The URL can be used to link to this page

Home My WebLink AboutSupplemental Attachments - 12/11/2017City of Waterloo Finance Committee Open Invoice Report Fok Jecember ,„,1, 201 Finance Committee Accounts Payable Open Invoice Report Total As of Friday, December o8, 2017 EFT Transactions: Wellmark Weekly Claims Wellmark Weekly Claims Wellmark Monthly Claims ISubtotal - as of Monday, December 11, 2017 Adjust United Rentals 2,253,156.39 206,897.13 168,540.58 54,483.20 (65.99) Workers Compensation Issued by TPA Housing Authority Housing Assistance EFT's Housing Authority Housing Assistance EFT's Payroll 'Bill Payment Total - Monday, December 11, 2017 2,683,011.31 3,141.02 7,279.33 1,697,465.01 Payment to Council members or related entities: 4,390,896.67 Sent over 113017 TRAVEL REQUEST CITY OF WATERLOO NAME(S) AND POSITION(S): (2) Firefighters DATE: 113017 FINANCE DEPT. STAFF ONLY LINE ITEM USED a/,,/,2 1 Vat) /''/c FYMSi BUDGETED 350o EXPENDED YTO THIS REQUEST LEFT AFTER THIS REQUEST 79 NAME OF CLASS / MEETING: Arson Investigation School DESTINATION: �ri'Il,R' DEPARTURE POINT IF NOT WATERLOO: DEPARTURE DATE: March 19, 2018 RETURN DATE: March 30, 2018 DATE(S) OF MEETING: March 19-30, 2018 PURPOSE OF TRAVEL: Attend the State of Iowa Basic Fire/Arson Investigation School for Certification as an Investigator. WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: x COST $ YES NO METHOD OF TRAVEL: x CITY VEHICLE AIRFARE DEPARTING FROM: PRIVATE VEHICLE ESTIMATE OF COST: $550.00 LODGING $250.00 MEALS $600.00 REGISTRATION MILEAGE/FUEL TOTAL FOR ALL: $ $1,400 TAXI PARKING AIRFARE MISC/TOLLS BUDGET LINE ITEM: 010-12-1400-1346 YES NO x YES NO GRANT REIMBURSABLE REQUIRED CERTIFICATION TOTAL: $ $700.00 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF W 00 CaLS-2 DEPARTMENT HEAD C__ Lit n DATE DATE I APPROVE THIS TRAVEL REQUEST MAYOR T I!' AVEL REQUEST CITY OF WATERLOO FINANCE DEPT. STAFF ONLY LINE ITEM USED ()/t) a�j 5/00 /3/6, FY< -)0/5 BUDGETED WO EXPENDED YTD THIS REQUEST /0' f LEFT AFTER THIS REQUEST DATE 79-x.) Original - Clerk/Finance Co. - De.artment NAME(S) AND POSITION(S): Jennifer Sparks, Permit Writer DATE: 11/30/2017 NAME OF CLASS / MEETING: ICC Residential Plans Examiner Exam DESTINATION Coralville, Iowa DEPARTURE POINT IF NOT WATERLOO DEPARTURE DATE: 12/13/2017 RETURN DATE: 12/13/2017 DATE(S) OF MEETING: 12/13/2017 PURPOSE OF TRAVEL/TRAINING Required certification WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: x COST $ YES NO METHOD OF TRAVEL: x CITY VEHICLE AIRFARE DEPARTING FROM: PRIVATE VEHICLE ESTIMATE OF COST: LODGING TAXI MEALS PARKING 199.00 REGISTRATION AIRFARE MILEAGE/FUEL MISC/TOLLS TOTAL FOR ALL: $ 199.00 BUDGET LINE ITEM: 010-22-5100-1346 X GRANT REIMBURSABLE YES NO X YES NO REQUIRED CERTIFICATION TOTAL: $ 199.00 PER PERSON I BELIEVE THIS TRIP SERVES A PUB IC - AND IS NECESSARY ANDDBENEFICI T CITY OF WATERLOO DEPARTMENT HEAD URPOSE THE I APPROVE THIS TRAVEL REQUEST (LAA ......LQA/6 MAYOR 2l‘i lo DATE DATE K:1Shared Goodies\Forms\Travel Request Form January 2010 TRAVEL REQUEST CITY OF WATERLOO FINANCE DEPT. STAFF LINE ITEM USED O(() FY 20! .gBUDGETED EXPENDED YTD THIS REQUEST LEFT AFTER THIS REQUEST DATE Original - Clerk/Finance ONLY dvcru 36ra /,2- '(7 Co. De•artment NAME(S) AND POSITION(S): Chief Pat Treloar, Lieutenant Hernandez, HiPAA Specialist Erica Christiansen DATE: December 4, 2017 NAME OF CLASS / MEETING: ESO WAVE interactive conference DESTINATION: Austin, TX DEPARTURE POINT IF NOT WATERLOO: DEPARTURE DATE: January 31, 2018 RETURN DATE: February 2, 2018 DATE(S) OF MEETING: February 1 and 2nd PURPOSE OF TRAVEL/TRAINING: ESO is the software that WFR uses for our ePCR (electronic patient care reporting) and our analytics for all EMS calls for service. This software also merges with our billing company's software. This conference is an interactive experience with workshops for advanced analytics as well as deciphering data using Adhoc reporting. In addition ESO recently purchased FIREHOUSE software (which WFR uses), and the conference will have workshops on how the merger will affect current FIREHOUSE users. NEMSiS (national EMS information system) and EMS Vision 2050 will be explained and covered. WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: X CITY VEHICLE X AIRFARE DEPARTING FROM: PRIVATE VEHICLE ESTIMATE OF COST: $1,100 $175.00 $895.00 LODGING 50.00 TAXI MEALS 35.00 PARKING REGISTRATION $1,345.00 AIRFARE MILEAGE/FUEL MISC/TOLLS TOTAL FOR ALL: $ $3,600.00 BUDGET LINE ITEM: 010-12-1410-1346 X GRANT REIMBURSABLE YES NO YES NO X REQUIRED CERTIFICATION TOTAL: $ $1,200.00 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NEC R ' ND : NEFICIAL TO THE CITY O ATERLOO I APPROVE THIS TRAVEL REQUEST DEPARTMENT HEAD MAYOR DATE K:\Shared Goodies\Forms\Travel Request Form January 2010 2c.,42w14-( Lit (2011 \ /k DATE WAVE Conference Agenda and Topics 1 ESO Page 1 of 7 CONTACT US: 866-766-9471 APP LOGIN February 1 & 2, 2018 I Hilton 1 Austin, Texas WHAT IS WAVE AGENDA + TOPICS REGISTRATION + HOTEL https://www.esosolutions.com/wave-2018/agenda/ 12/4/2017 WAVE Conference Agenda and Topics I ESO Page 2 of 7 Conference Times Conference Times Wednesday, 9:00 a.m. - 5:00 p.m. January 31 Steering Committee Meetings Thursday, February 1 12:00 p.m. - 5:00 p.m. Medical Director Summit 5:00 p.m. - 7:00 p.m. Pre -registration & Sponsor Hall Open 8:00 a.m. - 9:00 a.m. Registration & Sponsor Hall Open v 9:00 a.m. - 6:30 p.m. Day 1 Sessions (Opening Keynote, General, Breakout) Sponsor Hall Open 7:00 p.m. - 10:00 p.m. Wave After Party Friday, February 8:30 a.m. - 9:00 a.m. 2 Registration & Sponsor Hall Open 9:00 a.m. - 4:00 p.m. Day 2 Sessions (Keynote, General, Breakout) Sponsor Hall Open Conference Topics and Agenda General + Keynote https://www.esosolutions.com/wave-2018/agenda/ 12/4/2017 WAVE Conference Agenda and Topics 1 ESO Page 3 of 7 Day 1: ESO Roadmap: The Vision for ESO and the Future Chris Di!lie, ESO Interoperability EMS and Hospital Integration: Why EMS is a Good Partner Karrie Austin, MultiCare Health System Intro to HDE: How EMS & Hospitals Are Benefiting From Two -Way Data Sharing Chris French, ESO Data is the New Bacon Brooke Burton, Gold Cross (UT) Ambulance Training: Scan Rates? Done. Outcomes? Check. Now what? ESO Success with HDE: Tips for Getting the Most Out of HDE ESO Introduction of New HDE Roles & User Success Brent Myers, Joshua English, ESO Cultivating EMS Loyalty: Benefiting from Data & EMS Collaboration ESO Data Performance Improvement Made Practical Management Mike Taigman, FirstWatch Data Dictionary & Benchmarking: Having the Data & Putting It to Work Like Never Before Brent Myers, ESO Five Things You Never Thought You'd Hear a Former Fed Say About EMS Data Noah Smith, D.C. Department of Health Care Finance Spotlight: The Buck Stops Here, Evidence -Based Medicine Using ESO to Save $$ https://www.esosolutions.com/wave-2018/agenda/ 12/4/2017 WAVE Conference Agenda and Topics I ESO Page 4 of 7 Tim McIntosh, Port Aransas (TX) EMS Training: Analytics for Beginners Joshua English, ESO Training: Analytics for the Advanced User Joshua English, ESO Training: Deciphering Your Data Using AdHoc Dustin Barton, ESO EHR/EMS Best Data Driven Documentation Practices Brooke Burton, Gold Cross (UT) Ambulance Fire Best Practices Training: Validation Rules: Overcoming the Red Flags ESO Spotlight: Blood Products for Ground EMS Eric Bank, Harris County (TX) Emergency Services District 48 Training: Admin ESO EHR Roadmap & Feedback Kenny Schnell, ESO 2018 Predictions for the EMS Industry ESO Harnessing the Fire Data Paradigm Shift Matt Hinds -Aldrich, Ph.D., NFPA The Future of Fire: ESO & FIREHOUSE (Better Together) Shelley Koegler, ESO Training: Proving ROI with Your Fire Data ESO 2018 Predictions for the Public Safety Industry ESO https://www.esosolutions.com/wave-2018/agenda/ 12/4/2017 WAVE Conference Agenda and Topics I ESO Page 5 of 7 ESO Fire Roadmap & Feedback Tim Irelan, ESO Billing + Ambulance Payment Reform — Where do we go from Revenue here? Recovery Asbel Montes, Acadian Companies Research + Quality Product Portfolio Topics The Top Six Threats Facing Your EMS Agency Doug Wolfberg, PWW Compliance & Current Trends in Reimbursement Gail Atnip, Novitas Solutions Inc. It's Not All About Data: The Lost Art of Writing Clinical Narratives Doug Wolfberg, PWW ESO Billing Roadmap & Feedback Shelley Koegler, ESO Research & Quality Leadership Consortium Scott Bourn, ESO Poster Presentations Modern ePCR — Introduction to ESO EHR ESO SafetyPad: Vision & Next Steps Allen Johnson, ESO Introduction to ESO Fire Tim Irelan, ESO https://www.esosolutions.com/wave-2018/agenda/ 12/4/2017 City of Waterloo Expenditure Pre -Authorization Request Form City Clerk Use Only Finance Committee f �I Approval Date `2/ I I I The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Clerk/Finance Department to expend $ NTE $20,000 plus est. shipping costs of $ to pay for or purchase office furniture. This purchase or expenditure is being made because: we need to reconfigure the space to provide additional offices. More space is required due to hiring a full-time Human Resources director and having more p -t employees. Vendor selected for this purchase: Storey -Kenworthy ❑ Bids or written quotes were taken on this purchase, as follows: O Bids or quotes were not taken on this purchase because: The same vendor needed to be used so that various pieces could be incorporated. We are also combining with the prior pre-auth for the fire department to get better pricing. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: 0 General Fund 0 Road Use Tax ❑ Sewer 0 Sanitation Dx Bonds ❑ Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 414-03-8400-2118 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ 25,000.00 and the current available balance is $ 25,000.00 Respectfully submitted, a/c c _- /2 -6-!7 �,u-oevcei /.7_G-/7 (Sig ture D pt. ad or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Pre-auth Office Furniture.xls (Mar 2010) City Clerk Use Only Finance Committee Approval Date (� \ / I 1 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 WFR Department to expend $ NTE $3,000 plus est. shipping costs of $ N/A to pay for or purchase required annual fire pump testing. This purchase or expenditure is being made because: The pumps for our fire trucks are required to be tested yearly. Vendor selected for this purchase: Apparatus Testing Service ❑ Bids or written quotes were taken on this purchase, as follows: ❑x Bids or quotes were not taken on this purchase because: Single Source Provider Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: I x l General Fund ❑ Bonds Road Use Tax Federal/other grants ❑ Sewer ❑ Sanitation ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 010-12-1400-1547 (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available balance is ctfullitted (Project Code) $ 5,000.00 jT $ 2,472.94 f 141147 (Signature Dept. Head`or Designee) Date (Signature Finance Dept. Review) Sent over 120417. 42-b-,7 Date City Clerk Use Only Finance Committee Approval Date ( -2!( 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 $ 5,000.00 plus est. shipping costs of $ n/a to pay for or purchase three recruit hiring physicals. This purchase or expenditure is being made because: Physicals are required for new hires Vendor selected for this purchase: Unity Point n Bids or written quotes were taken on this purchase, as follows: n Bids or quotes were not taken on this purchase because: Single Source. Unity point is approved to conduct these physicals. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: nx General Fund 0 Road Use Tax n Sewer n Sanitation D Bonds El Federal/other grants n Other (specify) This expenditure is to be coded to the following budget line -item: 010-12-1400-1314 Health Services (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the current available balance is dig'spectfu 1, -*/17„..647 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date $ 14,500.00 V $ 12,430.31 '/ K:lshared goodieslforms\Expenditure Pre -Authorization (Mar 2010) City Clerk Use Only Finance Committee Approval Date 2/I t f 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 $ 24,660.00 plus est. shipping costs of $ to pay for or purchase replacement of warranty compressors and additional repairs to Multistack chillers. This purchase or expenditure is being made because: while units were under warranty, labor costs and miscellaneous parts were not. Vendor selected for this purchase: Young Plumbing @ Heatign Co. (Waterloo, IA) n Bids or written quotes were taken on this purchase, as follows: Ex Bids or quotes were not taken on this purchase because: Young Plumbing and Heating were the original installers. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: ElGeneral Fund ❑ Road Use Tax Sewer n Sanitation • Bonds E Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 010-37-4180-1371 Building & Gorunds Maint. (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ 34,834.00 ✓ and the current available balance is $ 28,220.46 Respectfully submitted, (Signature Dept. He-ad-br Designee) Ddte (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre -Authorization (Mar 2010) PLUMBING & HEATING CO. Mechanical Contractors December 5, 2017 ATTN CRAIG DENNER CEDAR VALLEY SPORTSPLEX 300 JEFFERSON STREET WATERLOO, IA 50701 RE: INVOICE #76334 BREAKDOWN Dear Craig, PLUMBING HEATING AIR CONDITIONING SHEET METAL PROCESS PIPING EXCAVATING Per our phone conversations, the following is the breakdown for our invoice #76334 for replacement of the Warranty compressors and additional repairs on the MultiStack chiller this past summer. The breakdown is as follows: LABOR — 234 Hours @ $70.00 MATERIRALS: 8 Solenoid Valves@ $525 each 8 Filter Driers @ $115.00 each 4 Heater Kits @ $100.00 each 1 Refrigerant Bypass Valve @ $540.00 504 R -410A Refrigerant @ $8.00 each Misc. Materials: $16,380.00 $ 4,200.00 $ 920.00 $ 400.00 $ 540.00 $ 400.00 $ 1440.00 i.e....Solder, pump oil, fittings, acid scavenger Freight $ 380.00 Total Invoice Amount $ 24,660.00 If you have additional questions or need more information, please feel free to contact me. Sincerely, Young Plumbing & Heating Co. John Thomas 750 SOUTH HACKETT ROAD WATERLOO, IOWA 50704 PHONE (319) 234-4411 P.O. BOX 1077 FAX (319) 234.4540 City Clerk Use Only Finance Committee Approval Date ' / i -/ 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 $ 17,900.00 plus est. shipping costs of Leisure Services Department to expend $ to pay for or purchase The removal of 21 ash trees at Fairview Cemetery This purchase or expenditure is being made because: They are infested with emerald ash borer. The 21 trees are at different stages of decline. The dead trees are already starting to have large limb failure. Vendor selected for this purchase: Affordable Tree Service UBids or written quotes were taken on this purchase, as follows: Affordable Tree Service - $17,900 Wilson Custom Tree - $20,995 Twin City Tree Service - $41,500 ❑ 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 ❑X Bonds Road Use Tax Federal/other grants ❑ Sewer ❑ Sanitation ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 417-37-4100-2166 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ 300,000.00" and the current available balance is Respectfully submitted, $ 2-997520.34 A32,' ) �p •i ignature'Dept,4e d or Designee) Date (Sinature Finance Dept. Review) Date K:lshared goodieslforms\Expenditure Pre -Authorization (Mar 2010) City Clerk Use Only Finance Committee Approval Date `2 // 14 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 $ 21,000.00 plus est. shipping costs of $ to pay for or purchase Equipment parts from various vendors based on price and availability of individual parts. This purchase or expenditure is being made because: To replace or repair worn out or broken parts to properly maintain the golf course mowing equipment. Vendor selected for this purchase: various n Bids or written quotes were taken on this purchase, as follows: R&R Products (Arizona), P&K Midwest (Waterloo), and Van Wall (Urbandale) Turfwerks(Johnston), each provided a price per part. Parts are being ordered from the lowest bidder per part. 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: ❑X General Fund ❑ Bonds El Road Use Tax ❑ Sewer Federal/other grants Other (specify) This expenditure is to be coded to the following budget line -item: 010-37-4120-1569 (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available balance is Respectfully ubmitted, Sanitation (Project Code) 0 $ 20,804.O,0 4- aro $ 21,000 after amendment (Signature Dept. Hea. or P -signee) Date (Signature Finance Dept. Review) Date K:lshared goodieslforms\Winter parts order preauth Great American.xls (Mar 2010) City Clerk Use Only Finance Committee 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 Leisure Services Department to expend $ 3,000.00 plus est. shipping costs of $ to pay for or purchase 32 chipper knives for wood chippers This purchase or expenditure is being made because: Replace old knives in wood chippers used by forestry crews. Vendor selected for this purchase: J.P. Scherrman, Inc. n Bids or written quotes were taken on this purchase, as follows: J.P. Scherrman, Inc. $3,000 Sherrill tree $3,262 • 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: ElGeneral Fund n Road Use Tax n Sewer 0 Sanitation n Bonds n Federal/other grants n Other (specify) This expenditure is to be coded to the following budget line -item: 010-37-4100-1571 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the current available balance is Res • - ull submitted, 'Signature Dept. • or Designee) Date (Signature Finance Dept. Review) Date $ 19,600.00 $ a-673.59786- /4 Al( 2- k' K:lshared goodieslforms\Expenditure Pre -Authorization (Mar 2010) City Clerk Use Only Finance Committee Approval Date l 1x1 /1 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 $ 7,395.00 plus est. shipping costs of $ to pay for or purchase Deckover Equipment Trailer. This price reflects $200 trade value offered on 2003 used trailer. This purchase or expenditure is being made because: The trailer of the same size and capacity from 2003 is no loger operable due to significant structural rust to the frame. Vendor selected for this purchase: Black Hawk Rental, Waterloo Iowa Bids or written quotes were taken on this purchase, as follows: 171 Bids or quotes were not taken on this purchase because: Black Hawk Rental is the only local vendor that carries this model of trailer. 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 Bonds Federal/other grants ri Other (specify) X This expenditure is to be coded to the following budget line -item: 415-37-4100-2113 (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available balance is (Project Code) $ 120, 000.00 $ 25,614.33 Respectfully submitted, (Signature Dept.-H�d'or Designee) Date (Signature Finance Dept. Review) Date K:lshared goodies\forms\Pre-Auth 15' B&B Trailer.xls (Mar 2010) City Clerk Use Only Finance Committee Approval Date ./1( 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 Sofware and mobile licenses This purchase or expenditure is being made because: TreeKeeper software is used to collect data in the field and used in the office to manage Waterloo's tree resources using that data. New technology reduced price by $1400. Vendor selected for this purchase: Davey Resource Group ElBids or written quotes were taken on this purchase, as follows: OX Bids or quotes were not taken on this purchase because: Davey Resource Group was chosen in 2012 to manage Waterloo's tree inventory after evaluating all vendors and bids. This payment is an annual renewal of that subscription. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: I ^ I General Fund n Road Use Tax n Sewer 0 Sanitation ElBonds n 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) in which the budgeted amount is and the current available balance is Resile II submitted, (Project Code) $ 14, 552.00 / $ 947 66' 90V7 y1 V (Signature De • . H=;. or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\for s\Expenditure Pre -Authorization (Mar 2010) City Clerk Use Only Finance Committee Approval Date 21 1( 1 City of Waterloo Expenditure Pre -Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Planning Department to expend $ 2,200.00 plus est. shipping costs of $ 0.00 to pay for or purchase Appraisal bids for two parcels adjacent to 2680 Sergeamt Road 4.30 acres and 7 acres This purchase or expenditure is being made because: It is our intent to purchase the parcels for development Vendor selected for this purchase: Valuation Services ❑X Bids or written quotes were taken on this purchase, as follows: Valuation Services - $2200 Rally Appraisal - $2400 ▪ 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: O General Fund 0 Road Use Tax El Sewer Sanitation ❑X Bonds Federal/other grants El Other (specify) This expenditure is to be coded to the following budget line -item: 416 08 6250 2140 (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available Respec alanc I5 (Project Code) $ -283;65-9A-,3(jG OQ() /7-01.09 /--'i1 (Signature Dept. Head or De •'ee Date (Signature Finance Dept. Review) Date K:lshared goodies\forms\Valuation Sery-2680 sergeant rd.xls (Mar 2010) TIM ANDERA From: Keith Jones <keith@valueservice.com> Sent: Friday, November 17, 2017 10:41 AM To: TIM ANDERA Subject: Appraisal Bids for two appraisals at 2680 Sergeant Road, Waterloo Tim, I would propose to do this work assignment as two separate vacant land appraisals. One subject being fully visible from U.S. Hwy 63, the other is a rather hidden site to the rear of O'Neal Steel. The bid for work is $2,200. Thank You for the opportunity to bid this work. D. Keith Jones, ASA - Urban Properties American Society of Appraisers President Valuation Services, Inc. 715 W 1st St. Cedar Falls, Iowa 50613 319-277-0477 Rally Appraisal, L.L.C. Cedar Falls Office • 2302 W 1" Street, Suite 201 D • Cedar Falls, IA 50613 Clint Cola - Manager Jim Herink — Senior Appraiser Adam Horan Dexter Klostermann Dave Passmore - Commercial Manager MAI November 21, 2017 Tim Andera Associate Planner City of Waterloo 715 Mulberry Street Waterloo, Iowa 50703 Phone: (319) 266-9373 Fax: (319) 277-5218 www.rallvanoraisal.com RE: Request for Bid Land adjacent to 2680 Sergeant Road, Waterloo, Iowa Dear Mr. Andera: Per your request, I am providing a bid for appraisals of the following properties. Property Bid Amount 4.30 acres adjacent to 2680 Sergeant Road, Waterloo, Iowa $1,200 7.00 acres adjacent to 2680 Sergeant Road, Waterloo, Iowa $1,200 The appraisal report can be complete within four weeks of the date it is awarded and no later than December 22, 2017. Sincerely, James Herink Certified General Real Property Appraiser, CG02627 (Iowa) Consistently exceeding expectations Dela: Base ITI2p data xeue. u DDG Hark C. ay nitma paeex not men pnsl a exumV. ea bbSry Is aaxe a re, the aa.aay of the data eameaaa nµim, tither axpeexxe a ar Mpfr a by a aG Hrvk ea. . MackHmN: Guery Aseaxser. ar0e:embyee, me ermlerou e m,bx .nna arv...wexx hwGeq as le llrceavney.flM WmmabnaDexn n Nlsmtp,.na""ss -"thvsPWpb�" �eof. Vern aTesiD nlep leyDdth AACLeeas, on,*remmpie &aek HaW GunMAs sseh on,* bemmpDle aM ae<male pivmnl6n &itis of Waterloo, Iowa City Clerk Use Only Finance Committee 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 $ 4,376.00 plus est. shipping costs of $ 50.00 to pay for or purchase purchase a new in car camera system This purchase or expenditure is being made because: replace an older outdated in car camera system that is no longer supported by the manufacture Vendor selected for this purchase: L3 Mobile Vision n Bids or written quotes were taken on this purchase, as follows: Q Bids or quotes were not taken on this purchase because: L3 Mobile Vision is a proprietary company to this camera system and the only provider to purchase this system from as this is an extensiion of our current in car camera system the Waterloo Police Department uses 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 Sanitation Bonds EX Federal/other grants Other (specify) This expenditure is to be coded to the following budget line -item: 010-11-1150-1563 11 G RTff DCTK42 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the current available balance is Respectfully su}3mitted, ( -r gnature Dept Head or Desppiiee) $ 6-G4f �✓ X13017 r ;/4/j-LA4 Dat (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre -Authorization (Mar 2010) City Clerk Use Only Finance Committee Approval Date LI t I 1 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 $ 30,342.00 plus est. shipping costs of $ 200.00 to pay for or purchase purchase (10) new DVR systems for the in car camera systems This purchase or expenditure is being made because: replace worn out older outdated DVR and antennas for the in car camera system that are no longer supported by the manuafacture Vendor selected for this purchase: L3 Mobile Vision n Bids or written quotes were taken on this purchase, as follows: Qx Bids or quotes were not taken on this purchase because: L3 Mobile Vision is a proprietary company to this camera system and the only provider to purchase this system from as this is an extensiion of our current in car camera system the Waterloo Police Department uses 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 0 Sanitation nX Bonds ❑ Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 416-11-1100-2127/ 417-11-1100-2127/ 41-6--1-1-1--1-00e2'TD (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available balance is Respectfully su mitt =d "(30/r) (Signature De ' Hea. •r Designee) Date (Signature Finance Dept. Review) Date (Project Code) $ 1(J, q!'1 !$v $ rri S,/2-°.% aadoo� K:\shared goodies\forms\Expenditure Pre -Authorization (Mar 2010) City Clerk Use Only Finance Committee Approval Date ( l tl / I 1 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 Sanitation Department to expend $ 2,450.00 plus est. shipping costs of $ 150.00 to pay for or purchase Front differential on Sideloader #151301 This purchase or expenditure is being made because: Replace front differential that is not repairable. Vendor selected for this purchase: GATR Truck Center n Bids or written quotes were taken on this purchase, as follows: GATR Truck Center Waterloo, Iowa $2,450.00 Sadler Power Train Waterloo, Iowa $2,788.50 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: ElGeneral Fund LI Road Use Tax Sewer ❑ Sanitation Bonds Federal/other grants n Other (specify) This expenditure is to be coded to the following budget line -item: 010-18-7-W1569 6569 (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available balance is Respectfully submitted, (Signature Dept. or Designee) 1 (Project Code) $ 265,000.00 frt ec- ),-'? 42" 5-'1/ / ate (Signature Finance Dept. Review) Date K:lshared goodies\forms12017-December-Expenditure Pre-Authorization-GATR Truck - front differential sideloader #151301 - $2,450.00+150.00SH - 010-18-7255-1569.xls (Mar 2010) City Clerk Use Only Finance Committee Approval Date q(% City of Waterloo Expenditure Authorization Request Form The Finance Committee of the City Council is here by requested to authorize the following purchase or expenditure submitted by the Sewer Department to expend $ 5.613.44 plus ext. shipping cost of $ 0.00 to pay for or purchase Emergency Welding repair work on #6 Digester Roof This purchase or expenditure is being made because: #6 Digester roof leaking biogas at seams of digester roof needs to be repair before spray polyurethane foam is applied. Vendor selected for this purchase: Brecke Mechanical Contractors IIIBids or written quotes were taken on this purchase, as follows Bids or quotes were not taken on this purchase because: Emergency Repair work has been done. Brecke Mechanical Contractors is rep selected to perform repair welding work on #6 Digester Roof. City Strategic Plan, Strategy 4.5 Maintain and develop community services and city facilities that support quality of place. 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: ]Sanitation: ▪ Bonds: ]Federal/other grants: 0Other(specify): This expenditure is to be coded to the following budget line -item: 520-14-5200-2 /310 (Fund - Department - Activity - Account Number) in which budgeted amount is and the current available balance is Respectfully submitted, I Loi '�/yj r,�i c.L>.v �) L c.s�-[/'� 42-(r61 (Signature Dept. Head Or Designee) Date (Signature Finance Dept. Review) Date (Project Code) $ 1z5o.on0- 330o4- 6775 t; $ 1-4g7eae-ea 8633 ✓ MECHANICAL CONTRACTORS Bill To: 12014 Waterloo Waste Water 3505 Easton Ave Waterloo, IA 50702 Customer Job #: Brecke Mechanical Contractors 4140 F Ave NW Cedar Rapids, IA 52405 Phone: (319) 396-7055 Fax: (319) 396-9390 Invoice Invoice Number 34871 Job: 173394 Waterloo Waste Water 3505 Easton Ave Waterloo, IA 50702 Customer Order #: Work Ordered by:Brian Rath Description of Services Emergency digester roof weld repair Labor 11/8/2017 11/8/2017 11/8/2017 11/10/2017 11/10/2017 11/13/2017 11/13/2017 11/13/2017 11/14/2017 11/14/2017 11/14/2017 11/14/2017 Millwright Journeyman Millwright Journeyman Millwright Superintendent Millwright Foreman Millwright Journeyman Millwright Foreman Millwright Journeyman Millwright Journeyman Millwright Foreman Millwright Foreman Millwright Journeyman Millwright Journeyman QTY Unit Price REG 4.00 72.00 REG 4.00 72.00 REG 4.00 82.75 REG 8.00 75.00 REG 8.00 72.00 REG 8.00 75.00 REG 8.00 72.00 REG 8.00 72.00 OT 0.25 105.75 REG 8.00 75.00 REG 8.00 72.00 REG 8.00 72.00 Price 288.00 288.00 331.00 600.00 576.00 600.00 576.00 576.00 26.44 600.00 576.00 576.00 Terms: Net 30 Days Thank You For Your Business! Page 1 of 1 Total Labor: 5,613.44 Subtotal $ Sales Tax (if applicable) $ Total Due $ 5,613.44 0.00 5,613.44 Warranty - All warranty claims must be brought to the attention of B.G. Brecke, Inc. within the warranty period of 90 days for service calls and one year for new installation projects. B.G. Brecke's warranty is limited to our labor only. Original manufacturer warranties are provided on a pass-through basis when available. A detailed warranty policy will be provided upon request. Unpaid accounts are subject to a fee of one and one-half percent (1-1/2%) per month plus any and all collection fees. City Clerk Use Only Finance Committee '11"Approval Date �U 1(1 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 Operation. Department to expend $ 1,565.80 plus est. shipping costs of $ 204.65 to pay for or purchase 2 and 4 Drawer Units, 6 Case Cabinet System, Utility Hook, etc. This purchase or expenditure is being made because: To modify - in-house - the newly purchased van for signal technicians. (Company recommended by dealer to modify van) Vendor selected for this purchase: American Van n Bids or written quotes were taken on this purchase, as follows: American Van Lakewood, NJ $1,565.80 n Bids or quotes were not taken on this purchase because: Prior Committee Actions (Dates): Approved by finance 11/20/17 - increase in freight Please check the following box(es) as appropriate to describe the funding for this expense: General Fund n Bonds Road Use Tax Sewer ❑ Sanitation Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 414-17-7120-2117 (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available balance is Re pectfully submitted, dLL' (Signature Dept. ead or Designee) (Project Code) $ 40,000.00 11,690.88 ,If1 Date (Signature Finance Dept. Review) 7 Date K:\shared goodies1forms12017-December-Expenditure Pre -Authorization -Traffic -American Van -Cabinets, Drawers for new Van to modify - $1,565.80 - $204.65 SH.xis (Mar 2010)