Time Period Demand 6 years ago 5 years ago 4 years ago 3 years ago 2 years ago Last year 28 21 42 35 56 49 What is this year’s forecast using a three-year moving average? What is this year’s forecast using a three-year weighted moving average, where the weights are .5,.3, .2? A. B. C. What is this year’s forecast using the linear trend method. D. Which forecast method has the smallest Mean Absolute Deviation (MAD), based upon forecasts for the latest 3 years of data? Coastal Airways, a small regional carrier, has flown the following number of passengers from its hub in Dubuque, lowa to Bismarck, North Dakota, in each of the past seven weeks. IV. Passengers 405 410 420 415 412 420 424 Week 5 a. T he airline wants you to use the trend method applied to these data to forecast the , number of passengers it could expect to fly in weeks 10, 11, and 12. b. If the ticket price for each passenger on this one-way route is $220, and the airline’s operating expense per passenger on this route is $67, what is the weekly net operating revenue (total operating revenue minus total operating cost) for weeks 10, 11 and 12?