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 |
|---|---|---|---|---|---|---|---|
| Lodging | 23 | 12 | $3,380 | $4,613 | $1,232 ✓ | 136.4% | |
| Per Diem | 59 | 39 | $2,275 | $0 | $2,275 | 0% | |
| Airfare | 2 | 2 | $1,699 | $1,331 | $368 | 78.3% | |
| Car Rental | 3 | 2 | $409 | $243 | $166 | 59.4% | |
| Labor - Travel (Hours) | 820 | 379 | $228 | $0 | $228 | 0% | |
| Other Expenses | 16 | 14 | $124 | $0 | $124 | 0% | |
| Mileage | 2 | 1 | $55 | $0 | $55 | 0% |
| Vertical | WOs | Internal Cost | Billed | Gap | Recovery |
|---|---|---|---|---|---|
| Lab/Power | 388 | $8,116 | $6,187 | $1,929 | 76.2% |
| EMS | 1 | $55 | $0 | $55 | 0% |
| Order Type | WOs | Internal Cost | Billed | Gap | Recovery |
|---|---|---|---|---|---|
| Preventive Maintenance | 260 | $2,873 | $2,025 | $848 | 70.5% |
| Repair | 58 | $2,366 | $2,165 | $200 | 91.5% |
| Training | 1 | $1,886 | $1,096 | $790 | 58.1% |
| Relocation | 2 | $731 | $900 | $169 | 123.2% |
| EOQ | 59 | $316 | $0 | $316 | 0% |
| Installation | 2 | $0 | $0 | $0 | 0% |
| EIQ | 1 | $0 | $0 | $0 | 0% |
| Calibration | 6 | $0 | $0 | $0 | 0% |