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

XLSX spreadsheet 27 KB Posted

Attached to
Mediation Services
Solicitation number
2026-46-06
Issued by
Franklin County, Ohio

View the file

Other files

File Type Posted
44A3FAEC-97F9-FAD6-B54F90D5CEDD52DA.xlsx XLSX spreadsheet
4ADC244E-B24C-BEC2-4654E43F7ACFB8A4.xlsx XLSX spreadsheet
8B00ECA9-D368-AD09-80DA20EDC1915543.pdf PDF
E99082A3-014B-96AB-48063D8559F32599.pdf PDF
C0135AC1-FF9D-F3AC-BDB7FB4697056E65.pdf PDF
39A8A9E3-F569-C6B6-B9E7BF50CFDC4F51.pdf PDF
44F2A935-093F-1234-3F0F06EFB73CE154.xlsx XLSX spreadsheet
58DCD716-9EAC-9E14-6719EE5FDA607EE3.pdf PDF
1FF81613-C943-E907-903208614AFFB273.pdf PDF
471F2B18-FADB-16E3-6A13A124C82D15B3.pdf PDF
455CA489-AF8F-CF71-6FFA3A68482AEF22.pdf PDF
76154B86-0D35-C013-E46368EB2B8F2266.pdf PDF
36771012-968A-47BA-49FB1CC4DFFFEC63.pdf PDF
B867E43E-FCA2-ABC6-686473D3D551080B.docx DOCX document
8BE169B1-0EA5-67F3-FE8D32CD74B2BC3C.pdf PDF
451D7EC8-9FAF-B01F-15E5F86D68AB3D4B.xlsx XLSX spreadsheet
48C544C3-FCC4-F4ED-99FB5E91E5744B30.pdf PDF
F13E338C-C030-4C55-2FE32EE64813CA9E.docx DOCX document
9188FC82-07E6-2A24-E7927A56369C067A.pdf PDF
600AF88E-C800-4399-20BE9FDE4A50714B.docx DOCX document
FAFB33F1-A49E-7354-6799AC07E5D29DA0.pdf PDF
47ADF7AD-983F-9719-2E5C720D20F03E5A.xlsx XLSX spreadsheet
8BD45E27-AD3D-2A81-9DC34421F6415618.pdf PDF
8CFF3838-EA7E-33CD-42D86D9937F5AFDB.pdf PDF
48C71F36-F14E-8501-2A85945F358C6068.xlsx XLSX spreadsheet
441CA1BC-A59E-E520-9F472E421C5515A7.pdf PDF
CCC737E4-C815-7DA9-BAFDD4D8BCA83EAE.pdf PDF
BEA8591A-F056-8D68-013C92A00C2DA843.pdf PDF
1FF79148-03D3-7B1B-77CF64FD687ECA4C.pdf PDF
4764BD72-A4C9-CB3B-C1392F63B1D7AA28.pdf PDF
BCCA0BAC-C5BA-CDB6-49D2EFF559EDAF11.pdf PDF
451DAC14-D169-2A9F-1266443CD504A357.xlsx XLSX spreadsheet
9AEA49E5-D258-E830-CAAB03DD9BBE7883.pdf PDF
D1C75C4E-ACBE-A700-94A3260C246A50BF.pdf PDF
9CF27992-010C-8CAD-3D1BE0F71396D62B.pdf PDF
600ACEFD-D8A4-EF86-6746123A35214FBD.pdf PDF
D465A6BC-B38E-009F-4BA8EFA38CE55315.pdf PDF
E99102BF-B146-146D-35DFAF9763C1170B.pdf PDF
455CC78D-B78A-EC66-F7D6D71B8AF36042.pdf PDF
6D302278-A5F3-8508-AEC851283D91EF01.pdf PDF
5FEA932D-A443-F834-C369AEC7AD13A552.pdf PDF
8BE999EA-C1F3-6CAA-1ED2B57E621612FB.pdf PDF
4540076D-DA44-888C-413CAB868FEC6141.xlsx XLSX spreadsheet
477EEBB5-9B64-4073-39F4D92B43E61BB0.pdf PDF
47647B12-EF69-CBAE-3877E615229CE346.pdf PDF
379F0AFD-BC67-5833-47CED9B9F8A77644.pdf PDF
8F33C1D9-B606-E1D0-F77CFF24E442EF1B.pdf PDF
4491B391-0B2C-57F1-169E865F334A5FAD.xlsx XLSX spreadsheet
4703BAFF-A637-A4BC-D31224A6D85981B6.pdf PDF
A46910BC-E967-DD22-10B71BADEA153824.docx DOCX document
Show 40 more

Latest 50 of 147 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 .