{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["1. FTE & Salary Allocation","2. Benefit Allocation","3. Total Expense Summary","4. Equipment_Other Detail","5. Budget Narrative"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1. FTE & Salary Allocation","index":0,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,1,1,4],[7,2,7,5]]}
["Kenosha County Department of Human Services Budget Worksheet #1 -- FTE & Salary Allocation",null,null,null,null,"Version: 2024"]
["Agency Name"]
[]
["     Please enter all information as indicated by BLUE font color and shaded in BLUE."]
[]
[]
[]
[null,null,"Enter Program Name Here"]
["Position ","Enter Annual Salary regardless of time allocated to Program","Total FTE","Direct Staff FTE","Admin/ Clerical/ Supervision","Allocation of Salary to Program"]
[null,0,{"$f":"SUM(D10:E10)","v":0},0,null,{"$f":"+B10*C10","v":0}]
[null,0,0,0,null,0]
[null,0,0,0,null,0]
[null,0,0,0,null,0]
[null,0,0,0,null,0]
[null,0,0,0,null,0]
[null,0,0,0,null,0]
[null,0,0,0,null,0]
[null,0,0,0,null,0]
[null,0,0,0,null,0]
[null,0,0,0,null,0]
[null,0,0,0,null,0]
[null,0,0,0,null,0]
[null,0,0,0,null,0]
[null,0,0,0,null,0]
[null,0,0,0,null,0]
[null,0,0,0,null,0]
[null,0,0,0,null,0]
["Total Time Allocation",{"$f":"SUM(B9:B27)","v":0},{"$f":"SUM(C10:C27)","v":0},{"$f":"SUM(D10:D27)","v":0},{"$f":"SUM(E10:E27)","v":0},{"$f":"SUM(F10:F27)","v":0}]

{"sheet":"2. Benefit Allocation","index":1,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,4],[4,0,4,4]]}
["Kenosha County Department of Human Services Budget Worksheet #2 -- Benefit Allocation",null,null,null,null,"Version: 2024"]
["Agency Name",{"$f":"+'1. FTE & Salary Allocation'!B2","v":0}]
[" Please enter all information as indicated by BLUE font color and shaded in BLUE."]
[]
["Annual amounts should be entered.  The last column will adjust to the actual FTE % allocated to the program as shown on the Time Allocation worksheet (#1)."]
[]
[]
[null,null,"Annual Salary and Benefit Calculation",null,null,null,null,null,null,{"$f":"+'1. FTE & Salary Allocation'!C8","v":"Enter Program Name Here"}]
["Position","Annual Salary","FICA","Annual Health Insurance Premiums (if applicable)","State and Federal UC (if applicable)","Retirement (if applicable)","Other Explanation","Other $","Total Annual Benefits","Allocated Program Benefits"]
[{"$f":"+'1. FTE & Salary Allocation'!A10","v":0},{"$f":"+'1. FTE & Salary Allocation'!B10","v":0},{"$f":"+B10*0.0765","v":0},0,0,0,null,0,{"$f":"SUM(C10:H10)","v":0},{"$f":"+I10*'1. FTE & Salary Allocation'!C10","v":0}]
[{"$f":"+'1. FTE & Salary Allocation'!A11","v":0},{"$f":"+'1. FTE & Salary Allocation'!B11","v":0},0,0,0,0,null,0,{"$f":"SUM(C11:H11)","v":0},{"$f":"+I11*'1. FTE & Salary Allocation'!C11","v":0}]
[{"$f":"+'1. FTE & Salary Allocation'!A12","v":0},{"$f":"+'1. FTE & Salary Allocation'!B12","v":0},0,0,0,0,null,0,{"$f":"SUM(C12:H12)","v":0},{"$f":"+I12*'1. FTE & Salary Allocation'!C12","v":0}]
[{"$f":"+'1. FTE & Salary Allocation'!A13","v":0},{"$f":"+'1. FTE & Salary Allocation'!B13","v":0},0,0,0,0,null,0,0,{"$f":"+I13*'1. FTE & Salary Allocation'!C13","v":0}]
[{"$f":"+'1. FTE & Salary Allocation'!A14","v":0},{"$f":"+'1. FTE & Salary Allocation'!B14","v":0},0,0,0,0,null,0,0,{"$f":"+I14*'1. FTE & Salary Allocation'!C14","v":0}]
[{"$f":"+'1. FTE & Salary Allocation'!A15","v":0},{"$f":"+'1. FTE & Salary Allocation'!B15","v":0},0,0,0,0,null,0,0,{"$f":"+I15*'1. FTE & Salary Allocation'!C15","v":0}]
[{"$f":"+'1. FTE & Salary Allocation'!A16","v":0},{"$f":"+'1. FTE & Salary Allocation'!B16","v":0},0,0,0,0,null,0,0,{"$f":"+I16*'1. FTE & Salary Allocation'!C16","v":0}]
[{"$f":"+'1. FTE & Salary Allocation'!A17","v":0},{"$f":"+'1. FTE & Salary Allocation'!B17","v":0},0,0,0,0,null,0,0,{"$f":"+I17*'1. FTE & Salary Allocation'!C17","v":0}]
[{"$f":"+'1. FTE & Salary Allocation'!A18","v":0},{"$f":"+'1. FTE & Salary Allocation'!B18","v":0},0,0,0,0,null,0,0,{"$f":"+I18*'1. FTE & Salary Allocation'!C18","v":0}]
[{"$f":"+'1. FTE & Salary Allocation'!A19","v":0},{"$f":"+'1. FTE & Salary Allocation'!B19","v":0},0,0,0,0,null,0,0,{"$f":"+I19*'1. FTE & Salary Allocation'!C19","v":0}]
[{"$f":"+'1. FTE & Salary Allocation'!A20","v":0},{"$f":"+'1. FTE & Salary Allocation'!B20","v":0},0,0,0,0,null,0,0,{"$f":"+I20*'1. FTE & Salary Allocation'!C20","v":0}]
[{"$f":"+'1. FTE & Salary Allocation'!A21","v":0},{"$f":"+'1. FTE & Salary Allocation'!B21","v":0},0,0,0,0,null,0,0,{"$f":"+I21*'1. FTE & Salary Allocation'!C21","v":0}]
[{"$f":"+'1. FTE & Salary Allocation'!A22","v":0},{"$f":"+'1. FTE & Salary Allocation'!B22","v":0},0,0,0,0,null,0,0,{"$f":"+I22*'1. FTE & Salary Allocation'!C22","v":0}]
[{"$f":"+'1. FTE & Salary Allocation'!A23","v":0},{"$f":"+'1. FTE & Salary Allocation'!B23","v":0},0,0,0,0,null,0,0,{"$f":"+I23*'1. FTE & Salary Allocation'!C23","v":0}]
[{"$f":"+'1. FTE & Salary Allocation'!A24","v":0},{"$f":"+'1. FTE & Salary Allocation'!B24","v":0},0,0,0,0,null,0,0,{"$f":"+I24*'1. FTE & Salary Allocation'!C24","v":0}]
[{"$f":"+'1. FTE & Salary Allocation'!A25","v":0},{"$f":"+'1. FTE & Salary Allocation'!B25","v":0},0,0,0,0,null,0,0,{"$f":"+I25*'1. FTE & Salary Allocation'!C25","v":0}]
[{"$f":"+'1. FTE & Salary Allocation'!A26","v":0},{"$f":"+'1. FTE & Salary Allocation'!B26","v":0},0,0,0,0,null,0,0,{"$f":"+I26*'1. FTE & Salary Allocation'!C26","v":0}]
[{"$f":"+'1. FTE & Salary Allocation'!A27","v":0},{"$f":"+'1. FTE & Salary Allocation'!B27","v":0},0,0,0,0,null,0,0,{"$f":"+I27*'1. FTE & Salary Allocation'!C27","v":0}]
["Total Benefits",{"$f":"SUM(B10:B27)","v":0},{"$f":"SUM(C10:C27)","v":0},{"$f":"SUM(D10:D27)","v":0},{"$f":"SUM(E10:E27)","v":0},{"$f":"SUM(F10:F27)","v":0},null,{"$f":"SUM(H10:H27)","v":0},{"$f":"SUM(I10:I27)","v":0},{"$f":"SUM(J10:J27)","v":0}]

