{"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":11,"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":"Budget Summary","index":0,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,0,2,3],[18,0,18,3],[42,1,42,3]]}
[]
["Attachment B - Budget Worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FFY 2023 Traffic Safety Grant Program for                                                                 State Government Agencies"]
[]
["Cost Categories","Federal 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}]
[]
["Fringe Benefit Costs",{"$f":"'Budget Detail'!E26","v":0},{"$f":"'Budget Detail'!F26","v":0},{"$f":"'Budget Detail'!G26","v":0}]
[]
["Indirect Costs",{"$f":"'Budget Detail'!E36","v":0},{"$f":"'Budget Detail'!F36","v":0},{"$f":"'Budget Detail'!G36","v":0}]
[]
["Consultants/Contractors 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+B34+B32+B36+B38","v":0},{"$f":"C24+C26+C28+C30+C34+C32+C36+C38","v":0},0]
[]
[]
["Name of Applicant Organization "]

{"sheet":"Budget Detail","index":1,"n_rows":88,"n_cols":7,"rows_kept":88,"cut":false,"hidden":false,"merged":[[78,0,78,6],[79,0,79,6],[49,0,49,6],[58,0,58,6],[59,0,59,6],[68,0,68,6],[69,0,69,6],[65,0,65,3],[39,0,39,6],[6,0,6,6],[8,0,8,6],[9,0,9,6],[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,6],[5,0,5,6],[48,0,48,6],[15,0,15,3],[7,0,7,4],[88,0,88,6],[75,0,75,3],[55,0,55,3],[85,0,85,3],[87,0,87,3],[25,0,25,3],[18,0,18,6],[19,0,19,6],[45,0,45,3],[35,0,35,3],[28,0,28,6],[29,0,29,6],[38,0,38,6]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["FFY 2023 Traffic Safety Grant Program for State Government Agencies"]
[{"$f":"CONCATENATE(\"Attachment B - \", 'Budget Summary'!B43)","v":"Attachment B - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you have enabled macros when prompted upon opening this document. 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."]
["Non-Executive Office of Public Safety and Security state agency subrecipients must provide a minimum 20% match of the total project cost (e.g., if the total project cost is $100,000, OGR will provide up to $80,000 the state agency must provide at least $20,000 match). Match may be (state, not federal) funding directly provided by the subrecipient for the project and/or (state, not federal) resources provided by the subrecipient that directly benefit the project. The match must be: an allowable expense(s) per the AGF, incurred during the same period as the project, auditable and documentable expenditures. The source and match amount must be detailed in the applicant's section (Section #11) and reported monthly, along with project expenditures, to OGR. The match expenses may not be utilized as match for any other federally funded project. For more information on what constitutes match, please review 2 CFR Part 200.306 (Cost sharing or matching). 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."]
[]
["PERSONNEL: Full or part-time regular salaried employees working on the grant. For Overtime costs, see the OGR related policy located in the AGF. 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(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,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(G15=\"\",\"\",G15-F15)","v":""},null,{"$f":"IF(B15=\"\",\"\",ROUND(ROUND(B15,4)*ROUND(C15,4),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: 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. Cost amounts for direct fringe benefits can be either actual costs or rates per employee calculated by the fiscal or human resource unit in your organization (rate computations must be included). INCLUDE A COPY OF THE 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(G22=\"\",\"\",G22-F22)","v":1479.7124999999999},null,{"$f":"IF(B22=\"\",\"\",ROUND(B22,4)*ROUND(C22,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(G23=\"\",\"\",G23-F23)","v":538.46200000000022},500,{"$f":"IF(B23=\"\",\"\",ROUND(B23,4)*ROUND(C23,4))","v":1038.4620000000002}]
[null,null,null,null,{"$f":"IF(G24=\"\",\"\",G24-F24)","v":""},null,{"$f":"IF(B24=\"\",\"\",ROUND(ROUND(B24,4)*ROUND(C24,8),2))","v":""}]
[null,null,null,null,{"$f":"IF(G25=\"\",\"\",G25-F25)","v":""},null,{"$f":"IF(B25=\"\",\"\",ROUND(ROUND(B25,4)*ROUND(C25,8),2))","v":""}]
["Subtotal(s):",null,null,null,{"$f":"SUM(OFFSET(Fringe,5,4):OFFSET(Indirect,-4,4))","v":0},{"$f":"SUM(OFFSET(Fringe,5,5):OFFSET(Indirect,-4,5))","v":0},{"$f":"SUM(OFFSET(Fringe,5,6):OFFSET(Indirect,-4,6))","v":0}]
[]
[]
["INDIRECT COSTS: COSTS CAN ONLY BE SHOWN HERE IF THE APPLICANT HAS A FEDERALLY APPROVED INDIRECT COST RATE. INCLUDE A COPY OF THE RATE AGREEMENT IN THE APPLICATION RESPONSE. If the applicant's accounting system permits, costs may be allocated to the applicable direct cost category in the budget, including the category \"other\" if the costs identified do not fit into one specific direct cost category. Any non-federal entity, except for state, local units of government, or Indian tribes, that has never received a negotiated indirect cost rate may elect to charge a de minimis rate of 10% of modified total direct costs (MTDC) which may be used indefinitely. Click the \"Add Indirect\" 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","Expenses Applied to Indirect Rate","Contract Indirect Rate","Description","Cash Expenditures","Match Expenditures","Total 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(G32=\"\",\"\",G32-F32)","v":1534.6727999999998},0,{"$f":"IF(B32=\"\",\"\",ROUND(B32,4)*ROUND(C32,4))","v":1534.6727999999998}]
["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(G33=\"\",\"\",G33-F33)","v":1066.1543999999999},990,{"$f":"IF(B33=\"\",\"\",ROUND(B33,4)*ROUND(C33,4))","v":2056.1543999999999}]
[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(Indirect,5,4):OFFSET(Contractors,-4,4))","v":0},{"$f":"SUM(OFFSET(Indirect,5,5):OFFSET(Contractors,-4,5))","v":0},{"$f":"SUM(OFFSET(Indirect,5,6):OFFSET(Contractors,-4,6))","v":0}]
[]
[]
["CONTRACTORS/CONSULTANTS: 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. This rate is the exception, not the rule. 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(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,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(G45=\"\",\"\",G45-F45)","v":""},null,{"$f":"IF(B45=\"\",\"\",ROUND(ROUND(B45,4)*ROUND(C45,4),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 $.585 per mile, as well as the actual costs of tolls and parking. Effective March 20, 2022, the new mileage reimbursement rate increased from $.45 per mile to $.585 per mile. The increase applies to mileage incurred on or after March 20, 2022, regardless of the mileage reimbursement submission dates. 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. 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(G52=\"\",\"\",G52-F52)","v":250},0,{"$f":"IF(B52=\"\",\"\",ROUND(B52,4)*ROUND(C52,2))","v":250}]
["Example: Tracey Thomas",0.58499999999999996,500,"Travel related to grant; $0.45/mile x 500 miles",{"$f":"IF(G53=\"\",\"\",G53-F53)","v":292.5},0,{"$f":"IF(B53=\"\",\"\",ROUND(B53,4)*ROUND(C53,2))","v":292.5}]
[null,null,null,null,{"$f":"IF(G54=\"\",\"\",G54-F54)","v":""},null,{"$f":"IF(B54=\"\",\"\",ROUND(ROUND(B54,4)*ROUND(C54,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(G55=\"\",\"\",G55-F55)","v":""},null,{"$f":"IF(B55=\"\",\"\",ROUND(ROUND(B55,4)*ROUND(C55,4),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. Equipment must be directly related to the program implementation. 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(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,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(G65=\"\",\"\",G65-F65)","v":""},null,{"$f":"IF(B65=\"\",\"\",ROUND(ROUND(B65,4)*ROUND(C65,4),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 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(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,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(G75=\"\",\"\",G75-F75)","v":""},null,{"$f":"IF(B75=\"\",\"\",ROUND(ROUND(B75,4)*ROUND(C75,4),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 listed in this category are those that cannot be listed within the aforementioned costs categories (e.g., telephone costs, training material 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(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,4),2))","v":""}]
[null,null,null,null,{"$f":"IF(G85=\"\",\"\",G85-F85)","v":""},null,{"$f":"IF(B85=\"\",\"\",ROUND(ROUND(B85,4)*ROUND(C85,4),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}]