01 Utilisation — key metrics
Filtered by client, position & name aboveActive workforce — workers with hours > 0 in the current month, sourced from the DailyPersonnelSchedule roster. Total engaged — distinct workers with any hours across the full 7-month reporting window; this is the broadest measure of the pool SRG has drawn on for Northwest. Avg hrs / worker — trailing 3-month average; hours are summed and divided by distinct workers × months so gaps count as zero, reflecting consistency rather than peak intensity. Forward committed — total hours in the next 3 months from confirmed and mobilising bookings only; contacted, planning, and short-list entries are excluded.
02 Utilisation — Position × Month
3 months behind, current, 3 months forward. Cell tint = MoM retention %.Source: DailyPersonnelSchedule (historical) and roster bookings (forward). Each cell shows headcount (workers with hours > 0) and total hours. Colour reflects month-on-month retention — the share of last month's workers who also appear this month: green ≥ 70 %, amber 50–70 %, red < 50 %. Forward months (hatched background) include only confirmed and mobilising bookings — soft statuses such as contacted, planning, and short list are excluded. Positions are ordered by discipline group.
03 By client
Same structure as Section 02, scoped to each clientThe same position × month utilisation table repeated for each client. A worker's hours appear under a client only in months where that client is their dominant assignment (most rostered days). Workers who split time between clients in a month are attributed to whichever client had more days. Click a client panel to expand it.
04 Utilisation trend
Avg hours / worker across the reporting windowAverage hours per active worker by month. A worker must have hours > 0 in that month to be included in the average — workers on zero hours do not dilute the figure. Months with no active workers for a client are shown as a gap in that client's line. Reflects the current filter selections.