DESTINATION: SAN DIEGO,
CA |
|
|
|
|
|
|
|
|
|
|
|
|
|
VEHICLE: |
|
|
MPG: |
|
TANK SIZE: |
|
|
|
|
@60 MPH |
|
|
|
|
|
START |
REFUEL |
TIME |
MILES |
GALLONS |
PRICE PER |
MONEY |
|
CITY |
CITY |
REQUIRED |
TRAVELED |
USED |
GALLON |
SPENT |
|
|
|
|
|
|
|
|
|
Portland,ME |
xxxxxx,xx |
99:99 |
999 |
99 |
$ 2.17 |
$99,999.99 |
|
|
|
99:99 |
999 |
99 |
$ 2.17 |
$99,999.99 |
|
|
|
99:99 |
999 |
99 |
$ 2.17 |
$99,999.99 |
|
|
|
99:99 |
999 |
99 |
$ 2.17 |
$99,999.99 |
|
xxxxxxx,xx |
San Diego, CA |
99:99 |
999 |
99 |
$ 2.17 |
$99,999.99 |
|
|
|
|
|
|
|
|
|
|
TOTALS: |
99:99 |
9,999.99
|
9,999.99
|
|
$99,999.99 |
|
|
|
|
|
|
|
|
|
1. Find an Economical Vehicle: |
www.car.com |
www.edmunds.com |
|
2. Plot the Best Route: |
|
mapquest.com |
|
|
|
3. Fill out the spreadsheet. |
|
|
|
|
|
|
4. Compare Results. |
|
|
|
|
|
|
5. WHO'S GOT THE FASTEST ROUTE? CHEAPEST?
MOST ECONOMICAL? |
|
|
|
|
|
|
|
|
|
|
|
|
TIME |
TRAVELED |
GALLONS |
PRICE |
MONEY |
|
|
|
MI TRVLD/60MPH |
YOU ENTER |
MI.TRAVELED |
GIVEN @ $2.17 |
GALS X PRICE |
|
|
|
|
|
DIVIDED BY |
|
|
|
|
|
|
|
MPG |
|
|
|
|
|
|
|
|
|
|
|
* TANK SIZE
MUST FIGURE INTO WHEN YOU STOP. ADD
.25 HOURS TO TIME, EACH STOP |
|
|
|
|
|
|
|
|
|