Signal Lab

Services Revenue Ceiling

Headcount × hours × utilization × realized rate — the services P&L engine

Industry — Professional Services Revenue / Pipeline What-ifs Profitability

Signal Lab · Model

Services Revenue Ceiling

Capacity-to-revenue ceiling for professional / field services. Utilization and realization stay separate levers.

Illustrative AU professional / field services sample until you enter actuals. Not financial advice.

Headcount, hours, rates, and target

Utilization ≠ realization — util is time sold; realization is what you collect vs standard rate. Persist locally · Jump to ceiling

Share of available hours that are billable (time sold).

Collected / standard — write-offs, discounts, under-billing. Not the same as utilization.

Utilization vs realization

Utilization answers “how much of capacity did we sell?” Realization answers “of what we billed at standard, how much did we keep?” Raising one does not automatically raise the other.

Revenue ceiling vs target

Available hours → billable hours → realized rate → ceiling. Gap and lever ranking below.

Equations

  • Available hours = Headcount × Hours / person / period
  • Billable hours = Available × Utilization %
  • Realized rate = Standard rate × Realization % (≠ utilization)
  • Ceiling = Billable hours × Realized rate · Gap = Ceiling − Target

Lever ranking (isolated +5 pts or +1 FTE)

How this is calculated
  • Available hours = Headcount × Hours / person / period
  • Billable hours = Available × Utilization %
  • Realized rate = Standard rate × Realization %
  • Revenue ceiling = Billable hours × Realized rate
  • Gap = Ceiling − Target (positive = surplus)

Further reading (footnote only, not scraped): Jirav · Drivetrain. Illustrative — not advice.

Sensitivity dials

+Util pts · +Realization pts · +Headcount — live ceiling and gap.

What-if dials

Each dial stacks on your base inputs. Utilization and realization remain separate.

Adds percentage points to utilization (capped at 100%).

Adds percentage points to realization (capped at 120%).

Adds blended billable FTEs at current util and realization.

Take it with you

Download a prompt, export the Excel workbook, or email yourself.

Email opens your mail client with the prompt in the body (mailto). No account required. Data stays in this browser (localStorage).