Question

In: Accounting

Alliance Enterprises is considering extensively modifying their manufacturing equipment. The modifications will result in less wastage...

Alliance Enterprises is considering extensively modifying their manufacturing equipment. The modifications will result in less wastage of materials, which will reduce variable manufacturing costs and introduce changes to the production process that will improve product quality. This will allow Alliance to increase the selling price of the product. Annual fixed costs are expected to increase to $660,000 if the modifications are made. Expected fixed and variable costs as well as the selling prices are shown below:

  Cost Item Existing Equipment Modified Equipment
  Selling price per unit $ 18             $ 20            
  Variable cost per unit 14             14            
  Fixed costs 320,000             660,000            
Required:
1. Determine the break-even point in units for the two machines.

    

2.

Determine the sales level in units at which the modified equipment will achieve a 10% target profit-to-sales ratio (ignore taxes).

       

3.

Determine the sales level in units at which the modified equipment will achieve $151,200 in after-tax operating income. Assume a tax rate of 30%.

      

4. Determine the sales level at which profits will be the same for either the existing or modified equipment.

      

Solutions

Expert Solution

1) Calculation of break even units for two machines is shown as follows:-

Break even point in units = Total Fixed cost/Contribution per unit

Contribution per unit for existing equipment = Selling price per unit - variable cost per unit

= $18 - $14 = $4 per unit

Total Fixed cost for existing equipment = $320,000

Break even point in units for existing equipment = $320,000/$4 per unit = 80,000 units

Contribution per unit for modified equipment = Selling price per unit - variable cost per unit

= $20 - $14 = $6 per unit

Total Fixed cost for modified equipment = $660,000

Break even point in units for modified equipment = $660,000/$6 per unit = 110,000 units

2) Let the required sales level in units equal to X. (for modified equipment)

Required profit per unit = Selling price per unit*10% = $20*10% = $2 per unit

Total Contribution - Fixed cost = Total Profit

(Contribution per unit*units sold) - Fixed cost = (Profit per unit*units sold)

($6 per unit*X) - $660,000 = ($2*X)

6X - 2X = $660,000

4X = $660,000

X = $660,000/4 = 165,000 units

Therefore the required sales level in units at which the modified equipment will achieve a 10% target profit-to-sales ratio is 165,000 units.

3) Required after tax operating income = $151,200

Tax rate = 30%

Operating income before tax = $151,200/(1-0.30) = $151,200/0.70 = $216,000

Sales level (in units) = (Fixed cost+Operating Income before tax)/contribution per unit

= ($660,000+$216,000)/$6 per unit

= $876,000/$6 per unit = 146,000 units

Therefore at the level of 146,000 units, the modified equipment will achieve $151,200 in after-tax operating income.

4) Sales level at which profits will be same for either the existing or modified equipment is calculated as follows:-

Let the required sales level equal to Y.

Profit is equal to contribution minu fixed cost

Profit in existing equipment = Profit in modified equipment

(Total Contribution - Fixed cost) = (Total Contribution - Fixed cost)

($4 per unit*Y) - $320,000 = ($6 per unit*Y) - $660,000

$660,000 - $320,000 = 6Y - 4Y

2Y = $340,000

Y = $340,000/2 = 170,000 units

Therefore at the sales level of 170,000 units, profits will be the same for either the existing or modified equipment.


Related Solutions

