Attachment_C-Prvoyance_Pricing.xlsx
XLSX spreadsheet 29 KB Posted
- Solicitation number
- SFR63016R0011
- Issued by
-
Department of State US Embassy Paris
About this file
RFP Health Insurance
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment_F_-_Statistic_Report_of_Incumbent_Contractor-PREVOYANCE.pdf | ||
| Attachment_A-Medical_Pricing-Categories_A_and_B.xlsx | XLSX spreadsheet | |
| Attachment_E-Staff_Statistics_-_Unclassified_Information.xls | XLS spreadsheet | |
| Attachment_F_-_Statistic_Report_of_Incumbent_Contractor-HEALTH.pdf | ||
| Attachment_B-1_Medical_Coverage_-_Social_Security_with_English_translation.xlsx | XLSX spreadsheet | |
| Attachment_B-2_Medical_Coverage_-_CSR_with_English_Translation.xlsx | XLSX spreadsheet | |
| Attachment_A-1-Medical_Pricing-Categories_C_and_D.xlsx | XLSX spreadsheet | |
| RFP_Health_Insurance-Final.docx | DOCX document | |
| Attachment_D-Prvoyance_Coverages_-_SS_and_CSR_w_Translation.xlsx | XLSX spreadsheet |
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
C Prévoyance Prices-Base
| ATTACHMENT C - PRICES/CONTRIBUTIONS FOR PREVOYANCE (DEATH & DISABILITY) | ||||||||||||||
| CLIN | Current Members | Contribution | Total Contribution for one contract Year | Retention Amount per Year* | Total Amount for one contract year | |||||||||
| Daily rate (Indemnités Journalières en cas de d'incapacité/invalidité) | Permanent and partial Disability (Invalidité permanente partielle et invalidité permanente totale) | Death (Décès) | ||||||||||||
| Category A - Employees Affiliated to French Social Security | ||||||||||||||
| Total amount of Tranche A per Year, € | Total amount of Tranche B per Year, € | % of ____ | Amount | Flat Rate / Month | % of ____ | Amount | % of ____ | Amount | € | € | € | |||
| Basic Option-Employees affiliated to Social Security | ||||||||||||||
| PASS ceiling 2017 in € | 39,228 | |||||||||||||
| P001 | Non-cadres | 150 | 5,291,058 | 362,867 | Not | |||||||||
| P002 | Cadres | 161 | 6,315,708 | 2,962,367 | Applicable |
High Option-Employees affiliated to Social Security
| P003 | Non-cadres | 40 | 1,464,599 | 92,977 | Not |
| P004 | Cadres | 43 | 1,686,804 | 1,005,677 | Applicable |
Category B - Employees Non-Affiliated to French Social Security
Basic Option-Employees non-affiliated to Social Security
| P005 | Non-cadres | 0 | 0 | 0 | Not |
| P006 | Cadres | 1 | 39,228 | 46,413 | Applicable |
High Option-Employees non-affiliated to Social Security
P007 Non-cadres 0 0 0
P008 Cadres 1 39,228 33,245
B.3.1 Base Year- Estimated Grand Total
* Retention amount shall remain unchanged throughout the whole period of contract. Offeror shall enter a value not a percentage
Solicitation: S-FR630-17-R-0013 Attachement C - Base Year Page: &P of & 1
C Prévoyance Prices-Opt Yr 1
| ATTACHMENT C - PRICES/CONTRIBUTIONS FOR PREVOYANCE (DEATH & DISABILITY) | ||||||||||||||
| CLIN | Current Members | Contribution | Total Contribution for one contract Year | Retention Amount per Year | Total Amount for one contract year | |||||||||
| Daily rate (Indemnités Journalières en cas de d'incapacité/invalidité) | Permanent and partial Disability (Invalidité permanente partielle et invalidité permanente totale) | Death (Décès) | ||||||||||||
| Category A - Employees Affiliated to French Social Security | ||||||||||||||
| Total amount of Tranche A per Year, € | Total amount of Tranche B per Year, € | % of ____ | Amount | Flat Rate / Month | % of ____ | Amount | % of ____ | Amount | € | € | € | |||
| Basic Option-Employees affiliated to Social Security | ||||||||||||||
| Taux 2011 | Taux 2011 | |||||||||||||
| P001 | Non-cadres | 150 | 5,291,058 | 362,867 | Not | |||||||||
| P002 | Cadres | 161 | 6,315,708 | 2,962,367 | Applicable |
High Option-Employees affiliated to Social Security
| P003 | Non-cadres | 40 | 1,464,599 | 92,977 | Not |
| P004 | Cadres | 43 | 1,686,804 | 1,005,677 | Applicable |
Category B - Employees Non-Affiliated to French Social Security
Basic Option-Employees non-affiliated to Social Security
| P005 | Non-cadres | 0 | 0 | 0 | Not |
| P006 | Cadres | 1 | 39,228 | 46,413 | Applicable |
High Option-Employees non-affiliated to Social Security
| P007 | Non-cadres | 0 | 0 | 0 |
| P008 | Cadres | 1 | 39,228 | 33,245 |
B.3.2 First Option Year- Estimated Grand Total
* Retention amount shall remain unchanged throughout the whole period of contract. Offeror shall enter a value not a percentage
Solicitation: S-FR630-17-R-0013 Attachement C - Option Year 1 Page: &P of & 1
C Prévoyance Prices-Opt Yr 2
| ATTACHMENT C - PRICES/CONTRIBUTIONS FOR PREVOYANCE (DEATH & DISABILITY) | ||||||||||||||
| CLIN | Current Members | Contribution | Total Contribution for one contract Year | Retention Amount per Year | Total Amount for one contract year | |||||||||
| Daily rate (Indemnités Journalières en cas de d'incapacité/invalidité) | Permanent and partial Disability (Invalidité permanente partielle et invalidité permanente totale) | Death (Décès) | ||||||||||||
| Category A - Employees Affiliated to French Social Security | ||||||||||||||
| Total amount of Tranche A per Year, € | Total amount of Tranche B per Year, € | % of ____ | Amount | Flat Rate / Month | % of ____ | Amount | % of ____ | Amount | € | € | € | |||
| Basic Option-Employees affiliated to Social Security | ||||||||||||||
| Taux 2011 | Taux 2011 | |||||||||||||
| P001 | Non-cadres | 150 | 5,291,058 | 362,867 | Not | |||||||||
| P002 | Cadres | 161 | 6,315,708 | 2,962,367 | Applicable |
High Option-Employees affiliated to Social Security
| P003 | Non-cadres | 40 | 1,464,599 | 92,977 | Not |
| P004 | Cadres | 43 | 1,686,804 | 1,005,677 | Applicable |
Category B - Employees Non-Affiliated to French Social Security
Basic Option-Employees non-affiliated to Social Security
| P005 | Non-cadres | 0 | 0 | 0 | Not |
| P006 | Cadres | 1 | 39,228 | 46,413 | Applicable |
High Option-Employees non-affiliated to Social Security
| P007 | Non-cadres | 0 | 0 | 0 |
| P008 | Cadres | 1 | 39,228 | 33,245 |
B.3.3 Second Option Year- Estimated Grand Total
* Retention amount shall remain unchanged throughout the whole period of contract. Offeror shall enter a value not a percentage
Solicitation: S-FR630-17-R-0013 Attachement C - Option Year 2 Page: &P of & 1
C Prévoyance Prices-Opt Yr 3
| ATTACHMENT C - PRICES/CONTRIBUTIONS FOR PREVOYANCE (DEATH & DISABILITY) | ||||||||||||||
| CLIN | Current Members | Contribution | Total Contribution for one contract Year | Retention Amount per Year | Total Amount for one contract year | |||||||||
| Daily rate (Indemnités Journalières en cas de d'incapacité/invalidité) | Permanent and partial Disability (Invalidité permanente partielle et invalidité permanente totale) | Death (Décès) | ||||||||||||
| Category A - Employees Affiliated to French Social Security | ||||||||||||||
| Total amount of Tranche A per Year, € | Total amount of Tranche B per Year, € | % of ____ | Amount | Flat Rate / Month | % of ____ | Amount | % of ____ | Amount | € | € | € | |||
| Basic Option-Employees affiliated to Social Security | ||||||||||||||
| Taux 2011 | Taux 2011 | |||||||||||||
| P001 | Non-cadres | 150 | 5,291,058 | 362,867 | Not | |||||||||
| P002 | Cadres | 161 | 6,315,708 | 2,962,367 | Applicable |
High Option-Employees affiliated to Social Security
| P003 | Non-cadres | 40 | 1,464,599 | 92,977 | Not |
| P004 | Cadres | 43 | 1,686,804 | 1,005,677 | Applicable |
Category B - Employees Non-Affiliated to French Social Security
Basic Option-Employees non-affiliated to Social Security
| P005 | Non-cadres | 0 | 0 | 0 | Not |
| P006 | Cadres | 1 | 39,228 | 46,413 | Applicable |
High Option-Employees non-affiliated to Social Security
| P007 | Non-cadres | 0 | 0 | 0 |
| P008 | Cadres | 1 | 39,228 | 33,245 |
B.3.4 Third Option Year- Estimated Grand Total
* Retention amount shall remain unchanged throughout the whole period of contract. Offeror shall enter a value not a percentage
Solicitation: S-FR630-17-R-0013 Attachement C - Option Year 3 Page: &P of & 1
C Prévoyance Prices-Opt Yr 4
| ATTACHMENT C - PRICES/CONTRIBUTIONS FOR PREVOYANCE (DEATH & DISABILITY) | ||||||||||||||
| CLIN | Current Members | Contribution | Total Contribution for one contract Year | Retention Amount per Year | Total Amount for one contract year | |||||||||
| Daily rate (Indemnités Journalières en cas de d'incapacité/invalidité) | Permanent and partial Disability (Invalidité permanente partielle et invalidité permanente totale) | Death (Décès) | ||||||||||||
| Category A - Employees Affiliated to French Social Security | ||||||||||||||
| Total amount of Tranche A per Year, € | Total amount of Tranche B per Year, € | % of ____ | Amount | Flat Rate / Month | % of ____ | Amount | % of ____ | Amount | € | € | € | |||
| Basic Option-Employees affiliated to Social Security | ||||||||||||||
| Taux 2011 | Taux 2011 | |||||||||||||
| P001 | Non-cadres | 150 | 5,291,058 | 362,867 | Not | |||||||||
| P002 | Cadres | 161 | 6,315,708 | 2,962,367 | Applicable |
High Option-Employees affiliated to Social Security
| P003 | Non-cadres | 40 | 1,464,599 | 92,977 | Not |
| P004 | Cadres | 43 | 1,686,804 | 1,005,677 | Applicable |
Category B - Employees Non-Affiliated to French Social Security
Basic Option-Employees non-affiliated to Social Security
| P005 | Non-cadres | 0 | 0 | 0 | Not |
| P006 | Cadres | 1 | 39,228 | 46,413 | Applicable |
High Option-Employees non-affiliated to Social Security
| P007 | Non-cadres | 0 | 0 | 0 |
| P008 | Cadres | 1 | 39,228 | 33,245 |
| B.3.5 | Fourth Option Year- Estimated Grand Total |
| * Retention amount shall remain unchanged throughout the whole period of contract. Offeror shall enter a value not a percentage | |
| B.3.6 | Base + Four Option Years- Estimated Grand Total |
| B.3. 7 GRAND ESTIMATED TOTAL FOR MEDICAL (B.2.2.6) AND PREVOYANCE (B.3.6) FOR A 5 YEAR CONTRACT PERIOD |
Solicitation: S-FR630-17-R-0013 Attachement C - Option Year 4 Page: &P of & 1
File details come from the government source that posted it. Updated .