Food Cost Percentage Calculator: Menu Price, Dish % and Monthly %

Food cost percentage formula: three numbers with one name

Food cost percentage = cost of food / food sales x 100. The same phrase covers three different sums, and mixing them up is the usual error:

1. Menu price from a target. Menu price = plate cost / target food cost %. $4.20 / 0.30 = $14.00.
2. One dish at its current price. Food cost % = plate cost / menu price. $4.20 / $12 = 35%.
3. The whole kitchen for a week or month. Food cost % = (beginning inventory + purchases - ending inventory) / food sales. ($6,000 + $14,000 - $5,500) / $45,000 = 32.22%.

The first is a plan, the second is a check on one item, the third is what happened. The formulas are the ones taught in the BC Cook Articulation Committee's open textbook Basic Kitchen and Food Service Management: selling price = cost / cost %, food cost percentage = portion cost / selling price, and cost of food = opening inventory + purchases - closing inventory.

I build pricing arithmetic; I do not run a kitchen. Every input on this page is an assumption to replace with your own invoice prices, portions and counts.

Food cost percentage calculator: menu price, dish % and period %

Enter a plate cost and a target and the calculator returns the menu price. Add the current menu price for that dish's food cost %, and the four period figures for the kitchen's food cost % and its distance from target.

It opens on this page's example. The top three results describe one dish; the bottom three describe every dish sold in the period, so the two halves are not meant to match. Leave the menu price or the period fields at 0 if you only need the other half.

How to calculate plate cost per serving, with yield

Plate cost is every ingredient on the plate, each costed per usable unit: cost per usable unit = purchase price / yield %. Yield % is the usable (edible portion, EP) weight divided by the as-purchased (AP) weight. The BC Campus chapter on yield testing gives the formulas: EP weight / AP weight x 100 = yield %, then 100 / yield % = a factor to multiply the purchase cost by. Its own example is 1 kg of carrots that leaves 800 g after peeling and topping, an 80% yield.

Chicken bought at $4.00 a lb costs $5.00 per usable lb once the trim is gone. Skip the yield step and the same plate costs $3.49, which is $0.71 too low; at a 30% target that prices the dish at $11.63 instead of $14, $2.37 short on every plate sold.

Only the carrot yield comes from the textbook; the chicken and potato yields are placeholders. Weigh a case before and after trimming and use your own figure. The chapter's point is that waste "has been paid for" and belongs in the menu price.

How do you calculate a 30% food cost menu price?

Divide the plate cost by 0.30, or multiply it by 3.33. A 30% food cost is the same statement as a 3.33 multiplier, a 233.33% markup on cost and a 70% gross margin on the plate.

Moving the target from 25% to 35% moves this one dish by $4.80, from $16.80 to $12. The multiplier is what the textbook calls the cost mark-up, 1 / food cost %. It is not a percentage markup: 3.33 times cost is cost plus 233.33%. The markup vs margin calculator guide has the full conversion chart.

The result is a base price. The textbook notes that it then gets adjusted for competitors' prices and for endings such as 5 or 9.

Food cost % of one dish at its current menu price

Divide the plate cost by the price on the menu today. At $12 the chicken plate runs 35%, 5 points over a 30% target, and leaves $7.80 of gross profit. Two levers close the gap.

Change the price

At $12.95 the dish runs 32.43%. It reaches 30% only at $14, a $2 rise.

Change the portion or the recipe

To hit 30% at $12, plate cost has to fall to $12 x 0.30 = $3.60, a cut of $0.60. Usable chicken costs $0.31 an ounce ($5.00 / 16), so that is 1.92 oz less chicken, or the same saving found in the sides.

The lever works in reverse too. One extra ounce of chicken on every plate lifts the cost to $4.51; at a $14 price the dish then runs 32.21%, not 30%.

Percent is not the only test. The menu engineering chapter also compares items by contribution margin, selling price minus cost. Penn State's open text Introduction to Food Production and Service notes that "not every menu item will carry exactly the same food cost percentage": low and high cost items are balanced to reach the target.

Food cost percentage for the month, from inventory

Count the stock, then: cost of food used = beginning inventory + purchases - ending inventory, and food cost % = food used / food sales. With $6,000 on the shelves at the start, $14,000 bought and $5,500 left, $14,500 of food was used. On $45,000 of food sales that is 32.22%.

Against a 30% target the month is 2.22 points over. In dollars, 30% of $45,000 allows $13,500; the kitchen used $14,500. The gap is $1,000 for the month, $12,000 a year if it repeats.

Use food sales only. Drink sales or sales tax in the divisor make the percentage look better than it is.

The count decides the answer. An ending inventory counted $500 low turns the same month into 33.33%, 1.11 points worse, with nothing changed in the kitchen.

