RFP_5800_SLW3033_ATT_10_v1.xlsx

This is a Financial Analysis Report attachment to a Request for Proposals issued by the City of Austin, Texas, for Worker's Compensation Third Party Administration Services. The document presents workers' compensation payment data and claim analysis for the City of Austin as of October 30, 2025, and includes historical fiscal year information spanning from 1974 through 2025. The report breaks down payments by service category, including chiropractor services, death benefits, dental, durable medical equipment, emergency medical services, hospital inpatient and outpatient services, laboratory services, various income benefit types, mileage, physical therapy, physician office visits, prescriptions, case management, home health, and allocated expenses. The data provides claim counts and percentage allocations to total spending across multiple fiscal years, with particular emphasis on medical payments only versus all payment types.

The financial analysis demonstrates the City's historical workers' compensation expenditure patterns and claim volume trends, serving as critical baseline information for prospective third-party administrators to understand the scope and complexity of the administration contract. The detailed breakdown by service type and claim year enables bidders to assess staffing requirements, processing capabilities, and cost management strategies necessary to administer the City's workers' compensation program effectively. This exhibit provides the financial foundation upon which qualified workers' compensation third-party administrators with public sector experience can develop competitive proposals and demonstrate their capacity to manage the City's claims administration needs.