On average, the annual sales information per market segment for the past full 12-month year were:

The following it for total number of jets in fleet and total number of service contracts annually, respectively.

Large Commercial 300, 12

Medium Commercial 150, 18

Small Corporate 15, 48

Small private 3, 165

The Division had established a competitive service contract price of $10,000,000 per large commercial contract and $4,000,000 per medium commercial contract. The service contract price was set at $1,250,000 per new small corporate contract and $400,000 per new small private contract.

The 1,200 highly-trained professional staff included the following 3 employee groups:

1. 600 Engineering staff (mechanical, electrical, and software engineers) Engineering staff were paid an annual salary of $120,000 plus an additional 25% in fringe benefits (health plan, pension);

2. 200 Documentation staff (technical and aeronautical professionals, professional pilots) Documentation staff were paid an annual salary of $95,000 plus an additional 20% in fringe benefits;

3. 400 General maintenance staff (pre-boarding cleaning, decontamination, stocking, fueling of aircraft) General maintenance staff were paid and annual salary of $60,000 plus an additional 15% in fringe benefits.

All staff worked 160 hours per person per month (over 20 days/month). This included an average of 2 hours per person per day of training, quality meetings, staff meeting, break times, etc., which were not production time. All staff worked on a rotating schedule such that the Division was able to maintain its commitment to 24/7 service (all day/year-round); in other words, the company operated during the entire 8,760 hours per year. The Division utilized state-of-the-art facilities and sophisticated equipment. These included hangars, towing trucks, specialty cranes, diagnostic equipment, computers, laser sensors, acoustic sensors, fueling depots and de-contamination devices, to name a few. In total, the facilities and equipment represented an annual expense of $145,000,000. The facilities operated non-stop throughout the year (for 8,760 hours).

Large Commercial Service Contracts

On average, each service contract required $300,000 of materials (parts), and $400,000 of direct labour, and the following consumption of resources by activities: (hours)

The following are for Engineering staff, Documentation Staff, General Maintenance Staff, respectively.

Administration 90hrs, 100hrs, 200hrs

Parts 275hrs, 50hrs, 100hrs

Maintenance 16,000hrs, 100hrs, 200hrs

Preparation 175hrs, - , 10hrs

Inspection 750hrs, 8000hrs, 16,000hrs,

Facilities and Equipment usage was 120 hours for each large commercial contract.

Medium Commercial Service Contracts

On average, each service contract required $100,000 of materials (parts), and $150,000 of direct labour, and the following consumption of resources by activities: (hours)

The following are for Engineering staff, Documentation Staff, General Maintenance Staff, respectively.

Administration 90hrs, 90hrs, 180hrs

Parts 275hrs, 50hrs, 100hrs

Maintenance 8000hrs, 20hrs, 40hrs

Preparation 90hrs, 100hrs, 10hrs

Inspection 350hrs, 6000hrs, 12,000hrs

Facilities and Equipment usage was 100 hours for each medium commercial contract.

Small Corporate Service Contracts

On average, each service contract required $25,000 of materials (parts), $50,000 of direct labour, and the following consumption of resources by activities: (hours)

The following are for Engineering staff, Documentation Staff, General Maintenance Staff, respectively.

Administration 90hrs, 80hrs, 160hrs

Parts 275hrs, 100hrs, 200hrs

Maintenance 3000hrs, 40hrs, 80hrs

Preparation 35hrs, - , 5hrs

Inspection 18 hrs, 500 hrs, 1000hrs

Facilities and Equipment usage was 50 hours for each small corporate contract.

Small Private Service Contracts

On average, each service contract required $10,000 of materials (parts), and $15,000 of direct labour, and the following consumption of resources activities: (hours)

The following are for Engineering staff, Documentation Staff, General Maintenance Staff, respectively.

Administration 75hrs, 70hrs, 140hrs

Parts 180hrs, 30hrs, 60hrs

Maintenance 1700hrs, 8hrs, 15hrs

Preparation 35hrs, -, 10hrs

Inspection 15hrs, 100hrs, 200hrs

Facilities and Equipment usage was 10 hours for each small private contract.

Q1) Assume the Division has entered into the two new market segments and that it uses its current traditional job costing system. Calculate the gross margin for each of the four market segments and for the Division for the past year.

Q2) Assume the Division uses a TDABC system. Reflecting on its impact on the profitability of the Division last year, provide one recommendation to address the issue of unused capacity. Clearly show your calculations of unused capacity.