Bottom Line

[Teflon]

I have created a spreadsheet for the purpose of helping me make timely decisions after receiving a load offer.
This sheet is for those working off a fixed rate per mile. I am working on a sheet for those that work off a percentage of load.

I personally have a minimum pay limit that I will accept in a load offer. This sheet helps me input just a few
numbers to see exactly what the trip pays to my bottom line.

You input just a few numbers and the rest is calculated automatically.

Just play around with it a little and you can immediately see what an increase/decrease in fuel mileage, fuel cost, Fuel surcharge
and paid or unpaid deadhead can do to your bottom line.

If you would like me to send it to you just reply with your email address to: [email protected]

It is in excel format.

 

[ihamner]

What a great idea! Can't wait to see this! Trying to get this figured quickly when a load offer comes across QC is sometimes a nightmare. Thanks for sharing your hard work!!

India Hamner
FedEx CC
D Unit
Life is short.
Stay awake for it!

 

[TeamCaffee]

You can also check your figures against the OOIDA spreadsheet for drivers. We have used this spreadsheet since day one and keep it updated with our figures monthly. Takes all the guess work out of accepting loads that will be profitable to you. Everyone of us have a different base operating cost.

http://www.ooida.com/trucking_tools/CPM/cost_per_mile.htm

 

[themagicoen]

Just use your head... (Miles x rate) - (total miles x avg fuel/mile) - tolls(if any) + fsc= load profit. I kept record of all my fuel so I knew my rate was around .33/mile. Where the load went was more important to me, if I was sitting in Ohio and they send me a load to denver, there was no way I was going to take that.

 

[nightcreacher]

I've not been in this business for to long,maybe 22 years. It looks to me that trying to make a profitt for some of you would give me an ulcer.
For those that have a minimum for what a load pays, before they take it,are missing alot,for example:discount load 300 loaded miles,with dead head of 200 miles,and lets say that pay is $375.00. Now on your way to the delivery of that load, your cussing yourself out for doing,you get an offer for a load with 100 miles dead head,but that load is going 2800 miles at full rate,how do you feel now,you still loosing money.
I don't want to sound like a dispatcher,and say all the stuff we all have heard over the years,you know if customer doesnt get short loads hauled,they wont give the long ones,well thats all true,and even if you think your lossing money on one load,youll be making money on another
When i turn loads down,it's because i've already had my bad load or two in a row, or the advance on that load won't get it delivered and me to my next load. I don't figure what I'm making by the week but by the month
Good luck to all,and remember, you don't have to be a rocket scientist to do our work,just be available.