Attachment A-1 Medical Pricing-Categories C and D.xlsx
XLSX spreadsheet 45 KB Posted
- Solicitation number
- 19FR6325R0003
- Issued by
-
Department of State US Embassy Paris
About this file
This file is an Excel-based medical pricing attachment (Attachment A-1) for a health insurance services solicitation by the U.S. Embassy in Paris, France. The document details pricing categories for medical coverage across four option years, specifically targeting retirees, former employees, survivors, and their dependents. The pricing is segmented into two primary categories: Category C (affiliates of French Social Security) and Category D (non-affiliates of French Social Security), with further subdivisions by age groups (up to 69 years, 70-80 years, over 81 years) and coverage levels (basic and high options).
However, the document contains numerous Excel formula errors (ERROR:#REF!) in the pricing fields, rendering the specific premium amounts unreadable. The solicitation (19FR6325R0003) seeks health insurance services for locally employed staff, former employees, and retirees of the U.S. Government in France, with coverage supplemental to French Social Security. The contract is anticipated to have a base year with four one-year option periods, and will be a fixed-price contract with economic price adjustment requirements. The total estimated membership across categories ranges from approximately 6 to 123 individuals, though precise pricing details are currently unavailable due to the spreadsheet errors.
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 | ||
| Solicitation letter.pdf | ||
| Attachment A-Medical Pricing-Categories A and B.xlsx | XLSX spreadsheet | |
| 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-1 Health Prices - Base Year
| ATTACHMENT A-1 - PRICES/PREMIUMS FOR MEDICAL COVERAGE FOR CATEGORIES NOT ON THE PAYROLL | ||||||
| CLIN | Current Global Estimated Number of Members | Estimated Members | Premium per Month & per Member, € | Total Amount for one contract year, € | AG2R Category | Total Amount for twelve months, € |
Category C - Retirees, riffed employees, survivors and dependents Affiliated to French Social Security
| C-1-1 Basic Option-Retirees, survivors and dependents affiliated to Social Security (Retraité, ayant droit et ayant droit de salarié décédé Régime Sécurité Sociale Option de Base) | 123 | |||||
| 7001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB1 | € 0.00 |
| 7002 | Spouses | 0 | 1 | ERROR:#REF! | RB2 | € 0.00 |
| 7003 | Children | 0 | 1 | ERROR:#REF! | RB3 | € 0.00 |
| 7004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB4 | € 0.00 |
| 7005 | Spouses | 0 | 1 | ERROR:#REF! | RB5 | € 0.00 |
| 7006 | Children | 0 | 1 | ERROR:#REF! | RB6 | € 0.00 |
| 7016 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB7 | € 0.00 |
| 7017 | Spouses | 0 | 1 | ERROR:#REF! | RB8 | € 0.00 |
| 7018 | Children | 0 | 1 | ERROR:#REF! | RB9 | € 0.00 |
| 7019 | Régime Alsace Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB10 | € 0.00 |
| 7020 | Spouses | 0 | 1 | ERROR:#REF! | RB11 | € 0.00 |
| 7021 | Children | 0 | 1 | ERROR:#REF! | RB12 | € 0.00 |
| 7022 | Régime Alsace Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB13 | € 0.00 |
| 7023 | Spouses | 0 | 1 | ERROR:#REF! | RB14 | € 0.00 |
| 7024 | Children | 0 | 1 | ERROR:#REF! | RB15 | € 0.00 |
| 7034 | Régime Alsace Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB16 | € 0.00 |
| 7035 | Spouses | 0 | 1 | ERROR:#REF! | RB17 | € 0.00 |
| 7036 | Children | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| C-1-2 Basic Option-Riffed employees, survivors and dependents affiliated to Social Security (Licencié, ayant droit et ayant droit de salarié décédé Régime Sécurité Sociale Option de Base) | ||||||
| 8001 | Former Employees | 0 | 1 | ERROR:#REF! | RB17 | € 0.00 |
| 8002 | Spouses | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 8003 | Children | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| C-2-1 High Option-Retirees, survivors and dependents affiliated to Social Security (Retraité, ayant droit, ayant droit de salarié décédé Régime Sécurité Sociale Option Haute) | 106 | |||||
| 9001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 9002 | Spouses | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| 9003 | Children | 0 | 1 | ERROR:#REF! | RB20 | € 0.00 |
| 9004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB21 | € 0.00 |
| 9005 | Spouses | 0 | 1 | ERROR:#REF! | RB22 | € 0.00 |
| 9006 | Children | 0 | 1 | ERROR:#REF! | RB23 | € 0.00 |
| 9007 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB24 | € 0.00 |
| 9008 | Spouses | 0 | 1 | ERROR:#REF! | RB25 | € 0.00 |
| 9009 | Children | 0 | 1 | ERROR:#REF! | RB26 | € 0.00 |
| 9010 | Régime Alsace Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB27 | € 0.00 |
| 9011 | Spouses | 0 | 1 | ERROR:#REF! | RB28 | € 0.00 |
| 9012 | Children | 0 | 1 | ERROR:#REF! | RB29 | € 0.00 |
| 9013 | Régime Alsace Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB30 | € 0.00 |
| 9014 | Spouses | 0 | 1 | ERROR:#REF! | RB31 | € 0.00 |
| 9015 | Children | 0 | 1 | ERROR:#REF! | RB32 | € 0.00 |
| 9016 | Régime Alsace Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB33 | € 0.00 |
| 9017 | Spouses | 0 | 1 | ERROR:#REF! | RB34 | € 0.00 |
| 9018 | Children | 0 | 1 | ERROR:#REF! | RB35 | € 0.00 |
| C-2-2 High Option-Riffed employees, survivors and dependents affiliated to Social Security (Licencié, ayant droit, ayant droit de salarié décédé Régime Sécurité Sociale Option Haute) | ||||||
| 10001 | Former Employees | 0 | 1 | ERROR:#REF! | RB33 | € 0.00 |
| 10002 | Spouses | 0 | 1 | ERROR:#REF! | RB34 | € 0.00 |
| 10003 | Children | 0 | 1 | ERROR:#REF! | RB35 | € 0.00 |
Category D - Retirees, riffed employees, survivors and dependents Non-Affiliated to French Social Security
| D-1-1 Basic Option-Retirees, survivors and dependents not affiliated to Social Security (Retraité, ayant droit et ayant droit de salarié décédé Non Sécurité Sociale Option de Base) | 6 | |||||
| 11001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB1 | € 0.00 |
| 11002 | Spouses | 0 | 1 | ERROR:#REF! | RB2 | € 0.00 |
| 11003 | Children | 0 | 1 | ERROR:#REF! | RB3 | € 0.00 |
| 11004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB4 | € 0.00 |
| 11005 | Spouses | 0 | 1 | ERROR:#REF! | RB5 | € 0.00 |
| 11006 | Children | 0 | 1 | ERROR:#REF! | RB6 | € 0.00 |
| 11007 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB7 | € 0.00 |
| 11008 | Spouses | 0 | 1 | ERROR:#REF! | RB8 | € 0.00 |
| 11009 | Children | 0 | 1 | ERROR:#REF! | RB9 | € 0.00 |
| D-1-2 Basic Option-Riffed employees, survivors and dependents not affiliated to Social Security (Licencié, ayant droit et ayant droit de salarié décédé Non Sécurité Sociale Option de Base) | ||||||
| 12001 | Former Employees | 0 | 1 | ERROR:#REF! | RB17 | € 0.00 |
| 12002 | Spouses | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 12003 | Children | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| D-2-1 High Option-Retirees, survivors and dependents not affiliated to Social Security (Retraité, Ayant droit et ayant droit de salarié décédé NON Sécurité Sociale Option Haute) | 5 | |||||
| 13001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 13002 | Spouses | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| 13003 | Children | 0 | 1 | ERROR:#REF! | RB20 | € 0.00 |
| 13004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB21 | € 0.00 |
| 13005 | Spouses | 0 | 1 | ERROR:#REF! | RB22 | € 0.00 |
| 13006 | Children | 0 | 1 | ERROR:#REF! | RB23 | € 0.00 |
| 13007 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB24 | € 0.00 |
| 13008 | Spouses | 0 | 1 | ERROR:#REF! | RB25 | € 0.00 |
| 13009 | Children | 0 | 1 | ERROR:#REF! | RB26 | € 0.00 |
| D-3 High Option-Riffed employees, survivors and dependents not affiliated to Social Security (Licencié, Ayant droit et ayant droit de salarié décédé NON Sécurité Sociale Option Haute) | ||||||
| 14001 | Former Employees | 0 | 1 | ERROR:#REF! | RB33 | € 0.00 |
| 14002 | Spouses | 0 | 1 | ERROR:#REF! | RB34 | € 0.00 |
| 14003 | Children | 0 | 1 | ERROR:#REF! | RB35 | € 0.00 |
Solicitation ref. 19FR6325R0003 Page: &P of &N
A-1 Health Prices Option Year 1
| ATTACHMENT A-1 - PRICES/PREMIUMS FOR MEDICAL COVERAGE FOR CATEGORIES NOT ON THE PAYROLL | ||||||
| CLIN | Current Global Estimated Number of Members | Estimated Members | Premium per Month & per Member, € | Total Amount for one contract year, € | AG2R Category | Total Amount for twelve months, € |
Category C - Retirees, riffed employees, survivors and dependents Affiliated to French Social Security
| C-1-1 Basic Option-Retirees, survivors and dependents affiliated to Social Security (Retraité, ayant droit et ayant droit de salarié décédé Régime Sécurité Sociale Option de Base) | 123 | |||||
| 7001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB1 | € 0.00 |
| 7002 | Spouses | 0 | 1 | ERROR:#REF! | RB2 | € 0.00 |
| 7003 | Children | 0 | 1 | ERROR:#REF! | RB3 | € 0.00 |
| 7004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB4 | € 0.00 |
| 7005 | Spouses | 0 | 1 | ERROR:#REF! | RB5 | € 0.00 |
| 7006 | Children | 0 | 1 | ERROR:#REF! | RB6 | € 0.00 |
| 7016 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB7 | € 0.00 |
| 7017 | Spouses | 0 | 1 | ERROR:#REF! | RB8 | € 0.00 |
| 7018 | Children | 0 | 1 | ERROR:#REF! | RB9 | € 0.00 |
| 7019 | Régime Alsace Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB10 | € 0.00 |
| 7020 | Spouses | 0 | 1 | ERROR:#REF! | RB11 | € 0.00 |
| 7021 | Children | 0 | 1 | ERROR:#REF! | RB12 | € 0.00 |
| 7022 | Régime Alsace Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB13 | € 0.00 |
| 7023 | Spouses | 0 | 1 | ERROR:#REF! | RB14 | € 0.00 |
| 7024 | Children | 0 | 1 | ERROR:#REF! | RB15 | € 0.00 |
| 7034 | Régime Alsace Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB16 | € 0.00 |
| 7035 | Spouses | 0 | 1 | ERROR:#REF! | RB17 | € 0.00 |
| 7036 | Children | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| C-1-2 Basic Option-Riffed employees, survivors and dependents affiliated to Social Security (Licencié, ayant droit et ayant droit de salarié décédé Régime Sécurité Sociale Option de Base) | ||||||
| 8001 | Former Employees | 0 | 1 | ERROR:#REF! | RB17 | € 0.00 |
| 8002 | Spouses | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 8003 | Children | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| C-2-1 High Option-Retirees, survivors and dependents affiliated to Social Security (Retraité, ayant droit, ayant droit de salarié décédé Régime Sécurité Sociale Option Haute) | 106 | |||||
| 9001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 9002 | Spouses | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| 9003 | Children | 0 | 1 | ERROR:#REF! | RB20 | € 0.00 |
| 9004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB21 | € 0.00 |
| 9005 | Spouses | 0 | 1 | ERROR:#REF! | RB22 | € 0.00 |
| 9006 | Children | 0 | 1 | ERROR:#REF! | RB23 | € 0.00 |
| 9007 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB24 | € 0.00 |
| 9008 | Spouses | 0 | 1 | ERROR:#REF! | RB25 | € 0.00 |
| 9009 | Children | 0 | 1 | ERROR:#REF! | RB26 | € 0.00 |
| 9010 | Régime Alsace Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB27 | € 0.00 |
| 9011 | Spouses | 0 | 1 | ERROR:#REF! | RB28 | € 0.00 |
| 9012 | Children | 0 | 1 | ERROR:#REF! | RB29 | € 0.00 |
| 9013 | Régime Alsace Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB30 | € 0.00 |
| 9014 | Spouses | 0 | 1 | ERROR:#REF! | RB31 | € 0.00 |
| 9015 | Children | 0 | 1 | ERROR:#REF! | RB32 | € 0.00 |
| 9016 | Régime Alsace Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB33 | € 0.00 |
| 9017 | Spouses | 0 | 1 | ERROR:#REF! | RB34 | € 0.00 |
| 9018 | Children | 0 | 1 | ERROR:#REF! | RB35 | € 0.00 |
| C-2-2 High Option-Riffed employees, survivors and dependents affiliated to Social Security (Licencié, ayant droit, ayant droit de salarié décédé Régime Sécurité Sociale Option Haute) | ||||||
| 10001 | Former Employees | 0 | 1 | ERROR:#REF! | RB33 | € 0.00 |
| 10002 | Spouses | 0 | 1 | ERROR:#REF! | RB34 | € 0.00 |
| 10003 | Children | 0 | 1 | ERROR:#REF! | RB35 | € 0.00 |
Category D - Retirees, riffed employees, survivors and dependents Non-Affiliated to French Social Security
| D-1-1 Basic Option-Retirees, survivors and dependents not affiliated to Social Security (Retraité, ayant droit et ayant droit de salarié décédé Non Sécurité Sociale Option de Base) | 6 | |||||
| 11001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB1 | € 0.00 |
| 11002 | Spouses | 0 | 1 | ERROR:#REF! | RB2 | € 0.00 |
| 11003 | Children | 0 | 1 | ERROR:#REF! | RB3 | € 0.00 |
| 11004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB4 | € 0.00 |
| 11005 | Spouses | 0 | 1 | ERROR:#REF! | RB5 | € 0.00 |
| 11006 | Children | 0 | 1 | ERROR:#REF! | RB6 | € 0.00 |
| 11007 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB7 | € 0.00 |
| 11008 | Spouses | 0 | 1 | ERROR:#REF! | RB8 | € 0.00 |
| 11009 | Children | 0 | 1 | ERROR:#REF! | RB9 | € 0.00 |
| D-1-2 Basic Option-Riffed employees, survivors and dependents not affiliated to Social Security (Licencié, ayant droit et ayant droit de salarié décédé Non Sécurité Sociale Option de Base) | ||||||
| 12001 | Former Employees | 0 | 1 | ERROR:#REF! | RB17 | € 0.00 |
| 12002 | Spouses | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 12003 | Children | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| D-2-1 High Option-Retirees, survivors and dependents not affiliated to Social Security (Retraité, Ayant droit et ayant droit de salarié décédé NON Sécurité Sociale Option Haute) | 5 | |||||
| 13001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 13002 | Spouses | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| 13003 | Children | 0 | 1 | ERROR:#REF! | RB20 | € 0.00 |
| 13004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB21 | € 0.00 |
| 13005 | Spouses | 0 | 1 | ERROR:#REF! | RB22 | € 0.00 |
| 13006 | Children | 0 | 1 | ERROR:#REF! | RB23 | € 0.00 |
| 13007 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB24 | € 0.00 |
| 13008 | Spouses | 0 | 1 | ERROR:#REF! | RB25 | € 0.00 |
| 13009 | Children | 0 | 1 | ERROR:#REF! | RB26 | € 0.00 |
| D-3 High Option-Riffed employees, survivors and dependents not affiliated to Social Security (Licencié, Ayant droit et ayant droit de salarié décédé NON Sécurité Sociale Option Haute) | ||||||
| 14001 | Former Employees | 0 | 1 | ERROR:#REF! | RB33 | € 0.00 |
| 14002 | Spouses | 0 | 1 | ERROR:#REF! | RB34 | € 0.00 |
| 14003 | Children | 0 | 1 | ERROR:#REF! | RB35 | € 0.00 |
A-1 Health Prices Option Year 2
| ATTACHMENT A-1 - PRICES/PREMIUMS FOR MEDICAL COVERAGE FOR CATEGORIES NOT ON THE PAYROLL | ||||||
| CLIN | Current Global Estimated Number of Members | Estimated Members | Premium per Month & per Member, € | Total Amount for one contract year, € | AG2R Category | Total Amount for twelve months, € |
Category C - Retirees, riffed employees, survivors and dependents Affiliated to French Social Security
| C-1-1 Basic Option-Retirees, survivors and dependents affiliated to Social Security (Retraité, ayant droit et ayant droit de salarié décédé Régime Sécurité Sociale Option de Base) | 123 | |||||
| 7001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB1 | € 0.00 |
| 7002 | Spouses | 0 | 1 | ERROR:#REF! | RB2 | € 0.00 |
| 7003 | Children | 0 | 1 | ERROR:#REF! | RB3 | € 0.00 |
| 7004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB4 | € 0.00 |
| 7005 | Spouses | 0 | 1 | ERROR:#REF! | RB5 | € 0.00 |
| 7006 | Children | 0 | 1 | ERROR:#REF! | RB6 | € 0.00 |
| 7016 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB7 | € 0.00 |
| 7017 | Spouses | 0 | 1 | ERROR:#REF! | RB8 | € 0.00 |
| 7018 | Children | 0 | 1 | ERROR:#REF! | RB9 | € 0.00 |
| 7019 | Régime Alsace Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB10 | € 0.00 |
| 7020 | Spouses | 0 | 1 | ERROR:#REF! | RB11 | € 0.00 |
| 7021 | Children | 0 | 1 | ERROR:#REF! | RB12 | € 0.00 |
| 7022 | Régime Alsace Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB13 | € 0.00 |
| 7023 | Spouses | 0 | 1 | ERROR:#REF! | RB14 | € 0.00 |
| 7024 | Children | 0 | 1 | ERROR:#REF! | RB15 | € 0.00 |
| 7034 | Régime Alsace Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB16 | € 0.00 |
| 7035 | Spouses | 0 | 1 | ERROR:#REF! | RB17 | € 0.00 |
| 7036 | Children | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| C-1-2 Basic Option-Riffed employees, survivors and dependents affiliated to Social Security (Licencié, ayant droit et ayant droit de salarié décédé Régime Sécurité Sociale Option de Base) | ||||||
| 8001 | Former Employees | 0 | 1 | ERROR:#REF! | RB17 | € 0.00 |
| 8002 | Spouses | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 8003 | Children | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| C-2-1 High Option-Retirees, survivors and dependents affiliated to Social Security (Retraité, ayant droit, ayant droit de salarié décédé Régime Sécurité Sociale Option Haute) | 106 | |||||
| 9001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 9002 | Spouses | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| 9003 | Children | 0 | 1 | ERROR:#REF! | RB20 | € 0.00 |
| 9004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB21 | € 0.00 |
| 9005 | Spouses | 0 | 1 | ERROR:#REF! | RB22 | € 0.00 |
| 9006 | Children | 0 | 1 | ERROR:#REF! | RB23 | € 0.00 |
| 9007 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB24 | € 0.00 |
| 9008 | Spouses | 0 | 1 | ERROR:#REF! | RB25 | € 0.00 |
| 9009 | Children | 0 | 1 | ERROR:#REF! | RB26 | € 0.00 |
| 9010 | Régime Alsace Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB27 | € 0.00 |
| 9011 | Spouses | 0 | 1 | ERROR:#REF! | RB28 | € 0.00 |
| 9012 | Children | 0 | 1 | ERROR:#REF! | RB29 | € 0.00 |
| 9013 | Régime Alsace Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB30 | € 0.00 |
| 9014 | Spouses | 0 | 1 | ERROR:#REF! | RB31 | € 0.00 |
| 9015 | Children | 0 | 1 | ERROR:#REF! | RB32 | € 0.00 |
| 9016 | Régime Alsace Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB33 | € 0.00 |
| 9017 | Spouses | 0 | 1 | ERROR:#REF! | RB34 | € 0.00 |
| 9018 | Children | 0 | 1 | ERROR:#REF! | RB35 | € 0.00 |
| C-2-2 High Option-Riffed employees, survivors and dependents affiliated to Social Security (Licencié, ayant droit, ayant droit de salarié décédé Régime Sécurité Sociale Option Haute) | ||||||
| 10001 | Former Employees | 0 | 1 | ERROR:#REF! | RB33 | € 0.00 |
| 10002 | Spouses | 0 | 1 | ERROR:#REF! | RB34 | € 0.00 |
| 10003 | Children | 0 | 1 | ERROR:#REF! | RB35 | € 0.00 |
Category D - Retirees, riffed employees, survivors and dependents Non-Affiliated to French Social Security
| D-1-1 Basic Option-Retirees, survivors and dependents not affiliated to Social Security (Retraité, ayant droit et ayant droit de salarié décédé Non Sécurité Sociale Option de Base) | 6 | |||||
| 11001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB1 | € 0.00 |
| 11002 | Spouses | 0 | 1 | ERROR:#REF! | RB2 | € 0.00 |
| 11003 | Children | 0 | 1 | ERROR:#REF! | RB3 | € 0.00 |
| 11004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB4 | € 0.00 |
| 11005 | Spouses | 0 | 1 | ERROR:#REF! | RB5 | € 0.00 |
| 11006 | Children | 0 | 1 | ERROR:#REF! | RB6 | € 0.00 |
| 11007 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB7 | € 0.00 |
| 11008 | Spouses | 0 | 1 | ERROR:#REF! | RB8 | € 0.00 |
| 11009 | Children | 0 | 1 | ERROR:#REF! | RB9 | € 0.00 |
| D-1-2 Basic Option-Riffed employees, survivors and dependents not affiliated to Social Security (Licencié, ayant droit et ayant droit de salarié décédé Non Sécurité Sociale Option de Base) | ||||||
| 12001 | Former Employees | 0 | 1 | ERROR:#REF! | RB17 | € 0.00 |
| 12002 | Spouses | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 12003 | Children | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| D-2-1 High Option-Retirees, survivors and dependents not affiliated to Social Security (Retraité, Ayant droit et ayant droit de salarié décédé NON Sécurité Sociale Option Haute) | 5 | |||||
| 13001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 13002 | Spouses | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| 13003 | Children | 0 | 1 | ERROR:#REF! | RB20 | € 0.00 |
| 13004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB21 | € 0.00 |
| 13005 | Spouses | 0 | 1 | ERROR:#REF! | RB22 | € 0.00 |
| 13006 | Children | 0 | 1 | ERROR:#REF! | RB23 | € 0.00 |
| 13007 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB24 | € 0.00 |
| 13008 | Spouses | 0 | 1 | ERROR:#REF! | RB25 | € 0.00 |
| 13009 | Children | 0 | 1 | ERROR:#REF! | RB26 | € 0.00 |
| D-3 High Option-Riffed employees, survivors and dependents not affiliated to Social Security (Licencié, Ayant droit et ayant droit de salarié décédé NON Sécurité Sociale Option Haute) | ||||||
| 14001 | Former Employees | 0 | 1 | ERROR:#REF! | RB33 | € 0.00 |
| 14002 | Spouses | 0 | 1 | ERROR:#REF! | RB34 | € 0.00 |
| 14003 | Children | 0 | 1 | ERROR:#REF! | RB35 | € 0.00 |
A-1 Health Prices Option Year 3
| ATTACHMENT A-1 - PRICES/PREMIUMS FOR MEDICAL COVERAGE FOR CATEGORIES NOT ON THE PAYROLL | ||||||
| CLIN | Current Global Estimated Number of Members | Estimated Members | Premium per Month & per Member, € | Total Amount for one contract year, € | AG2R Category | Total Amount for twelve months, € |
Category C - Retirees, riffed employees, survivors and dependents Affiliated to French Social Security
| C-1-1 Basic Option-Retirees, survivors and dependents affiliated to Social Security (Retraité, ayant droit et ayant droit de salarié décédé Régime Sécurité Sociale Option de Base) | 123 | |||||
| 7001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB1 | € 0.00 |
| 7002 | Spouses | 0 | 1 | ERROR:#REF! | RB2 | € 0.00 |
| 7003 | Children | 0 | 1 | ERROR:#REF! | RB3 | € 0.00 |
| 7004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB4 | € 0.00 |
| 7005 | Spouses | 0 | 1 | ERROR:#REF! | RB5 | € 0.00 |
| 7006 | Children | 0 | 1 | ERROR:#REF! | RB6 | € 0.00 |
| 7016 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB7 | € 0.00 |
| 7017 | Spouses | 0 | 1 | ERROR:#REF! | RB8 | € 0.00 |
| 7018 | Children | 0 | 1 | ERROR:#REF! | RB9 | € 0.00 |
| 7019 | Régime Alsace Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB10 | € 0.00 |
| 7020 | Spouses | 0 | 1 | ERROR:#REF! | RB11 | € 0.00 |
| 7021 | Children | 0 | 1 | ERROR:#REF! | RB12 | € 0.00 |
| 7022 | Régime Alsace Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB13 | € 0.00 |
| 7023 | Spouses | 0 | 1 | ERROR:#REF! | RB14 | € 0.00 |
| 7024 | Children | 0 | 1 | ERROR:#REF! | RB15 | € 0.00 |
| 7034 | Régime Alsace Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB16 | € 0.00 |
| 7035 | Spouses | 0 | 1 | ERROR:#REF! | RB17 | € 0.00 |
| 7036 | Children | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| C-1-2 Basic Option-Riffed employees, survivors and dependents affiliated to Social Security (Licencié, ayant droit et ayant droit de salarié décédé Régime Sécurité Sociale Option de Base) | ||||||
| 8001 | Former Employees | 0 | 1 | ERROR:#REF! | RB17 | € 0.00 |
| 8002 | Spouses | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 8003 | Children | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| C-2-1 High Option-Retirees, survivors and dependents affiliated to Social Security (Retraité, ayant droit, ayant droit de salarié décédé Régime Sécurité Sociale Option Haute) | 106 | |||||
| 9001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 9002 | Spouses | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| 9003 | Children | 0 | 1 | ERROR:#REF! | RB20 | € 0.00 |
| 9004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB21 | € 0.00 |
| 9005 | Spouses | 0 | 1 | ERROR:#REF! | RB22 | € 0.00 |
| 9006 | Children | 0 | 1 | ERROR:#REF! | RB23 | € 0.00 |
| 9007 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB24 | € 0.00 |
| 9008 | Spouses | 0 | 1 | ERROR:#REF! | RB25 | € 0.00 |
| 9009 | Children | 0 | 1 | ERROR:#REF! | RB26 | € 0.00 |
| 9010 | Régime Alsace Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB27 | € 0.00 |
| 9011 | Spouses | 0 | 1 | ERROR:#REF! | RB28 | € 0.00 |
| 9012 | Children | 0 | 1 | ERROR:#REF! | RB29 | € 0.00 |
| 9013 | Régime Alsace Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB30 | € 0.00 |
| 9014 | Spouses | 0 | 1 | ERROR:#REF! | RB31 | € 0.00 |
| 9015 | Children | 0 | 1 | ERROR:#REF! | RB32 | € 0.00 |
| 9016 | Régime Alsace Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB33 | € 0.00 |
| 9017 | Spouses | 0 | 1 | ERROR:#REF! | RB34 | € 0.00 |
| 9018 | Children | 0 | 1 | ERROR:#REF! | RB35 | € 0.00 |
| C-2-2 High Option-Riffed employees, survivors and dependents affiliated to Social Security (Licencié, ayant droit, ayant droit de salarié décédé Régime Sécurité Sociale Option Haute) | ||||||
| 10001 | Former Employees | 0 | 1 | ERROR:#REF! | RB33 | € 0.00 |
| 10002 | Spouses | 0 | 1 | ERROR:#REF! | RB34 | € 0.00 |
| 10003 | Children | 0 | 1 | ERROR:#REF! | RB35 | € 0.00 |
Category D - Retirees, riffed employees, survivors and dependents Non-Affiliated to French Social Security
| D-1-1 Basic Option-Retirees, survivors and dependents not affiliated to Social Security (Retraité, ayant droit et ayant droit de salarié décédé Non Sécurité Sociale Option de Base) | 6 | |||||
| 11001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB1 | € 0.00 |
| 11002 | Spouses | 0 | 1 | ERROR:#REF! | RB2 | € 0.00 |
| 11003 | Children | 0 | 1 | ERROR:#REF! | RB3 | € 0.00 |
| 11004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB4 | € 0.00 |
| 11005 | Spouses | 0 | 1 | ERROR:#REF! | RB5 | € 0.00 |
| 11006 | Children | 0 | 1 | ERROR:#REF! | RB6 | € 0.00 |
| 11007 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB7 | € 0.00 |
| 11008 | Spouses | 0 | 1 | ERROR:#REF! | RB8 | € 0.00 |
| 11009 | Children | 0 | 1 | ERROR:#REF! | RB9 | € 0.00 |
| D-1-2 Basic Option-Riffed employees, survivors and dependents not affiliated to Social Security (Licencié, ayant droit et ayant droit de salarié décédé Non Sécurité Sociale Option de Base) | ||||||
| 12001 | Former Employees | 0 | 1 | ERROR:#REF! | RB17 | € 0.00 |
| 12002 | Spouses | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 12003 | Children | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| D-2-1 High Option-Retirees, survivors and dependents not affiliated to Social Security (Retraité, Ayant droit et ayant droit de salarié décédé NON Sécurité Sociale Option Haute) | 5 | |||||
| 13001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 13002 | Spouses | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| 13003 | Children | 0 | 1 | ERROR:#REF! | RB20 | € 0.00 |
| 13004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB21 | € 0.00 |
| 13005 | Spouses | 0 | 1 | ERROR:#REF! | RB22 | € 0.00 |
| 13006 | Children | 0 | 1 | ERROR:#REF! | RB23 | € 0.00 |
| 13007 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB24 | € 0.00 |
| 13008 | Spouses | 0 | 1 | ERROR:#REF! | RB25 | € 0.00 |
| 13009 | Children | 0 | 1 | ERROR:#REF! | RB26 | € 0.00 |
| D-3 High Option-Riffed employees, survivors and dependents not affiliated to Social Security (Licencié, Ayant droit et ayant droit de salarié décédé NON Sécurité Sociale Option Haute) | ||||||
| 14001 | Former Employees | 0 | 1 | ERROR:#REF! | RB33 | € 0.00 |
| 14002 | Spouses | 0 | 1 | ERROR:#REF! | RB34 | € 0.00 |
| 14003 | Children | 0 | 1 | ERROR:#REF! | RB35 | € 0.00 |
A-1 Health Prices Option Year 4
| ATTACHMENT A-1 - PRICES/PREMIUMS FOR MEDICAL COVERAGE FOR CATEGORIES NOT ON THE PAYROLL | ||||||
| CLIN | Current Global Estimated Number of Members | Estimated Members | Premium per Month & per Member, € | Total Amount for one contract year, € | AG2R Category | Total Amount for twelve months, € |
Category C - Retirees, riffed employees, survivors and dependents Affiliated to French Social Security
| C-1-1 Basic Option-Retirees, survivors and dependents affiliated to Social Security (Retraité, ayant droit et ayant droit de salarié décédé Régime Sécurité Sociale Option de Base) | 123 | |||||
| 7001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB1 | € 0.00 |
| 7002 | Spouses | 0 | 1 | ERROR:#REF! | RB2 | € 0.00 |
| 7003 | Children | 0 | 1 | ERROR:#REF! | RB3 | € 0.00 |
| 7004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB4 | € 0.00 |
| 7005 | Spouses | 0 | 1 | ERROR:#REF! | RB5 | € 0.00 |
| 7006 | Children | 0 | 1 | ERROR:#REF! | RB6 | € 0.00 |
| 7016 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB7 | € 0.00 |
| 7017 | Spouses | 0 | 1 | ERROR:#REF! | RB8 | € 0.00 |
| 7018 | Children | 0 | 1 | ERROR:#REF! | RB9 | € 0.00 |
| 7019 | Régime Alsace Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB10 | € 0.00 |
| 7020 | Spouses | 0 | 1 | ERROR:#REF! | RB11 | € 0.00 |
| 7021 | Children | 0 | 1 | ERROR:#REF! | RB12 | € 0.00 |
| 7022 | Régime Alsace Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB13 | € 0.00 |
| 7023 | Spouses | 0 | 1 | ERROR:#REF! | RB14 | € 0.00 |
| 7024 | Children | 0 | 1 | ERROR:#REF! | RB15 | € 0.00 |
| 7034 | Régime Alsace Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB16 | € 0.00 |
| 7035 | Spouses | 0 | 1 | ERROR:#REF! | RB17 | € 0.00 |
| 7036 | Children | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| C-1-2 Basic Option-Riffed employees, survivors and dependents affiliated to Social Security (Licencié, ayant droit et ayant droit de salarié décédé Régime Sécurité Sociale Option de Base) | ||||||
| 8001 | Former Employees | 0 | 1 | ERROR:#REF! | RB17 | € 0.00 |
| 8002 | Spouses | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 8003 | Children | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| C-2-1 High Option-Retirees, survivors and dependents affiliated to Social Security (Retraité, ayant droit, ayant droit de salarié décédé Régime Sécurité Sociale Option Haute) | 106 | |||||
| 9001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 9002 | Spouses | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| 9003 | Children | 0 | 1 | ERROR:#REF! | RB20 | € 0.00 |
| 9004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB21 | € 0.00 |
| 9005 | Spouses | 0 | 1 | ERROR:#REF! | RB22 | € 0.00 |
| 9006 | Children | 0 | 1 | ERROR:#REF! | RB23 | € 0.00 |
| 9007 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB24 | € 0.00 |
| 9008 | Spouses | 0 | 1 | ERROR:#REF! | RB25 | € 0.00 |
| 9009 | Children | 0 | 1 | ERROR:#REF! | RB26 | € 0.00 |
| 9010 | Régime Alsace Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB27 | € 0.00 |
| 9011 | Spouses | 0 | 1 | ERROR:#REF! | RB28 | € 0.00 |
| 9012 | Children | 0 | 1 | ERROR:#REF! | RB29 | € 0.00 |
| 9013 | Régime Alsace Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB30 | € 0.00 |
| 9014 | Spouses | 0 | 1 | ERROR:#REF! | RB31 | € 0.00 |
| 9015 | Children | 0 | 1 | ERROR:#REF! | RB32 | € 0.00 |
| 9016 | Régime Alsace Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB33 | € 0.00 |
| 9017 | Spouses | 0 | 1 | ERROR:#REF! | RB34 | € 0.00 |
| 9018 | Children | 0 | 1 | ERROR:#REF! | RB35 | € 0.00 |
| C-2-2 High Option-Riffed employees, survivors and dependents affiliated to Social Security (Licencié, ayant droit, ayant droit de salarié décédé Régime Sécurité Sociale Option Haute) | ||||||
| 10001 | Former Employees | 0 | 1 | ERROR:#REF! | RB33 | € 0.00 |
| 10002 | Spouses | 0 | 1 | ERROR:#REF! | RB34 | € 0.00 |
| 10003 | Children | 0 | 1 | ERROR:#REF! | RB35 | € 0.00 |
Category D - Retirees, riffed employees, survivors and dependents Non-Affiliated to French Social Security
| D-1-1 Basic Option-Retirees, survivors and dependents not affiliated to Social Security (Retraité, ayant droit et ayant droit de salarié décédé Non Sécurité Sociale Option de Base) | 6 | |||||
| 11001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB1 | € 0.00 |
| 11002 | Spouses | 0 | 1 | ERROR:#REF! | RB2 | € 0.00 |
| 11003 | Children | 0 | 1 | ERROR:#REF! | RB3 | € 0.00 |
| 11004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB4 | € 0.00 |
| 11005 | Spouses | 0 | 1 | ERROR:#REF! | RB5 | € 0.00 |
| 11006 | Children | 0 | 1 | ERROR:#REF! | RB6 | € 0.00 |
| 11007 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB7 | € 0.00 |
| 11008 | Spouses | 0 | 1 | ERROR:#REF! | RB8 | € 0.00 |
| 11009 | Children | 0 | 1 | ERROR:#REF! | RB9 | € 0.00 |
| D-1-2 Basic Option-Riffed employees, survivors and dependents not affiliated to Social Security (Licencié, ayant droit et ayant droit de salarié décédé Non Sécurité Sociale Option de Base) | ||||||
| 12001 | Former Employees | 0 | 1 | ERROR:#REF! | RB17 | € 0.00 |
| 12002 | Spouses | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 12003 | Children | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| D-2-1 High Option-Retirees, survivors and dependents not affiliated to Social Security (Retraité, Ayant droit et ayant droit de salarié décédé NON Sécurité Sociale Option Haute) | 5 | |||||
| 13001 | Retirees , up to 69 years old | 0 | 1 | ERROR:#REF! | RB18 | € 0.00 |
| 13002 | Spouses | 0 | 1 | ERROR:#REF! | RB19 | € 0.00 |
| 13003 | Children | 0 | 1 | ERROR:#REF! | RB20 | € 0.00 |
| 13004 | Retirees , 70 to 80 years old | 0 | 1 | ERROR:#REF! | RB21 | € 0.00 |
| 13005 | Spouses | 0 | 1 | ERROR:#REF! | RB22 | € 0.00 |
| 13006 | Children | 0 | 1 | ERROR:#REF! | RB23 | € 0.00 |
| 13007 | Retirees , More than 81 years old | 0 | 1 | ERROR:#REF! | RB24 | € 0.00 |
| 13008 | Spouses | 0 | 1 | ERROR:#REF! | RB25 | € 0.00 |
| 13009 | Children | 0 | 1 | ERROR:#REF! | RB26 | € 0.00 |
| D-3 High Option-Riffed employees, survivors and dependents not affiliated to Social Security (Licencié, Ayant droit et ayant droit de salarié décédé NON Sécurité Sociale Option Haute) | ||||||
| 14001 | Former Employees | 0 | 1 | ERROR:#REF! | RB33 | € 0.00 |
| 14002 | Spouses | 0 | 1 | ERROR:#REF! | RB34 | € 0.00 |
| 14003 | Children | 0 | 1 | ERROR:#REF! | RB35 | € 0.00 |
File details come from the government source that posted it. Updated .