1. Determine the contribution margin per machine hour that each product generates.
.
. |
|
|
|
Contribution margin per unit |
$45.00 |
$36.00 |
|
Machine hours per unit |
0.4 |
1.0 |
|
Contribution margin per machine hour |
$112.5 |
$36.00 |
|
Product G |
Product B |
Total |
|
Maximum number of units to be sold |
600 |
200 |
.. |
Hours required to produce maximum units |
(600*0.4) 240 |
200 (200*1) |
440 |
.
2. How many units of Product G and Product B should the company produce if it continues to operate with only one shift? How much total contribution margin does this mix produce each month?
.
**Here the one month the available hours are 22 * 8 = 176 hours, the maximum contribution margin per machine hour will get from from Product G, so produce maximum units that can sell, Maximum number of units to be sold 600 units, need 240 hours to produce this units. However the machine hour is constrained, so only available in a month was 176 hour, there for utilize this full hours to produce the product G to get maximum profit. So we can produce 440 units ( 176 / 0.4 = 440) from 176 hours and 0 units product b
.
|
Product B |
Total |
|
Hours dedicated to the production of each product |
176 |
176 |
|
Units produced for most profitable sales mix |
440 |
. |
|
Contribution margin per unit |
$45.00 |
. |
|
Total contribution margin - one shift |
$19800 |
176 |
.
3. If the company adds another shift, how many units of Product G and Product B should it produce? How much total contribution margin would this mix produce each month?
.
**then total hour available = 176 * 2 shift = 352 hours
First priority to give product G, because we get maximum contribution per machine hour, here the machine hour is constrained factor
*We can sell maximum product of G 600 units, need machine hour = 600 * 0.4 = 240 hours
*Any hours remain produce the Product B,
So remaining hours = 352 - 240 = 112 hours, using this hours we can produce maximum units of Product B = 112 hours multiply with hour required to per units of 1 hour
112 * 1 = 112
.
Product G |
Product B |
Total |
|
Hours dedicated to the production of each product |
240 |
112 |
352 |
Units produced for most profitable sales mix |
600 |
112 |
. |
Contribution margin per unit |
$45.00 |
$36.00 |
|
Total contribution margin - two shifts |
$27000 |
$4032 |
$31032 |
Total contribution margin - one shift |
. |
19800 |
|
Change in contribution margin |
11232 |
||
Change in fixed costs |
. |
. |
4500 |
Change in operating income(loss) |
. |
$6732 |
|
Should the company add another shift? |
Yes |
. |
.
4. Suppose that the company determines that it can increase Product G’s maximum sales to 700 units per month by spending $3500 per month in marketing efforts. Should the company pursue this strategy and the double shift?
.
Now the company can sell the product G 700 units, so needed hours = 700 * 0.4 = 280 hours
Remaining hour of 352 - 280 = 72 can be used for producing product b of 72 units (72 * 1 )
So the maximum profit mix = 700 units of Product G and 72 units of Product B
.
. |
Product G |
Product B |
Total |
Hours dedicated to the production of each product |
280 |
72 |
352 |
Units produced for most profitable sales mix |
700 |
72 |
. |
Contribution margin per unit |
$45.00 |
$36.00 |
|
Total contribution margin - two shifts and marketing campaign |
$31500 |
$2592 |
$34092 |
Contribution margin - two shifts without marketing campaign |
. |
. |
$31032 |
Change in contribution margin |
. |
. |
3060 |
Additional marketing costs |
. |
. |
3500 |
Change in fixed costs |
. |
. |
4500 |
Change in operating income(loss) |
. |
. |
$(4940) |
Should the company pursue the marketing campaign? |
No |
Edgerron Company is able to produce two products, G and B, with the same machine in...
Edgerron Company is able to produce two products, G and B, with
the same machine in its factory. The following information is
available.
Product G
Product B
Selling price per unit
$
90
$
120
Variable costs per unit
30
72
Contribution margin per unit
$
60
$
48
Machine hours to produce 1 unit
0.4
hours
1.0
hours
Maximum unit sales per month
600
units
200
units
The company presently operates the machine for a single
eight-hour...
Edgerron Company is able to produce two products, G and B, with the same machine in its factory. The following information is available. Product G $ 180 75 Selling price per unit Variable costs per unit Contribution margin per unit Machine hours to produce 1 unit Maximum unit sales per month Product B $ 210 126 $ 84 $ 105 0.4 hours 1.0 hours 600 units 200 units The company presently operates the machine for a single eight-hour shift for...
Edgerron Company is able to produce two products, G and B, with the same machine in its factory. The following information is available Selling price per unit Variable costs per unit Contribution margin per unit Machine hours to produce 1 unit Maximum unit sales per month Product G $150 60 $ 90 0.4 hours 550 units Product B $ 180 108 $ 72 1.0 hours 200 units The company presently operates the machine for a single eight-hour shift for 22...
Edgerron Company is able to produce two products, G and B, with the same machine in its factory. The following information is available. Selling price per unit Variable costs per unit Contribution margin per unit Machine hours to produce 1 unit Maximum unit sales per month Product G $ 50 10 $ 40 Product B $ 80 48 $ 32 1.0 hours 200 units 0.4 hours 600 units The company presently operates the machine for a single eight-hour shift for...
Edgerron Company is able to produce two products, G and B, with the same machine in its factory. The following information is available. Product G $ 150 Product B $ 180 - 60 108 Selling price per unit Variable costs per unit Contribution margin per unit Machine hours to produce 1 unit Maximum unit sales per month $ 90 0.4 hours 550 units $ 72 1.0 hours 200 units The company presently operates the machine for a single eight-hour shift...
Edgerron Company is able to produce two products, G and B, with the same machine in its factory. The following information is available. Selling price per unit Variable costs per unit Product G $ 190 80 Product B $ 220 132 Contribution margin per unit $ 110 $ 88 0 unit Machine hours to produce 1 unit Maximum unit sales per month 0.4 hours 550 units 1.0 hours 200 units The company presently operates the machine for a single eight-hour...
Edgerron Company is able to produce two products, G and B, with the same machine in its factory. The following information is available Product G $ 180 Product B $ 210 Selling price per unit Variable costs per unit Contribution margin per unit Machine hours to produce 1 unit Maximum unit sales per month $ 105 S 84 0.4 hours 550 units 1.9 hours 200 units The company presently operates the machine for a single eight-hour shift for 22 working...
Edgerron Company is able to produce two products, G and B, with the same machine in its factory. The following information is available. Selling price per unit Variable costs per unit Contribution margin per unit Machine hours to produce 1 unit Maximum unit sales per month Product G $ 140 55 $ 85 Product B $ 170 102 $ 68 0.4 hours 500 units 1.0 hours 200 units The company presently operates the machine for a single eight-hour shift for...
Edgerron Company is able to produce two products, G and B, with the same machine in its factory. The following information is available. Selling price per unit Variable costs per unit Contribution margin per unit Machine hours to produce 1 unit Maximum unit sales per month Product G $ 80 25 $ 55 0.4 hours 600 units Product B $ 110 66 $ 44 1.0 hours 200 units The company presently operates the machine for a single eight-hour shift for...
Edgerron Company is able to produce two products, G and B, with the same machine in its factory. The following information is available. Product GProduct BSelling price per unit $90 $120 Variable costs per unit 30 72 Contribution margin per unit $60 $48 Machine hours to produce 1 unit0.4hours 1.0hours Maximum unit sales per month600units 200units The company presently operates the machine for a single eight-hour shift for 22 working days each month. Management is thinking about operating the machine...