Attachment 1 - Price Proposal.xlsx

XLSX spreadsheet 20 KB Posted

Attached to
Health Insurance for Locally Employed Staff, U. S. Embassy Praia, Cabo Verde
Solicitation number
19GE5025R0013
Issued by

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 Increase3
Self Plus One (two individuals) Increase1
Family (three or more individuals) Increase1
Rate Increase5%
CLINBase YearEstimated # of EmployeesEstimated Price per employee per monthEstimated Total per MonthEstimated Total per Year
0001Self-Only30
0002Self Plus One (two individuals)30
0003Family (three or more individuals)145
0004VAT if applicable-
Estimated Base Year Total
Option Year 1
1001Self-Only35
1002Self Plus One (two individuals)30
1003Family (three or more individuals)148
1004VAT if applicable-
Estimated First Option Year Total
Option Year 2
2001Self-Only35
2002Self Plus One (two individuals)35
2003Family (three or more individuals)160
2004VAT if applicable-
Estimated Second Option Year Total
Option Year 3
3001Self-Only35
3002Self Plus One (two individuals)35
3003Family (three or more individuals)160
3004VAT if applicable-
Estimated Third Option Year Total
Option Year 4
4001Self-Only35
4002Self Plus One (two individuals)35
4003Family (three or more individuals)160
4004VAT 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 .