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 | ||
| LOSS RUN REPORT 317.xlsx | XLSX spreadsheet | |
| download (1).pdf.crdownload | CRDOWNLOAD file | |
| QUESTION AND ANSWER 3160007857.pdf | ||
| IFB 3160007857W LOSS RUN OPEN CLAIMS REPORT.pdf.crdownload | CRDOWNLOAD file | |
| IFB 3160007857W LOSS RUN OPEN CLAIMS REPORT.pdf | ||
| download.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 Loss | Claim Entry Date | Status | Type | Total Paid | Outstanding Reserve | Total Incurred | Location Name |
| 5/4/2015 | 5/22/2015 | Open | Ind | $233,121.06 | $73,552.39 | $306,673.45 | MDPS-DISTRICT 4-OFFICE 1-TRP F |
| 9/2/2015 | 9/23/2015 | Open | Ind | $17,601.96 | $24,120.25 | $41,722.21 | MDPS-DISTRICT 1-OFFICE 8-TRAINING ACAD |
| 2/20/2016 | 2/22/2016 | Open | Ind | $188,582.29 | $27,741.34 | $216,323.63 | MDPS-DISTRICT 1-OFFICE 10-TRP C |
| 2/20/2016 | 2/22/2016 | Open | Ind | $758,446.94 | $837,999.69 | $1,596,446.63 | MDPS-DISTRICT 1-OFFICE 8-TRAINING ACAD |
| 8/15/2016 | 8/15/2016 | Open | Ind | $622,243.29 | $584,043.65 | $1,206,286.94 | MDPS-DISTRICT 8-OFFICE 1-TRP K |
| 9/11/2016 | 9/12/2016 | Open | Ind | $656,821.37 | $436,627.15 | $1,093,448.52 | MDPS-DISTRICT 9-OFFICE 1-TRP M |
| 5/3/2021 | 5/5/2021 | Open | Ind | $14,308.85 | $9,610.44 | $23,919.29 | MDPS-DISTRICT 8-OFFICE 1-TRP K |
| 5/15/2021 | 5/17/2021 | Open | Ind | $3,524.71 | $1,496.29 | $4,221.00 | MDPS-DISTRICT 5-OFFICE 1-TRP G |
| 5/15/2021 | 5/17/2021 | Open | Ind | $3,131.34 | $1,889.66 | $4,221.00 | MDPS-DISTRICT 5-OFFICE 1-TRP G |
| 10/19/2021 | 10/19/2021 | Open | Ind | $176,151.28 | $109,115.20 | $285,266.48 | MDPS-DISTRICT 3-OFFICE 1-TRP E |
| 2/18/2022 | 2/22/2022 | Open | Ind | $57,284.31 | $6,863.05 | $64,147.36 | MDPS-DISTRICT 4-OFFICE 1-TRP F |
| 8/29/2022 | 8/30/2022 | Open | Ind | $75,109.38 | $69,633.02 | $144,742.40 | MDPS - JACKSON BN |
| 9/6/2022 | 9/7/2022 | Open | Ind | $158,310.69 | $43,545.00 | $183,105.69 | MDPS-DISTRICT 4-OFFICE 1-TRP F |
| 11/17/2022 | 4/17/2023 | Open | Ind | $10,461.88 | $29,773.12 | $40,235.00 | MDPS-COMMERICAL TRANSPORTATION ENFORCEMENT DIVISION |
| 1/17/2023 | 1/23/2023 | Open | Ind | $41,900.28 | $29,656.12 | $71,556.40 | MDPS - HEADQUARTERS BN |
| 4/4/2023 | 4/5/2023 | Open | Ind | $85,581.81 | $41,669.08 | $127,250.89 | MDPS-DISTRICT 1-OFFICE 10-TRP C |
| 8/2/2023 | 8/15/2023 | Open | Ind | $49,409.44 | $54,679.87 | $104,089.31 | MDPS-CAPITOL POLICE |
| 9/4/2023 | 9/7/2023 | Open | Ind | $63,135.48 | $149,186.02 | $212,321.50 | MDPS-DISTRICT 1-OFFICE 2-MS STATE HDQ |
| 3/5/2024 | 4/11/2024 | Open | Ind | $89,375.82 | $29,641.46 | $119,017.28 | MDPS-DISTRICT 1-OFFICE 8-CIC |
| 3/12/2024 | 3/13/2024 | Open | Ind | $52,769.53 | $60,899.59 | $113,669.12 | MDPS-CAPITOL POLICE |
| 3/17/2024 | 3/19/2024 | Open | Ind | $26,426.49 | $36,929.67 | $63,356.16 | MDPS - TROOPER SCHOOL |
| 5/24/2024 | 5/31/2024 | Open | Ind | $123,322.74 | $107,666.72 | $230,989.46 | MDPS-DISTRICT 8-OFFICE 1-TRP K |
| 8/1/2024 | 8/1/2024 | Open | Ind | $243,702.89 | $71,035.04 | $314,737.93 | MDPS-DISTRICT 8-OFFICE 1-TRP K |
| 8/15/2024 | 8/20/2024 | Open | Ind | $19,950.54 | $9,506.94 | $29,457.48 | MDPS-DISTRICT 1-OFFICE 8-CIC |
| 9/25/2024 | 11/19/2024 | Open | Med | $1,730.00 | $365.00 | $2,095.00 | MDPS-DISTRICT 8-OFFICE 1-TRP K |
| 10/5/2024 | 10/7/2024 | Open | Ind | $62,023.46 | $83,505.90 | $145,529.36 | MDPS-DISTRICT 3-OFFICE 1-TRP E |
| 10/28/2024 | 10/30/2024 | Open | Ind | $21,591.11 | $47,731.85 | $69,322.96 | MDPS-DISTRICT 3-OFFICE 1-TRP E |
| 11/18/2024 | 11/18/2024 | Open | Ind | $15,479.63 | $13,928.92 | $29,408.55 | DNU-MDPS DISTRICT 1-OFFICE 11 |
| 1/3/2025 | 1/13/2025 | Open | Ind | $10,404.56 | $16,961.28 | $27,365.84 | MDPS-CAPITOL POLICE |
| 1/17/2025 | 1/22/2025 | Open | Ind | $14,843.52 | $42,675.46 | $57,518.98 | MDPS-CAPITOL POLICE |
| 2/6/2025 | 2/7/2025 | Open | Ind | $49,915.38 | $50,518.71 | $100,434.09 | MDPS - HATTIESBURG BN |
| 2/18/2025 | 2/20/2025 | Open | Med | $3,598.55 | $3,360.00 | $6,958.55 | MDPS-CAPITOL POLICE |
| 3/9/2025 | 7/7/2025 | Open | Ind | $764.64 | $75,616.28 | $76,380.92 | MDPS - TROOPER SCHOOL |
| 3/11/2025 | 3/25/2025 | Open | Ind | $13,709.70 | $43,715.20 | $57,424.90 | MDPS - TROOPER SCHOOL |
| 3/13/2025 | 3/25/2025 | Open | Ind | $31,080.27 | $53,546.71 | $84,626.98 | MDPS - TROOPER SCHOOL |
| 3/19/2025 | 3/25/2025 | Open | Med | $3,115.47 | $2,164.53 | $5,280.00 | MDPS - TROOPER SCHOOL |
| 3/30/2025 | 4/16/2025 | Open | Ind | $5,780.77 | $2,399.23 | $8,180.00 | MDPS - TROOPER SCHOOL |
| 4/10/2025 | 4/15/2025 | Open | Ind | $15,559.54 | $37,716.74 | $53,276.28 | MDPS-CAPITOL POLICE |
| 4/20/2025 | 5/8/2025 | Open | Ind | $38,181.21 | $62,698.21 | $100,879.42 | MDPS-DISTRICT 1-OFFICE 10-TRP C |
| 4/21/2025 | 5/5/2025 | Open | Ind | $23,619.76 | $50,306.16 | $73,925.92 | MDPS-DISTRICT 2-OFFICE 1-TRP D |
| 5/7/2025 | 5/8/2025 | Open | Ind | $14,207.25 | $25,025.99 | $39,233.24 | MDPS-COMMERICAL TRANSPORTATION ENFORCEMENT DIVISION |
| 5/19/2025 | 5/20/2025 | Open | Ind | $3,238.44 | $11,291.56 | $11,588.94 | MDPS - GREENWOOD BN |
| 5/21/2025 | 5/27/2025 | Open | Med | $5,852.91 | $3,627.09 | $9,480.00 | DNU-MDPS-DISTRICT 3-OFFICE 6 |
| 5/29/2025 | 5/30/2025 | Open | Ind | $3,340.15 | $14,582.81 | $17,922.96 | MDPS-DISTRICT 2-OFFICE 1-TRP D |
| 6/9/2025 | 6/11/2025 | Open | Ind | $6,830.95 | $3,699.05 | $10,530.00 | MDPS-DISTRICT 1-OFFICE 8-CIC |
| 8/2/2025 | 8/4/2025 | Open | Ind | $277,322.58 | $659,525.92 | $936,848.50 | MDPS-DISTRICT 8-OFFICE 1-TRP K |
| 8/3/2025 | 8/12/2025 | Open | Med | $1,697.13 | $682.87 | $2,380.00 | MDPS-CAPITOL POLICE |
| 8/7/2025 | 10/6/2025 | Open | Med | $214.85 | $1,645.15 | $1,860.00 | MDPS-DISTRICT 6-OFFICE 1-TRP H |
| 8/20/2025 | 8/21/2025 | Open | Ind | $9,691.20 | $17,438.80 | $27,130.00 | MDPS - OXFORD BN |
| 8/20/2025 | 8/21/2025 | Open | Ind | $604.99 | $9,425.01 | $10,030.00 | MDPS - OXFORD BN |
| 8/31/2025 | 9/2/2025 | Open | Med | $923.39 | $2,256.61 | $3,180.00 | MDPS - MCCOMB BN |
| 9/11/2025 | 9/24/2025 | Open | Ind | $132.51 | $2,188.49 | $2,321.00 | MDPS-DISTRICT 9-OFFICE 1-TRP M |
| 9/13/2025 | 9/24/2025 | Open | Ind | $14,444.20 | $58,613.32 | $73,057.52 | MDPS-COMMERICAL TRANSPORTATION ENFORCEMENT DIVISION |
| 9/17/2025 | 9/18/2025 | Open | Med | $561.82 | $1,238.18 | $1,800.00 | MDPS-DISTRICT 1-OFFICE 1-CRIME LAB |
| 9/18/2025 | 9/18/2025 | Open | Med | $673.52 | $706.48 | $1,380.00 | DNU-MDPS-DISTRICT 3-OFFICE 5 |
| 9/21/2025 | 9/30/2025 | Open | Med | $1,812.47 | $4,647.53 | $6,460.00 | MDPS-DISTRICT 6-OFFICE 1-TRP H |
| 9/22/2025 | 10/8/2025 | Open | Ind | $6,081.76 | $32,139.92 | $38,221.68 | MDPS-COMMERICAL TRANSPORTATION ENFORCEMENT DIVISION |
| 9/25/2025 | 10/13/2025 | Open | Ind | $1,371.12 | $3,649.88 | $5,021.00 | MDPS-DISTRICT 1-OFFICE 2-MS STATE HDQ |
| 9/29/2025 | 9/30/2025 | Open | Ind | $8,937.59 | $53,501.39 | $62,438.98 | MDPS - HATTIESBURG BN |
| 10/6/2025 | 10/8/2025 | Open | Med | $25.00 | $575.00 | $600.00 | MDPS-DISTRICT 1-OFFICE 8-TRAINING ACAD |
| 10/13/2025 | 10/17/2025 | Open | Ind | $620.91 | $1,020.09 | $1,641.00 | DNU-MDPS-DISTRICT 8-OFFICE 5 |
| 10/18/2025 | 10/24/2025 | Open | Med | $373.39 | $1,136.61 | $1,510.00 | MDPS-COMMERICAL TRANSPORTATION ENFORCEMENT DIVISION |
| 10/20/2025 | 10/21/2025 | Open | Med | $63.70 | $2,276.30 | $2,340.00 | MDPS-COMMERICAL TRANSPORTATION ENFORCEMENT DIVISION |
| 10/26/2025 | 11/5/2025 | Open | Ind | $11,079.46 | $46,532.22 | $57,611.68 | MDPS-CAPITOL POLICE |
| 11/19/2025 | 11/20/2025 | Open | Med | $182.29 | $317.71 | $500.00 | MDPS-DISTRICT 1-OFFICE 10-TRP C |
| 11/20/2025 | 11/21/2025 | Open | Ind | $219.95 | $11,910.05 | $12,130.00 | MDPS - JACKSON BN |
| 12/1/2025 | 12/3/2025 | Open | Med | $25.00 | $815.00 | $840.00 | MDPS-CAPITOL POLICE |
| 12/1/2025 | 12/1/2025 | Open | Ind | $766.32 | $62,532.66 | $63,298.98 | MDPS - GREENWOOD BN |
| 12/12/2025 | 12/15/2025 | Open | Med | $25.00 | $1,295.00 | $1,320.00 | MDPS-DISTRICT 1-OFFICE 2-MS STATE HDQ |
| 12/26/2025 | 12/31/2025 | Open | Med | $0.00 | $840.00 | $840.00 | DNU-MDPS DISTRICT 1-OFFICE 11 |
File details come from the government source that posted it. Updated .