Systems Case Study 02 // Perishable Supply Chains & Bottleneck Engineering

The Brew Box: Scaling Artisanal Canned Coffee Past the 200-Can Capacity Wall

Brew Box Official Logo

How I diagnosed physical extraction constraints, engineered an 18-row dynamic BOM waterfall, modeled 6-channel demand crosstalk, and designed a perishable scheduling platform that unlocked a 4x production scale (400 to 1,600 cans/wk) across Michigan City, Hammond, and La Porte.

Client / Subject Michelle Tagler (The Brew Box)
Regional Network Michigan City, La Porte, Hammond
Primary Physical Constraint 2 Espresso Shots / 72h Quality Window
Modeled Financial Outcome +$20,654/mo Net Profit (+469%)
4x Production Scale Scaled from 400 cans/wk to 1,600 cans/wk across three regional pickup hubs.
+$248k Annual Net Cash P&L model expands annualized net run-rate cash from $52.8k to $300.6k.
-47% Unit Labor Cost Decoupled prep from retail drag, dropping direct labor from $0.90 to $0.48/can.
5.8 Mo Capex Payback Full $10,200 automated canning suite paid back in under six operating months.

The Three Interlocking Operational Bottlenecks

Michelle Tagler operates a beloved craft coffee brand selling canned lattes and cold brews. At local weekend farmers markets, she brought 200 cans per market day (400 cans total) and routinely sold out hours before closing. Demand was overwhelming, but operations were paralyzed by three structural bottlenecks:

Constraint 01

The 200-Can Daily Prep Ceiling

Prepping inside her Michigan City retail location with manual equipment limited production to 200 cans/day. Weekly production was physically capped at 400 cans, forcing her to reject lucrative hotel and corporate accounts.

Constraint 02

The 40% Retail Multitasking Drag Factor

Running the Michigan City storefront while simultaneously canning introduced a 40% labor drag coefficient. A 6-hour canning run stretched into 8.5–9 hours of chaotic, fragmented work that disrupted walk-in customer service.

Constraint 03

The 72-Hour Freshness Window & 2-Shot Thermal Constraint

Zero chemical preservatives meant flavor peak begins degrading after 48–72 hours. Furthermore, each latte required 2 freshly pulled espresso shots, creating an extreme extraction and chilling bottleneck.

Dual-Build Financial Model & 18-Row P&L Waterfall

To evaluate Michelle's expansion options, I modeled three operating architectures across an 18-row P&L waterfall: continuing inside the Michigan City café (As-Is), leasing commissary prep space from Downtown Delights (La Porte), and scaling to a turnkey automated canning line with 6 demand channels:

Financial Metric Build 1: MC Café (As-Is) Build 2: Commissary Hub (LP) Scaled Turnkey (6 Levers) Variance / Strategic Driver
Weekly Volume Output 400 cans / week (Ceiling) 800 cans / week 1,600 cans / week +300% Total Volume Scale
Gross Monthly Revenue $11,267 / mo $22,533 / mo $45,067 / mo +$33,800/mo incremental revenue
Direct Material COGS (BOM) $1.98 / can ($3,432/mo) $1.98 / can ($6,864/mo) $1.98 / can ($13,728/mo) Beans ($0.58), Dairy ($0.32), Syrups ($0.55), Cans ($0.47), Labels ($0.06)
Production Spoilage & Purge $451 / mo (4.0% decay) $406 / mo (1.8% decay) $541 / mo (1.2% JIT decay) JIT scheduling cuts batch decay loss from 4% down to 1.2%
Direct Labor per Can $0.90 / can (1.45x retail drag) $0.55 / can (1.0x commissary flow) $0.48 / can (Pneumatic seamer) -47% Unit Labor Reduction
Monthly Direct Labor Total $1,560 / mo (78.0 hrs) $1,907 / mo (95.3 hrs) $3,328 / mo (166.4 hrs) Reclaims 87 hours/mo through equipment cycle time drops
Total Direct Production Cost $2.98 / can ($5,165/mo) $2.58 / can ($8,944/mo) $2.50 / can ($17,328/mo) Margin expands from 54.2% to 61.5%
Gross Contribution Margin $6,102 / mo $13,589 / mo $27,739 / mo +$21,637/mo gross profit expansion
Facility Rent & Cold Storage $875 / mo (Shared counter) $1,250 / mo ($950 lease + $300 util) $1,600 / mo (Hub + cold bay) Dedicated commissary uncouples prep from retail hours
Inter-Store Chilled Route Logistics $0 (Local walk-up only) $550 / mo (Tri-hub shuttle) $950 / mo (Daily multi-drop route) Connects Michigan City (0h), La Porte (+2h), & Hammond (+6h)
Equipment Amortization & Maint. $0 / mo (Manual tools) $475 / mo $475 / mo Full $10,200 equipment suite paid off in 5.8 months
NET MONTHLY PROFIT (EBITDA) $4,401 / mo $13,322 / mo $25,055 / mo +$20,654 / mo (+469% EBITDA Lift)
ANNUALIZED RUN-RATE NET PROFIT $52,812 / yr $159,864 / yr $300,660 / yr +$247,848 / yr net cash generation

