Travel & Margin Analysis

Quantify excess travel cost and identify optimization opportunities across your field service operation

WOs Analyzed

149

Total Travel Cost

$30,322

45,257 miles

Avoidable Cost

$25,917

38,682 excess miles

Optimal Cost

$4,405

If closest tech always used

Avg Excess / WO

259.6 mi

$173.94 per WO

Median Excess

97.8 mi

Outlier Rate (>50mi)

57%

85 WOs

From 61 WOs with expense data

Total Expenses

$46,177

Labor - Travel

$32,310

Mileage

Lodging

$4,709

Airfare

$3,455

Car Rental

$1,261

Per Diem

$1,700

Meals

$458

Other

$2,283

Cost Overview Actual Expenses Cost Breakdowns Coordinator Analysis Tech Utilization Quick Wins Coverage Gaps Low Hanging Fruit

Cost by Vertical

Vertical	WOs	Avg Excess	Total Excess	Avoidable Cost
FCO	149	259.6 mi	38,682	$25,917

Order Type	WOs	Avg Excess	Total Excess	Avoidable Cost
FCO P	70	334.6 mi	23,423	$15,693
Preventive Maintenance P	63	206.8 mi	13,028	$8,729
Installation P	6	190.7 mi	1,144	$766
PM P	1	718.6 mi	719	$482
Repair R	7	52.6 mi	368	$247
New Hire Training P	1	0 mi	0	$0
Training P	1	0 mi	0	$0

States with high avg actual distance may indicate coverage gaps requiring territory realignment or new hires.

State	WOs	Avg Actual	Avg Excess	Total Excess Miles	Avoidable Cost	Outliers (>50mi)
FL	38	545.1 mi	515.4 mi	19,584	$13,121	25 (65.8%)
TN	17	353.2 mi	335.2 mi	5,699	$3,818	17 (100%)
KS	3	1104.2 mi	827.5 mi	2,483	$1,664	3 (100%)
PA	27	123.8 mi	83.2 mi	2,246	$1,505	13 (48.1%)
GA	6	345 mi	311.4 mi	1,868	$1,252	3 (50%)
MO	2	994.9 mi	794.8 mi	1,590	$1,065	2 (100%)
NY	22	89.8 mi	64.9 mi	1,428	$957	3 (13.6%)
NC	5	277 mi	203.9 mi	1,020	$683	5 (100%)
VA	3	312.3 mi	254.8 mi	764	$512	2 (66.7%)
KY	2	306.5 mi	302.1 mi	604	$405	2 (100%)
OH	2	332.6 mi	267.1 mi	534	$358	2 (100%)
MA	5	127.6 mi	71.7 mi	359	$241	4 (80%)
MD	2	130.8 mi	69.7 mi	139	$93	1 (50%)
DC	1	166.6 mi	106.8 mi	107	$72	1 (100%)
CT	1	125.4 mi	97.8 mi	98	$66	1 (100%)
DE	2	82.8 mi	47.9 mi	96	$64	1 (50%)
NJ	4	31.2 mi	10.2 mi	41	$27	0 (0%)
MI	1	206.6 mi	23.1 mi	23	$15	0 (0%)
IN	2	15.8 mi	0 mi	0	$0	0 (0%)
ME	3	130.1 mi	0 mi	0	$0	0 (0%)
TX	1	135.9 mi	0 mi	0	$0	0 (0%)