A craft cocktail bar in Austin discovered they had $8,000 worth of premium spirits collecting dust for over 18 months. Those bottles weren't just taking up valuable shelf space—they were bleeding money through tied-up capital and storage costs. Calculating the margin impact of trimming your beverage selection can transform your cash flow overnight.
Why inventory turnover determines your margin
Every bottle sitting on your shelf longer than 3 months is quietly draining your profits. You've got capital locked up that's earning nothing while consuming valuable storage real estate that could house fast-moving products instead.
💡 Example:
You have 50 different whiskey varieties at €40 per bottle:
- Tied-up capital: 50 × €40 = €2,000
- At 5% interest: €100 per year in capital costs
- Storage space: 2m² at €200/m²/year = €400
Total costs: €500 per year for slow-moving inventory
Measure your current turnover speed
You'll need two numbers for each beverage: monthly sales volume and current stock levels. Divide your stock by monthly sales to get turnover speed in months.
💡 Example calculation:
Gin X: 6 bottles in stock, sell 2 per month
- Turnover: 6 ÷ 2 = 3 months of inventory
- This is acceptable (under 4 months)
Whiskey Y: 8 bottles in stock, sell 0.5 per month
- Turnover: 8 ÷ 0.5 = 16 months of inventory
- This is too much (over 6 months)
Set your cutoff threshold
Pick a turnover threshold that makes financial sense for your operation. Most bars find that 4-6 months works well—anything slower becomes a candidate for removal.
- Fast-moving: 0-2 months turnover
- Normal: 2-4 months turnover
- Slow: 4-6 months turnover
- Too slow: more than 6 months turnover
⚠️ Note:
Account for seasonality. Mulled wine turns slowly only in summer, but it's a bestseller in December. Check turnover over a full year.
Calculate the financial impact
For each potential cut, you need to weigh lost revenue against freed capital and storage savings. This calculation—the kind of thing you only learn after closing your first month at a loss—reveals whether trimming that product actually helps or hurts your bottom line.
💡 Example impact calculation:
Premium whiskey: 4 bottles in stock at €60, sell 3 per year
- Lost annual revenue: 3 × €180 = €540
- Lost margin (65%): €540 × 0.65 = €351
- Freed-up capital: 4 × €60 = €240
- Capital costs saved: €240 × 5% = €12
- Storage costs saved: €20 per year
Net impact: -€351 + €12 + €20 = -€319 per year
Conclusion: This whiskey stays in the selection.
Implement gradually
Don't slash your entire selection overnight. Start with the absolute worst performers and watch how customers respond. Most won't even notice you've dropped 1-2 products from each category.
- Phase 1: Remove products with more than 12 months turnover
- Phase 2: After 3 months, evaluate and remove next category
- Phase 3: Monitor customer reactions and revenue impact
You can reinvest that freed capital into deeper inventory of your bestsellers. This improves your purchasing power and eliminates those costly out-of-stock moments.
How do you calculate the margin impact of reducing your selection?
Inventory your current stock and sales
For each beverage type, count how many bottles you have in stock and how many you sell on average per month. This gives you the turnover speed per product.
Calculate costs per slow-moving product
Multiply your inventory value by your capital costs (usually 5-8% per year) and add storage costs. These are your actual costs for slow-moving inventory.
Compare costs with lost margin
Calculate how much margin you lose by removing a product (sales × profit margin) and compare it with the saved inventory costs. If savings are higher, remove the product.
✨ Pro tip
Track your beverage turnover for exactly 90 days, then eliminate anything moving slower than 8 months. You'll free up 15-25% of your bar inventory capital while losing less than 3% of total beverage revenue.
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
How often should I check my beverage turnover?
Check your turnover speeds every 3 months. For seasonal products, check before and after the season. This prevents you from holding onto slow-moving inventory too long.
What is a good turnover speed for beverages?
For most bars, 2-4 months is ideal. Faster than 2 months often means you don't have enough inventory. Slower than 6 months ties up too much capital.
Should I also account for seasonal products?
Yes, absolutely. Mulled wine turns slowly in summer but is essential in December. Calculate turnover over a full year for seasonal products.
How do I prevent customers from being disappointed by less choice?
Start with the truly slow-moving products that are almost never ordered. Customers usually don't notice the difference between 15 and 12 whiskeys.
Can I invest the freed-up money better?
Yes, invest in more inventory of your bestsellers. This prevents out-of-stock situations and gives you better purchasing terms through higher volumes per supplier.
What if a slow-moving product has high profit margins?
High margins don't always justify slow turnover. Calculate the actual annual profit versus capital costs and storage expenses. A €200 bottle with 80% margin that sells once yearly still ties up capital for 12 months.
How do I handle premium brands that customers expect but rarely order?
Keep one premium option per category as a 'halo product' for brand positioning. But you don't need three top-shelf tequilas if customers only order premium once per week.
📚 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.
Calculate your break-even point in seconds
Food cost is just one part of the story. KitchenNmbrs also helps you structure labor costs and other expenses for a complete break-even overview. Start free.
Start free trial →