i) PROTECTED VIEW This file has been verified by Micros A1 x fr Week B C D 1 Week 1 2 2 3 4 3 5 4 6 5 6 7 8 7 8 9 10 11 12 13 14 15 16 17 18 19 Sales 2750 3100 3250 2800 2900 3050 3300 3100 2950 3000 3200 3150 2900 3150 3000 3200 9 10 11 12 13 14 15 16 Question 3: Use the data file A393.xlsx to answer this question. United Dairies, Inc., supplies milk to several independent grocers throughout Dade County, Florida. Managers at United Dairies want to develop a forecast of the number of half gallons of milk sold per week. a. Construct a time series plot. What type of pattern exists in the data? b. Use exponential smoothing with a = 0.25 to develop a forecast of demand for Week 17. What is the resulting MSE? c Use a moving average with k = 5 to develop a forecast of demand for Week 17. What is the resulting MSE? d. Using the above forecasting techniques, what should be the forecasts for the next time period