23-V5 - City of Burleson 906435 - OVMCR-20B - Vision Membership by Tier Product - Membership 36Mo thru 2025-11.xlsx

XLSX spreadsheet 97 KB Posted

Attached to
RFP 2026-015 Dental & Vision Insurance Benefits
Solicitation number
RFP 2026-015
Issued by
Johnson County, Texas

About this file

This is a membership enrollment data report for the City of Burleson's Vision Insurance plan (Policy Number 0906435, Client ID 336654) under the OVMCR-20B product tier structure. The report captures subscriber and dependent enrollment counts across six membership tier categories—individual coverage, coverage with spouse, coverage with child, coverage with children, coverage with spouse and child, and coverage with spouse and children—from December 2022 through November 2025. The data reflects the client's effective date of January 1, 2016, with renewal scheduled for January 1, 2027. The three-year reporting period demonstrates membership trends across 36 months, tracking both the number of subscribers and total members (subscribers plus dependents) in each tier category.

The report shows total enrollment across the contract period of 5,769 subscribers with 21,666 dependents, resulting in 27,435 total members. Membership remained relatively stable throughout the period, with subscriber counts ranging from a low of 1,510 in June 2025 to a high of 1,680 in January 2024. The data indicates sustained demand for vision coverage across all tier options, with the highest enrollment concentrations in the "with spouse and children" and "with spouse" categories. This enrollment information serves as the baseline data for tracking utilization and plan performance under the City of Burleson's vision insurance benefits program.

View the file

Other files

File Type Posted
20-V2 - City of Burleson 906435 - OVMCR-01A - Vision Experience FI - Service 24Mo thru 2025-11.xlsx XLSX spreadsheet
9-D9 - CITY OF BURLESON ASO dental renewal.pdf PDF
17-01 - RFP 2026-015 Dental Vision Insurance Benefits.pdf PDF
22-V7 - CITY OF BURLESON VISION BENEFIT SUMMARY VH652 01.01.26.pdf PDF
4-03 - Form 1295 Certificate of Interested Parties.pdf PDF
6-D6 - City of Burleson 906435 - ODSCR-02B - Dental Experience ASO - Service CurMo thru 2025-12.pdf PDF
16-07 - Census Request Document.pdf PDF
8-D8 - City of Burleson 906435 - ODSCR-08B - Dental Membership by Tier Product - Membership CurMo thru 2025-12.pdf PDF
3-02 - Conflict of Interest Questionnaire.pdf PDF
18-V3 - City of Burleson 906435 - OVMCR-15A - Vision Dashboard - Service 24Mo thru 2025-11.xlsx XLSX spreadsheet
14-D2 - 906435- DENTAL PPO BUY UP PLAN.PDF PDF
21-V6 - CITY OF BURLESON sold vision renewal 09112024 jmw.pdf PDF
26-V9 - Vision RFP Questionnaire.xlsx XLSX spreadsheet
13-D1 - 2026 City of Burleson Guide.pdf PDF
24-V8 - Vision COC COB.pdf PDF
1-05 - Offeror Acknowledgment.pdf PDF
2-04 - W9 Form.pdf PDF
10-D10 - City of Burleson 906435 - ODSCR-01A - Dental Dashboard - Service 24Mo thru 2025-11.xlsx XLSX spreadsheet
7-D7 - City of Burleson 906435 - ODSCR-08B - Dental Membership by Tier Product - Membership 36Mo thru 2025-11.xlsx XLSX spreadsheet
11-D5 - City of Burleson 906435 - ODSCR-02B - Dental Experience ASO - Service 36Mo thru 2025-11.xlsx XLSX spreadsheet
19-V4 - City of Burleson 906435 - OVMCR-20A - Vision Membership by Tier - Membership YTD thru 2025-12.pdf PDF
5-06 - RFP 2026-015 Bid Opening Link.pdf PDF
12-D3 - 906435- PASSIVE DENTAL PPO.PDF PDF
15-D4 - City of Burleson - Dental RFP Questionnaire.xlsx XLSX spreadsheet
25-V1 - 2025-26 City of Burleson Guide.pdf PDF
Show all 25

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

OVMCR-20B

Membership Tiers by Product and Month

Selection Parameters Values on Report

Client Effective Date: 1/1/2016
Incurred Date Range: 12/1/2022 to 11/30/202512/1/2022 to 11/1/2025
Client Renewal Month Day: 1/1/2027
Client ID: 336654
Client Policy Number: 0906435

Group ID: -1

City of Burleson

