2139 - Addendum No. 3 - Vernon Cumulative FYE 2026 Monthly Report.xlsx

XLSX spreadsheet 429 KB Posted

Attached to
Medical Benefits Administrative Services, PMB, Dental Benefits & Stop-Loss
Solicitation number
2139 – 1-27-2026
Issued by
Tolland County, Bridgeport City, Connecticut

About this file

This is an Addendum No. 3 to a custom monthly financial report for a self-funded health insurance plan covering the Town and Public Schools of Vernon, Connecticut for the fiscal year ending June 30, 2026. The report documents medical and prescription drug claims experience for active employees, retirees, and COBRA participants across both entities during the period of July 1, 2025 through June 30, 2026. The report includes detailed monthly claims data through November 2025, with data for December 2025 through June 2026 pending. The plan is administered through Acrisure, LLC, with medical coverage provided through Cigna under an Administrative Services Organization (ASO) funding arrangement.

The plan demonstrates a cumulative loss ratio of 87.2 percent for Vernon Public Schools and 110.7 percent for the Town of Vernon through November 2025, indicating that claims and expenses have exceeded theoretical premiums for the Town entity. Employee contribution rates are differentiated by job classification and family status, ranging from 8 percent to 100 percent of premium costs. Large claims exceeding $50,000 are tracked separately, with notable high-cost cases including malignant neoplasms, multiple sclerosis, subarachnoid hemorrhage, and other serious medical conditions. The report includes pharmacy rebates, stop-loss reimbursements, and administrative fee breakdowns by employee class across 34 distinct payroll branches. As of November 2025, the combined net fund balance for both entities stood at $1,334,009, though the Town of Vernon maintained a deficit position of $66,859 while Vernon Public Schools showed a positive balance of $1,267,150.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Cover

Custom Monthly Financial Report
Prepared for: The Town and Public Schools of Vernon
Plan Year:2025/2026 - Fiscal Year End 2026
Claims Period:July 1, 2025 through June 30, 2026
Copyright © 2024
This report contains confidential information. We are providing this report and the enclosed data for "Internal Use Only". It is not intended to be distributed to any person outside of your company/organization without our authorization. The contents of this report are the property of Acrisure, LLC and have been copyrighted.
ACTIVE

&G &G

346 Shelburne Road Burlington, Vermont 05401 802.488.8728

BOE Total

VERNON PUBLIC SCHOOLS
ACTIVE, RETIRED & COBRA POPULATION
July 1, 2025 through June 30, 2026
MEDICAL & PRESCRIPTION DRUG
MonthTheoretical PremiumH.S.A/HRA DepositsAdministrative FeesStop-Loss PremiumsTotal Expenses & Stop-Loss PremiumMedical Paid ClaimsDrug Paid ClaimsStop-Loss ReimbursementsDrug Plan Rebates*Total Paid ClaimsExpenses & Paid ClaimsLoss RatioMargin/(Deficit)Employee ContributionsNet Fund Balance
Jul-25$710,737$26,650$82,255$108,905$440,845$118,213$0$0$559,057$667,96294.0%$42,775$171,120$213,895
Aug-25$698,823$26,650$82,255$108,905$469,053$69,906$0($106,714)$432,246$541,15077.4%$157,673$166,416$324,089
Sep-25$688,861$26,181$80,808$106,989$333,564$124,163$0$0$457,726$564,71682.0%$124,146$163,549$287,694
Oct-25$687,542$26,047$80,395$106,442$431,748$131,470$0$0$563,218$669,66097.4%$17,881$162,520$180,401
Nov-25$681,508$25,914$79,981$105,895$355,986$117,520$0$0$473,506$579,40185.0%$102,107$158,963$261,070
Dec-25
Jan-26
Feb-26
Mar-26
Apr-26
May-26
Jun-26
Totals$3,467,471$131,442$405,693$537,136$2,031,195$561,271$0($106,714)$2,485,753$3,022,88987.2%$444,582$822,568$1,267,150

ACTIVE

&G &G

Town Total

TOWN OF VERNON
ACTIVE, RETIRED & COBRA POPULATION
July 1, 2025 through June 30, 2026
MEDICAL & PRESCRIPTION DRUG
MonthTheoretical PremiumH.S.A/HRA DepositsAdministrative FeesStop-Loss PremiumsTotal Expenses & Stop-Loss PremiumMedical Paid ClaimsDrug Paid ClaimsStop-Loss ReimbursementsDrug Plan Rebates*Total Paid ClaimsExpenses & Paid ClaimsLoss RatioMargin/(Deficit)Employee ContributionsNet Fund Balance
Jul-25$327,647$11,785$36,374$48,159$364,924$82,137$0$0$447,061$495,220151.1%($167,573)$54,070($113,503)
Aug-25$341,760$12,655$39,061$51,716$302,731$63,675$0($97,201)$269,205$320,92193.9%$20,839$50,843$71,682
Sep-25$336,439$12,522$38,647$51,169$173,227$126,083$0$0$299,310$350,479104.2%($14,040)$46,907$32,867
Oct-25$338,889$12,588$38,854$51,442$260,768$92,593$0$0$353,361$404,803119.5%($65,914)$47,932($17,982)
Nov-25$331,873$12,455$38,441$50,895$138,445$94,790$0$0$233,236$284,13185.6%$47,742$46,054$93,795
Dec-25
Jan-26
Feb-26
Mar-26
Apr-26
May-26
Jun-26
Totals$1,676,608$62,005$191,376$253,381$1,240,095$459,279$0($97,201)$1,602,173$1,855,554110.7%($178,946)$245,805$66,859

ACTIVE

&G &G

Cigna Claims by Branch

