Skip to content
inventory

Excess and Obsolete Inventory

The value of inventory above forward requirements or no longer sellable.

Definition

The value of inventory above forward requirements or no longer sellable.

Why it matters

Excess inventory ties up cash, consumes space and eventually becomes a write-off that hits the income statement.

Formula

E and O % = Excess and Obsolete Value / Total Inventory Value x 100

Example

1.4M excess and obsolete against 20M total inventory = 7%.

How to interpret it

Split excess (sellable but over-covered) from obsolete (not sellable). They need completely different actions.

How to improve it

Set coverage ceilings per segment, review ageing monthly, stop replenishment on flagged items, and run disposition through a standing committee.

Common mistakes

Reporting only obsolescence reserves, which lags the operational problem by months.

Related KPIs

Last updated