The ABC Floral Shop sold the following number of geraniums during the last two weeks:
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?
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.