Question

In: Accounting

Patterson Products Inc. is considering an upgrade to its manufacturing equipment. The two upgrade options under...

Patterson Products Inc. is considering an upgrade to its manufacturing equipment. The two upgrade options under consideration are shown below.

Option 1 Option 2
  Direct material cost per unit $ 50.4   $ 33.6  
  Direct labour cost per unit $ 42   $ 35  
  Variable overhead per unit $ 8.4   $ 26.6  
Fixed manufacturing costs $ 2,040,000   $ 3,552,000  

The selling price of the company’s product is $168 per unit with variable selling costs of 10% of sales. Fixed selling and administrative costs are $3,340,000 per year.

There would be no change to the selling price, variable selling costs, or fixed selling and administrative costs as the result of the manufacturing equipment upgrade.

Required:

1. At what annual number of unit sales would Patterson Products Inc. be indifferent between the two upgrade options?

Annual number of unit sales=

2. If demand falls short of the indifference point calculated in part (1), which option would be preferred?

  • Option 1

  • Option 2

3. Calculate the break-even point in unit sales under each upgrade option. (Round your final answers to the nearest whole number.)

Break-even unit sales for Option1=

Break-even unit sales for Option2=

Solutions

Expert Solution

1) calculation of annual number of unit sales would Patterson Products Inc. be indifferent between the two upgrade options :

indifference point = difference in fixed costs/variable cost per unit

calculation of fixed cost and variale cost per unit

paricular option 1 option 2
variale cost per unit :-
Direct material cost per unit $50.4 $33.6
Direct labour cost per unit 42 35
Variable overhead per unit 8.4 26.6
total manufacturing variale cost per unit $100.8 $95.2
fixed cost :-
Fixed manufacturing costs $2040000 $3552000

difference in fixed costs = $3552000 - $2040000 = $1512000

difference in total manufacturing variale cost per unit = $100.8 - $95.2 = $5.6

indifference point = difference in fixed costs/variable cost per unit = $1512000/$5.6 = 270000

2) If demand falls short of the indifference point calculated in part (1), option 1 would be preferred which can be understood as under :

let us assume demand falls short of the indifference point calculated in part (1) to 250000 units then net income will be as under :

particular option 1 option 2
sales in units 250000 250000
selling price per unit (a) $168 $168
variale cost per unit :-
Direct material cost per unit $50.4 $33.6
Direct labour cost per unit 42 35
Variable overhead per unit 8.4 26.6
variable selling cost (10% of sales) $16.8 $16.8
total variable cost per unit (b) $117.6 $112
contribution per unit (c = a - b) $50.4 $56
total contribution (d = 250000 units x c ) $12600000 $14000000
fixed cost :-
Fixed manufacturing costs $2040000 $3552000
Fixed selling and administrative costs are $3,340,000 $3340000 $3340000
total fixed costs (e) $5380000 $6892000
net income (f = d - e) $7220000 $7108000

from the above calculation it is clear that net income of option 1 is more than net income of option 2.

3) Calculation of the break-even point in unit sales under each upgrade option :

particular option 1 option 2
selling price per unit (a) $168 $168
variale cost per unit :-
Direct material cost per unit $50.4 $33.6
Direct labour cost per unit 42 35
Variable overhead per unit 8.4 26.6
variable selling cost (10% of sales) $16.8 $16.8
total variable cost per unit (b) $117.6 $112
contribution per unit (c = a - b) $50.4 $56
fixed cost :-
Fixed manufacturing costs $2040000 $3552000
Fixed selling and administrative costs are $3,340,000 $3340000 $3340000
total fixed costs $5380000 $6892000

break-even point in unit sales under each upgrade option = fixed costs/contribution per unit

partticular option 1 option 2
break-even point in unit sales under each upgrade option $5380000/$50.4 = 106746 units $6892000/$56 = 123071 units

please give your feed back and rating


Related Solutions

Patterson Products Inc. is considering an upgrade to its manufacturing equipment. The two upgrade options under...
Patterson Products Inc. is considering an upgrade to its manufacturing equipment. The two upgrade options under consideration are shown below. Option 1 Option 2 Direct material cost per unit $ 72.0 $ 48.0 Direct labour cost per unit $ 54 $ 47 Variable overhead per unit $ 18.0 $ 41.0 Fixed manufacturing costs $ 2,100,000 $ 4,500,000 The selling price of the company’s product is $240 per unit with variable selling costs of 10% of sales. Fixed selling and administrative...
At what annual number of unit sales would Patterson Products Inc. be indifferent between the two upgrade options?
Patterson Products Inc. is considering an upgrade to its manufacturing equipment. The two upgrade options under consideration are shown below.     Option 1 Option 2 Direct materials cost per unit $18 $15 Direct labour cost per unit $34 $27 Variable overhead per unit $26 $32 Fixed manufacturing costs $2,000,000 $3,000,000   The selling price of the company's product is $120 per unit with variable selling costs of 5% of sales. Fixed selling and administrative costs are $3,300,000 per year....
Patterson Corp. is considering the purchase of a new piece of equipment, which would have an...
Patterson Corp. is considering the purchase of a new piece of equipment, which would have an initial cost of $528,000, a 7-year life, and $150,000 salvage value. The increase in net income each year of the equipment's life would be as follows: Year 1 $ 105,000 Year 2 $ 97,000 Year 3 $ 95,000 Year 4 $ 84,000 Year 5 $ 81,000 Year 6 $ 76,000 Year 7 $ 70,000 What is the payback period? Multiple Choice 5.92 years 6.13...
A manufacturing company is evaluating two options for new equipment to introduce a new product to...
A manufacturing company is evaluating two options for new equipment to introduce a new product to its suite of goods. The details for each option are provided below: Option 1 $65,000 for equipment with useful life of 7 years and no salvage value. Maintenance costs are expected to be $2,700 per year and increase by 3% in Year 6 and remain at that rate. Materials in Year 1 are estimated to be $15,000 but remain constant at $10,000 per year...
A manufacturing company is evaluating two options for new equipment to introduce a new product to...
A manufacturing company is evaluating two options for new equipment to introduce a new product to its suite of goods. The details for each option are provided below: Option 1  $65,000 for equipment with useful life of 7 years and no salvage value.  Maintenance costs are expected to be $2,700 per year and increase by 3% in Year 6 and remain at that rate.  Materials in Year 1 are estimated to be $15,000 but remain constant at $10,000 per year...
Case Study: A manufacturing company is evaluating two options for new equipment to introduce a new...
Case Study: A manufacturing company is evaluating two options for new equipment to introduce a new product to its suite of goods. The details for each option are provided below: Option 1 $65,000 for equipment with useful life of 7 years and no salvage value. Maintenance costs are expected to be $2,700 per year and increase by 3% in Year 6 and remain at that rate. Materials in Year 1 are estimated to be $15,000 but remain constant at $10,000...
A company is considering the purchase of a major piece of equipment for its manufacturing plant....
A company is considering the purchase of a major piece of equipment for its manufacturing plant. The project would cost $22m in initial investment and would result in cost savings, before tax, of $3.25m per year for five years. The equipment could be sold for $4.5m at the end of the five years. The equipment would also result in an increase in NWC of $500,000, which will be recovered at the end of the project. The company’s CCA rate is...
A company is considering the purchase of a major piece of equipment for its manufacturing plant....
A company is considering the purchase of a major piece of equipment for its manufacturing plant. The project would cost $22m in initial investment and would result in cost savings, before tax, of $3.25m per year for five years. The equipment could be sold for $4.5m at the end of the five years. The equipment would also result in an increase in NWC of $500,000, which will be recovered at the end of the project. The company’s CCA rate is...
Patterson Company is considering two competing investments. The first is for a standard piece of production...
Patterson Company is considering two competing investments. The first is for a standard piece of production equipment. The second is for computer-aided manufacturing (CAM) equipment. The investment and after-tax operating cash flows are as follows: Year Standard equipment CAM equipment R R 0 5 000 000 20 000 000 1 3 000 000 1 000 000 2 2 000 000 2 000 000 3 1 000 000 3 000 000 4 1 000 000 4 000 000 5 1 000...
Bernie Ltd is considering the purchase of a new equipment for its manufacturing plant and has...
Bernie Ltd is considering the purchase of a new equipment for its manufacturing plant and has asked you to work out an appropriate discount rate to use when evaluating the project. information about burnie’s current capital structure is as follows: Source of capital. Book value. Market value debts. $1,500,000. $1,600,000 ordinary share capital. $1,800,000. $3,000,000 total. $3,300,000. $3,600,000 to finance the purchase, Bernie can sell 10 year-bonds paying annual coupon interest at a rate of 6%. The bond can be...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT