Question

In: Accounting

Constraints Exercise Product A Product B Product C Selling price $180 $270 $240 Less variable expenses:...

Constraints Exercise

Product A

Product B

Product C

Selling price

$180

$270

$240

Less variable expenses:

         Direct materials

         Other

24

102

72

90

32

148

Total variable expenses

126

162

180

Contribution margin per unit

Contribution margin per constrained resource

1.      Rank the products in order of profitability based on contribution margin per unit.

2.      Assume that the same raw materials are used in all the products and is available in limited quantities at $8 per pound. There is a limited quantity of material on hand for production for the current month, and there is a backlog on the orders for each product. If the company cannot buy additional material this month, which product should it concentrate on first? Second? Third? Why?

3. Now let’s change the facts. Assume that the company has only 3,000 lb of material on hand for this month’s production and has order backlogs as follows:

Product A          200 units

Product B.         300 units

Product C         150 units

There is not enough material on hand available to clear the entire backlog of orders; however, the company can buy the same material at a premium price from a foreign supplier. What is the maximum price per lb. that the company would be willing to pay to acquire enough material to complete all the backlog of orders this month?

Step 1.      Which product is affected by the shortfall?

Step 2.      Maximum price per lb computation.

Solutions

Expert Solution

Ranking based on contribution per unit

Product A Product B Product C
Sales 180 270 240
Variable cost 126 162 180
Contribution 54 108 60
Ranking iii i ii
Constraint
Material W/N 1 3 9 4
Contribution 18 12 15
Revised Ranking i iii ii

Answer 2 Company should constraint product B as it gives least contribution per unit of material.

If deficiency still prevail then Product C can be be constrained as after Product B it has least contribution per unit of material and divert all resources to produce product A with maximum contribution per unit.

Working note 1: statement of material used per unit

Material cost/ cost per unit= unit of material used

Product A 24 8 3
Product B 72 8 9
Product C 32 8 4

Answer 3-Statement of material used

Backlogs Required Available Used Balance
Product A 200*3 600 3000 600 2400
Product C 150*4 600 2400 600 1800
Product B 300*9 2700 1800 1800 (900)

Product B is affected by shortfall by 900lbs eg. 100 units

Maximum price company may offer= sale price- labour/ no. of units

= 270-90 = 180/9 =$20/unit


Related Solutions

    Per Unit .       % of sales Selling price . $75 . 100% Variable Expenses ....
    Per Unit .       % of sales Selling price . $75 . 100% Variable Expenses . $45 . 60% Contribution Margin . $30 40% Fixed expenses are $75,000 per month and the company is selling 3,000 units per month. 2. Refer to the original data . Management is considering using higher quality components that would increase variable cost by $3 per unit. The manager believes that the higher quality product would increase sales by 15% per month. Should the higher...
Barlow Company manufactures three products: A, B, and C. The selling price, variable costs, and contribution...
Barlow Company manufactures three products: A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow:     Product     A      B      C Selling price   $   180         $   270         $   240      Variable expenses:                                    Direct materials      24            72            32      Other variable expenses      102            90  ...
Barlow Company manufactures three products: A, B, and C. The selling price, variable costs, and contribution...
Barlow Company manufactures three products: A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow:    Product A B C   Selling price $ 240 $ 320 $ 300   Variable expenses:     Direct materials 18 72 27     Other variable expenses 174 152 228   Total variable expenses 192 224 255   Contribution margin $ 48 $ 96 $ 45   Contribution margin ratio 20 % 30 % 15 %    The same raw material is used...
Barlow Company manufactures three products: A, B, and C. The selling price, variable costs, and contribution...
Barlow Company manufactures three products: A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow: Product A B C Selling price $ 240 $ 360 $ 320 Variable expenses: Direct materials 21 63 28 Other variable expenses 147 153 212 Total variable expenses 168 216 240 Contribution margin $ 72 $ 144 $ 80 Contribution margin ratio 30 % 40 % 25 % The same raw material is used in all...
Product AG52 has revenues of $195,600, variable cost of goods sold of $114,200, variable selling expenses...
Product AG52 has revenues of $195,600, variable cost of goods sold of $114,200, variable selling expenses of $31,600, and fixed costs of $58,100, creating a loss from operations of $8,300. a. Prepare a differential analysis as of October 7 to determine if Product AG52 should be continued (Alternative 1) or discontinued (Alternative 2), assuming fixed costs are unaffected by the decision. If an amount is zero, enter "0". Use a minus sign to indicate a loss. Differential Analysis Continue Product...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow: Product A B C Selling price $ 150 $ 240 $ 200 Variable expenses: Direct materials 12 48 18 Other variable expenses 108 120 152 Total variable expenses 120 168 170 Contribution margin $ 30 $ 72 $ 30 Contribution margin ratio 20 % 30 % 15 % The same raw material is used in all three...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow: Product A B C Selling price $ 180 $ 270 $ 240 Variable expenses: Direct materials 24 80 32 Other variable expenses 102 90 148 Total variable expenses 126 170 180 Contribution margin $ 54 $ 100 $ 60 Contribution margin ratio 30 % 37 % 25 % The same raw material is used in all three...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow: Product A B C Selling price $ 180 $ 240 $ 220 Variable expenses: Direct materials 18 72 30 Other variable expenses 126 96 140 Total variable expenses 144 168 170 Contribution margin $ 36 $ 72 $ 50 Contribution margin ratio 20 % 30 % 23 % The same raw material is used in all three...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow: Product A B C Selling price $ 180 $ 300 $ 250 Variable expenses: Direct materials 20 90 30 Other variable expenses 120 120 184 Total variable expenses 140 210 214 Contribution margin $ 40 $ 90 $ 36 Contribution margin ratio 22 % 30 % 14 % The same raw material is used in all three...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin...
Barlow Company manufactures three products—A, B, and C. The selling price, variable costs, and contribution margin for one unit of each product follow: Product A B C Selling price $ 150 $ 240 $ 200 Variable expenses: Direct materials 12 48 18 Other variable expenses 108 120 152 Total variable expenses 120 168 170 Contribution margin $ 30 $ 72 $ 30 Contribution margin ratio 20 % 30 % 15 % The same raw material is used in all three...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT