please can someone solve the problem with detailed formulas.

KV Accounting and Business Consultants provides a variety of consulting services to a diverse range of clients. The company has three support departments and three revenue-generating departments, whose cost details for a typical quarter are presented below: Support Departments IT Support Admin Support $ 290,500 Facilities Support 724,000 206,250 Revenue-Generating Departments Assurance 883,500 Tax Advisory 635,000 Business Advisory 803,400 $3,542,650 The existing cost allocation system is designed as follows: (1) the support department costs are allocated to the three revenue- generating departments, and (2) the revenue-generating department costs are allocated to individual clients. The support department costs are allocated to the revenue-generating departments as follows: (1) IT Support costs are allocated to Assurance, Tax Advisory, and Business Advisory using a 30:30:40 ratio, (2) Admin Support costs are allocated using a 40.30.30 ratio, and (3) Facilities Support costs are allocated using a 40:40.20 ratio. The costs accumulated in the three revenue-generating departments are allocated to individual clients based on the professional time consumed in the respective department. The Assurance, Tax Advisory, and Business Advisory departments recorded 10,500, 9,000, and 7,500 hours, respectively, for the quarter Required: 1. Compute the predetermined cost allocation rates for the three revenue-generating departments (Round your answers to 2 decimal places.) Predetermined Cost Allocation. Required: 1. Compute the predetermined cost allocation rates for the three revenue-generating departments. (Round your answers to 2 decimal places.) Predetermined Cost Allocation Rate Assurance Tax Advisory Business Advisory 2. Using the rates computed in Requirement (1) above, assign the costs to clients X and Y. Client X required 490, 630 and 750 hours of professional time, respectively, in the Assurance. Tax Advisory and Business Advisory departments, whereas client Y required 750, 900 and 350 hours of professional time. (Do not round intermediate calculations. Round your answers to the nearest whole dollar) Client X Client Y Assurance Service Tax Advisory Service Business Advisory Service $ 0 $ 0 3. You have recently learned about activity-based costing and decide to use six activity cost pools, one for each department. The additional information you have collected is as follows: Allocation Base Activity Cost Pool Cost Driver (allocation base) IT Support Quantity IT time 17,250 hours Admin Support Sales revenue $69.62 million Facilities Support Assurance 24,720 hours Tax Advisory Total professional time Assurance professional time Tax advisory professional time Business advisory professional time 10,500 hours 9,000 hours 7,500 hours Business Advisory Compute the predetermined allocation rate for each activity cost pool. (Round your answers to 2 decimal places.) Activity Cost Pool Activity Rate IT Support per IT support hour Admin Support % of sales revenue Facilities Support per hour of professional time per hour of assurance professional time Assurance per hour of tax advisory professional time Tax Advisory per hour of business advisory professional time Business Advisory 4. In addition to the Assurance, Tax Advisory, and Business Advisory time specified in Requirement (2) above, the two clients consumed the following additional resources: Resource. IT time (hours) Sales revenue Client X 500 $1,480,500 Client Y 300 $987,000 Assign the costs to the two clients using activity-based costing. (Round intermediate calculations to 2 decimal places and final answers to the nearest dollar amount.) Client X Client Y IT Support Admin Support Facilities Support Assurance Tax Advisory Business Advisory S 0$ 0 2