Author: Abt Associates Inc.

Date Created: 1/30/2008

Date Modified: 5/10/2011

Purpose: Contains adjustment factors based on Electricity Price Producer Index (Electric PPI).

File Contents:

Worksheet Contents

Rates Contains adjustment factors based on Electric PPI. These adjustment factors are used to bring electricity revenue and price values 

to 2009 and state these values in 2009 dollars.

DataPull Contains original data pull and data pull information.

Input Files:

External data used in calculations/analysis:

None
PPI Commodity Data

Data extracted on: June 25, 2010

Series ID : WPU0543

Not Seasonally Adjusted

Group : Fuels and related products and power

Item : Industrial electric power

Base Date : 198200

http://data.bls.gov/PDQ/servlet/SurveyOutputServlet?series_id=WPU0543&data_tool=XGtable

http://www.bls.gov/ppi/

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

1958 20.7 20.7 20.7 20.7 20.7 20.7 20.7 20.8 20.8 20.8 20.8 20.8 20.8

1959 20.8 20.8 20.8 20.8 20.8 20.8 20.8 20.8 20.8 20.8 20.8 20.9 20.8

1960 21 21.1 21.1 21.1 21.1 21.1 21.2 21.2 21.2 21.2 21.3 21.3 21.2

1961 21.2 21.2 21.3 21.3 21.3 21.3 21.3 21.3 21.3 21.3 21.3 21.3 21.3

1962 21.3 21.6 21.6 21.6 21.6 21.6 21.6 21.5 21.5 21.5 21.5 21.5 21.5

1963 21.5 21.5 21.5 21.5 21.4 21.4 21.3 21.3 21.3 21.2 21.2 21.2 21.4

1964 21.2 21.2 20.7 21.2 21.2 21.2 21.1 21.3 21.3 21.3 21.3 21.3 21.2

1965 21.3 21.2 21.2 21.2 21.2 21.2 21.2 21.2 21.2 21.2 21.2 21.2 21.2

1966 21.1 21.1 21.1 21.1 21.1 21.1 21.1 21.1 21.1 21.1 21.1 21.2 21.1

1967 21.1 21.1 21.1 21.1 21.1 21.1 21.1 21.1 21.2 21.2 21.2 21.2 21.1

1968 21.2 21.2 21.3 21.3 21.3 21.3 21.3 21.3 21.4 21.4 21.4 21.4 21.3

1969 21.4 21.4 21.4 21.5 21.5 21.5 21.5 21.7 21.8 21.8 21.8 21.9 21.6

1970 21.9 21.9 21.9 21.9 22.1 22.3 22.6 22.6 22.9 23.1 23.2 23.7 22.5

1971 23.8 24 24.3 24.4 24.5 24.6 24.9 25.3 25.2 25.2 25.3 25.9 24.8

1972 25.6 25.9 25.9 26 26.2 26.2 26.3 26.3 26.4 26.5 26.5 26.6 26.2

1973 26.8 27.3 27.5 27.7 27.8 27.7 27.9 27.9 28.3 28.7 29 29.7 28

1974 30.1 31.1 32.6 33.6 35.3 36.8 37.7 38.5 39.1 40.4 40.8 41.2 36.4

1975 41.9 42.9 44 44.9 44.1 43.6 43.9 44.5 45.2 45.6 45.9 45.5 44.3

1976 45.7 46 46.7 47.5 47.4 47.6 48.4 49 49.4 49 49.4 49.1 47.9

1977 49.6 51.1 52.5 54.2 54.4 54.1 55.5 56.9 56.2 56.5 55.4 55.4 54.3

1978 56.1 56.9 59 59.4 60.2 60.6 59.7 59.5 59.1 59.6 59.5 59.7 59.1

1979 59.9 60 61.7 62.7 63.9 63.8 65 66.1 66.4 67.5 68 69.5 64.5

1980 70.7 71.9 73.6 75 76.8 78.3 79.4 80.4 81.9 82.3 81.6 82.1 77.8

1981 83.1 84.2 85.3 85.6 87.5 89 90.7 93.8 93 92.4 92.4 93.7 89.2

