{"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":13,"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":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"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SFY2024 Human Trafficking Grant"]
[]
["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}]
[]
["Consultants/Contractors 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":1,"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"]
["SFY2024 Human Trafficking Grant"]
[{"$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. 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."]
[]
["PERSONNEL - Costs associated with agency personnel. List position, percentage of time charged to the grant, and annual salary. Include a brief description of the duties/activities to be completed and supported with grant funding. 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"]
["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(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 - 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 Police in the AGF. Click the \"Add Overtime\" 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"]
["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,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Overtime,5,4):OFFSET(Fringe,-4,4))","v":0}]
[]
[]
["FRINGE AND PAYROLL TAX - A copy of your agency's fringe rate agreement must be provided with the application submission. Eligible costs may 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. 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"]
["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,{"$f":"IF(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,6),2))","v":""}]
[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}]
[]
[]
["CONTRACTORS/CONSULTANTS - Consultant or Sub-Awards/Contracts to be funded. 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. The maximum rate for consultants is $650 for an 8 hour day or $81.25 per hour. Any request for compensation over $650 per day requires prior written approval by OGR. 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"]
["Example: JJ Counseling",200,24,"Counseling of domestic violence survivors; $200 per day x 24 days. Submitting reimbursement for $2,800.",{"$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 - 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.62 per mile, as well as the actual costs of tolls and parking. 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"]
["Example: Sue Smith",0.62,250,"Mileage reimbursement for 250 miles.",{"$f":"IF(B61=\"\",\"\",ROUND(ROUND(B61,4)*ROUND(C61,4),2))","v":155}]
["Example: Tracey Thomas",0.62,500,"Travel related to grant; $0.62/mile x 500 miles",{"$f":"IF(B62=\"\",\"\",ROUND(ROUND(B62,4)*ROUND(C62,4),2))","v":310}]
[null,null,null,null,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Travel,5,4):OFFSET(Equipment,-4,4))","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"]
["Example: Laptop",1200,1,"(1) Dell 1000 Laptop at $1,200.00.",{"$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,""]
[null,null,null,null,""]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Equipment,5,4):OFFSET(Supplies,-4,4))","v":0}]
[]
[]
["SUPPLIES - General supplies directly correlating to the program. 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"]
["Example: Copy Paper",50,4,"$50.00/box, 4 boxes. ",{"$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 - For items not included in the aforementioned. List items by major type and the basis of the computation. 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"]
["Example: Telephone",65,6,"Verizon: January-June at $65 per month",{"$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,4),2))","v":""}]
[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(E15+E25+E35+E45+E55+E65+E75+E85+E95),2)","v":0}]