Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
240
Total Travel Cost
$16,075
23,992 miles
Avoidable Cost
$13,503
20,154 excess miles
Optimal Cost
$2,572
If closest tech always used
Avg Excess / WO
84.0 mi
$56.26 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
7.5%
18 WOs

Actual Travel Expenses

From 168 WOs with expense data
Total Expenses
$16,806
Labor - Travel
$10,053
Mileage
$4,678
Lodging
$0
Airfare
$0
Car Rental
$0
Per Diem
$25
Meals
$0
Other
$2,049

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)
$16,806
168 WOs with expenses
Billed to Client
$12,997
77.3% recovery rate
Margin Gap (Unbilled)
$3,809
Cost absorbed internally
Avg Expense / WO
$100
Avg billed: $77
Internal Cost
$16,806
Billed
$12,997

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) 136 98 $10,054 $8,338 $1,716 82.9%
Mileage 184 51 $4,678 $3,938 $741 84.2%
Other Expenses 156 119 $2,049 $722 $1,327 35.2%
Per Diem 1 1 $25 $0 $25 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 183 $16,806 $12,997 $3,809 77.3%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 115 $10,939 $8,182 $2,757 74.8%
Preventive Maintenance 55 $5,043 $4,263 $781 84.5%
Evaluation 13 $824 $553 $271 67.1%

Monthly Expense Trend — Internal Cost vs Billed