Explore BrainMass

Explore BrainMass

    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 June 3, 2020, 9:09 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

    ADVERTISEMENT