Recipe Food Cost Calculator
Calculate the cost of each dish using your own ingredient prices. See your food cost percentage and check if your selling price meets your target.
Download
- File type
- XLSX
- Version
- v1.0
- Last updated
- 1 May 2026
- File size
- 163 KB
No account or email address required.
What this tool does
Before setting a menu price, you need to know how much the dish costs to make. This Excel calculator helps you work out the cost of each recipe. Enter the ingredients you use and how much they cost. The calculator works out the cost per portion and food cost percentage. You can also set your own food cost target and see which dishes are above it.
What’s included
- Excel calculator with 30 recipe cards
- Ingredient list with purchase prices and yield calculations
- 10 sections for costing homemade components
- Automatic cost per portion and food cost percentage
- Suggested selling price based on your target
- Summary of all 30 recipes on one sheet
- Currency and VAT settings
- Margherita Pizza example to help you get started
How to use it
Step 1. Open Start Here and set your currency. Enter your VAT rate and food cost target.
Step 2. Go to Ingredients. Enter the items you buy and the prices you pay.
Step 3. Use Components if you make something in batches, like a sauce. You can skip this if you don't need it
Step 4. Open a Recipe sheet. Choose your ingredients and enter how much you use. Add your menu price.
Step 5. Check the Summary sheet to see which recipes are above your food cost target.