Reference no: EM13505841

Far East Adventure Holidays offers a variety of holiday packages aimed at families, seniors and corporate groups. The Financial Controller Amy Wu is preparing for the annual Board meeting, and is concerned about the loss the business has made in the last year. She has examined the profits for each of the three departments of the business - family, seniors and corporate - and it seems that corporate is the source of the problem.

Amy has asked for your assistance to look more closely at the three packages offered by the corporate department, to see which packages are making profits and which are not. The three packages are to Sri Lanka, Singapore and Cambodia. The sales and direct costs for each corporate package over the last year was as follows:-

 

	Sri Lanka Adventure	Singapore Discovery	Cambodia Explorer
Number of packages sold	10	20	10
Number of people per package	5	6	8
Revenue per person	$         18,000	$   12,000	$  14,000
Direct Cost per package:
Tour Leader	$           5,000	$   12,000	$    9,000
Tour Assistant	$           2,000	$     3,000	$    6,000
Air Travel	$         28,000	$   30,000	$  32,000
Accommodation	$         15,000	$   26,000	$  24,000
Equipment Hire	$           4,000		$    9,000
Meals	$         18,000	$   15,000	$    8,000

The profit of each package is calculated by allocating a proportion of the overhead costs of running the corporate department, based on the proportion of actual sales revenue. For last year these overhead costs were as follows:-

Salaries 200,000 
Phone 2,000 
Depreciation on Equipment 5,000 
Utilities 2,000 
Rent and Taxes 9,000 
Other department costs 12,000 
Total Corporate Dept 230,000

Required:

1. Calculate the profit per package and the total profitability of each of the three corporate packages

2. Compare the profitability of the three corporate packages

3. Do you believe that the allocation of department overhead to packages based on actual sales revenue is appropriate? Can you suggest a better method?

4. Use your method in part 3 to develop an alternative report on the profitability of each package for the year.

5. Based on your answer to 4, identify the actions Fast East Adventure Holidays should take to improve profitability