24 months RX membership and Costshare.xlsx
XLSX spreadsheet 11 KB Posted
- Attached to
- PHARMACY BENEFITS MANAGEMENT State and local contract opportunity
- 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 for this state and local contract opportunity
Show all 15
On GovTribe
Work with this file on GovTribe
- 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 .