Recipe Costing Master Template

Recipe Costing Master Template

Purpose: Make every dish traceable to a reliable per-plate cost so menu decisions, pricing, and margin management are based on facts, not guesswork. This template explains the fields you need, shows worked examples, and gives practical steps for batch updates and sensitivity checks.

When to use this

Use the template when you create or change a recipe, price a menu item, investigate food cost variance, or when supplier prices change. Keep one card per menu item (or per recipe batch) and update prices on a regular cadence.

Recipe card — core fields

Record the following on every recipe card. Use consistent units for each ingredient (g, kg, oz, lb, L, each) and document unit conversions when needed.

Step-by-step calculation (worked example)

Example: Simple Caesar salad, batch produces 10 portions.

1. Record ingredients and purchase costs (example numbers):
   • Romaine: purchase unit 10 lb bag, cost $8.00 per bag, usage per batch 3 lb
   • Parmesan: purchase unit 1 lb, cost $6.00, usage per batch 0.5 lb
   • Dressing (bottled oil + anchovy mix): purchase unit 1 L bottle $10, usage per batch 0.25 L
   • Croutons: package 2 lb $4, usage per batch 0.5 lb
2. Convert usage to purchase-unit cost base and compute cost used per batch.
   • Romaine cost used = (3 lb / 10 lb) * $8.00 = $2.40
   • Parmesan = (0.5 lb / 1 lb) * $6.00 = $3.00
   • Dressing = (0.25 L / 1 L) * $10.00 = $2.50
   • Croutons = (0.5 lb / 2 lb) * $4.00 = $1.00
3. Sum batch ingredient cost = $2.40 + $3.00 + $2.50 + $1.00 = $8.90
4. Account for cooking/prep loss or yield adjustments if applicable. If prep loss reduces yield by 10% apply: adjusted batch cost per usable portion = batch cost / (usable portions). For this example assume negligible loss so usable portions = 10.
5. Per-plate food cost = $8.90 / 10 = $0.89
6. If menu price = $9.00 then contribution margin per plate = $9.00 - $0.89 = $8.11 (margin % = 90.1%).

Formulas (for spreadsheets)

1. Ingredient cost used = (Usage quantity / Purchase unit quantity) * Purchase unit cost
2. Batch cost = SUM(ingredient cost used for all ingredients)
3. Effective usable yield = Batch yield * (1 - CookingLoss%) * (1 - TrimLoss% as needed)
4. Per-portion cost = Batch cost / Number of usable portions
5. Contribution margin ($) = Menu price - Per-portion cost
6. Contribution margin (%) = Contribution margin ($) / Menu price

Sensitivity checks (quick tests to find risk)

Use these to see which ingredients or suppliers most affect cost:

• Change a single ingredient price by +10% and recompute per-plate cost to find per-plate and percentage change.
• Calculate cost share = (ingredient cost used / batch cost) to see which items dominate food cost.
• Run a small table: current price, +10%, +20%, then note per-plate and margin at each level to decide hedging, substitution, or price adjustment.

Batch scaling and portion locking

When scaling a recipe to different batch sizes:

1. Scale all usage quantities proportionally to desired batch. Keep portion size constant, scale number of portions.
2. Recompute rounding: account for purchase-pack constraints (you may need to round up to whole packs when ordering).
3. Lock portion sizes in prep charts and training guides. Use photo references and portion tools (scoops, ladles, scale) to reduce variance.

Keeping prices current — batch update method

Maintain a separate price list (SKU → purchase unit cost, vendor, last-updated date). When supplier invoices change:

1. Update the price list first.
2. Re-run recipe cost reports by linking recipe ingredient SKUs to the price list and computing new per-plate costs.
3. Flag recipes where food cost % moved beyond tolerance (for example, > ±5% of target food cost or where contribution margin falls below threshold).
4. For multi-location groups, publish a price-change summary with recommended actions: renegotiate, substitute, reformulate, or repricing suggestions.

Common mistakes to avoid

• Mismatched units — always convert to a consistent unit system before computing.
• Forgetting yield and trim losses — raw to usable conversion can materially change cost per portion.
• Using average purchase price while inventory includes older cheaper stock — use current invoice or weighted average defined by your accounting practice.
• Ignoring portion variance — train teams and audit portions frequently to match recipe assumptions.

Practical next steps

1. Create one completed recipe card for your signature dish following this template. Include SKU references for each ingredient.
2. Run sensitivity checks on the top three cost drivers for that dish and decide one immediate action (substitute, hedge, negotiate, or reprice).
3. Standardize portion controls with a short checklist and a one-week audit to measure actual portion variance vs. recipe standard.

CSV header example for spreadsheet import

RecipeName,Version,BatchYield,Portions,IngredientSKU,IngredientName,PurchaseUnit,PurchaseUnitQty,PurchaseUnitCost,UsagePerBatch,ConversionFactor,YieldAdjustmentPct,CookingLossPct,Vendor

Why this matters

Accurate recipe costing exposes hidden margin leaks, makes menu pricing defensible, helps you decide where to improve recipes or change suppliers, and creates a foundation for forecasting and inventory planning.

Optional: move this template to an interactive calculator

This HTML recipe card gives a clear, audit-ready structure. If you want saved calculations, repeated entries, or centralized price lists across locations, consider converting the template to an interactive form that links SKUs to a shared price table and stores submissions for tracking historical cost changes. See the capability notes below for ideas.