Loading...
HomeMy WebLinkAboutApproved Documents - 11/1/2021 City Clerk Use Only Finance Committee Approval Date 11/1/2021 City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Airport Department to expend $ 3,206.50 plus est. shipping costs of $ 518.14 to pay for or purchase Two (2) Totes of Cryotech E-36 Liquid Runway De-Icer for upcoming 2021 / 2022 winter season. This purchase or expenditure is being made because: Chemical is used for limiting the formation of ice on aircraft movement and non-movement areas during the winter season. Vendor selected for this purchase: Cyrotech of Fort Madison, Iowa Bids or written quotes were taken on this purchase, as follows: F■ Bids or quotes were not taken on this purchase because: Cryotech is the industry standard & preferred supplier for this material for airport operators during the winter season for ice control on the airfields. Prior Committee Actions (Dates): N/A Please check the following box(es)as appropriate to describe the funding for this expense: F■ General Fund ❑ Road Use Tax ❑ Sewer F—] Sanitation EIBonds ❑ Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 010-29-7700-1371 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 120,000.00 and the current available balance is $ 74,777.34 Respectfully submitted, Keith Kaspari, Airport Director 10/15/21 N'Jq' 11/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) City Clerk Use Only Finance Committee Approval Date 11/1/2021 City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Airport Department to expend $ 3,508.00 plus est. shipping costs of $ to pay for or purchase annual maintenance on Airport back-up generator. This purchase or expenditure is being made because: regular maintenance is required to ensure generator is operational when needed. Vendor selected for this purchase: Altorfer Inc 0■ Bids or written quotes were taken on this purchase, as follows: Altorfer Inc, as the local Cat dealer, provided a written maintenance agreement, with the cost locked in for six years. ❑ Bids or quotes were not taken on this purchase because: Prior Committee Actions (Dates): Please check the following box(es)as appropriate to describe the funding for this expense: F■ General Fund ❑ Road Use Tax ❑ Sewer F—] Sanitation ElBonds ❑ Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 010-29-7700-1371 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 120,000.00 and the current available balance is $ 74,777.34 Respectfully submitted, Keith Kaspari 10/20/202111/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) City Clerk Use Only Finance Committee Approval Date 11/1/2021 City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Department to expend $ 24,276.71 plus est. shipping costs of $ to pay for or purchase This purchase or expenditure is being made because: Installation of cameras for West side parking ramp. Vendor selected for this purchase: RC Systems Radio Communications Bids or written quotes were taken on this purchase, as follows: F■ Bids or quotes were not taken on this purchase because: RC Systems were previous vendor- matching prices offered at Park Ave Ramp and City Hall. Prior Committee Actions (Dates): Please check the following box(es)as appropriate to describe the funding for this expense: ❑ General Fund ❑ Road Use Tax ❑ Sewer F—] Sanitation ❑- Bonds ❑ Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 417-22-7960-2180 &418-22-7960-2126 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ $200,000 $65,000.00 and the current available balance is $ $ 492.15 $65,000.00 Respectfully submitted, Greg Ahlhelm 10/20/2021 N".A.wiJ., 11/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) City Clerk Use Only Finance Committee Approval Date 11/1/2021 City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Central Garage Department to expend $ 3,525.25 plus est. shipping costs of $ 150.00 to pay for or purchase New transmission for Crime Lab vehicle This purchase or expenditure is being made because: To replace unrepairable transmission. (only vendor locally to provide this transmission) -Wrong dealer listed previously Vendor selected for this purchase: Rydell F■ Bids or written quotes were taken on this purchase, as follows: Rydell Chevrolet Waterloo, IA $2,525.25 Bids or quotes were not taken on this purchase because: Prior Committee Actions (Dates): $3,525.25 approved 9/20/21 -wrong dealer listed Please check the following box(es)as appropriate to describe the funding for this expense: F■ General Fund ❑ Road Use Tax ❑ Sewer 0■ Sanitation EIBonds ❑ Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 010-18-7950-1571 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 60,283.00 and the current available balance is $ 41,308.22 Respectfully submitted, Sandie Greco 10/20/2021 ' im.weaker 11/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) City Clerk Use Only Finance Committee Approval Date 11/1/2021 City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Fire Department to expend $ 3,590.37 plus est. shipping costs of $ 0.00 to pay for or purchase of furniture for the administrative secretary office This purchase or expenditure is being made because: To update furniture and filing storage in the administrative secretary office Vendor selected for this purchase: Storey Kenworthy F■ Bids or written quotes were taken on this purchase, as follows: Storey Kenworthy: $3,590.37 KLog: $3,685.67 Bids or quotes were not taken on this purchase because: Prior Committee Actions (Dates): Please check the following box(es)as appropriate to describe the funding for this expense: ❑ General Fund ❑ Road Use Tax ❑ Sewer F—] Sanitation ❑- Bonds ❑ Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 420-12-1400-2112 Fire-Equipment and Uniforms (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 50,000.00 and the current available balance is $ 18,093.79 Respectfully submitted, Pat Treloar 10-13-2021 I�iM- 11/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) City Clerk Use Only Finance Committee Approval Date 11/1/2021 City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Leisure Services Department to expend $ 10,000.00 plus est. shipping costs of $ NA to pay for or purchase On Media advertising for the Cedar Valley SportsPlex This purchase or expenditure is being made because: being able to advertise with On Media will help retain members and recruit new Vendor selected for this purchase: On Media (Mediacom Park, NY) Bids or written quotes were taken on this purchase, as follows: QBids or quotes were not taken on this purchase because: On Media is the advertising agency for Mediacom cable. Prior Committee Actions (Dates): Please check the following box(es)as appropriate to describe the funding for this expense: EIGeneral Fund EI Road Use Tax EI Sewer F—] Sanitation EI Bonds EI Federal/other grants F Other(specify) Hotel Motel Funds This expenditure is to be coded to the following budget line-item: 010-37-4105-1351 37HMT.SPLX22 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 10,000.00 and the current available balance is $ 10,000.00 Respectfully submitted, Paul Huting 10/07/2021 11/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) City Clerk Use Only Finance Committee Approval Date 11/1/2021 City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Leisure Services Department to expend $ 125.00/hr NTE 24,000 plus est. shipping costs of $ to pay for or purchase Snow/Ice removal including salt application as needed on newly constructed sidewalks, crosswalks, and recreational trails in the University Ave & Kimball Corridors. This purchase or expenditure is being made because: In-house crews can no longer keep up with the expanding list of properties and locations needing to be cleared throughout the City. Vendor selected for this purchase: Professional Lawn Care, Waterloo, IA Bids or written quotes were taken on this purchase, as follows: F■ Bids or quotes were not taken on this purchase because: Professional Lawn Care has agreed to honor their 2020-2021 bid price. We have struggled to garner interest from other qualified and capable bidders for this work. Prior Committee Actions (Dates): Please check the following box(es)as appropriate to describe the funding for this expense: F■ General Fund ❑ Road Use Tax ❑ Sewer F—] Sanitation ElBonds ❑ Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 010-37-4100-1390 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 200,500.00 and the current available balance is $ 128,611.22 Respectfully submitted, Paul Huting 10/20/2021We wed„ 11/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) City Clerk Use Only Finance Committee Approval Date 11/1/2021 City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Leisure Services Department to expend $ 4,047.15 plus est. shipping costs of $ to pay for or purchase Repair of John Deere 2653 Tee Mower including the replacement of the wiring harness, computer module, and a lift/lower solenoid. This purchase or expenditure is being made because: Unit is inoperable and will not run. Vendor selected for this purchase: Van Wall Equipment, Perry Iowa Bids or written quotes were taken on this purchase, as follows: F■ Bids or quotes were not taken on this purchase because: Van Wall is the only John Deere dealer allowed to sell and service the golf turf line of equipment in Iowa. Prior Committee Actions (Dates): Please check the following box(es)as appropriate to describe the funding for this expense: F■ General Fund ❑ Road Use Tax ❑ Sewer F—] Sanitation EIBonds ❑ Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 010-37-4120-1569 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 23,804.00 and the current available balance is $ 14,842.89 Respectfully submitted, Paul Huting 10-20-2021 N"�Ae W"S_ 11/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) City Clerk Use Only Finance Committee Approval Date 11/1/2021 City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Leisure Services Department to expend $ 28,876.05 plus est. shipping costs of $ to pay for or purchase Services to remove 103 additional tree stumps in city parks and along street right of ways. ADDITIONAL stumps were identified to be removed. This does NOT replace the approval for 113 stumps. This purchase or expenditure is being made because: Large work load in forestry has developed due to two vacancies in forestry. Vendor selected for this purchase: Tree Pros Waterloo IA Bids or written quotes were taken on this purchase, as follows: F■ Bids or quotes were not taken on this purchase because: Tree Pros agreed to honor the pricing on previous stump removal bid. And they have the capability to complete project if weather cooperates this fall. Prior Committee Actions (Dates): 10/4/2021 finance approved previous bid for 113 stumps.. Please check the following box(es)as appropriate to describe the funding for this expense: ❑ General Fund ❑ Road Use Tax ❑ Sewer F—] Sanitation ❑- Bonds ❑ Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 419-37-4100 2166 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 75,000.00 and the current available balance is $ 29,000.00 Respectfully submitted, Paul Huting 10/20/21 *'q.W.j_ 11/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) City Clerk Use Only Finance Committee 11/1/2021 Approval Date City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the MIS Department to expend $ 4,161.85 plus est. shipping costs of $ to pay for or purchase Backup and Recovery System maintenance renewal. This purchase or expenditure is being made because: This is maintenance and support of our backup and recovery systems (server backups). Vendor selected for this purchase: Bids or written quotes were taken on this purchase, as follows: F■ Bids or quotes were not taken on this purchase because: DLT Solutions LLC is the vendor for the system we utilize. Prior Committee Actions (Dates): Please check the following box(es)as appropriate to describe the funding for this expense: F■ General Fund ❑ Road Use Tax ❑ Sewer F—] Sanitation ElBonds ❑ Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 010-01-8220 1520 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 42,000.00 and the current available balance is $ 22,427.29 Respectfully submitted, Chris Youngblut 10/20/2021war 11/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) City Clerk Use Only Finance Committee Approval Date 11/1/2021 City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Planning Department to expend $ 3,170.00 plus est. shipping costs of $ 0.00 to pay for or purchase Field reconnaissance and limited historic research of South Waterloo Business Park This purchase or expenditure is being made because: The work is needed to recertify the South Waterloo Business Park with the State of Iowa Vendor selected for this purchase: Tallgrass Archaeology LLC Bids or written quotes were taken on this purchase, as follows: F■ Bids or quotes were not taken on this purchase because: This is a continuation of work Tallgrass had completed from the initial Certification process in 2015/2016. Prior Committee Actions (Dates): Please check the following box(es)as appropriate to describe the funding for this expense: ❑ General Fund ❑ Road Use Tax ❑ Sewer F—] Sanitation ElBonds ElFederal/other grants FEOther(specify) San Marnan TIF This expenditure is to be coded to the following budget line-item: 426-08-6205-2103 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 3,170.00 and the current available balance is $ 3,170.00 Respectfully submitted, Noel Anderson 10/2112' Yn; 9e wugw 11/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) City Clerk Use Only Finance Committee Approval Date 11/1/2021 City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Police Department to expend $ $41,921.28 plus est. shipping costs of $ 0 to pay for or purchase Annual software licenses agreement for the Police Department computers for Microsoft products: Professional, Windows Professional, Remote Desktop, and Core Cal license. This purchase or expenditure is being made because: This is an annual license renewal of Microsoft products for all the Police Department computers. Vendor selected for this purchase: Insight Public Sector Bids or written quotes were taken on this purchase, as follows: F■ Bids or quotes were not taken on this purchase because: Insight is the vendor who has the State of Iowa bid for Microsoft software and is the only company that can bid the software package the department needs for the enterprise agreement Prior Committee Actions (Dates): Please check the following box(es)as appropriate to describe the funding for this expense: ❑ General Fund ❑ Road Use Tax ❑ Sewer F—] Sanitation ❑- Bonds ❑ Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 419-11-1100-2106/420-11-1100-2106 PIS (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 80,000.00 / 70,000 and the current available balance is $ 11,974.02/ 70,000 Respectfully submitted, Matt McGeough, Police Captain 10/14/2021 11/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) City Clerk Use Only Finance Committee Approval Date 11/1/2021 City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Police Department to expend $ 2,813.74 plus est. shipping costs of $ 0 to pay for or purchase Replace police uniform patches on all department worn uniforms. This purchase or expenditure is being made because: Replacement and removal of second batch of patches on all department uniforms. Vendor selected for this purchase: Carpenters Uniform (Galls) ❑ Bids or written quotes were taken on this purchase, as follows: Q Bids or quotes were not taken on this purchase because: Galls was awarded the previous bid for this project and this is a continuation of the patch re-branding project. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: F■ General Fund El Road Use Tax Sewer ❑ Sanitation ❑ Bonds 1:1 Federal/other grants Other(specify) This expenditure is to be coded to the following budget line-item: 417-11-1100-2120 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 2,813.74 and the current available balance is $ 2,813.74 Respectfully submitted, Z NSM-w�a-r 11/1/2021 (Signature Dept. Hea Desi nee) Date (Signature Finance Dept. Review) Date K%shared good ieslforms\Expenditure Pre-Authorization xls(Mar 2010) City Clerk Use Only Finance Committee Approval Date 11/1/2021 City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Sewer Department to expend $ 7,885.00 plus est. shipping costs of $700.00 to pay for or purchase Auma actuator rebuild for the Blowers Creek storm lift station. This purchase or expenditure is being made because: Current actuator is inoperable and needs to be repaired. Vendor selected for this purchase: Mellen & Associates, Inc. Bids or written quotes were taken on this purchase, as follows: F■ Bids or quotes were not taken on this purchase because: Mellen & Associates Inc is the sole provider of this unit. Prior Committee Actions (Dates): Please check the following box(es)as appropriate to describe the funding for this expense: ❑ General Fund ❑ Road Use Tax FE-1 Sewer F—] Sanitation ElBonds ❑ Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 520-14-5200 1571 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 400,000.00 and the current available balance is $ 218,205.03 Respectfully submitted, Brad Manahl 1020/2031 'I �GY`�{2 wP,IcfPCY 11/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) City Clerk Use Only Finance Committee Approval Date 11/1/2021 City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Sewer Department to expend $ 13,395.43 plus est. shipping costs of $ 175.00 to pay for or purchase JWC Muffin Monster sewage grinder pump This purchase or expenditure is being made because: Redundant Muffin Monster needed in case of malfunction of current unit. Vendor selected for this purchase: Electric Pump Bids or written quotes were taken on this purchase, as follows: F■ Bids or quotes were not taken on this purchase because: Electric Pump is sole provider of this item. Prior Committee Actions (Dates): Please check the following box(es)as appropriate to describe the funding for this expense: ❑ General Fund ❑ Road Use Tax FE-1 Sewer F—] Sanitation EIBonds ❑ Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 520-14-5200 1571 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 400,000.00 and the current available balance is $ 210,320.03 Respectfully submitted, Brad Manahl 10120/2021 11/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) City Clerk Use Only Finance Committee Approval Date 11/1/2021 City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Sewer Department to expend $ 8,572.50 plus est. shipping costs of $ 0 to pay for or purchase Service for aeration blower, plus parts This purchase or expenditure is being made because: Aeration blower needs servicing and possible bearing change for high vibration warnings. Vendor selected for this purchase: Gardner Denver Nash Bids or written quotes were taken on this purchase, as follows: F■ Bids or quotes were not taken on this purchase because: Sole provider for service Prior Committee Actions (Dates): Please check the following box(es)as appropriate to describe the funding for this expense: ❑ General Fund ❑ Road Use Tax FE-1 Sewer F—] Sanitation EIBonds ❑ Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 520-14-5200-1571 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 400,000.00 and the current available balance is $ 226,777.53 Respectfully submitted, Brian Bowman 012-21 N"�A.war 11/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) City Clerk Use Only Finance Committee Approval Date 11/1/2021 City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Sewer Department to expend $ 4,763 plus est. shipping costs of $ 0 to pay for or purchase Lab Fume Hood Blower This purchase or expenditure is being made because: The Lab Fume Hood Blower was not operable Vendor selected for this purchase: Heating & Cooling Supply Co. Bids or written quotes were taken on this purchase, as follows: Bids or quotes were not taken on this purchase because: Heating and Cooling Supply was sole provider Prior Committee Actions (Dates): Please check the following box(es)as appropriate to describe the funding for this expense: EI General Fund EI Road Use Tax FE-1 Sewer F—] Sanitation EI Bonds EI Federal/other grants F—] Other(specify) This expenditure is to be coded to the following budget line-item: 520-14-5200-1371 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 28,000 and the current available balance is $ 17,514 Respectfully submitted, Brian Bowman "1°'12' NJL.We W.'a.. V, 11/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) City Clerk Use Only Finance Committee Approval Date 11/1/2021 City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Traffic Operations Department to expend $ 5,854.13 plus est. shipping costs of $ 200.00 to pay for or purchase 1 - Holophane ATB2 LED Fixture 1 -Valmont Black Street Light Pole This purchase or expenditure is being made because: To replace damaged pole and fixture due to a crash at E. 1 st and Sycamore Sts. Previously Van Meter sent price on wrong pole and fixture ($4,222.50) Vendor selected for this purchase: Van Meter 0■ Bids or written quotes were taken on this purchase, as follows: 3E Waterloo, IA $5,854.13 Van Meter Waterloo, IA $6,892.50 ❑ Bids or quotes were not taken on this purchase because: Prior Committee Actions (Dates): $4,222.50 approved on 10/18/21 Please check the following box(es)as appropriate to describe the funding for this expense: ❑ General Fund ❑0 Road Use Tax ❑ Sewer F—] Sanitation EIBonds ❑ Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 266-17-7120-1521 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 28,800.00 and the current available balance is $ 22,300.23 Respectfully submitted, Sandie Greco 10/20/2021 11/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) PROJECT BUDGET WORKSHEET - ALL PROJECTS PAGE ONE Project Name SportsPlex Marketing FY2022 City Contract No. To be assigned by the Finance Dept. Project Manager Mark Gallagher Project No. 37HMT Project Budget Total $ 10,000.00 Subproject No. SPLX22 1. How will this project be funded? A. Federal Grant Yes 0 No 0 CFDA# % Paid by federal grant Grant Name Grant Agreement Number B. State Grant Yes = No % Paid by state grant Grant Name Reap Grant Grant Agreement Number C. City Match Source of Funding % Paid by City D. Other Entities Yes = No 0 % Paid by other entity 100.00% Name Hotel Motel Done None 2. Attach copies of any grant agreements that will fund the project(REQUIRED) Awarded 10/04/2021 Yes No 3. Does the project include the purchase of right of way or other real property? FX If yes, will real property purchases be reimbursable under the grant? If yes, have you attached authorization to purchase real property to this document? 4. Will this project include any non-participating expenses, such as: A. Stormwater permit fees F1 FX B. Publication, or printing costs ❑ FX C. Others, list ❑ FX 5. Does this project cover any regular full-time salaries or benefits? ❑ FX If yes, employee/position to be covered. 6. Include a brief description of the project in the space below: (REQUIRED) the CedarValley SportsPlex was awarded hotel motel funds to be used for marketing the sports facility. This will allow us to market to both potential members as well as event organizers. Page 2 must be attached and signed. K:\shared goodies\forms\Waterloo.30454.1.FY-2022—ON MED IA—Project—Budget—H MT SportsPlex\Page 1 All Projects (Mar 2010) PROJECT BUDGET WORKSHEET- NON-CONSTRUCTION PAGE TWO City Clerk Use Only Finance Committee 11/1/2021 Approval Date Project Name (from page one) SportsPlex Marketing FY2022 Department No. project will be budgeted under 37 To be assigned by the Finance Dept. Activity No. project will be budgeted under 4105 Project No. 37HMT Subproject No. SPLX22 (Each column should only include amounts by fund) Fund: 010 Fund: Fund: Fund: Total REVENUES: 010-37-4105 3000 Cash on Hand $ - 3350 Federal Grant - 3352 Federal HUD Grant - 3354 Shared Program - Local - 3357 Shared Program - County - 3358 Shared Program - City - 3360 Shared Program - State - 3361 State Grant - 3720 Donations- Restricted - 3750 Sale of Bonds - 3111 Hotel Motel Discretionary 10,000.00 10,000.00 TOTALS $ 10,000.00 $ - $ - $ - $ 10,000.00 EXPENDITURES: 1111 Salaries- Regular $ - 1112 Salaries- Part Time - 1315 Education &Training - 1345 Travel - Official City - 1346 Travel - Prof Training - 1390 Contractual Services - 1351 Advertising 10,000.00 10,000.00 TOTALS $ 10,000.00 $ - $ - $ - $ 10,000.00 Paul Fluting 10/07/2021 11/1/2021 (Signature Dept. Head) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Waterloo.30454.1.FY_2022_ONMEDIA_Project_Budget_HMT_SportsPlex\Page 2(Donat or NON-constr) (Mar 2010) PROJECT BUDGET WORKSHEET -ALL PROJECTS PAGE ONE Project Name FY21 Clearance and Demolition City Contract No. To be assigned by the Finance Dept. Project Manager Project No. 32BG20 Project Budget Total $ 30,000.00 Subproject No. DEMO 1. How will this project be funded? A. Federal Grant Yes 0 No 0 CFDA# 14.218 % Paid by federal grant 100.00% Grant Name CDBG Grant Agreement Number B-20-MC-19-0008 B. State Grant Yes 0 No 0 % Paid by state grant Grant Name Grant Agreement Number C. City Match Source of Funding % Paid by City D. Other Entities Yes = No % Paid by other entity Name Done None 2. Attach copies of any grant agreements that will fund the project(REQUIRED) FX ❑ Yes No 3. Does the project include the purchase of right of way or other real property? El ❑X If yes, will real property purchases be reimbursable under the grant? ❑ ❑ If yes, have you attached authorization to purchase real property to this document? ❑ ❑ 4. Will this project include any non-participating expenses, such as: A. Stormwater permit fees ❑ FX B. Publication, or printing costs ❑ FX C. Others, list ❑ FX 5. Does this project cover any regular full-time salaries or benefits? ❑ EX If yes, employee/position to be covered. 6. Include a brief description of the project in the space below: (REQUIRED) Clearance and demolition of slumb and blighted property. Page 2 must be attached and signed. K:\shared good ies\forms\Waterloo.30698.1.Demolition_and_Clearance_Budget_Worksheet\Page 1 All Projects (Mar 2010) PROJECT BUDGET WORKSHEET- NON-CONSTRUCTION PAGE TWO City Clerk Use Only Finance Committee Approval Date 11/1/2021 Project Name (from page one) FY21 Clearance and Demolition Department No. project will be budgeted under 32 To be assigned by the Finance Dept. Activity No. project will be budgeted under 5850 Project No. 32BG20 Subproject No. DEMO (Each column should only include amounts by fund) Fund: Fund: Fund: Fund: 224 Total REVENUES: 3000 Cash on Hand $ - 3350 Federal Grant 30,000.00 30,000.00 3352 Federal HUD Grant - 3354 Shared Program - Local - 3357 Shared Program - County - 3358 Shared Program - City - 3360 Shared Program - State - 3361 State Grant - 3720 Donations - Restricted - 3750 Sale of Bonds - 3905 TIF Revenue - TOTALS $ 30,000.00 $ - $ - $ - $ 30,000.00 EXPENDITURES: 1111 Salaries - Regular $ - 1112 Salaries - Part Time - 1315 Education &Training - 1345 Travel - Official City - 1346 Travel - Prof Training - 1390 Contractual Services - 1393 Contributions and Subsidies - 1396 Property Demolition 30,000.00 30,000.00 1358 Econ Dev Grant - TOTALS $ 30,000.00 $ - $ - $ - $ 30,000.00 Rudy Jones 10/15/202111/1/2021 (Signature Dept. Head) Date (Signature Finance Dept. Review) Date K:\shared good ies\forms\Waterloo.30698.1.Demolition_and_Clearance_Budget_Worksheet\Page 2(Donat or NON-constr) (Mar 2010) PROJECT BUDGET WORKSHEET - ALL PROJECTS PAGE ONE Project Name Feasibility Study of Indoor Competive Pool City Contract No. To be assigned by the Finance Dept. Project Manager Mark Gallagher Project No. Project Budget Total $ 8,825.00 Subproject No. 1. How will this project be funded? A. Federal Grant Yes 0 No 0 CFDA# % Paid by federal grant Grant Name Grant Agreement Number B. State Grant Yes = No % Paid by state grant Grant Name Grant Agreement Number C. City Match Source of Funding % Paid by City D. Other Entities Yes = No = % Paid by other entity 100.00% Name Funded 100% by Waterloo Development Corp. Done None 2. Attach copies of any grant agreements that will fund the project(REQUIRED) Fx ❑ Yes No 3. Does the project include the purchase of right of way or other real property? Fx If yes, will real property purchases be reimbursable under the grant? If yes, have you attached authorization to purchase real property to this document? 4. Will this project include any non-participating expenses, such as: A. Stormwater permit fees ❑ Q B. Publication, or printing costs F1 ❑ C. Others, list ❑ ❑ 5. Does this project cover any regular full-time salaries or benefits? El Ex If yes, employee/position to be covered. 6. Include a brief description of the project in the space below: (REQUIRED) Waterloo Development Corporation has commited funds for a feasibility study regardind an Indoor Competitive Pool for Waterloo. Because this project is for City amentities, the expense and related reimbursements will be processed by the City. Page 2 must be attached and signed. K:\shared goodies\forms\Waterloo.30703.1.Proj_Budget_study_indoor_competative_pool\Page 1 All Projects (Mar 2010) PROJECT BUDGET WORKSHEET- NON-CONSTRUCTION PAGE TWO City Clerk Use Only Finance Committee Approval Date 11/1/2021 Project Name (from page one) Feasibility Study of Indoor Competive Pool Department No. project will be budgeted under 37 To be assigned by the Finance Dept. Activity No. project will be budgeted under 4202 Project No. 37GAME Subproject No. CSWMSTDY (Each column should only include amounts by fund) Fund: 426-37- Fund: Fund: Fund: 4202 Total REVENUES: 3000 Cash on Hand $ - 3350 Federal Grant - 3352 Federal HUD Grant - 3354 Shared Program - Local - 3357 Shared Program - County - 3358 Shared Program - City - 3360 Shared Program - State - 3361 State Grant - 3720 Donations- Restricted 8,825.00 8,825.00 3750 Sale of Bonds - TOTALS $ 8,825.00 $ - $ - $ - $ 8,825.00 EXPENDITURES: 1111 Salaries- Regular $ - 1112 Salaries- Part Time - 1315 Education &Training - 1345 Travel - Official City - 1346 Travel - Prof Training - 2103 Contractual Services 8,825.00 8,825.00 TOTALS $ 8,825.00 $ - $ - $ - $ 8,825.00 Paul Huting 10/11/2021 rn"q� wa� 11/1/2021 (Signature Dept. Head) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Waterloo.30703.1.Proj_Budget_study_indoor_competative_pool\Page 2(Donat or NON-constr) (Mar 2010) PROJECT BUDGET WORKSHEET - ALL PROJECTS PAGE ONE Project Name Feasibility Study of Indoor Sports Facility City Contract No. To be assigned by the Finance Dept. Project Manager Mark Gallagher Project No. 37GAME Project Budget Total $ 29,950.00 Subproject No. SFACSTDY 1. How will this project be funded? A. Federal Grant Yes 0 No 0 CFDA# % Paid by federal grant Grant Name Grant Agreement Number B. State Grant Yes = No % Paid by state grant Grant Name Grant Agreement Number C. City Match Source of Funding % Paid by City D. Other Entities Yes = No = % Paid by other entity 100.00% Name Funded 100% by Waterloo Development Corp. Done None 2. Attach copies of any grant agreements that will fund the project(REQUIRED) Fx ❑ Yes No 3. Does the project include the purchase of right of way or other real property? Fx If yes, will real property purchases be reimbursable under the grant? If yes, have you attached authorization to purchase real property to this document? 4. Will this project include any non-participating expenses, such as: A. Stormwater permit fees ❑ Q B. Publication, or printing costs F1 ❑ C. Others, list ❑ ❑ 5. Does this project cover any regular full-time salaries or benefits? El Ex If yes, employee/position to be covered. 6. Include a brief description of the project in the space below: (REQUIRED) Waterloo Development Corporation has commited funds for a feasibility study regardind an Indoor Sports Facility for Waterloo. Because this project is for City amentities, the expense and related reimbursements will be processed by the City. Page 2 must be attached and signed. K:\shared goodies\forms\Waterloo.30710.1.Proj_Budget_for_Indoor_Sports_Facility\Page 1 All Projects (Mar 2010) PROJECT BUDGET WORKSHEET- NON-CONSTRUCTION PAGE TWO City Clerk Use Only Finance Committee Approval Date 11/1/2021 Project Name (from page one) Feasibility Study of Indoor Sports Facility Department No. project will be budgeted under To be assigned by the Finance Dept. Activity No. project will be budgeted under Project No. 37GAME Subproject No. SFACSTDY (Each column should only include amounts by fund) Fund: 426-37- Fund: Fund: Fund: 4202 Total REVENUES: 3000 Cash on Hand $ - 3350 Federal Grant - 3352 Federal HUD Grant - 3354 Shared Program - Local - 3357 Shared Program - County - 3358 Shared Program - City - 3360 Shared Program - State - 3361 State Grant - 3720 Donations- Restricted 29,950.00 29,950.00 3750 Sale of Bonds - TOTALS $ 29,950.00 $ - $ - $ - $ 29,950.00 EXPENDITURES: 1111 Salaries- Regular $ - 1112 Salaries- Part Time - 1315 Education &Training - 1345 Travel - Official City - 1346 Travel - Prof Training - 2103 Contractual Services 29,950.00 29,950.00 TOTALS $ 29,950.00 $ - $ - $ - $ 29,950.00 Paul Huting 10/11/2021 N11 4,weer 11/1/2021 (Signature Dept. Head) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Waterloo.30710.1.Proj_Budget_for_Indoor_Sports_Facility\Page 2(Donat or NON-constr) (Mar 2010) PROJECT BUDGET WORKSHEET - ALL PROJECTS PAGE ONE Project Name Aquatics Master Plan City Contract No. To be assigned by the Finance Dept. Project Manager Mark Gallagher Project No. 37GAME Project Budget Total $ 45,755.00 Subproject No. POOLPLAN 1. How will this project be funded? A. Federal Grant Yes 0 No 0 CFDA# % Paid by federal grant Grant Name Grant Agreement Number B. State Grant Yes = No % Paid by state grant Grant Name Grant Agreement Number C. City Match Source of Funding GO Bonds % Paid by City 56.00% D. Other Entities Yes 0 No = % Paid by other entity 44.00% Name BHCGA$20,000.00 Done None 2. Attach copies of any grant agreements that will fund the project(REQUIRED) Fx ❑ Yes No 3. Does the project include the purchase of right of way or other real property? Fx If yes, will real property purchases be reimbursable under the grant? If yes, have you attached authorization to purchase real property to this document? 4. Will this project include any non-participating expenses, such as: A. Stormwater permit fees ❑ Q B. Publication, or printing costs F1 ❑ C. Others, list ❑ ❑ 5. Does this project cover any regular full-time salaries or benefits? El Ex If yes, employee/position to be covered. 6. Include a brief description of the project in the space below: (REQUIRED) The City of Waterloo and BHCGA have partnered to fund an Aquatic Master Plan to help shape the future of our outdoor swimming facilities and spaces. Page 2 must be attached and signed. K:\shared good ies\forms\Waterloo.30697.1.Proj_Budget_Aquatic_Master_Plan_(1)\Page 1 All Projects (Mar 2010) PROJECT BUDGET WORKSHEET- NON-CONSTRUCTION PAGE TWO City Clerk Use Only Finance Committee Approval Date 11/1/2021 Project Name (from page one) Aquatics Master Plan Department No. project will be budgeted under 37 To be assigned by the Finance Dept. Activity No. project will be budgeted under 4105 Project No. 37GAME Subproject No. POOLPLAN (Each column should only include amounts by fund) Fund: 419 Fund: Fund: Fund: Total REVENUES: 419-37-4105-2103 426-37-4105 2103 bond$ Gaming 3000 Cash on Hand $ - 3350 Federal Grant - 3352 Federal HUD Grant - 3354 Shared Program - Local - 3357 Shared Program - County - 3358 Shared Program - City - 3360 Shared Program - State - 3361 State Grant - 3720 Donations- Restricted 20,000.00 20,000.00 3750 Sale of Bonds 25,755.00 25,755.00 TOTALS $ 25,755.00 $ 20,000.00 $ - $ - $ 45,755.00 EXPENDITURES: 1111 Salaries- Regular $ - 1112 Salaries- Part Time - 1315 Education &Training - 1345 Travel - Official City - 1346 Travel - Prof Training - 2103 Consulting 25,755.00 20,000.00 45,755.00 TOTALS $ 25,755.00 $ 20,000.00 $ - $ - $ 45,755.00 Paul Huting 10/11/2021 W.4— 11/1/2021 (Signature Dept. Head) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Waterloo.30697.1.Proj_Budget_Aquatic_Master_Plan_(1)\Page 2(Donat or NON-constr) (Mar 2010) PROJECT BUDGET WORKSHEET - ALL PROJECTS PAGE ONE Project Name Waterloo Housing Trust Fund City Contract No. To be assigned by the Finance Dept. Project Manager Project No. Project Budget Total $ 28,267.00 Subproject No. 1. How will this project be funded? A. Federal Grant Yes 0 No 0 CFDA# % Paid by federal grant Grant Name Grant Agreement Number 21-LHTF-05 B. State Grant Yes = No = % Paid by state grant Grant Name Grant Agreement Number C. City Match Source of Funding % Paid by City D. Other Entities Yes 0 No = % Paid by other entity 100.00% Name Waterloo Housing Trust Fund Done None 2. Attach copies of any grant agreements that will fund the project(REQUIRED) FX ❑ Yes No 3. Does the project include the purchase of right of way or other real property? FX If yes, will real property purchases be reimbursable under the grant? If yes, have you attached authorization to purchase real property to this document? 4. Will this project include any non-participating expenses, such as: A. Stormwater permit fees ❑ FX B. Publication, or printing costs ❑ Fx C. Others, list ❑ FX 5. Does this project cover any regular full-time salaries or benefits? El Ex If yes, employee/position to be covered. 6. Include a brief description of the project in the space below: (REQUIRED) These funds will be used to supplement our Emergency Repair program. Page 2 must be attached and signed. K:\shared goodies\forms\Waterloo.30699.1.Waterloo_Housing_Trust_Fund_Budget_Worksheet\Page 1 All Projects (Mar 2010) PROJECT BUDGET WORKSHEET- NON-CONSTRUCTION PAGE TWO City Clerk Use Only Finance Committee Approval Date 11/1/2021 Project Name (from page one) Waterloo Housing Trust Fund Department No. project will be budgeted under 32 To be assigned by the Finance Dept. Activity No. project will be budgeted under Project No. 32WHT Subproject No. WHTF8 (Each column should only include amounts by fund) Fund:_ Fund: Fund: Fund: 426 Total REVENUES: 32-5852 3000 Cash on Hand $ - 3350 Federal Grant - 3352 Federal HUD Grant - 3354 Shared Program - Local - 3357 Shared Program -County - 3358 Shared Program -City - 3360 Shared Program -State 28,267.00 28,267.00 3361 State Grant - 3720 Donations- Restricted - 3750 Sale of Bonds - 3905 TIF Revenue - TOTALS $ 28,267.00 $ - $ - $ - $ 28,267.00 EXPENDITURES: 1111 Salaries- Regular $ - 1113 Longevity - 1121 FICA - 1122 IPERS - 1123 Life& Disability - 1131 Health Insurance - 1313 Legal Service - 1315 Education and Training - 1317 Audit Expense - 1343 Postage and Mailing - 1351 Advertising Expense - 1358 Economic Development - 1376 Office Equipment - 1379 Interim Assistance 28,267.00 28,267.00 1393 Contributions and Subsidy - 1516 Minor Computer Equipment - 1520 Computer Software - 1561 Office Supplies - TOTALS $ 28,267.00 $ - $ - $ - $ 28,267.00 RUDY JONES 10/11/21 Nc4 Wawa 11/1/2021 (Signature Dept. Head) Date (Signature Finance Dept. Review) Date K:\shared good ies\forms\Waterloo.30699.1.Waterloo_Housing_Trust_Fund_Bud get_Worksheet\Page 2(Donat or NON-constr) (Mar 2010) Completed forms should be routed directly to the Finance Dept. FINANCE DEPT.ONLY Finance Committee approval required? YES X NO If so,date approved: 11/1/2021 City of Waterloo Line-Item Budget Amendment Request Form The Finance Committee of the City Council and/or Finance Dept. is hereby requested to authorize the following line-item budget amendment for FYE 2022 submitted by the Leisure Services Department: EXPENSES/REVENUE DECREASE EXPENDITURES(INCREASE REVENUE) INCREASE EXPENDITURES(DECREASE REVENUE) Fund Dept Activity Acct# Acct Name Proj Code Amount Fund Dept Activity Acct# Acct Name Proj Code Amount 010 37 4105 cash 37GFT.0007 5,500.59 010 37 4105 1567 rec equip 37GFT.0007 5,500.59 PEI TOTAL $5,500.59 TOTAL $5,500.59 This amendment is being requested because: to carry forward the cash balance in project 37GFT.0007 Young Arena Youth Hockey. Project where Marold funds are posted. Prior Committee Actions(Dates): Paul Huting 10/20/2021 11/11/20211 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K:\users\shared goodies\forms\Waterloo.30593.1.Amendment_37GFT.0007(Apr 2003) Under File, Select"Save As" From the"Save In"drop down box, locate the directory you wish to save your file in. You may rename the file in the"File name:" box at the bottom of the screen. REMEMBER: the form itself is protected so you can only enter information in the yellow high-lighted cells. At the top of the form, go to the first cell requiring information. This is Cell E11, directly after"FYE" Once you've completed the fiscal year you can press the"tab" key to go to the next cell requiring information to be entered. You may continue to press the"tab" key to move between the areas of the form that you must complete. Or, you can simply use your mouse and click on the individual yellow cells you wish to move to. The"TOTALS"will automatically be completed for you. Once all information is entered, save your file and print the form. Obtain the required signature and date and route the completed form to the Finance Department for their signature/approval. Completed forms should be routed directly to the Finance Dept. FINANCE DEPT.ONLY Finance Committee approval required? YES M NO If so,date approved: 11/11/2021 City of Waterloo Line-Item Budget Amendment Request Form The Finance Committee of the City Council and/or Finance Dept. is hereby requested to authorize the following line-item budget amendment for FYE 2022 submitted by the Police Department Department: EXPENSES/REVENUE DECREASE EXPENDITURES(INCREASE REVENUE) INCREASE EXPENDITURES(DECREASE REVENUE) Fund Dept Activity Acct# Acct Name Proj Code Amount Fund Dept Activity Acct# Acct Name Proj Code Amount 010 11 1150 3373 Federal Pass Thru 1GRT.HOTS 21,000.00 010 11 1150 1114 Overtime 1GRT.HOTS2 21,000.00 010 11 1160 3373 Federal Pass Thru 1GRT.HOTS 7,000.00 010 11 1160 1114 Overtime 1GRT.HOTS2 7,000.00 P9�-- TOTAL $28,000.00 TOTAL $28,000.00 This amendment is being requested because: This is to conform with the City's budget line item control policy. See attached paper worked, original grant extended from 10/1/2020 to 6/30/2022 with$28,000 in additional funding for Meth HotSpots CFDA#16.710 Grant#19-CAMP-16. Prior Committee Actions(Dates): Matt McGeough, Police Capt 10/20/2021 11/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K:\users\shared goodies\forms\Waterloo.30627.1.Budget_Amendment_Meth_HOTS21Extension_thru_6-30-2022(Apr 2003) Under File, Select"Save As" From the"Save In"drop down box, locate the directory you wish to save your file in. You may rename the file in the"File name:" box at the bottom of the screen. REMEMBER: the form itself is protected so you can only enter information in the yellow high-lighted cells. At the top of the form, go to the first cell requiring information. This is Cell E11, directly after"FYE" Once you've completed the fiscal year you can press the"tab" key to go to the next cell requiring information to be entered. You may continue to press the"tab" key to move between the areas of the form that you must complete. Or, you can simply use your mouse and click on the individual yellow cells you wish to move to. The"TOTALS"will automatically be completed for you. Once all information is entered, save your file and print the form. Obtain the required signature and date and route the completed form to the Finance Department for their signature/approval. PROJECT BUDGET WORKSHEET INSTRUCTIONS The purpose of the project budget form is to set up a budget and project code that can be used to more specifically account for certain construction or non-construction projects funded with state and federal grants, donations, or any "restricted"type revenue sources. This form should be completed BEFORE any invoices are processed or payments are made. It is also needed before any of the revenue is deposited. If you are not sure if a particular project needs a project code, please contact the Finance Department. We are glad to help! 1.) Page 1 is REQUIRED for all projects. Complete the page 2 (constr proj)tab if you are requesting a budget for a construction project. Complete page 2 (donat or NON-constr) if you are requesting a budget for any project, other than one involving construction. 2.)You MUST provide the CFDA#for all federally-funded projects, including those that involve federal funds but are passed on to the city from the State of Iowa. The grantor is required to provide that number to you. Sometimes that number is provided in the grant application only, so that is a good place to look for it if you can't find it in the grant award document. 3.) The revenue and expense account numbers provided on both page 2 tabs are commonly-used examples only. You may change, add or edit those if there's a number you need that isn't listed. This form isn't meant to list all possible account numbers, only those that are used the most often. 4.) Separate columns should be completed on the budget worksheet (page 2) if the project involves different "funds" (e.g. GO bond fund and grant-fund/fund 290). Expenses and revenue for each fund should be separated into columns and EACH column's revenue and expenses MUST EQUAL! You will get an "error" message below the expense totals line if they don't. You need to make a correction if you get an error message. 5.) In general, the Finance Department will assign the project codes. However, if you have a request or suggestion for the code you'd like to use, please discuss that with the Finance Department before submitting your worksheets. 6. Please remember to forward the related grant award document to the Finance Department, along with the budget. PROJECT BUDGET WORKSHEET - ALL PROJECTS PAGE ONE Project Name Anti-Heroin Task Force-Grant#19 City Contract No. #19-Heroin-19 To be assigned by the Finance Dept. Project Manager Chief Fitzgerald Project No. 11 GRT Project Budget Total $ 7,000.00 Subproject No. HEROIN19 1. How will this project be funded? A. Federal Grant Yes 0 No CFDA# #16.710 % Paid by federal grant 100.00% Grant Name Grant Agreement Number #19-Heroin-19 B. State Grant Yes = No 0 % Paid by state grant Grant Name Grant Agreement Number C. City Match Source of Funding None % Paid by City D. Other Entities Yes = No % Paid by other entity Name Done None 2. Attach copies of any grant agreements that will fund the project(REQUIRED) FX Yes No 3. Does the project include the purchase of right of way or other real property? El ❑X If yes, will real property purchases be reimbursable under the grant? If yes, have you attached authorization to purchase real property to this document? 4. Will this project include any non-participating expenses, such as: A. Stormwater permit fees ❑ FR B. Publication, or printing costs ❑ FR C. Others, list ❑ FR 5. Does this project cover any regular full-time salaries or benefits? ❑ EX If yes, employee/position to be covered. 6. Include a brief description of the project in the space below: (REQUIRED) Grant funds will cover heroin related overtime through the WPD's Tri-County Drug Task Force activities Page 2 must be attached and signed. K:\shared good ies\forms\Waterloo.30704.1.Heroin_Grant#19_FY2022_Project_Budget_Worksheet\Page 1 All Projects (Mar 2010) PROJECT BUDGET WORKSHEET- NON-CONSTRUCTION PAGE TWO City Clerk Use Only Finance Committee Approval Date 11/1/2021 Project Name (from page one) Anti-Heroin Task Force- Grant#19 Department No. project will be budgeted under 11 To be assigned by the Finance Dept. Activity No. project will be budgeted under 01011 1150 Project No. 11 GRT 01011 1150 Subproject No. HEROIN19 (Each column should only include amounts by fund) Fund: 1150 Fund: 1160 Fund: Fund: Total REVENUES: 3000 Cash on Hand $ - 3350 Federal Grant - 3352 Federal HUD Grant - 3354 Shared Program - Local - 3357 Shared Program - County - 3358 Shared Program - City - 3360 Shared Program -State - 3361 State Grant - 3373 Fed Pass thru for Iowa 4,900.00 2,100.00 7,000.00 3720 Donations - Restricted - 3750 Sale of Bonds - TOTALS $ 4,900.00 $ 2,100.00 $ - $ - $ 7,000.00 EXPENDITURES: 1111 Salaries - Regular $ - 1112 Salaries - Part Time - 1114 Overtime 4,900.00 4,900.00 1302 Outside Agencies 2,100.00 2,100.00 1315 Education &Training - 1345 Travel - Official City - 1346 Travel - Prof Training - 1390 Contractual Services - TOTALS $ 4,900.00 $ 2,100.00 $ - $ - $ 7,000.00 Matt McGeough, Police Captain 10/20/2021 11/1/2021 (Signature Dept. Head) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Waterloo.30704.1.Heroin_Grant#19_FY2022_Project_Budget_Worksheet\Page 2(Donat or NON-constr) (Mar 2010) Completed forms should be routed directly to the Finance Dept. FINANCE DEPT.ONLY Finance Committee approval required? YES ® NO If so,date approved: City of Waterloo Line-Item Budget Amendment Request Form The Finance Committee of the City Council and/or Finance Dept. is hereby requested to authorize the following line-item budget amendment for FYE 2022 submitted by the Leisure Services Department: EXPENSES/REVENUE DECREASE EXPENDITURES(INCREASE REVENUE) INCREASE EXPENDITURES(DECREASE REVENUE) Fund Dept Activity Acct# Acct Name Proj Code Amount Fund Dept Activity Acct# Acct Name Proj Code Amount 010 37 4105 cash 37RST.YAM1 11,123.13 010 37 4105 1567 rec equip 37RST.YAM1 11,123.13 TOTAL $11,123.13 TOTAL $11,123.13 This amendment is being requested because: to carry forward the cash balance in project 37RST.YAM1 Young Arena Miscellaneous improvements. Prior Committee Actions(Dates): Paul Huting 10/25/2021 11/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K:\users\shared goodies\forms\Waterloo.30726.1.Amendment_37RST.YAMI(Apr 2003) Under File, Select"Save As" From the"Save In"drop down box, locate the directory you wish to save your file in. You may rename the file in the"File name:" box at the bottom of the screen. REMEMBER: the form itself is protected so you can only enter information in the yellow high-lighted cells. At the top of the form, go to the first cell requiring information. This is Cell E11, directly after"FYE" Once you've completed the fiscal year you can press the"tab" key to go to the next cell requiring information to be entered. You may continue to press the"tab" key to move between the areas of the form that you must complete. Or, you can simply use your mouse and click on the individual yellow cells you wish to move to. The"TOTALS"will automatically be completed for you. Once all information is entered, save your file and print the form. Obtain the required signature and date and route the completed form to the Finance Department for their signature/approval.