Question

In: Accounting

Product Costing and Decision Analysis for a Service Company Blue Star Airline provides passenger airline service,...

Product Costing and Decision Analysis for a Service Company

Blue Star Airline provides passenger airline service, using small jets. The airline connects four major cities: Charlotte, Pittsburgh, Detroit, and San Francisco. The company expects to fly 170,000 miles during a month. The following costs are budgeted for a month:

Fuel $2,120,000
Ground personnel 788,500
Crew salaries 850,000
Depreciation 430,000
Total costs $4,188,500

Blue Star management wishes to assign these costs to individual flights in order to gauge the profitability of its service offerings. The following activity bases were identified with the budgeted costs:

Airline Cost Activity Base
Fuel, crew, and depreciation costs Number of miles flown
Ground personnel Number of arrivals and departures at an airport

The size of the company's ground operation in each city is determined by the size of the workforce. The following monthly data are available from corporate records for each terminal operation:

Terminal City Ground Personnel Cost Number of Arrivals/Departures
Charlotte $256,000 320
Pittsburgh 97,500 130
Detroit 129,000 150
San Francisco 306,000 340
Total $788,500 940

Three recent representative flights have been selected for the profitability study. Their characteristics are as follows:

Description Miles Flown Number of Passengers Ticket Price per Passenger
Flight 101 Charlotte to San Francisco 2,000 80 $695.00
Flight 102 Detroit to Charlotte 800 50 441.50
Flight 103 Charlotte to Pittsburgh 400 20 382.00

Required:

1. Determine the fuel, crew, and depreciation cost per mile flown.
$ per mile

2. Determine the cost per arrival or departure by terminal city.

Charlotte $
Pittsburgh $
Detroit $
San Francisco $

3. Use the information in (1) and (2) to construct a profitability report for the three flights. Each flight has a single arrival and departure to its origin and destination city pairs. Enter all amounts as positive numbers, except for a negative income from operations.

Blue Star Airline
Flight Profitability Report
For Three Representative Flights
Flight 101 Flight 102 Flight 103
Passenger revenue $ $ $
Fuel, crew, and depreciation costs $ $ $
Ground personnel
$ $ $
Flight income from operations $ $ $

Solutions

Expert Solution

1. Fuel, crew, and depreciation cost per mile = ($2120000 + $850000 + $430000)/170000 = $3400000/170000 = $20 per mile

2. Cost per arrival or departure by terminal city:

Charlotte $        800
Pittsburgh $        750
Detroit $        860
San Francisco $        900

Working:

Charlotte: $256000/320 = $800

Pittsburgh: $97500/130 = $750

Detroit: $129000/150 = $860

San Francisco: $306000/340 = $900

3.

Blue Star Airline
Flight Profitability Report
For Three Representative Flights
Flight 101 Flight 102 Flight 103
Passenger revenue 55600 22075 7640
Fuel, crew, and depreciation costs 40000 16000 8000
Ground personnel 1700 1660 1550
41700 17660 9550
Flight income from operations 13900 4415 -1910

Working:

Flight 101 Flight 102 Flight 103
Passenger revenue 80 x $695 50 x $441.50 20 x $382
Fuel, crew, and depreciation costs 2000 x $20 800 x $20 400 x $20
Ground personnel $800 + $900 $860 + $800 $800 + $750

Related Solutions

