I'm building a spreadsheet to calculate my total earnings per load. This is in hopes to break down load offerings and to see if the load really is worth taking. I've put together a sample and would like to know if I'm doing the calculations properly. Thanks
EXAMPLE:
[TABLE]
[TR]
[TD="width: 111"]P/U[/TD]
[TD="width: 114"]Deliver[/TD]
[TD="width: 86"]Paid Miles[/TD]
[TD="width: 86"]Actual Miles[/TD]
[TD="width: 86"]Rate[/TD]
[TD="width: 86"]FSC[/TD]
[TD="width: 86"]Truck Earns[/TD]
[TD="width: 86"]MPG[/TD]
[TD="width: 86"]FPP
[/TD]
[TD="width: 105"]Gallons needed[/TD]
[TD="width: 105"]Total fuel cost[/TD]
[TD="width: 118"]Actual Earnings[/TD]
[TD="width: 102"]Rate Per Mile[/TD]
[/TR]
[TR]
[TD]Monroeville, AL[/TD]
[TD]Chicago, IL[/TD]
[TD]778[/TD]
[TD]859[/TD]
[TD]$1,150.00[/TD]
[TD]$346.21[/TD]
[TD]$803.79[/TD]
[TD]6[/TD]
[TD]$3.85[/TD]
[TD]143.17[/TD]
[TD]$551.19[/TD]
[TD]$598.81[/TD]
[TD]$0.70[/TD]
[/TR]
[/TABLE]
The calculations are as follows: FSC is figured at the current rate times paid miles. Truck earns is Rate minus FSC. FPP is fuel pump price. Fuel costs is actual miles/MPG*gallons needed. Actual earnings is FSC-Total fuel cost+truck earns. Rate per mile is simply actual earnings divided by actual miles.
Please keep in mind that this is just to calculate what my truck may earn per offered load.
Thank you.
Am I doing this correct?
Discussion in 'Ask An Owner Operator' started by griemar, Feb 26, 2014.
-
-
Trucking Jobs in 30 seconds
Every month 400 people find a job with the help of TruckersReport.
-
Instead of paying the Pump price, why not join a fuel network and save some $ off the pump price?
lovesthedrive Thanks this. -
I plan on doing that, I'm just asking if my math is correct. I want to make sure that I'm calculating things correctly so that I can see at a glance what a loads breakdown will be, along with a estimated profit/loss should i decide to accept a load. Keep in mind that my first post is merely na example. There's no chance I would accept a .70cpm load. I'd be broke within a year, lol.
-
Do you run per mile or percentage? I have a spreadsheet I use for the same thing, but it is for percentage.
-
Wow monroeville Al, my hometown, lol, I had to look twice to make sure I read that right, it seems funny seeing it here
-
Trucking Jobs in 30 seconds
Every month 400 people find a job with the help of TruckersReport.