Loading...
Library Board Packet 2020 03-09-20 Finance CommitteeAgenda Yorkville Public Library Michelle Pfister Meeting Room Finance Committee Meeting March 9, 2020– 6 P.M. 902 Game Farm Road 1. Roll Call 2. Recognition of Visitors 3. Public Comment 4. Review Library Budget 5. Adjournment FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Library Operations 82-000-40-00-4000 PROPERTY TAXES - LIBRARY OPS 644,025 669,065 699,220 702,716 739,047 761,218 784,055 807,577 831,804 82-000-40-00-4083 PROPERTY TAXES - DEBT SERVICE 758,634 788,022 793,028 794,715 822,953 836,024 843,076 862,416 859,680 82-000-41-00-4120 PERSONAL PROPERTY TAX 4,948 5,353 5,250 5,250 5,250 5,250 5,250 5,250 5,250 82-000-41-00-4170 STATE GRANTS 13,138 25,211 20,000 21,151 20,000 20,000 20,000 20,000 20,000 82-000-43-00-4330 LIBRARY FINES 9,922 9,234 8,500 8,500 8,500 8,500 8,500 8,500 8,500 82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 8,040 9,185 8,000 9,000 8,500 8,500 8,500 8,500 8,500 82-000-44-00-4422 COPY FEES 3,853 3,980 3,750 3,900 3,900 3,900 3,900 3,900 3,900 82-000-44-00-4439 PROGRAM FEES 857 301 - 58 - - - - - 82-000-45-00-4500 4,593 11,463 10,000 10,000 10,000 10,000 7,500 7,500 5,000 82-000-45-00-4550 GAIN ON INVESTMENT 830 - - 3,882 - - - - - 82-000-46-00-4690 REIMB - MISCELLANEOUS 691 - - - - - - - - 82-000-48-00-4820 RENTAL INCOME 1,806 1,405 2,000 2,000 2,000 2,000 2,000 2,000 2,000 82-000-48-00-4824 DVD RENTAL INCOME 2,842 1,228 - - - - - - - 82-000-48-00-4850 MISCELLANEOUS INCOME 1,840 830 2,000 2,000 2,000 2,000 2,000 2,000 2,000 82-000-49-00-4901 TRANSFER FROM GENERAL 23,775 23,495 25,003 24,235 26,584 28,134 29,777 31,519 33,365 Revenue 1,479,794 1,548,772 1,576,751 1,587,407 1,648,734 1,685,526 1,714,558 1,759,162 1,779,999 82-820-50-00-5010 SALARIES & WAGES 213,880 261,231 278,394 278,394 289,742 298,434 307,387 316,609 326,107 82-820-50-00-5015 PART-TIME SALARIES 189,152 165,624 196,000 175,000 196,000 201,880 207,936 214,174 220,599 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 22,885 26,614 25,541 29,000 32,779 34,171 36,087 37,993 39,133 82-820-52-00-5214 FICA CONTRIBUTION 30,169 31,983 35,544 33,500 36,411 37,503 38,628 39,787 40,981 82-820-52-00-5216 GROUP HEALTH INSURANCE 65,658 68,695 81,184 72,474 85,915 92,788 100,211 108,228 116,886 82-820-52-00-5222 GROUP LIFE INSURANCE 388 351 387 362 391 395 399 403 407 82-820-52-00-5223 DENTAL INSURANCE 4,672 6,699 6,987 6,987 7,337 7,704 8,089 8,493 8,918 82-820-52-00-5224 VISION INSURANCE 637 973 1,012 1,012 1,012 1,042 1,073 1,105 1,138 82-820-52-00-5230 UNEMPLOYMENT INSURANCE 747 604 750 750 750 750 750 750 750 82-820-52-00-5231 LIABILITY INSURANCE 23,028 22,891 24,253 23,485 25,834 27,384 29,027 30,769 32,615 82-820-54-00-5412 TRAINING & CONFERENCES 308 1,374 2,000 2,000 2,000 2,000 2,000 2,000 2,000 82-820-54-00-5415 TRAVEL & LODGING 348 1,557 1,500 1,500 1,500 1,500 1,500 1,500 1,500 82-820-54-00-5426 PUBLISHING & ADVERTISING 100 3,019 2,000 2,000 2,000 1,000 1,000 1,000 1,000 82-820-54-00-5440 TELECOMMUNICATIONS 4,513 5,313 6,000 6,000 6,000 6,000 6,000 6,000 6,000 82-820-54-00-5452 POSTAGE & SHIPPING 582 655 750 750 750 600 600 600 600 82-820-54-00-5460 DUES & SUBSCRIPTIONS 8,911 9,602 11,000 11,000 11,000 11,000 11,000 11,000 11,000 82-820-54-00-5462 PROFESSIONAL SERVICES 24,151 24,213 40,000 40,000 40,000 40,000 40,000 40,000 40,000 82-820-54-00-5466 LEGAL SERVICES 2,100 2,205 3,000 3,000 3,000 3,000 3,000 3,000 3,000 82-820-54-00-5468 AUTOMATION 13,466 13,854 20,000 20,000 20,000 20,000 20,000 20,000 20,000 82-820-54-00-5480 UTILITIES 9,852 11,973 11,130 11,130 11,798 12,506 13,256 14,051 14,894 82-820-54-00-5495 OUTSIDE REPAIR & MAINTENANCE 65,777 28,900 50,000 50,000 50,000 50,000 50,000 50,000 50,000 INVESTMENT EARNINGS Description 1 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Actual Actual Adopted Projected Proposed Projected Projected Projected ProjectedDescription 82-820-54-00-5498 PAYING AGENT FEES 1,689 1,689 1,700 1,700 1,700 1,700 1,700 1,700 1,700 82-820-56-00-5610 OFFICE SUPPLIES 5,518 7,147 8,000 8,000 8,000 8,000 8,000 8,000 8,000 82-820-56-00-5620 LIBRARY OPERATING SUPPLIES 6,733 3,821 3,000 3,000 3,000 2,000 2,000 2,000 2,000 82-820-56-00-5621 CUSTODIAL SUPPLIES - 4,215 8,000 8,000 8,000 8,000 8,000 8,000 8,000 82-820-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - 1,199 2,000 2,000 2,000 2,000 2,000 2,000 2,000 82-820-56-00-5671 LIBRARY PROGRAMMING 820 1,737 1,000 1,000 1,000 1,000 1,000 1,000 1,000 82-820-56-00-5676 EMPLOYEE RECOGNITION 151 247 200 200 200 200 200 200 200 82-820-56-00-5684 COMPACT DISCS & OTHER MUSIC - - - - - - - - - 82-820-56-00-5685 DVD'S 499 56 500 500 500 500 500 500 500 82-820-56-00-5686 BOOKS 1,367 4,315 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 75,000 75,000 75,000 100,000 100,000 82-820-84-00-8050 INTEREST PAYMENT 27,363 24,988 22,613 22,613 20,238 16,675 13,113 9,550 4,800 Debt Service - 2013 Refunding Bond 82-820-99-00-8000 PRINCIPAL PAYMENT 520,000 565,000 585,000 585,000 610,000 645,000 675,000 700,000 730,000 82-820-99-00-8050 INTEREST PAYMENT 163,033 152,113 139,400 139,400 121,850 103,550 84,200 57,200 29,200 Expenditures 1,458,497 1,504,857 1,620,345 1,591,257 1,677,207 1,714,782 1,750,156 1,799,112 1,826,428 Surplus(Deficit)21,297 43,915 (43,594) (3,850) (28,473) (29,256) (35,598) (39,950) (46,429) Fund Balance 510,355 554,271 474,039 550,421 521,948 492,692 457,094 417,144 370,715 34.99%36.83%29.26%34.59%31.12%28.73%26.12%23.19%20.30% Operational Fund Balance %73.11%77.76%57.58%69.30%61.40%56.34%50.63%44.74%38.52% 2 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Actual Actual Adopted Projected Proposed Projected Projected Projected ProjectedDescription Library Capital 84-000-42-00-4214 DEVELOPMENT FEES 100,484 103,100 50,000 104,900 50,000 50,000 50,000 50,000 50,000 84-000-45-00-4500 16 257 100 100 100 100 100 100 100 84-000-48-00-4850 MISCELLANEOUS INCOME 37 1,835 - - - - - - - Revenue 100,537 105,192 50,100 105,000 50,100 50,100 50,100 50,100 50,100 84-840-54-00-5460 E-BOOKS SUBSCRIPTION 3,425 3,213 3,500 3,500 3,500 3,500 3,500 3,500 3,500 84-840-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE 7,367 14,897 15,000 15,000 15,000 15,000 15,000 15,000 15,000 84-840-56-00-5683 AUDIO BOOKS 3,531 3,877 3,500 3,500 3,500 3,500 3,500 3,500 3,500 84-840-56-00-5684 COMPACT DISCS & OTHER MUSIC 699 290 500 500 500 500 500 500 500 84-840-56-00-5685 DVD'S 1,903 3,425 3,000 3,000 3,000 3,000 3,000 3,000 3,000 84-840-56-00-5686 BOOKS 41,104 54,673 50,000 50,000 50,000 50,000 50,000 50,000 35,760 84-840-60-00-6020 BUILDINGS & STRUCTURES 3,970 - - - - - - - - Expenditures 61,999 80,375 75,500 75,500 75,500 75,500 75,500 75,500 61,260 Surplus(Deficit)38,538 24,817 (25,400) 29,500 (25,400) (25,400) (25,400) (25,400) (11,160) Fund Balance 58,443 83,260 31,274 112,760 87,360 61,960 36,560 11,160 - Cash Flow - Surplus(Deficit) Library Ops 21,297 43,915 (43,594) (3,850) (28,473) (29,256) (35,598) (39,950) (46,429) Library Capital 38,538 24,817 (25,400) 29,500 (25,400) (25,400) (25,400) (25,400) (11,160) 59,835 68,732 (68,994) 25,650 (53,873) (54,656) (60,998) (65,350) (57,589) Cash Flow - Fund Balance Library Ops 510,355 554,271 474,039 550,421 521,948 492,692 457,094 417,144 370,715 Library Capital 58,443 83,260 31,274 112,760 87,360 61,960 36,560 11,160 - 568,798 637,531 505,313 663,181 609,308 554,652 493,654 428,304 370,715 INVESTMENT EARNINGS Library 3 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Library Operations 82-000-40-00-4000 PROPERTY TAXES - LIBRARY OPS 644,025 669,065 699,220 702,716 739,047 761,218 784,055 807,577 831,804 82-000-40-00-4083 PROPERTY TAXES - DEBT SERVICE 758,634 788,022 793,028 794,715 822,953 836,024 843,076 862,416 859,680 82-000-41-00-4120 PERSONAL PROPERTY TAX 4,948 5,353 5,250 5,250 5,250 5,250 5,250 5,250 5,250 82-000-41-00-4170 STATE GRANTS 13,138 25,211 20,000 21,151 20,000 20,000 20,000 20,000 20,000 82-000-43-00-4330 LIBRARY FINES 9,922 9,234 8,500 8,500 8,500 8,500 8,500 8,500 8,500 82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 8,040 9,185 8,000 8,300 8,500 8,500 8,500 8,500 8,500 82-000-44-00-4422 COPY FEES 3,853 3,980 3,750 3,800 3,800 3,900 3,900 3,900 3,900 82-000-44-00-4439 PROGRAM FEES 857 301 - 64 - - - - - 82-000-45-00-4500 4,593 11,463 10,000 13,500 8,959 8,272 7,518 6,688 5,788 82-000-45-00-4550 GAIN ON INVESTMENT 830 - - 3,882 - - - - - 82-000-46-00-4690 REIMB - MISCELLANEOUS 691 - - - - - - - - 82-000-48-00-4820 RENTAL INCOME 1,806 1,405 2,000 1,500 1,750 1,750 1,750 1,750 1,750 82-000-48-00-4824 DVD RENTAL INCOME 2,842 1,228 - - - - - - - 82-000-48-00-4850 MISCELLANEOUS INCOME 1,840 830 2,000 2,500 2,000 2,000 2,000 2,000 2,000 82-000-49-00-4901 TRANSFER FROM GENERAL 23,775 23,495 25,003 24,235 26,584 28,134 29,777 31,519 33,365 Revenue 1,479,794 1,548,772 1,576,751 1,590,113 1,647,343 1,683,548 1,714,326 1,758,100 1,780,537 82-820-50-00-5010 SALARIES & WAGES 213,880 261,231 278,394 278,394 289,742 298,434 307,387 316,609 326,107 82-820-50-00-5015 PART-TIME SALARIES 189,152 165,624 196,000 167,500 190,000 205,729 221,551 237,410 253,305 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 22,885 26,614 25,541 29,000 32,779 34,171 36,087 37,993 39,133 82-820-52-00-5214 FICA CONTRIBUTION 30,169 31,983 35,544 33,500 35,952 38,568 40,464 42,382 44,325 82-820-52-00-5216 GROUP HEALTH INSURANCE 65,658 68,695 81,184 72,474 78,641 84,932 91,727 99,065 106,990 82-820-52-00-5222 GROUP LIFE INSURANCE 388 351 387 362 387 391 395 399 403 82-820-52-00-5223 DENTAL INSURANCE 4,672 6,699 6,987 6,987 6,322 6,638 6,970 7,319 7,685 82-820-52-00-5224 VISION INSURANCE 637 973 1,012 1,012 1,012 1,042 1,073 1,105 1,138 82-820-52-00-5230 UNEMPLOYMENT INSURANCE 747 604 750 750 750 750 750 750 750 82-820-52-00-5231 LIABILITY INSURANCE 23,028 22,891 24,253 23,485 25,834 27,384 29,027 30,769 32,615 82-820-54-00-5412 TRAINING & CONFERENCES 308 1,374 2,000 1,200 3,000 3,000 3,000 3,000 3,000 82-820-54-00-5415 TRAVEL & LODGING 348 1,557 1,500 500 1,500 1,500 1,500 1,500 1,500 82-820-54-00-5426 PUBLISHING & ADVERTISING 100 3,019 2,000 1,000 2,500 2,500 2,500 2,500 2,500 82-820-54-00-5440 TELECOMMUNICATIONS 4,513 5,313 6,000 5,750 7,200 7,200 7,200 7,200 7,200 82-820-54-00-5452 POSTAGE & SHIPPING 582 655 750 750 750 600 600 600 600 82-820-54-00-5460 DUES & SUBSCRIPTIONS 8,911 9,602 11,000 11,000 11,000 11,000 11,000 11,000 11,000 82-820-54-00-5462 PROFESSIONAL SERVICES 24,151 24,213 40,000 35,000 40,000 40,000 40,000 40,000 40,000 82-820-54-00-5466 LEGAL SERVICES 2,100 2,205 3,000 2,000 3,000 3,000 3,000 3,000 3,000 82-820-54-00-5468 AUTOMATION 13,466 13,854 20,000 15,000 20,000 20,000 20,000 20,000 20,000 82-820-54-00-5480 UTILITIES 9,852 11,973 11,130 11,130 11,798 12,506 13,256 14,051 14,894 Description INVESTMENT EARNINGS 1 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Actual Actual Adopted Projected Proposed Projected Projected Projected ProjectedDescription 82-820-54-00-5495 OUTSIDE REPAIR & MAINTENANCE 65,777 28,900 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 1,700 82-820-56-00-5610 OFFICE SUPPLIES 5,518 7,147 8,000 8,000 8,000 8,000 8,000 8,000 8,000 82-820-56-00-5620 LIBRARY OPERATING SUPPLIES 6,733 3,821 3,000 3,000 4,000 4,000 4,000 4,000 4,000 82-820-56-00-5621 CUSTODIAL SUPPLIES - 4,215 8,000 8,000 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 820 1,737 1,000 2,000 2,000 2,000 2,000 2,000 2,000 82-820-56-00-5676 EMPLOYEE RECOGNITION 151 247 200 200 300 300 300 300 300 82-820-56-00-5684 COMPACT DISCS & OTHER MUSIC - - - - - - - - - 82-820-56-00-5685 DVD'S 499 56 500 500 500 500 500 500 500 82-820-56-00-5686 BOOKS 1,367 4,315 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 75,000 75,000 75,000 100,000 100,000 82-820-84-00-8050 INTEREST PAYMENT 27,363 24,988 22,613 22,613 20,238 16,675 13,113 9,550 4,800 Debt Service - 2013 Refunding Bond 82-820-99-00-8000 PRINCIPAL PAYMENT 520,000 565,000 585,000 585,000 610,000 645,000 675,000 700,000 730,000 82-820-99-00-8050 INTEREST PAYMENT 163,033 152,113 139,400 139,400 121,850 103,550 84,200 57,200 29,200 Expenditures 1,458,497 1,504,857 1,620,345 1,569,696 1,666,255 1,716,570 1,761,800 1,820,402 1,857,145 Surplus(Deficit)21,297 43,915 (43,594) 20,417 (18,912) (33,022) (47,474) (62,302) (76,608) Fund Balance 510,355 554,271 474,039 574,688 555,776 522,754 475,280 412,978 336,370 34.99%36.83%29.26%36.61%33.35%30.45%26.98%22.69%18.11% Operational Fund Balance %73.11%77.76%57.58%74.38%66.23%59.65%51.97%43.30%33.87% Library Capital 84-000-42-00-4214 DEVELOPMENT FEES 100,484 103,100 50,000 113,000 50,000 50,000 50,000 50,000 50,000 84-000-45-00-4500 16 257 100 725 500 250 250 250 250 84-000-48-00-4850 MISCELLANEOUS INCOME 37 1,835 - - - - - - - Revenue 100,537 105,192 50,100 113,725 50,500 50,250 50,250 50,250 50,250 84-840-54-00-5460 E-BOOKS SUBSCRIPTION 3,425 3,213 3,500 3,000 3,500 3,500 3,500 3,500 3,500 84-840-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE 7,367 14,897 15,000 7,500 15,000 15,000 15,000 15,000 15,000 84-840-56-00-5683 AUDIO BOOKS 3,531 3,877 3,500 3,500 3,500 3,500 3,500 3,500 3,500 84-840-56-00-5684 COMPACT DISCS & OTHER MUSIC 699 290 500 500 500 500 500 500 500 84-840-56-00-5685 DVD'S 1,903 3,425 3,000 3,000 3,000 3,000 3,000 3,000 3,000 INVESTMENT EARNINGS 2 FY 2018 FY 2019 FY 2020 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 Account Number Actual Actual Adopted Projected Proposed Projected Projected Projected ProjectedDescription 84-840-56-00-5686 BOOKS 41,104 54,673 50,000 50,000 50,000 50,000 50,000 50,000 36,360 84-840-60-00-6020 BUILDINGS & STRUCTURES 3,970 - - - - - - - - Expenditures 61,999 80,375 75,500 67,500 75,500 75,500 75,500 75,500 61,860 Surplus(Deficit)38,538 24,817 (25,400) 46,225 (25,000) (25,250) (25,250) (25,250) (11,610) Fund Balance 58,443 83,260 31,274 129,485 104,485 79,235 53,985 28,735 17,125 Cash Flow - Surplus(Deficit) Library Ops 21,297 43,915 (43,594) 20,417 (18,912) (33,022) (47,474) (62,302) (76,608) Library Capital 38,538 24,817 (25,400) 46,225 (25,000) (25,250) (25,250) (25,250) (11,610) 59,835 68,732 (68,994) 66,642 (43,912) (58,272) (72,724) (87,552) (88,218) Cash Flow - Fund Balance Library Ops 510,355 554,271 474,039 574,688 555,776 522,754 475,280 412,978 336,370 Library Capital 58,443 83,260 31,274 129,485 104,485 79,235 53,985 28,735 17,125 568,798 637,531 505,313 704,173 660,261 601,989 529,265 441,713 353,495 Library 3