Question

2. (20 points) The following table shows the monthly sales in a local grocery store Month and 120 115 125 119 127 114 114 120 124 116 137 10 a. Suppose that Three-weeks moving average are used to forecast sales. Determine the one-step-ahead forecasts for weeks 4 through 10. b. Suppose that exponential smoothing is used with a smoothing constant α-02. Find the exponential smoothing forecasts weeks 4 through 10. (To get the method started, use 120.00 as the forecast for week 3). C. Suppose that exponential smoothing is used with a smoothing constant α - 0.3. Find the exponential smoothing forecasts weeks 4 through 10(To get the method started, use 120.00 as the forecast for week 3) d. Based on the MAD, which method did better? e. Based on the MAPE, which method did better?

Answer 1

lury. Poreraut 5 121 (12 +119 12213 123- 3. 3 614 12013 19 120 t l 24木116) 120 137 lo 42 7

126 118 119 119 .88 4.9991s 137 は.01 E Total- 4 2.343 MAD 049 Moveli 20 120 t L9 123 2.5 귀· 1 20 124 116 137 ot03M. 0.3치,9-+ 09 K 12 2:6If'z : 1,20.ohrf 4 026 5°·248 ETotal 4S.fo33 tee

If you have any questions please let me know

Thank you

Please give me thumb up....