APPENDIX 8-E. MONTHLY ENERGY PRICE FACTOR CALCULATIONS FOR
 

WATER HEATER ANALYSIS
 

TABLE OF CONTENTS
 

8-E.1 INTRODUCTION ....................................................................................................... 8-E-1 

8-E.2 MONTHLY RESIDENTIAL NATURAL GAS PRICE FACTOR 

CALCULATIONS....................................................................................................... 8-E-1 

8-E.3 MONTHLY RESIDENTIAL LPG PRICE FACTOR CALCULATIONS ................. 8-E-5 

8-E.4 MONTHLY RESIDENTIAL ELECTRICITY PRICE FACTOR 

CALCULATIONS....................................................................................................... 8-E-7
 

8-E.5 MONTHLY RESIDENTIAL OIL PRICE FACTOR CALCULATIONS ................ 8-E-10
 

LIST OF TABLES 

Table 8-E.2.1 Average Residential Natural Gas Prices for Census Division 1 

(nominal dollars / thousand cubic feet)...................................................... 8-E-2 

Table 8-E.2.2 Monthly Natural Gas Price Factors for 1990–2007 for Census Division 

1.................................................................................................................. 8-E-3 

Table 8-E.2.3 Monthly Natural Gas Monthly Energy Price Factors ................................ 8-E-4 

Table 8-E.2.4 Monthly Natural Gas Prices for 2007 Using Average Price Factors 

(2008$/MMBtu)......................................................................................... 8-E-4 

Table 8-E.3.1 Average Residential LPG Prices for the U.S. (cents/gallon) ..................... 8-E-5 

Table 8-E.3.2 Monthly LPG Price Factors for 1990–2006 for the U.S............................ 8-E-6 

Table 8-E.3.3 Monthly LPG for 2006 Using Average Price Factors (2008$/MMBtu).... 8-E-7 

Table 8-E.4.1 Average Residential Electricity Prices for Census Division 1 (cents / 

kWh) .......................................................................................................... 8-E-8 

Table 8-E.4.2 Monthly Electricity Price Factors for 1990-2007 for Census Division 1 .. 8-E-8 

Table 8-E.4.3 Monthly Electricity Price Factors .............................................................. 8-E-9 

Table 8-E.4.4 Monthly Electricity Prices for 2007 Using Monthly Price Factors 

(2008¢/kWh)............................................................................................ 8-E-10 

Table 8-E.5.1 Average Residential Oil Prices for Census Division 1 (cents / gallon) ... 8-E-11 

Table 8-E.5.2 Monthly Oil Prices Factors for 1983 – 2007 for Census Division 1 ....... 8-E-12 

Table 8-E.5.3 Monthly Oil Energy Price Factors ........................................................... 8-E-13 

Table 8-E.5.4 Monthly Oil Prices for 2007 Using Average Price Factors 

(2008$/MMBtu)....................................................................................... 8-E-14
 

LIST OF FIGURES 

Figure 8-E.1.1 Monthly Energy Price Factor Calculation Process .................................... 8-E-1 

Figure 8-E.2.1 Monthly Natural Gas Price Factors for 1990–2007 for Census Division 

1.................................................................................................................. 8-E-3 

Figure 8-E.3.1 Monthly LPG Price Factors for 1990–2006 for the U.S............................ 8-E-6 

Figure 8-E.4.1 Monthly Electricity Price Factors for 1990–2007 for Census Division 

1.................................................................................................................. 8-E-9
 

Figure 8-E.5.1 Monthly Oil Prices Factors for 1983–2007 for Census Division 1 ......... 8-E-13
 

8-E-i 

EE-2006-STD-0129 COMMENT 56.10
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

APPENDIX 8-E. MONTHLY ENERGY PRICE FACTOR CALCULATIONS FOR
 

WATER HEATER ANALYSIS 

8-E.1	 INTRODUCTION 

For water heaters, DOE developed monthly energy price factors and used monthly energy 

consumption data for the life-cycle cost and payback period calculations. DOE developed 

monthly energy price factors to capture robust seasonal trends in monthly energy prices. Figure 

8-E.1.1 depicts the monthly energy price factor calculation process. 

EIA Energy 

Price Data 

Average Annual 

Energy Price by 

Division 

EIA 

Consumption 

& Consumer 

Data 

Monthly Price 

Factors 

AEO 2009 

Average Price 

Factors 

New 2007 Base 

Year Monthly 

Energy Prices 

Monthly Energy 

Price Projections 

for each Division 

Figure 8-E.1.1 Monthly Energy Price Factor Calculation Process 

8-E.2	 MONTHLY RESIDENTIAL NATURAL GAS PRICE FACTOR 

CALCULATIONS 

DOE collected historical natural gas prices from 1990 to 2007 from EIA’s Natural Gas 

Navigator.1 The Natural Gas Navigator includes annual and monthly natural gas prices for 

residential, commercial, and industrial consumers by State. DOE aggregated the data by thirteen 

geographic regions: the nine U.S. Census Divisions and four large states: New England, Middle 

Atlantic, East North Central, West North Central, South Atlantic, East South Central, West South 

Central, Mountain, Pacific, New York, California, Texas, and Florida. 

For each geographic region, DOE determined average natural gas prices from 1990 to 

2007 by weighting the average residential natural gas prices for each State by the number of 

natural gas consumers in each State.2 Table 8-E.2.1 shows the results for Census Division 1 (CD 

1). 

8-E-1 

EE-2006-STD-0129 COMMENT 56.10
 

 

 

 

 

 

 

 

Table 8-E.2.1 Average Residential Natural Gas Prices for Census Division 1 (nominal 

dollars / thousand cubic feet) 

Jan Feb March Apr May June July Aug Sep Oct Nov Dec Avg 

1990 7.34 7.89 7.94 8.17 7.34 7.68 8.40 8.75 8.55 7.72 8.26 8.06 8.01 

1991 7.95 7.96 8.07 8.40 7.34 8.13 8.76 8.88 8.71 7.56 8.53 8.28 8.22 

1992 8.16 8.13 8.08 8.30 7.19 7.96 8.46 8.78 8.53 7.32 8.34 8.20 8.12 

