Every work order this quarter: quoted price against real cost, by crew and technician, including the losers.
Filters persist across every tab. Click any bar, dot or job row to drill down. Scheduled jobs carry no actuals and are excluded from margin math.
No rows match these filters.Nothing is being calculated, because there is nothing to calculate from — a rate over
zero rows is not zero, it is undefined, and showing you a number here would be a wrong one.
Jobs
–
Blended margin
–
Avg margin / job
–
completed jobs
Jobs at a loss
–
Margin leaked
–
on loss-making jobs
Quote → actual by job type
Average quote vs average actual cost per job type · the bar runs quote→cost · red = over quote (margin leak)
Jobs by margin band
How the job book splits · loss · thin · healthy · strong
Work orders
Every completed job on current filters · worst margin first · click a row to drill into the client
Job
Client
Type
Crew
Quote
Actual
Margin ▲
Band
Median overrun
–
actual vs quote
Jobs over quote
–
Worst job type
–
Margin leaked to overruns
–
actual above quote
Overrun spread by job type — P10 → P90
Overrun % (actual vs quote) per job type · light bar = P10–P90, amber = middle-half, navy tick = median. Wide = unpredictable pricing.
Margin leaked to overruns — by job type
Total £ lost to jobs running over quote (bars) + cumulative share
First-time-fix
–
fixed on first visit
Avg revenue / tech / day
–
quote value booked
Utilisation
–
on-site hrs ÷ available
Best crew margin
–
Technician scorecard — utilisation vs first-time-fix
Each dot a technician · x = utilisation · y = first-time-fix % · size = revenue. Low on the y-axis is where rework comes from — a big bubble sitting low costs most. Utilisation assumes 8 billable hrs/tech/working day.
Margin by crew
Total margin £ per crew · navy = profit, red = loss · click to drill
Clients
–
with completed jobs
Profitable clients
–
Top client margin
–
% margin from top 5
–
client concentration
Client profit cliff — who pays, who costs
Clients ranked by margin £ (bars, navy = profit / red = loss) + cumulative line. The dip is the loss-making clients dragging the book down.
Margin by client × job type
Margin % for the busiest clients × job type · navy = healthy, red = loss · thin cells (<5 jobs) greyed
Jobs / working day
–
across the quarter
Busiest day
–
Peak hour
–
most jobs start
Scheduled / open
–
not yet completed
Dispatch board — jobs by day × hour
Job starts by weekday and hour · darker = busier. Illustrative of the scheduling shape this data models (synthetic).
quietbusy
Booked vs completed, by week
Completed jobs vs still-scheduled jobs per week
First-time-fix
–
excl. warranty
Callback rate
–
jobs generating a return
Cost of rework
–
actual cost of callbacks
Worst job type
–
Callback rate by job type
Share of jobs generating a return visit (bars) + cumulative £ rework cost · modelled from job records for this demo
Weekly callback rate — signal vs noise
Callback % per week against the mean and ±3σ control limits · points outside the band are special-cause
Outstanding
–
invoiced, not yet paid
Overdue > 45 d
–
Overdue jobs
–
need chasing
Avg days to pay
–
paid jobs
Receivables aging
Outstanding invoice value by age · redder = older
Outstanding by client
Who to chase Monday · worst 12 clients by unpaid value