ERP Consulting: Why a $12 Million Distributor Counted 41,000 Missing Widgets

It was a Friday at 4:15 pm. The warehouse manager at a $12 million industrial parts distributor opened bin R-34, expecting to find 380 stainless steel widgets. The bin was empty, but the computer said the inventory was exactly where it should be.

That single mismatch turned into a three-week investigation. It ended with 41,000 units unaccounted for — roughly $230,000 in missing or misstated stock.

Where the widgets actually went

The team running the ERP Consulting engagement started by pulling the transaction history for those 41,000 units. What they found was not theft. It was something more common and more fixable: inventory was moving in four places nobody had bothered to record.

  • Receiving clerks signed for deliveries and put stock straight to the shelves without scanning — the system never knew the goods arrived.
  • Sales reps handed out free samples to win orders, and nobody wrote those units off.
  • Customers returned damaged parts that the front desk accepted without a return slip, so the units vanished from the records.
  • The owner “borrowed” parts for a personal project in year one, and the staff quietly followed that example ever since.

What changed when the counts became real

The ERP Consulting team didn’t install a fancy tracking system. They made three simple rules and enforced them for 30 days.

Every inbound pallet gets scanned within two hours of arrival. Every sample, return, and damage gets a stock movement code before the item leaves the dock. Every bin gets a blind count every month — the counter doesn’t see the system number until after they write theirs down.

The messiest part was the first count. It took 18 people and a Saturday to count the whole warehouse. The second month took four hours.

The number that matters

Inventory accuracy climbed from 72 percent to 98.5 percent in eleven weeks. The purchasing manager stopped ordering parts that were already sitting in the back corner, which cut the next month’s purchase total by 19 percent.

Here is your action for this week: pick fifty random bins and count them blind. If more than ten don’t match the system, you have the same problem this distributor had. The exact fix will depend on where your stock is leaking, but the first step is always the same — stop trusting the screen until the shelf agrees with it.

Run this test before you spend a dollar on more software. ERP Consulting can help you map the leaks, but the count is yours to do.