Medical Trust Actuarial Report-Segal

5734916v1/00914.015 
Rachel Calisi 
Senior Health Consultant 
T 602.381.4027 
rcalisi@segalco.com 
1501 West Fountainhead Parkway, Suite 370 
Tempe, AZ 85282 
segalco.com 
August 11, 2022 
Ms. 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, 2022 through December 31, 2022 – Data through June 30, 2022 
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 June 30, 2022. 
For the month of June, Medical paid claims were approximately $1,880,000 while net Rx claims 
were about $416,000. For the 2022 plan year-to-date, claims and expenses (after stop-loss 
reimbursements and pharmacy rebates) exceeded contributions by approximately $70,000 or 
0.6% of contributions. Based on paid claims and expenses, all Actives and Retirees on the Red 
and Blue Plans, as well as Retirees on the White Plan experienced an operating deficit, as 
displayed on Page 8.  
There have been ten claimants with paid claims in excess of $100,000 during the reporting 
period. There is one individual in the current plan year who has 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, HSA administration, and 
fees associated with the Affordable Care Act. Also included is the amount of $92,562 per month 
from the 2022 Operating Budget. These expenses exclude those funded by Blue Cross Blue 
Shield of Arizona. These expenses include categories such as wellness incentives, wellness 
portal, personnel support, audit & financial services, promotional, operating supplies & 
equipment, bank charges, contractual services, IT reports, and health savings and flex account 
contributions.   
In June 2022, approximately 38.2% of all active employees and retirees were enrolled in the 
Red plan, with 5.2% enrolled in the Blue plan, and 56.6% enrolled in the White plan. At the end

5734916v1/00914.015 
Ms. Rae Lynn Nielsen 
August 11, 2022 
Page 2 
of 2021, approximately 38.9% of enrollment was in the Red plan, 4.5% in the Blue plan and 
56.6% in the White plan. The current average enrollment in 2022 is approximately 2.1% higher 
than the 2021 average enrollment.  
The Coronavirus (COVID-19) pandemic has impacted the US economy and health plan claim’s 
history and projections for most Health Plan Sponsors. Realized trends in the 2021 plan year 
could be significantly different in 2022 as the population is vaccinated and changes in the 
spread of the COVID-19 virus is altered. 
I look forward to discussing this report with you. 
Sincerely yours, 
Rachel Calisi 
Senior Health Consultant 
/as

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