Adjustments. The BC Campus chapter on monthly food costs subtracts employee meals, promotions and food transferred out to get a net food cost, and treats those as labour or promotion expenses. Assume $300 of staff meals and $150 of promotions: net food cost is $14,050, or 31.22%. The calculator has no field for these; subtract them from food used yourself if you track them.

The same sum is cost of goods sold on a tax return: IRS Publication 334 shows Schedule C adding purchases and other costs to inventory at beginning of year, then subtracting inventory at end of year. How to value inventory for tax is a question for your accountant.

Why the period % runs above the plated %: the gap in points and dollars

The period % counts all food that left the shelves; the plated % counts only what the recipes say went on plates that were sold. To split the gap, cost the month's sales mix at recipe cost.

The mix sells for the same $45,000 and should have used $13,875 of food, 30.83%. That splits the $1,000 overrun in two:

• Menu side: $375 (0.83 points). Plated cost minus target. Even with perfect execution this menu and mix cannot hit 30%, because the chicken plate is priced at 35%.
• Kitchen side: $625 (1.39 points). Food used minus plated cost. This food was bought and is gone but was not sold at recipe portions.

The BC Campus chapter lists the causes of cost percentage overruns: short weights and counts on deliveries, waste in the kitchen, theft, poor recipe control, improper costing and menu pricing, and poor use of leftovers. The arithmetic cannot say which applies. It says how many dollars to look for and whether to start with the menu or the kitchen.

Is 30% a typical food cost? Deriving your own target

There is no single correct figure, and I do not quote an industry range. The BC Campus textbook says "many people simply set their food percentage at 30% and never work out a more appropriate figure". It derives the target from the budget: food costs = sales - (labour + overhead + profit), divided by sales.

For the example month, assume $45,000 of food sales, $27,000 of labour, rent and other operating costs, and $4,500 of profit wanted. $45,000 - $27,000 - $4,500 = $13,500 allowed for food, which is 30%. Here 30% is a result, not a rule. A heavier payroll leaves a lower allowed food cost from the same sum; the operating costs chapter notes that fast-food and fine-dining operations split food and labour differently.

Labour, rent and utilities are not in the food cost %. A dish at 30% still loses money if the other costs take more than the remaining 70%. The break-even calculator guide works out the sales needed to cover fixed costs.

Food cost percentage calculator in Excel and Google Sheets

Six formulas rebuild the calculator. Layout: B2 = purchase price per lb, B3 = yield %, B4 = plate cost, B5 = target food cost %, B6 = current menu price, B7 = beginning inventory, B8 = purchases, B9 = ending inventory, B10 = food sales. Enter percentages as percentages (80%, 30%). Results go in B12 to B17 in the order below.

Calculator, recipe costing sheet or P&L template: which to use

Use the calculator above to price a dish or check a month, your own recipe sheet to hold plate costs, and a monthly profit and loss statement to see what food cost did to profit.

What to put in a food cost sheet: per recipe, a row for each ingredient with price, yield %, portion and portion cost, then plate cost, target %, menu price and food cost % at that price. Per period: beginning inventory, purchases, ending inventory, food sales, food cost % and the gap to target in points and dollars.

To be plain about the paid product: the monthly P&L template has no food cost % cell and does no recipe costing. It takes a month of revenue, cost of goods sold and operating expenses and returns gross profit, gross margin, net profit, net margin and break-even revenue, with a 12-month cash flow tab. It costs $14.99 once and runs in Excel and Google Sheets.

It still shows the number. If revenue is food sales only and cost of goods sold is food used, food cost % = 100% - gross margin.

Gross margin is 67.78%, and 100% - 67.78% = 32.22%, the period figure from the calculator. Net profit is $3,500, not the $4,500 planned: the $1,000 food cost overrun came straight out of profit. The template's break-even revenue line, operating expenses / gross margin, gives $39,836.07. Type your month into the profit and loss spreadsheet to see the same lines; the profit and loss template guide covers the layout and the profit margin calculator guide the margin maths.

Step-by-step: Food Cost Percentage Calculator: Menu Price, Dish % and Monthly %

1. Cost each ingredient per usable unit. Divide the purchase price by the yield %. Chicken at $4.00 a lb with an 80% yield costs $5.00 per usable lb.
2. Add up the plate cost. Multiply each usable-unit cost by the portion and add every item on the plate, including sauce, garnish and bread. The example plate comes to $4.20.
3. Divide by the target food cost % for the menu price. $4.20 / 0.30 = $14.00. The same sum as a multiplier is $4.20 x 3.33.
4. Check the dish at its current price. Plate cost / menu price: $4.20 / $12 = 35%. Raise the price or cut the plate cost until it meets the target.
5. Count inventory and work out the period %. Beginning inventory + purchases - ending inventory = food used: $6,000 + $14,000 - $5,500 = $14,500. Divide by food sales of $45,000 for 32.22%.
6. Turn the gap into dollars. Period % minus target is 2.22 points. Food used minus target % x food sales is $14,500 - $13,500 = $1,000 for the month.

Related guides