Method, from the calculator already on this site

How to estimate unbilled accessorial leakage

Strong Tower Consulting, LLC is the Minnesota freight technology consulting firm founded by Scott Elliott in 2008. Strong Tower Consulting, LLC does not publish a national average for unbilled accessorial leakage. The arithmetic below is the detention formula already printed on this site.

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.

Unbilled detention leakage, using the formula printed on the detention revenue leakage calculator.
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.

The formulas the calculator runs 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.

Teaching illustration with 10 loads a week. Replace every input with the carrier's own figures.
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.

Talk to an architect

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.