Gasoline Price History - Excel

W
Description

Gasoline Price History document sample

Document Sample
scope of work template
							Agricultural Marketing Resource Center
       Fuel and Grain Price Historic
       The U.S. public is concerned about rising
       food prices and escalating fuel prices.
                              present):
       Price Charts (1980 to Oil and Corn
             Imported Crude Oil and Corn
         
             Imported Crude Oil and Soybean
              Imported Crude Oil and Soybean
         
                      Crude
              Imported and Diesel Fuel Prices
              Soybean and Diesel Fuel Prices
         
             Soybean Gasoline Prices
              Corn and Gasoline Prices (real)
             Corn and
                                  to present):
       Price Index Charts (1970 and Corn Price
             Domestic Crude Oil and Corn Price
             Domestic Crude Oil
       Use the tabs at the bottom to see
       Agricultural Marketing
       Authors: Don Hofstrand &                            Resource Center
       Ann Johanns
       File updated:
       6/9/2010
       . . . and justice for all of Agriculture (USDA) prohibits discrimination
       The U.S. Department
       in all its programs and activities on the basis of race, color, national
       Issued in furtherance of Cooperative Extension work, Acts of May 8
                Imported Crude Oil Prices and Corn Prices: Nominal                                                                                                                   Imported Crude Oil Prices and Soybean Prices:
                                    1980 - 2009                                                                                                                                                  Nominal, 1980 - 2009
            $100                                                                                                                           $7                         $100                                                                                                                         $18
             $90                                                                                                                                                       $90                                                                                                                         $16
                                                                                                                                           $6
             $80                                                                                                                                                       $80                                                                                                                         $14
             $70                                                                                                                           $5                          $70                                                                                                                         $12
             $60
 $/barrel




                                                                                                                                                                       $60




                                                                                                                                                           $/barrel
                                                                                                                                           $4                                                                                                                                                      $10




                                                                                                                                                                                                                                                                                                           $/bu.
                                                                                                                                                   $/bu.
             $50                                                                                                                                                       $50
             $40                                                                                                                           $3                                                                                                                                                      $8
                                                                                                                                                                       $40
             $30                                                                                                                                                       $30                                                                                                                         $6
                                                                                                                                           $2
             $20                                                                                                                                                       $20                                                                                                                         $4
                                                                                                                                           $1                                                                                                                                                      $2
             $10                                                                                                                                                       $10
              $0                                                                                                                           $0                           $0                                                                                                                         $0
                         1980
                                  1982
                                           1984
                                                   1986
                                                           1988
                                                                   1990
                                                                           1992
                                                                                  1994
                                                                                         1996
                                                                                                1998
                                                                                                       2000
                                                                                                              2002
                                                                                                                     2004
                                                                                                                             2006
                                                                                                                                    2008




                                                                                                                                                                                1980
                                                                                                                                                                                         1982
                                                                                                                                                                                                 1984
                                                                                                                                                                                                         1986
                                                                                                                                                                                                                 1988
                                                                                                                                                                                                                         1990
                                                                                                                                                                                                                                 1992
                                                                                                                                                                                                                                         1994
                                                                                                                                                                                                                                                 1996
                                                                                                                                                                                                                                                         1998
                                                                                                                                                                                                                                                                2000
                                                                                                                                                                                                                                                                       2002
                                                                                                                                                                                                                                                                              2004
                                                                                                                                                                                                                                                                                     2006
                                                                                                                                                                                                                                                                                            2008
                                         Nominal Crude Oil                                      Nominal Corn Price                                                                       Nominal Crude Oil                                         Nominal Soybean Price
Source: Energy Information Administration, USDA NASS                                                                                                       Source: Energy Information Administration, USDA NASS


                  Imported Crude Oil Prices and Corn Prices: Real                                                                                                            Imported Crude Oil Prices and Soybean Prices: Real
                          1980 - 2009, CPI: 1982-84 = 1.00                                                                                                                             1980 - 2009, CPI: 1982-84 = 1.00
            $45                                                                                                                       $4.00                           $45                                                                                                                          $9
            $40                                                                                                                       $3.50                           $40                                                                                                                          $8
            $35                                                                                                                       $3.00                           $35                                                                                                                          $7
            $30                                                                                                                                                       $30                                                                                                                          $6
                                                                                                                                      $2.50

                                                                                                                                                           $/barrel
$/barrel




            $25                                                                                                                                                       $25                                                                                                                          $5




                                                                                                                                                                                                                                                                                                         $/bu.
                                                                                                                                                $/bu.

                                                                                                                                      $2.00
            $20                                                                                                                                                       $20                                                                                                                          $4
            $15                                                                                                                       $1.50                           $15                                                                                                                          $3
            $10                                                                                                                       $1.00                           $10                                                                                                                          $2
             $5                                                                                                                       $0.50                            $5                                                                                                                          $1
             $0                                                                                                                       $0.00                            $0                                                                                                                          $0
                                                                                                                                                                              1980
                                                                                                                                                                                       1982
                                                                                                                                                                                                1984
                                                                                                                                                                                                        1986
                                                                                                                                                                                                                1988
                                                                                                                                                                                                                        1990
                                                                                                                                                                                                                                1992
                                                                                                                                                                                                                                        1994
                                                                                                                                                                                                                                                1996
                                                                                                                                                                                                                                                        1998
                                                                                                                                                                                                                                                                2000
                                                                                                                                                                                                                                                                       2002
                                                                                                                                                                                                                                                                              2004
                                                                                                                                                                                                                                                                                     2006
                                                                                                                                                                                                                                                                                            2008
                  1980
                           1982
                                    1984
                                            1986
                                                    1988
                                                            1990
                                                                    1992
                                                                           1994
                                                                                  1996
                                                                                         1998
                                                                                                2000
                                                                                                       2002
                                                                                                              2004
                                                                                                                     2006
                                                                                                                            2008




                                   Real Crude Oil Price                                         Real Corn Price                                                                               Real Crude Oil Price                                        Real Soybean Price

Source: Energy Information Administration, USDA NASS                                                                                                       Source: Energy Information Administration, USDA NASS
                       Domestic Crude Oil and Iowa Corn Price Index: Nominal
                                            1970 = 100
3,600
3,100
2,600
2,100
1,600
1,100
  600
  100



Source: US DOE, USDA           Corn Price per bu.             Crude Oil Price per barrel


                        Domestic Crude Oil and Iowa Corn Price Index: Real
                                1970 = 100, CPI: 1982-1984 = 1.00
600

500

400

300

200

100

   0



Source: US DOE, USDA             Crude Oil Price per barrel       Corn Price per bu.
                                                        Soybeans and Diesel Fuel Prices: Nominal
                                                                      1980 - 2009
          $4.00
          $3.50                                                                                                                                               $16.00
          $3.00
          $2.50                                                                                                                                               $12.00
$/gal




          $2.00
                                                                                                                                                              $8.00




                                                                                                                                                                       $/bu
          $1.50
          $1.00                                                                                                                                               $4.00
          $0.50
          $0.00                                                                                                                                               $0.00
                  1980


                         1982


                                   1984


                                            1986


                                                       1988


                                                                 1990


                                                                         1992


                                                                                    1994


                                                                                            1996


                                                                                                        1998


                                                                                                                2000


                                                                                                                        2002


                                                                                                                                   2004


                                                                                                                                            2006


                                                                                                                                                     2008
                                                               Nominal Diesel Fuel                  Nominal Soybean Price
Source: Energy Information Administration, USDA NASS


                                                              Soybeans and Diesel Fuel Prices: Real
                                                                 1980 - 2009, CPI: 1982-84 = 1.00
          $2.00                                                                                                                                                $9.00
          $1.80                                                                                                                                                $8.00
          $1.60                                                                                                                                                $7.00
          $1.40                                                                                                                                                $6.00
          $1.20
        $/gal




                                                                                                                                                               $5.00




                                                                                                                                                                       $/bu
          $1.00
                                                                                                                                                               $4.00
          $0.80
          $0.60                                                                                                                                                $3.00
          $0.40                                                                                                                                                $2.00
          $0.20                                                                                                                                                $1.00
          $0.00                                                                                                                                                $0.00
                  1980


                         1982


                                   1984


                                            1986


                                                       1988


                                                                 1990


                                                                          1992


                                                                                     1994


                                                                                             1996


                                                                                                         1998


                                                                                                                 2000


                                                                                                                            2002


                                                                                                                                     2004


                                                                                                                                              2006


                                                                                                                                                       2008
                                                                 Real Diesel Fuel                  Real Soybean Price
Source: Energy Information Administration, USDA NASS
                                           Regular Gasoline Prices and Corn: Nominal
                                                          1980 - 2009
         $3.50                                                                                                                                   $6.00
         $3.00                                                                                                                                   $5.00
         $2.50
                                                                                                                                                 $4.00
         $2.00
 $/gal




                                                                                                                                                         $/bu.
                                                                                                                                                 $3.00
         $1.50
                                                                                                                                                 $2.00
         $1.00
         $0.50                                                                                                                                   $1.00

         $0.00                                                                                                                                   $0.00
                 1980


                         1982


                                  1984


                                            1986


                                                       1988


                                                              1990


                                                                       1992


                                                                                  1994


                                                                                         1996


                                                                                                     1998


                                                                                                              2000


                                                                                                                     2002


                                                                                                                            2004


                                                                                                                                   2006


                                                                                                                                          2008
                                                              Nominal Gas price            Nominal corn price
Source: Energy Information Administration, USDA NASS


                                                   Regular Gasoline Prices and Corn: Real
                                                      1980 - 2009, CPI: 1982-84 = 1.00
         $1.60                                                                                                                                   $3.50
         $1.40                                                                                                                                   $3.00
         $1.20                                                                                                                                   $2.50
         $1.00
                                                                                                                                                 $2.00
$/gal




                                                                                                                                                         $/bu.
         $0.80
                                                                                                                                                 $1.50
         $0.60
         $0.40                                                                                                                                   $1.00
         $0.20                                                                                                                                   $0.50
         $0.00                                                                                                                                   $0.00
                 1980


                         1982


                                   1984


                                            1986


                                                       1988


                                                              1990


                                                                       1992


                                                                                  1994


                                                                                         1996


                                                                                                     1998


                                                                                                              2000


                                                                                                                     2002


                                                                                                                            2004


                                                                                                                                   2006


                                                                                                                                          2008
                                                                 Real Gas price                 Real corn price
Source: Energy Information Administration, USDA NASS
                                                         Ag Marketing Resource Center
                                          Annual Comparison of Energy Prices and Grain Prices*
        Imported Crude Oil Price             Diesel Fuel Price                 Gasoline Price             Corn Price          Soybean Price
            Nominal            Real        Nominal                Real         Nominal         Real     Nominal        Real   Nominal         Real
Year          $/barrel       $/barrel        $/gallon          $/gallon          $/gallon    $/gallon      $/bu        $/bu      $/bu         $/bu
1980             33.97         41.23             1.04              1.27             1.25        1.51       2.60        3.15      6.61         8.00
1981             37.07         40.83             1.19              1.31             1.38        1.52       2.84        3.14      6.85         7.55
1982             33.59         34.82             1.15              1.19             1.26        1.30       2.29        2.37      5.68         5.89
1983             29.35         29.48             1.14              1.14             1.20        1.21       2.92        2.92      6.63         6.65
1984             28.87         27.78             1.16              1.12             1.18        1.13       2.97        2.86      6.95         6.70
1985             27.00         25.10             1.17              1.09             1.17        1.08       2.41        2.24      5.32         4.95
1986             14.32         13.06             0.89              0.81             0.89        0.81       1.83        1.67      4.90         4.47
1987             18.05         15.88             0.94              0.82             0.91        0.80       1.45        1.28      4.97         4.38
1988             14.62         12.37             0.92              0.78             0.91        0.77       2.19        1.85      7.13         6.02
1989             18.07         14.57             0.99              0.80             0.98        0.79       2.34        1.89      6.56         5.30
1990             22.20         16.94             1.17              0.89             1.13        0.86       2.30        1.76      5.72         4.38
1991             18.74         13.76             1.13              0.83             1.10        0.81       2.26        1.66      5.52         4.05
1992             18.12         12.91             1.11              0.79             1.09        0.77       2.22        1.58      5.48         3.91
1993             16.17         11.20             1.11              0.77             1.07        0.74       2.15        1.49      5.97         4.13
1994             15.41         10.39             1.11              0.75             1.07        0.72       2.34        1.58      6.04         4.08
1995             17.15         11.25             1.11              0.73             1.11        0.73       2.47        1.62      5.74         3.76
1996             20.60         13.12             1.23              0.79             1.20        0.76       3.51        2.24      7.18         4.57
1997             18.55         11.56             1.20              0.74             1.20        0.75       2.52        1.57      7.32         4.56
1998             12.10          7.42             1.04              0.64             1.03        0.63       2.13        1.31      5.85         3.59
1999             17.27         10.34             1.12              0.67             1.13        0.68       1.80        1.08      4.45         2.67
2000             27.68         16.07             1.49              0.87             1.49        0.86       1.78        1.04      4.67         2.71
2001             21.99         12.42             1.40              0.79             1.43        0.81       1.81        1.02      4.39         2.48
2002             23.63         13.13             1.32              0.73             1.34        0.74       2.05        1.14      4.86         2.70
2003             27.84         15.14             1.51              0.82             1.56        0.85       2.18        1.19      6.08         3.30
2004             35.89         18.99             1.81              0.96             1.85        0.98       2.41        1.28      7.65         4.06
2005             48.92         25.02             2.40              1.23             2.27        1.16       1.90        0.97      5.88         3.01
2006             58.86         29.20             2.70              1.34             2.57        1.27       2.22        1.10      5.55         2.76
2007             67.08         32.30             2.88              1.39             2.80        1.35       3.37        1.62      7.78         3.74
2008             92.33         42.81             3.81              1.77             3.25        1.51       4.78        2.22     11.35         5.27
2009             59.37         27.63             2.46              1.15             2.34        1.09       3.81        1.77     10.06         4.69
       *Data is updated on an annual basis to reflect the historical trends in the market.
                                          Ag Marketing Resource Center
                                            Annual Average Domestic Crude Oil Prices
                                                          1970 - Present
                                    Prices                                                        Index
                   Domestic Oil                Corn Prices                  Domestic Crude Oil
  Year         Nominal       Real          Nominal       Real              Nominal       Real
1970               $3.18         $8.20         $1.17       $3.01                 100             100
1971               $3.39         $8.37         $1.21       $2.99                 107             102
1972               $3.39         $8.11         $1.11       $2.66                 107              99
1973               $3.89         $8.76         $1.81       $4.07                 122             107
1974               $6.87        $13.94         $2.87       $5.82                 216             170
1975               $7.67        $14.26         $2.66       $4.95                 241             174
1976               $8.19        $14.39         $2.45       $4.31                 258             176
1977               $8.57        $14.14         $1.98       $3.27                 269             173
1978               $9.00        $13.80         $2.04       $3.13                 283             168
1979              $12.64        $17.41         $2.25       $3.10                 397             212
1980              $21.59        $26.20         $2.60       $3.15                 679             320
1981              $31.77        $34.95         $2.84       $3.14                 999             426
1982              $28.52        $29.55         $2.29       $2.37                 897             361
1983              $26.19        $26.30         $2.92       $2.92                 824             321
1984              $25.88        $24.92         $2.97       $2.86                 814             304
1985              $24.09        $22.39         $2.41       $2.24                 758             273
1986              $12.51        $11.40         $1.83       $1.67                 393             139
1987              $15.40        $13.56         $1.45       $1.28                 484             165
1988              $12.58        $10.63         $2.19       $1.85                 396             130
1989              $15.86        $12.79         $2.34       $1.89                 499             156
1990              $20.03        $15.33         $2.30       $1.76                 630             187
1991              $16.54        $12.14         $2.26       $1.66                 520             148
1992              $15.99        $11.40         $2.22       $1.58                 503             139
1993              $14.25         $9.89         $2.15       $1.49                 448             121
1994              $13.19         $8.89         $2.34       $1.58                 415             109
1995              $14.62         $9.58         $2.47       $1.62                 460             117
1996              $18.46        $11.76         $3.51       $2.24                 581             144
1997              $17.23        $10.73         $2.52       $1.57                 542             131
1998              $10.87         $6.66         $2.13       $1.31                 342              81
1999              $15.56         $9.33         $1.80       $1.08                 489             114
2000              $26.72        $15.52         $1.78       $1.04                 840             189
2001              $21.84        $12.33         $1.81       $1.02                 687             150
2002              $22.51        $12.51         $2.05       $1.14                 708             153
2003              $27.56        $14.98         $2.18       $1.19                 867             183
2004              $36.77        $19.47         $2.41       $1.28                1156             238
2005              $50.28        $25.75         $1.90       $0.97                1581             314
2006              $59.69        $29.61         $2.22       $1.10                1877             361
2007              $66.52        $32.08         $3.37       $1.62                2092             391
2008              $94.04        $43.60         $4.78       $2.22                2957             532
2009              $56.39        $26.14         $3.81       $1.77                1773             319




Source: US DOE
http://tonto.eia.doe.gov/dnav/pet/hist/f000000__3a.htm
http://tonto.eia.doe.gov/dnav/pet/hist/f000000__3m.htm
ter
ces

      Index
                      Corn
              Nominal        Real
                    100             100
                    104              99
                      95             88
                    155             135
                    246             193
                    228             164
                    210             143
                    170             109
                    175             104
                    192             103
                    223             105
                    243             104
                    196              79
                    250              97
                    254              95
                    206              74
                    157              56
                    124              42
                    188              61
                    200              63
                    197              58
                    193              55
                    190              53
                    184              49
                    200              53
                    211              54
                    300              74
                    215              52
                    182              43
                    154              36
                    153              34
                    155              34
                    176              38
                    187              39
                    206              42
                    162              32
                    190              36
                    288              54
                    409              74
                    326              59
Data Sources

    History
          Gasoline Regular Grade Retail Price (including taxes)




          Diesel Fuel (including taxes)

          Crude Oil (refiner average imported crude oil acquisition cost)




          Consumer Price Index (all urban consumers):

          Corn and Soybean Prices



Real Price Calculation Procedure

    Real Price in Month A = Nominal Price in Month A  (Consumer Price Index in Base Month / Consumer Price Index in Mon
    CPI: 1982-84=1.00
     Gasoline Regular Grade Retail Price (including taxes)
          1980 - 1981: Bureau of Labor Statistics unleaded regular
          1982 -1994: Energy Information Administration (EIA) data extrapolated using BLS survey data.
          1995 - Present: EIA Weekly Petroleum Status Report , weekly EIA-878 "Motor Gasoline Price Survey"
     Diesel Fuel (including taxes)
          EIA Weekly Petroleum Status Report , EIA survey EIA-888 "On-Highway Diesel Fuel Price Survey"
     Crude Oil (refiner average imported crude oil acquisition cost)
          EIA Petroleum Marketing Monthly
          1980 - Sep. 1982: EIA survey ERA-51 "Transfer Pricing Report"
          Oct. 1982 - June 1984: EIA survey EP-51 "Monthly Foreign Crude Oil Transaction Report"
          July 1984 - Present: EIA survey EIA-856, "Monthly Foreign Crude Oil Acquisition Report"
     Consumer Price Index (all urban consumers):
          U.S. Bureau of Labor Statistics
     Corn and Soybean Prices
          1980-2007: National Agricultural Statistics Service

Price Calculation Procedure

Real Price in Month A = Nominal Price in Month A  (Consumer Price Index in Base Month / Consumer Price Index in Month A)
CPI: 1982-84=1.00
x in Month A)

						
Related docs