Travel & Margin Analysis

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

WOs Analyzed

1,129

Total Travel Cost

$86,092

128,495 miles

Avoidable Cost

$74,407

111,056 excess miles

Optimal Cost

$11,685

If closest tech always used

Avg Excess / WO

98.4 mi

$65.91 per WO

Median Excess

4.3 mi

Outlier Rate (>50mi)

21%

237 WOs

From 67 WOs with expense data

Total Expenses

$47,540

Labor - Travel

$3,593

Mileage

Lodging

$13,200

Airfare

$14,435

Car Rental

$6,290

Per Diem

$4,425

Meals

Other

$5,597

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
Lab/Power	1,129	98.4 mi	111,056	$74,408

Order Type	WOs	Avg Excess	Total Excess	Avoidable Cost
Overhaul P	34	1037.5 mi	35,275	$23,634
PM/CAL P	71	356.8 mi	25,334	$16,974
Repair R	676	20 mi	13,540	$9,072
Monthly Annuity P	12	859.5 mi	10,314	$6,910
Preventive Maintenance P	194	51.1 mi	9,916	$6,644
Repair/PM R	25	386.2 mi	9,656	$6,470
IOQ P	14	266.1 mi	3,726	$2,496
Acct. Management P	42	43 mi	1,807	$1,211
EOQ P	36	30.1 mi	1,085	$727
PQ Only P	1	329.2 mi	329	$220
Installation P	3	24.4 mi	73	$49
Calibration P	3	0 mi	0	$0
Cross-Training P	16	0 mi	0	$0
PM-EXT P	1	0 mi	0	$0
Site Prep 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)
NM	71	362.4 mi	356.8 mi	25,334	$16,974	71 (100%)
TX	108	207.7 mi	190.3 mi	20,550	$13,769	78 (72.2%)
CA	172	110.6 mi	95.1 mi	16,364	$10,964	26 (15.1%)
CO	8	1440.1 mi	1422.2 mi	11,378	$7,623	7 (87.5%)
MI	10	653.6 mi	612.1 mi	6,121	$4,101	10 (100%)
PA	13	486.9 mi	351.3 mi	4,567	$3,060	11 (84.6%)
MA	658	5.6 mi	5.2 mi	3,436	$2,302	0 (0%)
WA	3	1454.1 mi	976.1 mi	2,928	$1,962	3 (100%)
AL	4	840.8 mi	729.1 mi	2,917	$1,954	3 (75%)
IL	5	534.7 mi	390.1 mi	1,951	$1,307	3 (60%)
WI	2	902.8 mi	854.7 mi	1,709	$1,145	2 (100%)
NY	6	297.7 mi	282.7 mi	1,696	$1,136	6 (100%)
MS	2	880.5 mi	755.2 mi	1,510	$1,012	2 (100%)
DE	16	198.4 mi	92 mi	1,473	$987	1 (6.3%)
NE	1	1296.6 mi	1156.9 mi	1,157	$775	1 (100%)
FL	1	1139.8 mi	1137.7 mi	1,138	$762	1 (100%)
MN	3	380.4 mi	362.3 mi	1,087	$728	1 (33.3%)
GA	4	587.4 mi	239.4 mi	958	$642	1 (25%)
VA	2	439.6 mi	429.5 mi	859	$576	2 (100%)
SC	5	219.4 mi	150.2 mi	751	$503	1 (20%)
NC	2	395.6 mi	348.7 mi	697	$467	1 (50%)
KY	1	749.1 mi	693.3 mi	693	$464	1 (100%)
OH	3	261.7 mi	167.4 mi	502	$336	1 (33.3%)
MO	1	862.9 mi	351.4 mi	351	$235	1 (100%)
MT	1	867.1 mi	306.5 mi	307	$206	1 (100%)
OR	1	817.3 mi	260.3 mi	260	$174	1 (100%)
AR	5	111.6 mi	35.8 mi	179	$120	0 (0%)
NH	4	56.2 mi	43 mi	172	$115	1 (25%)
CT	1	95.9 mi	10.2 mi	10	$7	0 (0%)
IN	2	326.2 mi	0 mi	0	$0	0 (0%)
UT	14	0 mi	0 mi	0	$0	0 (0%)