Attachment 1 - Pricing.xlsx
XLSX spreadsheet 25 KB Posted
- Attached to
- Health and Life Insurance, US Embassy Cairo
- Solicitation number
- 19GE5021R0009
About this file
This solicitation seeks proposals for health and life insurance services for locally engaged staff at the US Embassy in Cairo, Egypt. Offerors must complete the pricing spreadsheet in Attachment 1, including biweekly rates for single and family health insurance, life insurance premiums, and optional riders. Proposals are due by February 26, 2021 to the Regional Procurement Support Office in Frankfurt, Germany. The anticipated award period is one base year with four one-year options. The Department of State is the contracting agency.
View the file
Other files
Show all 28
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
D.1 Health Insurance
| D.1.1 Base year | ||||
| CLIN 0001 | Bi weekly Rate per employee | estimated number of employees | rate per employee | Bi-weekly total |
| 0001a | Single Employees (Self only) | 400 | 0 | |
| 0001b | Family Plan | 1100 | 0 | |
| Sub Total | 0 | |||
| Total Price for Base year | 0 | |||
| D.1.2 Option year one | ||||
| CLIN 1001 | Bi weekly Rate per employee | estimated number of employees | rate per employee | Bi-weekly total |
| 1001a | Single Employees (Self only) | 400 | 0 | |
| 1001b | Family Plan | 1100 | 0 | |
| Sub Total | 0 | |||
| Total Price for Option year one | 0 | |||
| D.1.3 Option year two | ||||
| CLIN 2001 | Bi weekly Rate per employee | estimated number of employees | rate per employee | Bi-weekly total |
| 2001a | Single Employees (Self only) | 400 | 0 | |
| 2001b | Family Plan | 1100 | 0 | |
| Sub Total | 0 | |||
| Total Price for Option year two | 0 | |||
| D.1.4 Option year three | ||||
| CLIN 3001 | Bi weekly Rate per employee | estimated number of employees | rate per employee | Bi-weekly total |
| 3001a | Single Employees (Self only) | 400 | 0 | |
| 3001b | Family Plan | 1100 | 0 | |
| Sub Total | 0 | |||
| Total Price for Option year three | 0 | |||
| D.1.5 Option year four | ||||
| CLIN 4001 | Bi weekly Rate per employee | estimated number of employees | rate per employee | Bi-weekly total |
| 4001a | Single Employees (Self only) | 400 | 0 | |
| 4001b | Family Plan | 1100 | 0 | |
| Sub Total | 0 | |||
| Total Price for Option year four | 0 | |||
| D.1.6 Grand Total for Base plus 4 Option Years | ||||
| Base year total | 0 | |||
| Option year one total | 0 | |||
| Option year two total | 0 | |||
| Option year three total | 0 | |||
| Option year four total | 0 | |||
| Grand Total Base plus 4 Option years | 0 | |||
| highlighted cells to be completed by offeror |
D.2 Health Insurance Rider
| This section will NOT be evaluated as part of the overall price evaluation. |
| Riders will not be covered under the annual task order |
| D.2.1 Base year | |
| Category | Bi weekly rate per employee |
| ORE Staff, AECWA Staff, and their Dependents | |
| D.2.2 Option year one | |
| Category | Bi weekly rate per employee |
| ORE Staff, AECWA Staff, and their Dependents | |
| D.2.3 Option year two | |
| Category | Bi weekly rate per employee |
| ORE Staff, AECWA Staff, and their Dependents | |
| D.2.4 Option year three | |
| Category | Bi weekly rate per employee |
| ORE Staff, AECWA Staff, and their Dependents | |
| D.2.5 Option year four | |
| Category | Bi weekly rate per employee |
| ORE Staff, AECWA Staff, and their Dependents | |
| highlighted cells to be completed by offeror |
D.3 Retention amounts
| D.3.2 Bi weekly retention amounts | ||
| Period of Performance | Single Employees (Self Onyl) | Family Plan |
| Base year | ||
| Option year one | ||
| Option year two | ||
| Option year three | ||
| Option year four | ||
| highlighted cells to be completed by offeror |
D.4 Life Insurance
| D.4.1 Base year | ||||
| CLIN 0002 | Bi weekly Rate per employee | Premium per 1,0000 of Salary | estimated avarage payroll (bi weekly in thousands) | Bi-weekly total |
| 0002a | Basic Life | EGP 5,279.00 | 0 | |
| 0002b | Accidental Death and Dismemberment | EGP 5,279.00 | 0 | |
| 0002c | Partial and Total Disability | EGP 5,279.00 | ||
| Sub Total | 0 | |||
| Total Price for Base year | 0 | |||
| D.4.2 Option year one | ||||
| CLIN 1002 | Bi weekly Rate per employee | Premium per 1,0000 of Salary | estimated avarage payroll (bi weekly in thousands) | Bi-weekly total |
| 1002a | Basic Life | EGP 5,279.00 | 0 | |
| 1002b | Accidental Death and Dismemberment | EGP 5,279.00 | 0 | |
| 1002c | Partial and Total Disability | EGP 5,279.00 | ||
| Sub Total | 0 | |||
| Total Price for Option year one | 0 | |||
| D.4.3 Option year two | ||||
| CLIN 2002 | Bi weekly Rate per employee | Premium per 1,0000 of Salary | estimated avarage payroll (bi weekly in thousands) | Bi-weekly total |
| 2002a | Basic Life | EGP 5,279.00 | 0 | |
| 2002b | Accidental Death and Dismemberment | EGP 5,279.00 | 0 | |
| 2002c | Partial and Total Disability | EGP 5,279.00 | ||
| Sub Total | 0 | |||
| Total Price for Option year two | 0 | |||
| D.4.4 Option year three | ||||
| CLIN 3002 | Bi weekly Rate per employee | Premium per 1,0000 of Salary | estimated avarage payroll (bi weekly in thousands) | Bi-weekly total |
| 3002a | Basic Life | EGP 5,279.00 | 0 | |
| 3002b | Accidental Death and Dismemberment | EGP 5,279.00 | 0 | |
| 3002c | Partial and Total Disability | EGP 5,279.00 | ||
| Sub Total | 0 | |||
| Total Price for Option year three | 0 | |||
| D.4.5 Option year four | ||||
| CLIN 4002 | Bi weekly Rate per employee | Premium per 1,0000 of Salary | estimated avarage payroll (bi weekly in thousands) | Bi-weekly total |
| 4002a | Basic Life | EGP 5,279.00 | 0 | |
| 4002b | Accidental Death and Dismemberment | EGP 5,279.00 | 0 | |
| 4002c | Partial and Total Disability | EGP 5,279.00 | ||
| Sub Total | 0 | |||
| Total Price for Option year four | 0 | |||
| D.4.6 Grand Total for Base plus 4 Option Years | ||||
| Base year total | 0 | |||
| Option year one total | 0 | |||
| Option year two total | 0 | |||
| Option year three total | 0 | |||
| Option year four total | 0 | |||
| Grand Total Base plus 4 Option years | 0 | |||
| highlighted cells to be completed by offeror |
D.5 Life Insurance Rider
| This section will NOT be evaluated as part of the overall price evaluation. |
| Riders will not be covered under the annual task order |
| D.5.1 Base year | |
| Category | Bi weekly rate per employee |
| ORE Staff, AECWA Staff, and their Dependents | |
| D.5.2 Option year one | |
| Category | Bi weekly rate per employee |
| ORE Staff, AECWA Staff, and their Dependents | |
| D.5.3 Option year two | |
| Category | Bi weekly rate per employee |
| ORE Staff, AECWA Staff, and their Dependents | |
| D.5.4 Option year three | |
| Category | Bi weekly rate per employee |
| ORE Staff, AECWA Staff, and their Dependents | |
| D.5.5 Option year four | |
| Category | Bi weekly rate per employee |
| ORE Staff, AECWA Staff, and their Dependents | |
| highlighted cells to be completed by offeror |
Grand Total
| Total estimated contract amount | |
| Total Health Insurance | 0 |
| Total Life Insurance | 0 |
| Grand Total | 0 |
| curreny: | |
| highlighted cells to be completed by offeror |
File details come from the government source that posted it. Updated .