1993 8.25 8.20 8.29 8.49 7.73 8.41 8.89 9.25 9.13 8.00 9.17 9.22 8.59 

1994 8.83 8.77 9.05 9.43 8.58 9.15 10.24 10.58 10.12 8.84 9.94 9.30 9.40 

1995 9.13 9.03 8.88 9.20 7.93 8.77 9.84 10.19 9.75 8.92 9.40 8.76 9.15 

1996 8.81 8.97 9.00 9.29 7.10 8.50 9.53 9.92 9.72 8.41 9.57 9.54 9.03 

1997 9.44 9.71 9.51 9.64 8.30 8.99 10.29 10.73 10.45 9.03 9.73 9.75 9.63 

1998 9.24 9.28 9.37 9.40 9.39 9.75 10.76 11.35 10.98 9.81 9.73 9.78 9.90 

1999 11.27 11.32 8.82 8.99 8.46 9.10 9.24 9.60 9.06 9.04 9.48 9.07 9.45 

2000 9.23 9.17 9.57 9.92 9.64 10.25 11.85 12.50 12.43 11.34 11.56 11.51 10.75 

2001 11.27 12.42 12.96 13.50 13.57 13.87 15.03 15.77 14.71 12.57 11.95 11.22 13.24 

2002 10.27 9.90 10.09 10.23 10.04 10.43 12.40 12.77 12.83 10.83 10.44 10.89 10.93 

2003 11.01 11.12 12.29 13.52 13.94 13.57 14.84 15.82 15.24 13.25 12.79 12.56 13.33 

2004 12.77 13.75 13.90 14.37 14.85 14.87 14.35 15.31 17.39 15.43 14.88 15.00 14.74 

2005 14.26 14.10 13.09 14.29 15.10 14.87 16.94 18.01 18.93 19.66 19.45 18.65 16.45 

2006 18.81 17.98 16.72 17.01 17.32 17.76 19.44 19.90 19.04 16.62 16.42 16.58 17.80 

2007 16.47 15.83 16.66 17.06 17.36 17.63 19.46 19.63 19.05 17.97 16.74 16.49 17.53 

DOE then calculated monthly energy price factors for each year by dividing the prices for 

each month by the annual average price for each year. Table 8-E.2.2 and Figure 8-E.2.2 show the 

calculated results for Census Division 1. 

8-E-2 

EE-2006-STD-0129 COMMENT 56.10
 

 

 

 

 

 

Table 8-E.2.2 Monthly Natural Gas Price Factors for 1990–2007 for Census Division 1
 

Jan Feb March Apr May June July Aug Sep Oct Nov Dec 

1990 0.92 0.98 0.99 1.02 0.92 0.96 1.05 1.09 1.07 0.96 1.03 1.01 

1991 0.97 0.97 0.98 1.02 0.89 0.99 1.07 1.08 1.06 0.92 1.04 1.01 

1992 1.01 1.00 1.00 1.02 0.89 0.98 1.04 1.08 1.05 0.90 1.03 1.01 

1993 0.96 0.95 0.97 0.99 0.90 0.98 1.04 1.08 1.06 0.93 1.07 1.07 

1994 0.94 0.93 0.96 1.00 0.91 0.97 1.09 1.13 1.08 0.94 1.06 0.99 

1995 1.00 0.99 0.97 1.01 0.87 0.96 1.08 1.11 1.07 0.97 1.03 0.96 

1996 0.98 0.99 1.00 1.03 0.79 0.94 1.06 1.10 1.08 0.93 1.06 1.06 

1997 0.98 1.01 0.99 1.00 0.86 0.93 1.07 1.11 1.09 0.94 1.01 1.01 

1998 0.93 0.94 0.95 0.95 0.95 0.98 1.09 1.15 1.11 0.99 0.98 0.99 

1999 1.19 1.20 0.93 0.95 0.89 0.96 0.98 1.02 0.96 0.96 1.00 0.96 

2000 0.86 0.85 0.89 0.92 0.90 0.95 1.10 1.16 1.16 1.06 1.08 1.07 

2001 0.85 0.94 0.98 1.02 1.02 1.05 1.14 1.19 1.11 0.95 0.90 0.85 

2002 0.94 0.91 0.92 0.94 0.92 0.95 1.13 1.17 1.17 0.99 0.96 1.00 

2003 0.83 0.83 0.92 1.01 1.05 1.02 1.11 1.19 1.14 0.99 0.96 0.94 

2004 0.87 0.93 0.94 0.97 1.01 1.01 0.97 1.04 1.18 1.05 1.01 1.02 

2005 0.87 0.86 0.80 0.87 0.92 0.90 1.03 1.10 1.15 1.20 1.18 1.13 

2006 1.06 1.01 0.94 0.96 0.97 1.00 1.09 1.12 1.07 0.93 0.92 0.93 

2007 0.94 0.90 0.95 0.97 0.99 1.01 1.11 1.12 1.09 1.02 0.95 0.94 

Average 0.95 0.96 0.95 0.98 0.92 0.98 1.07 1.11 1.09 0.98 1.01 1.00 

0.70 

0.80 

0.90 

1.00 

1.10 

1.20 

1.30 

Jan Feb March Apr May June July Aug Sep Oct Nov Dec 

Natural Gas Price Factors 

1990 1991 1992 

1993 1994 1995 

1997 1998 1999 

2000 2001 2002 

2003 2004 2005 

2006 2007 Average 

Figure 8-E.2.2	 Monthly Natural Gas Price Factors for 1990–2007 for 

Census Division 1 

8-E-3 

EE-2006-STD-0129 COMMENT 56.10
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

DOE then averaged the monthly energy price factors for 1990 to 2007 to develop an 

average energy price factor for each month. DOE performed the same calculations for each 

geographic region to develop the average monthly energy price factors shown in Table 8-E.2.3. 

Table 8-E.2.3	 Monthly Natural Gas Monthly Energy Price Factors 

CD Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 

1 0.95 0.96 0.95 0.98 0.92 0.98 1.07 1.11 1.09 0.98 1.01 1.00 

2 0.86 0.86 0.87 0.90 0.99 1.11 1.20 1.21 1.17 1.02 0.92 0.90 

3 0.86 0.86 0.86 0.91 1.01 1.14 1.21 1.23 1.16 0.97 0.91 0.89 

