Every tank in your brewery has a cost. It takes up floor space, demands cleaning chemicals, ties up labor hours, and occupies time on your schedule that could go to another beer. So when a tank spends two weeks fermenting a hazy IPA that sells out in three days versus a saison that lingers on tap lists for a month, you're looking at two very different returns on the same physical asset.
Most brewery owners have a gut sense of which beers "do well." But gut sense isn't a financial strategy. Production data, when collected and analyzed properly, tells you exactly which beers earn their spot in your portfolio and which ones quietly drain margin from your operation. The difference between a brewery that grows profitably and one that stays stuck often comes down to this: treating every tank turn as an investment decision.
This guide walks you through a practical framework for using production data to rationalize your beer portfolio. You'll learn how to calculate true profit per tank turn, identify underperformers hiding behind strong top-line sales, and build a decision matrix that removes emotion from your lineup choices. If you're ready to move beyond spreadsheets and start making data-driven production decisions, BrewPlanner's craft brewery software gives you the tools to run this analysis without stitching together disconnected data sources.
Let's dig in.
Understanding Profit Per Tank Turn as Your Core Metric
Before you can rationalize your portfolio, you need one metric that levels the playing field across every beer you brew. That metric is profit per tank turn, sometimes called margin per occupied tank day. It's the single number that accounts for how much money a beer makes relative to how long it ties up your most constrained resource: tank capacity.
Here's why this matters more than gross margin alone. A barrel-aged stout with a 60% gross margin sounds like a home run. But if it occupies a fermenter for 45 days while your session lager with a 40% margin turns every 14 days, the lager generates substantially more profit from that same tank over a quarter. Volume, velocity, and margin all interact, and profit per tank turn captures that interaction in a single number.
Calculating the Number
The formula is straightforward:
Profit Per Tank Turn = (Revenue Per Batch - Total Batch Cost) / Tank Days Occupied
The tricky part isn't the math. It's getting accurate inputs. Let's break down each component:
Revenue Per Batch: This includes all channels. Taproom pints, crowler sales, distributor revenue, and any contract or collaboration income tied to that specific batch. If you sell a portion on draft and a portion in cans, capture both. Weight the revenue by actual sell-through, not projected sell-through.
Total Batch Cost: This goes beyond raw ingredients. A true cost-per-batch calculation includes grain, hops, yeast, adjuncts, water treatment chemicals, packaging materials, labor hours for brew day and packaging day, energy costs, cleaning chemicals, lab testing, and any batch-specific overhead like dry hop additions or fruit purees. If you want to go deeper on this topic, this guide on calculating true cost per batch walks through the methodology step by step.
Tank Days Occupied: Count every day from knock-out to clean-in-place completion. This includes fermentation, conditioning, dry hopping rest, carbonation, any time the beer sits waiting for packaging, and the CIP cycle afterward. Be honest here. If your team regularly lets a tank sit for two days before packaging because the canning line is booked, those days count.
Once you have this number for every beer in your portfolio, you can rank them. And rankings almost always produce surprises.
Where Breweries Get Tripped Up
The most common mistake is using incomplete cost data. If you're tracking ingredient costs but not labor, packaging, or tank time, your margin calculations will be skewed. A double IPA with expensive hops might look like it has slim margins until you realize it ferments fast and sells at a premium price point. Meanwhile, a mixed-fermentation beer with cheap ingredients but a 90-day tank hold is quietly destroying your throughput economics.
Another pitfall is ignoring shrinkage and waste. Yeast harvesting losses, trub, samples pulled for QC, and any dumped beer from off-flavor batches all reduce your effective revenue per batch. Track these losses batch over batch and fold them into your calculations.
Using inventory management software that tracks real-time stock levels and ingredient usage per batch eliminates the guesswork. When every grain bill, hop charge, and packaging run is logged against a specific batch number, your cost data becomes trustworthy enough to base real decisions on.
Building a Portfolio Scorecard That Reveals Hidden Underperformers
Ranking beers by profit per tank turn gives you a powerful starting point. But a single metric doesn't capture everything you need to make smart portfolio decisions. Some beers serve strategic purposes that don't show up in per-turn profitability. Your scorecard needs to account for these factors while still keeping financial performance front and center.
Here's a framework that balances hard numbers with strategic context.
The Four Columns Every Scorecard Needs
Create a table with every beer in your active portfolio. For each beer, populate four columns:
Beer NameProfit/Tank Turn/DayVolume VelocityStrategic ValueComposite ScoreFlagship IPA$82HighBrand anchorASession Lager$71HighTaproom stapleABarrel-Aged Stout$28LowEvent driverBHazy #7$64MediumHaze rotationBFarmhouse Saison$19LowBrewer passionCFruited Sour #3$12LowNone identifiedD
Column 1: Profit Per Tank Turn Per Day. This is the financial backbone of your analysis. Calculate it as described above. Normalize it to a daily figure so you can compare beers with wildly different fermentation timelines.
Column 2: Volume Velocity. How fast does this beer sell through once it's packaged or tapped? A beer that sits in your cold room for three weeks after packaging has hidden carrying costs. Rate each beer as High, Medium, or Low based on average days from packaging to complete sell-through.
Column 3: Strategic Value. This is the qualitative column. Does this beer serve a purpose beyond its direct margin? Valid strategic purposes include: brand anchor (your flagship that defines your identity), taproom traffic driver, competition medal winner that generates PR, seasonal release that creates excitement, or gateway beer that brings new customers into your brand. Be rigorous here. "The head brewer loves making it" is not a strategic purpose.
Column 4: Composite Score. Assign each beer a letter grade from A to D based on the combination of the first three columns. Beers that score high on profit per tank turn AND volume velocity are automatic A's regardless of strategic value. Beers that score low on financial metrics but have genuine strategic value get a B. Beers that score low on everything get a C or D.
According to Brewers Association economic impact data, craft breweries contribute significantly to local economies, but that contribution depends on individual brewery health. Running a disciplined portfolio analysis is how you protect your business and, by extension, the jobs and community impact your brewery supports.
What to Do With Each Grade
A-grade beers: These are your workhorses. Brew them more frequently. Consider increasing batch sizes if tank capacity allows. Invest in optimizing their recipes to shave cost without sacrificing quality.
B-grade beers: These earn their spot but need monitoring. Set a review trigger. If a B-grade beer's volume velocity drops for two consecutive batches, reassess its strategic value. If it was a medal winner and hasn't medaled again, it might be time to rotate it out.
C-grade beers: These are candidates for reformulation or retirement. Before cutting them, ask: could recipe changes reduce cost? Could a shorter fermentation schedule improve tank turn economics? Could a price increase be justified? If the answer to all three is no, move them to the retirement list.
D-grade beers: Cut them. Redirect those tank turns to A-grade and B-grade beers. Every batch of a D-grade beer is an opportunity cost, a batch of something more profitable that you didn't brew.
This is where emotion gets tricky. Brewers are creatives. Killing a beer feels personal. But the scorecard gives you an objective framework to point to, and it shifts the conversation from "I don't like that beer" to "the data shows this beer generates $12 per tank day while our average is $55."
Forecasting Demand and Optimizing Your Tank Schedule
Once you know which beers deserve priority, the next challenge is scheduling production to maximize tank utilization. Empty tanks don't make money. Tanks occupied by slow-selling beer don't make enough money. The goal is to keep your tanks as close to 100% productive utilization as possible, filled with your highest-scoring beers.
This requires demand forecasting, and it doesn't have to be complicated.
Simple Demand Forecasting for Craft Breweries
You don't need a PhD in statistics. You need historical sales data, broken down by beer and by channel, for at least the last six to twelve months. With that data, you can identify patterns.
Start by calculating your average weekly depletion rate for each beer. If your flagship IPA sells 30 barrels per week across all channels, and each batch produces 15 barrels, you need two batches per month just to keep up. Factor in your lead time (brew day to packaged and ready to sell) and you can work backward to determine when each batch needs to hit the fermenter.
Layer in seasonality patterns. Even without referencing specific months, you know your own trends. Lighter beers sell faster in warm weather. Dark beers pick up when temperatures drop. Festival season drives spikes. Use last year's depletion data to forecast this year's needs.
Here's a practical checklist for building your forecast:
- Pull 12 months of sales data by beer and channel
- Calculate average weekly depletion rate per beer
- Identify seasonal acceleration or deceleration patterns
- Factor in known events (festivals, anniversaries, holidays)
- Add a 10-15% buffer for unexpected demand spikes
- Map each beer's production lead time (brew to package-ready)
- Work backward from delivery dates to determine brew dates
Turning Forecasts Into Tank Schedules
With depletion rates and lead times mapped, you can build a production calendar that prioritizes your A-grade beers while fitting B-grade beers into open slots. Think of your tank schedule like a puzzle. Your highest-margin, fastest-turning beers get first claim on tank time. Everything else fills in around them.
Consider these optimization tactics:
Batch size alignment. If a beer consistently produces more than you can sell before it goes stale, brew smaller batches. If a beer sells out before your next batch is ready, increase batch size or increase brew frequency. Match production to demand as tightly as possible.
Stagger fermentation timelines. Schedule beers with different fermentation lengths so tanks free up on a rolling basis rather than all at once. This prevents the feast-or-famine cycle where your brewhouse sits idle because all fermenters are full, then suddenly everything is ready for packaging on the same day.
Reduce tank turnaround time. Every day between CIP completion and the next knock-out is wasted capacity. Track your average turnaround time and set a target. Even shaving one day off each turn adds up to significant additional capacity over a year.
BrewPlanner's brewery management software gives you a visual scheduling grid where you can drag and drop brewing orders across brewhouse, fermenter, and brite tank phases. You see conflicts immediately, identify idle gaps, and optimize your schedule without relying on whiteboards or spreadsheets that go stale the moment someone erases a note.
Connecting the Schedule Back to Portfolio Decisions
Here's where the loop closes. As you optimize your tank schedule around your highest-performing beers, you'll naturally discover capacity constraints. Maybe you have room for 24 fermentation cycles per month but you're running 28 beers in your portfolio. The math doesn't work. Something has to go.
This is the forcing function that makes portfolio rationalization tangible. It's not abstract strategy. It's a scheduling reality. When you can see on a calendar that brewing Beer X means you can't brew Beer Y, and Beer Y generates three times the profit per tank day, the decision makes itself.
Putting It All Together With a Quarterly Review Cycle
Portfolio rationalization isn't a one-time project. Markets shift, costs change, and customer preferences evolve. You need a recurring process that keeps your lineup aligned with profitability targets.
Build a quarterly review into your operations calendar. Here's what that review looks like in practice.
The Quarterly Portfolio Review Agenda
Step 1: Refresh your cost data. Ingredient prices change. Hop contracts get renegotiated. Energy costs fluctuate. Update your cost-per-batch calculations with current pricing. If you're tracking inventory and costs in a centralized system, this step takes minutes instead of days.
Step 2: Recalculate profit per tank turn. With updated costs and the latest sales data, regenerate your rankings. Compare this quarter's rankings to last quarter's. Which beers moved up? Which moved down? What changed?
Step 3: Update your scorecard. Reassess strategic value for each beer. Did your medal-winning beer fail to place at the last competition? Did a seasonal beer underperform its historical trend? Adjust grades accordingly.
Step 4: Make cut and add decisions. Based on updated grades, identify one or two beers to retire and one or two potential additions. Replacements should target underserved demand segments where you see growth potential. If your portfolio is heavy on IPAs and your taproom data shows increasing demand for lagers, that's a signal.
Step 5: Adjust your production forecast. Roll the changes into your tank schedule for the next quarter. Verify that your planned production aligns with projected demand and that your tank utilization stays optimized.
The breweries that win aren't the ones with the most taps. They're the ones that make the most money per tank, per day, per year.
For a deeper dive into the audit mechanics, this guide on running a SKU rationalization audit using margin data provides additional frameworks you can layer on top of the approach outlined here.
Common Objections and How to Handle Them
"But our customers expect variety." Variety matters, but 20 mediocre beers don't serve customers better than 12 excellent ones. Focus on variety within your top-performing styles. Rotate special releases through a dedicated "pilot" tap instead of giving every experiment a full production run.
"We can't cut beers that accounts are ordering." Look at the actual volume. If an account orders two cases per month of a beer that costs you $15 per tank day in opportunity cost, that account relationship isn't worth protecting at that price. Have an honest conversation with the account about transitioning to a higher-performing alternative.
"Our head brewer will revolt." Involve your brewer in the process from the start. Share the data. Most brewers are analytical thinkers who respond well to evidence. Frame it as: "We're freeing up tank time for you to brew more of what works and experiment more efficiently."
The path from gut-feel brewing to data-driven portfolio management doesn't require a massive investment in time or technology. It requires commitment to tracking the right numbers, reviewing them on a disciplined schedule, and making decisions based on what the data tells you rather than what feels comfortable.
If you're ready to see what your production data is actually telling you, schedule a demo with BrewPlanner and we'll show you how to set up profit-per-tank-turn tracking, build visual production schedules, and run portfolio reviews that drive real margin improvement.
