Attachment 1 - Pricing.xlsx
XLSX spreadsheet 20 KB Posted
- Solicitation number
- 19GE5025R0029
About this file
The file is a Pricing Attachment for a Life Insurance solicitation (Solicitation Number 19GE5025R0029) for Locally Employed Staff at the U.S. Embassy in Ankara, Turkey. The pricing table details a comprehensive life insurance premium structure across five age categories for base year and four subsequent option years, with consistent employee distribution: 44 employees aged 24-30, 260 employees aged 31-40, 342 employees aged 31-50, 207 employees aged 51-60, and 28 employees aged 61+. The document breaks down monthly premiums for natural death and accidental death for each age category, allowing for precise cost calculation across the contract's potential five-year duration. The solicitation is issued by the Department of State Office of Acquisition Management's Regional Procurement Support Office (RPSO) Frankfurt, seeking proposals for life insurance coverage for locally employed embassy staff.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment 1 - Pricing (A0003).xlsx | XLSX spreadsheet | |
| 19GE5025R0029_A0003.pdf | ||
| 19GE5025R0029_0002.pdf | ||
| Exhibit B - Census Data.xlsx | XLSX spreadsheet | |
| 19GE5025R0029_0001.pdf | ||
| Attachment 2 - Past Performance.docx | DOCX document | |
| Cover Letter.pdf | ||
| Solicitation 19GE5025R0029.pdf | ||
| Exhibit A - Employee and Annual Salary Statistics.xlsx | XLSX spreadsheet | |
| Instructions for Form W-14.pdf | ||
| Attachment 3 - Form W-14.pdf |
Show all 11
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
Pricing Table
| 19GE5025R0029 - Attachment 1 - Pricing | ||||
| CLIN 001 BASE YEAR | ||||
| Sub-CLIN | Description | Number of Employees | Monthly | |
| Natural Death Premium p.P. | Monthly | |||
| Accidental Death Premium p.P. | Monthly | |||
| Total Premium p.P. | Subtotal per year |
all employees
| 001A | Age Category 24 - 30 | 44 | ||
| 001B | Age Category 31 - 40 | 260 | ||
| 001C | Age Category 31 - 50 | 342 | ||
| 001D | Age Category 51 - 60 | 207 | ||
| 001E | Age Category 61+ | 28 | ||
| Total Base Year | ||||
| CLIN 1001 OPTION YEAR 1 | ||||
| Sub-CLIN | Description | Number of Employees | Monthly | |
| Natural Death Premium p.P. | Monthly | |||
| Accidental Death Premium p.P. | Monthly | |||
| Total Premium p.P. | Subtotal per year |
all employees
| 1001A | Age Category 24 - 30 | 44 | ||
| 1001B | Age Category 31 - 40 | 260 | ||
| 1001C | Age Category 31 - 50 | 342 | ||
| 1001D | Age Category 51 - 60 | 207 | ||
| 1001E | Age Category 61+ | 28 | ||
| Total Option Year 1 | ||||
| CLIN 2001 OPTION YEAR | ||||
| Sub-CLIN | Description | Number of Employees | Monthly | |
| Natural Death Premium p.P. | Monthly | |||
| Accidental Death Premium p.P. | Monthly | |||
| Total Premium p.P. | Subtotal per year |
all employees
| 2001A | Age Category 24 - 30 | 44 | ||
| 2001B | Age Category 31 - 40 | 260 | ||
| 2001C | Age Category 31 - 50 | 342 | ||
| 2001D | Age Category 51 - 60 | 207 | ||
| 2001E | Age Category 61+ | 28 | ||
| Total Option Year 2 | ||||
| CLIN 3001 OPTION YEAR 3 | ||||
| Sub-CLIN | Description | Number of Employees | Monthly | |
| Natural Death Premium p.P. | Monthly | |||
| Accidental Death Premium p.P. | Monthly | |||
| Total Premium p.P. | Subtotal per year |
all employees
| 3001A | Age Category 24 - 30 | 44 | ||
| 3001B | Age Category 31 - 40 | 260 | ||
| 3001C | Age Category 31 - 50 | 342 | ||
| 3001D | Age Category 51 - 60 | 207 | ||
| 3001E | Age Category 61+ | 28 | ||
| Total Option Year 3 | ||||
| CLIN 4001 OPTION YEAR 4 | ||||
| Sub-CLIN | Description | Number of Employees | Monthly | |
| Natural Death Premium p.P. | Monthly | |||
| Accidental Death Premium p.P. | Monthly | |||
| Total Premium p.P. | Subtotal per year |
all employees
| 4001A | Age Category 24 - 30 | 44 |
| 4001B | Age Category 31 - 40 | 260 |
| 4001C | Age Category 31 - 50 | 342 |
| 4001D | Age Category 51 - 60 | 207 |
| 4001E | Age Category 61+ | 28 |
| Total Option Year 4 |
Total
| Base Year | 0 |
| Option Year One | 0 |
| Option Year Two | 0 |
| Option Year Three | 0 |
| Option Year Four | 0 |
| Total Contract Amount | 0 |
| Currency |
File details come from the government source that posted it. Updated .