19GE5026Q0035-Attachment-3-Pricing-Schedule.xlsx
XLSX spreadsheet 29 KB Posted
- Solicitation number
- 19GE5026Q0035
About this file
This is a Pricing Schedule template for a health insurance services solicitation issued by the Department of State Regional Procurement Support Office Frankfurt for locally employed staff (LES) and eligible dependents at the U.S. Embassy in Lisbon, Portugal. The pricing schedule is structured as a firm-fixed-price Indefinite Delivery/Indefinite Quantity (IDIQ) contract with a base year and four optional one-year periods, with services commencing no later than January 1, 2027.
The pricing template requires offerors to submit bi-weekly rates for three coverage categories: Single Employees (Self Only) covering 31 members, Employee + 1 covering 56 members, and Family Plan covering 122 members. Rates must be provided for the Base Year, Year 1, Year 2, Year 3, and Year 4, with offerors calculating the annual rate (bi-weekly rate multiplied by 26 pay periods) and subtotals (annual rate multiplied by number of members) for each category and performance period. The template also includes a section for Monthly Retention Amounts across all contract periods. All pricing cells are highlighted for completion by the offeror, with a note that estimated quantities are for evaluation purposes only and actual member numbers may vary. The currency for pricing submission must be specified by the offeror.
View the file
Other files
Show all 12
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
| Attachment 3 - Pricing Schedule |
| Solicitation 19GE5026Q0035 |
| Highlighted cells to be completed by the offeror! |
| BASE YEAR |
| A | B | C | E | F | |||
| Sub-CLIN | Description | *Number of Members (Employee + Dependents) | UNIT | Bi-weekly rate (26 Pay Periods) | Rate per year | ||
| (C*26) | Subtotal |
(A*E)
| 0001 | Single Employees (Self Only) | 31 | Bi-Weekly | 0 | 0 |
| 0002 | Employee + 1 (either plus one spouse or plus one child) | 56 | Bi-Weekly | 0 | 0 |
| 0003 | Family Plan | 122 | Bi-Weekly | 0 | 0 |
| **BASE YEAR TOTAL | 0 |
YEAR 1
| A | B | C | E | F | |||
| Sub-CLIN | Description | *Number of Members (Employee + Dependents) | UNIT | Bi-weekly rate (26 Pay Periods) | Rate per year | ||
| (C*26) | Subtotal |
(A*E)
| 1001 | Single Employees (Self Only) | 31 | Bi-Weekly | 0 | 0 |
| 1002 | Employee + 1 (either plus one spouse or plus one child) | 56 | Bi-Weekly | 0 | 0 |
| 1003 | Family Plan | 122 | Bi-Weekly | 0 | 0 |
| ** YEAR 1 TOTAL | 0 |
YEAR 2
| A | B | C | E | F | |||
| Sub-CLIN | Description | *Number of Members (Employee + Dependents) | UNIT | Bi-weekly rate (26 Pay Periods) | Rate per year | ||
| (C*26) | Subtotal |
(A*E)
| 2001 | Single Employees (Self Only) | 31 | Bi-Weekly | 0 | 0 |
| 2002 | Employee + 1 (either plus one spouse or plus one child) | 56 | Bi-Weekly | 0 | 0 |
| 2003 | Family Plan | 122 | Bi-Weekly | 0 | 0 |
| ** YEAR 2 TOTAL | 0 |
YEAR 3
| A | B | C | E | F | |||
| Sub-CLIN | Description | *Number of Members (Employee + Dependents) | UNIT | Bi-weekly rate (26 Pay Periods) | Rate per year | ||
| (C*26) | Subtotal |
(A*E)
| 3001 | Single Employees (Self Only) | 31 | Bi-Weekly | 0 | 0 |
| 3002 | Employee + 1 (either plus one spouse or plus one child) | 56 | Bi-Weekly | 0 | 0 |
| 3003 | Family Plan | 122 | Bi-Weekly | 0 | 0 |
| ** YEAR 3 TOTAL | 0 |
YEAR 4
| A | B | C | E | F | |||
| Sub-CLIN | Description | *Number of Members (Employee + Dependents) | UNIT | Bi-weekly rate (26 Pay Periods) | Rate per year | ||
| (C*26) | Subtotal |
(A*E)
| 4001 | Single Employees (Self Only) | 31 | Bi-Weekly | 0 | 0 |
| 4002 | Employee + 1 (either plus one spouse or plus one child) | 56 | Bi-Weekly | 0 | 0 |
| 4003 | Family Plan | 122 | Bi-Weekly | 0 | 0 |
| ** YEAR 4 TOTAL | 0 |
| TOTAL |
| Base Year |
| Year 1 |
| Year 2 |
| Year 3 |
| Year 4 |
| TOTAL: |
OFFEROR'S CURRENCY:
| *Estimated quantity for evaluation purposes only and do not bind the Government. Actual number may be lower or higher than the estimates in the solicitation/contract. |
| ** Does not include any premiums for Riders. |
| Sub-Section B.3.3 - Monthly Retention Amounts | |||
| Period of Performance | Single Employees (Self only) | Employee + 1 | Family |
| Base Period | |||
| Year 1 | |||
| Year 2 | |||
| Year 3 | |||
| Year 4 |
SGE50017R0136
Locally Engaged Staff Health Insurance Attachment 1 Pricing Schedule
File details come from the government source that posted it. Updated .