The ABC Floral Shop sold the following number of geraniums during the last 2 weeks:

profiledynamite
 (Not rated)
 (Not rated)
Chat

 

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
    the best answer
    NOT RATED

    Purchase the answer to view it

    • attachment
      moving_average_forecast_.xls