{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Service List Tables","A) Total Agency Budget ","B)2020 Budget Wksht (15% Match)","B)2020 Budget Wksht (25% Match)"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":10,"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":"Instructions","index":0,"n_rows":63,"n_cols":1,"rows_kept":63,"cut":false,"hidden":false,"merged":[[1,0,1,8],[2,0,2,8],[3,0,3,8],[4,0,4,8],[6,0,6,8],[24,0,24,8],[7,0,7,8],[8,0,8,8],[9,0,9,8],[56,0,56,8],[26,0,26,8],[31,0,31,8],[32,0,32,8],[33,0,33,8],[34,0,34,8],[35,0,35,8],[36,0,36,8],[50,0,50,8],[37,0,37,8],[39,0,39,8],[40,0,40,8],[48,0,48,8],[49,0,49,8],[59,0,59,8],[60,0,60,8],[62,0,62,8],[58,0,58,8],[57,0,57,8],[61,0,61,8],[55,0,55,8],[51,0,51,8],[52,0,52,8],[53,0,53,8],[54,0,54,8],[27,0,27,8],[45,0,45,8],[46,0,46,8],[47,0,47,8],[41,0,41,8],[43,0,43,8],[28,0,28,8],[29,0,29,8],[42,0,42,8],[38,0,38,8],[44,0,44,8],[0,0,0,8],[10,0,10,8],[30,0,30,8],[25,0,25,8],[5,0,5,8],[11,0,11,8],[12,0,12,8],[13,0,13,8],[14,0,14,8],[15,0,15,8],[16,0,16,8],[17,0,17,8],[18,0,18,8],[19,0,19,8],[21,0,21,8],[22,0,22,8]]}
["Attachment 1"]
["The Budget Worksheets are in Microsoft Excel format, and must be completed using Excel. "]
["A)  Total Agency Budget for Current Year- Attachment 1A"]
["·         Enter the Biddder’s name on the worksheet. "]
["·         Enter the time period covered by the fiscal year budget."]
["●         Bidders are required to input data in Columns 1-3, rows 1-13 and 15-33 "]
["B)  2020 Budget Worksheet - Attachment 1B"]
["Complete a separate 2020 Budget Worksheet for each service that your agency is applying for.  Use the 15% Match Tab for the following services: Congregate Nutrition Service, Home Delivered Meals - Clermont CO, Legal Assistance, Ombudsman, Evidence - Based Health Edu, Recreation, Supportive Services & Transportation.  Use the 25% Match Tab for the following services:  Adult Day Service - Clermont Co, Alzheimer's Education, Caregivers Services - FCSP Support Group, Caregivers Services - FCSP Caregiver Training, Caregivers Services - Counseling, and Personal Care."]
["●         Enter the Bidder’s name "]
["●         Select the service from the drop down menu for which you are requesting funding "]
["Expenses"]
["1)  Column 1: Total Direct Expenses - (Rows 1-19) Identify the actual direct costs associated with the service."]
["·    Direct program expenses are those expenses that are associated directly with providing a particular COA funded Title III/State service to the clients."]
["·    Volunteers’ time should be computed and reported as an expense on Line 2 and as revenue on Line 25. Volunteer services must be documented and, to the extent feasible, supported by the same methods used for employees. Rates for volunteers should be consistent with those paid for similar work within the organization or the community. Volunteer efforts are to be offset with recognition of Volunteer revenue therefore Line 2 and Line 25 must equal."]
["2)  Column 2: Total Indirect Expenses - (Rows 1-19) Identify the total indirect costs associated with the service. Indirect Expenses are expenses that have been incurred for common or joint objectives that cannot be readily identified with a particular service (i.e. administration and general activities).  "]
["·   Indirect expenses may be assigned to the Title III/State funded services and other programs by one of the methods described in OMB Circular A-122. The following are two methods commonly used:  "]
["(a) Direct allocation method – The overhead costs are charged directly to the categories, or are prorated individually, using a base most appropriate to the particular cost being prorated. It is important to insure that the allocation is accurately reflecting the benefit provided to each activity by the particular costs. This method is acceptable only for the allocation of general administration and general expenses."]
[" (b) Simplified allocation method – Where the categories and programs benefit from the indirect cost to approximately the same degree, the allocation of indirect costs may be accomplished by the following method. It is acceptable to identify the total Management and General expenses in the “Total” column and divide by an equitable distribution base, such as total direct costs, direct salaries, or another base, which results in an equitable distribution, to arrive at an allocation percentage."]
["·         If your total indirect cost rate (on line 40) is greater than 20%, include specific justification on line 41. "]
["·         Include on line 43 a brief narrative on your method of indirect cost allocation."]
[]
["If your organization uses other methods and wishes to provide existing documentation for support of overhead charges, submit your request via e-mail to provider_services@help4seniors.org ."]
["3)  Column 3: Total Program Expenses - Total Program Expense is an automatic calculation of Total Direct Expense plus Total Indirect Expense. No data entry is required. "]
[]
["The Indirect Cost Allocation formula located in column 3 row 20 is an automatic calculation that may be overridden, if the simplified allocation method is used to determine Total Indirect Cost."]
["Revenue "]
["1)  Revenue - (Rows 22-29) The Revenue section is used to report all the sources of revenue that will be used to support the Title III/State funded services.   The total on Line 25 - Volunteers should be equal to the volunteer expense reported on Line 2."]
["2)  Total Funding Requested from COA - Enter on Line 31 the actual amount of requested funding for the service."]
["3)  Total Revenue - Line 32 should be equal to the total expenses on Line 21."]
["4)  Estimated Units of Service -  Enter on Line 33 the estimated units of service for the 2020 program year. The 2020 program year covers 9 months from January 1-September 30, 2020. ; however, your request should be based on 12 months.  Only 75% of your request will be funded in Year 1. "]
["5)  Required Match - Row 38 is an automatic calculation based on the required match percentage defined in (a), (b) and (c) below. "]
["(a) The programs listed below require a minimum 15% match of total program costs by either allowable in-kind contributions or non-federal cash for the services listed below. To compute the 15% required match, take the Title III/State funds requested (Line 31) for the service and divide by 85%. Take that total and multiply by 15%."]
["Congregate Nutrition Service "]
["Home Delivered Meals (Clermont County)"]
["Legal Assistance"]
["Ombudsman"]
["Transportation"]
["Supportive Services"]
["Evidence-Based Health Education "]
["Recreation"]
["(b) The programs listed below require a minimum 25% match of total program costs by either allowable in-kind contributions or non-federal cash for the services listed below. To compute the 25% required match, take the Title III/State funds requested (Line 31) for the service and divide by 75%. Take that total and multiply by 25%."]
["Respite - Adult Day Services (Clermont County)"]
["Respite - Personal Care (Clermont County) "]
["Caregiver Services - FSCP Support Group"]
["Caregiver Services - FSCP Counseling"]
["Alzheimer Education"]
["(c) Match is defined as any eligible resource that is used to enhance Title III/State funded service delivery and can be in the form of non-federal cash or in-kind contributions. Other programs, such as PASSPORT, that purchase whole units should not be reported as Local Match and are not to be counted as Title III/State funded units."]
["·         Three types of resources cannot be used as match:"]
["─ any other Federal dollars (unless specifically authorized by that program)"]
["─ resources used to match other Federal dollars"]
["─Title III/State funded program income"]
["·         Matches from in-kind contributions must:  "]
["─be supported with documentation;"]
["─directly enhance the Title III/State funded service (i.e. a volunteer bingo caller cannot be used to match a Title III/State funded nutrition program);"]
["─have a rate consistent with that ordinarily paid for the goods or services (minimum wage is used to value volunteer hours where no specialized skill is required)."]
["·         Answer the questions that apply on lines 42 - 50."]
["Allowable Cost Guidelines"]
["To be allowable under an award the costs must be:"]
["·         reasonable, applied consistently, and documented; "]
["·         consistent in policies and procedures with other activities of the organization and determined in accordance with generally accepted accounting principles;"]
["·         related to/benefit the program and not included in any other federally financed program."]
[]
["The following is a list of various expenses illustrating possible costs that should be included on the Budget: Revenue and Expenses pages, and/or those that must be excluded. It is not meant to be inclusive of all costs that may be allowed/disallowed. Most of these items have additional discussion in the “Cost Principles for Non-Profit Organizations” OMB Circular number A-122, or the applicable cost principles for your organization."]

