All,
I'm very passionate about creating Lemoncello in different recipe's. I've started to keep track in a basic excel file.
Now I'd like to make sort of an automated file, but I only know the very very basic excel functions and formulas.
I'm currently creating a masterdata sheet at the file, where I'll insert the ingredients their cost per kg or liter etc.
The goal is to create multiple sheets, like recipe sheet, cost / sales sheet, expenses sheet and the silver lining would be a sheet with graphs on production and sales.
In the recipe sheet, I want to be able to have drop down menu's where I can choose the ingredients then in a next column set the used quantity etc, based on those it then should project the expected quantity of the batch an provide the production cost in another sheet.
All tips and help would be very welcome.
Bookmarks