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%
The ABC Floral Shop sold the
following number of geraniums during the last 2 weeks:DayDemandDayDemand1200815021349182315710197416511136517712163612513157714614169Develop a spreadsheet to answer the
following questions.Grading
Criteria% of
grade for this assignmentCalculate
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 references5%
