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 |
% of |
Calculate |
30% |
Graph |
20% |
Which of |
30% |
APA |
5% |