{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Opening Document","Budget Summary","Budget Detail","Budget Guidelines"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":2,"defined_names":131,"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":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,0,2,2],[18,0,18,2],[42,1,42,2]]}
[]
["Attachment A - Budget Worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Commonwealth Project Safe Neighborhood Initiative"]
[]
["Cost Categories",null,"Cash Expenditures"]
[]
[]
["Personnel Costs",null,{"$f":"'Budget Detail'!E17","v":0}]
[]
["Overtime Costs",null,{"$f":"'Budget Detail'!E27","v":0}]
[]
["Fringe Benefit Costs",null,{"$f":"'Budget Detail'!E37","v":0}]
[]
["Subawards / Contractors Costs",null,{"$f":"'Budget Detail'!E47","v":0}]
[]
["Travel Costs",null,{"$f":"'Budget Detail'!E57","v":0}]
[]
["Equipment Costs",null,{"$f":"'Budget Detail'!E67","v":0}]
[]
["Supplies Costs",null,{"$f":"'Budget Detail'!E77","v":0}]
[]
["Other Costs",null,{"$f":"'Budget Detail'!E87","v":0}]
[]
["Total Costs",null,{"$f":"C24+C26+C28+C30+C34+C32+C36+C38","v":0}]
[]
[]
["Name of Applicant Organization "]

{"sheet":"Budget Detail","index":2,"n_rows":89,"n_cols":5,"rows_kept":89,"cut":false,"hidden":false,"merged":[[7,0,7,4],[49,0,49,4],[16,0,16,3],[8,0,8,4],[26,0,26,3],[36,0,36,3],[20,0,20,4],[29,0,29,4],[30,0,30,4],[46,0,46,3],[39,0,39,4],[40,0,40,4],[9,0,9,4],[10,0,10,4],[19,0,19,4],[89,0,89,4],[76,0,76,3],[56,0,56,3],[86,0,86,3],[88,0,88,3],[79,0,79,4],[80,0,80,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],[50,0,50,4],[59,0,59,4],[60,0,60,4],[69,0,69,4],[70,0,70,4],[66,0,66,3]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["Commonwealth Project Safe Neighborhood Initiative"]
[{"$f":"CONCATENATE(\"Attachment A - \", 'Budget Summary'!B43)","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 District Attorney’s Office and the Massachusetts State Police are eligible to apply. A District Attorney’s Office may solicit up to $100,000 in funding for this initiative, with a total of $1,100,000 available for all eleven (11) District Attorney Offices. The MSP may submit separate proposals covering different areas of the Commonwealth that they determine to have greatest need, with a total of $800,000 available to MSP. These funds must be prioritized to address the uptick in community violence and drug activity in our neighborhoods. Applicants may utilize funding over a 6-month period from January-June 30, 2024. Since these are state funds, all funds must be expended prior to June 30, 2024."]
[]
["PERSONNEL"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: Sue Smith",23.487500000000001,300,"Employee is projected to work a total of 300 hours during the grant at $23.4875/hr.",{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":7046.25}]
["Example: Tracey Thomas",1730.77,6,"Please describe duties of Employee here. ",{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,4),2))","v":10384.620000000001}]
[null,null,null,null,{"$f":"IF(B15=\"\",\"\",ROUND(ROUND(B15,4)*ROUND(C15,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Personnel,5,4):OFFSET(Overtime,-4,4))","v":0}]
[]
[]
["OVERTIME"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: Sue Smith",40,104,"Advocate worked a total of 104 hours for follow-up investigation of DV cases during the quarter at $40.00/hour. Reporting $2,500 match for S. Smith.",{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":4160}]
["Example: Tracey Thomas",32,52,"Please describe duties of Employee here. ",{"$f":"IF(B24=\"\",\"\",ROUND(ROUND(B24,4)*ROUND(C24,4),2))","v":1664}]
[null,null,null,null,{"$f":"IF(B25=\"\",\"\",ROUND(ROUND(B25,4)*ROUND(C25,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Overtime,5,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["FRINGE AND PAYROLL TAX"]
[]
["Employee Name","Wages Applied to Fringe","Contract Fringe Rate","Description","Cash Expenditures"]
["Example: Sue Smith",7046.25,0.21,"Per the fringe rate agreement, find the applicable cost categories to apply fringe to. In this example, the applicable cost category is \"Personnel.\" Take Sue Smith's total 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%). Match expenditures should be in relation to the match in the applicable category. ",{"$f":"IF(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,6),2))","v":1479.71}]
["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(B34=\"\",\"\",ROUND(ROUND(B34,4)*ROUND(C34,6),2))","v":1038.46}]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["SUBAWARDS (SUBGRANTS), PROCUREMENT CONTRACTS, & CONSULTANT FEES"]
[]
["Choose Category from List of Values Dropdown Below","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: JJ Counseling",200,24,"Counseling of domestic violence survivors; $200 per day x 24 days. Submitting reimbursement for $2,800.",{"$f":"IF(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,4),2))","v":4800}]
["Example: Subawards",45,210,"Please provide the names of each Subaward, Contractor and Consultant as well as duties/obligations that will be performed here.",{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,4),2))","v":9450}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Travel,-4,4))","v":0}]
[]
[]
["TRAVEL"]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures"]
["Example: Sue Smith",250,1,"Gas reimbursement related to grant. ",{"$f":"IF(B53=\"\",\"\",ROUND(ROUND(B53,4)*ROUND(C53,4),2))","v":250}]
["Example: Tracey Thomas",0.62,500,"Travel related to grant; $0.62/mile x 500 miles",{"$f":"IF(B54=\"\",\"\",ROUND(ROUND(B54,4)*ROUND(C54,4),2))","v":310}]
[null,null,null,null,{"$f":"IF(B55=\"\",\"\",ROUND(ROUND(B55,4)*ROUND(C55,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Equipment,-4,4))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures"]
["Example: Laptop",1200,1,"Please describe purpose of Equipment here. ",{"$f":"IF(B63=\"\",\"\",ROUND(ROUND(B63,4)*ROUND(C63,4),2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B64=\"\",\"\",ROUND(ROUND(B64,4)*ROUND(C64,4),2))","v":150}]
[null,null,null,null,{"$f":"IF(B65=\"\",\"\",ROUND(ROUND(B65,4)*ROUND(C65,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES"]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Copy Paper",50,4,"Please describe purpose of Supplies here. ",{"$f":"IF(B73=\"\",\"\",ROUND(ROUND(B73,4)*ROUND(C73,4),2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B74=\"\",\"\",ROUND(ROUND(B74,4)*ROUND(C74,4),2))","v":75}]
[null,null,null,null,{"$f":"IF(B75=\"\",\"\",ROUND(ROUND(B75,4)*ROUND(C75,4),2))","v":""}]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Supplies,5,4):OFFSET(Other,-4,4))","v":0}]
[]
[]
["OTHER"]
[]
["Item/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Telephone",65,6,"Please describe purpose of item/activity here. ",{"$f":"IF(B83=\"\",\"\",ROUND(ROUND(B83,4)*ROUND(C83,4),2))","v":390}]
["Example: Heat",6000,0.25,"Projected total bill for office during grant period is $6,000.00; this program is 1/4 of office space",{"$f":"IF(B84=\"\",\"\",ROUND(ROUND(B84,4)*ROUND(C84,4),2))","v":1500}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0}]
[]
["Grand Total:",null,null,null,{"$f":"ROUND(SUM(E17+E27+E37+E47+E57+E67+E77+E87),2)","v":0}]

