Restaurant menu costing: working out food cost % per dish and across the menu

Menu costing is five calculations in a fixed order: the cost of one usable unit of each ingredient, the cost of one portion, the food cost % of each dish, the contribution margin of each dish, and one food cost % for the whole menu weighted by what you actually sell. This article walks through each step with a small invented cafe, so every figure can be rechecked with a calculator.

All names, prices and quantities below are made up for the example. They are not benchmarks and they are not a forecast.

Step 1: ingredient unit cost, with yield

You pay for what you buy, but you cost what you can serve. Trim, peel, bone and cooking loss mean the usable part of an ingredient is smaller than the pack. The usable share (also called yield) is the fraction left after that loss.

Cost per usable unit = purchase price / (units per purchase x usable share)

The cafe buys these:

IngredientPack priceUnits per packUsable shareCost per usable unit
Chicken thigh$62.0010 kg80%62 / (10 x 0.80) = $7.75 per kg
Salmon fillet$110.005 kg88%110 / (5 x 0.88) = $25.00 per kg
Rice$9.005 kg100%9 / 5 = $1.80 per kg
Broccoli$12.505 kg80%12.5 / (5 x 0.80) = $3.125 per kg
Tomatoes$18.0012 kg100%18 / 12 = $1.50 per kg
Onion$13.5010 kg90%13.5 / (10 x 0.90) = $1.50 per kg
Cream$9.002 l100%9 / 2 = $4.50 per l

Leaving out the usable share understates the cost of a dish. Without it the chicken would cost $6.20 per kg instead of $7.75.

Step 2: cost per portion

Multiply each recipe line's quantity by that ingredient's cost per usable unit, add the lines, and divide by the number of portions the recipe makes.

Chicken rice bowl, one portion: 0.30 kg chicken x 7.75 = 2.325, 0.20 kg rice x 1.80 = 0.36, 0.12 kg broccoli x 3.125 = 0.375. Total $3.06.

Salmon plate, one portion: 0.18 kg salmon x 25.00 = 4.50, 0.15 kg rice x 1.80 = 0.27, 0.12 kg broccoli x 3.125 = 0.375. Total $5.145.

Tomato soup, a batch of 10 portions: 3 kg tomatoes x 1.50 = 4.50, 1 kg onion x 1.50 = 1.50, 0.6 l cream x 4.50 = 2.70. Batch total $8.70, so $8.70 / 10 = $0.87 per portion.

Step 3: food cost % per dish

Food cost % = cost per portion / menu price. Use the menu price without sales tax.

DishMenu priceCost per portionFood cost %
Chicken rice bowl$12.00$3.063.06 / 12 = 25.5%
Tomato soup$6.00$0.870.87 / 6 = 14.5%
Salmon plate$21.00$5.1455.145 / 21 = 24.5%

Choose the target food cost % for your own menu. This article gives none, because it cites no source for one.

Step 4: contribution margin

Contribution margin per dish = menu price - cost per portion. It is the money a portion leaves to pay everything that is not food.

The chicken bowl and the salmon plate have almost the same food cost % (25.5% and 24.5%), yet a salmon plate leaves $15.855 and a chicken bowl $8.94. A percentage tells you how much of the price goes to food. The margin tells you how many dollars are left. Look at both.

Step 5: the sales-mix weighted food cost %

The three dishes do not sell in equal numbers, so the average of the three percentages is the wrong figure for the menu as a whole. Suppose the cafe sells these portions in a week:

DishPortions soldSales at menu priceFood cost
Chicken rice bowl120120 x 12.00 = $1,440.00120 x 3.06 = $367.20
Tomato soup6060 x 6.00 = $360.0060 x 0.87 = $52.20
Salmon plate4040 x 21.00 = $840.0040 x 5.145 = $205.80
Total220$2,640.00$625.20

Weighted food cost % = total food cost / total sales at menu price = 625.20 / 2,640.00 = 23.68%.

The plain average of the three dish percentages is (25.5 + 14.5 + 24.5) / 3 = 21.5%. It is lower because it gives the cheap-to-make soup the same weight as the bowl that sells twice as often. Only the proportions between dishes matter: 120, 60 and 40 portions give the same result as 6, 3 and 2.

Why the weighted figure feeds break-even and the projection

A projection needs one cost of goods figure for each month's revenue, and a break-even point needs the share of each sales dollar left after food. Both come from the weighted food cost %, not from any single dish.

As an illustration, suppose the cafe's fixed costs are $1,800 a week (also invented) and food is the only cost that varies with sales. Each sales dollar then leaves 1 - 0.2368 = 0.7632 after food, so break-even sales are 1,800 / 0.7632, about $2,359 a week. This simplification ignores other costs that vary with sales, so treat it as the shape of the calculation and not as a result for any real restaurant.

If the soup price rises or the chicken price falls, the dish percentages change, the weighted figure changes, and so do break-even and every projected month.

Doing it in a spreadsheet

Free recipe-costing sheets exist, and some of them recalculate every recipe when an ingredient price changes. If costing is all you need, a free sheet may be enough.

The Restaurant 5-Year Plan & Menu Costing Workbook does the same five steps on its Ingredients and Menu costing sheets. Its difference from a costing-only sheet is the link: the weighted food cost % feeds the 5-year projection and the break-even sheet, so a price change shows up there too.

The workbook

The Restaurant 5-Year Plan & Menu Costing Workbook holds up to 200 menu items with up to 12 ingredient lines each, and includes a blank template and a worked example for an invented restaurant. It is a planning tool, not financial, tax, legal or lending advice.

This article was written with AI assistance by Northgate Enterprises, and its example figures were checked against the workbook's own formulas by an automated test.