Food Cost Calculator: How to Calculate Plate Cost and Food Cost Percentage in Excel
Build a food cost calculator in Excel: recipe costing with yield, plate cost, food cost percentage, menu price from a target, and the monthly actual-vs-theoretical food cost check, with a worked example.
A food cost calculator works out what one plate of a menu item costs you in ingredients (the plate cost) and what share of the menu price that cost represents (the food cost percentage): food cost % = plate cost ÷ menu price × 100. Built in Excel or Google Sheets, it pulls current ingredient prices from one list, adjusts for trim and cooking yield, adds a small allowance for seasonings and condiments, and then suggests a menu price from your target food cost percentage. A second part of the calculator checks your actual food cost for the month against what your recipes say it should have been — the gap is waste, over-portioning, theft or pricing errors.
This guide is part of our Restaurant & Café Costs section. It covers the two calculations every kitchen needs: recipe-level plate cost and period-level food cost.
The formulas behind a food cost calculator
| Measure | Formula |
|---|---|
| As-purchased (AP) quantity | Edible portion (EP) quantity ÷ yield % |
| Ingredient cost | AP quantity × price per unit |
| Plate cost | Sum of ingredient costs + seasoning/condiment allowance |
| Food cost % (per item) | Plate cost ÷ menu price |
| Menu price from a target | Plate cost ÷ target food cost % |
| Contribution margin | Menu price − plate cost |
| Actual food cost % (period) | (Beginning inventory + purchases − ending inventory) ÷ food sales |
Yield is the step most people skip. If you buy romaine by the pound and lose 20% to trimming, every ounce on the plate costs you 1 ÷ 0.80 = 1.25 ounces of purchased product. Ignore that and every item using romaine is under-costed.
Setting up the calculator in Excel
Tab 1: Ingredient price list
One row per ingredient: item code, name, supplier, purchase unit (lb, oz, each, fl oz), price per unit, standard yield %, and the date the price was last updated. Every recipe looks up prices here, so one update flows through the whole menu.
Tab 2: Recipe cards
For each menu item: ingredient code, portion (EP quantity), unit, yield, AP quantity, price and cost. Key formulas:
- Price lookup:
=XLOOKUP(A5,Prices!A:A,Prices!E:E,"missing") - AP quantity:
=B5/D5(portion ÷ yield) - Cost when the portion is in ounces and the price is per pound:
=E5/16*F5 - Cost when units match (each, fl oz):
=E5*F5 - Seasoning and condiment allowance (often called a “Q factor”), e.g. 3%:
=SUM(G5:G11)*3% - Plate cost:
=SUM(G5:G11)+G12
Tab 3: Menu summary
Each item with plate cost, current menu price, food cost % (=B2/C2), contribution margin (=C2-B2), suggested price at target (=B2/$H$1) and units sold last month. This is the tab you use to make pricing decisions.
Worked example: chicken Caesar wrap
| Ingredient | Portion (EP) | Yield | AP quantity | Price | Cost |
|---|---|---|---|---|---|
| Flour tortilla, 12 in | 1 each | 100% | 1 each | $0.38 each | $0.380 |
| Chicken breast, cooked | 4.5 oz | 75% | 6.0 oz raw | $3.20/lb | $1.200 |
| Romaine, chopped | 2.5 oz | 80% | 3.125 oz | $2.40/lb | $0.469 |
| Parmesan, shaved | 0.5 oz | 100% | 0.5 oz | $11.50/lb | $0.359 |
| Caesar dressing | 1.5 fl oz | 100% | 1.5 fl oz | $0.14/fl oz | $0.210 |
| Kettle chips (side) | 1.5 oz | 100% | 1.5 oz | $4.80/lb | $0.450 |
| Pickle spear | 1 each | 100% | 1 each | $0.12 each | $0.120 |
| Subtotal | $3.188 | ||||
| Seasoning/condiment allowance (3%) | $0.096 | ||||
| Plate cost | $3.28 | ||||
Prices in this example are assumptions for illustration — use your current supplier invoices. The 75% chicken yield reflects trim and cooking loss from raw to cooked weight; measure your own yields in your kitchen.
Turning plate cost into a menu price
| Target food cost % | Suggested price |
|---|---|
| 28% | $11.73 |
| 30% | $10.95 |
| 32% | $10.26 |
Suppose the café chooses a 28% target and rounds to a menu price of $11.99. Actual food cost is $3.28 ÷ $11.99 ≈ 27.4%, and the contribution margin is about $8.71 per wrap. At $11.49 the food cost would be about 28.6% and the margin about $8.21. Prices before sales tax; how tax is shown on the menu depends on your state and local rules.
Food cost percentage isn’t the whole story
A steak at 38% food cost can earn more dollars per plate than a pasta at 22%. That’s why the menu summary tracks both food cost % and contribution margin, plus units sold:
| Group | Popularity | Margin per plate | Typical action |
|---|---|---|---|
| Stars | High | High | Keep, feature prominently, protect quality |
| Plowhorses | High | Low | Re-engineer the recipe or portion; small price test |
| Puzzles | Low | High | Better placement, description or staff recommendation |
| Dogs | Low | Low | Rework or remove |
To check that margins cover rent, labor and other fixed costs, run the totals through a break-even analysis; to see how menu-level margins roll into the month, use a profit and loss template.
Monthly check: actual vs. theoretical food cost
Recipe costing tells you what food cost should be. Inventory counts tell you what it was.
- Beginning inventory: $6,200
- Purchases during the month: $18,400
- Ending inventory: $5,900
- Cost of food used: 6,200 + 18,400 − 5,900 = $18,700
- Food sales: $58,000 → actual food cost ≈ 32.2%
If the menu summary says the month’s sales mix should have produced a theoretical food cost of 29.5% (sum of plate cost × units sold, divided by food sales), the 2.7-point gap is worth roughly $1,590 for the month. Typical causes: over-portioning, waste and spoilage, unrecorded staff meals or comps, receiving errors, theft, or recipe cards with outdated prices. Count the highest-cost items weekly to narrow it down; your inventory management template can hold the counts.
Common mistakes
- Skipping yield: the most common reason plate costs are too low.
- Outdated prices: update the price list with every invoice, or at least monthly for volatile items like proteins and produce.
- Forgetting sides, sauces and garnishes: bread, butter, dressings and fries belong in the plate cost.
- Mixing units: divide by 16 when the portion is in ounces and the price is per pound; keep volume (fl oz) and weight (oz) separate.
- Counting inventory inconsistently: count on the same day each period, using the same units as your price list.
Purchasing and receiving matter as much as recipes: send orders on a purchase order template and check deliveries against it. Labor, your other big controllable cost, belongs in the employee schedule.
FAQ
What is a good food cost percentage?
It depends on concept, price point and labor model. Many restaurants and cafés set targets somewhere around 25–35% for food, but the right number is the one that, together with labor and overhead, leaves a profit. Track contribution margin alongside the percentage.
Should beverages be included?
Calculate beverage cost separately. Drinks usually have very different cost percentages from food, and mixing them hides problems in both.
How often should I recalculate plate costs?
Whenever a key ingredient price changes noticeably, and at least quarterly for the whole menu. With prices in one linked list, the recalculation is automatic — you only need to review the menu summary.
Does this calculator work in Google Sheets?
Yes. XLOOKUP, SUM and simple division work the same way in Google Sheets, and a shared sheet lets the chef update prices while the owner reviews margins.
Next step: set up the ingredient price list with your last invoices, cost your five best-selling items with real yields, and compare their food cost % and margin. More tools are in Restaurant & Café Costs.