Your taproom has twelve beers on tap. Your distributor carries eight of your SKUs. Your retail accounts stock six. But here's the question that keeps smart brewery owners up at night: which of those SKUs actually make you money?
Not revenue. Not volume. Profit.
Most breweries track sales totals and maybe gross margin, but few dig deep enough to understand the true profitability of each SKU in their portfolio. The result? You keep brewing that double IPA with expensive hops because it "sells well," while your simple cream ale with a fraction of the ingredient cost quietly generates twice the profit per barrel. Without a structured SKU profitability analysis, you're making portfolio decisions based on gut instinct instead of data.
Building a real profitability framework isn't complicated, but it does require discipline. You need to capture the right cost inputs, allocate overhead fairly, and then use the results to make decisions that actually move your business forward. This guide walks you through the entire process, from gathering raw cost data to building the analysis that drives portfolio decisions with confidence.
If you haven't already nailed down your per-batch cost calculations, start with how to calculate true cost per batch in your brewery before diving into multi-SKU comparisons.
Gathering the Cost Inputs That Actually Matter
The biggest mistake breweries make with profitability analysis is stopping at ingredient costs. Yes, malt, hops, yeast, and adjuncts matter. But they typically represent only 25-35% of your total cost to produce a finished case of beer. If that's all you're tracking, you're working with a dangerously incomplete picture.
A complete SKU profitability model captures costs across four layers. Each layer adds accuracy and reveals surprises about which beers truly earn their place in your portfolio.
Layer 1: Direct Material Costs
This is where most breweries start, and rightfully so. For every SKU, you need a precise bill of materials that accounts for every ingredient, packaging component, and consumable that goes into a finished unit. That means grain, hops, yeast, water treatment chemicals, finings, and any adjuncts on the ingredient side. On the packaging side, you need cans or bottles, labels, carriers, case trays, shrink wrap, and even the CO2 used for purging.
The key word here is precise. Rounding your hop additions or estimating your label cost per unit introduces errors that compound across your entire analysis. Pull actual purchase prices from your most recent vendor invoices and calculate cost per unit of measure (per pound, per ounce, per thousand labels). When ingredient prices fluctuate, use a rolling average from your last three to five purchases rather than a single snapshot.
A practical example: Say your West Coast IPA uses 2.5 pounds of hops per barrel across five varieties. Don't average the hop cost. Price each variety separately. Citra at $22/lb hits differently than Cascade at $8/lb, and that difference matters when you're comparing this SKU to your amber ale that uses 0.6 pounds of $9/lb hops per barrel.
Layer 2: Direct Labor Costs
Every SKU consumes brewing labor differently. A simple lager that ferments for four weeks ties up a brewer's time during brew day, yeast pitch, diacetyl rest monitoring, and packaging. A barrel-aged stout with fruit additions requires all of that plus blending sessions, barrel work, and extra quality checks.
To capture labor accurately, estimate the total labor hours each SKU requires across its entire lifecycle: brewing, cellar work, packaging, and any special handling. Multiply by your fully loaded labor rate (hourly wage plus benefits, taxes, and insurance). For most craft breweries, the fully loaded rate runs 1.25 to 1.4 times the base hourly wage.
Don't forget packaging labor variance. Hand-canning a 16oz four-pack with a manual seamer takes dramatically more labor per case than running the same beer through an automated canning line. If you package different SKUs differently, those labor differences need to show up in your model.
Layer 3: Overhead Allocation
Here's where things get interesting and where most brewery profitability analyses fall apart. Overhead includes your rent or mortgage, utilities, equipment depreciation, insurance, software subscriptions, loan payments, and every other fixed cost that keeps the lights on. These costs exist regardless of what you brew, but they need to be allocated to each SKU to understand true profitability.
The simplest allocation method is per-barrel: divide your total monthly overhead by your total monthly barrel production, then assign that per-barrel rate to each SKU based on its production volume. This works for breweries where most beers follow a similar process.
A more accurate approach is to allocate based on tank-days. A beer that occupies a fermenter for 14 days consumes half the tank capacity of a beer that sits for 28 days. If your fermentation capacity is your bottleneck (and for most growing breweries, it is), tank-day allocation reflects the true opportunity cost of each SKU. Using a brewery management platform that tracks tank assignments and timelines makes this calculation straightforward instead of a spreadsheet nightmare.
Layer 4: Sales and Distribution Costs
The final layer captures what it costs to get each SKU from your dock to the customer's hands. Distribution margins, sales commissions, point-of-sale materials, sampling costs, and delivery expenses all vary by SKU and by sales channel. A keg sold through your taproom at full retail price has a very different cost profile than a case of cans sold through a distributor at wholesale.
Break your revenue and costs out by channel: taproom, self-distribution, distributor, and online (if applicable). You'll often find that a SKU which looks mediocre at the portfolio level is actually highly profitable in one channel and a money loser in another.
Building the Profitability Model Step by Step
With your cost inputs gathered, it's time to assemble them into a model that produces actionable numbers. The goal is a single view that shows you the true margin for every SKU, across every channel, so you can compare apples to apples.
Step 1: Define Your Unit of Analysis
Before plugging in numbers, decide on your standard unit. Most breweries use "per barrel" as their base unit since production is measured in barrels, but your sales team thinks in cases, kegs, or pints. The solution is to build your model per barrel and then create conversion factors for each package format.
For example, one barrel equals roughly 13.8 cases of 24x12oz cans, or about 6.9 cases of 24x16oz cans, or 1.94 half-barrel kegs. With these conversion factors, you can express profitability per barrel, per case, per keg, or per pint depending on your audience.
Step 2: Build the SKU Cost Card
Create a standardized cost card for each SKU. Think of it as a recipe card, but for money. Here's what a simplified version looks like for an example Hazy IPA:
Cost CategoryPer BarrelGrain & Adjuncts$38.50Hops$52.00Yeast & Nutrients$4.25Water Chemistry$1.80Packaging Materials (16oz 4-packs)$45.60Direct Labor$22.00Overhead (tank-day allocation)$35.00Total Cost Per Barrel$199.15
Now compare that to an example American Lager:
Cost CategoryPer BarrelGrain & Adjuncts$24.00Hops$6.50Yeast & Nutrients$3.00Water Chemistry$2.10Packaging Materials (12oz 6-packs)$32.40Direct Labor$18.00Overhead (tank-day allocation)$48.00Total Cost Per Barrel$134.00
Notice that the lager's overhead allocation is higher despite being a simpler beer. That's the tank-day allocation at work. A lager fermenting and lagering for 28 days consumes twice the tank capacity of an ale finishing in 14 days. This insight alone can reshape how you think about your portfolio.
Step 3: Layer in Revenue by Channel
For each SKU, map out your actual realized revenue per barrel across each sales channel, net of any distributor margins, discounts, or commissions. Then subtract your total cost per barrel to get your contribution margin.
SKUTaproom Margin/BBLDistributor Margin/BBLSelf-Distro Margin/BBLHazy IPA$310.85$80.85$160.85American Lager$266.00$96.00$146.00
In this scenario, the Hazy IPA wins in the taproom and on self-distribution routes. But the American Lager actually generates a higher margin through distributors because its lower price point moves more volume with fewer returns, and the lower production cost offsets the reduced revenue.
Step 4: Calculate Portfolio-Level Metrics
Individual SKU margins are useful, but portfolio decisions require portfolio-level thinking. Calculate these additional metrics for each SKU:
- Margin per tank-day: Contribution margin divided by total tank days required. This tells you how efficiently each SKU uses your most constrained resource.
- Annual volume-weighted margin: Multiply per-barrel margin by projected annual barrel volume. A lower-margin beer that sells 500 barrels a year may contribute more total profit than a high-margin beer that sells 50.
- Velocity score: How quickly does each SKU sell through at retail or in your taproom? High velocity means faster cash conversion and fewer stale inventory risks.
Tracking these metrics over time with a system that connects your order management and production scheduling removes the manual data wrangling that causes most breweries to abandon their profitability analysis after one or two attempts.
Turning Analysis into Portfolio Decisions
Numbers on a spreadsheet don't improve your business. Decisions do. The profitability model you've built is a decision-making tool, and it's most powerful when you use it to evaluate three types of portfolio choices.
Decision Type 1: What to Cut
Every SKU in your portfolio competes for limited resources: tank space, ingredient capital, brewer attention, sales team bandwidth, and shelf space at retail. A SKU that generates a below-average margin per tank-day while consuming significant resources is a candidate for elimination, regardless of how much your sales team loves it.
But don't just cut the lowest margin SKU blindly. Consider the portfolio effect. Some lower-margin SKUs serve as "gateway beers" that bring new customers into your brand, who then trade up to higher-margin offerings. Others fill a distributor's need for variety, and cutting them might cost you placements for your profitable SKUs.
The framework for cutting is straightforward: rank all SKUs by margin per tank-day, then flag any SKU in the bottom quartile. For each flagged SKU, ask three questions. First, does this SKU provide meaningful volume that covers fixed overhead? Second, does it serve a strategic role in customer acquisition or retail placement? Third, could the tank capacity it frees up be allocated to a higher-margin SKU that has unmet demand? If the answers are no, no, and yes, you have a clear cut.
For a deeper look at this process, the guide on running a brewery SKU rationalization audit using margin data walks through the full evaluation criteria.
Decision Type 2: What to Grow
The flip side of cutting is doubling down on your winners. Your profitability model will likely reveal one or two SKUs that outperform across nearly every metric: high margin per barrel, high margin per tank-day, strong velocity, and good performance across multiple channels.
For these SKUs, the question isn't whether to grow them. It's how. Can you increase production without hitting capacity constraints? Can you expand distribution to new markets? Can you create line extensions (a different package format or a variant) that capitalize on the brand equity of your top performer?
The profitability model helps you project the impact. If your top SKU generates $160 margin per barrel through distribution and you can add 200 barrels of annual volume by entering a new market, that's $32,000 in incremental profit before any growth investment. Compare that to the cost of a new distributor relationship, additional sales support, and marketing spend to decide if the investment pencils out.
Decision Type 3: What to Fix
Some SKUs land in the middle of your profitability ranking, not bad enough to cut but not strong enough to celebrate. These are your optimization opportunities. For each mid-tier SKU, your cost card reveals exactly where the margin pressure comes from.
Maybe your porter's ingredient cost is reasonable but its overhead allocation is high because of a 21-day fermentation schedule. Can you adjust the recipe or process to finish in 16 days without sacrificing quality? Maybe your session IPA has great production economics but underperforms in the taproom because it's priced the same as your flagship IPA. A $1 price increase per pint on a beer that sells 40 pints a week adds over $2,000 in annual taproom revenue with zero additional cost.
These incremental fixes, applied across multiple SKUs, often generate more total profit improvement than a single dramatic portfolio change.
Keeping Your Analysis Alive and Actionable
The most dangerous profitability analysis is one you build once and never update. Ingredient prices shift, package costs change, labor rates increase, and your sales mix evolves month to month. A static model becomes a misleading model faster than you'd expect.
Build a rhythm for updating your analysis. Monthly is ideal, but quarterly works if your portfolio and pricing are relatively stable. The update process doesn't need to be painful if your underlying data is clean. Start each update by refreshing your ingredient costs from recent purchase orders, updating labor rates if they've changed, and recalculating overhead allocation based on actual production volume.
Track your key metrics over time in a simple trend view. Are your top SKUs maintaining their margins, or are rising hop costs eroding profitability? Is a mid-tier SKU improving after you adjusted its process? Did cutting that underperformer actually free up capacity that got reallocated to something better?
The breweries that get the most value from profitability analysis are the ones that make it part of their regular planning cycle. They review the numbers before finalizing their production schedules, they reference margins during pricing discussions, and they use portfolio-level data to guide capital investment decisions like new tanks or packaging equipment.
Start simple. Get your direct costs right for your top five SKUs. Add overhead allocation. Layer in channel-level revenue. Then expand to your full portfolio. Within a few cycles, you'll wonder how you ever made portfolio decisions without this clarity. And your bottom line will reflect the difference.
The brewery that knows its numbers doesn't just survive, it chooses where to grow.
Ready to connect your production data, inventory costs, and order management into a single system that makes SKU profitability analysis painless? Start organizing your brewery operations with BrewPlanner and build the foundation for data-driven portfolio decisions.
