Dash Dinner/Tools/Food Cost Spreadsheet

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.

Download the Excel template.xlsx · opens in Excel, Google Sheets, Numbers or LibreOffice

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.