Reference no: EM133782273

Question

The executives of Ace Consulting wanted to evaluate the revenue-generating productivity of employees and departments at year-end. Employees generate revenue through billable client hours. Department managers are responsible for a group of employees, helping to ensure that the company has enough employees to serve client projects but not too many employees that there is not enough work to keep each employee at least 90% utilized on billable efforts. The following data was available for the year: Department Manager A Date Hired Client Hours Yr. 2023 Available Hours Yr. 2023 Employee A1 2018 1920 2000 Employee A2 2019 1850 2000 Employee A3 6/1/2023 1050 1160 Employee A4 9/1/2023 610 660 Department Manager B Date Hired Client Hours Yr. 2023 Available Hours Yr. 2023 Employee B1 2016 1800 1960 Employee B2 2019 1925 2000 Employee B3 2018 1840 2000 Employee B4 6/1/2023 1040 1160 Employee B5 9/1/2023 600 660 Determine which department had the highest utilization rate and list the rate calculated for the highest department as a percentage with no sign and one place after the decimal point (such as 85.5).