ABC Floral Shop: Forecast the demand for geraniums and graph the results.

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?

Solution Summary

The solution presents the forecast for three and five year periods including a graph in the attached Excel file. An interpretation and opinion about the results is discussed in 102 words.