Question

In: Accounting

Xenon Corp. makes three products in a single facility. These products have the following unit product...


Xenon Corp. makes three products in a single facility. These products have the following unit product costs:

                                                                     Product I                              Product II                Product III

Direct material                                                $39.25                         $34.60                         $37.25

Direct labor                                                     20.60                         17.95                         17.30

Variable manufacturing overhead                       5.30                             6.65                           10.65

Fixed manufacturing overhead                       34.60                           35.90                         30.60    

Unit cost                                                         $99.15                         $95.10                        $95.80

Additional data concerning these products are listed below:

                                                                     Product I                             Product II              Product III

Mixing minutes per unit                                     6.6                                4                         5.2

Selling price per unit                                      $133.00                    $121.70                   127.65

Variable selling cost per unit                           $9.30                         $6.70                    $8.00

Monthly demand in units                               2,395                         4,790                     4,125

The mixing machines are potentially the constraint in the production facility. A total of 40,000 minutes are available per month on these machines.

Direct labor is a variable cost in this company.

Required:

1.    How many minutes of mixing machine time would be required to satisfy demand for all three products?

2.    Using only the available 40,000 minutes of machine time, how much of each product should be produced to maximize net operating income? (Round down to the nearest whole units.)

3.    Is there unmet demand for product(s)? If so, how much and for which product(s)?

4.    Assume there is unmet product demand. How much in total should Xenon be willing to pay for extra machine time?

5.    Did variable selling cost per unit figure into any of your calculations? Which ones, if any?

6.    Is there anything misleading about the figure given for fixed manufacturing overhead?

7.    What is the significance of contribution margins with respect to question 3?

8.    What is the significance of contribution margins with respect to question 5?

9.    Why isn’t sales price or the difference between sales prices and the unit costs stated in the problem the best predictor of the priority in producing the products?

Solutions

Expert Solution

I II III
Direct Material 39.25 34.60 37.25
Direct Labor 20.60 17.95 17.30
Variable manufacturing overhead 5.30 6.65 10.65
Fixed manufacturing overhead 34.60 35.90 30.60
Unit cost 99.75 95.10 95.80
Mixing minutes per unit 6.60 4.00 5.20
Selling price per unit 133.00 121.70 127.65
Variable selling cost per unit 9.30 6.70 8.00
Monthly demand in units 2395 4790 4125
1) Mixing machine time for each product 15807 19160 21450
2) As MH is the limiting factor, the contribution margin per MH should be found out.
Variable expenses per unit 74.45 65.90 73.20
Contribution margin per unit 58.55 55.80 54.45
CM per machine minute 8.87 13.95 10.47
As the CM per minute is highest for Product II, it should be produced to the maximum
extent possible. The allocation of Machine time would be as under:
Units to be produced Machine Minutes required Balance machine minutes available
Product II 2395 9580 30420
Product III 4790 19160 11260
Product I 1706 11260 0
3) I II III
Unmet demand 0 0 2419
4) Maximum that can be paid for extra machine time = 2419*58.55/(2419*6.6) = $          8.87
5) Yes, variable selling cost did figure into the arriving of CM per unit.
6) The fixed cost per unit should be given along with the number of units for which it is
worked out or how the total fixed cost has been assigned to individual products.
7) The CM per minute of machine utilisation is the deciding criteria, as it maximises
operating profit.
8) As above
9) Sales price or its difference does not reflect the economics of using the scarce
machine hours.

Related Solutions

