Recipe Costing Excel Workbook

I own restaurants and I’m trying to create a Recipe Costing work book.

First we need to create a list of all our ingredients and cost every item to

1- Ml (liquids)
Ml comes from
- Litre’s
- Gallon’s
- Fluid Ounces
- Pint
- Quart


2- Grams (no liquids)
Grams comes from
-Kilo
-Grams
-Pounds
-Ounces

3- Each (items we buy like Lemons, Avocados etc)
Each’s comes from
-Boxes
-Bags
-Cases
-Dozen



Column A (Product)
- User Enters Text

Column B (Category)
- Drop Down (we need to be able to edit the dropdown)

Column C (Company)
- Dropdown to come by column A on ‘Companies’ tab sheet

Column D&E - H&I - L&M
- These will be a mix of dropdown and auto populated cells, we will need to discuss this

Column P (loss & Waste)
- This needs to be a dropdown. With 5%, 10%, 15% jumping up in 5% to 80%
- The default will be 5%


I think to create this will not be to hard and will take 2hrs but we may need to chat whilst you doing it.

So I can give you calculations so theres not issues