Attachment 1 - Pricing_amendment 0009.xlsx

XLSX spreadsheet 25 KB Posted

Attached to
Health and Life Insurance, US Embassy Cairo
Solicitation number
19GE5021R0009
Issued by

About this file

This document contains an attachment to a solicitation for health and life insurance services. The Regional Procurement Support Office in Frankfurt is soliciting proposals on behalf of the US Embassy in Cairo, Egypt for health and life insurance to cover locally engaged staff. Offerors should complete the pricing tables in Attachment 1 by February 26, 2021 at 3:00pm German time and submit their proposals to the email addresses provided. The solicitation also contains representations and certifications in Section 5 that offerors must complete. Questions are due by February 9th and responses will be provided anonymously in an amendment. The services required include health insurance, life insurance, and associated riders for locally engaged staff and their dependents for a base year and four option years. Pricing should be provided in the offeror's preferred currency.

View the file

Other files

File Type Posted
19GE5021R0009_0009.pdf PDF
DOB report_amendent 0009.xlsx XLSX spreadsheet
Q and A set four 21R0009.pdf PDF
19GE5021R0009_0008.pdf PDF
19GE5021R0009_0007.pdf PDF
19GE5021R0009_0006.pdf PDF
Embassy Egypt CS Claims Analysis May 1 through Oct 31 2018.pdf PDF
19GE5021R0009_00005.pdf PDF
Claims Report_Life insurance_corrected_00004.xlsx XLSX spreadsheet
19GE5021R0009_0004.pdf PDF
DOB report_19GE5021R0009_A0003.pdf PDF
19GE5021R0009_00003_Q and A_set three.pdf PDF
19GE5021R0009_0003.pdf PDF
DEPENDENT_DATA_19GE5021R0009_A0003.pdf PDF
Claims Report_Life insurance.xlsx XLSX spreadsheet
19GE5021R0009_0002.pdf PDF
19GE5021R0009_Q and A_ set two.pdf PDF
19GE5021R0009_00001_Q and A_set one.pdf PDF
SAM.zip ZIP file
DOB report.pdf PDF
19GE5021R0009_00001.pdf PDF
Table of Benefits 2019.pdf PDF
Claims analysis.zip ZIP file
Attachment 2 - Experience and Past Performance.docx DOCX document
19GE5021R0009.pdf PDF
Attachment 3 - Form W-14.pdf PDF
Attachment 1 - Pricing.xlsx XLSX spreadsheet
Exhibits A_ B and C.pdf PDF
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 0001Bi weekly Rate per employeeestimated number of employeesrate per employeeBi-weekly total
0001aSingle Employees (Self only)4000
0001bFamily Plan11000
Sub Total0
Total Price for Base year0
D.1.2 Option year one
CLIN 1001Bi weekly Rate per employeeestimated number of employeesrate per employeeBi-weekly total
1001aSingle Employees (Self only)4000
1001bFamily Plan11000
Sub Total0
Total Price for Option year one0
D.1.3 Option year two
CLIN 2001Bi weekly Rate per employeeestimated number of employeesrate per employeeBi-weekly total
2001aSingle Employees (Self only)4000
2001bFamily Plan11000
Sub Total0
Total Price for Option year two0
D.1.4 Option year three
CLIN 3001Bi weekly Rate per employeeestimated number of employeesrate per employeeBi-weekly total
3001aSingle Employees (Self only)4000
3001bFamily Plan11000
Sub Total0
Total Price for Option year three0
D.1.5 Option year four
CLIN 4001Bi weekly Rate per employeeestimated number of employeesrate per employeeBi-weekly total
4001aSingle Employees (Self only)4000
4001bFamily Plan11000
Sub Total0
Total Price for Option year four0
D.1.6 Grand Total for Base plus 4 Option Years
Base year total0
Option year one total0
Option year two total0
Option year three total0
Option year four total0
Grand Total Base plus 4 Option years0
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
CategoryBi weekly rate per employee
ORE Staff, AECWA Staff, and their Dependents
D.2.2 Option year one
CategoryBi weekly rate per employee
ORE Staff, AECWA Staff, and their Dependents
D.2.3 Option year two
CategoryBi weekly rate per employee
ORE Staff, AECWA Staff, and their Dependents
D.2.4 Option year three
CategoryBi weekly rate per employee
ORE Staff, AECWA Staff, and their Dependents
D.2.5 Option year four
CategoryBi 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 PerformanceSingle 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 0002Bi weekly Rate per employeePremium per 1,0000 of Salaryestimated avarage payroll (bi weekly in thousands)Bi-weekly total
0002aBasic LifeEGP 10,488.000
0002bAccidental Death and DismembermentEGP 10,488.000
0002cPartial and Total DisabilityEGP 10,488.000
Sub Total0
Total Price for Base year0
D.4.2 Option year one
CLIN 1002Bi weekly Rate per employeePremium per 1,0000 of Salaryestimated avarage payroll (bi weekly in thousands)Bi-weekly total
1002aBasic LifeEGP 10,488.000
1002bAccidental Death and DismembermentEGP 10,488.000
1002cPartial and Total DisabilityEGP 10,488.000
Sub Total0
Total Price for Option year one0
D.4.3 Option year two
CLIN 2002Bi weekly Rate per employeePremium per 1,0000 of Salaryestimated avarage payroll (bi weekly in thousands)Bi-weekly total
2002aBasic LifeEGP 10,488.000
2002bAccidental Death and DismembermentEGP 10,488.000
2002cPartial and Total DisabilityEGP 10,488.000
Sub Total0
Total Price for Option year two0
D.4.4 Option year three
CLIN 3002Bi weekly Rate per employeePremium per 1,0000 of Salaryestimated avarage payroll (bi weekly in thousands)Bi-weekly total
3002aBasic LifeEGP 10,488.000
3002bAccidental Death and DismembermentEGP 10,488.000
3002cPartial and Total DisabilityEGP 10,488.000
Sub Total0
Total Price for Option year three0
D.4.5 Option year four
CLIN 4002Bi weekly Rate per employeePremium per 1,0000 of Salaryestimated avarage payroll (bi weekly in thousands)Bi-weekly total
4002aBasic LifeEGP 10,488.000
4002bAccidental Death and DismembermentEGP 10,488.000
4002cPartial and Total DisabilityEGP 10,488.000
Sub Total0
Total Price for Option year four0
D.4.6 Grand Total for Base plus 4 Option Years
Base year total0
Option year one total0
Option year two total0
Option year three total0
Option year four total0
Grand Total Base plus 4 Option years0
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
CategoryBi weekly rate per employee
ORE Staff, AECWA Staff, and their Dependents
D.5.2 Option year one
CategoryBi weekly rate per employee
ORE Staff, AECWA Staff, and their Dependents
D.5.3 Option year two
CategoryBi weekly rate per employee
ORE Staff, AECWA Staff, and their Dependents
D.5.4 Option year three
CategoryBi weekly rate per employee
ORE Staff, AECWA Staff, and their Dependents
D.5.5 Option year four
CategoryBi 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 Insurance0
Total Life Insurance0
Grand Total0
curreny:
highlighted cells to be completed by offeror

File details come from the government source that posted it. Updated .