Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
17
Total Travel Cost
$2,511
3,748 miles
Avoidable Cost
$2,319
3,462 excess miles
Optimal Cost
$192
If closest tech always used
Avg Excess / WO
203.6 mi
$136.44 per WO
Median Excess
206.3 mi
Outlier Rate (>50mi)
100%
17 WOs

Actual Travel Expenses

From 4 WOs with expense data
Total Expenses
$2,021
Labor - Travel
$0
Mileage
$0
Lodging
$1,571
Airfare
$0
Car Rental
$0
Per Diem
$450
Meals
$0
Other
$0

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)
$2,021
4 WOs with expenses
Billed to Client
$1,800
89.1% recovery rate
Margin Gap (Unbilled)
$221
Cost absorbed internally
Avg Expense / WO
$505
Avg billed: $450
Internal Cost
$2,021
Billed
$1,800

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
Lodging 8 4 $1,571 $1,800 $229 ✓ 114.6%
Per Diem 10 4 $450 $0 $450 0%
Labor - Travel (Hours) 21 10 $0 $0 $0 ✓ 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Lab/Power 10 $2,021 $1,800 $221 89.1%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Preventive Maintenance 9 $1,520 $1,350 $170 88.8%
Repair 1 $501 $450 $51 89.8%

Monthly Expense Trend — Internal Cost vs Billed