4 0.83 0.81 0.82 0.86 0.97 1.14 1.23 1.29 1.23 1.05 0.91 0.87 

5 0.81 0.82 0.82 0.87 1.02 1.16 1.24 1.25 1.21 1.06 0.89 0.86 

6 0.82 0.83 0.84 0.90 1.01 1.13 1.17 1.20 1.17 1.09 0.94 0.89 

7 0.80 0.79 0.80 0.87 1.03 1.12 1.18 1.22 1.20 1.14 0.98 0.87 

8 0.82 0.84 0.86 0.90 0.99 1.15 1.18 1.23 1.18 1.05 0.93 0.86 

9 0.89 0.91 0.91 0.94 0.97 1.02 1.12 1.17 1.13 1.04 0.96 0.94 

10 0.86 0.85 0.85 0.88 0.97 1.10 1.17 1.22 1.19 1.06 0.96 0.91 

11 1.00 0.99 0.96 0.94 0.99 1.04 1.03 1.02 1.01 1.02 0.99 1.00 

12 0.79 0.80 0.81 0.91 1.04 1.15 1.17 1.21 1.22 1.12 0.94 0.84 

13 0.81 0.83 0.89 0.94 1.03 1.08 1.11 1.13 1.12 1.11 1.03 0.91 

U.S. 0.86 0.86 0.87 0.91 1.00 1.11 1.17 1.19 1.15 1.03 0.93 0.90 

DOE then applied the monthly energy price factors to the annual natural gas data 

presented in chapter 8 to develop monthly energy prices for 2007 (Table 8-E.2.4). 

Table 8-E.2.4	 Monthly Natural Gas Prices for 2007 Using Average Price Factors 

(2008$/MMBtu) 

CD Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 

1 16.79 16.92 16.80 17.37 16.37 17.27 18.92 19.70 19.36 17.35 17.97 17.65 

2 13.77 13.86 14.02 14.55 15.92 17.84 19.26 19.43 18.77 16.34 14.80 14.42 

3 11.32 11.33 11.36 11.97 13.27 15.00 15.96 16.25 15.25 12.80 11.94 11.68 

4 11.79 11.61 11.65 12.24 13.90 16.26 17.55 18.33 17.57 14.93 12.99 12.36 

5 15.35 15.45 15.62 16.56 19.30 21.92 23.44 23.61 22.93 20.00 16.82 16.24 

6 13.27 13.36 13.53 14.55 16.29 18.18 18.88 19.32 18.83 17.52 15.20 14.32 

7 12.11 12.01 12.17 13.14 15.64 17.03 17.91 18.53 18.18 17.28 14.94 13.13 

8 10.79 10.96 11.25 11.82 13.02 15.07 15.38 16.10 15.49 13.70 12.24 11.27 

9 13.41 13.59 13.69 14.07 14.54 15.27 16.83 17.49 16.93 15.56 14.44 14.05 

10 14.50 14.28 14.36 14.84 16.39 18.54 19.72 20.51 20.09 17.89 16.20 15.29 

11 11.88 11.75 11.42 11.18 11.73 12.36 12.27 12.07 11.98 12.16 11.77 11.85 

12 11.16 11.28 11.46 12.79 14.64 16.18 16.50 17.04 17.13 15.83 13.24 11.85 

13 17.49 17.90 19.19 20.26 22.20 23.24 23.84 24.39 24.17 24.00 22.29 19.69 

US 12.65 12.66 12.71 13.26 14.60 16.26 17.09 17.37 16.83 15.12 13.69 13.13 

8-E-4 

EE-2006-STD-0129 COMMENT 56.10
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

8-E.3	 MONTHLY RESIDENTIAL LPG PRICE FACTOR 

CALCULATIONS 

DOE collected historical LPG prices from 1990 to 2006 from EIA’s Petroleum 

Navigator.3 The Petroleum Navigator includes monthly U.S. LPG prices from 1990 for the 

heating season. Table 8-E.3.1 shows the U.S. residential LPG prices from 1990 to 2006. 

Table 8-E.3.1 Average Residential LPG Prices for the U.S. (cents/gallon) 

Jan Feb Mar Apr May Jun July Aug Sep Oct Nov Dec Average 

1990 106 105 101.9 104.5 

1991 100.2 93.9 88.4 88 91 91.9 92.2 

1992 89.2 88 86.7 86 87 89.5 87.7 

1993 97.9 94.6 95.6 93 87 88 88.1 92.0 

1994 88.7 90.8 90.2 85 86 86.7 87.8 

1995 88 89.2 89.8 89 89 91.4 89.4 

1996 97.3 101.3 101.8 105 112 130.9 108.0 

1997 128.7 117.4 109.1 96 97 97.8 107.6 

1998 98.1 97.4 96.1 87 88 87.9 92.4 

1999 88.7 89.1 89 96 98 100.2 93.5 

2000 108 122 120.9 128 129 139.9 124.7 

2001 166.3 155.6 143.2 114 113 112 134.0 

2002 113.4 112.9 112.3 113 116 121.1 114.8 

2003 130.7 148 165.2 131 133 138.4 141.0 

2004 149.6 153.6 150.9 162 169 171.7 159.4 

2005 172.8 172 171.7 194 194 197.4 183.8 

2006 201 200.1 198.7 194 195 197.9 197.7 

DOE calculated monthly energy prices factors for each year by dividing the monthly 

prices by the annual average price for each year. For the months when no data were available, 

DOE assigned a price factor of 1.00. Table 8-E.3.2 and Figure 8-E.3.2 show the calculated 

results for the United States. 

8-E-5 

EE-2006-STD-0129 COMMENT 56.10
 

 

 

 

 

 

 

 

 

 

Table 8-E.3.2 Monthly LPG Price Factors for 1990–2006 for the U.S.
 

Jan Feb Mar Apr May Jun July Aug Sep Oct Nov Dec 

1990 1.00 1.00 1.00 1.00 1.00 1.00 1.02 1.01 0.98 

1991 1.09 1.02 0.96 1.00 1.00 1.00 1.00 1.00 1.00 0.95 0.99 1.00 

1992 1.02 1.00 0.99 1.00 1.00 1.00 1.00 1.00 1.00 0.98 0.99 1.02 