VERNON TOWN AND BOARD OF EDUCATION
MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT
July 2025 thru July 2025
Funding Type : SELF-FUNDED (ASO)
Reported Premium: Billed Pooled Premium, ASO Fees
Reported Claims: All Claims, All HRA, Debit, Clms Fwrd, Check, ATM
Paid claim dollars include amounts deducted from your account and paid to vendors for cost containment services.
YTD/MONTHACCOUNTPRODUCT TYPEBRANCHFIXED CHARGESIN NETWORKOUT OF NETWORKDRUGGROSS CLAIMSNET CLAIMSTotal HRATotal HRA & ClaimsTotal HSATotal HSA & CLAIMSPOOLED PREMIUMTOTAL ASO FEESTOTAL SUBSTOTAL MBRS
Jul-253343565-VERNON TOWN AND BOARD OF EDUCATIONOAP17970-BOE TEACHERS$34,307$207,215$2,147$72,406$316,075$316,075$0$316,075$63,374$379,449$48,557$10,026242613
7971-BOE ADMIN$2,960$48,252$0$2,586$53,798$53,798$0$53,798$4,621$58,419$3,010$6211548
7972-BOE SEC/MAIN/CUST$4,808$65,945($1,957)$4,668$73,464$73,464$0$73,464$8,516$81,980$8,026$1,6574082
7973-BOE PARAS$3,280$39,607$1,407$10,009$54,302$54,302$108$54,411$3,623$57,925$6,822$1,4093458
7974-BOE LIBRARIANS$331$681$0$0$1,012$1,012$0$1,012$945$1,957$201$4115
7975-BOE NURSES$951$2,558$0$141$3,651$3,651$0$3,651$26$3,677$1,405$290717
7976-BOE CAFETERIA$836$3,393$0$1,408$5,637$5,637$0$5,637$962$6,599$2,207$4561116
7977-BOE NON-AFFILIATE$3,410$5,520$0$19,914$28,844$28,844$561$29,406$5,197$34,041$5,016$1,0362562
7978-BOE SUPERVISORS$3$0$0$0$3$3$0$3$0$3$0$000
7979-BOE PART-TIME$97$907$0$0$1,004$1,004$0$1,004$0$1,004$201$3911
7980-BOE RETIREES$687$6,483$0$328$7,499$7,499$0$7,499$0$7,499$2,207$4281113
7981-BOE RETIREES NON MEDICARE ELIGIBLE$523$6,475$0$6,752$13,750$13,750$0$13,750$0$13,750$2,207$4281111
7982-BOE COBRA$2$16$0$0$18$18$0$18$0$18$0$000
7983-TOWN NON-UNION$5,282$158,615$790$39,794$204,481$204,481$2,637$207,118$19,778$224,259$8,829$1,8234488
7984-VERNON TOWN PROFESSIONALS$1,702$20,572$240$104$22,618$22,618$0$22,618$3,344$25,962$2,207$4561130
7985-DEPARTMENT HEAD$824$3,700$497$1,285$6,305$6,305$0$6,305$3,861$10,166$1,405$290716
7986-POLICE OFFICERS$6,120$53,524$396$9,469$69,509$69,509$0$69,509$10,706$80,215$7,825$1,61639109
7987-POLICE CIVILIANS$441$176$0$0$617$617$0$617$1,521$2,137$1,204$24969
7988-DPW SUPERVISORS$760$3,952$278$236$5,227$5,227$0$5,227$2,436$7,662$602$124313
7989-DPW LINE$4,107$19,369$0$10,669$34,145$34,145$0$34,145$14,213$48,357$8,026$1,6574079
7990-WPC NON-UNION$124$67$0$0$191$191$0$191$0$191$201$4112
7991-WPC PROFESSIONALS UNION$54$8$0$0$62$62$0$62$0$62$201$4111
7992-WPC DPW LINE$1,093$2,583$0$11,384$15,061$15,061$0$15,061$1,918$16,980$1,806$373920
7993-WPC SUPERVISORS$49$12$0$0$61$61$0$61$0$61$201$4111
7994-VCC NON-UNION$312$713$0$30$1,055$1,055$0$1,055$147$1,202$401$8325
7995-DP NON-UNION$115$5,308$0$5$5,429$5,429$0$5,429$0$5,429$201$4112
7996-DATA PROFESSIONALS$402$6,058$0$565$7,024$7,024$2,000$9,024$1,628$8,653$803$16648
7997-TOWN RETIREES$265$61,932$0$223$62,420$62,420$0$62,420$0$62,420$602$11733
7998-POLICE RETIREES$269$780$0$3,164$4,213$4,213$0$4,213$0$4,213$803$15645
7999-TOWN COBRA$49$4$0$0$53$53$0$53$0$53$201$3911
8003-AMBULANCE$956$2,425$0$5,209$8,590$8,590$0$8,590$4,100$12,690$2,408$4971217
PRODUCT TYPE Total$75,121$726,851$3,797$200,350$1,006,118$1,006,118$5,306$1,011,425$150,914$1,157,033$117,782$24,2425871,335
Aug-253343565-VERNON TOWN AND BOARD OF EDUCATIONOAP17970-BOE TEACHERS$34,777$134,529$39,571$44,906$253,782$253,782$0$253,782$69,441$323,223$48,758$10,067243618
7971-BOE ADMIN$2,780$9,636$0$2,980$15,396$15,396$0$15,396$12,628$28,024$3,010$6211548
7972-BOE SEC/MAIN/CUST$4,614$25,569$0$4,307$34,489$34,489$0$34,489$7,980$42,469$7,825$1,6163981
7973-BOE PARAS$3,622$61,223$217$6,383$71,445$71,445$161$71,606$8,054$79,499$6,621$1,3673357
7974-BOE LIBRARIANS$280$312$0$0$592$592$0$592$0$592$201$4115
7975-BOE NURSES$965$3,757$0$182$4,904$4,904$0$4,904$456$5,361$1,405$290717
7976-BOE CAFETERIA$874$529$0$1,029$2,433$2,433$0$2,433$1,065$3,497$2,207$4561115
7977-BOE NON-AFFILIATE$3,462$71,748$0$6,527$81,738$81,738$1,240$82,978$7,095$88,833$5,016$1,0362562
7979-BOE PART-TIME$48$0$0$93$142$142$0$142$0$142$201$3911
7980-BOE RETIREES$689$3,246$0$1,787$5,722$5,722$0$5,722$0$5,722$2,207$4281113
7981-BOE RETIREES NON MEDICARE ELIGIBLE$924$65,677$0$1,712$68,313$68,313$0$68,313$0$68,313$2,207$4281111
7982-BOE COBRA$4$0$0$0$4$4$0$4$0$4$201$3911
7983-TOWN NON-UNION$4,896$244,703$0$30,838$280,438$280,438$4,490$284,927$15,134$295,572$9,029$1,8644589
7984-VERNON TOWN PROFESSIONALS$1,698$990$1,760$220$4,667$4,667$0$4,667$1,495$6,163$2,207$4561130
7985-DEPARTMENT HEAD$873$1,403$0$1,053$3,329$3,329$0$3,329$2,450$5,779$1,405$290716
7986-POLICE OFFICERS$6,130$12,461$0$6,848$25,440$25,440$0$25,440$13,560$38,999$7,825$1,61639110
7987-POLICE CIVILIANS$486$82$0$0$568$568$0$568$611$1,179$1,204$24969
7988-DPW SUPERVISORS$753$1,749$0$165$2,667$2,667$0$2,667$309$2,976$602$124313
7989-DPW LINE$4,342$5,184$0$2,442$11,968$11,968$0$11,968$8,068$20,036$8,026$1,6574080
7990-WPC NON-UNION$109$0$0$0$109$109$0$109$0$109$201$4112
7991-WPC PROFESSIONALS UNION$54$0$0$0$54$54$0$54$409$463$201$4111
7992-WPC DPW LINE$1,139$2,896$0$16,709$20,744$20,744$0$20,744$6,138$26,882$1,605$331819
7993-WPC SUPERVISORS$49$0$0$0$49$49$0$49$0$49$201$4111
7994-VCC NON-UNION$283$49$0$30$362$362$0$362$293$655$401$8325
7995-DP NON-UNION$105$526$0$0$630$630$0$630$0$630$201$4112
7996-DATA PROFESSIONALS$459$3,873$0$40$4,371$4,371$447$4,818$2$4,373$1,003$20759
7997-TOWN RETIREES$157$0$0$0$157$157$0$157$0$157$602$11733
7998-POLICE RETIREES$264$780$0$5,229$6,272$6,272$0$6,272$0$6,272$803$15645
7999-TOWN COBRA$49$0$0$0$49$49$0$49$0$49$0$000
8003-AMBULANCE$916$3,514$0$101$4,531$4,531$0$4,531$2,690$7,221$2,408$4971216
PRODUCT TYPE Total$75,802$654,435$41,548$133,581$905,366$905,366$6,338$911,703$157,878$1,063,244$117,782$24,2425871,339

