Exhibit_H_-_Claims_Experience_(2_TABS_to_VIEW)_FINAL.xlsx

XLSX spreadsheet 61 KB Posted

Attached to
25-P-115TF Self-Funded Group Health Plan Administrative Services
Solicitation number
25-P-115TF
Issued by
Volusia County, Florida

About this file

Exhibit H – Claims Experience Summary

This document is a claims experience exhibit submitted by Volusia County, Florida in support of its RFP 25-P-115TF for self-funded group health plan administrative services. The exhibit presents comprehensive claims data spanning from January 2021 through February 2025, detailing medical and pharmacy claims paid by the county's self-insured health plan. The data is organized into two primary sections: a Claims Summary by Month showing monthly membership, contract counts, and detailed breakdowns of inpatient facility claims, outpatient facility claims, professional claims, and pharmacy claims; and a Claims Lags analysis demonstrating the timing and lag pattern of claims payments by service month. The membership data indicates relatively stable enrollment ranging from approximately 3,047 to 3,202 contracts with 6,171 to 6,349 total members throughout the period, while medical claims payments fluctuate monthly between approximately $2.0 million and $4.0 million, with pharmacy claims ranging between $0.8 million and $1.6 million monthly.

The cumulative claims data reveals total medical claims paid of approximately $152.6 million over the 50-month observation period, with total pharmacy claims of approximately $52.9 million, resulting in combined grand total claims of approximately $205.5 million. The Claims Lags section provides detailed analysis of payment timing, indicating that the majority of claims are paid within one to two months of service delivery, with the diagonal of each matrix representing current-month paid claims and subsequent columns representing prior-period claims adjustments and lag payments. This historical claims experience data serves as a critical baseline for prospective vendors to understand the county's anticipated claims volume, cost trends, and administrative processing requirements when submitting proposals for the January 1, 2027 contract effective date.

View the file

Other files

