Open Interactive Calculator →
Deterministic Planning Baseline

Wedding Bar Alcohol Formula: 175 Guests (5 Hours)

Exact bottle quantities and alcohol calculation for 175 wedding guests over a 5-hour reception. Itemized breakdown for wine, beer, spirits, ice, and unopened case return guide.

⚠️ CRITICAL SHORTAGE & OVERBUY RISK

High Risk of Running Out of Ice & Key Spirits Before Hour 5

Standard venue estimates for 175 guests leave you up to 35% short on peak-hour mixers while overcharging $2,000+ in retail wine markup. Up to $381 in unopened bottle returns locked in dossier.

Unlock Itemized Checklist & Store Return Guide ($3.99) →
Wine (750ml Bottles)
146 Bottles
Red & White split
Beer & Seltzers
17 Cases
408 standard servings
Spirits & Handles
0 Bottles
750ml bottles weighted
Bar Ice
263 lbs
Keep 40% for chilling tubs
Bulk Case Discount & Store Returns
Order This Exact Bottle Manifest on Total Wine
Save $300+ on volume case pricing with unopened bottle store return privileges.
Export Cart to Total Wine & More ➔
Want to adjust your specific scenario?
Change duration, guest ratios, vehicle mileage, or pacing goals in real time.
📥 Download Formula Excel (.xlsx) ⚡ Recalculate Live