Appendix_7.10_%20RFP_31786-00186%20FICA%20Tax%20Amounts%20Paid.xlsx

XLSX spreadsheet 9 KB Posted

Attached to
Short-Term Disability And Long-Term Disability Insurance - UPDATED
Solicitation number
RFP 31786-00186
Issued by
Davidson County, Tennessee

About this file

This appendix document provides historical FICA tax payment data associated with RFP 31786-00186 for the State of Tennessee's disability insurance procurement. The spreadsheet tracks quarterly FICA tax amounts paid before service fees across a five-quarter period from Q2 2024 through Q1 2025, followed by Q2 2025 data. The number of claims processed during each quarter ranges from 3 claims in Q2 2024 to 16 claims in Q4 2024, with FICA taxes paid varying from $1,539.83 to $4,857.62 per quarter. This historical claims and tax payment information appears to reflect the performance metrics of the incumbent vendor, Metropolitan Life Insurance Company, providing baseline data for evaluating contractor performance and cost projections under the current disability insurance administration contract.

The data demonstrates the scale and financial impact of disability claims processing operations under the existing program, with cumulative FICA taxes of approximately $18,035.24 paid across the five reporting quarters. The quarterly variation in both claim volume and FICA tax amounts reflects fluctuating benefit utilization patterns among covered employees. This financial snapshot serves as a critical reference point for prospective bidders to understand current operational demands and for the State of Tennessee to establish performance benchmarks and cost expectations for the successor contractor beginning January 1, 2027.

View the file

Other files

File Type Posted
Appendix_7.15_RFP%2031786-00186_MetLife%20September%202025.xlsx XLSX spreadsheet
Appendix_7.11_RFP%2031786-00186%20Written%20Questions%20and%20Comments%20template.docx DOCX document
Appendix_7.19_RFP_31786-00186%20Marketing%20and%20Communications%20Plan.xlsx XLSX spreadsheet
RFP_31786-00186_Amendment%20_5.pdf PDF
Appendix_7.22_RFP_31786-00186%20Sample%20Customized%20Communication%20Materials.pdf PDF
Appendix_7.13_RFP%2031786-00186_161596%20MetLife%20LTD%20Certificate%20of%20Coverage%20Eff.%20March%202021.pdf PDF
Appendix_7.18_RFP_31786-00186%20Disability%20Census%20as%20of%20December%202023.xlsx XLSX spreadsheet
Appendix_7.1_RFP_31786-00186%20Retirement%20Plan%20Guides.pdf PDF
Appendix_7.3a_RFP_31786-00186%20MetLife%20STD%20Certificate%20of%20Coverage.pdf PDF
Appendix_7.5_RFP_31786-00186%20Disability%20Census%20REVISED.xlsx XLSX spreadsheet
Appendix_7.12_RFP%2031786-00186_161596%20MetLife%20LTD%20Certificate%20of%20Coverage%20Eff.%20Jan%202018.pdf PDF
31786_00186_Short_and_Long_Term_Disability_Release_Two_for_posting.pdf PDF
Appendix_7.14_RFP%2031786-00186_161596%20MetLife%20LTD%20Certificate%20of%20Coverage%20Eff.%20Jan%202022.pdf PDF
Appendix_7.17_RFP_MetLife_Weekly_Disability_File_Transmission_Report_09-14-2025.pdf PDF
RFP%2031786-00186%20Amendment%20One.pdf PDF
Appendix_7.7_RFP_31786-00186%20Example%20Contractor%20STD%20LTD%20Decision%20Support%20System%20File%20Layout%20REVISED.xlsx XLSX spreadsheet
RFP_31786-00186_Amendment_Two.pdf PDF
Appendix_7_20_RFP_31786-00186_Communications_Efforts_Report.pdf PDF
Appendix_7.3c_RFP_31786-00186%20MetLife%20LTD%20Non-contributory%20Certificate%20of%20Coverage.pdf PDF
Disability_RFP_31786-00186_Attachment_6_3_Cost_Proposal_Scoring_Guide_REVISED.xlsx XLSX spreadsheet
31786_00186_Short_and_Long_Term_Disability_Release_Four.pdf PDF
Digital_Submission_Instructions.pdf PDF
RFP_31786_00186.pdf PDF
Appendix_7.3b_RFP_31786-00186%20MetLife%20LTD%20Contributory%20Certifcate%20of%20Coverage.pdf PDF
RFP%2031786-00186%20Amendment%20Four.pdf PDF
Appendix_7_6_RFP_31786-00186_Eligibility_Criteria_REVISED.pdf PDF
RFP_31786-00186_Amendment_Six.pdf PDF
RFP_31786-00186_Amendment_Three.pdf PDF
Appendix_7.8_RFP_31786-00186%20Claims%20History%20and%20P%20and%20L%20-%20REVISED.xlsx XLSX spreadsheet
Appendix_7.21_RFP_31786-00186%20Scorecard.xlsx XLSX spreadsheet
Appendix_7.9_RFP_31786-00186%20Disability%20Plan%20Changes%20Effective%20January%201%2c%202027%20REVISED.pdf PDF
Appendix_7.4%20RFP_31786-00186%20Enrollment%20and%20Premium%20History.xlsx XLSX spreadsheet
Appendix_7.2%20RFP_31786-00186%20State%20of%20TN%20Attendance%20and%20Leave%20Manual.pdf PDF
Appendix_7_16_RFP_31786-00186_STD_and_LTD_Premium_Rates.pdf PDF
Event_31786_00186_Release_3.pdf PDF
Appendix_7.1_RFP_31786-00186%20Retirement%20Plan%20Guides.pdf PDF
Appendix_7.22_RFP_31786-00186%20Sample%20Customized%20Communication%20Materials.pdf PDF
Appendix_7.4%20RFP_31786-00186%20Enrollment%20and%20Premium%20History.xlsx XLSX spreadsheet
Appendix_7.7_RFP_31786-00186%20Example%20Contractor%20STD%20LTD%20Decision%20Support%20System%20File%20Layout%20REVISED.xlsx XLSX spreadsheet
Appendix_7.18_RFP_31786-00186%20Disability%20Census%20as%20of%20December%202023.xlsx XLSX spreadsheet
RFP_31786-00186_Amendment_Two.pdf PDF
Appendix_7.2%20RFP_31786-00186%20State%20of%20TN%20Attendance%20and%20Leave%20Manual.pdf PDF
RFP_31786_00186.pdf PDF
Appendix_7.9_RFP_31786-00186%20Disability%20Plan%20Changes%20Effective%20January%201%2c%202027%20REVISED.pdf PDF
Appendix_7.17_RFP_MetLife_Weekly_Disability_File_Transmission_Report_09-14-2025.pdf PDF
Appendix_7.8_RFP_31786-00186%20Claims%20History%20and%20P%20and%20L%20-%20REVISED.xlsx XLSX spreadsheet
RFP_31786-00186_Amendment_Three.pdf PDF
31786_00186_Short_and_Long_Term_Disability_Release_Two_for_posting.pdf PDF
RFP_31786-00186_Amendment%20_5.pdf PDF
Appendix_7.3c_RFP_31786-00186%20MetLife%20LTD%20Non-contributory%20Certificate%20of%20Coverage.pdf PDF
Show 40 more

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

Sheet1

Time PeriodNumber of ClaimsFICA Paid Before Service Fee
Q2 20243$1,539.83
Q3 202412$4,857.62
Q4 202416$3,425.71
Q1 202511$4,483.14
Q2 202510$3,728.94

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