Skip to content
Inventory Management | Part 6 of 8

Slow Movers and Obsolete Stock: List, Decide, Prevent

Find stock without movement and excess reach, give every position a decision with an owner and a date, and close the three sources that create it.

Every warehouse has a corner where pallets gather dust. The stock there costs space and money every month and loses value every year. In the drive unit plant it adds up to EUR 410,000 without any movement for more than twelve months, 11.2 percent of the purchased parts.

Three categories

Use simple rules that the system can apply to every item.

  • Non moving: no movement for more than 365 days.
  • Slow: no movement for more than 180 days.
  • Excess: the item still moves, but the reach is above 26 weeks.

For the pilot group of 40 purchased items the list looks like this:

Category Items Stock value in EUR
Non moving 3 15,213
Slow 1 11,830
Excess 11 35,636
Total 15 62,679

That is 13.5 percent of the stock of the group. The three non moving items are old versions of a flange, a terminal box and a fan cover. The slow item is a gear wheel set of a phased-out drive.

A decision for every position

A list without decisions grows longer every quarter. Each position needs one of five decisions, an owner and a date.

  • Use up: a current product can use the part, with or without rework. Engineering and planning decide.
  • Return or sell: the supplier takes it back, or another plant or a service partner needs it.
  • Keep as service part: spare part demand is likely. Set a quantity and an end date, and move the stock out of the production warehouse.
  • Keep and reduce orders: for excess that still moves. Stop open orders and correct the order quantity.
  • Scrap: no use and no buyer. Book it and free the space.

The controller and the plant manager must be part of the decision. How stock is valued and written down follows your accounting rules, so agree the procedure with your controller before the first review.

Go and look

Lists are abstract. Standing in front of EUR 11,830 of phased-out gear wheel sets on four pallets is not. In a workshop, walk to the five items with the longest reach and to every item without demand.

Three sources and three rules

  • Engineering changes without a check of the remaining stock. Rule: the change date follows the stock, or the stock is decided before the change is released.
  • Minimum quantities far above the demand of a variant. Rule: an order that creates a reach above 26 weeks needs a second signature.
  • Phase-outs without a last order plan. Rule: the last purchase is calculated from the remaining program and the service demand, and it is approved.

A fourth source is quieter: parameters that nobody recalculated when demand fell. A quarterly recalculation prevents it.

The rhythm

Produce the list once a quarter, with value and age, sorted from high to low. Decide it in the monthly inventory review. Positions without a decision, an owner and a date stay on the list in red.

Measure two numbers: the value of stock without movement, and the number of positions without a decision. In the example plant, the first falls from EUR 410,000 to EUR 180,000 in twelve months.

The goal is not an empty list. The goal is that every position on it is there because someone decided it should be.

Newsletter

One Lean idea.
Every two weeks.