{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Budget Narrative","SubGrantee Budget","Cost Per Client"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":33,"n_cols":3,"rows_kept":33,"cut":false,"hidden":false,"merged":[[11,0,11,1],[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[23,0,23,1],[28,0,28,1],[29,1,32,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,1,17,1],[18,0,18,1]]}
["Program Budget Instructions"]
["·         Please enter into cells that are highlighted orange. >>>",null,"Example"]
["·         All line item amounts must be entered as WHOLE DOLLARS."]
["·         If no funds are budgeted for a line item, leave it blank.  "]
["·         Column B: Please complete Column B for a 12-month period."]
["·         Column C: The amount listed must reflect the expected amounts from other funding sources, other than COA, for the annual 12-month contract period."]
["·         Calculate and check all subtotals and totals, including the percentages by funding source at the bottom, and ensure all line item amounts, subtotals, and totals are in WHOLE DOLLARS and are correct."]
["·         Cost per Client Calculation: Add the number of total clients projected to be served in a 12-month period in cell B7"]
["Budget Narrative Instructions"]
["·         For every budget line containing a requested amount of City of Austin funding, enter a short description or list of items included in that budget line.  "]
["·         Do not enter narrative for budget lines that are blank or budgeted amounts from Other Funding."]
["Funding Summary Instructions"]
["·         Include the funding source, grant/contract name (if applicable), and ANNUAL amount of all funding including the requested City of Austin funding in the table. Use totals for the 12-month period."]
["·         The totals in this form should match the total shaded in yellow in the Program Budget and Narrative Form \"Total Budget All Funding Sources Column\" which includes Requested CITY OF AUSTIN Amount and ALL OTHER Sources."]
["Budget Line Items Instructions"]
["A. Personnel"]
["Salaries","These line items included in Personnel includes Salaries plus Fringe and Payroll Taxes."]
["Fringe and Payroll Taxes"]
["B. Operations"]
["General Operating Expenses","Include all operating expenses which are NOT included in any other line item).  Examples are any travel/training/conferences WITHIN Travis County, insurance/bonding, equipment costing less than $5,000 per item, general office supplies, rent, utilities, telecommunications, postage, program supplies, software licenses such as HMIS. Food that benefit a group of clients such as food for meetings, foodbank and commercial kitchen meals (shelter or community meals) should be included here."]
["Outsourced Professional Services","Include any sub-agreements/sub-contracts made with an individual or company which provides a service such as with a consulting, accounting or auditing, or translation/interpretation and language access services. This includes sign language interpretation. Sub-agreements/sub-contracts with individuals or agencies to provide client services that do not contribute to the unduplicated client count in your proposed performance measures should be included here. "]
["Supplemental Programmatic Services","Include any sub-agreements/sub-contracts made with an individual or company that is providing program or direct client services, but do not have unique clients that contribute to the program in the RFGA proposed performance measures. These services will be supplemental services provided to your program clients. "]
["Training/Travel Outside Austin and/or Travis Count","Include any necessary training that will take place outside Austin and/or Travis County."]
["C. Assistance to Clients"]
["Rental/Mortgage Assistance","Rental payments and arrears, mortgage payments or assistance. "]
["General Housing Assistance","Assistance related to obtaining housing OTHER THAN Rent/Mortgage such as utility payments and arrears, housing application deposits. "]
["Direct Client Assistance","Assistance to clients not related to obtaining housing that benefit an individual in the program such as clothing, bus passes, child care, transportation assistance, incentives."]
["Client Food and Beverage","Food and Beverages for clients such as groceries, and food assistance that benefits an individual in the program.  Food that benefit a group of clients such as food for meetings, foodbank and commercial kitchen meals (shelter or community meals) should be included in General Operations."]
["D. Subgrantees/Sub-recipients"]
["Personnel-Sub","In the case that the organization will be sub-contracting, the Lead Agency would assume full responsibility for paying sub-grantees/sub-recipients with City funds.  These categories are for costs associated with sub-grantees/sub-recipients with individuals or agencies to provide client services that contribute to the unduplicated client count in the RFGA proposed performance measures. These clients would be unique clients brought in from the sub-grantee, separate from the clients of the Lead Agency, but the clients would contribute to the overall number of clients served.  "]
["Operations-Sub"]
["Direct Client Assistance-Sub"]
["Other-Sub"]

{"sheet":"Budget Narrative","index":1,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[23,4,23,6],[25,4,25,6],[27,4,27,6],[26,4,26,6],[24,4,24,6],[5,0,5,3],[21,4,21,6],[22,4,22,6],[13,4,13,6],[14,4,14,6],[16,4,16,6],[17,4,17,6],[7,4,7,6],[9,4,9,6],[11,4,11,6],[18,4,18,6],[20,4,20,6],[12,4,12,6]]}
["Form 3 - Program Budget and Narrative"]
["Agency Name:"]
["Program Name:"]
["Total Proposed Clients Served:"]
[]
["Instruction: Applicants must identify all funding requested in the budget below. The completed Detailed Budget will be reviewed by evaluators.  Funds requested should correspond to the activities and services proposed in the application narrative. If awarded, funds may be transferred between line items."]
[]
["Budget Line-Item","Requested COA Funding Initial 12 months","Amounts Funded by ALL OTHER Sources for the SAME program 12 months","Total Budget (All Funding Sources) 12-Months","Complete an explanation for each City-funded line item."]
["Salaries"]
["Personnel (benefits and payroll taxes)",null,null,{"$f":"SUM(B10:C10)","v":0}]
["Operations"]
["General Operations",null,null,{"$f":"SUM(B12:C12)","v":0}]
["Outsourced Professional Services",null,null,{"$f":"SUM(B13:C13)","v":0}]
["Supplemental Programmatic Services",null,null,0]
["Training/Travel Outside of Austin/Travis County",null,null,0]
["Financial Assistance to Clients",null,null,{"$f":"SUM(B16:C16)","v":0}]
["Rental Assistance",null,null,{"$f":"SUM(B17:C17)","v":0}]
["General Housing Assistance",null,null,{"$f":"SUM(B18:C18)","v":0}]
["Direct Client Assistance",null,null,0]
["Sub-Grantees - Use SubGrantee Budget worksheet to enter amounts (If applicable)"]
["Sub-Grantee Personnel",{"$f":"SUM('SubGrantee Budget'!G7,'SubGrantee Budget'!G11,'SubGrantee Budget'!G15,'SubGrantee Budget'!G19,'SubGrantee Budget'!G23,'SubGrantee Budget'!G27,'SubGrantee Budget'!G31,'SubGrantee Budget'!G35,'SubGrantee Budget'!G39)","v":0},{"$f":"SUM('SubGrantee Budget'!H7,'SubGrantee Budget'!H11,'SubGrantee Budget'!H15,'SubGrantee Budget'!H19,'SubGrantee Budget'!H23,'SubGrantee Budget'!H27,'SubGrantee Budget'!H31,'SubGrantee Budget'!H35,'SubGrantee Budget'!H39)","v":0},{"$f":"SUM(B21:C21)","v":0}]
["Sub-Grantee Operations",{"$f":"SUM('SubGrantee Budget'!G8,'SubGrantee Budget'!G12,'SubGrantee Budget'!G16,'SubGrantee Budget'!G20,'SubGrantee Budget'!G24,'SubGrantee Budget'!G28,'SubGrantee Budget'!G32,'SubGrantee Budget'!G36,'SubGrantee Budget'!G40)","v":0},{"$f":"SUM('SubGrantee Budget'!H8,'SubGrantee Budget'!H12,'SubGrantee Budget'!H16,'SubGrantee Budget'!H20,'SubGrantee Budget'!H24,'SubGrantee Budget'!H28,'SubGrantee Budget'!H32,'SubGrantee Budget'!H36,'SubGrantee Budget'!H40)","v":0},{"$f":"SUM(B22:C22)","v":0}]
["Sub-Grantee Direct Assistance",{"$f":"SUM('SubGrantee Budget'!G9,'SubGrantee Budget'!G13,'SubGrantee Budget'!G17,'SubGrantee Budget'!G21,'SubGrantee Budget'!G25,'SubGrantee Budget'!G29,'SubGrantee Budget'!G33,'SubGrantee Budget'!G37,'SubGrantee Budget'!G41)","v":0},{"$f":"SUM('SubGrantee Budget'!H9,'SubGrantee Budget'!H13,'SubGrantee Budget'!H17,'SubGrantee Budget'!H21,'SubGrantee Budget'!H25,'SubGrantee Budget'!H29,'SubGrantee Budget'!H33,'SubGrantee Budget'!H37,'SubGrantee Budget'!H41)","v":0},0]
["Sub-Grantee Other",{"$f":"SUM('SubGrantee Budget'!G10,'SubGrantee Budget'!G14,'SubGrantee Budget'!G18,'SubGrantee Budget'!G22,'SubGrantee Budget'!G26,'SubGrantee Budget'!G30,'SubGrantee Budget'!G34,'SubGrantee Budget'!G38,'SubGrantee Budget'!G42)","v":0},{"$f":"SUM('SubGrantee Budget'!H10,'SubGrantee Budget'!H14,'SubGrantee Budget'!H18,'SubGrantee Budget'!H22,'SubGrantee Budget'!H26,'SubGrantee Budget'!H30,'SubGrantee Budget'!H34,'SubGrantee Budget'!H38,'SubGrantee Budget'!H42)","v":0},0]
["Program Income"]
["Program Income",null,null,0]
["Other"]
["Other",null,null,{"$f":"SUM(B28:C28)","v":0}]
["Total:",{"$f":"SUM(B10,B12,B13,B14,B15,B17,B18,B19,B21,B22,B23,B24,B26,B28)","v":0},{"$f":"SUM(C10,C12,C13,C14,C15,C17,C18,C19,C21,C22,C23,C24,C26,C28)","v":0},{"$f":"SUM(D10,D12,D13,D14,D15,D17,D18,D19,D21,D22,D23,D24,D26,D28)","v":0}]

