Cost for each product using this allocation process

Assignment Help Corporate Finance
Reference no: EM13203926

Premier Products, Inc. manufactures tennis rackets. Premier Products has grown extensively over the past two years. While the company has been very profitable, President Mark Harrison is concerned with its ability to cost products accurately. Some products appear to be very profitable while others, which should be showing a profit, seem to be losing money. The production manager is convinced that his production processes are as efficient as any in the industry, and he is unable to explain the apparent high cost of producing some of the products.

Harrison agreed with his production manager and is convinced that the cost accounting system is at fault. He has hired Tom Arnold, a management consultant, to analyze the firm's costing system. Arnold has documented the existing costing system. It is a very simple system that uses a single allocation rate for all overhead costs. The overhead rate for the year is determined by adding together the budgeted variable and fixed overhead costs and dividing this sum by the number of budgeted labor hours. The standard cost of a product is found by multiplying the number of direct labor hours required to manufacture that product by the overhead rate and adding this quantity to the direct labor and material costs.

Arnold is convinced that the company's costing system is partially to blame for some of the firm's problems. He has assembled data for four of Premier's products. He has put together the actual costs required for each of these products in Table A. These costs will serve as the benchmark against which the results of different allocation schemes can be evaluated. 

Of course, in real life we could never start out with accurate actual costs - accurate actual costs would be the end result that we would attempt to determine.  But we provide this information as a learning aid to help you to clearly understand the key issues. Table A is as follows:

PRODUCT

A

B

C

D

Material

$15.00

$ 5.00

$10.00

$ 5.00

+ Labor

30.00

5.00

15.00

10.00

+Variable OH

15.00

7.50

5.00

7.50

= Unit var. cost

$60.00

$17.50

$30.00

$22.50

Fixed overhead

$10,000

$10,000

$12,500

$12,500

Units produced

1,000

1,000

1,000

1,000

Unit fixed cost

$10.00

$10.00

$12.50

$12.50

Total unit cost

$70.00

$27.50

$42.50

$35.00

The manufacturing processes for these products are structured such that the same labor and equipment can be used to produce products A and B but cannot be used to manufacture products C and D. Similarly, the labor and equipment used to manufacture products C and D cannot be used for A and B.

The company has the capacity to produce:

(1) 1,000 units of product A and 1,000 units of product B, or

(2) 2,000 units of product A, or

(3) 2,000 units of product B; or

(4) Any linear combination of products A and B.

The same is true for products C and D. The company has the capacity to produce:

(1) 1,000 units of product C and 1,000 units of product D, or

(2) 2,000 units of product C, or

(3) 2,000 units of product D; or

(4) Any linear combination of products C and D.

  Product

 Labor hrs per unit

 Variable Ohd/unit

 Number of units

Total labor hrs

 Total varohd

A

6

$15.00

1,000

6,000

$15,000

B

1

7.50

1,000

1,000

7,500

C

3

5.00

1,000

3,000

5,000

D

2

7.50

1,000

2,000

 7,500

 Total

 

 

 4,000

12,000

 $35,000

The allocation rate is:

 Variable overhead

 $35,000

 Fixed overhead

 45,000

 Total overhead costs

 $80,000

 Labor hours

 12,000

 Allocation rate per hour

 $6.67

Using this allocation rate, Arnold calculated the standard cost for the four products.

 PRODUCT

A

B

C

D

Material

$15.00

$ 5.00

$10.00

$ 5.00

+ Labor

30.00

5.00

15.00

10.00

+Allocated cost

40.00

6.67

20.00

13.33

Total unit cost

$85.00

$16.67

$45.00

$28.33

The selling prices for the four products are:

A

B

C

D

$98.00

$38.50

$59.50

$49.00

Premier is considering a policy that would discontinue a product if its mark-on is under 25%. The mark-on is calculated by taking the selling price, subtracting the product's standard cost, and dividing by the standard cost. Harrison is concerned that if the firm's costing system does not provide accurate cost estimates, products will be dropped that should be retained. Arnold calculated that the mark-on for each product using the correct product costs in Table A is 40%.

 TABLE B

  PRODUCT

A

B

C

D

Selling price

$98.00

$38.50

$59.50

$49.00

Unit cost

$70.00

$27.50

$42.50

$35.00

 Profit

$28.00

$11.00

$17.00

$14.00

Mark-on percentage

40% (28/70)

40% (11/27.50)

40% (17/42.50)

40% (14/35)

Arnold then calculated the mark-on for the four products using the standard cost for each product based on allocating the overhead costs using direct labor hours.

 PRODUCT

A

B

C

D

Selling price

$98.00

$38.50

$59.50

$49.00

Unit cost

$85.00

$16.67

$45.00

$28.33

 Profit

$13.00

$21.83

$14.50

$20.67

Mark-on percentage

15%

131% 

32%

73%

