Wedding & Event Beverage Calculator
Turn your own guest and serving assumptions into a beverage purchase order for a wedding, reception or other event. Plan separate phases and guest groups, allocate each group's demand among water, nonalcoholic drinks and other beverages, and buy whole supplier packs after accounting for existing unopened stock. Then test that same purchase order against alternative demand scenarios. The phase timeline shows when containers open, which portions can be served and where stock runs short; the tables distinguish unopened new stock from unused capacity in opened containers. Prices and rates in the editable examples are illustrative, not market estimates or recommendations about alcohol intake. This is a finite-event stock planner, not a blood-alcohol calculator or a forecast of individual consumption.
Buy the packs. See where they run out.
Plan guest groups across your event, buy whole supplier packs, and test the same stock against alternative demand scenarios.
Build one purchase plan, inspect every scenario
The examples use illustrative quantities and prices. Modeled portions are not standard drinks or advice about alcohol intake. No substitution, mid-event restocking, tax, refund or consumption recommendation is assumed.
Event budget and volume units
These are editable purchasing assumptions, not recommendations about drinking. A portion is a modeled serving, not a standard drink. Include water and other nonalcoholic choices in your allocation.
One currency for every price; no exchange-rate conversion.
Applies even when no containers are purchased. Include quoted fees here; no tax or refund is inferred.
Unit changes preserve exact volume. Fractions may appear to avoid rounding.
Beverages and supplier packs
Existing stock is counted in unopened containers. Partial portions are not pooled across containers; unused capacity in an opened container carries into later phases.
Event phases and guest groups
Phases run in order. Enter guests present during each phase; the same people may attend successive phases. Each group's beverage shares must total exactly 100%. Zero-hour phases are allowed.
Phase 1: welcome
Elapsed duration, not clock time.
Phase 2: meal
Elapsed duration, not clock time.
Demand scenarios and purchase plan
100% uses the entered demand. Other percentages scale every group's demand. Each scenario uses the same purchased stock, without substitutions or restocking. Higher total demand does not guarantee coverage for every lower-demand product mix after rounding; inspect all scenarios.
This choice determines the single purchase order evaluated against every scenario.
Your whole-pack purchase order
Buying for: Entered demand. Existing containers are used first. All new packs are available before the first phase.
Known purchase cost: USD 78 + fixed cost: USD 12 = known cash subtotal: USD 90.
Whole portions per container are rounded down. Required containers and purchased packs are rounded up.
| Beverage | Portions / container | Demand to buy for | Existing containers | Buy packs | New containers | New volume | Purchase cost |
|---|---|---|---|---|---|---|---|
| wine | 5 | 15 | 2 | 1 | 6 | 4,500 mL | USD 60 |
| water | 4 | 10 | 1 | 1 | 6 | 6,000 mL | USD 18 |
Does the same stock cover each scenario?
Solid green shows served portions; striped red shows shortages. Bars share one demand scale. Whole-portion allocation can change a product's share after rounding, so buying for a higher total does not guarantee every other scenario is covered.
Lower demand
0 short
20 served of 20 planned portions.
Entered demand
0 short
25 served of 25 planned portions.
Higher demand
0 short
30 served of 30 planned portions.
Follow the stock through the event
Inspecting Entered demand: 25 served, 0 short. Selecting a scenario here does not change the purchase order.
Each container supplies 5 whole portions. Unusable or partial-portion volume per container: 0 mL. Phase bars share a scale for this beverage; exact figures are below each bar.
1. welcome
Hour 0 to 1
- Planned portions
- 9
- Served / short
- 9 / 0
- Containers opened now
- 2
- Of those, new stock
- 0
- Remaining total capacity
- 31 portions
- Unused open capacity
- 1 portions
2. meal
Hour 1 to 3
- Planned portions
- 6
- Served / short
- 6 / 0
- Containers opened now
- 1
- Of those, new stock
- 1
- Remaining total capacity
- 25 portions
- Unused open capacity
- 0 portions
Whole-portion allocation audit for this beverage
Exact quotas are pooled across guest groups within each phase, then allocated by largest remainder. Exact ties use the stable product ID.
| Phase | Exact portion quota | Floor | Remainder | Extra portion | Final portions |
|---|---|---|---|---|---|
| welcome | 9 | 9 | 0 | 0 | 9 |
| meal | 6 | 6 | 0 | 0 | 6 |
What remains after Entered demand?
Unopened new packs are inventory, not promised refunds. Remaining portions include capacity in unopened containers and unused capacity in opened containers.
One purchase order, evaluated against the selected scenario.
| Beverage | Demand | Served | Short | Old / new containers opened | Untouched old containers | Unopened new containers | Whole unopened new packs | Unused open portions | All remaining portions |
|---|---|---|---|---|---|---|---|---|---|
| wine | 15 | 15 | 0 | 2 / 1 | 0 | 5 | 0 | 0 | 25 |
| water | 10 | 10 | 0 | 1 / 2 | 0 | 4 | 0 | 2 | 18 |
Keep the purchasing and stock ledger
The CSV contains canonical mL inputs, exact allocation fractions, every scenario and phase, purchase quantities and known or missing prices. Spreadsheet formula-like labels are escaped.
How to use this calculator
- Load Two-phase gathering or Demand surge with the same order, then open Edit event and supplier packs. Enter your currency label, budget, fixed quoted costs and volume unit.
- Add each beverage with its container volume, modeled portion volume, usable percentage, supplier pack size and existing unopened containers. Enter the price for the entire pack or mark it unknown. New or copied products start with zero stock and zero shares.
- Enter event phases in chronological order. For each guest group, enter attendance, duration-based demand and beverage shares totaling exactly 100%. The same people can attend successive phases; do not double-count them within a phase. Reallocate a product's shares to zero before removing it.
- Enter up to three demand multipliers and choose Buy enough packs for. Update beverage plan. Review the whole-pack order, known and missing costs, and every scenario's shortages; a higher total does not guarantee every product mix is covered.
- Inspect a scenario, choose a beverage in the phase timeline, and review opening quantities, remaining capacity and the whole-portion allocation audit. Compare unopened new stock with unused open portions, then download the CSV or use its selectable copy.
The Formula
The mathematical logic powering this calculation is:
For each guest group in an event phase, expected portions = guests × phase hours × entered portions per guest per hour × scenario percentage / 100. Multiply by each product's share / 100 and sum that product's exact quota across the phase's guest groups. Every group includes every product exactly once, and its shares must total exactly 100%, including zero shares. These are purchasing assumptions, not probabilities, drinking guidance or predictions of individual consumption.
Allocate whole portions separately within each phase. The phase target is the ceiling of all exact product quotas combined. Start each product at the floor of its quota; distribute the remaining portions in descending order of fractional remainder. Exact ties use ascending stable ASCII product ID, not display label or row position. Stable IDs are retained in the CSV. Pooling groups before this rounding avoids rounding every group independently. Splitting one phase into several phases can change the result because each phase rounds separately. Largest-remainder allocation can also reduce one product's count as total demand rises. Buying for a higher-total scenario therefore does not guarantee coverage of every lower-total scenario: inspect every product's shortages.
Whole portions per container = floor(container volume × usable percentage / 100 / portion volume). Capacity must be at least one portion. Unusable or partial-portion volume = container volume − whole portions × portion volume; this includes both the entered loss and the leftover fraction that cannot form a whole portion. Fractional portions are not pooled across containers. Remaining whole-portion capacity in an opened container carries into later phases. The model assumes that capacity stays usable for the modeled event; it does not assess product storage, temperature or food safety.
Only the selected purchase scenario determines the order. For each product, required containers = ceil(total allocated demand across phases / whole portions per container). Additional containers = max(0, required containers − existing unopened containers). Packs to buy = ceil(additional containers / containers per supplier pack). New containers = packs × containers per pack. Available portions = (existing containers + new containers) × whole portions per container. All purchases are available before the first phase. No product substitution or restocking is inferred.
Evaluate every scenario against that same available stock. In phase order, served portions = min(phase demand, remaining capacity); shortfall = demand − served. Cumulative opened containers = ceil(cumulative served portions / portions per container). Containers opened in this phase are the difference from the prior phase. Existing stock is used before newly purchased containers. Unused open capacity = opened containers × capacity per container − cumulative served. Remaining total capacity includes unopened containers as well as unused capacity in opened containers.
At the end, unopened new containers = purchased containers − opened new containers. Whole unopened new packs = floor(unopened new containers / pack size), assuming the new containers are opened from packs in sequence. Untouched old containers remain a separate count. These are stock quantities, not promised returns or refunds. No monetary credit is assigned to leftovers or existing stock.
Purchase cost per product = whole packs × entered pack price, rounded half up to cents. Known purchase cost sums priced purchase lines. Complete cash outlay = purchase costs + entered fixed cost. Budget headroom = budget − complete cash outlay, retaining negative values. A missing price on an active purchase suppresses the complete total and headroom; known costs remain visible. A missing price on a zero-purchase line is inactive. Fixed cost applies even when demand is zero. Enter quoted fees in fixed cost or the pack prices as appropriate; no tax rate, exchange rate or refund policy is inferred.
Volumes use exact rational arithmetic with canonical millilitres. One litre = 1,000 mL and one US fluid ounce = 29.5735295625 mL exactly. Display-unit changes preserve physical quantities and may show exact fractions. Computed values are rounded only for display; the CSV preserves canonical inputs, exact fractions and all scenario ledgers. Counts are exact integers, including large supported totals.
Limits: 1–8 products, 1–8 event phases, 1–6 guest groups per phase and 1–3 scenarios. A phase lasts 0–24 hours, each group has 0–100,000 integer guests and an entered rate of 0–20 portions per guest per hour. Scenario multipliers are 0–300%. These are numerical limits, not consumption recommendations. Container volume is positive through 1,000,000 mL; portion volume is 0.001–1,000,000 mL. Usable volume is greater than 0 through 100%. Pack sizes are 1–1,000 integer containers; existing stock is 0–1,000,000 unopened containers per product. Budget, fixed cost and pack prices are 0–1 billion currency units with at most two decimal places. Other quantities accept unsigned decimals with at most nine places or bounded exact fractions. Names are 1–100 trimmed characters.
The retailer source provides event-planning context only; its recommended serving rates, prices and return terms are not imported. NIAAA's standard-drink explanation distinguishes beverage volume from alcohol content. This calculator does not compute alcohol content, standard drinks, intoxication or safe intake. The whole-portion allocation, order rounding and inventory rules above are the calculator's declared planning method, not a supplier contract.Worked Example
If you input:
- Event phases: 10 guests for a 1-hour welcome at 1.5 portions per guest per hour, then a 2-hour meal at 0.5 portions per guest per hour.
- Beverage shares: 60% wine and 40% water in each phase; these are illustrative demand assumptions.
- Wine quote and stock: 750 mL container, 150 mL portion, 100% usable; six containers per USD 60 pack; two existing containers.
- Water quote and stock: 1,000 mL container, 250 mL portion, 100% usable; six containers per USD 18 pack; one existing container.
- Scenarios and budget: 80%, 100% and 120% demand; buy for 100%. USD 12 fixed cost and USD 100 budget.
Result:
At 100% demand the welcome requires 15 portions, allocated as nine wine and six water; the meal requires ten, allocated as six wine and four water. Wine supplies five whole portions per container and water four. Total demand therefore requires three containers of each beverage. After existing stock, buy one six-container pack of each: USD 60 + USD 18 + USD 12 fixed cost = USD 90, leaving USD 10 headroom. The order supplies capacity for 40 wine portions and 28 water portions. In the purchase scenario, three wine containers open (two old, one new), leaving five unopened new wine containers. Three water containers open (one old, two new), leaving four unopened new water containers and two unused portions in opened water stock. The separate surge example changes the higher scenario to 300% without changing the purchase order: demand reaches 45 wine and 30 water portions, so 68 of 75 portions can be served and seven are short.
Frequently Asked Questions
How much alcohol should I buy for a wedding?
This tool turns your own demand assumptions into whole-pack purchases; it does not recommend alcohol intake. Enter the actual event phases, guest groups, product mix, portion sizes and supplier packs, including water and nonalcoholic choices. Test several assumptions and inspect shortages and leftovers before ordering.
Why can a higher-demand purchase scenario still miss a lower scenario's product mix?
Whole portions are allocated by largest fractional remainder within each phase. That rounding can change individual product counts when the total changes. A larger total need not allocate at least as many portions to every product. Every scenario is evaluated against the same stock so these product-specific shortages remain visible.
Are portions the same as standard drinks?
No. A portion is the beverage volume you enter. Alcohol content depends on more than volume, and this calculator does not model it. Do not interpret portion counts as standard drinks, blood alcohol levels or safe intake.
Can I include water, juice, cans, bottles and kegs?
Yes, as separate products with their own volumes, usable percentages, portion sizes, existing stock and supplier pack sizes. Use one container per pack when purchasing single containers. The model does not infer usable yield, product loss or serving size from the product name.
Does leftover volume in an opened container count toward the next phase?
Whole-portion capacity carries forward. Fractional portions left in different containers are not combined. The table distinguishes unused capacity in open containers from unopened stock. This is an inventory assumption, not a storage or food-safety assessment.
Why does an unknown price sometimes leave the total available?
An unknown price matters only when packs of that product must be purchased. If existing stock covers the purchase scenario, its zero-purchase line is inactive. Otherwise the complete total and budget headroom remain unavailable, while known costs are shown separately. Missing costs are never treated as free purchases.
Can I return the unopened packs or value leftover stock?
The planner reports whole unopened new packs under its sequential-opening assumption, but gives no refund credit. Retailer terms and actual pack handling determine whether anything can be returned. Existing inventory and leftovers are counted without assigning a monetary value.
Can I change units and export all scenarios?
Yes. Switching among mL, litres and US fluid ounces preserves exact volume; fractions may appear instead of rounded decimals. The CSV includes canonical mL inputs, stable product IDs, exact allocation quotas, whole-pack purchases and every scenario's phase and stock ledger. Edited or invalid drafts cannot export an old result as current.
Similar Calculators
Food Cost Calculator & Menu Planner
Calculate recipe food cost, portion costs and menu contribution. Model ingredient yields, whole batches, shared stock and pack purchases with sales sensitivity and CSV.
Recipe Scaling Calculator
Scale ingredient quantities from original servings to desired servings with fraction-friendly kitchen output.
EOQ & Inventory Ordering Planner
Compare economic order quantities with pack sizes, all-units discounts, storage and order budgets. Visualize carrying costs, stock cycles and supplier tradeoffs.
