Travel & Margin Analysis

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

Tech Placement Detail →
WOs Analyzed
102
Total Travel Cost
$2,380
3,553 miles
Avoidable Cost
$593
886 excess miles
Optimal Cost
$1,787
If closest tech always used
Avg Excess / WO
8.7 mi
$5.82 per WO
Median Excess
0.0 mi
Outlier Rate (>50mi)
2.9%
3 WOs

Actual Travel Expenses

From 57 WOs with expense data
Total Expenses
$19,229
Labor - Travel
$16,936
Mileage
$0
Lodging
$762
Airfare
$584
Car Rental
$323
Per Diem
$300
Meals
$0
Other
$325

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)
$19,229
57 WOs with expenses
Billed to Client
$13,913
72.4% recovery rate
Margin Gap (Unbilled)
$5,317
Cost absorbed internally
Avg Expense / WO
$337
Avg billed: $244
Internal Cost
$19,229
Billed
$13,913

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) 91 55 $16,936 $13,806 $3,130 81.5%
Lodging 3 3 $762 $0 $762 0%
Airfare 1 1 $584 $0 $584 0%
Other Expenses 14 10 $325 $107 $218 32.9%
Car Rental 5 2 $323 $0 $323 0%
Per Diem 7 3 $300 $0 $300 0%

Expenses by Vertical

Vertical WOs Internal Cost Billed Gap Recovery
Healthcare Provider 58 $19,229 $13,913 $5,317 72.4%

Expenses by Order Type

Order Type WOs Internal Cost Billed Gap Recovery
Repair 24 $12,209 $9,445 $2,764 77.4%
Misc. Inspection 19 $2,981 $2,177 $804 73%
Inspection 5 $1,529 $149 $1,380 9.7%
Delivery 2 $825 $605 $220 73.3%
Installation 1 $688 $688 $0 100%
Evaluation 3 $522 $373 $149 71.4%
Calibration 2 $357 $357 $0 100%
SWAPOUT 1 $119 $119 $0 100%
Support 1 $0 $0 $0 0%

Monthly Expense Trend — Internal Cost vs Billed