ACCOUNT Total $75,802 $654,435 $41,548 $133,581 $905,366 $905,366 $6,338 $911,703 $157,878 $1,063,244 $117,782 $24,242 587 1,339

Aug-2025 Total $75,802 $654,435 $41,548 $133,581 $905,366 $905,366 $6,338 $911,703 $157,878 $1,063,244 $117,782 $24,242 587 1,339

Sep-253343565-VERNON TOWN AND BOARD OF EDUCATIONOAP17970-BOE TEACHERS$43,045$139,396$42,699$94,512$319,652$319,652$0$319,652$89,527$409,180$47,955$9,902239609
7971-BOE ADMIN$6,155$10,387$0$4,123$20,665$20,665$0$20,665$7,338$28,003$2,809$5801446
7972-BOE SEC/MAIN/CUST$5,671$20,456$0$7,239$33,366$33,366$0$33,366$6,472$39,838$8,026$1,6574082
7973-BOE PARAS$3,626$37,003$0$7,779$48,409$48,409$20$48,429$8,427$56,836$6,220$1,2843156
7974-BOE LIBRARIANS$280$0$0$0$280$280$0$280$0$280$201$4115
7975-BOE NURSES$984$4,076$0$41$5,101$5,101$0$5,101$1,154$6,255$1,605$331818
7976-BOE CAFETERIA$822$1,432$0$1,081$3,335$3,335$0$3,335$1,208$4,543$2,207$4561115
7977-BOE NON-AFFILIATE$3,446$3,809$0$3,307$10,562$10,562$60$10,622$3,145$13,707$4,816$9942459
7979-BOE PART-TIME$48$0$0$0$48$48$0$48$0$48$201$3911
7980-BOE RETIREES$677$1,400$0$3,013$5,090$5,090$0$5,090$0$5,090$2,207$4281112
7981-BOE RETIREES NON MEDICARE ELIGIBLE$569$7,287$245$3,067$11,169$11,169$0$11,169$0$11,169$2,207$4281111
7982-BOE COBRA$49$0$0$0$49$49$0$49$0$49$0$000
7983-TOWN NON-UNION$7,387$40,202$160$66,862$114,611$114,611$690$115,301$17,272$131,883$9,029$1,8644588
7984-VERNON TOWN PROFESSIONALS$1,689$1,270$0$222$3,181$3,181$0$3,181$3,921$7,102$2,207$4561130
7985-DEPARTMENT HEAD$1,717$1,752$0$1,059$4,529$4,529$82$4,610$2,108$6,637$1,405$290716
7986-POLICE OFFICERS$7,797$65,342$0$16,211$89,350$89,350$0$89,350$15,366$104,715$7,625$1,57438109
7987-POLICE CIVILIANS$486$189$0$287$961$961$0$961$997$1,959$1,405$290712
7988-DPW SUPERVISORS$757$828$0$0$1,585$1,585$0$1,585$956$2,541$602$124313
7989-DPW LINE$4,427$6,902$0$9,056$20,385$20,385$0$20,385$10,247$30,632$7,825$1,6163979
7990-WPC NON-UNION$112$0$0$289$402$402$0$402$172$574$201$4112
7991-WPC PROFESSIONALS UNION$54$0$0$13,020$13,075$13,075$0$13,075$176$13,251$201$4111
7992-WPC DPW LINE$1,086$2,200$0($165)$3,121$3,121$0$3,121$1,626$4,747$1,605$331819
7993-WPC SUPERVISORS$49$0$0$0$49$49$0$49$0$49$201$4111
7994-VCC NON-UNION$283$15,399$0$30$15,711$15,711$0$15,711$224$15,935$401$8326
7995-DP NON-UNION$127$0$0$95$222$222$0$222$0$222$201$4112
7996-DATA PROFESSIONALS$503$5,007$0$44$5,554$5,554$534$6,088$252$5,807$1,003$20759
7997-TOWN RETIREES$157$736$0$0$893$893$0$893$0$893$602$11733
7998-POLICE RETIREES$264$1,640$0$5,323$7,227$7,227$0$7,227$0$7,227$803$15645
ACTIVE8003-AMBULANCE$862$3,843$0$13,750$18,454$18,454$0$18,454$1,150$19,605$2,207$4561115
PRODUCT TYPE Total$93,129$370,558$43,104$250,245$757,036$757,036$1,387$758,423$171,738$928,775$115,976$23,8725781,324

ACCOUNT Total $93,129 $370,558 $43,104 $250,245 $757,036 $757,036 $1,387 $758,423 $171,738 $928,775 $115,976 $23,872 578 1,324

Sep-2025 Total $93,129 $370,558 $43,104 $250,245 $757,036 $757,036 $1,387 $758,423 $171,738 $928,775 $115,976 $23,872 578 1,324

Oct-253343565-VERNON TOWN AND BOARD OF EDUCATIONOAP17970-BOE TEACHERS$37,411$246,736$13,661$71,775$369,583$369,583$0$369,583$79,244$448,827$47,755$9,860238610
7971-BOE ADMIN$2,894$26,817$0$4,870$34,581$34,581$0$34,581$3,933$38,514$2,809$5801446
7972-BOE SEC/MAIN/CUST$5,052$33,047$0$9,883$47,981$47,981$0$47,981$6,212$54,193$7,825$1,6163981
7973-BOE PARAS$3,447$23,892$96$9,983$37,418$37,418$377$37,796$7,791$45,209$6,421$1,3263257
7974-BOE LIBRARIANS$310$59$0$0$368$368$0$368$0$368$201$4115
7975-BOE NURSES$1,108$6,587$0$407$8,102$8,102$0$8,102$2,664$10,766$1,605$331818
7976-BOE CAFETERIA$892$2,076$0$1,010$3,978$3,978$0$3,978$2,016$5,994$2,007$4141014
7977-BOE NON-AFFILIATE$3,768$8,006$0$25,968$37,742$37,742$206$37,949$7,896$45,638$4,816$9942459
7979-BOE PART-TIME$54$565$0$179$798$798$0$798$0$798$201$3911
7980-BOE RETIREES$646$4,938$0$3,881$9,465$9,465$0$9,465$0$9,465$2,007$3891011
7981-BOE RETIREES NON MEDICARE ELIGIBLE$581$9,107$0$3,515$13,202$13,202$0$13,202$0$13,202$2,207$4281111
7982-BOE COBRA($4)$4$0$0$0$0$0$0$0$0$201$3911
7983-TOWN NON-UNION$5,398$60,376$720$56,402$122,896$122,896$10$122,906$16,392$139,288$9,029$1,8644591
7984-VERNON TOWN PROFESSIONALS$1,857$3,049$0$77$4,984$4,984$0$4,984$1,006$5,989$2,408$4971231
7985-DEPARTMENT HEAD$967$3,497$0$2,509$6,972$6,972$83$7,055$3,605$10,577$1,405$290715
7986-POLICE OFFICERS$7,829$53,628$469$2,481$64,408$64,408$0$64,408$6,475$70,883$7,424$1,53337105
7987-POLICE CIVILIANS$712$35,674$0$2,024$38,410$38,410$0$38,410$113$38,523$1,405$290712
7988-DPW SUPERVISORS$830$1,178$0$287$2,295$2,295$0$2,295$1,249$3,544$602$124313
7989-DPW LINE$4,813$25,475$345$6,482$37,115$37,115$0$37,115$13,327$50,441$7,625$1,5743878
7990-WPC NON-UNION$121$190$0$0$310$310$0$310$1,371$1,682$201$4112
7991-WPC PROFESSIONALS UNION$60$551$0$7,759$8,369$8,369$0$8,369$93$8,462$201$4111
7992-WPC DPW LINE$1,194$5,728$0$371$7,293$7,293$0$7,293$1,496$8,789$1,605$331819
7993-WPC SUPERVISORS$55$12$0$0$66$66$0$66$0$66$201$4111
7994-VCC NON-UNION$371$3,317$0$50$3,738$3,738$0$3,738$82$3,820$401$8326
7995-DP NON-UNION$117$3,927$0$576$4,619$4,619$0$4,619$0$4,619$201$4112
7996-DATA PROFESSIONALS$541$3,266$0$44$3,851$3,851$0$3,851$1,858$5,710$1,003$20757
7997-TOWN RETIREES$173$3,318$0$104$3,596$3,596$0$3,596$0$3,596$602$11733
7998-POLICE RETIREES$293$3,615$34$5,509$9,451$9,451$0$9,451$0$9,451$1,003$19556
7999-TOWN COBRA$0$4$0$0$4$4$0$4$0$4$0$000
8003-AMBULANCE$894$26,172$0$7,918$34,985$34,985$0$34,985$2,097$37,081$2,408$4971219
PRODUCT TYPE Total$82,382$594,808$15,325$224,064$916,579$916,579$677$917,256$158,920$1,075,499$115,775$23,8285771,325

