Real plate cost includes the food that never makes it to the customer — spillage, spoilage, comps, and over-portioning. Gross up the ideal recipe cost by a waste allowance for a truthful number.
The example
$4.00 recipe, 8% waste.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | Recipe cost | 4.00 |
| 3 | 8% waste | → $4.35 |
The formula
The formula:
How it works
How it works:
- Recipe cost is the ideal edible-portion cost of the dish as plated.
- Waste percent captures spillage, spoilage, comps, and trim beyond yield.
- Dividing by
(1 - waste)grosses up the cost so the dishes you do sell carry the loss. - Use this adjusted cost — not the ideal — when setting menu prices.
Waste vs yield are different losses. Yield is trim and cook loss within the recipe (handled in costing). Waste here is loss outside the recipe — dropped plates, spoiled prep, comped meals. Apply yield first to get recipe cost, then a waste factor on top; stacking both keeps pricing honest.
Try it: interactive demo
Recipe cost and waste %.
Variations
Waste cost amount
The added cost:
Simple add-on
Approximate:
Stack with yield
Both losses:
Pitfalls & errors
Divide, don’t just add. /(1 - waste) is exact; ×(1 + waste) slightly under-counts.
Waste ≠ yield. Yield is in-recipe trim; waste is loss outside the recipe — apply both.
Keep it realistic. Track real waste; a guessed rate misprices the menu.
Practice workbook
Frequently asked questions
How do I include waste in plate cost in Excel?
Should I divide or multiply for waste?
How is waste different from yield?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class