Attachment 1 - Pricing.xlsx
XLSX spreadsheet 22 KB Posted
- Solicitation number
- 19GE5025R0003
About this file
This is a pricing template spreadsheet for health insurance coverage for Locally Employed Staff at the U.S. Embassy in Georgetown, Guyana. The template includes pricing tables for a base year and four option years, with three coverage tiers: Single Employees (Self Only), Employee + 1 (spouse or child), and Family Plan.
The staffing numbers show gradual increases over the contract period, starting with 31 single employees, 20 employee+1, and 56 family plans in the base year, growing to 44 single employees, 28 employee+1, and 80 family plans by Option Year 4. The template requires vendors to input monthly rates which will automatically calculate annual rates and subtotals for each coverage tier, with a grand total for the base year plus all option years. The solicitation number is 19GE5025R0003, with proposal submissions due January 13, 2025, and questions due by December 18, 2024 at 14:00 CET.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Exhibit A - Employee Statistic.pdf | ||
| Attachment 5 - QUESTIONS.pdf | ||
| Attachment 7 - Claims Data.pdf | ||
| 19GE5025R0003-0001.pdf | ||
| Attachment 6 - Average Insured Member Count.pdf | ||
| Exhibit A - Employee Statistic.docx | DOCX document | |
| Solicitation 19GE5025R0003.pdf | ||
| Attachment 2 - Past Performance.docx | DOCX document | |
| Attachment 4 - Instructions to complete W-14.pdf | ||
| Attachment 3 - Form W-14.pdf |
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 Tables
| BASE YEAR | |||||||
| Sub-CLIN | Description | Number of Employees | UNIT | Rate per month | Rate per Year | Subtotal | |
| 0001A | Single Employees (Self Only) | 31 | PER PERSON | 0 | $0.00 | 3.1 | |
| 0001B | Employee + 1 (either plus one spouse or plus one child) | 20 | PER COUPLE | 0 | $0.00 | ||
| 0001C | Family Plan | 56 | PER FAMILY | 0 | $0.00 | ||
| BASE YEAR TOTAL | $0.00 | ||||||
| OPTION YEAR 1 | |||||||
| Sub-CLIN | Description | Number of Employees | UNIT | Rate per month | Rate per Year | Subtotal | |
| 1001A | Single Employees (Self Only) | 34 | PER PERSON | 0 | $0.00 | ||
| 1001B | Employee + 1 (either plus one spouse or plus one child) | 22 | PER COUPLE | 0 | $0.00 | ||
| 1001C | Family Plan | 61 | PER FAMILY | 0 | $0.00 | ||
| OPTION YEAR 1 TOTAL | $0.00 | ||||||
| OPTION YEAR 2 | |||||||
| Sub-CLIN | Description | Number of Employees | UNIT | Rate per month | Rate per Year | Subtotal | |
| 2001A | Single Employees (Self Only) | 37 | PER PERSON | 0 | $0.00 | ||
| 2001B | Employee + 1 (either plus one spouse or plus one child) | 24 | PER COUPLE | 0 | $0.00 | ||
| 2001C | Family Plan | 67 | PER FAMILY | 0 | $0.00 | ||
| OPTION YEAR 2 TOTAL | $0.00 | ||||||
| OPTION YEAR 3 | |||||||
| Sub-CLIN | Description | Number of Employees | UNIT | Rate per month | Rate per Year | Subtotal | |
| 3001A | Single Employees (Self Only) | 40 | PER PERSON | 0 | $0.00 | ||
| 3001B | Employee + 1 (either plus one spouse or plus one child) | 26 | PER COUPLE | 0 | $0.00 | ||
| 3001C | Family Plan | 73 | PER FAMILY | 0 | $0.00 | ||
| OPTION YEAR 3 TOTAL | $0.00 | ||||||
| OPTION YEAR 4 | |||||||
| Sub-CLIN | Description | Number of Employees | UNIT | Rate per month | Rate per Year | Subtotal | |
| 4001A | Single Employees (Self Only) | 44 | PER PERSON | 0 | $0.00 | ||
| 4001B | Employee + 1 (either plus one spouse or plus one child) | 28 | PER COUPLE | 0 | $0.00 | ||
| 4001C | Family Plan | 80 | PER FAMILY | 0 | $0.00 | ||
| OPTION YEAR 4 TOTAL | $0.00 | ||||||
| GRAND TOTAL (BASE + ALL OPTIONS) | $0.00 |
SGE50017R0136
Locally Engaged Staff Health Insurance Attachment 1 Pricing Schedule
File details come from the government source that posted it. Updated .