Safety stock is the extra units you keep to cover the weeks when sales are higher than the forecast or the supplier takes longer to deliver. If it is too low, the product runs out, and if it is too high, it ties up money and space.
The formula when lead time is fixed
Safety stock = z × σ × √L
zis a factor that comes from the desired service level (see the table below).σis the standard deviation of sales per day, i.e. how much sales vary from day to day.Lis the lead time in days.
The square root is there because variations from day to day partly cancel each other out. A lead time four times as long therefore only gives twice as much safety stock.
Service level and z
The service level here is the probability of not running out while waiting for a delivery.
| Service level | z |
|---|---|
| 90% | 1.28 |
| 95% | 1.64 |
| 97.5% | 1.96 |
| 98% | 2.05 |
| 99% | 2.33 |
Note that the last percentage points are expensive. From 95% to 99%, safety stock rises by more than 40%. It therefore probably makes sense to have a high service level on the products that account for most of the revenue, and a lower one on the rest. ABC analysis is a good way to split the range.
Worked example
A coffee pot sells 2.6 units a day on average. Sales vary with a standard deviation of 1.8 units per day, and the supplier delivers in 56 days. The desired service level is 95%.
1.64 × 1.8 × √56 = 1.64 × 1.8 × 7.48 = 22.1
The safety stock is therefore 23 units when rounded up.
When lead time also varies
If the supplier sometimes delivers in 49 days and other times in 63, that uncertainty has to be included too. You then use:
Safety stock = z × √(L × σ² + d² × σL²)
where d is the average sales per day and σL is the standard deviation of the lead time in days.
With the same coffee pot and a standard deviation of the lead time of 7 days:
1.64 × √(56 × 1.8² + 2.6² × 7²) = 1.64 × √(181 + 331) = 1.64 × 22.6 = 37.1
The safety stock rises from 23 to 38 units. In this example an unpredictable supplier matters more than unpredictable sales. That can be a useful argument in a conversation with the supplier about fixed lead times.
Where the numbers come from
- Sales per day: use the history without stockout days, otherwise both the average and the variation will be wrong.
- Variation: calculate the standard deviation of daily or weekly sales. If you use weeks, the lead time must also be in weeks.
- Lead time: use the measured time from order to receipt if you have it. The supplier’s own figure is often too optimistic.
Safety stock in lesslater
lesslater calculates safety stock for each product from the product’s own sales variation, the lead time and the service level set for the shop, the supplier or the ABC class. If receipts have been registered on purchase orders, the measured lead time can be used instead of the stated one.
Try it yourself
The calculator below uses the formulas above. Set the lead time variation to 0 if the lead time is fixed.
Calculator
Safety stock and reorder point
Safety stock
23 units
Reorder point
169 units
Sales during lead time 146 units + safety stock 23 units