After plotting demand for four periods, an emergency room manager has concluded that a trend-adjusted exponential smoothing model is appropriate to predict future demand. The initial estimate of trend is based on the net change of 30 for the three periods from 1 to 4, for an average of +10 units. Use α = .5 and β = .4, and TAF of 250 for period 5. Obtain forecasts for periods 6 through 10.See the screen shot and help me create this forecast. After plotting demand for four periods, an emergency room manager has concluded that a trend-adjusted exponential smoothing model is appropriate to predict future demand. The initial estimate oftrend is based on the net change of 30 for the three periods from 1 to 4, for an average of +10 units. Use a = .5 and B = .4, and TAF of 250 for period 5. Obtain forecasts for periods 6 through 10.Period12W N345Actual210224229240255Period678910Actual265272285294

PeriodActual121022243229424052556265727282859294 10

Answered: After plotting demand for four periods,…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

After plotting demand for four periods, an emergency room manager has concluded that a trend-adjusted exponential smoothing model is appropriate to predict future demand. The initial estimate of trend is based on the net change of 30 for the three periods from 1 to 4, for an average of +10 units. Use α = .5 and β = .4, and TAF of 250 for period 5. Obtain forecasts for periods 6 through 10.

See the screen shot and help me create this forecast.