Question

In: Finance

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 $ 190 $ 220
Variable costs per unit 80 132
Contribution margin per unit $ 110 $ 88
Machine hours to produce 1 unit 0.4 hours 1.0 hours
Maximum unit sales per month 550 units 200 units

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 for two shifts, which will increase its productivity by another eight hours per day for 22 days per month. This change would require $11,000 additional fixed costs per month. (Round hours per unit answers to 1 decimal place. Enter operating losses, if any, as negative values.)

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?

            Product G        Product B        Total

Hours dedicated to the production of each product                          

Units produced for most profitable sales mix                        

Contribution margin per unit             

Total contribution margin - one shift                        

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?

            Product G        Product B        Total

Hours dedicated to the production of each product                          

Units produced for most profitable sales mix                        

Contribution margin per unit             

Total contribution margin - two shifts                                   

                                   

                                   

                                   

                                   

                                   

4. Suppose that the company determines that it can increase Product G’s maximum sales to 600 units per month by spending $10,000 per month in marketing efforts. Should the company pursue this strategy and the double shift?

            Product G        Product B        Total

Hours dedicated to the production of each product                          

Units produced for most profitable sales mix                        

Contribution margin per unit             

Solutions

Expert Solution

Product G Product B
Contribution Margin per Unit $ 110 $ 88
Machine Hours to produce one unit 0.40 hours 1 hour
Contribution Margin per machine hour $ 275 $ 88

2. 440 units of Product G and 0 units of Product B would be possible. The maximum contribution margin = $ 48,400.

Product G Product B Total
Hours dedicated to the production of each product 176 0 176
Units produced for most profitable sales mix 440 0
Contribution Margin per unit $ 110 $ 88
Total Contribution Margin : One Shift $ 48,400 $ 0 $ 48,400

Product G should be emphasized as it has a higher contribution margin per unit of constrained resource, i.e, machine hours.

Total machine hours available on single shift basis = 22 x 8 = 176

Product G has a maximum sales demand of 550 units. This would take up 550 x 0.40 = 220 machine hours. But 220 machine hours are not available. Only 176 machine hours are available. Therefore, maximum production of Product G = 176 / 0.4 = 440 unit. No machine hours remain for production of Product B.

Maximum contribution margin possible = 440 units x $ 110 per unit = $ 48,400.

3.

Product G Product B Total
Hours dedicated to the production of each product 220 132 352
Units produced for most profitable sales mix 550 132
Contribution margin per unit $ 110 $ 88
Total Contribution Margin : two shifts $ 60,500 $ 11,616 $ 72,116

4.

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 $ 110 $ 88
Total Contribution Margin : two shifts $ 66,000 $ 9,856 $ 75,856
Total Contribution Margin : one shift 48,400
Change in Contribution Margin 27,456
Change in Fixed Costs $ ( 11,000 + 10,000) 21,000
Change in Operating Income ( Loss) 6,456
Should the company follow new marketing strategy and double shift ? YES

Related Solutions

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 $ 240 $ 270 Variable costs per unit 105 162 Contribution margin per unit $ 135 $ 108 Machine hours to produce 1 unit 0.4 hours 1.0 hours Maximum unit sales per month 650 units 250 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...
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 $ 132 $ 160 Variable costs per unit 50 96 Contribution margin per unit $ 82 $ 64 Machine hours to produce 1 unit 0.4 hours 1.0 hours Maximum unit sales per month 600 units 150 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...
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 $ 220 $ 250 Variable costs per unit 95 150 Contribution margin per unit $ 125 $ 100 Machine hours to produce 1 unit 0.4 hours 1.0 hours Maximum unit sales per month 650 units 250 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...
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 $ 200 $ 230 Variable costs per unit 85 138 Contribution margin per unit $ 115 $ 92 Machine hours to produce 1 unit 0.4 hours 1.0 hours Maximum unit sales per month 650 units 250 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...
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 $ 132 $ 160 Variable costs per unit 50 96 Contribution margin per unit $ 82 $ 64 Machine hours to produce 1 unit 0.4 hours 1.0 hours Maximum unit sales per month 600 units 150 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...
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 $ 170 $ 200 Variable costs per unit 70 120 Contribution margin per unit $ 100 $ 80 Machine hours to produce 1 unit 0.4 hours 1.0 hours Maximum unit sales per month 550 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...
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 $ 50 $ 80 Variable costs per unit 10 48 Contribution margin per unit $ 40 $ 32 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 shift for...
Problem 10-5A Analysis of sales mix strategies LO A1 Edgerron Company is able to produce two...
Problem 10-5A Analysis of sales mix strategies LO A1 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 $ 70 $ 100 Variable costs per unit 20 60 Contribution margin per unit $ 50 $ 40 Machine hours to produce 1 unit 0.4 hours 1.0 hours Maximum unit sales per month 600 units 200 units The company presently...
Problem 23-5A Analysis of sales mix strategies LO A1 Edgerron Company is able to produce two...
Problem 23-5A Analysis of sales mix strategies LO A1 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 $ 132 $ 160 Variable costs per unit 50 96 Contribution margin per unit $ 82 $ 64 Machine hours to produce 1 unit 0.4 hours 1.0 hours Maximum unit sales per month 600 units 150 units The company presently...
There are two companies, A and B, which have facilities to produce the same products. A's...
There are two companies, A and B, which have facilities to produce the same products. A's operating income is 15% and B's operating income is 25%. In general, company B can be considered a profitable company with higher internal efficiency. But if actual B is not better at internal competencies, explain how the above operating profit could have been achieved. (Hint: B may have been using the equipment for a longer period of time.)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT