Attachment B Pricing Spreadsheet.xlsx
XLSX spreadsheet 44 KB Posted
- Solicitation number
- 19FR6325R0003
- Issued by
-
Department of State US Embassy Paris
About this file
The file is a detailed pricing spreadsheet for a health insurance services contract for the U.S. Mission in France (Solicitation 19FR6325R0003). The document outlines pricing for medical coverage across multiple employee categories, including basic and high options for employees affiliated with French Social Security and those not affiliated. The contract is structured with a base year and four one-year option periods, covering medical, maternity, disability, and death benefits for locally employed staff, former employees, retirees, and their eligible dependents.
The pricing breakdown includes distinct categories for employees: Category A (French Social Security affiliated) with 378 basic and 178 high option premiums, and Category B (non-French Social Security) with 1 basic option premium. The estimated monthly payroll is 1,503,576 EUR for basic and 433,174 EUR for high options, with a yearly gross salary of 43,257 EUR for non-affiliated employees. The contract includes coverage percentages for permanent and partial disability (0.05% for tranche A, 0.32% for tranche B) and death benefits, with consistent pricing structures replicated across the base year and four option years.
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 A-Medical Pricing-Categories A and B.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
Base Year
| CLIN | Category | Estimated Number of Premiums* | Montly rate per Premium in Euros (€) including all taxes | Total Amount for twelve months in Euros (€) including all taxes |
| Category A - Employees Affiliated to French Social Security | ||||
| 1001 | A-1 Basic Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Base) | 378 | ||
| Category A - Employees Affiliated to French Social Security | ||||
| 2001 | A-2 High Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Haute) | 178 |
tc={136AFFFB-891C-4D5F-93D7-3F79A2AECCDE}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Demande Henner faite le 10.09.2024
| Category A - Employees Affiliated to French Social Security | ||
| 3001 | A-3 Basic Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Base) | 5 |
| Category A - Employees Affiliated to French Social Security | ||
| 4001 | A-4 High Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Haute) | 4 |
| Category B - Employees not Affiliated to French Social Security | ||
| 5001 | B-1 Basic Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Base) | 1 |
| Category B - Employees not Affiliated to French Social Security | ||
| 6001 | B-2 High Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Base) | 0 |
| Total estimated amount in Euros (€) for twelve months of Medical Coverage for Employees only** |
| * estimated number of premiums does not include any riders |
| ** does not include any premium for Riders |
| CLIN | Category | Estimated Number of Employees | Percentage of tranche A | Percentage of tranche B | Permanent and partial Disability (Invalidité permanente partielle et invalidité permanente totale) | Death (Décès) | Total Amount for twelve months in Euros (€) including all taxes* | |||
| Category A - Employees Affiliated to French Social Security | ||||||||||
| Basic Option-Employees affiliated to Social Security | ||||||||||
| PASS ceiling 2023 in Euro (€) | Not applicable | 0.05% | 0.32% | |||||||
| P001 | Employees | 383 | - % of PMSS** | € 0.00 | - % | - % | ||||
| High Option-Employees affiliated to Social Security | ||||||||||
| P002 | Employees | 182 | - % of tranche A | - % of Tranche B | - % | - % | ||||
| Category B - Employees Non-Affiliated to French Social Security | ||||||||||
| Basic Option-Employees non-affiliated to Social Security | ||||||||||
| P003 | Employees | 1 | - % of PMSS** | - % | - % | |||||
| High Option-Employees non-affiliated to Social Security | ||||||||||
| P004 | Employees | 0 | - % of tranche A | - % of tranche B | - % | - % | ||||
| Total estimated amount in Euros (€) for twelve months of Death and Disability Coverage |
** PMSS - Social Security ceiling
| Total estimated pay roll for one month (March 2025): |
| Basic: 1,503,576.00 € |
| High: 433,174.00 € |
Employees non-affiliated to Social Security estimated yearly gross salary: 43,257.00 €
&"Aptos,Bold"&9Solicitation ref. 19FR6325R0003
Option Year One
| CLIN | Category | Estimated Number of Premiums* | Montly rate per Premium in Euros (€) including all taxes | Total Amount for twelve months in Euros (€) including all taxes |
| Category A - Employees Affiliated to French Social Security | ||||
| 1001 | A-1 Basic Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Base) | 378 | ||
| Category A - Employees Affiliated to French Social Security | ||||
| 2001 | A-2 High Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Haute) | 178 |
tc={FFA2E9E7-3A09-4C09-B400-71055049C9EB}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Demande Henner faite le 10.09.2024
| Category A - Employees Affiliated to French Social Security | ||
| 3001 | A-3 Basic Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Base) | 5 |
| Category A - Employees Affiliated to French Social Security | ||
| 4001 | A-4 High Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Haute) | 4 |
| Category B - Employees not Affiliated to French Social Security | ||
| 5001 | B-1 Basic Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Base) | 1 |
| Category B - Employees not Affiliated to French Social Security | ||
| 6001 | B-2 High Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Base) | 0 |
| Total estimated amount in Euros (€) for twelve months of Medical Coverage for Employees only** |
| * estimated number of premiums does not include any riders |
| ** does not include any premium for Riders |
| CLIN | Category | Estimated Number of Employees | Percentage of tranche A | Percentage of tranche B | Permanent and partial Disability (Invalidité permanente partielle et invalidité permanente totale) | Death (Décès) | Total Amount for twelve months in Euros (€) including all taxes* | |||
| Category A - Employees Affiliated to French Social Security | ||||||||||
| Basic Option-Employees affiliated to Social Security | ||||||||||
| PASS ceiling 2023 in Euro (€) | Not applicable | 0.05% | 0.32% | |||||||
| P001 | Employees | 383 | - % of PMSS** | € 0.00 | - % | - % | ||||
| High Option-Employees affiliated to Social Security | ||||||||||
| P002 | Employees | 182 | - % of tranche A | - % of Tranche B | - % | - % | ||||
| Category B - Employees Non-Affiliated to French Social Security | ||||||||||
| Basic Option-Employees non-affiliated to Social Security | ||||||||||
| P003 | Employees | 1 | - % of PMSS** | - % | - % | |||||
| High Option-Employees non-affiliated to Social Security | ||||||||||
| P004 | Employees | 0 | - % of tranche A | - % of tranche B | - % | - % | ||||
| Total estimated amount in Euros (€) for twelve months of Death and Disability Coverage |
** PMSS - Social Security ceiling
| Total estimated pay roll for one month (March 2025): |
| Basic: 1,503,576.00 € |
| High: 433,174.00 € |
Employees non-affiliated to Social Security estimated yearly gross salary: 43,257.00 €
Option Year Two
| CLIN | Category | Estimated Number of Premiums* | Montly rate per Premium in Euros (€) including all taxes | Total Amount for twelve months in Euros (€) including all taxes |
| Category A - Employees Affiliated to French Social Security | ||||
| 1001 | A-1 Basic Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Base) | 378 | ||
| Category A - Employees Affiliated to French Social Security | ||||
| 2001 | A-2 High Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Haute) | 178 |
tc={DB6916DB-746A-403F-8786-67601EF9AE6C}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Demande Henner faite le 10.09.2024
| Category A - Employees Affiliated to French Social Security | ||
| 3001 | A-3 Basic Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Base) | 5 |
| Category A - Employees Affiliated to French Social Security | ||
| 4001 | A-4 High Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Haute) | 4 |
| Category B - Employees not Affiliated to French Social Security | ||
| 5001 | B-1 Basic Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Base) | 1 |
| Category B - Employees not Affiliated to French Social Security | ||
| 6001 | B-2 High Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Base) | 0 |
| Total estimated amount in Euros (€) for twelve months of Medical Coverage for Employees only** |
| * estimated number of premiums does not include any riders |
| ** does not include any premium for Riders |
| CLIN | Category | Estimated Number of Employees | Percentage of tranche A | Percentage of tranche B | Permanent and partial Disability (Invalidité permanente partielle et invalidité permanente totale) | Death (Décès) | Total Amount for twelve months in Euros (€) including all taxes* | |||
| Category A - Employees Affiliated to French Social Security | ||||||||||
| Basic Option-Employees affiliated to Social Security | ||||||||||
| PASS ceiling 2023 in Euro (€) | Not applicable | 0.05% | 0.32% | |||||||
| P001 | Employees | 383 | - % of PMSS** | € 0.00 | - % | - % | ||||
| High Option-Employees affiliated to Social Security | ||||||||||
| P002 | Employees | 182 | - % of tranche A | - % of Tranche B | - % | - % | ||||
| Category B - Employees Non-Affiliated to French Social Security | ||||||||||
| Basic Option-Employees non-affiliated to Social Security | ||||||||||
| P003 | Employees | 1 | - % of PMSS** | - % | - % | |||||
| High Option-Employees non-affiliated to Social Security | ||||||||||
| P004 | Employees | 0 | - % of tranche A | - % of tranche B | - % | - % | ||||
| Total estimated amount in Euros (€) for twelve months of Death and Disability Coverage |
** PMSS - Social Security ceiling
| Total estimated pay roll for one month (March 2025): |
| Basic: 1,503,576.00 € |
| High: 433,174.00 € |
Employees non-affiliated to Social Security estimated yearly gross salary: 43,257.00 €
Option Year Three
| CLIN | Category | Estimated Number of Premiums* | Montly rate per Premium in Euros (€) including all taxes | Total Amount for twelve months in Euros (€) including all taxes |
| Category A - Employees Affiliated to French Social Security | ||||
| 1001 | A-1 Basic Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Base) | 378 | ||
| Category A - Employees Affiliated to French Social Security | ||||
| 2001 | A-2 High Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Haute) | 178 |
tc={FF414B98-4D48-4CFE-AC6E-87C572B7935E}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Demande Henner faite le 10.09.2024
| Category A - Employees Affiliated to French Social Security | ||
| 3001 | A-3 Basic Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Base) | 5 |
| Category A - Employees Affiliated to French Social Security | ||
| 4001 | A-4 High Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Haute) | 4 |
| Category B - Employees not Affiliated to French Social Security | ||
| 5001 | B-1 Basic Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Base) | 1 |
| Category B - Employees not Affiliated to French Social Security | ||
| 6001 | B-2 High Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Base) | 0 |
| Total estimated amount in Euros (€) for twelve months of Medical Coverage for Employees only** |
| * estimated number of premiums does not include any riders |
| ** does not include any premium for Riders |
| CLIN | Category | Estimated Number of Employees | Percentage of tranche A | Percentage of tranche B | Permanent and partial Disability (Invalidité permanente partielle et invalidité permanente totale) | Death (Décès) | Total Amount for twelve months in Euros (€) including all taxes* | |||
| Category A - Employees Affiliated to French Social Security | ||||||||||
| Basic Option-Employees affiliated to Social Security | ||||||||||
| PASS ceiling 2023 in Euro (€) | Not applicable | 0.05% | 0.32% | |||||||
| P001 | Employees | 383 | - % of PMSS** | € 0.00 | - % | - % | ||||
| High Option-Employees affiliated to Social Security | ||||||||||
| P002 | Employees | 182 | - % of tranche A | - % of Tranche B | - % | - % | ||||
| Category B - Employees Non-Affiliated to French Social Security | ||||||||||
| Basic Option-Employees non-affiliated to Social Security | ||||||||||
| P003 | Employees | 1 | - % of PMSS** | - % | - % | |||||
| High Option-Employees non-affiliated to Social Security | ||||||||||
| P004 | Employees | 0 | - % of tranche A | - % of tranche B | - % | - % | ||||
| Total estimated amount in Euros (€) for twelve months of Death and Disability Coverage |
** PMSS - Social Security ceiling
| Total estimated pay roll for one month (March 2025): |
| Basic: 1,503,576.00 € |
| High: 433,174.00 € |
Employees non-affiliated to Social Security estimated yearly gross salary: 43,257.00 €
Option Year Four
| CLIN | Category | Estimated Number of Premiums* | Montly rate per Premium in Euros (€) including all taxes | Total Amount for twelve months in Euros (€) including all taxes |
| Category A - Employees Affiliated to French Social Security | ||||
| 1001 | A-1 Basic Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Base) | 378 | ||
| Category A - Employees Affiliated to French Social Security | ||||
| 2001 | A-2 High Option-Employees affiliated to Social Security (Actif Régime Sécurité Sociale Option de Haute) | 178 |
tc={AECE5E16-A49D-4860-B1DA-1AD243124736}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Demande Henner faite le 10.09.2024
| Category A - Employees Affiliated to French Social Security | ||
| 3001 | A-3 Basic Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Base) | 5 |
| Category A - Employees Affiliated to French Social Security | ||
| 4001 | A-4 High Option-Employees affiliated to Alsace Social Security (Actif Régime Alsace Option de Haute) | 4 |
| Category B - Employees not Affiliated to French Social Security | ||
| 5001 | B-1 Basic Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Base) | 1 |
| Category B - Employees not Affiliated to French Social Security | ||
| 6001 | B-2 High Option-Employees not-affiliated to Social Security (Actif NON Sécurité Sociale Option de Base) | 0 |
| Total estimated amount in Euros (€) for twelve months of Medical Coverage for Employees only** |
| * estimated number of premiums does not include any riders |
| ** does not include any premium for Riders |
| CLIN | Category | Estimated Number of Employees | Percentage of tranche A | Percentage of tranche B | Permanent and partial Disability (Invalidité permanente partielle et invalidité permanente totale) | Death (Décès) | Total Amount for twelve months in Euros (€) including all taxes* | |||
| Category A - Employees Affiliated to French Social Security | ||||||||||
| Basic Option-Employees affiliated to Social Security | ||||||||||
| PASS ceiling 2023 in Euro (€) | Not applicable | 0.05% | 0.32% | |||||||
| P001 | Employees | 383 | - % of PMSS** | € 0.00 | - % | - % | ||||
| High Option-Employees affiliated to Social Security | ||||||||||
| P002 | Employees | 182 | - % of tranche A | - % of Tranche B | - % | - % | ||||
| Category B - Employees Non-Affiliated to French Social Security | ||||||||||
| Basic Option-Employees non-affiliated to Social Security | ||||||||||
| P003 | Employees | 1 | - % of PMSS** | - % | - % | |||||
| High Option-Employees non-affiliated to Social Security | ||||||||||
| P004 | Employees | 0 | - % of tranche A | - % of tranche B | - % | - % | ||||
| Total estimated amount in Euros (€) for twelve months of Death and Disability Coverage |
** PMSS - Social Security ceiling
| Total estimated pay roll for one month (March 2025): |
| Basic: 1,503,576.00 € |
| High: 433,174.00 € |
Employees non-affiliated to Social Security estimated yearly gross salary: 43,257.00 €
File details come from the government source that posted it. Updated .