Question:
The assignment must be completed as a group assignment for face to face students. Distance students have the option of doing it as a group or can also submit as an individual assignment, if you are unable to form a group online. Face to face students will be allocated into groups of 4-5 members by your respective Lecturer. Distance students can form groups themselves via the discussion forum on Moodle.
Before starting this assessment please read information provided in the Plagiarism and Academic Misconduct tab on Moodle. Students are to exhibit knowledge of the subject matter by demonstrating: Demonstrating accuracy in accounting calculations.Understanding and the ability to analyse and interpret the information from the calculations undertaken.Breadth of quality of analyses and providing appropriate guidance to management decision making.Communication – use of appropriate grammar and the use of appropriate format. Correctly using the APA referencing system to cite academic sources in-text and in the reference list. Sufficient sources used – minimum of 4-6 references.
Allocation of marks Please use the marking criteria sheet provided separately as a guideline for how marks will be allocated. Please ensure that you use the correct referencing style (APA style) as stated in the Unit Profile.
Formatting You are required to consider the case study provided under the Assignment tab below and write an executive report using Power Point. Your report should be set out in an appropriate format under the following headings:
1. Executive summary – one page – an overview of the important issues and their background, and providing a summary of your findings.
2 2. Analysis – details of the analysis undertake and the results. All calculations should be shown.
3. Findings – detail and justify your findings from the analysis. Take care to recognise and describe any limitations.
4. Action items/limitations – detail the limitations from the analysis. Identify potential areas for actions to be undertaken by the organisation.
5. The report must not exceed 8 Power Point Slides (excluding references and appendices, if any) using the Times New Roman Font, font sizes between 16- 18
Submission requirements You must submit your assignment in Power Point format electronically through the secure upload facility in the Moodle system. Please do not email your assignment to your lecturer or the Unit Coordinator. Please ensure all details are complete in the Cover sheet and ensure that it is the FIRST page of your assignment. These are the minimum requirements as outlined in the marking criteria available on the moodle site. However, students should note that satisfactorily meeting the minimum requirements will typically only result in the minimum pass grade being awarded. Higher grades will be awarded for students that exceed these minimum requirements. See the marking criteria for further details.
Assignment questions Maharjan Manufacturing Pty Ltd is a medium-sized manufacturing company with its administration office based in Sydney, NSW. It has been operating since 1990 and manufactures generators. The strategy of Maharjan is to provide environmentally safe generators. It has two manufacturing plants that are based in Coffs Harbour and Port Macquarie, NSW. Coffs Harbour commenced manufacturing in 1990, while Port Macquarie commenced operations in 2005. The following information are available for the two manufacturing plants. The Coffs Harbour plant’s production rate is 320 generators per day, while Port Macquarie is 400. The normal and maximum annual capacity usage at both plants is 240 days and 300 days. Other details include:
Port Macquarie Coffs Harbour Selling Price $450.00 $450.00 Manufacturing variable cost per unit $216.00 $264.00 Manufacturing fixed cost per unit 90.00 45.00 Marketing variable cost per unit 42.00 42.00 Marketing fixed cost per unit 57.00 43.50 Total cost per unit 405.00 394.50 Operating income per unit $45.00 $55.5
Fixed costs per unit are calculated based on a normal capacity usage consisting of 240 working days. This includes all fixed costs. Overtime charges increases the manufacturing variable costs when the number of working days exceeds 240. This increase is by $9.00 per unit in the Port Macquarie Plant and $24.00 per unit in the Coffs Harbour Plant.
The Manager of Maharjan, Mr Raj Maharjan wants the production and sales increased in 2018. He has asked Mr Greg Mumford, the management accountant to work out the ideal number of generators to be manufactured to maximise production in 2018.
Mr Mumford wants to take advantage of the higher operating income at the Coffs Harbour plant. He decides manufacturing of 96,000 units at each plant resulting in a plan in which Coffs Harbour would operate at a maximum capacity (320 units per day x 300 days) and Port Macquarie operates at its normal volume (400 units per day x 240 days).
Assume you are Mr Mumford, and prepare a report to the Manager to advise the results of your analysis in taking advantage of the higher operating income at the Coffs Harbour plant. Your report should include the following:
1. Show how you calculated the contribution margin per unit under normal production and under overtime production. 2. Show how you identified the break-even point for both the plants.
3. Show how you determined the operating income, if 96,000 generators are manufactured at each plant. Show, how the production of 192,000 generators should be allocated between the two plants to maximise the operating income for Maharjan Manufacturing Pty Ltd.
Answer:
|
MAHARJAN MANUFACTURING PTY LTD
|
|
|
|
|
|
1 |
Contribution per unit |
|
|
|
|
|
|
|
(In Dollars) |
|
Under Normal Production |
|
Port Macquarie |
Coffs Harbour |
|
|
|
|
|
|
Selling price |
|
43200000 |
34560000 |
|
Less Variable Cost per unit |
|
|
|
|
Manufacturing |
|
20736000 |
20275200 |
|
Marketing |
|
4032000 |
3225600 |
|
|
|
24768000 |
23500800 |
|
|
|
|
|
|
Total Contribution |
|
18432000 |
11059200 |
|
|
|
|
|
|
No. of Units Produced |
|
96000 |
76800 |
|
|
|
|
|
|
Contritbution per unit |
|
192 |
144 |
|
|
|
|
|
|
|
|
|
|
|
Under Overtime Production |
|
Port Macquarie |
Coffs Harbour |
|
|
|
|
|
|
Selling price per unit |
|
54000000 |
43200000 |
|
Less Variable Cost per unit |
|
|
|
|
Manufacturing |
|
25920000 |
25344000 |
|
Marketing |
|
5040000 |
4032000 |
|
Overtime Charges |
|
1080000 |
2304000 |
|
|
|
32040000 |
31680000 |
|
|
|
|
|
|
Total Contribution |
|
21960000 |
11520000 |
|
|
|
|
|
|
No. of Units Produced |
= |
120000 |
96000 |
|
|
|
|
|
|
Contribution per unit |
|
183 |
120 |
|
|
|
|
|
|
|
|
|
|
2 |
Break Even Point |
|
|
|
|
|
|
|
|
|
|
|
|
(In Dollars) |
|
Under Normal Production |
|
Port Macquarie |
Coffs Harbour |
|
|
|
|
|
|
Fixed Costs |
|
|
|
|
Manufacturing |
|
8640000 |
3456000 |
|
Marketing |
|
5472000 |
3340800 |
|
Total Fixed Costs |
|
14112000 |
6796800 |
|
|
|
|
|
|
Contribution per Unit |
|
192 |
144 |
|
|
|
|
|
|
Break Even Point (In Units) |
|
73500 |
47200 |
|
|
|
|
|
|
|
|
|
(In Dollars) |
|
Under Overtime Production |
|
Port Macquarie |
Coffs Harbour |
|
|
|
|
|
|
Fixed Costs |
|
|
|
|
Manufacturing |
|
8640000 |
3456000 |
|
Marketing |
|
5472000 |
3340800 |
|
Total Fixed Costs |
|
14112000 |
6796800 |
|
|
|
|
|
|
Contribution per Unit |
|
183 |
120 |
|
|
|
|
|
|
Break Even Point (In Units) |
|
77115 |
56640 |
|
|
|
|
|
|
|
|
|
|
3 |
Calculation of Operating Income at 96000 generators production |
|
|
|
|
|
|
|
|
|
|
|
Under Normal Production |
|
Port Macquarie |
Coffs Harbour |
|
|
|
|
|
|
Selling price |
|
43200000 |
43200000 |
|
Less Variable Cost per unit |
|
|
|
|
Manufacturing |
|
20736000 |
25344000 |
|
Marketing |
|
4032000 |
4032000 |
|
Overtimes |
|
|
2304000 |
|
|
|
24768000 |
31680000 |
|
|
|
|
|
|
Total Contribution |
|
18432000 |
11520000 |
|
|
|
|
|
|
Less Fixed Costs |
|
|
|
|
Manufacturing |
|
8640000 |
3456000 |
|
Marketing |
|
5472000 |
3340800 |
|
Total Fixed Costs |
|
14112000 |
6796800 |
|
|
|
|
|
|
Opertaing Income |
|
4320000 |
4723200 |
|
|
|
|
|
|
|
|
|
|
4 |
Allocation of 192000 generators |
|
|
|
|
|
|
|
|
Port Macquarie |
Coffs Harbour |
|
|
|
|
|
|
Sales |
|
54000000 |
32400000 |
|
Less Variable Cost |
|
|
|
|
Manufacturing |
|
25920000 |
19008000 |
|
Marketing |
|
5040000 |
3024000 |
|
Overtime Charges |
|
1080000 |
|
|
|
|
32040000 |
22032000 |
|
|
|
|
|
|
Contribution |
|
21960000 |
10368000 |
|
|
|
|
|
|
Less Total Fixed Costs |
|
14112000 |
6796800 |
|
|
|
|
|
|
|
|
|
|
|
Opertaing Income |
= |
7848000 |
3571200 |
|
|
|
|
|
|
Units Allocated to attain Maximum Operating Income |
|
120000 |
72000 |