Exhibit_15_New_Supp_Aggregate_Utilization_Exp_.xlsx

XLSX spreadsheet 14 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 exhibit (Exhibit 15) for a healthcare services contract involving the state of Oklahoma, specifically detailing aggregate utilization and experience data for active and early retiree health plan participants for Plan Year 2026. The exhibit provides a comprehensive template for vendors to report detailed healthcare metrics across two distinct experience segments: one for Non-Value Based Networks and another for Value Based Networks, covering the period from April 2024 through March 2025. Vendors are instructed to provide statewide data covering 14 key performance indicators, including total premiums received, medical and prescription paid claims, subscriber and member coverage, age/sex factors, clinical utilization metrics, and provider network details.

The exhibit appears designed to collect standardized healthcare performance data to support procurement or contract evaluation processes, with a focus on capturing granular insights into network performance, claims experience, and healthcare utilization across different network models. By requesting anticipated or actual data, the state seems to be establishing a framework for comparing vendor capabilities, network effectiveness, and potential cost structures. The document is marked as confidential, suggesting it is part of a competitive solicitation or contract renewal process for Oklahoma's health benefits program, with an emphasis on gathering comprehensive, comparable data from potential healthcare service providers.

View the file

Other files for this state and local contract opportunity

Other files attached to OEIBA Program Commercial HMO, MSP, and MAPD Plans, newest first.
File Type Posted
Exhibit_22_Satisfaction_Surveys.xlsx XLSX spreadsheet
Exhibit_28_MAPD_File_and_Changes_Reports.xlsx XLSX spreadsheet
Exhibit_2_Geo-Access_Report.xlsx XLSX spreadsheet
Exhibit_35_HMO_Detailed_Utilization_Reports.xlsx XLSX spreadsheet
Exhibit_36_MAPD_Detailed_Utilization_Reports.xlsx XLSX spreadsheet
Exhibit_38_Advertising_Approval_Request_Form.docx DOCX document
VendorSecurityAssessment_(1).xlsx XLSX spreadsheet
OMES-FORM-CP-011-Amendment_2.pdf PDF
AttachmentB-NegotiableTerms.docx DOCX document
BID_PACKET_ATTACHMENTS_INSTRUCTIONS.pdf PDF
Exhibit_10_MAPD_Premium_Rate_and_LIS_Quote.docx DOCX document
Exhibit_13_MSP_Premium_Rate.docx DOCX document
Exhibit_20_Member_ID_Card_Example.xlsx XLSX spreadsheet
Exhibit_23_CAHPS_Survery_MAPD.xlsx XLSX spreadsheet
Exhibit_24_OEIBA_Program_Census_Information.xlsx XLSX spreadsheet
Exhibit_27_Minimum_Required_Reporting_List.docx DOCX document
Exhibit_29_Premium_Discrepancy_Reports.xlsx XLSX spreadsheet
Exhibit_33_Network_Changes_Summary.xlsx XLSX spreadsheet
Exhibit_34_Network_Detailed_Reports.xlsx XLSX spreadsheet
Exhibit_8_Rate_Developt_Support_Early_Retirees_Employees.xlsx XLSX spreadsheet
Exhibit_9_MAPD_Benefits_Summary.docx DOCX document
OMESFormCP004.pdf PDF
Attachment_E.docx DOCX document
Exhibit_11_MAPD_Rate_Setting.xlsx XLSX spreadsheet
Exhibit_14_Bid_Submission_Network_Detailed_Reports.xlsx XLSX spreadsheet
Exhibit_16_Large_Claims_Report_for_2023_and_2024.xlsx XLSX spreadsheet
Exhibit_17_Audited_Financial_Statements.xlsx XLSX spreadsheet
Exhibit_1_Standardized_Service_Areas.xlsx XLSX spreadsheet
Exhibit_31_HIPAA,_FWA,_and_Grievance_Reports.xlsx XLSX spreadsheet
Exhibit_32_HMO_Utilization_Reports.xlsx XLSX spreadsheet
Exhibit_37B_Individual_Employer_Experience_Reports.xlsx XLSX spreadsheet
Exhibit_3_Ratio_of_PCPs_to_Members.xlsx XLSX spreadsheet
Exhibit_7_Rate_Development_Supporting__Active_Employees.xlsx XLSX spreadsheet
Fillable_OMESFormCP076.pdf PDF
OMES-FORM-CP-011-Amendment_Q_A.pdf PDF
AttachmentD-ITTerms.pdf PDF
Attachment_A.pdf PDF
Bidder_Instructions.pdf PDF
Exhibit_12_MSP_Benefits_Summary.docx DOCX document
Exhibit_18_License(s).xlsx XLSX spreadsheet
Exhibit_19_Actuary_Certification.xlsx XLSX spreadsheet
Exhibit_21_Organizational_Chart_and_Brand_Logos.xlsx XLSX spreadsheet
Exhibit_25_Carrier_Eligibility_Companion_Guide.pdf PDF
Exhibit_26_OEIBB_Commercial_Carrier_Policy.pdf PDF
Exhibit_30_Member_Services_Reports.xlsx XLSX spreadsheet
Exhibit_37A_Individual_Emp_Experience_Reports_Instructions.docx DOCX document
Exhibit_4_HMO_Plan_Design.docx DOCX document
Exhibit_5_HMO_Premium_Quote.docx DOCX document
Exhibit_6_HMO_Rate_Development.xlsx XLSX spreadsheet
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 15

Exhibit 15
New Vendor Only- Aggregate Utilization/Experience Data- Actives & Early Retirees
Plan Year 2026
Instructions on providing the experience segments:

- Experience Segment 1: Provide requested information for the Oklahoma Book of Business on Non-Value Based Networks

- Experience Segment 2: Provide requested information for the Oklahoma Book of Business on Value Based Networks Note: In absence of actual data, please provide anticipated/expected information

Experience Segment 1 - April 2024 through March 2025Statewide
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.Age/Sex Factor
9.Total Admissions
10.Total Inpatient Days
11.Total Prescriptions
12.Total Primary Care Providers
13.Total Specialists
14.Total Hospitals
Experience Segment 2 - April 2024 through March 2025Statewide
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.Age/Sex Factor
9.Total Admissions
10.Total Inpatient Days
11.Total Prescriptions
12.Total Primary Care Providers
13.Total Specialists
14.Total Hospitals
CONFIDENTIAL

File details come from the government source that posted it. Updated .