As a simple solution try this:
Cell
A1 Start Date in B1 enter date i.e. 01/01/2009
A2 End Date in B2 enter date i.e. 12/31/2009
A3 Workdays in B3 enter formula =NETWORKDAYS(B1,B2)
A4 Return Mileage in B4 enter 140
A5 MPG in B5 enter 20
A6 Gas Price in B6 enter $2.10
A7 Cost per trip in B7 enter formula =(B4/B5)*B6
A8 Annual Cost in B8 enter formula =B7*B3
Rearrange to suit your layout
Hope this helps


"Sisell" wrote:

I have been given the task to figure out what it will cost us a year to
deliver to a certain branch.

We have a branch that we would like to start delivering to. We need to find
out how much it is going to cost us a year to deliver items to and from this
branch.

I need the following information to show and I need the ability to change if
gas prices change, weekdays in the year, etc.:

1. Weekdays we work a year: 261 week days in 2009
2. # of miles from the branch we work at to the other branch we want to
deliver to. - Estimated mileage is 140 miles round trip per day.
3. The trucks take 20 mpg
4. We want to use the gas price of $2.10.

Can anyone help me set up a template or does anyone have one to forward me
that I can use.