{"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":1,"defined_names":23,"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":45,"n_cols":3,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,0,2,2],[18,0,18,2],[44,1,44,2]]}
[]
["Attachment A - Budget Worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FY 2024 Senator Charles E. Shannon Jr.                                                          Community Safety Initiative                                                                                                                                          Statewide Research Partner (SRP)"]
[]
["Cost Categories",null,"Cash Expenditures"]
[]
[]
["Personnel Costs",null,{"$f":"'Budget Detail'!E15","v":0}]
[]
["Overtime Costs",null,{"$f":"'Budget Detail'!E25","v":0}]
[]
["Fringe Benefit Costs",null,{"$f":"'Budget Detail'!E35","v":0}]
[]
["Indirect Costs",null,{"$f":"'Budget Detail'!E45","v":0}]
[]
["Contracts/Consultants Costs",null,{"$f":"'Budget Detail'!E55","v":0}]
[]
["Travel Costs",null,{"$f":"'Budget Detail'!E65","v":0}]
[]
["Equipment Costs",null,{"$f":"'Budget Detail'!E75","v":0}]
[]
["Supplies Costs",null,{"$f":"'Budget Detail'!E85","v":0}]
[]
["Other Costs",null,{"$f":"'Budget Detail'!E95","v":0}]
[]
["Total Costs",null,{"$f":"C24+C26+C28+C30+C32+C36+C34+C38+C40","v":0}]
[]
[]
["Name of Applicant Organization "]

{"sheet":"Budget Detail","index":2,"n_rows":97,"n_cols":5,"rows_kept":97,"cut":false,"hidden":false,"merged":[[87,0,87,4],[88,0,88,4],[58,0,58,4],[67,0,67,4],[68,0,68,4],[77,0,77,4],[78,0,78,4],[74,0,74,3],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[38,0,38,4],[47,0,47,4],[48,0,48,4],[7,0,7,4],[8,0,8,4],[17,0,17,4],[57,0,57,4],[14,0,14,3],[6,0,6,4],[24,0,24,3],[97,0,97,4],[84,0,84,3],[64,0,64,3],[94,0,94,3],[96,0,96,3],[34,0,34,3],[18,0,18,4],[27,0,27,4],[28,0,28,4],[54,0,54,3],[44,0,44,3],[37,0,37,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FY 2024 Shannon Statewide Research Partner (SRP)"]
[{"$f":"CONCATENATE(\"Attachment A - \", 'Budget Summary'!B45)","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 allison.garvey@mass.gov."]
[]
["PERSONNEL"]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: Sue Smith",23.487500000000001,300,"Describe activities 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. Reporting $5,000 match for T. Thomas expenses. ",{"$f":"IF(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":10384.620000000001}]
[null,null,null,null,""]
[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(B21=\"\",\"\",ROUND(ROUND(B21,4)*ROUND(C21,4),2))","v":4160}]
["Example: Tracey Thomas",32,52,"Officer worked a total of 52 hours responding to initial DV calls during the quarter at $32.00/hour.",{"$f":"IF(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":1664}]
[null,null,null,null,{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,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(B31=\"\",\"\",ROUND(ROUND(B31,4)*ROUND(C31,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(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,6),2))","v":1038.46}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Indirect,-4,4))","v":0}]
[]
[]
["INDIRECT COSTS"]
[]
["Employee Name","Expenses Applied to Indirect Rate","Contract Indirect Rate","Description","Cash Expenditures"]
["Example: Sue Smith",8525.9599999999991,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 Sue Smith.      (18% * (7046.25 + 1479.71)). ",{"$f":"IF(B41=\"\",\"\",ROUND(ROUND(B41,4)*ROUND(C41,6),2))","v":1534.67}]
["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(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,6),2))","v":2056.15}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["CONTRACTS/CONSULTANTS"]
[]
["Contracts/Consultants Name","Pay Rate","Quantity","Description ","Cash Expenditures"]
["Example: JJ Counseling",200,24,"Describe activities of Contracts/Consultants here.",{"$f":"IF(B51=\"\",\"\",ROUND(ROUND(B51,4)*ROUND(C51,4),2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,4),2))","v":9450}]
[null,null,null,null,{"$f":"IF(B53=\"\",\"\",ROUND(ROUND(B53,4)*ROUND(C53,4),2))","v":""}]
[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(B61=\"\",\"\",ROUND(ROUND(B61,4)*ROUND(C61,4),2))","v":250}]
["Example: Sue Smith",0.62,500,"Describe acitivities or Travel here. ",{"$f":"IF(B62=\"\",\"\",ROUND(ROUND(B62,4)*ROUND(C62,4),2))","v":310}]
[null,null,null,null,{"$f":"IF(B63=\"\",\"\",ROUND(ROUND(B63,4)*ROUND(C63,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,"Describe purpose of equipment here. ",{"$f":"IF(B71=\"\",\"\",ROUND(ROUND(B71,4)*ROUND(C71,4),2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B72=\"\",\"\",ROUND(ROUND(B72,4)*ROUND(C72,4),2))","v":150}]
[null,null,null,null,{"$f":"IF(B73=\"\",\"\",ROUND(ROUND(B73,4)*ROUND(C73,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,"Describe purpose of supplies here. ",{"$f":"IF(B81=\"\",\"\",ROUND(ROUND(B81,4)*ROUND(C81,4),2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B82=\"\",\"\",ROUND(ROUND(B82,4)*ROUND(C82,4),2))","v":75}]
[null,null,null,null,""]
[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: Training Materials",65,6,"Describe activities or other items here. ",{"$f":"IF(B91=\"\",\"\",ROUND(ROUND(B91,4)*ROUND(C91,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(B92=\"\",\"\",ROUND(ROUND(B92,4)*ROUND(C92,4),2))","v":1500}]
[null,null,null,null,{"$f":"IF(B93=\"\",\"\",ROUND(ROUND(B93,4)*ROUND(C93,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(B94=\"\",\"\",ROUND(ROUND(B94,4)*ROUND(C94,6),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+E85+E95),2)","v":0}]

{"sheet":"Cost Categories","index":3,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[23,0,23,1],[24,0,24,1],[25,0,25,1],[17,0,19,0],[1,1,2,1],[3,1,4,1],[5,0,6,0],[5,1,6,1],[7,0,10,0],[1,0,2,0],[11,0,12,0],[13,0,14,0],[13,1,14,1],[15,0,16,0],[15,1,16,1]]}
[]
["Budget Cost Categories","Explanation of Costs"]
[]
["Personnel","·         Full- or part-time regular salaried employees 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/Consultants","·         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,"·         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","·         Items (e.g., direct and/or support service costs, rent costs, telephone costs, reproduction costs, training material costs, 10% grant administration costs);                                                                                                                                                                                                         "]
[null,"·         Printing Costs;  "]
[null,"·         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. "]
[]
[]
[]
["Unallowable Costs"]
["•\t No grant funds may be spent for construction, office furniture, or other like purchases;"]
["•\t No grant funds may be spent on food or beverages."]