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%