Financial
Utilization, Realization, and Effective Hourly Rate formulas (agencies & law)
Decompose consulting and legal revenue leakage across Utilization %, Billing Realization %, and Collection % into Effective Hourly Rate.
The 4-lever professional services identity: Rate x Utilization x Realization x Collection
Track utilization, billing realization and collections separately.
Their product with standard rate reconciles to cash collected per capacity hour when the quantities refer to the same cohort and rate basis.
| Agency Practice KPI (160 Cap Hrs, $200 Std Rate) | Formula | Result |
|---|---|---|
| Billable Utilization (128 Billable Hrs) | =128 / 160 | 80.0% (0.80) |
| Billing Realization ($23,040 Invoiced vs $25,600 Std) | =23040 / (128 * 200) | 90.0% (0.90) |
| Collection Rate ($21,888 Cash Collected) | =21888 / 23040 | 95.0% (0.95) |
| Effective Yield / Capacity Hour | =21888 / 160 | $136.80 / hr |
Utilization, Realization, and Effective Hourly Yield formulas
Standard Potential Billings equals BillableHours (B2) * StandardRate (C2).
=ROUND(D2 / (B2 * C2), 4)Effective collected rate per total capacity hour
Equals CashCollected / CapacityHrs (identically C2 * Utilization * Realization * Collection).
=ROUND(E2 / A2, 2)Additional worked calculation
Using the initial example inputs:
=ROUND(B2 / A2, 4)Inputs and interpretation
Match collections to the same invoice cohort, not simply cash received in the same calendar period. Uncollected balances may reflect payment timing rather than bad debt. The identity assumes one standard rate or a correctly weighted equivalent. Require positive denominators and define capacity hours consistently.
Try the example
Use the original values or change them to test your understanding.