Travel & Margin Analysis

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

WOs Analyzed

146

Total Travel Cost

$16,385

24,456 miles

Avoidable Cost

$6,170

9,210 excess miles

Optimal Cost

$10,215

If closest tech always used

Avg Excess / WO

63.1 mi

$42.26 per WO

Median Excess

19.6 mi

Outlier Rate (>50mi)

21.2%

31 WOs

From 62 WOs with expense data

Total Expenses

$12,970

Labor - Travel

$5,952

Mileage

$1,925

Lodging

$2,916

Airfare

Car Rental

$162

Per Diem

$1,125

Meals

Other

$889

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
WV	Elkins	26241	4	585.6 mi	88.2 mi	88.2 mi	3	—	$1,333	$549	$3,139	Critical
WV	Charleston	25304	6	296.5 mi	146.8 mi	146.8 mi	3	—	$602	$1,240	$2,384	Elevated
WV	Madison	25130	4	191.2 mi	169.0 mi	169.0 mi	1	—	$60	$214	$1,025	Moderate
WV	Beckley	25801	5	185.6 mi	147.1 mi	165.2 mi	2	—	$68	$504	$1,244	Moderate
WV	Martinsburg	25401	4	185.1 mi	64.1 mi	64.4 mi	3	—	$324	$443	$992	Moderate
WV	HAMLIN	25523	3	173.6 mi	141.1 mi	141.1 mi	1	—	$65	$713	$698	Moderate
WV	Huntington	25701	6	171.4 mi	78.2 mi	153.7 mi	2	—	$71	$226	$1,378	Moderate
WV	Charleston	25309	7	170.7 mi	148.6 mi	148.6 mi	1	—	$103	$248	$1,601	Moderate
WV	Logan	25601	11	170.6 mi	146.7 mi	146.7 mi	3	—	$176	$431	$2,515	Moderate
WV	HUNTINGTON	25702	9	166.8 mi	147.2 mi	147.2 mi	1	—	$118	$5	$2,012	Moderate
WV	Buckannon	26201	3	142.1 mi	142.1 mi	142.1 mi	1	—	$0	$329	$571	Moderate
WV	Clarksburg	26301	4	102.6 mi	62.5 mi	92.0 mi	2	—	$29	$781	$550	Moderate