{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Opening Document","Budget Guidelines","Budget Summary","Budget Detail","Object Classes"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":3,"defined_names":147,"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":49,"n_cols":2,"rows_kept":49,"cut":false,"hidden":false,"merged":[[10,0,10,8]]}
[]
[null,"UPON OPENING DOCUMENT…"]
[]
[]
[]
[]
[]
[]
[]
[]
["Click on Enable Editing/Enable Content"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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 Guidelines","index":1,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[13,0,14,0],[1,1,2,1],[1,0,2,0],[4,0,11,0]]}
["Allowable Budget Cost Categories","Definitions and Documentation Requirements"]
["Personnel","Costs associated with agency personnel. List position, percentage of time charged to grant, and annual salary. Include a brief description of each staff member’s duties/activities to be supported by grant funding."]
[]
["Overtime","Overtime is limited to sworn law enforcement personnel only. Indicate overtime rate for each officer charged to the grant and the number of overtime hours. Refer to OGR Overtime Policy in the AGF. "]
["Fringe Benefits","Eligible costs include the employer share of the following:"]
[null,"·         Life insurance"]
[null,"·         Health insurance"]
[null,"·         Social security costs"]
[null,"·         Pension costs"]
[null,"·         Unemployment insurance costs"]
[null,"·         Workers compensation insurance"]
[null,"Direct fringe benefits can be either actual costs or rate per employee calculated by the fiscal or human resource unit in your organization. Actual known costs must be itemized by type and include rate computation. Include a copy of approved rate agreement in the application response. State Agencies use BFY2025 approved fringe rate agreement for your department."]
["Indirect Costs","A federally approved Indirect Cost Rate Agreement is required (if not using the de minimus 15% indirect cost rate) Refer to your Indirect Cost Rate Agreement for applicable expenses to be used as your base.  State Agencies use BFY2025 approved indirect rate agreement for your department."]
["Contractors/Consultants","Contractors: A contractor is when an entity is hired to provide specific goods or services to support the project, without substantial involvement in the project’s overall goals."]
[null,"Consultants: The maximum rate for consultants is $650 for an eight- hour day or $81.25 per hour. Any request for compensation over $650 per day requires prior written approval by OGR. Waiver of this maximum rate is at the discretion of OGR."]
["Subawards","A subaward is when an organization receives funds to carry out a significant portion of a larger project’s goals, essentially acting as a partner in the project. Under a subaward, the award recipient transfers its responsibility to perform part of the project to another entity. "]
["Travel","Travel directly related to the purpose of the grant. In-state travel costs associated with the grant shall include mileage rates not to exceed $.62 per mile, as well as the actual costs of tolls and parking.  Out-of-state travel, or out-of-state lodging must be budgeted according to the current federal per diem rates which can be found here: https://www.gsa.gov/travel/plan-book/per-diem-rates."]
["Equipment/Technology","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; inclusive of any accessory items essential to the equipment’s’ operation. Rented or leased equipment costs should be listed under “contractors”."]
["Supplies","Supplies directly correlated to the program. Supplies include any materials that are expendable or consumed during the course of the project."]
["Other","List items (e.g., rent, telephone, use of space, etc.) and provide computation. For example, provide the square footage and the cost per square foot for rent, or provide a monthly rental cost and how many months to rent."]

{"sheet":"Budget Summary","index":2,"n_rows":47,"n_cols":3,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,0,2,2],[18,0,18,2],[46,1,46,2]]}
[]
["Attachment A - Budget Worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Edward J. Byrne Memorial Justice Assistance Grant"]
[]
["Cost Categories",null,"Cash Expenditures"]
[]
[]
["Personnel Costs",null,{"$f":"'Budget Detail'!E16","v":0}]
[]
["Overtime Costs",null,{"$f":"'Budget Detail'!E25","v":0}]
[]
["Fringe Benefit Costs",null,{"$f":"'Budget Detail'!E34","v":0}]
[]
["Indirect Costs",null,{"$f":"'Budget Detail'!E43","v":0}]
[]
["Contractors / Consultants Costs",null,{"$f":"'Budget Detail'!E52","v":0}]
[]
["Subawards Costs",null,{"$f":"'Budget Detail'!E61","v":0}]
[]
["Travel Costs",null,{"$f":"'Budget Detail'!E70","v":0}]
[]
["Equipment Costs",null,{"$f":"'Budget Detail'!E79","v":0}]
[]
["Supplies Costs",null,{"$f":"'Budget Detail'!E88","v":0}]
[]
["Other Costs",null,{"$f":"'Budget Detail'!E97","v":0}]
[]
["Total Costs",null,{"$f":"'Budget Detail'!E99","v":0}]
[]
[]
["Name of Police Department"]

