The following table contains the demand from the last 10 months

profiletutor4helpyou
question.docx
Home>Mathematics homework help>Numerical analysis homework help>The following table contains the demand from the last 10 months

The following table contains the demand from the last 10 months:  Month (M) 1- Actual Demand (AD)-31; M2-AD34; M3-AD33; M4-AD35; M5-AD37; M6-AD36; M7-AD38; M8-AD40; M9-AD40; M10=AD41.  STEP ONE: Calculate the single exponential smoothing forecast for these data using a alpha of .30, and an initial forecast of (F1) of 31.  STEP TWO: Calculate the exponential smoothing with trend forecast for these data using a alpha of .30 a delta of .30, and an initial trend forecast (T1) of 1, and an initial exponentially smoothed forecast (F1) of 30.  STEP THREE: Calculate the mean absolute deviation (MAD) for each forecast.  STEP FOUR: Which is best and explain why? We are allowed to use excel, but it must be done by hand and not using excel functions. Please indicate Step 1, 2, 3, 4 and indicate (highlight) the final answer for each.