OPEN CLAIMS EXCEL REPORT.xlsx

XLSX spreadsheet 21 KB Posted

Attached to
1711-26-R-IFBD-00005-V03
Solicitation number
3160007857
Issued by
Mississippi

About this file

This is an Open Claims Excel Report for the State of Mississippi Department of Public Safety (MDPS) documenting the status of individual claims across multiple district offices and specialized divisions. The report contains 68 open claims entries spanning from May 2015 through December 2025, tracking claims data across various MDPS locations including District offices (1-9), the Training Academy, Capitol Police, Commercial Transportation Enforcement Division, and specialized battalions. The claims are categorized by type as either Individual (Ind) or Medical (Med), with corresponding financial metrics for each entry. No specific response dates, due dates, site visits, bidder meetings, or award information are contained within this claims report document itself. The report serves as a baseline reference document for the State of Mississippi's Third Party Claims Administration Services procurement (IFB 1711-26-R-IFBD-00005-V01), with a proposal submission deadline of March 31, 2026.

The Open Claims Report provides critical portfolio data necessary for prospective bidders to develop accurate cost estimates and service delivery plans. The total incurred amounts across all 68 claims range from $500 to over $1.5 million per claim, with cumulative outstanding reserves and paid amounts indicating substantial claims management requirements. The claims span nearly a decade of losses, demonstrating the complexity and aging characteristics of the portfolio that contractors must address. No specific pricing terms, budget allocations, incumbent contractor information, or funding sources are disclosed within this report document; prospective bidders are directed to obtain complete bid specifications and technical requirements directly from the State of Mississippi procurement office to ensure comprehensive understanding of all contract terms, evaluation criteria, and service expectations prior to proposal submission.

View the file

Other files

File Type Posted
download (1).pdf PDF
LOSS RUN REPORT 317.xlsx XLSX spreadsheet
download (1).pdf.crdownload CRDOWNLOAD file
QUESTION AND ANSWER 3160007857.pdf PDF
IFB 3160007857W LOSS RUN OPEN CLAIMS REPORT.pdf.crdownload CRDOWNLOAD file
IFB 3160007857W LOSS RUN OPEN CLAIMS REPORT.pdf PDF
download.pdf PDF

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

