Eastern Chemical Company produces three products. The operating results of the current year are: Product Sales Quantity 1,200.00 6,000.00 600.00 Target Price $288.00 300.60 205.50 Actual Price $289.00 258.60 313.00 Difference $ 1.00 (42.00) $107.50 The firm sets the target price of each product at 150% of the product's total manufacturing cost. It appears that the firm was able to sell Product Cat a much higher price than the target price of the product and lost money on Product B. Tom Watson, CEO, wants to promote Product C much more aggressively and phase out Product B. He believes that the information suggests that Product C has the greatest potential among the firm's three products because the actual selling price of Product C was almost 50% higher than the target price, while the firm was forced to sell Product B at a price below the target price. Both the budgeted and actual factory overhead for the current year are $588,300. The actual units sold for each product also are the same as the budgeted units. The firm uses direct labor dollars to assign manufacturing overhead costs. The direct materials and direct labor costs per unit for each product are: Direct materials Direct labor Total prime cost Product A $ 53.00 23.00 $ 76.00 Product B $117.40 15.00 $132.40 Product C $ 68.00 12.00 $ 80.00 The controller noticed that not all products consumed factory overhead similarly. Upon further investigation, she identified the following usage of factory overhead during the year: 5 Number of setups Weight of direct materials (pounds) Waste and hazardous disposals Quality inspections Utilities (machine hours) Total Total Product A Product B Product C Overhead 6 $ 9,300 403 253 353 132,000 28 48 33 300,000 33 78,000 2,400 7,300 1,200 69,000 $588,300 38 38 Required: 1. Determine the manufacturing cost per unit for each of the products using the volume-based method. 2. What is the least profitable and the most profitable product under both the current and the ABC systems? 3. What is the new target price for each product based on 150% of the new costs under the ABC system? Compare this price with the actual selling price. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Determine the manufacturing cost per unit for each of the products using the volume-based method. (Round your intermediate calculations and final answers to 2 decimal places.) Product A Product B Product C Materials Labor Overhead Total cost Required: 1. Determine the manufacturing cost per unit for each of the products using the volume-based method. 2. What is the least profitable and the most profitable product under both the current and the ABC systems? 3. What is the new target price for each product based on 150% of the new costs under the ABC system? Compare this price with the actual selling price. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 2 What is the least profitable fitable product under both the current and the ABC systems? Current Cost Data ABC Costing System Most profitable product Least profitable product Required 1 Required 3 > Required: 1. Determine the manufacturing cost per unit for each of the products using the volume-based method. 2. What is the least profitable and the most profitable product under both the current and the ABC systems? 3. What is the new target price for each product based on 150% of the new costs under the ABC system? Compare this price with the actual selling price. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 What is the new target price for each product based on 150% of the new costs under the ABC system? Compare this price with the actual selling price. (Round your intermediate calculations and final answers to 2 decimal places.) Product Product B Product C Product costs: Activity system ABC-based product pricing: Target price Actual selling price Difference in price
