Fill in the parts that have red X
Unter Components manufactures low-cost navigation systems for installation in ride-sharing cars. It sells these systems to various car services that can customize them for their locale and business model. It manufactures two systems, the Star 100 and the Star150, which differ in terms of capabilities. The following information is available: Star 100 $ 130 Star 150 $ 150 60 80 Costs per Unit Direct materials Direct labor Variable overhead Fixed overhead Total cost per unit Price Units sold 30 180 $ 400 $ 580 4,000 40 240 $ 510 $ 780 2,000 The average wage rate is $40 per hour. Variable overhead varies with the quantity of direct labor-hours. The plant has a capacity of 20,000 direct labor-hours, but current production uses only 10,000 direct labor-hours. Required: a. A nationwide car-sharing service has offered to buy 2,500 Star 100 systems and 2,500 Star 150 systems if the price is lowered to $400 and $500, respectively, per unit. a-1. If Unter accepts the offer, how many direct labor-hours will be required to produce the additional systems? Direct labor-hours 8,750 a-2. Complete the following table to determine the differential profit increase (or decrease) if Unter accepts this proposal. Prices on regular sales will remain the same. Differential revenues: Star 100 $ 1,000,000 1,250,000 Star 150 2 250.000 Differential costs: Star 100 Star 150 Differential profit (loss) 550,000 675,000 1,225,000 1,025,000 b-1. Supposed that the car-sharing service has offered instead to buy 3,500 each of the two models at $400 and $500, respectively. This customer will purchase the 3,500 units of each model only in an all-or-nothing deal. That is, Unter must provide all 3,500 units of each model or none. Unter's management has decided to fill the entire special order for both models. In view of its capacity constraints, Unter will reduce sales to regular customers as needed to fill the special order. Complete the table below to determine the total contribution margin with the special order added. Star100 Star150 Total Special Order Contribution margin per unit Number of units 3,500 3,500 Total contribution margin $ 0 $ 0 $ 0 Regular production: Contribution margin per unit $ 360 $ 510 Number of units 2,500 2,000 Total contribution margin $ 900,000 $1,020,000 1,920,000 Total contribution margin for both: $ 1,920,000 "Red text indicates no response was expected in a cell or a formula-based calculation is incorrect; no points deducted. b-2. How much will the profits change if the order is accepted? Assume that the company cannot increase its production capacity to meet the extra demand. Increase in profit C-1. Assume that in the situation presented in requirement b-1, the plant can work overtime. Direct labor costs for the overtime production inrease to $60 per hour. Variable overhead costs for overtime production are $10 per hour more than for normal production. Complete the table below to determine the total contribution margin Star100 Star150 T otal Special Order: Contribution margin per unit Number of units X X Total contribution margin $ 0 $ 0 $ 0 Regular production: Contribution margin per unit Number of units Total contribution margin $ 0 % 0 % 0 Total contribution margin for both: Additional direct-labor costs L L L * Additional variable overhead Total contribution margin for both (with additional $ 0 costs): *Red text indicates no response was expected in a cell or a formula-based calculation is incorrect; no points deducted. C-2. How much will the profits change in this situation? Increase in profit Unter Components manufactures low-cost navigation systems for installation in ride-sharing cars. It sells these systems to various car services that can customize them for their locale and business model. It manufactures two systems, the Star 100 and the Star150, which differ in terms of capabilities. The following information is available: Star 100 $ 130 Star 150 $ 150 60 80 Costs per Unit Direct materials Direct labor Variable overhead Fixed overhead Total cost per unit Price Units sold 30 180 $ 400 $ 580 4,000 40 240 $ 510 $ 780 2,000 The average wage rate is $40 per hour. Variable overhead varies with the quantity of direct labor-hours. The plant has a capacity of 20,000 direct labor-hours, but current production uses only 10,000 direct labor-hours. Required: a. A nationwide car-sharing service has offered to buy 2,500 Star 100 systems and 2,500 Star 150 systems if the price is lowered to $400 and $500, respectively, per unit. a-1. If Unter accepts the offer, how many direct labor-hours will be required to produce the additional systems? Direct labor-hours 8,750 a-2. Complete the following table to determine the differential profit increase (or decrease) if Unter accepts this proposal. Prices on regular sales will remain the same. Differential revenues: Star 100 $ 1,000,000 1,250,000 Star 150 2 250.000 Differential costs: Star 100 Star 150 Differential profit (loss) 550,000 675,000 1,225,000 1,025,000 b-1. Supposed that the car-sharing service has offered instead to buy 3,500 each of the two models at $400 and $500, respectively. This customer will purchase the 3,500 units of each model only in an all-or-nothing deal. That is, Unter must provide all 3,500 units of each model or none. Unter's management has decided to fill the entire special order for both models. In view of its capacity constraints, Unter will reduce sales to regular customers as needed to fill the special order. Complete the table below to determine the total contribution margin with the special order added. Star100 Star150 Total Special Order Contribution margin per unit Number of units 3,500 3,500 Total contribution margin $ 0 $ 0 $ 0 Regular production: Contribution margin per unit $ 360 $ 510 Number of units 2,500 2,000 Total contribution margin $ 900,000 $1,020,000 1,920,000 Total contribution margin for both: $ 1,920,000 "Red text indicates no response was expected in a cell or a formula-based calculation is incorrect; no points deducted. b-2. How much will the profits change if the order is accepted? Assume that the company cannot increase its production capacity to meet the extra demand. Increase in profit C-1. Assume that in the situation presented in requirement b-1, the plant can work overtime. Direct labor costs for the overtime production inrease to $60 per hour. Variable overhead costs for overtime production are $10 per hour more than for normal production. Complete the table below to determine the total contribution margin Star100 Star150 T otal Special Order: Contribution margin per unit Number of units X X Total contribution margin $ 0 $ 0 $ 0 Regular production: Contribution margin per unit Number of units Total contribution margin $ 0 % 0 % 0 Total contribution margin for both: Additional direct-labor costs L L L * Additional variable overhead Total contribution margin for both (with additional $ 0 costs): *Red text indicates no response was expected in a cell or a formula-based calculation is incorrect; no points deducted. C-2. How much will the profits change in this situation? Increase in profit
