Recipe cost calculator: plate cost and menu price

Enter what you pay for each ingredient and how much the recipe uses. You get the cost per portion, the food cost percentage and the menu price for your target.

Free tool · Restaurants · Excel · Updated

1Start from your ingredient list

Columns: ingredient, pack price, pack size, pack unit, amount used, unit used, yield %.

2The recipe and what you pay

$

Leave blank for a new item.

%
IngredientPack pricePack sizePack unitUsedUnit usedYield %Line cost
$15.79
$2.13
$6.40
$6.00
$2.00
$3.57
$0.35
$8.00
$1.88
$5.52
oz is weight, fl oz is liquid. Case packs like 6/5 lb read as 30 lb.

3Cost per portion

Cost per portion
$2.58
Food cost at $8.50
30.4%
Menu price at 30%
$8.61
Batch cost
$51.64

At $8.50 this plate runs 0.4 points over your 30% target. Each plate leaves $5.92 after food cost.

IngredientUsedBought asYieldLine costShare of plate
Chicken thighs, boneless6 lb$89.50 / 40 lb85%$15.7930.6%
Sour cream2.5 lb$16.00 / 5 lb100%$8.0015.5%
Diced tomatoes, #10 can1 each$38.40 / 6 each100%$6.4012.4%
Chicken base4 oz$24.00 / 1 lb100%$6.0011.6%
Shredded jack cheese1.5 lb$18.40 / 5 lb100%$5.5210.7%
Cilantro2 each$1.25 / 1 each70%$3.576.9%
Yellow onions3 lb$32.00 / 50 lb90%$2.134.1%
Corn tortillas20 each$12.00 / 120 each100%$2.003.9%
Vegetable oil1 cup$30.00 / 1 gal100%$1.883.6%
Ground cumin2 tbsp$14.00 / 16 oz100%$0.350.7%

Saved recipes stay in this browser so you can re-cost them when a price changes.

Want this done on your whole Excel? We fix plate costs that drift every time a supplier raises a price on your real data, tested with you.

Walk us through your recipe costing

How do you calculate plate cost?

Plate cost is the cost of every ingredient in the batch divided by the portions it makes. Each ingredient line is priced from the case you buy:

Line cost = pack price ÷ pack size × amount used ÷ yield %

Plate cost = sum of line costs ÷ portions per batch

Example: a 40 lb case of chicken thighs costs 89.50 dollars, so 2.24 dollars a pound. The soup uses 6 lb at an 85% yield after trim, so the line costs 15.79 dollars. If the whole batch costs 51.64 dollars and makes 20 bowls, each bowl costs 2.58 dollars.

How do you calculate food cost percentage?

Food cost percentage is the plate cost divided by the menu price.

Food cost % = plate cost ÷ menu price × 100

Example: a bowl that costs 2.58 dollars and sells for 8.50 dollars runs at a 30.4% food cost. The other 5.92 dollars covers labor, rent and profit.

How do you set a menu price from food cost?

Divide the plate cost by the food cost percentage you are aiming for.

Menu price = plate cost ÷ target food cost %

Example: at a 30% target, the 2.58 dollar bowl needs a menu price of 8.61 dollars. The calculator starts at 30%; set the target you use for that category.

How do you account for trim and cooking loss?

Enter the yield: the share of what you buy that ends up in the dish. The tool divides the cost by it, so you pay for the trim too.

Example: USDA’s Food Buying Guide says 1 lb of untrimmed fresh broccoli gives 0.81 lb ready to cook. Enter 81% and 1 lb used costs as much as 1.23 lb bought.

Weigh it yourself for your own cuts and cooks: trim one case, weigh what is left, and divide by what you started with.

Can I use it with my recipe costing spreadsheet?

Yes. Copy the rows from Excel or Google Sheets and paste them in, or save the sheet as CSV and drop it in.

  • Columns: ingredient, pack price, pack size, pack unit, amount used, unit used, yield %.
  • Units: lb, oz, g, kg, gal, qt, pt, cup, fl oz, tbsp, tsp, L, mL, each and dozen.
  • Case packs: a pack size written as 6/5 lb, 4 x 5 lb or 12/16 oz is read as 30 lb, 20 lb or 192 oz.

The download is a CSV you can open in either one. Saved recipes stay in this browser, so you can open one, change a price and re-cost it. For a full menu re-costed from every invoice, see Reports & answers.

Questions

Does oz mean weight or liquid?

Here oz is weight (16 oz to the pound) and fl oz is liquid volume (8 fl oz to the cup). NIST lists them as separate units, so pick the one your recipe means.

What if I buy by the pound and measure in cups?

The row asks what one recipe unit weighs, in ounces (or grams for a pack bought in kg). Weigh one level cup once and enter it.

Are my recipes uploaded anywhere?

They stay on your device. The math runs in your browser and saved recipes are kept in this browser only. Clearing browser data removes them, so download the CSV for a copy.

Does it include labor or packaging?

It costs ingredients. Add to-go containers or napkins as an ingredient line, priced by the case, to include them in the plate cost.

Sources

Lines of light running into one large blue period

Walk us through one problem.

We’ll tell you what we’d fix first.

Walk us through one problem

Free. 30 minutes. A one-page note within two business days.