File Type Posted
25-P-115TF_Self-Funded_Group_Health_Plan_Administrative_Services_(Addendum_#6_Revision).pdf PDF
25-P-115TF_Self-Funded_Group_Health_Plan_Administrative_Services.pdf PDF
Exhibit_D_-_Insurance_Requirements_(For_DRAFT_Contract)_FINAL_.pdf PDF
25-P-115TF_Self-Funded_Group_Health_Plan_Admin_Srvs_Agreement_FINAL_DRAFT.pdf PDF
Exhibit_M_-_Pharmacy_Claims_Pricing_File_(1_TAB_TO_COMPLETE,_DO_NOT_SUBMIT)_FINAL.xlsx XLSX spreadsheet
Exhibit_L_-_Medical_Discount_Pricing_File_(3_TABS_TO_COMPLETE,_DO_NOT_SUBMIT)_FINAL.xlsx XLSX spreadsheet
Exhibit_K_–_Medical_Claims_Pricing_File_(3_TABS_TO_COMPLETE,_DO_NOT_SUBMIT)_FINAL.xlsx XLSX spreadsheet
Exhibit_J_-_Large_Claims_2022-2024_(3_TABS_to_VIEW)_FINAL.xlsx XLSX spreadsheet
Exhibit_I_-_Census_(3_TABS_to_VIEW)_FINAL.xlsx XLSX spreadsheet
Exhibit_H_-_Claims_Experience_(2_TABS_to_VIEW)_FINAL.xlsx XLSX spreadsheet
Exhibit_G_-_County_Computing_Security_Procedures_FINAL.pdf PDF
Exhibit_F_-_HIPPA_Business_Associate_Agreement_FINAL.pdf PDF
Exhibit_E_-_Human_Trafficking_Affidavit_FINAL.pdf PDF
Exhibit_C_-_Summary_Plan_Document_(2025)_FINAL.pdf PDF
Attachment_B.1_Pharmacy_Pricing_Guarantees_(1_TAB_TO_COMPLETE)_FINAL.xlsx XLSX spreadsheet
Exhibit_B_-_Fees_and_Performance_Guarantees_FINAL.docx DOCX document
Exhibit_A.4_-_Onsite_Job_Descriptions_FINAL.pdf PDF
Exhibit_A.3_-_Claims_Reporting_Fields_FINAL.pdf PDF
Attachment_A.2_-_Network_and_Formulary_Disruption_(4_TABS_TO_COMPLETE)_FINAL.xlsx XLSX spreadsheet
Attachment_A.1_-_Worksheet_Health_Plan_Administrative_Services_FINAL.docx DOCX document
Exhibit_A_-_Scope_of_Services_FINAL.pdf 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

Claims Summary by Month

COUNTY OF VOLUSIA
EXHIBIT 'H', CLAIMS EXPERIENCE
Claims Summary and Eligibility by Month 01/2022 - 02/2025
MEMBERSHIPCLAIMS PAYMENTS
Paid
DateContractsMembersInpatientOutpatientTotal
FacilityProfessionalTotal
MedicalPharmacyGrand

Total

Jan-222,9885,967$685,727$1,017,746$1,703,473$872,156$2,575,629$839,771$3,415,401
Feb-223,1876,250$414,199$856,194$1,270,394$995,323$2,265,716$938,216$3,203,932
Mar-223,1706,222$1,442,884$1,047,593$2,490,477$1,040,946$3,531,423$819,457$4,350,881
Apr-223,1606,204$434,281$939,134$1,373,415$1,066,592$2,440,007$854,071$3,294,078
May-223,1476,171$657,086$1,138,310$1,795,396$1,134,843$2,930,239$896,338$3,826,576
Jun-223,1536,183$768,902$1,088,561$1,857,463$938,763$2,796,226$954,818$3,751,043
Jul-223,1486,196$864,040$1,179,506$2,043,546$1,004,887$3,048,433$846,523$3,894,956
Aug-223,1566,199$981,856$1,136,955$2,118,811$1,116,977$3,235,788$987,047$4,222,835
Sep-223,1416,179$1,595,893$1,204,558$2,800,451$1,203,628$4,004,079$945,171$4,949,250
Oct-223,1896,246$518,618$976,608$1,495,225$984,790$2,480,015$822,122$3,302,137
Nov-223,1926,252$919,201$1,006,226$1,925,427$1,215,442$3,140,869$964,777$4,105,645
Dec-223,2026,277$1,244,200$1,085,546$2,329,747$1,151,566$3,481,313$886,281$4,367,594
Jan-233,1936,331$966,092$1,315,816$2,281,908$989,433$3,271,341$957,056$4,228,397
Feb-233,1776,304$985,589$1,039,765$2,025,354$1,133,494$3,158,847$992,714$4,151,561
Mar-233,1786,303$1,138,636$1,296,536$2,435,173$1,071,683$3,506,855$900,586$4,407,441
Apr-233,1816,299$618,521$1,413,650$2,032,170$1,100,457$3,132,627$1,004,093$4,136,720
May-233,1846,310$624,136$1,149,226$1,773,362$1,232,021$3,005,382$1,057,698$4,063,081
Jun-233,1906,328$818,025$1,122,530$1,940,555$1,276,573$3,217,128$1,024,143$4,241,271
Jul-233,1966,349$1,151,882$1,029,668$2,181,551$1,114,936$3,296,486$937,502$4,233,988
Aug-233,1866,340$1,310,531$1,171,551$2,482,082$1,233,063$3,715,145$1,190,220$4,905,365
Sep-233,1746,314$1,121,378$1,106,043$2,227,421$1,179,117$3,406,538$912,061$4,318,599
Oct-233,1916,337$1,167,103$1,037,566$2,204,669$1,158,563$3,363,232$1,060,480$4,423,712
Nov-233,1776,305$724,225$892,630$1,616,855$1,153,284$2,770,140$1,097,364$3,867,503
Dec-233,1806,312$764,819$1,059,665$1,824,484$1,369,027$3,193,511$1,042,657$4,236,168
Jan-243,1896,256$1,204,488$984,469$2,188,956$1,007,484$3,196,440$1,182,942$4,379,383
Feb-243,1726,228$688,214$1,126,766$1,814,980$1,165,309$2,980,289$1,111,981$4,092,270
Mar-243,1576,222$684,989$1,014,918$1,699,907$1,074,092$2,773,999$997,906$3,771,904
Apr-243,1626,224$606,583$997,584$1,604,168$1,410,318$3,014,486$1,286,879$4,301,365
May-243,1806,264$751,711$1,095,940$1,847,652$1,267,804$3,115,455$1,209,741$4,325,196
Jun-243,1836,248$878,300$1,136,889$2,015,188$1,140,321$3,155,509$1,438,860$4,594,369
Jul-243,1816,266$935,749$1,312,808$2,248,556$1,235,729$3,484,286$1,326,971$4,811,257
Aug-243,1996,288$1,474,673$1,120,363$2,595,036$1,330,298$3,925,334$1,513,619$5,438,953
Sep-243,2016,308$980,084$1,252,660$2,232,744$1,088,636$3,321,380$1,627,394$4,948,775
Oct-243,1836,279$889,850$1,263,085$2,152,934$1,508,303$3,661,237$1,376,144$5,037,381
Nov-243,1686,268$822,568$476,237$1,298,805$605,440$1,904,244$1,416,041$3,320,286
Dec-243,1716,282$1,447,775$2,145,928$3,593,703$1,849,135$5,442,838$1,457,692$6,900,530
Jan-253,1586,204$785,421$1,189,816$1,975,237$1,246,612$3,221,849$1,265,597$4,487,446
Feb-253,1566,216$517,796$1,290,739$1,808,536$1,328,349$3,136,885$1,332,361$4,469,245

&"Arial,Bold"25-P-115TF &"Arial,Bold"Exhibit H - Claims Experience

&"Arial,Regular"Page &P of &N

Claims Lags

VOLUSIA COUNTY GOVERNMENT
MEDICAL CLAIMS
Paid MonthTotal PaidJan-21Feb-21Mar-21Apr-21May-21Jun-21Jul-21Aug-21Sep-21Oct-21Nov-21Dec-21Jan-22Feb-22Mar-22Apr-22May-22Jun-22Jul-22Aug-22Sep-22Oct-22Nov-22Dec-22Jan-23Feb-23Mar-23Apr-23May-23Jun-23Jul-23Aug-23Sep-23Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24Sep-24Oct-24Nov-24Dec-24
Jan-21$1,130,603$1,130,603$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Feb-21$1,935,112$1,026,481$908,630$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Mar-21$2,537,966$200,921$1,396,959$940,085$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Apr-21$2,743,620$12,803$85,084$1,673,963$971,769$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
May-21$2,670,688$40,275$20,990$238,251$1,499,915$871,257$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jun-21$3,089,616$28,439$41,012$174,109$110,571$1,434,729$1,300,756$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jul-21$3,058,792$5,770$15,532$18,385$14,224$393,891$1,476,949$1,134,041$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Aug-21$2,958,483$1,609$5,230$15,654$6,130$21,536$155,651$1,365,893$1,386,779$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Sep-21$3,115,569-$795$1,749-$4,763$4,072$20,294$98,737$194,394$1,341,751$1,460,129$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Oct-21$2,635,568$1,557-$52-$4,375$1,960$7,564$24,756$185,833$159,750$1,047,189$1,211,386$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Nov-21$2,754,212$9,727-$6,730-$7,102-$4,074$4,433$3,226$1,852$156,697$334,785$1,170,640$1,090,759$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Dec-21$2,564,148$9,578$508-$726$399$2,758$7,005$44,406$39,605$74,470$226,306$1,089,349$1,070,491$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jan-22$2,597,784$2,294$889-$1,115$2-$16,834$60,375$3,039$13,825$116,839$157,222$222,612$1,121,936$916,700$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Feb-22$2,263,852$349$172$147$7,033$358$1,392$30,425$3,483$2,689$122,216$32,262$213,113$938,252$911,961$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Mar-22$3,528,997$275$295$723$4,510-$4,767$476,616$19,819$6,562$9,162$46,212$13,855$112,393$556,860$1,378,051$908,431$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Apr-22$2,437,369$335$544$16,327$1,918-$2,792$1,096$2,346$3,137$2,771-$27,649$2,661$5,712$52,427$275,674$1,100,436$1,002,424$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
May-22$2,931,919-$124-$28$708-$5,225$2,085$8,339$1,011-$802$1,013-$5,723$2,204$15,212$67,047$15,375$304,009$1,348,190$1,178,630$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jun-22$2,789,348$0-$553$416-$110$1,094$14,338-$36,648$1,799$2,534-$11,373-$3,779$18,338$37,405$67,165$139,255$187,315$1,160,381$1,211,772$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jul-22$3,049,562$114-$285$126$255$416$325$1,124$258-$2,440-$1,636$2,394-$3,687$5,016$15,417$44,657$171,743$378,404$1,231,528$1,205,834$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Aug-22$3,226,410-$100-$12$0$170$1,442$873$0-$1,051-$104-$42,141-$2,869$1,393$1,230$4,941$32,056$33,435$298,505$386,209$1,041,260$1,471,174$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Sep-22$4,004,802-$149-$430-$900$1,066-$133$1,728$40,518-$114$1,335$8,521$24,504-$8,056$3,400-$6,186$810$31,357$303,166$103,547$292,798$1,793,163$1,414,857$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Oct-22$2,480,038$0-$548$0-$115$623$1,840$614$5,097-$2,359-$342$1,744-$1,517-$300$1,212$1,730$11,859$19,950$21,236$114,542$244,139$893,331$1,167,300$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Nov-22$3,147,168$0$0$0$0$120,904$6,850$0$0$14$4,670$1,265-$639$1,210$13,877$6,365$713$1,626$9,432$12,824$64,362$163,676$1,560,425$1,179,593$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Dec-22$3,481,574$0-$442$0$0$1,448-$748-$147-$1,105-$358$5,552-$1,114$384-$467-$212$1,634$3,288$34,001-$7,171$146,512$46,402$175,468$324,054$1,276,355$1,478,241$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jan-23$3,261,254$0$0-$592-$314-$38,942$917-$424-$2,058-$292-$74$40$944$30,910-$127$385,060$2,350$4,252$1,534$5,471$225,112$15,789$108,846$169,965$863,334$1,489,554$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Feb-23$3,159,688-$188$0$0-$122-$64-$792-$785-$21-$94-$162-$325$173$627-$1,914$2,304$1,477-$9,174-$9,131$234,639$5,844$17,160$17,714$116,751$213,576$1,049,162$1,523,032$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Mar-23$3,506,858$0$0$0-$135$0$864$0$110$0-$295$9,566$4,533$69$1,888-$76$37$769$19,778$4,754$54,395$4,470$103,193$250,986$68,100$370,302$1,168,393$1,445,158$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Apr-23$3,130,628-$26-$220-$3,257$23,023$0-$13$20-$4,725-$962$0-$599$0$56$99-$121$828-$25-$575$6,969$10$24,918-$851$21,699$33,277$37,742$147,961$1,296,784$1,548,614$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
May-23$3,006,837$0$0$0-$73$0-$19-$1,666-$823$75$0-$2,644-$1,297$1,783-$578-$529-$666$3,453$22,502-$1,278$213$13,836$8,820$3,903$39,416$15,848$93,462$412,360$997,758$1,402,980$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jun-23$3,218,016$0$675$0$2,226$0$24-$161$0-$8,115$0$0$0$415$1,321$1,509$14,466-$13-$2,151$2,840-$39,750-$10,954-$3,693$52,409$163$16,208$62,746$79,320$116,348$1,077,185$1,854,999$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jul-23$3,296,103$0$0$0$204$0$0$0$0$0$0$0-$75$44-$5,449$3,197-$314$0$767$6,356$52,792-$2,349$271$12,772$6,836$4,284$15,504$152,362$142,204$390,007$1,322,584$1,194,105$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Aug-23$3,715,145$0$0$0$0$0$1,991-$324-$146$0$0-$8,616-$26$1,837$209$4,730-$98$1,761-$6,498$2,018-$2,509$734$10,832-$5,065$1,449-$3,318$35,736$16,749$222,140$49,973$145,965$1,624,049$1,621,576$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Sep-23$3,381,181$0$0$0-$39-$30$0-$26,043$0$0$0-$584$594-$2,457$248-$97-$779$0-$420$2,298$35-$55$9,778$312-$4,277$12,689$3,196$21,453$53,093$50,609$45,409$184,517$1,555,786$1,475,947$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Oct-23$3,375,276$0$0$0-$306$0$0-$537-$124$0-$377$0$0-$2,472-$129$2,835-$206$228-$33,794-$381-$666$6,157-$1,336-$23,919$1,791-$29,375$1,974$33,079$55,945$87,030$70,531$81,408$226,914$1,484,048$1,416,962$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Nov-23$2,778,514$0$0$0-$1$0$0-$1$0$0-$1$0$166-$109$0-$12,108-$124$122$124$205-$2,683-$1,269$1,408-$682$4,249$649$5,669$10,933$6,440-$420$4,679$63,145$113,922$205,297$1,166,035$1,212,867$0$0$0$0$0$0$0$0$0$0$0$0$0
Dec-23$3,211,463-$113$0$0$0$0$0$0$0$0$0$96$96$78$123$1,185$207-$10,911$3,882$29-$8,625$0$0-$1,155$11,696-$1,346$1,189-$1,520$6,128$10,170$32,129$63,394$387,594$62,943$269,556$1,124,033$1,260,605$0$0$0$0$0$0$0$0$0$0$0$0
Jan-24$3,216,845$0$0$0-$226$0$0-$465$46,724$0-$2,185-$615$0$0$0$50-$118-$2,494$0$156-$897$6,295-$190$0-$405$0$0$12,241$2,426$9,010$4,229$552,825$28,909$12,530$30,242$227,325$1,037,008$1,254,468$0$0$0$0$0$0$0$0$0$0$0
Feb-24$3,014,029-$25-$25-$51$1,081-$78-$382-$51-$33-$68-$51-$270-$2,205-$933-$259-$912-$83$0-$225-$276-$120-$2,738-$61,501-$960-$55-$1,754-$94-$284$1,110-$15,921$8,053-$762$6,833$18,763$62,740$358,732$421,103$1,168,292$1,057,437$0$0$0$0$0$0$0$0$0$0
Mar-24$2,790,509$0$0$0$0-$11$0$0$0$0-$2,605$0$0$0$0-$2,835$0$0$0$99$122-$71$23-$1,680$15,728-$1,420$34,906-$3,370-$4,096-$473$16,718-$13,301-$921$3,562-$607$16,416$41,553$127,096$1,030,688$1,534,988$0$0$0$0$0$0$0$0$0
Apr-24$3,018,976$0$0$0$0$0$0$0$0$0$0-$81-$87-$420-$55$0-$1,661-$163$0$0$0$0$0$0$551$174$69-$105-$647$660-$5,975$2,123-$7,526$234$18,995$6,080$54,554$54,650$185,425$1,197,146$1,515,034$0$0$0$0$0$0$0$0
May-24$3,115,455$0$0$0$0$0$0$0$0$0$0$81$82$0$0$0$0$0$0$0$10,296$2,584$8,190-$856$6,110$1,387$9,428$4,948$5,972$3,221$15,710$15,178$22,352$2,240-$418$6,330$52,494$7,378$56,783$119,308$1,103,032$1,663,627$0$0$0$0$0$0$0
Jun-24$3,156,174-$1,813-$129$0$0$0$0-$129$0$0$0$81$0-$187-$3,963$0$35$20-$436-$26$0$146$96$0-$39,302$131$0$12-$1,978-$3,541-$193$21,784-$3,039-$7,343$4,721$31,989$2,700$21,090$125,285$120,703$107,650$1,304,409$1,477,404$0$0$0$0$0$0
Jul-24$3,485,724$0$0$0$0$0$0$0$0$0$51-$575$5$195$125-$78-$254$669$4,654$0$5,300$336$352$1,855$6,276-$227$66-$7,061-$1,586$92-$5,240-$1,386$210$571$10,022$133,610$5,521$49,891$10,841$69,949$71,404$211,628$1,035,039$1,883,467$0$0$0$0$0
Aug-24$3,926,311$644$0$3,089$0$0$0$0$0$0$1,118-$4,213$0-$134$34$43-$62$2,775-$122$6,286$353$5,941$1,007$6,737$586$5,882-$1,887-$544-$1,135-$123-$10,040$598$47-$589$1,636-$2,490$39,691-$39,998$5,793$69,398$53,010$84,883$210,469$1,733,316$1,754,312$0$0$0$0
Sep-24$3,321,380$0-$3,081-$1,947$0$0$0$0$0$0$0-$100$0$30$0$3,123$0$191-$223-$6,159$8,738$0$1,053$6,904$24,111$46,290$680$629-$6,394-$76-$662$1,062$24,590$6,259-$162$11,502-$11,560$5,661$1,447$2,688$25,393$4,351$11,746$70,280$1,610,654$1,484,360$0$0$0
Oct-24$3,661,350$0$0$0-$7,500$0$0$0$0$0$0-$85$0$0$0-$500$0$0$0$0$0$151$0-$3,579-$246$81$0-$1,701$0$0$2,777$0-$503$11,926$3,576$260$329$1,872$6,403$4,696$49,341$43,257$10,491$42,664$164,553$1,537,461$1,795,625$0$0
Nov-24$1,904,244$0-$79$2,497$0$0$0$0-$41$0$0$0$0$0$0$0$0$0$0$0-$100$1,449$0$570$0$220-$100-$187$721$651$2,175$1,348$126$567$147$1,969$212$2,749$8,634-$435$12,906$5,589$15,598$5,888$15,381$30,280$1,368,144$427,369$0
Dec-24$5,442,838$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0-$976-$1,395$0$0-$53-$909$0$92-$394$4,167-$938$2,300-$2,203-$2,405$0-$6,046$1,659-$2,014$2,304$13,969$798$18,025$35,435$193,999$245,192$478,511$2,537,594$1,926,127
Jan-25$3,223,226$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$2,665$5,104$5,349$59-$2,232-$2,907$0$29,405-$6,904$0$0$0$372-$455$2-$960-$1,036$23,725$1,846$1,488$78,212$1,613$69,435$67,762$18,329-$5,372$115,572$1,142,218
Feb-25$3,136,885$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$142$26-$289$0-$42$11,950$0$788$867$1,932$2,102-$608-$532$987$3,007$1,260$6,630$21,078$4,657$41,630$55,124$66,262$12,925$25,098$79,574
TOTAL$152,588,108$2,468,441$2,465,658$3,059,652$2,632,288$2,821,181$3,642,692$2,957,952$3,154,537$3,038,213$2,859,282$2,467,003$2,547,975$2,608,110$2,668,851$2,926,166$2,805,356$3,366,122$2,956,218$3,077,768$3,927,102$2,731,549$3,259,502$3,068,263$2,731,407$3,010,904$3,097,826$3,471,254$3,172,516$3,065,687$3,508,012$3,789,938$3,980,033$3,277,057$2,982,687$3,128,017$2,896,672$2,654,759$2,513,454$3,123,852$2,959,857$3,417,831$2,785,042$3,882,115$3,861,785$3,381,883$3,649,834$3,105,633$3,147,919
PHARMACY CLAIMS
Paid MonthTotal PaidJan-21Feb-21Mar-21Apr-21May-21Jun-21Jul-21Aug-21Sep-21Oct-21Nov-21Dec-21Jan-22Feb-22Mar-22Apr-22May-22Jun-22Jul-22Aug-22Sep-22Oct-22Nov-22Dec-22Jan-23Feb-23Mar-23Apr-23May-23Jun-23Jul-23Aug-23Sep-23Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24Sep-24Oct-24Nov-24Dec-24
Jan-21$634,096$634,096$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Feb-21$1,067,376$237,768$829,608$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Mar-21$832,785$347$125,104$707,334$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Apr-21$923,502$378$754$224,839$697,531$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
May-21$1,005,786$13,200$12,565$154$269,951$709,916$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jun-21$948,285$0$8$0$259$239,099$708,919$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jul-21$916,258$0$0$235$0$456$210,492$705,074$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Aug-21$919,447$0$0$305$0$318$24,695$238,103$656,025$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Sep-21$1,066,323$0$0$0$0$0$0$52$316,297$749,974$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Oct-21$905,988$424$678$384$81$1,322$121$1,928$547$180,306$720,197$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Nov-21$1,060,953$0$0$0$40$94$40$80$241$204$234,008$826,245$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Dec-21$1,140,273$83$103$407$538$390$165$476$106$62,960$98,480$217,476$759,088$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jan-22$839,771$0$0$103$80$80$0$80$40$0$414$1,097$281,786$556,091$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Feb-22$938,216$0$0$0$40$80$0$0$0$0$0$165$1,493$225,375$711,062$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Mar-22$819,457$0$0$0$0$2,495$0$0$0$0$0$40$53$1,008$166,885$648,977$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Apr-22$854,071$20$17$0$40$0$0$0$0$40$0$0$0$1,856$2,309$271,086$578,704$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
May-22$896,338$0$0$0$0$0$0$0$0$0$0$40$0$0$0$1,186$249,401$645,711$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jun-22$954,818$0$0$0$0$0$0$0$0$0$0$40$0$297$406$0$1,082$230,290$722,702$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jul-22$846,523$0$0$0$0$0$0$0$0$0$0$0$40$0$0$0$43$9,793$233,831$602,817$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Aug-22$987,047$0$0$0$0$0$0$0$0$0$0$0$0$0$337$337$374$0$417$251,705$733,878$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Sep-22$945,171$0$0$0$0$0$0$0$285$0$0$0$0$0$0$0$0$0$18$476$331,632$612,760$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Oct-22$822,122$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$24$146,988$675,109$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Nov-22$964,777$0$0$0$0$0$0$0$0$380$0$4$0$0$0$0$0$0$0$0$0$0$259,263$705,130$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Dec-22$886,281$0$0$0$0$0$0$0$0$0$0$0$331$0$0$0$0$0$835$936$899$248$1,162$255,812$626,057$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jan-23$957,056$0$0$0$0$0$0$0$0$0$0$0$0$337$1$0$2$0$0$0$2$0$66$3,754$290,703$662,190$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Feb-23$992,714$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$41$2,038$297,537$693,098$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Mar-23$900,586$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$45$3,557$250,111$646,874$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Apr-23$1,004,093$0$0$2$11$6$2$0$2$2$0$14$0$0$0$0$6$0$0$0$0$0$0$0$0$50$467$315,995$687,534$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
May-23$1,057,698$0$0$0$0$0$0$0$0$0$0$331$0$0$0$0$0$0$0$0$0$0$0$0$36$0$8$1,728$303,271$752,325$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jun-23$1,024,143$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$403$32$0$0$0$0$0$0$0$0$24$3,396$244,128$776,160$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Jul-23$937,502$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$76$0$0$0$0$0$695$2,308$245,278$689,145$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Aug-23$1,190,220$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$1,630$2,420$310,734$875,436$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Sep-23$912,061$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$6$0$0$0$0$0$0$5,114$334$2,746$288,491$615,369$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Oct-23$1,060,480$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$48$339$0$0$0$0$0$0$0$0$0$1,240$874$355,711$702,268$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Nov-23$1,097,364$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$36$678$0$0$0$0$0$0$0$3,481$0$29$979$352,671$739,490$0$0$0$0$0$0$0$0$0$0$0$0$0
Dec-23$1,042,657$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$2,503$345,197$694,957$0$0$0$0$0$0$0$0$0$0$0$0
Jan-24$1,182,942$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$13$0$12$0$0$0$0$0$1,284$208$291,180$890,246$0$0$0$0$0$0$0$0$0$0$0
Feb-24$1,111,981$0$0$31$0$38$32$0$0$69$0$0$0$63$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$34$150$310,641$800,923$0$0$0$0$0$0$0$0$0$0
Mar-24$997,906$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$14$0$0$0$0$253,865$744,027$0$0$0$0$0$0$0$0$0
Apr-24$1,286,879$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$347$0$0$0$0$0$0$0$0$209$1,596$16,349$342,666$925,712$0$0$0$0$0$0$0$0
May-24$1,209,741$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$347$0$0$0$0$0$0$0$0$4,144$5,760$330,990$868,500$0$0$0$0$0$0$0
Jun-24$1,438,860$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$45$1,189$1,188$531,151$905,287$0$0$0$0$0$0
Jul-24$1,326,971$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$56$0$327$307$0$0$0$0$76$346,118$980,086$0$0$0$0$0
Aug-24$1,513,619$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$29$917$300$528,291$984,082$0$0$0$0
Sep-24$1,627,394$0$0$0$0$0$0$0$0$0$0$0$0$226$46$0$0$0$0$0$0$0$0$0$0$14$18$0$0$0$0$0$0$7,954$10,056$6,726$3,464$3,451$0$0$0$0$0$0$442,402$1,153,037$0$0$0
Oct-24$1,376,144$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$17$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$11$2,246$1,004$1,046$29$47$408,274$963,469$0$0
Nov-24$1,416,041$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$1,679$426,255$988,108$0
Dec-24$1,457,692$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$2,712$351,356$1,103,624
Jan-25$1,265,597$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$488$35$6$0$0$0$0$0$0$0$67$111$77$375,383
Feb-25$1,332,361$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$861$5,060$2,151$2,534$3,457$1,845$6,937$4,377$4,282$3,996$4,421$12,941
TOTAL$52,896,365$886,315$968,838$933,794$968,572$954,295$944,466$945,793$973,545$993,935$1,053,099$1,045,453$1,042,792$785,254$881,046$921,586$829,612$886,213$957,834$855,935$1,066,483$760,371$936,361$964,737$918,879$963,348$943,715$964,968$994,907$1,005,852$1,027,674$1,003,865$1,164,830$980,082$1,068,782$1,092,471$990,303$1,206,801$1,080,385$1,095,804$1,262,700$1,405,105$1,254,597$1,515,344$1,430,908$1,567,338$1,396,543$1,343,962$1,491,948

&"Arial,Bold"25-P-115TF &"Arial,Bold"Exhibit H - Claims Experience (Claims Lags)

&"Arial,Regular"Page &P of &N

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it. Updated .