Expanding your wine selection without proper calculations often leads to margin erosion. Restaurant owners frequently add wines based on gut feeling rather than data analysis. Learn the step-by-step process to calculate exactly how wine list changes affect your revenue and profitability.
Why wine list length affects your margin
A longer wine list gives guests more choice, but not all wines deliver the same returns. More expensive wines often have a lower margin percentage, but higher absolute profit per bottle. Cheaper wines have a higher margin percentage, but less absolute profit.
The impact on your average margin depends on:
- Which wines you add (price and margin)
- How often guests order these new wines
- Whether guests switch from cheaper to more expensive wines
The basics: calculating your current wine margin
Before you can measure what a longer list does, you need to know where you stand now.
💡 Example current situation:
Restaurant with 5 wines on the list:
- Wine A: €28 (incl. 21% VAT) - cost €8 - sold 20x/month
- Wine B: €35 (incl. 21% VAT) - cost €12 - sold 15x/month
- Wine C: €42 (incl. 21% VAT) - cost €18 - sold 10x/month
- Wine D: €55 (incl. 21% VAT) - cost €25 - sold 8x/month
- Wine E: €75 (incl. 21% VAT) - cost €35 - sold 5x/month
Total wine revenue: €2.254/month
Average wine margin: 62.1%
Calculating the impact of new wines
Your mix shifts once you add wines. Guests choose differently, which can raise or lower your average margin.
⚠️ Note:
Always calculate with prices excluding VAT. Wine prices on the list are including 21% VAT, but for margin calculations use the price excluding VAT.
The formula for wine margin per bottle:
Wine margin % = ((Selling price excl. VAT - Cost price) / Selling price excl. VAT) × 100
Scenario analysis: adding 3 extra wines
Suppose you add 3 wines to your list. You'll need to estimate how much of each wine you'll sell and how this affects your current sales.
💡 Example new wines:
3 new wines you're considering:
- Wine F: €22 (incl. VAT) - cost €6 - expected 12x/month
- Wine G: €48 (incl. VAT) - cost €20 - expected 6x/month
- Wine H: €95 (incl. VAT) - cost €45 - expected 3x/month
New total revenue: €3.129/month
New average margin: 61.8%
Accounting for cannibalization effects
New wines often "steal" sales from existing wines. You need to factor this cannibalization effect into your calculation. I've seen this mistake cost the average restaurant EUR 200-400 per month in lost margins.
Typical effects:
- Cheaper new wine: draws sales away from more expensive wines
- More expensive new wine: some guests upgrade from cheaper wines
- Mid-range new wine: affects sales of comparable wines
💡 Example with cannibalization:
Realistic expectation after adding 3 wines:
- Existing wines: -15% sales (due to more choice)
- New wines: as expected
Adjusted total revenue: €2.792/month
Realistic new margin: 60.9%
ROI of a longer wine list
A longer wine list costs money: more inventory, possible waste from slow-moving wines, extra time for purchasing and staff training.
Calculate:
- Extra revenue per month
- Extra absolute profit per month
- Extra costs (inventory, waste, time)
- Net impact on your results
Practical tools for wine margin analysis
Manually calculating different scenarios takes a lot of time. A system helps you calculate different wine list scenarios without Excel sheets.
You can record per wine:
- Cost price and supplier
- Selling price (automatically calculated excl. VAT)
- Expected sales per period
- Actual sales (for adjustment)
How do you calculate the impact of a longer wine list? (step by step)
Calculate your current average wine margin
Add up all wine sales from last month (revenue and cost of goods). Calculate the average margin across your entire wine list. This is your baseline to compare against.
Estimate sales of new wines
For each wine you want to add: estimate how many bottles you'll sell per month. Look at comparable wines in your current assortment as a reference.
Calculate the cannibalization effect
New wines 'steal' sales from existing wines. Estimate how much your current sales will decline (typically 10-20%) and calculate the net impact on your total wine margin.
✨ Pro tip
Track your wine list performance weekly for the first 6 weeks after expansion. This gives you enough data to spot margin shifts before they become permanent problems.
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 wine margin in hospitality?
Common wine margins range between 60-75%. Cheaper wines often have higher margins (70-80%), more expensive wines lower margins (50-65%) but more absolute profit per bottle.
How do I prevent wines from sitting too long?
Track your sales figures per wine monthly. Wines that sell less than 2-3 bottles per month are better replaced with more popular alternatives.
Should I include VAT in my wine margin calculation?
No, always calculate excluding VAT. Wine has 21% VAT, so a bottle priced at €30 incl. VAT is €24.79 excl. VAT for your margin calculation.
What if guests only order the cheapest wine?
This often happens with too large a price gap. Ensure good spacing: no more than €8-12 difference between consecutive wines on your list.
📚 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 cocktail costs down to the ml
Drink margins seem high, but spillage and free pours eat them up. KitchenNmbrs calculates the exact cost price of every cocktail and drink. Try it free.
Start free trial →