Recipe costing standard work + lightweight calculator

Why this matters (the hunger)

When every dish has a reliable cost and predictable portioning, you can price confidently, protect margins, and keep quality consistent across shifts and locations. Hidden trim loss, ambiguous portions, and inconsistent unit conversions quietly erode profits. This guide gives focused standard work you can implement in a few shifts plus a simple calculator structure you can copy into a spreadsheet or turn into an interactive form.

What you'll get

• A clear step-by-step costing method you can apply to any recipe.
• Spreadsheet-ready calculator layout and explained formulas.
• Practical portion-control and plating-weight tactics to stop ingredient creep.
• A change-control log for recipe updates and versioning.
• KPIs, common mistakes, and a short implementation checklist.

Core concepts (brief)

• Purchase unit: the unit you buy (e.g., 10 lb bag of potatoes).
• Recipe yield factor: the usable amount after trim/loss (expressed as a decimal, e.g., 0.85).
• Portion size (g or oz): the plated weight or number of pieces per guest.
• Per-portion cost: the direct ingredient cost for a single plated portion.
• Contribution margin: price minus per-portion cost (or price minus cost %).

Step-by-step recipe costing standard work

1. Record the recipe yield and portioning.

   Weigh the finished batch (after trim and cooking if relevant). Record total usable yield (in grams or ounces) and planned number of portions. From these derive the plated portion weight: plated portion = usable yield / number of portions.

2. List every ingredient with purchase unit and unit cost.

   For each ingredient, capture: supplier pack size (e.g., 10 lb), purchase price for that pack, purchase unit (lb, kg, each), and the recipe amount used in recipe units (e.g., 2.5 lb, 300 g, 2 each).

3. Apply trim loss and yield factors.

   For ingredients with trim (meat, vegetables, shells), record the yield factor (usable / purchased). Example: a 10 lb whole chicken yields 6.5 lb cooked/usable — yield factor = 0.65. Adjust the amount used in the recipe by dividing by the yield factor when computing cost from purchase price.

4. Convert units consistently.

   Ensure ingredient quantities and purchase units match. Convert lbs ↔ kg or grams as needed. Use the same base unit (grams or ounces) for the calculator to avoid errors.

5. Compute per-portion ingredient cost.

   Formula (word form): Per-portion cost for ingredient = (purchase price / purchase quantity) × (recipe quantity ÷ number of portions) ÷ yield factor (if applicable).

   Example: Purchase: 10 lb potatoes @ $12.00 → $1.20/lb. Recipe uses 3 lb for a batch that yields 20 portions after cooking. Per-portion cost = ($1.20 × 3 lb) / 20 = $0.18 per portion.

6. Sum ingredient costs and compute item contribution margin.

   Add all per-portion ingredient costs to get the total food cost per portion. Then compute margin metrics:

   • Item food cost % = (food cost per portion ÷ menu price) × 100
   • Contribution margin = menu price − food cost per portion
7. Account for common overhead allocation (optional).

   If you want item-level contribution that reflects labor or overhead, add a per-portion overhead allocation (e.g., $0.30 per portion for plating and cook time). Be explicit about which overheads you include.

Spreadsheet-ready calculator layout (copy into a sheet)

Create a sheet with these columns for each ingredient row:

• Ingredient
• Purchase Unit (e.g., lb, kg, each)
• Purchase Quantity (numeric, e.g., 10)
• Purchase Price (total for that pack)
• Unit Cost = Purchase Price / Purchase Quantity
• Recipe Qty (in same unit as purchase unit or converted)
• Yield Factor (decimal, default 1.0)
• Amount from Purchase = Recipe Qty / Yield Factor
• Cost for Recipe Qty = Unit Cost × Amount from Purchase
• Portions per Batch (sheet-level cell)
• Per-portion Cost = Cost for Recipe Qty / Portions per Batch

Then a small summary area with:

• Total food cost per portion = SUM(per-portion Cost column)
• Menu price (input)
• Food cost % = Total food cost per portion / Menu price
• Contribution margin = Menu price − Total food cost per portion

Worked numeric example

Recipe batch yields 20 portions.

• Ingredient A: 10 lb pack @ $12 → unit cost $1.20/lb. Recipe uses 3 lb. No trim loss. Cost = 1.20 × 3 = $3.60 → Per-portion = 3.60 / 20 = $0.18.
• Ingredient B (trimmed): 20 lb pork @ $40 → $2.00/lb. Recipe uses 5 lb raw, yield factor 0.80. Amount from purchase = 5 / 0.8 = 6.25 lb. Cost for recipe qty = 6.25 × $2.00 = $12.50 → Per-portion = 12.50 / 20 = $0.625.

Total food cost per portion (sum) = $0.18 + $0.625 + ... = e.g., $3.00. If menu price = $12.00 → food cost % = 25%; contribution margin = $9.00.

Visual portion guides and plating weight targets

1. Weigh a serving from several cooks across three shifts to establish a target plated weight (g or oz).
2. Create a visual reference card: photo of plated item with a scale showing weight and simple instructions (e.g., scoop size, number of pieces, garnish weight).
3. Post the photo and weight at plating stations and include it in the recipe card. Use a 1–2 oz tolerance band to reduce policing friction but stay tight enough for cost control.
4. Run quick portion audits weekly: random check 10 servings per week, record deviations and follow up with coaching when variance exceeds tolerance.

Change-control log (template fields)

Keep a simple log (spreadsheet or form) with these columns:

• Recipe ID / Name
• Version Date
• Change Summary (ingredient, portion, process)
• Author / Approver
• Reason (cost, supplier change, quality)
• Effective Date
• Notes (testing results, photos)

KPIs and monitoring

• Food cost % by item and by category (weekly)
• Recipe variance (planned portion weight vs actual average)
• Ingredient usage variance (purchases vs expected by sales mix)
• Remake rate and portion-related complaints

Common mistakes and quick fixes

• Mixing units: standardize to grams/ounces in the sheet and convert once at input.
• Ignoring yield: record real trim/cooking yields rather than guessing.
• Undocumented recipe changes: use the change-control log and require approver sign-off for cost-impacting changes.
• No training on portions: use visual guides and lightweight audits, not only memos.

Implementation checklist (first 30 days)

1. Select 6–12 high-volume or high-cost menu items to cost first (covers most waste and margin impact).
2. Run yield tests and establish plated weights for each selected item.
3. Build the spreadsheet calculator and populate with supplier prices.
4. Publish visual portion guides at plating stations and train staff on the targets.
5. Start weekly portion audits and log changes in the change-control sheet.
6. Review results after 30 days and adjust portions, prices, or processes as needed.

Next steps and scaling

Once you have stable recipes and validated costs, consider:

• Converting the sheet into an interactive form so cooks and managers can view live costs and save recipe versions.
• Mapping recipe ingredient SKUs to your inventory system/POS so usage data can validate expected vs actual consumption.
• Bundling high-impact recipes into a standard-recipe toolkit for multi-location roll-out.

Frequently asked questions

Q: How often should I update purchase prices?
A: Update prices at least monthly for volatile items; more often for proteins and seasonal produce.

Q: Should I include condiments and garnish in cost?
A: Include any ingredient that meaningfully affects cost or guest experience. Small garnish costs can be rolled into a category-level overhead if tracking them individually adds too much friction.

Resources and template files

Use the spreadsheet layout above to create a simple sheet. Label the sheet 'Recipe Cost Calculator' and include a 'Recipe Header' area (recipe name, portions per batch, menu price) and an 'Ingredient Table' as described. Save templates as read-only master copies and create editable copies for each recipe.

Image search phrase: chef recipe costing spreadsheet