MBA 6211 Managerial Decision Making (excel)

 1. Plot time series data (10 pts) 2. Generate linear trend model and forecast WTI for the next period. (12 pts) 3. Generate linear trend with seasonality model and forecast WTI for the next period. (12 pts) 4. Comment on the quality of these models and calculate MAD (10 pts) 5. Show the linear trend and trend with seasonality model equations (6 pts)  

 QUESTIONS: 1. Generate Moving Averages of 2, 3, 5, and 10 weeks and forecast WTI for the next period. (12 pts) 2. Calculate the MAD for each Moving Average model and comment on which is the best model among these. (10 pts) 3. Generate Exponential Smoothing models with alpha of 0.2, 0.4, 0.6 and 0.8. Forecast WTI for the next period. (12 pts) 4. Calculate the MAD for each Exponential Smoothing model and comment on which is the best model among these. (10 pts) 5. Plot the Moving Average models with the actual WTI on one chart AND on a separate chart plot the Exponential Smoothing models with actual WTI. (6 pts) 

1 . Compare the forecasts from the all the models (Linear trend, trend with seasonality, moving average and exponential smoothing) generated using the MAD. Determine which model Juan should present to his boss.  

Must be excel proficient. Please review the entire assignment and both attachments.

m