AutoSave . off 7 ) Forecasting Homework corrected MSE - Saved to this PC A Peter Nguyen PN X File Home Insert Draw Design Layout References Mailings Review View Help Search Share Comments Cut Cambria 12 A Aav AaBbCcDd AaBbCcDd AaBbC AaBbCcI AAB AaBbCcD AaBbCcDd AaBbCcDd Find A Paste Copy c Replace Dictate Format Painter U ab X , A A E E 1 Normal 1 No Spac... Heading 1 Heading 2 Title Subtitle Subtle Em... Emphasis Select Clipboard Font Paragraph Styles Editing Voice Please answer the following: Submit work as a PDF and separately also submit your spreadsheet file showing your work a. 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. Sales data for the past 12 weeks are: Week Sales W N 2,750 3,100 4 3,250 2,800 5 6 2,90 3,050 7 8 3 ,300 3 ,100 9 2,950 10 3,000 12 3,200 3,150 1. Compute four-week and five-week moving averages for the time series. a. Compute the MSE for the four-week and five-week moving average forecasts. b. What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? The MSE for three weeks is 23527.78 2. Show the exponential smoothing forecasts using a = 0.1. Applying the MSE measure of forecast accuracy, would you prefer a smoothing constant of a=0.1 or a= 0.2 for the United Dairies sales time series b. Are the results the same if you apply MAE as the measure of accuracy? c. What are the results if MAPE is used? 3. Use exponential smoothing with a a = 0.4 to develop a forecast of demand for week 13. What is the resulting MSE? Page 1 of 1 224 words + 100% O 9 w 9:13 AM 10/6/2019