Glover Company makes three products in a single facility. These products have the following unit product...
Glover Company makes three products in a single facility. These products have the following unit product costs: Product A B C Direct materials $ 35.00 $ 51.50 $ 57.90 Direct labor 22.40 25.00 15.80 Variable manufacturing overhead 2.20 1.60 1.50 Fixed manufacturing overhead 12.10 7.70 8.30 Unit product cost $ 71.70 $ 85.80 $ 83.50 Additional data concerning these products are listed below. Product A B C Mixing minutes per unit 1.40 0.90 0.50 Selling price per unit $ 80.00...
Glover Company makes three products in a single facility. These products have the following unit product...
Glover Company makes three products in a single facility. These products have the following unit product costs: Product A B C Direct materials $ 32.90 $ 49.40 $ 55.80 Direct labor 20.30 22.90 13.70 Variable manufacturing overhead 1.30 0.70 0.80 Fixed manufacturing overhead 13.40 9.00 9.60 Unit product cost $ 67.90 $ 82.00 $ 79.90 Additional data concerning these products are listed below. Product A B C Mixing minutes per unit 1.30 1.10 0.30 Selling price per unit $ 59.00...
Glocker Company makes three products in a single facility. These products have the following unit product...
Glocker Company makes three products in a single facility. These products have the following unit product costs: Product A B C   Direct materials $ 33.90 $ 50.40 $ 56.80   Direct labor $ 21.30 $ 23.90 $ 14.70   Variable manufacturing overhead $ 2.30 $ 1.70 $ 0.40   Fixed manufacturing overhead 6.40 4.00 4.60   Unit product cost $63.90 $80.00 $76.50   Additional data concerning these products are listed below.   Mixing minutes per unit 1.10 0.70 0.20   Selling price per unit $ 69.00 $...
WY Company makes three products in a single facility. These products have the following unit product...
WY Company makes three products in a single facility. These products have the following unit product costs: Product A B C   Direct materials $ 34.90 $ 51.40 $ 57.80   Direct labor $ 22.30 $ 24.90 $ 15.70   Variable manufacturing overhead $ 2.10 $ 1.50 $ 1.40   Fixed manufacturing overhead 12.00 7.60 8.20   Unit product cost $71.30 $85.40 $83.10   Additional data concerning these products are listed below.   Mixing minutes per unit 1.30 1.10 0.40   Selling price per unit $ 79.00 $...
Glocker Company makes three products in a single facility. These products have the following unit product...
Glocker Company makes three products in a single facility. These products have the following unit product costs: Product A B C   Direct materials $ 33.80 $ 50.30 $ 56.70   Direct labor $ 21.20 $ 23.80 $ 14.60   Variable manufacturing overhead $ 2.20 $ 1.60 $ 0.30   Fixed manufacturing overhead 12.50 8.10 8.70   Unit product cost $69.70 $83.80 $80.30   Additional data concerning these products are listed below.   Mixing minutes per unit 1.20 0.60 0.10   Selling price per unit $ 68.00 $...
Glocker Company makes three products in a single facility. These products have the following unit product...
Glocker Company makes three products in a single facility. These products have the following unit product costs: Product A B C   Direct materials $ 34.10 $ 50.60 $ 57.00   Direct labor $ 21.50 $ 24.10 $ 14.90   Variable manufacturing overhead $ 1.30 $ 0.70 $ 0.60   Fixed manufacturing overhead 11.20 6.80 7.40   Unit product cost $68.10 $82.20 $79.90   Additional data concerning these products are listed below.   Mixing minutes per unit 1.30 0.90 0.30   Selling price per unit $ 71.00 $...
Glocker Company makes three products in a single facility. These products have the following unit product...
Glocker Company makes three products in a single facility. These products have the following unit product costs: Product A B C   Direct materials $ 34.10 $ 50.60 $ 57.00   Direct labor $ 21.50 $ 24.10 $ 14.90   Variable manufacturing overhead $ 1.30 $ 0.70 $ 0.60   Fixed manufacturing overhead 11.20 6.80 7.40   Unit product cost $68.10 $82.20 $79.90   Additional data concerning these products are listed below.   Mixing minutes per unit 1.30 0.90 0.30   Selling price per unit $ 71.00 $...
Glunn Company makes three products in a single facility. These products have the following unit product...
Glunn Company makes three products in a single facility. These products have the following unit product costs:      Product A B C   Direct materials $ 21.80    $ 18.30    $ 13.70      Direct labor 23.10    23.90    19.00      Variable manufacturing overhead 10.20    9.90    9.50      Fixed manufacturing overhead 27.50    26.20    32.70      Unit product cost $ 82.60    $ 78.30    $ 74.90         Additional data concerning these products are listed below.          Product A B C...
Glover Company makes three products in a single facility. These products have the following unit product...
Glover Company makes three products in a single facility. These products have the following unit product costs: Product A B C Direct materials $ 15.80 $ 11.00 $ 14.10 Direct labor 19.10 17.20 20.30 Variable manufacturing overhead 2.60 3.10 3.30 Fixed manufacturing overhead 21.60 24.10 31.30 Unit product cost $ 59.10 $ 55.40 $ 69.00 Additional data concerning these products are listed below. Product A B C Mixing minutes per unit 3.30 2.60 3.10 Selling price per unit $ 74.30...
Bruce Corporation makes four products in a single facility. These products have the following unit product...
Bruce Corporation makes four products in a single facility. These products have the following unit product costs: Products A B C D Direct materials $ 16.30 $ 20.20 $ 13.20 $ 15.90 Direct labor 18.30 21.70 16.10 10.10 Variable manufacturing overhead 5.10 6.30 8.80 5.80 Fixed manufacturing overhead 28.20 15.10 15.20 17.20 Unit product cost $ 67.90 $ 63.30 $ 53.30 $ 49.00 Additional data concerning these products are listed below. Products A B C D Grinding minutes per unit...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT