Explore BrainMass

Explore BrainMass

    Forecasting the Demand - Moving Average and Trend Analysis

    Not what you're looking for? Search our solutions OR ask your own Custom question.

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

    Forecasting Exercise

    Year Demand ( in 1000's )

    1 13
    2 17
    3 18
    4 21
    5 27

    Develop a forecast for year 6, using two-year moving average and trend analysis. Identify which method is most appropriate for this data set

    © BrainMass Inc. brainmass.com March 4, 2021, 7:11 pm ad1c9bdddf

    Solution Preview

    Moving Average method:
    Let Xt denote the Demand(in 1000’s) at time t. Then a two year moving average for the time (t+1) is calculated using the formula:

    X_t + 1 = 1/2 (X_t + X_t -1)

    Here we want to ...

    Solution Summary

    Solution describes an application to moving average method and trend analysis.