Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
9
Total Travel Cost
$29,243
43,646 miles
Avoidable Cost
$9,742
14,540 excess miles
Optimal Cost
$19,501
If closest tech always used
Avg Excess / WO
1,615.5 mi
$1,082.41 per WO
Median Excess
1,449.0 mi
Outlier Rate (>50mi)
100%
9 WOs

Actual Travel Expenses

From 6 WOs with expense data
Total Expenses
$15,656
Labor - Travel
$10,500
Mileage
$0
Lodging
$1,602
Airfare
$1,560
Car Rental
$644
Per Diem
$300
Meals
$0
Other
$1,050

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)
$15,656
6 WOs with expenses
Billed to Client
$4,160
26.6% recovery rate
Margin Gap (Unbilled)
$11,495
Cost absorbed internally
Avg Expense / WO
$2,609
Avg billed: $693
Internal Cost
$15,656
Billed
$4,160

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) 13 6 $10,500 $2,600 $7,900 24.8%
Lodging 6 3 $1,602 $0 $1,602 0%
Airfare 3 3 $1,560 $1,560 $0 ✓ 100%
Other Expenses 12 3 $1,050 $0 $1,050 0%
Car Rental 3 3 $644 $0 $644 0%
Per Diem 6 2 $300 $0 $300 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 6 $15,656 $4,160 $11,495 26.6%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 6 $15,656 $4,160 $11,495 26.6%

Monthly Expense Trend — Internal Cost vs Billed