Exhibit 65 - Aug 2024 to Jul 2025 City of Miami CIGNA Lag Report Incurred Date included - Monthly Healthcare Experience by Acct Rlg 12-1.xlsx

XLSX spreadsheet 32 KB Posted

Attached to
RFP No. 2130386 - Employee Health Benefits Plan
Solicitation number
RFP No. 2130386 - Employee Health Benefits Plan
Issued by
Florida

About this file

Written by GovTribe AI ·

This document is a monthly healthcare lag report for the City of Miami, spanning from August 2024 through July 2025, detailing healthcare claims and expenses over a 12-month period. The report, labeled as Exhibit 65, provides a comprehensive retrospective experience-rated analysis of all reported claims, tracking paid claims across various incurred dates from November 2016 to July 2025.

The report shows a total account claim amount of $48,583,443 for the specified period, with monthly variations in claim volumes and values. Significant monthly claim totals range from around $3.2 million to $4.5 million, with peak months like August 2024 and July 2024 showing particularly high claim amounts of $3,646,729 and $2,114,740 respectively. The document appears to be part of a healthcare benefits planning and tracking process for the City of Miami, likely related to the referenced RFP No. 2130386 for an Employee Health Benefits Plan in Florida, providing detailed financial insights into healthcare claim expenditures.

View the file

Other files

