Question

Using only the Chicago sales data, generate the following sales forecasts in Excel:

Naïve forecasts (using the deseasonalized sales data) for January 5th through January 30^th. You will need to adjust the sales data to remove the seasonality effects.

Four-day moving average forecasts for January 8^th through January 30^th.

Twelve-day moving average forecasts for January 16^th through January 30^th.

Note that, for example, you will not be able to make a four-day moving average forecast for January 7^th since four previous sales figures are required.

Date	Chicago	Seasonal Relatives for Chicago Sales
1/4/18	152	0.3
1/5/18	195	0.4
1/6/18	653	1.5
1/7/18	187	0.5
1/8/18	240	0.6
1/9/18	207	0.8
1/10/18	311	0.9
1/11/18	373	1.2
1/12/18	225	0.5
1/13/18	276	0.3
1/14/18	475	0.7
1/15/18	755	1.1
1/16/18	732	1.4
1/17/18	975	2.2
1/18/18	170	0.3
1/19/18	203	0.7
1/20/18	288	0.8
1/21/18	378	0.9
1/22/18	400	1.3
1/23/18	798	1.6
1/24/18	1111	1.9
1/25/18	176	0.5
1/26/18	213	0.6
1/27/18	240	0.9
1/28/18	311	0.7
1/29/18	456	1
1/30/18

Answer 1

Below is the screenshot of the formula applied -

Below is the screenshot of the result calculated -