Creating a worksheet/template for Mileage
 

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.

Creating a worksheet/template for Mileage
 

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.

Creating a worksheet/template for Mileage
 

Ron@Buy,

Thank you so much for this....It was PERFECT!!! Greatly appreciated.

thankyou,
Sisell

"Ron@Buy" wrote:

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.

Creating a worksheet/template for Mileage
 

Glad I could help
Thanks for the feedback

"Sisell" wrote:

Ron@Buy,

Thank you so much for this....It was PERFECT!!! Greatly appreciated.

thankyou,
Sisell

"Ron@Buy" wrote:

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.

Creating a worksheet/template for Mileage
 

Your requirement isn't very complicated. Why bother with a template? Just
enter your four variables in cells, like:
a1: 261
a2: 140
a3: 20
a4: 2.10

Cost per year = a1*a2/a3*a4

Regards,
Fred.

"Sisell" wrote in message
...
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.