{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Opening Document","Budget Summary","Budget Detail"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":2,"defined_names":22,"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":"Opening Document","index":0,"n_rows":55,"n_cols":2,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[null,"UPON OPENING DOCUMENT…"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"IF THE RED BANNER OCCURS…."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1. DOWNLOAD DOCUMENT AND SAVE TO DESKTOP"]
[null,"2. RIGHT CLICK, PROPERTIES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. CHECK OFF UNBLOCK, CLICK APPLY, CLICK OK"]
[null,"4. REOPEN EXCEL WORKBOOK"]
[null,"5. IF NEEDED, ENABLE EDITING, ENABLE CONTENT"]

{"sheet":"Budget Summary","index":1,"n_rows":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,0,2,3],[18,0,18,3],[40,1,40,3],[20,2,20,3],[23,2,23,3],[25,2,25,3],[27,2,27,3],[29,2,29,3],[31,2,31,3],[35,2,35,3],[37,2,37,3],[33,2,33,3]]}
[]
["Attachment A - Budget Worksheets"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FY2025 Emerging Adults Reentry Initiative                                    Technical Assistance Provider"]
[]
["Cost Categories",null,"Total"]
[]
[]
["Personnel Costs",null,{"$f":"'Budget Detail'!E15","v":0}]
[]
["Fringe Costs",null,{"$f":"'Budget Detail'!E25","v":0}]
[]
["Consultants/Contractors Costs",null,{"$f":"'Budget Detail'!E35","v":0}]
[]
["Travel Costs",null,{"$f":"'Budget Detail'!E45","v":0}]
[]
["Supplies Costs",null,{"$f":"'Budget Detail'!E55","v":0}]
[]
["Indirect Costs",null,{"$f":"'Budget Detail'!E65","v":0}]
[]
["Administrative Costs",null,{"$f":"'Budget Detail'!E75","v":0}]
[]
["Total Costs",null,{"$f":"'Budget Detail'!E77","v":0}]
[]
[]
["Name of Applicant Organization "]

{"sheet":"Budget Detail","index":2,"n_rows":77,"n_cols":8,"rows_kept":77,"cut":false,"hidden":false,"merged":[[77,0,77,4],[54,0,54,3],[44,0,44,3],[74,0,74,3],[76,0,76,3],[47,0,47,4],[48,0,48,4],[67,0,67,4],[68,0,68,4],[57,0,57,4],[58,0,58,4],[64,0,64,3],[14,0,14,3],[8,0,8,4],[7,0,7,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[6,0,6,4],[38,0,38,4],[24,0,24,3],[34,0,34,3],[17,0,17,4],[18,0,18,4],[27,0,27,4],[28,0,28,4],[37,0,37,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["Justice & Prevention Division"]
[{"$f":"CONCATENATE(\"Budget Worksheets - \",'Budget Summary'!B41)","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."]
["The following cost categories are considered to be direct expenses and are categories that may be applicable to your indirect rate agreement: Personnel, Fringe, Contractors/Consultants, Travel, and Supplies. Please complete these cost categories prior to completing the Indirect section, as these \"direct\" cost categories may determine what is eligible to be applied against your indirect rate agreement. The combination of these \"direct\" cost categories and Indirect will then determine how much administrative costs are eligible under this request. Per Chapter 126 of the Acts of 2024, administrative costs are not to exceed 7.5% of the total award. "]
["PERSONNEL: Full or part-time regular salaried employees working on the grant. Job descriptions and/or titles must be included in the description. "]
[]
["Employee Name","Pay Rate","Quantity","Description ","Total Cash Expenditures"]
["Example: Sue Smith",23.487500000000001,300,"Please describe duties of Employee here.",{"$f":"IF(B11=\"\",\"\",ROUND(ROUND(B11,4)*ROUND(C11,4),2))","v":7046.25}]
["Example: Tracey Thomas",1730.77,6,"$1730.77 per pay period x 6 pay periods",10384.620000000001]
[null,null,null,null,""]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,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. "]
[]
["Employee Name","Wages Applied to Fringe","Contract Fringe Rate","Description","Total Cash Expenditures"]
["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(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,6),2))","v":1479.71}]
["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(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,6),2))","v":1038.46}]
[null,null,null,null,{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(B24=\"\",\"\",ROUND(ROUND(B24,4)*ROUND(C24,8),2))","v":""}]
["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. "]
[]
["Contractors/Consultants Name","Pay Rate","Quantity","Description ","Total Cash Expenditures"]
["Example: JJ Counseling",200,24,"Please provide the names of each Contractor and Consultant as well as duties/obligations that will be performed here. ",{"$f":"IF(B31=\"\",\"\",ROUND(ROUND(B31,4)*ROUND(C31,4),2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,{"$f":"IF(B34=\"\",\"\",ROUND(ROUND(B34,4)*ROUND(C34,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,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."]
[]
["Employee Name","Rate","Quantity","Description","Total Cash Expenditures"]
["Example: Sue Smith",0.62,125,"Travel related to grant; $.62/mile x 125 miles",{"$f":"IF(B41=\"\",\"\",ROUND(ROUND(B41,4)*ROUND(C41,4),2))","v":77.5}]
["Example: Tracey Thomas",0.62,200,"Travel related to DV cases; $0.62/mile x 200 miles",{"$f":"IF(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,4),2))","v":124}]
[null,null,null,null,{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,4),2))","v":""}]
[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.)."]
[]
["Supplies/Company","Cost","Quantity","Description","Total Cash Expenditures"]
["Example: Copy Paper",50,4,"Please describe purpose of Supplies here. ",{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,4),2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,4),2))","v":75}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Supplies,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 15% of modified total direct costs. These agreements will list the applicable costs also known as a base that can be applied to Indirect. "]
[]
["Indirect Expenses","Expenses Applied to Indirect","Contract Indirect Rate","Description","Total Cash Expenditures"]
["Example: Indirect Expenses",7046.25,0.21,"Please describe a breakdown of all costs to be covered with Indirect recoupment.",{"$f":"IF(B61=\"\",\"\",ROUND(ROUND(B61,4)*ROUND(C61,6),2))","v":1479.71}]
["Example: Programmatic Indirect Expenses",10384.620000000001,0.1,null,{"$f":"IF(B62=\"\",\"\",ROUND(ROUND(B62,4)*ROUND(C62,6),2))","v":1038.46}]
[null,null,null,null,{"$f":"IF(B63=\"\",\"\",ROUND(ROUND(B63,4)*ROUND(C63,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(B64=\"\",\"\",ROUND(ROUND(B64,4)*ROUND(C64,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(Other,-4,4))","v":0}]
[]
[]
["ADMINISTRATIVE:  Normally recouped through the use of an indirect rate agreement, Facilities and Administrative (F&A) costs are typically costs of an organization that are not readily assignable to a particular project, but necessary to the operation of the entire organization. As referenced in https://www.ecfr.gov/current/title-2/subtitle-A/chapter-II/part-200/appendix-Appendix%20IV%20to%20Part%20200 these costs include facility and building maintenance/expenses, telephone and utility expenses, depreciation and interest expenses, general supplies not specific to the project at task, rental and lease costs for property, and/or administrative salaries and associated benefits for administrative employees whose work benefits the entire organization such as but not limited to CEOs, CFOs, CIOs, Treasurers, Secretaries, or Directors. These costs should not be included as the base to be applied against an indirect rate in the cost category above. If this cost category exceeds the Maximum Administrative Costs in Column H, the subtotal cell will become red, and will require you to make adjustments to meet this threshold."]
[null,null,null,null,null,null,"Direct Costs + Indirect:",{"$f":"E15+E25+E35+E45+E55+E65","v":0}]
["Item/Activity","Cost","Quantity","Description","Total Cash Expenditures",null,"Maximum Adminstrative Costs:",{"$f":"ROUND(SUM((H69/0.925)-H69),2)","v":0}]
["Example: Janitorial Services",65,12,"Please describe purpose of item/activity here.",{"$f":"IF(B71=\"\",\"\",ROUND(ROUND(B71,4)*ROUND(C71,4),2))","v":780}]
[]
[null,null,null,null,{"$f":"IF(B73=\"\",\"\",ROUND(ROUND(B73,4)*ROUND(C73,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(B74=\"\",\"\",ROUND(ROUND(B74,4)*ROUND(C74,4),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E15+E25+E35+E45+E55+E65+E75),2)","v":0}]