Recipe Cost & Contribution Margin Calculator (editable)

Welcome — what this calculator does

This resource helps managers, chefs, and operators determine exactly what a plated item costs and how price changes, yield losses, labor, and overhead affect margins. It describes the fields you'll use, shows formulas you can paste into a spreadsheet, and walks through a worked example plus 'what-if' scenarios you can test.

Quick overview

Core outputs you'll get by following the worksheet below:

• Per-portion cost (after yield, labor, and overhead)
• Ideal food cost percentage for a target price
• Contribution margin (dollars and percent) at any proposed selling price
• A simple approach to run 'what-if' scenarios when ingredient prices or yields change

Field definitions (use these headings in your sheet)

1. Ingredient — name of ingredient (e.g., Chicken Breast)
2. Unit Cost — cost for the purchase unit (e.g., $3.50 per lb, $0.80 per egg)
3. Purchase Unit — the quantity that price refers to (note for reference only)
4. Amount Used — quantity used in recipe (use same unit as purchase unit when possible)
5. Yield % — edible yield (after trimming, cooking loss) expressed as a percent (enter 100 for no yield loss)
6. Ingredient Cost (raw) — Unit Cost × Amount Used
7. Ingredient Cost (adjusted) — Ingredient Cost (raw) / (Yield% ÷ 100). Use when yield < 100%
8. Sum of Adjusted Ingredient Costs — total of adjusted ingredient costs for the full recipe
9. Prep Labor Minutes — minutes of direct labor to prepare the recipe
10. Labor $/hour — average wage (including payroll burden if desired)
11. Labor Cost (recipe) — (Prep Labor Minutes ÷ 60) × Labor $/hour
12. Overhead Allocation — either a fixed $ amount per recipe or a percent applied to ingredient+labor costs (choose one method and document it)
13. Total Recipe Cost — Sum of adjusted ingredient costs + Labor Cost + Overhead Allocation
14. Portions per Recipe — how many portions the recipe yields
15. Per-Portion Cost — Total Recipe Cost ÷ Portions per Recipe
16. Selling Price — planned menu price per portion
17. Contribution Margin ($) — Selling Price − Per-Portion Cost
18. Contribution Margin % — (Contribution Margin ÷ Selling Price) × 100
19. Food Cost % (actual) — (Per-Portion Cost ÷ Selling Price) × 100

Formulas you can paste into a spreadsheet

Assume columns: A=Ingredient, B=UnitCost, C=AmountUsed, D=YieldPct

• Ingredient Cost (raw) = B2 * C2
• Ingredient Cost (adjusted) = (B2 * C2) / (D2 / 100)
• Sum of Adjusted Ingredient Costs (for recipe) = SUM(adjusted column)
• Labor Cost (recipe) = (PrepLaborMinutes / 60) * LaborRate
• Overhead Allocation = either fixed number or (SumIngredients + LaborCost) * OverheadPercent
• Total Recipe Cost = SumAdjustedIngredients + LaborCost + OverheadAllocation
• Per-Portion Cost = TotalRecipeCost / Portions
• Contribution $ = SellingPrice - PerPortionCost
• Contribution % = (Contribution$ / SellingPrice) * 100
• Food Cost % = (PerPortionCost / SellingPrice) * 100

Worked example

Use this to validate your sheet. Numbers are illustrative.

• Ingredients (adjusted total): $12.00
• Prep Labor: 30 minutes at $18/hour → Labor Cost = (30 ÷ 60) × 18 = $9.00
• Overhead: 10% of (ingredients + labor) = 0.10 × ($12 + $9) = $2.10
• Total Recipe Cost = 12 + 9 + 2.10 = $23.10
• Portions per Recipe = 6 → Per-Portion Cost = 23.10 ÷ 6 = $3.85
• Selling Price = $12.00 → Contribution Margin $ = 12 − 3.85 = $8.15
• Contribution Margin % = (8.15 ÷ 12) × 100 ≈ 67.9%
• Food Cost % = (3.85 ÷ 12) × 100 ≈ 32.1%

Using the 'what-if' area

To test ingredient price shifts or yield changes:

1. Change the Unit Cost of the ingredient(s) you want to test and observe the change in Per-Portion Cost.
2. Test a yield change by reducing the Yield % on that ingredient and observe the adjusted ingredient cost.
3. Try raising selling price, and watch how food cost% and contribution margin change.

Common mistakes & how to avoid them

• Mixing units: keep purchase unit and amount used in the same units. Convert before calculating.
• Forgetting yield: if you trim or lose weight in prep/cooking, always adjust ingredient costs with yield%.
• Not including payroll burden: consider adding taxes and benefits into Labor $/hr when you want full-cost visibility.
• Double-counting overhead: pick either a % approach or an allocated $ per recipe and be consistent across menu items.
• Using average prices during volatile supply: snapshot price is fine for immediate decisions—run weekly checks for items with large price swings.

Ready-to-copy template layout (paste into a spreadsheet)

Column headings to paste into row 1 of a new sheet:

Below the ingredient table include cells for:

How to adapt this for multi-location groups

Keep a central master recipe (with standard yields) and let each location copy it into a local sheet. Track actual purchase unit costs by location and run a monthly reconciliation to identify locations with higher costs or yield losses.

Next steps & extensions

• Create a master menu dashboard that pulls per-portion costs across items and shows top contributors to food cost and top margin items.
• Track ingredient price changes over time to identify menu items sensitive to volatility and plan substitutions or price updates.
• Consider adding allergen and nutrition columns if menu labeling requires it.

Capability enhancement suggestions

This static calculator is useful as a template and guide. The platform can make it more powerful by:

• Rendering an InteractiveForm version where users enter ingredient rows and site-specific prices and save results for later comparison.
• Enabling data submissions so locations can submit their recipe-cost snapshots, supporting analytics that show where margins are drifting.
• Providing an integrated downloadable spreadsheet (Excel/Google Sheets) copy pre-filled with formulas.

Where this helps most

This resource is targeted to operations, kitchen leads and managers who need a reliable, repeatable way to: price menu items, analyze margin sensitivity, and test ingredient or yield changes without complex accounting systems.

Tip: Preserve a copy labeled with the date whenever you update ingredient prices so you can compare trends across weeks or months.