Loading...
HomeMy WebLinkAbout19-56 Unsigned Resolution No. 19-56 be. oesuA RESOLUTION AUTHORIZING ACCEPTANCE OF ILLINOIS DEPARTMENT OF TRANSPORTATION SUSTAINED TRAFFIC ENFORCEMENT PROGRAM (STEP) GRANT AND AUTHORIZING THE EXECUTION OF A GRANT AGREEMENT AMENDMENT (Agreement No. OP-19-0140) BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF ELGIN,ILLINOIS,that the City of Elgin,Illinois hereby accepts the Illinois Department of Transportation Sustained Traffic Enforcement Program (STEP) grant in the amount of $14,600.00 for occupant protection and impaired driving enforcement. BE IT FURTHER RESOLVED BY THE CITY COUNCIL OF THE CITY OF ELGIN, ILLINOIS, that Richard G. Kozal, City Manager, and Kimberly A. Dewis, City Clerk, be and are hereby authorized and directed to execute a grant agreement amendment with Illinois Department of Transportation regarding the Sustained Traffic Enforcement Program (STEP), a copy of which is attached hereto and made a part hereof by reference. s/David J. Kaptain David J. Kaptain, Mayor Presented: April 10, 2019 Adopted: April 10, 2019 Vote: Yeas: 8 Nays: 0 Attest: s/Kimberly Dewis Kimberly Dewis, City Clerk Illinois Department P Distracted Driving Attachment p.:,;, of Transportation Email. NOFO# 19-0343-03 Applicant Agency Name Elgin Police Department Personnel(Salaries&Wages)Budget Distracted Driving.Enforcement Distracted Driving Crackdown Officer Hireback Total Campaign Breakdown Distracted Driving Crackdown(April 1-30, 2019) Distracted Driving #of officers #of hours #of details Total Hours Overtime Rate Total Campaign Budget Daytime 4 2 20 160 $73.00 $11,680.00 Nighttime 4 2 5 40 $73.00 $2,920.00 Indirect Costs Total Indirect Costs from Line 17 of Page 1 of 23 on the Budget Template Total $14,600.00 FY 2019 Distracted Driving Grant Enforcement Campaign Dates Paid Advertising Potential Kickoff Post Enforcement Grant Data Campaign Campaign Press Release Enforcement Media Release Collection Form Dates Due Distracted Driving Yes March 26-29, 2019 April 1-30, 2019 May 1-3, 2019 May 14, 2019 Awareness Month Internal Use Only Project Number Received By OP-19-0140 Printed 03/13/19 BSPE 311 (Rev 10/31/18) Illinois Uniform Intergovernmental o, Departm�t of Transportation Agreement Amendment o.:.: 1 FOR THE AGREEMENT City of Eigin OP-19-0140 The undersigned GRANTOR and GRANTEE (the PARTIES) agree that the following AMENDMENT shall amend the AGREEMENT referenced herein.All terms and conditions set forth in the original AGREEMENT, not amended herein,shall remain in full force and effect as written. In the event of conflict, the terms of this AMENDMENT shall prevail. This AMENDMENT is in the best interest of the State of Illinois and is authorized by law and Article 26.5 of the AGREEMENT. 1. Description Of Agreement Increased hire back hours for law enforcement agencies during the Distracted Driving enforcement campaign to • maximize the effect of traffic enforcement. 2. Effective Date Of Amendment AMENDMENT is effective from April 1-30, 2019. 3. Description Of Amendment This Amendment is to increase the Grantee's funding by an additional $14,600.00 for officer hire back hours. The current Agreement (OP-19-0140) is for the period of 10/01/18 to 09/30/19 for an estimated contract amount of $116,208.00. Once this Amendment is executed, the total Agreement amount will be $130,808.00. 4.Attachments and Incorporations Choose the appropriate attachment clause No Attachments applicable to this Amendment ®The following Attachments are hereby incorporated and made part of this Amendment Attachment A is incorporated and made part of this Amendment IN WITNESS WHEREOF,the parties have caused this AGREEMENT AMENDMENT to be executed on the dates shown below by representatives authorized to bind the respective parties. Printed 03/26/19 Page 1 of 3 BoBS 2806(Rev.01/07/19) FOR THE GRANTEE Si ure of the Authorized Representative 4 Printed Name&Title of the Authorized Representative Date ___ Rick Kozel, City Manager April 10,2019 Governmental Body _ Legal Address - City of Elgin 151 Dexter Ct City State Zip Attn Email Elgin IL 60120 Rick Kozel % kozal_r@cityofelgin.org FOR THE GRANTOR ATTEST: �L��G'�'—('-� Check One: City Clerk ® The amendment is under$250,0_00. Only the Director and/or Secretary's signatures are required and may be delegated. LI The amendment is over$250 ODD. All signatures below are required and cannot be delegated. Paul A.Loete,Director Date Matt Magalis,Acting Secretary of Transportation Date Office of Highways PI/Chief Engineer By By Printed Name I Printed Name Printed Title _ Printed Title L Philip C.Kaufmann,Chief Counsel Date Joanne Woodworth,Acting Chief Fiscal Officer Date (Approved as to form) Printed 03/26/19 Page 2 of 3 BoBS 2806(Rev.01/07/19) Attachment A [Describe which Exhibit(s)of the UIGA is(are)being amended]of the original AGREEMENT is to include the following: The original Agreement is amended to add funding for Personnel for additional officer hire back hours that correspond to the Distracted Driving enforcement campaign (April 1-30, 2019). Section 1.2 of the Agreement is amended as follows to reflect the addition of funding: "are estimated to be $130,808.00 of which $130,808.00 are federal funds." EXHIBIT C PAYMENT of the Agreement is amended as follows to reflect the addition of funding: "Grantee will be reimbursed for the amount spent under this Agreement. The Agreement will be amended for$14,600.00 in additional funding for the Distracted Driving enforcement campaign." Performance Measures The Grantee shall: I. Grantee shall increase the number of distracted driving citations issued through officer hire back (overtime) enforcement details from April 1-30, 2019. The Grantee shall submit this information via BSPE 205 form Local/ State Mobilizations Data Collection, to the Grantor no later than 5 P.M. on Tuesday, May 14, 2019. The BSPE 205 form shall be submitted electronically to DOT.BSPEDATA@illinois.gov. Performance Standards Performance Standards shall include: I. A minimum of two traffic citations for every 60 minutes of patrol. Il. 50% of traffic citations must be Distracted Driving violations. III. Timeliness of corrective actions will be determined on a case-by-case basis dependent on the urgency to which any issues need to be addressed. This may be determined by the Grantor, the assigned Grantor contact listed in Exhibit D of the STEP Agreement, any authorized agent of the Grantor, a third party retained by the Grantor, or coordination between the Grantor and the Grantee. a. The Grantee shall generate and maintain invoices, implementation plan documents and materials and all other related documents including but not limited to email and mail correspondence in addition to other materials as listed in this Agreement. b. The Grantee shall file accurate documentation to be compliant with Exhibits B and E in their STEP Agreement. Reimbursement Agencies are required to submit one separate Distracted Driving claim for reimbursement (BSPE 500) for the entire month of April 2019. Printed 03/26/19 Page 3 of 3 BoBS 2806(Rev 01/07/19) ,.N:;,:,....,„$:A, State of Illinois UNIFORM GRANT BUDGET TEMPLATE This form is used to apply to individual State of Illinois discretionary grant programs. Applicants should submit budgets based upon the total estimated costs for the project including all funding sources. Pay attention to applicable program specific instructions, if attached. The applicant organization should refer to 2 CFR 200, "Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards"cited within these instructions. You must consult with your Business Office prior to submitting this form for any award restrictions, limitations or requirements when filling out the narrative and Uniform Budget Template. Section A — Budget Summary STATE OF ILLINOIS FUNDS All applicants must complete Section A and provide a break-down by the applicable budget categories shown in lines 1-17. Eligible applicants requesting funding for only one year should complete the column under"Year 1." Eligible applicants requesting funding for multi-year grants should complete all applicable columns. Please read all instructions before completing form. STATE OF ILLINOIS GRANT FUNDS Provide a total requested State of Illinois Grant amount for each year in the Revenue portion of Section A. The amount entered in Line (a) will equal the total amount budgeted on Line 18 of Section A. BUDGET SUMMARY—STATE OF ILLINOIS FUNDS All applicants must complete Section A and provide a break-down by the applicable budget categories shown in lines 1-17. Line 18: Show the total budget request for each fiscal year for which funding is requested. Please use detail worksheet and narrative section for further descriptions and explanations of budgetary line items. Section A (continued) Indirect Cost Information: (This information should be completed by the applicant's Business Office). If the applicant is requesting reimbursement for indirect costs on line 17, the applicant's Business Office must select one of the options listed on the Indirect Cost Information page under Section-A Indirect Cost Information (1-4). Option (1): The applicant has a Negotiated Indirect Cost Rate Agreement (NICRA) that was approved by the Federal government. A copy of this agreement must be provided to the State of Illinois' Indirect Cost Unit for review and documentation. This NICRA will be accepted by all State of Illinois Agencies up to any statutory, rule- based or programmatic restrictions or limitations. If this option is selected by the applicant, basic information is required for completion of this section. See bottom of "Section-A Indirect Cost Information". NOTE: The applicant may not have a Federally Negotiated Indirect Cost Rate Agreement. Therefore, in order for the applicant to be reimbursed for Indirect Costs from the State of Illinois, the applicant must either: A) Negotiate an Indirect Cost Rate with the State of Illinois' Indirect Cost Unit with guidance from our State Cognizant Agency on an annual basis. B) Elect to use the de minimis rate of 10% modified total direct cost(MTDC)which may be used indefinitely on State of Illinois Awards. C) Use a Restricted Rate designated by programmatic statutory policy. (See Notice of Funding Opportunity for Restricted Rate Programs). GOMBGATU-3002-(R-02-17) - ' '"� State of Illinois UNIFORM GRANT BUDGET TEMPLATE Section A -- Budget Summary (continued) Option (2a): The applicant currently has a Negotiated Indirect Cost Rate Agreement with the State of Illinois that will be accepted by all State of Illinois Agencies up to any statutory, rule-based or programmatic restrictions or limitations. The applicant is required to submit a new Indirect Cost Rate Proposal to the Indirect Cost Unit within six (6) months after the close of each fiscal year (2 CFR 200 Appendix IV (C)(2)(c). Note: If this option is selected by the applicant, basic information is required for completion of this section. See bottom of"Section-A Indirect Cost Information". Option (2b): The applicant currently does not have a Negotiated Indirect Cost Rate Agreement with the State of Illinois. The applicant must submit its initial Indirect Cost Rate Proposal (ICRP) immediately after the applicant is advised that the State award will be made and, in no event, later than three (3) months after the effective date of the State award (2 CFR 200 Appendix IV (C)(2)(b). The initial ICRP will be sent to the State of Illinois' Indirect Cost Unit. Note: The applicant should check with the State of Illinois awarding Agency for information regarding reimbursement of indirect costs while its proposal is being negotiated. Option (3): The applicant elects to charge the de minimis rate of 10% modified total direct cost(MTDC) which may be used indefinitely on State of Illinois awards (2 CFR 200.414 (c)(4)(f) & (200.68). Note: (The applicant must be eligible, see 2 CFR 200.414 (f), and submit documentation on the calculation of MTDC within your Budget Narrative under Indirect Costs.) Option (4): If you are applying for a grant under a Restricted Rate Program, indicate whether you are using a restricted indirect cost rate that is included on your approved Indirect Cost Rate Agreement, or whether you are using a restricted indirect cost rate that complies with statutory or programmatic policies. Note: See Notice of State Award for Restricted Rate Programs. Section B — Budget Summary NON-STATE OF ILLINOIS FUNDS NON-STATE OF ILLINOIS FUNDS: If the applicant is required to provide or volunteers to provide cost-sharing or matching funds or other non-State of Illinois resources to the project, the applicant must provide a revenue breakdown of all Non-State of Illinois funds in lines (b)-(d). the total of "Non-State Funds" should equal the amount budgeted on Line 18 of Section B. If a match percentage is required, the amount should be entered in this section. BUDGET SUMMARY—NON-STATE OF ILLINOIS FUNDS If the applicant is required to provide or volunteers to provide ost-sharing or matching funds or other non-State of Illinois resources to the project, these costs should be shown for each applicable budget category on lines 1017 of Section B. Lines 1-17: For each project year,for which matching funds or other contributions are provided, show the total contribution for each applicable budget category. Line 18: Show the total matching or other contribution for each fiscal year. Please see detail worksheet and narrative section for further descriptions and explanations of budgetary line items. GOMBGATU-3002-(R-02-17) *, e. v'`^ State of Illinois UNIFORM GRANT BUDGET TEMPLATE ...yv Section C — Budget Worksheet & Narrative [Attach separate sheet(s)1 Pair attention so apoIicaPle program specific instructions, if attached. All applicants are required to submit a budget narrative along with Section A and Section B. The budget narrative is sometimes referred to as the budget justification. The narrative serves two purposes: it explains how the costs were estimated and it justifies the need for the cost. The narrative may include tables for clarification purposes. The State of Illinois recommends using the State of Illinois Uniform Budget Template worksheet and narrative guide provided. 1. Provide an itemized budget breakdown, and justification by project year,for each budget category listed in Sections A and B. 2. For non-State of Illinois funds or resources listed in Section B that are used to meet a cost-sharing or matching requirement or provided as a voluntary cost- sharing or matching commitment, you must include: a. The specific costs or contributions by budget category; b. The source of the costs or contributions; and c. In the case of third-party in-kind contributions, a description of how the value was determined for the donated or contributed goods or services. [Please review cost sharing and matching regulations found in 2 CFR 200.306.] 3. If applicable to this program, provide the rate and base on which fringe benefits are calculated. 4. If the applicant is requesting reimbursement for indirect costs on line 17, this information should be completed by the applicant's Business Office. Specify the estimated amount of the base to which the indirect cost rate is applied and the total indirect expense. Depending on the grant program to which the applicant is applying and/or the applicant's approved Indirect Cost Rate Agreement, some direct cost budget categories in the applicant's grant application budget may not be included in the base and multiplied by your indirect cost rate. Please indicate which costs are included and which costs are excluded from the base to which the indirect cost rate is applied. 5. Provide other explanations or comments you deem necessary. GOMBGATU-3002-(R-02-17) 4e, ` State of Illinois UNIFORM GRANT BUDGET TEMPLATE Keep in mind the following— Although the degree of specificity of any budget will vary depending on the nature of the project and State of Illinois agency requirements, a complete, well-thought-out budget serves to reinforce your credibility and increase the likelihood of your proposal being funded. ■ A well-prepared budget should be reasonable and demonstrate that the funds being asked for will be used wisely. ■ The budget should be as concrete and specific as possible in its estimates. Make every effort to be realistic,to estimate costs accurately. ■ The budget format should be as clear as possible. It should begin with a budget narrative, which you should write after the entire budget has been prepared. • Each section of the budget should be in outline form, listing line items under major headings and subheadings. • Each of the major components should be subtotaled with a grand total at the end. Your budget should justify all expenses and be consistent with the program narrative: • Salaries should be comparable to those within the applicant organization. • If new staff is being hired, additional space and equipment are considered, as necessary. • If the budget lists an equipment purchase, it is the type allowed by the agency. • If additional space is rented, the increase in insurance is supported. a If an indirect cost rate applies to the proposal, the division between direct and indirect costs is not in conflict, and the aggregate budget totals refer directly to the approved formula. Indirect costs are costs that are not readily assignable to a particular project, but are necessary to the operation of the organization and the performance of the project(like the cost of operating and maintaining facilities, depreciation, and administrative salaries). §200.308 Revision of budget and program plans (e) The Federal/State awarding agency may, at its option, restrict the transfer of funds among direct cost categories or programs, functions and activities for Federal/State awards in which the Federal/State share of the project exceeds the Simplified Acquisition Threshold and the cumulative amount of such transfers exceeds or is expected to exceed 10 percent or $1,000 per detail line item, whichever is greater of the total budget as last approved by the Federal/State awarding agency. The Federal/State awarding agency cannot permit a transfer that would cause any Federal/State appropriation to be used for purposes other than those consistent with the appropriation. GOMBGATU-3002-(R-02-17) State of Illinois UNIFORM GRANT BUDGET TEMPLATE State Agency: Illinois Department of Transportation Organization Name:City of Elgin Notice of Funding 19-0343-02 Data Universal Number System (DUNS) Number(enter numbers only) : 010224772 Opportunity (NOFO) Number: Catalog of State Financial Assistance (CSFA) Number:1494-10-0343 CSFA Short Description:State &Comm. Hwy. Safety/Ntl. Priority Safety Programs Section A: State of Illinois Funds Fiscal Year:FFY19 REVENUES Total Revenue State of Illinois Grant Requested $ 130,808.00 Budget Expenditure Categories i OMB Uniform Guidance Total Expenditures Federal Awards Reference 2 CFR 200 , 1. Personnel(Salary and Wages) 200.430 $ 130,808.00 12. Fringe Benefits 200.431 $ 3. Travel 200.474 $ 4. Equipment 200.439 ( $ 5. Supplies 200.94 $ 6. Contractual Services and Subawards 200.318&200.92 $ 7. Consultant(Professional Service) 200.459 $ 18. Construction $ j 9. Occupancy(Rent and Utilities) 200.465 $ 10. Research and Development(R&D) 200.87 $ 11. Telecommunications $ 12. Training and Education 200.472 $ 13. Direct Administrative Costs 200.413 (c) $ 14. Miscellaneous Costs ' S 15.A. Grant Exclusive Line Item(s) $ i 15. B. Grant Exclusive Line Item(s) 16. Total Direct Costs (add lines 1-15) 200.413 $ 130,808.001 17. Total Indirect Costs 200.414 $ Rate%. Base i ( Instructions 18.Total Costs State Grant Funds found at end of (Lines 16 and 17) $ 130,808.00 document. MUST EQUAL REVENUE TOTALS ABOVE GOMBGATU-3002-(R-02-17) Page 1 of 23 State of Illinois UNIFORM GRANT BUDGET TEMPLATE Organization Name:City of Elgin NOFO Number:19-0343-02 SECTION A -Continued -Indirect Cost Rate Information If your organization is requesting reimbursement for indirect costs on line 17 of the Budget Summary, please select one of the following options 1. Our Organization receives direct Federal funding and currently has a Negotiated Indirect Cost Rate Agreement (NICRA)with our Federal Cognizant Agency. A copy of this agreement will be provided to the State of Illinois' Indirect Cost Unit for review and documentation before reimbursement is 1-1 allowed. This NICRA will be accepted by all State of Illinois agencies up to any statutory, rule-based or programmatic restrictions or limitations. NOTE: (If this option is selected, please, provide basic Negotiated Indirect Cost Rate Agreement in area designated below.) Your organization may not have a Federally Negotiated Cost Rate Agreement. Therefore, in order for your organization to be reimbursed for the Indirect Costs from the State of Illinois your organization must either: a. Negotiate an Indirect Cost Rate with the State of Illinois'Indirect Cost Unit with guidance from your State Cognizant Agency on an annual basis; b. Elect to use the de minimis rate of 10% modified for total direct costs (MTDC)which may be used indefinitely on State of Illinois awards; or c. Use a Restricted Rate designated by programmatic or statutory policy (see Notice of Funding Opportunity for Restricted Rate Programs). 2a. Our Organizations currently has a Negotiated Indirect Cost Rate Agreement (NICRA) with the State of Illinois that will be accepted by all State o —, Illinois agencies up to any statutory, rule-based or programmatic restrictions or limitations. Our Organization is required to submit a new Indirect Cost Rate Proposal to the Indirect Cost Unit within 6 months after the close of each fiscal year [2 CFR 200, Appendix IV(C)(2)(c)]. NOTE: (If this option is selected, please provide basic Indirect Cost Rate information in area designated below.) 2b. Our Organization currently does not have a Negotiated Indirect Cost Rate Agreement (NICRA) with the State of Illinois. Our organization will submit our initial Indirect Cost Rate Proposal (ICRP) immediately after our Organization is advised that the State award will be made no later than three (3) months after the effective date of the State award [2 CFR 200 Appendix (C)(2)(b)]. The initial ICRP will be sent to the State of Illinois Indirect Cost unit. Note: (Check with you State of Illinois Agency for information regarding reimbursement of indirect costs while your proposal is being negotiated.) 3. Our Organization has never received a Negotiated Indirect Cost Rate Agreement from either the Federal government or the State or Illinois and --I elects to charge the de minimis rate of 10% modified total direct cost(MTDC)which may be used indefinitely on State of Illinois awards[2 CFR 200.414 (C)(4)(f) and 200.68.] [Note: Your Organization must be eligible,see 2 CFR 200.414(f), and submit documentation on the calculation of MTDC within your Budget Narrative under Indirect Costs.] 4. For Restricted Rate Programs, our Organization is using a restricted indirect cost rate that: Lis included as a "Special Indirect Cost Rate"in the NICRA, pursuant to 2 CFR 200 Appendix IV(5); or ❑complies with other statutory policies. The Restricted Indirect Cost Rate is: ® 5. No reimbursement of Indirect Cost is being requested. (Please consult your program office regarding possible match requirements.) Basic Negotiated Indirect Cost Rate Information (Use only if option 1 or 2(a), above is selected.) Period Covered by NICRA: From: To: j Approving Federal or State Agency: Indirect Cost Rate: % The Distribution Base Is: GOMBGATU-3002-(R-02-17) Page 2 of 23 State of Illinois ►-"; UNIFORM GRANT BUDGET TEMPLATE Organization Name:City of Elgin NOFO Number: 19-0343-02 Section B: Non-State of Illinois Funds Fiscal Year: FFY19 REVENUES Total Revenue Grantee Match Requirement% (Agency to Populate) b) Cash $ c) Non-Cash ! $ d) other Funding and Contributions $ Total Non-State Funds (lined b through d) ' $ OMB Uniform Guidance Budget Expenditure Categories Federal Awards Reference 2 CFR 200 Total Expenditures 1. Personnel (Salaries and Wages) 200.430 $ 12. Fringe Benefits 200.431 $ i3. Travel 200.474 $ 4. Equipment 200.439 $ 5. Supplies 200.94 $ 6. Contractual Services and Subawards 200.318 &200.92 $ 7. Consultant(Professional Services) 200.459 $ 18. Construction $ I 9. Occupancy (Rent and Utilities) 200.465 $ 10. Research and Development(R&D( 200.87 $ _ 11. Telecommunications • i $ 12. Training and Education 200.472 13. Direct Administrative Costs 200.413 (c) $ I 14. Miscellaneous Costs $ '15. A. Grant Exclusive Line Item(s) $ '15. B. Grant Exclusive Line Item(s) $ 16. Total Direct Costs (add lines 1-15) 200.413 ! $ 17. Total indirect Costs 200.414 $ Rate %: Base: 118. Total Costs State Grant Funds (Lines 16 and 17) $ MUST EQUAL REVENUE TOTALS ABOVE GOMBGATU-3002-(R-02-17) Page 3 of 23 " ,w... State of Illinois r UNIFORM GRANT BUDGET TEMPLATE Organization Name:City of Elgin NOFO Number:19-0343-02 Data Universal Number System (DUNS) Number(enter numbers only) : 010224772 Fiscal Year:FFY19 Catalog of State Financial Assistance(CSFA) Number: 494-10-0343 CSFA Short Description:State& Comm. Hwy. Safety/Ntl. Priority Safety Programs By signing this report, I certify to the best of my knowledge and belief that the report is true, complete and accurate and that any false, fictitious or fraudulent information or the omission of any material fact could result in the immediate termination of my grant award(s). City of Elgin City of Elgin Institution/Organization Name: Institution/Organization Name: Chief Financial Officer City Manager Title(Chief Financial Officer or equivalent): Title(Executive Director or equivalent): Debra Nawrocki Rick Kozel Printed Name (Chief Financial Officer or equivalent): Printed Name (Executive Director or equivalent): ie6Ititi IMP tog Signature(Chief Financial Officer or equivalent): Sigiature(Executive Di -er, or eq -t): April 10, 2019 April 10,2019 1 Date of Execution (Chief Financial Officer): Date of Execution(Executive Director): Note: The State Awarding Agency may change required signers based on the grantee's organizational structure. The required signers must have the authority to enter onto contractual agreements on the behalf of the organization. GOMBGATU-3002-(R-02-17) Page 4 of 23 4',4t,477- �.o State of Illinois UNIFORM GRANT BUDGET TEMPLATE FFATA Data Collection Form(if needed by agency) Under FFATA, all sub-recipients who receive$30,000 or more must provide the following information for federal reporting. Please fill out the following form accurately and completely. 4-digit extension if applicable: Sub-recipient DUNS: 010224772 Sub-recipient Parent Company DUNS: Sub-recipient Name: City of Elgin Sub-recipient DBA Name: Elgin Police Department Sub-recipient Street Address: 150 Dexter Ct City: Elgin State: II Zip-Code:60120-5503 Congressional District: 6th Congressional Sub-recipient Principal Place of Performance: City of Elgin City: Elgin State: II Zip-Code:60120-5503 Congressional District: 6th Congressional Contract Number(if known): Award Amount: I Project Period: From: Project Period: To: OP-19-0140 $130,808.00 Oct 1, 2018 Sep 30, 2019 State of Illinois Awarding Agency and Project Detail Description: IDOT STEP Grant Under certain circumstances,sub-recipient must provide names and total compensation of its top 5 highly compensated officials. Please answer the following questions and follow the instructions. 41. In your business or organization's previous fiscal year, did your business or organization (including parent organization, all branches and affiliates worldwide) receive (1) 80% or more of your annual gross revenues in U.S. federal contracts, subcontracts, loans, grants, subgrants and/or cooperative agreements and (2) $25,000,000 or more in annual gross revenue from U.S.federal contracts, subcontracts, loans, grants, subgrants and/or cooperative agreements? Yes ® If Yes, must answer Q2 below. No I I If No,you are not required to provide data. Q2. Does the public have access to information about the compensation of the senior executives in your business or organization (including parent organization, all branches and all affiliates worldwide)through periodic reports filed under section 13(a)or 15(d)of the Security Exchange Act of 1934(5 U.S.C. 78m(a), 78o(d))or section 6104 of the Internal Revenue code of 1986 (i.e., on IRS Form 990)? Yes Z No [ I If No, you must provide the data. Please fill out the rest of this form. Please provide names and total compensation of the top five officials: Name Amount: Name. Amount: Name. Amount: Name: Amount: Name: Amount: GOMBGATU-3002-(R-02-17) Page 5 of 23 ', IState of Illinois �'' 1� UNIFORM GRANT BUDGET TEMPLATE 1). Personnel(Salaries and Wages) (2 CFR 200.430) 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 and length of time working on the project . Compensation paid for employees engaged in grant activities must be consistent with that paid for similar work within the applicant organization. Include a description of the responsibilities and duties of each position in relationship to fulfilling the project goals and objectives in the narrative space provided below. Also, provide a justification and description of each position (including vacant positions). Relate each position specifically to program objectives. Personnel cannot exceed 100% of their time on all active projects. Name Position Salary or Wage Basis % of Time Length of Time Personnel Cost Add/Delete (Yr./Mo.1Hr.) Row Hire Back Officers $72.00 Hourly 100 % 1,614 $116,208.00 Add Delete Hire Back Officers $73.00 Hourly 100 % 200 $14,600.00 Add l Delete State Total $130,808.00 fa Add Vo =Delete.. NON-State Total Total Personnel $130,808.00 Personnel Narrative(State): Police Officers to work grant funded hire back patrols not to exceed$166,208.00, Police Officers to work grant funded Distracted Driving hire back patrols not to exceed$14,600.00. Personnel Narrative(Non-State): (i.e. "Match"or"Other Funding") l GOMBGATU-3002-(R-02-17) Page 6 of 23 • ,r State of Illinois I,; ' i UNIFORM GRANT BUDGET TEMPLATE 2). Fringe Benefits (2 CFR 200.431) Fringe benefits should be based on actual known costs or an established formula. Fringe benefits are for the personnel listed in category(1) direct salaries and wages, and only for the percentage of time devoted to the project. Provide the fringe benefit rate used and a clear description of how the computation of fringe benefits was done. Provide both the annual (for multiyear awards) and total. If a fringe benefit rate is not used, show how the fringe benefits were computed for each position. The budget justification should be reflected in the budget description. Elements that comprise fringe benefits should be indicated. I Name Position(s) Base Rate(%) Fringe Benefit Add/Delete Cost Rows I State Total &�-r....._r11 Non-State Total 1Total Fringe Benefits Fringe Benefits Narrative (State): Fringe Benefits Narrative (Non-State): (i.e. "Match"or"Other Funding") GOMBGATU-3002-(R-02-17) Page 7 of 23 State of Illinois UNIFORM GRANT BUDGET TEMPLATE 3). Travel (2 CFR 200.474) Travel should include: origin and destination, estimated costs and type of transportation, number of travelers, related lodging and per diem costs, brief description of the travel involved, its purpose, and explanation of how the proposed travel is necessary for successful completion of the project. In training projects, travel and meals for trainees should be listed separately. Show the number of trainees and unit cost involved. Identify the location of travel, if known; or if unknown, indicate "location to be determined." Indicate source of Travel Policies applied, Applicant or State of Illinois Travel Regulations. NOTE: Dollars requested in the travel category should be for staff travel only. Travel for consultants should be shown in the consultant category along with the consultant's fee. Travel for training participants, advisory committees, review panels and etc., should be itemized the same way as indicated above and placed in the"Miscellaneous"category. Purpose of Travel/Items Location Cost Rate Basis Quantity Number of Trips Travel Cost Add/Delete Row Pagl State Total �r r NON-State Total Total Travel Travel Narrative(State): Travel Narrative(Non-State): (i.e..e"Match"of"Other Funding) GOMBGATU-3002-(R-02-17) Page 8 of 23 ' c-A-4 ;.; State of Illinois - UNIFORM GRANT BUDGET TEMPLATE 4). Equipment(2 CFR 200.439) Provide justification for the use of each item and relate them to specific program objectives. Provide both the annual (for multiyear awards) and total for equipment. Equipment is defined as an article of tangible personal property that has a useful life of more than one year and a per-unit acquisition cost which equals or exceeds the lesser of the capitalization level established by the non-Federal entity for financial statement purposes, or $5,000. An applicant organization may classify equipment at a lower dollar value but cannot classify it higher than $5,000. (Note_Organization's own capitalization policy for classification ofequjprpeit_can be_tksed1., Applicants should analyze the cost benefits of purchasing versus leasing equipment, especially high cost items and those subject to rapid technical advances. Rented or leased equipment costs should be listed in the"Contractual" category. Explain how the equipment is necessary for the success of the project. Attach a narrative describing the procurement method to be used. I, • Item Quantity Cost Per Item Equipment Add/Delete Cost Rows Add Delete I � State Total Add .Delete. Non-State Total Total Equipment Equipment Narrative (State): i Equipment Narrative (Non-State): (i.e. "Match"or"Other Funding") GOMBGATU-3002-(R-02-17) Page 9 of 23 State of Illinois UNIFORM GRANT BUDGET TEMPLATE 5). Supplies (2 CFR 200.94) List items by type (office supplies, postage, training materials, copying paper, and other expendable items 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. • Item Quantity/Duration Cost Per Item Supplies Add/Delete Cost Rows -AdcrisV DelefeM State Total Add Delete Non-State Total Total Supplies Supplies Narrative(State)- Supplies Narrative(Non-State): (i.e. "Match" or"Other Funding") GOMBGATU-3002-(R-02-17) Page 10 of 23 State of Illinois . UNIFORM GRANT BUDGET TEMPLATE `4Xs:O, 6). Contractual Services (2 CFR 200.318) &Subawards (200.92) Provide a description of the product or service to be procured by contract and an estimate of the cost.Applicants are encouraged to promote free and open competition in awarding contracts. A separate justification must be provided for sole contracts in excess of$150,000 (See 2 CFR 200.88). NOTE : this budget category may include subawards. Provide separate budgets for each subaward or contract, regardless of the dollar value and indicate the basis for the cost estimates in the narrative. Describe products or services to be obtained and indicate the applicability or necessity of each to the project. Please also note the differences between subaward,contract,and contractor(vendor): 1) Subaward (200.92) means an award provided by a pass-through entity to a sub-recipient for the sub-recipient to carry out part of a Federal/State award, including a portion of the scope of work or objectives. It does not include payments to a contractor or payments to an individual that is a beneficiary of a Federal/State program. 2) Contract (200.22) means a legal instrument by which a non-Federal entity purchases property or services needed to carry out the project or program under a Federal award. The term as used in this part does not include a legal instrument, even if the non-Federal entity considers it a contract, when the substance of the transaction meets the definition of a Federal award or subaward. 3) "Vendor" or "Contractor" is generally a dealer, distributor or other seller that provides supplies, expendable materials, or data processing services in support of the project activities. Item Contractual Services Add/Delete Cost Rows State Total .11111 Non-State Total Total Contractual Services I Contractual Services Narrative (State): Contractual Services Narrative (Non-State): (i.e."Match"or"Other Funding") GOMBGATU-3002-(R-02-17) Page 11 of 23 State of Illinois UNIFORM GRANT BUDGET TEMPLATE 7).Consultant Services and Expenses (2 CFR 200.459) Consultant Services (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 Expenses: List all expenses to be paid from the grant to the individual consultant in addition to their fees (i.e., travel, meals, lodging, etc.) Consultant-- Indicate whether applicant's formal,written Procurement Policy or the Federal Acquisitions Policy is used. Consultant Services Add/Delete Consultant Services (Fees) I Services Provided Fee Basis Quantity (Fee)Cost Row State Total rrir' NON-State Total Total Consultant Services (Fees) i Consultant Services Narrative(State): Consultant Services Narrative (Non-State): Consultant Expenses- Items Location Cost Rate Basis Quantity Number of Consultant Expenses Add/Delete Trips Cost Row State Total I NON-State Total Total Consultant Expenses Consultant Expenses Narrative(State): Consultant Expenses Narrative(Non-State): (i.e. "Match"or"Other Funding") r GOMBGATU-3002-(R-02-17) Page 12 of 23 State of Illinois ` : UNIFORM GRANT BUDGET TEMPLATE 8). Construction Provide a description of the construction project and an estimate of the costs. As a rule, construction costs are not allowable unless with prior written approval. In some cases, minor repairs or renovations may be allowable. Consult with the program office before budgeting funds in this category. Estimated construction costs must be supported by documentation including drawings and estimates, formal bids, etc. As with all other costs, follow the specific requirements of the program, the terms and conditions of the award, and applicable regulations. Purpose Description of Work Construction Add/Delete Cost Rows State Total 1 ,:.' , Non-State Total Total Construction Construction Narrative(State): Construction Narrative(Non-State): (i.e. "Match" or"Other Funding") GOMBGATU-3002-(R-02-17) Page 13 of 23 4 ��F'- VState of Illinois `I I UNIFORM GRANT BUDGET TEMPLATE 9).Occupancy -Rent and Utilities (2 CFR 200.465) List items and descriptions by major type and the basis of the computation. Explain how rental and utility expenses are allocated for distribution as an expense to the program/service. For example, provide the square footage and the cost per square foot rent and utility, and provide a monthly rental and utility cost and how many months to rent. NOTE: This budgetary line item is to be used for direct program rent and utilities, all other indirect or administrative occupancy costs should be listed in the indirect expense section of the Budget worksheet and narrative. Maintenance and repair costs may be included here if directly allocated to program. Description Quantity Basis Cost Length of Time Occupancy Add/Delete Cost Row MittetiME State Total NON-State Total Total Occupancy-Rent and Utilities Occupancy-Rent and Utilities Narrative(State): Occupancy-Rent and Utilities Narrative(Non-State): (i.e."Match"or"Other Funding") GOMBGATU-3002-(R-02-17) Page 14 of 23 � s State of Illinois •' ` ` UNIFORM GRANT BUDGET TEMPLATE 10). Research & Development(R&D) (2 CFR 200.87) Definition: All research activities, both basic and applied, and all development activities that are performed by non-Federal entities directed toward the production of useful materials, devices, systems, or methods, including design and development of prototypes and processes. Provide a description of the research and development project and an estimate of the costs. Consult with the program office before budgeting funds in this category. Purpose Description of Work Research and Development Add/Delete Cost Rows Add Delete State Total Add Delete Non-State Total Total Research and Development Research and Development Narrative (State): Research and Development Narrative (Non-State): (i.e. "Match"or"Other Funding") GOMBGATU-3002-(R-02-17) Page 15 of 23 State of Illinois UNIFORM GRANT BUDGET TEMPLATE 11).Telecommunications List items and descriptions by major type and the basis of the computation. Explain how telecommunication expenses are allocated for distribution as an expense to the program/service. NOTE: This budgetary line item is to be used for direct program telecommunications, all other indirect or administrative telecommunication costs should be listed in the indirect expense section of the Budget worksheet and narrative. Description Quantity Basis Cost Length of Time Telecommunications Add/Delete Cost Row --_ Add ::Delete`" State Total Add --- DT1ete NON-State Total Total Telecommunications Telecommunications Narrative(State): Telecommunications Narrative (Non-State): (i.e."Match"or"Other Funding") GOMBGATU-3002-(R-02-17) Page 16 of 23 tAf State of Illinois UNIFORM GRANT BUDGET TEMPLATE 12).Training and Education (2 CFR 200.472) Describe the training and education cost associated with employee development. Include rental space for training(if required),training materials, speaker fees, substitute teacher fees, and any other applicable expenses related to the training.When training materials(pamphlets, notebooks, videos,and other various handouts)are ordered for specific training activities,these items should be itemized below. Description Quantity Basis Cost Length of Time Training and Add/Delete Education Cost Row aecState Total NON-State Total Total Training and Education [Training and Education Narrative(State): Training and Education Narrative(Non-State): (i.e. "Match"or"Other Funding") GOMBGATU-3002-(R-02-17) Page 17 of 23 s. State of Illinois r s UNIFORM GRANT BUDGET TEMPLATE 13). Direct Administrative Costs (2 CFR 200.413(c)) The salaries of administrative and clerical staff should normally be treated as indirect (FSA) costs. Direct charging of these costs may be appropriate only if all of the following conditions are met: (1)Administrative or clerical services are integral to a project or activity; (2) Individuals involved can be specifically identified with the project or activity; (3)Such costs are_explicitly included in the budget or have the prior written approvalsf_t e State awarding agency; and (4) The costs are not also recovered as indirect costs. Name Position Salary or Wage Basis % of Time Length of Time Direct Administrative Add/Delete (Yr./Mo./Hr.) Cost Row ok Add Delete State Total Add Delete NON-State Total Total Direct Administrative Costs Direct Administrative Costs Narrative(State): Direct Administrative Costs Narrative(Non-State): (i.e."Match"or"Other Funding") GOMBGATU-3002-(R-02-17) Page 18 of 23 �4Nru: �� '` ) State of Illinois .` , / UNIFORM GRANT BUDGET TEMPLATE 15). GRANT EXCLUSIVE LINE ITEM Grant Exclusive Line Item Description Costs directly related to the service or activity of the program that is an integral line item for budgetary purposes. To use this budgetary line item, an applicant must have Program approval. (Please cite reference per statute for unique costs directly related to the service or activity of the program). (Note: Use columns within table as needed for the item being reported. Leave blank those columns that are not applicable. This table does NOT auto-calculate each line. You must enter the line totals. The table will auto-calculate the State. Non-State, and Total Grant Exclusive Line Item amounts based on your line entries. The State, Non-State and Total Grant Exclusive Line Item amounts will NOT carry forward to the Budget Narrative Summary table. You will have to enter the State and Non-State Totals for ALL Grant Exclusive Line Items in the Budget Narrative Summary table. Use the "Add New Grant Exclusive Line Item"button below to add additional tables as needed.) Grant Exclusive Line ' Add/Delete Description Quantity Basis Cost Length of Time Item Cost i Row Add —Delete- State Total Add Delete NON-State Total Total Grant Exclusive Line Item Grant Exclusive Line Item Narrative (State) Grant Exclusive Line Item Narrative (Non-State): (i.e. "Match" or"Other Funding") Add New Grant Exclusive Line Item Delete Grant Exclusive Line Item GOMBGATU-3002-(R-02-17) Page 20 of 23 4�s State of Illinois UNIFORM GRANT BUDGET TEMPLATE 16). Indirect Cost(2 CFR 200.414) Provide the most recent indirect cost rate agreement information with the itemized budget. The applicable indirect cost rate(s) negotiated by the organization with the cognizant negotiating agency must be used in computing indirect costs (F&A) for a program budget. The amount for indirect costs should be calculated by applying the current negotiated indirect cost rate(s) to the approved base(s). After the amount of indirect costs is determined for the program, a breakdown of the indirect costs should be provided in the budget worksheet and narrative below. Description Base Rate Indirect Cost Add/Delete Rows • ,Add Delete State Total Add Delete Non-State Total Total Indirect Costs Indirect Costs Narrative (State). Indirect Costs Narrative (Non-State):GOMBGATU-3002-(R-02-17) Page 21 of 23 4itivCA� State of Illinois �� UNIFORM GRANT BUDGET TEMPLATE Budget Narrative Summary--When you have completed the budget worksheet, transfer the totals for each category to the spaces below to the uniform template provided (SECTION A& B). Verify the total costs and the total project costs. Indicate the amount of State requested funds and the amount of non-State funds that will support the project.. (Note: The State, Non-State, and Total cost amounts for each line item below are auto-filled based upon the entries in the preceding budget tables 1-14 and 16. The State and Non-State Total amounts from Table 15 above, Grant Exclusive Line Item(s), must be entered into this table by hand due to the possibility of there being more than one Grant Exclusive Line Item table. Once the Grant Exclusive Line Item(s) amounts are entered into this table,the State Request amount, Non-State Amount and the Total Project Costs will be calculated automatically. It is imperative that the summary tables be completed accurately for the Budget Narrative Summary to be accurate.) 1 Budget Category State Non-State Total 1. Personnel $130,808.00 $130,808.00 2. Fringe Benefits 3. Travel 4. Equipment 5. Supplies 6. Contractual Services 7. Consultant (Professional Services) 8. Construction 9. Occupancy(Rent and Utilities) 10. Research and Development (R & D) 11.Telecommunications 12.Training and Education 13. Direct Administrative Costs 14. Other or Miscellaneous Costs 15. GRANT EXCLUSIVE LINE ITEM(S) 16. Indirect Costs State Request $130.808.00, Non-State Amount TOTAL PROJECT COSTS $130,808.00 GOMBGATU-3002-(R-02-17) Page 22 of 23 :tet.•ser.: State of Illinois UNIFORM GRANT BUDGET TEMPLATE For State Use Only Grantee: City of Elgin Notice of Funding 19-0343-02 Data Universal Number System (DUNS) Number(enter numbers only) : 010224772 Opportunity(NOFO) Number: Catalog of State Financial Assistance (CSFA) Number:1494-10-0343 CSFA Short Description:1State & Comm. Hwy. Safety/Ntl. Priority Safety Programs Fiscal Year(s): FFY19 Initial Budget Request Amount: $116,208.00 Prior Written Approval for Expense Line Item: n/a Statutory Limits or Restrictions. n/a Checklist: n/a Final Budget Amount Approved: $116,208.00 Program Approval Name Program Approval Signature Date Fiscal &Administrative Approval Name Fiscal &Administrative Approval Signature Date Budget Revision Approved: $130,808.00 Adam Gabany Program Approval Name Program Approval Signature Date Cynthia L. Watters, P.E. Fiscal &Administrative Approval Signature Fiscal &Administrative Approval Signature Date 200.308 Revision of budget and program plans (e)The Federal/State awarding agency may, at its option, restrict the transfer of funds among direct cost categories or programs, functions and activities for Federal/State awards in which the Federal/State share of the project exceeds the Simplified Acquisition Threshold and the cumulative amount of such transfers exceeds or is expected to exceed 10 percent or $1,000 per detail line item, whichever is greater of the total budget as last approved by the Federal/State awarding agency. The Federal/State awarding agency cannot permit a transfer that would cause any Federal/State appropriation to be used for purposes other than those consistent with the appropriation. GOMBGATU-3002-(R-02-17) Page 23 of 23