Segal Report

Mary Fedor 1501 West Fountainhead Parkway
Senior Consultant Suite 370
T 480.550.0362 Tempe, AZ 85282-1936
M 602.750.4078 segalco.com
mfedor@segalco.com
October 21, 2026
Fernanda Acurio
Human Resources Manager
City of Chandler
PO Box 4008
Chandler, AZ 85244-4008
Re: City of Chandler
Medical and Prescription Drug Plan Monthly Reporting
January 1, 2026 through December 31, 2026 – Data through August
Dear Fernanda:
Enclosed is the monthly experience reporting for the City’s medical and prescription drug plans.
The report contains medical claims, prescription drug claims, enrollment, and expense
information as furnished by Blue Cross Blue Shield of Arizona (Whyzen Analytics reporting tool)
through August 31, 2026.
For the month of August, Medical paid claims were approximately $1,987,000 while net Rx
claims were about $632,600. For the 2026 plan year to date, claims and expenses (after stop-
loss reimbursements and pharmacy rebates) were above contributions by approximately
$1,886,500 or 8.9% of contributions. Based on paid claims and expenses, Actives and Retirees
on the Blue and Red Plan experienced an operating deficit, along with Retirees on the White
Plan, as displayed on Page 9.
There are twenty-six claimants with paid claims in excess of $100,000 during the reporting
period. There are zero claimants in the current plan year to date who have exceeded the stop
loss deductible of $350,000.
Expenses included in this report are medical plan administration, stop-loss premium, capitation
for behavioral health & chiropractic services, value-based services, out-of-network shared
savings costs, HSA administration, and fees associated with the Affordable Care Act. Also
included is the amount of $67,800 per month from the estimated 2026 Operating Budget. These
expenses exclude those funded by Blue Cross Blue Shield of Arizona. These expenses include
categories such as wellness incentives, personnel support, audit & financial services,
promotional, operating supplies & equipment, bank charges, contractual services, and health
savings and flex account contributions.
In August 2026, approximately 34.8% of all active employees and retirees were enrolled in the
Red plan, with 4.4% enrolled in the Blue plan, and 60.8% enrolled in the White plan. The
average total enrollment in 2026 is approximately 2.9% higher than the 2025 average
enrollment.
#6010096v1/00914.015

Fernanda Acurio
October 21, 2026
Page 2
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 required by law or required for the Client’s proper
administration, this document should not be copied, reproduced, or shared with other parties
without Segal’s consent and, in such instances, should only be shared in its entirety. 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.
I look forward to discussing this report with you.
Sincerely,
Mary Fedor
Senior Consultant
#6010096v1/00914.015

City of Chandler
Medical/Rx Monthly Reporting:
January 2026 - December 2026
(Data Through August 2026)
10/21/2026
Presented by: Mary Fedor
© 2026 by The Segal Group Inc. All rights reserved.

