Posted: December 14th, 2016

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?

Place an order in 3 easy steps. Takes less than 5 mins.