Under the policy of dropping products with mark-ons under 25%, product A would be dropped. Arnold recalculates the allocation rate assuming product A is dropped and the manufacturing capacity is shifted to produce an additional 1,000 units of product B.

  Product

 Labor hrs per unit

 Variable Ohd/unit

 Number of units

Total labor hrs

 Total varohd

B

1

7.50

2,000

2,000

$15,000

C

3

5.00

1,000

3,000

5,000

D

2

7.50

1,000

2,000

 7,500

 Total

 

 

 4,000

7,000

 $27,500

The new allocation rate is:

 Variable overhead

 $27,500

 Fixed overhead

 45,000

 Total overhead costs

 $72,500

 Labor hours

 7,000

 Allocation rate per hour

 $10.36

Questions

4. What would happen if the firm modified its costing system so that all variable costs were traced to the product accurately, but fixed costs were allocated using the existing system? Compute the cost for each product using this allocation process. What would be the impact on profits? How accurate is this method of allocating costs?

5. What would happen if the firm modified its costing system so that it contained two cost pools, one containing the overhead costs associated with Products A and B and the other overhead costs associated with Products C and D, and then allocated these overhead pools on the basis of direct labor hours? Compute the cost for each product using this allocation process. What would be the impact on profits? How accurate is this method of allocating costs?

Reference no: EM13203926

Questions Cloud

Estimate the gdp impact of a positive change of govt : Any change in the economy's total expenditures would be expected to translate into a change in GDP that was larger than the initial change in spending. This phenomenon is known as the multiplier effect. Explain how the multiplier effect works.
What is the lenght and width of a rectangle : what is the lenght and width of a rectangle if the length is 100 feet more than the width and the perimiter is 1320 feet?
Logical-creative thinker’s approach to problem solving : Is there a difference between a logical thinker and a creative thinker’s approach to problem solving? Why or why not?
Write a recurring formula that provides the number : A flower nursery manages 50,000 flowers and each year sells 10% of the flowers and plants 4,000 new ones. Write a recurring formula that provides the number of flowers each year.
Cost for each product using this allocation process : Compute the cost for each product using this allocation process. What would be the impact on profits? How accurate is this method of allocating costs?
State the pair of linear equations in two variables : Given the pair of linear equations in two variables: find the x and y -intercepts for each line . plot those intercepts, and graph the two on the same chart.
Find the value of x that maximizes the volume of the box : A box with no top is to be built by taking a 6'' - by - 10'' sheet of cardboard and cutting x - in. squares out of each corner and folding up the sides. Find the value of x that maximizes the volume of the box.
Is demand elastic or inelastic in the price range : (a.) Is demand elastic or inelastic in the $6-$8 price range How do you know (b.) If the table represents the demand faced by a monopoly firm, then what is that firm's marginal revenue as it increases output from 1700 units to 2300 units
Write the volume v of the package as a function of x : A rectangular package to be sent by the U.S. Postal Service can have a maximum combined length and girth (perimeter of a cross section) of 180 inches.

Reviews

Write a Review

Corporate Finance Questions & Answers

  Find the after-tax cash flow from the sale

Consider an asset that costs $237,600 & depreciated straight-line to zero over its six year tax life. The asset is to be used in a two year project; at the end of the project, the asset will be sold for 29,700.

  Analyze the firms past and possibly future profitability

The statement of cash flows allows the financial manager and other interested parties to analyze the firm's past and possibly future profitability

  Capital budgeting decisions in npv and irr

There are other measures used in capital budgeting decisions other than NPV and IRR. What are those measures? What are their weaknesses as compared to NPV/IRR

  Discuss about the investors relations

Please visit the Yahoo Stock Screener and use the page to find a publicly traded corporation that you find interesting and would like to study for this class.

  Challenge problem template

Why are cash flows that are connected to common stock difficult to estimate? How does this compare to those related to bonds.

  How much money will he need to transfer

TDA each year to the legal maximum of $12,000 and move funds from the money market to cover the resulting shortfall in studebaker spendable income. how much money will he need to transfer each year from the money market?

  Preparing an analysis of the market

Create your portfolio. First, set out your investment objectives and decide how much risk you are willing to take. You may invest for yourself or for an imaginary client.

  Why are the percentage changes different

What is the operating income (EBIT) for both firms and what are the earnings after interest - Why are the percentage changes different?

  Calculate fair present value

A stock you are estimating just paid an yearly dividend of $2.50. Dividends have increase at a constant rate of 1.5% over the last 15 years and you expect this to continue.

  Income statement from incomplete info from balance sheet

Income Statement from incomplete info from balance sheet and Using the balance sheet equation, compute net income for the past year

  Describe key risk indicators

Key risk indicators act as signals for sound risk management, potentially helping to prevent or prepare for risk exposure.

  What type of reorganization is contemplated transaction

Assume that Shepard uses a 10% discount rate and is in the 34% tax bracket for all years. What type of reorganization is this contemplated transaction?

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