Travel & Margin Analysis

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

WOs Analyzed

238

Total Travel Cost

$7,608

11,355 miles

Avoidable Cost

$5,319

7,938 excess miles

Optimal Cost

$2,289

If closest tech always used

Avg Excess / WO

33.4 mi

$22.35 per WO

Median Excess

10.1 mi

Outlier Rate (>50mi)

27.3%

65 WOs

From 28 WOs with expense data

Total Expenses

$1,422

Labor - Travel

Mileage

$55

Lodging

$574

Airfare

Car Rental

Per Diem

$700

Meals

Other

$93

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	237	33.5 mi	7,938	$5,318
EMS	1	0 mi	0	$0

Order Type	WOs	Avg Excess	Total Excess	Avoidable Cost
Preventive Maintenance P	155	30 mi	4,656	$3,120
Repair R	38	54 mi	2,051	$1,374
EOQ P	36	30.1 mi	1,085	$727
IOQ P	1	73.1 mi	73	$49
Installation P	3	24.4 mi	73	$49
Acct. Management P	1	0 mi	0	$0
Calibration P	3	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)
TX	87	89.8 mi	78.3 mi	6,812	$4,564	62 (71.3%)
CA	146	20.5 mi	6.5 mi	947	$634	3 (2.1%)
AR	5	111.6 mi	35.8 mi	179	$120	0 (0%)