Question

In: Accounting

A while later Manny comes into your office with another proposal that came past his desk....

A while later Manny comes into your office with another proposal that came past his desk. As part of GT’s mining operations, GT produces its own mine excavator tracks. A Japanese consortium, KoBI Engineering, has approached GT to produce the excavator tracks for GT.

You pull out your general ledger report, and you review the expenses for tracks last year. GT will typically produce its 90 excavator tracks, with a cost to the end of last year as follows:

Direct Materials: $175,000

Labour for employees working directly on the tracks: $300,000

Overhead for Factory workshop:

Annual Rent: $100,000

Annual Depreciation on factory machinery: $12,000

Factory Machine parts: $50,000

Factory Utilities: $30,000

Kobi has offered to sell GT the excavator tracks at $6,100/ unit.

The workshop is used for a number of functions outside of the manufacturing of tracks.

Requirement:

Undertake an analysis of the above costs and advise Manny on which option should be taken from a purely financial perspective

Question 2(b):

GT has three products that it sells: Copper, Bauxite, and Gravel. Results of the fourth quarter are presented below:

Copper Bauxite Gravel Total

Tonnage Sold 10,000 20,000 20,000

Revenue $22,000,000 $40,000,000 $23,000,000 $85,000,000

Variable costs 17,000,000 22,000,000 12,000,000 51,000,000

Direct fixed costs 1,000,000 3,000,000 2,000,000 6,000,000

Allocated fixed costs 8,000,000 8,000,000 8,000,000 24,000,000

Net income (loss) $ (4,000,000) $ 7,000,000 $ 1,000,000 $ 4,000,000

The allocated fixed costs are unavoidable. Demand of individual products is not affected by changes in other product lines.

Requirement

Do a financial analysis of what will happen to profits if GT sells the copper division?

Question 2(c):

Use the financial information provided to you in part 2(b). Please do a break-even analysis on each product to confirm the level of production needed for each product line.

Solutions

Expert Solution

Answer to 2(a):
Make or Buy Decision
Calculation of Cost of Manufacturing Excavator
Particulars Amount
Direct Materials $1,75,000
Labour $3,00,000
Overheads:
Annual Rent $1,00,000
Annual Depreciation $12,000
Factory Machine Parts $50,000
Factory Utilities $30,000
Cost of Manufacturing Excavators $6,67,000
No of Excavators $90
Cost Per Unit $7,411
Purchase Cost From Kobi $6,100
From Financial perspective Purchasing from Kobi Excavators is better as Cost is less.
Answer to 2(b):
Overall Net Profit/(Loss) $40,00,000
If Copper Division is Sold then Overall Profit / (Loss)
Total Revenue $6,30,00,000
Less: Variable Costs $3,40,00,000
Less: Direct Fixed Costs $50,00,000
Less: Allocated Fixed Costs Unavoidable $2,40,00,000
Overall Net Profit/(Loss) $0
So, if Copper Division is Sold then Overall Profit will be 0 So it is not advisable to Sell Copper Division
Answer to 2©:
Break Even Points
Copper Bauxite Gravel
Revenue $2,20,00,000 $4,00,00,000 $2,30,00,000
Less: Variable Costs $1,70,00,000 $2,20,00,000 $1,20,00,000
Contribution $50,00,000 $1,80,00,000 $1,10,00,000
Contribution %                   22.73                   45.00                   47.83
Fixed Costs:
Direct $10,00,000 $30,00,000 $20,00,000
Allocated $80,00,000 $80,00,000 $80,00,000
Total $90,00,000 $1,10,00,000 $1,00,00,000
Break Even Point $3,96,00,000 $2,44,44,444 $2,09,09,091
(Fixed Cost/Contribution %)

Related Solutions

