Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
216
Total Travel Cost
$15,149
22,611 miles
Avoidable Cost
$9,504
14,184 excess miles
Optimal Cost
$5,646
If closest tech always used
Avg Excess / WO
65.7 mi
$44.00 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
26.4%
57 WOs

Actual Travel Expenses

From 101 WOs with expense data
Total Expenses
$18,469
Labor - Travel
$14,183
Mileage
$0
Lodging
$735
Airfare
$0
Car Rental
$0
Per Diem
$225
Meals
$0
Other
$3,326

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)
$18,469
101 WOs with expenses
Billed to Client
$12,692
68.7% recovery rate
Margin Gap (Unbilled)
$5,776
Cost absorbed internally
Avg Expense / WO
$183
Avg billed: $126
Internal Cost
$18,469
Billed
$12,692

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) 66 44 $14,183 $12,090 $2,093 85.2%
Other Expenses 118 80 $3,326 $18 $3,308 0.5%
Lodging 5 3 $735 $584 $150 79.5%
Per Diem 8 8 $225 $0 $225 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
FCO 117 $18,469 $12,692 $5,776 68.7%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
FCO 84 $13,997 $9,729 $4,268 69.5%
Preventive Maintenance 26 $4,018 $2,635 $1,383 65.6%
Repair 2 $310 $310 $0 100%
Installation 5 $144 $18 $126 12.5%

Monthly Expense Trend — Internal Cost vs Billed