Date of LossClaim Entry DateStatusTypeTotal PaidOutstanding ReserveTotal IncurredLocation Name
5/4/20155/22/2015OpenInd$233,121.06$73,552.39$306,673.45MDPS-DISTRICT 4-OFFICE 1-TRP F
9/2/20159/23/2015OpenInd$17,601.96$24,120.25$41,722.21MDPS-DISTRICT 1-OFFICE 8-TRAINING ACAD
2/20/20162/22/2016OpenInd$188,582.29$27,741.34$216,323.63MDPS-DISTRICT 1-OFFICE 10-TRP C
2/20/20162/22/2016OpenInd$758,446.94$837,999.69$1,596,446.63MDPS-DISTRICT 1-OFFICE 8-TRAINING ACAD
8/15/20168/15/2016OpenInd$622,243.29$584,043.65$1,206,286.94MDPS-DISTRICT 8-OFFICE 1-TRP K
9/11/20169/12/2016OpenInd$656,821.37$436,627.15$1,093,448.52MDPS-DISTRICT 9-OFFICE 1-TRP M
5/3/20215/5/2021OpenInd$14,308.85$9,610.44$23,919.29MDPS-DISTRICT 8-OFFICE 1-TRP K
5/15/20215/17/2021OpenInd$3,524.71$1,496.29$4,221.00MDPS-DISTRICT 5-OFFICE 1-TRP G
5/15/20215/17/2021OpenInd$3,131.34$1,889.66$4,221.00MDPS-DISTRICT 5-OFFICE 1-TRP G
10/19/202110/19/2021OpenInd$176,151.28$109,115.20$285,266.48MDPS-DISTRICT 3-OFFICE 1-TRP E
2/18/20222/22/2022OpenInd$57,284.31$6,863.05$64,147.36MDPS-DISTRICT 4-OFFICE 1-TRP F
8/29/20228/30/2022OpenInd$75,109.38$69,633.02$144,742.40MDPS - JACKSON BN
9/6/20229/7/2022OpenInd$158,310.69$43,545.00$183,105.69MDPS-DISTRICT 4-OFFICE 1-TRP F
11/17/20224/17/2023OpenInd$10,461.88$29,773.12$40,235.00MDPS-COMMERICAL TRANSPORTATION ENFORCEMENT DIVISION
1/17/20231/23/2023OpenInd$41,900.28$29,656.12$71,556.40MDPS - HEADQUARTERS BN
4/4/20234/5/2023OpenInd$85,581.81$41,669.08$127,250.89MDPS-DISTRICT 1-OFFICE 10-TRP C
8/2/20238/15/2023OpenInd$49,409.44$54,679.87$104,089.31MDPS-CAPITOL POLICE
9/4/20239/7/2023OpenInd$63,135.48$149,186.02$212,321.50MDPS-DISTRICT 1-OFFICE 2-MS STATE HDQ
3/5/20244/11/2024OpenInd$89,375.82$29,641.46$119,017.28MDPS-DISTRICT 1-OFFICE 8-CIC
3/12/20243/13/2024OpenInd$52,769.53$60,899.59$113,669.12MDPS-CAPITOL POLICE
3/17/20243/19/2024OpenInd$26,426.49$36,929.67$63,356.16MDPS - TROOPER SCHOOL
5/24/20245/31/2024OpenInd$123,322.74$107,666.72$230,989.46MDPS-DISTRICT 8-OFFICE 1-TRP K
8/1/20248/1/2024OpenInd$243,702.89$71,035.04$314,737.93MDPS-DISTRICT 8-OFFICE 1-TRP K
8/15/20248/20/2024OpenInd$19,950.54$9,506.94$29,457.48MDPS-DISTRICT 1-OFFICE 8-CIC
9/25/202411/19/2024OpenMed$1,730.00$365.00$2,095.00MDPS-DISTRICT 8-OFFICE 1-TRP K
10/5/202410/7/2024OpenInd$62,023.46$83,505.90$145,529.36MDPS-DISTRICT 3-OFFICE 1-TRP E
10/28/202410/30/2024OpenInd$21,591.11$47,731.85$69,322.96MDPS-DISTRICT 3-OFFICE 1-TRP E
11/18/202411/18/2024OpenInd$15,479.63$13,928.92$29,408.55DNU-MDPS DISTRICT 1-OFFICE 11
1/3/20251/13/2025OpenInd$10,404.56$16,961.28$27,365.84MDPS-CAPITOL POLICE
1/17/20251/22/2025OpenInd$14,843.52$42,675.46$57,518.98MDPS-CAPITOL POLICE
2/6/20252/7/2025OpenInd$49,915.38$50,518.71$100,434.09MDPS - HATTIESBURG BN
2/18/20252/20/2025OpenMed$3,598.55$3,360.00$6,958.55MDPS-CAPITOL POLICE
3/9/20257/7/2025OpenInd$764.64$75,616.28$76,380.92MDPS - TROOPER SCHOOL
3/11/20253/25/2025OpenInd$13,709.70$43,715.20$57,424.90MDPS - TROOPER SCHOOL
3/13/20253/25/2025OpenInd$31,080.27$53,546.71$84,626.98MDPS - TROOPER SCHOOL
3/19/20253/25/2025OpenMed$3,115.47$2,164.53$5,280.00MDPS - TROOPER SCHOOL
3/30/20254/16/2025OpenInd$5,780.77$2,399.23$8,180.00MDPS - TROOPER SCHOOL
4/10/20254/15/2025OpenInd$15,559.54$37,716.74$53,276.28MDPS-CAPITOL POLICE
4/20/20255/8/2025OpenInd$38,181.21$62,698.21$100,879.42MDPS-DISTRICT 1-OFFICE 10-TRP C
4/21/20255/5/2025OpenInd$23,619.76$50,306.16$73,925.92MDPS-DISTRICT 2-OFFICE 1-TRP D
5/7/20255/8/2025OpenInd$14,207.25$25,025.99$39,233.24MDPS-COMMERICAL TRANSPORTATION ENFORCEMENT DIVISION
5/19/20255/20/2025OpenInd$3,238.44$11,291.56$11,588.94MDPS - GREENWOOD BN
5/21/20255/27/2025OpenMed$5,852.91$3,627.09$9,480.00DNU-MDPS-DISTRICT 3-OFFICE 6
5/29/20255/30/2025OpenInd$3,340.15$14,582.81$17,922.96MDPS-DISTRICT 2-OFFICE 1-TRP D
6/9/20256/11/2025OpenInd$6,830.95$3,699.05$10,530.00MDPS-DISTRICT 1-OFFICE 8-CIC
8/2/20258/4/2025OpenInd$277,322.58$659,525.92$936,848.50MDPS-DISTRICT 8-OFFICE 1-TRP K
8/3/20258/12/2025OpenMed$1,697.13$682.87$2,380.00MDPS-CAPITOL POLICE
8/7/202510/6/2025OpenMed$214.85$1,645.15$1,860.00MDPS-DISTRICT 6-OFFICE 1-TRP H
8/20/20258/21/2025OpenInd$9,691.20$17,438.80$27,130.00MDPS - OXFORD BN
8/20/20258/21/2025OpenInd$604.99$9,425.01$10,030.00MDPS - OXFORD BN
8/31/20259/2/2025OpenMed$923.39$2,256.61$3,180.00MDPS - MCCOMB BN
9/11/20259/24/2025OpenInd$132.51$2,188.49$2,321.00MDPS-DISTRICT 9-OFFICE 1-TRP M
9/13/20259/24/2025OpenInd$14,444.20$58,613.32$73,057.52MDPS-COMMERICAL TRANSPORTATION ENFORCEMENT DIVISION
9/17/20259/18/2025OpenMed$561.82$1,238.18$1,800.00MDPS-DISTRICT 1-OFFICE 1-CRIME LAB
9/18/20259/18/2025OpenMed$673.52$706.48$1,380.00DNU-MDPS-DISTRICT 3-OFFICE 5
9/21/20259/30/2025OpenMed$1,812.47$4,647.53$6,460.00MDPS-DISTRICT 6-OFFICE 1-TRP H
9/22/202510/8/2025OpenInd$6,081.76$32,139.92$38,221.68MDPS-COMMERICAL TRANSPORTATION ENFORCEMENT DIVISION
9/25/202510/13/2025OpenInd$1,371.12$3,649.88$5,021.00MDPS-DISTRICT 1-OFFICE 2-MS STATE HDQ
9/29/20259/30/2025OpenInd$8,937.59$53,501.39$62,438.98MDPS - HATTIESBURG BN
10/6/202510/8/2025OpenMed$25.00$575.00$600.00MDPS-DISTRICT 1-OFFICE 8-TRAINING ACAD
10/13/202510/17/2025OpenInd$620.91$1,020.09$1,641.00DNU-MDPS-DISTRICT 8-OFFICE 5
10/18/202510/24/2025OpenMed$373.39$1,136.61$1,510.00MDPS-COMMERICAL TRANSPORTATION ENFORCEMENT DIVISION
10/20/202510/21/2025OpenMed$63.70$2,276.30$2,340.00MDPS-COMMERICAL TRANSPORTATION ENFORCEMENT DIVISION
10/26/202511/5/2025OpenInd$11,079.46$46,532.22$57,611.68MDPS-CAPITOL POLICE
11/19/202511/20/2025OpenMed$182.29$317.71$500.00MDPS-DISTRICT 1-OFFICE 10-TRP C
11/20/202511/21/2025OpenInd$219.95$11,910.05$12,130.00MDPS - JACKSON BN
12/1/202512/3/2025OpenMed$25.00$815.00$840.00MDPS-CAPITOL POLICE
12/1/202512/1/2025OpenInd$766.32$62,532.66$63,298.98MDPS - GREENWOOD BN
12/12/202512/15/2025OpenMed$25.00$1,295.00$1,320.00MDPS-DISTRICT 1-OFFICE 2-MS STATE HDQ
12/26/202512/31/2025OpenMed$0.00$840.00$840.00DNU-MDPS DISTRICT 1-OFFICE 11

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