City of Chandler
HealthPlan Dashboard - Data thru August 2026
Financial Enrollment
Income vs Paid Medical/Rx Claims + Expenses Demographics
Metrics Aug'26 Jan'26-Aug'26 Jan'25-Dec'25 Metrics Aug'26 Jan'26-Aug'26 Jan'25-Dec'25
Contributions (PEPM)6 $1,365.01 $1,368.91 $1,307.96 Avg. # of Employees 1,965 1,946 1,891
Net Paid Medical Claims (PEPM) $1,011.02 $1,030.16 $1,204.23 Avg. # of Members 4,991 4,955 4,817
Net Paid Rx Claims (PEPM) $321.92 $262.12 $263.17 Ratio Members to EEs 2.54 2.55 2.55
Total Claims (PEPM) $1,332.94 $1,292.29 $1,467.40 Age/Gender Index 1 - 0.941 0.943
Stop Loss & Adm Expenses (PEPM) $208.79 $197.80 $227.70
Total Claims & Expenses (PEPM) $1,541.73 $1,490.09 $1,695.11 Medical Utilization
Surplus/Deficit (PEPM) -$176.72 -$121.17 -$387.15
Loss Ratio 113% 109% 130% Large Claimants (> $100,000)
PEPM % Change 3.5% -12.1% Metrics Jan'26-Aug'26 Jan'25-Aug'25 % Change
# of Claimants 26 26 0.0%
$ of Medical/Rx Paid Claims $4,229,760 $4,577,230 -7.6%
Prescription Drugs (Rx) % of Medical/Rx Paid Claims 20.7% 21.5% -3.8%
Inpatient Hospital
Pharmacy Spend2 Metrics Jan'26-Aug'26 Jan'25-Dec'25 % Change
Metrics Jan'26-Aug'26 Jan'25-Dec'25 % Change Bed Days/1,000 258.2 259.7 -0.6%
Generic (PEPM) $18.94 $21.71 -12.7% Avg Length of Stay 5.4 4.4 21.8%
Brand Preferred (PEPM) $233.50 $231.25 1.0%
Brand Non-Preferred (PEPM) $8.25 $11.42 -27.8% Medical Network
Specialty (PEPM) $277.42 $313.55 -11.5%
Total (PEPM) $538.12 $577.93 -6.9% Medical In-Network Usage & Discounts
Pharmacy Retail vs Mail Order Metrics Jan'26-Aug'26 Jan'25-Dec'25 % Change
Metrics Jan'26-Aug'26 Jan'25-Dec'25 % Change In-Network Allowed % 99.5% 96.1% 3.5%
Retail Scripts PMPY 10.84 11.72 -7.6% Discount from Billed5 69.1% 66.0% 4.8%
Mail Order Scripts PMPY 0.45 0.47 -2.7%
% Mail Order 4.0% 3.8% 5.1% Medical/Rx Plan Design
Pharmacy Per Script Metrics2
Metrics Jan'26-Aug'26 Jan'25-Dec'25 % Change Medical/Rx Plan - Member Cost Sharing3
Generic Dispensing Rate 83.4% 83.2% 0.2% Metrics Jan'26-Aug'26 Jan'25-Dec'25 % Change
Generic Plan Paid/Script $7.57 $8.47 -10.7% Member Cost Share % 16.4% 11.8% 38.7%
Brand Plan Paid/Script $533.89 $518.27 3.0% Plan Paid % 83.6% 88.2% -5.2%
Specialty Plan Paid/Script $6,098.41 $6,533.39 -6.7%
Total Plan Paid/Script $179.33 $187.76 -4.5%
(1) BCBS factor for measuring the cost deviation of a population from that of a benchmark population based on age and gender attributes.
(2) The amount that plan participants enrolled in the White plan pay for their prescription drugs is not included in the Pharmacy Spend and Pharmacy Per Script Metric sections of the Dashboard because the information is not
available broken down by pharmacy category in the BCBSAZ Whyzen system. Differences in pharmacy spend may also be due to the reporting data source.
(3) Cost share means the member's out-of-pocket expense compared to the sum of plan paid claims plus member out-of-pocket. Percentages do not reflect employee contributions.
(4) Percentages are rounded to the first decimal.
(5) Dashboard Large Claims data is taken from the BCBSAZ Whyzen reporting tool, which is a utilization "snapshot in time" possibly resulting in a difference between the dashboard and the monthly report.
6009993 2

