The Midwestern Manufacturing Company (MMC) is a large manufacturer of electrical generators. The firm has experienced demand for their generators as shown below:
For the questions below, create EXCEL worksheets naming the tabs as indicated.
a. Calculate a forecast for 2010 using a 3 year moving average. Place your results in a worksheet tab named Q1.
b. Calculate a forecast for 2010 using exponential smoothing. Use .7 as your Alpha value. Place your results in worksheet tab Q1.
c. Using Mean Absolute Deviation as your criteria, determine which method performs best. Explain your decision. Place your results in worksheet tab Q1.