Excess and Obsolete Inventory: How to Find It, Cost It, and Clear It

The difference between excess and obsolete

The distinction matters because it determines the right action.

Excess inventory has demand, just not enough to justify the quantity on hand. If your forecast says you will sell 200 units over the next 12 months and you have 600 units in stock, you hold 400 units of excess relative to a one-year horizon. Excess can often be sold through normal channels given time, or returned to the supplier under return provisions.

Obsolete inventory has no meaningful remaining demand. The product has been discontinued, superseded by a newer model, the customer who specified it has stopped ordering, or it has expired. Obsolete inventory must be disposed of outside normal sales channels, liquidated, donated, repurposed, or scrapped. Waiting does not help; it only adds carrying cost to an asset with no future value.

Many organizations track them together as E&O because the financial treatment is similar, both require a reserve or write-down, but the operational response differs. Excess calls for demand stimulation or supplier returns; obsolete calls for disposal.

Why E&O accumulates

E&O rarely appears suddenly. It accumulates through a combination of decisions that individually seemed reasonable.

Demand forecast errors. Purchasing to a forecast that overestimated demand leaves residual stock when actual sales fall short. This is the most common root cause. The demand forecasting post covers how forecast error propagates into inventory levels.

Minimum order quantities. A supplier requires 1,000 units for a product you will use 200 of in the next year. You buy at the MOQ and hold 800 excess units. The MOQ post discusses this tension in detail.

End-of-life planning failures. When a product is being discontinued or replaced, the purchasing team does not always reduce the buy-in time. The last few orders arrive as demand has already shifted to the replacement. End-of-life buys are a major source of obsolescence.

Product changes. Engineering changes, regulatory changes, or customer specification changes that make existing stock non-conforming. Stock that was good yesterday is obsolete today because the spec changed.

Over-buying for price breaks. A buyer purchases a large quantity to achieve a volume discount. The discount saves 5 percent; the holding cost on the excess runs 20 percent annually. Net result: a loss dressed up as a saving.

Safety stock that is never consumed. Safety stock is sized for demand variability. When demand turns out to be steady and supply reliable, safety stock does not turn. Over time it accumulates. If it is never reviewed against current demand rates, it silently becomes excess.

Identifying E&O: the coverage method

The most practical tool for finding E&O is coverage analysis: for each SKU, calculate how many months of forward demand the current on-hand quantity covers.

Coverage (months) = On-hand quantity ÷ (Average monthly demand)

Set thresholds based on your business context. Common rules:

Coverage above 12 months: excess. The stock exceeds one year of anticipated demand. Investigate and act.

Coverage above 24 months: deep excess or potential obsolescence. Cost the position and determine whether demand will actually materialize.

Zero demand in the trailing 12 months: obsolete candidate. Flag for review and likely write-down.

Apply these thresholds to your full inventory list, sorted by coverage descending. The top of the list shows the most pressing E&O positions. Use the Inventory Turnover Calculator to identify low-turnover items, inventory turnover and coverage are two views of the same underlying problem.

Costing E&O positions

Once you have identified E&O candidates, quantify the financial exposure.

The carrying cost of E&O stock runs 20 to 30 percent of inventory value per year in most operations, covering capital cost, warehouse space, insurance, handling, and the risk of obsolescence. Every month an E&O position sits on the shelf, it generates cost and deteriorates in value.

Annual E&O carrying cost = E&O value × Holding cost rate

For a USD 500,000 E&O position at a 25 percent holding cost rate, the annual cost of inaction is USD 125,000. This is the floor cost of the decision to do nothing. Any disposal path that recovers more than zero value is better than that baseline.

In addition to ongoing carrying cost, quantify the write-down exposure. For deep excess items that are unlikely to sell at full price and for all obsolete items, the expected recovery value is less than book value. The difference is the write-down. Finance requires a reserve for this exposure once E&O positions are identified; accounting standards in most jurisdictions require it.

ABC class and E&O risk

E&O items tend to cluster in certain ABC classes but for different reasons.

Class C items (low annual usage value) are the most common E&O candidates by count. Because C items are numerous and low-value, they are easy to overlook. A C item ordered once with a high MOQ or in anticipation of demand that never materialized can sit for years. The individual exposure is small, but C item E&O can accumulate to a material total across a large catalog.

Class A items (high annual usage value) create the most financially significant E&O when they go wrong. A forecast miss on an A item or an end-of-life failure on a high-value component creates a large write-down. A items deserve proactive E&O review at every product lifecycle transition.

Use the ABC Analysis Calculator to segment your inventory before running E&O analysis. The A item review and the C item review have different financial stakes and require different management attention.

Disposal options and recovery rates

Once identified and costed, E&O requires a disposal decision. Options in rough order of value recovery:

Supplier return. If the supplier accepts returns, this is usually the highest-value option. Return provisions in supply agreements typically specify restocking fees (10 to 25 percent is common) and conditions. An item worth USD 100 returned for USD 85 is far better than an item liquidated for USD 30.

Redistribution to another internal site or business unit. If the stock is usable elsewhere in the organization, a transfer recovers full value with no external transaction. Rarely available for truly obsolete items but common for geographic or departmental excess.

Customer sell-back or co-op disposal. For customer-specific inventory, negotiate with the customer to take back the excess, apply it to future orders, or split disposal costs. This requires relationship capital but often produces better outcomes than unilateral liquidation.

Secondary market or liquidation. Brokers, liquidators, and secondary market resellers buy excess at discounts ranging from 10 to 80 percent of cost depending on the product category and market conditions. Electronics and technology components command better prices than slow-moving consumables. Recovery of 30 to 50 cents on the dollar is typical for industrial excess; some categories do better.

