Travel & Margin Analysis

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

WOs Analyzed

166

Total Travel Cost

$7,480

11,164 miles

Avoidable Cost

$4,643

6,930 excess miles

Optimal Cost

$2,837

If closest tech always used

Avg Excess / WO

41.7 mi

$27.97 per WO

Median Excess

27.5 mi

Outlier Rate (>50mi)

28.3%

47 WOs

From 147 WOs with expense data

Total Expenses

$51,214

Labor - Travel

$44,974

Mileage

Lodging

$2,333

Airfare

$582

Car Rental

$541

Per Diem

$1,200

Meals

Other

$1,584

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
Animal Health	166	41.7 mi	6,930	$4,643

Order Type	WOs	Avg Excess	Total Excess	Avoidable Cost
Repair R	52	36.4 mi	1,892	$1,268
Preventive Maintenance P	40	43.9 mi	1,754	$1,175
Asset Tagging P	17	51.2 mi	870	$583
Inspection P	19	40.0 mi	761	$510
Installation P	11	62.2 mi	684	$458
Misc. Inspection P	21	24.0 mi	504	$338
Relocation P	1	365.7 mi	366	$245
Evaluation P	3	31.9 mi	96	$64
Calibration P	2	1.9 mi	4	$3

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)
AZ	42	48.2 mi	37.7 mi	1,585	$1,062	11 (26.2%)
CA	36	62.0 mi	38.5 mi	1,387	$929	11 (30.6%)
FL	8	103.1 mi	90.4 mi	724	$485	4 (50%)
CO	1	582.8 mi	575.9 mi	576	$386	1 (100%)
IL	3	157.0 mi	141.2 mi	424	$284	2 (66.7%)
PA	2	180.4 mi	151.0 mi	302	$202	2 (100%)
NY	10	58.0 mi	26.4 mi	264	$177	2 (20%)
TX	9	35.3 mi	27.7 mi	249	$167	3 (33.3%)
MO	4	138.4 mi	61.2 mi	245	$164	1 (25%)
OH	3	68.1 mi	60.7 mi	182	$122	1 (33.3%)
TN	2	137.7 mi	65.4 mi	131	$88	2 (100%)
VA	1	138.1 mi	123.1 mi	123	$82	1 (100%)
WI	1	137.8 mi	122.3 mi	122	$82	1 (100%)
WA	14	75.3 mi	7.9 mi	111	$74	0 (0%)
VT	1	208.8 mi	85.2 mi	85	$57	1 (100%)
OR	3	34.8 mi	25.5 mi	77	$52	0 (0%)
NE	1	171.9 mi	63.1 mi	63	$42	1 (100%)
NH	1	94.7 mi	62.5 mi	62	$42	1 (100%)
AL	1	100.3 mi	58.8 mi	59	$40	1 (100%)
MI	7	18.3 mi	8.3 mi	58	$39	1 (14.3%)
MA	2	46.0 mi	24.0 mi	48	$32	0 (0%)
NJ	2	12.6 mi	10.5 mi	21	$14	0 (0%)
CT	3	28.2 mi	4.3 mi	13	$9	0 (0%)
MD	1	27.3 mi	12.4 mi	12	$8	0 (0%)
ME	1	154.6 mi	7.2 mi	7	$5	0 (0%)
MN	3	8.3 mi	0.0 mi	0	$0	0 (0%)
SC	1	1.7 mi	0.0 mi	0	$0	0 (0%)
NC	1	45.6 mi	0.0 mi	0	$0	0 (0%)
GA	1	138.4 mi	0.0 mi	0	$0	0 (0%)
NV	1	4.0 mi	0.0 mi	0	$0	0 (0%)