Explore BrainMass

Explore BrainMass

    The ABC Floral Shop sold the following number of geraniums d

    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? i also need the names of the resources that you uses

    © BrainMass Inc. brainmass.com June 4, 2020, 12:38 am ad1c9bdddf

    Solution Preview

    Moving averages smooth the price data to form a trend following indicator. They do not predict price direction, but rather define the current direction with a lag. Moving averages lag because they are based on past prices. Despite this lag, moving averages help smooth price action and filter out the noise.

    Calculate a ...

    Solution Summary

    The solution provides detailed explanations and calculations for the problem. The solution also provides Excel graphs as per requirements.