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

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

Written by GovTribe AI ·

This is a FICA Tax Amounts Paid appendix from RFP 31786-00186, documenting historical payroll tax data across five consecutive quarters. The document tracks the number of claims processed and corresponding FICA taxes paid before service fees from Q2 2024 through Q1 2025, providing baseline financial information for contract evaluation purposes.

The data shows fluctuating claim volumes and associated FICA tax payments over the specified period. Q3 2024 represented the highest claim volume at 12 claims with $4,857.62 in FICA taxes paid, while Q2 2024 had the lowest volume at 3 claims with $1,539.83 in FICA taxes paid. The remaining quarters (Q4 2024, Q1 2025, and Q2 2025) ranged from 10 to 16 claims with FICA taxes between $3,425.71 and $4,483.14. The total FICA taxes paid across all five quarters amounted to $18,035.24, representing the historical cost basis for this contract category.

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
Appendix_7.10_%20RFP_31786-00186%20FICA%20Tax%20Amounts%20Paid.xlsx XLSX spreadsheet
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
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
Try for free Login

Text version

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

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 .