Excess and obsolete (E&O) stock is cash you already spent and sales you will not make. Here is how to find it early and cut it without creating stockouts.
Excess and obsolete inventory, usually shortened to E&O, is stock that demand will not justify. Excess is stock you hold well beyond what near-term demand needs: more months of cover than the item warrants. Obsolete is stock with no remaining demand at all, discontinued lines, superseded parts, expired lots. The two sit on a spectrum: today's quiet excess is next year's write-off if nobody acts. Both are the same thing in cash terms, money you already spent that is not coming back as a sale on its current path.
E&O is rarely one bad decision; it is the quiet sum of small ones. Forecast bias that runs consistently high pads every order. Supplier minimums (MOQs) force you to buy more than you need to hit a price break. Promotions and launches leave a tail of unsold units. Product lifecycles end faster than the purchasing cadence reacts. And safety stock set years ago and never revisited keeps buffering demand that has since moved. Each looks harmless; stacked across thousands of SKUs they become the single biggest pool of trapped cash a mid-market company carries.
The mistake is waiting for the annual write-off review, by which point the stock is already dead. The better approach is to flag items heading for trouble while they can still be sold, using a few simple signals: months of coverage (how long current stock lasts at the current sales rate), stock age, and a demand trend that is bending down. An item with 30 months of cover and falling sales is a pre-obsolescence case today, not a surprise next December.
Take a SKU that holds 1,200 units and sells 40 a month. Its coverage is 1,200 / 40 = 30 months. If your policy says anything beyond 12 months of cover is excess for this class of item, then 12 months of cover is 480 units; the other 720 units are excess. At a unit cost of $15, that is 720 × $15 = $10,800 of cash tied up in a single SKU, on a line that is not even obsolete yet. Run that calculation across the catalogue and the pattern, not any single item, is where the money is. Catching it at 30 months of cover, while the item still sells, is the difference between a managed drawdown and a write-off.
Once flagged, excess clears through four levers, in order of value. Stop feeding it: right-size the reorder point and challenge the MOQ, so you stop adding to the pile; this alone solves most future E&O. Redeploy: move stock to a site or channel where it still sells before you discount it. Promote or discount early, while the item has value, rather than deep-marking a dead item later. Write off last: disposal is the lever of final resort, not the first move. The order matters, every step to the left recovers more value than the one to its right.
Clearing today's E&O without fixing the inflow just refills the shelf. Prevention comes from three habits: size safety stock on each item's real forecast error and lead-time variability rather than a round number, so buffers stop silently becoming excess; model the end of a product's life in the plan instead of reacting to it; and run the monthly S&OP discipline that catches building coverage before it hardens. The goal is a system where excess is caught at the coverage-ratio stage, every month, not discovered at the annual count.
Three numbers keep E&O honest. E&O as a percentage of total inventory value tells you the size of the problem and whether it is shrinking. Days of inventory outstanding (DIO) tells you how long cash sits in stock overall. And the write-off rate, the share of inventory destroyed or disposed each year, tells you how much you are failing to catch early. Watch all three over time; a program is working when E&O percentage and write-off rate fall while service holds.
Excess is stock beyond what near-term demand needs but still sellable; obsolete is stock with no remaining demand, discontinued, superseded or expired. Excess becomes obsolete if it is not acted on, which is why catching it early matters.
Compare each item's months of coverage (current stock divided by the current demand rate) against the coverage you intend to hold for that class of item. Anything above that threshold is excess; multiply the excess units by unit cost to size the cash tied up.
It varies by industry and product mix, so the useful target is a falling trend rather than a universal number. Track E&O as a percentage of total inventory value and aim to reduce it each quarter while holding service. Perishable and short-lifecycle sectors will run tighter than long-life industrial parts.
Yes, if you clear it item by item against each item's own demand, not with an across-the-board cut. Blanket reductions trim steady and volatile items alike and cause stockouts on the products that earn. Right-sizing per item releases the excess while protecting, or improving, service.
The cheapest write-off is the one you prevent at thirty months of cover, while the item still sells.
Picture your next S&OP meeting: one number on screen that nobody argues with. See it free, on your own data, in 45 minutes; and if it does not hold up, we part as friends.