Excel · SheetsActual food cost % each week from inventory, purchases and sales, plus a waste log by reason.
What's included:
- Weekly sheet: opening, purchases, closing, sales → food cost used and %
- Flags weeks above your target
- Waste log with reasons and cost
- Summary: overall food cost % and waste by reason
Preview: what's inside
Settings Settings
| Setting | Value |
|---|---|
| Target food cost % | 30% |
Summary Summary
- Purchases (all weeks)
- Food sales (all weeks)
- Overall food cost %
- Waste cost logged
- Waste as % of purchases
- Spoiled
- Overproduction
- Dropped / burnt
Sheet Weekly food cost — One row per week.
| Week starting | Opening inventory | Purchases | Closing inventory | Food sales | Food cost used | Food cost % | vs target |
|---|---|---|---|---|---|---|---|
| 2026-11-02 | 3,150.00 | 4,820.00 | 3,010.00 | 16,100.00 | auto | auto | auto |
| 2026-11-09 | 3,010.00 | 5,240.00 | 3,280.00 | 16,950.00 | auto | auto | auto |
Sheet Waste log — Anything binned, with a reason.
| Date | Item | Qty | Unit | Unit cost | Reason | Waste cost | Note |
|---|---|---|---|---|---|---|---|
| 2026-11-03 | Salad leaves | 0.6 | kg | 11.20 | Spoiled | auto | |
| 2026-11-05 | Cooked rice | 2 | kg | 2.30 | Overproduction | auto |
Preview generated from the actual file: sample rows are example data you replace with your own; formulas fill the calculated columns.
Good to know
- Instant digital download. Nothing physical is shipped.
- Licensed for personal and single-business use.
- 30-day fix-or-refund if a file doesn't work as described (terms).
- Support: eclipsekingdom.support@gmail.com