Managing Inventory Obsolescence

Inventory obsolescence is stock you can no longer sell or use at its normal value because demand, design, or shelf life has moved past it. Excess-and-obsolete (E&O) inventory ties up cash, fills warehouse space, and eventually becomes a write-off you book against profit.

Every plant and warehouse carries a quiet, growing pile of parts nobody will ever use: components for a product you stopped building, raw material bought for a promotion that fizzled, finished goods that aged past their date. That pile does not announce itself. It sits in a bin, counted as an asset, until an auditor or a year-end review forces the write-off. This post covers how to spot excess and obsolete inventory early, how to set a reserve so the hit is smoothed instead of sudden, and how phase-out planning keeps stock from aging into a total loss.

What is inventory obsolescence?

Inventory obsolescence is the loss of an item's value because it can no longer be sold or consumed as intended. Practitioners usually pair it with a sibling problem under one label, excess and obsolete (E&O) because the two travel together. Excess stock is still usable but far exceeds any realistic demand, so a share of it will likely never move. Obsolete stock has crossed a harder line: it is superseded by a new design, expired, or attached to a product that no longer exists. Excess is a probability of loss; obsolete is a realized one.

Items rarely jump straight from active to dead. They slide. A fast mover slows as demand tapers, becomes slow-moving, then non-moving, then excess, and finally obsolete once there is no path back to normal use. Catching an item on that slide, while it is still slow-moving and can be sold at a discount or returned to a supplier, is worth far more than discovering it at the bottom as scrap.

How do you flag excess and obsolete inventory?

You flag it with aging and usage data, not with a walk through the racks. The signal is simple: an item with plenty on hand and little or no recent movement is a candidate, and the longer it sits, the stronger the case. Run this as a standing procedure, monthly or quarterly, so the list stays current instead of surfacing once a year at count time.

1. Pull days-since-last-issue for every SKU. The single most useful field is when the item last moved. No movement in 6, 12, or 24 months is your first filter.
2. Compare on-hand to forward demand. Divide quantity on hand by average usage to get months-of-supply; anything holding years of stock is excess whether it moved recently or not.
3. Flag design and lifecycle triggers. An engineering change, a product end-of-life, a lost customer, or a passed expiration date converts stock to obsolete instantly, ahead of any aging clock.
4. Score each candidate by recoverable value. Separate items you can still return, rework, or discount from items that are only worth scrap, because the two get very different actions.
5. Assign an owner and a disposition. Every flagged item needs a decision, return to vendor, discount, reuse, donate, or scrap, and a name attached to it, or the list just grows.
6. Feed the reserve. Roll the flagged value into the obsolescence reserve so the financial picture updates as the operational one does.

Pair this with an ABC analysis so effort lands where the dollars are: a high-value A item going stale deserves a phone call today, while a bin of low-value C parts can wait for the quarterly sweep. Slow-moving high-value stock is also the biggest drag on inventory turnover so the same list that protects the books also frees working capital.

What is an obsolescence reserve and how do you set it?

An obsolescence reserve is an allowance you book against inventory to reflect stock you expect to lose value on before you actually dispose of it. Under U.S. GAAP, inventory is carried at the lower of cost or net realizable value, so once an item's recoverable value drops below its book cost, accounting rules require you to write it down. The reserve is a contra-asset account, often called the allowance for obsolete inventory, that nets against inventory on the balance sheet, with the offsetting expense usually running through cost of goods sold. It lets you recognize the loss gradually as risk builds, instead of taking one brutal hit when an item is finally scrapped.

Most operations set the reserve with an aging schedule: the longer an item has sat without moving, the higher the percentage of its value you reserve. A common shape looks like this, though the exact bands and percentages should reflect your own history of what actually gets recovered versus scrapped.

Two rules keep the reserve defensible. First, be consistent: use the same method year to year, because auditors expect the calculation to be stable and any change disclosed. Second, override the schedule with judgment where it is clearly wrong, a superseded part goes to 100% the day the change order lands regardless of its age, and a slow item with a firm future order should not be reserved just because the clock says so.

What do the numbers say?

Context from standards bodies and primary data:

• Excess and obsolete (E&O) inventory is a defined concept in the supply-chain body of knowledge maintained by the Association for Supply Chain Management (ASCM/APICS) which frames obsolescence as inventory that has lost value and reached the end of its useful life.
• Inventory is a very large asset to protect from decay: the U.S. Census Bureau's Manufacturing and Trade Inventories and Sales series tracks business inventories in the trillions of dollars, with the inventories-to-sales ratio hovering in a roughly 1.3 to 1.4 range in recent years, so a percentage point of obsolescence is real money.
• The accounting rule is not optional: U.S. GAAP requires inventory to be carried at the lower of cost or net realizable value, which forces a write-down once recoverable value falls below book cost.

The practical takeaway: obsolescence is both an operational loss and a reported one, and the reserve is how you keep the reported number honest as the operational risk grows.

How do you reduce write-offs with phase-out planning?

You cut write-offs by managing the ends of a product's life as deliberately as the middle. Most obsolescence is created upstream, when a design change, a promotion, or a discontinuation is decided without anyone reconciling the decision against the stock already on hand or on order. Phase-out planning closes that gap. Before an engineering change takes effect, count the old-revision parts in stock and in the pipeline, and time the change so you burn down the old before switching to the new. Before you launch a promotion, plan the ramp down as carefully as the ramp up. When a customer or product is ending, freeze new buys against it immediately and work the remaining stock while it still has a buyer.

The same discipline applies to how much you buy in the first place. Obsolescence often starts as ordinary excess, a bulk buy chased for a price break or a forecast that never materialized, so tighter ordering and a hard look at minimum order quantities prevent tomorrow's dead stock. This is where obsolescence connects to broader inventory optimization: the buffers you set for service should be sized against real demand variability, not padded out of habit, since every extra unit you carry is a unit that can age into a loss. Obsolescence and inventory shrinkage are the two ways stock quietly loses value on the books, and both reward the same thing, accurate records and someone paying attention.

Where obsolescence hides in a real plant

The reason E&O grows unseen is that the data needed to catch it lives in pieces. Last-movement dates sit in one system, open purchase orders in another, engineering change orders in a folder or an email thread, and the physical stock in a bin nobody has walked past in a year. No single view connects them, so the item that should have been flagged the day its product was discontinued keeps sitting there as a full-value asset until year-end. Harmony is an AI-native layer that connects machines, software, and paperwork into one operational layer, with no rip-and-replace, so aging, usage, open orders, and change notices become one live record instead of four disconnected ones. AI search returns cited answers across those records, so a planner can ask which parts tied to a discontinued product still sit in stock, or which items have not moved in 18 months, and get a real answer instead of a spreadsheet archaeology project. Harmony's digital workflows then route each disposition, return, discount, or scrap, to the right person with the decision documented. It is the same paper-to-digital move Harmony makes elsewhere on the floor (see the CLS case study): the reserve stops being a year-end guess and becomes a live number the operation can actually manage.