AirBorne is a small airline operating out of Boise, Idaho. Its three flights travel to Salt Lake City, Reno, and Portland. The owner of the airline wants to assess the full cost of operating each flight. As part of this assessment, the costs of two support departments $($maintenance and baggage$)$ must be allocated to the three flights. The two support departments that support all three flights are located in Boise $($any maintenance or baggage costs at the destination airports are directly traceable to the individual flights$).$ Budgeted and actual data for the year are as follows for the support departments and the three flights: Use the rounded values for subsequent calculations.

Support Centers Flights

Maintenance Baggage Salt Lake City Reno Portland

Budgeted data:

Fixed overhead $$240,000$ $$150,000$ $$20,000$ $$18,000$ $$30,000$

Variable overhead $$30,000$ $$64,000$ $$5,000$ $$10,0006,000$

Hours of flight time$*2,0004,0002,000$

Number of passengers $10,00015,0005,000$

Actual data:

Fixed overhead $$235,000$ $$156,000$ $$22,000$ $$17,000$ $$29,500$

Variable overhead $$80,000$ $$33,000$ $$6,200$ $$11,000$ $$5,800$

Hours of flight time $1,8004,2002,500$

Number of passengers $8,00016,0006,000$

$*$Normal activity levels.

Round all allocation ratios and variable rates to four significant digits. Round all allocated amounts to the nearest dollar.

Required:

$1.$ Using the direct method, allocate the support service costs to each flight, assuming that the objective is to determine the cost of operating each flight.

Allocation ratios for fixed costs

SLC Reno Portland

Hours of flight time fill in the blank $1$

fill in the blank $2$

fill in the blank $3$

Number of passengers fill in the blank $4$

fill in the blank $5$

fill in the blank $6$

Variable rates:

Maintenance: $fill in the blank $7$

per flight hour

Baggage: $fill in the blank $8$

per passenger

Cost Allocation

SLC Reno Portland

Maintenance$$fixed: $fill in the blank $9$

$fill in the blank $10$

$fill in the blank $11$

Maintenance$$variable: fill in the blank $12$

fill in the blank $13$

fill in the blank $14$

Baggage$$fixed: fill in the blank $15$

fill in the blank $16$

fill in the blank $17$

Baggage$$variable: fill in the blank $18$

fill in the blank $19$

fill in the blank $20$

$fill in the blank $21$

$fill in the blank $22$

$fill in the blank $23$

$2.$ Using the direct method, allocate the support service costs to each flight, assuming that the objective is to evaluate performance.

SLC Reno Portland

Maintenance$$fixed: $fill in the blank $24$

$fill in the blank $25$

$fill in the blank $26$

Maintenance$$variable: fill in the blank $27$

fill in the blank $28$

fill in the blank $29$

Baggage$$fixed: fill in the blank $30$

fill in the blank $31$

fill in the blank $32$

Baggage$$variable: fill in the blank $33$

fill in the blank $34$

fill in the blank $35$

$fill in the blank $36$

$fill in the blank $37$

$fill in the blank $38$Allocation ratios for fixed costs

Using the direct method, allocate the support service costs to each flight, assuming that the objective is to evaluate performance.