Loading...
HomeMy WebLinkAboutCouncil Packet - 10/5/2020 FINANCE COMMITTEE October 5, 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 September 28, 2020, as proposed. TRAVEL REQUESTS 1. Rusty Zey, Randy Shepard, Troy Deeds, Chris Preston;Airport Ops/ARFF Personnel Class/Meeting:Annual Wildlife Training Destination:Waterloo Regional Airport Dates: TBD in October 2020 Amount not to exceed: $500 PRE-AUTHORIZATION TO EXPEND OVER$2,500.00 2. Central Garage Amount and Estimated S/H: $8,230 Expenditure: (2) Rubber tracks. 3. Finance Amount and Estimated S/H: $97,709 Expenditure:Annual software maintenance for financial and community development software. 4. Leisure Services Amount and Estimated S/H: $10,260 Expenditure:Annual installment of registration software 5/1/2020 through 4/30/2021. 5. Police Department Amount and Estimated S/H: $9,450.88 Expenditure: Repair and paint the concrete flooring for the Crime Lab remodel project. 6. Street Department Amount and Estimated S/H: $4,200 Expenditure: (3) sets of uniforms as per union contract. Page 1 of 119 7. Traffic Operations Amount and Estimated S/H: $3,246.34 Expenditure: John Deere SPEC snow pusher. BILLS PAYMENT 8. October 5, 2020. ADJOURNMENT Kelley Felchle City Clerk Page 2 of 119 CITY OF WATERLOO Council Communication Minutes of September 28, 2020, as proposed. City Council Meeting: 10/5/2020 Prepared: REVIEWERS: Department Reviewer Action Date Clerk Office Higby, Nancy Approved 9/28/2020 - 1:22 PM ATTACHMENTS: Description Type ❑ Minutes of 9.28.2020 Backup Material Page 3 of 119 FINANCE COMMITTEE September 28, 2020 5:10 p.m. Harold E. Getty Council Chambers Members present: Vice Chairperson Pat Morrissey and Chairperson Sharon Juon joined the meeting by telephone. Margaret Klein was present. 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 September 21, 2020, as proposed, be approved. Voice vote - Ayes: Three. Motion carried. Moved by Morrissey seconded by Klein that the request for the following travel requests, be approved. Travel Requests Name & Title of Amount Personnel Class/Meeting Destination Date(s) not to Exceed Kelley Felchle, City Iowa Municipal Finance Des Moines, October 22- $215 Clerk Officers Association Fall IA 23, 2020 Conference Voice vote -Ayes: Three. Motion carried. Moved by Morrissey seconded by Klein 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. Expenditure MIS $6,792 VMWare licensing, support and maintenance for three Department years. Police $14,227.88 Updating and adding new building security cameras to the lon term stora e building for the Police Department. Police $33,607.06 Annual software licenses agreement for Microsoft products for Police Department computers. Sewer $15,551.25 + (5) 275 gallon totes of ST-2520 chemical. $2,362 S/H Sewer $4,396.00 + Membrane 84P for aeration basins. $418.56 S/H Sewer $3,458.88 + KSB pump repair for Southview Lift Station. $250 S/H Traffic $9,837 Diamond Blade Cutter. Operations Traffic $12,000+ $900 (2) State of the Art- Smart Poles. Operations S/H Mr. Morrissey questioned if the police department annual software update includes any kind of tracking software. Joel Fitzgerald, Police Chief, confirmed that the update is for general Microsoft Office products. Voice vote -Ayes: Three. Motion carried. Moved by Klein seconded by Morrissey that the budget amendment to carryover the balance left in project 37RST.PS16 at the end of fiscal year 2020 in the amount of$6,661.88 to be spent for trees, as submitted by Leisure Services, be approved. Voice vote -Ayes: Three. Motion carried. Page 4 of 119 Finance Committee September 28, 2020 Page 2 Moved by Klein seconded by Morrissey that the project budget for the 2020 Capital Fund Allocation in the amount of $70,382.00 as submitted by the Housing Authority, be approved. Voice vote -Ayes: Three. Motion carried. Moved by Klein seconded by Morrissey that request approval to purchase food for the coaches and players for the Mayor's More Than Basketball League, to be held at the SportsPlex on 9/26, 10/1, 10/10, 10/15 and 10/17, in the amount of$1,200, be approved. Voice vote - Ayes: Three. Motion carried. Moved by Klein seconded by Morrissey that request approval to sell obsolete dock sections and parts,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 September 28, 2020, in the amount of$4,935,118.46 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 Klein seconded by Morrissey that the meeting be adjourned at 5:17 p.m. Voice vote -Ayes: Three. Motion carried. Kelley Felchle City Clerk Page 5 of 119 CITY OF WATERLOO Council Communication Rusty Zey, Randy Shepard, Troy Deeds, Chris Preston;Airport Ops/ARFF Personnel City Council Meeting: 10/5/2020 Prepared: 9/24/2020 REVIEWERS: Department Reviewer Action Date Airport Kaspari, Keith Approved 9/24/2020 - 4:33 PM Finance Weidner, Michelle Approved 9/30/2020 - 4:26 PM Clerk Office Higby, Nancy Approved 10/1/2020 - 9:37 AM ATTACHMENTS: Description Type ❑ Wildlife Training 2020 Cover Memo Page 6 of 119 I FINANCE DEPT. STAFF ONLY LINE ITEM USED 010-29-7700-1315 TRAVEL REQUEST FY 2021 BUDGETED 10,000.00 CITY OF WATERLOO EXPENDED YTD 0.00 THI5 REQUEST 500.00 LEFT AFTER THIS REQUEST 9,500.00 DATE 9/30/2020 Original-Clerk/Finance Copy- Department NAME(S) AND POSITION(S): DATE: Rusty Zey, Randy Shepard, Troy Deeds, Chris Preston;Airport 9/24/2020 Ops/ARFF personnel NAME OF CLASS/ MEETING: DESTINATION: Waterloo Regional Airport Annual Wildlife Training DEPARTURE POINT IF NOT WATERLOO: DEPARTURE DATE: RETURN DATE: DATE(S) OF MEETING: TBD TBD TBD in October 2020 PURPOSE OF TRAVEL/TRAINING: FAA requires annual wildlife training for all Airport Ops /ARFF personnel to minimize potential threat to aviation operations. Note: USDA Trainer will come to Waterloo. WILL TRAVEL REQUIRE ADDITIONAL PERSONNEL: X COST $ YES NO METHOD OF TRAVEL: CITY VEHICLE PRIVATE VEHICLE AIRFARE DEPARTING FROM: ESTIMATE OF COST: BUDGET LINE ITEM: 010-29-7700-1346 LODGING TAXI X GRANT REIMBURSABLE MEALS PARKING YES NO $500 REGISTRATION AIRFARE X REQUIRED CERTIFICATION MILEAGE/FUEL MISC/TOLLS YES NO TOTAL FOR ALL: $ 500 TOTAL: $ 125 PER PERSON I BELIEVE THIS TRIP SERVES A PUBLIC PURPOSE I APPROVE THIS TRAVEL REQUEST AND IS NECESSARY AND BENEFICIAL TO THE CITY OF WATERLOO Keith Kaspari DEPARTMENT HEAD MAYOR September 24, 2020 DATE DATE K:\Shared Goodies\Forms\Travel Request Form January 2010 Page 7 of 119 CITY OF WATERLOO Council Communication Central Garage City Council Meeting: 10/5/2020 Prepared: 9/29/2020 REVIEWERS: Department Reviewer Action Date Public Works Department Greco, Sandie Approved 9/29/2020 - 11:53 AM Finance Weidner, Michelle Approved 9/30/2020 - 4:10 PM Clerk Office Higby, Nancy Approved 10/1/2020 - 9:40 AM ATTACHMENTS: Description Type ❑ Pre-auth Rubber Tracks Cover Memo Page 8 of 119 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 Central Garage Department to expend $ 8,230.00 plus est. shipping costs of $ to pay for or purchase Arisun Rubber Tracks This purchase or expenditure is being made because: To replace Tracks on Waste Management Excavator Vendor selected for this purchase: Bauer Built F■ Bids or written quotes were taken on this purchase, as follows: Bauer Built Waterloo, IA $8,230.00 Mid Country Machinery Waterloo, IA $10,372.58 Murphy Tractor Waterloo, IA $8,345.64 ❑ Bids or quotes were not taken on this purchase because: Prior Committee Actions (Dates): Please check the following box(es)as appropriate to describe the funding for this expense: F■ General Fund ❑ Road Use Tax ❑ Sewer F—] Sanitation EIBonds ❑ Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 010-18-7955-1571 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 345,500.00 and the current available balance is $ 248,853.40 Respectfully submitted, Sandie Greco 9/16/2020 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) Page 9 of 119 CITY OF WATERLOO Council Communication Finance City Council Meeting: 10/5/2020 Prepared: 9/28/2020 REVIEWERS: Department Reviewer Action Date Finance Weidner, Michelle Approved 9/30/2020 - 4:10 PM Clerk Office Higby, Nancy Approved 10/1/2020 - 9:39 AM ATTACHMENTS: Description Type ❑ Pre-auth Logos Software Mtce Cover Memo Page 10 of 119 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 Finance Department to expend $ 97,709 plus est. shipping costs of $ to pay for or purchase annual maintenance fees for financial and community development software. This purchase or expenditure is being made because: Vendor selected for this purchase: Bids or written quotes were taken on this purchase, as follows: F■ Bids or quotes were not taken on this purchase because: This is the required annual support and maintenance fee for the City's Enterprise Resource software that serves all departments with financial, human resources and community development applications. Prior Committee Actions (Dates): Please check the following box(es)as appropriate to describe the funding for this expense: F■ General Fund ❑ Road Use Tax ❑ Sewer 0■ Sanitation EIBonds ❑ Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 010-03 $73,955; 010-22 $ 21 251; 525-15 $2,503 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 111,000.00 32,300.00 3,536.00 and the current available balance is $ 100,165.65 29 656.18 3,536.00 Respectfully submitted, Michelle Weidner 9/24/2020 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) Page 11 of 119 CITY OF WATERLOO Council Communication Leisure Services City Council Meeting: 10/5/2020 Prepared: REVIEWERS: Department Reviewer Action Date Leisure Services Huting, Paul Approved 9/29/2020 - 4:55 PM Finance Weidner, Michelle Approved 9/30/2020 - 4:36 PM Clerk Office Higby, Nancy Approved 10/1/2020 - 9:42 AM ATTACHMENTS: Description Type ❑ preauthorization Active Network Backup Material Page 12 of 119 City Clerk Use Only Finance Committee Approval Date City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Leisure Services Department to expend $ 10,260.00 plus est. shipping costs of $ to pay for or purchase annual installment of registration software. Ca_�_ap }� _3`. aQ�� This purchase or expenditure is being made because: the software is used by sports, sportsplex, park office, young arena and center for the arts for membership registration, activity registration, scheduling. Vendor selected for this purchase: Active Network/Max Galaxy Dallas TX Bids or written quotes were taken on this purchase, as follows: ❑■ Bids or quotes were not taken on this purchase because: This is the vendor of the software being used. Prior Committee Actions (Dates): Please check the following box(es) as appropriate to describe the funding for this expense: General Fund Road Use Tax EI Sewer F-1 Sanitation Bonds Federallother grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: i balance after expense budget amendment Park 010-37-41001520 $307.801 $0.00. $308.00 sportsplex _ 010-37-41_80 1520 $5,643.001 $5,700.00 sports 010-37-42001520 $3,796.20 $5,500.00I young arena .010-37-4500 1520 i _ $513AQy $0, 0' $513.00_ TOTAL $10,260.00; Paul Huting 9/29/2020 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodiesllormslExpenditure Pre-Authorization.xls(Mar 2010) Page 13 of 119 CITY OF WATERLOO Council Communication Police Department City Council Meeting: 10/5/2020 Prepared: 9/25/2020 REVIEWERS: Department Reviewer Action Date Police Department Mohlis, Dave Approved 9/25/2020 - 1:13 PM Finance Weidner, Michelle Approved 9/30/2020 - 4:20 PM Clerk Office Higby, Nancy Approved 10/1/2020 - 9:38 AM ATTACHMENTS: Description Type ❑ Pre-auth Flooring Crime Lab Cover Memo SUBJECT: Crime Lab flooring Submitted by: Submitted By: Dave Mohlis, Police Captain Recommended Action: Summary Statement: Expenditure Required: Source of Funds: Policy Issue: Alternative: Background Information: Page 14 of 119 City Clerk Use Only Finance Committee Approval Date City of Waterloo Expenditure Pre-Authorization Request Form The Finance Committee of the City Council is hereby requested to authorize the following purchase or expenditure submitted by the Police Department to expend $ $9,450.88 plus est. shipping costs of $ 0 to pay for or purchase Repair and paint flooring for the Police Department Crime Lab. This purchase or expenditure is being made because: This is part of the building remodeling of the Crime Lab. Flooring repairs are needed and then painting of an epoxy covering. Vendor selected for this purchase: Ackley Painting F■ Bids or written quotes were taken on this purchase, as follows: Ackley Painting Co. $9450.88 Even Quality Works $11,754.00 Bids or quotes were not taken on this purchase because: Prior Committee Actions (Dates): Please check the following box(es)as appropriate to describe the funding for this expense: ❑ General Fund ❑ Road Use Tax ❑ Sewer F—] Sanitation ❑- Bonds ❑ Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 418-11-1100-2152 Police Department Improvements (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 50,000.00 and the current available balance is $ 43,298.43 Respectfully submitted, Dave Mohlis, Police Captain 9/25/20 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) Page 15 of 119 CITY OF WATERLOO Council Communication Street Department City Council Meeting: 10/5/2020 Prepared: 9/30/2020 REVIEWERS: Department Reviewer Action Date Public Works Department Greco, Sandie Approved 9/30/2020 - 10:05 AM Finance Weidner, Michelle Approved 9/30/2020 - 4:38 PM Clerk Office Higby, Nancy Approved 10/1/2020 - 9:43 AM ATTACHMENTS: Description Type ❑ expenditure pre-auth Cover Memo Page 16 of 119 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 Street Department Department to expend $ 4,200.00 plus est. shipping costs of $ to pay for or purchase Uniforms for union employees This purchase or expenditure is being made because: Annual 3 sets of uniforms as per union contract (Van Meter honoring same prices as last year's bid) Vendor selected for this purchase: Van Meter Bids or written quotes were taken on this purchase, as follows: F■ Bids or quotes were not taken on this purchase because: Honoring last year's bid prices Prior Committee Actions (Dates): Please check the following box(es)as appropriate to describe the funding for this expense: ❑ General Fund ❑0 Road Use Tax ❑ Sewer F—] Sanitation EI Bonds ❑ Federal/other grants ❑E Other(specify) This expenditure is to be coded to the following budget line-item: 205-19-7110-1579; 521-19-5500-1579; 266-19-7100-1579 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 1,200; 750; 2,500 and the current available balance is $ 1,200; 750; 2,388.46 Respectfully submitted, Sandie Greco 9/30/2020 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) Page 17 of 119 CITY OF WATERLOO Council Communication Traffic Operations City Council Meeting: 10/5/2020 Prepared: 9/29/2020 REVIEWERS: Department Reviewer Action Date Traffic Operations Greco, Sandie Approved 9/29/2020 - 9:58 AM Finance Weidner, Michelle Approved 9/30/2020 - 4:31 PM Clerk Office Higby, Nancy Approved 10/1/2020 - 9:39 AM ATTACHMENTS: Description Type ❑ Expenditure Pre-Auth Cover Memo Page 18 of 119 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 $ 3,246.34 plus est. shipping costs of $ to pay for or purchase 1 John Deere SP8C Snow Pusher This purchase or expenditure is being made because: To be installed on Skidsteer for removing snow in parking lots and top of the parking ramps/ Vendor selected for this purchase: Murphy Tractor& Equipment Co. F■ Bids or written quotes were taken on this purchase, as follows: Murphy Tractor& Equipment Co. Waterloo, IA $3,246.34 Mid Country Machinery, Inc. Waterloo, IA $5,200.00 Bids or quotes were not taken on this purchase because: Prior Committee Actions (Dates): Please check the following box(es)as appropriate to describe the funding for this expense: ❑ General Fund ❑ Road Use Tax ❑ Sewer F—] Sanitation ❑- Bonds ❑ Federal/other grants ❑ Other(specify) This expenditure is to be coded to the following budget line-item: 418-17-7120-2117 (Fund - Department-Activity-Account Number) (Project Code) in which the budgeted amount is $ 50,000.00 and the current available balance is $ 50,000.00 Respectfully submitted, Sandie Greco 9/16/2020 (Signature Dept. Head or Designee) Date (Signature Finance Dept. Review) Date KAshared goodies\forms\Expenditure Pre-Authorization.xls(Mar 2010) Page 19 of 119 CITY OF WATERLOO Council Communication October 5, 2020. City Council Meeting: 10/5/2020 Prepared: REVIEWERS: Department Reviewer Action Date Finance Higby, Nancy Approved 9/28/2020 - 1:22 PM ATTACHMENTS: Description Type ❑ 10.05.20 Preliminary Cover Invoice Report Backup Material ❑ 10.05.20 Preliminary Detail Invoice Report Backup Material ❑ 10.05.20 Preliminary Summary Invoice Report Backup Material Page 20 of 119 City of Waterloo Finance Committee Preliminary Draft Invoice Report As of Friday, October 2, 2020 For October 5, 2020 Approval Finance Committee Accounts Payable Open Invoice Report Total As of Friday, October 02, 2020 1 ,151 ,551 .34 EFT Transactions: 1,151,551.34 Workers Compensation Issued by TPA Housing Authority Housing Assistance EFT's 1 ,853.00 Housing Authority Housing Assistance EFT's Payroll Bill Payment Total - Friday, October 2, 2020 1,153,404.34 Payment to Council members or related entities: Page 21 of 119 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 7218-QWEST 151436505 CHARGES FOR ACCOUNT Edit 10/20/2020 10/05/2020 10/05/2020 948.52 85605101 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CHARGES FOR ACCOUNT 1.0000 EA 948.5200 948.52 85605101 GIL Account Project Amount 010-01-8220 1344(General Fund-Mayor-Administrative SVCS/MIS 948.52 Telephone&Fax Expense) Invoice Items 1 2021-00000589 LIBRARY FAX LINE Edit 09/13/2020 10/05/2020 10/05/2020 09/01/2020 76.73 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- LIBRARY FAX LINE 1.0000 EA 76.7300 76.73 CHARGES GIL Account Project Amount 010-01-8220 1339(General Fund-Mayor-Administrative SVCS/MIS Data 76.73 Communication) Invoice Items 1 Vendor 7218-QWEST Totals Invoices 2 $1,025.25 Vendor 423-AAA DRAIN DOCTOR 53993 RT-SHOWER DRAIN IN # 113 Edit 10/07/2019 10/05/2020 10/05/2020 105.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- RT-SHOWER DRAIN IN # 1.0000 EA 105.0000 105.00 113 GIL Account Project Amount 283-13-5450 1371 (Housing Programs-Housing Authority-Ridgeway 105.00 Towers Building&Grounds Maintenance) Invoice Items 1 Vendor 423-AAA DRAIN DOCTOR Totals Invoices 1 $105.00 Vendor 11784-ACTION SIGNS,LLC 4873 PRINTING AAND MATERIALS FOR Edit 09/28/2020 10/05/2020 10/05/2020 09/28/2020 1,600.00 NEIGHBORHOOD SERVICES TRAILER P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- PRINTING AAND 1.0000 EA 1,600.0000 1,600.00 MATERIALS FOR NEIGHBORHOOD SERVICES TRAILER GIL Account Project Amount Run by Emily Graham on 10/02/2020 12:23:03 PM Page 22 of 119 Page 1 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 4873 PRINTING AAND MATERIALS FOR Edit 09/28/2020 10/05/2020 10/05/2020 09/28/2020 1,600.00 NEIGHBORHOOD SERVICES TRAILER P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 426-32-5850 1567(Capital Improvements Fund-Community 32GRT.TRAILER(CDBG GRANTS&PROJECTS, 1,600.00 Development-Block Grant Administration Recreational Equipment& NEIGHBORHOOD SERVICES PARTY TRAILER) Supplies) Invoice Items 1 Vendor 11784-ACTION SIGNS,LLC Totals Invoices 1 $1,600.00 Vendor 5419-AECOM TECHNICAL SERVICES,INC 2000406343 AIRPORT WATER MAIN IMP; Edit 09/15/2020 10/05/2020 10/05/2020 1,219.26 SERVICES AUG 15-SEP 11,2020 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-AIRPORT WATER MAIN 1.0000 EA 1,219.2600 1,219.26 IMP; SERVICES AUG 15-SEP 11,2020 GIL Account Project Amount 426-08-6260 2103(Capital Improvements Fund-Planning&Zoning- 1,219.26 Midport TIF District Engineering&Consulting) Invoice Items 1 2000398026 CONT 877 DRY RUN CREEK Edit 08/25/2020 10/05/2020 10/05/2020 27,192.47 INTERCEPTOR P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- 18W FINAL CLARIFIER 1.0000 EA 27,192.4700 27,192.47 MAINTENANCE AND REPAIRS GIL Account Project Amount 520-14-5320 2103 (Sanitary Sewer Fund-Waste Management-Water 14SRF.DRYRNSWR(STATE REVOLVING LOAN FUND, 27,192.47 Pollution-Sewer Coll Sytem Improvements Engineering&Consulting) DRY RUN CREEK SANITARY INTERCEPTOR SEWER) Invoice Items 1 2000406329 18W FINAL CLARIFIER Edit 09/15/2020 10/05/2020 10/05/2020 7,553.03 MAINTENANCE AND REPAIRS P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- 18W FINAL CLARIFIER 1.0000 EA 7,553.0300 7,553.03 MAINTENANCE AND REPAIRS GIL Account Project Amount 520-14-5320 2103(Sanitary Sewer Fund-Waste Management-Water 7,553.03 Pollution-Sewer Coll Sytem Improvements Engineering&Consulting) Invoice Items 1 Vendor 5419-AECOM TECHNICAL SERVICES,INC Totals Invoices 3 $35,964.76 Vendor 11320-AGVANTAGE FS,INC. Run by Emily Graham on 10/02/2020 12:23:03 PM Page 23 of 119 Page 2 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 53008184 UNLEADED GAS W/ETH 10% Edit 09/16/2020 10/05/2020 10/05/2020 12,627.27 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-UNLEADED GAS W/ETH 1.0000 EA 12,627.2700 12,627.27 10% GIL Account Project Amount 010-18-7955 1533(General Fund-Central Garage-Garage-Motor Pool 12,627.27 Service Fuel Expense) Invoice Items 1 Vendor 11320-AGVANTAGE FS,INC.Totals Invoices 1 $12,627.27 Vendor 22-AHLERS&COONEY,P.C. 789610 MUNI COMM UTILITY Edit 09/19/2020 10/05/2020 10/05/2020 3,225.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-MUNI COMM UTILITY 1.0000 EA 3,225.0000 3,225.00 GIL Account Project Amount 417-08-6105 2103(June 2017 GO Bond Fund-Planning&Zoning-Special 3,225.00 Projects Engineering&Consulting) Invoice Items 1 790134 SEWER 2020A TAXABLE SRF Edit 09/22/2020 10/05/2020 10/05/2020 8,015.08 LOAN P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SEWER 2020A TAXABLE 1.0000 EA 8,015.0800 8,015.08 SRF LOAN GIL Account Project Amount 520-14-8980 1750(Sanitary Sewer Fund-Waste Management-Water 8,015.08 Pollution-Fiduciary Transactions Debt Service Expense) Invoice Items 1 790135 SEWER 2020B TAXABLE SRF Edit 09/22/2020 10/05/2020 10/05/2020 11,004.32 LOAN P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SEWER 20208 TAXABLE 1.0000 EA 11,004.3200 11,004.32 SRF LOAN GIL Account Project Amount 520-14-8980 1750(Sanitary Sewer Fund-Waste Management-Water 11,004.32 Pollution-Fiduciary Transactions Debt Service Expense) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 24 of 119 Page 3 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 790136 SEWER 2020C TAXABLE SRF Edit 09/22/2020 10/05/2020 10/05/2020 16,004.33 LOAN P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SEWER 2020C TAXABLE 1.0000 EA 16,004.3300 16,004.33 SRF LOAN GIL Account Project Amount 520-14-8980 1750(Sanitary Sewer Fund-Waste Management-Water 16,004.33 Pollution-Fiduciary Transactions Debt Service Expense) Invoice Items 1 Vendor 22-AHLERS&COONEY,P.C.Totals Invoices 4 $38,248.73 Vendor 42-ALLEN GLASS COMPANY,INC 00020686 INSTALL GLASS BARRIERS AT Edit 09/21/2020 10/05/2020 10/05/2020 1,512.00 AIRLINE COUNTERS P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-INSTALL GLASS BARRIERS 1.0000 EA 1,512.0000 1,512.00 AT AIRLINE COUNTERS GIL Account Project Amount 010-29-7700 1371 (General Fund-Airport Commission-Airport 1,512.00 Administration Building&Grounds Maintenance) Invoice Items 1 Vendor 42-ALLEN GLASS COMPANY,INC Totals Invoices 1 $1,512.00 Vendor 5996-ALLEN OCCUPATIONAL HEALTH SERVICES 36214 PRE EMPLOYMENT VISION TEST Edit 09/15/2020 10/05/2020 10/05/2020 25.00 FOR R.WENCE P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- PRE EMPLOYMENT VISION 1.0000 EA 25.0000 25.00 TEST FOR R.WENCE GIL Account Project Amount 010-11-1100 1314(General Fund-Police Department-Police Operations 25.00 Health Services) Invoice Items 1 Vendor 5996-ALLEN OCCUPATIONAL HEALTH SERVICES Totals Invoices 1 $25.00 Vendor 8563-AMENT INC Run by Emily Graham on 10/02/2020 12:23:03 PM Page 25 of 119 Page 4 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 2743 20AB DOWNTOWN FIBER OPTIC Edit 09/03/2020 10/05/2020 10/05/2020 3,712.95 CAMERAS P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-20AB DOWNTOWN FIBER 1.0000 EA 3,712.9500 3,712.95 OPTIC CAMERAS GIL Account Project Amount 290-17-71612103(Grant Funded Projects-Traffic Operations-Traffic 17TRF.SWAP769(TRAFFIC DEPARTMENT GRANTS 3,712.95 Improvements Engineering&Consulting) AND PROJECTS, DOWNTOWN CAMERA SWAP PROJECT) Invoice Items 1 2759 19AE TRAFF SAFETY IMPR Edit 09/08/2020 10/05/2020 10/05/2020 1,425.00 RIDGEWAY&GREYHOUND P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- 19AE TRAFF SAFETY IMPR 1.0000 EA 1,425.0000 1,425.00 RIDGEWAY&GREYHOUND GIL Account Project Amount 419-17-71612103 (June 2019 GO Bond Fund-Traffic Operations-Traffic 17TRF.TSF762(TRAFFIC DEPARTMENT GRANTS AND 1,425.00 Improvements Engineering&Consulting) PROJECTS, RIDGEWAY&GREYHOUND TRAFFIC SAFETY) Invoice Items 1 Vendor 8563-AMENT INC Totals Invoices 2 $5,137.95 Vendor 59-AMERICAN PLANNING ASSOCIATION 158082-2075 MEMBERSHIP RENEWAL; Edit 07/10/2020 10/05/2020 10/05/2020 308.00 HYBERGER P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-MEMBERSHIP RENEWAL 1.0000 EA 308.0000 308.00 GIL Account Project Amount 010-08-5700 1391 (General Fund-Planning&Zoning-Planning&Zoning 308.00 Dues&Memberships) Invoice Items 1 2830279-2075 MEMBERSHIP RENEWAL; Edit 07/10/2020 10/05/2020 10/05/2020 308.00 DORNOFF P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- MEMBERSHIP RENEWAL; 1.0000 EA 308.0000 308.00 DORNOFF GIL Account Project Amount 010-08-5700 1391 (General Fund-Planning&Zoning-Planning&Zoning 308.00 Dues&Memberships) Invoice Items 1 Vendor 59-AMERICAN PLANNING ASSOCIATION Totals Invoices 2 $616.00 Vendor 67-ANSWER PLUS INC Run by Emily Graham on 10/02/2020 12:23:03 PM Page 26 of 119 Page 5 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 001-084200924202 RT-ANSWERING SERVICE Edit 09/24/2020 10/05/2020 10/05/2020 112.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-RT-ANSWERING SERVICE 1.0000 EA 112.0000 112.00 GIL Account Project Amount 283-13-5450 1344(Housing Programs-Housing Authority-Ridgeway 112.00 Towers Telephone&Fax Expense) Invoice Items 1 Vendor 67-ANSWER PLUS INC Totals Invoices 1 $112.00 Vendor 20968-AP INDUSTRIAL STEEL,INC 11582 SQ TUBE Edit 09/17/2020 10/05/2020 10/05/2020 38.58 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SQ TUBE 1.0000 EA 38.5800 38.58 GIL Account Project Amount 266-19-7100 1555(Road Use Tax-Street Department-Street 38.58 Maintenance Minor Equipment&Supplies) Invoice Items 1 Vendor 20968-AP INDUSTRIAL STEEL,INC Totals Invoices 1 $38.58 Vendor 72-ARAMARK UNIFORM SERVICES,INC. 1877396319 MATS,TOWELS-CITY HALL Edit 09/22/2020 10/05/2020 10/05/2020 09/22/2020 125.96 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- MATS,TOWELS-CITY 1.0000 EA 125.9600 125.96 HALL GIL Account Project Amount 010-22-8800 1356(General Fund-Building Inspection-Facilities 125.96 Maintenance Uniforms&Mats- Cleaning&Rental) Invoice Items 1 1877392059 JANITORIAL Edit 09/14/2020 10/05/2020 10/05/2020 149.40 SERVICES/UNIFORMS P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-JANITORIAL 1.0000 EA 149.4000 149.40 SERVICES/UNIFORMS GIL Account Project Amount 010-18-7950 1541 (General Fund-Central Garage-Central Garage 80.24 Janitorial Supplies) 010-18-1405 1579(General Fund-Central Garage-Fire-Garage Parts& 5.32 Service Uniforms) 010-18-7950 1579(General Fund-Central Garage-Central Garage 63.84 Uniforms) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 27 of 119 Page 6 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 1877395555 JANITORIAL Edit 09/21/2020 10/05/2020 10/05/2020 187.86 SERVICES/UNIFORMS P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-JANITORIAL 1.0000 EA 187.8600 187.86 SERVICES/UNIFORMS GIL Account Project Amount 010-18-7950 1541 (General Fund-Central Garage-Central Garage 118.70 Janitorial Supplies) 010-18-7950 1579(General Fund-Central Garage-Central Garage 63.84 Uniforms) 010-18-1405 1571 (General Fund-Central Garage-Fire-Garage Parts& 5.32 Service Machinery&Equipment Replacement Parts) Invoice Items 1 1877396276 MOPS,TOWEL SERVICE Edit 09/22/2020 10/05/2020 10/05/2020 122.44 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-MOPS,TOWEL SERVICE 1.0000 EA 122.4400 122.44 GIL Account Project Amount 010-33-3100 1371 (General Fund-Library-Library Services Building& 122.44 Grounds Maintenance) Invoice Items 1 1877396320 MATS,TOWELS,&BIO HAZARD Edit 09/22/2020 10/05/2020 10/05/2020 136.12 BAG CLEANING-WPD P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- MATS,TOWELS,&BIO 1.0000 EA 136.1200 136.12 HAZARD BAG CLEANING-WPD GIL Account Project Amount 010-11-1100 1356(General Fund-Police Department-Police Operations 136.12 Uniforms&Mats- Cleaning&Rental) Invoice Items 1 1877395556 JANITORIAL Edit 09/21/2020 10/05/2020 10/05/2020 93.88 SERVICES/UNIFORMS P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-JANITORIAL 1.0000 EA 93.8800 93.88 SERVICES/UNIFORMS GIL Account Project Amount 266-19-7100 1541 (Road Use Tax-Street Department-Street 79.49 Maintenance Janitorial Supplies) 266-19-7100 1579(Road Use Tax-Street Department-Street 14.39 Maintenance Uniforms) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 28 of 119 Page 7 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 1877395560 JANITORIAL Edit 09/21/2020 10/05/2020 10/05/2020 421.17 SUPPLIES/UNIFORMS P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-JANITORIAL 1.0000 EA 421.1700 421.17 SUPPLIES/UNIFORMS GIL Account Project Amount 520-14-5200 1579(Sanitary Sewer Fund-Waste Management-Water 202.74 Pollution-Water Pollution Control Plant Op Uniforms) 520-14-5200 1541 (Sanitary Sewer Fund-Waste Management-Water 218.43 Pollution-Water Pollution Control Plant Op Janitorial Supplies) Invoice Items 1 1877399088 UNIFORMS/RUGS CLEANING& Edit 09/28/2020 10/05/2020 10/05/2020 18.89 RENTAL P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-UNIFORMS/RUGS 1.0000 EA 18.8900 18.89 CLEANING&RENTAL GIL Account Project Amount 525-15-5400 1356(Sanitation Fund-Waste Management-Sanitation-Solid 18.89 Waste Disposal Uniforms&Mats- Cleaning&Rental) Invoice Items 1 Vendor 72-ARAMARK UNIFORM SERVICES,INC.Totals Invoices 8 $1,255.72 Vendor 3222-ARNOLD MOTOR SUPPLY 46NVO33569 SPARK PLUGS Edit 09/15/2020 10/05/2020 10/05/2020 47.10 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SPARK PLUGS 1.0000 EA 47.1000 47.10 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 47.10 Service Machinery&Equipment Replacement Parts) Invoice Items 1 46NVO33588 STOCK PARTS Edit 09/16/2020 10/05/2020 10/05/2020 106.90 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-STOCK PARTS 1.0000 EA 106.9000 106.90 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 106.90 Service Machinery&Equipment Replacement Parts) Invoice Items 1 46NVO33589 DEF Edit 09/16/2020 10/05/2020 10/05/2020 35.97 P.O.Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- DEF 1.0000 EA 35.9700 35.97 GIL Account Project Amount Run by Emily Graham on 10/02/2020 12:23:03 PM Page 29 of 119 Page 8 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 46NVO33589 DEF Edit 09/16/2020 10/05/2020 10/05/2020 35.97 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 010-18-1411 1571 (General Fund-Central Garage-Ambulance-Garage 35.97 Parts&Service Machinery&Equipment Replacement Parts) Invoice Items 1 46NVO33609 GASKET Edit 09/16/2020 10/05/2020 10/05/2020 4.08 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-GASKET 1.0000 EA 4.0800 4.08 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 4.08 Service Machinery&Equipment Replacement Parts) Invoice Items 1 46NVO33610 WHL NUT Edit 09/16/2020 10/05/2020 10/05/2020 4.51 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-WHL NUT 1.0000 EA 4.5100 4.51 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 4.51 Service Machinery&Equipment Replacement Parts) Invoice Items 1 46NVO33624 1/4"MALE PLUG A-STYLE Edit 09/16/2020 10/05/2020 10/05/2020 6.45 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- 1/4"MALE PLUG A-STYLE 1.0000 EA 6.4500 6.45 GIL Account Project Amount 010-18-7950 1571 (General Fund-Central Garage-Central Garage 6.45 Machinery&Equipment Replacement Parts) Invoice Items 1 46NVO33638 BRAKES Edit 09/17/2020 10/05/2020 10/05/2020 46.95 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-BRAKES 1.0000 EA 46.9500 46.95 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 46.95 Service Machinery&Equipment Replacement Parts) Invoice Items 1 46NVO33641 J-B WELD SKIN CD Edit 09/17/2020 10/05/2020 10/05/2020 6.91 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-J-B WELD SKIN CD 1.0000 EA 6.9100 6.91 GIL Account Project Amount 010-18-7950 1571 (General Fund-Central Garage-Central Garage 6.91 Machinery&Equipment Replacement Parts) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 30 of 119 Page 9 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 46NVO33666 TUBE CUT OIL CD/RNDRND STEM Edit 09/17/2020 10/05/2020 10/05/2020 35.11 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-TUBE CUT OIL CD/RNDRND 1.0000 EA 35.1100 35.11 STEM GIL Account Project Amount 010-18-7950 1571 (General Fund-Central Garage-Central Garage 10.58 Machinery&Equipment Replacement Parts) 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 24.53 Service Machinery&Equipment Replacement Parts) Invoice Items 1 46CR003867 CREDIT Edit 09/18/2020 10/05/2020 10/05/2020 (48.94) P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CREDIT 1.0000 EA (48.9400) (48.94) GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool (48.94) Service Machinery&Equipment Replacement Parts) Invoice Items 1 46NVO33696 FUEL PUMP DRIVER MODULE Edit 09/18/2020 10/05/2020 10/05/2020 139.83 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- FUEL PUMP DRIVER 1.0000 EA 139.8300 139.83 MODULE GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 139.83 Service Machinery&Equipment Replacement Parts) Invoice Items 1 46NVO33706 OIL ONLY WHITE Edit 09/18/2020 10/05/2020 10/05/2020 72.65 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-OIL ONLY WHITE 1.0000 EA 72.6500 72.65 GIL Account Project Amount 010-18-7950 1571 (General Fund-Central Garage-Central Garage 72.65 Machinery&Equipment Replacement Parts) Invoice Items 1 46NVO33707 PARTS FOR 121332 Edit 09/18/2020 10/05/2020 10/05/2020 48.94 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- PARTS FOR 121332 1.0000 EA 48.9400 48.94 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 48.94 Service Machinery&Equipment Replacement Parts) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 31 of 119 Page 10 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 46NVO33726 ULTRA GREY RIGID HI-TORQUE Edit 09/18/2020 10/05/2020 10/05/2020 19.99 RTV SILICONE GSKT MKR P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ULTRA GREY RIGID HI- 1.0000 EA 19.9900 19.99 TORQUE RTV SILICONE GSKT MKR GIL Account Project Amount 010-18-7950 1571 (General Fund-Central Garage-Central Garage 19.99 Machinery&Equipment Replacement Parts) Invoice Items 1 46NVO33808 ALTERNATOR Edit 09/21/2020 10/05/2020 10/05/2020 295.98 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ALTERNATOR 1.0000 EA 295.9800 295.98 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 295.98 Service Machinery&Equipment Replacement Parts) Invoice Items 1 46NVO33944 BLADE FUSE Edit 09/23/2020 10/05/2020 10/05/2020 3.02 P.O.Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-BLADE FUSE 1.0000 EA 3.0200 3.02 GIL Account Project Amount 266-17-7120 1521(Road Use Tax-Traffic Operations-Traffic Safety 3.02 Electrical Supplies) Invoice Items 1 Vendor 3222-ARNOLD MOTOR SUPPLY Totals Invoices 16 $825.45 Vendor 12816-ARROWHEAD SCIENTIFIC,INC. 130394 BLOOD ALCOHOL URINE TEST Edit 09/21/2020 10/05/2020 10/05/2020 129.50 KITS(20)&FINGERPRINT BRUSH(3) P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- BLOOD ALCOHOL URINE 1.0000 EA 129.5000 129.50 TEST KITS(20)&FINGERPRINT BRUSH(3) GIL Account Project Amount 010-11-1100 1568(General Fund-Police Department-Police Operations 129.50 Crime Laboratory Supplies) Invoice Items 1 Vendor 12816-ARROWHEAD SCIENTIFIC,INC.Totals Invoices 1 $129.50 Vendor 21785-AT&T MOBILITY LLC Run by Emily Graham on 10/02/2020 12:23:03 PM Page 32 of 119 Page 11 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount X09272020 ACCT#287291817096 8/20-9/19 Edit 09/19/2020 10/05/2020 10/05/2020 2,170.65 DATA&PHONE LINE MONTHLY CHARGES P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ACCT#287291817096 8/20- 1.0000 EA 2,170.6500 2,170.65 9/19 DATA&PHONE LINE MONTHLY CHARGES GIL Account Project Amount 010-11-1160 1512(General Fund-Police Department-Law Enforcement 11TRI.TRIF(TRI-COUNTY TASK FORCE,TRI-COUNTY 99.32 Programs Tri-Co Forfeiture Distributions) FORFEITURE FUNDS RECEIVED) 010-11-1105 1321 (General Fund-Police Department-Police Computer 2,071.33 Services Data Processing Services) Invoice Items 1 Vendor 21785-AT&T MOBILITY LLC Totals Invoices 1 $2,170.65 Vendor 13217-AUTO PLUS AUTO PARTS 001-393318 LOAD EQLZR ALUM Edit 09/18/2020 10/05/2020 10/05/2020 12.06 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- LOAD EQLZR ALUM 1.0000 EA 12.0600 12.06 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 12.06 Service Machinery&Equipment Replacement Parts) Invoice Items 1 001-393326 RAVEN POWDER FREE/FOAMY Edit 09/18/2020 10/05/2020 10/05/2020 54.15 GUNKR ENG P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- RAVEN POWDER 1.0000 EA 54.1500 54.15 FREE/FOAMY GUNKR ENG GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 26.16 Service Machinery&Equipment Replacement Parts) 010-18-7950 1571 (General Fund-Central Garage-Central Garage 27.99 Machinery&Equipment Replacement Parts) Invoice Items 1 Vendor 13217-AUTO PLUS AUTO PARTS Totals Invoices 2 $66.21 Vendor 8204-B&B LAWN CARE SERVICE 1270 AUG 2020 MOWING; MISC LOTS Edit 09/08/2020 10/05/2020 10/05/2020 8,610.16 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-AUG 2020 MOWING; MISC 1.0000 EA 8,610.1600 8,610.16 LOTS GIL Account Project Amount Run by Emily Graham on 10/02/2020 12:23:03 PM Page 33 of 119 Page 12 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 1270 AUG 2020 MOWING; MISC LOTS Edit 09/08/2020 10/05/2020 10/05/2020 8,610.16 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 010-08-5885 1371 (General Fund-Planning&Zoning-City Property 08PRO.MTCE(SPECIAL PROJECTS,GENERAL CITY 8,610.16 Management Building&Grounds Maintenance) PROPERTY MAINTENANCE) Invoice Items 1 Vendor 8204-B&B LAWN CARE SERVICE Totals Invoices 1 $8,610.16 Vendor 107-BAKER&TAYLOR 2035485127 YOUTH PRINT Edit 09/23/2020 10/05/2020 10/05/2020 14.12 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-YOUTH PRINT 1.0000 EA 14.1200 14.12 GIL Account Project Amount 010-33-3100 1590(General Fund-Library-Library Services Youth Print 14.12 Materials) Invoice Items 1 2035485128 YOUTH PRINT Edit 09/23/2020 10/05/2020 10/05/2020 11.23 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-YOUTH PRINT 1.0000 EA 11.2300 11.23 GIL Account Project Amount 010-33-3100 1590(General Fund-Library-Library Services Youth Print 11.23 Materials) Invoice Items 1 2035485132 YOUTH PRINT Edit 09/23/2020 10/05/2020 10/05/2020 51.98 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-YOUTH PRINT 1.0000 EA 51.9800 51.98 GIL Account Project Amount 010-33-3100 1590(General Fund-Library-Library Services Youth Print 51.98 Materials) Invoice Items 1 2035485133 YOUTH PRINT Edit 09/23/2020 10/05/2020 10/05/2020 17.59 P.O.Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-YOUTH PRINT 1.0000 EA 17.5900 17.59 GIL Account Project Amount 010-33-3100 1590(General Fund-Library-Library Services Youth Print 17.59 Materials) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 34 of 119 Page 13 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 2035485134 TEEN PRINT Edit 09/23/2020 10/05/2020 10/05/2020 14.10 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-TEEN PRINT 1.0000 EA 14.1000 14.10 GIL Account Project Amount 010-33-3100 1593(General Fund-Library-Library Services Teen Print 14.10 Materials) Invoice Items 1 2035485135 YOUTH PRINT Edit 09/23/2020 10/05/2020 10/05/2020 56.86 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-YOUTH PRINT 1.0000 EA 56.8600 56.86 GIL Account Project Amount 010-33-3100 1590(General Fund-Library-Library Services Youth Print 56.86 Materials) Invoice Items 1 2035485136 TEEN PRINT Edit 09/23/2020 10/05/2020 10/05/2020 14.12 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-TEEN PRINT 1.0000 EA 14.1200 14.12 GIL Account Project Amount 010-33-3100 1593(General Fund-Library-Library Services Teen Print 14.12 Materials) Invoice Items 1 2035485137 YOUTH PRINT Edit 09/23/2020 10/05/2020 10/05/2020 49.38 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-YOUTH PRINT 1.0000 EA 49.3800 49.38 GIL Account Project Amount 010-33-3100 1590(General Fund-Library-Library Services Youth Print 49.38 Materials) Invoice Items 1 2035485138 TEEN PRINT Edit 09/23/2020 10/05/2020 10/05/2020 10.64 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-TEEN PRINT 1.0000 EA 10.6400 10.64 GIL Account Project Amount 010-33-3100 1593(General Fund-Library-Library Services Teen Print 10.64 Materials) Invoice Items 1 Vendor 107-BAKER&TAYLOR Totals Invoices 9 $240.02 Vendor 114-BAUER BUILT INC. Run by Emily Graham on 10/02/2020 12:23:03 PM Page 35 of 119 Page 14 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 210060783 SPARTACUS ATVS Edit 09/15/2020 10/05/2020 10/05/2020 442.56 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SPARTACUS ATVS 1.0000 EA 442.5600 442.56 GIL Account Project Amount 010-18-7955 1569(General Fund-Central Garage-Garage-Motor Pool 442.56 Service Vehicle Replacement Parts) Invoice Items 1 Vendor 114-BAUER BUILT INC.Totals Invoices 1 $442.56 Vendor 20722-BBE PRO TOOLS LLC 63458 SAW KIT Edit 09/10/2020 10/05/2020 10/05/2020 269.99 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SAW KIT 1.0000 EA 269.9900 269.99 GIL Account Project Amount 010-18-7950 1571 (General Fund-Central Garage-Central Garage 269.99 Machinery&Equipment Replacement Parts) Invoice Items 1 Vendor 20722-BBE PRO TOOLS LLC Totals Invoices 1 $269.99 Vendor 8069-BDI 9501452577 LANDPRIDE BELTS Edit 09/21/2020 10/05/2020 10/05/2020 147.84 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-LANDPRIDE BELTS 1.0000 EA 147.8400 147.84 GIL Account Project Amount 010-37-4100 1569(General Fund-Leisure Services-Leisure Services-Parks 147.84 Vehicle Replacement Parts) Invoice Items 1 Vendor 8069-BDI Totals Invoices 1 $147.84 Vendor 22038-SUZANNE KAY BELLINGER SEP20RR SEPTEMBER RUN REVIEW EMS Edit 09/28/2020 10/05/2020 10/05/2020 90.00 TRAINING P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item 1.0000 EA 90.0000 90.00 GIL Account Project Amount 010-12-1410 1315(General Fund-Fire Department-Fire Ambulance 90.00 Service Educational&Training Services) Invoice Items 1 Vendor 22038-SUZANNE KAY BELLINGER Totals Invoices 1 $90.00 Vendor 9720-BERGEN PLUMBING Run by Emily Graham on 10/02/2020 12:23:03 PM Page 36 of 119 Page 15 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 32728412 RT-REPAIR WATER LEAK IST Edit 09/23/2020 10/05/2020 10/05/2020 108.58 FLOOR HALLWAY P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- RT-WATER SHUT DOWN 1.0000 EA 108.5800 108.58 AND DRAINING WATER PRESSURE DOWN GIL Account Project Amount 283-13-5450 1371 (Housing Programs-Housing Authority-Ridgeway 108.58 Towers Building&Grounds Maintenance) Invoice Items 1 32771448 RT-REPAIR LEAKING SHOWER Edit 09/23/2020 10/05/2020 10/05/2020 324.18 APT#111 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- RT- ROOM #101 ABOVE 1.0000 EA 324.1800 324.18 CEILING WATER LINES GIL Account Project Amount 283-13-5450 1371 (Housing Programs-Housing Authority-Ridgeway 324.18 Towers Building&Grounds Maintenance) Invoice Items 1 Vendor 9720-BERGEN PLUMBING Totals Invoices 2 $432.76 Vendor 144-BITUMINOUS MATERIAL&SUPPLY, 2213241834 CRS-2 Edit 09/21/2020 10/05/2020 10/05/2020 27,851.13 P.O.Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CRS-2 1.0000 EA 27,851.1300 27,851.13 GIL Account Project Amount 205-19-7110 1513(Local Option Sales Tax-Street Department-Seal 27,851.13 Coating Program Chemicals&Gases) Invoice Items 1 Vendor 144-BITUMINOUS MATERIAL&SUPPLY,Totals Invoices 1 $27,851.13 Vendor 148-BLACK HAWK COUNTY ATTORNEY JULY 2020 REIMBURSE TRI COUNTY JULY Edit 09/28/2020 10/05/2020 10/05/2020 9,358.20 2020 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-REIMBURSE TRI COUNTY 1.0000 EA 9,358.2000 9,358.20 JULY 2020 GIL Account Project Amount 010-11-1160 1302(General Fund-Police Department-Law Enforcement 11TRI.TF21(TRI-COUNTY TASK FORCE,TRI-CO 9,358.20 Programs Tri-County Outside Agency Expense) BYRNE JUSTICE ASSISTANCE GRANT(JAG)FY2021) Invoice Items 1 Vendor 148- BLACK HAWK COUNTY ATTORNEY Totals Invoices 1 $9,358.20 Vendor 170-BLACK HAWK COUNTY SHERIFF Run by Emily Graham on 10/02/2020 12:23:03 PM Page 37 of 119 Page 16 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount JULY 2020 REIMBURSE TRI COUNTY JULY Edit 09/28/2020 10/05/2020 10/05/2020 5,580.00 2020 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-REIMBURSE TRI COUNTY 1.0000 EA 5,580.0000 5,580.00 JULY 2020 GIL Account Project Amount 010-11-1160 1302(General Fund-Police Department-Law Enforcement 11TRI.TF21(TRI-COUNTY TASK FORCE,TRI-CO 5,580.00 Programs Tri-County Outside Agency Expense) BYRNE JUSTICE ASSISTANCE GRANT(JAG)FY2021) Invoice Items 1 Vendor 170-BLACK HAWK COUNTY SHERIFF Totals Invoices 1 $5,580.00 Vendor 6828-BLACK HAWK MEMORIAL CO,INC 2020-00002711 CHARGES FOR 3 BRICKS Edit 06/29/2020 10/05/2020 10/05/2020 75.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CHARGES FOR 3 BRICKS 1.0000 EA 75.0000 75.00 GIL Account Project Amount 010-22-8820 1539(General Fund-Building Inspection-Facilities Restricted 01MYR.0009(MAYORS RESTRICTED PROJECTS, 75.00 Project Institutional Supplies) VETERANS MEMORIAL BRICK WALKWAY) Invoice Items 1 2021-00000591 CHARGES FOR 2 BRICKS Edit 08/18/2020 10/05/2020 10/05/2020 50.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CHARGES FOR 2 BRICKS 1.0000 EA 50.0000 50.00 GIL Account Project Amount 010-22-8820 1539(General Fund-Building Inspection-Facilities Restricted 01MYR.0009(MAYORS RESTRICTED PROJECTS, 50.00 Project Institutional Supplies) VETERANS MEMORIAL BRICK WALKWAY) Invoice Items 1 Vendor 6828-BLACK HAWK MEMORIAL CO,INC Totals Invoices 2 $125.00 Vendor 162-BLACK HAWK RENTAL 306270-1 CAP/WEED TRIMMER SERVICE Edit 09/18/2020 10/05/2020 10/05/2020 41.25 KIT P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CAP/WEED TRIMMER 1.0000 EA 41.2500 41.25 SERVICE KIT GIL Account Project Amount 520-14-5200 1371 (Sanitary Sewer Fund-Waste Management-Water 41.25 Pollution-Water Pollution Control Plant Op Building&Grounds Maintenance) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 38 of 119 Page 17 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 306591-2 WATER TANK./CHOP SAW Edit 09/23/2020 10/05/2020 10/05/2020 1,151.71 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-WATER TANK./CHOP SAW 1.0000 EA 1,151.7100 1,151.71 GIL Account Project Amount 520-14-5200 1571 (Sanitary Sewer Fund-Waste Management-Water 1,151.71 Pollution-Water Pollution Control Plant Op Machinery&Equipment Replacement Parts) Invoice Items 1 Vendor 162-BLACK HAWK RENTAL Totals Invoices 2 $1,192.96 Vendor 8352-BLACK HAWK ROOF CO INC 3526 PATCHED HOLES Edit 09/18/2020 10/05/2020 10/05/2020 312.80 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- PATCHED HOLES 1.0000 EA 312.8000 312.80 GIL Account Project Amount 010-37-4180 1319(General Fund-Leisure Services-SportsPlex Other 37SPLX.OPER(CEDAR VALLEY SPORTSPLEX, 312.80 Professional Services) SPORTSPLEX OPERATIONS) Invoice Items 1 Vendor 8352-BLACK HAWK ROOF CO INC Totals Invoices 1 $312.80 Vendor 21628-BOOMERANG CORP 09232020 CONT 877 DRY RUN CREEK Edit 09/23/2020 10/05/2020 10/05/2020 233,881.26 ESTIMATE NO. 07 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CONT 877 DRY RUN CREEK 1.0000 EA 233,881.2600 233,881.26 ESTIMATE NO. 07 GIL Account Project Amount 520-14-5375 2163(Sanitary Sewer Fund-Waste Management-Water 14SRF.DRYRNSWR(STATE REVOLVING LOAN FUND, 233,881.26 Pollution-Sewer Coll Systm Impr-SRF/Grnt Sanitary Sewers) DRY RUN CREEK SANITARY INTERCEPTOR SEWER) Invoice Items 1 Vendor 21628- BOOMERANG CORP Totals Invoices 1 $233,881.26 Vendor 8449-BOUND TREE MEDICAL LLC 83769527 PEDIATRIC EXTRICATION Edit 09/28/2020 10/05/2020 10/05/2020 314.50 COLLAR P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- PEDIATRIC EXTRICATION 1.0000 EA 314.5000 314.50 COLLAR GIL Account Project Amount 010-12-1410 1551 (General Fund-Fire Department-Fire Ambulance 314.50 Service Drugs/Medicines&Medical/Lab Supplies) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 39 of 119 Page 18 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 83771264 COVID-MASK WITH VISOR Edit 09/28/2020 10/05/2020 10/05/2020 91.29 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-COVID-MASK WITH VISOR 1.0000 EA 91.2900 91.29 GIL Account Project Amount 010-12-1410 1551 (General Fund-Fire Department-Fire Ambulance 91.29 Service Drugs/Medicines&Medical/Lab Supplies) Invoice Items 1 Vendor 8449-BOUND TREE MEDICAL LLC Totals Invoices 2 $405.79 Vendor 21979-BROCK EVEN CONSTRUCTION LLC 1009-8 CONTRACT#1009 FY 2020 Edit 09/04/2020 10/05/2020 10/05/2020 59,506.49 SIDEWALK&TRAIL REPAIR PROGRAM ZONE 10 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CONTRACT#1009 FY 2020 1.0000 EA 59,506.4900 59,506.49 SIDEWALK&TRAIL REPAIR PROGRAM ZONE 10 GIL Account Project Amount 419-07-7650 2164(June 2019 GO Bond Fund-City Engineer-Sidewalk 59,506.49 Repair/Construction Sidewalks) Invoice Items 1 1009-9 CONT 1009 SIDEWALK TRAIL Edit 09/28/2020 10/05/2020 10/05/2020 5,525.61 PROGRAM P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CONT 1009 SIDEWALK 1.0000 EA 5,525.6100 5,525.61 TRAIL PROGRAM GIL Account Project Amount 419-07-7650 2164(June 2019 GO Bond Fund-City Engineer-Sidewalk 5,525.61 Repair/Construction Sidewalks) Invoice Items 1 Vendor 21979- BROCK EVEN CONSTRUCTION LLC Totals Invoices 2 $65,032.10 Vendor 207-BRODART COMPANY B5970508 ADULT PRINT Edit 09/21/2020 10/05/2020 10/05/2020 158.43 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 158.4300 158.43 GIL Account Project Amount 010-33-3100 1582(General Fund-Library-Library Services Adult Print 158.43 Materials) Invoice Items 1 Vendor 207-BRODART COMPANY Totals Invoices 1 $158.43 Vendor 208-BROTHERS CONSTRUCTION Run by Emily Graham on 10/02/2020 12:23:03 PM Page 40 of 119 Page 19 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 1538 ESTIMATE#1-714 HOPE Edit 09/25/2020 10/05/2020 10/05/2020 09/28/2020 5,449.00 AVENUE-LEAD P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ESTIMATE#1-714 HOPE 1.0000 EA 5,449.0000 5,449.00 AVENUE-LEAD GIL Account Project Amount 224-32-5853 1327(Community Develop Block Grant-Community BGLEDI8.REHAB(LEAD GRANT, LEAD GRANT REHAB) 5,449.00 Development-Lead Paint Grant Residential Rehabilitation) Invoice Items 1 Vendor 208-BROTHERS CONSTRUCTION Totals Invoices 1 $5,449.00 Vendor 7986-C.J.COOPER&ASSOC.INC 159871 HR RANDOM DRUG SCREENINGS Edit 09/22/2020 10/05/2020 10/05/2020 70.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SANITATION DRUG 2.0000 EA 35.0000 70.00 SCREENINGS GIL Account Project Amount 525-15-5400 1314(Sanitation Fund-Waste Management-Sanitation-Solid 70.00 Waste Disposal Health Services) Invoice Items 1 Vendor 7986-C.J.COOPER&ASSOC.INC Totals Invoices 1 $70.00 Vendor 221-CAMPBELL SUPPLY CO INV-00175990 FLAGS STAKE RED 100/PK Edit 09/18/2020 10/05/2020 10/05/2020 14.30 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- FLAGS STAKE RED 100/PK 1.0000 EA 14.3000 14.30 GIL Account Project Amount 520-14-5200 1571 (Sanitary Sewer Fund-Waste Management-Water 14.30 Pollution-Water Pollution Control Plant Op Machinery&Equipment Replacement Parts) Invoice Items 1 INV-00176166 SHOCKWAVE 2 PWR BIT TX 125 Edit 09/18/2020 10/05/2020 10/05/2020 7.40 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SHOCKWAVE 2 PWR BIT TX 1.0000 EA 7.4000 7.40 125 GIL Account Project Amount 520-14-5200 1571 (Sanitary Sewer Fund-Waste Management-Water 7.40 Pollution-Water Pollution Control Plant Op Machinery&Equipment Replacement Parts) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 41 of 119 Page 20 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount INV-00176237 INV UTIL YLW PNT Edit 09/18/2020 10/05/2020 10/05/2020 6.10 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-INV UTIL YLW PNT 1.0000 EA 6.1000 6.10 GIL Account Project Amount 520-14-5200 1571 (Sanitary Sewer Fund-Waste Management-Water 6.10 Pollution-Water Pollution Control Plant Op Machinery&Equipment Replacement Parts) Invoice Items 1 INV-00177525 HEX KEY Edit 09/23/2020 10/05/2020 10/05/2020 34.32 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-HEX KEY 1.0000 EA 34.3200 34.32 GIL Account Project Amount 520-14-5200 1535(Sanitary Sewer Fund-Waste Management-Water 34.32 Pollution-Water Pollution Control Plant Op Hardware Items) Invoice Items 1 INV-00177426 GLOVES&GLOVES FOR CITY Edit 09/23/2020 10/05/2020 10/05/2020 215.04 WIDE CLEANUP P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-GLOVES&GLOVES FOR 1.0000 EA 215.0400 215.04 CITY WIDE CLEANUP GIL Account Project Amount 525-15-5400 1573(Sanitation Fund-Waste Management-Sanitation-Solid 215.04 Waste Disposal Safety&Protective Equipment) Invoice Items 1 Vendor 221-CAMPBELL SUPPLY CO Totals Invoices 5 $277.16 Vendor 6169-CDW GOVERNMENT,LLC 1047859 BLACK BOX FIBER 1M PATCH Edit 09/08/2020 10/05/2020 10/05/2020 09/08/2020 74.06 CABLE P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- BLACK BOX FIBER 1M SM 9 7.0000 EA 10.5800 74.06 MICRON SC-LC GIL Account Project Amount 010-01-8220 1516(General Fund-Mayor-Administrative SVCS/MIS Minor 74.06 Computer Equipment) Invoice Items 1 1060010 TRIPP POWER STRIP Edit 09/09/2020 10/05/2020 10/05/2020 09/09/2020 64.43 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-TRIPP POWER STRIP 12 1.0000 EA 64.4300 64.43 OUTLET URM GIL Account Project Amount Run by Emily Graham on 10/02/2020 12:23:03 PM Page 42 of 119 Page 21 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 1060010 TRIPP POWER STRIP Edit 09/09/2020 10/05/2020 10/05/2020 09/09/2020 64.43 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 010-01-8220 1516(General Fund-Mayor-Administrative SVCS/MIS Minor 64.43 Computer Equipment) Invoice Items 1 1107859 BLACKBOX FIBER 1M SM 9 Edit 09/09/2020 10/05/2020 10/05/2020 09/09/2020 31.74 MICRON LC-SC P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- BLACK BOX FIBER 1M SM 9 3.0000 EA 10.5800 31.74 MICRON SC-LC GIL Account Project Amount 010-01-8220 1516(General Fund-Mayor-Administrative SVCS/MIS Minor 31.74 Computer Equipment) Invoice Items 1 1688770 BLACKBOX 2M ST ST FIBER Edit 09/21/2020 10/05/2020 10/05/2020 09/21/2020 19.72 CONNECTORS P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- BLACKBOX 2M ST/ST FIBER 1.0000 EA 19.7200 19.72 PATCH CABLES GIL Account Project Amount 010-01-8220 1516(General Fund-Mayor-Administrative SVCS/MIS Minor 19.72 Computer Equipment) Invoice Items 1 Vendor 6169-CDW GOVERNMENT,LLC Totals Invoices 4 $189.95 Vendor 245-CEDAR FALLS POLICE DIVISION JULY 2020 REIMBURSE TRI COUNTY JULY Edit 09/28/2020 10/05/2020 10/05/2020 5,971.80 2020 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- REIMBURSE TRI COUNTY 1.0000 EA 5,971.8000 5,971.80 JULY 2020 GIL Account Project Amount 010-11-1160 1302(General Fund-Police Department-Law Enforcement 11TRI.TF21(TRI-COUNTY TASK FORCE,TRI-CO 5,971.80 Programs Tri-County Outside Agency Expense) BYRNE JUSTICE ASSISTANCE GRANT(JAG)FY2021) Invoice Items 1 Vendor 245-CEDAR FALLS POLICE DIVISION Totals Invoices 1 $5,971.80 Vendor 10986-CENTER FOR BEHAVIORAL HEALTH Run by Emily Graham on 10/02/2020 12:23:03 PM Page 43 of 119 Page 22 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 2021-00000574 MMPI-2 FOR POTENTIAL NEW Edit 09/19/2020 10/05/2020 10/05/2020 200.00 HIRE C. KUBLI P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- MMPI-2 FOR POTENTIAL 1.0000 EA 200.0000 200.00 NEW HIRE C. KUBLI GIL Account Project Amount 010-11-1100 1314(General Fund-Police Department-Police Operations 200.00 Health Services) Invoice Items 1 Vendor 10986-CENTER FOR BEHAVIORAL HEALTH Totals Invoices 1 $200.00 Vendor 20537-CONSTANT CONTACT,INC. WBX8WT4AB26920 MASS E-MAIL MARKETING FOR Edit 09/25/2020 10/05/2020 10/05/2020 1,890.00 15001-25000 CONTACTS P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- MASS E-MAIL MARKETING 1.0000 EA 1,890.0000 1,890.00 FOR 15001-25000 CONTACTS GIL Account Project Amount 010-33-3100 1339(General Fund-Library-Library Services Data 1,890.00 Communication) Invoice Items 1 Vendor 20537-CONSTANT CONTACT,INC.Totals Invoices 1 $1,890.00 Vendor 21282-CONVEY SIGN SOLUTIONS,INC INV-91971 SIGNAGE FOR P.PERFECT& Edit 09/23/2020 10/05/2020 10/05/2020 246.48 gUATEMALAN EXHIBIT P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SIGNAGE FOR P.PERFECT& 1.0000 EA 246.4800 246.48 gUATEMALAN EXHIBIT GIL Account Project Amount 010-26-4208 1350(General Fund-Cultural/Arts Commission-Youth 246.48 Pavilion Exhibition Expenses) Invoice Items 1 Vendor 21282-CONVEY SIGN SOLUTIONS,INC Totals Invoices 1 $246.48 Vendor 12407-COOK COUNTY HOUSING AUTHORITY 10/01/2020 HAP&AF-ANDREA GARDNER Edit 09/28/2020 10/05/2020 10/05/2020 1,840.13 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-AF-ANDREA GARDNER 1.0000 EA 47.1300 47.13 GIL Account Project Amount 283-13-5452 1706(Housing Programs-Housing Authority-Section 8 47.13 Housing Assistance Payments) Run by Emily Graham on 10/02/2020 12:23:03 PM Page 44 of 119 Page 23 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 10/01/2020 HAP&AF-ANDREA GARDNER Edit 09/28/2020 10/05/2020 10/05/2020 1,840.13 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-HAP-ANDREA GARDNER 1.0000 EA 1,793.0000 1,793.00 GIL Account Project Amount 283-13-5452 1706(Housing Programs-Housing Authority-Section 8 1,793.00 Housing Assistance Payments) Invoice Items 2 Vendor 12407-COOK COUNTY HOUSING AUTHORITY Totals Invoices 1 $1,840.13 Vendor 20229-COPY SYSTEMS,INC IN389023 SERVICE CALL CHARGES Edit 09/24/2020 10/05/2020 10/05/2020 40.95 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SERVICE CALL CHARGES 1.0000 EA 40.9500 40.95 GIL Account Project Amount 010-03-8400 1561 (General Fund-City Clerk&Finance-City Clerk& 40.95 Finance Office Supplies&Minor Equipment) Invoice Items 1 Vendor 20229-COPY SYSTEMS,INC Totals Invoices 1 $40.95 Vendor 7625-COURIER 186970-1 HR CLASSIFIED AD JOB POSTING Edit 09/01/2020 10/05/2020 10/05/2020 123.40 FINANCE MGR P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- FINANCE MANAGER JOB 1.0000 EA 123.4000 123.40 POSTING GIL Account Project Amount 010-09-8250 1351 (General Fund-Human Resources-Human Resources 123.40 Advertising Expense) Invoice Items 1 187653 BOA; 1407 INDEPENDENCE AVE Edit 09/16/2020 10/05/2020 10/05/2020 12.07 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- BOA; 1407 INDEPENDENCE 1.0000 EA 12.0700 12.07 AVE GIL Account Project Amount 010-08-5700 1351 (General Fund-Planning&Zoning-Planning&Zoning 12.07 Advertising Expense) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 45 of 119 Page 24 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 187652 BOA;W OF 5605 ANSBOROUGH Edit 09/17/2020 10/05/2020 10/05/2020 16.60 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-BOA;W OF 5605 1.0000 EA 16.6000 16.60 ANSBOROUGH GIL Account Project Amount 010-08-5700 1351 (General Fund-Planning&Zoning-Planning&Zoning 16.60 Advertising Expense) Invoice Items 1 187654 BOA; 326 HIGHLAND BLVD Edit 09/17/2020 10/05/2020 10/05/2020 11.07 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- BOA; 326 HIGHLAND BLVD 1.0000 EA 11.0700 11.07 GIL Account Project Amount 010-08-5700 1351 (General Fund-Planning&Zoning-Planning&Zoning 11.07 Advertising Expense) Invoice Items 1 187658 BHC SEPT BOA AGENDA Edit 09/17/2020 10/05/2020 10/05/2020 15.09 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- BHC SEPT BOA AGENDA 1.0000 EA 15.0900 15.09 GIL Account Project Amount 010-08-5700 1351 (General Fund-Planning&Zoning-Planning&Zoning 15.09 Advertising Expense) Invoice Items 1 Vendor 7625-COURIER Totals Invoices 5 $178.23 Vendor 4577-D&J OIL COMPANY 71042 GASOLINE-SHOP Edit 09/23/2020 10/05/2020 10/05/2020 885.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-GASOLINE-SHOP 1.0000 EA 885.0000 885.00 GIL Account Project Amount 010-37-4100 1533(General Fund-Leisure Services-Leisure Services-Parks 885.00 Fuel Expense) Invoice Items 1 Vendor 4577-D&J OIL COMPANY Totals Invoices 1 $885.00 Vendor 388-DELL MARKETING L.P. 10425243154 DELL OPTIPLEX 7070 TOWER Edit 09/19/2020 10/05/2020 10/05/2020 09/19/2020 1,744.56 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- DELL OPTIPLEX 7070 MT 2.0000 EA 872.2800 1,744.56 XCTO GIL Account Project Amount Run by Emily Graham on 10/02/2020 12:23:03 PM Page 46 of 119 Page 25 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 10425243154 DELL OPTIPLEX 7070 TOWER Edit 09/19/2020 10/05/2020 10/05/2020 09/19/2020 1,744.56 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 420-01-8225 2106(June 2020 GO Bond Fund-Mayor-MIS Capital 1,744.56 Computer Equipment) Invoice Items 1 10426062003 DELL 24 MONITORS Edit 09/23/2020 10/05/2020 10/05/2020 09/23/2020 712.28 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-DELL 24 INCH MONITOR 4.0000 EA 178.0700 712.28 P2419H GIL Account Project Amount 420-01-8225 2106(June 2020 GO Bond Fund-Mayor-MIS Capital 712.28 Computer Equipment) Invoice Items 1 Vendor 388-DELL MARKETING L.P.Totals Invoices 2 $2,456.84 Vendor 389-DELTA DENTAL OF IOWA 3255900000202029 DENTAL CLAIMS PAID 9/1/20 TO Edit 09/30/2020 10/05/2020 10/05/2020 54,494.15 9/30/20 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-DENTAL CLAIMS PAID 1.0000 EA 55,751.7300 55,751.73 GIL Account Project Amount 010-03-8950 1367(General Fund-City Clerk&Finance-Self Funded 55,751.73 Health Insurance Dental Claims) Conversion Item- EE CONTRIBUTION CK# 1.0000 EA (1,257.5800) (1,257.58) 285936 GIL Account Project Amount 010-03-8950 3829(General Fund-City Clerk&Finance-Self Funded (1,257.58) Health Insurance Employee Contributions) Invoice Items 2 Vendor 389-DELTA DENTAL OF IOWA Totals Invoices 1 $54,494.15 Vendor 1599-DICK WITHAM FORD 267873 HOSE ASY/SEALS/PIPE Edit 09/16/2020 10/05/2020 10/05/2020 489.96 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-HOSE ASY/SEALS/PIPE 1.0000 EA 489.9600 489.96 GIL Account Project Amount 010-18-1411 1571 (General Fund-Central Garage-Ambulance-Garage 489.96 Parts&Service Machinery&Equipment Replacement Parts) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 47 of 119 Page 26 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 267899 ROTOR ASY/OIL/SPARK Edit 09/16/2020 10/05/2020 10/05/2020 476.36 PLUGS/BOOTS P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ROTOR ASY/OIL/SPARK 1.0000 EA 476.3600 476.36 PLUGS/BOOTS GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 476.36 Service Machinery&Equipment Replacement Parts) Invoice Items 1 267950 CLIP Edit 09/17/2020 10/05/2020 10/05/2020 59.70 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CLIP 1.0000 EA 59.7000 59.70 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 59.70 Service Machinery&Equipment Replacement Parts) Invoice Items 1 267935 VALVE ASY Edit 09/18/2020 10/05/2020 10/05/2020 69.96 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-VALVE ASY 1.0000 EA 69.9600 69.96 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 69.96 Service Machinery&Equipment Replacement Parts) Invoice Items 1 267990 CLIP Edit 09/21/2020 10/05/2020 10/05/2020 39.76 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CLIP 1.0000 EA 39.7600 39.76 GIL Account Project Amount 010-18-1411 1571 (General Fund-Central Garage-Ambulance-Garage 39.76 Parts&Service Machinery&Equipment Replacement Parts) Invoice Items 1 267991 COIL ASY/SPARK PLUG/MOTOR Edit 09/21/2020 10/05/2020 10/05/2020 263.90 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-COIL ASY/SPARK 1.0000 EA 263.9000 263.90 PLUG/MOTOR GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 263.90 Service Machinery&Equipment Replacement Parts) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 48 of 119 Page 27 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 268064 REPAIR PARTS#103 Edit 09/22/2020 10/05/2020 10/05/2020 19.15 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-REPAIR PARTS#103 1.0000 EA 19.1500 19.15 GIL Account Project Amount 010-37-4100 1569(General Fund-Leisure Services-Leisure Services-Parks 19.15 Vehicle Replacement Parts) Invoice Items 1 268072 BRACKET#103 Edit 09/22/2020 10/05/2020 10/05/2020 49.74 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-BRACKET#103 1.0000 EA 49.7400 49.74 GIL Account Project Amount 010-37-4100 1569(General Fund-Leisure Services-Leisure Services-Parks 49.74 Vehicle Replacement Parts) Invoice Items 1 Vendor 1599-DICK WITHAM FORD Totals Invoices 8 $1,468.53 Vendor 328-DICKEY'S PRINTING 45246 SHIRTS FOR FLAG FOOTBALL Edit 09/24/2020 10/05/2020 10/05/2020 2,040.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SHIRTS FOR FLAG 1.0000 EA 2,040.0000 2,040.00 FOOTBALL GIL Account Project Amount 010-37-4200 1567(General Fund-Leisure Services-Sports&Youth 2,040.00 Services Recreational Equipment&Supplies) Invoice Items 1 Vendor 328-DICKEY'S PRINTING Totals Invoices 1 $2,040.00 Vendor 1206-DIGITECH 21210 JULY BILLING Edit 09/28/2020 10/05/2020 10/05/2020 27,287.68 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-JULY BILLING 1.0000 EA 27,287.6800 27,287.68 GIL Account Project Amount 010-12-1410 1311 (General Fund-Fire Department-Fire Ambulance 27,287.68 Service Accounting&Clerical Service) Invoice Items 1 21370 AUGUST BILLING Edit 09/28/2020 10/05/2020 10/05/2020 7,207.05 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-AUGUST BILLING 1.0000 EA 7,207.0500 7,207.05 GIL Account Project Amount 010-12-1410 1311 (General Fund-Fire Department-Fire Ambulance 7,207.05 Service Accounting&Clerical Service) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 49 of 119 Page 28 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 1206-DIGITECH Totals Invoices 2 $34,494.73 Vendor 21539-DUPACO CREDIT UNION 2021-00000595 DOWNPAYMENT FOR KIMBERLY Edit 09/25/2020 10/05/2020 10/05/2020 3,500.00 CALDWELL P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- DOWNPAYMENT FOR 1.0000 EA 3,500.0000 3,500.00 KIMBERLY CALDWELL GIL Account Project Amount 283-13-5455 1393(Housing Programs-Housing Authority-Down Payment 3,500.00 Assistance Contributions&Subsidies) Invoice Items 1 Vendor 21539-DUPACO CREDIT UNION Totals Invoices 1 $3,500.00 Vendor 454-ELECTRICAL ENGINEERING&EQUIP 6893609-00 ELECTRICAL SUPPLIES FOR 3RD Edit 09/14/2020 10/05/2020 10/05/2020 10.08 FLOOR CRIME LAB P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- ELECTRICAL SUPPLIES FOR 1.0000 EA 10.0800 10.08 3RD FLOOR CRIME LAB GIL Account Project Amount 418-11-1100 2152(June 2018 GO Bond Fund-Police Department-Police 10.08 Operations Building Improvements) Invoice Items 1 6891510-00 ROUND COVER Edit 09/10/2020 10/05/2020 10/05/2020 6.26 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ROUND COVER 1.0000 EA 6.2600 6.26 GIL Account Project Amount 266-17-7120 1521 (Road Use Tax-Traffic Operations-Traffic Safety 6.26 Electrical Supplies) Invoice Items 1 6901490-00 ELECTRICAL SUPPLIES Edit 09/22/2020 10/05/2020 10/05/2020 58.56 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ELECTRICAL SUPPLIES 1.0000 EA 58.5600 58.56 GIL Account Project Amount 520-14-5200 1521 (Sanitary Sewer Fund-Waste Management-Water 58.56 Pollution-Water Pollution Control Plant Op Electrical Supplies) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 50 of 119 Page 29 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 6902625-00 ELECTRICAL SUPPLIES Edit 09/22/2020 10/05/2020 10/05/2020 67.98 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ELECTRICAL SUPPLIES 1.0000 EA 67.9800 67.98 GIL Account Project Amount 520-14-5200 1521 (Sanitary Sewer Fund-Waste Management-Water 67.98 Pollution-Water Pollution Control Plant Op Electrical Supplies) Invoice Items 1 6904388-00 INT ELC4536 Edit 09/23/2020 10/05/2020 10/05/2020 58.56 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-INT ELC4536 1.0000 EA 58.5600 58.56 GIL Account Project Amount 520-14-5200 1521 (Sanitary Sewer Fund-Waste Management-Water 58.56 Pollution-Water Pollution Control Plant Op Electrical Supplies) Invoice Items 1 6902205-00 2PRTINS TAP CONS/RED BUSH Edit 09/24/2020 10/05/2020 10/05/2020 339.27 BUSHINGS P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-2PRT INS TAP CONS/RED 1.0000 EA 339.2700 339.27 BUSH BUSHINGS GIL Account Project Amount 520-14-5200 1521 (Sanitary Sewer Fund-Waste Management-Water 339.27 Pollution-Water Pollution Control Plant Op Electrical Supplies) Invoice Items 1 Vendor 454-ELECTRICAL ENGINEERING&EQUIP Totals Invoices 6 $540.71 Vendor 7178-EMSLRC 30847 EMS CLASS 20-1800-099FE Edit 09/28/2020 10/05/2020 10/05/2020 20.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-EMS CLASS 20-1800-099FE 1.0000 EA 20.0000 20.00 GIL Account Project Amount 010-12-1410 1315(General Fund-Fire Department-Fire Ambulance 20.00 Service Educational&Training Services) Invoice Items 1 30848 EMS CLASS 20-1800-100FE Edit 09/28/2020 10/05/2020 10/05/2020 20.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- EMS CLASS 20-1800-100FE 1.0000 EA 20.0000 20.00 GIL Account Project Amount 010-12-1410 1315(General Fund-Fire Department-Fire Ambulance 20.00 Service Educational&Training Services) Invoice Items 1 Vendor 7178-EMSLRC Totals Invoices 2 $40.00 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 51 of 119 Page 30 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 471-EXPRESS SERVICES,INC. 24385719 TAMRA GONZALES, MARY Edit 09/16/2020 10/05/2020 10/05/2020 536.76 HOLMAN P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-TAMRA GONZALES, MARY 1.0000 EA 536.7600 536.76 HOLMAN GIL Account Project Amount 525-15-5400 1301 (Sanitation Fund-Waste Management-Sanitation-Solid 536.76 Waste Disposal Temp Agency Services) Invoice Items 1 Vendor 471-EXPRESS SERVICES,INC.Totals Invoices 1 $536.76 Vendor 482-FARM PLAN 3869911 WHEEL&BOLT FOR WAM; PMT Edit 09/10/2020 10/05/2020 10/05/2020 09/24/2020 183.70 ON ACCT#34150-24151 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-WHEEL&BOLT FOR WAM; 1.0000 EA 183.7000 183.70 PMT ON ACCT#34150-24151 GIL Account Project Amount 010-29-7700 1571 (General Fund-Airport Commission-Airport 183.70 Administration Machinery&Equipment Replacement Parts) Invoice Items 1 3870615 FLASHLIGHT Edit 09/11/2020 10/05/2020 10/05/2020 09/24/2020 21.99 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-FLASHLIGHT 1.0000 EA 21.9900 21.99 GIL Account Project Amount 010-29-7700 1555(General Fund-Airport Commission-Airport 21.99 Administration Minor Equipment&Supplies) Invoice Items 1 Vendor 482-FARM PLAN Totals Invoices 2 $205.69 Vendor 486-FEDEX 7-124-67537 SHIPPING CHARGES Edit 09/16/2020 10/05/2020 10/05/2020 74.41 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SHIPPING CHARGES 1.0000 EA 74.4100 74.41 GIL Account Project Amount 520-14-5200 1343(Sanitary Sewer Fund-Waste Management-Water 74.41 Pollution-Water Pollution Control Plant Op Postage&Mailing Expense) Invoice Items 1 Vendor 486-FEDEX Totals Invoices 1 $74.41 Vendor 11488-FERGUSON ENTERPRISES,INC. Run by Emily Graham on 10/02/2020 12:23:03 PM Page 52 of 119 Page 31 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 7857646 HARDWARE Edit 09/21/2020 10/05/2020 10/05/2020 8.24 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-HARDWARE 1.0000 EA 8.2400 8.24 GIL Account Project Amount 520-14-5200 1535(Sanitary Sewer Fund-Waste Management-Water 8.24 Pollution-Water Pollution Control Plant Op Hardware Items) Invoice Items 1 Vendor 11488-FERGUSON ENTERPRISES,INC.Totals Invoices 1 $8.24 Vendor 4408-FIFTH STREET TIRE,INC 194107 MOWER TIRES Edit 09/23/2020 10/05/2020 10/05/2020 544.25 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-MOWER TIRES 1.0000 EA 544.2500 544.25 GIL Account Project Amount 010-37-4100 1569(General Fund-Leisure Services-Leisure Services-Parks 544.25 Vehicle Replacement Parts) Invoice Items 1 Vendor 4408-FIFTH STREET TIRE,INC Totals Invoices 1 $544.25 Vendor 515-GALE/CENGAGE LEARNING 71780364 ADULT PRINT Edit 09/04/2020 10/05/2020 10/05/2020 143.20 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 143.2000 143.20 GIL Account Project Amount 010-33-3100 1582(General Fund-Library-Library Services Adult Print 143.20 Materials) Invoice Items 1 Vendor 515-GALE/CENGAGE LEARNING Totals Invoices 1 $143.20 Vendor 2206-GALLS INCORPORATED 016447185 DISPOSABLE TRANZPORT HOOD Edit 09/10/2020 10/05/2020 10/05/2020 382.60 5 PK(9) P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- DISPOSABLE TRANZPORT 1.0000 EA 382.6000 382.60 HOOD 5 PK(9) GIL Account Project Amount 010-11-1150 1573(General Fund-Police Department-Police Grants Safety 11GRT.COVID20(POLICE DEPARTMENT GRANTS AND 382.60 &Protective Equipment) PROJECTS,COVIDI9 RESPONSE PR03ECT) Invoice Items 1 Vendor 2206-GALLS INCORPORATED Totals Invoices 1 $382.60 Vendor 11168-SANDIE GRECO Run by Emily Graham on 10/02/2020 12:23:03 PM Page 53 of 119 Page 32 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount RECEIPT MU2T13PB WET SANDBLASTER Edit 09/08/2020 10/05/2020 10/05/2020 29.99 ATTACHMENT P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-WET SANDBLASTER 1.0000 EA 29.9900 29.99 ATTACHMENT GIL Account Project Amount 266-17-7120 1571 (Road Use Tax-Traffic Operations-Traffic Safety 29.99 Machinery&Equipment Replacement Parts) Invoice Items 1 Vendor 11168-SANDIE GRECO Totals Invoices 1 $29.99 Vendor 21601-GREEN ACRES STORAGE 2021-00000590 FY21 SAN MARNAN PROPERTY Edit 09/25/2020 10/05/2020 10/05/2020 49,618.00 TAX REBATE; IST HALF P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- FY21 SAN MARNAN 1.0000 EA 49,618.0000 49,618.00 PROPERTY TAX REBATE; IST HALF GIL Account Project Amount 101-08-6205 1795(Tax Increment Financing Fund-Planning&Zoning- 49,618.00 San Marnan TIF Property Tax Rebate) Invoice Items 1 Vendor 21601-GREEN ACRES STORAGE Totals Invoices 1 $49,618.00 Vendor 6871-HACH COMPANY 12131007 LABORATORY SUPPLIES Edit 09/22/2020 10/05/2020 10/05/2020 657.91 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-LABORATORY SUPPLIES 1.0000 EA 657.9100 657.91 GIL Account Project Amount 520-14-5200 1551 (Sanitary Sewer Fund-Waste Management-Water 657.91 Pollution-Water Pollution Control Plant Op Drugs/Medicines& Medical/Lab Supplies) Invoice Items 1 Vendor 6871-HACH COMPANY Totals Invoices 1 $657.91 Vendor 10388-HENDERSON TRUCK EQUIPMENT 319529 CABLE Edit 09/09/2020 10/05/2020 10/05/2020 594.48 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CABLE 1.0000 EA 594.4800 594.48 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 594.48 Service Machinery&Equipment Replacement Parts) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 54 of 119 Page 33 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 319535 CABLE SPLITTER Edit 09/09/2020 10/05/2020 10/05/2020 1,103.90 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CABLE SPLITTER 1.0000 EA 1,103.9000 1,103.90 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 1,103.90 Service Machinery&Equipment Replacement Parts) Invoice Items 1 Vendor 10388-HENDERSON TRUCK EQUIPMENT Totals Invoices 2 $1,698.38 Vendor 22039-ANGELIA HOAG 2021-00000592 514 PLEASANT STREET-3 Edit 09/29/2020 10/05/2020 10/05/2020 09/29/2020 360.00 NIGHTS-RELOCATION P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-514 PLEASANT STREET-3 1.0000 EA 360.0000 360.00 NIGHTS-RELOCATION GIL Account Project Amount 224-32-5853 1327(Community Develop Block Grant-Community BGLEDI8.RELO(LEAD GRANT,LEAD GRANT 360.00 Development-Lead Paint Grant Residential Rehabilitation) RELOCATION) Invoice Items 1 Vendor 22039-ANGELIA HOAG Totals Invoices 1 $360.00 Vendor 21473-IOWA ONE CALL 225007 AUGUST FY21 LOCATE EMAILS Edit 09/18/2020 10/05/2020 10/05/2020 158.40 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-AUGUST FY21 LOCATE 1.0000 EA 158.4000 158.40 EMAILS GIL Account Project Amount 266-17-7120 1344(Road Use Tax-Traffic Operations-Traffic Safety 158.40 Telephone&Fax Expense) Invoice Items 1 225125 LOCATION SERVICES Edit 09/18/2020 10/05/2020 10/05/2020 705.60 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-LOCATION SERVICES 1.0000 EA 705.6000 705.60 GIL Account Project Amount 520-14-5200 1319(Sanitary Sewer Fund-Waste Management-Water 705.60 Pollution-Water Pollution Control Plant Op Other Professional Services) Invoice Items 1 Vendor 21473-IOWA ONE CALL Totals Invoices 2 $864.00 Vendor 2358-IOWA STATE UNIVERSITY Run by Emily Graham on 10/02/2020 12:23:03 PM Page 55 of 119 Page 34 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount ITRNS-T3M173 dTIMMS SUPPORT Edit 06/02/2020 10/05/2020 10/05/2020 2,500.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-dTIMMS SUPPORT 1.0000 EA 2,500.0000 2,500.00 GIL Account Project Amount 205-07-7830 1390(Local Option Sales Tax-City Engineer-City Engineer 2,500.00 Other Contractual Services) Invoice Items 1 Vendor 2358-IOWA STATE UNIVERSITY Totals Invoices 1 $2,500.00 Vendor 830-JIM LIND SERVICE 330613 GENERATOR FUEL Edit 09/24/2020 10/05/2020 10/05/2020 21.55 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-GENERATOR FUEL 1.0000 EA 21.5500 21.55 GIL Account Project Amount 266-17-7120 1533(Road Use Tax-Traffic Operations-Traffic Safety Fuel 21.55 Expense) Invoice Items 1 Vendor 830-JIM LIND SERVICE Totals Invoices 1 $21.55 Vendor 748-JOHNSTONE SUPPLY 1071278 OUTSIDE TEMP SENSOR; BELT Edit 09/24/2020 10/05/2020 10/05/2020 115.16 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-OUTSIDE TEMP SENSOR; 1.0000 EA 115.1600 115.16 BELT GIL Account Project Amount 010-29-7700 1371 (General Fund-Airport Commission-Airport 115.16 Administration Building&Grounds Maintenance) Invoice Items 1 1071731 ELEC-CITY HALL Edit 09/17/2020 10/05/2020 10/05/2020 09/25/2020 79.92 P.O.Number Item Description Quantity U/M AmounVUnit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- ELEC-CITY HALL 1.0000 EA 79.9200 79.92 GIL Account Project Amount 010-22-8800 1521 (General Fund-Building Inspection-Facilities 79.92 Maintenance Electrical Supplies) Invoice Items 1 Vendor 748-JOHNSTONE SUPPLY Totals Invoices 2 $195.08 Vendor 8690-JONES,RUDY/ PETTY CASH Run by Emily Graham on 10/02/2020 12:23:03 PM Page 56 of 119 Page 35 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 2021-00000586 MORTGAGE LIENS AND Edit 09/28/2020 10/05/2020 10/05/2020 09/28/2020 124.00 RELEASES P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-MORTGAGE LIENS AND 1.0000 EA 124.0000 124.00 RELEASES GIL Account Project Amount 224-32-5853 1327(Community Develop Block Grant-Community BGLEDI8.REHAB(LEAD GRANT, LEAD GRANT REHAB) 54.00 Development-Lead Paint Grant Residential Rehabilitation) 224-32-5850 1327(Community Develop Block Grant-Community BG2IA.ADMN (BLOCK GRANT GENERAL 49.00 Development-Block Grant Administration Residential Rehabilitation) MANAGEMENT,OVERSIGHT, BLOCK GRANT GENERAL ADMINISTRATION) 224-32-5870 1327(Community Develop Block Grant-Community HM21A.0001(HOME-FEDERAL PROGRAM 21.00 Development-Block Grant Home-Federal Residential Rehabilitation) ADMINISTRATION, HOME FEDERAL ADMINISTRATION) Invoice Items 1 Vendor 8690-JONES,RUDY/ PETTY CASH Totals Invoices 1 $124.00 Vendor 11943-JSA DEVELOPMENT LLC 2020-00002712 FY20 ANNUAL DOWNTOWN Edit 07/01/2020 10/05/2020 10/05/2020 55,394.00 PROPERTY TAX REBATE; AFFILIATED COMPANIES P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- FY20 ANNUAL DOWNTOWN 1.0000 EA 55,394.0000 55,394.00 PROPERTY TAX REBATE;AFFILIATED COMPANIES GIL Account Project Amount 101-08-6270 1795(Tax Increment Financing Fund-Planning&Zoning- 55,394.00 Downtown(Urban)TIF District Property Tax Rebate) Invoice Items 1 Vendor 11943-JSA DEVELOPMENT LLC Totals Invoices 1 $55,394.00 Vendor 788-K&S WHEEL ALIGNMENT SERVICE 134674 ADJ TOE IN/CENTER STEERING Edit 09/11/2020 10/05/2020 10/05/2020 48.00 WHEEL P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-AD]TOE IN/CENTER 1.0000 EA 48.0000 48.00 STEERING WHEEL GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 48.00 Service Machinery&Equipment Replacement Parts) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 57 of 119 Page 36 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 134715 ALIGNMENT Edit 09/16/2020 10/05/2020 10/05/2020 48.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ALIGNMENT 1.0000 EA 48.0000 48.00 GIL Account Project Amount 010-18-1405 1571 (General Fund-Central Garage-Fire-Garage Parts& 48.00 Service Machinery&Equipment Replacement Parts) Invoice Items 1 Vendor 788- K&S WHEEL ALIGNMENT SERVICE Totals Invoices 2 $96.00 Vendor 755-KAREN'S PRINT-RITE 171962 COLOR COPIES, LAMINATED Edit 09/23/2020 10/05/2020 10/05/2020 61.70 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-COLOR COPIES, 1.0000 EA 61.7000 61.70 LAMINATED GIL Account Project Amount 010-37-4200 1567(General Fund-Leisure Services-Sports&Youth 61.70 Services Recreational Equipment&Supplies) Invoice Items 1 Vendor 755-KAREN'S PRINT-RITE Totals Invoices 1 $61.70 Vendor 9359-KARL CHEVROLET CTCS738290 PARTS FOR AMBULANCE Edit 06/17/2020 10/05/2020 10/05/2020 2,200.50 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- PARTS FOR AMBULANCE 1.0000 EA 2,200.5000 2,200.50 GIL Account Project Amount 010-18-1405 1571 (General Fund-Central Garage-Fire-Garage Parts& 2,200.50 Service Machinery&Equipment Replacement Parts) Invoice Items 1 Vendor 9359-KARL CHEVROLET Totals Invoices 1 $2,200.50 Vendor 9642-KING,MATTHEW 12870 RT-CLEAN ALL CARPETS IN Edit 09/18/2020 10/05/2020 10/05/2020 95.00 #101 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- RT-CLEAN ALL CARPETS 1.0000 EA 95.0000 95.00 IN #101 GIL Account Project Amount 283-13-5450 1371 (Housing Programs-Housing Authority-Ridgeway 95.00 Towers Building&Grounds Maintenance) Invoice Items 1 Vendor 9642-KING,MATTHEW Totals Invoices 1 $95.00 Vendor 20945-KOELKER PROPERTIES Run by Emily Graham on 10/02/2020 12:23:03 PM Page 58 of 119 Page 37 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 2021-00000583 FY21 MIDPORT PROPERTY TAX Edit 09/24/2020 10/05/2020 10/05/2020 4,138.00 REBATE; 1ST HALF P.O. Number Item Description Quantity U/M AmounVUnit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- FY21 MIDPORT PROPERTY 1.0000 EA 4,138.0000 4,138.00 TAX REBATE; IST HALF GIL Account Project Amount 101-08-6260 1795(Tax Increment Financing Fund-Planning&Zoning- 4,138.00 Midport TIF District Property Tax Rebate) Invoice Items 1 Vendor 20945-WELKER PROPERTIES Totals Invoices 1 $4,138.00 Vendor 3076-KWWL TELEVISION 2021-00000587 FY21 LOGAN AVE PROPERTY TAX Edit 09/24/2020 10/05/2020 10/05/2020 13,845.00 REBATE; 1ST HALF P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- FY21 LOGAN AVE 1.0000 EA 13,845.0000 13,845.00 PROPERTY TAX REBATE; IST HALF GIL Account Project Amount 101-08-6280 1795(Tax Increment Financing Fund-Planning&Zoning- 13,845.00 Logan Avenue TIF Property Tax Rebate) Invoice Items 1 Vendor 3076-KWWL TELEVISION Totals Invoices 1 $13,845.00 Vendor 8889-LOCKSPERTS 172751 REKEY-PUBLIC MARKET Edit 09/21/2020 10/05/2020 10/05/2020 09/22/2020 22.68 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-REKEY-PUBLIC MARKET 1.0000 EA 22.6800 22.68 GIL Account Project Amount 010-22-8800 1535(General Fund-Building Inspection-Facilities 22.68 Maintenance Hardware Items) Invoice Items 1 Vendor 8889-LOCKSPERTS Totals Invoices 1 $22.68 Vendor 833-LOGAN CONTRACTORS SUPPLY,INC P79938 1/8"SEALING TIP W/SHOE Edit 09/16/2020 10/05/2020 10/05/2020 24.40 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- 1/8"SEALING TIP W/SHOE 1.0000 EA 24.4000 24.40 GIL Account Project Amount 205-19-7110 1555(Local Option Sales Tax-Street Department-Seal 24.40 Coating Program Minor Equipment&Supplies) Invoice Items 1 Vendor 833-LOGAN CONTRACTORS SUPPLY,INC Totals Invoices 1 $24.40 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 59 of 119 Page 38 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 21838-M&T BANK 10/01/2020 HAP-TRINA SMITH 0015340383 Edit 09/28/2020 10/05/2020 10/05/2020 490.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-HAP-TRINA SMITH 1.0000 EA 490.0000 490.00 0015340383 GIL Account Project Amount 283-13-5452 1706(Housing Programs-Housing Authority-Section 8 490.00 Housing Assistance Payments) Invoice Items 1 Vendor 21838-M&T BANK Totals Invoices 1 $490.00 Vendor 2922-MACQUEEN EQUIPMENT INC. P11311 LIQUID SMOKE Edit 09/21/2020 10/05/2020 10/05/2020 993.92 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-LIQUID SMOKE 1.0000 EA 993.9200 993.92 GIL Account Project Amount 520-14-5200 1555(Sanitary Sewer Fund-Waste Management-Water 993.92 Pollution-Water Pollution Control Plant Op Minor Equipment&Supplies) Invoice Items 1 Vendor 2922- MACQUEEN EQUIPMENT INC.Totals Invoices 1 $993.92 Vendor 845-MANATT'S INC. 999476 CONCRETE Edit 09/18/2020 10/05/2020 10/05/2020 181.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CONCRETE 1.0000 EA 181.0000 181.00 GIL Account Project Amount 520-14-5200 1511 (Sanitary Sewer Fund-Waste Management-Water 181.00 Pollution-Water Pollution Control Plant Op Concrete&Aggregates) Invoice Items 1 Vendor 845-MANATT'S INC.Totals Invoices 1 $181.00 Vendor 848-MANPOWER,INC 35295202 YDW ATTENDANT/CHARLES Edit 09/20/2020 10/05/2020 10/05/2020 804.59 LANDFAIR P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-YDW ATTENDANT/ 1.0000 EA 804.5900 804.59 CHARLES LANDFAIR GIL Account Project Amount 525-15-5400 1301 (Sanitation Fund-Waste Management-Sanitation-Solid 804.59 Waste Disposal Temp Agency Services) Invoice Items 1 Vendor 848-MANPOWER,INC Totals Invoices 1 $804.59 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 60 of 119 Page 39 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 855-MARTIN BROS DIST CO INC 8598839 CONCESSIONS- EXCHANGE Edit 09/17/2020 10/05/2020 10/05/2020 115.53 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CONCESSIONS-EXCHANGE 1.0000 EA 115.5300 115.53 GIL Account Project Amount 010-37-4500 1553(General Fund-Leisure Services-Young Arena 115.53 Merchandise for Resale) Invoice Items 1 8607147 CONCESSIONS-EXCHANGE Edit 09/23/2020 10/05/2020 10/05/2020 380.32 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CONCESSIONS-EXCHANGE 1.0000 EA 380.3200 380.32 GIL Account Project Amount 010-37-4200 1553(General Fund-Leisure Services-Sports&Youth 380.32 Services Merchandise for Resale) Invoice Items 1 8611232 CONCESSIONS-SPORTSPLEX Edit 09/25/2020 10/05/2020 10/05/2020 782.69 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CONCESSIONS- 1.0000 EA 782.6900 782.69 SPORTSPLEX GIL Account Project Amount 010-37-4180 1553 (General Fund-Leisure Services-SportsPlex 37SPLX.OPER(CEDAR VALLEY SPORTSPLEX, 782.69 Merchandise for Resale) SPORTSPLEX OPERATIONS) Invoice Items 1 Vendor 855-MARTIN BROS DIST CO INC Totals Invoices 3 $1,278.54 Vendor 8147-MEDIACOM 2021-00000588 FIBER MAINTENANCE Edit 09/22/2020 10/05/2020 10/05/2020 09/01/2020 200.00 P.O.Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- FIBER MAINTENANCE AND 1.0000 EA 200.0000 200.00 SERVICE GIL Account Project Amount 010-01-8220 1339(General Fund-Mayor-Administrative SVCS/MIS Data 200.00 Communication) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 61 of 119 Page 40 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 2021-00000582 8/24-9/23 SERVICE AT 1689 Edit 08/16/2020 10/05/2020 10/05/2020 59.99 BURTON AVE STE 2-TRI CO TASK FORCE P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-8/24-9/23 SERVICE AT 1.0000 EA 59.9900 59.99 1689 BURTON AVE STE 2-TRI CO TASK FORCE GIL Account Project Amount 010-11-1160 1512(General Fund-Police Department-Law Enforcement 11TRI.TRIF(TRI-COUNTY TASK FORCE,TRI-COUNTY 59.99 Programs Tri-Co Forfeiture Distributions) FORFEITURE FUNDS RECEIVED) Invoice Items 1 2021-00000548 9/24-10/23 SERVICE AT 1689 Edit 09/16/2020 10/05/2020 10/05/2020 59.99 BURTON AVE STE 2-TRI CO TASK FORCE P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-9/24-10/23 SERVICE AT 1.0000 EA 59.9900 59.99 1689 BURTON AVE STE 2-TRI CO TASK FORCE GIL Account Project Amount 010-11-1160 1512(General Fund-Police Department-Law Enforcement I ITRI.TRIF(TRI-COUNTY TASK FORCE,TRI-COUNTY 59.99 Programs Tri-Co Forfeiture Distributions) FORFEITURE FUNDS RECEIVED) Invoice Items 1 09132020 INTERNET SERVICES Edit 09/13/2020 10/05/2020 10/05/2020 174.90 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-INTERNET SERVICES 1.0000 EA 174.9000 174.90 GIL Account Project Amount 520-14-5200 1344(Sanitary Sewer Fund-Waste Management-Water 174.90 Pollution-Water Pollution Control Plant Op Telephone&Fax Expense) Invoice Items 1 Vendor 8147- MEDIACOM Totals Invoices 4 $494.88 Vendor 885-MENARDS 66291 ELEC-CITY HALL Edit 09/16/2020 10/05/2020 10/05/2020 09/24/2020 17.57 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ELEC-CITY HALL 1.0000 EA 17.5700 17.57 GIL Account Project Amount 010-22-8800 1521 (General Fund-Building Inspection-Facilities 17.57 Maintenance Electrical Supplies) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 62 of 119 Page 41 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 66321 ELEC-CITY HALL Edit 09/16/2020 10/05/2020 10/05/2020 09/24/2020 50.10 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ELEC-CITY HALL 1.0000 EA 50.1000 50.10 GIL Account Project Amount 010-22-8800 1521 (General Fund-Building Inspection-Facilities 50.10 Maintenance Electrical Supplies) Invoice Items 1 66357-20 CEILING TILE-CITY HALL Edit 09/17/2020 10/05/2020 10/05/2020 09/24/2020 6.86 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CEILING TILE-CITY HALL 1.0000 EA 6.8600 6.86 GIL Account Project Amount 010-22-8800 1571 (General Fund-Building Inspection-Facilities 6.86 Maintenance Machinery&Equipment Replacement Parts) Invoice Items 1 66370 CEILING TILE-CITY HALL Edit 09/17/2020 10/05/2020 10/05/2020 09/24/2020 2.47 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CEILING TILE-CITY HALL 1.0000 EA 2.4700 2.47 GIL Account Project Amount 010-22-8800 1371 (General Fund-Building Inspection-Facilities 2.47 Maintenance Building&Grounds Maintenance) Invoice Items 1 66398 ELEC-CITY HALL Edit 09/17/2020 10/05/2020 10/05/2020 09/24/2020 14.20 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ELEC-CITY HALL 1.0000 EA 14.2000 14.20 GIL Account Project Amount 010-22-8800 1521 (General Fund-Building Inspection-Facilities 14.20 Maintenance Electrical Supplies) Invoice Items 1 66453 OFFICE SUPPLIES-BLDG MAINT Edit 09/18/2020 10/05/2020 10/05/2020 09/24/2020 17.98 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-OFFICE SUPPLIES-BLDG 1.0000 EA 17.9800 17.98 MAINT GIL Account Project Amount 010-22-8800 1561 (General Fund-Building Inspection-Facilities 17.98 Maintenance Office Supplies&Minor Equipment) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 63 of 119 Page 42 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 66295 CEMENT PATCH Edit 09/16/2020 10/05/2020 10/05/2020 12.98 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CEMENT PATCH 1.0000 EA 12.9800 12.98 GIL Account Project Amount 266-07-7830 1555(Road Use Tax-City Engineer-City Engineer Minor 12.98 Equipment&Supplies) Invoice Items 1 65861 PLEXIGLAS FOR WELCOME DESK Edit 09/09/2020 10/05/2020 10/05/2020 221.01 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-PLEXIGLAS FOR WELCOME 1.0000 EA 221.0100 221.01 DESK GIL Account Project Amount 010-33-3100 1371 (General Fund-Library-Library Services Building& 221.01 Grounds Maintenance) Invoice Items 1 65874 HARDWARE FOR PLEXIGLAS FOR Edit 09/09/2020 10/05/2020 10/05/2020 12.64 WELCOME DESK P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- HARDWARE FOR 1.0000 EA 12.6400 12.64 PLEXIGLAS FOR WELCOME DESK GIL Account Project Amount 010-33-3100 1561 (General Fund-Library-Library Services Office Supplies 12.64 &Minor Equipment) Invoice Items 1 65913 HARDWARE FOR HOLDS SHELF Edit 09/10/2020 10/05/2020 10/05/2020 21.62 CIRC WORKROOM P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- HARDWARE FOR HOLDS 1.0000 EA 21.6200 21.62 SHELF CIRC WORKROOM GIL Account Project Amount 010-33-3100 1561 (General Fund-Library-Library Services Office Supplies 21.62 &Minor Equipment) Invoice Items 1 66732 MATERIALS&HARDWARE FOR Edit 09/22/2020 10/05/2020 10/05/2020 128.04 YOUTH DEPT DRAWERS P.O. Number Item Description Quantity U/M Amount/Un/t Total Amount Vendor Catalog Part Number Contract Number Conversion Item- MATERIALS&HARDWARE 1.0000 EA 128.0400 128.04 FOR YOUTH DEPT DRAWERS GIL Account Project Amount 010-33-3100 1371 (General Fund-Library-Library Services Building& 128.04 Grounds Maintenance) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 64 of 119 Page 43 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 66302 MORTAR MIX FOR SKATE PARK Edit 09/16/2020 10/05/2020 10/05/2020 23.29 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- MORTAR MIX FOR SKATE 1.0000 EA 23.2900 23.29 PARK GIL Account Project Amount 010-37-4100 1511 (General Fund-Leisure Services-Leisure Services-Parks 23.29 Concrete&Aggregates) Invoice Items 1 66379 PLUMBING REPAIR Edit 09/17/2020 10/05/2020 10/05/2020 5.67 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- PLUMBING REPAIR 1.0000 EA 5.6700 5.67 GIL Account Project Amount 010-37-4120 1565(General Fund-Leisure Services-Golf Courses 5.67 Plumbing,Sewage&Drainage Supplies) Invoice Items 1 66454-2020 GATES TILE CONNECTORS Edit 09/18/2020 10/05/2020 10/05/2020 8.36 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-GATES TILE CONNECTORS 1.0000 EA 8.3600 8.36 GIL Account Project Amount 010-37-4120 1565(General Fund-Leisure Services-Golf Courses 8.36 Plumbing,Sewage&Drainage Supplies) Invoice Items 1 66683 IRRIGATION SUPPLIES Edit 09/22/2020 10/05/2020 10/05/2020 78.47 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-IRRIGATION SUPPLIES 1.0000 EA 78.4700 78.47 GIL Account Project Amount 010-37-4110 1569(General Fund-Leisure Services-Downtown Area 78.47 Maintenance Vehicle Replacement Parts) Invoice Items 1 18545 ACRYLIC FOR SNEEZE QUARDS Edit 09/24/2020 10/05/2020 10/05/2020 234.93 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ACRYLIC FOR SNEEZE 1.0000 EA 234.9300 234.93 QUARDS GIL Account Project Amount 010-37-4500 1373(General Fund-Leisure Services-Young Arena Fixed 234.93 Plant Operating Equip Repair) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 65 of 119 Page 44 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 66366 ANTIBACTERIAL WIPES(12)& Edit 09/17/2020 10/05/2020 10/05/2020 57.37 LYSOL SPRAY(4) P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ANTIBACTERIAL WIPES 1.0000 EA 57.3700 57.37 (12)&LYSOL SPRAY(4) GIL Account Project Amount 010-11-1150 1573(General Fund-Police Department-Police Grants Safety 11GRT.COVID20(POLICE DEPARTMENT GRANTS AND 57.37 &Protective Equipment) PROJECTS,COVID19 RESPONSE PROJECT) Invoice Items 1 63974-2020 2X8- 16 Edit 08/11/2020 10/05/2020 10/05/2020 71.96 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-2X8- 16 1.0000 EA 71.9600 71.96 GIL Account Project Amount 205-19-7110 1555(Local Option Sales Tax-Street Department-Seal 71.96 Coating Program Minor Equipment&Supplies) Invoice Items 1 17887-2020 75CT CLOROX WIPES Edit 09/15/2020 10/05/2020 10/05/2020 25.74 P.O.Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-75CT CLOROX WIPES 1.0000 EA 25.7400 25.74 GIL Account Project Amount 266-19-7100 1541(Road Use Tax-Street Department-Street 25.74 Maintenance Janitorial Supplies) Invoice Items 1 66682-2020 CHIP SEAL PROGRAM Edit 09/22/2020 10/05/2020 10/05/2020 35.96 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CHIP SEAL PROGRAM 1.0000 EA 35.9600 35.96 GIL Account Project Amount 205-19-7110 1555(Local Option Sales Tax-Street Department-Seal 35.96 Coating Program Minor Equipment&Supplies) Invoice Items 1 66359 JANITORIAL SUPPLIES Edit 09/17/2020 10/05/2020 10/05/2020 1.51 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-JANITORIAL SUPPLIES 1.0000 EA 1.5100 1.51 GIL Account Project Amount 525-17-2400 1541 (Sanitation Fund-Traffic Operations-Animal Control 1.51 Janitorial Supplies) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 66 of 119 Page 45 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 664608 UTILITY HANGER Edit 09/18/2020 10/05/2020 10/05/2020 6.76 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-UTILITY HANGER 1.0000 EA 6.7600 6.76 GIL Account Project Amount 266-17-7120 1535(Road Use Tax-Traffic Operations-Traffic Safety 6.76 Hardware Items) Invoice Items 1 Vendor 885-MENARDS Totals Invoices 22 $1,055.49 Vendor 336-MERCY ONE 2200930 AUGUST DRUGS AMBULANCE Edit 09/28/2020 10/05/2020 10/05/2020 2,081.77 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-AUGUST DRUGS 1.0000 EA 2,081.7700 2,081.77 AMBULANCE GIL Account Project Amount 010-12-1410 1551 (General Fund-Fire Department-Fire Ambulance 2,081.77 Service Drugs/Medicines&Medical/Lab Supplies) Invoice Items 1 Vendor 336-MERCY ONE Totals Invoices 1 $2,081.77 Vendor 911-MIDAMERICAN ENERGY 503776003 UTILITIES-327 W 3RD Edit 09/11/2020 10/05/2020 10/05/2020 09/23/2020 164.21 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-UTILITIES-327 W 3RD 1.0000 EA 164.2100 164.21 GIL Account Project Amount 010-22-8800 1400(General Fund-Building Inspection-Facilities 164.21 Maintenance Utility Service) Invoice Items 1 2021-00000580 UTILTIES-GOLF, PARK,SPORTS Edit 09/28/2020 10/05/2020 10/05/2020 2,130.71 P.O.Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-UTILTIES-GOLF, PARK, 1.0000 EA 2,130.7100 2,130.71 SPORTS GIL Account Project Amount 010-37-4120 1400(General Fund-Leisure Services-Golf Courses Utility 1,230.46 Service) 010-37-4200 1400(General Fund-Leisure Services-Sports&Youth 10.00 Services Utility Service) 010-37-4100 1400(General Fund-Leisure Services-Leisure Services-Parks 890.25 Utility Service) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 67 of 119 Page 46 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 503761722 GE 96 W.18TH ST,ST LT Edit 09/11/2020 10/05/2020 10/05/2020 36.25 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-GE 96 W.18TH ST,ST LT 1.0000 EA 36.2500 36.25 GIL Account Project Amount 266-17-7105 1400(Road Use Tax-Traffic Operations-Street Lighting 36.25 Utility Service) Invoice Items 1 2021-00000573 AREA LIGHTING SUMMARY Edit 09/17/2020 10/05/2020 10/05/2020 .75 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-AREA LIGHTING SUMMARY 1.0000 EA .7500 .75 GIL Account Project Amount 266-17-7105 1400(Road Use Tax-Traffic Operations-Street Lighting .75 Utility Service) Invoice Items 1 503779916 UTILITIES-LIFT STATION Edit 09/11/2020 10/05/2020 10/05/2020 131.51 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-UTILITIES-LIFT STATION 1.0000 EA 131.5100 131.51 GIL Account Project Amount 520-14-5200 1400(Sanitary Sewer Fund-Waste Management-Water 131.51 Pollution-Water Pollution Control Plant Op Utility Service) Invoice Items 1 503806582 UTILITIES-WM Edit 09/11/2020 10/05/2020 10/05/2020 80.38 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-UTILITIES-WM 1.0000 EA 80.3800 80.38 GIL Account Project Amount 520-14-5200 1400(Sanitary Sewer Fund-Waste Management-Water 80.38 Pollution-Water Pollution Control Plant Op Utility Service) Invoice Items 1 503895041 UTILITIES-ORANGE ROAD Edit 09/15/2020 10/05/2020 10/05/2020 110.99 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-UTILITIES-ORANGE ROAD 1.0000 EA 110.9900 110.99 GIL Account Project Amount 520-14-5200 1400(Sanitary Sewer Fund-Waste Management-Water 110.99 Pollution-Water Pollution Control Plant Op Utility Service) Invoice Items 1 Vendor 911-MIDAMERICAN ENERGY Totals Invoices 7 $2,654.80 Vendor 904-MIDLAND SCIENTIFIC INC Run by Emily Graham on 10/02/2020 12:23:03 PM Page 68 of 119 Page 47 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 6153173 AQUA Edit 09/21/2020 10/05/2020 10/05/2020 67.32 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-AQUA 1.0000 EA 67.3200 67.32 GIL Account Project Amount 520-14-5200 1551 (Sanitary Sewer Fund-Waste Management-Water 67.32 Pollution-Water Pollution Control Plant Op Drugs/Medicines& Medical/Lab Supplies) Invoice Items 1 Vendor 904-MIDLAND SCIENTIFIC INC Totals Invoices 1 $67.32 Vendor 10545-MIDWEST SAFETY COUNSELORS INC IVC0061783 FOUR GAS METER CALIBRATION Edit 09/28/2020 10/05/2020 10/05/2020 240.00 &REPAIR P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-FOUR GAS METER 1.0000 EA 240.0000 240.00 CALIBRATION&REPAIR GIL Account Project Amount 010-12-1400 1598(General Fund-Fire Department-Fire Protection 240.00 Service Hazardous Materials Expense) Invoice Items 1 Vendor 10545-MIDWEST SAFETY COUNSELORS INC Totals Invoices 1 $240.00 Vendor 2274-MIDWEST TAPE 99396233 DVD Edit 09/17/2020 10/05/2020 10/05/2020 24.39 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-DVD 1.0000 EA 24.3900 24.39 GIL Account Project Amount 010-33-3100 1597(General Fund-Library-Library Services DVD's) 24.39 Invoice Items 1 99396234 DVD Edit 09/17/2020 10/05/2020 10/05/2020 19.89 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-DVD 1.0000 EA 19.8900 19.89 GIL Account Project Amount 010-33-3100 1597(General Fund-Library-Library Services DVD's) 19.89 Invoice Items 1 99396236 DVDS Edit 09/17/2020 10/05/2020 10/05/2020 49.08 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-DVDS 1.0000 EA 49.0800 49.08 GIL Account Project Amount 010-33-3100 1597(General Fund-Library-Library Services DVD's) 49.08 Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 69 of 119 Page 48 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 99396237 DVD Edit 09/17/2020 10/05/2020 10/05/2020 42.04 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-DVD 1.0000 EA 42.0400 42.04 GIL Account Project Amount 010-33-3100 1597(General Fund-Library-Library Services DVD's) 42.04 Invoice Items 1 99396238 DVD Edit 09/17/2020 10/05/2020 10/05/2020 43.54 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-DVD 1.0000 EA 43.5400 43.54 GIL Account Project Amount 010-33-3100 1597(General Fund-Library-Library Services DVD's) 43.54 Invoice Items 1 99396239 DVD Edit 09/17/2020 10/05/2020 10/05/2020 21.39 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-DVD 1.0000 EA 21.3900 21.39 GIL Account Project Amount 010-33-3100 1597(General Fund-Library-Library Services DVD's) 21.39 Invoice Items 1 99396400 DVD Edit 09/17/2020 10/05/2020 10/05/2020 26.59 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-DVD 1.0000 EA 26.5900 26.59 GIL Account Project Amount 010-33-3100 1597(General Fund-Library-Library Services DVD's) 26.59 Invoice Items 1 99396401 DVD Edit 09/17/2020 10/05/2020 10/05/2020 20.64 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-DVD 1.0000 EA 20.6400 20.64 GIL Account Project Amount 010-33-3100 1597(General Fund-Library-Library Services DVD's) 20.64 Invoice Items 1 99396402 DVD Edit 09/17/2020 10/05/2020 10/05/2020 37.84 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-DVD 1.0000 EA 37.8400 37.84 GIL Account Project Amount 010-33-3100 1597(General Fund-Library-Library Services DVDs) 37.84 Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 70 of 119 Page 49 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 99396403 DVD Edit 09/17/2020 10/05/2020 10/05/2020 9.69 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-DVD 1.0000 EA 9.6900 9.69 GIL Account Project Amount 010-33-3100 1597(General Fund-Library-Library Services DVD's) 9.69 Invoice Items 1 Vendor 2274-MIDWEST TAPE Totals Invoices 10 $295.09 Vendor 7808-MURPHY TRACTOR&EQUIPMENT 1458951 FILTER ELE/FUEL FILTER Edit 09/18/2020 10/05/2020 10/05/2020 84.82 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- FILTER ELE/FUEL FILTER 1.0000 EA 84.8200 84.82 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 84.82 Service Machinery&Equipment Replacement Parts) Invoice Items 1 Vendor 7808-MURPHY TRACTOR&EQUIPMENT Totals Invoices 1 $84.82 Vendor 961-MUTUAL WHEEL COMPANY 5561567 TANDEM FDRS/MOUTNING KIT Edit 09/17/2020 10/05/2020 10/05/2020 1,054.82 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-TANDEM FDRS/MOUTNING 1.0000 EA 1,054.8200 1,054.82 KIT GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 1,054.82 Service Machinery&Equipment Replacement Parts) Invoice Items 1 5562653 REPAIR PARTS#315 Edit 09/23/2020 10/05/2020 10/05/2020 56.72 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-REPAIR PARTS#315 1.0000 EA 56.7200 56.72 GIL Account Project Amount 010-37-4100 1571 (General Fund-Leisure Services-Leisure Services-Parks 56.72 Machinery&Equipment Replacement Parts) Invoice Items 1 5562817 CHIPPER PARTS#315 Edit 09/23/2020 10/05/2020 10/05/2020 189.75 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CHIPPER PARTS#315 1.0000 EA 189.7500 189.75 GIL Account Project Amount 010-37-4100 1571 (General Fund-Leisure Services-Leisure Services-Parks 189.75 Machinery&Equipment Replacement Parts) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 71 of 119 Page 50 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 961-MUTUAL WHEEL COMPANY Totals Invoices 3 $1,301.29 Vendor 966-NAPA AUTO PARTS 238182 CLIP Edit 09/18/2020 10/05/2020 10/05/2020 24.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CLIP 1.0000 EA 24.0000 24.00 GIL Account Project Amount 010-18-1411 1571 (General Fund-Central Garage-Ambulance-Garage 24.00 Parts&Service Machinery&Equipment Replacement Parts) Invoice Items 1 Vendor 966-NAPA AUTO PARTS Totals Invoices 1 $24.00 Vendor 1008-NORTHLAND PRODUCTS COMPANY CMNP003206 NPC GRAY PLASTIC 55 RETURN Edit 09/17/2020 10/05/2020 10/05/2020 (66.00) P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- NPC GRAY PLASTIC 55 1.0000 EA (66.0000) (66.00) RETURN GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool (66.00) Service Machinery&Equipment Replacement Parts) Invoice Items 1 INVNP0050467 DEXOS/75W90/NORPLEX Edit 09/17/2020 10/05/2020 10/05/2020 674.80 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-DEXOS/75W90/NORPLEX 1.0000 EA 674.8000 674.80 GIL Account Project Amount 010-18-7955 1547(General Fund-Central Garage-Garage-Motor Pool 674.80 Service Oils&Greases) Invoice Items 1 INVNP0050747 TALAMAR Edit 09/18/2020 10/05/2020 10/05/2020 1,384.50 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-TALAMAR 1.0000 EA 1,384.5000 1,384.50 GIL Account Project Amount 010-18-7955 1547(General Fund-Central Garage-Garage-Motor Pool 1,384.50 Service Oils&Greases) Invoice Items 1 Vendor 1008-NORTHLAND PRODUCTS COMPANY Totals Invoices 3 $1,993.30 Vendor 20668-OFFICE EXPRESS Run by Emily Graham on 10/02/2020 12:23:03 PM Page 72 of 119 Page 51 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 127298-0 COPY PAPER Edit 09/23/2020 10/05/2020 10/05/2020 32.90 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-COPY PAPER 1.0000 EA 32.9000 32.90 GIL Account Project Amount 010-03-8400 1561 (General Fund-City Clerk&Finance-City Clerk& 32.90 Finance Office Supplies&Minor Equipment) Invoice Items 1 127298-1 OFFICE SUPPLIES Edit 09/23/2020 10/05/2020 10/05/2020 16.80 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-OFFICE SUPPLIES 1.0000 EA 16.8000 16.80 GIL Account Project Amount 010-03-8400 1561 (General Fund-City Clerk&Finance-City Clerk& 16.80 Finance Office Supplies&Minor Equipment) Invoice Items 1 127551-0 COPY PAPER Edit 09/24/2020 10/05/2020 10/05/2020 32.90 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-COPY PAPER 1.0000 EA 32.9000 32.90 GIL Account Project Amount 010-03-8400 1561 (General Fund-City Clerk&Finance-City Clerk& 32.90 Finance Office Supplies&Minor Equipment) Invoice Items 1 126778-0 CLEANER&3-HOLE PUNCH Edit 09/21/2020 10/05/2020 10/05/2020 28.95 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CLEANER&3-HOLE PUNCH 1.0000 EA 28.9500 28.95 GIL Account Project Amount 283-13-5452 1561 (Housing Programs-Housing Authority-Section 8 13FAC.CARES V(FEDERAL ANNUAL CONTRIBUTIONS 28.95 Office Supplies&Minor Equipment) CONTRACT,CARES ACT ADMINISTRATIVE FEES- VOUCHER) Invoice Items 1 Vendor 20668-OFFICE EXPRESS Totals Invoices 4 $111.55 Vendor 13314-OVERDRIVE INC 02863DA20301487 E-BOOKS Edit 09/21/2020 10/05/2020 10/05/2020 65.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- E-BOOKS 1.0000 EA 65.0000 65.00 GIL Account Project Amount 010-33-3100 1583(General Fund-Library-Library Services Downloadable 65.00 Materials) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 73 of 119 Page 52 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 02863DA20303363 E-BOOKS Edit 09/22/2020 10/05/2020 10/05/2020 408.92 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-E-BOOKS 1.0000 EA 408.9200 408.92 GIL Account Project Amount 010-33-3100 1583(General Fund-Library-Library Services Downloadable 408.92 Materials) Invoice Items 1 02863DA20303684 E-BOOKS Edit 09/22/2020 10/05/2020 10/05/2020 40.49 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-E-BOOKS 1.0000 EA 40.4900 40.49 GIL Account Project Amount 010-33-3100 1583(General Fund-Library-Library Services Downloadable 40.49 Materials) Invoice Items 1 Vendor 13314-OVERDRIVE INC Totals Invoices 3 $514.41 Vendor 1028-OVERHEAD DOOR CO.OF WATERLOO 24702 OVERHEAD DOOR; Edit 09/24/2020 10/05/2020 10/05/2020 09/24/2020 1,130.00 TRANSMITTER-FIRE STAT#4 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-OVERHEAD DOOR; 1.0000 EA 1,130.0000 1,130.00 TRANSMITTER-FIRE STAT#4 GIL Account Project Amount 418-22-1400 2152(June 2018 GO Bond Fund-Building Inspection-Fire 1,130.00 Protection Service Building Improvements) Invoice Items 1 Vendor 1028-OVERHEAD DOOR CO.OF WATERLOO Totals Invoices 1 $1,130.00 Vendor 1127-PEPSI COLA GENERAL BOTTLING 32097712 CONCESSIONS- EXCHANGE Edit 09/23/2020 10/05/2020 10/05/2020 537.34 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CONCESSIONS-EXCHANGE 1.0000 EA 537.3400 537.34 GIL Account Project Amount 010-37-4200 1553(General Fund-Leisure Services-Sports&Youth 537.34 Services Merchandise for Resale) Invoice Items 1 Vendor 1127-PEPSI COLA GENERAL BOTTLING Totals Invoices 1 $537.34 Vendor 7803-PER MAR SECURITY SERVICES Run by Emily Graham on 10/02/2020 12:23:03 PM Page 74 of 119 Page 53 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 509715 PHYSICAL SECURITY OFFICER- Edit 09/12/2020 10/05/2020 10/05/2020 1,852.56 WM P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-PHYSICAL SECURITY 1.0000 EA 1,852.5600 1,852.56 OFFICER-WM GIL Account Project Amount 520-14-5200 1319(Sanitary Sewer Fund-Waste Management-Water 1,852.56 Pollution-Water Pollution Control Plant Op Other Professional Services) Invoice Items 1 Vendor 7803-PER MAR SECURITY SERVICES Totals Invoices 1 $1,852.56 Vendor 1132-PETERSON CONTRACTORS,INC 934-31 CONT 934 RECONSTRUCTION OF Edit 09/28/2020 10/05/2020 10/05/2020 247,725.45 UNIVERSITY AVE P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CONT 934 1.0000 EA 247,725.4500 247,725.45 RECONSTRUCTION OF UNIVERSITY AVE GIL Account Project Amount 426-07-7650 2164(Capital Improvements Fund-City Engineer-Sidewalk 07UNIV.GAME(RECON UNIVERSITY AVE MIDWAY DR 12,277.69 Repair/Construction Sidewalks) TO US63, UNIVERSITY AVE RECONSTRUCION) 266-07-7500 2165(Road Use Tax-City Engineer-Street Construction 07UNIV.PH2(RECON UNIVERSITY AVE MIDWAY DR 197,714.95 Streets&Roadways) TO US63, UNIVERSITY AVE RECONSTRUCTION PHASE 2) 266-07-7500 2165(Road Use Tax-City Engineer-Street Construction 07UNIV.934W(RECON UNIVERSITY AVE MIDWAY DR 37,732.81 Streets&Roadways) TO US63,934 RECONSTRUCTION OF UNIVERSITY AVE) Invoice Items 1 Vendor 1132-PETERSON CONTRACTORS,INC Totals Invoices 1 $247,725.45 Vendor 10537-PPG ARCHITECTURAL FINISHES 983603114689 TOUCH UP PAINT FOR TERMINAL Edit 09/25/2020 10/05/2020 10/05/2020 19.60 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-TOUCH UP PAINT FOR 1.0000 EA 19.6000 19.60 TERMINAL GIL Account Project Amount 010-29-7700 1371 (General Fund-Airport Commission-Airport 19.60 Administration Building&Grounds Maintenance) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 75 of 119 Page 54 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 983603114690 MATERIALS FOR DRYWALL Edit 09/25/2020 10/05/2020 10/05/2020 13.99 TOUCH UPS P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-MATERIALS FOR DRYWALL 1.0000 EA 13.9900 13.99 TOUCH UPS GIL Account Project Amount 010-29-7700 1371 (General Fund-Airport Commission-Airport 13.99 Administration Building&Grounds Maintenance) Invoice Items 1 983602086601 PAINT RESTROOM AT SKATE Edit 09/21/2020 10/05/2020 10/05/2020 194.74 PARK P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-PAINT RESTROOM AT 1.0000 EA 194.7400 194.74 SKATE PARK GIL Account Project Amount 418-37-4202 2178(June 2018 GO Bond Fund-Leisure Services-Sports 37IMP.SK8BOND(PARKS DEPARTMENT 194.74 Facilities Sports Facility Improvements) IMPROVEMENTS, FY20 RIVERSIDE SKATE PARK- BONDS) Invoice Items 1 983603114597 PAINT SUPPLIES RESTROOM AT Edit 09/23/2020 10/05/2020 10/05/2020 14.61 SKATE PARK P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- PAINT SUPPLIES 1.0000 EA 14.6100 14.61 RESTROOM AT SKATE PARK GIL Account Project Amount 418-37-4202 2178(June 2018 GO Bond Fund-Leisure Services-Sports 37IMP.SK8BOND(PARKS DEPARTMENT 14.61 Facilities Sports Facility Improvements) IMPROVEMENTS, FY20 RIVERSIDE SKATE PARK- BONDS) Invoice Items 1 983603114608 PAINT RESTROOM AT SKATE Edit 09/23/2020 10/05/2020 10/05/2020 165.73 PARK P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- PAINT RESTROOM AT 1.0000 EA 165.7300 165.73 SKATE PARK GIL Account Project Amount 418-37-4202 2178(June 2018 GO Bond Fund-Leisure Services-Sports 37IMP.SK8BOND(PARKS DEPARTMENT 165.73 Facilities Sports Facility Improvements) IMPROVEMENTS, FY20 RIVERSIDE SKATE PARK- BONDS) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 76 of 119 Page 55 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 983603114615 PAINT RESTROOM AT SKATE Edit 09/23/2020 10/05/2020 10/05/2020 156.95 PARK P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-PAINT RESTROOM AT 1.0000 EA 156.9500 156.95 SKATE PARK GIL Account Project Amount 418-37-4202 2178(June 2018 GO Bond Fund-Leisure Services-Sports 37IMP.SK8BOND(PARKS DEPARTMENT 156.95 Facilities Sports Facility Improvements) IMPROVEMENTS, FY20 RIVERSIDE SKATE PARK- BONDS) Invoice Items 1 983603114623 PAINT RESTROOM AT SKATE Edit 09/23/2020 10/05/2020 10/05/2020 28.79 PARK P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- PAINT RESTROOM AT 1.0000 EA 28.7900 28.79 SKATE PARK GIL Account Project Amount 418-37-4202 2178(June 2018 GO Bond Fund-Leisure Services-Sports 37IMP.SK8BOND(PARKS DEPARTMENT 28.79 Facilities Sports Facility Improvements) IMPROVEMENTS, FY20 RIVERSIDE SKATE PARK- BONDS) Invoice Items 1 983603114627 PAINT RESTROOM AT SKATE Edit 09/23/2020 10/05/2020 10/05/2020 156.95 PARK P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- PAINT RESTROOM AT 1.0000 EA 156.9500 156.95 SKATE PARK GIL Account Project Amount 418-37-4202 2178(June 2018 GO Bond Fund-Leisure Services-Sports 37IMP.BCBOND(PARKS DEPARTMENT 156.95 Facilities Sports Facility Improvements) IMPROVEMENTS, BOAT HOUSE PARKING LOT IMPR- PH 1&2) Invoice Items 1 Vendor 10537-PPG ARCHITECTURAL FINISHES Totals Invoices 8 $751.36 Vendor 13100-PRAIRIE EVENT SUPPLY,INC. 2690 TABLES,CHAIRS Edit 09/10/2020 10/05/2020 10/05/2020 5,038.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-TABLES,CHAIRS 1.0000 EA 5,038.0000 5,038.00 GIL Account Project Amount 420-37-4500 2152(June 2020 GO Bond Fund-Leisure Services-Young 3,152.79 Arena Building Improvements) 417-37-4500 2152(June 2017 GO Bond Fund-Leisure Services-Young 1,885.21 Arena Building Improvements) Invoice Items 1 Vendor 13100-PRAIRIE EVENT SUPPLY,INC.Totals Invoices 1 $5,038.00 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 77 of 119 Page 56 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 21241-PRO-WEST&ASSOC INC 004622 SUPPORT PACKAGE Edit 09/24/2020 10/05/2020 10/05/2020 09/24/2020 2,600.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-TWENTY HOUR BLOCK 1.0000 EA 2,600.0000 2,600.00 SUPPORT PACKAGE GIL Account Project Amount 010-01-8220 1319(General Fund-Mayor-Administrative SVCS/MIS Other 2,600.00 Professional Services) Invoice Items 1 Vendor 21241-PRO-WEST&ASSOC INC Totals Invoices 1 $2,600.00 Vendor 20142-PTL PROPERTIES,LLC 2021-00000577 FY21 MARTIN RD PROPERTY TAX Edit 09/04/2020 10/05/2020 10/05/2020 3,815.00 REBATE; 1ST HALF P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-FY21 MARTIN RD 1.0000 EA 3,815.0000 3,815.00 PROPERTY TAX REBATE; IST HALF GIL Account Project Amount 101-08-6250 1795(Tax Increment Financing Fund-Planning&Zoning- 3,815.00 Martin Road TIF Property Tax Rebate) Invoice Items 1 Vendor 20142-PTL PROPERTIES,LLC Totals Invoices 1 $3,815.00 Vendor 20487-PUSH PEDAL PULL,INC 287212 ANTIBACTERIAL WIPES COVID Edit 09/23/2020 10/05/2020 10/05/2020 1,116.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ANTIBACTERIAL WIPES 1.0000 EA 1,116.0000 1,116.00 COVID GIL Account Project Amount 010-37-4180 1541 (General Fund-Leisure Services-SportsPlex Janitorial 37SPLX.OPER(CEDAR VALLEY SPORTSPLEX, 1,116.00 Supplies) SPORTSPLEX OPERATIONS) Invoice Items 1 Vendor 20487-PUSH PEDAL PULL,INC Totals Invoices 1 $1,116.00 Vendor 21956-QUADIENT LEASING N8487405 MAIL MACHINE LEASE 7-19-20 Edit 09/17/2020 10/05/2020 10/05/2020 1,031.70 TO 10-18-20 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- MAIL MACHINE LEASE 7-19 1.0000 EA 1,031.7000 1,031.70 -20 TO 10-18-20 GIL Account Project Amount Run by Emily Graham on 10/02/2020 12:23:03 PM Page 78 of 119 Page 57 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount N8487405 MAIL MACHINE LEASE 7-19-20 Edit 09/17/2020 10/05/2020 10/05/2020 1,031.70 TO 10-18-20 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 010-03-8400 1343(General Fund-City Clerk&Finance-City Clerk& 1,031.70 Finance Postage&Mailing Expense) Invoice Items 1 Vendor 21956-QUADIENT LEASING Totals Invoices 1 $1,031.70 Vendor 6981-QUILL CORPORATION 8797054 CLOROX WIPES Edit 07/21/2020 10/05/2020 10/05/2020 34.74 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-COLORX WIPES 1.0000 EA 34.7400 34.74 GIL Account Project Amount 283-13-5452 1541 (Housing Programs-Housing Authority-Section 8 13FAC.CARES V(FEDERAL ANNUAL CONTRIBUTIONS 34.74 Janitorial Supplies) CONTRACT,CARES ACT ADMINISTRATIVE FEES- VOUCHER) Invoice Items 1 10697502 Office Supplies Edit 09/22/2020 10/05/2020 10/05/2020 42.08 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-Office Supplies 1.0000 EA 42.0800 42.08 GIL Account Project Amount 010-01-8200 1561 (General Fund-Mayor-Mayor Office Supplies&Minor 42.08 Equipment) Invoice Items 1 10701383 Office Supplies Edit 09/22/2020 10/05/2020 10/05/2020 64.95 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-Office Supplies 1.0000 EA 64.9500 64.95 GIL Account Project Amount 010-01-8200 1561 (General Fund-Mayor-Mayor Office Supplies&Minor 64.95 Equipment) Invoice Items 1 Vendor 6981-QUILL CORPORATION Totals Invoices 3 $141.77 Vendor 8210-RC SYSTEMS Run by Emily Graham on 10/02/2020 12:23:03 PM Page 79 of 119 Page 58 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 97548 LABOR&SUPPLIES FOR CABLING Edit 09/21/2020 10/05/2020 10/05/2020 581.90 BETWEEN IT&WATCH COMMAND P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- LABOR&SUPPLIES FOR 1.0000 EA 581.9000 581.90 CABLING BETWEEN IT&WATCH COMMAND GIL Account Project Amount 010-11-1105 1321 (General Fund-Police Department-Police Computer 581.90 Services Data Processing Services) Invoice Items 1 Vendor 8210-RC SYSTEMS Totals Invoices 1 $581.90 Vendor 21815-REPUBLIC SERVICES INC 0897-000907622 TRASH&RECYCLE PICKUP,OCT Edit 09/20/2020 10/05/2020 10/05/2020 255.48 '20 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-TRASH&RECYCLE PICKUP, 1.0000 EA 255.4800 255.48 OCT'20 GIL Account Project Amount 010-29-7700 1371 (General Fund-Airport Commission-Airport 255.48 Administration Building&Grounds Maintenance) Invoice Items 1 Vendor 21815-REPUBLIC SERVICES INC Totals Invoices 1 $255.48 Vendor 3600-RICOH USA INC 5060398252 COPIER MAINTENANCE Edit 09/10/2020 10/05/2020 10/05/2020 09/22/2020 105.42 AGREEMENT P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-COPIER MAINTENANCE 1.0000 EA 105.4200 105.42 AGREEMENT GIL Account Project Amount 010-29-7700 1376(General Fund-Airport Commission-Airport 105.42 Administration Office Equipment Repair&Maintenance) Invoice Items 1 Vendor 3600-RICOH USA INC Totals Invoices 1 $105.42 Vendor 1246-RYDELL CHEVROLET,INC 728499P CONNECTOR Edit 09/15/2020 10/05/2020 10/05/2020 18.63 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CONNECTOR 1.0000 EA 18.6300 18.63 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 18.63 Service Machinery&Equipment Replacement Parts) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 80 of 119 Page 59 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 1246-RYDELL CHEVROLET,INC Totals Invoices 1 $18.63 Vendor 1259-SCHEELS-CEDAR FALLS 19314 REPAIR TO EQUIPMENT Edit 08/28/2020 10/05/2020 10/05/2020 159.99 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-REPAIR TO EQUIPMENT 1.0000 EA 159.9900 159.99 GIL Account Project Amount 010-37-4180 1319(General Fund-Leisure Services-SportsPlex Other 37SPLX.OPER(CEDAR VALLEY SPORTSPLEX, 159.99 Professional Services) SPORTSPLEX OPERATIONS) Invoice Items 1 Vendor 1259-SCHEELS-CEDAR FALLS Totals Invoices 1 $159.99 Vendor 2865-SCOT'S SUPPLY 020486 PARALLEL WIRE Edit 09/17/2020 10/05/2020 10/05/2020 88.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-PARALLEL WIRE 1.0000 EA 88.0000 88.00 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 88.00 Service Machinery&Equipment Replacement Parts) Invoice Items 1 020568 SNO GO PARTS Edit 09/21/2020 10/05/2020 10/05/2020 2.22 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SNO GO PARTS 1.0000 EA 2.2200 2.22 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 2.22 Service Machinery&Equipment Replacement Parts) Invoice Items 1 Vendor 2865-SCOT'S SUPPLY Totals Invoices 2 $90.22 Vendor 8578-SHIRT SHACK,THE 20003 BLDG/SHIRTS Edit 09/21/2020 10/05/2020 10/05/2020 374.84 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-BLDG/SHIRTS 1.0000 EA 374.8400 374.84 GIL Account Project Amount 010-26-4265 1351 (General Fund-Cultural/Arts Commission-Cultural/Arts 26HMT.ADVFY20(CULT&ARTS HOTEL/MOTEL TAX 374.84 Grants&Projects Advertising Expense) PROJECTS,CULTURAL/ARTS TAX GRANT- ADVERTISING FY2020) Invoice Items 1 Vendor 8578-SHIRT SHACK,THE Totals Invoices 1 $374.84 Vendor 21239-SHRI GANAPATI&BAJRANGBALI,INC Run by Emily Graham on 10/02/2020 12:23:03 PM Page 81 of 119 Page 60 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 2021-00000578 FY21 CROSSROADS PROPERTY Edit 09/11/2020 10/05/2020 10/05/2020 19,195.00 TAX REBATE; 1ST HALF P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-FY21 CROSSROADS 1.0000 EA 19,195.0000 19,195.00 PROPERTY TAX REBATE; IST HALF GIL Account Project Amount 101-08-6215 1795(Tax Increment Financing Fund-Planning&Zoning- 19,195.00 Crossroads TIF District Property Tax Rebate) Invoice Items 1 Vendor 21239-SHRI GANAPATI&BAIRANGBALI,INC Totals Invoices 1 $19,195.00 Vendor 1309-SIGNS BY TOMORROW 74011 PURCHASE AND INSTALLATION Edit 09/29/2020 10/05/2020 10/05/2020 993.50 OF VEHICLE DECALS P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-PURCHASE AND 1.0000 EA 993.5000 993.50 INSTALLATION OF VEHICLE DECALS GIL Account Project Amount 010-12-1410 2112(General Fund-Fire Department-Fire Ambulance 993.50 Service Fire Fighting Equipment) Invoice Items 1 Vendor 1309-SIGNS BY TOMORROW Totals Invoices 1 $993.50 Vendor 1319-SLED SHED,THE 14608 TRIMMER BIKE HANDLE/BUSH Edit 09/18/2020 10/05/2020 10/05/2020 490.03 KNIFE/MOWING HEAD/TRIMMER LINE P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-TRIMMER BIKE 1.0000 EA 490.0300 490.03 HANDLE/BUSH KNIFE/MOWING HEAD/TRIMMER LINE GIL Account Project Amount 520-14-5200 1535(Sanitary Sewer Fund-Waste Management-Water 490.03 Pollution-Water Pollution Control Plant Op Hardware Items) Invoice Items 1 Vendor 1319-SLED SHED,THE Totals Invoices 1 $490.03 Vendor 4158-SPRAY-LAND USA 33889 SPRAYER PARTS Edit 09/22/2020 10/05/2020 10/05/2020 120.08 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SPRAYER PARTS 1.0000 EA 120.0800 120.08 GIL Account Project Amount Run by Emily Graham on 10/02/2020 12:23:03 PM Page 82 of 119 Page 61 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 33889 SPRAYER PARTS Edit 09/22/2020 10/05/2020 10/05/2020 120.08 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 010-37-4100 1569(General Fund-Leisure Services-Leisure Services-Parks 120.08 Vehicle Replacement Parts) Invoice Items 1 Vendor 4158-SPRAY-LAND USA Totals Invoices 1 $120.08 Vendor 5290-STANLEY CONSULTANTS INC. 225924 19Y UPTON AVENUE Edit 09/24/2020 10/05/2020 10/05/2020 3,610.00 STORMWATER DETENTION BASIN P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- 19Y UPTON AVENUE 1.0000 EA 3,610.0000 3,610.00 STORMWATER DETENTION BASIN GIL Account Project Amount 521-07-5300 2103(Storm Water Fund-City Engineer-Storm Sewers 3,610.00 Engineering&Consulting) Invoice Items 1 225926 CONT 853 DELANE AVENUE Edit 09/24/2020 10/05/2020 10/05/2020 3,891.00 STORMWATER DETENTION IMPROVEMENTS P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CONT 853 DELANE AVENUE 1.0000 EA 3,891.0000 3,891.00 STORMWATER DETENTION IMPROVEMENTS GIL Account Project Amount 521-07-5300 2103(Storm Water Fund-City Engineer-Storm Sewers 3,891.00 Engineering&Consulting) Invoice Items 1 Vendor 5290-STANLEY CONSULTANTS INC.Totals Invoices 2 $7,501.00 Vendor 1350-STAR EQUIPMENT, LTD 401749 16"DIAMOND BLADE GUARDIAN Edit 09/23/2020 10/05/2020 10/05/2020 262.23 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- 16" DIAMOND BLADE 1.0000 EA 262.2300 262.23 GUARDIAN GIL Account Project Amount 520-14-5200 1571 (Sanitary Sewer Fund-Waste Management-Water 262.23 Pollution-Water Pollution Control Plant Op Machinery&Equipment Replacement Parts) Invoice Items 1 Vendor 1350-STAR EQUIPMENT,LTD Totals Invoices 1 $262.23 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 83 of 119 Page 62 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 1360-STETSON BUILDING PRODUCTS INC 14235127-00 METAL KEYWAY/EPDXY/REBAR Edit 09/18/2020 10/05/2020 10/05/2020 238.69 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- METAL 1.0000 EA 238.6900 238.69 KEYWAY/EPDXY/REBAR GIL Account Project Amount 205-19-7110 1511 (Local Option Sales Tax-Street Department-Seal 238.69 Coating Program Concrete&Aggregates) Invoice Items 1 Vendor 1360-STETSON BUILDING PRODUCTS INC Totals Invoices 1 $238.69 Vendor 13063-STOREY KENWORTHY PINV839500 DISINFECTANT SPRAY Edit 09/24/2020 10/05/2020 10/05/2020 17.54 P.O.Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-DISINFECTANT SPRAY 1.0000 EA 17.5400 17.54 GIL Account Project Amount 283-13-5452 1541 (Housing Programs-Housing Authority-Section 8 13FAC.CARES V(FEDERAL ANNUAL CONTRIBUTIONS 17.54 Janitorial Supplies) CONTRACT,CARES ACT ADMINISTRATIVE FEES- VOUCHER) Invoice Items 1 PINV839517 3 PLY DISPOSABLE CHILD MASK Edit 09/24/2020 10/05/2020 10/05/2020 17.54 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-3 PLY DISPOSABLE CHILD 1.0000 EA 17.5400 17.54 MASK GIL Account Project Amount 283-13-5452 1573(Housing Programs-Housing Authority-Section 8 13FAC.CARES V(FEDERAL ANNUAL CONTRIBUTIONS 17.54 Safety&Protective Equipment) CONTRACT,CARES ACT ADMINISTRATIVE FEES- VOUCHER) Invoice Items 1 PINV836617 HAND SANITIZER DISPENSERS Edit 09/15/2020 10/05/2020 10/05/2020 275.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-HAND SANITIZER 1.0000 EA 275.0000 275.00 DISPENSERS GIL Account Project Amount 010-33-3100 1561 (General Fund-Library-Library Services Office Supplies 275.00 &Minor Equipment) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 84 of 119 Page 63 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount PINV839853 ENVELOPES, PAINT MARKERS,ID Edit 09/24/2020 10/05/2020 10/05/2020 64.98 POUCH,BUSINESS CARDS P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ENVELOPES, PAINT 1.0000 EA 64.9800 64.98 MARKERS,ID POUCH,BUSINESS CARDS GIL Account Project Amount 010-11-1100 1561 (General Fund-Police Department-Police Operations 64.98 Office Supplies&Minor Equipment) Invoice Items 1 PINV836167 DISINFECTANT SPRAY Edit 09/14/2020 10/05/2020 10/05/2020 15.72 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-DISINFECTANT SPRAY 1.0000 EA 15.7200 15.72 GIL Account Project Amount 520-14-5200 1541 (Sanitary Sewer Fund-Waste Management-Water 15.72 Pollution-Water Pollution Control Plant Op Janitorial Supplies) Invoice Items 1 PINV837534 PADS/TAPE/HIGHLIGHTERS Edit 09/17/2020 10/05/2020 10/05/2020 162.76 P.O.Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-PADS/TAPE/HIGHLIGHTERS 1.0000 EA 162.7600 162.76 GIL Account Project Amount 520-14-5200 1561 (Sanitary Sewer Fund-Waste Management-Water 162.76 Pollution-Water Pollution Control Plant Op Office Supplies&Minor Equipment) Invoice Items 1 Vendor 13063-STOREY KENWORTHY Totals Invoices 6 $553.54 Vendor 21318-STRAND CORPORATION INC 0164141 CONT 994 BIOSOLIDS PROJECT Edit 09/13/2020 10/05/2020 10/05/2020 59,371.62 4463.009 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CONT 994 BIOSOLIDS 1.0000 EA 59,371.6200 59,371.62 PROJECT 4463.009 GIL Account Project Amount 520-14-5280 2103(Sanitary Sewer Fund-Waste Management-Water 14SRF.SOLIDS(STATE REVOLVING LOAN FUND, 59,371.62 Pollution-Plant Improvements-SRF/Grants Engineering&Consulting) PLANT SOLIDS MODIFICATIONS) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 85 of 119 Page 64 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 0164227 CONT 1021 DIGESTER NO 3 Edit 09/14/2020 10/05/2020 10/05/2020 10,000.00 REPAIR COVER PROJECT P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CONT 1021 DIGESTER NO 3 1.0000 EA 10,000.0000 10,000.00 REPAIR COVER PROJECT GIL Account Project Amount 520-14-5280 2103(Sanitary Sewer Fund-Waste Management-Water 14INS.DIG3(SEWER INSURANCE, DIGESTER#3 LID) 10,000.00 Pollution-Plant Improvements-SRF/Grants Engineering&Consulting) Invoice Items 1 Vendor 21318-STRAND CORPORATION INC Totals Invoices 2 $69,371.62 Vendor 1366-STREICHER'S Q337702 AVON C50 CBRN TWIN-PORT Edit 09/18/2020 10/05/2020 10/05/2020 2,310.00 MASK(6) P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-AVON C50 CBRN TWIN- 1.0000 EA 2,310.0000 2,310.00 PORT MASK(6) GIL Account Project Amount 010-11-1150 1573(General Fund-Police Department-Police Grants Safety 11GRT.COVID20(POLICE DEPARTMENT GRANTS AND 2,310.00 &Protective Equipment) PROJECTS,COVIDI9 RESPONSE PROJECT) Invoice Items 1 I1453914 DUTY HELMET WITH SAFETY Edit 09/23/2020 10/05/2020 10/05/2020 13,189.00 VISORS(121) P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-DUTY HELMET WITH 1.0000 EA 13,189.0000 13,189.00 SAFETY VISORS(121) GIL Account Project Amount 010-11-1150 1573 (General Fund-Police Department-Police Grants Safety 11GRT.COVID20(POLICE DEPARTMENT GRANTS AND 13,189.00 &Protective Equipment) PROJECTS,COVIDI9 RESPONSE PROJECT) Invoice Items 1 Vendor 1366-STREICHER'S Totals Invoices 2 $15,499.00 Vendor 1370-SUPERIOR WELDING SUPPLY CO 969904 PAD TREATED WIRE FEED Edit 09/10/2020 10/05/2020 10/05/2020 27.98 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-PAD TREATED WIRE FEED 1.0000 EA 27.9800 27.98 GIL Account Project Amount 010-18-7950 1571(General Fund-Central Garage-Central Garage 27.98 Machinery&Equipment Replacement Parts) Invoice Items 1 Vendor 1370-SUPERIOR WELDING SUPPLY CO Totals Invoices 1 $27.98 Vendor 21218-TANDEM GRAPHICS,INC. Run by Emily Graham on 10/02/2020 12:23:03 PM Page 86 of 119 Page 65 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 2020-13 CONSULTING THRU 09/30/20 Edit 09/30/2020 10/05/2020 10/05/2020 1,435.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CONSULTING THRU 1.0000 EA 1,435.0000 1,435.00 09/30/20 GIL Account Project Amount 010-03-8400 1319(General Fund-City Clerk&Finance-City Clerk& 1,435.00 Finance Other Professional Services) Invoice Items 1 Vendor 21218-TANDEM GRAPHICS,INC.Totals Invoices 1 $1,435.00 Vendor 974-TESTAMERICA LABORATORIES,INC. 3100035032 LAB TESTING Edit 09/23/2020 10/05/2020 10/05/2020 3,402.79 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- LAB TESTING 1.0000 EA 3,402.7900 3,402.79 GIL Account Project Amount 520-14-5200 1323(Sanitary Sewer Fund-Waste Management-Water 3,402.79 Pollution-Water Pollution Control Plant Op Laboratory Services) Invoice Items 1 Vendor 974-TESTAMERICA LABORATORIES,INC.Totals Invoices 1 $3,402.79 Vendor 20939-TOTER LLC 65700777 REFUSE CARTS Edit 09/14/2020 10/05/2020 10/05/2020 15,312.50 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- REFUSE CARTS 1.0000 EA 15,312.5000 15,312.50 GIL Account Project Amount 525-15-5400 1596(Sanitation Fund-Waste Management-Sanitation-Solid 15,312.50 Waste Disposal Refuse&Yard Waste Containers) Invoice Items 1 Vendor 20939-TOTER LLC Totals Invoices 1 $15,312.50 Vendor 1441-TRACTOR SUPPLY 100487300 TANK CLEANER Edit 09/14/2020 10/05/2020 10/05/2020 33.97 P.O.Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-TANK CLEANER 1.0000 EA 33.9700 33.97 GIL Account Project Amount 010-37-4100 1537(General Fund-Leisure Services-Leisure Services-Parks 33.97 Horticultural&Landscaping Supplies) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 87 of 119 Page 66 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 100487390 PUMP Edit 09/15/2020 10/05/2020 10/05/2020 159.99 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-PUMP 1.0000 EA 159.9900 159.99 GIL Account Project Amount 010-37-4100 1571 (General Fund-Leisure Services-Leisure Services-Parks 159.99 Machinery&Equipment Replacement Parts) Invoice Items 1 100487521 MOLE TRAPS Edit 09/16/2020 10/05/2020 10/05/2020 53.98 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-MOLE TRAPS 1.0000 EA 53.9800 53.98 GIL Account Project Amount 010-37-4120 1371 (General Fund-Leisure Services-Golf Courses Building 53.98 &Grounds Maintenance) Invoice Items 1 100487605 FILTERS Edit 09/17/2020 10/05/2020 10/05/2020 72.96 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-FILTERS 1.0000 EA 72.9600 72.96 GIL Account Project Amount 010-37-4100 1569(General Fund-Leisure Services-Leisure Services-Parks 72.96 Vehicle Replacement Parts) Invoice Items 1 Vendor 1441-TRACTOR SUPPLY Totals Invoices 4 $320.90 Vendor 22035-TRUCK CENTER COMPANIES EAST LLC X101160456:01 PARTS FOR 121302 Edit 09/01/2020 10/05/2020 10/05/2020 3,310.18 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-PARTS FOR 121302 1.0000 EA 3,310.1800 3,310.18 GIL Account Project Amount 010-18-1405 1571 (General Fund-Central Garage-Fire-Garage Parts& 3,310.18 Service Machinery&Equipment Replacement Parts) Invoice Items 1 X101160668:01 VALVE Edit 09/01/2020 10/05/2020 10/05/2020 88.31 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-VALVE 1.0000 EA 88.3100 88.31 GIL Account Project Amount 010-18-1411 1571 (General Fund-Central Garage-Ambulance-Garage 88.31 Parts&Service Machinery&Equipment Replacement Parts) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 88 of 119 Page 67 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount X101160775:01 SEAL 0-RING/SENSOR GP Edit 09/02/2020 10/05/2020 10/05/2020 146.68 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SEAL 0-RING/SENSOR GP 1.0000 EA 146.6800 146.68 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 146.68 Service Machinery&Equipment Replacement Parts) Invoice Items 1 X101161486:02 SEAT CUSHION Edit 09/10/2020 10/05/2020 10/05/2020 111.08 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SEAT CUSHION 1.0000 EA 111.0800 111.08 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 111.08 Service Machinery&Equipment Replacement Parts) Invoice Items 1 X101161599:01 QUIKTIE ROD ASSY Edit 09/10/2020 10/05/2020 10/05/2020 204.68 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-QUIKTIE ROD ASSY 1.0000 EA 204.6800 204.68 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 204.68 Service Machinery&Equipment Replacement Parts) Invoice Items 1 X101161632:01 WATER HEATER HOSE Edit 09/10/2020 10/05/2020 10/05/2020 4.34 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-WATER HEATER HOSE 1.0000 EA 4.3400 4.34 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 4.34 Service Machinery&Equipment Replacement Parts) Invoice Items 1 X101162034:01 SENSOR/RING Edit 09/15/2020 10/05/2020 10/05/2020 50.39 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SENSOR/RING 1.0000 EA 50.3900 50.39 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 50.39 Service Machinery&Equipment Replacement Parts) Invoice Items 1 X101161775:05 LED STROBES Edit 09/16/2020 10/05/2020 10/05/2020 255.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- LED STROBES 1.0000 EA 255.0000 255.00 GIL Account Project Amount Run by Emily Graham on 10/02/2020 12:23:03 PM Page 89 of 119 Page 68 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount X101161775:05 LED STROBES Edit 09/16/2020 10/05/2020 10/05/2020 255.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 255.00 Service Machinery&Equipment Replacement Parts) Invoice Items 1 X101162134:01 HOSE/FRTLNR Edit 09/16/2020 10/05/2020 10/05/2020 703.93 STERLIN/TENSIONER BELT P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- HOSE/FRTLNR 1.0000 EA 703.9300 703.93 STERLIN/TENSIONER BELT GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 703.93 Service Machinery&Equipment Replacement Parts) Invoice Items 1 X101162354:01 CLAMP Edit 09/17/2020 10/05/2020 10/05/2020 16.32 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CLAMP 1.0000 EA 16.3200 16.32 GIL Account Project Amount 010-18-7955 1571 (General Fund-Central Garage-Garage-Motor Pool 16.32 Service Machinery&Equipment Replacement Parts) Invoice Items 1 Vendor 22035-TRUCK CENTER COMPANIES EAST LLC Totals Invoices 10 $4,890.91 Vendor 8568-TRUCK OUTFITTERS PLUS 101938 BRUSH TRUCK: RUNNING Edit 09/28/2020 10/05/2020 10/05/2020 389.55 BOARDS P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- Brush Truck: Running 1.0000 EA 389.5500 389.55 Boards GIL Account Project Amount 010-12-1410 2112(General Fund-Fire Department-Fire Ambulance 389.55 Service Fire Fighting Equipment) Invoice Items 1 Vendor 8568-TRUCK OUTFITTERS PLUS Totals Invoices 1 $389.55 Vendor 10265-TURFWERKS Run by Emily Graham on 10/02/2020 12:23:03 PM Page 90 of 119 Page 69 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 3I52509 FUEL FILTERS#7312 Edit 09/22/2020 10/05/2020 10/05/2020 75.41 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-FUEL FILTERS#7312 1.0000 EA 75.4100 75.41 GIL Account Project Amount 010-37-4120 1569(General Fund-Leisure Services-Golf Courses Vehicle 75.41 Replacement Parts) Invoice Items 1 Vendor 10265-TURFWERKS Totals Invoices 1 $75.41 Vendor 21911-UNIFIRST CORPORATION 188041 SERVICE-SPORTSPLEX Edit 09/21/2020 10/05/2020 10/05/2020 118.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SERVICE-SPORTSPLEX 1.0000 EA 118.0000 118.00 GIL Account Project Amount 010-37-4180 1390(General Fund-Leisure Services-SportsPlex Other 37SPLX.OPER(CEDAR VALLEY SPORTSPLEX, 118.00 Contractual Services) SPORTSPLEX OPERATIONS) Invoice Items 1 188539 SERVICE-GATES MAINT Edit 09/24/2020 10/05/2020 10/05/2020 33.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SERVICE-GATES MAINT 1.0000 EA 33.0000 33.00 GIL Account Project Amount 010-37-4120 1319(General Fund-Leisure Services-Golf Courses Other 33.00 Professional Services) Invoice Items 1 188540 SERVICE-GATES PRO SHOP Edit 09/24/2020 10/05/2020 10/05/2020 14.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SERVICE-GATES PRO 1.0000 EA 14.0000 14.00 SHOP GIL Account Project Amount 010-37-4120 1319(General Fund-Leisure Services-Golf Courses Other 14.00 Professional Services) Invoice Items 1 188832 SERVICE-SPORTSPLEX Edit 09/28/2020 10/05/2020 10/05/2020 118.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SERVICE-SPORTSPLEX 1.0000 EA 118.0000 118.00 GIL Account Project Amount 010-37-4180 1390(General Fund-Leisure Services-SportsPlex Other 37SPLX.OPER(CEDAR VALLEY SPORTSPLEX, 118.00 Contractual Services) SPORTSPLEX OPERATIONS) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 91 of 119 Page 70 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 188833 SERVICE-SHOP Edit 09/28/2020 10/05/2020 10/05/2020 54.50 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SERVICE-SHOP 1.0000 EA 54.5000 54.50 GIL Account Project Amount 010-37-4100 1319(General Fund-Leisure Services-Leisure Services-Parks 54.50 Other Professional Services) Invoice Items 1 Vendor 21911-UNIFIRST CORPORATION Totals Invoices 5 $337.50 Vendor 20614-UNITY POINT HEALTH 2021-00000585 NEW HIRE CARDIAC STRESS Edit 09/28/2020 10/05/2020 10/05/2020 218.00 TEST: B.GAUDINEER P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- NEW HIRE CARDIAC 1.0000 EA 218.0000 218.00 STRESS TEST: B.GAUDINEER GIL Account Project Amount 010-12-1400 1314(General Fund-Fire Department-Fire Protection 218.00 Service Health Services) Invoice Items 1 Vendor 20614-UNITY POINT HEALTH Totals Invoices 1 $218.00 Vendor 6691-USDA/APHIS/WILDLIFE SERVICES 21-7219-9000-RA ANNUAL WILDLIFE TRAINING, Edit 09/24/2020 10/05/2020 10/05/2020 500.00 WATERLOO REGIONAL AIRPORT P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ANNUAL WILDLIFE 1.0000 EA 500.0000 500.00 TRAINING,WATERLOO REGIONAL AIRPORT GIL Account Project Amount 010-29-7700 1346(General Fund-Airport Commission-Airport 500.00 Administration Travel-Professional Training) Invoice Items 1 Vendor 6691-USDA/APHIS/WILDLIFE SERVICES Totals Invoices 1 $500.00 Vendor 1484-UTILITY EQUIPMENT COMPANY 30058733-000 EJ FRAME/AGS El LID/GASKET Edit 09/18/2020 10/05/2020 10/05/2020 687.28 SEAL P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- EJ FRAME/AGS EJ 1.0000 EA 687.2800 687.28 LID/GASKET SEAL GIL Account Project Amount 520-14-5200 1571 (Sanitary Sewer Fund-Waste Management-Water 687.28 Pollution-Water Pollution Control Plant Op Machinery&Equipment Replacement Parts) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 92 of 119 Page 71 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 1484-UTILITY EQUIPMENT COMPANY Totals Invoices 1 $687.28 Vendor 1487-VAN METER INDUSTRIAL,INC. 5011282563.001 ELECTRICAL SUPPLIES Edit 09/18/2020 10/05/2020 10/05/2020 377.66 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ELECTRICAL SUPPLIES 1.0000 EA 377.6600 377.66 GIL Account Project Amount 520-14-5200 1521 (Sanitary Sewer Fund-Waste Management-Water 377.66 Pollution-Water Pollution Control Plant Op Electrical Supplies) Invoice Items 1 5011282563.002 ELECTRICAL SUPPLIES Edit 09/18/2020 10/05/2020 10/05/2020 94.31 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ELECTRICAL SUPPLIES 1.0000 EA 94.3100 94.31 GIL Account Project Amount 520-14-5200 1521 (Sanitary Sewer Fund-Waste Management-Water 94.31 Pollution-Water Pollution Control Plant Op Electrical Supplies) Invoice Items 1 S011283475.001 ELECTRICAL SUPPLIES Edit 09/18/2020 10/05/2020 10/05/2020 49.57 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ELECTRICAL SUPPLIES 1.0000 EA 49.5700 49.57 GIL Account Project Amount 520-14-5200 1521 (Sanitary Sewer Fund-Waste Management-Water 49.57 Pollution-Water Pollution Control Plant Op Electrical Supplies) Invoice Items 1 5011283909.001 TORK FOR LED FIXTURES Edit 09/18/2020 10/05/2020 10/05/2020 94.31 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-TORK FOR LED FIXTURES 1.0000 EA 94.3100 94.31 GIL Account Project Amount 520-14-5200 1521 (Sanitary Sewer Fund-Waste Management-Water 94.31 Pollution-Water Pollution Control Plant Op Electrical Supplies) Invoice Items 1 5011285417.001 ELECTRICAL SUPPLIES Edit 09/22/2020 10/05/2020 10/05/2020 166.42 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ELECTRICAL SUPPLIES 1.0000 EA 166.4200 166.42 GIL Account Project Amount 520-14-5200 1521 (Sanitary Sewer Fund-Waste Management-Water 166.42 Pollution-Water Pollution Control Plant Op Electrical Supplies) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 93 of 119 Page 72 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 5011285800.001 ELECTRICAL SUPPLIES Edit 09/22/2020 10/05/2020 10/05/2020 471.97 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ELECTRICAL SUPPLIES 1.0000 EA 471.9700 471.97 GIL Account Project Amount 520-14-5200 1521 (Sanitary Sewer Fund-Waste Management-Water 471.97 Pollution-Water Pollution Control Plant Op Electrical Supplies) Invoice Items 1 5011286710.001 ELECTRICAL SUPPLIES Edit 09/23/2020 10/05/2020 10/05/2020 164.73 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-ELECTRICAL SUPPLIES 1.0000 EA 164.7300 164.73 GIL Account Project Amount 520-14-5200 1521 (Sanitary Sewer Fund-Waste Management-Water 164.73 Pollution-Water Pollution Control Plant Op Electrical Supplies) Invoice Items 1 S011287122.001 ELECTRICAL SUPPLIES Edit 09/23/2020 10/05/2020 10/05/2020 483.64 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- ELECTRICAL SUPPLIES 1.0000 EA 483.6400 483.64 GIL Account Project Amount 520-14-5200 1521 (Sanitary Sewer Fund-Waste Management-Water 483.64 Pollution-Water Pollution Control Plant Op Electrical Supplies) Invoice Items 1 5011288608.001 ELECTRICAL SUPPLIES Edit 09/23/2020 10/05/2020 10/05/2020 90.48 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- ELECTRICAL SUPPLIES 1.0000 EA 90.4800 90.48 GIL Account Project Amount 520-14-5200 1521 (Sanitary Sewer Fund-Waste Management-Water 90.48 Pollution-Water Pollution Control Plant Op Electrical Supplies) Invoice Items 1 Vendor 1487-VAN METER INDUSTRIAL,INC.Totals Invoices 9 $1,993.09 Vendor 6447-VANDEWALLE&ASSOCIATES 202009002 21A IMPLEMENTATION SRVCS Edit 09/18/2020 10/05/2020 10/05/2020 8,264.85 THRU SEPT 18. 2020 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-21A IMPLEMENTATION 1.0000 EA 8,264.8500 8,264.85 SRVCS THRU SEPT 18. 2020 GIL Account Project Amount 420-08-6270 2103(June 2020 GO Bond Fund-Planning&Zoning- 08PRO.IMP21 (SPECIAL PROJECTS, DOWNTOWN 8,264.85 Downtown(Urban)TIF District Engineering&Consulting) IMPLEMENTATION FY21) Invoice Items 1 Vendor 6447-VANDEWALLE&ASSOCIATES Totals Invoices 1 $8,264.85 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 94 of 119 Page 73 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 7739-VERIZON WIRELESS 20173265-3051389 SMS PRESERVATION 8/10/20- Edit 09/06/2020 10/05/2020 10/05/2020 50.00 8/17/20 FOR INV V ZUBAK W20- 061410 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-SMS PRESERVATION 1.0000 EA 50.0000 50.00 8/10/20-8/17/20 FOR INV V ZUBAK W20- 061410 GIL Account Project Amount 010-11-1100 1319(General Fund-Police Department-Police Operations 50.00 Other Professional Services) Invoice Items 1 Vendor 7739-VERIZON WIRELESS Totals Invoices 1 $50.00 Vendor 5663-VESSCO INC 80851 MEMBRANE/CLAMP Edit 08/10/2020 10/05/2020 10/05/2020 4,814.56 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-MEMBRANE/CLAMP 1.0000 EA 4,814.5600 4,814.56 GIL Account Project Amount 520-14-5200 1372(Sanitary Sewer Fund-Waste Management-Water 4,814.56 Pollution-Water Pollution Control Plant Op Facility Maintenance) Invoice Items 1 Vendor 5663-VESSCO INC Totals Invoices 1 $4,814.56 Vendor 1535-WATERLOO COMMUNITY SCHOOL DISTRICT 9999776 COMMUNITY DEVELOPMENT- Edit 08/05/2020 10/05/2020 10/05/2020 75.00 PAY ESTIMATE FORM P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-COMMUNITY 1.0000 EA 75.0000 75.00 DEVELOPMENT-PAY ESTIMATE FORM GIL Account Project Amount 010-03-8970 1353(General Fund-City Clerk&Finance-Print Shop 75.00 Printing Services) Invoice Items 1 99101456 TRAFFIC-PET REGISTRATION Edit 08/27/2020 10/05/2020 10/05/2020 152.52 2019 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-TRAFFIC-PET 1.0000 EA 152.5200 152.52 REGISTRATION 2019 GIL Account Project Amount 010-03-8970 1353(General Fund-City Clerk&Finance-Print Shop 152.52 Printing Services) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 95 of 119 Page 74 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 9997758B CULTURE ARTS-BLANK Edit 08/31/2020 10/05/2020 10/05/2020 86.10 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CULTURE ARTS-BLANK 1.0000 EA 86.1000 86.10 GIL Account Project Amount 010-03-8970 1353(General Fund-City Clerk&Finance-Print Shop 86.10 Printing Services) Invoice Items 1 Vendor 1535-WATERLOO COMMUNITY SCHOOL DISTRICT Totals Invoices 3 $313.62 Vendor 1551-WATERLOO OIL COMPANY 82571 PRESSURE/VACUUM VENT Edit 09/10/2020 10/05/2020 10/05/2020 09/24/2020 232.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-PRESSURE/VACUUM VENT 1.0000 EA 232.0000 232.00 GIL Account Project Amount 010-29-7700 1371 (General Fund-Airport Commission-Airport 232.00 Administration Building&Grounds Maintenance) Invoice Items 1 Vendor 1551-WATERLOO OIL COMPANY Totals Invoices 1 $232.00 Vendor 1563-WATERLOO WATER WORKS 2021-00000571 WATER/SEWER,AIRPORT Edit 09/22/2020 10/05/2020 10/05/2020 103.75 TERMINAL,ACCT#124123- 510268 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-WATER/SEWER,AIRPORT 1.0000 EA 103.7500 103.75 TERMINAL,ACCT#124123-510268 GIL Account Project Amount 010-29-7700 1400(General Fund-Airport Commission-Airport 103.75 Administration Utility Service) Invoice Items 1 2021-00000575 WATER/SEWER, HANGAR 4, Edit 09/22/2020 10/05/2020 10/05/2020 118.75 ACCT#124122-510270 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-WATER/SEWER, HANGAR 4, 1.0000 EA 118.7500 118.75 ACCT#124122-510270 GIL Account Project Amount 010-29-7700 1400(General Fund-Airport Commission-Airport 118.75 Administration Utility Service) Invoice Items 1 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 96 of 119 Page 75 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 2021-00000576 WATER/SEWER,CARWASH,ACCT Edit 09/22/2020 10/05/2020 10/05/2020 79.93 #124126-510270 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-WATER/SEWER,CARWASH, 1.0000 EA 79.9300 79.93 ACCT#124126-510270 GIL Account Project Amount 010-29-7700 1400(General Fund-Airport Commission-Airport 79.93 Administration Utility Service) Invoice Items 1 2021-00000579 RT-WATER&SEWER Edit 09/22/2020 10/05/2020 10/05/2020 1,148.69 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-RT-SEWER 1.0000 GAL 837.5000 837.50 GIL Account Project Amount 283-13-5450 1400(Housing Programs-Housing Authority-Ridgeway 837.50 Towers Utility Service) Conversion Item-RT-WATER 1.0000 EA 311.1900 311.19 GIL Account Project Amount 283-13-5450 1400(Housing Programs-Housing Authority-Ridgeway 311.19 Towers Utility Service) Invoice Items 2 Vendor 1563-WATERLOO WATERWORKS Totals Invoices 4 $1,451.12 Vendor 9724-WAVERLY TIRE CO 282949 CHANGED TIRE ON WAM Edit 09/11/2020 10/05/2020 10/05/2020 09/24/2020 10.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CHANGED TIRE ON WAM 1.0000 EA 10.0000 10.00 GIL Account Project Amount 010-29-7700 1571 (General Fund-Airport Commission-Airport 10.00 Administration Machinery&Equipment Replacement Parts) Invoice Items 1 Vendor 9724-WAVERLY TIRE CO Totals Invoices 1 $10.00 Vendor 7587-MICHELLE WEIDNER 2021-00000594 AICPA MEMBERSHIP THRU Edit 09/24/2020 10/05/2020 10/05/2020 285.00 07/31/21 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-AICPA MEMBERSHIP THRU 1.0000 EA 285.0000 285.00 07/31/21 GIL Account Project Amount 010-03-8400 1391 (General Fund-City Clerk&Finance-City Clerk& 285.00 Finance Dues&Memberships) Invoice Items 1 Vendor 7587-MICHELLE WEIDNER Totals Invoices 1 $285.00 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 97 of 119 Page 76 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 1577-WERTJES UNIFORMS 52925 CARGO PANTS(2)FOR MULLER Edit 09/23/2020 10/05/2020 10/05/2020 168.00 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CARGO PANTS(2)FOR 1.0000 EA 168.0000 168.00 MULLER GIL Account Project Amount 010-11-1100 1579(General Fund-Police Department-Police Operations 168.00 Uniforms) Invoice Items 1 52930 CARGO PANTS(1),S/S POLO(1), Edit 09/25/2020 10/05/2020 10/05/2020 175.09 L/S POLO(1)FOR PO MRZUAK P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-CARGO PANTS(1),S/S 1.0000 EA 175.0900 175.09 POLO(1), L/S POLO(1) FOR PO MRZUAK GIL Account Project Amount 010-11-1100 1579(General Fund-Police Department-Police Operations 175.09 Uniforms) Invoice Items 1 Vendor 1577-WERTJES UNIFORMS Totals Invoices 2 $343.09 Vendor 20896-KIM WYBORNEY 2021-00000570 PETTY CASH (12)RESERVE Edit 09/24/2020 10/05/2020 10/05/2020 24.00 OFFICERS PAYMENT FOR FY21 P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item- PETTY CASH (12) RESERVE 1.0000 EA 24.0000 24.00 OFFICERS PAYMENT FOR FY21 GIL Account Project Amount 010-11-1100 1319(General Fund-Police Department-Police Operations 24.00 Other Professional Services) Invoice Items 1 Vendor 20896-KIM WYBORNEY Totals Invoices 1 $24.00 Vendor 1621-YOUNG PLUMBING&HEATING CO 1608R WATER SERVICE REPAIR- Edit 09/10/2020 10/05/2020 10/05/2020 09/11/2020 4,249.00 LAFAYETTE-E PARK AVE RAMP P.O. Number Item Description Quantity U/M Amount/Unit Total Amount Vendor Catalog Part Number Contract Number Conversion Item-WATER SERVICE REPAIR- 1.0000 EA 4,249.0000 4,249.00 LAFAYETTE-E PARK AVE RAMP GIL Account Project Amount 417-22-7960 2180(June 2017 GO Bond Fund-Building Inspection- 4,249.00 Parking Facility Construction Parking Improvements) Invoice Items 1 Vendor 1621-YOUNG PLUMBING&HEATING CO Totals Invoices 1 $4,249.00 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 98 of 119 Page 77 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Detail Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Grand Totals Invoices 323 $1,151,551.34 Run by Emily Graham on 10/02/2020 12:23:03 PM Page 99 of 119 Page 78 of 78 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 7218-QWEST 151436505 CHARGES FOR ACCOUNT Edit 10/20/2020 10/05/2020 10/05/2020 948.52 85605101 2021-00000589 LIBRARY FAX LINE Edit 09/13/2020 10/05/2020 10/05/2020 09/01/2020 76.73 Vendor 7218-QWEST Totals Invoices 2 $1,025.25 Vendor 423-AAA DRAIN DOCTOR 53993 RT-SHOWER DRAIN IN # 113 Edit 10/07/2019 10/05/2020 10/05/2020 105.00 Vendor 423-AAA DRAIN DOCTOR Totals Invoices 1 $105.00 Vendor 11784-ACTION SIGNS,LLC 4873 PRINTING AAND MATERIALS FOR Edit 09/28/2020 10/05/2020 10/05/2020 09/28/2020 1,600.00 NEIGHBORHOOD SERVICES TRAILER Vendor 11784-ACTION SIGNS,LLC Totals Invoices 1 $1,600.00 Vendor 5419-AECOM TECHNICAL SERVICES,INC 2000406343 AIRPORT WATER MAIN IMP; Edit 09/15/2020 10/05/2020 10/05/2020 1,219.26 SERVICES AUG 15-SEP 11,2020 2000398026 CONT 877 DRY RUN CREEK Edit 08/25/2020 10/05/2020 10/05/2020 27,192.47 INTERCEPTOR 2000406329 18W FINAL CLARIFIER Edit 09/15/2020 10/05/2020 10/05/2020 7,553.03 MAINTENANCE AND REPAIRS Vendor 5419-AECOM TECHNICAL SERVICES,INC Totals Invoices 3 $35,964.76 Vendor 11320-AGVANTAGE FS,INC. 53008184 UNLEADED GAS W/ETH 10% Edit 09/16/2020 10/05/2020 10/05/2020 12,627.27 Vendor 11320-AGVANTAGE FS,INC.Totals Invoices 1 $12,627.27 Vendor 22-AHLERS&COONEY,P.C. 789610 MUNI COMM UTILITY Edit 09/19/2020 10/05/2020 10/05/2020 3,225.00 790134 SEWER 2020A TAXABLE SRF Edit 09/22/2020 10/05/2020 10/05/2020 8,015.08 LOAN 790135 SEWER 2020B TAXABLE SRF Edit 09/22/2020 10/05/2020 10/05/2020 11,004.32 LOAN 790136 SEWER 2020C TAXABLE SRF Edit 09/22/2020 10/05/2020 10/05/2020 16,004.33 LOAN Vendor 22-AHLERS&COONEY,P.C.Totals Invoices 4 $38,248.73 Vendor 42-ALLEN GLASS COMPANY,INC 00020686 INSTALL GLASS BARRIERS AT Edit 09/21/2020 10/05/2020 10/05/2020 1,512.00 AIRLINE COUNTERS Vendor 42-ALLEN GLASS COMPANY,INC Totals Invoices 1 $1,512.00 Vendor 5996-ALLEN OCCUPATIONAL HEALTH SERVICES Run by Emily Graham on 10/02/2020 12:17:51 PM Page 100 of 119 Page 1 of 20 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 36214 PREEMPLOYMENT VISION TEST Edit 09/15/2020 10/05/2020 10/05/2020 25.00 FOR R.WENCE Vendor 5996-ALLEN OCCUPATIONAL HEALTH SERVICES Totals Invoices 1 $25.00 Vendor 8563-AMENT INC 2743 20AB DOWNTOWN FIBER OPTIC Edit 09/03/2020 10/05/2020 10/05/2020 3,712.95 CAMERAS 2759 19AE TRAFF SAFETY IMPR Edit 09/08/2020 10/05/2020 10/05/2020 1,425.00 RIDGEWAY&GREYHOUND Vendor 8563-AMENT INC Totals Invoices 2 $5,137.95 Vendor 59-AMERICAN PLANNING ASSOCIATION 158082-2075 MEMBERSHIP RENEWAL; Edit 07/10/2020 10/05/2020 10/05/2020 308.00 HYBERGER 2830279-2075 MEMBERSHIP RENEWAL; Edit 07/10/2020 10/05/2020 10/05/2020 308.00 DORNOFF Vendor 59-AMERICAN PLANNING ASSOCIATION Totals Invoices 2 $616.00 Vendor 67-ANSWER PLUS INC 001-084200924202 RT-ANSWERING SERVICE Edit 09/24/2020 10/05/2020 10/05/2020 112.00 Vendor 67-ANSWER PLUS INC Totals Invoices 1 $112.00 Vendor 20968-AP INDUSTRIAL STEEL,INC 11582 SQ TUBE Edit 09/17/2020 10/05/2020 10/05/2020 38.58 Vendor 20968-AP INDUSTRIAL STEEL,INC Totals Invoices 1 $38.58 Vendor 72-ARAMARK UNIFORM SERVICES,INC. 1877396319 MATS,TOWELS-CITY HALL Edit 09/22/2020 10/05/2020 10/05/2020 09/22/2020 125.96 1877392059 JANITORIAL Edit 09/14/2020 10/05/2020 10/05/2020 149.40 SERVICES/UNIFORMS 1877395555 JANITORIAL Edit 09/21/2020 10/05/2020 10/05/2020 187.86 SERVICES/UNIFORMS 1877396276 MOPS,TOWEL SERVICE Edit 09/22/2020 10/05/2020 10/05/2020 122.44 1877396320 MATS,TOWELS,&BIO HAZARD Edit 09/22/2020 10/05/2020 10/05/2020 136.12 BAG CLEANING-WPD 1877395556 JANITORIAL Edit 09/21/2020 10/05/2020 10/05/2020 93.88 SERVICES/UNIFORMS 1877395560 JANITORIAL Edit 09/21/2020 10/05/2020 10/05/2020 421.17 SUPPLIES/UNIFORMS 1877399088 UNIFORMS/RUGS CLEANING& Edit 09/28/2020 10/05/2020 10/05/2020 18.89 RENTAL Vendor 72-ARAMARK UNIFORM SERVICES,INC.Totals Invoices 8 $1,255.72 Vendor 3222-ARNOLD MOTOR SUPPLY 46NVO33569 SPARK PLUGS Edit 09/15/2020 10/05/2020 10/05/2020 47.10 46NVO33588 STOCK PARTS Edit 09/16/2020 10/05/2020 10/05/2020 106.90 Run by Emily Graham on 10/02/2020 12:17:51 PM Page 101 of 119 Page 2 of 20 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 46NVO33589 DEF Edit 09/16/2020 10/05/2020 10/05/2020 35.97 46NVO33609 GASKET Edit 09/16/2020 10/05/2020 10/05/2020 4.08 46NVO33610 WHL NUT Edit 09/16/2020 10/05/2020 10/05/2020 4.51 46NVO33624 1/4"MALE PLUG A-STYLE Edit 09/16/2020 10/05/2020 10/05/2020 6.45 46NVO33638 BRAKES Edit 09/17/2020 10/05/2020 10/05/2020 46.95 46NVO33641 I-B WELD SKIN CD Edit 09/17/2020 10/05/2020 10/05/2020 6.91 46NVO33666 TUBE CUT OIL CD/RNDRND STEM Edit 09/17/2020 10/05/2020 10/05/2020 35.11 46CR003867 CREDIT Edit 09/18/2020 10/05/2020 10/05/2020 (48.94) 46NVO33696 FUEL PUMP DRIVER MODULE Edit 09/18/2020 10/05/2020 10/05/2020 139.83 46NVO33706 OIL ONLY WHITE Edit 09/18/2020 10/05/2020 10/05/2020 72.65 46NVO33707 PARTS FOR 121332 Edit 09/18/2020 10/05/2020 10/05/2020 48.94 46NVO33726 ULTRA GREY RIGID HI-TORQUE Edit 09/18/2020 10/05/2020 10/05/2020 19.99 RTV SILICONE GSKT MKR 46NVO33808 ALTERNATOR Edit 09/21/2020 10/05/2020 10/05/2020 295.98 46NVO33944 BLADE FUSE Edit 09/23/2020 10/05/2020 10/05/2020 3.02 Vendor 3222-ARNOLD MOTOR SUPPLY Totals Invoices 16 $825.45 Vendor 12816-ARROWHEAD SCIENTIFIC,INC. 130394 BLOOD ALCOHOL URINE TEST Edit 09/21/2020 10/05/2020 10/05/2020 129.50 KITS(20)&FINGERPRINT BRUSH(3) Vendor 12816-ARROWHEAD SCIENTIFIC,INC.Totals Invoices 1 $129.50 Vendor 21785-AT&T MOBILITY LLC X09272020 ACCT#287291817096 8/20-9/19 Edit 09/19/2020 10/05/2020 10/05/2020 2,170.65 DATA&PHONE LINE MONTHLY CHARGES Vendor 21785-AT&T MOBILITY LLC Totals Invoices 1 $2,170.65 Vendor 13217-AUTO PLUS AUTO PARTS 001-393318 LOAD EQLZR ALUM Edit 09/18/2020 10/05/2020 10/05/2020 12.06 001-393326 RAVEN POWDER FREE/FOAMY Edit 09/18/2020 10/05/2020 10/05/2020 54.15 GUNKR ENG Vendor 13217-AUTO PLUS AUTO PARTS Totals Invoices 2 $66.21 Vendor 8204-B&B LAWN CARE SERVICE 1270 AUG 2020 MOWING; MISC LOTS Edit 09/08/2020 10/05/2020 10/05/2020 8,610.16 Vendor 8204-B&B LAWN CARE SERVICE Totals Invoices 1 $8,610.16 Vendor 107-BAKER&TAYLOR 2035485127 YOUTH PRINT Edit 09/23/2020 10/05/2020 10/05/2020 14.12 2035485128 YOUTH PRINT Edit 09/23/2020 10/05/2020 10/05/2020 11.23 2035485132 YOUTH PRINT Edit 09/23/2020 10/05/2020 10/05/2020 51.98 2035485133 YOUTH PRINT Edit 09/23/2020 10/05/2020 10/05/2020 17.59 Run by Emily Graham on 10/02/2020 12:17:51 PM Page 102 of 119 Page 3 of 20 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 2035485134 TEEN PRINT Edit 09/23/2020 10/05/2020 10/05/2020 14.10 2035485135 YOUTH PRINT Edit 09/23/2020 10/05/2020 10/05/2020 56.86 2035485136 TEEN PRINT Edit 09/23/2020 10/05/2020 10/05/2020 14.12 2035485137 YOUTH PRINT Edit 09/23/2020 10/05/2020 10/05/2020 49.38 2035485138 TEEN PRINT Edit 09/23/2020 10/05/2020 10/05/2020 10.64 Vendor 107-BAKER&TAYLOR Totals Invoices 9 $240.02 Vendor 114-BAUER BUILT INC. 210060783 SPARTACUS ATVS Edit 09/15/2020 10/05/2020 10/05/2020 442.56 Vendor 114-BAUER BUILT INC.Totals Invoices 1 $442.56 Vendor 20722-BBE PRO TOOLS LLC 63458 SAW KIT Edit 09/10/2020 10/05/2020 10/05/2020 269.99 Vendor 20722-BBE PRO TOOLS LLC Totals Invoices 1 $269.99 Vendor 8069-BDI 9501452577 LANDPRIDE BELTS Edit 09/21/2020 10/05/2020 10/05/2020 147.84 Vendor 8069-BDI Totals Invoices 1 $147.84 Vendor 22038-SUZANNE KAY BELLINGER SEP20RR SEPTEMBER RUN REVIEW EMS Edit 09/28/2020 10/05/2020 10/05/2020 90.00 TRAINING Vendor 22038-SUZANNE KAY BELLINGER Totals Invoices 1 $90.00 Vendor 9720-BERGEN PLUMBING 32728412 RT-REPAIR WATER LEAK IST Edit 09/23/2020 10/05/2020 10/05/2020 108.58 FLOOR HALLWAY 32771448 RT-REPAIR LEAKING SHOWER Edit 09/23/2020 10/05/2020 10/05/2020 324.18 APT#111 Vendor 9720-BERGEN PLUMBING Totals Invoices 2 $432.76 Vendor 144-BITUMINOUS MATERIAL&SUPPLY, 2213241834 CRS-2 Edit 09/21/2020 10/05/2020 10/05/2020 27,851.13 Vendor 144-BITUMINOUS MATERIAL&SUPPLY,Totals Invoices 1 $27,851.13 Vendor 148-BLACK HAWK COUNTY ATTORNEY JULY 2020 REIMBURSE TRI COUNTY JULY Edit 09/28/2020 10/05/2020 10/05/2020 9,358.20 2020 Vendor 148-BLACK HAWK COUNTY ATTORNEY Totals Invoices 1 $9,358.20 Vendor 170-BLACK HAWK COUNTY SHERIFF JULY 2020 REIMBURSE TRI COUNTY JULY Edit 09/28/2020 10/05/2020 10/05/2020 5,580.00 2020 Vendor 170-BLACK HAWK COUNTY SHERIFF Totals Invoices 1 $5,580.00 Vendor 6828-BLACK HAWK MEMORIAL CO,INC Run by Emily Graham on 10/02/2020 12:17:51 PM Page 103 of 119 Page 4 of 20 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 2020-00002711 CHARGES FOR 3 BRICKS Edit 06/29/2020 10/05/2020 10/05/2020 75.00 2021-00000591 CHARGES FOR 2 BRICKS Edit 08/18/2020 10/05/2020 10/05/2020 50.00 Vendor 6828-BLACK HAWK MEMORIAL CO,INC Totals Invoices 2 $125.00 Vendor 162-BLACK HAWK RENTAL 306270-1 CAP/WEED TRIMMER SERVICE Edit 09/18/2020 10/05/2020 10/05/2020 41.25 KIT 306591-2 WATER TANK./CHOP SAW Edit 09/23/2020 10/05/2020 10/05/2020 1,151.71 Vendor 162-BLACK HAWK RENTAL Totals Invoices 2 $1,192.96 Vendor 8352-BLACK HAWK ROOF CO INC 3526 PATCHED HOLES Edit 09/18/2020 10/05/2020 10/05/2020 312.80 Vendor 8352-BLACK HAWK ROOF CO INC Totals Invoices 1 $312.80 Vendor 21628-BOOMERANG CORP 09232020 CONT 877 DRY RUN CREEK Edit 09/23/2020 10/05/2020 10/05/2020 233,881.26 ESTIMATE NO. 07 Vendor 21628- BOOMERANG CORP Totals Invoices 1 $233,881.26 Vendor 8449-BOUND TREE MEDICAL LLC 83769527 PEDIATRIC EXTRICATION Edit 09/28/2020 10/05/2020 10/05/2020 314.50 COLLAR 83771264 COVID-MASK WITH VISOR Edit 09/28/2020 10/05/2020 10/05/2020 91.29 Vendor 8449-BOUND TREE MEDICAL LLC Totals Invoices 2 $405.79 Vendor 21979-BROCK EVEN CONSTRUCTION LLC 1009-8 CONTRACT#1009 FY 2020 Edit 09/04/2020 10/05/2020 10/05/2020 59,506.49 SIDEWALK&TRAIL REPAIR PROGRAM ZONE 10 1009-9 CONT 1009 SIDEWALK TRAIL Edit 09/28/2020 10/05/2020 10/05/2020 5,525.61 PROGRAM Vendor 21979- BROCK EVEN CONSTRUCTION LLC Totals Invoices 2 $65,032.10 Vendor 207-BRODART COMPANY B5970508 ADULT PRINT Edit 09/21/2020 10/05/2020 10/05/2020 158.43 Vendor 207-BRODART COMPANY Totals Invoices 1 $158.43 Vendor 208-BROTHERS CONSTRUCTION 1538 ESTIMATE#1-714 HOPE Edit 09/25/2020 10/05/2020 10/05/2020 09/28/2020 5,449.00 AVENUE-LEAD Vendor 208-BROTHERS CONSTRUCTION Totals Invoices 1 $5,449.00 Vendor 7986-C.J.COOPER&ASSOC.INC 159871 HR RANDOM DRUG SCREENINGS Edit 09/22/2020 10/05/2020 10/05/2020 70.00 Vendor 7986-C.J.COOPER&ASSOC.INC Totals Invoices 1 $70.00 Run by Emily Graham on 10/02/2020 12:17:51 PM Page 104 of 119 Page 5 of 20 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 221-CAMPBELL SUPPLY CO INV-00175990 FLAGS STAKE RED 100/PK Edit 09/18/2020 10/05/2020 10/05/2020 14.30 INV-00176166 SHOCKWAVE 2 PWR BIT TX 125 Edit 09/18/2020 10/05/2020 10/05/2020 7.40 INV-00176237 INV UTIL YLW PNT Edit 09/18/2020 10/05/2020 10/05/2020 6.10 INV-00177525 HEX KEY Edit 09/23/2020 10/05/2020 10/05/2020 34.32 INV-00177426 GLOVES&GLOVES FOR CITY Edit 09/23/2020 10/05/2020 10/05/2020 215.04 WIDE CLEANUP Vendor 221-CAMPBELL SUPPLY CO Totals Invoices 5 $277.16 Vendor 6169-CDW GOVERNMENT,LLC 1047859 BLACK BOX FIBER 1M PATCH Edit 09/08/2020 10/05/2020 10/05/2020 09/08/2020 74.06 CABLE 1060010 TRIPP POWER STRIP Edit 09/09/2020 10/05/2020 10/05/2020 09/09/2020 64.43 1107859 BLACKBOX FIBER 1M SM 9 Edit 09/09/2020 10/05/2020 10/05/2020 09/09/2020 31.74 MICRON LC-SC 1688770 BLACKBOX 2M ST ST FIBER Edit 09/21/2020 10/05/2020 10/05/2020 09/21/2020 19.72 CONNECTORS Vendor 6169-CDW GOVERNMENT,LLC Totals Invoices 4 $189.95 Vendor 245-CEDAR FALLS POLICE DIVISION JULY 2020 REIMBURSE TRI COUNTY JULY Edit 09/28/2020 10/05/2020 10/05/2020 5,971.80 2020 Vendor 245-CEDAR FALLS POLICE DIVISION Totals Invoices 1 $5,971.80 Vendor 10986-CENTER FOR BEHAVIORAL HEALTH 2021-00000574 MMPI-2 FOR POTENTIAL NEW Edit 09/19/2020 10/05/2020 10/05/2020 200.00 HIRE C. KUBLI Vendor 10986-CENTER FOR BEHAVIORAL HEALTH Totals Invoices 1 $200.00 Vendor 20537-CONSTANT CONTACT,INC. WBX8WT4AB26920 MASS E-MAIL MARKETING FOR Edit 09/25/2020 10/05/2020 10/05/2020 1,890.00 15001-25000 CONTACTS Vendor 20537-CONSTANT CONTACT,INC.Totals Invoices 1 $1,890.00 Vendor 21282-CONVEY SIGN SOLUTIONS,INC INV-91971 SIGNAGE FOR P.PERFECT& Edit 09/23/2020 10/05/2020 10/05/2020 246.48 gUATEMALAN EXHIBIT Vendor 21282-CONVEY SIGN SOLUTIONS,INC Totals Invoices 1 $246.48 Vendor 12407-COOK COUNTY HOUSING AUTHORITY 10/01/2020 HAP&AF-ANDREA GARDNER Edit 09/28/2020 10/05/2020 10/05/2020 1,840.13 Vendor 12407-COOK COUNTY HOUSING AUTHORITY Totals Invoices 1 $1,840.13 Vendor 20229-COPY SYSTEMS,INC IN389023 SERVICE CALL CHARGES Edit 09/24/2020 10/05/2020 10/05/2020 40.95 Run by Emily Graham on 10/02/2020 12:17:51 PM Page 105 of 119 Page 6 of 20 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 20229-COPY SYSTEMS,INC Totals Invoices 1 $40.95 Vendor 7625-COURIER 186970-1 HR CLASSIFIED AD JOB POSTING Edit 09/01/2020 10/05/2020 10/05/2020 123.40 FINANCE MGR 187653 BOA; 1407 INDEPENDENCE AVE Edit 09/16/2020 10/05/2020 10/05/2020 12.07 187652 BOA;W OF 5605 ANSBOROUGH Edit 09/17/2020 10/05/2020 10/05/2020 16.60 187654 BOA; 326 HIGHLAND BLVD Edit 09/17/2020 10/05/2020 10/05/2020 11.07 187658 BHC SEPT BOA AGENDA Edit 09/17/2020 10/05/2020 10/05/2020 15.09 Vendor 7625-COURIER Totals Invoices 5 $178.23 Vendor 4577-D&J OIL COMPANY 71042 GASOLINE-SHOP Edit 09/23/2020 10/05/2020 10/05/2020 885.00 Vendor 4577-D&J OIL COMPANY Totals Invoices 1 $885.00 Vendor 388-DELL MARKETING L.P. 10425243154 DELL OPTIPLEX 7070 TOWER Edit 09/19/2020 10/05/2020 10/05/2020 09/19/2020 1,744.56 10426062003 DELL 24 MONITORS Edit 09/23/2020 10/05/2020 10/05/2020 09/23/2020 712.28 Vendor 388-DELL MARKETING L.P.Totals Invoices 2 $2,456.84 Vendor 389-DELTA DENTAL OF IOWA 3255900000202029 DENTAL CLAIMS PAID 9/1/20 TO Edit 09/30/2020 10/05/2020 10/05/2020 54,494.15 9/30/20 Vendor 389-DELTA DENTAL OF IOWA Totals Invoices 1 $54,494.15 Vendor 1599-DICK WITHAM FORD 267873 HOSE ASY/SEALS/PIPE Edit 09/16/2020 10/05/2020 10/05/2020 489.96 267899 ROTOR ASY/OIL/SPARK Edit 09/16/2020 10/05/2020 10/05/2020 476.36 PLUGS/BOOTS 267950 CLIP Edit 09/17/2020 10/05/2020 10/05/2020 59.70 267935 VALVE ASY Edit 09/18/2020 10/05/2020 10/05/2020 69.96 267990 CLIP Edit 09/21/2020 10/05/2020 10/05/2020 39.76 267991 COIL ASY/SPARK PLUG/MOTOR Edit 09/21/2020 10/05/2020 10/05/2020 263.90 268064 REPAIR PARTS#103 Edit 09/22/2020 10/05/2020 10/05/2020 19.15 268072 BRACKET#103 Edit 09/22/2020 10/05/2020 10/05/2020 49.74 Vendor 1599-DICK WITHAM FORD Totals Invoices 8 $1,468.53 Vendor 328-DICKEY'S PRINTING 45246 SHIRTS FOR FLAG FOOTBALL Edit 09/24/2020 10/05/2020 10/05/2020 2,040.00 Vendor 328-DICKEY'S PRINTING Totals Invoices 1 $2,040.00 Vendor 1206-DIGITECH 21210 JULY BILLING Edit 09/28/2020 10/05/2020 10/05/2020 27,287.68 21370 AUGUST BILLING Edit 09/28/2020 10/05/2020 10/05/2020 7,207.05 Vendor 1206-DIGITECH Totals Invoices 2 $34,494.73 Run by Emily Graham on 10/02/2020 12:17:51 PM Page 106 of 119 Page 7 of 20 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 21539-DUPACO CREDIT UNION 2021-00000595 DOWNPAYMENT FOR KIMBERLY Edit 09/25/2020 10/05/2020 10/05/2020 3,500.00 CALDWELL Vendor 21539-DUPACO CREDIT UNION Totals Invoices 1 $3,500.00 Vendor 454-ELECTRICAL ENGINEERING&EQUIP 6893609-00 ELECTRICAL SUPPLIES FOR 3RD Edit 09/14/2020 10/05/2020 10/05/2020 10.08 FLOOR CRIME LAB 6891510-00 ROUND COVER Edit 09/10/2020 10/05/2020 10/05/2020 6.26 6901490-00 ELECTRICAL SUPPLIES Edit 09/22/2020 10/05/2020 10/05/2020 58.56 6902625-00 ELECTRICAL SUPPLIES Edit 09/22/2020 10/05/2020 10/05/2020 67.98 6904388-00 INT ELC4536 Edit 09/23/2020 10/05/2020 10/05/2020 58.56 6902205-00 2PRTINS TAP CONS/RED BUSH Edit 09/24/2020 10/05/2020 10/05/2020 339.27 BUSHINGS Vendor 454-ELECTRICAL ENGINEERING&EQUIP Totals Invoices 6 $540.71 Vendor 7178-EMSLRC 30847 EMS CLASS 20-1800-099FE Edit 09/28/2020 10/05/2020 10/05/2020 20.00 30848 EMS CLASS 20-1800-100FE Edit 09/28/2020 10/05/2020 10/05/2020 20.00 Vendor 7178-EMSLRC Totals Invoices 2 $40.00 Vendor 471-EXPRESS SERVICES,INC. 24385719 TAMRA GONZALES, MARY Edit 09/16/2020 10/05/2020 10/05/2020 536.76 HOLMAN Vendor 471-EXPRESS SERVICES,INC.Totals Invoices 1 $536.76 Vendor 482-FARM PLAN 3869911 WHEEL&BOLT FOR WAM; PMT Edit 09/10/2020 10/05/2020 10/05/2020 09/24/2020 183.70 ON ACCT#34150-24151 3870615 FLASHLIGHT Edit 09/11/2020 10/05/2020 10/05/2020 09/24/2020 21.99 Vendor 482-FARM PLAN Totals Invoices 2 $205.69 Vendor 486-FEDEX 7-124-67537 SHIPPING CHARGES Edit 09/16/2020 10/05/2020 10/05/2020 74.41 Vendor 486-FEDEX Totals Invoices 1 $74.41 Vendor 11488-FERGUSON ENTERPRISES,INC. 7857646 HARDWARE Edit 09/21/2020 10/05/2020 10/05/2020 8.24 Vendor 11488-FERGUSON ENTERPRISES,INC.Totals Invoices 1 $8.24 Vendor 4408-FIFTH STREET TIRE,INC 194107 MOWER TIRES Edit 09/23/2020 10/05/2020 10/05/2020 544.25 Vendor 4408- FIFTH STREET TIRE,INC Totals Invoices 1 $544.25 Vendor 515-GALE/CENGAGE LEARNING Run by Emily Graham on 10/02/2020 12:17:51 PM Page 107 of 119 Page 8 of 20 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 71780364 ADULT PRINT Edit 09/04/2020 10/05/2020 10/05/2020 143.20 Vendor 515-GALE/CENGAGE LEARNING Totals Invoices 1 $143.20 Vendor 2206-GALLS INCORPORATED 016447185 DISPOSABLE TRANZPORT HOOD Edit 09/10/2020 10/05/2020 10/05/2020 382.60 5 PK(9) Vendor 2206-GALLS INCORPORATED Totals Invoices 1 $382.60 Vendor 11168-SANDIE GRECO RECEIPT MU2T13PB WET SANDBLASTER Edit 09/08/2020 10/05/2020 10/05/2020 29.99 ATTACHMENT Vendor 11168-SANDIE GRECO Totals Invoices 1 $29.99 Vendor 21601-GREEN ACRES STORAGE 2021-00000590 FY21 SAN MARNAN PROPERTY Edit 09/25/2020 10/05/2020 10/05/2020 49,618.00 TAX REBATE; 1ST HALF Vendor 21601-GREEN ACRES STORAGE Totals Invoices 1 $49,618.00 Vendor 6871-HACH COMPANY 12131007 LABORATORY SUPPLIES Edit 09/22/2020 10/05/2020 10/05/2020 657.91 Vendor 6871-HACH COMPANY Totals Invoices 1 $657.91 Vendor 10388-HENDERSON TRUCK EQUIPMENT 319529 CABLE Edit 09/09/2020 10/05/2020 10/05/2020 594.48 319535 CABLE SPLITTER Edit 09/09/2020 10/05/2020 10/05/2020 1,103.90 Vendor 10388-HENDERSON TRUCK EQUIPMENT Totals Invoices 2 $1,698.38 Vendor 22039-ANGELIA HOAG 2021-00000592 514 PLEASANT STREET-3 Edit 09/29/2020 10/05/2020 10/05/2020 09/29/2020 360.00 NIGHTS-RELOCATION Vendor 22039-ANGELIA HOAG Totals Invoices 1 $360.00 Vendor 21473-IOWA ONE CALL 225007 AUGUST FY21 LOCATE EMAILS Edit 09/18/2020 10/05/2020 10/05/2020 158.40 225125 LOCATION SERVICES Edit 09/18/2020 10/05/2020 10/05/2020 705.60 Vendor 21473-IOWA ONE CALL Totals Invoices 2 $864.00 Vendor 2358-IOWA STATE UNIVERSITY ITRNS-TJM173 dTIMMS SUPPORT Edit 06/02/2020 10/05/2020 10/05/2020 2,500.00 Vendor 2358-IOWA STATE UNIVERSITY Totals Invoices 1 $2,500.00 Vendor 830-JIM LIND SERVICE 330613 GENERATOR FUEL Edit 09/24/2020 10/05/2020 10/05/2020 21.55 Vendor 830-JIM LIND SERVICE Totals Invoices 1 $21.55 Vendor 748-JOHNSTONE SUPPLY Run by Emily Graham on 10/02/2020 12:17:51 PM Page 108 of 119 Page 9 of 20 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 1071278 OUTSIDE TEMP SENSOR; BELT Edit 09/24/2020 10/05/2020 10/05/2020 115.16 1071731 ELEC-CITY HALL Edit 09/17/2020 10/05/2020 10/05/2020 09/25/2020 79.92 Vendor 748-JOHNSTONE SUPPLY Totals Invoices 2 $195.08 Vendor 8690-JONES,RUDY/ PETTY CASH 2021-00000586 MORTGAGE LIENS AND Edit 09/28/2020 10/05/2020 10/05/2020 09/28/2020 124.00 RELEASES Vendor 8690-JONES,RUDY/ PETTY CASH Totals Invoices 1 $124.00 Vendor 11943-JSA DEVELOPMENT LLC 2020-00002712 FY20 ANNUAL DOWNTOWN Edit 07/01/2020 10/05/2020 10/05/2020 55,394.00 PROPERTY TAX REBATE; AFFILIATED COMPANIES Vendor 11943-JSA DEVELOPMENT LLC Totals Invoices 1 $55,394.00 Vendor 788-K&S WHEEL ALIGNMENT SERVICE 134674 ADJ TOE IN/CENTER STEERING Edit 09/11/2020 10/05/2020 10/05/2020 48.00 WHEEL 134715 ALIGNMENT Edit 09/16/2020 10/05/2020 10/05/2020 48.00 Vendor 788-K&S WHEEL ALIGNMENT SERVICE Totals Invoices 2 $96.00 Vendor 755-KAREN'S PRINT-RITE 171962 COLOR COPIES, LAMINATED Edit 09/23/2020 10/05/2020 10/05/2020 61.70 Vendor 755-KAREN'S PRINT-RITE Totals Invoices 1 $61.70 Vendor 9359-KARL CHEVROLET CTCS738290 PARTS FOR AMBULANCE Edit 06/17/2020 10/05/2020 10/05/2020 2,200.50 Vendor 9359-KARL CHEVROLET Totals Invoices 1 $2,200.50 Vendor 9642-KING,MATTHEW 12870 RT-CLEAN ALL CARPETS IN Edit 09/18/2020 10/05/2020 10/05/2020 95.00 #101 Vendor 9642-KING,MATTHEW Totals Invoices 1 $95.00 Vendor 20945-KOELKER PROPERTIES 2021-00000583 FY21 MIDPORT PROPERTY TAX Edit 09/24/2020 10/05/2020 10/05/2020 4,138.00 REBATE; 1ST HALF Vendor 20945-KOELKER PROPERTIES Totals Invoices 1 $4,138.00 Vendor 3076-KWWL TELEVISION 2021-00000587 FY21 LOGAN AVE PROPERTY TAX Edit 09/24/2020 10/05/2020 10/05/2020 13,845.00 REBATE; IST HALF Vendor 3076-KWWL TELEVISION Totals Invoices 1 $13,845.00 Vendor 8889-LOCKSPERTS 172751 REKEY-PUBLIC MARKET Edit 09/21/2020 10/05/2020 10/05/2020 09/22/2020 22.68 Run by Emily Graham on 10/02/2020 12:17:51 PM Page 109 of 119 Page 10 of 20 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 8889-LOCKSPERTS Totals Invoices 1 $22.68 Vendor 833-LOGAN CONTRACTORS SUPPLY,INC P79938 1/8"SEALING TIP W/SHOE Edit 09/16/2020 10/05/2020 10/05/2020 24.40 Vendor 833-LOGAN CONTRACTORS SUPPLY,INC Totals Invoices 1 $24.40 Vendor 21838-M&T BANK 10/01/2020 HAP-TRINA SMITH 0015340383 Edit 09/28/2020 10/05/2020 10/05/2020 490.00 Vendor 21838-M&T BANK Totals Invoices 1 $490.00 Vendor 2922-MACQUEEN EQUIPMENT INC. P11311 LIQUID SMOKE Edit 09/21/2020 10/05/2020 10/05/2020 993.92 Vendor 2922-MACQUEEN EQUIPMENT INC.Totals Invoices 1 $993.92 Vendor 845-MANATT'S INC. 999476 CONCRETE Edit 09/18/2020 10/05/2020 10/05/2020 181.00 Vendor 845-MANATT'S INC.Totals Invoices 1 $181.00 Vendor 848-MANPOWER,INC 35295202 YDW ATTENDANT/CHARLES Edit 09/20/2020 10/05/2020 10/05/2020 804.59 LANDFAIR Vendor 848-MANPOWER,INC Totals Invoices 1 $804.59 Vendor 855-MARTIN BROS DIST CO INC 8598839 CONCESSIONS-EXCHANGE Edit 09/17/2020 10/05/2020 10/05/2020 115.53 8607147 CONCESSIONS- EXCHANGE Edit 09/23/2020 10/05/2020 10/05/2020 380.32 8611232 CONCESSIONS-SPORTSPLEX Edit 09/25/2020 10/05/2020 10/05/2020 782.69 Vendor 855-MARTIN BROS DIST CO INC Totals Invoices 3 $1,278.54 Vendor 8147-MEDIACOM 2021-00000588 FIBER MAINTENANCE Edit 09/22/2020 10/05/2020 10/05/2020 09/01/2020 200.00 2021-00000582 8/24-9/23 SERVICE AT 1689 Edit 08/16/2020 10/05/2020 10/05/2020 59.99 BURTON AVE STE 2-TRI CO TASK FORCE 2021-00000548 9/24-10/23 SERVICE AT 1689 Edit 09/16/2020 10/05/2020 10/05/2020 59.99 BURTON AVE STE 2-TRI CO TASK FORCE 09132020 INTERNET SERVICES Edit 09/13/2020 10/05/2020 10/05/2020 174.90 Vendor 8147- MEDIACOM Totals Invoices 4 $494.88 Vendor 885-MENARDS 66291 ELEC-CITY HALL Edit 09/16/2020 10/05/2020 10/05/2020 09/24/2020 17.57 66321 ELEC-CITY HALL Edit 09/16/2020 10/05/2020 10/05/2020 09/24/2020 50.10 66357-20 CEILING TILE-CITY HALL Edit 09/17/2020 10/05/2020 10/05/2020 09/24/2020 6.86 66370 CEILING TILE-CITY HALL Edit 09/17/2020 10/05/2020 10/05/2020 09/24/2020 2.47 Run by Emily Graham on 10/02/2020 12:17:51 PM Page 110 of 119 Page 11 of 20 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 66398 ELEC-CITY HALL Edit 09/17/2020 10/05/2020 10/05/2020 09/24/2020 14.20 66453 OFFICE SUPPLIES-BLDG MAINT Edit 09/18/2020 10/05/2020 10/05/2020 09/24/2020 17.98 66295 CEMENT PATCH Edit 09/16/2020 10/05/2020 10/05/2020 12.98 65861 PLEXIGLAS FOR WELCOME DESK Edit 09/09/2020 10/05/2020 10/05/2020 221.01 65874 HARDWARE FOR PLEXIGLAS FOR Edit 09/09/2020 10/05/2020 10/05/2020 12.64 WELCOME DESK 65913 HARDWARE FOR HOLDS SHELF Edit 09/10/2020 10/05/2020 10/05/2020 21.62 CIRC WORKROOM 66732 MATERIALS&HARDWARE FOR Edit 09/22/2020 10/05/2020 10/05/2020 128.04 YOUTH DEPT DRAWERS 66302 MORTAR MIX FOR SKATE PARK Edit 09/16/2020 10/05/2020 10/05/2020 23.29 66379 PLUMBING REPAIR Edit 09/17/2020 10/05/2020 10/05/2020 5.67 66454-2020 GATES TILE CONNECTORS Edit 09/18/2020 10/05/2020 10/05/2020 8.36 66683 IRRIGATION SUPPLIES Edit 09/22/2020 10/05/2020 10/05/2020 78.47 18545 ACRYLIC FOR SNEEZE QUARDS Edit 09/24/2020 10/05/2020 10/05/2020 234.93 66366 ANTIBACTERIAL WIPES(12)& Edit 09/17/2020 10/05/2020 10/05/2020 57.37 LYSOL SPRAY(4) 63974-2020 2X8- 16 Edit 08/11/2020 10/05/2020 10/05/2020 71.96 17887-2020 75CT CLOROX WIPES Edit 09/15/2020 10/05/2020 10/05/2020 25.74 66682-2020 CHIP SEAL PROGRAM Edit 09/22/2020 10/05/2020 10/05/2020 35.96 66359 JANITORIAL SUPPLIES Edit 09/17/2020 10/05/2020 10/05/2020 1.51 66460B UTILITY HANGER Edit 09/18/2020 10/05/2020 10/05/2020 6.76 Vendor 885-MENARDS Totals Invoices 22 $1,055.49 Vendor 336-MERCY ONE 2200930 AUGUST DRUGS AMBULANCE Edit 09/28/2020 10/05/2020 10/05/2020 2,081.77 Vendor 336-MERCY ONE Totals Invoices 1 $2,081.77 Vendor 911-MIDAMERICAN ENERGY 503776003 UTILITIES-327 W 3RD Edit 09/11/2020 10/05/2020 10/05/2020 09/23/2020 164.21 2021-00000580 UTILTIES-GOLF, PARK,SPORTS Edit 09/28/2020 10/05/2020 10/05/2020 2,130.71 503761722 GE 96 W.18TH ST,ST LT Edit 09/11/2020 10/05/2020 10/05/2020 36.25 2021-00000573 AREA LIGHTING SUMMARY Edit 09/17/2020 10/05/2020 10/05/2020 .75 503779916 UTILITIES-LIFT STATION Edit 09/11/2020 10/05/2020 10/05/2020 131.51 503806582 UTILITIES-WM Edit 09/11/2020 10/05/2020 10/05/2020 80.38 503895041 UTILITIES-ORANGE ROAD Edit 09/15/2020 10/05/2020 10/05/2020 110.99 Vendor 911-MIDAMERICAN ENERGY Totals Invoices 7 $2,654.80 Vendor 904-MIDLAND SCIENTIFIC INC 6153173 AQUA Edit 09/21/2020 10/05/2020 10/05/2020 67.32 Vendor 904-MIDLAND SCIENTIFIC INC Totals Invoices 1 $67.32 Vendor 10545-MIDWEST SAFETY COUNSELORS INC Run by Emily Graham on 10/02/2020 12:17:51 PM Page 111 of 119 Page 12 of 20 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount IVC0061783 FOUR GAS METER CALIBRATION Edit 09/28/2020 10/05/2020 10/05/2020 240.00 &REPAIR Vendor 10545-MIDWEST SAFETY COUNSELORS INC Totals Invoices 1 $240.00 Vendor 2274-MIDWEST TAPE 99396233 DVD Edit 09/17/2020 10/05/2020 10/05/2020 24.39 99396234 DVD Edit 09/17/2020 10/05/2020 10/05/2020 19.89 99396236 DVDS Edit 09/17/2020 10/05/2020 10/05/2020 49.08 99396237 DVD Edit 09/17/2020 10/05/2020 10/05/2020 42.04 99396238 DVD Edit 09/17/2020 10/05/2020 10/05/2020 43.54 99396239 DVD Edit 09/17/2020 10/05/2020 10/05/2020 21.39 99396400 DVD Edit 09/17/2020 10/05/2020 10/05/2020 26.59 99396401 DVD Edit 09/17/2020 10/05/2020 10/05/2020 20.64 99396402 DVD Edit 09/17/2020 10/05/2020 10/05/2020 37.84 99396403 DVD Edit 09/17/2020 10/05/2020 10/05/2020 9.69 Vendor 2274-MIDWEST TAPE Totals Invoices 10 $295.09 Vendor 7808-MURPHY TRACTOR&EQUIPMENT 1458951 FILTER ELE/FUEL FILTER Edit 09/18/2020 10/05/2020 10/05/2020 84.82 Vendor 7808-MURPHY TRACTOR&EQUIPMENT Totals Invoices 1 $84.82 Vendor 961-MUTUAL WHEEL COMPANY 5561567 TANDEM FDRS/MOUTNING KIT Edit 09/17/2020 10/05/2020 10/05/2020 1,054.82 5562653 REPAIR PARTS#315 Edit 09/23/2020 10/05/2020 10/05/2020 56.72 5562817 CHIPPER PARTS#315 Edit 09/23/2020 10/05/2020 10/05/2020 189.75 Vendor 961-MUTUAL WHEEL COMPANY Totals Invoices 3 $1,301.29 Vendor 966-NAPA AUTO PARTS 238182 CLIP Edit 09/18/2020 10/05/2020 10/05/2020 24.00 Vendor 966-NAPA AUTO PARTS Totals Invoices 1 $24.00 Vendor 1008-NORTHLAND PRODUCTS COMPANY CMNP003206 NPC GRAY PLASTIC 55 RETURN Edit 09/17/2020 10/05/2020 10/05/2020 (66.00) INVNP0050467 DEXOS/75W90/NORPLEX Edit 09/17/2020 10/05/2020 10/05/2020 674.80 INVNP0050747 TALAMAR Edit 09/18/2020 10/05/2020 10/05/2020 1,384.50 Vendor 1008-NORTHLAND PRODUCTS COMPANY Totals Invoices 3 $1,993.30 Vendor 20668-OFFICE EXPRESS 127298-0 COPY PAPER Edit 09/23/2020 10/05/2020 10/05/2020 32.90 127298-1 OFFICE SUPPLIES Edit 09/23/2020 10/05/2020 10/05/2020 16.80 127551-0 COPY PAPER Edit 09/24/2020 10/05/2020 10/05/2020 32.90 126778-0 CLEANER&3-HOLE PUNCH Edit 09/21/2020 10/05/2020 10/05/2020 28.95 Vendor 20668-OFFICE EXPRESS Totals Invoices 4 $111.55 Run by Emily Graham on 10/02/2020 12:17:51 PM Page 112 of 119 Page 13 of 20 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 13314-OVERDRIVE INC 02863DA20301487 E-BOOKS Edit 09/21/2020 10/05/2020 10/05/2020 65.00 02863DA20303363 E-BOOKS Edit 09/22/2020 10/05/2020 10/05/2020 408.92 02863DA20303684 E-BOOKS Edit 09/22/2020 10/05/2020 10/05/2020 40.49 Vendor 13314-OVERDRIVE INC Totals Invoices 3 $514.41 Vendor 1028-OVERHEAD DOOR CO.OF WATERLOO 24702 OVERHEAD DOOR; Edit 09/24/2020 10/05/2020 10/05/2020 09/24/2020 1,130.00 TRANSMITTER-FIRE STAT#4 Vendor 1028-OVERHEAD DOOR CO.OF WATERLOO Totals Invoices 1 $1,130.00 Vendor 1127-PEPSI COLA GENERAL BOTTLING 32097712 CONCESSIONS-EXCHANGE Edit 09/23/2020 10/05/2020 10/05/2020 537.34 Vendor 1127-PEPSI COLA GENERAL BOTTLING Totals Invoices 1 $537.34 Vendor 7803-PER MAR SECURITY SERVICES 509715 PHYSICAL SECURITY OFFICER- Edit 09/12/2020 10/05/2020 10/05/2020 1,852.56 WM Vendor 7803-PER MAR SECURITY SERVICES Totals Invoices 1 $1,852.56 Vendor 1132-PETERSON CONTRACTORS,INC 934-31 CONT 934 RECONSTRUCTION OF Edit 09/28/2020 10/05/2020 10/05/2020 247,725.45 UNIVERSITY AVE Vendor 1132-PETERSON CONTRACTORS,INC Totals Invoices 1 $247,725.45 Vendor 10537-PPG ARCHITECTURAL FINISHES 983603114689 TOUCH UP PAINT FOR TERMINAL Edit 09/25/2020 10/05/2020 10/05/2020 19.60 983603114690 MATERIALS FOR DRYWALL Edit 09/25/2020 10/05/2020 10/05/2020 13.99 TOUCH UPS 983602086601 PAINT RESTROOM AT SKATE Edit 09/21/2020 10/05/2020 10/05/2020 194.74 PARK 983603114597 PAINT SUPPLIES RESTROOM AT Edit 09/23/2020 10/05/2020 10/05/2020 14.61 SKATE PARK 983603114608 PAINT RESTROOM AT SKATE Edit 09/23/2020 10/05/2020 10/05/2020 165.73 PARK 983603114615 PAINT RESTROOM AT SKATE Edit 09/23/2020 10/05/2020 10/05/2020 156.95 PARK 983603114623 PAINT RESTROOM AT SKATE Edit 09/23/2020 10/05/2020 10/05/2020 28.79 PARK 983603114627 PAINT RESTROOM AT SKATE Edit 09/23/2020 10/05/2020 10/05/2020 156.95 PARK Vendor 10537- PPG ARCHITECTURAL FINISHES Totals Invoices 8 $751.36 Vendor 13100-PRAIRIE EVENT SUPPLY,INC. 2690 TABLES,CHAIRS Edit 09/10/2020 10/05/2020 10/05/2020 5,038.00 Run by Emily Graham on 10/02/2020 12:17:51 PM Page 113 of 119 Page 14 of 20 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 13100-PRAIRIE EVENT SUPPLY,INC.Totals Invoices 1 $5,038.00 Vendor 21241-PRO-WEST&ASSOC INC 004622 SUPPORT PACKAGE Edit 09/24/2020 10/05/2020 10/05/2020 09/24/2020 2,600.00 Vendor 21241-PRO-WEST&ASSOC INC Totals Invoices 1 $2,600.00 Vendor 20142-PTL PROPERTIES,LLC 2021-00000577 FY21 MARTIN RD PROPERTY TAX Edit 09/04/2020 10/05/2020 10/05/2020 3,815.00 REBATE; 1ST HALF Vendor 20142-PTL PROPERTIES,LLC Totals Invoices 1 $3,815.00 Vendor 20487-PUSH PEDAL PULL,INC 287212 ANTIBACTERIAL WIPES COVID Edit 09/23/2020 10/05/2020 10/05/2020 1,116.00 Vendor 20487- PUSH PEDAL PULL,INC Totals Invoices 1 $1,116.00 Vendor 21956-QUADIENT LEASING N8487405 MAIL MACHINE LEASE 7-19-20 Edit 09/17/2020 10/05/2020 10/05/2020 1,031.70 TO 10-18-20 Vendor 21956-QUADIENT LEASING Totals Invoices 1 $1,031.70 Vendor 6981-QUILL CORPORATION 8797054 CLOROX WIPES Edit 07/21/2020 10/05/2020 10/05/2020 34.74 10697502 Office Supplies Edit 09/22/2020 10/05/2020 10/05/2020 42.08 10701383 Office Supplies Edit 09/22/2020 10/05/2020 10/05/2020 64.95 Vendor 6981-QUILL CORPORATION Totals Invoices 3 $141.77 Vendor 8210-RC SYSTEMS 97548 LABOR&SUPPLIES FOR CABLING Edit 09/21/2020 10/05/2020 10/05/2020 581.90 BETWEEN IT&WATCH COMMAND Vendor 8210-RC SYSTEMS Totals Invoices 1 $581.90 Vendor 21815-REPUBLIC SERVICES INC 0897-000907622 TRASH&RECYCLE PICKUP,OCT Edit 09/20/2020 10/05/2020 10/05/2020 255.48 '20 Vendor 21815-REPUBLIC SERVICES INC Totals Invoices 1 $255.48 Vendor 3600-RICOH USA INC 5060398252 COPIER MAINTENANCE Edit 09/10/2020 10/05/2020 10/05/2020 09/22/2020 105.42 AGREEMENT Vendor 3600-RICOH USA INC Totals Invoices 1 $105.42 Vendor 1246-RYDELL CHEVROLET,INC 728499P CONNECTOR Edit 09/15/2020 10/05/2020 10/05/2020 18.63 Vendor 1246-RYDELL CHEVROLET,INC Totals Invoices 1 $18.63 Run by Emily Graham on 10/02/2020 12:17:51 PM Page 114 of 119 Page 15 of 20 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 1259-SCHEELS-CEDAR FALLS 19314 REPAIR TO EQUIPMENT Edit 08/28/2020 10/05/2020 10/05/2020 159.99 Vendor 1259-SCHEELS-CEDAR FALLS Totals Invoices 1 $159.99 Vendor 2865-SCOT'S SUPPLY 020486 PARALLEL WIRE Edit 09/17/2020 10/05/2020 10/05/2020 88.00 020568 SNO GO PARTS Edit 09/21/2020 10/05/2020 10/05/2020 2.22 Vendor 2865-SCOT'S SUPPLY Totals Invoices 2 $90.22 Vendor 8578-SHIRT SHACK,THE 20003 BLDG/SHIRTS Edit 09/21/2020 10/05/2020 10/05/2020 374.84 Vendor 8578-SHIRT SHACK,THE Totals Invoices 1 $374.84 Vendor 21239-SHRI GANAPATI&BAJRANGBALI,INC 2021-00000578 FY21 CROSSROADS PROPERTY Edit 09/11/2020 10/05/2020 10/05/2020 19,195.00 TAX REBATE; 1ST HALF Vendor 21239-SHRI GANAPATI&BAJRANGBALI,INC Totals Invoices 1 $19,195.00 Vendor 1309-SIGNS BY TOMORROW 74011 PURCHASE AND INSTALLATION Edit 09/29/2020 10/05/2020 10/05/2020 993.50 OF VEHICLE DECALS Vendor 1309-SIGNS BY TOMORROW Totals Invoices 1 $993.50 Vendor 1319-SLED SHED,THE 14608 TRIMMER BIKE HANDLE/BUSH Edit 09/18/2020 10/05/2020 10/05/2020 490.03 KNIFE/MOWING HEAD/TRIMMER LINE Vendor 1319-SLED SHED,THE Totals Invoices 1 $490.03 Vendor 4158-SPRAY-LAND USA 33889 SPRAYER PARTS Edit 09/22/2020 10/05/2020 10/05/2020 120.08 Vendor 4158-SPRAY-LAND USA Totals Invoices 1 $120.08 Vendor 5290-STANLEY CONSULTANTS INC. 225924 19Y UPTON AVENUE Edit 09/24/2020 10/05/2020 10/05/2020 3,610.00 STORMWATER DETENTION BASIN 225926 CONT 853 DELANE AVENUE Edit 09/24/2020 10/05/2020 10/05/2020 3,891.00 STORMWATER DETENTION IMPROVEMENTS Vendor 5290-STANLEY CONSULTANTS INC.Totals Invoices 2 $7,501.00 Vendor 1350-STAR EQUIPMENT,LTD 401749 16"DIAMOND BLADE GUARDIAN Edit 09/23/2020 10/05/2020 10/05/2020 262.23 Vendor 1350-STAR EQUIPMENT,LTD Totals Invoices 1 $262.23 Run by Emily Graham on 10/02/2020 12:17:51 PM Page 115 of 119 Page 16 of 20 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount Vendor 1360-STETSON BUILDING PRODUCTS INC 14235127-00 METAL KEYWAY/EPDXY/REBAR Edit 09/18/2020 10/05/2020 10/05/2020 238.69 Vendor 1360-STETSON BUILDING PRODUCTS INC Totals Invoices 1 $238.69 Vendor 13063-STOREY KENWORTHY PINV839500 DISINFECTANT SPRAY Edit 09/24/2020 10/05/2020 10/05/2020 17.54 PINV839517 3 PLY DISPOSABLE CHILD MASK Edit 09/24/2020 10/05/2020 10/05/2020 17.54 PINV836617 HAND SANITIZER DISPENSERS Edit 09/15/2020 10/05/2020 10/05/2020 275.00 PINV839853 ENVELOPES, PAINT MARKERS,ID Edit 09/24/2020 10/05/2020 10/05/2020 64.98 POUCH, BUSINESS CARDS PINV836167 DISINFECTANT SPRAY Edit 09/14/2020 10/05/2020 10/05/2020 15.72 PINV837534 PADS/TAPE/HIGHLIGHTERS Edit 09/17/2020 10/05/2020 10/05/2020 162.76 Vendor 13063-STOREY KENWORTHY Totals Invoices 6 $553.54 Vendor 21318-STRAND CORPORATION INC 0164141 CONT 994 BIOSOLIDS PROJECT Edit 09/13/2020 10/05/2020 10/05/2020 59,371.62 4463.009 0164227 CONT 1021 DIGESTER NO 3 Edit 09/14/2020 10/05/2020 10/05/2020 10,000.00 REPAIR COVER PROJECT Vendor 21318-STRAND CORPORATION INC Totals Invoices 2 $69,371.62 Vendor 1366-STREICHER'S Q337702 AVON C50 CBRN TWIN-PORT Edit 09/18/2020 10/05/2020 10/05/2020 2,310.00 MASK(6) I1453914 DUTY HELMET WITH SAFETY Edit 09/23/2020 10/05/2020 10/05/2020 13,189.00 VISORS(121) Vendor 1366-STREICHER'S Totals Invoices 2 $15,499.00 Vendor 1370-SUPERIOR WELDING SUPPLY CO 969904 PAD TREATED WIRE FEED Edit 09/10/2020 10/05/2020 10/05/2020 27.98 Vendor 1370-SUPERIOR WELDING SUPPLY CO Totals Invoices 1 $27.98 Vendor 21218-TANDEM GRAPHICS,INC. 2020-13 CONSULTING THRU 09/30/20 Edit 09/30/2020 10/05/2020 10/05/2020 1,435.00 Vendor 21218-TANDEM GRAPHICS,INC.Totals Invoices 1 $1,435.00 Vendor 974-TESTAMERICA LABORATORIES,INC. 3100035032 LAB TESTING Edit 09/23/2020 10/05/2020 10/05/2020 3,402.79 Vendor 974-TESTAMERICA LABORATORIES,INC.Totals Invoices 1 $3,402.79 Vendor 20939-TOTER LLC 65700777 REFUSE CARTS Edit 09/14/2020 10/05/2020 10/05/2020 15,312.50 Vendor 20939-TOTER LLC Totals Invoices 1 $15,312.50 Vendor 1441-TRACTOR SUPPLY Run by Emily Graham on 10/02/2020 12:17:51 PM Page 116 of 119 Page 17 of 20 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 100487300 TANK CLEANER Edit 09/14/2020 10/05/2020 10/05/2020 33.97 100487390 PUMP Edit 09/15/2020 10/05/2020 10/05/2020 159.99 100487521 MOLE TRAPS Edit 09/16/2020 10/05/2020 10/05/2020 53.98 100487605 FILTERS Edit 09/17/2020 10/05/2020 10/05/2020 72.96 Vendor 1441-TRACTOR SUPPLY Totals Invoices 4 $320.90 Vendor 22035-TRUCK CENTER COMPANIES EAST LLC X101160456:01 PARTS FOR 121302 Edit 09/01/2020 10/05/2020 10/05/2020 3,310.18 X101160668:01 VALVE Edit 09/01/2020 10/05/2020 10/05/2020 88.31 X101160775:01 SEAL 0-RING/SENSOR GP Edit 09/02/2020 10/05/2020 10/05/2020 146.68 X101161486:02 SEAT CUSHION Edit 09/10/2020 10/05/2020 10/05/2020 111.08 X101161599:01 QUIKTIE ROD ASSY Edit 09/10/2020 10/05/2020 10/05/2020 204.68 X101161632:01 WATER HEATER HOSE Edit 09/10/2020 10/05/2020 10/05/2020 4.34 X101162034:01 SENSOR/RING Edit 09/15/2020 10/05/2020 10/05/2020 50.39 X101161775:05 LED STROBES Edit 09/16/2020 10/05/2020 10/05/2020 255.00 X101162134:01 HOSE/FRTLNR Edit 09/16/2020 10/05/2020 10/05/2020 703.93 STERLIN/TENSIONER BELT X101162354:01 CLAMP Edit 09/17/2020 10/05/2020 10/05/2020 16.32 Vendor 22035-TRUCK CENTER COMPANIES EAST LLC Totals Invoices 10 $4,890.91 Vendor 8568-TRUCK OUTFITTERS PLUS 101938 BRUSH TRUCK: RUNNING Edit 09/28/2020 10/05/2020 10/05/2020 389.55 BOARDS Vendor 8568-TRUCK OUTFITTERS PLUS Totals Invoices 1 $389.55 Vendor 10265-TURFWERKS JI52509 FUEL FILTERS#7312 Edit 09/22/2020 10/05/2020 10/05/2020 75.41 Vendor 10265-TURFWERKS Totals Invoices 1 $75.41 Vendor 21911-UNIFIRST CORPORATION 188041 SERVICE-SPORTSPLEX Edit 09/21/2020 10/05/2020 10/05/2020 118.00 188539 SERVICE-GATES MAINT Edit 09/24/2020 10/05/2020 10/05/2020 33.00 188540 SERVICE-GATES PRO SHOP Edit 09/24/2020 10/05/2020 10/05/2020 14.00 188832 SERVICE-SPORTSPLEX Edit 09/28/2020 10/05/2020 10/05/2020 118.00 188833 SERVICE-SHOP Edit 09/28/2020 10/05/2020 10/05/2020 54.50 Vendor 21911-UNIFIRST CORPORATION Totals Invoices 5 $337.50 Vendor 20614-UNITY POINT HEALTH 2021-00000585 NEW HIRE CARDIAC STRESS Edit 09/28/2020 10/05/2020 10/05/2020 218.00 TEST: B.GAUDINEER Vendor 20614-UNITY POINT HEALTH Totals Invoices 1 $218.00 Vendor 6691-USDA/APHIS/WILDLIFE SERVICES Run by Emily Graham on 10/02/2020 12:17:51 PM Page 117 of 119 Page 18 of 20 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 21-7219-9000-RA ANNUAL WILDLIFE TRAINING, Edit 09/24/2020 10/05/2020 10/05/2020 500.00 WATERLOO REGIONAL AIRPORT Vendor 6691-USDA/APHIS/WILDLIFE SERVICES Totals Invoices 1 $500.00 Vendor 1484-UTILITY EQUIPMENT COMPANY 30058733-000 EJ FRAME/AGS EJ LID/GASKET Edit 09/18/2020 10/05/2020 10/05/2020 687.28 SEAL Vendor 1484-UTILITY EQUIPMENT COMPANY Totals Invoices 1 $687.28 Vendor 1487-VAN METER INDUSTRIAL,INC. S011282563.001 ELECTRICAL SUPPLIES Edit 09/18/2020 10/05/2020 10/05/2020 377.66 5011282563.002 ELECTRICAL SUPPLIES Edit 09/18/2020 10/05/2020 10/05/2020 94.31 5011283475.001 ELECTRICAL SUPPLIES Edit 09/18/2020 10/05/2020 10/05/2020 49.57 5011283909.001 TORK FOR LED FIXTURES Edit 09/18/2020 10/05/2020 10/05/2020 94.31 5011285417.001 ELECTRICAL SUPPLIES Edit 09/22/2020 10/05/2020 10/05/2020 166.42 5011285800.001 ELECTRICAL SUPPLIES Edit 09/22/2020 10/05/2020 10/05/2020 471.97 5011286710.001 ELECTRICAL SUPPLIES Edit 09/23/2020 10/05/2020 10/05/2020 164.73 5011287122.001 ELECTRICAL SUPPLIES Edit 09/23/2020 10/05/2020 10/05/2020 483.64 5011288608.001 ELECTRICAL SUPPLIES Edit 09/23/2020 10/05/2020 10/05/2020 90.48 Vendor 1487-VAN METER INDUSTRIAL,INC.Totals Invoices 9 $1,993.09 Vendor 6447-VANDEWALLE&ASSOCIATES 202009002 21A IMPLEMENTATION SRVCS Edit 09/18/2020 10/05/2020 10/05/2020 8,264.85 THRU SEPT 18. 2020 Vendor 6447-VANDEWALLE&ASSOCIATES Totals Invoices 1 $8,264.85 Vendor 7739-VERIZON WIRELESS 20173265-3051389 SMS PRESERVATION 8/10/20- Edit 09/06/2020 10/05/2020 10/05/2020 50.00 8/17/20 FOR INV V ZUBAK W20- 061410 Vendor 7739-VERIZON WIRELESS Totals Invoices 1 $50.00 Vendor 5663-VESSCO INC 80851 MEMBRANE/CLAMP Edit 08/10/2020 10/05/2020 10/05/2020 4,814.56 Vendor 5663-VESSCO INC Totals Invoices 1 $4,814.56 Vendor 1535-WATERLOO COMMUNITY SCHOOL DISTRICT 9999776 COMMUNITY DEVELOPMENT- Edit 08/05/2020 10/05/2020 10/05/2020 75.00 PAY ESTIMATE FORM 99101456 TRAFFIC-PET REGISTRATION Edit 08/27/2020 10/05/2020 10/05/2020 152.52 2019 9997758B CULTURE ARTS-BLANK Edit 08/31/2020 10/05/2020 10/05/2020 86.10 Vendor 1535-WATERLOO COMMUNITY SCHOOL DISTRICT Totals Invoices 3 $313.62 Vendor 1551-WATERLOO OIL COMPANY Run by Emily Graham on 10/02/2020 12:17:51 PM Page 118 of 119 Page 19 of 20 Finance Committee Invoice Report 10/5/2020 Invoice Due Date Range 10/05/20 - 10/05/20 Report By Vendor - Invoice • Summary Listing Invoice Number Invoice Description Status Held Reason Invoice Date Due Date G/L Date Received Date Payment Date Invoice Net Amount 82571 PRESSURE/VACUUM VENT Edit 09/10/2020 10/05/2020 10/05/2020 09/24/2020 232.00 Vendor 1551-WATERLOO OIL COMPANY Totals Invoices 1 $232.00 Vendor 1563-WATERLOO WATER WORKS 2021-00000571 WATER/SEWER,AIRPORT Edit 09/22/2020 10/05/2020 10/05/2020 103.75 TERMINAL,ACCT#124123- 510268 2021-00000575 WATER/SEWER, HANGAR 4, Edit 09/22/2020 10/05/2020 10/05/2020 118.75 ACCT#124122-510270 2021-00000576 WATER/SEWER,CARWASH,ACCT Edit 09/22/2020 10/05/2020 10/05/2020 79.93 #124126-510270 2021-00000579 RT-WATER&SEWER Edit 09/22/2020 10/05/2020 10/05/2020 1,148.69 Vendor 1563-WATERLOO WATER WORKS Totals Invoices 4 $1,451.12 Vendor 9724-WAVERLY TIRE CO 282949 CHANGED TIRE ON WAM Edit 09/11/2020 10/05/2020 10/05/2020 09/24/2020 10.00 Vendor 9724-WAVERLY TIRE CO Totals Invoices 1 $10.00 Vendor 7587-MICHELLE WEIDNER 2021-00000594 AICPA MEMBERSHIP THRU Edit 09/24/2020 10/05/2020 10/05/2020 285.00 07/31/21 Vendor 7587- MICHELLE WEIDNER Totals Invoices 1 $285.00 Vendor 1577-WERTJES UNIFORMS 52925 CARGO PANTS(2)FOR MULLER Edit 09/23/2020 10/05/2020 10/05/2020 168.00 52930 CARGO PANTS(1),S/S POLO(1), Edit 09/25/2020 10/05/2020 10/05/2020 175.09 L/S POLO(1)FOR PO MRZUAK Vendor 1577-WERTJES UNIFORMS Totals Invoices 2 $343.09 Vendor 20896-KIM WYBORNEY 2021-00000570 PETTY CASH (12)RESERVE Edit 09/24/2020 10/05/2020 10/05/2020 24.00 OFFICERS PAYMENT FOR FY21 Vendor 20896-KIM WYBORNEY Totals Invoices 1 $24.00 Vendor 1621-YOUNG PLUMBING&HEATING CO 1608R WATER SERVICE REPAIR- Edit 09/10/2020 10/05/2020 10/05/2020 09/11/2020 4,249.00 LAFAYETTE-E PARK AVE RAMP Vendor 1621-YOUNG PLUMBING&HEATING CO Totals Invoices 1 $4,249.00 Grand Totals Invoices 323 $1,151,551.34 Run by Emily Graham on 10/02/2020 12:17:51 PM Page 119 of 119 Page 20 of 20