The URL can be used to link to this page

Home My WebLink AboutCouncil Packet - 5/26/2020FINANCE COMMITTEE May 26, 2020 5:10 PM Harold E. Getty Council Chambers Members Chairperson Sharon Juon Vice Chairperson Patrick Morrissey Margaret Klein Roll Call: Approval of Agenda Approval of Minutes Minutes of May 18, 2020, as proposed. TRAVEL REQUESTS 1. Greg Ahlhelm, Building Official Class/Meeting: CEU Authority - Mechanical update class Destination: If not in Waterloo - Online Class Dates: June 9, 2020 Amount not to exceed: $275 PRE -AUTHORIZATION TO EXPEND OVER S1,000.00 2. Airport Amount and Estimated S/H: $15,100 Expenditure: Reimbursement to Benton's Sand and Gravel for prep work associated with the main waterline at the airport for construction of the Osprey Aviation Storage Hangar. 3. Airport Amount and Estimated S/H: $4,554 Expenditure: Reimbursement to Benton's Sand and Gravel for the replacement of two fire hydrants at the airport for the A-Line/P OS Aircraft Storage Hangar. 4. Fire Amount and Estimated S/H: $44,924.58 + $690 S/H Expenditure: Three (3) AeroClave Room Decontamination Systems. 5. Fire Amount and Estimated S/H: $2,451.40 Expenditure: Annual support for Enterprise Staff Scheduling Module. 6. Fire Amount and Estimated S/H: $2,013 Expenditure: Tuition payment for paramedic school, summer term. Page 1 of 129 7. Garage Amount and Estimated S/H: $4,558.31 + $250 S/H Expenditure: Bell Kit for the grinder at the Yard Waste site. 8. Police Amount and Estimated S/H: $18,455 Expenditure: Renewal of annual Maintenance Agreement for Sheildware. 9. Police Amount and Estimated S/H: $70,300 Expenditure: FARO 3D measuring, imaging and analysis system for crash and crime scene investigations. BILLS PAYMENT 10. May 26, 2020. ADJOURNMENT Kelley Felchle City Clerk Page 2 of 129 CITY OF WATERLOO Council Communication Minutes of May 18, 2020, as proposed. City Council Meeting: 5/26/2020 Prepared: REVIEWERS: Department Reviewer Action Date Clerk Office Higby, Nancy Approved 5/20/2020 - 9:57 AM ATTACHMENTS: Description Type u 5.18.2020 Finance Committee Minutes Backup Material Page 3 of 129 FINANCE COMMITTEE May 18, 2020 5:10 p.m. Harold E. Getty Council Chambers Members present: Vice Chairperson Pat Morrissey, Margaret Klein, and Chairperson Sharon Juon joined the meeting by telephone. Moved by Morrissey seconded by Klein that the Agenda, as proposed, be approved. Voice vote - Ayes: Three. Motion carried. Moved by Morrissey seconded by Klein that the Minutes of May 11, 2020, as proposed, be approved. Voice vote - Ayes: Three. Motion carried. Moved by Klein seconded by Morrissey that the request for the following travel requests, be approved. Travel Requests Name & Title of Personnel Class/Meeting Destination Date(s) Amount not to Exceed Martin M. Petersen, City Attorney Iowa State Bar Association Annual Meeting Webinar May 18-22, 2020 $125 Voice vote - Ayes: Three. Motion carried. Moved by Klein seconded by Morrissey that the request for the following pre -authorizations to expend over $1,000.00, be approved. Pre -Authorizations to Expend over $1,000.00 Dept. Amount + Est. S/H Expenditure Airport $6,272 Multi -level service and maintenance check for ALO's emergency generator. Airport $2,225 Replacement airfield guidance sign panels due to aging and weathering, and to comply with FAA Part-139 compliance standards. Fire $13,004.82 (3) computer tables and mounting hardware. Fire $33,566.63 (2) Lucas mechanical CPR devices. Garage $5,582.35 + $300 S/H Color front mount display, video cable, assembly battery cable, bottom tank assembly for Fire Truck #304. Leisure Services $3,900 Helical anchor design for fishing pier at Greenbelt Lake on Martin Road. Leisure Services $3,495 (102) trees and shrubs to be planted west of Greenbelt Lake. Neighborhood Services $4,060 (1) 6' x 6' x 6' enclosed trailer. Police $10,690.55 + $355 S/H Evidence drying cabinet for the crime lab with UV lights and wash down sprayer. Traffic $1,835 Autoscope camera and interface panel. Voice vote - Ayes: Three. Motion carried. Moved by Morrissey seconded by Klein that the budget amendment for the Capital Projects fund to budget for projects anticipated to be completed before June 30, 2020, funded with gaming donations and tax increment financing revenue in the total amount of $3,900,000, as submitted by the Finance Department, be approved. Voice vote - Ayes: Three. Motion carried. Page 4 of 129 Finance Committee May 18, 2020 Page 2 Moved by Morrissey seconded by Klein that the budget amendment to budget for anticipated hotel/motel tax grants payments to be paid before June 30, 2020, in the total amount of $120,000, as submitted by the Finance Department, be approved. Voice vote - Ayes: Three. Motion carried. Moved by Morrissey seconded by Klein that the budget amendment to budget for Convention Center activities in the amount of $1,000,000, as submitted by the Finance Department, be approved. Voice vote - Ayes: Three. Motion carried. Moved by Morrissey seconded by Klein that the budget amendment to budget for increased debt service expense owed by the Sewer Fund to the Debt Service Fund in the amount of $78,657, as submitted by the Finance Department, be approved. Voice vote - Ayes: Three. Motion carried. Moved by Morrissey seconded by Klein that the budget amendment to budget for the Metro Coalition revenue and expense, in the total amount of $60,000, as submitted by the Finance Department, be approved. Voice vote - Ayes: Three. Motion carried. Moved by Morrissey seconded by Klein that the project budget for the Neighborhood Services Party Trailer project, funded with donations from Black Hawk County Gaming and VGM, in the total amount of $10,500, as submitted by the Community Development Department, be approved. Voice vote - Ayes: Three. Motion carried. Moved by Morrissey seconded by Klein that the budget amendment to increase Local Option Tax fund expenses and intergovernmental revenue for the payment from Water Works to be paid to DOT for Highway 63 construction, in the amount of $1,300,000, be approved. Voice vote - Ayes: Three. Motion carried. Moved by Juon seconded by Morrissey that Bills Payment, as contained in Accounts Payable Invoice Report, dated May 18, 2020, in the amount of $13,777,930.75 be received, placed on file and approved and forwarded to the full council for approval. Voice vote - Ayes: Three. Motion carried. With no further business before the committee, it was moved by Morrissey seconded by Klein that the meeting be adjourned at 5:17 p.m. Voice vote - Ayes: Three. Motion carried. Kelley Felchle City Clerk Page 5 of 129 CITY OF WATERLOO Council Communication Greg Ahlhelm, Building Official City Council Meeting: 5/26/2020 Prepared: 5/21/2020 REVIEWERS: Department Reviewer Action Date Building Department Even, LeAnn Approved 5/21/2020 - 4:25 PM ATTACHMENTS: Description Type ❑ Departmental Request Backup Material Page 6 of 129 FINANCE DEPT. STAFF ONLY LINE ITEM USED Uf(I a.7- 57a /3li(/ TRAVEL REQUEST CITY OF WATERLOO FY ,20,0 BUDGETED EXPENDED YTD THIS REQUEST LEFT AFTER THIS REQUEST DATE Original - Clerk/Finance 2??& 5',z.o -24) Copy - Department NAME(S) AND POSITION(S): Greg Ahlhelm, Building Official DATE: 5/19/2020 NAME OF CLASS / MEETING: CEU Authority — mechanical update class DESTINATION DEPARTURE POINT IF NOT WATERLOO Online Class DEPARTURE DATE: 6/9/2020 RETURN DATE: 6/9/2020 DATE(S) OF MEETING: 6/9/2020 PURPOSE OF TRAVEL/TRAINING Required Continuing Education — license renewal WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: x COST $ YES NO METHOD OF TRAVEL: CITY VEHICLE PRIVATE VEHICLE AIRFARE DEPARTING FROM: ESTIMATE OF COST: LODGING TAXI MEALS PARKING 275.00 REGISTRATION AIRFARE MILEAGE/FUEL MISC/TOLLS TOTAL FOR ALL: $ 275.00 BUDGET LINE ITEM: 010-22-5100-1346 X GRANT REIMBURSABLE YES NO X YES NO REQUIRED CERTIFICATION TOTAL: $ 275.00 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO I APPROVE THIS TRAVEL REQUEST DEPARTMENT HEAD MAYOR �9- 2a 20 tIA\1;Biared Goodies\Forms\Travel Request Forcer January 2010 DATE Page 7 of 129 CITY OF WATERLOO Council Communication Airport City Council Meeting: 5/26/2020 Prepared: REVIEWERS: Department Reviewer Action Date Airport Even, LeAnn Approved 5/21/2020 - 4:44 PM ATTACHMENTS: Description Type ❑ Department Requests Backup Material Page 8 of 129 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 Airport Department to expend $ 15,100.00 plus est. shipping costs of $ N/A to pay for or purchase This request is for the reimbursement to Benton's S&G for the site prep work associated with the main waterline at the airport for construction of the Osprey Aviation Storage Hngr. This purchase or expenditure is being made because: To allow Benton to properly bury the main waterline for this hangar and the airport fire station at the proper depth to prevent any damage to the line during winter freeze -ups. Vendor selected for this purchase: Benton's Sand & Gravel of Cedar Falls, Iowa Bids or written quotes were taken on this purchase, as follows: As site prep work for the hangar was on -going, it was discovered that the main water line for this hangar, which also provides the main water source for the ALO fire station was not buried deep enough to prevent future frost heaves of the line itself. Bids or quotes were not taken on this purchase because: Therefore, as Airport Director, I am asking for support to bury this, and then to replace approx. 180LF of nearly 50-year old pipe & hydrant at the NW corner of Hangar No: 4. City Engineer supports the cost & deems appropriate. Site grading is also very import. Prior Committee Actions (Dates): REF. Budget Amendment Request from Staff. Please check the following box(es) as appropriate to describe the funding for this expense: nGeneral Fund ❑ Road Use Tax n Sewer ❑ Sanitation n Bonds n Federal/other grants n Other (specify) This expenditure is to be coded to the following budget line -item: 010 - 29 - 7700 - 1371 (Bldgs & Grds Maintenance) N/A (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is -nd t e urrent available balance is R: sp- tf Ily ubmitted, 5f � 114,005.00 ,?0z93 13 30" 18,9 02 + 20,295 B/A 38 3”6. (Signature Det/He-• or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\05 18 2020 Site Work for Osprey Aircraft Hangar (Mar 2010) Page 9 of 129 CITY OF WATERLOO Council Communication Airport City Council Meeting: 5/26/2020 Prepared: REVIEWERS: Department Reviewer Action Date Airport Even, LeAnn Approved 5/21/2020 - 4:48 PM ATTACHMENTS: Description Type ❑ Departmental Request Backup Material Page 10 of 129 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 Airport Department to expend $ 4,554.00 plus est. shipping costs of $ N/A to pay for or purchase This request is for the reimbursement to Benton's S&G for the replacement of two fire hydrants at the airport for the A -Line / POS Aircraft Storage Hangar. This purchase or expenditure is being made because: As Airport Director for ALO, I did not want nearly 50-year old hydrants to go back into an installation of a new hangar to provide water suppression if needed during an emergency. Vendor selected for this purchase: Benton's Sand & Gravel of Cedar Falls, Iowa Bids or written quotes were taken on this purchase, as follows: Also, as Airport Director, I verbally gave my word to Benton's staff that as the lease - holder for this structure, a building which will eventually be the property of the City, wanted new hyrants for this new aircraft storage hangar. Bids or quotes were not taken on this purchase because: These two new hydrants will not just provide a water source for the hangar for future fire suppression, but also the General Aviation Terminal Building, Hangars 3-A & 3-B, and also the Kingfisher Hangar and Car Wash Building & Snow Equip. Storage Bldg. Prior Committee Actions (Dates): REF: Budget Amendment Request from Staff. Please check the following box(es) as appropriate to describe the funding for this expense: General Fund Bonds Road Use Tax n Sewer n Sanitation Federal/other grants ❑ Other (specify) This expenditure is to be coded to the following budget line -item: 010 - 29 - 7700 - 1371 (Bldgs & Grds Maintenance) (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available balance is (Sig ature Dept or Designee) D_te N/A (Project Code) $ 1-14,005..0 4- a0.1q.f s /6V, 30V P $ .2-8`1 (Signature Finance Dept. Review) Date K:\shared goodies\forms\05 18 2020 Fire Hydrants for Aircraft Hangar (Mar 2010) Page 11 of 129 CITY OF WATERLOO Council Communication F ire City Council Meeting: 5/26/2020 Prepared: REVIEWERS: Department Reviewer Action Date Fire Rescue Even, LeAnn Approved 5/21/2020 - 4:31 PM ATTACHMENTS: Description Type ❑ Departmental Request Backup Material Page 12 of 129 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 Fire Department to expend $ 44,924.58 plus est. shipping costs of $ 690.00 to pay for or purchase Three (3) AeroClave Room Decontamination Systems. This purchase or expenditure is being made because: we need an approved decontamination system to use in our ambualnces as well as fire stations. Vendor selected for this purchase: AeroClave, LLC X Bids or written quotes were taken on this purchase, as follows: Bids or quotes were not taken on this purchase because: Single Source-AeroClave is the leader in EPA certified instantaneous decontamination systems and has no authorized distributors. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: X General Fund Bonds ❑X Road Use Tax Sewer n Sanitation Federal/other grants n Other (specify) This expenditure is to be coded to the following budget line -item: 12GRTCARES2110/419-12-1410-2117 CARES/Ambulance Replace (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ 42,857.90 / 540,000.00 and the current available balance is Respec Ily s $ 42,857.90 / 59,369.73 S-1e-ace (Signature •-pt. Head or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\AeroClave Pre-Authorization.xls (Mar 2010) Page 13 of 129 / l�l AerC/ate BILL TO: AeroClave, LLC 4007 Forsyth Road Winter Park Quote Florida Valid Till: Jun 13, 2020 United States 32792 Quote Number : 1491633000010453215 SHIP TO: 425 E. 3rd Street 425 E. 3rd Street Waterloo Waterloo Iowa Iowa United States United States 50703 50703 Account Name:Waterloo Fire Rescue (IA) Quote Stage: Contact Name:Pat Treloar S.N o. rpduct Details Qty, List Price Discount Total 1. S3110 -HGAC 3 $13,509.04 $ 0.00 $ 40,527.12 AeroClave Room Decontamination System, Model 3110. APA25 - HGAC AeroClave Portable Applicator, Hand Sprayer, 25' 3 $ 1,205.28 $ 0.00 $ 3,615.84 3. VOXU12 - HGAC 6 $130.27 $ 0.00 $ 781.62 Vital Oxide disinfectant solution, 1 Case, Four 1 Gal. Bottles ea. 4. RDS3110 - shipping 3 $175.00 $ 0.00 $ 525.00 Shipping and Handling 5. APA25 - shipping 3 $ 15.00 $ 0.00 $ 45.00 Shipping and Handling 6. VOXU12 - shipping 6 $ 20.00 $ 0.00 $ 120.00 Shipping and Handling Sub Total $ 45,614.58 Tax $ 0.00 Adjustment $ 0.00 Grand Total $ 45,614.58 Terms and Conditions ***WE ARE NOT ACCEPTING RETURNS/CANCELLATIONS UNDER ANY CIRCUMSTANCES DURING THIS CRITICAL TIME*** ALL PRICES ARE LISTED IN USD ($) The information contained in this quote is applicable for 30 days. On -site training is available for $2,000/day. Vital -Oxide Disinfectant pricing is as follows (1 case = four 1 gallon bottles): • 1-11 cases - $140.00 USD (GSA: $126.95 USD) per case + $20.00 shipping per case • 12-47 cases - $132.00 USD (GSA: $119.90 USD) per case + free shipping (Contiguous United States only) • 48 case pallet - $120.00 USD (GSA: $108.82 USD) per case + free shipping (Contiguous United States only) Hardware and Vital Oxide quantity discounts available. With each purchase, AeroClave will provide 12 months free parts and labor warranty. For customers within a 30-mile radius, this will be performed on -site. For customers outside a 30-mile radius, AeroClave will provide a loaner unit while the unit is under repair. If unit problem is determined to Page 14 of 1 9 be a manufacturing or workmanship defect, AeroClave will pay for the shipping both ways. If problem is determined to be caused by operator error or abuse, freight cost will be the responsibility of the owner. Should you have any questions regarding this quote, please contact Michael Quinoy (mquinoy@aeroclave.com). We look forward to working with you. Thanks for your business! AeroClave LLC Page 15 of 129 HeroIwo u ` May 14, 2020 Sent via email to: pat.treloara(�waterloo-ia.orq Pat Treloar Waterloo Fire Rescue Department 425 E. 3rd Street Waterloo, IA 50703 Subject:AeroClave RDS 3110 Sole Source Justification AeroClave is the world's foremost producer of large-scale decontamination equipment. AeroClave has developed decontamination solutions for the military, healthcare, life science, police/fire/EMS, and athletics industries. AeroClave is pleased to provide the following information for a sole source justification for the purchase of the AeroClave RDS 3110 decontamination system. The RDS 3110 uses proprietary technology and process to decontaminate rooms, vehicles, and equipment. The system utilizes a proprietary pulsed application process that involves using an EPA registered hospital disinfectant solution, which is atomized and kills microorganisms in the air and on surfaces The RDS 3110 is currently the only product available that: • Can provide a full-scale, instantaneous decontamination of surfaces that is: o Safe, easy to use (non -corrosive, minimal training required) o Quick (under 30 minutes for average size room, under 20 minutes for a rescue) o Green (no byproducts) • Can effectively treat bacteria, viruses, molds and mildew • Can decontaminate facilities, vehicles and equipment — with the same unit • Same unit can be operated in either room fogging or hand spray modes • Can integrate directly into a vehicle or room via AeroClave's proprietary ADP technology, a patented component that provides unique functionality to the unit (U.S. Patent No. 9,913,923). • Uses an inexpensive disinfectant solution (approximate $35/gallon) • Can operate in the open environment (items being treated do not need to be encapsulated) • Can operate in a wide range of environmental conditions both indoors and outdoors • Offers a 12-month full factory warranty including temporary loaner units There is no other singular like item available for purchase that would serve the same purpose with the same functionality as the AeroClave RDS 3110. AeroClave is the sole manufacturer of this equipment and has no authorized distributors, therefore the unit must be purchased directly from AeroClave, LLC in Winter Park, Florida. Additionally, AeroClave is the only one authorized to perform factory warranty service on the unit. If there are any questions pertaining to the information provided above, please feel free to contact Michael Quinoy at 407-788-3300 ext. 101 or email at mquinoyna.aeroclave.com. Sincerely, M. Quhv oy Michael G. Quinoy Vice President of Commercial Sales AeroClave, LLC. 4007 Forsyth Road Winter Park, FL 32792 Phone: 407.788.3300 Fax: 407.339.0019 www.aeroclave.com Page 16 of 129 CITY OF WATERLOO Council Communication Fire City Council Meeting: 5/26/2020 Prepared: REVIEWERS: Department Reviewer Action Date Fire Rescue Even, LeAnn Approved 5/21/2020 - 4:54 PM ATTACHMENTS: Description Type ❑ Departmental Request Backup Material Page 17 of 129 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 WFR Department to expend $ 2,451.40 plus est. shipping costs of $ none to pay for or purchase Annual support for Enterprise Staff Sceduling Module. This purchase or expenditure is being made because: Annual support for Enterprise Staff Scheduling module for Firehouse system. Vendor selected for this purchase: ESO Solutions, Inc. n Bids or written quotes were taken on this purchase, as follows: Single Source Provider 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: n General Fund n Road Use Tax Bonds ❑ Federal/other grants ❑ Sewer n Sanitation Other (specify) This expenditure is to be coded to the following budget line -item: 010-12-1400-1520 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the cu _=..e._ available balance is $ $ ai `r y 5? ✓ (SignatureyIe.t. Head or Designee) Date (Sign ture Finance Dept. Review) Date Page 18 of 129 CITY OF WATERLOO Council Communication F ire City Council Meeting: 5/26/2020 Prepared: REVIEWERS: Department Reviewer Action Date Fire Rescue Even, LeAnn Approved 5/21/2020 - 5:01 PM ATTACHMENTS: Description Type ❑ Departmental Request Backup Material Page 19 of 129 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 Fire Department Department to expend $ 2,013.00 plus est. shipping costs of $ 0.00 to pay for or purchase Tuition payment for paramedic school summer term This purchase or expenditure is being made because: FF/EMT Ben Weber is enrolled in and attending Paramedic School at Hawkeye Community College. Vendor selected for this purchase: Hawkeye Community College n Bids or written quotes were taken on this purchase, as follows: n Bids or quotes were not taken on this purchase because: It is the only local source for this education Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: n General Fund nBonds El Road Use Tax n Sewer n Sanitation Federal/other grants n Other (specify) This expenditure is to be coded to the following budget line -item: 010-12-1410 1346 (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available balance is Respectful) (Project Code) $ la 9-�✓ $ ev13°% (Signature Dept./ ead or Designee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Ben Weber Summer Semester Tuition.xls (Mar 2010) Page 20 of 129 HAWKEYE COMMUNITY COLLEGE Hawkeye Community College 1501 E Orange Rd PO Box 8015 Waterloo, IA 50704-8015 Benjamin D. Weber 4240 Lavenz Ln Waterloo, IA 50701-9393 Please Account Activity Summary - 2020 Summer Term Student Statement Name Benjamin D. Weber Student ID 0157257 Total Balance $2,013.00 Amount Due 6/1/2020 $2,013.00 Total Amount Due $2,013.00 Amount Enclosed ............ Charges Tuition by Section Fees + Total Charges $1, 870.00 $143.00 $2,013.00 = 2020 Summer Term Balance $2,013.00 = Total Amount Due Course Schedule BI0-168-5 B10-173-4 HSC-113-1 $2,013.00 Total Balance Hum Anat & Physiology I w/Lab Human Anatomy & Physiology II Medical Terminology 2.00 4.00 4.00 Account Activity Details - 2020 Summer Term MTuWTh FSaSu MTuWTh FSaSu MTuWTh FSaSu MTuWTh FSaSu MTuWTh FSaSu TBD TBD TBD TBD TBD WEB WEB WEB WEB WEB WEB ai $2,013.00 Etld Dates 5/18/2020- 6/29/2020 WEB WEB WEB 6/30/2020- WEB WEB 8/11/2020 WEB WEB WEB 6/1/2020-7/27/2020 WEB Page 21 of 129 HAWKEYE by Section BIO-168-5 BIO-173-4 HSC-113-1 Total Fees Hum Anat & Physiology! w/Lab Human Anatomy & Physiology II Medical Terminology Name Student ID $748.00 4.00 $748.00 4.00 $374.00 2.00 Student Statement - Page 2 Benjamin D. Weber New New New 0157257 $1,870.00 i ,tion Student Activity Fee Computer Fee Social Science Lab Fee Total Balance $45.00 $40.00 $58.00 $143.00 $2,013.00 Page 22 of 129 CITY OF WATERLOO Council Communication Garage City Council Meeting: 5/26/2020 Prepared: REVIEWERS: Department Reviewer Action Date Traffic Operations Even, LeAnn Approved 5/21/2020 - 4:39 PM ATTACHMENTS: Description Type ❑ Departmental Request Backup Material Page 23 of 129 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 Traffic Department to expend $ 4,558.31 plus est. shipping costs of $ 250.00 to pay for or purchase Belt Kit for the Grinder at the Yard Waste Site This purchase or expenditure is being made because: To replace damaged belt on Grinder (Vermeer is only vendor to supply this belt kit) Vendor selected for this purchase: Vemeer X Bids or written quotes were taken on this purchase, as follows: Vemeer Iowa Des Moines, Iowa $4,558.31 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 Road Use Tax Bonds Federal/other grants Sewer Other (specify) This expenditure is to be coded to the following budget line -item: 010-18-7955-1571 Sanitation (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is and the current available balance is Respectfully submitted, • 1 i �7✓ $ 249,9490.00 1/5(wp $ So?/3L3 (Sig ature Dept. ea: or Designee) Date (Signat re Finance Dept. Review) Date K:\shar- goodies\forms\2020-May-Pre-Auth-Belt Kit for Grinder - Vermeer -Garage-Sanitation-010-18-7955-1571 $4,558.31-S { ls(maar of 129 2010) rd CITY OF WATERLOO Council Communication Police City Council Meeting: 5/26/2020 Prepared: REVIEWERS: Department Reviewer Action Date Police Department Even, LeAnn Approved 5/21/2020 - 4:51 PM ATTACHMENTS: Description Type ❑ Departmental Request Backup Material Page 25 of 129 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 Police Department to expend $ 18,455.00 plus est. shipping costs of $ 0.00 to pay for or purchase Renewal of annual maintenance agreement for Sheildware This purchase or expenditure is being made because: this is an annual renewal that supports the Sheildware system that is used by the Police Department for data collection and State of Iowa mandated reports. Vendor selected for this purchase: Sheid Technology Corporation nBids or written quotes were taken on this purchase, as follows: n Bids or quotes were not taken on this purchase because: This system is what is used countywide and is propretary to the Sheild Technology Corporation. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: 0 General Fund Bonds Road Use Tax n Sewer n Sanitation Federal/other grants n Other (specify) This expenditure is to be coded to the following budget line -item: 010-11-1105-1520 (Fund - Department - Activity - Account Number) in which the budgeted amount is and the current available balance is Respectfully submit ed, (Signsre Dep . Head or Designee) (Project Code) $ /O2elGS C 2O 7 Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\Shieldware renewal 2020.xisx (Mar 2010) Page 26 of 129 CITY OF WATERLOO Council Communication Police City Council Meeting: 5/26/2020 Prepared: REVIEWERS: Department Reviewer Action Date Police Department Even, LeAnn Approved 5/21/2020 - 4:37 PM ATTACHMENTS: Description Type ❑ Departmental Request Backup Material Page 27 of 129 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 Police Department to expend $ 70,300.00 plus est. shipping costs of $ 0.00 to pay for or purchase FARO 3D measuring, imaging and analysis system for crash and crime scene investigations. This purchase or expenditure is being made because: this system will document in 3D imaging for criminal investigations in place of the current total station measuring that takes extensive man hours to complete. Vendor selected for this purchase: FARO 3D Visionary ❑ Bids or written quotes were taken on this purchase, as follows: n Bids or quotes were not taken on this purchase because: FARO has the government contract, GSA Contract-GS-07F-197GA. This is also proprietary to FARO. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: ❑ General Fund nBonds El Road Use Tax ❑ Sewer n Sanitation Federal/other grants n Other (specify) Covid 19 This expenditure is to be coded to the following budget line -item: 010-11-1150-2110 Machinery and Equipment 11GRT Covid 19 (Fund - Department - Activity - Account Number) (Project Code) in which the budgeted amount is $ and the current available balance is Respectfully submitted, as -13 2c) (Sign ure De t. ead esignee) Date (Signature Finance Dept. Review) Date K:\shared goodies\forms\FARO imaging 2020 Covid.xlsx (Mar 2010) Page 28 of 129 CITY OF WATERLOO Council Communication May 26, 2020. City Council Meeting: 5/26/2020 Prepared: REVIEWERS: Department Reviewer Action Date Finance Higby, Nancy Approved 5/20/2020 - 9:57 AM ATTACHMENTS: Description Type ❑ Preliminary Cover Invoice Report Backup Material ❑ Preliminary Summary Invoice Report Backup Material ❑ Preliminary Detail Invoice Report Backup Material Page 29 of 129 City of Waterloo Finance Committee Preliminary Draft Invoice Report As of Friday, May 22, 2020 For May 26, 2020 Approval Finance Committee Accounts Payable Open Invoice Report Total As of Friday, May 21, 2020 EFT Transactions: 2,352,148.11 GATSO 33,192.00 Iowa Finance Authority 212,915.21 Bank Fees 2,158.26 2,600,413.58 Workers Compensation Issued by TPA Housing Authority Housing Assistance EFT's Housing Authority Housing Assistance EFT's Payroll 1,291.62 434,115.76 1,685,942.78 Bill Payment Total - Friday, May 22, 2020 4,721,763.74 Payment to Council members or related entities: Page 30 of 129 Invoice Number Invoice Description Vendor 2 - AABLE PEST CONTROL INC 1095494 PEST CONTROL, MAY '20 1095829 QTRLY BIRD SERV - PARK & 218 OVER PASS Vendor 4825 - ACCO 0202049-IN FLOW METER REPAIRS - GATES POOL 0202050-IN FLOW METER REPAIRS - BYRNES POOL Vendor 8258 - ACES 70126 SERVER SUPPORT W/ MONITORING FOR (4) WITH EXCHANGE FOR 5/1/2020 70132 SAFETY NET EMAIL CONT. 5/1/2020 70136 SERVER SUPPORT W/MONITORING (3) 5/1/2020 70146 RECON BASE PLATFORM FOR WORKSTATIONS FOR 5/1/2020 70151 SECURITY INFORMATION & EVENT MGMT 5/1/2020 70152 BORDER PATROL MGMT ON HARDWARE 5/1/2020 70204 EMAIL ENCRYPTION SERVICES 5/1/2020 70218 SCREEN CONNECT AGREEMENT FOR MAY (2) 70219 ANTIVIRUS BUNDLE LICENSE FOR 5/1/2020 Vendor 10373 - ADVANTAGE SCREENPRINT 28756 STAFF SHIRTS Vendor 5419 - AECOM TECHNICAL SERVICES, INC 2000356429 CONSULTANT SVCS, FY-20 IDOT CSVI, 4/4/20-5/1/20 2000356442 CONSULTANT SVCS, RECONSTRUCT T/W B; REMOVE TREES, 4/4/20-5/1/20 Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Summary Listing Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Edit 05/15/2020 05/26/2020 05/26/2020 110.00 Edit 05/16/2020 05/26/2020 05/26/2020 05/18/2020 450.00 Edit 05/11/2020 05/26/2020 05/26/2020 05/15/2020 Edit 05/11/2020 05/26/2020 05/26/2020 05/15/2020 Vendor 4825 - ACCO Totals Invoices Edit 05/01/2020 05/26/2020 05/26/2020 Edit 05/01/2020 05/26/2020 05/26/2020 Edit 05/01/2020 05/26/2020 05/26/2020 Edit 05/01/2020 05/26/2020 05/26/2020 Edit 05/01/2020 05/26/2020 05/26/2020 Edit 05/01/2020 05/26/2020 05/26/2020 Edit 05/01/2020 05/26/2020 05/26/2020 Edit 05/01/2020 05/26/2020 05/26/2020 Edit 05/01/2020 05/26/2020 05/26/2020 Vendor 8258 - ACES Totals Invoices Edit 05/14/2020 05/26/2020 05/26/2020 Vendor 10373 - ADVANTAGE SCREENPRINT Totals Invoices 1 $990.00 2 $560.00 619.68 619.68 2 $1,239.36 852.56 712.00 639.44 490.44 460.00 459.00 48.00 14.00 8.75 9 $3,684.19 990.00 Vendor 2 - AABLE PEST CONTROL INC Totals Invoices Edit 05/08/2020 05/26/2020 05/26/2020 Edit 05/08/2020 05/26/2020 05/26/2020 10,819.75 76,545.41 Run by Emily Graham on 05/22/2020 02:49:03 PM Page 31 of 129 Page 1 of 19 Invoice Number 2000357701 200357692 Invoice Description CONT 1014 PHASE IVA CIP PIPELINING APR 11-MAY 8 CONT 919 2018 PHASE IIIB, PHASE IIIC Vendor 11320 - AGVANTAGE FS, INC. 53007318 #2 ULTRA LS DYED 53007355 GASOHOL Status Edit Edit Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Summary Listing Held Reason Invoice Date 05/12/2020 05/12/2020 Vendor 5419 - AECOM TECHNICAL SERVICES, INC Totals Edit Edit Vendor 72 - ARAMARK UNIFORM SERVICES, INC. 1877329670 MATS, TOWELS - CARNEGIE Edit 1877328937 JANITORIAL Edit SERVICES/UNIFORMS 1877330319 MOPS, TOWEL SERVICE Edit 1877327705 AIRFRESHNER & MAT CLEANING Edit AT THE WPD TRAINING CENTER 1877328935 JANITORIAL Edit SERVICES/UNIFORMS 1877332322 WKLY SERVICES Edit 1877332319 UNIFORMS/RUGS CLEANING & Edit RENTAL Vendor 3222- 46CR003212 46NV027598 46NV027599 46CR003216 46NV027619 46NV027736 46NV027740 46NV027770 46CR003233 46NV027795 46NV027797 46NV027865 46CR003262 46NV027956 46NV027970 46NV027981 ARNOLD MOTOR SUPPLY CREDIT MARINE DEEP CYCLE SERVICE MARINE/RV DEEP CYCLE SERVICE CORE CREDIT MARINE/RV DEEP CYCLE SERVICE OIL FILTERS SCREWDDRIVER LED ACCESSORY LIGHT CORE CREDIT RAVEN GLV XL HYDRAULIC PARTS WHEEL BEARINGS & HYB ASSEMBLY CORE CREDIT 02 SENSOR ALTERNATOR COUPLERS Due Date G/L Date Received Date Payment Date 05/26/2020 05/26/2020 05/26/2020 05/26/2020 Invoices 4 05/01/2020 05/26/2020 05/26/2020 05/04/2020 05/26/2020 05/26/2020 Vendor 11320 - AGVANTAGE FS, INC. Totals Invoices 05/12/2020 05/26/2020 05/26/2020 05/14/2020 05/11/2020 05/26/2020 05/26/2020 05/13/2020 05/26/2020 05/26/2020 05/07/2020 05/26/2020 05/26/2020 05/11/2020 05/26/2020 05/26/2020 05/18/2020 05/26/2020 05/26/2020 05/18/2020 05/26/2020 05/26/2020 Vendor 72 - ARAMARK UNIFORM SERVICES, INC. Totals Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit 04/28/2020 04/28/2020 04/28/2020 Invoices 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 04/29/2020 05/26/2020 05/26/2020 04/29/2020 05/26/2020 05/26/2020 05/01/2020 05/01/2020 05/02/2020 05/04/2020 05/04/2020 05/04/2020 05/05/2020 05/07/2020 05/07/2020 05/07/2020 05/07/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 2 7 Invoice Net Amount 8,303.15 13,044.63 $108,712.94 6,614.35 8,401.05 $15,015.40 62.21 136.51 122.44 41.17 95.31 416.28 18.89 $892.81 (166.99) 166.99 166.99 (72.00) 166.99 20.16 3.99 70.69 (45.00) 129.90 97.83 244.89 (36.00) 66.86 190.20 12.78 Run by Emily Graham on 05/22/2020 02:49:03 PM Page 32 of 129 Page 2 of 19 Invoice Number 46NV027985 46NV028008 46NV028054 46NV028095 Invoice Description PRESSURE SWITCH WATERPROOF ON/OFF SWITCH HYDRAULIC COUPLER STOCK PARTS Vendor 82 - ASPRO INC., & SUBSIDIARIES 965-17 CONT 965 FY2019 STREET RECON PROGRAM 993-3 CONT 993 FY20 STREET RECON 888002-10839 888001-34654 PROGRAM SURFACE MIX UPM COLD MIX Vendor 95 - AUTOMOTIVE SERVICE SOLUTIONS 55707 ALTERNATOR #217 Status Edit Edit Edit Edit Edit Edit Edit Edit Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Summary Listing Held Reason Invoice Date Due Date 05/07/2020 05/08/2020 05/09/2020 05/11/2020 Vendor 3222 - ARNOLD MOTOR SUPPLY Totals 05/26/2020 05/26/2020 05/26/2020 05/26/2020 G/L Date 05/26/2020 05/26/2020 05/26/2020 05/26/2020 Received Date Invoices 20 05/15/2020 05/26/2020 05/26/2020 05/15/2020 05/26/2020 05/26/2020 05/09/2020 05/26/2020 05/26/2020 05/16/2020 05/26/2020 05/26/2020 Vendor 82 - ASPRO INC., & SUBSIDIARIES Totals Invoices Payment Date Invoice Net Amount 32.87 13.69 19.96 336.51 $1,421.31 585.70 344,687.72 359.04 1,241.72 4 $346,874.18 Edit 05/06/2020 05/26/2020 05/26/2020 613.13 Vendor 95 - AUTOMOTIVE SERVICE SOLUTIONS Totals Invoices 1 $613.13 Vendor 117 - B & B BUILDERS & SUPPLY 981-7 CONT 981 2019 SIDEWALK Edit ASSESSMENT Vendor 107 - BAKER & TAYLOR 2035193604 YOUTH PRINT Vendor 20722 - BBE PRO TOOLS LLC 58870 SCAN TOOL Vendor 8069 - BDI 9501251298 DICHTO 25#BAG X2 Vendor 2262 - BENTON'S READY MIX CONCRETE 176826 C-4 176873 C-4 Vendor 144 - BITUMINOUS MATERIAL & SUPPLY, 2213222552 CRS-2 Edit Edit Edit Edit Edit 05/14/2020 05/26/2020 05/26/2020 101,352.12 Vendor 117 - B & B BUILDERS & SUPPLY Totals Invoices 04/29/2020 05/26/2020 05/26/2020 Vendor 107 - BAKER & TAYLOR Totals Invoices $101,352.12 14.12 $14.12 03/19/2020 05/26/2020 05/26/2020 11,359.98 Vendor 20722 - BBE PRO TOOLS LLC Totals Invoices 05/14/2020 05/26/2020 05/26/2020 Vendor 8069 - BDI Totals Invoices 05/06/2020 05/26/2020 05/26/2020 05/07/2020 05/26/2020 05/26/2020 Vendor 2262 - BENTON'S READY MIX CONCRETE Totals Invoices Edit 05/11/2020 05/26/2020 05/26/2020 $11,359.98 5.66 $5.66 605.00 484.00 2 $1,089.00 942.86 Vendor 144 - BITUMINOUS MATERIAL & SUPPLY, Totals Invoices 1 $942.86 Run by Emily Graham on 05/22/2020 02:49:03 PM Page 33 of 129 Page 3 of 19 Invoice Number Invoice Description Status Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Summary Listing Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 112 - BMC AGGREGATES LC 81016 WASHED CHIPS Edit Vendor 21979 - BROCK EVEN CONSTRUCTION LLC 1009-1 CONT 1009 SIDEWALK AND Edit TRAIL REPAIR PROGRAM Vendor 21977 - SCOTT BRUNSON 1217287 BOUNCE FS SHEETS 04/30/2020 05/26/2020 05/26/2020 734.43 Vendor 112 - BMC AGGREGATES LC Totals Invoices 1 $734.43 05/15/2020 05/26/2020 05/26/2020 35,991.18 Vendor 21979 - BROCK EVEN CONSTRUCTION LLC Totals Edit Vendor 240 - C & C WELDING & SAND BLASTING 74100 CYLINDER JD 7330 LEVY Edit TRACTOR Invoices 1 $35,991.18 05/11/2020 05/26/2020 05/26/2020 21.40 Vendor 21977 - SCOTT BRUNSON Totals Invoices 1 $21.40 05/07/2020 05/26/2020 05/26/2020 260.75 Vendor 240 - C & C WELDING & SAND BLASTING Totals Invoices Vendor 7986 - C.J. COOPER & ASSOC. INC 151920 HR RANDOM DRUG SCREENINGS Edit 05/11/2020 05/26/2020 05/26/2020 05/12/2020 Vendor 221 - CAMPBELL SUPPLY CO INV-00143536 TOOLS INV-00142905 INV-00143563 INV-00142896 INV-001423588 INV-00142678 INV-00143066 INV-00143240 PLUMBING WH - FIRE STAT #1 SAFETY GLOVES - BLDG MAINT SPRAYER SHACKLE SCREW PINS SDS AND BLADE FRAMING JIGSAW BLADES ELASTIC UNA, GRIND WHL, ROW STEEL Edit Edit Edit Edit Edit Edit Edit Edit Vendor 20056 - CAN -AM AUTOMOTIVE & TOWING W20-33788 TOW FROM BEECH/ONEIDA TO Edit WPD IMPOUND W20-33788 Vendor 21974 - CARBON6 INC 1043 25 TON TILT 1 $260.75 630.00 Vendor 7986 - C.J. COOPER & ASSOC. INC Totals Invoices 1 $630.00 05/14/2020 05/26/2020 05/26/2020 05/12/2020 05/26/2020 05/26/2020 05/18/2020 05/14/2020 05/26/2020 05/26/2020 05/18/2020 05/12/2020 05/26/2020 05/26/2020 05/11/2020 05/26/2020 05/26/2020 05/11/2020 05/26/2020 05/26/2020 05/12/2020 05/26/2020 05/26/2020 05/13/2020 05/26/2020 05/26/2020 Vendor 221 - CAMPBELL SUPPLY CO Totals Invoices 619.11 115.18 25.98 119.99 113.72 19.53 21.63 128.52 8 $1,163.66 05/14/2020 05/26/2020 05/26/2020 110.00 Vendor 20056 - CAN -AM AUTOMOTIVE & TOWING Totals Edit Vendor 243 - CEDAR BEND HUMANE SOCIETY, INC 050120E APRIL SURRENDERS 2020 Edit Invoices 09/30/2019 05/26/2020 05/26/2020 Vendor 21974 - CARBON6 INC Totals Invoices $110.00 25,274.00 $25,274.00 05/08/2020 05/26/2020 05/26/2020 3,772.50 Run by Emily Graham on 05/22/2020 02:49:03 PM Page 34 of 129 Page 4 of 19 Invoice Number Invoice Description Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Summary Listing Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 243 - CEDAR BEND HUMANE SOCIETY, INC Totals Invoices 1 Vendor 6693 - CEDAR VALLEY LAWN CARE 80944 BLACK SOIL FOR STUMP HOLES Edit 04/24/2020 05/26/2020 05/26/2020 81004 BLACK SOIL FOR STUMP HOLES Edit 05/11/2020 05/26/2020 05/26/2020 $3,772.50 1,260.00 420.00 Vendor 6693 - CEDAR VALLEY LAWN CARE Totals Invoices 2 $1,680.00 Vendor 21833 - CENTRAL IOWA DISTRIBUTING 194887 GLOVES Edit 05/06/2020 05/26/2020 05/26/2020 195214 SOAP, SANITIZER Edit 05/12/2020 05/26/2020 05/26/2020 431.00 421.20 Vendor 21833 - CENTRAL IOWA DISTRIBUTING Totals Invoices 2 $852.20 Vendor 3639 - KIM CHAPMAN 113-4932014-9029 LOCKS FOR FISH TANK CABINET Edit 04/23/2020 05/26/2020 05/26/2020 16.00 MCOM35504099 DISPOSABLE MASKS Edit 05/08/2020 05/26/2020 05/26/2020 126.06 2020-00002369 LIBRARYWORKS WEBINAR Edit 05/13/2020 05/26/2020 05/26/2020 49.00 Vendor 3639 - KIM CHAPMAN Totals Invoices 3 $191.06 Vendor 8567 - CLAPSADDLE-GARBER ASSOC. INC. 41504 CONT 979 HWY SANITARY Edit 04/30/2020 05/26/2020 05/26/2020 1,904.65 SEWER Vendor 8567 - CLAPSADDLE-GARBER ASSOC. INC. Totals Invoices 1 $1,904.65 Vendor 21975 - COLLABORATIVE SUMMER LIBRARY PROGRAM 7740 SLP MINI STICKERS Edit 05/14/2020 05/26/2020 05/26/2020 21.25 Vendor 21975 - COLLABORATIVE SUMMER LIBRARY PROGRAM Totals Invoices 1 $21.25 Vendor 20229 - COPY SYSTEMS, INC IN376782 POSTAGE MAILING TAPES Edit 05/07/2020 05/26/2020 05/26/2020 20.60 Vendor 20229 - COPY SYSTEMS, INC Totals Invoices 1 $20.60 Vendor 7625 - COURIER 181392A INTENT TO RELEASE FUNDS Edit 05/05/2020 05/26/2020 05/26/2020 05/05/2020 116.80 Vendor 7625 - COURIER Totals Invoices 1 $116.80 Vendor 348 - CRESCENT ELECTRIC SUPPLY CO. S507848364.001 LIGHTS Edit 05/08/2020 05/26/2020 05/26/2020 Vendor 4577 - D & J OIL COMPANY 70700 GASOLINE - SHOP Vendor 414 - D & K PRODUCTS 0508295-IN TURF PRODUCTS 182.73 Vendor 348 - CRESCENT ELECTRIC SUPPLY CO. Totals Invoices 1 $182.73 Edit Edit 05/13/2020 05/26/2020 05/26/2020 884.00 Vendor 4577 - D & J OIL COMPANY Totals Invoices 1 $884.00 05/06/2020 05/26/2020 05/26/2020 2,105.95 Run by Emily Graham on 05/22/2020 02:49:03 PM Page 35 of 129 Page 5 of 19 Invoice Number Invoice Description Status Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Summary Listing Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 414 - D & K PRODUCTS Totals Invoices 1 $2,105.95 Vendor 388 - DELL MARKETING L.P. 10391562823 DELL LATITUDE 7390 2-IN1 CTO Edit 05/06/2020 05/26/2020 05/26/2020 893.84 BASE Vendor 3079 - DENNIS SUPPLY CO. WA01192743-001 AIR FILTERS - FIRE STAT #3 Edit Vendor 388 - DELL MARKETING L.P. Totals Invoices 1 $893.84 05/11/2020 05/26/2020 05/26/2020 05/14/2020 61.56 Vendor 3079 - DENNIS SUPPLY CO. Totals Invoices 1 $61.56 Vendor 13186 - DIAMOND OIL COMPANY 500682 UNLEADED GASOHOL Edit 04/20/2020 05/26/2020 05/26/2020 7,478.18 Vendor 13186 - DIAMOND OIL COMPANY Totals Invoices 1 $7,478.18 Vendor 1599 - DICK WITHAM FORD 33.36 MUDFLAPS Edit 04/29/2020 05/26/2020 05/26/2020 33.36 263661 NUTS Edit 05/04/2020 05/26/2020 05/26/2020 14.00 Vendor 6386 - ELECTRONIC ENGINEERING 345000125-1 PARTS & LABOR FOR KEMP'S CAR Edit CAMERA HAVING VIDEO ISSUES Vendor 471 - EXPRESS SERVICES, INC. 23894650 YDW SECURITY MARY A. Edit HOLMAN Vendor 12909 - FARMERS STATE BANK 2020-00002355 April Bank Fees Edit Vendor 1599 - DICK WITHAM FORD Totals Invoices 2 $47.36 04/24/2020 05/26/2020 05/26/2020 127.50 Vendor 6386 - ELECTRONIC ENGINEERING Totals Invoices 1 $127.50 04/29/2020 05/26/2020 05/26/2020 554.36 Vendor 471 - EXPRESS SERVICES, INC. Totals Invoices 1 $554.36 05/25/2020 05/26/2020 05/26/2020 1,642.37 Vendor 12909 - FARMERS STATE BANK Totals Invoices 1 $1,642.37 Vendor 11488 - FERGUSON ENTERPRISES, INC. 7485551 REPL GRINDER PUMP - ART Edit 05/11/2020 05/26/2020 05/26/2020 05/18/2020 1,052.00 CENTER 7514616 PLUMBING - ART CENTER Edit 05/11/2020 05/26/2020 05/26/2020 05/18/2020 192.00 7520044 TANKLESS WH - FIRE STAT #1 Edit 05/11/2020 05/26/2020 05/26/2020 05/18/2020 1,745.56 7521551 PLUMBING WH - FIRE STAT #1 Edit 05/12/2020 05/26/2020 05/26/2020 05/18/2020 407.49 7523429 PLUMBING - ART CENTER Edit 05/12/2020 05/26/2020 05/26/2020 05/18/2020 652.93 7522998 IRRIGATION REPAIR Edit 05/12/2020 05/26/2020 05/26/2020 26.19 Vendor 11488 - FERGUSON ENTERPRISES, INC. Totals Invoices 6 $4,076.17 Vendor 21982 - FIVE SULLIVAN BROTHERS CONVENTION CENTER 10000018 CONV CTR OFFICE CARPET Edit 04/30/2020 05/26/2020 05/26/2020 8,076.03 Run by Emily Graham on 05/22/2020 02:49:03 PM Page 36 of 129 Page 6 of 19 Invoice Number 10000019 Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Summary Listing Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount CONV CTR TIMECLOCK Edit 04/30/2020 05/26/2020 05/26/2020 3,766.93 Vendor 21982 - FIVE SULLIVAN BROTHERS CONVENTION CENTER Totals Invoices 2 $11,842.96 Vendor 21398 - ANGIE FORDYCE 43977 REFUND PERSONAL TRAINING Edit 05/15/2020 05/26/2020 05/26/2020 400.00 Vendor 21398 - ANGIE FORDYCE Totals Invoices 1 $400.00 Vendor 4516 - FRIENDS OF THE LIBRARY 2020-00002368 REIMBURSE CC USE CANVA Edit 05/15/2020 05/26/2020 05/26/2020 119.40 SOFTWARE ANNUAL SUBSCRIPTION Vendor 4516 - FRIENDS OF THE LIBRARY Totals Invoices 1 $119.40 Vendor 515 - GALE/CENGAGE LEARNING 70149864 ADULT PRINT Edit 03/20/2020 05/26/2020 05/26/2020 20.24 70272081 ADULT PRINT Edit 04/22/2020 05/26/2020 05/26/2020 105.72 70272135 ADULT PRINT Edit 04/22/2020 05/26/2020 05/26/2020 270.00 Vendor 515 - GALE/CENGAGE LEARNING Totals Invoices 3 $395.96 Vendor 21540 - GATSO 2019--2305 ATE 4/12/20 - 4/25/20 Edit 05/25/2020 05/26/2020 05/26/2020 17,136.00 2019--2339 ATE 4/26/20 - 5/11/20 Edit 05/25/2020 05/26/2020 05/26/2020 16,056.00 Vendor 21540 - GATSO Totals Invoices 2 Vendor 538 - GIERKE-ROBINSON COMPANY 3122302-000 CUT DIAMOND BLADE Edit 05/12/2020 05/26/2020 05/26/2020 Vendor 538 - GIERKE-ROBINSON COMPANY Totals Invoices 1 $33,192.00 170.69 $170.69 Vendor 547 - GOODYEAR COMMERCIAL TIRE & SERVICE CENTERS 119-1061585 TIRES Edit 05/04/2020 05/26/2020 05/26/2020 808.36 Vendor 547 - GOODYEAR COMMERCIAL TIRE & SERVICE CENTERS Totals Invoices 1 $808.36 Vendor 553 - GRAINGER 9531576461 RETHREADING DIE CARBON Edit 05/13/2020 05/26/2020 05/26/2020 81.52 STEEL 9534374682 PRE -MOISTENED TOWELETTE Edit 05/15/2020 05/26/2020 05/26/2020 43.70 STAND PK 100 Vendor 553 - GRAINGER Totals Invoices 2 $125.22 Vendor 564 - GROUT MUSEUM OF HISTORY AND SCIENCE 2020-5 May 2020 Property Taxes Edit 05/25/2020 05/26/2020 05/26/2020 Vendor 13038 - HALL & ASSOCIATES 10799 APRIL SERVICES 42,105.38 Vendor 564 - GROUT MUSEUM OF HISTORY AND SCIENCE Totals Invoices 1 $42,105.38 Edit 05/14/2020 05/26/2020 05/26/2020 761.25 Run by Emily Graham on 05/22/2020 02:49:03 PM Page 37 of 129 Page 7 of 19 Invoice Number Vendor 1952 - X101148716:01 X101148934:01 X101148946:01 X101148946:02 X101149011:01 X101148716:02 X101149669:01 Invoice Description HARRISON TRUCK CENTERS PARTS FOR 193B08 HOSE VALVE VALVE BATTERY BOX PARTS FOR 193B08 WATER PUMP KITS Vendor 587 - HAWKEYE ALARM & SIGNAL CO 80686 SERVICE CALL 80671 INSTALLED ALARM SYSTEM @ YDW SITE Vendor 21872 - HENKEL CONSTRUCTION COMPANY 1978M.02 16W EST #2 - 5 SULL BROS KITCHEN PLUMBING IMPROVEMENTS 1978M.03 16W EST #3-5 SULL BROS KITCHEN PLUMBING IMPROVEMENTS Status Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Summary Listing Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 13038 - HALL & ASSOCIATES Totals Invoices 1 $761.25 Edit 04/30/2020 Edit 04/30/2020 Edit 04/30/2020 Edit 05/01/2020 Edit 05/01/2020 Edit 05/04/2020 Edit 05/11/2020 Edit Edit Vendor 1952 - HARRISON TRUCK CENTERS Totals 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 Invoices 05/03/2020 05/26/2020 05/26/2020 05/03/2020 05/26/2020 05/26/2020 812.06 37.96 187.65 187.65 108.03 387.71 595.47 7 $2,316.53 400.00 930.00 Vendor 587 - HAWKEYE ALARM & SIGNAL CO Totals Invoices 2 $1,330.00 Edit 02/04/2020 05/26/2020 05/26/2020 05/14/2020 96,330.00 Edit 03/18/2020 05/26/2020 05/26/2020 05/14/2020 44,655.89 Vendor 21872 - HENKEL CONSTRUCTION COMPANY Totals Vendor 21609 - I & S GROUP, INC 64532 20AC TRUCK WASH REVIEW Edit Vendor 730 - I W I MOTOR PARTS 2277728 CARBIDE CUTTER Edit Invoices 2 $140,985.89 04/30/2020 05/26/2020 05/26/2020 690.00 Vendor 21609 - I & S GROUP, INC Totals Invoices 1 $690.00 05/05/2020 05/26/2020 05/26/2020 15.30 Vendor 730 - I W I MOTOR PARTS Totals Invoices 1 $15.30 Vendor 11799 - INTERSTATE BATTERIES OF UPPER IOWA 22153423 BATTERIES Edit 05/06/2020 Vendor 11799 - INTERSTATE BATTERIES OF UPPER IOWA Totals Vendor 723 - IOWA DEPARTMENT OF TRANSPORTATION 61449 GUARDRAIL Edit 04/24/2020 Vendor 862 Vendor 723 - IOWA DEPARTMENT OF TRANSPORTATION Totals 20112 - IOWA ECONOMIC DEVELOPMENT AUTHORITY Conversion Item Edit 05/26/2020 05/26/2020 05/26/2020 518.20 Invoices 1 $518.20 05/26/2020 149.94 Invoices 1 $149.94 05/13/2020 05/26/2020 05/26/2020 750.00 Run by Emily Graham on 05/22/2020 02:49:03 PM Page 38 of 129 Page 8 of 19 Invoice Number Vendor C0906RT-0620I C0906RT-0620P C0906RT-620F C0990RT-0620I C0990RT-0620P C099ORT-620F Invoice Description Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Summary Listing Status Held Reason Invoice Date Due Date Vendor 20112 - IOWA ECONOMIC DEVELOPMENT AUTHORITY Totals 11839 - IOWA FINANCE AUTHORITY SRF INTEREST SRF PRINCIPAL SRF SERVICE FEE SRF INTEREST SRF PRINCIPAL SRF SERVICE FEE Vendor 21473 - IOWA ONE CALL 220985 APRIL 2020 LOCATE EMAILS 221103 APRIL EMAILS Vendor 4101 - IOWA WALL SAWING SERVICE 031927 CORE DRILLING - FIRE STAT #6 031928 CORE DRILLING - FIRE STAT #2 Edit 05/01/2020 Edit 05/01/2020 Edit 05/01/2020 Edit 05/01/2020 Edit 05/01/2020 Edit 05/01/2020 Vendor 11839 - IOWA FINANCE AUTHORITY Totals Edit Edit Edit Edit 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 G/L Date Received Date Payment Date Invoices 1 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 Invoices 6 05/15/2020 05/26/2020 05/26/2020 05/15/2020 05/26/2020 05/26/2020 Invoice Net Amount $750.00 12,845.00 69,000.00 1,835.00 5,455.81 123,000.00 779.40 $212,915.21 210.60 1,006.30 Vendor 21473 - IOWA ONE CALL Totals Invoices 2 $1,216.90 05/05/2020 05/26/2020 05/26/2020 05/12/2020 05/05/2020 05/26/2020 05/26/2020 05/12/2020 Vendor 4101 - IOWA WALL SAWING SERVICE Totals Invoices Vendor 4895 - IOWA WORKFORCE DEVELOPMENT 165937 ELEV PERMIT #8076 - CARNEGIE Edit 05/08/2020 05/26/2020 05/26/2020 05/14/2020 Vendor 4895 - IOWA WORKFORCE DEVELOPMENT Totals Invoices Vendor 10535 - JIM HAWK TRUCK TRAILERS 2201260013 0-RING SEAL Vendor 748 - JOHNSTONE SUPPLY 1064122 HVAC - FIRE STAT #1 1064213 HVAC - FIRE STAT #1 Vendor 788 - K & S WHEEL ALIGNMENT SERVICE 133228 TIRES Edit 05/05/2020 05/26/2020 05/26/2020 Vendor 10535 - JIM HAWK TRUCK TRAILERS Totals Invoices Edit Edit 350.00 450.00 2 $800.00 75.00 1 $75.00 345.14 1 $345.14 05/11/2020 05/26/2020 05/26/2020 05/14/2020 62.40 05/13/2020 05/26/2020 05/26/2020 05/14/2020 61.94 Vendor 748 - JOHNSTONE SUPPLY Totals Invoices 2 $124.34 Edit 05/11/2020 05/26/2020 05/26/2020 Vendor 788 - K & S WHEEL ALIGNMENT SERVICE Totals Invoices Vendor 364 - K. CUNNINGHAM CONSTRUCTION 970-11 CONT 970 FY20 DYSART RD & W Edit 2ND STREET RECON Vendor 6845 - KWIK TRIP INC. 8334889 CAN GAS 910.08 1 $910.08 05/14/2020 05/26/2020 05/26/2020 220,159.19 Vendor 364 - K. CUNNINGHAM CONSTRUCTION Totals Edit Invoices 1 $220,159.19 05/15/2020 05/26/2020 05/26/2020 11.25 Run by Emily Graham on 05/22/2020 02:49:03 PM Page 39 of 129 Page 9 of 19 Invoice Number Vendor 8889 - 169993 Vendor 21085 1015-2 05082020 Invoice Description Status LOCKSPERTS REKEY OF THE NEW PROPERTY Edit STORAGE BLDG - LODGE CONSTRUCTION INC CONT 1015 FY20 COURTLAND, Edit JEFFERSON AND MULBERRY STREET RECON CONT 949 REMEDIAL ACTION PH Edit IIIB PAY EST #7 RETAINAGE RELEASE Vendor 2922 - MACQUEEN EQUIPMENT INC. P09834 PARTS FOR 190805 P10294 WATER TANK Vendor 845 - MANATT'S INC. 981198 900 W 7TH ST Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Summary Listing Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 6845 - KWIK TRIP INC. Totals Invoices 1 $11.25 05/08/2020 05/26/2020 05/26/2020 242.24 Vendor 8889 - LOCKSPERTS Totals Invoices 1 $242.24 05/14/2020 05/26/2020 05/26/2020 98,440.90 05/08/2020 05/26/2020 05/26/2020 22,159.79 Vendor 21085 - LODGE CONSTRUCTION INC Totals Invoices 2 Edit 03/12/2020 05/26/2020 05/26/2020 Edit 05/04/2020 05/26/2020 05/26/2020 $120,600.69 12,138.48 59.15 Vendor 2922 - MACQUEEN EQUIPMENT INC. Totals Invoices 2 $12,197.63 Edit Vendor 848 - MANPOWER, INC 40164337 YDW ATTENDANT/ CHARLES Edit LANDFAIR Vendor 855 - MARTIN BROS DIST CO INC 8429946 CONCESSIONS - SPORTSPLEX Vendor 8147 - MEDIACOM 2020-00002371 RT - CABLE & WI-FI 2020-00002370 RT - INTERNET Vendor 885 - MENARDS 57061 HARDWARE - BLDG MAINT 57504 HVAC - FIRE STAT #1 57551 PLUMBING - FIRE STAT #1 57153 CLEANING MATERIALS/COVID19 57063 RT - VINYL AND BASE FOR COMMON BATHROOM AREA 05/15/2020 05/26/2020 05/26/2020 348.75 Vendor 845 - MANATT'S INC. Totals Invoices 1 $348.75 05/10/2020 05/26/2020 05/26/2020 777.46 Vendor 848 - MANPOWER, INC Totals Invoices Edit 05/15/2020 05/26/2020 05/26/2020 Edit Edit Edit Edit Edit Edit Edit 1 $777.46 378.47 Vendor 855 - MARTIN BROS DIST CO INC Totals Invoices 1 $378.47 05/07/2020 05/26/2020 05/26/2020 4,670.96 05/12/2020 05/26/2020 05/26/2020 147.72 Vendor 8147 - MEDIACOM Totals Invoices 2 $4,818.68 05/06/2020 05/12/2020 05/12/2020 05/07/2020 05/06/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/14/2020 05/14/2020 05/14/2020 29.14 52.59 36.11 15.47 406.54 Run by Emily Graham on 05/22/2020 02:49:03 PM Page 40 of 129 Page 10 of 19 Invoice Number 57203 57219 56131 56562 57671 56973 57518 57576-1 Invoice Description EARPLUGS & STAPLEGUNS (3) CORDLESS IMPACT DRIVER & ACCESSORIES PROPANE TANKS FOR DURAPATCHER WONDER MOP PAINT SUPPLIES WRAP, CORDS BLADES SCREWS Status Edit Edit Edit Edit Edit Edit Edit Edit Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Summary Listing Held Reason Invoice Date Due Date 05/08/2020 05/26/2020 05/08/2020 05/26/2020 04/23/2020 04/29/2020 05/12/2020 05/05/2020 05/12/2020 05/12/2020 Vendor 885 - MENARDS Totals G/L Date 05/26/2020 05/26/2020 Received Date Payment Date Invoice Net Amount 80.90 174.99 05/26/2020 05/26/2020 13.88 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 Invoices Vendor 891 - METROPOLITAN TRANSIT AUTHORITY 2020-5 May 2020 Property Taxes Edit 05/25/2020 05/26/2020 05/26/2020 Vendor 891 - METROPOLITAN TRANSIT AUTHORITY Totals Invoices Vendor 911 - 2020-00002362 2020-00002363 2020-00002365 399684479 399682595 39996261 399974121 2020-00002366 2020-00002367 399718126 399949046 399997529 MIDAMERICAN ENERGY UTILITIES - HANGAR 4, ACCT Edit #56560-12025 UTILITIES-19 AIRPORT Edit LOCATIONS; ACCT #19741- 28008 UTILITIES - GOLF, PARK Edit 4/8-5/7 SERVICE AT 348 N ELK Edit RUN RD- WPD TRAINING CENTER APRIL UTILITIES; 113 E 8TH ST Edit APRIL/MAY UTILITIES; 225 Edit COMMERCIAL; CHARGING STATION APRIL/MAY UTILITIES; 321 W Edit 6TH ST TC 82231-04006 TRF LT Edit SUMMARY 03791-34016 STREET LIGHTING Edit 07030-18029 3260 LAFAYETTE Edit LIFT 431 03720-63005 80 W MULLAN AVE Edit PUMP 96190-18017 1314 BLACK HAWK Edit ST STORM BLDG Vendor 904 - MIDLAND SCIENTIFIC INC 6064207 CREDIT RETURN 6091505 RICCA DIMETHYLGLYOXIME Edit Edit 05/07/2020 8.37 28.02 20.23 31.96 23.78 13 $921.98 92,300.47 1 $92,300.47 05/26/2020 05/26/2020 68.81 05/12/2020 05/26/2020 05/26/2020 05/15/2020 05/07/2020 05/07/2020 05/14/2020 05/14/2020 05/11/2020 05/11/2020 05/08/2020 05/14/2020 05/14/2020 Vendor 911 - MIDAMERICAN ENERGY Totals 03/17/2020 05/11/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 5,709.81 595.70 179.18 3.94 68.97 05/26/2020 40.85 05/26/2020 4,375.80 05/26/2020 460.34 05/26/2020 10.00 05/26/2020 57.68 05/26/2020 125.50 Invoices 12 $11,696.58 05/26/2020 05/26/2020 (425.74) 05/26/2020 05/26/2020 75.17 Run by Emily Graham on 05/22/2020 02:49:03 PM Page 41 of 129 Page 11 of 19 Invoice Number 6091586 6092110 Invoice Description SULFIDE, POTASSIUM AMMONIUM CHLORIDE Status Edit Edit Vendor 11769 - MIDWEST JANITORIAL SERVICE INC 214322 MAY JANITORIAL - CITY HALL Edit 214323 MAY JANITORIAL - PD TRNG Edit CNTR 214471 MAY JANITORIAL - W PARKING Edit RAMP 214472 MAY JANITORIAL - VET MEM Edit HALL 214473 MAY JANITORIAL - CARNEGIE Edit 214157 CLEAN & DISINFECT ALL AREAS Edit OF WPD 214325 MAY JANITORIAL Edit Vendor 2274 - MIDWEST TAPE 98852437 DVD 98852438 98872703 98872705 98872706 98872707 98872708 98872709 98872710 98872711 98872712 98872713 98872714 98872715 98872716 98872717 98872718 BOOK ON CD BOOK ON CD DVDS BLURAY DVD DVD DVDS DVDS DVD DVD DVDS DVDS DVD DVDS DVDS DVDS Vendor 912 - MIDWEST WHEEL CO. 1952204-00 SEAT SAVER Vendor 5690 - MOTION INDUSTRIES Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Summary Listing Held Reason Invoice Date Due Date 05/11/2020 05/26/2020 05/12/2020 05/26/2020 Vendor 904 - MIDLAND SCIENTIFIC INC Totals 05/12/2020 05/12/2020 05/12/2020 05/12/2020 05/12/2020 04/29/2020 05/12/2020 Vendor 11769 - MIDWEST JANITORIAL SERVICE INC Totals Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit 05/04/2020 05/04/2020 05/06/2020 05/06/2020 05/06/2020 05/06/2020 05/06/2020 05/06/2020 05/06/2020 05/06/2020 05/06/2020 05/06/2020 05/06/2020 05/06/2020 05/06/2020 05/06/2020 05/06/2020 Vendor 2274 - MIDWEST TAPE Totals G/L Date Received Date Payment Date 05/26/2020 05/26/2020 Invoice Net Amount 251.16 124.68 Invoices 4 $25.27 05/26/2020 05/26/2020 05/14/2020 4,249.00 05/26/2020 05/26/2020 05/14/2020 285.00 05/26/2020 05/26/2020 05/14/2020 150.00 05/26/2020 05/26/2020 05/14/2020 207.00 05/26/2020 05/26/2020 05/14/2020 837.00 05/26/2020 05/26/2020 1,980.00 05/26/2020 05/26/2020 1,426.00 Invoices 7 $9,134.00 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 Invoices 04/30/2020 05/26/2020 05/26/2020 Vendor 912 - MIDWEST WHEEL CO. Totals Invoices 23.69 79.98 40.94 385.25 37.84 56.58 58.08 168.39 56.58 39.04 28.44 150.81 90.43 20.29 89.47 207.66 150.21 17 $1,683.68 194.52 1 $194.52 Run by Emily Graham on 05/22/2020 02:49:03 PM Page 42 of 129 Page 12 of 19 Invoice Number IA02-265763 IA02-266225 Invoice Description Status LATEX DISPOSABLE INDUSTRIAL Edit GRADE LATEX DISPOSABLE CREDIT Edit Vendor 958 - MUNICIPAL PIPE TOOL CO., LLC 05082020 CONT 962 PAY EST #5, FY2019 Edit CIP PIPELINING PHASE IIIC Vendor 7808 1370500 1370738 1371509 1372448 1373768 1373770 1373775 1375517 1377128 1377291 - MURPHY TRACTOR & EQUIPMENT PARTS FOR 194B02 PIN FASTENERS PARTS FOR 194B02 ORIFICE/PIN PARTS FOR 194E CONTROL VALVE/O-RING HYDRAULIC CYLINDER ROD 0-RING/SEALS SEAL V-BELT Vendor 961 - MUTUAL WHEEL COMPANY 5531558 STOCK PARTS 5532361 5532533 5532597 5532846 Vendor 224788 225646 225866 226206 226233 CLIP/VALVES ALCOHOL EVAP PARTS FOR 193B06 TP3DC VLV 966 - NAPA AUTO PARTS FILTERS AIR FILTER AIR FILTER AIR FILTERS CAP #7531 Vendor 20466 - BENJAMIN NEIL FY2OSHOE FY20 BOOT ALLOWANCE Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Summary Listing Held Reason Invoice Date Due Date G/L Date Received Date Payment Date 04/22/2020 05/26/2020 05/26/2020 05/12/2020 Vendor 5690 - MOTION INDUSTRIES Totals 05/08/2020 Vendor 958 - MUNICIPAL PIPE TOOL CO., LLC Totals Edit 04/30/2020 Edit 04/30/2020 Edit 05/01/2020 Edit 05/04/2020 Edit 05/05/2020 Edit 05/05/2020 Edit 05/05/2020 Edit 05/07/2020 Edit 05/11/2020 Edit 05/11/2020 Vendor 7808 - MURPHY TRACTOR & EQUIPMENT Totals Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit Edit Vendor 20110 - NORTHERN SAFETY TECHNOLOGY INC 04/30/2020 05/06/2020 05/06/2020 05/06/2020 05/07/2020 Vendor 961 - MUTUAL WHEEL COMPANY Totals 04/29/2020 05/07/2020 05/11/2020 05/14/2020 05/14/2020 Vendor 966 - NAPA AUTO PARTS Totals 05/26/2020 05/26/2020 Invoices 2 05/26/2020 05/26/2020 Invoices 1 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 Invoices 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 Invoices 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 Invoices 05/16/2020 05/26/2020 05/26/2020 Vendor 20466 - BENJAMIN NEIL Totals Invoices 10 5 5 1 Invoice Net Amount 98.24 (63.78) $34.46 31,369.00 $31,369.00 247.25 491.18 538.81 284.65 295.45 61.18 667.32 226.55 61.74 223.02 $3,097.15 709.95 131.36 109.56 545.70 134.84 $1,631.41 88.94 82.40 50.50 99.81 8.62 $330.27 150.00 $150.00 Run by Emily Graham on 05/22/2020 02:49:03 PM Page 43 of 129 Page 13 of 19 Invoice Number 50298 Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Summary Listing Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount LIGHTS Edit 04/27/2020 05/26/2020 05/26/2020 117.34 Vendor 20110 - NORTHERN SAFETY TECHNOLOGY INC Totals Invoices 1 $117.34 Vendor 1008 NORTHLAND PRODUCTS COMPANY INVNP0028676 TALAMAR Edit 04/30/2020 05/26/2020 05/26/2020 958.50 INVNP0030257 BOX PLASTIC HOLDERS Edit 05/08/2020 05/26/2020 05/26/2020 29.00 INVNP0029800 OIL Edit 05/06/2020 05/26/2020 05/26/2020 118.50 Vendor 1008 - NORTHLAND PRODUCTS COMPANY Totals Invoices 3 $1,106.00 Vendor 1012 - NUTRI JECT SYSTEMS, INC 7250 BIOSOLIDS TRANSPORTED 5/1- Edit 05/15/2020 05/26/2020 05/26/2020 11,587.77 5/15 Vendor 1012 - NUTRI JECT SYSTEMS, INC Totals Invoices 1 $11,587.77 Vendor 21266 - ONE SOURCE 4281-202000430 HR EMPLOYMENT BACKGROUND Edit 04/21/2020 05/26/2020 05/26/2020 05/12/2020 126.49 CHECKS Vendor 21266 - ONE SOURCE Totals Invoices 1 $126.49 Vendor 13314 - OVERDRIVE INC 02863DA20127508 E-BOOK Edit 05/02/2020 05/26/2020 05/26/2020 24.99 02863DA20129665 E-BOOKS Edit 05/04/2020 05/26/2020 05/26/2020 157.50 02863DA20132902 E-BOOKS Edit 05/05/2020 05/26/2020 05/26/2020 127.94 02863DA20140765 E-BOOK Edit 05/12/2020 05/26/2020 05/26/2020 76.00 02863DA20140894 E-BOOKS Edit 05/12/2020 05/26/2020 05/26/2020 103.93 Vendor 13314 - OVERDRIVE INC Totals Invoices 5 $490.36 Vendor 1028 - OVERHEAD DOOR CO. OF WATERLOO 23282 LABOR - EAST SIDE NORTH Edit 05/11/2020 05/26/2020 05/26/2020 140.50 DOOR - PW Vendor 1028 - OVERHEAD DOOR CO. OF WATERLOO Totals Invoices 1 $140.50 Vendor 20359 - P & K MIDWEST INC 3654443 0-RING Edit 04/30/2020 05/26/2020 05/26/2020 .84 3675180 PUSH PULL CABLE Edit 05/12/2020 05/26/2020 05/26/2020 34.60 Vendor 20359 - P & K MIDWEST INC Totals Invoices 2 $35.44 Vendor 7803 - PER MAR SECURITY SERVICES 499410 WK ENDING 5/9 Edit 05/09/2020 05/26/2020 05/26/2020 1,703.88 Vendor 7803 - PER MAR SECURITY SERVICES Totals Invoices 1 $1,703.88 Vendor 1132 - PETERSON CONTRACTORS, INC 934-22 CONT 934 RECON UNIVERSITY Edit AVE 05/17/2020 05/26/2020 05/26/2020 296,104.08 Vendor 1132 - PETERSON CONTRACTORS, INC Totals Invoices 1 $296,104.08 Run by Emily Graham on 05/22/2020 02:49:03 PM Page 44 of 129 Page 14 of 19 Invoice Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Summary Listing Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 12259 - PLATINUM PEST SERVICES 30721 BAIT STATIONS Edit 05/12/2020 05/26/2020 05/26/2020 50.00 Vendor 12259 - PLATINUM PEST SERVICES Totals Invoices 1 $50.00 Vendor 10726 - PRIMARY SYSTEMS 6-0473 RT - AFTER HOURS DIALER Edit 05/15/2020 05/26/2020 05/26/2020 195.00 Vendor 11144 - PRO LINE AUDIO INC. 3701 SPRAY ON BEDLINER Edit Vendor 10726 - PRIMARY SYSTEMS Totals Invoices 1 $195.00 05/07/2020 05/26/2020 05/26/2020 150.00 Vendor 11144 - PRO LINE AUDIO INC. Totals Invoices 1 $150.00 Vendor 6981 - QUILL CORPORATION 4956671 TONER INK, LABEL MAKER, MISC Edit 02/21/2020 05/26/2020 05/26/2020 470.96 OFFICE SUPPLIES 6720301 TONER INK Edit 05/06/2020 05/26/2020 05/26/2020 147.59 6739895 MISC OFFICE SUPPLIES Edit 05/06/2020 05/26/2020 05/26/2020 517.11 6741833 INK CARTRIDGES Edit 05/06/2020 05/26/2020 05/26/2020 146.65 6841694 COMPUTER CHAIR REPLACEMENT Edit 05/11/2020 05/26/2020 05/26/2020 326.99 - CAMERON Vendor 6981 - QUILL CORPORATION Totals Invoices 5 $1,609.30 Vendor 1178 - RACOM AB155235 REPLACEMENT BATTERY Edit 05/14/2020 05/26/2020 05/26/2020 85.00 Vendor 1178 - RACOM Totals Invoices 1 $85.00 Vendor 8210 - RC SYSTEMS 97143 T1803 LOGIC BOARD,M Edit 04/28/2020 05/26/2020 05/26/2020 1,189.13 CONTACTOR BOARD Vendor 8210 - RC SYSTEMS Totals Invoices 1 $1,189.13 Vendor 1060 - REGIONS BANK 05132020 April Analysis Fees Edit 05/25/2020 05/26/2020 05/26/2020 105.04 2020-00002356 April Credit Card Fees Edit 05/25/2020 05/26/2020 05/26/2020 171.75 Vendor 1060 - REGIONS BANK Totals Invoices 2 $276.79 Vendor 20938 - REPUBLIC PARKING SYSTEM INC 2020-00002374 APRIL PAYROLL EXPENSES Edit 04/30/2020 05/26/2020 05/26/2020 2020-00002375 APRIL OPERATING EXPENSES Edit 04/30/2020 05/26/2020 05/26/2020 20,933.17 7,976.58 Vendor 20938 - REPUBLIC PARKING SYSTEM INC Totals Invoices 2 $28,909.75 Vendor 21815 - REPUBLIC SERVICES INC 0897-000894625 CONTRACT #22588 Edit 04/30/2020 05/26/2020 05/26/2020 56,650.00 0897-000894625C CART DELIVERY/PICKUP Edit 04/30/2020 05/26/2020 05/26/2020 1,300.00 Run by Emily Graham on 05/22/2020 02:49:03 PM Page 45 of 129 Page 15 of 19 Invoice Number Invoice Description Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Summary Listing Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 21815 - REPUBLIC SERVICES INC Totals Invoices 2 $57,950.00 Vendor 3600 - RICOH USA INC 5059502156 PRINTER COPIER CONTRACT- Edit 05/01/2020 05/26/2020 05/26/2020 05/20/2020 55.55 4710451 5059502776 COPIER Edit 05/01/2020 05/26/2020 05/26/2020 131.05 Vendor 3600 - RICOH USA INC Totals Invoices 2 $186.60 Vendor 5970 - ROBBY'S SALES & SERVICE 00056453 TRIMMER STRING Edit 05/07/2020 05/26/2020 05/26/2020 63.73 00056463 TRIMMER LINE Edit 05/08/2020 05/26/2020 05/26/2020 67.48 Vendor 5970 - ROBBY'S SALES & SERVICE Totals Invoices 2 $131.21 Vendor 21976 - RUTABAGA RAGS INC 19995 FACE MASKS Edit 05/14/2020 05/26/2020 05/26/2020 540.00 Vendor 21976 - RUTABAGA RAGS INC Totals Invoices 1 $540.00 Vendor 1252 - SANDEE'S 161458 CIVILIAN COMMENDATION Edit 05/12/2020 05/26/2020 05/26/2020 90.40 Vendor 1252 - SANDEE'S Totals Invoices 1 $90.40 Vendor 6956 - SANDRY FIRE SUPPLY 010540 MSA CARRIER ASSY. ETC. Edit 05/07/2020 05/26/2020 05/26/2020 395.50 Vendor 6956 - SANDRY FIRE SUPPLY Totals Invoices 1 $395.50 Vendor 20127 - ARIC SCHROEDER 863046 PETTY CASH REPLENISHMENT Edit 05/18/2020 05/26/2020 05/26/2020 171.00 Vendor 20127 - ARIC SCHROEDER Totals Invoices 1 $171.00 Vendor 2865 - SCOT'S SUPPLY 013889 CARR BOL Edit 05/05/2020 05/26/2020 05/26/2020 10.50 014139 GEAR PULLER Edit 05/12/2020 05/26/2020 05/26/2020 26.05 Vendor 2865 - SCOT'S SUPPLY Totals Invoices 2 $36.55 Vendor 5105 - SERVICE SIGNING, L.C. 9486 SUPPLY, PLACE AND REMOVE Edit 05/11/2020 05/26/2020 05/26/2020 300.00 TRAFFIC CONTROL AT WAGNER ROAD Vendor 5105 - SERVICE SIGNING, L.C. Totals Invoices 1 $300.00 Vendor 1303 - SHERWIN-WILLIAMS CO. 0E0126725A3033 REPAIR KIT, AIRLESS HOSE, Edit 05/18/2020 05/26/2020 05/26/2020 343.70 FILTER Vendor 1303 - SHERWIN-WILLIAMS CO. Totals Invoices 1 $343.70 Vendor 21981 - SQUARE, INC. Run by Emily Graham on 05/22/2020 02:49:03 PM Page 46 of 129 Page 16 of 19 Invoice Number 101004425 Vendor 5290 - 1003-1b Vendor 1350 - 02500563B 03094692 Vendor 1360 - 13946009-00 13946195-00 Vendor 13063 PINV799496 PINV799343 PINV798723 PINV800983 PINV799497 PINV799358 PINV800963 CM 127943 Invoice Description CONV CTR POS SYSTEM STANLEY CONSULTANTS INC. CONT 1003 BRIDGE PRELIM DESIGN -ADJUSTMENT TO INVOICE STAR EQUIPMENT, LTD DURAPATCHER HYDRAULIC CURB ROLLER RENTAL STETSON BUILDING PRODUCTS INC EPDXY EXP JOINT/DECK 0 FOAM Status Edit Edit Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Summary Listing Held Reason Invoice Date Due Date 01/31/2020 05/26/2020 Vendor 21981 - SQUARE, INC. Totals G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 9,719.00 Invoices 1 $9,719.00 03/28/2020 05/26/2020 05/26/2020 3,000.00 Vendor 5290 - STANLEY CONSULTANTS INC. Totals Edit Edit Edit Edit Invoices 1 05/12/2020 05/26/2020 05/26/2020 05/12/2020 05/26/2020 05/26/2020 Vendor 1350 - STAR EQUIPMENT, LTD Totals Invoices 05/12/2020 05/26/2020 05/26/2020 05/12/2020 05/26/2020 05/26/2020 Vendor 1360 - STETSON BUILDING PRODUCTS INC Totals - STOREY KENWORTHY OFFICE SUPPLIES GLOVES KEYBOARD COVERS FACE MASKS CLASP ENVELOPES (2) PENS, POPUP POST -IT NOTES POST -IT NOTES, MARKER PENS POP-UP POST IT NOTES (RETURN) Edit Edit Edit Edit Edit Edit Edit Edit Vendor 1370 - SUPERIOR WELDING SUPPLY CO 249136 EXTINGUISHERS PUT ON OLD Edit 334 957997 OXYGEN THERAPY Edit 05/07/2020 05/07/2020 05/05/2020 05/14/2020 05/07/2020 05/07/2020 05/14/2020 05/15/2020 Vendor 13063 - STOREY KENWORTHY Totals Invoices 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 Invoices $3,000.00 201,369.00 279.00 2 $201,648.00 160.00 57.91 2 $217.91 119.07 11.97 87.15 181.78 23.98 35.19 30.82 (21.18) 8 $468.78 05/08/2020 05/26/2020 05/26/2020 43.00 05/12/2020 05/26/2020 05/26/2020 20.65 Vendor 1370 - SUPERIOR WELDING SUPPLY CO Totals Vendor 21446 - THOMPSON SHOES 050420 SAFETY SHOES - TODD HENRICH Edit 050420PW BOOTS - PW - CENTRAL GARAGE Edit - MIKE HEICHEL Vendor 20491 - THOMPSON TRUCK & TRAILER INC Invoices 2 $63.65 05/04/2020 05/26/2020 05/26/2020 05/12/2020 144.50 05/04/2020 05/26/2020 05/26/2020 150.00 Vendor 21446 - THOMPSON SHOES Totals Invoices 2 $294.50 Run by Emily Graham on 05/22/2020 02:49:03 PM Page 47 of 129 Page 17 of 19 Invoice Number X102053039:01 X102053072:01 X102053145:01 X102053179:01 X102053206:01 Invoice Description PARTS FOR 191002 FUEL FILTER PARTS FOR 191002 SLEEVE/DASH CONT VLV/REPAIRLINK BREATHER Status Edit Edit Edit Edit Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Summary Listing Held Reason Invoice Date 04/28/2020 04/30/2020 05/05/2020 05/06/2020 Edit 05/07/2020 Vendor 20491 - THOMPSON TRUCK & TRAILER INC Totals Vendor 12295 - TRICON GENERAL CONSTRUCTION 947-4 CONT 947 FY20 VIRDEN CREEK Edit LEVEE 05/14/2020 Vendor 12295 - TRICON GENERAL CONSTRUCTION Totals Vendor 21193 - TRUE NORTH LUBRICANTS & RESOURCES LLC 0060329-IN DEF Edit Vendor 05/12/2020 21193 - TRUE NORTH LUBRICANTS & RESOURCES LLC Totals Vendor 21911 - UNIFIRST CORPORATION 247 0171891 SERVICE - SOUTH HILLS MAINT 247 0172704 SERVICE - SHOP 247 0173520 SERVICE-SPORTSPLEX 247 0173521 SERVICE - SHOP Edit Edit Edit Edit 05/04/2020 05/11/2020 05/18/2020 05/18/2020 Vendor 21911 - UNIFIRST CORPORATION Totals Due Date 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 G/L Date 05/26/2020 05/26/2020 05/26/2020 05/26/2020 Received Date Payment Date Invoice Net Amount 204.86 515.47 97.52 206.50 05/26/2020 226.56 Invoices 5 $1,250.91 05/26/2020 05/26/2020 Invoices 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 05/26/2020 Invoices 05/26/2020 05/26/2020 05/26/2020 05/26/2020 Invoices 4 Vendor 21176 - UNIQUE MANAGEMENT SERVICES INC 580173 ADDRESS VERIFICATION Edit 05/01/2020 05/26/2020 05/26/2020 Vendor 21176 - UNIQUE MANAGEMENT SERVICES INC Totals Invoices Vendor 9960 - US BANK 2020-00002361 April Bank Fees Vendor 1487 - S011119699.001 S011136788.001 S01137204.001 Edit VAN METER INDUSTRIAL, INC. PROXIMITY SWITCH Edit TORK 3000 BUTTON PHOTOCELL, Edit SOCKET REDUCER FLUKE TRUE-RMS AC CLAMP Edit METER Vendor 1563 - WATERLOO WATER WORKS 2020-5 May 2020 Property Taxes Vendor 4282 - WEBER PAPER COMPANY 05/25/2020 05/26/2020 05/26/2020 Vendor 9960 - US BANK Totals Invoices 04/28/2020 05/13/2020 05/13/2020 Vendor 1487 - VAN METER INDUSTRIAL, INC. Totals 325,193.10 $325,193.10 270.30 $270.30 17.50 64.50 118.00 64.50 $264.50 51.78 1 $51.78 162.93 1 $162.93 05/26/2020 05/26/2020 126.95 05/26/2020 05/26/2020 369.71 05/26/2020 05/26/2020 236.99 Invoices Edit 05/25/2020 05/26/2020 05/26/2020 Vendor 1563 - WATERLOO WATER WORKS Totals Invoices 3 $733.65 1,148.00 1 $1,148.00 Run by Emily Graham on 05/22/2020 02:49:03 PM Page 48 of 129 Page 18 of 19 Invoice Number W042401 Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Summary Listing Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 4 TORSK185A Edit 05/08/2020 05/26/2020 05/26/2020 102.12 Vendor 4282 - WEBER PAPER COMPANY Totals Invoices 1 $102.12 Vendor 7048 - WELLS FARGO BANK, N.A. 2020-00002357 April Bank Fees Edit 05/25/2020 05/26/2020 05/26/2020 76.17 Vendor 7048 - WELLS FARGO BANK, N.A. Totals Invoices 1 $76.17 Vendor 1577 - WERTJES UNIFORMS 52603 WELIVER WORK CLOTHES Edit 03/05/2020 05/26/2020 05/26/2020 250.98 52625 BECK UNIFORMS Edit 03/18/2020 05/26/2020 05/26/2020 163.00 Vendor 1577 - WERTJES UNIFORMS Totals Invoices 2 $413.98 Vendor 4214 - ZARNOTH BRUSH WORKS 0180172-IN TRAIL BROOM Edit 04/29/2020 05/26/2020 05/26/2020 Vendor RICHARD KIRBY 2020-00002373 REIMB SUPPLIES Edit 516.00 Vendor 4214 - ZARNOTH BRUSH WORKS Totals Invoices 1 $516.00 05/03/2020 05/26/2020 05/26/2020 64.05 Vendor RICHARD KIRBY Totals Invoices 1 $64.05 Grand Totals Invoices 325 $2,600,413.58 Run by Emily Graham on 05/22/2020 02:49:03 PM Page 49 of 129 Page 19 of 19 Invoice Number Invoice Description Status Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 1095494 P.O. Number 2 - AABLE PEST CONTROL INC PEST CONTROL, MAY '20 Edit Item Description Quantity Conversion Item - PEST CONTROL, MAY '20 1.0000 G/L Account 010-29-7700 1371 (General Fund -Airport Commission -Airport Administration Building & Grounds Maintenance) Invoice Items U/M EA 05/15/2020 Amount/Unit 110.0000 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 110.00 Amount 110.00 1095829 P.O. Number QTRLY BIRD SERV - PARK & 218 Edit OVER PASS Item Description Quantity U/M Conversion Item QTRLY BIRD SERV - PARK & 1.0000 EA 218 OVER PASS G/L Account 010-22-8800 1371 (General Fund -Building Inspection -Facilities Maintenance Building & Grounds Maintenance) 05/16/2020 Amount/Unit 450.0000 Invoice Items Project 1 05/26/2020 05/26/2020 05/18/2020 Total Amount Vendor Catalog Part Number Contract Number 450.00 Amount 450.00 Vendor 4825 - ACCO 0202049-IN FLOW METER REPAIRS - GATES Edit POOL Vendor 2 - AABLE PEST CONTROL INC Totals 05/11/2020 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - FLOW METER REPAIRS - 1.0000 EA 619.6800 GATES POOL G/L Account 418-22-4200 2132 (June 2018 GO Bond Fund -Building Inspection -Sports & Youth Services Swimming Pool Equipment & Improvements) Invoice Items Project 1 Invoices 05/26/2020 05/26/2020 05/15/2020 Total Amount Vendor Catalog Part Number 619.68 110.00 450.00 2 $560.00 Contract Number Amount 619.68 0202050-IN P.O. Number FLOW METER REPAIRS - BYRNES Edit POOL Item Description Quantity U/M Amount/Unit Conversion Item - FLOW METER REPAIRS - 1.0000 EA 619.6800 BYRNES POOL G/L Account 418-22-4200 2132 (June 2018 GO Bond Fund -Building Inspection -Sports & Youth Services Swimming Pool Equipment & Improvements) Invoice Items 05/11/2020 Project 1 05/26/2020 05/26/2020 05/15/2020 Total Amount Vendor Catalog Part Number 619.68 Contract Number Amount 619.68 Vendor 4825 - ACCO Totals Vendor 8258 - ACES Invoices 619.68 619.68 2 $1,239.36 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 50 of 129 Page 1 of 80 Invoice Number 70126 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status SERVER SUPPORT W/ Edit MONITORING FOR (4) WITH EXCHANGE FOR 5/1/2020 Item Description Quantity Conversion Item - SERVER SUPPORT W/ 1.0000 MONITORING FOR (4) WITH EXCHANGE FOR 5/1/2020 Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/01/2020 05/26/2020 05/26/2020 852.56 U/M Amount/Unit EA 852.5600 G/L Account 010-11-1105 1321 (General Fund -Police Department -Police Computer Services Data Processing Services) Invoice Items Project 1 Total Amount Vendor Catalog Part Number Contract Number 852.56 Amount 852.56 70132 P.O. Number SAFETY NET EMAIL CONT. Edit 5/1/2020 05/01/2020 05/26/2020 05/26/2020 712.00 Item Description Quantity U/M Amount/Unit Conversion Item - SAFETY NET EMAIL CONT. 1.0000 EA 712.0000 5/1/2020 G/L Account 010-11-1105 1321 (General Fund -Police Department -Police Computer Services Data Processing Services) Invoice Items Project 1 Total Amount Vendor Catalog Part Number Contract Number 712.00 Amount 712.00 70136 P.O. Number SERVER SUPPORT Edit W/MONITORING (3) 5/1/2020 05/01/2020 Item Description Quantity U/M Amount/Unit Conversion Item - SERVER SUPPORT 1.0000 EA 639.4400 W/MONITORING (3) 5/1/2020 G/L Account 010-11-1105 1321 (General Fund -Police Department -Police Computer Services Data Processing Services) Invoice Items Project 1 05/26/2020 05/26/2020 639.44 Total Amount Vendor Catalog Part Number Contract Number 639.44 Amount 639.44 70146 P.O. Number RECON BASE PLATFORM FOR Edit WORKSTATIONS FOR 5/1/2020 Item Description Quantity U/M Amount/Unit Conversion Item - RECON BASE PLATFORM 1.0000 EA 490.4400 FOR WORKSTATIONS FOR 5/1/2020 G/L Account 010-11-1105 1321 (General Fund -Police Department -Police Computer Services Data Processing Services) Invoice Items 05/01/2020 Project 1 05/26/2020 05/26/2020 490.44 Total Amount Vendor Catalog Part Number Contract Number 490.44 Amount 490.44 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 51 of 129 Page 2 of 80 Invoice Number 70151 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason Invoice Date SECURITY INFORMATION & Edit 05/01/2020 EVENT MGMT 5/1/2020 Item Description Quantity U/M Amount/Unit Conversion Item - SECURITY INFORMATION & 1.0000 EA 460.0000 EVENT MGMT 5/1/2020 G/L Account 010-11-1105 1321 (General Fund -Police Department -Police Computer Services Data Processing Services) Invoice Items Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 460.00 Total Amount Vendor Catalog Part Number Contract Number 460.00 Amount 460.00 70152 P.O. Number BORDER PATROL MGMT ON Edit HARDWARE 5/1/2020 05/01/2020 Item Description Quantity U/M Amount/Unit Conversion Item - BORDER PATROL MGMT ON 1.0000 EA 459.0000 HARDWARE 5/1/2020 G/L Account 010-11-1105 1321 (General Fund -Police Department -Police Computer Services Data Processing Services) Invoice Items Project 1 05/26/2020 05/26/2020 459.00 Total Amount Vendor Catalog Part Number Contract Number 459.00 Amount 459.00 70204 P.O. Number EMAIL ENCRYPTION SERVICES Edit 5/1/2020 Item Description Quantity U/M Amount/Unit Conversion Item - EMAIL ENCRYPTION 1.0000 EA 48.0000 SERVICES 5/1/2020 G/L Account 010-11-1105 1321 (General Fund -Police Department -Police Computer Services Data Processing Services) Invoice Items 05/01/2020 Project 1 05/26/2020 05/26/2020 48.00 Total Amount Vendor Catalog Part Number Contract Number 48.00 Amount 48.00 70218 P.O. Number SCREEN CONNECT AGREEMENT Edit FOR MAY (2) Item Description Quantity U/M Amount/Unit Conversion Item - SCREEN CONNECT 1.0000 EA 14.0000 AGREEMENT FOR MAY (2) G/L Account 010-11-1105 1321 (General Fund -Police Department -Police Computer Services Data Processing Services) Invoice Items 05/01/2020 Project 1 05/26/2020 05/26/2020 14.00 Total Amount Vendor Catalog Part Number Contract Number 14.00 Amount 14.00 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 52 of 129 Page 3 of 80 Invoice Number 70219 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason ANTIVIRUS BUNDLE LICENSE Edit FOR 5/1/2020 Item Description Quantity U/M Amount/Unit Conversion Item - ANTIVIRUS BUNDLE 1.0000 EA 8.7500 LICENSE FOR 5/1/2020 G/L Account 010-11-1105 1321 (General Fund -Police Department -Police Computer Services Data Processing Services) Invoice Items Invoice Date 05/01/2020 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 8.75 Total Amount Vendor Catalog Part Number Contract Number 8.75 Amount 8.75 Vendor 10373 - ADVANTAGE SCREENPRINT 28756 STAFF SHIRTS P.O. Number Item Description Conversion Item - STAFF SHIRTS G/L Account 010-37-4200 1567 (General Fund -Leisure Services -Sports & Youth Services Recreational Equipment & Supplies) Invoice Items Edit Vendor 8258 - ACES Totals Quantity U/M 1.0000 EA 05/14/2020 Amount/Unit 990.0000 Project 1 Invoices 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number 990.00 9 $3,684.19 Contract Number Amount 990.00 Vendor 10373 - ADVANTAGE SCREENPRINT Totals Vendor 5419 - AECOM TECHNICAL SERVICES, INC 2000356429 CONSULTANT SVCS, FY-20 IDOT Edit CSVI, 4/4/20-5/1/20 Invoices 05/08/2020 05/26/2020 05/26/2020 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - CONSULTANT SVCS, FY-20 1.0000 EA 10,819.7500 IDOT CSVI, 4/4/20-5/1/20 G/L Account 291-29-7760 2103 (Airport FM Projects -Airport Commission -Airport State Projects Engineering & Consulting) Invoice Items Total Amount Vendor Catalog Part Number 10,819.75 Project 29PRO.VI20 (AIRPORT PROJECTS, CONTRACT 21613 VERTICAL INFRASTRUCTURE FY2020) 1 990.00 1 $990.00 Contract Number Amount 10,819.75 2000356442 P.O. Number CONSULTANT SVCS, Edit RECONSTRUCT T/W B; REMOVE TREES, 4/4/20-5/1/20 05/08/2020 05/26/2020 05/26/2020 Item Description Quantity U/M Amount/Unit Conversion Item - CONSULTANT SVCS, 1.0000 EA 76,545.4100 RECONSTRUCT T/W B; REMOVE TREES, 4/4/20-5/1/20 G/L Account 291-29-7750 2103 (Airport FAA Projects -Airport Commission -Airport Federal Projects Engineering & Consulting) Invoice Items Total Amount Vendor Catalog Part Number Contract Number 76, 545.41 Project 29AIP.0047 (FEDERAL AIRPORT PROJECTS, RECONSTRUCT TAXIWAY B & TREE REMOVAL) 1 Amount 76,545.41 10,819.75 76,545.41 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 53 of 129 Page 4 of 80 Invoice Number 2000357701 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason Invo CONT 1014 PHASE IVA CIP Edit 05/1 PIPELINING APR 11-MAY 8 Item Description Quantity U/M Amount/Un Item - CONT 1014 PHASE IVA CIP 1.0000 EA 8,303.15 PIPELINING APR 11-MAY 8 G/L Account 520-14-5320 2103 (Sanitary Sewer Fund -Waste Management -Water Pollution -Sewer Coll Sytem Improvements Engineering & Consulting) Invoice Items ice Date Due Date G/L Date Received Date Payment Date 2/2020 05/26/2020 05/26/2020 nit Total Amount Vendor Catalog Part Number Contract Number 00 8,303.15 Project 14SRF.CIPP4A (STATE REVOLVING LOAN FUND, FY2020 CIP PIPELINING PHASE IVA) 1 Amount 8,303.15 Invoice Net Amount 8,303.15 200357692 P.O. Number CONT 919 2018 PHASE IIIB, Edit 05/1 PHASE IIIC Item Description Quantity U/M Amount/Un Item - CONT 919 2018 PHASE 1.0000 EA 13,044.63 IIIB, PHASE IIIC G/L Account 520-14-5320 2103 (Sanitary Sewer Fund -Waste Management -Water Pollution -Sewer Coll Sytem Improvements Engineering & Consulting) Invoice Items 2/2020 05/26/2020 05/26/2020 nit Total Amount Vendor Catalog Part Number Contract Number 00 13,044.63 Project 14SRF.CIPP3B (STATE REVOLVING LOAN FUND, CIPP3B) 1 Amount 13,044.63 Vendor 11320 - AGVANTAGE FS, INC. 53007318 #2 ULTRA LS DYED P.O. Number Vendor 5419 - AECOM TECHNICAL SERVICES, INC Totals Edit Item Description Quantity U/M Conversion Item - #2 ULTRA LS DYED 1.0000 EA G/L Account 010-18-7955 1533 (General Fund -Central Garage -Garage -Motor Pool Service Fuel Expense) Invoice Items Invoices 4 13,044.63 05/01/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 6,614.3500 6,614.35 Project Amount 1 6,614.35 $108,712.94 53007355 P.O. Number GASOHOL Edit Item Description Quantity U/M Conversion Item - GASOHOL 1.0000 EA G/L Account 010-18-7955 1533 (General Fund -Central Garage -Garage -Motor Pool Service Fuel Expense) Invoice Items 05/04/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 8,401.0500 8,401.05 Project Amount 1 8,401.05 Vendor 11320 - AGVANTAGE FS, INC. Totals Vendor 72 - ARAMARK UNIFORM SERVICES, INC. Invoices 2 6,614.35 8,401.05 $15,015.40 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 54 of 129 Page 5 of 80 Invoice Number 1877329670 P.O. Number Invoice Description Status MATS, TOWELS - CARNEGIE Edit Item Description Conversion Item - MATS, TOWELS - CARNEGIE Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Held Reason Invoice Date 05/12/2020 Quantity U/M Amount/Unit 1.0000 EA 62.2100 G/L Account 010-22-8800 1356 (General Fund -Building Inspection -Facilities Maintenance Uniforms & Mats - Cleaning & Rental) Invoice Items Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 05/14/2020 Total Amount Vendor Catalog Part Number Contract Number 62.21 Amount 62.21 1877328937 P.O. Number JANITORIAL Edit SERVICES/UNIFORMS 05/11/2020 Item Description Quantity U/M Amount/Unit Conversion Item - JANITORIAL 1.0000 EA 136.5100 SERVICES/UNIFORMS G/L Account 010-18-7950 1541 (General Fund -Central Garage -Central Garage Janitorial Supplies) 010-18-1405 1579 (General Fund -Central Garage -Fire -Garage Parts & Service Uniforms) 010-18-7950 1579 (General Fund -Central Garage -Central Garage Uniforms) Project Invoice Items 1 62.21 05/26/2020 05/26/2020 136.51 Total Amount Vendor Catalog Part Number Contract Number 136.51 Amount 85.49 5.32 45.70 1877330319 P.O. Number MOPS, TOWEL SERVICE Edit Item Description Conversion Item - MOPS, TOWEL SERVICE G/L Account Quantity 1.0000 U/M EA 05/13/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 122.4400 122.44 Project 010-33-3100 1371 (General Fund -Library -Library Services Building & Grounds Maintenance) Invoice Items 1 Contract Number Amount 122.44 1877327705 P.O. Number AIRFRESHNER & MAT CLEANING Edit AT THE WPD TRAINING CENTER Item Description Quantity U/M Amount/Unit Conversion Item - AIRFRESHNER & MAT 1.0000 EA 41.1700 CLEANING AT THE WPD TRAINING CENTER G/L Account 010-11-1100 1356 (General Fund -Police Department -Police Operations Uniforms & Mats - Cleaning & Rental) 05/07/2020 05/26/2020 05/26/2020 Project Invoice Items 1 Total Amount Vendor Catalog Part Number 41.17 Contract Number Amount 41.17 122.44 41.17 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 55 of 129 Page 6 of 80 Invoice Number 1877328935 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason Invoice Date JANITORIAL Edit 05/11/2020 SERVICES/UNIFORMS Item Description Quantity U/M Amount/Unit Conversion Item - JANITORIAL 1.0000 EA 95.3100 SERVICES/UNIFORMS G/L Account 266-19-7100 1579 (Road Use Tax -Street Department -Street Maintenance Uniforms) 266-19-7100 1541 (Road Use Tax -Street Department -Street Maintenance Janitorial Supplies) Invoice Items Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 95.31 Total Amount Vendor Catalog Part Number Contract Number 95.31 Amount 9.14 86.17 1877332322 P.O. Number WKLY SERVICES Edit Item Description Quantity U/M Conversion Item - WKLY SERVICES 1.0000 EA G/L Account 520-14-5200 1356 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Uniforms & Mats - Cleaning & Rental) Invoice Items 05/18/2020 Amount/Unit 416.2800 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 416.28 Amount 416.28 1877332319 P.O. Number UNIFORMS/RUGS CLEANING & Edit RENTAL Item Description Quantity U/M Amount/Unit Conversion Item - UNIFORMS/RUGS 1.0000 EA 18.8900 CLEANING & RENTAL G/L Account 525-15-5400 1356 (Sanitation Fund -Waste Management -Sanitation -Solid Waste Disposal Uniforms & Mats - Cleaning & Rental) Invoice Items 05/18/2020 05/26/2020 05/26/2020 Project 1 Total Amount Vendor Catalog Part Number 18.89 Contract Number Amount 18.89 Vendor 3222 - ARNOLD MOTOR SUPPLY 46CR003212 CREDIT P.O. Number Vendor 72 - ARAMARK UNIFORM SERVICES, INC. Totals Edit Item Description Quantity U/M Conversion Item - CREDIT 1.0000 EA G/L Account 010-18-7950 1571 (General Fund -Central Garage -Central Garage Machinery & Equipment Replacement Parts) Invoice Items Invoices 04/28/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number (166.9900) (166.99) Project 1 416.28 18.89 7 $892.81 Contract Number Amount (166.99) (166.99) Run by Emily Graham on 05/22/2020 02:50:29 PM Page 56 of 129 Page 7 of 80 Invoice Number 46NV027598 P.O. Number Invoice Description Status MARINE DEEP CYCLE SERVICE Edit Item Description Conversion Item - MARINE DEEP CYCLE SERVICE Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Quantity 1.0000 Held Reason U/M EA Invoice Date 04/28/2020 Amount/Unit 166.9900 G/L Account 010-18-7950 1571 (General Fund -Central Garage -Central Garage Machinery & Equipment Replacement Parts) Invoice Items Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 166.99 Amount 166.99 46NV027599 P.O. Number MARINE/RV DEEP CYCLE Edit 04/28/2020 SERVICE Item Description Quantity U/M Amount/Unit Conversion Item - MARINE/RV DEEP CYCLE 1.0000 EA 166.9900 SERVICE G/L Account 010-18-7950 1571 (General Fund -Central Garage -Central Garage Machinery & Equipment Replacement Parts) Invoice Items Project 1 166.99 05/26/2020 05/26/2020 166.99 Total Amount Vendor Catalog Part Number Contract Number 166.99 Amount 166.99 46CR003216 P.O. Number CORE CREDIT Edit 04/29/2020 05/26/2020 05/26/2020 Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Conversion Item - CORE CREDIT 1.0000 EA (72.0000) (72.00) G/L Account Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 Contract Number Amount (72.00) 46NV027619 P.O. Number MARINE/RV DEEP CYCLE Edit 04/29/2020 SERVICE Item Description Quantity U/M Amount/Unit Conversion Item - MARINE/RV DEEP CYCLE 1.0000 EA 166.9900 SERVICE G/L Account 010-18-7950 1571 (General Fund -Central Garage -Central Garage Machinery & Equipment Replacement Parts) Invoice Items Project 1 (72.00) 05/26/2020 05/26/2020 166.99 Total Amount Vendor Catalog Part Number Contract Number 166.99 Amount 166.99 46NV027736 P.O. Number OIL FILTERS Edit Item Description Quantity U/M Conversion Item - OIL FILTERS 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 05/01/2020 Amount/Unit 20.1600 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 20.16 Amount 20.16 20.16 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 57 of 129 Page 8 of 80 Invoice Number 46NV027740 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason SCREWDDRIVER Edit Item Description Quantity U/M Conversion Item - SCREWDDRIVER 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items Invoice Date 05/01/2020 Amount/Unit 3.9900 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 3.99 Amount 3.99 46NV027770 P.O. Number LED ACCESSORY LIGHT Edit Item Description Quantity U/M Conversion Item - LED ACCESSORY LIGHT 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 05/02/2020 Amount/Unit 70.6900 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 70.69 Amount 70.69 46CR003233 P.O. Number CORE CREDIT Edit Item Description Quantity U/M Conversion Item - CORE CREDIT 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 05/04/2020 Amount/Unit (45.0000) Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number (45.00) Amount (45.00) 46NV027795 P.O. Number RAVEN GLV XL Item Description Conversion Item - RAVEN GLV XL G/L Account Edit Quantity U/M 1.0000 EA 05/04/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 129.9000 129.90 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 Contract Number Amount 129.90 46NV027797 P.O. Number HYDRAULIC PARTS Item Description Conversion Item - HYDRAULIC PARTS G/L Account Edit Quantity U/M 1.0000 EA 05/04/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 97.8300 97.83 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 Contract Number Amount 97.83 3.99 70.69 (45.00) 129.90 97.83 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 58 of 129 Page 9 of 80 Invoice Number 46NV027865 P.O. Number Invoice Description WHEEL BEARINGS & HYB ASSEMBLY Item Description Conversion Item - WHEEL BEARINGS & HYB ASSEMBLY Status Edit Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Held Reason Invoice Date 05/05/2020 Quantity U/M Amount/Unit 1.0000 EA 244.8900 G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 244.89 Total Amount Vendor Catalog Part Number Contract Number 244.89 Amount 244.89 46CR003262 CORE CREDIT Edit P.O. Number Item Description Quantity U/M Conversion Item - CORE CREDIT 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 05/07/2020 Amount/Unit (36.0000) Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number (36.00) Amount (36.00) 46NV027956 02 SENSOR Edit P.O. Number Item Description Quantity U/M Conversion Item - 02 SENSOR 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 05/07/2020 Amount/Unit 66.8600 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 66.86 Amount 66.86 46NV027970 ALTERNATOR Edit P.O. Number Item Description Quantity U/M Conversion Item - ALTERNATOR 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 05/07/2020 Amount/Unit 190.2000 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 190.20 Amount 190.20 46NV027981 COUPLERS Edit P.O. Number Item Description Quantity U/M Conversion Item - COUPLERS 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 05/07/2020 Amount/Unit 12.7800 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 12.78 Amount 12.78 (36.00) 66.86 190.20 12.78 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 59 of 129 Page 10 of 80 Invoice Number 46NV027985 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status PRESSURE SWITCH Edit Item Description Quantity U/M Conversion Item - PRESSURE SWITCH 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items Held Reason Invoice Date 05/07/2020 Amount/Unit 32.8700 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 32.87 Amount 32.87 46NV028008 P.O. Number WATERPROOF ON/OFF SWITCH Edit Item Description Quantity U/M Conversion Item - WATERPROOF ON/OFF 1.0000 EA SWITCH G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 05/08/2020 Amount/Unit 13.6900 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 13.69 Amount 13.69 46NV028054 P.O. Number HYDRAULIC COUPLER Edit Item Description Quantity U/M Conversion Item - HYDRAULIC COUPLER 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 05/09/2020 Amount/Unit 19.9600 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 19.96 Amount 19.96 46NV028095 P.O. Number STOCK PARTS Edit Item Description Quantity U/M Conversion Item - STOCK PARTS 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 05/11/2020 Amount/Unit 336.5100 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 336.51 Amount 336.51 Vendor 82 - ASPRO INC., & SUBSIDIARIES 965-17 CONT 965 FY2019 STREET Edit RECON PROGRAM Vendor 3222 - ARNOLD MOTOR SUPPLY Totals 05/15/2020 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - CONT 965 FY2019 STREET 1.0000 EA 585.7000 RECON PROGRAM G/L Account 205-07-7500 2165 (Local Option Sales Tax -City Engineer -Street Construction Streets & Roadways) Invoice Items Project 1 Invoices 32.87 13.69 19.96 336.51 20 $1,421.31 05/26/2020 05/26/2020 585.70 Total Amount Vendor Catalog Part Number Contract Number 585.70 Amount 585.70 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 60 of 129 Page 11 of 80 Invoice Number 993-3 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason Invoice Date CONT 993 FY20 STREET RECON Edit 05/15/2020 PROGRAM Item Description Quantity U/M Amount/Unit Conversion Item - CONT 993 FY20 STREET 1.0000 EA 344,687.7200 RECON PROGRAM G/L Account 520-14-5200 2163 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Sanitary Sewers) 205-07-7500 2165 (Local Option Sales Tax -City Engineer -Street Construction Streets & Roadways) Invoice Items Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 344,687.72 Total Amount Vendor Catalog Part Number Contract Number 344,687.72 Amount 53,798.79 290,888.93 888002-10839 P.O. Number SURFACE MIX Edit Item Description Quantity U/M Conversion Item - SURFACE MIX 1.0000 EA G/L Account 266-19-7100 1511 (Road Use Tax -Street Department -Street Maintenance Concrete & Aggregates) Invoice Items 05/09/2020 Amount/Unit 359.0400 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 359.04 Amount 359.04 888001-34654 P.O. Number UPM COLD MIX Edit Item Description Quantity U/M Conversion Item - UPM COLD MIX 1.0000 EA G/L Account 266-19-7100 1511 (Road Use Tax -Street Department -Street Maintenance Concrete & Aggregates) 05/16/2020 Amount/Unit 1,241.7200 Project Invoice Items 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number 1,241.72 Contract Number Amount 1,241.72 Vendor 95 - AUTOMOTIVE SERVICE SOLUTIONS 55707 ALTERNATOR #217 P.O. Number Edit Item Description Conversion Item - ALTERNATOR #217 G/L Account Vendor 82 - ASPRO INC., & SUBSIDIARIES Totals Quantity U/M 1.0000 EA Invoices 05/06/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 613.1300 613.13 Project 010-37-4100 1569 (General Fund -Leisure Services -Leisure Services -Parks Vehicle Replacement Parts) Invoice Items 1 359.04 1,241.72 4 $346,874.18 Contract Number Amount 613.13 Vendor 95 - AUTOMOTIVE SERVICE SOLUTIONS Totals Vendor 117 - B & B BUILDERS & SUPPLY Invoices 613.13 1 $613.13 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 61 of 129 Page 12 of 80 Invoice Number 981-7 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status CONT 981 2019 SIDEWALK Edit ASSESSMENT Item Description Quantity U/M Conversion Item - CONT 981 2019 SIDEWALK 1.0000 EA ASSESSMENT G/L Account 010-07-7650 2164 (General Fund -City Engineer -Sidewalk Repair/Construction Sidewalks) Held Reason Invoice Date 05/14/2020 Amount/Unit 101,352.1200 Invoice Items Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 101,352.12 Total Amount Vendor Catalog Part Number Contract Number 101,352.12 Amount 101,352.12 Vendor 107 - BAKER & TAYLOR 2035193604 YOUTH PRINT P.O. Number Item Description Conversion Item - YOUTH PRINT G/L Account 010-33-3100 1590 (General Fund -Library -Library Services Youth Print Materials) Edit Vendor 117 - B & B BUILDERS & SUPPLY Totals Quantity U/M 1.0000 EA Invoices 04/29/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 14.1200 14.12 Project Invoice Items 1 1 $101,352.12 Contract Number Amount 14.12 Vendor 20722 - BBE PRO TOOLS LLC 58870 SCAN TOOL P.O. Number Item Description Conversion Item - SCAN TOOL G/L Account Edit Vendor 107 - BAKER & TAYLOR Totals Quantity U/M 1.0000 EA Invoices 03/19/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 11,359.9800 11,359.98 Project 416-18-7950 2152 (June 2016 GO Bond Fund -Central Garage -Central Garage Building Improvements) Invoice Items 1 14.12 Contract Number Amount 11,359.98 Vendor 8069 - BDI 9501251298 P.O. Number Vendor 20722 - BBE PRO TOOLS LLC Totals Invoices DICHTO 25#BAG X2 Edit 05/14/2020 05/26/2020 05/26/2020 Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Conversion Item - DICHTO 25#BAG X2 1.0000 EA 5.6600 5.66 G/L Account Project 520-14-5200 1511 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Concrete & Aggregates) Invoice Items 1 11,359.98 1 $11,359.98 Contract Number Amount 5.66 Vendor 8069 - BDI Totals Vendor 2262 - BENTON'S READY MIX CONCRETE Invoices 5.66 1 $5.66 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 62 of 129 Page 13 of 80 Invoice Number 176826 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason C-4 Edit Item Description Quantity U/M Conversion Item - C-4 1.0000 EA G/L Account 266-19-7100 1511 (Road Use Tax -Street Department -Street Maintenance Concrete & Aggregates) Invoice Date 05/06/2020 Amount/Unit 605.0000 Project Invoice Items 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 605.00 Amount 605.00 176873 P.O. Number C-4 Edit Item Description Quantity U/M Conversion Item - C-4 1.0000 EA G/L Account 266-19-7100 1511 (Road Use Tax -Street Department -Street Maintenance Concrete & Aggregates) 05/07/2020 Amount/Unit 484.0000 Project Invoice Items 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 484.00 Amount 484.00 Vendor 144 - BITUMINOUS MATERIAL & SUPPLY, 2213222552 CRS-2 P.O. Number Item Description Conversion Item - CRS-2 G/L Account Vendor 2262 - BENTON'S READY MIX CONCRETE Totals Edit Quantity U/M 1.0000 EA 05/11/2020 Amount/Unit 942.8600 Project 205-19-7110 1513 (Local Option Sales Tax -Street Department -Seal Coating Program Chemicals & Gases) Invoice Items 1 Invoices 605.00 484.00 2 $1,089.00 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 942.86 Amount 942.86 Vendor 112 - BMC AGGREGATES LC 81016 WASHED CHIPS P.O. Number Vendor 144 - BITUMINOUS MATERIAL & SUPPLY, Totals Edit Item Description Quantity U/M Conversion Item - WASHED CHIPS 1.0000 EA G/L Account 205-19-7110 1511 (Local Option Sales Tax -Street Department -Seal Coating Program Concrete & Aggregates) Invoices 942.86 1 $942.86 04/30/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 734.4300 734.43 Project Amount 734.43 Invoice Items 1 Vendor 112 - BMC AGGREGATES LC Totals Vendor 21979 - BROCK EVEN CONSTRUCTION LLC Invoices 734.43 1 $734.43 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 63 of 129 Page 14 of 80 Invoice Number 1009-1 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason CONT 1009 SIDEWALK AND Edit TRAIL REPAIR PROGRAM Item Description Quantity U/M Conversion Item - CONT 1009 SIDEWALK AND 1.0000 EA TRAIL REPAIR PROGRAM G/L Account 418-07-7650 2164 (June 2018 GO Bond Fund -City Engineer -Sidewalk Repair/Construction Sidewalks) Invoice Items Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/15/2020 05/26/2020 05/26/2020 35,991.18 Amount/Unit 35,991.1800 Project 1 Total Amount Vendor Catalog Part Number Contract Number 35,991.18 Amount 35,991.18 Vendor 21977 - SCOTT BRUNSON 1217287 BOUNCE FS SHEETS P.O. Number Vendor 21979 - BROCK EVEN CONSTRUCTION LLC Totals Edit Item Description Conversion Item - BOUNCE FS SHEETS G/L Account 525-15-5400 1535 (Sanitation Invoices 1 $35,991.18 05/11/2020 05/26/2020 05/26/2020 21.40 Quantity U/M Amount/Unit 1.0000 EA 21.4000 Project Fund -Waste Management -Sanitation -Solid Waste Disposal Hardware Items) Invoice Items 1 Total Amount Vendor Catalog Part Number Contract Number 21.40 Amount 21.40 Vendor 240 - C & C WELDING & SAND BLASTING 74100 CYLINDER JD 7330 LEVY Edit TRACTOR Vendor 21977 - SCOTT BRUNSON Totals Invoices 1 $21.40 05/07/2020 05/26/2020 05/26/2020 260.75 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - CYLINDER JD 7330 LEVY 1.0000 EA 260.7500 TRACTOR G/L Account 010-37-4100 1569 (General Fund -Leisure Services -Leisure Services -Parks Vehicle Replacement Parts) Invoice Items Project 1 Total Amount Vendor Catalog Part Number Contract Number 260.75 Amount 260.75 Vendor 240 - C & C WELDING & SAND BLASTING Totals Vendor 7986 - C.J. COOPER & ASSOC. INC 151920 HR RANDOM DRUG SCREENINGS Edit P.O. Number Item Description Conversion Item - BUILDING INSP DRUG SCREEN Quantity U/M 1.0000 EA 05/11/2020 Amount/Unit 35.0000 G/L Account 010-22-8800 1314 (General Fund -Building Inspection -Facilities Maintenance Health Services) Project Invoices 1 $260.75 05/26/2020 05/26/2020 05/12/2020 Total Amount Vendor Catalog Part Number Contract Number 35.00 Amount 35.00 630.00 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 64 of 129 Page 15 of 80 Invoice Number 151920 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status HR RANDOM DRUG SCREENINGS Edit Item Description Conversion Item - GARAGE RANDOM DRUG SCREENS (STREET) G/L Account 266-19-7100 1314 (Road Use Tax -Street Department -Street Maintenance Health Services) Conversion Item - GOLF DRUG SCREENS 2.0000 G/L Account 010-37-4120 1314 (General Fund -Leisure Services -Golf Courses Health Services) Conversion Item - PARKS DRUG SCREEN G/L Account 010-37-4100 1314 (General Fund -Leisure Services -Leisure Services -Parks Health Services) Conversion Item - SANITATION RANDOM DRUG SCREENS G/L Account 525-15-5400 1314 (Sanitation Fund -Waste Management -Sanitation -Solid Waste Disposal Health Services) Conversion Item - SEWER/WATER POLLUTION TESTS Quantity 2.0000 2.0000 1.0000 Held Reason U/M EA EA 35.0000 EA EA 35.0000 35.0000 4.0000 EA 35.0000 G/L Account 520-14-5200 1314 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Health Services) Conversion Item - STORM WATER DRUG 0.5000 EA 35.0000 SCREEN G/L Account 521-19-5500 1314 (Storm Water Fund -Street Department -Street Cleaning Health Services) Conversion Item - STREET RANDOM DRUG 5.5000 EA 35.0000 SCREEN G/L Account 266-19-7100 1314 (Road Use Tax -Street Department -Street Maintenance Health Services) Invoice Items Invoice Date 05/11/2020 Amount/Unit 35.0000 Project Project Project Project Project Project Project 8 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 05/12/2020 Total Amount Vendor Catalog Part Number Contract Number 70.00 70.00 70.00 35.00 140.00 17.50 192.50 Amount 70.00 Amount 70.00 Amount 70.00 Amount 35.00 Amount 140.00 Amount 17.50 Amount 192.50 Vendor 7986 - C.J. COOPER & ASSOC. INC Totals Vendor 221 - CAMPBELL SUPPLY CO Invoices 630.00 1 $630.00 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 65 of 129 Page 16 of 80 Invoice Number INV-00143536 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status TOOLS Edit Item Description Quantity U/M Conversion Item - TOOLS 1.0000 EA G/L Account 010-29-7700 1371 (General Fund -Airport Commission -Airport Administration Building & Grounds Maintenance) Invoice Items Held Reason Invoice Date 05/14/2020 Amount/Unit 619.1100 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 619.11 Amount 619.11 INV-00142905 P.O. Number PLUMBING WH - FIRE STAT #1 Edit Item Description Conversion Item - PLUMBING WH - FIRE STAT #1 Quantity U/M 1.0000 EA 05/12/2020 Amount/Unit 115.1800 G/L Account 418-22-1400 2152 (June 2018 GO Bond Fund -Building Inspection -Fire Protection Service Building Improvements) Project Invoice Items 1 05/26/2020 05/26/2020 05/18/2020 Total Amount Vendor Catalog Part Number Contract Number 115.18 Amount 115.18 INV-00143563 P.O. Number SAFETY GLOVES - BLDG MAINT Edit Item Description Conversion Item - SAFETY GLOVES - BLDG MAINT Quantity U/M 1.0000 EA 05/14/2020 05/26/2020 05/26/2020 05/18/2020 Amount/Unit Total Amount Vendor Catalog Part Number 25.9800 25.98 G/L Account 010-22-8800 1573 (General Fund -Building Inspection -Facilities Maintenance Safety & Protective Equipment) Project Invoice Items 1 Contract Number Amount 25.98 INV-00142896 P.O. Number SPRAYER Edit 05/12/2020 05/26/2020 05/26/2020 Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Conversion Item - SPRAYER 1.0000 EA 119.9900 119.99 G/L Account Project 205-19-7110 1555 (Local Option Sales Tax -Street Department -Seal Coating Program Minor Equipment & Supplies) Invoice Items 1 Contract Number Amount 119.99 INV-001423588 P.O. Number SHACKLE SCREW PINS Edit Item Description Conversion Item - SHACKLE SCREW PINS G/L Account Quantity 1.0000 U/M EA 05/11/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 113.7200 113.72 Project 520-14-5200 1535 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Hardware Items) Invoice Items 1 Contract Number Amount 113.72 619.11 115.18 25.98 119.99 113.72 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 66 of 129 Page 17 of 80 Invoice Number INV-00142678 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason SDS AND BLADE FRAMING Edit Item Description Quantity U/M Conversion Item - SDS AND BLADE FRAMING 1.0000 EA G/L Account 520-14-5200 1535 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Hardware Items) Invoice Items Invoice Date 05/11/2020 Amount/Unit 19.5300 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 19.53 Amount 19.53 INV-00143066 P.O. Number JIGSAW BLADES Edit Item Description Quantity U/M Conversion Item - JIGSAW BLADES 1.0000 EA G/L Account 520-14-5200 1535 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Hardware Items) Invoice Items 05/12/2020 Amount/Unit 21.6300 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 21.63 Amount 21.63 INV-00143240 P.O. Number ELASTIC UNA, GRIND WHL, ROW Edit STEEL Item Description Quantity U/M Amount/Unit Conversion Item - ELASTIC UNA, GRIND WHL, 1.0000 EA 128.5200 ROW STEEL G/L Account 520-14-5200 1571 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Machinery & Equipment Replacement Parts) Invoice Items 05/13/2020 Project 1 19.53 21.63 05/26/2020 05/26/2020 128.52 Total Amount Vendor Catalog Part Number Contract Number 128.52 Amount 128.52 Vendor 20056 - W20-33788 P.O. Number Vendor 221 - CAMPBELL SUPPLY CO Totals CAN -AM AUTOMOTIVE & TOWING TOW FROM BEECH/ONEIDA TO Edit WPD IMPOUND W20-33788 Item Description Quantity Conversion Item - TOW FROM BEECH/ONEIDA 1.0000 TO WPD IMPOUND W20-33788 G/L Account 010-11-1100 1397 (General Fund -Police Department -Police Operations Vehicle Towing & Storage) 05/14/2020 U/M Amount/Unit EA 110.0000 Invoice Items Project 1 Invoices 8 $1,163.66 05/26/2020 05/26/2020 110.00 Total Amount Vendor Catalog Part Number Contract Number 110.00 Amount 110.00 Vendor 20056 - CAN -AM AUTOMOTIVE & TOWING Totals Vendor 21974 - CARBON6 INC Invoices 1 $110.00 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 67 of 129 Page 18 of 80 Invoice Number 1043 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Held Reason 25 TON TILT Item Description Quantity U/M Conversion Item - 25 TON TILT 1.0000 EA G/L Account 419-19-7100 2117 (June 2019 GO Bond Fund -Street Department -Street Maintenance Motor Vehicles & Equipment) Invoice Items Status Edit Invoice Date 09/30/2019 Amount/Unit 25,274.0000 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 25,274.00 Total Amount Vendor Catalog Part Number Contract Number 25,274.00 Amount 25,274.00 Vendor 243 - CEDAR BEND HUMANE SOCIETY, INC 050120E APRIL SURRENDERS 2020 Edit P.O. Number Item Description Conversion Item - APRIL SURRENDERS 2020 G/L Account Vendor 21974 - CARBON6 INC Totals Quantity U/M 1.0000 EA Invoices 05/08/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 3,772.5000 3,772.50 Project 525-17-2400 1314 (Sanitation Fund -Traffic Operations -Animal Control Health Services) Invoice Items 1 1 $25,274.00 Contract Number Amount 3,772.50 Vendor 243 - CEDAR BEND HUMANE SOCIETY, INC Totals Vendor 6693 - CEDAR VALLEY LAWN CARE 80944 BLACK SOIL FOR STUMP HOLES Edit P.O. Number Item Description Conversion Item - BLACK SOIL FOR STUMP HOLES Quantity U/M 1.0000 EA Invoices 04/24/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 1,260.0000 1,260.00 G/L Account 418-37-4100 2166 (June 2018 GO Bond Fund -Leisure Services -Leisure Services -Parks Trees & Shrubs) Project Invoice Items 1 3,772.50 1 $3,772.50 Contract Number Amount 1,260.00 81004 P.O. Number BLACK SOIL FOR STUMP HOLES Edit Item Description Conversion Item - BLACK SOIL FOR STUMP HOLES Quantity U/M 1.0000 EA 05/11/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 420.0000 420.00 G/L Account 418-37-4100 2166 (June 2018 GO Bond Fund -Leisure Services -Leisure Services -Parks Trees & Shrubs) Project Invoice Items 1 Contract Number Amount 420.00 Vendor 6693 - CEDAR VALLEY LAWN CARE Totals Vendor 21833 - CENTRAL IOWA DISTRIBUTING Invoices 1,260.00 420.00 2 $1,680.00 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 68 of 129 Page 19 of 80 Invoice Number 194887 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason GLOVES Edit Item Description Quantity Conversion Item - GLOVES 1.0000 G/L Account 010-37-4180 1541 (General Fund -Leisure Services-SportsPlex Janitorial Supplies) U/M EA Invoice Items Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/06/2020 05/26/2020 05/26/2020 431.00 Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 431.0000 431.00 Project 37SPLX.OPER (CEDAR VALLEY SPORTSPLEX, SPORTSPLEX OPERATIONS) 1 Amount 431.00 195214 P.O. Number SOAP, SANITIZER Edit Item Description Quantity U/M Conversion Item - SOAP, SANITIZER 1.0000 EA G/L Account 010-37-4180 1541 (General Fund -Leisure Services-SportsPlex Janitorial Supplies) Invoice Items 05/12/2020 Amount/Unit 421.2000 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 421.20 Project 37SPLX.OPER (CEDAR VALLEY SPORTSPLEX, SPORTSPLEX OPERATIONS) 1 Amount 421.20 Vendor 21833 - CENTRAL IOWA DISTRIBUTING Totals Vendor 3639 - KIM CHAPMAN 113-4932014-9029 LOCKS FOR FISH TANK CABINET Edit P.O. Number Item Description Quantity Conversion Item - LOCKS FOR FISH TANK 1.0000 CABINET U/M EA Invoices 04/23/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 16.0000 16.00 G/L Account 010-33-3200 1561 (General Fund -Library -County Library System Office Supplies & Minor Equipment) Invoice Items Project 1 421.20 2 $852.20 Contract Number Amount 16.00 MCOM35504099 P.O. Number DISPOSABLE MASKS Edit Item Description Quantity Conversion Item - DISPOSABLE MASKS 1.0000 G/L Account 010-33-3200 1561 (General Fund -Library -County Library System Office Supplies & Minor Equipment) U/M EA Invoice Items 05/08/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 126.0600 126.06 Project 1 Contract Number Amount 126.06 2020-00002369 P.O. Number LIBRARYWORKS WEBINAR Edit Item Description Quantity Conversion Item - LIBRARYWORKS WEBINAR 1.0000 G/L Account 010-33-3210 1346 (General Fund -Library -Library Open Access Travel - Professional Training) U/M EA Invoice Items 05/13/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 49.0000 49.00 Project 1 Contract Number Amount 49.00 Vendor 3639 - KIM CHAPMAN Totals Vendor 8567 - CLAPSADDLE-GARBER ASSOC. INC. Invoices 16.00 126.06 49.00 3 $191.06 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 69 of 129 Page 20 of 80 Invoice Number 41504 P.O. Number Invoice Description Status CONT 979 HWY SANITARY Edit SEWER Item Description Conversion Item - CONT 979 HWY SANITARY SEWER Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 04/30/2020 05/26/2020 05/26/2020 1,904.65 Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 1.0000 EA 1,904.6500 1,904.65 G/L Account 426-08-6260 2103 (Capital Improvements Fund -Planning & Zoning- Midport TIF District Engineering & Consulting) Invoice Items Project Amount 08MIDPT.KOELKER (MIDPORT, AIRLINE SEWER) 1,904.65 1 Vendor 8567 - CLAPSADDLE-GARBER ASSOC. INC. Totals Vendor 21975 - COLLABORATIVE SUMMER LIBRARY PROGRAM 7740 P.O. Number SLP MINI STICKERS Edit Item Description Quantity U/M Conversion Item - SLP MINI STICKERS 1.0000 EA G/L Account 010-33-3200 1561 (General Fund -Library -County Library System Office Supplies & Minor Equipment) Invoice Items 05/14/2020 Amount/Unit 21.2500 Project 1 Invoices 1 $1,904.65 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 21.25 Amount 21.25 Vendor 21975 - COLLABORATIVE SUMMER LIBRARY PROGRAM Totals Vendor 20229 - COPY SYSTEMS, INC IN376782 POSTAGE MAILING TAPES Edit P.O. Number Item Description Quantity Conversion Item - POSTAGE MAILING TAPES 1.0000 G/L Account 010-33-3200 1561 (General Fund -Library -County Library System Office Supplies & Minor Equipment) Invoice Items U/M EA Invoices 05/07/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 20.6000 20.60 Project 1 21.25 1 $21.25 Contract Number Amount 20.60 Vendor 20229 - COPY SYSTEMS, INC Totals Vendor 7625 - COURIER 181392A INTENT TO RELEASE FUNDS Edit P.O. Number Item Description Quantity U/M Conversion Item - INTENT TO RELEASE 1.0000 EA FUNDS Invoices 05/05/2020 05/26/2020 05/26/2020 05/05/2020 Amount/Unit Total Amount Vendor Catalog Part Number 116.8000 116.80 G/L Account 224-32-5870 1351 (Community Develop Block Grant -Community Development -Block Grant Home -Federal Advertising Expense) Project HM21A.0001 (HOME -FEDERAL PROGRAM ADMINISTRATION, HOME FEDERAL ADMINISTRATION) 20.60 1 $20.60 Contract Number Amount 58.40 116.80 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 70 of 129 Page 21 of 80 Invoice Number 181392A P.O. Number Invoice Description Status INTENT TO RELEASE FUNDS Edit Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Held Reason Invoice Date Due Date G/L Date Received Date 05/05/ Item Description Quantity U/M Amount/Unit 224-32-5850 1351 (Community Develop Block Grant -Community Development -Block Grant Administration Advertising Expense) Invoice Items Payment Date 2020 05/26/2020 05/26/2020 05/05/2020 Total Amount Vendor Catalog Part Number Contract Number BG21A.ADMN (BLOCK GRANT GENERAL 58.40 MANAGEMENT, OVERSIGHT, BLOCK GRANT GENERAL ADMINISTRATION) 1 Invoice Net Amount 116.80 Vendor 348 - CRESCENT ELECTRIC SUPPLY CO. S507848364.001 LIGHTS P.O. Number Item Description Conversion Item - LIGHTS G/L Account 010-37-4180 1521 (General Fund -Leisure Services-SportsPlex Electrical Supplies) Invoice Items Edit Vendor 7625 - COURIER Totals Invoices 1 $116.80 Quantity U/M 1.0000 EA 05/08/2020 05/26/2020 05/26/2020 Amount/Unit 182.7300 182.73 Project 37SPLX.OPER (CEDAR VALLEY SPORTSPLEX, SPORTSPLEX OPERATIONS) 1 Total Amount Vendor Catalog Part Number Contract Number Amount 182.73 Vendor 4577 - D & J OIL COMPANY 70700 GASOLINE - SHOP P.O. Number Vendor 348 - CRESCENT ELECTRIC SUPPLY CO. Totals Edit Item Description Quantity Conversion Item - GASOLINE - SHOP 1.0000 Invoices 05/13/2020 05/26/2020 05/26/2020 U/M Amount/Unit EA 884.0000 G/L Account Project 010-37-4100 1533 (General Fund -Leisure Services -Leisure Services -Parks Fuel Expense) Invoice Items 1 Total Amount Vendor Catalog Part Number 884.00 182.73 1 $182.73 Contract Number Amount 884.00 Vendor 414 - D & K PRODUCTS 0508295-IN TURF PRODUCTS P.O. Number Edit Item Description Conversion Item - TURF PRODUCTS G/L Account Vendor 4577 - D & J OIL COMPANY Totals Invoices Quantity U/M 1.0000 EA 05/06/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 2,105.9500 2,105.95 Project 010-37-4100 1537 (General Fund -Leisure Services -Leisure Services -Parks Horticultural & Landscaping Supplies) Invoice Items 1 884.00 1 $884.00 Contract Number Amount 2,105.95 Vendor 414 - D & K PRODUCTS Totals Invoices Vendor 388 - DELL MARKETING L.P. 2,105.95 1 $2,105.95 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 71 of 129 Page 22 of 80 Invoice Number 10391562823 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount DELL LATITUDE 7390 2-IN1 CTO Edit 05/06/2020 05/26/2020 05/26/2020 893.84 BASE Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item - DELL LATITUDE 7390 2-IN1 1.0000 EA 893.8400 893.84 CTO BASE G/L Account Project Amount 418-11-1100 2106 (June 2018 GO Bond Fund -Police Department -Police 893.84 Operations Computer Equipment) Invoice Items 1 Vendor 388 - DELL MARKETING L.P. Totals Invoices 1 $893.84 Vendor 3079 - DENNIS SUPPLY CO. WA01192743-001 AIR FILTERS - FIRE STAT #3 Edit 05/11/2020 05/26/2020 05/26/2020 05/14/2020 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item - AIR FILTERS - FIRE STAT 1.0000 EA 61.5600 61.56 #3 G/L Account Project Amount 010-22-8800 1571 (General Fund -Building Inspection -Facilities 61.56 Maintenance Machinery & Equipment Replacement Parts) Invoice Items 1 61.56 Vendor 3079 - DENNIS SUPPLY CO. Totals Invoices 1 $61.56 Vendor 13186 - DIAMOND OIL COMPANY 500682 UNLEADED GASOHOL Edit 04/20/2020 05/26/2020 05/26/2020 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item - UNLEADED GASOHOL 1.0000 EA 7,478.1800 7,478.18 G/L Account Project Amount 010-18-7955 1533 (General Fund -Central Garage -Garage -Motor Pool 7,478.18 Service Fuel Expense) Invoice Items 1 7,478.18 Vendor 13186 - DIAMOND OIL COMPANY Totals Invoices 1 $7,478.18 Vendor 1599 - DICK WITHAM FORD 33.36 MUDFLAPS Edit 04/29/2020 05/26/2020 05/26/2020 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item - MUDFLAPS 1.0000 EA 33.3600 33.36 G/L Account Project Amount 010-18-1411 1571 (General Fund -Central Garage -Ambulance -Garage 33.36 Parts & Service Machinery & Equipment Replacement Parts) Invoice Items 1 33.36 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 72 of 129 Page 23 of 80 Invoice Number 263661 P.O. Number Invoice Description Status NUTS Edit Item Description Conversion Item - NUTS G/L Account Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Held Reason Invoice Date 05/04/2020 Quantity U/M Amount/Unit 1.0000 EA 14.0000 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 14.00 Amount 14.00 Vendor 6386 - ELECTRONIC ENGINEERING 345000125-1 PARTS & LABOR FOR KEMP'S CAR Edit CAMERA HAVING VIDEO ISSUES Vendor 1599 - DICK WITHAM FORD Totals 04/24/2020 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - PARTS & LABOR FOR 1.0000 EA 127.5000 KEMP'S CAR CAMERA HAVING VIDEO ISSUES G/L Account 010-11-1100 1378 (General Fund -Police Department -Police Operations Other Equipment Repair & Maintenance) Invoice Items Project 1 Invoices 14.00 2 $47.36 05/26/2020 05/26/2020 127.50 Total Amount Vendor Catalog Part Number Contract Number 127.50 Amount 127.50 Vendor 471 - EXPRESS SERVICES, INC. 23894650 YDW SECURITY MARY A. HOLMAN Vendor 6386 - ELECTRONIC ENGINEERING Totals Edit 04/29/2020 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - YDW SECURITY MARY A. 1.0000 EA 554.3600 HOLMAN G/L Account 525-15-5400 1301 (Sanitation Fund -Waste Management -Sanitation -Solid Waste Disposal Temp Agency Services) Project Invoice Items 1 Invoices 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number 554.36 1 $127.50 Contract Number Amount 554.36 Vendor 471 - EXPRESS SERVICES, INC. Totals Vendor 12909 - FARMERS STATE BANK 2020-00002355 April Bank Fees Edit P.O. Number Item Description Quantity Conversion Item 1.0000 G/L Account 010-37-4100 1504 Credit Card Fees) Conversion Item 1.0000 EA G/L Account 010-37-4500 1504 Card Fees) U/M EA Invoices 05/25/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 66.3600 66.36 Project (General Fund -Leisure Services -Leisure Services -Parks 69.9000 Project (General Fund -Leisure Services -Young Arena Credit 69.90 554.36 1 $554.36 Contract Number Amount 66.36 Amount 69.90 1,642.37 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 73 of 129 Page 24 of 80 Invoice Number 2020-00002355 P.O. Number Invoice Description Status April Bank Fees Edit Item Description Conversion Item G/L Account 010-37-4500 1504 (General Card Fees) Conversion Item G/L Account 010-37-4180 1504 (General Card Fees) Conversion Item G/L Account 010-37-4200 1504 (General Services Credit Card Fees) Conversion Item G/L Account 010-22-7930 1503 (General Bank Fees) Conversion Item G/L Account 010-22-7930 1503 (General Bank Fees) Conversion Item G/L Account 010-22-7930 1503 (General Bank Fees) Conversion Item G/L Account 010-22-7930 1503 (General Bank Fees) Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Held Reason Quantity U/M 1.0000 EA Invoice Date 05/25/2020 Amount/Unit 191.1000 Fund -Leisure Services -Young Arena Credit Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 1,642.37 Total Amount Vendor Catalog Part Number Contract Number 191.10 Project Amount 1.0000 EA 182.3500 182.35 Fund -Leisure Services-SportsPlex Credit 1.0000 EA Fund -Leisure Services -Sports & Youth 191.10 Project Amount 37SPLX.OPER (CEDAR VALLEY SPORTSPLEX, 182.35 SPORTSPLEX OPERATIONS) 571.0100 571.01 Project Amount 571.01 1.0000 EA 20.0000 20.00 Fund -Building Inspection -Parking Operations 1.0000 EA 527.4500 Fund -Building Inspection -Parking Operations Project Project 527.45 1.0000 EA 12.0000 12.00 Project Fund -Building Inspection -Parking Operations 1.0000 EA 2.2000 2.20 Project Fund -Building Inspection -Parking Operations Invoice Items 9 Amount 20.00 Amount 527.45 Amount 12.00 Amount 2.20 Vendor 11488 - FERGUSON ENTERPRISES, INC. 7485551 REPL GRINDER PUMP - ART Edit CENTER Vendor 12909 - FARMERS STATE BANK Totals 05/11/2020 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - REPL GRINDER PUMP - ART 1.0000 EA 1,052.0000 CENTER G/L Account 418-22-8800 2152 (June 2018 GO Bond Fund -Building Inspection - Facilities Maintenance Building Improvements) Project Invoice Items 1 Invoices 1 $1,642.37 05/26/2020 05/26/2020 05/18/2020 1,052.00 Total Amount Vendor Catalog Part Number Contract Number 1,052.00 Amount 1,052.00 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 74 of 129 Page 25 of 80 Invoice Number 7514616 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason PLUMBING - ART CENTER Edit Item Description Quantity U/M Conversion Item - PLUMBING - ART CENTER 1.0000 EA G/L Account 418-22-8800 2152 (June 2018 GO Bond Fund -Building Inspection - Facilities Maintenance Building Improvements) Invoice Items Invoice Date 05/11/2020 Amount/Unit 192.0000 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 05/18/2020 Total Amount Vendor Catalog Part Number Contract Number 192.00 Amount 192.00 7520044 P.O. Number TANKLESS WH - FIRE STAT #1 Edit Item Description Conversion Item - TANKLESS WH - FIRE STAT #1 Quantity U/M 1.0000 EA 05/11/2020 Amount/Unit 1,745.5600 G/L Account 418-22-1400 2152 (June 2018 GO Bond Fund -Building Inspection -Fire Protection Service Building Improvements) Project Invoice Items 1 05/26/2020 05/26/2020 05/18/2020 Total Amount Vendor Catalog Part Number Contract Number 1,745.56 Amount 1,745.56 7521551 P.O. Number PLUMBING WH - FIRE STAT #1 Edit Item Description Quantity U/M Conversion Item - PLUMBING WH - FIRE STAT 1.0000 EA #1 G/L Account 418-22-1400 2152 (June 2018 GO Bond Fund -Building Inspection -Fire Protection Service Building Improvements) Invoice Items 05/12/2020 Amount/Unit 407.4900 Project 1 05/26/2020 05/26/2020 05/18/2020 Total Amount Vendor Catalog Part Number 407.49 Contract Number Amount 407.49 7523429 P.O. Number PLUMBING - ART CENTER Edit Item Description Quantity U/M Conversion Item - PLUMBING - ART CENTER 1.0000 EA G/L Account 418-22-8800 2152 (June 2018 GO Bond Fund -Building Inspection - Facilities Maintenance Building Improvements) Invoice Items 05/12/2020 05/26/2020 05/26/2020 05/18/2020 Amount/Unit Total Amount Vendor Catalog Part Number 652.9300 652.93 Project 1 Contract Number Amount 652.93 7522998 P.O. Number IRRIGATION REPAIR Edit Item Description Conversion Item - IRRIGATION REPAIR G/L Account Quantity 1.0000 U/M EA 05/12/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 26.1900 26.19 Project 010-37-4120 1565 (General Fund -Leisure Services -Golf Courses Plumbing, Sewage & Drainage Supplies) Invoice Items 1 Contract Number Amount 26.19 Vendor 11488 - FERGUSON ENTERPRISES, INC. Totals Vendor 21982 - FIVE SULLIVAN BROTHERS CONVENTION CENTER Invoices 192.00 1,745.56 407.49 652.93 26.19 6 $4,076.17 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 75 of 129 Page 26 of 80 Invoice Number 10000018 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status CONV CTR OFFICE CARPET Edit Item Description Quantity U/M Conversion Item - CONV CTR OFFICE CARPET 1.0000 EA G/L Account 417-22-4900 2152 (June 2017 GO Bond Fund -Building Inspection -Five Sullivans Ctr Improvement Building Improvements) Invoice Items Held Reason Invoice Date 04/30/2020 Amount/Unit 8,076.0300 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 8,076.03 Amount 8,076.03 10000019 P.O. Number CONV CTR TIMECLOCK Edit Item Description Quantity U/M Conversion Item - CONV CTR TIMECLOCK 1.0000 EA G/L Account 417-22-4900 2152 (June 2017 GO Bond Fund -Building Inspection -Five Sullivans Ctr Improvement Building Improvements) Invoice Items 04/30/2020 Amount/Unit 3,766.9300 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 3,766.93 Amount 3,766.93 Vendor 21982 - FIVE SULLIVAN BROTHERS CONVENTION CENTER Totals Vendor 21398 - ANGIE FORDYCE 43977 REFUND PERSONAL TRAINING Edit P.O. Number Item Description Conversion Item - REFUND PERSONAL TRAINING Quantity U/M 1.0000 EA 05/15/2020 Amount/Unit 400.0000 G/L Account 010-37-4180 1785 (General Fund -Leisure Services-SportsPlex Refund Payments) Invoice Items Invoices 8,076.03 3,766.93 2 $11,842.96 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 400.00 Project 37SPLX.OPER (CEDAR VALLEY SPORTSPLEX, SPORTSPLEX OPERATIONS) 1 Amount 400.00 Vendor 4516 - FRIENDS OF THE LIBRARY 2020-00002368 REIMBURSE CC USE CANVA Edit SOFTWARE ANNUAL SUBSCRIPTION Vendor 21398 - ANGIE FORDYCE Totals 05/15/2020 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - REIMBURSE CC USE CANVA 1.0000 EA 119.4000 SOFTWARE ANNUAL SUBSCRIPTION G/L Account 010-33-3100 1520 (General Fund -Library -Library Services Computer Software) Invoice Items Project 1 400.00 Invoices 1 $400.00 05/26/2020 05/26/2020 119.40 Total Amount Vendor Catalog Part Number Contract Number 119.40 Amount 119.40 Vendor 4516 - FRIENDS OF THE LIBRARY Totals Vendor 515 - GALE/CENGAGE LEARNING Invoices 1 $119.40 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 76 of 129 Page 27 of 80 Invoice Number 70149864 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date ADULT PRINT Edit 03/20/2020 05/26/2020 05/26/2020 Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item - ADULT PRINT 1.0000 EA 20.2400 20.24 G/L Account Project Amount 010-33-3100 1582 (General Fund -Library -Library Services Adult Print 20.24 Materials) Invoice Items 1 Invoice Net Amount 20.24 70272081 ADULT PRINT Edit 04/22/2020 05/26/2020 05/26/2020 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item - ADULT PRINT 1.0000 EA 105.7200 105.72 G/L Account Project Amount 010-33-3100 1582 (General Fund -Library -Library Services Adult Print 105.72 Materials) Invoice Items 1 70272135 ADULT PRINT P.O. Number Item Description Conversion Item - ADULT PRINT G/L Account Edit 04/22/2020 05/26/2020 05/26/2020 Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 1.0000 EA 270.0000 270.00 Project Amount 010-33-3100 1582 (General Fund -Library -Library Services Adult Print 270.00 Materials) Invoice Items 1 105.72 270.00 Vendor 515 - GALE/CENGAGE LEARNING Totals Invoices 3 $395.96 Vendor 21540 - GATSO 2019--2305 ATE 4/12/20 - 4/25/20 Edit 05/25/2020 05/26/2020 05/26/2020 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item 1.0000 EA 17,136.0000 17,136.00 G/L Account Project Amount 010-11-1160 1390 (General Fund -Police Department -Law Enforcement 11PRO.ATE (POLICE DEPARTMENT PROJECTS, Police 17,136.00 Programs Other Contractual Services) ATE Citation Revenue) Invoice Items 1 2019--2339 ATE 4/26/20 - 5/11/20 Edit 05/25/2020 05/26/2020 05/26/2020 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item 1.0000 EA 16,056.0000 16,056.00 G/L Account Project Amount 010-11-1160 1390 (General Fund -Police Department -Law Enforcement 11PRO.ATE (POLICE DEPARTMENT PROJECTS, Police 16,056.00 Programs Other Contractual Services) ATE Citation Revenue) Invoice Items 1 Vendor 538 - GIERKE-ROBINSON COMPANY 17,136.00 16,056.00 Vendor 21540 - GATSO Totals Invoices 2 $33,192.00 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 77 of 129 Page 28 of 80 Invoice Number 3122302-000 P.O. Number Invoice Description Status CUT DIAMOND BLADE Edit Item Description Conversion Item - CUT DIAMOND BLADE G/L Account Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Quantity 1.0000 Held Reason Invoice Date 05/12/2020 U/M Amount/Unit EA 170.6900 520-14-5200 1535 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Hardware Items) Invoice Items Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 170.69 Amount 170.69 Vendor 538 - GIERKE-ROBINSON COMPANY Totals Vendor 547 - GOODYEAR COMMERCIAL TIRE & SERVICE CENTERS 119-1061585 P.O. Number TIRES Edit Item Description Conversion Item - TIRES G/L Account Quantity U/M 1.0000 EA 05/04/2020 Amount/Unit 808.3600 Project 010-18-7955 1569 (General Fund -Central Garage -Garage -Motor Pool Service Vehicle Replacement Parts) Invoice Items 1 Invoices 170.69 1 $170.69 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 808.36 Amount 808.36 Vendor 547 - GOODYEAR COMMERCIAL TIRE & SERVICE CENTERS Totals Vendor 553 - GRAINGER 9531576461 RETHREADING DIE CARBON Edit STEEL 05/13/2020 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - RETHREADING DIE 1.0000 EA 81.5200 CARBON STEEL G/L Account 520-14-5200 1535 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Hardware Items) Invoice Items Project 1 Invoices 808.36 1 $808.36 05/26/2020 05/26/2020 81.52 Total Amount Vendor Catalog Part Number Contract Number 81.52 Amount 81.52 9534374682 P.O. Number PRE -MOISTENED TOWELETTE Edit STAND PK 100 Item Description Quantity U/M Amount/Unit Conversion Item - PRE -MOISTENED 1.0000 EA 43.7000 TOWELETTE STAND PK 100 G/L Account 520-14-5200 1551 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Drugs/Medicines & Medical/Lab Supplies) Invoice Items 05/15/2020 Project 1 05/26/2020 05/26/2020 43.70 Total Amount Vendor Catalog Part Number Contract Number 43.70 Amount 43.70 Vendor 553 - GRAINGER Totals Vendor 564 - GROUT MUSEUM OF HISTORY AND SCIENCE Invoices 2 $125.22 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 78 of 129 Page 29 of 80 Invoice Number 2020-5 P.O. Number Invoice Description Status May 2020 Property Taxes Edit Item Description Conversion Item G/L Account 010-01-4220 1393 (G Subsidies) Conversion Item G/L Account 010-01-4220 1393 (G Subsidies) Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Quantity 1.0000 Held Reason U/M EA Invoice Date 05/25/2020 Amount/Unit 41,453.0200 eneral Fund -Mayor -Grout Museum Contributions & 1.0000 EA 652.3600 eneral Fund -Mayor -Grout Museum Contributions & Invoice Items Due Date 05/26/2020 G/L Date 05/26/2020 Received Date Payment Date Total Amount Vendor Catalog Part Number Contract Number 41,453.02 Project Amount 41,453.02 Project 2 652.36 Amount 652.36 Invoice Net Amount 42,105.38 Vendor 13038 - HALL & ASSOCIATES 10799 APRIL SERVICES P.O. Number Vendor 564 - GROUT MUSEUM OF HISTORY AND SCIENCE Totals Edit 05/14/2020 Item Description Quantity U/M Conversion Item - APRIL SERVICES 1.0000 EA G/L Account 520-14-5200 1313 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Legal Services) Invoice Items Amount/Unit 761.2500 Project 1 Invoices 1 $42,105.38 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 761.25 Amount 761.25 Vendor 1952 - HARRISON TRUCK CENTERS X101148716:01 PARTS FOR 193B08 P.O. Number Vendor 13038 - HALL & ASSOCIATES Totals Invoices Edit 04/30/2020 05/26/2020 05/26/2020 Item Description Quantity U/M Amount/Unit Conversion Item - PARTS FOR 193B08 1.0000 EA 812.0600 G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items Project 1 Total Amount Vendor Catalog Part Number 812.06 761.25 1 $761.25 Contract Number Amount 812.06 X101148934:01 HOSE P.O. Number Item Description Conversion Item - HOSE G/L Account Edit Quantity U/M 1.0000 EA 04/30/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 37.9600 37.96 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 Contract Number Amount 37.96 812.06 37.96 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 79 of 129 Page 30 of 80 Invoice Number X101148946:01 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status VALVE Edit Item Description Quantity U/M Conversion Item - VALVE 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items Held Reason Invoice Date 04/30/2020 Amount/Unit 187.6500 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 187.65 Amount 187.65 X101148946:02 P.O. Number VALVE Item Description Conversion Item - VALVE G/L Account Edit Quantity U/M 1.0000 EA 05/01/2020 Amount/Unit 187.6500 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 187.65 Amount 187.65 X101149011:01 P.O. Number BATTERY BOX Item Description Conversion Item - BATTERY BOX G/L Account Edit Quantity U/M 1.0000 EA 05/01/2020 Amount/Unit 108.0300 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 108.03 Amount 108.03 X101148716:02 P.O. Number PARTS FOR 193B08 Item Description Conversion Item - PARTS FOR 193B08 G/L Account Edit Quantity U/M 1.0000 EA 05/04/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 387.7100 387.71 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 Contract Number Amount 387.71 X101149669:01 P.O. Number WATER PUMP KITS Item Description Conversion Item - WATER PUMP KITS G/L Account Edit Quantity U/M 1.0000 EA 05/11/2020 Amount/Unit 595.4700 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 595.47 Amount 595.47 Vendor 1952 - HARRISON TRUCK CENTERS Totals Vendor 587 - HAWKEYE ALARM & SIGNAL CO Invoices 187.65 187.65 108.03 387.71 595.47 7 $2,316.53 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 80 of 129 Page 31 of 80 Invoice Number 80686 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status SERVICE CALL Edit Item Description Quantity U/M Conversion Item - SERVICE CALL 1.0000 EA G/L Account 266-19-7100 1371 (Road Use Tax -Street Department -Street Maintenance Building & Grounds Maintenance) Invoice Items Held Reason Invoice Date 05/03/2020 Amount/Unit 400.0000 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 400.00 Amount 400.00 80671 P.O. Number INSTALLED ALARM SYSTEM @ Edit YDW SITE Item Description Quantity U/M Amount/Unit Conversion Item - INSTALLED ALARM SYSTEM 1.0000 EA 930.0000 @ YDW SITE G/L Account 525-15-5400 1371 (Sanitation Fund -Waste Management -Sanitation -Solid Waste Disposal Building & Grounds Maintenance) Invoice Items 05/03/2020 Project 1 400.00 05/26/2020 05/26/2020 930.00 Total Amount Vendor Catalog Part Number Contract Number 930.00 Amount 930.00 Vendor 587 - HAWKEYE ALARM & SIGNAL CO Totals Vendor 21872 - HENKEL CONSTRUCTION COMPANY 1978M.02 16W EST #2 - 5 SULL BROS Edit KITCHEN PLUMBING IMPROVEMENTS 02/04/2020 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - 16W EST #2 - 5 SULL BROS 1.0000 EA 96,330.0000 KITCHEN PLUMBING IMPROVEMENTS G/L Account 417-22-4900 2152 (June 2017 GO Bond Fund -Building Inspection -Five Sullivans Ctr Improvement Building Improvements) Invoice Items Project 1 Invoices 2 $1,330.00 05/26/2020 05/26/2020 05/14/2020 96,330.00 Total Amount Vendor Catalog Part Number Contract Number 96,330.00 Amount 96,330.00 1978M.03 P.O. Number 16W EST #3-5 SULL BROS Edit KITCHEN PLUMBING IMPROVEMENTS 03/18/2020 05/26/2020 05/26/2020 05/14/2020 Item Description Quantity U/M Amount/Unit Conversion Item - 16W EST #3-5 SULL BROS 1.0000 EA 44,655.8900 KITCHEN PLUMBING IMPROVEMENTS G/L Account 417-22-4900 2152 (June 2017 GO Bond Fund -Building Inspection -Five Sullivans Ctr Improvement Building Improvements) Invoice Items Project 1 Total Amount Vendor Catalog Part Number Contract Number 44,655.89 Amount 44,655.89 Vendor 21872 - HENKEL CONSTRUCTION COMPANY Totals Vendor 21609 - I & S GROUP, INC Invoices 44,655.89 2 $140,985.89 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 81 of 129 Page 32 of 80 Invoice Number 64532 P.O. Number Invoice Description Status 20AC TRUCK WASH REVIEW Edit Item Description Conversion Item - 20AC TRUCK WASH REVIEW Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Held Reason Invoice Date 04/30/2020 Quantity U/M Amount/Unit 1.0000 EA 690.0000 G/L Account 418-18-7950 2103 (June 2018 GO Bond Fund -Central Garage -Central Garage Engineering & Consulting) Project Invoice Items 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 690.00 Amount 690.00 Vendor 2277728 P.O. Number Vendor 21609 - I & S GROUP, INC Totals 730 - I W I MOTOR PARTS CARBIDE CUTTER Edit Item Description Quantity U/M Conversion Item - CARBIDE CUTTER 1.0000 EA G/L Account 010-18-7950 1571 (General Fund -Central Garage -Central Garage Machinery & Equipment Replacement Parts) Invoices 05/05/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 15.3000 15.30 Project Invoice Items 1 690.00 1 $690.00 Contract Number Amount 15.30 Vendor 730 - I W I MOTOR PARTS Totals Vendor 11799 - INTERSTATE BATTERIES OF UPPER IOWA 22153423 BATTERIES Edit P.O. Number Item Description Quantity U/M Conversion Item - BATTERIES 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items Invoices 05/06/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 518.2000 518.20 Project 1 15.30 1 $15.30 Contract Number Amount 518.20 Vendor 11799 INTERSTATE BATTERIES OF UPPER IOWA Totals Vendor 723 - IOWA DEPARTMENT OF TRANSPORTATION 61449 GUARDRAIL Edit P.O. Number Item Description Conversion Item - GUARDRAIL G/L Account Quantity U/M 1.0000 EA Invoices 04/24/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 149.9400 149.94 Project 266-19-7100 1575 (Road Use Tax -Street Department -Street Maintenance Steel, Iron & Metal Supplies) Invoice Items 1 518.20 1 $518.20 Contract Number Amount 149.94 Vendor 723 - IOWA DEPARTMENT OF TRANSPORTATION Totals Vendor 20112 - IOWA ECONOMIC DEVELOPMENT AUTHORITY Invoices 149.94 1 $149.94 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 82 of 129 Page 33 of 80 Invoice Number 862 P.O. Number Status Edit Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Quantity 1.0000 Invoice Description Conversion Item Item Description Conversion Item - Thisislowa.com Featured Partner payment #1 G/L Account 010-01-8280 1351 (General Fund -Mayor -Communications Advertising Expense) Held Reason U/M EA Invoice Items Invoice Date 05/13/2020 Amount/Unit 750.0000 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 750.00 Amount 750.00 Vendor 20112 - IOWA ECONOMIC DEVELOPMENT AUTHORITY Totals Vendor 11839 - IOWA FINANCE AUTHORITY C0906RT-0620I SRF INTEREST P.O. Number Item Description Conversion Item - SRF INTEREST G/L Account Edit Quantity U/M 1.0000 EA 520-14-8980 2251 (Sanitary Sewer Fund -Waste Management -Water Pollution -Fiduciary Transactions Capital Loan Note Interest) Invoice Items Invoices 750.00 1 $750.00 05/01/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 12,845.0000 12,845.00 Project Amount 12,845.00 1 C0906RT-0620P P.O. Number SRF PRINCIPAL Edit 05/01/2020 05/26/2020 05/26/2020 Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Conversion Item - SRF PRINCIPAL 1.0000 EA 69,000.0000 69,000.00 G/L Account Project 520-14-8980 2250 (Sanitary Sewer Fund -Waste Management -Water Pollution -Fiduciary Transactions Capital Loan Note Principal) Invoice Items 1 Contract Number Amount 69,000.00 C0906RT-620F P.O. Number SRF SERVICE FEE Edit 05/01/2020 05/26/2020 05/26/2020 Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Conversion Item - SRF SERVICE FEE 1.0000 EA 1,835.0000 1,835.00 G/L Account Project 520-14-8980 1750 (Sanitary Sewer Fund -Waste Management -Water Pollution -Fiduciary Transactions Debt Service Expense) Invoice Items 1 Contract Number Amount 1,835.00 C099ORT-0620I P.O. Number SRF INTEREST Edit 05/01/2020 05/26/2020 05/26/2020 Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Conversion Item - SRF INTEREST 1.0000 EA 5,455.8100 5,455.81 G/L Account Project 520-14-8980 2251 (Sanitary Sewer Fund -Waste Management -Water Pollution -Fiduciary Transactions Capital Loan Note Interest) Invoice Items 1 Contract Number Amount 5,455.81 12,845.00 69,000.00 1,835.00 5,455.81 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 83 of 129 Page 34 of 80 Invoice Number C099ORT-0620P P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status SRF PRINCIPAL Edit Item Description Quantity U/M Conversion Item - SRF PRINCIPAL 1.0000 EA G/L Account 520-14-8980 2250 (Sanitary Sewer Fund -Waste Management -Water Pollution -Fiduciary Transactions Capital Loan Note Principal) Invoice Items Held Reason Invoice Date 05/01/2020 Amount/Unit 123,000.0000 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 123,000.00 Amount 123,000.00 123,000.00 C099ORT-620F P.O. Number SRF SERVICE FEE Edit Item Description Quantity U/M Conversion Item - SRF SERVICE FEE 1.0000 EA G/L Account 520-14-8980 1750 (Sanitary Sewer Fund -Waste Management -Water Pollution -Fiduciary Transactions Debt Service Expense) Invoice Items 05/01/2020 Amount/Unit 779.4000 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 779.40 Amount 779.40 Vendor 11839 - IOWA FINANCE AUTHORITY Totals Vendor 21473 - IOWA ONE CALL 220985 APRIL 2020 LOCATE EMAILS Edit P.O. Number Item Description Conversion Item - APRIL 2020 LOCATE EMAILS Quantity U/M 1.0000 EA 05/15/2020 Amount/Unit 210.6000 G/L Account 266-17-7120 1344 (Road Use Tax -Traffic Operations -Traffic Safety Telephone & Fax Expense) Invoice Items Project 1 Invoices 779.40 6 $212,915.21 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 210.60 Amount 210.60 221103 P.O. Number APRIL EMAILS Edit Item Description Conversion Item - APRIL EMAILS G/L Account 520-14-5200 1319 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Other Professional Services) Invoice Items Quantity U/M 1.0000 EA 05/15/2020 Amount/Unit 1,006.3000 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 1,006.30 Amount 1,006.30 Vendor 4101 - IOWA WALL SAWING SERVICE 031927 CORE DRILLING - FIRE STAT #6 Edit P.O. Number Item Description Conversion Item - CORE DRILLING - FIRE STAT #6 G/L Account Vendor 21473 - IOWA ONE CALL Totals Quantity U/M 1.0000 EA 05/05/2020 Amount/Unit 350.0000 Project Invoices 210.60 1,006.30 2 $1,216.90 05/26/2020 05/26/2020 05/12/2020 Total Amount Vendor Catalog Part Number Contract Number 350.00 Amount 350.00 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 84 of 129 Page 35 of 80 Invoice Number 031927 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason Invoice Date CORE DRILLING - FIRE STAT #6 Edit 05/05/2020 Item Description Quantity U/M Amount/Unit 418-22-1400 2152 (June 2018 GO Bond Fund -Building Inspection -Fire Protection Service Building Improvements) Invoice Items 1 Due Date G/L Date Received Date Payment Date 05/26/2020 05/26/2020 05/12/2020 Total Amount Vendor Catalog Part Number Contract Number 350.00 Invoice Net Amount 350.00 031928 P.O. Number CORE DRILLING - FIRE STAT #2 Edit Item Description Quantity U/M Amount/Unit Conversion Item - CORE DRILLING - FIRE 1.0000 EA 450.0000 STAT #2 G/L Account 418-22-1400 2152 (June 2018 GO Bond Fund -Building Inspection -Fire Protection Service Building Improvements) Invoice Items 05/05/2020 Project 1 05/26/2020 05/26/2020 05/12/2020 Total Amount Vendor Catalog Part Number Contract Number 450.00 Amount 450.00 Vendor 4101 - IOWA WALL SAWING SERVICE Totals Vendor 4895 - IOWA WORKFORCE DEVELOPMENT 165937 ELEV PERMIT #8076 - CARNEGIE Edit P.O. Number Item Description Conversion Item - ELEV PERMIT #8076 - CARNEGIE Quantity U/M 1.0000 EA 05/08/2020 Amount/Unit 75.0000 G/L Account 010-22-8800 1390 (General Fund -Building Inspection -Facilities Maintenance Other Contractual Services) Invoice Items Project 1 Invoices 450.00 2 $800.00 05/26/2020 05/26/2020 05/14/2020 Total Amount Vendor Catalog Part Number Contract Number 75.00 Amount 75.00 Vendor 10535 - JIM HAWK TRUCK TRAILERS 2201260013 0-RING SEAL P.O. Number Vendor 4895 - IOWA WORKFORCE DEVELOPMENT Totals Edit 05/05/2020 Item Description Quantity U/M Amount/Unit Conversion Item - 0-RING SEAL 1.0000 EA 345.1400 G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items Project 1 Invoices 75.00 1 $75.00 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 345.14 Amount 345.14 Vendor 10535 - JIM HAWK TRUCK TRAILERS Totals Vendor 748 - JOHNSTONE SUPPLY Invoices 345.14 1 $345.14 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 85 of 129 Page 36 of 80 Invoice Number 1064122 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason HVAC - FIRE STAT #1 Edit Item Description Quantity U/M Conversion Item - HVAC - FIRE STAT #1 1.0000 EA G/L Account 010-22-8800 1571 (General Fund -Building Inspection -Facilities Maintenance Machinery & Equipment Replacement Parts) Invoice Items Invoice Date 05/11/2020 Amount/Unit 62.4000 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 05/14/2020 Total Amount Vendor Catalog Part Number Contract Number 62.40 Amount 62.40 1064213 P.O. Number HVAC - FIRE STAT #1 Edit Item Description Quantity U/M Conversion Item - HVAC - FIRE STAT #1 1.0000 EA G/L Account 010-22-8800 1571 (General Fund -Building Inspection -Facilities Maintenance Machinery & Equipment Replacement Parts) Invoice Items 05/13/2020 Amount/Unit 61.9400 Project 1 05/26/2020 05/26/2020 05/14/2020 Total Amount Vendor Catalog Part Number Contract Number 61.94 Amount 61.94 Vendor 788 - K & S WHEEL ALIGNMENT SERVICE 133228 TIRES Edit Vendor 748 - JOHNSTONE SUPPLY Totals P.O. Number Item Description Quantity Conversion Item - TIRES 1.0000 G/L Account U/M EA 05/11/2020 Amount/Unit 910.0800 Project 010-18-7955 1569 (General Fund -Central Garage -Garage -Motor Pool Service Vehicle Replacement Parts) Invoice Items 1 Invoices 62.40 61.94 2 $124.34 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 910.08 Amount 910.08 Vendor 788 - K & S WHEEL ALIGNMENT SERVICE Totals Vendor 364 - K. CUNNINGHAM CONSTRUCTION 970-11 CONT 970 FY20 DYSART RD & W Edit 2ND STREET RECON 05/14/2020 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - CONT 970 FY20 DYSART 1.0000 EA 220,159.1900 RD & W 2ND STREET RECON G/L Account 205-07-7500 2165 (Local Option Sales Tax -City Engineer -Street Construction Streets & Roadways) Invoice Items Project 1 Invoices 910.08 1 $910.08 05/26/2020 05/26/2020 220,159.19 Total Amount Vendor Catalog Part Number Contract Number 220,159.19 Amount 220,159.19 Vendor 364 - K. CUNNINGHAM CONSTRUCTION Totals Vendor 6845 - KWIK TRIP INC. Invoices 1 $220,159.19 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 86 of 129 Page 37 of 80 Invoice Number 8334889 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason CAN GAS Edit Item Description Quantity Conversion Item - CAN GAS 1.0000 G/L Account 010-12-1400 1533 (General Fund -Fire Department -Fire Protection Service Fuel Expense) U/M EA Invoice Items Invoice Date 05/15/2020 Amount/Unit 11.2500 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 11.25 Amount 11.25 Vendor 6845 - KWIK TRIP INC. Totals Vendor 8889 - LOCKSPERTS 169993 REKEY OF THE NEW PROPERTY Edit STORAGE BLDG P.O. Number Item Description Quantity Conversion Item - REKEY OF THE NEW 1.0000 PROPERTY STORAGE BLDG G/L Account 416-11-1100 2152 (June 2016 GO Bond Fund -Police Department -Police Operations Building Improvements) Invoice Items 05/08/2020 U/M Amount/Unit EA 242.2400 Project 1 Invoices 11.25 05/26/2020 05/26/2020 242.24 Total Amount Vendor Catalog Part Number Contract Number 242.24 Amount 242.24 Vendor 8889 - LOCKSPERTS Totals Vendor 21085 - LODGE CONSTRUCTION INC 1015-2 CONT 1015 FY20 COURTLAND, Edit JEFFERSON AND MULBERRY STREET RECON P.O. Number Item Description Quantity Conversion Item - CONT 1015 FY20 1.0000 COURTLAND, JEFFERSON AND MULBERRY STREET RECON G/L Account 617-14-5320 2163 (June 2017 Sewer GO Bond Management -Water Pollution -Sewer Coll Sytem Sewers) 205-07-7500 2165 (Local Option Sales Tax -City Construction Streets & Roadways) 05/14/2020 U/M Amount/Unit EA 98,440.9000 Fund -Waste Improvements Sanitary Engineer -Street Invoice Items Project 1 Invoices 1 $242.24 05/26/2020 05/26/2020 98,440.90 Total Amount Vendor Catalog Part Number Contract Number 98,440.90 Amount 88,703.40 9,737.50 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 87 of 129 Page 38 of 80 Invoice Number 05082020 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status CONT 949 REMEDIAL ACTION PH Edit IIIB PAY EST #7 RETAINAGE RELEASE Item Description Quantity U/M Conversion Item - CONT 949 REMEDIAL 1.0000 EA ACTION PH IIIB PAY EST #7 RETAINAGE RELEASE Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/08/2020 05/26/2020 05/26/2020 22,159.79 Amount/Unit 22,159.7900 G/L Account 520-14-5200 2163 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Sanitary Sewers) Invoice Items Total Amount Vendor Catalog Part Number Contract Number 22,159.79 Project 14SRF.CIPP3B (STATE REVOLVING LOAN FUND, CIPP3B) 1 Amount 22,159.79 Vendor 2922 - MACQUEEN EQUIPMENT INC. P09834 PARTS FOR 190805 P.O. Number Vendor 21085 - LODGE CONSTRUCTION INC Totals Edit Item Description Conversion Item - PARTS FOR 190805 G/L Account Quantity U/M 1.0000 EA Invoices 03/12/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 12,138.4800 12,138.48 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 2 $120,600.69 Contract Number Amount 12,138.48 P10294 P.O. Number WATER TANK Edit 05/04/2020 05/26/2020 05/26/2020 Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Conversion Item - WATER TANK 1.0000 EA 59.1500 59.15 G/L Account Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 Contract Number Amount 59.15 Vendor 845 - MANATT'S INC. 981198 P.O. Number 900 W 7TH ST Item Description Conversion Item - 900 W 7TH ST G/L Account Vendor 2922 - MACQUEEN EQUIPMENT INC. Totals Edit Quantity U/M 1.0000 EA Invoices 05/15/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 348.7500 348.75 Project 520-14-5200 1511 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Concrete & Aggregates) Invoice Items 1 12,138.48 59.15 2 $12,197.63 Contract Number Amount 348.75 Vendor 845 - MANATT'S INC. Totals Vendor 848 - MANPOWER, INC Invoices 348.75 1 $348.75 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 88 of 129 Page 39 of 80 Invoice Number 40164337 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason Invoice Date YDW ATTENDANT/ CHARLES Edit 05/10/2020 LANDFAIR Item Description Quantity U/M Amount/Unit Conversion Item - YDW ATTENDANT/ 1.0000 EA 777.4600 CHARLES LANDFAIR G/L Account 525-15-5400 1301 (Sanitation Fund -Waste Management -Sanitation -Solid Waste Disposal Temp Agency Services) Invoice Items Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 777.46 Total Amount Vendor Catalog Part Number Contract Number 777.46 Amount 777.46 Vendor 848 - MANPOWER, INC Totals Vendor 855 - MARTIN BROS DIST CO INC 8429946 CONCESSIONS - SPORTSPLEX Edit 05/15/2020 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - CONCESSIONS - 1.0000 EA 378.4700 SPORTSPLEX G/L Account 010-37-4180 1553 (General Fund -Leisure Services-SportsPlex Merchandise for Resale) Invoice Items Invoices 1 $777.46 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 378.47 Project 37SPLX.OPER (CEDAR VALLEY SPORTSPLEX, SPORTSPLEX OPERATIONS) 1 Amount 378.47 Vendor 8147 - MEDIACOM 2020-00002371 RT - CABLE & WI-FI P.O. Number Vendor 855 - MARTIN BROS DIST CO INC Totals Edit 05/07/2020 Item Description Quantity U/M Amount/Unit Conversion Item - RT - CABLE & WI-FI 1.0000 EA 4,670.9600 G/L Account 283-13-5450 1400 (Housing Programs -Housing Authority -Ridgeway Towers Utility Service) Invoice Items Project 1 Invoices 378.47 1 $378.47 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 4,670.96 Amount 4,670.96 2020-00002370 RT - INTERNET Edit P.O. Number Item Description Quantity U/M Conversion Item - RT - INTERNET 1.0000 EA G/L Account 283-13-5450 1400 (Housing Programs -Housing Authority -Ridgeway Towers Utility Service) Invoice Items 05/12/2020 05/26/2020 05/26/2020 Amount/Unit 147.7200 147.72 Project 1 Total Amount Vendor Catalog Part Number Contract Number Amount 147.72 Vendor 8147 - MEDIACOM Totals Vendor 885 - MENARDS Invoices 4,670.96 147.72 2 $4,818.68 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 89 of 129 Page 40 of 80 Invoice Number 57061 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason HARDWARE - BLDG MAINT Edit Item Description Conversion Item - HARDWARE - G/L Account 010-22-8800 1535 (General Fund -Building Inspection -Facilities Maintenance Hardware Items) Quantity U/M BLDG MAINT 1.0000 EA Invoice Date 05/06/2020 Amount/Unit 29.1400 Project Invoice Items 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 05/14/2020 Total Amount Vendor Catalog Part Number Contract Number 29.14 Amount 29.14 57504 HVAC - FIRE STAT #1 Edit 05/12/2020 05/26/2020 05/26/2020 05/14/2020 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Conversion Item - HVAC - FIRE STAT #1 1.0000 EA 52.5900 52.59 G/L Account Project 010-22-8800 1571 (General Fund -Building Inspection -Facilities Maintenance Machinery & Equipment Replacement Parts) Invoice Items 1 Contract Number Amount 52.59 57551 PLUMBING - FIRE STAT #1 Edit P.O. Number Item Description Conversion Item - PLUMBING - FIRE STAT #1 G/L Account Quantity U/M 1.0000 EA 05/12/2020 05/26/2020 05/26/2020 05/14/2020 Amount/Unit Total Amount Vendor Catalog Part Number 36.1100 36.11 Project 010-22-8800 1565 (General Fund -Building Inspection -Facilities Maintenance Plumbing, Sewage & Drainage Supplies) Invoice Items 1 Contract Number Amount 36.11 57153 CLEANING MATERIALS/COVID19 Edit 05/07/2020 05/26/2020 05/26/2020 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Conversion Item - CLEANING 1.0000 EA 15.4700 15.47 MATERIALS/COVID19 G/L Account Project 010-12-1400 1371 (General Fund -Fire Department -Fire Protection Service Building & Grounds Maintenance) Invoice Items 1 Contract Number Amount 15.47 57063 P.O. Number RT - VINYL AND BASE FOR Edit COMMON BATHROOM AREA 05/06/2020 05/26/2020 05/26/2020 Item Description Quantity U/M Amount/Unit Conversion Item - RT - VINYL AND BASE FOR 1.0000 EA 406.5400 COMMON BATHROOM AREA G/L Account 283-13-5450 1371 (Housing Programs -Housing Authority -Ridgeway Towers Building & Grounds Maintenance) Project Invoice Items 1 Total Amount Vendor Catalog Part Number 406.54 Contract Number Amount 406.54 29.14 52.59 36.11 15.47 406.54 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 90 of 129 Page 41 of 80 Invoice Number 57203 P.O. Number Invoice Description Status EARPLUGS & STAPLEGUNS (3) Edit Item Description Conversion Item - EARPLUGS & STAPLEGUNS (3) Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Quantity 1.0000 Held Reason Invoice Date 05/08/2020 U/M Amount/Unit EA 80.9000 G/L Account 010-11-1100 1371 (General Fund -Police Department -Police Operations Building & Grounds Maintenance) 010-11-1100 1573 (General Fund -Police Department -Police Operations Safety & Protective Equipment) Invoice Items Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 80.90 Amount 50.91 29.99 57219 P.O. Number CORDLESS IMPACT DRIVER & Edit ACCESSORIES Item Description Quantity U/M Amount/Unit Conversion Item CORDLESS IMPACT DRIVER 1.0000 EA 174.9900 & ACCESSORIES G/L Account 010-11-1100 1371 (General Fund -Police Department -Police Operations Building & Grounds Maintenance) Invoice Items 05/08/2020 Project 1 80.90 05/26/2020 05/26/2020 174.99 Total Amount Vendor Catalog Part Number Contract Number 174.99 Amount 174.99 56131 P.O. Number PROPANE TANKS FOR Edit DURAPATCHER 04/23/2020 05/26/2020 05/26/2020 Item Description Quantity U/M Amount/Unit Conversion Item - PROPANE TANKS FOR 1.0000 EA 13.8800 DURAPATCHER G/L Account 205-19-7110 1555 (Local Option Sales Tax -Street Department -Seal Coating Program Minor Equipment & Supplies) Project Invoice Items 1 Total Amount Vendor Catalog Part Number 13.88 Contract Number Amount 13.88 56562 P.O. Number WONDER MOP Edit Item Description Quantity Conversion Item - WONDER MOP 1.0000 G/L Account 266-19-7100 1541 (Road Use Tax -Street Department -Street Maintenance Janitorial Supplies) U/M EA 04/29/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 8.3700 8.37 Project Invoice Items 1 Contract Number Amount 8.37 57671 P.O. Number PAINT SUPPLIES Edit Item Description Quantity U/M Conversion Item - PAINT SUPPLIES 1.0000 EA G/L Account 266-17-7120 1577 (Road Use Tax -Traffic Operations -Traffic Safety Traffic Sign Materials & Supplies) 05/12/2020 05/26/2020 05/26/2020 Amount/Unit 28.0200 28.02 Project Invoice Items 1 Total Amount Vendor Catalog Part Number Contract Number Amount 28.02 13.88 8.37 28.02 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 91 of 129 Page 42 of 80 Invoice Number 56973 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status WRAP, CORDS Edit Item Description Quantity U/M Conversion Item - WRAP, CORDS 1.0000 EA G/L Account 520-14-5200 1535 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Hardware Items) Invoice Items Held Reason Invoice Date 05/05/2020 Amount/Unit 20.2300 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 20.23 Amount 20.23 57518 P.O. Number BLADES Edit Item Description Quantity U/M Conversion Item - BLADES 1.0000 EA G/L Account 520-14-5200 1535 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Hardware Items) Invoice Items 05/12/2020 Amount/Unit 31.9600 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 31.96 Amount 31.96 57576-1 P.O. Number SCREWS Item Description Conversion Item - SCREWS G/L Account Edit Quantity U/M 1.0000 EA 05/12/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 23.7800 23.78 Project 520-14-5200 1535 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Hardware Items) Invoice Items 1 Contract Number Amount 23.78 Vendor 891 - METROPOLITAN TRANSIT AUTHORITY 2020-5 May 2020 Property Taxes Edit P.O. Number Item Description Conversion Item G/L Account Vendor 885 - MENARDS Totals Quantity U/M 1.0000 EA Invoices 05/25/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 92,300.4700 92,300.47 Project 010-01-7800 1393 (General Fund -Mayor -Metropolitan Transit Contributions & Subsidies) Invoice Items 1 20.23 31.96 23.78 13 $921.98 Contract Number Amount 92,300.47 Vendor 891 - METROPOLITAN TRANSIT AUTHORITY Totals Vendor 911 - MIDAMERICAN ENERGY 2020-00002362 UTILITIES - HANGAR 4, ACCT Edit #56560-12025 P.O. Number Item Description Conversion Item - UTILITIES - HANGAR 4, ACCT #56560-12025 G/L Account Quantity 1.0000 05/07/2020 U/M Amount/Unit EA 68.8100 Project Invoices 92,300.47 1 $92,300.47 05/26/2020 05/26/2020 68.81 Total Amount Vendor Catalog Part Number Contract Number 68.81 Amount Run by Emily Graham on 05/22/2020 02:50:29 PM Page 92 of 129 Page 43 of 80 Invoice Number 2020-00002362 P.O. Number Invoice Description Status UTILITIES - HANGAR 4, ACCT Edit #56560-12025 Item Description Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Held Reason Invoice Date 05/07/2020 Quantity U/M Amount/Unit 010-29-7700 1400 (General Fund -Airport Commission -Airport Administration Utility Service) Invoice Items 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 68.81 Total Amount Vendor Catalog Part Number Contract Number 68.81 2020-00002363 P.O. Number UTILITIES-19 AIRPORT Edit LOCATIONS; ACCT #19741- 28008 05/12/2020 05/26/2020 05/26/2020 5,709.81 Item Description Quantity U/M Amount/Unit Conversion Item - UTILITIES-19 AIRPORT 1.0000 EA 5,709.8100 LOCATIONS; ACCT #19741-28008 G/L Account 010-29-7700 1400 (General Fund -Airport Commission -Airport Administration Utility Service) Invoice Items Project 1 Total Amount Vendor Catalog Part Number Contract Number 5,709.81 Amount 5,709.81 2020-00002365 P.O. Number UTILITIES - GOLF, PARK Edit Item Description Quantity U/M Conversion Item - UTILITIES - GOLF, PARK 1.0000 EA G/L Account 010-37-4100 1400 (General Fund -Leisure Services -Leisure Services -Parks Utility Service) 010-37-4120 1400 (General Fund -Leisure Services -Golf Courses Utility Service) Invoice Items 05/15/2020 Amount/Unit 595.7000 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 595.70 Amount 72.30 523.40 399684479 P.O. Number 4/8-5/7 SERVICE AT 348 N ELK Edit RUN RD- WPD TRAINING CENTER Item Description Quantity U/M Amount/Unit Conversion Item - 4/8-5/7 SERVICE AT 348 N 1.0000 EA 179.1800 ELK RUN RD- WPD TRAINING CENTER G/L Account 010-11-1100 1400 (General Fund -Police Department -Police Operations Utility Service) Invoice Items 05/07/2020 Project 1 595.70 05/26/2020 05/26/2020 179.18 Total Amount Vendor Catalog Part Number Contract Number 179.18 Amount 179.18 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 93 of 129 Page 44 of 80 Invoice Number 399682595 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status APRIL UTILITIES; 113 E 8TH ST Edit Item Description Quantity U/M Conversion Item - APRIL UTILITIES; 113 E 1.0000 EA 8TH ST Held Reason Invoice Date 05/07/2020 Amount/Unit 3.9400 G/L Account 010-08-5885 1400 (General Fund -Planning & Zoning -City Property Management Utility Service) Invoice Items Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 3.94 Project Amount 08PRO.MTCE (SPECIAL PROJECTS, GENERAL CITY 3.94 PROPERTY MAINTENANCE) 1 39996261 P.O. Number APRIL/MAY UTILITIES; 225 Edit COMMERCIAL; CHARGING STATION 05/14/2020 05/26/2020 05/26/2020 Item Description Quantity U/M Amount/Unit Conversion Item - APRIL/MAY UTILITIES; 225 1.0000 EA 68.9700 COMMERCIAL; CHARGING STATION G/L Account 010-08-5885 1400 (General Fund -Planning & Zoning -City Property Management Utility Service) Invoice Items Total Amount Vendor Catalog Part Number 68.97 Project 08PRO.MTCE (SPECIAL PROJECTS, GENERAL CITY PROPERTY MAINTENANCE) 1 Contract Number Amount 68.97 399974121 P.O. Number APRIL/MAY UTILITIES; 321 W Edit 6TH ST Item Description Quantity U/M Amount/Unit Conversion Item - APRIL/MAY UTILITIES; 321 1.0000 EA 40.8500 W 6TH ST G/L Account 010-08-5885 1400 (General Fund -Planning & Zoning -City Property Management Utility Service) Invoice Items 05/14/2020 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number 40.85 Project 08PRO.MTCE (SPECIAL PROJECTS, GENERAL CITY PROPERTY MAINTENANCE) 1 Contract Number Amount 40.85 2020-00002366 P.O. Number TC 82231-04006 TRF LT Edit SUMMARY Item Description Quantity U/M Conversion Item - TC 82231-04006 TRF LT 1.0000 EA SUMMARY G/L Account 266-17-7161 1400 (Road Use Tax -Traffic Operations -Traffic Improvements Utility Service) 05/11/2020 05/26/2020 05/26/2020 Amount/Unit 4,375.8000 Invoice Items Project 1 Total Amount Vendor Catalog Part Number 4,375.80 Contract Number Amount 4,375.80 2020-00002367 P.O. Number 03791-34016 STREET LIGHTING Edit Item Description Conversion Item - 03791-34016 STREET LIGHTING G/L Account Quantity U/M 1.0000 EA 05/11/2020 Amount/Unit 460.3400 Project 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number 460.34 Contract Number Amount 3.94 68.97 40.85 4,375.80 460.34 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 94 of 129 Page 45 of 80 Invoice Number 2020-00002367 P.O. Number Invoice Description Status 03791-34016 STREET LIGHTING Edit Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Held Reason Invoice Date 05/11/2020 Item Description Quantity U/M Amount/Unit 266-17-7105 1400 (Road Use Tax -Traffic Operations -Street Lighting Utility Service) Invoice Items 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 460.34 399718126 P.O. Number 07030-18029 3260 LAFAYETTE Edit LIFT 431 Item Description Quantity Conversion Item - 07030-18029 3260 1.0000 LAFAYETTE LIFT 431 G/L Account 520-14-5200 1400 (Sanitary Sewer Fund -Waste Pollution -Water Pollution Control Plant Op Utility 05/08/2020 U/M Amount/Unit EA 10.0000 Management -Water Service) Invoice Items Project 1 460.34 05/26/2020 05/26/2020 10.00 Total Amount Vendor Catalog Part Number Contract Number 10.00 Amount 10.00 399949046 P.O. Number 03720-63005 80 W MULLAN AVE Edit PUMP Item Description Quantity Conversion Item - 03720-63005 80 W 1.0000 MULLAN AVE PUMP G/L Account 520-14-5200 1400 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Utility Service) Invoice Items 05/14/2020 U/M Amount/Unit EA 57.6800 Project 1 05/26/2020 05/26/2020 57.68 Total Amount Vendor Catalog Part Number Contract Number 57.68 Amount 57.68 399997529 P.O. Number 96190-18017 1314 BLACK HAWK Edit ST STORM BLDG Item Description Quantity Conversion Item - 96190-18017 1314 BLACK 1.0000 HAWK ST STORM BLDG G/L Account 520-14-5200 1400 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Utility Service) Invoice Items 05/14/2020 U/M Amount/Unit EA 125.5000 Project 1 05/26/2020 05/26/2020 125.50 Total Amount Vendor Catalog Part Number Contract Number 125.50 Amount 125.50 Vendor 911 - MIDAMERICAN ENERGY Totals Vendor 904 - MIDLAND SCIENTIFIC INC Invoices 12 $11,696.58 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 95 of 129 Page 46 of 80 Invoice Number 6064207 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status CREDIT RETURN Edit Item Description Quantity U/M Conversion Item - CREDIT RETURN 1.0000 EA G/L Account 520-14-5200 1551 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Drugs/Medicines & Medical/Lab Supplies) Held Reason Invoice Date 03/17/2020 Amount/Unit (425.7400) Project Invoice Items 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number (425.74) Amount (425.74) 6091505 P.O. Number RICCA DIMETHYLGLYOXIME Edit Item Description Conversion Item - RICCA DIMETHYLGLYOXIME G/L Account Quantity U/M 1.0000 EA 05/11/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 75.1700 75.17 Project 520-14-5200 1551 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Drugs/Medicines & Medical/Lab Supplies) Invoice Items 1 Contract Number Amount 75.17 6091586 P.O. Number SULFIDE, POTASSIUM Edit Item Description Quantity U/M Conversion Item - SULFIDE, POTASSIUM 1.0000 EA G/L Account 05/11/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 251.1600 251.16 Project 520-14-5200 1551 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Drugs/Medicines & Medical/Lab Supplies) Invoice Items 1 Contract Number Amount 251.16 6092110 P.O. Number AMMONIUM CHLORIDE Edit Item Description Quantity Conversion Item - AMMONIUM CHLORIDE 1.0000 G/L Account U/M EA 05/12/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 124.6800 124.68 Project 520-14-5200 1551 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Drugs/Medicines & Medical/Lab Supplies) Invoice Items 1 Contract Number Amount 124.68 Vendor 11769 - MIDWEST JANITORIAL SERVICE INC 214322 MAY JANITORIAL - CITY HALL Edit P.O. Number Vendor 904 - MIDLAND SCIENTIFIC INC Totals Item Description Conversion Item - MAY JANITORIAL - CITY HALL G/L Account Quantity U/M 1.0000 EA Invoices 05/12/2020 05/26/2020 05/26/2020 05/14/2020 Amount/Unit Total Amount Vendor Catalog Part Number 4,249.0000 4,249.00 Project (425.74) 75.17 251.16 124.68 4 $25.27 Contract Number Amount 4,249.00 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 96 of 129 Page 47 of 80 Invoice Number 214322 P.O. Number Invoice Description Status MAY JANITORIAL - CITY HALL Edit Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Held Reason Invoice Date 05/12/2020 Item Description Quantity U/M Amount/Unit 010-22-8800 1371 (General Fund -Building Inspection -Facilities Maintenance Building & Grounds Maintenance) Invoice Items 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 05/14/2020 4,249.00 Total Amount Vendor Catalog Part Number Contract Number 4,249.00 214323 P.O. Number MAY JANITORIAL - PD TRNG Edit CNTR 05/12/2020 05/26/2020 05/26/2020 05/14/2020 Item Description Quantity U/M Amount/Unit Conversion Item - MAY JANITORIAL - PD 1.0000 EA 285.0000 TRNG CNTR G/L Account 010-22-8800 1371 (General Fund -Building Inspection -Facilities Maintenance Building & Grounds Maintenance) Project Invoice Items 1 Total Amount Vendor Catalog Part Number Contract Number 285.00 Amount 285.00 214471 P.O. Number MAY JANITORIAL - W PARKING Edit RAMP Item Description Quantity U/M Amount/Unit Conversion Item - MAY JANITORIAL - W 1.0000 EA 150.0000 PARKING RAMP G/L Account 010-22-7930 1390 (General Fund -Building Inspection -Parking Operations Other Contractual Services) 05/12/2020 05/26/2020 05/26/2020 05/14/2020 Project Invoice Items 1 Total Amount Vendor Catalog Part Number Contract Number 150.00 Amount 150.00 214472 P.O. Number MAY JANITORIAL - VET MEM Edit HALL Item Description Quantity U/M Conversion Item - MAY JANITORIAL - VET 1.0000 EA MEM HALL 05/12/2020 05/26/2020 05/26/2020 05/14/2020 Amount/Unit Total Amount Vendor Catalog Part Number 207.0000 207.00 G/L Account Project 010-22-8850 1390 (General Fund -Building Inspection -Veterans Memorial Hall Other Contractual Services) Invoice Items 1 Contract Number Amount 207.00 214473 P.O. Number MAY JANITORIAL - CARNEGIE Edit Item Description Conversion Item - MAY JANITORIAL - CARNEGIE Quantity U/M 1.0000 EA 05/12/2020 05/26/2020 05/26/2020 05/14/2020 Amount/Unit Total Amount Vendor Catalog Part Number 837.0000 837.00 G/L Account 010-22-8800 1371 (General Fund -Building Inspection -Facilities Maintenance Building & Grounds Maintenance) Project Invoice Items 1 Contract Number Amount 837.00 285.00 150.00 207.00 837.00 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 97 of 129 Page 48 of 80 Invoice Number 214157 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason CLEAN & DISINFECT ALL AREAS Edit OF WPD Item Description Quantity U/M Conversion Item - CLEAN & DISINFECT ALL 1.0000 EA AREAS OF WPD G/L Account 010-11-1150 1319 (General Fund -Police Department -Police Grants Professional Services) Invoice Items Invoice Date Due Date G/L Date Received Date 04/29/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 1,980.0000 1,980.00 Project Other 11GRT.COVID20 (POLICE DEPARTMENT GRANTS AND PROJECTS, COVID19 RESPONSE PROJECT) 1 Payment Date Contract Number Amount 1,980.00 Invoice Net Amount 1,980.00 214325 P.O. Number MAY JANITORIAL Edit 05/12/2020 05/26/2020 05/26/2020 Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Conversion Item - MAY JANITORIAL 1.0000 EA 1,426.0000 1,426.00 G/L Account Project 520-14-5200 1371 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Building & Grounds Maintenance) Invoice Items 1 Contract Number Amount 1,426.00 Vendor 2274 - MIDWEST TAPE 98852437 DVD P.O. Number Vendor 11769 - MIDWEST JANITORIAL SERVICE INC Totals Edit Item Description Quantity U/M Conversion Item - DVD 1.0000 EA G/L Account 010-33-3150 1597 (General Fund -Library -Library Access Plus DVD's) Invoice Items Invoices 05/04/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 23.6900 23.69 Project 1 1,426.00 7 $9,134.00 Contract Number Amount 23.69 98852438 P.O. Number BOOK ON CD Item Description Conversion Item - BOOK ON CD G/L Account 010-33-3100 1595 Edit Quantity U/M 1.0000 EA 05/04/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 79.9800 79.98 Project (General Fund -Library -Library Services CD's) Invoice Items 1 Contract Number Amount 79.98 98872703 P.O. Number BOOK ON CD Item Description Conversion Item - BOOK ON CD G/L Account 010-33-3100 1595 Edit Quantity U/M 1.0000 EA 05/06/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 40.9400 40.94 Project (General Fund -Library -Library Services CD's) Invoice Items 1 Contract Number Amount 40.94 23.69 79.98 40.94 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 98 of 129 Page 49 of 80 Invoice Number 98872705 P.O. Number Invoice Description Status DVDS Edit Item Description Conversion Item - DVDS G/L Account 010-33-3190 1 Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Held Reason Quantity U/M 1.0000 EA Invoice Date 05/06/2020 Amount/Unit 385.2500 Project 597 (General Fund -Library -Iowa Library Services DVD's) Invoice Items 1 Due Date G/L Date Received Date Payment Date 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 385.25 Amount 385.25 Invoice Net Amount 385.25 98872706 P.O. Number BLURAY Edit Item Description Quantity U/M Conversion Item - BLURAY 1.0000 EA G/L Account 010-33-3150 1597 (General Fund -Library -Library Access Plus DVD's) Invoice Items 05/06/2020 Amount/Unit 37.8400 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 37.84 Amount 37.84 98872707 P.O. Number DVD Edit Item Description Quantity U/M Conversion Item - DVD 1.0000 EA G/L Account 010-33-3150 1597 (General Fund -Library -Library Access Plus DVD's) Invoice Items 05/06/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 56.5800 56.58 Project 1 Contract Number Amount 56.58 98872708 P.O. Number DVD Edit Item Description Quantity U/M Conversion Item - DVD 1.0000 EA G/L Account 010-33-3150 1597 (General Fund -Library -Library Access Plus DVD's) Invoice Items 05/06/2020 Amount/Unit 58.0800 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 58.08 Amount 58.08 98872709 P.O. Number DVDS Edit Item Description Quantity U/M Conversion Item - DVDS 1.0000 EA G/L Account 010-33-3150 1597 (General Fund -Library -Library Access Plus DVD's) Invoice Items 05/06/2020 Amount/Unit 168.3900 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 168.39 Amount 168.39 98872710 P.O. Number DVDS Edit Item Description Quantity U/M Conversion Item - DVDS 1.0000 EA G/L Account 010-33-3190 1597 (General Fund -Library -Iowa Library Services DVD's) Invoice Items 05/06/2020 Amount/Unit 56.5800 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 56.58 Amount 56.58 37.84 56.58 58.08 168.39 56.58 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 99 of 129 Page 50 of 80 Invoice Number 98872711 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason DVD Edit Item Description Quantity U/M Conversion Item - DVD 1.0000 EA G/L Account 010-33-3190 1597 (General Fund -Library -Iowa Library Services DVD's) Invoice Items Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/06/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 39.0400 39.04 Project Amount 39.04 1 98872712 P.O. Number DVD Edit Item Description Quantity U/M Conversion Item - DVD 1.0000 EA G/L Account 010-33-3190 1597 (General Fund -Library -Iowa Library Services DVD's) Invoice Items Amount/Unit 28.4400 Project 1 05/06/2020 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 28.44 Amount 28.44 98872713 P.O. Number DVDS Item Description Conversion Item - DVDS G/L Account Edit 39.04 28.44 05/06/2020 05/26/2020 05/26/2020 150.81 Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 1.0000 EA 150.8100 150.81 Project 010-33-3190 1597 (General Fund -Library -Iowa Library Services DVD's) Invoice Items 1 Amount 150.81 98872714 P.O. Number DVDS Edit Item Description Quantity U/M Conversion Item - DVDS 1.0000 EA G/L Account 010-33-3190 1597 (General Fund -Library -Iowa Library Services DVD's) Invoice Items 05/06/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 90.4300 90.43 Project Amount 1 90.43 98872715 P.O. Number DVD Edit Item Description Quantity U/M Conversion Item - DVD 1.0000 EA G/L Account 010-33-3190 1597 (General Fund -Library -Iowa Library Services DVD's) Invoice Items 05/06/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 20.2900 20.29 Project Amount 1 20.29 98872716 P.O. Number DVDS Edit Item Description Quantity U/M Conversion Item - DVDS 1.0000 EA G/L Account 010-33-3190 1597 (General Fund -Library -Iowa Library Services DVD's) Invoice Items 05/06/2020 Amount/Unit 89.4700 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 89.47 Amount 89.47 90.43 20.29 89.47 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 100 of 129 Page 51 of 80 Invoice Number 98872717 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason DVDS Edit Item Description Quantity Conversion Item - DVDS 1.0000 G/L Account 010-33-3190 1597 (General Fund -Library -Iowa Library Services DVD's) Invoice Items U/M EA Invoice Date Due Date G/L Date Received Date Payment Date 05/06/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 207.6600 207.66 Project Amount 1 207.66 Invoice Net Amount 207.66 98872718 P.O. Number DVDS Item Description Conversion Item - DVDS G/L Account Edit Quantity U/M 1.0000 EA 05/06/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 150.2100 150.21 Project 010-33-3190 1597 (General Fund -Library -Iowa Library Services DVD's) Invoice Items 1 Contract Number Amount 150.21 Vendor 912 - MIDWEST WHEEL CO. 1952204-00 SEAT SAVER P.O. Number Item Description Conversion Item - SEAT SAVER G/L Account Edit Vendor 2274 - MIDWEST TAPE Totals Quantity U/M 1.0000 EA Invoices 04/30/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 194.5200 194.52 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 150.21 17 $1,683.68 Contract Number Amount 194.52 Vendor 5690 - MOTION INDUSTRIES IA02-265763 LATEX DISPOSABLE INDUSTRIAL Edit GRADE Vendor 912 - MIDWEST WHEEL CO. Totals Invoices 04/22/2020 05/26/2020 05/26/2020 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - LATEX DISPOSABLE 1.0000 EA 98.2400 INDUSTRIAL GRADE G/L Account 520-14-5200 1551 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Drugs/Medicines & Medical/Lab Supplies) Project Invoice Items 1 Total Amount Vendor Catalog Part Number 98.24 194.52 1 $194.52 Contract Number Amount 98.24 IA02-266225 LATEX DISPOSABLE CREDIT Edit P.O. Number Item Description Conversion Item - LATEX DISPOSABLE CREDIT G/L Account Quantity 1.0000 U/M EA 05/12/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number (63.7800) (63.78) Project Contract Number Amount 98.24 (63.78) Run by Emily Graham on 05/22/2020 02:50:29 PM Page 101 of 129 Page 52 of 80 Invoice Number IA02-266225 P.O. Number Invoice Description Status LATEX DISPOSABLE CREDIT Edit Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Held Reason Invoice Date 05/12/2020 Item Description Quantity U/M Amount/Unit 520-14-5200 1551 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Drugs/Medicines & Medical/Lab Supplies) Invoice Items 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 (63.78) Total Amount Vendor Catalog Part Number Contract Number (63.78) Vendor 5690 - MOTION INDUSTRIES Totals Vendor 958 - MUNICIPAL PIPE TOOL CO., LLC 05082020 CONT 962 PAY EST #5, FY2019 Edit 05/0 CIP PIPELINING PHASE IIIC P.O. Number Item Description Quantity U/M Amount/Un Item - CONT 962 PAY EST #5, 1.0000 EA 31,369.00 FY2019 CIP PIPELINING PHASE IIIC G/L Account 520-14-5320 2163 (Sanitary Sewer Fund -Waste Management -Water Pollution -Sewer Coll Sytem Improvements Sanitary Sewers) Invoice Items Invoices 8/2020 05/26/2020 05/26/2020 nit Total Amount Vendor Catalog Part Number 00 31,369.00 2 $34.46 Project 14SRF.CIPP3 (STATE REVOLVING LOAN FUND, CURED IN PLACE PIPE LINING PHASE 3) 1 Contract Number Amount 31,369.00 Vendor 1370500 P.O. Number Vendor 958 - MUNICIPAL PIPE TOOL CO., LLC Totals 7808 - MURPHY TRACTOR & EQUIPMENT PARTS FOR 194B02 Item Description Conversion Item - PARTS FOR 194B02 G/L Account Edit Quantity U/M 1.0000 EA Invoices 04/30/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 247.2500 247.25 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 31,369.00 1 $31,369.00 Contract Number Amount 247.25 1370738 PIN FASTENERS Edit 04/30/2020 05/26/2020 05/26/2020 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Conversion Item - PIN FASTENERS 1.0000 EA 491.1800 491.18 G/L Account Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 Contract Number Amount 491.18 247.25 491.18 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 102 of 129 Page 53 of 80 Invoice Number 1371509 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status PARTS FOR 194B02 Edit Item Description Quantity U/M Conversion Item - PARTS FOR 194B02 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items Held Reason Invoice Date 05/01/2020 Amount/Unit 538.8100 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 538.81 Amount 538.81 1372448 P.O. Number ORIFICE/PIN Item Description Conversion Item - ORIFICE/PIN G/L Account Edit Quantity U/M 1.0000 EA 05/04/2020 Amount/Unit 284.6500 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 284.65 Amount 284.65 1373768 P.O. Number PARTS FOR 194E Item Description Conversion Item - PARTS FOR 194E G/L Account Edit Quantity U/M 1.0000 EA 05/05/2020 Amount/Unit 295.4500 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 295.45 Amount 295.45 1373770 P.O. Number CONTROL VALVE/O-RING Edit Item Description Conversion Item - CONTROL VALVE/O-RING G/L Account Quantity U/M 1.0000 EA 05/05/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 61.1800 61.18 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 Contract Number Amount 61.18 1373775 P.O. Number HYDRAULIC CYLINDER ROD Edit Item Description Conversion Item - HYDRAULIC CYLINDER ROD G/L Account Quantity U/M 1.0000 EA 05/05/2020 Amount/Unit 667.3200 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 667.32 Amount 667.32 1375517 P.O. Number 0-RING/SEALS Item Description Conversion Item - 0-RING/SEALS G/L Account Edit Quantity U/M 1.0000 EA 05/07/2020 Amount/Unit 226.5500 Project 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 226.55 Amount 538.81 284.65 295.45 61.18 667.32 226.55 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 103 of 129 Page 54 of 80 Invoice Number 1375517 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason 0-RING/SEALS Edit Item Description Quantity U/M Amount/Unit 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items Invoice Date 05/07/2020 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 226.55 1377128 P.O. Number SEAL Edit Item Description Quantity U/M Conversion Item - SEAL 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 05/11/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 61.7400 61.74 Project 1 Contract Number Amount 61.74 1377291 P.O. Number V-BELT Edit Item Description QL—"tv U/M Conversion Item - V-BELT 1.0000 EA G/L Account 010-18-7955 1571 Service Machinery & Equipment Replacement Parts) 05/11/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 223.0200 223.02 Project (General Fund -Central Garage -Garage -Motor Pool Invoice Items 1 Contract Number Amount 223.02 Vendor 961 - MUTUAL WHEEL COMPANY 5531558 STOCK PARTS P.O. Number Vendor 7808 - MURPHY TRACTOR & EQUIPMENT Totals Invoices Edit 04/30/2020 05/26/2020 05/26/2020 Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Conversion Item - STOCK PARTS 1.0000 EA 709.9500 709.95 G/L Account Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 226.55 61.74 223.02 10 $3,097.15 Contract Number Amount 709.95 5532361 P.O. Number CLIP/VALVES Edit Item Description Quantity U/M Conversion Item - CLIP/VALVES 1.0000 EA G/L Account 010-18-7955 1571 Service Machinery & Equipment Replacement Parts) 05/06/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 131.3600 131.36 Project (General Fund -Central Garage -Garage -Motor Pool Invoice Items 1 Contract Number Amount 131.36 709.95 131.36 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 104 of 129 Page 55 of 80 Invoice Number 5532533 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status ALCOHOL EVAP Edit Item Description Quantity U/M Conversion Item - ALCOHOL EVAP 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items Held Reason Invoice Date 05/06/2020 Amount/Unit 109.5600 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 109.56 Amount 109.56 5532597 P.O. Number PARTS FOR 193B06 Edit Item Description Quantity U/M Conversion Item - PARTS FOR 193B06 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 05/06/2020 Amount/Unit 545.7000 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 545.70 Amount 545.70 5532846 P.O. Number TP3DC VLV Item Description Conversion Item - TP3DC VLV G/L Account Edit Quantity U/M 1.0000 EA 05/07/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 134.8400 134.84 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 Contract Number Amount 134.84 Vendor 966 - NAPA AUTO PARTS 224788 FILTERS P.O. Number Item Description Conversion Item - FILTERS G/L Account Edit Vendor 961 - MUTUAL WHEEL COMPANY Totals Quantity U/M 1.0000 EA Invoices 04/29/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 88.9400 88.94 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 109.56 545.70 134.84 5 $1,631.41 Contract Number Amount 88.94 225646 P.O. Number AIR FILTER Item Description Conversion Item - AIR FILTER G/L Account Edit Quantity U/M 1.0000 EA 05/07/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 82.4000 82.40 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 Contract Number Amount 82.40 88.94 82.40 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 105 of 129 Page 56 of 80 Invoice Number 225866 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status AIR FILTER Edit Item Description Quantity U/M Conversion Item - AIR FILTER 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items Held Reason Invoice Date 05/11/2020 Amount/Unit 50.5000 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 50.50 Amount 50.50 226206 P.O. Number AIR FILTERS Edit Item Description Quantity U/M Conversion Item - AIR FILTERS 1.0000 EA G/L Account 010-37-4100 1569 (General Fund -Leisure Services -Leisure Services -Parks Vehicle Replacement Parts) Invoice Items 05/14/2020 Amount/Unit 99.8100 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 99.81 Amount 99.81 226233 P.O. Number CAP #7531 Item Description Conversion Item - CAP #7531 G/L Account Edit Quantity U/M 1.0000 EA 05/14/2020 Amount/Unit 8.6200 Project 010-37-4120 1569 (General Fund -Leisure Services -Golf Courses Vehicle Replacement Parts) Invoice Items 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 8.62 Amount 8.62 Vendor 20466 - BENJAMIN NEIL FY2OSHOE FY20 BOOT ALLOWANCE P.O. Number Vendor 966 - NAPA AUTO PARTS Totals Invoices Edit 05/16/2020 05/26/2020 05/26/2020 Item Description Quantity U/M Amount/Unit Conversion Item - FY20 BOOT ALLOWANCE 1.0000 EA 150.0000 G/L Account 266-07-7830 1573 (Road Use Tax -City Engineer -City Engineer Safety & Protective Equipment) Project Invoice Items 1 Total Amount Vendor Catalog Part Number 150.00 50.50 99.81 8.62 5 $330.27 Contract Number Amount 150.00 Vendor 20110 - NORTHERN SAFETY TECHNOLOGY INC 50298 LIGHTS Edit P.O. Number Item Description Conversion Item - LIGHTS G/L Account Vendor 20466 - BENJAMIN NEIL Totals Quantity U/M 1.0000 EA Invoices 04/27/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 117.3400 117.34 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 150.00 1 $150.00 Contract Number Amount 117.34 117.34 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 106 of 129 Page 57 of 80 Invoice Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason Invoice Date Vendor 20110 - NORTHERN SAFETY TECHNOLOGY INC Totals Vendor 1008 - NORTHLAND PRODUCTS COMPANY INVNP0028676 TALAMAR Edit P.O. Number Item Description Conversion Item - TALAMAR G/L Account 010-18-7955 1547 (General Fund -Central Garage -Garage -Motor Pool Service Oils & Greases) Quantity U/M 1.0000 EA Due Date G/L Date Received Date Payment Date Invoices 1 Invoice Net Amount 04/30/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 958.5000 958.50 Project Amount 958.50 Invoice Items 1 INVNP0030257 BOX PLASTIC HOLDERS Edit P.O. Number Item Description Conversion Item - BOX PLASTIC HOLDERS G/L Account Quantity 1.0000 U/M EA 05/08/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 29.0000 29.00 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 Contract Number Amount 29.00 INVNP0029800 OIL P.O. Number Item Description Conversion Item - OIL G/L Account Edit Quantity U/M 1.0000 EA 05/06/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 118.5000 118.50 Project 010-37-4120 1547 (General Fund -Leisure Services -Golf Courses Oils & Greases) Invoice Items 1 Contract Number Amount 118.50 Vendor 1008 - NORTHLAND PRODUCTS COMPANY Totals Invoices Vendor 1012 - NUTRI JECT SYSTEMS, INC 7250 BIOSOLIDS TRANSPORTED 5/1- Edit 05/15/2020 05/26/2020 05/26/2020 5/15 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Conversion Item BIOSOLIDS TRANSPORTED 1.0000 EA 11,587.7700 11,587.77 5/1-5/15 G/L Account 520-14-5200 1341 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Contract Carriers) Invoice Items Project 1 $117.34 958.50 29.00 118.50 3 $1,106.00 Contract Number Amount 11,587.77 Vendor 1012 - NUTRI JECT SYSTEMS, INC Totals Vendor 21266 - ONE SOURCE Invoices 11,587.77 1 $11,587.77 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 107 of 129 Page 58 of 80 Invoice Number 4281-202000430 P.O. Number Invoice Description HR EMPLOYMENT BACKGROUND CHECKS Item Description Conversion Item - BACKGROUND C WPD JFITZGERALD G/L Account 010-09-8250 1319 (G Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Status Held Reason Edit Quantity HECK FOR 1.0000 eneral Fund -Human Resources -Human Resources Invoice Date 04/21/2020 U/M Amount/Unit EA 142.4900 Other Professional Services) Conversion Item - CREDIT FOR HOSFORD 1.0000 EA (16.0000) BACKGRD CHECK G/L Account 520-14-5200 1313 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Legal Services) Invoice Items Project Project 2 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 05/12/2020 126.49 Total Amount Vendor Catalog Part Number Contract Number 142.49 (16.00) INV 428120200229 & 4281- 20200331 Amount 142.49 Amount (16.00) Vendor 21266 - ONE SOURCE Totals Vendor 13314 - OVERDRIVE INC 02863DA20127508 E-BOOK Edit P.O. Number Item Description Quantity U/M Conversion Item - E-BOOK 1.0000 EA G/L Account 010-33-3100 1583 (General Fund -Library -Library Services Downloadable Materials) Invoices 05/02/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 24.9900 24.99 Project Invoice Items 1 1 $126.49 Contract Number Amount 24.99 02863DA20129665 P.O. Number E-BOOKS Item Description Conversion Item - E-BOOKS Edit Quantity 1.0000 U/M EA 05/04/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 157.5000 157.50 G/L Account Project 010-33-3100 1583 (General Fund -Library -Library Services Downloadable Materials) Invoice Items 1 Contract Number Amount 157.50 02863DA20132902 P.O. Number E-BOOKS Edit Item Description Quantity U/M Conversion Item - E-BOOKS 1.0000 EA G/L Account 010-33-3100 1583 (General Fund -Library -Library Services Downloadable Materials) 05/05/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 127.9400 127.94 Project Invoice Items 1 Contract Number Amount 127.94 24.99 157.50 127.94 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 108 of 129 Page 59 of 80 Invoice Number 02863DA20140765 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason E-BOOK Edit Item Description Quantity U/M Conversion Item - E-BOOK 1.0000 EA G/L Account 010-33-3100 1583 (General Fund -Library -Library Services Downloadable Materials) Invoice Items 1 Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/12/2020 05/26/2020 05/26/2020 76.00 Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 76.0000 76.00 Project Amount 76.00 02863DA20140894 P.O. Number E-BOOKS Edit Item Description Quantity U/M Conversion Item - E-BOOKS 1.0000 EA G/L Account Project 010-33-3100 1583 (General Fund -Library -Library Services Downloadable Materials) 05/12/2020 Amount/Unit 103.9300 Invoice Items 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number 103.93 Contract Number Amount 103.93 Vendor 1028 - OVERHEAD DOOR CO. OF WATERLOO 23282 LABOR - EAST SIDE NORTH Edit DOOR - PW P.O. Number Item Description Conversion Item - LABOR - EAST SIDE NORTH DOOR - PW Vendor 13314 - OVERDRIVE INC Totals 05/11/2020 Invoices 05/26/2020 05/26/2020 Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number 1.0000 EA 140.5000 140.50 G/L Account 266-19-7100 1371 (Road Use Tax -Street Department -Street Maintenance Building & Grounds Maintenance) Project Invoice Items 1 103.93 5 $490.36 Contract Number Amount 140.50 Vendor 20359 - P & K MIDWEST INC 3654443 0-RING P.O. Number Vendor 1028 - OVERHEAD DOOR CO. OF WATERLOO Totals Edit Item Description Quantity U/M Conversion Item - 0-RING 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 04/30/2020 Amount/Unit .8400 Project 1 Invoices 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number .84 140.50 1 $140.50 Contract Number Amount .84 3675180 P.O. Number PUSH PULL CABLE Item Description Conversion Item - PUSH PULL CABLE G/L Account Edit Quantity U/M 1.0000 EA 05/12/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 34.6000 34.60 Project Contract Number Amount .84 34.60 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 109 of 129 Page 60 of 80 Invoice Number 3675180 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason Invoice Date PUSH PULL CABLE Edit 05/12/2020 Item Description Quantity U/M Amount/Unit 010-37-4110 1569 (General Fund -Leisure Services -Downtown Area Maintenance Vehicle Replacement Parts) Invoice Items 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 34.60 Total Amount Vendor Catalog Part Number Contract Number 34.60 Vendor 7803 - PER MAR SECURITY SERVICES 499410 WK ENDING 5/9 P.O. Number Vendor 20359 - P & K MIDWEST INC Totals Edit Item Description Quantity U/M Conversion Item - WK ENDING 5/9 G/L Account 520-14-5200 1319 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Other Professional Services) Invoice Items Invoices 2 $35.44 05/09/2020 05/26/2020 05/26/2020 1,703.88 Amount/Unit Total Amount 1.0000 EA 1,703.8800 Project 1 1,703.88 Vendor Catalog Part Number Contract Number Amount 1,703.88 Vendor 7803 - PER MAR SECURITY SERVICES Totals Vendor 1132 - PETERSON CONTRACTORS, INC 934-22 CONT 934 RECON UNIVERSITY Edit AVE P.O. Number Item Description Conversion Item - CONT 934 RECON UNIVERSITY AVE G/L Account 266-07-7500 2165 (Road Use Tax -City Engineer -Street Construction Streets & Roadways) Invoices 1 05/17/2020 05/26/2020 05/26/2020 Quantity U/M Amount/Unit 1.0000 EA 296,104.0800 426-07-7650 2164 (Capital Improvements Fund -City Engineer -Sidewalk Repair/Construction Sidewalks) 520-14-5200 2163 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Sanitary Sewers) 266-07-7500 2165 (Road Use Tax -City Engineer -Street Construction Streets & Roadways) 266-07-7500 2165 (Road Use Tax -City Engineer -Street Construction Streets & Roadways) Invoice Items Total Amount Vendor Catalog Part Number 296,104.08 Contract Number Project Amount 07UNIV.PH2 (RECON UNIVERSITY AVE MIDWAY DR 190,545.07 TO US63, UNIVERSITY AVE RECONSTRUCTION PHASE 2) 07UNIV.GAME (RECON UNIVERSITY AVE MIDWAY DR 8,218.21 TO US63, UNIVERSITY AVE RECONSTRUCION) 07UNIV.SWR (RECON UNIVERSITY AVE MIDWAY DR 2,660.00 TO US63, UNIVERSITY AVE SEWER) 07UNIV.CF (RECON UNIVERSITY AVE MIDWAY DR TO 1,140.00 US63, CONT 934 CEDAR FALLS PORTION UNIVERSITY) 07UNIV.934W (RECON UNIVERSITY AVE MIDWAY DR 93,540.80 TO US63, 934 RECONSTRUCTION OF UNIVERSITY AVE) 1 $1,703.88 296,104.08 Vendor 1132 - PETERSON CONTRACTORS, INC Totals Vendor 12259 - PLATINUM PEST SERVICES Invoices 1 $296,104.08 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 110 of 129 Page 61 of 80 Invoice Number 30721 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason Invoice Date Due Date BAIT STATIONS Edit Item Description Quantity U/M Conversion Item - BAIT STATIONS 1.0000 EA G/L Account 525-15-5400 1371 (Sanitation Fund -Waste Management -Sanitation -Solid Waste Disposal Building & Grounds Maintenance) Invoice Items 05/12/2020 05/26/2020 Amount/Unit Total Amount 50.0000 50.00 Project 1 G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 50.00 Vendor Catalog Part Number Contract Number Amount 50.00 Vendor 10726 - PRIMARY SYSTEMS 6-0473 RT - AFTER HOURS DIALER Edit P.O. Number Vendor 12259 - PLATINUM PEST SERVICES Totals Item Description Conversion Item - RT - AFTER HOURS DIALER G/L Account Quantity U/M 1.0000 EA Invoices 05/15/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 195.0000 195.00 Project 283-13-5450 1371 (Housing Programs -Housing Authority -Ridgeway Towers Building & Grounds Maintenance) Invoice Items 1 1 $50.00 Contract Number Amount 195.00 Vendor 11144 - PRO LINE AUDIO INC. 3701 SPRAY ON BEDLINER P.O. Number Edit Item Description Conversion Item - SPRAY ON BEDLINER G/L Account Vendor 10726 - PRIMARY SYSTEMS Totals Quantity U/M 1.0000 EA Invoices 05/07/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 150.0000 150.00 Project 010-18-1405 1571 (General Fund -Central Garage -Fire -Garage Parts & Service Machinery & Equipment Replacement Parts) Invoice Items 1 195.00 1 $195.00 Contract Number Amount 150.00 Vendor 6981 - QUILL CORPORATION 4956671 TONER INK, LABEL MAKER, MISC Edit OFFICE SUPPLIES Vendor 11144 - PRO LINE AUDIO INC. Totals Invoices 02/21/2020 05/26/2020 05/26/2020 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - TONER INK, LABEL MAKER, 1.0000 EA 470.9600 MISC OFFICE SUPPLIES G/L Account 525-15-5125 1561 (Sanitation Fund -Waste Management -Sanitation -Code Enforcement Office Supplies & Minor Equipment) Invoice Items Project 1 Total Amount Vendor Catalog Part Number 470.96 150.00 1 $150.00 Contract Number Amount 470.96 470.96 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 111 of 129 Page 62 of 80 Invoice Number 6720301 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount TONER INK Edit 05/06/2020 05/26/2020 05/26/2020 147.59 Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item - TONER INK 1.0000 EA 147.5900 147.59 G/L Account Project Amount 525-15-5125 1561 (Sanitation Fund -Waste Management -Sanitation -Code Enforcement Office Supplies & Minor Equipment) Invoice Items 1 147.59 6739895 MISC OFFICE SUPPLIES Edit 05/06/2020 05/26/2020 05/26/2020 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item - MISC OFFICE SUPPLIES 1.0000 EA 517.1100 517.11 G/L Account Project Amount 525-15-5125 1561 (Sanitation Fund -Waste Management -Sanitation -Code Enforcement Office Supplies & Minor Equipment) Invoice Items 1 517.11 6741833 INK CARTRIDGES Edit 05/06/2020 05/26/2020 05/26/2020 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item - INK CARTRIDGES 1.0000 EA 146.6500 146.65 G/L Account Project Amount 525-15-5125 1561 (Sanitation Fund -Waste Management -Sanitation -Code Enforcement Office Supplies & Minor Equipment) Invoice Items 1 146.65 517.11 146.65 6841694 COMPUTER CHAIR REPLACEMENT Edit 05/11/2020 05/26/2020 05/26/2020 326.99 - CAMERON P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item - COMPUTER CHAIR 1.0000 EA 326.9900 326.99 REPLACEMENT-CAMERON G/L Account Project Amount 525-15-5125 1376 (Sanitation Fund -Waste Management -Sanitation -Code 326.99 Enforcement Office Equipment Repair & Maintenance) Invoice Items 1 Vendor 6981 - QUILL CORPORATION Totals Invoices 5 $1,609.30 Vendor 1178 - RACOM AB155235 REPLACEMENT BATTERY Edit 05/14/2020 05/26/2020 05/26/2020 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item - REPLACEMENT BATTERY 1.0000 EA 85.0000 85.00 G/L Account Project Amount 010-11-1100 1377 (General Fund -Police Department -Police Operations 85.00 Radio Equipment Repair & Maintenance) Invoice Items 1 85.00 Vendor 1178 - RACOM Totals Invoices 1 $85.00 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 112 of 129 Page 63 of 80 Invoice Number Vendor 8210 - RC 97143 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason Invoice Date Due Date SYSTEMS T1803 LOGIC BOARD,M Edit 04/28/2020 CONTACTOR BOARD Item Description Quantity U/M Amount/Unit Conversion Item - T1803 LOGIC BOARD,M 1.0000 EA 1,189.1300 CONTACTOR BOARD G/L Account Project 266-17-7120 1377 (Road Use Tax -Traffic Operations -Traffic Safety Radio Equipment Repair & Maintenance) Invoice Items 1 G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 1,189.13 Total Amount Vendor Catalog Part Number Contract Number 1,189.13 Amount 1,189.13 Vendor 1060 - REGIONS BANK 05132020 P.O. Number Vendor 8210 - RC SYSTEMS Totals April Analysis Fees Edit 05/25/2020 Item Description Quantity U/M Amount/Unit Conversion Item 1.0000 EA 12.8400 G/L Account Project 416-03-8980 1503 (June 2016 GO Bond Fund -City Clerk & Finance - Fiduciary Transactions Bank Fees) Conversion Item 1.0000 EA 2.8800 G/L Account Project 417-03-8980 1503 (June 2017 GO Bond Fund -City Clerk & Finance - Fiduciary Transactions Bank Fees) Conversion Item 1.0000 EA G/L Account 418-03-8980 1503 (June 2018 GO Bond Fund -City Clerk & Finance - Fiduciary Transactions Bank Fees) Item 1.0000 EA G/L Account 520-14-5200 1503 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Bank Fees) Item 1.0000 EA 11.9800 G/L Account 521-07-7830 1503 (Storm Water Fund -City Engineer -City Engineer Bank Fees) Item 1.0000 EA G/L Account 13.2000 Project Conversion 35.9100 Project Conversion Conversion 28.2300 Project 520-14-5200 1503 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Bank Fees) Invoice Items Project 6 Invoices 1 $1,189.13 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 12.84 2.88 13.20 35.91 11.98 28.23 Amount 12.84 Amount 2.88 Amount 13.20 Amount 35.91 Amount 11.98 Amount 28.23 105.04 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 113 of 129 Page 64 of 80 Invoice Number 2020-00002356 P.O. Number Invoice Description Status April Credit Card Fees Edit Item Description Conversion Item G/L Account Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Held Reason Quantity U/M 1.0000 EA Invoice Date 05/25/2020 Amount/Unit 26.0400 Project Conversion 72.8600 Project Conversion 72.8500 Project 010-29-7700 1504 (General Fund -Airport Commission -Airport Administration Credit Card Fees) Item 1.0000 EA G/L Account 010-26-4250 1504 (General Fund-Cultural/Arts Commission -Center for the Arts Credit Card Fees) Item 1.0000 EA G/L Account 010-26-4208 1504 (General Fund-Cultural/Arts Commission -Youth Pavilion Credit Card Fees) Invoice Items 3 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 26.04 72.86 72.85 Amount 26.04 Amount 72.86 Amount 72.85 Vendor 20938 - REPUBLIC PARKING SYSTEM INC 2020-00002374 APRIL PAYROLL EXPENSES Edit P.O. Number Item Description Conversion Item - APRIL PAYROLL EXPENSES Vendor 1060 - REGIONS BANK Totals Quantity U/M 1.0000 EA 04/30/2020 Amount/Unit 20,933.1700 G/L Account Project 010-22-7930 1390 (General Fund -Building Inspection -Parking Operations Other Contractual Services) Invoice Items 1 Invoices 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number 20,933.17 171.75 2 $276.79 Contract Number Amount 20,933.17 2020-00002375 P.O. Number APRIL OPERATING EXPENSES Edit Item Description Conversion Item - APRIL OPERATING EXPENSES G/L Account 010-22-7930 1310 (General Fund -Building Professional Services) Conversion Item - APRIL OPERATING 1.00 EXPENSES G/L Account 010-22-7930 1321 (General Fund -Building Data Processing Services) Conversion Item - APRIL OPERATING 1.00 EXPENSES Quantity 1.0000 U/M EA 04/30/2020 Amount/Unit 3,538.6800 Inspection -Parking Operations 00 EA 350.0000 Inspection -Parking Operations 00 EA 35.8700 Project Project G/L Account Project 010-22-7930 1343 (General Fund -Building Inspection -Parking Operations Postage & Mailing Expense) 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number 3,538.68 350.00 35.87 Contract Number Amount 3,538.68 Amount 350.00 Amount 35.87 20,933.17 7,976.58 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 114 of 129 Page 65 of 80 Invoice Number 2020-00002375 P.O. Number Invoice Description Status APRIL OPERATING EXPENSES Edit Item Description Conversion Item - APRIL OPERATING EXPENSES Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Quantity 1.0000 Held Reason U/M EA Invoice Date 04/30/2020 Amount/Unit 128.1300 G/L Account 010-22-7930 1344 (General Fund -Building Inspection -Parking Operations Telephone & Fax Expense) Conversion Item - APRIL OPERATING 1.0000 EA 1,823.6500 EXPENSES G/L Account 010-22-7930 1361 (General Fund -Building Inspection -Parking Operations Real Property Insurance) Conversion Item - APRIL OPERATING 1.0000 EA 583.3300 EXPENSES G/L Account 010-22-7930 1362 (General Fund -Building Inspection -Parking Operations Vehicle Insurance) Conversion Item - APRIL OPERATING 1.0000 EA 215.9700 EXPENSES Project Project Project G/L Account Project 010-22-7930 1364 (General Fund -Building Inspection -Parking Operations Tort Liability Insurance) Conversion Item - APRIL OPERATING 1.0000 EA 121.4800 EXPENSES G/L Account 010-22-7930 1389 (General Fund -Building Inspection -Parking Operations Landfill Fees) Conversion Item - APRIL OPERATING 1.0000 EA 776.7900 EXPENSES G/L Account 010-22-7930 1520 (General Fund -Building Inspection -Parking Operations Computer Software) Conversion Item - APRIL OPERATING 1.0000 EA 379.9600 EXPENSES G/L Account 010-22-7930 1555 (General Fund -Building Inspection -Parking Operations Minor Equipment & Supplies) Conversion Item - APRIL OPERATING 1.0000 EA 15.2400 EXPENSES G/L Account 010-22-7930 1569 (General Fund -Building Inspection -Parking Operations Vehicle Replacement Parts) Project Project Project Project Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 128.13 1,823.65 583.33 215.97 121.48 776.79 379.96 15.24 Amount 128.13 Amount 1,823.65 Amount 583.33 Amount 215.97 Amount 121.48 Amount 776.79 Amount 379.96 Amount 15.24 7,976.58 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 115 of 129 Page 66 of 80 Invoice Number 2020-00002375 P.O. Number Invoice Description Status APRIL OPERATING EXPENSES Edit Item Description Conversion Item - APRIL OPERATING EXPENSES Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Quantity 1.0000 Held Reason U/M EA Invoice Date 04/30/2020 Amount/Unit 7.4800 G/L Account Project 010-22-7930 1561 (General Fund -Building Inspection -Parking Operations Office Supplies & Minor Equipment) Invoice Items 12 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 7.48 Amount 7.48 Vendor 20938 - REPUBLIC PARKING SYSTEM INC Totals Vendor 21815 - REPUBLIC SERVICES INC 0897-000894625 CONTRACT #22588 Edit P.O. Number Item Description Quantity U/M Conversion Item - CONTRACT #22588 1.0000 EA G/L Account 525-15-5400 1390 (Sanitation Fund -Waste Management -Sanitation -Solid Waste Disposal Other Contractual Services) Invoice Items 04/30/2020 Amount/Unit 56,650.0000 Project 1 Invoices 7,976.58 2 $28,909.75 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 56,650.00 Amount 56,650.00 0897-000894625C P.O. Number CART DELIVERY/PICKUP Edit 04/30/2020 Item Description Quantity U/M Amount/Unit Conversion Item - CART DELIVERY/PICKUP 1.0000 EA 1,300.0000 G/L Account 525-15-5400 1390 (Sanitation Fund -Waste Management -Sanitation -Solid Waste Disposal Other Contractual Services) Invoice Items Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 1,300.00 Amount 1,300.00 Vendor 5059502156 3600 - RICOH USA INC PRINTER COPIER CONTRACT- Edit 4710451 Vendor 21815 - REPUBLIC SERVICES INC Totals Invoices 56,650.00 1,300.00 2 $57,950.00 05/01/2020 05/26/2020 05/26/2020 05/20/2020 55.55 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - PRINTER COPIER 1.0000 EA 55.5500 CONTRACT-4710451 G/L Account 224-32-5850 1561 (Community Develop Block Grant -Community Development -Block Grant Administration Office Supplies & Minor Equipment) Invoice Items Total Amount Vendor Catalog Part Number Contract Number 55.55 Project BG21A.ADMN (BLOCK GRANT GENERAL MANAGEMENT, OVERSIGHT, BLOCK GRANT GENERAL ADMINISTRATION) 1 Amount 55.55 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 116 of 129 Page 67 of 80 Invoice Number 5059502776 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason COPIER Edit Item Description Quantity U/M Amount/Unit Conversion Item - COPIER 1.0000 EA 131.0500 G/L Account 525-15-5400 1371 (Sanitation Fund -Waste Management -Sanitation -Solid Waste Disposal Building & Grounds Maintenance) 266-17-7120 1376 (Road Use Tax -Traffic Operations -Traffic Safety Office Equipment Repair & Maintenance) 266-19-7100 1371 (Road Use Tax -Street Department -Street Maintenance Building & Grounds Maintenance) 010-18-7950 1376 (General Fund -Central Garage -Central Garage Office Equipment Repair & Maintenance) Invoice Items Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/01/2020 05/26/2020 05/26/2020 131.05 Total Amount Vendor Catalog Part Number Contract Number 131.05 Project 1 Amount 13.11 19.66 85.18 13.10 Vendor 5970 - ROBBY'S SALES & SERVICE 00056453 TRIMMER STRING P.O. Number Edit Item Description Conversion Item - TRIMMER STRING G/L Account Vendor 3600 - RICOH USA INC Totals Quantity U/M 1.0000 EA 05/07/2020 Amount/Unit 63.7300 Project 010-37-4100 1555 (General Fund -Leisure Services -Leisure Services -Parks Minor Equipment & Supplies) Invoice Items 1 Invoices 2 $186.60 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 63.73 Amount 63.73 00056463 P.O. Number TRIMMER LINE Edit Item Description Quantity U/M Conversion Item - TRIMMER LINE 1.0000 EA G/L Account 010-37-4110 1555 (General Fund -Leisure Services -Downtown Area Maintenance Minor Equipment & Supplies) Invoice Items 05/08/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 67.4800 67.48 Project 1 Contract Number Amount 67.48 Vendor 21976 - RUTABAGA RAGS INC 19995 FACE MASKS P.O. Number Vendor 5970 - ROBBY'S SALES & SERVICE Totals Edit 05/14/2020 Item Description Quantity U/M Conversion Item - FACE MASKS 1.0000 EA G/L Account 010-37-4180 1567 (General Fund -Leisure Services-SportsPlex Recreational Equipment & Supplies) Invoice Items Amount/Unit 540.0000 540.00 Project 37SPLX.OPER (CEDAR VALLEY SPORTSPLEX, SPORTSPLEX OPERATIONS) 1 Invoices 63.73 67.48 2 $131.21 05/26/2020 05/26/2020 540.00 Total Amount Vendor Catalog Part Number Contract Number Amount 540.00 Vendor 21976 - RUTABAGA RAGS INC Totals Vendor 1252 - SANDEE'S Invoices 1 $540.00 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 117 of 129 Page 68 of 80 Invoice Number 161458 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason CIVILIAN COMMENDATION Edit Item Description Quantity U/M Conversion Item - CIVILIAN COMMENDATION 1.0000 EA G/L Account 010-12-1400 1319 (General Fund -Fire Department -Fire Protection Service Other Professional Services) Invoice Items Invoice Date 05/12/2020 Amount/Unit 90.4000 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 90.40 Amount 90.40 Vendor 6956 - SANDRY FIRE SUPPLY 010540 P.O. Number MSA CARRIER ASSY. ETC. Edit Item Description Conversion Item - MSA CARRIER ASSY. ETC. G/L Account Vendor 1252 - SANDEE'S Totals Quantity U/M 1.0000 EA 05/07/2020 Amount/Unit 395.5000 Project 010-12-1400 1574 (General Fund -Fire Department -Fire Protection Service Safety Equipment Replacement Parts) Invoice Items 1 Invoices 90.40 1 $90.40 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 395.50 Amount 395.50 Vendor 6956 - SANDRY FIRE SUPPLY Totals Vendor 20127 - ARIC SCHROEDER 863046 PETTY CASH REPLENISHMENT Edit 05/18/2020 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - 136 SMITH ST & 421 1.0000 EA 36.0000 CHERRY ST DOCS G/L Account 010-08-5700 1313 (General Fund -Planning & Zoning -Planning & Zoning Legal Services) Conversion Item - VILLAGE CREEK DOCS 1.0000 EA 104.0000 G/L Account 426-08-6220 2104 (Capital Improvements Fund -Planning & Zoning -NE Industrial Site TIF Legal Services) Conversion Item - VILLAGE CREEK DOCS1 1.0000 EA 31.0000 G/L Account 010-08-5700 1313 (General Fund -Planning & Zoning -Planning & Zoning Legal Services) Invoice Items Project Project Project 3 Invoices 395.50 1 $395.50 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 36.00 104.00 31.00 Amount 36.00 Amount 104.00 Amount 31.00 Vendor 20127 - ARIC SCHROEDER Totals Vendor 2865 - SCOT'S SUPPLY Invoices 171.00 1 $171.00 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 118 of 129 Page 69 of 80 Invoice Number 013889 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status CARR BOL Edit Item Description Quantity U/M Conversion Item - CARR BOL 1.0000 EA G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items Held Reason Invoice Date 05/05/2020 Amount/Unit 10.5000 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 10.50 Amount 10.50 014139 P.O. Number GEAR PULLER Edit Item Description Quantity U/M Conversion Item - GEAR PULLER 1.0000 EA G/L Account 520-14-5200 1535 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Hardware Items) Invoice Items 05/12/2020 Amount/Unit 26.0500 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 26.05 Amount 26.05 Vendor 5105 - SERVICE SIGNING, L.C. 9486 SUPPLY, PLACE AND REMOVE Edit TRAFFIC CONTROL AT WAGNER ROAD Vendor 2865 - SCOT'S SUPPLY Totals 05/11/2020 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - SUPPLY, PLACE AND 1.0000 EA 300.0000 REMOVE TRAFFIC CONTROL AT WAGNER ROAD G/L Account 205-07-7500 2165 (Local Option Sales Tax -City Engineer -Street Construction Streets & Roadways) Invoice Items Project 1 10.50 26.05 Invoices 2 $36.55 05/26/2020 05/26/2020 300.00 Total Amount Vendor Catalog Part Number Contract Number 300.00 Amount 300.00 Vendor 1303 - SHERWIN-WILLIAMS CO. 0E0126725A3033 REPAIR KIT, AIRLESS HOSE, Edit FILTER Vendor 5105 - SERVICE SIGNING, L.C. Totals 05/18/2020 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - REPAIR KIT, AIRLESS 1.0000 EA 343.7000 HOSE, FILTER G/L Account 266-17-7120 1581 (Road Use Tax -Traffic Operations -Traffic Safety Paint & Paint Supplies) Invoice Items Project 1 Invoices 1 $300.00 05/26/2020 05/26/2020 343.70 Total Amount Vendor Catalog Part Number Contract Number 343.70 Amount 343.70 Vendor 1303 - SHERWIN-WILLIAMS CO. Totals Vendor 21981 - SQUARE, INC. Invoices 1 $343.70 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 119 of 129 Page 70 of 80 Invoice Number 101004425 P.O. Number Invoice Description Status CONV CTR POS SYSTEM Edit Item Description Conversion Item - CONV CTR POS SYSTEM G/L Account Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Quantity 1.0000 Held Reason Invoice Date 01/31/2020 U/M Amount/Unit EA 9,719.0000 417-22-4900 2152 (June 2017 GO Bond Fund -Building Inspection -Five Sullivans Ctr Improvement Building Improvements) Invoice Items Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 9,719.00 Amount 9,719.00 Vendor 5290 - STANLEY CONSULTANTS INC. 1003-lb CONT 1003 BRIDGE PRELIM Edit DESIGN -ADJUSTMENT TO INVOICE Vendor 21981 - SQUARE, INC. Totals 03/28/2020 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - CONT 1003 BRIDGE PRELIM 1.0000 EA 3,000.0000 DESIGN -ADJUSTMENT TO INVOICE G/L Account 417-07-7400 2103 (June 2017 GO Bond Fund -City Engineer -Bridge Maintenance & Improvement Engineering & Consulting) Invoice Items Project 1 Invoices 9,719.00 1 $9,719.00 05/26/2020 05/26/2020 3,000.00 Total Amount Vendor Catalog Part Number Contract Number 3,000.00 Amount 3,000.00 Vendor 1350 - STAR EQUIPMENT, LTD 02500563E DURAPATCHER Vendor 5290 - STANLEY CONSULTANTS INC. Totals Edit Invoices 05/12/2020 05/26/2020 05/26/2020 P.O. Number Item Description Quantity U/M Amount/Unit Conversion Item - DURAPATCHER 1.0000 EA 201,369.0000 G/L Account 417-19-7100 2117 (June 2017 GO Bond Fund -Street Department -Street Maintenance Motor Vehicles & Equipment) Invoice Items Project 1 1 $3,000.00 Total Amount Vendor Catalog Part Number Contract Number 201,369.00 Amount 201,369.00 201,369.00 03094692 P.O. Number HYDRAULIC CURB ROLLER Edit 05/12/2020 RENTAL Item Description Quantity U/M Amount/Unit Conversion Item HYDRAULIC CURB ROLLER 1.0000 EA 279.0000 RENTAL G/L Account 520-14-5200 1564 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Equipment Rental) Invoice Items Project 1 05/26/2020 05/26/2020 279.00 Total Amount Vendor Catalog Part Number Contract Number 279.00 Amount 279.00 Vendor 1350 - STAR EQUIPMENT, LTD Totals Vendor 1360 - STETSON BUILDING PRODUCTS INC Invoices 2 $201,648.00 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 120 of 129 Page 71 of 80 Invoice Number 13946009-00 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason EPDXY Edit Item Description Quantity U/M Conversion Item - EPDXY 1.0000 EA G/L Account 266-19-7100 1555 (Road Use Tax -Street Department -Street Maintenance Minor Equipment & Supplies) Invoice Items Invoice Date 05/12/2020 Amount/Unit 160.0000 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 160.00 Amount 160.00 13946195-00 P.O. Number EXP JOINT/DECK 0 FOAM Edit Item Description Quantity U/M Conversion Item - EXP JOINT/DECK 0 FOAM 1.0000 EA G/L Account 205-19-7110 1511 (Local Option Sales Tax -Street Department -Seal Coating Program Concrete & Aggregates) Invoice Items 05/12/2020 Amount/Unit 57.9100 Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 57.91 Amount 57.91 Vendor 13063 - STOREY KENWORTHY PINV799496 OFFICE SUPPLIES P.O. Number Vendor 1360 - STETSON BUILDING PRODUCTS INC Totals Edit Item Description Conversion Item - OFFICE SUPPLIES G/L Account Quantity U/M 1.0000 EA 05/07/2020 Amount/Unit 119.0700 Project 010-29-7700 1561 (General Fund -Airport Commission -Airport Administration Office Supplies & Minor Equipment) Invoice Items 1 Invoices 160.00 57.91 2 $217.91 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 119.07 Amount 119.07 PINV799343 P.O. Number GLOVES Edit Item Description Quantity U/M Conversion Item - GLOVES 1.0000 EA G/L Account 010-33-3100 1541 (General Fund -Library -Library Services Janitorial Supplies) Invoice Items 05/07/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 11.9700 11.97 Project Amount 11.97 1 PINV798723 P.O. Number KEYBOARD COVERS Edit Item Description Quantity U/M Conversion Item - KEYBOARD COVERS 1.0000 EA G/L Account 010-37-4180 1567 (General Fund -Leisure Services-SportsPlex Recreational Equipment & Supplies) Invoice Items 119.07 11.97 05/05/2020 05/26/2020 05/26/2020 87.15 Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 87.1500 87.15 Project Amount 37SPLX.OPER (CEDAR VALLEY SPORTSPLEX, 87.15 SPORTSPLEX OPERATIONS) 1 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 121 of 129 Page 72 of 80 Invoice Number PINV800983 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status FACE MASKS Edit Item Description Quantity U/M Conversion Item - FACE MASKS 1.0000 EA G/L Account 010-37-4200 1561 (General Fund -Leisure Services -Sports & Youth Services Office Supplies & Minor Equipment) Invoice Items Held Reason Invoice Date 05/14/2020 Amount/Unit 181.7800 Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 181.78 Amount 181.78 PINV799497 P.O. Number CLASP ENVELOPES (2) Edit Item Description Conversion Item - CLASP ENVELOPES (2) G/L Account Quantity U/M 1.0000 EA 05/07/2020 Amount/Unit 23.9800 Project 010-11-1100 1561 (General Fund -Police Department -Police Operations Office Supplies & Minor Equipment) Invoice Items 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 23.98 Amount 23.98 PINV799358 P.O. Number PENS, POPUP POST -IT NOTES Edit Item Description Conversion Item - PENS, POPUP POST -IT NOTES Quantity U/M 1.0000 EA 05/07/2020 Amount/Unit 35.1900 G/L Account 010-08-5700 1561 (General Fund -Planning & Zoning -Planning & Zoning Office Supplies & Minor Equipment) Invoice Items Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 35.19 Amount 35.19 PINV800963 P.O. Number POST -IT NOTES, MARKER PENS Edit Item Description Conversion Item - POST -IT NOTES, MARKER PENS Quantity U/M 1.0000 EA 05/14/2020 Amount/Unit 30.8200 G/L Account 010-08-5700 1561 (General Fund -Planning & Zoning -Planning & Zoning Office Supplies & Minor Equipment) Invoice Items Project 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 30.82 Amount 30.82 CM 127943 P.O. Number POP-UP POST IT NOTES Edit (RETURN) Item Description Quantity Conversion Item - POP-UP POST IT NOTES 1.0000 (RETURN) 05/15/2020 U/M Amount/Unit EA (21.1800) G/L Account 010-08-5700 1561 (General Fund -Planning & Zoning -Planning & Zoning Office Supplies & Minor Equipment) Invoice Items Project 1 181.78 23.98 35.19 30.82 05/26/2020 05/26/2020 (21.18) Total Amount Vendor Catalog Part Number Contract Number (21.18) Amount (21.18) Vendor 13063 - STOREY KENWORTHY Totals Vendor 1370 - SUPERIOR WELDING SUPPLY CO Invoices 8 $468.78 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 122 of 129 Page 73 of 80 Invoice Number 249136 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount EXTINGUISHERS PUT ON OLD Edit 05/08/2020 05/26/2020 05/26/2020 43.00 334 Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item - EXTINGUISHERS PUT ON 1.0000 EA 43.0000 43.00 OLD 334 G/L Account Project Amount 010-12-1400 1319 (General Fund -Fire Department -Fire Protection 43.00 Service Other Professional Services) Invoice Items 1 957997 OXYGEN THERAPY Edit 05/12/2020 05/26/2020 05/26/2020 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item - OXYGEN THERAPY 1.0000 EA 20.6500 20.65 G/L Account Project Amount 010-12-1410 1551 (General Fund -Fire Department -Fire Ambulance 20.65 Service Drugs/Medicines & Medical/Lab Supplies) Invoice Items 1 20.65 Vendor 1370 - SUPERIOR WELDING SUPPLY CO Totals Invoices 2 $63.65 Vendor 21446 - THOMPSON SHOES 050420 SAFETY SHOES - TODD HENRICH Edit 05/04/2020 05/26/2020 05/26/2020 05/12/2020 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item - SAFETY SHOES - TODD 1.0000 EA 144.5000 144.50 HENRICH G/L Account 010-22-8800 1356 (General Fund -Building Inspection -Facilities Maintenance Uniforms & Mats - Cleaning & Rental) Invoice Items Project 1 Amount 144.50 050420PW P.O. Number BOOTS - PW - CENTRAL GARAGE Edit - MIKE HEICHEL Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item - BOOTS - PW - CENTRAL 1.0000 EA 150.0000 150.00 GARAGE - MIKE HEICHEL G/L Account Project Amount 010-18-7950 1573 (General Fund -Central Garage -Central Garage Safety 150.00 & Protective Equipment) 144.50 05/04/2020 05/26/2020 05/26/2020 150.00 Invoice Items 1 Vendor 21446 - THOMPSON SHOES Totals Invoices 2 $294.50 Vendor 20491 - THOMPSON TRUCK & TRAILER INC Run by Emily Graham on 05/22/2020 02:50:29 PM Page 123 of 129 Page 74 of 80 Invoice Number X102053039:01 P.O. Number Invoice Description Status PARTS FOR 191002 Edit Item Description Conversion Item - PARTS FOR 191002 G/L Account Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Held Reason Quantity U/M 1.0000 EA Invoice Date 04/28/2020 Amount/Unit 204.8600 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 204.86 Amount 204.86 X102053072:01 P.O. Number FUEL FILTER Item Description Conversion Item - FUEL FILTER G/L Account Edit Quantity U/M 1.0000 EA 04/30/2020 Amount/Unit 515.4700 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 515.47 Amount 515.47 X102053145:01 P.O. Number PARTS FOR 191002 Item Description Conversion Item - PARTS FOR 191002 G/L Account Edit Quantity U/M 1.0000 EA 05/05/2020 Amount/Unit 97.5200 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 97.52 Amount 97.52 X102053179:01 P.O. Number SLEEVE/DASH CONT Edit VLV/REPAIRLINK 05/06/2020 Item Description Quantity U/M Amount/Unit Conversion Item - SLEEVE/DASH CONT 1.0000 EA 206.5000 VLV/REPAIRLINK G/L Account 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items Project 1 204.86 515.47 97.52 05/26/2020 05/26/2020 206.50 Total Amount Vendor Catalog Part Number Contract Number 206.50 Amount 206.50 X102053206:01 P.O. Number BREATHER Item Description Conversion Item - BREATHER G/L Account Edit Quantity U/M 1.0000 EA 05/07/2020 Amount/Unit 226.5600 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 226.56 Amount 226.56 Vendor 20491 - THOMPSON TRUCK & TRAILER INC Totals Vendor 12295 - TRICON GENERAL CONSTRUCTION Invoices 226.56 5 $1,250.91 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 124 of 129 Page 75 of 80 Invoice Number 947-4 P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason Invoice Date CONT 947 FY20 VIRDEN CREEK Edit 05/14/2020 LEVEE Item Description Quantity U/M Amount/Unit Conversion Item - CONT 947 FY20 VIRDEN 1.0000 EA 325,193.1000 CREEK LEVEE G/L Account 417-07-5600 2171 (June 2017 GO Bond Fund -City Engineer -Flood Protection Flood Protection Improvements) 416-07-5600 2171 (June 2016 GO Bond Fund -City Engineer -Flood Protection Flood Protection Improvements) Invoice Items Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 325,193.10 Total Amount Vendor Catalog Part Number Contract Number 325,193.10 Amount 132,452.22 192,740.88 Vendor 12295 - TRICON GENERAL CONSTRUCTION Totals Vendor 21193 - TRUE NORTH LUBRICANTS & RESOURCES LLC 0060329-IN DEF Edit P.O. Number Item Description Conversion Item - DEF G/L Account Quantity U/M 1.0000 EA Invoices 05/12/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 270.3000 270.30 Project 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items 1 1 $325,193.10 Contract Number Amount 270.30 Vendor 21193 - TRUE NORTH LUBRICANTS & RESOURCES LLC Totals Vendor 21911 - UNIFIRST CORPORATION 247 0171891 SERVICE - SOUTH HILLS MAINT Edit P.O. Number Item Description Conversion Item - SERVICE - SOUTH HILLS MAINT Quantity U/M 1.0000 EA Invoices 05/04/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 17.5000 17.50 G/L Account 010-37-4120 1319 (General Fund -Leisure Services -Golf Courses Other Professional Services) Project Invoice Items 1 270.30 1 $270.30 Contract Number Amount 17.50 247 0172704 P.O. Number SERVICE - SHOP Edit 05/11/2020 05/26/2020 05/26/2020 Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Conversion Item - SERVICE - SHOP 1.0000 EA 64.5000 64.50 G/L Account Project 010-37-4100 1319 (General Fund -Leisure Services -Leisure Services -Parks Other Professional Services) Invoice Items 1 Contract Number Amount 64.50 17.50 64.50 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 125 of 129 Page 76 of 80 Invoice Number 247 0173520 P.O. Number Invoice Description Status SERVICE - SPORTSPLEX Edit Item Description Conversion Item - SERVICE - SPORTSPLEX G/L Account Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Held Reason Quantity U/M 1.0000 EA Invoice Date 05/18/2020 Amount/Unit 118.0000 010-37-4180 1390 (General Fund -Leisure Services-SportsPlex Other Contractual Services) Invoice Items Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 118.00 Total Amount Vendor Catalog Part Number Contract Number 118.00 Project 37SPLX.OPER (CEDAR VALLEY SPORTSPLEX, SPORTSPLEX OPERATIONS) 1 Amount 118.00 247 0173521 P.O. Number SERVICE - SHOP Item Description Conversion Item - SERVICE SHOP G/L Account Edit Quantity U/M 1.0000 EA 05/18/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 64.5000 64.50 Project 010-37-4100 1319 (General Fund -Leisure Services -Leisure Services -Parks Other Professional Services) Invoice Items 1 Contract Number Amount 64.50 Vendor 21176 - UNIQUE MANAGEMENT SERVICES INC 580173 ADDRESS VERIFICATION Edit P.O. Number Vendor 21911 - UNIFIRST CORPORATION Totals Invoices Item Description Conversion Item - ADDRESS VERIFICATION G/L Account Quantity U/M 1.0000 EA 05/01/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 51.7800 51.78 Project 010-33-3100 1319 (General Fund -Library -Library Services Other Professional Services) Invoice Items 1 64.50 4 $264.50 Contract Number Amount 51.78 Vendor 9960 - US BANK 2020-00002361 April Bank Fees P.O. Number Vendor 21176 - UNIQUE MANAGEMENT SERVICES INC Totals Invoices Item Description Conversion Item G/L Account Edit Quantity U/M 1.0000 EA 05/25/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 44.8100 44.81 Project 283-13-5450 1503 (Housing Programs -Housing Authority -Ridgeway Towers Bank Fees) Conversion Item G/L Account 283-13-5452 1503 (Housing Programs -Housing Authority -Section 8 Bank Fees) 1.0000 EA 118.1200 Invoice Items Project 2 118.12 51.78 1 $51.78 Contract Number Amount 44.81 Amount 118.12 Vendor 9960 - US BANK Totals Invoices Vendor 1487 - VAN METER INDUSTRIAL, INC. 162.93 1 $162.93 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 126 of 129 Page 77 of 80 Invoice Number S011119699.001 P.O. Number Invoice Description Status PROXIMITY SWITCH Edit Item Description Conversion Item - PROXIMITY SWITCH G/L Account Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Quantity 1.0000 Held Reason Invoice Date 04/28/2020 U/M Amount/Unit EA 126.9500 010-18-7955 1571 (General Fund -Central Garage -Garage -Motor Pool Service Machinery & Equipment Replacement Parts) Invoice Items Project 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 126.95 Amount 126.95 S011136788.001 P.O. Number TORK 3000 BUTTON PHOTOCELL, Edit SOCKET REDUCER Item Description Quantity U/M Amount/Unit Conversion Item - TORK 3000 BUTTON 1.0000 EA 369.7100 PHOTOCELL, SOCKET REDUCER G/L Account 520-14-5200 1571 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Machinery & Equipment Replacement Parts) Invoice Items 05/13/2020 Project 1 126.95 05/26/2020 05/26/2020 369.71 Total Amount Vendor Catalog Part Number Contract Number 369.71 Amount 369.71 S01137204.001 P.O. Number FLUKE TRUE-RMS AC CLAMP Edit METER 05/13/2020 Item Description Quantity U/M Amount/Unit Conversion Item - FLUKE TRUE-RMS AC 1.0000 EA 236.9900 CLAMP METER G/L Account 520-14-5200 1571 (Sanitary Sewer Fund -Waste Management -Water Pollution -Water Pollution Control Plant Op Machinery & Equipment Replacement Parts) Invoice Items Project 1 05/26/2020 05/26/2020 236.99 Total Amount Vendor Catalog Part Number Contract Number 236.99 Amount 236.99 Vendor 2020-5 P.O. Number Vendor 1487 - VAN METER INDUSTRIAL, INC. Totals 1563 - WATERLOO WATER WORKS May 2020 Property Taxes Edit Item Description Quantity U/M Conversion Item 1.0000 EA G/L Account 010-03-8400 1710 (General Fund -City Clerk & Finance -City Clerk & Finance Claims, Judgments & Contingencies) Invoice Items 05/25/2020 Amount/Unit 1,148.0000 Project 1 Invoices 3 $733.65 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 1,148.00 Amount 1,148.00 Vendor 1563 - WATERLOO WATER WORKS Totals Vendor 4282 - WEBER PAPER COMPANY Invoices 1,148.00 1 $1,148.00 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 127 of 129 Page 78 of 80 Invoice Number W042401 P.O. Number Status Edit Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Held Reason 4 TORSK185A Item Description Quantity U/M Conversion Item - 4 TORSK185A 1.0000 EA G/L Account 010-12-1400 1541 (General Fund -Fire Department -Fire Protection Service Janitorial Supplies) Invoice Date 05/08/2020 Amount/Unit 102.1200 Project Invoice Items 1 Due Date G/L Date Received Date Payment Date Invoice Net Amount 05/26/2020 05/26/2020 Total Amount Vendor Catalog Part Number Contract Number 102.12 Amount 102.12 Vendor 7048 - WELLS FARGO BANK, N.A. 2020-00002357 April Bank Fees P.O. Number Item Description Conversion Item G/L Account Edit Vendor 4282 - WEBER PAPER COMPANY Totals Quantity U/M 1.0000 EA Invoices 05/25/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 76.1700 76.17 Project 010-03-8400 1503 (General Fund -City Clerk & Finance -City Clerk & Finance Bank Fees) Invoice Items 1 102.12 1 $102.12 Contract Number Amount 76.17 Vendor 7048 - WELLS FARGO BANK, N.A. Totals Vendor 1577 - WERTJES UNIFORMS 52603 WELIVER WORK CLOTHES Edit P.O. Number Item Description Conversion Item - WELIVER WORK CLOTHES G/L Account Quantity U/M 1.0000 EA Invoices 03/05/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 250.9800 250.98 Project 010-12-1400 1579 (General Fund -Fire Department -Fire Protection Service Uniforms) Invoice Items 1 76.17 1 $76.17 Contract Number Amount 250.98 52625 BECK UNIFORMS P.O. Number Item Description Conversion Item - BECK UNIFORMS G/L Account Edit Quantity U/M 1.0000 EA 03/18/2020 05/26/2020 05/26/2020 Amount/Unit Total Amount Vendor Catalog Part Number 163.0000 163.00 Project 010-12-1400 1579 (General Fund -Fire Department -Fire Protection Service Uniforms) Invoice Items 1 Contract Number Amount 163.00 Vendor 1577 - WERTJES UNIFORMS Totals Vendor 4214 - ZARNOTH BRUSH WORKS Invoices 250.98 163.00 2 $413.98 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 128 of 129 Page 79 of 80 Invoice Number 0180172-IN P.O. Number Finance Committee Invoice Report 5/26/2020 Invoice Due Date Range 05/26/20 - 05/26/20 Report By Vendor - Invoice Detail Listing Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount TRAIL BROOM Edit 04/29/2020 05/26/2020 05/26/2020 516.00 Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item - TRAIL BROOM 1.0000 EA 516.0000 516.00 G/L Account Project Amount 010-37-4100 1569 (General Fund -Leisure Services -Leisure Services -Parks 516.00 Vehicle Replacement Parts) Invoice Items 1 Vendor RICHARD KIRBY 2020-00002373 REIMB SUPPLIES P.O. Number Edit Item Description Conversion Item - REIMB SUPPLIES G/L Account Vendor 4214 - ZARNOTH BRUSH WORKS Totals Invoices 1 $516.00 05/03/2020 05/26/2020 05/26/2020 Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 1.0000 EA 64.0500 64.05 Project Amount 283-13-5450 1371 (Housing Programs -Housing Authority -Ridgeway 64.05 Towers Building & Grounds Maintenance) Invoice Items 1 64.05 Vendor RICHARD KIRBY Totals Invoices 1 $64.05 Grand Totals Invoices 325 $2,600,413.58 Run by Emily Graham on 05/22/2020 02:50:29 PM Page 129 of 129 Page 80 of 80