Exhibit_8_Rate_Developt_Support_Early_Retirees_Employees.xlsx
XLSX spreadsheet 19 KB Posted
- Attached to
- OEIBA Program Commercial HMO, MSP, and MAPD Plans State and local contract opportunity
- Solicitation number
- EV00000681
- Issued by
- Oklahoma County, Hobart City, Oklahoma
About this file
This document is an Excel spreadsheet titled "Exhibit 8 Rate Development Supporting Data - Early Retiree Employees" for an unnamed supplier, covering rate development data for Oklahoma Early Retirees across three experience segments from January 2023 through March 2025. The exhibit provides a comprehensive template for tracking monthly and annual health insurance metrics, including premium receipts, medical and prescription paid claims, capitated claims, prescription rebates, subscriber and member coverage, admissions, inpatient days, and prescription details.
The spreadsheet is structured to capture detailed financial and utilization data across three distinct time periods: Experience Segment 1 (January 2023 through December 2023), Experience Segment 2 (January 2024 through December 2024), and Experience Segment 3 (January 2025 through March 2025). The document appears to be part of a rate development and insurance contract support process, specifically focused on early retiree employees in Oklahoma, with instructions indicating that this exhibit should reconcile with Exhibit 6 (Reports 6a and 6b). The file is marked as CONFIDENTIAL, suggesting sensitive financial and healthcare coverage information.
View the file
Other files for this state and local contract opportunity
Show all 49
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Exhibit 8 Exhibit 8 Rate Development Supporting Data - Early Retiree Employees [Supplier Name] Plan Year [Year] Instructions on providing the experience segments:
- Experience Segment 1: Provide requested information for the Oklahoma Early Retirees.
- This Exhibit and Exhibit 6: Reports 6a and 6b should reconcile.
| Experience Segment 1 - January 2023 through December 2023 | January | February | March | April | May | June | July | August | September | October | November | December | Total | |
| 1. | Total Premium Received (In Dollars) | |||||||||||||
| 2. | Total Medical Paid Claims non-capitated (In Dollars) | |||||||||||||
| 3. | Total Rx Paid Claims (In Dollars) | |||||||||||||
| 4. | Total Capitated Paid Claims (In Dollars) | |||||||||||||
| 5. | Total Rx Rebates (Client Specific in Dollars) | |||||||||||||
| 6. | Total Subscribers Covered | |||||||||||||
| 7. | Total Members Covered | |||||||||||||
| 8. | Total Admissions | |||||||||||||
| 9. | Total Inpatient Days | |||||||||||||
| 10. | Total Non-Specialty Prescriptions | |||||||||||||
| 11. | Total Specialty Prescriptions | |||||||||||||
| Experience Segment 2 - January 2024 through December 2024 | January | February | March | April | May | June | July | August | September | October | November | December | Total | |
| 1. | Total Premium Received (In Dollars) | |||||||||||||
| 2. | Total Medical Paid Claims non-capitated (In Dollars) | |||||||||||||
| 3. | Total Rx Paid Claims (In Dollars) | |||||||||||||
| 4. | Total Capitated Paid Claims (In Dollars) | |||||||||||||
| 5. | Total Rx Rebates (Client Specific in Dollars) | |||||||||||||
| 6. | Total Subscribers Covered | |||||||||||||
| 7. | Total Members Covered | |||||||||||||
| 8. | Total Admissions | |||||||||||||
| 9. | Total Inpatient Days | |||||||||||||
| 10. | Total Non-Specialty Prescriptions | |||||||||||||
| 11. | Total Specialty Prescriptions | |||||||||||||
| Experience Segment 3 - January 2025 through March 2025 | January | February | March | Total | ||||||||||
| 1. | Total Premium Received (In Dollars) | |||||||||||||
| 2. | Total Medical Paid Claims non-capitated (In Dollars) | |||||||||||||
| 3. | Total Rx Paid Claims (In Dollars) | |||||||||||||
| 4. | Total Capitated Paid Claims (In Dollars) | |||||||||||||
| 5. | Total Rx Rebates (Client Specific in Dollars) | |||||||||||||
| 6. | Total Subscribers Covered | |||||||||||||
| 7. | Total Members Covered | |||||||||||||
| 8. | Total Admissions | |||||||||||||
| 9. | Total Inpatient Days | |||||||||||||
| 10. | Total Non-Specialty Prescriptions | |||||||||||||
| 11. | Total Specialty Prescriptions |
CONFIDENTIAL
File details come from the government source that posted it. Updated .