Manual OM tracker + live Supabase warehouse · Jurisdiction: Ontario
SNAPSHOT
As of 18 Jun 2026
A · Warehouse — by Ops Manager (Supabase, live)
Open Jobs
614
Overdue
58
Over Budget
38
Critical Jobs
436
Backlog
$8.3M
WIP Unbilled
-$2.9M
Ops Manager
Open Jobs
Overdue
Over Budget
Avg Days Open
Critical Jobs
Backlog $
WIP Unbilled $
On trackWatchOff target▸ Click an Ops Manager to see their coordinators. Thresholds editable in CONFIG.
All six OMs now tracked. Bridge confirmed via employee_pcc_mappings; Stella D'Silva and Nathan Bellrose added. Two things still to watch: (1) Stella holds $3.4M backlog / -$2.2M unbilled on only 46 jobs (avg 189 days open) — your single biggest cash exposure; getting her onto the daily cadence is the priority. (2) Terry Johnson shows only 4 open jobs vs a 5-PC roster in the tracker — likely a reassignment or attribution gap worth confirming.
B · OM Daily Tracker (manual entry)
Awaiting entries. These populate from the four OM tabs in OM_Daily_Tracker. Counts (Pending/New/Ongoing/Completed, Emerg>7d, Files Closed, XA>5d) and discipline % (Backlog reason, Estimates audited, Estimator review, XA closed&assigned, Coord schedule returned, GP met) flow here once OMs fill the sheet. Discipline target = 100%.
D · Claims Intake — by PM / Insurer / Region
Latest Day
—
Week to Date
—
Month to Date
—
Year to Date
—
By Project Manager
PM
WTD
MTD
YTD
By Insurer
Insurer
WTD
MTD
YTD
By Region
Region
WTD
MTD
YTD
Claims counted from the daily roundup emails → public.claims (live via the Worker). Top 12 shown per dimension; units = claims assigned. Region = the city as entered in the email. Normalized 2026-06-21:Halton Peel→Halton (same territory, relabeled May 29) and Toroto→Toronto (typo). Future variants need the same one-line cleanup until the parser maps them.
C · Operating Standards (targets)
Emergency SLA
≤ 7 days hard
GP — Emergency
≥ 40%
GP — Repair/Core
≥ 30%
GP — Commercial
≥ 35%
GP — Contents
≥ 50%
Backlog reasons
100% documented
Estimate audit
Daily · pre-Desk
XA estimate aging
Flag > 5 days
Closure rate
≥ 36% YTD
E · Sales — MTD vs Target
MTD Sales
—
Target
—
% of Target
—
Variance
—
Business Unit
Budget
MTD Actual
% of Target
Variance
MTD Sales by PM
PM
MTD $
MTD Sales by Ops Manager
Ops Manager
MTD $
MTD Sales by PCC
PCC
MTD $
Sales = live Monday invoicing for the current month (—), synced every 2h. Monday provides only the job # + invoiced value; PM / Ops / PCC assignments come from Supabase (v_job_assignments, joined by job #). Budget by BU from Sales Budget 2026.