Excel, With formulas Pls.

AWN Period 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Actual Demand 1150 1400 1200 1500 1500 1300 1320 1700 1300 1450 1500 1500 1600 2000 2000 1700 1800 2200 1900 2400 2420 2460 2400 2420 2500 2200 2200 1960 2080 2100 24 25 26 27 28 29 30 The demand for Personal Protective Equipment (PPE) used in an emergency department (ED) for the last 30 weeks is displayed on Tab 1 of the workbook. We want to advise this ED's management on a predictive model for future weekly PPE demand forecasts. b. Complete steps e-g by applying a 5-period moving average model a e. Use the given predictive model to develop forecasts for the demand over this 30- week time period. f. Calculate mean absolute error (MAE) and mean absolute percent error (MAPE) for this predictive model. (**Make sure to show your work for calculation of prediction error and percent error for each forecast by separating the calculation steps**) g. Plot the actual data and the forecast in one figure (**Make sure to label your plot appropriately**)