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:
- Key figures: stock value, turns, availability, stockouts, record accuracy. Ten minutes.
- The largest gaps to target, by item. Fifteen minutes.
- The stockouts of the month with their causes. Ten minutes.
- Slow mover decisions, once a quarter. Fifteen minutes.
- 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.