SCHEDULE 1
COLCHESTER BOARD OF EDUCATION
HEALTH INSURANCE RESERVE ANALYSIS
AS OF: OCTOBER 2019
FINAL
BEGINNING BALANCE 7/1/19 2,193,048.90
DEPOSITS:
EMPLOYER CONTRIBUTIONS 1,759,641.72
CO-PAY EMPLOYEES 308,799.61
RETIREES 98,938.82
COBRA 4,585.42
INTEREST 67.21
TOTAL DEPOSITS 2,172,032.78
EXPENSES:
CLAIMS 1,681,183.38
ADMIN FEE 238,402.63
HSA EMPLOYER CONTRIBUTION 124,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 16,963.00
Actuarial Services & PY Adj & Audit Fees 0.00
Other 0.00
TOTAL EXPENSES 2,062,356.47
ENDING BALANCE 2,302,725.21
AVERAGE MONTHLY CLAIMS 426,242.38
(Includes claims+admin fee)
(Based on a 13 month average)
AVERAGE MONTHLY RESERVE 5.40
12/10/2019 2:25 PM
SCHEDULE 3
COLCHESTER BOARD OF EDUCATION
HEALTH INSURANCE MONTHLY SUMMARY
AS OF: OCTOBER 2019
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-18 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-18 436,354 42,075 478,429 247,381 121,032 0 0 3,846 0 0 372,259 106,169 2,206,482
Sep-18 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-18 450,580 163,416 613,995 386,322 58,657 0 0 4,142 0 0 449,120 164,875 2,302,725
Nov-18 0 0 0 0 0 0 0 0 0 0 0 0 2,302,725
Dec-18 0 0 0 0 0 0 0 0 0 0 0 0 2,302,725
Jan-19 0 0 0 0 0 0 0 0 0 0 0 0 2,302,725
Feb-19 0 0 0 0 0 0 0 0 0 0 0 0 2,302,725
Mar-19 0 0 0 0 0 0 0 0 0 0 0 0 2,302,725
Apr-19 0 0 0 0 0 0 0 0 0 0 0 0 2,302,725
May-19 0 0 0 0 0 0 0 0 0 0 0 0 2,302,725
Jun-19 0 0 0 0 0 0 0 0 0 0 0 0 2,302,725
TOTAL 1,759,642 412,391 2,172,033 1,681,183 238,403 0 0 16,963 124,000 1,807 2,062,356 109,676
MONTHLY AVERAGES:
DEPOSITS 543,008
EXPENSES 515,589
CONTRIBUTION TO
RESERVE 27,419
E. Gallupe 12/10/2019 2:25 PM
COLCHESTER
COLCHESTERBOARD
BOARD OFOFEDUCATION
EDUCATION
13
13 MONTH
MONTHMEDICAL
MEDICAL CLAIMS
CLAIMS TREND
TREND HISTORY
HISTORY
(PAID
(PAID CLAIMS
CLAIMS AND
AND NETWORK
NETWORKACCESS
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
Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19
Series2 257,645
Series2 318,180 614,829 499,346 325,536 452,780 1
290,101 414,657 645,444 554,990 247,381 533,939 386,322
Series1 470,216
Series1 471,299 483,357 489,843 460,834 464,325 1
437,340 426,230 431,002 446,639 465,668 506,740 426,242
12/10/2019 2:25 PM