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

XLSX spreadsheet 27 KB Posted

Attached to
Site Security Cameras, LiDAR & Management System
Solicitation number
2025-62-21
Issued by
Franklin County, Ohio

About this file

This is a Paid & Incurred (P&I) Limited Liability Exhibit for Franklin County Cooperative Health Improvement Program (Plan ID: 157775), documenting long-term disability (LTD) claims experience and financial performance as of July 31, 2025. The exhibit covers a five-year experience period from January 1, 2020, through August 1, 2025, tracking claims activity for an average of 2,050 covered lives across the cooperative membership. The summary metrics reveal a total of 51 open and closed claims with 18 currently open claims, 34 denied claims, and 2 pending claims. Over the entire experience period, the program paid $1,516,944 in claims against $3,585,589 in paid premiums, with incurred claims totaling $2,693,725 when accounting for case reserves, incurred but not reported (IBNR) reserves, and investment credits. The incurred loss ratio (adjusted) across all periods averaged 0.788, indicating claims costs of approximately 79 cents per premium dollar received.

The detailed claim listing identifies 87 individual LTD claimants with specific disability dates, monthly gross benefits ranging from approximately $1,456 to $5,446, and various social security benefit coordination statuses. The majority of claimants have Social Security pending (SSP) status, with a significant portion already receiving Social Security benefits (SSA) or deemed ineligible for Social Security (NED). Claims span multiple years with active monthly indemnity payments totaling $42,702 during the current period, and substantial case reserves of $1,331,916 accumulated across open claims. Premium rates have remained consistent at 0.532 for most of the experience period, with adjusted annual premiums per employee averaging $334. The program demonstrates historical claims incidence of 5.13 per 1,000 covered lives with an average cost per claim of $50,989, reflecting the cooperative's disability risk profile and management of long-term disability benefits.

View the file

Other files

File Type Posted
B130D82C-B69F-E211-5C113B664A13BDA1.pdf PDF
4ADB9154-92D0-FA39-8C51818579A9E699.pdf PDF
E99102BF-B146-146D-35DFAF9763C1170B.pdf PDF
5FEA932D-A443-F834-C369AEC7AD13A552.pdf PDF
D1C75C4E-ACBE-A700-94A3260C246A50BF.pdf PDF
1FF7D8D0-C608-E689-8D121B0F5CC22DA9.pdf PDF
9D5C4E27-A2A7-EBA2-2714B42F829186DC.pdf PDF
4ADBF0DE-FA15-F6CB-0B2B1FFF2D166DEF.pdf PDF
B867E43E-FCA2-ABC6-686473D3D551080B.docx DOCX document
600B382B-92C2-EE01-36E3171A1CE23381.pdf PDF
4ADC6B3E-009D-638E-F9834A3736C61F00.xlsx XLSX spreadsheet
4ADBDA30-A10A-65AC-2585EBF3396EC49F.pdf PDF
FAFB33F1-A49E-7354-6799AC07E5D29DA0.pdf PDF
48C544C3-FCC4-F4ED-99FB5E91E5744B30.pdf PDF
44F2E64B-E391-5EAC-DD33927813E7BE98.xlsx XLSX spreadsheet
F388F0B8-095B-81FD-4AB0A90CB30AE31F.pdf PDF
98C3F6F7-A2E4-2584-EE8EB79AF1AA8052.xlsx XLSX spreadsheet
260F9701-94BA-EFEA-FCAED968AC730EE0.docx DOCX document
ED338BF8-FCF8-7E6B-4327CDB3236D9A0A.pdf PDF
A3F924CA-A2E1-A38A-2E6F296BD4EAE5D4.pdf PDF
47647B12-EF69-CBAE-3877E615229CE346.pdf PDF
44F2A935-093F-1234-3F0F06EFB73CE154.xlsx XLSX spreadsheet
45745F40-E0BA-1577-1AE1A9CC2179CA13.pdf PDF
455CC78D-B78A-EC66-F7D6D71B8AF36042.pdf PDF
47A09361-9A16-2F9F-03970F0DC73EAB8D.pdf PDF
1FF6D412-D5CF-E3DA-42373990EB63A4DE.docx DOCX document
E9905CF7-C973-40FC-678D5FD85143E735.pdf PDF
477EEBB5-9B64-4073-39F4D92B43E61BB0.pdf PDF
47ADF7AD-983F-9719-2E5C720D20F03E5A.xlsx XLSX spreadsheet
BCDA75E7-EC2E-694E-CB30EC7B8D89F683.pdf PDF
8BE169B1-0EA5-67F3-FE8D32CD74B2BC3C.pdf PDF
D19B3093-A699-8107-EE175100DAB2A969.pdf PDF
4ADC244E-B24C-BEC2-4654E43F7ACFB8A4.xlsx XLSX spreadsheet
1FF79148-03D3-7B1B-77CF64FD687ECA4C.pdf PDF
A4692B9C-E659-F33F-532C87A025A11AC2.pdf PDF
9EDCD8B0-B36E-8610-B9A1060DE4F7BDD1.pdf PDF
E920A267-FB29-7597-A525F8234B855C09.pdf PDF
52DB9448-0DA4-58EC-7CC559390BFA917E.pdf PDF
451DAC14-D169-2A9F-1266443CD504A357.xlsx XLSX spreadsheet
36771012-968A-47BA-49FB1CC4DFFFEC63.pdf PDF
48C71F36-F14E-8501-2A85945F358C6068.xlsx XLSX spreadsheet
600AF88E-C800-4399-20BE9FDE4A50714B.docx DOCX document
3CA5BBE9-A618-9D6F-45A1FE1B6F58F0BF.pdf PDF
48FFA356-A619-FDBE-4B4D833D8E7B2589.pdf PDF
8BE999EA-C1F3-6CAA-1ED2B57E621612FB.pdf PDF
8CFF3838-EA7E-33CD-42D86D9937F5AFDB.pdf PDF
1FF7B35A-B067-E38B-5984FBC2B840ECE1.pdf PDF
8B0111A9-AB26-EF6C-1377B5BEC77C1480.pdf PDF
39A8A9E3-F569-C6B6-B9E7BF50CFDC4F51.pdf PDF
47A070EA-AA3B-485A-6C240303241C99D2.pdf PDF
Show 40 more

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