Segal Report

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 
 
 
 
5976954v1/00914.015 
 
 
 
February 4, 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, 2025 through December 31, 2025 – Data through December 
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 December 31, 2025. 
For the month of December, Medical paid claims were approximately $3,400,700 while net Rx 
claims were about $619,700. For the 2025 plan year to date, claims and expenses (after stop-
loss reimbursements and pharmacy rebates) exceeded contributions by approximately 
$8,784,400 or 29.6% of contributions. Based on paid claims and expenses, Actives and 
Retirees on the Red Plan, Blue Plan, and White Plan experienced an operating deficit, as 
displayed on Page 8. 
There are fifty-five claimants with paid claims in excess of $100,000 during the reporting period. 
There are six 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 $126,692 per month from the estimated 2025 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 December 2025, approximately 36.8% of all active employees and retirees were enrolled in 
the Red plan, with 5.3% enrolled in the Blue plan, and 57.9% enrolled in the White plan. The 
average total enrollment in 2025 is approximately 1.1% higher than the 2024 average 
enrollment.

Fernanda Acurio 
February 4, 2026 
Page 2 
 
5976954v1/00914.015 
 
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 yours, 
Rachel Calisi, GBDS, CEBS 
Senior Health Consultant

City of Chandler
(Data Through December 2025)
2/4/2026
Presented by: Rachel Calisi and Mary Fedor
© 2026 by The Segal Group Inc.
Medical/Rx Monthly Reporting:    
January 2025 - December 2025

