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%