Attachment A-Medical Pricing-Categories A and B.xlsx
XLSX spreadsheet 36 KB Posted
- Solicitation number
- 19FR6325R0003
- Issued by
-
Department of State US Embassy Paris
About this file
This Excel file is a pricing attachment (Attachment A) for a medical insurance contract for the U.S. Mission in France, detailing premium categories and member estimations across multiple contract years. The document breaks down medical coverage pricing into two primary categories: Category A for employees affiliated with French Social Security and Category B for employees not affiliated with French Social Security, with further subdivisions for basic and high insurance options.
The pricing structure covers different membership types including employees, spouses, and children, with specific line items for various social security regimes (standard French Social Security and Alsace Social Security). The contract spans a base year with four one-year option periods, and while specific premium amounts are not clearly displayed (many cells show ERROR:#REF!), the document provides detailed member count estimates. The solicitation (19FR6325R0003) is issued by the U.S. Embassy in Paris and seeks to provide supplemental health insurance for locally employed staff, former employees, retirees, and their eligible dependents, with contributions for spouses and children to be paid separately from the main contract.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| SF30-Amendment 0001- RFP 19FR6325R0003 Final 6.27.2025.pdf | ||
| solicitation ref. 19FR6325R0003.pdf | ||
| Attachment C - Statistics Health and Life Insurance.pdf | ||
| Attachment A-1 Medical Pricing-Categories C and D.xlsx | XLSX spreadsheet | |
| Solicitation letter.pdf | ||
| Attachment B Pricing Spreadsheet.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
A Health Prices Base Year
| CLIN | |||||
| CLIN | Current Members of the U.S. Mission | Estimated Members of the U.S. Mission + spouses and children | Premium per Month & per Member, € | Total Amount for twelve months, € | AG2R Category |
Category A - Employees Affiliated to French Social Security
A-1 Basic Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Base) Empl-PP USG-PP
| 1001 | Employees | 378 | 378 | € - 0 | AB1 | ERROR:#REF! | ERROR:#REF! |
| 1002 | Spouses* | 54 | 76 | € - 0 | AB5 | ||
| 1003 | Children* | 123 | 123 | € - 0 |
A-2 High Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Haute)
| 2001 | Employees | 189 | 178 | € - 0 | AH1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| 2002 | Spouses* | 30 | 30 | € - 0 | ||||
| 2003 | Children* | 65 | 65 | € - 0 |
A-3 Basic Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Base)
| 3001 | Employees | 5 | 5 | € - 0 | AB2 | ERROR:#REF! | ERROR:#REF! |
| 3002 | Spouses* | 0 | 1 | € - 0 | |||
| 3003 | Children* | 0 | 1 | € - 0 |
A-4 High Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Haute)
| 4001 | Employees | 4 | 4 | € - 0 | AH2 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| 4002 | Spouses* | 0 | 1 | € - 0 | ||||
| 4003 | Children* | 0 | 1 | € - 0 |
Category B - Employees Not-Affiliated to French Social Security
B-1 Basic Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Base)
| 5001 | Employees | 1 | 1 | € - 0 | AB3 | ERROR:#REF! |
| 5002 | Spouses* | 0 | 0 | € - 0 | AB4 | |
| 5003 | Children* | 0 | 0 | € - 0 | ERROR:#REF! |
B-2 High Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Haute)
| 6001 | Employees (Cadres et Non-cadres) | 0 | 0 | € - 0 | AH3 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| 6002 | Spouses* | 0 | 0 | € - 0 | AH4 | |||
| 6003 | Children* | 0 | 0 | € - 0 | ERROR:#REF! |
B.2.2.1 Total estimated amount for twelve months of Medical Coverage for Employees only € - 0
* Spouses and children are benefitting from the contract prices but contributions are paid separately from the contract and are not included in the above total estimated amount
Solicitation ref. 19FR6325R0003
Attachment A - PRICES/PREMIUMS FOR MEDICAL CONTRACT LINE ITEMS OF CATEGORIES A & B Page: &P of &N
A Health Prices Option Year 1
| ATTACHMENT A - PRICES/PREMIUMS FOR MEDICAL COVERAGE | |||||
| CLIN | Current Members of the U.S. Mission | Estimated Members of the U.S. Mission + spouses and children | Premium per Month & per Member, € | Total Amount for twelve months, € | AG2R Category |
Category A - Employees Affiliated to French Social Security
A-1 Basic Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Base) Empl-PP USG-PP
| 1001 | Employees | 378 | 378 | € - 0 | AB1 | ERROR:#REF! | ERROR:#REF! |
| 1002 | Spouses* | 54 | 76 | € - 0 | AB5 | ||
| 1003 | Children* | 123 | 123 | € - 0 |
A-2 High Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Haute)
| 2001 | Employees | 189 | 178 | € - 0 | AH1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| 2002 | Spouses* | 30 | 30 | € - 0 | ||||
| 2003 | Children* | 65 | 65 | € - 0 |
A-3 Basic Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Base)
| 3001 | Employees | 5 | 5 | € - 0 | AB2 | ERROR:#REF! | ERROR:#REF! |
| 3002 | Spouses* | 0 | 1 | € - 0 | |||
| 3003 | Children* | 0 | 1 | € - 0 |
A-4 High Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Haute)
| 4001 | Employees | 4 | 4 | € - 0 | AH2 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| 4002 | Spouses* | 0 | 1 | € - 0 | ||||
| 4003 | Children* | 0 | 1 | € - 0 |
Category B - Employees Not-Affiliated to French Social Security
B-1 Basic Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Base)
| 5001 | Employees | 1 | 1 | € - 0 | AB3 | ERROR:#REF! |
| 5002 | Spouses* | 0 | 0 | € - 0 | AB4 | |
| 5003 | Children* | 0 | 0 | € - 0 | ERROR:#REF! |
B-2 High Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Haute)
| 6001 | Employees (Cadres et Non-cadres) | 0 | 0 | € - 0 | AH3 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| 6002 | Spouses* | 0 | 0 | € - 0 | AH4 | |||
| 6003 | Children* | 0 | 0 | € - 0 | ERROR:#REF! |
B.2.2.1 Total estimated amount for twelve months of Medical Coverage for Employees only € - 0
* Spouses and children are benefitting from the contract prices but contributions are paid separately from the contract and are not included in the above total estimated amount
A Health Prices Option Year 2
| ATTACHMENT A - PRICES/PREMIUMS FOR MEDICAL COVERAGE | |||||
| CLIN | Current Members of the U.S. Mission | Estimated Members of the U.S. Mission + spouses and children | Premium per Month & per Member, € | Total Amount for twelve months, € | AG2R Category |
Category A - Employees Affiliated to French Social Security
A-1 Basic Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Base) Empl-PP USG-PP
| 1001 | Employees | 378 | 378 | € - 0 | AB1 | ERROR:#REF! | ERROR:#REF! |
| 1002 | Spouses* | 54 | 76 | € - 0 | AB5 | ||
| 1003 | Children* | 123 | 123 | € - 0 |
A-2 High Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Haute)
| 2001 | Employees | 189 | 178 | € - 0 | AH1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| 2002 | Spouses* | 30 | 30 | € - 0 | ||||
| 2003 | Children* | 65 | 65 | € - 0 |
A-3 Basic Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Base)
| 3001 | Employees | 5 | 5 | € - 0 | AB2 | ERROR:#REF! | ERROR:#REF! |
| 3002 | Spouses* | 0 | 1 | € - 0 | |||
| 3003 | Children* | 0 | 1 | € - 0 |
A-4 High Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Haute)
| 4001 | Employees | 4 | 4 | € - 0 | AH2 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| 4002 | Spouses* | 0 | 1 | € - 0 | ||||
| 4003 | Children* | 0 | 1 | € - 0 |
Category B - Employees Not-Affiliated to French Social Security
B-1 Basic Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Base)
| 5001 | Employees | 1 | 1 | € - 0 | AB3 | ERROR:#REF! |
| 5002 | Spouses* | 0 | 0 | € - 0 | AB4 | |
| 5003 | Children* | 0 | 0 | € - 0 | ERROR:#REF! |
B-2 High Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Haute)
| 6001 | Employees (Cadres et Non-cadres) | 0 | 0 | € - 0 | AH3 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| 6002 | Spouses* | 0 | 0 | € - 0 | AH4 | |||
| 6003 | Children* | 0 | 0 | € - 0 | ERROR:#REF! |
B.2.2.1 Total estimated amount for twelve months of Medical Coverage for Employees only € - 0
* Spouses and children are benefitting from the contract prices but contributions are paid separately from the contract and are not included in the above total estimated amount
A Health Prices Option Year 3
| ATTACHMENT A - PRICES/PREMIUMS FOR MEDICAL COVERAGE | |||||
| CLIN | Current Members of the U.S. Mission | Estimated Members of the U.S. Mission + spouses and children | Premium per Month & per Member, € | Total Amount for twelve months, € | AG2R Category |
Category A - Employees Affiliated to French Social Security
A-1 Basic Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Base) Empl-PP USG-PP
| 1001 | Employees | 378 | 378 | € - 0 | AB1 | ERROR:#REF! | ERROR:#REF! |
| 1002 | Spouses* | 54 | 76 | € - 0 | AB5 | ||
| 1003 | Children* | 123 | 123 | € - 0 |
A-2 High Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Haute)
| 2001 | Employees | 189 | 178 | € - 0 | AH1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| 2002 | Spouses* | 30 | 30 | € - 0 | ||||
| 2003 | Children* | 65 | 65 | € - 0 |
A-3 Basic Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Base)
| 3001 | Employees | 5 | 5 | € - 0 | AB2 | ERROR:#REF! | ERROR:#REF! |
| 3002 | Spouses* | 0 | 1 | € - 0 | |||
| 3003 | Children* | 0 | 1 | € - 0 |
A-4 High Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Haute)
| 4001 | Employees | 4 | 4 | € - 0 | AH2 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| 4002 | Spouses* | 0 | 1 | € - 0 | ||||
| 4003 | Children* | 0 | 1 | € - 0 |
Category B - Employees Not-Affiliated to French Social Security
B-1 Basic Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Base)
| 5001 | Employees | 1 | 1 | € - 0 | AB3 | ERROR:#REF! |
| 5002 | Spouses* | 0 | 0 | € - 0 | AB4 | |
| 5003 | Children* | 0 | 0 | € - 0 | ERROR:#REF! |
B-2 High Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Haute)
| 6001 | Employees (Cadres et Non-cadres) | 0 | 0 | € - 0 | AH3 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| 6002 | Spouses* | 0 | 0 | € - 0 | AH4 | |||
| 6003 | Children* | 0 | 0 | € - 0 | ERROR:#REF! |
B.2.2.1 Total estimated amount for twelve months of Medical Coverage for Employees only € - 0
* Spouses and children are benefitting from the contract prices but contributions are paid separately from the contract and are not included in the above total estimated amount
A Health Prices Option Year 4
| ATTACHMENT A - PRICES/PREMIUMS FOR MEDICAL COVERAGE | |||||
| CLIN | Current Members of the U.S. Mission | Estimated Members of the U.S. Mission + spouses and children | Premium per Month & per Member, € | Total Amount for twelve months, € | AG2R Category |
Category A - Employees Affiliated to French Social Security
A-1 Basic Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Base) Empl-PP USG-PP
| 1001 | Employees | 378 | 378 | € - 0 | AB1 | ERROR:#REF! | ERROR:#REF! |
| 1002 | Spouses* | 54 | 76 | € - 0 | AB5 | ||
| 1003 | Children* | 123 | 123 | € - 0 |
A-2 High Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Haute)
| 2001 | Employees | 189 | 178 | € - 0 | AH1 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| 2002 | Spouses* | 30 | 30 | € - 0 | ||||
| 2003 | Children* | 65 | 65 | € - 0 |
A-3 Basic Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Base)
| 3001 | Employees | 5 | 5 | € - 0 | AB2 | ERROR:#REF! | ERROR:#REF! |
| 3002 | Spouses* | 0 | 1 | € - 0 | |||
| 3003 | Children* | 0 | 1 | € - 0 |
A-4 High Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Haute)
| 4001 | Employees | 4 | 4 | € - 0 | AH2 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| 4002 | Spouses* | 0 | 1 | € - 0 | ||||
| 4003 | Children* | 0 | 1 | € - 0 |
Category B - Employees Not-Affiliated to French Social Security
B-1 Basic Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Base)
| 5001 | Employees | 1 | 1 | € - 0 | AB3 | ERROR:#REF! |
| 5002 | Spouses* | 0 | 0 | € - 0 | AB4 | |
| 5003 | Children* | 0 | 0 | € - 0 | ERROR:#REF! |
B-2 High Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Haute)
| 6001 | Employees (Cadres et Non-cadres) | 0 | 0 | € - 0 | AH3 | ERROR:#REF! | ERROR:#REF! | ERROR:#REF! |
| 6002 | Spouses* | 0 | 0 | € - 0 | AH4 | |||
| 6003 | Children* | 0 | 0 | € - 0 | ERROR:#REF! |
B.2.2.1 Total estimated amount for twelve months of Medical Coverage for Employees only € - 0
* Spouses and children are benefitting from the contract prices but contributions are paid separately from the contract and are not included in the above total estimated amount
File details come from the government source that posted it. Updated .