{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["3- DFPS Program Budget ","Instructions"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"3- DFPS Program Budget ","index":0,"n_rows":196,"n_cols":12,"rows_kept":196,"cut":false,"hidden":false,"merged":[[155,6,155,7],[155,8,155,9],[0,0,0,4],[5,6,5,11],[90,6,90,7],[105,9,105,10],[154,6,154,9]]}
["FY22 Grant Budget"]
[null,"RFA Applicant:","Applicant Name",null," "]
[null,"Total DFPS Grant Obligation : ",{"$f":"B48+B91+B106+B114+B127+B133+B151+B167+B175","v":0}]
[null,"Total Match : ",{"$f":"D48+D91+D106+D114+D127+D133+D151+D167+D175","v":0}]
[null,"Funding Period : ","9/01/2021 to 08/31/2022",null," "]
[null,null," ",null," ",null,"FTE Allocations"]
["PERSONNEL - SALARIES","DFPS Grant Budget","Methodology for \nGrant Budget Narrative","Match \nBudget","Methodology for \nMatch Budget Narrative",null," Total Salary","FTE","% Time Allocated to DFPS Grant","% Time Allocated to  Match","Number of months on Grant","Direct Service or Admin?"]
[null,0,null,{"$f":"IF(K8=0,\"0\",ROUND((G8/12)*H8*J8*K8,2))","v":"0"},null,null,0,0,0,0,0,"Direct Service"]
["2",{"$f":"IF(K9=0,\"0\",ROUND((G9/12)*H9*I9*K9,2))","v":"0"},null,{"$f":"IF(K9=0,\"0\",ROUND((G9/12)*H9*J9*K9,2))","v":"0"},null,null,0,0,0,0,0]
["3","0",null,"0",null,null,0,0,0,0,0]
[4,"0",null,"0",null,null,0,0,0,0,0]
[5,"0",null,"0",null,null,0,0,0,0,0]
[6,"0",null,"0",null,null,0,0,0,0,0]
[7,"0",null,"0",null,null,0,0,0,0,0]
[8,"0",null,"0",null,null,0,0,0,0,0]
[9,"0",null,"0",null,null,0,0,0,0,0]
[10,"0",null,"0",null,null,0,0,0,0,0]
[11,"0",null,"0",null,null,0,0,0,0,0]
[12,"0",null,"0",null,null,0,0,0,0,0]
[13,"0",null,"0",null,null,0,0,0,0,0]
[14,"0",null,"0",null,null,0,0,0,0,0]
[15,"0",null,"0",null,null,0,0,0,0,0]
[16,"0",null,"0",null,null,0,0,0,0,0]
[17,"0",null,"0",null,null,0,0,0,0,0]
[18,"0",null,"0",null,null,0,0,0,0,0]
[19,"0",null,"0",null,null,0,0,0,0,0]
[20,"0",null,"0",null,null,0,0,0,0,0]
[21,"0",null,"0",null,null,0,0,0,0,0]
[22,"0",null,"0",null,null,0,0,0,0,0]
[23,"0",null,"0",null,null,0,0,0,0,0]
[24,"0",null,"0",null,null,0,0,0,0,0]
[25,"0",null,"0",null,null,0,0,0,0,0]
[26,"0",null,"0",null,null,0,0,0,0,0]
[27,"0",null,"0",null,null,0,0,0,0,0]
[28,"0",null,"0",null,null,0,0,0,0,0]
[29,"0",null,"0",null,null,0,0,0,0,0]
[30,"0",null,"0",null,null,0,0,0,0,0]
[31,"0",null,"0",null,null,0,0,0,0,0]
[32,"0",null,"0",null,null,0,0,0,0,0]
[33,"0",null,"0",null,null,0,0,0,0,0]
[34,"0",null,"0",null,null,0,0,0,0,0]
[35,"0",null,"0",null,null,0,0,0,0,0]
[36,"0",null,"0",null,null,0,0,0,0,0]
[37,"0",null,"0",null,null,0,0,0,0,0]
[38,"0",null,"0",null,null,0,0,0,0,0]
[39,"0",null,"0",null,null,0,0,0,0,0]
[40,"0",null,"0",null,null,0,0,0,0,0]
["Total",{"$f":"SUM(B8:B47)","v":0},null,{"$f":"SUM(D8:D47)","v":0},null,null,{"$f":"SUM(G8:G47)","v":0}]
[]
["FRINGE by EMPLOYEE","DFPS Grant Budget","Methodology for \nGrant Budget Narrative","Match \nBudget","Methodology for \nMatch Budget Narrative",null,"Total Fringe per Employee","FTE","% Fringe Allocated to DFPS Grant","% Fringe Allocated to  Match","Number of months on Grant","Fringe % of Salary "]
[{"$f":"A8","v":0},{"$f":"IF(K51=0,\"0\",ROUND((G51/12)*H51*I51*K51,2))","v":"0"},null,{"$f":"IF(K51=0,\"0\",ROUND((G51/12)*H51*J51*K51,2))","v":"0"},null,null,{"$f":"G8*L51","v":0},{"$f":"H8","v":0},0,0,0,0]
["2",{"$f":"IF(K52=0,\"0\",ROUND((G52/12)*H52*I52*K52,2))","v":"0"},null,{"$f":"IF(K52=0,\"0\",ROUND((G52/12)*H52*J52*K52,2))","v":"0"},null,null,{"$f":"G9*L52","v":0},0,0,0,0,0]
["3","0",null,"0",null,null,0,0,0,0,0,0]
[4,"0",null,"0",null,null,0,0,0,0,0,0]
[5,"0",null,"0",null,null,0,0,0,0,0,0]
[6,"0",null,"0",null,null,0,0,0,0,0,0]
[7,"0",null,"0",null,null,0,0,0,0,0,0]
[8,"0",null,"0",null,null,0,0,0,0,0,0]
[9,"0",null,"0",null,null,0,0,0,0,0,0]
[10,"0",null,"0",null,null,0,0,0,0,0,0]
[11,"0",null,"0",null,null,0,0,0,0,0,0]
[12,"0",null,"0",null,null,0,0,0,0,0,0]
[13,"0",null,"0",null,null,0,0,0,0,0,0]
[14,"0",null,"0",null,null,0,0,0,0,0,0]
[15,"0",null,"0",null,null,0,0,0,0,0,0]
[16,"0",null,"0",null,null,0,0,0,0,0,0]
[17,"0",null,"0",null,null,0,{"$f":"H24","v":0},0,0,0,0]
[18,"0",null,"0",null,null,0,0,0,0,0,0]
[19,"0",null,"0",null,null,0,0,0,0,0,0]
[20,"0",null,"0",null,null,0,0,0,0,0,0]
[21,"0",null,"0",null,null,0,0,0,0,0,0]
[22,"0",null,"0",null,null,0,0,0,0,0,0]
[23,"0",null,"0",null,null,0,0,0,0,0,0]
[24,"0",null,"0",null,null,0,0,0,0,0,0]
[25,"0",null,"0",null,null,0,0,0,0,0,0]
[26,"0",null,"0",null,null,0,0,0,0,0,0]
[27,"0",null,"0",null,null,0,0,0,0,0,0]
[28,"0",null,"0",null,null,0,0,0,0,0,0]
[29,"0",null,"0",null,null,0,0,0,0,0,0]
[30,"0",null,"0",null,null,0,0,0,0,0,0]
[31,"0",null,"0",null,null,0,0,0,0,0,0]
[32,"0",null,"0",null,null,0,0,0,0,0,0]
[33,"0",null,"0",null,null,0,{"$f":"H40","v":0},0,0,0,0]
[34,"0",null,"0",null,null,0,0,0,0,0,0]
[35,"0",null,"0",null,null,0,0,0,0,0,0]
[36,"0",null,"0",null,null,0,0,0,0,0,0]
[37,"0",null,"0",null,null,0,0,0,0,0,0]
[38,"0",null,"0",null,null,0,0,0,0,0,0]
[39,"0",null,"0",null,null,0,0,0,0,0,0]
[40,"0",null,"0",null,null,0,0,0,0,0,0]
["Total",{"$f":"ROUND(SUM(B51:B90),2)","v":0},null,{"$f":"SUM(D51:D90)","v":0},null,null,"Total Fringe % (of Salary)",null,{"$f":"IF(B48=0,0,B91/B48)","v":0},{"$f":"IF(B48=0,0,D91/B48)","v":0}]
[]
["FRINGE by TYPE of BENEFIT","DFPS Grant Budget","Methodology for \nGrant Budget Narrative","Match \nBudget","Methodology for \nMatch Budget Narrative",null,"Total Fringe for DFPS Program Benefits","% Fringe Allocated to DFPS Grant","% Fringe Allocated to  Match"]
["Social Security (FICA)",{"$f":"G94*H94","v":0},null,{"$f":"G94*I94","v":0},null,null,0,0,0]
["State Unemployment Tax Act (SUTA)",{"$f":"G95*H95","v":0},null,{"$f":"G95*I95","v":0},null,null,0,0,0]
["Retirement",0,null,0,null,null,0,0,0]
["Insurance- Medical",0,null,0,null,null,0,0,0]
["Insurance- Dental",0,null,0,null,null,0,0,0]
["Insurance- Vision",0,null,0,null,null,0,0,0]
["Insurance- Worker's Compensation ",0,null,0,null,null,0,0,0]
["Insurance- Unemployment ",0,null,0,null,null,0,0,0]
["Short-Term Disability",0,null,0,null,null,0,0,0]
["Long-Term Disability",0,null,0,null,null,0,0,0]
["Life Insurance",0,null,0,null,null,0,0,0]
["Other Fringe",0,null,0,null,null,0,0,0]
["Total",{"$f":"SUM(B94:B105)","v":0},null,{"$f":"SUM(D94:D105)","v":0},null,null,null,{"$f":"B106/B48","v":{"$error":"#DIV/0!"}},{"$f":"D106/B48","v":{"$error":"#DIV/0!"}},"Total Fringe % (of Salary)"]
[]
["TRAVEL  ","DFPS Grant Budget","Methodology for \nGrant Budget Narrative","Match \nBudget","Methodology for \nMatch Budget Narrative"]
["Mileage",0,null,0," "]
["Airfare",0," ",0," "]
["Meals",0," ",0," "]
["Lodging",0," ",0," "]
["Miscellaneous Transportation",0," ",0," "]
["Total",{"$f":"SUM(B109:B113)","v":0},null,{"$f":"SUM(D109:D113)","v":0}]
[]
["SUPPLIES and CONTROLLED ASSETS","DFPS Grant Budget","Methodology for \nGrant Budget Narrative","Match \nBudget","Methodology for \nMatch Budget Narrative"]
["Office Supplies",0,null,0]
["Program Curriculum",0,null,0]
["Outreach Materials/Program Literature",0,null,0]
["Technology (controlled assets)",0,null,0]
["other supplies and controlled assets",0,null,0]
["other supplies and controlled assets",0,null,0]
["other supplies and controlled assets",0,null,0]
["other supplies and controlled assets",0,null,0]
["other supplies and controlled assets",0,null,0]
["other supplies and controlled assets",0,null,0]
["Total",{"$f":"SUM(B117:B126)","v":0},null,{"$f":"SUM(D117:D126)","v":0}]
[]
["CAPITAL EQUIPMENT (greater than $5K)","DFPS Grant Budget","Methodology for \nGrant Budget Narrative","Match \nBudget","Methodology for \nMatch Budget Narrative"]
[null,0,null,0]
[null,0,null,0]
[null,0,null,0]
["Total",{"$f":"SUM(B130:B132)","v":0},null,{"$f":"SUM(D130:D132)","v":0}]
[]
["OTHER","DFPS Grant Budget","Methodology for \nGrant Budget Narrative","Match \nBudget","Methodology for \nMatch Budget Narrative"]
["Direct Assistance for Program Clients (contractors)",0,null,0," "]
["Program Incentives",0,null,0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Other",0," ",0," "]
["Total",{"$f":"SUM(B136:B150)","v":0},null,{"$f":"SUM(D136:D150)","v":0}]
[]
["SUBTOTAL \nExcluding Subawards","DFPS Grant Budget","Methodology for \nGrant Budget Narrative","Match \nBudget","Methodology for \nMatch Budget Narrative"]
[null,{"$f":"B48+B91+B106+B114+B127+B133+B151","v":0},null,{"$f":"D48+D91+D106+D114+D127+D133+D151","v":0}]
[null,null,null,null,null,null,"Subaward Expenses Added to Indirect Cost Budget"]
["CONTRACTUAL - \nSubawards","DFPS Grant Budget","Methodology for \nGrant Budget Narrative","Match \nBudget","Methodology for \nMatch Budget Narrative",null,"Reimburseable Amount Subject to Indirect Cost Rate",null,"Match Amount \nSubject to Indirect Cost Rate"]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,0,null,0]
["Total",{"$f":"SUM(B157:B166)","v":0},null,{"$f":"SUM(D157:D166)","v":0}]
[]
["Subaward Costs added to the Indirect Cost Calculation"]
[" ",{"$f":"SUM(H157:H166)","v":0},null,{"$f":"SUM(J157:J166)","v":0}]
[]
["INDIRECT COSTS","DFPS Grant Budget","Methodology for \nGrant Budget Narrative","Match \nBudget","Methodology for \nMatch"]
[0,{"$f":"ROUND(B154+B170,2)*A173","v":0}," ",{"$f":"ROUND(D154+D170,2)*A173","v":0}," "]
["Indirect Cost Rate adjustment",0,null,0]
["Total",{"$f":"SUM(B173:B174)","v":0},null,{"$f":"SUM(D173:D174)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Direct Service or Admin?"]
["Direct Service"]
["Admin"]

{"sheet":"Instructions","index":1,"n_rows":109,"n_cols":4,"rows_kept":109,"cut":false,"hidden":false,"merged":[[6,0,6,3],[7,0,7,3],[8,0,8,3],[9,0,9,3],[10,0,10,3],[11,0,11,3],[0,0,0,2],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[5,0,5,3],[18,0,18,3],[19,0,19,3],[20,1,20,3],[21,0,21,3],[22,0,22,3],[23,0,23,3],[12,0,12,3],[13,0,13,3],[14,0,14,3],[15,0,15,3],[16,0,16,3],[17,0,17,3],[30,0,30,3],[31,0,31,3],[32,0,32,3],[33,0,33,3],[34,0,34,3],[35,0,35,3],[24,0,24,3],[25,0,25,3],[26,0,26,3],[27,0,27,3],[28,0,28,3],[29,0,29,3],[42,0,42,3],[43,0,43,3],[44,0,44,3],[45,0,45,3],[46,0,46,3],[47,0,47,3],[36,0,36,3],[37,0,37,3],[38,0,38,3],[39,0,39,3],[40,0,40,3],[41,0,41,3],[54,0,54,3],[55,0,55,3],[56,0,56,3],[57,0,57,3],[58,0,58,3],[59,0,59,3],[48,0,48,3],[49,0,49,3],[50,0,50,3],[51,0,51,3],[52,0,52,3],[53,0,53,3],[66,0,66,3],[67,0,67,3],[68,0,68,3],[69,0,69,3],[70,0,70,3],[71,0,71,3],[60,0,60,3],[61,0,61,3],[62,0,62,3],[63,0,63,3],[64,0,64,3],[65,0,65,3],[78,0,78,3],[79,0,79,3],[80,0,80,3],[81,0,81,3],[82,0,82,3],[83,0,83,3],[72,0,72,3],[73,0,73,3],[74,0,74,3],[75,0,75,3],[76,0,76,3],[77,0,77,3],[90,0,90,3],[91,0,91,3],[92,0,92,3],[93,0,93,3],[95,0,95,3],[96,0,96,3],[84,0,84,3],[85,0,85,3],[86,0,86,3],[87,0,87,3],[88,0,88,3],[89,0,89,3],[103,0,103,3],[104,0,104,3],[105,0,105,3],[106,0,106,3],[107,0,107,3],[108,0,108,3],[97,0,97,3],[98,0,98,3],[99,0,99,3],[100,0,100,3],[101,0,101,3],[102,0,102,3]]}
["Texas Department of Family and Protective Services",null,null,"Form 2030"]
["Instructions for Completing Form 2030 \nExpenditure Proposal for Grants"]
["These instructions will explain how to submit the Expenditure Proposal."]
["Form 2030 - Expenditure Proposal Summary Tab"]
["Because this is a Cost Reimbursement grant, DFPS is not obligated to pay unauthorized costs or to pay more than the Applicant's allowable and actual incurred costs.  These costs must be in compliance with the appropriate regulations.  Federally funded grants follow the Uniform Grant Guidelines (UGG) and State funded grants follow the Uniform Grant Management Standards (UGMS). "]
["The 2030 is designed to maintain the original Approved Budget and monthly invoices for the grant.  All of the expenditure information in this Summary will be carried forward from the Applicant's Expenditure Proposal.  The only information the Applicant needs to provide on this tab is  the name and title of the individual who is authorized to certify the expediture proposal.  Please include the date that this budget was certified. "]
["Reimbursable expenses will be charged to DFPS in the month that the cost is reflected on the Applicant's general ledger.  For example, mileage was reimbursed in October (and hits the Applicant's October general ledger) for September travel- then the expense would be included on the Applicant's October Billing Invoice.  More information is available on the tab, \"Instructions- Billing Invoice\"."]
["The Expenditure Proposal is composed of the following seven budget categories:\n     1. Salaries\n     2. Fringe Benefits (per Employee or by Type of Benefit)\n     3. Travel\n     4. Supplies and Controlled Assets\n     5. Capital Equipment (expense exceeding $5,000)\n     6. Other\n     7. Contractual (subawards)\n"]
[]
["Expenditure Proposal Tab"]
["In general, only enter amounts or information in non-shaded areas.  The shaded cells are protected- because the data is either a formula or carried forward from another cell.  "]
["In column C, enter the methodology for the Applicant's Reimbursable budget line items.  The Appliant's methodology should provide a level of detail that will allow the DFPS staff to approve the amount of funds being requested on a line by line basis.  In many instances, it will be more efficient to provide the details and eliminate assumptions."]
["In columns D & E, if the grant does not require Match- please disregard this section and these calculations.\n\nIf the grant does requires Match, please enter the methodology for the grant budget line items that will be budgeted to Match.  The methodology should provide a level of detail that will allow the DFPS staff to approve the amount of funds being requested on a line by line basis.  In many instances, it will be more efficient to provide the details and eliminate assumptions."]
["List the organization's name in C2 and the organization's name will populate throughout the workbook.  DFPS will provide the Applicant funding source.  Please identify the individual in the Applicant's organization that is preparing and approving this budget."]
["Once finalized, this tab will be renamed the \"Approved\" Budget.  "]
["The following sections will explain how to provide budget information for the individual Budget Categories:"]
[]
["SALARIES"]
["In column A, list the titles for each individual staff person directly working on this grant. Do not list employee names.  This includes all staff whose salaries are all or partially reimbursable and salaries that are all or partially contributing to Match."]
["In column G, list the Annual Salary for each individual."]
[null,"Please propose any pay raises that will occur during the grant term.  In the methodology section (Column C and/or Column E), clearly indicate the number of months at one pay rate and the number of months at the increased pay rate.  The methodology should calculate to the Annual Salary being listed in Column G.\n"]
["In column H, list whether the individual is full-time (1.0) or part-time.  If part time, identify the amount of time the individual is employed, i.e. 0.5 for half time, 0.75 for 3/4 time, etc.  "]
["In column I, list the amount of percentage of time this individual will be allocated to this grant. For example, list the individual at 100% or 50% or ...  "]
["If the grant requires Match, In column J, list the percentage of salary this individual will contribute to the Applicant's Match requirement.  For example, list the individual at 0% or 50% or …"]
["In column K, list the number of months each individual will work on this grant during each state fiscal year."]
["In column L, indicate whether the staff is in a direct service or administrative role by using the drop down arrow."]
["In column B, this total will represent the Reimbursable funds needed to work on this grant during each state fiscal year.  \n"]
["The Total Salaries in B71 will be carried forward to the Form 2030 tab (cell D10)."]
["In column D, this total will represent the Match funds needed to work on this grant during the each state fiscal year.  \n"]
[]
["FRINGE by EMPLOYEE"]
["Complete either the Fringe by Employee section or the Fringe by Type of Benefit section - but do not complete both "]
["The positions listed in the Salaries section will auto populate in Column A (cells A75 to A 124).  The FTE Allocations from the Salaries section will also auto populate.  "]
["Enter the fringe benefit percentage (cells L75-L124) that will each individual working on this grant will be budgeted to receive.  Different individuals can have different budgeted percentages.  "]
["The total fringe per employee will be calculated in column G."]
["The total fringe per employee that is Reimbursable will be calculated in column B.  This calculation is based on the Total Fringe per Employee (column G) and the percent of time allocated to the grant (column H). "]
["The Total Reimbursement Fringe per Employee  (cell B125) will be carried forward to the Form 2030 tab (cell D11 )."]
["The total fringe per employee that is Match will be calculated in column D.  This calculation is based on the Total Fringe per Employee (column G) and the percent of time allocated to the Match (column J). "]
[]
["FRINGE by TYPE of BENEFIT"]
["Complete either the Fringe by Employee section or the Fringe by Type of Benefit section - but do not complete both "]
["If all staff are not included in the calculations, specify to whom the benefits applies to or does not apply to (whichever is clearer)"]
["The following definitions and formulas may be helpful:\n"]
["Social Security is the Federal Insurance Contributions Act (FICA) and is the total of the FICA rate (7.65%) x the participating staffs' salaries."]
["Texas Unemployment Compensation Act (TUCA) is the total of the rate assigned by TWC (4.34% of the first $9,000 per employee) x the participating staffs' salaries."]
["Retirement is the rate (dependent on the type of plan) x the participating staffs' salaries."]
["Health Insurance costs are also dependent on the (various) plans' benefits x the participating staffs' salaries. "]
["Worker's Compensation is purchased through private insurance firms that determine the appropriate employment classification and rates."]
["In column G, enter the budget needed for each individual type of benefit."]
["In column H, enter the percentage of time allocated staff are allocated to directly work on the grant during each state fiscal year."]
["The Total Reimbursement Fringe by Type of Benefit (cell B141) will be carried forward to the Form 2030 tab (cell D12)."]
["In column I, enter the percentage of time allocated staff are allocated to Match during the state fiscal year."]
[]
["TRAVEL"]
["The following definitions and formulas may be helpful:\n"]
["Meals, Lodging, Mileage Reimbursements and Transportation costs can be budgeted on a flat per diem basis or a cost-incurred basis (follow the grant terms and conditions).  The Applicant may use either method- but must use the same methodology consistently to compute all costs.  The Applicant should specify the methodology in column C or column E (Match).  "]
["If the Applicant chooses the per diem methodology, the Applicant's expenses may not exceed the per diem and mileage rate established in the grant terms and conditions.  The Applicant's subgrantees are also subject to these rates and limitations."]
["If the Applicant chooses the cost-incurred methodology, receipts documenting the expense must be maintained to substantiate the reimbursement."]
["Items normally included in the methodology column would be positions authorized to travel, number of miles/units and mileage rate, and the travel purpose (client visit, training class, conference…)"]
["In column B, enter the amounts that will be needed for Reimbursable mileage, airfare, meals, lodging and miscellaneous."]
["The Total Travel (cell B150) will be carried forward to the Form2030 tab (cell D13)."]
["In column D, enter the amounts that will be needed for Match mileage, airfare, meals, lodging and miscellaneous."]
["Miscellaneous transportation costs include car rentals, fuel, taxi, toll road charges, parking fees…"]
["Expected out-of-state travel can be included in the Applicant's budget proposal."]
["Please ensure that the methodology (column C and column E) will provide an adequate explanation for the expenses being budgeted."]
[]
["SUPPLIES and CONTROLLED ASSETS"]
["In column A, there are 3 supply types and 1 controlled asset type listed and 6 rows where the Applicant can create budgets for various supply needs."]
["Controlled Assets are items of real or personal property with an estimated life of greater than one year, but an acquisition cost of less than $5000.  These items are considered high risk and have a high potential for loss; therefore, controlled assets must be maintained in the Applicant's inventory system and tagged accordingly based on specific acquisition costs. Applicants should review the Comptroller's State Property Accounting User Manual for the most current information regarding controlled assets.  "]
["Please ensure that the methodology (column C and column E) will provide an adequate explanation for the expenses being budgeted.\nFor example, Office Supplies methodology could state \"$75 (based on last year's expenditures) x 10 FTEs = $75.\nFor example, Controlled Asset- Camera methodology could state (2) Cannon Digital Rebel Xti cameras x $800 = $1600.\nFor example, Controlled Asset- Computers- could include the purchase of laptops, tablets, iPads, desktops..."]
["In column B, enter the amounts requested for Reimbursable supplies"]
["The Total Supplies (cell B164) will be carried forward to the Form 2030 tab (cell D14)."]
["In column E, enter the amounts requested for Match supplies."]
[]
["CAPITAL EQUIPMENT"]
["In column A, list any equipment that meets or exceeds the capitalization threshold ($5,000).  The tangible personal property must have a useful life of more than one year.  The equipment purchased with DFPS funds must be tagged by the Applicant and must be inventoried on an annual basis (at minimum).\n"]
["Non-capitalized equipment will be budgeted in the \"Supplies and Controlled Assets\" budget category. \nLeased equipment will be budgeted in the \"Other\" budget category."]
[]
["OTHER"]
["Do not list any Indirect Costs here. "]
["Items listed in the \"Other\" budget category include items that do not fit under any other cost categories.  These items could include federal background checks, cell phone expenses, internet charges, space rental, leased items, professional dues, conference registration fee, accounting software annual maintenance fees, software for new computers..."]
["In column A, there are 35 lines available to list a budget for an allowable expense that does not fit in any of the previous budget categories.  the Applicant can type over the word \"other\"."]
["In column B, enter the amounts that will be needed for Reimbursable Other expenses."]
["The Total Other (cell B210) will be carried forward to the Form 2030 tab (cell D16)."]
["In column D, enter the amounts that will be needed for Match Other expenses."]
["Please ensure that the methodology (column C and column E) will provide an adequate explanation for the budgeted expenses."]
[]
["SUBTOTAL - Excluding Subawards"]
["There is no budget information to enter here."]
["This is a total that will be used when calculating Indirect Costs."]
[]
["CONTRACTUAL - Subaward"]
["Cell A217 will auto populate if a subaward budget is completed in the corresponding Sub Budget 1 tab."]
["Cells A218-A226 are reserved for additional subawards."]
[]
["Subaward Expenses Added to Indirect Cost Budget"]
["For Reimbursable Expenses, enter an amount up to (but not exceeding) $25,000 in cells H217 through H226 for the corresponding subawards listed in cells A217 to A226.  "]
["The total in cell B231 will be added with the total in B214 and is multiplied by the approved indirect cost rate."]
["The Reimbursable indirect cost total is calculated in cell B236 and will be carried forward to the Form 2030 tab (cell D20)."]
[]
["INDIRECT COSTS"]
["If the Applicant chooses not to charge Indirect Costs to this grant, enter a zero in A234.  Zero totals will be automatically calculated for this category. "]
["Section Section 200.414 (c) of 2 CFR 215 (the Uniform Grant Guidelines = UGG) allows the Applicant to use a Federally Negotiated Indirect Cost Rate  for a period of up to four years.  Enter that amount in A234.  State the Negotiated Rate in the Methodology (C175) and identify the % being charged to this grant and any/if % being charged to Match (D234 and E234).  The Applicant should submit a copy of the Organization's Indirect Cost Rate Agreement with the expenditure proposal.  Label Attachment Q-1"]
["Section 200.414 of 2 CFR 215 allows an Applicant who has never received a negotiated indirect cost rate, to charge a de minimis rate of 10% of modified total direct costs (MTDC)- which may be used indefinitely.  In 200.68, MTDC is defined as all direct salaries and wages, applicable fringe benefits, materials and supplies, travel & up to $25,000 of each subaward.  MTDC excludes equipment, capital equipment, rental costs, and subawards in excess of $25,000.  This methodology once elected, must be used consistently for all Federal awards until such time as a non-Federal entity chooses to negotiate for a rate- which can be done at any time.  The UGG allows the Applicant to charge a \"de minimus\" indirect cost rate of 10% or a Modified Total Direct Cost Rate of 10%- indefinitely (Section 200.414 (f)).  If choosing the 10% rate, enter 10% in A234 and write the words \"de minimus\" in C234."]
["The biggest advantage for using this methodology is that the Applicant does not have to support the 10% charged to this grant.   The UGG requires the State of Texas to accept this indirect cost rate, and in addition, encourages subrecipients and recipients to take advantage of this methodology.    "]
["If the Applicant chooses not to use the \"de minimus\" rate and the Applicant does not have a Federally Negotiated rate, the Applicant's Indirect Cost Allocation Methodology Plan must be submitted with the Applicants expenditure proposal.  DFPS must approve the methodology.  Enter the requested rate in A234.  The formula is set to calculate the total indirect costs."]
[]
["MATCH"]
["Expenses used for Match requirements must follow the same guidelines as reimbursable expenses.  They must be reasonable, necessary, allowable and correctly allocated.  Similar to reimbursable expenses, clear and concise explanations must be provided in the Methodology (column E)."]