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

XLSX spreadsheet 27 KB Posted

Attached to
Franklin County EOC Technology Upgrade
Solicitation number
RFP 2026-62-10
Issued by
Franklin County, Ohio

About this file

This is a Paid & Incurred (P&I) Limited Exhibit for the Franklin County Cooperative Health Improvement Program, showing long-term disability (LTD) claims experience as of July 31, 2025. The document provides actuarial analysis covering a 60-month experience period from January 1, 2020, through August 1, 2025, with a separate incomplete claim lag period. The exhibit tracks key metrics including average lives covered (ranging from 1,779 to 2,460 employees across experience periods), paid claims totaling $1,516,944, case reserves of $1,331,916, and incurred claims of $2,693,725. The program reports an overall incurred loss ratio (adjusted) of 0.788, indicating claims costs of approximately 78.8 cents per premium dollar. Monthly indemnity payments total $42,702 with 18 open claims out of 51 total open or closed claims. The average cost per claim is $50,989, with claim incidence rates of 5.13 per 1,000 employees.

The accompanying claim listing details 79 individual LTD claimants as of July 31, 2025, with monthly gross benefits ranging from $1,456 to $5,446. Claimant ages span from 27 to 69 years old, with dates of disability ranging from January 3, 2020, through January 17, 2025. Social Security coordination status indicates that most claimants have approved Social Security benefits (SSA status), pending Social Security applications (SSP status), or are deemed ineligible or have been denied Social Security twice (NED status). Total benefits paid to date across all claimants amount to $2,693,725, with active claims carrying reserves of $1,331,916. The majority of claims show ended status (code 03) or active status (code 00), with two claims pending (PS status) as of the valuation date. Premium paid totals $3,585,589 with adjusted premiums of $3,418,299 across the experience period.

View the file

Other files

File Type Posted
6E289AB6-A1A3-D139-AC198FD956FD1A77.pdf PDF
52DB9448-0DA4-58EC-7CC559390BFA917E.pdf PDF
8BE999EA-C1F3-6CAA-1ED2B57E621612FB.pdf PDF
9705A9CE-B76B-3514-2AB6D46F5013FD96.pdf PDF
2D575AB7-B92A-4C61-DE1B68E18F3B1809.pdf PDF
6D302278-A5F3-8508-AEC851283D91EF01.pdf PDF
CCC737E4-C815-7DA9-BAFDD4D8BCA83EAE.pdf PDF
39A8A9E3-F569-C6B6-B9E7BF50CFDC4F51.pdf PDF
8BD45E27-AD3D-2A81-9DC34421F6415618.pdf PDF
8CFF3838-EA7E-33CD-42D86D9937F5AFDB.pdf PDF
8BE169B1-0EA5-67F3-FE8D32CD74B2BC3C.pdf PDF
96EE5830-0F4F-104B-FF1246192320CF51.pdf PDF
FAFB33F1-A49E-7354-6799AC07E5D29DA0.pdf PDF
1DCD1842-B247-5772-E27F53DB3DE27613.pdf PDF
379F0AFD-BC67-5833-47CED9B9F8A77644.pdf PDF
4ADC244E-B24C-BEC2-4654E43F7ACFB8A4.xlsx XLSX spreadsheet
4491B391-0B2C-57F1-169E865F334A5FAD.xlsx XLSX spreadsheet
98B00E89-F3C2-2215-1B6B7A585EA6B903.pdf PDF
1FF7D8D0-C608-E689-8D121B0F5CC22DA9.pdf PDF
471F2B18-FADB-16E3-6A13A124C82D15B3.pdf PDF
47411393-E3B2-7F55-0865EAB909BEF818.xlsx XLSX spreadsheet
1FF834AF-CB60-B607-A9DD3103FF766EDA.pdf PDF
44F2C847-DCDE-D822-A4337D82DBDE228F.xlsx XLSX spreadsheet
BEA8D216-B719-D18D-2A1EF07B83D22C78.xlsx XLSX spreadsheet
E9905CF7-C973-40FC-678D5FD85143E735.pdf PDF
48FFC2CD-AEC5-7A21-3B4F6E3270F0429B.pdf PDF
DE522D80-FE3B-40B1-1C32D6110AF0CD6F.pdf PDF
BEA8B132-08B9-5848-83E1018BFD8D09C5.xlsx XLSX spreadsheet
F13E338C-C030-4C55-2FE32EE64813CA9E.docx DOCX document
56D200B6-A79A-5846-53B374D48289713F.xlsx XLSX spreadsheet
4ADBDA30-A10A-65AC-2585EBF3396EC49F.pdf PDF
3D557BC1-D80F-2E25-C9390E0BF5A59073.pdf PDF
98C3F6F7-A2E4-2584-EE8EB79AF1AA8052.xlsx XLSX spreadsheet
E13134B7-AC80-2A6B-17903505A1365FE4.pdf PDF
1FF70774-E56E-EAC8-88A7694DAF5EB82C.pdf PDF
4764BD72-A4C9-CB3B-C1392F63B1D7AA28.pdf PDF
455CC78D-B78A-EC66-F7D6D71B8AF36042.pdf PDF
47649CE8-A0E3-2433-AC9846884D7DA4C4.pdf PDF
E99082A3-014B-96AB-48063D8559F32599.pdf PDF
56D1E25C-D6F7-A070-782594700401C348.docx DOCX document
340E518F-B0A2-92CD-5CE67BE8C5C74ADC.pdf PDF
48FFA356-A619-FDBE-4B4D833D8E7B2589.pdf PDF
D1C75C4E-ACBE-A700-94A3260C246A50BF.pdf PDF
48FFE6B8-C249-DC8C-BA6A621BAD5FF49F.xlsx XLSX spreadsheet
441CA1BC-A59E-E520-9F472E421C5515A7.pdf PDF
4ADBBFB5-F75A-53E0-AE23AAE483992AC8.pdf PDF
4540076D-DA44-888C-413CAB868FEC6141.xlsx XLSX spreadsheet
8F33C1D9-B606-E1D0-F77CFF24E442EF1B.pdf PDF
1FF7B35A-B067-E38B-5984FBC2B840ECE1.pdf PDF
3CA5BBE9-A618-9D6F-45A1FE1B6F58F0BF.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 .