I am working on this problem in excel.

P17.5 (LO 1, 2,3,4), AN Service Lewis and Stark is a public accounting firm that offers two primary services, auditing a return preparation. A controversy has developed between the partners of the two service lines as to who is contributing the greatet .watount to the bottom line. The area of contention is the assignment of overhead. The tax parthers argue for assigning overhead on the basis of 40% of direct labor dollars, while the audit partners argue for implementing activity-based costing The partiers agree to use next year's budgeted data for purposes of analysis and comparison. The following overhead data are collected to develop the comparison. b. 1. Using activity-based costing, prepare a schedule showing the computations of the activity-based overhead rates (per cost driver). (Hint: As a result of breaking out travel costs as a separate cost pool, travel costs can now be traced directly to services provided. Thus, an overhead rate is not needed.) 2. Prepare a schedule assigning each activity's overhead cost pool to each accounting service based on the use of the cost drivers. b. (2) Cost assigned Tax $337,441