Prepare a chart comparing the costs assigned

Assignment Help Managerial Accounting
Reference no: EM13501492

The management of Albatross Packaging Corporation is concerned about overhead cost allocations.  The corporation has been using the plant-wide rate based on direct labor costs since it began operations.   The CEO, J.J. Smith, has been hearing a lot about Activity Based Costing and is beginning to think the Corporation needs to adopt such a system.   He has decided to hire you as a consultant to evaluate overall overhead allocation system and prepare recommendations. 

He tells you that a number of problems have arisen in the past few months.  Several large, potentially profitable jobs have been lost due to underbidding by the competition.   There also seems to erosion in the market share of the generic cardboard boxes as competitors are beginning to undercut the company's current selling price.

In addition, some of the specialty jobs that have been won do not seem to improving the bottom line as much as anticipated. In total, profits in the past three years have been gradually eroding.  Since prime costs are fairly standard and stable for the industry, he is beginning to suspect that the overhead costs are not being allocated in the proper manner and/or may be out of line with the competition. 

The next part of your analysis concerns the use of activity based costing to assign the overhead to the jobs.  Assume the following five cost pools exist in the Albatross Packaging Corp. 

Overhead costs assigned to activity pools

 

Cost drivers

Activity

Pool rate

Maintenance

        975,000.00

        100,000.00

Machine hours

 

Material handling

        650,000.00

           2,600.00

material moves

 

Setups

     3,250,000.00

              236.00

number of setups

 

Inspections

        750,000.00

         10,000.00

Inspection hours

 

Other

        600,000.00

   15,000,000.00

Units produced

 

Total overhead costs

     6,225,000.00

 

 

 

Each of the jobs completed use the number or amount of resources identified in the schedule below.

 

 Activities used by each job

Generic

18

19

Generic 2

20

21

22

23

Maintenance

1800

230

375

1800

365

220

280

425

Material handling

10

4

6

10

4

6

4

4

Setups

1

1

1

1

1

1

1

1

Inspections

345

25

35

340

28

20

27

125

Other

500000

12500

25000

500000

20000

10000

15000

35000

Required

1.      Prepare a schedule showing total cost per pool and the pool rates.

2.      Prepare another schedule showing the total costs attached to each of the jobs above using the pool rates above to apply the overhead and the prime costs found in part 1.  It is suggested that you first prepare a schedule to show the overhead costs assigned.

3.      Prepare a final schedule comparing the total cost, unit costs broken down by material, labor and overhead for both ABC and for the traditional costing methods.  (Pull the information from the costs computed in the first part and compare to the information calculated for the ABC costing method.)

4.      Compare the income statements broken down by job using the plant wide rate and ABC.  Compute the gross profit margin for each job as well as gross profit in total. 

5.      Prepare a chart comparing the costs assigned for overhead for the two methods evaluated in part 1 and part 2.

6.      Discuss, in memo format, the impact on the costs and bids using the plant-wide rate and activity based costing.  Include the recommendation for one of these two methods.  Be sure to include proper rationale and at least one schedule or graph that you've prepared.

Reference no: EM13501492

Questions Cloud

Explain the concentration of the solution in units : Lactose, C12H22O11, is a naturally occurring sugar found in mammalian milk. A 0.335 M solution of lactose in water has a density of 1.0432 g/mL at 20 degrees Celsius. What is the concentration of this solution in the following units
What was the speed of the clay immediately before impact : A 13.0-g wad of sticky clay is hurled horizontally at a 90-g wooden block initially at rest on a horizontal surface. The clay sticks to the block. what was the speed of the clay immediately before impact
Prepare absorption costing income statements : If the company wishes to earn an after-tax income of $3,000,000, what is the break even in units?  Assume that the corporate income tax rate is 40%.
What fraction of the neutrons kinetic energy : A neutron in a nuclear reactor makes an elastic, head-on collision with the nucleus of a carbon atom initially at rest. What fraction of the neutron's kinetic energy is transferred to the carbon nucleus
Prepare a chart comparing the costs assigned : Compare the income statements broken down by job using the plant wide rate and ABC.  Compute the gross profit margin for each job as well as gross profit in total.
Evaluate the mass of unknown solid required to prepare : Calculate the mass of unknown solid required to prepare 100 mL of a solution that is 100 ppm in Ca by assuming that the sample contains 50 wt% CaCO3.
What is the proper shutter speed at this setting : A camera lens is initially set at f/16 for a shutter speed of 1/160s. what is the proper shutter speed at this setting
Indicate whether this overhead is under or over applied : Calculate the predetermined overhead rate for the current year and use this rate to apply overhead to the jobs that are worked during February.
Explain the procedure use to determine anion pairs : Describe the procedure you will use to determine those cation/anion pairs that produce precipitates. Make sure you include all equipment and amounts of materials you expect to use

Reviews

Write a Review

 

Managerial Accounting Questions & Answers

  Draw a time line for the plating department

Journalize all transactions affecting the Plating department during March, including the entries that have already been posted.

  Evaluate the contribution margin per unit

The journal entry to record the allocation of any underapplied or overapplied overhead for August would include -Evaluate the contribution margin per unit

  Compute the marginal cost of capital

Compute the weighted average cost of capital on the first $250 million of funds and saven Travel will need to raise $150 of additional capital for expansion. How much of this will be debt and equity?

  Questioncolin currant started surecut mowing services a

questioncolin currant started surecut mowing services a number of years ago to provide mowing services to both local

  Isaiah''s return on total assets

Isaiah's return on total assets and beginning merchandise inventory and the average net receivables during the period are $400,000. What is the amount of net credit sales for the period?

  Nbspmaxwell company manufactures and sells a single

nbspmaxwell company manufactures and sells a single product.the following costs were incurred during the companys first

  Classification of cost what are the ways in which cost be

what are the ways in which cost be be classified to suit management needs.give examples of the

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Total cost-solution set

A review of Parrish Corporation's accounting records found that at a volume of 144,000 units, the variable and fixed cost per unit amounted to $6 and $2, respectively.

  Prepare a short report for mr banner

Prepare a short report for Mr. Banner to explain the reasons for the negative cash balance at the end of the previous year and other operating problems. To support your points, you may use a statement of cash flows and relevant financial ratios.

  Reduce the effectiveness of the system

Identify the problems that appear to exist in Ferguson and Son Manufacturing Company's budgetary control system and explain how the problems are likely to reduce the effectiveness of the system.

  As an eec corporate business financial analyst you must

as an eec corporate business financial analyst you must have an expert understanding of the various costing methods.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd