24 months RX membership and Costshare.xlsx
XLSX spreadsheet 11 KB Posted
- Attached to
- PHARMACY BENEFITS MANAGEMENT
- Solicitation number
- ARFP-0225-PEI2500000002-2
- Issued by
- Kanawha County, West Virginia
About this file
The file "24 months RX membership and Costshare.xlsx" appears to be a detailed spreadsheet tracking prescription (RX) membership and cost-sharing data, likely for a state or local government healthcare program. The document covers a comprehensive 24-month period from June 2023 to June 2025, tracking monthly membership levels, deductibles, copayments, and total cost shares for active, non-Medicare retirees and specific healthcare program participants.
The spreadsheet reveals consistent membership levels around 153,000-154,000 members per month, with total cost shares ranging from approximately $3.7 million to $7.1 million monthly. The data shows fluctuating deductible and copayment amounts, with notable peaks in January of both 2024 and 2025, where total cost shares exceed $6-7 million. The comprehensive tracking suggests this is part of a healthcare benefits program, with claims being processed through June 11, 2025, indicating a structured approach to managing healthcare costs and membership for a specific population of government or institutional healthcare recipients.
View the file
Other files
Show all 15
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
| Month | Members | Deductible | Copay | Total Cost Share |
| 2023-06 | 157,072 | 164,498.22 | 4,432,442.17 | 4,596,940.39 |
| 2023-07 | 153,836 | 2,300,427.00 | 3,075,992.09 | 5,376,419.09 |
| 2023-08 | 153,776 | 1,443,634.27 | 3,552,473.94 | 4,996,108.21 |
| 2023-09 | 154,392 | 968,053.01 | 3,333,393.79 | 4,301,446.80 |
| 2023-10 | 154,463 | 637,445.81 | 3,542,914.11 | 4,180,359.92 |
| 2023-11 | 154,726 | 520,621.15 | 3,477,543.54 | 3,998,164.69 |
| 2023-12 | 154,787 | 420,385.69 | 3,429,795.63 | 3,850,181.32 |
| 2024-01 | 154,434 | 367,148.33 | 6,553,375.97 | 6,920,524.30 |
| 2024-02 | 154,345 | 308,361.02 | 5,755,640.58 | 6,064,001.60 |
| 2024-03 | 154,204 | 252,855.58 | 5,234,645.19 | 5,487,500.77 |
| 2024-04 | 154,074 | 204,435.47 | 4,858,783.88 | 5,063,219.35 |
| 2024-05 | 153,895 | 183,440.04 | 4,149,407.52 | 4,332,847.56 |
| 2024-06 | 153,570 | 156,302.46 | 3,589,650.42 | 3,745,952.88 |
| 2024-07 | 154,099 | 2,691,276.95 | 3,638,008.76 | 6,329,285.71 |
| 2024-08 | 153,993 | 1,516,658.99 | 3,612,371.84 | 5,129,030.83 |
| 2024-09 | 154,050 | 1,001,915.58 | 3,450,973.32 | 4,452,888.90 |
| 2024-10 | 154,191 | 714,397.70 | 3,813,853.69 | 4,528,251.39 |
| 2024-11 | 154,103 | 508,085.54 | 3,319,916.47 | 3,828,002.01 |
| 2024-12 | 154,046 | 411,351.03 | 3,389,994.60 | 3,801,345.63 |
| 2025-01 | 153,519 | 336,215.31 | 6,758,566.52 | 7,094,781.83 |
| 2025-02 | 153,427 | 302,682.40 | 5,757,390.96 | 6,060,073.36 |
| 2025-03 | 153,220 | 279,422.44 | 5,852,369.12 | 6,131,791.56 |
| 2025-04 | 153,034 | 211,323.59 | 4,878,817.10 | 5,090,140.69 |
| 2025-05 | 152,725 | 179,663.02 | 4,210,327.72 | 4,389,990.74 |
16,080,600.60 103,668,648.93 119,749,249.53
| Active, non Medicare retirees, and MSWP, RTP |
| Claims are paid through 11-jun-2025 |
File details come from the government source that posted it. Updated .