When to reorder: expected demand over the lead time plus a safety stock that covers variable demand and variable lead time at the service level you choose. Free, in the browser, no sign-up.
The reorder point is expected demand over the lead time plus safety stock: ROP = d × L + z × σLT. With the defaults below, 1,840 units a week on a six-week lead time, both variable, at a 98 per cent cycle service level, the safety stock is 7,547 and the reorder point is 18,587 units. Compare it with stock on hand plus stock on order, not with stock on hand alone.
| Result | Value |
|---|---|
| Expected demand over the lead time | 11,040 |
| Standard deviation of demand over the lead time | 3,674.6 |
| z at the service level | 2.0537 |
| Safety stock | 7,547 |
| Reorder point | 18,587 |
Runs in your browser: nothing you type is sent anywhere.
σLT = √(L × σd² + d² × σL²)
Safety stock = z × σLT, with z = NORM.S.INV(service level)
Reorder point = d × L + safety stock
In Excel: =d*L+NORM.S.INV(SL)*SQRT(L*sd^2+d^2*sL^2)
Use the same period throughout: weekly demand with a lead time in weeks, or daily demand with days. Set the lead time deviation to zero if the supplier is reliable; on the default part the lead time, not demand, creates nine tenths of the variance, which is why the safety stock is so large.
When the lead time is longer than the time between orders, several orders are open at once. The reorder point must then be compared with inventory position (on hand plus on order minus backorders), or it triggers too many orders.
Go further with the worked example, step by step, the free Excel template and the companion files for Supply Chain Management.
Multiply average demand per period by the lead time in periods and add safety stock. With 1,840 units a week, a six-week lead time and 7,547 units of safety stock, the reorder point is 18,587.
Combine both sources of variance: the standard deviation over the lead time is the square root of (lead time × demand variance + demand squared × lead time variance), then multiply by z for the service level.
NORM.S.INV of the cycle service level: 1.6449 for 95 per cent, 2.0537 for 98 per cent, 2.3263 for 99 per cent. Each extra point of service costs more stock than the last.
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 →