41. Activity-Based Costing Versus Traditional Approach, Activity-Based Management. Fine Finishing, Inc., produces a wood desk that sells for $500 and a wood table that sells for $900. Last year, total overhead costs of $6,000,000 were allocated based on direct labor costs. Direct labor costs totaled $2,000,000 last year, and the company produced 15,000 desks and 5,000 tables. Total direct labor and direct materials costs by product for last year were as follows: Table Desk Direct materials $1,575,000 $950,000 Direct labor $1,200,000 $800,000 The management of Fine Finishing, Inc., would like to use activity-based costing to allocate overhead rather than one 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 Overhead Costs Desk Table Total Activity Cost Driver Purchase orders Number of purchase orders $ 800,000 900 100 1,000 Machine setups Number of setups 1,600,000 240 260 500 Machine Machine hours 2,400,000 42,000 18,000 60,000 maintenance Number of Quality inspections inspections Total 1,200,000 15,000 5,000 20,000 $ 6,000,000 Desk Predetermined Cost Activity Overhead Rate Driver Activity Purchase orders per order Machine setups per setup Machine maintenance per machine hour Quality inspections per inspection Total overhead costs allocated Total companywide overhead costs Overhead cost per unit for each product (rounded to nearest cent) Table Cost Overhead Allocated* Driver Overhead Activity Allocated $ 80,000 $6,000,000 $386.40 c. 1. Using the activity-based costing allocation method, 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.) 2. Using the activity-based costing allocation method, allocate overhead to each product. (Hint: This is step 5 in the activity-based costing process.) Determine the overhead cost per unit. Round results to the nearest dollar. 3. What is the product cost per unit for the desk and table products? d. Calculate the per unit profit for each product using the plantwide approach and the activity- based costing approach. How much did the per unit profit change when moving from one approach to the other? e. Refer to the estimated cost driver activity provided. Calculate the percent of each activity consumed by each product (for example, the desk product issued 900 of the 1,000 purchase orders issued in total and therefore consumes 90 percent of this activity). These percentages represent the amount of overhead costs allocated to each product using activity-based costing. Using the plantwide approach, 60 percent of all overhead costs are allocated to the desk and 40 percent to the table. Compare the activity-based costing percentages to the percentage of overhead allocated to each product using the plantwide approach. Use this information to explain what caused the shift in overhead costs to the desk product using activity-based costing