When we scaled our bar network one thing became obvious: growth doesn’t break sales — it breaks control.
And because 75% of our entire revenue came from draft beer, the smallest deviation in pour size was driving real money out of the business.
For context: each bar ran 15+ taps on average and moved 4–5 tons of beer a month. Across the whole network, that translated into $4.1M in annual revenue which is over 500,000 pints a year. At that scale, even a half-centimeter overpour turns into real money.
The Problem: Traditional Inventory Doesn’t Scale Before we introduced a new system, we ran inventory checks twice a month across all locations. That process cost us:
176 hours of on-site staff time (2 people × 4 hours × 2 checks month × 11 bars) ~55 hours of the inventory accountant 6 hours of the head accountant → 237 labor hours every month
And despite all of that, our stock variance stayed at 4–7% and we only saw discrepancies 16–17 days later, long after the damage was done.
This system was fundamentally not compatible with scale.
The Breakthrough: A Custom Two-Warehouse Logic Inside the ERP Out of necessity, I built a custom workflow that the ERP wasn’t designed for. We virtually split each bar’s warehouse into two:
Storage Warehouse Sales Warehouse
All connected kegs lived in the Sales Warehouse. All unopened kegs lived in Storage.
Whenever a new keg was tapped:
the manager made a mark in a simple log (paper → synced to Google Sheets), the ERP registered a movement from Storage → Sales,
When a keg ran out, the Sales Warehouse was supposed to hit zero. If it didn’t, we had an immediate signal that something was off.
The effect: Every tap of a keg became a micro-inventory check. Across 11 locations. Every day. Automatically.
The accounting team saw accurate stock numbers the next morning, not two weeks later.
The Result: Real-Time Control and Zero Variance After rolling out the system:
stock variance dropped from 4–7% to 0%, we consistently stayed within our 2.5% internal waste benchmark, senior managers and accountants no longer spent hours on reconciliation, data lag went from 17 days → 1 day, scheduled inventory checks became completely unnecessary.
We still ran random spot checks early on to validate the workflow and everything matched.
The Economics: 14% Payroll Savings + 237 Hours of Work Removed This single operational change removed:
237 hours of recurring monthly labor, eliminated an entire class of operational risk, and reduced the network’s total payroll costs by 14%, without buying new software, hiring more people or implementing automation.
Just restructuring the logic inside the ERP and redesigning the process.
Why This Matters This experience taught me a lesson that applies far beyond hospitality:
Scale breaks every process that isn’t designed for it.
The fastest wins often come from:
process architecture over brute force. transparency over assumptions. simple systems that compound over time. real-time data → real-time decisions.
This was one of the clearest cases where operational design outperformed both additional tooling and additional headcount.