Exhibit B Claims Data.pdf
PDF 191 KB Posted
- Attached to
- Health Insurance for Locally Employed Staff, U. S. Consulate General Willemstad, Curacao
- Solicitation number
- 19GE5025R0010
About this file
This file is a health insurance claims data spreadsheet showing detailed claim histories for three policy numbers (1000XXXXX1, 1000XXXXX2, and 1000XXXXX3) from 2020-2024. The data appears to be supporting documentation for solicitation 19GE5025R0010 for health insurance services for locally employed staff at the U.S. Consulate General in Willemstad, Curacao.
The spreadsheet breaks down individual claims by policy number and year, with amounts ranging from small claims under $100 to larger claims over $100,000. Policy 1000XXXXX1 shows total claims of $282,494.77, policy 1000XXXXX2 shows $194,229.73 in total claims, and policy 1000XXXXX3 shows $492,636.70 in total claims, for an aggregate claims total of $969,361.20 across all three policies over the period. The data shows claim patterns and utilization trends that would be relevant for insurance providers to assess risk and price their proposals for the solicitation.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 19GE5025R0010 0002.pdf | ||
| Pre-Proposal Presentation_25R0010.pdf | ||
| 19GE5025R0010 0001.pdf | ||
| QA Letter_25R0010.pdf | ||
| Exhibit A Employee Statistics.pdf | ||
| Attachment 3 Form W-14.pdf | ||
| Attachment 2 Past Performance.docx | DOCX document | |
| RFP_19GE5025R0010.pdf | ||
| RFP_Cover letter_25R0010.pdf | ||
| Attachment 1 Pricing.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
Claims Data for Health Insurance
2020-2024
Policy nr. Data 2020 2021 2022 2023
2024-
12YTD
Grand
Total
1000XXXXX1 Claim 794.52 16.13 323.50 1,134.15
Claim 641.04 423.09 1,064.13
Claim 469.25 65.00 534.25
Claim 25.00 65.00 90.00
Claim 0.00 0.00 0.00
Claim 18,994.36 13,144.21 -1,650.00 30,488.57
Claim 1,320.67 598.54 1,919.21
Claim 495.00 495.00
Claim 248.00 248.00
Claim -330.00 -330.00
Claim 173.07 450.00 623.07
Claim 5,013.87 823.64 5,837.51
Claim -372.00 -372.00
Claim 607.54 108.42 715.96
Claim 17,349.53 5,061.96 85.00 465.00 22,961.49
Claim 24,631.03 143,508.10 1,731.15 169,870.29
Claim 225.00 0.00 225.00
Claim 1,021.01 1,500.00 2,521.01
Claim 637.36 0.00 637.36
Claim 1,448.75 0.00 1,448.75
Claim 214.24 63.14 277.38
Claim 2,382.91 321.54 2,704.45
Claim 35.13 0.00 35.13
Claim 2,200.43 571.84 379.00 3,151.27
Claim 439.88 0.00 439.88
Claim 9,359.99 2,285.67 11,645.66
Claim 75.00 37.50 112.50
Claim 87.50 37.50 125.00
Claim 0.00 0.00 0.00
Claim 355.27 0.00 355.27
Claim -66.00 0.00 -66.00
Claim 0.00 0.00 0.00
Claim 1,511.25 1,248.58 2,759.83
Claim 1,385.01 431.80 1,816.81
Claim 152.00 0.00 152.00
Claim 0.00 0.00 0.00
Claim 325.00 0.00 325.00
Claim 1,653.74 816.00 2,469.74
Claim 0.00 0.00 0.00
Claim 2,086.40 0.00 2,086.40
Claim 944.48 0.00 944.48
Claim 9,548.22 3,500.00 13,048.22
Claim 0.00 0.00 0.00
Claim 0.00 0.00 0.00
Claim 0.00 0.00 0.00
Claim 0.00 0.00 0.00
Claim 0.00 0.00 0.00
Claim 0.00 0.00 0.00
1000XXXXX1 Claim 106,083.45 175,077.66 166.15 1,167.50 282,494.77
Claim 2020 2021 2022 2023
2024-
12YTD
Grand
Total
1000XXXXX2 Claim 323.19 813.59 1,136.78
Claim 1,190.00 0.00 1,190.00
Claim 0.00 0.00 0.00
Claim 0.00 0.00
Claim 309.00 0.00 309.00
Claim 5,321.10 5,321.10
Claim 2,135.19 -200.00 1,935.19
Claim 1,186.62 450.00 1,636.62
Claim 3,624.93 366.41 3,991.34
Claim 1,033.54 65.00 1,098.54
Claim 11,581.10 5,443.70 36.00 17,060.80
Claim 108,222.08 -1,199.90 1,026.80 108,048.98
Claim 590.00 -490.00 100.00
Claim 502.50 0.00 502.50
Claim 0.00 0.00
Claim 0.00 0.00 0.00
Claim 579.48 0.00 579.48
Claim 2,072.13 15,902.41 112.00 200.00 18,286.54
Claim 0.00 0.00 0.00
Claim 2,939.71 581.18 3,520.89
Claim 1,635.76 243.41 285.00 2,164.17
Claim 7,714.80 733.73 8,448.53
Claim 232.50 60.00 292.50
Claim 182.50 60.00 242.50
Claim 60.00 0.00 60.00
Claim 0.00 0.00
Claim 1,416.99 1,347.55 2,764.54
Claim 315.00 0.00 315.00
Claim 1,549.93 0.00 1,549.93
Claim 2,561.19 289.90 244.00 3,095.09
Claim 160.00 0.00 160.00
Claim 0.00 0.00 0.00
Claim 296.44 0.00 296.44
Claim 0.00 0.00 0.00
Claim 4,838.08 610.90 5,448.98
Claim 116.11 0.00 116.11
Claim 2,194.41 0.00 2,194.41
Claim 567.82 50.00 617.82
Claim 0.00 0.00 0.00
Claim 0.00 0.00 0.00
Claim 200.00 500.00 700.00
Claim 482.86 361.00 843.86
Claim 0.00 0.00 0.00
Claim 0.00 0.00 0.00
Claim 82.09 120.00 202.09
1000XXXXX2 Claim 166,217.05 26,108.88 1,459.80 444.00 194,229.73
Claim 2020 2021 2022 2023
2024-
12YTD
Grand
Total
1000XXXXX3 Claim 3,517.59 2,906.33 179,271.88 185,695.80
Claim 2,068.66 3,202.95 3,971.16 9,242.77
Claim 0.00 0.00 600.00 600.00
Claim 0.00 0.00 0.00
Claim 0.00 67.50 955.00 1,022.50
Claim 237.50 130.00 771.00 1,138.50
Claim 1,688.15 8,778.05 622.00 11,088.20
Claim 3,455.94 4,998.71 3,236.28 11,690.93
Claim 1,731.18 1,454.52 1,553.54 4,739.24
Claim 9,355.92 9,124.30 11,090.63 29,570.85
Claim 30,500.67 28,432.60 58,933.27
Claim 840.00 1,477.14 100.00 2,417.14
Claim 592.00 1,686.50 90.00 2,368.50
Claim 70.00 425.50 65.00 560.50
Claim 3,369.74 6,181.57 891.40 10,442.71
Claim 2,067.73 2,155.52 802.15 5,025.40
Claim 471.14 343.45 4,258.93 5,073.52
Claim 7,676.41 9,937.84 1,492.61 19,106.86
Claim 668.52 849.47 149.44 1,667.43
Claim 11,545.46 11,288.56 7,866.43 30,700.45
Claim 890.00 235.28 212.50 1,337.78
Claim 472.74 513.45 482.50 1,468.69
Claim 136.03 0.00 0.00 136.03
Claim 159.54 6,205.00 8,472.37 14,836.91
Claim 207.68 3,014.15 1,912.00 5,133.83
Claim 1,309.14 610.00 380.00 2,299.14
Claim 1,854.00 3,251.10 1,270.74 6,375.84
Claim 250.00 115.00 1,093.14 1,458.14
Claim 0.00 3,022.50 519.00 3,541.50
Claim 560.00 2,117.00 1,170.74 3,847.74
Claim 437.05 3,139.79 168.00 3,744.84
Claim 0.00 402.50 1,150.00 1,552.50
Claim 438.25 3,288.43 590.73 4,317.41
Claim 677.57 1,197.57 51.32 1,926.46
Claim 541.00 365.21 1,483.00 2,389.21
Claim 1,525.71 6,299.67 5,311.00 13,136.38
Claim 0.00 0.00 450.00 450.00
Claim 3,418.94 4,159.01 3,707.80 11,285.75
Claim 2,043.37 2,199.66 2,715.57 6,958.60
Claim 0.00 0.00 0.00 0.00
Claim 0.00 0.00 0.00 0.00
Claim 120.00 1,246.00 998.50 2,364.50
Claim 0.00 1,547.86 1,945.00 3,492.86
Claim 0.00 0.00 1,920.00 1,920.00
Claim 0.00 0.00 0.00 0.00
Claim 0.00 0.00
Claim 0.00 0.00
Claim 160.00 1,140.00 1,300.00
Claim 0.00 282.35 282.35
Claim 682.00 1,907.36 2,589.36
Claim 77.81 77.81
Claim 1,644.52 1,644.52
Claim 78.98 78.98
Claim 655.00 655.00
Claim 950.00 950.00
1000XXXXX3 Claim 94,897.63 137,211.69 260,527.38 492,636.70
Total Claim 106,083.45 341,294.72 121,172.65 139,838.99 260,971.38 969,361.20
File details come from the government source that posted it. Updated .