Question

In: Accounting

XYZ Company produces three products, A, B, and C. XYZ's plant capacity is limited to 48,000...

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.

Solutions

Expert Solution

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

Related Solutions

XYZ Company produces three products, A, B, and C. XYZ's plant capacity is limited to 48,000...
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...
XYZ Company produces three products, A, B, and C. XYZ's plant capacity is limited to 200,000...
XYZ Company produces three products, A, B, and C. XYZ's plant capacity is limited to 200,000 machine hours per year. The following information is available for planning purposes: Product A Product B Product C demand for next year in units .... 100,000 200,000 150,000 selling price per unit ........... $18 $28 $24 variable costs per unit .......... $15 $20 $22 It is known that it takes 0.40 machine hours to produce one unit of Product A; 0.70 machine hours to...
Amazon ltd produces three products; A, B, C and D using the same processing plant. The...
Amazon ltd produces three products; A, B, C and D using the same processing plant. The following information relates to the company: Product                                  A                     B                     C                     D Units produced                      2,000               20,000             2,400               28,000 Material cost per unit (sh)    20                    20                    64                    68 Labour hours per unit                      2                      2                      8                      6 Machine hours per unit        1                      1                      4                      6 Labour cost per unit (sh)      12                    12                    48                    36 The cost accountant analysed the production overheads recorded under the...
THE Company produces three products, A, B, and C. The following information relates to THE Company...
THE Company produces three products, A, B, and C. The following information relates to THE Company and its three products for June: THE Company: Sales revenue .............. $700,000 Segment margin ............. $204,000 Net income ................. $169,000 Product A: Sales revenue .............. $200,000 Contribution margin ........ $104,000 Segment margin ............. $ 19,000 Product B: Variable costs ............. 30% of sales of Product B Product C: Variable costs ............. $181,000 Traceable fixed costs ...... $ 36,000 Contribution margin ........ 20% of sales...
A company produces and sells three types of products A, B, and C. The table below...
A company produces and sells three types of products A, B, and C. The table below shows the selling price per unit and the total demand for each product type. $/unit Demand A 5 300 B 6 250 C 7 200 For this purpose, the company can commission any of 7 plants with varying costs. Furthermore, each plant has a fixed capacity (in units) regardless of the type of product made. Production costs and capacities for each of the six...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit):...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit): Product A B C Selling price $ 84.00 $ 70.00 $ 74.00 Variable expenses: Direct materials 25.20 21.00 9.00 Other variable expenses 25.20 31.50 42.80 Total variable expenses 50.40 52.50 51.80 Contribution margin $ 33.60 $ 17.50 $ 22.20 Contribution margin ratio 40 % 25 % 30 % The company estimates that it can sell 750 units of each product per month. The same...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit):...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit): Product A B C Selling price $ 88.00 $ 72.00 $ 78.00 Variable expenses: Direct materials 26.40 18.00 9.00 Other variable expenses 26.40 36.00 45.60 Total variable expenses 52.80 54.00 54.60 Contribution margin $ 35.20 $ 18.00 $ 23.40 Contribution margin ratio 40 % 25 % 30 % The company estimates that it can sell 900 units of each product per month. The same...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit):...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit): Product A B C Selling price $ 88.00 $ 72.00 $ 78.00 Variable expenses: Direct materials 26.40 18.00 9.00 Other variable expenses 26.40 36.00 45.60 Total variable expenses 52.80 54.00 54.60 Contribution margin $ 35.20 $ 18.00 $ 23.40 Contribution margin ratio 40 % 25 % 30 % The company estimates that it can sell 900 units of each product per month. The same...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit):...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit): Product A B C Selling price $ 72.00 $ 60.00 $ 62.00 Variable expenses: Direct materials 21.60 18.00 9.00 Other variable expenses 21.60 27.00 34.40 Total variable expenses 43.20 45.00 43.40 Contribution margin $ 28.80 $ 15.00 $ 18.60 Contribution margin ratio 40 % 25 % 30 % The company estimates that it can sell 1,000 units of each product per month. The same...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit):...
Benoit Company produces three products—A, B, and C. Data concerning the three products follow (per unit): Product A B C Selling price $ 80.00 $ 66.00 $ 72.00 Variable expenses: Direct materials 24.00 16.50 12.00 Other variable expenses 24.00 33.00 38.40 Total variable expenses 48.00 49.50 50.40 Contribution margin $ 32.00 $ 16.50 $ 21.60 Contribution margin ratio 40 % 25 % 30 % The company estimates that it can sell 700 units of each product per month. The same...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT