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.
| A | B | C | |
| Selling price | 80 | 120 | 160 |
| less:variable cost | |||
| Direct material | 24 | 21 | 38 |
| Direct labor | 18 | 50 | 38 |
| variable overhead | 22 | 25 | 54 |
| Total variable overhead | (64) | (96) | (130) |
| contribution per unit | 16 | 24 | 30 |
| Hours required per unit | .80 | 1.25 | 1.60 |
| contribution per hour | 16/.80=$20 | 24/1.25=$19.2 | 30/1.6=18.75 |
| Ranking | 1 | 2 | 3 |
Availability and use of hours
| Product | Hours used | Hours left for use | Units produced |
| A | 24000*.80= 19200 | 48000-19200=28800 | 24000 |
| B | 25000*1.25=31250 | since available for use is only 28800 ,production of B will be restricted to 28800/1.25 = 23040 units | 23040 |
If Additional overtime is done to manufacture the remaining units of B and c,contribution will be"
| B | C | |
| Selling price | 120 | 160 |
| variable cost | (96) | (130) |
| Overtime premium | (25) [50*50%] | (19) [38*50%] |
| contribution per unit | (1) | 11 |
since if overtime is done contribution of B will be negative so all of the overtime hours should be used for manufacturing C
Number of units of C that can be manufactured :8000 /1.60 = 5000 units
total number of units of Product C that XYZ Company should produce in order to maximize its net income : 5000 units