Creating a Monthly Sales Forecast with FS1 | Task

Ole Ersoy
Apr - 25  -  1 min

Scenario

We have a CSV sales history data set containing monthly sales history for the locations Chicago, Detroit, and Philadelphia:

LOCATION,      SKU,   2010M01,  2010M02,  2010M03,  2010M04,   2010M05,  2010M06
Chicago,       FS1,     149,      188,      255,      570,       333,      760
Detroit,       FS2,     149,      188,      255,      570,       333,      760
Philadelphia,  FS3,     149,      188,      255,      570,       333,      760

And we want to produce a forecast for the months 2010M07, 2010M08 along with the corresponding MAD forecast error measure for each LOCATION AND SKU combination.

Approach

Login to FS1. Click on LOAD and load the sales history.

Click FORECAST. The error minimizing forecast is generated and can now be saved. To change the number of months that the forecast is generated for click on SETTINGS and select the number of forecast periods.