Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
82
Total Travel Cost
$4,313
6,437 miles
Avoidable Cost
$2,000
2,985 excess miles
Optimal Cost
$2,313
If closest tech always used
Avg Excess / WO
36.4 mi
$24.39 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
7.3%
6 WOs

Actual Travel Expenses

From 45 WOs with expense data
Total Expenses
$15,922
Labor - Travel
$9,920
Mileage
$1,280
Lodging
$789
Airfare
$1,379
Car Rental
$270
Per Diem
$425
Meals
$0
Other
$1,859

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)
$15,922
45 WOs with expenses
Billed to Client
$12,460
78.3% recovery rate
Margin Gap (Unbilled)
$3,461
Cost absorbed internally
Avg Expense / WO
$354
Avg billed: $277
Internal Cost
$15,922
Billed
$12,460

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) 56 37 $9,920 $6,440 $3,480 64.9%
Other Expenses 36 24 $1,859 $822 $1,037 44.2%
Airfare 3 2 $1,379 $0 $1,379 0%
Mileage 38 16 $1,280 $4,923 $3,643 ✓ 384.7%
Lodging 2 2 $789 $275 $514 34.8%
Per Diem 10 3 $425 $0 $425 0%
Car Rental 4 2 $270 $0 $270 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
EMS 56 $15,922 $12,460 $3,461 78.3%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 27 $12,980 $6,887 $6,092 53.1%
Preventive Maintenance 27 $1,540 $5,183 $3,643 336.6%
Cross-Training 1 $1,012 $0 $1,012 0%
Evaluation 1 $390 $390 $0 100%

Monthly Expense Trend — Internal Cost vs Billed