Explore BrainMass

Explore BrainMass

    ratio-to-moving average method: Forecasting problem

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

    An analyst wants to use the ratio-to-moving average method to forecast a company's sales for the next few quarters. Beginning in Quarter 4 of 2003, the analyst collects the following sales data (in millions of dollars).
    Estimate the seasonal index associated with Quarter 2. Round your answer to at least three decimal places.

    Time Period Quarter Sales Moving Average
    1 4 142.4
    2 1 147.6 145.700
    3 2 169.0 139.400
    4 3 123.8 145.975
    5 4 117.2 146.800
    6 1 173.9 147.250
    7 2 172.3 153.975
    8 3 125.6 154.150
    9 4 144.1 161.150
    10 1 174.6 167.600
    11 2 200.3
    12 3 151.4

    © BrainMass Inc. brainmass.com June 3, 2020, 8:00 pm ad1c9bdddf
    https://brainmass.com/statistics/central-tendency/ratio-to-moving-average-method-forecasting-problem-120594

    Solution Summary

    This posting contains solution to following problem on forecasting using ratio-to-moving average method.

    $2.19

    ADVERTISEMENT