Medical Trust Actuarial 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 
 
 
 
5858397v1/00914.015 
 
 
 
May 8, 2024 
Rae Lynn Nielsen 
Human Resources Director 
City of Chandler  
PO Box 4008   
Chandler, AZ 85244-4008 
 
Re:   City of Chandler  
  Medical and Prescription Drug Plan Monthly Reporting 
  January 1, 2024 through December 31, 2024 – Data through March 
Dear Rae Lynn:  
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 March 31, 2024. 
For the month of March, Medical paid claims were approximately $1,419,200 while net Rx 
claims were about $415,000. For the 2024 plan year-to-date, claims and expenses (after stop-
loss reimbursements and pharmacy rebates) exceeded contributions by approximately 
$311,700 or 4.6% of contributions. Based on paid claims and expenses, Actives and Retirees 
on the Red Plan and Blue Plan, as well as Retirees on the White Plan experienced an operating 
deficit, as displayed on Page 8. 
There are four claimants with paid claims in excess of $100,000 during the reporting period. 
There are no individuals in the current plan year 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 $125,689 per month from the estimated 2024 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 March 2024, approximately 39.3% of all active employees and retirees were enrolled in the 
Red plan, with 5.1% enrolled in the Blue plan, and 55.6% enrolled in the White plan. The current 
average total enrollment in 2024 is approximately 2.0% higher than the 2023 average 
enrollment.

Rae Lynn Nielsen 
May 8, 2024 
Page 2 
 
5858397v1/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 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. 
I look forward to discussing this report with you. 
Sincerely yours, 
Rachel Calisi, GBDS, CEBS 
Senior Health Consultant

City of Chandler
(Data Through March 2024)
5/8/2024
Presented by: Rachel Calisi
© 2024 by The Segal Group Inc.
Medical/Rx Monthly Reporting:    
January 2024 - December 2024

Mar'24
Jan'24-Mar'24
Jan'23-Dec'23
Mar'24
Jan'24-Mar'24
Jan'23-Dec'23
Contributions (PEPM)
$1,220.18
$1,222.48
$1,141.17
Avg. # of Employees
1,866
1,857
1,818
Net Paid Medical Claims (PEPM)
$749.74
$853.52
$832.44
Avg. # of Members
4,734
4,723
4,678
Net Paid Rx Claims (PEPM)
$222.37
$225.67
$248.75
Ratio Members to EEs
2.54
2.54
2.57
Total Claims (PEPM)
$972.11
$1,079.19
$1,081.19
Age/Gender Index 1
-
0.979
0.983
Stop Loss & Adm Expenses (PEPM)
$212.11
$199.20
$181.52
Total Claims & Expenses (PEPM)
$1,184.22
$1,278.39
$1,262.71
Surplus/Deficit (PEPM)
$35.96
-$55.91
-$121.53
Loss Ratio
97%
105%
111%
PEPM % Change
-7.4%
1.2%
Jan'24-Mar'24
Jan'23-Mar'23
% Change
# of Claimants
4
3
33.3%
$ of Medical/Rx Paid Claims
$469,168
$389,155
20.6%
% of Medical/Rx Paid Claims
7.6%
5.9%
27.4%
Jan'24-Mar'24
Jan'23-Dec'23
% Change
Jan'24-Mar'24
Jan'23-Dec'23
% Change
Bed Days/1,000
NA6
325.4
N/A
Generic (PEPM)
$25.32
$32.50
-22.1%
Avg Length of Stay
NA6
6.7
N/A
Brand Preferred (PEPM)
$194.76
$224.54
-13.3%
Brand Non-Preferred (PEPM)
$13.39
$11.98
11.8%
Specialty (PEPM)
$222.07
$169.80
30.8%
Total (PEPM)
$455.54
$438.81
3.8%
Jan'24-Mar'24
Jan'23-Dec'23
% Change
Jan'24-Mar'24
Jan'23-Dec'23
% Change
In-Network Allowed %
97.8%
97.7%
0.1%
Retail Scripts PMPY
3.01
14.40
-79.1%
Discount from Billed5
67.0%
69.0%
-2.9%
Mail Order Scripts PMPY
0.10
0.45
-77.6%
% Mail Order
3.2%
3.0%
6.9%
Jan'24-Mar'24
Jan'23-Dec'23
% Change
Generic Dispensing Rate
81.7%
81.4%
0.5%
Jan'24-Mar'24
Jan'23-Dec'23
% Change
Generic Plan Paid/Script
$8.18
$10.56
-22.6%
Member Cost Share %
17.6%
13.2%
32.9%
Brand Plan Paid/Script
$320.49
$352.52
-9.1%
Plan Paid %
82.4%
86.8%
-5.0%
Specialty Plan Paid/Script
$5,249.35
$5,004.49
4.9%
Total Plan Paid/Script
$120.23
$116.01
3.6%
Inpatient Hospital
City of Chandler
HealthPlan Dashboard - Data thru March 2024
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.  (6) We are working with BCBSAZ to confirm and report accurate Inpatient Hospital metrics for 2024.                                                                                                                                                                                            
5840459
Financial
Prescription Drugs (Rx)
Enrollment
Medical Utilization
Medical Network
Medical/Rx Plan Design

