Who's booked, who's on the bench — operational dashboard demo

Utilisation

–

vs 85% target

–

billable ÷ net capacity

On the bench

–

people under 70%

Bench cost

–

idle capacity / week

Non-billable

–

leave · admin · BD · training

Utilisation — who's booked, who's on the bench

Weeks 1–13: billable % of net capacity, per person per week — amber outline = 95% or over, no slack left. Weeks 14–26 (faded): booked hours against contracted capacity — red outline = booked past capacity. Forward weeks are illustrative, not actuals. Click any cell or name to isolate that person.

idlefully booked

Where the hours go

Net capacity decomposed: −leave −admin −BD −training = billable. The honest utilisation denominator.

Utilisation trend — signal vs noise

Firm weekly utilisation with mean ±2σ band (actual weeks only, n=13). Points outside the band are special-cause.

Forward utilisation

–

weeks 14–26 booked

Committed / probable

–

of booked hours

Net gap · next 8 wks

–

capacity − demand

Recommendation

–

structural = hire · spike = freelance

Capacity vs booked demandIllustrative forecast

Forward weeks: contracted capacity (line) vs booked demand (bars). Bars over the line = a deficit → freelance/hire. Forward bookings are synthetic illustrative assumptions, not confirmed work.

Forward bookings by confidenceIllustrative forecast

Booked hours split committed / probable / pipeline, by week

Rate realisation

–

billed ÷ standard rate

Discount leakage

–

£ vs rack rate

Worst-realising client

–

Blended bill rate

–

£/billable hour

Realisation by seniority

Billed vs standard rate per grade. Below 100% = discounting that grade's time. Are seniors billed at a discount?

Client realisation — volume vs discount

Each dot a client · x = billable hours · y = realisation % · size = fee. Bottom-right = big & discounted = renegotiate.

Blended margin

–

fee − grade-weighted cost

Below-target projects

–

margin under 25%

Loss-making

–

Over-serviced hours

–

booked beyond budget

Project profit cliff — who pays, who drains

Projects ranked by margin £ (bars, oxblood = profit / rose = loss) + cumulative line. The dip at the right is the loss-makers pulling total profit down.

Over / under-servicing — hours vs budget

Hours booked beyond budget = margin given away. Right = over-serviced (leak), left = under budget. Click to drill.

Active clients

–

with billable work

Top-3 concentration

–

of fee revenue

Avg client margin

–

fee − cost

Loss-making clients

–

negative contribution

Client margin by team

Contribution margin % for each client × delivery team · darker oxblood = healthier · rose = loss · thin cells (<40h) greyed

Revenue concentration

Fee revenue by client (bars) + cumulative share — how much rides on the top few clients

Headcount

–

people in view

Over-worked seniors

–

Partner/Lead over 95%

Idle juniors

–

Mid/Junior under 65%

Avg utilisation

–

across people in view

Seniority pyramid & utilisation

Headcount by grade (bars) with average utilisation marker — spot over-worked seniors / idle juniors

People — utilisation vs realisation

Each dot a person · x = utilisation · y = realisation % · colour = team. Top-right = star billers; bottom-left = at-risk.

Work in progress

–

delivered − invoiced

Over-serviced value

–

delivered beyond fee

WIP % of fees

–

locked-up value

Delivered to date

–

billable value earned

WIP by project — delivered vs invoicedIllustrative invoicing

Billable value delivered vs invoiced-to-date per project. The gap is unbilled WIP — cash you've earned but not raised. Invoicing cadence is illustrative.

Delivered value — cumulative

Cumulative billable value earned across the quarter (actual weeks)

Project book

Aggregated on current filters · click a header to sort · click a row to filter

Group by

Group	Billable hrs	Billed £	Margin £ ▼