Pickup Truck Cost Per Mile for Expediters

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.

 

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.

 

Good post I'll try to get the wife to turn it into a printable writable clean PDF

 

Go here for the spreadsheet.

http://www.ooida.com/EducationTools/Tools/

 

The only thing missing is non-revenue miles. You still incur cost when you're not getting paid. It could be easy to add a percent or number of miles( non-paid) to get a more accurate picture.

 

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