Question

Read Continental Airlines Case Study and answer the case questions. There is also an excel file to use for the calculations (See Question.xlsx).

CASE QUESTIONS:

1. Using the quarterly data for operating costs and the various cost drivers of costs provided in the spreadsheet, estimate regressions for each of the ten cost categories listed above.
Then, write the appropriate cost function for each category of cost and interpret your regression results. For example, your first regression would have “salaries and wages” as your dependent variable and “available seat miles” as independent variable.
2. Based on your regression results and your interpretation of those results, where do you see the largest reductions in costs if flying capacity is lowered by 11 percent? Also, in which areas do you see opportunities to achieve further cost reductions? Why?
3. The table below provides a quarterly forecast of revenues, jet fuel prices,5 and the projected operating activity for 2009. Using the information from your regressions and the forecast information provided, estimate Continental’s operating costs and expected profit for the upcoming fiscal year.
4. Based on the results of your profitability analysis, what can you say about the firm’s financial outlook? Would Continental be earning an operating profit in 2009? If not, what should Continental’s management do to restore profitability in 2009?

Secondly, take the role of a consultant giving a short summary of your regression analysis. In particular, address the following three areas: (i) How do airlines make money?, (ii) What is the airline cost structure, and (iii) In which cost area do you see greatest potential to achieve cost reductions?

Solution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Continental Airlines Case Study Questions

This is only a preview of the solution. Please use the purchase button to see the entire solution

Related Homework Solutions

Business Questions
Homework Solution
$50.00
Accounting
Business
Economy
Finance
Assets
Liabilities
Net Working Capital
Inventory Turnover
Sales
Income Statement
Accounting Questions
Homework Solution
$13.00
Accounting
Least
Squares
Line
Slope
Regression
Y-intercept
Correlation
Coefficient
P-value
Randomly
Business Questions
Homework Solution
$70.00
Business
Financial Analyst
MBA
Economy
Accounting
Management
General Motors
Interest
Bonds
Dividends
Stocks
Risk Premiums
Required Returns
US Government
Cash Flow
Pension Fund
Debt
Investments
Portfolio's Beta
Standard Deviation
Accounting and Banking Questions
Homework Solution
$55.00
Accounting
Business
Finance
Economy
Banking
Federal Reserve
Reserve Ratio
Money Supply
Deposit
Business Questions
Homework Solution
$43.00
Business
Financial Analyst
Accounting
Economy
Stores
Costs
Average Values
Capital Budget
Financial Metrics
Capital Management
Annual Sales
Marginal Tax
Payback Period
Bonds
Projects
Get help from a qualified tutor
Live Chats