Every beer in your portfolio costs something to keep alive. Raw materials, tank time, packaging runs, label inventory, distributor attention, taproom menu space. Some of those beers earn their keep and then some. Others quietly drain resources while contributing almost nothing to your bottom line.
The hard truth? Most craft breweries carry too many SKUs relative to their production capacity and sales volume. According to the Brewers Association, craft beer production has been declining, with roughly 60% of breweries seeing volume decreases. In a contracting market, the breweries that thrive are the ones making ruthless, data-backed decisions about which products to keep, which to cut, and which to double down on.
That process is called SKU rationalization, and it doesn't have to be painful. With the right margin data and a structured approach, you can turn a bloated portfolio into a lean, profitable lineup. The key is having accurate cost and revenue data for every product you make. Tools like BrewPlanner's inventory management system give you real-time visibility into ingredient costs, stock levels, and lot traceability, which forms the data foundation for everything we're about to walk through.
Let's break this audit into a practical, repeatable process you can run quarterly or whenever your portfolio starts feeling unwieldy.
Building Your SKU-Level Margin Dataset
Before you can rationalize anything, you need numbers you actually trust. Most brewery owners have a general sense of which beers sell well and which don't. But gut feeling and actual contribution margin data tell very different stories. A beer that "flies off the shelves" might generate thin margins after you account for specialty hops, longer fermentation times, and custom packaging. Meanwhile, a modest-selling session ale might be your most profitable product per barrel.
Gathering True Cost Per SKU
The first step is calculating a complete cost of goods sold (COGS) for every active SKU. This goes well beyond the ingredient bill. You need to capture:
- Raw material costs: Malt, hops, yeast, adjuncts, water treatment chemicals, and any specialty additions. Track actual purchase prices, not estimates from six months ago.
- Packaging costs: Cans, bottles, labels, carriers, case trays, shrink wrap, kegs (amortized or rental costs), and crowlers if applicable.
- Direct labor allocation: Brewing labor hours, cellar work, and packaging line labor divided across the batches they touched.
- Tank occupancy cost: Every day a beer sits in a fermenter or brite tank, it prevents another batch from occupying that space. Calculate your daily tank cost by dividing total cellar overhead by total tank-days available, then multiply by the days each SKU occupies tanks.
- Yield and loss factors: Trub loss, dry hop creep absorption, packaging line waste, and any quality holds or dumps.
If you're still pulling this data from disconnected spreadsheets, you're almost certainly working with incomplete or outdated numbers. An integrated system that links your recipe, batch records, and inventory data makes this calculation dramatically faster and more accurate. For a deeper dive into this process, check out this guide on how to calculate and track true brewery COGS per barrel.
Capturing Revenue Per SKU
On the revenue side, you need net revenue per package, not just the list price. Account for:
- Channel-specific pricing: Taproom pints generate very different revenue than distributed six-packs or kegs sold to bars.
- Distributor margins and fees: Deductions, placement fees, promotional allowances, and any volume-based rebates.
- Returns and breakage: Product that comes back or gets credited reduces your effective revenue.
- Promotional discounts: If you regularly discount a particular SKU to move volume, that discounted price is your real revenue.
Once you have both sides of the equation, calculating contribution margin per SKU is straightforward: net revenue minus total COGS equals contribution margin. Express this both as a dollar amount per barrel (or per case) and as a percentage. You'll use both figures in the next phase.
Most breweries find that a handful of products generate the vast majority of their margin dollars. That's not a problem. It's a signal that tells you exactly where to focus.
Scoring and Ranking Your Product Portfolio
With margin data in hand, you need a structured framework for evaluating each SKU. Margin alone doesn't tell the whole story. A low-margin beer might serve a strategic purpose, while a decent-margin beer might not be worth the complexity it adds to your operation.
The Four-Quadrant SKU Matrix
Plot every SKU on a simple two-axis grid. The horizontal axis is sales volume (units sold per period). The vertical axis is contribution margin percentage. This creates four quadrants:
QuadrantVolumeMarginActionStarsHighHighProtect and grow. Prioritize tank time and raw materials.Cash CowsHighLowInvestigate cost reduction. Can you reformulate, renegotiate supplier pricing, or shift packaging?Niche WinnersLowHighMaintain selectively. These are profitable but don't move volume, so limit batch frequency.DrainLowLowCandidates for elimination or radical overhaul.
This matrix gives you a visual snapshot of your entire portfolio and immediately highlights where your attention belongs.
Adding a Strategic Overlay
Pure financial analysis misses qualitative factors that matter. Before you cut anything in the "Drain" quadrant, ask these questions:
- Does this SKU serve a specific channel requirement? Some distributors or key accounts require a certain style to maintain the relationship. Cutting it might cost you shelf space for your Stars.
- Is this a flagship or brand identity product? Your original IPA might not be the most profitable beer, but it could be tied to your brand story. Reformulate or reposition before you kill it.
- Does this SKU attract a unique customer segment? A low-margin sour might bring in customers who also buy your high-margin stout. Track basket analysis if you can.
- Is the low performance a distribution or marketing problem rather than a product problem? A great beer with no visibility will underperform. That's fixable without discontinuing the product.
Score each SKU on a 1 to 5 scale for strategic importance, then combine it with the margin quadrant to make your final keep/cut/fix decision. This prevents you from making purely financial decisions that damage your brand or customer relationships.
Setting Your Cutoff Threshold
Every brewery needs a minimum margin threshold below which a SKU must justify its existence with strategic value. A common starting point is requiring every product to achieve at least a 40% contribution margin. Products below that line either need a cost reduction plan with a deadline or they go on the discontinuation list.
Set a timeline, typically 90 days, for "fix" SKUs to hit their targets. If reformulation or supplier negotiation doesn't get them above the threshold, they move to the cut list. This creates accountability and prevents low performers from lingering indefinitely.
Executing the Rationalization and Measuring Results
Deciding which SKUs to cut is only half the job. Executing the changes without disrupting your operation, your distribution relationships, or your taproom experience requires a structured rollout plan.
Phase 1: Communicate Before You Cut
Don't blindside your sales team, distributors, or taproom staff. Before discontinuing any product:
- 1Brief your sales team with the rationale. Give them the margin data (simplified) so they can speak confidently about why you're streamlining.
- 2Notify distributors with adequate lead time, typically 60 to 90 days. Offer a suggested replacement SKU from your Stars or Niche Winners category.
- 3Plan a taproom transition. If you're cutting a beer that has loyal fans, announce it as a "final batch" rather than quietly removing it. This creates a sense of urgency that can actually boost short-term sales.
- 4Coordinate with your packaging schedule. Use up existing label and packaging inventory for discontinued SKUs rather than scrapping it. Time your final production run to burn through raw materials you've already committed to.
Phase 2: Reallocate Freed Resources
The real payoff from SKU rationalization isn't just eliminating losers. It's redirecting their resources to your winners. When you cut three underperforming SKUs, you free up:
- Tank capacity. More turns per year for your highest-margin beers. If your best IPA was constrained to 20 batches per year because your tanks were occupied by slow movers, you might push it to 28 or 30.
- Purchasing leverage. Consolidating your malt and hop purchases into fewer varieties gives you larger orders per ingredient, which often unlocks volume discounts.
- Packaging efficiency. Fewer changeovers on your canning line means less downtime, less waste, and lower per-unit packaging costs.
- Sales focus. Your sales team can tell a tighter, stronger story when they're not spreading their attention across 15 products. Fewer SKUs means deeper retail penetration for each one.
Quantify these gains. If cutting three SKUs frees up 30 tank-days per quarter and you fill those with your highest-margin product, calculate the incremental margin dollars. This is how you build the business case for the next rationalization cycle.
Phase 3: Track and Iterate
SKU rationalization isn't a one-time project. It's an ongoing discipline. Build a quarterly review into your operations calendar where you pull updated margin data, replot your matrix, and evaluate whether any new products you've added are performing to expectations.
Key metrics to track after rationalization:
- Overall portfolio contribution margin. This should increase as you've removed drag from low performers.
- Revenue per barrel. With a tighter lineup of higher-margin products, your revenue per barrel should climb even if total volume stays flat.
- Production efficiency. Track batches per tank per quarter. Fewer SKUs should mean better tank utilization.
- Inventory turns. Fewer products should lead to faster turnover of both raw materials and finished goods.
- Customer and distributor feedback. Watch for any negative impact on key accounts or taproom traffic.
Using brewery management software that integrates your production schedule, inventory levels, and sales data makes this quarterly review a manageable task rather than a multi-day spreadsheet wrestling match. When your batch records, ingredient costs, and tank schedules live in one system, pulling the data you need for a rationalization review takes minutes instead of hours.
Putting It All Together With a Repeatable Framework
Let's consolidate this into a checklist you can follow every time you run a rationalization audit:
- Export complete COGS data for every active SKU, including ingredients, packaging, labor, and tank time
- Calculate net revenue per SKU by channel, accounting for distributor margins, discounts, and returns
- Compute contribution margin per barrel and contribution margin percentage for each product
- Plot all SKUs on the volume vs. margin matrix to identify Stars, Cash Cows, Niche Winners, and Drains
- Apply the strategic overlay, scoring each SKU for channel importance, brand value, and customer segment relevance
- Set a minimum margin threshold and identify SKUs that fall below it
- Create a 90-day improvement plan for fixable SKUs and a discontinuation timeline for the rest
- Communicate changes to sales, distribution, and taproom teams with clear rationale
- Reallocate freed tank capacity, purchasing volume, and sales focus to top performers
- Schedule the next quarterly review
The breweries that consistently outperform their peers aren't necessarily making better beer. They're making better decisions about which beer to make. In a market where margins are under pressure and competition for shelf space is fierce, a disciplined approach to portfolio optimization separates businesses that grow from businesses that slowly bleed resources.
If your biggest barrier to running this audit is scattered data across spreadsheets, recipe cards, and accounting software, start by centralizing your production and inventory information. BrewPlanner's craft brewery platform is built specifically for operations like yours, connecting batch planning, inventory tracking, and cost data in one place so you can make confident decisions about your product lineup.
Your next rationalization audit doesn't have to be overwhelming. Start with the margin data, follow the framework, and let the numbers guide you to a leaner, more profitable portfolio.
