471F0983-EB69-959C-3B62A289547CA11E.xlsx

XLSX spreadsheet 27 KB Posted

Attached to
Wayfinding Signage Manufacturing and Installation
Solicitation number
RFP 2026-03-03
Issued by
Franklin County, Ohio

About this file

This is a Paid & Incurred (P&I) Limited Dental Claims Exhibit for Franklin County Cooperative Health Improvement Program (plan number 157775) as of July 31, 2025. The document presents comprehensive claims experience data and individual claim listings spanning from January 1, 2020, through August 1, 2025. The exhibit covers six experience periods plus a claim lag period, tracking metrics across an average of 2,050 covered lives with monthly enrollment ranging from 1,779 to 2,460 participants. Key performance indicators include paid claims totaling $1,516,944, incurred claims of $2,693,725, case reserves of $1,331,916, and IBNR reserves of $15,294 across the entire experience period. The program reflects a claim incidence rate of 5.13 per 1,000 lives with an average cost per claim of $50,989 and an incurred loss ratio (adjusted) of 0.788.

The detailed claim listing includes 78 individual LTD claims with disability dates ranging from January 3, 2020, through January 17, 2025. Claims are categorized by Social Security status (SSA for approved benefits, SSP for pending status, and NED for those not eligible or denied), claim status (active, declined, waiting, ended, inactive, incomplete, or pending), and monthly gross benefits ranging from approximately $1,252 to $5,446. The exhibit demonstrates active claim management with 18 open claims, 51 total open/closed claims, 2 pending claims, and 34 denied claims across the experience period. Current monthly indemnity payments total $42,702, with reserves established for 18 active claims totaling $1,331,916, reflecting the program's ongoing liability and reserve adequacy for disability benefit administration.

View the file

Other files

File Type Posted
E13134B7-AC80-2A6B-17903505A1365FE4.pdf PDF
7D243EA3-FAAD-CF0C-AFFD3FFE55D5912C.pdf PDF
B867E43E-FCA2-ABC6-686473D3D551080B.docx DOCX document
9124AC45-D403-5860-A4635A70C618C298.pdf PDF
1FF6D412-D5CF-E3DA-42373990EB63A4DE.docx DOCX document
48C4F0C3-D2EA-9DD6-943661FD67266514.pdf PDF
1FF81613-C943-E907-903208614AFFB273.pdf PDF
48C51FFE-B1BA-D9DA-11337A7B04016CA4.pdf PDF
1FF79148-03D3-7B1B-77CF64FD687ECA4C.pdf PDF
8F33C1D9-B606-E1D0-F77CFF24E442EF1B.pdf PDF
1FF834AF-CB60-B607-A9DD3103FF766EDA.pdf PDF
47ADF7AD-983F-9719-2E5C720D20F03E5A.xlsx XLSX spreadsheet
8BD45E27-AD3D-2A81-9DC34421F6415618.pdf PDF
98B00E89-F3C2-2215-1B6B7A585EA6B903.pdf PDF
4ADBDA30-A10A-65AC-2585EBF3396EC49F.pdf PDF
4540076D-DA44-888C-413CAB868FEC6141.xlsx XLSX spreadsheet
600B382B-92C2-EE01-36E3171A1CE23381.pdf PDF
9188FC82-07E6-2A24-E7927A56369C067A.pdf PDF
441C7CE8-FE79-FFAD-86876E5C9E330E9F.pdf PDF
477EEBB5-9B64-4073-39F4D92B43E61BB0.pdf PDF
A3F924CA-A2E1-A38A-2E6F296BD4EAE5D4.pdf PDF
1FF70774-E56E-EAC8-88A7694DAF5EB82C.pdf PDF
48C71F36-F14E-8501-2A85945F358C6068.xlsx XLSX spreadsheet
8B00ECA9-D368-AD09-80DA20EDC1915543.pdf PDF
47A070EA-AA3B-485A-6C240303241C99D2.pdf PDF
D1C78A42-D40E-4E7A-6D1A7D2FA849B7AF.pdf PDF
441CC2FC-B00B-E914-728A3B9F6E284C71.pdf PDF
1FF7330C-CAC3-999B-9E6EF28469A04621.pdf PDF
4ADC54F2-C74F-3F02-B4900398FFBEE5A5.xlsx XLSX spreadsheet
3CA5BBE9-A618-9D6F-45A1FE1B6F58F0BF.pdf PDF
47411393-E3B2-7F55-0865EAB909BEF818.xlsx XLSX spreadsheet
1FF76D77-0146-31BD-B70AC2B9310C078F.pdf PDF
6A9BE711-E1B2-9B67-147E88484CF79F1A.pdf PDF
1FF7D8D0-C608-E689-8D121B0F5CC22DA9.pdf PDF
47413282-9830-5BA4-96685E7F9A28C371.xlsx XLSX spreadsheet
A4692B9C-E659-F33F-532C87A025A11AC2.pdf PDF
9D5C4E27-A2A7-EBA2-2714B42F829186DC.pdf PDF
3D557BC1-D80F-2E25-C9390E0BF5A59073.pdf PDF
E93EE438-A2D2-AF8E-6F5941F303D00F6A.pdf PDF
9705A9CE-B76B-3514-2AB6D46F5013FD96.pdf PDF
A46910BC-E967-DD22-10B71BADEA153824.docx DOCX document
451D7EC8-9FAF-B01F-15E5F86D68AB3D4B.xlsx XLSX spreadsheet
BCCA0BAC-C5BA-CDB6-49D2EFF559EDAF11.pdf PDF
340E518F-B0A2-92CD-5CE67BE8C5C74ADC.pdf PDF
BCDA75E7-EC2E-694E-CB30EC7B8D89F683.pdf PDF
C4A97C2F-E431-1D38-75E6D603401030C8.pdf PDF
5FEA932D-A443-F834-C369AEC7AD13A552.pdf PDF
4ADC0CC3-B76B-A18D-C62DDED0F769FB5E.xlsx XLSX spreadsheet
D1C75C4E-ACBE-A700-94A3260C246A50BF.pdf PDF
490005E7-0009-0FD7-0E92BD0F4BF1B987.xlsx XLSX spreadsheet
Show 40 more