While working in your office, you get an urgent email from the director of another department,...
While working in your office, you get an urgent email from the director of another department, Max. Max claims that your work activity created a problem resulting in delays with his subordinates processing an important project, and that he needs a solution to this problem as soon as possible. Upon further investigation, you discover that there are some sub-assembly components needed that are not available for use. You have a couple of options that may help to mitigate the problem....
The partner in charge of the James Spencer Corporation audit comes by your desk and leaves...
The partner in charge of the James Spencer Corporation audit comes by your desk and leaves a letter he has started to the CEO and a copy of the statement of cash flows for the year ended December 31, 2020. Because he must leave on an emergency, he asks you to finish the letter by explaining (1) the difference between the net income and cash flow amounts, (2) the importance of operating cash flow, (3) the sustainable source(s) of cash...
A Parkinson's patient comes to the office where you are working as a patient educator. His...
A Parkinson's patient comes to the office where you are working as a patient educator. His wife believes that the problem is in his muscles. Explain to the patient and his wife what is really affected and why he has these symptoms.
1. Christian Wolff, an infamous accountant (and martial artist), is injured while shutting his computer desk...
1. Christian Wolff, an infamous accountant (and martial artist), is injured while shutting his computer desk drawer in his office at work with a karate chop. A. Workers compensation would likely cover the employee’s injury. B. This is a violation of Title VII of the Civil Rights Act. C. As closing drawers with a karate chop is not part of an accountant job, his injury will not be eligible for workers compensation. D. Whether or not workers compensation applies to...
A new business client comes to your office. There are three owners of the business. The...
A new business client comes to your office. There are three owners of the business. The three individuals, Alan, Bob, and Carol, are thinking about forming a partnership. Alan is only investing $1 million in cash. He will not have anything to do with the daily activities of the business. Bob has had some experience in the business and will be responsible for the day-to-day operations of the business. Carol has a great deal of experience and many contacts within...
A new business client comes to your office. There are three owners of the business. The...
A new business client comes to your office. There are three owners of the business. The three individuals, Alan, Bob, and Carol, are thinking about forming a partnership. Alan is only investing $1 million in cash. He will not have anything to do with the daily activities of the business. Bob has had some experience in the business and will be responsible for the day-to-day operations of the business. Carol has a great deal of experience and many contacts within...
A new business client comes to your office. There are three owners of the business. The...
A new business client comes to your office. There are three owners of the business. The three individuals, Alan, Bob, and Carol, are thinking about forming a partnership. Alan is only investing $1 million in cash. He will not have anything to do with the daily activities of the business. Bob has had some experience in the business and will be responsible for the day-to-day operations of the business. Carol has a great deal of experience and many contacts within...
One late Friday afternoon your obnoxious boss comes into your office as you are about to...
One late Friday afternoon your obnoxious boss comes into your office as you are about to leave, and shows you 26 observations that he believes to be related. Y, he believes, is the dependent variable and X1 is the independent variable. He also thinks there is a 2nd order polynomial relationship in the data ( Y = B1X1 +B2X12 + B0 ), and, as you casually view the data, you tend to agree. He insists that the determination of B1,...
SUBJECT : HEALTHCARE ETHICS You are a general practitioner and a mother comes into your office...
SUBJECT : HEALTHCARE ETHICS You are a general practitioner and a mother comes into your office with her child who is complaining of flu-like symptoms. Upon entering the room, you ask the boy to remove his shirt and you notice a pattern of very distinct bruises on the boy's torso. You ask the mother where the bruises came from, and she tells you that they are from a procedure she performed on him known as "cao gio," which is also...
5. A patient comes into your doctor’s office (you specialize in immunology and allergy) with a...
5. A patient comes into your doctor’s office (you specialize in immunology and allergy) with a problem. Every time they get a gastro-intestinal infection, they have a very severe inflamed gut. This doesn’t happen when they get either respiratory or skin infections. When you biopsy the iliac and mesenteric lymph nodes, you don’t find any B or T cells that are responsive to the infection, which is a bit surprising. Based on the role of LN and GALT, explain why...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT