Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer on excel. After plotting demand for four periods, an emergency room manager has concluded that a trend-adjusted exponential smoothing model is appropriate to

please answer on excel.

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.

Period Actual Period Actual
1 205 6 262
2 228 7 269
3 224 8 271
4 235 9 296
5 252 10

Use =.5 and =.1, and TAF of 250 for period 5. Obtain forecasts for periods 6 through 10. (Round your intermediate calculations and final answers to 2 decimal places.)

t Period TAFt
6
7
8
9
10

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transportation A Global Supply Chain Perspective

Authors: John J. Coyle, Robert A. Novak, Brian Gibson, Edward J. Bard

8th edition

9781305445352, 1133592961, 130544535X, 978-1133592969

More Books

Students also viewed these Mathematics questions