Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
41
Total Travel Cost
$5,292
7,899 miles
Avoidable Cost
$2,824
4,214 excess miles
Optimal Cost
$2,469
If closest tech always used
Avg Excess / WO
102.8 mi
$68.87 per WO
Median Excess
21.3 mi
Outlier Rate (>50mi)
31.7%
13 WOs

Actual Travel Expenses

From 25 WOs with expense data
Total Expenses
$4,603
Labor - Travel
$2,495
Mileage
$1,432
Lodging
$118
Airfare
$0
Car Rental
$0
Per Diem
$50
Meals
$0
Other
$509

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)
$4,603
25 WOs with expenses
Billed to Client
$2,207
48% recovery rate
Margin Gap (Unbilled)
$2,396
Cost absorbed internally
Avg Expense / WO
$184
Avg billed: $88
Internal Cost
$4,603
Billed
$2,207

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) 30 20 $2,495 $1,943 $553 77.9%
Mileage 13 3 $1,432 $0 $1,432 0%
Other Expenses 31 24 $509 $265 $244 52%
Lodging 2 2 $118 $0 $118 0%
Per Diem 1 1 $50 $0 $50 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 31 $4,603 $2,207 $2,396 48%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 25 $3,129 $2,207 $922 70.5%
Preventive Maintenance 3 $1,457 $0 $1,457 0%
Part Order 1 $18 $0 $18 0%
Evaluation 2 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed