ClearOps Co
Service Repair — Aged RO Dashboard
Branch Status Aging
Total Open ROs
365
repair orders
Total RO Value
$954K
open dollar amount
ROs > 10 Days
159
44% of selected ROs
ROs > 30 Days
71
19% of selected ROs
Avg Age (Days)
17.0
across selected ROs
Aging Distribution
RO count by age bucket — click to drill
0–10 Days 11–30 Days 31+ Days
Status Breakdown
Open ROs by current status — click to drill
Dollar Value by Age
Total $ exposure per bucket — click to drill
0–10 Days 11–30 Days 31+ Days
Branch Comparison
Total RO count (navy) vs. 31+ day flags (gold) — top 10 by volume — click a branch to drill
Total ROs 31+ Days
Function Priority Period
Open Requests
284
across all functions
SLA Compliance
87%
target: 95%
Avg Resolution Days
4.8
target: <3.0
Requests > 7 Days
61
21% of open
Escalations (QTD)
18
target: <10
Request Volume by Function
Open work items this quarter — click to drill
SLA Compliance by Function
% requests resolved within SLA — click to drill
Aging — Open Requests
Days since submission
0–3 Days 4–7 Days 8+ Days
Monthly Intake vs. Closed
Jan–Mar 2025 request flow
Intake Closed
Capacity Utilization by Team
% of available bandwidth in use
HR94%
Target: <85%
Finance / AP88%
Target: <85%
IT Support76%
Target: <85%
Facilities61%
Target: <85%
Function Scorecard
Q1 performance snapshot
FunctionAvg DaysSLA %Status
HR6.279%Watch
Finance/AP5.187%Watch
IT Support2.894%On Track
Facilities3.491%On Track
Other4.982%Watch
Service Line Crew Period
Jobs Completed
412
Q1 all service lines
Open Estimates
$287K
68 quotes pending
Equip Utilization
71%
target: 82%
Avg Job Cycle (Days)
3.2
target: <2.5
Callback / Rework
4.8%
target: <2%
Revenue by Service Line
Q1 — click a bar to drill
Quote-to-Close Rate
Estimates converted — click to drill
Equipment Utilization — Monthly
Revenue days vs. available fleet days
Utilized Target 82%
Open Estimate Aging
Days since quote issued — click to drill
0–7 Days 8–21 Days 22+ Days
Crew Productivity
Billable hours as % of total paid hours
Crew A — Install81%
Target: 80%
Crew B — Maintenance77%
Target: 80%
Crew C — Mixed69%
Target: 80%
Crew D — Irrigation74%
Target: 80%
Service Line Scorecard
Q1 performance snapshot
LineMarginCallback%Status
Maintenance44%3.1%Watch
Install/Design38%6.2%Watch
Equip Sales28%1.1%On Track
Irrigation41%2.8%On Track
Division Lane Period
Loads Covered (QTD)
1,842
brokerage + fleet
On-Time Delivery
91%
target: 94%
Asset Utilization
78%
target: 85%
Claims / 100 Loads
1.2
target: <1.0
Avg Load Cycle (Days)
2.3
target: <2.0
On-Time Performance — Monthly
OTP % by division Jan–Mar
Brokerage Fleet Warehouse
Asset Utilization — Fleet
Revenue days vs. available — click to drill
Utilized % Target 85%
Load Volume by Division
Total loads covered Q1 — click to drill
Brokerage Warehouse Fleet Rental
Exception & Rework Rate
% transactions requiring correction Jan–Mar
Brokerage Fleet Warehouse
Cross-Division Health
Key operational indicators vs. target
OTIF — All Divisions88%
Target: 93%
SLA Compliance94%
Target: 95%
PM Compliance — Fleet91%
Target: 95%
Carrier Repeat Usage71%
Target: 70% — On Track
Overtime % of Payroll14%
Target: <8%
Division Scorecard
Q1 performance snapshot
DivisionOTPUtil%Status
Brokerage91%Watch
Warehousing95%83%On Track
Fleet Rental89%78%Gap