How to use on-site sales data to plan festival bar stock

Your festival bar runs out of a popular drink before the final act, yet the stockroom still has cases of something hardly anyone ordered. Next time, buying more of everything feels reassuring. It also ties up more cash without necessarily fixing the problem.

The first thing you want to do is connect what the tills sold with what physically left stock, then use that record to plan quantities by product, bar and service period. Keep sales, waste, complimentary drinks and transfers separate. They explain different parts of the order you need to place.

A sales report can tell you which drinks people bought. It can't tell you how many wanted a drink after it sold out, whether an open keg was wasted, or whether the runner delivered a case to the wrong bar. That's why a useful festival bar stock forecast needs a little operational context alongside the transactions.

Here's how to turn those records into a buying plan, decide how much to hold at each counter, and make sensible changes during the event. The worked figures throughout this guide are fictional planning examples, not festival benchmarks or recommendations for how much alcohol anyone should drink.

Start with quantities you can actually compare

Pull item-level sales for the last comparable festival, including the product code, serving size, quantity, price, sale time and bar location. Keep a separate record of refunds, voids and discounts. A report that only gives total takings is useful for settlement, but too blunt for ordering drinks.

Suppose beer revenue rose while the number of beers sold fell. A price change could explain that. Ordering from revenue alone would send you in the wrong direction. For stock planning, begin with physical quantities and use money later to judge the cost of carrying them.

Choose one reporting unit for each item. Packaged drinks can usually be counted as individual containers. For poured drinks, use the actual recipe quantity and container size. Don't mix cases, bottles, serves and litres in one column and hope the next person knows what you meant.

Keep different serving sizes separate in the sales export, even if they use the same underlying stock. You can combine them after converting them into a common quantity. The same applies when a cocktail and a spirit measure draw from one bottle. Count the ingredients used by both.

Australia's government guide to managing inventory recommends recording sales and returns, listing stock consistently, and checking records against physical counts. For a festival, apply that discipline to the actual bars and stores your team operates, including temporary counters that disappear during breakdown.

Before analysing the export, ask the bar manager to check the product mapping. Did staff use a generic drinks button? Did an unavailable item remain on the screen? Did a bundle record several drinks as one sale? Resolve what you can and flag the rest. Precision in a spreadsheet doesn't repair an unclear till record.

Save the original export alongside your cleaned version. Keep a short note explaining each adjustment, particularly where you merged product names or converted pack sizes. When a supplier questions the next order, you should be able to show how you reached it without reconstructing the whole event from memory.

If terminals upload transactions after reconnecting, distinguish the time an order happened from the time it reached the report. Otherwise a batch of delayed uploads can look like a sudden rush at a quiet bar. Ask the provider which timestamp the export uses and whether every terminal has finished synchronising before treating the file as complete.

You rarely need buyer identities to plan quantities. Product, time and location usually answer the stock question. Request the minimum operational records you need, with suitable access for the bar manager and person approving purchases. Don't circulate a full customer export simply because it arrived in the same report folder.

Reconcile sales with the physical stock movement

Now count what happened to the goods. For each product and location, start with opening stock, add deliveries and transfers in, then subtract closing stock and transfers out. The result is the quantity that left available stock at that location during the period.

That quantity includes more than paid sales. Artist hospitality, authorised complimentary drinks, spillages, damaged containers and preparation waste all use stock. Record those uses separately so you can explain the difference without treating every missing unit as a customer purchase or an accusation against the team.

Imagine a bar starts with 1,000 cans, receives another 200 and transfers 100 to a neighbouring bar. It closes with 260. Its physical depletion is 840 cans. If paid sales account for 800, authorised hospitality for 20 and recorded damage for 10, another 10 need checking.

Those fictional figures balance only when you keep the transfer out of sales. The neighbouring bar should have a matching transfer in. Across the whole site, the movement cancels out. A case travelling between counters changes where stock is available, not how much the festival bought or sold.

