Creating a Weekly Sales Forecast with FS1 | Task

Ole Ersoy
Apr - 25  -  1 min

Scenario

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

LOCATION,      SKU,   2010W01,  2010W02,  2010W03,   2010W04,   2010W05,  2010W06
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 weeks 2010W07, 2010W08 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 weeks that the forecast is generated for click on SETTINGS and select the number of forecast periods.