Explore BrainMass
Share

Explore BrainMass

    Forecasting- moving average, exponential smoothing, trend

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

    MSE(Mean Squared error)
    MAD(Mean absolute deviation)

    6-23 The Garden Avenue Seven sells tapes of its musical performances. The following data shows sales for the past 18 months. The group's manager wants an accurate method for forecasting future sales.

    Month Sales Month Sales Month Sales
    1 293 7 381 13 549
    2 283 8 431 14 544
    3 322 9 424 15 601
    4 355 10 433 16 587
    5 346 11 470 17 644
    6 379 12 481 18 660

    Forecast the sales for month 19 and compute the MSE and MAD assuming:
    a. A 3 months moving average
    b. A 4 months weighted moving average, assuming a weight of 0.4 for the most recent period, 0.3 for the next period back, 0.2 for the third period back, and 0.1 for the fourth period back.
    c. An exponential smoothing with alpha = 0.3 and 0.5. Which value of alpha provides the best forecast?
    d. A trend line projection
    e. Which method of forecasting would you recommend to the manager? Why?

    © BrainMass Inc. brainmass.com October 9, 2019, 10:43 pm ad1c9bdddf
    https://brainmass.com/business/weighted-average-cost-of-capital/forecasting-moving-average-exponential-smoothing-trend-230157

    Solution Preview

    Please see the attached Excel file for answers

    Questions:
    6-23 The Garden Avenue Seven sells tapes of its musical performances. The following data shows sales for the past 18 months. The group's manager wants an accurate ...

    Solution Summary

    Makes forecasts using moving average, weighted moving average, exponential smoothing, trend line projection.

    $2.19