Investigate the unexplained difference before carrying it into next year's forecast. Check the count, delivery receipt, product button and timing of the transfer first. A count taken after a runner moved stock may create an apparent shortage that never existed. Correct the record and retain the explanation.

Refunds need the same care. Returning a customer's payment doesn't necessarily return a sellable drink to stock. A spilled drink followed by a refund has different physical consequences from an unopened can accepted back under your procedures. Record the payment adjustment and the physical outcome separately, without automatically adding refunded units back.

Our guide to improving music venue bar sales covers the wider service and settlement operation. Here, the reason to reconcile is narrower. You need a reliable starting quantity for the next order, with preventable losses visible rather than quietly built into a bigger purchase.

Check whether last year's sales describe next year's audience

A bigger audience is an obvious reason to review stock, but use the right audience count. Tickets issued, tickets sold and people who attended aren't interchangeable. Choose the attendance measure that matches the sales period and keep that definition consistent when comparing festivals.

Loopyah's ticketing tools include QR ticket check-in from staff phones. Where you use that attendance record, check how repeat entry, multi-day admission and complimentary access are represented before calculating a rate. A scanned ticket still doesn't tell you what its holder bought at the bar.

For a simple starting estimate, divide a product's recorded sales by comparable attendance, then multiply by expected attendance. Suppose 4,000 attendees bought 2,400 cans of one soft drink. That's 0.6 cans per attendee. At 5,000 comparable attendees, the same observed rate gives 3,000 cans before other adjustments.

This is arithmetic, not a prediction that every person will buy the same amount. Some won't visit the bar. Some will buy for friends. The rate helps scale a previous total, but it doesn't establish individual consumption or justify an assumption about what a particular guest wants.

Check what else has changed. A longer public programme creates different buying opportunities. A camping audience may use the site differently from day visitors. A new food offer, a changed drinks policy or a different audience age profile may make last year's product mix a poor guide.

Avoid multiplying every adjustment together because each sounds plausible. An attendance increase and a longer opening period can overlap in their effect. Write down what each assumption changes and why. Where you lack comparable evidence, keep a range and explain the uncertainty to whoever approves the order.

For multi-day events, build each day separately before adding the totals. Day tickets, weekend access and actual daily attendance create different denominators. A weekend ticket holder appearing on both days belongs in both daily attendance counts, but only once in a distinct-person count across the weekend. Label the measure you use.

Find stockouts and service interruptions before trusting the mix

A product that sold out early will look less popular than it might have been. The report only records purchases that happened. It doesn't include the person who saw the sold-out sign, chose another drink or left the queue without buying anything.

Put availability notes against the sales timeline. Record when each product became unavailable, when it returned, and which bars were affected. Also note terminal failures, staffing gaps, equipment problems and closed counters. A quiet hour caused by a broken fridge shouldn't become your forecast for a fully working bar.

You can compare unaffected bars or earlier periods to understand what might have happened, but don't present that comparison as recovered demand. Audience movement, programme timing and substitution can all change the result. Keep any estimate explicitly hypothetical and separate from actual sales in the planning file.

The interesting part is often the alternative people bought. If one beer sold out and another suddenly accelerated, ordering both products at their full observed peak could exaggerate next year's requirement. Ask whether the second product gained sales because guests preferred it or because their first choice disappeared.

Talk to supervisors while they still remember the shift. Which requests kept coming? Were guests happy with the substitution? Did staff remove a till button or keep explaining the shortage? These observations won't give you an exact lost-sales total, but they can stop you repeating a clearly unsuitable product allocation.

Separate a site shortage from a bar shortage. If a product remained in central storage while a counter went without it, the next improvement may be a runner, a delivery route or an earlier request. Buying extra stock adds cost while leaving the replenishment failure intact.

Keep the distinction in your review notes. Write that the main bar lacked stock during a named period and that central stores still held it, rather than recording simply that beer ran out. The next manager needs enough detail to decide whether to change purchasing, allocation or the way stock moves across the site.

Use the trading pattern to plan each bar's allocation

Once the total looks reasonable, break it into service periods. Hourly or shorter intervals can help where your export supports them, but choose a level your team can interpret. Tiny time slices won't improve a plan if the timestamps are unreliable or stock movements weren't recorded that precisely.

Compare the sales pattern with the running order. Doors, meal periods, stage changeovers and the final performance can affect where guests gather. A bar near the entrance may trade heavily early, while another becomes busier after people move deeper into the site. Their opening allocations should reflect those different jobs.

The chart below uses a fictional packaged soft drink example. It shows 300 units sold before the main programme, 600 during early performances, 900 during the busiest changeover and 600 later. The total is 2,400 units. These are invented quantities for explaining allocation, with no claim about typical festival demand.

The busiest period accounts for 900 of the 2,400 recorded units, or 37.5%. That doesn't mean you should leave the rest in a distant warehouse until the queue forms. Have enough serviceable stock near the relevant bars before the rush, with the remaining quantity available through a workable replenishment plan.

Keep the chart tied to availability. If the final period included a stockout, its lower total doesn't prove demand naturally fell. Mark the interruption in your private analysis and avoid using that period as evidence that a small late allocation will be sufficient next time.

Then check whether the allocation can actually be served. A counter may have room for the cases but insufficient chilling capacity or too few prepared service positions. More stock behind the bar can obstruct work. Agree where reserve stock waits, how it stays suitable for service and who brings it forward.

Review the same pattern by location before finalising deliveries. Site totals can conceal one overloaded bar and another with slow-moving stock. Start with the expected crowd movement, then use the previous sales record to challenge the assumption. The objective is availability where guests order, without blocking the counter with the whole day's supply.

For a new bar location, start from the closest comparable counter and explain the differences. Don't assign an apparently precise share just because the site plan has another serving point. Watch its early trade, record what happens and retain enough flexibility to move appropriate stock without leaving the established bars short.

Convert the forecast into a purchase order

Keep expected paid sales, planned non-sale use and the extra stock held against uncertainty in separate lines. Add them to get the requirement, then subtract usable stock already held and confirmed incoming supply. Round the remaining quantity to the supplier's actual pack sizes, recording the rounding rather than hiding it.

For example, imagine a requirement of 3,000 cans for sales, 100 for approved hospitality and 200 held against uncertainty. That's 3,300 cans. With 420 usable cans already held, you need 2,880 more. At 24 cans per case, the fictional order is 120 cases.

The 200 extra cans are a chosen planning allowance in this example. They aren't a recommended percentage. Your allowance should depend on uncertainty, how quickly more stock can arrive, available storage and what happens to unsold goods. Document the reason so you can review it after the festival.

Business Queensland's stock control guidance explains the tradeoff between meeting demand and the cash, storage and spoilage costs of holding goods. For your order, that means a sealed, returnable product and a prepared ingredient may deserve very different allowances, even when both sold well last time.

Ask suppliers about delivery cutoffs, minimum orders, substitutions, collection and returns before confirming quantities. Get the conditions in writing. A promise to take stock back is only useful when you know which products qualify, whether packaging must remain intact and when the return has to happen.

Price the order using your actual agreed costs. If those fictional 120 cases cost $30 each, the purchase requires $3,600 before any separately agreed charges. That payment is cash committed to stock. It isn't automatically the cost of drinks sold, because some goods may remain usable after the event.

Put the payment dates into the wider festival budget. A profitable projected bar can still create a cash problem if you must pay the supplier before the event and receive ticket or concession proceeds later. Confirm who funds the order, who owns the remaining stock and who receives any supplier credit.

If an outside concession operator buys and sells the drinks, agree what information the festival receives before the contract is signed. A commission statement may show the money due to you without revealing product quantities, stockouts or waste. Ask for the operational report needed to improve next year's provision, with clear definitions and delivery dates.