City of Chandler
2025-2026 Medical/Rx Contributions and Expenses
Year-to-date through August 2026
Total Paid Claims Surplus/
Month Enrollment Contributions1 Medical Paid2,3 Stop Loss Refunds Rx Paid Rx Rebates Net Claims Expenses4 and Expenses (Deficit) Total Loss Ratio
Jan-25 1,888 $2,466,316 $1,305,024 ($24,025) $445,129 $0 $1,726,127 $421,069 $2,147,196 $319,120 87.1%
Feb-25 1,888 $2,463,414 $1,597,614 ($883) $458,094 ($176,701) $1,878,125 $425,517 $2,303,642 $159,772 93.5%
Mar-25 1,886 $2,466,464 $2,482,351 ($897) $379,806 $0 $2,861,261 $431,031 $3,292,292 ($825,827) 133.5%
Apr-25 1,883 $2,461,954 $2,248,996 ($44,893) $575,693 $0 $2,779,796 $429,998 $3,209,794 ($747,839) 130.4%
May-25 1,871 $2,448,132 $2,424,209 ($240) $486,142 ($172,934) $2,737,178 $431,398 $3,168,576 ($720,443) 129.4%
Jun-25 1,875 $2,452,954 $2,005,554 ($411) $600,164 $0 $2,605,307 $402,132 $3,007,439 ($554,484) 122.6%
Jul-25 1,882 $2,463,067 $2,865,701 ($26) $580,271 $0 $3,445,946 $414,929 $3,860,875 ($1,397,808) 156.8%
Aug-25 1,893 $2,479,584 $2,468,819 ($98,917) $525,941 ($186,362) $2,709,481 $445,941 $3,155,422 ($675,838) 127.3%
Sep-25 1,892 $2,475,194 $2,658,890 ($1,648) $650,647 $0 $3,307,889 $411,447 $3,719,337 ($1,244,143) 150.3%
Oct-25 1,901 $2,489,674 $2,983,630 ($212,167) $720,400 ($199,888) $3,291,975 $429,803 $3,721,778 ($1,232,105) 149.5%
Nov-25 1,914 $2,501,278 $2,218,334 ($328,599) $665,265 $0 $2,555,000 $448,245 $3,003,245 ($501,967) 120.1%
Dec-25 1,917 $2,509,478 $3,400,703 ($623,073) $619,656 $0 $3,397,286 $475,078 $3,872,364 ($1,362,887) 154.3%
2025 Total 22,690 $29,677,509 $28,659,826 ($1,335,778) $6,707,209 ($735,885) $33,295,371 $5,166,587 $38,461,958 ($8,784,449) 129.6%
2025 Avg. 1,891 $2,473,126 $2,388,319 ($111,315) $558,934 ($61,324) $2,774,614 $430,549 $3,205,163 ($732,037) 129.6%
Jan-26 1,947 $2,670,878 $1,468,995 ($30,808) $564,997 ($223,891) $1,779,293 $343,834 $2,123,127 $547,751 79.5%
Feb-26 1,942 $2,660,682 $1,695,626 ($4,984) $512,768 $0 $2,203,410 $356,237 $2,559,647 $101,035 96.2%
Mar-26 1,941 $2,658,442 $2,053,214 ($1,478) $470,139 $0 $2,521,875 $306,013 $2,827,888 ($169,446) 106.4%
Apr-26 1,940 $2,657,244 $1,852,877 ($65) $637,457 $0 $2,490,268 $327,129 $2,817,397 ($160,152) 106.0%
May-26 1,949 $2,665,443 $2,661,926 $0 $509,090 ($224,903) $2,946,113 $493,254 $3,439,367 ($773,924) 129.0%
Jun-26 1,942 $2,657,016 $2,188,197 ($120) $532,447 $0 $2,720,524 $451,654 $3,172,178 ($515,162) 119.4%
Jul-26 1,943 $2,660,685 $2,168,609 $0 $670,309 $0 $2,838,918 $391,143 $3,230,061 ($569,377) 121.4%
Aug-26 1,965 $2,682,237 $1,987,010 ($365) $632,581 $0 $2,619,227 $410,268 $3,029,495 ($347,258) 112.9%
Sep-26
Oct-26
Nov-26
Dec-26
2026 Total 15,569 $21,312,627 $16,076,454 ($37,820) $4,529,788 ($448,794) $20,119,628 $3,079,532 $23,199,160 ($1,886,533) 108.9%
2026 Avg. 1,946 $2,664,078 $2,009,557 ($4,727) $566,223 ($56,099) $2,514,953 $384,942 $2,899,895 ($235,817) 108.9%
(1) Contributions for COBRA are assumed to be the same as the Actives. (2) Medical Paid claims include BCBSAZ AEA amounts, access fees, and capitation.
(3) Medical Paid claims includes retroactive adjustments which causes discrepancies when comparing to BCBSAZ invoices. (4) Expenses include prorated monthly PCORI fees and budgeted interest income as an offset to operating expenses.
(5) Enrollment may change retrospectively based on updated BCBSAZ reporting.
2026 vs 2025 Cumulative Paid Claims & Expenses
2026 Cumulative Claims & Expenses 2025 Cumulative Claims & Expenses
$38,461,958
$34,589,594
Dollars $20,169,665 $23,199,160 $27,864,571 $31,586,349
$13,767,426 $16,939,604 $24,145,234
$7,510,662 $10,328,059 $17,128,937 $20,989,812
$2,123,127 $4,682,774 $14,121,499
$10,952,923
$2,147,196 $4,450,838 $7,743,129
Jan. Feb. Mar. Apr. May Jun. Jul. Aug. Sept. Oct. Nov. Dec.
Month
6009993 3