Alliance Enterprises is considering extensively modifying their manufacturing equipment. The modifications will result in less wastage...
Alliance Enterprises is considering extensively modifying their manufacturing equipment. The modifications will result in less wastage of materials, which will reduce variable manufacturing costs and introduce changes to the production process that will improve product quality. This will allow Alliance to increase the selling price of the product. Annual fixed costs are expected to increase to $300,000 if the modifications are made. Expected fixed and variable costs as well as the selling prices are shown below:   Cost Item Existing Equipment...
Exercise 17.4 Alliance Manufacturing Company is considering the purchase of a new automated drill press to...
Exercise 17.4 Alliance Manufacturing Company is considering the purchase of a new automated drill press to replace an older one. The machine now in operation has a book value of zero and a salvage value of zero. However, it is in good working condition with an expected life of 10 additional years. The new drill press is more efficient than the existing one and, if installed, will provide an estimated cost savings (in labor, materials, and maintenance) of $6,000 per...
A company is considering replacement of manufacturing equipment with computer controlled equipment, at a cost of...
A company is considering replacement of manufacturing equipment with computer controlled equipment, at a cost of $500,000, replacing equipment with a scrap value of $50,000. This will reduce defect costs by $150,000 a year. At the end of 7 years, the equipment will be replaced and will have a scrap value of $100,000. The interest charges for financing the purchase will be $25,000 a year. The new system will be housed in a building that is currently unused, with an...
Burke Enterprises is considering a machine costing $30 billion that will result in initial after-tax cash...
Burke Enterprises is considering a machine costing $30 billion that will result in initial after-tax cash savings of $3.7 billion at the end of the first year, and these savings will grow at a rate of 2 percent per year for 11 years. After 11 years, the company can sell the parts for $5 billion. Burke has a target debt/equity ratio of 1.2, a beta of 1.79. You estimate that the return on the market is 7.5% and T-bills are...
Clarissa Hardware is currently considering the purchase equipment that costs $55 000. As a result of...
Clarissa Hardware is currently considering the purchase equipment that costs $55 000. As a result of the purchase, it will generate some additional cash flows for the company. The cash inflows for the years are given as follows: The first three years - $8 000 per year, the fourth year - $10 000 and the fifth year to the seventh year - $15 000 per year. Assuming the required rate of return = 3% Assessment Task Calculate: Discounted payback period...
Perez Electronics is considering investing in manufacturing equipment expected to cost $310,000. The equipment has an...
Perez Electronics is considering investing in manufacturing equipment expected to cost $310,000. The equipment has an estimated useful life of four years and a salvage value of $ 18,000. It is expected to produce incremental cash revenues of $155,000 per year. Perez has an effective income tax rate of 40 percent and a desired rate of return of 10 percent. (PV of $1 and PVA of $1) (Use appropriate factor(s) from the tables provided.)     Required Determine the net present...
Harper Electronics is considering investing in manufacturing equipment expected to cost $250,000. The equipment has an...
Harper Electronics is considering investing in manufacturing equipment expected to cost $250,000. The equipment has an estimated useful life of four years and a salvage value of $25,000. It is expected to produce incremental cash revenues of $125,000 per year. Harper has an effective income tax rate of 30 percent and a desired rate of return of 10 percent. (PV of $1 and PVA of $1) (Use appropriate factor(s) from the tables provided.) Required Determine the net present value and...
Franklin Electronics is considering investing in manufacturing equipment expected to cost $270,000. The equipment has an...
Franklin Electronics is considering investing in manufacturing equipment expected to cost $270,000. The equipment has an estimated useful life of four years and a salvage value of $ 16,000. It is expected to produce incremental cash revenues of $135,000 per year. Franklin has an effective income tax rate of 30 percent and a desired rate of return of 12 percent. (PV of $1 and PVA of $1) (Use appropriate factor(s) from the tables provided.)     Required Determine the net present...
Campbell Electronics is considering investing in manufacturing equipment expected to cost $240,000. The equipment has an...
Campbell Electronics is considering investing in manufacturing equipment expected to cost $240,000. The equipment has an estimated useful life of four years and a salvage value of $ 18,000. It is expected to produce incremental cash revenues of $120,000 per year. Campbell has an effective income tax rate of 35 percent and a desired rate of return of 14 percent. (PV of $1 and PVA of $1) (Use appropriate factor(s) from the tables provided.)     Required Determine the net present...
Vernon Electronics is considering investing in manufacturing equipment expected to cost $370,000. The equipment has an...
Vernon Electronics is considering investing in manufacturing equipment expected to cost $370,000. The equipment has an estimated useful life of four years and a salvage value of $ 21,000. It is expected to produce incremental cash revenues of $185,000 per year. Vernon has an effective income tax rate of 40 percent and a desired rate of return of 14 percent. (PV of $1 and PVA of $1) (Use appropriate factor(s) from the tables provided.)     Required Determine the net present...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT