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...
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 $ 57.6   $ 38.4     Direct labour cost per unit $ 46   $ 39     Variable overhead per unit $ 11.6   $ 31.4   Fixed manufacturing costs $ 2,060,000   $ 3,852,000   The selling price of the company’s product is $192 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...
JB Hi-Fi management is considering the two following options of buying a new equipment for a...
JB Hi-Fi management is considering the two following options of buying a new equipment for a new investment project with the same initial cost. Year:- 0 , 1, 2, 3, 4 Project A :-, -$78500, $43000, $29000, $23000, $21000, Project B:-, -$78500, $21000, $28000 , $34000, $41000 A) which project the company should choose based on NPV Criterion if the required rate of return is 11%. B) Which project the company should choose based on P1 criterion if the required...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT