Get Instant Help From 5000+ Experts For
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
wave
Question:
  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.
  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.
  3. 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.
  4. 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.
  5. What transfer price, or range of prices, would ensure goal congruence among the division managers? Show your calculations and provide an explanation.
Answer:

Part 1: Customer-Cost Report

The following table shows in the various cost reports:

Particulars

 Adams

 Betz

 Chatham

 Dedham

 Elm

 General

 Total

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 Fixed costs allocated

             42,550.00

    42,550.00

    45,386.67

         45,386.67

   45,386.67

   1,19,140.00

   3,40,400.00

 

 

 

 

 

 

 

 

 

 

 Costs

             42,550.00

    42,550.00

    45,386.67

         45,386.67

   45,386.67

   1,19,140.00

   3,40,400.00

 

 

 

 

 

 

 

 

 

 

 

Particulars

 Adams

 Betz

 Chatham

 Dedham

 Elm

 General

 Total

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 Direct costs

       1,47,000.00

    1,17,200.00

      2,18,400.00

       1,15,720.00

       57,040.00

 

      6,55,360.00

 

 Discounts

          23,400.00

 

 

 

         3,660.00

 

         27,060.00

 

 Fixed costs

          42,550.00

       42,550.00

         45,386.67

          45,386.67

       45,386.67

   1,19,140.00

      3,40,400.00

 

 

 

 

 

 

 

 

 

 

 Total costs

       2,12,950.00

    1,59,750.00

      2,63,786.67

       1,61,106.67

    1,06,086.67

   1,19,140.00

    10,22,820.00

 

 

 

 

 

 

 

 

 

 

The following is the profitability analysis:

Particulars

 Adams

 Betz

 Chatham

 Dedham

 Elm

 General

 Total

 

 

 

 

 

 

 

 

 

 

 Gross revenue

       2,34,000.00

    1,88,800.00

      3,57,380.00

       1,47,840.00

       73,200.00

 

    10,01,220.00

 

 Less: direct costs

       1,47,000.00

    1,17,200.00

      2,18,400.00

       1,15,720.00

       57,040.00

 

      6,55,360.00

 

 Less: discount

          23,400.00

 

 

 

         3,660.00

 

         27,060.00

 

 Less: fixed costs

          42,550.00

       42,550.00

         45,386.67

          45,386.67

       45,386.67

   1,19,140.00

      3,40,400.00

 

 

 

 

 

 

 

 

 

 

 Profit earned

          21,050.00

       29,050.00

         93,593.33

        -13,266.67

      -32,886.67

  -1,19,140.00

        -21,600.00

 

 

 

 

 

 

 

 

 

 

Part 2:
Introduction:

The report talks about the concept of ABC costing which means the allocation of the costs on the basis of some drivers that drives those costs.  This report further throws light on the profitability analysis of these departments.

Analysis:

The total fixed costs of the company comes to be $340400 which is divided on the basis of costing drivers. These are allocated on the basis of the judgment of the management or the past experience or on the basis of some estimate.

The allocated costs comes to be the following:

Particulars

 Adams

 Betz

 Chatham

 Dedham

 Elm

 General

 Total

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 Fixed costs allocated

             42,550.00

    42,550.00

    45,386.67

         45,386.67

   45,386.67

   1,19,140.00

   3,40,400.00

 

 

 

 

 

 

 

 

 

 

 Costs

             42,550.00

    42,550.00

    45,386.67

         45,386.67

   45,386.67

   1,19,140.00

   3,40,400.00

 

 

 

 

 

 

 

 

 

 

Secondly, talking about the total costs that have been allocated to each and every department. The following are the desired costs:

Particulars

 Adams

 Betz

 Chatham

 Dedham

 Elm

 General

 Total

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 Direct costs

       1,47,000.00

    1,17,200.00

      2,18,400.00

       1,15,720.00

       57,040.00

 

      6,55,360.00

 

 Discounts

          23,400.00

 

 

 

         3,660.00

 

         27,060.00

 

 Fixed costs

          42,550.00

       42,550.00

         45,386.67

          45,386.67

       45,386.67

   1,19,140.00

      3,40,400.00

 

 

 

 

 

 

 

 

 

 

 Total costs

       2,12,950.00

    1,59,750.00

      2,63,786.67

       1,61,106.67

    1,06,086.67

   1,19,140.00

    10,22,820.00

 

 

 

 

 

 

 

 

 

 

