22-Attachment B - Milwaukee County - Lives history.xlsx

This is a life insurance coverage history document for Milwaukee County, Wisconsin, detailing enrollment data for Basic Life Insurance, Optional Life Insurance, and Dependent Life Insurance programs from January 2021 through December 2025. The document supports Milwaukee County's Request for Proposal to solicit qualified firms to provide insurance coverage and full administrative services for these programs. Willis Towers Watson Midwest, Inc. serves as the County's Broker of Record. The County intends to award a contract for an initial three-year term with renewal options available to the selected respondent.

The enrollment data reveals significant workforce composition across three coverage categories. Basic Life Insurance enrollment ranged from approximately 7,122 to 7,634 total lives across the five-year period, with active employees comprising roughly 4,400 to 4,700 lives and retirees ranging from 2,244 to 3,044 lives. Optional Life Insurance participation fluctuated considerably, ranging from 1,078 to 2,133 lives, with notable increases in 2024 and 2025. Dependent Life Insurance coverage remained relatively stable, ranging from approximately 1,467 to 1,813 lives. The data demonstrates consistent employee populations with seasonal variations and shows growth in optional coverage participation in recent periods, providing prospective bidders with critical enrollment metrics necessary for rate development and administrative planning.