Start with the number: $2.3 million. That was the value of inventory in one distributor’s warehouse that had not moved in 400 days or more. It occupied 19% of their rack space and generated zero revenue.
The owner knew some of it was old. He guessed $300,000. When we pulled the aging report and walked the aisles together, confirming the real figure took four hours and made him quiet for the rest of the afternoon.
How dead stock hides in plain sight
Dead inventory doesn’t announce itself. It sits on the top rack, behind the fast movers, in packaging that still looks current. Their system tracked when items came in, not when they last went out, so most of that pile showed a “last received” date nobody ever questioned.
Meanwhile, the buying team kept reordering off minimum and maximum rules nobody had touched since the business was half its current size. Twelve percent of their purchase orders were for items that had not sold a single unit in the prior year.
The 12-month rule that changed buying behavior
- Any item with zero sales in 12 months gets flagged automatically and frozen from reordering.
- Any item with zero sales in 24 months gets a decision deadline: discount, bundle, return to vendor, or write off.
- Buyers see the flag before they can approve a purchase — no override without a written reason.
- The monthly purchasing review opens with the dead-stock list, not the sales list.
That last one matters more than it sounds. Their Monday purchasing meeting used to start with what was selling. Now it starts with what isn’t. Within two quarters, dead stock dropped from $2.3 million to $740,000 without a single layoff or fire sale.
What to do with the stock you already own
You can’t flag your way out of inventory you already bought. But you can stop pretending it’s an asset. This is the unglamorous half of ERP Consulting: nobody wants to book a $310,000 write-off, yet that’s what makes the remaining numbers believable.
- Still sellable but slow: bundled with a fast mover at a small discount. Recovered about 60 cents on the dollar.
- Obsolete but usable: sold to a competitor in an adjacent region who still serviced that older equipment line.
- Damaged or expired: written off in one clean entry so the balance sheet told the truth.
- Genuinely unknown: quarantined in one aisle, priced at cost, reviewed quarterly.
The write-off freed 1,400 square feet of rack space. They canceled a warehouse expansion that would have cost $480,000. That trade alone paid for the cleanup twice over.
Run your aging report sorted by last-ship date, not last-received date. Most systems can do it. If yours can’t, that’s the first thing worth fixing, and an ERP Consulting engagement usually surfaces it in week one.