The company estimated it would incur $96,000 in manufacturing overhead costs during current period. Overhead currently is app to the products on the basis of direct labor hours. Last year, Come-On-In Manufacturing purchased an expensive robotics syst to allow for more decorative door products in the deluxe product line. The CFO suggested that an ABC analysis could be valua to help evaluate a product mix and promotion strategy for the next sales campaign. She obtained the following ABC informati for 2010: Total Overhead Costs $96,000 Required: (To solve this problem you must use Excel and upload in the course Blackboard) a. Using the current system, compute predetermined overhead rate and unit product cost of each type of door. b. Using ABC, compute ABC rate and unit product cost of each type of door c. Explain why there are difference in unit product costs under current system and under activity based costing The company estimated it would incur $96,000 in manufacturing overhead costs during current period. Overhead currently is app to the products on the basis of direct labor hours. Last year, Come-On-In Manufacturing purchased an expensive robotics syst to allow for more decorative door products in the deluxe product line. The CFO suggested that an ABC analysis could be valua to help evaluate a product mix and promotion strategy for the next sales campaign. She obtained the following ABC informati for 2010: Total Overhead Costs $96,000 Required: (To solve this problem you must use Excel and upload in the course Blackboard) a. Using the current system, compute predetermined overhead rate and unit product cost of each type of door. b. Using ABC, compute ABC rate and unit product cost of each type of door c. Explain why there are difference in unit product costs under current system and under activity based costing