4. Calculate the forecast errors, MAD, MSE, and MAPE for the forecasts you made in Question 2. Use the actual sales data for 2011 given below. Round your answers to the whole number.
Period | Actual Sales | Forecasts | Errors | Absolute Error | Error^2 | Absolute % Error
August | 10,800 | 11,000 | | | |
September | 9,700 | | | | |
October | 10,200 | | | | |
November | 11,600 | | | | |
December | 11,100 | | | | |
| | | | MAD = | MSE = | MAPE =
5. Based on the two methods used to calculate forecasts for TFY, which method produced the best forecast? The moving average method or the exponential smoothing method?