Also check who has authority to act on it. Seeing that a product is running low doesn't mean the festival can order stock on the trader's account. Name the person who approves changes, confirm who pays, and keep that agreement consistent with the actual ownership of goods and responsibility for unsold stock.

Plan poured drinks around the actual recipe and equipment

Packaged stock makes counting straightforward. Poured products add preparation and dispensing losses, partial containers and recipe choices. Translate the sales forecast into ingredient quantities before ordering. A till total for cocktails doesn't tell the supplier how much of each ingredient the bar will need.

Use the recipe your team will serve, including each serving size and any allowed substitution. Count mixers, garnish and packaging alongside the main ingredient. If two drinks share a mixer, combine their ingredient requirements before placing the order, while retaining the separate sales assumptions that produced them.

Don't assume the nominal contents of a keg become the same volume of saleable drinks. Record your own measured dispensing losses and investigate avoidable causes. The Brewers Association's Draught Beer Quality Manual covers system setup, dispensing, pouring, cleaning and sanitation. Use it with your supplier's equipment instructions rather than borrowing a universal loss percentage.

If the team expects waste from an equipment problem, fixing that problem should be part of the plan. Buying enough to absorb repeated poor pours may keep the bar trading, but it also commits you to avoidable cost. Ask the equipment provider what needs testing before opening and who handles a fault during service.

Treat partly used containers consistently at closing. Agree the measuring method and record any uncertainty. Don't let one supervisor enter an opened bottle as full while another records it as empty. The resulting comparison could suggest a change in demand when the real change was counting practice.

Preparation also creates a timing decision. Making the entire forecast in advance may reduce work during the rush, yet leave more waste if attendance or product choice differs. Ask the bar manager which preparation can safely happen in smaller batches and what staff need to maintain service while doing it.

Use the actual safe storage and handling requirements for every ingredient. Your stock forecast cannot authorise a longer holding time or an unsuitable temperature. When the operational team changes a recipe or supplier, revise the ingredient quantities and product information together before the new version reaches the counter.

Set a replenishment trigger the runner can meet

A purchase order covers the site. A replenishment trigger protects the bar during service. Decide how much stock should remain when the supervisor requests more, using expected sales while the runner completes the delivery plus a separate allowance for delay or uncertainty.

Here's a fictional packaged drink example. A bar expects to sell 120 cans an hour during its busiest period. A routine replenishment takes 30 minutes, so expected sales during delivery are 60 cans. With an additional 30-can allowance, the request goes in when usable stock falls to 90.

That calculation assumes the runner can deliver within the stated time and the demand estimate fits the coming period. Check both. A route that takes a few minutes before doors can take much longer after the audience arrives. Test the journey with the operations team and revise the trigger when conditions change.

Define what usable stock means. Warm cans awaiting chilling, damaged goods and products awaiting a safety check shouldn't silently count as ready to serve. If chilling takes longer than moving cases, the trigger must allow for that extra time. A delivery to the compound isn't the same as availability at the counter.

Give each bar a named contact and a clear way to request stock. Record the product, quantity, location and request time, then confirm receipt. Where your stock system already records these movements, use it consistently. Don't create a parallel notebook that leaves two people working from different quantities.

Set an escalation for a late delivery. The supervisor should know whom to contact, whether another bar can transfer stock and who can approve a supplier order. Keep the same transfer record whichever route you use. A busy moment is precisely when an unrecorded case can distort several bars' closing figures.

Write a brief stock instruction for each counter before doors. Include its opening quantity, the reserve location, the level for requesting more and the person who can approve substitutions. Use the same product names as the till and delivery sheet. If a runner needs a case count, show the conversion alongside the individual units used in your analysis. Check that the person receiving the instruction can find the stock and identify the correct pack without calling the author.

