Attachment O – Medical Claim Repricing File for Discount and Disruption Analysis.xlsx

XLSX spreadsheet 3 MB Posted

Attached to
RFP 26-025-CJ GCPS- Employee Medical, Stop Loss, Dental, Vision, Disability & Voluntary Benefits Coverage
Solicitation number
RFP-115259
Issued by
Frederick County, Virginia

About this file

Summary

This is a Medical Claim Repricing File for Discount and Disruption Analysis, a data submission document used for evaluating medical claim pricing and cost management strategies. The file is an Excel spreadsheet designed to organize and analyze medical claim information across state and local healthcare contracting entities. The document serves as a supporting exhibit for procurement opportunities related to health plan administration, claims processing, and pharmacy benefit management services. The file contains structured data fields for claim-level information necessary to assess repricing methodologies, discount structures, and potential service disruptions that may impact healthcare delivery and costs.

The spreadsheet is formatted to accommodate detailed claim records including pricing variables, discount applications, and disruption factors relevant to claims analysis and rate-setting evaluations. This type of file typically supports competitive bidding processes where vendors must demonstrate their ability to achieve specific cost savings, maintain service quality, and manage claims efficiently. The data submission requirements ensure that bidders understand the volume, complexity, and pricing expectations associated with the contract opportunity, enabling accurate proposal development and cost estimation for state and local health plan administration services.

View the file

Other files

File Type Posted
Addendum 1.pdf PDF
external extract for gloucester co.xlsx XLSX spreadsheet
Attachment T – Vision Top Providers for Disruption Analysis.xlsx XLSX spreadsheet
Attachment M – Long Term Disability Claims History.xlsx XLSX spreadsheet
Attachment 2A. HCCs Sept 2023 - Oct 2024-GLOUCESTER COUNTY SCHOOL BOARD(Total Account)_HCC-01_20260318 03_32 PM.xlsx XLSX spreadsheet
Attachment 3 Retiree Dental GCPS Addendum Question.xlsx XLSX spreadsheet
Addendum 3 FINAL.pdf PDF
Attachment 2B. HCCs Oct 2024 - Sept 2025-GLOUCESTER COUNTY SCHOOL BOARD(Total Account)_HCC-01_20260318 03_31 PM.xlsx XLSX spreadsheet
Addendum 1.pdf PDF
Attachment V - Hybrid STD Benefit Summary.pdf PDF
external extract for gloucester co.xlsx XLSX spreadsheet
Attachment L – Disability Benefits.pdf PDF
Attachment S – Dental Network Utilization for Disruption Analysis .xlsx XLSX spreadsheet
Gloucester County Repricing Summary 02032026 file.xlsx XLSX spreadsheet
Addendum 2.pdf PDF
Attachment 2C. HCCs Oct 2025 - Feb 2026-GLOUCESTER COUNTY SCHOOL BOARD(Total Account)_HCC-01_20260318 03_29 PM.xlsx XLSX spreadsheet
Attachment D – Current census and enrollment for all lines of coverage (including COBRA and Retirees).xlsx XLSX spreadsheet
Attachment J – Dental Claims and enrollment history.xlsx XLSX spreadsheet
Attachment 2. HCCS over 50k Feb 2024 - Jan 2025-GLOUCESTER COUNTY SCHOOL BOARD(Total Account)_HCC-01_20260317 03_43 PM.pdf PDF
Attachment H – Vision Benefits.pdf PDF
Attachment B - Price Proposal.xlsx XLSX spreadsheet
Attachment R – Current and Historical Rates - All Lines.pdf PDF
Attachment W - Hybrid LTD Benefit Summary.pdf PDF
Attachment Q – Pharmacy Questionnaire.docx DOCX document
1B Member and claims oct 2025- Feb 2026.xlsx XLSX spreadsheet
Attachment 1. Mem and Claims Oct 2023 - Sept 2024-GLOUCESTER COUNTY SCHOOL BOARD(Total Account)_FIN-01_20260317 03_29 PM (2).xlsx XLSX spreadsheet
Attachment K – Vision Claims and enrollment history.pdf PDF
Attachment U - Supplemental Plan Claims Utilization.pdf PDF
Attachment 1A. Mem and Claims Oct 2024 - Sept 2025-GLOUCESTER COUNTY SCHOOL BOARD(Total Account)_FIN-01_20260317 03_28 PM.xlsx XLSX spreadsheet
Attachment P – Pharmacy Claim Repricing & Disruption Analysis - DELETE YELLOW ONCE APPROVED.xlsx XLSX spreadsheet
Gloucester County Repricing Cover Letter 02032026.docx DOCX document
Attachment N – Accident, Critical Illness, Hospital Benefits.pdf PDF
Attachment I – Medical Claims, Enrollment, HCCs.xlsx XLSX spreadsheet
Show all 33

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

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