ACCOUNT Total $82,382 $594,808 $15,325 $224,064 $916,579 $916,579 $677 $917,256 $158,920 $1,075,499 $115,775 $23,828 577 1,325

Oct-2025 Total $82,382 $594,808 $15,325 $224,064 $916,579 $916,579 $677 $917,256 $158,920 $1,075,499 $115,775 $23,828 577 1,325

Nov-253343565-VERNON TOWN AND BOARD OF EDUCATIONOAP17970-BOE TEACHERS$38,263$171,069$11,529$75,735$296,597$296,597$0$296,597$59,503$356,099$47,755$9,860238608
7971-BOE ADMIN$2,957$9,107$0$3,827$15,891$15,891$0$15,891$1,260$17,151$2,809$5801446
7972-BOE SEC/MAIN/CUST$5,128$55,463$0$10,838$71,429$71,429$0$71,429$6,925$78,354$7,825$1,6163978
7973-BOE PARAS$3,731$15,388$217$9,455$28,791$28,791$0$28,791$5,691$34,482$6,220$1,2843156
7974-BOE LIBRARIANS$310$0$0$0$310$310$0$310$0$310$201$4115
7975-BOE NURSES$1,123$360$0$138$1,621$1,621$0$1,621$1,490$3,110$1,605$331818
7976-BOE CAFETERIA$835$6,365$0$1,172$8,371$8,371$0$8,371$1,017$9,388$2,007$4141014
7977-BOE NON-AFFILIATE$3,698$6,407$0$7,977$18,082$18,082$30$18,112$6,134$24,216$5,016$1,0362560
7979-BOE PART-TIME$54$3$0$116$172$172$0$172$0$172$201$3911
7980-BOE RETIREES$635$2,783$0$5,386$8,804$8,804$0$8,804$0$8,804$1,806$35099
7981-BOE RETIREES NON MEDICARE ELIGIBLE$590$19,911$0$2,876$23,378$23,378$0$23,378$0$23,378$2,007$3891010
7982-BOE COBRA$60$0$0$0$60$60$0$60$0$60$201$3911
7983-TOWN NON-UNION$7,603$35,119$1,137$49,540$93,399$93,399$78$93,476$8,924$102,322$9,230$1,9064695
7984-VERNON TOWN PROFESSIONALS$1,939$6,092$2,400$2,194$12,626$12,626$0$12,626$3,394$16,020$2,408$4971231
7985-DEPARTMENT HEAD$908$2,682$78$138$3,806$3,806$0$3,806$2,483$6,289$1,405$290715
7986-POLICE OFFICERS$6,580$16,523$428$16,833$40,365$40,365$0$40,365$6,875$47,240$7,223$1,49136101
7987-POLICE CIVILIANS$721$1,401$0$43$2,165$2,165$0$2,165$775$2,940$1,405$290712
7988-DPW SUPERVISORS$830$0$0$236$1,066$1,066$0$1,066$427$1,493$602$124313
7989-DPW LINE$4,737$4,715$277$4,747$14,476$14,476$0$14,476$4,113$18,589$7,625$1,5743878
7990-WPC NON-UNION$124$760$0$0$884$884$0$884$247$1,131$201$4112
7991-WPC PROFESSIONALS UNION$60$3,289$0$7,747$11,095$11,095$0$11,095$19$11,114$201$4111
7992-WPC DPW LINE$1,200$5,468$0$345$7,013$7,013$0$7,013$2,338$9,351$1,806$373919
7993-WPC SUPERVISORS$55$0$0$0$55$55$0$55$0$55$201$4111
7994-VCC NON-UNION$356$0$0$59$415$415$0$415$312$727$201$4112
7995-DP NON-UNION$117$196$0$141$454$454$0$454$0$454$201$4112
7996-DATA PROFESSIONALS$421$1,351$0$39$1,811$1,811$0$1,811$736$2,547$1,003$20757
7997-TOWN RETIREES$1,104$180$0$0$1,284$1,284$0$1,284$0$1,284$401$7822
7998-POLICE RETIREES$348$2,822$0$5,458$8,629$8,629$0$8,629$0$8,629$1,003$19556
8003-AMBULANCE$1,134$25,290$0$7,271$33,694$33,694$0$33,694$1,959$35,654$2,207$4561118
PRODUCT TYPE Total$85,620$392,744$16,067$212,310$706,741$706,741$108$706,849$114,622$821,364$114,972$23,6695731,311

ACCOUNT Total $85,620 $392,744 $16,067 $212,310 $706,741 $706,741 $108 $706,849 $114,622 $821,364 $114,972 $23,669 573 1,311

Nov-2025 Total $85,620 $392,744 $16,067 $212,310 $706,741 $706,741 $108 $706,849 $114,622 $821,364 $114,972 $23,669 573 1,311

Prem v. Claims

Theoretical PremiumClaims & ExpensesMargin/(Deficit)
Jul-24$1,038,385$1,163,182($124,797)
Aug-24$1,040,583$862,071$178,511
Sep-24$1,025,300$915,195$110,106
Oct-24$1,026,431$1,074,464($48,033)
Nov-24$1,013,380$863,531$149,849
Dec-24
Jan-25
Feb-25
Mar-25
Apr-25
May-25
Jun-25
Totals$5,144,079$4,878,443$265,636
ACTIVE

