Demographicsandstatistics.xlsx
XLSX spreadsheet 19 KB Posted
- Attached to
- Heathcare Insurance
- Solicitation number
- SNU-700-14-R-0001
- Issued by
-
Department of State US Embassy Managua
About this file
Demographics and Statitics
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Additional_QandA_(2).docx | DOCX document |
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
Sheet1 The following data has been updated as of March 6, 2014.
Table 1. Number of participants to be covered by a the Health Plan Insurance
| Description | Chancery | USAID | *ORE | *AEA | Totals |
| Employees | 559 | 23 | 9 | 6 | 597 |
| Dependents | 515 | 28 | 5 | 0 | 548 |
| Grand total | 1074 | 51 | 14 | 6 | 1145 |
| Note: * Covered under a rider |
Table 2. Totals of participation (employees plus dependents) in percentages
| Description | Chancery | USAID | *ORE | *AEA | Totals |
| Employees | 93.63% | 3.85% | 1.51% | 1.01% | 100% |
| Dependents | 93.98% | 5.11% | 0.91% | 0.00% | 100% |
| Grand total | 93.80% | 8.96% | 2.42% | 1.01% |
| Table 2. Shows percentages (of employees plus dependents) for each group |
| compared to the grand total of 1145 participants. E.g the Chancery comprises |
| the largest participation with 93.80% in relation to grand total of 1145 including |
| current employees and dependents. |
Table 3. Employees's health plan choice
| Employees's health plan | Chancery | USAID | *ORE | *AEA | Totals | |
| Family | 199 | 16 | 1 | 0 | 216 | 36% |
| Single | 360 | 7 | 8 | 6 | 381 | 64% |
| Grand total | 559 | 23 | 9 | 6 | 597 |
| Table 3. Indicates the employee's current health plan choice. The majority of the |
| employees 381 are in the single option represented in a 64% of the grand total and |
| 360 belong to the Chancery group. The table shows a trend to single plan choice against |
| 216 employeees that are in family plan. |
Table 4. Potential Participants (employees) by age and gender categories
| Age range | 20-35 | 36-50 | 51-60 | Over 61 | Totals | |
| Gender | ||||||
| Female | 34 | 54 | 17 | 1 | 106 | 18% |
| Male | 165 | 249 | 59 | 18 | 491 | 82% |
| Grand total | 199 | 303 | 76 | 19 | 597 |
| Table 4. shows that 491 employees equal to 82% are men. Thus a 36-50 male age-range |
| constitutes about 50.75% of the total employees partipating in the health insurance |
| plan. Female represent about 18% of the grand total current employee population to |
| be covered by the health insurance plan. |
Table 5. Potential (employees) participants's dependents by age and gender categories
| Age range | 0-12 | 13-24 | 25-40 | 41-60 | Over 60 | Totals | |
| Gender | |||||||
| Female | 87 | 83 | 96 | 63 | 7 | 336 | 61% |
| Male | 84 | 91 | 16 | 17 | 4 | 212 | 39% |
| Grand total | 171 | 174 | 112 | 80 | 11 | 548 |
| Table 5. indicates the total of dependents that may participate in the family health coverage. |
| 61% of prospective dependents are women within a prevailing age-range of 25-40 years |
| 174 dependents of 13-24 age-range represent the major group with 31.75% of the total |
| feasible dependents coverage. |
Table 6. Employees by age and gender categories (specific request)
| Age range | 20-29 | 30-39 | 40-49 | 50-59 | 60-64 | 65-69 | Totals |
| Gender | |||||||
| Female | 9 | 39 | 27 | 23 | 8 | 0 | 106 |
| Male | 60 | 191 | 165 | 57 | 15 | 3 | 491 |
| Grand total | 69 | 230 | 192 | 80 | 23 | 3 | 597 |
Table 7. Dependents by age and gender categories (specific request)
| Age range | 0-3 | 4-9 | 10-14 | 15-19 | 20-29 | 30-39 | 40-49 | 50-59 | Totals |
| Gender | |||||||||
| Female | 15 | 37 | 52 | 38 | 41 | 70 | 49 | 17 | 319 |
| Male | 13 | 40 | 49 | 44 | 23 | 12 | 9 | 1 | 191 |
| Grand total | 28 | 77 | 101 | 82 | 64 | 82 | 58 | 18 | 510 |
| Table 8. Current occupied positions (specific request) | |||||||||
| Working Title | Current employees | ||||||||
| ACS ASSIST. | 2 | ||||||||
| ADMIN ASSIST (RSO INV) | 9 | ||||||||
| AGRICULTURAL ASSIST. | 1 | ||||||||
| AGRICULTURAL SPECIALIST | 1 | ||||||||
| ALUMNI COOR/IRC ASSIST. | 1 | ||||||||
| APPLIANCE TECH. | 1 | ||||||||
| AUTOM MECHANIC/CHAUFFEUR | 1 | ||||||||
| BUDGET ANALYST(FMC) | 4 | ||||||||
| CARPENTER FOREMAN | 1 | ||||||||
| CARPENTER/PAINTER | 5 | ||||||||
| CASHIER | 1 | ||||||||
| CHAUFFEUR | 21 | ||||||||
| COMMERCIAL SPECIALIST | 1 | ||||||||
| COMP MGT SPECIALIST | 1 | ||||||||
| COMPUTER MGT. ASSIST. | 1 | ||||||||
| CONS INVEST ASST | 1 | ||||||||
| CONSULAR ADMIN ASSIST. | 1 | ||||||||
| CONTRACT SPECIALIST | 1 | ||||||||
| CULT AFF ASSIST | 1 | ||||||||
| CULTURAL AFFAIRS SPECIALIST | 1 | ||||||||
| DEFENSIVE SECURITY COORD. | 1 | ||||||||
| ECONOMIC SPECIALIST | 1 | ||||||||
| ELECTRICIAN | 4 | ||||||||
| ENGLISH LANGUAGE COORD. | 1 | ||||||||
| EXECUT SECRETARY(MILGR) | 1 | ||||||||
| FACILITY ENGINEER | 1 | ||||||||
| FED BENEFIT ASST | 1 | ||||||||
| FINANCIAL ASSIST.(RSO) | 1 | ||||||||
| FINANCIAL SPECIALIST | 1 | ||||||||
| FINANCIAL SPECIALIST | 1 | ||||||||
| GARDENER | 11 | ||||||||
| GENERAL MAINT./WELDER | 1 | ||||||||
| GUARDS | 374 | ||||||||
| HOUSING ASSIST. | 3 | ||||||||
| HR ADMIN ASSIST. | 1 | ||||||||
| HR LGP ASSIST. | 1 | ||||||||
| HUMAN RESOURCES ASSIST. | 1 | ||||||||
| HUMAN RESOURCES CLERK | 1 | ||||||||
| HUMAN RESOURCES TRAVEL ASSIST. | 1 | ||||||||
| HVAC SUPERVISOR | 1 | ||||||||
| HVAC TECH. | 5 | ||||||||
| IMMIGRANT VISA ASSIST/FRAUD INVESTIGATOR | 1 | ||||||||
| INFOR RESOURCES MGT SPEC | 1 | ||||||||
| INFORMATION ASSIST. | 1 | ||||||||
| INL PROGRAM ASSIST. | 1 | ||||||||
| INL PROGRAM MNG SPEC. | 1 | ||||||||
| JANITORS | 9 | ||||||||
| LOGISTICS/OPERATION ADM ASSIST/MILG | 1 | ||||||||
| MAILROOM CLERK | 1 | ||||||||
| MAILROOM SUPERVISOR | 1 | ||||||||
| MECHANIC | 1 | ||||||||
| MECHANICAL SUPERVISOR | 1 | ||||||||
| MOTOR POOL DISPACHER | 1 | ||||||||
| MOTOR POOL SUPERVISOR | 1 | ||||||||
| MULTIMEDIA AND COMPUTER TECH. | 1 | ||||||||
| NIV CLERK/WEBMASTER | 1 | ||||||||
| NOB JANITOR FOREMAN | 1 | ||||||||
| NOX JANITOR FOREMAN | 1 | ||||||||
| NURSE (SENIOR) | 1 | ||||||||
| NXP. STOREKEEPER | 1 | ||||||||
| PLUMBER | 4 | ||||||||
| POLITICAL SPECIALIST | 1 | ||||||||
| POST SECURITY TECH. | 1 | ||||||||
| POSTAL ASSIST. | 1 | ||||||||
| POWER PLAN OPERATOR | 2 | ||||||||
| PROCUREMENT SUPERVISOR | 1 | ||||||||
| PROP CLAIMS ASSIS(JUNIOR) | 1 | ||||||||
| PROTOCOL ASST. | 1 | ||||||||
| PURCHASING AGENT | 4 | ||||||||
| RADIO TECH. | 1 | ||||||||
| RECEIVING CLERK | 1 | ||||||||
| RECEIVING SUPERVISOR | 1 | ||||||||
| RESIDENTIAL FOREMAN | 1 | ||||||||
| RESIDENTIAL MAINT. COORD. | 1 | ||||||||
| RESIDENTIAL SECURITY COORD. | 1 | ||||||||
| RESIDENTIAL SUPERVISOR | 1 | ||||||||
| S.D. FIELD SUPERVISOR | 1 | ||||||||
| SAFETY PROGRAM COORD. | 1 | ||||||||
| SDT COORD. | 1 | ||||||||
| SEC. ASSIST PROG MAN | 1 | ||||||||
| SECURITY INVESTIGATORS | 5 | ||||||||
| SENIOR INFORMATION SPEC | 1 | ||||||||
| SENIOR SEC INVESTIGATOR | 1 | ||||||||
| SHIPMENT STAFF | 4 | ||||||||
| STOREKEEPER EXPEN(GSO) | 1 | ||||||||
| STOREKEEPER(WAREHOUSE) | 1 | ||||||||
| SUPERV. VOUCHER EXAMINER | 1 | ||||||||
| SUPPLY STAFF | 3 | ||||||||
| SWITCHBOARD OPERATOR | 2 | ||||||||
| TELECOMMUNICATIONS FIELD SUPERVISOR | 1 | ||||||||
| TRANSLATOR/BACK UP PROT. ASSIST | 1 | ||||||||
| VISA ASSIST(IMMING VISA) | 1 | ||||||||
| VISA ASSIST.(NON-IMMIG) | 1 | ||||||||
| VOUCHER EXAMINER | 1 | ||||||||
| WAREHOUSEMAN | 6 | ||||||||
| WAREHOUSEMAN & CHAUFFEUR | 2 | ||||||||
| WEB SYSTEM ADMINISTRATOR | 1 | ||||||||
| WEBMASTER/MULTIMEDIA TECH. | 1 | ||||||||
| WORK ORDER CLERK | 1 | ||||||||
| Totals of current occupied positions | 558 |
| Table 9. Services statistics (specific request) | |
| Informes Estadísticos de Planes Medicos | |
| Septiembre 2012 a Septiembre del 2013 | |
| AREA | Embusa |
| CONSULTA MEDICA | |
| Emergencia | 1717 |
| Consulta General | 4258 |
| Consulta Especialidades | 4215 |
| TOTAL | 10190 |
| PROC. QUIRURGICOS | |
| Cirugias Mayores | 36 |
| Cirugias Menores | 8 |
| Cir. Ambulatorias | 25 |
| TOTAL | 69 |
| Partos | 4 |
| Cesareas | 10 |
Sheet2
Sheet3
File details come from the government source that posted it. Updated .