The URL can be used to link to this page

Home My WebLink AboutCC Resolution 13348 (GASB 45; Bartel Associates)RESOLUTION NO. 13348 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF SAN RAFAEL ACCEPTING BARTEL ASSOCIATES' GASB 45 COMPLIANCE REPORT FOR DATA ENDING JUNE 30, 2011 WHEREAS, the Governmental Accounting Standards Board (GASB) establishes financial accounting and reporting standards for state and local governmental entities, which recognize GASB as the official source of generally accepted accounting principles for state and local government; and WHEREAS, GASB 45 establishes standards for accounting and financial reporting of "Other Post Employment Benefits" (OPEBs) and requires each public agency to engage a certified actuary to calculate several actuarial measures estimating the current and future costs and liabilities of an agency's OPEBs; and WHEREAS, the City entered into an agreement with Bartel Associates to prepare the GASB 45 required compliance report for data ending June 30, 2011; and WHEREAS, in San Rafael, the only OPEB offered is medical which varies by bargaining unit; and WHEREAS, there has already been a number of significant steps taken to control retiree health costs in San Rafael. NOW, THEREFORE, BE IT RESOLVED, that the City Council of the City of San Rafael affirms the policy to not increase the cap on City contributions to retiree medical premiums and hereby accepts the report from Bartel Associates, LLC (attached herein). 1, ESTHER C. BEIRNE, Clerk of the City of San Rafael, hereby certify that the foregoing resolution was duly and regularly introduced and adopted at a regular meeting of the City Council of said City held on Monday the 21 st day of May 2012, by the following vote, to wit: AYES: COUNCIL MEMBERS: Connolly, Heller, Levine, McCullough & Mayor Phillips NOES: COUNCIL MEMBERS: None ABSENT: COUNCIL MEMBERS: None ESTHER C. BEIRNE, City Clerk CITY OF SAN RAFAEL RETIREE HEALTHCARE PLAN June 30, 2011 GASB 45 Actuarial Valuation Doug Pryor, Vice President Mary Beth Redding, Actuary Harish Ganesan, Actuarial Analyst Bartel Associates, LLC May 17, 2012 CONTENTS Topic Page Benefit Summary 1 Data Summary 5 Actuarial Assumptions Highlights 7 Actuarial Methods 12 Assets 13 Results 17 Actuarial Certification 30 Exhibits Premiums E— 1 Participant Statistics E — 3 Actuarial Assumptions E-33 Definitions E-37 o lchents'city of san rafael\opeb`•2011 rahepoil\ba 12-05-1' sanrafaelei I I-Oo-30 opeb �aluahon final results docx I BENEFIT SUMMARY Elected Officials, All other Unrepresented Bargaining Units Mid Management & Management ■ Eligibility ■ Retire directly from City: • Age 50 (age 55 if hired > 7/1/11) with 10 years service (including reciprocity) or • 30 years service (Miscellaneous), 20 years service (Safety); or • Disability retirement ■ Benefit ■ Hired < 1/1/09 Full premium/cap ■ Hired < 1/1/10 Up to cap ■ Hired > 1/] /09 PEMHCA Min ■ Hired > 1 / 1 / 10 PEMHCA Min2 ■ Surviving ■ Benefit continues to surviving spouse Spouse Benefit Actives contribute 50 hours of sick leave to HRA each year (excluded from valuation) Firefighters contribute 2% of salary to HRA (excluded from valuation) May 17, 2012 1 ■ Medicare Part B ■ Other OPEB ■ Contributions May 17, 2012 BENEFIT SUMMARY ■ Hired < 4/1/07 Full ■ None reimbursement ■ Hired > 4/l/07 None ■ No Dental, Vision, or Life Benefits Fiscal Year Pav-Go 2010/11 $1,808,000 2009/10 1,755,000 2008/09 1,686,000 2 Trust Total $(1,000,000) $808,000 (1,000,000) 755,000 (1,000,000) 686,000 BENEFIT SUMMARY Bargaining Unit ' Monthly Cap SEIU Child Care Unit $543 Unrepresented Mid -Management Employees Retired < 12/1/01: $442 Retired > 12/1/01: Full prem Hired > 4/1/07: $600 San Rafael Fire Chief Officer's Association $557 San Rafael Firefighters' Association, LA.FF., Local $557 11775 San Rafael Police Association $386 San Rafael Police Mid -Management Association $566 SEIU 1021 $752 Public Employees Bargaining Unit (PEU) Local 1 $659 Unrepresented Management Employees and Council Hired < 4/1/07: Full prem. City Clerk and Elected Part -Time City Attorney Hired > 4/1/07: $600 Western Council of Engineers (WCE) $752 Employees hired on or after date receive only PEMHCA minimum ($112 in 2012). May 17, 2012 3 Min Date 31 1/1/10 1/1/09 BENEFIT SUMMARY I' I This page intentionally blank May 17. 2012 4 DATA SUMMARY Actives " Data as of April 2010. Data as of December 2011 ? l May 17, 2012 5 DATA SUMMARY Retirees 6/30/07 6/30/094 6/30/115 ■ Count 247 291 308 • Tier 1 408 377 326 • Tier 2 n/a 4 35 • Total 408 381 361 ■ Average $ 480 $ 537 $ 573 • Age 44.7 44.3 44.6 • City Service 11.6 10.7 10.9 • Pay $ 72,800 $ 77,900 $ 77,000 ■ Total Payroll (in 000's) 29,719 29,689 27,784 " Data as of April 2010. Data as of December 2011 ? l May 17, 2012 5 DATA SUMMARY Retirees Data as of April 2010 Data as of December 2011. May 17. 2012 6 6/30/07 6/30/096 6/30/117 ■ Count 247 291 308 ■ Average • Age 66.6 65.9 66.7 • Retirement Age 56.6 53.9 54.7 • Monthly Benefit $ 480 $ 537 $ 573 Data as of April 2010 Data as of December 2011. May 17. 2012 6 Assumption ■ Valuation Date ■ Funding Policy ■ General ACTUARIAL ASSUMPTIONS HIGHLIGHTS June 30, 2009 Valuation • June 30, 2009 • 2010/11 & 2011/12 • Pay -go with 401(h) account reimbursements: $1 million in 2008/09, 2009/10 and 2010/11 decreasing by $100,000 each year with no reimbursement in 2020/21 • 3.50% Inflation ■ 401(h) Asset . 7.75% Return ■ City Return • 4.50% May 17, 2012 June 30, 2011 Valuation • June 30, 2011 • 2012/13 & 2013/14 • Pay -go with 401(h) account reimbursement: $1 million for 2011/12 i None thereafter • 3.25% • 7.50% • 4.25% 7 ACTUARIAL ASSUMPTIONS HIGHLIGHTS Assumption June 30, 2009 Valuation June 30, 2011 Valuation ■ Discount • Select & ultimate discount rates • Select & ultimate discount rates Rate based on funded status: based on funded status: 2009/10 5.40% 2011/12 7.32% 2014/15 5.17% 2012/13 7.28% 2019/20 5.16% 2013/14 7.39% 2024/25 5.31% 2014/15 7.47% 1 1 2015/16+ 7.50% 2047/48+ 7.75% ■ Payroll Increases May 17,'_012 • Aggregate increases — 3.5011'0 • Merit Increases — Same as 6/30/2009 MCERA assumptions s • Aggregate increases — 3.25% • Merit Increases — Same as 6/30/2011 MCERA assumptions Em Assumption ■ Healthcare Trend ACTUARIAL ASSUMPTIONS HIGHLIGHTS June 30, 2009 Valuation Increase from Prior Year Year Non -Medicare Medicare Year HMO PPO HMO PPO 2009 Actual 2009 Premiums 2010 Actual 2010 Premiums 2011 Actual 2011 Premiums 2012 8.9% 9.5% 9.2% 9.8% 2013 8.3% 8.8% 8.5% 9.0% 1 1 1 1 1 2018+ 5.0% 5.0% 5.0% 5.0% ■ Cap Increases • 3.50% ■ Actuarial Loading May 17, 2012 Assumption ■ PEMHCA Minimum Increases ■ Participation at Retirement Ma\ 17. 2012 June 30, 2011 Valuation Non -Medicare Medicare Year All Plans 2009 n/a 2010 n/a 2011 Actual 2011 premiums 2012 Actual 2012 premiums 2013 9.0% 9.4% 2014 8.5% 8.9% 2015 8.0% 8.3% 2016 7.5% 7.8% 2017 7.0% 7.2% 2018 6.5% 6.7% 2019 6.0% 6.1% 2020 5.5% 5.6% 20211 5.0% 5.0% • None • 1/2 of 2008-2011 Cap/Premium • 2% (Management benefit gain reserved for future uncapped) increases > expected (6.2%) 9 ACTUARIAL ASSUMPTIONS HIGHLIGHTS I June 30, 2009 Valuation • 4.5% after 2011 • Actives: Capped benefit: o Currently covered: 100% o Currently waived: 80% PEMHCA minimum: 90% • Retirees: same as current election 9 June 30, 2011 Valuation • 4.5% after 2012 • Actives: Capped benefit: a Currently covered: 100% o Currently waived: 80% r PEMHCA minimum: 60% • Retirees: same as current election ACTUARIAL METHODS Method June 30, 2009 Valuation June 30, 2011 Valuation ■ Cost Method ■ Entry Age Normal IN Same ■ Amortization ■ Level percentage of payroll ■ Same Method ■ 15 -year fixed (closed) period IN Actuarial ■ MCERA 401(h) account ■ MCERA 401(h) account Value of actuarial value projected actuarial value projected Assets forward to 6/30/10 forward to 6/30/12 period ■ Implied ■ Employer cost for allowing retirees to participate. irrespective of May 17, 2012 11 ACTUARIAL METHODS Method June 30, 2009 Valuation June 30, 2011 Valuation IN Amortization IN 28 -year fixed (closed) period ■ 23 -year fixed (closed) period Period for initial UAAL from 6/30/10 for 6/30/12 UAAL IN 20 -year fixed (closed) period for plan changes ■ 15 -year fixed (closed) period for method and assumption changes, and experience and contribution gains and losses ■ Maximum 30 -year combined period ■ Implied ■ Employer cost for allowing retirees to participate. irrespective of Subsidy- employer contribution ■ Community rated plans not required to value implied subsidy ■ No implied subsidy determined for this valuation Mav 17 2012 12 ASSETS Market Value of Plan Assets (000's Omitted) ■ MVA (boy) • Contribution • Benefit Payment • Investment Return ■ MVA (eoy) ■ Approximate Return May 17, 2012 2007/08 2008/09 2009/10 $ 14,525 $ 13,010 $ 10,644 1,119 - - (1,000) (1,000) (1,000) (1,634) (1,366) (59) 13,010 10,644 9,585 -11.2% -10.5% -0.6% 13 ASSETS Actuarial Value of Plan Assets' (000's Omitted) x Assets projected based on 7 5°o annual assumed rate of return. May 17. 2012 14 2010/11 $ 9,585 (1.000) 2,303 10,888 24.0% Proj Proj 2010/11 2011/12 NAVA (boy) $ 11,008 $ 10,861 • Contribution - - • Benefit Payment (1,000) (1,000) • Credited Return 853 740 NAVA (eoy) 10,861 10,601 ■Assumed Return 7.750/0 7.50% x Assets projected based on 7 5°o annual assumed rate of return. May 17. 2012 14 2010/11 $ 9,585 (1.000) 2,303 10,888 24.0% ASSETS Historical Returns 30% 10/I1 -0.6% 25% 7.75% 7.75% 20% 15% 10% 5% 0% (5%) (10%) A--- (15%) (20%) (25%) (30%) 07/08 08/09 _-A•-401(h) -11.2% -10.5% Expected Return 7.75% 7.75% May 17, 2012 15 09/10 10/I1 -0.6% 24.0% 7.75% 7.75% ASSETS This page intentionally blank MaN 17. 2012 1 h RESULTS Actuarial Obligations (000's Omitted) May 17. 2012 $60.000 $50,000 $40,000 $30.000 - $20000 - 17 RESULTS Historical Funded Status (000's Omitted) I $10.000 i $0 6/30,,07 6/30/09 =Retiree pay -go =RetireeAAl_lesspay -go -Active AAI_ t Mar 17. 2012 6,'30/11 MVA 6/30/07 6/30/09 6/30/11 ■ Present Value of Benefits • Actives $ 41,880 $ 37,131 $ 14,105 • Retirees 27,714 35,196 25,802 • Total 69,594 72,327 39,907 ■ Actuarial Accrued Liability • Actives 25,053 21,066 9,354 • Retirees 27,714 35,196 25,802 • Total 52,767 56,262 35,156 ■ Assets 14,563 12,773 10,861 ■Unfunded Liability 38,204 43,489 24,295 ■Normal Cost 2,022 1,805 706 ■Pay -Go Cost 1,686 2,045 2,282 May 17. 2012 $60.000 $50,000 $40,000 $30.000 - $20000 - 17 RESULTS Historical Funded Status (000's Omitted) I $10.000 i $0 6/30,,07 6/30/09 =Retiree pay -go =RetireeAAl_lesspay -go -Active AAI_ t Mar 17. 2012 6,'30/11 MVA RESULTS Actuarial Accrued Liabilitv Gain/Loss (000's Omitted) ■ Actual (a),, 6/30/09 ■ Expected (�&, 6/30/11 ■ Changes • Change in Decrement Assumptions • Change in Medical Trend • Premiums/Caps < Expected • Actuarial Load • Change in Discount Rate r Assumed Investment Return r Funding Policy Change • Cap Freeze • Other • Total ■ Actual (a, 6/30/11 May 17. 2012 19 RESULTS Total Gain/Loss (000's Omitted) ■ Source • Liability • Asset • Total Max 17 2012 20 AAL (Gain)/Loss $ 56,262 61,142 3,169 512 (3,711) (2,370) 2,093 (10,727) (14,653) (299) (25,986) 35,156 6/30/12 Total (Gain)/Loss $ (27,937) 1,311 (26,626) RESULTS Annual Required Contribution (ARC) (000's Omitted) r Mar 17. 2012 21 RESULTS Annual Required Contribution (ARC) (000's Omitted) 6/30/2009 Val 6/30/2011 Val 2010/11 2011/12 2012/13 2013/14 ■ Annual Required Contribution - $ $1000 • Normal Cost $ 1,805 $ 1,869 $ 706 $ 699 • UAAL Amortization 2,219 2,496 1,728 1,797 • Total ARC 4,024 4,365 2,434 2,496 1 ■ Projected Payroll 30,728 31,727 28,687 29,619 ■ Annual Required Contribution - % • Normal Cost 5.9% 5.9% 2.5% 2.4% • UAAL Amortization 7.2% 7.9% 6.0% 6.1% • Total ARC 13.1% 13.8% 8.5% 8.4% r Mar 17. 2012 21 RESULTS Annual Required Contribution (ARC) (000's Omitted) 11/12 1213 13/14 1,869 706 699 2,496 1.728 1.797 4,365 j 2,434 I 14% May 17, 2012 22 $6.000 $5,000 $4.000 $3.000 = $1000 $1,000 $0 10,'11 !0 Normal Cost 1,805 ❑ Amortization 2,219 ARC 4,024 11/12 1213 13/14 1,869 706 699 2,496 1.728 1.797 4,365 j 2,434 I 14% May 17, 2012 22 ■ Outstanding Balance • Initial UAAL • (Gain)/Loss 2009 val i= 2011 val • Contribution (Gain)/Loss • Total 1 May P. 2012 RESULTS Amortization Bases (000's Omitted) • Initial UAAL 6/30/2009 Val 6/30/2011 Val 6/30/10 6/30/11 6/30/12 6/30/13 $ 44,417 $ 44,705 $ 44,908 $ 45,034 (4,536) (4,422) (4,287) (4,299) - - (26,626) (26,700) 6,265 8,485 11,575 11,788 46,146 48,768 25,571 25,822 23 RESULTS Amortization Pavments (000's Omitted) 6/30/2009 Val 6/30/2011 Val 2010111 1 2011/12 2012/13 2013/14 ■ Payment • Initial UAAL $ 2,084 $ 2,157 $ 3,035 $ 3,134 • (Gain)/Loss 2009 val (357) (369) (290) (299) .-2011 -al - - (1,800) (1,858) • Contribution (Gain);'Loss 492 707 782 820 • Total 2,219 2,495 1,728 1,797 • Average years 27 25 23 22 May 17, 2012 24 i I RESULTS Estimated Net OPEB ObliLyation (NOO) (000's Omitted) CAFR Estimated 2010/11 2011/12 2012/13 2013/14 ■ Estimated NOO at Beginning of Year $ 6,265 $ 8,485 $ 11,576 $ 11,789 ■ Annual OPEB Cost • Annual Required Contribution 4,024 4,3659 2,434 2,496 • Interest on NOO 335 621 843 872 • Adjustment for NOO4( 92)7( 07) (782) (820) • Annual OPEB Cost 3,867 4,279 2,495 2,547 ■ Contributions Obligation Pmts Fund Contrib (AOC) • Benefit Payments10 2,648 2,188 2,282 2,428 • Trust Pre-Funding1( ,000)1( ,000) - - • Total Contribution 1,648 1,188 2,282 2,428 ■ Estimated NOO at End of Year 8,485 11,576 11,789 11,908 Based on 6/30/09 valuation. 0 �Essttiimated benefit payments for 2011/12. 2012/13, & 2013/14 May 17, 2012 25 RESULTS NOO Proiection (000's Omitted) Beginning I Contribution] 1 Annual of Year OPEB Contribution Fiscal Net OPEB Benefit Pre- I Total Cost as % of Year Obligation Pmts Fund Contrib (AOC) Payroll Payroll 2012/13 $ 11,576 $ 2,282 $ - $ 2,282 $ 2,495 $ 28,687 8.0% 2013/14 11,789 2,428 - 2,428 2,547 29,619 8.2% 2014/15 11,908 2.560 - 2,560 2,591 30,582 8.4% 2014/15 11.939 2.681 - 2,681 2,622 31.576 8.5% 2015/16 11,879 2,798 - 1798 2,644 32,602 8.6% 2016/17 11,725 2,913 - 2,913 2,659 33,662 8.7% 2017/18 11,471 3,039 - 3,039 2,664 34,756 8.7% 2018/19 11,096 3,143 - 3343 1658 35,885 8.8% 2019/20 10,611 3,224 - 3,224 2,648 37,051 8.7% 2020/21 10,035 3,290 - 3,290 2.633 38,256 8.6% Based on benefits paid to retirees May 17. 2012 26 N RESULTS 2012/13 Actuarial ObliLations (000's Omitted) June 30, 2011 Miscellaneous Safety Total ■ ARC- $ (000's Omitted) • Normal Cost $ 516 Miscellaneous Safety Total ■ PVPB 1,728 • Total ARC 1,620 814 • Actives $ 10,625 $ 3,480 $ 14,105 28,687 • Retirees 15,021 10,780 25,802 • Normal Cost • Total 25,646 14,260 39,907 ■ AAL 6.0% • Total ARC 10.3% 6.3% • Actives 7,236 2,118 9,354 • Retirees 15,021 10,780 25,802 • Total 22,257 12,898 35,156 ■ Assets 12 6,876 3,985 10,861 ■ Unfunded Liability 15,381 8,913 24,295 ■ Normal Cost (12/13) 516 190 706 ■ Pay Go Costs (12/13) 1,307 975 2,282 Forillustrative purposes. assets allocated on AAL. f ? May 17. 2012 27 RESULTS Annual Required Contribution (ARC) 2012/13 (000's Omitted) Miscellaneous Safety Total ■ ARC- $ • Normal Cost $ 516 $ 190 $ 706 • UAL Amortization 1 1,105 623 1,728 • Total ARC 1,620 814 1434 ■ Projected Payroll 15,779 12,908 28,687 ■ARC-% • Normal Cost 3.3% 1.50//o 2.5% • UAL Amortization 7.0% 4.8% 6.0% • Total ARC 10.3% 6.3% 8.5% For illustrative purposes. amortization amount allocated on AAI MaN 17. 2012 28 RESULTS Actuarial Obligations & Annual Required Contribution Tiers (000's Omitted) 14 All assets allocated to Tier 1. May 17, 2012 29 ACTUARIAL CERTIFICATION This report presents the City of San Rafael Retiree Healthcare Plan ("Plan") June 30, 2011 actuarial valuation. The purpose of this valuation is to: ■ Determine the Governmental Accounting Standards Board Statement Nos. 43 and 45 June 30. 2011 Benefit Obligations, ■ Determine the Plans June 30, 20 Funded Status, and ■ Calculate the 2012/13 and 2013/14 Annual Required Contributions. The report provides information intended for reporting under GASB 43 and 45, but may not be appropriate for other purposes. Information provided in this report may be useful to the City for the Plan's financial management. Future valuations may differ significantly if the Plans experience differs from our assumptions or if there are changes in Plan design. actuarial methods or actuarial assumptions The project scope did not include an analysis of this potential variation. The valuation is based on Plan provisions. participant data. and asset information provided by the City as summarized in this report. which we relied on and did not audit. We reviewed the participant data for reasonableness To the best of our knowledge. this report is complete and accurate and has been conducted using generally accepted actuarial principals and practices Additionally. in our opinion. actuarial methods and assumptions comply with GASB 43 and 45. As members of the American Academy of Actuaries meeting the Academy Qualification Standards. we certify the actuarial results and opinions herein. Respectfully submitted. Doug Pnor. ASA. EA, MAAA Vice President Bartel Associates. LLC May 17. 2012 1 r _fes-. .-- • . -, Mary Elizabeth Redding. FSA. MAAA, EA Assistant Vice President Bartel Associates. LLC Mav 17. 2012 s May 17. 2012 30 Tier 1 Tier 2 Total ■ AAL $ 35,152 $ 4 $ 35,156 ■ Assets 14 10,861 - 10,861 ■ Unfunded Liability 24,291 4 24,295 ■ 2012/13 ARC • Normal Cost 692 14 706 • UAL Amortization 1,727 - 1,728 • Total ARC 2,420 14 2,434 ■ Payroll 26,663 2,024 28,687 ■ ARC % of payroll 9.1% 0.7% 8.5% 14 All assets allocated to Tier 1. May 17, 2012 29 ACTUARIAL CERTIFICATION This report presents the City of San Rafael Retiree Healthcare Plan ("Plan") June 30, 2011 actuarial valuation. The purpose of this valuation is to: ■ Determine the Governmental Accounting Standards Board Statement Nos. 43 and 45 June 30. 2011 Benefit Obligations, ■ Determine the Plans June 30, 20 Funded Status, and ■ Calculate the 2012/13 and 2013/14 Annual Required Contributions. The report provides information intended for reporting under GASB 43 and 45, but may not be appropriate for other purposes. Information provided in this report may be useful to the City for the Plan's financial management. Future valuations may differ significantly if the Plans experience differs from our assumptions or if there are changes in Plan design. actuarial methods or actuarial assumptions The project scope did not include an analysis of this potential variation. The valuation is based on Plan provisions. participant data. and asset information provided by the City as summarized in this report. which we relied on and did not audit. We reviewed the participant data for reasonableness To the best of our knowledge. this report is complete and accurate and has been conducted using generally accepted actuarial principals and practices Additionally. in our opinion. actuarial methods and assumptions comply with GASB 43 and 45. As members of the American Academy of Actuaries meeting the Academy Qualification Standards. we certify the actuarial results and opinions herein. Respectfully submitted. Doug Pnor. ASA. EA, MAAA Vice President Bartel Associates. LLC May 17. 2012 1 r _fes-. .-- • . -, Mary Elizabeth Redding. FSA. MAAA, EA Assistant Vice President Bartel Associates. LLC Mav 17. 2012 s May 17. 2012 30 Medical Plan Blue Shield Blue Shield NetValue Kaiser PERS Choice PERS Select PERSCare PORAL May 17, 2012 Medical Plan Blue Shield Blue Shield NetValue Kaiser PERS Choice PERS Select PERSCare ' PORAC PREMIUMS 2011 PEMHCA Monthlv Premiums Bay Area Non -Medicare Eligible Single 2 -Party Family $675.51 $1,351.02 $1,756.33 581.24 1,162.48 1,511.22 568.99 1,13 7.98 1,479.37 563.40 1,126.80 1,464.84 492.68 985.36 1,280.97 893.95 1,787.90 2,324.27 527.00 987.00 1,254.00 Is PREMIUMS Medicare Eligible Single 2 -Party Family $337.88 $675.76 $1,013.64 337.88 675.76 1,013.64 282.30 564.60 846.90 375.88 751.76 1,127.64 375.88 751.761 1,127.64 433.66 867.32 1,300.981 418.00 833.00 1,331.00 2012 PEMHCA Monthly Premiums Bay Area Non -Medicare Eligible Single 2 -Party Family $711.10 $1,422.20 $1,848.86 611.59 1,223.18 1,590.13 610.44 1,220.88 1,587.14 574.15 1,148.30 1,492.79 487.39 974.78 1,267.21 1,029.23 1058.46 2,676.00 556.00 1,041.00 1,323.00 Mar 17. 2012 E-2 Medicare Eligible Single 2 -Party Family $337.99 $675.98 $1,013.97 337.99 675.98 1,013.97 277.81 555.62 833.43 383.44 766.88 1,150.321 383.44 766.88 1,150.32; 432.43 ; 864.86 1,297.29 418.00 833.00 1,331.00 PARTICIPANT STATISTICS Participant Statistics June 30, 2011 PARTICIPANT STATISTICS Participant Statistics June 30, 200916 Miscellaneous Police Fire Total ■ Actives • Count 245 59 57 361 • Average Age 46.2 39.8 42.7 44.6 • Average Service 10.3 10.8 13.4 10.9 • Average Pay $62,374 $ 103,737 $ 111,962 $76,964 • Payroll ($000s) 15,282 6,120 6,382 27,784 ■ Retirees ;o Count < 65 62 44 49 155 Count > 65 76 32 45 .153 Total 138 76 94 308 • Average Age 68.6 64.3 66.0 66.7 • Average Ret. Age 15 58.5 50.4 52.7 54.7 15 Excludes 28 surviving spouses May 17, 2012 E-4 May 17, 2012 E-3 PARTICIPANT STATISTICS Participant Statistics June 30, 200916 Miscellaneous Police Fire Total ■ Actives • Count 254 66 61 381 • Average Age 46.0 38.7 43.2 44.3 • Average Service 10.2 9.6 14.4 10.7 • Average Pay $64,400 $ 103,000 $ 106,900 $77,900 • Payroll ($000s) 16,370 6,797 6,522 29,689 ■ Retirees Count < 65 64 51 49 164 Count > 65 68 24 35 127 Total 132 75 84 291 • Average Age 68.5 62.4 64.9 65.9 • Average Ret. Age 17 58.0 49.0 52.2 53.9 Data as of Marcli-April 2010- June 30. 2009 actrxe counts approximately 5% higher May 17, 2012 E-4 PARTICIPANT STATISTICS Medical Plan Participation " Excludes 28 surviving spouses May 17, 2012 E-5 PARTICIPANT STATISTICS This page intentionally blank F May 17. 2012 E-± Retirees Medical Plan Actives C 65 > 65 Total Blue Shield 21% 26% 20% 23% Blue Shield NetValue 1% 1% 1% 1% Kaiser 67% 49% 41% 45% PERS Choice 3% 7% 9% 8% PERS Select 1% 1% 0% 1% j PERS Care 2% 8% 30% 19% PORAC 5% 8% 0% 4% Total 100% 100% 100% 100% " Excludes 28 surviving spouses May 17, 2012 E-5 PARTICIPANT STATISTICS This page intentionally blank F May 17. 2012 E-± PARTICIPANT STATISTICS Active Medical Coverasse Medical Plan Single 2 -Party Family Waived Total Blue Shield 25 17 26 - 68 j Blue Shield NetValue 1 - 2 - 3 Kaiser 80 41 91 - 212 PERS Choice 2 3 5 - 10 PERS Select 1 1 1 - 3 j PERSCare 1 2 2 - 5 PORAC 5 3 9 - 17 Waived - - - 43 43 i Total 115 67 136 43 361 j May 17, 2012 E-7 PARTICIPANT STATISTICS Retiree Medical Coverage Under Age 65 Medical Plan Region Single j 2 -Party Family Total Blue Shield/Net Value Bay Area 18 8 11 37 Sacramento 1 1 j North 2 - - 2 j j Kaiser Bav Area 34 23 16 73 j Sacramento I - - 1 j South - 1 - I Out of State 1 - - 1 PERS Choice Bay Area 1 2 - 3 North 2 1 - 3 j Out of State 3 2 ( - 5 I j PERS Select Bav Area 2 - - 2 PERSCare Bav Area 4 1 2 7 North 1 - Out of State 2 2 1 - 4 j PORAL 2 8 , 3 13 Total 74 49 32 155 (--\I May 17 2012 F.-8 PARTICIPANT STATISTICS Retiree Medical CoveraLre Over Age 65 Medical Plan Region Single 2 -Party Family Total i Blue Shield/Net Value Bay Area 11 14 - 25 Sacramento 1 3 - 4 North 1 - - I South I - - 1 Kaiser Bay Area 25 27 2 54 Sacramento ( - 2 - 2 Los Angeles 1 - - I South 2 1 - 3 Out of State 1 1 - 2 PERS Choice Bay Area - 6 - 6 Sacramento 1 - - 1 North ( - 2 - 2 Out of State 4 1 - 5 PERSCare Bay Area 18 13 - 31 North 2 2 - 4 South I - - 1 Out of State 8 2 - 10 Total 77 74 2 153 May 17. 2012 E-9 PARTICIPANT STATISTICS I I This page intentionally blank 1.J Mav 17.2012 E-10 PARTICIPANT STATISTICS PARTICIPANT STATISTICS Active ALye Distribution Miscellaneous Mw, 17.2012 E-12 I � Actives by Aee and Citv Service Miscellaneous City Service Age < 1 1-4 5-9 10-14 15-19 20-24 >_ 25 Total <25 6 - 2 2 - - - - 10 25-29 4 6 4 - - - - 14 30-34 5 12 4 3 - - - 24 35-39 4 12 8 6 1 - - 31 1� 40-44 - 5 6 4 5 3 - 23 11I 45-49 3 8 9 9 2 7 6 44 11I 50-54 1 6 7 13 3 7 2 39 i 55-59 - 7 8 10 3 6 4 38 60-64 - - 1 3 2 3 - 9 >65 1 2 3 3 1 1 2 13 Total 24 60 52 51 17 27 14 245 Mav 17. 2012 E-11 PARTICIPANT STATISTICS Active ALye Distribution Miscellaneous Mw, 17.2012 E-12 PARTICIPANT STATISTICS Active Service Distribution Miscellaneous 100 90` o680N9Valuation 80 -- | �— � 06B0/11Valuation � '" nv -- 50 -- --- -- -- 7 40 -- --- --- 30 -- --- --- 20 -- --- 10 -----' ------' ' ---- --- rH� ' | || | , � . . . 0-4 5-9 10-14 15-19 20-24 ^25 Service ( ` May 17, 2012 E- 13 | | PARTICIPANT—STATISTICS This page intentionally blank ' / \ N/IaN 17. 2012 5'N PARTICIPANT STATISTICS Actives by Age and Citv Service Police PARTICIPANT STATISTICS Active Ate Distribution Police Safety 18 16 s 06/30109 Valuation 14 E36/30; 11 Valuation 12 -- 10j 8 1 6 4 0 <25 25-29 30-34 35-39 40-44 45-49 50-54 55-59 60-65 >65 Age MaN 17. 2012 E-16 City Service I Age < 1 1-4 5-9 10-14 15-19 20-24 >_ 25 Total <25 - - - - - - - - 25-29 - 3 4 - - - - 7 30-34 - - 7 2 - - - 9 35-39 - 2 9 5 - - - 16 1� 40-44 1 3 2 4 3 - - 13 I 45-49 - - - 2 - 4 - 6 50-54 - 1 - 1 - 1 3 6 55-59 - 1 1 - - - - 2 60-64 - - - - - - - - I >65 - - - - - - - - Total 1 10 23 14 3 5 3 59 May 17, 2012 E-15 PARTICIPANT STATISTICS Active Ate Distribution Police Safety 18 16 s 06/30109 Valuation 14 E36/30; 11 Valuation 12 -- 10j 8 1 6 4 0 <25 25-29 30-34 35-39 40-44 45-49 50-54 55-59 60-65 >65 Age MaN 17. 2012 E-16 25 20 — 15 — E z 10 [b- 0-4 5-9 10-14 15-19 20-24 >25 Service May 17. 2012 May 17, 2012 PARTICIPANT STATISTICS Active Service Distribution Police Safety ❑6130109 Valuation 136/30/11 Valuation —1 E-17 PARTICIPANT STATISTICS This page intentionally blank E-18 PARTICIPANT STATISTICS Actives by Age and Citv Service Fire PARTICIPANT STATISTICS i I Active Age Distribution Fire Safety May 17. 2012 E-20 City Service I Age < 1 1-4 5-9 10-14 15-19 20-24 > 25 Total <25 - 1 - - - - - 1 25-29 1 3 1 - - - - 1� 5 I 30-34 2 4 1 1 - - -_ 8 35-39 - - 3 4 - - - 7 40-44 1 - 4 3 2 - 1 11 45-49 - 2 1 1 - 3 2 9 I 50-54 - 1 1 1 - 5 7 15 55-59 - - - 1 - - - 1 60-64 - - - - - - - - >65 - - - - - - - - Total 4 11 11 I 11 2 8 10 57 May 17. 2012 E-14 PARTICIPANT STATISTICS i I Active Age Distribution Fire Safety May 17. 2012 E-20 PARTICIPANT STATISTICS Active Service Distribution Fire Safety 16 06/30/09 Valuation 14 06 /301111 Valuation 12 10 Ee,� 8 6 4 2 0 0-4 5-9 10-14 15-19 20-24 >25 Service May 17, 2012 E-21 PARTICIPANT STATISTICS This page intentionally blank %lay 17. 2012 E-22 PARTICIPANT STA'T'ISTICS l I Actives by Age and Citv Service Total PARTICIPANT STATISTICS I Active Age Distribution Total "', May 17.'012 E-24 City Service Age < 1 1-4 5-9 10-14 15-19 20-24 >_ 25 Total <25 6 3 2 - - - - 11 25-29 5 12 9 - - - - 26 30-34 7 16 12 6 - - - 41 35-39 4 14 20 15 1 - - 54 40-44 2 8 12 11 10 3 1 47 45-49 3 10 10 12 2 14 8 59 50-54 1 8 8 15 3 13 12 60 55-59 - 8 9 11 3 6 4 41 60-64 - - 1 3 2 3 - 9 >65 1 2 3 3 1 1 2 13 Total 29 81 86 76 22 40 27 361 May 17. 2012 E-23 PARTICIPANT STATISTICS I Active Age Distribution Total "', May 17.'012 E-24