{"sheet":"Budget Detail","index":3,"n_rows":99,"n_cols":6,"rows_kept":99,"cut":false,"hidden":false,"merged":[[24,0,24,3],[33,0,33,3],[10,0,10,4],[18,0,18,4],[99,0,99,4],[87,0,87,3],[69,0,69,3],[96,0,96,3],[98,0,98,3],[19,0,19,4],[27,0,27,4],[28,0,28,4],[51,0,51,3],[42,0,42,3],[36,0,36,4],[37,0,37,4],[45,0,45,4],[46,0,46,4],[6,0,6,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[8,0,8,4],[15,0,15,3],[7,0,7,4],[90,0,90,4],[91,0,91,4],[64,0,64,4],[72,0,72,4],[73,0,73,4],[81,0,81,4],[82,0,82,4],[78,0,78,3],[54,0,54,4],[55,0,55,4],[60,0,60,3],[63,0,63,4],[9,0,9,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["Edward J. Byrne Memorial Justice Assistance Grant"]
[{"$f":"CONCATENATE(\"Attachment A - \", 'Budget Summary'!B47)","v":"Attachment A - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you read the instructions on the Opening Document tab upon opening this document to make sure that macros are enabled macros. 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 the BJAG grant manager assigned in the Availability of Grant Funds (AGF) document."]
["Please read the Availability of Grant Funds (AGF) document. This will outline key dates, funding criteria, allowable and unallowable costs. Cost category definitions are highlighted in the Budget Guidelines tab. Only a Massachusetts state agency with a law enforcement nexus may apply for a maximum award amount of $60,000. Such agencies include, but are not limited to, those that are under the umbrella of the Executive Office of Public Safety and Security (EOPSS), Sheriff’s, District Attorney’s and Campus Police for a State College/University. A state agency must be the primary applicant, however, the applicant may subaward grant funds to community partners to support the project. Only one (1) application per state agency is permitted for submission. OGR reserves the right to disqualify an agency from being eligible for an award that submits more than one application for consideration of funding. Applicants may submit a budget for up to 12 months."]
["Since awards will be disbursed via Interdepartmental Service Agreement (ISA), please indicate what object class will be used for each line item using Column F. Every line item that does not have this action completed will result in a red Column F cell. This will help determine how the ISA Attachment B will be set up as well as how the award will be allocated in MMARS. The totals displayed per object class under the Object Classes tab should reflect how the totals will be displayed on the ISA Attachment B."]
[]
["PERSONNEL"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures","Object Class"]
["Example: Tracey Thomas",1730.77,6,"Please describe duties of Employee here. ",{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,6)*ROUND(C13,8),2))","v":10384.620000000001},"\"AA\""]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,6)*ROUND(C14,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(B15=\"\",\"\",ROUND(ROUND(B15,6)*ROUND(C15,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Personnel,4,4):OFFSET(Overtime,-4,4))","v":0}]
[]
[]
["OVERTIME"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures","Object Class"]
["Example: Tracey Thomas",32,52,"Please describe duties of Employee here. ",{"$f":"IF(B22=\"\",\"\",ROUND(ROUND(B22,6)*ROUND(C22,8),2))","v":1664},"\"AA\""]
[null,null,null,null,{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,6)*ROUND(C23,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(B24=\"\",\"\",ROUND(ROUND(B24,6)*ROUND(C24,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Overtime,4,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["FRINGE AND PAYROLL TAX"]
[]
["Employee Name","Wages Applied to Fringe","Contract Fringe Rate","Description","Cash Expenditures","Object Class"]
["Example: Tracey Thomas ",10384.620000000001,0.1,"Per the fringe rate agreement, find the applicable cost categories to apply fringe to. In this example, the applicable cost category is \"Personnel.\" Take Tracey Thomas' total 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(B31=\"\",\"\",ROUND(ROUND(B31,6)*ROUND(C31,8),2))","v":1038.46},"\"DD\""]
[null,null,null,null,{"$f":"IF(B32=\"\",\"\",ROUND(ROUND(B32,6)*ROUND(C32,8),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,4,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT COSTS"]
[]
["Employee Name","Expenses Applied to Indirect Rate","Contract Indirect Rate","Description","Cash Expenditures","Object Class"]
["Example: Tracey Thomas",11423.08,0.18,"The federally approved rate of \"18%\" times allowable expenses per contract. If allowable expenses are all categories, take the sum of all categories and multiply by the federally approved rate. If allowable expenses are only Personnel and Fringe like in this example, take the approved rate and multiply by the sum of Personnel and Fringe total costs associated with Tracey Thomas.      (18% * (10,384.62 + 1,038.46)). ",{"$f":"IF(B40=\"\",\"\",ROUND(ROUND(B40,6)*ROUND(C40,8),2))","v":2056.15},"\"EE\""]
[null,null,null,null,{"$f":"IF(B41=\"\",\"\",ROUND(ROUND(B41,6)*ROUND(C41,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(B42=\"\",\"\",ROUND(ROUND(B42,6)*ROUND(C42,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,4,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["CONTRACTORS/CONSULTANTS"]
[]
["Company Name/Activity","Pay Rate","Quantity","Description ","Cash Expenditures","Object Class"]
["Example: JJ Contracting",45,210,"Please provide the names of each Contractor and Consultant as well as duties/obligations that will be performed here.",{"$f":"IF(B49=\"\",\"\",ROUND(ROUND(B49,6)*ROUND(C49,8),2))","v":9450},"\"JJ\""]
[null,null,null,null,{"$f":"IF(B50=\"\",\"\",ROUND(ROUND(B50,6)*ROUND(C50,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,6)*ROUND(C51,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,4,4):OFFSET(Subawards,-4,4))","v":0}]
[]
[]
["SUBAWARDS (SUBGRANTS)"]
[]
["Subaward Name/Activity","Pay Rate","Quantity","Description ","Cash Expenditures","Object Class"]
["Example: JJ Subawards",15000,1,"Please provide the names of each Subaward as well as duties/obligations that will be performed here.",{"$f":"IF(B58=\"\",\"\",ROUND(ROUND(B58,6)*ROUND(C58,8),2))","v":15000},"\"PP\""]
[null,null,null,null,{"$f":"IF(B59=\"\",\"\",ROUND(ROUND(B59,6)*ROUND(C59,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(B60=\"\",\"\",ROUND(ROUND(B60,6)*ROUND(C60,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Subawards,4,4):OFFSET(Travel,-4,4))","v":0}]
[]
[]
["TRAVEL"]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures","Object Class"]
["Example: Tracey Thomas",0.62,500,"Travel related to grant; $0.62/mile x 500 miles",{"$f":"IF(B67=\"\",\"\",ROUND(ROUND(B67,6)*ROUND(C67,8),2))","v":310},"\"BB\""]
[null,null,null,null,{"$f":"IF(B68=\"\",\"\",ROUND(ROUND(B68,6)*ROUND(C68,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(B69=\"\",\"\",ROUND(ROUND(B69,6)*ROUND(C69,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,4,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures","Object Class"]
["Example: Laptop",1200,1,"Please describe purpose of Equipment here. ",{"$f":"IF(B76=\"\",\"\",ROUND(ROUND(B76,6)*ROUND(C76,8),2))","v":1200},"\"UU\""]
[null,null,null,null,{"$f":"IF(B77=\"\",\"\",ROUND(ROUND(B77,6)*ROUND(C77,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(B78=\"\",\"\",ROUND(ROUND(B78,6)*ROUND(C78,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,4,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES"]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures","Object Class"]
["Example: Copy Paper",50,4,"Please describe purpose of Supplies here. ",{"$f":"IF(B85=\"\",\"\",ROUND(ROUND(B85,6)*ROUND(C85,8),2))","v":200},"\"FF\""]
[null,null,null,null,{"$f":"IF(B86=\"\",\"\",ROUND(ROUND(B86,6)*ROUND(C86,8),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Supplies,4,4):OFFSET(Other,-4,4))","v":0}]
[]
[]
["OTHER"]
[]
["Item/Company","Cost","Quantity","Description","Cash Expenditures","Object Class"]
["Example: Telephone",65,6,"Please describe purpose of item/activity here. ",{"$f":"IF(B94=\"\",\"\",ROUND(ROUND(B94,6)*ROUND(C94,8),2))","v":390},"\"EE\""]
[null,null,null,null,{"$f":"IF(B95=\"\",\"\",ROUND(ROUND(B95,6)*ROUND(C95,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(B96=\"\",\"\",ROUND(ROUND(B96,6)*ROUND(C96,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,4,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E16+E25+E34+E43+E52+E61+E70+E79+E88+E97),2)","v":0}]

{"sheet":"Object Classes","index":4,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Object Classes","Description","Budgeted Totals"]
["AA","State Employee Compensation",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A2,'Budget Detail'!E:E)","v":0}]
["BB","State Employee - Related Expenses",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A3,'Budget Detail'!E:E)","v":0}]
["CC","Special Employees / Contracted Services",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A4,'Budget Detail'!E:E)","v":0}]
["DD","Pension and Insurance - Related Expenditures",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A5,'Budget Detail'!E:E)","v":0}]
["EE","Administrative Expenses",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A6,'Budget Detail'!E:E)","v":0}]
["FF","Programmatic Facility Operational Supplies and Related Expenses",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A7,'Budget Detail'!E:E)","v":0}]
["GG","Energy Costs, Utilities, and Space Rental Expenses",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A8,'Budget Detail'!E:E)","v":0}]
["HH","Consultant Service Contracts",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A9,'Budget Detail'!E:E)","v":0}]
["JJ","Programmatic Operational Services",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A10,'Budget Detail'!E:E)","v":0}]
["KK","Programmatic Equipment Purchase",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A11,'Budget Detail'!E:E)","v":0}]
["LL","Programmatic Equipment Tax Exempt Lease - Purchase (TELP), Lease and Rental, Maintenance and Repair",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A12,'Budget Detail'!E:E)","v":0}]
["MM","Purchased Client Human and Social Services and Non-Human Services Programs",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A13,'Budget Detail'!E:E)","v":0}]
["NN","Horizontal and Vertical Construction, Improvements, Maintenance and Repair Costs, and Land Acquisition",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A14,'Budget Detail'!E:E)","v":0}]
["PP","Grants and Subsidies",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A15,'Budget Detail'!E:E)","v":0}]
["RR","Entitlement Programs",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A16,'Budget Detail'!E:E)","v":0}]
["SS","Debt Payment",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A17,'Budget Detail'!E:E)","v":0}]
["TT","Loans and Special Payments",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A18,'Budget Detail'!E:E)","v":0}]
["UU","Information Technology Expenses",{"$f":"SUMIF('Budget Detail'!F:F,'Object Classes'!A19,'Budget Detail'!E:E)","v":0}]
[null,null,{"$f":"SUM(C2:C19)","v":0}]