{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Opening Document","Budget Summary","Budget Detail","Cost Categories"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":2,"defined_names":32,"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. MAKE SURE THERE IS A CHECK IN THE UNBLOCK BOX, CLICK APPLY, CLICK OK"]
[null,"4. REOPEN EXCEL WORKBOOK"]
[null,"5. IF NEEDED, ENABLE EDITING, ENABLE CONTENT"]

{"sheet":"Budget Summary","index":1,"n_rows":44,"n_cols":4,"rows_kept":44,"cut":false,"hidden":false,"merged":[[18,0,18,3],[43,1,43,3],[1,0,1,3],[2,0,2,3]]}
[]
["Attachment A - Budget Worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FY 2024 Senator Charles E. Shannon Jr.                                                                        Community Safety Initiative"]
[]
["Cost Categories","State Costs","Match Costs","Total Costs"]
[]
[]
["Personnel Costs",{"$f":"'Budget Detail'!E16","v":0},{"$f":"'Budget Detail'!F16","v":0},{"$f":"'Budget Detail'!G16","v":0}]
[]
["Overtime Costs",{"$f":"'Budget Detail'!E26","v":0},{"$f":"'Budget Detail'!F26","v":0},{"$f":"'Budget Detail'!G26","v":0}]
[]
["Fringe Benefit Costs",{"$f":"'Budget Detail'!E36","v":0},{"$f":"'Budget Detail'!F36","v":0},{"$f":"'Budget Detail'!G36","v":0}]
[]
["Contracts Costs",{"$f":"'Budget Detail'!E46","v":0},{"$f":"'Budget Detail'!F46","v":0},{"$f":"'Budget Detail'!G46","v":0}]
[]
["Travel Costs",{"$f":"'Budget Detail'!E56","v":0},{"$f":"'Budget Detail'!F56","v":0},{"$f":"'Budget Detail'!G56","v":0}]
[]
["Equipment Costs",{"$f":"'Budget Detail'!E66","v":0},{"$f":"'Budget Detail'!F66","v":0},{"$f":"'Budget Detail'!G66","v":0}]
[]
["Supplies Costs",{"$f":"'Budget Detail'!E76","v":0},{"$f":"'Budget Detail'!F76","v":0},{"$f":"'Budget Detail'!G76","v":0}]
[]
["Other Costs",{"$f":"'Budget Detail'!E86","v":0},{"$f":"'Budget Detail'!F86","v":0},{"$f":"'Budget Detail'!G86","v":0}]
[]
["Total Costs",{"$f":"B24+B26+B28+B30+B32+B34+B36+B38","v":0},{"$f":"C24+C26+C28+C30+C32+C34+C36+C38","v":0},{"$f":"D24+D26+D28+D30+D32+D34+D36+D38","v":0}]
[]
["Match Requirement",{"$f":"ROUND(B40/3,2)","v":0}]
[]
["Name of Applicant Organization "]