City of Chandler
2026 Medical/Rx Paid Claims by Plan and Status
Year-to-date through August 2026
Medical/Rx YTD Claims Paid by Plan and Status -- 2026 Plan Year
Actives '26 Retirees '26 All '26
$2,596
Claims $1,791 $1,875 $1,578 $1,797
(PEPM) $1,619 $1,412 $1,466 $1,324
$1,257
$911 $983
Red Blue White All Plans
Plan
Medical/Rx Claims Paid by Plan and Status -- 2025 Plan Year
Actives '25 Retirees '25 All '25
$2,720
$2,422 $2,431
$1,924 $2,002
Claims $1,334 $1,546 $1,441 $1,559
(PEPM) $1,379 $1,130 $1,291
Red Blue White All Plans
Plan
Notes:
Paid claims illustrated include capitation but are not reduced for stop loss reimbursements and prescription drug rebates.
The claims information by Active and Retiree status is approximate based on the status information reported to Blue Cross Blue Shield as of the date the claim was adjudicated.
6009993 4

City of Chandler
2026 Enrollment by Status and Plan
Year-to-date through August 2026
Month Active Red Active Blue Active White Active Total Retiree Red Retiree Blue Retiree White Retiree Total Total Red Total Blue Total White Total All
Jan-26 616 69 1,001 1,686 80 18 163 261 696 87 1,164 1,947
Feb-26 610 69 1,019 1,698 73 18 153 244 683 87 1,172 1,942
Mar-26 611 71 1,019 1,701 72 18 150 240 683 89 1,169 1,941
Apr-26 613 71 1,019 1,703 71 17 149 237 684 88 1,168 1,940
May-26 618 70 1,027 1,715 69 17 148 234 687 87 1,175 1,949
Jun-26 611 70 1,024 1,705 69 17 151 237 680 87 1,175 1,942
Jul-26 613 70 1,022 1,705 69 17 152 238 682 87 1,174 1,943
Aug-26 615 70 1,044 1,729 68 17 151 236 683 87 1,195 1,965
Sep-26
Oct-26
Nov-26
Dec-26
2026 Avg. 613 70 1,022 1,705 71 17 152 241 685 87 1,174 1,946
% of Total 31.5% 3.6% 52.5% 87.6% 3.7% 0.9% 7.8% 12.4% 35.2% 4.5% 60.3% 100.0%
2025 Avg. 632 78 956 1,666 68 21 136 225 700 99 1,092 1,891
% Change -2.9% -9.9% 6.9% 2.4% 4.6% -16.9% 11.9% 7.0% -2.2% -11.4% 7.5% 2.9%
Active Enrollment by Plan
1,500 Active Red Active Blue Active White
1,000
Count
500
-
Jan-26 Feb-26 Mar-26 Apr-26 May-26 Jun-26 Jul-26 Aug-26 Sep-26 Oct-26 Nov-26 Dec-26
Month
Retiree Enrollment by Plan
Retiree Red Retiree Blue Retiree White
200
150
Count 100
50
-
Jan-26 Feb-26 Mar-26 Apr-26 May-26 Jun-26 Jul-26 Aug-26 Sep-26 Oct-26 Nov-26 Dec-26
Month
6009993 5

