3-Exhibit A - Claim Count and Amounts.xlsx

This exhibit is a claims data summary document submitted by the City of Dallas in support of a Request for Proposal for actuarial services related to risk management. The document presents historical claim information for the fiscal year period of October 1, 2024, through September 30, 2025, across multiple insurance coverage categories. The City seeks to establish a three-year service price agreement with a consultant to provide actuarial analysis and advisory services for self-funded workers' compensation, general liability, and auto liability exposures.

The claims data reveals significant exposure across the organization's insurance portfolio. Workers' compensation represents the largest liability category with 1,782 claims totaling $14,782,987.14 in incurred costs and $7,994,858.83 in paid claims. General liability follows with 1,138 claims at $102,345.86 incurred and $87,736.91 paid. Auto liability accounts for 645 claims with $1,684,971.58 incurred and $1,107,346.97 paid. Additional coverages include contractual liability (4 claims, $0.00 incurred and paid), employment practices liability (17 claims, $0.00 incurred and paid), and law enforcement liability (14 claims, $0.00 incurred and paid). This claims experience demonstrates the City's need for expert actuarial analysis to evaluate its risk management strategy and reserving requirements across these self-funded programs.