Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
7
Total Travel Cost
$1,836
2,741 miles
Avoidable Cost
$0
0 excess miles
Optimal Cost
$1,836
If closest tech always used
Avg Excess / WO
0.0 mi
$0.00 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
0%
0 WOs

Actual Travel Expenses

From 6 WOs with expense data
Total Expenses
$6,975
Labor - Travel
$3,900
Mileage
$0
Lodging
$921
Airfare
$639
Car Rental
$446
Per Diem
$350
Meals
$0
Other
$719

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)
$6,975
6 WOs with expenses
Billed to Client
$4,286
61.4% recovery rate
Margin Gap (Unbilled)
$2,689
Cost absorbed internally
Avg Expense / WO
$1,163
Avg billed: $714
Internal Cost
$6,975
Billed
$4,286

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) 22 4 $3,900 $3,510 $390 90%
Lodging 4 3 $921 $554 $367 60.1%
Other Expenses 19 6 $719 $97 $622 13.5%
Airfare 3 3 $639 $0 $639 0%
Car Rental 6 3 $446 $0 $446 0%
Per Diem 8 3 $350 $125 $225 35.7%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 6 $6,975 $4,286 $2,689 61.4%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 5 $6,278 $3,882 $2,396 61.8%
Preventive Maintenance 1 $697 $404 $293 57.9%

Monthly Expense Trend — Internal Cost vs Billed