Field Service Dashboard

Route Optimization & Travel Efficiency — ClearFlow Water Systems

Goal: Miles/Job

18.4 → 15.5

Miles per Completed Job

17.2

-6.5% vs goal

Route Adherence

81%

-3% vs target

Detour Index

1.18

Target <1.10

Jobs per Route per Day

6.1

+8% vs LM

Travel Cost per Job

$28

+$3 Metro East

Route Disruption Rate

14%

Critical alert

Planned vs Actual Routes — Nov 7 Sample

Metro East territory showing 1.34 detour index with same-day reschedules Nov 5–7. SLA held but travel cost +$12/job.

Date	Territory	Detour Index	Unplanned Miles	Reschedules	Travel Cost/Job	Impact
Nov 7	Metro East	1.48	124 mi	8	$42	Critical
Nov 6	Metro East	1.41	108 mi	7	$39	Critical
Nov 5	Metro East	1.38	102 mi	6	$37	High
Oct 29	South Central	1.35	96 mi	5	$35	High
Oct 22	Metro North	1.32	89 mi	6	$34	High
Nov 12	Metro East	1.29	84 mi	4	$33	Medium
Oct 18	South Central	1.27	78 mi	5	$32	Medium
Nov 3	Metro North	1.26	75 mi	3	$31	Medium
Oct 15	Metro West	1.24	71 mi	4	$30	Medium
Nov 1	Metro East	1.23	68 mi	3	$30	Medium

Metro East

Below target

Metro West

Post re-zone pilot

Metro North

Acceptable

South Central

Below target

Re-zone Recommendation: Metro East and South Central show balance index <0.8. Re-zone pilot in Metro West reduced miles/job by 11%.

Key Insights — Route Optimization Recovery Path

• $67K/month recoverable: Metro East detour spike Nov 5–7 added $12/job travel cost. Next-day re-optimization can recover ~560 jobs/month.

• Same-day reschedules: 14% disruption rate destroys route integrity. Enforce 4-hour cutoff or dynamic re-routing middleware.

• Re-zone pilot success: Metro West territory redesign reduced miles/job 11% (19.4→17.2) while maintaining 6.1 jobs/route. Scale to East/South.

• SLA trade-off: Scatter plot shows adherence <75% correlates with SLA miss. Prioritize route integrity over hyper-optimization.