Run a few sensitivity analyses with varying fuel and


Allegiant Air bills itself "America's favorite small cities to world-class destinations, Allegiant makes leisure travel affordable and convenient." As of 2013, it is the most profitable U.S. airline based on margin on revenue and unique in that it operates only used aircraft. The backbone of the fleet is 57 MD- 80 aircraft, but it also operates 6 Boeing 757-200s and is adding 9 Airbus A319 aircraft. Allegiant acquired 18 of its early MD-80s from Scandinavian Airways System paying roughly $4 million dollars per plane in an all cash transaction. Allegiant believes it can continue its aggressive fleet expansion with additional used MD-80s acquired for the same price as American Airlines and Delta Air Lines reduce their large MD-80 fleets. Although these aircraft have a useful service life of 15 more years, Allegiant recognizes it must eventually modernize its fleet. As with all older aircraft, the MD-80 burns more fuel and requires more maintenance than new generation aircraft of equal mission capability.

Escalating and volatile fuel prices have added to senior management's interest in evaluating new aircraft. Because it already operates Airbus 319s, the slightly larger Airbus A-320 is its preferred option. As you will see, this decision is critically dependent on your projection for future fuel costs and the discount rate employed.

The Analysis

An Excel template is provided as an attachment for conducting your net present value analysis. You will need to insert costs and performance figures into the template. You may wish to review the template before reading further.

In order to complete your analysis, you will need to obtain current aircraft operating data and prices from authoritative sources. The sources listed below are sufficient and adequate for your project:

- Aircraft prices: Airbus publishes its aircraft list prices periodically. Search the Airbus Industries website or simply do a Google search for "Airbus aircraft list prices."

- Aircraft performance data and operating costs: The Airline Monitor publishes extensive airline data needed for your analysis. The Airline Monitor is available through the Hunt Library Aerospace/Aviation electronic databases. When you've accessed The Airline Monitor, select Online Edition, then Block Hour Operating Costs (pdf). This is a large document. Be certain to use Allegiant's reported data for the MD-80 and industry data for the A-320 (use the data for the A-320, not the A0320neo). The data you need looks like this:

System Operations

 

737-300

 

 

737-400

 

 

All Services

Total
737-300

 

South- west

USAir-
ways

Total
737-400

 

Alaska

USAir-
ways

Operating Data

Revenue Pass. Miles (mil.)

17.938.9

 

17,514.8

424.1

7.831.8

 

3.441.2

4.390.6

Available Seat Miles (mil.)

23,051.8

 

22,536.3

515.4

9,565.6

 

4.312.3

5,253.3

Load Factor

77.8%

 

77.7%

82.3%

81.9%

 

79.8%

83.6%

Revenue Miles                   (000)

168.590

 

164.499

4.091

69.880

 

33.398

36,481

Revenue Hours

418.645

 

407.917

10.728

169.791

 

79.463

90,328

Block Hours

499.655

 

485,648

14,007

206.653

 

94,095

112,558

Aircraft Days

54,938

 

52,572

2,366

25,549

 

10,990

14,559

Revenue Departures

314,766

 

306,097

8,669

107,560

 

51,059

56,501

Gallons of Fuel          (000)

370.659

 

359.902

10.757

166.864

 

74,559

92,305

Number of Aircraft

150.5

 

144.0

6.5

70.0

 

30.1

39.9

Year End Pass. Fleet & % measured

164

91.8%

 

 

73

95.9%

 

 

Financial Data                    (000)

 

 

 

 

 

 

 

 

Flight Crew Expense

$433,029

 

$392.174

840.855

$119.063

 

579,669

539,394

Fuel Expense

1.200.988

 

1.167.867

33.121

524.984

 

240.784

284,200

Total Flying Expense

1,691,992

 

1,617,495

74,497

660,916

 

329,426

331,490

