Demand, Sales and Workload Forecasting Software

« Statistical Learning vs. Statistical Forecasting | Main | Simplicity vs. Flexibility - Forecasts at stake »

Calculate safety stocks with Microsoft Excel

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).

Posted on Wednesday, November 28, 2007 at 04:42PM by Registered CommenterJoannes Vermorel in , , | Comments Off