posted a question
The ABC Floral Shop sold the following number of geraniums during the last two 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
I need to develop a spreadsheet to answer the questions.
Calculate a forecast of the above demand using a three- and five-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?