How to Calculate Real Food Cost with Last Quarter's Data
Food cost is probably the most scrutinized indicator in a restaurant's accounts. And, paradoxically, the worst calculated.
The figure that appears in your monthly Excel sheet ("food cost: 31%") is usually a convenient approximation: total purchases for the month / total revenue for the month. This formula is accounting-based, simple, and almost always misleading. It doesn't account for inventories, spoilage, order discrepancies between months, or products you've paid for but haven't yet consumed.
The real food cost (the one that truly explains your margin) requires a different calculation. And most of the data to do it correctly, you already have: it's in your invoices and your sales system.
The Formula That Really Works
The accounting food cost formula is:
Food Cost % = (Cost of Consumed Product / Sales) × 100
The important thing is that the numerator is product consumed, not product purchased. That's the key difference.
Product Consumed =
Beginning Inventory
+ Purchases for the Period
- Ending Inventory
- Recorded Spoilage
Without that correction for inventories and spoilage, what you're measuring is what you've spent on suppliers, not what went onto the plate. If a large order of canned goods arrived in March that you haven't consumed yet, it artificially inflates your March food cost. And vice versa in the following month.
How to Calculate It Correctly with Last Quarter's Data
We recommend working with quarters rather than individual months. Three reasons: it smooths out specific variations, allows room for two well-executed inventories, and the data becomes more stable and useful for decision-making.
Step 1: Inventory at the end of the quarter.
Physical, counted, valued. Each line with quantity and current unit cost. Ideally, you do it on the last day of the quarter with the kitchen closed, to avoid contaminating the data with ongoing consumption. If that's not feasible, do it on the first day of the new quarter first thing in the morning.
Step 2: Inventory at the beginning of the quarter.
If you already had the previous quarter's closing inventory well done, that same data is your beginning inventory. If you don't have it, ask your system or the head chef for a reasoned estimate. Imperfect but sufficient.
Step 3: Purchases for the quarter.
Total invoices received from food suppliers during the quarter. Ideally with a breakdown by category (meat, fish, fruit and vegetables, dairy, canned goods, beverages if you include them). Your digitized invoices will provide this if you use a system. Otherwise, you extract it manually from your invoice archive.
Step 4: Recorded spoilage.
Spoilage refers to product that came in but wasn't sold: what broke, expired, burned, was stolen (yes, that too), or was discarded due to quality. The ideal figure is what your kitchen records daily (some restaurants do this). If it's not recorded, do not calculate it: only include what you know for certain.
Step 5: Apply the formula.
Product Consumed = Beg. Inv. + Purchases - End. Inv. - Spoilage
Real Food Cost = (Product Consumed / Quarterly Sales) × 100
Sales are for the quarter, excluding IVA, within the same period for which you calculated consumption.
Comparison: What You Get vs. What You Think
When you perform this calculation correctly for the first time, two things usually happen:
Case 1: Real food cost is higher than accounting food cost. You thought you were at 31% and it turns out to be 34%. This is the most common scenario. It indicates that product is being purchased but not accounted for correctly: unrecorded spoilage, theft, ordering errors, overproduction. Good news: you now have an identified lever for improvement.
Case 2: Real food cost is lower than accounting food cost. You thought you were at 33% and it turns out to be 30%. Rarer but possible. It indicates that you are accumulating inventory (you bought much more than you consumed). Be careful with this: apparent savings can become a problem if inventory starts to expire.
The Ghost Food Cost
There's a category that deserves its own name. We call ghost food cost the difference between real food cost and accounting food cost. It's the loss that occurs and isn't directly visible.
Most frequent causes, ordered by frequency:
1. Unrecorded spoilage. The kitchen discards product, but no one records it. Every time a spoiled hake, a damaged box of strawberries, or a burned sauce is discarded, there's an invisible cost. The solution is discipline: a daily spoilage sheet, a responsible person.
2. Over-portioning. The dish officially contains 180g of protein, but the chef ends up serving 220g. The menu states 180g, the theoretical cost is calculated with 180g, but the actual consumption is 220g. Multiply this by all services, and the difference is significant. Solution: weigh plated dishes, team training, scales at the pass.
3. Incorrectly calculated recipes. The technical sheet has errors: imprecise quantities, forgotten ingredients, processing spoilage (a kilo of peeled potato yields 800g net, not 1000g). If the theoretical cost of the recipe is wrong, then the entire theoretical food cost is wrong.
4. Theft. It exists, and no one likes to talk about it. Product leaving through the back door, unbilled meals for staff or acquaintances, orders that 'go missing.' Detectable only if the real food cost is well calculated and the deviation appears.
5. Errors in orders and deliveries. You are billed for more than what was delivered, or less than what was ordered is delivered and not claimed. This counts as ghost food cost because you pay for product you don't consume.
How to Measure Ghost Food Cost
The formula is:
Ghost Food Cost % = Real Food Cost - Theoretical Food Cost
Where theoretical food cost is the cost calculated from recipes and actual sales (sum of 'for X dishes sold from the menu, Y of each ingredient should have been consumed').
If your ghost food cost is 1-2%, it's within the normal range for hospitality. If it's 3-5%, there's a specific problem worth investigating (probably spoilage or portioning). If it exceeds 5%, you have a serious problem that isn't a drip: it's a leak.
How Many Calculations Are Needed Per Month
The practical question: does this mean you have to do inventories every quarter and calculate formulas? Yes, if you want it done right.
But there are lighter versions that also provide useful information:
Weekly 'high-rotation' inventory. You don't do a full inventory. Only for the 10-15 products that move the most (meat, fresh fish, seasonal vegetables). This gives you a weekly signal of the food cost for your most significant items.
Order vs. sales comparison. Each week, you look at how much of the key products you ordered and how many portions of the dishes that use them were sold. If you ordered 30 kg of sirloin and sold the equivalent of 24, you have a clue (it could be spoilage, over-portioning, or that inventory increased: all relevant).
Comparison between locations (if you have several). If your food cost in location A is 31% and in location B is 36%, there's something different between the two. Same concept, same supplier, different result. Always investigate the difference.
The Role of Digitized Data
For all of this to be viable to maintain month after month, the data needs to be accessible. If each food cost calculation requires gathering invoices from four different folders, reading POS sales in another way, and cross-referencing everything in Excel, you'll do it twice and then give up.
What you need is:
- Digitized invoices with automatic extraction of products, quantities, and prices.
- Exportable or integrated POS sales.
- Inventories recorded in a system (with automatic valuation at the last purchase price).
With these three elements, real food cost is calculated with a couple of clicks and can be reviewed monthly without extra effort.
Conclusion
Simple accounting food cost is useful for a casual chat. Real food cost (with inventories and spoilage) is what truly explains your margin. The difference between the two is where money is lost without you seeing it.
Calculating it correctly the first time requires discipline (physical inventories, spoilage sheet, accurate sales). Maintaining it thereafter is much easier if the data is digitized.
If you want your invoices digitized and consolidated by supplier and product, Sincrio does it for you as soon as you upload your first invoices.