| Question 1 |
| Air travel on Mountain Airlines for the past 18 weeks was: |
| |
| |
| Week | Passengers | Week | Passengers |
| 1 | 405 | 10 | 440 |
| 2 | 410 | 11 | 446 |
| 3 | 420 | 12 | 451 |
| 4 | 415 | 13 | 455 |
| 5 | 412 | 14 | 464 |
| 6 | 420 | 15 | 466 |
| 7 | 424 | 16 | 474 |
| 8 | 433 | 17 | 476 |
| 9 | 438 | 18 | 482 |
| Use an appropriate technique to develop a forecast for the expected number of passengers for the next three weeks. (Round your intermediate calculations to 4 decimal places and final answers to 2 decimal places.) |
| |
| |
| Week | Forecasted Demand |
| 19 | |
| 20 | |
| 21 | |
| Question 2 |
| 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 | 214 | 6 | 269 |
| 2 | 229 | 7 | 260 |
| 3 | 228 | 8 | 273 |
| 4 | 244 | 9 | 286 |
| 5 | 259 | 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 | |
| Question 3. |
| A manager of a store that sells and installs spas wants to prepare a forecast for January, February, and March of next year. Her forecasts are a combination of trend and seasonality. She uses the following equation to estimate the trend component of monthly demand: Ft = 80 + 3t, where t = 0 in June of last year. Seasonal relatives are .87 for January, 1.05 for February, and 1.05 for March. What demands should she predict? (Round your answers to 2 decimal places.) |
| |
| Month | Forecast |
| January of the next year | |
| February of the next year | |
| March of the next year | |
| Question 4 |
| The manager of a fashionable restaurant open Wednesday through Saturday says that the restaurant does about 30 percent of its business on Friday night, 27 percent on Saturday night, and 19 percent on Thursday night. What seasonal relatives would describe this situation?(Round your answers to 2 decimal places.) |
| |
| Wednesday | |
| Thursday | |
| Friday | |
| Saturday | |
elijahmncab
stats_1.xlsx
