Extracted text (via pymupdf)
9246 characters
Rachel Calisi, GBDS, CEBS Senior Health Consultant T 602.381.4027 M 480.490.7306 rcalisi@segalco.com 1501 West Fountainhead Parkway Suite 370 Tempe, AZ 85282-1936 segalco.com 5901397v1/00914.015 August 2, 2024 Rae Lynn Nielsen Human Resources Director City of Chandler PO Box 4008 Chandler, AZ 85244-4008 Re: City of Chandler Dental Plan Monthly Reporting January 1, 2024 through December 31, 2024 – Data through June Dear Rae Lynn: Enclosed is the monthly experience reporting for the City’s dental plan. The report contains dental paid claims, enrollment, and expense information as furnished by Delta Dental of Arizona through June 30, 2024. For the month of June, the Dental plan ran a surplus of approximately $5.2K (before IBNR) or 2.5% of contributions. The 2024 plan year-to-date loss ratio was 97.5%. For the 2024 plan year-to-date, the average Dental enrollment for Active employees and Retirees has increased 3.1% and 4.2% from the 2023 Plan Year average, respectively. We will continue to monitor the dental plan experience and provide monthly reports. I look forward to discussing this report with you. This document has been prepared for the exclusive use and benefit of the City of Chandler, based upon information provided by you and your other service providers or otherwise made available to Segal at the time this document was created. Segal makes no representation or warranty as to the accuracy of any forward-looking statements and does not guarantee any particular outcome or result. Except as may be required by law, this document should not be shared, copied or quoted, in whole or in part, without the consent of Segal. This document does not constitute legal, tax or investment advice or create or imply a fiduciary relationship. You are encouraged to discuss any issues raised with your legal, tax and other advisors before taking, or refraining from taking, any action. Sincerely yours, Rachel Calisi, GBDS, CEBS Senior Health Consultant City of Chandler (Data Through June 2024) 8/2/2024 Presented by: Rachel Calisi © 2024 by The Segal Group Inc. Dental Monthly Reporting: January 2024 - December 2024 Month Enrollment Contributions Dental Paid Claims Expenses Total Paid Claims and Expenses Surplus/ (Deficit) Total Loss Ratio Jan-23 2,144 $195,540 $208,484 $10,489 $218,974 ($23,434) 112.0% Feb-23 2,145 $195,671 $149,849 $10,494 $160,343 $35,328 81.9% Mar-23 2,141 $195,311 $170,547 $10,479 $181,027 $14,284 92.7% Apr-23 2,142 $195,226 $171,425 $10,474 $181,899 $13,327 93.2% May-23 2,159 $196,233 $173,239 $10,553 $183,792 $12,441 93.7% Jun-23 2,171 $196,837 $174,117 $10,616 $184,733 $12,104 93.9% Jul-23 2,183 $197,785 $170,091 $10,675 $180,766 $17,019 91.4% Aug-23 2,180 $197,612 $212,141 $10,660 $222,801 ($25,189) 112.7% Sep-23 2,193 $198,235 $157,158 $10,724 $167,882 $30,353 84.7% Oct-23 2,199 $198,637 $183,970 $10,753 $194,723 $3,914 98.0% Nov-23 2,200 $198,572 $142,710 $10,753 $153,463 $45,109 77.3% Dec-23 2,208 $199,248 $148,452 $10,797 $159,249 $39,999 79.9% 2023 Total 26,065 $2,364,907 $2,062,184 $127,468 $2,189,652 $175,255 92.6% 2023 Avg. 2,172 $197,076 $171,849 $10,622 $182,471 $14,605 92.6% Jan-24 2,210 $200,554 $217,749 $10,802 $228,551 ($27,997) 114.0% Feb-24 2,246 $203,074 $155,160 $10,983 $166,143 $36,931 81.8% Mar-24 2,244 $202,920 $186,034 $10,973 $197,008 $5,912 97.1% Apr-24 2,247 $202,917 $196,780 $10,988 $207,767 ($4,850) 102.4% May-24 2,259 $203,573 $177,867 $11,042 $188,909 $14,664 92.8% Jun-24 2,267 $204,097 $187,838 $11,086 $198,924 $5,173 97.5% Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 2024 Total 13,473 $1,217,135 $1,121,428 $65,873 $1,187,301 $29,834 97.5% 2024 Avg. 2,246 $202,856 $186,905 $10,979 $197,883 $4,972 97.5% 2 City of Chandler 2023-2024 Dental Contributions and Expenses Year-to-date through June 2024 $228,551 $394,693 $591,701 $799,468 $988,377 $1,187,301 $218,974 $379,317 $560,343 $742,243 $926,034 $1,110,767 $1,291,533 $1,514,335 $1,682,216 $1,876,939 $2,030,402 $2,189,652 $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 Jan. Feb. Mar. Apr. May Jun. Jul. Aug. Sept. Oct. Nov. Dec. 2024 vs 2023 Cumulative Paid Claims & Expenses 2024 Cumulative Claims & Expenses 2023 Cumulative Claims & Expenses 5901197 ACTIVE RETIREE TOTAL Jan-24 1,636 574 2,210 Feb-24 1,666 580 2,246 Mar-24 1,664 580 2,244 Apr-24 1,661 586 2,247 May-24 1,669 590 2,259 Jun-24 1,673 594 2,267 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 2024 Avg. 1,662 584 2,246 % of Total 74% 26% 100% 2023 Avg. 1,612 561 2,172 % Change 3.1% 4.2% 3.4% 3 City of Chandler 2024 Dental Enrollment by Status Year-to-date through June 2024 0 1,000 2,000 3,000 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 Active and Retiree Enrollment ACTIVE RETIREE TOTAL 5901197 Notes: - The claims information by Active and Retiree status is approximate based on the status information reported to Delta Dental as of the date the claim was adjudicated. City of Chandler 2024 Dental Paid Claims by Status Year-to-date through June 2024 4 $84 $80 $83 $50 $60 $70 $80 $90 $100 $110 Dental Claims per Employee per Month (PEPM) Dental YTD Claims Paid by Status -- 2024 Plan Year Active 2024 Retiree 2024 All 2024 $82 $71 $79 $50 $60 $70 $80 $90 $100 $110 Dental Claims per Employee per Month (PEPM) Dental Claims Paid by Status -- 2023 Plan Year Active 2023 Retiree 2023 All 2023 5901197 Enrollment Contributions Claims & Expenses Active Loss Ratio Enrollment Contributions Claims & Expenses Retiree Loss Ratio Enrollment Contributions Total Claims & Expenses Total Loss Ratio Dental 9,969 $942,051 $889,730 94% 3,504 $275,084 $297,571 108% 13,473 $1,217,135 $1,187,301 98% % of Total 74% 77% 75% 26% 23% 25% 100% 100% 100% 4/10/2015 * Notes: - Percent of Total rows sum Active and Retiree columns by plan and show each plan's percentage of the total in the Total columns. - The claims information by Active and Retiree is approximate based on the status information reported to Delta Dental as of the date the claim was adjudicated. 5 City of Chandler 2024 Dental Contributions and Paid Claims by Status Year-to-date through June 2024 ACTIVE RETIREE TOTAL $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 $ Year-to-Date Dental Active Contributions vs Claims and Expenses $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 $ Year-to-Date Dental Retiree Contributions vs Claims and Expenses Contributions Claims & Expenses 5901197 Month EE EE+1 EE+2 or more EE EE+1 EE+2 or more Jan-23 524 365 713 202 268 72 Feb-23 529 353 716 202 272 73 Mar-23 526 355 711 201 273 75 Apr-23 528 354 708 201 275 76 May-23 538 361 707 202 275 76 Jun-23 545 365 704 204 276 77 Jul-23 551 361 707 206 280 78 Aug-23 544 362 705 209 281 79 Sep-23 553 367 702 211 280 80 Oct-23 554 369 704 213 281 78 Nov-23 556 367 702 214 282 79 Dec-23 555 376 701 213 284 79 2023 Total 6,503 4,355 8,480 2,478 3,327 922 2023 Avg. 542 363 707 207 277 77 Month EE EE+1 EE+2 or more EE EE+1 EE+2 or more Jan-24 540 385 711 207 289 78 Feb-24 563 387 716 210 290 80 Mar-24 562 386 716 209 292 79 Apr-24 564 384 713 210 297 79 May-24 570 387 712 213 298 79 Jun-24 574 387 712 215 299 80 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 2024 Total 3,373 2,316 4,280 1,264 1,765 475 2024 Avg. 562 386 713 211 294 79 6 Active Retirees City of Chandler Dental Enrollment by Tier Year-to-date through June 2024 Retirees Actives 5901197 4/10/2015 * 7 City of Chandler 2024 Dental Contributions and Expenses by Status Year-to-date through June 2024 The claims information by Active and Retiree status is approximate based on the status information provided by Delta Dental as of the date the claim was adjudicated. $94 $89 $5 -$20 $0 $20 $40 $60 $80 $100 $120 $ per Employee per Month (PEPM) Active Surplus/(Deficit) by Status Contributions Claims & Expenses Surplus(Deficit) $79 $85 ($6) -$20 $0 $20 $40 $60 $80 $100 $120 $ per Employee per Month (PEPM) Retiree Surplus/(Deficit) by Status Contributions Claims & Expenses Surplus(Deficit) 74% 26% Enrollment Active Retiree 75% 25% Claims and Expenses Active Retiree 5901197 77% 23% Contributions Active Retiree Twelve Month Period Ending (a) Enrollment (b) Dental Claims Paid (b)/(a) Dental Claims PEPM Jun-23 25,618 $2,031,980 $79.32 Jul-23 25,732 $2,055,239 $79.87 Aug-23 25,809 $2,081,439 $80.65 Sep-23 25,886 $2,092,207 $80.82 Oct-23 25,952 $2,110,233 $81.31 Nov-23 26,008 $2,071,623 $79.65 Dec-23 26,065 $2,062,184 $79.12 Jan-24 26,131 $2,071,448 $79.27 Feb-24 26,232 $2,076,759 $79.17 Mar-24 26,335 $2,092,246 $79.45 Apr-24 26,440 $2,117,600 $80.09 May-24 26,540 $2,122,228 $79.96 Jun-24 26,636 $2,135,950 $80.19 City of Chandler Thirteen Month Snapshot - Dental Plan Paid Claims Through June 2024 8 5901197 $79 $80 $81 $81 $81 $80 $79 $79 $79 $79 $80 $80 $80 $50 $55 $60 $65 $70 $75 $80 $85 $90 $95 $100 Claims per Employee per Month 12-Month Period Ending Rolling Twelve Month Dental Claims PEPM Dental Trend 1.1%