by TareKit Editorial TeamFood costing · 8 min read
Free Recipe Costing Spreadsheet: A Worked Example and How to Use It
Build a recipe costing spreadsheet from purchase prices and quantities used, with packaging, labor, overhead and a price-update check.
In this article
A recipe costing spreadsheet answers one practical question: how much does one portion cost to make?
Start with what you paid for each purchase pack, then calculate the cost of the quantity used in your recipe. Add the costs you want to track, divide by the portions you can sell, and compare the result with your selling price.
The example below shows the calculations for ten chicken rice bowls. Replace the sample figures with your own receipts, recipe quantities and operating assumptions.
What to put in your recipe costing sheet
Use one row per ingredient and keep these six columns:
| Ingredient | Pack quantity | Unit | Pack price | Quantity used | Cost used |
|---|---|---|---|---|---|
| Rice, dry | 1,000 | g | $4.00 | 500 | $2.00 |
| Chicken, usable meat | 1,000 | g | $24.00 | 500 | $12.00 |
| Cooking oil | 1,000 | ml | $10.00 | 100 | $1.00 |
| Ready-made sauce | 1,000 | g | $20.00 | 200 | $4.00 |
| Prepared vegetables | 1,000 | g | $8.00 | 250 | $2.00 |
| Total ingredient cost | $21.00 |
This simplified example assumes the chicken and vegetables are bought ready to use, with no preparation loss. The oil quantity is the amount consumed by this batch.
For each ingredient:
Cost used
Cost used = Pack price ÷ Pack quantity × Quantity used
Chicken: $24.00 ÷ 1,000 g × 500 g = $12.00
The chicken costs $24 for 1,000 g. Using 500 g costs $12. The unused half of the purchase pack stays out of this batch's recipe cost.
If columns A–F follow the table above and your first ingredient is in row 2, the Excel or Google Sheets formula in F2 is:
Excel / Google Sheets
=D2/B2*E2
Copy it down the ingredient rows, then total them.
The formula assumes the purchase and recipe quantities use the same unit. Convert 1 kg to 1,000 g before entering it; do not divide a price per kilogram by a quantity in grams without conversion.
For ingredients that lose weight during preparation, use a consistent edible-yield calculation. Do not apply the same loss twice. Our AP vs. EP yield guide explains that step separately.
Add packaging, labor and overhead separately
Ingredient cost alone is useful, but it does not show the full cost of preparing a takeaway order. Keep the additional assumptions visible:
| Cost for this batch | Amount |
|---|---|
| Ingredients | $21.00 |
| Packaging: 10 sets at $0.50 | $5.00 |
| Direct labor allocated to the batch | $15.00 |
| Overhead allocated to the batch | $5.00 |
| Total modeled batch cost | $46.00 |
| Sellable portions | 10 |
| Modeled cost per portion | $4.60 |
This gives two useful figures: $2.10 in ingredients per portion, and $4.60 per portion after the listed additional costs. Label them separately so you know which figure you are comparing with the selling price.
Labor should reflect the time and rate you choose to allocate. Overhead might include a share of kitchen utilities or rent. Use a documented allocation method, and avoid counting the same expense here and again elsewhere in the calculation.
Compare the cost with your selling price
At a selling price of $8.00, this example leaves:
Cash left after the listed costs
$8.00 − $4.60 = $3.40 per portion
Payment fees, delivery commissions, discounts and taxes are not included.
That $3.40 is not a statement of net profit. Payment fees, delivery commissions, discounts, taxes where applicable, and other expenses are not included in this example.
Keep the costing basis consistent. A food-cost percentage based on ingredients answers a different question from a margin calculated after labor and allocated overhead. Use the menu-pricing guide for the difference between markup and margin.
Check the sheet when ingredient prices change
Suppose the chicken pack rises from $24.00 to $28.80. The 500 g used now costs $14.40, adding $2.40 to the batch. With all other assumptions unchanged, modeled cost per portion rises from $4.60 to $4.84.
Updated chicken cost
$28.80 ÷ 1,000 g × 500 g = $14.40
New batch cost: $46.00 + $2.40 = $48.40; per portion: $4.84.
Each time you review the sheet:
Check the purchase price and pack size
Match them against the latest relevant receipt, not a price you remember.
Record the price date
Old assumptions are easier to spot when each price carries the date you checked it.
Update every recipe using that ingredient
If your workbook keeps a shared ingredient record, update it once and recalculate the linked recipes.
Check actual portions, packaging and labor assumptions
A batch that yields fewer sellable portions raises the cost per portion even when prices hold.
Recalculate before changing the selling price
Decide from the updated cost, not from the price list you used last month.
Excel and Google Sheets can recalculate linked recipes. The upkeep depends on how you build and maintain the workbook.
Start with one real recipe
A spreadsheet can be enough when your recipe list is small and you keep its inputs current. Cost one regular menu item before building a larger system.
Prefer to calculate in your browser? Use the free food-cost calculator. If you want to organize multiple recipes and their costs in TareKit, start a free account.