Explore BrainMass
Share

Exponential Smoothing Forecast

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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

© BrainMass Inc. brainmass.com March 21, 2019, 3:56 pm ad1c9bdddf
https://brainmass.com/statistics/multivariate-time-series-and-survival-analysis/exponential-smoothing-forecast-168573

Attachments

Solution Preview

16. Look at the attached spreadsheet....Use excel or QM to do exponential smoothing to compute miles for ...

Solution Summary

The expert computes the exponential smoothing forecasts.

$2.19