{"sheet":"Budget Detail","index":2,"n_rows":88,"n_cols":7,"rows_kept":88,"cut":false,"hidden":false,"merged":[[49,0,49,6],[38,0,38,6],[39,0,39,6],[48,0,48,6],[45,0,45,3],[28,0,28,6],[29,0,29,6],[35,0,35,3],[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[15,0,15,3],[7,0,7,4],[8,0,8,6],[9,0,9,6],[5,0,5,6],[18,0,18,6],[19,0,19,6],[25,0,25,3],[6,0,6,6],[88,0,88,6],[75,0,75,3],[55,0,55,3],[85,0,85,3],[87,0,87,3],[68,0,68,6],[69,0,69,6],[78,0,78,6],[79,0,79,6],[65,0,65,3],[58,0,58,6],[59,0,59,6]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FY 2024 Senator Charles E. Shannon Jr. Community Safety Initiative"]
[{"$f":"CONCATENATE(\"Attachment A - \", 'Budget Summary'!B44)","v":"Attachment A - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you have enabled macros when prompted upon opening this document. Please review the \"Opening Document\" tab for instructions on how to enable macros. In addition, please take the time to review the AGF to understand allowable and unallowable costs. 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 emily.fontaine@mass.gov."]
["Authorizing legislation mandates that preference be given to applicants submitting a match commitment of 25%. The 25% matching funds may be in the form of municipal or private contributions. The Match amount must be entered into the Match Expenditures column (Column F) in order for the requested amount to be calculated from the Total Expenditures. To determine the 25% match, divide the state funding request by three (3). The resulting figure will equal 25% of the total project cost. Example: If requesting $300,000 in state funds to support the project, the applicant must provide an additional $100,000 in matching funds. ($300,000 / 3 = $100,000). State funds total $300,000 (75%), Match funds total $100,000 (25%), and the Total Project Costs total $400,000 (100%)."]
[]
["PERSONNEL"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Sue Smith",23.487500000000001,300,"Describe activities of employee here.",{"$f":"IF(G12=\"\",\"\",G12-F12)","v":7046.25},0,{"$f":"IF(B12=\"\",\"\",ROUND(B12,4)*ROUND(C12,2))","v":7046.25}]
["Example: Tracey Thomas",1730.77,6,"$1730.77 per pay period x 6 pay periods. Reporting $5,000 match for T. Thomas expenses. ",{"$f":"IF(G13=\"\",\"\",G13-F13)","v":5384.619999999999},5000,{"$f":"IF(B13=\"\",\"\",ROUND(B13,4)*ROUND(C13,2))","v":10384.619999999999}]
[null,null,null,null,{"$f":"IF(G14=\"\",\"\",G14-F14)","v":""},null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(G15=\"\",\"\",G15-F15)","v":""},null,{"$f":"IF(B15=\"\",\"\",ROUND(ROUND(B15,4)*ROUND(C15,6),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Personnel,5,4):OFFSET(Overtime,-4,4))","v":0},{"$f":"SUM(OFFSET(Personnel,5,5):OFFSET(Overtime,-4,5))","v":0},{"$f":"SUM(OFFSET(Personnel,5,6):OFFSET(Overtime,-4,6))","v":0}]
[]
[]
["OVERTIME"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Sue Smith",40,104,"Describe activities of overtime here.",{"$f":"IF(G22=\"\",\"\",G22-F22)","v":1660},2500,{"$f":"IF(B22=\"\",\"\",ROUND(B22,4)*ROUND(C22,2))","v":4160}]
["Example: Tracey Thomas",1730.77,6,"$1730.77 per pay period x 6 pay periods. Reporting $5,000 match for T. Thomas expenses. ",{"$f":"IF(G23=\"\",\"\",G23-F23)","v":5384.619999999999},5000,{"$f":"IF(B23=\"\",\"\",ROUND(B23,4)*ROUND(C23,2))","v":10384.619999999999}]
[null,null,null,null,{"$f":"IF(G24=\"\",\"\",G24-F24)","v":""},null,{"$f":"IF(B24=\"\",\"\",ROUND(ROUND(B24,4)*ROUND(C24,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(G25=\"\",\"\",G25-F25)","v":""},null,{"$f":"IF(B25=\"\",\"\",ROUND(ROUND(B25,4)*ROUND(C25,6),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Overtime,5,4):OFFSET(Fringe,-4,4))","v":0},{"$f":"SUM(OFFSET(Overtime,5,5):OFFSET(Fringe,-4,5))","v":0},{"$f":"SUM(OFFSET(Overtime,5,6):OFFSET(Fringe,-4,6))","v":0}]
[]
[]
["FRINGE AND PAYROLL TAX"]
[]
["Employee Name","Wages Applied to Fringe","Contract Fringe Rate","Description","Cash Expenditures","Match Expenditures","Total 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(G32=\"\",\"\",G32-F32)","v":1479.7124999999999},null,{"$f":"IF(B32=\"\",\"\",ROUND(B32,4)*ROUND(C32,4))","v":1479.7124999999999}]
["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(G33=\"\",\"\",G33-F33)","v":538.46200000000022},500,{"$f":"IF(B33=\"\",\"\",ROUND(B33,4)*ROUND(C33,4))","v":1038.4620000000002}]
[null,null,null,null,{"$f":"IF(G34=\"\",\"\",G34-F34)","v":""},null,{"$f":"IF(B34=\"\",\"\",ROUND(ROUND(B34,4)*ROUND(C34,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(G35=\"\",\"\",G35-F35)","v":""},null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Contractors,-4,4))","v":0},{"$f":"SUM(OFFSET(Fringe,5,5):OFFSET(Contractors,-4,5))","v":0},{"$f":"SUM(OFFSET(Fringe,5,6):OFFSET(Contractors,-4,6))","v":0}]
[]
[]
["CONTRACTS"]
[]
["Contractorss Name","Pay Rate","Quantity","Description ","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: JJ Counseling",200,24,"Describe activities of Contracts here.",{"$f":"IF(G42=\"\",\"\",G42-F42)","v":2000},2800,{"$f":"IF(B42=\"\",\"\",ROUND(B42,4)*ROUND(C42,2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(G43=\"\",\"\",G43-F43)","v":9450},0,{"$f":"IF(B43=\"\",\"\",ROUND(B43,4)*ROUND(C43,2))","v":9450}]
[null,null,null,null,{"$f":"IF(G44=\"\",\"\",G44-F44)","v":""},null,{"$f":"IF(B44=\"\",\"\",ROUND(ROUND(B44,4)*ROUND(C44,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(G45=\"\",\"\",G45-F45)","v":""},null,{"$f":"IF(B45=\"\",\"\",ROUND(ROUND(B45,4)*ROUND(C45,6),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Contractors,5,4):OFFSET(Travel,-4,4))","v":0},{"$f":"SUM(OFFSET(Contractors,5,5):OFFSET(Travel,-4,5))","v":0},{"$f":"SUM(OFFSET(Contractors,5,6):OFFSET(Travel,-4,6))","v":0}]
[]
[]
["TRAVEL"]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Sue Smith",0.62,125,"Describe acitivities or Travel here. ",{"$f":"IF(G52=\"\",\"\",G52-F52)","v":77.5},0,{"$f":"IF(B52=\"\",\"\",ROUND(B52,4)*ROUND(C52,2))","v":77.5}]
["Example: Tracey Thomas",0.45,500,"Travel related to grant; $0.45/mile x 500 miles",{"$f":"IF(G53=\"\",\"\",G53-F53)","v":225},0,{"$f":"IF(B53=\"\",\"\",ROUND(B53,4)*ROUND(C53,2))","v":225}]
[null,null,null,null,{"$f":"IF(G54=\"\",\"\",G54-F54)","v":""},null,{"$f":"IF(B54=\"\",\"\",ROUND(ROUND(B54,4)*ROUND(C54,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(G55=\"\",\"\",G55-F55)","v":""},null,{"$f":"IF(B55=\"\",\"\",ROUND(ROUND(B55,4)*ROUND(C55,6),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Equipment,-4,4))","v":0},{"$f":"SUM(OFFSET(Travel,5,5):OFFSET(Equipment,-4,5))","v":0},{"$f":"SUM(OFFSET(Travel,5,6):OFFSET(Equipment,-4,6))","v":0}]
[]
[]
["EQUIPMENT"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Laptop",1200,1,"Describe purpose of equipment here. ",{"$f":"IF(G62=\"\",\"\",G62-F62)","v":1075},125,{"$f":"IF(B62=\"\",\"\",ROUND(B62,4)*ROUND(C62,2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(G63=\"\",\"\",G63-F63)","v":150},0,{"$f":"IF(B63=\"\",\"\",ROUND(B63,4)*ROUND(C63,2))","v":150}]
[null,null,null,null,{"$f":"IF(G64=\"\",\"\",G64-F64)","v":""},null,{"$f":"IF(B64=\"\",\"\",ROUND(ROUND(B64,4)*ROUND(C64,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(G65=\"\",\"\",G65-F65)","v":""},null,{"$f":"IF(B65=\"\",\"\",ROUND(ROUND(B65,4)*ROUND(C65,6),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Supplies,-4,4))","v":0},{"$f":"SUM(OFFSET(Equipment,5,5):OFFSET(Supplies,-4,5))","v":0},{"$f":"SUM(OFFSET(Equipment,5,6):OFFSET(Supplies,-4,6))","v":0}]
[]
[]
["SUPPLIES"]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Copy Paper",50,4,"Describe purpose of supplies here. ",{"$f":"IF(G72=\"\",\"\",G72-F72)","v":100},100,{"$f":"IF(B72=\"\",\"\",ROUND(B72,4)*ROUND(C72,2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(G73=\"\",\"\",G73-F73)","v":75},0,{"$f":"IF(B73=\"\",\"\",ROUND(B73,4)*ROUND(C73,2))","v":75}]
[null,null,null,null,{"$f":"IF(G74=\"\",\"\",G74-F74)","v":""},null,{"$f":"IF(B74=\"\",\"\",ROUND(ROUND(B74,4)*ROUND(C74,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(G75=\"\",\"\",G75-F75)","v":""},null,{"$f":"IF(B75=\"\",\"\",ROUND(ROUND(B75,4)*ROUND(C75,6),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Supplies,5,4):OFFSET(Other,-4,4))","v":0},{"$f":"SUM(OFFSET(Supplies,5,5):OFFSET(Other,-4,5))","v":0},{"$f":"SUM(OFFSET(Supplies,5,6):OFFSET(Other,-4,6))","v":0}]
[]
[]
["OTHER"]
[]
["Item/Company","Cost","Quantity","Description","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Telephone",65,6,"Describe activities or other items here. ",{"$f":"IF(G82=\"\",\"\",G82-F82)","v":390},0,{"$f":"IF(B82=\"\",\"\",ROUND(B82,4)*ROUND(C82,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(G83=\"\",\"\",G83-F83)","v":1500},0,{"$f":"IF(B83=\"\",\"\",ROUND(B83,4)*ROUND(C83,2))","v":1500}]
[null,null,null,null,{"$f":"IF(G84=\"\",\"\",G84-F84)","v":""},null,{"$f":"IF(B84=\"\",\"\",ROUND(ROUND(B84,4)*ROUND(C84,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(G85=\"\",\"\",G85-F85)","v":""},null,{"$f":"IF(B85=\"\",\"\",ROUND(ROUND(B85,4)*ROUND(C85,6),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Other,5,4):OFFSET(GrandTotal,-3,4))","v":0},{"$f":"SUM(OFFSET(Other,5,5):OFFSET(GrandTotal,-3,5))","v":0},{"$f":"SUM(OFFSET(Other,5,6):OFFSET(GrandTotal,-3,6))","v":0}]
[]
["Grand Total(s):",null,null,null,{"$f":"ROUND(SUM(E16+E26+E36+E46+E56+E66+E76+E86),2)","v":0},{"$f":"ROUND(SUM(F16+F26+F36+F46+F56+F66+F76+F86),2)","v":0},{"$f":"ROUND(SUM(G16+G26+G36+G46+G56+G66+G76+G86),2)","v":0}]

