Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

ACC202 - Management Accounting Trimester XXXXXXXXXXGROUP 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...

1 answer below »
ACC202 - Management Accounting
Trimester XXXXXXXXXXGROUP 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 co
espondence with the Tutor as well as the assignment final submission.
    
Scenario 1 (25 marks):

Customer Profitability

Louise Fai
ern operates Interiors by Louise, an interior design consulting and window treatment fa
ication 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 $ XXXXXXXXXXLouise 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 Fai
ern 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 XXXXXXXXXXwords and should include a
ief 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 XXXXXXXXXXhours per year.
One customer orders a maximum of XXXXXXXXXXSuper-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 cu
ent 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 cu
ently 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 transfe
ed 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 XXXXXXXXXXhours instead of XXXXXXXXXXhours, would you answer differently to requirement 3 above? Show your calculations and provide an explanation. (5 marks)
Answered Same Day Sep 17, 2020 ACC202 Alphacrucis College

Solution

Soumi answered on Sep 19 2020
141 Votes
Running Head: MANAGEMENT AND ACCOUNTING    1
MANAGEMENT AND ACCOUNTING        3
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
Table of Contents
Scenario 1    3
Part 1    3
Activity Based Costing Report    3
Part 2    3
Introduction    3
Analysis    3
Customer Costs    3
Customer profitability    4
Distribution channel profitability    4
Total profitability    5
Recommendations    5
Conclusion    5
Scenario 2    5
Part 1    5
Part 2    6
Part 3    8
Part 4    8
References    10
Scenario 1
Part 1
Activity Based Costing Report
Overheads can be allocated on various basis. Revenue and labour hours are the most widely used basis for allocation of overheads. In this assignment, the overheads have been allocated based on net revenue. The net revenue of five units has been taken as the base for the purpose of overhead allocation. Overheads is a major cost for the company. Therefore, allocation of overhead will have a major impact on the bottom line of the company.
    Â 
    Architecture
    Window Treatment
    Particulars
    Adams
    Betz
    Chatham
    Dedham
    Elm
    Gross revenue
    234000
    188800
    357380
    147840
    73200
    Discounts
    23400
    0
    0
    0
    0
    Net Revenue
    210600
    188800
    357380
    147840
    73200
    Direct costs
    147 000
    117 200
    218 400
    115 720
    57 040
    Overheads
    71796
    64364
    126191
    52202
    25847
    Less: Cash Discount
    0
    0
    0
    0
    3660
    Total cost
    242196
    181564
    344591
    167922
    86547
    Net Operating Profit
    -8196
    7236
    12789
    -20082
    -13347
Total revenue for the business is $1001220 and total loss is $21600. Therefore, the overall loss for the business is 2.157%. In case of architecture business, the loss is 0.22%. The window treatment business has loss of 3.568%.
Part 2
Introduction
The customer cost has been very high that has led to loss for the company. Customers, who are profitable, are Betz and Chatham and the remaining are loss-making customers. This report contains a detailed explanation of the costs, individual profitability and total profitability of the five customers of the company.
Analysis
Customer Costs
The total cost of maintaining the customers is 102.16% of the total sales. This indicates that the cost of maintaining customers is higher than the revenue generated from each customers. The total direct cost for the business has been 65.45%. The total overhead cost is 34% of the gross revenue. In addition to that, the company has provided discounts to the customers to few customers that have led to increase in loss for the company. According...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here