1993 1.06 1.03 1.04 1.01 1.00 1.00 1.00 1.00 1.00 0.95 0.95 0.96 

1994 1.01 1.03 1.03 1.00 1.00 1.00 1.00 1.00 1.00 0.96 0.98 0.99 

1995 0.98 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.99 1.00 1.02 

1996 0.90 0.94 0.94 1.00 1.00 1.00 1.00 1.00 1.00 0.97 1.04 1.21 

1997 1.20 1.09 1.01 1.00 1.00 1.00 1.00 1.00 1.00 0.89 0.90 0.91 

1998 1.06 1.05 1.04 1.00 1.00 1.00 1.00 1.00 1.00 0.94 0.95 0.95 

1999 0.95 0.95 0.95 1.00 1.00 1.00 1.00 1.00 1.00 1.03 1.05 1.07 

2000 0.87 0.98 0.97 1.00 1.00 1.00 1.00 1.00 1.00 1.03 1.03 1.12 

2001 1.24 1.16 1.07 1.00 1.00 1.00 1.00 1.00 1.00 0.85 0.84 0.84 

2002 0.99 0.98 0.98 1.00 1.00 1.00 1.00 1.00 1.00 0.99 1.01 1.05 

2003 0.93 1.05 1.17 1.00 1.00 1.00 1.00 1.00 1.00 0.93 0.94 0.98 

2004 0.94 0.96 0.95 1.00 1.00 1.00 1.00 1.00 1.00 1.01 1.06 1.08 

2005 0.94 0.94 0.93 1.00 1.00 1.00 1.00 1.00 1.00 1.06 1.06 1.07 

2006 1.02 1.01 1.01 1.00 1.00 1.00 1.00 1.00 1.00 0.98 0.98 1.00 

Average 1.01 1.01 1.00 1.00 1.00 1.00 1.00 1.00 1.00 0.97 0.99 1.01 

0.75 

0.85 

0.95 

1.05 

1.15 

1.25 

1.35 

Jan Feb Mar Apr May Jun July Aug Sep Oct Nov Dec 

US LPG Price Factors 

1990 1991 1992 1993 1994 

1995 1996 1997 1998 1999 

2000 2001 2002 2003 2004 

2005 2006 Average 

Figure 8-E.3.2 Monthly LPG Price Factors for 1990–2006 for the U.S. 

DOE then averaged the yearly factors to determine U.S. average energy price factors for 

each month. The EIA data were collected without taxes, so DOE determined the average tax rate 

for the four Census Regions (Northeast, South, Midwest, and West)4 and applied it to the annual 

average data. To present the LPG price data for the same year as the other fuels (2006), DOE 

8-E-6 

EE-2006-STD-0129 COMMENT 56.10
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

scaled the 2006 prices using data in AEO2009 (see section 8.5.5) to determine the average LPG 

prices shown in Table 8-E.3.3. 

Table 8-E.3.3 Monthly LPG for 2006 Using Average Price Factors (2008$/MMBtu) 

CD Jan Feb Mar Apr May Jun July Aug Sep Oct Nov Dec 

1 30.2 30.2 29.9 29.9 29.8 29.8 29.8 29.8 29.8 29 29.5 30.3 

2 30.1 30.1 29.8 29.8 29.7 29.7 29.7 29.7 29.7 28.9 29.4 30.2 

3 23.4 23.4 23.2 23.1 23.1 23.1 23.1 23.1 23.1 22.5 22.8 23.5 

4 20.5 20.5 20.3 20.2 20.2 20.2 20.2 20.2 20.2 19.7 20 20.5 

5 28.2 28.2 27.9 27.9 27.8 27.8 27.8 27.8 27.8 27 27.5 28.2 

6 27.4 27.4 27.1 27.1 27.1 27.1 27.1 27.1 27.1 26.3 26.7 27.5 

7 25.2 25.2 24.9 24.9 24.9 24.9 24.9 24.9 24.9 24.2 24.6 25.2 

8 25 25 24.7 24.7 24.7 24.7 24.7 24.7 24.7 24 24.4 25 

9 29.2 29.2 28.9 28.9 28.9 28.9 28.9 28.9 28.9 28 28.5 29.3 

10 29.6 29.7 29.4 29.3 29.3 29.3 29.3 29.3 29.3 28.5 28.9 29.7 

11 31.1 31.2 30.8 30.8 30.8 30.8 30.8 30.8 30.8 29.9 30.4 31.2 

12 28.1 28.2 27.9 27.8 27.8 27.8 27.8 27.8 27.8 27 27.5 28.2 

13 33.2 33.2 32.9 32.8 32.8 32.8 32.8 32.8 32.8 31.9 32.4 33.3 

U.S. 26.2 26.2 26 25.9 25.9 25.9 25.9 25.9 25.9 25.2 25.6 26.3 

8-E.4	 MONTHLY RESIDENTIAL ELECTRICITY PRICE FACTOR 

CALCULATIONS 

DOE collected historical electricity prices from 1990 to 2007 from EIA’s Form 826.5 

These data are published annually and include annual electricity sales, revenues from electricity 

sales, and average price for the residential, commercial, industrial, and transportation sectors by 

State. DOE aggregated the data by thirteen geographic regions: the nine U.S. Census Divisions 

and four large states: New England, Middle Atlantic, East North Central, West North Central, 

South Atlantic, East South Central, West South Central, Mountain, Pacific, New York, 

California, Texas, and Florida. 

For each geographic region, DOE determined average electricity prices from 1990 to 

2007 by weighting the average residential electricity prices for each State by the number of 

residential electricity consumers in each State.6 Table 8-E.4.1 shows the results for Census 

Division 1. 

8-E-7 

EE-2006-STD-0129 COMMENT 56.10
 

 

 

 

 

 

 

 

 

 

 

Table 8-E.4.1 Average Residential Electricity Prices for Census Division 1 (cents / kWh)
 

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Average 

1990 9.12 9.68 9.35 9.37 9.56 9.93 9.92 9.91 10.11 10.41 10.11 10.05 9.79 

1991 10.15 10.20 9.93 10.00 10.32 10.46 10.56 10.68 10.62 10.78 10.58 10.96 10.44 

