How do we define obsolete consistently?
Written policy: e.g. no movement 12 months, superseded revision, or below forecast with no approved promo plan. Apply same at all sites.
Library / Inventory Control / Obsolete Inventory %
ZBI Business Control Library
Obsolete Inventory %
Obsolete Inventory %: plain-English definition, formula, worked example, how to interpret the result, peer-based benchmark guidance, common mistakes, and management actions in the ZBI Business Control Library.
What is Obsolete Inventory %?
Obsolete inventory percent is dead stock value divided by total inventory value—how much of what you carry cannot realistically be sold or used at full value. Obsolete is a policy definition: no movement in twelve months, superseded revision, or no approved demand path. At Logistika Zadar, obsolete inventory EUR 35,000 against total inventory EUR 400,000 is 8.75%. I watch this metric before turnover celebrations—a warehouse can turn fast on A-class while 8.75% obsolete quietly waits for a write-off that hits gross margin in one quarter.
Why Obsolete Inventory % matters
Obsolete stock consumes space, insurance, and pick paths while contributing zero to service. At 8.75%, Logistika Zadar has EUR 35,000 that ties capital and will likely move to P&L as a write-off or deep discount. Buyers keep replenishing active lines while obsolete FG from a discontinued flavour blocks fast-pick locations. Sales promises assortment freshness to retailers while finance reserves grow. Every new product launch without a disposition plan for replaced SKUs adds to the 8.75%—engineering releases ECOs but warehouse still counts revision B as sellable when only revision D is on the price list.
Formula and variables
Obsolete Inventory % = Obsolete Inventory Value ÷ Total Inventory Value × 100
Obsolete inventory value — stock meeting written obsolete policy at standard or net realizable value per finance rules.
Total inventory value — same valuation basis for all inventory categories in scope.
Excel: =IFERROR(B2/B3*100,0)
Real business example
Logistika Zadar inventory close: obsolete EUR 35,000 (SKUs with no movement 12+ months, superseded packaging, and promo stock with no approved clearance plan); total inventory EUR 400,000 at weighted average cost. Obsolete percent = 35,000 ÷ 400,000 × 100 = 8.75%. Prior quarter was 7.2%—the step-up is EUR 11,000 of slow beverage extensions after a retailer delisted two flavours. CFO sets a 90-day disposition target: discount channel for EUR 18k recoverable, write-off reserve for EUR 17k with engineering sign-off on superseded codes.
How to interpret the result
Obsolete percent measures capital trapped in stock with no viable demand path.
- 8.75% exceeds many manufacturing targets under 5%—trend and absolute euros both matter.
- Define obsolete the same at every site or corporate headline hides a branch at 15%.
- Write-offs improve the percent without fixing launch discipline—track pre-write-off obsolete separately.
- Pair with new product introduction count—launches up but obsolete flat means old SKUs are not cleared.
Benchmark context
Discrete manufacturers and distributors often aim under 3–5% obsolete of inventory value; 8.75% signals a disposition backlog. Compare quarter-on-quarter and to obsolete euros as a share of gross margin—at EUR 400k inventory scale, each point is EUR 4k. Seasonal FMCG may spike after promo ends; benchmark post-campaign obsolete separately from structural SKU proliferation.
Red flags
- Obsolete percent above 8% and rising two quarters—write-offs ahead; gross margin hit when reserves move to P&L.
- Obsolete defined inconsistently by site—corporate headline hides a plant at 15% dead stock.
- New product introductions up but obsolete percent flat—superseded SKUs not cleared from warehouse.
- Write-offs improve obsolete percent without disposition process—same SKUs reclassified next year.
- Obsolete euros concentrated in one buyer's category—assortment discipline failure, not random slow movers.
Common mistakes
- Obsolete defined differently by site—corporate 8.75% hides a warehouse at 14%.
- Waiting for annual write-off to 'clean' the metric without monthly obsolete review.
- Classifying superseded revision as active because 'someone might order it' without sales evidence.
- Excluding WIP obsolete—half-finished promo packs count when no demand path exists.
- New product launches without mandatory disposition checklist on replaced SKUs.
What should management do next?
- Apply written obsolete definition consistently; publish percent before and after write-off.
- Monthly obsolete review with engineering sign-off on superseded revisions.
- Set disposition path—discount, scrap, return—and deadline per obsolete band.
- Tie new product launch checklist to obsolete risk on replaced SKUs.
- Board report when obsolete percent exceeds policy threshold two quarters running.
Related calculators
Related analyzers
Related templates & software
Related KPI pages
Related blog articles
FAQ
When do we write off versus discount?
Write off when no demand path; discount when channel and margin allow clearance. Finance sets materiality threshold.
Should engineering sign off on the obsolete list?
Yes monthly for FG and WIP—ECO process should feed obsolete review, not only warehouse counts.
Is 8.75% obsolete acceptable?
Trend matters—rising from 7.2% triggers action. Aspiration under 5% for many distributors; set your policy with board visibility.
Does clearing obsolete hurt turnover metrics?
Yes cosmetically. Track pre-write-off obsolete separately so ops cannot hide buildup behind write-off timing.
Summary
Obsolete inventory percent shows how much stock has no viable demand path. Define obsolete consistently, disposition monthly with engineering input, and tie product launches to clearance of replaced SKUs.
Reviewed by ZBI Business Control Library · Last updated 2026-06-15