The following table contains the demand from the last 10 months: MONTH 1 ACTUAL DEMAND 32...

  

  

Transcribed Image Text:

The following table contains the demand from the last 10 months: MONTH 1 ACTUAL DEMAND 32 2 35 3 36 4 38 5 41 6 39 7 39 8 41 9 10 44 40 a. Calculate the single exponential smoothing forecast for these data using an aof 0.30 and an initial forecast (F) of 32. (Round your answers to 2 decimal places.) Exponential Month Smoothing 1 2 3 4 5 6 7 8 9 10 b. Calculate the exponential smoothing with trend forecast for these data using an a of 0.30, a Sof 0.20, an initial trend forecast (T) of 1.00, and an initial exponentially smoothed forecast (F) of 31. (Round your answers to 2 decimal places.) Month 1 2 3 4 5 6 7 8 9 10 FITT c-1. Calculate the mean absolute deviation (MAD) for the last nine months of forecasts. (Round your answers to 2 decimal places.) Single exponential smoothing forecast Exponential smoothing with trend forecast MAD c-2. Which is best? Exponential smoothing with trend forecast Single exponential smoothing forecast The following table contains the demand from the last 10 months: MONTH 1 ACTUAL DEMAND 32 2 35 3 36 4 38 5 41 6 39 7 39 8 41 9 10 44 40 a. Calculate the single exponential smoothing forecast for these data using an aof 0.30 and an initial forecast (F) of 32. (Round your answers to 2 decimal places.) Exponential Month Smoothing 1 2 3 4 5 6 7 8 9 10 b. Calculate the exponential smoothing with trend forecast for these data using an a of 0.30, a Sof 0.20, an initial trend forecast (T) of 1.00, and an initial exponentially smoothed forecast (F) of 31. (Round your answers to 2 decimal places.) Month 1 2 3 4 5 6 7 8 9 10 FITT c-1. Calculate the mean absolute deviation (MAD) for the last nine months of forecasts. (Round your answers to 2 decimal places.) Single exponential smoothing forecast Exponential smoothing with trend forecast MAD c-2. Which is best? Exponential smoothing with trend forecast Single exponential smoothing forecast

Answer rating: 100% (QA)

a b c1 MAD Single exponential smoothing forecast 276 Exponential ... View the full answer