1992 10.68 10.63 10.45 10.37 10.85 10.79 11.10 11.03 11.07 11.15 11.04 11.40 10.88 

1993 10.98 10.93 10.74 11.00 11.32 11.61 11.31 11.41 11.44 11.33 11.20 11.84 11.26 

1994 11.07 11.01 10.96 11.17 11.26 11.82 11.59 11.57 11.80 11.79 11.75 11.98 11.48 

1995 11.32 11.55 11.33 11.50 11.98 11.77 12.18 11.80 11.97 12.02 11.51 12.28 11.77 

1996 11.21 11.68 11.96 11.52 11.64 12.41 11.99 12.23 11.96 11.66 11.44 12.38 11.84 

1997 11.82 11.74 12.11 11.54 12.03 12.68 12.12 12.27 12.06 12.35 12.02 12.31 12.09 

1998 11.65 11.70 11.66 11.59 11.69 11.73 11.58 11.71 11.30 11.47 11.42 11.55 11.59 

1999 10.97 11.39 11.24 11.46 11.42 11.73 11.26 11.27 11.15 11.37 11.25 10.34 11.24 

2000 11.29 10.96 10.91 11.37 11.27 11.53 11.43 11.17 11.35 11.35 11.30 11.35 11.27 

2001 11.91 11.81 11.90 12.25 12.28 12.27 12.59 12.20 12.47 12.53 12.14 11.77 12.18 

2002 11.28 11.05 11.63 11.56 11.25 11.38 11.27 11.07 11.25 11.52 11.30 11.06 11.30 

2003 10.81 11.12 11.20 11.19 11.95 12.23 11.94 12.13 12.40 12.13 12.01 11.82 11.74 

2004 11.47 11.92 11.85 11.89 12.03 12.07 12.25 12.25 11.98 11.98 11.88 11.76 11.94 

2005 12.74 13.20 12.99 13.24 13.36 13.42 13.30 13.45 14.09 13.52 14.11 13.93 13.45 

2006 15.53 16.17 15.94 16.10 16.03 15.81 15.50 16.06 16.31 15.91 15.48 16.12 15.91 

2007 17.00 16.61 16.89 16.99 16.49 17.02 16.26 16.31 16.62 16.56 16.28 15.99 16.58 

DOE then calculated monthly energy prices factors by dividing the monthly prices by the 

annual average for each year. Table 8-E.4.2 and Figure 8-E.4.2 show the calculated results for 

Census Division 1. 

Table 8-E.4.2 Monthly Electricity Price Factors for 1990-2007 for Census Division 1 

Jan Feb March April May June July Aug Sep Oct Nov Dec 

1990 0.93 0.99 0.95 0.96 0.98 1.01 1.01 1.01 1.03 1.06 1.03 1.03 

1991 0.97 0.98 0.95 0.96 0.99 1.00 1.01 1.02 1.02 1.03 1.01 1.05 

1992 0.98 0.98 0.96 0.95 1.00 0.99 1.02 1.01 1.02 1.03 1.01 1.05 

1993 0.97 0.97 0.95 0.98 1.00 1.03 1.00 1.01 1.02 1.01 0.99 1.05 

1994 0.96 0.96 0.96 0.97 0.98 1.03 1.01 1.01 1.03 1.03 1.02 1.04 

1995 0.96 0.98 0.96 0.98 1.02 1.00 1.03 1.00 1.02 1.02 0.98 1.04 

1996 0.95 0.99 1.01 0.97 0.98 1.05 1.01 1.03 1.01 0.98 0.97 1.05 

1997 0.98 0.97 1.00 0.95 1.00 1.05 1.00 1.02 1.00 1.02 0.99 1.02 

1998 1.01 1.01 1.01 1.00 1.01 1.01 1.00 1.01 0.98 0.99 0.99 1.00 

1999 0.98 1.01 1.00 1.02 1.02 1.04 1.00 1.00 0.99 1.01 1.00 0.92 

2000 1.00 0.97 0.97 1.01 1.00 1.02 1.01 0.99 1.01 1.01 1.00 1.01 

2001 0.98 0.97 0.98 1.01 1.01 1.01 1.03 1.00 1.02 1.03 1.00 0.97 

2002 1.00 0.98 1.03 1.02 1.00 1.01 1.00 0.98 1.00 1.02 1.00 0.98 

2003 0.92 0.95 0.95 0.95 1.02 1.04 1.02 1.03 1.06 1.03 1.02 1.01 

2004 0.96 1.00 0.99 1.00 1.01 1.01 1.03 1.03 1.00 1.00 0.99 0.98 

2005 0.95 0.98 0.97 0.98 0.99 1.00 0.99 1.00 1.05 1.01 1.05 1.04 

2006 0.98 1.02 1.00 1.01 1.01 0.99 0.97 1.01 1.02 1.00 0.97 1.01 

2007 1.02 1.00 1.02 1.02 0.99 1.03 0.98 0.98 1.00 1.00 0.98 0.96 

Average 0.97 0.98 0.98 0.99 1.00 1.02 1.01 1.01 1.01 1.02 1.00 1.01 

8-E-8 

EE-2006-STD-0129 COMMENT 56.10
 

 

 

 

 

 

 

 

 

 

 

 

Figure 8-E.4.2	 Monthly Electricity Price Factors for 1990–2007 for 

Census Division 1 

DOE then averaged the monthly energy prices factors for 1990 to 2007 to develop an 

average energy price factor for each month. DOE performed the same calculations for each 

geographic region to develop the average monthly energy price factors shown in Table 8-E.4.3. 

Table 8-E.4.3	 Monthly Electricity Price Factors 

CD Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 

1 0.97 0.98 0.98 0.99 1.00 1.02 1.01 1.01 1.01 1.02 1.00 1.01 

2 0.93 0.93 0.95 0.97 1.00 1.07 1.08 1.08 1.06 1.00 0.98 0.96 

3 0.92 0.94 0.96 1.00 1.03 1.06 1.05 1.05 1.05 1.03 0.98 0.94 

4 0.89 0.91 0.94 0.97 1.04 1.11 1.10 1.10 1.05 1.00 0.96 0.92 

5 0.92 0.93 0.96 0.98 1.02 1.06 1.07 1.07 1.05 1.02 0.98 0.94 