&G &G

VERNON TOWN & PUBLIC SCHOOLS

Medical Premium vs. Claims

FYE 2026

Claims & Expenses 45474 45505 45536 45566 45597 45627 45658 45689 45717 45748 45778 1163182.0199999998 862071.34 915194.53 1074463.6299999999 863531.43 Theoretical Premium 45474 45505 45536 45566 45597 45627 45658 45689 45717 45748 45778 45809 1038384.6894 1040582.5733999999 1025300.3482499999 1026430.76055 1013380.4738999999

Town Enrollment

RATESApproved Renewal Increase
Employee$978.92$978.92$978.92$978.92$978.92$1,045.06$1,045.06$978.92$978.92$978.92$978.92$978.92$978.92$978.92$978.92$978.92$978.92$978.92$978.92$978.92$978.92$978.92$978.92$1,045.06$1,045.06$1,045.06$1,045.06$1,045.06$1,045.06$1,045.06$978.92$978.92$978.92$978.92$978.92$978.92Effective July 1, 2025
Employee Sp$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$2,090.14$2,090.14$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$2,090.14$2,090.14$2,090.14$2,090.14$2,090.14$2,090.14$2,090.14$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.829.50%
Employee Ch$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$2,090.14$2,090.14$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$2,090.14$2,090.14$2,090.14$2,090.14$2,090.14$2,090.14$2,090.14$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82$1,957.82
Family$2,643.06$2,643.06$2,643.06$2,643.06$2,643.06$2,821.63$2,821.63$2,643.06$2,643.06$2,643.06$2,643.06$2,643.06$2,643.06$2,643.06$2,643.06$2,643.06$2,643.06$2,643.06$2,643.06$2,643.06$2,643.06$2,643.06$2,643.06$2,821.63$2,821.63$2,821.63$2,821.63$2,821.63$2,821.63$2,821.63$2,643.06$2,643.06$2,643.06$2,643.06$2,643.06$2,643.06
Employee Counts
branch79977998799779987996798379837984798579867987798879897996798479857986798779897992799379967983799079947995800379838003798879897992798979927989
NameTown RetireePolice RetireeTown RetireePolice Retiree7996-DATA PROFESSIONALSTown Non-UnionTown Non-Union7984-VERNON TOWN PROFESSIONALS7985-DEPARTMENT HEAD7986-POLICE OFFICERS7987-POLICE CIVILIANS7988-DPW SUPERVISORS7989-DPW LINE7996-DATA PROFESSIONALS7984-VERNON TOWN PROFESSIONALS7985-DEPARTMENT HEAD7986-POLICE OFFICERS7987-POLICE CIVILIANS7989-DPW LINE7991-WPC Professionals7992-WPC DPW LINE7993-WPC SUPERVISORS7996-DATA PROFESSIONALS7983-TOWN NON-UNION7990-WPC NON-UNION7994-VCC NON-UNION7995-DP NON-UNIONAmbulanceTown Non-UnionAmbulance7988-DPW SUPERVISORS7989-DPW LINE7992-WPC DPW LINE7989-DPW LINE7992-WPC DPW LINE7989-DPW LINE
Plan4k4k2k2k4k4K20004k4k4k4k4k4k4k2k2k2k2k2k2k3k3k3k3k3k15004k4k4k2k2k4k
July
Employee00520021000000131052212000001050002040181585
Employee Sp21001303260000000000009101000041001
Employee Ch00000001131000000000003110100000000
Family0000000422102410000000012010100173000
Total Premium$3,916$1,958$4,895$1,958$1,958$6,270$2,090$19,382$11,160$73,125$1,958$5,286$10,572$2,643$979$2,937$9,789$4,895$1,958$0$1,958$979$1,958$58,941$4,180$4,912$2,090$4,912$10,451$5,225$2,643$26,333$9,887$19,578$3,916$1,958$327,647
August
Employee003300110000001212411212000011490002020190588
Employee Sp210013031310010000000013001100050000
Employee Ch00000001131000000000004110000020000
Family0000100522102400000000010010100184000
Total Premium$3,916$1,958$2,937$2,937$4,601$6,270$1,045$22,025$9,202$67,251$3,916$5,286$10,572$1,958$979$1,958$11,747$3,916$979$979$1,958$979$1,958$63,749$2,090$4,912$2,090$5,957$14,631$9,406$2,643$34,849$10,572$19,578$1,958$341,760
September
Employee003300110000001211411212000011580001920186578
Employee Sp010012031310010000000013001100050000
Employee Ch00000001131000000000004110000020000
Family0000100522112400000000010010100184000
Total Premium$0$1,958$2,937$2,937$4,601$4,180$1,045$22,025$9,202$67,251$6,559$5,286$10,572$1,958$979$1,958$10,768$3,916$979$979$1,958$979$1,958$63,749$2,090$4,912$2,090$5,957$15,676$8,360$2,643$34,849$10,572$18,599$1,958$336,439
October
Employee00340011000000221141121300001148000182018857779
Employee Sp01001203131001000000001300110005000033
Employee Ch0000000113100000000000511010002000016
Family000010052201240000000001001010018400060
Total Premium$0$1,958$2,937$3,916$4,601$4,180$1,045$22,025$9,202$64,608$6,559$5,286$10,572$1,958$1,958$1,958$10,768$3,916$979$979$1,958$979$2,937$65,839$2,090$4,912$2,090$8,047$14,631$8,360$2,643$34,849$10,572$17,621$1,958$338,889
November
Employee00240011000000221141131300001147000182018557278
Employee Sp010012031310010000000001300110005100034
Employee Ch00000001131000000000000511010002000016
Family0000000521912400000000001100010018300057
Total Premium$0$1,958$1,958$3,916$1,958$4,180$1,045$22,025$9,202$61,965$6,559$5,286$10,572$1,958$1,958$1,958$10,768$3,916$979$979$2,937$979$2,937$68,660$2,090$2,090$2,090$8,047$14,631$7,315$2,643$34,849$9,887$17,621$1,958$331,873
December
Employee0
Employee Sp
Employee Ch
Family
Total Premium$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
January
Employee0
Employee Sp
Employee Ch
Family
Total Premium$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
February
Employee0
Employee Sp
Employee Ch
Family
Total Premium$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
March
Employee0
Employee Sp
Employee Ch
Family
Total Premium$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
April
Employee0
Employee Sp
Employee Ch
Family
Total Premium$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
May
Employee0
Employee Sp
Employee Ch
Family
Total Premium$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
June
Employee0
Employee Sp
Employee Ch
Family
Total Premium$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
CONTRIBUTIONS100%100%100%100%17%8.0%8.0%17%17%17%15%16%13%17%17%17%17%15%13%13%17%17%8.0%8.0%8.0%8.0%8.0%8.0%8.0%16%13%13%13%13%13%Monthly Total
July 2024$3,915.63$1,957.82$4,894.60$1,957.84$332.83$501.63$167.21$3,295.01$1,897.13$12,431.17$293.67$845.78$1,374.39$449.32$166.42$499.25$1,664.16$734.19$254.52$0.00$332.83$166.42$156.63$4,715.29$334.42$392.94$167.21$392.94$836.05$836.05$343.60$3,423.25$1,285.31$2,545.19$509.04$54,069.71$225,189.92
August$3,915.63$1,957.82$2,936.76$2,936.76$782.15$501.63$83.60$3,744.33$1,564.30$11,432.68$587.34$845.78$1,374.39$332.83$166.42$332.83$1,996.99$587.35$127.26$127.26$332.83$166.42$156.63$5,099.89$167.21$392.94$167.21$476.55$1,170.46$1,504.88$343.60$4,530.39$1,374.39$2,545.19$254.52$50,843.12
September$0.00$1,957.82$2,936.76$2,936.76$782.15$334.42$83.60$3,744.33$1,564.30$11,432.68$983.80$845.78$1,374.39$332.83$166.42$332.83$1,830.58$587.35$127.26$127.26$332.83$166.42$156.63$5,099.89$167.21$392.94$167.21$476.55$1,254.07$1,337.67$343.60$4,530.39$1,374.39$2,417.93$254.52$46,906.71
October$0.00$1,957.82$2,936.76$3,915.68$782.15$334.42$83.60$3,744.33$1,564.30$10,983.36$983.80$845.78$1,374.39$332.83$332.83$332.83$1,830.58$587.35$127.26$127.26$332.83$166.42$234.94$5,267.10$167.21$392.94$167.21$643.76$1,170.46$1,337.67$343.60$4,530.39$1,374.39$2,290.67$254.52$47,931.86
November$0.00$1,957.82$1,957.84$3,915.68$332.83$334.42$83.60$3,744.33$1,564.30$10,534.04$983.80$845.78$1,374.39$332.83$332.83$332.83$1,830.58$587.35$127.26$127.26$499.25$166.42$234.94$5,492.83$167.21$167.21$167.21$643.76$1,170.46$1,170.46$343.60$4,530.39$1,285.31$2,290.67$254.52$46,053.51
December$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$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$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
January 2025$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$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$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
February$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$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$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
March$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$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$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
April$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$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$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
May$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$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$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
June$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$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$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
ACTIVE

