Loading...
HomeMy WebLinkAboutApproved Documents - 7/31/2023TRAVEL REQUEST CITY OF WATERLOO FINANCE DEPT. LINE ITEM USED FY 24 BUDGETED EXPENDED YTD THIS REQUEST LEFT AFTER THIS REQUEST DATE Original - Clerk/Finance STAFF ONLY 010-29-7700-1346 $5,000.00 $173.45 $1,800.00 $3,026.55 07/18/2023 Copy - Department NAME(S) AND POSITION(S): Rusty Zey, Ops Coordinator; Troy Deeds, Tyler Hare, Cody Wilson, Ops Specialists DATE: 7/18/23 NAME OF CLASS / MEETING: Aircraft Live Burn Training DESTINATION: Eastern Iowa Airport DEPARTURE POINT IF NOT WATERLOO: DEPARTURE DATE: 9/21/23 or 9/22/23 RETURN DATE: 9/21/23 or 9/22/23 DATE(S) OF MEETING: 9/21/23 and 9/22/23 PURPOSE OF TRAVEL/TRAINING: Annual live fire training for all Airport Ops personnel assigned to Aircraft Rescue Fire Fighting is required by the FAA for compliance with Federal Aviation Regulation (FAR) Part 139. Two employees will attend each day's training. WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: X CITY VEHICLE AIRFARE DEPARTING FROM: ALO PRIVATE VEHICLE ESTIMATE OF COST: LODGING approx $1,800 MEALS REGISTRATION MILEAGE/FUEL TOTAL FOR ALL: $ 1,800.00 TAXI PARKING AIRFARE M ISC/TOLLS BUDGET LINE ITEM: 010-29-7700-1346 X GRANT REIMBURSABLE YES NO X YES NO REQUIRED CERTIFICATION TOTAL: $ 450.00 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Date Approved by Finance Committee: Keith Kaspari 7/31/2023 DEPARTMENT HEAD DATE 7/18/2023 DATE K: \Shared Goodies\Forms\Travel Request Form (Nu f ett N0,p� °siceEo a TRAVEL REQUEST CITY OF WATERLOO FINANCE DEPT. LINE ITEM USED FY 24 BUDGETED EXPENDED YTD THIS REQUEST LEFT AFTER THIS REQUEST DATE Original - Clerk/Finance STAFF ONLY 010-03-8400 1346 $10,000.00 $455.00 $943.88 $8,601.12 07/17/2023 Copy - Department NAME(S) AND POSITION(S): Bridgett Wood, Finance Director Kim Bahr, Financial Analyst DATE: 07/17/2023 NAME OF CLASS / MEETING: Iowa League of Cities Annual Conference DESTINATION: Cedar Rapids, IA DEPARTURE POINT IF NOT WATERLOO: DEPARTURE DATE: September 20, 2023 RETURN DATE: September 22, 2023 DATE(S) OF MEETING: September 20-22, 2023 PURPOSE OF TRAVEL/TRAINING: To attend the 2023 Iowa League of Cities Annual Conference and Exhibit. WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: x COST $ YES NO METHOD OF TRAVEL: X CITY VEHICLE AIRFARE PRIVATE VEHICLE DEPARTING FROM: Waterloo, IA ESTIMATE OF COST: LODGING MEALS $460.00 REGISTRATION $433.88 MILEAGE/FUEL $50.00 TOTAL FOR ALL: $ 943.88 TAXI PARKING AIRFARE M ISC/TOLLS BUDGET LINE ITEM: 010-03-8400 1346 x GRANT REIMBURSABLE YES NO x REQUIRED CERTIFICATION YES NO TOTAL: $ 471.94 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Bridgett Wood DEPARTMENT HEAD 07/17/2023 DATE K: \Shared Goodies\Forms\Travel Request Form Date Approved by Finance Committee: 7/31/2023 DATE TRAVEL REQUEST CITY OF WATERLOO FINANCE DEPT. LINE ITEM USED FY 24 BUDGETED EXPENDED YTD THIS REQUEST LEFT AFTER THIS REQUEST DATE Original - Clerk/Finance STAFF ONLY 010-11-1100-1346 $121,000.00 $16,125.00 $3,150.00 $101,725.00 7/18/23 Copy - Department NAME(S) AND POSITION(S): DATE:7/18/23 Sergeant(s) Pohl, Wilson, J. Tyler NAME OF CLASS / MEETING: 1 DESTINATION: Online FBI LEEDA Trilogy (Basic Supervisory Liability, Advanced Supervisory Liability and 1 elective First Amendement or Ethics) DEPARTURE POINT IF NOT WATERLOO: DEPARTURE DATE: August 2023 RETURN DATE: December of 2023 DATE(S) OF MEETING: Multiple Date Options See attached PURPOSE OF TRAVEL/TRAINING: Lt. Bose is requesting to send Sergeant(s) Pohl, Wilson and J Tyler to the FBI Leeda Trilogy Supervisory. This training consists of 3 classes, Basic and Advanced Supervisroy Liability and an Elective (Ethic or 1st Ammendment) Cost not to exceed $3,150.00 WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: XXX CITY VEHICLE AIRFARE DEPARTING FROM: PRIVATE VEHICLE ESTIMATE OF COST: LODGING $3,150.00 MEALS REGISTRATION MILEAGE/FU EL TOTAL FOR ALL: $ 3,150.00 TAXI PARKING AIRFARE M ISC/TOLLS BUDGET LINE ITEM: GRANT REIMBURSABLE YES NO YES NO TOTAL: $ 1,050.00 PER PERSON REQUIRED CERTIFICATION I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Lt. Steven Bose Date Approved by Finance Committee: 7/31/2023 DEPARTMENT HEAD DATE 7/18/23 i Mew s' DATE K: \Shared Goodies\Forms\Travel Request Form TRAVEL REQUEST CITY OF WATERLOO FINANCE DEPT. LINE ITEM USED FY 24 BUDGETED EXPENDED YTD THIS REQUEST LEFT AFTER THIS REQUEST DATE Original - Clerk/Finance STAFF ONLY 010-03-8400 1346 $10,000.00 $1,398.88 $1,365.28 $7,235.84 07/19/2023 Copy - Department NAME(S) AND POSITION(S): Kelley Felchle, City Clerk and LeAnn Even, Deputy City Clerk DATE: July 19, 2023 NAME OF CLASS / MEETING: Iowa League of Cities Conference DESTINATION: Cedar Rapids, Iowa DEPARTURE POINT IF NOT WATERLOO: DEPARTURE DATE: September 20, 2023 RETURN DATE: September 22, 2023 DATE(S) OF MEETING: September 20-22, 2023 PURPOSE OF TRAVEL/TRAINING: Continuing Education WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: XX YES NO COST $ METHOD OF TRAVEL: CITY VEHICLE AIRFARE XX DEPARTING FROM: PRIVATE VEHICLE ESTIMATE OF COST: 640.00 100.00 $460.00 176/$115.28 LODGING MEALS REGISTRATION MILEAGE/FUEL 50.00 TOTAL FOR ALL: $ 1365.28 TAXI PARKING AIRFARE M ISC/TOLLS BUDGET LINE ITEM: 010-03-8400 1346 X GRANT REIMBURSABLE YES NO X YES NO TOTAL: $ 682.64 REQUIRED CERTIFICATION PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Kelley Felchle DEPARTMENT HEAD 07/19/2023 DATE K: \Shared Goodies\Forms\Travel Request Form Date Approved by Finance Committee: 7/31/2023 DATE (W Z ooq siceEo TRAVEL REQUEST CITY OF WATERLOO FINANCE DEPT. LINE ITEM USED FY 24 BUDGETED EXPENDED YTD THIS REQUEST LEFT AFTER THIS REQUEST DATE Original - Clerk/Finance STAFF ONLY 010-11-1100 1346 $120,000.00 $3,894.93 $2,550.00 $116,105.07 07/18/2023 Copy - Department NAME(S) AND POSITION(S): DATE:7/18/23 6 Command Staff Members NAME OF CLASS / MEETING: DESTINATION: Cedar Falls, Iowa "Complaint Affairs Investigations Processing and Procedural Responsibilities" DEPARTURE POINT IF NOT WATERLOO: DEPARTURE DATE: 8/7/23 RETURN DATE: 8/8/23 DATE(S) OF MEETING: August 7-8, 2023 PURPOSE OF TRAVEL/TRAINING: Lt. Bose is requesting to send 6 command staff members to the Internal Affairs Investigations " Complaint Processing and Procedural Responsibilities" in Cedar Falls, IA. The cost of this training will not exceed $2,550.00 WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: XXX CITY VEHICLE AIRFARE DEPARTING FROM: PRIVATE VEHICLE ESTIMATE OF COST: LODGING $2,550.00 MEALS REGISTRATION MILEAGE/FUEL TOTAL FOR ALL: $ 2,550.00 TAXI PARKING AIRFARE M ISC/TOLLS BUDGET LINE ITEM: 010-11-1100 1346 X GRANT REIMBURSABLE YES NO X REQUIRED CERTIFICATION YES NO TOTAL: $ 425.00 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Date Approved by Finance Committee: Lt. Steven Bose 7/31/2023 DEPARTMENT HEAD DATE 7/18/23 DATE K: \Shared Goodies\Forms\Travel Request Form (WritN0,04' sicNEo City Clerk Use Only Finance Committee Approval Date 7/31/2023 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 $ 5,899.20 plus est. shipping costs of $ 0.00 to pay for or purchase beads for painting runways and taxiways. This purchase or expenditure is being made because: painted markings on airfield must be maintained for FAA FAR Part 139 certification and compliance. Vendor selected for this purchase: Iowa DOT �■ Bids or written quotes were taken on this purchase, as follows: Iowa DOT .49 per pound Potter's Beads .71 per pound, minimum 6,000 pounds n 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 IT Road Use Tax IT Sewer n Sanitation ❑ Bonds . Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 010-29-7700-1371 29A1P.0049 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ 125,000.00 and the current available balance is $ 100,238.19 Respectfully submitted, Keith Kaspari 7/18/2023 7/31/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) City Clerk Use Only Finance Committee Approval Date 7/31/2023 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 Bldg Maintenance Department to expend $ 13,800.00 plus est. shipping costs of $ 0.00 to pay for or purchase This purchase or expenditure is being made because: Replacement of 4 pumps for heating system at the Public Library. Two zones with 2 pumps each all pumps are original pumps from 1980. Vendor selected for this purchase: Air Management �■ Bids or written quotes were taken on this purchase, as follows: Air Management - $ 13,800.00 Ferguson Enterprise - $ 14,675.29 Dennis Supply - $ 18,652.00 n 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 IT Road Use Tax IT Sewer n Sanitation . Bonds ❑ Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 322-22-8800-2152 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ 400,000.00 and the current available balance is $ 264,149.97 Respectfully submitted, Greg Ahlhelm - Building Official 7/31/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) City Clerk Use Only Finance Committee Approval Date 7/31/2023 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 $ 38,000.00 plus est. shipping costs of $ 1,000.00 to pay for or purchase Blanket Pre -Authorization for fuel island repair parts. Cost estimate based on previous invoices received. This purchase or expenditure is being made because: Fuel island has gone down twice within the last year. Vendor selected for this purchase: Will use best available price. n Bids or written quotes were taken on this purchase, as follows: IT Bids or quotes were not taken on this purchase because: Will use best available price at time of repair. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: General Fund IT Road Use Tax IT Sewer n Sanitation ElBonds ❑ 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 $ 66,483.00 and the current available balance is $ 62,784.78 Respectfully submitted, Sheila Steffen 07/21/2023 (-••%i4 t NacWo�i o 7/31/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) City Clerk Use Only Finance Committee Approval Date 7/31/2023 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 Culture & Arts Department to expend $ $10,440.00 plus est. shipping costs of $ N/A to pay for or purchase Vaporblast stripping, priming and painting of 3 sculptures which comprise "Cityscape" a public art work on Lafayette Street between 4th and 5th Streets This purchase or expenditure is being made because: The finish on the sculptures has deteriorated and restoration services are required in order to return the rehabilitate the works and extend their useful lifespan. Vendor selected for this purchase: Personified Inc. �■ Bids or written quotes were taken on this purchase, as follows: Personified Inc: $10,440.00 Harris Cleaning: quote requested, vendor did not submit We were advised that no other local vendors provide the required services. n 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 IT Road Use Tax IT Sewer n Sanitation . Bonds ❑ Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: Capital Improvements 421-26-4260-1390 Cultural Arts - Sculpture (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the current available balance is Respectfully submitted, Chawne Paige $ $15,501.00 $ $15,501.00 7/17 ZUaaq" 7/31/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) City Clerk Use Only Finance Committee Approval Date 7/31/2023 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 $ 3,250.00 Leisure Services Department to expend plus est. shipping costs of $ to pay for or purchase asbestos removal from the tank coating/insulation and caulk at ByrnesPool Bath House. This purchase or expenditure is being made because: in order to remodel the building the asbestos needs to be removed. Vendor selected for this purchase: Advanced Environmental (Waterloo, IA) n Bids or written quotes were taken on this purchase, as follows: n Bids or quotes were not taken on this purchase because: Advance Environmental did initial inspection and are the local vendor for the asbestos removal Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: ❑ General Fund IT Road Use Tax IT Sewer n Sanitation . Bonds ❑ Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 421-37-4200-2103/2132 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the current available balance is Respectfully submitted, $ 700,000.00 $ 420,339.28 Paul Huting 7/12/23 No -ad 7/31/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) City Clerk Use Only Finance Committee Approval Date 7/31/2023 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 $ 3,708.75 plus est. shipping costs of Leisure Services $0 Department to expend to pay for or purchase Epoxy painting of north & south concession stand floors at Young Arena. This purchase or expenditure is being made because: current concession areas floors are worn and in need of repainting with a more durable product. Vendor selected for this purchase: Polymax Concrete Coatings, Waterloo �■ Bids or written quotes were taken on this purchase, as follows: Polymax Concrete Coatings, Waterloo $3,708.75 Even Quality Works $4,837.50 IT 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 IT Road Use Tax IT Sewer n Sanitation . Bonds ❑ Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 322-37-4500-2152 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ 90,000 and the current available balance is Respectfully submitted, Paul Huting 7/12/23 Toe NacW 7/31/2023 $ 24,918 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) City Clerk Use Only Finance Committee Approval Date 7/31/2023 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 $ 5,215.94 plus est. shipping costs of $ 0.00 Parts and labor to repair AC on John Deere utility tractor. Department to expend to pay for or purchase This purchase or expenditure is being made because: the air conditioning quit working a the JD 3720. This unit has a cab that is permanently attached. Vendor selected for this purchase: P&K Waterloo IA n Bids or written quotes were taken on this purchase, as follows: IT Bids or quotes were not taken on this purchase because: P&K is the John Deere implement in Waterloo. They currently have the unit in their shop, torn apart for diagnosing the problem. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: General Fund IT Road Use Tax IT Sewer n Sanitation ElBonds ❑ Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 010-37-4100 1378 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the current available balance is Respectfully submitted, $ 14,552.00 $ 14,403.00 Paul Huting 7/18/2023 Toe N04,d 7/31/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) City Clerk Use Only Finance Committee Approval Date 7/31/2023 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 $ 9,439 plus est. shipping costs of $ 0 to pay for or purchase (6) new security cameras, camera equipment accessories, licenses & installation of equipment and relocation of (4) cameras at Young Arena This purchase or expenditure is being made because: additional cameras and relocation of others will enhance user & visitor safety by expanding our coverage areas that were not included in phase 1. Vendor selected for this purchase: Hawkeye Alarm, Waterloo Iowa n Bids or written quotes were taken on this purchase, as follows: IT Bids or quotes were not taken on this purchase because: Hawkeye Alarm has been the previous vendor for this camera system at Young Arena Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: ▪ General Fund IT Road Use Tax IT Sewer n Sanitation . Bonds ❑ Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 322-37-4500-2152 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the current available balance is Respectfully submitted, Paul Huting $ 90,000 $ 24,918 07/10/2023 Naad '11' 7/31/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) City Clerk Use Only Finance Committee Approval Date 7/31/2023 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,714.20 plus est. shipping costs of $ 0.00 to pay for or purchase Annual fee for registration/membership software to be used by SportsPlex, Sports, and Leisure Campbell office. Service 0707/2023 thru 07/07/2024 This purchase or expenditure is being made because: the current software has been in use for two years. Vendor selected for this purchase: Peak Software Systems, Sandy UT n Bids or written quotes were taken on this purchase, as follows: IT Bids or quotes were not taken on this purchase because: We wish to continue using the current "SportsMan" software. Software must purchased through them. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: General Fund IT Road Use Tax IT Sewer n Sanitation ElBonds ❑ Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 4180-1520 $2,121.39 4200-1520 $2,21.39 4100-1520 471.42 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the current available balance is Respectfully submitted, Paul Huting 07/14/2023 $ 5,700.00 5,500.00 472.00 $ 5,700.00 5,500.00 472.00 Zi0 `�` 7/31/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) City Clerk Use Only Finance Committee Approval Date 7/31/2023 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 $ 4,305.96 plus est. shipping costs of $ NA pool paint for the Cedar Valley SportsPlex pool. Department to expend to pay for or purchase This purchase or expenditure is being made because: the SportsPlex pool is due for new paint. Vendor selected for this purchase: ACCO (Johnston, IA) n Bids or written quotes were taken on this purchase, as follows: IT Bids or quotes were not taken on this purchase because: ACCO is the company that can supply this type of paint. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: General Fund IT Road Use Tax IT Sewer n Sanitation ElBonds ❑ Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 010-37-4180-1390 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the current available balance is Respectfully submitted, Paul Huting $ 25,518.00 $ 25,132.32 7/17/2023 Tw+-tt ' `in 7/31/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) City Clerk Use Only Finance Committee Approval Date 7/31/2023 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 $ 12,179.00 plus est. shipping costs of MIS Department to expend $ 0.00 to pay for or purchase Avaya IP Phone System Licensing, Maintenance and Support This purchase or expenditure is being made because: This is annual phone system maintenance. Vendor selected for this purchase: Gordon Flesch n Bids or written quotes were taken on this purchase, as follows: IT Bids or quotes were not taken on this purchase because: Gordon Flesh/Avaya is the supplier of the phone system and they are very familiar with our entire telecom system. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: General Fund IT Road Use Tax IT Sewer n 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 $ 103,416.00 and the current available balance is $ 103,416.00 Respectfully submitted, Chris Youngblut 07/19/2023 7/31/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) City Clerk Use Only Finance Committee Approval Date 7/31/2023 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 (Flygt Pump) Department to expend $ 52,625.00 plus est. shipping costs of $ 500.00 to pay for or purchase Flygt Pump for Tyson This purchase or expenditure is being made because: New Flygt Pump is needed Vendor selected for this purchase: Electric Pump n Bids or written quotes were taken on this purchase, as follows: 0 Bids or quotes were not taken on this purchase because: Sole Provider Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: General Fund ❑ Road Use Tax n Sewer n Sanitation 0 Bonds ❑ Federal/other grants 0 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 and the current available balance is Respectfully submitted, Jesse Gaherty 07/20/23 $ 400,000.00 $ 398,364.75 Wrte Na °s' o 7/31/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) City Clerk Use Only Finance Committee Approval Date 7/31/2023 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( Actuator) Department to expend $ 8,015.00 plus est. shipping costs of $ 500.00 to pay for or purchase Heating Limitorque Actuator for Digester #3 This purchase or expenditure is being made because: Digester #3 Heating Actuator shaft is bent and prevents it from working correctly. Vendor selected for this purchase: Mead O'Brien n Bids or written quotes were taken on this purchase, as follows: IT Bids or quotes were not taken on this purchase because: Sole Provider Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: ▪ General Fund IT Road Use Tax n Sewer n Sanitation ❑ Bonds ❑ 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 $ 398,364.75 Respectfully submitted, Jesse Gaherty 07/18/23 Tti4ett Zaoci <i 7/31/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) City Clerk Use Only Finance Committee Approval Date 7/31/2023 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 (Software) Department to expend $ 4,500.00 plus est. shipping costs of $ 0.00 to pay for or purchase GreniteNet ESRI Software & Services Implementation This purchase or expenditure is being made because: Need upgrade to continue to support GrfniteNet ESRI Software and Services Vendor selected for this purchase: CUES n Bids or written quotes were taken on this purchase, as follows: IT Bids or quotes were not taken on this purchase because: CUES is sole provider for televising software Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: ▪ General Fund IT Road Use Tax n Sewer n Sanitation ❑ Bonds ❑ Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 520-14-5200-1520 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the current available balance is Respectfully submitted, Jesse Gaherty $ 32,000.00 $ 32,000.00 07/08/23 NaCW tii a 7/31/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) PROJECT BUDGET WORKSHEET - ALL PROJECTS PAGE ONE Project Name FY24 Waterloo Housing Trust Fund City Contract No. Project Manager Project Budget Total INRCOG #76 $ 47,470.00 1. How will this project be funded? To be assigned by the Finance Dept. Project No. 32WHT.WHTF10 Subproject No. Varies A. Federal Grant Yes No X CFDA # 14.239 % Paid by federal grant Grant Name Grant Agreement Number IFA 23-LHTF-03 B. State Grant Yes X No % Paid by state grant 100.00% Grant Name Grant Agreement Number C. City Match Source of Funding % Paid by City D. Other Entities Yes No X % Paid by other entity Name 2. Attach copies of any grant agreements that will fund the project (REQUIRED) 3. Does the project include the purchase of right of way or other real property? 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 B. Publication, or printing costs C. Others, list 5. Does this project cover any regular full-time salaries or benefits? If yes, employee/position to be covered. 6. Include a brief description of the project in the space below: (REQUIRED) Housing Trust Funds provide supplemental funding to the CDBG Emergency Repair Program. Done None ❑X ❑ Yes No ❑ 0 ❑ ❑ ❑ ❑ ❑ ❑X ❑ ❑x ❑ ❑X ❑ ❑x Page 2 must be attached and signed. K:\shared goodies\forms\Housing Trust Fund Budget (1) (1).xls\Page 1 All Projects (Mar 2010) CONSTRUCTION PROJECT BUDGET WORKSHEET PAGE TWO City Clerk Use Only Finance Committee Approval Date 7/31/2023 Project Name (from page one) FY24 Waterloo Housing Trust Fund Department No. project will be budgeted under 32 Activity No. project will be budgeted under 5852 REVENUES: 3000 Cash on Hand 3112 Local Option Sales Tax 3350 Federal Grant 3357 Shared Program - County 3358 Shared Program - City 3360 Shared Program - State 3361 State Grant 3365 State RISE Grant 3368 EPA Grant 3377 EDA Grant 3720 Donations - Restricted 3750 Sale of Bonds EXPENDITURES: Fund: 426 (Each column should only include amounts by fund) To be assigned by the Finance Dept. Project No. 32WHT.WHTF10 Subproject No. Varies Fund: Fund: Fund: Fund: Total 47,470.00 47,470.00 TOTALS $ 47,470.00 $ $ $ $ $ 47,470.00 1379 Interim Assistance 2125 Traffic Control Equipment 2140 Land Acquisition 2144 Land Improvements 2146 Demolitions 2151 Building Construction 2156 Bikeway Construction 2162 Storm Sewers 2163 Sanitary Sewers 2164 Sidewalks 2165 Streets & Roadways 2199 Non -participating Misc $ 47,470.00 $ 47,470.00 TOTALS $ 47,470.00 $ Rudy Jones 7/18/23 $ $ $ $ 47,470.00 Trte ZOao,q° 7/31/2023 (Signature Dept. Head) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Housing Trust Fund Budget (1) (1).xls\Page 2 (Constr Proj) (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: 7/31/2023 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 6/30/2024 submitted by the Community Development 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 224 32 5871 3350 FED Grants IMARP.ADMF 77,765.30 224 32 3571 1111 Salaries -MARP.ADMF 41,362.29 1113 Longevity -1MARP.ADMt 421.13 1121 FICA iMARP.ADMr 3,247.73 1122 IPERS 1MARP.ADMr 3,677.16 1131 Health Insurance IMARP.ADMF 17,500.00 1317 Audit Expense -MARP.ADMt 6,500.00 1346 Travel & Proffesiona iMARP.ADMF 1,640,00 1351 Advertising Expense-IMARP.ADMt 2,909.15 1561 Office Supplies iMARP.ADMF 507.84 r TOTAL This amendment is being requested because: FY24 Budget for current HOME ARP Grant Funds $77,765.30 TOTAL $77,765.30 Prior Committee Actions (Dates): (Sign re ept. Head or Designe Date orertnur 7o S' 7/31/2023 (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K: userslshared goodieslforms1FY24 HOME ARP CURRENT AMAIN BUDGET.xls (Apr 2003)