City of Chandler
Enrollment by Tier
Year-to-date through August 2026
Month Red EE Red EE+SP Red EE+Ch(rn) Red EE+Fam Blue EE Blue EE+SP Blue EE+Ch(rn) Blue EE+Fam White EE White EE+SP White EE+Ch(rn) White EE+Fam
Jan-26 169 136 92 219 28 9 12 20 350 108 109 434
Feb-26 165 137 90 218 28 9 12 20 363 109 109 438
Mar-26 165 138 92 216 30 9 12 20 363 111 107 438
Apr-26 168 137 92 216 30 9 12 20 363 111 107 438
May-26 169 136 96 217 30 8 12 20 369 113 108 437
Jun-26 166 135 95 215 30 8 12 20 366 114 106 438
Jul-26 168 135 94 216 30 8 12 20 364 112 107 439
Aug-26 169 137 93 216 30 8 12 20 376 116 108 444
Sep-26
Oct-26
Nov-26
Dec-26
2026 Total 1,339 1,091 744 1,733 236 68 96 160 2,914 894 861 3,506
2026 Avg. 167 136 93 217 30 9 12 20 364 112 108 438
Month Red Retiree Red Ret+SP Red Ret+Ch(rn) Red Ret+Fam Blue Retiree Blue Ret+SP Blue Ret+Ch(rn) Blue Ret+Fam White Retiree White Ret+SP White Ret+Ch(rn) White Ret+Fam
Jan-26 34 34 7 5 10 7 - 1 64 55 10 34
Feb-26 30 32 7 4 10 7 - 1 59 50 10 34
Mar-26 29 32 7 4 10 7 - 1 58 48 10 34
Apr-26 28 32 7 4 9 7 - 1 57 48 10 34
May-26 28 31 6 4 9 7 - 1 56 48 10 34
Jun-26 28 31 6 4 9 7 - 1 57 48 10 36
Jul-26 28 31 6 4 9 7 - 1 57 48 10 37
Aug-26 28 30 6 4 9 7 - 1 57 48 10 36
Sep-26
Oct-26
Nov-26
Dec-26
2026 Total 233 253 52 33 75 56 - 8 465 393 80 279
2026 Avg. 29 32 7 4 9 7 - 1 58 49 10 35
6009993 6

City of Chandler
Enrollment by Tier
Plan Year 2025
Month Red EE Red EE+SP Red EE+Ch(rn) Red EE+Fam Blue EE Blue EE+SP Blue EE+Ch(rn) Blue EE+Fam White EE White EE+SP White EE+Ch(rn) White EE+Fam
Jan-25 186 146 89 217 38 9 11 17 329 106 103 426
Feb-25 186 145 91 215 40 9 11 17 332 104 103 423
Mar-25 186 143 90 219 39 10 11 17 332 104 101 424
Apr-25 182 141 88 219 40 9 11 17 331 105 101 421
May-25 179 136 89 221 41 9 10 17 329 105 102 417
Jun-25 181 135 90 224 42 10 10 16 327 108 102 411
Jul-25 184 132 91 225 41 10 10 17 323 108 105 414
Aug-25 183 128 92 228 40 9 10 18 325 112 105 413
Sep-25 179 127 93 228 41 9 10 18 327 110 105 410
Oct-25 178 129 92 231 40 8 11 20 330 109 106 406
Nov-25 180 131 93 228 39 8 12 20 334 110 107 407
Dec-25 179 132 93 229 39 9 12 20 333 110 107 412
2025 Total 2,183 1,625 1,091 2,684 480 109 129 214 3,952 1,291 1,247 4,984
2025 Avg. 182 135 91 224 40 9 11 18 329 108 104 415
Month Red Retiree Red Ret+SP Red Ret+Ch(rn) Red Ret+Fam Blue Retiree Blue Ret+SP Blue Ret+Ch(rn) Blue Ret+Fam White Retiree White Ret+SP White Ret+Ch(rn) White Ret+Fam
Jan-25 25 29 5 3 11 7 1 1 65 40 7 17
Feb-25 27 28 5 4 11 7 1 1 62 40 7 19
Mar-25 27 27 5 4 12 6 1 1 60 40 7 20
Apr-25 28 29 5 4 11 7 1 1 62 41 7 22
May-25 28 29 5 4 11 7 1 1 61 40 7 22
Jun-25 28 30 6 3 11 7 1 1 61 41 7 23
Jul-25 28 30 6 3 12 7 1 1 63 41 7 23
Aug-25 29 33 6 3 12 7 1 1 63 42 7 26
Sep-25 31 32 7 3 12 7 1 1 64 43 8 26
Oct-25 31 32 7 3 14 8 - 1 63 44 9 29
Nov-25 31 32 8 3 14 8 - 1 64 44 9 31
Dec-25 31 31 8 3 13 8 - 1 62 44 11 30
2025 Total 344 362 73 40 144 86 9 12 750 500 93 288
2025 Avg. 29 30 6 3 12 7 1 1 63 42 8 24
6009993 7

