Compare the MAPE calculated for the LR forecast (#1 above) with the MAPEs calculated using SES.

Using this Excel template: Data chart for BUS520 SLP 2, do the following:

Calculate the MAPE for Year 2 Linear Regression forecast (use the first spreadsheet tab labeled Year 2 Forecast MAPE).

Calculate forecasted sales for Year 2 using SES (use the second spreadsheet tab labeled SES MAPE). Use 0.15 and 0.90 alphas.

Compare the MAPE calculated for the LR forecast (#1 above) with the MAPEs calculated using SES.