Explore BrainMass

Explore BrainMass

    Forecasting: weighted moving average

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

    Historical demand for a product is

    DEMAND
    January 12
    February 11
    March 15
    April 12
    May 16
    June 15

    a. Using a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast.

    b. Using a simple three-month moving average, find the July forecast.

    c. Using single exponential smoothing with α = 0.2 and a June forecast = 13, find the July forecast. Make whatever assumptions you wish.

    d. Using simple linear regression analysis, calculate the regression equation for the preceding demand data.

    e. Using the regression equation in d, calculate the forecast for July.

    Thanks

    © BrainMass Inc. brainmass.com June 3, 2020, 7:11 pm ad1c9bdddf
    https://brainmass.com/business/business-math/forecasting-weighted-moving-average-89192

    Solution Summary

    Excel file shows a month's foretasted demand using:
    a weighted moving average with weights of 0.60, 0.30, and 0.10, find the July forecast.

    b. Using a simple three-month moving average
    c. single exponential smoothing

    d. simple linear regression analysis

    $2.19

    ADVERTISEMENT