Loading...
HomeMy WebLinkAbout04/11/2016FINANCE COMMITTEE April 11, 2016 5:10 PM Harold E. Getty Council Chambers Members Chairperson Ron Welper Vice Chairperson David Jones Bruce Jacobs Roll Call: Approval of Agenda Approval of Minutes of April 4, 2016, as proposed. NEW BUSINESS TRAVEL REQUESTS 1. Lt. Ferguson Class/Meeting: Fire Alarm System Testing & Inspections / Fire Alarm Plan Review Destination: Minneapolis, MN Dates: May 3-6, 2016 Amount not to exceed: $828.00 2. Lt Ferguson Class/Meeting: 2 Day Sprinlder System Plan Review (National Fire Sprinkler Association) Destination: Lockport, IL Dates: May 10-12, 2016 Amount not to exceed: $530.00 3. Todd Henrich and Joel Shepard, Building Maintenance Class/Meeting: Continuing Education - IA State Electrical License Destination: Cedar Rapids, IA Dates: May 2-3, 2016 Amount not to exceed: $1,198.00 4. Pre -Authorizations to Expend over $1,000.00 Clerk's Office Amount and Estimated S/H: $58,180.80 Expenditure: Costs associated with the 2015 Waterloo City & Runoff Election. Leisure Services Amount and Estimated S/H: $3,370.00 + $450.00 S/H Expenditure: One granular surface trail conditioner. P&Z,Eng&CD Amount and Estimated S/H: $3,709.15 Expenditure: ArcGIS Software Maintenance & ArcPad Maintenance Agreement Page 1 of 189 Police Amount and Estimated S/H: $4,000.00 Expenditure: Four (4) additional Shieldware RMS licenses. Sewer Amount and Estimated S/H: $12,539.80 + $431.36 S/H Expenditure: (3) Pole camera add -on SD recording device, (4) Rear view camera add -on for transporters, and accessories for sewer TV inspections. Sewer Amount and Estimated S/H: $5,118.00 + $235.00 S/H Expenditure: Automatic sampler and cable assembly for sampling at UV building. BUDGET LINE HEMS TO BE AMENDED 5. Approve the project budget for the Airfield Pavement Management Maintenance System, funded with $99,800 in general funds paid to the airport for the "purchase" of land previously acquired using federal funds, as submitted by the Airport Department. 6. Approve the project budget amendment in the amount of $3,941.60 to budget for revenue received from MidAmerican Energy to be used for improvements at Young Arena, as submitted by Leisure Services. 7. Approve the budget amendment for the Library Miscellaneous Donations project to use cash donated in prior years to purchase library materials in the amount of $2,315, as submitted by the Library. 8. Approve the budget amendment for the Central Garage to increase revenue by $1,500 to be used to spend an additional $1,500 on parts, as submitted by the Public Works Director. BILLS PAYMENT 9. April 11, 2016 ADJOURNMENT Suzy Schares, CMC City Clerk/Human Resource Director Page 2 of 189 TRAVEL REQUEST CITY OF WATERLOO FINANCE DEPT. STAFF ONLY LINE ITEM USED ` b'S cam (� }jam FYA th BUDGETED /..52)0 EXPENDED YTD 3 'c /o1U " THIS REQUEST 5V45iy L LEFT AFTER THIS REQUEST &// 2` DATE 7-- Original - Clerk/Finance Copy - Department NAME(S) AND POSITION(S): Todd Henrich - Building Maintenance Joel Shepard - Building Maintenance DATE: 4-6-2016 NAME OF CLASS / MEETING: Continuing Education - IA State Electrical License DESTINATION Cedar Rapids, Iowa DEPARTURE POINT IF NOT WATERLOO DEPARTURE DATE: May 2nd & 3'd, 2016 RETURN DATE: May 2"d & 3rd, 2016 DATE(S) OF MEETING: May 2nd & 3rd, 2016 PURPOSE OF TRAVELITRAINING Required Electrical CEU's WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: x COST $ YES NO METHOD OF TRAVEL: X CITY VEHICLE AIRFARE DEPARTING FROM: Waterloo, Iowa PRIVATE VEHICLE ESTIMATE OF COST: LODGING TAXI MEALS PARKING 599.00 (ea) REGISTRATION AIRFARE MILEAGE/FUEL MISCITOLLS TOTAL FOR ALL: $ 1,198.00 010-22-8800-1346 'Todd_ BUDGET LINE ITEM: 010-22-6860-1346 ,j-oe- X GRANT REIMBURSABLE YES NO X REQUIRED CERTIFICATION YES NO TOTAL: $ 599.00 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY ATERLO DEPARTMENT HEAD I APPROVE THIS TRAVEL REQUEST MAYOR DATE DATE K:\Shared Goodies\Forms\Travel Request Form January 2010 FriNANCE DEPT. 5TAFF ONLY LIFE ITEM USED ()/() /- WO 6447 TRAVEL REQUEST 14sl1DSc6'ED ;.. '7000`Y CITY OF WATERLOO €'FxPENDED YTD 44) i,1 S« .."' HIs REEQUEST.': • 1-v sue" L AFTER THIS REQUEST air-cr/ -DATE �*../ 4{'S /(o . Or, gi ;;- Clerk/Finance, Copy.- Dep'arttnent I NAME(S) AND CAVES T:i.Arctut. POSITION(S): Sow , 1— DATE: ! j• NAME OF CLASS / MEETING: d"J 5 p (;Ah)V.,( 5� s f P kw ipQ..2J Nathnnut RA5vs;•nW- oY /1--“O:'i f, c�.f-t n DESTINATION DEPARTU Wi4� IF NOT RE POINT TERLOO'I 1 ' a a GI(I-JIU-v f-, T.- V . DEPARTURE DATE: ` rilb-Ai toil_ RETURN DATE: 12 !I , I. LTE(S):OF MEETING: clp ( PURPOSE OF TRAVEL y, el hew {-� Gerr�3�L� h.tafa. utl'c C C.tAk�f-t st a d1i5 CL 5 d2� p/D _. c� J tOennou,.4 64,/v✓S - .'- s - 1 1 -6L_ %.�.1i0� U 1�✓�C1� c Gt�f�luti-r s. . f; :. : . ; WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: /-1') �/ COST YES NO'',l METHOD OF TRAVEL: CITY VEHICLE I kPR111ATE'vEICLE ; i$ AIRFARE DEPARTING FROM: : j I' I, tip - -. _ .. .._, ESTIMATE OF COST: II R 1 8tli it f1. / L•.Itil� ITEM: �fO 'I 3- ..1 o 'I3 fo �5,e� LODGING TAXI II ' ,.>/ GRAN T.REIMBURS,i:'?LE gam MEALS PARKING YES NO d 5".0 REGISTRATION AIRFARE f ,a V 1 REQUIRED CERTIFICATION MILEAGE/FUEL MISC/TOLLS YES 'NO e-Pl5• TOTAL FOR ALL: $ 5--go ..TONAL: $ - ... - PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO DEPARTMENT HEA DATE K:\Shared Goodies\Forms\Travel Request Form January 2010 IAPPROVE TH1S•T.RAVEL'REOUEST Print Preview Page 1 of 2 2 Day Sprinkler System Plan Review -Lockport, IL Register d Map this Event {;r„) Tell a Friend 5/11/2016 to 5/12/2016 When: May 11-12, 2016 7:30 AM-4:00 PM Where: Map this event » Lockport Township Fire District 19623 W Renwick Road Lockport, Illinois 60441 United States Register Online registration is available until: 5/11/2016 1 bZ3 W R . ICK Koa�3 - Lock., Ilinois 60441 UnStatesRomeoville Get Directions 1 Export to Calendar Lockport 0 jdfire4dA201M6pattitita « Go to Upcoming Event List This two-day seminar provides attendees with vital information on how to conduct the plan review process for water -based fire protection systems. Utilizing the requirements of NFPA 13 the participant will be guided through an actual review of sprinkler system plans and calculations. They will discuss the importance of employing a systematic review process and identify the documents required for a complete plan review. Finally they will review a submittal of hydraulic http://www.nfsa.org/events/EventDetails.aspx?id=773925&group= Print Preview Page 2 of 2 calculation presented with the plans and discuss the process of hydraulic calculations and identify the key pieces of information presented and the common errors that are made. Total Instructional Contact Minutes: 780 min. (1.3 CEUs, 13 CPDs ) Learning Objectives: At the conclusion of this seminar the participant will be able to: 1. Apply the requirements for Plan Review in NFPA 13 2. Discuss the importance of a systematic review process. 3. Identify the documents required for a complete plan review process 4. Correlate the requirements for plan review with the requirements in other chapters of NFPA 13. You must bring a copy of NFPA 13 (2010 or 2013 ed.) with you to class! For a complete syllabus, click HERE REGISTRATION FEE: Members or AHJs: $250 EARLY BIRD ($295 Two Weeks Before) Non -Members: $600 http://www.nfsa.org/events/EventDetails.aspx?id=773925&group= 4/1/2016 NANCE DEPT. STAFF ONLY 1E rrEM USED OM /), /60 /3,k TRAVEL REQUEST /&BUD&ETEb ; - . - 1000 CITY OF WATERLOO I ;.. I EXPENDED YTD 3e6 ( e ('j H:.S REQUEST, ; ' .. 37P, Sf., .:AFTER THI5 k REQUEST `-fi DATE ': ;a'q' 5 <fv Or oi - Clerk/Finance,. Copy- Deportment NAME(S) AND LAIv r i� POSI T ION(S): e• 4.)O( 1f DATE: 3 / 3/ J.::�U f • .. .: . NAME OF CLASS / MEETING: 6 rL M.curprySYs4r "1e9}irt' Iv\setciiory _ p, rite_ AIe.L.✓,rr, PI( eviruAS DESTINATION DEPARTURE IF NOT WfTERLO61; POINT IYiin c.196I 1‘5, (11N , DEPARTURE DATE: RETURN DATE: DI TE(S).OF MEETING: PURPOSE OF 7� go r 3 $W,L4 .( TRAVEL: /1/)P kl (of e-v ;,e15/o2-ufar? (0.4 Ark , r_zt �� �Jev �n� @«.t-N a�,i� a$ uo 1 t� al '.. P lr>u. s,.bh'1I�� CIAO ba 6 __ . .y !� o- t6 aik . C ieI vi/i-olv.vtfS S!/iq9.4 d ro i O.ICuOta,{� Y1S f 1 r Jti ,Mp.d.r . p% ic,u; :.._. WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: 1/COS YES NO ... METHOD OF TRAVEL: CITY VEHICLE ' a PRIVATE VEHICLE AIRFARE DEPARTING FROM: ESTIMATE OF COST: (.`7pp°`--- LODGING TAXI II XBUbGET I Lp !!� / E !+A: Q'f d .I � l'`'D© i34 1. • IT� 1 .../GRANT,REIMBUPSA'?LE 36MEALS PARKING YES NO ! REQUIRED CERTIFICATION 4- DD— REGISTRATION AIRFARE MILEAGE/FUEL MISC/TOLLS YES -.TOTAL: NO $' - .. . •. .•'.;: :- PER PERSON TOTAL FOR ALL: $ C ice- t BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WAT DEPARTMENT HE I APPROVETHIS ;TRAVEL REQUEST MAYOR DATE DATE K:\Shared Goodies\Forms\Travel Request Form January 2010 slagwaw-uON w 0 3 O CD 69tfltflba N N N CA CON CDCD(DCD D m Z m m c co co n 0 - Om Z n O O -13 - CD D �0 • F O 7 N 0®-6 c w (D = Om 0 7" %J N c3 n 7 D - Cn 0 0 Z m m 0 = m <' CD o: c sll o. c CO a c Q cn C0 7 m O cc n O = n n.a S) CAD 7 co N A1� Og < Z CD ° n0 = CD m -1 CO O- 'i 3. > 5. llco N CD -p -c D(v(D O' o y ▪ O. CD =' 3 C' (n N CD O- C) CD -In 0 Ur 73 o c n v - m a to CU Da CD CD CD0. rt O ---1 N CQ N 0 n N Co v m C) _rt CD O -{ N N N � rt 0 0 7 Hours of Continuing Education - Participant must attend entire seminar to receive credit. c O C) O m c CD n)0 N7 O 7 1 rt rt O N --n N Z co m3 -o _. Dv 7 CD N 0 w v 0) rt n �. CD = = v c — CD • m rt o- CD 0. rt 7 0 (D m Z� n - CD iU - 'O O 3' - CD SD 0(. = N MS CD 7 y y 7 C1 N cct S3A!133!'80 3sIn0O 0 SU CCDD 3 Z i 00 mC) — � 7 - I 0 su v 0) -0 "0 00 co N C) N tv rt a— v rt v 3o5�3 cp pg 0 mcco . Cp C) (ND �' 0 7 O v _I a = o 3 y E (n = a: .. o 7' 7 (D 0) 7 (D NICET now has a certification for Fire Alarm Inspection and Testing Personnel based on the requirements of NFPA 72-2013. -n Z1 cn cn cn r - o 0 cn m Z 6) m Z Ta N Instructor: Jim Mundy, SET - AFAA Instructor sJagwaw-uoN w 0 3 3 CD O CD CD v� D �fq Om n -I 0_ • CD r- y a= cn s_.r i rent 63<° n O 3o 0 okay 3 - V am ▪ `"_n0 0 0 x X F. 3 CD CD < <, m m'(D (0 3 w m T 13 C R -7' O a CD 0 Dv CD - D a = on 0W• i =y n0 • (D a0 cflfnv)v, N N N C4 N A CD(Oo)(0 CD (D CD CD CI C) C) C) 7 Contact Hours Continuing Education - Participant must attend entire seminar to receive credit. CD 0 st c c gin' CD D) a=rn O N 5 — AI - O " CD -I(D N • S - 'a C 73 v C) -I 3 O CI c13 Da "O O CT _ .. 3m-. CI g ( N 73 ID 0 a • a 0 073 C cn• -a N 3 0 CD 0 0 -g aci) 0 • 0 3 o (7) is 00(0 " g_a 73 SDO 51) c m Da O ▪ �a m * 0 s c 0 co CFI cn N ( a• cn (D O ID O,a_ co al 0 CD n•. Z 0 a 0 CD v 7 N (D OAF N o 3in) O • S3All03rao 3sdnOo c o 0 0 0 m � Do 3 N CD (D O 0 g 3 g_ O CD CD < 3 O �O O-rt• -0 73 0 St O CD (D - 4- C p a "a -0 C _ N G O �1 3 (3Wv < (D N CD K ^' 7 < CD 0 -0 N O D 3 a� 0 (o vS 0) c CD 0 Day m v 0 m n ✓ o_ co co O)WW== coco� o 0 cocoa cr) (I)cp00 O 0 Cn co � co O 0 D� C) (D (D ' C) O _ 00 -a 0 o DI o 0 1D 03 0 I v (n ..-,77 -.. (D CD N n (OD ((DD .J. 0 —I S.c c N CD 6 a) — 0 0 0 0 C) cn 0 0 N N N FIRE ALARM PLAN REVIEW SEMINAR CONTENT co m >0 rnpm Ni ...1.—I —I O 7 N EL. so (D �� O �O y �ZDv. 0 5 . �° n p v < CO 71 X cn -a Q m r- FIT 0 m m 3 oN -� m • _ c) 0 cn (D 03 = O, j W z (n -I. 7,- (D co c n 3 3.: Z pA rs CD D o. O (D <) O tn• - co O E. tp g i O1 7 CCD Z< 7 D. _n 5O j su !' (11 Q. Q c p co 0_ 0, lD < ooi j• O D _. Z o < co ; (Do a) CA)m �, co -P 3 o 5- m d CD m N x .-1- Fe0 >c1i m. °' o -m < 1) Q d y cD (D y � ♦y D N = 0-4 0 g'�=7 c o 0 7 ID , O y O N a C co 0 N •- 7 y p o 07, O C y m o O ceff _ ^. modem O O O.O D 3 AID 0 cp o=a_= (7 <4 co) I oa co a s o d O y ... n.I 0(o=ID3 3° yCD 3-'' 5,, co? m`. 0 co • y D y 0 o' m 3 m m 3 5 T O N m m 3 3 m 2 Em o?? co o N N y G m S. S O y = a N - co N 0 Q o. (p G) a a o 0 a coCD CS w O Z • y D m z D -n D z 0 cD CD CD Z z Z m m m m Billing address (if different than above) Cardholder Name (Please Print) oN pJe3 llpaJD m CD 1) N X v N ssaappy;aaJTS O co d N co 0 0 :;uud ao ad); °weld :auo )ioago aseeld f H`d ao Jagwaw WdV Jegwew-uoN WdOd NOI1beI1SIO3ei O 0 O O Z Z m m D D Co N I N No O CO N-1 (D 3 3 D- Cr CD -' (D iA ffl O) 00 w m in O o � a O O 0 c 3 3 (f] (D 3 a. a- (D (D O 0° c CD0D tza bi O cn o CD (D c ea = = O O O,') _< O' O O O0(D ON a aa * 'O N (D (D 3 N O -I -1 0 C 0 0) rn O_ Ot Cn D) co m (D C) 0 0- (D City of Waterloo Expenditure Pre -Authorization Request Form City Clerk Use Only Finance Committe Approval Date 1� The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Clerk's Office Department to expend $ 58,180.80 plus est. shipping costs of $ to pay for or purchase Costs associated with the 2015 Waterloo City & Runoff Election. This purchase or expenditure is being made because: Vendor selected for this purchase: Black Hawk County Auditor x Bids or written quotes were taken on this purchase, as follows: Bids or quotes were not taken on this purchase because: Municipal Election Black Hawk County Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: El General Fund Bonds Road Use Tax U Sewer n Sanitation Federal/other grants ri Other (specify) This expenditure is to be coded to the following budget line -item: 010-03-8400-1780 (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available balance is Respectfully submitted, (Project Code) $ ho, o00 $ (o0 600-7 �A.,'� (Signature D t ad or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies \forms12015 Waterloo City & Runoff Election Expenses (Mar 2010) KYLE JENSSON-Elections Manager March 31, 2016 Waterloo City Clerk Suzy Schares 715 Mulberry St Waterloo IA 50703 COUNTY AUDITOR AND COMMISSIONER OF ELECTIONS GRANT VEEDER ELECTIONS AND VOTER REGISTRATION DIVISION BLACK HAWK COUNTY 316 E. 5"{ STREET ROOM 210 WATERLOO, IOWA 50703-4774 j(319)833-3007 (319)833-3119 .black-hawk.ia.us SUBJECT: 2015 Waterloo City & Runoff Election Expense This is to certify that the following costs were expended for the conduct of the 2015 Waterloo City and Runoff Elections. Publication of Ballot Ballot Printing Precinct Officials (Polls) — Hours Precinct Officials (AB) — Hours Precinct Officials Mileage (Includes AB) Precinct Officials Training Hours Precinct Officials Training Mileage Polling Place Rental Voting Machine Technician Mileage Voting Machine Transportation Rental Extra Crthouse Staff Pct Runner Mileage Postage Supplies 11/03/2015 $ 847.78 $ 5,437.50 $19,497.88 $ 195.76 $ 440.51 $ 3,505.00 $ 519.09 $ 180.00 $ 147.19 $ 506.10 $ 12.09 $ 1,072.13 $ 877.20 12/01/2015 Totals: $ 163.56 $ 1,011.34 $ 3,083.75 $ 8,521.25 $18,561.41 $38,059.29 $ 200.52 $ 396.28 $ 472.49 $ 913.00 $ .00 $ 3,505.00 $ .00 $ 519.09 $ 180.00 $ 360.00 $ 163.00 $ 310.19 $ 409.14 $ 915.24 $ 28.20 $ 40.29 $ 826.27 $ 1,898.40 $ 854.23 $ 1,731.43 Grand Total: $58,180.80 Non -billable costs include: voter registration processing, administration, clerical expenses and for voting equipment. Witness my hand and seal of Black Hawk County this 31 st day of March, 2016. ytc._ Kyle Jsson Election Manager City Clerk Use Only Finance Committee ry// Approval Date "` `1 /1let 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,370.00 plus est. shipping costs of $ 450.00 to pay for or purchase One granular surface trail conditioner. This purchase or expenditure is being made because: This device will be used to groom new and existing granular recreational trails in the City of Waterloo. Cedar Trails Partnership has awarded a $2,500.00 grant for this item. Vendor selected for this purchase: Roadrunner Equipment LLC. Bids or written quotes were taken on this purchase, as follows: n Bids or quotes were not taken on this purchase because: Roadrunner Equipment has a patented design on their conditioner, they only sell factory direct. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: x General Fund Bonds Federal/other grants Road Use Tax n Sewer n Sanitation x Other (specify) This expenditure is to be coded to the following budget line -item: 010-37-4105 1555 $2,500 414-37-4100 2113 $1,320 37GFT.PARK (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available balance is Respectfully submitted, G (Signature Dep `Z CI& 0/� (Project Code) $ 2,500V150,000 $ 2,500 36,065 signee) Date (Signature Finance Dept. Review) Date K:\shared goodies \forms\Pre-4tiffi Roadrunner Blade.xls (Mar 2010) City of Waterloo Expenditure Pre -Authorization Request Form City Clerk Use Only Finance Committee Approval Date The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the P&Z,Eng & CD Department to expend $ 3,709.15 plus est. shipping costs of $ 0.00 to pay for or purchase ArcGIS Software Maintenance & ArcPad Maintenance Agreement This purchase or expenditure is being made because: The maintenance agreement is a yearly ageement that provides technical support for the software, as well as no -cost upgrades that become available Vendor selected for this purchase: ESRI n Bids or written quotes were taken on this purchase, as follows: n Bids or quotes were not taken on this purchase because: This is a maintenance agreement to current software Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: ❑X General Fund ❑ Road Use Tax ❑ Sewer n Sanitation Bonds n Federal/other grants ❑X Other (specify) LOST,storm water,CDBG This expenditure is to be coded to the following budget line -item: 010 08 570 1520 ($606.43); 224 32 5850 1520 ($303.21) --1 BG21A ADMN (Fund - Department - Activity - Account Number) (Project Code) in which hebudgeted amount is and the current available balance is Respectf s • 'tt OiCe $3t-lo� ��Qo q CaSOD� q00✓ $t i-10 / 1 a 5 v.)3 /L1 g I { (5L41M1-y6CP 1C, u.Usr (oob°' .3() J rwe> �1S{ (Signature Dept. Head or Designee Lit„)}„,_, („)„.c-i -emudot6 Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre-Authorization.xls (Mar 2010) esri Esri Inc 380 New York Street Redlands CA 92373 Subject: Date: To: Organization: Fax #: From: Fax #: Email: Number of pages transmitted (including this cover sheet): Renewal Quotation 04/01/2016 Aric Schroeder City of Waterloo Planning & Zoning Dept 319-291-4262 Phone #: 319-291-4366 Hannah Lehmann Phone #: 909-793-2853 Ext. 3485 hlehmann@esri.com Quotation #25730225 4 Document Date: 03/25/2016 Please find the attached quotation for your forthcoming term. Keeping your term current may entitle you to exclusive benefits, and if you choose to discontinue your coverage, you will become ineligible for these valuable benefits and services. If your quote is regarding software maintenance renewal, visit the following website for details regarding the maintenance program benefits at your licensing level http://www. esri.com/apps/products/maintenance/qualifying.cfm All maintenance fees from the date of discontinuation will be due and payable if you decide to reactivate your coverage at a later date. Please note: Certain programs and license types may have varying benefits. Complimentary User Conference registrations, software support, and software and data updates are not included in all programs. Customers who have multiple copies of certain Esri licenses may have the option of supporting some of their licenses with secondary maintenance. For information about the terms of use for Esri products as well as purchase order terms and conditions, please visit http://www. esri.com/legal/licensing/software-license.html If you have any questions or need additional information, please contact Customer Service at 888-377-4575 option 5. • esri Date: 03/25/2016 e 380 New York Street Redlands, CA 92373 Phone: 909-793-28533485 Quotation Number: 25730225 Quotation City of Waterloo Planning & Zoning Dept 715 Mulberry St Waterloo IA 50703 Attn: Aric Schroeder Customer Number: 159163 For questions regarding this document, please contact Customer Service at 888-377-4575. Item Qty Material# Send Purchase Orders To: Environmental Systems Research Institute, Inc. 380 New York Street Redlands, CA 92373-8100 Attn: Hannah Lehmann Please include the following remittance address on your Purchase Order: Environmental Systems Research Institute, Inc. File #54630 Los Angeles, CA 90074-4630 Unit Price Extended Price 10 1 87192 400.00 400.00 ArcGIS for Desktop Basic Single Use Primary Maintenance Start Date: 02/01/2016 End Date: 01/31/2017 4010 3 87193 ArcGIS for Desktop Basic Single Use Secondary Maintenance Start Date: 03/01/2016 End Date: 01/31/2017 276.30 828.90 5010 5 87193 300.00 1,500.00 ArcGIS for Desktop Basic Single Use Secondary Maintenance Start Date: 02/01/2016 End Date: 01/31/2017 6010 3 114511 250.00 750.00 ArcPad Maintenance Start Date: 02/01/2016 End Date: 01/31/2017 7010 1 114511 230.25 230.25 This quotation is good for 90 days. Any estimated sales and/or use tax has been calculated as of the date of this quotation and is merely provided as a convenience for your organization's budgetary purposes. Esri reserves the right to adjust and collect sales and/or use tax at the actual date of invoicing. If your organization is tax exempt or pays state taxes directly, then prior to invoicing, your organization must provide Esri with a copy of a current tax exemption certificate issued by your state's taxing authority for the given jurisdiction. Esri may charge a fee to cover expenses related to any customer requirement to use a proprietary vendor management, procurement, or invoice program. Issued By: Hannah Lehmann Ext: 3485 To expedite your order, please reference your customer number and thls quotation number on your purchase order. [LEHMANNH] • 380 New York Street esri Date: 03/25/2016 Item Qty Material# ® Redlands, CA 92373 Phone: 909-793-28533485 Quotation Number: 25730225 Quotation Page 2 Unit Price Extended Price ArcPad Maintenance Start Date: 03/01/2016 End Date: 01/31/2017 DUNS/CEC: 06-313-4175 CAGE: OAMS3 Item Subtotal 3,709.15 Estimated Tax 0.00 Total $ 3,709.15 [LEHMANNH] esri 380 New York Street ® Redlands, CA 92373 Phone: 909-793-28533485 Date: 03/25/2016 Quotation No: 25730225 Customer No: 159163 Quotation Page 3 Item Qty Material# Unit Price Extended Price IF YOU WOULD LIKE TO RECEIVE AN INVOICE FOR THIS MAINTENANCE QUOTE YOU MAY DO ONE OF THE FOLLOWING: • RESPOND TO THIS EMAIL WITH YOUR AUTHORIZATION TO INVOICE • SIGN BELOW AND FAX TO 909-307-3083 • FAX YOUR PURCHASE ORDER TO 909-307-3083 • EMAIL YOUR PURCHASE ORDER TO Service(arlesri.com REQUESTS VIA EMAIL OR SIGNED QUOTE INDICATE THAT YOU ARE AUTHORIZED TO OBLIGATE FUNDS FOR YOUR ORGANIZATION AND THAT YOUR ORGANIZATION DOES NOT REQUIRE A PURCHASE ORDER. If there are any changes required to your quotation, please respond to this email and indicate any changes in your invoice authorization. If you choose to discontinue your support, you will become ineligible for support benefits and services. All maintenance fees from the date of discontinuation will be due and payable if you decide to reactivate your support coverage at a later date. This transaction is governed exclusively by the terms of your signed agreement with Esri, if any, or, where applicable, Esri's standard terms and conditions at www.esri.com/legal; such terms are incorporated in this quotation by reference. Acceptance is limited to the terms of this quotation. Federal government entities and government prime contractors authorized under FAR 51.1 may purchase under the terms of Esri's GSA Federal Supply Schedule. State of California government entities may purchase under the terms of http://www.esri.com/—/media/Files/Pdfs/ legal/pdfs/addendums/california.pdf, titled Addendum to State of California Purchases. Esri objects to and expressly rejects any different or additional terms contained in any purchase order, offer or confirmation sent or to be sent by buyer. In order to expedite processing, please reference the quotation number and any/all applicable Esri contract number(s) (e.g. MPA, ELA, SmartBuy, GSA, BPA) on your ordering document. By signing below, you are authorizing Esri to issue a software support invoice in the amount of $ plus sales tax, if applicable. Please check one of the following: I agree to pay any applicable sales tax. I am tax exempt. Please contact me if Esri does not have my current exempt information on file. Signature of Authorized Representative Date Name (Please Print) Title (LEHMANNHI Approval Date City Clerk Use Only Finance Committee 4/fl//V 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,000.00 plus est. shipping costs of $ 0.00 to pay for or purchase Four (4) additional Shieldware RMS licenses This purchase or expenditure is being made because: purchase additional license for Shieldware which is the operating system for the Police Departments computer data collection and state mandated reports Vendor selected for this purchase: Shield Technology Corporation ❑ Bids or written quotes were taken on this purchase, as follows: pi Bids or quotes were not taken on this purchase because: Shield Technology System is proprietary to the software used county wide and the Waterloo Police Department for our computer operating system Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: ❑x General Fund Bonds Road Use Tax ❑ Sewer ❑ Sanitation Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 415-11-1100-2106 (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available balance is spectfully sutted, M.za (Signature Dept. Flead or (Project Code) 415P6. at (Signature Finance Dept. Review) Date K:\shared goodies\forms\Expenditure Pre -Authorization (Mar 2010) City Clerk Use Only Finance Committee yl I I Approval Date City of Waterloo st Form Expenditure Authorization RegueUe to Foorize the following The Finance Committee of the City Council is here byrequestedDepartment to expend purchase or expenditure submitted by the Sewer to pay for or purchase $ 12,539.80 plus ext. shipping cost of $ 431.36 Pole Camera add -on SD Recordin Devris 3-each Rear view camera add -on for trans orters 4-each and accessories, for sewer TV inspectio This purchase or expenditure is being made because: Pole cameras ne-ded for manhole and levee ins,ection . Re vi-w amera for better operation when returning the camera. Vendor selected for this purchase: Municipal Pipe tool Co., LLC ❑Bids or written quotes were taken on this purchase, as follows ®Bids or quotes were not taken on this purchase because: Municipal Pipe tool Co., LLC is rep. for camera equipment. Total cost including freight is $12,971.16. Emergency purchase to TV inspect the piping on the river levees, has been purchased. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: General Fund: ❑Road Use Tax: ❑X Sewer: Sanitation: Bonds: This expenditure is to be coded to the following budget line -item: (II /4- 13,20 (Project Code) (Fund - Department - Activity - Account Number) (Pro 1 in which budgeted amount is $ O6 3 �°J ❑Federallother grants: DOther(specify): and the current available balance is Respectfully submitted, (Signature Dept. Head Or Designee) Date (Signature Finance Dept. Review) Date MUNICIPAL PIPE TOOL CO., LLC 515 5TH STREET - PO BOX 398 - HUDSON, IOWA 50643 Phone: 319-988-4205 Fax: 319-988-3506 Sewer Maintenance and Rehabilitation Contractors, JetNacuum Cleaning Television Inspections, I/1 Studies, Grouting, Trench less Technology Pipeline Repairs Phone: 291-4311 Fax: 291-4571 Sold To: CITY OF WATERLOO CITY CLERK 715 MULBERRY ST WATERLOO, IA 50703 Ship to: 3505 EASTON AVENUE WATERLOO, IA 50702 Invoice Invoice Number: 27283 Invoice Date: Mar21, 2016 Customer ID WATERLcity Sales Rep ID 06R OBI NSON Quantity Order Number MARK Shipping Method FEDEX AM Description POLE CAMERA ADD -ON SD RECORDING DEVICE 3.000E924 - KIT, DVR/SD ASSY, OZ2 452347/451916 Payment Terms Net 30 Days Ship Date Due Date 2/29/16 4/20/16 01, RETURNED PARTS ARE SUBJECT TO A 20% RE -STOCKING FEE Unit Price 1,245.0C RFrF gar! MAR 1xtens ion 3,735.00 Subtotal 3,735.00 Sales Tax Freight 242.89 Total Invoice Amount 3, 977 89 Interest Rates: Invoices are due 30 days after date of invoice. Interest will be charged on all past due invoices at the rate of 1.5% per month. If payment is not received within 30 days of invoice, interest will be assessed from the first day past due. Statements will be sent on a monthly basis. We hereby guarantee that the goods covered on this invoice were produced or manufactured in accordance with the applicable provisions of the fair labor standings act of 1938. Our responsibility ceases after we obtain receipt in good order from transportation company. All claims for damages, delay, or loss must be made against the transportation company. MUNICIPAL PIPE TOOL CO., LLC 515 5TH STREET - PO BOX 398 - HUDSON, IOWA 50643 Phone: 319-988-4205 Fax: 319-988-3506 Sewer Maintenance and Rehabilitation Contractors, JotNacuum Cleaning Television Inspections, I/1 Studies, Grouting, Trenchloss Technology Pipeline Repairs Phone: 291-4311 Fax: 291-4571 Sold To: CITY OF WATERLOO CITY CLERK 715 MULBERRY ST WATERLOO, IA 50703 Customer ID WATERLcity Sales Rep ID 06ROBINSON Quantity 4.0( 2.0( 1.0( 1.0C Ship to: 3505 EASTON AVENUE WATERLOO, IA 50702 Order Number JOE OR MARK Shipping Method FEDEX AM Description REAR VIEW CAMERA ADD -ON FOR 4 TRANSPORTERS WS960- KIT, REAR VIEW CAMERA, SPR W/0 LIFT HW693 - 0-RING, 2-043, BUNA-N QE361 - CABLE ASSY, BAT>CNTL, ANDRSON, OZ2 VST QE301 - CABLE ASSY, DISPLAY, OZII 450628/451368/451918/451902 Invoice Invoice Number: 27884 Invoice Date: Mar 21, 2016 Payment Terms Net 30 Days Ship Date Due Date 2/23/16 4/20/16 RETURNED PARTS ARE SUBJECT TO A 20% RE -STOCKING FEE ((nil Price 2,134.57 473 119.50 137.56 PErFFIIVFI; MAR Extension 8,538.26 9.46 119.50 137.56 Subtotal 8,804.80 Sales Tax Freight 188.47 Total Invoice Amount 8,993.27 Interest Rates: Invoices are due 30 days after date of invoice. Interest will be charged on all past due invoices at the rate of 1.5% per month. If payment is not received within 30 days of invoice, interest will be assessed from the first day past due. Statements will be sent on a monthly basis. We hereby guarantee that the goods covered on this invoice were produced or manufactured in accordance with the applicable provisions of the fair labor standings act of 1938. Our responsibility ceases after we obtain receipt in g ood order from transportation company. All claims for damages, delay, or loss must be made against the transportation company. City Clerk Use Only Finance Committee Approval Date_ 41t11/ 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 $ 5,118.00 plus ext. shipping cost of $ 235.00 Automatic Sampler and cable assy for sampling at 1.1V building. Department to expend to pay for or purchase This purchase or expenditure is being made because: Added sampling location required by renewed NPDFS Permit from 1DNR. Vendor selected for this purchase: Hach X Bids or written quotes were taken on this purchase, as follows Bids or quotes were not taken on this purchase because: Hach is rep. for this equipment. Total cost including freight is $5,353.00. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: nGeneral Fund: nRoad Use Tax: X Sewer: Sanitation: Bonds: 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) $ 3377ea0:66' 37;g,00D and the current available balance is $ 0.00 5; 7 (c4 Respectfully submitted, 1142-0 71iLiIJ 6,)� (Signature Dept. Head Or Designee) Date (Signature Finance Dept. Review) Federal/other grants: in which budgeted amount is Date Be Right' Quote Number: 100151846v1 Use quote number at time of order to ensure that you receive prices quoted Quote Date: 04-Apr-2016 Quote Expiration: 03-Jun-2016 CITY OF WATERLOO WASTE MANAGEMENT SERVICES 3505 EASTON AVE WATERLOO, IA 50702-2000 Name: Kathleen 5 Phone: 319-291-4553 Email: kathy.skillings@waterloo-ia.org Customer Account Number: 060785 Quotation Hach PO Box 608 Loveland, CO 80539-0608 Phone: (800) 227-4224 Email: quotes@hach.com Website: www.hach.com 1 ASR.CXXX1X11XX A5950 FRIG, 115V VINYL, 5.5GAL POLY 1 4,974 00 4,974.00 2 8528500 CABLE ASSY, AUX HALF, 7P F, 4FT 1 1 144.00 144.00 Freight: Ground Prepay and Add FCA: Hach's facility All purchases of Hach Company products and/or services are expressly and without limitation subject to Hach Company's Terms 8, Conditions of Sale ("Hach TCS"), Incorporated herein by reference and published on Hach Company's website at www.hach.com/terms. Hach TCS are contained directly and/or by reference in Hach's offer, order acknowledgment, and invoice documents. The first of the following acts constitutes an acceptance of Hach's offer and not a counteroffer and creates a contract of sale "Contract" in accordance with the Hach TCS: (i) Buyer's issuance of a purchase order document against Hach's offer; (ii) acknowledgement of Buyer's order by Hach; or (iii) commencement of any performance by Hach pursuant to Buyer's order. Provisions contained In Buyer's purchase documents (including electronic commerce Interfaces) that materially alter, add to or subtract from the provisions of the Hach TCS are not part of the Contract. Due to International regulations, a U.S. Department of Commerce Export License may be required. Hach reserves the right to approve specific shipping agents. Wooden boxes suitable for ocean shipment are extra. Specify final destination to ensure proper documentation and packing suitable for International transport. In addition, Hach may require : 1). A statement of intended end -use; 2).Certification that the intended end -use does not relate to proliferation of weapons of mass destruction (prohibited nuclear end use, chemical / biological weapons, missile technology); and 3). Certification that the goods will not be diverted contrary to U.S. law. ORDER TERMS: Terms are Subject to Credit Review Please reference the quotation number on your purchase order. Sales tax is not included. Applicable sales tax will be added to the Invoice based on the U.S. destination, if applicable provide a resale/exemption certificate. Shipments will be prepaid and added to invoices unless otherwise specified. Equipment quoted operates with standard U.S. supply voltage. Hach standard terms and conditions apply to all sales. Additional terms and conditions apply to orders for service partnerships. Prices do not include delivery of product. Reference attached Freight Charge Schedule and Collect Handling Fees. Standard lead time is 30 days. This Quote is good for a one time purchase. Budget Amendment Descriptions for 4/11/2017 Finance Committee Meeting Agenda: 1. Approve the project budget for the Airfield Pavement Management Maintenance System, funded with $99,800 in general city funds paid to the airport for the "purchase" of land previously acquired using federal funds, as submitted by the Airport department. 2. Approve the project budget amendment in the amount of $3,941.60 to budget for revenue received from MidAmerican Energy to be used for improvements at Young Arena, as submitted by Leisure Services. 3. Approve the budget amendment for the Library Miscellaneous Donations project to use cash donated in prior years to purchase library materials in the amount of $2,315, as submitted by the Library. Please use this for project budget descriptions on Finance agenda. Do not need to include this cover sheet in the Finance Committee packet. Budget Amendment Descriptions for 4/4/2017 Finance Committee Meeting Agenda: 1. Approve the project budget for the Nature Art Camp FY16, funded with a $500 donation from the Prairie Rapids Audubon Society, as submitted by the Cultural & Arts department. 2. Approve the project budget 5th and 6th Street Traffic Safety Improvements in the amount of $484,000 funded by the Iowa DOT, as submitted by the Traffic Operations department. 3.� Approve the budget amendment for the Central Garage to increase revenue by $1,500 to be �� used to spend an additional $1,500 on parts, as submitted by the Public Works director. Please use this for project budget descriptions on Finance agenda. Do not need to include this cover sheet in the Finance Committee packet. PROJECT BUDGET WORKSHEET- NON -CONSTRUCTION PAGE TWO Project Name (from page one) Airfield Pavement Management Maintenance System Department No. project will be budgeted under 29 Activity No. project will be budgeted under vai 1/ s ) 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 EXPENDITURES: City Clerk Use Only Finance Committee Approval Date V(I// Ao, (Each column should only include amounts by fund) Fund: ➢l7I�Q ��4i Fund: Fund: Fund: $ 99,800.00 Total $ 99,800.00 TOTALS $ 99,800.00 $ $ $ $ 99,800.00 1111 Salaries - Regular 1112 Salaries - Part Time 1315 Education & Training 1345 Travel - Official City 1346 Travel - Prof Training 1390 Contractual Services 2103 Engineering & Consulting (Signa ure Dep 99,800.00 TOTALS $ 99,800.00 $ ate 99,800.00 $ $ 99,800.00 (Signature Finance Dept. Review) IL iep Date !Ushered goodies Worms \Project Budget Worksheet FORM-NEW2D10.xls\Page 2 (Donat or NON-constr) (Mar 2010) PROJECT BUDGET WORKSHEET - ALL PROJECTS PAGE ONE Project Name Airfield Pavement Management Maintenance System N'L,/gO City Contract No. Project Manager Project Budget Total Keith Kaspari $ 99,800.00 1. How will this project be funded? A. Federal Grant Yes Grant Name B. State Grant Grant Name C. City Match No CFDA # Yes No Source of Funding D. Other Entities Yes Name No Land Release Funds 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 11 Yes No n ❑ ❑X ❑ El n❑ ❑ ❑X 6. Include a brief description of the project in the space below: (REQUIRED) Scope of work includes the completion of an Airfield Pavement Management Study and Analysis. Page 2 must be attached and signed. K:\shared goodieslforms\Project Budget Worksheet FORM-NEV2010.xls1Page 1 All Projects (Mar 2010) Completed forms should be routed directly to the Finance Dept. FINANCE DEPT. ONLY Finance C mittee approval required? YES NO If so, date approved: 1-/ I 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 2016 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 3 Reslipitetrbon. YAMI 3,941.60 010 37 4105 . YAMI 3,941.60 31? 1 RefiAMs 13 a 3, R . : ci i -:. TOTAL $3, 941.60 TOTAL This amendment is being requested because: for accountablity purposes these Mid -American Energy rebates needed to be added into the FY 2016 revenue budget $3,941.60 Prior Committee Actions (Dates): yl� (Signature Dept. mad - Iesignee) Date (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) K:Wsers\shared goodies\forms\Yami budget Amendment 03 23 2016.,ds (Apr 2003) Completed forms should be routed directly to the Finance Dept. City of Waterloo Line -Item Budget Amendment Request Form FINANCE DEPT. ONLY Finance ommittee approval required? YES NO (� If so, date approved: Y Q4 fa The Finance Committee of the City Council and/or Finance Dept. is hereby requested to authorize the following line -item budget amendment for FYE 2016 submitted by the Library Department: EXPENSES/REVENUE DECREASE EXPENDITURES (INCREASE REVENUE) INCREASE EXPENDITURES (DECREASE REVENUE) Fund Dept Activity Acct # Acct Name Proj Code Amount r and Dept Activity Acct # Acct Name Proj Code Amount 010 33 3160 3720 donations 33GFT.MISC 2,315.00 010 33 3160 1597 DVDs 2,315.00 TOTAL $2,315.00 TOTAL $2,315.00 This amendment is being requested because; �j to amend for current year revenue, G pipe, eer�i•,qed 6 /f?c/ aii sit 7 5-4 ti I-�/10 °matrons � #eJ bL-e ..t w� hau cd 5.2 /S Pi 0.AI-renbr t yr dAa--75bns .-#r,i- ke, ip ladn -to yend . Prior Committee Actions (Dates): Alrn L/4,?/‘ (AZ& 6-1 a,/ c:"14 (Signature Dept. Head or Designee) Date (Sign�u a Finance Dept. Review) Date Date Posted (Financ jl)ern., Completed forms should' be routed directlyto,ihe Finance Dept. FINANCE DEPT. ONLY Finance 9 n1mittee approval required? YES V NO ter, If so, date approved: `T/t 0 (. 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 2016 submitted by the Public Works Department: EXPENSES/REVENUE DECREASE EXPENDITURES (INCREASE,REVENUE) INCREASE EXPENDITURES (DECREASE REVENUE) Fund Dept Activity Acct # .Acct Name Proj Code','' Amount and Dept Activity Acct # Acct Name Proj Code Amount 010 18 7950 3873 Reimburse Service 1,500.00' 010 18 7950 1571 Equip Parts 1,500.00 TOTAL This amendment is being requested because: Transfer to cover expenses. $1,500.00 TOTAL /iri l u i ry TZJi7tz IS &e-rstU G l5 /ytvt2Z i7.yl j i7C .J,62 l »1oc LT-1t31464L4r $1,500.00 Prior Committee Actions (Dates): (Signature De ead or Designee) Date (Signature Finance Dept. Review) Date Date Posted (Finance Dept.) Knusers\shared goodies\forms\Lineltem Amendment -2016 - Transferto cover Expenses-2 -Public Works - April 2016.xls (Apr 2003)