Month
Enrollment
Contributions1
Medical Paid2,3
Stop Loss Refunds
Rx Paid
Net Claims
Expenses4
Total Paid Claims 
and Expenses
Surplus/
(Deficit)
Total Loss 
Ratio
Jan-23
1,813
$2,072,635
$1,757,955
($529,140)
$346,274
$1,575,089
$310,806
$1,885,895
$186,740
91.0%
Feb-23
1,809
$2,065,461
$2,234,521
($651,299)
$373,487
$1,956,708
$321,404
$2,278,112
($212,651)
110.3%
Mar-23
1,810
$2,069,164
$1,496,646
($141,915)
$307,300
$1,662,031
$321,862
$1,983,893
$85,271
95.9%
Apr-23
1,803
$2,055,673
$1,389,050
($29,892)
$472,317
$1,831,474
$328,899
$2,160,373
($104,700)
105.1%
May-23
1,815
$2,067,151
$1,519,940
($28,001)
$498,414
$1,990,353
$347,770
$2,338,123
($270,973)
113.1%
Jun-23
1,825
$2,076,418
$1,596,502
$2,865
$451,471
$2,050,838
$340,928
$2,391,766
($315,348)
115.2%
Jul-23
1,827
$2,083,387
$1,557,845
($72,498)
$464,618
$1,949,965
$343,702
$2,293,667
($210,279)
110.1%
Aug-23
1,820
$2,082,858
$1,771,460
($243,721)
$510,839
$2,038,578
$334,372
$2,372,950
($290,092)
113.9%
Sep-23
1,835
$2,097,022
$1,683,582
($185,845)
$490,640
$1,988,377
$334,812
$2,323,189
($226,167)
110.8%
Oct-23
1,834
$2,092,480
$1,936,578
($162,907)
$502,805
$2,276,476
$343,721
$2,620,198
($527,718)
125.2%
Nov-23
1,835
$2,092,595
$1,937,863
($105,511)
$536,782
$2,369,134
$299,113
$2,668,247
($575,652)
127.5%
Dec-23
1,842
$2,100,360
$1,687,456
($217,733)
$484,618
$1,954,341
$342,106
$2,296,446
($196,086)
109.3%
2023 Total
21,868
$24,955,206
$20,569,398
($2,365,599)
$5,439,566
$23,643,364
$3,969,495
$27,612,859
($2,657,653)
110.6%
2023 Avg.
1,822
$2,079,601
$1,714,116
($197,133)
$453,297
$1,970,280
$330,791
$2,301,072
($221,471)
110.6%
Jan-24
1,837
$2,255,077
$2,391,086
($121,423)
$410,269
$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
$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
$1,813,957
$395,792
$2,209,748
$67,098
97.1%
Apr-24
May-24
Jun-24
Jul-24
Aug-24
Sep-24
Oct-24
Nov-24
Dec-24
2024 Total
5,574
$6,814,090
$4,991,761
($234,224)
$1,257,861
$6,015,398
$1,110,362
$7,125,760
($311,670)
104.6%
2024 Avg.
1,858
$2,271,363
$1,663,920
($78,075)
$419,287
$2,005,133
$370,121
$2,375,253
($103,890)
104.6%
2
City of Chandler
2023-2024 Medical/Rx Contributions and Expenses
Year-to-date through March 2024
(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.
$3,007,827 
$4,916,012 
$7,125,760 
$1,885,895 
$4,164,007 
$6,147,900 
$8,308,272 
$10,646,396 
$13,038,162 
$15,331,829 
$17,704,779 
$20,027,968 
$22,648,166 
$25,316,413 
$27,612,859 
 $-
 $5,000,000
 $10,000,000
 $15,000,000
 $20,000,000
 $25,000,000
 $30,000,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
5840459

Red
Blue
White
Total
Red
Blue
White
Total
Red
Blue
White
Total
Jan-24
657
74
881
1,612
71
22
132
225
728
96
1,013
1,837
Feb-24
661
76
907
1,644
71
21
135
227
732
97
1,042
1,871
Mar-24
664
75
903
1,642
69
21
134
224
733
96
1,037
1,866
Apr-24
May-24
Jun-24
Jul-24
Aug-24
Sep-24
Oct-24
Nov-24
Dec-24
2024 Avg.
661
75
897
1,633
70
21
134
225
731
96
1,031
1,858
% of Total
36%
4%
48%
88%
4%
1%
7%
12%
39%
5%
55%
100%
2023 Avg.
650
69
881
1,600
75
22
126
223
725
91
1,007
1,822
% Change
1.6%
9.4%
1.9%
2.1%
-5.6%
-2.7%
5.8%
1.2%
0.8%
6.4%
2.4%
2.0%
3
City of Chandler
2024 Enrollment by Status and Plan
Year-to-date through March 2024
TOTAL
ACTIVE
RETIREE
0
500
1,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 Enrollment by Plan 
ACTIVE Red
ACTIVE Blue
ACTIVE White
0
50
100
150
Jan-24
Feb-24
Mar-24
Apr-24
May-24
Jun-24
Jul-24
Aug-24
Sep-24
Oct-24
Nov-24
Dec-24
Retiree Enrollment by Plan
RETIREE Red
RETIREE Blue
RETIREE White
5840459

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
2024 Medical/Rx Paid Claims by Plan and Status
Year-to-date through March 2024
$1,635 
$1,769 
$632 
$1,090 
$1,969 
$1,997 
$914 
$1,345 
$1,667 
$1,820 
$668 
$1,121 
$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 -- 2024 Plan Year
Actives '24
Retirees '24
All '24
$1,504 
$1,223 
$805 
$1,107 
$2,257 
$598 
$1,702 
$1,779 
$1,581 
$1,072 
$918 
$1,189 
$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 -- 2023 Plan Year
Actives '23
Retirees '23
All '23
5840459

Enrollment
Contributions
Claims & 
Expenses
Active 
Loss Ratio Enrollment Contributions
Claims & 
Expenses
Retiree 
Loss Ratio Enrollment Contributions
Total Claims 
& Expenses
Total Loss 
Ratio
All Plans
4,898
$6,147,916
$6,316,017
103%
676
$666,175
$1,043,967
157%
5,574
$6,814,090
$7,359,984
108%
% of Total
88%
90%
86%
12%
10%
14%
100%
100%
100%
Red Plan
1,982
$3,043,044
$3,636,165
119%
211
$256,468
$457,313
178%
2,193
$3,299,512
$4,093,478
124%
% of Total
90%
92%
89%
10%
8%
11%
39%
48%
56%
Blue Plan
225
$260,364
$442,847
170%
64
$63,328
$140,512
222%
289
$323,692
$583,359
180%
% of Total
78%
80%
76%
22%
20%
24%
5%
5%
8%
White Plan
2,691
$2,844,509
$2,237,005
79%
401
$346,378
$446,142
129%
3,092
$3,190,887
$2,683,147
84%
% of Total
87%
89%
83%
13%
11%
17%
55%
47%
36%
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.  
City of Chandler
2024 Contributions and Paid Claims by Status and Plan
Year-to-date through March 2024
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.                             
 $-
 $1,000,000
 $2,000,000
 $3,000,000
 $4,000,000
 $5,000,000
 $6,000,000
 $7,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
Active Contributions vs Claims and Expenses
 $-
 $200,000
 $400,000
 $600,000
 $800,000
 $1,000,000
 $1,200,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
Retiree Contributions vs Claims and Expenses 
 Contributions
 Claims & Expenses
5840459

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
May-24
Jun-24
Jul-24
Aug-24
Sep-24
Oct-24
Nov-24
Dec-24
2024 Total
554
444
294
690
110
12
50
53
911
307
280
1,193
2024 Avg.
185
148
98
230
37
4
17
18
304
102
93
398
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
May-24
Jun-24
Jul-24
Aug-24
Sep-24
Oct-24
Nov-24
Dec-24
2024 Total
103
88
12
8
37
24
0
3
195
130
21
55
2024 Avg.
34
29
4
3
12
8
0
1
65
43
7
18
6
City of Chandler
Enrollment by Tier
Year-to-date through March 2024
 Red
 Blue
 White
Actives
Retirees
Red
Blue
White
5840459

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-23
171
137
91
240
31
7
13
12
293
105
93
404
Feb-23
173
133
92
239
32
7
12
12
294
100
91
406
Mar-23
176
136
93
239
31
7
12
12
291
99
89
406
Apr-23
174
137
95
230
31
7
12
14
291
98
88
406
May-23
177
140
95
232
33
7
13
14
297
96
88
404
Jun-23
183
143
95
228
33
8
13
15
297
94
88
407
Jul-23
183
141
96
233
34
8
12
16
295
93
88
403
Aug-23
178
140
95
237
34
8
13
16
292
93
88
402
Sep-23
184
143
95
238
33
8
13
18
295
94
87
400
Oct-23
187
143
97
236
35
6
12
19
294
94
88
397
Nov-23
187
142
98
235
35
6
13
20
297
93
85
395
Dec-23
189
148
96
235
36
6
14
20
298
93
86
392
2023 Total
2,162
1,683
1,138
2,822
398
85
152
188
3,534
1,152
1,059
4,822
2023 Avg.
180
140
95
235
33
7
13
16
295
96
88
402
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-23
39
29
3
2
12
9
0
1
52
49
4
16
Feb-23
40
30
3
2
12
9
0
1
54
48
4
15
Mar-23
40
29
3
2
12
9
0
1
54
48
5
16
Apr-23
40
28
3
2
12
9
0
1
54
48
6
17
May-23
40
28
3
2
12
9
0
1
53
48
6
17
Jun-23
40
29
3
2
12
9
0
1
53
47
6
19
Jul-23
39
32
3
2
12
9
0
1
55
45
7
20
Aug-23
38
32
3
2
12
9
0
1
54
45
7
21
Sep-23
38
32
3
2
12
9
0
1
58
44
7
21
Oct-23
37
32
3
2
12
9
0
1
59
43
7
21
Nov-23
39
32
3
2
12
9
0
1
58
43
7
23
Dec-23
39
32
3
2
11
9
0
1
57
44
7
24
2023 Total
469
365
36
24
143
108
0
12
661
552
73
230
2023 Avg.
39
30
3
2
12
9
0
1
55
46
6
19
City of Chandler
Enrollment by Tier
Plan Year 2023
 Red
 Blue
 White
7
Actives
Retirees
Red
Blue
White
5840459

4/10/2015
*
8
City of Chandler
2024 Contributions and Expenses by Status and Plan
Year-to-date through March 2024
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,535 
$1,157 
$1,057 
$1,255 
$1,835 
$1,968 
$831 
$1,290 
($299)
($811)
$226 
($34)
-$2,000
-$1,500
-$1,000
-$500
$0
$500
$1,000
$1,500
$2,000
$2,500
$3,000
Red
Blue
White
All Plans
$ per Employee per Month
Active Surplus/(Deficit) by Plan
Contributions
Claims+Expenses
Surplus/(Deficit)
$1,215 
$990 
$864 
$985 
$2,167 
$2,196 
$1,113 
$1,544 
($952)
($1,206)
($249)
($559)
-$2,500
-$2,000
-$1,500
-$1,000
-$500
$0
$500
$1,000
$1,500
$2,000
$2,500
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
86%
14%
Claims and Expenses
Active
Retiree
5840459

Rank
Plan
Medical/Rx Paid YTD
Medical/Rx Paid in Excess of 
$350K Stop Loss Deductible
1
Red Plan
$144,572
$0
2
Red Plan
$112,247
$0
3
Red Plan
$108,981
$0
4
Blue Plan
$103,369
$0
$469,168
$0
7.5%
City of Chandler
2024 Incurred Medical Claims Paid in Excess of $100,000
Year-to-date through March 2024
9
Total of four claimants
Percentage of Total Medical/Rx Paid:
7.5%
92.5%
Large Claims
All Other Medical/Rx Claims
5840459

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
Mar-23
21,481
$20,472,947
($2,310,350)
$18,162,598
$4,468,614
$22,631,211
$845.52
$208.03
Apr-23
21,536
$21,043,923
($2,463,869)
$18,580,054
$4,622,683
$23,202,738
$862.74
$214.65
May-23
21,600
$21,485,380
($2,413,549)
$19,071,831
$4,803,572
$23,875,402
$882.96
$222.39
Jun-23
21,665
$21,202,631
($2,310,632)
$18,891,999
$4,839,277
$23,731,276
$872.01
$223.37
Jul-23
21,741
$20,677,694
($2,308,329)
$18,369,365
$4,967,746
$23,337,111
$844.92
$228.50
Aug-23
21,775
$20,600,656
($2,325,058)
$18,275,598
$5,051,159
$23,326,757
$839.29
$231.97
Sep-23
21,802
$20,360,474
($2,372,550)
$17,987,924
$5,183,108
$23,171,032
$825.06
$237.74
Oct-23
21,827
$20,592,710
($2,416,356)
$18,176,354
$5,218,967
$23,395,321
$832.75
$239.11
Nov-23
21,847
$20,809,299
($2,295,752)
$18,513,547
$5,338,914
$23,852,460
$847.42
$244.38
Dec-23
21,868
$20,569,398
($2,365,599)
$18,203,798
$5,439,566
$23,643,364
$832.44
$248.75
Jan-24
21,892
$21,202,529
($1,957,882)
$19,244,647
$5,503,561
$24,748,208
$879.07
$251.40
Feb-24
21,954
$20,149,512
($1,399,219)
$18,750,293
$5,562,716
$24,313,009
$854.07
$253.38
Mar-24
22,010
$20,072,038
($1,277,469)
$18,794,569
$5,670,366
$24,464,935
$853.91
$257.63
Notes:
Medical Claims Paid includes capitation. 
10
City of Chandler
Thirteen Month Snapshot - Medical and Rx Plan Paid Claims Through March 2024
$846
$863
$883
$872
$845
$839
$825
$833
$847
$832
$879
$854
$854
$790
$800
$810
$820
$830
$840
$850
$860
$870
$880
$890
Claims per Employee per Month
12-Month Period Ending
Rolling Twelve Month Net Medical Claims PEPM
Net Medical Trend 1.0%
$208
$215
$222 $223 $228 $232
$238 $239
$244 $249 $251 $253 $258
$160
$170
$180
$190
$200
$210
$220
$230
$240
$250
$260
Claims per Employee per Month
12-Month Period Ending
Rolling Twelve Month Rx Claims PEPM
Rx Trend 23.8%
5840459