Donation. For food-grade, medical, or consumer products, donation may generate a tax benefit that approaches or exceeds the liquidation value while removing the stock from the books cleanly.

Scrap or destruction. The last resort, recovery is the scrap value of the material, often near zero. Required for items with regulatory disposal requirements, safety hazards, or products whose resale would violate brand or contractual restrictions.

E&O and product lifecycle management

The highest-leverage point for E&O prevention is the product lifecycle transition: new product introduction, product change, and end-of-life. These are the moments when existing inventory either becomes excess or obsolete most rapidly.

At new product introduction: run down the inventory of the predecessor product before the new one launches. Set a hard cutoff date for last buys of the predecessor and communicate it to buyers months in advance.

At product change: assess all on-hand and in-transit inventory of the old revision for usability under the new spec. If it fails the new spec, it is immediately obsolete. Plan the transition buy to land at near-zero stock of the old version.

At end-of-life: set a last-time-buy quantity based on remaining projected demand plus a service parts horizon if applicable. Over-buying at end-of-life is a major source of long-tail obsolete inventory that ties up capital for years.

Building an E&O reserve

Finance and accounting teams require an E&O reserve, a balance sheet liability, to reflect the expected loss on inventory that will not sell at book value. The reserve methodology varies: some organizations use a formula based on coverage thresholds (any item with more than 12 months coverage is reserved at 50 percent; more than 24 months at 100 percent). Others use historical recovery rates by product category.

The reserve does not itself generate cash or improve the inventory position. It makes the expected loss visible on the balance sheet, which is a forcing function for management action. An operations team that has to explain a large and growing E&O reserve at every quarterly review is more motivated to take disposal action than one whose excess is not separately identified.

Common mistakes

• Not reviewing E&O regularly. E&O analysis done once a year misses positions that accumulate and age for 11 months before anyone looks. Monthly or quarterly E&O reviews are standard in well-run operations.
• Waiting for demand to come back. For truly obsolete items, demand does not come back. The decision to wait is a decision to add carrying cost to an asset that will eventually be written off anyway. It delays the loss without reducing it.
• Counting safety stock in the coverage calculation. Safety stock is intentionally held above the demand-driven cycle stock. If you count it as available to cover future demand, you will understate coverage and miss E&O. Run coverage against safety stock separately.
• Focusing only on unit count rather than value. A warehouse full of low-cost fasteners may have 50,000 excess units worth USD 2,000 total. A single excess assembly worth USD 80,000 deserves far more attention. Sort E&O by value, not count.
• Not engaging sales in demand stimulation for excess. Excess inventory that can still be sold is a sales opportunity. Markdowns, promotions, bundle offers, and priority fulfillment for excess SKUs turn the E&O problem into a near-term revenue opportunity.

Frequently asked questions

What is the difference between excess and obsolete inventory?

Excess inventory has demand but the quantity on hand exceeds what near-term demand justifies. You have too much of something that still sells. Obsolete inventory has no remaining demand, the product is discontinued, superseded, or past its usable life. Excess can often be sold through normal channels at normal prices given time. Obsolete must be disposed of outside normal channels, usually at a significant discount or written off entirely.

How do you identify excess inventory?

The most practical method is coverage analysis: divide on-hand quantity by average monthly demand to get months of supply on hand. Items with more than 12 months of coverage are typically classified as excess. Items with zero demand in the trailing 12 months are obsolete candidates. Sort all SKUs by coverage descending to prioritize the largest exposures. Low inventory turnover rates, calculated by dividing cost of goods sold by average inventory, identify the same problem from a different angle.

What does it cost to hold excess inventory?

The carrying cost of inventory is typically 20 to 30 percent of inventory value per year, covering capital cost (the interest or opportunity cost of the money tied up), warehouse space, insurance, handling labor, and the risk of further obsolescence. A USD 200,000 E&O position costs USD 40,000 to USD 60,000 per year to hold if no action is taken. This is the financial argument for disposing sooner rather than waiting for a better price.

What are the options for disposing of obsolete inventory?

In rough order of value recovery: supplier return (often yields the highest recovery, subject to restocking fees and return provisions), redistribution to another internal site, customer negotiation for return or future credit, secondary market or liquidation broker (typically 20 to 60 cents on the dollar depending on the product category), donation (which may have tax benefit), and scrap or destruction as the last resort. The right choice depends on the product type, return provisions in your supplier agreements, and the urgency of clearing the position.

How does E&O inventory affect financial statements?

E&O inventory must be written down to its net realizable value under most accounting standards (GAAP, IFRS). This means recognizing a loss on inventory that will not sell at book value. Organizations typically build an E&O reserve, a balance sheet contra-asset, equal to the expected loss on identified E&O positions. When the inventory is eventually disposed of, the write-down reduces the reserve rather than hitting the income statement directly, but the reserve itself reduces reported inventory value and owner equity.

How do you prevent excess and obsolete inventory from building up?

The highest-leverage prevention is at product lifecycle transitions: disciplined end-of-life planning, coordinated predecessor product run-down before new product introduction, and careful last-time-buy quantity calculations. Operationally: regular E&O reviews (monthly or quarterly), better demand forecasting to reduce over-buys, negotiating lower MOQs on slow-moving items, and revisiting safety stock levels when demand rates change materially. An E&O position review is most effective when it is a standing agenda item at operations and finance reviews rather than an annual cleanup exercise.