Latest 50 of 146 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

Text version

P&I

LTD Paid & Incurred Exhibit
as of 7/31/2025
157775 - FRANKLIN COUNTY COOPERATIVE HEALTH IMPROVEMENT PRO
Experience Period *12345Claim LagTotal *
Experience Period From1/1/201/1/211/1/221/1/231/1/241/1/251/1/20
Experience Period To1/1/211/1/221/1/231/1/241/1/258/1/251/1/25
Months in period1212121212760

Average Lives 1,779 2,040 1,909 2,195 2,326 2,460 2,050

Paid Claims$306,511$628,842$112,625$242,854$226,112$0$1,516,944
Case Reserve$138,976$0$0$112,906$1,080,033$118,446$1,331,916
IBNR Reserve$0$0$0$0$15,294$263,482$15,294
Investment Credit($49,344)($55,432)($7,728)($19,244)($38,681)($4,518)($170,429)
Incurred Claims$396,143$573,410$104,897$336,516$1,282,759$377,411$2,693,725
Premium(Paid)$646,348$703,967$604,185$773,107$857,981$542,258$3,585,589
Rate0.6650.5320.5320.5320.5320.526
Premium (Adjusted)$511,391$696,223$597,539$764,603$848,543$542,258$3,418,299
Ann Adj Prm per E'ee$287$341$313$348$365$378$334

I.L.R. (Adjusted) 0.775 0.824 0.176 0.440 1.512 0.696 0.788

Open Claims100413118
Open/Closed Claims61561014151
Pending Claims0000212
Denied Claims89692034
Claim Incidence (per 1,000)3.377.353.144.566.703.335.13
Average Cost Per Claim$66,024$38,095$17,437$33,652$84,962$74,928$50,989
Average Reserve Per Claim$138,976$0$0$28,227$77,079$79,446$69,662
Monthly Indemnity$1,252$0$0$7,793$33,658$2,010$42,702
% Claims Still Open - Actual17%0%0%40%93%
* The Claim Lag period is incomplete for incidence and claim development. This period is excluded from the Total.

Claim List