BOE Enrollment

RATESlib cust maint secteach non aff adm paralib cust main secTeach non aff adm parateach non aff adm parasec main custparasnon affparasnursessec main custlibrariansec main custlib
Employee$965.14$965.14$965.14$965.14$965.14$1,028.07$965.14$964.94$965.14$977.34$1,028.07$1,028.07$1,028.07$1,028.07$967.07$967.07$965.14$965.14$965.14$964.94$965.14$965.14$965.14$964.94$965.14$977.34$977.34$964.94$965.14$558.45Approved Renewal Increase
Employee Sp$1,930.28$1,930.28$1,930.28$1,930.28$1,930.28$2,056.13$1,930.28$1,929.82$1,930.28$1,930.08$2,056.13$2,056.13$2,056.13$2,056.13$1,934.12$1,934.12$1,930.28$1,930.28$1,930.28$1,929.82$1,930.28$1,930.28$1,930.28$1,929.82$1,930.28$1,930.08$1,930.08$1,929.82$1,930.28$1,478.97Effective July 1, 2025
Employee Ch$1,930.28$1,930.28$1,930.28$1,930.28$1,930.28$2,056.13$1,930.28$1,929.82$1,930.28$1,930.08$2,056.13$2,056.13$2,056.13$2,056.13$1,934.12$1,934.12$1,890.86$1,930.28$1,930.28$1,929.82$1,890.86$1,930.28$1,930.28$1,929.82$1,890.86$1,930.08$1,930.08$1,929.82$1,930.28$1,478.979.50%
Family$2,605.85$2,605.85$2,605.85$2,605.85$2,605.85$2,775.76$2,734.54$2,605.26$2,734.54$2,605.57$2,775.76$2,775.76$2,775.76$2,775.76$2,611.07$2,611.07$2,605.85$3,000.05$2,734.54$2,605.26$2,605.85$3,000.05$2,734.54$2,605.26$2,605.85$2,605.57$2,605.57$2,605.26$2,605.85$1,996.59
Employee Counts
branch7982798279807980
Name7982-BOE COBRA7982-BOE COBRA7980-BOE RETIREES7980-BOE RETIREES7980-BOE RETIREES7972-BOE SEC/MAIN/CUST7973-BOE PARAS7977-BOE NON-AFFILIATE7973-BOE PARAS7975-BOE NURSES7972-BOE SEC/MAIN/CUST7974-BOE LIBRARIANS7972-BOE SEC/MAIN/CUST7974-BOE LIBRARIANS7976-BOE CAFETERIA7976-BOE CAFETERIA7970-BOE TEACHERS7971-BOE ADMIN7973-BOE PARAS7977-BOE NON-AFFILIATE7970-BOE TEACHERS7971-BOE ADMIN7973-BOE PARAS7977-BOE NON-AFFILIATE7970-BOE TEACHERS7975-BOE NURSES7975-BOE NURSES7978-BOE SUPERVISORS7981-BOE RETIREES NON MEDICARE ELIGIBLE7979-BOE PART-TIME
Plan4k2k2k4k2k2k4k4k2k2k4k4k2k2k4k2k4k4k4k4k2k2k2k2k2k4k2k4k2k
July
Employee0111700000102211410009912281020112404
Employee Sp0002000100700040172710000020000
Employee Ch0000000000100010190110000010000
Family10000000001110000106125130000020000
Total Premium$2,606$965$965$4,826$6,756$0$0$1,930$0$0$48,010$2,776$22,618$1,028$10,638$3,868$345,926$39,861$29,115$37,728$95,549$965$21,233$7,719$965$11,001$1,955$0$10,617$1,117$710,737
August
Employee0111700010102002540009621991020111398
Employee Sp0002000100700030173610000020000
Employee Ch0000000000100010160210000010000
Family00000000001010000109105130000020000
Total Premium$0$965$965$4,826$6,756$0$0$1,930$965$0$45,235$2,776$20,561$0$9,671$4,835$350,966$35,791$29,115$37,728$92,654$1,930$18,338$8,684$11,001$1,955$0$10,617$558$698,823
Employee0112700010102102530009521691030111392578
Employee Sp0001000100700030162710000020000
Employee Ch0000000000100010160210000010000
Family00000000001010000108105120000020000
Total Premium$0$965$965$3,861$6,756$0$0$1,930$965$0$45,235$2,776$21,590$0$9,671$4,835$345,465$33,861$31,045$35,123$91,689$1,930$15,442$8,684$965$11,001$2,932$0$10,617$558$688,861
October
Employee0111700010102001530009321791030111389178
Employee Sp000100010070003016271000002000040
Employee Ch000000000010001016021000001000022
Family00000000001010000109105120000020000149
Total Premium$0$965$965$2,895$6,756$0$0$1,930$965$0$45,235$2,776$20,561$0$8,704$4,835$348,071$33,861$31,045$35,123$89,758$1,930$16,407$8,684$965$11,001$2,932$0$10,617$558$687,542
November
Employee01117000101021015300093216101030101387
Employee Sp0000000100700030172710000020000
Employee Ch0000000000100010170210000010000
Family0000000000910000107105120000020000
Total Premium$0$965$965$965$6,756$0$0$1,930$965$0$42,459$2,776$21,590$0$8,704$4,835$346,680$33,861$31,045$35,123$89,758$1,930$15,442$9,649$965$11,001$2,932$0$9,651$558$681,508
December
Employee0
Employee Sp
Employee Ch
Family
Total Premium$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
January
Employee0
Employee Sp
Employee Ch
Family
Total Premium$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
February
Employee0
Employee Sp
Employee Ch
Family
Total Premium$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
March
Employee0
Employee Sp
Employee Ch
Family
Total Premium$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
April
Employee
Employee Sp
Employee Ch
Family
Total Premium$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
May
Employee
Employee Sp
Employee Ch
Family
Total Premium$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
June
Employee
Employee Sp
Employee Ch
Family
Total Premium$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
CONTRIBUTIONS100%100%100%100%100%20%22%20%22%23%20%21%20%21%22%22%21%23%22%20%21%23%22%20%21%23%23%19.0%100%39%Monthly Total
July 2023$2,605.85$965.14$965.14$4,825.70$6,756.01$0.00$0.00$385.96$0.00$0.00$9,602.09$582.91$4,523.52$215.90$2,340.29$851.02$72,644.47$9,168.06$6,405.29$7,545.59$20,065.34$221.98$4,671.30$1,543.90$202.68$2,530.32$449.58$0.00$10,616.58$435.59$171,120.21
August$0.00$965.14$965.14$4,825.70$6,756.01$0.00$0.00$385.96$212.33$0.00$9,046.93$582.91$4,112.29$0.00$2,127.54$1,063.78$73,702.95$8,232.00$6,405.29$7,545.59$19,457.30$443.97$4,034.30$1,736.88$0.00$2,530.32$449.58$0.00$10,616.58$217.80$166,416.31
September$0.00$965.14$965.14$3,860.56$6,756.01$0.00$0.00$385.96$212.33$0.00$9,046.93$582.91$4,317.91$0.00$2,127.54$1,063.78$72,547.69$7,788.04$6,829.95$7,024.54$19,254.62$443.97$3,397.31$1,736.88$202.68$2,530.32$674.37$0.00$10,616.58$217.80$163,548.96
October$0.00$965.14$965.14$2,895.42$6,756.01$0.00$0.00$385.96$212.33$0.00$9,046.93$582.91$4,112.29$0.00$1,914.78$1,063.78$73,094.91$7,788.04$6,829.95$7,024.54$18,849.26$443.97$3,609.64$1,736.88$202.68$2,530.32$674.37$0.00$10,616.58$217.80$162,519.65
November$0.00$965.14$965.14$965.14$6,756.01$0.00$0.00$385.96$212.33$0.00$8,491.78$582.91$4,317.91$0.00$1,914.78$1,063.78$72,802.90$7,788.04$6,829.95$7,024.54$18,849.26$443.97$3,397.31$1,929.87$202.68$2,530.32$674.37$0.00$9,651.44$217.80$158,963.33
December$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$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$0.00$0.00$0.00$0.00$0.00
January 2024$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$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$0.00$0.00$0.00$0.00$0.00
February$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$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$0.00$0.00$0.00$0.00$0.00
March$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$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$0.00$0.00$0.00$0.00$0.00
April$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$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$0.00$0.00$0.00$0.00$0.00
May$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$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$0.00$0.00$0.00$0.00$0.00
June$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$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$0.00$0.00$0.00$0.00$0.00
ACTIVE

