KCDHS-Budget-Worksheet.xlsx

This is a budget worksheet template file from the Kenosha County Department of Human Services (KCDHS) designed for contractors to submit detailed financial proposals for human services programs. The Excel-based template (Version 141104) consists of five main worksheets that require contractors to provide comprehensive budget breakdowns including FTE and salary allocation, benefit allocation, total expense summary, other services explanation, and revenue sources. The template accommodates up to 50 staff positions and includes fields for contractor information such as agency name, contract period dates, and program name, though these fields are currently blank as this is an unfilled template rather than a completed proposal.

The budget worksheet requires detailed financial information including annual salaries, FTE allocations between direct staff and administrative roles, benefit calculations (FICA, health insurance, unemployment compensation, retirement), equipment purchases over $500, contracted services, and various operational expenses such as rent, utilities, supplies, and travel. The template includes provisions for administration allocation rates with required detailed explanations, allows for up to 5% profit margin for for-profit agencies, and provides options for both actual reimbursement budgets and unit rate calculations based on direct staff hours (calculated as DS FTE x 2080 hours x 75% efficiency). The worksheet also accommodates offset revenue from other sources and includes protective formatting with blue-shaded areas indicating required input fields while maintaining data integrity through worksheet protection.