Question: 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
Get step-by-step solutions from verified subject matter experts
