This assignment is 3 problem setsabout forecasting. Please use Microsoft excel. Please use a separate sheet for each problem set.

Questions Burlington has tracked daily sales of coats for the three locations below: Date Chicago 1/4/2016 1/5/2016 1/6/2016 1/7/2016 1/8/2016 1/9/2016 1/10/2016 1/11/2016 1/12/2016 1/13/2016 1/14/2016 1/15/2016 1/16/2016 1/17/2016 1/18/2016 1/19/2016 1/20/201 6 1/21/2016 1/22/201 6 1/23/2016 1/24/201 6 1/25/201 6 1/26/201 6 1/27/201 6 1/28/201 6 1/29/201 6 142 180 232 258 409 794 679 167 224 182 320 373 610 1064 192 201 240 311 388 707 1037 152 173 288 306 395 Seasonal Relatives for Chicago Sales 0.4 0.5 0.6 0.7 1 1.6 2.2 0.4 0.5 0.6 0.7 1 1.6 2.2 0.4 0.5 California New York 484 611 543 625 562 495 607 490 531 540 485 676 641 566 692 632 481 569 546 616 496 559 546 566 537 482 463 593 590 575 585 550 0.6 546 572 0.7 520 584 1 511 624 1.6 585 660 2.2 639 642 0.4 563 630 0.5 544 567 0.6 674 690 0.7 709 659 1 586 519 Question Set 1. Using only the Chicago 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 8th through January 30th. (3pts) 3. Twelve-day moving average forecasts for January 16 th through January 30th. (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 California sales data: 1. Forecast sales for January 7th through January 30th using a three-day weighted moving average. (5pts) The weights are: Day 1 day previous 2 days previous 3 days previous Weight 0.5000 0.3333 0.1667 2. Find the mean absolute deviation of the sales forecasts for January 7 th through January 29th. 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 29th. (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 New York sales data: 1. Forecast sales for January 5th through January 30th using exponential smoothing with alpha set to 0.4. Assume the sales forecast for January 4th was 481. (6pts) 2. Using your forecasts from Q3.1, find the mean absolute deviation of the sales forecasts for January 5 th through January 29th. Again, you should not include the forecast for January 30 h 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 29th. (4pts) Reminder: Check your work to make sure you have only included forecasts and accuracy measures for the exact date ranges specified. Also, please copy these tables into your excel file while solving