Attachment 1-Pricing Spreadsheet_v20200919.xlsx
XLSX spreadsheet 16 KB Posted
- Solicitation number
- 19AQMM20R0332
About this file
This spreadsheet provides pricing details for a life and health insurance solicitation for employees of the United States Embassy in Kingston, Jamaica. The base year and four option years include pricing for single, employee plus one dependent, and family coverage under both health and life insurance plans. Life insurance coverage is based on 26 months salary for basic life and 34 months salary for accidental death and dismemberment. However, the spreadsheet does not include pricing amounts, as they are represented with [$JMD]. The related solicitation seeks these life and health insurance services for employees in Jamaica under solicitation number 19AQMM20R0332 issued by the Department of State Office of Acquisition Management.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment 2- Q_A Released.xlsx | XLSX spreadsheet | |
| 19AQMM20R0332.pdf | ||
| Attachment 2- Q_A.xlsx | XLSX spreadsheet |
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
Base + 4 OYs
| Health and Life Insurance - Pricing Spreadsheet | |||||||||
| Base Year | |||||||||
| CLIN | Sub-CLIN | Description | Rate per Employee (PREMIUM) | Unit | Months | SALARY VOLUME OF INSURANCE IN JMD | Number of Personnel | Total Cost per year | Bi weekly amount |
| 001 - Health and Life Insurance | |||||||||
| 0001 | Single Coverage (Self only) | Each | 12 | 54 | [$JMD] 0.00 | [$JMD] 0.00 | |||
| 0002 | Employee plus One Dependent | Each | 12 | 48 | [$JMD] 0.00 | [$JMD] 0.00 | |||
| 0003 | Family | Each | 12 | 113 | [$JMD] 0.00 | [$JMD] 0.00 | |||
| 002 - Group Life Insurance | |||||||||
| 0004 | Basic Life - Based on 26 months Salary Volume | Each | 12 | 1,623,016,000 | - | [$JMD] 0.00 | [$JMD] 0.00 | ||
| 0005 | Accidental Death and Dismemberment - Based on 34 months Salary Volume | Each | 12 | 2,122,380,000 | - | [$JMD] 0.00 | [$JMD] 0.00 | ||
| [$JMD] 0.00 | [$JMD] 0.00 |
| Option Year 1 | ||||||||
| 101 - Health and Life Insurance | ||||||||
| 1001 | Single Coverage (Self only) | Each | 12 | 54 | [$JMD] 0.00 | [$JMD] 0.00 | ||
| 1002 | Employee plus One Dependent | Each | 12 | 48 | [$JMD] 0.00 | [$JMD] 0.00 | ||
| 1003 | Family | Each | 12 | 113 | [$JMD] 0.00 | [$JMD] 0.00 | ||
| 102 - Group Life Insurance | ||||||||
| 1004 | Basic Life - Based on 26 months Salary Volume | Each | 12 | 1,623,016,000 | - | [$JMD] 0.00 | [$JMD] 0.00 | |
| 1005 | Accidental Death and Dismemberment - Based on 34 months Salary Volume | Each | 12 | 2,122,380,000 | - | [$JMD] 0.00 | [$JMD] 0.00 | |
| [$JMD] 0.00 | [$JMD] 0.00 |
| Option Year 2 | ||||||||
| 201 - Health and Life Insurance | ||||||||
| 2001 | Single Coverage (Self only) | Each | 12 | 54 | [$JMD] 0.00 | [$JMD] 0.00 | ||
| 2002 | Employee plus One Dependent | Each | 12 | 48 | [$JMD] 0.00 | [$JMD] 0.00 | ||
| 2003 | Family | Each | 12 | 113 | [$JMD] 0.00 | [$JMD] 0.00 | ||
| 202 - Group Life Insurance | ||||||||
| 2004 | Basic Life - Based on 26 months Salary Volume | Each | 12 | 1,623,016,000 | - | [$JMD] 0.00 | [$JMD] 0.00 | |
| 2005 | Accidental Death and Dismemberment - Based on 34 months Salary Volume | Each | 12 | 2,122,380,000 | - | [$JMD] 0.00 | [$JMD] 0.00 | |
| [$JMD] 0.00 | [$JMD] 0.00 |
| Option Year 3 | ||||||||
| 301 - Health and Life Insurance | ||||||||
| 3001 | Single Coverage (Self only) | Each | 12 | 54 | [$JMD] 0.00 | [$JMD] 0.00 | ||
| 3002 | Employee plus One Dependent | Each | 12 | 48 | [$JMD] 0.00 | [$JMD] 0.00 | ||
| 3003 | Family | Each | 12 | 113 | [$JMD] 0.00 | [$JMD] 0.00 | ||
| 302 - Group Life Insurance | ||||||||
| 3004 | Basic Life - Based on 26 months Salary Volume | Each | 12 | 1,623,016,000 | - | [$JMD] 0.00 | [$JMD] 0.00 | |
| 3005 | Accidental Death and Dismemberment - Based on 34 months Salary Volume | Each | 12 | 2,122,380,000 | - | [$JMD] 0.00 | [$JMD] 0.00 | |
| [$JMD] 0.00 | [$JMD] 0.00 |
| Option Year 4 | ||||||||
| 401 - Health and Life Insurance | ||||||||
| 4001 | Single Coverage (Self only) | Each | 12 | 54 | [$JMD] 0.00 | [$JMD] 0.00 | ||
| 4002 | Employee plus One Dependent | Each | 12 | 48 | [$JMD] 0.00 | [$JMD] 0.00 | ||
| 4003 | Family | Each | 12 | 113 | [$JMD] 0.00 | [$JMD] 0.00 | ||
| 402 - Group Life Insurance | ||||||||
| 4004 | Basic Life - Based on 26 months Salary Volume | Each | 12 | 1,623,016,000 | - | [$JMD] 0.00 | [$JMD] 0.00 | |
| 4005 | Accidental Death and Dismemberment - Based on 34 months Salary Volume | Each | 12 | 2,122,380,000 | - | [$JMD] 0.00 | [$JMD] 0.00 | |
| [$JMD] 0.00 | [$JMD] 0.00 | |||||||
| BiWeekly Total below: | ||||||||
| [$JMD] 0.00 |
TOTAL CONTRACT VALUE (BASE + FOUR OPTION YEARS) [$JMD] 0.00
&"-,Bold"&14MSS_Body Shop
IGCE
File details come from the government source that posted it. Updated .