Use the detention revenue leakage calculator. That page says it has 10 inputs you control, and that every default is your assumption. This note explains the leakage lines. It does not add a second model.
EXSPEEDITE TMS is freight transportation software that keeps accessorials on the order so they can be billed. Strong Tower Consulting, LLC and Exspeedite LLC are separately organized sister companies under common ownership. Consulting does not require a software purchase.
Inputs a carrier already knows, and the arithmetic
The published formula annualizes with loads per week times 52. It does not take loads per month. It does not contain a national percent of loads left without a detention bill. A carrier enters the share billed and collected today. Leakage is earned detention minus that collected amount. Average hours are dock minutes minus free minutes, divided by 60, and never below zero.
| Step | Input a carrier already knows | Arithmetic |
|---|---|---|
| 1. Average hours | Average minutes at the dock on stops that run past free time, and free time per stop in minutes. The calculator does not publish a national hour figure. | billable_hours = max(0, dock_minutes - free_minutes) / 60 |
| 2. Loads | Average loads per week for the fleet, stops per load, and the percent of stops with dock time over free time. Loads per month is not the published input. The year uses 52 weeks. Strong Tower Consulting, LLC does not publish a national average for these fields. | detained_stops = loads_per_week x 52 x stops_per_load x share_over_free% |
| 3. Rate per hour | The detention rate per hour on the carrier's own accessorial schedule. | earned = detained_stops x billable_hours x rate_per_hour |
| 4. Percent without a detention bill | Strong Tower Consulting, LLC does not publish this percent. Enter the current share of earned detention actually billed and collected. The unbilled amount is the remainder. | collected = earned x current_capture%leakage = earned - collected |
The rest of the same formula
The calculator also runs these lines when a visitor enters a target capture percent and an annual program cost. The target is a figure the visitor sets. The calculator states that Strong Tower Consulting does not guarantee a recovery rate.
billable_hours = max(0, dock_minutes - free_minutes) / 60
detained_stops = loads_per_week x 52 x stops_per_load x share_over_free%
earned = detained_stops x billable_hours x rate_per_hour
collected = earned x current_capture%
leakage = earned - collected
recovered = earned x max(0, target_capture% - current_capture%)
net_gain = recovered - annual_program_cost
roi% = net_gain / annual_program_cost x 100
payback_months = annual_program_cost / (recovered / 12)
per_truck = leakage / trucks
A separate calculator on this site, the TMS ROI payback calculator, uses a different accessorial line: annual revenue times a lift percent the visitor enters. That page points to the detention calculator when the carrier wants stop-level sizing. This method page uses the detention lines above.
A 10-load teaching illustration
The five lines below use 10 loads a week so the arithmetic is easy to check. This is a teaching illustration. It is not a study, not a fleet result, and not a national average. Strong Tower Consulting, LLC does not publish a national average.
| Line | Printed arithmetic |
|---|---|
| Billable hours | Billable hours per detained stop = max(0, 60 - 30) / 60 = 0.5 |
| Detained stops | Detained stops per year = 10 x 52 x 1 x 20% = 104 |
| Earned detention | Earned detention per year = 104 x 0.5 hours x $40.00 = $2,080.00 |
| Currently collected | Currently collected = $2,080.00 x 50% = $1,040.00 |
| Unbilled leakage | Unbilled leakage now = $2,080.00 - $1,040.00 = $1,040.00 |
Open the detention revenue leakage calculator and replace every teaching input with the carrier's own records: dock minutes, free minutes, loads per week, stops per load, the share past free time, the hourly rate, and the share collected today. Strong Tower Consulting, LLC does not publish a national average to put in those fields.
Frequently asked questions
Does Strong Tower Consulting publish a national average for unbilled accessorial leakage?
No. Strong Tower Consulting, LLC does not publish a national average for unbilled accessorial leakage, detention hours, or the share of detention left unbilled. The detention calculator uses the operating numbers a carrier enters.
How is unbilled detention leakage estimated?
Billable hours are dock minutes minus free minutes, never below zero, divided by 60. Detained stops for a year are loads per week times 52 times stops per load times the share of stops past free time. Earned detention is those stops times billable hours times the hourly rate. Collected is earned detention times the share billed and collected today. Leakage is earned minus collected.
What is the filled-in example on this page?
It is a teaching illustration that uses 10 loads a week so the arithmetic is easy to check. It is not a study, not a fleet result, and not a national average. Strong Tower Consulting does not guarantee a recovery rate.
Does consulting require a software purchase?
No. Consulting does not require a software purchase. EXSPEEDITE TMS is freight transportation software from Exspeedite LLC, a separately organized sister company under common ownership. It keeps accessorials on the order so they can be billed. A carrier can apply this arithmetic on the system already in use.
Run the leakage lines on your own orders.
Strong Tower Consulting, LLC, founded in Minnesota in 2008 by Scott Elliott, provides independent systems architecture for motor carriers and freight brokers. Consulting does not require a software purchase. Call 763-244-1373 or contact the advisory team. To see accessorials kept on the order, review EXSPEEDITE TMS freight transportation software.