Att 1 - Pricing.xlsx
XLSX spreadsheet 28 KB Posted
- Solicitation number
- 19GE5024R0008
About this file
This document is an attachment to a federal contract opportunity solicitation, specifically a pricing template for a health and life insurance contract for locally engaged staff at the U.S. Embassy Bridgetown, Barbados, and U.S. Embassy St. George's, Grenada.
The pricing template covers base year and four option years for health insurance (single, employee+1, and family plans) and life insurance (basic life and accidental death and dismemberment). The estimated number of employees and average biweekly payroll are provided as reference. Offerors are required to complete the highlighted cells with their proposed pricing. The overall grand total for the base year and four option years must be calculated. The related federal contract opportunity has a solicitation number of 19GE5024R0008 and is due by April 26, 2024, 15:00 German Time. Any questions regarding the solicitation must be submitted by April 12, 2024, 15:00 German Time.
View the file
Other files
Show all 14
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
D.1 Health Insurance
| D.1.1 Base year | ||||
| CLIN 0001 | Bi weekly Rate per employee | estimated number of employees* | rate per employee | Bi-weekly total |
| 0001a | Single Employees (Self only) | 60 | 0 | |
| 0001b | Employee + 1 | 42 | 0 | |
| 0001c | Family Plan | 41 | 0 | |
| Sub Total | 0 | |||
| Total Price for Base year** | 0 | |||
| D.1.2 Option year one | ||||
| CLIN 1001 | Bi weekly Rate per employee | estimated number of employees* | rate per employee | Bi-weekly total |
| 1001a | Single Employees (Self only) | 60 | 0 | |
| 1001b | Employee + 1 | 42 | 0 | |
| 1001c | Family Plan | 45 | 0 | |
| Sub Total | 0 | |||
| Total Price for Option year one** | 0 | |||
| D.1.3 Option year two | ||||
| CLIN 2001 | Bi weekly Rate per employee | estimated number of employees* | rate per employee | Bi-weekly total |
| 2001a | Single Employees (Self only) | 60 | 0 | |
| 2001b | Employee + 1 | 42 | 0 | |
| 2001c | Family Plan | 45 | 0 | |
| Sub Total | 0 | |||
| Total Price for Option year two** | 0 | |||
| D.1.4 Option year three | ||||
| CLIN 3001 | Bi weekly Rate per employee | estimated number of employees* | rate per employee | Bi-weekly total |
| 3001a | Single Employees (Self only) | 60 | 0 | |
| 3001b | Employee + 1 | 42 | 0 | |
| 3001c | Family Plan | 45 | 0 | |
| Sub Total | 0 | |||
| Total Price for Option year three** | 0 | |||
| D.1.5 Option year four | ||||
| CLIN 4001 | Bi weekly Rate per employee | estimated number of employees* | rate per employee | Bi-weekly total |
| 4001a | Single Employees (Self only) | 60 | 0 | |
| 4001b | Employee + 1 | 42 | 0 | |
| 4001c | Family Plan | 45 | 0 | |
| Sub Total | 0 | |||
| Total Price for Option year four** | 0 | |||
| D.1.6 Grand Total for Base plus 4 Option Years | ||||
| Base year total | 0 | |||
| Option year one total | 0 | |||
| Option year two total | 0 | |||
| Option year three total | 0 | |||
| Option year four total | 0 | |||
| Grand Total Base plus 4 Option years | 0 | |||
| highlighted cells to be completed by offeror | ||||
| *estimated number of premiums does not include any Riders (III, D) | ||||
| **does not include any premiums for Riders. | ||||
| Note: All quantities are reasonable estimates per year based on past experience. They do not obligate the USG to order those quantities. |
D.2 Life Insurance
| D.2.1 Base year | ||||
| CLIN 0002 | Bi weekly Rate per employee | Premium per 1,000 of Salary | estimated avarage payroll (bi weekly in thousands) | Bi-weekly total |
| 0002a | Basic Life | 12,298.07 | 0 | |
| 0002b | Accidental Death and Dismemberment | 12,298.07 | 0 | |
| Sub Total | 0 | |||
| Total Price for Base year | 0 | |||
| D.2.2 Option year one | ||||
| CLIN 1002 | Bi weekly Rate per employee | Premium per 1,000 of Salary | estimated avarage payroll (bi weekly in thousands) | Bi-weekly total |
| 1002a | Basic Life | 12,298.07 | 0 | |
| 1002b | Accidental Death and Dismemberment | 12,298.07 | 0 | |
| Sub Total | 0 | |||
| Total Price for Option year one | 0 | |||
| D.2.3 Option year two | ||||
| CLIN 2002 | Bi weekly Rate per employee | Premium per 1,000 of Salary | estimated avarage payroll (bi weekly in thousands) | Bi-weekly total |
| 2002a | Basic Life | 12,298.07 | 0 | |
| 2002b | Accidental Death and Dismemberment | 12,298.07 | 0 | |
| Sub Total | 0 | |||
| Total Price for Option year two | 0 | |||
| D.2.4 Option year three | ||||
| CLIN 3002 | Bi weekly Rate per employee | Premium per 1,000 of Salary | estimated avarage payroll (bi weekly in thousands) | Bi-weekly total |
| 3002a | Basic Life | 12,298.07 | 0 | |
| 3002b | Accidental Death and Dismemberment | 12,298.07 | 0 | |
| Sub Total | 0 | |||
| Total Price for Option year three | 0 | |||
| D.2.5 Option year four | ||||
| CLIN 4002 | Bi weekly Rate per employee | Premium per 1,000 of Salary | estimated avarage payroll (bi weekly in thousands) | Bi-weekly total |
| 4002a | Basic Life | 12,298.07 | 0 | |
| 4002b | Accidental Death and Dismemberment | 12,298.07 | 0 | |
| Sub Total | 0 | |||
| Total Price for Option year four | 0 | |||
| D.2.6 Grand Total for Base plus 4 Option Years | ||||
| Base year total | 0 | |||
| Option year one total | 0 | |||
| Option year two total | 0 | |||
| Option year three total | 0 | |||
| Option year four total | 0 | |||
| Grand Total Base plus 4 Option years | 0 | |||
| highlighted cells to be completed by offeror | ||||
| Note: All quantities are reasonable estimates per year based on past experience. They do not obligate the USG to order those quantities. |
E.1 Retention amounts
| Section 1, III Prices, E.1. Bi weekly administrative retention amounts | |||
| Period of Performance | Single Employees (Self Onyl) | Employee + 1 | Family Plan |
| Base year | |||
| Option year one | |||
| Option year two | |||
| Option year three | |||
| Option year four | |||
| highlighted cells to be completed by offeror |
Grand Total
| Total estimated contract amount | |
| Total Health Insurance | 0 |
| Total Life Insurance | 0 |
| Grand Total | 0 |
| Currency: | Barbados Dollars |
File details come from the government source that posted it. Updated .