1982 96.1 96.2 99.8 100 99.7 99.7 102.2 102 101.8 100.7 100.2 101.7 100

1983 101.9 101.8 101.8 101.5 102.1 103.6 104.7 104.4 104.6 104.8 103.2 103.1 103.1

1984 103.8 104.6 105.3 106.8 107.5 109.6 110.9 111.5 111.5 110.2 109.6 109.5 108.4

1985 110.8 110.8 111.4 112.1 111.9 113.9 114 114.5 114.2 113.6 113.1 112.9 112.8

1986 114.2 115 114.4 113.7 114.1 115.3 116.2 116.3 116.3 113 112.7 112.3 114.5

1987 110.3 109.8 110.2 109.9 111.8 113.9 116.2 115.7 115.5 111 109.2 109.6 111.9

1988 108.8 109 109 109.1 108.9 117.2 118.2 118.3 118.5 114.2 109.2 110.5 112.6
Year Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Ann

1989 112 112 112.3 112.4 113.6 119.8 122.2 122.4 122.5 117.2 113.5 114.2 116.2

1990 114.9 115 115.4 115.1 117 123.9 124.4 124.6 125 121.2 120.2 118.9 119.6

1991 124.2 124.3 124.3 124.7 128.2 132.6 134.5 133.8 133.8 128.3 123.1 125.1 128.1

1992 125.9 125.3 125.8 124.8 128.5 134.8 135.6 135.1 135.9 131.2 125.5 126.7 129.6

1993 127.1 126.4 126.7 126.8 127.5 136.9 137.1 137.2 137.6 131.9 126.3 126 130.6

1994 126.2 125.9 125.8 125.4 126 133.5 134.5 134.5 134.9 129.1 127 127.4 129.2

1995 127.6 128 128.3 126.4 130.2 135.3 136.6 136.5 133.7 131.4 127.6 127.7 130.8

1996 127.9 127.1 127.8 129.1 135 137.5 136 136.2 136.2 131.2 127.1 127.7 131.6

1997 128.3 128.1 128.2 127.3 129.7 135.1 135.9 134.7 136 130.1 127.9 128.3 130.8

1998 127.4 127.2 126.7 126.4 129.2 133.8 134.8 135.2 135.2 130.4 127.6 126.6 130

1999 126.1 125.5 125.5 125.2 127.4 131.6 133.9 133.9 134.1 129.5 127.5 126.5 128.9

2000 126.8 126.7 126.7 126.8 128.6 133.6 136.2 137.4 137.8 134.1 130.9 132.7 131.5

2001 136.4 136.4 136.5 135.1 136.2 148.4 149.5 148.9 148.2 143.8 137.3 136.9 141.1

2002 136.3 135.4 135.7 135.4 137.9 143.6 144.9 145 145.8 140 139.5 139.6 139.9

2003 140.3 140.6 143.3 144.3 145.1 148.3 151.6 151.3 152 147.4 142.7 142.9 145.8

2004 143.1 143.1 143.1 143.1 144.2 152.4 152.2 154 154 145.8 144.9 146.2 147.2

2005 148.9 148 148.1 148.7 151.1 159.7 162.1 162.5 162.8 159.5 161.1 161.4 156.2

2006 167 168.6 167.4 169.6 170.8 181.2 181.9 180.2 181 171.2 167.2 167.8 172.8

2007 171.9 175.7 172.1 173.1 179.2 186.7 187 187.6 188.4 182.7 180.3 180 180.4

2008 181.9 180 183.1 185.2 189.5 191.9 196.1 197.1 195.9 193 187.7 188.3 189.1

2009 190.3 190.3 187.6 186.9 190.5 193.3 196.2 194.7 194.9 189.9 186 186 190.6

2010 186.3 186.1 184.2 187.8 193.3 198.6
Dollar Year for Analyses

2009

ANNUAL 

AVG JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Year Annual Adjustment

Actual 2003 104.22%

Elect PPI 1998 130.00 127.40 127.20 126.70 126.40 129.20 133.80 134.80 135.20 135.20 130.40 127.60 126.60 2004 100.96%

