The URL can be used to link to this page

Library Board Packet 2019 12-09-19 Agenda Yorkville Public Library Michelle Pfister Meeting Room Board of Trustees December 9, 2019- 7:00 P.M. 902 Game Farm Road 1. Roll Call 2. Recognition of Visitors 3. Amendments to the Agenda 4. Minutes 5. Correspondence 6. Public Comment 7. Staff Comment 8. Report of the Treasurer Financial Statement Payment of Bills Statistics 9. Report of the Library Director 10. City Council Liaison 11. Standing Committees Policy Personnel Finance Community Relations Physical Facilities 12. Unfinished Business Digital Sign Update-Electrical Snow Bars Proposal-Showalter Boiler Repair Update Wireless Revised Proposal Per Capita Grant Requirements 13. New Business Community Survey Deadline Revised Drug Free Workplace & Smoking Policy 14. Executive Session (if needed) 1. For the appointment, employment, compensation, discipline, performance or legal counsel for the public body, including hearing testimony on a complaint lodged against an employee of the public body, or against legal counsel for the pub lic body to determine its validity. 15. Adjournment DRAFT Yorkville Public Library Personnel Committee Meeting Monday, October 7, 2019, 6:00pm 902 Game Farm Road – Michelle Pfister Meeting Room The Personnel Committee meeting was called to order at 6:00pm by President Darren Crawford. Roll Call: Darren Crawford-present, Theron Garcia-present, Julie Brendich-present, Russ Walter-present, Wamecca Rodriguez (arr. 6:05pm) Absent: Krista Danis Others Present: None Recognition of Visitors: No visitors Public Comment: None Library Director's Annual Evaluation: The purpose of the meeting was to discuss the Library Director's annual evaluation. At 6pm, President Crawford made a motion to enter into Executive Session and he stated the date and time and read the reason: For the appointment, employment, compensation, discipline, performance or dismissal of specific employees of the public body or legal counsel for the public body, including hearing testimony on a complaint lodged against an employee of the public body, or against legal counsel for the public body to determine its validity. Theron Garcia seconded. Roll call: Crawford-yes, Garcia-yes, Brendich-yes, Walter-yes. Passed 4-0. Executive Session: The committee entered into Executive Session at approximately 6:01pm. It concluded at approximately 8:03pm on a motion and second by Board members Crawford and Garcia, respectively. Voice vote approval. No action was taken on the Director's evaluation at this time. It will be presented to the Board in Executive Session at the next regular Board meeting on October 14. Adjournment: There was no further business and the meeting was adjourned at approximately 8:04pm on a motion by Mr. Crawford and second by Mr. Walter. Unanimous voice vote approval. Minutes respectfully submitted by Marlys Young, Minute Taker Page 1 of 1 DRAFT Yorkville Public Library Board of Trustees Monday, November 18, 2019, 7:00pm 902 Game Farm Road – Michelle Pfister Meeting Room The meeting was called to order at 7:00pm by President Darren Crawford, roll was called and a quorum was established. Roll Call: Julie Brendich-yes, Darren Crawford-yes, Ryan Forristall-yes, Theron Garcia-yes, Jason Hedman-yes, Wamecca Rodriquez-yes, Russ Walter-yes Absent: Krista Danis, Susan Chacon Others Present: Library Director Elisa Topper, Director of Adult Services Shelley Augustine, Circulation Manager Sharyl Iwanski-Goist, Alderman/Library Liaison Daniel Transier Recognition of Visitors: President Crawford recognized the library staff and liaison. Amendments to the Agenda: None Minutes: October 10, 2019, October 14, 2019, November 4, 2019 Mr. Walter moved and Mr. Hedman seconded the motion to approve the minutes for the Physical Facilities Committee of November 4, 2019 and Library Board meeting of October 14 as presented. Mr. Hedman seconded. Mr. Walter amended his motion to include the Physical Facilities Committee meeting of October 10. Mr. Crawford seconded the amended motion to include all three meetings. Roll call: Crawford-yes, Forristall-yes, Garcia-yes, Hedman-yes, Rodriguez-yes, Walter-yes, Brendich-yes. Carried 7-0. Correspondence: Trustee Walter reported an email had been received in response to his query about the $8,000 in IMET Funds. The funds might be received late this year or early next year.. Public Comment: None Staff Comment: None Report of the Treasurer: The Board reviewed the financial reports in the absence of the Treasurer. Payment of Bills A motion was made by President Crawford and seconded by Trustee Garcia to pay the bills as follows: $28,464.02 Accounts Payable $39,354.22 Payroll $67,818.24 TOTAL Page 1 of 4 Roll call: Crawford-yes, Forristall-yes, Garcia-yes, Hedman-yes, Rodriguez-yes, Walter-yes, Brendich-yes. Carried 7-0. Report of the Library Director: 1. Chiller screens have been installed. The $875 installation cost was not in the quote and after negotiations, Ms. Topper was able to have it reduced to $475. 2. RJ O'Neil was called due to water pump making noises and they cleaned the pump. They came on another occasion to perform preventive maintenance and found that boiler #1 had several cracks in the burners which was discussed at the Physical Facilities meeting. It was deemed an emergency situation and boiler #1 was shut down and burner parts ordered. Boiler #2 was determined to have an igniter problem and RJ O'Neil came the same day to repair it. The burner parts for boiler #1 have now been installed and preventive maintenance will be done on boiler #2. 3. It was discovered there was no hot water in the building due to the water pump being installed upside down. 4. Painting was done and siding has been repaired as of November 5th. 5. Fall cleaning will be rescheduled due to snowfall that day. 6. A theft of $50 from a wallet occurred in the reference area. Staff tried to obtain footage from the security cameras and found that the camera has not been recording since September. Though the camera is recording now, a Sound Inc. rep will provide a quote since the system is outdated. 7. Library personnel had a staff day on October 11th and watched the movie “The Public” followed by small group discussions. Barb Johnson, a PADS volunteer and former Library Board member, spoke about the available PADS services. While there has not been any PADS guests yet this year, the Library receives an update each day, of the previous night's activities. This report is forwarded to all Library managers. Ms. Topper said the staff is much better prepared this year. 8. Second Halloween contest held and prizes were awarded. 9. Ugly sweater contest to be held. 10. One person applied for Youth Services position, but later withdrew. Ms. Topper said results for background checks are taking very long. Position is being advertised on websites for City, RAILS and Library and Indeed.com was suggested. It is expected that two more employees will be leaving. Cross training will be done. City Council Liaison Alderman Transier said setback regulations for cannabis operations will be voted on next week at City Council. Standing Committees: President Crawford handed out a list of committee assignments. He also noted that the Library needs to incorporate the cannabis issue into the policy book, so the Policy Committee will need to meet next month. Unfinished Business: Electrical Work for Digital Sign-Frost Electric Ms. Topper contacted Frost Electric about the electrical hook-up since the conduit had been crushed during road construction. Frost will locate it and shut off the original circuit at no extra charge. Mr. Dhuse said the current electric connection is tied in with the parking lot lights. There was discussion on the funding for the electrical work and it was decided to use money from the Outside Building & Page 2 of 4 Maintenance fund. Mr. Walter moved and Mr. Crawford seconded a motion to approve $6,250 to run a circuit for the new sign. Roll call: Forristall-yes, Garcia-yes, Hedman-yes, Rodriguez-yes, Walter-yes, Brendich-yes, Crawford- yes. Carried 7-0. E-Rate Proposal S&G Communications Mr. Walter said three companies submitted proposals for upgrade of the wireless network with S&G Communications providing the best prices. Mr. Walter said the Board can approve the quote, however, no action can be taken until the 2020 e-rate funds are released in June. The prices will be locked in for one year. The bandwidth needs to be increased as well, but it cannot be done until the funding is received. Mr. Walter will ask for a revised proposal for the components approved by the Board. A motion was made by Mr. Walter to approve the S&G proposal for $3,057.10 for cabling, $4,356 for 12 Aruba IAP207 wireless access points, to not use S&G for bandwidth increases and all contingent on e- rate funding being approved next year. Ms. Garcia seconded the motion. Roll call: Forristall-yes, Garcia-yes, Hedman-yes, Rodriguez-yes, Walter-yes, Brendich-yes, Crawford- yes. Carried 7-0. Snow Bars/Gutter Covers Proposal-Showalter Roofing Services The original snow guards on the west side of the building were removed, but the price was not adjusted on the proposal. Ms. Topper will verify the pricing. In response to an installation query about the bars, the vendor and said the bars can be installed at a slight angle, but the gutters may still be need to be cleaned. Mr. Hedman asked what money would actually be saved by installing gutter guards if cleaning is still needed. He noted it is easier and cheaper to just clean gutters than screens over the gutters. Mr. Forristall added that pine needles can clog the holes and they are difficult to remove. The points and snow bars were both scheduled for removal and Ms. Topper said painting would then be needed. She said the triangles were removed from the gutters and the landscaper cleaned the gutters. Since the trees are scheduled to be trimmed to help alleviate clogging and the triangles removed, the Board decided to evaluate the problem after a year and not install gutter guards at this time. A motion was made by Ms. Rodriguez and seconded by Ms. Garcia to approve the Showalter Roofing Service to install the Dyna-Guard snow retention system not to exceed $9,000. Roll call: Garcia-yes, Hedman-yes, Rodriguez-yes, Walter-yes, Brendich-yes, Crawford-yes, Forristall- yes. Carried 7-0. New Business: Boiler Repair This was discussed earlier in the meeting. Per Capita Grant Requirements 2019 The grant application is due January 15th and there are three Board requirements. Board members must read Chapters 6-10 of the Trustee Facts File contained in the agenda packet. The second item is completion of an on-line class for Library safety--Ms. Topper will find suggestions and email to all prior to next meeting. Additionally, there is outreach, so the Board will discuss the Illinois Veterans' History project at the December meeting. Drug Free Workplace Policy-City of Yorkville City Council recently passed a drug free policy. Since the Library follows the City policy, this should be incorporated into the Library Policy Manual. The Policy Committee will address the incorporation. Mr. Walter asked if the smoking policy needs to include no-vaping and he suggested inclusion in the policy and that signs should be changed. Page 3 of 4 Meeting Dates 2020 It was noted the Library would start being open on Martin Luther King Day in 2021 even though the City offices are closed. Chairman Crawford moved and Ms. Garcia seconded a motion to approve the Board meeting dates for 2020. Hedman-yes, Rodriguez-yes, Walter-yes, Brendich-yes, Crawford-yes, Forristall-yes, Garcia-yes. Carried 7-0. Closing Dates It was moved and seconded by Trustees Walter and Garcia, respectively, to approve the closure dates for the Library. Roll call: Rodriguez-yes, Walter-yes, Brendich-yes, Crawford-yes, Forristall-yes, Garcia-yes, Hedman-yes. Carried 7-0. Additional Business: None Executive Session: None Adjournment: There was no further business and the meeting adjourned at 7:53pm on a motion by Mr. Walter and second by Mr. Crawford. Minutes respectfully submitted by, Marlys Young, Minute Taker DATE: 11/14/19UNITED CITY OF YORKVILLETIME: 08:21:43MANUAL CHECK REGISTERID: AP225000.WOWCHECK # VENDOR # INVOICE ITEMCHECKINVOICE #DATE# DESCRIPTIONDATE ACCOUNT #ITEM AMT------------------------------------------------------------------------------------------------------------------------------------ 900081 FNBO FIRST NATIONAL BANK OMAHA 11/25/19112519-A.HERNANDEZ 10/31/19 01 HOME DEPO-KEYS79-790-56-00-562021.51INVOICE TOTAL:21.51 *112519-A.SIMMONS 11/06/19 01 GO DADDY-STANDARD UCC SSL01-640-54-00-5450199.9902 RENEWAL** COMMENT **03 CDW-G-2 NEW COMPUTERS25-212-56-00-56353,207.6704 VERIZON-SEPT 2019 IN CAR01-210-54-00-5440720.2005 UNITS** COMMENT **06 VERIZON-SEPT 2019 MOBILE01-220-54-00-5440187.8007 PHONES** COMMENT **08 VERIZON-SEPT 2019 MOBILE01-210-54-00-5440892.3309 PHONES** COMMENT **10 VERIZON-SEPT 2019 MOBILE79-795-54-00-5440101.7611 PHONES** COMMENT **12 VERIZON-SEPT 2019 MOBILE51-510-54-00-5440180.4413 PHONES** COMMENT **14 VERIZON-SEPT 2019 MOBILE52-520-54-00-544036.0115 PHONES** COMMENT **16 ADS-NOV 2019-JAN 202023-216-54-00-5446136.8317 MONITORING AT 102 E VAN EMMON ** COMMENT **18 ADS-NOV 2019-OCT 201982-820-54-00-5462357.4819 MONITORING AT 902 GAME FARM RD ** COMMENT **20 FOX VALLEY79-790-54-00-5495560.0021 SANDBLASTING-SANDBLAST &** COMMENT **22 RECOAT SHELTER POSTS** COMMENT **INVOICE TOTAL:6,580.51 *112519-B.OLSEM10/31/19 01 WAREHOUSE DIRECT-FOLDERS01-110-56-00-561019.6002 WAREHOUSE DIRECT-BATTERIES01-110-56-00-561011.4003 CNA SURETY-OVERCHARGE CREDIT 01-110-54-00-5462-30.0004 WAREHOUSE DIRECT-BATTERIES01-110-56-00-561010.73INVOICE TOTAL:11.73 *112519-B.OLSON10/31/19 01 ICMA CONFERENCE REGISTRATION 01-110-54-00-5412790.0002 RENAISSANCE-ICMA LODGING-OLSON 01-110-54-00-5415768.15INVOICE TOTAL:1,558.15 *112519-B.PFIZENMAIER 10/31/19 01 AMERICAN TIRE#2286-OIL CHANGE 01-210-54-00-549543.0402 AMERICAN TIRE#2344-OIL CHANGE 01-210-54-00-549560.1503 AMERICAN TIRE#2293-REPLACED 01-210-54-00-5495621.8504 COOLING FAN ASSEMBLY & RELAY** COMMENT **05 AMERICAN TIRE#2308-OIL01-210-54-00-5495937.8406 CHANGE, REPLACED BRAKE PADS,** COMMENT **07 ROTARS & BATTERY** COMMENT **08 AMERICAN TIRE#2327-REPLACE01-210-54-00-549587.13Page 1 of 14 DATE: 11/14/19UNITED CITY OF YORKVILLE TIME: 08:21:43MANUAL CHECK REGISTERID: AP225000.WOWCHECK # VENDOR # INVOICE ITEMCHECKINVOICE #DATE# DESCRIPTIONDATE ACCOUNT #ITEM AMT------------------------------------------------------------------------------------------------------------------------------------ 900081 FNBO FIRST NATIONAL BANK OMAHA 11/25/19112519-B.PFIZENMAIER 10/31/19 09 BATTERY TERMINAL SWITCH** COMMENT **10 AMERICAN TIRE#2314-OIL CHANGE 01-210-54-00-549548.1511 AMERICAN TIRE#2363-OIL CHANGE 01-210-54-00-549548.1512 AMERICAN TIRE#2361-OIL CHANGE 01-210-54-00-549563.5213 AMERICAN TIRE#2310-OIL CHANGE 01-210-54-00-549584.0314 AMAZON-BOOK01-210-56-00-562043.9815 GALLS-NIKE BOOTS-MERTES01-210-56-00-5600147.2016 AMAZON-HEADLIGHTS01-210-54-00-549525.7417 IACP CONFERENCE PARKING &01-210-54-00-5415191.1018 LODGING** COMMENT **INVOICE TOTAL:2,401.88 *112519-D.BROWN10/31/19 01 R J KECK SUPPLY-PIPE THREAD 51-510-56-00-563863.4202 SEALANT, UNIONS, NIPPLES** COMMENT **INVOICE TOTAL:63.42 *112519-D.DEBORD 10/31/19 01 MENARDS-WEED CONTROL, PRUNING 82-820-56-00-562148.7502 SHEARS, HEDGE SHEARS, YARD** COMMENT **03 WASTE BAGS** COMMENT **04 MENARDS-TARP82-000-24-00-24807.57INVOICE TOTAL:56.32 *112519-D.SMITH10/31/19 01 RURAL KING-HOODIE, SHIRTS79-790-56-00-560084.96INVOICE TOTAL:84.96 *112519-E.DHUSE10/31/19 01 APWA-OCT 2019 MEMBERSHIP51-510-54-00-5412100.0002 MEETING FEE FOR DHUSE, BAUER & ** COMMENT **03 OLSON** COMMENT **04 NAPA#237352-OIL, OIL DRY79-790-56-00-564095.9205 NAPA#237657-FILTERS51-510-56-00-562810.8806 NAPA#237941-PLIERS79-790-56-00-564033.9907 NAPA#238162-FILTERS01-410-56-00-562896.8908 NAPA#238233-ANTI-SEIZE01-410-56-00-56288.4909 NAPA#238260-AIR CYLINDER SEAT 01-410-56-00-562848.8210 NAPA#238284-FILTERS, CABIN01-410-56-00-5628816.2011 AIR FILTERS** COMMENT **12 NAPA#239284-TACKY GREASE,01-410-56-00-562876.8813 DEEP CREEP** COMMENT **14 NAPA#238445-HD CREEPER01-410-56-00-5628159.9815 CASEYS-REFRESHMENTS FOR GOAL 01-110-56-00-561030.2816 SETTING MEETING** COMMENT **17 DUNKIN DONUTS-REFRESHMENTS01-110-56-00-561032.2218 FOR GOAL SETTING MEETING** COMMENT **19 AMAZON-RAIL POWER SUPPLY51-510-56-00-563823.3220 NAPA#239710-WHEEL NUTS01-410-56-00-562826.24Page 2 of 14 DATE: 11/14/19UNITED CITY OF YORKVILLE TIME: 08:21:43MANUAL CHECK REGISTERID: AP225000.WOWCHECK # VENDOR # INVOICE ITEMCHECKINVOICE #DATE# DESCRIPTIONDATE ACCOUNT #ITEM AMT------------------------------------------------------------------------------------------------------------------------------------ 900081 FNBO FIRST NATIONAL BANK OMAHA 11/25/19112519-E.DHUSE10/31/19 21 NAPA#239665-ELECTRONIC MODULE 01-410-56-00-562864.4922 NAPA#239736-ICON BLADES01-410-56-00-5628223.0423 NAPA#239735-ICON BLADES01-410-56-00-5628145.08INVOICE TOTAL:1,992.72 *112519-E.TOPPER 10/31/19 01 AMAZON-BOOKS82-000-24-00-2480152.6402 CONSTANT CONTACT-12 MONTH82-820-54-00-5462588.0003 EMAIL MARKETING CONTRACT** COMMENT **04 BOOK PAGE-ANNUAL SUBSCRIPTION 82-000-24-00-2480576.0005 JEWEL-MEETING REFRESHMENTS82-820-54-00-541266.7406 UPPER CRUST-MEETING82-820-54-00-541295.9507 REFRESHMENTS** COMMENT **08 MONTHLY PRIME MEMBERSHIP82-820-54-00-546012.9909 AMAZON-PAPER PLATES, ADDRESS 82-820-56-00-5610160.0610 LABLES, PAPER, MARKERS,** COMMENT **11 PAINTER TAPE, PENS** COMMENT **12 AMAZON-PLAYING CARDS, TONER 82-820-56-00-5610234.2613 CARTRIDGES, LABELS** COMMENT **14 AMAZON-PLASTIC COINS82-000-24-00-248014.9515 NCG-GIFT CARD82-000-24-00-248025.00INVOICE TOTAL:1,926.59 *112519-E.WILLRETT 10/31/19 01 AMAZON-FILE CABINET01-110-56-00-5610150.0602 CDW-G-10 MONITORS01-640-54-00-54501,250.0003 AMAZON-ADAPTERS01-640-54-00-545057.0504 ELEMENT FOUR-OCT 2019 CLOUD 01-640-54-00-54501,200.8205 CONNECT AGREEMENT** COMMENT **06 DOUBLETREE-ICMA CONFERENCE01-110-54-00-5415555.9007 LODGING-WILLRETT** COMMENT **08 PARAGON-6 DELL DOCKING01-640-54-00-54501,379.9409 STATIONS** COMMENT **10 PARAGON-DELL LATITUDE 740001-640-54-00-54501,169.9911 FACEBOOK ADVERTISING79-795-54-00-542630.40INVOICE TOTAL:5,794.16 *112519-G.KLEEFISCH 10/31/19 01 HOME DEPO- MECHANICAL TIMER 79-790-56-00-564075.02INVOICE TOTAL:75.02 *112519-G.STEFFENS 10/31/19 01 ADDISON BUILDING MATERIALS- 01-410-56-00-5640151.1302 ABOCRETE** COMMENT **INVOICE TOTAL:151.13 *112519-J,BAUER10/31/19 01 TRI-COUNTY TRUCK-NEW TRUCK51-510-54-00-54902,282.0002 CAP** COMMENT **INVOICE TOTAL:2,282.00 *Page 3 of 14 DATE: 11/14/19UNITED CITY OF YORKVILLE TIME: 08:21:43MANUAL CHECK REGISTERID: AP225000.WOWCHECK # VENDOR # INVOICE ITEMCHECKINVOICE #DATE# DESCRIPTIONDATE ACCOUNT #ITEM AMT------------------------------------------------------------------------------------------------------------------------------------ 900081 FNBO FIRST NATIONAL BANK OMAHA11/25/19112519-J.DYON10/31/19 01 SAMS-MEMBERSHIP RENEWAL,01-110-56-00-561058.9802 KLEENEX** COMMENT **03 TARGET-HAND SOAP01-110-56-00-56108.8704 SAMS-PAPER PLASTE, KLEENEX01-110-56-00-561030.14INVOICE TOTAL:97.99 *112519-J.ENGBERG 10/31/19 01 ADOBE-CREATIVE CLOUD MONTHLY 01-220-54-00-546052.9902 LICENSE** COMMENT **INVOICE TOTAL:52.99 *112519-J.GALAUNER 10/31/19 01 GOODWILL-SUPPLIES FOR79-795-56-00-560629.9402 SCARECROW WALK** COMMENT **03 SPIRT-SUPPLIES FOR SCARECROW 79-795-56-00-5606331.0604 WALK** COMMENT **05 TARGET-SUPPLIES FOR SCARECROW 79-795-56-00-560629.6606 WALK** COMMENT **07 WALMART-POP, BUNS, POPCORN79-795-56-00-560744.7208 USPS.COM-LETTERS TO SANTA79-795-56-00-560634.3009 AMAZON-NORTH POLE LETTERHEAD 79-795-56-00-560635.9810 AMAZON-CHRISTMAS BACKDROP79-795-56-00-560621.9811 AMAZON-ENVELOPES79-795-56-00-560629.90INVOICE TOTAL:557.54 *112519-J.JENSEN 10/31/19 01 IACP MEMBERSHIP RENEWAL-JENSEN 01-210-54-00-546095.00INVOICE TOTAL:95.00 *112519-J.WEISS10/31/19 01 JEWEL-REFRESHMENTS FOR CHILI 82-000-24-00-248016.2802 LUG PROGRAM** COMMENT **03 DOLLAR TREE-HALLOWEEN82-820-56-00-567114.0004 PROGRAMMING SUPPLIES** COMMENT **05 PIZZA HUT-REFRESHMENTS FOR82-820-56-00-567131.9606 CHILI LUG PROGRAM** COMMENT **INVOICE TOTAL:62.24 *112519-K.BARKSDALE 10/31/19 01 KONE-OCT 2019 ELEVATOR23-216-54-00-5446155.0702 MAINTENANCE** COMMENT **INVOICE TOTAL:155.07 *112519-K.GREGORY 10/31/19 01 HILTON-2019 IML PARKING-01-110-54-00-541550.0002 TRANSIER** COMMENT **03 HILTON-IML PARKING -01-110-54-00-5415146.2504 MILSCHEWSKI** COMMENT **05 MINER ELECTRIC-MANAGED01-410-54-00-5462366.8506 SERVICES RADIOS-SEPT 2019** COMMENT **07 MINER ELECTRIC-MANAGED51-510-54-00-5462430.65Page 4 of 14 DATE: 11/14/19UNITED CITY OF YORKVILLETIME: 08:21:43MANUAL CHECK REGISTERID: AP225000.WOWCHECK # VENDOR # INVOICE ITEMCHECKINVOICE #DATE# DESCRIPTIONDATE ACCOUNT #ITEM AMT------------------------------------------------------------------------------------------------------------------------------------ 900081 FNBO FIRST NATIONAL BANK OMAHA 11/25/19112519-K.GREGORY 10/31/19 08 SERVICES RADIOS-SEPT 2019** COMMENT **09 MINER ELECTRIC-MANAGED52-520-54-00-5462287.1010 SERVICES RADIOS-SEPT 2019** COMMENT **11 MINER ELECTRIC-MANAGED79-790-54-00-5462510.4012 SERVICES RADIOS-SEPT 2019** COMMENT **13 TEE JAY-DOOR REPAIR82-820-54-00-5495240.0014 ARAMARK#1591995052-MATS01-410-54-00-548548.8215 ARAMARK#1592003044-MATS51-510-54-00-548548.8216 LAWSON-HEX SCREWS, CAPS,01-410-56-00-5620160.0917 CONNECTORS, FUSES, NUTS, QUICK ** COMMENT **18 SLIDES, COTTER PINS** COMMENT **19 LAWSON-HEX SCREWS, CAPS,51-510-56-00-5620160.0920 CONNECTORS, FUSES, NUTS, QUICK ** COMMENT **21 SLIDES, COTTER PINS** COMMENT **22 LAWSON-HEX SCREWS, CAPS,52-520-56-00-5620160.0823 CONNECTORS, FUSES, NUTS, QUICK ** COMMENT **24 SLIDES, COTTER PINS** COMMENT **25 TRUGREEN-GROUNDS TREATMENT23-216-54-00-5446399.0026 MINER ELECTRIC-MANAGED01-410-54-00-5462366.8527 SERVICES RADIOS-OCT 2019** COMMENT **28 MINER ELECTRIC-MANAGED51-510-54-00-5462430.6529 SERVICES RADIOS-OCT 2019** COMMENT **30 MINER ELECTRIC-MANAGED52-520-54-00-5462287.1031 SERVICES RADIOS-OCT 2019** COMMENT **32 MINER ELECTRIC-MANAGED79-790-54-00-5462510.4033 SERVICES RADIOS-OCT 2019** COMMENT **INVOICE TOTAL:4,603.15 *112519-L.PICKERING 10/31/19 01 PF PETTIBONE-PAPER01-110-56-00-5610101.1502 WYNDHAM-LODGING FOR MUNICIPAL 01-110-54-00-5415369.5103 CLERK'S TRAING** COMMENT **04 TRIBUNE-PUBLIC HEARING NOTICE 90-149-00-00-0011204.8505 TRIBUNE-PUBLIC HEARING NOTICE 01-220-54-00-5426159.0606 FOR TEXT AMENDMENT FOR SPECAL ** COMMENT **07 USE IN B-1 DISTRICT** COMMENT **INVOICE TOTAL:834.57 *112519-M.SENG10/31/19 01 RANDALL PRESSURE SYSTEMS-BRINE 01-410-56-00-5628222.8002 TANK HOSES** COMMENT **INVOICE TOTAL:222.80 *112519-N.DECKER 10/31/19 01 AMAZON-DURABLE DESKTOP01-210-56-00-561077.1202 REFERENCE SYSTEM** COMMENT **03 COMCAST-9/15-10/14 KENCOM01-640-54-00-54491,145.5504 LINE** COMMENT **Page 5 of 14 DATE: 11/14/19UNITED CITY OF YORKVILLETIME: 08:21:43MANUAL CHECK REGISTERID: AP225000.WOWCHECK # VENDOR # INVOICE ITEMCHECKINVOICE #DATE# DESCRIPTIONDATE ACCOUNT #ITEM AMT------------------------------------------------------------------------------------------------------------------------------------ 900081 FNBO FIRST NATIONAL BANK OMAHA 11/25/19112519-N.DECKER 10/31/19 05 AMAZON-FLASHDRIVES01-210-56-00-561071.6806 AMAZON-FRAMES01-210-56-00-562055.9907 SHREDIT-SEPT 2019 SHREDDING 01-210-54-00-5462175.9608 AT&T-9/25-10/24 SERVICE01-210-54-00-5440241.2109 COMCAST-10/08-11/07 CABLE01-210-54-00-54404.2010 ACCURINT-SEPT 2019 SEARCHES 01-210-54-00-5462150.0011 WATCHGUARD VIDEO-ANNUAL01-210-54-00-54953,600.0012 SOFTWARE MAINTENANCE RENEWAL** COMMENT **13 KENDALL PRINTING-500 BUSINESS 01-210-54-00-543068.0014 CARDS-FISHER** COMMENT **INVOICE TOTAL:5,589.71 *112519-P.RATOS10/31/19 01 VISTAPRINT-DOOR HANGERS01-220-56-00-562057.7302 AMAZON-PHONE CASES01-220-56-00-562033.9803 THREAD LOGIC-6 SHIRTS, 101-220-56-00-5620207.8004 SWEATSHIRT-CREADEUR** COMMENT **05 THREAD LOGIC-4 SHIRTS, 101-220-56-00-5620178.3006 SWEATSHIRT-HASTINGS** COMMENT **07 THREAD LOGIC-3 SHIRTS, 101-220-56-00-5620113.1408 SWEATSHIRT-RATOS** COMMENT **09 BFCA-UNDERSTANDING01-220-54-00-5412195.0010 INTERNATIONAL SOLAR ENERGY** COMMENT **11 PROVISIONS SEMINAR-CREADEUR** COMMENT **INVOICE TOTAL:785.95 *112519-P.SCODRO 10/31/19 01 STOCK & FIELD-JEANS, HOODIES 51-510-56-00-5600144.99INVOICE TOTAL:144.99 *112519-R.FREDRICKSON 10/31/19 01 COMCAST-9/10-10/09 INTERNET, 82-820-54-00-5440421.2302 PHONE & CABLE** COMMENT **03 YORKVILLE POST-JRB PACKET87-870-54-00-54624.4004 MAILING** COMMENT **05 YORKVILLE POST-JRB PACKET88-880-54-00-54624.4006 MAILING** COMMENT **07 YORKVILLE POST-JRB PACKET89-890-54-00-54624.4008 MAILING** COMMENT **09 COMCAST-9/12-10/11 CABLE01-110-54-00-544021.0110 IGFOA-2019 PUBLIC PENSION01-120-54-00-5412120.0011 INSTITUTE SEMINAR-FREDRICKSON ** COMMENT **12 COMCAST-9/29-10/28 185 WOLF 79-790-54-00-544089.9013 ST INTERNET** COMMENT **14 COMCAST-9/29-10/28 185 WOLF 79-790-54-00-5440108.3915 ST PHONE & CABLE** COMMENT **16 COMCAST-9/13-10/12 610 TOWER 51-510-54-00-5440106.8517 PLANT INTERNET** COMMENT **Page 6 of 14 DATE: 11/14/19UNITED CITY OF YORKVILLETIME: 08:21:43MANUAL CHECK REGISTERID: AP225000.WOWCHECK # VENDOR # INVOICE ITEMCHECKINVOICE #DATE# DESCRIPTIONDATEACCOUNT #ITEM AMT------------------------------------------------------------------------------------------------------------------------------------ 900081 FNBO FIRST NATIONAL BANK OMAHA 11/25/19112519-R.HARMON 10/31/19 14 FUN EXPRESS-HALLOWEEN SUPPLIES 79-795-56-00-5606282.8615 AMAZON-SKELETON COSTUMES,79-795-56-00-560625.5416 COTTON BALLS, CARD GAMES, TAPE** COMMENT **17 MEASURE** COMMENT **18 MY PRESCHOOL-E BOOKS79-795-56-00-560621.0019 AMAZON-COOKING SCALE,79-795-56-00-560681.2820 HALLOWEEN STAMPS, DINNER** COMMENT **21 PLATES, HOLE PUNCH** COMMENT **INVOICE TOTAL:1,599.49 *112519-R.HORNER10/31/19 01 OCC OUTDOORS-TRASH RECEPTACLE 79-790-56-00-564086.9502 REPLACEMENT DOME TOP WITH** COMMENT **03 DOOR** COMMENT **04 ONLINE STORES-40 FLAGS79-790-56-00-5620693.00INVOICE TOTAL:779.95 *112519-R.MIKOLASEK 10/31/19 01 HOMICIDE INVESTIGATOR01-210-54-00-5415253.0802 TRAINING LODGING** COMMENT **INVOICE TOTAL:253.08 *112519-R.WRIGHT 10/31/19 01 PHYSICIANS CARE-DRUG SCREENING 01-210-54-00-546243.0002 PHYSICIANS CARE-DRUG SCREENING 51-510-54-00-546279.5003 PHYSICIANS CARE-DRUG SCREENING 52-520-54-00-546221.5004 PHYSICIANS CARE-DRUG SCREENING 79-790-54-00-546258.0005 PHYSICIANS CARE-DRUG SCREENING 79-795-54-00-5462129.00INVOICE TOTAL:331.00 *112519-S.AUGUSTINE 10/31/19 01 PANERA-REFRESHMENTS FOR82-000-24-00-248014.9902 FINANCIAL LITERACY PROGRAM** COMMENT **03 JEWEL-REFRESHMENTS FOR82-000-24-00-248022.7604 FINANCIAL LITERACY PROGRAM** COMMENT **05 JEWEL-REFRESHMENTS FOR OCT82-000-24-00-248016.9706 MOVIE PROGRAM** COMMENT **INVOICE TOTAL:54.72 *112519-S.IWANSKI 10/31/19 01 YORKVILLE POST-POSTAGE82-820-54-00-545227.2202 VISTA PRINT-250 BUSINESS CARDS 82-820-56-00-562032.5003 FLOWER SHOP-FLOWERS FOR82-820-56-00-561047.8904 HOSPITALIZED STAFF MEMBER** COMMENT **INVOICE TOTAL:107.61 *112519-S.REDMON 10/31/19 01 SHAW MEDIA-2019 HTD ADS79-795-56-00-56021,730.0002 AT&T-9/24-10/23 TOWN SQUARE 79-795-54-00-544076.9103 SIGN INTERNET** COMMENT **04 GEN POWER-2019 HTD ELECTRICITY 79-795-56-00-56027,375.00Total for all Highlighted Library Invoices: $3,226.19Page 7 of 14 82-820 LIBRARY OPERATIONS84-840 LIBRARY CAPITALDATE: 12/03/19UNITED CITY OF YORKVILLETIME: 08:07:54CHECK REGISTERPRG ID: AP215000.WOWCHECK DATE: 12/09/19CHECK # VENDOR # INVOICE INVOICE ITEMNUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT------------------------------------------------------------------------------------------------------------------------------------ 104808 BAKTAY BAKER & TAYLOR203489848211/01/19 01 BOOKS84-840-56-00-5686803.91INVOICE TOTAL:803.91 *203492641611/14/19 01 BOOKS84-840-56-00-5686909.37INVOICE TOTAL:909.37 *CHECK TOTAL:1,713.28 104809 CAMBRIA CAMBRIA SALES COMPANY INC.4115911/04/19 01 TOILET TISSUE, PAPER TOWELS, 82-820-56-00-5621989.4802 GARBAGE BAGS, VACUUM BAGS,** COMMENT **03 BOWL CLEANER, WINDEX, GLOVES, ** COMMENT **04 SOAP, GLASS CLEANER, LYSOL** COMMENT **INVOICE TOTAL:989.48 *CHECK TOTAL:989.48 104810 ERICSCUT ERIC K HILL1100911/22/19 01 FALL GROUNDS CLEANUP82-820-54-00-54951,400.00INVOICE TOTAL:1,400.00 *CHECK TOTAL:1,400.00 104811 FINDAWAY FINDAWAY WORLD LLC30488111/13/19 01 AUDIO BOOKS84-840-56-00-5683164.97INVOICE TOTAL:164.97 *CHECK TOTAL:164.97 104812 LLWCONSU LLOYD WARBER1046411/27/19 01 NOV 2019 ON SITE IT SUPPORT 82-820-54-00-5462720.00INVOICE TOTAL:720.00 *CHECK TOTAL:720.00Page 8 of 14 82-820 LIBRARY OPERATIONS 84-840 LIBRARY CAPITAL DATE: 12/03/19 UNITED CITY OF YORKVILLE TIME: 08:07:54 CHECK REGISTERPRG ID: AP215000.WOW CHECK DATE: 12/09/19CHECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT------------------------------------------------------------------------------------------------------------------------------------ 104813 MIDWTAPE MIDWEST TAPE 98196093 11/12/19 01 DVD 84-840-56-00-5685 22.49 02 AUDIO BOOKS 84-840-56-00-5683 274.93 INVOICE TOTAL: 297.42 * 98224995 11/18/19 01 AUDIO BOOK 84-840-56-00-5683 37.99 02 DVD 84-840-56-00-5685 22.49 INVOICE TOTAL: 60.48 * 98240741 11/23/19 01 DVDS 84-840-56-00-5685 42.73 INVOICE TOTAL: 42.73 * CHECK TOTAL: 400.63 104814 PROQUEST PROQUEST INFORMATION 70605482 12/02/19 01 ANCESTRY LIBRARY RENEWAL 82-820-54-00-5460 1,352.00 INVOICE TOTAL: 1,352.00 * CHECK TOTAL: 1,352.00 104815 RJONEIL R.J. O'NEIL, INC. 00110911 10/31/19 01 BOILER REPAIR 82-820-54-00-5495 232.50 INVOICE TOTAL: 232.50 * CHECK TOTAL: 232.50 104816 SHOWALT SHOWALTER ROOFING SERVICE, INC 26155 11/01/19 01 DOWNPAYMENT FOR INSTALLATION 82-820-54-00-5495 3,260.00 02 OF A SNOW RETENTION SYSTEM ** COMMENT ** INVOICE TOTAL: 3,260.00 * CHECK TOTAL: 3,260.00Page 9 of 14 82-820 LIBRARY OPERATIONS 84-840 LIBRARY CAPITAL DATE: 12/03/19 UNITED CITY OF YORKVILLE TIME: 08:07:54 CHECK REGISTERPRG ID: AP215000.WOW CHECK DATE: 12/09/19CHECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT------------------------------------------------------------------------------------------------------------------------------------ 104817 SOUND SOUND INCORPORATED R165323 11/12/19 01 DEC 2019-FEB 2020 TELEPHONE & 82-820-54-00-5462 291.00 02 VOICEMAIL MAINTENANCE ** COMMENT ** 03 AGREEMENT ** COMMENT ** INVOICE TOTAL: 291.00 * CHECK TOTAL: 291.00 104818 THYSSEN THYSSENKRUPP ELEVATOR CORP 120119 12/01/19 01 ANNUAL INSPECTION WITNESSING 82-820-54-00-5462 421.00 02 FEE FOR ELEVATORS ** COMMENT ** INVOICE TOTAL: 421.00 * CHECK TOTAL: 421.00 104819 TODAYS TODAY'S BUSINESS SOLUTIONS INC 072919-7 07/30/19 01 CHARGE FOR APR-JUN FAXES 82-820-54-00-5462 43.52 INVOICE TOTAL: 43.52 * CHECK TOTAL: 43.52 104820 YOUNGM MARLYS J. YOUNG 110419 11/14/19 01 11/04/19 MEETING MINUTES 82-820-54-00-5462 56.75 INVOICE TOTAL: 56.75 * 111819 11/25/19 01 11/18/19 MEETING MINUTES 82-820-54-00-5462 57.00 INVOICE TOTAL: 57.00 * CHECK TOTAL: 113.75 TOTAL AMOUNT PAID: 11,102.13Page 10 of 14 REGULAR OVERTIME TOTAL IMRF FICA TOTALSADMINISTRATION19,489.34$ -$ 19,489.34 1,772.54$ 1,026.02$ 22,287.90$ FINANCE10,703.47 - 10,703.47 983.33 804.02 12,490.82$ POLICE117,693.17 2,945.75 120,638.92 587.01 8,845.60 130,071.53$ COMMUNITY DEV.19,050.83 - 19,050.83 1,753.18 1,420.17 22,224.18$ STREETS13,033.09 98.95 13,132.04 1,189.76 951.13 15,272.93$ WATER16,415.37 436.15 16,851.52 1,540.33 1,240.48 19,632.33$ SEWER7,925.92 107.20 8,033.12 659.86 581.74 9,274.72$ PARKS22,885.16 110.05 22,995.21 1,979.63 1,682.06 26,656.90$ RECREATION18,144.89 - 18,144.89 1,230.52 1,354.87 20,730.28$ LIBRARY16,798.82 - 16,798.82 977.72 1,261.59 19,038.13$ TOTALS262,140.06$ 3,698.10$ 265,838.16$ 12,673.88$ 19,167.68$ 297,679.72$ TOTAL PAYROLL297,679.72$ UNITED CITY OF YORKVILLEPAYROLL SUMMARYNovember 1, 2019Page 11 of 14 REGULAR OVERTIME TOTAL IMRF FICA TOTALSMAYOR & LIQ. COM.1,043.34$ -$ 1,043.34$ -$ 79.82$ 1,123.16$ ALDERMAN4,880.00 - 4,880.00 - 373.34 5,253.34 ADMINISTRATION20,124.35 - 20,124.35 1,823.27 1,068.86 23,016.48 FINANCE11,338.46 - 11,338.46 1,027.27 841.12 13,206.85 POLICE113,866.71 1,343.84 115,210.55 587.02 8,407.34 124,204.91 COMMUNITY DEV.19,050.83 - 19,050.83 1,726.00 1,397.21 22,174.04 STREETS13,033.10 657.55 13,690.65 1,240.35 991.07 15,922.07 WATER15,665.37 - 15,665.37 1,419.28 1,140.78 18,225.43 SEWER7,770.86 - 7,770.86 704.04 560.91 9,035.81 PARKS22,985.15 - 22,985.15 2,007.09 1,674.67 26,666.91 RECREATION17,668.37 - 17,668.37 1,280.36 1,312.68 20,261.41 LIBRARY17,142.72 - 17,142.72 954.38 1,276.43 19,373.53 TOTALS264,569.26$ 2,001.39$ 266,570.65$ 12,769.06$ 19,124.23$ 298,463.94$ TOTAL PAYROLL298,463.94$ UNITED CITY OF YORKVILLEPAYROLL SUMMARYNovember 15, 2019Page 12 of 14 REGULAR OVERTIME TOTAL IMRFFICA TOTALSADMINISTRATION21,113.57$ -$ 21,113.57 1,912.90$ 1,181.25$ 24,207.72$ FINANCE10,703.47 - 10,703.47 969.74 634.98 12,308.19$ POLICE126,701.32 1,578.44 128,279.76 587.01 9,748.86 138,615.63$ COMMUNITY DEV.19,105.90 - 19,105.90 1,730.99 1,438.64 22,275.53$ STREETS16,094.87 6,219.21 22,314.08 2,021.72 1,696.32 26,032.12$ WATER14,369.33 117.76 14,487.09 1,312.52 1,098.77 16,898.38$ SEWER7,175.91 - 7,175.91 650.13 548.94 8,374.98$ PARKS21,912.17 - 21,912.17 1,950.38 1,676.15 25,538.70$ RECREATION16,835.87 - 16,835.87 1,223.73 1,287.98 19,347.58$ LIBRARY16,209.92 - 16,209.92 954.38 1,236.23 18,400.53$ TOTALS270,222.33$ 7,915.41$ 278,137.74$ 13,313.50$ 20,548.12$ 311,999.36$ TOTAL PAYROLL311,999.36$ UNITED CITY OF YORKVILLEPAYROLL SUMMARYNovember 27, 2019Page 13 of 14 Library CC Check Register (Pages 1‐ 7)11/25/2019 $3,226.19 Library Check Register (Pages 8‐10)12/09/2019 11,102.13 Flex ‐ Sept 2019 HRA Admin Fees 11/26/2019 $20.00 Lincoln Financial ‐Nov. 2019 Life Ins 11/12/2019 30.83 IPRF ‐ Dec. 2019 Workers Comp 11/12/2019 910.84 Illinois State Police‐Background Checks 11/12/2019 56.50 Blue Cross /Blue Shield‐Dec. 2019 Health Ins 11/26/2019 5,537.74 Blue Cross /Blue Shield‐Dec. 2019 Dental Ins 11/26/2019 582.29 Dearborn National ‐ Dec. 2019 Vision Ins 11/12/2019 84.33 Marlys Young‐10/7, 10/10, & 10/14 Meeting Minutes 11/12/2019 200.75 D.Donnely ‐ 11/07/19 Art Program 11/12/2019 50.00 TOTAL BILLS PAID: $21,801.60 DATE Bi‐weekly (Page 11)11/01/2019 $19,038.13 Bi‐weekly (Page 12)11/15/2019 19,373.53 Bi‐weekly (Page 13)11/27/2019 18,400.53 TOTAL PAYROLL:$56,812.19 TOTAL DISBURSEMENTS:$78,613.79 PAYROLL YORKVILLE LIBRARY BOARD BILL LIST SUMMARY Monday, December 9, 2019 ACCOUNTS PAYABLE Page 14 of 14 May June July August September October November December January February March April2019 2019 2019 2019 2019 2019 2019 2019 2020 2020 2020 2020Library Operations Old Second $ 408,036 $ 625,661 $ 589,917 $ 562,731 $ 831,380 $ 805,514 $ 750,913 Building Development FeesOld Second 90,345 87,625 89,174 93,668 93,111 150,030 146,425 Library Operations IMET * 8,007 8,007 8,007 8,007 8,007 8,007 8,007 Library Operations Illinois Funds 211,592 212,013 212,444 212,841 234,376 234,758 235,099 Total: $ 717,980 $ 933,307 $ 899,542 $ 877,248 $ 1,166,874 $ 1,198,309 $ 1,140,444 $ - $ - $ - $ - $ - * RestrictedPAYROLL1ST PAY PERIOD18,476$ $ 19,369 $ 18,734 $ 19,355 $ 19,306 $ 19,493 $ 19,188 2ND PAY PERIOD19,361 19,417 19,287 18,873 18,814 20,011 19,374 3RD PAY PERIOD 19,324 - - - - - 18,401 Total 57,162$ 38,786$ 38,021$ 38,228$ 38,120$ 39,504$ 56,962$ -$ -$ -$ -$ -$ YORKVILLE PUBLIC LIBRARYCASH STATEMENTAs of November 30, 2019FISCAL YEAR 2020 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTIONMay-19June-19July-19August-19 September-19 October-19 November-19Totals BUDGET % of BudgetLIBRARY OPERATIONS REVENUESTaxes82-000-40-00-4000 PROPERTY TAXES 58,036298,555 12,30025,236278,962 22,1017,528702,716 699,220100.50%82-000-40-00-4083 PROPERTY TAXES-DEBT SERVICE65,634337,641 13,91028,540315,483 24,9948,513794,715 793,028100.21%Intergovernmental82-000-41-00-4120 PERSONAL PROPERTY TAX1,460- 862103- 1,501- 3,927 5,250 74.80%82-000-41-00-4170 STATE GRANTS- - - - 21,151- - 21,151 20,000 105.76%Fines & Forfeits82-000-43-00-4330 LIBRARY FINES4347124921,6692791,1682314,985 8,500 58.65%Charges for Service82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS1,1938828809909664754355,821 8,000 72.76%82-000-44-00-4422 COPY FEES2943224413992643612452,326 3,750 62.01%82-000-44-00-4439 PROGRAM FEES- 152023- - - 58 -0.00%Investment Earnings82-000-45-00-4500 INVESTMENT EARNINGS7356808171,0791,3771,3941,3587,440 10,000 74.40%Miscellaneous82-000-48-00-4820 RENTAL INCOME200- - 175- 325200900 2,000 45.00%82-000-48-00-4850MISCELLANEOUS INCOME1,98137052- - 27- 2,431 2,000 121.53%Other Financing Sources82-000-49-00-4901 TRANSFER FROM GENERAL5,5881,8302,0021,8301,8302,00291115,991 25,003 63.96%TOTAL REVENUES: LIBRARY 135,555 641,006 31,77760,044620,311 54,34819,4211,562,4611,576,75199.09%LIBRARY OPERATIONS EXPENDITURESSalaries & Wages82-820-50-00-5010 SALARIES & WAGES30,98821,45120,90320,90320,90220,90331,710167,759278,39460.26%82-820-50-00-5015 PART-TIME SALARIES19,54912,67512,56012,75212,65113,93818,442102,567196,00052.33%Benefits82-820-52-00-5212RETIREMENT PLAN CONTRIBUTION2,8211,9571,9071,9071,9071,9072,88615,294 25,541 59.88%82-820-52-00-5214 FICA CONTRIBUTION3,8042,5522,5012,5162,5082,6073,77420,263 35,544 57.01%82-820-52-00-5216 GROUP HEALTH INSURANCE11,0995,3015,1125,4615,1585,0347,40144,567 81,184 54.90%82-820-52-00-5222 GROUP LIFE INSURANCE31313131313131216 387 55.76%82-820-52-00-5223 DENTAL INSURANCE1,1655825825825825825824,658 6,987 66.67%82-820-52-00-5224 VISION INSURANCE169848484848484675 1,012 66.66%82-820-52-00-5230 UNEMPLOYMENT INSURANCE172- 172- - 172- 516 750 68.83%82-820-52-00-5231 LIABILITY INSURANCE5,4161,8301,8301,8301,8301,83091115,475 24,253 63.81%Contractual Services82-820-54-00-5412 TRAINING & CONFERENCES- - - - - - 163163 2,000 8.13%82-820-54-00-5415 TRAVEL & LODGING- - - - - - 120120 1,500 8.02%82-820-54-00-5426 PUBLISHING & ADVERTISING- - - 485(52) 55- 488 2,000 24.41%YORKVILLE PUBLIC LIBRARYFISCAL YEAR 2020 BUDGET REPORTFor the Month Ended November 30, 20191 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTIONMay-19June-19July-19August-19 September-19 October-19 November-19Totals BUDGET % of BudgetYORKVILLE PUBLIC LIBRARYFISCAL YEAR 2020 BUDGET REPORTFor the Month Ended November 30, 201982-820-54-00-5440 TELECOMMUNICATIONS- 832- 842- 4224212,517 6,000 41.94%82-820-54-00-5452 POSTAGE & SHIPPING- 4598202027129 750 17.26%82-820-54-00-5460 DUES & SUBSCRIPTIONS1,5331313- 1191,6501,4814,809 11,000 43.72%82-820-54-00-5462 PROFESSIONAL SERVICES4,0591,9831,1813,3841,3392,7504,09118,788 40,000 46.97%82-820-54-00-5466 LEGAL SERVICES- - - 630- - - 630 3,000 21.00%82-820-54-00-5468 AUTOMATION2,249- - 3,804- 4,299- 10,351 20,000 51.76%82-820-54-00-5480 UTILITIES- - 559774- 8257592,916 11,130 26.20%82-820-54-00-5495OUTSIDE REPAIR & MAINTENANCE2484,9217,3591,3432,6409,5271,55327,591 50,000 55.18%82-820-54-00-5498 PAYING AGENT FEES- 1,100- 589- - 1,689 1,700 99.32%Supplies82-820-56-00-5610 OFFICE SUPPLIES- 1124375005281,0111,6914,279 8,000 53.49%82-820-56-00-5620 OPERATING SUPPLIES- 30923408- - 6131,354 3,000 45.12%82-820-56-00-5621 CUSTODIAL SUPPLIES- 1,397- 120918100492,583 8,000 32.28%82-820-56-00-5635COMPUTER EQUIPMENT & SOFTWARE- - - - - - - -2,000 0.00%82-820-56-00-5671 LIBRARY PROGRAMMING- 2261- 376131178768 1,000 76.76%82-820-56-00-5675 EMPLOYEE RECOGNITION- - - - 70- - 70 200 35.22%82-820-56-00-5685 DVD'S- - - - - - - -500 0.00%82-820-56-00-5686 BOOKS- - - 273- 22- 295 1,500 19.67%2006 Bond82-820-84-00-8000 PRINCIPAL PAYMENT- - - - - - - -50,000 0.00%82-820-84-00-8050 INTEREST PAYMENT- 11,306- - - - - 11,306 22,613 50.00%2013 Refunding Bond82-820-99-00-8000 PRINCIPAL PAYMENT- - - - - - - -585,0000.00%82-820-99-00-8050 INTEREST PAYMENT- 69,700- - - - - 69,700 139,40050.00%TOTAL FUND REVENUES135,555 641,006 31,77760,044620,311 54,34819,4211,562,4611,576,75199.09%TOTAL FUND EXPENDITURES83,303 138,204 55,32559,22651,61367,89876,968532,5361,620,34532.87%FUND SURPLUS (DEFICIT)52,251 502,802 (23,548) 818568,697 (13,550) (57,546) 1,029,925(43,594) LIBRARY CAPITAL REVENUES84-000-42-00-4214DEVELOPMENT FEES9,8004,4007,3002,80059,9003,7506,37594,325 50,000 188.65%84-000-45-00-4500 INVESTMENT EARNINGS62505662605769417 100 417.14%84-000-48-00-4850 MISCELLANEOUS INCOME- 29- - - - - 29 -0.00%TOTAL REVENUES: LIBRARY CAPITAL9,8624,4797,3562,86259,9603,8076,44494,771 50,100 189.16%LIBRARY CAPITAL EXPENDITURES84-840-54-00-5460 E-BOOK SUBSCRIPTIONS- - - - - - - -3,500 0.00%84-840-56-00-5635COMPUTER EQUIPMENT & SOFTWARE- - - - - - - -15,000 0.00%84-840-56-00-5683 AUDIO BOOKS- 157233952403755871,687 3,500 48.20%2 % of Fiscal Year8% 17% 25% 33% 42% 50% 58%Year-to-Date FISCAL YEAR 2020 ACCOUNT NUMBER DESCRIPTIONMay-19June-19July-19August-19 September-19 October-19 November-19Totals BUDGET % of BudgetYORKVILLE PUBLIC LIBRARYFISCAL YEAR 2020 BUDGET REPORTFor the Month Ended November 30, 201984-840-56-00-5684 COMPACT DISCS & OTHER MUSIC- - 343100- - - 443 500 88.53%84-840-56-00-5685 DVD'S- 1271192463132223621,390 3,000 46.32%84-840-56-00-5686 BOOKS- 1,9583,7132,4272,3642,9416,47519,877 50,000 39.75%TOTAL FUND REVENUES9,8624,4797,3562,86259,9603,8076,44494,771 50,100 189.16%TOTAL FUND EXPENDITURES- 2,2414,4082,8672,9183,5387,42423,396 75,500 30.99%FUND SURPLUS (DEFICIT)9,8622,2382,948(5) 57,042269(980) 71,375 (25,400) 3 DATE: 12/03/2019 UNITED CITY OF YORKVILLE PAGE: 1TIME: 10:59:48 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 07PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________82-000-24-00-2480 (L) ESCROW - MEMORIALS & GIFTS_____________________________________________________________________________________________________________________________________________________01 05/01/2019 BEGINNING BALANCE 74,987.16 AP-190513B 05/06/2019 01 BOOKS BAKER & TAYLOR 104703 2034422390-B 58.24 05/06/2019 02 BOOKS BAKER & TAYLOR 104703 2034437996-B 60.16 05/06/2019 03 WASHER TOSS GAME, CRAFT ORIENTAL TRADING CO 104706 695971245-01 69.31 AP-190525MB 05/14/2019 25 AMAZON-SCREEN LIGHTING KIT, FIRST NATIONAL BANK 900073 052519-E.TOPPER-B 413.89 05/14/2019 26 JEWEL-COOKIE TRAY FOR PATRON FIRST NATIONAL BANK 900073 052519-E.TOPPER-B 42.96 GJ-190531LB 06/03/2019 06 May 2019 Deposits 487.00 CR-C190521 05/21/2019 06 KONICA MFP REIMB 006 0000000012 100.00 _________________________________ TOTAL PERIOD 01 ACTIVITY 644.56 587.0002 AP-190610B 06/04/2019 01 BOOKS BAKER & TAYLOR 104718 2034546750 20.69 06/04/2019 02 JULY 201, 2019 MAGIC AND ART DANIEL LAIB 104721 552 300.00 AP-190618M 06/18/2019 01 FABRICATE AND INSTALL A MAIN AURORA SIGN CO 104730 190511-1 12,497.00 AP-190625MB 06/20/2019 139 AMAZON-IPAD, ENVELOPES, FIRST NATIONAL BANK 900075 062519-E.TOPPER-B 686.29 06/20/2019 140 AMAZON-IPAD CASE FIRST NATIONAL BANK 900075 062519-E.TOPPER-B 14.99 06/20/2019 141 PANERA-3 GIFT CARDS FOR ADULT FIRST NATIONAL BANK 900075 062519-S.AUGUSTINE-B 30.00 06/20/2019 142 GRACE COFFEE-2 GIFT CARDS FOR FIRST NATIONAL BANK 900075 062519-S.AUGUSTINE-B 20.00 06/20/2019 143 AMAZON-MOVIE CLAPPER FIRST NATIONAL BANK 900075 062519-S.AUGUSTINE-B 9.54 06/20/2019 144 AMAZON-MOVIE PARTY PROPS FIRST NATIONAL BANK 900075 062519-S.AUGUSTINE-B 58.94 06/20/2019 145 TARGET-DVDS FIRST NATIONAL BANK 900075 062519-S.AUGUSTINE-B 38.00 06/20/2019 146 STARBUCKS- 3 GIFT CARDS FOR FIRST NATIONAL BANK 900075 062519-S.AUGUSTINE-B 30.00 06/20/2019 147 NCG-GIFT CARDS FOR ADULT FIRST NATIONAL BANK 900075 062519-S.AUGUSTINE-B 78.00 06/20/2019 148 AMAZON-RED CARPET ISLE RUNNER FIRST NATIONAL BANK 900075 062519-S.AUGUSTINE-B 49.99 06/20/2019 149 AMAZON-BEISTLE CUTOUTS FIRST NATIONAL BANK 900075 062519-S.AUGUSTINE-B 12.90 _________________________________ TOTAL PERIOD 02 ACTIVITY 13,846.34 0.0003 AP-072919VD 07/29/2019 03 BOOKS FOR FRIENDS :VOID 104738 THE READING WAREHOUS 194537 148.83 AP-190708 07/01/2019 01 BOOKS BAKER & TAYLOR 104731 2034568271 66.09 07/01/2019 02 BOOKS BAKER & TAYLOR 104731 2034591302 56.95 07/01/2019 03 BOOKS FOR FRIENDS SUMMER THE READING WAREHOUS 194537 148.83 AP-190725M 07/22/2019 166 BOEGERS LANDSCAPE-FOUNTAIN FIRST NATIONAL BANK 900077 072519-D.DEBORD 449.00 07/22/2019 167 GROUND EFFECTS-MEXICAN PEBBLES FIRST NATIONAL BANK 900077 072519-J.WEISS 8.05 07/22/2019 168 READING WAREHOUSE-BOOKS FIRST NATIONAL BANK 900077 072519-J.WEISS 148.83 07/22/2019 169 MENARDS-PLANTER, DIRT, PLANTS FIRST NATIONAL BANK 900077 072519-J.WEISS 161.79 07/22/2019 170 MENARDS-PLANTS FIRST NATIONAL BANK 900077 072519-J.WEISS 39.74 07/22/2019 171 TARGET-SUMMER READING PROGRAM FIRST NATIONAL BANK 900077 072519-J.WEISS 69.89 GJ-190731LB 08/02/2019 06 July 2019 Deposits 449.00 _________________________________ TOTAL PERIOD 03 ACTIVITY 1,149.17 597.8304 AP-190812 08/05/2019 01 2 BRICKS KING & SONS MONUMENT 104748 071119 60.00 GJ-190831LB 09/03/2019 07 August 2019 Deposits 265.00 _________________________________ TOTAL PERIOD 04 ACTIVITY 60.00 265.0005 AP-190909 09/04/2019 01 2019 ICE CREAM SOCIAL MUSICAL CHARLES E. STEWART 104766 091419 300.00 GJ-190930LB 10/01/2019 05 September 2019 Deposits 750.00 _________________________________ TOTAL PERIOD 05 ACTIVITY 300.00 750.0006 AP-191014 10/01/2019 01 MAIN MONUMENT SIGN AURORA SIGN CO 104774 190511-2 12,997.00 DATE: 12/03/2019 UNITED CITY OF YORKVILLE PAGE: 2TIME: 10:59:49 GENERAL LEDGER ACTIVITY REPORTID: GL440000.WOW FOR FISCAL YEAR 2020 ACTIVITY THROUGH FISCAL PERIOD 07PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________82-000-24-00-2480 (L) ESCROW - MEMORIALS & GIFTS_____________________________________________________________________________________________________________________________________________________06 AP-191014 10/01/2019 02 BOOKS BAKER & TAYLOR 104776 2034756989 151.18 10/01/2019 03 BOOKS BAKER & TAYLOR 104776 2034770138 9.77 10/01/2019 04 BOOKS BAKER & TAYLOR 104776 2034784292 27.27 AP-191025M 10/15/2019 207 WALMART-MOVIE SNACKS FIRST NATIONAL BANK 900080 102519-S.AUGUSTINE 10.44 GJ-191031LB 11/01/2019 06 Oct 2019 Deposits 1,598.12 _________________________________ TOTAL PERIOD 06 ACTIVITY 13,195.66 1,598.1207 AP-191118 11/13/2019 01 BOOKS BAKER & TAYLOR 104791 2034803424 690.22 11/13/2019 02 BOOKS BAKER & TAYLOR 104791 2034810164 25.18 11/13/2019 03 BOOKS BAKER & TAYLOR 104791 2034826890 41.85 11/13/2019 04 BOOKS BAKER & TAYLOR 104791 2034844604 62.88 11/13/2019 05 BOOKS BAKER & TAYLOR 104791 2034868770 22.11 11/13/2019 06 DINOSAUR CUTOUTS, INFLATABLE ORIENTAL TRADING CO 104803 698860024-01 53.64 AP-191125M 11/14/2019 208 MENARDS-TARP FIRST NATIONAL BANK 900081 112519-D.DEBORD 7.57 11/14/2019 209 AMAZON-BOOKS FIRST NATIONAL BANK 900081 112519-E.TOPPER 152.64 11/14/2019 210 BOOK PAGE-ANNUAL SUBSCRIPTION FIRST NATIONAL BANK 900081 112519-E.TOPPER 576.00 11/14/2019 211 AMAZON-PLASTIC COINS FIRST NATIONAL BANK 900081 112519-E.TOPPER 14.95 11/14/2019 212 NCG-GIFT CARD FIRST NATIONAL BANK 900081 112519-E.TOPPER 25.00 11/14/2019 213 JEWEL-REFRESHMENTS FOR CHILI FIRST NATIONAL BANK 900081 112519-J.WEISS 16.28 11/14/2019 214 PANERA-REFRESHMENTS FOR FIRST NATIONAL BANK 900081 112519-S.AUGUSTINE 14.99 11/14/2019 215 JEWEL-REFRESHMENTS FOR FIRST NATIONAL BANK 900081 112519-S.AUGUSTINE 22.76 11/14/2019 216 JEWEL-REFRESHMENTS FOR OCT FIRST NATIONAL BANK 900081 112519-S.AUGUSTINE 16.97 GJ-191130LB 12/02/2019 06 November 2019 Deposits 150.00 _________________________________ TOTAL PERIOD 07 ACTIVITY 1,743.04 150.00 TOTAL ACCOUNT ACTIVITY 30,938.77 3,947.95 ENDING BALANCE 47,996.34 GRAND TOTAL 0.00 47,996.34 TOTAL DIFFERENCE 0.00 47,996.34 November YTD % of FY 2020 Actual Actual Budget Budget YTD Actual % Change LIBRARY OPERATIONS FUND (82) Revenues Property Taxes 16,041$ 1,497,431$ 100.3% 1,492,248$ 1,457,087$ 2.77% Intergovernmental Personal Property Replacement Tax -$ 3,927$ 74.8% 5,250$ 2,715$ 44.65% State Grants - 21,151 105.8% 20,000 25,211 -16.10% Total Intergovernmental -$ 25,078$ 99.3% 25,250$ 27,926$ -10.20% Library Fines 231$ 4,985$ 58.6% 8,500$ 5,318$ -6.26% Charges for Services Library Subscription Cards 435$ 5,821$ 72.8% 8,000$ 5,666$ 2.74% Copy Fees 245 2,326 62.0% 3,750 2,590 -10.22% Program Fees - 58 0.0% - 1 5725.00% Total Charges for Services 680$ 8,205$ 69.8% 11,750$ 8,257$ -0.63% Investment Earnings 1,358$ 7,440$ 74.4% 10,000$ 4,573$ 62.70% Reimbursements/Miscellaneous/Transfers In Miscellaneous Reimbursements -$ -$ 0.0% -$ -$ 0.00% Rental Income 200 900 45.0% 2,000 925 -2.70% DVD Rental Income - - 0.0% - 1,133 -100.00% Miscellaneous Income - 2,431 121.5% 2,000 148 1542.32% Transfer In 911 15,991 64.0% 25,003 15,397 3.86% Total Miscellaneous & Transfers 1,111$ 19,322$ 66.6% 29,003$ 17,603$ 9.77% Total Revenues and Transfers 19,421$ 1,562,461$ 99.1% 1,576,751$ 1,520,764$ 2.74% Expenditures Library Operations 76,968$ 532,536$ 32.9%1,620,345$ 517,557$ 2.89% 50 Salaries 50,151 270,326 57.0% 474,394 261,194 3.50% 52 Benefits 15,670 101,664 57.9% 175,658 99,532 2.14% 54 Contractual Services 8,615 70,191 47.1% 149,080 55,074 27.45% 56 Supplies 2,531 9,349 38.6% 24,200 13,207 -29.21% 99 Debt Service - 81,006 10.2% 797,013 88,550 -8.52% Total Expenditures and Transfers 76,968$ 532,536$ 32.9% 1,620,345$ 517,557$ 2.89% Surplus(Deficit) (57,546)$ 1,029,925$ (43,594)$ 1,003,206$ *November represents 59% of fiscal year 2020 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ended November 30, 2019 * Fiscal Year 2019 For the Month Ended November 30, 2018 LIBRARY DIRECTOR REPORT—November 2019 Facilities Management- Chiller screens installed (11/4/19). Painters did repairs (11/5/19), RJ O’Neil did preventive maintenance and repair work on (11/14,11/21/,11/25,11/27) scheduled to do additional work on Boiler #2 and work on the Water Heater replacing anode rods. Parts have been ordered. Met with Sound Inc. to provide information to the representative to draft a proposal to upgrade our camera system. Public Relations- A patron was impressed with the service that was provided to them in obtaining a family obituary that he sent a donation to the Library. A complimentary letter was sent about Shelley Augustine and her dedication to the Creative Writers Group (To be circulated as part of Correspondence). Meetings-Attended the Physical Facilities Committee meeting (11/4/19). Attended the quarterly meeting of the Physical Facilities Manager’s Group (11/20/19) at the Huntley Public Library and discussed snow bars with the group. Staff – We interviewed 2 applicants for the Youth Services weekend positions. Still waiting for the background checks to come back from the City. Library Operations-We will be getting a mobile app for the Library next year as part of an agreement with Prairie Cat. There was a problem in the building (12/3/19) causing a strange odor so we evacuated the building and had the fire department check for toxic fumes. We were cleared. Could have been the oils burning off on the new burners. Served as our fire drill for the year. We are having some problems with teens after school in the Library. We will have the police start doing walk throughs. Grant/Projects/Programs- Working on the final report for the Literacy Grant and the Per Capita Grant. Friends- Staff is working with the Friends on the Mini-Golf Event. Programs, Activities Adult Programs Men’s Book Club 4 Friends Meeting 11 Lunch Bunch 5 Creative Writing 11 Book Folding (Garden Club) 32 Medicare Program 11 Threads and More 13 Movie Matinee 14 Dragon Ornament (2) 18 Library Programmers Mtg 11 Passive Programs Total 55 Includes the puzzles, chess board and art wall. TOTAL ADULT ATTENDANCE 130 Children Programs Drop-In Storytime (5) 48 Tots and Toddlers (2) 49 LEGO Duplo16 Lapsit 8 Panera (2) 56 Book Club (1-2 grades) 12 Book Club (3-5 grades) 15 Literacy Centers 24 Morning/afternoon Read 6 TAG (3) 19 Window Art 8 LEGO 23 Chess Club 22 Books for Bingo 27 Movie 7 Magic the Gathering 10 Evening Art 7 Read with Paws 1Museum Pass Program Brookfield Zoo 2 Air Museum of Aviation 1 LEGOLAND Discovery Center 1 Total 4 TOTAL CHILDREN’S ATTENDANCE 368 Passive programs included: Games, Magnet Shapes (dino), teen coloring, Teen Boggle Challenge, Find the hidden dinosaurs, thankful leaves, clothes pin dino, dino mask, dino color, dino egg craft, draw a dino, and dino info. Theme in YS this month is Dinovember. TOTAL PARTICIPATION FOR PASSIVE PROGRAMS 427 Computer Use Adult 296 Young Adult 42 Children 25 TOTAL COMPUTER USE 363 Database & E-book Use Ancestry database 381 Gale 6 Omni E-Book 667 E-Audio 432 (268 Users) E-Read IL 33 E-Book Audio 68 (39Users) Circulation Checkouts 14,012 New Patrons Added 74 New Items Added 484 Teen Volunteers: Mikayla Mika, Juleah Richardson, Katelyn Tugman, Bree Weiss, Lexi Mika, Joey Koenig, Leah Nieman, Ellianna Black, Leah English, Mikayla Moi, Mark Sanford, Naytona Faedtke and Lexi Roehr. Adult Volunteers: Nancy Aschauer, Sands McCormick Uridil, Fox Valley Therapy Dog Group and Brad Smith. Meeting Room 2 Rental, 17 Programs Proctored Test 1 Patron Count 4,979 YORKVILLE STATISTICS FOR FY20 PrairieCat Month All Transacti ons web renewals checkouts + renewals checkouts renewals all holds placed holds filled checkins Items lent to other libraries Items borrowe d from other libraries Items to Reciprocal Borrowers atYorkville Items added Patrons added e- commerc e MAY 14,800 6,868 5,767 1,101 395 1,663 5,873 775 1,329 313 436 59 418.35 JUNE 17,904 9,107 7,996 1,111 395 1,529 6,873 1,012 1,246 310 341 170 325.65 JUL 18,576 8,666 7,399 1,267 503 1,687 7,720 948 1,280 329 285 115 296.35 AUG 15,509 6,921 5,871 1,050 421 1,707 6,460 966 1,396 269 310 108 130.35 SEP 13,372 833 6,071 5,661 410 415 1,665 5,221 821 1,362 199 285 101 235 OCT 14,990 843 6,589 6,198 391 532 1,785 6,084 886 1,439 208 607 84 204.25 NOV 14,012 1069 5,975 5,632 343 491 1,676 5,870 779 1,345 265 484 74 DEC JAN FEB MAR APR DATABASE USEAGE FOR FY20 ANCESTRY GALE E-READ IL OMNI OCLC SEARCHES HITS SESSIONS SEARCHES E-BOOK E-AUDIO USERS E-BOOK E-AUDIO USERS VIDEO LENT BORROWED MAY 7 16 17 35 34 71 30 629 398 259 0 22 7 JUN 62 108 1 2 33 58 31 717 401 279 0 11 5 JUL 97 81 2 2 47 78 36 794 433 289 0 11 14 AUG 92 44 4 13 50 94 39 658 394 281 0 23 19 SEP 108 39 7 30 44 78 47 668 414 272 0 25 11 OCT 15 13 10 31 51 98 43 737 446 284 2 25 14 NOV 381 265 2 6 33 68 39 667 432 268 0 DEC JAN FEB MAR APR 17W715 Butterfield Rd. • Suite D • Oakbrook Terrace, IL 60181 •Phone: 847 459 1220 • Fax: 630 953 5949 November 27, 2019 Bid # 1909-07-C Page 1 of 2 Russell Walter Yorkville Public Library 902 Game Farm Rd Yorkville, IL 60560 Re: Library Wireless Network 1.0 Cabling Specifications 1.1 Install 6 category 6 non-plenum data cables for wireless access points; terminate on customer patch panel 2.0 Equipment Specifications 2.1 Option to install up to 12 Aruba IAP 207 WAPs at $223 each. 3.0 Configuration 3.1 All cables will be tested for continuity, wire mapping and primary electrical performance. 3.2 All faceplates and patch panels will be machine-print labeled and correspond to customer-approved numbering system. 3.3 Allowance for up to 12 engineering hours for wireless network design and implementation 3.4 Provide coverage heat maps for installed WAPs 3.5 Provide as-built prints identifying all WAPs as installed 4.0 Budgetary Pricing 4.1 Cabling Material Cost $ 417.10 Labor Cost $ 2,640.00 Total $ 3,057.10 4.2 WAPs and Controller 4.2.1 Aruba Equipment Cost $ 2,676.00 Professional Services $ 1,680.00 Total $ 4,356.00 17W715 Butterfield Rd. • Suite D • Oakbrook Terrace, IL 60181 •Phone: 847 459 1220 • Fax: 630 953 5949 November 27, 2019 Bid # 1909-07-C Page 2 of 2 Any alterations or deviations from the above specifications may involve extra costs with the additional cost being specifically stated in writing and completed only upon approval of the customer. Actual costs may vary when unexpected conditions are encountered. A revised estimate or quote may be required. This project will proceed only upon consent of the customer under those conditions. Permits and fees will be at an additional cost if required. Clauses appending certificates of insurance modifying terms of existing policies beyond simple additional insured may involve legal and business review at an additional charge. All agreements are contingent upon strikes, accidents or delays beyond our control. This proposal is valid for thirty days. If not directed to proceed within thirty days of the proposal date, prices may change. Acceptance of this proposal shall be in the form of a signed acceptance form and a check for 50% of the total cost with balance due net 30 from completion; or on smaller installations where the down payment is waived, final payment is due on completion. If awarded this proposal, adequate notification must be provided to insure the availability of resources and material. Best regards, Jack Bush S & G Communication Inc. Acceptance Form This proposal is hereby accepted by customer and is granted to S & G Communications Inc. Signature: _________________________ Date: _________________ BID EVALUATION MATRIXApplicant Name:BEN:FCC Form 470#:FY: Allowable Contract Date (ACD):BIDs:Notes:Internet AccessInternal ConnectionsBasic MaintenanceManaged Internal BroadbandOtherService Provider / BidderDate Bid ReceivedANNUAL Cost of Services ($)Price Rating Attended Pre-Bid Conference Experience with EntityVendor's Ability w/E-RateLocal Presence Total Points21-40 20 20 10 10 1001. Electronaca Q109878/27/19 8,743.00$ 21 0 0 10 10 412. Electronaca Q110498/27/19 8,743.00$ 21 0 0 10 10 413. Granite (no equipment) / labor only 8/29/19 4,884.98$ 21 0 0 10 10 414. DSN - quoted Rukus w/cabling 9/21/19 5,800.00$ 0 0 0 0 0 05. S&G - cabling & Ubiquiti 9/16/19 6,417.00$ 0 0 0 0 0 06. S&G - cabling & Aruba9/19/19 9,660.00$ 0 0 0 0 0 07. S&G - cabling & equipment corrected quote 11/27/19 7,413.10$ 40 20 10 0 0 70√8. 09.010.0135742Approved By - Name:TitleDate of ReviewPrice Rating: Based on a scale of 21-40 points All Other Ratings: rate from 0 = Poorest; to total points available = BestYorkville Public Library 5. Price Rating is based on a scale of 21-40 points. Instructions:1. Applicants are not required to change vendors or choose the lowest price bid; however price must be the most heavily weighted criteria. 2. Rules require applicants to wait at least 28 days after the FCC Form 470 is posted before executing any contracts for services, or selecting a service provider for tariff or month-to-month services. 3. Complete a separate Bid Evaluation Worksheet for each Type of Service being bid.4. The scoring criteria provide broad guidance for assigning points from a range of points based on the stated criteria.Refer to RFP - Controller, APs, Cabling20202000001356. All other Criteria rated objectively from high to low bid for total points available.Briefly Describe Service(s)Type of Service (Double Click)Pre-Bid Walk Through 8/26/19 - ACD 9/22/194 DID NOT ATTEND PRE-BID CONFERENCE Electronaca - did not attended pre-bid walk through; Q10987 Aruba, did not include controller Electronaca - did not attended pre-bid walk through; Q11049 Ubiquiti, did not include controller Granite - did not attended pre-bid walk through; installation and inside wiring costs ONLY, no equipment ATTENDED PRE-BID CONFERENCE DSN - 9/21/19, quoted Rukus w/install - NOT COMPATABLE WITH CURRENT EQUIPMENT S & G - 9/16/19, quoted Ubiquit & Aruba w/install, received corrected quote 11/27/19 (Labor cost $3,057). Date of Review - the review of bids must be conducted after the Allowable Contract Date (ACD)Total Points AvailableLnWinning Bid (√)Program Rules Require That All E-Rate Correspondence, Worksheets, And Documentation Be Retained for 10 YearsE-Rate Funding Services, LLC | 718 St. Nicholas Dr., O'Fallon, IL 62269|973-714-3724 |Fax 866-735-8070 BID EVALUATION MATRIXApplicant Name:BEN:FCC Form 470#:FY: Allowable Contract Date (ACD):BIDs:Notes:Internet AccessInternal ConnectionsBasic MaintenanceManaged Internal BroadbandOtherService Provider / Bidder USED 100MBPS FOR COMPARISONDate Bid ReceivedANNUAL Cost of Services ($)Price Rating Meeting Overall NeedsExperience with EntityVendor's Ability w/E-RateLocal Presence Total Points21-40 20 20 10 10 1001. Comcast8/5/19 7,260.00$ 40 20 20 10 10 100n/a2. MetroNet8/28/19 7,800.00$ 36 20 0 10 5 71n/a3. Cytranet8/2/19 8,508.00$ 32 10 0 10 5 57n/a4. AT&T8/22/19 9,216.00$ 28 20 0 10 10 68n/a5. EM3 Networks8/12/19 7,800.00$ 24 20 0 10 5 59n/a6. Granite8/29/19 12,900.00$ 21 20 0 10 10 61n/a7.8.BOARD decision - fiber not cost effective stay with coax9.10.Yorkville Public Library 20000013520201357426. All other Criteria rated objectively from high to low bid for total points available.8/29/20196Instructions:1. Applicants are not required to change vendors or choose the lowest price bid; however price must be the most heavily weighted criteria. 2. Rules require applicants to wait at least 28 days after the FCC Form 470 is posted before executing any contracts for services, or selecting a service provider for tariff or month-to-month services. 3. Complete a separate Bid Evaluation Worksheet for each Type of Service being bid.4. The scoring criteria provide broad guidance for assigning points from a range of points based on the stated criteria.5. Price Rating is based on a scale of 21-40 points. Ln Winning Bid (√) Briefly Describe Service(s)Dedicated Symmetrical Internet – 100; 250; 500 MbpsType of Service (Double Click)Total Points AvailablePrice Rating: Based on a scale of 21-40 points All Other Ratings: rate from 0 = Poorest; to total points available = BestCytranet - Terms: did not indicated, submitted a generic bid, did not specifically address the requested services; did not indiciate applicant name. Comcast - Terms: 36 mon. EM3 Networks - Terms: 36 mon. AT&T - Terms. 24 or 36 mon. MetroNet - Terms: used 36 mon for comparison Granite - Term: 36-month ------------------------ BOARD decision - fiber not cost effective will stay with coaxDate of Review - the review of bids must be conducted after the Allowable Contract Date (ACD)Approved By - Name:TitleDate of ReviewProgram Rules Require That All E-Rate Correspondence, Worksheets, And Documentation Be Retained for 10 YearsE-Rate Funding Services, LLC | 718 St. Nicholas Dr., O'Fallon, IL 62269|973-714-3724 |Fax 866-735-8070 BID EVALUATION MATRIXBidder Date 100 250 500 NRCComcast 8/5/19 605 1,230 1,580 - Quote 300 Mbps not 250MetroNet 8/28/19 650 850 1,100 - Cytranet 8/2/19 709 1,065 1,368 550 AT&T w/mangd router 8/22/19 768 1,014 1,406 - Granite 8/29/19 1,075 1,510 1,735Program Rules Require That All E-Rate Correspondence, Worksheets, And Documentation Be Retained for 10 YearsE-Rate Funding Services, LLC | 718 St. Nicholas Dr., O'Fallon, IL 62269|973-714-3724 |Fax 866-735-8070 BID EVALUATION MATRIXApplicant Name:BEN:FCC Form 470#:FY: Allowable Contract Date (ACD):BIDs:Notes:Internet AccessInternal ConnectionsBasic MaintenanceManaged Internal BroadbandOtherService Provider / Bidder Comparison 500 MbpsDate Bid ReceivedANNUAL Cost of Services ($)Price Rating Meeting Overall NeedsExperience with EntityVendor's Ability w/E-RateLocal Presence Total Points21-40 20 20 10 10 1001. Comcast8/5/19 5,004.00$ 40 20 20 10 10 100√2. Granite 8/29/19 5,100.00$ 30 20 0 10 10 703. S&G9/16/19 9,180.00$ 21 20 0 10 10 614.05.06.07.08.09.010.0Price Rating: Based on a scale of 21-40 points All Other Ratings: rate from 0 = Poorest; to total points available = Best6. All other Criteria rated objectively from high to low bid for total points available.Type of Service (Double Click)TitleDate of ReviewYorkville Public Library 1357422000001358/29/201932020Instructions:1. Applicants are not required to change vendors or choose the lowest price bid; however price must be the most heavily weighted criteria. 2. Rules require applicants to wait at least 28 days after the FCC Form 470 is posted before executing any contracts for services, or selecting a service provider for tariff or month-to-month services. 3. Complete a separate Bid Evaluation Worksheet for each Type of Service being bid.4. The scoring criteria provide broad guidance for assigning points from a range of points based on the stated criteria.5. Price Rating is based on a scale of 21-40 points. Total Points AvailableComcast - Term: 36 mon., includes equipment fee Granite - Term: 36 mon., all inclusive S&G, Term: none, using Comcast last mileDate of Review - the review of bids must be conducted after the Allowable Contract Date (ACD)Briefly Describe Service(s)Internet Coax - 100/12; 300/25; 500/35; and 1Gbps/35 LnWinning Bid (√)Approved By - Name:Program Rules Require That All E-Rate Correspondence, Worksheets, And Documentation Be Retained for 10 YearsE-Rate Funding Services, LLC | 718 St. Nicholas Dr., O'Fallon, IL 62269|973-714-3724 |Fax 866-735-8070 BID EVALUATION MATRIXBidder Date 150 300 500 1000 NRCComcast 8/5/19 267 367 417 517 0Granite 8/29/19 170 230 425 585 WaivedS&G 9/16/19 405 765 925Program Rules Require That All E-Rate Correspondence, Worksheets, And Documentation Be Retained for 10 YearsE-Rate Funding Services, LLC | 718 St. Nicholas Dr., O'Fallon, IL 62269|973-714-3724 |Fax 866-735-8070