Skip to content
Inventory Management | Part 8 of 8

Inventory Targets and Reviews: The Target Is the Sum of the Items

Build the inventory target bottom up from safety stock and order quantity, set a realistic first-year goal and run a monthly review that attacks the causes of stock.

Most inventory targets are born in a budget meeting: fifteen percent less by year end.

A target that holds is built the other way round, from the items up.

Target stock per item

Target stock = safety stock + half the order quantity

The motor flange of the drive unit plant has a safety stock of 885 units and an order quantity of 800. Its target is 885 + 400 = 1,285 units, EUR 23,773. On hand today: 3,900 units, EUR 72,150.

Add up all items and the group has a target:

Class Stock today in EUR Calculated target in EUR Gap in EUR
A 297,210 168,786 128,424
B 85,355 37,554 47,801
C 82,933 17,692 65,241
Total 465,498 224,031 241,467

Both directions

Not every item goes down. Three items of the pilot group are below their target. The inverter module has EUR 14,400 on hand and a target of EUR 33,888.

This is what makes a calculated target credible. It adds stock where the calculation says so, with the same authority as it removes stock elsewhere.

From the calculated target to the goal

The calculated target is the stock you would hold on average if every item ran exactly on its parameters.

A realistic goal for the first year is to close half of the gap. For the pilot group: EUR 465,498 minus EUR 120,733 gives about EUR 345,000, or 6.9 turns instead of 5.1. For the whole plant the same logic leads from EUR 3.65 million to EUR 2.92 million, from 5.0 to 6.25 turns. At a holding cost rate of 20 percent, the EUR 730,000 released are worth EUR 146,000 per year.

Attack the causes

Once stock follows the parameters, the next reduction comes only from changing what the parameters are made of. For the motor flange:

  • Lead time two weeks instead of four: safety stock from 885 to 854 units.
  • Demand deviation halved: 838 units.
  • Lead time deviation halved: 527 units.
  • Order quantity 800 instead of 2,400: 800 units less cycle stock on average.

Take the three largest safety stocks of a group to the supplier meeting, each with the number that would halve it.

The monthly inventory review

One hour a month, with materials planning, purchasing, production, warehouse and the controller. The agenda is fixed:

  1. Key figures: stock value, turns, availability, stockouts, record accuracy. Ten minutes.
  2. The largest gaps to target, by item. Fifteen minutes.
  3. The stockouts of the month with their causes. Ten minutes.
  4. Slow mover decisions, once a quarter. Fifteen minutes.
  5. Parameter changes and open actions. Ten minutes.

Every discussion ends at an item number, an owner and a date. Nobody is blamed for a stockout that the agreed service level allows: at 98 percent, one cycle in fifty runs short.

Signs that it works

After a year, the example plant has moved from 91 to 97 percent material availability and from 38 to 9 stockouts per month, with EUR 730,000 less stock. Four things change:

  • Assembly stops calling the warehouse about missing parts.
  • Planners can explain every safety stock with three numbers.
  • The slow mover list gets shorter every quarter.
  • Finance and operations argue about causes, not about a percentage.
Newsletter

One Lean idea.
Every two weeks.