Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Library Packet 2018 04-09-18
Agenda Yorkville Public Library Michelle Pfister Meeting Room Board of Trustees April 9, 2018 - 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 12. Unfinished Business Approve Budget for 2018/2019 13. New Business Public Notice Participants in Public Act 92 - 1066 Non-Resident Fee Card 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 public body to determine its validity. 15. Adjournment DRAFT Yorkville Public Library Board of Trustees Monday, March 12, 2018, 7:00pm 902 Game Farm Road – Michelle Pfister Meeting Room The meeting was called to order at 7:03pm by President Russ Walter, roll was called and a quorum was established. Roll Call: Susan Chacon-present, Darren Crawford-present, Krista Danis-present, Theron Garcia- present, Jason Hedman-present, Carol LaChance-present, Wamecca Rodriquez-present, Russ Walter- present Others Present: Library Director Elisa Topper, Director of Adult Services Shelley Augustine, Circulation Manager Sharyl Iwanski, Youth Director Marianne Eberhardt, Alderman Chris Funkhouser Recognition of Visitors: President Walter recognized the library staff and guest. Amendments to the Agenda: President Walter said the 5K race would be removed from the agenda since it will not be held this year. Minutes: February 12, 2018 Ms. LaChance moved and Ms. Garcia seconded the motion to approve the minutes as presented. Approved unanimously by voice vote. Correspondence: Board members received Statement of Economic Interest letters from the County and Mr. Walter reminded all to complete and turn them in by May. Ms. Topper said she received an email from a patron commending Customer Service in Circulation. Public Comment: None Staff Comment: Ms. Augustine reported a patron wished to donate Catholic Worker magazine. Ms. Augustine told her the library budget does not allow for purchase of other religious magazines to represent all religions fairly. The patron responded with a positive letter. Ms. Topper said that new “religious fiction” labels have been placed on the appropriate books. Report of the Treasurer: Ms. Chacon presented the report. She said the budget is where it is expected to be at this time and noted that Repairs and Maintenance continues to be over-budget. The library received 207.5% of Page 1 of 3 development fees. A $200 reduction was given on the recently replaced fire panel, said Ms. Topper. Mr. Hedman reminded the Board that the fire panel expense should be reclassed to development fees and Ms. Topper will notify the city to make this change. Payment of Bills A motion was made and seconded by Trustees Hedman and LaChance, respectively, to pay the bills as follows: $23,077 Accounts Payable $36,022 Payroll $59,099 TOTAL Roll call: Walter-yes, Chacon-yes, Crawford-yes, Danis-yes, Garcia-yes, Hedman-yes, LaChance-yes, Rodriguez-yes. Motion carried 8-0 Report of the Library Director: 1. Ms. Augustine made a You Tube video of the mini golf event 2. Ms. Topper attended a quarterly meeting of library facility managers, which will share a network of people who can provide information on vendors who overcharge. 3. New fire panel installed at cost of $4,000, also did inspection 4. Elevator inspection to be set up for next month 5. Ongoing hot water issue in new part of building, water is brown and has odor. A patron/engineer suggested a solution of raising the water heater temperature and some improvement has been noticed. Disassembly and bleaching may also be needed 6. Repair was made to sink 7. Library was recently short-staffed so Ms. Topper filled in, she will also be on the April Sunday rotation. City Council Liaison No report Standing Committees: To be discussed under New Business. Unfinished Business: Update on the Inter-governmental Agreement Ms. Topper said the Administration Committee will meet next week to discuss the agreement and she will contact Mr. Olson for an update. Mr. Walter reported that he advised Tim Evans the 5K run would not be held. A co-op fundraiser was suggested by Mr. Evans for a future city event with possible dates of Fourth of July or Hometown Days. Mr. Evans will contact library staff regarding space needs. Update on Parking Lot Lights/Plumbing Issues The city has repaired the light, but parts are on order for a remaining flickering issue. Ms. Topper sent Mr. Olson an email to ask if the city will charge for this repair so it can be budgeted. New Library Cards The new library cards were presented; white cards for residents and blue for non-residents. The Library will be marketing the cards to the Bristol area. Ms. Topper thanked staff members and Sharyl for help with the new design. New scanners will be needed to read the cards. Ms. Iwanski noted that there are smaller cards for key chains for convenience. The cost for cards was $800. Page 2 of 3 New Business: Approve ALA Conference-June 2018 Ms. Topper requested approval to attend the ALA conference in New Orleans. She said free books are given out, there is a technology exhibit and she was asked to be a panel participant for role-playing. She reported on the airfare and other costs and said she would keep costs as low as possible. She spoke with Rob Fredrickson about bridging the expenses over 2 years. Additional money was requested for this line item so that other staff members can attend conferences as well. Mr. Hedman said it's important for staff to learn and grow and made a motion to approve Ms. Topper 's attendance at the annual 2018 conference. He also asked for a summary of the conference and said registration should be done now to save money. Mr. Crawford seconded the motion and roll was called. Crawford-yes, Danis-yes, Garcia-yes, Hedman-yes, LaChance-yes, Rodriguez-yes, Walter-yes, Chacon-yes. Motion carried 8-0. Approve Budget for 2018/2019 The Board reviewed the changes made to the budget. Increases in the budget were made for Training & Conferences, Publishing and Advertising, library card revenue, employee recognition, legal services and Repairs/Maintenance were split. Ms. Chacon said this year's budget will come in under the projected deficit amount. President Walter reminded the Board that development fees and the Friend's Group have greatly helped with expenses. A revised budget will be brought to the April Board meeting for approval. There was also discussion regarding the ALA conference expenses and spreading the cost over two budgets. Executive Session: At approximately 7:48pm, Ms. Garcia made a motion to move into Executive Session 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 public body to determine its validity. Ms. Chacon seconded the motion. Roll call: Danis-yes, Garcia-yes, Hedman-yes, LaChance-yes, Rodriguez-yes, Walter-yes, Chacon- yes, Crawford-yes. Motion carried 8-0 The Session concluded at 8:04pm on a motion by Ms. Chacon and second by Ms. Rodriguez. New Business cont. Following the Executive Session, the Board scheduled a strategic planning meeting on Tuesday, April 10th from 6-8pm. Additional Business: None Adjournment: There was no further business and the meeting adjourned at 8:06pm on a motion by Ms. Garcia and second by Ms. Rodriguez. Minutes respectfully submitted by Marlys Young, Minute Taker Page 3 of 3 March YTD % of FY 2018 Actual Actual Budget Budget YTD Actual % Change LIBRARY OPERATIONS FUND (82) Revenues Property Taxes -$ 644,025$ 99.7% 645,867$ 626,183$ 2.85% Intergovernmental Personal Property Replacement Tax 505 3,759 71.6% 5,250 4,475 -15.99% State Grants - - 0.0% 17,200 13,044 -100.00% Total Intergovernmental 505$ 3,759$ 16.7% 22,450$ 17,518$ -78.54% Library Fines 496$ 8,385$ 104.8% 8,000$ 6,834$ 22.69% Charges for Services Library Subscription Cards 180$ 7,283$ 112.0% 6,500$ 5,518$ 31.98% Copy Fees 465 3,483 139.3% 2,500 2,408 44.65% Program Fees 49 812 81.2% 1,000 848 -4.27% Total Charges for Services 694$ 11,578$ 115.8% 10,000$ 8,774$ 31.96% Investment Earnings 602$ 2,796$ 349.5% 800$ 883$ 216.67% Reimbursements/Miscellaneous/Transfers In Miscellaneous Reimbursements -$ 691$ 0.0% -$ 2,141$ 0.00% Rental Income 150 1,674 83.7% 2,000 2,050 -18.34% DVD Rental Income 230 2,596 103.8% 2,500 2,260 -25.32% Miscellaneous Income 18.00 1,688.02 168.8% 1,000 1,820 1206.45% Transfer In 1,754 23,775 89.9% 26,440 24,044 -1.12% Total Miscellaneous & Transfers 2,152$ 30,423$ 95.3% 31,940$ 32,314$ -5.85% Total Revenues and Transfers 4,449$ 700,966$ 97.5% 719,057$ 692,506$ 1.22% Expenditures Library Operations 52,581$ 640,787$ 79.8%803,154$ 641,999$ -0.19% 50 Salaries 30,862 369,813 81.0% 456,517 379,993 -2.68% 52 Benefits 13,292 143,149 79.2% 180,757 152,163 -5.92% 54 Contractual Services 7,796 115,901 81.7% 141,880 86,700 33.68% 56 Supplies 630 11,924 56.8% 21,000 23,143 -48.48% 99 Transfers Out - - 0.0% 3,000 - 0.00% Total Expenditures and Transfers 52,581$ 640,787$ 79.8% 803,154$ 641,999$ -0.19% Surplus(Deficit) (48,132)$ 60,179$ (84,097)$ 50,507$ *March represents 92% of fiscal year 2018 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Month Ending March 31, 2018 * Fiscal Year 2017 For the Month Ending March 31, 2017 % of Fiscal Year 8%17%25%33%42%50%58%67%75%83%92%Year-to-Date FISCAL YEAR 2018 ACCOUNT NUMBER DESCRIPTION May-17 June-17 July-17 August-17 September-17 October-17 November-17 December-17 January-18 February-18 March-18 Totals BUDGET % of Budget LIBRARY OPERATIONS REVENUES Taxes 82-000-40-00-4000 PROPERTY TAXES 52,665 272,734 10,239 23,713 265,842 11,974 6,859 - - - - 644,025 645,867 99.71% Intergovernmental 82-000-41-00-4120 PERSONAL PROPERTY TAX 909 - 930 43 - 635 - 167 570 - 505 3,759 5,250 71.60% 82-000-41-00-4170 STATE GRANTS - - - - - - - - - - - - 17,200 0.00% Fines & Forfeits 82-000-43-00-4330 LIBRARY FINES 1,289 654 1,649 604 294 515 927 292 529 1,136 496 8,385 8,000 104.81% Charges for Service 82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 698 1,340 147 531 908 627 1,206 990 176 480 180 7,283 6,500 112.05% 82-000-44-00-4422 COPY FEES 248 226 401 520 341 276 205 230 273 298 465 3,483 2,500 139.31% 82-000-44-00-4439 PROGRAM FEES 60 108 170 25 65 30 49 72 85 99 49 812 1,000 81.18% Investment Earnings 82-000-45-00-4500 INVESTMENT EARNINGS 129 137 161 169 166 184 181 196 213 198 233 1,967 800 245.81% 82-000-45-00-4550 GAIN ON INVESTMENT - - - - - - - - - 461 369 830 - 0.00% Miscellaneous 82-000-46-00-4690 REIMB-MISCELLANEOUS - - - 691 - - - - - - - 691 - 0.00% 82-000-48-00-4820 RENTAL INCOME 170 150 109 - 200 200 245 150 150 150 150 1,674 2,000 83.70% 82-000-48-00-4824 DVD RENTAL INCOME 157 221 220 438 170 246 268 147 238 261 230 2,596 2,500 103.84% 82-000-48-00-4850 MISCELLANEOUS INCOME 26 125 68 269 1,041 10 32 37 - 62 18 1,688 1,000 168.80% Other Financing Sources 82-000-49-00-4901 TRANSFER FROM GENERAL 5,448 1,820 1,820 2,049 1,820 1,197 1,820 1,328 3,606 1,113 1,754 23,775 26,440 89.92% TOTAL REVENUES: LIBRARY 61,799 277,516 15,914 29,050 270,847 15,893 11,792 3,608 5,839 4,258 4,449 700,966 719,057 97.48% LIBRARY OPERATIONS EXPENDITURES Salaries & Wages 82-820-50-00-5010 SALARIES & WAGES 16,338 36,858 12,468 12,468 12,468 16,218 16,325 24,487 16,325 16,325 16,325 196,604 223,828 87.84% 82-820-50-00-5015 PART-TIME SALARIES 15,098 23,061 14,223 14,230 13,721 14,491 14,574 21,892 11,797 15,585 14,537 173,210 232,689 74.44% Benefits 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,761 3,973 1,344 1,344 1,344 1,748 1,760 2,640 1,722 1,722 1,722 21,081 24,435 86.27% 82-820-52-00-5214 FICA CONTRIBUTION 2,339 4,527 1,989 1,990 1,951 2,297 2,304 3,484 2,100 2,390 2,310 27,680 34,263 80.79% 82-820-52-00-5216 GROUP HEALTH INSURANCE 13,349 4,104 4,808 4,617 4,418 4,796 5,690 5,434 5,524 5,608 6,986 65,334 88,996 73.41% 82-820-52-00-5222 GROUP LIFE INSURANCE 67 22 28 28 28 28 41 35 35 42 39 392 403 97.34% 82-820-52-00-5223 DENTAL INSURANCE 404 443 253 338 338 338 443 423 423 423 423 4,249 5,550 76.56% 82-820-52-00-5224 VISION INSURANCE 117 33 46 46 46 46 71 58 58 58 58 637 670 95.13% 82-820-52-00-5230 UNEMPLOYMENT INSURANCE 92 - - 229 - 229 - - - 198 - 747 1,000 74.68% 82-820-52-00-5231 LIABILITY INSURANCE 5,356 1,820 1,820 1,820 1,820 968 1,820 1,328 3,606 915 1,754 23,028 25,440 90.52% Contractual Services 82-820-54-00-5412 TRAINING & CONFERENCES - - - - - - - 112 - 46 - 158 500 31.61% 82-820-54-00-5415 TRAVEL & LODGING - - - 42 - - 115 35 - 44 - 236 600 39.28% 82-820-54-00-5426 PUBLISHING & ADVERTISING - - 100 - - - - - - - - 100 100 100.00% 82-820-54-00-5440 TELECOMMUNICATIONS - - 518 - 1,127 - - 1,463 264 - 267 3,638 6,000 60.63% 82-820-54-00-5452 POSTAGE & SHIPPING - 294 - 7 13 27 11 28 41 6 95 521 500 104.29% 82-820-54-00-5460 DUES & SUBSCRIPTIONS - 1,717 11 468 11 728 1,342 1,250 141 2,589 11 8,268 12,000 68.90% YORKVILLE PUBLIC LIBRARY FISCAL YEAR 2018 BUDGET REPORT For the Month Ending March 31, 2018 1 % of Fiscal Year 8%17%25%33%42%50%58%67%75%83%92%Year-to-Date FISCAL YEAR 2018 ACCOUNT NUMBER DESCRIPTION May-17 June-17 July-17 August-17 September-17 October-17 November-17 December-17 January-18 February-18 March-18 Totals BUDGET % of Budget YORKVILLE PUBLIC LIBRARY FISCAL YEAR 2018 BUDGET REPORT For the Month Ending March 31, 2018 82-820-54-00-5462 PROFESSIONAL SERVICES 877 3,691 1,510 5,107 1,483 942 2,465 1,952 1,515 1,311 1,992 22,845 40,000 57.11% 82-820-54-00-5466 LEGAL SERVICES - - - - - - - - - - 2,100 2,100 2,000 105.00% 82-820-54-00-5468 AUTOMATION - - - 3,147 373 3,147 - - - 3,147 - 9,814 20,000 49.07% 82-820-54-00-5480 UTILITIES - - 362 384 337 502 536 954 1,590 1,503 1,751 7,920 8,480 93.39% 82-820-54-00-5495 OUTSIDE REPAIR & MAINTENANCE 513 6,560 2,865 - 25,800 1,415 4,891 3,907 7,279 3,803 1,581 58,613 50,000 117.23% 82-820-54-00-5498 PAYING AGENT FEES - 1,100 - 589 - - - - - - - 1,689 1,700 99.32% Supplies 82-820-56-00-5610 OFFICE SUPPLIES - 302 570 392 13 1,008 104 781 394 815 326 4,706 8,000 58.82% 82-820-56-00-5620 OPERATING SUPPLIES - 1,500 96 664 - 978 - 506 - 667 149 4,559 10,000 45.59% 82-820-56-00-5671 LIBRARY PROGRAMMING - 193 23 - 32 62 95 89 44 99 155 793 1,000 79.27% 82-820-56-00-5685 DVD'S - 138 49 55 - 41 - 80 116 21 - 499 500 99.87% 82-820-56-00-5686 BOOKS - 11 - 13 - 22 - - - 1,321 - 1,367 1,500 91.11% 82-820-99-00-9983 TRANSFER TO LIB DEBT SERVICE - - - - - - - - - - - - 3,000 0.00% TOTAL FUND REVENUES 61,799 277,516 15,914 29,050 270,847 15,893 11,792 3,608 5,839 4,258 4,449 700,966 719,057 97.48% TOTAL FUND EXPENDITURES 56,311 90,348 43,082 47,976 65,323 50,031 52,586 70,938 52,974 58,637 52,581 640,787 803,154 79.78% FUND SURPLUS (DEFICIT)5,488 187,168 (27,167) (18,926) 205,525 (34,138) (40,794) (67,330) (47,135) (54,379) (48,132) 60,179 (84,097) LIBRARY DEBT SERVICE REVENUES 83-000-40-00-4000 PROPERTY TAXES 62,037 321,269 12,061 27,932 313,150 14,105 8,079 - - - - 758,634 757,396 100.16% 83-000-45-00-4500 INVESTMENT EARNINGS 0 0 2 70 227 240 275 472 476 566 23 2,352 - 0.00% 83-000-49-00-4982 TRANSFER FROM LIB OPS - - - - - - - - - - - - 3,000 0.00% TOTAL REVENUES: LIBRARY DEBT SERVICE 62,037 321,269 12,064 28,002 313,378 14,345 8,354 472 476 566 23 760,985 760,396 100.08% LIBRARY DEBT SERVICE EXPENDITURES 2006 Bond 83-830-84-00-8000 PRINCIPAL PAYMENT - - - - - - - 50,000 - - - 50,000 50,000 100.00% 83-830-84-00-8050 INTEREST PAYMENT - 13,681 - - - - - 13,681 - - - 27,363 27,363 100.00% 2013 Refunding Bond 83-830-99-00-8000 PRINCIPAL PAYMENT - - - - - - - 520,000 - - - 520,000 520,000 100.00% 83-830-99-00-8050 INTEREST PAYMENT - 81,516 - - - - - 81,516 - - - 163,033 163,033 100.00% TOTAL FUND REVENUES 62,037 321,269 12,064 28,002 313,378 14,345 8,354 472 476 566 23 760,985 760,396 100.08% TOTAL FUND EXPENDITURES - 95,198 - - - - - 665,198 - - - 760,395 760,396 100.00% FUND SURPLUS (DEFICIT)62,037 226,072 12,064 28,002 313,378 14,345 8,354 (664,726) 476 566 23 590 - LIBRARY CAPITAL REVENUES 84-000-42-00-4214 DEVELOPMENT FEES 6,150 7,000 4,200 12,650 4,700 5,600 4,350 11,575 6,250 10,150 16,409 89,034 35,000 254.38% 84-000-45-00-4500 INVESTMENT EARNINGS 1 1 1 1 1 1 1 1 1 2 2 14 10 144.20% TOTAL REVENUES: LIBRARY CAPITAL 6,151 7,001 4,201 12,651 4,701 5,601 4,351 11,576 6,251 10,152 16,411 89,048 35,010 254.35% 2 % of Fiscal Year 8%17%25%33%42%50%58%67%75%83%92%Year-to-Date FISCAL YEAR 2018 ACCOUNT NUMBER DESCRIPTION May-17 June-17 July-17 August-17 September-17 October-17 November-17 December-17 January-18 February-18 March-18 Totals BUDGET % of Budget YORKVILLE PUBLIC LIBRARY FISCAL YEAR 2018 BUDGET REPORT For the Month Ending March 31, 2018 LIBRARY CAPITAL EXPENDITURES 84-840-54-00-5460 E-BOOK SUBSCRIPTIONS - - 128 - - - 128 - - 3,128 - 3,383 3,500 96.64% 84-840-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - 862 3,894 - - - - 2,379 - - 232 7,367 15,000 49.11% 84-840-56-00-5683 AUDIO BOOKS - 1,001 150 - - - 170 177 - 45 300 1,843 - 0.00% 84-840-56-00-5684 COMPACT DISCS & OTHER MUSIC - - - - - - - 110 - - 84 194 - 0.00% 84-840-56-00-5685 DVD'S - 18 91 205 69 46 122 276 - 376 295 1,497 - 0.00% 84-840-56-00-5686 BOOKS - 2,466 2,717 2,068 2,143 3,738 3,347 4,573 452 2,449 2,777 26,731 16,500 162.00% 84-840-60-00-6020 BUILDING & STRUCTURES - - - - - - - - - - 3,970 3,970 TOTAL FUND REVENUES 6,151 7,001 4,201 12,651 4,701 5,601 4,351 11,576 6,251 10,152 16,411 89,048 35,010 254.35% TOTAL FUND EXPENDITURES - 4,347 6,979 2,273 2,212 3,784 3,767 7,515 452 5,997 7,658 41,014 35,000 117.18% FUND SURPLUS (DEFICIT)6,151 2,654 (2,778) 10,378 2,489 1,817 585 4,061 5,799 4,155 8,753 48,034 10 3 May June July August September October November December January February March April 2017 2017 2017 2017 2017 2017 2017 2017 2018 2018 2018 2018 Library Operations Old Second $ 349,886 $ 533,078 $ 504,996 $ 485,272 $ 742,421 $ 724,470 $ 693,626 $ 562,336 $ 515,309 $ 460,137 $ 410,075 Building Development Fees Old Second 20,004 21,754 21,732 23,660 34,099 35,016 36,851 33,687 33,236 45,066 51,530 Library Operations IMET * 8,837 8,837 8,837 8,837 8,837 8,837 8,837 8,837 8,837 8,376 8,007 Library Operations Illinois Funds 170,559 170,682 170,821 170,967 171,115 171,270 171,423 171,596 171,787 171,966 172,181 Total: $ 549,286 $ 734,351 $ 706,386 $ 688,736 $ 956,471 $ 939,593 $ 910,736 $ 776,456 $ 729,169 $ 685,545 $ 641,794 $ - * Restricted PAYROLL 1ST PAY PERIOD 17,692$ $ 20,595 $ 14,577 $ 14,818 $ 15,201 $ 16,196 $ 17,339 $ 17,117 $ 14,889 $ 17,734 $ 17,213 2ND PAY PERIOD 17,845 32,345 15,447 15,213 14,283 18,558 17,623 17,977 17,055 18,288 17,681 3RD PAY PERIOD - 15,479 - - - - - 17,409 - - - Total 35,537$ 68,420$ 30,024$ 30,031$ 29,484$ 34,754$ 34,962$ 52,503$ 31,944$ 36,022$ 34,894$ -$ YORKVILLE PUBLIC LIBRARY CASH STATEMENT As of March 31, 2018 FISCAL YEAR 2018 DATE: 04/04/2018 UNITED CITY OF YORKVILLE PAGE: 1TIME: 17:03:26 GENERAL LEDGER ACTIVITY REPORT F-YR: 18ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 11PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________82-000-24-00-2480 (L) ESCROW - MEMORIALS & GIFTS_____________________________________________________________________________________________________________________________________________________ 01 05/01/2017 BEGINNING BALANCE 3,077.05 GJ-170531LB 06/02/2017 08 May 2017 Deposits 300.00 _________________________________ TOTAL PERIOD 01 ACTIVITY 0.00 300.00 02 AP-170612B 06/06/2017 01 BOOKS BAKER & TAYLOR 104361 2032897995 52.18 06/06/2017 02 NAME PLATES KING & SONS MONUMENT 104364 051717 180.00 AP-170625 06/19/2017 148 AMAZON-PRINTER, PRINTER FIRST NATIONAL BANK 900046 062517-M.PFISTER 436.17 06/19/2017 149 TARGET-TARGUS CASES FIRST NATIONAL BANK 900046 062517-S.AUGUSTINE 99.98 GJ-170630LB 07/05/2017 08 June 2017 Deposits 2,675.23 _________________________________ TOTAL PERIOD 02 ACTIVITY 768.33 2,675.23 03 AP-170710 07/05/2017 01 BOOKS BAKER & TAYLOR 104377 2032916077 31.02 07/05/2017 02 BOOKS BAKER & TAYLOR 104377 2032937543 51.15 07/05/2017 03 BOOKS BAKER & TAYLOR 104377 2032944087 14.95 07/05/2017 04 BOOKS BAKER & TAYLOR 104377 2032946730 34.61 07/05/2017 05 BOOKS BAKER & TAYLOR 104377 2032960762 287.41 07/05/2017 06 BOOKS BAKER & TAYLOR 104377 2032963290 9.77 07/05/2017 07 BOOKS BAKER & TAYLOR 104377 2032970774 65.53 07/05/2017 08 07/19/17 NATURE'S ARCHITECTS FOREST PARK NATURE C 104380 071917 135.00 GJ-170731LB 08/01/2017 08 July 2017 Deposits 2.00 _________________________________ TOTAL PERIOD 03 ACTIVITY 629.44 2.00 04 AP-170814 08/09/2017 01 BOOKS BAKER & TAYLOR 104390 2032988056 212.74 08/09/2017 02 BOOKS BAKER & TAYLOR 104390 2032994518 13.80 08/09/2017 03 BOOKS BAKER & TAYLOR 104390 2033005997 74.38 08/09/2017 04 BOOKS BAKER & TAYLOR 104390 2033019466 273.87 08/09/2017 05 BOOKS BAKER & TAYLOR 104390 2033029979 143.42 08/09/2017 06 BOOKS BAKER & TAYLOR 104390 2033032006 350.87 08/09/2017 07 BOOKS BAKER & TAYLOR 104390 2033048611 112.15 08/09/2017 08 DVD MIDWEST TAPE 104396 95229398 22.99 08/09/2017 09 AUDIO BOOK MIDWEST TAPE 104396 95254126 39.99 08/09/2017 10 DVD, AUDIO BOOK MIDWEST TAPE 104396 95273332 69.98 GJ-170831LB 09/01/2017 08 August 2017 Deposits 385.00 GJ-170903RC 09/05/2017 02 RC Aug 2017 Lib Deposits 277.00 _________________________________ TOTAL PERIOD 04 ACTIVITY 1,314.19 662.00 05 AP-170911 09/06/2017 01 BOOKS BAKER & TAYLOR 104403 2033052718 24.46 09/06/2017 02 BOOKS BAKER & TAYLOR 104403 2033074220 74.42 09/06/2017 03 BOOKS BAKER & TAYLOR 104403 2033092389 86.13 09/06/2017 04 BOOKS BAKER & TAYLOR 104403 2033096069 155.34 09/06/2017 05 BOOKS BAKER & TAYLOR 104403 2033111556 110.03 09/06/2017 06 2 MEMORIAL BRICKS KING & SONS MONUMENT 104406 082317 60.00 09/06/2017 07 DVD MIDWEST TAPE 104407 95284174 14.99 09/06/2017 08 AUDIO BOOK MIDWEST TAPE 104407 95311530 39.99 09/06/2017 09 AUDIO BOOK MIDWEST TAPE 104407 95326184 39.99 09/06/2017 10 AUDIO BOOKS MIDWEST TAPE 104407 95344286 69.98 09/06/2017 11 BOKK-IT 5K TIMING RACE TIME 104410 N0902 481.81 AP-170925M 09/19/2017 165 TARGET-PRIZES FOR SUMMER FIRST NATIONAL BANK 900050 092517-J.WEISS 32.87 DATE: 04/04/2018 UNITED CITY OF YORKVILLE PAGE: 2TIME: 17:03:26 GENERAL LEDGER ACTIVITY REPORT F-YR: 18ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 11PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________82-000-24-00-2480 (L) ESCROW - MEMORIALS & GIFTS_____________________________________________________________________________________________________________________________________________________ 05 AP-170925M 09/19/2017 166 DOLLAR TREE-PRIZES FOR SUMMER FIRST NATIONAL BANK 900050 092517-J.WEISS 8.00 09/19/2017 167 TARGET-GIFT CARDS FIRST NATIONAL BANK 900050 092517-S.AUGUSTINE 50.00 09/19/2017 168 NCG CINEMA-GIFT CARDS FIRST NATIONAL BANK 900050 092517-S.AUGUSTINE 25.00 09/19/2017 169 PANERA-GIFT CARDS FIRST NATIONAL BANK 900050 092517-S.AUGUSTINE 25.00 GJ-170930LB 09/29/2017 08 Sept 2017 Deposits 330.00 _________________________________ TOTAL PERIOD 05 ACTIVITY 1,298.01 330.00 06 AP-171009 10/03/2017 01 BOOKS BAKER & TAYLOR 104415 2033127088 51.73 10/03/2017 02 BOOKS BAKER & TAYLOR 104415 2033130769 42.69 10/03/2017 03 BOOKS BAKER & TAYLOR 104415 2033131319 11.49 10/03/2017 04 BOOKS BAKER & TAYLOR 104415 2033150590 12.59 10/03/2017 05 BOOKS BAKER & TAYLOR 104415 2033160913 84.57 10/03/2017 06 BOOKS BAKER & TAYLOR 104415 2033172409 14.37 10/03/2017 07 BOOKS BAKER & TAYLOR 104415 2033175842 14.94 10/03/2017 08 AUDIO BOOKS MIDWEST TAPE 104420 95382801 39.99 10/03/2017 09 2 DVDS, 1 AUDIO BOOK MIDWEST TAPE 104420 95409502 77.97 10/03/2017 10 1 AUDIO BOOK, 1 DVD MIDWEST TAPE 104420 95430011 59.98 GJ-171031LB 11/01/2017 08 Oct 2017 Deposits 1,850.00 _________________________________ TOTAL PERIOD 06 ACTIVITY 410.32 1,850.00 07 AP-171113 11/06/2017 01 BOOKS BAKER & TAYLOR 104426 2033191873 14.95 11/06/2017 02 BOOKS BAKER & TAYLOR 104426 2033210465 14.94 11/06/2017 03 BOOK BAKER & TAYLOR 104426 2033231304 14.94 11/06/2017 04 BOOK BAKER & TAYLOR 104426 2033245448 15.53 11/06/2017 05 DVD MIDWEST TAPE 104433 95481997 22.99 11/06/2017 06 DVD MIDWEST TAPE 104433 95509775 23.99 11/06/2017 07 DVDS MIDWEST TAPE 104433 95530036 45.98 AP-171125M 11/30/2017 175 AMAZON-BINGO CARDS, DAUBERS, FIRST NATIONAL BANK 900052 112517-D.DEBORD 37.44 GJ-171130LB 12/01/2017 08 Nov 2017 Deposits 2,644.00 _________________________________ TOTAL PERIOD 07 ACTIVITY 190.76 2,644.00 08 AP-171211 12/04/2017 01 BOOKS BAKER & TAYLOR 104441 2033253908 285.39 12/04/2017 02 BOOKS BAKER & TAYLOR 104441 2033277843 32.99 12/04/2017 03 BOOKS BAKER & TAYLOR 104441 2033279262 47.27 12/04/2017 04 BOOKS BAKER & TAYLOR 104441 2033297864 23.23 12/04/2017 05 BOOKS BAKER & TAYLOR 104441 2033303265 80.48 12/04/2017 06 BOOKS BAKER & TAYLOR 104441 2033324276 8.99 12/04/2017 07 BOOKS BAKER & TAYLOR 104441 2033325433 10.34 AP-171225M 12/18/2017 139 MCDONALDS-GIFT CARD FIRST NATIONAL BANK 900053 122517-M.EBERHARDT 20.00 12/18/2017 140 NCG CINEMA-GIFT CARD FIRST NATIONAL BANK 900053 122517-M.EBERHARDT 20.00 12/18/2017 141 IMPRINT-TABLE THROW & RUNNER FIRST NATIONAL BANK 900053 122517-S.AUGUSTINE 187.08 GJ-171231LB 01/02/2018 08 Dec 2017 Deposits 971.08 _________________________________ TOTAL PERIOD 08 ACTIVITY 715.77 971.08 09 GJ-170131LB 02/01/2018 08 January 2018 Deposits 346.20 AP-180108 01/03/2018 01 BOOKS BAKER & TAYLOR 104455 2033341157 61.29 01/03/2018 02 BOOKS BAKER & TAYLOR 104455 2033372209 599.34 01/03/2018 03 DVD MIDWEST TAPE 104459 95649185 17.99 DATE: 04/04/2018 UNITED CITY OF YORKVILLE PAGE: 3TIME: 17:03:26 GENERAL LEDGER ACTIVITY REPORT F-YR: 18ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 11PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT_____________________________________________________________________________________________________________________________________________________82-000-24-00-2480 (L) ESCROW - MEMORIALS & GIFTS_____________________________________________________________________________________________________________________________________________________ 09 AP-180108 01/03/2018 04 DVD MIDWEST TAPE 104459 95686677 22.99 AP-180125M 01/19/2018 152 ELLISON-CUTTING PAD, SURE CUT FIRST NATIONAL BANK 900054 012518-M.EBERHARDT 178.20 _________________________________ TOTAL PERIOD 09 ACTIVITY 879.81 346.20 10 AP-180212 02/05/2018 01 BOOKS BAKER & TAYLOR 104463 2033379254 23.66 02/05/2018 02 BOOKS BAKER & TAYLOR 104463 2033403826 233.40 02/05/2018 03 BOOKS BAKER & TAYLOR 104463 2033421604 59.12 02/05/2018 04 BOOKS BAKER & TAYLOR 104463 2033427801 328.11 02/05/2018 05 BOOKS BAKER & TAYLOR 104463 2033464650 92.28 AP-180226M 02/20/2018 236 DOLLAR TREE-SUPPLIES FOR FIRST NATIONAL BANK 900055 022618-J.WEISS 18.00 _________________________________ TOTAL PERIOD 10 ACTIVITY 754.57 0.00 11 AP-180312 03/05/2018 02 BOOKS BAKER & TAYLOR 104482 2033480290 81.17 03/05/2018 03 BOOKS BAKER & TAYLOR 104482 2033481760 34.70 03/05/2018 04 BOOKS BAKER & TAYLOR 104482 2033496511 89.68 03/05/2018 05 BOOKS BAKER & TAYLOR 104482 2033504391 32.99 03/05/2018 06 BOOKS BAKER & TAYLOR 104482 2033507109 510.13 03/05/2018 07 BOOKS BAKER & TAYLOR 104482 2033515534 171.60 GJ-180331LB 04/03/2018 08 Mar 2018 Deposits 50.00 _________________________________ TOTAL PERIOD 11 ACTIVITY 920.27 50.00 TOTAL ACCOUNT ACTIVITY 7,881.47 9,830.51 ENDING BALANCE 5,026.09 GRAND TOTAL 0.00 5,026.09 TOTAL DIFFERENCE 0.00 5,026.09 LIBRARY DIRECTOR REPORT— March, 2018 Facilities Management Kendall Plumbing repaired 2 sinks and adjusted water heater temperature to try to alleviate the sulfur smell and discolored water (3/2/18). Fire Inspection on Fire Panel (State Requirement-4/21/18). Public Relations Planning for activities during National Library Week, April 8-14, 2018. Letters to the Editor, Board and Friends Recognition at the Board Meeting (4/9/18), Staff Lunch (4/11/18) and Patron Appreciation (4/12/18). Grants Researched and submitted the Back to Books Grant to the State Library (3/28/18) for $4,060 to purchase 150 STEM books for the Youth Services Department. We will be notified mid-April if awarded as funds need to be spent by September 30th. Meetings Sharyl Iwanski and Shelley Augustine attended a Staff Development Day at Wabaunsee Community College (3/8/18). Sharyl Iwanski and I met with a local muralist to obtain ideas and costs to do a mural above the Circulation Desk and in the Youth Services Program Room. We would have to look at fundraising in order to fund these murals. Met with Rob Frederickson to review the library budget for 2018/2019. Staff Recruitment New staff member, Katrina Cole has started work in the Youth Services Department. Library Operations Continue to work the Reference desk in the evenings and lunch breaks as needed. Will be starting an orientation in the Circulation department in the next 2 weeks. Friends We continue to provide the library’s wish list to the Friends on a monthly basis. We are now researching projection systems for the Meeting Room as they have agreed to fund this project. We will have a report ready for their May meeting. Programs, Activities Adult Programs Evening Book Club 4 Men’s Book Club 7 Friends Meeting 8 Threads and More 8 Creative Writing 12 Lunch Bunch 6 Academy Awards Drawing Participation 25 Al Capone & the 1933 World’s Fair 25 TOTAL ADULT ATTENDANCE 95 Young Adult Programs Teen Meeting -TAG 23 TOTAL YA ATTENDANCE 23 Children Programs Drop-In Storytime 19 Tots and Toddlers (2 programs) 62 Afternoon/Morning Read (2 programs) 10 Lego Club 6 Book Club (2 programs) (Grades 1-2) 9 Book Club (2 programs) (Grades 3-5) 6 Panera Storytime (2 programs) 33 Literacy Center (2 programs) 19 Beginning Read 2 Chess Club (2 programs) 29 Lap sit 10 Read with Paws 8 Club Duplo 10 Movie 25 Dance Party 12 Life Size Candyland 60 Cards for Kids 17 Books for Bingo 23 TOTAL CHILDREN’S ATTENDANCE 360 Passive programs included: Dr. Seuss birthday card (52), Dr. Seuss doorknob hanger (20), Lucky Leprechaun (25) Shamrock Secret Code Sheet (27), Jungle Puzzle (38) and Egg Stack (117). TOTAL PARTICIPATION FOR PASSIVE PROGRAMS 279 Computer Use Adult 338 Young Adult 59 Children 49 Express 39 TOTAL COMPUTER USE 485 E-book Use Omni E-Book 740 E-Audio 310 (227 Users) E-Read IL E-Book 19 Audio 41 (25 Users) Circulation Checkouts 15,093 New Patrons Added 130 New Items Added 745 Teen Volunteers Morgan Rustsay, Mikayla Mika, Sydney Klebenow, Skylar Krantz, Mark Sanford, Katlyn Tugman, Zach Weiss, Kassey Hester and Marie Berengi. Adult Volunteers Yorkville Jr. Women’s Club (Drop in Story Time), Fox Valley Therapy Dogs (Read with Paws) Theron Garcia (Dance Party) and Brad Smith (Chess Club). Meeting Room 3 Rental, 14 Programs Proctored Test 1 Patron Count 4,983 YORKVILLE STATISTICS FOR FY18 PrairieCat Month All Transactions checkouts+ renewals checkouts renewals all holds placed holds filled checkins usage Items lent to other libraries Items borrowed from other libraries Items to Reciprocal Borrowers atYorkville Items added Total items Patrons added Total patrons e- commerce MAY 12,510 6,087 5,275 812 334 1,160 4,929 0 535 932 266 437 111 492.84 JUNE 17,149 8,616 7,531 1,085 413 1,507 6,613 0 598 1,266 425 310 184 405.54 JUL 16,457 7,641 6,569 1,072 437 1,468 6,911 0 604 1,217 258 305 146 296.55 AUG 15,773 7,313 6,221 1,092 367 1,550 6,542 1 699 1,290 220 272 142 203.95 SEP 13,260 6,043 5,104 939 421 1,499 5,297 0 615 1,263 207 325 113 147.70 OCT 14,168 6,723 5,693 1,030 416 1,470 5,559 0 660 1,236 325 481 113 361.20 NOV 13,625 6,322 5,421 901 306 1,432 5,565 0 716 1,169 247 418 80 174.85 DEC 10,639 4,958 4,009 949 307 1,023 4,351 0 565 831 220 261 76 169.60 JAN 13,487 6,444 5,629 815 371 1,642 5,030 0 786 1,350 253 399 118 345.10 FEB 12,204 5,774 4,815 959 343 1,347 4,740 0 714 1,110 201 247 85 331.40 MAR 15,093 7,267 6,297 970 427 1,566 5,833 0 899 1,299 263 745 130 APR DATABASE USEAGE FOR FY18 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 189 70 6 34 14 15 13 642 216 208 2 27 21 JUN 90 30 6 20 5 8 13 723 191 210 1 12 19 JUL 38 18 8 22 22 10 13 797 231 203 0 12 14 AUG 280 159 1 7 16 15 16 676 222 214 1 23 14 SEP 110 22 12 88 27 15 21 665 228 198 0 18 6 OCT 219 72 23 51 23 29 19 586 258 204 1 22 9 NOV 236 118 6 18 21 54 22 559 220 190 0 32 5 DEC 164 76 13 25 10 39 16 621 246 202 0 13 18 JAN 98 96 21 69 16 40 22 684 267 226 1 9 15 FEB 60 147 20 47 3 10 21 606 289 228 0 35 9 MAR 19 41 25 740 310 227 3 APR FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Library Operations 82-000-40-00-4000 PROPERTY TAXES - LIBRARY OPS 622,529 626,183 645,867 644,025 672,505 685,955 699,674 713,667 727,940 82-000-40-00-4083 PROPERTY TAXES - DEBT SERVICE 746,621 745,908 757,396 758,634 792,101 797,013 827,088 840,225 847,313 82-000-41-00-4120 PERSONAL PROPERTY TAX 5,324 5,914 5,250 5,250 5,250 5,250 5,250 5,250 5,250 82-000-41-00-4170 STATE GRANTS 21,151 13,044 17,200 13,138 13,100 13,100 13,100 13,100 13,100 82-000-43-00-4330 LIBRARY FINES 8,081 7,355 8,000 9,000 8,500 8,500 8,500 8,500 8,500 82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 6,038 6,576 6,500 8,800 7,500 7,500 7,500 7,500 7,500 82-000-44-00-4422 COPY FEES 2,283 2,717 2,500 3,500 3,000 3,000 3,000 3,000 3,000 82-000-44-00-4439 PROGRAM FEES 870 915 1,000 1,000 1,000 1,000 1,000 1,000 1,000 82-000-45-00-4500 559 1,594 800 2,000 1,750 1,550 1,400 1,300 1,200 82-000-46-00-4690 REIMB - MISCELLANEOUS - 2,141 - 691 - - - - - 82-000-48-00-4820 RENTAL INCOME 1,942 2,200 2,000 1,800 2,000 2,000 2,000 2,000 2,000 82-000-48-00-4824 DVD RENTAL INCOME 2,454 2,444 2,500 2,800 2,750 2,750 2,750 2,750 2,750 82-000-48-00-4850 MISCELLANEOUS INCOME 844 2,455 1,000 2,150 2,000 2,000 2,000 2,000 2,000 82-000-49-00-4901 TRANSFER FROM GENERAL 25,928 24,044 26,440 23,793 25,179 26,645 28,199 29,846 31,592 Revenue 1,444,624 1,443,490 1,476,453 1,476,581 1,536,635 1,556,263 1,601,461 1,630,138 1,653,145 82-820-50-00-5010 SALARIES & WAGES 201,312 211,185 223,828 215,000 226,998 233,808 240,822 248,047 255,488 82-820-50-00-5015 PART-TIME SALARIES 190,592 200,317 232,689 190,000 195,700 201,571 207,618 213,847 220,262 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 21,767 22,558 24,435 23,500 24,252 25,672 27,213 28,873 30,633 82-820-52-00-5214 FICA CONTRIBUTION 29,361 30,778 34,263 31,000 31,720 32,672 33,652 34,662 35,702 82-820-52-00-5216 GROUP HEALTH INSURANCE 68,514 74,462 88,996 67,475 79,318 85,663 92,516 99,917 107,910 82-820-52-00-5222 GROUP LIFE INSURANCE 443 403 403 381 328 331 334 337 340 82-820-52-00-5223 DENTAL INSURANCE 5,034 5,286 5,550 4,673 4,652 4,885 5,129 5,385 5,654 82-820-52-00-5224 VISION INSURANCE 651 651 670 638 701 701 701 722 744 82-820-52-00-5230 UNEMPLOYMENT INSURANCE 420 474 1,000 747 750 750 750 750 750 82-820-52-00-5231 LIABILITY INSURANCE 25,508 23,570 25,440 23,046 24,429 25,895 27,449 29,096 30,842 82-820-54-00-5412 TRAINING & CONFERENCES 249 330 500 500 2,500 500 500 500 500 82-820-54-00-5415 TRAVEL & LODGING 262 365 600 600 600 600 600 600 600 82-820-54-00-5421 PPRT TAX REBATE 678 - - - - - - - - 82-820-54-00-5426 PUBLISHING & ADVERTISING 23 277 100 100 2,000 2,000 2,000 2,000 2,000 82-820-54-00-5440 TELECOMMUNICATIONS 6,007 3,524 6,000 5,000 5,000 5,000 5,000 5,000 5,000 82-820-54-00-5452 POSTAGE & SHIPPING 494 398 500 500 500 500 500 500 500 82-820-54-00-5460 DUES & SUBSCRIPTIONS 9,560 9,005 12,000 10,000 11,000 11,000 11,000 11,000 11,000 82-820-54-00-5462 PROFESSIONAL SERVICES 31,278 38,037 40,000 35,000 40,000 40,000 40,000 40,000 40,000 82-820-54-00-5466 LEGAL SERVICES - - 2,000 - 3,000 3,000 3,000 3,000 3,000 82-820-54-00-5468 AUTOMATION 17,890 12,633 20,000 15,000 20,000 20,000 20,000 20,000 20,000 Description INVESTMENT EARNINGS FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Proposed Projected Projected Projected ProjectedDescription 82-820-54-00-5480 UTILITIES 6,504 10,961 8,480 9,000 9,540 10,112 10,719 11,362 12,044 82-820-54-00-5495 OUTSIDE REPAIR & MAINTENANCE 19,962 27,190 50,000 65,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 1,700 82-820-56-00-5610 OFFICE SUPPLIES 9,240 8,906 8,000 8,000 8,000 8,000 8,000 8,000 8,000 82-820-56-00-5620 LIBRARY OPERATING SUPPLIES 11,210 9,654 10,000 10,000 2,000 2,000 2,000 2,000 2,000 82-820-56-00-5621 CUSTODIAL SUPPLIES - - - - 8,000 8,000 8,000 8,000 8,000 82-820-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - - - - - - - - - 82-820-56-00-5671 LIBRARY PROGRAMMING 1,030 1,243 1,000 1,000 1,000 1,000 1,000 1,000 1,000 82-820-56-00-5676 EMPLOYEE RECOGNITION - - - - 200 200 200 200 200 82-820-56-00-5684 COMPACT DISCS & OTHER MUSIC - - - - - - - - - 82-820-56-00-5685 DVD'S 2,427 1,141 500 500 500 500 500 500 500 82-820-56-00-5686 BOOKS - 5,983 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 50,000 50,000 50,000 50,000 75,000 75,000 75,000 82-820-84-00-8050 INTEREST PAYMENT 32,113 29,738 27,363 27,363 24,988 22,613 20,238 16,675 13,113 Debt Service - 2013 Refunding Bond 82-820-99-00-8000 PRINCIPAL PAYMENT 485,000 500,000 520,000 520,000 565,000 585,000 610,000 645,000 675,000 82-820-99-00-8050 INTEREST PAYMENT 182,733 173,033 163,033 163,033 152,113 139,400 121,850 103,550 84,200 Expenditures 1,411,951 1,453,791 1,560,550 1,480,245 1,547,989 1,574,573 1,629,491 1,668,723 1,703,182 Surplus(Deficit)32,673 (10,301) (84,097) (3,664) (11,354) (18,310) (28,030) (38,585) (50,037) Fund Balance 499,355 489,057 396,472 485,393 474,039 455,729 427,699 389,114 339,077 35.37%33.64%25.41%32.79%30.62%28.94%26.25%23.32%19.91% Operational Fund Balance %75.42%69.76%49.55%67.43%62.71%58.61%53.30%46.97%39.62% Library Capital 84-000-42-00-4214 DEVELOPMENT FEES 35,350 53,450 35,000 70,000 43,200 39,600 39,600 39,600 39,600 84-000-42-00-4224 RENEW PROGRAM PERMITS 750 200 - - - - - - - 84-000-45-00-4500 8 12 10 10 10 10 10 10 10 84-000-48-00-4850 MISCELLANEOUS INCOME 10 130 - - - - - - - Revenue 36,118 53,792 35,010 70,010 43,210 39,610 39,610 39,610 39,610 84-840-54-00-5406 RENEW PROGRAM 750 200 - - - - - - - 84-840-54-00-5460 E-BOOKS SUBSCRIPTION 3,508 3,644 3,500 3,500 3,500 3,500 3,500 3,500 3,500 84-840-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE 1,311 15,444 15,000 15,000 15,000 15,000 15,000 15,000 15,000 84-840-56-00-5683 AUDIO BOOKS 1,237 2,758 - 1,600 1,600 1,600 1,600 1,600 1,600 INVESTMENT EARNINGS FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Proposed Projected Projected Projected ProjectedDescription 84-840-56-00-5684 COMPACT DISCS & OTHER MUSIC - - - 150 500 500 500 500 500 84-840-56-00-5685 DVD'S 394 1,843 - 1,500 1,500 1,500 1,500 1,500 1,500 84-840-56-00-5686 BOOKS 26,826 24,806 16,500 28,000 30,000 30,000 30,000 30,000 30,000 Expenditures 34,026 48,695 35,000 49,750 52,100 52,100 52,100 52,100 52,100 Surplus(Deficit)2,092 5,097 10 20,260 (8,890) (12,490) (12,490) (12,490) (12,490) Fund Balance 14,807 19,904 23,999 40,164 31,274 18,784 6,294 (6,196) (18,686) Cash Flow - Surplus(Deficit) Library Ops 32,673 (10,301) (84,097) (3,664) (11,354) (18,310) (28,030) (38,585) (50,037) Library Capital 2,092 5,097 10 20,260 (8,890) (12,490) (12,490) (12,490) (12,490) 34,765 (5,204) (84,087) 16,596 (20,244) (30,800) (40,520) (51,075) (62,527) Cash Flow - Fund Balance Library Ops 499,355 489,057 396,472 485,393 474,039 455,729 427,699 389,114 339,077 Library Capital 14,807 19,904 23,999 40,164 31,274 18,784 6,294 (6,196) (18,686) 514,162 508,961 420,471 525,557 505,313 474,513 433,993 382,918 320,391 Library Fiscal Year Fund Dept Account Number Description Original Amount Revised Amount Effect on Fund Balance Notes Date Budget Adjustment # 1 2019 7,000 7,500 500 Proposed by Management 3/19/2018 2020 7,000 7,500 500 2021 7,000 7,500 500 2022 7,000 7,500 500 2023 7,000 7,500 500 2019 Library Library Operations 82-820-54-00-5412 Training & Conferences 500 2,500 (2,000)Adjusted as requested by the Yorkville Library Board. 2019 100 2,000 (1,900) 2020 100 2,000 (1,900) 2021 100 2,000 (1,900) 2022 100 2,000 (1,900) 2023 100 2,000 (1,900) 2019 2,000 3,000 (1,000) 2020 2,000 3,000 (1,000) 2021 2,000 3,000 (1,000) 2022 2,000 3,000 (1,000) 2023 2,000 3,000 (1,000) 2019 - 200 (200) 2020 - 200 (200) 2021 - 200 (200) 2022 - 200 (200) 2023 - 200 (200) Library Operations Library Library Operations Library 82-000-44-00-4401 Library Subscription Cards 82-820-54-00-5426 Publishing & Advertising Adjusted as requested by the Yorkville Library Board. Adjusted as requested by the Yorkville Library Board. Library Library Operations Library Library Operations 82-820-54-00-5466 Legal Services 82-820-56-00-5676 Employee Recognition Adjusted as requested by the Yorkville Library Board. Adjusted as requested by the Yorkville Library Board. 2019 10,000 8,000 / 2,000 - 2020 10,000 8,000 / 2,000 - 2021 10,000 8,000 / 2,000 - 2022 10,000 8,000 / 2,000 - 2023 10,000 8,000 / 2,000 - 2019 220,386 226,998 (6,612) 2020 220,386 233,808 (13,422) 2021 220,386 240,822 (20,436) 2022 220,386 248,047 (27,661) 2023 220,386 255,488 (35,102) 2019 235,000 195,700 39,300 2020 235,000 201,571 33,429 2021 235,000 207,618 27,382 2022 235,000 213,847 21,153 2023 235,000 220,262 14,738 2019 23,546 24,252 (706) 2020 23,546 25,672 (2,126) 2021 23,546 27,213 (3,667) 2022 23,546 28,873 (5,327) 2023 23,546 30,633 (7,087) 2019 34,221 31,720 2,501 2020 34,221 32,672 1,549 2021 34,221 33,652 569 2022 34,221 34,662 (441) 2023 34,221 35,702 (1,481) 1,553$ Library Operations 82-820-52-00-5214 FICA Contribution Library Library Operations Library Library Operations Adjusted as requested by the Yorkville Library Board. Adjusted accordingly to reflect 3% COLA implemented for all Full & Part-Time Library Employees thru FY 2023. Adjusted as requested by the Yorkville Library Board. Adjusted accordingly to reflect 3% COLA implemented for all Full-Time Library Employees thru FY 2023. Library Library Operations Operating Supplies Library Net Effect on Fund Balance Library Library Operations 82-820-50-00-5010 Salaries & Wages 82-820-50-00-5015 Part-Time Salaries 82-820-52-00-5212 Retirement Plan Contribution 82-820-56-00-5620 Adjusted as requested by the Yorkville Library Board. Operating Supplies broken out into two distinct line items: Custodial Supplies budgeted at $8,000 thru FY 2023; and Library Operating Supplies budgeted at $2,000 thru FY 2023. Adjusted as requested by the Yorkville Library Board. 3% COLA implemented for all Full-Time Library Employees thru FY 2023. Adjusted as requested by the Yorkville Library Board. 3% COLA implemented for all Part-Time Library Employees thru FY 2023. Budget Adjustment # 2 2019 83,747 79,318 4,429 Proposed by Management 3/21/2018 2020 90,447 85,663 4,784 4/2/2018 2021 97,683 92,516 5,167 2022 105,498 99,917 5,581 2023 113,938 107,910 6,028 25,989$ Budget Adjustment # 3 82-820-52-00-5222 Group Life Insurance 450 328 122 Proposed by Management 4/2/2018 82-820-52-00-5223 Dental Insurance 5,333 4,652 681 82-820-52-00-5224 Vision Insurance 722 701 21 82-820-52-00-5222 Group Life Insurance 455 331 124 82-820-52-00-5223 Dental Insurance 5,600 4,885 715 82-820-52-00-5224 Vision Insurance 744 701 43 82-820-52-00-5222 Group Life Insurance 460 334 126 82-820-52-00-5223 Dental Insurance 5,880 5,129 751 82-820-52-00-5224 Vision Insurance 766 701 65 82-820-52-00-5222 Group Life Insurance 465 337 128 82-820-52-00-5223 Dental Insurance 6,174 5,385 789 82-820-52-00-5224 Vision Insurance 789 722 67 82-820-52-00-5222 Group Life Insurance 470 340 130 82-820-52-00-5223 Dental Insurance 6,483 5,654 829 82-820-52-00-5224 Vision Insurance 813 744 69 4,660$ Library Library Operations 82-820-52-00-5216 Group Life, Dental & Vision Insurance amounts revised based on renewal information from Alliant/Mesirow. Net Effect on Fund Balance Library Operations Group Health Insurance Group Health Insurance amounts revised to reflect an increase of 3.34% (v. 8.0% as originally budgeted) based on renewal information from Alliant/Mesirow. Revised on April 3rd to reflect additional 1% reduction in rates as a result of City Council's decision to go with BCBS as the City's dental carrier for FY 2019. Net Effect on Fund Balance Library Library Operations2019 Library Library Operations 2021 Library 2020 Library Library Operations 2023 Library Library Operations 2022 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Projected Proposed Projected Projected Projected Projected Totals Library Ops - 35,136 22,496 7,357 (8,311) (24,476) 32,202 Library Capital Entity-Wide Total 0 35,136 22,496 7,357 (8,311)(24,476)32,202 Overall Effect of Proposed Budget Adjustments on Fund Balance FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Projected Proposed Projected Projected Projected Projected Library 485,393 474,039 455,729 427,699 389,114 339,077 Library Capital 40,164 31,274 18,784 6,294 (6,196) (18,686) Adjusted Entity-Wide Total 525,557 505,313 474,513 433,993 382,918 320,391 Library Fund Balance Adjusted