Problem 4: Activity-Based Costing Versus Traditional Approach: Service Company, Activity-Based Management. (Topic B03) (30 point] Hodges and Associates is a small firm that provides structural engineering services for its clients. The company performs structural engineering services for both residential and commercial buildings. Last year, total overhead costs of $330,000 were allocated based on direct labor costs. A total of $300,000 in direct labor costs were incurred in the following areas: $120,000 in the residential segment and $180,000 in the commercial segment. Direct materials used were negligible and are included in overhead costs. Sales revenue totaled $450,000 for residential services and $330,000 for commercial services. The management of Hodges and Associates would like to use activity-based costing to allocate overhead rather than a plantwide rate based on direct labor costs. The following estimates are for the activities and related cost drivers identified as having the greatest impact on overhead costs. Estimated Cost Driver Activity Estimated Activity Cost Driver Overhead Costs Residential Commercial Scheduling and data entry Direct labor hours $100,000 4.500 3,500 Computer maintenance Number of computer hours 70,000 8000 12,000 Processing permit applications Number of applications 160,000 400 400 Total $330,000 Total 8,000 20.000 800 Required: 1. Using the plantwide allocation method, calculate the total cost for each product. (Hint: Product costs for this company include overhead and direct labor.) 2. Using the plantwide approach, calculate the profit for each product. Also calculate profit as a percent of sales revenue for each product (round to the nearest tenth of a percent). 3. Using activity-based costing, calculate the predetermined overhead rate for each activity. (Hint: Step 1 through step 3 in the activity-based costing process have already been done for you; this is step 4.) Round results to the nearest cent. 4. Using activity-based costing, calculate the amount of overhead assigned to each product. (Hint: This is step 5 in the activity-based costing process.) 5. Using activity-based costing, calculate the profit for each product. Also calculate profit as a percent of sales revenue for each product (round to the nearest tenth of a percent). 6. What caused the shift of overhead costs to the residential product using activity-based costing? How might management use this information to make improvements within the company