The URL can be used to link to this page

Home My WebLink AboutApproved Documents - 11/23/2020 City Clerk Use Only Finance Committee Approval Date 11/23/2020 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 Building Maint Department to expend $ 3,945 plus est. shipping costs of $ to pay for or purchase This purchase or expenditure is being made because: Replace existing garage heaters at Hazmat Training Center Vendor selected for this purchase: Plumb Tech Inc. F■ Bids or written quotes were taken on this purchase, as follows: Plumb Tech Inc. - $3,945 Young Plumbing - $14,630 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: 418-22-1400-2152 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 20,000 and the current available balance is $ 18,278.12 Respectfully submitted, Greg Ahlhelm 11/13/2020 Michelle Weidner 11/23/2020 (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/23/2020 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 Community Development Department to expend $ 13,043.97 plus est. shipping costs of $ to pay for or purchase 8 Dell Latitude 5510 and 8 Dell docks= $12,509.76 and 3 Dell Monitors =$534.21 This purchase or expenditure is being made because: With the ongoing pandemic-measures have been taken to insure that staff stays safe, telecommuting has been approved as a viable work option.The purchase of laptops will ensure that staff is able to work remotely. Vendor selected for this purchase: Dell Bids or written quotes were taken on this purchase, as follows: F■ 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 EI Bonds ❑- Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 224 32 5851.1516 32CARE1.ADMN (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 14,000 and the current available balance is $ 14,000 Respectfully submitted, Rudy D. Jones Mlcheae Wezdler 11/23/2020 (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/23/2020 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 $ 13,345.36 plus est. shipping costs of $ to pay for or purchase complete emergency lighting package along with radio, siren, scene lighting and command zone. This purchase or expenditure is being made because: We have purchased a new brush truck and we are outfitting it with emergency lighting, scene lighting, radio, opticom, siren package, and command zone. Vendor selected for this purchase: Keltek Incorporated F■ Bids or written quotes were taken on this purchase, as follows: We are utilizing pricing through the Iowa Department of Administrative Services Whelen Products Master Agreement aka "State Bid" that was awarded to Keltek Inc. 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-12-1410 2112 Fire Fighting Equip (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 68,000 and the current available balance is $ 66,462 Respectfully submitted, Pat Treloar 11-18-20 M«-hel% l Azdner 11/23/2020 (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/23/2020 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 $ 2,500.00 plus est. shipping costs of $ to pay for or purchase renewal of annual subscription to TreeKeeper Software This purchase or expenditure is being made because: TreeKeeper software is used to manage Waterloo's tree resources. Vendor selected for this purchase: Davey Resource Group Bids or written quotes were taken on this purchase, as follows: F■ Bids or quotes were not taken on this purchase because: Davey Resource Group's TreeKeeper software was chosen in 2012 to manage Waterloo's tree inventory after evaluating all vendors and bids. 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-4100 1319 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 14,552.00 and the current available balance is $ 13,395.45 Respectfully submitted, Paul Huting 11/17/2020 Michelle Ve&ke; 11/23/2020 (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/23/2020 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 $ 15,498.00 plus est. shipping costs of $ 0 to pay for or purchase three year NetMotion software agreement for connectivity to patrol car computer systems. This purchase or expenditure is being made because: Netmotion is used to connect the patrol cars to the station computer network. Vendor selected for this purchase: CDWG Bids or written quotes were taken on this purchase, as follows: F■ Bids or quotes were not taken on this purchase because: NetMotion only sells to vendors. CDWG is the state bid vendor for NetMotion. 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 PIS ($13,305)/010-11-1105-1520($2,293) (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 80,000.00/110,355.00 and the current available balance is $ 51,971.24/89,364.50 Respectfully submitted, Dave Mohlis, Police Captain 11-10-20 Michelle INezdn r 11/23/2020 (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/23/2020 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 $ 26,999.00 plus est. shipping costs of $ 0 to pay for or purchase Purchase of a 2021 Chevrolet Traverse SUV for the Tri-County Drug Enforcement Task Force. This purchase or expenditure is being made because: The Tri-County Drug Enforcement Task Force has approved the purchase of a replacement vehicle for the enforcement unit. Vendor selected for this purchase: Karl Chevrolet Bids or written quotes were taken on this purchase, as follows: F■ Bids or quotes were not taken on this purchase because: Karl Chevrolet has the State of Iowa bid for Chevrolet vehicles for government entities. 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 El Sanitation ❑ Bonds ❑ Federal/other grants ❑E Other(specify) TRI County Forf. This expenditure is to be coded to the following budget line-item: 010-11-1160-1512 Tri-County TRIF (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 180,000.00 and the current available balance is $ 21,823.73 Respectfully submitted, Dave Mohlis, Police Captain 11-16-20 M,6-hea& Wetdncr 11/23/2020 (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/23/2020 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,045.24 plus est. shipping costs of $ to pay for or purchase WeatherSentry- Public Safety Edition - NEXRAD Radar, Local, Regional & Full US Radar Coverage Addition of the ONLINE Platinum ROADCAST PAVEMENT Transportation Edition This purchase or expenditure is being made because: Storm tracking, smart phone application, precipitation timing for snow storms Including the roadcast pavement transportation edition. Vendor selected for this purchase: DTN F■ Bids or written quotes were taken on this purchase, as follows: DTN - WeatherSentry OnLine Bids or quotes were not taken on this purchase because: Prior Committee Actions (Dates): $2,791.20 approved by Finance on 10/26/2020 Please check the following box(es)as appropriate to describe the funding for this expense: ❑ General Fund ❑0 Road Use Tax ❑ Sewer F—] Sanitation ElBonds ❑ Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 266-19-7200-1390 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 3,500.00 and the current available balance is $ 3,500.00 Respectfully submitted, Sandie Greco 11/17/2020 Miche«e Ve&Ziter 11/23/2020 (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/23/2020 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,485.00 plus est. shipping costs of $ to pay for or purchase 1 - Remote Solar Flasher Assembly- 2 Channel This purchase or expenditure is being made because: To replace remote flasher that failed on Greenhill Road approaching the signalized intersection of Progress & Greenhill (only vendor to supply same model that failed) Vendor selected for this purchase: Traffic Control Corporation F■ Bids or written quotes were taken on this purchase, as follows: Traffic Control Corporation Ankeny, Iowa $5,485.00 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: 419-17-7161-2125 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 40,000.00 and the current available balance is $ 40,000.00 Respectfully submitted, Sandie Greco 11/18/2020 Michelle WelAe;^ 11/23/2020 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) PROJECT BUDGET WORKSHEET- NON-CONSTRUCTION PAGE TWO City Clerk Use Only Finance Committee Approval Date 11/23/2020 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 5852 Project No. 32WHT Subproject No. Various (Each column should only include amounts by fund) Fund:_ Fund: Fund: Fund: 426 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 30,000.00 30,000.00 3361 State Grant - 3720 Donations- Restricted - 3750 Sale of Bonds - 3905 TIF Revenue - TOTALS $ 30,000.00 $ - $ - $ - $ 30,000.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 30,000.00 30,000.00 1393 Contributions and Subsidy - 1516 Minor Computer Equipment - 1520 Computer Software - 1561 Office Supplies - TOTALS $ 30,000.00 $ - $ - $ - $ 30,000.00 RUDY JONES 11/16/2020 Michelle veldner 11/23/2020 (Signature Dept. Head) Date (Signature Finance Dept. Review) Date KAshared good ies\forms\Waterloo_Housing_Trust_Fund_B udget_Worksheet(1).xls\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. 32WHT Project Budget Total $ 30,000.00 Subproject No. Various 1. How will this project be funded? A. Federal Grant Yes = No 0 CFDA# % Paid by federal grant Grant Name Grant Agreement Number 20-LHTF-06 Trust F 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 0 No 0 % 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) Q ❑ 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? El El 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 El 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) These funds will be used to supplement our Emergency Repair program. Page 2 must be attached and signed. K:\shared good ies\forms\Waterloo_Housing_Trust_Fund_Budget_Worksheet(1).xls\Page 1 All Projects (Mar 2010)