The abc floral shop sold the following number of geraniums during

     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?