Question

In: Accounting

ABC Company produces Product X, Product Y, and Product Z. All three products require processing on...

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 2,130 hours per month. ABC Company wants 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 Product Y Product Z Selling price $ 149 $ 121 $ 35 Variable costs 104 60 27 Machine time per unit 3 hours 3 hours 1 hour Monthly demand (units) 430 280 755

Determine how the 2,130 hours of machine time should be allocated to the three products to provide the most profitable product mix. (Do not round intermediate calculations.)

Solutions

Expert Solution

Product X Product Y Product Z
Selling price (i) 149 121 35
Variable cost (ii) 104 60 27
Contribution margin per unit (iii) = (i) - (ii) 45 61 8
Machine time per unit (iv) 3 hours 3 hours 1 hour
Contribution margin per machine hour (iii)/(iv) $15 $10.3333 $8
Rank 1 2 3

Since contribution margin per machine hour is maximum in case of product X, hence product X will be produced to the maximum possible extent. From the remaining machine hours, then product Y will be produced to the maximum possible extent and finally from the remainder machine hours, product Z will be produced.

Machine hours used in production of product X = 430 x 3

= 1290

Machine hours used in production of product Y = 280 x 3

= 840

Remaining machine hours = 2130 - 1290 - 840

= 0

Since after production of product X and Y, no machine hours are left, hence there will be no production of product Z

Sales mix table

Product X Product Y Product Z
Production 430 units 280 units 0

Related Solutions

dKristen Company manufactures three products: X, Y, and Z. The demand for each product is 100...
dKristen Company manufactures three products: X, Y, and Z. The demand for each product is 100 units. The selling price, variable expenses, and contribution margin for one unit of each product follow:               Product    X    Y     Z Selling price $140 $300 $390 Less variable expenses        (Only Special steel)     50    100    150 Contribution margin    $90   $200 $240 Steel need to make 1 unit    1 kg    2 kg   3 kg The same special steel is used for...
BC Company sells three products, X, Y, and Z. During October, Product X had sales of...
BC Company sells three products, X, Y, and Z. During October, Product X had sales of $500,000; Product Y had sales totaling $300,000; and Product Z reported sales of $200,000. ABC Company as a whole reported total fixed costs of $443,000, a total segment margin of $77,000, and a net income of $53,000. The traceable fixed costs for Product X amounted to $80,000 during October and the traceable fixed costs for Product Z were $60,000 in October. Calculate the traceable...
KUMA makes three products X, Y, and Z. All three products must be offered for sale...
KUMA makes three products X, Y, and Z. All three products must be offered for sale each month in order to provide a complete market service. The products are fragile and their quality deteriorates rapidly once they are manufactured. The products are produced on two types of machine and worked on by a single grade of direct labour. Five direct employees are paid Ghc 8 per hour for a guaranteed minimum of 160 hours each per month. All of the...
Monica's Manufacturing produces three products: X, Y, and Z. It has fixed costs of $18,000. X...
Monica's Manufacturing produces three products: X, Y, and Z. It has fixed costs of $18,000. X Y Z Unit selling price $100 $130 $210 Unit variable costs $60 $30 $180 Labor-hours per unit 4 5 3 a. What is the break-even point (in units) if Monica were to sell only product X? b. What is the break-even point (in units) if Monica sells products X, Y, and Z according to the following sales-mix? X Y Z Sales Mix 55% 15%...
*please show calculations* 1. Shelby Company produces three products: X, Y, and Z. Data about the...
*please show calculations* 1. Shelby Company produces three products: X, Y, and Z. Data about the three products are as follows: ($ per unit) X Y Z Selling Price 80 56 70 Less: Variable expenses:    Direct materials 24 15 9    Labor and overhead 24 27 40 Total variable expenses 48 42 49 Unit Contribution Margin 32 14 21 Demand for the company’s products is very strong. With far more orders each month than the company can produce with...
QUESTION 1 KUMA makes three products X, Y, and Z. All three products must be offered...
QUESTION 1 KUMA makes three products X, Y, and Z. All three products must be offered for sale each month in order to provide a complete market service. The products are fragile and their quality deteriorates rapidly once they are manufactured. The products are produced on two types of machine and worked on by a single grade of direct labour. Five direct employees are paid Ghc 8 per hour for a guaranteed minimum of 160 hours each per month. All...
ABC Company operates three divisions, X, Y, and Z. The following information is available for the...
ABC Company operates three divisions, X, Y, and Z. The following information is available for the most recent month: ABC Company: Segment margin ............. $200,000 Contribution margin ........ 40% of sales Division X: Sales revenue .............. $732,000 Contribution margin ........ $260,000 Segment margin ............. $ 30,000 Division Y: Sales revenue .............. $276,000 Contribution margin ........ 25% of sales Division Z: Sales revenue .............. $200,000 Traceable fixed costs ...... $ 33,000 Calculate the segment margin reported by Division Z during the...
Benjamin Company produces two products from a joint process: X and Z. Joint processing costs for...
Benjamin Company produces two products from a joint process: X and Z. Joint processing costs for this production cycle are $8,000. Yards Sales price per yard at split-off Disposal cost per yard at split-off Further processing per yard Final sale price per yard X 1,500 $6.00 $3.50 $1.00 $7.50 Z 2,200 9.00 5.00 3.00 11.25 If X and Z are processed further, no disposal costs will be incurred or such costs will be borne by the buyer. Refer to Benjamin...
If X, Y and Z are three arbitrary vectors, prove these identities: a. (X×Y).Z = X.(Y×Z)...
If X, Y and Z are three arbitrary vectors, prove these identities: a. (X×Y).Z = X.(Y×Z) b. X×(Y×Z) = (X.Z)Y – (X.Y)Z c. X.(Y×Z) = -Y.(X×Z)
ABC Company produces three products in a joint production process. At the split-off point, all three...
ABC Company produces three products in a joint production process. At the split-off point, all three products are produced further and then sold. Information about these products for 2019, the most recent year, appears below: Product A Product B Product C Units produced ............... 15,000 25,000 10,000 Selling price ................ $50 per unit $40 per unit $75 per unit Additional processing costs .. $15 per unit $16 per unit $37.50 per unit Joint costs for 2019 totaled $150,000. During 2019,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT