Calculating forecasted demand with a moving average

written by - Comments off

I need help with the following:

The ABC Floral Shop sold the following number of geraniums during the last 2 weeks:
Day 1: Demand: 200
Day 2: Demand 134
Day 3: Demand 157
Day 4: Demand 165
Day 5: Demand 177
Day 6: Demand 125
Day 7: Demand 146
Day 8: Demand 150
Day 9: Demand 182
Day 10: Demand 197
Day 11: Demand 136
Day 12: Demand 163
Day 13: Demand 157
Day 14: Demand 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?

Note: Currently, Regular Priority times are 3-5 days. Log in to upload files with your questions. Tutorials you buy shall be emailed to your PAYPAL email. Talking about quality references: finding and referencing an (n+1)th article for your tutorial requires substantially more time than the (n)th article referenced, therefore you will see the price increasing with the number of references you require in some questions. Wanted to contact us over something related to this question? Email us: support AT

© 2010 Customized Homework help. - Powered by OM