Download: ABC Floral Shop

Download:	http://solutionzip.com/downloads/abc-floral-shop-solution/
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?
Download:	http://solutionzip.com/downloads/abc-floral-shop-solution/