{"sheet":"Budget Guidelines","index":3,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":false,"merged":[[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[28,0,28,1],[31,0,31,1],[32,0,32,1],[34,0,34,1],[35,0,35,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[11,0,12,0],[20,0,20,1],[19,0,19,1],[3,0,10,0],[21,0,21,1]]}
["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 below."]
["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."]
["Contracts and Subawards and Consultants","Contracts and Subawards:  Provide a description of the product/services to be procured by contract and an estimate of the cost.  Applicants must follow their organization's own procurement policy."]
[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."]
["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. Note that no grant funds may be spent for out-of-state conference fees, out-of-state travel, or out-of-state lodging."]
["Equipment/Technology ","Tangible, non-expendable personal property having a useful life of more than one year; cost based on classification of equipment."]
["Supplies","Supplies directly correlated to the program."]
["Other ","List items that don’t fit within the above cost categories and the basis of the computation."]
[]
[]
["Allowable Costs"]
["All applicants and their selected partners must be able to implement their program immediately upon execution of this award, which is anticipated before January 1, 2024. "]
["The following are examples of the types of allowable uses of funds under this application process:"]
[]
["·         Personnel, fringe and, indirect costs;"]
["·         Overtime for suppression/investigation/enforcement efforts;"]
["·         Subawards to local police departments and/or nonprofits;"]
["·         Consultants to provide services or training to address key priority areas;"]
["·         Small equipment items such as protective gear for officers in the field, surveillance cameras, etc.; and"]
["·         Materials needed for evidence-based youth prevention or diversion programming."]
[]
[]
["Unallowable Costs"]
["For this AGF, funds may NOT be used for any of the following:"]
[]
["·         Standard firearms or ammunition;"]
["·         Construction, office furniture, or other like purchases;"]
["·         Vehicles, vessels, or aircraft including unmanned aerial vehicle/unmanned aircraft, aircraft system, or aerial vehicles (UA/UAS/UAV); "]
["·         Gift cards, tee-shirts, and trinkets;"]
["·         Food and beverages; and"]
["·         Extended warranty above and beyond the cost of the item and extending after the contract end date."]