Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
144
Total Travel Cost
$10,455
15,605 miles
Avoidable Cost
$6,702
10,003 excess miles
Optimal Cost
$3,770
If closest tech always used
Avg Excess / WO
69.3 mi
$46.42 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
5.6%
8 WOs

Actual Travel Expenses

From 107 WOs with expense data
Total Expenses
$20,106
Labor - Travel
$16,791
Mileage
$2,223
Lodging
$163
Airfare
$0
Car Rental
$0
Per Diem
$50
Meals
$0
Other
$878

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)
$20,106
107 WOs with expenses
Billed to Client
$15,210
75.7% recovery rate
Margin Gap (Unbilled)
$4,895
Cost absorbed internally
Avg Expense / WO
$188
Avg billed: $142
Internal Cost
$20,106
Billed
$15,210

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) 113 72 $16,791 $11,508 $5,284 68.5%
Mileage 55 30 $2,223 $3,073 $849 ✓ 138.2%
Other Expenses 74 60 $878 $630 $248 71.8%
Lodging 1 1 $163 $0 $163 0%
Per Diem 1 1 $50 $0 $50 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 116 $20,106 $15,210 $4,895 75.7%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 62 $13,175 $10,110 $3,064 76.7%
Evaluation 15 $4,304 $2,028 $2,277 47.1%
Preventive Maintenance 32 $2,389 $2,813 $423 117.7%
Inspection 4 $211 $260 $49 123.2%
Upgrade 2 $21 $0 $21 0%
Calibration 1 $6 $0 $6 0%

Monthly Expense Trend — Internal Cost vs Billed