Exhibit 51 - Cal Yr 2023 City of Miami CIGNA Claims by Benefits and ASO Fees Monthly Healthcare Experience by Benefit Option Rolling 12 BenOpt-1.xlsx
XLSX spreadsheet 19 KB Posted
- Attached to
- RFP No. 2130386 - Employee Health Benefits Plan
- Solicitation number
- RFP No. 2130386
- Issued by
- Florida
About this file
The document is a monthly healthcare experience report for the City of Miami's health benefits plan, covering the calendar year 2023 and prepared by CIGNA. The report details retrospective experience-rated claims and administrative services only (ASO) fees across multiple benefit options, including Network Open Access POS, Standalone Network POS, Out of Area Plan, and Vision plans. The data tracks monthly total paid claims, ASO fees, subscriber counts, and member enrollment from January through December 2023.
The report reveals consistent monthly claims ranging from approximately $2.8 million to $3.8 million, with total annual claims of $41,452,000 and total ASO fees of $885,891. The City of Miami's health plan enrollment remained relatively stable throughout the year, with total subscribers averaging around 5,640 and total members around 11,340 per month. The data is associated with a related Request for Proposals (RFP No. 2130386) for an Employee Health Benefits Plan in the state of Florida, suggesting this report may be part of the procurement documentation or performance evaluation for the current health benefits contract.
View the file
Other files
Show 40 more
Latest 50 of 114 listed here. See the rest on GovTribe.
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
Rllg12 Client BenOpt-1
| CITY OF MIAMI | |||||||||
| MONTHLY HEALTHCARE EXPERIENCE REPORT BY BENEFIT OPTION | |||||||||
| January 2023 thru December 2023 | |||||||||
| EXHIBIT 51 | |||||||||
| Rating Type : RETROSPECTIVE EXPERIENCE RATED | |||||||||
| Reported Premium: ASO Fees | |||||||||
| Reported Claims: All Claims | |||||||||
| YTD/MONTH | NPOS-NETWORK OPEN ACCESS POS (ALL EMPLOYEES) | NPOS2-STANDALONE NETWORK POS PLAN COPY NO RX | OOA-OUT OF AREA PLAN | OOA2-STANDALONE OUT OF AREA PLAN COPY NO RX | VIS-VISION FOR NETWORK PARTICIPANTS (BUNDLED | TOTAL PAID CLAIMS | TOTAL ASO FEES | TOTAL SUBS | TOTAL MBRS |
| Jan-23 | $2,995,492 | $46,066 | ($15) | $120 | $9,294 | $3,050,956 | $713 | 5,718 | 11,429 |
| Feb-23 | $3,407,877 | $62,254 | $0 | $8 | $8,030 | $3,478,169 | $80,507 | 5,677 | 11,334 |
| Mar-23 | $3,588,033 | $92,579 | $0 | $74 | $11,409 | $3,692,094 | $80,726 | 5,671 | 11,314 |
| Apr-23 | $2,881,663 | ($845) | $0 | $513 | $5,447 | $2,886,778 | $80,543 | 5,656 | 11,300 |
| May-23 | $3,729,456 | ($34,679) | $0 | $901 | $9,792 | $3,705,471 | $80,155 | 5,625 | 11,253 |
| Jun-23 | $3,137,795 | $36,534 | $81 | $391 | $6,449 | $3,181,250 | $80,262 | 5,632 | 11,286 |
| Jul-23 | $3,468,390 | $117,658 | $0 | $222 | $5,635 | $3,591,905 | $80,042 | 5,615 | 11,268 |
| Aug-23 | $3,832,763 | $56,794 | $0 | $28 | $9,987 | $3,899,572 | $80,298 | 5,635 | 11,319 |
| Sep-23 | $3,231,748 | $67,462 | ($6) | $233 | $15,044 | $3,314,480 | $80,334 | 5,638 | 11,343 |
| Oct-23 | $3,624,463 | $173,677 | $228 | $637 | $9,142 | $3,808,148 | $80,262 | 5,640 | 11,354 |
| Nov-23 | $3,114,468 | $88,104 | $70 | $170 | $4,931 | $3,207,743 | $80,951 | 5,651 | 11,350 |
| Dec-23 | $3,541,849 | $90,226 | $50 | $571 | $2,738 | $3,635,435 | $81,097 | 5,663 | 11,372 |
| Grand Total | $40,553,996 | $795,830 | $409 | $3,868 | $97,897 | $41,452,000 | $885,891 | 67,821 | 135,922 |
&G &7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law. ADVICE Reporting System &8Page &P of &N Date: 1/7/2024 image1.png
File details come from the government source that posted it. Updated .