RFP 202603 BW.xlsx

This is a budget worksheet template for the Kenosha County Department of Human Services designed to support contract proposals and budgeting for state and local services. The document serves as the standard financial planning tool for agencies bidding on or administering contracts with Kenosha County, particularly for programs such as supervised visitation services for children in out-of-home care. The template is organized into five primary worksheets: FTE and Salary Allocation (Worksheet 1), which captures personnel positions, degrees, annual salaries, and full-time equivalent allocations; Benefit Allocation (Worksheet 2), which calculates FICA, health insurance premiums, unemployment compensation, retirement contributions, and other employee benefits; Total Expense Summary (Worksheet 3), which consolidates personnel costs and itemizes other expenses including contracted services, equipment purchases, data processing, training, travel, insurance, utilities, and supplies; Detail of Other Expenses (Worksheet 4), which provides line-item justifications for contracted services and equipment exceeding $500; and Other Revenue Sources (Worksheet 5), which identifies funding sources to offset program costs. The template accommodates up to 50 staff positions and supports both actual reimbursement budgets and unit-rate budget calculations.

The budget template permits agencies to request actual cost reimbursement or to calculate cost per unit based on direct staff FTE multiplied by 2,080 hours annually at 75 percent utilization. Agencies may allocate indirect administration costs with required detailed explanation of the calculation methodology, and for-profit entities may include expected profit not to exceed 5 percent of the total program budget. Personnel costs must not exceed the program funding level specified by the Department of Human Services, and all blue-shaded fields require input while other fields remain protected. The template was most recently revised in November 2014 to include staff identifiers such as first name, last name, and degree level, with degree options including advanced practice nurse practitioner, bachelor's degree, master's degree, psychiatrist/MD, PhD, psychologist/doctoral, and qualified treatment trainee designations. The worksheet serves as a standardized mechanism to ensure consistent financial proposal submission and evaluation across all potential service providers contracting with Kenosha County.