Here's an Excel worksheet to help you calculate delivery charges.
NOTE: only areas w/ pale yellow background can be edited (the sheet is password protected!!)
In column A (far left) are the GIVENS:
what your delivery vehicle's OVERALL AVERAGE MPG is -- example: my little PT Cruiser gets about 18 in the city and 24 or so on the highway. Therefore with the mix of driving I do (city vs. hwy) I get an overall average of 20 -- which is what is entered currently. Change this to your figure.
then the cost of gas per gallon. I used $4.00 as it's a nice round number and most of the stations in my area are flirtin' with it. Use the actual amount you're paying. Tho' I would round up some (ok, a fair bit)
it then calculates the cost per mile and uses it to recalculate the sheet.
ALSO -- the current IRS rate is 50.5 cents/mile which is entered. This changes annually -- just check their website for the latest figure.
VERY IMPORTANT TO REMEMBER -- the IRS and YOU SHOULD TOO! set the rate to include not just the cost of gas but also maintenance, insurance, and depreciation on the vehicle.
(I thought it interesting that the current IRS rate matches fairly closely the 2.5x the cost of gas at $4/gallon.)
Note how at the top of the middle four columns you can set a flat fee for the first 15 or 25 miles and then an additional fee for each 5 or 10 miles beyond the first amount.
Let me tell you a secret!!
As always I AM IN AWE Of YOU
made a few revisions to fix the usual bad typing / spelling / etc. I am prey to.
Wow thanks Doug
I think it varies by state as to whether the IRS will let you deduct both mileage AND depreciation etc. In WI, you have to choose one or the other but it's a good lesson in choosing which one is better for you