Quantify excess travel cost and identify optimization opportunities across your field service operation
Compares what was billed to clients against what we actually paid for travel expenses. The gap represents unbilled internal cost.
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) | 263 | 115 | $40,288 | $9,752 | $30,536 | 24.2% | |
| Lodging | 21 | 7 | $3,823 | $1,111 | $2,712 | 29.1% | |
| Airfare | 6 | 5 | $3,443 | $2,796 | $647 | 81.2% | |
| Other Expenses | 52 | 28 | $2,312 | $775 | $1,538 | 33.5% | |
| Car Rental | 13 | 5 | $1,813 | $455 | $1,358 | 25.1% | |
| Per Diem | 32 | 9 | $1,450 | $100 | $1,350 | 6.9% | |
| Mileage | 28 | 11 | $963 | $1,975 | $1,012 ✓ | 205.1% |
| Vertical | WOs | Internal Cost | Billed | Gap | Recovery |
|---|---|---|---|---|---|
| FCO | 13 | $24,104 | $9,125 | $14,979 | 37.9% |
| Healthcare Provider | 76 | $22,697 | $2,343 | $20,354 | 10.3% |
| EMS | 17 | $2,747 | $2,913 | $166 | 106.1% |
| Animal Health | 4 | $1,732 | $1,357 | $375 | 78.3% |
| Installation | 1 | $1,277 | $0 | $1,277 | 0% |
| Lab/Power | 1 | $1,119 | $1,119 | $0 | 100% |
| Kiosk | 17 | $382 | $106 | $276 | 27.8% |
| Bed Services | 1 | $35 | $0 | $35 | 0% |
| Order Type | WOs | Internal Cost | Billed | Gap | Recovery |
|---|---|---|---|---|---|
| Repair | 62 | $19,994 | $3,975 | $16,018 | 19.9% |
| FCO | 5 | $19,281 | $4,434 | $14,847 | 23% |
| Preventive Maintenance | 47 | $9,763 | $6,838 | $2,925 | 70% |
| Installation | 3 | $1,594 | $0 | $1,594 | 0% |
| Inspection | 4 | $1,565 | $245 | $1,320 | 15.7% |
| Repair/PM | 2 | $1,151 | $1,119 | $33 | 97.2% |
| Delivery | 2 | $248 | $0 | $248 | 0% |
| Misc. Inspection | 1 | $245 | $245 | $0 | 100% |
| Connectivity | 2 | $154 | $0 | $154 | 0% |
| Removal | 1 | $96 | $106 | $10 | 110% |
| Upgrade | 1 | $0 | $0 | $0 | 0% |