Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
152
Total Travel Cost
$4,152
6,197 miles
Avoidable Cost
$2,278
3,400 excess miles
Optimal Cost
$1,873
If closest tech always used
Avg Excess / WO
22.4 mi
$14.99 per WO
Median Excess
17.3 mi
Outlier Rate (>50mi)
5.9%
9 WOs

Actual Travel Expenses

From 105 WOs with expense data
Total Expenses
$36,894
Labor - Travel
$33,627
Mileage
$0
Lodging
$306
Airfare
$0
Car Rental
$2,589
Per Diem
$0
Meals
$0
Other
$372

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)
$36,894
105 WOs with expenses
Billed to Client
$10,108
27.4% recovery rate
Margin Gap (Unbilled)
$26,786
Cost absorbed internally
Avg Expense / WO
$351
Avg billed: $96
Internal Cost
$36,894
Billed
$10,108

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) 232 99 $33,627 $9,955 $23,672 29.6%
Car Rental 29 8 $2,589 $0 $2,589 0%
Other Expenses 31 27 $372 $153 $220 41%
Lodging 1 1 $306 $0 $306 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 107 $36,894 $10,108 $26,786 27.4%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 56 $20,256 $5,693 $14,562 28.1%
Cross-Training 13 $8,673 $0 $8,673 0%
Misc. Inspection 17 $3,186 $3,127 $60 98.1%
Inspection 11 $2,370 $0 $2,370 0%
Evaluation 3 $1,138 $902 $236 79.3%
Preventive Maintenance 4 $853 $385 $468 45.2%
Installation 2 $309 $0 $309 0%
Delivery 1 $110 $0 $110 0%

Monthly Expense Trend — Internal Cost vs Billed