Travel & Margin Analysis

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

WOs Analyzed

450

Total Travel Cost

$113,993

170,139 miles

Avoidable Cost

$91,629

136,759 excess miles

Optimal Cost

$22,365

If closest tech always used

Avg Excess / WO

303.9 mi

$203.62 per WO

Median Excess

164.1 mi

Outlier Rate (>50mi)

66.9%

301 WOs

From 128 WOs with expense data

Total Expenses

$94,085

Labor - Travel

$65,780

Mileage

Lodging

$11,091

Airfare

$7,269

Car Rental

$2,005

Per Diem

$4,000

Meals

Other

$3,940

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
FCO	318	358.9 mi	114,134	$76,470
Project	128	176.8 mi	22,625	$15,159
Training/Other	4	0.0 mi	0	$0

Order Type	WOs	Avg Excess	Total Excess	Avoidable Cost
FCO P	178	506.2 mi	90,101	$60,368
Upgrade P	128	176.8 mi	22,625	$15,159
Preventive Maintenance P	104	177.5 mi	18,465	$12,372
Training P	14	163.0 mi	2,282	$1,529
Installation P	8	202.8 mi	1,622	$1,087
Repair R	9	96.0 mi	864	$579
PM P	3	266.4 mi	799	$535
New Hire Training 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)
FL	211	297.2 mi	277.1 mi	58,466	$39,172	151 (71.6%)
MO	17	1097.6 mi	830.2 mi	14,114	$9,456	17 (100%)
TN	22	435.2 mi	397.1 mi	8,736	$5,853	22 (100%)
GA	19	519.7 mi	413.5 mi	7,857	$5,264	13 (68.4%)
MS	8	1100.1 mi	945.8 mi	7,566	$5,069	8 (100%)
TX	4	1247.7 mi	1125.8 mi	4,503	$3,017	3 (75%)
OH	11	428.0 mi	366.9 mi	4,036	$2,704	10 (90.9%)
AL	5	838.8 mi	785.5 mi	3,927	$2,631	5 (100%)
KS	4	1145.0 mi	897.5 mi	3,590	$2,405	4 (100%)
ID	2	2153.6 mi	1424.3 mi	2,849	$1,909	2 (100%)
NC	10	350.1 mi	259.1 mi	2,591	$1,736	10 (100%)
PA	32	129.1 mi	79.8 mi	2,554	$1,711	15 (46.9%)
NV	3	2154.1 mi	631.2 mi	1,893	$1,268	3 (100%)
VA	8	294.2 mi	218.6 mi	1,749	$1,172	5 (62.5%)
NY	33	74.5 mi	49.0 mi	1,618	$1,084	3 (9.1%)
HI	1	4781.6 mi	1449.0 mi	1,449	$971	1 (100%)
MT	1	1897.3 mi	1387.2 mi	1,387	$929	1 (100%)
KY	4	415.2 mi	325.6 mi	1,302	$872	4 (100%)
OK	1	1354.6 mi	1258.0 mi	1,258	$843	1 (100%)
AR	1	1204.5 mi	1063.9 mi	1,064	$713	1 (100%)
NJ	10	110.3 mi	98.3 mi	983	$659	1 (10%)
CO	1	1679.7 mi	789.2 mi	789	$529	1 (100%)
MA	9	129.9 mi	82.6 mi	743	$498	6 (66.7%)
CT	12	103.4 mi	38.7 mi	464	$311	4 (33.3%)
NH	3	255.0 mi	124.4 mi	373	$250	3 (100%)
MD	6	71.3 mi	44.3 mi	266	$178	2 (33.3%)
DC	2	180.5 mi	128.9 mi	258	$173	2 (100%)
ME	4	193.2 mi	35.1 mi	141	$94	1 (25%)
IA	1	210.7 mi	135.7 mi	136	$91	1 (100%)
DE	2	82.8 mi	47.9 mi	96	$64	1 (50%)
Tx	1	13.9 mi	0.0 mi	0	$0	0 (0%)
IN	2	15.8 mi	0.0 mi	0	$0	0 (0%)