Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
111
Total Travel Cost
$4,906
7,322 miles
Avoidable Cost
$4,041
6,031 excess miles
Optimal Cost
$865
If closest tech always used
Avg Excess / WO
54.3 mi
$36.40 per WO
Median Excess
23.2 mi
Outlier Rate (>50mi)
27%
30 WOs

Actual Travel Expenses

From 72 WOs with expense data
Total Expenses
$16,871
Labor - Travel
$15,716
Mileage
$0
Lodging
$234
Airfare
$0
Car Rental
$0
Per Diem
$175
Meals
$0
Other
$746

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)
$16,871
72 WOs with expenses
Billed to Client
$8,625
51.1% recovery rate
Margin Gap (Unbilled)
$8,246
Cost absorbed internally
Avg Expense / WO
$234
Avg billed: $120
Internal Cost
$16,871
Billed
$8,625

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 % Gap Distribution
Labor - Travel (Hours) 88 58 $15,716 $8,625 $7,091 54.9%
Other Expenses 45 22 $746 $0 $746 0%
Lodging 2 1 $234 $0 $234 0%
Per Diem 4 3 $175 $0 $175 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 73 $16,871 $8,625 $8,246 51.1%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 50 $11,693 $7,075 $4,618 60.5%
FCO 15 $3,129 $620 $2,509 19.8%
Preventive Maintenance 6 $1,976 $930 $1,046 47.1%
Installation 2 $73 $0 $73 0%

Monthly Expense Trend — Internal Cost vs Billed