For the Hawkins Company, the monthly percentages of all shipments received on ti
ID: 2909767 • Letter: F
Question
For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83 a. Which of the following a time series plot? 86 86 85 85 83 81 80 79 78 81 79 0 2 3 45 67 89 10 11 12 13 0 1 2 3 4 5 6789 10 11 12 13 83 81 79 78 0 1 2 3 45 6 7 8 910 11 12 13 time series plot #c What type of pattern exists in the data? b. Compare the three-month moving average approach with the exponential smoothing approach for ? = .2 (to 2 decimals). Round intermediate calculations to two decimal places. MSE(3-Month) MSE (?-2)Explanation / Answer
b)
for 3 month forecast:
for erxponential smoothing:
b)
MSE(3-month)=1.23
MSE(alpha=0.2)=3.56
c)
forecast for next month =83.33
week actual(A) forecast(F) (A-F)^2 1 80 2 82 3 84 4 83 82.00 1 5 83 83.00 0 6 84 83.33 0.44 7 85 83.33 2.78 8 84 84.00 0 9 82 84.33 5.44 10 83 83.67 0.44 11 84 83.00 1 12 83 83.00 0 83.33 average(MSE) 1.23