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.
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:
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.
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.
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.
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 |
To break through the weekend-only sales plateau, I designed and simulated 6 discrete demand channels with dynamic crosstalk, cannibalization guardrails, and production leveling:
Event hosts will pre-pay for 24-can flats if guaranteed 24–48h freshness with multi-hub pickup.
Thursday AM production dedicated to weekend catering prevents Saturday morning market prep bottlenecks.
Captures the 35% of market attendees who arrive after 11:00 AM and leave disappointed due to early sellouts.
-40 walk-up cans eroded if pre-reserves exceed 200 cans. Mitigated by physical express table separation.
Regional medical practices and law offices will subscribe to recurring Tuesday AM fresh cold brew drops.
Fills low-demand Tuesday and Wednesday production slots, lifting weekday leveling index to 52%.
Pairing canned espresso with Downtown Delights artisan ice cream (affogato floats) creates evening cross-sales.
Offsets Downtown Delights commissary rent while utilizing evening retail foot traffic (4:00 PM – 9:00 PM).
Offering 4-pack and 6-pack carrier boxes with rotating seasonal flavors lifts Average Order Value by 42%.
+8% catering spillover as retail multipack buyers subsequently book corporate party catering.
South Shore Line rail commuters in Hammond will grab chilled specialty canned lattes during morning rush.
Requires +6h courier transit schedule; cans pre-staged via Monday/Wednesday evening route runs.
Multi-channel demand cannot be evaluated in isolation. I engineered dynamic behavioral models to protect gross margins against unintended channel friction:
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 |
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:
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.