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.