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
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 ...
The solution provides detailed explanations and calculations for the problem. The solution also provides Excel graphs as per requirements.