6 0.94 0.96 0.98 1.02 1.03 1.03 1.01 1.02 1.01 1.03 1.01 0.97 

7 0.90 0.94 0.97 0.99 1.02 1.06 1.05 1.05 1.06 1.03 0.98 0.94 

8 0.94 0.96 0.97 0.99 1.03 1.04 1.03 1.02 1.03 1.04 0.99 0.98 

9 0.98 0.99 0.99 0.98 0.99 0.99 1.00 1.00 1.01 1.02 1.03 1.02 

10 0.95 0.95 0.96 0.97 1.00 1.03 1.04 1.05 1.04 1.02 1.00 0.98 

11 0.99 0.98 0.97 0.98 1.00 1.02 1.05 1.04 1.00 0.96 1.00 1.02 

12 0.90 0.92 0.96 0.98 1.02 1.06 1.06 1.06 1.06 1.05 0.98 0.95 

13 0.99 1.00 1.00 1.02 1.00 0.99 0.99 1.00 1.00 1.00 1.02 1.00 

U.S. 0.94 0.95 0.97 0.99 1.02 1.04 1.05 1.05 1.03 1.01 0.99 0.97 

DOE then applied the monthly energy price factors to the annual electricity data 

presented in chapter 8 to develop monthly energy prices for 2007 (Table 8-E.4.4). 

8-E-9 

EE-2006-STD-0129 COMMENT 56.10
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Table 8-E.4.4 Monthly Electricity Prices for 2007 Using Monthly Price Factors 

(2008¢/kWh) 

CD Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 

1 16.74 16.93 16.90 16.98 17.21 17.53 17.36 17.37 17.47 17.49 17.25 17.41 

2 11.72 11.77 11.94 12.17 12.67 13.47 13.63 13.56 13.34 12.62 12.30 12.10 

3 9.36 9.63 9.81 10.23 10.54 10.81 10.73 10.70 10.72 10.59 10.05 9.62 

4 7.73 7.92 8.13 8.45 9.06 9.66 9.60 9.58 9.16 8.64 8.32 7.95 

5 9.01 9.17 9.38 9.63 10.05 10.42 10.51 10.53 10.32 10.03 9.61 9.22 

6 8.14 8.32 8.50 8.82 8.96 8.91 8.77 8.82 8.79 8.92 8.82 8.47 

7 8.38 8.67 8.95 9.20 9.45 9.81 9.71 9.77 9.82 9.59 9.12 8.76 

8 8.98 9.16 9.27 9.49 9.92 9.94 9.83 9.81 9.84 9.96 9.45 9.35 

9 9.52 9.61 9.62 9.57 9.62 9.65 9.77 9.78 9.83 9.93 9.99 9.96 

10 16.82 16.94 17.08 17.26 17.66 18.34 18.54 18.57 18.52 18.05 17.77 17.42 

11 14.73 14.57 14.51 14.54 14.95 15.21 15.61 15.56 14.87 14.37 14.86 15.13 

12 11.55 11.79 12.24 12.58 13.11 13.55 13.58 13.58 13.52 13.47 12.53 12.14 

13 11.54 11.61 11.70 11.83 11.66 11.47 11.56 11.59 11.61 11.68 11.82 11.67 

US 10.86 11.00 11.16 11.40 11.75 12.06 12.10 12.10 11.95 11.73 11.44 11.21 

8-E.5 MONTHLY RESIDENTIAL OIL PRICE FACTOR CALCULATIONS 

DOE collected historical oil prices from 1983 to 2007 from EIA’s Petroleum Navigator.3 

The Petroleum Navigator includes monthly oil prices for residential, commercial, industrial, and 

transportation consumers by Petroleum Administration for Defense Districts (PADD). The first 

four PADD follow the US Census Divisions. However, Arizona is not included in PADD for the 

Pacific Region and New Mexico is excluded altogether. In addition, data were not provided for 

the East South Central region, West South Central region, Florida, Texas, and California so 

national averages were used for these regions. The prices were aggregated by eight geographic 

regions: New England, Middle Atlantic, East North Central, West North Central, South Atlantic, 

Mountain, Pacific, and New York. 

For each geographic region, DOE determined average oil prices from 1983 to 2007 by 

weighting the average residential oil prices for each PADD by the amount of oil consumed in 

each region.7 Table 8-E.5.1 shows the results for Census Division 1. 

8-E-10 

EE-2006-STD-0129 COMMENT 56.10
 

 

 

 

 

 

 

Table 8-E.5.1 Average Residential Oil Prices for Census Division 1 (cents / gallon)
 

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Avg. 

1983 116.5 112.8 106.4 104.8 106 106.9 106.2 106.2 106.8 106.8 106.9 107.8 107.8 

1984 114.7 119.8 113.7 111.9 110.6 109.4 106.4 104.5 104.9 106.5 106.5 106.3 109.6 

1985 106.3 107.1 106.7 106.8 104.9 101.8 98.7 98.3 100.5 104.1 110.4 111.9 104.8 

1986 107.8 97.4 90.8 82.8 78.5 74.1 67.8 66.8 68.6 69.1 70.7 73.5 79.0 

1987 79.9 81.1 80.2 80 80.2 78.8 79.5 79.4 79.7 81.9 84.3 85.1 80.8 

1988 86.1 85.4 84.5 84.1 83 80.2 77.7 74.1 77.1 76.8 78.5 83.1 80.9 

1989 86.9 87.5 88.7 88.9 87.6 85 82.8 82.2 82 86.5 89.3 110.1 88.1 

1990 118 98.9 96.9 94.8 92.3 87.5 84.7 99.5 115.2 127.2 125.2 121.8 105.2 

1991 119.6 113.5 105.5 99 93.9 90.5 87.8 88 91 95.7 99.7 97.6 98.5 

1992 96.1 96 94.6 93.9 93.4 93.2 91.6 89.8 91.2 94.9 96.3 95.9 93.9 

1993 95.7 95.9 96.5 93.4 91.7 89.4 85.9 84.6 85.8 88.6 88.7 87.6 90.3 

1994 91 94.6 92.5 89 86.6 85.6 83.1 82.4 83.7 85.2 86.1 87.3 87.3 

