A 5% inventory variance can drain thousands of euros from your restaurant annually. Most restaurant owners underestimate how these seemingly small discrepancies compound over twelve months. Here's exactly how to calculate what that variance costs you and prevent future losses.
What is a 5% inventory variance?
Inventory variance occurs when your actual stock doesn't match what your records show. A 5% variance means you're missing €500 worth of inventory from an expected €10,000 on hand.
Common causes include:
- Theft (staff or external)
- Unrecorded waste
- Oversized portions
- Purchase or sales recording errors
- Unnoticed spoilage
The formula for financial impact
Calculate your annual variance impact using this formula:
Annual impact = (Variance % × Monthly purchase value) × 12
💡 Example:
Restaurant with monthly purchases of €15,000:
- Inventory variance: 5%
- Monthly loss: €15,000 × 0.05 = €750
- Annual loss: €750 × 12 = €9,000
This restaurant loses €9,000 per year due to inventory variance!
Impact across different revenue classes
Your financial impact scales with business size:
💡 Example: Different restaurant sizes
- Small restaurant (€8,000/month purchases): €4,800/year loss
- Average restaurant (€15,000/month purchases): €9,000/year loss
- Large restaurant (€25,000/month purchases): €15,000/year loss
All at 5% inventory variance.
Hidden costs of inventory variance
Direct losses aren't the only concern. Additional costs include:
- Emergency orders: Rush deliveries cost more
- Sold-out dishes: Lost revenue opportunities
- Stress and time: Constant reordering and verification
- Cash flow: You're purchasing more than you're selling
⚠️ Attention:
A 5% inventory variance effectively raises your food cost by 5 percentage points. If you're calculating with 30% food cost, you're actually running at 35%.
How do you measure inventory variance?
Accurate measurement requires these components:
- Beginning inventory: Complete count on January 1st
- Purchases: Total of all annual deliveries
- Ending inventory: Complete count on December 31st
- Theoretical sales: Beginning inventory + Purchases - Ending inventory
Formula: Inventory variance % = ((Theoretical sales - Actual sales) / Theoretical sales) × 100
💡 Example calculation:
- Beginning inventory: €8,000
- Annual purchases: €180,000
- Ending inventory: €7,000
- Theoretical sales: €8,000 + €180,000 - €7,000 = €181,000
- Actual sales: €172,000
Inventory variance: ((€181,000 - €172,000) / €181,000) × 100 = 5%
What is an acceptable inventory variance?
From tracking this across dozens of restaurants, here are typical variance ranges:
- 0-2%: Excellent management
- 2-5%: Normal, but improvable
- 5-8%: High, requires action
- Above 8%: Critical, needs immediate investigation
Prevention and control
Reduce large inventory variances with these strategies:
- Weekly inventory counts: At minimum for your most expensive products
- Standard portion sizes: Prevent oversized servings
- FIFO system: First in, first out
- Daily waste registration: Track everything discarded
- Access control: Limit storage area access
Systems like KitchenNmbrs track inventory movements and identify discrepancies early, so you can address small issues before they become major losses.
How do you calculate the financial impact? (step by step)
Determine your monthly purchase value
Add up all purchases from the past month. Check your supplier invoices and add everything together. This is your monthly purchase value.
Calculate the monthly loss
Multiply your monthly purchase value by the inventory variance percentage. With €15,000 in purchases and 5% variance: €15,000 × 0.05 = €750 per month.
Calculate what this costs per year
Multiply the monthly loss by 12. In the example: €750 × 12 = €9,000 per year. This is your total financial impact from inventory variance.
✨ Pro tip
Track your 5% variance by calculating the weekly impact: multiply your weekly purchase value by 0.05 to see exactly how much you're losing every seven days. Most restaurants are shocked to discover they're hemorrhaging €150-300 weekly from seemingly minor discrepancies.
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
Is 5% inventory variance normal in hospitality?
5% sits on the higher end but occurs frequently across the industry. Well-managed restaurants maintain variances under 3%. Above 5% requires immediate action to prevent escalating losses.
What if my inventory variance exceeds 8%?
You're facing a serious operational issue that demands immediate attention. Check for theft, incorrect portioning, and administrative errors right away. Variances above 8% can cost thousands annually and indicate systemic problems.
How often should I count inventory for accurate variance measurement?
Complete monthly inventory counts provide reliable variance measurements. Count expensive items like proteins and alcohol weekly to catch discrepancies faster. More frequent counting of high-value products helps identify problems before they compound.
📚 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.
Manage inventory without spreadsheets
Always know what you have in stock and what it's worth. KitchenNmbrs connects inventory to recipes and purchasing for complete oversight. Start your free trial.
Start free trial →