Exhibit 31 - Cal Yr 2024 City of Miami CIGNA Lag Report Incurred Date included - Monthly Healthcare Experience by Acct Rolling 12-1.xlsx

XLSX spreadsheet 32 KB Posted

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

About this file

Written by GovTribe AI ·

This document is a monthly healthcare lag report for the City of Miami, spanning calendar year 2024 and prepared by CIGNA, detailing retrospective experience-rated claims data. The report tracks paid claims from May 2013 through December 2024, with a comprehensive monthly breakdown of healthcare expenditures across various incurred date periods. The total account claims for the entire reporting period amount to $46,783,552, with monthly variations ranging from negative adjustments to significant positive claims.

The report appears to be supporting documentation for a larger Employee Health Benefits Plan request for proposals (RFP No. 2130386), specifically for the state of Florida. The claims data provides a detailed financial history and projected healthcare spending, which likely serves as critical background information for potential healthcare plan providers bidding on the City of Miami's health insurance contract. The granular monthly breakdown allows for precise analysis of claims trends, including retrospective adjustments, and provides insights into the city's healthcare utilization and financial performance across different reporting periods.

View the file

Other files

File Type Posted
Exhibit 50 - Cal Yr 2024 City of Miami CIGNA Vision Plans Claim Summary Report.pdf PDF
Exhibit 39 - Cal Yr 2024 City of Miami Stop Loss - High Claimant Report De-ID Dx.xlsx XLSX spreadsheet
Exhibit 14b - Cal Yr 2025 City of Miami CIGNA Medicare Benefits - Comp EEs No Rx Plan 70 Percent Ded 300 Max Out Of Pocket 1K ASO69.pdf PDF
Questionnaire No. 2 - Stop Loss Insurance.pdf PDF
Exhibit 46 - Cal Yr 2025 City of Miami Benefit Eligible Employees as of Sep 2025.xlsx XLSX spreadsheet
Exhibit 69 - Cal Yr 2024 City of Miami RX CAP Report Plan Exec Summ and Top 20 Therapeutic Drugs.ppt PPT presentation
Exhibit 01a - Cal Yr 2025 YTD as of June City of Miami Monthly Healthcare Detail Experience - Stop Loss ALL claims.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 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 51 - Cal Yr 2023 City of Miami CIGNA Claims by Benefits and ASO Fees Monthly Healthcare Experience by Benefit Option Rolling 12 BenOpt-1.xlsx XLSX spreadsheet
Exhibit 52a - Cal Yr 2022 City of Miami CIGNA Pooled Stop Loss High Claims Greater than 50K Experience De-ID.xlsx XLSX spreadsheet
Questionnaire No. 7 - Flexible Spending Accounts.pdf PDF
Exhibit 06c - Cal Yr 2025 City of Miami CIGNA Dental PPO Certificate Riders and Coverage for other states ETALLD25B Plan 3202272 HC-IMP35.pdf PDF
Exhibit 47 - Cal Yr 2023 City of Miami CIGNA Dental Exp.xlsx XLSX spreadsheet
Questionnaire No. 5 - Group Benefit Vision Plan.pdf PDF
Exhibit 29 - Cal Yr 2025 City of Miami CIGNA OAP No Rx PlanMedical Benefits - Summary Benefits Coverage POST 65.pdf PDF
Exhibit 25 - Cal Yr 2025 City of Miami Cobra Monthly Premiums.pdf PDF
Exhibit 03 - City of Miami AFSCME 1907 General Employees Union Contract Oct 1 2023 - Sep 30 2026.pdf PDF
Exhibit 45 - Cal Yr 2024 City of Miami EAP - EAP Utilization.pptx PPTX presentation
Exhibit 05 - Cal Yr 2024 City of Miami CIGNA Dental HMO Plan Document.pdf PDF
2130386 - Sample PSA.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 44 - Cal Yrs 2025 _ 2026 EAP Renewal Letter.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 37 - Cal Yr 2022 City of Miami Stop Loss - Greater than 50K High Claimant Report De-ID Dx.xlsx XLSX spreadsheet
Questionnaire No. 8 - COBRA.pdf PDF
Exhibit 55 - Cal Yr 2025 as of Apr EAP Network Analysis Report Access 118974.pdf PDF
Exhibit 57c - Cal Yr 2025 YTD as of Jul - City of Miami CIGNA Pharmacy RX Dispensed Report.xlsx XLSX spreadsheet
Exhibit 08 - Cal Yr 2024 City of Miami CIGNA EGWP Medicare Formulary.pdf PDF
Exhibit 62 - Cal Yr 2025 City of Miami CIGNA FSA Healthcare - Summary Plan Document.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 49 - Cal Yr 2023 City of Miami CIGNA Vision Plans Claim Summary Report.pdf PDF
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 34 - Cal Yr 2025 City of Miami CIGNA Dental HMO Summary with Patient Charge Schedule.pdf PDF
Exhibit 42 - Cal Yr 2025 City of Miami CIGNA TC19 Disruption Report - Total Records Total Claimants Total Eligible Charges Summary.xlsx XLSX spreadsheet
Exhibit 61 - Cal Yr 2025 City of Miami CIGNA FSA Dependent Care - Summary Plan Document.pdf PDF
Exhibit 41a - Cal Yr 2025 City of Miami CIGNA Medical - Disruption Detail with Provider TIN - Option 1 - OAP-OA001 RITM9284277_TC19.xlsx XLSX spreadsheet
Exhibit 59 - City of Miami CIGNA Medical - Professional Services Agreement AMENDMENT NO 1 May 6 2021 ASO Agreement with Fees.pdf PDF
Exhibit 02 - City of Miami AFSCME 871 Sanitation Employees Union Contract Oct 1 2023 - Sep 30 2026.pdf PDF
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
Exhibit 30a - Cal Yr 2025 City of MIami CIGNA VIS Vision Benefit imbedded in Medical Plan Document ASO71.pdf PDF
Exhibit 18 - Cal Yrs 2023 _ 2024 City of Miami CIGNA FIXED Charges Report - PRR.xlsx XLSX spreadsheet
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
Attachment A - City of Miami Living Wage Ordinance.pdf PDF
Exhibit 19 - Cal Yr 2025 City of Miami CIGNA Medical - SBC Comp Ded 300 Max Out of Pocket 1K.pdf PDF
Exhibit 63 - Aug 2024 to Jul 2025 City of Miami CIGNA Claims by Benefits and ASO Fees Monthlty Healthcare Experience by Ben Option Rlg 12.xlsx XLSX spreadsheet
Exhibit 17c - Cal Yr 2025 City of Miami CIGNA Healthcare Massachusetts Rider for OAP Plans HC-RDR1.pdf PDF
Exhibit 54a - Cal Yr 2025 City of Miami CIGNA Medical - Administrative Services Only ASO And Stop Loss Fees Schedule.pdf PDF
Exhibit 05c - Cal Yr 2025 City of Miami CIGNA Dental HMO Certificate Riders and Coverage for 7 States ETALLD25A Plan 3202272 HC-ETRDR.pdf PDF
Exhibit 06d - Cal Yr 2025 City of Miami CIGNA Dental PPO Territorial Legislation - 23 States ETALLD25B.pdf PDF
Show 40 more

