The Trucking Rate Calculator Supply “weak” Market Strategy example

The green highlighted sections are not normally green on the calculator, these represent areas of spending that have either been eliminated all together or reduced.

	Trucking Calculator		www.therealdealtrucking.com				The Trucking Calculator
ENTER FIXED EXPENSE AMOUNTS AND WHAT FOR IN THIS SECTION
4.00		Try to use ATM's less			60.00	wash truck once a month
5.00		Fuel only once or twice per card load			0.00	don't renew SCAC
5.00		get fuel with advance check and get advance $			60.00	get cheaper minutes plan
0.00					750.00	refinance truck payment
0.00					650.00	CARGO INSUR
0.00					400.00	refinance trailer payment
3.00		Rescale			2.29	Maps
0.00					32.00	TVC drv legal
0.00					35.00	GL.COM
1.00		IFTA sticker 10 ayear			25.00	ITS.COM
0.83		New Mexico w & d registration			4,312.50	FUEL $ month
25.00		use fuel card to purchase most fuel			484.38	FACTORING less
5.00		tip less			141.00	IRP $/12mo
20.00		dine in less and/or tip less			46.00	HHUT $/12mo
20.00		tip less and/or wash truck less			85.00	IFTA $/12mo
0.00					200.00	MAINTENANCE
0.00		plan ahead don't use directory assistance			200.00	REPAIRS
10.00		Canada calls extra charge			198.72	Take fuel advances, can save sometimes
0.00		try not to be late on payment save on late fee			200.00	TIRES 18 tire change in 18 mo's
20.00		Kentucy weight and distance tax			350.00	set up settlement plan
0.00		try to stay out of Oregon			80.00	stay out of toll area's
10.00		New York Highway use tax			25.00	printer ink use less
0.00					0.00	$9 ea. com data charge/load card
0.00					10.00	income tax preparation
2.50		Medical Exam about 60.00 ÷ 24mo			506.25	IDLING less
0.00		try not to use fuel additives			0.00
5.00		widow washer fluid			2.50	fuel finder books
0.00					0.00
0.00					10.00	hotel while repairs
10.00		Stationary			8.50	random drug consordium
5.00		flashlight batteries			0.00
151.33		0.00		0.00	8,874.14	0.00

"Adjustments for a Dead Market"
			0.029		Medicare	0
			0.124		Soc. Sec	0
this section deleted intentionally			0.153		2,553.45	390.68
					Total Taxes	0
					391
Input Prcnt of Runs You Factor	Misc Variable Expense		Per Ttl Miles		Enter %	0
0.60	pilot vehicle		10,350		0.00	0.00
For Un-Factored Income	pay co on outside loads		10,350		0.00	0.00
Enter 1 Below	use less comdata check		4		4.00	14.40
0			Total		4.00	0
% of Advanced per mo	Misc Variable Expense		Amount of			0
0.40			Enter # of times		Amount/day	0
Unfactored income	sweep trailer instead of wash		0		30.00	0.00
is calculated with	scale tickets		4		8.50	34.00
an Advance Fee	Total				38.50	0
of 4%, If you don't take	Variable expns per Ld		Loads		Price	0
Advances, Add it back in	Trippak/priority mail		18		9.00	162.00
	Load FuelCard		20		9.00	180.00
	Total				18.00	0
	Connection Card		more fixed expens→			60.00
			fixed expens→			0.00
			fixed expens→			0.00
			fixed expens→			0.00
			fixed expens→			0.00
Hours Idling per month times 1.25 gal per hour			6.0	Hrs		0
i.e. 7hrs x 25days out=175 X 1.25 X fuel rate=cost per mo			27	Days		0
			1.25	Gal. Per Hr		0
		adjust fuel rate in the setting	2.50	Fuel Rate		0
			506.25	Idling cost		0
		Refer Fuel per mo	Total Avg Hours	Gal Per Hour		0
		Refer Fuel	0	0.75		0.00
0.00		0.00	0.00	0.00		841
			Total Monthly Expense			9,866.55

This page is the second half of the expense page reflecting mostly variable expense.

As you can see the total expense is given here and will feed into the nest section which is the calculators main settings section, this is where based on “how you run” (how you’re paid that is) you’ll calculate what your average rate per mile needs to be on all loads.

In the actual Spreadsheet this is the Calculator Settings Page and it’s on top being the first page you’ll see when you open the Calculator. I can’t explain everything you’ll need to know about how to operate the calculator here but the sky blue areas is where manual input is made. Notice in a dead market the expected income is bottomed out at 2,000 month and the average rate per mile is as low as 1.50 cpm for Operating Authority.

THE TRUCKING CALCULATOR www.therealdealtrucking.com				Set Fuel Surcharge (Fixed)
Activate Lease $ all mi's	0		11,867	Leased On $ on All Miles
Total Expense Monthly	9,866.55		3,450	Fuel Surcharge Amount Ld mi
Expected Monthly Income	Manually input 2,000.00 “Dead Market”		8,417	0.81
Ttl Expns + Exptd $ Goal	11,866.55		3,450	0.00
% of Income Factored	0.60		3,450.00	Leased On $ on All Miles Net
% Advanced	0.40		16,481	Leased On Paid Percent
Current Fuel Price	2.50		1.99	Booked Rate
Activate leased on by %	0		11,867
Your Avgerage MPG	6.00		3,450	Fuel Surcharge Amount Ld mi
more days on road	27		8,417
1 days Run + Delays	1.50
.= # of Runs	18.00			1.85
Per Run Avg. Loaded mi's	460.00		3,450	0.00
Percent of loaded mi DH	0.20		3,450.00	Leased On Paid Percent Net
Activate Base Rate+DH	0		11,867	DH Less than Base Rate
Per Run Avg. DH mi's	115.00		3,450	Fuel Surcharge Amount Ld mi
Per Run Avg. Total mi's	575.00		0	Amount Paid on DH
Loaded Miles	8,280.00		3,450	Fuel Surcharge Plus DH Pay
DH Miles		2,070.00	8,417	1.02
Miles Back	0.00		3,450	0.00
Total Miles (limit)13,500	10,350.00		3,450.00	DH Less than Base Rate Net
Don' exceed monthly mi	↑Keep it real↑		3,588.60	Company Driver Net Pay
Activate Authority = 1	1		11,867	Line Haul/BackHaul
Deactivate Authority = 0	!!!			1.43
Linehaul/Backhaul Runs			12,420	1.50
			2,553.45	Line Haul/BackHaul Net
Activate Roundtrip = 1	0		11,867	1.49
Deactivate Roundtrip = 0			0	0.00
% mi back DH Rnd Trip	0.88		0.00	Round Trip