Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
103
Total Travel Cost
$6,796
10,144 miles
Avoidable Cost
$3,332
4,973 excess miles
Optimal Cost
$3,464
If closest tech always used
Avg Excess / WO
48.3 mi
$32.35 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
6.8%
7 WOs

Actual Travel Expenses

From 78 WOs with expense data
Total Expenses
$15,363
Labor - Travel
$12,818
Mileage
$1,191
Lodging
$118
Airfare
$0
Car Rental
$0
Per Diem
$50
Meals
$0
Other
$1,187

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,363
78 WOs with expenses
Billed to Client
$9,104
59.3% recovery rate
Margin Gap (Unbilled)
$6,259
Cost absorbed internally
Avg Expense / WO
$197
Avg billed: $117
Internal Cost
$15,363
Billed
$9,104

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) 103 59 $12,818 $8,043 $4,775 62.7%
Mileage 23 9 $1,191 $260 $931 21.8%
Other Expenses 89 66 $1,187 $801 $386 67.5%
Lodging 1 1 $118 $0 $118 0%
Per Diem 1 1 $50 $0 $50 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 84 $15,363 $9,104 $6,259 59.3%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 52 $8,041 $4,852 $3,189 60.3%
Preventive Maintenance 23 $4,714 $2,635 $2,079 55.9%
Evaluation 7 $2,271 $1,357 $914 59.7%
Inspection 1 $266 $260 $6 97.7%
Warranty 1 $71 $0 $71 0%

Monthly Expense Trend — Internal Cost vs Billed