Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
65
Total Travel Cost
$1,767
2,637 miles
Avoidable Cost
$200
299 excess miles
Optimal Cost
$1,583
If closest tech always used
Avg Excess / WO
4.2 mi
$2.82 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
0%
0 WOs

Actual Travel Expenses

From 54 WOs with expense data
Total Expenses
$13,036
Labor - Travel
$9,614
Mileage
$2,649
Lodging
$163
Airfare
$0
Car Rental
$0
Per Diem
$50
Meals
$0
Other
$560

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)
$13,036
54 WOs with expenses
Billed to Client
$7,791
59.8% recovery rate
Margin Gap (Unbilled)
$5,245
Cost absorbed internally
Avg Expense / WO
$241
Avg billed: $144
Internal Cost
$13,036
Billed
$7,791

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) 60 40 $9,614 $5,953 $3,662 61.9%
Mileage 20 10 $2,649 $1,390 $1,259 52.5%
Other Expenses 42 34 $560 $448 $111 80.1%
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 56 $13,036 $7,791 $5,245 59.8%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 36 $7,179 $5,231 $1,948 72.9%
Evaluation 10 $2,990 $1,170 $1,820 39.1%
Preventive Maintenance 9 $2,607 $1,130 $1,477 43.3%
Inspection 1 $260 $260 $0 100%

Monthly Expense Trend — Internal Cost vs Billed