Explore BrainMass

Explore BrainMass

    Quantitative analysis:Moving average demand analysis.

    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 October 2, 2020, 1:44 am ad1c9bdddf
    https://brainmass.com/business/strategy-and-business-analysis/quantitative-analysis-moving-average-demand-analysis-400895

    Solution Summary

    The problem deals with estimating the 3 and 5 month moving average of a set of data.

    $2.19

    ADVERTISEMENT