Please answer parts A and B. I'm completely lost. The use of a excel would be ideal so I can see exactly where I'm messing this up. Thank you.

P4.5A (LO 1, 2, 3, 4), AN Service 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 Assign overhead costs to services using traditional costing and ABC, compute overhead rates and unit costs, compare results. Estimated Use of Cost Drivers Estimated Use of Cost Drivers per Service Estimated Overhead Cost Drivers Audit Tax $1,100,000 Direct labor dollars Number of reports/forms Number of minutes $216,000 76,200 Activity Cost Pools Employee training Typing and secretarial Computing Facility rental Travel $700,000 1,700 $1,800,000 2,500 60.000 800 204,000 27,000 33,000 40 22 18 Number of employees Per expense reports 142,500 81,300 $720,000 Direct 56,000 25,300 Instructions a. 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. b. 1. Using activity-based costing, prepare a schedule showing the computations of the activity-based overhead rates (per cost driver). 2. Prepare a schedule assigning each activity's overhead cost pool to each service based on the use of the cost drivers. Cost assigned-Tax $337,441