please show all work using excel & answer all parts

clearer image

5. The forecasts generated by three forecasting methods and actual demand for the Tor rance Company are as follows: DEMAND FORECAST 2 FORECAST 3 MONTH FORECAST 1 25 MG 20 268 252 292 383 255 26 256 2 24 20 25 20 2/4 23 Compute the MSE and MAD for each forecasting method. Which forecasting method is the best? Would your decision on which forecasting method performs better depend on which forecasting accuracy measure (MAD or VSE) is selected? 5. The forecasts generated by three forecasting methods and actual demand for the Tor- rance Company are as follows: MONTH DEMAND FORECAST 1 FORECAST 2 FORECAST 3 2 2 3 269 289 294 278 275 266 290 284 270 768 268 287 292 298 274 270 295 290 280 270 200 269 Compute the MSE and MAD for each forecasting method. Which forecasting method is the best? Would your decision on which forecasting method performs better depend on which forecasting accuracy measure (MAD or MSE) is selected