Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
15
Total Travel Cost
$19,573
29,214 miles
Avoidable Cost
$16,854
25,155 excess miles
Optimal Cost
$2,720
If closest tech always used
Avg Excess / WO
1,677.0 mi
$1,123.58 per WO
Median Excess
1,600.8 mi
Outlier Rate (>50mi)
100%
15 WOs

Actual Travel Expenses

From 15 WOs with expense data
Total Expenses
$25,953
Labor - Travel
$17,110
Mileage
$0
Lodging
$2,855
Airfare
$2,762
Car Rental
$1,209
Per Diem
$950
Meals
$0
Other
$1,068

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)
$25,953
15 WOs with expenses
Billed to Client
$9,839
37.9% recovery rate
Margin Gap (Unbilled)
$16,114
Cost absorbed internally
Avg Expense / WO
$1,730
Avg billed: $656
Internal Cost
$25,953
Billed
$9,839

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) 48 15 $17,110 $7,078 $10,033 41.4%
Lodging 17 4 $2,855 $0 $2,855 0%
Airfare 6 5 $2,762 $2,762 $0 ✓ 100%
Car Rental 8 5 $1,209 $0 $1,209 0%
Other Expenses 13 6 $1,068 $0 $1,068 0%
Per Diem 21 5 $950 $0 $950 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 15 $25,953 $9,839 $16,114 37.9%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 13 $25,241 $9,127 $16,114 36.2%
Repair 2 $713 $713 $0 100%

Monthly Expense Trend — Internal Cost vs Billed