The ABC Floral Shop
(Not rated)
(Not rated)
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?
Grading Criteria | % of grade for this assignment |
Calculate a forecast of the above demand using a 3- and 5-period moving average. | 30% |
Graph these forecasts and the original data using Excel. What does the graph show? | 20% |
Which of the above forecasts is best? Why? | 30% |
APA citation and references | 5% |
12 years ago
Moving Average Forecasting Models
NOT RATED
Purchase the answer to view it

- moving_average_forecast.xls
The ABC Floral Shop sold the following number of geraniums during the last 2 weeks:
NOT RATED12 years ago