File Type Posted
Exhibit 18b - Cal Yr 2025 City of Miami CIGNA ASO and Fixed Charges Monthly Healthcare Experience by Prod YTD.xlsx XLSX spreadsheet
Exhibit 15b - City of Miami Cal Yr 2025 CIGNA Medical - Comp EEs Plan 70 Percent Ded 300 Max Out of Pocket 1K ASO68.pdf PDF
Exhibit 50 - Cal Yr 2024 City of Miami CIGNA Vision Plans Claim Summary Report.pdf PDF
Questionnaire No. 4 (Revised) - Group Benefit Dental Plan.pdf PDF
Exhibit 74 - Cal Yr 2023 City of Miami ASO Fixed Charges and Fees Per Product Type Monthly Healthcare Detail Experience.xlsx XLSX spreadsheet
Exhibit 06d - Cal Yr 2025 City of Miami CIGNA Dental PPO Territorial Legislation - 23 States ETALLD25B.pdf PDF
Exhibit 22 - Cal Yr 2025 City of Miami CIGNA Sum Ben Cov Comp EEs No Rx- Out Of Area Plan - Plan 70 Pct Ded 300 Max Out of Pocket 1K ASO67.pdf PDF
Exhibit 30a - Cal Yr 2025 City of MIami CIGNA VIS Vision Benefit imbedded in Medical Plan Document ASO71.pdf PDF
Attachment A - City of Miami Living Wage Ordinance.pdf PDF
Exhibit 11a - Cal Yr 2022 City of Miami CIGNA Total Health Insight - Claims paid Feb 2023.pdf PDF
Exhibit 18 (Revised) -Cal Yrs 2023-2024 CIGNA City of Miami CAP Report_Redacted.pdf PDF
Exhibit 37 - Cal Yr 2022 City of Miami Stop Loss - Greater than 50K High Claimant Report De-ID Dx.xlsx XLSX spreadsheet
Exhibit 54a - Cal Yr 2025 City of Miami CIGNA Medical - Administrative Services Only ASO And Stop Loss Fees Schedule.pdf PDF
Exhibit 16b - Cal Yr 2025 City of Miami CIGNA Open Access Plan (OAP) Medicare No Rx - Comp EEs Plan 80 Percent Ded 500 Max Out of Pocket 2K ASO70.pdf PDF
Exhibit 03 - City of Miami AFSCME 1907 General Employees Union Contract Oct 1 2023 - Sep 30 2026.pdf PDF
Exhibit 28 - Cal Yr 2025 City of Miami Comprehensive Buy UP Vision Benefit Summary Fully Insured (VISE) C1 PPO.pdf PDF
Exhibit 07 - Cal Yr 2024 City of Miami CIGNA EGWP Medicare - Evidence of Coverage Snapshot.pdf PDF
Exhibit 62 - Cal Yr 2025 City of Miami CIGNA FSA Healthcare - Summary Plan Document.pdf PDF
Exhibit 57a - Cal Yr 2025 City of Miami CIGNA Rx - Standard 3-Tier Prescription Drug List.pdf PDF
Exhibit 35 - Cal Yr 2024 City of Miami CIGNA Dental PPO Summary of Benefits Summary.pdf PDF
Exhibit 02 - City of Miami AFSCME 871 Sanitation Employees Union Contract Oct 1 2023 - Sep 30 2026.pdf PDF
Exhibit 16 - Cal Yr 2024 City of Miami CIGNA Open Access Plan (OAP) Medicare No Rx - Comp EEs Plan 80 Percent Ded 500 Max Out of Pocket 2K ASO66.pdf PDF
Exhibit 26 - Cal Yr 2025 City of Miami Imputed Biweekly Income Table for Domestic Partner Medical Coverage.pdf PDF
Exhibit 69 - Cal Yr 2024 City of Miami RX CAP Report Plan Exec Summ and Top 20 Therapeutic Drugs.ppt PPT presentation
Exhibit 24 - Cal Yr 2025 City of Miami Benefits Biweekly Premiums.pdf PDF
Exhibit 40 - 2025 City of Miami Medical Network Access Disruption Report.pdf PDF
Exhibit 11b - Cal Yr 2023 City of Miami CIGNA Total Health Insight - Claims paid Feb 2024.pdf PDF
Exhibit 09d - Cal Yr 2024 City of Miami CIGNA Vision - Monthly Healthcare Experience INN OON Total Claims Subs Mbrs.xlsx XLSX spreadsheet
Attachment B - Reference Submittal Form.pdf PDF
Questionnaire No. 2 - Stop Loss Insurance.pdf PDF
Exhibit 25 - Cal Yr 2025 City of Miami Cobra Monthly Premiums.pdf PDF
Questionnaire No. 3 (Revised) - Prescription Drugs (Rx).pdf PDF
Exhibit 51a - Cal Yr 2024 City of Miami CIGNA ASO Monthly Fees Healthcare Experience by Benefit Option Rolling 12 BenOpt-1.xlsx XLSX spreadsheet
Exhibit 21 - Cal Yr 2025 City of Miami CIGNA Summary Benefits Coverage OAP - Out Of Area - Ded 300 Maximum Out of Pocket 1K Comp EEs.pdf PDF
Exhibit 08a - Cal Yr 2025 City of Miami CIGNA Medicare EGWP Prescription Drug Plan.pdf PDF
Exhibit 07a - Cal Yr 2025 City of Miami CIGNA Healthcare EGWP Rx Prescription Drug Plan and Summary of Benefits.pdf PDF
Exhibit 57b - Cal Yr 2025 City of Miami YTD as of Apr Stats by Ther Class _ Brand - Healthcare Spend and Trend - Pharmacy - Paid.xlsx XLSX spreadsheet
Exhibit 09b - Cal Yr 2025 City of Miami CIGNA VISE Comprehensive BuyUp Vision Certificate HP-POL1053.pdf PDF
Exhibit 20 - Cal Yr 2025 City of Miami Medicare No Rx - SBC_OAP Plan Comp 300 Ded 300 Max Out of Pocket 1K.pdf PDF
Exhibit 23 - Cal Yr 2025 City of Miami CIGNA Summary Benefits Coverage Open Access Plan - All employees.pdf PDF
Exhibit 27. 2025 City of Miami Master CIGNA Census De-ID All Benefit Options.xlsx XLSX spreadsheet
Exhibit 32 - Cal Yr 2023 CIty of Miami CIGNA Lag Report Incurred Date included - Monthly Healthcare Experience Lag Report by Acct Rolling 12-1.xlsx XLSX spreadsheet
Exhibit 68 - Cal Yr 2024 City of Miami RX Stats by Ther Class _ Brand Healthcare Spend and Trend.xlsx XLSX spreadsheet
Exhibit 14 - Cal Yr 2024 City of Miami CIGNA Medicare Benefits - Comp EEs No Rx Plan 70 Percent Ded 300 Max Out Of Pocket 1K ASO65.pdf PDF
Questionnaire No. 6 - Employee Assistance Program.pdf PDF
Exhibit 48 - Cal Yr 2024 City of Miami CIGNA Dental Experience.xlsx XLSX spreadsheet
Exhibit 54b - Cal Yr 2025 City of Miami Stop CIGNA ISL and ASL Coverage Information Amendment Plan 3202272 CSL-SCH(10-15).pdf PDF
Exhibit 55 - Cal Yr 2025 as of Apr EAP Network Analysis Report Access 118974.pdf PDF
Exhibit 38 - Cal Yr 2023 City of Miami Stop Loss - Greater than 50K High Claimant Report De-ID Dx.xlsx XLSX spreadsheet
Exhibit 15 - City of Miami Cal Yr 2024 CIGNA Medical - Comp EEs Plan 70 Percent Ded 300 Max Out of Pocket 1K ASO64.pdf PDF
Show 40 more