City of Chandler
2026 Contributions and Paid Claims by Status and Plan
Year-to-date through August 2026
Medical Plan Active Enrollment Active Contributions Active Claims & Expenses Active Loss Ratio Retiree Enrollment Retiree Contributions Retiree Claims & Expenses Retiree Loss Ratio Total Enrollment Total Contributions Total Claims & Expenses Total Loss Ratio
All Plans 13,642 $19,023,752 $19,843,680 104% 1,927 $2,288,875 $3,842,093 168% 15,569 $21,312,627 $23,685,774 111%
% of Total 87.6% 89.3% 83.8% 12.4% 10.7% 16.2% 100.0% 100.0% 100.0%
Red Plan 4,907 $8,581,467 $9,757,818 114% 571 $823,053 $1,594,535 194% 5,478 $9,404,521 $11,352,353 121%
% of Total 90% 91% 86% 10% 9% 14% 35% 44% 48%
Blue Plan 560 $772,359 $1,017,167 132% 139 $159,988 $223,593 140% 699 $932,347 $1,240,760 133%
% of Total 80% 83% 82% 20% 17% 18% 4% 4% 5%
White Plan 8,175 $9,669,925 $9,068,696 94% 1,217 $1,305,834 $2,023,965 155% 9,392 $10,975,759 $11,092,661 101%
% of Total 87% 88% 82% 13% 12% 18% 60% 51% 47%
Notes:
Paid claims include capitation but are unadjusted for stop loss reimbursements and prescription drug rebates.
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 Blue Cross Blue Shield as of the date the claim was adjudicated.
Active Contributions vs Claims and Expenses
Contributions Claims & Expenses
$19,023,752
$14,245,499 $16,622,176
Dollars $9,483,755 $11,870,836 $19,843,680
$4,735,081 $7,108,745 $14,693,509 $17,245,232
$2,363,146 $12,056,363
$1,922,435 $4,045,335 $6,509,311 $8,949,356
Jan-26 Feb-26 Mar-26 Apr-26 May-26 Jun-26 Jul-26 Aug-26 Sep-26 Oct-26 Nov-26 Dec-26
Month
Retiree Contributions vs Claims and Expenses
Contributions Claims & Expenses
$3,410,682 $3,842,093
Dollars $2,197,192 $2,732,344
$1,262,512 $1,639,929
$455,391 $897,122
$1,724,207 $2,008,214 $2,288,875
$307,733 $596,479 $881,258 $1,163,491 $1,441,854
Jan-26 Feb-26 Mar-26 Apr-26 May-26 Jun-26 Jul-26 Aug-26 Sep-26 Oct-26 Nov-26 Dec-26
Month
6009993 8

City of Chandler
2026 Contributions and Expenses by Status and Plan
Year-to-date through August 2026
Active Surplus/(Deficit) by Plan Retiree Surplus/(Deficit) by Plan
Contributions Claims+Expenses Surplus/(Deficit) Contributions Claims+Expenses Surplus/(Deficit)
$2,793
$1,749 $1,989 $1,816 $1,994
$1,379 $1,394 $1,455 $1,441 $1,609 $1,663
$1,183 $1,109 $1,151 $1,073 $1,188
Dollars Dollars
(PEPM) $74 (PEPM)
($60)
($240) ($437) ($458)
($590) ($806)
($1,351)
Red Blue White All Plans Red Blue White All Plans
Plan Plan
Enrollment Contributions Claims and Expenses
12% 11% 16%
88%
89% 84%
Active Retiree Active Retiree Active Retiree
Notes:
Claims include capitation (allocated by claims paid year-to-date), but are unreduced for stop loss reimbursements.
The claims information by Active and Retiree status is approximate based on the status information reported to Blue Cross as of the date the claim was adjudicated.
Expenses on these graphs are limited to self-insurance administrative fees, PCORI fees, and paid claims.
6009993 9

