Stonebarrow Brewing
Brewing production, fermentation, taproom retail, and wholesale
About Stonebarrow Brewing
Industry
Craft Brewery
Production scale
About 13,000 barrels brewed per year across 386 fictional brew batches, the cadence starting three weeks before the window so packaging runs at full rate from day one.
Beer lineup
16 house beer styles spanning IPAs, lagers, pale and amber ales, a porter, stouts, a wheat, a saison, and a blonde.
Packaging
Roughly 420,000 sellable units packaged across 10 keg, can, bottle, and taproom-fill formats, at about a 93 percent packaging yield. The 14 newest batches are still in tank at the window close and carry no packaging runs yet.
Sales reach
120 wholesale accounts across four territories plus a busy on-site taproom running about 137,000 tickets over two years.
Wholesale revenue
Just under $8.0M in two-year wholesale revenue, the larger of the two channels.
Taproom revenue
About $7.1M from the taproom over two years, roughly 47 percent of the combined total.
Combined scale
Around $15.0M across both channels over the two-year window, near $7.5M per year.
Stonebarrow Brewing is a fictional regional craft brewery used for synthetic BI analysis. The company story follows beer from the brewhouse through fermentation and conditioning, into kegs, cans, and bottles, and then out to guests in the on-site taproom and to wholesale accounts like bars, restaurants, and bottle shops. Everything here is invented for analytics practice. No real brewery, beer brand, taproom, distributor, account, or person is represented, and the beer-style names and region names are fictional.
Operating Profile
- Brews on a main brewhouse plus a smaller cellar system and a pilot system, tracking each batch by style, brewhouse, gravity, and barrels.
- Monthly fermentation snapshots follow batches through tank volume, gravity, temperature, and stage from active fermentation to conditioning to ready to package.
- Packaging converts finished batches into kegs, cans, bottles, and taproom fills for sale through the taproom and wholesale program.
- Excludes raw-material purchasing ledgers, supplier invoices, water chemistry, lab microbiology, compliance filings, and full ledger.
Recent Business Events
- 1The taproom is an executive focus: warm-month and holiday visits drive strong direct revenue while late-winter visits pressure staffing.
- 2Cans carry 52 percent of wholesale revenue on 45 percent of the volume while kegs carry 54 percent of the volume, so canning and keg capacity compete.
- 3Leadership wants one view connecting brewing production, fermentation, packaging, taproom retail, and wholesale demand.
These are the operating questions this kit is optimized to answer first.
Barrels brewed and packaged by beer style, category, and brewhouse
Fermentation tank volume, gravity, temperature, and stage by batch and tank
Packaging units and volume by format, and the keg versus can versus bottle mix
Taproom revenue, tickets, and pour volume by style, serving type, and daypart
Wholesale revenue, units, and volume by account type, territory, and package
Embedded Analytical Stories
Two demand seasons
Taproom revenue peaks in summer and the holidays while wholesale builds into its steadier autumn lift.
Chain that narrows
Brewed barrels exceed packaged barrels, which exceed volume sold, for every style and package format.
Lineup spread
Flagship IPAs and the pilsner carry the most volume while seasonal and limited styles fill out the lineup.
Cellar pipeline
Gravity, temperature and tank volume all fall together as a batch moves from active fermentation through conditioning to ready to package.
Wholesale mix
Kegs lead on-premise and cases lead off-premise across bars, restaurants, bottle shops, grocery, and venues.