Attachment 1 - Price Proposal.xlsx
XLSX spreadsheet 20 KB Posted
- Solicitation number
- 19GE5025R0013
About this file
This is a pricing template spreadsheet for health insurance coverage for locally employed staff at the U.S. Embassy in Praia, Cabo Verde. The template is structured across a base year and four option years, with Contract Line Item Numbers (CLINs) for three coverage tiers: Self-Only, Self Plus One (two individuals), and Family (three or more individuals), plus Value Added Tax (VAT) if applicable.
The template shows increasing staffing estimates over the contract period, starting with 30 employees for Self-Only and Self Plus One categories, and 145 for Family coverage in the base year. By Option Year 4, these numbers increase to 35 employees for both Self-Only and Self Plus One categories, and 160 for Family coverage. The template requires vendors to input price per employee per month, with calculations for monthly and yearly totals, culminating in an estimated grand total for the entire contract period (base year plus all option years). A 5% rate increase is specified in the document.
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
| Self-Only Increase | 3 | ||||||
| Self Plus One (two individuals) Increase | 1 | ||||||
| Family (three or more individuals) Increase | 1 | ||||||
| Rate Increase | 5% | ||||||
| CLIN | Base Year | Estimated # of Employees | Estimated Price per employee per month | Estimated Total per Month | Estimated Total per Year | ||
| 0001 | Self-Only | 30 | |||||
| 0002 | Self Plus One (two individuals) | 30 | |||||
| 0003 | Family (three or more individuals) | 145 | |||||
| 0004 | VAT if applicable | - | |||||
| Estimated Base Year Total | |||||||
| Option Year 1 | |||||||
| 1001 | Self-Only | 35 | |||||
| 1002 | Self Plus One (two individuals) | 30 | |||||
| 1003 | Family (three or more individuals) | 148 | |||||
| 1004 | VAT if applicable | - | |||||
| Estimated First Option Year Total | |||||||
| Option Year 2 | |||||||
| 2001 | Self-Only | 35 | |||||
| 2002 | Self Plus One (two individuals) | 35 | |||||
| 2003 | Family (three or more individuals) | 160 | |||||
| 2004 | VAT if applicable | - | |||||
| Estimated Second Option Year Total | |||||||
| Option Year 3 | |||||||
| 3001 | Self-Only | 35 | |||||
| 3002 | Self Plus One (two individuals) | 35 | |||||
| 3003 | Family (three or more individuals) | 160 | |||||
| 3004 | VAT if applicable | - | |||||
| Estimated Third Option Year Total | |||||||
| Option Year 4 | |||||||
| 4001 | Self-Only | 35 | |||||
| 4002 | Self Plus One (two individuals) | 35 | |||||
| 4003 | Family (three or more individuals) | 160 | |||||
| 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 .