questions is in the linked files
ACC202 - Management Accounting Trimester 2 2018 GROUP ASSIGNMENT Student Id Number S tu d en t N a m e S tu d en t N a m e S tu d en t N a m e S tu d en t N a m e Student Id Number Student Id Number Student Id Number Student Id Number Student Name Question Student Mark Scenario 1 /25 Scenario 2 /25 Total Assignment /50 Assessment Mark (out of 20) /20 Overview Group Assignment: 3-5 members (or as agreed with your Tutor) Nature of Assignment: Computational LO refer (a,b,c) as per Section 2.3 Subject Outline Date Due: Week 10(Friday 10pm) Worth: 20% Submission Method: via Moodle (printed copy to Tutor) Instructions · This is a Group Assignment of 3-5 members (or as agreed with your Tutor). The groups must be finalised prior to the Mid-trimester test in Week 6. · Write each of your Student Names and Numbers at the top of this page IN THE BOX PROVIDED. Ensure you identify who your group lead is. The Group lead will be responsible for all correspondence with the Tutor as well as the assignment final submission. Scenario 1 (25 marks): Customer Profitability Louise Fairbern operates Interiors by Louise, an interior design consulting and window treatment fabrication business. Her business is made up of two different distribution channels: a consulting business in which Louise serves two architecture firms (Adams and Betz), and a commercial window treatment business in which Louise designs and constructs window treatments for three commercial clients (Chatham, Dedham and Elm). Louise wishes to evaluate the profitability of her two architecture-firm clients and three commercial window treatment clients, as well as evaluate the profitability of each of the two channels and the business as a whole. Information relating to the most recent quarter is: Adams Betz Chatham Dedham Elm Gross revenue $234 000 $188 800 $357 380 $147 840 $73 200 Direct costs 147 000 117 200 218 400 115 720 57 040 The total overhead costs are $340 400. Louise estimates that 25% of her overhead costs relate directly to her architectural business, 40% directly to her window-treatment business, and the remainder are general in nature. On the revenues above, Louise gave a 10% discount to Adams to lure this customer from a competitor and gave a 5% discount to Elm for advance payment in cash. Required 1. Prepare an activity-based customer-cost report, distribution channel cost report and a customer-profitability analysis for the five customers. Ensure that you also include an overall total profitability analysis for the business. (10 marks) 2. Write a report to Louise Fairbern relating customer costs, customer profitability, distribution channel profitability and total profitability. Support the report with the analyses you have prepared and recommend courses of action to Louise. The report excluding the computational analysis should be around 500-1000 words and should include a brief introduction, analysis, recommendation and conclusion. (15 marks) Scenario 2 (25 Marks): Transfer Pricing The Australian Instrument Company (AIC) consists of the Semiconductor Division and the Process Control Division, each of which operates as an independent profit centre. The Semiconductor Division employs craftspeople who produce two different electronic components: the new high-performance Super-chip and an older product called Okay-chip. These two products have the following cost characteristics: Super-chip Okay-chip Direct materials $5 $2 Direct manufacturing labour, 3 hours × $20; 1 hour × $20 60 20 Annual overhead in the Semiconductor Division totals $400 000, all fixed. Due to the high skill level necessary for the craftspeople, the Semiconductor Division’s capacity is set at 45 000 hours per year. One customer orders a maximum of 15 000 Super-chips per year, at a price of $80 per chip. The rest of the Semiconductor Division’s capacity is devoted to the Okay-chip, for which there is unlimited demand at $26 per chip. The Process Control Division produces only one product, a process-control unit, with the following cost structure: · direct materials (circuit board): $70 · direct manufacturing labour: $45 (3 hours * $15) Fixed overhead costs of the Process Control Division are $80 000 per year. The current market price for the control unit is $132 per unit. A joint research project has just revealed that a single Super-chip could be substituted for the circuit board currently used to make the process-control unit. Direct labour cost of the processcontrol unit would not change. The improved process-control unit could be sold for $145. Required 1. Calculate the contribution margin per hour of selling the Super-chip and the Okay-chip. If no transfers of Super-chip are made to the Process Control Division, how many Super-chips and Okay-chips should the Semiconductor Division manufacture and sell? Show your calculations. (6 marks) 2. The Process Control Division expects to sell 5000 process-control units this year. From the viewpoint of AIC as a whole, should 5000 Super-chips be transferred to the Process Control Division to replace circuit boards? Show your calculations. (9 marks) 3. What transfer price, or range of prices, would ensure goal congruence among the division managers? Show your calculations and provide an explanation. (5 marks) 4. If labour capacity in the Semiconductor Division were 60 000 hours instead of 45 000 hours, would you answer differently to requirement 3 above? Show your calculations and provide an explanation. (5 marks)