Creating a Quarterly Sales Forecast with FS1 | Task

Ole Ersoy
Apr - 25  -  1 min

Scenario

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

LOCATION,      SKU,   2010Q01, 2010Q02, 2010Q03, 2010Q04,  2011Q01, 2011Q02
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 quarters 2011Q03, 2011Q04 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 quarters that the forecast is generated for click on SETTINGS and select the number of forecast periods.