A) Refer to Figure 4. Calculate the VALUE that goes in cell E.

Figure 4 The following spreadsheet shows a 3-period weighted average forecasting model used to forecast demand for bags of fertilizer 1 Historical data Forecast Error Analysis AbsoluteSquared Absolute error Year Bags Weights ForecaError error % error 4000 1 6000 1 40002 500 5000 750 750 1000 3750 4500 5000 5000 10000 8000 7000 9000 12000 14000 15000 250000 10.00% 5000 25000000 50.00% 562500 9.38% 562500 10.71% 500 750 750 1000 7750 8000 8250 10000 E 12250 10 1000000 3750 14062500 31.25% 4000 16000000 28.57% 62500 18.33% 8125000.000 21.17% MSE MAPE 10 12 13 14 Next period 15 sum of weights 2750 2750 75 4 MAD