## 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 AnalysesIPM 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 2010ECI_2009_to_2010 1.0342 1996ECI_Adjustment_1996 1.5358 ECI_2010 114.27 2011 ECI_2009_to_2011 1.0695 1997ECI_Adjustment_1997 1.4917 ECI_2011 118.18 2012 ECI_2009_to_2012 1.1060 1998ECI_Adjustment_1998 1.4430 ECI_2012 122.21 2013 ECI_2009_to_2013 1.1438 1999ECI_Adjustment_1999 1.3987 ECI_2013 126.39 2014ECI_2009_to_2014 1.1828 2000ECI_Adjustment_2000 1.3402 ECI_2014 130.70 2015 ECI_2009_to_2015 1.2232 2001ECI_Adjustment_2001 1.2856 ECI_2015 135.17 2016 ECI_2009_to_2016 1.2650 2002ECI_Adjustment_2002 1.2395 ECI_2016 139.78 2017 ECI_2009_to_2017 1.3082 2003ECI_Adjustment_2003 1.1943 ECI_2017 144.56 2018 ECI_2009_to_2018 1.3529 2004ECI_Adjustment_2004 1.1516 ECI_2018 149.49 2019 ECI_2009_to_2019 1.3991 2005ECI_Adjustment_2005 1.1159 ECI_2019 154.60 2020ECI_2009_to_2020 1.4469 2006ECI_Adjustment_2006 1.0825 ECI_2020 159.88 2021 ECI_2009_to_2021 1.4963 2007ECI_Adjustment_2007 1.0474 ECI_2021 165.34 2022 ECI_2009_to_2022 1.5474 2008ECI_Adjustment_2008 1.0170 ECI_2022 170.98 2023 ECI_2009_to_2023 1.6002 2009ECI_Adjustment_2009 1.0000 ECI_2023 176.82 2024ECI_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 2030ECI_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 2010ECI_2006_to_2032 1.12 ECI_2032 239.22 2033 ECI_2009_to_2033 2.2388 2011ECI_2006_to_2033 1.16 ECI_2033 247.39 2034ECI_2009_to_2034 2.3153 2012ECI_2006_to_2034 1.20 ECI_2034 255.84 2035 ECI_2009_to_2035 2.3943 2013ECI_2006_to_2035 1.24 ECI_2035 264.57 2036 ECI_2009_to_2036 2.4761 2014ECI_2006_to_2036 1.28 ECI_2036 273.61 2037 ECI_2009_to_2037 2.5607 2015ECI_2006_to_2037 1.32 ECI_2037 282.95 2038 ECI_2009_to_2038 2.6481 2016ECI_2006_to_2038 1.37 ECI_2038 292.62 2039 ECI_2009_to_2039 2.7386 2017ECI_2006_to_2039 1.42 ECI_2039 302.61 2040ECI_2009_to_2040 2.8321 2018ECI_2006_to_2040 1.46 ECI_2040 312.95 2041 ECI_2009_to_2041 2.9288 2019ECI_2006_to_2041 1.51Year Annual Avg March June Sept Dec Year Annual Adjustment

ECI_2041 323.63 2042 ECI_2009_to_2042 3.0288 2020ECI_2006_to_2042 1.57 ECI_2042 334.69 2043 ECI_2009_to_2043 3.1323 2021ECI_2006_to_2043 1.62 ECI_2043 346.12 2044ECI_2009_to_2044 3.2392 2022ECI_2006_to_2044 1.68 ECI_2044 357.94 2045 ECI_2009_to_2045 3.3499 2023ECI_2006_to_2045 1.73 ECI_2045 370.16 2046 ECI_2009_to_2046 3.4643 2024ECI_2006_to_2046 1.79 ECI_2046 382.80 2047 ECI_2009_to_2047 3.5826 2025ECI_2006_to_2047 1.85 ECI_2047 395.87 2048 ECI_2009_to_2048 3.7049 2026ECI_2006_to_2048 1.92 ECI_2048 409.39 2049 ECI_2009_to_2049 3.8315 2027ECI_2006_to_2049 1.98 ECI_2049 423.38 2050ECI_2009_to_2050 3.9623 2028ECI_2006_to_2050 2.05 ECI_2050 437.83 2051 ECI_2009_to_2051 4.0976 2029ECI_2006_to_2051 2.12 ECI_2051 452.79 2052 ECI_2009_to_2052 4.2376 2030ECI_2006_to_2052 2.19 ECI_2052 468.25 2053 ECI_2009_to_2053 4.3823 ECI_2053 484.24 2054ECI_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 2060ECI_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 2064ECI_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 2070ECI_2009_to_2070 7.7559 ECI_2070 857.02