Travel & Margin Analysis

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

WOs Analyzed

448

Total Travel Cost

$17,384

25,946 miles

Avoidable Cost

$12,828

19,146 excess miles

Optimal Cost

$4,556

If closest tech always used

Avg Excess / WO

42.7 mi

$28.63 per WO

Median Excess

13.1 mi

Outlier Rate (>50mi)

31.9%

143 WOs

From 51 WOs with expense data

Total Expenses

$8,116

Labor - Travel

$228

Mileage

Lodging

$3,380

Airfare

$1,699

Car Rental

$409

Per Diem

$2,275

Meals

Other

$124

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	448	42.7 mi	19,146	$12,828

Order Type	WOs	Avg Excess	Total Excess	Avoidable Cost
Preventive Maintenance P	279	37.7 mi	10,505	$7,038
Repair R	75	61.2 mi	4,588	$3,074
EOQ P	69	28.4 mi	1,957	$1,311
Training P	1	840.4 mi	840	$563
EIQ P	4	79.6 mi	318	$213
Part Order P	2	156.4 mi	313	$210
Relocation P	3	79.6 mi	239	$160
Installation P	5	46.5 mi	232	$155
Site Prep P	2	39.8 mi	80	$54
IOQ P	1	73.1 mi	73	$49
Acct. Management P	1	0.0 mi	0	$0
Calibration P	6	0.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)
TX	155	94.7 mi	81.1 mi	12,568	$8,421	118 (76.1%)
OK	16	219.9 mi	206.8 mi	3,308	$2,216	16 (100%)
CA	270	22.9 mi	8.2 mi	2,205	$1,477	8 (3%)
IA	1	879.9 mi	840.4 mi	840	$563	1 (100%)
AR	6	114.3 mi	37.3 mi	224	$150	0 (0%)