Claims_Report_2017.xlsx
XLSX spreadsheet 15 KB Posted
- Attached to
- Health & Life Insurance Services
- Solicitation number
- SPM070-17-R-0001
About this file
Claims Report 2014-2017
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Amendment_A004.pdf | ||
| Claims_Report_2017_-_Chronic_Conditions.xlsx | XLSX spreadsheet | |
| HL_QA4_061417_final.docx | DOCX document | |
| Amendment_A003.pdf | ||
| HL_QA3_060217.docx | DOCX document | |
| Comparison_Chart_2012-2022.xlsx | XLSX spreadsheet | |
| Amendment_A002.pdf | ||
| Exhibit_E_List_of_Dependents.pdf | ||
| Exhibits_ABCD.pdf | ||
| Quick_Guide_for_Contract_Registrations_SAM.pdf | ||
| HL_QA2_060117.docx | DOCX document | |
| PreProposal_Minutes.pdf | ||
| Amendment_A001.pdf | ||
| Chart_agegroup_andgender_2017.xlsx | XLSX spreadsheet | |
| HL_QA1_051617.docx | DOCX document | |
| PremiumsvsClaims_2014_2017wretirees.xlsx | XLSX spreadsheet | |
| Sample_Report_2017.xlsx | XLSX spreadsheet | |
| Exhibits_ABCD.pdf | ||
| RFP_InvitationLetter.pdf | ||
| SF33_Cover_Page.pdf | ||
| HL_Solicitation_Final.pdf |
Show all 21
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
Employees
| EMBASSY OF THE UNITED STATES OF AMERICA, PANAMA |
| HEALTH |
| CLAIMS REPORT |
| Description | 2014-02 to 2015-01 | 2015-02 to 2016-01 | 2016-02 to 2017-01 | Total |
| # Claims | 1,311 | 1,812 | 1,612 | 4,735 |
| Claims ($) | 216,127.78 | 232,619.81 | 188,900.27 | 637,647.86 |
| # of Pregnancies | 5 | 6 | 0 | 11 |
| # Hospital Admissions | 20 | 24 | 14 | 58 |
| # Claims over $10,000 | 3 | 2 | 3 | 8 |
| Note: |
| The Embassy has obtained the following historical data from the current contractor but cannot certify as to whether this data will be indicative of future claims. Therefore, it is each offeror’s decision on whether or not to use this information. However, under no circumstances shall the U.S. Government be liable for this information or shall it become the basis for a request to adjust the premium rates once the contract is awarded. Rather, offerors are advised any adjustments to contract premium rates shall be in accordance with the Price Adjustment clauses (B.4 and B.8) of the contract. |
&"Times New Roman,Regular"Health and Life Solicitation
Retirees
| EMBASSY OF THE UNITED STATES OF AMERICA, PANAMA |
| HEALTH |
| CLAIMS REPORT |
| Description | 2014-02 to 2015-01 | 2015-02 to 2016-01 | 2016-02 to 2017-01 | Total |
| # Claims | 322 | 386 | 403 | 1,111 |
| Claims ($) | 94,966.18 | 122,647.35 | 92,835.45 | 310,448.98 |
| # of Pregnancies | 0 | 0 | 0 | 0 |
| # Hospital Admissions | 5 | 3 | 3 | 11 |
| # Claims over $10,000 | 2 | 1 | 2 | 5 |
| Note: |
| The Embassy has obtained the following historical data from the current contractor but cannot certify as to whether this data will be indicative of future claims. Therefore, it is each offeror’s decision on whether or not to use this information. However, under no circumstances shall the U.S. Government be liable for this information or shall it become the basis for a request to adjust the premium rates once the contract is awarded. Rather, offerors are advised any adjustments to contract premium rates shall be in accordance with the Price Adjustment clauses (B.4 and B.8) of the contract. |
&"Times New Roman,Regular"Health and Life Solicitation
File details come from the government source that posted it. Updated .