Loading...
HomeMy WebLinkAboutApproved Documents - 5/1/2023FINANCE DEPT. STAFF ONLY LINE ITEM USED 224 32 5853 1346 TRAVEL REQUEST CITY OF WATERLOO FY 23 BUDGETED 16,200 EXPENDED YTD 524.44 THIS REQUEST 12,140.00 LEFT AFTER THIS REQUEST 3,535.56 DATE 4-12-23 Original - Clerk/Finance Copy - Department NAME(S) AND POSITION(S): Amended Anita Rousselow, Rudy Jones, Angie Fordyce DATE: 4-12- 23 Amended NAME OF CLASS / MEETING: 2023 Program Manager School -Lead Grant DESTINATION: Seattle, Washington DEPARTURE POINT IF NOT WATERLOO: DEPARTURE DATE: April 16, 2023 RETURN DATE: April 20, 2023 DATE(S) OF MEETING: April 17-20, 2023 PURPOSE OF TRAVEL/TRAINING: Program Manager Training is required for staff that have day to day responsibilities with the lead grant. This is hosted by the Office of Lead Hazard Control and Healthy Homes. This is an amended travel request , as Matt has resigned. The cost of a new ticket is $1,120. WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: CITY VEHICLE PRIVATE VEHICLE AIRFARE DEPARTING FROM: Waterloo, Iowa ESTIMATE OF COST: BUDGET LINE ITEM: 224 32 5853 1346 3540.00 LODGING 50.00 TAXI X GRANT REIMBURSABLE 525.00 MEALS PARKING YES NO 2535.00 REGISTRATION 5370.00 AIRFARE X REQUIRED CERTIFICATION MILEAGE/FUEL 120.00 MISC/TOLLS YES NO TOTAL FOR ALL: $ 12,140.00 TOTAL: $ 4046.66 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Rudy D Jones I APPROVE THIS TRAVEL REQUEST T Z0aaot° DEPARTMENT HEAD MAYOR 4-12-2023 DATE XX K:\Shared Goodies\Forms\Travel Request Form January 2010 Finance Committee Approved 5/1/2023 TRAVEL REQUEST CITY OF WATERLOO FINANCE DEPT. LINE ITEM USED FY 23 BUDGETED EXPENDED YTD THIS REQUEST LEFT AFTER THIS REQUEST DATE Original - Clerk/Finance STAFF ONLY 525-15-5400-1346 $5,000.00 $1,010.68 $625.00 $3,364.32 04/20/2023 Copy - Department NAME(S) AND POSITION(S): Sheila Steffen, Public Works Coordinator DATE: April 12, 2023 NAME OF CLASS / MEETING: Iowa Municipal Clerks Academy DESTINATION: Des Moines, Iowa DEPARTURE POINT IF NOT WATERLOO: DEPARTURE DATE: July 26, 2023 RETURN DATE: July 28, 2023 DATE(S) OF MEETING: July 26 - 28, 2023 PURPOSE OF TRAVEL/TRAINING: Clerks Academy CEU's WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: X CITY VEHICLE AIRFARE PRIVATE VEHICLE DEPARTING FROM: Waterloo ESTIMATE OF COST: 290.00 140.00 195.00 LODGING MEALS REGISTRATION MILEAGE/FUEL TOTAL FOR ALL: $ 625.00 TAXI PARKING AIRFARE M ISC/TOLLS BUDGET LINE ITEM: 525-15-5400-1346 X GRANT REIMBURSABLE YES NO x YES NO REQUIRED CERTIFICATION TOTAL: $ 625.00 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Randy Bennett, Public Works Division Manager DEPARTMENT HEAD 04/12/2023 DATE K: \Shared Goodies\Forms\Travel Request Form Date Approved by Finance Committee: 5/1/2023 DATE W'ci lava SIGNED TRAVEL REQUEST CITY OF WATERLOO FINANCE DEPT. LINE ITEM USED FY 23 BUDGETED EXPENDED YTD THIS REQUEST LEFT AFTER THIS REQUEST DATE Original - Clerk/Finance STAFF ONLY 266-17-7120 1345 $3,000.00 $1,370.18 $1,010.96 $618.86 04/20/2023 Copy - Department NAME(S) AND POSITION(S): Tina Schellhorn, Electrical Foreman DATE: 4/19/2023 NAME OF CLASS / MEETING: Network Video Fundamentals & Certification DESTINATION: Des Moines, Iowa DEPARTURE POINT IF NOT WATERLOO: DEPARTURE DATE: 5-2-2023 RETURN DATE: 5-4-2023 DATE(S) OF MEETING: 5/2/2023 to 5/4/2023 PURPOSE OF TRAVEL/TRAINING: Gain knowledge to help with managing, maintaining and expanding traffic video cameras and being certified in Axis cameras system. WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: X CITY VEHICLE AIRFARE PRIVATE VEHICLE DEPARTING FROM: Waterloo ESTIMATE OF COST: 176.96 LODGING 115 MEALS 679 REGISTRATION 40 MILEAGE/FUEL TOTAL FOR ALL: $ 1010.96 TAXI PARKING AIRFARE M ISC/TOLLS BUDGET LINE ITEM: 266-17-7120-1 345 X GRANT REIMBURSABLE YES NO X REQUIRED CERTIFICATION YES NO TOTAL: $ 1010.96 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO DEPARTMENT HEAD 4/19/2023 DATE K: \Shared Goodies\Forms\Travel Request Form Date Approved by Finance Committee: 5/1/2023 DATE N City Clerk Use Only Finance Committee 5/1/2023 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 Airport Department to expend $ 15,000.00 plus est. shipping costs of $ to pay for or purchase updated leakage study for Waterloo Regional Airport. This purchase or expenditure is being made because: airlines use leakage studies to determine passenger volume and market viability. The most recent study for ALO is almost four years old (completed in July 2019). Vendor selected for this purchase: Volaire Aviation n Bids or written quotes were taken on this purchase, as follows: IT Bids or quotes were not taken on this purchase because: The Airport Board and the Air Service Working Group has been working with Volaire Aviation for the past few years to maintain, and hopefully grow, air service @ ALO. 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-29-7700-1319 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ 35,000.00 and the current available balance is $ 18,425.91 Respectfully submitted, Keith Kaspari 4/14/23 5/1/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 5/1/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 $ 8,000.00 plus est. shipping costs of $ to pay for or purchase lease of mowing equipment for 2023 cutting season. This purchase or expenditure is being made because: This is an annual lease of mowing equipment for airfield grass areas. Includes: M20 Rotary Cutter and Z-Series Mower for cutting grass around airfield lights and signs (per FAA requirements). Vendor selected for this purchase: P & K Midwest of Waterloo n Bids or written quotes were taken on this purchase, as follows: IT Bids or quotes were not taken on this purchase because: As in past years, additional requests for bids were not responded to. 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-29-7700-1384 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ 8,000.00 and the current available balance is $ 8,000.00 Respectfully submitted, Keith Kaspari 4/14/2023 (Sc wruc� 5/1/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 5/1/2023 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 $ 4,450.00 plus est. shipping costs of Department to expend $ 0.00 to pay for or purchase Technical support package block of 30 hours with ProWest & Associates for GIS support and project completion. This purchase or expenditure is being made because: ProWest has helped us design and implement our GIS system and is key in maintaining the system. Vendor selected for this purchase: Pro -West & Associates n Bids or written quotes were taken on this purchase, as follows: IT Bids or quotes were not taken on this purchase because: Pro -West and Associates has helped us from design to implementation of our GIS 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 1319 / 322-01-8225 2106 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ 20,000.00 and the current available balance is $ 11,650.22 Respectfully submitted, Chris Youngblut 4/24/2023 Zof 5/1/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 5/1/2023 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 Police Department to expend $ 12,851.66 plus est. shipping costs of $ 60.00 to pay for or purchase 2x Blueridge Level III 24x36 inch ballistic shields 1x Blueridge Level III 23x34 inch rifle rated ballistic shiled This purchase or expenditure is being made because: Because of the rise in major incident in the US the Department is purchasing three level III ballistic shields specifically for patrol use and emergency response. Vendor selected for this purchase: Armor Express n Bids or written quotes were taken on this purchase, as follows: Blueridge Armor $17,949.00 CCG Safety Gear $17,705.00 Armor Express $12,911.66 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-11-1100-2128 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ $29,500.39 and the current available balance is $ $29,500.39 Respectfully submitted, Aaron McClelland, Police Captain 4/17/2023 2U a( 5/1/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 5/1/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 Police Department to expend $ 4,813.70 plus est. shipping costs of $ 0.00 to pay for or purchase five (5) Gamber-Johnson computer docking stations for the Police Department patrol vehicles. This purchase or expenditure is being made because: Five computer docking stations will replace computer mounts that are older and the end of the life cycle. This are mobile computers used by the patrol division squad cars. Vendor selected for this purchase: CDWG n Bids or written quotes were taken on this purchase, as follows: IT Bids or quotes were not taken on this purchase because: CDWG has the State of Iowa bid for Panasonic Toughbook computers as well as the docking stations they rely on. 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-11-1100-2106 Information Systems (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ 33561.75 and the current available balance is $ 33561.75 Respectfully submitted, Aaron P. McClelland, Police Captain 4/13/23 5/ 1 /20 23 (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 5/1/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 (VFD River Rd) Department to expend $ 39,312.00 plus est. shipping costs of $ included to pay for or purchase A VFD for River Road This purchase or expenditure is being made because: River Rd Variable Frequency Drive needs to be replaced 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: Electric Pump is sole proprietor 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 $ 400,000.00 $ 201,685.35 04/06/23 �'cc�yy Nacz, ( 5/1/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 5/1/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 Street Department to expend $ 3,763.75 plus est. shipping costs of $ 0.00 to pay for or purchase Sourcewell - Smart Board MX V3 Pro Series with iQ SBID-MX265-v3-PW 65" LED -backlit LCD This purchase or expenditure is being made because: Smart Board for Street Department Vendor selected for this purchase: CDW-G n Bids or written quotes were taken on this purchase, as follows: n Bids or quotes were not taken on this purchase because: Sourcewell Quote 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: 266-19-7100-2118 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ 3,800.00 and the current available balance is Respectfully submitted, Sheila Steffen 04/18/2023 $ 3,801.37 zuo 5/1/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 5/1/2023 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 Traffic Department to expend $ 5,400.00 plus est. shipping costs of $ 0.00 to pay for or purchase Red LED Signal Light Inserts This purchase or expenditure is being made because: Red signal light inserts have reached end of life and are failing. Vendor selected for this purchase: Mobotrex �■ Bids or written quotes were taken on this purchase, as follows: Mobotrex Davenport, IA $5,400.00 General Traffic Controls Spencer, IA $5,600.00 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: 266-17-7120-1576 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ 26,400.00 and the current available balance is Respectfully submitted, Sheila Steffen 04/19/2023 $ 6,206.04 7> t ZacW 5/1/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) Completed forms should be routed directly to the Finance Dept. FINANCE DEPT. ONLY Finance Committee approval required? YES No —5/1/2023 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 2023 submitted by the Martin Petersen/Code Enforcement 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 525 15 5125 3469 Property Cleanup 15,000.00 525 15 5125 1390 Other Contr. Serv. 15,000.00 TOTAL This amendment is being requested because: Additional funds are needed for mowing. Prior Committee Actions (Dates): 15,000.00 TOTAL 15,000.00 Martin Petersen 4/11/23 'Wet zu_o 5/1/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K:\users\shared goodies\forms\Copy of Budget Amendment Request Form (Apr 2003) Completed forms should be routed directly to the Finance Dept. FINANCE DEPT, ONLY Finance Committee approval required'' YES NO '/1/2023 If so, data approved' City of Waterloo Line -Item Budget Amendment Request Form The Finance Committee of the City CounciI and/or Finance Dept. is hereby requested to authorize the following Iine-item budget amendment for FYE 23 submitted by the Waste Management 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 Prof Code Amount 520 14 5200 3433 sewer usage Fee -3O0,OOO.00 520 14 5200 1571 Machinery & Egsipr ant 300,000.00 Replacement ,Repair TOTAL This amendment is being requested because: T300,000. TOTAL 300,000.00 Extra wear on equipment due to vendor having Pretreatment issues and lack of reliable pretreatment process. Resulting in our equipment having extra wear and tear. Using the increased revenue from the industrial clients surcharges. e Actions (Da (Signatuk Dept. Head o (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K3nserslshared goodiesllormsSCopy of Budget Amendment Request Form (Apr 2003) Completed forms should be routed directly to the Finance Dept. FINANCE DEPT. ONLY Finance Committee approval required? YES NO 5/1 /2023 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 2023 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 3720 Donations 37GFT.0008 _ 7,000.00 010 37 4105 1567 Rec Equip 37GFT.0008 7,000.00 TOTAL This amendment is being requested because: 7,000.00 TOTAL 7,000.00 $2,000 was originally budgeted. We have received $9,295.68 so far this fiscal year. This amendment will more accurately reflect the funds actually received, and possible expenses related to the donation. Prior Committee Actions (Dates): Paul Hutting 4/13/23 ,stwyett mew 5/1/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K:\users\shared goodies\forms\Copy of Budget Amendment Request Form (Apr 2003) Completed forms should be routed directly to the Finance Dept. FINANCE DEPT. ONLY Finance Committee approval required? YES NO 5/1/2023 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 2023 submitted by the Fire 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 12 1400 3498 Sale of Equipment 7,000.00 010 12 1400 1371 Build&Maint 7,000.00 TOTAL $7,000.00 TOTAL $7,000.00 This amendment is being requested because: The funds transferred will go towards the creation of a ladies locker room at Station 6 in pursuit of "reasonable accommodations". Waterloo Fire Rescue currently employs five female firefighters that all hold and utilize a paramedic certification. Station 6 is a three person station that requires a paramedic due to being an ALS Engine and having a reserve ambulance. Currently, the only shower is in unlockable area and the locker room is open. According to the building department, these funds should cover all expenses to mirror the locker room built at Station 3 in 2022. Prior Committee Actions (Dates): (Signature Dept. Head or Designee) Date 5/1/2023 (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K:\users\shared goodies\forms\4-18-23 Station 6 locker room (Apr 2003) Completed forms should be routed directly to the Finance Dept. FINANCE DEPT. ONLY Finance Committee approval required? YES NO 5/1/2023 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 2023 submitted by the Central Garage 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 18 7955 3920 Dept Charges - Fuel _ -45,000.00 010 18 7950 1571 Mach & Equip Repl 45,000.00 TOTAL This amendment is being requested because: -45,000.00 TOTAL 45,000.00 Budget amendment to increase fuel receipts and machinery & replacement parts by $45,000.00 each. Prior Committee Actions (Dates): Sheila Steffen 4/19/23 ,wyeet N 5/1/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K:\users\shared goodies\forms\Copy of Budget Amendment Request Form (Apr 2003) PROJECT BUDGET WORKSHEET - ALL PROJECTS PAGE ONE Project Name City Contract No. Project Manager Memorandum of Understanding- United States Marshals Service- Gang Enforcement & Operations Captain Jason Feaker Project Budget Total $ 1,800.00 1. How will this project be funded? A. Federal Grant Yes 11 No Grant Name CFDA # B. State Grant Yes L� No Grant Name C. City Match Source of Funding D. Other Entities Yes X No Name United States Marshals Service To be assigned by the Finance Dept. Project No. Subproject No. 11 PRO % Paid by federal grant Grant Agreement Number % Paid by state grant Grant Agreement Number % Paid by City % Paid by other entity 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. 100.00% Done None ❑X ❑ Yes No ❑ ❑X ❑ ❑X ❑ ❑X ❑ ❑X ❑ ❑X ❑ ❑X ❑ ❑X 6. Include a brief description of the project in the space below: (REQUIRED) MOU with United States Marshals Service allowing for the repayment of overtime funds used during the investigations & apprehensions of violent fugitives. Page 2 must be attached and signed. K:\shared goodies\forms\Operation Corridor roundup JLEO22-US Marshals Project Budget Worksheet 4-13-23 (1).xls\Page 1 All Projects (Mar 2010) Completed forms should be routed directly to the Finance Dept. FINANCE DEPT. ONLY Finance Committee approval required? YES NO 5/1/2023 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 06/30/2023 submitted by the Housing Authority 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 283 13 5452 3000 Cash 150,000.00 283 13 5452 1706 Hsg Asst Pmts 150,000.00 TOTAL 150,000.00 TOTAL 150,000.00 This amendment is being requested because: Due to HUD's cash management accounting system, and increases in our expenditures due to policy changes, we are anticipating a shortfall in the amount required for our Housing Assistance Payments. We are requesting to use fund balance in the amount of $150,000 to cover HAP expenses through June 30, 2023. Prior Committee Actions (Dates): Julie Dawson 4/24/23 moci 5/1/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K:\users\shared goodies\forms\Copy of Budget Amendment Request Form (Apr 2003) PROJECT BUDGET WORKSHEET- NON -CONSTRUCTION PAGE TWO City Clerk Use Only Committee Approval Date 5/1/2023 Project Name (from page one) Memorandum of Understanding- United States Marshals Service- Gang Enforcement & OperE Department No. project will be budgeted under 11 Activity No. project will be budgeted under 010 11 1150 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 3750 Sale of Bonds 3873 Reimburse for Services EXPENDITURES: To be assigned by the Finance Dept. Project No. 11 PRO Subproject No. (Each column should only include amounts by fund) Fund: 1150 Fund: Fund: Fund: Total 1,800.00 1,800.00 TOTALS $ 1,800.00 $ $ - $ $ 1,800.00 1111 Salaries - Regular 1112 Salaries - Part Time 1315 Education & Training 1345 Travel - Official City 1346 Travel - Prof Training 1390 Contractual Services 1114 Overtime 1573 Safety & Protective Equipment 1,800.00 1,800.00 TOTALS $ 1,800.00 $ $ $ $ 1,800.00 Capt. Aaron McClelland 4/13/202' qt64,e-tt Mac( 5/1/2023 (Signature Dept. Head) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Operation Corridor roundup JLEO22-US Marshals Project Budget Worksheet 4-13-23 (1).xls\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: 5/1/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 2023 submitted by the Leisure Services - Young Arena 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 4500 3476 Ice Rent 14,000.00 010 37 4500 1319 Other Prof. Srv. 14,000.00 TOTAL 14,000.00 TOTAL 14,000.00 This amendment is being requested because: Amendments are being made to fix current line item overages and prepare for anticipated expenses and revenues thru June 30, 2023. Prior Committee Actions (Dates): Paul Huting 4/21/23 5/1/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K:\users\shared goodies\forms\Copy of Budget Amendment Request Form (Apr 2003) Completed forms should be routed directly to the Finance Dept. FINANCE DEPT. ONLY Finance Committee approval required? YES NO 5/1/2023 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 2023 submitted by the Leisure Services - Young Arena 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 4500 3471 Arena Revenue _ 71,000.00 010 37 4500 1400 Utilities 35,500.00 1371 Building & Grounds 4,375.00 1375 Auto Equip Repair 4,000.00 1388 Ice System 11,300.00 1390 Other Contractual 3,000.00 1555 Minor Equip 1,000.00 1561 Office Supplies 1,000.00 1571 Mach Equip Parts 1,000.00 1581 Paint Supplies 1,525.00 1 1 1 1 Salaries -- Regular 7,800.00 1114 Time & Half 500.00 TOTAL This amendment is being requested because: 71,000.00 TOTAL 71,000.00 Amendments are being made to fix current line item overages and prepare for anticipated expenses and revenues thru June 30, 2023. Prior Committee Actions (Dates): Paul Huting 4/21/23 N6449 5/1/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K:\users\shared goodies\forms\Copy of Budget Amendment Request Form (Apr 2003) Completed forms should be routed directly to the Finance Dept. FINANCE DEPT. ONLY Finance Committee approval required? YES NO 5/1/2023 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 2023 submitted by the Leisure Services - Young Arena 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 4500 3481 Concession Revenue 99,000.00 010 37 4500 3830 Unrestricted gifts 1,500.00 3722 Refunds 1,500.00 1553 Merch. Resale 34,000.00 1112 Part -Time 46,400.00 1373 Fix Plant 5,000.00 1541 Janitorial Supplies 2,500.00 1504 Credit Card Fees 2,600.00 1400 Utilities 5,500.00 TOTAL This amendment is being requested because: 99,000.00 TOTAL 99,000.00 Amendments are being made to fix current line item overages and prepare for anticipated expenses and revenues thru June 30, 2023. Prior Committee Actions (Dates): Paul Huting 4/21/23 Tuerm NacW (Signature Dept. Head or Designee) Date 5/1/2023 (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K:\users\shared goodies\forms\Copy of Budget Amendment Request Form (Apr 2003) Completed forms should be routed directly to the Finance Dept. FINANCE DEPT. ONLY Finance Committee approval required? YES NO 5/1/2023 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 2023 submitted by the Finance 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 03 9050 3000 Cash _ 2,500,000.00 010 03 9050 2700 Transfers Out 2,500,000.00 01ARPA. 290 03 9050 6050 Transfers In 2,500,000.00 290 03 6105 2103 Engineering BKBN2 100,447.00 290 03 6105 2103 Engineering EDAFIBER 44,509.00 290 03 6105 2103 Engineering FTTHDSN 2,275,044.00 290 03 6105 2103 Engineering MIDMILE 80,000.00 TOTAL This amendment is being requested because: Prior Committee Actions (Dates): 5,000,000.( TOTAL 5,000,000.0 Bridgett Wood, Finance Manager 4/25/23 W 2u 5/1/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K:\users\shared goodies\forms\Copy of Budget Amendment Request Form (Apr 2003) Completed forms should be routed directly to the Finance Dept. FINANCE DEPT. ONLY Finance Committee approval required? YES NO 5/1/2023 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 2023 submitted by the Finance 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 101 08 6205 3000 San Marnan Cash 143,134.00 101 08 9050 2700 Transfers Out 143,134.00 101 08 6210 3000 Rath Cash 122,345.00 101 08 9050 2700 Transfers Out 122,345.00 101 08 6220 3000 NE Site Cash 39,402.00 101 08 9050 2700 Transfers out 39,402.00 101 08 6250 3000 Martin Cash 416.00 101 08 9050 2700 Transfers Out 416.00 101 08 6260 3000 Midport Cash 1,157,191.00 101 08 9050 2700 Transfers out 1,157,191.00 426 08 9050 6050 Transfers In 1,462,488.00 426 08 6205 2103 Engineering 143,134.00 426 08 6210 1396 Prop Demo 122,345.00 426 08 6220 2103 Engineering 39,402.00 426 08 6250 2104 Legal 416.00 426 08 6260 2144 Land Impr 1,157,191.00 TOTAL This amendment is being requested because: 2,924,976.( To budget for anticipated transfers from the TIF Fund Prior Committee Actions (Dates): TOTAL 2,924,976.0 Bridgett Wood, Finance Manager 4/25/23 Tu4ett Z3acW 5/1/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K:\users\shared goodies\forms\Copy of Budget Amendment Request Form (Apr 2003) Completed forms should be routed directly to the Finance Dept. FINANCE DEPT. ONLY Finance Committee approval required? YES NO 5/1/2023 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 2023 submitted by the Finance 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 101 08 6270 3000 Downtown Cash 169,220.00 101 08 9050 2700 Transfers Out 169,220.00 101 08 6280 3000 Logan Cash 474,152.00 101 08 9050 2700 Transfers Out 474,152.00 101 08 6260 3000 Midport Cash 1,000,000.00 101 08 6260 1358 Econ Development 1,000,000.00 426 08 9050 6050 Transfers In 643,372.00 426 08 6270 2103 Engineering 169,220.00 426 08 6280 2103 Engineering 474,152.00 TOTAL This amendment is being requested because: 2,286,744.( TOTAL To budget for anticipated transfers from the TIF Fund; Budget for estimated TIF expense increases expected through June 30, 2023 Prior Committee Actions (Dates): 2,286,744.0 Bridgett Wood, Finance Manager 4/25/23 5/1/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K:\users\shared goodies\forms\Copy of Budget Amendment Request Form (Apr 2003) Completed forms should be routed directly to the Finance Dept. FINANCE DEPT. ONLY Finance Committee approval required? YES NO 5/1/2023 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 2023 submitted by the FINANCE 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 03 8960 3722 Refunds _ 30,000.00 010 03 8960 1368 Medical Claims 30,000.00 010 03 8960 3000 Cash 100,000.00 010 03 8960 1365 Indemnity Pmts 40,000.00 010 03 8960 1368 Medical Claims 60,000.00 TOTAL This amendment is being requested because: 130,000.00 TOTAL Budget for estimated work comp expense increases expected through June 30, 2023 Prior Committee Actions (Dates): 130,000.00 Bridgett Wood, Finance Manager 4/25/23 5/1/2023 J (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K:\users\shared goodies\forms\Copy of Budget Amendment Request Form (Apr 2003) Completed forms should be routed directly to the Finance Dept. FINANCE DEPT. ONLY Finance Committee approval required? YES NO If so, date approved: 5/1/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 2023 submitted by the Finance 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 01 6920 3111 Hotel/Motel Tax 01HMT.WCVB 100,000.00 010 01 6920 1393 Contributions 01HMT.WCVB 100,000.00 TOTAL This amendment is being requested because: 100,000.00 Hotel/Motel revenue is projected to be over budget. Prior Committee Actions (Dates): TOTAL 100,000.00 Bridgett Wood, Finance Manager 4/24/23 (WrJt 2uai,q° 5/1/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K:\users\shared goodies\forms\Copy of Budget Amendment Request Form (Apr 2003) Completed forms should be routed directly to the Finance Dept. FINANCE DEPT. ONLY Finance Committee approval required? YES NO If so, date approved: 5/1/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 2023 submitted by the Planning 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 08 6105 3000 Cash _ 304,012.00 010 08 6105 2140 Property Acq. 304,012.00 TOTAL This amendment is being requested because: 304,012.00 TOTAL 304,012.00 To use carryforward cash from Sale and Acquisition of HCC Homes project to purchase 2 homes this FY. Prior Committee Actions (Dates): Noel Anderson 4/24/23 5/1/2023 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K:\users\shared goodies\forms\Copy of Budget Amendment Request Form (Apr 2003)