This also helps a replacement supervisor take over halfway through the day. When you revise a quantity, tell the affected bars and stores together so one team does not continue working from an earlier instruction. Keep the current version available wherever staff make the actual request during service. Have the receiving supervisor confirm changes.

Finally, respect the site's safe movement plan. HSE in Great Britain advises monitoring event operations and briefing staff about site risks. Apply that coordination to replenishment. A forecast doesn't justify sending a delivery through a crowded route or obstructing an emergency access point to save a few minutes.

Adjust the order when conditions change

Weather belongs in the assumptions, but it doesn't provide an automatic drink multiplier. NOAA distinguishes short-term weather from longer-term climate patterns. Use the local forecast for operational decisions as the festival approaches, while treating historical conditions as context when comparing previous editions.

If the forecast changes, ask what the change means for your particular site. It may affect attendance, dwell time, audience movement, delivery access and demand for different products. Agree the response with the relevant teams. Don't turn a weather forecast into an unsupported claim that everyone will buy a fixed additional quantity.

Keep drinking-water provision and guest welfare separate from the commercial drinks forecast. Your plan must support the event's actual safety arrangements and local requirements regardless of what the bar earns. A slow sales report isn't a reason to reduce essential provision, and strong alcohol sales aren't a reason to encourage heavier drinking.

Use a small number of clearly described planning cases. In one, expected attendance and the usual menu hold. In another, attendance is lower and some stock remains unsold. In a busier case, identify which products and replenishment routes would become constrained. Price the consequences using real supplier terms.

Then decide which choices can wait. You may need to commit to equipment and core stock early, while retaining an agreed deadline for a later top-up. Confirm that the supplier can actually support it. An imaginary emergency delivery makes an otherwise careful forecast look safer than it is.

During trading, compare actual quantities with the relevant service period, not just the day's total. Check availability and crowd movement before changing the plan. A popular early product may slow once the programme changes. Moving every remaining case to that bar can create a shortage elsewhere later.

Give one person authority to approve additional purchasing and record why they used it. Include the time, quantity, expected use, delivery commitment and cost. After the event, you can then judge the decision against the information available at that moment instead of blaming someone simply because a different outcome eventually occurred.

If this is your first festival, admit that the evidence is limited. Use supplier discussions, the confirmed menu, service hours and genuinely comparable events to build an initial estimate, then agree how you will learn during trading. Keep borrowed figures labelled by source and context. Another event's total isn't your own sales history.

Start with the products and service periods most likely to cause a costly failure. Test counts and requests during a rehearsal, and make sure supervisors can explain the process without the spreadsheet author present. A modest forecast that the team understands is more useful than elaborate calculations nobody can update when the programme changes.

Close with a record you can use next time

Schedule the closing count before the team disperses and stock moves during breakdown. Record who counted, when they counted and whether any bars or deliveries remained active. If operations continue, make the cutoffs explicit so late transactions and transfers don't disappear between two reporting periods.

Confirm the remaining stock is genuinely usable. Separate returns awaiting supplier acceptance, damaged goods, opened containers and products with limited remaining life. A tidy total that treats everything as available makes the next order look cheaper until the team discovers what it cannot serve.

Review the forecast against paid sales and physical depletion separately. Ask where demand differed, where stock arrived late and where recorded losses changed. Avoid celebrating an accurate total if individual bars repeatedly ran out. The forecast succeeded only partly if guests couldn't buy an available product at the place they wanted it.

Check the supplier credit after returns are processed, too. Stock marked for return is still a pending financial outcome until the supplier accepts it under your agreement. Keep the collection record, accepted quantities and credit together with the original delivery. If acceptance differs from what the team expected, record the reason before planning the next order. That evidence may change which products you buy, how you store reserve cases or whether the apparent return option actually reduces your risk enough.

Choose the next correction with the bar manager while the details are fresh. It might be fewer cases of a slow seller, an earlier delivery request or a better recipe record. Save that decision with the reconciled figures, then start the next festival's order from the corrected record rather than the old invoice.