Explore BrainMass

Explore BrainMass

    Forecast demand using 3 and 5 period moving average

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

    The ABC Floral Shop sold the following number of geraniums during the last 2 weeks:

    Day
    Demand
    Day
    Demand

    1
    200
    8
    150

    2
    134
    9
    182

    3
    157
    10
    197

    4
    165
    11
    136

    5
    177
    12
    163

    6
    125
    13
    157

    7
    146
    14
    169

    Develop a spreadsheet to answer the following questions.

    Calculate a forecast of the above demand using a 3- and 5-period moving average.
    Graph these forecasts and the original data using Excel. What does the graph show?
    Which of the above forecasts is best? Why?

    © BrainMass Inc. brainmass.com June 4, 2020, 1:28 am ad1c9bdddf
    https://brainmass.com/business/accounting/forecast-demand-period-moving-average-402119

    Solution Summary

    The forecast demand using 3 and 5 period moving average is examined.

    $2.19

    ADVERTISEMENT