Technical Exhibit B - Historical Claims and Members CDRL.xlsx

XLSX spreadsheet 11 KB Posted

Attached to
MNG Medical, Dental, & Vision Insurance
Solicitation number
Not on record
Issued by

About this file

The file "Technical Exhibit B - Historical Claims and Members CDRL.xlsx" appears to be a spreadsheet containing historical insurance claims data for a medical, dental, and vision insurance contract. The document provides detailed monthly breakdown of insurance claims, including the number of lives insured, number of paid claims, and total amount of paid claims across different months (December through November). The spreadsheet also includes additional demographic information such as total number of lives, age ranges, family tiers, and number of employees. This data is likely part of the solicitation (MNG_medical_dental_vision_insurance_RFP) issued by the United States Army Contracting Command - Rock Island for medical, dental, and vision insurance services for Ministry of the National Guard (MNG) Students and their Dependents attending courses in the United States. The historical claims data would be crucial for potential bidders to understand the risk profile and claims history of the insurance program they are bidding to provide.

View the file

Other files

File Type Posted
W519TC25RA016 Amendment 0004.pdf PDF
Attachment 0004 - Section M 18 SEP 2025.pdf PDF
Attachment 0003 - Section L 18 SEP 2025.pdf PDF
Attachment 0002 - Pricing Matrix 17SEP2025 1.xlsx XLSX spreadsheet
Attachment 0011 - Section C (Seed Project) 18 SEP 2025.pdf PDF
W519TC25RA016 Amendment 0003.pdf PDF
Attachment 0009 - MNG Medical Insurance Q and A.xlsx XLSX spreadsheet
Attachment 0010 - Historical Members and Claims 2025.pdf PDF
W519TC25RA016 Amendment 0002.pdf PDF
Attachment 0009 - MNG Medical Insurance Q and A.xlsx XLSX spreadsheet
Attachment 0001 - PWS.pdf PDF
Technical Exhibit A - Monthly Additions and Deletions CDRL.xlsx XLSX spreadsheet
Attachment 0009 - MNG Medical Insurance Q and A.xlsx XLSX spreadsheet
Attachment 0002 - Pricing Matrix.xlsx XLSX spreadsheet
W519TC25RA016 Amendment 0001.pdf PDF
Attachment 0006- Historical Number of Members_Redacted.pdf PDF
Attachment 0004 - Section M.pdf PDF
Technical Exhibit A - CDRL.xlsx XLSX spreadsheet
Attachment 0007 - Current Policy_Redacted.pdf PDF
Attachment 0008 - Performance Assessment Questionnaire.docx DOCX document
Attachment 0005- Historical Claims.pdf PDF
Attachment 0002 - Pricing Matrix.xlsx XLSX spreadsheet
W519TC25RA016.pdf PDF
Attachment 0003 - Section L.pdf PDF
Attachment 0001 - PWS Medical Insurance Policy 02 June 2025.pdf PDF
Show all 25

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

Historical Claims

MonthNumber of Lives InsuredNumber of Paid ClaimsAmount of Paid Claims
December
January
February
March
April
May
June
July
August
October
November
Total

Historical Number of Lives

NumberAge RangeFamily Tier
Number of Employees:
Total Number of Lives:

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