Financial Statements and Wellness Report
Extracted text (via pymupdf)
12298 characters
ASSETS
Cash and investments
15,160,482
$
Accrued interest
37,246
Due from City - premiums
392,472
Total assets
15,590,200
Retirees claims payable, due to Blue Cross Blue Shield
Compensated absences payable
47,613
Claims incurred but not reported (IBNR) Current 90%
2,034,000
Claims incurred but not reported (IBNR) Non-current 10%
226,000
Employees claims payable, due to Blue Cross Blue Shield
1,331,488
Retirees claims payable, due to Blue Cross Blue Shield
106,621
COBRA claims payable, due to Blue Cross Blue Shield
9,845
Total liabilities
3,755,567
NET POSITION
Unrestricted
11,834,633
Total net position
11,834,633
$
Note: December 31, 2021 minimum end of year reserve including IBNR and two months costs as
projected by Segal Consulting.
$ 6,934,000
CITY OF CHANDLER
Chandler Health Care Benefits Self-Insurance Trust Fund
Statement of Net Position
March 31, 2022
2022
Budget
2022
Budget
Prorated
Actuals
Budget to
Actual
Difference
OPERATING REVENUES
Contributions:
Employer self insurance premiums
19,194,205
$
4,798,551
4,516,182
$
(282,369)
$
Employee self insurance premiums
2,194,830
548,708
504,966
(43,741)
Retiree premiums
2,051,370
512,843
566,717
53,875
COBRA premiums
77,095
19,274
(3,294)
(22,568)
Other:
BCBS wellness programs
25,000
25,000
25,000
-
BCBS wellness coordinator
100,000
100,000
100,000
-
BCBS administration
25,000
25,000
25,000
-
BCBS communication
30,000
30,000
30,000
-
Recovery of medical claims
30,000
7,500
3,598
(3,902)
Total operating revenues
23,727,500
6,066,875
5,768,168
(298,707)
OPERATING EXPENSES
Personnel support
473,828
127,569
106,741
(20,828)
Audits & financial services
8,600
8,600
5,004
(3,596)
Promotional
30,000
7,500
-
(7,500)
Operating supplies & equipment
40,027
10,007
840
(9,167)
Bank charges
400
100
-
(100)
Contractual services
174,000
43,500
13,234
(30,266)
Other:
Self-insurance administrative fees
2,818,636
704,659
428,801
(275,858)
PCORI fees
11,000
11,000
-
(11,000)
Wellness programs
130,494
32,624
7,921
(24,703)
Health savings & flex spending acct contributions
317,700
317,700
212,450
(105,250)
Claims paid:
Employees
18,862,000
4,715,500
4,119,382
(596,118)
Retirees
4,252,000
1,063,000
394,104
(668,896)
COBRA
136,000
34,000
20,960
(13,040)
Total operating expenses
27,254,685
7,075,758
5,309,438
(1,766,321)
OPERATING INCOME (LOSS)
(3,527,185)
(1,008,883)
458,731
1,467,614
NONOPERATING REVENUES (EXPENSES):
Transfers Out - Technology Fund
(5,530)
-
-
-
Transfers In - General Fund
5,000,000
-
-
-
Interest income (loss)
106,050
26,513
43,350
16,837
Total nonoperating revenues (expenses)
5,100,520
26,513
43,350
16,837
Change in net position
1,573,335
(982,371)
502,080
1,484,450
NET POSITION:
Total net position, as of January 1, 2022
11,332,553
11,332,553
11,332,553
-
Total net position, as of March 31, 2022
12,905,888
$
10,350,182
$
11,834,633
$
1,484,450
$
CITY OF CHANDLER
Chandler Health Care Benefits Self-Insurance Trust Fund
Statement of Revenues, Expenses and Changes in Net Position
For the Three Months Ended March 31, 2022
Cash flows from operating activities:
Cash received for premiums and other operating purposes
4,239,322
$
Cash payments for claims
(5,290,616)
Cash payments to suppliers for other services
(658,329)
Cash payments to employees for services
(124,556)
Net cash provided by operating activities
(1,834,178)
Cash flows from investing activities:
Investment income
41,085
Proceeds from sales of investments
8,429,006
Purchases of investments
(6,635,913)
Net cash used for investing activities
1,834,178
Net increase in cash and cash equivalents
-
Cash and cash equivalents, January 1, 2022
-
Cash and cash equivalents, March 31, 2022
-
$
Reconciliation of operating income to cash provided by operating activities:
Operating income
458,731
$
Adjustments to reconcile operating income to net cash provided by
operating activities:
Changes in assets and liabilities:
(Increase)/Decrease in due from (to) City
(1,528,846)
(Increase)/Decrease in prepaids
12,826
Increase/(Decrease) in claims payable
(756,170)
Increase/(Decrease) in accounts payable
(2,904)
Increase/(Decrease) in accrued payroll
(17,815)
Net cash provided by operating activities
(1,834,178)
$
Reconciliation of Cash and Cash Equivalents to the Statement of Net Position:
Cash and cash equivalents
-
$
Investments
15,160,482
Cash and investments
15,160,482
$
CITY OF CHANDLER
Chandler Health Care Benefits Self-Insurance Trust Fund
Statement of Cash Flows
For the Three Months Ended March 31, 2022
Wellness Detail
Jan - Dec
2011
Jan - Dec
2012
Jan - Dec
2013
Jan - Dec
2014
Jan - Dec
2015
Jan - Dec
2016
Jan - Dec
2017
Jan - Dec
2018
Jan - Dec
2019
Jan - Dec
2020
Jan - Dec
2021
Jan - Dec
2022
Cumulative
Total Since
Inception
Revenue
Wellness Funds from BCBS
24,031.73
25,000.00
25,000.00
25,000.00
25,000.00
25,000.00
25,000.00
25,000.00
25,000.00
25,000.00
25,000.00
25,000.00
299,031.73
YOGA Program Revenues
-
2,150.00
2,288.00
2,466.00
2,266.00
1,820.00
1,062.00
2,148.00
-
-
-
-
14,200.00
Total Wellness Program Revenue
24,031.73
27,150.00
27,288.00
27,466.00
27,266.00
26,820.00
26,062.00
27,148.00
25,000.00
25,000.00
25,000.00
25,000.00
313,231.73
Expenses
YOGA Program Expenses
-
1,820.00
3,360.00
3,220.00
3,150.00
2,905.00
2,555.00
1,000.00
-
-
360.00
-
18,370.00
Other Professional Services
-
-
-
1,200.00
-
93.62
-
-
-
-
-
2,500.00
3,793.62
Promotional/Advertising Svcs
-
7,547.42
22,174.80
24,361.61
10,408.85
8,567.47
15,024.50
10,060.07
17,712.80
9,759.42
10,434.58
3,776.83
139,828.35
Supplies (printing, office, etc.)
-
227.89
2,954.17
1,259.37
1,447.85
1,735.20
12.30
3.02
35.22
-
-
-
7,675.02
Food & Events
-
350.19
375.02
64.56
795.09
677.75
427.82
535.24
1,163.33
424.57
843.38
648.96
6,305.91
Clothing & Uniforms
-
628.00
-
-
-
-
51.58
-
-
-
-
-
679.58
Other Supplies
-
26.16
-
26.75
-
-
-
-
-
-
-
-
52.91
Office Furniture
-
-
-
-
-
-
-
-
-
-
-
489.80
489.80
Employee Activities/Recognition
-
-
-
-
-
1,000.00
-
-
-
-
1,121.00
350.84
2,471.84
Postage & Freight
-
-
481.63
-
-
-
-
-
-
-
-
-
481.63
Travel
-
-
27.12
-
-
-
288.50
942.96
1,327.36
-
-
-
2,585.94
Subscriptions & Memberships
-
365.00
352.00
310.00
-
-
395.00
365.00
-
-
-
154.22
1,941.22
Education & Training
-
-
(600.00)
-
120.00
79.00
439.10
625.50
895.50
460.00
419.00
-
2,438.10
Other Wellness Expenses
2,648.92
-
-
-
-
-
-
-
-
-
-
-
2,648.92
Registrations
-
-
-
-
-
-
625.50
-
200.00
-
70.00
-
895.50
Total Wellness Program Expenses
2,648.92
10,964.66
29,124.74
30,442.29
15,921.79
15,058.04
19,819.30
13,531.79
21,334.21
10,643.99
13,247.96
7,920.65
190,658.34
Net Wellness Funds Remaining
122,573.39
Chandler Health Care Benefits Trust
Wellness Programs Tracking January 1 Thru December 31, 2022