Food and beer that spoil or get tossed are pure loss. Waste cost — wasted units times unit cost — and the waste rate quantify the leak and justify tighter prep and par levels.
The example
14 wasted units at $3.20.
| A | B | |
|---|---|---|
| 1 | Item | Value |
| 2 | 14 × 3.20 | — |
| 3 | Waste cost | → $44.80 |
The formula
The formula:
How it works
How it works:
- Count wasted units (spoiled, dropped, comped, expired) and multiply by unit cost.
- Waste rate = wasted ÷ total used — the percentage to track and reduce.
- Waste is cost with no revenue — it directly raises effective food cost.
- Right-size par levels and prep to the day’s expected demand to cut it.
Waste is food cost you paid for and threw away — it hits margin twice. A 5% waste rate on a 30% food-cost menu effectively pushes food cost toward 31.5%, straight off the bottom line. Tracking waste by item reveals whether the fix is smaller par levels, better rotation (FIFO), or a menu change. For a small operation, cutting waste a couple of points is often easier than raising prices.
Try it: interactive demo
Wasted units, unit cost, total used.
Variations
Waste rate
Wasted ÷ used:
Effective food cost
With waste:
Monthly waste cost
By item, summed:
Pitfalls & errors
All waste. Spoiled, dropped, comped, expired — count it all.
Raises food cost. Waste effectively inflates your food cost %.
Zero used. No usage gives #DIV/0! in the rate.
Practice workbook
Frequently asked questions
How do I calculate spoilage cost in Excel?
What's the waste rate?
How does waste affect food cost?
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