Appendix_7.5_Claims_History.xlsx

XLSX spreadsheet 165 KB Posted

Attached to
Administrative Services Only to Perform as Third-Party Administrator for the State's The Tennessee Plan (a self-insured supplemental medical insurance plan for retirees with Medicare) - UPDATED
Solicitation number
RFP 31786-00187
Issued by
Davidson County, Tennessee

About this file

Written by GovTribe AI ·

This Excel spreadsheet contains a comprehensive claims history and financial analysis for the State of Tennessee, detailing monthly healthcare services claims data from 2018 through 2024. The document provides a granular breakdown of total paid amounts, number of claims, cost per claim, enrollment figures, and year-over-year comparative metrics across six consecutive years.

The data reveals consistent growth trends in healthcare claims and costs, with an average annual increase of 4% in plan costs, 4.24% in claims volume, 2.20% in enrollment, and 2.45% in cost per claim. Notable observations include significant increases in total paid amounts, with peaks in 2022 and 2023, where annual costs rose by approximately 9.76-9.81%. The enrollment base has steadily grown from 41,224 in January 2018 to 48,011 in December 2024, representing a measured expansion of approximately 16.5% over the six-year period. The per-claim costs have fluctuated, with the highest monthly per-claim amount reaching $65.87 in May 2024 and the lowest at $36.71 in July 2018.

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
Appendix_7.5_Claims_History.xlsx XLSX spreadsheet
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
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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

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 .