Use the right denominator for each question
For one menu item, divide its ingredient cost by its selling price to calculate food cost percentage. For a period-level food cost percentage, compare food cost used with matching food sales. Toast’s food cost guide explains the ratio and why it should be considered alongside the amount left after ingredient cost.
Markup uses cost as its denominator; margin uses selling price. Write those names beside the result. A cell labeled only “profit %” hides the distinction and makes a pricing sheet difficult to review.
One dish, four different numbers
Imagine a bowl with $4.20 of ingredients and a $14.00 selling price. The recipe, portions and prices here are fictional teaching inputs.
| Measure | Calculation | Result |
|---|---|---|
| Food cost percentage | $4.20 ÷ $14.00 × 100 | 30.00% |
| Contribution after ingredients | $14.00 − $4.20 | $9.80 |
| Margin after ingredients only | $9.80 ÷ $14.00 × 100 | 70.00% |
| Markup on ingredient cost | $9.80 ÷ $4.20 × 100 | 233.33% |
The 70% and 233.33% figures describe the same $9.80 difference using different denominators. Neither includes every restaurant expense. If packaging, selling fees or other variable costs are part of the decision, subtract them as well and label the resulting contribution measure.
Compare contribution dollars as well as food cost percentages
A lower percentage can still leave fewer dollars per sale. Consider these two fictional items:
| Item | Price | Ingredients | Food cost | Left after ingredients |
|---|---|---|---|---|
| Soup | $9.00 | $2.70 | 30% | $6.30 |
| Bowl | $15.00 | $5.40 | 36% | $9.60 |
At 40 sales each, the soup leaves $252 after ingredients and the bowl leaves $384. These are not final profits. Preparation time, extra costs and how many customers order each item still matter. The BC Cook Articulation Committee’s menu engineering chapter discusses this distinction between food cost percentages and contribution dollars.
Bakery example: include sellable yield and the costs you model
Suppose a batch costs $12 in ingredients and produces 24 pieces, of which 22 can be sold. The modeled labor cost is $18, allocated overhead is $8 and packaging costs $0.35 for each sellable piece.
Total modeled batch cost is $12 + $18 + $8 + (22 × $0.35) = $45.70. Cost per sellable piece is $45.70 ÷ 22 = approximately $2.0773. Keep that precision inside the calculation. Dividing by 24 would spread the cost across two pieces that cannot generate sales.
At an illustrative 30% margin on those included costs, the calculated price is $2.0773 ÷ (1 − 0.30) = about $2.97 per piece. Ingredient cost per piece is only $12 ÷ 22, or about $0.55. Using that ingredient figure alone would ignore much of the work and packaging in this example. Include any additional relevant costs before interpreting the result.
Why adding 30% to cost does not give a 30% margin
Use a simpler $10 modeled cost to see the difference. A 30% markup gives a $13 price: $10 × 1.30. The difference is $3, and $3 ÷ $13 is a 23.08% margin.
A 30% margin instead gives a calculated price of $10 ÷ 0.70 = $14.2857. At the rounded price of $14.29, the actual modeled margin is about 30.02%. Rounding changes the final percentage slightly, so recalculate from the price you actually choose.
These are arithmetic examples, not recommended selling prices. A price still needs to make sense for the product, customers and costs of the business.
Choose a spreadsheet formula that matches the decision
- Food cost ratio:
=IngredientCost/SellingPrice, formatted as a percentage. - Contribution after entered costs:
=SellingPrice-EnteredCosts. - Margin on entered costs:
=(SellingPrice-EnteredCosts)/SellingPrice. - Price from a chosen margin:
=EnteredCosts/(1-TargetMargin). - Price from a food cost target:
=IngredientCost/TargetFoodCostPercentage.
Enter a target such as 30% as 0.30 or a percentage-formatted value. The selling price must be positive for the ratios, and a target margin must be below 100%. Show missing inputs rather than silently treating them as complete costs. The two pricing formulas answer different questions because their cost bases differ.
Keep the recipe, pricing and actual results connected
Start with the recipe cost per serving guide, then update costs when prices, quantities or sellable yield change. For the restaurant-wide view, use the prime cost percentage guide.
SheetChief sells the linked tools. The Recipe Cost Calculator spreadsheet supports recipe-cost and menu-pricing records. The Bakery Pricing Calculator and Order Tracker focuses on bakery planning. Check the current Etsy listing for included fields, software requirements and previews before choosing a product.
Put this into practice
Restaurant Spreadsheet Templates for Google Sheets & Excel · Try the free calculator
Compare the actual product previews and included files before choosing a paid template.
Sources and further reading
The explanations and worked examples are prepared for SheetChief. These sources support the referenced methods or platform instructions.
Questions, answered
Does 30% food cost mean 70% net profit?
No. It leaves 70% after the ingredient cost used in that calculation. Labor, overhead and other costs still affect the final profit.
What is the difference between markup and margin?
Markup divides the difference between price and cost by cost. Margin divides that difference by selling price. The same price can therefore have different markup and margin percentages.
How do I calculate a price for a 30% modeled margin?
Divide the costs included in your model by 0.70. Then check the margin again after rounding the selling price. Add missing relevant costs before relying on the result.
Should bakery cost per item use planned or sellable yield?
For this pricing example, use the number of pieces you can actually sell. Keep any waste assumption visible and avoid counting the same loss twice.
Related SheetChief tools
These are our own products. The examples above explain the task; check each Etsy listing to confirm which features and formats are included.
