In many systems the safety stock is a number that somebody entered years ago, or a flat rule such as ten days for every item.
Safety stock covers the difference between what you expect and what happens during the lead time. It can be calculated from three inputs.
The three inputs
- The service level. The share of replenishment cycles that should end without a stockout. It sets the safety factor z.
- Demand: the average per week (d) and its standard deviation (sD), from the last 13 weeks.
- Lead time: the average in weeks (L) and its standard deviation (sL), measured from order date to goods receipt for the last deliveries.
The motor flange of the drive unit plant is an AX item. Demand is 400 units per week with a standard deviation of 80. The last eight deliveries took 2.5, 5.5, 3, 5, 3.5, 4.5, 4 and 4 weeks: an average of 4.0 weeks with a standard deviation of 1.0 week. The plant has agreed a service level of 98 percent for A items.
The formula
Safety stock = z x square root of (L x sD² + d² x sL²)
For the motor flange, z is 2.054:
2.054 x square root of (4 x 80² + 400² x 1.0²) = 2.054 x square root of (25,600 + 160,000) = 2.054 x 430.8 = 885 units
At EUR 18.50 per piece, that is EUR 16,373.
Which uncertainty drives it
Look at the two terms. The lead time term is six times the demand term. If only demand varied, 329 units would be enough.
This item needs its safety stock because deliveries arrive a week early or a week late, not because demand jumps. That is worth knowing before the next supplier meeting. If the supplier halves the deviation of the lead time to half a week, the safety stock falls to 527 units. Halving the lead time itself, from four weeks to two, only brings it to 854.
For this item, reliability is worth more than eleven times as much as speed.
What the service level costs
The safety factor comes from the normal distribution. In Excel it is NORM.S.INV(service level), in older versions NORMSINV.
| Service level | Safety factor z | Safety stock of the motor flange |
|---|---|---|
| 90 % | 1.282 | 553 |
| 95 % | 1.645 | 709 |
| 98 % | 2.054 | 885 |
| 99 % | 2.326 | 1,003 |
The last percent is the most expensive one. From 95 to 99 percent the safety stock grows by 294 units, EUR 5,439 for this one item.
The service level is therefore a decision, not a calculation. Production says what a shortage costs, the controller says what stock costs, and the plant manager decides per class. The example plant uses 98 percent for A items, 97 percent for B items and 99 percent for C items.
Where the formula stops
- Sporadic demand: Z items do not follow that shape. Decide them by hand.
- Trend: if demand is rising, the average of the past is too low. Correct the average before you calculate.
- Quality and records: rejected deliveries and wrong stock figures need their own fix. More safety stock only hides them.
Keep it current
Recalculate every quarter and after every change of supplier, lead time or demand level. Document every safety stock that is set above the calculated value, with a reason and an end date.