Problem 7-16 (Algo) Comparing Traditional and Activity-Based Product Margins [LO7-1, LO7-3, LO7-4, LO7-5]

Hi-Tek Manufacturing, Incorporated, makes two types of industrial component partsthe B300 and the T500. An absorption costing income statement for the most recent period is shown:

Please add formulas! I want to know how to do it!

Hi-Tek produced and sold 60,300 units of B300 at a price of $21 per unit and 12,700 units of T500 at a price of $40 per unit. The company's traditional cost system allocates manufacturing overhead to products using a plantwide overhead rate and direct labor dollars as the allocation base. Additional information relating to the company's two product lines is shown below: The company has created an activity-based costing system to evaluate the profitability of its products. Hi-Tek's ABC implementation team concluded that $56,000 and $103,000 of the company's advertising expenses could be directly traced to B300 and T500, respectively. The remainder of the selling and administrative expenses was organization-sustaining in nature. The ABC team also distributed the company's manufacturing overhead to four activities as shown below: Required: 1. Compute the product margins for the B300 and T500 under the company's traditional costing system. 2. Compute the product margins for B300 and T500 under the activity-based costing system. 3. Prepare a quantitative comparison of the traditional and activity-based cost assignments