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%

 

    • 7 years ago
    Moving Average Forecasting Models
    NOT RATED

    Purchase the answer to view it

    • attachment
      moving_average_forecast.xls