(***) (Microsoft Excel problem) 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. (Hint: Format the cells for the exponential smoothing model to show only two decimal places. Otherwise, the number of decimal places that shows will increase with each new forecast.) 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.