Latest 50 of 115 listed here. See the rest on GovTribe.

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Lag by Acct Rllg12-1

CITY OF MIAMI
MONTHLY HEALTHCARE LAG REPORT
August 2024 thru July 2025
EXHIBIT 65
Incurred Date : All
Rating Type : RETROSPECTIVE EXPERIENCE RATED
Reported Claims: All Claims
ACCOUNTINCURRED DATEAug-2024Sep-2024Oct-2024Nov-2024Dec-2024Jan-2025Feb-2025Mar-2025Apr-2025May-2025Jun-2025Jul-2025TOTAL PAID CLAIMS
3202272Nov-16$0$0$0$0$0$0$0($468)$0$0$0$0($468)
Apr-18$0$0($90)$0$0$0$0$0$0$0$0$0($90)
Aug-18$0$0$32,694$0$0$0$0$0$0$0$0$0$32,694
Oct-18$0($4)($145)$0$0$0$0$0($158)$0$0$0($306)
Nov-18($44)$0$0($82)$0$0$0$0$0$0$0$0($126)
Jan-20$0$0$0$0$0$0$0$0$0$0$30$130$160
Feb-20$0$0$0$0$0$0$0($309)$0($49)$0$0($358)
Mar-20$0$0$0$0$0$0$0$0($11)$0$0$0($11)
Jan-21$0$0$0$0$0$0$0$0$0$0$25,875$0$25,875
Mar-21$0$0$0$0$0$0$0$0$0$0$158,039$0$158,039
Apr-21$0($19)$0$0$0$0$0$0$0$0$6,827$0$6,808
May-21$0$0$0$0$0$0$0$0$0$0$27,341$0$27,341
Jun-21$0$0$0$0$0$0$0$0$0($1,447)$0$0($1,447)
Jul-21$0$0$0$0$0$0$0$0$0$0($10)$0($10)
Aug-21$0$0$0$0$0$0$0$0$0$0$7,257$0$7,257
Sep-21$0$0$0$0$0$0$0$0$0$0$151$0$151
Oct-21$0$12($12)$0$0$0$0$0$0$0$0$0$0
Nov-21$0$4($4)$0($6,171)$0$0$0$0$0$0$0($6,171)
Dec-21$0$75($19)$0$0$0$0$0$0$0$851$0$907
Jan-22($478)$13$41$0$0$0$0$0($72)$0$0$0($495)
Feb-22($250)$0($18)$0$0($5,869)$0$0$0$0$0$0($6,137)
Mar-22($1,774)($264)$0$0$0$0($875)$10,723$0$0$0($1)$7,810
Apr-22$0$0$0($67)$0$0$0$0$0$0$0$0($67)
May-22$0$0$0$0$0$0$0$0$35$0$0$0$35
Jun-22($405)$1,487$0$547$0$0$0$0$0$0($57,336)$0($55,707)
Jul-22$0($176)$0$0$134$0$0$0$0$0$0$0($43)
Aug-22$2,829$0$0$0$0$0$0$1,800$0$0$0$17$4,645
Sep-22$81($97)($103)$0$0$317$0$0$0$0($350)$0($152)
Oct-22$1,083$3,112($790)$0$0$288$0($12)$0$742$0$0$4,422
Nov-22($2,886)$79$551$0$0($165)($205)$0($596)$742$0$0($2,478)
Dec-22$105$60$0$826$0$739$0$428$2,400$428$571$0$5,556
Jan-23($965)($164)$799$0$0$2,726($273)$596$1,265$998$285$0$5,267
Feb-23($12)$2,299$460$89$0$1,016$0$428$394$143$143$0$4,959
Mar-23($0)($329)$3,571($2,155)$15$1,452$1,275$143($629)$143$0$0$3,485
Apr-23$1,274$12($22,811)$179$162$425$0$0($1,076)$396$40$0($21,399)
May-23$1,343$4,891$0($181)($8,793)$870$135($427)$966($3,735)$0$0($4,931)
Jun-23$120$3,647$1,532$0$84$651$589$0$2,651$5,849$17($234)$14,907
Jul-23($1,270)$5,115$5,971($1,144)$0$3,976$6,087$0($3,603)$5,519$101$0$20,752
Aug-23($91)$2,963$1,368($22,746)$486$395$351($17,703)($381)$3,496$396$0($31,466)
Sep-23($1,386)$5,904($1)$208$489$1,062$508$22$34$5,151$856$0$12,848
Oct-23$1,451$6,466$136,303$348($482)$1,215$3,093$1,587$939$2,014($1,179)($742)$151,014
Nov-23($3,723)$3,791($2,419)$0($2,415)($2,411)$1,994$771($223)$63$50$299($4,225)
Dec-23$9,438$3,226$2,912($4,686)$12,182$503$20,414$197$23$5,412$0$358$49,979
Jan-24$25,778$3,444$16,559$844$49,017($20,306)$1,350($2,124)$2,433$6,948($2,827)($2,829)$78,287
Feb-24$82,235$37,602($4,843)$132,681($627)($6,343)$1,002$652($3,906)($827)($583)$21,454$258,498
Mar-24$103,046$9,217$12,452($1,774)$70,668$93,644($5,901)$81$254$1,407$1,223$4,867$289,183
Apr-24$42,493($31,044)$9,268$1,641$1,258$14,899$32,206$2,703$5,601$498$5,919$2,100$87,542
May-24$69,328$16,198$39,978$8,240$14,349$2,237$294$853$30,721($19,658)$315($158)$162,695
Jun-24$284,043$75,605$64,648$134,491($63,319)($1,286)$12,860($12,499)($24,798)$2$953$0$470,701
Jul-24$1,434,158$263,676$20,585$20,394$37,607$158,620$115,873$22,591$7,972($29,506)$733$62,038$2,114,740
Aug-24$1,950,831$1,306,748$163,208$164,888$6,911$19,622$42,708$6,704$5,577$1,281($7,949)($13,800)$3,646,729
Sep-24$0$1,620,703$1,191,037$164,787$57,746$56,769$13,005$6,722$10,285$116,346$16,940$10,073$3,264,411
Oct-24$0$0$2,014,149$1,166,860$354,567$128,723$47,877$9,883$136,497$37,258$10,850($22,902)$3,883,763
Nov-24$0$0$0$736,704$2,398,148$184,826$34,701$305,278$38,965$8,075$57,786$14,780$3,779,263
Dec-24$0$0$0$0$2,083,737$1,282,104$270,118$26,880$167,196$149,941$18,403$22,207$4,020,585
Jan-25$0$0$0$0$0$2,003,896$1,729,973$224,086$93,049$361,350$51,950$29,935$4,494,240
Feb-25$0$0$0$0$0$0$1,875,223$1,610,693$222,097$390,056($2,226)$2,253$4,098,096
Mar-25$0$0$0$0$0$0$0$1,905,143$1,673,295$105,575$18,111$60,521$3,762,645
Apr-25$0$0$0$0$0$0$0$0$2,403,221$1,435,694$168,504$15,377$4,022,795
May-25$0$0$0$0$0$0$0$0$0$2,114,125$1,477,821$528,521$4,120,467
Jun-25$0$0$0$0$0$0$0$0$0$0$1,846,564$1,598,370$3,444,934
Jul-25$0$0$0$0$0$0$0$0$0$0$0$2,175,046$2,175,046
ACCOUNT Total$3,996,353$3,344,249$3,686,831$2,500,892$5,005,753$3,924,595$4,204,384$4,105,419$4,770,417$4,704,429$3,832,440$4,507,682$48,583,443
INCURRED DATE TotalsNov-16$0$0$0$0$0$0$0($468)$0$0$0$0($468)
Apr-18$0$0($90)$0$0$0$0$0$0$0$0$0($90)
Aug-18$0$0$32,694$0$0$0$0$0$0$0$0$0$32,694
Oct-18$0($4)($145)$0$0$0$0$0($158)$0$0$0($306)
Nov-18($44)$0$0($82)$0$0$0$0$0$0$0$0($126)
Jan-20$0$0$0$0$0$0$0$0$0$0$30$130$160
Feb-20$0$0$0$0$0$0$0($309)$0($49)$0$0($358)
Mar-20$0$0$0$0$0$0$0$0($11)$0$0$0($11)
Jan-21$0$0$0$0$0$0$0$0$0$0$25,875$0$25,875
Mar-21$0$0$0$0$0$0$0$0$0$0$158,039$0$158,039
Apr-21$0($19)$0$0$0$0$0$0$0$0$6,827$0$6,808
May-21$0$0$0$0$0$0$0$0$0$0$27,341$0$27,341
Jun-21$0$0$0$0$0$0$0$0$0($1,447)$0$0($1,447)
Jul-21$0$0$0$0$0$0$0$0$0$0($10)$0($10)
Aug-21$0$0$0$0$0$0$0$0$0$0$7,257$0$7,257
Sep-21$0$0$0$0$0$0$0$0$0$0$151$0$151
Oct-21$0$12($12)$0$0$0$0$0$0$0$0$0$0
Nov-21$0$4($4)$0($6,171)$0$0$0$0$0$0$0($6,171)
Dec-21$0$75($19)$0$0$0$0$0$0$0$851$0$907
Jan-22($478)$13$41$0$0$0$0$0($72)$0$0$0($495)
Feb-22($250)$0($18)$0$0($5,869)$0$0$0$0$0$0($6,137)
Mar-22($1,774)($264)$0$0$0$0($875)$10,723$0$0$0($1)$7,810
Apr-22$0$0$0($67)$0$0$0$0$0$0$0$0($67)
May-22$0$0$0$0$0$0$0$0$35$0$0$0$35
Jun-22($405)$1,487$0$547$0$0$0$0$0$0($57,336)$0($55,707)
Jul-22$0($176)$0$0$134$0$0$0$0$0$0$0($43)
Aug-22$2,829$0$0$0$0$0$0$1,800$0$0$0$17$4,645
Sep-22$81($97)($103)$0$0$317$0$0$0$0($350)$0($152)
Oct-22$1,083$3,112($790)$0$0$288$0($12)$0$742$0$0$4,422
Nov-22($2,886)$79$551$0$0($165)($205)$0($596)$742$0$0($2,478)
Dec-22$105$60$0$826$0$739$0$428$2,400$428$571$0$5,556
Jan-23($965)($164)$799$0$0$2,726($273)$596$1,265$998$285$0$5,267
Feb-23($12)$2,299$460$89$0$1,016$0$428$394$143$143$0$4,959
Mar-23($0)($329)$3,571($2,155)$15$1,452$1,275$143($629)$143$0$0$3,485
Apr-23$1,274$12($22,811)$179$162$425$0$0($1,076)$396$40$0($21,399)
May-23$1,343$4,891$0($181)($8,793)$870$135($427)$966($3,735)$0$0($4,931)
Jun-23$120$3,647$1,532$0$84$651$589$0$2,651$5,849$17($234)$14,907
Jul-23($1,270)$5,115$5,971($1,144)$0$3,976$6,087$0($3,603)$5,519$101$0$20,752
Aug-23($91)$2,963$1,368($22,746)$486$395$351($17,703)($381)$3,496$396$0($31,466)
Sep-23($1,386)$5,904($1)$208$489$1,062$508$22$34$5,151$856$0$12,848
Oct-23$1,451$6,466$136,303$348($482)$1,215$3,093$1,587$939$2,014($1,179)($742)$151,014
Nov-23($3,723)$3,791($2,419)$0($2,415)($2,411)$1,994$771($223)$63$50$299($4,225)
Dec-23$9,438$3,226$2,912($4,686)$12,182$503$20,414$197$23$5,412$0$358$49,979
Jan-24$25,778$3,444$16,559$844$49,017($20,306)$1,350($2,124)$2,433$6,948($2,827)($2,829)$78,287
Feb-24$82,235$37,602($4,843)$132,681($627)($6,343)$1,002$652($3,906)($827)($583)$21,454$258,498
Mar-24$103,046$9,217$12,452($1,774)$70,668$93,644($5,901)$81$254$1,407$1,223$4,867$289,183
Apr-24$42,493($31,044)$9,268$1,641$1,258$14,899$32,206$2,703$5,601$498$5,919$2,100$87,542
May-24$69,328$16,198$39,978$8,240$14,349$2,237$294$853$30,721($19,658)$315($158)$162,695
Jun-24$284,043$75,605$64,648$134,491($63,319)($1,286)$12,860($12,499)($24,798)$2$953$0$470,701
Jul-24$1,434,158$263,676$20,585$20,394$37,607$158,620$115,873$22,591$7,972($29,506)$733$62,038$2,114,740
Aug-24$1,950,831$1,306,748$163,208$164,888$6,911$19,622$42,708$6,704$5,577$1,281($7,949)($13,800)$3,646,729
Sep-24$0$1,620,703$1,191,037$164,787$57,746$56,769$13,005$6,722$10,285$116,346$16,940$10,073$3,264,411
Oct-24$0$0$2,014,149$1,166,860$354,567$128,723$47,877$9,883$136,497$37,258$10,850($22,902)$3,883,763
Nov-24$0$0$0$736,704$2,398,148$184,826$34,701$305,278$38,965$8,075$57,786$14,780$3,779,263
Dec-24$0$0$0$0$2,083,737$1,282,104$270,118$26,880$167,196$149,941$18,403$22,207$4,020,585
Jan-25$0$0$0$0$0$2,003,896$1,729,973$224,086$93,049$361,350$51,950$29,935$4,494,240
Feb-25$0$0$0$0$0$0$1,875,223$1,610,693$222,097$390,056($2,226)$2,253$4,098,096
Mar-25$0$0$0$0$0$0$0$1,905,143$1,673,295$105,575$18,111$60,521$3,762,645
Apr-25$0$0$0$0$0$0$0$0$2,403,221$1,435,694$168,504$15,377$4,022,795
May-25$0$0$0$0$0$0$0$0$0$2,114,125$1,477,821$528,521$4,120,467
Jun-25$0$0$0$0$0$0$0$0$0$0$1,846,564$1,598,370$3,444,934
Jul-25$0$0$0$0$0$0$0$0$0$0$0$2,175,046$2,175,046
Grand Total$3,996,353$3,344,249$3,686,831$2,500,892$5,005,753$3,924,595$4,204,384$4,105,419$4,770,417$4,704,429$3,832,440$4,507,682$48,583,443

&G &7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law. ADVICE Reporting System &8Page &P of &N Date: 8/6/2025 image1.png

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