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?
