\f8.45 Traditional versus simple activity-based costing, strategic cost analysis: manufacturer L0 8.1 , 8.2 , 8.5 , 8.6 Morelli Electric Motor Corporation manufactures electric motors for commercial use. The company produces three models called standard, deluxe and heavy-duty. The company uses ajob costing system with manufacturing overhead applied on the basis of direct labour hours. The system has been in place with little change for 25 years. Product costs and annual sales data are as follows: Standard model Deluxe model Heavy-duty model Annual sales (units) 20 000 1 000 10 000 Product costs: Raw material $ 10 $ 25 $ 42 Direct labour 10 (0.5 hr @ $20) 20 (1 hr @ $20) 20 (1 hr @ $20) Manufacturing warhead" _85 E J Total product cost $105 $215 $232 Forthe past 10 years, the company's pricing formula has been to set each product's budgeted price at 110 per cent of its full product cost. Recently, however, Page 405 the standard model motor has come under increasing price pressure from offshore competitors. As a result the price on the standard model has been lowered to $110. The company CEO recently asked the nancial controller, 'Why can't we compete with these other companies? They're selling motors just like our standard model for $106. That's only a dollar more than our production cost. Are we really that inefficient?' The nancial controller responded by saying, 'I think this is due to an outmoded product costing system. As you may remember, I raised a red ag about our system when I came on board last year. But the decision was to keep our current system in place. In my opinion, our product costing system is distorting our product costs. Let me run a few numbers to demonstrate whatl mean'. Getting the CEO's goahead, the nancial controller compiled the basic data needed to implement an activitybased costing system. These data are displayed in the following table. The percentages are the proportion of each activity driver consumed by each product line. Product lines Activity Activity driver Standard model Deluxe model Heavy-duty model Depreciation, machinery Maintenance, machinery Machine time 40% 13% 47% Engineering Inspection and repair of defects Engineering hours 47% 6% 47% Purchasing, receiving and shipping Number of Material handling material orders 47% 8% 45% Depreciation, taxes and insurance for factory Factory space Miscellaneous manufacturing overhead usage 42% 15% 43% Required: Iv UI Ur . Calculate the budgeted prices forthe three models, based on the traditional product costing system. . Calculate new product costs for the three products, based on the new data collected by the nancial controller. Round to the nearest cent. . Calculate a new budgeted price for the three products, based on the activity-based costing system. Compare the new budgeted target price with the current actual selling price for the standard model electric motor. Write a memo to the CEO explaining what has been happening as a result of using the rm's traditional product costing system. What strategic options does Morelli Electric Motor Corporation have? What do you recommend and why? Refer to the product costs developed in requirement 2 above. Prepare a table showing how Morelli's traditional product costing system distorts the product costs of the standard, deluxe and heavyduty models