Free Safety Stock Calculator
Safety stock exists because you are wrong. This works out how much buffer one item needs for the service level you want, and shows how quickly the cost climbs as you chase the last few percent.
Safety stock calculator
Work out how much buffer stock one item needs for the service level you want, and what that buffer costs. Use weekly numbers throughout. Nothing is uploaded: the numbers stay in your browser.
Don't know your average and standard deviation? Paste weekly sales instead
Paste at least 8 weeks of sales for one item, one number per line or straight from an Excel row or column. Ideally 26 to 52 weeks, with promotions and stockout weeks taken out.
What each extra point of service costs
Formula: Safety stock = Z x square root of [ (lead time + review period) x demand std dev² + average demand² x lead time std dev² ]. Z comes from the normal distribution for your service level (95% is 1.64, 99% is 2.33). It assumes demand is roughly normal and independent from week to week, which suits steady, reasonably high-volume items. It does not suit lumpy, slow or highly seasonal items, new products or anything heavily promoted. Treat the answer as a starting point and check it against how the item actually behaves.
Related
- Safety Stock Explained Without the Textbook Nonsense
- Weeks of cover and inventory health checker
- All free Nerd Tools
Want someone to look at the whole picture? The Planning Health Check from Forward Cover reviews your forecasting, inventory and supply planning and tells you where the money is leaking.