Answer to Question #152899 in Statistics and Probability for izah

Question

Weekly sales of copy paper at Cubicle Suppliers are provided in the table below. Compute a three-period moving average, a three-period weighted moving average (most recent period 05, last two period = 0.3, last three period = 0.2) and an exponential smoothing forecast (initial forecast = 26, α = 0.2). Compute the MAD, MSE, MAPE for each forecasting method. Which model is more accurate for week 8 forecast? (please use 3 decimal points)

Week Sales (cases) Forecast
1 27 26
2 28
3 28
4 29
5 29
6 27
7 28
8

Answer 1

Calculations: