Calculate a different drink for this event

How Much Wine for a 200 Guest New Year's Eve Party?

🍷
185
bottles of wine

For a 200-guest new year's eve party lasting 5 hours

15% buffer included
804
Total servings
4
Per person
+24
Buffer bottles

How We Calculated This

Our bartender-tested formula, step by step

1

Estimate actual drinkers

200 guests × 65% drinking rate
= 130 drinkers

At xlarge events, about 65% of guests typically drink alcohol.

2

Calculate base consumption

130 drinkers × 1.5 drinks/hour × 5 hours
= 975 base drinks

Industry standard is 1.5 drinks per person per hour for a 5-hour event.

3

Apply consumption decay

Adjusted for drinking slowdown over time (decay factor: 3.75)
= 731 adjusted drinks

People drink faster in the first hour and slow down as the event progresses.

4

Apply new year's eve party modifier

× 1.1 (+10% for wine)
= 804 wine servings needed

New Year's Eve Partys typically consume 10% more wine than average.

5

Convert to bottles

804 servings ÷ 5 servings per bottle
= 160.8 bottles (raw)

Each bottle of wine provides 5 servings.

6

Add 15% buffer & round up

160.8 × 1.15 = 184.9, rounded up
= 185 bottles

Always round up and add a buffer. Running out is worse than having leftovers!

* Why trust this formula?

Based on industry standards and refined by bartenders with 30+ years of experience. We factor in consumption decay (people drink less as events progress) and real-world drinking percentages.

📊 Quick Reference: Wine by Guest Count

Guests Wine Needed Total Servings
25 guests 24 bottles 101 servings
50 guests 47 bottles 201 servings
75 guests 70 bottles 302 servings
100 guests 93 bottles 402 servings
150 guests 139 bottles 603 servings
200 guests (you) 185 bottles 804 servings

* All calculations include a 15% buffer. Amounts for new year's eve party.

Your Shopping List

Everything you need, plus essentials you might forget

🍷
Wine
The main event
185
bottles

Don't forget these

  • Wine opener/corkscrew (Have a backup!)
    2 pieces
    Buy
  • Wine glasses (or plastic) (2 per drinker for variety)
    260 glasses
    Buy

Pro Tips for Your New Year's Eve Party

Insider advice from experienced bartenders

💡

70% of champagne is consumed between 11:30pm and 12:15am - time your chilling.

Have champagne COLD and ready to pour at 11:55pm.

🎯

People pace themselves until 10pm then drinking accelerates.

🧊

Late-night parties need designated drivers or Uber - plan ahead.

Noisemakers and party favors should be near the champagne station.

🛒 Buying Guide

This is THE champagne event. Plan 1 bottle per 3-4 guests for the midnight toast, plus additional for cocktails (French 75s, Kir Royale). Have regular bar options for earlier in the evening. Stock more than you think - better to have leftovers than run out at midnight.

🎉

Planning a different event?

Use our free calculator for any combination of drinks, events, and guest counts.

Browse All 336 Calculators