The abc floral shop | Business & Finance homework help
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% |