6-Channel Demand Matrix & Crosstalk Simulation

To break through the weekend-only sales plateau, I designed and simulated 6 discrete demand channels with dynamic crosstalk, cannibalization guardrails, and production leveling:

Lever 01 // Advance Ordering +320 Cans / Wk

Online Catering Pre-Orders (Events & Corporate)

Hypothesis

Event hosts will pre-pay for 24-can flats if guaranteed 24–48h freshness with multi-hub pickup.

Crosstalk Interaction

Thursday AM production dedicated to weekend catering prevents Saturday morning market prep bottlenecks.

Lever 02 // Sellout Relief +160 Cans / Wk (Net +120)

Farmers Market VIP "Skip-the-Line" Reserve

Hypothesis

Captures the 35% of market attendees who arrive after 11:00 AM and leave disappointed due to early sellouts.

Cannibalization Shielding

-40 walk-up cans eroded if pre-reserves exceed 200 cans. Mitigated by physical express table separation.

Lever 03 // Demand Smoothing +220 Cans / Wk

Corporate & Medical Office B2B Tuesday Drops

Hypothesis

Regional medical practices and law offices will subscribe to recurring Tuesday AM fresh cold brew drops.

Schedule Smoothing

Fills low-demand Tuesday and Wednesday production slots, lifting weekday leveling index to 52%.

Lever 04 // Retail Syndicate +180 Cans / Wk

Downtown Delights Dessert Pairing & Affogato

Hypothesis

Pairing canned espresso with Downtown Delights artisan ice cream (affogato floats) creates evening cross-sales.

Lease Synergy

Offsets Downtown Delights commissary rent while utilizing evening retail foot traffic (4:00 PM – 9:00 PM).

Lever 05 // Basket Size +140 Cans / Wk

Multipack Bundling & Seasonal Limited LTOs

Hypothesis

Offering 4-pack and 6-pack carrier boxes with rotating seasonal flavors lifts Average Order Value by 42%.

Halo Discovery

+8% catering spillover as retail multipack buyers subsequently book corporate party catering.

Lever 06 // Commuter Outpost +120 Cans / Wk

Hammond Commuter Grab-and-Go Outpost

Hypothesis

South Shore Line rail commuters in Hammond will grab chilled specialty canned lattes during morning rush.

Logistics Buffer

Requires +6h courier transit schedule; cans pre-staged via Monday/Wednesday evening route runs.

Dynamic Crosstalk & Schedule Smoothing Engine

Multi-channel demand cannot be evaluated in isolation. I engineered dynamic behavioral models to protect gross margins against unintended channel friction:

Cannibalization Shielding
When VIP Mobile Reserve exceeds 200 cans/wk, walk-up market sales decay at -0.25 cans per excess VIP can due to customer substitution. The model enforces physical queue segregation to protect high-margin impulse sales.
Weekday Demand Smoothing (52% Balance)
Shifting B2B corporate drops (Tuesday) and wholesale dessert inventory (Wednesday) smooths the traditional "prep cliff" from 85% weekend concentration down to a sustainable 52% weekday leveling index.

Time-and-Motion Bottleneck Audit & Equipment ROI

Every canned latte requires 2 fresh espresso shots. On a 2-group machine, pulling 100 cans requires 53.3 minutes of continuous extraction alone. Adding manual single-can seaming and ice water bath dwelling brought total manual cycle time to 2.5 hours per 100 cans.

Equipment Upgrade Replaced Manual Bottleneck Capital Capex Monthly Labor Saved Payback Period
Oktober Model 8 Pneumatic Seamer Manual hand-crank seamer (4 cans/min ➔ 18 cans/min) $2,850 19.2 hrs / mo ($384) 7.4 Months
Inline Sanitary Glycol Plate Chiller Ice water bath dwell (15m dwell ➔ 0m inline 165°F to 36°F) $1,200 15.0 hrs / mo ($300) 4.0 Months
Batch Espresso Extraction System Manual portafilter pulling (53m pull ➔ 12m batch extraction) $4,500 40.8 hrs / mo ($816) 5.5 Months
COMPLETE TURNKEY CANNING SUITE Full Automation Line (100 Cans in 32 Minutes) $10,200 87.0 hrs / mo ($1,740) 5.8 MONTHS

Dynamic Earliest Pickup Date Algorithm

To prevent selling stale cans and guarantee unyielding quality, I architected the Dynamic Earliest Pickup Date Algorithm. It evaluates physical brewing capacity, supplier packaging lead times, perishable freshness windows, and multi-hub transit buffers in real time:

EarliestDate = min { D ∈ CalendarDays | CapacityAvailable(D) ∧ IngredientLeadTime(D) ∧ FreshnessEnvelope(D) ≤ 72h } + TransitBuffer(Location)

The engine dynamically accounts for direct walk-in pickup at The Brew Box Michigan City (0h buffer), +2h shuttle transit to Downtown Delights (La Porte), and +6h courier route to Hammond, preventing overbooking on peak roasting days.

Brew Box OS // Interactive Operations & Financial Simulator (v3.1)