Weekly food cost % tracker
Print this page (Ctrl+P / Cmd+P). Example rows are illustrative; blank rows are for your numbers. Back to the template
| Week starting | Opening inventory | Purchases | Closing inventory | Food sales | Food cost (COGS) | Food cost % | vs target (pts) |
|---|---|---|---|---|---|---|---|
| Week 1 | 4200 | 6100 | 4000 | 21000 | 6300 | 30.0% | |
| Week 2 | 4000 | 5800 | 3900 | 19500 | 5900 | 30.3% | |
The sheet works out food cost = opening + purchases - closing, then food cost % = food cost / food sales, and shows how far you are from your target. Keep one row per week to spot drift early; the total row gives your period food cost %.
Free template from thehospitalityinsider.com/templates/