Please note that number 1 is calculating each consultants utilization rate for the QUARTER.

number 2 calculate the AVERAGE WEEKLY utilization rate for each consultants. please provide workings for better understanding.

Utilization Problem (10 total points) 1. The Great-Compaty Consulting Agency has three consultants currently working for them. You are the consulting practice manager, and you need to calculate each consultant's utilization rate for the quarter. Using the table and data below, calculate each consultant's utilization rate. The Great-Company Consulting Agency bases their calculations for utilization on 2000 hours a year of available, billable time. Hint A quarter does not have 2000 hours. (5 Points) Quarter Consultant's Name Total Number of Billable Hours Quarter 1 Utilization rate % 1 Ortense Behl 345.8 ES Vemon Anderson 489.1 1 Ruben Kleinschmidt 520.0 2. You are the consulting manager for the Great-Company Consulting Agency. You have the following data below. You were asked by your company leadership to calculate the average weekly utilization rate for your consulting team Below, you'll find the total number of hours (billable and non-billable) last year for each consultant. Using this data, calculate the average weekly utilization rate for each consultant for last year's data (5 Points) Year Consultant's Name Total Number Average Weekly Utilization Rate of Billable Hours 2015 Ortense Behl 1500.0 2015 Vernon Anderson 1800.6 2015 Ruben Kleinschmidt 2100.0