{"sheet":"Cost Categories","index":3,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[[11,0,13,0],[14,0,15,0],[14,1,15,1],[16,0,17,0],[16,1,17,1],[18,0,23,0],[1,0,2,0],[1,1,2,1],[5,0,6,0],[5,1,6,1],[7,0,10,0]]}
[]
["Budget Cost Categories","Explanation of Costs"]
[]
["Personnel","·         Full- or part-time regular salaried employees working on the grant."]
["Overtime","·         Allowable only for sworn law enforcement personnel working on the grant. "]
["Fringe","·         Employer Fringe benefits requested to be paid by this grant can be based on either: 1) actual known municipality paid costs for each benefit category, or 2) an established formula applied to the base salary numbers shown above broken out by the benefit category.  Fringe benefits are for the personnel listed in budget category A and only for the percentage of time devoted to the project.  Employer paid payroll taxes may also be included as a separate cost."]
[]
["Contracts","·         Consultant or contractor fees."]
[null,"·         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 requires prior written approval by OGR. "]
[null,"·         Contracts – a competitive process based on the municipality’s procurement policy should be followed when procuring contracted services."]
[null,"·         Contract salary, fringe benefit, travel, and other costs should be placed within this category and follow instructions within direct salary, fringe benefit, travel and other cost categories. "]
["Travel","·         Travel directly related to the purpose of the grant."]
[null,"·         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."]
[null,"·         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."]
["Equipment ","·         Tangible, non-expendable personal property having a useful life of more than one year; cost based on classification of equipment (e.g., communication, IT, etc.). "]
[]
["Supplies","·         General supplies required for project or office (pens, pencils, postage, training materials, copying paper, and other expendable items such as books, ink, etc.)."]
[]
["Other","·         Direct and/or support service costs relevant to the proposed project that cannot be listed within the personnel, fringe, consultants/contracts, travel and/or supplies cost category can be included in the “Other” cost category.  Please be sure to itemize each cost type and detail as to how the amount budgeted was calculated."]
[null,"·         Items such as rent, telephone, reproduction of training materials are considered administration costs and shall not exceed 10% of your state award."]
[null,"·         No grant funds may be used for incentives without prior written approval from OGR."]
[null,"·         No grant funds may be used for a cash reserve."]
[null,"·         No grant funds may be spent on food or beverages."]