Paste Font V Call Styles 121 Ax & fx C B D E F G 1 Method 1 Method #1 Method #2 Method #4 Method #S #3 2 Forums Month Demand "D" (Historical Data) Forecast Forecast 2 Forecast 3 Forecast 3 Nalve month month month Method SMA SMA WMA Periods 4-Periods 4-Periods 4- Periods 4- 10 10 10 10 Smoothie ille Periods 4-10 in LO DO Wouw 1 2 3 4 5 6 7 8 40 50 40 57 25 45 48.5 NO 9 10 11 12 13 40 57 25 40 28 48 35 28 48 35 47 48.0 45.6 49.0 41.8 41.3 37.3 40.5 38.9 43.3 49.0 40.7 40.7 31.0 38.7 37.0 32.5 34 38 43.0 49.8 39.1 40.6 30.7 39.6 36.8 10 41.5 UN 21 15 Please complete the table below (highlighted in red) for A-D 16 A. Calculate the cumulative forecast error for periods 4-10 for each of the five methods. 17 B. Calculate the mean absolute deviation (MAD) for periods 4-10 for each of the five methods. ea 18 C. Calculate the means squared error (MSE) for periods 4-10 for each of the five methods. 19 D. Which forecasting procedure would you select? Why? 20 Method Method Method Method Methods 22 A OFE 23 B MAD 24 C INS 25 D Insert your preferred model here and indicate why you selected 26 this modeliver the others 22 28 29 30 ONSENS