Loading...
HomeMy WebLinkAboutApproved Documents - 2/1/2021City Clerk Use Only Finance Committee Approval Date 2/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 $ 11,903 plus est. shipping costs of $ to pay for or purchase Airport General Liability Insurance for CY-2021. This purchase or expenditure is being made because: Liability insurance is necessary for risk management of Airport operations. Vendor selected for this purchase: �■ Bids or written quotes were taken on this purchase, as follows: The City has bid Insurance and PDCM is currently the City's insurance agent. PDCM has bid our insurance through several aviation insurance companies. 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 ElBonds ❑ Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 010-29-7700-1364 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the current available balance is Respectfully submitted, Keith D. Kaspari 1/12/2021 $ 10,770 + 1,133 amendment $ 11,903 Michelle Weidner 2/1/2021 (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 2/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 Code Enforcement $ 2,500.00 plus est. shipping costs of $ Removal of a hazardous tree at 209 Julie Court. Department to expend to pay for or purchase This purchase or expenditure is being made because: Court ordered removal - charge back to the property owner. Vendor selected for this purchase: Owens Property Service LLC �■ Bids or written quotes were taken on this purchase, as follows: Owens Property Service LLC $2,500.00 Affordable Tree Service $2,850.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: 525-15-5125-1390 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ 50,000.00 and the current available balance is $ 29,780.04 Respectfully submitted, Martin Petersen January 13, 2021 M/cke//e eaner 2/1/2021 (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 2/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 Engineering $ 4,692.60 plus est. shipping costs of $ 0.00 Autodesk AEC software Department to expend to pay for or purchase This purchase or expenditure is being made because: This is the software that Engineering uses to design our reconstruction, overlay, sidewalk and misc. projects. Vendor selected for this purchase: DTL Solutions Bids or written quotes were taken on this purchase, as follows: Bids or quotes were not taken on this purchase because: Single source provider for all government agencies Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: CGeneral Fund 0 Road Use Tax 0 Sewer — Sanitation ElBonds 0 Federal/other grants 0 Other (specify) LOST This expenditure is to be coded to the following budget line -item: 205-07-7830-1520 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ 8,000.00 and the current available balance is $ 6,655.56 Respectfully submitted, Jamie Knutson 01/14/2021 Michelle Weidner 2/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K;Ishared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) INVOICE Invoice #: Date: Order #: RFQ #: Terms: 4930540A 1/14/2021 4930540 Net 30 Days Credit Card COD 2411 Dulles Corner Park Suite 800 Herndon, VA 20171 Sales Rep: Phone: Fax: Email: Web: Ervin So (703) 708-9675 (703) 709-8450 sales@dlt.com http://www.dit.com/ r Bill To Address: Name: Jamie Knutson Agency: Waterloo, City of (IA) Address' 715 Mulberry Street City/State/Zip: Waterloo, IA 50703 Email: jamie.knutson©gwaterloo-ia.org Shp To Address: Waterloo, City of (IA) 715 Mulberry Street Waterloo, IA 50703 Shipping Instructions: Item Part# 1 Mfg # Description Qty 1 Contract Unit Price Ext Price 1 9701-1008733 02H11-009608-L819 Architecture Engineering & Construction Collection Government Single - user Annual Subscription Renewal Switched From Maintenance (Switched between May 2019 - May 2020 and Ongoing) 4 $1,173.15 $4,692.60 OM Total Price: $4,692.60 By ACH/Wire DLT Solutions, LLC Bank of America ABA #111000012 Acct #4451063799 SWIFT Code: BOFAUS3N Contact: ACH 301-517-3118 1455 Market Street San Francisco, CA 94109 By Regular Mail OLT Solutions, LLC P.O. Box 743359 Atlanta, GA 30374-3359 By Overnight Mail Bank of America Lockbox Services DLT Solutions, LLC Lockbox 743359 6000 Feldwood Road College Park, GA 30349 301-517-3118 For Questions regarding this invoice or payment via electronic funds transfer, please contact Collections at (888) 358-9346 Invoices not paid within terms are subject to a 1.5% per month interest charge. TIN: 541599882 CA Reseller: SCOHB 97-695811 Strictly Confidential Page 1 of 1 City Clerk Use Only Finance Committee Approval Date 2/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 $ 3,819.88 plus est. shipping costs of $ 30.00 to pay for or purchase NI -HARD IMPELLER PART TO REPAIR 4B2J PUMP TRIM FOR GRIT PUMP IN HEADWORKS BUILDING This purchase or expenditure is being made because: THE GRIT PUMP IN THE HEADDWORKS BUILING IS IN NEED OF REPAIR. Vendor selected for this purchase: ■ SMITH & LOVELESS,INC. Bids or written quotes were taken on this purchase, as follows: Bids or quotes were not taken on this purchase because: SMITH & LOVELESS, INC. IS THE SOLE PROVIDER FOR PARTS FOR THE GRIT PUMPS. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: General Fund Bonds Road Use Tax Federal/other grants • Sewer Other (specify) This expenditure is to be coded to the following budget line -item: 520-14-5200-1571 Sanitation (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the current available balance is Respectfully submitted, BRIAN BOWMAN 01/14/21 $ 400,000.00 $ 185,520.76 Michelle Weidner 2/1/2021 (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 2/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 $ 7857.00 plus est. shipping costs of $ 0 to pay for or purchase Replacement HMI screen for West Commercial Street Storm Water Station Waterloo, IA This purchase or expenditure is being made because: The HMI screen went bad and is needed to see and control all pumps at the West Commercial Street Storm Water Station Waterloo, IA . Vendor selected for this purchase: Electric Pump n Bids or written quotes were taken on this purchase, as follows: IT Bids or quotes were not taken on this purchase because: Electric Pump is the sole provider for screen needed and they provide the necessary training. 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 and the current available balance is Respectfully submitted, $ 400,000 $ 193,377.76 Brian Bowman- 01/14/21 Micelle bVeidger 2/1/2021 (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 2/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 $ 7,002.30 plus est. shipping costs of $ 150.67 Hydraulic Valve, Pump and Labor to repair Aerial Bucket Truck Traffic Department to expend to pay for or purchase This purchase or expenditure is being made because: Altec service technician replaced valve and pump on aerial bucket truck (only Vendor in area to repair, replace and inspect aerial truck) Vendor selected for this purchase: Altec �■ Bids or written quotes were taken on this purchase, as follows: Altec St. Joseph, MO $7,002.30 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-7102-1374 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the current available balance is Respectfully submitted, Sandie Greco 1/111/2021 $ 1,600.00 $ 8,955.00 M/chelle L4/ezdner 2/1/2021 (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 2/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 Tri-County/Police Department to expend $ 5,095.84 plus est. shipping costs of $ to pay for or purchase Additional workstations at the Tri-County Drug Enforcement Task Force office. This purchase or expenditure is being made because: This expenditure has been approved by the Tri-County Drug Enforcement Task Force board. Vendor selected for this purchase: Storey Kenworthy n Bids or written quotes were taken on this purchase, as follows: IT Bids or quotes were not taken on this purchase because: This is the State of Iowa bid price. 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-11-1160-1512 Tri-County Forf TRIF (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ 120,000.00 and the current available balance is $ 14,679.21 Respectfully submitted, Dave Mohlis, Police Captain 01 /11 /21 /ftchelle Wetdne' 2/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) CONSTRUCTION PROJECT BUDGET WORKSHEET PAGE TWO City Clerk Use Only Committee Approval Date 2/1/2021 Project Name (from page one) Midport Blvd to Betsworth Water Main Improvements Department No. project will be budgeted under 08 Activity No. project will be budgeted under 6260 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: To be assigned by the Finance Dept. Project No. 08MIDPT Subproject No. WTR20 (Each column should only include amounts by fund) Fund:426 Fund: Fund: Fund: Total $ 364,400.00 $ 364,400.00 TOTALS $ 364,400.00 $ $ $ $ 364,400.00 2103 Engineering & Consulting $ 89,400.00 $ 89,400.00 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 2173 Water Line Const 275,000.00 275,000.00 TOTALS $ 364,400.00 $ $ $ $ 364,400.00 Jamie Knutson 1/14/2021 Michelle W eidner 2/1/2021 (Signature Dept. Head) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\1033_Project_Budget_Worksheet (2).xls\Page 2 (Constr Proj) (Mar 2010) PROJECT BUDGET WORKSHEET - ALL PROJECTS PAGE ONE Project Name City Contract No. Project Manager Project Budget Total $ Waterloo Regional Airport Water Main Improvements 1033 Wayne Castle 1. How will this project be funded? A. Federal Grant Yes No Grant Name B. State Grant Yes No Grant Name CFDA # C. City Match Source of Funding D. Other Entities Yes No Name To be assigned by the Finance Dept. Project No. 08MIDPT Subproject No. WTR20 % 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. Done None ❑ ❑X Yes No ❑ 0 ❑ ❑X ❑ ❑X ❑ 0 ❑ ❑X ❑ ❑X ❑ ❑X 6. Include a brief description of the project in the space below: (REQUIRED) Installation of water main from MidPort Blvd to Betsworth Drive for private development at the Airport. Page 2 must be attached and signed. K:\shared goodies\forms\1033_Project_Budget_Worksheet (2).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 If so, date approved: 2/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 2021 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 3873 Reimb for Services 11GRT.ODEF 7,500.00 010 11 1150 1114 Overtime 7,500.00 TOTAL $7,500.00 TOTAL $7,500.00 This amendment is being requested because: This is to conform with the City's budget line item control policy. See attached paper worked, continued funding for Kid Kilo WC-IAN-0132 T-32 for FY21. Prior Committee Actions (Dates): Michelle 1ll//eidner 2/1/2021 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K:\users\shared goodies\forms\Budget_Amendment_ODEF_continued_funding_FY21_1-25-2021 (1).xls (Apr 2003) PROJECT BUDGET WORKSHEET - ALL PROJECTS PAGE ONE Project Name Waterloo Police Department's Covid-19 Pandemic Initiative City Contract No. Project Manager Captain Mohlis Project Budget Total $ 29,000.00 1. How will this project be funded? To be assigned by the Finance Dept. Project No. 11 GRT Subproject No. COVID2 A. Federal Grant Yes X No CFDA # 16.034 % Paid by federal grant 100.00% Grant Name Byrne -Justice Assistance Grant Program (JAG) Grant Agreement Number B. State Grant Yes X No % Paid by state grant Grant Name Pass thru Iowa Coronavirus Emergency Supplements Grant Agreement Number Grant #20-CESF-38: 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. Done None ❑X ❑ Yes No ❑ ❑X ❑ ❑ ❑ ❑ ❑ ❑X ❑ ❑X ❑ 0 ❑ ❑X 6. Include a brief description of the project in the space below: (REQUIRED) These funds will be used to create appropriate socially distant workspaces and allow for remote work with the purchase of offic( equipment & laptop computers for the Waterloo Police Department's Investigation Division. Page 2 must be attached and signed. K:\shared goodies\forms\Byrne-JAG_COVID-19_Pandemic_Grant_(1).xls\Page 1 All Projects (Mar 2010) PROJECT BUDGET WORKSHEET- NON -CONSTRUCTION PAGE TWO City Clerk Use Only Finance Committee Approval Date 2/1/2021 Project Name (from page one) Waterloo Police Departments Covid-19 Pandemic Initiative Department No. project will be budgeted under 11 Activity No. project will be budgeted under 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 3373 - Federal pass-thru to Iowa EXPENDITURES: To be assigned by the Finance Dept. Project No. 11GRT Subproject No. COVID2 (Each column should only include amounts by fund) Fund: Fund: Fund: Fund: 010 Total 29,000.00 29,000.00 TOTALS $ 29,000.00 $ $ $ $ 29,000.00 1111 Salaries - Regular 1112 Salaries - Part Time 1315 Education & Training 1345 Travel - Official City 1346 Travel - Prof Training 1390 Contractual Services 2106 Computer Equipment 2118 Office Furniture & Equipmei 14,000.00 14,000.00 15,000.00 15,000.00 TOTALS $ 29,000.00 $ $ $ $ 29,000.00 Dave Mohlis 1/22/2021 Michelle W eictner 2/1/2021 (Signature Dept. Head) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Byrne-JAG_COVID-19_Pandemic_Grant_(1).xls\Page 2 (Donat or NON-constr) (Mar 2010) PUBLIC WORKS SANITATION DEPARTMENT REFUND REQUEST GARBAGE/YARD WASTE Name: Payvk &\eV Address: 1515 UJ , 51* Sf City/State/Zip: " "4+ (°0 Service Address: 1515 to, 5Th '$} Date: Phone: 9 07- g5. - jc Sb Refund Amount Requested: $ - (CO **Documentation Included: v Yes No ** All requestforrefunds required proof of payment before refunds are processed. +,, Comments: � 1 r reco-rc& 3V re.INLOV& (oT (, ,rG4 i'itft,STc eak 6,5 SQ,vvtOver +o VJcr Way k a rt to Wa-o bct+ W".s o+ amoveL o-P her acumiutt Signature/Sanitation Department Date Confirmed Refund Amount: $ q(,tgo Confirmed w/Water Works: v Yes No 2/1 /2021 Mzchelle Weaver Finance Signature Date Refund Amount Paid: $ 9.60 To whom it may concern, 11-16-2020 This is a request for a refund on my sanitaton bill. I was overcharged for the use of a recycle bin that I do not have. It was picked up, at my request, by your company when I moved in at the end of August The refund is for $9.60. Thank you, Pam Turner 1515 W. 5th St. Waterloo, is 50702 907-952-1950 WATERLOO WATER WOR!« 325 Sycamore Street P.O. Box 27 Waterloo, Jowa 50704 STATEMENT OF SERVICES Phone: (319) 232-6280 ew:l eter;oovrater,atg f'aoe 1 of 1 ACCOUNT SUMMAAY Customer Name: Account Number: 5ervico Address: Pam Turner 107595-549306 1515 W 5Tt1 ST Billing Frequency: Billing Date: Billing Due Date: Quarterly 11/10/2020 12/04I2020 Waterloo Water'7•Jor s Services `7dater Water Service Excise Tax Water Works Subtotal City of Waterloo Services Sanitary Sevier Storm Water Fee Garbage Yard Waste / Recycle Site Maintenance Fee Yard Waste / Recycle Curbside City of Waterloo Subtotal S21,77 S 1.31 S23,08 S36.85 S10.08 327.81 S11.83 5'4.6J S96.15 Credits/Payments Deposit Charged ."later Works Subtotal -$105.00 $105.00 S23.08 City of Waterloo Subtotal $96.15 Total Curre.nt Service Charges $119.23 Total Amount Oue S119.23 Amount Oue After 12104/2020 $125.12 oat-4/2020 10►2312020 I.1 Actual t9 Actual 0 s m h LOGAN AVENUE HY-VEE IS NOW ABLE TO TAKE PAYMENTS CURRENT BILLS Please detach and return the bottom portion with your payment. See reverse side for additional information WATERLOG WALE( WORKS P.O. BOA 17 Waterloo, to va 50704 Phone:(319)232-62110 N Account Number: 107595-549306 Total Amount Due: 119.23 Amount Duo After : 125.12 Billing Due Date: 12/04/2020 Amount Enclosed: