A brewery that brews based on gut feeling will eventually pour money down the drain. Maybe you've been there: a flagship IPA sells out two weeks early while a seasonal sour sits in the brite tank with no orders to fill. The gap between what you produce and what your customers actually buy is where profit disappears. The good news? Your sales order history already contains the answers. You just need to know how to read it.
Forecasting demand isn't reserved for massive operations with dedicated data teams. Any brewery, from a 5-barrel brewpub to a 30-barrel regional producer, can turn past sales data into a production plan that reduces waste, keeps tanks full of the right beer, and gets orders out the door on time. With tools like BrewPlanner's sales order management, you can track every order at the item level and use that history to build smarter production schedules.
Let's walk through a practical framework for turning your sales order data into reliable demand forecasts and production plans.
Mining Your Sales Order Data for Demand Signals
Before you can forecast anything, you need to understand what your sales history is actually telling you. Raw order numbers are just noise until you organize them into patterns. The goal here is to extract three types of demand signals: baseline velocity, trend direction, and variability.
Baseline Velocity: What Sells Consistently
Baseline velocity is the average rate at which a specific product moves through your sales pipeline over a defined period. To calculate it, pull your completed sales orders (those marked as DELIVERED, not PENDING or RETURNED) and group them by product and time period.
Here's a simple example. Say your Hazy IPA had the following delivered order volumes over the past six months:
MonthCases DeliveredMonth 1320Month 2345Month 3310Month 4360Month 5340Month 6355
Your baseline velocity is roughly 338 cases per month. That's your starting point for forecasting. Any production plan should ensure you can meet at least this volume without scrambling.
But don't stop at the average. Look at the range. The difference between your lowest month (310) and highest month (360) is about 15%. That variability matters when you're deciding how much buffer stock to carry.
Trend Direction: Is Demand Growing or Shrinking
Averages can mask important shifts. If your first three months averaged 325 cases and your last three averaged 352, demand is trending upward. Ignoring that trend means you'll consistently underproduce.
A simple way to spot trends without complex statistics: compare the average of your most recent quarter to the average of the quarter before it. If there's a consistent difference of more than 5-10%, you've got a meaningful trend that should influence your forecast.
For products in decline, the signal is equally valuable. If your amber ale has dropped 8% quarter over quarter, scaling back production frees up tank time for products that are growing. This is where building a production schedule that maximizes tank utilization becomes a strategic advantage rather than just an operational exercise.
Variability and Seasonality Patterns
Some products are steady sellers. Others spike and dip. Your sales order history reveals which category each product falls into. Look for patterns tied to recurring events: summer months, holidays, local festivals, or even payroll cycles for your on-premise accounts.
To identify seasonality, you need at least 12 months of order data. Plot your monthly volumes and look for repeated peaks and valleys. A wheat beer that spikes every warm season is predictable. A stout that doubles in volume during colder months is predictable. Use those patterns.
The practical takeaway: segment your products into three buckets.
- Steady movers: Low variability, predictable demand. Brew on a regular cadence.
- Seasonal performers: High variability but with predictable patterns. Schedule production to ramp up before demand peaks.
- Volatile products: High variability with no clear pattern. Keep batch sizes smaller and brew more frequently to stay responsive.
This segmentation alone will transform how you think about your production calendar.
Building a Demand Forecast From Historical Orders
Once you've identified your demand signals, it's time to turn them into actual numbers you can brew against. You don't need a PhD in statistics. A straightforward weighted approach works remarkably well for craft breweries.
Step 1: Weight Recent Data More Heavily
Older data matters, but recent trends matter more. A simple weighted moving average gives more influence to your most recent months. Here's how it works for a six-month window:
- Most recent month: weight of 6
- Second most recent: weight of 5
- Third: weight of 4
- Fourth: weight of 3
- Fifth: weight of 2
- Oldest: weight of 1
Using the Hazy IPA example:
This weighted forecast of 343 cases is slightly higher than the simple average of 338, reflecting the upward trend in recent months. That difference of 5 cases per month might seem small, but across a year and across your full product lineup, these adjustments add up to thousands of dollars in captured revenue or avoided waste.
Step 2: Apply Seasonal Adjustments
If you've identified seasonal patterns, layer them on top of your weighted forecast. Calculate a seasonal index for each month by dividing each month's historical average by the overall average.
For example, if your overall monthly average for a wheat beer is 200 cases, but the warm-season months historically average 280 cases, the seasonal index for those months is 1.4 (280 ÷ 200). For slower months averaging 140 cases, the index is 0.7.
Multiply your weighted forecast by the appropriate seasonal index to get your adjusted monthly forecast.
Step 3: Factor in Customer Pipeline Intelligence
Numbers alone don't tell the whole story. Your sales team (or you, if you're wearing that hat too) has qualitative information that should adjust the forecast. Are you onboarding a new distributor? Did a major account just reduce their order frequency? Is a competitor closing?
This is where having detailed customer records with order history becomes invaluable. When you can see that a specific account has been steadily increasing their orders by 10% each cycle, you can factor that growth into your forecast with confidence. BrewPlanner's customer management features let you track customer contacts, preferences, and order patterns in one place, giving you the context behind the numbers.
Combine your quantitative forecast with these qualitative adjustments. A good rule of thumb: quantitative data should drive 70-80% of your forecast, with qualitative adjustments accounting for the remaining 20-30%.
Step 3 Output: A Monthly Forecast Table
Your final output should look something like this for each product:
ProductWeighted ForecastSeasonal IndexAdjusted ForecastQualitative Adj.Final ForecastHazy IPA3431.1377+5% (new account)396Amber Ale1800.9162-10% (declining)146Wheat Beer2001.4280None280
This table becomes your production target. Every brewing decision flows from these numbers.
Translating Forecasts Into a Production Plan
A forecast tells you what to brew and how much. A production plan tells you when to brew it and where it goes. Bridging that gap requires working backward from your delivery dates through your entire brewing process.
Map Your Production Timeline
Every beer has a production timeline that includes brewhouse time, fermentation, conditioning in a brite tank, and packaging. These timelines vary by style.
For example:
- Hazy IPA: 1 day brewhouse, 10 days fermenter, 3 days brite tank, 1 day packaging = 15 days total
- Lager: 1 day brewhouse, 21 days fermenter, 7 days brite tank, 1 day packaging = 30 days total
- Sour: 1 day brewhouse, 30+ days fermenter, 5 days brite tank, 1 day packaging = 37+ days total
If your forecast says you need 396 cases of Hazy IPA next month and your system can produce 200 cases per batch, you need two batches. Working backward 15 days from your target delivery dates tells you exactly when each batch needs to hit the brewhouse.
Assign Tank Capacity to Forecasted Demand
This is where production planning gets real. You have a finite number of fermenters and brite tanks, and they all need to be shared across your product lineup. Your forecast tells you what needs to be in each tank and when.
Start by mapping your tank inventory:
- Fermenters (FV): List each tank with its volume capacity
- Brite Tanks (BT): Same exercise
- Brewhouse (BH): Note your maximum brews per day
Then overlay your forecasted batches onto a calendar, assigning specific tanks to specific batches. Look for conflicts where two products need the same fermenter during the same window. When conflicts arise, adjust timing, shift batches earlier, or consider which product has more margin flexibility.
A visual scheduling grid makes this process dramatically easier than spreadsheets. When you can see all your tanks, batches, and timelines in one view, conflicts become obvious and solutions become intuitive. BrewPlanner's dashboard scheduling grid lets you drag and drop tank assignments across brewhouse, fermenter, and brite tank phases, turning what used to be hours of spreadsheet wrestling into a visual planning session.
Build in Safety Stock
No forecast is perfect. The question isn't whether you'll be wrong, but how wrong you'll be and what it costs. Safety stock is your insurance policy.
A practical formula for safety stock:
Safety Stock = (Maximum monthly demand - Average monthly demand) × Lead time in months
For your Hazy IPA with a max of 360 cases, an average of 338, and a half-month lead time:
That's not a lot, but it's the difference between fulfilling every order and telling your best account to wait. For products with higher variability, safety stock will be larger. For steady movers, it might be negligible.
The key is matching your safety stock levels to the variability of each product, not applying a blanket buffer across everything. Over-buffering ties up tank space and cash. Under-buffering loses sales.
Closing the Loop: Measure, Learn, and Improve
Forecasting isn't a one-time exercise. It's a discipline. The breweries that get the best results treat their forecast as a living document that improves with every production cycle.
Track Forecast Accuracy
After each month, compare your forecast to actual sales. Calculate your forecast accuracy as a percentage:
If you forecasted 396 cases and sold 410, your accuracy was 96.6%. Track this metric for every product every month. According to the Brewers Association's benchmarking data, breweries that actively track production efficiency metrics tend to achieve stronger margins, and forecast accuracy is one of the most impactful metrics you can monitor.
Aim for 85-90% accuracy as a starting target. Over time, as you refine your process and accumulate more data, 90-95% is achievable for steady-moving products.
Review and Adjust Monthly
Set a recurring monthly planning meeting (even if it's just you and a spreadsheet) to:
- Compare last month's forecast vs. actual sales for each product
- Update your weighted moving average with the latest month's data
- Review any qualitative changes (new accounts, lost accounts, market shifts)
- Adjust next month's forecast and production plan accordingly
- Check safety stock levels and replenish if needed
- Document any lessons learned for future reference
This feedback loop is where the real value lives. Each cycle makes your forecast more accurate, which makes your production plan more efficient, which makes your brewery more profitable.
Connect Sales Data to Inventory and Purchasing
Demand forecasting doesn't exist in isolation. Your production forecast should feed directly into your raw materials purchasing. If you know you need to brew 4 batches of Hazy IPA next month, you can calculate exactly how much grain, hops, and yeast to order, and when to order it.
This connection between sales forecasts, production planning, and inventory management is what separates breweries that scramble from breweries that execute smoothly. When your bill of materials is linked to your production schedule and your purchasing workflow, you can generate purchase orders proactively instead of reactively.
The bottom line: your sales order history is the most underused asset in your brewery. Every delivered order, every returned case, every seasonal spike contains information that can make your next production cycle more profitable than the last. Start with the basics. Pull your last six months of order data, calculate your baseline velocities, and build your first weighted forecast. You don't need to be perfect on day one. You just need to start.
Ready to put your sales data to work? Start organizing your brewery's orders, production schedules, and inventory in one place with BrewPlanner.
