5-Appendix E - Enrollment Claims.xlsx
XLSX spreadsheet 12 KB Posted
- Solicitation number
- RFP-2025-710-HRM-CG
- Issued by
- Bernalillo County, Albuquerque City, New Mexico
About this file
This document is an Excel spreadsheet detailing monthly dental insurance claims and enrollment data for a City of New Mexico dental benefit program. The file covers a comprehensive historical and projected view of dental insurance metrics from July 2022 through May 2025, tracking monthly premiums, paid claims, dental loss ratios, subscriber counts, and total member populations. The related state and local contract opportunity indicates the City is seeking proposals for a fully insured dental benefit program for city employees and participating entities.
The spreadsheet reveals consistent monthly premiums ranging from approximately $409,000 to $470,424, with dental loss ratios fluctuating between 35.70% and 99% over the tracked period. Subscriber and member counts show gradual growth, increasing from around 6,614 subscribers and 15,412 members in July 2022 to a projected 7,065 subscribers and 15,692 members by May 2025. Notable variations include an unusual spike in November 2024 where paid claims exceeded premiums by 126.80%, and a significant drop in claims percentage in October 2024 to 35.70%. The data suggests potential volatility in dental insurance utilization and may be used to inform future contract negotiations and pricing strategies.
View the file
Other files
Show all 12
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
Sheet1
| Month | Premium | Dental Paid Claims | Dental Loss Ratio | Dental Subscribers | Dental Members |
| Jul-22 | $412,491 | $371,063 | 89.96% | 6,614 | 15,412 |
| Aug-22 | $413,201 | $405,412 | 98.11% | 6,640 | 15,436 |
| Sep-22 | $411,162 | $351,718 | 85.54% | 6,610 | 15,376 |
| Oct-22 | $409,522 | $333,399 | 81.41% | 6,573 | 15,280 |
| Nov-22 | $408,972 | $304,510 | 74.45% | 6,585 | 15,248 |
| Dec-22 | $409,653 | $359,223 | 87.69% | 6,602 | 15,271 |
| Jan-23 | $409,466 | $352,929 | 86.19% | 6,611 | 15,255 |
| Feb-23 | $410,537 | $342,595 | 83.45% | 6,641 | 15,295 |
| Mar-23 | $409,580 | $393,835 | 96.14% | 6,630 | 15,277 |
| Apr-23 | $409,635 | $321,341 | 78.46% | 6,638 | 15,243 |
| May-23 | $409,302 | $338,992 | 82.82% | 6,636 | 15,233 |
| Jun-23 | $410,053 | $383,045 | 93.41% | 6,661 | 15,245 |
| Jul-23 | $419,613 | $379,487 | 90% | 6,778 | 15,628 |
| Aug-23 | $421,386 | $419,920 | 99% | 6,826 | 15,671 |
| Sep-23 | $420,197 | $365,876 | 87.00% | 6,824 | 15,638 |
| Oct-23 | $420,653 | $369,765 | 87.00% | 6,818 | 15,630 |
| Nov-23 | $420,500 | $343,914 | 81.79% | 6,821 | 15,604 |
| Dec-23 | $422,173 | $328,443 | 77.80% | 6,864 | 15,659 |
| Jan-24 | $423,525 | $362,027 | 85.48% | 6,910 | 15,696 |
| Feb-24 | $457,619 | $320,260 | 69.90% | 6,927 | 15,676 |
| Mar-24 | $430,519 | $389,949 | 90.50% | 6,953 | 15,689 |
| Apr-24 | $417,355 | $397,041 | 95.10% | 6,972 | 15,716 |
| May-24 | $428,403 | $352,547 | 82.20% | 6,981 | 15,731 |
| Jun-24 | $470,424 | $380,148 | 80.80% | 6,966 | 15,680 |
| Jul-24 | $421,389 | $194,523 | 46.20% | 7,140 | 16,105 |
| Aug-24 | $421,181 | $307,160 | 72.90% | 7,136 | 16,083 |
| Sep-24 | $421,815 | $285,621 | 67.70% | 7,184 | 16,146 |
| Oct-24 | $418,432 | $149,505 | 35.70% | 7,106 | 15,989 |
| Nov-24 | $418,430 | $530,679 | 126.80% | 7,105 | 15,957 |
| Dec-24 | $417,214 | $318,192 | 76.30% | 7,098 | 15,904 |
| Jan-25 | $414,668 | $322,842 | 77.90% | 7,050 | 15,805 |
| Feb-25 | $414,946 | $332,344 | 80.10% | 7,041 | 15,757 |
| Mar-25 | $413,046 | $349,629 | 84.60% | 7,025 | 15,698 |
| Apr-25 | $411,640 | $341,442 | 82.90% | 7,025 | 15,662 |
| May-25 | $412,283 | $350,142 | 84.90% | 7,065 | 15,692 |
File details come from the government source that posted it. Updated .