Travel & Margin Analysis

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

Tech Placement Detail →

WOs Analyzed

Total Travel Cost

$3,377

5,040 miles

Avoidable Cost

$2,289

3,416 excess miles

Optimal Cost

$1,088

If closest tech always used

Avg Excess / WO

427.0 mi

$286.07 per WO

Median Excess

433.3 mi

Outlier Rate (>50mi)

100%

8 WOs

Actual Travel Expenses

From 4 WOs with expense data

Total Expenses

$1,862

Labor - Travel

$1,170

Mileage

Lodging

$260

Airfare

Car Rental

$234

Per Diem

$125

Meals

Other

$73

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

Billable vs Internal Cost — Margin Gap

Compares what was billed to clients against what we actually paid for travel expenses. The gap represents unbilled internal cost.

Internal Cost (What We Paid)

$1,862

4 WOs with expenses

Billed to Client

$803

43.1% recovery rate

Margin Gap (Unbilled)

$1,059

Cost absorbed internally

Avg Expense / WO

$465

Avg billed: $201

Internal Cost

$1,862

Billed

$803

Expense Breakdown by Category

Internal cost vs billed amount by expense type. Negative margin = we paid more than we billed.

Category	Lines	WOs	Internal Cost	Billed to Client	Margin Gap	Recovery %
Labor - Travel (Hours)	6	3	$1,170	$260	$910	22.2%
Lodging	1	1	$260	$260	$0 ✓	100%
Car Rental	4	1	$234	$234	$0 ✓	100%
Per Diem	3	1	$125	$0	$125	0%
Other Expenses	7	4	$73	$49	$24	67.5%

Expenses by Vertical

Vertical	WOs	Internal Cost	Billed	Gap	Recovery
Lab/Power	1	$1,554	$494	$1,060	31.8%
EMS	4	$308	$309	$1	100.5%

Expenses by Order Type

Order Type	WOs	Internal Cost	Billed	Gap	Recovery
PQ Only	1	$1,554	$494	$1,060	31.8%
Repair	4	$308	$309	$1	100.5%

Travel & Margin Analysis

Actual Travel Expenses

Billable vs Internal Cost — Margin Gap

Expense Breakdown by Category

Expenses by Vertical

Expenses by Order Type

Monthly Expense Trend — Internal Cost vs Billed