Custom Loss Run Report Summary

This document is a Custom Loss Run Report prepared for the City of Chandler's workers' compensation claims portfolio, covering the period from July 1, 2017, through June 30, 2023. The report provides a comprehensive pivot table analysis of claim types organized by injury fiscal year, with detailed claim-level data presented in tabular format. The dataset encompasses 889 total claims across the six-year period, with claim classifications categorized as IND (presumably Individual or Indemnity), MO (Medical Only), and RO (Return to Work or similar classification). The report includes multiple financial metrics for each claim, including Medical (MED) Paid, Compliance (CMP) Paid, Allowed Expenses (ALE) Paid, Total Reserve amounts, Total Recoveries, and Net Incurred costs. Aggregate figures across all fiscal years show total Medical Paid of $4,063,100.53, total Compliance Paid of $1,700,033.25, total Allowed Expenses Paid of $1,511,419.80, total reserves of $6,096,613.76, total recoveries of $106,290.91, and net incurred losses of $13,264,876.43. The report is marked with a HIPAA warning indicating it contains protected patient information and was prepared on January 16, 2025.

The report demonstrates significant variation in claims costs across the fiscal years analyzed, with 2018 showing the highest net incurred amount at $3,120,794.82 for IND claims and 2019 at $1,748,710.63. The data reveals that IND classifications consistently generate substantially higher costs per claim compared to MO classifications, reflecting the distinction between full indemnity claims and medical-only claims. Notable individual claims with exceptional costs include CN-18-005455 ($1,386,505.59 net incurred), CN-22-005123 ($1,514,606.59 net incurred), and CN-21-005148 ($1,160,690.03 net incurred), indicating the presence of catastrophic injury claims within the portfolio. The systematic tracking of these claims across multiple cost categories—including paid medical expenses, compliance costs, reserves, and recoveries—provides the City of Chandler with detailed loss history essential for evaluating third-party claims administration performance and estimating future funding requirements for workers' compensation obligations.