Aug LRG CLMS

VERNON TOWN AND BOARD OF EDUCATION
DE-IDENTIFIED CLAIMS EXCEEDING REPORT
July 2025 thru August 2025
Rating Type : POOLED STOP LOSS, RETROSPECTIVE EXPERIENCE RATED
Claims Exceeding : $50,000.00
Reported Claims: InNet, OutNet, Drug
Diagnosis is based on the largest medical claim amount
Member Status is as of the most current month.
BRANCHMEMBER STATUSRELICD DESCRIPTIONDRUG CLAIMSPAID CLAIMSCLAIMANT TOTAL
7983-TOWN NON-UNIONACTIVECHOPEN BITE OF RIGHT EAR, INITIAL ENCOUNTER$268$171,323$171,591
7983-TOWN NON-UNIONACTIVECHNONTRAUMATIC SUBARACHNOID HEMORRHAGE FROM UNSP INTRACRAN ART$0$105,270$105,270
7983-TOWN NON-UNIONACTIVESCPHARMACY$94$0$94
$94$105,270$105,364

7983-TOWN NON-UNION ACTIVE EE MALIGNANT NEOPLASM OF ANAL CANAL $495 $70,153 $70,649

7981-BOE RETIREES NON MEDICARE ELIGIBLE RETIREE EE SEPSIS, UNSPECIFIED ORGANISM $3,905 $57,865 $61,770

7983-TOWN NON-UNION ACTIVE EE INFLAMED SEBORRHEIC KERATOSIS $51,855 $436 $52,291

7977-BOE NON-AFFILIATE ACTIVE SP MULTIPLE SCLEROSIS $141 $64,648 $64,789

7997-TOWN RETIREES RETIREE EE DVTRCLI OF LG INT W PERFORATION AND ABSCESS W/O BLEEDING $0 $62,048 $62,048

Grand Total$56,758$531,745$588,503
ACTIVE

Sep LRG Clms

VERNON TOWN AND BOARD OF EDUCATION
DE-IDENTIFIED CLAIMS EXCEEDING REPORT
July 2025 thru September 2025
Rating Type : POOLED STOP LOSS, RETROSPECTIVE EXPERIENCE RATED
Claims Exceeding : $50,000.00
Reported Claims: InNet, OutNet, Drug
Diagnosis is based on the largest medical claim amount
Member Status is as of the most current month.
BRANCHMEMBER STATUSRELICD DESCRIPTIONDRUG CLAIMSPAID CLAIMSCLAIMANT TOTAL
7970-BOE TEACHERSACTIVESPALCOHOL DEPENDENCE, UNCOMPLICATED$0$81,743$81,743

7983-TOWN NON-UNION ACTIVE CH OPEN BITE OF RIGHT EAR, INITIAL ENCOUNTER $292 $179,977 $180,268

7983-TOWN NON-UNIONACTIVECHNONTRAUMATIC SUBARACHNOID HEMORRHAGE FROM UNSP INTRACRAN ART$0$107,488$107,488
7983-TOWN NON-UNIONACTIVESCPHARMACY$94$0$94
$94$107,488$107,582

7983-TOWN NON-UNION ACTIVE EE MALIGNANT NEOPLASM OF ANAL CANAL $546 $74,852 $75,398

7986-POLICE OFFICERS ACTIVE EE OTHER HODGKIN LYMPHOMA, LYMPH NODES OF HEAD, FACE, AND NECK $14,958 $59,987 $74,945

7981-BOE RETIREES NON MEDICARE ELIGIBLE RETIREE EE SEPSIS, UNSPECIFIED ORGANISM $4,980 $62,128 $67,108

