Every brewery owner has that one beer. The seasonal that sold well three years ago, the collaboration brew that lives on the menu out of nostalgia, or the experimental hop-forward IPA that the head brewer loves but nobody orders twice. These SKUs take up tank time, tie up raw materials, and quietly erode your margins while your best sellers fight for capacity.
A SKU rationalization audit forces you to answer a simple question: does every beer in your portfolio earn its place? The answer requires two categories of hard data, production costs and sales channel performance, and a willingness to act on what the numbers reveal. This isn't about cutting beers for the sake of cutting. It's about freeing up resources so your strongest products can grow.
If you've already explored margin-based SKU rationalization, this guide builds on that foundation by layering in production cost specifics and sales channel intelligence. The result is a more complete picture that accounts for where your money goes and where it comes from.
Let's walk through exactly how to do it.
Building Your Production Cost Baseline for Every SKU
Before you can evaluate which beers to keep, grow, or retire, you need an honest accounting of what each SKU actually costs to produce. Most breweries have a rough sense of ingredient costs per batch, but that's only one piece of the puzzle. True production cost includes materials, labor, tank occupancy, utilities, packaging, and waste.
Gather Your Raw Material Costs
Start with your bill of materials for each beer. Every recipe has a defined set of ingredients: base malt, specialty grains, hops, yeast, adjuncts, water treatment chemicals, and any flavor additions. Pull your most recent purchase orders and calculate the cost per unit for each input. Then multiply by the quantity used per batch.
Here's where many breweries get tripped up: they use list prices instead of actual landed costs. Your real ingredient cost includes shipping, minimum order surcharges, and any waste from partial bag usage. If you're buying a 55-pound sack of specialty malt for one recipe and only using 12 pounds per batch, the remaining 43 pounds may sit in storage for weeks, absorbing moisture and losing freshness. That waste belongs in your cost model.
A practical approach is to build a simple table for each SKU:
IngredientQty per BatchUnit CostBatch CostNotesPale Malt800 lbs$0.42/lb$336.00Bulk pricingCrystal 6060 lbs$0.58/lb$34.80Partial bag waste ~15%Citra Hops25 lbs$18.50/lb$462.50Contract pricingYeast2 packs$45.00$90.00Re-pitched 3x maxWater Chem1 kit$12.00$12.00Total$935.30
Do this for every active SKU. Yes, it takes time. But you can't rationalize what you can't measure.
Factor in Tank Occupancy and Opportunity Cost
Ingredients typically represent 30 to 50 percent of your total production cost. The rest hides in overhead, and the biggest hidden cost for most breweries is tank time.
Consider two beers: a cream ale that ferments in seven days and conditions for three, versus a barrel-aged stout that occupies a fermenter for 45 days. If both use the same 30-barrel fermenter, the cream ale generates roughly four times more throughput per month. That fermenter sitting for 45 days isn't just holding stout. It's blocking four potential batches of your best seller.
To calculate tank occupancy cost, divide your monthly overhead (rent, utilities, insurance, loan payments, staff salaries) by the total fermenter-days available across your cellar. That gives you a cost per fermenter-day. Multiply by the number of days each SKU occupies a tank from brew day through packaging.
For a brewery with $40,000 in monthly overhead and 300 available fermenter-days:
- Cost per fermenter-day: $133.33
- Cream ale (10 days): $1,333.30 in tank occupancy
- Barrel-aged stout (45 days): $5,999.85 in tank occupancy
That barrel-aged stout better command a significantly higher price point to justify nearly six times the tank cost.
Don't Forget Packaging and Labor Variability
Some SKUs are more labor-intensive than others. A straightforward pale ale in 16oz cans runs through your canning line with minimal adjustments. A fruited sour with pulp additions might require extra filtration steps, slower fill speeds, and more QC checks.
Track the actual labor hours per packaging run for each SKU over several batches. Include setup time, changeovers, cleaning, and any rework from quality issues. Some breweries discover that a single problematic SKU consumes 30 percent more labor than their standard beers, which completely changes the profitability equation.
Mapping Sales Channel Performance by SKU
Knowing your costs is half the audit. The other half is understanding where each beer sells, how much revenue it generates per channel, and what margin each channel actually delivers after accounting for distribution costs, discounts, and promotional spend.
Define Your Sales Channels Clearly
Most breweries sell through some combination of these channels:
- Taproom / on-site sales (highest margin, lowest volume for most breweries)
- Self-distribution to local accounts (moderate margin, moderate volume)
- Distributor / wholesale (lowest margin, highest potential volume)
- Online / direct-to-consumer shipping (variable margin, growing for some markets)
- Special events and festivals (one-time revenue, hard to predict)
For each SKU, break down what percentage of total volume moves through each channel. You might discover that your hazy IPA sells 60% through distribution but your pilsner moves 80% through the taproom. These aren't just interesting facts. They're strategic data points.
Calculate Channel-Specific Margins
A beer that looks profitable on paper can become a money loser when you account for channel costs. Here's why: your taproom pint of a $10 per pint IPA carries no distribution markup, no retailer margin, and no slotting fees. That same IPA in a four-pack at a grocery store involves distributor margins (typically 25 to 33 percent of wholesale), retailer markup, potential scan-back promotions, and delivery logistics.
Build a channel margin table for each SKU:
ChannelRevenue per BBLChannel Costs per BBLNet Margin per BBLTaproom$620$45$575Self-Distro$310$85$225Wholesale$195$52$143
When you overlay this with production costs, the picture sharpens dramatically. A beer with $150 per barrel in production costs looks great selling through the taproom at $575 net margin. That same beer through wholesale at $143 net margin barely covers production, leaving almost nothing for overhead contribution.
Identify Volume Trends and Velocity
Margin per unit matters, but so does velocity. A high-margin taproom-only beer that sells 5 barrels per month contributes less total profit than a moderate-margin distributed beer that moves 50 barrels per month.
Pull your sales data for the last 12 months (or longer if you have it) and look for:
- Consistent performers: SKUs with steady or growing volume across multiple channels
- Declining performers: SKUs losing volume quarter over quarter
- Channel-dependent SKUs: Beers that only sell well in one channel and struggle everywhere else
- Seasonal spikes without baseline: SKUs that sell for two months and sit dormant for ten
Plot volume trends on a simple line chart. If a beer's sales curve looks like a downhill ski slope, that's a signal worth paying attention to, regardless of its margin profile.
Running the Actual Audit and Scoring Your SKUs
With production costs and sales channel data assembled, you now have the raw material for your rationalization audit. The goal is to score every SKU against a consistent framework, then sort them into clear action categories.
Create a Scoring Matrix
A simple but effective approach uses four weighted criteria:
- 1Contribution margin per barrel (weight: 30%) — After all production and channel costs, how much does each barrel contribute to overhead and profit?
- 2Volume velocity (weight: 25%) — How many barrels per month does this SKU move across all channels?
- 3Channel diversification (weight: 20%) — Does this beer sell through multiple channels, or is it dependent on one?
- 4Tank efficiency (weight: 25%) — How much revenue does this SKU generate per fermenter-day occupied?
Score each criterion on a 1 to 10 scale for every SKU, then calculate the weighted total. Here's a simplified example for three beers:
SKUMargin ScoreVolume ScoreChannel ScoreTank EfficiencyWeighted TotalFlagship IPA79888.00Fruited Sour84355.15Session Lager57797.00
The numbers tell a story. The Flagship IPA earns its place across all dimensions. The Session Lager scores well despite lower margins because it turns tanks fast and sells through multiple channels. The Fruited Sour has the best per-unit margin but scores poorly on volume, channel reach, and tank efficiency.
Sort SKUs into Action Categories
Using your weighted scores, group every SKU into one of four buckets:
- Grow (scores 7.5+): Allocate more tank time, expand distribution, invest in marketing
- Maintain (scores 5.5 to 7.4): Keep producing but monitor quarterly for changes
- Fix (scores 3.5 to 5.4): Give these a defined window (two to three production cycles) to improve through reformulation, repackaging, or channel shifts
- Retire (scores below 3.5): Phase out and reallocate resources to higher-performing SKUs
Be honest with the "Fix" category. It's tempting to keep underperformers indefinitely with the hope that something will change. Set a deadline. If a beer doesn't improve its score within two production cycles, move it to "Retire."
Run a Capacity Simulation
Before finalizing decisions, model what happens to your brewery's capacity when you retire underperformers. If cutting three SKUs frees up 60 fermenter-days per month, what could you do with that capacity?
Maybe you brew four more batches of your flagship, increasing annual revenue by $80,000. Maybe you reduce overtime because your packaging team isn't running as many changeovers. Maybe you finally have tank space to test a genuinely promising new recipe without squeezing your core lineup.
This simulation turns the abstract exercise of "cutting beers" into a concrete growth story, which makes it much easier to get buy-in from your team.
Implementing Changes and Building an Ongoing Review Cycle
The audit itself is a point-in-time exercise. The real value comes from implementing its findings and establishing a rhythm of ongoing review so your portfolio stays optimized.
Communicate Decisions with Data, Not Emotion
Retiring a beer can be emotional, especially if it's a brewer's passion project or has a loyal niche following. Lead every conversation with the data. Show the production cost breakdown, the channel performance, the tank efficiency score. When people see that a beloved sour ale costs $185 per barrel to produce, sells only 4 barrels a month through a single channel, and ties up a fermenter for 30 days, the decision becomes less about opinion and more about math.
That doesn't mean you ignore qualitative factors entirely. If a beer serves as a taproom conversation starter that drives foot traffic, account for that. But quantify it. How many additional taproom visitors does it actually attract? What's the incremental spend from those visitors? If you can't measure it, it probably isn't as significant as it feels.
Phase Retirements Strategically
Don't pull four beers off the menu on the same day. Phase retirements over a few production cycles. Brew final batches, let existing inventory sell through, and communicate the change to your customers as a positive portfolio evolution. "We're making room for more of what you love" resonates better than "we're cutting beers to save money."
For beers in the "Fix" category, define specific improvement targets. If a beer needs to increase volume by 30% through a new channel partnership, set that goal explicitly and track against it weekly.
Establish a Quarterly Review Cadence
SKU rationalization isn't a one-time project. Markets shift, ingredient costs change, and new sales channels emerge. Build a quarterly review into your operations calendar where you update your scoring matrix with fresh data.
Keep the process lightweight. If your data infrastructure is solid, updating costs and sales figures should take a few hours, not a few weeks. The scoring and sorting takes another hour. The strategic discussion about actions takes a meeting. That's a small time investment for the clarity it provides.
Tools that centralize your production data, inventory costs, and order history make this process dramatically easier. When your bill of materials, purchase orders, and sales records live in one system, pulling the numbers for a quarterly audit becomes a routine task rather than a research project. BrewPlanner was built to connect exactly these dots, giving you production cost tracking, inventory management, and order data in a single platform designed for breweries.
The breweries that grow sustainably aren't the ones with the longest tap lists. They're the ones that know exactly which beers deserve to be there.
Start your audit this week. Pull your ingredient costs for your top ten SKUs, map their sales channels, and run the numbers. You might be surprised which beers are quietly costing you more than they earn. And you'll almost certainly find capacity you didn't know you had, waiting to be put to better use.