Product Costing and Decision Analysis for a Service Company Blue Star Airline provides passenger airline service,...
Product Costing and Decision Analysis for a Service Company Blue Star Airline provides passenger airline service, using small jets. The airline connects four major cities: Charlotte, Pittsburgh, Detroit, and San Francisco. The company expects to fly 170,000 miles during a month. The following costs are budgeted for a month: Fuel $2,120,000 Ground personnel 788,500 Crew salaries 850,000 Depreciation 430,000 Total costs $4,188,500 Blue Star management wishes to assign these costs to individual flights in order to gauge the profitability of...
Product Costing and Decision Analysis for a Service Company Blue Star Airline provides passenger airline service,...
Product Costing and Decision Analysis for a Service Company Blue Star Airline provides passenger airline service, using small jets. The airline connects four major cities: Charlotte, Pittsburgh, Detroit, and San Francisco. The company expects to fly 170,000 miles during a month. The following costs are budgeted for a month: Fuel $2,120,000 Ground personnel 788,500 Crew salaries 850,000 Depreciation 430,000 Total costs $4,188,500 Blue Star management wishes to assign these costs to individual flights in order to gauge the profitability of...
Product Costing and Decision Analysis for a Service Company Pleasant Stay Medical Inc. wishes to determine...
Product Costing and Decision Analysis for a Service Company Pleasant Stay Medical Inc. wishes to determine its product costs. Pleasant Stay offers a variety of medical procedures (operations) that are considered its “products.” The overhead has been separated into three major activities. The annual estimated activity costs and activity bases follow: Activity Budgeted Activity Cost Activity Base Scheduling and admitting $432,000              Number of patients Housekeeping 4,212,000              Number of patient days Nursing 5,376,000              Weighted care unit     Total costs $10,020,000              Total “patient...
PRODUCT COSTING FOR MANAGEMENT AND PRICING (2-5) 1. Service Company Allocation of Overhead Blue Computer Repair...
PRODUCT COSTING FOR MANAGEMENT AND PRICING (2-5) 1. Service Company Allocation of Overhead Blue Computer Repair treats each repair order as a job. Overhead is allocated based on the cost of technician time. At the start of the year, annual technician wages were estimated to be $800,000, and company overhead was estimated to be $500,000. Required a.   Discuss why use of a predetermined overhead rate would be preferred to assigning actual overhead to repair jobs. b.   Suppose a job required...
The Airline industry provides passenger and freight transport services through its fleet of aircraft flying to...
The Airline industry provides passenger and freight transport services through its fleet of aircraft flying to domestic and international destinations. The industry is part of the air travel value chain which includes suppliers as well as distributors of the main service provider, the airlines' company. The chain is set up to cater to the needs of the ultimate customers in the process, air travellers. Qantas Airlines is the designated national carrier of Australia. It operates both domestically and internationally. The...
In performing short-term CVP analysis for a new product or service, the decision-maker would: Group of...
In performing short-term CVP analysis for a new product or service, the decision-maker would: Group of answer choices Include only allocated fixed costs. Include only current fixed costs. Include all current and future fixed costs. Include only incremental fixed costs. Include only future fixed costs. PreviousNext
Break-Even Sales and Sales Mix for a Service Company Zero Turbulence Airline provides air transportation services...
Break-Even Sales and Sales Mix for a Service Company Zero Turbulence Airline provides air transportation services between Los Angeles, California; and Kona, Hawaii. A single Los Angeles to Kona round-trip flight has the following operating statistics: Fuel $8,258 Flight crew salaries 6,325 Airplane depreciation 2,987 Variable cost per passenger—business class 40 Variable cost per passenger—economy class 30 Round-trip ticket price—business class 570 Round-trip ticket price—economy class 250 It is assumed that the fuel, crew salaries, and airplane depreciation are fixed,...
Break-Even Sales and Sales Mix for a Service Company Zero Turbulence Airline provides air transportation services...
Break-Even Sales and Sales Mix for a Service Company Zero Turbulence Airline provides air transportation services between Los Angeles, California, and Kona, Hawaii. A single Los Angeles to Kona round-trip flight has the following operating statistics: Fuel $7,000 Flight crew salaries 3,200 Airplane depreciation 3,480 Variable cost per passenger—business class 140 Variable cost per passenger—economy class 120 Round-trip ticket price—business class 800 Round-trip ticket price—economy class 300 It is assumed that the fuel, crew salaries, and airplane depreciation are fixed,...
Put together an Industry Analysis of the U.S. passenger airline industry using Porter’s Five Forces model...
Put together an Industry Analysis of the U.S. passenger airline industry using Porter’s Five Forces model and Seeger’s Economic Ratio approach.   After your analysis, conclude with reasons why this industry is a good bet for an investment or not. NOTE:   While you do not have data on the Economic ratios, you will use your judgement, and business acumen to make reasonable judgements about the potential range of values of the ratios (for example, relatively high or relatively low) based on...
LowFare is a no-frills airline that provides daily shuttle service in the northeast United States. Passengers...
LowFare is a no-frills airline that provides daily shuttle service in the northeast United States. Passengers are predominantly businesspeople who travel between New York and Boston for the day. Identify one measure in each of the four perspectives of the balanced scorecard that LowFare managers should monitor. Explain your reasoning for each.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT