Exhibit P - Active Census with Sick Leavel.xlsx

This document is an active employee census with sick leave balances for the City of Madison, Wisconsin, compiled in support of a life and disability insurance procurement. The file contains detailed personnel data for approximately 800 active employees across multiple city departments including Fire, Police, Streets, Water, Library, Parks, Engineering, and Metro Transit. The data includes employee identification numbers, job classifications, salary information, employment tenure, age, gender, FTE percentages, and current sick leave balances. The census appears designed to support actuarial analysis and rate development for basic life insurance, voluntary life insurance, accidental death and dismemberment (AD&D) coverage, and wage replacement insurance products (short-term and long-term disability). The spreadsheet tracks current benefit elections including basic life coverage amounts, supplemental life options at various coverage levels (50%, 100%, 200%), dependent coverage status, and wage insurance enrollment.

The employee population demonstrates significant diversity in compensation levels, ranging from hourly crossing guard positions with no annual salary to department heads earning over $200,000 annually. Approximately 86% of full-time permanent employees maintain active sick leave balances, with amounts varying from zero to over 2,000 hours, reflecting varying tenure and absence patterns. The data captures comprehensive benefit participation metrics that would inform premium calculations, including life insurance elections across approximately 70% of the workforce and dependent coverage selections. This census data is critical for establishing baseline risk profiles, determining appropriate coverage levels, and calculating claims experience for the insurance procurement, as the vendor will need to understand the demographic composition, salary distribution, and current benefit utilization across the city workforce to develop competitive and appropriate proposals.