Safety stock when demand and lead time both vary, the demand-only figure for comparison, and how much of the buffer the supplier’s lead time creates. Free, in the browser, no sign-up.
When both demand and lead time vary, safety stock is z × √(L × σd² + d² × σL²): the variances add, not the standard deviations. With the defaults below, a part selling 1,840 units a week with a standard deviation of 462, on a six-week lead time that varies by 1.9 weeks, needs 7,547 units of safety stock at a 98 per cent cycle service level. The demand-only formula gives 2,324.
| Result | Value |
|---|---|
| z at the service level | 2.0537 |
| Safety stock, demand and lead time variable | 7,547 |
| Safety stock if lead time were fixed | 2,324 |
| Share of variance from lead time | 90.52% |
| Reorder point | 18,587 |
| Value of the safety stock | 215,844 |
Runs in your browser: nothing you type is sent anywhere.
Safety stock = z × √(L × σd² + d² × σL²)
z = NORM.S.INV(service level). In Excel: =NORM.S.INV(B6)*SQRT(B3*B2^2+B1^2*B4^2)
Demand and lead time must be in the same unit: weekly demand with a lead time in days is the most common way this formula produces nonsense. In the default case 90.5 per cent of the variance comes from the supplier, so shortening or stabilising the lead time is worth far more stock than a better demand forecast.
Use the reorder point calculator for when to order: reorder point calculator.
Go further with the worked example, step by step, the free Excel template and the companion files for Supply Chain Management.
With demand and lead time both variable: z × square root of (lead time × demand variance + demand squared × lead time variance). With lead time fixed, the second term drops out.
Usually because of lead time variability. In the default case 1.9 weeks of lead time variation creates nine tenths of the variance and more than triples the buffer against the demand-only formula.
A cycle service level is the probability of no stockout in a replenishment cycle. Each extra point costs more stock than the last: compare 95, 98 and 99 per cent in the calculator.
This calculator comes from Supply Chain Management by Julian R. Sterling, which works the same case in full, with every figure in a free workbook.
Get the book on Amazon → DRM-free PDF edition, $19.99
If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review.
Not on Amazon: 19 paperbacks by Julian R. Sterling on markets, funds and compliance, printed on demand and shipped worldwide. Browse the bookshop →