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

â?¢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

#### 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.

\$2.19