20-V2 - City of Burleson 906435 - OVMCR-01A - Vision Experience FI - Service 24Mo thru 2025-11.xlsx

XLSX spreadsheet 94 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 document is a Vision Client Experience and Utilization report for the City of Burleson's fully insured vision plan (Client ID: 336654, Policy Number: 0906435), covering the period from December 1, 2023, through November 30, 2025. The report tracks monthly performance metrics for vision insurance benefits provided to city employees and dependents. Over the 24-month service period, the plan served an average of 3,408 subscribers and 7,743 members, with collected revenue totaling $983,472.26 against incurred claims of $640,004.87. The plan maintained a blended benefit-cost ratio of 65.1% throughout the contract term, with claim counts totaling 733 incidents and an average cost per incurred claim of $87.32.

Monthly performance data reveals fluctuating claim patterns and utilization rates across the contract period. Incurred claims ranged from a low of $1,082.53 in May 2024 to a high of $4,834.63 in July 2025, with benefit-cost ratios varying from 26.9% to 115.5%. Revenue remained relatively stable, ranging between $3,961.26 and $4,257.40 monthly, while member counts grew slightly from 748 in December 2023 to 780 by November 2025, reflecting modest enrollment increases. The data demonstrates consistent plan utilization across the two-year contract period, with average monthly claims representing approximately 65% of collected premiums, indicating stable claims experience and predictable plan costs for the City of Burleson's vision insurance program.

View the file

Other files

File Type Posted
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
23-V5 - City of Burleson 906435 - OVMCR-20B - Vision Membership by Tier Product - Membership 36Mo thru 2025-11.xlsx XLSX spreadsheet
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

Vision Client Experience and Ut

Vision Client Experience and Utilization for Fully Insured

Selection ParametersValues on Report
Client Effective Date: 1/1/2016
Incurred Date Range: 12/1/2023 to 11/30/202512/1/2023 to 11/1/2025
Client Renew Date: 1/1/2025
Client ID: 336654
Client Policy Number: 0906435

City of Burleson

Incurred
MonthNumber of SubscribersNumber of MembersCollected RevenueIncurred Claim
(Includes IBNR)BCRClaim Count
(Includes IBNR)Average Cost

Per Incurred Claim

12/01/20233,4,07,4,8$3,9,9,7.08$3,5,0,5.4287.7%3,6$9,7.37
01/01/20243,4,97,7,2$4,0,9,8.42$2,0,4,0.0349.8%2,5$8,1.60
02/01/20243,4,57,7,2$4,0,7,7.36$1,6,0,1.4339.3%1,8$8,8.97
03/01/20243,4,67,8,3$4,1,0,1.66$3,8,8,3.3794.7%4,5$8,6.30
04/01/20243,4,67,7,6$4,0,7,6.28$1,6,6,8.7140.9%2,1$7,9.46
05/01/20243,4,47,6,6$4,0,2,7.68$1,0,8,2.5326.9%1,3$8,3.27
06/01/20243,4,17,5,9$3,9,9,7.08$2,0,0,6.7650.2%2,4$8,3.62
07/01/20243,4,17,5,7$3,9,8,8.62$3,2,3,4.2881.1%3,9$8,2.93
08/01/20243,4,27,6,4$4,0,2,1.38$2,6,1,9.9165.1%3,1$8,4.51
09/01/20243,3,67,5,8$3,9,6,8.64$2,8,0,4.4770.7%2,8$1,0,0.16
10/01/20243,3,57,5,7$3,9,6,1.26$1,8,6,3.8947.1%2,5$7,4.56
11/01/20243,4,17,6,7$4,0,1,4.00$1,4,5,2.6836.2%1,6$9,0.79
12/01/20243,3,97,6,5$3,9,9,9.24$4,3,8,4.46109.6%4,8$9,1.25
01/01/20253,4,17,9,6$4,1,8,4.88$2,8,8,3.1668.9%3,2$8,9.92
02/01/20253,4,17,8,7$4,1,6,7.52$4,3,0,1.12103.2%4,5$9,5.39
03/01/20253,4,37,9,0$4,1,9,1.32$2,7,4,6.4865.5%3,0$9,1.09
04/01/20253,4,58,0,3$4,2,4,8.72$2,3,2,6.1854.8%2,3$1,0,0.73
05/01/20253,4,58,0,7$4,2,5,7.40$1,8,3,6.0343.1%2,2$8,2.96
06/01/20253,3,67,7,9$4,1,4,5.96$2,8,4,4.1468.6%3,0$9,4.05
07/01/20253,4,07,8,7$4,1,8,4.88$4,8,3,4.63115.5%5,4$8,8.72
08/01/20253,3,77,7,7$4,1,4,4.84$2,2,0,0.4753.1%2,7$8,0.36
09/01/20253,3,67,7,4$4,1,3,7.28$2,3,9,5.1857.9%3,3$7,3.05
10/01/20253,4,18,0,0$4,2,1,8.48$2,6,9,1.7863.8%3,6$7,3.91
11/01/20253,3,67,8,0$4,1,3,7.28$2,7,9,7.7567.6%3,0$9,3.06
8,1,8,61,8,6,2,4$9,8,3,4,7.26$6,4,0,0,4.8765.1%7,3,3$8,7.32

&"Arial,Regular"&5&F &"-,Regular"12/8/2025 4:42:29 PM image3.jpg image4.jpg

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