Latest 50 of 114 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
January 2024 thru December 2024
EXHIBIT 31
Incurred Date : All
Rating Type : RETROSPECTIVE EXPERIENCE RATED
Reported Claims: All Claims
ACCOUNTINCURRED DATEJan-2024Feb-2024Mar-2024Apr-2024May-2024Jun-2024Jul-2024Aug-2024Sep-2024Oct-2024Nov-2024Dec-2024TOTAL PAID CLAIMS
3202272May-13$0$0$0$0$0$0$88$0$0$0$0$0$88
Jun-13$0$0$0$0$0$39$0$0$0$0$0$0$39
Jul-16$0$0$0$0$85$0$0$0$0$0$0$0$85
Oct-17$0$0$0$0$0$0($48)$0$0$0$0$0($48)
Feb-18($35)$0$0$0$0$0$0$0$0$0$0$0($35)
Apr-18$0$0$0$0$0$0$0$0$0($90)$0$0($90)
Aug-18$0$0$0$0$0$0$0$0$0$32,694$0$0$32,694
Oct-18$0$0$0$0$0$0$0$0($4)($145)$0$0($149)
Nov-18$0$0$0($130)$0$0$0($44)$0$0($82)$0($256)
Mar-19$0$0$0$0($79)$0$0$0$0$0$0$0($79)
Jun-19$0$0$0$0($7,342)$0$0$0$0$0$0$0($7,342)
Aug-19$0$0$0$0($271)$0$0$0$0$0$0$0($271)
Sep-19$0$0$0$0($132)$0$0$0$0$0$0$0($132)
Oct-19$0$0$0$0($378)$0$0$0$0$0$0$0($378)
Nov-19$0$0$0$0($1,582)$0($365)$0$0$0$0$0($1,947)
Dec-19$0$0$0$0($216)$0$0$0$0$0$0$0($216)
Mar-20$0$107$0$0$0$0$0$0$0$0$0$0$107
Apr-20$0$0$0$0($15,000)$60$155$0$0$0$0$0($14,784)
May-20$0$0$0$0$0$72$111$0$0$0$0$0$183
Jun-20$0$0$0$0$0$39$0$0$0$0$0$0$39
Jul-20$0$0$0$0$0$0$128$0$0$0$0$0$128
Aug-20$0($24)$0$0$0$0$0$0$0$0$0$0($24)
Nov-20$0$100$0$0$0$0$0$0$0$0$0$0$100
Dec-20$449$272$0$0$0($30)($73)$0$0$0$0$0$618
Jan-21$0$0$95$0$0$0$0$0$0$0$0$0$95
Feb-21$0($1,257)($530)$0$0$0$0$0$0$0$0$0($1,787)
Mar-21$0($649)$0$0$0$0$0$0$0$0$0$0($649)
Apr-21$0$0$0$0$0$61,236$0$0($19)$0$0$0$61,217
May-21$0$0$0$0$50$0$0$0$0$0$0$0$50
Jun-21$0$0$0$0$30($99)$0$0$0$0$0$0($69)
Jul-21($190)$190$0$0$0$0$0$0$0$0$0$0$0
Aug-21$0($3,713)$41$0$5,569$0$0$0$0$0$0$0$1,898
Sep-21$0$0($243)$41$41$0($532)$0$0$0$0$0($692)
Oct-21$26$0$303$145$41$0$0$0$12($12)$0$0$516
Nov-21$18$651$248$83$0$0($173)$0$4($4)$0($6,171)($5,344)
Dec-21$0($55)$1,076$690($18)$0$83$0$75($19)$0$0$1,831
Jan-22$76$0$219$450($31)$0($95)($478)$13$41$0$0$195
Feb-22($10,577)$6$262$116$41$0$30,063($250)$0($18)$0$0$19,644
Mar-22$139$264($77,949)$418($15,948)$0$258($1,774)($264)$0$0$0($94,854)
Apr-22$103$0$372$206$0$0$0$0$0$0($67)$0$614
May-22($136)$53$1,068$495$83$0$41$0$0$0$0$0$1,605
Jun-22$41$2,913$1,647$41$41$1,483($3,007)($405)$1,487$0$547$0$4,789
Jul-22$1,178$738$2,231$537$83$0$0$0($176)$0$0$134$4,723
Aug-22($5)($16)$515$207$40,061$685$41$2,829$0$0$0$0$44,316
Sep-22$151($614)$352$265($1,839)$30$0$81($97)($103)$0$0($1,774)
Oct-22($284)($2,347)$2,886($14,812)$0$0$363$1,083$3,112($790)$0$0($10,789)
Nov-22$255$26,216$6,695$11,972$0($605)($446)($2,886)$79$551$0$0$41,831
Dec-22($2,457)$850$1,229$2,751($883)$143$0$105$60$0$826$0$2,624
Jan-23$354$68,195$2,421$124$26$97($13)($965)($164)$799$0$0$70,874
Feb-23$1,953$747$294$2,069($536)$568($875)($12)$2,299$460$89$0$7,055
Mar-23$3,265($32,415)$1,114$491($231)$900$3,723($0)($329)$3,571($2,155)$15($22,051)
Apr-23$1,751$1,751$926$791$717$670$1,792$1,274$12($22,811)$179$162($12,786)
May-23$12,884($2,089)$2,722$6,634$58($662)$34$1,343$4,891$0($181)($8,793)$16,841
Jun-23$4,979$2,283($36,296)$446$2,565$874($728)$120$3,647$1,532$0$84($20,493)
Jul-23$2,516($180)$1,474$1,078($152)$1,937$193($1,270)$5,115$5,971($1,144)$0$15,537
Aug-23$46,880($1,038)$723$2,344($247)$430$615($91)$2,963$1,368($22,746)$486$31,688
Sep-23$16,049$9,707$9,912$1,079$8,053$22,013$1,102($1,386)$5,904($1)$208$489$73,130
Oct-23$51,000$67,824$300,087$165,970$2,185($190)($7,383)$1,451$6,466$136,303$348($482)$723,579
Nov-23$319,578$282,617$40,248$43,585$9,772$9,429$910($3,723)$3,791($2,419)$0($2,415)$701,373
Dec-23$1,163,682$99,271$93,411$69,970$7,042$2,204$16,534$9,438$3,226$2,912($4,686)$12,182$1,475,187
Jan-24$1,606,237$2,003,948$446,392$55,911$9,862$56,246$102,114$25,778$3,444$16,559$844$49,017$4,376,351
Feb-24$0$1,375,180$1,806,509$467,795$64,169$255,351$104,678$82,235$37,602($4,843)$132,681($627)$4,320,730
Mar-24$0$0$1,763,779$1,779,839$313,097$175,836$225,181$103,046$9,217$12,452($1,774)$70,668$4,451,340
Apr-24$0$0$0$1,804,001$1,569,855$275,617$104,891$42,493($31,044)$9,268$1,641$1,258$3,777,980
May-24$0$0$0$0$1,812,609$1,383,977$495,331$69,328$16,198$39,978$8,240$14,349$3,840,009
Jun-24$0$0$0$0$0$1,878,774$1,375,639$284,043$75,605$64,648$134,491($63,319)$3,749,882
Jul-24$0$0$0$0$0$0$1,971,562$1,434,158$263,676$20,585$20,394$37,607$3,747,982
Aug-24$0$0$0$0$0$0$0$1,950,831$1,306,748$163,208$164,888$6,911$3,592,585
Sep-24$0$0$0$0$0$0$0$0$1,620,703$1,191,037$164,787$57,746$3,034,272
Oct-24$0$0$0$0$0$0$0$0$0$2,014,149$1,166,860$354,567$3,535,576
Nov-24$0$0$0$0$0$0$0$0$0$0$736,704$2,398,148$3,134,852
Dec-24$0$0$0$0$0$0$0$0$0$0$0$2,083,737$2,083,737
ACCOUNT Total$3,219,879$3,899,487$4,374,234$4,405,603$3,801,252$4,127,125$4,421,894$3,996,353$3,344,249$3,686,831$2,500,892$5,005,753$46,783,552
INCURRED DATE TotalsMay-13$0$0$0$0$0$0$88$0$0$0$0$0$88
Jun-13$0$0$0$0$0$39$0$0$0$0$0$0$39
Jul-16$0$0$0$0$85$0$0$0$0$0$0$0$85
Oct-17$0$0$0$0$0$0($48)$0$0$0$0$0($48)
Feb-18($35)$0$0$0$0$0$0$0$0$0$0$0($35)
Apr-18$0$0$0$0$0$0$0$0$0($90)$0$0($90)
Aug-18$0$0$0$0$0$0$0$0$0$32,694$0$0$32,694
Oct-18$0$0$0$0$0$0$0$0($4)($145)$0$0($149)
Nov-18$0$0$0($130)$0$0$0($44)$0$0($82)$0($256)
Mar-19$0$0$0$0($79)$0$0$0$0$0$0$0($79)
Jun-19$0$0$0$0($7,342)$0$0$0$0$0$0$0($7,342)
Aug-19$0$0$0$0($271)$0$0$0$0$0$0$0($271)
Sep-19$0$0$0$0($132)$0$0$0$0$0$0$0($132)
Oct-19$0$0$0$0($378)$0$0$0$0$0$0$0($378)
Nov-19$0$0$0$0($1,582)$0($365)$0$0$0$0$0($1,947)
Dec-19$0$0$0$0($216)$0$0$0$0$0$0$0($216)
Mar-20$0$107$0$0$0$0$0$0$0$0$0$0$107
Apr-20$0$0$0$0($15,000)$60$155$0$0$0$0$0($14,784)
May-20$0$0$0$0$0$72$111$0$0$0$0$0$183
Jun-20$0$0$0$0$0$39$0$0$0$0$0$0$39
Jul-20$0$0$0$0$0$0$128$0$0$0$0$0$128
Aug-20$0($24)$0$0$0$0$0$0$0$0$0$0($24)
Nov-20$0$100$0$0$0$0$0$0$0$0$0$0$100
Dec-20$449$272$0$0$0($30)($73)$0$0$0$0$0$618
Jan-21$0$0$95$0$0$0$0$0$0$0$0$0$95
Feb-21$0($1,257)($530)$0$0$0$0$0$0$0$0$0($1,787)
Mar-21$0($649)$0$0$0$0$0$0$0$0$0$0($649)
Apr-21$0$0$0$0$0$61,236$0$0($19)$0$0$0$61,217
May-21$0$0$0$0$50$0$0$0$0$0$0$0$50
Jun-21$0$0$0$0$30($99)$0$0$0$0$0$0($69)
Jul-21($190)$190$0$0$0$0$0$0$0$0$0$0$0
Aug-21$0($3,713)$41$0$5,569$0$0$0$0$0$0$0$1,898
Sep-21$0$0($243)$41$41$0($532)$0$0$0$0$0($692)
Oct-21$26$0$303$145$41$0$0$0$12($12)$0$0$516
Nov-21$18$651$248$83$0$0($173)$0$4($4)$0($6,171)($5,344)
Dec-21$0($55)$1,076$690($18)$0$83$0$75($19)$0$0$1,831
Jan-22$76$0$219$450($31)$0($95)($478)$13$41$0$0$195
Feb-22($10,577)$6$262$116$41$0$30,063($250)$0($18)$0$0$19,644
Mar-22$139$264($77,949)$418($15,948)$0$258($1,774)($264)$0$0$0($94,854)
Apr-22$103$0$372$206$0$0$0$0$0$0($67)$0$614
May-22($136)$53$1,068$495$83$0$41$0$0$0$0$0$1,605
Jun-22$41$2,913$1,647$41$41$1,483($3,007)($405)$1,487$0$547$0$4,789
Jul-22$1,178$738$2,231$537$83$0$0$0($176)$0$0$134$4,723
Aug-22($5)($16)$515$207$40,061$685$41$2,829$0$0$0$0$44,316
Sep-22$151($614)$352$265($1,839)$30$0$81($97)($103)$0$0($1,774)
Oct-22($284)($2,347)$2,886($14,812)$0$0$363$1,083$3,112($790)$0$0($10,789)
Nov-22$255$26,216$6,695$11,972$0($605)($446)($2,886)$79$551$0$0$41,831
Dec-22($2,457)$850$1,229$2,751($883)$143$0$105$60$0$826$0$2,624
Jan-23$354$68,195$2,421$124$26$97($13)($965)($164)$799$0$0$70,874
Feb-23$1,953$747$294$2,069($536)$568($875)($12)$2,299$460$89$0$7,055
Mar-23$3,265($32,415)$1,114$491($231)$900$3,723($0)($329)$3,571($2,155)$15($22,051)
Apr-23$1,751$1,751$926$791$717$670$1,792$1,274$12($22,811)$179$162($12,786)
May-23$12,884($2,089)$2,722$6,634$58($662)$34$1,343$4,891$0($181)($8,793)$16,841
Jun-23$4,979$2,283($36,296)$446$2,565$874($728)$120$3,647$1,532$0$84($20,493)
Jul-23$2,516($180)$1,474$1,078($152)$1,937$193($1,270)$5,115$5,971($1,144)$0$15,537
Aug-23$46,880($1,038)$723$2,344($247)$430$615($91)$2,963$1,368($22,746)$486$31,688
Sep-23$16,049$9,707$9,912$1,079$8,053$22,013$1,102($1,386)$5,904($1)$208$489$73,130
Oct-23$51,000$67,824$300,087$165,970$2,185($190)($7,383)$1,451$6,466$136,303$348($482)$723,579
Nov-23$319,578$282,617$40,248$43,585$9,772$9,429$910($3,723)$3,791($2,419)$0($2,415)$701,373
Dec-23$1,163,682$99,271$93,411$69,970$7,042$2,204$16,534$9,438$3,226$2,912($4,686)$12,182$1,475,187
Jan-24$1,606,237$2,003,948$446,392$55,911$9,862$56,246$102,114$25,778$3,444$16,559$844$49,017$4,376,351
Feb-24$0$1,375,180$1,806,509$467,795$64,169$255,351$104,678$82,235$37,602($4,843)$132,681($627)$4,320,730
Mar-24$0$0$1,763,779$1,779,839$313,097$175,836$225,181$103,046$9,217$12,452($1,774)$70,668$4,451,340
Apr-24$0$0$0$1,804,001$1,569,855$275,617$104,891$42,493($31,044)$9,268$1,641$1,258$3,777,980
May-24$0$0$0$0$1,812,609$1,383,977$495,331$69,328$16,198$39,978$8,240$14,349$3,840,009
Jun-24$0$0$0$0$0$1,878,774$1,375,639$284,043$75,605$64,648$134,491($63,319)$3,749,882
Jul-24$0$0$0$0$0$0$1,971,562$1,434,158$263,676$20,585$20,394$37,607$3,747,982
Aug-24$0$0$0$0$0$0$0$1,950,831$1,306,748$163,208$164,888$6,911$3,592,585
Sep-24$0$0$0$0$0$0$0$0$1,620,703$1,191,037$164,787$57,746$3,034,272
Oct-24$0$0$0$0$0$0$0$0$0$2,014,149$1,166,860$354,567$3,535,576
Nov-24$0$0$0$0$0$0$0$0$0$0$736,704$2,398,148$3,134,852
Dec-24$0$0$0$0$0$0$0$0$0$0$0$2,083,737$2,083,737
Grand Total$3,219,879$3,899,487$4,374,234$4,405,603$3,801,252$4,127,125$4,421,894$3,996,353$3,344,249$3,686,831$2,500,892$5,005,753$46,783,552

&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: 1/7/2025 image1.png

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