LTD Claim Listing
as of 7/31/2025
157775 - FRANKLIN COUNTY COOPERATIVE HEALTH IMPROVEMENT PRO
Experience NumberReport NumberSubcodePaypointClaim NumberSocial Security StatusBirth DateAge of Claimant at Valuation DateGenderStatusDate of DisabilityMonthly Gross BenefitRegular Monthly BenefitTotal Benefit Paid To DateLBCSURVCOLACNC_CDReserve
0157775015777528000002742006040727SSP9/16/7550M031/3/20$ 1,922$ - 0$ 46,126NYN8000$ - 0Key
0157775015777596010001712007270901SSA1/1/7452F032/23/20$ 1,948$ - 0$ 17,212YYN8000$ - 0
0157775015777590000002742008141787SSP3/6/6659M033/19/20$ 2,011$ - 0$ 70,398NYN8000$ - 0Social Security Status
0157775015777593000001702011021070SSP3/21/7649F016/1/20$ 1,923$ - 0$ - 0YYN8000$ - 0CodeDescription
0157775015777596010001642009148934SSP1/28/6066M016/4/20$ 1,948$ - 0$ - 0NYN8000$ - 0SSASS benefits have been approved
0157775015777512000001612108238271SSP11/14/7055M016/9/20$ 2,480$ - 0$ - 0NYN8000$ - 0SSPSS status is pending (have not yet submitted or have submitted and not been denied twice)
0157775015777512000001652006088945SSP11/14/7055M016/9/20$ 2,378$ - 0$ - 0YYN8000$ - 0NEDClaimant is not eligible for SS or has been denied at least twice
0157775015777512000001742011091367SSP11/14/7055M036/9/20$ 2,378$ - 0$ 25,682YYN8000$ - 0
0157775015777593000001682101198088SSP10/25/6560F018/19/20$ 1,956$ - 0$ - 0YYN8000$ - 0Claim Status
0157775015777511600001642012178734NED8/9/5768M0110/2/20$ 2,267$ - 0$ 20,481YYN8000$ - 0CodeDescription
0157775015777593000001732103291096SSP4/18/9530F0110/8/20$ 2,040$ - 0$ - 0NYN8000$ - 000Active
015777501577756900000264201028851409/16/7352F0110/27/20$ 1,771$ - 0$ - 0NYN8000$ - 001Declined
0157775015777567000001702103311220NED10/18/6758F0010/29/20$ 2,366$ 1,252$ 63,837NYN8000$ 138,97602Waiting
0157775015777593000001752104260289NED3/15/6362M0311/26/20$ 2,102$ - 0$ 62,775NYN8000$ - 003Ended
0157775015777593000001742106250877NED9/22/7154F031/12/21$ 3,118$ - 0$ 12,783YYN8000$ - 004Inactive
0157775015777596000001752107201929SSP11/6/6065F031/18/21$ 1,905$ - 0$ 45,727YYN8000$ - 005Incomplete
0157775015777596000001692201248329SSP9/6/7253M032/18/21$ 5,014$ - 0$ 10,027YYN8000$ - 0PSPending
0157775015777570000001662106158256SSP6/4/7154M012/19/21$ 2,299$ - 0$ - 0YYN8000$ - 0
0157775015777593000001722108301723SSP12/26/7649F013/11/21$ 2,177$ - 0$ - 0YYN8000$ - 0
0157775015777593000001712109240822SSP4/22/7748F013/25/21$ 2,219$ - 0$ - 0NYN8000$ - 0
0157775015777593000001742109140377SSP10/16/9233F034/13/21$ 2,063$ - 0$ 31,363YYN8000$ - 0
0157775015777596000001732110011135NED6/8/7253M035/10/21$ 5,014$ - 0$ 128,364YYN8000$ - 0
0157775015777596010001742201031167SSP6/11/8639M035/21/21$ 2,841$ - 0$ 4,168NYN8000$ - 0
0157775015777593000001742111080788SSP8/7/8144F016/2/21$ 2,162$ - 0$ - 0YYN8000$ - 0
0157775015777540000001742108301747SSP9/2/6560M036/3/21$ 3,212$ - 0$ 54,810NYN8000$ - 0
0157775015777570000001672203298337NED9/2/7253F036/7/21$ 2,289$ - 0$ 96,140NYN8000$ - 0
0157775015777593000001612112038671SSP5/9/8738F037/20/21$ 2,162$ - 0$ 26,523NYN8000$ - 0
0157775015777593000001642108028964SSP5/9/8738F017/20/21$ 2,162$ - 0$ - 0YYN8000$ - 0
0157775015777593000001642107268804SSP2/16/8045F017/28/21$ 2,065$ - 0$ - 0NYN8000$ - 0
0157775015777593000001702112280910SSP1/20/6858F037/28/21$ 2,193$ - 0$ 6,580NYN8000$ - 0
0157775015777590000002642201078144SSP1/8/8838M018/12/21$ 2,100$ - 0$ - 0NYN8000$ - 0
0157775015777590000002732201121555SSP1/8/8838M018/12/21$ 2,100$ - 0$ - 0NYN8000$ - 0
0157775015777593000001742202231437SSP6/15/8936F039/10/21$ 2,237$ - 0$ 4,493YYN8000$ - 0
0157775015777570000002702204181680SSP3/12/8738F0310/23/21$ 1,744$ - 0$ 10,523YYN8000$ - 0
0157775015777596010001732203250775SSP8/21/7253M0310/23/21$ 5,014$ - 0$ 120,341YYN8000$ - 0
0157775015777596010001712205050491NED10/7/7649M0311/19/21$ 5,014$ - 0$ 60,335YYN8000$ - 0
0157775015777570000001702205170980SSP4/12/8936F0112/17/21$ 1,722$ - 0$ - 0YYN8000$ - 0
0157775015777567000001622207148032SSA4/30/5867F0312/20/21$ 1,726$ - 0$ 16,667NYN8000$ - 0
0157775015777544000002732206240135SSP7/20/6956F031/18/22$ 3,206$ - 0$ 6,520NYN8000$ - 0
0157775015777500010021712209050591NED12/25/6857F034/5/22$ 1,683$ - 0$ 5,369NYN8000$ - 0
0157775015777500010003642205098054SSP11/8/6263F014/6/22$ 1,456$ - 0$ - 0YYN8000$ - 0
0157775015777544000002672212018207SSP1/16/7056F035/27/22$ 3,032$ - 0$ 39,411NYN8000$ - 0
0157775015777570000001632208268793SSP2/13/9530M016/17/22$ 2,608$ - 0$ - 0YYN8000$ - 0
0157775015777563000002732211220026SSP2/18/5768F016/22/22$ 2,755$ - 0$ - 0YYN8000$ - 0
0157775015777544000002622306238562SSP1/19/9531F018/8/22$ 2,725$ - 0$ - 0NYN8000$ - 0
0157775015777544000002742304171567SSP2/17/9134M019/29/22$ 2,477$ - 0$ - 0NYN8000$ - 0
0157775015777511100002722303020014SSP4/15/7154F039/30/22$ 3,296$ - 0$ 3,186YYN8000$ - 0
0157775015777593000001752303270839SSA10/4/5669F0310/21/22$ 2,471$ - 0$ 41,423YYN8000$ - 0
0157775015777593000001742304111378NED4/22/7748F0311/9/22$ 2,786$ - 0$ 16,717YYN8000$ - 0
0157775015777570000001602212078270SSP4/14/9827F0112/7/22$ 2,298$ - 0$ - 0NYN8000$ - 0
0157775015777513000001602306078150SSP6/17/6659F032/17/23$ 3,161$ - 0$ 3,161NYN8000$ - 0
0157775015777513000001712307201042SSP6/17/6659F012/17/23$ 3,161$ - 0$ - 0NYN8000$ - 0
0157775015777512000002722307311464SSP10/10/6659M032/28/23$ 3,782$ - 0$ 28,116NYN8000$ - 0
0157775015777596010001662309138166SSP2/11/6857M013/27/23$ 5,446$ - 0$ - 0YYN8000$ - 0
0157775015777511000002752309181759NED6/19/5867F004/4/23$ 2,084$ 2,084$ 43,837NYN8000$ 18,757
0157775015777511400001682312138858NED4/24/5966F004/17/23$ 3,669$ 1,595$ 30,431NYN8000$ 23,930
0157775015777511400001732404031935SSP4/24/5966F014/18/23$ 3,669$ - 0$ - 0NYN8000$ - 0
0157775015777593000001752309220009SSP11/13/6461F014/22/23$ 2,216$ - 0$ - 0YYN8000$ - 0
0157775015777569000002702311130480SSP4/23/6362F016/12/23$ 2,007$ - 0$ - 0NYN8000$ - 0
0157775015777512000001722311271053SSP3/1/6065M006/26/23$ 2,521$ 2,108$ 39,251NYN8000$ 13,274
0157775015777593000001722311281104SSP2/3/6461F016/28/23$ 2,918$ - 0$ - 0YYN8000$ - 0
0157775015777570000001622307058862SSP6/4/7154M016/29/23$ 2,772$ - 0$ - 0NYN8000$ - 0
0157775015777570000002622307278542SSP12/9/7748F017/18/23$ 2,590$ - 0$ - 0YYN8000$ - 0
0157775015777593000002752312190049SSP2/15/7451F037/19/23$ 3,158$ - 0$ 6,738YYN8000$ - 0
0157775015777593000002742401010518NED9/19/7253F037/27/23$ 2,086$ - 0$ 1,182NYN8000$ - 0
0157775015777565000002742402021928NED7/5/6362F009/6/23$ 3,139$ 2,005$ 33,674YYN8000$ 56,945
0157775015777599970001752404260759SSP5/14/6263F0310/30/23$ 2,139$ - 0$ 1,070NYN8000$ - 0
0157775015777565000001722404230614SSP3/17/6362F0111/22/23$ 1,991$ - 0$ - 0YYN8000$ - 0
0157775015777568000002742405101268NED1/15/6264M0312/9/23$ 4,873$ - 0$ 55,395NYN8000$ - 0
0157775015777593000001662408148686SSP8/30/9134F001/19/24$ 2,424$ 2,424$ 29,091YYN8000$ 32,225
0157775015777593000001732406261016NED3/12/6164F002/23/24$ 2,757$ 2,757$ 27,570YYN8000$ 88,225
0157775015777593000002702405271850NED6/1/5768F003/15/24$ 2,984$ 2,984$ 29,838NYN8000$ 32,821
0157775015777567000001752411010049SSA2/7/8144F003/20/24$ 2,398$ 100$ 19,286NYN8000$ 16,450
0157775015777528000001682406188188SSP8/21/5966F034/17/24$ 2,762$ - 0$ 16,666NYN8000$ - 0
0157775015777593000001732411110395NED12/3/7253F005/10/24$ 2,937$ 2,937$ 23,496YYN8000$ 126,778
0157775015777540000001722412111884SSP10/2/8441M006/14/24$ 3,007$ 3,007$ 21,046NYN8000$ 145,528
0157775015777593000002712411140791SSP3/11/5867M016/14/24$ 3,083$ - 0$ - 0YYN8000$ - 0
0157775015777593000002712411150842SSP6/10/6362F006/15/24$ 3,306$ 3,306$ 23,143NYN8000$ 97,360
0157775015777590000002642409068314SSP8/7/5768F016/28/24$ 3,703$ - 0$ - 0YYN8000$ - 0
0157775015777569000002722412160054SSA3/4/7748F007/15/24$ 2,129$ 2,129$ 12,776YYN8000$ 68,258
0157775015777532000002742504170447SSP1/8/6462F029/16/24$ 2,524$ 2,524$ 5,627NYN8000$ 44,540
0157775015777593000001722503171284SSP11/12/7748F0010/16/24$ 2,372$ 2,372$ 7,196NYN8000$ 84,656
0157775015777599970001702503241570NED1/23/6363M0010/22/24$ 3,554$ 3,554$ 7,107NYN8000$ 191,899
0157775015777512500002732505010976SSP3/29/6560M0011/24/24$ 3,270$ 3,270$ 3,270YYN8000$ 52,929
0157775015777593000001612506068131SSP2/22/6065FPS12/6/24$ 2,415$ - 0$ - 0NYN8000$ 39,000
0157775015777570000001722505061123SSP5/16/9827FPS12/9/24$ 2,322$ - 0$ - 0YYN8000$ 39,000
0157775015777512000001722505281843SSP11/3/6560M0012/28/24$ 2,293$ 2,293$ - 0NYN8000$ 20,365
0157775015777588000002732506120345SSP6/7/7451F001/10/25$ 2,010$ 2,010$ - 0NYN8000$ 79,446
0157775015777593000002732506050125SSP9/2/7649F001/17/25$ 3,954$ - 0$ - 0YYN8000$ 39,000

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