Gasoline Price History - Excel
W
Description
Gasoline Price History document sample
Document Sample


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
Get documents about "