Exponential Smoothing Forecast.

16. Look at the attached spreadsheet....Use excel or QM to do exponential smoothing to compute miles for weeks 2 through 12, assuming an initial forecast for week 1 of 17,000. Use alpha of 0.2. What is the forecast demand for week 5?

A. 15
B. 19
C. 25
D. 30

17. See attached spreadsheet...What is the MAD for this model?

A. .91
B. 2.38
C. 8.23
D. 3.14

© SolutionLibrary Inc. solutionlibary.com February 20, 2020, 6:09 pm 9836dcf9d7 https://solutionlibrary.com/statistics/multivariate-time-series-and-survival-analysis/exponential-smoothing-forecast-54jt
Attachments