Calculate a forecast of the demand


The ABC Floral Shop sold the following number of geraniums during the last two 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 questions. Calculate a forecast of the above demand using a three- and five-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?

Request for Solution File

Ask an Expert for Answer!!
Operation Management: Calculate a forecast of the demand
Reference No:- TGS091329

Expected delivery within 24 Hours