Travel & Margin Analysis

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

Tech Placement Detail →

WOs Analyzed

Total Travel Cost

$2,127

3,175 miles

Avoidable Cost

$987

1,473 excess miles

Optimal Cost

$1,140

If closest tech always used

Avg Excess / WO

92.0 mi

$61.66 per WO

Median Excess

0.0 mi

Outlier Rate (>50mi)

6.3%

1 WOs

Actual Travel Expenses

From 2 WOs with expense data

Total Expenses

$2,159

Labor - Travel

Mileage

Lodging

$118

Airfare

$833

Car Rental

$62

Per Diem

$75

Meals

Other

$1,071

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)

$2,159

2 WOs with expenses

Billed to Client

$903

41.8% recovery rate

Margin Gap (Unbilled)

$1,256

Cost absorbed internally

Avg Expense / WO

$1,079

Avg billed: $452

Internal Cost

$2,159

Billed

$903

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 %
Other Expenses	5	2	$1,071	$903	$168	84.3%
Airfare	1	1	$833	$0	$833	0%
Lodging	1	1	$118	$0	$118	0%
Per Diem	2	1	$75	$0	$75	0%
Car Rental	2	1	$62	$0	$62	0%
Labor - Travel (Hours)	11	8	$0	$0	$0 ✓	0%

Expenses by Vertical

Vertical	WOs	Internal Cost	Billed	Gap	Recovery
Lab/Power	9	$2,159	$903	$1,256	41.8%

Expenses by Order Type

Order Type	WOs	Internal Cost	Billed	Gap	Recovery
Preventive Maintenance	8	$1,256	$0	$1,256	0%
Acct. Management	1	$903	$903	$0	100%

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