{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Budget Summary","Budget Detail"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":12,"comments":1,"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":"Budget Summary","index":0,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,0,2,3],[18,0,18,3],[40,1,40,3]]}
[]
["Attachment B - Budget Worksheets"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FY 2022 Senator Charles E. Shannon Jr., Community Safety Initiative          Local Action Research Partners (LARP)"]
[]
["Cost Categories","Federal Costs","Match Costs","Total Costs"]
[]
[]
["Personnel Costs",{"$f":"'Budget Detail'!E17","v":0},{"$f":"'Budget Detail'!F17","v":0},{"$f":"'Budget Detail'!G17","v":0}]
[]
["Fringe Benefit Costs",{"$f":"'Budget Detail'!E27","v":0},{"$f":"'Budget Detail'!F27","v":0},{"$f":"'Budget Detail'!G27","v":0}]
[]
["Contracts Costs",{"$f":"'Budget Detail'!E37","v":0},{"$f":"'Budget Detail'!F37","v":0},{"$f":"'Budget Detail'!G37","v":0}]
[]
["Travel Costs",{"$f":"'Budget Detail'!E47","v":0},{"$f":"'Budget Detail'!F47","v":0},{"$f":"'Budget Detail'!G47","v":0}]
[]
["Equipment Costs",{"$f":"'Budget Detail'!E57","v":0},{"$f":"'Budget Detail'!F57","v":0},{"$f":"'Budget Detail'!G57","v":0}]
[]
["Supplies Costs",{"$f":"'Budget Detail'!E67","v":0},{"$f":"'Budget Detail'!F67","v":0},{"$f":"'Budget Detail'!G67","v":0}]
[]
["Other Costs",{"$f":"'Budget Detail'!E77","v":0},{"$f":"'Budget Detail'!F77","v":0},{"$f":"'Budget Detail'!G77","v":0}]
[]
["Total Costs",{"$f":"B24+B26+B28+B30+B32+B34+B36","v":0},{"$f":"C24+C26+C28+C30+C32+C34+C36","v":0},{"$f":"D24+D26+D28+D30+D32+D34+D36","v":0}]
[]
[]
["Name of Applicant Organization "]

{"sheet":"Budget Detail","index":1,"n_rows":79,"n_cols":7,"rows_kept":79,"cut":false,"hidden":false,"merged":[[40,0,40,6],[29,0,29,6],[30,0,30,6],[39,0,39,6],[36,0,36,3],[19,0,19,6],[20,0,20,6],[26,0,26,3],[0,0,0,6],[1,0,1,6],[2,0,2,6],[4,0,4,6],[16,0,16,3],[8,0,8,4],[9,0,9,6],[10,0,10,6],[7,0,7,6],[6,0,6,6],[79,0,79,6],[66,0,66,3],[46,0,46,3],[76,0,76,3],[78,0,78,3],[59,0,59,6],[60,0,60,6],[69,0,69,6],[70,0,70,6],[56,0,56,3],[49,0,49,6],[50,0,50,6]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FY 2022 Senator Charles E. Shannon Jr., Community Safety Initiative"]
[null,null,null,"Local Action Research Partners (LARP)"]
["Attachment B - Budget Worksheets"]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you have enabled macros when prompted upon opening this document. Each cost category has headers that will be marked with a red flag in the top right corner. Hovering over these headers will provide a description for what actions are needed to be taken in that cost category.  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."]
["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: Full or part-time regular salaried employees working on the grant. Click the \"Add Personnel\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button. "]
[]
["Employee Name","Pay Rate","Quantity","Description ","Cash Expenditures","Match Expenditures","Total 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(G13=\"\",\"\",G13-F13)","v":7046.25},0,{"$f":"IF(B13=\"\",\"\",ROUND(B13,4)*ROUND(C13,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(G14=\"\",\"\",G14-F14)","v":5384.619999999999},5000,{"$f":"IF(B14=\"\",\"\",ROUND(B14,4)*ROUND(C14,2))","v":10384.619999999999}]
[null,null,null,null,{"$f":"IF(G15=\"\",\"\",G15-F15)","v":""},null,{"$f":"IF(B15=\"\",\"\",ROUND(ROUND(B15,4)*ROUND(C15,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(G16=\"\",\"\",G16-F16)","v":""},null,{"$f":"IF(B16=\"\",\"\",ROUND(ROUND(B16,4)*ROUND(C16,2),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Personnel,5,4):OFFSET(Fringe,-4,4))","v":0},{"$f":"SUM(OFFSET(Personnel,5,5):OFFSET(Fringe,-4,5))","v":0},{"$f":"SUM(OFFSET(Personnel,5,6):OFFSET(Fringe,-4,6))","v":0}]
[]
[]
["FRINGE AND PAYROLL TAX: 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 number shown in Personnel broken out by the benefit category. Fringe benefits are for the personnel listed in the Personnel cost category and only for the percentage of time devoted to the project. Eligible costs include the employer share of the following: life insurance, health insurance, social security costs, pension costs, unemployment insurance costs, workers compensation insurance, FMLA costs, and payroll taxes. Include copy of approved rate agreement in the application response. Click the \"Add Fringe\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button."]
[]
["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(G23=\"\",\"\",G23-F23)","v":1479.7124999999999},null,{"$f":"IF(B23=\"\",\"\",ROUND(B23,4)*ROUND(C23,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(G24=\"\",\"\",G24-F24)","v":538.46200000000022},500,{"$f":"IF(B24=\"\",\"\",ROUND(B24,4)*ROUND(C24,4))","v":1038.4620000000002}]
[null,null,null,null,{"$f":"IF(G25=\"\",\"\",G25-F25)","v":""},null,{"$f":"IF(B25=\"\",\"\",ROUND(ROUND(B25,4)*ROUND(C25,6),2))","v":""}]
[null,null,null,null,{"$f":"IF(G26=\"\",\"\",G26-F26)","v":""},null,{"$f":"IF(B26=\"\",\"\",ROUND(ROUND(B26,4)*ROUND(C26,6),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 / CONSULTANTS: For contracts, a competitive process based on the municipality's procurement policy should be followed when procuring contracted services. Contract salary, fringe benefits, travel, and other costs should be placed within this cost category and follow instructions within direct salary, fringe benefit, travel, and other cost categories. This includes consultant or contractor fees. 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 8 hour day or $81.25 per hour requires prior written approval by EOPSS. Click the \"Add C/C\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button. "]
[]
["Contractors/Consultants Name","Pay Rate","Quantity","Description ","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: JJ Counseling",200,24,"Counseling of domestic violence survivors; $200 per day x 24 days. Submitting reimbursement for $2,800.",{"$f":"IF(G33=\"\",\"\",G33-F33)","v":2000},2800,{"$f":"IF(B33=\"\",\"\",ROUND(B33,4)*ROUND(C33,2))","v":4800}]
["Example: B & B Tech Support",45,210,"Installation of database and training; $45 per hour x 210 hours ",{"$f":"IF(G34=\"\",\"\",G34-F34)","v":9450},0,{"$f":"IF(B34=\"\",\"\",ROUND(B34,4)*ROUND(C34,2))","v":9450}]
[null,null,null,null,{"$f":"IF(G35=\"\",\"\",G35-F35)","v":""},null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(G36=\"\",\"\",G36-F36)","v":""},null,{"$f":"IF(B36=\"\",\"\",ROUND(ROUND(B36,4)*ROUND(C36,2),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: 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.45 per mile, as well as the actual costs of tolls and parking. Click the \"Add Travel\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button. "]
[]
["Employee Name","Rate","Quantity","Description","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Sue Smith",250,1,"Gas reimbursement related to grant. ",{"$f":"IF(G43=\"\",\"\",G43-F43)","v":250},0,{"$f":"IF(B43=\"\",\"\",ROUND(B43,4)*ROUND(C43,2))","v":250}]
["Example: Tracey Thomas",0.45,500,"Travel related to grant; $0.45/mile x 500 miles",{"$f":"IF(G44=\"\",\"\",G44-F44)","v":225},0,{"$f":"IF(B44=\"\",\"\",ROUND(B44,4)*ROUND(C44,2))","v":225}]
[null,null,null,null,{"$f":"IF(G45=\"\",\"\",G45-F45)","v":""},null,{"$f":"IF(B45=\"\",\"\",ROUND(ROUND(B45,4)*ROUND(C45,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(G46=\"\",\"\",G46-F46)","v":""},null,{"$f":"IF(B46=\"\",\"\",ROUND(ROUND(B46,4)*ROUND(C46,2),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: Tangible non-expendable personal property having a useful life of more than one year; cost based on classification of equipment. Click the \"Add Equipment\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button. "]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Laptop",1200,1,"(1) Dell 1000 Laptop at $1,200.00.",{"$f":"IF(G53=\"\",\"\",G53-F53)","v":1075},125,{"$f":"IF(B53=\"\",\"\",ROUND(B53,4)*ROUND(C53,2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(G54=\"\",\"\",G54-F54)","v":150},0,{"$f":"IF(B54=\"\",\"\",ROUND(B54,4)*ROUND(C54,2))","v":150}]
[null,null,null,null,{"$f":"IF(G55=\"\",\"\",G55-F55)","v":""},null,{"$f":"IF(B55=\"\",\"\",ROUND(ROUND(B55,4)*ROUND(C55,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(G56=\"\",\"\",G56-F56)","v":""},null,{"$f":"IF(B56=\"\",\"\",ROUND(ROUND(B56,4)*ROUND(C56,2),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: General supplies required for program (pens, pencils, postage, training materials, copying paper, and other expendable items such as books, ink, etc.). Click the \"Add Supplies\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button."]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Copy Paper",50,4,"$50.00/box, 4 boxes. ",{"$f":"IF(G63=\"\",\"\",G63-F63)","v":100},100,{"$f":"IF(B63=\"\",\"\",ROUND(B63,4)*ROUND(C63,2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(G64=\"\",\"\",G64-F64)","v":75},0,{"$f":"IF(B64=\"\",\"\",ROUND(B64,4)*ROUND(C64,2))","v":75}]
[null,null,null,null,{"$f":"IF(G65=\"\",\"\",G65-F65)","v":""},null,{"$f":"IF(B65=\"\",\"\",ROUND(ROUND(B65,4)*ROUND(C65,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(G66=\"\",\"\",G66-F66)","v":""},null,{"$f":"IF(B66=\"\",\"\",ROUND(ROUND(B66,4)*ROUND(C66,2),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: Items not listed in the aforementioned (e.g. direct and/or support service costs, rent costs, telephone costs, reproduction costs, training material costs, 10% grant administration costs). Click the \"Add Other\" button to add a new record. To delete an unwanted record, click into the cell that you want to delete, and click the \"Delete Row\" button."]
[]
["Item/Company","Cost","Quantity","Description","Cash Expenditures","Match Expenditures","Total Expenditures"]
["Example: Telephone",65,6,"Verizon: January-June at $65 per month",{"$f":"IF(G73=\"\",\"\",G73-F73)","v":390},0,{"$f":"IF(B73=\"\",\"\",ROUND(B73,4)*ROUND(C73,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(G74=\"\",\"\",G74-F74)","v":1500},0,{"$f":"IF(B74=\"\",\"\",ROUND(B74,4)*ROUND(C74,2))","v":1500}]
[null,null,null,null,{"$f":"IF(G75=\"\",\"\",G75-F75)","v":""},null,{"$f":"IF(B75=\"\",\"\",ROUND(ROUND(B75,4)*ROUND(C75,2),2))","v":""}]
[null,null,null,null,{"$f":"IF(G76=\"\",\"\",G76-F76)","v":""},null,{"$f":"IF(B76=\"\",\"\",ROUND(ROUND(B76,4)*ROUND(C76,2),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(E17+E27+E37+E47+E57+E67+E77),2)","v":0},{"$f":"ROUND(SUM(F17+F27+F37+F47+F57+F67+F77),2)","v":0},{"$f":"ROUND(SUM(G17+G27+G37+G47+G57+G67+G77),2)","v":0}]