11-D5 - City of Burleson 906435 - ODSCR-02B - Dental Experience ASO - Service 36Mo thru 2025-11.xlsx
XLSX spreadsheet 66 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 dental experience and utilization report for an Administrative Services Organization (ASO) client serving the City of Burleson, Texas, covering the 36-month period from December 1, 2022 through November 30, 2025. The report documents PPO plan performance metrics across the service term, tracking subscriber enrollment, dependent coverage, and total membership throughout the contract period.
The data reflects consistent membership levels, with subscribers ranging from approximately 3,990 to 4,190 and total members fluctuating between 8,460 and 9,340 across the 36-month span. Administrative fees remained relatively stable, averaging $1,693 per month, while incurred claims (including Incurred But Not Reported reserves) totaled $857,394 over the entire period, with monthly claims ranging from approximately $14,272 to $36,628. The cumulative totals show 14,722 total subscribers, 17,114 insured dependents, and 31,836 total members served, with aggregate administrative fees of $61,092 and aggregate incurred claims of $857,394. This utilization data provides historical baseline information relevant to the City of Burleson's upcoming RFP 2026-015 for dental and vision insurance benefits for eligible full-time employees, retirees, and dependents.
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
ODSCR-02B
Dental Client Experience and Utilization for ASO Client Effective Date: 1/1/2016
Client Renewal Month Year: 01/01
Client Policy Number: 0906435
| CITY OF BURLESON | |
| Business Category: ALL |
Service Date Range: 12/1/2022 to 11/1/2025
Business Category Incurred Month Subscribers Insured Dependents Members Administrative Fee Incurred Claim (Including IBNR)
| PPO | 12/01/2022 | 4,0,0 | 4,4,6 | 8,4,6 | $1,6,6,0 | $1,8,4,1,0 |
| PPO | 01/01/2023 | 3,9,9 | 4,5,6 | 8,5,5 | $1,6,5,6 | $1,5,5,0,5 |
| PPO | 02/01/2023 | 3,9,9 | 4,5,4 | 8,5,3 | $1,6,5,6 | $2,4,7,3,7 |
| PPO | 03/01/2023 | 4,0,2 | 4,5,5 | 8,5,7 | $1,6,6,8 | $2,5,2,0,3 |
| PPO | 04/01/2023 | 4,0,4 | 4,5,9 | 8,6,3 | $1,6,7,7 | $2,0,4,9,3 |
| PPO | 05/01/2023 | 4,0,8 | 4,6,1 | 8,6,9 | $1,6,9,3 | $1,4,2,7,2 |
| PPO | 06/01/2023 | 4,0,7 | 4,5,9 | 8,6,6 | $1,6,8,9 | $2,6,1,6,6 |
| PPO | 07/01/2023 | 4,0,7 | 4,6,0 | 8,6,7 | $1,6,8,9 | $1,8,4,1,2 |
| PPO | 08/01/2023 | 4,0,9 | 4,5,8 | 8,6,7 | $1,6,9,7 | $2,6,8,7,0 |
| PPO | 09/01/2023 | 4,0,8 | 4,5,6 | 8,6,4 | $1,6,9,3 | $1,9,9,9,5 |
| PPO | 10/01/2023 | 4,0,2 | 4,5,6 | 8,5,8 | $1,6,6,8 | $2,1,8,7,6 |
| PPO | 11/01/2023 | 4,0,4 | 4,5,8 | 8,6,2 | $1,6,7,7 | $1,6,9,4,8 |
| PPO | 12/01/2023 | 4,1,4 | 4,5,9 | 8,7,3 | $1,7,1,8 | $1,7,1,6,6 |
| PPO | 01/01/2024 | 4,1,9 | 4,7,1 | 8,9,0 | $1,7,3,5 | $2,7,7,9,2 |
| PPO | 02/01/2024 | 4,1,2 | 4,7,0 | 8,8,2 | $1,7,1,0 | $2,4,8,9,8 |
| PPO | 03/01/2024 | 4,1,6 | 4,8,0 | 8,9,6 | $1,7,2,6 | $2,2,8,0,4 |
| PPO | 04/01/2024 | 4,1,6 | 4,7,7 | 8,9,3 | $1,7,2,6 | $2,4,4,3,9 |
| PPO | 05/01/2024 | 4,1,5 | 4,6,9 | 8,8,4 | $1,7,2,2 | $2,3,0,3,9 |
| PPO | 06/01/2024 | 4,1,1 | 4,6,5 | 8,7,6 | $1,7,0,6 | $2,3,4,7,7 |
| PPO | 07/01/2024 | 4,0,9 | 4,6,2 | 8,7,1 | $1,6,9,7 | $2,6,7,0,9 |
| PPO | 08/01/2024 | 4,0,9 | 4,6,7 | 8,7,6 | $1,6,9,7 | $2,3,5,9,1 |
| PPO | 09/01/2024 | 4,0,8 | 4,6,8 | 8,7,6 | $1,6,9,3 | $2,2,9,0,3 |
| PPO | 10/01/2024 | 4,0,8 | 4,6,8 | 8,7,6 | $1,6,9,3 | $2,7,2,8,4 |
| PPO | 11/01/2024 | 4,0,8 | 4,6,8 | 8,7,6 | $1,6,9,3 | $2,1,4,1,6 |
| PPO | 12/01/2024 | 4,0,6 | 4,6,9 | 8,7,5 | $1,6,8,5 | $2,5,3,6,9 |
| PPO | 01/01/2025 | 4,1,1 | 5,1,5 | 9,2,6 | $1,7,0,6 | $3,6,6,2,8 |
| PPO | 02/01/2025 | 4,1,1 | 5,0,4 | 9,1,5 | $1,7,0,6 | $2,7,8,5,0 |
| PPO | 03/01/2025 | 4,1,3 | 5,0,5 | 9,1,8 | $1,7,1,4 | $2,1,4,6,3 |
| PPO | 04/01/2025 | 4,1,5 | 5,1,5 | 9,3,0 | $1,7,2,2 | $2,2,6,3,3 |
| PPO | 05/01/2025 | 4,1,6 | 5,1,8 | 9,3,4 | $1,7,2,6 | $2,5,7,4,4 |
| PPO | 06/01/2025 | 4,0,9 | 4,9,9 | 9,0,8 | $1,6,9,7 | $3,0,2,5,3 |
| PPO | 07/01/2025 | 4,1,2 | 5,0,3 | 9,1,5 | $1,7,1,0 | $3,2,6,6,6 |
| PPO | 08/01/2025 | 4,0,9 | 4,9,5 | 9,0,4 | $1,6,9,7 | $2,8,6,4,1 |
| PPO | 09/01/2025 | 4,0,8 | 4,9,1 | 8,9,9 | $1,6,9,3 | $2,6,5,6,3 |
| PPO | 10/01/2025 | 4,1,2 | 5,0,7 | 9,1,9 | $1,7,1,0 | $2,1,6,1,0 |
| PPO | 11/01/2025 | 4,0,6 | 4,9,1 | 8,9,7 | $1,6,8,5 | $2,3,5,7,1 |
| Client Total | 1,4,7,2,2 | 17114 | 3,1,8,3,6 | $6,1,0,9,2 | $8,5,7,3,9,4 |
&"Arial,Regular"&5&F &"-,Regular"12/8/2025 4:40:09 PM image3.jpg image4.png
File details come from the government source that posted it. Updated .