Calculate safety stocks with Microsoft Excel

Published on by Joannes Vermorel.

In retail, the ultimate goal of sales forecasting is usually to calculate optimal safety stocks. Unfortunately, most online resources do give much detail about the explicit algorithms that should be used for safety stocks.

screenshot-safety-stocks-excel.png

In order to facilitate the task for customers and partners (and competitors :-), I have just published an extensive guide Calculate safety stocks with sales forecasting. The guide is illustrated with a Microsoft Excel spreadsheet.

The intent of this guide is to be a valuable piece of information for practitioners. I have pushed some efforts in order to make it independent from the Lokad forecasting technology (thus, you can grab your favorite forecasting tool, and re-use the formulas as such).

Categories: excel, safety stock, technical Tags: