25R0025 Attachment 1 Price Proposal.xlsx
XLSX spreadsheet 20 KB Posted
- Solicitation number
- 19GE5025R0025
About this file
The file is a Price Proposal Excel spreadsheet for a health insurance contract (Solicitation Number 19GE5025R0025) for locally employed staff at the U.S. Embassy in Gaborone, Botswana. The pricing structure includes four coverage tiers: Self-Only, Self Plus One, Family, and a VAT line item, with consistent estimated employee counts across a base year and four option years. The base year and each option year maintain similar enrollment projections: 70 employees for Self-Only, 45 for Self Plus One, and 75 for Family coverage (with a slight reduction to 70 Family enrollees in Option Year 4).
The contract is being issued by the Department of State Office of Acquisition Management through the Regional Procurement Support Office in Frankfurt, Germany. It is a Fixed Price with economic adjustment Indefinite Delivery Indefinite Quantity (IDIQ) contract, intended to provide a supplemental medical benefit plan for Locally Employed Staff that complements existing government-provided healthcare. The contract's performance period will be 12 months, with the potential for four additional one-year option periods, with an anticipated award in the second quarter of calendar year 2025.
View the file
Other files
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
Per Employee 19GE5025R0025 19GE50-25-R-0025 Gaborona Health Insurance
| CLIN | Base Year | Estimated # of Employees | Estimated Price per employee per month | Estimated Total per Month | Estimated Total per Year |
| 0001 | Self-Only | 70 | |||
| 0002 | Self Plus One (two individuals) | 45 | |||
| 0003 | Family (three or more individuals) | 75 | |||
| 0004 | VAT if applicable | - | |||
| Estimated Base Year Total | |||||
| Option Year 1 | |||||
| 1001 | Self-Only | 70 | |||
| 1002 | Self Plus One (two individuals) | 45 | |||
| 1003 | Family (three or more individuals) | 75 | |||
| 1004 | VAT if applicable | - | |||
| Estimated First Option Year Total | |||||
| Option Year 2 | |||||
| 2001 | Self-Only | 70 | |||
| 2002 | Self Plus One (two individuals) | 45 | |||
| 2003 | Family (three or more individuals) | 75 | |||
| 2004 | VAT if applicable | - | |||
| Estimated Second Option Year Total | |||||
| Option Year 3 | |||||
| 3001 | Self-Only | 70 | |||
| 3002 | Self Plus One (two individuals) | 45 | |||
| 3003 | Family (three or more individuals) | 75 | |||
| 3004 | VAT if applicable | - | |||
| Estimated Third Option Year Total | |||||
| Option Year 4 | |||||
| 4001 | Self-Only | 70 | |||
| 4002 | Self Plus One (two individuals) | 45 | |||
| 4003 | Family (three or more individuals) | 70 | |||
| 4004 | VAT if applicable | - | |||
| Estimated Fourth Option Year Total |
Estimated Grand total (Base Year+ Option years)
File details come from the government source that posted it. Updated .