Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
44
Total Travel Cost
$2,824
4,214 miles
Avoidable Cost
$1,160
1,731 excess miles
Optimal Cost
$1,664
If closest tech always used
Avg Excess / WO
39.4 mi
$26.37 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
29.5%
13 WOs

Actual Travel Expenses

From 37 WOs with expense data
Total Expenses
$15,770
Labor - Travel
$15,143
Mileage
$198
Lodging
$130
Airfare
$0
Car Rental
$0
Per Diem
$275
Meals
$0
Other
$24

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,770
37 WOs with expenses
Billed to Client
$4,447
28.2% recovery rate
Margin Gap (Unbilled)
$11,323
Cost absorbed internally
Avg Expense / WO
$426
Avg billed: $120
Internal Cost
$15,770
Billed
$4,447

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) 82 32 $15,143 $4,317 $10,826 28.5%
Per Diem 9 9 $275 $0 $275 0%
Mileage 2 1 $198 $0 $198 0%
Lodging 1 1 $130 $130 $0 ✓ 100%
Other Expenses 3 3 $24 $0 $24 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 38 $15,770 $4,447 $11,323 28.2%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 21 $9,550 $357 $9,193 3.7%
Delivery 6 $4,010 $3,457 $553 86.2%
Preventive Maintenance 3 $1,207 $0 $1,207 0%
Installation 2 $853 $633 $220 74.2%
Inspection 5 $150 $0 $150 0%
Evaluation 1 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed