I don't count wages, taxes and profit as costs. I take revenue, subtract costs and get taxable income. I allow for taxes and get gross profit. I take my cut, and if there's excess profit it goes into savings.
For example, a couple months ago, I drove 4500 miles for the month. At my per mile of about .65, that's 2925 in costs. My revenue was 7450. That leaves 4525 taxable. I estimate 20% for taxes, or 905 leaving 3620. I was able to cover household expenses and save a bit. That was a pretty slow month.
edited to add:
That was actually my lowest per-mile month- I did a bunch of small local trips to help out a company who lost their driver. For most of this year, I'm averaging about 3.12 per mile billing.
Pickup Truck Cost Per Mile for Expediters
Discussion in 'Expediter and Hot Shot Trucking Forum' started by stammingerr, Sep 9, 2014.
Page 4 of 5
-
-
Trucking Jobs in 30 seconds
Every month 400 people find a job with the help of TruckersReport.
-
Here is something I ran across that may give you an idea just what may be involved. I hope this copies ok.
[TABLE="width: 419"]
[TR]
[TD="class: xl66, width: 159, bgcolor: black"]Cost of Operations[/TD]
[TD="class: xl98, width: 335, bgcolor: transparent, colspan: 4"](based on 100,000 miles a year)[/TD]
[TD="width: 64, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl97, bgcolor: transparent, colspan: 6"]In the example below, the drivers income is based on 30% of the Total Cost of Operation.[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, bgcolor: transparent"]Total Miles Driven Annually[/TD]
[TD="class: xl76, bgcolor: transparent"][/TD]
[TD="class: xl80, bgcolor: #FFFF99"]100,000[/TD]
[TD="class: xl76, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: silver"]FIXED COSTS[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"]ANNUAL COSTS[/TD]
[TD="class: xl75, bgcolor: transparent"]MONTHLY COSTS[/TD]
[TD="class: xl75, bgcolor: transparent"]CENTS PER MILE[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl81, bgcolor: transparent"] [/TD]
[TD="class: xl81, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Truck Payment[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$16,000.00[/TD]
[TD="class: xl85, bgcolor: transparent"]$1,333.33[/TD]
[TD="class: xl84, bgcolor: transparent, align: right"]0.160[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Trailer Payment[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl83, bgcolor: #FFFF99"]$0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$0.00[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.000[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Collision/Comp Insur.[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$5,700.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$475.00[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.057[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Bobtail Insur.[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$704.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$58.67[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.007[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Cargo Insur.[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$0.00[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.000[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Health Insur.[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$2,643.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$220.25[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.026[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Licenses[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$1,574.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$131.17[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.016[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Permits[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$454.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$37.83[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.005[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Accounting Svcs[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$541.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$45.08[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.005[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Return on Investment[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$0.00[/TD]
[TD="class: xl72, bgcolor: transparent"]$0.00[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]0.000[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl87, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Total Fixed Costs:[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl90, bgcolor: transparent"]$27,616.00[/TD]
[TD="class: xl90, bgcolor: transparent"]$2,301.33[/TD]
[TD="class: xl88, bgcolor: transparent, align: right"]0.276[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: silver"]VARIABLE COSTS[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Tractor Fuel[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$20,700.00[/TD]
[TD="class: xl85, bgcolor: transparent"]$1,725.00[/TD]
[TD="class: xl89, bgcolor: transparent, align: right"]0.207[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Reefer Fuel[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$0.00[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.000[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Tractor/Trailer Tires[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$2,300.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$191.67[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.023[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Maintenance[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$4,676.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$389.67[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.047[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Repair[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$5,615.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$467.92[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.056[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Truck Wash[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$701.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$58.42[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.007[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Telephone[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$1,534.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$127.83[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.015[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Lodging[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$788.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$65.67[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.008[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Meals[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$5,177.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$431.42[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.052[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Loading/Unloading Charges[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$0.00[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.000[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Tolls[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$1,276.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$106.33[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.013[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Legal Fees[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$0.00[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.000[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Fines[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$0.00[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.000[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Cargo Claims[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$0.00[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.000[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Scale Fees[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$0.00[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.000[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Workman's Compensation[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$0.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$0.00[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.000[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Taxes(Road, Use, Fuel, Fed)[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$1,755.00[/TD]
[TD="class: xl71, bgcolor: transparent"]$146.25[/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]0.018[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"]Miscellaneous Expenses[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl79, bgcolor: #FFFF99"]$500.00[/TD]
[TD="class: xl72, bgcolor: transparent"]$41.67[/TD]
[TD="class: xl74, bgcolor: transparent, align: right"]0.005[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl87, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]Total Variable Costs:[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl91, bgcolor: transparent"]$45,022[/TD]
[TD="class: xl90, bgcolor: transparent"]$3,751.83[/TD]
[TD="class: xl88, bgcolor: transparent, align: right"]0.450[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]Total Vehicle Costs:[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl91, bgcolor: transparent"]$72,638[/TD]
[TD="class: xl90, bgcolor: transparent"]$6,053.17[/TD]
[TD="class: xl88, bgcolor: transparent, align: right"]0.726[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]Drivers Income:[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl91, bgcolor: transparent"]$31,131[/TD]
[TD="class: xl90, bgcolor: transparent"]$2,594.21[/TD]
[TD="class: xl88, bgcolor: transparent, align: right"]0.311[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]Total Cost of Operation:[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl91, bgcolor: transparent"]$103,769[/TD]
[TD="class: xl90, bgcolor: transparent"]$8,647.38[/TD]
[TD="class: xl92, bgcolor: transparent, align: right"]1.038[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl98, bgcolor: transparent, colspan: 5"]*In the example above you will note this driver has total expenses per mile of [/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl98, bgcolor: transparent, colspan: 5"]$0.726 cents a mile. If he's hauling 82 cents per mile freight, he's clearing [/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl98, bgcolor: transparent, colspan: 5"]10 cents a mile which translatates into an annual wage of $9,362.[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl97, bgcolor: transparent, colspan: 6"]In the example below, enter the drivers income amount you expect/desire, and the[/TD]
[/TR]
[TR]
[TD="class: xl97, bgcolor: transparent, colspan: 4"]Total Cost of Operation will be figured automatically.[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]Drivers Income:[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl93, bgcolor: #FFFF99"]$40,000[/TD]
[TD="class: xl90, bgcolor: transparent"]$3,333.33[/TD]
[TD="class: xl88, bgcolor: transparent, align: right"]0.400[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]Total Cost of Operation:[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl91, bgcolor: transparent"]$112,638[/TD]
[TD="class: xl90, bgcolor: transparent"]$9,386.50[/TD]
[TD="class: xl92, bgcolor: transparent, align: right"]1.126[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl97, bgcolor: transparent, colspan: 6"]In the example below, enter the drivers income amount you expect/desire, and the[/TD]
[/TR]
[TR]
[TD="class: xl97, bgcolor: transparent, colspan: 5"]Cents Per Mile and the needed miles to be driven will be figured automatically.[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]Drivers Income:[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl93, bgcolor: #FFFF99"]$50,000[/TD]
[TD="class: xl90, bgcolor: transparent"]$4,166.67[/TD]
[TD="class: xl88, bgcolor: transparent, align: right"]0.500[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]Total Cost of Operation:[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl91, bgcolor: transparent"]$122,638[/TD]
[TD="class: xl90, bgcolor: transparent"]$10,219.83[/TD]
[TD="class: xl96, bgcolor: #FFFF99, align: right"]1.150[/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Miles Needed[/TD]
[TD="class: xl95, bgcolor: transparent, align: right"]106,642[/TD]
[TD="class: xl94, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[/TABLE] -
CMF are these your numbers or what was in it when you found the sheet? It is a pretty good example has a lot of the the things that I forget when making budgets. I think his fuel is off but if it was just an example then who cares. Was this in Excel or Word or just on a web page that you copied?
Thanks for posting it. -
I read it again and it says it is an example. I copied it right into Excel and Pasted with merged cells.
-
I found the spreadsheet on a web site and thought it would be nice to have. The spreadsheet works on my computer but I didn't know how to upload it. Hope it helps others see what it takes to make a nickel.
LGarrison Thanks this. -
-
Go here for the spreadsheet.
http://www.ooida.com/EducationTools/Tools/ -
-
From the above linked website, with deadhead miles, Partially filled out, no insurance, etc.....
[TABLE="width: 613"]
[TR]
[TD="class: xl79, width: 437, bgcolor: transparent"]OOIDA Cost Per Mile Calculator Cost of Operation
[/TD]
[TD="class: xl81, width: 126, bgcolor: #1F497D"]Fill in blue colored squares
[/TD]
[TD="class: xl82, width: 126, bgcolor: transparent"]Sub-Totals
[/TD]
[TD="class: xl83, width: 126, bgcolor: transparent"]Per - Mile Figures
[/TD]
[/TR]
[TR]
[TD="class: xl80, bgcolor: transparent"]Operation Specifics:
[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl87, width: 437, bgcolor: #F2F2F2"]How many loaded miles did you run last year?
[/TD]
[TD="class: xl71, bgcolor: #C9DEF7, align: right"]97,000
[/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl87, width: 437, bgcolor: #F2F2F2"]How many empty miles did you run last year?
[/TD]
[TD="class: xl71, bgcolor: #C9DEF7, align: right"]13,000
[/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl101, bgcolor: #F2F2F2"]Total Loaded and Unloaded run in the year
[/TD]
[TD="class: xl70, bgcolor: black"][/TD]
[TD="class: xl72, bgcolor: transparent, align: right"]110,000
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl100, width: 437, bgcolor: #F2F2F2"]Gallons of Tractor fuel purchased in last year?
[/TD]
[TD="class: xl71, bgcolor: #C9DEF7, align: right"]18,333
[/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Gallons of Reefer fuel purchased in last year?
[/TD]
[TD="class: xl71, bgcolor: #C9DEF7, align: right"]1,250
[/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl89, width: 437, bgcolor: #F2F2F2"]MPG
[/TD]
[TD="class: xl70, bgcolor: black"][/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]6.0
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl89, width: 437, bgcolor: #F2F2F2"]Average price per gallon
[/TD]
[TD="class: xl70, bgcolor: black"][/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]$3.75
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl111, bgcolor: transparent"]Operation Income (Yearly):
[/TD]
[TD="class: xl109, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl90, width: 437, bgcolor: #F2F2F2"]Gross earnings from truck(s)
[/TD]
[TD="class: xl84, bgcolor: #C9DEF7, align: right"]$145,000
[/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Interest earnings on escrow funds, investments, cash
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Other sources of business income
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl98, width: 437, bgcolor: #F2F2F2"]Total Gross Income Last Year
[/TD]
[TD="class: xl70, bgcolor: black"][/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]$145,000.00
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl105, bgcolor: transparent"]Operation Fixed Expenses (Yearly):
[/TD]
[TD="class: xl85, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl86, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl90, width: 437, bgcolor: #F2F2F2"]Yearly Truck payment
[/TD]
[TD="class: xl84, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl92, width: 437, bgcolor: #F2F2F2"]Yearly Trailer payment
[/TD]
[TD="class: xl84, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl90, width: 437, bgcolor: #F2F2F2"]Public Liability and Property Damage insurance premiums
[/TD]
[TD="class: xl84, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Bobtail/Deadhead insurance premiums
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Cargo insurance premiums
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Primary Medical insurance premiums
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Primary Disability insurance premiums
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Workers Compensation insurance premiums
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]License Plates
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Permits
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Garage or Parking Expense
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl99, width: 437, bgcolor: #F2F2F2"]Total Fixed Expenses Last Year
[/TD]
[TD="class: xl74, bgcolor: black"][/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]$0.00
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl78, width: 437, bgcolor: white"][/TD]
[TD="class: xl75, bgcolor: white"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl80, bgcolor: transparent"]Annual Operation Variable Expenses (Yearly):
[/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Tractor Fuel
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7, align: right"]$68,749
[/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Reefer Fuel
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7, align: right"]$4,688
[/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl93, width: 437, bgcolor: #F2F2F2"]Meals or per diem meal expense
[/TD]
[TD="class: xl102, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Telephone
[/TD]
[TD="class: xl102, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Satellite
[/TD]
[TD="class: xl102, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Tolls
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Loading and unloading Fees (include gate fees, lumpers, etc.)
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Tires
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Preventative Maintenance
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Repairs (replacing a truck part)
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Factoring fees (selling accounts receivable)
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Legal Services
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Broker fees
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Professional Services (accounting, etc.)
[/TD]
[TD="class: xl103, bgcolor: #C5D9F1"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Driver Wages (total paid to drivers working for you)
[/TD]
[TD="class: xl103, bgcolor: #C5D9F1"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Payroll Taxes for employee drivers
[/TD]
[TD="class: xl103, bgcolor: #C5D9F1"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl87, width: 437, bgcolor: #F2F2F2"]Taxes: Road, Fuel, Property, Federal highway use
[/TD]
[TD="class: xl103, bgcolor: #C5D9F1"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl87, width: 437, bgcolor: #F2F2F2"]Advance fees
[/TD]
[TD="class: xl103, bgcolor: #C5D9F1"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Uncollectable receivables
[/TD]
[TD="class: xl103, bgcolor: #C5D9F1"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Collection fees
[/TD]
[TD="class: xl103, bgcolor: #C5D9F1"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl88, width: 437, bgcolor: #F2F2F2"]Misc Expenses and Losses
[/TD]
[TD="class: xl104, bgcolor: #C5D9F1"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl98, width: 437, bgcolor: #F2F2F2"]Total Variable Expenses Last Year
[/TD]
[TD="class: xl74, bgcolor: black"][/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]$73,436.25
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl105, bgcolor: transparent"]Annual Operation Summary:
[/TD]
[TD="class: xl107, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl94, width: 437, bgcolor: #F2F2F2"]Total miles run (from previous pages)
[/TD]
[TD="class: xl76, bgcolor: transparent, align: right"]110,000
[/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl91, width: 437, bgcolor: #F2F2F2"]Total Gross Income (from previous pages)
[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]$145,000
[/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl95, width: 437, bgcolor: #F2F2F2"]Total fixed expenses
[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]$0
[/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl91, width: 437, bgcolor: #F2F2F2"]Total variable expenses
[/TD]
[TD="class: xl77, bgcolor: transparent, align: right"]$73,436
[/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl95, width: 437, bgcolor: #F2F2F2"]Wages you paid yourself Last Year (Net Income)
[/TD]
[TD="class: xl69, bgcolor: #C9DEF7, align: right"]$30,000
[/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl95, width: 437, bgcolor: #F2F2F2"]Your Total Profit or Loss Last Year
[/TD]
[TD="class: xl70, bgcolor: black"][/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]$71,563.75
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl89, width: 437, bgcolor: #F2F2F2"]Gross income per mile
[/TD]
[TD="class: xl74, bgcolor: black"][/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]$1.32
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl89, width: 437, bgcolor: #F2F2F2"]Fixed expenses per mile
[/TD]
[TD="class: xl74, bgcolor: black"][/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]$0.00
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl89, width: 437, bgcolor: #F2F2F2"]Variable expenses per mile
[/TD]
[TD="class: xl74, bgcolor: black"][/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]$0.67
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl89, width: 437, bgcolor: #F2F2F2"]Total expenses per mile
[/TD]
[TD="class: xl74, bgcolor: black"][/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]$0.67
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl96, width: 437, bgcolor: #F2F2F2"]Wages you paid yourself per mile
[/TD]
[TD="class: xl74, bgcolor: black"][/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]$0.27
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl97, width: 437, bgcolor: #F2F2F2"]Company profit or loss per mile
[/TD]
[TD="class: xl74, bgcolor: black"][/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]$0.65
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]$0.38
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"]less wages
[/TD]
[/TR]
[/TABLE] -
61flathead, that works, I copied and pasted into Excel and it works fine, Thanks,
CMFofNC
Trucking Jobs in 30 seconds
Every month 400 people find a job with the help of TruckersReport.
Page 4 of 5