Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
35
Total Travel Cost
$3,481
5,196 miles
Avoidable Cost
$641
957 excess miles
Optimal Cost
$2,840
If closest tech always used
Avg Excess / WO
27.4 mi
$18.33 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
28.6%
10 WOs

Actual Travel Expenses

From 19 WOs with expense data
Total Expenses
$6,480
Labor - Travel
$3,795
Mileage
$642
Lodging
$780
Airfare
$0
Car Rental
$0
Per Diem
$475
Meals
$0
Other
$788

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)
$6,480
19 WOs with expenses
Billed to Client
$3,929
60.6% recovery rate
Margin Gap (Unbilled)
$2,551
Cost absorbed internally
Avg Expense / WO
$341
Avg billed: $207
Internal Cost
$6,480
Billed
$3,929

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) 47 26 $3,795 $3,015 $780 79.4%
Other Expenses 19 13 $788 $639 $149 81.1%
Lodging 5 3 $780 $275 $505 35.2%
Mileage 12 2 $642 $0 $642 0%
Per Diem 13 11 $475 $0 $475 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 30 $6,480 $3,929 $2,551 60.6%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Installation 4 $4,768 $3,777 $991 79.2%
Preventive Maintenance 2 $970 $0 $970 0%
Repair 20 $644 $72 $572 11.1%
Parts Sale 1 $74 $81 $7 110%
Evaluation 3 $25 $0 $25 0%

Monthly Expense Trend — Internal Cost vs Billed