Question

In: Accounting

RAK Travel Agency specialises in tour packages between Dubai and Salalah. It books Passengers on EK...

  1. RAK Travel Agency specialises in tour packages between Dubai and Salalah. It books

Passengers on EK Airlines at AED 900 per round-trip package. Until last month, EK Airlines paid RAK Travel a commission of 10% of the package price paid by each passenger. This commission was RAK Travel’s only source of revenues. RAK Travel’s fixed costs are AED 14 000 per month (for salaries, rent, etc.) and its variable costs are AED 20 per package purchased for a passenger. This AED 20 includes an AED 15 per package delivery fee paid to Emirates Post. (To keep the analysis simple, please assume each round-trip package purchased is delivered separately. Thus the AED 15 delivery fee applies to each tour package.)

Considering the recent economy, EK Airlines has just announced a revised payment schedule for all travel agents. It will now pay travel agents a 10% commission per package up to a maximum of AED 50. Any package costing more than AED 500 generates only a AED 50 commission, regardless of the package price.

Instructions

Answer the following questions (15 marks per question, Total 30 marks):

1. Under the old 10% commission structure, how many round-trip packages must RAK Travel sell each month:

(a) to break even and

(b) to earn a profit of AED 7000?

2. How does EK’s revised payment schedule affect your answers to (a) and (b) in requirement 1?

Solutions

Expert Solution

1. (a) Break even
Let assume no of trips for break even is "X"
Total Charge for X Trip = 900X
Commission from "X" Trip = 10% of 900X = 90X
Variable cost = 20X
Fixed cost = 14,000
90X= 14000+ 20X
70X = 14,000
X = (14,000/70) = 200 round trips packages
So, Break even point is 200 round trips packages
(b) to earn profit of AED 7000
Let assume no of trips to earn profit of AED 7000 is "X"
Commission Revenue - Variable cost - Fixed cost = Profit
90X - 20X - 14,000 = 7,000
70X = 21,000
X = (21,000/70)
X= 300 round trips packages
So, to earn profit of AED 7,000 = 300 round trips packages
2. EK's revised payment Schedule = 10% commission per package but upto AED 50/package only
Amount of Round trip package is = AED 900 Fixed
its 10 % is AED 90 but as per revised payment schedule commission would be AED 50 only
So, (a) break even
Let assume no of trips for break even is "X"
Commission from "X" Trip = 50X
Variable cost = 20X
Fixed cost = 14,000
50X= 14000+ 20X
30X = 14,000
X = (14,000/30) = 467 round trips packages
So, Break even point is 467 round trips packages
Hence, break even would increase by 167 (467-300) round trip package.
(b) to earn profit of AED 7000
Let assume no of trips to earn profit of AED 7000 is "X"
Commission Revenue - Variable cost - Fixed cost = Profit
50X - 20X - 14,000 = 7,000
30X = 21,000
X = (21,000/30)
X= 700 round trips packages
Hence, to earn AED 7000, RAK travel agency should sell 233 (700 - 467) round trip package

Related Solutions

Dana Travel Agency specialises in flights between Los Angeles and London. It books passengers on Virgin...
Dana Travel Agency specialises in flights between Los Angeles and London. It books passengers on Virgin Airlines at £900 per round-trip ticket. Until last month, Virgin paid Dana a commission of 10% of the ticket price paid by each passenger. This commission was Dana’s only source of income. The agency expects to sell 500 tickets each month. Dana’s fixed costs are £14,000 per month (for salaries, rent, and so on), and its variable costs are £20 per ticket purchased for...
Bright travel agency specializes in flights between toronto and jamaica. it books passengers on ottawa air....
Bright travel agency specializes in flights between toronto and jamaica. it books passengers on ottawa air. brights fixed costs are $25,500 per month. ottawa air charges passengers $1,300 per round trip ticket.   Calculate the number of tickets bright must sell each month to (a) break even and (b) make a target operating income of $10,000 per month in each of the following independent cases. (round up to the nearest whole number. ex 10.2 should be 11) 1. Brights variable costs...
Sparkle Travel Agency specializes in flights between Toronto and Jamaica. It books passengers on Ottawa Air....
Sparkle Travel Agency specializes in flights between Toronto and Jamaica. It books passengers on Ottawa Air. Sparkle​'s fixed costs are$ 29,500 per month. Ottawa Air charges passengers $1,600 per​ round-trip ticket. Breakeven number of units = ____ / ____ Calculate the number of tickets Sparkle must sell each month to​ (a) break even and​ (b) make a target operating income of $19,000 per month in each of the following independent cases. ​(Round up to the nearest whole number. For​example, 10.2...
Sunset Travel Agency specializes in flights between Toronto and Jamaica. It books passengers on OshawaOshawa Air....
Sunset Travel Agency specializes in flights between Toronto and Jamaica. It books passengers on OshawaOshawa Air. SunsetSunset​'s fixed costs are $29,500 per month. OshawaOshawa Air charges passengers $1,600 per​ round-trip ticket. Read the requiremennt. Calculate the number of tickets SunsetSunset must sell each month to​ (a) break even and​(b) make a target operating income of $12,000 per month in each of the following independent cases. ​(Round up to the nearest whole number. For​ example, 10.2 should be rounded up to​...
Question-4 Travel Agency specializes in flights between Toronto and Peru. It books passengers on Toronto Air....
Question-4 Travel Agency specializes in flights between Toronto and Peru. It books passengers on Toronto Air. North’s fixed costs are $35,000 per month. Toronto Air charges passengers $1,700 per round-trip ticket. Calculate the number of tickets North Travel must sell each month to (a) break even and (b) make a target operating income of $17,000 per month in each of the following independent cases. Required: 1. North’s variable costs are $33 per ticket. Toronto Air pays Sunset 5% commission on...
Explain the difference between a tour wholesaler and a travel agent.
Explain the difference between a tour wholesaler and a travel agent.
ABC Tour Limited is a medium-size travel agency. The staff are using the Microsoft Office, including...
ABC Tour Limited is a medium-size travel agency. The staff are using the Microsoft Office, including Excel, Word and Power-point, to conduct most of their daily operations and record keeping. John, the general manager of ABC Tour, would like to increase the operation efficiency by replacing the Microsoft Office with a new customer relationship management (CRM) software. However, the labor union is opposing on the change due to some concerns. (a)In order to tailor-made the CRM system, the IT vendor...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT