Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Gas Mileage Calculator

VIEWS: 1,304 PAGES: 10

This is an example of gas mileage calculator. This document is useful for calculating gas mileage.

More Info
									Gas Mileage Calculator

1. Enter your beginning odometer reading
2. Each time you re-fuel, record the odometer reading, the amount of fuel added
   and the cost
(Don't delete the blue columns - they contain formulas)
To use metric values, substitute km for miles and liters for gallons


 Refuel Odometer                     Gallons                       $Cost
  Date    Reading        Miles    (fuel added)    $Cost   MPG     per Mile
4/14/2008     10.0                      1        $ 3.50 (mileage)
 4/29/08         78.0     68.0       0.966       $   3.59    70.4    $ 0.053
 5/2/08        173.8      95.8       1.326       $   4.93    72.2    $ 0.051
 5/14/08       268.3      94.5       1.225       $   4.81    77.1    $ 0.051
 5/19/08       346.8      78.5       1.115       $   4.37    70.4    $ 0.056
 5/29/08       445.3      98.5       1.315       $   5.38    74.9    $ 0.055
 6/7/08        525.2      79.9       1.206       $   4.09    66.3    $ 0.051
 6/11/08       619.8      94.6       1.216       $   5.06    77.8    $ 0.053
 6/19/08       713.8      94.0       1.169       $   4.86    80.4    $ 0.052
 6/26/08       801.0      87.2       1.134       $   4.72    76.9    $ 0.054
 7/2/08        900.4      99.4       1.314       $   5.52    75.6    $ 0.056
 7/9/08        991.3      90.9       1.177       $   4.94    77.2    $ 0.054
 7/16/08      1,071.8     80.5       1.166       $   4.90    69.0    $ 0.061
 7/27/08      1,164.9     93.1       1.184       $   4.95    78.6    $ 0.053
 8/4/08       1,248.6     83.7       1.105       $   4.53    75.7    $ 0.054
 8/11/08      1,335.9     87.3       1.096       $   4.12    79.7    $ 0.047
 8/25/08      1,431.1     95.2       1.296       $   4.77    73.5    $ 0.050
 8/30/08      1,523.9     92.8       1.239       $   4.76    74.9    $ 0.051
 9/5/08       1,614.5     90.6       1.246       $   4.68    72.7    $   0.05
Gas Mileage Calculator
                                                                                           Scooter
1. Enter your beginning odometer reading                                                   Trip Fuel Cost Estimator
2. Each time you re-fuel, record the odometer reading, the amount of fuel added             $Cost per Mile
   and the cost                                                                                  Distance
(Don't delete the blue columns - they contain formulas)                                            Cost
To use metric values, substitute km for miles and liters for gallons

                                                                                   $Total  $Total Cost
 Refuel    Odometer                  Gallons                            $Cost     Cost Gas    Gas
  Date      Reading      Miles    (fuel added)    $Cost      MPG       per Mile     (Car)   (Scooter)
             142250                                        (mileage)              $ 827.67 $    88.48
  5/6/08     142504      254.0       11.433      $ 40.00     22.2      $ 0.157
  5/9/08     142786      282.0       13.201      $ 47.51     21.4      $ 0.168
 5/10/08     143045      259.0       11.626      $ 43.00     22.3      $ 0.166
 5/16/08     143295      250.0       11.586      $ 42.51     21.6      $ 0.170
 5/23/08     143544      249.0       12.266      $ 46.60     20.3      $ 0.187
  6/1/08     143784      240.0       12.503      $ 47.50     19.2      $ 0.198
 6/13/08     144014      230.0       12.182      $ 47.50     18.9      $ 0.207
 6/20/08     144259      245.0       12.183      $ 47.50     20.1      $ 0.194
 7/13/08     144491      232.0       11.998      $ 47.50     19.3      $ 0.205
 7/15/08     144773      282.0       12.631      $ 50.01     22.3      $ 0.177
 7/20/08     145057      284.0       12.251      $ 48.26     23.2      $ 0.170
 7/25/08     145309      252.0       11.697      $ 45.02     21.5      $ 0.179
 7/31/08     145558      249.0       12.502      $ 47.50     19.9      $ 0.191
 8/12/08     145812      254.0       13.035      $ 46.00     19.5      $ 0.181
 8/16/08     146075      263.0       12.639      $ 47.51     20.8      $ 0.181
 8/17/08     146373      298.0       12.802      $ 48.25     23.3      $ 0.162
 8/24/08     146627      254.0       11.767      $ 40.00     21.6      $ 0.157
  9/1/08     146882      255.0       13.079      $ 45.50     19.5      $ 0.178
                                                                  Car
Trip Fuel Cost Estimator                                          Trip Fuel Cost Estimator
             $ 0.053                                             $Cost per Mile $ 0.179
               1,614.5 miles                                          Distance    4,632 miles
             $ 85.59                                                    Cost $ 830.80




                          40                                                                                                             $0.30
                Mileage




                          35                                                                                                             $0.25
                          30                                                                                                             $0.20
                          25
                          20                                                                                                             $0.15
                          15                                                                                                             $0.10
                                          5/20/2008




                                                                  6/17/2008




                                                                                         7/15/2008

                                                                                                     7/29/2008

                                                                                                                 8/12/2008

                                                                                                                             8/26/2008
                               5/6/2008




                                                      6/3/2008




                                                                              7/1/2008
Service Log - Scooter                                                     Service Log - Car

Date      Miles      Service             Cost       Total   $ 119.64      Date
 6/5/2008        506 500 mile service     $ 72.32                         1/29/2008
 8/7/2008       1286 1200 mile service    $ 47.32                          5/5/2008


                                                            january   x
                                                            february
                                                            march
                                                            april
                                                            may       x
                                                            june
                                                            july
                                                            august
                                                            september x
                                                            october
                                                            november
                                                            december
Service Log - Car

        Miles       Service      Cost       Total   $ 140.53
                    Oil change    $ 41.95
                    Oil change    $ 98.58
Remember: Reset your trip odometer                           Remember: Reset your trip odometer
                   km or      Liters or       km/L or                           km or   Liters or       km/L or
Date   Odometer    Miles      Gallons     $    MPG           Date   Odometer    Miles   Gallons     $    MPG




                                                        Fold Here




                  Fold Here                                                        Fold Here


Remember: Reset your trip odometer                           Remember: Reset your trip odometer
                   km or      Liters or       km/L or                           km or   Liters or       km/L or
Date   Odometer    Miles      Gallons     $    MPG           Date   Odometer    Miles   Gallons     $    MPG




                                                        Fold Here
Total Scooter Costs
                                                                                               $3.00/gal
Item         Cost                                  Total       $ 2,066.09           Savings     $ 256.77
Gas           $   88.48                            Spent
Servicing     $ 119.64

Insurance                 $ 456.14 (April - December 2008)
Loan payments             $ 846.54 (April - December 2008)


Additional Purchases                    Total
Jacket     $ 150.00                 $     555.29
Gloves     $   25.00
Helmet       $   170.00            Fuel Consumption Comparison
Alarm        $    29.00                                                                                    Scooter
License      $    15.00                            Scooter     Car       Difference Price/Gal Miles
Lock         $   100.00            January                      $ 114.82             $    2.90
MSF Class    $    65.00            February                     $ 101.01             $    2.84
Cup holder   $     1.29            March                        $ 181.72             $    3.15
                                   April                        $ 183.66             $    3.47
                                   May             $   26.58    $ 219.62 $ 193.04 $       3.79    445.3
                                   June            $   18.73    $ 142.50 $ 123.77 $       3.89    355.7
                                   July            $   20.31    $ 238.29 $ 217.98 $       3.79    363.9
                                   August          $   18.18    $ 181.76 $ 163.58 $       3.59    359.0
                                   September       $    4.68    $  45.50 $    40.82                 90.6
                                   October
                                   November
                                   December

                                                   $   88.48   $ 1,408.88                        1,614.5
$3.50/gal $4.00/gal $4.25/gal $4.50/gal
 $ 299.56 $ 342.36 $ 363.76 $ 385.15




                2008
 Scooter                           Car               Total
Gallons MPG           Miles      Gallons   MPG       Miles     Savings




      6.9     64.10      1,294        60     21.53   1,739.3   $   80.15
      4.7     75.28        947        49     19.38   1,302.7   $   64.03
      4.8     75.17      1,299        61     21.27   1,662.9   $   65.50
      4.7     75.80      1,069        50     21.28   1,508.5   $   64.62
      1.2     72.71        255        13     19.50     419.6   $   16.31
                                                         -
                                                         -
                                                         -

                       4,864.0                       6,633.0   $ 290.61

								
To top