The figure on the following page shows an Excel spreadsheet that calculates a two- period weighted moving average and exponential smoothing model for a set of demand numbers, as well as the resulting MFE and MAD values. Re-create this spreadsheet in Excel. While your formatting does not have to be exactly the same, your answers should be.
Your spreadsheet should recalculate results whenever any changes are made to the shaded cells. If your logic is correct, changing the initial forecast for the exponential smoothing model to 50 will result in new MFE and MAD values of 0.76 and 5.62, respectively. Similarly, changing both weights for the two-period model to 0.5 should result in new MFE and MAD values of -0.077 and 7.692, respectively.

  • CreatedApril 10, 2015
  • Files Included
Post your question