Travel & Margin Analysis

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

WOs Analyzed

185

Total Travel Cost

$26,860

40,089 miles

Avoidable Cost

$18,558

27,698 excess miles

Optimal Cost

$8,302

If closest tech always used

Avg Excess / WO

149.7 mi

$100.31 per WO

Median Excess

13.9 mi

Outlier Rate (>50mi)

28.1%

52 WOs

From 108 WOs with expense data

Total Expenses

$54,091

Labor - Travel

$40,288

Mileage

$963

Lodging

$3,823

Airfare

$3,443

Car Rental

$1,813

Per Diem

$1,450

Meals

Other

$2,312

Cost Overview Actual Expenses Cost Breakdowns Coordinator Analysis Tech Utilization Quick Wins Coverage Gaps Low Hanging Fruit

Coverage Gap Map

Circle size = WO count. Color = severity (red=critical, orange=high, yellow=elevated, blue=moderate). Click a marker to see details.

Cities with 3+ WOs and >100mi avg actual distance. Click a city to see WO-level breakdown. Click any column header to sort.

State	City	Zip	WOs	Avg Actual Dist	Closest Tech Dist (Min)	Avg Closest Dist	Unique Techs Sent	Flew	Avoidable Cost	Actual Expense	Est. Annual Cost	Severity
MO	SPRINGFIELD	65802	3	1065.7 mi	273.2 mi	273.7 mi	2	—	$1,592	—	$4,284	Critical
MO	KANSAS CITY	64128	4	927.0 mi	21.2 mi	232.6 mi	2	—	$1,861	—	$4,969	Critical
MO	SPRINGFIELD	65807	5	891.3 mi	143.7 mi	247.1 mi	2	—	$2,158	$630	$5,972	Critical
MO	Wildwood	63040	4	661.3 mi	4.3 mi	100.5 mi	1	✈ 1 /3	$1,503	$4,443	$3,545	Critical
MO	Poplar Bluff	63901	11	528.5 mi	112.8 mi	162.0 mi	4	✈ 2 /9	$2,701	$19,282	$7,790	Critical
MO	Saint Joseph	64506	3	231.0 mi	49.9 mi	55.0 mi	3	✈ 1 /2	$354	$3,258	$929	Elevated
MO	St. Louis	63103	4	159.1 mi	19.1 mi	19.4 mi	3	—	$375	$176	$853	Moderate
MO	KANSAS CITY	64153	3	152.1 mi	27.8 mi	28.9 mi	2	—	$248	$1,527	$611	Moderate
MO	Kansas City	64114	3	141.3 mi	14.8 mi	14.8 mi	2	—	$255	$1,255	$568	Moderate
MO	SEDALIA	65301	3	125.7 mi	87.5 mi	87.5 mi	2	—	$77	$1,371	$505	Moderate
MO	HOUSTON	65483	6	116.6 mi	100.1 mi	100.1 mi	1	—	$66	—	$937	Moderate