Calculate a forecast of the demand


Question: You sold the following number of flowers during the last two weeks. Calculate a forecast of the demand using a 3 and 5 period moving average. Graph these forecasts and the original data using excel. What does the graph show and which of the above forecasts is best and why.

Day 1 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

Solution Preview :

Prepared by a verified Expert
Other Management: Calculate a forecast of the demand
Reference No:- TGS01860894

Now Priced at $20 (50% Discount)

Recommended (92%)

Rated (4.4/5)