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
$4,462
6,660 miles
Avoidable Cost
$282
421 excess miles
Optimal Cost
$4,180
If closest tech always used
Avg Excess / WO
9.6 mi
$6.41 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
6.8%
3 WOs

Actual Travel Expenses

From 33 WOs with expense data
Total Expenses
$23,440
Labor - Travel
$14,320
Mileage
$2,620
Lodging
$1,237
Airfare
$1,823
Car Rental
$682
Per Diem
$675
Meals
$0
Other
$2,083

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)
$23,440
33 WOs with expenses
Billed to Client
$11,349
48.4% recovery rate
Margin Gap (Unbilled)
$12,092
Cost absorbed internally
Avg Expense / WO
$710
Avg billed: $344
Internal Cost
$23,440
Billed
$11,349

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) 58 23 $14,320 $7,720 $6,600 53.9%
Mileage 22 8 $2,620 $2,145 $475 81.9%
Other Expenses 44 23 $2,083 $805 $1,279 38.6%
Airfare 5 5 $1,823 $0 $1,823 0%
Lodging 5 4 $1,237 $554 $683 44.8%
Car Rental 9 5 $682 $0 $682 0%
Per Diem 16 6 $675 $125 $550 18.5%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 36 $23,440 $11,349 $12,092 48.4%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 23 $16,163 $8,040 $8,123 49.7%
Preventive Maintenance 13 $7,278 $3,309 $3,969 45.5%

Monthly Expense Trend — Internal Cost vs Billed