Air travel on mountain airlines for the past 18 weeks was
Problem 3-14
Air travel on Mountain Airlines for the past 18 weeks was:
Week Passengers Week Passengers
1 402 10 440
2 410 11 446
3 420 12 451
4 415 13 455
5 412 14 460
6 417 15 466
7 424 16 474
8 433 17 476
9 438 18 249
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 3 decimal places and final answers to 2 decimal places.)
Week Forecasted demand
19
20
21
Problem 3-2
National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows:
Month Sales
(000)Units
Feb. 20
Mar. 19
Apr. 12
May. 28
Jun. 16
Jul. 22
Aug. 28
b. Forecast September sales volume using each of the following:
(1)A linear trend equation.(Round your intermediate calculations and final answer to 2 decimal places.)
Yt_____ thousands
(2) A five-month moving average.(Round your answer to 2 decimal places.)
Moving average 21.2 thousands
(3) Exponential smoothing with a smoothing constant equal to .30, assuming a March forecast of 19(000). (Round your intermediate calculations and final answer to 2 decimal places.)
Forecast_______thousands