Dec'25
Jan'25-Dec'25
Jan'24-Dec'24
Dec'25
Jan'25-Dec'25
Jan'24-Dec'24
Contributions (PEPM)
$1,309.06
$1,307.96
$1,218.43
Avg. # of Employees
1,917
1,891
1,871
Net Paid Medical Claims (PEPM)
$1,448.95
$1,204.23
$868.80
Avg. # of Members
4,884
4,817
4,732
Net Paid Rx Claims (PEPM)
$323.24
$263.17
$257.63
Ratio Members to EEs
2.55
2.55
2.53
Total Claims (PEPM)
$1,772.19
$1,467.40
$1,126.42
Age/Gender Index 1
-
0.943
0.944
Stop Loss & Adm Expenses (PEPM)
$247.82
$227.70
$212.71
Total Claims & Expenses (PEPM)
$2,020.01
$1,695.11
$1,339.13
Surplus/Deficit (PEPM)
-$710.95
-$387.15
-$120.70
Loss Ratio
154%
130%
110%
PEPM % Change
19.2%
26.6%
Jan'25-Dec'25
Jan'24-Dec'24
% Change
# of Claimants
55
50
10.0%
$ of Medical/Rx Paid Claims
$11,714,881
$8,931,201
31.2%
% of Medical/Rx Paid Claims
33.3%
34.7%
-3.9%
Jan'25-Dec'25
Jan'24-Dec'24
% Change
Jan'25-Dec'25
Jan'24-Dec'24
% Change
Bed Days/1,000
249.1
234.0
6.5%
Generic (PEPM)
$20.84
$23.34
-10.7%
Avg Length of Stay
4.4
5.3
-17.5%
Brand Preferred (PEPM)
$220.44
$196.82
12.0%
Brand Non-Preferred (PEPM)
$10.84
$20.70
-47.6%
Specialty (PEPM)
$294.83
$278.25
6.0%
Total (PEPM)
$546.94
$519.10
5.4%
Jan'25-Dec'25
Jan'24-Dec'24
% Change
Jan'25-Dec'25
Jan'24-Dec'24
% Change
In-Network Allowed %
96.6%
96.2%
0.4%
Retail Scripts PMPY
11.22
11.00
2.1%
Discount from Billed5
65.8%
68.2%
-3.4%
Mail Order Scripts PMPY
0.44
0.39
12.6%
% Mail Order
3.8%
3.5%
9.9%
Jan'25-Dec'25
Jan'24-Dec'24
% Change
Generic Dispensing Rate
83.3%
83.4%
0.0%
Jan'25-Dec'25
Jan'24-Dec'24
% Change
Generic Plan Paid/Script
$8.46
$9.86
-14.2%
Member Cost Share %
12.2%
14.7%
-17.4%
Brand Plan Paid/Script
$516.73
$499.13
3.5%
Plan Paid %
87.8%
85.3%
3.0%
Specialty Plan Paid/Script
$6,526.48
$7,541.56
-13.5%
Total Plan Paid/Script
$185.10
$182.82
1.2%
Inpatient Hospital
City of Chandler
HealthPlan Dashboard - Data thru December 2025
Income vs Paid Medical/Rx Claims + Expenses
Demographics
Large Claimants (> $100,000)
1
Pharmacy Spend 2
Medical In-Network Usage & Discounts
Pharmacy Retail vs Mail Order
Pharmacy Per Script Metrics2
Medical/Rx Plan - Member Cost Sharing 3
(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.                                                                                                                                                                                                   
5976824
Financial
Prescription Drugs (Rx)
Enrollment
Medical Utilization
Medical Network
Medical/Rx Plan Design

Month
Enrollment
Contributions1
Medical Paid2,3
Stop Loss Refunds
Rx Paid
Rx Rebates
Net Claims
Expenses4
Total Paid Claims 
and Expenses
Surplus/
(Deficit)
Total Loss 
Ratio
Jan-24
1,837
$2,255,077
$2,391,086
($121,423)
$410,269
$0
$2,679,932
$327,895
$3,007,827
($752,750)
133.4%
Feb-24
1,871
$2,282,167
$1,181,504
($92,637)
$432,642
$0
$1,521,510
$386,675
$1,908,185
$373,982
83.6%
Mar-24
1,866
$2,276,847
$1,419,172
($20,165)
$414,950
$0
$1,813,957
$395,792
$2,209,748
$67,098
97.1%
Apr-24
1,861
$2,267,739
$1,725,393
($8,572)
$409,060
$0
$2,125,881
$428,808
$2,554,689
($286,950)
112.7%
May-24
1,867
$2,269,373
$1,793,138
$0
$543,123
$0
$2,336,261
$393,110
$2,729,371
($459,998)
120.3%
Jun-24
1,866
$2,268,861
$1,764,187
($1,853)
$591,275
$0
$2,353,608
$390,143
$2,743,751
($474,890)
120.9%
Jul-24
1,879
$2,282,875
$1,783,173
($67,503)
$560,440
$0
$2,276,109
$428,029
$2,704,139
($421,264)
118.5%
Aug-24
1,879
$2,285,642
$1,861,896
($2,003)
$565,136
$0
$2,425,029
$401,274
$2,826,303
($540,662)
123.7%
Sep-24
1,873
$2,282,149
$1,649,463
($477)
$515,968
$0
$2,164,953
$411,554
$2,576,508
($294,358)
112.9%
Oct-24
1,881
$2,290,288
$1,446,977
($18)
$526,203
$0
$1,973,162
$394,475
$2,367,637
($77,349)
103.4%
Nov-24
1,880
$2,290,795
$1,219,703
$0
$586,109
($319,040)
$1,486,772
$409,738
$1,896,510
$394,285
82.8%
Dec-24
1,886
$2,297,060
$1,620,147
($40,176)
$546,539
$0
$2,126,510
$406,916
$2,533,427
($236,367)
110.3%
2024 Total
22,446
$27,348,873
$19,855,837
($354,825)
$6,101,713
($319,040)
$25,283,685
$4,774,410
$30,058,094
($2,709,222)
109.9%
2024 Avg.
1,871
$2,279,073
$1,654,653
($29,569)
$508,476
($26,587)
$2,106,974
$397,867
$2,504,841
($225,768)
109.9%
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%
2
City of Chandler
2024-2025 Medical/Rx Contributions and Expenses
Year-to-date through December 2025
(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.
(5) Enrollment may change retrospectively based on updated BCBSAZ reporting.
$2,147,196 
$4,450,838 
$7,743,129 
$10,952,923 
$14,121,499 
$17,128,937 
$20,989,812 
$24,145,234 
$27,864,571 
$31,586,349 
$34,589,594 
$38,461,958 
$3,007,827 
$4,916,012 
$7,125,760 
$9,680,449 
$12,409,819 
$15,153,571 
$17,857,709 
$20,684,013 
$23,260,520 
$25,628,157 
$27,524,668 
$30,058,094 
 $-
 $5,000,000
 $10,000,000
 $15,000,000
 $20,000,000
 $25,000,000
 $30,000,000
 $35,000,000
 $40,000,000
 $45,000,000
Jan.
Feb.
Mar.
Apr.
May
Jun.
Jul.
Aug.
Sept.
Oct.
Nov.
Dec.
2025 vs 2024 Cumulative Paid Claims & Expenses
2025 Cumulative Claims & Expenses
2024 Cumulative Claims & Expenses
5976824

Red
Blue
White
Total
Red
Blue
White
Total
Red
Blue
White
Total
Jan-25
638
75
964
1,677
62
20
129
211
700
95
1,093
1,888
Feb-25
637
77
962
1,676
64
20
128
212
701
97
1,090
1,888
Mar-25
638
77
961
1,676
63
20
127
210
701
97
1,088
1,886
Apr-25
630
77
958
1,665
66
20
132
218
696
97
1,090
1,883
May-25
625
77
953
1,655
66
20
130
216
691
97
1,083
1,871
Jun-25
630
78
948
1,656
67
20
132
219
697
98
1,080
1,875
Jul-25
632
78
950
1,660
67
21
134
222
699
99
1,084
1,882
Aug-25
631
77
955
1,663
71
21
138
230
702
98
1,093
1,893
Sep-25
627
78
952
1,657
73
21
141
235
700
99
1,093
1,892
Oct-25
630
79
951
1,660
73
23
145
241
703
102
1,096
1,901
Nov-25
632
79
958
1,669
74
23
148
245
706
102
1,106
1,914
Dec-25
633
80
962
1,675
73
22
147
242
706
102
1,109
1,917
2025 Avg.
632
78
956
1,666
68
21
136
225
700
99
1,092
1,891
% of Total
33%
4%
51%
88%
4%
1%
7%
12%
37%
5%
58%
100%
2024 Avg.
660
75
915
1,650
71
21
129
221
730
96
1,044
1,871
% Change
-4.2%
3.0%
4.6%
1.0%
-3.2%
-0.4%
5.1%
1.9%
-4.1%
2.2%
4.6%
1.1%
3
City of Chandler
2025 Enrollment by Status and Plan
Year-to-date through December 2025
TOTAL
ACTIVE
RETIREE
0
500
1,000
1,500
Jan-25
Feb-25
Mar-25
Apr-25
May-25
Jun-25
Jul-25
Aug-25
Sep-25
Oct-25
Nov-25
Dec-25
Active Enrollment by Plan 
ACTIVE Red
ACTIVE Blue
ACTIVE White
0
50
100
150
200
Jan-25
Feb-25
Mar-25
Apr-25
May-25
Jun-25
Jul-25
Aug-25
Sep-25
Oct-25
Nov-25
Dec-25
Retiree Enrollment by Plan
RETIREE Red
RETIREE Blue
RETIREE White
5976824

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.
4
City of Chandler
2025 Medical/Rx Paid Claims by Plan and Status
Year-to-date through December 2025
$1,924 
$1,334 
$1,130 
$1,441 
$2,720 
$1,546 
$2,422 
$2,431 
$2,002 
$1,379 
$1,291 
$1,559 
$0
$500
$1,000
$1,500
$2,000
$2,500
$3,000
$3,500
Red
Blue
White
All Plans
Claims per Employee per Month
Medical/Rx YTD Claims Paid by Plan and Status -- 2025 Plan Year
Actives '25
Retirees '25
All '25
$1,563 
$1,384 
$740 
$1,099 
$2,064 
$1,544 
$1,337 
$1,589 
$1,611 
$1,419 
$814 
$1,156 
$0
$500
$1,000
$1,500
$2,000
$2,500
$3,000
$3,500
Red
Blue
White
All Plans
Claims per Employee per Month
Medical/Rx Claims Paid by Plan and Status -- 2024 Plan Year
Actives '24
Retirees '24
All '24
5976824

Enrollment
Contributions
Claims & 
Expenses
Active 
Loss Ratio Enrollment Contributions
Claims & 
Expenses
Retiree 
Loss Ratio Enrollment Contributions
Total Claims 
& Expenses
Total Loss 
Ratio
All Plans
19,989
$26,725,990
$33,352,828
125%
2,701
$2,951,519
$7,180,793
243%
22,690
$29,677,509
$40,533,621
137%
% of Total
88%
90%
82%
12%
10%
18%
100%
100%
100%
Red Plan
7,583
$12,571,407
$16,318,867
130%
819
$1,112,893
$2,413,893
217%
8,402
$13,684,300
$18,732,760
137%
% of Total
90%
92%
87%
10%
8%
13%
37%
46%
46%
Blue Plan
932
$1,142,366
$1,455,690
127%
251
$267,595
$445,246
166%
1,183
$1,409,960
$1,900,936
135%
% of Total
79%
81%
77%
21%
19%
23%
5%
5%
5%
White Plan
11,474
$13,012,218
$15,578,271
120%
1,631
$1,571,032
$4,321,654
275%
13,105
$14,583,249
$19,899,926
136%
% of Total
88%
89%
78%
12%
11%
22%
58%
49%
49%
4/10/2015
*
5
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.
Notes: Paid claims include capitation but are unadjusted for stop loss reimbursements and prescription drug rebates.  
City of Chandler
2025 Contributions and Paid Claims by Status and Plan
Year-to-date through December 2025
ACTIVE
RETIREE
TOTAL
Percent of Total rows sum Active and Retiree columns by plan and show each plan's percentage of the total in the Total columns.                             
 $-
 $5,000,000
 $10,000,000
 $15,000,000
 $20,000,000
 $25,000,000
 $30,000,000
 $35,000,000
Jan-25
Feb-25
Mar-25
Apr-25
May-25
Jun-25
Jul-25
Aug-25
Sep-25
Oct-25
Nov-25
Dec-25
$ Year-to-Date
Active Contributions vs Claims and Expenses
 $-
 $1,000,000
 $2,000,000
 $3,000,000
 $4,000,000
 $5,000,000
 $6,000,000
 $7,000,000
 $8,000,000
Jan-25
Feb-25
Mar-25
Apr-25
May-25
Jun-25
Jul-25
Aug-25
Sep-25
Oct-25
Nov-25
Dec-25
$ Year-to-Date
Retiree Contributions vs Claims and Expenses 
 Contributions
 Claims & Expenses
5976824

Month
EE
EE+SP
EE+Ch(rn)
EE+Fam
EE
EE+SP
EE+Ch(rn)
EE+Fam
EE
EE+SP
EE+Ch(rn)
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
Retiree
Ret+SP
Ret+Ch(rn)
Ret+Fam
Retiree
Ret+SP
Ret+Ch(rn)
Ret+Fam
Retiree
Ret+SP
Ret+Ch(rn)
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
0
1
63
44
9
29
Nov-25
31
32
8
3
14
8
0
1
64
44
9
31
Dec-25
31
31
8
3
13
8
0
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
6
City of Chandler
Enrollment by Tier
Year-to-date through December 2025
 Red
 Blue
 White
Actives
Retirees
Red
Blue
White
5976824

Month
EE
EE+SP
EE+Ch(rn)
EE+Fam
EE
EE+SP
EE+Ch(rn)
EE+Fam
EE
EE+SP
EE+Ch(rn)
EE+Fam
Jan-24
181
148
95
233
37
4
16
17
292
101
93
395
Feb-24
185
147
100
229
37
4
17
18
310
104
94
399
Mar-24
188
149
99
228
36
4
17
18
309
102
93
399
Apr-24
190
146
101
226
34
5
18
18
310
100
93
397
May-24
190
144
100
225
34
5
19
17
315
106
94
396
Jun-24
184
142
100
228
34
5
19
17
321
104
95
397
Jul-24
191
144
100
227
34
5
18
17
321
105
99
400
Aug-24
190
141
98
227
33
5
18
17
321
105
99
405
Sep-24
193
142
98
227
32
5
18
17
317
105
97
404
Oct-24
194
142
100
225
35
5
18
19
320
99
97
407
Nov-24
189
142
100
227
36
5
18
19
323
100
97
408
Dec-24
193
141
99
229
37
6
19
19
323
101
97
405
2024 Total
2,268
1,728
1,190
2,731
419
58
215
213
3,782
1,232
1,148
4,812
2024 Avg.
189
144
99
228
35
5
18
18
315
103
96
401
Month
Retiree
Ret+SP
Ret+Ch(rn)
Ret+Fam
Retiree
Ret+SP
Ret+Ch(rn)
Ret+Fam
Retiree
Ret+SP
Ret+Ch(rn)
Ret+Fam
Jan-24
35
30
4
2
13
8
0
1
65
42
7
18
Feb-24
35
29
4
3
12
8
0
1
65
44
7
19
Mar-24
33
29
4
3
12
8
0
1
65
44
7
18
Apr-24
33
30
4
3
13
7
0
1
65
43
7
17
May-24
33
30
4
3
12
7
0
1
65
41
7
19
Jun-24
34
30
4
3
12
7
0
1
64
41
7
17
Jul-24
33
30
5
3
12
7
1
1
62
40
7
17
Aug-24
32
32
6
3
12
7
1
2
62
39
7
17
Sep-24
31
31
6
3
11
7
1
2
61
40
7
18
Oct-24
30
31
6
4
11
7
1
2
62
41
7
18
Nov-24
28
30
6
4
12
6
1
2
61
41
7
18
Dec-24
29
31
6
4
12
6
1
2
60
41
8
17
2024 Total
386
363
59
38
144
85
6
17
757
497
85
213
2024 Avg.
32
30
5
3
12
7
1
1
63
41
7
18
City of Chandler
Enrollment by Tier
Plan Year 2024
 Red
 Blue
 White
7
Actives
Retirees
Red
Blue
White
5976824

4/10/2015
*
8
City of Chandler
2025 Contributions and Expenses by Status and Plan
Year-to-date through December 2025
Claims include capitation (allocated by claims paid year-to-date), but are unreduced for stop loss reimbursements.
Expenses on these graphs are limited to self-insurance administrative fees, PCORI fees, and paid claims.
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.
$1,658 
$1,226 
$1,134 
$1,337 
$2,152 
$1,562 
$1,358 
$1,669 
($494)
($336)
($224)
($332)
-$3,000
-$2,000
-$1,000
$0
$1,000
$2,000
$3,000
$4,000
Red
Blue
White
All Plans
$ per Employee per Month
Active Surplus/(Deficit) by Plan
Contributions
Claims+Expenses
Surplus/(Deficit)
$1,359 
$1,066 
$963 
$1,093 
$2,947 
$1,774 
$2,650 
$2,659 
($1,589)
($708)
($1,686)
($1,566)
-$3,000
-$2,000
-$1,000
$0
$1,000
$2,000
$3,000
$4,000
Red
Blue
White
All Plans
$ per Employee per Month
Retiree Surplus/(Deficit) by Plan
Contributions
Claims+Expenses
Surplus/(Deficit)
88%
12%
Enrollment
Active %
Retiree %
90%
10%
Contributions
Active
Retiree
82%
18%
Claims and Expenses
Active
Retiree
5976824

Rank
Plan
Medical/Rx Paid YTD
Medical/Rx Paid in Excess of 
$350K Stop Loss Deductible
1
White Plan
$925,012
$575,012
2
Red Plan
$655,550
$305,550
3
White Plan
$518,225
$168,225
4
White Plan
$451,292
$101,292
5
Red Plan
$412,769
$62,769
6
White Plan
$401,483
$51,483
7
White Plan
$316,159
$0
8
Red Plan
$279,880
$0
9
White Plan
$279,701
$0
10
Red Plan
$263,607
$0
11
White Plan
$263,490
$0
12
Red Plan
$261,347
$0
13
Red Plan
$240,758
$0
14
Red Plan
$225,932
$0
15
White Plan
$223,065
$0
16
Red Plan
$218,913
$0
17
Blue Plan
$202,216
$0
18
White Plan
$196,584
$0
19
Red Plan
$185,302
$0
20
Red Plan
$185,044
$0
21
Red Plan
$184,210
$0
22
White Plan
$182,859
$0
23
Blue Plan
$178,814
$0
24
Red Plan
$177,523
$0
25
Red Plan
$172,224
$0
26
White Plan
$168,071
$0
27
White Plan
$167,954
$0
28
Red Plan
$167,388
$0
29
White Plan
$164,015
$0
30
White Plan
$163,824
$0
31
Red Plan
$159,221
$0
32
White Plan
$156,785
$0
33
White Plan
$155,831
$0
34
White Plan
$154,670
$0
35
Red Plan
$154,239
$0
36
White Plan
$148,107
$0
37
Red Plan
$145,812
$0
38
Red Plan
$143,235
$0
39
Red Plan
$141,323
$0
40
White Plan
$141,011
$0
41
Red Plan
$140,797
$0
42
White Plan
$139,063
$0
43
White Plan
$134,889
$0
44
White Plan
$125,127
$0
45
Blue Plan
$122,806
$0
46
Red Plan
$118,957
$0
47
Red Plan
$118,419
$0
48
Red Plan
$116,698
$0
49
Red Plan
$114,579
$0
50
White Plan
$114,213
$0
51
Blue Plan
$110,192
$0
52
Red Plan
$109,932
$0
53
White Plan
$108,702
$0
54
Red Plan
$105,171
$0
55
Red Plan
$101,889
$0
$11,714,881
$1,264,331
33.1%
City of Chandler
2025 Incurred Medical Claims Paid in Excess of $100,000
Year-to-date through December 2025
9
Total of fifty-five claimants
Percentage of Total Medical/Rx Paid:
33.1%
66.9%
Large Claims
All Other Medical/Rx
Claims
5976824

Twelve Month Period 
Ending
(a)
Enrollment
(b)
Medical Claims 
Paid
(c)
Stop Loss 
Reimbursements
(d)=(b)+(c)
Net Medical 
Claims
(e)
Rx Paid
(f)=(d)+(e)
Net Claims
(d)/(a)
Net Medical 
Claims PEPM
(e)/(a)
Rx Claims PEPM
Dec-24
22,446
$19,855,837
($354,825)
$19,501,011
$6,101,713
$25,602,725
$868.80
$271.84
Jan-25
22,497
$18,769,775
($257,428)
$18,512,346
$6,136,573
$24,648,920
$822.88
$272.77
Feb-25
22,514
$19,185,885
($165,674)
$19,020,211
$6,162,025
$25,182,236
$844.82
$273.70
Mar-25
22,534
$20,249,064
($146,406)
$20,102,659
$6,126,881
$26,229,540
$892.10
$271.89
Apr-25
22,556
$20,772,667
($182,727)
$20,589,940
$6,293,515
$26,883,455
$912.84
$279.02
May-25
22,560
$21,403,739
($182,967)
$21,220,772
$6,236,534
$27,457,306
$940.64
$276.44
Jun-25
22,569
$21,645,106
($181,524)
$21,463,582
$6,245,423
$27,709,005
$951.02
$276.73
Jul-25
22,572
$22,727,635
($114,048)
$22,613,587
$6,265,255
$28,878,842
$1,001.84
$277.57
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
Notes:
Medical Claims Paid includes capitation. 
10
City of Chandler
Thirteen Month Snapshot - Medical and Rx Plan Paid Claims Through December 2025
$869
$823
$845 $892
$913
$941
$951
$1,002$1,024
$1,068
$1,125
$1,153
$1,204
$750
$800
$850
$900
$950
$1,000
$1,050
$1,100
$1,150
$1,200
$1,250
Claims per Employee per Month
12-Month Period Ending
Rolling Twelve Month Net Medical Claims PEPM
Net Medical Trend 38.6%
$272 $273 $274 $272
$279 $276 $277 $278 $276
$281
$290 $293 $296
$230
$240
$250
$260
$270
$280
$290
$300
Claims per Employee per Month
12-Month Period Ending
Rolling Twelve Month Rx Claims PEPM
Rx Trend 8.7%
5976824