ABC Company produces Product X, Product Y and Product Z. All three products requ
ID: 2363894 • Letter: A
Question
ABC Company produces Product X, Product Y and Product Z. All three products require processing on specialized finishing machines. The capacity of these machines is 3,600 hours per month. ABC Company wishes to determine the product mix that should be achieved to meet the high demand for each product and provide the maximum profit. Following is information about each product:Product X
Selling price.................$300
Variable costs................$210
Machine time per unit......6 hours
Monthly demand (units)....360
Product Y
Selling Price.................$240
Variable Costs...............$120
Machine time per unit.....4 hours
Monthly demand (units)...240
Product Z
Selling Price.................$76
Variable Costs...............$60
Machine time per unit.....2 hours
Monthly demand (units)...600
A.) Determine how the 3,600 hours of machine time should be allocated to the three products to provide the most profitable mix.
Explanation / Answer
X Y Z
Unit Contribution Margin $90 $120 $16
Time per unit 6 hours 4 hours 2 hours
Margin per hour $15 per hour $30 per hour $8 per hour
360 units @ 2160 hrs 240 units @960 hrs 240 units @ 480hrs
You have a constraint of 3600 hours (2160+960+480=3600) You must maximize machine time in terms of contribution margin per hour. Maximize monthly demand for each product and multiply by the number of hours it takes to produce. Add these together until you reach your 3600 hour constraint. Hope this helps! 360 units of x, 240 units of y, and 240 units of z will maximize profit