Jun'22
Jan'22-Jun'22
Jan'21-Dec'21
Jun'22
Jan'22-Jun'22
Jan'21-Dec'21
Contributions (PEPM)
$1,064.24
$1,063.23
$1,071.86
Avg. # of Employees
1,760
1,753
1,713
Net Paid Medical Claims (PEPM)
$1,010.91
$739.27
$861.61
Avg. # of Members
4,600
4,608
4,555
Net Paid Rx Claims (PEPM)
$236.23
$180.75
$221.05
Ratio Members to EEs
2.61
2.63
2.66
Total Claims (PEPM)
$1,247.14
$920.02
$1,082.66
Age/Gender Index 1
-
0.981
0.980
Stop Loss & Adm Expenses (PEPM)
$151.53
$149.89
$164.05
Total Claims & Expenses (PEPM)
$1,398.67
$1,069.91
$1,246.70
Surplus/Deficit (PEPM)
-$334.42
-$6.68
-$174.84
Loss Ratio
131%
101%
116%
PEPM % Change
30.7%
-14.2%
Jan'22-Jun'22
Jan'21-Jun'21
% Change
# of Claimants
10
18
-44.4%
$ of Medical/Rx Paid Claims
$1,991,985
$3,335,045
-40.3%
% of Medical/Rx Paid Claims
20.0%
28.2%
-29.3%
Jan'22-Jun'22
Jan'21-Dec'21
% Change
Jan'22-Jun'22
Jan'21-Dec'21
% Change
Bed Days/1,000
327.2
308.9
5.9%
Generic (PEPM)
$28.15
$31.55
-10.8%
Avg Length of Stay
7.0
6.5
7.7%
Brand Preferred (PEPM)
$212.50
$222.65
-4.6%
Brand Non-Preferred (PEPM)
$10.90
$11.65
-6.4%
Specialty (PEPM)
$106.98
$135.37
-21.0%
Total (PEPM)
$358.53
$401.22
-10.6%
Jan'22-Jun'22
Jan'21-Dec'21
% Change
Jan'22-Jun'22
Jan'21-Dec'21
% Change
In-Network Allowed %
98.3%
97.1%
1.2%
Retail Scripts PMPY
7.12
13.99
-49.1%
Discount from Billed5
65.4%
67.2%
-2.7%
Mail Order Scripts PMPY
0.05
0.14
-64.3%
% Mail Order
0.7%
1.0%
-29.8%
Jan'22-Jun'22
Jan'21-Dec'21
% Change
Generic Dispensing Rate
82.7%
81.1%
1.9%
Jan'22-Jun'22
Jan'21-Dec'21
% Change
Generic Plan Paid/Script
$8.92
$10.18
-12.4%
Member Cost Share %
17.7%
13.4%
32.1%
Brand Plan Paid/Script
$352.72
$341.02
3.4%
Plan Paid %
82.3%
86.6%
-5.0%
Specialty Plan Paid/Script
$4,072.33
$4,062.97
0.2%
Total Plan Paid/Script
$93.96
$105.02
-10.5%
Inpatient Hospital
City of Chandler
HealthPlan Dashboard - Data thru June 2022
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.
5718498
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-21
1,708
$1,829,009
$1,661,205
($71,830)
$389,983
$1,979,358
$278,182
$2,257,540
($428,532)
123.4%
Feb-21
1,698
$1,819,359
$1,384,946
($11,968)
$375,656
$1,748,635
$280,266
$2,028,901
($209,542)
111.5%
Mar-21
1,704
$1,828,100
$1,739,289
($20,983)
$321,008
$2,039,314
$280,796
$2,320,110
($492,010)
126.9%
Apr-21
1,703
$1,828,978
$1,524,544
($1,603)
$388,568
$1,911,509
$280,675
$2,192,184
($363,206)
119.9%
May-21
1,703
$1,830,244
$1,714,029
($83,558)
$394,335
$2,024,807
$280,636
$2,305,443
($475,200)
126.0%
Jun-21
1,722
$1,847,707
$1,640,304
($134,389)
$374,365
$1,880,279
$282,462
$2,162,742
($315,035)
117.1%
Jul-21
1,717
$1,839,218
$1,349,631
($104,469)
$360,363
$1,605,525
$281,979
$1,887,503
($48,286)
102.6%
Aug-21
1,714
$1,840,013
$1,352,027
($130,390)
$379,275
$1,600,912
$281,650
$1,882,563
($42,550)
102.3%
Sep-21
1,717
$1,841,570
$1,332,072
($131,720)
$378,985
$1,579,337
$279,041
$1,858,377
($16,807)
100.9%
Oct-21
1,733
$1,858,733
$1,600,815
($119,875)
$423,006
$1,903,947
$286,019
$2,189,966
($331,233)
117.8%
Nov-21
1,735
$1,854,450
$1,666,669
($184,296)
$345,153
$1,827,526
$283,565
$2,111,091
($256,641)
113.8%
Dec-21
1,752
$1,869,360
$2,030,370
($246,550)
$424,269
$2,208,089
$285,066
$2,493,155
($623,795)
133.4%
2021 Total
20,606
$22,086,738
$18,995,900
($1,241,629)
$4,554,966
$22,309,237
$3,380,337
$25,689,574
($3,602,836)
116.3%
2021 Avg.
1,717
$1,840,562
$1,582,992
($103,469)
$379,580
$1,859,103
$281,695
$2,140,798
($300,236)
116.3%
Jan-22
1,760
$1,871,210
$1,507,401
($191,783)
$326,101
$1,641,719
$261,157
$1,902,876
($31,666)
101.7%
Feb-22
1,756
$1,865,487
$1,231,204
($21,351)
$235,866
$1,445,719
$263,559
$1,709,278
$156,210
91.6%
Mar-22
1,747
$1,857,678
$1,649,945
($117,877)
$288,374
$1,820,442
$262,717
$2,083,159
($225,481)
112.1%
Apr-22
1,748
$1,858,559
$818,074
$123,627
$318,247
$1,259,948
$262,689
$1,522,637
$335,923
81.9%
May-22
1,751
$1,861,273
$1,078,484
($78,321)
$317,526
$1,317,688
$260,294
$1,577,982
$283,291
84.8%
Jun-22
1,760
$1,873,065
$1,879,251
($100,053)
$415,766
$2,194,964
$266,688
$2,461,652
($588,587)
131.4%
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
2022 Total
10,522
$11,187,273
$8,164,359
($385,758)
$1,901,879
$9,680,480
$1,577,104
$11,257,584
($70,311)
100.6%
2022 Avg.
1,754
$1,864,545
$1,360,726
($64,293)
$316,980
$1,613,413
$262,851
$1,876,264
($11,718)
100.6%
2
City of Chandler
2021-2022 Medical/Rx Contributions and Expenses
Year-to-date through June 2022
(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.
(4) Enrollment may change retrospectively based on updated BCBSAZ reporting.
$1,902,876 
$3,612,154 
$5,695,312 
$7,217,949 
$8,795,931 
$11,257,584 
$2,257,540 
$4,286,441 
$6,606,551 
$8,798,735 
$11,104,179 
$13,266,920 
$15,154,423 
$17,036,986 
$18,895,363 
$21,085,329 
$23,196,420 
$25,689,574 
 $-
 $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.
2022 vs 2021 Cumulative Paid Claims & Expenses
2022 Cumulative Claims & Expenses
2021 Cumulative Claims & Expenses
5718498

Red
Blue
White
Total
Red
Blue
White
Total
Red
Blue
White
Total
Jan-22
591
56
909
1,556
73
27
104
204
664
83
1,013
1,760
Feb-22
585
57
905
1,547
75
27
107
209
660
84
1,012
1,756
Mar-22
580
57
898
1,535
75
27
110
212
655
84
1,008
1,747
Apr-22
584
57
892
1,533
77
27
111
215
661
84
1,003
1,748
May-22
586
62
887
1,535
78
27
111
216
664
89
998
1,751
Jun-22
595
64
882
1,541
78
27
114
219
673
91
996
1,760
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
2022 Avg.
587
59
896
1,541
76
27
110
213
663
86
1,005
1,754
% of Total
33%
3%
51%
88%
4%
2%
6%
12%
38%
5%
57%
100%
2021 Avg.
600
50
874
1,524
68
28
98
193
667
78
972
1,717
% Change
-2%
17%
2%
1%
12%
-2%
12%
10%
-1%
10%
3%
2.1%
3
City of Chandler
2022 Enrollment by Status and Plan
Year-to-date through June 2022
TOTAL
ACTIVE
RETIREE
0
500
1,000
Jan-22
Feb-22
Mar-22
Apr-22
May-22
Jun-22
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
Active Enrollment by Plan 
ACTIVE Red
ACTIVE Blue
ACTIVE White
0
20
40
60
80
100
120
Jan-22
Feb-22
Mar-22
Apr-22
May-22
Jun-22
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
Retiree Enrollment by Plan
RETIREE Red
RETIREE Blue
RETIREE White
5718498

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
2022 Medical/Rx Paid Claims by Plan and Status
Year-to-date through June 2022
$1,470 
$1,125 
$563 
$930 
$1,523 
$1,668 
$768 
$1,153 
$1,476 
$1,296 
$585 
$957 
$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 -- 2022 Plan Year
Actives '22
Retirees '22
All '22
$1,480 
$1,708 
$742 
$1,064 
$3,120 
$1,105 
$1,007 
$1,761 
$1,647 
$1,495 
$769 
$1,143 
$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 -- 2021 Plan Year
Actives '21
Retirees '21
All '21
5718498

Enrollment Contributions
Claims & 
Expenses
Active 
Loss Ratio Enrollment Contributions
Claims & 
Expenses
Retiree 
Loss Ratio Enrollment Contributions
Total Claims 
& Expenses
Total Loss 
Ratio
All Plans
9,247
$10,070,862
$9,982,922
99%
1,275
$1,116,411
$1,660,419
149%
10,522
$11,187,273
$11,643,341
104%
% of Total
88%
90%
86%
12%
10%
14%
100%
100%
100%
Red Plan
3,521
$4,763,768
$5,704,054
120%
456
$481,765
$762,784
158%
3,977
$5,245,533
$6,466,838
123%
% of Total
89%
91%
88%
11%
9%
12%
38%
47%
56%
Blue Plan
353
$356,493
$450,124
126%
162
$140,326
$294,467
210%
515
$496,819
$744,591
150%
% of Total
69%
72%
60%
31%
28%
40%
5%
4%
6%
White Plan
5,373
$4,950,601
$3,828,744
77%
657
$494,320
$603,168
122%
6,030
$5,444,921
$4,431,912
81%
% of Total
89%
91%
86%
11%
9%
14%
57%
49%
38%
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
2022 Contributions and Paid Claims by Status and Plan
Year-to-date through June 2022
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.
 $-
 $2,000,000
 $4,000,000
 $6,000,000
 $8,000,000
 $10,000,000
 $12,000,000
Jan-22
Feb-22
Mar-22
Apr-22
May-22
Jun-22
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
$ Year-to-Date
Active Contributions vs Claims and Expenses
 $-
 $500,000
 $1,000,000
 $1,500,000
 $2,000,000
Jan-22
Feb-22
Mar-22
Apr-22
May-22
Jun-22
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
$ Year-to-Date
Retiree Contributions vs Claims and Expenses 
 Contributions
 Claims & Expenses
5718498

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-22
148
136
81
226
26
6
10
14
277
117
100
415
Feb-22
145
136
81
223
26
7
10
14
278
115
99
413
Mar-22
141
136
81
222
25
8
10
14
278
111
99
410
Apr-22
144
135
82
223
25
8
10
14
278
110
97
407
May-22
146
132
83
225
28
9
11
14
276
110
96
405
Jun-22
151
134
85
225
28
9
12
15
271
110
96
405
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
2022 Total
875
809
493
1,344
158
47
63
85
1,658
673
587
2,455
2022 Avg.
146
135
82
224
26
8
11
14
276
112
98
409
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-22
33
32
5
3
14
13
0
0
47
44
4
9
Feb-22
34
33
5
3
14
12
0
1
48
44
4
11
Mar-22
33
34
5
3
14
12
0
1
48
45
4
13
Apr-22
36
33
5
3
14
12
0
1
47
45
4
15
May-22
37
34
4
3
14
12
0
1
49
44
3
15
Jun-22
37
34
4
3
14
12
0
1
50
44
3
17
Jul-22
Aug-22
Sep-22
Oct-22
Nov-22
Dec-22
2022 Total
210
200
28
18
84
73
0
5
289
266
22
80
2022 Avg.
35
33
5
3
14
12
0
1
48
44
4
13
6
City of Chandler
Enrollment by Tier
Year-to-date through June 2022
 Red
 Blue
 White
Actives
Retirees
Red
Blue
White
5718498

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-21
153
138
87
224
18
3
7
17
261
122
100
396
Feb-21
147
136
89
223
18
2
7
17
256
119
101
395
Mar-21
146
136
89
226
20
3
7
18
257
119
100
395
Apr-21
145
136
90
226
19
3
7
19
255
120
100
396
May-21
143
135
91
227
18
3
7
19
257
117
99
396
Jun-21
146
135
91
231
18
3
7
19
260
122
103
395
Jul-21
147
133
90
229
19
4
8
19
260
119
99
395
Aug-21
145
134
90
231
20
4
8
19
259
116
95
396
Sep-21
146
133
89
230
22
5
8
19
260
116
96
398
Oct-21
149
131
91
232
24
5
8
19
261
117
97
398
Nov-21
152
132
90
229
25
5
9
19
263
120
96
394
Dec-21
150
133
88
232
23
5
9
19
276
119
96
398
2021 Total
1,769
1,612
1,075
2,740
244
45
92
223
3,125
1,426
1,182
4,752
2021 Avg.
147
134
90
228
20
4
8
19
260
119
99
396
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-21
28
30
2
3
14
14
0
0
40
39
2
10
Feb-21
29
30
2
3
15
14
0
0
43
40
2
10
Mar-21
29
30
2
3
15
14
0
0
42
40
3
10
Apr-21
29
29
2
4
16
13
0
0
42
41
3
8
May-21
30
30
3
4
16
13
0
0
42
42
3
8
Jun-21
30
30
3
4
17
12
0
0
43
42
3
8
Jul-21
30
31
4
3
15
12
0
0
47
43
3
7
Aug-21
30
30
5
3
15
12
0
0
47
45
3
7
Sep-21
29
31
5
3
15
11
0
0
46
45
3
7
Oct-21
28
36
6
3
15
11
0
0
46
45
3
8
Nov-21
28
35
6
3
15
11
0
0
47
45
3
8
Dec-21
31
35
6
3
15
11
0
0
47
45
3
8
2021 Total
351
377
46
39
183
148
0
0
532
512
34
99
2021 Avg.
29
31
4
3
15
12
0
0
44
43
3
8
City of Chandler
Enrollment by Tier
Plan Year 2021
 Red
 Blue
 White
7
Actives
Retirees
Red
Blue
White
5718498

4/10/2015
*
8
City of Chandler
2022 Contributions and Expenses by Status and Plan
Year-to-date through June 2022
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,353 
$1,010 
$921 
$1,089 
$1,620 
$1,275 
$713 
$1,080 
($267)
($265)
$209 
$10 
-$1,500
-$1,000
-$500
$0
$500
$1,000
$1,500
$2,000
$2,500
Red
Blue
White
All Plans
$ per Employee per Month
Active Surplus/(Deficit) by Plan
Contributions
Claims+Expenses
Surplus/(Deficit)
$1,057 
$866 
$752 
$876 
$1,673 
$1,818 
$918 
$1,302 
($616)
($951)
($166)
($427)
-$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
5718498

Rank
Plan
Medical/Rx Paid YTD
Medical/Rx Paid in Excess of 
$350K Stop Loss Deductible
1
Red Plan
$447,231
$97,231
2
Red Plan
$258,357
$0
3
Red Plan
$215,224
$0
4
White Plan
$201,041
$0
5
Red Plan
$199,790
$0
6
White Plan
$181,342
$0
7
Red Plan
$135,436
$0
8
Red Plan
$120,599
$0
9
Blue Plan
$116,685
$0
10
White Plan
$116,284
$0
$1,991,989
$97,231
19.8%
City of Chandler
2022 Incurred Medical Claims Paid in Excess of $100,000
Year-to-date through June 2022
9
Total of ten claimants
Percentage of Total Medical/Rx Paid:
19.8%
80.2%
Large Claims
All Other Medical/Rx Claims
5718498

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
Jun-21
20,439
$18,881,903
($922,629)
$17,959,274
$4,658,039
$22,617,313
$878.68
$227.90
Jul-21
20,448
$19,023,093
($919,883)
$18,103,210
$4,639,035
$22,742,245
$885.33
$226.87
Aug-21
20,454
$18,794,607
($982,693)
$17,811,914
$4,586,043
$22,397,956
$870.83
$224.21
Sep-21
20,470
$18,594,973
($991,646)
$17,603,327
$4,594,938
$22,198,264
$859.96
$224.47
Oct-21
20,513
$18,688,733
($1,043,316)
$17,645,417
$4,631,827
$22,277,244
$860.21
$225.80
Nov-21
20,557
$18,834,622
($1,091,323)
$17,743,300
$4,573,876
$22,317,175
$863.13
$222.50
Dec-21
20,606
$18,995,900
($1,241,629)
$17,754,271
$4,554,966
$22,309,237
$861.61
$221.05
Jan-22
20,658
$18,842,097
($1,361,582)
$17,480,514
$4,491,084
$21,971,598
$846.19
$217.40
Feb-22
20,716
$18,688,354
($1,370,965)
$17,317,389
$4,351,293
$21,668,682
$835.94
$210.05
Mar-22
20,759
$18,599,010
($1,467,858)
$17,131,152
$4,318,659
$21,449,811
$825.24
$208.04
Apr-22
20,804
$17,892,540
($1,342,629)
$16,549,911
$4,248,338
$20,798,250
$795.52
$204.21
May-22
20,852
$17,256,995
($1,337,393)
$15,919,602
$4,171,528
$20,091,131
$763.46
$200.05
Jun-22
20,890
$17,495,942
($1,303,057)
$16,192,886
$4,212,930
$20,405,815
$775.15
$201.67
Notes:
Medical Claims Paid includes capitation. 
10
City of Chandler
Thirteen Month Snapshot - Medical and Rx Plan Paid Claims Through June 2022
$879
$885
$871
$860
$860
$863
$862
$846
$836
$825
$796
$763
$775
$700
$720
$740
$760
$780
$800
$820
$840
$860
$880
$900
Claims per Employee per Month
12-Month Period Ending
Rolling Twelve Month Net Medical Claims PEPM
Net Medical Trend -11.8%
$228 $227 $224 $224 $226 $222 $221 $217
$210 $208 $204 $200 $202
$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 -11.5%
5718498