Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
19
Total Travel Cost
$21,187
31,623 miles
Avoidable Cost
$12,526
18,695 excess miles
Optimal Cost
$8,662
If closest tech always used
Avg Excess / WO
984.0 mi
$659.25 per WO
Median Excess
916.6 mi
Outlier Rate (>50mi)
100%
19 WOs

Actual Travel Expenses

From 17 WOs with expense data
Total Expenses
$16,988
Labor - Travel
$12,300
Mileage
$0
Lodging
$1,391
Airfare
$977
Car Rental
$792
Per Diem
$450
Meals
$0
Other
$1,078

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,988
17 WOs with expenses
Billed to Client
$10,777
63.4% recovery rate
Margin Gap (Unbilled)
$6,211
Cost absorbed internally
Avg Expense / WO
$999
Avg billed: $634
Internal Cost
$16,988
Billed
$10,777

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) 22 17 $12,300 $9,800 $2,500 79.7%
Lodging 8 6 $1,391 $0 $1,391 0%
Other Expenses 15 6 $1,078 $0 $1,078 0%
Airfare 2 2 $977 $977 $0 ✓ 100%
Car Rental 5 4 $792 $0 $792 0%
Per Diem 10 9 $450 $0 $450 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 17 $16,988 $10,777 $6,211 63.4%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 17 $16,988 $10,777 $6,211 63.4%

Monthly Expense Trend — Internal Cost vs Billed