forecast of the sales during last three months. The information is below: A Manager uses moving...

Transcribed Image Text:

forecast of the sales during last three months. The information is below: A Manager uses moving average and exponential smoothing forecasting method to make the Month 1 2 3 4 Actual Sales 20 25 32 40 Forecast Using Moving Average Method 22 30 25 42 Forecast Using Regression Method 25 28 24 45 (a) Calculate the Mean Absolute Deviation (MAD) using Moving Average Method and Regression Method. (2 Points) (b) Calculate the Mean Squared Error (MSE) using Moving Average Method and Regression Method. (2 Points) (c) Calculate the Mean Absolute Percent Error (MAPE) using Moving Average Method and Regression Method. (2 Points) (d) Based on your answer in Part (a), (b), and (c), which forecasting method (Moving Average Method and Regression Method) should use in this problem? And please explain your reason. (2 Points) forecast of the sales during last three months. The information is below: A Manager uses moving average and exponential smoothing forecasting method to make the Month 1 2 3 4 Actual Sales 20 25 32 40 Forecast Using Moving Average Method 22 30 25 42 Forecast Using Regression Method 25 28 24 45 (a) Calculate the Mean Absolute Deviation (MAD) using Moving Average Method and Regression Method. (2 Points) (b) Calculate the Mean Squared Error (MSE) using Moving Average Method and Regression Method. (2 Points) (c) Calculate the Mean Absolute Percent Error (MAPE) using Moving Average Method and Regression Method. (2 Points) (d) Based on your answer in Part (a), (b), and (c), which forecasting method (Moving Average Method and Regression Method) should use in this problem? And please explain your reason. (2 Points)

Answer rating: 100% (QA)

a To calculate the Mean Absolute Deviation MAD you need to find the absolute difference between the ... View the full answer