Recipe Costing & Portion Standardization Spreadsheet

Purpose

This calculator template helps kitchens reliably answer: what does each plated item actually cost? It shows how to convert purchase units to recipe units, adjust for yield and prep loss, compute per-portion costs for batches or single-serve prep, and calculate contribution margin so you can set and protect menu prices.

When to use this

• Costing a new dish or updating menu prices
• Standardizing portions across shifts and locations
• Investigating unexplained margin erosion
• Comparing batch vs. made-to-order costs

Core fields (what you’ll enter)

1. Ingredient — ingredient name
2. Purchase unit & qty — e.g., 20 lb case
3. Purchase price — total cost of purchased unit
4. Purchase unit size (base unit) — convert to a consistent unit (grams, ounces, pounds, liters)
5. Recipe usage — amount used in the recipe (same unit as base unit)
6. Ingredient yield % — edible percentage after trim/peel/trim loss (0–100)
7. Prep loss % — additional loss during prep/cooking (optional)
8. Number of portions per batch — if batch-made
9. Target portion weight — weight or size served per portion

Key calculations & example formulas (spreadsheet-ready)

Below are recommended column names and example formulas you can paste into a spreadsheet. Assume consistent base units (e.g., grams).

Columns

Ingredient | PurchaseQty | PurchaseUnitSize | PurchasePrice | CostPerBaseUnit | RecipeUsage | YieldPct | PrepLossPct | EdibleUsage | AdjustedUsageCost | PortionsPerBatch | CostPerPortion

Formulas (Excel/Sheets style)

• CostPerBaseUnit = PurchasePrice / PurchaseUnitSize
    Example: = D2 / C2
• EdibleUsage = RecipeUsage * (YieldPct / 100)
    Example: = F2 * (G2 / 100)
• FinalUsableQty = EdibleUsage * (1 - PrepLossPct / 100) (if you track prep loss separately)
• AdjustedUsageCost = FinalUsableQty * CostPerBaseUnit
    Example: = H2 * E2
• CostPerPortion (ingredient) = AdjustedUsageCost / PortionsPerBatch
    Example: = I2 / J2

Batch vs. Single-Serve

If you make a batch, sum all ingredient adjusted costs for the batch and divide by PortionsPerBatch. For single-serve (made-to-order), compute each ingredient's per-portion cost directly from the recipe usage.

Plate cost and contribution margin

Plate Cost = SUM(all ingredient CostPerPortion) + garnish/packaging cost + allocated labor & overhead per portion.

Contribution Margin = Menu Price - Plate Cost

Contribution Margin % = Contribution Margin / Menu Price

Practical example (single ingredient)

Purchase: 25 lb bag of flour @ $20. Convert to grams: 25 lb = 11340 g. CostPerGram = 20 / 11340 = $0.001764. Recipe uses 300 g; yield 100% for dry goods; prep loss 0%. Ingredient cost per portion = 300 * 0.001764 = $0.53.

Ready-to-copy CSV header

You can copy this header row into a new sheet and paste it as CSV headers:

Ingredient,PurchaseQty,PurchaseUnitSize,PurchasePrice,PurchaseUnit,CostPerBaseUnit,RecipeUsage,RecipeUnit,YieldPct,PrepLossPct,FinalUsableQty,AdjustedUsageCost,PortionsPerBatch,CostPerPortion,Notes

Portion control checks

• Weigh finished portions for 5 random plates each shift and record variance vs. target portion weight.
• Flag items where average portion weight deviates >+/-10% — investigate for ingredient creep or staff technique issues.
• Include a simple checklist on the line cook station: weigh, photograph (optional), sign-off.

Version control & change tracking

Keep a locked header with: Recipe Name | Version | Effective Date | Author | Change Notes. When a recipe or price changes, create a new version row so you can compare past margins and trace when costs shifted. Store previous versions in a VersionHistory tab or use file versioning.

Common pitfalls and how to avoid them

• Not converting units consistently — choose grams or ounces and stick with them.
• Forgetting yield loss — trim, peel, bones, and shrink during cooking matter.
• Hidden garnish or condiment costs — small items add up across many plates.
• Labor and overhead omission — allocate labor minutes and overhead at a sensible rate per portion.
• Ingredient creep — train staff to follow portioning tools (portion scoops, scales) and audit regularly.

How to test your costing

1. Pick 3 menu items: high-volume, high-margin, low-margin.
2. Complete full ingredient costing and calculate contribution margins using current menu prices.
3. Measure actual portions for a week and compare theoretical ingredient usage to real usage (waste & variance).
4. Identify where practice diverges from recipe and prioritize fixes (training, tooling, recipe simplification).

Quick tips

• Use scales, not visual cues, for portions.
• Include a small buffer for unavoidable shrinkage in high-risk proteins.
• Review supplier prices monthly and update PurchasePrice fields promptly.
• Keep a short notes column for supplier, brand, or seasonal substitutions that change cost or yield.

Next improvements (optional)

Consider linking this spreadsheet to POS sales to compute gross food cost by item, or to inventory purchase data for automated price updates.