- Fuel Prices: Your estimate of fuel prices over the next twenty years is critical. Historical data on jet fuel prices are available from several sources. The Airline Monitor includes this data in the Block Hour Operating Cost document (above). Data are also available from the industry association Airlines for America. Select Economics & Analysis, then Traffic & Financial Results. Scroll down to select the appropriate reports. You may also find long-range forecast energy prices from the American Energy Information Administration useful.

Note that fuel prices increased dramatically during the global economic expansion of the mid-2000s peaking at nearly $4 per gallon in June 2008, but plummeted during the subsequent recession. Fuel costs will certainly increase again when world demand recovers. You will need to estimate future fuel costs for the analysis. Be certain that the fuel price for the first year is the current jet fuel spot price (available from several sources via a web search).

Conduct a sensitivity analysis for a range of projected fuel prices. This is often done using optimistic, pessimistic, and most likely projections.

- Return on invested capital (the discount rate): The appropriate rate varies by airlines; however, the following extracts from the financial press are illustrative. Alaska Air Group CEO Bill Ayer pointed to "its target of 10% return on invested capital (ROIC). For its part Delta, is also targeting a 10% sustainable return on invested capital, according to President Ed Bastian." (CAPA, 2010, June 16). Southwest Airlines is looking for a 15% ROIC. Your fleet replacement decision will depend on what rate you choose. Airlines with the best credit can borrow at the lower rates which also decreases the discount rate. You should perform a sensitivity analysis (work the problem with several discount rates) to better understand and defend your recommendation.

SH&E staff have surveyed Allegiant's management to arrive at several critical assumptions about aircraft costs and performance.

1. Airlines with solid balance sheets, such as Allegiant, can normally obtain new aircraft for about two- thirds (2/3) of list price. After 15 years, an A-320 is estimated to be worth about half of the original purchase price (not list price) in the used market whereas an MD-80 will have only $100,000 in scrap value 15 years hence. Even if Allegiant should continue to operate the new planes beyond 15 years, these values still represent an opportunity cost.

2. Because Allegiant's segment lengths are relatively long, it believes fuel burns (gallons per block hour) on a new A-320 will meet the lowest of any airline and that speed in miles per block will equal the highest of any airline.

3. Although Allegiant's business model does not provide for high aircraft utilization, because of the A- 320 greater range capability, annual utilization (block hours per year) for the A-320 will be 20% higher than for the MD-80. Note: This annual utilization is for one aircraft, not the entire fleet.

4. Allegiant plans to outsource its heavy maintenance, so it will pay another airline or maintenance repair facility for both direct and burden (overhead) costs. If it decides to purchase a new fleet type, Allegiant believes that its first year maintenance expense will equal the lowest for any airline operating the Airbus 320 but that these costs will increase by 2% per year. However, as the current fleet of MD-80s age, Allegiant believes that maintenance costs for this fleet will increase by 5% per year.

5. Allegiant configures its aircraft in high density, all-coach configuration. It plans a seating capacity equal to the highest of any airline.

6. Allegiant does not expect crew expenses to change with the choice of aircraft, so this and other immaterial costs are not included in the analysis (an extra flight attendant will be required but this cost is ignored here).

Task

Enter data into the Excel template. Run a few "sensitivity" analyses with varying fuel and discount rates to see how the fleet replacement decision changes. Remember that the net present value obtained is a total cost of operation. The spreadsheet computes the cost per available seat mile (CASM). The aircraft with the lowest net present value CASM is the best financial choice. Prepare a memorandum (not more than 2 pages) to Mr. Sheldon summarizing your analysis and making a recommendation. Remember that executive management will need to understand how the analysis was conducted. Explain your assumptions and methodology concisely. Insert (copy and paste) and reference Excel worksheets as appendices to support your fleet replacement recommendation. Use other tables and graphs as appropriate to support your recommendation.

Attachment:- fleet_replacement.xls

Request for Solution File

Ask an Expert for Answer!!
Macroeconomics: Run a few sensitivity analyses with varying fuel and
Reference No:- TGS01081458

Expected delivery within 24 Hours