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,250 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 | $ | 151 | $ | 120 | $ | 38 | |||
Variable costs | 105 | 58 | 30 | ||||||
Machine time per unit | 3 | hours | 3 | hours | 1 | hour | |||
Monthly demand (units) | 440 | 310 | 755 | ||||||
Required:
Determine how the 2,250 hours of machine time should be allocated to the three products to provide the most profitable product mix. (Do not round intermediate calculations.)
CALCULATION OF CONTRIBUTION MARGIN PER MACHINE HOURS AND RANKING OF THEM | |||||||
Product X | Product Y | Product Z | |||||
Selling Price | 151 | 120 | 38 | ||||
Less: Variable Cost | $ 105 | $ 58 | $ 30 | ||||
Contribution Per Unit | 46 | 62 | 8 | ||||
Divide by Machine Hours required per unit | 3 Hours | 3 Hours | 1 Hours | ||||
Contribution per machine hours = | $ 15.33 | $ 20.67 | $ 2.67 | ||||
Ranking | 2 nd Rank | Ist Rank | 3 rd Rank | ||||
SCHEDULE OF PRODUCTION FOR MAXIMUM PROFIT | |||||||
PARTICULARS | Product | Maximum No. of Units | Unit Per Hours | Total Hrs. Required | Balance Hours | ||
Total Hours Available | 2,250 | ||||||
Production of Product Y First | Y | 310 | 3 | 930 | 1,320 | ||
Production of Product X Second | X | 440 | 3 | 1320 | - | ||
Production of Product Z In last | Z | 0 | 0 | - | |||
Note : There is no balance hours available for Product Z so no production is made for this product | |||||||
Answer = | |||||||
Most Profitable product Mix | |||||||
Product Y = | 310 Units | ||||||
Product X = | 440 Units | ||||||
ABC Company produces Product X, Product Y, and Product Z. All three products require processing on...
ABC Co p any pr tu es Product X Product Y and Product Ζ. All three products requre processing on specia ized finishing machines. The capatty of these mach es s 210 hours er m m Company wants to determine the product mix that should be achieved to meet the high demand for each product and provide the maximum proft. Folowing ls information atout each product ABC Product XProduct Y Selling price $149 105 $118 50 s 35 Variable costs...
Cari Company produces three products; X, Y and Z. Additionally, they only have 1,000 direct labor hours available to produce their products. Time requirements and contribution margins per unit for each product are as follows: Product X Product Y Product Z Labor hours Contribution margin per unit $10 $24 $12 Required: a. Which of the three product lines makes the most profitable use of the constrained resource, direct labor hours? What would be the contribution margin if you used all...
Please provide explanation. Thank you Selection of Most Profitable Product TEB produces two products with the per unit information given in the table below. Due to shortage of finishing time, TEB cannot produce the market demand of either product (i.e., TEB can sell as much ABC or XYZ as it can produce with the available finishing time). Indicate which product that will produce the most profit. Product per Unit Amounts Product per Unit Amounts ABC Product XYZ Sales price Variable...
Suzy Co. produces and sells three products (X, Y. and Z). The following data relate to the three products, Demand in units Selling price per unit Raw materials costs per unit Labor time in minutes per unit 160 150 149 $130 $ 160 $ 150 $ 65 $ 80 10 2010 $ 90 Which is the most profitable product if there is no constraint on labor time? Product X 0 Product Y Product Z
Manico Co produces three products, X,Y, and Z, with the following characteristics: Selling price/unit: X $20, Y $16, Z $15; Variable cost/ unut: X$12, Y, $12, Z $6; Contribution margin/unit: X $8, Y$4, Z $9; Machine hours/unit: X 5, Y 3, Z 6. The company has only 2,000 machine hours available each month If demand exceeds the company’s capacity, in what sequence should orders for the three products be filled to maximize total contribution margin?
Hickory Company manufactures two products—13,000 units of Product Y and 5,000 units of Product Z. The company uses a plantwide overhead rate based on direct labor-hours. It is considering implementing an activity-based costing (ABC) system that allocates all $745,200 of its manufacturing overhead to four cost pools. The following additional information is available for the company as a whole and for Products Y and Z: Activity Cost Pool Activity Measure Estimated Overhead Cost Expected Activity Machining Machine-hours $ 242,400 12,000...
Suzy Co. produces and sells three products (X, Y. and Z). The following data relate to the three products: Demand in units Selling price per unit Raw materials costs per unit Labor time in minutes per unit 160 150 140 $ 139 $ 160 $ 150 $ 65 $ 80 $ 90 10 20 10 Which is the most profitable product if there is no constraint on labor time? Multiple Choice Product X Product Y. Product Z More than one...
Greenwood Company manufactures two products—14,000 units of Product Y and 6,000 units of Product Z. The company uses a plantwide overhead rate based on direct labor-hours. It is considering implementing an activity-based costing (ABC) system that allocates all of its manufacturing overhead to four cost pools. The following additional information is available for the company as a whole and for Products Y and Z: Activity Cost Pool Activity Measure Estimated Overhead Cost Expected Activity Machining Machine-hours $ 209,000 10,000 MHs...
Dunford Company produces three products with the following costs and selling prices: Product X Y Z Selling price per unit.............................................. $40 $30 $35 Variable costs per unit........................................... 24 16 20 Contribution margin per unit................................. $16 $14 $15 Direct labor hours per unit..................................... 4 2 3 Machine hours per unit.......................................... 5 7 4 If Dunford has a limit of 30,000 machine hours but no limit on units sold or direct labor hours, then the three products should...
Hickory Company manufactures two products—15,000 units of Product Y and 7,000 units of Product Z. The company uses a plantwide overhead rate based on direct labor-hours. It is considering implementing an activity-based costing (ABC) system that allocates all $674,000 of its manufacturing overhead to four cost pools. The following additional information is available for the company as a whole and for Products Y and Z: Activity Cost Pool Activity Measure Estimated Overhead Cost Expected Activity Machining Machine-hours $ 216,700 11,000...