Creating a Yearly Sales Forecast with FS1 | Task

Ole Ersoy
Apr - 25  -  1 min

Scenario

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

LOCATION,      SKU,    2010,   2011,    2012,    2013,    2014,     2015
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 years 2016, 2017 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 years that the forecast is generated for click on SETTINGS and select the number of forecast periods.