How to Calculate Food Cost Per Portion for a Catering Menu
You know what a case of chicken thighs costs. What you need for a quote is what one portion of the finished dish costs, with the oil, the lemons, the herbs and the trim included. Without that number, every menu price is an educated guess, and every supplier price change silently eats margin until you notice months later.
This guide walks through the calculation step by step on a real recipe, gives you the exact formulas to use in Excel or Google Sheets, and shows how one price change ripples through the dish.
Prices below are fictional examples. Use your own supplier invoices.
The five numbers you need
- Unit cost of each ingredient = pack price ÷ pack size
- Line cost = unit cost × quantity used in the batch
- Batch cost = sum of all line costs
- Cost per portion = batch cost ÷ portions the batch yields
- True cost per portion = cost per portion × (1 + waste %)
Then, optionally, a menu price = true cost per portion ÷ target food cost %.
Worked example: garlic herb chicken thighs, batch of 40
This dish sits on a corporate lunch menu. One batch yields 40 portions, with 8 oz of raw boneless thigh per portion.
Step 1 and 2: unit cost and line cost
| Ingredient | Pack price | Pack size | Unit cost | Qty in batch | Line cost |
|---|---|---|---|---|---|
| Boneless chicken thighs | $95.60 | 40 lb | $2.39 / lb | 20 lb | $47.80 |
| Olive oil | $27.00 | 3 L | $9.00 / L | 0.4 L | $3.60 |
| Lemons | $48.30 | 115 each | $0.42 each | 12 | $5.04 |
| Peeled garlic | $18.50 | 5 lb | $3.70 / lb | 0.5 lb | $1.85 |
| Fresh herbs | $1.75 | 1 bunch | $1.75 / bunch | 6 bunches | $10.50 |
| Salt, pepper, spices | $2.00 | per batch | $2.00 | 1 | $2.00 |
Step 3: batch cost = $47.80 + $3.60 + $5.04 + $1.85 + $10.50 + $2.00 = $70.79
Notice the herbs. They cost more than the oil, lemons and garlic combined, and they are exactly the kind of line people leave off a back-of-envelope cost.
The spice allowance matters too. Salt, pepper and dried spices are hard to measure per batch, so set a small flat allowance per recipe rather than ignoring them.
Step 4: cost per portion
$70.79 ÷ 40 portions = $1.77 per portion
Step 5: add waste
Trim, a tray that dries out, the portion that hits the floor. Assume 8% waste for this dish:
$1.77 × 1.08 = $1.91 true cost per portion
That 14 cents looks trivial. Across 300 portions a week it is $42 a week, and it compounds across every dish on the menu.
Optional: menu price from a target food cost
If this dish is sold on a per-item drop-off menu and your target food cost is 30%:
$1.91 ÷ 0.30 = $6.37, which you might round to $6.50.
For full-service events, do not stop here. A food-cost target only covers the food; labor, rentals and travel need their own lines. See our catering costing spreadsheet guide for how the dish costs feed a complete event quote priced on gross margin.
The ripple: what one price change does
Your supplier moves the 40 lb case of thighs from $95.60 to $105.00. The new chicken line is $105.00 ÷ 40 × 20 = $52.50, up $4.70.
- New batch cost: $75.49
- New true cost per portion: $75.49 ÷ 40 × 1.08 = $2.04
- Food cost on a $6.50 menu price moves from 29.4% to 31.4%
Two points of food cost on one dish, from one invoice. If that dish is in a quote you sent last month for an event next month, the margin on that event just dropped and nothing told you. This is why recipe costs should be linked to a single ingredients list, not typed in as fixed numbers.
Copy-ready formulas for Excel or Google Sheets
Ingredients tab (one row per ingredient you buy)
- A: Ingredient | B: Supplier | C: Pack price | D: Pack size | E: Unit
- F (unit cost):
=C2/D2
Recipe lines tab (one row per ingredient per dish)
- A: Dish | B: Ingredient | C: Qty per batch
- D (unit cost):
=XLOOKUP(B2, Ingredients!A:A, Ingredients!F:F)(orVLOOKUP(B2, Ingredients!A:F, 6, FALSE)in older Excel) - E (line cost):
=C2*D2
Menu items tab (one row per dish)
- A: Dish | B: Portions per batch | C: Waste %
- D (batch cost):
=SUMIF('Recipe lines'!A:A, A2, 'Recipe lines'!E:E) - E (cost per portion):
=D2/B2 - F (true cost per portion):
=E2*(1+C2) - G: Menu price
- H (food cost %):
=F2/G2 - I (flag):
=IF(H2>target, "OVER TARGET", "")
Update a pack price once on the Ingredients tab, and every dish, flag and quote that uses it recalculates.
Common costing mistakes
- Costing from the recipe card, not the purchase unit. If you buy by the case and the recipe says “2 lemons”, you need the unit cost of one lemon from the case price.
- Forgetting yield. A batch that “makes about 40” but actually serves 36 has an 11% higher cost per portion than you think. Count real portions a few times.
- One waste % for everything. Bone-in proteins and delicate greens lose more than rice. Set waste per dish.
- Stale prices. A cost sheet built in spring and quoted from in autumn is fiction.
Once each dish has a true cost, the next step is to add overage for the service style. Buffets need more food per guest than plated meals; see buffet vs plated vs family style catering cost per person for how much difference it makes.
The Catering & Private Chef Event Costing workbook is built exactly this way: an Ingredients tab with pack cost and pack size, Recipe Lines priced straight from it, and Menu Items returning batch cost, cost per portion, a waste-adjusted true cost, margin and food cost percentage for every dish, with allergens and dietary tags alongside.
Featured on ReadySheetGo
Catering & Private Chef Event Costing, Menu Pricing and Quote Builder — $18.99
Ingredients → recipes → menu items → quotes, all linked. Change one pack price and every dish cost, food cost percentage and event margin updates. Works in Excel and Google Sheets.
General information only, not business advice. Example figures are fictional.
Frequently Asked Questions
What is the formula for food cost per portion?
Cost per portion = batch cost ÷ portions the batch yields. Batch cost is the sum of each ingredient's unit cost times the quantity used, and unit cost is pack price ÷ pack size. Add a waste allowance on top to get the true cost per portion.
How do I set a menu price from food cost per portion?
Divide the true cost per portion by your target food cost percentage. A dish with a true cost of $1.91 at a 30% target food cost gives $1.91 ÷ 0.30 = $6.37. For staffed events, price the whole event on gross margin as well, because labor and rentals are not covered by a food-cost target.
What waste percentage should a caterer use?
There is no single right number; it depends on the dish, your trim and how accurately you portion. Start with an estimate per dish, then compare what you bought with what you served after a few events and adjust. Proteins with bones or heavy trim usually need a higher allowance than dry goods.
How often should I update ingredient prices?
Whenever a supplier invoice changes a price you use often, and at least before quoting a large event. If your spreadsheet prices recipes from a single ingredients list, one update flows through every dish that uses that ingredient.