City of Chandler
2026 Incurred Medical Claims Paid in Excess of $100,000
Year-to-date through August 2026
Medical/Rx Claims Paid in Excess of $100,000 vs. All Other
Claims Paid
20.5%
79.5%
Large Claims
All Other Medical/Rx
Claims
Medical/Rx Paid in Excess
of $350K Stop Loss
Rank Plan Medical/Rx Paid YTD Deductible
1 Red Plan $345,855 $0
2 White Plan $328,416 $0
3 White Plan $276,534 $0
4 Blue Plan $274,857 $0
5 Red Plan $241,027 $0
6 Red Plan $175,861 $0
7 White Plan $166,969 $0
8 Red Plan $164,084 $0
9 Red Plan $163,304 $0
10 White Plan $151,902 $0
11 White Plan $149,573 $0
12 Red Plan $149,463 $0
13 White Plan $147,653 $0
14 Red Plan $135,208 $0
15 Red Plan $127,960 $0
16 Red Plan $122,380 $0
17 Red Plan $120,047 $0
18 White Plan $117,857 $0
19 Red Plan $117,226 $0
20 White Plan $115,701 $0
21 Red Plan $111,183 $0
22 Red Plan $109,844 $0
23 Red Plan $106,951 $0
24 Red Plan $106,651 $0
25 White Plan $101,812 $0
26 White Plan $101,443 $0
Total of twenty-six claimants $4,229,760 $0
Percentage of Total
Medical/Rx Paid: 20.5%
6009993 10

City of Chandler
Thirteen Month Snapshot - Medical and Rx Plan Paid Claims Through August 2026
Rolling Twelve Month Net Medical Claims Rolling Twelve Month Rx Claims PEPM
PEPM
$1,204 $1,209 $305 $307 $306
$1,169 $1,180 $300
$1,125 $1,208 $1,127 $293 $307 $310
$1,153 $1,188 $1,176 $302 $303
Claims $1,147 Claims $281 $296
(PEPM) $1,024$1,068 (PEPM) $290
Net Medical Trend 10.1% Rx Trend 12.4%
$276
12-Month Period Ending 12-Month Period Ending
(b) (c) (d)=(b)+(c) (d)/(a) (e)/(a)
Twelve Month (a) Medical Claims Stop Loss Net Medical (e) (f)=(d)+(e) Net Medical Rx Claims
Period Ending Enrollment Paid Reimbursements Claims Rx Paid Net Claims Claims PEPM PEPM
Aug-25 22,586 $23,334,558 ($210,962) $23,123,596 $6,226,059 $29,349,655 $1,023.80 $275.66
Sep-25 22,605 $24,343,986 ($212,133) $24,131,853 $6,360,738 $30,492,591 $1,067.54 $281.39
Oct-25 22,625 $25,880,639 ($424,281) $25,456,357 $6,554,935 $32,011,292 $1,125.14 $289.72
Nov-25 22,659 $26,879,270 ($752,880) $26,126,389 $6,634,091 $32,760,481 $1,153.02 $292.78
Dec-25 22,690 $28,659,826 ($1,335,778) $27,324,048 $6,707,209 $34,031,256 $1,204.23 $295.60
Jan-26 22,749 $28,823,797 ($1,342,560) $27,481,236 $6,827,077 $34,308,313 $1,208.02 $300.10
Feb-26 22,803 $28,921,808 ($1,346,662) $27,575,146 $6,881,751 $34,456,897 $1,209.28 $301.79
Mar-26 22,858 $28,492,671 ($1,347,243) $27,145,428 $6,972,084 $34,117,512 $1,187.57 $305.02
Apr-26 22,915 $28,096,552 ($1,302,415) $26,794,137 $7,033,847 $33,827,984 $1,169.28 $306.95
May-26 22,993 $28,334,269 ($1,302,176) $27,032,093 $7,056,795 $34,088,888 $1,175.67 $306.91
Jun-26 23,060 $28,516,912 ($1,301,885) $27,215,028 $6,989,078 $34,204,105 $1,180.18 $303.08
Jul-26 23,121 $27,819,820 ($1,301,858) $26,517,962 $7,079,115 $33,597,077 $1,146.92 $306.18
Aug-26 23,193 $27,338,011 ($1,203,306) $26,134,705 $7,185,755 $33,320,460 $1,126.84 $309.82
Notes:
Medical Claims Paid includes capitation.
6009993 11