Incurred DateSubscribers Count by TierMembers Count by TierTotal
Subscriber Onlyw/ Spousew/ Childw/ Childrenw/ Spouse & Childw/ Spouse & Childrenw/ Spousew/ Childw/ Childrenw/ Spouse & Childw/ Spouse & ChildrenSubscribersDependentsMembers
VH652December 20221,5,93,91,21,62,76,47,82,45,48,12,9,23,1,73,7,16,8,8
January 20231,5,74,01,21,82,77,18,02,46,18,13,2,33,2,54,0,17,2,6
February 20231,5,74,11,21,72,87,18,22,45,88,43,2,03,2,63,9,97,2,5
March 20231,5,94,11,31,72,87,18,22,65,88,43,2,03,2,94,0,07,2,9
April 20231,6,04,21,31,82,87,18,42,66,18,43,2,03,3,24,0,37,3,5
May 20231,6,44,01,31,92,87,28,02,66,68,43,2,53,3,64,0,97,4,5
June 20231,6,54,11,21,92,97,18,22,46,68,73,2,23,3,74,0,97,4,6
July 20231,6,54,01,31,83,07,18,02,66,39,03,2,23,3,74,0,97,4,6
August 20231,6,44,11,41,82,87,28,22,86,38,43,2,63,3,74,1,07,4,7
September 20231,6,44,11,41,82,77,28,22,86,38,13,2,63,3,64,0,87,4,4
October 20231,6,14,11,21,82,87,28,22,46,38,43,2,63,3,24,0,87,4,0
November 20231,6,14,01,31,82,87,28,02,66,38,43,2,63,3,24,0,87,4,0
December 20231,6,64,11,61,82,77,28,23,26,38,13,2,43,4,04,0,87,4,8
January 20241,6,83,81,81,93,57,17,63,66,81,0,53,1,93,4,94,2,37,7,2
February 20241,6,43,51,81,73,97,27,03,66,21,1,73,2,33,4,54,2,77,7,2
March 20241,6,33,51,81,63,87,67,03,65,71,1,43,4,33,4,64,3,77,8,3
April 20241,6,63,41,91,63,67,56,83,85,71,0,83,3,93,4,64,3,07,7,6
May 20241,6,83,21,91,63,67,36,43,85,71,0,83,3,13,4,44,2,27,6,6
June 20241,6,63,21,91,63,77,16,43,85,71,1,13,2,33,4,14,1,87,5,9
July 20241,6,73,21,91,63,67,16,43,85,71,0,83,2,33,4,14,1,67,5,7
August 20241,6,53,32,01,63,67,26,64,05,71,0,83,2,83,4,24,2,27,6,4
September 20241,6,03,22,01,63,57,36,44,05,71,0,53,3,23,3,64,2,27,5,8
October 20241,5,93,22,01,63,57,36,44,05,71,0,53,3,23,3,54,2,27,5,7
November 20241,6,43,12,01,73,67,36,24,06,11,0,83,3,23,4,14,2,67,6,7
December 20241,6,23,12,01,63,77,36,24,05,81,1,13,3,23,3,94,2,67,6,5
January 20251,5,53,31,81,74,17,76,63,66,21,2,33,5,43,4,14,5,57,9,6
February 20251,5,73,21,81,74,27,56,43,66,21,2,63,4,23,4,14,4,67,8,7
March 20251,5,83,21,91,64,47,46,43,85,91,3,23,3,93,4,34,4,77,9,0
April 20251,5,63,21,91,74,57,66,43,86,31,3,53,4,73,4,54,5,88,0,3
May 20251,5,53,11,91,74,67,76,23,86,31,3,83,5,13,4,54,6,28,0,7
June 20251,5,13,21,91,74,57,26,43,86,31,3,53,2,83,3,64,4,37,7,9
July 20251,5,43,31,81,94,37,36,63,67,01,2,93,3,23,4,04,4,77,8,7
August 20251,5,33,41,71,94,27,26,83,46,81,2,63,2,83,3,74,4,07,7,7
September 20251,5,23,51,72,14,07,17,03,47,51,2,03,2,33,3,64,3,87,7,4
October 20251,5,23,61,72,13,97,67,23,47,51,1,73,5,03,4,14,5,98,0,0
November 20251,5,23,61,82,13,77,27,23,67,51,1,13,3,43,3,64,4,47,8,0
Total5,7,6,91,2,9,15,9,86,3,11,2,6,32,6,1,02,5,8,21,1,9,62,2,4,23,7,8,91,1,8,5,71,2,1,6,21,5,2,7,32,7,4,3,5
Report Total5,7,6,91,2,9,15,9,86,3,11,2,6,32,6,1,02,5,8,21,1,9,62,2,4,23,7,8,91,1,8,5,71,2,1,6,21,5,2,7,32,7,4,3,5

&"Arial,Regular"&10 OVMCR-20B &"Arial,Regular"&10 Run Date Time: 12/8/2025 image3.jpg image4.jpg

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