Comprehensive Food Costing Excel Sheet
Budget: $10 – $30 USD
I'm looking for a skilled Excel expert who can help me create a comprehensive food costing spreadsheet. In particular, I would like the following sections:
- **Ingredients Cost**: where I can enter the prices of all the ingredients I use in my recipes.
- **Recipe Costing**: a section where I can input my recipes and the spreadsheet automatically calculates the total cost of each recipe based on the ingredients.
- **Menu Pricing**: a feature where I can input the recipes from my menu and the spreadsheet automatically calculates a profitable price based on the recipe costs.
- Inventory management:
- **Track Inventory Levels**: a feature that keeps an eye on my ingredient stock levels.
- **Predict Future Inventory Needs**: an analysis that could help me foresee when I'll need to restock certain items.
- **Update Costs Based on Supplier Prices**: a feature that lets me update the costs of ingredients based on the supplier prices, ensuring my calculations are always accurate.
The ideal candidate would have:
- Advanced Excel skills
- Experience in food costing or inventory management would be a plus.
- **Ingredients Cost**: where I can enter the prices of all the ingredients I use in my recipes.
- **Recipe Costing**: a section where I can input my recipes and the spreadsheet automatically calculates the total cost of each recipe based on the ingredients.
- **Menu Pricing**: a feature where I can input the recipes from my menu and the spreadsheet automatically calculates a profitable price based on the recipe costs.
- Inventory management:
- **Track Inventory Levels**: a feature that keeps an eye on my ingredient stock levels.
- **Predict Future Inventory Needs**: an analysis that could help me foresee when I'll need to restock certain items.
- **Update Costs Based on Supplier Prices**: a feature that lets me update the costs of ingredients based on the supplier prices, ensuring my calculations are always accurate.
The ideal candidate would have:
- Advanced Excel skills
- Experience in food costing or inventory management would be a plus.