{"sheet":"3. Total Expense Summary","index":2,"n_rows":77,"n_cols":6,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,0,0,3],[3,1,3,4],[56,0,56,2]]}
["Kenosha County Department of Human Services Budget Worksheet #3 -- Total Expense Summary",null,null,null,"Version: 2024"]
["Agency Name",null,{"$f":"+'1. FTE & Salary Allocation'!B2:E2","v":0},0,0,0]
[null,"Please enter all information as indicated by BLUE font color and BLUE shaded area."]
[null,"NOTE:  For the Room & Board component of the contracted daily rate, the Purchaser will pay the provider's bugeted amount up to a maximum of $24.00 per day.  If a budget is submitted with Room & Board costs higher than $24.00 per day, the Purchaser reserves the right to subtract the excess amount from the total proposed daily rate to establish the contracted daily rate."]
[null,null,"Total Facility Costs Separated by Funding for MA Waiver Program"]
[null,null,"Total Facility Costs","Room & Board","Program Costs"]
["Personnel","Employee Salary Allocation - Worksheet 1",{"$f":"+'1. FTE & Salary Allocation'!F28","v":0},null,{"$f":"+C7","v":0}]
["Personnel","Employee Benefit Allocation - Worksheet 2",{"$f":"+'2. Benefit Allocation'!J28","v":0},null,{"$f":"+C8","v":0}]
["Personnel","Owners Salaries & Benefits",null,null,{"$f":"+C9","v":0}]
["Personnel","Respite Care",null,null,{"$f":"+C10","v":0}]
[null,"Total Personnel",{"$f":"SUM(C7:C10)","v":0},null,{"$f":"SUM(E7:E10)","v":0}]
[null,"OTHER EXPENSES:"]
["Transportation","Travel Reimbursement to Staff",0,null,{"$f":"+C13","v":0}]
["Transportation","Client Transportation",null,null,{"$f":"+C14","v":0}]
["Maintenance /Utilities","Maintenance/Utilities - Telephone for Facility",null,null,{"$f":"+C15","v":0}]
["Maintenance /Utilities","Maintenance/Utilities - Telephone for residents",null,{"$f":"+C16","v":0}]
["Maintenance /Utilities","Maintenance/Utilites - Utilities",null,0]
["Maintenance /Utilities","Cable TV",null,0]
["Maintenance /Utilities","Snow Removal/Lawn Care - Contracted Services",null,0]
["Maintenance /Utilities","Maint & repairs-Building",null,0]
["Maintenance /Utilities","Maint & repairs-resident equipment",null,0]
["Maintenance /Utilities","Maint & repairs-other than building & resident equip",null,null,{"$f":"+C22","v":0}]
["Housing","Rentals-Building Housing for CBRF",null,{"$f":"+C23","v":0},"."]
["Housing","Rentals - equipment related to room & board",null,{"$f":"+C24","v":0}]
["Housing","Depreciation-land improvements, building, and equipiment related to room and board",null,{"$f":"+C25","v":0}]
["Housing","Depreciation-land improvements, building, and equipiment NOT related to room and board",null,null,{"$f":"+C26","v":0}]
["Housing","Interest-related to building and room & board",null,{"$f":"+C27","v":0}]
["Housing","Interest-other than building and room & board",null,null,{"$f":"+C28","v":0}]
["Housing","Taxes-related to room & board (Real Estate)",null,{"$f":"+C29","v":0}]
["Housing","Insurance-Property",null,{"$f":"+C30","v":0}]
["Housing","Insurance-Other than Property",null,null,{"$f":"+C31","v":0}]
["Equipment Purchases","Equipment purchases > $500 related to room & board (list detail on worksheet #4)",null,{"$f":"+C32","v":0}]
["Equipment Purchases","Equipment purchases > $500 not related to room & board (list detail on worksheet #4)",null,null,{"$f":"+C33","v":0}]
["Food","Food",null,{"$f":"+C34","v":0}]
["Other","Advertising",null,null,{"$f":"+C35","v":0}]
["Other","Recruitment",null,null,{"$f":"+C36","v":0}]
["Other","Staff Development, education, etc.",null,null,{"$f":"+C37","v":0}]
["Other","Printing",null,null,{"$f":"+C38","v":0}]
["Other","Newspapers/Subscriptions",null,null,{"$f":"+C39","v":0}]
["Other","Supplies-Household supplies & linens",null,{"$f":"+C40","v":0}]
["Other","Supplies-Other than household supplies & linens",null,null,{"$f":"+C41","v":0}]
["Other","Professional Fees",null,null,{"$f":"+C42","v":0}]
["Other","Licenses",null,null,{"$f":"+C43","v":0}]
["Other","Other Allowable Costs related to room & board (list detail on worksheet #4--NOTE:  If no detail found, this line item will disregarded)",null,{"$f":"+C44","v":0}]
["Other","Other Allowable Costs not related to room & board (list detail on worksheet #4--NOTE:  If no detail found, this line item will disregarded))",null,null,{"$f":"+C45","v":0}]
[null,"Sub-Total including Personnel",{"$f":"SUM(C11:C45)","v":0},{"$f":"SUM(D11:D45)","v":0},{"$f":"SUM(E11:E45)","v":0},{"$f":"+E46+D46-C46","v":0}]
[null,"Admin Allocation (Enter Rate Below for automatic calculation)  USED FOR LARGE ENTITIES ONLY",{"$f":"+$C$54*C46","v":0},{"$f":"+D46/C46*C47","v":{"$error":"#DIV/0!"}},{"$f":"+C47-D47","v":{"$error":"#DIV/0!"}}]
[{"$f":"+C48/(C47+C46)","v":{"$error":"#DIV/0!"}},"Expected Profit Maximum 5% (FOR PROFIT AGENCIES ONLY--Reference Wisconsin Allowable Cost Policy)",null,{"$f":"+D46/C46*C48","v":{"$error":"#DIV/0!"}},{"$f":"+C48-D48","v":{"$error":"#DIV/0!"}}]
[null,"Total Costs",{"$f":"SUM(C46:C48)","v":0},{"$f":"SUM(D46:D48)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E46:E48)","v":{"$error":"#DIV/0!"}},{"$f":"+E49+D49-C49","v":{"$error":"#DIV/0!"}}]
[null,"Licensed Beds in facility",null,{"$f":"+C50","v":0},{"$f":"+C50","v":0}]
[null,"Annual cost per bed",{"$f":"+C49/C50","v":{"$error":"#DIV/0!"}},{"$f":"+D49/D50","v":{"$error":"#DIV/0!"}},{"$f":"+E49/E50","v":{"$error":"#DIV/0!"}}]
[null,"Monthly Rate",{"$f":"+C51/12","v":{"$error":"#DIV/0!"}},{"$f":"+D51/12","v":{"$error":"#DIV/0!"}},{"$f":"+E51/12","v":{"$error":"#DIV/0!"}}]
[null,"Daily Rate",{"$f":"+C51/365","v":{"$error":"#DIV/0!"}},{"$f":"+D51/365","v":{"$error":"#DIV/0!"}},{"$f":"+E51/365","v":{"$error":"#DIV/0!"}}]
[null,"Admin Allocation Rate (Maximum 10%)"]
[null,null,null,{"$f":"24-D53","v":{"$error":"#DIV/0!"}},"(Over) Under $24.00"]
[]
["Monthly Allowable Rent Calculation (less food, cable TV, and personal phone charges)",null,null,{"$f":"(+D49-D34-D16-D18)/D50/12","v":{"$error":"#DIV/0!"}}]
[null,"Total Residential Square Footage"]
[null,"Personal Use Square Footage"]
[null,"Provider Contact Name"]
[null,"Provider Address"]
[]
[null,"Provider Phone"]
[null,"Provider Fax"]
[]
[null,"Department Use Only -- Summary of Above Costs:","Total Costs","Cost Per Bed"]
[null,"Personnel",{"$f":"SUM(C7:C10)","v":0},{"$f":"+C67/$C$50","v":{"$error":"#DIV/0!"}}]
[null,"Transportation",{"$f":"SUM(C13:C14)","v":0},{"$f":"+C68/$C$50","v":{"$error":"#DIV/0!"}}]
[null,"Maintenance/Utilities",{"$f":"SUM(C15:C22)","v":0},{"$error":"#DIV/0!"}]
[null,"Housing",{"$f":"SUM(C23:C31)","v":0},{"$error":"#DIV/0!"}]
[null,"Food",{"$f":"+C34","v":0},{"$error":"#DIV/0!"}]
[null,"Equipment Purchases",{"$f":"SUM(C32:C33)","v":0},{"$error":"#DIV/0!"}]
[null,"Other",{"$f":"SUM(C35:C45)","v":0},{"$error":"#DIV/0!"}]
[null,"Administration/Overhead",{"$f":"+C47","v":0},{"$error":"#DIV/0!"}]
[null,"Profit",{"$f":"+C48","v":0},{"$error":"#DIV/0!"}]
[null,null,{"$f":"SUM(C67:C75)","v":0},{"$f":"+C76/C50","v":{"$error":"#DIV/0!"}}]
[null,"Ck figure - should be 0",{"$f":"+C76-C49","v":0},{"$f":"SUM(D67:D75)-D76","v":{"$error":"#DIV/0!"}}]

