Author: Abt Associates Inc.

Date Created: 6/12/2008

Date Modified: 5/10/2011

Purpose: Contains adjustment factors based on Employment Cost Index (ECI).

File Contents:

Worksheet Contents

Rates Contains adjustment factors based on Employment Cost Index (ECI). These adjustment factors are used to bring 

administrative cost values to a given year and state these values in dollars of that year.

DataPullInfo Contains data pull information, including the date of the data pull and sources.

Input Files:

External data used in calculations/analysis:

None
Data Source: Employment Cost Index Historical Listing Current-Dollar March 2001 - December 2008

-->Employment Cost Index for Total Compensation by occupational group and industry (Seasonally Adjusted)

---->Data for "Civilian Workers"

Employment Cost Index Historical Listing Current-dollar 1975-2005

-->TABLE 1a. EMPLOYMENT COST INDEX (COMPENSATION), CIVILIAN, STATE AND LOCAL GOVERNMENT, AND PRIVATE 

INDUSTRY WORKERS2 BY OCCUPATION AND INDUSTRY GROUP (Seasonally adjusted)

---->Data for "Civilian Workers"

Date Downloaded: 25/07/2010 Last Revised: April 30, 2010

Created By: Bureau of Labour Statistics (BLS)

Available at: http://www.bls.gov/ncs/ect/ectsfact.htm (http://www.bls.gov/web/echistrynaics.pdf)

Notes: ECI values for 2001 through 2005 are available from both documents. The values used here are taken from the 1975-2005 document.
Dollar Year for Analyses IPM Dollar Year

2009 2006

Civilian Workers

Year Annual Avg March June Sept Dec Year Annual Adjustment

Actual 2000 1.04367

ECI_1996 71.95 71.2 71.7 72.2 72.7 2001 1.04245

ECI_1997 74.08 73.2 73.8 74.3 75.0 2002 1.03723

ECI_1998 76.58 75.6 76.2 77.0 77.5 2003 1.03786

ECI_1999 79.00 77.8 78.6 79.4 80.2 2004 1.03702

ECI_2000 82.45 81.2 82.1 82.9 83.6 2005 1.03205

ECI_2001 85.95 84.7 85.5 86.4 87.2 2006 1.03080

ECI_2002 89.15 88.0 88.9 89.5 90.2 2007 1.03355

ECI_2003 92.53 91.3 92.1 93.0 93.7 2008 1.02986

ECI_2004 95.95 94.7 95.6 96.4 97.1 2009 1.01703

ECI_2005 99.03 97.9 98.6 99.4 100.2 Average 1.03415

ECI_2006 102.08 100.7 101.6 102.6 103.4

ECI_2007 105.50 104.2 105.1 105.9 106.8

ECI_2008 108.65 107.6 108.3 109.1 109.6 vlookup--do not delete vlookup--do not delete

ECI_2009 110.50 109.9 110.3 110.7 111.1 ↓ Adjustment from 2009 Dollars ↓ Adjustments to 2009 Dollars

Projected Estimates 2010 ECI_2009_to_2010 1.0342 1996 ECI_Adjustment_1996 1.5358

ECI_2010 114.27 2011 ECI_2009_to_2011 1.0695 1997 ECI_Adjustment_1997 1.4917

ECI_2011 118.18 2012 ECI_2009_to_2012 1.1060 1998 ECI_Adjustment_1998 1.4430

ECI_2012 122.21 2013 ECI_2009_to_2013 1.1438 1999 ECI_Adjustment_1999 1.3987

ECI_2013 126.39 2014 ECI_2009_to_2014 1.1828 2000 ECI_Adjustment_2000 1.3402

ECI_2014 130.70 2015 ECI_2009_to_2015 1.2232 2001 ECI_Adjustment_2001 1.2856

ECI_2015 135.17 2016 ECI_2009_to_2016 1.2650 2002 ECI_Adjustment_2002 1.2395

ECI_2016 139.78 2017 ECI_2009_to_2017 1.3082 2003 ECI_Adjustment_2003 1.1943

ECI_2017 144.56 2018 ECI_2009_to_2018 1.3529 2004 ECI_Adjustment_2004 1.1516

ECI_2018 149.49 2019 ECI_2009_to_2019 1.3991 2005 ECI_Adjustment_2005 1.1159

ECI_2019 154.60 2020 ECI_2009_to_2020 1.4469 2006 ECI_Adjustment_2006 1.0825

ECI_2020 159.88 2021 ECI_2009_to_2021 1.4963 2007 ECI_Adjustment_2007 1.0474

ECI_2021 165.34 2022 ECI_2009_to_2022 1.5474 2008 ECI_Adjustment_2008 1.0170

ECI_2022 170.98 2023 ECI_2009_to_2023 1.6002 2009 ECI_Adjustment_2009 1.0000

ECI_2023 176.82 2024 ECI_2009_to_2024 1.6549

ECI_2024 182.86 2025 ECI_2009_to_2025 1.7114 ECI_Feb2009_to_2009 1.0055

ECI_2025 189.11 2026 ECI_2009_to_2026 1.7698

ECI_2026 195.57 2027 ECI_2009_to_2027 1.8303

ECI_2027 202.24 2028 ECI_2009_to_2028 1.8928

ECI_2028 209.15 2029 ECI_2009_to_2029 1.9574

ECI_2029 216.29 2030 ECI_2009_to_2030 2.0243 Employment Cost Index (ECI)

ECI_2030 223.68 2031 ECI_2009_to_2031 2.0934 vlookup--do not delete

ECI_2031 231.32 2032 ECI_2009_to_2032 2.1649 2010 ECI_2006_to_2032 1.12

ECI_2032 239.22 2033 ECI_2009_to_2033 2.2388 2011 ECI_2006_to_2033 1.16

ECI_2033 247.39 2034 ECI_2009_to_2034 2.3153 2012 ECI_2006_to_2034 1.20

ECI_2034 255.84 2035 ECI_2009_to_2035 2.3943 2013 ECI_2006_to_2035 1.24

ECI_2035 264.57 2036 ECI_2009_to_2036 2.4761 2014 ECI_2006_to_2036 1.28

ECI_2036 273.61 2037 ECI_2009_to_2037 2.5607 2015 ECI_2006_to_2037 1.32

ECI_2037 282.95 2038 ECI_2009_to_2038 2.6481 2016 ECI_2006_to_2038 1.37

ECI_2038 292.62 2039 ECI_2009_to_2039 2.7386 2017 ECI_2006_to_2039 1.42

ECI_2039 302.61 2040 ECI_2009_to_2040 2.8321 2018 ECI_2006_to_2040 1.46

ECI_2040 312.95 2041 ECI_2009_to_2041 2.9288 2019 ECI_2006_to_2041 1.51
Year Annual Avg March June Sept Dec Year Annual Adjustment

ECI_2041 323.63 2042 ECI_2009_to_2042 3.0288 2020 ECI_2006_to_2042 1.57

ECI_2042 334.69 2043 ECI_2009_to_2043 3.1323 2021 ECI_2006_to_2043 1.62

ECI_2043 346.12 2044 ECI_2009_to_2044 3.2392 2022 ECI_2006_to_2044 1.68

ECI_2044 357.94 2045 ECI_2009_to_2045 3.3499 2023 ECI_2006_to_2045 1.73

ECI_2045 370.16 2046 ECI_2009_to_2046 3.4643 2024 ECI_2006_to_2046 1.79

ECI_2046 382.80 2047 ECI_2009_to_2047 3.5826 2025 ECI_2006_to_2047 1.85

ECI_2047 395.87 2048 ECI_2009_to_2048 3.7049 2026 ECI_2006_to_2048 1.92

ECI_2048 409.39 2049 ECI_2009_to_2049 3.8315 2027 ECI_2006_to_2049 1.98

ECI_2049 423.38 2050 ECI_2009_to_2050 3.9623 2028 ECI_2006_to_2050 2.05

ECI_2050 437.83 2051 ECI_2009_to_2051 4.0976 2029 ECI_2006_to_2051 2.12

ECI_2051 452.79 2052 ECI_2009_to_2052 4.2376 2030 ECI_2006_to_2052 2.19

ECI_2052 468.25 2053 ECI_2009_to_2053 4.3823

ECI_2053 484.24 2054 ECI_2009_to_2054 4.5319

ECI_2054 500.78 2055 ECI_2009_to_2055 4.6867

ECI_2055 517.88 2056 ECI_2009_to_2056 4.8468

ECI_2056 535.57 2057 ECI_2009_to_2057 5.0123

ECI_2057 553.86 2058 ECI_2009_to_2058 5.1835

ECI_2058 572.77 2059 ECI_2009_to_2059 5.3605

ECI_2059 592.33 2060 ECI_2009_to_2060 5.5436

ECI_2060 612.56 2061 ECI_2009_to_2061 5.7329

ECI_2061 633.48 2062 ECI_2009_to_2062 5.9287

ECI_2062 655.12 2063 ECI_2009_to_2063 6.1311

ECI_2063 677.49 2064 ECI_2009_to_2064 6.3405

ECI_2064 700.63 2065 ECI_2009_to_2065 6.5571

ECI_2065 724.56 2066 ECI_2009_to_2066 6.7810

ECI_2066 749.30 2067 ECI_2009_to_2067 7.0126

ECI_2067 774.89 2068 ECI_2009_to_2068 7.2521

ECI_2068 801.35 2069 ECI_2009_to_2069 7.4997

ECI_2069 828.72 2070 ECI_2009_to_2070 7.7559

ECI_2070 857.02