Elect PPI 1999 128.90 126.10 125.50 125.50 125.20 127.40 131.60 133.90 133.90 134.10 129.50 127.50 126.50 2005 106.11%

Elect PPI 2000 131.50 126.80 126.70 126.70 126.80 128.60 133.60 136.20 137.40 137.80 134.10 130.90 132.70 2006 110.63%

Elect PPI 2001 141.10 136.40 136.40 136.50 135.10 136.20 148.40 149.50 148.90 148.20 143.80 137.30 136.90 2007 104.40%

Elect PPI 2002 139.90 136.30 135.40 135.70 135.40 137.90 143.60 144.90 145.00 145.80 140.00 139.50 139.60 2003 104.22%

Elect PPI 2003 145.80 140.30 140.60 143.30 144.30 145.10 148.30 151.60 151.30 152.00 147.40 142.70 142.90 2004 100.96%

Elect PPI 2004 147.20 143.10 143.10 143.10 143.10 144.20 152.40 152.20 154.00 154.00 145.80 144.90 146.20 2005 106.11%

Elect PPI 2005 156.20 148.90 148.00 148.10 148.70 151.10 159.70 162.10 162.50 162.80 159.50 161.10 161.40 2006 110.63%

Elect PPI 2006 172.80 167.00 168.60 167.40 169.60 170.80 181.20 181.90 180.20 181.00 171.20 167.20 167.80 2007 104.40%

Elect PPI 2007 180.40 171.90 175.70 172.10 173.10 179.20 186.70 187.00 187.60 188.40 182.70 180.30 180.00 2008 104.82%

Elect PPI 2008 189.10 181.90 180.00 183.10 185.20 189.50 191.90 196.10 197.10 195.90 193.00 187.70 188.30 2009 100.79%

Elect PPI 2009 190.60 190.30 190.30 187.60 186.90 190.50 193.30 196.20 194.70 194.90 189.90 186.00 186.00 Average 105.31%

Projected Estimates

Elect PPI 2010 200.72 vlookup--do not delete

Elect PPI 2011 211.37 2010 PPI_Adjustment_2009_to_2010 1.0531

Elect PPI 2012 222.59 2011 PPI_Adjustment_2009_to_2011 1.1090

Elect PPI 2013 234.40 2012 PPI_Adjustment_2009_to_2012 1.1678

Elect PPI 2014 246.84 2013 PPI_Adjustment_2009_to_2013 1.2298

Elect PPI 2015 259.94 2014 PPI_Adjustment_2009_to_2014 1.2951

Elect PPI 2016 273.74 2015 PPI_Adjustment_2009_to_2015 1.3638

Elect PPI 2017 288.26 2016 PPI_Adjustment_2009_to_2016 1.4362

Elect PPI 2018 303.56 2017 PPI_Adjustment_2009_to_2017 1.5124

Elect PPI 2019 319.67 2018 PPI_Adjustment_2009_to_2018 1.5927

Elect PPI 2020 336.64 2019 PPI_Adjustment_2009_to_2019 1.6772

Elect PPI 2021 354.51

Elect PPI 2022 373.32

Elect PPI 2023 393.13

Elect PPI 2024 414.00

Elect PPI 2025 435.97

Elect PPI 2026 459.11

Elect PPI 2027 483.47

Elect PPI 2028 509.13

Elect PPI 2029 536.15

Elect PPI 2030 564.61
PPI_Adjustment_1998 1.47

PPI_Adjustment_1999 1.48

PPI_Adjustment_2000 1.45

PPI_Adjustment_2001 1.35

PPI_Adjustment_2002 1.36

PPI_Adjustment_2003 1.31

PPI_Adjustment_2004 1.29

PPI_Adjustment_2005 1.22

PPI_Adjustment_2006 1.10

PPI_Adjustment_2007 1.06

PPI_Adjustment_2008 1.01

PPI_Adjustment_2009 1.00

PPI_Adjustment_1999_to_2015 2.02

PPI_Adjustment_2007_to_2015 1.44

PPI_Adjustment_2008_to_2015 1.37

PPI_Adjustment_1999_to_2017 2.24

PPI_Adjustment_2007_to_2017 1.60

PPI_Adjustment_2008_to_2017 1.52