DataBrosFTW.
Sample — illustrative numbers

The Monday Ops Sheet

Week of Aug 10–16 · prepared for the owner of a ~$17M intermodal drayage carrier (fictional). Built from the TMS, the drivers' daily paperwork, and QuickBooks. On your desk Monday at 6:30am — nobody keys it in.

Three things that need you this week

Send the drafted detention invoices — $6,800 was earned and never billed.Serious · $6,800

Three customers, clock data attached, invoices already drafted — they go out on your OK.

Have dispatch chase the 7 missing PODs — $4,100 of delivered freight can't invoice without them.Watch · $4,100

The sheet names the drivers so dispatch chases people, not paper. Auto-chase texts went out Sunday night.

Approve Tuesday's street-turn matches — import-pool chassis dwell hit 2.8 days.Watch · ~$2,700

Each match avoids a per-diem day; ~0.8 extra days across 112 import loads runs roughly $2,700 a week at typical per-diem.

The week in four numbers — with the eight weeks behind them
412▲ 2% loads delivered 8-wk loads
$198,700▲ 4% linehaul + accessorial revenue 8-wk revenue
$482▲ $11 revenue per load, all lanes 8-wk rev/load
94%▼ 3 pts driver paperwork complete (388 of 412 loads) 8-wk % complete — slipping
By customer — loads, revenue, and where boxes sit
Customer / laneLoadsRevenueChassis dwell 2.0-day targetNote
Rail ramp – DIA corridor148$71,900
1.9d
on plan
Steamship import pool112$52,300
2.8d
see item 3 above
Regional grocery DC88$46,200
1.2d
steady
Spot / other64$28,300 spot rate up $22 week over week
Driver paperwork — the daily tickets, rolled up instead of piled up
ExceptionCountStatus
Delivery tickets missing95 drivers — auto-chase texts went out Sunday night
Inspection reports late8two drivers account for 6 of the 8
POD not imaged7blocks $4,100 of invoicing — see item 2 above
Revenue — $198,700 by customer
$71,900RAIL–DIA
$52,300IMPORT POOL
$46,200GROCERY DC
$28,300SPOT
  • Import pool carries the dwell problem — amber above (item 3).
  • Spot rate up $22 week over week on 64 loads.
  • $6,800 of earned detention still unbilled (item 1).
Paperwork — 412 loads
388 clean · dark24 exceptions · amber

7 of the 24 are missing PODs — $4,100 of delivered freight can't invoice until they're imaged (item 2). The rest are missing tickets and late inspections, already in the auto-chase.