Assignment Print View 1. Page 1 of 3 Award: 10.00 points Problem 3-8
Air travel on Mountain Airlines for the past 18 weeks was: Week
1
2
3
4
5
6
7
8
9 Passengers
405
410
420
415
412
420
424
433
438 Week
10
11
12
13
14
15
16
17
18 Passengers
440
446
451
455
464
466
474
476
482 b. 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
19
20
21 Forecasted Demand Hints
Hint #1 References
Worksheet Difficulty: 2 Medium Problem 3-8 Learning Objective:
03-11 Prepare a
linear trend forecast. http://ezto.mheducation.com/hm.tpx 1/8/2017 Assignment Print View 2. Page 2 of 3 Award: 10.00 points Problem 3-10
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
1
2
3
4
5 Actual
213
229
226
243
253 Period
6
7
8
9
10 Actual
268
268
283
296 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
6
7
8
9
10 TAFt References 3. Worksheet Difficulty: 3 Hard Problem 3-10 Learning Objective:
03-12 Prepare a
trend-adjusted
exponential
smoothing forecast. Award: 10.00 points Problem 3-11 http://ezto.mheducation.com/hm.tpx 1/8/2017 Assignment Print View Page 3 of 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 = 90 + 3t, where t = 0 in June of last year.
Seasonal relatives are 1.00 for January, .96 for February, and .95 for March. What demands should she
predict? (Round your answers to 2 decimal places.)
Month
January of the next year
February of the next year
March of the next year Forecast References 4. Worksheet Difficulty: 2 Medium Problem 3-11 Learning Objective:
03-11 Prepare a
linear trend forecast. Learning Objective: 03-13 Compute and
use seasonal relatives. Award: 10.00 points Problem 3-15
The manager of a fashionable restaurant open Wednesday through Saturday says that the restaurant does
about 33 percent of its business on Friday night, 29 percent on Saturday night, and 16 percent on Thursday
night. What seasonal relatives would describe this situation?(Round your answers to 2 decimal places.) Wednesday
Thursday
Friday
Saturday References
Worksheet Difficulty: 2 Medium Problem 3-15 Learning Objective:
03-13 Compute and
use seasonal
relatives. http://ezto.mheducation.com/hm.tpx 1/8/2017
