{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Opening Document","Budget Summary","Budget Detail","Budget Guidelines"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":2,"defined_names":131,"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":49,"n_cols":2,"rows_kept":49,"cut":false,"hidden":false,"merged":[[10,0,10,8]]}
[]
[null,"UPON OPENING DOCUMENT…"]
[]
[]
[]
[]
[]
[]
[]
[]
["Click on Enable Editing/Enable Content"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"IF THE RED BANNER OCCURS…."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1. DOWNLOAD DOCUMENT AND SAVE TO DESKTOP"]
[null,"2. RIGHT CLICK, PROPERTIES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. CHECK OFF UNBLOCK, CLICK APPLY, CLICK OK"]
[null,"4. REOPEN EXCEL WORKBOOK"]
[null,"5. IF NEEDED, ENABLE EDITING, ENABLE CONTENT"]

{"sheet":"Budget Summary","index":1,"n_rows":47,"n_cols":3,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,0,2,2],[18,0,18,2],[44,1,44,2],[46,0,46,2]]}
[]
["Attachment A - Budget Worksheet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Edward J. Byrne Memorial Justice Assistance Grant"]
[]
["Cost Categories",null,"Cash Expenditures"]
[]
[]
["Personnel Costs",null,{"$f":"'Budget Detail'!E16","v":0}]
[]
["Overtime Costs",null,{"$f":"'Budget Detail'!E26","v":0}]
[]
["Fringe Benefit Costs",null,{"$f":"'Budget Detail'!E36","v":0}]
[]
["Indirect Costs",null,{"$f":"'Budget Detail'!E46","v":0}]
[]
["Subawards / Contractors Costs",null,{"$f":"'Budget Detail'!E56","v":0}]
[]
["Travel Costs",null,{"$f":"'Budget Detail'!E66","v":0}]
[]
["Equipment Costs",null,{"$f":"'Budget Detail'!E76","v":0}]
[]
["Supplies Costs",null,{"$f":"'Budget Detail'!E86","v":0}]
[]
["Other Costs",null,{"$f":"'Budget Detail'!E96","v":0}]
[]
["Total Costs",null,{"$f":"C24+C26+C28+C30+C32+C36+C34+C38+C40","v":0}]
[]
[]
["Name of Police Department"]
[]
["This page will autofill from the information entered on the Budget Detail tab."]