{"sheet":"Service List Tables","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["15% Match",null,"25% Match"]
["Congregate Nutrition Service",null,"Adult Day Services -Clermont Co."]
["Evidence-Based Health Education",null,"Alzheimer's Education"]
["Home Delivered Meals - Clermont County",null,"Caregiver Services - FCSP Caregiver Training"]
["Legal Assistance",null,"Caregiver Services - FCSP Counseling"]
["Ombudsman",null,"Caregiver Services - FCSP Support Group"]
["Recreation",null,"Personal Care (Clermont County)"]
["Supportive Services"]
["Transportation"]

{"sheet":"A) Total Agency Budget ","index":2,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[[25,1,25,7],[49,1,49,7],[50,1,50,7],[0,0,0,7],[23,1,23,3],[2,2,3,7],[2,0,3,1],[5,0,5,1],[5,2,5,7],[9,1,9,7]]}
[" Appendix C - Total Agency Budget for Current Fiscal Year"]
[]
["Applicant Name:"]
[]
[]
["Time Period:"]
[]
[null,null,null,null,"Budget for Current FY","Year-to-Date Budget","Year-to-Date Actual","Variance"]
[null,null,null,null,"(Column 1)","(Column 2)","(Column 3)","(Column 4)"]
[null,"Revenue/Support"]
[1,"Govt. grants/contracts/per diem (identify)",null,null,null,null,null,{"$f":"G11/F11","v":{"$error":"#DIV/0!"}}]
[2,"Corporate Grants",null,null,null,null,null,{"$f":"G12/F12","v":{"$error":"#DIV/0!"}}]
[3,"Foundation Grants",null,null,null,null,null,{"$error":"#DIV/0!"}]
[4,"Contributions",null,null,null,null,null,{"$error":"#DIV/0!"}]
[5,"United Way",null,null,null,null,null,{"$error":"#DIV/0!"}]
[6,"Other Federated Campaigns (identify)",null,null,null,null,null,{"$error":"#DIV/0!"}]
[7,"Special Events/Fundraisers",null,null,null,null,null,{"$error":"#DIV/0!"}]
[8,"Membership dues",null,null,null,null,null,{"$error":"#DIV/0!"}]
[9,"Sponsorships ",null,null,null,null,null,{"$error":"#DIV/0!"}]
[10,"Admissions",null,null,null,null,null,{"$error":"#DIV/0!"}]
[11,"Sales to the public",null,null,null,null,null,{"$error":"#DIV/0!"}]
[12,"Investment Income",null,null,null,null,null,{"$error":"#DIV/0!"}]
[13,"Other (identify)",null,null,null,null,null,{"$error":"#DIV/0!"}]
[14,"Total Revenue/Support",null,null,{"$f":"SUM(E11:E23)","v":0},{"$f":"SUM(F11:F23)","v":0},{"$f":"SUM(G11:G23)","v":0},{"$error":"#DIV/0!"}]
[]
[null,"Expenses"]
[15,"Salaries",null,null,null,null,null,{"$f":"G27/F27","v":{"$error":"#DIV/0!"}}]
[16,"Employee Benefits",null,null,null,null,null,{"$error":"#DIV/0!"}]
[17,"Payroll Taxes",null,null,null,null,null,{"$error":"#DIV/0!"}]
[18,"Travel",null,null,null,null,null,{"$error":"#DIV/0!"}]
[19,"Training, Staff Development",null,null,null,null,null,{"$error":"#DIV/0!"}]
[20,"Conferences & Meetings",null,null,null,null,null,{"$error":"#DIV/0!"}]
[21,"Supplies",null,null,null,null,null,{"$error":"#DIV/0!"}]
[22,"Postage/Delivery",null,null,null,null,null,{"$error":"#DIV/0!"}]
[23,"Telephone",null,null,null,null,null,{"$error":"#DIV/0!"}]
[24,"Printing and Publications",null,null,null,null,null,{"$error":"#DIV/0!"}]
[25,"Professional and Consulting Fees",null,null,null,null,null,{"$error":"#DIV/0!"}]
[26,"Legal",null,null,null,null,null,{"$error":"#DIV/0!"}]
[27,"Membership Fees",null,null,null,null,null,{"$error":"#DIV/0!"}]
[28,"Insurance Premiums",null,null,null,null,null,{"$error":"#DIV/0!"}]
[29,"Occupancy",null,null,null,null,null,{"$error":"#DIV/0!"}]
[30,"Minor Equipment <$2,000",null,null,null,null,null,{"$error":"#DIV/0!"}]
[31,"Equipment Repair",null,null,null,null,null,{"$error":"#DIV/0!"}]
[32,"Depreciation",null,null,null,null,null,{"$error":"#DIV/0!"}]
[33,"Miscellaneous Expenses",null,null,null,null,null,{"$error":"#DIV/0!"}]
[34,"Total Expenses",null,null,{"$f":"SUM(E27:E45)","v":0},{"$f":"SUM(F27:F45)","v":0},{"$f":"SUM(G27:G45)","v":0},{"$error":"#DIV/0!"}]
[]
[35,"Revenue less Expenses",null,null,{"$f":"E24-E46","v":0},{"$f":"F24-F46","v":0},{"$f":"G24-G46","v":0},{"$error":"#DIV/0!"}]
[]
[36,"If expenses exceed revenues/support, provide a brief explaination of how the difference will be offset:"]

{"sheet":"B)2020 Budget Wksht (15% Match)","index":3,"n_rows":1002,"n_cols":27,"rows_kept":1002,"cut":false,"hidden":false,"merged":[[72,0,72,1],[65,0,65,1],[67,0,67,1],[73,0,74,1],[73,2,73,5],[74,2,74,5],[68,0,69,1],[68,2,68,5],[69,2,69,5],[70,0,70,1],[71,0,71,1],[62,0,62,1],[63,0,64,1],[63,2,63,5],[64,2,64,5],[59,2,59,3],[60,0,61,1],[60,2,60,5],[61,2,61,5],[56,0,56,1],[57,0,57,1],[58,0,58,1],[59,0,59,1],[52,0,52,5],[54,0,54,1],[55,0,55,1],[48,0,48,1],[48,2,48,4],[49,0,49,1],[50,0,50,1],[50,2,50,4],[45,0,45,1],[46,0,46,1],[46,2,46,4],[47,0,47,1],[43,0,43,1],[43,2,43,4],[44,0,44,1],[44,2,44,4],[40,0,40,1],[41,0,41,1],[41,2,41,4],[42,0,42,1],[38,0,38,1],[38,2,38,4],[39,0,39,1],[39,2,39,4],[36,0,36,1],[36,2,36,4],[37,0,37,1],[37,2,37,4],[34,0,34,1],[34,2,34,4],[35,0,35,1],[35,2,35,4],[32,0,32,1],[32,2,32,4],[33,0,33,1],[33,2,33,4],[28,0,28,1],[29,0,29,1],[29,2,29,4],[31,2,31,5],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[14,0,14,1],[15,0,15,1],[0,0,0,6],[2,0,3,1],[2,2,4,2],[2,4,4,5],[16,0,16,1],[12,0,12,1],[13,0,13,1],[6,2,6,5],[9,0,9,1],[10,0,10,1],[11,0,11,1]]}
[" Appendix C - 2020 Budget"]
[]
["Applicant Name:",null,null,"Service:","Congregate Nutrition Service"]
[]
[]
[]
[null,null,"Expenses"]
[null,null,null,"Total Direct","Total Indirect ","Total Program"]
[null,null,null,"(Column 1)","(Column 2)","(Column 3)"]
[1,null,"Staff Salaries & Wages",null,null,{"$f":"SUM(D10:E10)","v":0}]
[2,null,"Volunteers",null,null,{"$f":"SUM(D11:E11)","v":0}]
[3,null,"Payroll Taxes",null,null,0]
[4,null,"Fringe Benefits",null,null,0]
[5,null,"Professional and Consultant Fees",null,null,0]
[6,null,"Staff Travel",null,null,0]
[7,null,"Training Expense",null,null,0]
[8,null,"Postage",null,null,0]
[9,null,"Office Supplies",null,null,0]
[10,null,"Program Supplies",null,null,0]
[11,null,"Food Supplies",null,null,0]
[12,null,"Maintenance",null,null,0]
[13,null,"Insurance",null,null,0]
[14,null,"Occupancy / Rent",null,null,0]
[15,null,"Printing",null,null,0]
[16,null,"Communication",null,null,0]
[17,null,"Minor Equipment Cost",null,null,0]
[18,null,"Other (Specify)",null,null,0]
[19,null,"Depreciation",null,null,0]
[20,null,"Total Expense",{"$f":"SUM(D10:D28)","v":0},{"$f":"SUM(E10:E28)","v":0}]
[21,null,"Total Program Expense",null,null,{"$f":"SUM(F10:F28)","v":0}]
[]
[null,null,"Revenue"]
[22,null,"United Way"]
[23,null,"Foundations"]
[24,null,"All Other Local Cash"]
[25,null,"Volunteers"]
[26,null,"All Other (In-Kind)"]
[27,null,"Program Income"]
[28,null,"Other State"]
[29,null,"Other Federal"]
[]
[30,null,"Total Other Revenue",null,null,{"$f":"SUM(F33:F40)","v":0}]
[]
[31,null,"Total Funding Requested from COA"]
[32,null,"Total Revenue",null,null,{"$f":"+F42+F44","v":0}]
[]
[33,null,"Estimated Units of Service"]
[]
[34,null,"Total Unit Rate=Total Program Expense/Estimated Units of Service (line 21/line 33)",null,null,{"$f":"IF(F47>0,(F30/F47),\"\")","v":""}]
[]
[35,null,"Unit Reimbursement Rate=Total Requested from COA/Estimated Units of Service (line 31/line 33)",null,null,{"$f":"IF(F47>0,(F44/F47),\"\")","v":""}]
[]
["Budget Worksheet Review"]
[null,null,null,null,"Balance","Status"]
[36,null,"Volunteer Expense vs. Volunteer Revenue",null,{"$f":"IF(F11=F36,\"-\",(F36-F11))","v":"-"},{"$f":"IF(E55=\"-\",\"Balanced\",(IF(E55<0,\"Revenue Deficit\",\"Revenue Surplus\")))","v":"Balanced"}]
[37,null,"Difference and Status of Revenue vs. Expenses",null,{"$f":"IF(F30=F45,\"-\",(F45-F30))","v":"-"},{"$f":"IF(E56=\"-\",\"Balanced\",(IF(E56<0,\"Revenue Deficit\",\"Revenue Surplus\")))","v":"Balanced"}]
[38,null,"Required Match",null,{"$f":"(F44/0.85)*0.15","v":0}]
[39,null,"Total Proposed Match (sum of lines 22-26)",null,{"$f":"+F33+F34+F35+F36+F37","v":0},{"$f":"IF(E58>=E57,\"Adequate Match\",\"Inadequate Match\")","v":"Adequate Match"}]
[]
[40,null,"Percentage of Indirect Cost",null,{"$f":"IF($E29>0,(E29/$F30),\"\")","v":""},"%"]
[41,null,"If line 40 is greater than 20%, provide a brief explaination:"]
[]
[42,null,"Indirect expense allocation method"]
[43,null,"Brief explanation of indirect cost allocation method:"]
[]
[44,null,"Is a budget change anticipated in the next two years?"]
[null,null,"If the answer to question 44 is Yes, answer questions 45-50."]
[45,null,"Is a gap in service anticipated?"]
[46,null,"Brief explanation of the cause and length of gap in service:"]
[]
[47,null,"Is the ratio of volunteers to employees expected to:"]
[48,null,"Current ratio of volunteers to employees",null,null,0]
[49,null,"Projected ratio of volunteers to employees",null,null,0]
[50,null,"Brief explanation for the change in ratio of volunteers to employees:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Congregate Nutrition Service"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Home Delivered Meals - Clermont County"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Legal Assistance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ombudsman"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Evidence-Based Health Education"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recreation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supportive Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transportation"]

{"sheet":"B)2020 Budget Wksht (25% Match)","index":4,"n_rows":1003,"n_cols":27,"rows_kept":1003,"cut":false,"hidden":false,"merged":[[70,0,70,1],[71,0,71,1],[72,0,72,1],[73,0,74,1],[73,2,73,5],[74,2,74,5],[68,0,69,1],[68,2,68,5],[69,2,69,5],[59,0,59,1],[59,2,59,3],[60,0,61,1],[60,2,60,5],[61,2,61,5],[62,0,62,1],[63,0,64,1],[63,2,63,5],[64,2,64,5],[65,0,65,1],[67,0,67,1],[58,0,58,1],[47,0,47,1],[48,0,48,1],[48,2,48,4],[49,0,49,1],[50,0,50,1],[50,2,50,4],[52,0,52,5],[54,0,54,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[46,0,46,1],[46,2,46,4],[39,0,39,1],[39,2,39,4],[40,0,40,1],[41,0,41,1],[41,2,41,4],[42,0,42,1],[43,0,43,1],[43,2,43,4],[44,0,44,1],[44,2,44,4],[45,0,45,1],[36,0,36,1],[36,2,36,4],[37,0,37,1],[37,2,37,4],[38,0,38,1],[38,2,38,4],[33,0,33,1],[33,2,33,4],[34,0,34,1],[34,2,34,4],[35,0,35,1],[35,2,35,4],[28,0,28,1],[29,0,29,1],[29,2,29,4],[31,2,31,5],[32,0,32,1],[32,2,32,4],[27,0,27,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[15,0,15,1],[0,0,0,6],[2,0,3,1],[2,2,4,2],[2,4,4,5],[6,2,6,5],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1]]}
[" Appendix C - 2020 Budget"]
[]
["Applicant Name:",null,null,"Service:","Adult Day Services -Clermont Co."]
[]
[]
[]
[null,null,"Expenses"]
[null,null,null,"Total Direct","Total Indirect ","Total Program"]
[null,null,null,"(Column 1)","(Column 2)","(Column 3)"]
[1,null,"Staff Salaries & Wages",null,null,{"$f":"SUM(D10:E10)","v":0}]
[2,null,"Volunteers",null,null,{"$f":"SUM(D11:E11)","v":0}]
[3,null,"Payroll Taxes",null,null,0]
[4,null,"Fringe Benefits",null,null,0]
[5,null,"Professional and Consultant Fees",null,null,0]
[6,null,"Staff Travel",null,null,0]
[7,null,"Training Expense",null,null,0]
[8,null,"Postage",null,null,0]
[9,null,"Office Supplies",null,null,0]
[10,null,"Program Supplies",null,null,0]
[11,null,"Food Supplies",null,null,0]
[12,null,"Maintenance",null,null,0]
[13,null,"Insurance",null,null,0]
[14,null,"Occupancy / Rent",null,null,0]
[15,null,"Printing",null,null,0]
[16,null,"Communication",null,null,0]
[17,null,"Minor Equipment Cost",null,null,0]
[18,null,"Other (Specify)",null,null,0]
[19,null,"Depreciation",null,null,0]
[20,null,"Total Expense",{"$f":"SUM(D10:D28)","v":0},{"$f":"SUM(E10:E28)","v":0}]
[21,null,"Total Program Expense",null,null,{"$f":"SUM(F10:F28)","v":0}]
[]
[null,null,"Revenue"]
[22,null,"United Way"]
[23,null,"Foundations"]
[24,null,"All Other Local Cash"]
[25,null,"Volunteers"]
[26,null,"All Other (In-Kind)"]
[27,null,"Program Income"]
[28,null,"Other State"]
[29,null,"Other Federal"]
[]
[30,null,"Total Other Revenue",null,null,{"$f":"SUM(F33:F40)","v":0}]
[]
[31,null,"Total Funding Requested from COA"]
[32,null,"Total Revenue",null,null,{"$f":"+F42+F44","v":0}]
[]
[33,null,"Estimated Units of Service"]
[]
[34,null,"Total Unit Rate=Total Program Expense/Estimated Units of Service (line 21/line 33)",null,null,{"$f":"IF(F47>0,(F30/F47),\"\")","v":""}]
[]
[35,null,"Unit Reimbursement Rate=Total Requested from COA/Estimated Units of Service (line 31/line 33)",null,null,{"$f":"IF(F47>0,(F44/F47),\"\")","v":""}]
[]
["Budget Worksheet Review"]
[null,null,null,null,"Balance","Status"]
[36,null,"Volunteer Expense vs. Volunteer Revenue",null,{"$f":"IF(F11=F36,\"-\",(F36-F11))","v":"-"},{"$f":"IF(E55=\"-\",\"Balanced\",(IF(E55<0,\"Revenue Deficit\",\"Revenue Surplus\")))","v":"Balanced"}]
[37,null,"Difference and Status of Revenue vs. Expenses",null,{"$f":"IF(F30=F45,\"-\",(F45-F30))","v":"-"},{"$f":"IF(E56=\"-\",\"Balanced\",(IF(E56<0,\"Revenue Deficit\",\"Revenue Surplus\")))","v":"Balanced"}]
[38,null,"Required Match",null,{"$f":"(F44/0.75)*0.25","v":0}]
[39,null,"Total Proposed Match (sum of lines 22-26)",null,{"$f":"+F33+F34+F35+F36+F37","v":0},{"$f":"IF(E58>=E57,\"Adequate Match\",\"Inadequate Match\")","v":"Adequate Match"}]
[]
[40,null,"Percentage of Indirect Cost",null,{"$f":"IF($E29>0,(E29/$F30),\"\")","v":""}]
[41,null,"If line 40 is greater than 20%, provide a brief explaination:"]
[]
[42,null,"Indirect expense allocation method"]
[43,null,"Brief explanation of indirect cost allocation method:"]
[]
[44,null,"Is a budget change anticipated in the next two years?"]
[null,null,"If the answer to question 44 is Yes, answer questions 45-50."]
[45,null,"Is a gap in service anticipated?"]
[46,null,"Brief explanation of the cause and length of gap in service:"]
[]
[47,null,"Is the ratio of volunteers to employees expected to:"]
[48,null,"Current ratio of volunteers to employees",null,null,0]
[49,null,"Projected ratio of volunteers to employees",null,null,0]
[50,null,"Brief explanation for the change in ratio of volunteers to employees:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adult Day Services -Clermont Co."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alzheimer's Education"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caregiver Services - FCSP Support Group"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caregiver Services - FCSP Caregiver Training"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caregiver Services - FCSP Counseling"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personal Care (Clermont County)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33]