{"sheet":"SubGrantee Budget","index":2,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[6,0,9,0],[6,1,9,1],[6,2,9,2],[6,3,9,3],[6,4,9,4],[14,0,17,0],[14,1,17,1],[14,2,17,2],[14,3,17,3],[14,4,17,4],[10,0,13,0],[10,1,13,1],[10,2,13,2],[10,3,13,3],[10,4,13,4],[18,0,21,0],[18,1,21,1],[18,2,21,2],[18,3,21,3],[18,4,21,4],[26,0,29,0],[26,1,29,1],[26,2,29,2],[26,3,29,3],[26,4,29,4],[22,0,25,0],[22,1,25,1],[22,2,25,2],[22,3,25,3],[22,4,25,4],[30,0,33,0],[30,1,33,1],[30,2,33,2],[30,3,33,3],[30,4,33,4],[34,0,37,0],[34,1,37,1],[34,2,37,2],[34,3,37,3],[34,4,37,4],[38,0,41,0],[38,1,41,1],[38,2,41,2],[38,3,41,3],[38,4,41,4]]}
[{"$f":"'Budget Narrative'!A1","v":"Form 3 - Program Budget and Narrative"}]
[{"$f":"'Budget Narrative'!A2","v":"Agency Name:"},{"$f":"'Budget Narrative'!B2","v":0}]
[{"$f":"'Budget Narrative'!A3","v":"Program Name:"},{"$f":"'Budget Narrative'!B3","v":0}]
[{"$f":"'Budget Narrative'!A4","v":"Total Proposed Clients Served:"},{"$f":"'Budget Narrative'!B4","v":0}]
[]
["SubGrantee Name:","Start Date:","End Date:","Services Agreed to Perform","Unduplicated Clients Served","Line-Items","COA Amount","Other Funded Amount:","Total Amount:"]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G7:H7)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G8:H8)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G10:H10)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G11:H11)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G12:H12)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G14:H14)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G15:H15)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G16:H16)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G18:H18)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G19:H19)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G20:H20)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G22:H22)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G23:H23)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G24:H24)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G26:H26)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G27:H27)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G28:H28)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G30:H30)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G31:H31)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G32:H32)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G34:H34)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G35:H35)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G36:H36)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G38:H38)","v":0}]
[null,null,null,null,null,"Personnel:",null,null,{"$f":"SUM(G39:H39)","v":0}]
[null,null,null,null,null,"Operations:",null,null,{"$f":"SUM(G40:H40)","v":0}]
[null,null,null,null,null,"Direct Assistance:",null,null,0]
[null,null,null,null,null,"Other",null,null,{"$f":"SUM(G42:H42)","v":0}]
[null,null,null,null,null,"Total:",{"$f":"SUM(G7:G42)","v":0},{"$f":"SUM(H7:H42)","v":0},0]

{"sheet":"Cost Per Client","index":3,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Budget Narrative'!A1","v":"Form 3 - Program Budget and Narrative"}]
[{"$f":"'Budget Narrative'!A2","v":"Agency Name:"},{"$f":"'Budget Narrative'!B2","v":0}]
[{"$f":"'Budget Narrative'!A3","v":"Program Name:"},{"$f":"'Budget Narrative'!B3","v":0}]
[{"$f":"'Budget Narrative'!A4","v":"Total Proposed Clients Served:"},{"$f":"'Budget Narrative'!B4","v":0}]
[]
["Overall Budget:",{"$f":"'Budget Narrative'!D29","v":0}]
["Cost per client",{"$f":"IF(B4=0,\"\",SUM(B6/B4))","v":""}]