Excel Online Structured Activity: Forecast Accuracy Comparison The forecasts generated by two forecasting methods and actual sales have been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop forecast accuracy and answer the following questions X X HA 3. What is the MAD, the MSE, the MAPE, the RSFE, and the tracking signal for each forecasting method? Do not round intermediate calculations. Round your answers to two decimal places. Use the minus sign to enter negative values, f any. MAD MSE RSFE MAPE Forecast 1 Forecast 2 Forecast 1 Tracking signal: Forecast 2 Tracking Signal 4. What can be concluded about the quality of the forecasts 17 Assume that the controllime for the tracking signal is 3 The results indicate in the forecasts 1, and that the tracking signal within the control limits of 3 5. What can be concluded about the quality of the forecasts 27. Assume that the controllimit for the tracking signal is +3. within the control units of 3 The results indicate in the forecasts 2, and that the tracking sional G Formulas Abs. % Error 5 D Forecast Acouracy Measures Forecast Period Sales Forecast Error Absolute Error Error2 1 267 265 2 290 265 3 295 292 4 274 290 5 264 269 6 269 265 7 265 260 8 273 Emor NA NA WNA WNA WNA WNA IINIA N/A Absolute Error WNIA INA MNIA WNIA #NIA WNIA WNIA Error2 SNA F #N/A F WNIA F WNIA N/A WNIA F WNIA F UA Abs. % Error WNIA NIA WNIA UNIA F ANIA SNIA F WNIA UNIA 275 WNIA INIA F WNIA SNIA NNA WNIA UNIA ONIA 11 Total 14 15 Average RSFE MAD MSE MAPE 17 18 Tracking Signal 19 20 Forecast 2 21 Period Sales Forecast Error Absolute Error Error2 Abs. % Error 22 1 267 265 2 290 289 24 3 295 291 25 4 274 293 26 5 264 282 27 6 269 267 7 265 29 8 275 273 30 31 Total 32 33 Average RSFE MAD MSE MAPE 35 30 Tracking Signal 97 NERES Error2 Error WNIA ANA #N/A WNIA WNIA WNIA ANA IN/A Absolute Error WNA WNIA NNA WNIA WNIA WNIA WNIA #N/A WNIA #NIA WNIA WNA INIA MNIA WNIA Abs. \ Error WNIA ANIA UNA WNIA #NIA WNIA F #NIA F WNIA 256 WNIA WNIA ANA WNIA #N/A WNA UNA ANA