{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Worksheet","Summary","PRA and Instructions"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Worksheet","index":0,"n_rows":221,"n_cols":15,"rows_kept":221,"cut":false,"hidden":false,"merged":[[1,0,1,11]],"flags":["formulas_cached_only"]}
["Grant Application Detailed Budget Worksheet ",{"$nulls":11},"OMB Approval No. 2501-XXXX"]
[{"$nulls":12},"Expiration: XXXX"]
[null,"Applicant Name:"]
[null,"Applicant Address:"]
[]
[]
[]
["Category",{"$nulls":5},"Detailed Description of Budget (for full grant period)"]
["1.  Personnel (Direct Labor)",null,"Estimated Hours","Rate per Hour","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
["Position or Individual"]
{"$rows_empty":9}
["     Total Direct Labor Cost"]
["2.  Fringe Benefits",null,"Rate (%)","Base","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
{"$rows_empty":10}
["     Total Fringe Benefits Cost"]
["3.  Travel"]
["3a.  Transportation - Local Private Vehicle",null,"Mileage","Rate per Mile","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
[]
[]
[]
["     Subtotal - Trans - Local Private Vehicle"]
["3b.  Transportation - Airfare (show destination)",null,"Trips","Fare","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
[]
[]
[]
["     Subtotal - Transportation - Airfare"]
["3c.  Transportation - Other",null,"Quantity","Unit Cost","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
[]
[]
[]
["     Subtotal - Transportation - Other"]
["3d.  Per Diem or Subsistence (indicate location)",null,"Days","Rate per Day","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
[]
[]
["     Subtotal - Per Diem or Subsistence"]
["Total Travel Cost"]
["4.  Equipment (Only items over $5,000 Depreciated value)",null,"Quantity","Unit Cost","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
[]
["Total Equipment Cost"]
["5.  Supplies and Materials (Items under $5,000 Depreciated Value)"]
["5a.  Consumable Supplies",null,"Quantity","Unit Cost","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
{"$rows_empty":7}
["     Subtotal - Consumable Supplies"]
["5b.  Non-Consumable Materials",null,"Quantity","Unit Cost","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
[]
[]
[]
["     Subtotal - Non-Consumable Materials"]
["Total Supplies and Materials Cost"]
["6.  Consultants (Type)",null,"Days","Rate per Day","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
[]
[]
[]
["Total Consultants Cost"]
["7.  Contracts and Sub-Grantees (List individually)"]
["7a.  Contracts",null,"Quantity","Unit Cost","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
{"$rows_empty":7}
["     Subtotal - Contracts"]
["7b.  Sub-Grantees (List individually)",null,"Quantity","Unit Cost","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
[]
[]
[]
["     Subtotal - Sub-Grantees"]
["Total Contracts and Sub-Grantees Cost"]
["8.  Construction Costs"]
["8a.  Administrative and legal expenses",null,"Quantity","Unit Cost","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
[]
[]
["     Subtotal - Administrative and legal expenses"]
["8b. Land, structures, rights-of way, appraisal, etc ",null,"Quantity","Unit Cost","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
[]
["     Subtotal -  Land, structures, rights-of way, …"]
["8c. Relocation expenses and payments",null,"Quantity","Unit Cost","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
[]
[]
["     Subtotal - Relocation expenses and payments"]
["8d. Architectural and engineering fees",null,"Quantity","Unit Cost","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
[]
[]
["     Subtotal - Architectural and engineering fees"]
["8e. Other architectural and engineering fees",null,"Quantity","Unit Cost","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
[]
[]
["     Subtotal - Other architectural and engineering fees"]
["8f. Project inspection fees",null,"Quantity","Unit Cost","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
["     Subtotal -  Project inspection fees"]
["8g. Site work ",null,"Quantity","Unit Cost","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
["     Subtotal - Site work"]
["8h. Demolition and removal",null,"Quantity","Unit Cost","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
["     Subtotal - Demolition and removal"]
["8i. Construction",null,"Quantity","Unit Cost","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
["     Subtotal - Construction"]
["8j. Equipment",null,"Quantity","Unit Cost","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
[]
["     Subtotal - Equipment"]
["8k. Contingencies ",null,"Quantity","Unit Cost","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
["     Subtotal - Contingencies "]
["8l. Miscellaneous ",null,"Quantity","Unit Cost","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[]
[]
[]
["     Subtotal - Miscellaneous "]
["Total Construction Costs"]
["9.  Other Direct Costs",null,"Quantity","Unit Cost","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[null,"Item"]
{"$rows_empty":13}
["Total Other Direct Costs"]
[]
["Subtotal of Direct Costs"]
[]
["10.  Indirect Costs",null,"Rate","Base","Estimated Cost",null,"HUD Share","Applicant Match",null,"Other HUD Funds","Other Federal Share","State Share","Local/Tribal Share","Other","Program Income"]
[null,"Type"]
{"$rows_empty":9}
["Total Indirect Costs"]
["Total Estimated Costs"]

{"sheet":"Summary","index":1,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[{"$nulls":4},"form HUD-424-CBW"]
[{"$nulls":4},"OMB Approval No. 2501-XXXX"]
["Grant Application Detailed Budget Worksheet ",null,null,null,"Expiration: XXXX"]
[]
["Detailed Description of Budget"]
["Analysis of Total Estimated Costs",null,null,"Estimated Cost","Percent of Total"]
[1,"Personnel (Direct Labor)",null,0,0]
[2,"Fringe Benefits",null,0,0]
[3,"Travel",null,0,0]
[4,"Equipment",null,0,0]
[5,"Supplies and Materials",null,0,0]
[6,"Consultants",null,0,0]
[7,"Contracts and Sub-Grantees",null,0,0]
[8,"Construction",null,0,0]
[9,"Other Direct Costs",null,0,0]
[10,"Indirect Costs",null,0,0]
[null,"Total:",null,0,0]
["                            ","       ","Federal Share:"]
[null,"       ","Match \n(Expressed as a percentage of the Federal Share):"]
{"$rows_empty":9}
[null,null,null,"                                    "]

{"sheet":"PRA and Instructions","index":2,"n_rows":75,"n_cols":3,"rows_kept":75,"cut":false,"hidden":false,"merged":[[70,1,72,1],[74,1,74,2],[3,1,3,2],[31,1,33,1],[63,1,69,1],[28,1,30,1],[37,1,49,1],[19,1,21,1],[22,1,24,1],[25,1,27,1],[7,1,7,2],[9,1,15,1]],"flags":["formulas_cached_only"]}
[]
[null,"Public Reporting Act Statement"]
[]
[null,"The public reporting burden for this collection of information is estimated to average 3 hours per response, including the time for reviewing instructions, searching existing data sources, gathering, and maintaining the data needed, and completing and reviewing the collection of information. Comments regarding the accuracy of this burden estimate and any suggestions for reducing this burden can be sent to: U.S. Department of Housing and Urban Development, Office of the Chief Data Officer, R, 451 7th St SW, Room 8210, Washington, DC 20410-5000. Do not send completed HUD 424-CBW forms to this address. This agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless the collection displays a valid OMB control number. The Department of Housing and Urban Development is authorized to collect this information under the authority cited in the Notice of Funding Opportunity for this grant program. The information collected will provide proposed budget data for multiple programs. HUD will use this information in the selection of applicants. This information is required to obtain the benefit sought in the grant program. This information will not be held confidential and may be made available to the public in accordance with the Freedom of Information Act (5 U.S.C. §552)."]
[]
[null,"Instructions for Completing the Grant Application Detailed Budget Worksheet "]
[]
[null,"This form is to be used to provide detailed budget information regarding your proposed program.  If your program requires you to provide program activity information you should use a separate HUD-424-CBW to provide information related to each program activity.  The detailed information provided on this form can be summarized on the HUD-424-CB form by checking the “All Years” box at the top of the form and inputting the summary information."]
[null,"Item","Discussion"]
[null,"1 - Personnel (Direct Labor)","This section should show the labor costs for all individuals supporting the grant program effort (regardless of the source of their salaries). The hours and costs are for the full life of the grant. If an individual is employed by a contractor or sub-grantee, their labor costs should not be shown here."]
[]
[null,null,"Please include all labor costs that are associated with the proposed grant program, including those costs that will be paid for with in-kind or matching funds."]
[]
[null,null,"Do not show fringe or other indirect costs in this section."]
[]
[null,null,"Please use the hourly labor cost for salaried employees (use 2080 hours per year or the value your organization uses to perform this calculation). An employee working less than full time on the grant should show the numbers of hours they will work on the grant."]
[null,"2 - Fringe Benefits","Use the standard fringe rates used by your organization. You may use a single fringe rate (a percentage of the total direct labor) or list each of the individual fringe charges. The spreadsheet is set up to use the Total Direct Labor Cost as the base for the fringe calculation. If your organization calculates fringe benefits differently, please use a different base and discuss how you calculate fringe as a comment."]
[null,"3 - Travel"]
[null,"3a - Transportation - Local Private Vehicle","If you plan on reimbursing staff for the use of privately owned vehicles or if you are required to reimburse your organization for mileage charges, show your mileage and cost estimates in this section."]
[null,"3b - Transportation - Airfare","Show the estimated cost of airfare required to support the grant program effort.  Show the destination and the purpose of the travel as well as the estimated cost of the tickets."]
[]
[null,null,"Each program notice of funding opportunity (NOFO) discusses the travel requirements that should be listed here."]
[null,"3c - Transportation - Other","If you or are charged monthly by your organization for a vehicle for use by the grant program, indicate those costs in this section."]
[]
[null,null,"Provide estimates for other transportation costs that may be incurred (taxi, etc.)."]
[null,"3d - Per Diem or Subsistence","For travel which will require the payment of subsistence or per diem in accordance with your organization’s policies. Indicate the location of the travel."]
[]
[null,null,"Each program NOFO discusses the travel requirements that should be listed here."]
[null,"4 – Equipment","“Equipment” means tangible personal property (including information technology systems) having a useful life of more than one year and a per-unit acquisition cost that equals or exceeds the lesser of the capitalization level established by the non-Federal entity for financial statement purposes, or $5,000."]
[]
[null,null,"Each program NOFO describes what equipment may be purchased using grant funding."]
[null,"5 - Supplies and Materials","“Supplies” means all tangible personal property other than those described in the definition of equipment. A computing device is a supply if the acquisition cost is less than the lesser of the capitalization level established by the non-Federal entity for financial statement purposes or $5,000, regardless of the length of its useful life."]
[]
[null,null,"List the proposed supplies and materials as either Consumable Supplies or as Non-Consumable Materials."]
[null,"5a - Consumable Supplies","List the consumable supplies you propose to purchase. General office or other common supplies may be estimated using an anticipated consumption rate. "]
[null,"5b - Non-consumable materials","List furniture, computers, printers, and other items that will not be consumed in use. Please list the quantity and unit cost."]
[null,"6 – Consultants","Indicate the consultants you will use. Indicate the type of consultant (skills), the number of days you expect to use them, and their daily rate. "]
[null,"7 - Contracts and Subgrantees\n     \t7a - Contracts\n     \t7b - Subgrantees","List the contractors and sub-grantees that will help accomplish the grant effort. Examples of contracts that should be shown here include contracts with Community Based Organizations; liability insurance; and training and certification for contractors and workers."]
[]
[null,null,"If any contractor, sub-contractor, or sub-grantee is expected to receive over 10% of the total Federal amount requested, a separate Grant Application Detailed Budget (Worksheet) should be developed for that contractor or sub-grantee and the total amount of their proposed effort should be shown as a single entry in this section."]
[]
[null,null,"Unless your proposed program will perform the primary grant effort with in-house employees (which should be listed in section 1), the costs of performing the primary grant activities  should be shown in this section."]
[]
[null,null,"Types of activities which should be shown in this section:"]
[null,null,"·        Contracts for all services"]
[null,null,"·        Training for individuals not on staff "]
[null,null,"·        Contracts with Community Based Organizations or Other Governmental Organizations (note the 10% requirement discussed above)"]
[null,null,"·        Insurance if your program will procure it separately"]
[]
[null,null,"Please provide a short description of the activity the contractor or subgrantee will perform, if not evident."]
[null,"8 – Construction Costs"]
[null,"8a – Administrative and legal expenses","Enter estimated amounts needed to cover administrative expenses.  Do not include costs  that are related to the normal functions of government.  "]
[null,"      8b – Land, structures, rights-of way, appraisal, etc.","Enter estimated site and right(s)-of-way acquisition costs (this includes purchase, lease, and/or easements)."]
[null,"      8c – Relocation expenses and payments","Enter estimated costs related to relocation advisory assistance, replacement housing, relocation payments to displaced persons and businesses, etc."]
[null,"      8d – Architectural and engineering fees","Enter estimated basic engineering fees related to construction (this includes start-up services and preparation of project performance work plan)."]
[null,"      8e – Other architectural and engineering fees","Enter estimated engineering costs, such as surveys, tests, soil borings, etc."]
[null,"      8f – Project inspection fees","Enter estimated engineering inspection costs."]
[null,"      8g – Site work","Enter the estimated site preparation and restoration costs that are not included in the basic construction contract."]
[null,"      8h – Demolition and removal","Enter the estimated costs related to demolition activities."]
[null,"      8i – Construction","Enter estimated costs of the construction contract."]
[null,"      8j - Equipment","Enter estimated cost of office, shop, laboratory, safety equipment, etc. to be used at the facility, if such costs are not included in the construction contract."]
[null,"      8k – Contingencies","Enter any estimated contingency costs."]
[null,"      8l – Miscellaneous","Enter estimated miscellaneous costs."]
[null,"9 - Other Direct Costs","Other Direct Costs include a number of items that are not appropriate for other sections."]
[]
[null,null,"Other Direct Costs may include:"]
[null,null,"·        Staff training"]
[null,null,"·        Telecommunications"]
[null,null,"·        Printing and postage"]
[null,null,"Relocation, if costs are paid directly by your organization (if relocation costs are paid by a subgrantee, it should be reflected in Section 7)"]
[null,"10 - Indirect Costs","Indirect costs (including Facilities and Administration costs) are those costs that have been incurred for common or joint purposes. These costs benefit more than one cost objective and cannot be readily identified with a particular final cost objective without effort disproportionate to the results achieved. "]
[]
[null,null,"Indicate your approved Indirect Cost Rate (if any) and calculate the indirect costs in accordance with the terms of your approved indirect cost rate and enter the resulting amount.  Also show the applicable cost base amount and identify the proposed cost base type."]
[null,"Total Estimated Costs","Enter the grand total of all the applicable columns."]
[null,"The eight rightmost columns allow you to identify how the costs will be spread between the HUD Share and other contributors (including Match funds and Program Income). This information will help the reviewers better understand your program and priorities."]