A plumbing supplies distributor with locations in three cities called me in a panic. Sales were up 35% year over year, but net profit was flat. Nobody could explain why.
Each warehouse ordered its own stock, kept its own records, and answered to its own manager. The owner had to phone three people to find out how much total inventory they held. Even then, the answers didn’t quite add up.
Here’s the thing about growth: it hides disorder. When you’re small, you can keep everything in your head. Add a second and third location, and suddenly the left hand doesn’t know what the right hand is buying.
The specific mess we uncovered
One warehouse was sitting on 90 days of a certain copper fitting. Another warehouse, 400 miles away, was paying a premium for a rush order of the exact same fitting. That waste alone was roughly $15,000 a year.
And it wasn’t the only one. I counted eleven items where two locations were both overstocked while occasionally emergency-shipping from each other.
The root cause was simple: each location was measured on its own inventory and its own sales. There was no incentive to share or to think about the company’s total cash. This fragmented thinking is the first thing ERP Consulting challenges, because software can’t fix a culture that rewards hiding.
- Stop measuring each warehouse’s inventory accuracy in isolation—measure the company’s total stock value and the number of inter-warehouse transfers that actually happened
- Make one person responsible for “slow-moving capital,” the dollars sitting on shelves that haven’t moved in 90 days, and review that number every Monday
- Before any purchase order above $5,000, require a quick check of stock levels at all other locations
What happens when the numbers finally line up
We put all three locations on one connected view. For the first time, the owner could see total company stock across all sites with one log-in. Within two months, they found $190,000 in unnecessary inventory. They sold off the excess, used the cash to pay down their credit line, and stopped the premium freight nonsense almost entirely.
But the quieter win was even bigger. The warehouse managers started talking to each other. One discovered the other had a crew with spare capacity, and they started swapping labor instead of both paying overtime. That’s the kind of collaboration that can’t be forced by an email from headquarters; it only happens when everyone’s looking at the same numbers.
When to call for help
The signal that you’ve outgrown your spreadsheets is simple: it takes you more than ten minutes to answer “how much total inventory do we own right now, in dollars, across all locations?” If you can’t answer that instantly, you’re flying blind.
I’ve seen this scenario play out in food, hardware, apparel, auto parts, you name it. The solution always involves the same two steps: standardize how every location counts and categorizes its stock, then put the numbers in one shared place. That’s precisely where ERP Consulting earns its keep—not in teaching you software, but in forcing the discipline to make the data comparable. Start by making all your locations use identical product names and units; you’d be shocked how often “1 box” in one warehouse means “12 units” in another.