The total amounts of the costs that are being incurred have now reached $10,22,820.

Now, if we analyse the profits that the company has earned from each of the customer and also as the whole, then we get losses which could be seen form the below table:

Particulars

 Adams

 Betz

 Chatham

 Dedham

 Elm

 General

 Total

 

 

 

 

 

 

 

 

 

 

 Gross revenue

       2,34,000.00

    1,88,800.00

      3,57,380.00

       1,47,840.00

       73,200.00

 

    10,01,220.00

 

 Less: direct costs

       1,47,000.00

    1,17,200.00

      2,18,400.00

       1,15,720.00

       57,040.00

 

      6,55,360.00

 

 Less: discount

          23,400.00

 

 

 

         3,660.00

 

         27,060.00

 

 Less: fixed costs

          42,550.00

       42,550.00

         45,386.67

          45,386.67

       45,386.67

   1,19,140.00

      3,40,400.00

 

 

 

 

 

 

 

 

 

 

 Profit earned

          21,050.00

       29,050.00

         93,593.33

        -13,266.67

      -32,886.67

  -1,19,140.00

        -21,600.00

 

 

 

 

 

 

 

 

 

 

From the above table, it could be seen that the company earns a loss of $21,600 in total. If we break this down, then we realise that Dedham and Elm is giving us losses. Though Chatham is able to earn profit for the company but these losses along with the general losses are so much that the total amount is going into losses. Hence, the company is not bale to earn profit even when it is working so hard to do so.

On top of that the company is giving cash discounts to its customers.

Conclusion and recommendation:

The company is working very hard to generate in profits. Hence, though the technique of the company of allocating these fixed costs is in line with the profit objective but its rules and policies may not be so strong that the company generates in profits.

ABC costing technique is the method through which the costs are identified these are then loaded into the secondary pools, primary cost pools are loaded, the various drivers of the activities are measured, the secondary costs are allocated into the primary pools and the costs are charged on the basis of these cost objects (Accounting tools, 2018).

In order to generate in profits, the company could do the following:

  • Increase the amounts that it charges from its customers
  • Stop giving cash discounts to them
  • Think of more activities that could be introduced so as to maximise its revenue
  • Think of ways of reducing its expenses which would help in reduction of the costs.
Scenario 2:
Part 1:

The following table shows the calculation of contribution per hour:

 

 Semiconductor Division

 

 Particulars

 Super-chip

 Okay-chip

 

 

 

 

 

 Direct materials

              5.00

              2.00

 

 Direct manufacturing labour

            60.00

            20.00

 

 

 

 

 

 Annual F overhead

     40,000.00

 

 

 

 

 

 

 Capacity

 45000 hours

 

 

 

 

 

 

 Particulars

 Super-chip

 Okay-chip

 

 

 

 

 

 Selling price

            80.00

            26.00

 

 Less: variable cost:

 

 

 

 Direct material

              5.00

              2.00

 

 Direct manufacturing labour

            60.00

            20.00

 

 

 

 

 

 Contribution

            15.00

              4.00

 

 Divided by the number of hours

              3.00

              1.00

 

 

 

 

 

 Contribution per hour

              5.00

              4.00

 

 

 

 

 

Keeping in mind the total number of direct labour hours, the following number of units should be produced:

 

 

 

 

Particulars

Number of hours per unit

Number of units to be produced

Total hours

 

 

 

 

 Super-chip

       3.00

 15,000.00

 45,000.00

 

 

 

 

 Okay chip

          -   

 15,000.00

              -   

 

 

 

 

 

 

 

 

 Total

 

 

 45,000.00

 

 

 

 

The company should manufacture 15,000 units of Super Chips and 15,000 units of Okay chips.

Part 2:

The following are the relevant calculations:

Particulars

 Costs in $

 

 

 

 

 Selling price of process control unit

             132.00

 

 

 

 

 Less: variable costs:

 

 

 Direct labour

               70.00

 

 Direct manufacturing labour

               45.00

 

 

 

 

 Contribution per unit

               17.00

 

 Number of direct labour hours

                 3.00

 

 

 

 

 Contribution per hour

