In: Accounting
XYZ Company produces three products, A, B, and C. XYZ's plant capacity is limited to 48,000 machine hours per year. The following information is available for planning purposes: Product A Product B Product C demand for next year ............. 24,000 units 25,000 units 12,000 units selling price per unit ........... $80 $120 $160 direct material cost per unit .... $24 $ 21 $ 38 direct labor cost per unit ....... $18 $ 50 $ 38 variable overhead cost per unit .. $22 $ 25 $ 54 It takes 0.80 machine hours to produce one unit of Product A; 1.25 machine hours to produce one unit of Product B; and 1.60 machine hours to produce one unit of Product C. Assume that XYZ Company can work its plant overtime for 8,000 additional machine hours. Overtime premiums will add 50% to direct labor costs. Calculate the total number of units of Product C that XYZ Company should produce in order to maximize its net income.
CALCULATION OF CONTRIBUTION PER MACHIENE HOURS PER UNIT | |||||||
Product A | Product B | Product C | |||||
Selling Price Per unit (A) | 80 | 120 | 160 | ||||
Less: Variable Costs | |||||||
Direct Material Cost Per unit | 24 | 21 | 38 | ||||
Direct Labour Cost per unit | 18 | 50 | 38 | ||||
Variable Overhead Cost per unit | 22 | 25 | 54 | ||||
Total Variable Cost (B) | 64 | 96 | 130 | ||||
contribution (A-B = C) | 16 | 24 | 30 | ||||
Machiene Hours required per units (D) | 0.8 | 1.25 | 1.6 | ||||
Contribution per unit per hours =(C/D) | 20 | 19.2 | 18.75 | ||||
Ranking on the basis on machine hours contribution | 1st | 2nd | 3rd | ||||
Production shedule be on the basis of Merit of contribution of machiene hours | |||||||
Units | Hours RequiredPEr units | Total Hours Required for production | total Hours Available For Production | Balance Hours | |||
Product A = | 24000 | 0.8 | 19200 | 56000 | 36800 | ||
Product B = | 25000 | 1.25 | 31250 | 36800 | 5550 | ||
Product C = | 3469 | 1.6 | 5550 | 5550 | 0 | ||
Answer = total number of units for product C = 3469 Units | |||||||
Note: Avalable hours = 48,000 Machiene Hours + 8000 addittional machiene hours | |||||||
Avalable hours = 56,000 Machiene Hours | |||||||