Attachment 1 - Price Proposal Breakdown.xlsx
XLSX spreadsheet 26 KB Posted
- Solicitation number
- 19GE5026R0003
About this file
This file is a Pricing Proposal Breakdown template for a Locally Engaged Staff Health Insurance contract for the U.S. Embassy in Harare, Zimbabwe. The Excel spreadsheet provides a detailed pricing structure across five performance periods (base year and four option years), with six different coverage tiers ranging from single employee to family plans with up to five or more dependents. The pricing matrix allows offerors to input monthly unit rates per person or family, with columns for calculating total monthly premiums and annual totals.
The associated federal contract opportunity solicitation (19GE5026R0003) requires health insurance services to be provided by August 1, 2026, with a proposal submission deadline of February 6, 2026. Key requirements include having a physical address in Zimbabwe, authorization to operate in the country, and an active System for Award Management (SAM) registration. The solicitation is issued by the Department of State Office of Acquisition Management and includes a virtual pre-proposal conference on January 12, 2026, with participant email submissions required by January 9, 2026 and questions due by January 16, 2026.
View the file
Other files
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 Tables
| highlighted cells to be completed by the offeror | ||||||
| BASE YEAR | ||||||
| Sub-CLIN | Description | *Number of Members (Employee + Dependents) | UNIT | Rate per month | Total Monthly Premiums (D * G) | Total – Amount (G * 12) |
| 0001A | Single Employees (Self Only) | 22 | PER PERSON | 0 | 0 | |
| 0001B | Employee + 1 (either plus one spouse or plus one child) | 46 | PER COUPLE | 0 | 0 | |
| 0001C | Family Plan: Employee + 2 | 78 | PER PERSON | 0 | 0 | |
| 0001D | Family Plan: Employee + 3 | 140 | PER PERSON | 0 | 0 | |
| 0001E | Family Plan: Employee + 4 | 285 | PER PERSON | 0 | 0 | |
| 0001F | Family Plan: Employee + 5 or More | 275 | PER FAMILY | 0 | 0 | |
| **BASE YEAR TOTAL | 0 |
| OPTION YEAR 1 | ||||||
| Sub-CLIN | Description | *Number of Members (Employee + Dependents) | UNIT | Rate per month | Total Monthly Premiums (D * G) | Total – Amount (G * 12) |
| 1001A | Single Employees (Self Only) | 22 | PER PERSON | 0 | 0 | |
| 1001B | Employee + 1 (either plus one spouse or plus one child) | 46 | PER COUPLE | 0 | 0 | |
| 1001C | Family Plan: Employee + 2 | 78 | PER PERSON | 0 | 0 | |
| 1001D | Family Plan: Employee + 3 | 140 | PER PERSON | 0 | 0 | |
| 1001E | Family Plan: Employee + 4 | 285 | PER PERSON | 0 | 0 | |
| 1001F | Family Plan: Employee + 5 or More | 275 | PER FAMILY | 0 | 0 | |
| **OPTION YEAR 1 TOTAL | 0 |
| OPTION YEAR 2 | ||||||
| Sub-CLIN | Description | *Number of Members (Employee + Dependents) | UNIT | Rate per month | Total Monthly Premiums (D * G) | Total – Amount (G * 12) |
| 2001A | Single Employees (Self Only) | 22 | PER PERSON | 0 | 0 | |
| 2001B | Employee + 1 (either plus one spouse or plus one child) | 46 | PER COUPLE | 0 | 0 | |
| 2001C | Family Plan: Employee + 2 | 78 | PER PERSON | 0 | 0 | |
| 2001D | Family Plan: Employee + 3 | 140 | PER PERSON | 0 | 0 | |
| 2001E | Family Plan: Employee + 4 | 285 | PER PERSON | 0 | 0 | |
| 2001F | Family Plan: Employee + 5 or More | 275 | PER FAMILY | 0 | 0 | |
| **OPTION YEAR 2 TOTAL | 0 |
| OPTION YEAR 3 | ||||||
| Sub-CLIN | Description | *Number of Members (Employee + Dependents) | UNIT | Rate per month | Total Monthly Premiums (D * G) | Total – Amount (G * 12) |
| 3001A | Single Employees (Self Only) | 22 | PER PERSON | 0 | 0 | |
| 3001B | Employee + 1 (either plus one spouse or plus one child) | 46 | PER COUPLE | 0 | 0 | |
| 3001C | Family Plan: Employee + 2 | 78 | PER PERSON | 0 | 0 | |
| 3001D | Family Plan: Employee + 3 | 140 | PER PERSON | 0 | 0 | |
| 3001E | Family Plan: Employee + 4 | 285 | PER PERSON | 0 | 0 | |
| 3001F | Family Plan: Employee + 5 or More | 275 | PER FAMILY | 0 | 0 | |
| **OPTION YEAR 3 TOTAL | 0 |
| OPTION YEAR 4 | ||||||
| Sub-CLIN | Description | *Number of Members (Employee + Dependents) | UNIT | Rate per month | Total Monthly Premiums (D * G) | Total – Amount (G * 12) |
| 4001A | Single Employees (Self Only) | 22 | PER PERSON | 0 | 0 | |
| 4001B | Employee + 1 (either plus one spouse or plus one child) | 46 | PER COUPLE | 0 | 0 | |
| 4001C | Family Plan: Employee + 2 | 78 | PER PERSON | 0 | 0 | |
| 4001D | Family Plan: Employee + 3 | 140 | PER PERSON | 0 | 0 | |
| 4001E | Family Plan: Employee + 4 | 285 | PER PERSON | 0 | 0 | |
| 4001F | Family Plan: Employee + 5 or More | 275 | PER FAMILY | 0 | 0 | |
| **OPTION YEAR 4 TOTAL | 0 |
GRAND TOTAL (BASE + ALL OPTIONS) 0
| 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. |
| Section I, B.3.3 - Monthly Retention Amounts | |||||
| Period of Performance | Single Employees (Self only) | Employee + 2 | Employee + 3 | Employee + 4 | Employee + 5 or More |
| Base Period | |||||
| First Option Year | |||||
| Second Option Year | |||||
| Third Option Year | |||||
| Fourth Option Year |
SGE50017R0136
Locally Engaged Staff Health Insurance Attachment 1 Pricing Schedule
File details come from the government source that posted it. Updated .