Lewis and Stark is a public accounting firm that offers two primary services, auditing and tax-return preparation. A controversy has developed between the partners of the two service lines as to who is contributing the greater amount to the bottom line. The area of contention is the assignment of overhead. The tax partners argue for assigning overhead on the basis of 40% of direct labor dollars, while the audit partners argue for implementing activity-based costing. The partners agree to use next year's budgeted data for purposes of analysis and comparison. The following overhead data are collected to develop the comparison. Estimated Use of Cost Drivers per Service Estimated Use of Activity Cost Pools Cost Drivers Estimated Overhead Cost Drivers Audit Tax Employee training Direct labor dollars $213,000 $1,775,000 $1,196,000 $579,000 Typing and secretarial Number of reports/forms 76,400 2,500 800 1,700 Computing Number of minutes 193,200 60,000 27,000 33,000 Facility rental Number of employees 146,000 40 22 Travel Per expense reports 81,400 Direct 56,000 25,300 $710,000 Using traditional product costing as proposed by the tax partners, compute the total overhead cost assigned to both services (audit and tax) of Lewis and Stark. Audit Tax Total overhead cost assigned $ e Textbook and Media Using activity-based costing, prepare a schedule showing the computations of the activity-based overhead rates (per cost driver). (Round overhead rates to 2 decimal places, e.g. 12.25.) Activity Estimated Expected Use of Activity-Based Cost Pools Overhead Cost Drivers per Activity Overhead Rates Employee Direct labor S $ $ training dollars Typing and Reports/forms $ secretarial pe do pe re Using activity-based costing, prepare a schedule showing the computations of the activity-based overhead rates (per cost driver). (Round overhead rates to 2 decimal places, s. 12.25.) Estimated Overhead Activity-Based Overhead Rates Expected Use of Cost Drivers per Activity Direct labor dollars $ $ dc Activity Cost Pools Employee training Typing and secretarial Computing Facility Reports/forms $ pi re Minutes $ rental Employees $ P er Travel Direct Direct $ e Textbook and Media Prepare a schedule assigning each activity's overhead cost pool to each service based on the use of the cost drivers. (Round overhead rates to 2 decimal places, e.g. 12.25 and cost assigned to 0 decimal places, e.g. 2,500.) Audit Activity-Based Overhead Rates Estimated Use of Cost Drivers Activity Cost Pool Cost Assigned Employee training $ $ Typing and secretarial $ Computing $ I Facility rental $ Travel Direct Overhead costs assigned S Using activity-based costing, prepare a schedule showing the computations of the activity-based overhead rates (per cost driver). (Round overhead rates to 2 decimal places, s. 12.25.) Estimated Overhead Activity-Based Overhead Rates Activity Cost Pools Employee training Typing and secretarial $ $ pi de Expected Use of Cost Drivers per Activity Direct labor $ dollars Reports/forms $ re Computing Minutes pi Facility rental Employees $ er Travel Direct Direct $ e Textbook and Media Prepare a schedule assigning each activity's overhead cost pool to each service based on the use of the cost drivers. (Round overhead rates to 2 decimal places, eg. 12.25 and cost assigned to 0 decimal places, e.g. 2,500.) Estimated Use of Cost Drivers Tax Activity-Based Overhead Rates Cost Assigned Cost Assigned S $ $ $ I S Direct $