A restaurant food cost template calculates food cost percentage as beginning inventory plus purchases minus ending inventory, divided by sales. This free Excel version adds waste and theoretical-versus-actual variance columns, which is where the real money hides - the gap between what you should have used and what you actually used.
Download it free
Excel (.xlsx) - works in Excel, Google Sheets and Numbers. No email, no signup.
What's inside
- Period food cost - Beginning inventory, purchases, ending inventory and sales in one calculation
- Multi-location comparison - Same period across sites, so you can see which kitchen is drifting
- Waste log - Logged waste by category, because you cannot cut what you never measured
- Theoretical vs actual - What the recipes say you should have used against what you actually used
How to use it
- Count inventory at the same time on the same day every period. Consistency matters more than precision here.
- Enter purchases for the period from invoices, not from memory or the ordering app.
- Log waste as it happens for two full weeks. Most operators are wrong about where their waste concentrates.
- Compare theoretical to actual. A gap wider than a couple of points is portioning, theft, or a recipe nobody follows.
- Run it by location. A single blended number hides the one site that is actually causing your problem.
Food cost benchmarks and what moves them
| Metric | Typical range | Operator read |
|---|---|---|
| Food cost %, full service | Around 32% median | Above 35% sustained, check portioning before you reprice |
| Prime cost (food + labor) | 60% or below | The number that actually decides whether you profit |
| Theoretical vs actual gap | Under 2 points | Wider than that is portioning, waste or shrinkage |
| Logged waste | Most operators log none | Two weeks of honest logging usually finds the biggest single leak |
At 8,000 meals a day the thing that moved food cost was never renegotiating with suppliers. It was closing the gap between the recipe and what actually left the line. Nobody notices a portion drifting 10% until it shows up as three points of food cost at month-end.
Prefer to run the numbers here?
The Food Waste Cost calculator does the same math in your browser - no download, no spreadsheet.
Open the calculatorFrequently asked questions
How do I calculate food cost percentage?
Beginning inventory plus purchases minus ending inventory gives you cost of goods sold. Divide that by sales for the same period and multiply by 100. The template does the arithmetic - the hard part is counting inventory consistently.
What should food cost percentage be in a restaurant?
Full-service restaurants sit near a 32% median, though it varies widely by concept - a steakhouse and a pizzeria should not be compared. What matters more than the absolute number is whether yours is stable and whether theoretical matches actual.
What is theoretical versus actual food cost?
Theoretical is what your recipes say you should have spent for the volume you sold. Actual is what you really spent. The gap is portioning drift, waste, or shrinkage. Tracking the gap is far more actionable than tracking the headline percentage.
Sources
- National Restaurant Association: Restaurant operators kept food-cost ratios in check in 2024 (2025). Full-service food and non-alcohol beverage costs ran a median of 32.0% of sales in 2024.
- National Restaurant Association: Elevated labor costs had a significant impact on restaurant profitability in 2024 (2025). Full-service wages including benefits ran a median of 36.5% of sales in 2024.
The template shows you the number. It won't fix it.
If the number comes back worse than you expected, that is a system problem, not a spreadsheet problem. Book a free Ops Screen and I'll tell you where it is leaking. If I don't find the leak, you owe nothing.
Book the free Ops Screen →Read next
- How Can I Better Manage Food Costs Across Multiple Locations?
- What's the Best System for Tracking Food Waste in Restaurants?
- Why Is My Restaurant Not Making Money? The 5 Places the System Is Lying to You