The URL can be used to link to this page

Library Board Packet 2021 04-12-21 Agenda Yorkville Public Library Board of Trustees April 12, 2021 at 7:00 P.M. Michelle Pfister Meeting Room 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 9. Report of the Library Director 10. City Council Liaison 11. Standing Committees: Policy Personnel Physical Facilities Finance Community Relations 12. Unfinished Business: Library/City Partnership Keyless entry— Umbrella Tech. 13. New Business: Internet provider contract- Metronet Phone system proposal —TCG Solutions Camera proposal —Griffin Systems FY22 Budget approval Resolution to adopt Non-Resident Card payment by Tax Bill Method for FY22 Reminder: File Statement of Economic Interest with the Kendall County Clerk's office 14. Executive Session (if needed) OMA 5 ILCS 120/2(c)(1) "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." 15. Adjournment DRAFT Yorkville Public Library Board of Trustees Monday, March 8, 2021 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: Wamecca Rodriguez-yes, Jason Hedman-yes, Theron Garcia-yes, Ryan Forristall-yes, Darren Crawford-yes, Susan Chacon-yes, Julie Brendich-yes, Russ Walter-yes. Others Present: Shelley Augustine and Dixie DeBord-Interim Co-Directors, Judy Somerlot-Friends of the Library, Daniel Transier-City Council Liaison, Mayor John Purcell, Bart Olson-City Administrator, Tim Evans- Director Parks & Recreation, Thomas Carnevale-Umbrella Technologies Recognition of Visitors: President Crawford recognized staff and guests. Amendments to the Agenda: President Crawford asked to move the City/Library Partnership discussion to immediately following the presentation by Umbrella Technologies. Umbrella Technologies Proposals —Thomas Carnevale Tom Carnevale said he has been installing security systems over 20 years and his company is located in Aurora. He has extensive experience working with libraries, federal buildings, and installing video surveillance, etc. He said the goal is to update the system at the library. Mr. Carnevale said there would be no recurring annual fees for the software and that the system is scalable allowing cameras to be added. He described the equipment that would be needed and said video can be viewed from smartphones, web browser or laptop. Mr. Hedman questioned the bankruptcy of the company that makes some of the equipment which he felt was outdated. Mr. Carnevale said the equipment is in stock at his company and they cover the warranty. Trustee Hedman requested the cost of a more up-to-date system. Mr. Carnevale said it would be about $35,000 for a system including 32 cameras, infrastructure, installation, cable, etc. which could be done in a phased approach. Door Entry ystem: Mr. Carnevale said the key card system is scalable, works with any card reader, enables cloud management, allows existing FOB'S to be used and is generally manageable from mobile apps. It also has touchless capabilities and staff can eliminate or add employee access easily. If the internet goes down, there is still full functionality. Page 1 of 4 City/Library Partnership Discussion Overview: At a previous Board meeting, there was discussion of an opportunity to partner with the Parks and Rec Department. President Crawford and Trustee Brendich recently met with Mayor Purcell, Bart Olson and Tim Evans for a discovery process to determine space needs for the Parks & Rec pre- school and the library need for a Facilities Manager. They discussed holding pre-school programming in the library and the library sharing a facilities person with the city. Mayor Purcell said it made sense to hold a preschool at the library, which in turn exposes kids to the library. The preschool is currently held at the old Post Office on the river. He also talked about the recent purchase of the new city hall. Discussion: Ms. Brendich said it will first be decided if the partnership will work, space needs will be determined on the first or second floor and the committee will look at accommodations for book storage prior to the used book sale. Mr. Evans suggested the possibility of bi-fold doors in the meeting room to separate space for a pre-school and discussion was held regarding the use of the Board room and Director's office for either library use or pre-school use. Using the upstairs would allow for additional safety for the pre-school and would maintain the current space downstairs. Ms. Somerlot noted that the Board desires extensive programming and she was concerned that altering the meeting room would minimize program opportunities. She also expressed concern for used book storage and a room for the book sale. The book sale raises thousands of dollars for funding programs. Board members and city staff agreed the first step is to determine interest, then input is needed from the Parks and Rec staff and library staff. Ms. Brendich asked the Co-Directors for their input and Ms. Chacon said a Friends of the Library representative should be invited to meetings. A decision about moving forward with pre-school at the library needs to be made by June 1. It was noted that several programs are held in the summer and any construction would interrupt programming. President Crawford said that part of the discussion is the Facilities Manager for which the Library would pay half the costs. Some Board members were concerned about relinquishing space in addition to absorbing the cost of this additional employee. Summary: Another meeting will be held with participants from Parks, Library staff, Trustees and Friends prior to the next Board meeting so that options can be presented to the Board. Mr. Evans volunteered to write a proposal before the next Board meeting and he also suggested a possible partnership with Beecher and the High School. Ms. Somerlot said a designated time period should be included in the proposal in the event the arrangement is not compatible. Mr. Olson added that an Inter- Governmental Agreement could be drafted as well. Minutes: February 8, 2021 President Crawford moved and Ms. Garcia seconded to approve the minutes as presented. Roll call: Hedman-yes, Garcia-yes, Forristall-yes, Crawford-yes, Chacon-yes, Brendich-yes, Walter-yes, Rodriguez-yes. Carried 8-0. Correspondence: None Public Comment: None Staff Comment: None Page 2 of 4 Report of the Treasurer: Financial Statement Treasurer Hedman said the budget is at 85% of the FY. He also highlighted some of the invoices and said the budget is on track. Payment of Bills President Crawford made a motion to pay the bills as follows and Trustee Garcia seconded: $15,965.04 Accounts Payable $34,166.70 Payroll $50,131.74 TOTAL Roll call: Garcia-yes, Forristall-yes, Crawford-yes, Chacon-yes, Brendich-yes, Walter-yes, Rodriguez- yes, Hedman-yes. Carried 8-0. Report of the Library Director: Interim Co-Directors Ms.Augustine and Ms. DeBord presented the report and noted some mechanical issues in the building. They also reported the welcome letters received a positive response. As a result of the reading program, a total of$300 was donated to the Food Pantry which included a$100 donation from the Friends group and an anonymous donor doubled the initial amount collected. More library cards were issued for the month than for any other library with PrairieCat. A Read and Return display was prepared by Ms. Iwanski-Goist. In preparation for the switch to LED bulbs, a light bulb count will be presented at the April meeting. Most of the library staff has received the Covid vaccines with assistance from Police Chief Jensen. The staff continues to work with Weblinx on the website update, the per capita grant has been completed and the library has completed a re-certification through RAILS. City Council Liaison: No report. Standing Committees: None Unfinished Business: Keyless Entry Ms. DeBord said she received one return call who gave a favorable reference for the system installed by Umbrella Technologies. A motion was made by Mr. Hedman to approve the keyless entry system proposed by Umbrella Technologies, pending approval of the product reference check, the proposal being in the amount of$5,900. Ms. Garcia seconded. Roll call: Forristall-yes, Crawford-yes, Chacon-yes, Brendich-yes, Walter-yes, Rodriguez-yes, Hedman-yes, Garcia-yes. Carried 8-0. A motion was made by Mr. Walter to approve the access controlled cloud hosting service for $480 per quarter since it is not included in the proposal. Ms. Garcia seconded. Roll call: Crawford-yes, Chacon-yes, Brendich-yes, Walter-yes, Rodriguez-yes, Hedman-yes, Garcia-yes, Forristall-yes. Carried 8-0. The Sound Inc. contract will need to be canceled since it expires at the end of April and 45 days notice are required. Ms. Garcia moved and Mr. Walter seconded the motion to cancel the Sound Inc. contract for video, keyless entry and burglar alarm. Roll call: Crawford-yes, Chacon-yes, Brendich-yes, Walter-yes, Rodriguez-yes, Hedman-yes, Garcia-yes, Forristall-yes. Page 3 of 4 Ms. Rodriguez said there should be a camera at the meeting room door and it should be installed when the rest of the work is done. Mr. Hedman expressed reservations with the outdated equipment Umbrella Technologies was proposing. He said more options should be explored. The Board will also ask for a quote for a new NVR and the cost per camera. A camera that pans the room was also suggested. HVAC System Control Mr. Walter suggested the Board approve this item. There is $20,000 available now or it could be delayed until next budget year. However, Mr. Hedman said the cost was too close to the budget and he recommended delaying it until next budget year in favor of purchasing cameras and access equipment. The matter was tabled. Mr. Hedman noted that a budget meeting is needed and it was scheduled for March 15 at 7pm. New Business: LibraryAware Marketing Resource Ms.Augustine requested Board approval to purchase a yearly subscription software system which is a marketing resource for staff use. It would allow for composing custom newsletters, patrons can sign up for personalized newsletters, assists with materials for special programs and many other features. The Friends group has volunteered to pay for half($600) of this purchase. Ms. Garcia made a motion to purchase the LibraryAware program at $1,267 per year and Ms. Chacon seconded. Roll call: Chacon- yes, Brendich-yes, Walter-yes, Rodriguez-yes, Hedman-yes, Garcia-yes, Forristall-yes, Crawford-yes. Carried 8-0. Executive Session: None Additional Business: None Adiournment• There was no further business and the meeting adjourned at 9:1 1pm. Minutes respectfully submitted by Marlys Young, Minute Taker Page 4 of 4 DRAFT Yorkville Public Library Personnel Committee Meeting Monday, March 15, 2021, 6:00pm Yorkville Public Library 902 Game Farm Road —Michelle Pfister Meeting Room The Personnel Committee meeting was called to order at 6:OOpm by Chairwoman Theron Garcia. Roll Call of Committee Members: Theron Garcia-present, Wamecca Rodriguez-present, Julie Brendich-present, Russ Walter-present Others Present: Library Board President Darren Crawford Recognition of Visitors: No visitors Public Comment: None New Business: Review of Candidates Submitted for Director position Chairwoman Garcia cited the statute, #SILCS 120/2, under which the Personnel Committee would meet and enter into Executive Session. She moved to go into Executive Session and Mr. Walter seconded. Roll call: Rodriguez-yes, Brendich-yes, Walter-yes, Garcia-yes. The reason is as follows: 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. Executive Session: The committee entered into Executive Session at approximately 6:O1pm. It concluded at approximately 6:49pm on a motion Ms. Garcia and second by Mr. Walter. The committee decided to meet again tentatively on March 29"' and March 31St for the purpose of interviewing potential Library Director candidates. Adiournment• There was no further business and the meeting was adjourned at approximately 6:58pm Minutes respectfully submitted by Marlys Young, Minute Taker DRAFT Yorkville Public Library Michele Pfister Meeting Room Finance Committee Meeting Monday, March 15, 2021 - 7:00pm 902 Game Farm Road The meeting was called to order at 7:01pm by Committee Chairman Jason Hedman and roll was called. Roll Call: Committee members: Susan Chacon-yes, Darren Crawford-yes, Ryan Forristall-yes, Jason Hedman-yes Others Present: Trustee Russ Walter, City Finance Director Rob Fredrickson Recognition of Visitors: Chairman Hedman recognized Mr. Walter and Mr. Fredrickson Public Comment: None New Business: Review of Library Budget for FY 2022 Revenue Side: The purpose of the meeting was to review the FY 2022 budget. Mr. Hedman asked Mr. Fredrickson to summarize the budget changes made along with assumptions. Mr. Fredrickson said the largest revenue source for the library is the property tax and he estimated $758,000 with 3% increases. He commented the debt service will be finished in FY 2026. The state grant projection is $21,000. Expenditure Side: Salaries are the largest expense and $75,000 is budgeted for a new Library Director. An increase in part-time salaries is anticipated, though part-time expenses are under-budget at this time. The health insurance budget amount increased due to an employee opting in and Mr. Fredrickson budgeted for the Director as well. The rates for group health decreased about 4%. He said Fund 84 capital account, development fees have doubled due to more homes being built and Fund 82 has a surplus of$16,000 for 2021. For FY 2022 he predicted a deficit of$50,000 which he said is typical, though the library usually fares better than the projections. Overall he said there should be a projected Fund Balance of$600,000 at the end of 2021. He said that he budgeted conservatively and there would be $150,000 for building related expenses if the Board desires. Committee discussion: 1. Committee would like staff to request approval for book purchases which exceed budget. 2. Look at sharing cost of Facilities Manager, added $20,000 part-time position to budget. Mr. Fredrickson was asked to consult with Directors and complete analysis of part-time hours. Part time hours were less this year due to library covid-related closures. 3. BAS (Building Automated System)project should be put on capital side. Separate line item will be added to earmark $20,000 for this system. Page 1 of 2 4. Capital improvement projects desired for this year include access control and camera system. Invoice must be dated at least by April 30th and new hardware/software in place to have this expense included in 2021 budget. 5. Discussed parking lot striping status, Mr. Fredrickson will check with other city employees. 6. Fine and subscription budget amounts will remain as is in budget, amounts were lower this year due to covid/library closure. 7. Conferences & Lodging were retained in budget for new Director. Mr. Fredrickson will pro- rate the Director salary starting with June. 8. Outside Repair &Maintenance: it was suggested the gutter system should be evaluated due to ongoing leaks above door and ice problems in winter. Outdoor and indoor LED light bulb costs need to be captured in this category. 9. Discussed if Custodial Supplies should be bumped up from $7,000. 10. Treasurer Surety Bond had increased this year to $7,500, however, Mr. Fredrickson said it could be absorbed in the budget under Professional Services. Summary: Mr. Fredrickson summarized the steps he will take to finalize the budget and then provide an update to Mr. Hedman and Mr. Crawford. The budget will need to be adopted at the April Board meeting. Adiournment: There was no further business and the meeting adjourned at 7:31pm. Minutes respectfully submitted by Marlys Young, Minute Taker DRAFT Yorkville Public Library Personnel Committee Meeting Monday, March 29, 2021, 6:00pm Yorkville Public Library 902 Game Farm Road—Michelle Pfister Meeting Room The Personnel Committee meeting was called to order at 6:OOpm by Chairwoman Theron Garcia. Roll Call of Committee Members: Theron Garcia-present, Wamecca Rodriguez-present, Russ Walter-present, Julie Brendich-present Others Present: Library Board President Darren Crawford Recotinition of Visitors: Ms. Garcia recognized Mr. Crawford Public Comment: None New Business: Candidate Review/Interviews for Library Director Position Chairwoman Garcia moved to enter Executive Session and she stated the reason as follows: 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. Mr. Crawford seconded the motion. Roll call: Rodriguez-yes, Walter-yes, Brendich-yes, Garcia-yes. Carried 4-0. Executive Session: The committee entered into Executive Session at approximately 6:02pm. It concluded at approximately 7:24pm on a motion Ms. Garcia and second by Ms. Rodriguez. The committee will meet again March 31 to interview a second Library Director candidate. Adiournment• There was no further business and the meeting was adjourned at approximately 7:24pm Minutes respectfully submitted by Marlys Young, Minute Taker DRAFT Yorkville Public Library Personnel Committee Meeting Monday, March 31, 2021, 6:00pm Yorkville Public Library 902 Game Farm Road—Michelle Pfister Meeting Room The Personnel Committee meeting was called to order at 6:OOpm by Chairwoman Theron Garcia. Roll Call of Committee Members: Wamecca Rodriguez-present, Russ Walter-present, Julie Brendich-present, Theron Garcia-present Others Present: None Recognition of Visitors: No visitors Public Comment: None New Business: Candidate Review/Interviews for Library Director Position Chairwoman Garcia moved to enter into Executive Session and read the reason as follows: 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. Ms. Rodriguez seconded the motion. Roll call: Rodriguez-yes, Walter-yes, Brendich-yes, Garcia-yes. Carried 4-0. Executive Session: The committee entered into Executive Session at approximately 6:01pm. It concluded at approximately 7:06pm on a motion Ms. Garcia and second by Mr. Walter. No further action taken. Adiournment: There was no further business and the meeting was adjourned immediately at 7:06pm. Minutes respectfully submitted by Marlys Young, Minute Taker DRAFT Yorkville Public Library Personnel Committee Meeting Monday, April 5, 2021, 6:00pm Yorkville Public Library 902 Game Farm Road—Michelle Pfister Meeting Room The Personnel Committee meeting was called to order at 6:OOpm by Chairwoman Theron Garcia. Roll Call of Committee Members: Theron Garcia-present, Wamecca Rodriguez-present, Russ Walter-present Absent: Julie Brendich Others Present: Library Board President Darren Crawford, Library Staff. Dixie DeBord, Sharyl Iwanski-Goist, Jennette Weiss Recognition of Visitors: Ms. Garcia recognized guests. Public Comment: None New Business: Candidate Review/Interviews for Library Director Position Chairwoman Garcia moved to enter Executive Session and she stated the reason as follows: 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. Mr. Walter seconded the motion. Roll call: Garcia-yes, Rodriguez-yes, Walter-yes. Carried 3-0. Executive Session: The committee entered into Executive Session at approximately 6:02pm. It concluded at approximately 7:32pm on a motion by Ms. Garcia and second by Mr. Walter. No further action was taken. Adjournment: There was no further business and the meeting was adjourned immediately at 7:32pm. Minutes respectfully submitted by Marlys Young, Minute Taker DATE: 03/23/21 UNITED CITY OF YORKVILLE TIME: 08:01:00 MANUAL CHECK REGISTER ID: AP225000.WOW CHECK # VENDOR # INVOICE ITEM CHECK INVOICE # DATE # DESCRIPTION DATE ACCOUNT # ITEM AMT -------- ----------------------------------------------------------- 900100 FNBO FIRST NATIONAL BANK OMAHA 03/25/21 032521-A.SIMMONS 02/28/21 04 ADS-FEB-APR MONITORING 23-216-54-00-5446 223.83 05 CHARGES FOR 102 E VAN EMMON ** COMMENT ** 06 ADS-FEB-APR MONITORING 23-216-54-00-5446 796.77 07 CHARGES FOR 651 PRIAIRE POINTE ** COMMENT ** 08 ADS-ANNUAL MAINTENANCE CHARGE 82-820-54-00-5462 1,129.68 09 FOR 902 GAME FARM RD ** COMMENT ** 10 ADS-2/4/21 SERVICE CALL AT 23-216-54-00-5446 258.75 11 651 PRAIRIE POINTE ** COMMENT ** 12 ADS-2/8/21 INSTALLATION OF 23-216-54-00-5446 318.20 13 NEW SMOKE DETECTOR AND SMOKE ** COMMENT ** 14 HEAD IN ELEVATOR ROOM AT 651 ** COMMENT ** 15 PRAIRIE POINT ** COMMENT ** 16 VERIZON-JAN 2021 IN CAR UNITS 01-210-54-00-5440 792.22 17 VERIZON-JAN 2021 CELL PHONES 01-220-54-00-5440 169.72 18 VERIZON-JAN 2021 CELL PHONES 01-110-54-00-5440 169.72 19 VERIZON-JAN 2021 CELL PHONES 01-210-54-00-5440 854.99 20 VERIZON-JAN 2021 CELL PHONES 79-790-54-00-5440 36.01 21 VERIZON-JAN 2021 CELL PHONES 79-795-54-00-5440 182.46 22 VERIZON-JAN 2021 CELL PHONES 51-510-54-00-5440 261.82 23 VERIZON-JAN 2021 CELL PHONES 52-520-54-00-5440 36.01 24 ADS-2/1/21 SERVICE CALL TO 82-820-54-00-5462 342.74 25 REPLACE BATTERIES AT 902 GAME ** COMMENT ** 26 FARM RD ** COMMENT ** 27 ADS-ANNUAL MAINTENANCE CHARGE 82-820-54-00-5462 314.28 INVOICE TOTAL: 5,887.20 * 032521-B.OLSON 02/28/21 01 ZOOM-MONTHLY ACCESS/USAGE FEE 01-110-54-00-5462 273.18 INVOICE TOTAL: 1 273.18 * 032521-B.PFIZENMAIER 02/28/21 01 AMERICAN TIRE#4720-OIL CHANGE 01-210-54-00-5495 67.59 02 AMERICAN TIRE#4720-SEAT 01-210-54-00-5495 886.21 03 ADJUSTER REPLACED, TIRES ** COMMENT ** 04 MOUNTED AND BALANCED ** COMMENT ** 05 TARGET-VIZIO TV 01-210-56-00-5620 299.99 06 STREICHERS#I1476729-MAG HOLDER 01-210-56-00-5600 61.60 07 STREICHERS#II1480249-BADGE 01-210-56-00-5600 116.00 O8 STREICHERS#I1479740-VESTS 01-210-56-00-5690 1,665.00 09 STREICHERS#I1476263-CITATION 01-210-56-00-5600 129.16 10 HOLDERS, BATON HOLDERS, ** COMMENT ** 11 IRRITANT HOLDERS ** COMMENT ** 12 NOTORIOUS AUTO 01-210-54-00-5495 230.00 13 GLASS-WINDSHIELD REPLACED ** COMMENT ** 14 STREICHERS#I1476299-FLASHLIGHT 01-210-56-00-5600 817.16 15 , HANDCUFFS, CASES, BATON, CLI ** COMMENT ** 16 O`HERRON#2084076-IN-NAMEPLATE, 01-210-56-00-5600 27.99 Page 1 of 11 DATE: 03/23/21 UNITED CITY OF YORKVILLE TIME: 08:01:00 MANUAL CHECK REGISTER ID: AP225000.WOW CHECK # VENDOR # INVOICE ITEM CHECK INVOICE # DATE # DESCRIPTION DATE ACCOUNT # ITEM AMT ------------------------------------------------------------------- 900100 FNBO FIRST NATIONAL BANK OMAHA 03/25/21 032521-D.DEBORD 02/28/21 01 FARONICS-DEEP FREEZE ENT 82-820-54-00-5462 707.96 02 AMAZON-BATTERY BACKUP SURGE PR 82-820-56-00-5610 130.00 03 AMAZON-PAPER TOWELS 82-820-56-00-5621 39.92 04 FOX VALLEY FIRE & SAFETY-FIRE 82-820-54-00-5462 860.00 05 AMAZON-PRIME MEMBERSHIP 82-820-54-00-5460 12.99 06 MENDARDS-LATEX GLOVES,FUNNEL 82-820-56-00-5621 86.04 07 SET, SPLASH DE-BUG, WINDEX, ** COMMENT ** 08 PINESOL ** COMMENT ** INVOICE TOTAL: 1,836.91 032521-E.DHUSE 02/28/21 01 NAPA#276225-BATTERY 01-410-56-00-5628 125.00 02 NAPA#276227-COOLANT 01-410-56-00-5628 16.88 03 NAPA#276287-TRANS FLUID 01-410-56-00-5628 18.76 04 NAPA#276609-BONNET 52-520-56-00-5628 7.99 05 NAPA#276627-RUBBING COMPOUND 01-410-56-00-5628 13.99 06 NAPA#276810-WIPER BLADES 01-410-56-00-5628 64.02 07 NAPA#279092-WIPER BLADES 01-410-56-00-5628 14.40 08 NAPA#277154-LOCK DE-ICER 51-510-56-00-5620 3.29 09 NAPA#277103-POWER STEERING 01-410-56-00-5628 101.76 10 FLUID, TRANS FLUID ** COMMENT ** 11 NAPA#277350-GREASE. OIL 01-410-56-00-5628 22.45 12 AMAZON-OFFICE CHAIRS 01-410-56-00-5620 101.83 13 AMAZON-OFFICE CHAIRS 51-510-56-00-5620 101.82 14 AMAZON-OFFICE CHAIRS 52-520-56-00-5620 101.82 15 NAPA#277580-BOXED CAPSULES 01-410-56-00-5628 25.48 16 NAPA#277556-WIPER BLADES 01-410-56-00-5628 32.80 17 NAPA#277680-WINDSHIELD FLUID 01-410-56-00-5628 80.22 18 NAPA#277884-BATTERY DEPOSIT 01-410-56-00-5628 -27.50 19 NAPA#277549-HEADLIGHTS 01-410-56-00-5628 46.45 20 NAPA#277964-WIPER MOTOR 51-510-56-00-5628 143.65 21 NAPA#278270-TORCH LIGHTER 01-410-56-00-5628 4.14 22 NAPA#278269-SPARK PLUGS 01-410-56-00-5628 10.40 23 NAPA#278408-PIGTAIL HARNESS 01-410-56-00-5628 13.90 24 NAPA#278445-BULBS 01-410-56-00-5628 7.13 25 NAPA#277157-PLOW MARKERS 01-410-56-00-5628 76.48 INVOICE TOTAL: 1,107.16 032521-E.WILLRETT 02/28/21 01 ELEMENT FOUR-JAN 2021 BACKUP 01-640-54-00-5450 531.44 02 SERVICES ** COMMENT ** 03 ELEMENT FOUR-FEB 2021 BACKUP 01-640-54-00-5450 548.23 04 SERVICES ** COMMENT ** INVOICE TOTAL: 1,079.67 032521-G.STEFFENS 02/28/21 01 HOME DEPO-VACUUM FILTERS 52-520-56-00-5620 50.94 INVOICE TOTAL: 50.94 Page 2 of 11 DATE: 03/23/21 UNITED CITY OF YORKVILLE TIME: 08:01:00 MANUAL CHECK REGISTER ID: AP225000.WOW CHECK # VENDOR # INVOICE ITEM CHECK INVOICE # DATE # DESCRIPTION DATE ACCOUNT # ITEM AMT ----------------------------------------------------------------------- 900100 FNBO FIRST NATIONAL BANK OMAHA 03/25/21 032521-J.DYON 02/28/21 01 WAREHOUSE DIRECT-PRINTER INK 01-120-56-00-5610 11.20 02 WAREHOUSE DIRECT-PRINTER INK 51-510-56-00-5620 16.91 03 WAREHOUSE DIRECT-PRINTER INK 52-520-56-00-5610 4.88 INVOICE TOTAL: 32.99 * 032521-J.ENGBERG 02/28/21 01 ADOBE-MONTHLY CREATIVE CLOUD 01-220-54-00-5462 52.99 02 SHERWIN WILLIAMS-PAINT 01-220-54-00-5462 468.75 03 APA-MEMBERSHIP RENEWAL-ENGBERG 01-220-54-00-5460 575.00 INVOICE TOTAL: 1,096.74 032521-J.JACKSON 02/28/21 01 O'REILLY AUTO-POLISH 52-520-56-00-5628 15.99 INVOICE TOTAL: 15.99 * 032521-J.JENSEN 02/25/21 01 IACP-SHARED PRINCIPLE POSTER 01-210-56-00-5610 74.00 02 WPY-2021 EMPLOYMENT LAW 01-210-54-00-5412 129.00 03 SEMINAR REGISTRATION-JENSEN ** COMMENT ** INVOICE TOTAL: 203.00 * 032521-J.SLEEZER 02/28/21 01 AMAZON-REFUND FOR RETURNED 01-410-56-00-5600 -1,004.40 02 HEADSETS ** COMMENT ** 03 SES-CDL LICENSE RENEWAL 01-410-54-00-5462 66.46 04 AMAZON-AIR IMPACT WRENCH 01-410-56-00-5630 370.00 INVOICE TOTAL: -567.94 * 032521-J.WEISS 02/28/21 01 TARGET-CLEANING AND OFFICE 82-620-56-00-5671 27.73 02 SUPPLIES ** COMMENT ** INVOICE TOTAL: 27.73 * 032521-K.BARKSDALE 02/25/21 01 KONE-JAN 2021 ELEVATOR 23-216-54-00-5446 165.76 02 MAINTENANCE ** COMMENT ** 03 WAREHOUSE DIRECT-CLIPS,FOLDERS 01-220-56-00-5610 67.13 INVOICE TOTAL: 232.89 * 032521-K.GREGORY 02/28/21 01 ARAMARK#610000071242-MATS 01-410-54-00-5485 56.65 02 MASKS,TOWELS,BAG ** COMMENT ** 03 WELDSTAR#01925931-OXYGEN 01-410-54-00-5485 76.80 04 ARNESON#173443-JAN 2021 DIESEL 01-410-56-00-5695 67.28 05 ARNESON#173443-JAN 2021 DIESEL 51-510-56-00-5695 67.28 06 ARNESON#173443-JAN 2021 DIESEL 52-520-56-00-5695 67.28 11 ARAMARK#610000079401-MATS 52-520-54-00-5485 56.65 13 ARAMARK#610000075059-MATS 52-520-54-00-5485 56.65 15 WELDSTART#01929033-GAS STEEL 01-410-54-00-5485 35.96 16 CYL ** COMMENT ** 17 WATER PRODUCTS#0300891- 51-510-56-00-5640 50.87 18 COUPLING ** COMMENT ** Page 3 of 11 DATE: 03/23/21 UNITED CITY OF YORKVILLE TIME: 08:01:00 MANUAL CHECK REGISTER ID: AP225000.WOW CHECK # VENDOR # INVOICE ITEM CHECK INVOICE # DATE # DESCRIPTION DATE ACCOUNT # ITEM AMT --------------------------------------------------------------------- 900100 FNBO FIRST NATIONAL BANK OMAHA 03/25/21 032521-R.HORNER 02/28/21 01 RUAL KING-STIHL CHAINSAW PART 79-790-56-00-5640 6.70 INVOICE TOTAL: 6.70 032521-S.AUGUSTINE 02/28/21 01 AMAZON-BOOKS 84-840-56-00-5686 21.28 02 ILLINOIS LIBRARY 82-820-54-00-5426 100.00 03 ASSOCIATION-JOB POSTING ** COMMENT ** 04 ZOOM#INV68043807-WEBINAR 82-000-24-00-2480 40.00 06 AMAZON-CLOCK 82-820-56-00-5610 19.99 07 KENDALL PRINTING-CHECKS 82-820-56-00-5610 96.75 08 AMAZON-TONERS 82-820-56-00-5610 342.90 09 AMAZON-TONER,STAPLES,CARTRIDGE 82-820-56-00-5610 161.83 10 TRIBUNE-SUBSCRIPTION 82-820-54-00-5460 44.00 INVOICE TOTAL: 826.75 032521-S.IWANSKI 02/28/21 01 USPS-POSTAGE 82-820-54-00-5452 14.97 02 OFFICE DEPOT-CHRMAT 82-820-56-00-5610 37.79 03 USPS-PUBLISHING 82-820-54-00-5426 173.78 INVOICE TOTAL: 226.54 032521-S.RAASCH 02/28/21 01 CWF RESTORATION-BIOHAZARD 23-216-54-00-5446 1,950.00 02 SERVICES AT 610 TOWER LN ** COMMENT ** INVOICE TOTAL: 1,950.00 032521-S.REDMON 02/28/21 01 SAMS-RETURNED SUPPLIES FROM 79-795-56-00-5606 -23.84 02 ELSA DELIVERY ** COMMENT ** 03 SMITHEREEN-DEC 2020 PEST 79-795-54-00-5495 67.00 04 CONTROL ** COMMENT ** 05 SMITHEREEN-JAN 2021 PEST 79-795-54-00-5495 88.00 06 CONTROL ** COMMENT ** 07 AT&T-2/24-3/23 INTERNET FOR 79-795-54-00-5440 78.53 08 TOWN SQUARE PARK SIGN ** COMMENT ** 09 ARAMARK#610000058738-MATS 79-790-54-00-5462 18.21 10 ARAMARK#610000054546-MATS 79-790-54-00-5462 18.21 11 ARAMARK#610000051080-MATS 79-790-54-00-5462 18.21 12 ARAMARK#610000047984-MATS 79-790-54-00-5462 18.21 13 USPS-PRESCHOOL PACKET SHIPPING 79-795-54-00-5452 33.95 14 JOT FORM-2/7-3/6 MONTHLY FEE 79-795-56-00-5606 29.00 15 PLUG&PAY-JAN 2021 BILLING 79-795-54-00-5462 38.55 16 MENARDS-CLEANER 79-795-56-00-5606 166.10 17 REINDERS-BYPASS VALVE KIT 79-790-56-00-5640 131.11 18 REINDERS-IGNITION SWITCH 79-790-56-00-5640 177.24 19 ARNESON#176384-JAN 2021 GAS 79-790-56-00-5695 160.86 20 ARNESON#176384-JAN 2021 GAS 79-790-56-00-5695 739.95 21 STATE FOOD SAFETY-FOOD 79-795-54-00-5412 124.00 22 MANAGER SANITATION TRAINING ** COMMENT ** Total for all Highlighted Library Invoices: $4,704.63 Page 4 of 11 DATE: 04/06/21 UNITED CITY OF YORKVILLE TIME: 09:53:31 CHECK REGISTER PRG ID: AP215000.WOW CHECK DATE: 04/12/21 CHECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ------- ----------------------------------------------------- 105005 BAKTAY BAKER & TAYLOR 2035775435 02/22/21 01 BOOKS 84-840-56-00-5686 315.58 INVOICE TOTAL: 315.58 * 2035776522 02/24/21 01 BOOKS 84-840-56-00-5686 376.96 INVOICE TOTAL: 376.96 * 2035793393 03/02/21 01 BOOKS 84-840-56-00-5686 429.01 INVOICE TOTAL: 429.01 * 2035802121 03/11/21 01 BOOKS 84-640-56-00-5686 750.60 INVOICE TOTAL: 750.80 * 2035820925 03/16/21 01 BOOKS 84-840-56-00-5686 701.09 INVOICE TOTAL: 701.09 * 2035840059 03/25/21 01 BOOKS 84-840-56-00-5686 261.76 INVOICE TOTAL: 261.76 * CHECK TOTAL: 2,835.20 105006 CAMBRIA CAMBRIA SALES COMPANY INC. 42277 02/25/21 01 TOILET TISSUE, PAPER TOWEL, 82-820-56-00-5621 430.31 02 GARBAGE BAGS, DUSTING SPRAY, ** COMMENT ** 03 MOPHEADS ** COMMENT ** INVOICE TOTAL: 430.31 * CHECK TOTAL: 430.31 105007 EBSCO EBSCO INDUSTRIES, INC. 1000151001-1 03/10/21 01 LIBRARY AWARE DATABASE RENEWAL 82-820-54-00-5460 1,260.00 INVOICE TOTAL: 1,260.00 * CHECK TOTAL: 1,260.00 82-820 LIBRARY OPERATIONS 84-840 LIBRARY CAPITAL Page 5 of 11 DATE: 04/06/21 UNITED CITY OF YORKVILLE TIME: 09:53:31 CHECK REGISTER PRG ID: AP215000.WOW CHECK DATE: 04/12/21 CHECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT --------------------------------------------------------------------- 105008 ELEVATOR ELEVATOR INSPECTION SERVICE 99306 03/22/21 01 ELEVATOR INSPECTION 82-820-54-00-5462 75.00 INVOICE TOTAL: 75.00 * CHECK TOTAL: 75.00 105009 ERATEFUN E-RATE FUND SERVICES, LLC 420 01/14/21 01 FY20 E-RATE PROCESSING SERVICE 82-820-54-00-5462 185.33 INVOICE TOTAL: 185.33 * CHECK TOTAL: 185.33 105010 LLWCONSA LLOYD WARBER 10494 03/27/21 01 FEB-MAR 2021 ON SITE IT 82-820-54-00-5462 1,440.00 02 SUPPORT ** COMMENT ** INVOICE TOTAL: 1,440.00 CHECK TOTAL: 1,440.00 105011 MIDWTAPE MIDWEST TAPE 500095661 03/01/21 01 AUDIO BOOK 84-840-56-00-5683 39.99 02 DVDS 84-840-56-00-5685 48.72 INVOICE TOTAL: 88.71 500131795 03/09/21 01 AUDIO BOOK 84-840-56-00-5683 24.99 02 DVDS 84-840-56-00-5685 29.98 INVOICE TOTAL: 54.97 500168145 03/15/21 01 DVDS 84-840-56-00-5685 44.98 INVOICE TOTAL: 44.98 500184351 03/18/21 01 DVD 84-640-56-00-5685 22.49 INVOICE TOTAL: 22.49 82-820 LIBRARY OPERATIONS 84-840 LIBRARY CAPITAL Page 6 of 11 DATE: 04/06/21 UNITED CITY OF YORKVILLE TIME: 09:53:31 CHECK REGISTER PRG ID: AP215000.WOW CHECK DATE: 04/12/21 CHECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ------------------------------------------------------------------------- 105011 MIDWTAPE MIDWEST TAPE 500204974 03/23/21 01 AUDIO BOOKS 84-840-56-00-5683 109.97 INVOICE TOTAL: 109.97 * 500231897 03/29/21 01 AUDIO BOOK 84-840-56-00-5683 34.99 02 DVDS 84-840-56-00-5685 38.95 / 03 CDS 84-840-56-00-5684 41.00 INVOICE TOTAL: 114.94 * CHECK TOTAL: 436.06 105012 PRAIRCAT PRAIRIECAT 7087 11/02/20 01 MOBILE BASE APPLICATION 82-820-54-00-5468 599.00 INVOICE TOTAL: 599.00 * 7305 04/01/21 01 PARTICIPATION FEES-APR 2021 82-820-54-00-5468 1,267.08 02 PARTICIPATION FEE-MAY-JUN 2021 82-000-14-00-1400 2,534.17 INVOICE TOTAL: 3,801.25 * CHECK TOTAL: 4,400.25 105013 R0002451 NORTH SUBURBAN LIBRARY 030921-RPLCMNT 03/09/21 01 LOST BOOK REPLACEMENT 82-820-56-00-5686 27.50 INVOICE TOTAL: 27.50 * CHECK TOTAL: 27.50 105014 RJONEIL R.J. O'NEIL, INC. 00113708 03/10/21 01 BLOWER & RETURN AIR HANDLER 82-820-54-00-5462 180.66 02 REPAIR ** COMMENT ** INVOICE TOTAL: 180.66 * 00113767 03/23/21 01 REPLACED LOW WATER CUT OFF 82-820-54-00-5495 823.47 INVOICE TOTAL:. 823.47 * CHECK TOTAL: 1,004.13 82-820 LIBRARY OPERATIONS 84-840 LIBRARYCAPITAL Page 7 of 11 DATE: 04/06/21 UNITED CITY OF YORKVILLE TIME: 09:53:31 CHECK REGISTER PRG ID: AP215000.WOW CHECK DATE: 04/12/21 CHECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ----------------------------------------------------------- 105015 TERRACAR TERRA CARE ENTERPRISES, INC 10118 10/16/20 01 TREE TRIMMING AND REMOVAL 82-820-54-00-5495 585.00 INVOICE TOTAL: 585.00 CHECK TOTAL: 585.00 105016 UMBRELLA UMBRELLA TECHNOLOGIES 012621-BALANCE 01/26/21 01 BALANCE FOR INSTALLATION OF 82-820-54-00-5462 2,950.00 02 SMART HUB ** COMMENT ** INVOICE TOTAL: 2,950.00 CHECK TOTAL: 2,950.00 105017 WEBLINX WEBLINX INCORPORATED 29932 03/12/21 01 WEBSITE DESIGN INSTALLATION 3 82-820-54-00-5462 1, 650.00 02 OF 4 ** COMMENT ** INVOICE TOTAL: 1, 650.00 CHECK TOTAL: 1,650.00 105018 YOUNGM MARLYS J. YOUNG 020621 02/23/21 01 02/08/21 MEETING MINUTES 82-820-54-00-5462 88.25 INVOICE TOTAL: 88.25 030821 03/21/21 01 03/08/21 MEETING MINUTES 82-820-54-00-5462 89.50 INVOICE TOTAL: 89.50 031521 03/28/21 01 03/15/21 MEETING MINUTES 82-820-54-00-5462 73.00 INVOICE TOTAL: 73.00 CHECK TOTAL: 250.75 TOTAL AMOUNT PAID: 17,529.53 82-820 LIBRARY OPERATIONS 84-840 LIBRARY CAPITAL Page 8 of l l , D C/T� _u O EST. , @ � 1836 4 �,,�,, UNITED CITY OF YORKVILLE PAYROLL SUMMARY March 5 2021 REGULAR OVERTIME TOTAL IMRF FICA TOTALS ADMINISTRATION $ 20,995.59 $ - 20,995.59 $ 2,340.95 $ 1,558.67 $ 24,895.21 FINANCE 9,081.46 - 9,081.46 1,025.61 692.64 $ 10,799.71 POLICE 126,089.53 2,534.57 128,624.10 719.52 9,575.84 $ 138,919.46 COMMUNITY DEV. 19,814.10 - 19,814.10 2,234.69 1,478.32 $ 23,527.11 STREETS 16,569.58 4,120.02 20,689.60 2,298.63 1,521.61 $ 24,509.84 WATER 16,953.18 181.23 17,134.41 1,920.30 1,266.13 $ 20,320.84 SEWER 10,875.58 - 10,875.58 1,208.26 797.07 $ 12,880.91 PARKS 22,504.03 1,516.82 24,020.85 2,679.83 1,778.99 $ 28,479.67 RECREATION 15,562.50 - 15,562.50 1,580.46 1,167.95 $ 18,310.91 LIBRARY 13,890.63 - 13,890.63 880.32 1,025.04 $ 15,795.99 TOTALS $ 272,336.18 $ 8,352.64 $ 280,688.82 $ 16,888.57 $ 20,862.26 $ 318,439.65 TOTAL PAYROLL $ 318,439.65 Page 9 of 11 D C/�, EST. , _ 1836 UNITED CITY OF YORKVILLE <E PAYROLL SUMMARY March 19, 2021 REGULAR OVERTIME TOTAL IMRF FICA TOTALS MAYOR & LIQ. COM. $ 908.34 $ - $ 908.34 $ - $ 69.49 $ 977.83 ALDERMAN 4,000.00 - 4,000.00 - 306.00 4,306.00 ADMINISTRATION 21,245.56 - 21,245.56 2,360.38 1,572.06 25,178.00 FINANCE 9,405.75 - 9,405.75 1,044.98 705.97 11,156.70 POLICE 116,468.86 2,645.41 119,114.27 719.52 8,817.78 128,651.57 COMMUNITY DEV. 19,814.10 - 19,814.10 2,201.35 1,455.38 23,470.83 STREETS 17,236.41 - 17,236.41 1,914.96 1,260.68 20,412.05 WATER 17,637.65 213.49 17,851.14 1,983.27 1,307.02 21,141.43 SEWER 10,842.37 - 10,842.37 1,204.59 793.76 12,840.72 PARKS 23,265.21 - 23,265.21 2,584.76 1,713.55 27,563.52 RECREATION 15,993.02 - 15,993.02 1,555.47 1,183.70 18,732.19 LIBRARY 15,507.39 - 15,507.39 991.43 1,148.72 17,647.54 TOTALS $ 272,324.66 $ 2,858.90 $ 275,183.56 $ 16,560.71 $ 20,334.11 $ 312,078.38 TOTAL PAYROLL $ 312,078.38 Page 10 of 11 P111111C LIBRARY Y YORKVILLE LIBRARY BOARD BILL LIST SUMMARY Monday,April 12, 2021 ACCOUNTS PAYABLE Library CC Check Register (Pages 1 -4) 03/25/2021 $4,704.63 Library Check Register (Pages 5-8) 04/12/2021 17,529.53 Metlife- Mar. 2020 Dental Ins. 03/09/2021 526.83 Building Permit Cancellation Refund 03/09/2021 250.00 IPRF-Apr. 2021 Workers Comp 03/09/2021 979.66 Umbrella Tech-Deposit for updating keyless entry 03/23/2021 2,950.00 Nicor-02/01/21-03/02/21 services 03/23/2021 1,901.47 TOTAL BILLS PAID: $28,842.12 PAYROLL DATE Bi-weekly(Page 9) 03/05/2021 $ 15,795.99 Bi-weekly(Page 10) 03/19/2021 17,647.54 TOTAL PAYROLL: $33,443.53 TOTAL DISBURSEMENTS: $62,285.65 Page 11 of 11 DATE: 04/06/2021 UNITED CITY OF YORKVILLE PAGE: 1 TIME: 13:55:46 GENERAL LEDGER ACTIVITY REPORT ID: GL440000.WOW FOR FISCAL YEAR 2021 ACTIVITY THROUGH FISCAL PERIOD 11 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 82-000-24-00-2480 (L) ESCROW - MEMORIALS & GIFTS O1 05/01/2020 BEGINNING BALANCE 49,444.29 AP-200525MB 05/19/2020 13 BREAKOUT-EDU KIT REFUND FIRST NATIONAL BANK 900088 052520-E.TOPPER-B 160.88 TOTAL PERIOD O1 ACTIVITY 0.00 160.88 02 AP-200625MB 06/16/2020 101 AMAZON-FIRE 7 TABLET FIRST NATIONAL BANK 900090 062520-E.TOPPER-B 47.49 GJ-200630LB 07/02/2020 05 June 2020 Deposits 196.19 TOTAL PERIOD 02 ACTIVITY 47.49 196.19 03 AP-200713 07/07/2020 01 BOOKS BAKER & TAYLOR 104898 2035272564 673.42 07/07/2020 02 BOOKS BAKER & TAYLOR 104898 2035278024 554.19 AP-200725M 07/16/2020 213 AMAZON-ROCKING CHAIR FIRST NATIONAL BANK 900092 072520-E.TOPPER 44.99 07/16/2020 214 AMAZON-ADDRESS LABELS, FIRST NATIONAL BANK 900092 072520-E.TOPPER 76.36 07/16/2020 215 AMAZON-ELECTRONIC KEYBOARD FIRST NATIONAL BANK 900092 072520-E.TOPPER 82.99 07/16/2020 216 AMAZON-GAMES, CARDS FIRST NATIONAL BANK 900092 072520-E.TOPPER 36.93 07/16/2020 217 AMAZON-SENSORY BALL FIRST NATIONAL BANK 900092 072520-E.TOPPER 14.99 07/16/2020 218 THERAPY SHOPPE-FIDGETS FIRST NATIONAL BANK 900092 072520-J.WEISS 105.61 07/16/2020 219 FOXY'S ICE CREAM-16 $5.00 GIFT FIRST NATIONAL BANK 900092 072520-J.WEISS 80.00 07/16/2020 220 ROSATIS-GIFT CARDS FOR SUMMER FIRST NATIONAL BANK 900092 072520-J.WEISS 40.00 07/16/2020 221 PARMA-GIFT CARDS FOR SUMMER FIRST NATIONAL BANK 900092 072520-J.WEISS 40.00 07/16/2020 222 STARBUCKS-SUMMER READING GIFT FIRST NATIONAL BANK 900092 072520-S.AUGUSTINE 20.00 07/16/2020 223 GRACE COFFEE-SUMMER READING FIRST NATIONAL BANK 900092 072520-S.AUGUSTINE 10.00 GJ-200731LB 08/02/2020 03 July 220 Deposits 1,216.44 TOTAL PERIOD 03 ACTIVITY 1,779.48 1,216.44 04 AP-200825M 08/19/2020 165 AMAZON-BOOKS, JUMPER CABLES, FIRST NATIONAL BANK 900093 082520-E.TOPPER 678.01 08/19/2020 166 AMAZON-ALEXA SPEAKER FIRST NATIONAL BANK 900093 082520-E.TOPPER 39.99 08/19/2020 167 AMAZON-SUPPLY CASE FIRST NATIONAL BANK 900093 082520-E.TOPPER 22.73 08/19/2020 168 AMAZON-FIRE 7 TABLET FIRST NATIONAL BANK 900093 082520-E.TOPPER 49.99 08/19/2020 169 DOLLAR TREE-SUMMER READING FIRST NATIONAL BANK 900093 082520-J.WEISS 12.50 08/19/2020 170 TARGET-SUMMER READING GIFT FIRST NATIONAL BANK 900093 082520-J.WEISS 25.00 GJ-200831LB 09/01/2020 05 Aug 2020 Deposits 4,708.14 TOTAL PERIOD 04 ACTIVITY 828.22 4,708.14 05 AP-200914 09/08/2020 01 BOOKS BAKER & TAYLOR 104920 2035371948 658.84 09/08/2020 02 BOOKS BAKER & TAYLOR 104920 2035383645 676.99 09/08/2020 03 BOOKS BAKER & TAYLOR 104920 2035405495 536.18 09/08/2020 04 BOOKS BAKER & TAYLOR 104920 2035418721 436.93 09/08/2020 05 BOOKS BAKER & TAYLOR 104920 2035422067 467.45 09/08/2020 06 BOOKS BAKER & TAYLOR 104920 2035428949 293.26 09/08/2020 07 BOOKS BAKER & TAYLOR 104920 20359395078 303.11 TOTAL PERIOD O5 ACTIVITY 3,372.76 0.00 06 AP-201012 10/06/2020 01 BOOKS BAKER & TAYLOR 104933 2035452893 616.27 10/06/2020 02 BOOKS BAKER & TAYLOR 104933 2035480910 50.86 10/06/2020 03 ANNUAL SUBSCRIPTION RENEWAL PROMOTION, INC. 104934 550082 588.00 AP-201025M 10/19/2020 219 CONSTANT CONTACT-ANNUAL FIRST NATIONAL BANK 900095 102520-E.TOPPER 588.00 GJ-201031LB 11/02/2020 06 Oct 2020 Deposits 1,686.00 TOTAL PERIOD 06 ACTIVITY 1,843.13 1,686.00 DATE: 04/06/2021 UNITED CITY OF YORKVILLE PAGE: 2 TIME: 13:55:47 GENERAL LEDGER ACTIVITY REPORT ID: GL440000.WOW FOR FISCAL YEAR 2021 ACTIVITY THROUGH FISCAL PERIOD 11 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 82-000-24-00-2480 (L) ESCROW - MEMORIALS & GIFTS 08 AP-201214 12/07/2020 01 BOOKS BAKER & TAYLOR 104955 2035562347 31.50 12/07/2020 02 BOOKS BAKER & TAYLOR 104955 2035572750 39.12 AP-201225M 12/28/2020 177 AMAZON-SEED GEMS, FM FIRST NATIONAL BANK 900097 122520-E.TOPPER 127.83 12/28/2020 178 AMAZON-ZIPPER BAGS FIRST NATIONAL BANK 900097 122520-E.TOPPER 7.78 12/28/2020 179 AMAZON-HOT CHOCOLATE FIRST NATIONAL BANK 900097 122520-E.TOPPER 13.40 12/28/2020 180 DOLLAR TREE-POLAR EXPRESS FIRST NATIONAL BANK 900097 122520-J.WEISS 26.50 12/28/2020 181 DOLLAR TREE-POLAR EXPRESS FIRST NATIONAL BANK 900097 122520-J.WEISS 12.50 GJ-201231LB 01/04/2021 04 Dec 2020 Deposits 449.03 TOTAL PERIOD 08 ACTIVITY 258.63 449.03 10 AP-210208 02/02/2021 01 BOOKS BAKER & TAYLOR 104979 2035690481 122.82 02/02/2021 02 BOOKS BAKER & TAYLOR 104979 2035705110 32.38 GJ-210228LB 03/01/2021 05 Feb 2021 Deposits 40.00 TOTAL PERIOD 10 ACTIVITY 155.20 40.00 11 AP-210308 03/02/2021 02 BOOKS BAKER & TAYLOR 104996 2035715610 29.98 03/02/2021 03 BOOKS BAKER & TAYLOR 104996 2035734564 35.40 AP-210325M 03/23/2021 245 ZOOM#INV68043807-WEBINAR FIRST NATIONAL BANK 900100 032521-S.AUGUSTINE 40.00 GJ-210331LB 04/05/2021 05 March 2021 Deposits 250.00 TOTAL PERIOD 11 ACTIVITY 105.38 250.00 TOTAL ACCOUNT ACTIVITY 8,390.29 8,706.68 ENDING BALANCE 49,760.68 GRAND TOTAL 0.00 49,760.68 TOTAL DIFFERENCE 0.00 49,760.68 YORKVILLE PUBLIC LIBRARY A FISCAL YEAR 2021 BUDGET REPORT PUBLIC LIBRARY For the Month Ended March 31,2021 %n(Frrd 1'm. A°e li a 25% 354 a+'- 501 51, 5:?: 75:4 F394 9r' AC'C'0141T.11111R D6SCTUPTIO\ Mar-20 Jwre-20 Juh-20 A x1-20 Se ertMrvEU O<.W-20 \a�rmbrr-EU leash,-20 Jaruon--21 re6nn -EI M_n 2t 3rT-h-Mil ��'B000ET 021 tBud¢r( LIBRARY OPERATIONS REVENUES T.- 82-000-40-004000 'c82-000-!0-004000 PROPERTY TAXES - 351,569 27,872 31,873 295,065 18,644 X,900 - 736,X83 779,047 99.71% 11 le n-00-0085 PROPERTY TAXIiS-DEBT SERVICE - 3')3,43X 1-146 J5,6G9 333,562 2(1.864 9,960 11 le menmarrrul - - 824,640 8",951 100.21% R2-000-0I-00-4120 PERSONAL PROPERTY TAX 800 - 831 614 - 779 - 202 958 _ 346 4,510 5,250 86.2X% R2-000-11-00-1170 STATE GRAMS - - - - 21,151 - _ 500 F'ncs h For eitr - - - 21,651 20,(700 108.26% 82-00043-00-3730 LIBRARY FINES - 1,072 - 526 56 179 796 G3 134 380 Ch es ar Service LIG 2.921 8,500 34.36% R2-000-344)0-4401 LIBRARY SUBSCRIPFION CARDS - 476 175 342 168 165 1,504 285 863 673 4,653 X,500 54.74% 92-000-044KN422 COPYFEES - 3 - 325 7 362 36 189 124 8 326 1,579 3,800 41.56% fl2-000-04-00-1439 PROGRAM II>Ii5 - _ h-l.-t Emur s - - - 2 - - - 2 - 0.0(1% 8241fKH5-004500 INVESTMCNT EARNINGS 203 14'_ 136 103 102 148 I(NI 93 74 G4 56 Il-ell-ell1,'_21 8,959 13.62% X2-00048-00-4820 R[iNTAL INCOME _ 1.750 0.00 8248048-00-185(1 MISCELLANLOUS INCOMG 44 In8 665 2000 Other FinnnNn Sanrcrs 3,25% 82-000-19-00-1901 TRANSFER FROM GENERAL 5.911 1,911 2.244 1.911 1,911 2.244 992 '779 4,476 2.325 , 980 25.A84 26,564 97.;7% TOTAL REVENUES:LIBRARY 6,914 748,934 62,364 71,363 655,073 43,388 21,889 1,726 6,689 3,684 2,606 1,624,429 1,647,343 78.62 LIBRARY OPERATIONS EXPENDITURES Sn(mirs.f B' X2-820-50-0U-5010 SALARIES&WAGES 31,602 21.068 21,068 21,068 21,068 34,224 21,700 37,779 16,847 16,X47 IG,847 260,119 289,742 89.78% 62-920-50-00-5015 PART=I'IA�SALARIES 19,92`) 9,261 9,829 10.936 In 5n5 17,780 11,605 12,063 10,771 li?'+2 12.551 138,501 190,000 72 Bnm rls 90 82-820-52-00-5212 RETiREMENTPLANCONTRIBUTION 3,547 2,370 2,770 2.370 2,370 3,840 2,441 4,237 1,872 1,872 1.872 29,159 32,779 88.96% 82520-52-00-5214 FICA CONTRIBUTION 3,X86 2,264 2,307 2,796 2359 3.922 2,491 3,776 2,078 225 '-. 2,174 29,814 15,95'_ 52.99% 82-820-52-00-5216 GROUPHEALI'II INSURANCE 10,625 9,593 8,998 4,655 4,655 3,828 4,492 4,770 10,023 6,284 6,153 74.077 76,764 - 96 50% 82-520-52-00-5222 GROUP LIFE INSURANCE 29 29 29 29 29 58 - 29 24 24 24 304 387 78.44% 82-820-52-00-5223 DENTAL INSURANCE 527 527 396 527 527 527 527 527 527 527 527 5,6+64 6,322 99.60% 82-X20-52-00-1224 VISION INSURANCE 169 84 84 84 84 84 - R4 84 72 84 915 1,012 90.41% 82-820-52-(111-5230 UNEMPLOYME-NT INSURANCE 333 - 331 - - 333 - - - 364 - 1 36 750 18 1.69% 82-820-52-00-5231 1 LIABILITY INSURANCE 5.578 1,911 1.911 1.911 1.9111,911 992 979 4,476 1.961 980 24.522 25,834 94.92% Cnuracnml Services 82-82n-54-00-5412 TRAINING R CONFERENCES - - 3 000 0.00% 82-820-54-00-5415 TRAVEL&LODGING - - - - - - - - 1.500 0.00% 82-820-54-00-5426 PUBLISHING&ADVERTISING - 228 567 35 - - _ _ _ - 274 1,104 2,500 44.15% 82-820-54-00-5440 TELECOMMUNICATIONS - - 609 420 4,127 421 420 419 - 840 - 7,256 7,200 100.78% 82-820-54-00-5452 POSTAGE&SHIPPING - - 7 5 239 20 16 15 14 121 15 452 750 60.12% 82-820-54-00-5460 DUES&SUBSCRIPTIONS 593 185 248 51 284 3,037 1 2,997 1,674 128 343 57 9,597 11,000 8721% 82-820-54-00-5462 PROFESSIONAL SERVICES 3,865 1,442 1,771 210 4,511 288 3,680 905 2.361 5,001 9.771 33,804 40.000 54.51% 82-820-54-00-5466 LEGAL SERVICES - - _ 338 - - - - 3,825 450 - 4,613 1,000 15175% 82-S20-54-00-5468 AIrrOMAT10N 2,366 - 4,105 503 - 3,801 - 411 - 3,801 - 14,990 20,000 74.95% 82-820-54-00-5480 UTILITIES - - 600 1,281 735 1,124 1.213 1,465 1,874 1,630 1,901 11,824 11798 100.22% 92-820-54-00-5495 OUTSIDE REPAIR&MAINTENANCE - - 2,195 462 4,277 6,738 1,120 - 4,6985,481 895 25,866 50,000 51.73% 82-820-54-00-5498 PAYING AGENT FEES - 1,100 589 - - - - - _ 1.689 1.700 99.32% &, /les 82-820-56-00-5(10 OFFICE SUPPLIES - 311 69 144 438 587 1,119 596 178 176 789 4,407 8,000 55.0X% 82-820-56-00-5620 OPERATING SUPPLIES - 78 - 152 690 39 IX 3,200 - - - 4,177 4,000 104.43% 82-S20-56-00-5621 CUSTODIAL SUPPLIES - 895 1,028 306 1,636 49 - 410 769 1,947 250 7,285 7,000 10407% 82-820-56-00-5635 COMPI=EQUIPMLNT&SOFTWARE _ _ _ :7 - 207 _ _ - _ 244 2,000 12.20°0 R2S2(1-56-00-5671 LIBRARY PROGRAMMING - - 55 - 81 - 276 - 42 - 28 481 2,000 24.05% 82-820-56-00-5675 EMPLOYEE RECOGNITION - - - _ _ - 45 _ - _ 45 100 15.00% YORKVILLE PUBLIC LIBRARY FISCAL YEAR 2021 BUDGET REPORT v Ar For the Month Ended March 31,2021 PUBLICIJBRARY :: 255 ».. 127: 505 58, 17% .751 83?: 91;a YeaMo-Dafe FISCAL\'P 1R 2021 \C[.Of�NT NI'}IXlR DFSC'BIMON Nfa,-20 Jwe-20 July-20 A 91-20 Sr ember-2U W.I ,-20 N...m r-20 Uerrmbrr-20 Jaanri-21 Fe6rw -21 AfartM121 Tofah BUDGET Y.ofBUJCN 82-S20-5ur-B"f DVUS _ _ _ _ - im 82-820-5BOOKS 1062006 B- - 365 I,SOU 24.34% 82-820-5PRINCIPALPAYNTWF - 7s.non82-520-8INTGREST PA1TfElVT - 10,11920,335 2U??32nd - - 100.00% 82-520-9PRINCIPAL.PAYMENT - _ 610,000 - - 610000 610.00082-520-9MTEREST PAYMENT _ 60.925 - - - - - 60.9'_5 - - - 121.85(1 121.850 TOTAL FUND REVENUES 6,914 74%.934 62.36) 71}63 655,071 13,388 21,889 1,726 6,6X9 3,684 2,606 1,621,629 1,647}J3 98.62'/. TOTAL FUND EXPENDITURES 83,048 122}90 59,275 47931 60,563 82,60555,617 829,385 60,551 63,18) 55,191 1„5(9,710 1,661}78 91.}1 FUND SURPLUS(DEFICI-F) (76,131) 626,511 1,089 23,4!1 594,510 (39,218) (33,728) (827,660) (13,862) (59,500) (5285) 101,A88 (17,035) LIBRARY CAPITAL REVENUES 84-000-42-004214 DrVELOPMENT FEES 3,500 1.500 7,900 17,900 1G.O50 15.550 3,050 9,500 6000 6,750 g124 10 AW 50,000 20020% 814)(10-15-00-1500 [NVES'1'MENF EARNINGS 16IS 17 14 17 20 12 167 5(10 13.10% 6441(10-18110-4850 MISCELLANEOUS INC'OMF - 2G _ _ 26 - (100% TOTAL REVENUES:LIBRARY CAPITAL 3,516 1 541 7,917 17,914 16,067 15,5703,065 9514 6,014 6762 100,293 -50,50o-198.60--/. LIBRARY CAPITAL EXPENDITURES 84-840-54-00-5460 E-BOOK SUBSCRIPTIONS _ - _ - - - 3.347 - 3.147 3.500 95.61% 84-810-5G-0o-5635 CONIPUILR EQL91'h1LNT&SOFTIVARE - 1,326 - - - 50 1,650 4,892 - - - 7,919 I5,00o 52.79% 84-840-SG-00-5483 AUDR7 B(x)KS - 155 271 40 190 225 787 307 41 40 45 2,10' 3.509 60.04% 84-340-56-00-5684 COMPACT DISCS&OTHER MUSIC - Ib - - 14 10 - 41 69 13 _ 163 500 3258% 84-540-5G-00-5685 DVD'S - 420 361 25 239 255 - 186 123 170 274 2.033 3,000 68.47% 84-840-56-00-5686 BCK)KS - 1046404 2,999 - 3,331 5.078 1 7,128 1 1.544 7,149 1 4.419 33,096 501000 66.L9% TOTAL FUND REVENUES }516 1511 7,917 17,91) 16,067 15570 3,065 9,514 6,011 6,762 12,JU 100,29} 50,500 19X.60% TOTAL FUND EXPENDITURES - 2,963 1,036 3,064 443 3,8.71 7 515 12,551 1,777 10,718 4,737 48,679 75,500 64.46•/. FUND SURPLUS(DEF3CI'I) 3,516 (1,422) 6,%80 14,051 15,624 11,699 (4,450) (3,041) 4,236 (31956) 7,676 51,614 (25,000) 2 YORKVILLE PUBLIC LIBRARY Ir PUBLIC LIBRARY CASH STATEMENT As of March 31, 2021 FISCAL YEAR 2021 May June July August September October November December January February March April 2020 2020 2020 2020 2020 2020 2020 2020 2021 2021 2021 2021 Library Operations Old Second S 321,123 $ 629,168 $ 588,982 $ 575,506 $ 874,784 $ 839,655 S 801,304 S 644,730 $ 603,203 $ 523,033 $ 470,808 Building Old Second 123,389 123,967 l� Development Fees _3,713 120,664 146,038 158,237 166,287 156,796 164,532 160,727 162,658 Library Operations IMET" 4,126 4,126 4,126 4,126 4,126 4,126 4,126 4,126 4,126 J4,126 4,126 Library Operations Illinois Funds 236,679 236,766 236,816 236,848 258,024 258,046 258,066 258,086 258,105 258,120 258,133 Total: S 685,315 S 994,026 S 953,637 S 937,144 $ 1,282,972 $ 1,260,064 $ 1,229,782 $ 1,063,738 $ 1,029,966 S 946,005 $ 895,724 S - *Restricted PAYROLL ,IT PAY PERIOD $ 19,794 S 17,836 $ 17,494 $ 18,360 $ 17,830 $ 21,421 $ 19,389 $ 39,288 $ 13,850 $ 16,383 $ 15,796 2ND PAY PERIOD 19,653 17,277 18,230 18,459 18,622 19,130 18,848 18,566 17,678 17,784 17,648 3"PAY PERIOD 19,667 - Total $ 59,113 $ 35,113 S 35,724 S 36,819 $ 36,452 S 52,765 S 38,237 $ 57,854 S 31,528 S 34,167 S 33,444 S - YORKVILLE PUBLIC LIBRARY STATEMENT OF REVENUES,EXPENDITURES AND TRANSFERS ��ss ��,�P" For the Month Ended March 31,2021 -0/ °' P�1BL[C LIBRAHtY Fiscal Year 2020 March YTD %of FY 2021 For the Month Ended March 31,2020 Actual Actual Budget Budget YTD Actual %Change LIBRARY OPERATIONS FUND(82) Revenues Property Taxes $ - $ 1,561,523 100.0% $ 1,562,000 $ 1,497,431 4.28% Intergovernmental Personal Property Replacement Tax $ 346 $ 4,530 86.3% $ 5,250 $ 5,269 -14.03% State Grants - 21,651 108.3% 20,000 21,151 2.36% Total Intergovernmental $ 346 $ 26,181 103.7% $ 25,250 $ 26,420 -0.90% Library Fines $ 116 $ 2,921 34.4% $ 8,500 $ 7,464 -60.87% Charges for Services Library Subscription Cards $ 673 $ 4,653 54.7% $ 8,500 $ 7,558 -38.44% Copy Fees 326 1,579 41.6% 3,800 3,582 -55.92% Program Fees - 2 0.0% - 64 -96.87% Total Charges for Services $ 999 $ 6,234 50.7% $ 12,300 $ 11,204 -44.36% Investment Earnings $ 56 $ 1,221 13.6% $ 8,959 $ 16,196 -92.46% Reimbursements/Miscellaneous/Transfers In Miscellaneous Reimbursements $ - $ - 0.0% $ - $ - 0.00% Rental Income - - 0.0% 1,750 1,350 -100.00% Miscellaneous Income 108 665 33.3% 2,000 2,524 -73.65% Transfers In 980 25,884 97.4% 26,584 24,388 6.14% Total Miscellaneous&Transfers $ 1,088 $ 26,550 87.5% $ 30,334 $ 28,262 -6.06% Total Revenues and Transfers S 2,606 $ 1,624,629 98.6% $ 1,647,343 $ 1,586,976 2.37% Expenditures Library Operations $ 55.191 $ 1.519.740 91.3% $ 1.664.378 $ 1,50707 0.80% 50 Salaries 29,398 398,620 83.1% 479,742 403,536 -1.22% 52 Benefits 11,813 165,839 92.2% 179,800 157,953 4.99% 54 Contractual Services 12,913 111,190 72.9% 152,448 131,121 -15.20% 56 Supplies 1,067 17,004 67.2% 25,300 18,064 -5.87% 99 Debt Service - 827,088 100.0% 827,088 797,013 3.77% Total Expenditures and Transfers $ 55,191 $ 1,519,740 91.3% $ 1,664,378 S 1,507,687 0.80% Surplus(Deficit) $ (52,585) $ 104,888 $ (17,035) $ 79,289 * March represents 92%of fiscal year 2021 Director's Report March 2021 Summary R.J. O'Neil came on the March 15th to replace a low water control board on boiler 1. The new Keyless access system is installed but turns out we need new readers installed because the ones we have are proprietary to the old system. In addition, by disconnecting the doors from the motion detectors we had to have a new motion panel and keypad installed by ADS to be able to set the alarm. The city facilities manager is working with us on getting the Library on the same schedule for inspections as the city buildings. Fire extinguishers were checked April 6, 2021 and backflow will be on April 13,2021. It has been noticed that some gutter damage occurred on the front meeting room roof as well as the snow bar over the door has slipped down. We have a call in to the installer of the snowbars to come out and inspect. Sharyl has made some good connections with folks at Senior Services, Heritage Woods and Cedar Hurst senior living centers. She is planning an April tour for Seniors from Heritage Woods. Coordinators at Heritage Woods and Cedar Hurst have been set up with a library card and are using it to borrow movies and books for their residents. The free bookshelf Sharyl and Jennette set up at the laundromat has been well received and used. Staff is learning LibraryAware's marketing tools for the newsletter, website and displays. National Library Week April 4-10 "Welcome to your Library" Shelley posted a letter to the editor in the Kendall County Record for April 1 to celebrate the week activities, programs, games, contests, drawings (compliments of the Friends of the Library), and book giveaways. At the March 23 city council meeting, the mayor read a proclamation declaring April 4-10 as National Library Week in the city. A staff member worked on a project to collect library cards from every state in the country and has displayed them on a map in the library lobby.The Friends of the Library have also sponsored a virtual program on the evening of Wed, Apr 7 at 7:00—registration is required. 4 new monitors were purchased and installed to replace original square monitors at both service desks. We are joined 30 other businesses and participated in the Yorkville Chamber of Commerce's Yorkville's Great Egg Scape Drive Up Egg Hunt that will run April 1-11. We are inviting people to come in for our scavenger hunt and raffle. We will be encouraging participants to post their photo to the Yorkville's Great Egg-scape Facebook page. We are now listing patrons total saving for using your library card when they when they checkout items. The total savings will be listed at the bottom of their checkout slips. This has been a 2 year request that we have had with PrairieCat to list this savings. We will make sure to have staff show patrons of the amount of money our patrons are saving by using their library card. Shelley has registered for a few marketing meetings and conferences for the following week. Rails is conducting a Marketing with Infographics Zoom meeting.The Yorkville Chamber of Commerce is having a lunch and learn on marketing your digital presence. ILA Marketing Forum Mini Conference. Spoke with Weblinx on the progress of our website. They are in the development phase of building. They are coding, building out internal pages, and plug-ins. We should see a demo site in 7-8 weeks. Programs Children's Programs: 9 programs with 104 attending (2 book clubs, 2 story times, Zoom Bingo,window art, escape, 2 4-H STEM Mars) 12 passive programs with 706 views (5 crafts-to-go, 4 virtual story times, 2 virtual STEM, 1 Spanish story time) 4 Teen programs with 13 attending(book club& 2 TAG, Dungeons & Dragons Zoom 2 passive teen programs with 16 attending(crafts-to-go, 3-D printing) Adult Programs: 5 programs with 68 attending 3/2 Threads Zoom-6 3/10 Lunch Bunch book club/Zoom- 7 3/18 Men's Book Club/Zoom-7 3/23 Creative Writing Zoom-12 3//4 Rachael Carson- 36 Passive Programs:1 YouTube 18 views (Rachael Carson recording) Meeting Room Usage: Rentals-0; Library use- 10; Community use-5 Museum pass:4 Proctored tests:0 Volunteers- Friends of the Library are operating the Lobby book sale and have been continuing to index the KCR Obits. YORKVILLE STATISTICS FOR FY21 PrairieCat Items to Reciproc Items al Items borrowe Borrower All checkout lent to d from s Transacti web s+ checkout all holds holds other other atYorkvill Items Patrons ons renewals renewals s renewals placed filled checkins libraries libraries e added added MAY 641 0 24 13 11 0 0 617 0 0 0 413 10 JUNE 7,303 128 2,095 1967, 128 528 1,756 2,924 96 275 31 269 12 JUL 10,324 457 4,704 4,451 253 285 2,110 3,224 814 1,548 97 324 34 AUG 12,723 744 5,498 5,321 177 381 2,005 4,839 698 1,547 241 313 46 SEP 12,163 796 5,469 5,258 211 348 2,111 4,235 732 1,618 178 388 53 OCT 12,824 1125 5,626 5,383 243 329 2,093 4,776 728 1,670 217 327 67 NOV 12,160 776 5,372 5,103 269 271 2,036 4,481 680 1,522 297 444 37 DEC 11,403 843 5,137 4,711 426 314 1,732 4,220 661 1,308 329 309 27 JAN 12,480 814 5,701 5,397 304 428 2,096 4,255 817 1,594 329 369 45 FEB 12,611 890 5,382 5,161 221 326 1,871 5,032 669 1,464 353 468 59 MAR 14,131 882 6,255 5,987 268 410 2,042 5,424 781 1,601 287 321 98 APR Totals 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 0 0 0 0 92 80 52 1210 480 330 0 0 0 JUN 0 0 0 0 45 63 45 1133 436 328 1 0 0 JUL 51 24 5 42 45 77 37 923 506 301 0 10 7 AUG 283 154 3 21 36 51 32 923 468 280 1 10 4 SEP 121 23 2 15 23 75 29 787 421 257 0 127 OCT 32 50 1 2 25 83 33 797 451 273 1 13 9 NOV 59 19 0 0 28 63 31 813 438 293 0 14 4 DEC 0 0 1 1 42 79 32 773 443 278 0 9 20 JAN 50 9 0 0 36 80 37 234 521 291 0 12 10 FEB 88 64 2 36 34 59 31 789 442 297 0 15 10 MAR 11 32 0 0 43 75 41 873 448 305 0 31 9 APR Totals FY 2021 ATTENDANCE MAY JUN JUL AUG SEP OCT NOV DEC JAN FEB MAR APR PATRON DOOR COUNT 0 0 13003131 3491 3510 3052 2600 3089 3169 3656 CURBSIDE PATRONS 471 105 72 70 76 53 49 54 55 57 NUMBER OF CHILDREN'S PROGRAMS 2 3 2 7 10 8 7 9 6 8 9 CHILDREN'S ROGRAM ATTENDANCE 25 8 20 36 32 121 90 136 39 52 104 NUMBER OF CHILDREN'S PASSIVE PROGRAMS 5 5 10 12 9 10 14 10 16 12 12 CHILDREN'S PASSIVE PROGRAM ATTENDANCE 803 676 843 680 556 460 437 186 796 444 706 NUMBER OF YA PROGRAMS 1 1 1 3 2 3 3 4 4 YA PROGRAM ATTENDANCE 1 1 4 23 10 7 20 49 13 NUMBER OF YA PASSIVE PROGRAMS 1 1 1 1 1 2 1 2 2 YA PASSIVE PROGRAM ATTENDANCE 4 1 0 0 0 20 15 3 16 YOUTH SUMMER/WINTER READING 72 32 NUMBER OF ADULT PROGRAMS 4 4 4 4 4 4 5 5 6 4 5 ADULT PROGRAM ATTENDANCE 46 46 46 45 43 43 40 73 90 30 68 NUMBER OF ADULT PASSIVE PROGRAMS 2 1 ADULT PASSIVE PROGRAM ATTENDANCE 58 18 ADULT SUMMER/WINTER READING 33 38 YOUTH COMPUTER SESSIONS 22 17 33 78 18 18 70 9 16 ADULT COMPUTER SESSIONS140 201 170 217 169 169 230 183 264 FRIENDS VOLUNTEER HOURS 13 10 31 13 19 48 40 30 50 IPLAR NOTES:COUNT LIVE VIRTUAL PROGRAMS AS PROGRAM ATTENDANCE COUNT VIEWS OF RECORDED VIRTUAL PROGRAMS AS PASSIVE PROGRAM ATTENDANCE Umbrella Technologies 4-7-20212:00 pm I spoke with Thomas Carneval on the phone after I emailed him asking if they would come and explain why the installation did not go as planned. He was very agitated that I even ask them to take their own time to come do that. He said "You can't expect us to know until they take things apart in an at the end- of-life unsupported system what they will find."Tech found that readers were proprietary after he took one off. He will not negotiate at all and would not come down on price for any of it. He said the Weigland reader is as low as they can go and it will do the job. Later his email below: Wed 4/7/20212:56 PM Dixie, Here is a written overview of the legacy access control system. Reader Issue Explanation So going into the installation we were under the understanding that all the current readers were standard Weigand readers. The Weigand format is understood as to mean the standard 26-bit format, which is a very specific arrangement of binary card data. This format describes what a number means, or how a number is used for each credential. This is the most commonly used format for older access control systems. There was no way to determine this prior to the installation. The current readers are non-standard programable readers that can be programmed to different formats either will a programing card or through the software. Both of which we have had no access to prior to installation. Due to the readers being programmed to the old access control system in a different format the new system is not receiving all the required information from the credential. Your existing system is end-of-life and has no method of programming the readers to any new format. Currently, the new system (OpenPath) is only receiving the first 14-bits of the 26-bit code on the credentials. Due to this issue in order to achieve the proper system functionality, we will need to replace the existing readers because we have no way to reprogram the current readers. The Openpath system can work with any standard reader and can use a wide range of credentials because it has the ability to change the card format when programming the credentials. Thomas Carnevale Subject: Openpath Readers quote and Differences Features Weigand Reader Openpath Reader Unlock Beeper X X Indoor/Outdoor rated X X Small Form Factor X X Compatible With Current Fobs X X Status Indicator LED X Bluetooth Unlocking X Touchless Wave to Unlock X Software Statistics X Software Controles X ESTIMATE tmbrella Umbrella Technologies 120 Gale Street I E C H N 0 L 0 G I ES Suite Aurora, Illinois 60504 United States (888)819-4211 www.umbrellatech.co BILL TO Estimate Number: Yorkville Public Yorkville Public Library Library Card Reader Dixie DeBord Replacement. 902Game Farm Rd Yorkville, Illinois 60560 Estimate Date: April 1, 2021 United States Expires On: April 1, 2021 630-553-4354; 104 Dldebord@yorkville.lib.il.us Grand Total (USD): $3,200.00 Items Quantity Price Amount UMB-CR 10 $170.00 $1,700.00 Small sized, low cost reader features a beeper and multicolor LED which can be host and/or locally controlled. Potted reader suitable for indoor or outdoor use. Designed for mounting directly onto metal with no change in read range performance. Available with either Wiegand or Clock-and-Data (magnetic stripe data)output. Compatible with all standard access control systems. Aesthetic design available in two cover designs and in four colors to match any decor. Includes multilingual installation manual. UMB-SOW 1 $1,500.00 $1,500.00 Installation, configuration, wiring, testing and trouble-shooting. Includes training and engineering of the system. Including Cat5e cabling, and all installation materials required per defined scope-of- work. Total: $3,200.00 Grand Total (USD): $3,200.00 ESTIMATE Umbrella Technologies tmbrella 120 Gale Street T E C H N 0 L 0 G I ES Suite Aurora, Illinois 60504 United States (888)819-4211 www.umbrellatech.co BILL TO Estimate Number: Yorkville Public Yorkville Public Library Library Openpath Dixie DeBord Card Reader 902Game Farm Rd Replacement Yorkville, Illinois 60560 United States Estimate Date: April 2, 2021 630-553-4354; 104 Expires On: April 2, 2021 Dldebord@yorkviIle.Iib.il.us Grand Total(USD): $4,000.00 Items Quantity Price Amount UMB-OP-RHF-MULB 10 $250.00 $2,500.00 High Frequency Mullion Smart Reader UMB-SOW 1 $1,500.00 $1,500.00 Installation, configuration, wiring, testing and trouble-shooting. Includes training and engineering of the system. Including Cat5e cabling, and all installation materials required per defined scope-of- work. Total: $4,000.00 Grand Total(USD): $4,000.00 M E T R NET Business Services Agreement Customer Yorkville Public Library Date 3/22/2021 Sub I.D. Sales Rep Dard Moore Physical Address 902 Game Farm Road,Yorkville,IL 60560 Referred by: tmlude CIN.5T.LP Billing Address 902 Game Farm Road,Yorkville.IL 60560 Requested due: -JL3�L Prima Contact Russ Walter.Board - = _ Primary Trustee Phone: (630)2.403240 Email: russ.walterayorkville.lib.iLus On Site Contact Russ Walter.Board Trustee Phone: (630)240-3240 Email: russ.walter(Myorkviile.lib.il.us Confact(s)with purchase Phone: Email: aulhorizalion Phone:_ Email: Network Vendor Phone: Email: Account Payable Phone: Email: Business Fiber Internet Speed Term Non-Recurring F ecurring Bandwidth Speed I Gbps/1 Gbps 36monlhs 50.00 5249.95 DHCP or Static QuanfRy Non-Recurring Recurring IP Address Static 1 $0.00 included YOTAL Monthly Service Costs(plus ra■as and1...) $249.95 Non-Retuning 60.00 Installation Cost so.00 By signing below,Customer makes the following representations and warranties to MetroNel: (i)the undersigned is authorized to sign this Business Order Form and otherwise bind the Customer: fill the undersigned has had an opportunity to read and review the Agreement,as that term is defined in the terms and conditions listed on the MetroNel website at hltas://business.metronelinc.comlterms-condilion s and agrees to abide by all of the terms and conditions contained in the Agreement and those terms that ore specific to any service being purchased by Customer as specified In the above Business Order Form. This Business Order Form is hereby incorporated by reference into the Agreement. Authorized Signer Name(printed): Russell WallerLL Signature: -- Title: Board Trustee Date: v.3.3.20_ M ETR ON ET statement of work Business Name: Yorkville Public Library Physical Address: 902 Game Farm Road,Yorkville,IL 60560 Explanation of work to bedone,Install 1 Gbps/1 Gbps Business Fiber Internet service with one(1)Static IP address.This is an E-Rate order.The Yorkville Public Library's current contract with Comcast does not expire until August 81h,2021,so the library would like to wait until the week of August 1 st,2021 to have internet service installed and billing begin,If MetroNet chooses to install internet service before August 1st,service should be provided at no charge until August 1st.Billing should not begin until August 1st,at the earliest. Is this a Complex Order(Y/N) N It Complex Order was Sales Engineering Engaged(Y/N) N Day of Service Installation MetroNet will assign an installation dote for your Fiber Services.On the Installation Date you will experience service down time due to factors outside of our control. In some cases this may mean you may not have phone or computer service for several hours. Such downtime is unavoidable but,we will use commercially reasonable efforts to minimize the inconvenience you. DMARC(ONT) When an ONT/fiber drop is installed MetroNet is responsible for service up to the DMARC(ONT).Anything beyond the DMARC is the customer's internal network and the business owner's financial responsibility to contact an IT vendor for support and/or repairs. Customer Phone Vendor/Cut Sheet Customer designates Not applicable-no phone service being sold ("Phone Vendor") to be responsible for maintaining the internal phone systems on behalf of Customer.Phone Vendor will be responsible for locating all lines prior 10 the Installation Date provided by MetroNet and will be responsible for connecting Customer's internal phone system to MelroNet's demarcation point. Phone Vendor must be present on the Installation Date at the designated time.Customer will be responsible for scheduling the Phone Vendor on the Installation Date and shall pay all expenses associated wllh the Phone Vendor. MetroNet will provide Customer with a document detailing the lines/circuits to be installed for the benefit of the Phone Vendor("Cut Sheet''). Changes Customer understands that any changes made to the SOW or Fiber Services,including but not limited to database information,after execution of this SOW may result in the assignment of a new Installation Date by Company at its standard intervals or otherwise delay the provisioning of the Fiber Services to you. This SOW is hereby Incorporated by reference Into the Agreement between Customer and MetroNet,as that term is defined In the terms and conditions to the Business Order Form.Any captlalized terms not defined herein shall have the some meanings as ascribed to them In the Agreement. Authorized Signer Name(Printed): Russell Walter Signature: i Title: Board Trustee Dale: 3 G.p-? v,3.3.30 M E T R N E T Authorization Date: 3/9/2021 Sales Rep: Darci Moore Customer Yorkville Public Library Sub I.D. Billing Address 902 Game Form Road.,Yorkville,IL 60560 The Primary Contact and Additional Authorized Coniocts listed below,have oulhorization to act on this account(e.g.make billing changes,request changes and upgrades in service/equipment,cancel service,make address changes,request and provide account information,give and accept notices.etc.)whether such action is taken by telephone,electronically or other manner. In the event the Primary Contact or an Addilional Authorized Contact ceases to be authorized or a new individual becomes authorized,it is the responsibility of the Pdmory Contact(or an Additional Authorized Contact in the event of a change in Primary Contact)to provide MetroNet written notice of such change.MelroNel may.but shall have no obligation to,verify authorizations or the ideniily of the authorizer. Primary Contact Title Phone Email Russ Walter Board Trustee (630(240-3240 russ.waller@vorkville.Iib.it us Onsite Contact Title Phone Email Russ Walter Board Trustee (630)240-3240 russ.vvalterCaworkville Iib it us Contact to Receive MetroNet Text Alerts Title Phone Email Accounts Payable THIe Phone Email Additional Authorized Contacts THIe Phone Email Darren Crawford Board President (630)553.4354 darren.crawforda-vorkville Iib it its The undersigned represents and warrants to MclroNcl that he/she is authorized to sign this Authorization on behalf of Cuslorner. Aulhorized by Primary(printed): Russell Walter Signalure: Title: Board Trustee Dale: 3 — 2-3, v.3.3.20 Applicant Name: Yorkville Public Library BEN: 135742 FCC Form 470# 210024114 FY: 2021 Allowable Contract Date(ACD): 3/21/21 If BIDs• 2 and 6 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. Applicants must 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 M-T-M 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. S. Price Rating is based on a weighted scale of 40 points;All other Criteria rated objectively from high to low bid for total points available. Type of Service Briefly Describe Service(s) x Internet Access(IA) Fiber Dedicated Leased Lit Fiber Symmetrical 100;250;500 Mbps Internal Connections(IC) Leased Coax(Business Fiber)-150/25;300/25;500/35;and 1Gbps/35 Basic Maintenance(BMIC) Managed Internal Broadband(MIB) Other - -- --- Service Provider/Bidder ANNUAL %to Lowest Meeting Vendor's For Comparison: Cost of Services bid(low bid Weighted Experience Local Ln cost/bid Cost Needs Overall with Entity Rate Ability a Presence Total Paints Used 36-month Term ($) Winning Bid cost) (v) Points Available 40 20 20 10 10 100 1 Business Fiber-Used iGbps 2 Metronet $ 2,999.40 1.000 40.00 10.00 0.00 10.00 10.00 70.00 3 Comcast $ 5,999.40 0.500 20.00 10.00 20.00 10.00 8.00 68.00 4 5 Fiber-Used 300Mbps for Comparison - 6 Metronet $ 5,400.00 1.000 40.00 20.00 0.00 10.00 9.00 79.00 7 Comcast $ 7,140.00 0.756 30.25 15.00 15.00 10.00 6.00 76.25 8 AT&T $ 7,892.40 0.684 40.00 20.00 0.00 10.00 10.00 80.00 9 Cytranet $ 8,691.36 0.621 24.85 15.00 0.00 10.00 4.00 53.85 10 Huntleigh $ 12,564.00 0.430 17.19 15.00 0.00 10.00 2.00 44.19 11 Proficient $ 11,508.00 0.469 18.77 15.00 0.00 1 10.00 1 5.00 48.77 Price Rating:Based on a Weighted Cost of 40 points All Other Ratings:rate from 0=Poorest;to total points available=Best Approved By-Name: Title Date of Review Russ Walter Trustee 3/22/2021 Date of Review-the review of bids must be conducted after the Allowable Contract Date(ACD) Notes: Applicant's Zip-60560 Cytranet,Term:not specified,amortized NRC$550.00 over 36 months,added$15.28 to total;Zip 36609-759.28 miles AT&T,Term:36&60-month;NRC 0.00;Zip 60560-0.0.miles Comcast,Non-Fiber Term:12-month;quoted 200/20 in lieu of 150/25;300/30 in lieu of 300/25;600/35 in lieu of 500/35;add $19.95/24.95 for 1 or 5 Static IP:DIA Symmetrical,quote 200 in lieu of 250Mbps;IPV4 blocks from$20 to$200/month,used min for cost comparison,added to monthly quotes;also included additional service,e.g.managed router,etc.;Zip 60643-40.25 miles Metronet,Term:36 and 60-month,ALL symmetrical;quoted 200 in lieu of 250;Zip 60543-5.77 miles MetroNet,"Best Svc"asymmetrical does not include a dedicated line or Service Level Agreement,100 in lieu of 150; 200 in lieu of 300;Zip 60543-5.77 miles Huntleigh,Term:24,36,60-month;quoted 200 in lieu of 100 mbps,reflected in Meeting Overall Needs;amortized Quoted Monthly Cost Per Bandwidth Speed NRC$250.00 over 36 months,added$7.00 to total;Zip 79901- 1,230.72 miles Proficient,Term:36-month;quoted 150 in lieu of 100 Mbps.;Zip 64112- 370.8 miles Bidder Date 150/25 300/25 500/35 1000/35 NRC 1 Non-Fiber i 2 Comcast 3/1/21 259.95 349.95 359.95 i 499.95 i - 3 (Metronet - 3/9/21 - --99.95 129.95 199.95 249.95 4 ;Metronet-Business Fiber. 3/22/21 249.95 5 Bidder Date 100 250 500 r 1000 NRC 6 ': Fiber i 7 �C ranet 2/21/21 � 709.00 i 1,065.00 �--- � ----- --'-----�--- ---- -- _ _ j 1,368.00 I i 550.00 8 AT&T 2/23/21 ' 657.70 873.60 1,205.50 9 Metronet 3/8/21 450.00 -550.00 750.00 1,050.00 10(Comcast 3/18/21 595.00 '820.00 970.00 11 (Huntleigh 3/19/21 1,040.00 ; 1,215.00 1,390.00 250.00 i I 12 iProficient 3/12/21 ; 959.00 i 1,369.00 11,669.00 ' Quoted 200 in lieu of 250 TF cc C; (it LIl 716 N. Bridge Street Yorkville, IL 60560 630.453.8726 April 5, 2021 Proposal of Services Yorkville Library, Thank you for taking time to sit down and talking about your phone needs. I believe our Hosted Phone System offered below can meet and it exceed your needs. Below I have prepared an aggressive quote for the Library, please review it and let me know if I missed anything. Feel free to reach out and ask questions. I hope to hear from you soon. Thank you, Jeff Norris TCG Solutions Inc. 630-453-8726 Hosted VoIP Phone System TCG Solutions will provide 19 Phones and include unlimited calling in the 48 continues states. All Phones and equipment are considered rented equipment. TCG will replace any equipment that fails during normal use, at no expense to the Library.TCG will charge for damaged or abused equipment. TCG holds at least 1 Spare part of each piece of equipment listed. All services will be charged at the beginning of each month for that month's service. Long Distance Service is considered any calls to numbers outside the 48 contiguous states, this service can be enabled but is disabled by default. 900#'s are blocked. This is a 36-month agreement. Upstream Provider is Inteloquent one of the largest Phone companies in the U.S. 911 Services—Upon install TCG will test 911 Services and will configure the phone system with the Library's address. Call Recordings—TCG Reserves the right to record inbound and outbound calls to improve call quality. 5 Phones for Managers and office staff($30.00/Each) $150.00/Month Features Transfer calls Voice Mail 3 Way Calls 6 Lines 24 Dual-Color BLF Extension Keys PoE, Bluetooth, USB, EHS with Plantronics Headsets 3 Cordless Phones ($30.00/Each $90.00/Month Features Transfer calls Voice Mail Dual-band Wi-Fi with efficient antenna design and advanced roaming support 2 Lines (SIP Accounts) HD voice &dual MIC design with AEC and Noise Shield Technology Rechargeable 1500mAh battery, 6 hours talk time, 120-hour standby. Configurable button for push-to-talk Micro USB port and 3.5mm headset jack 11 Basic Phones ($25.00/Each) $275.00/Month Features Transfer calls Voice Mail 2 Lines (SIP Accounts) 1 Elevator Line ($20.00) $20.00/Month Connects Elevator to 911 Services (stands alone). 1 Sip to PA Adapter ($30.00/Each) $30.00/Month Connects Phone system to PA system. 24 Port PoE Managed Switch $25.00/Month Features Powers all VolP Phones VLAN Capable Managed by TCG Solutions Total Monthly Bill $590.00/Month The total does not reflect taxes, and 911 Fees. Discount for a Neighbor -$90.00/Month TCG Solutions is offering the Library a discount as a friend and a neighbor of the Library. MonthlV Bill $500.00/Month Taxes and 911 Fees Not included. Install Fee $1,000.00 This includes installing 19 Phones, 1 PA Bridge, 1 PoE 24 Port Switch. TCG will work with the Library to setup a proper install date along with 4 Hours of onsite training. Onsite training can be split into 2 visits. FY 2019 FY 2020 FY 2021 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 FY 2026 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Library Operations 82-00040-00-4000 PROPERTY TAXES-LIBRARY OPS $ 669,065 $ 702,716 $ 739,047 $ 736,883 82-000-40-004083 PROPERTY TAXES-DEBT SERVICE 788,022 794,715 822,953 824,640 836,024 843,076 862,416 859,680 82-00041-004120 PERSONAL PROPERTY TAX 5,353 5,860 5,250 5,250 5,250 5,250 5,250 5,250 5,250 82-000-41-004160 FEDERAL GRANTS - - - 500 - - 82-00041-00.4170 STATE GRANTS 25,211 21,151 20,000 21,151 21,151 21,151 21,151 21,151 21,151 82-000-43-00-4330 LIBRARYFINES 9,234 7,552 8,500 3,500 8,500 8,500 8,500 8,500 8,500 82-00044-004401 LIBRARY SUBSCRIPTION CARDS 9,185 7,558 8,500 4,250 8,500 8,500 8,500 8,500 8,500 82-000.44-00.4422 COPY FEES 3,980 3,582 3,800 1,750 3,800 3,900 3,900 3,900 3,900 82-000-44-00-4439 PROGRAM FEES 301 64 _ 82-00045-004500 INVESTMENT EARNINGS 11,463 12,589 8,959 1,500 2,000 3,000 8,000 10,000 100,000 82-00045-00-4550 GAIN ON INVESTMENT - 3,882 82-00048-004820 RENTAL INCOME 2,633 1,400 1,750 - 1,750 1,750 1,750 1,750 1,750 82-00048-00-4850 MISCELLANEOUS INCOME 830 2,974 2,000 500 2,000 2,000 2,000 2,000 2,000 82-00049-00-4901 TRANSFER FROM GENERAL 23,495 24,388 26,584 25,522 26,993 28,553 30,206 31,958 33,815 Revenue S 1,548,772 $ 1,588,431 $ 1,647,343 $ 1,625,446 S 1,692,702 S 1,725,716 $ 1,775,710 S 1,801,447 S 1,059,087 82-820-50-00-5010 SALARIES&WAGES $ 261,231 $ 275,622 $ 289,742 $ 280,000 $ 299,306 $ 306,789 $ 315,993 S 325,473 82-820-50-00-5015 PART-TIME SALARIES 165,624 166,497 190,000 160,000195,544 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 26,614 27,240 32,779 32,779 3 34,271 36,017 37,919 39,057 82-820-52-00-5214 FICA CONTRIBUTION 31,983 33,137 35,952 33,000 35,6 82-820-52-00-5216 GROUP HEALTH INSURANCE 68,695 71,184 76,764 66,215 10 117,593 127,000 137,160 148,133 82-820-52-00-5222 GROUP LIFE INSURANCE 351 362 387 328 395 399 403 407 82-820-52-00-5223 DENTALINSURANCE 6,699 6,987 6,322 5,977 7,715 8,101 8,506 8,931 82-820-52-00-5224 VISION INSURANCE 973 1,012 1,012 974 1,162 1,197 1,233 1,270 82-820-52-00-5230 UNEMPLOYMENT INSURANCE 604 849 750 1,000 1,000 1,000 1,000 1,000 1,000 82-820-52-00-5231 LIABILITY INSURANCE 22,891 23,539 25,834 24,522 25,993 27,553 29,206 30,958 32,815 82-820-54-00-5412 TRAINING&CONFERENCES 1,374 486 3,000 1,000 3,000 3,000 3,000 3,000 3,000 82-820-54-00-5415 TRAVEL&LODGING 1,557 1,834 1,500 - 1,500 1,500 1,500 1,500 1,500 82-820-54-00-5426 PUBLISHING&ADVERTISING 3,019 825 2,500 2,500 2,500 2,500 2,500 2,500 2,500 82-820-54-00-5440 TELECOMMUNICATIONS 5,313 4,524 7,200 7,200 7,200 7,200 7,200 . 7,200 7,200 82-820-54-00-5452 POSTAGE&SHIPPING 655 483 750 750 750 750 750 750 750 82-820-54-00-5460 DUES&SUBSCRIPTIONS 9,602 9,755 11,000 11,000 11,000 11,000 11,000 11,000 11,000 82-820-54-00-5462 PROFESSIONAL SERVICES 24,213 29,445 40,000 40,000 40,000 40,000 40,000 40,000 40,000 82-820-54-00-5466 LEGAL SERVICES 2,205 630 3,000 4,162 3,000 3,000 3,000 3,000 3,000 82-820-54-00-5468 AUTOMATION 13,854 15,603 20,000 20,000 20,000 20,000 20,000 20,000 20,000 82-820-54-00-5480 UTILITIES 11,973 10,992 11,798 11,652 12,351 13,092 13,878 14,711 15,594 FY 2019 FY 2020 FY 2021 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 FY 2026 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected 82-820-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 28,900 61,034 50,000 50,000 50,000 50,000 50,000 50,000 50,000 82-820-54-00-5498 PAYING AGENT FEES 1,689 1,689 1,700 1,689 1,700 1,700 1,700 1,700 - 82-820-56-00-5610 OFFICE SUPPLIES 7,147 8,408 8,000 8,000 8,000 8,000 8,000 8,000 8,000 82-820-56-00-5620 LIBRARY OPERATING SUPPLIES 3,821 3,325 4,000 4,000 4,000 4,000 4,000 4,000 4,000 82-820-56-00-5621 CUSTODIAL SUPPLIES 4,215 9,695 7,000 9,500 7,000 7,000 7,000 7,000 7,000 82-820-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 1,199 - 2,000 1,000 2,000 2,000 2,000 2,000 2,000 82-820-56-00-5671 LIBRARY PROGRAMMING 1,737 1,022 2,000 2,000 2,000 2,000 2,000 2,000 2,000 82-820-56-00-5676 EMPLOYEE RECOGNITION 247 200 300 300 300 300 300 300 300 82-820-56-00-5685 DVD'S 56 - 500 500 500 500 500 500 500 82-820-56-00-5686 BOOKS 4,315 704 1,500 1,500 1;500 1,500 1,500 1,500 1,500 Debt Service-2006 Bond 82-820-84-00.8000 PRINCIPAL PAYMENT 50,000 50,000 75,000 75,000 75,000 75,000 100,000 100,000 - 82-820-84-00-8050 INTEREST PAYMENT 24,988 22,613 20,238 20,238 16,675 13,113 9,550 4,800 Debt Service-2013 Refunding Bond 82-820-99-00-8000 PRINCIPAL PAYMENT 565,000 585,000 610,000 610,000 645,000 675,000 700,000 730,000 - 82-820-99-00-8050 INTEREST PAYMENT 152,113 139,400 121,850 121,850 103,550 84,200 57,200 29,200 Expenditures $ 1,504,857 S 1,564,096 S 1,664,378 $ 1,608,636 S 1,709,443 $ 1,761,555 S 1,816,003 S 1,851,550 $ 1,023,181 Surplus(Deficit) 43,915 24,335 (17,035) 16,810 (16,741) (35,839 (40,293) (50,103) 35,906 Fund Balance S 554,271 S 578,607 $ 557,653 $ 595,417 S 578,676 S 542,837 S 502,544 S 452,441 S 488,347 36.83% 36.99% 33.51% 37.01% 33.85% 30.81% 17.67% 14.4.1% 47.73% Operational Fund Balance% 77.76% 75.43% 66.60% 76.18% 66.57% 59.38% 5294% 45.81% 47.73% FY 2019 FY 2020 FY 2021 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 FY 2026 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Library Capital 84-00042-004214 DEVELOPMENT FEES $ 103,100 $ 110,775 $ 50,000 $ 105,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000 84-00045-00-4500 INVESTMENT EARNINGS 257 658 500 150 200 250 250 250 250 84-000-48-004850 MISCELLANEOUS INCOME 1,835 (1,780) Revenue $ 105,192 $ 109,653 $ 509500 $ 105,150 $ 50,200 $ 50,250 $ 50,250 $ 50,250 $ 50,250 84-840-54-00-5460 E-BOOKS SUBSCRIPTION $ 3,213 $ 3,000 $ 3,500 $ 3,500 $ 3,500 $ 3,500 $ 3,500 $ 3,500 $ 3,500 84-840-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 14,897 5,392 15,000 15,000 15,000 15,000 15,000 15,000 15,000 84-840-56-00-5683 AUDIO BOOKS 3,877 3,550 3,500 3,500 3,500 3,500 3,500 3,500 3,500 84-840-56-00-5684 COMPACT DISCS&OTHER MUSIC 290 769 500 500 500 500 500 500 500 84-840-56-00-5685 DVD'S 3,425 2,585 3,000 3,000 3,000 3,000 3,000 3,000 3,000 84-840-56-00-5686 BOOKS 54,673 54,034 50,000 50,000 50,000 50,000 50,000 50,000 25,910 84-840-56-00-5686 BUILDING IMPROVEMENTS - - Expenditures S 80,375 S 69,330 $ 75,500 $ 75,500 S 95,500 $ 75,500 $ 75,500 $ 75,500 $ 51,410 Surplus(Deficit) 24,817 40,323 (25,000) 29,650 (45,300) (25,250) (25,250) (25,250) (1,160) Fund Balance S 83,260 S 123,583 S 104,485 S 153,233 $ 107,933 $ 82,683 $ 57,433 $ 32,183 $ 31,023 FY 2019 FY 2020 FY 2021 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 FY 2026 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Cash Flow-Surplus(Deficit) Library Ops $ 43,915 S 24,335 $ (17,035) $ 16,810 S (16,741) S (35,839) S (40,293) S (50,103) S 35,906 Library Capital 24,817 40,323 (25,000) 29,650 (45,300) (25,250) (25,250) _ (25,250) (1,160) S 68,732 S 64,658 S (42,035) S 46,460 S (62,041) S (61,089) S (65,543) S (75,353) S 34,746 Cash Flow-Fund Balance Library Ops $ 554,271 S 578,607 $ 557,653 $ 595,417 S 578,676 S 542,837 S 502,544 S 452,441 $ 488,347 Library Capital 83,260 123,583 104,485 153,233 107,933 82,683 57,433 32,183 31,023 S 637,531 S 702,190 S 662,138 S 748,650 S 686,609 S 625,520 S 559,977 S 484,624 S 519,370 RESOLUTION 01-21 ANNUAL RESOLUTION AUTHORIZING NON-RESIDENT LIBRARY CARDS WHEREAS, the Yorkville Public Library(the Library) is a tax-supported public library; and WHEREAS, persons residing within the jurisdictional boundaries of the Library pay taxes to support the Library; and WHEREAS, the Local Library Act(the Act)provides that the Board of Library Trustees(the Board)may allow non-residents to purchase a library card, i.e.,the Act provides the Board may extend the privileges and use of the Library, including the borrowing of materials on an individual basis by persons residing outside the Library(75 ILCS 5/4-7(12); and WHERAS, the Act stipulates that"A person residing outside of a public library service area must apply for a non-resident card at the public library located closest to the person's principal residence"; and WHEREAS, the Board has determined for its fiscal year commencing May 1,2021 and ending April 30, 2022 to participate in the non-resident reciprocal borrowing program of its regional library system and to issue non-resident library cards. NOW, THEREFORE, be it and it is hereby resolved by the Board as follows: Section 1: Individuals residing beyond the jurisdictional boundaries of the Library and owning no taxable property within the jurisdictional boundaries of the Library may purchase a non-resident fee card for the price calculated according to the"Tax Bill Method"(see 23 Ad. Code 3050.60(b)). Section 2: Individuals residing beyond the jurisdictional boundaries of the Library but owning or leasing property that is taxed for library service (as an individual, a partner,the principal stockholder, or other joint owner)within the jurisdictional boundaries of the Library, or serving as a senior administrative officer of a firm, business or other corporation owning taxable property within the jurisdictional boundaries of the Library may obtain a non-resident library card without payment of the non-resident fee upon presentation of the most recent tax bill upon that taxable property or a copy of the commercial lease of that taxable property. Each non-resident library card issued pursuant to this Section is limited to the exclusive use of the individual whose name appears on its face. Section 3: The Library shall notify the regional library system of this Resolution within 30 days of the adoption of this Resolution. Section 4: A valid non-resident library card issued by the Library pursuant to this Resolution shall afford a non-resident library cardholder all the services which the Library affords its residents, including reciprocal borrowing privileges. Section 5: This Resolution is effective upon its adoption. ADOPTED April 12, 2021 by a roll call vote as follows: AYES: NAYS: ABSENT: President Board of Library Trustees Yorkville Public Library ATTEST: Secretary Board of Library Trustees Yorkville Public Library