1995 87.6 88.2 87.3 85.8 86.9 85.2 82.4 81.1 82.7 84.5 86.8 92.1 85.9 

1996 96.1 97.5 100.6 102.7 98.1 91.3 88 88.2 94.4 103.5 106.1 108.5 97.9 

1997 109 106 102.5 100.3 97.1 92.9 88.7 86.8 89 92.8 94.6 94.6 96.2 

1998 93.5 92.8 90.8 88.6 85.9 82.1 78.4 76.1 77.6 79.1 80.6 79.6 83.8 

1999 81.4 80.8 81.4 83.2 82.3 80.9 81.4 82.7 89.6 94.9 100.2 104.9 87.0 

2000 128.2 145.8 124.4 118.2 117.8 116.8 115.7 119.4 132.1 136.6 140.4 142.2 128.1 

2001 139.7 135.2 130.4 127.9 124.8 120.3 114.1 114.4 116.8 114.8 112.2 109.8 121.7 

2002 111.6 110.1 111.8 113.2 111.1 107.9 104.6 105.2 110.4 114.7 118.3 124.5 112.0 

2003 134.2 152 155.4 136.2 129.2 123.5 118.2 118.6 120.9 125 129.6 135.3 131.5 

2004 143.3 145.2 142.6 142.2 143.1 142 143.9 150.8 160.2 180.6 183.4 180.7 154.8 

2005 182.1 185.2 194.2 196.7 192 199.7 205.5 218.4 241.5 241.7 231.8 232.2 210.1 

2006 234.8 232.3 235.8 242.7 246.1 244.8 244.2 247.1 238.8 231.3 234.2 237.8 239.2 

2007 231.9 240.3 245.3 247.8 248 249.4 255.1 249.6 259.9 274.2 302.8 310.1 259.5 

DOE then calculated monthly energy price factors by dividing the monthly prices by the 

annual average price for each year. Table 8-E.5.2 and Figure 8-E.5.2 show the calculated results 

for Census Division 1. 

8-E-11 

EE-2006-STD-0129 COMMENT 56.10
 

 

 

 

Table 8-E.5.2 Monthly Oil Prices Factors for 1983 – 2007 for Census Division 1
 

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 

1983 1.08 1.05 0.99 0.97 0.98 0.99 0.98 0.98 0.99 0.99 0.99 1.00 

1984 1.05 1.09 1.04 1.02 1.01 1.00 0.97 0.95 0.96 0.97 0.97 0.97 

1985 1.01 1.02 1.02 1.02 1.00 0.97 0.94 0.94 0.96 0.99 1.05 1.07 

1986 1.36 1.23 1.15 1.05 0.99 0.94 0.86 0.85 0.87 0.87 0.90 0.93 

1987 0.99 1.00 0.99 0.99 0.99 0.97 0.98 0.98 0.99 1.01 1.04 1.05 

1988 1.06 1.06 1.04 1.04 1.03 0.99 0.96 0.92 0.95 0.95 0.97 1.03 

1989 0.99 0.99 1.01 1.01 0.99 0.96 0.94 0.93 0.93 0.98 1.01 1.25 

1990 1.12 0.94 0.92 0.90 0.88 0.83 0.81 0.95 1.10 1.21 1.19 1.16 

1991 1.21 1.15 1.07 1.01 0.95 0.92 0.89 0.89 0.92 0.97 1.01 0.99 

1992 1.02 1.02 1.01 1.00 0.99 0.99 0.98 0.96 0.97 1.01 1.03 1.02 

1993 1.06 1.06 1.07 1.03 1.02 0.99 0.95 0.94 0.95 0.98 0.98 0.97 

1994 1.04 1.08 1.06 1.02 0.99 0.98 0.95 0.94 0.96 0.98 0.99 1.00 

1995 1.02 1.03 1.02 1.00 1.01 0.99 0.96 0.94 0.96 0.98 1.01 1.07 

1996 0.98 1.00 1.03 1.05 1.00 0.93 0.90 0.90 0.96 1.06 1.08 1.11 

1997 1.13 1.10 1.07 1.04 1.01 0.97 0.92 0.90 0.93 0.96 0.98 0.98 

1998 1.12 1.11 1.08 1.06 1.03 0.98 0.94 0.91 0.93 0.94 0.96 0.95 

1999 0.94 0.93 0.94 0.96 0.95 0.93 0.94 0.95 1.03 1.09 1.15 1.21 

2000 1.00 1.14 0.97 0.92 0.92 0.91 0.90 0.93 1.03 1.07 1.10 1.11 

2001 1.15 1.11 1.07 1.05 1.03 0.99 0.94 0.94 0.96 0.94 0.92 0.90 

2002 1.00 0.98 1.00 1.01 0.99 0.96 0.93 0.94 0.99 1.02 1.06 1.11 

2003 1.02 1.16 1.18 1.04 0.98 0.94 0.90 0.90 0.92 0.95 0.99 1.03 

2004 0.93 0.94 0.92 0.92 0.92 0.92 0.93 0.97 1.03 1.17 1.18 1.17 

2005 0.87 0.88 0.92 0.94 0.91 0.95 0.98 1.04 1.15 1.15 1.10 1.11 

2006 0.98 0.97 0.99 1.01 1.03 1.02 1.02 1.03 1.00 0.97 0.98 0.99 

2007 0.89 0.93 0.95 0.95 0.96 0.96 0.98 0.96 1.00 1.06 1.17 1.19 

Average 1.04 1.04 1.02 1.00 0.98 0.96 0.94 0.94 0.98 1.01 1.03 1.05 

8-E-12 

EE-2006-STD-0129 COMMENT 56.10
 

 

 

 

 

 

 

 

 

 

 

 

 

sr

ot

c

a

F 

e

ci

r

P

l

i

O

1983 1984 1985 1986 

1.50 1987 1988 1989 1990 

1991 1992 1993 1994 

1995 1996 1997 1998 

1999 2000 2001 

1.40 

2002 

2003 2004 2005 2006 1.30 2007 Average 

1.20 

1.10 

1.00 

0.90 

0.80 

0.70 

0.60 

0.50 

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 

Figure 8-E.5.2	 Monthly Oil Prices Factors for 1983–2007 for Census 

Division 1 

