PremiumsvsClaims_2014_2017wretirees.xlsx
XLSX spreadsheet 18 KB Posted
- Attached to
- Health & Life Insurance Services
- Solicitation number
- SPM070-17-R-0001
About this file
Premiums Vs Claims Report
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Amendment_A004.pdf | ||
| Claims_Report_2017_-_Chronic_Conditions.xlsx | XLSX spreadsheet | |
| HL_QA4_061417_final.docx | DOCX document | |
| Amendment_A003.pdf | ||
| HL_QA3_060217.docx | DOCX document | |
| Comparison_Chart_2012-2022.xlsx | XLSX spreadsheet | |
| Amendment_A002.pdf | ||
| Exhibit_E_List_of_Dependents.pdf | ||
| Exhibits_ABCD.pdf | ||
| Quick_Guide_for_Contract_Registrations_SAM.pdf | ||
| Claims_Report_2017.xlsx | XLSX spreadsheet | |
| HL_QA2_060117.docx | DOCX document | |
| PreProposal_Minutes.pdf | ||
| Amendment_A001.pdf | ||
| Chart_agegroup_andgender_2017.xlsx | XLSX spreadsheet | |
| HL_QA1_051617.docx | DOCX document | |
| Sample_Report_2017.xlsx | XLSX spreadsheet | |
| Exhibits_ABCD.pdf | ||
| RFP_InvitationLetter.pdf | ||
| SF33_Cover_Page.pdf | ||
| HL_Solicitation_Final.pdf |
Show all 21
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
LES
| EMBASSY OF THE UNITED STATES OF AMERICA, PANAMA |
| GROUP LIFE AND HEALTH |
| CLAIMS PAID/PREMIUMS COLLECTED UTILIZATION REPORT |
| Month | Life Premium Received | Health Premium Received | Life Insurance Reimbursement | Health Insurance Reimbursement | Life Experience | Medical Experience |
| Mar-14 | - 0 | 34,644.23 | - 0 | 19,524.45 | 0.0% | 56.4% |
| Apr-14 | 5,814.90 | - 0 | - 0 | 14,161.16 | 0.0% | 0.0% |
| May-14 | 4,369.04 | 56,015.45 | - 0 | 23,364.31 | 0.0% | 41.7% |
| Jun-14 | 1,465.50 | 37,463.85 | - 0 | 28,614.69 | 0.0% | 76.4% |
| Jul-14 | 14,727.41 | 75,697.32 | - 0 | 15,279.34 | 0.0% | 20.2% |
| Aug-14 | - 0 | - 0 | - 0 | 16,605.39 | 0.0% | 0.0% |
| Sep-14 | 4,362.13 | 37,310.14 | - 0 | 16,866.22 | 0.0% | 45.2% |
| Oct-14 | 1,520.64 | 57,216.74 | - 0 | 12,974.32 | 0.0% | 22.7% |
| Nov-14 | 1,534.96 | 38,607.89 | - 0 | 7,040.51 | 0.0% | 18.2% |
| Dec-14 | 4,425.55 | 39,028.53 | - 0 | 17,472.02 | 0.0% | 44.8% |
| Jan-15 | - 0 | 38,946.48 | - 0 | 16,301.15 | 0.0% | 41.9% |
| Feb-15 | 453.31 | 78,610.92 | - 0 | 12,492.74 | 0.0% | 15.9% |
| Mar-15 | 4,548.51 | 41,300.80 | - 0 | 29,740.29 | 0.0% | 72.0% |
| Apr-15 | 8,633.42 | 105.00 | - 0 | 24,823.31 | 0.0% | 23641.2% |
| May-15 | 9,519.70 | 63,676.50 | - 0 | 21,735.13 | 0.0% | 34.1% |
| Jun-15 | 9,078.47 | 42,332.43 | - 0 | 11,983.93 | 0.0% | 28.3% |
| Jul-15 | 1,522.02 | 42,420.63 | - 0 | 22,965.03 | 0.0% | 54.1% |
| Aug-15 | 10,671.60 | 43,307.03 | - 0 | 15,826.46 | 0.0% | 36.5% |
| Sep-15 | 18,687.86 | 65,699.73 | - 0 | 19,001.37 | 0.0% | 28.9% |
| Oct-15 | 5,176.46 | 44,405.91 | - 0 | 26,079.17 | 0.0% | 58.7% |
| Nov-15 | 761.01 | 45,010.91 | - 0 | 9,523.24 | 0.0% | 21.2% |
| Dec-15 | 761.01 | 89,639.28 | - 0 | 12,519.54 | 0.0% | 14.0% |
| Jan-16 | 15,098.87 | - 0 | - 0 | 25,929.60 | 0.0% | 0.0% |
| Feb-16 | 4,733.31 | 44,466.84 | - 0 | 13,320.28 | 0.0% | 30.0% |
| Mar-16 | 6,088.49 | 110,810.26 | - 0 | 18,209.90 | 0.0% | 16.4% |
| Apr-16 | 6,589.26 | - 0 | - 0 | 10,466.02 | 0.0% | 0.0% |
| May-16 | 4,220.10 | 47,223.16 | - 0 | 23,770.53 | 0.0% | 50.3% |
| Jun-16 | 10,835.74 | 95,062.99 | - 0 | 25,197.86 | 0.0% | 26.5% |
| Jul-16 | 1,183.52 | 47,267.32 | - 0 | 18,085.16 | 0.0% | 38.3% |
| Aug-16 | 10,164.91 | 71,065.82 | 1,479.67 | 7,384.76 | 14.6% | 10.4% |
| Sep-16 | 5,493.38 | - 0 | 1,479.67 | 15,923.85 | 26.9% | 0.0% |
| Oct-16 | - 0 | 46,926.68 | 1,479.67 | 16,277.19 | 0.0% | 34.7% |
| Nov-16 | 5,613.51 | 47,412.82 | 1,479.67 | 12,814.69 | 26.4% | 27.0% |
| Dec-16 | - 0 | 95,715.08 | 1,479.67 | 14,296.98 | 0.0% | 14.9% |
| Jan-17 | 11,192.26 | 23,611.58 | 48,446.34 | 12,990.85 | 432.9% | 55.0% |
| Feb-17 | 11,660.55 | 69,791.61 | 20,715.31 | 12,611.79 | 177.7% | 18.1% |
| Mar-17 | - 0 | 65,078.45 | - 0 | 14,252.51 | 0.0% | 21.9% |
| 200,907.40 | 1,735,872.38 | 76,560.00 | 636,425.74 | 38.1% | 36.7% |
Retirees
| Month | Health Premium Received | Health Insurance Reimbursement | Medical Experience |
| Mar-14 | 5,871.90 | 8,034.55 | 136.8% |
| Apr-14 | 5,759.34 | 6,688.72 | 116.1% |
| May-14 | 5,442.73 | 17,755.65 | 326.2% |
| Jun-14 | 5,410.92 | 6,312.69 | 116.7% |
| Jul-14 | 7,565.96 | 35,202.15 | 465.3% |
| Aug-14 | 5,738.07 | 8,682.83 | 151.3% |
| Sep-14 | 5,565.52 | 1,847.12 | 33.2% |
| Oct-14 | 5,743.30 | 2,176.80 | 37.9% |
| Nov-14 | 5,879.11 | 2,285.71 | 38.9% |
| Dec-14 | 5,704.35 | 1,234.24 | 21.6% |
| Jan-15 | - 0 | 2,050.49 | 0.0% |
| Feb-15 | 10,504.54 | 5,328.27 | 50.7% |
| Mar-15 | 4,981.65 | 3,818.35 | 76.6% |
| Apr-15 | 5,514.89 | 632.77 | 11.5% |
| May-15 | 4,778.27 | 4,264.92 | 89.3% |
| Jun-15 | 4,804.29 | 928.24 | 19.3% |
| Jul-15 | 5,691.76 | 24,281.98 | 426.6% |
| Aug-15 | 6,026.09 | 16,350.49 | 271.3% |
| Sep-15 | 4,893.09 | 7,224.73 | 147.7% |
| Oct-15 | 5,063.05 | 15,602.75 | 308.2% |
| Nov-15 | 5,714.40 | 10,475.12 | 183.3% |
| Dec-15 | 4,974.14 | 13,853.01 | 278.5% |
| Jan-16 | 5,622.94 | 19,886.72 | 353.7% |
| Feb-16 | - 0 | 5,164.11 | 0.0% |
| Mar-16 | 9,985.95 | 10,339.75 | 103.5% |
| Apr-16 | 5,824.50 | 11,639.42 | 199.8% |
| May-16 | 5,132.61 | 9,842.38 | 191.8% |
| Jun-16 | 4,854.51 | 4,589.31 | 94.5% |
| Jul-16 | 4,473.04 | 5,614.06 | 125.5% |
| Aug-16 | 6,489.93 | 5,945.04 | 91.6% |
| Sep-16 | - 0 | 5,798.03 | 0.0% |
| Oct-16 | 5,902.91 | 10,310.54 | 174.7% |
| Nov-16 | 7,030.56 | 1,285.11 | 18.3% |
| Dec-16 | 6,652.98 | 16,154.16 | 242.8% |
| Jan-17 | 3,731.57 | 6,153.54 | 164.9% |
| Feb-17 | 5,604.30 | 1,295.48 | 23.1% |
| Mar-17 | 4,793.52 | 2,081.59 | 43.4% |
| 197,726.69 | 311,130.82 | 157.4% |
File details come from the government source that posted it. Updated .