Free download · no signup
Free Food Cost Spreadsheet
An Excel template that costs any dish from its ingredients and tracks food cost and margin across your whole menu. Live formulas, a worked example to overwrite, and nothing to sign up for.
What’s inside
Two sheets that do the maths.
Recipe Costing
List a dish’s ingredients, quantities and unit costs. It totals the recipe, works out cost per portion, your food-cost % and margin, and the price to hit a target food cost.
Menu Tracker
Drop in every dish with its plate cost and menu price. See food-cost %, gross profit and margin per dish, a healthy/high/low flag, and your average food cost across the menu.
Edit the blue cells — everything in grey calculates itself.
Tired of re-costing recipes by hand every time a price changes?
Dash Dinner keeps recipe costs live from your real ingredient prices and flags margins as they move.
Questions
About the template.
What is in the food cost spreadsheet?+
Two sheets: a Recipe Costing sheet that totals a dish from its ingredients and gives you the food-cost %, margin and a target price; and a Menu Tracker that lists every dish with its plate cost, price, food-cost %, margin and a healthy/high/low flag.
Does the template do the maths for me?+
Yes. The grey cells are live formulas — enter your ingredients, quantities and prices in the blue cells and the costs, percentages and margins calculate automatically. It comes with one worked example you can overwrite.
What do I need to open it?+
Any spreadsheet app — Microsoft Excel, Google Sheets, Apple Numbers or LibreOffice Calc. It is a standard .xlsx file, free to download with no signup.