About this file

Claims History Summary

This file is a claims history spreadsheet detailing the State of Tennessee's self-insured supplemental medical insurance plan (The Tennessee Plan) administered through the Department of Finance and Administration's Division of Benefits Administration. The spreadsheet provides month-by-month claims data, enrollment figures, and cost metrics spanning from January 2018 through December 2024, with partial data available for the first and second quarters of 2025. The document tracks total paid amounts, number of claims processed, paid per claim amounts, enrollment levels, and paid per enrolled member figures across a seven-year period, establishing baseline performance metrics and cost trends critical to evaluating administrative services for the upcoming third-party administrator contract.

The claims history demonstrates consistent growth in plan costs and utilization over the six-year period from 2018 to 2024, with total annual paid amounts increasing from $63.0 million in 2018 to $89.0 million in 2024, representing a 41% cumulative increase. Annual plan costs have grown by an average of 4% year-over-year, while claims volume increased an average of 4.24% annually and enrollment grew at an average of 2.20% per year. The cost per claim increased an average of 2.45% annually, reaching approximately $59.05 in 2024. Enrollment levels grew from 41,809 members in 2018 to 47,727 members in 2024, with growth continuing into 2025 to approximately 48,011 members by December 2024. This historical data serves as the foundation for projecting future claims volumes, administrative costs, and performance expectations for the incoming third-party administrator effective January 1, 2027.

View the file

Other files

File Type Posted
31786-00187_TN_Plan_Release_3.pdf PDF
RFP_31786-00187_Amendment_Three.pdf PDF
31786-00187_TN_Plan_Release_4.pdf PDF
RFP_31786-00187_Appendix_7_7_Member_Demographics.xlsx XLSX spreadsheet
Appendix_7.4_HIPAA_Business_Associate_Assessment.xlsx XLSX spreadsheet
RFP_31786-00187_Amendment_5.pdf PDF
Appendix_7.5_Claims_History.xlsx XLSX spreadsheet
31786-00187_TN_Plan_for_posting.pdf PDF
Appendix_7.1_Plan_Document_for_The_Tennessee_Plan.pdf PDF
RFP_31786-00187_Amendment_Four.pdf PDF
RFP_31786-00187_Amendment_Two.pdf PDF
31786-00187_TN_Plan_Release_2.pdf PDF
RFP_31786-00187_Amendment_One_Schedule_Update.pdf PDF
Appendix_7.3_Benefits_Administration_834_Guidance_Manual_v5.pdf PDF
31786-00187_Digital_Submission_Instructions.pdf PDF
Appendix_7.2_Enrollment_History.xlsx XLSX spreadsheet
RFP_31786-00187_Draft_The_TN_Plan_Attachment_6.3_Cost_Proposal.xlsx XLSX spreadsheet
Appendix_7.6_Written_Q_and_C_template.pdf PDF
31786-00187_TN_Plan_Release_5.pdf PDF
Appendix_7.6_Written_Q_and_C_template.pdf PDF
31786-00187_TN_Plan_Release_2.pdf PDF
RFP_31786-00187_Amendment_Two.pdf PDF
31786-00187_Digital_Submission_Instructions.pdf PDF
31786-00187_TN_Plan_for_posting.pdf PDF
RFP_31786-00187_Appendix_7_7_Member_Demographics.xlsx XLSX spreadsheet
31786-00187_TN_Plan_Release_4.pdf PDF
Appendix_7.1_Plan_Document_for_The_Tennessee_Plan.pdf PDF
Appendix_7.3_Benefits_Administration_834_Guidance_Manual_v5.pdf PDF
RFP_31786-00187_Draft_The_TN_Plan_Attachment_6.3_Cost_Proposal.xlsx XLSX spreadsheet
Appendix_7.4_HIPAA_Business_Associate_Assessment.xlsx XLSX spreadsheet
Appendix_7.2_Enrollment_History.xlsx XLSX spreadsheet
RFP_31786-00187_Amendment_One_Schedule_Update.pdf PDF
RFP_31786-00187_Amendment_Three.pdf PDF
31786-00187_TN_Plan_Release_3.pdf PDF
RFP_31786-00187_Amendment_Four.pdf PDF
RFP_31786-00187_Amendment_Two.pdf PDF
31786-00187_TN_Plan_Release_2.pdf PDF
Appendix_7.1_Plan_Document_for_The_Tennessee_Plan.pdf PDF
Appendix_7.5_Claims_History.xlsx XLSX spreadsheet
Appendix_7.3_Benefits_Administration_834_Guidance_Manual_v5.pdf PDF
31786-00187_Digital_Submission_Instructions.pdf PDF
31786-00187_TN_Plan_for_posting.pdf PDF
RFP_31786-00187_Amendment_Three.pdf PDF
Appendix_7.4_HIPAA_Business_Associate_Assessment.xlsx XLSX spreadsheet
RFP_31786-00187_Appendix_7_7_Member_Demographics.xlsx XLSX spreadsheet
Appendix_7.6_Written_Q_and_C_template.pdf PDF
Appendix_7.2_Enrollment_History.xlsx XLSX spreadsheet
RFP_31786-00187_Draft_The_TN_Plan_Attachment_6.3_Cost_Proposal.xlsx XLSX spreadsheet
RFP_31786-00187_Amendment_One_Schedule_Update.pdf PDF
31786-00187_TN_Plan_Release_3.pdf PDF
Show 40 more

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

Year by Month Details

State of Tennessee
Services, Claims and Paid Amounts
2018, 2019, 2020, 2021, 2022, 2023, 2024 Comparison

Month/Year Total Paid # of Claims Paid Per Claim Enrollment Paid Per Enrolled

2018
18-Jan$4,339,200.7786,872$49.9541,224$105.26
18-Feb$3,839,617.2789,127$43.0841,215$93.16
18-Mar$5,839,319.24114,245$51.1141,387$141.09
18-Apr$4,752,364.8593,361$50.9041,486$114.55
18-May$5,840,765.57112,404$51.9641,588$140.44
18-Jun$3,297,469.2956,280$58.5939,969$82.50
18-Jul$5,538,336.02150,854$36.7141,886$132.22
18-Aug$7,711,434.27137,390$56.1342,111$183.12
18-Sep$4,951,538.4893,633$52.8842,397$116.79
18-Oct$6,415,822.34120,860$53.0842,711$150.21
18-Nov$5,508,044.5797,239$56.6442,783$128.74
18-Dec$5,001,725.9790,938$55.0042,945$116.47
2018 YTD$63,035,638.641,243,203$51.3441,809$125.38
2019
19-Jan$5,890,484.42119,624$49.2443,014$136.94
19-Feb$4,810,399.4098,885$48.6543,052$111.73
19-Mar$5,441,555.6899,435$54.7243,211$125.93
19-Apr$4,922,194.7696,604$50.9543,282$113.72
19-May$6,547,025.81123,487$53.0243,335$151.08
19-Jun$5,562,492.18100,404$55.4043,410$128.14
19-Jul$6,802,336.88122,608$55.4843,521$156.30
19-Aug$5,185,998.9599,005$52.3843,698$118.68
19-Sep$5,351,011.0799,106$53.9943,927$121.82
19-Oct$6,160,874.76124,624$49.4444,165$139.50
19-Nov$5,404,197.55103,028$52.4544,233$122.18
19-Dec$5,084,633.2293,673$54.2844,341$114.67
2019 YTD$67,163,204.681,280,483$52.5043,599$128.39
Change from 2018 to 20196%2.91%2.21%4.11%2.34%
2020
20-Jan$6,462,054.00122,476$52.7644,396$145.55
20-Feb$4,644,007.00103,534$44.8544,417$104.55
20-Mar$5,057,388.00101,014$50.0744,534$113.56
20-Apr$6,339,173.00104,018$60.9444,536$142.34
20-May$3,846,051.0063,635$60.4444,595$86.24
20-Jun$4,461,930.0083,195$53.6344,656$99.92
20-Jul$5,823,972.65112139$51.9444,781$130.05
20-Aug$5,195,157.1391938$56.5144,963$115.54
20-Sep$6,730,135.37118552$56.7745,182$148.96
20-Oct$5,099,309.3992,038$55.4045,359$112.42
20-Nov$5,263,468.7896,659$54.4545,461$115.78
20-Dec$6,903,595.73118,512$54.4545,523$151.65
2020 YTD$65,826,242.051,207,710$54.3544,867$122.21
Change from 2019 to 2020-8%1.56%-9.30%2.97%-10.89%
2021
21-Jan$4,480,178.3084,107$53.2745,403$98.68
21-Feb$4,862,188.0693,793$51.8445,410$107.07
21-Mar$6,770,873.26117,108$57.8245,464$148.93
21-Apr$4,763,953.6686,907$54.8245,486$104.73
21-May$6,678,801.72111,119$60.1045,556$146.61
21-Jun$7,223,531.39121,811$59.3045,628$158.31
21-Jul$5,476,286.3394,426$58.0045,772$119.64
21-Aug$4,989,833.5294,621$52.7345,935$108.63
21-Sep$6,983,111.48128,096$54.5146,143$151.34
21-Oct$5,602,796.6099,719$56.1946,328$120.94
21-Nov$5,740,677.6499,513$57.6946,380$123.77
21-Dec$6,868,104.75123,761$55.4946,471$147.79
2021 YTD$70,440,336.711,254,981$55.9845,831$128.04
Change from 2020 to 20216.55%3.77%2.91%2.10%4.55%
2022
22-Jan$5,333,185.6596,238$55.4246,391$114.96
22-Feb$6,074,783.80108,852$55.8146,375$130.99
22-Mar$7,496,402.28137,455$54.5446,413$161.52
22-Apr$5,707,866.74104,916$54.4046,425$122.95
22-May$6,263,157.10108,210$57.8846,495$134.71
22-Jun$7,595,603.84126,248$60.1646,499$163.35
22-Jul$5,977,281.2494,715$63.1146,687$128.03
22-Aug$7,533,831.99134,593$55.9746,894$160.66
22-Sep$6,265,642.48105,199$59.5647,095$133.04
22-Oct$6,619,919.07114,263$57.9447,290$139.99
22-Nov$7,818,324.59134,165$58.2747,313$165.25
22-Dec$5,417,115.3494,940$57.0647,322$114.47
2022 YTD$78,103,114.121,359,794$57.5146,767$139.16
Change from 2021 to 20229.81%7.71%2.66%2.00%7.99%
2023
Jan-23$5,726,086.4292,988$61.5847,280$121.11
Feb-23$6,451,548.47123,358$52.3047,277$136.46
Mar-23$7,951,687.54134,099$59.3047,282$168.18
Apr-23$6,659,540.96114,234$58.3047,298$140.80
May-23$8,543,236.99151,279$56.4747,355$180.41
Jun-23$6,628,081.70107,737$61.5247,319$140.07
Jul-23$7,040,176.27111,060$63.3947,408$148.50
Aug-23$7,907,923.36137,700$57.4347,408$166.81
Sep-23$7,091,983.53118,476$59.8647,612$148.95
Oct-23$6,392,454.43109,637$58.3147,700$134.01
Nov-23$9,170,154.91149,575$61.3147,745$192.07
Dec-23$6,982,967.04123,531$56.5347,773$146.17
2023 YTD$86,545,841.621,473,674$58.8647,455$151.96
Change from 2022 to 20239.76%7.73%2.29%1.45%8.42%
2024
Jan-24$7,917,592.20130,505$60.6747,626$166.25
Feb-24$3,497,309.8366,359$52.7047,590$73.49
Mar-24$6,167,659.73115,609$53.3547,595$129.59
Apr-24$7,251,054.60125,845$57.6247,602$152.33
May-24$10,443,418.29158,544$65.8747,581$219.49
Jun-24$6,962,074.26114,380$60.8747,576$146.34
Jul-24$8,935,608.72143,450$62.2947,648$187.53
Aug-24$7,981,193.12121,862$65.4947,691$167.35
Sep-24$7,208,698.89121,887$59.1447,856$150.63
Oct-24$8,471,289.17142,093$59.6247,959$176.64
Nov-24$7,102,966.10115,571$61.4647,986$148.02
Dec-24$7,107,259.93143,689$49.4648,011$148.03
2024 YTD$89,046,124.841,499,794$59.0547,727$155.47
Change from 2023 to 20242.81%1.74%0.32%0.57%2.26%

Year over Year Totals

State of Tennessee 6 Year Comparisonn
YearPlan Cost IncreaseClaim IncreaseEnrollment IncreaseCost Per Claim Increase
2018 to 20196%2.91%4.11%2.34%
2019 to 2020-8%1.56%2.97%-10.89%
2020 to 20216.55%3.77%2.10%4.55%
2021 to 20229.81%7.71%2%7.99%
2022 to 20239.76%7.73%1.45%8.42%
2023 to 20242.81%1.74%0.57%2.26%

Average 4% 4.24% 2.20% 2.45%

2025 - Thru Q2 image1.jpeg image2.png

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