For this assignment, please submit one Excel file. Use a separate sheet for each question. Name each sheet as question number. To rename a worksheet, right-click the worksheet tab located at the bottom of your current sheet and use the rename option. Label the tabs as "Q Set 1", "Q Set 2", and "Q Set 3", respectively. Be sure to label all results clearly.

Questions

Durhlington has tracked daily sales of coats for the three locations below:

Date	Washington	Seasonal Relatives for Washington Sales	Newyork	Houston
1/4/21	272	0.4	659	456
1/5/21	388	0.5	493	672
1/6/21	622	1.3	483	584
1/7/21	605	1.7	579	609
1/8/21	222	1.4	652	596
1/9/21	222	1.6	535	529
1/10/21	302	0.9	399	612
1/11/21	338	1.2	423	683
1/12/21	239	0.5	619	565
1/13/21	283	0.3	567	559
1/14/21	505	0.7	548	785
1/15/21	829	1.1	766	783
1/16/21	686	1.4	479	599
1/17/21	893	2.2	435	711
1/18/21	184	0.6	651	756
1/19/21	188	0.7	650	712
1/20/21	290	0.8	491	512
1/21/21	369	0.9	549	447
1/22/21	395	1.3	463	574
1/23/21	846	1.5	595	654
1/24/21	961	1.9	829	552
1/25/21	193	0.5	886	470
1/26/21	193	0.8	639	596
1/27/21	245	0.8	645	562
1/28/21	317	0.9	627	454
1/29/21	480	1	459	800
1/30/21

Question Set 1. Using only the Washington sales data, generate the following sales forecasts:

1. Nave 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. (6pts)

2. Four-day moving average forecasts for January 8^th through January 30^th using the original (seasonalized) sales data. (3pts)

3. Twelve-day moving average forecasts for January 16^th through January 30^th using the original (seasonalized) sales data. (3pts)

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.

Question Set 2. Using only the Newyork sales data:

1. Forecast sales for January 7^th through January 30^th using a three-day weighted moving average. (5pts)

The weights are:

Day	Weight
1 day previous	0.50
2 days previous	0.30
3 days previous	0.20

2. Find the mean absolute deviation of the sales forecasts for January 7^th through January 29^th. You should not include the forecast for January 30^th since there is no corresponding sales figure for that date. (3pts)

3. Find the mean squared error of the sales forecasts, again for January 7^th through January 29^th. (4pts)

4. Create a scatter scatter-chart for the three-day weighted moving average. Label your chart axes properly. (2 pts)

Question Set 3. Using only the Houston sales data:

1. Forecast sales for January 5^th through January 30^th using exponential smoothing with alpha set to 0.6. Assume the sales forecast for January 4^th was 456. (6pts)

2. Using your forecasts from Q3.1, find the mean absolute deviation of the sales forecasts for January 5^th through January 29^th. Again, you should not include the forecast for January 30^th since there is no corresponding sales figure for that date. (4pts)

3. Using your forecasts from Q3.1, find the mean squared error of the sales forecasts for January 5^th through January 29^th. (4pts)