Method Method Method Method Method #1 #2 #3 #4 #5 Ft Month Demand "D" (Historical Data Exponential Forecast Forecast | Forecast Forecast Nave 2 month 3 month 3 month Method SMA SMA WMA Periods Periods 4. Periods 4. Periods 4- 4-10 10 10 10 Smoothing Periods 4-10 1 40 2 3 4 48.0 45.6 5 50 40 57 25 40 28 48 35 47 40 571 251 40 28 481 6 7 8 9 45 48.5 41 32.5 34 38 41.5 43.3 49.01 40.7 40.7| 43.0 49.8 39.1 40.61 49.0 41.81 41.3 37.3 40.5 31.0 38.7 37.01 30.7 39.6 36.8 10 35 38.9 Please complete the table below (highlighted in red) for A-D A. Calculate the cumulative forecast error for periods 4-10 for each of the five methods. B. Calculate the mean absolute deviation (MAD) for periods 4-10 for each of the five methods. C. Calculate the means squared error (MSE) for periods 4-10 for each of the five methods. D. Which forecasting procedure would you select? Why? Method 1 Method 2 Method 3 Method 4 Method 5 CFE MAD MSE D Insert your preferred model here and indicate why you selected this model over the others