{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Budget Summary","Budget Detail"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":11,"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 Summary","index":0,"n_rows":44,"n_cols":3,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,0,2,3],[18,0,18,3],[43,1,43,3],[21,2,21,3],[24,2,24,3],[26,2,26,3],[28,2,28,3],[30,2,30,3],[32,2,32,3],[34,2,34,3],[36,2,36,3],[40,2,40,3],[38,2,38,3]]}
[]
["Attachment B - Budget Worksheets"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FY2023 Emerging Adults Reentry Initiative"]
[]
[]
["Cost Categories",null,"Total"]
[]
[]
["Personnel Costs",null,{"$f":"'Budget Detail'!E16","v":0}]
[]
["Fringe Costs",null,{"$f":"'Budget Detail'!E26","v":0}]
[]
["Consultants/Contractors Costs",null,{"$f":"'Budget Detail'!E36","v":0}]
[]
["Equipment Costs",null,{"$f":"'Budget Detail'!E46","v":0}]
[]
["Travel Costs",null,{"$f":"'Budget Detail'!E56","v":0}]
[]
["Supplies Costs",null,{"$f":"'Budget Detail'!E66","v":0}]
[]
["Other Costs",null,{"$f":"'Budget Detail'!E76","v":0}]
[]
["Indirect Costs",null,{"$f":"'Budget Detail'!E88","v":0}]
[]
["Total Costs",null,{"$f":"'Budget Detail'!E90","v":0}]
[]
[]
["Name of Applicant Organization "]

{"sheet":"Budget Detail","index":1,"n_rows":90,"n_cols":10,"rows_kept":90,"cut":false,"hidden":false,"merged":[[39,0,39,5],[48,0,48,5],[49,0,49,5],[25,0,25,3],[35,0,35,3],[45,0,45,3],[18,0,18,5],[19,0,19,5],[28,0,28,5],[29,0,29,5],[38,0,38,5],[15,0,15,3],[9,0,9,5],[8,0,8,5],[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[7,0,7,5],[6,0,6,5],[5,0,5,5],[90,0,90,4],[65,0,65,3],[55,0,55,3],[75,0,75,3],[89,0,89,3],[58,0,58,5],[59,0,59,5],[68,0,68,5],[69,0,69,5],[78,0,78,5],[79,0,79,5],[87,0,87,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["Justice & Prevention Division"]
[{"$f":"CONCATENATE(\"Budget Worksheets - \",'Budget Summary'!B44)","v":"Budget Worksheets - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you have enabled macros when prompted upon opening this document. The items marked as Example are only examples, and do not necessarily reflect items in your requested budget. Please note that the subtotals will auto-populate based on the numbers reported within each category. Your requested budget per cost category shall be entered in the rows below the Examples using the \"Add\" command button to add another row if needed. If you have any questions, please contact your grant manager."]
["Please distinguish whether the budgeted line items are Administrative or Programmatic by choosing from the list of values in Column F. Administrative costs are those expenses incurred by grant recipients or sub- recipients in support of the day-to-day operations of their organization. These overhead costs are the expenses that are not directly tied to a specific program purpose. Programmatic costs are costs that are tied directly to the delivery of a particular project, service, or activity undertaken by a Grantee to achieve an outcome intended by the funding program. Each line item will need to have either \"Admin\" or \"Program\" chosen in order for the budget to be accepted and reviewed. Per Chapter 126 of the Acts of 2022 – administrative costs cannot exceed 7.5% of the total allocation. This includes all of the line items marked as \"Admin\" as well as the portion of Indirect that may be associated with the \"Admin\" line items if the federally-approved indirect rate agreement or de minimis rate agreement allows for it. A calculator to help determine such is located at the bottom of the budget alongside the Indirect cost category."]
[]
["PERSONNEL: Full or part-time regular salaried employees working on the grant. Job descriptions and/or titles must be included in the description. Click the \"Add Personnel\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button. "]
[]
["Employee Name","Pay Rate","Quantity","Description ","Total Cash Expenditures","Admin or Program"]
["Example: Sue Smith",23.487500000000001,300,"Advocate worked a total of 300 hours during the QTR at $23.4875/hr. (300 hours cash)",{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":7046.25},"Ex. Admin"]
["Example: Tracey Thomas",1730.77,6,"$1730.77 per pay period x 6 pay periods",10384.620000000001,"Ex. Admin"]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B15=\"\",\"\",ROUND(ROUND(B15,4)*ROUND(C15,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Personnel,5,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["FRINGE AND PAYROLL TAX: Eligible costs include the employer share of the following: life insurance, health insurance, social security costs, pension costs, unemployment insurance costs, workers compensation insurance, payroll taxes, FMLA. Cost amounts for direct fringe benefits can be either actual costs or rates per employee calculated by the fiscal or human resource unit in your organization (rate computations must be included). A copy of the approved rate agreement should be included with the application response. This can be either a federally approved fringe rate or a breakout of what rates are being charged per eligible cost. Click the \"Add Fringe\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button. "]
[]
["Employee Name","Wages Applied to Fringe","Contract Fringe Rate","Description","Total Cash Expenditures","Admin or Program"]
["Example: Sue Smith",7046.25,0.21,"Take Sue Smith's wages reported on this worksheet under the \"Personnel\" section and multiply by the federally approved fringe rate or the fringe rate that was proposed and approved by OGR in the application process. ($7,046.25 * 21%)",{"$f":"IF(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,6),2))","v":1479.71},"Ex. Admin"]
["Example: Tracey Thomas ",10384.620000000001,0.1,"Take Tracey Thomas' wages reported on this worksheet under the \"Personnel\" section and multiply by the breakout of what rates are being charged per eligible cost. (7.5% - health insurance, 2% - life insurance, .5% - workers compensation)",{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,6),2))","v":1038.46},"Ex. Admin"]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["CONTRACTORS/CONSULTANTS: List each subcontractor and/or consultant along with their rate. The maximum rate for consultants is $650 for an eight-hour day or $81.25 per hour (excluding travel and subsistence costs).  Any request for compensation over $650 per day hour day or $81.25 per hour requires prior written approval by EOPSS. Requests for a waiver of this requirement, with documented justification, must be made in writing at the time of application. Click the \"Add C/C\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button."]
[]
["Contractors/Consultants Name","Pay Rate","Quantity","Description ","Total Cash Expenditures","Admin or Program"]
["Example: JJ Counseling",200,24,"Counseling of domestic violence survivors; $200 per day x 24 days",{"$f":"IF(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,4),2))","v":4800},"Ex. Program"]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,4),2))","v":9450},"Ex. Program"]
[null,null,null,null,{"$f":"IF(B34=\"\",\"\",ROUND(ROUND(B34,4)*ROUND(C34,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT: List the purchases of tangible non-expendable personal property having a useful life of more than one year. Equipment must be directly related to the program implementation. Please see the AGF for more specific Equipment guidelines. Click the \"Add Equipment\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button."]
[]
["Equipment","Cost","Quantity","Description","Total Cash Expenditures","Admin or Program"]
["Example: Laptop",1200,1,"Dell 1000 Laptop. Purchased (1) laptop at a rate of $1200.",{"$f":"IF(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,4),2))","v":1200},"Ex. Admin"]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. Purchased (3) keyboards at $50/each",{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,4),2))","v":150},"Ex. Admin"]
[null,null,null,null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Travel,-4,4))","v":0}]
[]
[]
["TRAVEL: This must be travel directly related to the purpose of the grant. In-state travel costs associated with the grant shall include mileage rates not in excess of $0.62 per mile, as well as the actual costs of tolls and parking. No grant funds may be spent for out of state conference fees, out of state travel or out of state lodging without prior written approval from OGR. Click the \"Add Travel\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button. "]
[]
["Employee Name","Rate","Quantity","Description","Total Cash Expenditures","Admin or Program"]
["Example: Sue Smith",17,1,"Parking for DV roundtable on 2/7/18",{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,4),2))","v":17},"Ex. Admin"]
["Example: Tracey Thomas",0.62,200,"Travel related to DV cases; $0.62/mile x 200 miles",{"$f":"IF(B53=\"\",\"\",ROUND(ROUND(B53,4)*ROUND(C53,4),2))","v":124},"Ex. Admin"]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES: List the purchases of supplies required for program (pens, pencils, postage, training materials, copying paper, and other expendable items such as books, ink, etc.). Click the \"Add Supplies\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button. "]
[]
["Supplies/Company","Cost","Quantity","Description","Total Cash Expenditures","Admin or Program"]
["Example: Copy Paper",50,4,"$50.00/box, 4 boxes",{"$f":"IF(B62=\"\",\"\",ROUND(ROUND(B62,4)*ROUND(C62,4),2))","v":200},"Ex. Admin"]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B63=\"\",\"\",ROUND(ROUND(B63,4)*ROUND(C63,4),2))","v":75},"Ex. Admin"]
[null,null,null,null,{"$f":"IF(B64=\"\",\"\",ROUND(ROUND(B64,4)*ROUND(C64,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Supplies,5,4):OFFSET(Other,-4,4))","v":0}]
[]
[]
["OTHER: List the purchases for other expenses not applicable in the aforementioned that were incurred due to this program implementation (e.g., telephone costs, training material costs). If \"Other Administration Costs\" are being budgeted, please choose \"Apply\" in Column F. Click the \"Add Other\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button. "]
[]
["Item/Company","Cost","Quantity","Description","Total Cash Expenditures","Admin or Program"]
["Example: Telephone",65,3,"Verizon: January-March at $65 per month",{"$f":"IF(B72=\"\",\"\",ROUND(ROUND(B72,4)*ROUND(C72,4),2))","v":195},"Ex. Admin"]
["Example: Heat",3200,0.25,"Total bill for office for quarter was $3,200.00; this program is 1/4 of office space",{"$f":"IF(B73=\"\",\"\",ROUND(ROUND(B73,4)*ROUND(C73,4),2))","v":800},"Ex. Admin"]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT: Applicants may charge indirect costs through the use of an indirect cost rate that has been federally-approved. Please include a copy of a current, signed federally-approved indirect cost rate agreement. Applicants that have never received a federally-approved indirect cost rate may elect to charge a de minimis rate of 10% of modified total direct costs which may be used indefinitely. These agreements will list the applicable costs also known as a base that can be applied to Indirect. There is a 7.5% maximum threshold in the total budget for Admin related expenses and the Indirect (if allowable per the federally-approve indirect rate agreement or de minimis rate agreement) that correlates to those expenses. In Column J (Administrative Indirect Expenses line item), the maximum 7.5% Admin threshold will be shown. This is calculated by taking the Grand Total and multiplying by 7.5%. All line items in the preceding cost categories must be identified as \"Admin\" or \"Program\". If these actions have been taken, Column H will populate the sum of all \"Admin\" and \"Program\" line items before taking Indirect into consideration. Column H represents the maximum expenses that may be applied for Indirect only if these expenses are considered as a base in the indirect rate agreement. Prior to entering values in Column B and Column C for Administrative Indirect Expenses, if these cells are filled in red, this indicates that the amount of identified \"Admin\" expenses already exceeds the maximum 7.5% threshold. For this to clear, adjustments will need to be made in the preceding cost categories. If the cells are not filled in red, proceed with entering values. The amount entered in Column B should not exceed the amount shown in Column H. The amount shown on Column I on the Administrative Indirect Expenses line should never exceed the amount shown in Column J. To make sure that total \"Admin\" related expenses do not exceed the 7.5%, adjustments may be needed. Examples may include decreasing the amount of \"Admin\" expenses in Column B or by applying a lower indirect rate in Column C. There is no threshold on \"Program\" related expenses, besides not being able to use a rate that is greater than the federally-approved rate or de minimis rate.  Just like \"Admin\", the maximum expenses that can be applied for \"Program\" is shown in Column H and is contingent on if the expenses are considered as a base in the indirect rate agreement. The federally-approved negotiated rate or the de minimis rate will be entered in Column C. Descriptions for what the Indirect reimbursements will cover must be provided."]
[]
["Indirect Expenses","Expenses Applied to Indirect","Contract Indirect Rate","Description","Total Cash Expenditures","Admin or Program"]
["Example: Administrative Indirect Expenses",7046.25,0.21,null,{"$f":"IF(B82=\"\",\"\",ROUND(ROUND(B82,4)*ROUND(C82,6),2))","v":1479.71},"Ex. Admin"]
["Example: Programmatic Indirect Expenses",10384.620000000001,0.1,null,{"$f":"IF(B83=\"\",\"\",ROUND(ROUND(B83,4)*ROUND(C83,6),2))","v":1038.46},"Ex. Program"]
[]
[null,null,null,null,null,null,null,"Expenses that may be applied to Indirect","Total Expenses (Includes Indirect)","7.5% Budget Admin Threshold"]
["Administrative Indirect Expenses",null,null,null,"","Indirect - Admin",null,{"$f":"(SUMIF(F:F, \"Admin\", E:E))","v":0},{"$f":"IFERROR(H86+E86,H86)","v":0},{"$f":"ROUND(E90*0.075,2)","v":0}]
["Programmatic Indirect Expenses",null,null,null,"","Indirect - Program",null,{"$f":"(SUMIF(F:F, \"Program\", E:E))","v":0},{"$f":"IFERROR(H87+E87,H87)","v":0}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E16+E26+E88+E36+E46+E56+E66+E76),2)","v":0}]