Question: Demand for a new bread at a medium-sized grocery store is given in the following table: month demand month demand month demand 1 165 9

Demand for a new bread at a medium-sized grocery store is givenDemand for a new bread at a medium-sized grocery store is given in the following table: month demand month demand month demand 1 165 9 357 17 585 2 201 10 410 18 702 3 239 11 603 19 775 4 216 12 449 20 652 5 251 13 479 21 586 6 269 14 569 22 760 7 299 15 623 23 788 8 332 16 591 24 817 a. Using a simple exponential smoothing model (with alpha=0.1 ), determine the forecast for consumption in (1) month 25 and (2) month 30. b.Using a simple exponential smoothing model (with alpha=0.3 ), determine the forecast for consumption in (1) month 25 and (2) month 30. c. Plot the demand data

Demand for a new bread at a medifum-sized grocery store is given in the following table; a. Using a simple exponential smoothing model (with =0.1 ), determine the forecast for consumption in (1) month 25 and (2) month 30. b.Using a simple exponential smoothing model (with =0.3 ), determine the forecast for consumption in (1) month 25 and (2) month 30. c. Plot the demand data and the two sets of forecasts roughly to scale. Discuss your results briefly. d. If you used an exponential smoothing model with a trend instead of simple exponential smoothing, how would you use the demand data in the above table to estimate the trend? (You are expected to answer this qualitatively. You may use the data to illustrate your answer.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!