Home / Guides / Recipe cost spreadsheet
Menu Decision Kit · free guide
How to set up a recipe cost calculator spreadsheet
A recipe cost sheet answers one question: what does one portion cost to make? Food trucks, home bakers, caterers, and small restaurants all need the same three pieces: what you pay for each ingredient, how much of it is actually usable, and how much the recipe uses. This page shows the columns and formulas. It is planning arithmetic from figures you type, not accounting, tax, nutrition, food-safety, or business advice.
Sheet 1: ingredients (one row per thing you buy)
| Column | What goes in it |
|---|---|
| Ingredient | Name as you buy it, e.g. “Yellow onions, 10 lb bag”. |
| Pack price | What you paid for the pack, e.g. $8.50. |
| Pack size and unit | 10 and lb (or g, oz, each). Pick one base unit per ingredient and stick to it. |
| Yield % | The usable share after peeling, trimming, or cooking loss. You measure this yourself: weigh before and after. |
| Cost per usable unit | = pack price ÷ pack size ÷ yield. Example: 8.50 ÷ 10 ÷ 0.90 = $0.944 per usable lb. |
Sheet 2: one recipe
- List each ingredient the recipe uses and the quantity in the same base unit as Sheet 1.
- Line cost
= quantity × cost per usable unit(look it up from Sheet 1 with XLOOKUP or VLOOKUP so a price change flows through). - Batch cost = sum of line costs. Add a line for things you do not want to measure per gram, such as oil, salt, and spices, as a small fixed amount you choose.
- Portion cost
= batch cost ÷ portions per batch. - Food-cost % at your menu price
= portion cost ÷ menu price.
Worked example (fictional numbers)
A batch of 12 portions uses 3 usable lb of onions at $0.944 ($2.83), 4 lb of beef at $5.40 ($21.60), 1.5 lb of cheese at $4.20 ($6.30), 12 buns at $0.35 ($4.20), and a $1.50 allowance for oil and seasoning. Batch cost = $36.43. Portion cost = 36.43 ÷ 12 = $3.04. At a $12.00 menu price, food cost = 3.04 ÷ 12.00 = 25.3%.
Where a single sheet starts to hurt
One recipe per sheet is fine until the same ingredient sits in ten recipes and its price changes. Then you are re-typing prices and hoping you caught every copy. The fix is one shared ingredient list that every recipe reads from, so one price edit updates every plate.
Try it without building anything
The free one-recipe plate cost calculator does the per-recipe arithmetic above in your browser, offline, with no email required (overview on the calculator page). The paid Menu Decision Kit ($29) keeps one ingredient list for a whole menu, costs recipes after usable yield, shows a price-change ripple across recipes, and includes a companion workbook. It was local-tested; there are no customer results yet. Related: food-cost percent and menu pricing.
No Buy button? Checkout is switched off right now, or JavaScript is blocked in this browser. The product page has the details.
More guides: the guides hub. All products: Tallyfox hub. Privacy: site privacy notice.