SCHEDULE 1
COLCHESTER BOARD OF EDUCATION
HEALTH INSURANCE RESERVE ANALYSIS
AS OF:MAY 2020
FINAL
BEGINNING BALANCE 7/1/19 2,193,048.90
DEPOSITS:
EMPLOYER CONTRIBUTIONS 4,786,579.74
CO-PAY EMPLOYEES 1,246,706.55
RETIREES 243,668.98
COBRA 11,015.86
INTEREST 3,283.47
TOTAL DEPOSITS 6,291,254.60
EXPENSES:
CLAIMS 4,428,246.62
ADMIN FEE 645,836.30
HSA EMPLOYER CONTRIBUTION 312,000.02
Federal Excise Tax 1,807.44
Wellness Program Fees 0.00
Wellness Program Incentives 0.00
Year End Settlement 0.00
State Assessment 0.00
PPI Benefits 51,623.82
Actuarial Services & PY Adj & Audit Fees 750.00
Other 0.00
TOTAL EXPENSES 5,440,264.20
ENDING BALANCE 3,044,039.30
AVERAGE MONTHLY CLAIMS
(Includes claims+admin fee)
(Based on a 13 month average)
AVERAGE MONTHLY RESERVE
7/9/2020 12:09 PM
SCHEDULE 3
COLCHESTER BOARD OF EDUCATION
HEALTH INSURANCE MONTHLY SUMMARY
AS OF:MAY 2020
REVENUES EXPENSES MONTHLY YTD
Wellness State PPI
EMPLOYER CO-PAYS TOTAL CLAIMS/FEES ADMIN HSA Other TOTAL BALANCE BALANCE
Program Assessment Benefit
BEG BALANCE 2,193,049
Jul-19 436,354 51,232 487,586 554,990 0 0 0 4,483 19,042 1,807 580,322 (92,737) 2,100,312
Aug-19 436,354 42,075 478,429 247,381 121,032 0 0 3,846 0 0 372,259 106,169 2,206,482
Sep-19 436,354 155,669 592,023 492,490 58,713 0 0 4,493 104,958 0 660,655 (68,632) 2,137,850
Oct-19 450,580 163,416 613,995 386,322 58,657 0 0 4,142 0 0 449,120 164,875 2,302,725
Nov-19 443,467 153,965 597,432 548,662 58,232 0 0 4,408 0 0 611,301 (13,870) 2,288,856
Dec-19 443,467 149,094 592,561 298,316 57,270 0 0 4,054 63,250 750 423,640 168,921 2,457,777
Jan-20 428,001 163,586 591,587 408,189 58,936 0 0 4,322 12,750 0 484,197 107,389 2,565,167
Feb-20 428,001 154,343 582,343 386,825 58,092 0 0 4,423 0 0 449,340 133,004 2,698,170
Mar-20 428,001 154,560 582,561 544,481 57,504 0 0 4,311 112,000 0 718,295 (135,734) 2,562,436
Apr-20 428,001 163,212 591,213 211,132 58,872 0 0 8,803 0 0 278,807 312,406 2,874,842
May-20 428,001 153,524 581,525 349,459 58,528 0 0 4,341 0 0 412,328 169,197 3,044,039
Jun-20 0 0 0 0 0 0 0 0 0 0 0 0 3,044,039
TOTAL 4,786,580 1,504,675 6,291,255 4,428,247 645,836 0 0 51,624 312,000 2,557 5,440,264 850,990
MONTHLY AVERAGES:
DEPOSITS 571,932
EXPENSES 494,569
CONTRIBUTION TO
RESERVE 77,363
E. Gallupe 7/9/2020 12:09 PM
COLCHESTER
COLCHESTER BOARD
BOARD OF
OF EDUCATION
EDUCATION
13
13 MONTH
MONTH MEDICAL
MEDICAL CLAIMS
CLAIMS TREND
TREND HISTORY
HISTORY
(PAID
(PAID CLAIMS
CLAIMS AND
AND NETWORK
NETWORK ACCESS
ACCESS FEE)
FEE)
BUDGET
Excludes YEAR 2002/2003
Administrative Costs
1.2
700,000
600,0001
500,000
0.8
AMOUNT
400,000
AMOUNT
0.6
300,000
0.4
200,000
0.2
100,000
00 1
May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20
Series2
Series2 414,657 645,444 554,990 247,381 533,939 386,322 1
548,662 298,316 408,189 386,825 544,481 211,132 349,459
Series1 437,340
Series1 426,230 431,002 446,639 465,668 506,740 1
426,242 448,628 447,100 431,205 422,549 439,391 420,803
7/9/2020 12:09 PM
COLCHESTER BOARD OF EDUCATION
HEALTH INSURANCE RESERVE ANALYSIS
JULY AUGUST SEPT OCT NOV DEC JAN FEB MARCH APRIL MAY JUNE TOTAL
DEPOSITS:
EMPLOYER CONTRIBUTION 436,354.00 436,354.00 436,354.00 450,579.72 443,466.86 443,466.86 428,000.86 428,000.86 428,000.86 428,000.86 428,000.86 4,786,579.74
CO-PAY EMPLOYEES 21,563.04 21,843.54 133,430.16 131,962.87 131,937.74 132,452.14 133,151.65 135,082.55 135,154.45 134,615.50 135,512.91 1,246,706.55
RETIREES 28,698.77 19,260.02 21,303.10 29,676.93 21,091.83 15,705.09 29,492.47 18,335.69 17,334.94 26,127.36 16,642.78 243,668.98
COBRA 954.93 954.93 918.02 1,757.54 918.02 918.02 922.32 918.02 918.02 918.02 918.02 11,015.86
INTEREST 15.05 16.09 17.71 18.36 17.35 18.82 19.62 6.34 1,152.93 1,551.24 449.96 3,283.47
TOTAL 487,585.79 478,428.58 592,022.99 613,995.42 597,431.80 592,560.93 591,586.92 582,343.46 582,561.20 591,212.98 581,524.53 0.00 6,291,254.60
DEDUCT:
CLAIMS 554,990.23 247,381.37 492,490.19 386,321.59 548,662.12 298,316.05 408,188.96 386,824.56 544,480.79 211,131.61 349,459.15 0.00 4,428,246.62
Excise Tax 1,807.44 1,807.44
ADMIN FEE 0.00 121,032.23 58,713.46 58,656.94 58,231.74 57,269.98 58,936.48 58,092.08 57,503.55 58,871.98 58,527.86 645,836.30
ADMIN Symetra 0.00
HSA EMPLOYER CONT 19,041.65 104,958.37 63,250.00 12,750.00 0.00 112,000.00 0.00 0.00 312,000.02
Wellness Prog fees 0.00
Wellness incentives 0.00
Other 0.00
PPI Benefits 4,483.00 3,845.50 4,493.00 4,141.50 4,407.50 4,053.50 4,322.00 4,423.00 4,311.00 8,803.32 4,340.50 51,623.82
Year End settlement 0.00
State Assessment 0.00 0.00
Actuarial Ser 0.00 750.00 750.00
TOTAL 580,322.32 372,259.10 660,655.02 449,120.03 611,301.36 423,639.53 484,197.44 449,339.64 718,295.34 278,806.91 412,327.51 0.00 5,440,264.20
PRIOR YEAR CLAIMS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00