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.

Event beverage studio

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.

Your whole-pack purchase order

Buying for: Entered demand. Existing containers are used first. All new packs are available before the first phase.

Planned cash outlay
USD 90
Purchased packs plus entered fixed cost.
Budget headroom
USD 10
Negative means above your entered budget.
Supplier packs to buy
2
Total packs across all beverages; pack sizes can differ.
New containers
12
Existing stock is additional.

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.

Whole-pack purchase order
BeveragePortions / containerDemand to buy forExisting containersBuy packsNew containersNew volumePurchase cost
wine5152164,500 mLUSD 60
water4101166,000 mLUSD 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. 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. 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 demand allocation audit
PhaseExact portion quotaFloorRemainderExtra portionFinal portions
welcome99009
meal66006

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.

Scenario stock and shortages
BeverageDemandServedShortOld / new containers openedUntouched old containersUnopened new containersWhole unopened new packsUnused open portionsAll remaining portions
wine151502 / 1050025
water101001 / 2040218

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

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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