7983-TOWN NON-UNION ACTIVE EE MALIGNANT NEOPLASM OF PROSTATE $102,889 $1,700 $104,589

7977-BOE NON-AFFILIATE ACTIVE SP MULTIPLE SCLEROSIS $283 $64,648 $64,932

7997-TOWN RETIREES RETIREE EE DVTRCLI OF LG INT W PERFORATION AND ABSCESS W/O BLEEDING $0 $62,276 $62,276

Grand Total$124,043$694,799$818,841
ACTIVE

Oct LRG Clms

VERNON TOWN AND BOARD OF EDUCATION
DE-IDENTIFIED CLAIMS EXCEEDING REPORT
July 2025 thru October 2025
Rating Type : POOLED STOP LOSS, RETROSPECTIVE EXPERIENCE RATED
Claims Exceeding : $50,000.00
Reported Claims: InNet, OutNet, Drug
Diagnosis is based on the largest medical claim amount
Member Status is as of the most current month.
BRANCHMEMBER STATUSRELICD DESCRIPTIONDRUG CLAIMSPAID CLAIMSCLAIMANT TOTAL
7970-BOE TEACHERSACTIVESPALCOHOL DEPENDENCE, UNCOMPLICATED$14$95,316$95,331

7983-TOWN NON-UNION ACTIVE CH OPEN BITE OF RIGHT EAR, INITIAL ENCOUNTER $292 $195,547 $195,838

7983-TOWN NON-UNIONACTIVECHNONTRAUMATIC SUBARACHNOID HEMORRHAGE FROM UNSP INTRACRAN ART$0$107,715$107,715
7983-TOWN NON-UNIONACTIVESCPHARMACY$108$0$108
$108$107,715$107,823

7983-TOWN NON-UNION ACTIVE EE MALIGNANT NEOPLASM OF ANAL CANAL $546 $81,316 $81,862

7986-POLICE OFFICERS ACTIVE EE OTHER HODGKIN LYMPHOMA, LYMPH NODES OF HEAD, FACE, AND NECK $15,002 $69,423 $84,425

7981-BOE RETIREES NON MEDICARE ELIGIBLE RETIREE EE SEPSIS, UNSPECIFIED ORGANISM $4,980 $67,821 $72,801

7970-BOE TEACHERS ACTIVE EE PARKINSON'S DIS WITH DYSKINESIA, W/O MENTION OF FLUCTUATIONS $5,577 $59,191 $64,768

7983-TOWN NON-UNION ACTIVE EE MALIGNANT NEOPLASM OF PROSTATE $138,598 $1,700 $140,298

7977-BOE NON-AFFILIATE ACTIVE SP MULTIPLE SCLEROSIS $356 $64,648 $65,004

7997-TOWN RETIREES RETIREE EE DVTRCLI OF LG INT W PERFORATION AND ABSCESS W/O BLEEDING $104 $65,496 $65,601

Grand Total $165,578 $808,172 $973,751

ACTIVE

Nov LRG Clms

VERNON TOWN AND BOARD OF EDUCATION
DE-IDENTIFIED CLAIMS EXCEEDING REPORT
July 2025 thru November 2025
Rating Type : POOLED STOP LOSS, RETROSPECTIVE EXPERIENCE RATED
Claims Exceeding : $50,000.00
Reported Claims: InNet, OutNet, Drug
Diagnosis is based on the largest medical claim amount
Member Status is as of the most current month.
BRANCHMEMBER STATUSRELICD DESCRIPTIONDRUG CLAIMSPAID CLAIMSCLAIMANT TOTAL
7970-BOE TEACHERSACTIVESPMALIGNANT NEOPLASM OF RECTUM$9,171$42,762$51,933

7970-BOE TEACHERS ACTIVE SP ALCOHOL DEPENDENCE, UNCOMPLICATED $34 $106,276 $106,310

7983-TOWN NON-UNION ACTIVE CH OPEN BITE OF RIGHT EAR, INITIAL ENCOUNTER $292 $195,693 $195,985

7983-TOWN NON-UNIONACTIVECHNONTRAUMATIC SUBARACHNOID HEMORRHAGE FROM UNSP INTRACRAN ART$0$107,715$107,715
7983-TOWN NON-UNIONACTIVESCPHARMACY$214$0$214
$214$107,715$107,929

7983-TOWN NON-UNION ACTIVE EE MALIGNANT NEOPLASM OF ANAL CANAL $689 $82,932 $83,621

7986-POLICE OFFICERS ACTIVE EE OTHER HODGKIN LYMPHOMA, LYMPH NODES OF HEAD, FACE, AND NECK $22,695 $74,184 $96,880

7981-BOE RETIREES NON MEDICARE ELIGIBLE TERMINATED EE SEPSIS, UNSPECIFIED ORGANISM $4,980 $68,955 $73,935

8003-AMBULANCE ACTIVE EE OTHER INTERVERTEBRAL DISC DISPLACEMENT, LUMBOSACRAL REGION $33,050 $32,789 $65,839

7972-BOE SEC/MAIN/CUSTACTIVEEEMULTIPLE SCLEROSIS$0($307)($307)
7972-BOE SEC/MAIN/CUSTACTIVEEERELAPSING-REMITTING MULTIPLE SCLEROSIS$2,280$56,074$58,354
$2,280$55,767$58,047

7970-BOE TEACHERS ACTIVE CH IMMUNE THROMBOCYTOPENIC PURPURA $0 $54,838 $54,838

7970-BOE TEACHERS ACTIVE EE PARKINSON'S DIS WITH DYSKINESIA, W/O MENTION OF FLUCTUATIONS $5,609 $69,461 $75,070

7983-TOWN NON-UNION ACTIVE EE MALIGNANT NEOPLASM OF PROSTATE $173,543 $1,863 $175,406

7977-BOE NON-AFFILIATE ACTIVE SP MULTIPLE SCLEROSIS $429 $64,648 $65,078

7997-TOWN RETIREES TERMINATED EE DVTRCLI OF LG INT W PERFORATION AND ABSCESS W/O BLEEDING $104 $65,496 $65,601

Grand Total$253,091$1,023,381$1,276,472
ACTIVE

R12 LRG Clms

VERNON TOWN AND BOARD OF EDUCATION
DE-IDENTIFIED CLAIMS EXCEEDING REPORT
December 2024 thru November 2025
Rating Type : POOLED STOP LOSS, RETROSPECTIVE EXPERIENCE RATED
Claims Exceeding : $50,000.00
Reported Claims: InNet, OutNet, Drug
Diagnosis is based on the largest medical claim amount
Member Status is as of the most current month.MedicalDrug
BRANCHMEMBER STATUSRELICD DESCRIPTIONDRUG CLAIMSPAID CLAIMSCLAIMANT TOTAL>$200K>$200K
7977-BOE NON-AFFILIATEACTIVEEESPONDYLOSIS W/O MYELOPATHY OR RADICULOPATHY, CERVICAL REGION$98,104$14,346$112,450

7996-DATA PROFESSIONALS ACTIVE SP HYPO-OSMOLALITY AND HYPONATREMIA $525 $58,893 $59,417

7970-BOE TEACHERS ACTIVE EE PATENT FORAMEN OVALE…

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .