I need answer in excel with formula

Help Save & Exit Submit 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 $ 293,500 Admin Support 728, 600 10 Facilities Support 208, 150 points Revenue-Generating Departments Assurance 891, 709 Skipped Tax Advisory 641,060 Business Advisory 809, 600 $3,571, 950 e Book 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, Print and Business Advisory using a 40:20: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,700, 9,200, and 7,700 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 Rate Assurance Tax Advisory Business Advisory