Traditional VS. Activity-Based Costing Methods ABC Corporation manufactures electric pumps and their three product models are regular, advanced, and deluxe. The company has been using a job-order cost method to apply manufacturing overhead costs to each model. The allocation is on the basis of direct-labor hours. The following is the information about the company's product costs and annual sales. Regular Model Advanced Model Deluxe Model Annual Sales (units) 20,000 1,000 10,000 Product Costs: Direct $20 $50 $84 Material Product Costs: Direct 20 (1 hr at $20) 40 (2 hr at $20) 40 (2 hr at $20) Labor Product Costs: 170 (1 hr at $170) 340 (2 hr at $170) 340 (2 hr at $170) Manufacturing Overhead* Total Product Cost $210 $430 $464 "The calculation of the predetermined overhead rate is as follows: Manufacturing-Overhead Budget Manufacturing Overhead Amount Depreciation, machinery $2,960,000 Maintenance, machinery 240,000 Depreciation, taxes, and insurance for factory 600,000 Engineering 700,000 Purchasing, receiving, and shipping 500,000 Inspection and repair of defects 750,000 Manufacturing-Overhead Budget Manufacturing Overhead Amount Depreciation, machinery $2,960,000 Maintenance, machinery 240,000 Depreciation, taxes, and insurance for factory 600,000 Engineering 700,000 Purchasing, receiving, and shipping 500,000 Inspection and repair of defects 750,000 Material handling 800,000 Miscellaneous manufacturing overhead costs 590,000Total $7,140,000 Direct-Labor Budget Direct-Labor Budget Model Time Regular Model 20,000 hours Advanced Model 2,000 hours Deluxe Model 20,000 hours Total 42,000 hours Predetermined overhead rate: budgeted overhead divided by budgeted direct-labor hours $7,140,000 divided by 42,000 hours = $170 per hour Hilton, R. W. (2013). Managerial accounting: creating value in a dynamic business environment. Retrieved from http://connect.mheducation.com/connect/hmInstructorSectionHomePortal.do?sectionld= 38690402 For the last 10 years, the company set each model's target price at 110 percent of its full product cost. However, ABC Corporation realized that the regular-model pump has come under increasing price pressure from offshore competitors. The result was that the price on the regular model has been lowered to $220. When the company president had a meeting with a controller, the president expressed his concerns; "Why can't we compete with these other companies? They're selling pumps just like our regular model for $212. That's only two bucks more than our production cost. Are we really that inefficient? What gives?" The controller responded by saying, "I think this is due to an outmoded product-costing system. As you may remember, I raised a red flag about our system when I came on board last year. But the decision was to keep our current system in place. In my judgment, our product-costing system is distorting our product costs. Let me run a few numbers to demonstrate what I mean." Getting the president's go-ahead, the controller compiled the basic data needed to implement an activity-based costing system. These data are displayed in the following table. The percentages are the proportion of each cost driver consumed by each product line. Activity Cost Pool Cost Driver Product Product Product Lines Lines: Getting the president's go-ahead, the controller compiled the basic data needed to implement an activity-based costing system. These data are displayed in the following table. The percentages are the proportion of each cost driver consumed by each product line.Activity Cost Pool Cost Driver Product Product Product Lines: Lines: Lines: Regular Advanced Deluxe Model Model Model I: Depreciation, machinery Machine time 39% 13% 48% Maintenance, machinery Il: Engineering Inspection and Engineering hours 47% 6% 47% repair of defects Page 2 of 3 Ill: Purchasing, receiving, and Number of material 47% 8% 45% shipping orders Material handling IV: Depreciation, taxes, and Factory space 42% 15% 43% insurance for factory usage Miscellaneous manufacturing overhead Hilton, R. W. (2013). Managerial accounting: creating value in a dynamic business environment. Retrieved from http://connect.mheducation.com/connect/hmInstructorSectionHomePortal.do?sectionld=Required: 1. Compute the target prices for the three pump models, based on the traditional, volume-based product-costing system. 2. Compute new product costs for the three products, based on the new data collected by the controller. Round to the nearest cent. 3. Calculate a new target price for the three products, based on the activity-based costing system. Compare the new target price with the current actual selling price for the regular model pump. 4. Write a memo to the company president explaining what has been happening as a result of the firm's traditional volume-based product-costing system. 5. What strategic options does management have? What do you recommend, and why