Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Aveces Airline has collected data for the percentage of available seats occupied on its flights per quarter for the past 5 years. Aveces has also

image text in transcribed
Aveces Airline has collected data for the percentage of available seats occupied on its flights per quarter for the past 5 years. Aveces has also collected data for the average percentage fare discount for each of these quarters, as follows: Seat Average Fare Year Quarter Occupancy % Discount % 1 1 53 21 2 75 34 3 76 18 4 58 26 2 1 59 18 2 62 40 3 81 25 76 30 3 N PA 65 23 70 28 78 30 69 35 4 59 20 61 35 83 26 71 30 NHAW 5 50 25 66 37 86 25 74 30 a) Develop a seasonally adjusted forecast model for seat occupancy. Forecast seat occupancy for year 6 by using a linear trend line forecast estimate for seat occupancy in year 6. b) Develop linear regression models relating seat occupancy to discount fares to forecast seat occupancy for each quarter in year 6. This will require that you calculate slope and intercept figures of discount % vs. seat occupancy % for each quarter given the data above. Then, calculate the forecast of seat occupancy given a fare discount of 20% for quarter 1, 36% for quarter 2, 25% for quarter 3, and 30% for quarter 4 c) Compare the forecasts developed in (a) and (b) and indicate which one appears to be the best

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematical Interest Theory

Authors: Leslie Jane, James Daniel, Federer Vaaler

3rd Edition

147046568X, 978-1470465681

More Books

Students also viewed these Mathematics questions