Excess inventory acts like a slow leak in your restaurant's financial plumbing - you know something's wrong, but the damage happens gradually, out of sight. Most restaurant owners focus on the purchase price but miss how much money sits idle in overstocked coolers and pantries. Here's exactly how to calculate what that inventory buildup actually costs you and translate it into real impact on your revenue.
What does excess inventory cost you?
Your inventory drains money through three channels: tied-up capital, storage expenses, and spoilage risk. Most operators see only the purchase price but overlook these hidden drains.
💡 Example:
A restaurant carries €15,000 in inventory with €50,000 monthly revenue:
- Capital costs: €15,000 × 5% interest = €750/year
- Storage costs: 10% of inventory value = €1,500/year
- Spoilage and loss: 8% of inventory = €1,200/year
Total inventory costs: €3,450/year = 0.6% of revenue
Calculate your inventory-to-revenue ratio
Healthy inventory sits between 2-5% of monthly revenue. Anything beyond that threshold costs unnecessary money. Here's your calculation:
Inventory percentage = (Total inventory value / Monthly revenue) × 100
💡 Example calculation:
Restaurant generating €45,000 monthly revenue:
- Current inventory: €18,000
- Inventory percentage: (€18,000 / €45,000) × 100 = 40%
- Optimal level: 4% = €1,800
- Excess inventory: €18,000 - €1,800 = €16,200
This €16,200 costs approximately €3,240 annually in hidden expenses
Calculate costs per category
Different product categories carry different cost structures. Fresh items cost significantly more per day than shelf-stable products due to higher spoilage risk and energy requirements.
- Fresh products: 15-25% annual inventory costs
- Refrigerated products: 12-18% annual inventory costs
- Frozen items: 8-12% annual inventory costs
- Dry goods: 6-10% annual inventory costs
From tracking this across dozens of restaurants, I've seen operators consistently underestimate refrigerated storage costs - those coolers run 24/7 whether they're half-empty or packed.
⚠️ Note:
Count everything: purchase value plus what's currently in your walk-in, reach-ins, freezer, and dry storage. Many operators forget that half-kilo of butter in the back cooler or those rice bags tucked behind the prep station.
Impact on your profit margin
Excess inventory directly erodes profit margins. If you're carrying €10,000 in unnecessary inventory, you're bleeding €1,500-2,000 annually in hidden costs. With an 8% net margin, you'd need €18,750-25,000 in additional sales just to break even on that waste.
💡 Calculation example:
With €60,000 monthly revenue and 8% net margin:
- Optimal inventory (3%): €1,800
- Actual inventory: €8,000
- Excess: €6,200
- Annual cost of excess: €1,240
- Required additional revenue: €1,240 ÷ 0.08 = €15,500
You need €15,500 more in sales just to offset this waste
Signs of excess inventory
Recognize these warning signs? You're probably overstocked:
- You regularly toss expired products
- Your coolers stay packed, but you can't locate specific items quickly
- You order the same quantities automatically, regardless of recent sales patterns
- Products sit unused for weeks at a time
- Cash flow feels tight despite solid revenue numbers
Practical solutions
Start with a complete inventory count and calculate your current ratio. Set a target of 2-4% of monthly revenue. Tools like KitchenNmbrs can track inventory values and alert you before overordering becomes expensive.
⚠️ Note:
Don't slash inventory overnight. Reduce gradually over 4-6 weeks by ordering smaller quantities and using existing stock first. This prevents shortages during unexpected busy periods.
How do you calculate inventory costs? (step by step)
Count your total inventory value
Go through your cooler, freezer, and dry storage. Add up all purchase prices of what's there. Don't forget half-used packages or leftovers. Note everything by product category.
Calculate your inventory-to-revenue percentage
Divide your inventory value by your average monthly revenue and multiply by 100. A healthy percentage is between 2-5%. Anything above 6% is probably too much.
Calculate the annual costs
Multiply your excess inventory by 15-20% for total annual costs. These are capital costs, storage, and spoilage risk combined. Divide this by your net margin to see how much additional revenue you need.
✨ Pro tip
Track your inventory-to-revenue ratio weekly for 8 weeks straight - you'll spot seasonal patterns and identify which product categories consistently run too high. Most operators discover they're overstocked on dry goods by 40-60%.
Calculate this yourself?
In the KitchenNmbrs app you can do this in just a few clicks. 7 days free, no credit card.
Was this article helpful?
Frequently asked questions
What's a normal inventory-to-revenue ratio for restaurants?
Healthy inventory runs 2-5% of monthly revenue. So with €50,000 monthly sales, you'd carry €1,000-2,500 in inventory. Anything above 6% gets expensive due to capital and storage costs.
What exactly does excess inventory cost me annually?
Calculate 15-20% of inventory value per year in total costs. This includes capital costs (interest), storage expenses (energy, space), and spoilage losses. €10,000 in excess inventory costs €1,500-2,000 annually.
How do I prevent shortages while reducing inventory levels?
Reduce gradually over 4-6 weeks rather than cutting drastically. Order less of shelf-stable items first, maintain normal ordering for fresh products. Monitor sales patterns to avoid stockouts during busy periods.
📚 Sources consulted
- EU Verordening 852/2004 — Levensmiddelenhygiëne (2004) — Official source
- EU Verordening 853/2004 — Hygiënevoorschriften voor levensmiddelen van dierlijke oorsprong (2004) — Official source
- EU Verordening 1169/2011 — Voedselinformatie aan consumenten (2011) — Official source
- NVWA — Hygiënecode voor de horeca (2024) — Official source
- NVWA — Allergenen in voedsel (2024) — Official source
- Codex Alimentarius — International Food Standards (2024) — Official source
- FSA — Safer food, better business (HACCP) (2024) — Official source
- BVL — Lebensmittelhygiene (HACCP) (2024) — Official source
- Warenwetbesluit Bereiding en behandeling van levensmiddelen (2024) — Official source
- WHO — Foodborne diseases estimates (2024) — Official source
Food Standards Agency (FSA) — https://www.food.gov.uk
The HACCP standards shown in this application are for informational purposes only. KitchenNmbrs does not guarantee that displayed values are current or complete. Always consult the FSA or your local authority for the latest regulations.
Written by
Jeffrey Smit
Founder & CEO of KitchenNmbrs
Jeffrey Smit built KitchenNmbrs from 8 years of hands-on experience as kitchen manager at 1NUL8 Group in Rotterdam. His mission: give every restaurant owner control over food cost.
Make food waste measurable and manageable
Every kilo you throw away is lost margin. KitchenNmbrs connects your inventory to your recipes so you can see exactly where waste occurs — and how much it costs. Try it free.
Start free trial →