{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Budget Narrative Example","First PY Budget","Second PY Budget","Third PY Budget","Total_POP_Budget","Budget Narrative Template Y2","Budget Narrative Template Y3","Total POP Budget","Lists"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":119,"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":"Budget Narrative Example","index":0,"n_rows":146,"n_cols":11,"rows_kept":146,"cut":false,"hidden":true,"merged":[[46,1,46,10],[0,1,0,4],[1,1,1,4],[3,1,3,4],[5,1,5,4],[7,1,7,4],[18,1,18,4],[19,1,19,4],[21,1,21,4],[31,1,31,4],[32,1,32,4],[34,1,34,10],[94,1,94,5],[47,1,47,10],[49,1,49,5],[61,1,61,5],[62,1,62,5],[64,1,64,6],[78,1,78,6],[79,1,79,6],[81,1,81,6],[89,1,89,6],[90,1,90,6],[92,1,92,4],[107,1,107,5],[95,1,95,5],[96,7,96,12],[97,7,97,12],[98,7,98,12],[99,7,99,12],[100,7,100,12],[113,7,113,12],[101,7,101,12],[102,7,102,12],[103,7,103,12],[104,7,104,12],[105,7,105,12],[108,7,108,12],[109,7,109,12],[110,7,110,12],[111,7,111,12],[112,7,112,12],[143,1,143,4],[114,7,114,12],[115,7,115,12],[116,7,116,12],[117,7,117,12],[121,1,121,6],[122,1,122,6],[124,1,124,4],[133,1,133,4],[134,1,134,4],[141,1,141,4],[142,1,142,4]]}
[null,"HVRP Budget Narrative Template version 1.0"]
[null,"NOTE: The Budget Narrative is the justification for budget line-items meet program objectives. The Budget Narrative must be concrete and specific. The Budget Narrative is for a one-year budget up to $600,000 that supports the targeted population and the service delivery area(s); additionally, proposed allocations must be proportional to the resources needed to implement the proposed project. "]
[]
[null,"Applicants/recipients must demonstrate that costs are allowable (2 C.F.R. § 200.403). In other words, costs must be necessary and reasonable for the performance of the Federal award and must be allocable under the cost principles in 2 C.F.R § 200 Subpart E. A cost is “necessary” if it meets a program objective and is necessary and reasonable for the performance of the HVRP. A cost is “reasonable” if it meets the “prudent person” standard (2 C.F.R. § 200.404). See section IV.B.2.a of the FOA for additional requirements for the budget narrative. Shared costs among multiple programs or projects should be proportionate: (ex. Program Manager who works HVRP 20% of the time, the amount charged to HVRP for items such as the Program Manager's cell phone or laptop, would be cost shared among the other programs).\n\nIf charging indirect costs in Section J. Indirect Charges, ensure costs are not duplicated under any of the direct costs categories. Costs must not be duplicated or inconsistently charged, costs must be charged as either indirect or direct costs. "]
[]
[null,"The Budget Narrative must include a justification for all proposed costs and align with the SF-424A and the estimated funding amount in the SF-424 (Section 18). The Budget Narrative must be consistent with and support the activities, resources, staff, and other items described in the project narrative. \n\nTo add more rows or space to any budget line-item, select the “Add” button to the right of the field. "]
[]
["a.","Personnel:\nList all staff positions (including individuals hired by an employment contract) by title (both current and proposed) and provide the annual salary, the percentage of time devoted to the project, and the amount of each position’s salary funded by the grant. Do not list positions that will be covered under Indirect Costs. \n\nIn the Justification of Costs section, include the corresponding roles and responsibilities for each position. "]
[null,"Position Title","Annual Salary","% of FTE","Actual Salary"]
[null,null,null,null,{"$f":"(C10*D10)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"Total Personnel",null,null,{"$f":"SUM(E10:E16)","v":0}]
[null,"Total Personnel - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",{"$f":"ROUND(E17,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
["b.","Fringe Benefits:\nProvide information on the rate of fringe benefits used and the basis for the calculation. If not using a fringe benefits rate, itemize how the fringe benefits amount is computed in the Justification of Costs section.\nFringe benefits may be in the form of employer contributions or expenses for FICA (Social Security and Medicare tax), employee life, health, unemployment, worker's compensation insurance, paid absences, and other similar reasonable and allowable benefits as required by law, organization – employee agreement, or established written policies of the applicant/recipient organization per 2 C.F.R § 200.431. Fringe benefits are for the personnel listed in budget category (a) and are only for the percentage of time devoted to the project. "]
[null,"Description ","Base","Rate","Cost"]
[null,null,null,null,{"$f":"D24*C24","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"Total Fringe Benefits",null,null,{"$f":"SUM(E24:E29)","v":0}]
[null,"Total Fringe Benefits - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",{"$f":"ROUND(E30,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
["c.","Travel (for grant recipient staff only):\nTravel costs are allowable as expenses by employees who are in travel status on official business/project-related travel. Itemize travel expenses of personnel by purpose (e.g., staff training, field interviews, advisory group meeting, etc.) and include funds to cover travel to DOL-sponsored training events such as the annual post-award conference, professional conference, and/or any other offered trainings. Travel for participants (e.g., travel stipends for program participants) should be specifically itemized and placed in the Other category. \nInclude the basis of computation (e.g., six people to 3-day training at $X airfare, $X lodging, $X subsistence) for each travel expense. Specify the purpose, location (e.g., location or whether in-state or out-of-state), type of expense (select from dropdown), basis (e.g., round-trip, day/night, mileage, etc.), cost or cost and quantity (e.g., number of nights or miles), number of staff traveling, and number of trips for each type of travel.  \nIn the Justification of Costs section, describe the purpose of each travel expenditure in reference to the project objectives. Applicants must provide a justification for travel expenditures that exceed 10 percent of the one-year budget. \nNOTE: Per 2 C.F.R § 200.475(a), applicants must have policies in place related to travel costs. In the absence of an established travel policies, applicants/recipients must comply with the Federal travel regulations (48 C.F.R. § 31.205-46(a)), most easily accessible via the U.S. General Services Administration’s (GSA) website, see 2 C.F.R § 200.475.  For reimbursement on a mileage basis, the HVRP grant program cannot be charged more than the maximum allowable mileage reimbursement rates authorized for Federal employees. Mileage rates must be checked annually at GSA’s Privately Owned Vehicle (POV) Mileage Reimbursement Rates webpage to ensure compliance."]
[null,"Purpose","Location","Type of Expense","Basis","Cost","Quantity","# of Staff","# of Trips","% Charged to HVRP","Total Cost"]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(Travel13[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(Travel13[[#This Row],[Cost]]*Travel13[[#This Row],[Quantity]]*Travel13[[#This Row],['# of Staff]]*Travel13[[#This Row],['# of Trips]]*Travel13[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(Travel13[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(Travel13[[#This Row],[Cost]]*Travel13[[#This Row],[Quantity]]*Travel13[[#This Row],['# of Staff]]*Travel13[[#This Row],['# of Trips]]*Travel13[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(Travel13[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(Travel13[[#This Row],[Cost]]*Travel13[[#This Row],[Quantity]]*Travel13[[#This Row],['# of Staff]]*Travel13[[#This Row],['# of Trips]]*Travel13[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(Travel13[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(Travel13[[#This Row],[Cost]]*Travel13[[#This Row],[Quantity]]*Travel13[[#This Row],['# of Staff]]*Travel13[[#This Row],['# of Trips]]*Travel13[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(Travel13[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(Travel13[[#This Row],[Cost]]*Travel13[[#This Row],[Quantity]]*Travel13[[#This Row],['# of Staff]]*Travel13[[#This Row],['# of Trips]]*Travel13[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(Travel13[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(Travel13[[#This Row],[Cost]]*Travel13[[#This Row],[Quantity]]*Travel13[[#This Row],['# of Staff]]*Travel13[[#This Row],['# of Trips]]*Travel13[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(Travel13[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(Travel13[[#This Row],[Cost]]*Travel13[[#This Row],[Quantity]]*Travel13[[#This Row],['# of Staff]]*Travel13[[#This Row],['# of Trips]]*Travel13[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(Travel13[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(Travel13[[#This Row],[Cost]]*Travel13[[#This Row],[Quantity]]*Travel13[[#This Row],['# of Staff]]*Travel13[[#This Row],['# of Trips]]*Travel13[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,"Total Travel",null,null,null,null,null,null,null,null,{"$f":"SUM(K37:K44)","v":0}]
[null,"Total Travel - Rounded to the Nearest Whole Dollar",null,null,null,null,null,null,"(must match SF-424A)",null,{"$f":"ROUND(K45,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
["d.","Equipment:\nPer 2 C.F.R. §200.1, equipment is an item of tangible, non-expendable, personal property (including information technology systems – means computing devices, ancillary equipment, software, and firmware etc.) having a useful life of more than one year AND an acquisition cost of at least $5,000 per unit or more regardless of the non-Federal entity’s capitalization threshold.\n\nList the item, quantity, and the unit cost per item. In the Justification of Costs section, describe the need for the equipment, i.e., explain how the use of each item of equipment is related to the implementation of the required/approved activities to achieve the specific project objectives. List expendable items or materials in Supplies. Generally, DOL/VETS does not permit the purchase of equipment during the last funded year of the award."]
[null,"Item","Quantity","Cost Per Unit","% Charged to HVRP","Total"]
[null,null,null,null,null,{"$f":"(C52*D52*E52)","v":0}]
[null,null,null,null,null,{"$f":"(C53*D53*E53)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,"Total Equipment",null,null,null,{"$f":"SUM(F52:F59)","v":0}]
[null,"Total Equipment - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",null,{"$f":"ROUND(F60,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
["e.","Supplies:\nPer 2 C.F.R. §200.1, supplies are items that cost less than $5,000 per unit and often have a one-time use, that is, materials which are expendable or consumed during the performance of the federal award. A computing device is a supply if the acquisition cost is less than the lesser of the capitalization level established by the organization for financial statement purposes or $5,000, regardless of the length of its useful life. \n\nList the items by type of supply (e.g., training materials, desktop computer, laptop, projector etc.), cost per unit, quantity, or cost per month. Note: subscription services such as cellular phone service or internet service are not tangible and must be listed in Other.\n\nFor each item or cost, include an adequate justification in the Justification of Costs section."]
[null,"Item","Cost Per Unit","Quantity","Cost Per Month","% Charged to HVRP","Total"]
[null,null,null,null,null,null,{"$f":"IF(Supplies15[[#This Row],[Cost Per Unit]]<>\"\",Supplies15[[#This Row],[Cost Per Unit]]*Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[% Charged to HVRP]],IF(Supplies15[[#This Row],[Quantity]]<>\"\",Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12,Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(Supplies15[[#This Row],[Cost Per Unit]]<>\"\",Supplies15[[#This Row],[Cost Per Unit]]*Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[% Charged to HVRP]],IF(Supplies15[[#This Row],[Quantity]]<>\"\",Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12,Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(Supplies15[[#This Row],[Cost Per Unit]]<>\"\",Supplies15[[#This Row],[Cost Per Unit]]*Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[% Charged to HVRP]],IF(Supplies15[[#This Row],[Quantity]]<>\"\",Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12,Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(Supplies15[[#This Row],[Cost Per Unit]]<>\"\",Supplies15[[#This Row],[Cost Per Unit]]*Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[% Charged to HVRP]],IF(Supplies15[[#This Row],[Quantity]]<>\"\",Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12,Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(Supplies15[[#This Row],[Cost Per Unit]]<>\"\",Supplies15[[#This Row],[Cost Per Unit]]*Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[% Charged to HVRP]],IF(Supplies15[[#This Row],[Quantity]]<>\"\",Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12,Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(Supplies15[[#This Row],[Cost Per Unit]]<>\"\",Supplies15[[#This Row],[Cost Per Unit]]*Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[% Charged to HVRP]],IF(Supplies15[[#This Row],[Quantity]]<>\"\",Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12,Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(Supplies15[[#This Row],[Cost Per Unit]]<>\"\",Supplies15[[#This Row],[Cost Per Unit]]*Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[% Charged to HVRP]],IF(Supplies15[[#This Row],[Quantity]]<>\"\",Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12,Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(Supplies15[[#This Row],[Cost Per Unit]]<>\"\",Supplies15[[#This Row],[Cost Per Unit]]*Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[% Charged to HVRP]],IF(Supplies15[[#This Row],[Quantity]]<>\"\",Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12,Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(Supplies15[[#This Row],[Cost Per Unit]]<>\"\",Supplies15[[#This Row],[Cost Per Unit]]*Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[% Charged to HVRP]],IF(Supplies15[[#This Row],[Quantity]]<>\"\",Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12,Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(Supplies15[[#This Row],[Cost Per Unit]]<>\"\",Supplies15[[#This Row],[Cost Per Unit]]*Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[% Charged to HVRP]],IF(Supplies15[[#This Row],[Quantity]]<>\"\",Supplies15[[#This Row],[Quantity]]*Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12,Supplies15[[#This Row],[Cost Per Month]]*Supplies15[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,"Total Supplies",null,null,null,null,{"$f":"SUM(G67:G76)","v":0}]
[null,"Total Supplies - Rounded to the Nearest Whole Dollar",null,null,"(must match SF-424A)",null,{"$f":"ROUND(G77,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
["f.","Contractual:\nDescribe contracts and subawards separately.  Contracts are defined according to 2 C.F.R. § 200.1 as a legal instrument by which a non-federal entity purchases goods or services needed to carry out the project or program under a federal award.  A subaward, defined by 2 C.F.R. § 200.1, means an award provided by a pass-through entity to a subrecipient for the subrecipient to carry out part of a federal award received by the pass-through entity.  It does not include payments to a contractor or payments to an individual that is a beneficiary of a federal program. \n\nFor each contract or subaward, list the purpose, goods and/or services to be provided, and the amount. In the Justification of Costs section, describe the goods and/or services to be provided by each contractor or sub-awardee, and how the goods and/or services relate to the accomplishment of specific project objectives.\n\nAll procurement transactions for the acquisition of goods and/or services required under a federal award must be conducted in a manner providing full and open competition consistent with the federal procurement standards in 2 C.F.R. § 200.319 (Competition.) and 2 C.F.R. §200.320 (Methods of procurement to be followed). Applicants must follow their documented procurement procedures which reflect applicable state, local, and tribal laws, and regulations. These procedures must also conform to applicable Federal laws, regulations and the standards identified in 2 C.F.R § 200.318.  Applicants must maintain oversight to ensure that contractors and sub-awardees perform in accordance with the terms, conditions, and specifications of their legal agreement. For additional guidance, refer to 2 C.F.R. § 200.318 through 2 C.F.R. § 200.327 on Procurement Standards."]
[null,"Contract/Subaward","Purpose","Activities to be provivded","Amount","% Charged to HVRP","Total"]
[null,null,null,null,null,null,{"$f":"Contractual16[[#This Row],[Amount]]*Contractual16[[#This Row],[% Charged to HVRP]]","v":0}]
[null,null,null,null,null,null,{"$f":"Contractual16[[#This Row],[Amount]]*Contractual16[[#This Row],[% Charged to HVRP]]","v":0}]
[null,null,null,null,null,null,{"$f":"Contractual16[[#This Row],[Amount]]*Contractual16[[#This Row],[% Charged to HVRP]]","v":0}]
[null,null,null,null,null,null,{"$f":"Contractual16[[#This Row],[Amount]]*Contractual16[[#This Row],[% Charged to HVRP]]","v":0}]
[null,"Total Contractual",null,null,null,null,{"$f":"SUM(G84:G87)","v":0}]
[null,"Total Contractual - Rounded to the Nearest Whole Dollar",null,null,"(must match SF-424A)",null,{"$f":"ROUND(G88,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
["g.","Construction:\nConstruction costs are unallowable under the HVRP grant program; and therefore, this budget line-item must be zero. Minor alterations to modernize, improve, and/or reconfigure an existing space for grant activities (such as a classroom alteration) may be allowable, as this is not considered construction. Applicants must include the costs for minor alterations in the budget line-item Contractual.",null,null,null,0]
[]
["h.","Other"]
[null,"Participant Support Costs: \nList participant support costs (e.g., training, clothing, etc.) and provide clear and specific detail, including costs and quantity, for each item so that we can review factors affecting allowability of costs as discussed in 2 C.F.R. § 200.403. Per 2 C.F.R. § 200.1, participant support costs means direct costs for items such as stipends or subsistence allowances, travel allowances, and registration fees paid to or on behalf of participants or trainees (but not employees) in connection with conferences, or training projects. "]
[null,"Item","Cost Per Unit","Quantity","Cost Per Month","% Charged to HVRP","Total","Justification of Costs\n(max 2,620 characters including spaces; users may adjust row height manually to display full text)"]
[null,null,null,null,null,null,{"$f":"IF($C98<>\"\",$C98*$D98*$F98,IF($D98<>\"\",$D98*$E98*$F98*12,$E98*$F98*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF($C99<>\"\",$C99*$D99*$F99,IF($D99<>\"\",$D99*$E99*$F99*12,$E99*$F99*12))","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,"Total Participant Support Services",null,null,null,null,{"$f":"SUM(G98:G106)","v":0}]
[null,"Other Costs:\nList items or expenses not covered in other budget line-items, and provide specific details including the costs and quantity, for each item. Show the basis for the calculations – breakdown costs into the cost per unit or month (e.g., cost per square foot, cost per participant etc.). "]
[null,"Item","Cost Per Unit","Quantity","Cost Per Month","% Charged to HVRP","Total","Justification of Costs\n(max 2,620 characters including spaces; users may adjust row height manually to display full text)"]
[null,null,null,null,null,null,{"$f":"IF($C110<>\"\",$C110*$D110*$F110,IF($D110<>\"\",$D110*$E110*$F110*12,$E110*$F110*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF($C111<>\"\",$C111*$D111*$F111,IF($D111<>\"\",$D111*$E111*$F111*12,$E111*$F111*12))","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,"Total Other Costs",null,null,null,null,{"$f":"SUM(G110:G118)","v":0}]
[null,"Other Total (Participant Support Services + Other)",null,null,null,null,{"$f":"SUM(G107,G119)","v":0}]
[null,"Other Total - Rounded to the Nearest Whole Dollar",null,null,null,"(must match SF-424A)",{"$f":"ROUND(G120,0)","v":0}]
[null,"Justification of Costs Not Explained in Columns G:L Above (max 3,225 characters including spaces)"]
[]
[]
["j.","Indirect Costs:\nPer 2 C.F.R. § 200.1 indirect (facilities and administrative (F&A)) costs are costs incurred for a common or joint purpose benefitting more than one cost objective, and not readily assignable to the cost objectives specifically benefitted, without effort disproportionate to the results achieved. To facilitate equitable distribution of indirect expenses to the cost objectives served, it may be necessary to establish several pools of indirect (F&A) costs. \n\nInclude the type of rate or agreement (e.g., Negotiated Indirect Costs Rate Agreement (NICRA), Cost Allocation Plan (CAP), or the de minimis rate of 10% of modified total direct costs (MTDC)), the total approved base (if applicable), and the approved rate (if applicable).\n\nIf using a NICRA, in the Justification of Costs section, provide an explanation of how the indirect costs are calculated. This explanation should include which portion of each line item, along with the associated costs, are included in your allocation base.\n\nIf using the de minimis rate of 10% of MTDC, in the Justification of Costs section, provide an explanation of which portion of each line item, along with the associated costs, are included in your allocation base. Note that there are various items not included in the calculation of MTDC, see 2 C.F.R. § 200.1 for specific exclusions. \n\nIf using a CAP, in the Justification of Costs section, provide estimated indirect costs based on your approved allocation methodology. "]
[null,"Type of Rate Agreement","Base","Rate","Total Indirect Costs"]
[null,"NICRA",null,null,{"$f":"IF(OR(Indirect_Costs18[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs18[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),D127*C127,C127)","v":0}]
[null,null,null,null,{"$f":"IF(OR(Indirect_Costs18[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs18[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),D128*C128,C128)","v":0}]
[null,null,null,null,{"$f":"IF(OR(Indirect_Costs18[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs18[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),D129*C129,C129)","v":0}]
[null,null,null,null,{"$f":"IF(OR(Indirect_Costs18[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs18[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),D130*C130,C130)","v":0}]
[null,null,null,null,{"$f":"IF(OR(Indirect_Costs18[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs18[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),D131*C131,C131)","v":0}]
[null,"Total Indirect Costs",null,null,{"$f":"SUM(E127:E131)","v":0}]
[null,"Total Indirect Costs - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",{"$f":"ROUND(E132,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
[null,"Total Costs","Column1"]
[null,"Total Direct Costs",{"$f":"SUM(G121,G89,G78,K46,E31,E18,F61)","v":0}]
[null,"Total Indirect Costs",{"$f":"E133","v":0}]
[null,"Total Costs funded by Grant\n(must match the total on the SF-424 and SF-424A, as well as the Year 1 total on the VETS-704 Abstract)",{"$f":"SUM(C138:C139)","v":0}]
[]
[null,"Leveraged Resources:\nThe HVRP grant program does not require cost sharing or matching funds. However, the Budget Narrative should include a section describing any leveraged resources provided (as applicable) to support grant activities. DOL/VETS considers any resources contributed to the project, beyond the funds provided by the agency, as leveraged resources. Applicants are encouraged to leverage resources to increase stakeholder investment in the project and broaden and sustain the impact of the project itself. The Budget Narrative should provide a description of the leveraged resources provided to support grant activities, the specific activities they will cover, the way they will support HVRP goals and the funding source. Valuation of leveraged resources follows the same requirements as matching funds.  \t"]
[null,"Description of Leveraged Resources (max 3,225 characters including spaces)"]
[]
[]
[null,"**DOL/VETS does not allow the purchase of construction, motor vehicles, buildings, or land."]

{"sheet":"First PY Budget","index":1,"n_rows":209,"n_cols":12,"rows_kept":209,"cut":false,"hidden":false,"merged":[[150,7,150,11],[149,7,149,11],[2,5,2,11],[101,0,101,5],[130,7,130,11],[6,0,6,3],[39,0,39,9],[60,0,60,4],[80,0,80,5],[40,0,40,9],[21,0,22,3],[37,0,37,3],[77,0,77,4],[99,0,99,5],[57,0,58,9],[1,0,1,3],[2,0,2,3],[5,0,5,3],[192,0,192,3],[188,0,188,3],[189,0,189,3],[167,0,167,3],[117,0,117,4],[138,0,138,4],[7,0,7,3],[193,0,193,3],[190,0,190,3],[3,1,3,2],[4,1,4,2],[153,7,153,11],[165,0,165,5],[181,0,181,3],[168,0,168,3],[158,0,159,5],[151,7,151,11],[24,0,24,3],[152,7,152,11],[113,0,113,5],[131,7,131,11],[136,0,136,5],[115,0,115,3]]}
["Accessibility key:  Users may only edit unlocked cells, these unlocked cells are highlighted in yellow. If the user is experiencing macro-related issues, the alt text of the relevant images in cell F3 will notify them about the links that assist in resolving the issue."]
["HVRP Budget Narrative Template version 2.2",null,null,null,0,0,0,0,0,0,0,0]
["Applicants/grant recipients must demonstrate that their proposed costs are allowable (2 C.F.R. § 200.403). In other words, costs must be necessary and reasonable for the performance of the federal award and must be allocable under the cost principles in 2 C.F.R. Part 200, Subpart E. A cost is “necessary” if it meets a program objective and is necessary and reasonable for the performance of the Homeless Veterans' Reintegration Program (HVRP). A cost is “reasonable” if it does not exceed an amount that a prudent person would incur under the circumstances prevailing when the decision was made to incur the cost (2 C.F.R. § 200.404). Shared costs among multiple programs or projects must be proportionate (e.g., If a Program Manager works HVRP 20 percent of the time, the amount charged to HVRP for items such as the Program Manager's cell phone or laptop would be cost-shared among the other programs).\n\nIf charging indirect costs in Section B 6.j of the SF-424A, Indirect Charges, ensure costs are not duplicated under any of the direct costs categories. Costs must not be duplicated or inconsistently charged; costs must be charged as either indirect or direct costs, but not both.\n\nThe Budget Narrative must include a justification for all proposed costs and align with the SF-424A and the estimated federal funding amount in Section 18.a of the SF-424. The Budget Narrative must be consistent with and support the activities, resources, staff, and other items described in the project narrative.\n\nThe total one-year budget must not exceed the total one-year budget specified in the VETS-704 Form – Abstract and Planned Goals Chart, nor the annual maximum outlined in the award information section of the original Funding Opportunity Announcement applied under.  \n\nTo add more rows or space to any budget line-item, select the “Add” button to the right of the field.\n\nDo not copy and paste from one Spreadsheet to another in this workbook as this may alter pre-set formulas. \n\nIf your Justification text exceeds the character limit in a category, please utilize the Add Space to Justification button. If further space is needed, then use Additional Space for Narrative Justification section located at the bottom of this form.\n\nEnsure that all text is visible in the Excel File. GrantSolutions creates a PDF of this form, and all justification text must be visible. ",null,null,null,0,"If you encounter either of these warnings, please click the image for support:"]
["Enter Organization name below: ","Enter VETS-704 Form Abstract and Planned Chart Request Year 1 Amount"]
[]
["Budget Year 1"]
["Personnel: \nList all staff positions by title (both current and proposed) and provide the hourly wage, the percentage of time charged to the project (100% is 2,080 hours) and the annual salary for each position funded by the grant. Do not list positions that will be covered under Indirect Costs. Grant recipients that charge Personnel positions among multiple HVRP grants cannot exceed 100 percent FTE collectively among potential and active grants.\n\nIn the Justification of Costs section, include the corresponding roles and responsibilities for each position.\n\n",null,null,null,null,0,0,0,0,0,0,0]
["See the HVRP Glossary of Terms for Personnel position/staff definitions and examples."]
["Job or Position Title","Hourly Wage","% of FTE","Actual Annual Salary",0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"(B10*(C10*2080))","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"(B11*(C11*2080))","v":0},0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Total Personnel",null,null,{"$f":"SUM(D10:D17)","v":0},0,0,0,0,0,0,0]
["Total Personnel - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",{"$f":"ROUND(D18,0)","v":0},0,0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Fringe Benefits:\nProvide information on the rate of all fringe benefits used and the basis for the calculation. If not using a fringe benefits rate, itemize how the fringe benefits amount is computed in the Justification of Costs section.\n\nFringe benefits may be in the form of employer contributions or expenses for FICA (Social Security and Medicare tax), employee life, health, unemployment, and/or worker's compensation insurance, paid absences, and other similar reasonable and allowable benefits as required by law, organization – employee agreement, or established written policies of the applicant/recipient organization per 2 C.F.R. § 200.431. Fringe benefits are for the personnel listed in budget category (a) and are only for the percentage of time devoted to the project.\n\nAn example of calculating fringe benefits based on base wages: The federal unemployment tax rate is 6% on the first $7,000 of wages, according to IRS Publication 15: Employers Tax Guide. This means $7,000 × 0.06 = $420 per full-time employee (FTE). The state unemployment tax rate is 5.4% on a $10,000 base wage, according to State Unemployment Compensation Law. This means $10,000 × 0.054 = $540 per FTE.",null,null,null,0,0,0,0,0,0,0,0]
["Description ","Base","Rate","Cost",0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"C27*B27","v":0},0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
["Total Fringe Benefits","Total Rate:",{"$f":"SUM(C27:C33)","v":0},{"$f":"SUM(D27:D33)","v":0},0,0,0,0,0,0,0,0]
["Total Fringe Benefits - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",{"$f":"ROUND(D34,0)","v":0},0,0,0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Travel (for grant recipient staff only ):\nThis section is for grant recipient staff only. Per 2 C.F.R. § 200.475(a), applicants/grant recipients must have policies in place related to travel costs.\n\nIn the absence of an established written policy regarding travel costs, the rates and amounts established under 5 U.S.C. §§ 5701–11 (‘‘Travel and Subsistence Expenses; Mileage Allowances”), by the Administrator of General Services, or by the President (or their designee) pursuant to any provisions of such subchapter must apply to travel under federal awards (48 C.F.R. § 31.205–46(a)). \n\nFor reimbursement on a mileage basis, the HVRP grant program cannot be charged more than the maximum allowable mileage reimbursement rates authorized for federal employees. Mileage rates must be checked annually at the U.S. General Services Administration (GSA)GSA’s Privately Owned Vehicle (POV) Mileage Reimbursement Rates webpage to ensure compliance.\n\nLocal Travel – It is not necessary to specify the exact locations of each trip, as it will be fluid based on participants, employers, and outreach opportunities. \n\nOut-of-State or In-State Overnight Travel – Requires specific start date/time and destination locations so DOL/VETS can determine whether the per diem and/or lodging costs are reasonable. This travel could also include allowable expenses to cover travel to DOL-sponsored training events such as the region or state annual post-award conferences, professional conferences, and/or any other offered training. The National Post Award Conference is virtual, so do not include travel costs for that event. Identify the name and location of the conference that staff will attend. Staff should not claim full day per diem rates for the first and last day of travel. Lodging and per diem expenditures must not exceed the rates established by GSA for the location of your trip. Find your per diem and lodging rates on the GSA Per Diem Rates webpage.\n\nTravel for participants (e.g., travel stipends for program participants) should be specifically itemized and placed in the Other category. \n\nInclude the basis of computation (e.g., six people to three-day training at $X airfare, $X lodging, $X subsistence) for each travel expense. Specify the purpose, location (e.g., location or whether in-state or out-of-state), type of expense (select from dropdown), basis (e.g., round-trip, day/night, mileage, etc.), cost or cost and quantity (e.g., number of nights or miles), number of staff traveling, and number of trips for each type of travel. Some cells may automatically turn gray based on the choice you make in the dropdown menu.\n\nApplicants/grant recipients must provide a justification for travel expenditures that exceed 10 percent of this one-year budget.  ",null,null,null,null,null,null,null,null,null,0,0]
["click here to look up the most current FY GSA per diem rates: https://www.gsa.gov/travel/plan-book/per-diem-rates",null,null,null,null,null,null,null,null,null,0,0]
["Purpose","Location","Type of Expense","Basis","Cost","Quantity","# of Staff","# of Trips","% Charged to HVRP","Total Cost",0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel[[#This Row],[Basis]]=\"Round-Trip\",Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]],Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Staff]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel[[#This Row],[Basis]]=\"Round-Trip\",Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]],Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Staff]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel[[#This Row],[Basis]]=\"Round-Trip\",Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]],Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Staff]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel[[#This Row],[Basis]]=\"Round-Trip\",Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]],Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Staff]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel[[#This Row],[Basis]]=\"Round-Trip\",Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]],Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Staff]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel[[#This Row],[Basis]]=\"Round-Trip\",Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]],Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Staff]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel[[#This Row],[Basis]]=\"Round-Trip\",Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]],Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Staff]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel[[#This Row],[Basis]]=\"Round-Trip\",Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]],Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Staff]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel[[#This Row],[Basis]]=\"Round-Trip\",Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]],Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Staff]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]]),0)","v":0}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel[[#This Row],[Basis]]=\"Round-Trip\",Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]],Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Staff]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]]),0)","v":0}]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel[[#This Row],[Basis]]=\"Round-Trip\",Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]],Travel[[#This Row],[Cost]]*Travel[[#This Row],[Quantity]]*Travel[[#This Row],['# of Staff]]*Travel[[#This Row],['# of Trips]]*Travel[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
["Total Travel",null,null,null,null,null,null,null,null,{"$f":"SUM(J43:J53)","v":0},0,0]
["Total Travel - Rounded to the Nearest Whole Dollar",null,null,null,null,null,"(must match SF-424A)",null,null,{"$f":"ROUND(J54,0)","v":0},0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Equipment :\nPer 2 C.F.R. § 200.1, “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 recipient or subrecipient for financial statement purposes or $10,000. Items with a unit cost of less than $10,000 are supplies, not “equipment.” DOL/VETS does not allow the purchase of motor vehicles, buildings, or land.\n\nApplicants/grant recipients must list the item, quantity, and unit cost per item. In the Justification of Costs section, describe the need for the equipment, i.e., explain how the use of each item of equipment is related to the implementation of the required/approved activities to achieve the specific project objectives. List expendable items or materials in Supplies. DOL/VETS does not permit the purchase of equipment during the last funded year of the award.",null,null,null,null,0,0,0,0,0,0,0]
["Item","Quantity","Cost Per Unit","% Charged to HVRP","Total",0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"(B63*C63*D63)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"(B64*C64*D64)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0]
[null,null,null,null,0]
["Total Equipment",null,null,null,{"$f":"SUM(E63:E73)","v":0},0,0,0,0,0,0,0]
["Total Equipment - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",null,{"$f":"ROUND(E74,0)","v":0},0,0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Supplies :\nPer 2 C.F.R. § 200.1, “supplies” means all tangible personal property other than those described in the equipment definition. A computing device is a supply if the acquisition cost is below the lesser of the capitalization level established by the recipient or subrecipient for financial statement purposes or $10,000, regardless of the length of its useful life.\n\nApplicants/grant recipients must list the items by type of supply (e.g., training materials, desktop computer, laptop, projector, etc.), cost per unit, quantity, or cost per month if rented or leased. \n\nNote: 1) Software subscription services, such as cellular phone service or internet service, and advertising costs are not tangible and must be listed in Other. Cost allocations for supplies that are not broken down by individual item in the narrative must document the methodology used in determining the amount allocated for this line item, per 2 C.F.R. § 200.405(d); and 2) Supplies for participants should be placed in the “Other” line item.\n\nFor each item or cost, include an adequate reason in the Justification of Costs section.",null,null,null,null,null,0,0,0,0,0,0]
["Item","Cost Per Unit","Quantity","Cost Per Month","% Charged to HVRP","Total",0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies[[#This Row],[Cost Per Unit]]<>\"\",Supplies[[#This Row],[Cost Per Unit]]*Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[% Charged to HVRP]],IF(Supplies[[#This Row],[Quantity]]<>\"\",Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12,Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies[[#This Row],[Cost Per Unit]]<>\"\",Supplies[[#This Row],[Cost Per Unit]]*Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[% Charged to HVRP]],IF(Supplies[[#This Row],[Quantity]]<>\"\",Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12,Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies[[#This Row],[Cost Per Unit]]<>\"\",Supplies[[#This Row],[Cost Per Unit]]*Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[% Charged to HVRP]],IF(Supplies[[#This Row],[Quantity]]<>\"\",Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12,Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies[[#This Row],[Cost Per Unit]]<>\"\",Supplies[[#This Row],[Cost Per Unit]]*Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[% Charged to HVRP]],IF(Supplies[[#This Row],[Quantity]]<>\"\",Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12,Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies[[#This Row],[Cost Per Unit]]<>\"\",Supplies[[#This Row],[Cost Per Unit]]*Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[% Charged to HVRP]],IF(Supplies[[#This Row],[Quantity]]<>\"\",Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12,Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies[[#This Row],[Cost Per Unit]]<>\"\",Supplies[[#This Row],[Cost Per Unit]]*Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[% Charged to HVRP]],IF(Supplies[[#This Row],[Quantity]]<>\"\",Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12,Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies[[#This Row],[Cost Per Unit]]<>\"\",Supplies[[#This Row],[Cost Per Unit]]*Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[% Charged to HVRP]],IF(Supplies[[#This Row],[Quantity]]<>\"\",Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12,Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies[[#This Row],[Cost Per Unit]]<>\"\",Supplies[[#This Row],[Cost Per Unit]]*Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[% Charged to HVRP]],IF(Supplies[[#This Row],[Quantity]]<>\"\",Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12,Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies[[#This Row],[Cost Per Unit]]<>\"\",Supplies[[#This Row],[Cost Per Unit]]*Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[% Charged to HVRP]],IF(Supplies[[#This Row],[Quantity]]<>\"\",Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12,Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies[[#This Row],[Cost Per Unit]]<>\"\",Supplies[[#This Row],[Cost Per Unit]]*Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[% Charged to HVRP]],IF(Supplies[[#This Row],[Quantity]]<>\"\",Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12,Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies[[#This Row],[Cost Per Unit]]<>\"\",Supplies[[#This Row],[Cost Per Unit]]*Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[% Charged to HVRP]],IF(Supplies[[#This Row],[Quantity]]<>\"\",Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12,Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies[[#This Row],[Cost Per Unit]]<>\"\",Supplies[[#This Row],[Cost Per Unit]]*Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[% Charged to HVRP]],IF(Supplies[[#This Row],[Quantity]]<>\"\",Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12,Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,{"$f":"IF(Supplies[[#This Row],[Cost Per Unit]]<>\"\",Supplies[[#This Row],[Cost Per Unit]]*Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[% Charged to HVRP]],IF(Supplies[[#This Row],[Quantity]]<>\"\",Supplies[[#This Row],[Quantity]]*Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12,Supplies[[#This Row],[Cost Per Month]]*Supplies[[#This Row],[% Charged to HVRP]]*12))","v":0}]
["Total Supplies",null,null,null,null,{"$f":"SUM(F83:F95)","v":0},0,0,0,0,0,0]
["Total Supplies - Rounded to the Nearest Whole Dollar",null,null,"(must match SF-424A)",null,{"$f":"ROUND(F96,0)","v":0},0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Contractual :\nDescribe contracts and subawards separately. The term “contracts” is defined in 2 C.F.R. § 200.1 and means, for the purpose of federal financial assistance, a legal instrument by which a recipient or subrecipient conducts procurement transactions under a federal award. Contractor means an entity that receives a contract. Subaward means an award provided by a pass-through entity to a subrecipient for the subrecipient to contribute to the goals and objectives of the project by carrying out part of the federal award received by the pass-through entity. It does not include payments to a contractor or payments to an individual that is a beneficiary of a federal program. A subaward may be provided through any form of legal agreement, including an agreement that the pass-through entity considers a contract.\n\nFor each contract or subaward, list the purpose, goods and/or services to be provided, amount, and percent charged to HVRP. In the Justification of Costs section, describe the goods and/or services to be provided by each contractor or sub-awardee and how the goods and/or services relate to the accomplishment of specific project objectives. Phone and copier contracts, agreements, or leases should not be included in this section. \n\nAll procurement transactions for the acquisition of goods and/or services required under an award must be conducted in a manner providing full and open competition consistent with the federal procurement standards in 2 C.F.R. § 200.319 (Competition) and 2 C.F.R. § 200.320 (Methods of procurement to be followed). Applicants/grant recipients must follow their documented procurement procedures that reflect applicable state, local, and tribal laws and regulations. These procedures must also conform to applicable federal laws, regulations, and the standards identified in 2 C.F.R. § 200.318. Applicants/grant recipients must maintain oversight to ensure that contractors and sub-awardees perform in accordance with the terms, conditions, and specifications of their legal agreement. For additional guidance, refer to 2 C.F.R. § 200.318 through 2 C.F.R. § 200.327 on Procurement Standards.",null,null,null,null,null,0,0,0,0,0,0]
["Contract/Subaward","Purpose","Activities to be provided","Amount","% Charged to HVRP","Total",0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"Contractual[[#This Row],[Amount]]*Contractual[[#This Row],[% Charged to HVRP]]","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"Contractual[[#This Row],[Amount]]*Contractual[[#This Row],[% Charged to HVRP]]","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"Contractual[[#This Row],[Amount]]*Contractual[[#This Row],[% Charged to HVRP]]","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"Contractual[[#This Row],[Amount]]*Contractual[[#This Row],[% Charged to HVRP]]","v":0}]
[null,null,null,null,null,{"$f":"Contractual[[#This Row],[Amount]]*Contractual[[#This Row],[% Charged to HVRP]]","v":0}]
[null,null,null,null,null,{"$f":"Contractual[[#This Row],[Amount]]*Contractual[[#This Row],[% Charged to HVRP]]","v":0}]
["Total Contractual",null,null,null,null,{"$f":"SUM(F104:F109)","v":0},0,0,0,0,0,0]
["Total Contractual - Rounded to the Nearest Whole Dollar",null,null,"(must match SF-424A)",null,{"$f":"ROUND(F110,0)","v":0},0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Construction :\nConstruction costs are unallowable under the HVRP grant program; therefore, this budget line item must be zero. Minor alterations to modernize, improve, and/or reconfigure existing space for grant activities (such as a classroom alteration) may be allowable, as this is not considered construction. Applicants/grant recipients must include the costs for minor alterations in the Contractual budget line item.",null,null,null,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Other :\nParticipant Support Costs:  \n\nPer 2 C.F.R. § 200.1, participant support costs mean direct costs that support participants and their involvement in a federal award, such as stipends, subsistence allowances, travel allowances, registration fees, temporary dependent care, and per diem paid directly to or on behalf of participants.\n\nA participant support cost is allowed only when incurred to enable the eligible veteran’s participation in HVRP services and must be tied to a specific HVRP service. It is not meant to cover all the participants’ needs. A participant support cost must be reasonable and necessary to help the participant engage in services and activities related to the employment plan. A participant support cost should not duplicate a service a participant receives from another program (i.e., federal, state, local programs). For specific guidance on Participant Support Costs, please see VPL 06-24 HVRP Requirements and Functions or the most current guidance on this topic. \n\nList participant support costs (e.g., training, clothing, work-related materials, etc.) and provide clear and specific details, including costs and quantity, for each item so that VETS can review factors affecting the allowability of costs as cited in 2 C.F.R. § 200.403. You may also list the support cost per month, if applicable. Note: identify the percentage of the cost that will be charged to the grant.",null,null,null,null,0,0,0,0,0,0,0]
["Item","Cost Per Unit","Quantity","Cost Per Month","% Charged to HVRP","Total",0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF($B120<>\"\",$B120*$C120*$E120,IF($C120<>\"\",$C120*$D120*$E120*12,$D120*$E120*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF($B121<>\"\",$B121*$C121*$E121,IF($C121<>\"\",$C121*$D121*$E121*12,$D121*$E121*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
["Total Participant Support Services",null,null,null,null,{"$f":"SUM(F120:F133)","v":0},0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Other Costs : \nList items or expenses not covered in other budget line items and provide specific details including the costs and quantity for each item. Show the basis for the calculations—break down costs into the cost per unit or rate (e.g., cost per square foot, cost per participant, etc.). You may also estimate the cost per month, if applicable, and the percentage that will be charged to the grant. \n\nIncentives may be provided to active HVRP participants for recognition and achievement directly tied to participation in the program and employment goals. If you plan to use incentive funds, your Budget Narrative must include the planned amount and type of incentives (e.g., gift cards, vouchers, etc.), and the justification must state the criteria for participant issuance, in accordance with VPL 06-24. Planned costs for incentives must be categorized under the “Other” cost category and not as a Participant Support Cost.",null,null,null,null,0,0,0,0,0,0,0]
["Item","Cost Per Unit","Quantity","Cost Per Month","% Charged to HVRP","Total",0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF($B141<>\"\",$B141*$C141*$E141,IF($C141<>\"\",$C141*$D141*$E141*12,$D141*$E141*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
["Total Other Costs",null,null,null,null,{"$f":"SUM(F141:F155)","v":0},0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[]
["Other Total (Participant Support Services + Other)",null,null,null,null,{"$f":"SUM(F134,F156)","v":0},0,0,0,0,0,0]
["Other Total - Rounded to the Nearest Whole Dollar",null,null,null,"(must match SF-424A)",{"$f":"ROUND(F161,0)","v":0},0,0,0,0,0,0]
["Justification of Costs Not Explained Above",null,null,null,null,null,0,0,0,0,0,0]
[" (max 3,225 characters including spaces)",null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Indirect Costs :\nPer 2 C.F.R. § 200.1, indirect cost means those costs incurred for a common or joint purpose benefitting more than one cost objective and not readily assignable to the cost objectives specifically benefited, without effort disproportionate to the results achieved. It may be necessary to establish multiple pools of indirect costs to facilitate equitable distribution of indirect expenses to the cost objectives served. Indirect cost pools must be distributed to benefitted cost objectives on a basis that will produce an equitable result in consideration of the relative benefits derived.\n\nInclude the type of rate or agreement (e.g., Negotiated Indirect Costs Rate Agreement [NICRA], Cost Allocation Plan [CAP], or the de minimis rate of 15 percent of modified total direct costs [MTDC]), the total approved base (if applicable), and the approved rate (if applicable).\n\nIf using a NICRA, in the Justification of Costs section, provide an explanation of how the indirect costs are calculated and the authorized from/to date of approval. This explanation should include which portion of each line item, along with the associated costs, is included in your allocation base.",null,null,null,0,0,0,0,0,0,0,0]
["\nRegarding the de minimis rate, applicants/grant recipients and subrecipients that do not have a current federal negotiated indirect cost rate (including provisional rate) may elect to charge a de minimis rate of up to 15 percent of MTDC. The recipient or subrecipient is authorized to determine the appropriate rate up to this limit, in accordance with 2 C.F.R. § 200.414(f). Additionally, applicants/grant recipients and subrecipients are not required to use the de minimis rate. If using the de minimis rate of 15 percent of MTDC, in the Justification of Costs section, provide an explanation of which portion of each line item, along with the associated costs, is included in your allocation base. Note that there are various items not included in the calculation of MTDC. \n\nPer 2 C.F.R. § 100, MTDC means all direct salaries and wages, applicable fringe benefits, materials and supplies, services, travel, and up to the first $50,000 of each subaward (regardless of the period of performance of the subawards under the award). MTDC excludes equipment, capital expenditures, charges for patient care, rental costs, tuition remission, scholarships and fellowships, participant support costs, and the portion of each subaward more than $50,000. Other items may only be excluded when necessary to avoid serious inequity in the distribution of indirect costs and with the approval of the cognizant agency for indirect costs.\n\nYou must exclude Participant Support Costs from your MTDC. For more information on rental costs, see 2 C.F.R. § 200.465 rental costs of real property and equipment.\n\nIf using a CAP, in the Justification of Costs section, provide the estimated indirect costs based on your approved allocation methodology."]
["Type of Rate Agreement","Base","Rate","Total Indirect Costs",0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(OR(Indirect_Costs[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C171*B171,B171)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(OR(Indirect_Costs[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C172*B172,B172)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(OR(Indirect_Costs[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C173*B173,B173)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(OR(Indirect_Costs[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C174*B174,B174)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(OR(Indirect_Costs[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C175*B175,B175)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(OR(Indirect_Costs[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C176*B176,B176)","v":0}]
[null,null,null,{"$f":"IF(OR(Indirect_Costs[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C177*B177,B177)","v":0}]
["Total Indirect Costs",null,null,{"$f":"SUM(D171:D177)","v":0},0,0,0,0,0,0,0,0]
["Total Indirect Costs - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",{"$f":"ROUND(D178,0)","v":0},0,0,0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Total Costs","Totals",0,0,0,0,0,0,0,0,0,0]
["Total Direct Costs",{"$f":"SUM(F162,F111,F97,J55,D35,D19,E75)","v":0},0,0,0,null,0,0,0,0,0,0]
["Total Indirect Costs",{"$f":"D179","v":0},0,0,0,null,0,0,0,0,0,0]
["Total Costs funded by Grant \n(must match the total on the SF-424 and SF-424A, as well as the specific year this budget is for on the VETS-704 Abstract)",{"$f":"SUM(B185:B186)","v":0},{"$f":"IF(Total_Costs[[#This Row],[Totals]]>500000, \"This amount exceeds the allowed 12-month budget ceiling for HVRP. Please revise.\",\"\")","v":""},{"$f":"IF(Total_Costs[[#This Row],[Totals]] > Enter_VETS_704_Form_Abstract_and_Planned_Chart_Request_Year_1_Amount,\n    \"This amount exceeds your Year 1 requested amount listed at the beginning of this budget form.\",\n    IF(Total_Costs[[#This Row],[Totals]] < Enter_VETS_704_Form_Abstract_and_Planned_Chart_Request_Year_1_Amount,\n        \"This amount is less than the First PY Requested Amount. Please Revise\",\n        \"\")\n)","v":""},0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Leveraged Resources :\nThe HVRP grant program does not require cost sharing or matching funds. Applicants/grant recipients that are not using federal grant funds to support grant activities must provide a description of leveraged resources. DOL/VETS considers any resources contributed to the project, beyond the funds provided by the agency, as leveraged resources. Applicants/grant recipients are encouraged to leverage resources to increase stakeholder investment in the project and broaden and sustain the impact of the project itself. The Budget Narrative should provide a description of the leveraged resources provided to support grant activities, the specific activities they will cover, the way they will support HVRP goals, and the funding source. Valuation of leveraged resources follows the same requirements as cost sharing.",null,null,null,0,0,0,0,0,0,0,0]
["Description of Leveraged Resources (max 3,225 characters including spaces)",null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Additional space for narrative justification not described above",null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
["**DOL/VETS does not allow the purchase of construction, motor vehicles, buildings, or land.",null,null,0,0,0,0,0,0,0,0,0]
["2 C.F.R. § 200.403",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R § 200 Subpart E",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R. § 200.404",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R § 200.431",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R § 200.475(a)",0,0,0,0,0,0,0,0,0,0,0]
["41 C.F.R Subtitle F",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R § 200.475",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R. §200.1",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R. § 200.319 ",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R. §200.320",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R § 200.318",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R. § 200.327",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R. § 200.403",0,0,0,0,0,0,0,0,0,0,0]
["END OF DOCUMENT"]

{"sheet":"Second PY Budget","index":2,"n_rows":204,"n_cols":12,"rows_kept":204,"cut":false,"hidden":true,"merged":[[149,7,149,11],[128,7,128,11],[95,0,95,5],[125,7,125,11],[126,7,126,11],[148,7,148,11],[147,7,147,11],[145,7,145,11],[146,7,146,11],[109,0,109,5],[132,0,132,5],[134,0,134,4],[188,0,188,3],[185,0,185,3],[176,0,176,3],[184,0,184,3],[187,0,187,3],[162,0,162,3],[163,0,163,3],[183,0,183,3],[154,0,154,5],[160,0,160,5],[76,0,76,5],[97,0,97,5],[111,0,111,3],[113,0,113,4],[8,0,8,3],[73,0,73,4],[57,0,57,4],[1,0,1,3],[2,0,2,3],[39,0,39,9],[55,0,55,9],[2,5,2,11],[5,0,5,3],[7,0,7,3],[23,0,23,3],[38,0,38,9],[36,0,36,3],[21,0,21,3],[6,0,6,3],[3,1,3,2],[4,1,4,2]]}
["Accessibility key:  Users may only edit unlocked cells, these unlocked cells are highlighted in yellow. If the user is experiencing macro-related issues, the alt text of the relevant images in cell F3 will notify them about the links that assist in resolving the issue."]
["HVRP Budget Narrative Template version 2.2",null,null,null,0,0,0,0,0,0,0,0]
["Applicants/grant recipients must demonstrate that their proposed costs are allowable (2 C.F.R. § 200.403). In other words, costs must be necessary and reasonable for the performance of the federal award and must be allocable under the cost principles in 2 C.F.R. Part 200, Subpart E. A cost is “necessary” if it meets a program objective and is necessary and reasonable for the performance of the Homeless Veterans' Reintegration Program (HVRP). A cost is “reasonable” if it does not exceed an amount that a prudent person would incur under the circumstances prevailing when the decision was made to incur the cost (2 C.F.R. § 200.404). Shared costs among multiple programs or projects must be proportionate (e.g., If a Program Manager works HVRP 20 percent of the time, the amount charged to HVRP for items such as the Program Manager's cell phone or laptop would be cost-shared among the other programs).\n\nIf charging indirect costs in Section B 6.j of the SF-424A, Indirect Charges, ensure costs are not duplicated under any of the direct costs categories. Costs must not be duplicated or inconsistently charged; costs must be charged as either indirect or direct costs, but not both.\n\nThe Budget Narrative must include a justification for all proposed costs and align with the SF-424A and the estimated federal funding amount in Section 18.a of the SF-424. The Budget Narrative must be consistent with and support the activities, resources, staff, and other items described in the project narrative.\n\nThe total one-year budget must not exceed the total one-year budget specified in the VETS-704 Form – Abstract and Planned Goals Chart, nor the annual maximum outlined in the award information section of the original Funding Opportunity Announcement applied under.  \n\nTo add more rows or space to any budget line-item, select the “Add” button to the right of the field.\n\nDo not copy and paste from one Spreadsheet to another in this workbook as this may alter pre-set formulas. \n\nIf your Justification text exceeds the character limit in a category, please utilize the Add Space to Justification button. If further space is needed, then use Additional Space for Narrative Justification section located at the bottom of this form.\n\nEnsure that all text is visible in the Excel File. GrantSolutions creates a PDF of this form, and all justification text must be visible. ",null,null,null,0,"If you encounter either of these warnings, please click the image for support:"]
[null,"Enter VETS-704 Form Abstract and Planned Chart Request Year 2 Amount"]
[{"$f":"IF(Applicant_or_Grant_recipient_name=\"\", \"Enter Organization name in the First PY Budget Year tab.\",Applicant_or_Grant_recipient_name)","v":"Enter Organization name in the First PY Budget Year tab."}]
["Budget Year 2"]
["Please DO NOT copy and paste from other Spreadsheet tabs"]
["Personnel: \nList all staff positions by title (both current and proposed) and provide the hourly wage, the percentage of time charged to the project (100% is 2,080 hours) and the annual salary for each position funded by the grant. Do not list positions that will be covered under Indirect Costs. Grant recipients that charge Personnel positions among multiple HVRP grants cannot exceed 100 percent FTE collectively among potential and active grants.\n\nIn the Justification of Costs section, include the corresponding roles and responsibilities for each position.",null,null,null,null,0,0,0,0,0,0,0]
["See the HVRP Glossary of Terms for Personnel position/staff definitions and examples."]
["Job or Position Title","Hourly Wage","% of FTE","Actual Annual Salary",0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"(B11*(C11*2080))","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"(B12*(C12*2080))","v":0},0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,0]
[null,null,null,0]
["Total Personnel",null,null,{"$f":"SUM(D11:D17)","v":0},0,0,0,0,0,0,0]
["Total Personnel - Rounded to the Nearest Whole Dollar- (must match SF-424A)",null,null,{"$f":"ROUND(D18,0)","v":0},0,0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Fringe Benefits:\nProvide information on the rate of all fringe benefits used and the basis for the calculation. If not using a fringe benefits rate, itemize how the fringe benefits amount is computed in the Justification of Costs section.\n\nFringe benefits may be in the form of employer contributions or expenses for FICA (Social Security and Medicare tax), employee life, health, unemployment, and/or worker's compensation insurance, paid absences, and other similar reasonable and allowable benefits as required by law, organization – employee agreement, or established written policies of the applicant/recipient organization per 2 C.F.R. § 200.431. Fringe benefits are for the personnel listed in budget category (a) and are only for the percentage of time devoted to the project.\n\nAn example of calculating fringe benefits based on base wages: The federal unemployment tax rate is 6% on the first $7,000 of wages, according to IRS Publication 15: Employers Tax Guide. This means $7,000 × 0.06 = $420 per full-time employee (FTE). The state unemployment tax rate is 5.4% on a $10,000 base wage, according to State Unemployment Compensation Law. This means $10,000 × 0.054 = $540 per FTE.",null,null,null,0,0,0,0,0,0,0,0]
["Description ","Base","Rate","Cost",0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"C26*B26","v":0},0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
["Total Fringe Benefits",null,{"$f":"SUM(C26:C32)","v":0},{"$f":"SUM(D26:D32)","v":0},0,0,0,0,0,0,0,0]
["Total Fringe Benefits - Rounded to the Nearest Whole Dollar- (must match SF-424A)",null,null,{"$f":"ROUND(D33,0)","v":0},0,0,0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Travel (for grant recipient staff only ):\nThis section is for grant recipient staff only. Per 2 C.F.R. § 200.475(a), applicants/grant recipients must have policies in place related to travel costs.\n\nIn the absence of an established written policy regarding travel costs, the rates and amounts established under 5 U.S.C. §§ 5701–11 (‘‘Travel and Subsistence Expenses; Mileage Allowances”), by the Administrator of General Services, or by the President (or their designee) pursuant to any provisions of such subchapter must apply to travel under federal awards (48 C.F.R. § 31.205–46(a)). \n\nFor reimbursement on a mileage basis, the HVRP grant program cannot be charged more than the maximum allowable mileage reimbursement rates authorized for federal employees. Mileage rates must be checked annually at the U.S. General Services Administration (GSA)GSA’s Privately Owned Vehicle (POV) Mileage Reimbursement Rates webpage to ensure compliance.\n\nLocal Travel – It is not necessary to specify the exact locations of each trip, as it will be fluid based on participants, employers, and outreach opportunities. \n\nOut-of-State or In-State Overnight Travel – Requires specific start date/time and destination locations so DOL/VETS can determine whether the per diem and/or lodging costs are reasonable. This travel could also include allowable expenses to cover travel to DOL-sponsored training events such as the region or state annual post-award conferences, professional conferences, and/or any other offered training. The National Post Award Conference is virtual, so do not include travel costs for that event. Identify the name and location of the conference that staff will attend. Staff should not claim full day per diem rates for the first and last day of travel. Lodging and per diem expenditures must not exceed the rates established by GSA for the location of your trip. Find your per diem and lodging rates on the GSA Per Diem Rates webpage.\n\nTravel for participants (e.g., travel stipends for program participants) should be specifically itemized and placed in the Other category. \n\nInclude the basis of computation (e.g., six people to three-day training at $X airfare, $X lodging, $X subsistence) for each travel expense. Specify the purpose, location (e.g., location or whether in-state or out-of-state), type of expense (select from dropdown), basis (e.g., round-trip, day/night, mileage, etc.), cost or cost and quantity (e.g., number of nights or miles), number of staff traveling, and number of trips for each type of travel. Some cells may automatically turn gray based on the choice you make in the dropdown menu.\n\nApplicants/grant recipients must provide a justification for travel expenditures that exceed 10 percent of this one-year budget.  ",null,null,null,null,null,null,null,null,null,0,0]
["click here to look up the most current FY GSA per diem rates: https://www.gsa.gov/travel/plan-book/per-diem-rates",null,null,null,null,null,null,null,null,null,0,0]
["Purpose","Location","Type of Expense","Basis","Cost","Quantity","# of Staff","# of Trips","% Charged to HVRP","Total Cost",0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel1[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel1[[#This Row],[Basis]]=\"Round-Trip\",Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]],Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Staff]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel1[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel1[[#This Row],[Basis]]=\"Round-Trip\",Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]],Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Staff]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel1[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel1[[#This Row],[Basis]]=\"Round-Trip\",Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]],Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Staff]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel1[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel1[[#This Row],[Basis]]=\"Round-Trip\",Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]],Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Staff]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel1[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel1[[#This Row],[Basis]]=\"Round-Trip\",Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]],Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Staff]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel1[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel1[[#This Row],[Basis]]=\"Round-Trip\",Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]],Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Staff]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel1[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel1[[#This Row],[Basis]]=\"Round-Trip\",Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]],Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Staff]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel1[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel1[[#This Row],[Basis]]=\"Round-Trip\",Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]],Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Staff]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel1[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel1[[#This Row],[Basis]]=\"Round-Trip\",Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]],Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Staff]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel1[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel1[[#This Row],[Basis]]=\"Round-Trip\",Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]],Travel1[[#This Row],[Cost]]*Travel1[[#This Row],[Quantity]]*Travel1[[#This Row],['# of Staff]]*Travel1[[#This Row],['# of Trips]]*Travel1[[#This Row],[% Charged to HVRP]]),0)","v":0}]
["Total Travel",null,null,null,null,null,null,null,null,{"$f":"SUM(J42:J51)","v":0},0,0]
["Total Travel - Rounded to the Nearest Whole Dollar- (must match SF-424A)",null,null,null,null,null,null,null,null,{"$f":"ROUND(J52,0)","v":0},0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Equipment :\nPer 2 C.F.R. § 200.1, “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 recipient or subrecipient for financial statement purposes or $10,000. Items with a unit cost of less than $10,000 are supplies, not “equipment.” DOL/VETS does not allow the purchase of motor vehicles, buildings, or land.\n\nApplicants/grant recipients must list the item, quantity, and unit cost per item. In the Justification of Costs section, describe the need for the equipment, i.e., explain how the use of each item of equipment is related to the implementation of the required/approved activities to achieve the specific project objectives. List expendable items or materials in Supplies. DOL/VETS does not permit the purchase of equipment during the last funded year of the award.",null,null,null,null,0,0,0,0,0,0,0]
["Item","Quantity","Cost Per Unit","% Charged to HVRP","Total",0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"(B60*C60*D60)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"(B61*C61*D61)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
["Total Equipment",null,null,null,{"$f":"SUM(E60:E69)","v":0},0,0,0,0,0,0,0]
["Total Equipment - Rounded to the Nearest Whole Dollar- (must match SF-424A)",null,null,null,{"$f":"ROUND(E70,0)","v":0},0,0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Supplies :\nPer 2 C.F.R. § 200.1, “supplies” means all tangible personal property other than those described in the equipment definition. A computing device is a supply if the acquisition cost is below the lesser of the capitalization level established by the recipient or subrecipient for financial statement purposes or $10,000, regardless of the length of its useful life.\n\nApplicants/grant recipients must list the items by type of supply (e.g., training materials, desktop computer, laptop, projector, etc.), cost per unit, quantity, or cost per month if rented or leased. \n\nNote: 1) Software subscription services, such as cellular phone service or internet service, and advertising costs are not tangible and must be listed in Other. Cost allocations for supplies that are not broken down by individual item in the narrative must document the methodology used in determining the amount allocated for this line item, per 2 C.F.R. § 200.405(d); and 2) Supplies for participants should be placed in the “Other” line item.\n\nFor each item or cost, include an adequate reason in the Justification of Costs section.\n\nProject startup costs (e.g., purchase of laptops, printers, and supplies with a useful life of more than one program year’s budget) should not be written into the second- or third-year budget.",null,null,null,null,null,0,0,0,0,0,0]
["Item","Cost Per Unit","Quantity","Cost Per Month","% Charged to HVRP","Total",0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies1[[#This Row],[Cost Per Unit]]<>\"\",Supplies1[[#This Row],[Cost Per Unit]]*Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[% Charged to HVRP]],IF(Supplies1[[#This Row],[Quantity]]<>\"\",Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12,Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies1[[#This Row],[Cost Per Unit]]<>\"\",Supplies1[[#This Row],[Cost Per Unit]]*Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[% Charged to HVRP]],IF(Supplies1[[#This Row],[Quantity]]<>\"\",Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12,Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies1[[#This Row],[Cost Per Unit]]<>\"\",Supplies1[[#This Row],[Cost Per Unit]]*Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[% Charged to HVRP]],IF(Supplies1[[#This Row],[Quantity]]<>\"\",Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12,Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies1[[#This Row],[Cost Per Unit]]<>\"\",Supplies1[[#This Row],[Cost Per Unit]]*Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[% Charged to HVRP]],IF(Supplies1[[#This Row],[Quantity]]<>\"\",Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12,Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies1[[#This Row],[Cost Per Unit]]<>\"\",Supplies1[[#This Row],[Cost Per Unit]]*Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[% Charged to HVRP]],IF(Supplies1[[#This Row],[Quantity]]<>\"\",Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12,Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies1[[#This Row],[Cost Per Unit]]<>\"\",Supplies1[[#This Row],[Cost Per Unit]]*Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[% Charged to HVRP]],IF(Supplies1[[#This Row],[Quantity]]<>\"\",Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12,Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies1[[#This Row],[Cost Per Unit]]<>\"\",Supplies1[[#This Row],[Cost Per Unit]]*Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[% Charged to HVRP]],IF(Supplies1[[#This Row],[Quantity]]<>\"\",Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12,Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies1[[#This Row],[Cost Per Unit]]<>\"\",Supplies1[[#This Row],[Cost Per Unit]]*Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[% Charged to HVRP]],IF(Supplies1[[#This Row],[Quantity]]<>\"\",Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12,Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies1[[#This Row],[Cost Per Unit]]<>\"\",Supplies1[[#This Row],[Cost Per Unit]]*Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[% Charged to HVRP]],IF(Supplies1[[#This Row],[Quantity]]<>\"\",Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12,Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies1[[#This Row],[Cost Per Unit]]<>\"\",Supplies1[[#This Row],[Cost Per Unit]]*Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[% Charged to HVRP]],IF(Supplies1[[#This Row],[Quantity]]<>\"\",Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12,Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies1[[#This Row],[Cost Per Unit]]<>\"\",Supplies1[[#This Row],[Cost Per Unit]]*Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[% Charged to HVRP]],IF(Supplies1[[#This Row],[Quantity]]<>\"\",Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12,Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,{"$f":"IF(Supplies1[[#This Row],[Cost Per Unit]]<>\"\",Supplies1[[#This Row],[Cost Per Unit]]*Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[% Charged to HVRP]],IF(Supplies1[[#This Row],[Quantity]]<>\"\",Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12,Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,{"$f":"IF(Supplies1[[#This Row],[Cost Per Unit]]<>\"\",Supplies1[[#This Row],[Cost Per Unit]]*Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[% Charged to HVRP]],IF(Supplies1[[#This Row],[Quantity]]<>\"\",Supplies1[[#This Row],[Quantity]]*Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12,Supplies1[[#This Row],[Cost Per Month]]*Supplies1[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
["Total Supplies",null,null,null,null,{"$f":"SUM(F79:F91)","v":0},0,0,0,0,0,0]
["Total Supplies - Rounded to the Nearest Whole Dollar",null,null,"(must match SF-424A)",null,{"$f":"ROUND(F92,0)","v":0},0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Contractual :\nDescribe contracts and subawards separately. The term “contracts” is defined in 2 C.F.R. § 200.1 and means, for the purpose of federal financial assistance, a legal instrument by which a recipient or subrecipient conducts procurement transactions under a federal award. Contractor means an entity that receives a contract. Subaward means an award provided by a pass-through entity to a subrecipient for the subrecipient to contribute to the goals and objectives of the project by carrying out part of the federal award received by the pass-through entity. It does not include payments to a contractor or payments to an individual that is a beneficiary of a federal program. A subaward may be provided through any form of legal agreement, including an agreement that the pass-through entity considers a contract.\n\nFor each contract or subaward, list the purpose, goods and/or services to be provided, amount, and percent charged to HVRP. In the Justification of Costs section, describe the goods and/or services to be provided by each contractor or sub-awardee and how the goods and/or services relate to the accomplishment of specific project objectives. Phone and copier contracts, agreements, or leases should not be included in this section. \n\nAll procurement transactions for the acquisition of goods and/or services required under an award must be conducted in a manner providing full and open competition consistent with the federal procurement standards in 2 C.F.R. § 200.319 (Competition) and 2 C.F.R. § 200.320 (Methods of procurement to be followed). Applicants/grant recipients must follow their documented procurement procedures that reflect applicable state, local, and tribal laws and regulations. These procedures must also conform to applicable federal laws, regulations, and the standards identified in 2 C.F.R. § 200.318. Applicants/grant recipients must maintain oversight to ensure that contractors and sub-awardees perform in accordance with the terms, conditions, and specifications of their legal agreement. For additional guidance, refer to 2 C.F.R. § 200.318 through 2 C.F.R. § 200.327 on Procurement Standards.",null,null,null,null,null,0,0,0,0,0,0]
["Contract/Subaward","Purpose","Activities to be provided","Amount","% Charged to HVRP","Total",0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"Contractual1[[#This Row],[Amount]]*Contractual1[[#This Row],[% Charged to HVRP]]","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"Contractual1[[#This Row],[Amount]]*Contractual1[[#This Row],[% Charged to HVRP]]","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"Contractual1[[#This Row],[Amount]]*Contractual1[[#This Row],[% Charged to HVRP]]","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"Contractual1[[#This Row],[Amount]]*Contractual1[[#This Row],[% Charged to HVRP]]","v":0}]
[null,null,null,null,null,{"$f":"Contractual1[[#This Row],[Amount]]*Contractual1[[#This Row],[% Charged to HVRP]]","v":0}]
[null,null,null,null,null,{"$f":"Contractual1[[#This Row],[Amount]]*Contractual1[[#This Row],[% Charged to HVRP]]","v":0}]
["Total Contractual",null,null,null,null,{"$f":"SUM(F100:F105)","v":0},0,0,0,0,0,0]
["Total Contractual - Rounded to the Nearest Whole Dollar",null,null,"(must match SF-424A)",null,{"$f":"ROUND(F106,0)","v":0},0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Construction :\nConstruction costs are unallowable under the HVRP grant program; therefore, this budget line item must be zero. Minor alterations to modernize, improve, and/or reconfigure existing space for grant activities (such as a classroom alteration) may be allowable, as this is not considered construction. Applicants/grant recipients must include the costs for minor alterations in the Contractual budget line item.",null,null,null,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Other :\nParticipant Support Costs:  \n\nPer 2 C.F.R. § 200.1, participant support costs mean direct costs that support participants and their involvement in a federal award, such as stipends, subsistence allowances, travel allowances, registration fees, temporary dependent care, and per diem paid directly to or on behalf of participants.\n\nA participant support cost is allowed only when incurred to enable the eligible veteran’s participation in HVRP services and must be tied to a specific HVRP service. It is not meant to cover all the participants’ needs. A participant support cost must be reasonable and necessary to help the participant engage in services and activities related to the employment plan. A participant support cost should not duplicate a service a participant receives from another program (i.e., federal, state, local programs). For specific guidance on Participant Support Costs, please see VPL 06-24 HVRP Requirements and Functions or the most current guidance on this topic. \n\nList participant support costs (e.g., training, clothing, work-related materials, etc.) and provide clear and specific details, including costs and quantity, for each item so that VETS can review factors affecting the allowability of costs as cited in 2 C.F.R. § 200.403. You may also list the support cost per month, if applicable. Note: identify the percentage of the cost that will be charged to the grant.\n\nProject startup costs (e.g., office furniture, PPE equipment, other items with a useful life of more than one program year’s budget) should not be written into the second- or third-year budget.",null,null,null,null,0,0,0,0,0,0,0]
["Item","Cost Per Unit","Quantity","Cost Per Month","% Charged to HVRP","Total",0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF($B116<>\"\",$B116*$C116*$E116,IF($C116<>\"\",$C116*$D116*$E116*12,$D116*$E116*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF($B117<>\"\",$B117*$C117*$E117,IF($C117<>\"\",$C117*$D117*$E117*12,$D117*$E117*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0]
["Total Participant Support Services",null,null,null,null,{"$f":"SUM(F116:F129)","v":0},0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Other Costs : \nList items or expenses not covered in other budget line items and provide specific details including the costs and quantity for each item. Show the basis for the calculations—break down costs into the cost per unit or rate (e.g., cost per square foot, cost per participant, etc.). You may also estimate the cost per month, if applicable, and the percentage that will be charged to the grant. \n\nIncentives may be provided to active HVRP participants for recognition and achievement directly tied to participation in the program and employment goals. If you plan to use incentive funds, your Budget Narrative must include the planned amount and type of incentives (e.g., gift cards, vouchers, etc.), and the justification must state the criteria for participant issuance, in accordance with VPL 06-24. Planned costs for incentives must be categorized under the “Other” cost category and not as a Participant Support Cost.",null,null,null,null,0,0,0,0,0,0,0]
["Item","Cost Per Unit","Quantity","Cost Per Month","% Charged to HVRP","Total",0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF($B137<>\"\",$B137*$C137*$E137,IF($C137<>\"\",$C137*$D137*$E137*12,$D137*$E137*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
["Total Other Costs",null,null,null,null,{"$f":"SUM(F137:F151)","v":0},0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
["Other Total (Participant Support Services + Other)",null,null,null,null,{"$f":"SUM(F130,F152)","v":0},0,0,0,0,0,0]
["Other Total - Rounded to the Nearest Whole Dollar",null,null,null,"(must match SF-424A)",{"$f":"ROUND(F156,0)","v":0},0,0,0,0,0,0]
["Justification of Costs Not Explained Above",null,null,null,null,null,0,0,0,0,0,0]
[" (max 3,225 characters including spaces)",null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Indirect Costs :\nPer 2 C.F.R. § 200.1, indirect cost means those costs incurred for a common or joint purpose benefitting more than one cost objective and not readily assignable to the cost objectives specifically benefited, without effort disproportionate to the results achieved. It may be necessary to establish multiple pools of indirect costs to facilitate equitable distribution of indirect expenses to the cost objectives served. Indirect cost pools must be distributed to benefitted cost objectives on a basis that will produce an equitable result in consideration of the relative benefits derived.\n\nInclude the type of rate or agreement (e.g., Negotiated Indirect Costs Rate Agreement [NICRA], Cost Allocation Plan [CAP], or the de minimis rate of 15 percent of modified total direct costs [MTDC]), the total approved base (if applicable), and the approved rate (if applicable).\n\nIf using a NICRA, in the Justification of Costs section, provide an explanation of how the indirect costs are calculated and the authorized from/to date of approval. This explanation should include which portion of each line item, along with the associated costs, is included in your allocation base.\n",null,null,null,0,0,0,0,0,0,0,0]
["\nRegarding the de minimis rate, applicants/grant recipients and subrecipients that do not have a current federal negotiated indirect cost rate (including provisional rate) may elect to charge a de minimis rate of up to 15 percent of MTDC. The recipient or subrecipient is authorized to determine the appropriate rate up to this limit, in accordance with 2 C.F.R. § 200.414(f). Additionally, applicants/grant recipients and subrecipients are not required to use the de minimis rate. If using the de minimis rate of 15 percent of MTDC, in the Justification of Costs section, provide an explanation of which portion of each line item, along with the associated costs, is included in your allocation base. Note that there are various items not included in the calculation of MTDC. \n\nPer 2 C.F.R. § 100, MTDC means all direct salaries and wages, applicable fringe benefits, materials and supplies, services, travel, and up to the first $50,000 of each subaward (regardless of the period of performance of the subawards under the award). MTDC excludes equipment, capital expenditures, charges for patient care, rental costs, tuition remission, scholarships and fellowships, participant support costs, and the portion of each subaward more than $50,000. Other items may only be excluded when necessary to avoid serious inequity in the distribution of indirect costs and with the approval of the cognizant agency for indirect costs.\n\nYou must exclude Participant Support Costs from your MTDC. For more information on rental costs, see 2 C.F.R. § 200.465 rental costs of real property and equipment.\n\nIf using a CAP, in the Justification of Costs section, provide the estimated indirect costs based on your approved allocation methodology."]
["Type of Rate Agreement","Base","Rate","Total Indirect Costs",0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(OR(Indirect_Costs1[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs1[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C166*B166,B166)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(OR(Indirect_Costs1[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs1[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C167*B167,B167)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(OR(Indirect_Costs1[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs1[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C168*B168,B168)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(OR(Indirect_Costs1[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs1[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C169*B169,B169)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(OR(Indirect_Costs1[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs1[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C170*B170,B170)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(OR(Indirect_Costs1[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs1[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C171*B171,B171)","v":0}]
[null,null,null,{"$f":"IF(OR(Indirect_Costs1[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs1[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C172*B172,B172)","v":0}]
["Total Indirect Costs",null,null,{"$f":"SUM(D166:D172)","v":0},0,0,0,0,0,0,0,0]
["Total Indirect Costs - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",{"$f":"ROUND(D173,0)","v":0},0,0,0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Total Costs","Totals",0,0,0,0,0,0,0,0,0,0]
["Total Direct Costs",{"$f":"SUM(F157,F107,F93,J53,D34,D19,E71)","v":0},0,0,0,null,0,0,0,0,0,0]
["Total Indirect Costs",{"$f":"D174","v":0},0,0,0,null,0,0,0,0,0,0]
["Total Costs funded by Grant \n(must match the total on the SF-424 and SF-424A, as well as the specific year this budget is for on the VETS-704 Abstract)",{"$f":"SUM(B180:B181)","v":0},{"$f":"IF(Total_Costs1[[#This Row],[Totals]]>500000, \"This amount exceeds the allowed 12-month budget ceiling for HVRP. Please revise.\",\"\")","v":""},{"$f":"IF(Total_Costs1[[#This Row],[Totals]] > Enter_VETS_704_Form_Abstract_and_Planned_Chart_Request_Year_2_Amount,\n    \"This amount exceeds your Year 2 requested amount listed at the beginning of this budget form.\",\n    IF(Total_Costs1[[#This Row],[Totals]] < Enter_VETS_704_Form_Abstract_and_Planned_Chart_Request_Year_2_Amount,\n        \"This amount is less than the Second PY Requested Amount. Please Revise\",\n        \"\")\n)","v":""},0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Leveraged Resources :\nThe HVRP grant program does not require cost sharing or matching funds. Applicants/grant recipients that are not using federal grant funds to support grant activities must provide a description of leveraged resources. DOL/VETS considers any resources contributed to the project, beyond the funds provided by the agency, as leveraged resources. Applicants/grant recipients are encouraged to leverage resources to increase stakeholder investment in the project and broaden and sustain the impact of the project itself. The Budget Narrative should provide a description of the leveraged resources provided to support grant activities, the specific activities they will cover, the way they will support HVRP goals, and the funding source. Valuation of leveraged resources follows the same requirements as cost sharing.",null,null,null,0,0,0,0,0,0,0,0]
["Description of Leveraged Resources (max 3,225 characters including spaces)",null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Additional space for narrative justification not described above",null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
["**DOL/VETS does not allow the purchase of construction, motor vehicles, buildings, or land.",null,null,0,0,0,0,0,0,0,0,0]
["2 C.F.R. § 200.403",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R § 200 Subpart E",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R. § 200.404",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R § 200.431",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R § 200.475(a)",0,0,0,0,0,0,0,0,0,0,0]
["41 C.F.R Subtitle F",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R § 200.475",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R. §200.1",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R. § 200.319 ",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R. §200.320",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R § 200.318",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R. § 200.327",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R. § 200.403",0,0,0,0,0,0,0,0,0,0,0]
["END OF DOCUMENT"]

{"sheet":"Third PY Budget","index":3,"n_rows":207,"n_cols":12,"rows_kept":207,"cut":false,"hidden":true,"merged":[[157,0,157,5],[98,0,98,5],[100,0,100,5],[79,0,79,5],[24,0,24,3],[39,0,39,9],[128,7,128,11],[129,7,129,11],[114,0,114,3],[116,0,116,4],[135,0,135,5],[148,7,148,11],[152,7,152,11],[151,7,151,11],[137,0,137,4],[149,7,149,11],[191,0,191,3],[179,0,179,3],[187,0,187,3],[188,0,188,3],[163,0,163,5],[190,0,190,3],[165,0,165,3],[166,0,166,3],[186,0,186,3],[1,0,1,3],[2,0,2,3],[2,5,2,11],[5,0,5,3],[7,0,7,3],[4,1,4,2],[3,1,3,2],[6,0,6,3],[153,7,153,11],[131,7,131,11],[112,0,112,5],[8,0,8,3],[40,0,40,9],[58,0,58,9],[76,0,76,4],[60,0,60,4],[37,0,37,3],[21,0,22,3],[150,7,150,11]]}
["Accessibility key:  Users may only edit unlocked cells, these unlocked cells are highlighted in yellow. If the user is experiencing macro-related issues, the alt text of the relevant images in cell F3 will notify them about the links that assist in resolving the issue."]
["HVRP Budget Narrative Template version 2.2",null,null,null,0,0,0,0,0,0,0,0]
["Applicants/grant recipients must demonstrate that their proposed costs are allowable (2 C.F.R. § 200.403). In other words, costs must be necessary and reasonable for the performance of the federal award and must be allocable under the cost principles in 2 C.F.R. Part 200, Subpart E. A cost is “necessary” if it meets a program objective and is necessary and reasonable for the performance of the Homeless Veterans' Reintegration Program (HVRP). A cost is “reasonable” if it does not exceed an amount that a prudent person would incur under the circumstances prevailing when the decision was made to incur the cost (2 C.F.R. § 200.404). Shared costs among multiple programs or projects must be proportionate (e.g., If a Program Manager works HVRP 20 percent of the time, the amount charged to HVRP for items such as the Program Manager's cell phone or laptop would be cost-shared among the other programs).\n\nIf charging indirect costs in Section B 6.j of the SF-424A, Indirect Charges, ensure costs are not duplicated under any of the direct costs categories. Costs must not be duplicated or inconsistently charged; costs must be charged as either indirect or direct costs, but not both.\n\nThe Budget Narrative must include a justification for all proposed costs and align with the SF-424A and the estimated federal funding amount in Section 18.a of the SF-424. The Budget Narrative must be consistent with and support the activities, resources, staff, and other items described in the project narrative.\n\nThe total one-year budget must not exceed the total one-year budget specified in the VETS-704 Form – Abstract and Planned Goals Chart, nor the annual maximum outlined in the award information section of the original Funding Opportunity Announcement applied under.  \n\nTo add more rows or space to any budget line-item, select the “Add” button to the right of the field.\n\nDo not copy and paste from one Spreadsheet to another in this workbook as this may alter pre-set formulas. \n\nIf your Justification text exceeds the character limit in a category, please utilize the Add Space to Justification button. If further space is needed, then use Additional Space for Narrative Justification section located at the bottom of this form.\n\nEnsure that all text is visible in the Excel File. GrantSolutions creates a PDF of this form, and all justification text must be visible. ",null,null,null,0,"If you encounter either of these warnings, please click the image for support:"]
[null,"Enter VETS-704 Form Abstract and Planned Chart Request Year 2 Amount"]
[{"$f":"IF(Applicant_or_Grant_recipient_name=\"\", \"Enter Organization name in the First PY Budget Year tab.\",Applicant_or_Grant_recipient_name)","v":"Enter Organization name in the First PY Budget Year tab."}]
["Budget Year 3"]
["Please DO NOT copy and paste from other Spreadsheet tabs"]
["Personnel: \nList all staff positions by title (both current and proposed) and provide the hourly wage, the percentage of time charged to the project (100% is 2,080 hours) and the annual salary for each position funded by the grant. Do not list positions that will be covered under Indirect Costs. Grant recipients that charge Personnel positions among multiple HVRP grants cannot exceed 100 percent FTE collectively among potential and active grants.\n\nIn the Justification of Costs section, include the corresponding roles and responsibilities for each position.",null,null,null,null,0,0,0,0,0,0,0]
["See the HVRP Glossary of Terms for Personnel position/staff definitions and examples."]
["Job or Position Title","Hourly Wage","% of FTE","Actual Annual Salary",0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"(B11*(C11*2080))","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"(B12*(C12*2080))","v":0},0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,0]
[null,null,null,0]
["Total Personnel",null,null,{"$f":"SUM(D11:D17)","v":0},0,0,0,0,0,0,0]
["Total Personnel - Rounded to the Nearest Whole Dollar",null,null,{"$f":"ROUND(D18,0)","v":0},0,0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Fringe Benefits:\nProvide information on the rate of all fringe benefits used and the basis for the calculation. If not using a fringe benefits rate, itemize how the fringe benefits amount is computed in the Justification of Costs section.\n\nFringe benefits may be in the form of employer contributions or expenses for FICA (Social Security and Medicare tax), employee life, health, unemployment, and/or worker's compensation insurance, paid absences, and other similar reasonable and allowable benefits as required by law, organization – employee agreement, or established written policies of the applicant/recipient organization per 2 C.F.R. § 200.431. Fringe benefits are for the personnel listed in budget category (a) and are only for the percentage of time devoted to the project.\n\nAn example of calculating fringe benefits based on base wages: The federal unemployment tax rate is 6% on the first $7,000 of wages, according to IRS Publication 15: Employers Tax Guide. This means $7,000 × 0.06 = $420 per full-time employee (FTE). The state unemployment tax rate is 5.4% on a $10,000 base wage, according to State Unemployment Compensation Law. This means $10,000 × 0.054 = $540 per FTE.",null,null,null,0,0,0,0,0,0,0,0]
["Description ","Base","Rate","Cost",0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"C27*B27","v":0},0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
[null,null,null,0,0,0,0,0,0,0,0,0]
["Total Fringe Benefits","Total Rate:",{"$f":"SUM(C27:C33)","v":0},{"$f":"SUM(D27:D33)","v":0},0,0,0,0,0,0,0,0]
["Total Fringe Benefits - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",{"$f":"ROUND(D34,0)","v":0},0,0,0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Travel (for grant recipient staff only ):\nThis section is for grant recipient staff only. Per 2 C.F.R. § 200.475(a), applicants/grant recipients must have policies in place related to travel costs.\n\nIn the absence of an established written policy regarding travel costs, the rates and amounts established under 5 U.S.C. §§ 5701–11 (‘‘Travel and Subsistence Expenses; Mileage Allowances”), by the Administrator of General Services, or by the President (or their designee) pursuant to any provisions of such subchapter must apply to travel under federal awards (48 C.F.R. § 31.205–46(a)). \n\nFor reimbursement on a mileage basis, the HVRP grant program cannot be charged more than the maximum allowable mileage reimbursement rates authorized for federal employees. Mileage rates must be checked annually at the U.S. General Services Administration (GSA)GSA’s Privately Owned Vehicle (POV) Mileage Reimbursement Rates webpage to ensure compliance.\n\nLocal Travel – It is not necessary to specify the exact locations of each trip, as it will be fluid based on participants, employers, and outreach opportunities. \n\nOut-of-State or In-State Overnight Travel – Requires specific start date/time and destination locations so DOL/VETS can determine whether the per diem and/or lodging costs are reasonable. This travel could also include allowable expenses to cover travel to DOL-sponsored training events such as the region or state annual post-award conferences, professional conferences, and/or any other offered training. The National Post Award Conference is virtual, so do not include travel costs for that event. Identify the name and location of the conference that staff will attend. Staff should not claim full day per diem rates for the first and last day of travel. Lodging and per diem expenditures must not exceed the rates established by GSA for the location of your trip. Find your per diem and lodging rates on the GSA Per Diem Rates webpage.\n\nTravel for participants (e.g., travel stipends for program participants) should be specifically itemized and placed in the Other category. \n\nInclude the basis of computation (e.g., six people to three-day training at $X airfare, $X lodging, $X subsistence) for each travel expense. Specify the purpose, location (e.g., location or whether in-state or out-of-state), type of expense (select from dropdown), basis (e.g., round-trip, day/night, mileage, etc.), cost or cost and quantity (e.g., number of nights or miles), number of staff traveling, and number of trips for each type of travel. Some cells may automatically turn gray based on the choice you make in the dropdown menu.\n\nApplicants/grant recipients must provide a justification for travel expenditures that exceed 10 percent of this one-year budget.  ",null,null,null,null,null,null,null,null,null,0,0]
["click here to look up the most current FY GSA per diem rates: https://www.gsa.gov/travel/plan-book/per-diem-rates",null,null,null,null,null,null,null,null,null,0,0]
["Purpose","Location","Type of Expense","Basis","Cost","Quantity","# of Staff","# of Trips","% Charged to HVRP","Total Cost",0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel2[[#This Row],[Basis]]=\"Round-Trip\",Travel2[[#This Row],[Cost]]*Travel2[[#This Row],[Quantity]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]],Travel2[[#This Row],[Cost]]*Travel2[[#This Row],[Quantity]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel2[[#This Row],[Basis]]=\"Round-Trip\",Travel2[[#This Row],[Cost]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]],Travel2[[#This Row],[Cost]]*Travel2[[#This Row],[Quantity]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel2[[#This Row],[Basis]]=\"Round-Trip\",Travel2[[#This Row],[Cost]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]],Travel2[[#This Row],[Cost]]*Travel2[[#This Row],[Quantity]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel2[[#This Row],[Basis]]=\"Round-Trip\",Travel2[[#This Row],[Cost]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]],Travel2[[#This Row],[Cost]]*Travel2[[#This Row],[Quantity]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel2[[#This Row],[Basis]]=\"Round-Trip\",Travel2[[#This Row],[Cost]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]],Travel2[[#This Row],[Cost]]*Travel2[[#This Row],[Quantity]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel2[[#This Row],[Basis]]=\"Round-Trip\",Travel2[[#This Row],[Cost]]*Travel2[[#This Row],[Quantity]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]],Travel2[[#This Row],[Cost]]*Travel2[[#This Row],[Quantity]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel2[[#This Row],[Basis]]=\"Round-Trip\",Travel2[[#This Row],[Cost]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]],Travel2[[#This Row],[Cost]]*Travel2[[#This Row],[Quantity]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel2[[#This Row],[Basis]]=\"Round-Trip\",Travel2[[#This Row],[Cost]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]],Travel2[[#This Row],[Cost]]*Travel2[[#This Row],[Quantity]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel2[[#This Row],[Basis]]=\"Round-Trip\",Travel2[[#This Row],[Cost]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]],Travel2[[#This Row],[Cost]]*Travel2[[#This Row],[Quantity]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel2[[#This Row],[Basis]]=\"Round-Trip\",Travel2[[#This Row],[Cost]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]],Travel2[[#This Row],[Cost]]*Travel2[[#This Row],[Quantity]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel2[[#This Row],[Basis]]=\"Round-Trip\",Travel2[[#This Row],[Cost]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]],Travel2[[#This Row],[Cost]]*Travel2[[#This Row],[Quantity]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
[null,null,null,{"$f":"IFERROR(VLOOKUP(Travel2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(IF(Travel2[[#This Row],[Basis]]=\"Round-Trip\",Travel2[[#This Row],[Cost]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]],Travel2[[#This Row],[Cost]]*Travel2[[#This Row],[Quantity]]*Travel2[[#This Row],['# of Staff]]*Travel2[[#This Row],['# of Trips]]*Travel2[[#This Row],[% Charged to HVRP]]),0)","v":0},0,0]
["Total Travel",null,null,null,null,null,null,null,null,{"$f":"SUM(J43:J54)","v":0},0,0]
["Total Travel - Rounded to the Nearest Whole Dollar",null,null,null,null,null,"(must match SF-424A)",null,null,{"$f":"ROUND(J55,0)","v":0},0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Equipment :\nPer 2 C.F.R. § 200.1, “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 recipient or subrecipient for financial statement purposes or $10,000. Items with a unit cost of less than $10,000 are supplies, not “equipment.” DOL/VETS does not allow the purchase of motor vehicles, buildings, or land.\n\nApplicants/grant recipients must list the item, quantity, and unit cost per item. In the Justification of Costs section, describe the need for the equipment, i.e., explain how the use of each item of equipment is related to the implementation of the required/approved activities to achieve the specific project objectives. List expendable items or materials in Supplies. DOL/VETS does not permit the purchase of equipment during the last funded year of the award.",null,null,null,null,0,0,0,0,0,0,0]
["Item","Quantity","Cost Per Unit","% Charged to HVRP","Total",0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"(B63*C63*D63)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,{"$f":"(B64*C64*D64)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
["Total Equipment",null,null,null,{"$f":"SUM(E63:E72)","v":0},0,0,0,0,0,0,0]
["Total Equipment - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",null,{"$f":"ROUND(E73,0)","v":0},0,0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Supplies :\nPer 2 C.F.R. § 200.1, “supplies” means all tangible personal property other than those described in the equipment definition. A computing device is a supply if the acquisition cost is below the lesser of the capitalization level established by the recipient or subrecipient for financial statement purposes or $10,000, regardless of the length of its useful life.\n\nApplicants/grant recipients must list the items by type of supply (e.g., training materials, desktop computer, laptop, projector, etc.), cost per unit, quantity, or cost per month if rented or leased. \n\nNote: 1) Software subscription services, such as cellular phone service or internet service, and advertising costs are not tangible and must be listed in Other. Cost allocations for supplies that are not broken down by individual item in the narrative must document the methodology used in determining the amount allocated for this line item, per 2 C.F.R. § 200.405(d); and 2) Supplies for participants should be placed in the “Other” line item.\n\nFor each item or cost, include an adequate reason in the Justification of Costs section.\n\nProject startup costs (e.g., purchase of laptops, printers, and supplies with a useful life of more than one program year’s budget) should not be written into the second- or third-year budget.",null,null,null,null,null,0,0,0,0,0,0]
["Item","Cost Per Unit","Quantity","Cost Per Month","% Charged to HVRP","Total",0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies2[[#This Row],[Cost Per Unit]]<>\"\",Supplies2[[#This Row],[Cost Per Unit]]*Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[% Charged to HVRP]],IF(Supplies2[[#This Row],[Quantity]]<>\"\",Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12,Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies2[[#This Row],[Cost Per Unit]]<>\"\",Supplies2[[#This Row],[Cost Per Unit]]*Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[% Charged to HVRP]],IF(Supplies2[[#This Row],[Quantity]]<>\"\",Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12,Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies2[[#This Row],[Cost Per Unit]]<>\"\",Supplies2[[#This Row],[Cost Per Unit]]*Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[% Charged to HVRP]],IF(Supplies2[[#This Row],[Quantity]]<>\"\",Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12,Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies2[[#This Row],[Cost Per Unit]]<>\"\",Supplies2[[#This Row],[Cost Per Unit]]*Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[% Charged to HVRP]],IF(Supplies2[[#This Row],[Quantity]]<>\"\",Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12,Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies2[[#This Row],[Cost Per Unit]]<>\"\",Supplies2[[#This Row],[Cost Per Unit]]*Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[% Charged to HVRP]],IF(Supplies2[[#This Row],[Quantity]]<>\"\",Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12,Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies2[[#This Row],[Cost Per Unit]]<>\"\",Supplies2[[#This Row],[Cost Per Unit]]*Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[% Charged to HVRP]],IF(Supplies2[[#This Row],[Quantity]]<>\"\",Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12,Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies2[[#This Row],[Cost Per Unit]]<>\"\",Supplies2[[#This Row],[Cost Per Unit]]*Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[% Charged to HVRP]],IF(Supplies2[[#This Row],[Quantity]]<>\"\",Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12,Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies2[[#This Row],[Cost Per Unit]]<>\"\",Supplies2[[#This Row],[Cost Per Unit]]*Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[% Charged to HVRP]],IF(Supplies2[[#This Row],[Quantity]]<>\"\",Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12,Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies2[[#This Row],[Cost Per Unit]]<>\"\",Supplies2[[#This Row],[Cost Per Unit]]*Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[% Charged to HVRP]],IF(Supplies2[[#This Row],[Quantity]]<>\"\",Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12,Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies2[[#This Row],[Cost Per Unit]]<>\"\",Supplies2[[#This Row],[Cost Per Unit]]*Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[% Charged to HVRP]],IF(Supplies2[[#This Row],[Quantity]]<>\"\",Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12,Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(Supplies2[[#This Row],[Cost Per Unit]]<>\"\",Supplies2[[#This Row],[Cost Per Unit]]*Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[% Charged to HVRP]],IF(Supplies2[[#This Row],[Quantity]]<>\"\",Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12,Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,{"$f":"IF(Supplies2[[#This Row],[Cost Per Unit]]<>\"\",Supplies2[[#This Row],[Cost Per Unit]]*Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[% Charged to HVRP]],IF(Supplies2[[#This Row],[Quantity]]<>\"\",Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12,Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,{"$f":"IF(Supplies2[[#This Row],[Cost Per Unit]]<>\"\",Supplies2[[#This Row],[Cost Per Unit]]*Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[% Charged to HVRP]],IF(Supplies2[[#This Row],[Quantity]]<>\"\",Supplies2[[#This Row],[Quantity]]*Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12,Supplies2[[#This Row],[Cost Per Month]]*Supplies2[[#This Row],[% Charged to HVRP]]*12))","v":0},0,0,0,0,0,0]
["Total Supplies",null,null,null,null,{"$f":"SUM(F82:F94)","v":0},0,0,0,0,0,0]
["Total Supplies - Rounded to the Nearest Whole Dollar",null,null,"(must match SF-424A)",null,{"$f":"ROUND(F95,0)","v":0},0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Contractual :\nDescribe contracts and subawards separately. The term “contracts” is defined in 2 C.F.R. § 200.1 and means, for the purpose of federal financial assistance, a legal instrument by which a recipient or subrecipient conducts procurement transactions under a federal award. Contractor means an entity that receives a contract. Subaward means an award provided by a pass-through entity to a subrecipient for the subrecipient to contribute to the goals and objectives of the project by carrying out part of the federal award received by the pass-through entity. It does not include payments to a contractor or payments to an individual that is a beneficiary of a federal program. A subaward may be provided through any form of legal agreement, including an agreement that the pass-through entity considers a contract.\n\nFor each contract or subaward, list the purpose, goods and/or services to be provided, amount, and percent charged to HVRP. In the Justification of Costs section, describe the goods and/or services to be provided by each contractor or sub-awardee and how the goods and/or services relate to the accomplishment of specific project objectives. Phone and copier contracts, agreements, or leases should not be included in this section. \n\nAll procurement transactions for the acquisition of goods and/or services required under an award must be conducted in a manner providing full and open competition consistent with the federal procurement standards in 2 C.F.R. § 200.319 (Competition) and 2 C.F.R. § 200.320 (Methods of procurement to be followed). Applicants/grant recipients must follow their documented procurement procedures that reflect applicable state, local, and tribal laws and regulations. These procedures must also conform to applicable federal laws, regulations, and the standards identified in 2 C.F.R. § 200.318. Applicants/grant recipients must maintain oversight to ensure that contractors and sub-awardees perform in accordance with the terms, conditions, and specifications of their legal agreement. For additional guidance, refer to 2 C.F.R. § 200.318 through 2 C.F.R. § 200.327 on Procurement Standards.",null,null,null,null,null,0,0,0,0,0,0]
["Contract/Subaward","Purpose","Activities to be provided","Amount","% Charged to HVRP","Total",0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"Contractual2[[#This Row],[Amount]]*Contractual2[[#This Row],[% Charged to HVRP]]","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"Contractual2[[#This Row],[Amount]]*Contractual2[[#This Row],[% Charged to HVRP]]","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"Contractual2[[#This Row],[Amount]]*Contractual2[[#This Row],[% Charged to HVRP]]","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"Contractual2[[#This Row],[Amount]]*Contractual2[[#This Row],[% Charged to HVRP]]","v":0}]
[null,null,null,null,null,{"$f":"Contractual2[[#This Row],[Amount]]*Contractual2[[#This Row],[% Charged to HVRP]]","v":0}]
[null,null,null,null,null,{"$f":"Contractual2[[#This Row],[Amount]]*Contractual2[[#This Row],[% Charged to HVRP]]","v":0}]
["Total Contractual",null,null,null,null,{"$f":"SUM(F103:F108)","v":0},0,0,0,0,0,0]
["Total Contractual - Rounded to the Nearest Whole Dollar",null,null,"(must match SF-424A)",null,{"$f":"ROUND(F109,0)","v":0},0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Construction :\nConstruction costs are unallowable under the HVRP grant program; therefore, this budget line item must be zero. Minor alterations to modernize, improve, and/or reconfigure existing space for grant activities (such as a classroom alteration) may be allowable, as this is not considered construction. Applicants/grant recipients must include the costs for minor alterations in the Contractual budget line item.",null,null,null,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Other :\nParticipant Support Costs:  \n\nPer 2 C.F.R. § 200.1, participant support costs mean direct costs that support participants and their involvement in a federal award, such as stipends, subsistence allowances, travel allowances, registration fees, temporary dependent care, and per diem paid directly to or on behalf of participants.\n\nA participant support cost is allowed only when incurred to enable the eligible veteran’s participation in HVRP services and must be tied to a specific HVRP service. It is not meant to cover all the participants’ needs. A participant support cost must be reasonable and necessary to help the participant engage in services and activities related to the employment plan. A participant support cost should not duplicate a service a participant receives from another program (i.e., federal, state, local programs). For specific guidance on Participant Support Costs, please see VPL 06-24 HVRP Requirements and Functions or the most current guidance on this topic. \n\nList participant support costs (e.g., training, clothing, work-related materials, etc.) and provide clear and specific details, including costs and quantity, for each item so that VETS can review factors affecting the allowability of costs as cited in 2 C.F.R. § 200.403. You may also list the support cost per month, if applicable. Note: identify the percentage of the cost that will be charged to the grant.\n\nProject startup costs (e.g., office furniture, PPE equipment, other items with a useful life of more than one program year’s budget) should not be written into the second- or third-year budget.",null,null,null,null,0,0,0,0,0,0,0]
["Item","Cost Per Unit","Quantity","Cost Per Month","% Charged to HVRP","Total",0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF($B119<>\"\",$B119*$C119*$E119,IF($C119<>\"\",$C119*$D119*$E119*12,$D119*$E119*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF($B120<>\"\",$B120*$C120*$E120,IF($C120<>\"\",$C120*$D120*$E120*12,$D120*$E120*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0]
["Total Participant Support Services",null,null,null,null,{"$f":"SUM(F119:F132)","v":0},0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Other Costs : \nList items or expenses not covered in other budget line items and provide specific details including the costs and quantity for each item. Show the basis for the calculations—break down costs into the cost per unit or rate (e.g., cost per square foot, cost per participant, etc.). You may also estimate the cost per month, if applicable, and the percentage that will be charged to the grant. \n\nIncentives may be provided to active HVRP participants for recognition and achievement directly tied to participation in the program and employment goals. If you plan to use incentive funds, your Budget Narrative must include the planned amount and type of incentives (e.g., gift cards, vouchers, etc.), and the justification must state the criteria for participant issuance, in accordance with VPL 06-24. Planned costs for incentives must be categorized under the “Other” cost category and not as a Participant Support Cost.",null,null,null,null,0,0,0,0,0,0,0]
["Item","Cost Per Unit","Quantity","Cost Per Month","% Charged to HVRP","Total",0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF($B140<>\"\",$B140*$C140*$E140,IF($C140<>\"\",$C140*$D140*$E140*12,$D140*$E140*12))","v":0},0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0,null,0]
[null,null,null,null,null,0,null,0]
["Total Other Costs",null,null,null,null,{"$f":"SUM(F140:F154)","v":0},0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
["Other Total (Participant Support Services + Other)",null,null,null,null,{"$f":"SUM(F133,F155)","v":0},0,0,0,0,0,0]
["Other Total - Rounded to the Nearest Whole Dollar",null,null,null,"(must match SF-424A)",{"$f":"ROUND(F159,0)","v":0},0,0,0,0,0,0]
["Justification of Costs Not Explained Above",null,null,null,null,null,0,0,0,0,0,0]
[" (max 3,225 characters including spaces)",null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Indirect Costs :\nPer 2 C.F.R. § 200.1, indirect cost means those costs incurred for a common or joint purpose benefitting more than one cost objective and not readily assignable to the cost objectives specifically benefited, without effort disproportionate to the results achieved. It may be necessary to establish multiple pools of indirect costs to facilitate equitable distribution of indirect expenses to the cost objectives served. Indirect cost pools must be distributed to benefitted cost objectives on a basis that will produce an equitable result in consideration of the relative benefits derived.\n\nInclude the type of rate or agreement (e.g., Negotiated Indirect Costs Rate Agreement [NICRA], Cost Allocation Plan [CAP], or the de minimis rate of 15 percent of modified total direct costs [MTDC]), the total approved base (if applicable), and the approved rate (if applicable).\n\nIf using a NICRA, in the Justification of Costs section, provide an explanation of how the indirect costs are calculated and the authorized from/to date of approval. This explanation should include which portion of each line item, along with the associated costs, is included in your allocation base.",null,null,null,0,0,0,0,0,0,0,0]
["\nRegarding the de minimis rate, applicants/grant recipients and subrecipients that do not have a current federal negotiated indirect cost rate (including provisional rate) may elect to charge a de minimis rate of up to 15 percent of MTDC. The recipient or subrecipient is authorized to determine the appropriate rate up to this limit, in accordance with 2 C.F.R. § 200.414(f). Additionally, applicants/grant recipients and subrecipients are not required to use the de minimis rate. If using the de minimis rate of 15 percent of MTDC, in the Justification of Costs section, provide an explanation of which portion of each line item, along with the associated costs, is included in your allocation base. Note that there are various items not included in the calculation of MTDC. \n\nPer 2 C.F.R. § 100, MTDC means all direct salaries and wages, applicable fringe benefits, materials and supplies, services, travel, and up to the first $50,000 of each subaward (regardless of the period of performance of the subawards under the award). MTDC excludes equipment, capital expenditures, charges for patient care, rental costs, tuition remission, scholarships and fellowships, participant support costs, and the portion of each subaward more than $50,000. Other items may only be excluded when necessary to avoid serious inequity in the distribution of indirect costs and with the approval of the cognizant agency for indirect costs.\n\nYou must exclude Participant Support Costs from your MTDC. For more information on rental costs, see 2 C.F.R. § 200.465 rental costs of real property and equipment.\n\nIf using a CAP, in the Justification of Costs section, provide the estimated indirect costs based on your approved allocation methodology."]
["Type of Rate Agreement","Base","Rate","Total Indirect Costs",0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(OR(Indirect_Costs2[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs2[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C169*B169,B169)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(OR(Indirect_Costs2[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs2[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C170*B170,B170)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(OR(Indirect_Costs2[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs2[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C171*B171,B171)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(OR(Indirect_Costs2[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs2[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C172*B172,B172)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(OR(Indirect_Costs2[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs2[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C173*B173,B173)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"IF(OR(Indirect_Costs2[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs2[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C174*B174,B174)","v":0}]
[null,null,null,{"$f":"IF(OR(Indirect_Costs2[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_Costs2[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),C175*B175,B175)","v":0}]
["Total Indirect Costs",null,null,{"$f":"SUM(D169:D175)","v":0},0,0,0,0,0,0,0,0]
["Total Indirect Costs - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",{"$f":"ROUND(D176,0)","v":0},0,0,0,0,0,0,0,0]
["Justification of Costs (max 3,225 characters including spaces)",null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Total Costs","Totals",0,0,0,0,0,0,0,0,0,0]
["Total Direct Costs",{"$f":"SUM(F160,F110,F96,J56,D35,D19,E74)","v":0},0,0,0,null,0,0,0,0,0,0]
["Total Indirect Costs",{"$f":"D177","v":0},0,0,0,null,0,0,0,0,0,0]
["Total Costs funded by Grant \n(must match the total on the SF-424 and SF-424A, as well as the specific year this budget is for on the VETS-704 Abstract)",{"$f":"SUM(B183:B184)","v":0},{"$f":"IF(Total_Costs2[[#This Row],[Totals]]>500000,\"This amount exceeds the allowed 12-month budget ceiling for HVRP. Please revise.\",\"\")","v":""},{"$f":"IF(Total_Costs2[[#This Row],[Totals]] > Enter_VETS_704_Form_Abstract_and_Planned_Chart_Request_Year_3_Amount,\n    \"This amount exceeds your Year 3 requested amount listed at the beginning of this budget form.\",\n    IF(Total_Costs2[[#This Row],[Totals]] < Enter_VETS_704_Form_Abstract_and_Planned_Chart_Request_Year_3_Amount,\n        \"This amount is less than the Third PY Requested Amount. Please Revise\",\n        \"\")\n)","v":""},0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Leveraged Resources :\nThe HVRP grant program does not require cost sharing or matching funds. Applicants/grant recipients that are not using federal grant funds to support grant activities must provide a description of leveraged resources. DOL/VETS considers any resources contributed to the project, beyond the funds provided by the agency, as leveraged resources. Applicants/grant recipients are encouraged to leverage resources to increase stakeholder investment in the project and broaden and sustain the impact of the project itself. The Budget Narrative should provide a description of the leveraged resources provided to support grant activities, the specific activities they will cover, the way they will support HVRP goals, and the funding source. Valuation of leveraged resources follows the same requirements as cost sharing.",null,null,null,0,0,0,0,0,0,0,0]
["Description of Leveraged Resources (max 3,225 characters including spaces)",null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0]
["Additional space for narrative justification not described above",null,null,null,0,0,0,0,0,0,0,0]
[null,null,null,null,0,0,0,0,0,0,0,0]
["**DOL/VETS does not allow the purchase of construction, motor vehicles, buildings, or land.",null,null,0,0,0,0,0,0,0,0,0]
["2 C.F.R. § 200.403",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R § 200 Subpart E",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R. § 200.404",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R § 200.431",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R § 200.475(a)",0,0,0,0,0,0,0,0,0,0,0]
["41 C.F.R Subtitle F",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R § 200.475",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R. §200.1",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R. § 200.319 ",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R. §200.320",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R § 200.318",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R. § 200.327",0,0,0,0,0,0,0,0,0,0,0]
["2 C.F.R. § 200.403",0,0,0,0,0,0,0,0,0,0,0]
["END OF DOCUMENT"]

{"sheet":"Total_POP_Budget","index":4,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":true,"merged":[[1,0,1,4],[2,0,2,4],[3,0,3,1]]}
["Accessibility Key: Summary of HVRP Total Period of Performance Budget by 12-Month Program Year."]
["Summary"]
["HVRP- Total Period of Performance Budget by 12-Month Program Year (PY)"]
[{"$f":"IF(Applicant_or_Grant_recipient_name=\"\", \"Enter Organization name in the First PY Budget Year tab.\",Applicant_or_Grant_recipient_name)","v":"Enter Organization name in the First PY Budget Year tab."}]
[null,"First PY Requested Amount","Second PY  Requested Amount","Third PY  Requested Amount","Total PoP  Requested Amount"]
[null,{"$f":"Enter_VETS_704_Form_Abstract_and_Planned_Chart_Request_Year_1_Amount","v":0},{"$f":"Enter_VETS_704_Form_Abstract_and_Planned_Chart_Request_Year_2_Amount","v":0},{"$f":"Enter_VETS_704_Form_Abstract_and_Planned_Chart_Request_Year_3_Amount","v":0},{"$f":"SUM(B6:D6)","v":0}]
["Budget Category","First PY Budget","Second PY Budget","Third PY Budget","Total PoP Budget"]
["Personnel",{"$f":"'First PY Budget'!D19","v":0},{"$f":"'Second PY Budget'!D19","v":0},{"$f":"'Third PY Budget'!D19","v":0},{"$f":"SUM(B8:D8)","v":0}]
["Fringe Benefits",{"$f":"'First PY Budget'!D35","v":0},{"$f":"'Second PY Budget'!D34","v":0},{"$f":"'Third PY Budget'!D35","v":0},0]
["Travel",{"$f":"'First PY Budget'!J55","v":0},{"$f":"'Second PY Budget'!J53","v":0},{"$f":"'Third PY Budget'!J56","v":0},0]
["Equipment",{"$f":"'First PY Budget'!E75","v":0},{"$f":"'Second PY Budget'!E71","v":0},{"$f":"'Third PY Budget'!E74","v":0},0]
["Supplies",{"$f":"'First PY Budget'!F97","v":0},{"$f":"'Second PY Budget'!F93","v":0},{"$f":"'Third PY Budget'!F96","v":0},0]
[" Contractual",{"$f":"'First PY Budget'!F111","v":0},{"$f":"'Second PY Budget'!F107","v":0},{"$f":"'Third PY Budget'!F110","v":0},0]
["Construction",{"$f":"'First PY Budget'!E116","v":0},{"$f":"'Second PY Budget'!E112","v":0},{"$f":"'Third PY Budget'!E115","v":0},0]
["Total Other",{"$f":"SUM(B16:B17)","v":0},{"$f":"SUM(C16:C17)","v":0},{"$f":"SUM(D16:D17)","v":0},0]
["Other: Participant Support Costs",{"$f":"'First PY Budget'!F134","v":0},{"$f":"'Second PY Budget'!F130","v":0},{"$f":"'Third PY Budget'!F133","v":0},{"$f":"SUM(B16:D16)","v":0}]
["Other",{"$f":"'First PY Budget'!F156","v":0},{"$f":"'Second PY Budget'!F152","v":0},{"$f":"'Third PY Budget'!F155","v":0},{"$f":"SUM(B17:D17)","v":0}]
["Total Direct Costs",{"$f":"SUM(B8:B15)","v":0},{"$f":"SUM(C8:C15)","v":0},{"$f":"SUM(D8:D15)","v":0},{"$f":"SUM(B18:D18)","v":0}]
["Indirect Costs",{"$f":"'First PY Budget'!D179","v":0},{"$f":"'Second PY Budget'!D174","v":0},{"$f":"'Third PY Budget'!D177","v":0},{"$f":"SUM(B19:D19)","v":0}]
["Total Cost",{"$f":"SUM(B19,B18)","v":0},{"$f":"SUM(C19,C18)","v":0},{"$f":"SUM(D19,D18)","v":0},{"$f":"SUM(E18,E19)","v":0}]
[null,{"$f":"IF(B20>500000, \"This amount exceeds the allowd 12-month budget ceiling for HVRP. Please revise.\",\"\")","v":""},{"$f":"IF(C20>500000, \"This amount exceeds the allowd 12-month budget ceiling for HVRP. Please revise.\",\"\")","v":""},{"$f":"IF(D20>500000, \"This amount exceeds the allowd 12-month budget ceiling for HVRP. Please revise.\",\"\")","v":""}]
[null,{"$f":"IF(B20 > B6,\n    \"This amount exceeds the First PY Budget entered above. Please revise.\",\n    IF(B20 < B6,\n        \"This amount is less than the First PY Requested Amount. Please Revise\",\n        \"\")\n)","v":""},{"$f":"IF(C20 > C6,\n    \"This amount exceeds the Second PY Budget entered above. Please revise.\",\n    IF(C20 < C6,\n        \"This amount is less than the Second PY Requested Amount. Please Revise\",\n        \"\")\n)","v":""},{"$f":"IF(D20 > D6,\n    \"This amount exceeds the Third PY Budget entered above. Please revise.\",\n    IF(D20 < D6,\n        \"This amount is less than the Third PY Requested Amount. Please Revise\",\n        \"\")\n)","v":""},{"$f":"IF(E20 > E6,\n    \"This amount exceeds the Total PoP Budget entered above. Please revise.\",\n    IF(E20 < E6,\n        \"This amount is less than the Total PoP PY Requested Amount. Please Revise\",\n        \"\")\n)","v":""}]

{"sheet":"Budget Narrative Template Y2","index":5,"n_rows":145,"n_cols":11,"rows_kept":145,"cut":false,"hidden":true,"merged":[[45,1,45,10],[0,1,0,4],[1,1,1,4],[3,1,3,4],[5,1,5,4],[7,1,7,4],[17,1,17,4],[18,1,18,4],[20,1,20,4],[30,1,30,4],[31,1,31,4],[33,1,33,10],[93,1,93,5],[46,1,46,10],[48,1,48,5],[60,1,60,5],[61,1,61,5],[63,1,63,6],[77,1,77,6],[78,1,78,6],[80,1,80,6],[88,1,88,6],[89,1,89,6],[91,1,91,4],[106,1,106,5],[94,1,94,5],[95,7,95,12],[96,7,96,12],[97,7,97,12],[98,7,98,12],[99,7,99,12],[112,7,112,12],[100,7,100,12],[101,7,101,12],[102,7,102,12],[103,7,103,12],[104,7,104,12],[107,7,107,12],[108,7,108,12],[109,7,109,12],[110,7,110,12],[111,7,111,12],[142,1,142,4],[113,7,113,12],[114,7,114,12],[115,7,115,12],[116,7,116,12],[120,1,120,6],[121,1,121,6],[123,1,123,4],[132,1,132,4],[133,1,133,4],[140,1,140,4],[141,1,141,4]]}
[null,"HVRP Budget Narrative Template version 1.0"]
[null,"NOTE: The Budget Narrative is the justification for budget line-items meet program objectives. The Budget Narrative must be concrete and specific. The Budget Narrative is for a one-year budget up to $600,000 that supports the targeted population and the service delivery area(s); additionally, proposed allocations must be proportional to the resources needed to implement the proposed project. "]
[]
[null,"Applicants/recipients must demonstrate that costs are allowable (2 C.F.R. § 200.403). In other words, costs must be necessary and reasonable for the performance of the Federal award and must be allocable under the cost principles in 2 C.F.R § 200 Subpart E. A cost is “necessary” if it meets a program objective and is necessary and reasonable for the performance of the HVRP. A cost is “reasonable” if it meets the “prudent person” standard (2 C.F.R. § 200.404). See section IV.B.2.a of the FOA for additional requirements for the budget narrative. Shared costs among multiple programs or projects should be proportionate: (ex. Program Manager who works HVRP 20% of the time, the amount charged to HVRP for items such as the Program Manager's cell phone or laptop, would be cost shared among the other programs).                                                           \n                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      If charging indirect costs in Section J. Indirect Charges, ensure costs are not duplicated under any of the direct costs categories. Costs must not be duplicated or inconsistently charged, costs must be charged as either indirect or direct costs. "]
[]
[null,"The Budget Narrative must include a justification for all proposed costs and align with the SF-424A and the estimated funding amount in the SF-424 (Section 18). The Budget Narrative must be consistent with and support the activities, resources, staff, and other items described in the project narrative.     \n                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              \nTo add more rows or space to any budget line-item, select the “Add” button to the right of the field. "]
[]
["a.","Personnel:\nList all staff positions (including individuals hired by an employment contract) by title (both current and proposed) and provide the annual salary, the percentage of time devoted to the project, and the amount of each position’s salary funded by the grant. Do not list positions that will be covered under Indirect Costs. \n\nIn the Justification of Costs section, include the corresponding roles and responsibilities for each position. "]
[null,"Position Title","Annual Salary","% of FTE","Actual Salary"]
[null,null,null,null,{"$f":"(C10*D10)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"Total Personnel",null,null,{"$f":"SUM(E10:E15)","v":0}]
[null,"Total Personnel - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",{"$f":"ROUND(E16,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
["b.","Fringe Benefits:\nProvide information on the rate of fringe benefits used and the basis for the calculation. If not using a fringe benefits rate, itemize how the fringe benefits amount is computed in the Justification of Costs section.\n\nFringe benefits may be in the form of employer contributions or expenses for FICA (Social Security and Medicare tax), employee life, health, unemployment, worker's compensation insurance, paid absences, and other similar reasonable and allowable benefits as required by law, organization – employee agreement, or established written policies of the applicant/recipient organization per 2 C.F.R § 200.431. Fringe benefits are for the personnel listed in budget category (a) and are only for the percentage of time devoted to the project. "]
[null,"Description ","Base","Rate","Cost"]
[null,null,null,null,{"$f":"D23*C23","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"Total Fringe Benefits",null,null,{"$f":"SUM(E23:E28)","v":0}]
[null,"Total Fringe Benefits - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",{"$f":"ROUND(E29,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
["c.","Travel (for grant recipient staff only):\nTravel costs are allowable as expenses by employees who are in travel status on official business/project-related travel. Itemize travel expenses of personnel by purpose (e.g., staff training, field interviews, advisory group meeting, etc.) and include funds to cover travel to DOL-sponsored training events such as the annual post-award conference, professional conference, and/or any other offered trainings. Travel for participants (e.g., travel stipends for program participants) should be specifically itemized and placed in the Other category. \n\nInclude the basis of computation (e.g., six people to 3-day training at $X airfare, $X lodging, $X subsistence) for each travel expense. Specify the purpose, location (e.g., location or whether in-state or out-of-state), type of expense (select from dropdown), basis (e.g., round-trip, day/night, mileage, etc.), cost or cost and quantity (e.g., number of nights or miles), number of staff traveling, and number of trips for each type of travel.  \nIn the Justification of Costs section, describe the purpose of each travel expenditure in reference to the project objectives. Applicants must provide a justification for travel expenditures that exceed 10 percent of the one-year budget. \n\nNOTE: Per 2 C.F.R § 200.475(a), applicants must have policies in place related to travel costs. In the absence of an established travel policies, applicants/recipients must comply with the Federal travel regulations (48 C.F.R. § 31.205-46(a)), most easily accessible via the U.S. General Services Administration’s (GSA) website, see 2 C.F.R § 200.475.  For reimbursement on a mileage basis, the HVRP grant program cannot be charged more than the maximum allowable mileage reimbursement rates authorized for Federal employees. Mileage rates must be checked annually at GSA’s Privately Owned Vehicle (POV) Mileage Reimbursement Rates webpage to ensure compliance."]
[null,"Purpose","Location","Type of Expense","Basis","Cost","Quantity","# of Staff","# of Trips","% Charged to HVRP","Total Cost"]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(TravelY2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(TravelY2[[#This Row],[Cost]]*TravelY2[[#This Row],[Quantity]]*TravelY2[[#This Row],['# of Staff]]*TravelY2[[#This Row],['# of Trips]]*TravelY2[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(TravelY2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(TravelY2[[#This Row],[Cost]]*TravelY2[[#This Row],[Quantity]]*TravelY2[[#This Row],['# of Staff]]*TravelY2[[#This Row],['# of Trips]]*TravelY2[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(TravelY2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(TravelY2[[#This Row],[Cost]]*TravelY2[[#This Row],[Quantity]]*TravelY2[[#This Row],['# of Staff]]*TravelY2[[#This Row],['# of Trips]]*TravelY2[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(TravelY2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(TravelY2[[#This Row],[Cost]]*TravelY2[[#This Row],[Quantity]]*TravelY2[[#This Row],['# of Staff]]*TravelY2[[#This Row],['# of Trips]]*TravelY2[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(TravelY2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(TravelY2[[#This Row],[Cost]]*TravelY2[[#This Row],[Quantity]]*TravelY2[[#This Row],['# of Staff]]*TravelY2[[#This Row],['# of Trips]]*TravelY2[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(TravelY2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(TravelY2[[#This Row],[Cost]]*TravelY2[[#This Row],[Quantity]]*TravelY2[[#This Row],['# of Staff]]*TravelY2[[#This Row],['# of Trips]]*TravelY2[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(TravelY2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(TravelY2[[#This Row],[Cost]]*TravelY2[[#This Row],[Quantity]]*TravelY2[[#This Row],['# of Staff]]*TravelY2[[#This Row],['# of Trips]]*TravelY2[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(TravelY2[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(TravelY2[[#This Row],[Cost]]*TravelY2[[#This Row],[Quantity]]*TravelY2[[#This Row],['# of Staff]]*TravelY2[[#This Row],['# of Trips]]*TravelY2[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,"Total Travel",null,null,null,null,null,null,null,null,{"$f":"SUM(K36:K43)","v":0}]
[null,"Total Travel - Rounded to the Nearest Whole Dollar",null,null,null,null,null,null,"(must match SF-424A)",null,{"$f":"ROUND(K44,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
["d.","Equipment:\nPer 2 C.F.R. §200.1, equipment is an item of tangible, non-expendable, personal property (including information technology systems – means computing devices, ancillary equipment, software, and firmware etc.) having a useful life of more than one year AND an acquisition cost of at least $5,000 per unit or more regardless of the non-Federal entity’s capitalization threshold.\n\nList the item, quantity, and the unit cost per item. In the Justification of Costs section, describe the need for the equipment, i.e., explain how the use of each item of equipment is related to the implementation of the required/approved activities to achieve the specific project objectives. List expendable items or materials in Supplies. Generally, DOL/VETS does not permit the purchase of equipment during the last funded year of the award."]
[null,"Item","Quantity","Cost Per Unit","% Charged to HVRP","Total"]
[null,null,null,null,null,{"$f":"(C51*D51*E51)","v":0}]
[null,null,null,null,null,{"$f":"(C52*D52*E52)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,"Total Equipment",null,null,null,{"$f":"SUM(F51:F58)","v":0}]
[null,"Total Equipment - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",null,{"$f":"ROUND(F59,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
["e.","Supplies:\nPer 2 C.F.R. §200.1, supplies are items that cost less than $5,000 per unit and often have a one-time use, that is, materials which are expendable or consumed during the performance of the federal award. A computing device is a supply if the acquisition cost is less than the lesser of the capitalization level established by the organization for financial statement purposes or $5,000, regardless of the length of its useful life. \n\nList the items by type of supply (e.g., training materials, desktop computer, laptop, projector etc.), cost per unit, quantity, or cost per month. Note: subscription services such as cellular phone service or internet service are not tangible and must be listed in Other.\n\nFor each item or cost, include an adequate justification in the Justification of Costs section."]
[null,"Item","Cost Per Unit","Quantity","Cost Per Month","% Charged to HVRP","Total"]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY2[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY2[[#This Row],[Cost Per Unit]]*SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[% Charged to HVRP]],IF(SuppliesY2[[#This Row],[Quantity]]<>\"\",SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12,SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY2[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY2[[#This Row],[Cost Per Unit]]*SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[% Charged to HVRP]],IF(SuppliesY2[[#This Row],[Quantity]]<>\"\",SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12,SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY2[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY2[[#This Row],[Cost Per Unit]]*SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[% Charged to HVRP]],IF(SuppliesY2[[#This Row],[Quantity]]<>\"\",SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12,SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY2[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY2[[#This Row],[Cost Per Unit]]*SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[% Charged to HVRP]],IF(SuppliesY2[[#This Row],[Quantity]]<>\"\",SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12,SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY2[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY2[[#This Row],[Cost Per Unit]]*SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[% Charged to HVRP]],IF(SuppliesY2[[#This Row],[Quantity]]<>\"\",SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12,SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY2[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY2[[#This Row],[Cost Per Unit]]*SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[% Charged to HVRP]],IF(SuppliesY2[[#This Row],[Quantity]]<>\"\",SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12,SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY2[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY2[[#This Row],[Cost Per Unit]]*SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[% Charged to HVRP]],IF(SuppliesY2[[#This Row],[Quantity]]<>\"\",SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12,SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY2[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY2[[#This Row],[Cost Per Unit]]*SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[% Charged to HVRP]],IF(SuppliesY2[[#This Row],[Quantity]]<>\"\",SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12,SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY2[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY2[[#This Row],[Cost Per Unit]]*SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[% Charged to HVRP]],IF(SuppliesY2[[#This Row],[Quantity]]<>\"\",SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12,SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY2[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY2[[#This Row],[Cost Per Unit]]*SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[% Charged to HVRP]],IF(SuppliesY2[[#This Row],[Quantity]]<>\"\",SuppliesY2[[#This Row],[Quantity]]*SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12,SuppliesY2[[#This Row],[Cost Per Month]]*SuppliesY2[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,"Total Supplies",null,null,null,null,{"$f":"SUM(G66:G75)","v":0}]
[null,"Total Supplies - Rounded to the Nearest Whole Dollar",null,null,"(must match SF-424A)",null,{"$f":"ROUND(G76,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
["f.","Contractual:\nDescribe contracts and subawards separately.  Contracts are defined according to 2 C.F.R. § 200.1 as a legal instrument by which a non-federal entity purchases goods or services needed to carry out the project or program under a federal award.  A subaward, defined by 2 C.F.R. § 200.1, means an award provided by a pass-through entity to a subrecipient for the subrecipient to carry out part of a federal award received by the pass-through entity.  It does not include payments to a contractor or payments to an individual that is a beneficiary of a federal program. \n\nFor each contract or subaward, list the purpose, goods and/or services to be provided, and the amount. In the Justification of Costs section, describe the goods and/or services to be provided by each contractor or sub-awardee, and how the goods and/or services relate to the accomplishment of specific project objectives.\n\nAll procurement transactions for the acquisition of goods and/or services required under a federal award must be conducted in a manner providing full and open competition consistent with the federal procurement standards in 2 C.F.R. § 200.319 (Competition.) and 2 C.F.R. §200.320 (Methods of procurement to be followed). Applicants must follow their documented procurement procedures which reflect applicable state, local, and tribal laws, and regulations. These procedures must also conform to applicable Federal laws, regulations and the standards identified in 2 C.F.R § 200.318.  Applicants must maintain oversight to ensure that contractors and sub-awardees perform in accordance with the terms, conditions, and specifications of their legal agreement. For additional guidance, refer to 2 C.F.R. § 200.318 through 2 C.F.R. § 200.327 on Procurement Standards."]
[null,"Contract/Subaward","Purpose","Activities to be provivded","Amount","% Charged to HVRP","Total"]
[null,null,null,null,null,null,{"$f":"ContractualY2[[#This Row],[Amount]]*ContractualY2[[#This Row],[% Charged to HVRP]]","v":0}]
[null,null,null,null,null,null,{"$f":"ContractualY2[[#This Row],[Amount]]*ContractualY2[[#This Row],[% Charged to HVRP]]","v":0}]
[null,null,null,null,null,null,{"$f":"ContractualY2[[#This Row],[Amount]]*ContractualY2[[#This Row],[% Charged to HVRP]]","v":0}]
[null,null,null,null,null,null,{"$f":"ContractualY2[[#This Row],[Amount]]*ContractualY2[[#This Row],[% Charged to HVRP]]","v":0}]
[null,"Total Contractual",null,null,null,null,{"$f":"SUM(G83:G86)","v":0}]
[null,"Total Contractual - Rounded to the Nearest Whole Dollar",null,null,"(must match SF-424A)",null,{"$f":"ROUND(G87,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
["g.","Construction:\nConstruction costs are unallowable under the HVRP grant program; and therefore, this budget line-item must be zero. Minor alterations to modernize, improve, and/or reconfigure an existing space for grant activities (such as a classroom alteration) may be allowable, as this is not considered construction. Applicants must include the costs for minor alterations in the budget line-item Contractual.",null,null,null,0]
[]
["h.","Other"]
[null,"Participant Support Costs: \nList participant support costs (e.g., training, clothing, etc.) and provide clear and specific detail, including costs and quantity, for each item so that we can review factors affecting allowability of costs as discussed in 2 C.F.R. § 200.403. Per 2 C.F.R. § 200.1, participant support costs means direct costs for items such as stipends or subsistence allowances, travel allowances, and registration fees paid to or on behalf of participants or trainees (but not employees) in connection with conferences, or training projects. "]
[null,"Item","Cost Per Unit","Quantity","Cost Per Month","% Charged to HVRP","Total","Justification of Costs\n(max 2,620 characters including spaces; users may adjust row height manually to display full text)"]
[null,null,null,null,null,null,{"$f":"IF($C97<>\"\",$C97*$D97*$F97,IF($D97<>\"\",$D97*$E97*$F97*12,$E97*$F97*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF($C98<>\"\",$C98*$D98*$F98,IF($D98<>\"\",$D98*$E98*$F98*12,$E98*$F98*12))","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,"Total Participant Support Services",null,null,null,null,{"$f":"SUM(G97:G105)","v":0}]
[null,"Other Costs:\nList items or expenses not covered in other budget line-items, and provide specific details including the costs and quantity, for each item. Show the basis for the calculations – breakdown costs into the cost per unit or rate (e.g., cost per square foot, cost per participant etc.). "]
[null,"Item","Cost Per Unit","Quantity","Cost Per Month","% Charged to HVRP","Total","Justification of Costs\n(max 2,620 characters including spaces; users may adjust row height manually to display full text)"]
[null,null,null,null,null,null,{"$f":"IF($C109<>\"\",$C109*$D109*$F109,IF($D109<>\"\",$D109*$E109*$F109*12,$E109*$F109*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF($C110<>\"\",$C110*$D110*$F110,IF($D110<>\"\",$D110*$E110*$F110*12,$E110*$F110*12))","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,"Total Other Costs",null,null,null,null,{"$f":"SUM(G109:G117)","v":0}]
[null,"Other Total (Participant Support Services + Other)",null,null,null,null,{"$f":"SUM(G106,G118)","v":0}]
[null,"Other Total - Rounded to the Nearest Whole Dollar",null,null,null,"(must match SF-424A)",{"$f":"ROUND(G119,0)","v":0}]
[null,"Justification of Costs Not Explained in Columns G:L Above (max 3,225 characters including spaces)"]
[]
[]
["j.","Indirect Costs:\nPer 2 C.F.R. § 200.1 indirect (facilities and administrative (F&A)) costs are costs incurred for a common or joint purpose benefitting more than one cost objective, and not readily assignable to the cost objectives specifically benefitted, without effort disproportionate to the results achieved. To facilitate equitable distribution of indirect expenses to the cost objectives served, it may be necessary to establish several pools of indirect (F&A) costs. \n\nInclude the type of rate or agreement (e.g., Negotiated Indirect Costs Rate Agreement (NICRA), Cost Allocation Plan (CAP), or the de minimis rate of 10% of modified total direct costs (MTDC)), the total approved base (if applicable), and the approved rate (if applicable).\n\nIf using a NICRA, in the Justification of Costs section, provide an explanation of how the indirect costs are calculated. This explanation should include which portion of each line item, along with the associated costs, are included in your allocation base.\n\nIf using the de minimis rate of 10% of MTDC, in the Justification of Costs section, provide an explanation of which portion of each line item, along with the associated costs, are included in your allocation base. Note that there are various items not included in the calculation of MTDC, see 2 C.F.R. § 200.1 for specific exclusions. \n\nIf using a CAP, in the Justification of Costs section, provide estimated indirect costs based on your approved allocation methodology. "]
[null,"Type of Rate Agreement","Base","Rate","Total Indirect Costs"]
[null,null,null,null,{"$f":"IF(OR(Indirect_CostsY2[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_CostsY2[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),D126*C126,C126)","v":0}]
[null,null,null,null,{"$f":"IF(OR(Indirect_CostsY2[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_CostsY2[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),D127*C127,C127)","v":0}]
[null,null,null,null,{"$f":"IF(OR(Indirect_CostsY2[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_CostsY2[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),D128*C128,C128)","v":0}]
[null,null,null,null,{"$f":"IF(OR(Indirect_CostsY2[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_CostsY2[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),D129*C129,C129)","v":0}]
[null,null,null,null,{"$f":"IF(OR(Indirect_CostsY2[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_CostsY2[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),D130*C130,C130)","v":0}]
[null,"Total Indirect Costs",null,null,{"$f":"SUM(E126:E130)","v":0}]
[null,"Total Indirect Costs - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",{"$f":"ROUND(E131,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
[null,"Total Costs","Column1"]
[null,"Total Direct Costs",{"$f":"SUM(G120,G88,G77,K45,E30,E17,F60)","v":0}]
[null,"Total Indirect Costs",{"$f":"E132","v":0}]
[null,"Total Costs funded by Grant\n(must match the total on the SF-424 and SF-424A, as well as the Year 1 total on the VETS-704 Abstract)",{"$f":"SUM(C137:C138)","v":0}]
[]
[null,"Leveraged Resources:\nThe HVRP grant program does not require cost sharing or matching funds. However, the Budget Narrative should include a section describing any leveraged resources provided (as applicable) to support grant activities. DOL/VETS considers any resources contributed to the project, beyond the funds provided by the agency, as leveraged resources. Applicants are encouraged to leverage resources to increase stakeholder investment in the project and broaden and sustain the impact of the project itself. The Budget Narrative should provide a description of the leveraged resources provided to support grant activities, the specific activities they will cover, the way they will support HVRP goals and the funding source. Valuation of leveraged resources follows the same requirements as matching funds.  "]
[null,"Description of Leveraged Resources (max 3,225 characters including spaces)"]
[]
[]
[null,"**DOL/VETS does not allow the purchase of construction, motor vehicles, buildings, or land."]

{"sheet":"Budget Narrative Template Y3","index":6,"n_rows":145,"n_cols":11,"rows_kept":145,"cut":false,"hidden":true,"merged":[[45,1,45,10],[0,1,0,4],[1,1,1,4],[3,1,3,4],[5,1,5,4],[7,1,7,4],[17,1,17,4],[18,1,18,4],[20,1,20,4],[30,1,30,4],[31,1,31,4],[33,1,33,10],[93,1,93,5],[46,1,46,10],[48,1,48,5],[60,1,60,5],[61,1,61,5],[63,1,63,6],[77,1,77,6],[78,1,78,6],[80,1,80,6],[88,1,88,6],[89,1,89,6],[91,1,91,4],[106,1,106,5],[94,1,94,5],[95,7,95,12],[96,7,96,12],[97,7,97,12],[98,7,98,12],[99,7,99,12],[112,7,112,12],[100,7,100,12],[101,7,101,12],[102,7,102,12],[103,7,103,12],[104,7,104,12],[107,7,107,12],[108,7,108,12],[109,7,109,12],[110,7,110,12],[111,7,111,12],[142,1,142,4],[113,7,113,12],[114,7,114,12],[115,7,115,12],[116,7,116,12],[120,1,120,6],[121,1,121,6],[123,1,123,4],[132,1,132,4],[133,1,133,4],[140,1,140,4],[141,1,141,4]]}
[null,"HVRP Budget Narrative Template version 1.0"]
[null,"NOTE: The Budget Narrative is the justification for budget line-items meet program objectives. The Budget Narrative must be concrete and specific. The Budget Narrative is for a one-year budget up to $600,000 that supports the targeted population and the service delivery area(s); additionally, proposed allocations must be proportional to the resources needed to implement the proposed project. "]
[]
[null,"Applicants/recipients must demonstrate that costs are allowable (2 C.F.R. § 200.403). In other words, costs must be necessary and reasonable for the performance of the Federal award and must be allocable under the cost principles in 2 C.F.R § 200 Subpart E. A cost is “necessary” if it meets a program objective and is necessary and reasonable for the performance of the HVRP. A cost is “reasonable” if it meets the “prudent person” standard (2 C.F.R. § 200.404). See section IV.B.2.a of the FOA for additional requirements for the budget narrative. Shared costs among multiple programs or projects should be proportionate: (ex. Program Manager who works HVRP 20% of the time, the amount charged to HVRP for items such as the Program Manager's cell phone or laptop, would be cost shared among the other programs).                                                           \n                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      If charging indirect costs in Section J. Indirect Charges, ensure costs are not duplicated under any of the direct costs categories. Costs must not be duplicated or inconsistently charged, costs must be charged as either indirect or direct costs. "]
[]
[null,"The Budget Narrative must include a justification for all proposed costs and align with the SF-424A and the estimated funding amount in the SF-424 (Section 18). The Budget Narrative must be consistent with and support the activities, resources, staff, and other items described in the project narrative.     \n                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              \nTo add more rows or space to any budget line-item, select the “Add” button to the right of the field. "]
[]
["a.","Personnel:\nList all staff positions (including individuals hired by an employment contract) by title (both current and proposed) and provide the annual salary, the percentage of time devoted to the project, and the amount of each position’s salary funded by the grant. Do not list positions that will be covered under Indirect Costs. \n\nIn the Justification of Costs section, include the corresponding roles and responsibilities for each position. "]
[null,"Position Title","Annual Salary","% of FTE","Actual Salary"]
[null,null,null,null,{"$f":"(C10*D10)","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"Total Personnel",null,null,{"$f":"SUM(E10:E15)","v":0}]
[null,"Total Personnel - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",{"$f":"ROUND(E16,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
["b.","Fringe Benefits:\nProvide information on the rate of fringe benefits used and the basis for the calculation. If not using a fringe benefits rate, itemize how the fringe benefits amount is computed in the Justification of Costs section.\n\nFringe benefits may be in the form of employer contributions or expenses for FICA (Social Security and Medicare tax), employee life, health, unemployment, worker's compensation insurance, paid absences, and other similar reasonable and allowable benefits as required by law, organization – employee agreement, or established written policies of the applicant/recipient organization per 2 C.F.R § 200.431. Fringe benefits are for the personnel listed in budget category (a) and are only for the percentage of time devoted to the project. "]
[null,"Description ","Base","Rate","Cost"]
[null,null,null,null,{"$f":"D23*C23","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,"Total Fringe Benefits",null,null,{"$f":"SUM(E23:E28)","v":0}]
[null,"Total Fringe Benefits - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",{"$f":"ROUND(E29,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
["c.","Travel (for grant recipient staff only):\nTravel costs are allowable as expenses by employees who are in travel status on official business/project-related travel. Itemize travel expenses of personnel by purpose (e.g., staff training, field interviews, advisory group meeting, etc.) and include funds to cover travel to DOL-sponsored training events such as the annual post-award conference, professional conference, and/or any other offered trainings. Travel for participants (e.g., travel stipends for program participants) should be specifically itemized and placed in the Other category. \n\nInclude the basis of computation (e.g., six people to 3-day training at $X airfare, $X lodging, $X subsistence) for each travel expense. Specify the purpose, location (e.g., location or whether in-state or out-of-state), type of expense (select from dropdown), basis (e.g., round-trip, day/night, mileage, etc.), cost or cost and quantity (e.g., number of nights or miles), number of staff traveling, and number of trips for each type of travel.  \nIn the Justification of Costs section, describe the purpose of each travel expenditure in reference to the project objectives. Applicants must provide a justification for travel expenditures that exceed 10 percent of the one-year budget. \n\nNOTE: Per 2 C.F.R § 200.475(a), applicants must have policies in place related to travel costs. In the absence of an established travel policies, applicants/recipients must comply with the Federal travel regulations (48 C.F.R. § 31.205-46(a)), most easily accessible via the U.S. General Services Administration’s (GSA) website, see 2 C.F.R § 200.475.  For reimbursement on a mileage basis, the HVRP grant program cannot be charged more than the maximum allowable mileage reimbursement rates authorized for Federal employees. Mileage rates must be checked annually at GSA’s Privately Owned Vehicle (POV) Mileage Reimbursement Rates webpage to ensure compliance."]
[null,"Purpose","Location","Type of Expense","Basis","Cost","Quantity","# of Staff","# of Trips","% Charged to HVRP","Total Cost"]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(TravelY3[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(TravelY3[[#This Row],[Cost]]*TravelY3[[#This Row],[Quantity]]*TravelY3[[#This Row],['# of Staff]]*TravelY3[[#This Row],['# of Trips]]*TravelY3[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(TravelY3[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(TravelY3[[#This Row],[Cost]]*TravelY3[[#This Row],[Quantity]]*TravelY3[[#This Row],['# of Staff]]*TravelY3[[#This Row],['# of Trips]]*TravelY3[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(TravelY3[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(TravelY3[[#This Row],[Cost]]*TravelY3[[#This Row],[Quantity]]*TravelY3[[#This Row],['# of Staff]]*TravelY3[[#This Row],['# of Trips]]*TravelY3[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(TravelY3[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(TravelY3[[#This Row],[Cost]]*TravelY3[[#This Row],[Quantity]]*TravelY3[[#This Row],['# of Staff]]*TravelY3[[#This Row],['# of Trips]]*TravelY3[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(TravelY3[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(TravelY3[[#This Row],[Cost]]*TravelY3[[#This Row],[Quantity]]*TravelY3[[#This Row],['# of Staff]]*TravelY3[[#This Row],['# of Trips]]*TravelY3[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(TravelY3[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(TravelY3[[#This Row],[Cost]]*TravelY3[[#This Row],[Quantity]]*TravelY3[[#This Row],['# of Staff]]*TravelY3[[#This Row],['# of Trips]]*TravelY3[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(TravelY3[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(TravelY3[[#This Row],[Cost]]*TravelY3[[#This Row],[Quantity]]*TravelY3[[#This Row],['# of Staff]]*TravelY3[[#This Row],['# of Trips]]*TravelY3[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(VLOOKUP(TravelY3[[#This Row],[Type of Expense]],Lists!A:B,2,),\"N/A\")","v":"N/A"},null,null,null,null,null,{"$f":"IFERROR(TravelY3[[#This Row],[Cost]]*TravelY3[[#This Row],[Quantity]]*TravelY3[[#This Row],['# of Staff]]*TravelY3[[#This Row],['# of Trips]]*TravelY3[[#This Row],[% Charged to HVRP]],0)","v":0}]
[null,"Total Travel",null,null,null,null,null,null,null,null,{"$f":"SUM(K36:K43)","v":0}]
[null,"Total Travel - Rounded to the Nearest Whole Dollar",null,null,null,null,null,null,"(must match SF-424A)",null,{"$f":"ROUND(K44,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
["d.","Equipment:\nPer 2 C.F.R. §200.1, equipment is an item of tangible, non-expendable, personal property (including information technology systems – means computing devices, ancillary equipment, software, and firmware etc.) having a useful life of more than one year AND an acquisition cost of at least $5,000 per unit or more regardless of the non-Federal entity’s capitalization threshold.\n\nList the item, quantity, and the unit cost per item. In the Justification of Costs section, describe the need for the equipment, i.e., explain how the use of each item of equipment is related to the implementation of the required/approved activities to achieve the specific project objectives. List expendable items or materials in Supplies. Generally, DOL/VETS does not permit the purchase of equipment during the last funded year of the award."]
[null,"Item","Quantity","Cost Per Unit","% Charged to HVRP","Total"]
[null,null,null,null,null,{"$f":"(C51*D51*E51)","v":0}]
[null,null,null,null,null,{"$f":"(C52*D52*E52)","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,"Total Equipment",null,null,null,{"$f":"SUM(F51:F58)","v":0}]
[null,"Total Equipment - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",null,{"$f":"ROUND(F59,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
["e.","Supplies:\nPer 2 C.F.R. §200.1, supplies are items that cost less than $5,000 per unit and often have a one-time use, that is, materials which are expendable or consumed during the performance of the federal award. A computing device is a supply if the acquisition cost is less than the lesser of the capitalization level established by the organization for financial statement purposes or $5,000, regardless of the length of its useful life. \n\nList the items by type of supply (e.g., training materials, desktop computer, laptop, projector etc.), cost per unit, quantity, or cost per month. Note: subscription services such as cellular phone service or internet service are not tangible and must be listed in Other.\n\nFor each item or cost, include an adequate justification in the Justification of Costs section."]
[null,"Item","Cost Per Unit","Quantity","Cost Per Month","% Charged to HVRP","Total"]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY3[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY3[[#This Row],[Cost Per Unit]]*SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[% Charged to HVRP]],IF(SuppliesY3[[#This Row],[Quantity]]<>\"\",SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12,SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY3[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY3[[#This Row],[Cost Per Unit]]*SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[% Charged to HVRP]],IF(SuppliesY3[[#This Row],[Quantity]]<>\"\",SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12,SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY3[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY3[[#This Row],[Cost Per Unit]]*SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[% Charged to HVRP]],IF(SuppliesY3[[#This Row],[Quantity]]<>\"\",SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12,SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY3[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY3[[#This Row],[Cost Per Unit]]*SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[% Charged to HVRP]],IF(SuppliesY3[[#This Row],[Quantity]]<>\"\",SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12,SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY3[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY3[[#This Row],[Cost Per Unit]]*SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[% Charged to HVRP]],IF(SuppliesY3[[#This Row],[Quantity]]<>\"\",SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12,SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY3[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY3[[#This Row],[Cost Per Unit]]*SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[% Charged to HVRP]],IF(SuppliesY3[[#This Row],[Quantity]]<>\"\",SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12,SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY3[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY3[[#This Row],[Cost Per Unit]]*SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[% Charged to HVRP]],IF(SuppliesY3[[#This Row],[Quantity]]<>\"\",SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12,SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY3[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY3[[#This Row],[Cost Per Unit]]*SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[% Charged to HVRP]],IF(SuppliesY3[[#This Row],[Quantity]]<>\"\",SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12,SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY3[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY3[[#This Row],[Cost Per Unit]]*SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[% Charged to HVRP]],IF(SuppliesY3[[#This Row],[Quantity]]<>\"\",SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12,SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(SuppliesY3[[#This Row],[Cost Per Unit]]<>\"\",SuppliesY3[[#This Row],[Cost Per Unit]]*SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[% Charged to HVRP]],IF(SuppliesY3[[#This Row],[Quantity]]<>\"\",SuppliesY3[[#This Row],[Quantity]]*SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12,SuppliesY3[[#This Row],[Cost Per Month]]*SuppliesY3[[#This Row],[% Charged to HVRP]]*12))","v":0}]
[null,"Total Supplies",null,null,null,null,{"$f":"SUM(G66:G75)","v":0}]
[null,"Total Supplies - Rounded to the Nearest Whole Dollar",null,null,"(must match SF-424A)",null,{"$f":"ROUND(G76,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
["f.","Contractual:\nDescribe contracts and subawards separately.  Contracts are defined according to 2 C.F.R. § 200.1 as a legal instrument by which a non-federal entity purchases goods or services needed to carry out the project or program under a federal award.  A subaward, defined by 2 C.F.R. § 200.1, means an award provided by a pass-through entity to a subrecipient for the subrecipient to carry out part of a federal award received by the pass-through entity.  It does not include payments to a contractor or payments to an individual that is a beneficiary of a federal program. \n\nFor each contract or subaward, list the purpose, goods and/or services to be provided, and the amount. In the Justification of Costs section, describe the goods and/or services to be provided by each contractor or sub-awardee, and how the goods and/or services relate to the accomplishment of specific project objectives.\n\nAll procurement transactions for the acquisition of goods and/or services required under a federal award must be conducted in a manner providing full and open competition consistent with the federal procurement standards in 2 C.F.R. § 200.319 (Competition.) and 2 C.F.R. §200.320 (Methods of procurement to be followed). Applicants must follow their documented procurement procedures which reflect applicable state, local, and tribal laws, and regulations. These procedures must also conform to applicable Federal laws, regulations and the standards identified in 2 C.F.R § 200.318.  Applicants must maintain oversight to ensure that contractors and sub-awardees perform in accordance with the terms, conditions, and specifications of their legal agreement. For additional guidance, refer to 2 C.F.R. § 200.318 through 2 C.F.R. § 200.327 on Procurement Standards."]
[null,"Contract/Subaward","Purpose","Activities to be provivded","Amount","% Charged to HVRP","Total"]
[null,null,null,null,null,null,{"$f":"ContractualY3[[#This Row],[Amount]]*ContractualY3[[#This Row],[% Charged to HVRP]]","v":0}]
[null,null,null,null,null,null,{"$f":"ContractualY3[[#This Row],[Amount]]*ContractualY3[[#This Row],[% Charged to HVRP]]","v":0}]
[null,null,null,null,null,null,{"$f":"ContractualY3[[#This Row],[Amount]]*ContractualY3[[#This Row],[% Charged to HVRP]]","v":0}]
[null,null,null,null,null,null,{"$f":"ContractualY3[[#This Row],[Amount]]*ContractualY3[[#This Row],[% Charged to HVRP]]","v":0}]
[null,"Total Contractual",null,null,null,null,{"$f":"SUM(G83:G86)","v":0}]
[null,"Total Contractual - Rounded to the Nearest Whole Dollar",null,null,"(must match SF-424A)",null,{"$f":"ROUND(G87,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
["g.","Construction:\nConstruction costs are unallowable under the HVRP grant program; and therefore, this budget line-item must be zero. Minor alterations to modernize, improve, and/or reconfigure an existing space for grant activities (such as a classroom alteration) may be allowable, as this is not considered construction. Applicants must include the costs for minor alterations in the budget line-item Contractual.",null,null,null,0]
[]
["h.","Other"]
[null,"Participant Support Costs: \nList participant support costs (e.g., training, clothing, etc.) and provide clear and specific detail, including costs and quantity, for each item so that we can review factors affecting allowability of costs as discussed in 2 C.F.R. § 200.403. Per 2 C.F.R. § 200.1, participant support costs means direct costs for items such as stipends or subsistence allowances, travel allowances, and registration fees paid to or on behalf of participants or trainees (but not employees) in connection with conferences, or training projects. "]
[null,"Item","Cost Per Unit","Quantity","Cost Per Month","% Charged to HVRP","Total","Justification of Costs\n(max 2,620 characters including spaces; users may adjust row height manually to display full text)"]
[null,null,null,null,null,null,{"$f":"IF($C97<>\"\",$C97*$D97*$F97,IF($D97<>\"\",$D97*$E97*$F97*12,$E97*$F97*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF($C98<>\"\",$C98*$D98*$F98,IF($D98<>\"\",$D98*$E98*$F98*12,$E98*$F98*12))","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,"Total Participant Support Services",null,null,null,null,{"$f":"SUM(G97:G105)","v":0}]
[null,"Other Costs:\nList items or expenses not covered in other budget line-items, and provide specific details including the costs and quantity, for each item. Show the basis for the calculations – breakdown costs into the cost per unit or rate (e.g., cost per square foot, cost per participant etc.). "]
[null,"Item","Cost Per Unit","Quantity","Cost Per Month","% Charged to HVRP","Total","Justification of Costs\n(max 2,620 characters including spaces; users may adjust row height manually to display full text)"]
[null,null,null,null,null,null,{"$f":"IF($C109<>\"\",$C109*$D109*$F109,IF($D109<>\"\",$D109*$E109*$F109*12,$E109*$F109*12))","v":0}]
[null,null,null,null,null,null,{"$f":"IF($C110<>\"\",$C110*$D110*$F110,IF($D110<>\"\",$D110*$E110*$F110*12,$E110*$F110*12))","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,"Total Other Costs",null,null,null,null,{"$f":"SUM(G109:G117)","v":0}]
[null,"Other Total (Participant Support Services + Other)",null,null,null,null,{"$f":"SUM(G106,G118)","v":0}]
[null,"Other Total - Rounded to the Nearest Whole Dollar",null,null,null,"(must match SF-424A)",{"$f":"ROUND(G119,0)","v":0}]
[null,"Justification of Costs Not Explained in Columns G:L Above (max 3,225 characters including spaces)"]
[]
[]
["j.","Indirect Costs:\nPer 2 C.F.R. § 200.1 indirect (facilities and administrative (F&A)) costs are costs incurred for a common or joint purpose benefitting more than one cost objective, and not readily assignable to the cost objectives specifically benefitted, without effort disproportionate to the results achieved. To facilitate equitable distribution of indirect expenses to the cost objectives served, it may be necessary to establish several pools of indirect (F&A) costs. \n\nInclude the type of rate or agreement (e.g., Negotiated Indirect Costs Rate Agreement (NICRA), Cost Allocation Plan (CAP), or the de minimis rate of 10% of modified total direct costs (MTDC)), the total approved base (if applicable), and the approved rate (if applicable).\n\nIf using a NICRA, in the Justification of Costs section, provide an explanation of how the indirect costs are calculated. This explanation should include which portion of each line item, along with the associated costs, are included in your allocation base.\n\nIf using the de minimis rate of 10% of MTDC, in the Justification of Costs section, provide an explanation of which portion of each line item, along with the associated costs, are included in your allocation base. Note that there are various items not included in the calculation of MTDC, see 2 C.F.R. § 200.1 for specific exclusions. \n\nIf using a CAP, in the Justification of Costs section, provide estimated indirect costs based on your approved allocation methodology. "]
[null,"Type of Rate Agreement","Base","Rate","Total Indirect Costs"]
[null,null,null,null,{"$f":"IF(OR(Indirect_CostsY3[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_CostsY3[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),D126*C126,C126)","v":0}]
[null,null,null,null,{"$f":"IF(OR(Indirect_CostsY3[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_CostsY3[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),D127*C127,C127)","v":0}]
[null,null,null,null,{"$f":"IF(OR(Indirect_CostsY3[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_CostsY3[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),D128*C128,C128)","v":0}]
[null,null,null,null,{"$f":"IF(OR(Indirect_CostsY3[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_CostsY3[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),D129*C129,C129)","v":0}]
[null,null,null,null,{"$f":"IF(OR(Indirect_CostsY3[[#This Row],[Type of Rate Agreement]]=\"NICRA\",Indirect_CostsY3[[#This Row],[Type of Rate Agreement]]=\"De Minimus\"),D130*C130,C130)","v":0}]
[null,"Total Indirect Costs",null,null,{"$f":"SUM(E126:E130)","v":0}]
[null,"Total Indirect Costs - Rounded to the Nearest Whole Dollar",null,"(must match SF-424A)",{"$f":"ROUND(E131,0)","v":0}]
[null,"Justification of Costs (max 3,225 characters including spaces)"]
[]
[]
[null,"Total Costs","Column1"]
[null,"Total Direct Costs",{"$f":"SUM(G120,G88,G77,K45,E30,E17,F60)","v":0}]
[null,"Total Indirect Costs",{"$f":"E132","v":0}]
[null,"Total Costs funded by Grant\n(must match the total on the SF-424 and SF-424A, as well as the Year 1 total on the VETS-704 Abstract)",{"$f":"SUM(C137:C138)","v":0}]
[]
[null,"Leveraged Resources:\nThe HVRP grant program does not require cost sharing or matching funds. However, the Budget Narrative should include a section describing any leveraged resources provided (as applicable) to support grant activities. DOL/VETS considers any resources contributed to the project, beyond the funds provided by the agency, as leveraged resources. Applicants are encouraged to leverage resources to increase stakeholder investment in the project and broaden and sustain the impact of the project itself. The Budget Narrative should provide a description of the leveraged resources provided to support grant activities, the specific activities they will cover, the way they will support HVRP goals and the funding source. Valuation of leveraged resources follows the same requirements as matching funds.  "]
[null,"Description of Leveraged Resources (max 3,225 characters including spaces)"]
[]
[]
[null,"**DOL/VETS does not allow the purchase of construction, motor vehicles, buildings, or land."]

{"sheet":"Total POP Budget","index":7,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":true,"merged":[[0,1,0,7],[58,0,99,7],[19,0,56,7]]}
[null,"Total POP Budget by Program Year (PY)"]
[null,"Object Class Categories","Initial PY HVRP Budget","Second PY HVRP Budget","Third PHVRP Budget","Column1","Column2","Total POP Budget"]
[null,"a.  Personnel",{"$f":"'First PY Budget'!$D19","v":0},{"$f":"'Budget Narrative Template Y2'!$E17","v":0},{"$f":"'Budget Narrative Template Y3'!$E17","v":0},null,null,{"$f":"SUM(C3:G3)","v":0}]
[null,"b.  Fringe Benefits",{"$f":"'First PY Budget'!$D35","v":0},{"$f":"'Budget Narrative Template Y2'!$E30","v":0},{"$f":"'Budget Narrative Template Y3'!$E30","v":0},null,null,0]
[null,"c.  Travel",{"$f":"'First PY Budget'!$J55","v":0},{"$f":"'Budget Narrative Template Y2'!$K45","v":0},{"$f":"'Budget Narrative Template Y3'!$K45","v":0},null,null,0]
[null,"d.  Equipment",{"$f":"'First PY Budget'!$E75","v":0},{"$f":"'Budget Narrative Template Y2'!$F60","v":0},{"$f":"'Budget Narrative Template Y3'!$F60","v":0},null,null,0]
[null,"e.  Supplies",{"$f":"'First PY Budget'!$F97","v":0},{"$f":"'Budget Narrative Template Y2'!$G77","v":0},{"$f":"'Budget Narrative Template Y3'!$G77","v":0},null,null,0]
[null,"f.  Contractual",{"$f":"'First PY Budget'!$F111","v":0},{"$f":"'Budget Narrative Template Y2'!$G88","v":0},{"$f":"'Budget Narrative Template Y3'!$G88","v":0},null,null,0]
[null,"g.  Construction",0,0,0,null,null,0]
[null,"h.  Other",{"$f":"'First PY Budget'!$F162","v":0},{"$f":"'Budget Narrative Template Y2'!$G120","v":0},{"$f":"'Budget Narrative Template Y3'!$G120","v":0},null,null,{"$f":"SUM(C10:G10)","v":0}]
[null,"i.  Total Direct Charges (sum of 6a-6h)",{"$f":"SUM(C3:C10)","v":0},{"$f":"SUM(D3:D10)","v":0},{"$f":"SUM(E3:E10)","v":0},null,null,{"$f":"SUM(C11:G11)","v":0}]
[null,"j.  Indirect Charges",{"$f":"'First PY Budget'!$D179","v":0},{"$f":"'Budget Narrative Template Y2'!$E132","v":0},{"$f":"'Budget Narrative Template Y3'!$E132","v":0},null,null,{"$f":"SUM(C12:G12)","v":0}]
[null,"k.  Totals (sum of 6i-6j)",{"$f":"SUM(C12,C11)","v":0},{"$f":"SUM(D12,D11)","v":0},{"$f":"SUM(E12,E11)","v":0},null,null,{"$f":"SUM(H11:H12)","v":0}]

{"sheet":"Lists","index":8,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Type of Expense","Basis"]
["Local Travel","N/A"]
["Lodging","Night"]
["Meals","Day"]
["Mileage","Mile"]
["Rental","N/A"]
["Transportation","Round-Trip"]
["Other","N/A"]