{"sheet":"4. Equipment_Other Detail","index":3,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,1],[2,0,2,1]]}
["Kenosha County Department of Human Services Budget Worksheet #4 - Other Costs and Equipment Detail",null,"Version: 2024"]
["Agency Name",{"$f":"+'1. FTE & Salary Allocation'!$B$2","v":0}]
["NOTE:  For the Room & Board component of the contracted daily rate, the Purchaser will pay the provider's bugeted amount up to a maximum of $21.50 per day.  If a budget is submitted with Room & Board costs higher than $21.50 per day, the Purchaser reserves the right to subtract the excess amount from the total proposed daily rate to establish the contracted daily rate."]
["Please enter all information as indicated by BLUE font color and BLUE shaded area."]
[]
[]
[]
[]
["Provide detailed explanation below","List Detail of Other Services"]
["List Other Costs from Worksheet 3:",{"$f":"+'1. FTE & Salary Allocation'!C8","v":"Enter Program Name Here"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total",{"$f":"SUM(B11:B19)","v":0}]
["List Equipment over $500 AND a useful life of more than 1 year:"]
[]
[]
[]
[]
[]
[]
["Total ",{"$f":"SUM(B22:B27)","v":0}]

{"sheet":"5. Budget Narrative","index":4,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,1,1,8],[2,0,2,8],[5,0,5,8],[7,0,7,8]]}
["Kenosha County Department of Human Services Budget Worksheet #5 - Narrative",null,null,null,null,null,null,null,null,"Version: 2024"]
["Agency Name"]
["NOTE:  For the Room & Board component of the contracted daily rate, the Purchaser will pay the provider's budgeted amount up to a maximum of $24.00 per day.  If a budget is submitted with Room & Board costs higher than $24.00 per day, the Purchaser reserves the right to subtract the excess amount from the total proposed daily rate to establish the contracted daily rate."]
["Please enter all information as indicated by BLUE font color and BLUE shaded area."]
[]
["1.  Provide information for reviewers to determine the reasonableness of the costs included in the budget.  For example, indicate which salaries are higher due to staff education or experience levels.  If current Kenosha County provider, comment on significant increases or decreases of line item expenses from previous year."]
[]
["2.  If administration allocation is included in Budget Worksheet #3, please indicate the basis by which these costs are allocated to this proposal."]
[]
["To enter budget narrative below, click once inside the box and begin typing."]