Travel & Margin Analysis

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

WOs Analyzed

190

Total Travel Cost

$21,909

32,700 miles

Avoidable Cost

$21,175

31,604 excess miles

Optimal Cost

$734

If closest tech always used

Avg Excess / WO

166.3 mi

$111.45 per WO

Median Excess

4.3 mi

Outlier Rate (>50mi)

41.6%

79 WOs

From 1 WOs with expense data

Total Expenses

$230

Labor - Travel

Mileage

Lodging

$175

Airfare

Car Rental

Per Diem

$50

Meals

Other

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	190	166.3 mi	31,604	$21,175

Order Type	WOs	Avg Excess	Total Excess	Avoidable Cost
PM/CAL P	71	356.8 mi	25,334	$16,974
Overhaul P	3	1425.6 mi	4,277	$2,866
Repair R	91	17.2 mi	1,564	$1,048
Preventive Maintenance P	14	20.9 mi	292	$196
EOQ P	4	29.2 mi	117	$78
Acct. Management P	2	10.2 mi	20	$13
Calibration P	3	0 mi	0	$0
Cross-Training P	1	0 mi	0	$0
Repair/PM R	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%)
CA	16	176.1 mi	163.5 mi	2,616	$1,753	1 (6.3%)
CO	1	1744.8 mi	1729.3 mi	1,729	$1,158	1 (100%)
AL	1	974.6 mi	942.1 mi	942	$631	1 (100%)
TX	8	80.5 mi	70.2 mi	561	$376	5 (62.5%)
MA	89	4.9 mi	4.7 mi	421	$282	0 (0%)
GA	1	201.4 mi	0 mi	0	$0	0 (0%)
NC	1	61.2 mi	0 mi	0	$0	0 (0%)
OH	1	96.3 mi	0 mi	0	$0	0 (0%)
UT	1	0 mi	0 mi	0	$0	0 (0%)