11:06 AM Wed Oct 5 a no 'a? (B 82%-: ezio.mheducation.com B Private 4, Award: 5.00 points Respond to each of the items using the following time series data. Period Demand 20 46 20 9 1 7 8 19 34 39 10 4 11 32 12 23 13 10 14 27 wwwmu'rwax B Click here for the Excel Data File b. Compute all possible forecasts using exponential smoothing with a smoothing coefficient (a) of 0.3. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.) 1 20 2 46 3 20 4 9 5 17 6 8 7 19 8 34 9 39 1O 4 11 32 12 23 13 1D 14 27 15 c. Compute all possible forecasts using exponential smoothing with a smoothing coefficient (a) of 0.7. (Negative amounts should be indicated by a minus sign. Round your answers to 3 decimal places.) Period Demand Exponential Error Absolute Error Smooth 20 2 46 3 20 9 5 17 6 8 7 19 8 34 39 10 4 32 12 23 13 10 14 27 15 d. Compute the MADs for each forecast model. (Round your answers to 3 decimal places.) Average Forecast For an alpha of 0.3, the MAD For an alpha of 0.7, the MAD e. Which forecast model would you choose? Why? The forecast using the smoothing coefficient (a) of model is to be chosen because it has a measure of error (MAD)