{"sheet":"Budget Detail","index":2,"n_rows":98,"n_cols":5,"rows_kept":98,"cut":false,"hidden":false,"merged":[[88,0,88,4],[89,0,89,4],[59,0,59,4],[68,0,68,4],[69,0,69,4],[78,0,78,4],[79,0,79,4],[75,0,75,3],[6,0,6,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[5,0,5,4],[39,0,39,4],[48,0,48,4],[49,0,49,4],[8,0,8,4],[9,0,9,4],[18,0,18,4],[58,0,58,4],[15,0,15,3],[7,0,7,4],[25,0,25,3],[98,0,98,4],[85,0,85,3],[65,0,65,3],[95,0,95,3],[97,0,97,3],[35,0,35,3],[19,0,19,4],[28,0,28,4],[29,0,29,4],[55,0,55,3],[45,0,45,3],[38,0,38,4]]}
["Executive Office of Public Safety and Security "]
["Office of Grants and Research"]
["Edward J. Byrne Memorial Justice Assistance Grant"]
[{"$f":"CONCATENATE(\"Attachment A - \", 'Budget Summary'!B45)","v":"Attachment A - "}]
[]
["INSTRUCTIONS: This is a macro-enabled document. Please make sure that you read the instructions on the Opening Document tab upon opening this document to make sure that macros are enabled macros. 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 the BJAG grant manager assigned in the Availability of Grant Funds (AGF) document."]
["Please read the Availability of Grant Funds (AGF) document. This will outline key dates, funding criteria, allowable and unallowable costs. Cost category definitions are highlighted in the Budget Guidelines tab. All fringe and indirect rate agreements reported below must be consistent with how they will reported during the quarterly/monthly reimbursements. If these rates change during the grant period, please contact your BJAG grant manager. Also, please note that all costs reported below should be based on a Maximum 12-Month Timeline. "]
[]
["PERSONNEL"]
[]
["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(B12=\"\",\"\",ROUND(ROUND(B12,4)*ROUND(C12,4),2))","v":7046.25}]
["Example: Tracey Thomas",1730.77,6,"Please describe duties of Employee here. ",{"$f":"IF(B13=\"\",\"\",ROUND(ROUND(B13,4)*ROUND(C13,4),2))","v":10384.620000000001}]
[null,null,null,null,{"$f":"IF(B14=\"\",\"\",ROUND(ROUND(B14,4)*ROUND(C14,4),2))","v":""}]
[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(B22=\"\",\"\",ROUND(ROUND(B22,4)*ROUND(C22,4),2))","v":4160}]
["Example: Tracey Thomas",32,52,"Please describe duties of Employee here. ",{"$f":"IF(B23=\"\",\"\",ROUND(ROUND(B23,4)*ROUND(C23,4),2))","v":1664}]
[null,null,null,null,{"$f":"IF(B24=\"\",\"\",ROUND(ROUND(B24,4)*ROUND(C24,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(B32=\"\",\"\",ROUND(ROUND(B32,4)*ROUND(C32,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(B33=\"\",\"\",ROUND(ROUND(B33,4)*ROUND(C33,6),2))","v":1038.46}]
[null,null,null,null,""]
[null,null,null,null,{"$f":"IF(B35=\"\",\"\",ROUND(ROUND(B35,4)*ROUND(C35,8),2))","v":""}]
["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(B42=\"\",\"\",ROUND(ROUND(B42,4)*ROUND(C42,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(B43=\"\",\"\",ROUND(ROUND(B43,4)*ROUND(C43,6),2))","v":2056.15}]
[null,null,null,null,""]
[null,null,null,null,{"$f":"IF(B45=\"\",\"\",ROUND(ROUND(B45,4)*ROUND(C45,8),2))","v":""}]
["Subtotal:",null,null,null,{"$f":"SUM(OFFSET(Indirect,5,4):OFFSET(Contractors,-4,4))","v":0}]
[]
[]
["SUBAWARDS (SUBGRANTS), PROCUREMENT CONTRACTS, & CONSULTANT FEES"]
[]
["Choose Category from List of Values Dropdown Below","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(B52=\"\",\"\",ROUND(ROUND(B52,4)*ROUND(C52,4),2))","v":4800}]
["Example: Subawards",45,210,"Please provide the names of each Subaward, Contractor and Consultant as well as duties/obligations that will be performed here.",{"$f":"IF(B53=\"\",\"\",ROUND(ROUND(B53,4)*ROUND(C53,4),2))","v":9450}]
[null,null,null,null,{"$f":"IF(B54=\"\",\"\",ROUND(ROUND(B54,4)*ROUND(C54,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(B62=\"\",\"\",ROUND(ROUND(B62,4)*ROUND(C62,4),2))","v":250}]
["Example: Tracey Thomas",0.62,500,"Travel related to grant; $0.62/mile x 500 miles",{"$f":"IF(B63=\"\",\"\",ROUND(ROUND(B63,4)*ROUND(C63,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"]
[]
["Equipment","Cost","Quantity","Description","Cash Expenditures"]
["Example: Laptop",1200,1,"Please describe purpose of Equipment here. ",{"$f":"IF(B72=\"\",\"\",ROUND(ROUND(B72,4)*ROUND(C72,4),2))","v":1200}]
["Example: Computer Keyboard",50,3,"Replacement keyboard, IBM part #872021. (3) keyboards at $50/each",{"$f":"IF(B73=\"\",\"\",ROUND(ROUND(B73,4)*ROUND(C73,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"]
[]
["Supplies/Company","Cost","Quantity","Description","Cash Expenditures"]
["Example: Copy Paper",50,4,"Please describe purpose of Supplies here. ",{"$f":"IF(B82=\"\",\"\",ROUND(ROUND(B82,4)*ROUND(C82,4),2))","v":200}]
["Example: ABC Office Supply",75,1,"1 lot of office supplies (pens, staples, paperclips), $75/lot",{"$f":"IF(B83=\"\",\"\",ROUND(ROUND(B83,4)*ROUND(C83,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: Telephone",65,6,"Please describe purpose of item/activity here. ",{"$f":"IF(B92=\"\",\"\",ROUND(ROUND(B92,4)*ROUND(C92,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(B93=\"\",\"\",ROUND(ROUND(B93,4)*ROUND(C93,4),2))","v":1500}]
[null,null,null,null,{"$f":"IF(B94=\"\",\"\",ROUND(ROUND(B94,4)*ROUND(C94,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(E16+E26+E36+E46+E56+E66+E76+E86+E96),2)","v":0}]

{"sheet":"Budget Guidelines","index":3,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[[6,1,6,10],[7,1,7,10],[8,1,8,10],[9,1,9,10],[0,0,0,10],[1,1,1,10],[2,1,2,10],[3,1,3,10],[4,1,4,10],[5,1,5,10]]}
["Budget Category Descriptions:"]
["Personnel","List each position by title and name of employee, if available. Show the annual salary rate and the percentage of time to be devoted to the project. Compensation paid for employees engaged in grant activities must be consistent with that paid for similar work within the applicant organization. In the budget narrative, include a description of the responsibilities and duties of each position in relationship to fulfilling the project goals and objectives. All requested information must be included in the budget detail worksheet and budget narrative.\n"]
["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 Policy in the AGF. "]
["Fringe Benefits","Fringe benefits should be based on actual known costs or an approved negotiated rate by a Federal agency. If not based on an approved negotiated rate, list the composition of the fringe benefit package. Fringe benefits are for the personnel listed in the budget category (A) and only for the percentage of time devoted to the project. Actual know costs must be itemized by type and include rate computation.  Include a copy of approved rate agreement.  All requested information must be included in the budget detail worksheet and budget narrative."]
["Indirect Costs","Indirect costs are allowed only if:  a) the applicant has a current, federally approved indirect cost rate; or b) the applicant is eligible to use and elects to use the “de minimis” indirect cost rate described in 2 C.F.R. 200.414(f).  (See paragraph D.1.b. in Appendix VII to Part 200—States and Local Government and Indian Tribe Indirect Cost Proposals for a description of entities that may not elect to use the “de minimis” rate.)  An applicant with a current, federally approved indirect cost rate must attach a  copy of the rate approval, (a fully-executed, negotiated agreement.  If the applicant does not have an approved rate, one can be requested by contacting the applicant’s cognizant Federal agency, which will review all documentation and approve a rate for the applicant organization, or if the applicant’s accounting system permits, costs may be allocated in the direct costs categories.  (Applicant Indian tribal governments, in particular, should review Appendix VII to Part 200—States and Local Government and Indian Tribe Indirect Cost Proposals regarding submission and documentation of indirect cost proposals.)  Narrative for any indirect costs should clearly state which direct costs the indirect cost agreement is being applied to.  All requested information must be included in the budget detail worksheet and budget narrative.\nIn order to use the “de minimis” indirect rate an applicant would need to attach written documentation to the application that advises DOJ of both the applicant’s eligibility (to use the “de minimis” rate) and its election. If the applicant elects the de minimis method, costs must be consistently charged as either indirect or direct costs, but may not be double charged or inconsistently charged as both. In addition, if this method is chosen then it must be used consistently for all federal awards until such time as the applicant entity chooses to negotiate a federally approved indirect cost rate.\n"]
["Subawards (Subgrants), \nProcurement Contracts, &\nConsultant Fees","Subawards:  Provide a description of the Federal award activities proposed to be carried out by any subrecipient and an estimate of the cost (include the cost per subrecipient, to the extent known prior to application submission).  For each subrecipient, enter the subrecipient entity name, if known.  Please indicate any subaward information included under budget category Subawards (Subgrants)/Procurement Contracts by including the label “(subaward)” with each subaward entry.\n\nProcurement contracts: Provide a description of the product or service to be procured by contract and an estimate of the cost.  Indicate whether the applicant’s formal, written Procurement Policy or the Federal Acquisition Regulation is followed.  Applicants are encouraged to promote free and open competition in awarding procurement contracts.  A separate justification must be provided for sole source procurements in excess of the Simplified Acquisition Threshold set in accordance with 41 U.S.C. 1908 (currently set at $150,000).\n\nConsultant Fees:  For each consultant enter the name, if known, service to be provided, hourly or daily fee (8-hour day), and estimated time on the project.  Consultant fees in excess of the DOJ grant-making component’s maximum rate for an 8-hour day (currently $650) require additional justification and prior approval from the respective DOJ grant-making component.  All requested information must be included in the budget detail worksheet and budget narrative.\n"]
["Travel","Travel directly related to the purpose of the grant. In-state travel costs associated with the grant shall include mileage rates not to exceed $0.62 per mile, as well as the actual costs of tolls and parking. Note that 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."]
["Equipment","List non-expendable items that are to be purchased (Note: Organization's own capitalization policy for classification of equipment should be used). Expendable items should be included in the \"Supplies\" category. Applicants should analyze the cost benefits of purchasing versus leasing equipment, especially high cost items and those subject to rapid technological advances.In the budget narrative, explain how the equipment is necessary for the success of the project, and describe the procurement method to be used. All requested information must be included in the budget detail worksheet and budget narrative."]
["Supplies","List items by type (office supplies, postage, training materials, copy paper, and expendable equipment items costing less than $5,000, such as books, hand held tape recorders) and show the basis for computation. Generally, supplies include any materials that are expendable or consumed during the course of the project. All requested information must be included in the budget detail worksheet and budget narrative."]
["Other Costs","List items (e.g., rent, reproduction, telephone, janitorial or security services, and investigative or confidential funds) by type and the basis of the computation. For example, provide the square footage and the cost per square foot for rent, or provide a monthly rental cost and how many months to rent. All requested information must be included in the budget detail worksheet and budget narrative."]