Jul 11, 2026
Last Updated: July 11, 2026
Forecasting pub inventory accurately is critical for running a profitable on-trade business. Venues that forecast properly waste less, maintain better cash flow, and serve customers consistently. Forecasting is built on three pillars: understanding consumption patterns, tracking sales, and adjusting for demand variables. Most pubs manage stock reactively instead of predictively, resulting in either overstocking or understocking, this guide covers the practical methods that separate thriving operations from struggling ones.
Par levels are the maximum stock quantity you want on hand for a product at any time. When stock drops below par, you reorder. Getting this right prevents both cash drain and lost revenue.
Calculating par levels requires three pieces of information: average daily consumption, supplier lead time, and a safety buffer.
Step 1: Calculate consumption rate. Review POS data from the last 4 weeks. For each product, divide total units sold by trading days. If you sold 140 pints of Carling Lager over 28 days, your consumption rate is 5 pints per day.
Step 2: Account for supplier lead time. If your supplier delivers within 2 business days and you trade 6 days per week, you need stock to cover 2 days of sales plus a safety margin. For Carling at 5 pints daily, that's 10 pints minimum.
Step 3: Add a safety buffer. Add 20-30% above your minimum for unexpected demand spikes or supplier delays. For Carling, that's 10 pints minimum plus 1.25 pints buffer = 11 pints par level.
Par Level = (Daily Consumption × Supplier Lead Time in Days) + (Daily Consumption × Safety Buffer %)
Different product categories have different turnover rates. Draught lagers like Carling and Madri move quickly and justify higher par levels. Stouts like Guinness appeal to specific customers and turn more slowly. For spirits, par levels depend on your cocktail menu, feature drinks should be parred higher; backup options lower. Match par level to actual sales velocity.
Increase par levels temporarily for weekends, holidays, and special events. Before a bank holiday weekend, increase fast-moving products by 30-50%. Before Christmas, increase by 50-75%. Before major sporting events, increase by 20-40%. Revert to standard par levels once the event passes.
You cannot forecast what you don't measure. Your POS system records every transaction and is the best source for consumption data.
Modern inventory software pulls data directly from your POS system, eliminating manual entry and errors. When a customer buys a pint of Guinness, the POS records the sale and inventory software automatically adjusts stock. If your POS doesn't integrate with inventory software, ask your supplier, many modern systems offer API connections. The investment pays for itself within weeks through reduced waste and prevented stock-outs.
Pour cost is the ratio of drink cost to revenue. A typical target is 20-30% for spirits and 25-35% for beer and cider.
Pour Cost = (Cost of Drinks Sold ÷ Drinks Revenue) × 100
If you spent £500 on spirits and generated £2,000 in sales, your pour cost is 25%. If it creeps toward 35-40%, investigate: pricing may be too low, consumption too high, or supplier costs rising. Consumption rate is units sold per day or week, track in your POS system, segment by category, and update monthly.
A well-designed spreadsheet handles forecasting for small to medium operations. Include columns for product name, SKU, par level, current stock, consumption rate, reorder point, supplier lead time, order date, cost per unit, and total stock value. Track weekly, every Sunday or Monday, count stock and update the spreadsheet. Compare actual counts against POS data to reveal waste, pricing, or data entry problems.
Use one sheet per product category. Calculate weekly: opening stock, purchases, closing stock, and consumption (Opening + Purchases - Closing). Over 4-8 weeks, patterns emerge that inform your safety buffer.
Weekly counts take 30-60 minutes and are your best early warning system. Reconcile POS data against physical stock. If POS says you sold 50 pints but physical count is 10 pints lower than expected, you have an 8-pint variance. Investigate the pattern.
| Reconciliation Issue | Likely Cause | Investigation Step |
|---|---|---|
| Variance larger on weekends | Staff over-pouring or free pours | Review training and pouring procedures |
| Variance on specific products | Possible theft or damage | Check for breakage; review staff access logs |
| Variance across all products | POS not recording all sales | Audit POS settings and staff training |
| Variance only on draught | Keg spillage or line purging | Inspect keg seals and tap lines |
Manual spreadsheets become unwieldy at scale. Inventory software automates data collection, variance analysis, and reorder alerts. Good systems connect to your POS, adjust stock after every sale, calculate consumption rates in real time, and alert you when stock drops below par.
Prioritise these features: POS integration, real-time stock visibility, automated reorder alerts, consumption tracking, variance reporting, supplier management, forecasting, and reporting. Ask your supplier about integration options. Software costs typically £30-100 per month and recovers quickly through reduced waste and better ordering.
Dead stock hasn't sold in 30+ days and ties up cash. When you spot dead stock, ask: Is it still on your menu? Is it priced correctly? Is it visible? Solutions include discounting to clear, removing from orders and replacing with faster-moving items, or featuring on promotion. For slow-moving items (1-2 units per week), reduce par levels to match demand and reorder more frequently.
Waste and shrinkage are forecasting problems. Better forecasting prevents waste by stocking only what you'll sell and managing par levels so old stock doesn't expire. It also reveals shrinkage patterns indicating theft or training problems.
Over-pouring is the biggest waste source. A standard spirit pour is 25ml or 35ml. If staff pour 40ml, they're giving away 15-60% more than charged. Quantify over-pouring by comparing pour cost against benchmarks. If your pour cost is 5-10 percentage points higher than expected, over-pouring is likely. Solution: implement measured pourers, train staff, and audit regularly.
Spillage and breakage should be minimal, more than 2-3% loss indicates training or equipment problems. Expired stock happens when you overstock slow-moving products; reduce par levels and rotate stock properly (first in, first out). Unrecorded consumption includes staff drinks not rung into POS; establish clear policies requiring all pours recorded.
Special events create demand spikes your baseline forecasting doesn't capture. For planned events, adjust forecast 1-2 weeks ahead and increase par levels for products you know will be popular. After each event, analyse what you sold to refine forecasting for similar future events.
Seasonal demand varies dramatically. Summer brings garden drinkers and higher soft drink sales. Winter brings warming drinks and spirits. Christmas and bank holidays create spending spikes. Your forecasting must account for these patterns.
Your best forecasting tool is your own history. Pull POS data for the same period last year and compare week-by-week sales. Calculate seasonal adjustment factors. If average weekly spirits sales are £2,000 but Christmas week is typically £4,000, your Christmas adjustment factor is 2.0. Account for product-specific patterns: lagers and ciders peak in summer; spirits and warming drinks peak in winter.
Plan 4-6 weeks before Christmas. Increase draught lager par levels by 50%, spirits by 40%, soft drinks by 30%. Order early because suppliers are busy and lead times extend. For summer, plan 2-3 weeks ahead and increase cider and draught lager by 30-40%. For bank holidays, plan 1-2 weeks ahead and increase all par levels by 20-30%.
Your supplier is your forecasting partner. A good supplier understands your business, provides reliable delivery, and helps you plan for seasonal demand.
Lead time is days between order placement and arrival. Standard lead time might be 2 business days, but during Christmas it could be 5-7 days. Know your supplier's lead times for each product and build par levels around realistic lead times. Communicate with your supplier about lead times, seasonal extensions, expedited delivery options, and minimum order quantities.
Swallow Drinks has spent 40 years building relationships with on-trade venues across Birmingham and beyond. We understand seasonal patterns affecting your business and stock a vast portfolio of premium wines, beers, spirits, and soft drinks. Our standard lead time is 2 business days for most products, with flexible ordering around your forecasting needs. We provide historical sales data and seasonal adjustment guidance based on experience with similar venues.
Use Trade ordering to access real-time pricing, order tracking, and account management tools. Explore our product range, including Carling Lager (50 ltrs), Guinness Stout (50ltr), Madri Lager (50 ltrs), and Thatchers Gold (50ltr).
| Forecasting Task | Frequency | Time Required | Key Output |
|---|---|---|---|
| Calculate consumption rate | Monthly | 30 minutes | Daily/weekly units sold per product |
| Review and adjust par levels | Quarterly | 45 minutes | Updated par levels for each product |
| Weekly stock count | Weekly | 45-60 minutes | Physical stock vs. POS variance |
| Reconcile POS vs. physical | Weekly | 30 minutes | Variance analysis and shrinkage tracking |
| Review pour cost | Monthly | 20 minutes | Pour cost % by category |
| Plan for seasonal peaks | 4-6 weeks ahead | 60 minutes | Adjusted par levels for upcoming period |
| Analyse special event sales | Within 1 week of event | 30 minutes | Forecast refinement for future events |
Forecasting pub inventory connects three systems: your POS data, physical stock counts, and supplier relationships. Venues that track consumption accurately, adjust par levels based on demand patterns, and plan ahead for seasonal peaks waste less, maintain better cash flow, and serve customers consistently. Start with basics: calculate par levels, count stock weekly, and reconcile POS data. Once established, layer in seasonal planning and special event forecasting. When ready to move beyond spreadsheets, inventory software automates tedious parts and provides better visibility.
Swallow Drinks has helped countless venues across Birmingham optimise stock management and forecasting. With 40 years of experience and reliable supply, we're your partner in building a forecasting system that works. Register at swallow.uk.com to access the tools and support you need to forecast confidently and manage stock profitably.
Accurate pub inventory forecasting prevents overstocking (which ties up cash and increases waste) and understocking (which leads to lost sales and disappointed customers). It directly impacts your profit and loss statement by optimising stock levels, reducing shrinkage, and ensuring you meet demand during peak trading periods. Forecasting also helps you plan distributor lead times effectively and maintain consistent stock rotation.
Par levels represent the maximum stock quantity you should hold for each drink. Calculate them by multiplying your average daily consumption rate by the number of days between supplier deliveries, then add a safety buffer for unexpected demand spikes. For example, if you sell 10 pints of Carling Lager daily and receive deliveries weekly, your par level might be 80 units. Adjust par levels seasonally and for special events to reflect changing demand patterns.
Key factors include seasonal trends (summer versus winter), holidays and special events, local competition, weather patterns, and historical sales data from your POS system. Day-of-week variations (busier weekends) and meal periods also influence consumption rates. Dead stock and slow-moving items should be identified and either promoted or removed from your beverage program. Understanding your check average and customer preferences helps refine forecasts over time.
Modern inventory management software integrates POS data automatically, eliminating manual entry errors and providing real-time consumption insights. It tracks inventory turnover, calculates pour cost automatically, identifies shrinkage patterns, and generates demand forecasts based on historical data. Software also alerts you when stock falls below par levels and suggests reorder quantities, saving time and reducing the risk of stockouts or overstocking during peak trading periods.
Members of:
AWRS Registration Number: XJAW00000100730
