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
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 Parameters | Values on Report | |
| Client Effective Date: 1/1/2016 | ||
| Incurred Date Range: 12/1/2023 to 11/30/2025 | 12/1/2023 to 11/1/2025 | |
| Client Renew Date: 1/1/2025 |
| Client ID: 336654 | |
| Client Policy Number: 0906435 |
City of Burleson
| Incurred | ||||||
| Month | Number of Subscribers | Number of Members | Collected Revenue | Incurred Claim | ||
| (Includes IBNR) | BCR | Claim Count | ||||
| (Includes IBNR) | Average Cost |
Per Incurred Claim
| 12/01/2023 | 3,4,0 | 7,4,8 | $3,9,9,7.08 | $3,5,0,5.42 | 87.7% | 3,6 | $9,7.37 |
| 01/01/2024 | 3,4,9 | 7,7,2 | $4,0,9,8.42 | $2,0,4,0.03 | 49.8% | 2,5 | $8,1.60 |
| 02/01/2024 | 3,4,5 | 7,7,2 | $4,0,7,7.36 | $1,6,0,1.43 | 39.3% | 1,8 | $8,8.97 |
| 03/01/2024 | 3,4,6 | 7,8,3 | $4,1,0,1.66 | $3,8,8,3.37 | 94.7% | 4,5 | $8,6.30 |
| 04/01/2024 | 3,4,6 | 7,7,6 | $4,0,7,6.28 | $1,6,6,8.71 | 40.9% | 2,1 | $7,9.46 |
| 05/01/2024 | 3,4,4 | 7,6,6 | $4,0,2,7.68 | $1,0,8,2.53 | 26.9% | 1,3 | $8,3.27 |
| 06/01/2024 | 3,4,1 | 7,5,9 | $3,9,9,7.08 | $2,0,0,6.76 | 50.2% | 2,4 | $8,3.62 |
| 07/01/2024 | 3,4,1 | 7,5,7 | $3,9,8,8.62 | $3,2,3,4.28 | 81.1% | 3,9 | $8,2.93 |
| 08/01/2024 | 3,4,2 | 7,6,4 | $4,0,2,1.38 | $2,6,1,9.91 | 65.1% | 3,1 | $8,4.51 |
| 09/01/2024 | 3,3,6 | 7,5,8 | $3,9,6,8.64 | $2,8,0,4.47 | 70.7% | 2,8 | $1,0,0.16 |
| 10/01/2024 | 3,3,5 | 7,5,7 | $3,9,6,1.26 | $1,8,6,3.89 | 47.1% | 2,5 | $7,4.56 |
| 11/01/2024 | 3,4,1 | 7,6,7 | $4,0,1,4.00 | $1,4,5,2.68 | 36.2% | 1,6 | $9,0.79 |
| 12/01/2024 | 3,3,9 | 7,6,5 | $3,9,9,9.24 | $4,3,8,4.46 | 109.6% | 4,8 | $9,1.25 |
| 01/01/2025 | 3,4,1 | 7,9,6 | $4,1,8,4.88 | $2,8,8,3.16 | 68.9% | 3,2 | $8,9.92 |
| 02/01/2025 | 3,4,1 | 7,8,7 | $4,1,6,7.52 | $4,3,0,1.12 | 103.2% | 4,5 | $9,5.39 |
| 03/01/2025 | 3,4,3 | 7,9,0 | $4,1,9,1.32 | $2,7,4,6.48 | 65.5% | 3,0 | $9,1.09 |
| 04/01/2025 | 3,4,5 | 8,0,3 | $4,2,4,8.72 | $2,3,2,6.18 | 54.8% | 2,3 | $1,0,0.73 |
| 05/01/2025 | 3,4,5 | 8,0,7 | $4,2,5,7.40 | $1,8,3,6.03 | 43.1% | 2,2 | $8,2.96 |
| 06/01/2025 | 3,3,6 | 7,7,9 | $4,1,4,5.96 | $2,8,4,4.14 | 68.6% | 3,0 | $9,4.05 |
| 07/01/2025 | 3,4,0 | 7,8,7 | $4,1,8,4.88 | $4,8,3,4.63 | 115.5% | 5,4 | $8,8.72 |
| 08/01/2025 | 3,3,7 | 7,7,7 | $4,1,4,4.84 | $2,2,0,0.47 | 53.1% | 2,7 | $8,0.36 |
| 09/01/2025 | 3,3,6 | 7,7,4 | $4,1,3,7.28 | $2,3,9,5.18 | 57.9% | 3,3 | $7,3.05 |
| 10/01/2025 | 3,4,1 | 8,0,0 | $4,2,1,8.48 | $2,6,9,1.78 | 63.8% | 3,6 | $7,3.91 |
| 11/01/2025 | 3,3,6 | 7,8,0 | $4,1,3,7.28 | $2,7,9,7.75 | 67.6% | 3,0 | $9,3.06 |
| 8,1,8,6 | 1,8,6,2,4 | $9,8,3,4,7.26 | $6,4,0,0,4.87 | 65.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 .