Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
145
Total Travel Cost
$5,241
7,822 miles
Avoidable Cost
$2,416
3,606 excess miles
Optimal Cost
$2,825
If closest tech always used
Avg Excess / WO
24.9 mi
$16.66 per WO
Median Excess
4.3 mi
Outlier Rate (>50mi)
9.7%
14 WOs

Actual Travel Expenses

From 101 WOs with expense data
Total Expenses
$27,530
Labor - Travel
$26,091
Mileage
$0
Lodging
$539
Airfare
$0
Car Rental
$0
Per Diem
$700
Meals
$0
Other
$199

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)
$27,530
101 WOs with expenses
Billed to Client
$10,931
39.7% recovery rate
Margin Gap (Unbilled)
$16,599
Cost absorbed internally
Avg Expense / WO
$273
Avg billed: $108
Internal Cost
$27,530
Billed
$10,931

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) 174 98 $26,091 $10,231 $15,861 39.2%
Per Diem 17 9 $700 $25 $675 3.6%
Lodging 1 1 $539 $539 $0 ✓ 100%
Other Expenses 12 10 $199 $136 $63 68.3%
Airfare 1 1 $0 $0 $0 ✓ 0%
Car Rental 1 1 $0 $0 $0 ✓ 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 102 $27,530 $10,931 $16,599 39.7%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 72 $20,485 $7,072 $13,413 34.5%
Misc. Inspection 14 $2,466 $1,910 $556 77.4%
Cross-Training 3 $2,089 $1,664 $425 79.7%
Delivery 5 $747 $0 $747 0%
Inspection 4 $734 $0 $734 0%
Preventive Maintenance 2 $500 $0 $500 0%
Installation 1 $447 $224 $224 50%
Calibration 1 $61 $61 $0 100%

Monthly Expense Trend — Internal Cost vs Billed