The URL can be used to link to this page

Home My WebLink About14 - Salaries Payable CITY OF BROOKLYN CENTER SALARIES PAYABLE 12/31/07 FUND NAME Salaries ACCOUNT /DESCRIPTION Payable MAJOR FUNDS: GENERALFUND 10 100 -2110 SALARIES AND WAGES PAYABLE 239 90400 -2015 VOUCHERS PAYABLE - 90400 -2110 SALARIES AND WAGES PAYABLE - 90400 -2112 FEDERAL TAX WITHHELD 90400 -2114 MINNESOTA TAX WITHHELD - 90400 -2116 GARNISHMENTS 1 90400 -2118 UNITED WAY PAYABLE - 90400 -2120 PERA DEFINED CONTRIBUTION 68.48 90400 -2128 ACCRUED PERA COORDINATED 28 90400 -2132 ACCRUED PERA POLICE & FIRE 24 90400 -2136 ACCRUED FICA PAYABLE - 90400 -2140 ACCRUED MEDICARE PAYABLE - 90400 -2144 ACCRUED WORKERS COMP INS PAY - 90400 -2145 VE BA PAYABLE 1 90400 -2150 MEDICA HIGH PAYABLE 796.34 90400 -2152 MEDICA ELECT PAYABLE (2,627.69) 90400 -2156 DENTAL PAYABLE (209.00) 90400 -2158 LIFE INSURANCE PAYABLE 3.65 90400 -2161 M S RS PAYABLE - 90400 -2162 ICMA PAYABLE 16 90400 -2163 POST EMPLOYMENT HEALTH SAVINGS 231.64 90400 -2170 MEDICAL EXPENSE ACCT 6 90400 -2172 DEPENDENT CARE EXPENSE 3 90400 -2174 SHORT TERM DISABILITY (84.79) 90400 -2176 LONG TERM DISABILITY - 90400 -2184 MISC PAYROLL PAYABLE - 90400 -2188 49ER PENSION PAYABLE 3 90400 -2190 49ER UNION DUES 750.00 90400 -2192 LELS UNION DUES 1 TOTAL GENERAL FUND 326,827.92 TIF DISTRICT NO 3 27800 -2110 SALARIES AND WAGES PAYABLE 620.96 ENTERPRISE FUNDS: MUNICIPAL LIQUOR 60900 -2110 SALARIES AND WAGES PAYABLE 12 CENTERBROOK GOLF COURSE 61300-2110 SALARIES AND WAGES PAYABLE 1 EARLE BROWN HERITAGE CENTER 61700-2110 SALARIES AND WAGES PAYABLE 16 WATER UTILITY 60100-2110 SALARIES AND WAGES PAYABLE 9 SANITARY SEWER UTILITY 60200 -2110 SALARIES AND WAGES PAYABLE 2 STORM SEWER UTILITY 65100-2110 SALARIES AND WAGES PAYABLE 1 TOTAL ENTERPRISE FUNDS 44,968.57 CITY OF BROOKLYN CENTER SALARIES PAYABLE 12/31/07 FUND NAME Salaries ACCOUNT /DESCRIPTION Payable NONMAJOR FUNDS: ECONOMIC DEVELOPMENT AUTHORITY 20300 -2110 SALARIES AND WAGES PAYABLE 3 CITY INITIATIVES GRANT 28600 -2110 SALARIES AND WAGES PAYABLE 6 CENTRAL GARAGE 70100-2110 SALARIES AND WAGES PAYABLE 5 TOTAL ACCRUED LIABILITIES 388,320.02 R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 1 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 10100 GENERAL FUND 2110 SALARIES AND WAGES PAYABLE 239,500.30- 187,281.83- 239,500.30- 52,218.47- 10100 GENERAL FUND 239,500.30- 187,281.83- 239,500.30- 52,218.47- R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 2 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 20300 EDA FUND 2110 SALARIES AND WAGES PAYABLE 3,941.20- 2,723.21- 3,941.20- 1,217.99- 20300 EDA FUND 3,941.20- 2,723.21- 3,941.20- 1,217.99- R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 3 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 27600 TIF DISTRICT #1- BROOKWOOD HSG R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 4 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 27700 TIF DISTRICT #2 -EBHC 2110 SALARIES AND WAGES PAYABLE 193.52- 193.52 27700 TIF DISTRICT #2 -EBHC 193.52- 193.52 R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 5 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 27800 TIF DISTRICT #3 2110 SALARIES AND WAGES PAYABLE 620.96- 880.99- 620.96- 260.03 27800 TIF DISTRICT #3 620.96- 880.99- 620.96- 260.03 R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 6 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 27900 TIF DIST #4- FRANCE AVE BUS PK R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 7 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 28600 CITY INITIATIVES GRANT FUND 2110 SALARIES AND WAGES PAYABLE 6,052.61- 2,260.71- 6,052.61- 3,791.90- 28600 CITY INITIATIVES GRANT FUND 6,052.61- 2,260.71- 6,052.61- 3,791.90- R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 8 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 37600 TAX INCREMENT BONDS -1991A R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 9 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 37700 TAX INCREMENT BONDS -1992A R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 10 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 37800 TAX INCREMENT BONDS -1995A R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 11 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 37900 GO TAX INCREMENT REFI -2004B R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 12 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 38000 GO TAX INCREMENT BONDS -2004D R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 13 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 40100 CAPITAL IMPROVEMENTS FUND R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 14 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 40200 MUNICIPAL STATE AID CONSTRUCT R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 15 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 40600 CAPITAL RESERVE EMERGENCY FUND R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 16 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 40700 INFRASTRUCTURE CONSTRUCTION 2110 SALARIES AND WAGES PAYABLE 2,298.90- 2,298.90 40700 INFRASTRUCTURE CONSTRUCTION 2,298.90- 2,298.90 R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 17 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 60100 WATER UTILITY FUND 2110 SALARIES AND WAGES PAYABLE 9,591.88- 7,398.53- 9,591.88- 2,193.35- 60100 WATER UTILITY FUND 9,591.88- 7,398.53- 9,591.88- 2,193.35- R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 18 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 60200 SEWER UTILITY FUND 2110 SALARIES AND WAGES PAYABLE 2,931.91- 3,738.38- 2,931.91- 806.47 60200 SEWER UTILITY FUND 2,931.91- 3,738.38- 2,931.91- 806.47 R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 19 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 60900 BROOKLYN CENTER LIQUOR 2110 SALARIES AND WAGES PAYABLE 12,471.22- 8,258.27- 9,778.43- 4,212.95- 2,692.79- 60900 BROOKLYN CENTER LIQUOR 12,471.22- 8,258.27- 9,778.43- 4,212.95- 2,692.79- R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 20 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 61300 CENTERBROOK GOLF COURSE 2110 SALARIES AND WAGES PAYABLE 1,487.05- 1,170.13- 1,487.05- 316.92- 61300 CENTERBROOK GOLF COURSE 1,487.05- 1,170.13- 1,487.05- 316.92- R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 21 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 61700 EARLE BROWN HERITAGE CENTER 2110 SALARIES AND WAGES PAYABLE 16,937.46- 13,634.57- 16,744.96- 3,302.89- 192.50- 61700 EARLE BROWN HERITAGE CENTER 16,937.46- 13,634.57- 16,744.96- 3,302.89- 192.50- R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 22 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 65100 STORM SEWER UTILITY FUND 2110 SALARIES AND WAGES PAYABLE 1,549.05- 1,353.32- 1,549.05- 195.73- 65100 STORM SEWER UTILITY FUND 1,549.05- 1,353.32- 1,549.05- 195.73- R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 23 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 65200 STREET LIGHT UTILITY FUND R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 24 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 65300 RECYCLING FUND R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 25 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 70100 CENTRAL GARAGE 2110 SALARIES AND WAGES PAYABLE 5,908.76- 6,033.21- 5,908.76- 124.45 70100 CENTRAL GARAGE 5,908.76- 6,033.21- 5,908.76- 124.45 R10111 B CITY OF BROOKLYN CENTER 2/20/2008 11:17:30 LOGIS0004 Balance Sheet Page - 26 As of December 31, 2007 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Amounts * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** * * * * * * * * * * * * * * * * ** Change * * * * * * * * * * * * * * * * ** Description Current Last Month End Last Year End This Month This Year 90400 PAYROLL FUND 2110 SALARIES AND WAGES PAYABLE 51,834.93- 51,834.93 90400 PAYROLL FUND 51,834.93- 51,834.93 Post Emp Benefits Payable current liability Effective Prem JANUARY 2008 Date of Rate Premium City Employee Last Change Code 1/1/2007 1 RC $ 497.23 $ 497.23 6/1/2004 2RE -C $ 1,057.86 $ 497.23 $ 560.63 10/1/2004 1 RC $ 497.23 $ 497.23 10/1/2004 1 RC $ 497.23 $ 497.23 8/1/2007 1 RE $ 497.23 $ 497.23 8/1/2007 1 RC $ 497.23 $ 497.23 1/1/2004 1 RC $ 497.23 $ 497.23 1/1/2005 1 RC $ 497.23 $ 497.23 1/1/2004 1 RC $ 497.23 $ 497.23 5/1/2005 1 RE $ 497.23 $ 497.23 3/1/2006 1 RC $ 497.23 $ 497.23 1/1/2004 1 RC $ 497.23 $ 497.23 1/1/2008 1 RE $ 497.23 $ 497.23 1/1/2004 1 RC $ 497.23 $ 497.23 1/1/2004 2RE -C $ 1 7 057.86 $ 497.23 $ 560.63 8/1/2007 1 RC $ 497.23 $ 497.23 1/1/2004 1 RC $ 497.23 $ 497.23 1/1/2004 4RE -CT $ 1 1 308.91 $ 751.00 $ 557.91 $ 497.23 $ 497.23 12/31/2007 Ending 2007 Police Qualification Participation (last mo.) Date Date Date Date Service Age Rule Start End 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 01/01/2007 12/31/2016 12 12 12 12 12 12 12 12 12 0 0 0 0 05/31/2014 12 12 12 12 12 12 5 0 0 0 0 0 0 09/30/2014 12 12 12 12 12 12 9 0 0 0 0 0 0 08/01/2008 07/31/2018 5 12 12 12 12 12 12 12 12 12 7 0 0 08/01/2007 01/31/2011 12 12 12 1 0 0 0 0 0 0 0 0 0 01/31/2008 1 0 0 0 0 0 0 0 0 0 0 0 0 06/01/2006 05/31/2016 12 12 12 12 12 12 12 12 5 0 0 0 0 07/01/2005 06/30/2015 12 12 12 12 12 12 12 6 0 0 0 0 0 11/30/2009 12 11 0 0 0 0 0 0 0 0 0 0 0 01/31/2009 12 1 0 0 0 0 0 0 0 0 0 0 0 01/31/2014 12 12 12 12 12 12 1 0 0 0 0 0 0 08/31/2014 12 12 12 12 12 12 8 0 0 0 0 0 0 03/31/2009 12 3 0 0 0 0 0 0 0 0 0 0 0 1 T MANDATE, NOT OPEB ? ?? 07/31 /2031 12 12 12 12 12 12 12 12 12 12 12 12 12 01/13/2012 12 12 12 12 1 0 0 0 0 0 0 0 0 06/30/2032 12 12 12 12 12 12 12 12 12 12 12 12 12 0513112011 38 61 99 2011 12 12 12 5 0 0 0 0 0 0 0 0 0 0913012011 38 61 99 2011 12 12 12 9 0 0 0 0 0 0 0 0 0 0212912008 37 64 101 2008 2 0 0 0 0 0 0 0 0 0 0 0 0 0113112010 34 63 97 2009 12 1 0 0 0 0 0 0 0 0 0 0 0 0913012012 33 60 93 2012 12 12 12 12 9 0 0 0 0 0 0 0 0 0410112009 0913012017 32 55 87 2009 2017 0 9 12 12 12 12 12 12 12 9 0 0 0 0410112011 0413012020 31 52 83 2011 2020 0 0 0 9 12 12 12 12 12 12 12 12 4 0310112010 0212812017 30 55 85 2010 2017 0 0 10 12 12 12 12 12 12 2 0 0 0 0210112014 0113112024 29 48 77 2014 2024 0 0 0 0 0 0 11 12 12 12 12 12 12 0510112013 0413012022 29 50 79 2013 2022 0 0 0 0 0 8 12 12 12 12 12 12 12 0710112011 0113112018 28 55 83 2011 2017 0 0 0 6 12 12 12 12 12 1 0 0 0 1110112009 1013112014 28 58 86 2009 2014 0 2 12 12 12 12 10 0 0 0 0 0 0 02/08/2008 02/08/2008 0310112013 0212812023 27 49 76 2008 2023 0 0 0 0 0 10 12 12 12 12 12 12 12 1210112012 1113012019 27 53 80 2012 2019 0 0 0 0 1 12 12 12 12 12 12 11 0 0710112011 0313112017 27 55 82 2011 2017 0 0 0 6 12 12 12 12 12 3 0 0 0 1110112009 1013112012 26 60 86 2009 2012 0 0 2 12 10 0 0 0 0 0 0 0 0 1010112016 1113012025 26 47 73 2016 2025 0 0 0 0 0 0 0 0 3 12 12 12 12 0710112015 0913012022 25 50 75 2015 2022 0 0 0 0 0 0 0 3 12 12 12 12 12 09/19/2008 09/19/2008 1010112013 0913012023 24 49 73 2008 2023 0 0 0 0 0 3 12 12 12 12 12 12 12 0810112018 0413012028 24 44 68 2018 2028 0 0 0 0 0 0 0 0 0 0 5 12 12 0410112014 0313112018 23 54 77 2014 2018 0 0 0 0 0 0 9 12 12 12 3 0 0 12/12/2004 12/12/2010 0110112010 1213112019 22 53 75 2010 2019 0 0 0 0 0 0 0 0 12 12 12 12 0 06/15/2002 01/06/2011 0710112007 0613012017 21 55 76 2011 2017 12 12 12 12 12 12 12 12 12 6 0 0 0 0510112019 0713112026 21 46 67 2019 2026 0 0 0 0 0 0 0 0 0 0 0 7 12 02/10/2011 02/10/2011 0310112016 0212812026 21 46 67 2011 2026 0 0 0 0 0 0 0 10 12 12 12 12 12 05/27/2007 05/27/2007 0610112012 0513112022 20 50 70 2007 2022 0 0 0 0 6 12 12 12 12 12 12 12 12 06/25/2016 06/25/2016 0710112021 0613012031 20 41 61 2016 2031 0 0 0 0 0 0 0 0 0 0 0 0 0 0410112020 0713112026 19 46 65 2020 2026 0 0 0 0 0 0 0 0 0 0 0 0 9 0710112014 0313112015 19 57 76 2014 2015 0 0 0 0 0 0 6 3 0 0 0 0 0 04/20/2011 04/20/2011 0510112016 0413012026 19 46 65 2011 2026 0 0 0 0 0 0 0 0 8 12 12 12 12 08/24/2015 08/24/2015 0910112020 0813112030 18 42 60 2015 2030 0 0 0 0 0 0 0 0 0 0 0 0 4 03/21/2015 03/21/2015 0410112020 0313112030 18 42 60 2015 2030 0 0 0 0 0 0 0 0 0 0 0 0 9 05/12/2010 05/12/2010 0610112015 0513112025 17 47 64 2010 2025 0 0 0 0 0 0 0 7 12 12 12 12 12 04/11/2016 04/11/2016 0510112021 0413012031 17 41 58 2016 2031 0 0 0 0 0 0 0 0 0 0 0 0 0 08/31/2010 08/31/2010 0910112015 0813112025 17 47 64 2010 2025 0 0 0 0 0 0 0 4 12 12 12 12 12 0210112024 0413012031 16 41 57 2024 2031 0 0 0 0 0 0 0 0 0 0 0 0 0 236 219 228 240 231 249 263 249 280 237 207 210 206 medical cost inflation 6% single cost 497.23 111,380 115,427 127,381 142,130 145,008 165,686 185,502 186,165 221,903 199,094 184,326 198,217 206,108 cafeteria plan contribution inflation 3% cafeteria 751.00 9,012 9,282 9,561 9,848 10,143 10,447 10,761 11,084 11,416 11,759 12,111 12,475 12,849 discount price 5% 120,392 124,709 136,942 151,978 155,151 176,133 196,263 197,249 233,319 210,853 196,437 210,692 218,957 (928) gg single cost 497.23 527.06 558.69 592.21 627.74 665.41 705.33 747.65 792.51 840.06 890.46 943.89 1,000.52 (665) gg cafeteria 751.00 773.53 796.74 820.64 845.26 870.61 896.73 923.64 951.34 979.88 1,009.28 1,039.56 1,070.75 (547) gg cumulative cost 120,392 245,101 382,043 534,021 689,172 865,305 1,061,568 1,258,817 1,492,136 1,702,988 1,899,426 2,110,118 2,329,075 (856) gg (22,691) ps 114,659 113,115 118,296 125,032 121,565 131,433 139,480 133,506 150,400 129,445 114,853 117,321 116,118 (554) pw -1 -2 -3 -4 -5 -6 -7 -8 -9 -10 -11 -12 -13 (2,416) pw (1,593) pr (3,707) pr (295) cd (104) cd 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12 12 12 12 12 12 12 12 12 12 7 0 0 0 0 0 0 0 0 0 0 0 0 0 12 12 12 12 12 12 12 12 12 12 12 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ----------------------------------------------------------------------------- 0 0 0 0 0 0 0 0 0 0 0 0 - 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12 12 12 1 0 0 0 0 0 0 0 0 12 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12 12 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12 12 12 12 11 0 0 0 0 0 0 0 12 9 0 0 0 0 0 0 0 0 0 0 12 12 9 0 0 0 0 0 0 0 0 0 12 12 12 12 12 12 12 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12 12 12 12 12 7 0 0 0 0 0 0 12 12 12 12 12 2 0 0 0 0 0 0 12 5 0 0 0 0 0 0 0 0 0 0 6 12 12 12 12 12 12 12 12 12 6 0 12 12 12 12 12 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 12 12 12 12 12 4 0 0 0 0 0 0 12 12 12 12 12 12 12 12 12 8 0 0 12 12 12 12 12 12 12 12 12 3 0 0 12 12 12 12 5 0 0 0 0 0 0 0 8 12 12 12 12 12 12 12 12 12 4 0 12 12 12 12 8 0 0 0 0 0 0 0 0 0 0 10 12 12 12 12 12 12 4 0 230 222 191 179 168 116 96 88 84 71 33 6 243,928 249,570 227,603 226,102 224,940 164,635 144,424 140,332 141,991 127,217 62,677 12,080 13,234 13,631 14,040 14,462 14,895 15,342 15,803 16,277 16,765 17,268 17,786 9,160 257,162 263,201 241,643 240,564 239,835 179,977 160,227 156,609 158,756 144,485 80,463 21,240 1,060.56 1,124.19 1,191.64 1,263.14 1,338.93 1,419.26 1,504.42 1,594.68 1,690.37 1,791.79 1,899.29 2,013.25 1,102.87 1,135.95 1,170.03 1,205.13 1,241.29 1,278.53 1,316.88 1,356.39 1,397.08 1,438.99 1,482.16 1,526.63 2,586,237 2,849,438 3,091,082 3,331,645 3,571,481 3,751,458 3,911,685 4,068,294 4,227,049 4,371,534 4,451,997 4,473,237 129,885 126,604 110,700 104,957 99,657 71,223 60,388 56,213 54,271 47,040 24,949 6,272 -14 -15 -16 -17 -18 -19 -20 -21 -22 -23 -24 -25 2,517,382 adjustment needed: (35,954)