DOE then averaged the monthly energy price factors for 1983 to 2007 to develop an 

average energy price factor for each month. DOE performed the same calculations for each 

geographic region to develop the average monthly energy price factors shown in Table 8-E.5.3. 

Table 8-E.5.3 Monthly Oil Energy Price Factors 

CD Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
 

1
 1.04 1.04 1.02 1.00 0.98 0.96 0.94 0.94 0.98 1.01 1.03 1.05 

2 1.04 1.04 1.02 1.00 0.98 0.96 0.93 0.94 0.98 1.01 1.03 1.06 

3 1.01 1.00 0.99 0.99 0.98 0.97 0.96 0.97 1.01 1.04 1.05 1.05 

4 1.00 0.98 0.98 0.98 0.98 0.96 0.96 1.01 1.02 1.03 1.06 1.03 

5 1.04 1.04 1.02 1.00 0.97 0.95 0.94 0.95 0.99 1.02 1.04 1.06 

6* 1.04 1.03 1.02 1.00 0.98 0.96 0.94 0.95 0.98 1.01 1.03 1.05 

7* 1.04 1.03 1.02 1.00 0.98 0.96 0.94 0.95 0.98 1.01 1.03 1.05 

8 0.98 0.97 0.98 0.99 0.98 0.96 0.95 0.98 1.03 1.05 1.07 1.04 

9 0.99 0.99 1.00 1.00 0.99 0.97 0.95 0.97 1.01 1.04 1.05 1.03 

10 1.03 1.03 1.01 1.00 0.99 0.98 0.96 0.94 0.97 1.01 1.03 1.05 

11* 1.04 1.03 1.02 1.00 0.98 0.96 0.94 0.95 0.98 1.01 1.03 1.05 

12* 1.04 1.03 1.02 1.00 0.98 0.96 0.94 0.95 0.98 1.01 1.03 1.05 

13* 1.04 1.03 1.02 1.00 0.98 0.96 0.94 0.95 0.98 1.01 1.03 1.05 

1.04 1.03 1.02 1.00 0.98 0.96 0.94 0.95 0.98 1.01 1.03 1.05 

*National Average 

US 

The EIA data were collected and the energy price factors were determined without taxes. 

DOE applied the energy price factors to historical oil prices from EIA’s Petroleum Navigator.3 

DOE then added monthly tax data from the EIA’s Short-Term Energy Outlook4 to determine the 

average oil prices shown in Table 8-E.5.4. 

8-E-13 

EE-2006-STD-0129 COMMENT 56.10
 

 

1 

2

3

4

5

6

7

8

9

10 

11

12

13

 

Table 8-E.5.4 Monthly Oil Prices for 2007 Using Average Price Factors (2008$/MMBtu)
 

CD Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 

20.96 20.92 20.53 20.14 19.79 19.33 18.89 18.97 19.68 20.36 20.79 21.24 

20.80 20.79 20.39 20.00 19.57 19.06 18.64 18.70 19.45 20.18 20.62 21.10 

20.05 19.91 19.74 19.71 19.54 19.25 19.04 19.35 20.18 20.71 20.86 20.85 

20.45 20.19 20.12 20.12 20.03 19.72 19.77 20.64 20.99 21.24 21.80 21.19 

20.58 20.47 20.11 19.67 19.20 18.81 18.59 18.84 19.47 20.10 20.47 20.90 

20.94 20.90 20.55 20.21 19.87 19.41 19.00 19.13 19.83 20.51 20.90 21.28 

20.94 20.90 20.55 20.21 19.87 19.41 19.00 19.13 19.83 20.51 20.90 21.28 

19.96 19.91 19.95 20.22 19.99 19.70 19.53 20.14 21.09 21.55 21.96 21.28 

20.67 20.74 20.97 20.97 20.77 20.25 19.90 20.18 21.02 21.65 21.85 21.56 

21.56 21.60 21.19 20.82 20.65 20.38 19.98 19.75 20.35 21.04 21.51 21.88 

21.64 21.59 21.24 20.88 20.53 20.06 19.63 19.77 20.49 21.19 21.60 21.98 

20.94 20.90 20.55 20.21 19.87 19.41 19.00 19.13 19.83 20.51 20.90 21.28 

20.47 20.43 20.09 19.75 19.42 18.98 18.57 18.70 19.39 20.05 20.43 20.80 

U.S. 20.94 20.90 20.55 20.21 19.87 19.41 19.00 19.13 19.83 20.51 20.90 21.28 

8-E-14 

EE-2006-STD-0129 COMMENT 56.10
 

 

 

 

 

 

 

 

 

 

 

 

 

REFERENCES 

1.	 U.S. Department of Energy - Energy Information Administration, Natural Gas 

Navigator. 2009. http://tonto.eia.doe.gov/dnav/ng/ng_pri_sum_dcu_nus_m.htm 

2.	 U.S. Department of Energy - Energy Information Administration, Natural Gas 

Navigator. 2007. http://tonto.eia.doe.gov/dnav/ng/ng_pri_sum_dcu_nus_m.htm 

3.	 Energy Information Administration, Petroleum Navigator, December, 2009. Washington, 

DC. <http://tonto.eia.doe.gov/dnav/pet/pet_pri_wfr_a_EPLLPA_PRS_cpgal_m.htm> 

4.	 U.S. Department of Energy - Energy Information Administration, Short-Term Energy 

Outlook. 2009. http://eia.doe.gov/steo 

5.	 U.S. Department of Energy - Energy Information Administration, Form EIA-826 

Database Monthly Electric Utility Sales and Revenue Data, 2009. 

<http://www.eia.doe.gov/cneaf/electricity/page/eia826.html> 

6.	 Energy Information Administration, Table 5. U.S. Average Monthly Bill by Sector, 

Census Division, and State 2007. 

2009<http://www.eia.doe.gov/cneaf/electricity/esr/table5.html> 

7.	 Energy Information Administration, Petroleum Navigator: Adjusted Sales of Distillate 

Fuel Oil by End Use, December, 2008. Washington, DC. 

<http://tonto.eia.doe.gov/dnav/pet/pet_cons_821dsta_a_EPD0_VAR_Mgal_a.htm> 

8-E-15 

EE-2006-STD-0129 COMMENT 56.10