BETA APP IN DEVELOPMENT HACCP and more are available in your dashboard — currently in beta, so minor bugs may occur. The updated app with full integration is coming soon.
📝 Bar, drinks & cocktails · ⏱️ 2 min read

How do I calculate my margin when buying wine by the pallet versus by the case?

📝 KitchenNmbrs · updated 14 Mar 2026

Picture this: you're reviewing your wine costs and wondering if those bulk discounts actually pay off. Most restaurants stick with case purchases, missing potential savings that could boost profit margins. Here's how to crunch the numbers and decide what works for your operation.

Why pallet purchasing makes financial sense

Wine typically delivers some of your strongest margins. Even a modest drop in purchase price translates to meaningful profit gains. Suppliers commonly offer 10-25% discounts on full pallets (typically 50-100 cases).

💡 Example:

A bottle of wine that you normally buy for €8.50 per bottle (by the case):

  • By the case (12 bottles): €8.50 per bottle
  • By the pallet (60 cases = 720 bottles): €7.20 per bottle
  • Savings: €1.30 per bottle = 15% discount

On 720 bottles you save: €936

Calculating your wine margin

Wine follows identical margin principles as food, but VAT matters here. Alcoholic beverages carry 21% VAT, not 9%.

The formula for your pour cost (beverage equivalent of food cost):

Pour cost % = (Purchase price per bottle / Selling price excl. VAT) × 100

💡 Calculation example:

You sell a bottle of wine for €32.00 (incl. 21% VAT):

  • Selling price excl. VAT: €32.00 / 1.21 = €26.45
  • Purchase by the case: €8.50 per bottle
  • Pour cost: (€8.50 / €26.45) × 100 = 32.1%

With pallet discount (€7.20 per bottle):

  • Pour cost: (€7.20 / €26.45) × 100 = 27.2%
  • Difference: 4.9 percentage points better margin

Determining if pallet purchasing pays off

Bulk buying offers clear advantages, but carries real risks. You're tying up more cash upfront and need additional storage capacity. Plus there's always spoilage risk or wines falling out of favor.

⚠️ Watch out:

Only buy by the pallet if you're confident you'll move the wine within 6-12 months. Otherwise, inventory risk will wipe out your discount.

Calculate your break-even scenario:

  • How many bottles of this wine do you move monthly?
  • How long to sell through a complete pallet?
  • What are your additional storage expenses?
  • What's your spoilage or dead stock risk?

💡 Calculation example:

You sell 30 bottles per month of a particular wine:

  • Pallet = 720 bottles
  • Sales duration: 720 / 30 = 24 months
  • Savings: €1.30 × 720 = €936
  • Extra storage costs: €50/month × 24 = €1,200

Result: €936 savings - €1,200 storage costs = -€264 loss

Factoring storage costs into your math

Many operators overlook the hidden expenses of carrying extra inventory. Consider these factors:

  • Additional rent for storage space
  • Higher insurance premiums
  • More capital tied up (interest costs)
  • Risk of spoilage or theft

A pattern we see repeatedly in restaurant financials: calculate 15-25% of your inventory value annually in hidden storage expenses.

Tools for wine margin tracking

Modern inventory systems let you record multiple purchase prices per ingredient. This shows you the immediate difference between case and pallet pricing on your margins. You can also compare suppliers to identify optimal deals.

Quality apps automatically calculate your pour cost per wine, accounting for correct VAT percentages. This keeps you informed about which wines deliver the strongest profitability.

How do you calculate whether pallet purchasing is worthwhile?

1

Calculate your current pour cost per bottle

Divide your purchase price by your selling price excl. 21% VAT and multiply by 100. This is your current margin per bottle.

2

Calculate the savings per bottle with pallet purchasing

Subtract the pallet price per bottle from your current case price. Multiply this by the number of bottles in the pallet for the total savings.

3

Add up all extra costs

Calculate storage costs, interest costs on tied-up capital, and risk of spoilage. Subtract this from your savings to determine your net benefit.

4

Check your sales duration

Divide the number of bottles in the pallet by your monthly sales. If this is longer than 12 months, the risk becomes too high.

✨ Pro tip

Ask your supplier about price locks on future smaller orders after buying a pallet. Some guarantee pallet pricing for 3-6 months on subsequent case purchases.

Calculate this yourself?

In the KitchenNmbrs app you can do this in just a few clicks. 7 days free, no credit card.

Try KitchenNmbrs free →

Was this article helpful?

Share this article

WhatsApp LinkedIn

Frequently asked questions

What's a normal pour cost for wine?

Typical pour costs for wine run 18-25%. Under 20% is excellent territory, while above 30% signals insufficient margin.

Should I include VAT in wine margin calculations?

No, always calculate excluding VAT. Alcoholic beverages carry 21% VAT, so a €32 bottle including VAT equals €26.45 excluding VAT.

Can I combine different wines in one pallet order?

Many suppliers offer mixed pallets where you can combine different wines while still getting bulk discounts. This approach reduces your risk significantly.

ℹ️ This article was prepared based on official sources and professional expertise. While we strive for current and accurate information, the content may differ from the most recent regulations. Always consult the official authorities for binding standards.

📚 Sources consulted

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.

JS

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.

🏆 8 years kitchen manager at 1NUL8 Group Rotterdam
Expertise: food cost management HACCP kitchen management restaurant operations food safety compliance

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 →
Disclaimer & terms of use

Table of Contents

💬 in 𝕏