5.666666667

 

 

Particulars

 Costs in $

 

 

 

 

 Selling price of process control unit

              145.00

 

 

 

 

 Less: variable costs:

 

 

 Direct labour

                65.00

 

 Direct manufacturing labour

                45.00

 

 

 

 

 Contribution per unit

                35.00

 

 Number of direct labour hours

                  3.00

 

 

 

 

 Contribution per hour

11.66666667

 

Conclusion: the company must go for the production of the transfer of the Super chips at the price at which the company sells it to the outside. This would result in an increased amount of the revenue being generated for the company.

In the given question, the fixed costs have been ignored since these have to be incurred even if the company decides to stop its production.

Part 3:

The following table shows in the relevant calculations:

Particulars

 Costs in $

 

 Super chips

 Process control unit

Improved control unit

 Selling price of process control unit

                     80.00

             132.00

145

 

 

 

 

 Less: variable costs:

 

 

 

 Direct labour

                       5.00

               70.00

                        65.00

 Direct manufacturing labour

                     60.00

               45.00

                        45.00

 

 

 

 

 Contribution per unit

                     15.00

               17.00

                        35.00

 Number of direct labour hours

                       3.00

                 3.00

                          3.00

 

 

 

 

 Contribution per hour

5

5.666666667

11.66666667

 

 

 

 

Total

10.66666667

 

Total

 

 

16.66666667

In order to achieve the goal congruence, the Semiconductor division must transfer the super chips at its variable cost since it can be seen that the total of the contribution of both the departments comes out to be $(5+5.67) =$10.67 and if the new improved control unit is sold, then the total contribution comes out to be $(5+11.67)=$16.67.

Part 4:

Yes, the answer would still be the same as above.

The following table shows in the relevant calculations:

Particulars

 Costs in $

 

 Super chips

 Process control unit

Improved control unit

 Selling price of process control unit

                     80.00

             132.00

145

 

 

 

 

 Less: variable costs:

 

 

 

 Direct labour

                       5.00

               70.00

                        65.00

 Direct manufacturing labour

                     60.00

               45.00

                        45.00

 

 

 

 

 Contribution per unit

                     15.00

               17.00

                        35.00

 Number of direct labour hours

                       3.00

                 3.00

                          3.00

 

 

 

 

 Contribution per hour

5

5.666666667

11.66666667

 

 

 

 

Total

10.66666667

 

Total

 

 

16.66666667

In order to achieve the goal congruence, the Semiconductor division must transfer the super chips at its variable cost since it can be seen that the total of the contribution of both the departments comes out to be $(5+5.67) =$10.67 and if the new improved control unit is sold, then the total contribution comes out to be $(5+11.67)=$16.67.

References:

Bragg, S. and Bragg, S. (2018). Activity based costing. [online] AccountingTools. Available at: https://www.accountingtools.com/articles/2017/5/14/activity-based-costing [Accessed 11 Sep. 2018].

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). Activity-Based Customer-Cost Report And Profitability Analysis. Retrieved from https://myassignmenthelp.com/free-samples/acc202-management-accounting/accounting-tools.html.

"Activity-Based Customer-Cost Report And Profitability Analysis." My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/acc202-management-accounting/accounting-tools.html.

My Assignment Help (2021) Activity-Based Customer-Cost Report And Profitability Analysis [Online]. Available from: https://myassignmenthelp.com/free-samples/acc202-management-accounting/accounting-tools.html
[Accessed 22 November 2024].

My Assignment Help. 'Activity-Based Customer-Cost Report And Profitability Analysis' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/acc202-management-accounting/accounting-tools.html> accessed 22 November 2024.

My Assignment Help. Activity-Based Customer-Cost Report And Profitability Analysis [Internet]. My Assignment Help. 2021 [cited 22 November 2024]. Available from: https://myassignmenthelp.com/free-samples/acc202-management-accounting/accounting-tools.html.

Get instant help from 5000+ experts for
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing: Proofread your work by experts and improve grade at Lowest cost

loader
250 words
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Plagiarism checker
Verify originality of an essay
essay
Generate unique essays in a jiffy
Plagiarism checker
Cite sources with ease
support
close