Home / Free tools / Food Cost & Inventory
Excel · 5 KB
Restaurant Food Cost Calculator
A one-sheet Excel calculator for food cost percentage. Enter beginning inventory, purchases, ending inventory and food sales; it returns your cost of goods sold and your food cost percentage, against the 28-35% range the sheet carries as a reference.
- Format
- Excel workbook
- Size
- 5 KB
- Price
- Free, no sign-up
- Section
- Food Cost & Inventory
Work out your food cost percentage
Use one period, and use the same days for every figure. Count inventory on the first and last day of it.
What's in it
- Four inputs on one sheet: beginning inventory, purchases, ending inventory, food sales
- Cost of goods sold calculated as beginning inventory + purchases - ending inventory
- Food cost percentage calculated as COGS divided by food sales for the same period
- Carries a 28-35% reference range for full-service restaurants
How to use it
- Count inventory on the first and last day of the period you are measuring, not whenever is convenient
- Enter purchases as food invoices received inside that period
- Use food sales only, unless your COGS figure also includes beverage
- Read the percentage, then use the guide to work out where the difference is going
The guide that explains it
How to Calculate Food Cost Percentage (With Formula & Examples) — The exact food cost percentage formula, three worked examples, the benchmarks by restaurant type, and a step-by-step plan to bring a high number down.