Employee Utilization Dashboard

Billable Hours & Revenue Realization — Meridian Consulting Group

Billable Utilization
68.2%
-8.4% vs target
Revenue Realization
89.3%
+1.2% vs prior
Revenue per Avail. Hour
$142
-$9 vs Q1
Bench FTEs
24
+12 since Wk6
Gross Margin / FTE
$38K
-14% vs plan
Presales Conversion
31%
+3% vs prior

Billable Utilization by Role Band

Non-Billable Hour Breakdown

Revenue Realization by Client Tier

Forecast vs Actual Utilization Variance

Top 10 Employees by Billable Hours (Current Period)

Employee Name Role Practice Billable Hrs Utilization Realization Status
Sarah Chen Principal Technology 468 89.2% 94.1% Active
Marcus Rodriguez Senior Manager Strategy 441 84.1% 91.8% Active
Emily Nakamura Manager Technology 438 83.5% 88.3% Active
David Foster Principal Operations 422 80.4% 92.7% Active
Priya Sharma Senior Manager Technology 415 79.1% 86.9% Rolling Off
James Liu Manager Strategy 408 77.8% 90.2% Active
Rachel Thompson Senior Consultant Operations 396 75.5% 87.4% Active
Kevin O'Brien Principal Technology 384 73.2% 93.6% Bench (Wk6)
Lisa Park Senior Manager Strategy 378 72.1% 89.1% Active
Tom Anderson Manager Technology 372 70.9% 85.7% Bench (Wk6)

Bench Aging by Discipline (FTE Count)

Utilization-to-Margin Conversion by Practice

Overtime & Compression Rate

Overtime Hours (>40/wk) 18.3%
Compression Rate (rushed) 12.7%
Alert: Tech Practice
42% overtime in Wk11-13 due to Project Orion re-staffing
Last refresh: May 18, 2024 08:42 UTC
Data source: Workday HCM + Salesforce PSA