Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Ordinance 2019-24
STATE OF ILLINOIS COUNTY OF KENMU - FILED . APR 18 2019 Aw COUNTY CLERK KENMLL COUNTY UNITED CITY OF YORKVILLE KENDALL COUNTY, ILLINOIS ORDINANCE NO.2019-24 ORDINANCE APPROVING THE 2019-2020 FISCAL BUDGET FOR THE UNITED CITY OF YORKVILLE Passed by the City Council of the United City of Yorkville,Kendall County,Illinois This 91 day of April,2019 Published in pamphlet form by the authority of the Mayor and City Council of the United City of Yorkville,Kendall County,Illinois on April 18,2019. ORDINANCE NO. 2019- ORDINANCE APPROVING THE 2019-2020 FISCAL BUDGET FOR THE UNITED CITY OF YORKVILLE WHEREAS, the Mayor and City Council of the UNITED CITY OF YORKVILLE have duly held all Public Hearings, allowed public input, and have duly considered formation of a budget for the 2019-2020 Fiscal Year; and WHEREAS,a tentative budget was duly announced and available for examination at the City offices of the UNITED CITY OF YORKVILLE; and WHEREAS,the Mayor and City Council of the UNITED CITY OF YORKVILLE deem it in the best interest of the City for the orderly operation thereof to pass and approve the 2019-2020 Fiscal Year Budget being submitted on April 9, 2019 at its regular City Council Meeting: NOW, THEREFORE, BE IT ORDAINED,by the Mayor and City Council of the United City of Yorkville, Kendall County, Illinois that the 2019-2020 Budget totaling $36,168,516 including the amounts of$16,469,238 General Fund, $718,788 Motor Fuel Tax Fund, $225,470 Vehicle& Equipment Fund, $2,538,097 Sewer Fund, $5,770,144 Water Fund, $4,548,408 City-Wide Capital Fund, $324,025 Debt Service Fund, $104,850 Land Cash Fund, $2,343,405 Parks&Recreation Fund, $1,620,345 Library Operations Fund, $75,500 Library Capital Fund, $923,808 Countryside TIF Fund, $426,484 Downtown TIF Fund, $35,000 Downtown TIF II Fund, $13,977 Sunflower SSA Fund, and $30,977 Fox Hill SSA Fund is hereby adopted for the 2019-2020 Fiscal Year, as presented. Passed by the City Council of the United City of Yorkville, Kendall Co ty, Illinois this 9h day of April, A.D. 2019. CITY CLERK Ordinance No.2019-aAl Page 2 I CARLO COLOSIMO KEN KOCH JACKIE MILSCHEWSKI Y ARDEN JOE PLOCHER CHRIS FUNKHOUSER JOEL FRIEDERS SEAVER TARULIS JASON PETERSON 7 Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois,this 9�"day of April,A.D. 2019. v / MAYOR Ordinance No.2019--ay Page 3 FY 2019FY 2017 FY 2018 AdoptedFY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024Actual Actual Budget ProjectedAdoptedProjectedProjectedProjectedProjectedRevenue Taxes 10,736,464 10,962,693 11,014,213 11,240,608 11,388,715 11,589,464 11,793,832 11,861,871 12,073,632 Intergovernmental2,235,395 2,296,435 2,512,487 2,608,659 2,703,232 2,753,618 2,810,013 2,862,436 2,920,906 Licenses & Permits315,862 364,499 336,000 539,500 413,500 388,500 388,500 388,500 388,500 Fines & Forfeits140,250 123,617 130,400 117,400 125,400 125,400 125,400 125,400 125,400 Charges for Service1,465,678 1,508,994 1,535,112 1,585,887 1,616,211 1,652,978 1,690,694 1,735,820 1,782,300 Investment Earnings21,197 49,018 20,000 80,000 80,000 76,495 64,555 51,021 29,359 Reimbursements66,449 85,579 55,000 54,000 75,000 75,000 75,000 75,000 75,000 Miscellaneous19,848 19,243 21,750 25,250 20,000 20,000 20,000 20,000 20,000 Other Financing Sources9,645 92,125 18,000 30,000 47,180 47,180 47,180 47,180 47,180 Total Revenue15,010,788 15,502,203 15,642,962 16,281,304 16,469,238 16,728,635 17,015,174 17,167,228 17,462,277 ExpendituresSalaries 4,212,964 4,522,164 4,901,639 4,782,655 5,206,755 5,482,410 5,701,586 5,929,253 6,165,723 Benefits2,635,062 2,905,833 3,056,457 2,923,040 3,273,617 3,532,710 3,737,769 3,993,959 4,266,327 Contractual Services4,796,367 4,767,096 5,047,691 5,213,855 5,193,468 5,281,279 5,223,106 5,167,256 5,273,758 Supplies194,947 245,057 345,098 322,338 464,998 421,970 426,666 431,597 436,775 Other Financing Uses2,649,065 2,779,764 3,044,911 3,039,217 2,330,400 2,586,243 2,969,276 3,190,286 2,931,155 Total Expenditures14,488,405 15,219,914 16,395,796 16,281,105 16,469,238 17,304,612 18,058,403 18,712,351 19,073,738 Surplus (Deficit)522,383 282,289 (752,834) 199 - (575,977)(1,043,229) (1,545,123) (1,611,461) Ending Fund Balance6,214,089 6,496,373 5,468,778 6,496,572 6,496,572 5,920,595 4,877,366 3,332,243 1,720,782 42.89% 42.68% 33.35% 39.90% 39.45% 34.21% 27.01% 17.81% 9.02%GENERAL FUND (01)The General Fund is the City’s primary operating fund. It accounts for major tax revenue used to support administrative and public safety functions. $0$2,000$4,000$6,000$8,000ThousandsFund Balance1 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjected01-000-40-00-4000 PROPERTY TAXES - CORPORATE LEVY2,206,9252,129,9842,191,2792,191,1592,119,3232,161,7092,204,9432,249,0422,294,02301-000-40-00-4010 PROPERTY TAXES - POLICE PENSION817,490963,908958,544958,4761,105,9271,155,9271,205,9271,255,9271,305,92701-000-40-00-4030 MUNICIPAL SALES TAX2,940,9763,002,1333,009,4753,090,0003,151,8003,214,8363,279,1333,344,7163,411,61001-000-40-00-4035 NON-HOME RULE SALES TAX2,259,7872,325,6232,339,5752,385,0002,432,7002,481,3542,530,9812,581,6012,633,23301-000-40-00-4040 ELECTRIC UTILITY TAX710,892702,111695,000720,000710,000710,000710,000710,000710,00001-000-40-00-4041 NATURAL GAS UTILITY TAX241,699251,555240,000260,000250,000250,000250,000250,000250,00001-000-40-00-4043 EXCISE TAX359,947334,595325,000325,000313,625302,648292,055281,833271,96901-000-40-00-4044TELEPHONE UTILITY TAX8,3408,3408,3408,3408,3408,3408,3408,3408,34001-000-40-00-4045 CABLE FRANCHISE FEES294,275290,669290,000290,000290,000290,000290,000290,000290,00001-000-40-00-4050 HOTEL TAX72,40779,60280,00080,00080,00080,00080,00080,00080,00001-000-40-00-4055 VIDEO GAMING TAX100,457119,733110,000140,000140,000140,000140,000140,000140,00001-000-40-00-4060 AMUSEMENT TAX200,284199,974200,000210,000205,000205,000205,000205,000205,00001-000-40-00-4065 ADMISSIONS TAX122,007130,766120,000148,133140,000140,000140,000- - 01-000-40-00-4070 BUSINESS DISTRICT TAX - KENDALL MRKT359,093374,631408,000375,000382,500390,150397,953405,912414,03001-000-40-00-4071 BUSINESS DISTRICT TAX - DOWNTOWN15,99224,66315,00035,00035,00035,00035,00035,00035,00001-000-40-00-4072 BUSINESS DISTRICT TAX - COUNTRYSIDE12,0719,86511,00010,00010,00010,00010,00010,00010,00001-000-40-00-4075 AUTO RENTAL TAX13,82214,54113,00014,50014,50014,50014,50014,50014,50001-000-41-00-4100 STATE INCOME TAX1,602,4101,640,2911,822,3081,870,0001,916,3661,954,6931,993,7872,033,6632,074,33601-000-41-00-4105 LOCAL USE TAX417,212474,797500,279555,000602,966615,025627,326639,873652,67001-000-41-00-4110 ROAD & BRIDGE TAX145,522131,612135,000128,668130,000130,000135,000135,000140,00001-000-41-00-4120 PERSONAL PROPERTY TAX17,84514,93217,00017,00017,00017,00017,00017,00017,00001-000-41-00-4160 FEDERAL GRANTS16,81011,71616,00016,00015,00015,00015,00015,00015,00001-000-41-00-416831,60622,20121,00018,69521,00021,00021,00021,00021,00001-000-41-00-4170 STATE GRANTS3,000- - 2,413- - - - - 01-000-41-00-4182 MISC INTERGOVERNMENTAL99088690088390090090090090001-000-42-00-4200LIQUOR LICENSES52,85256,46556,00056,00056,00056,00056,00056,00056,00001-000-42-00-4205 OTHER LICENSES & PERMITS6,7959,4725,0007,5007,5007,5007,5007,5007,50001-000-42-00-4210 BUILDING PERMITS256,215298,562275,000476,000350,000325,000325,000325,000325,00001-000-43-00-4310 CIRCUIT COURT FINES41,51244,59745,00045,00045,00045,00045,00045,00045,00001-000-43-00-4320 ADMINISTRATIVE ADJUDICATION33,51227,25030,00027,00030,00030,00030,00030,00030,00001-000-43-00-4323 OFFENDER REGISTRATION FEES42069540040040040040040040001-000-43-00-4325 POLICE TOWS64,80651,07555,00045,00050,00050,00050,00050,00050,00001-000-44-00-4400 GARBAGE SURCHARGE1,284,0441,135,0351,157,2251,195,0001,224,8751,255,4971,286,8841,325,4911,365,25601-000-44-00-4405 UB COLLECTION FEES 158,062163,782160,000175,000165,000165,000165,000165,000165,00001-000-44-00-4407 LATE PENALTIES - GARBAGE22,77221,21323,00021,00021,00021,00021,00021,00021,00001-000-44-00-4415 ADMINISTRATIVE CHARGEBACK- 188,064194,387194,387204,836210,981217,310223,829230,54401-000-44-00-4474 POLICE SPECIAL DETAIL800900500500500500500500500GENERAL FUND - 01DescriptionSTATE GRANTS - TRAFFIC SIGNAL MAINTENANCE2 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescription01-000-45-00-450021,19740,47920,00080,00080,00076,49564,55551,02129,35901-000-45-00-4550 GAIN ON INVESTMENT- 8,539- - - - - - - 01-000-46-00-4604 REIMB - ENGINEERING EXPENSES6,6841,15425,0001,00025,00025,00025,00025,00025,00001-000-46-00-4680 REIMB - LIABILITY INSURANCE9,21311,5825,0003,00010,00010,00010,00010,00010,00001-000-46-00-4685 REIMB - CABLE CONSORTIUM33,16335,21720,00035,00035,00035,00035,00035,00035,00001-000-46-00-4690 REIMB - MISCELLANEOUS17,38937,6265,00015,0005,0005,0005,0005,0005,00001-000-48-00-4820 RENTAL INCOME7,2857,1006,7507,0007,0007,0007,0007,0007,00001-000-48-00-4850 MISCELLANEOUS INCOME12,56312,14315,00018,25013,00013,00013,00013,00013,00001-000-49-00-4916 TRANSFER FROM CW MUNICIPAL BUILDING9,645 92,125 18,000 30,000 47,180 47,180 47,180 47,180 47,180 Revenue 15,010,78815,502,20315,642,96216,281,30416,469,23816,728,63517,015,17417,167,22817,462,277INVESTMENT EARNINGS3 FY 2019FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024Actual Actual Budget ProjectedAdoptedProjected Projected Projected ProjectedExpendituresSalaries460,265 518,618 579,552 573,500 600,095 616,238 632,865 649,991 667,631 Benefits161,660 201,497 224,357 216,600 220,528 234,679 249,957 266,327 283,870 Contractual Services140,692 131,910 141,990 141,607 131,949 134,672 136,496 139,185 143,054 Supplies7,563 8,832 10,000 10,000 10,000 10,000 10,000 10,000 10,000 Total Administration770,180 860,857 955,899 941,707 962,572 995,589 1,029,318 1,065,503 1,104,555 ADMINISTRATION DEPARTMENTThe Administration Department includes both elected official and management expenditures. The executive and legislative branches consist of the Mayor and an eight member City Council. The city administrator is hired by the Mayor with the consent of the City Council. City staff report to the city administrator. It is the role of the city administrator to direct staff in the daily administration of City services. $0$200$400$600$800$1,000$1,200Thousands4 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionAdministration01-110-50-00-5001 SALARIES - MAYOR 10,1759,97011,00010,00011,00011,00011,00011,00011,00001-110-50-00-5002 SALARIES - LIQUOR COMM1,0001,0001,0001,0001,0001,0001,0001,0001,00001-110-50-00-5003 SALARIES - CITY CLERK7,4407,0358,0007,500- - - - - 01-110-50-00-5004 SALARIES - CITY TREASURER1,0001,0001,0001,000- - - - - 01-110-50-00-5005 SALARIES - ALDERMAN46,46548,22552,00050,00050,00050,00050,00050,00050,00001-110-50-00-5010 SALARIES - ADMINISTRATION394,185451,388506,552504,000538,095554,238570,865587,991605,63101-110-52-00-5212 RETIREMENT PLAN CONTRIBUTION41,83348,54254,11951,50049,36752,26555,43158,79962,38001-110-52-00-5214 FICA CONTRIBUTION30,32435,30440,33940,33941,68642,93744,22545,55246,91901-110-52-00-5216 GROUP HEALTH INSURANCE82,328109,134120,465115,298120,064129,669140,043151,246163,34601-110-52-00-5222 GROUP LIFE INSURANCE49254345148042843243644044401-110-52-00-5223DENTAL INSURANCE5,9247,0137,8537,8537,8538,2468,6589,0919,54601-110-52-00-5224 VISION INSURANCE7599611,1301,1301,1301,1301,1641,1991,23501-110-54-00-5410 TUITION REIMBURSEMENT8,0405,11013,00012,864- - - - - 01-110-54-00-5412 TRAINING & CONFERENCES11,05116,06017,00017,00017,00017,00017,00017,00017,00001-110-54-00-5415 TRAVEL & LODGING12,09711,4089,0009,00010,00010,00010,00010,00010,00001-110-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK- - 4,5684,5681,6552,7782,9173,8315,83001-110-54-00-5426 PUBLISHING & ADVERTISING6,2192,5475,0005,0005,0005,0005,0005,0005,00001-110-54-00-5430 PRINTING & DUPLICATING2,3764,1393,2503,2503,2503,2503,2503,2503,25001-110-54-00-5440 TELECOMMUNICATIONS15,62317,63419,00019,00019,00019,00019,00019,00019,00001-110-54-00-5448 FILING FEES2125150050050050050050050001-110-54-00-5451CODIFICATION1,5792,8645,0005,0005,0005,0005,0005,0005,00001-110-54-00-5452 POSTAGE & SHIPPING1,2971,8023,0003,0003,0003,0003,0003,0003,00001-110-54-00-5460 DUES & SUBSCRIPTIONS16,25119,62017,00017,00020,00020,00020,00020,00020,00001-110-54-00-5462 PROFESSIONAL SERVICES28,26110,45112,00012,00012,00012,00012,00012,00012,00001-110-54-00-5480 UTILITIES16,95926,80019,61019,61020,78722,03423,35624,75726,24201-110-54-00-5485 RENTAL & LEASE PURCHASE2,1022,1022,4002,4003,0003,0003,0003,0003,00001-110-54-00-5488 OFFICE CLEANING18,62511,32211,66211,41511,75712,11012,47312,84713,23201-110-56-00-5610 OFFICE SUPPLIES7,563 8,832 10,000 10,000 10,000 10,000 10,000 10,000 10,000 770,180860,857955,899941,707962,572995,5891,029,3181,065,5031,104,5555 FY 2019FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024Actual Actual Budget ProjectedAdoptedProjected Projected Projected ProjectedExpendituresSalaries234,874 251,587 272,370 272,370 301,372 310,413 319,725 329,317 339,197 Benefits78,103 106,348 119,623 109,909 119,719 127,399 135,695 144,585 154,109 Contractual Services83,934 84,202 95,936 96,036 108,250 104,150 106,509 111,066 112,770 Supplies2,528 1,898 2,700 2,000 2,500 2,500 2,500 2,500 2,500 Total Finance399,439 444,035 490,629 480,315 531,841 544,462 564,429 587,468 608,576 FINANCE DEPARTMENTThe Finance Department is responsible for the accounting, internal controls, external reporting and auditing of all financial transactions. The Finance Department is in charge of preparing for the annual audit, utility billing, receivables, payables, treasury management and payroll and works with administration in the preparation of the annual budget. Personnel are budgeted in the General and Water Funds.$0$100$200$300$400$500$600$700Thousands6 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionFinance01-120-50-00-5010 SALARIES & WAGES 234,874251,587272,370272,370301,372310,413319,725329,317339,19701-120-52-00-5212 RETIREMENT PLAN CONTRIBUTION25,47327,11029,10029,10027,64929,27231,04532,93234,93701-120-52-00-5214 FICA CONTRIBUTION17,64718,77619,98819,98821,57422,22122,88823,57524,28201-120-52-00-5216 GROUP HEALTH INSURANCE28,33754,10264,39054,67664,35169,49975,05981,06487,54901-120-52-00-5222 GROUP LIFE INSURANCE33433424624624624825025325601-120-52-00-5223 DENTAL INSURANCE5,6555,3195,1925,1925,1925,4525,7256,0116,31201-120-52-00-5224 VISION INSURANCE65770770770770770772875077301-120-54-00-5412 TRAINING & CONFERENCES2,9113,5153,5003,5003,5003,5003,5003,5003,50001-120-54-00-5414 AUDITING SERVICES34,00029,00033,20029,80034,10035,00035,90040,00040,00001-120-54-00-5415 TRAVEL & LODGING2614461,0005001,0001,0001,0001,0001,00001-120-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK- - 2,8362,836- - 1,4591,9163,62001-120-54-00-5430 PRINTING & DUPLICATING2,5722,9893,5003,5003,5003,5003,5003,5003,50001-120-54-00-5440 TELECOMMUNICATIONS1,1501,1041,2501,2501,2501,2501,2501,2501,25001-120-54-00-5452 POSTAGE & SHIPPING1,0338971,2001,2001,2001,2001,2001,2001,20001-120-54-00-5460 DUES & SUBSCRIPTIONS1,0109851,2501,2501,5001,5001,5001,5001,50001-120-54-00-5462 PROFESSIONAL SERVICES39,002 43,325 46,000 50,000 60,000 55,000 55,000 55,000 55,000 01-120-54-00-5485 RENTAL & LEASE PURCHASE1,995 1,941 2,2002,2002,2002,2002,2002,2002,20001-120-56-00-5610 OFFICE SUPPLIES2,528 1,898 2,700 2,000 2,5002,500 2,5002,500 2,500 399,439444,035490,629480,315531,841544,462564,429587,468608,5767 FY 2019FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024Actual Actual Budget ProjectedAdoptedProjected Projected Projected ProjectedExpendituresSalaries2,780,763 2,911,083 3,151,723 3,050,500 3,349,248 3,572,027 3,736,742 3,908,313 4,087,004 Benefits1,728,589 1,915,338 1,960,422 1,885,459 2,175,164 2,365,372 2,534,141 2,714,316 2,906,978 Contractual Services297,858 341,253 405,411 340,581 270,613 281,339 260,664 263,766 277,326 Supplies96,715 115,879 127,560 125,500 128,500 131,650 134,958 138,431 142,078 Total Police 4,903,925 5,283,553 5,645,116 5,402,040 5,923,525 6,350,388 6,666,505 7,024,826 7,413,386 POLICE DEPARTMENTThe mission of the Yorkville Police Department is to work in partnership with the community to protect life and property, assist neighborhoods with solving their problems and enhance the quality of life in our City.$0$1,000$2,000$3,000$4,000$5,000$6,000$7,000$8,000Thousands8 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionPolice01-210-50-00-5008 SALARIES - POLICE OFFICERS 1,542,8001,652,6721,775,1161,695,0001,924,2242,110,5072,237,6312,370,4842,509,29501-210-50-00-5011 SALARIES - POLICE CHIEF & DEPUTIES351,000365,716385,551447,500396,159408,044420,285432,894445,88101-210-50-00-5012 SALARIES - SERGEANTS577,455588,265616,592578,000644,811664,155684,080704,602725,74001-210-50-00-5013 SALARIES - POLICE CLERKS136,050141,996169,464162,500175,554180,821186,246191,833197,58801-210-50-00-5014 SALARIES - CROSSING GUARD23,43724,85524,00027,50027,50027,50027,50027,50027,50001-210-50-00-5015 PART-TIME SALARIES50,18039,96170,00040,00070,00070,00070,00070,00070,00001-210-50-00-5020 OVERTIME99,84197,618111,000100,000111,000111,000111,000111,000111,00001-210-52-00-5212 RETIREMENT PLAN CONTRIBUTION14,66115,19218,10518,10516,10617,05118,08419,18320,35201-210-52-00-5213825,413966,211963,361963,3611,111,4841,161,4841,211,4841,261,4841,311,48401-210-52-00-5214 FICA CONTRIBUTION204,346215,493234,853222,000245,951262,579275,338288,626302,46401-210-52-00-5216 GROUP HEALTH INSURANCE626,179659,332686,289626,752741,025856,732956,2701,066,2511,187,70901-210-52-00-5222 GROUP LIFE INSURANCE3,4163,6202,6192,3212,7482,9413,0543,1703,28801-210-52-00-5223 DENTAL INSURANCE48,64648,89648,43446,45250,77057,03361,88967,08872,65301-210-52-00-5224 VISION INSURANCE5,9286,5946,7616,4687,0807,5528,0228,5149,02801-210-54-00-5410 TUITION REIMBURSEMENT9,8328,44215,00015,00017,27217,2724,0062,8002,80001-210-54-00-5411 POLICE COMMISSION 3,19813,8444,0004,0004,00015,0004,0004,00015,00001-210-54-00-5412 TRAINING & CONFERENCE12,43316,86221,00021,00021,00021,00021,00021,00021,00001-210-54-00-5415 TRAVEL & LODGING1,2537,54110,00010,00010,00010,00010,00010,00010,00001-210-54-00-5422 VEHICLE & EQUIPMENT CHARGEBACK97,459130,208140,24194,68724,03225,10025,10025,10025,10001-210-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK- - 9,3589,3584,3012,6065,8349,76811,94301-210-54-00-5430PRINTING & DUPLICATING7,9315,7134,5004,5004,5004,5004,5004,5004,50001-210-54-00-5440 TELECOMMUNICATIONS35,13034,98536,50038,50040,00040,00040,00040,00040,00001-210-54-00-5452 POSTAGE & SHIPPING1,1299441,6001,6001,6001,6001,6001,6001,60001-210-54-00-5460 DUES & SUBSCRIPTIONS9,1005,9855,3008,7759,0009,0009,0009,0009,00001-210-54-00-5462 PROFESSIONAL SERVICES22,31828,57630,00030,00030,00030,00030,00030,00030,00001-210-54-00-5467 ADJUDICATION SERVICES18,56012,87120,00020,00020,00020,00020,00020,00020,00001-210-54-00-5469 NEW WORLD & LIVE SCAN12,4891,99519,5001,9952,0002,0002,0002,0002,00001-210-54-00-5472 KENDALL CO JUVE PROBATION3,2393,5844,0004,0004,0004,0004,0004,0004,00001-210-54-00-5484 MDT - ALERTS FEE6,6606,6607,000- - - - - - 01-210-54-00-5485 RENTAL & LEASE PURCHASE6,0105,3625,7505,7507,1507,1507,1507,1507,15001-210-54-00-5488 OFFICE CLEANING- 11,32311,66211,41611,75812,11112,47412,84813,23301-210-54-00-5495 OUTSIDE REPAIR & MAINTENANCE51,11746,35860,00060,00060,00060,00060,00060,00060,00001-210-56-00-5600 WEARING APPAREL10,64112,31215,00015,00015,00015,00015,00015,00015,00001-210-56-00-5610 OFFICE SUPPLIES1,8832,6694,5004,5004,5004,5004,5004,5004,50001-210-56-00-5620 OPERATING SUPPLIES9,72713,02916,00016,00016,00016,00016,00016,00016,00001-210-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE5,96113,10312,50012,50012,50012,50012,50012,50012,50001-210-56-00-5650 COMMUNITY SERVICES1,0121,8831,5001,5001,5001,5001,5001,5001,50001-210-56-00-5690 BALISTIC VESTS4,6364,1496,0006,0006,0006,0006,0006,0006,000EMPLOYER CONTRIBUTION - POLICE PENSION9 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescription01-210-56-00-5695 GASOLINE54,93358,73962,06060,00063,00066,15069,45872,93176,57801-210-56-00-5696 AMMUNITION7,922 9,995 10,000 10,000 10,000 10,000 10,000 10,000 10,000 4,903,925 5,283,553 5,645,116 5,402,040 5,923,525 6,350,388 6,666,505 7,024,826 7,413,386 10 FY 2019FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024Actual Actual Budget ProjectedAdoptedProjected Projected Projected ProjectedExpendituresSalaries374,208 427,777 488,585 467,355 520,619 536,238 552,325 568,895 585,962 Benefits138,585 151,538 179,347 167,773 184,592 196,118 208,564 221,884 236,139 Contractual Services52,914 44,147 154,174 274,159 217,523 249,327 159,159 164,105 164,108 Supplies8,251 6,431 7,540 7,540 7,655 7,775 7,901 8,034 8,173 Total Community Development573,958 629,893 829,646 916,827 930,389 989,458 927,949 962,918 994,382 COMMUNITY DEVELOPMENT DEPARTMENTThe primary focus of the Community Development Department is to ensure that all existing and new construction is consistent with the overall development goals of the City which entails short and long-range planning, administration of zoning regulations, building permits issuance and code enforcement. The department also provides staff support to the City Council, Plan Commission, Zoning Board of Appeals and Park Board and assists in the review of all development plans proposed within the United City of Yorkville.$0$200$400$600$800$1,000$1,200Thousands11 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionCommunity Development01-220-50-00-5010 SALARIES & WAGES 331,861408,213440,585464,500520,619536,238552,325568,895585,96201-220-50-00-5015 PART-TIME SALARIES42,34719,56448,0002,855- - - - - 01-220-52-00-5212 RETIREMENT PLAN CONTRIBUTION35,45443,85147,07147,07147,76350,56753,63156,89060,35401-220-52-00-5214 FICA CONTRIBUTION27,58531,81336,50436,50438,31739,46740,65141,87143,12701-220-52-00-5216 GROUP HEALTH INSURANCE69,88969,02188,82777,02290,47197,709105,526113,968123,08501-220-52-00-5222 GROUP LIFE INSURANCE40149139339342943343744144501-220-52-00-5223 DENTAL INSURANCE4,6695,5905,7065,8936,6036,9337,2807,6448,02601-220-52-00-5224 VISION INSURANCE5877728468901,0091,0091,0391,0701,10201-220-54-00-5412 TRAINING & CONFERENCES1,5374,8767,3007,3007,3007,3007,3007,3007,30001-220-54-00-5415 TRAVEL & LODGING2197,6776,5006,5006,5006,5006,5006,5006,50001-220-54-00-5422 VEHICLE & EQUIPMENT CHARGEBACK- - 40,00044,985- - - - - 01-220-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK- - 3,6243,6241,3233,1271,4594,4054,40801-220-54-00-5426 PUBLISHING & ADVERTISING3,6592,1692,5002,5002,5002,5002,5002,5002,50001-220-54-00-5430 PRINTING & DUPLICATING8831,3671,5001,5001,5001,5001,5001,5001,50001-220-54-00-5440 TELECOMMUNICATIONS4,0084,0984,0004,0004,0004,0004,0004,0004,00001-220-54-00-5452 POSTAGE & SHIPPING5355911,0001,0001,0001,0001,0001,0001,00001-220-54-00-5459 INSPECTIONS5951,7855,000150,000125,000125,000125,000125,000125,00001-220-54-00-5460 DUES & SUBSCRIPTIONS2,2222,1412,1002,1002,7502,7502,7502,7502,75001-220-54-00-5462 PROFESSIONAL SERVICES36,12416,31177,50047,50062,50092,5004,0006,0006,00001-220-54-00-5485 RENTAL & LEASE PURCHASE3,1323,1323,1503,1503,1503,1503,1503,1503,15001-220-56-00-5610 OFFICE SUPPLIES1,7421,7071,5001,5001,5001,5001,5001,5001,50001-220-56-00-5620 OPERATING SUPPLIES4,8292,6993,7503,7503,7503,7503,7503,7503,75001-220-56-00-5695 GASOLINE1,680 2,025 2,290 2,290 2,4052,525 2,6512,784 2,923 573,958 629,893 829,646 916,827 930,389 989,458 927,949 962,918 994,382 12 FY 2019FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024Actual Actual Budget ProjectedAdoptedProjected Projected Projected ProjectedExpendituresSalaries362,054 395,459 408,909 418,430 434,921 446,994 459,429 472,237 485,429 Benefits196,446 196,203 197,100 195,937 193,915 206,615 220,332 235,041 250,817 Contractual Services1,450,218 1,239,831 1,304,948 1,357,544 1,385,782 1,407,246 1,443,720 1,483,816 1,526,881 Supplies68,784 97,088 182,298 162,298 301,343 255,045 256,307 257,632 259,024 Total Public Works 2,077,502 1,928,581 2,093,255 2,134,209 2,315,961 2,315,900 2,379,788 2,448,726 2,522,151 PUBLIC WORKS DEPARTMENT - STREET OPERATIONS / HEALTH & SANITATIONThe Public Works Department is an integral part of the United City of Yorkville. We provide high quality drinking water, efficient disposal of sanitary waste and maintain a comprehensive road and storm sewer network to ensure the safety and quality of life for the citizens of Yorkville.$0$500$1,000$1,500$2,000$2,500$3,000Thousands13 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionPublic Works - Street Operations01-410-50-00-5010 SALARIES & WAGES 339,927360,757382,309380,000402,421414,494426,929439,737452,92901-410-50-00-5015 PART-TIME SALARIES8,4558,55011,60013,43012,50012,50012,50012,50012,50001-410-50-00-5020 OVERTIME13,67226,15215,00025,00020,00020,00020,00020,00020,00001-410-52-00-5212 RETIREMENT PLAN CONTRIBUTION37,76841,33742,44842,44838,75440,97343,39745,97448,71201-410-52-00-5214 FICA CONTRIBUTION26,60829,27130,16130,16131,90232,85933,84534,86035,90601-410-52-00-5216 GROUP HEALTH INSURANCE121,383116,109115,626114,472114,394123,546133,430144,104155,63201-410-52-00-5222 GROUP LIFE INSURANCE61059443742843744144544945301-410-52-00-5223 DENTAL INSURANCE9,0107,8277,3637,3637,3637,7318,1188,5248,95001-410-52-00-5224 VISION INSURANCE1,0671,0651,0651,0651,0651,0651,0971,1301,16401-410-54-00-5412 TRAINING & CONFERENCES2,8952,6033,0003,0003,0003,0003,0003,0003,00001-410-54-00-5415 TRAVEL & LODGING1,1577062,0002,0002,0002,0002,0002,0002,00001-410-54-00-5422 VEHICLE & EQUIPMENT CHARGEBACK63,626- - - - - - 2,8264,63501-410-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK- - 1,5231,5232,5008693,4131,2831,95001-410-54-00-5435 TRAFFIC SIGNAL MAINTENANCE18,8718,79520,00020,00030,00020,00020,00020,00020,00001-410-54-00-5440 TELECOMMUNICATIONS2,7513,4333,5003,5003,7503,7503,7503,7503,75001-410-54-00-5455 MOSQUITO CONTROL7,1427,1427,4996,2816,2816,5956,9257,2717,63501-410-54-00-5458 TREE & STUMP MAINTENANCE8,9805,72515,00015,00015,00015,00015,00015,00015,00001-410-54-00-5462 PROFESSIONAL SERVICES6,4283,0894,0004,0006,8256,8256,8256,8256,82501-410-54-00-5482 STREET LIGHTING4264009,000500- - - - - 01-410-54-00-5483 JULIE SERVICES- - 3,0001,2503,0003,0003,0003,0003,00001-410-54-00-5485 RENTAL & LEASE PURCHASE6,1621,2386,0006,0006,0006,0006,0006,0006,00001-410-54-00-5488 OFFICE CLEANING- 1,1641,1991,0201,0511,0831,1151,1481,18201-410-54-00-5490 VEHICLE MAINTENANCE SERVICES30,385 64,919 55,000 85,000 65,000 65,000 65,000 65,000 65,000 01-410-56-00-5600 WEARING APPAREL4,6206,6325,1005,1005,1005,1005,1005,1005,10001-410-56-00-5618 SALT & CALCIUM CHLORIDE- - - - 157,500120,000120,000120,000120,00001-410-56-00-5619 SIGNS- - 15,00015,000- - - - - 01-410-56-00-5620 OPERATING SUPPLIES5,28718,83225,10025,10023,00023,00023,00023,00023,00001-410-56-00-5628 VEHICLE MAINTENANCE SUPPLIES27,44127,12530,00030,00030,00030,00030,00030,00030,00001-410-56-00-5630 SMALL TOOLS & EQUIPMENT3,2703,2886,0006,00018,5008,5008,5008,5008,50001-410-56-00-5632 ASPHALT PATCHING- - 35,00015,000- - - - - 01-410-56-00-5640 REPAIR & MAINTENANCE12,77519,33925,00025,00025,00025,00025,00025,00025,00001-410-56-00-5642 STREET LIGHTING SUPPLIES- - 17,00017,00017,00017,00017,00017,00017,00001-410-56-00-5665 JULIE SUPPLIES- - 1,2001,2001,2001,2001,2001,2001,20001-410-56-00-5695 GASOLINE15,391 21,872 22,898 22,898 24,043 25,245 26,507 27,832 29,224 776,107787,964919,028925,7391,074,5861,041,7761,072,0961,102,0131,135,24714 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionPublic Works - Health & Sanitation01-540-54-00-5441 GARBAGE SERVICES - SENIOR SUBSIDY 35,10331,14732,08933,25034,08134,93335,80636,88037,98601-540-54-00-5442 GARBAGE SERVICES1,262,2121,105,6301,137,1381,168,5001,200,2941,232,1911,264,8861,302,8331,341,91801-540-54-00-5443 LEAF PICKUP4,080 3,840 5,000 6,720 7,0007,000 7,0007,000 7,000 1,301,395 1,140,617 1,174,227 1,208,470 1,241,375 1,274,124 1,307,692 1,346,713 1,386,904 2,077,502 1,928,581 2,093,255 2,134,209 2,315,961 2,315,900 2,379,788 2,448,726 2,522,151 Total Public Works15 FY 2019FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024Actual Actual Budget ProjectedAdoptedProjected Projected Projected ProjectedExpendituresSalaries800 17,640 500 500 500 500 500 500 500 Benefits331,679 334,909 375,608 347,362 379,699 402,527 389,080 411,806 434,414 Contractual Services2,770,751 2,925,753 2,945,232 3,003,928 3,079,351 3,104,545 3,116,558 3,005,318 3,049,619 Supplies11,106 14,929 15,000 15,000 15,000 15,000 15,000 15,000 15,000 Other Financing Uses2,649,065 2,779,764 3,044,911 3,039,217 2,330,400 2,586,243 2,969,276 3,190,286 2,931,155 Total Admin Services & Transfers5,763,401 6,072,995 6,381,251 6,406,007 5,804,950 6,108,815 6,490,414 6,622,910 6,430,688 ADMINISTRATIVE SERVICES DEPARTMENTThe Administrative Services Department accounts for General Fund expenditures that are shared by all departments and cannot be easily classified in one department or the other. These expenditures include such items as tax rebates, bad debt, engineering services, corporate legal expenditures and interfund transfers. $5,200$5,400$5,600$5,800$6,000$6,200$6,400$6,600$6,800Thousands16 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionAdministrative Services01-640-50-00-5016 SALARIES - SPECIAL CENSUS - 16,740- - - - - - - 01-640-50-00-5092 POLICE SPECIAL DETAIL WAGES80090050050050050050050050001-640-52-00-5214 FICA CONTRIBUTION - SPECIAL CENSUS- 1,281- - - - - - - 01-640-52-00-5230 UNEMPLOYMENT INSURANCE11,2986,40220,00010,00015,00015,00015,00015,00015,00001-640-52-00-5231 LIABILITY INSURANCE286,792294,582313,712295,466316,374335,356355,477376,806399,41401-640-52-00-5240 RETIREES - GROUP HEALTH INSURANCE33,25531,85741,36741,36747,79651,62018,45820,00020,00001-640-52-00-5241 RETIREES - DENTAL INSURANCE260554449449449471124- - 01-640-52-00-5242 RETIREES - VISION INSURANCE742338080808021- - 01-640-54-00-5418 PURCHASING SERVICES5,18754,53553,41943,39350,46552,36554,35456,43858,62301-640-54-00-5423 IDOR ADMINISTRATION FEE- 51,94557,35743,91844,68945,47846,28747,11447,96101-640-54-00-5427 GC HOUSING RENTAL ASSISTANCE- 1,03412,0006,4387,8008,5809,43810,38211,42001-640-54-00-5428 UTILITY TAX REBATE- 14,37514,37513,25014,37514,37514,375- - 01-640-54-00-5432 FACILITY MANAGEMENT SERVICES- 1,07250,00054,13057,42559,14660,92362,75564,64601-640-54-00-5439 AMUSEMENT TAX REBATE61,61347,72360,00050,00060,00060,00030,00030,00030,00001-640-54-00-5449 KENCOM74,842119,698110,958110,958126,109147,320157,591168,204179,17101-640-54-00-5450 INFORMATION TECHNOLOGY SERVICES117,691203,809136,000225,000225,000225,000225,000225,000225,00001-640-54-00-5456 CORPORATE COUNSEL102,82599,701110,000120,000115,000115,000115,000115,000115,00001-640-54-00-5461 LITIGATION COUNSEL211,454188,411120,00080,000120,000120,000120,000120,000120,00001-640-54-00-5462 PROFESSIONAL SERVICES- - - 20,00027,000- - - - 01-640-54-00-5463 SPECIAL COUNSEL4,8159,51120,00035,00025,00025,00025,00025,00025,00001-640-54-00-5465 ENGINEERING SERVICES350,899379,663390,000390,000390,000390,000390,000390,000390,00001-640-54-00-5473 KENDALL AREA TRANSIT23,55023,55025,00023,55025,00025,00025,00025,00025,00001-640-54-00-5475 CABLE CONSORTIUM FEE92,76596,01092,00096,00096,00096,00096,00096,00096,00001-640-54-00-5478 SPECIAL CENSUS108,0933,349- - - - - - - 01-640-54-00-5481 HOTEL TAX REBATE65,16671,64272,00072,00072,00072,00072,00072,00072,00001-640-54-00-5486ECONOMIC DEVELOPMENT160,359145,989145,000160,225146,000146,000146,000146,000146,00001-640-54-00-5491 CITY PROPERTY TAX REBATE1,2861,2331,5001,2331,5001,5001,5001,5001,50001-640-54-00-5492 SALES TAX REBATE879,408879,122928,303895,000912,900931,158949,781968,777988,15301-640-54-00-5493 BUSINESS DISTRICT REBATE 387,157401,611425,320413,700421,088428,623436,309444,148452,14501-640-54-00-5494 ADMISSIONS TAX REBATE122,007130,766120,000148,133140,000140,000140,000- - 01-640-54-00-5499 BAD DEBT1,6341,0042,0002,0002,0002,0002,0002,0002,00001-640-56-00-5625 REIMBURSABLE REPAIRS11,10614,92915,00015,00015,00015,00015,00015,00015,00001-640-99-00-9915 TRANSFER TO MOTOR FUEL TAX33,750268- - - - - - - 01-640-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL71,602- 569,725569,725- 95,756- - - 01-640-99-00-9942 TRANSFER TO DEBT SERVICE266,979309,972318,725314,725319,379318,579324,729325,429- 01-640-99-00-9952 TRANSFER TO SEWER1,134,0521,137,166856,583856,583575,030586,749994,4791,135,9641,134,60617 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescription01-640-99-00-9979 TRANSFER TO PARKS & RECREATION1,118,6381,308,5831,274,6991,274,6991,410,9881,558,7011,622,0681,699,2581,765,18101-640-99-00-9982 TRANSFER TO LIBRARY OPERATIONS24,044 23,775 25,179 23,485 25,003 26,458 28,000 29,635 31,368 5,763,4016,072,9956,381,251 6,406,007 5,804,950 6,108,815 6,490,414 6,622,910 6,430,688 Expenditures14,488,40515,219,91416,395,79616,281,10516,469,23817,304,61218,058,40318,712,35119,073,738Surplus(Deficit)522,383282,289(752,834) 199- (575,977) (1,043,229) (1,545,123) (1,611,461) Fund Balance6,214,0896,496,3735,468,7786,496,5726,496,5725,920,5954,877,3663,332,2431,720,78242.89%42.68%33.35%39.90%39.45%34.21%27.01%17.81%9.02%18 FY 2019 FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 7,263 9,366 13,381 13,381 13,381 13,381 13,381 13,381 13,381 Other Financing Sources 22,000 - - - - - - - - Total Revenue 29,263 9,366 13,381 13,381 13,381 13,381 13,381 13,381 13,381 Expenditures Contractual Services 10,741 17,552 8,835 8,835 30,977 10,326 10,482 10,646 12,258 Total Expenditures 10,741 17,552 8,835 8,835 30,977 10,326 10,482 10,646 12,258 Surplus (Deficit)18,522 (8,186) 4,546 4,546 (17,596) 3,055 2,899 2,735 1,123 Ending Fund Balance 14,742 6,556 9,954 11,102 (6,494) (3,439) (540) 2,195 3,318 137.25%37.35%112.67%125.66%-20.96%-33.30%-5.15%20.62%27.07% Fox Hill SSA Fund (11) This fund was created for the purpose of maintaining the common areas of the Fox Hill Estates (SSA 2004-201) subdivision. All money for the fund is derived from property taxes levied on homeowners in the subdivision. -534.828 -2374.704 270.222 -1131.924 -1068.555 ($3,000) ($2,500) ($2,000) ($1,500) ($1,000) ($500) $0 $500 ThousandsFund Balance ($10) $0 $10 $20 ThousandsFund Balance 19 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionFox Hill SSA - 1111-000-40-00-4000 PROPERTY TAXES7,2639,36613,38113,38113,38113,38113,38113,38113,38111-000-49-00-4910 SALE OF CAPITAL ASSETS22,000- -- -- -- - Revenue 29,2639,36613,38113,38113,38113,38113,38113,38113,38111-111-54-00-5462 PROFESSIONAL SERVICES- 2,138 2,835 2,835 2,977 3,126 3,282 3,446 3,618 11-111-54-00-5495 OUTSIDE REPAIR & MAINTENANCE10,741 15,414 6,000 6,000 28,000 7,200 7,200 7,200 8,640 Expenditures 10,74117,5528,8358,83530,97710,32610,48210,64612,258Surplus(Deficit)18,522(8,186) 4,5464,546(17,596) 3,0552,8992,7351,123Fund Balance14,7426,5569,95411,102(6,494) (3,439) (540) 2,1953,318137.25%37.35%112.67%125.66%-20.96%-33.30%-5.15%20.62%27.07%20 FY 2019 FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 20,456 13,480 15,637 15,639 18,140 21,304 21,304 21,304 21,304 Total Revenue 20,456 13,480 15,637 15,639 18,140 21,304 21,304 21,304 21,304 Expenditures Contractual Services 5,057 18,957 18,835 18,835 13,977 15,326 15,482 15,646 17,258 Total Expenditures 5,057 18,957 18,835 18,835 13,977 15,326 15,482 15,646 17,258 Surplus (Deficit)15,399 (5,477) (3,198) (3,196) 4,163 5,978 5,822 5,658 4,046 Ending Fund Balance (15,774) (21,251) (28,236) (24,447) (20,284) (14,306) (8,484) (2,826) 1,220 -311.92%-112.10%-149.91%-129.80%-145.12%-93.34%-54.80%-18.06%7.07% This fund was created for the purpose of maintaining the common areas of the Sunflower Estates (SSA 2006-119) subdivision. All money for the fund is derived from property taxes levied on homeowners in the subdivision. Sunflower SSA Fund (12) ($30) ($20) ($10) $0 $10 ThousandsFund Balance 21 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionSunflower SSA - 1212-000-40-00-4000 PROPERTY TAXES20,456 13,480 15,637 15,639 18,140 21,304 21,304 21,304 21,304 Revenue 20,45613,48015,63715,63918,14021,30421,30421,30421,30412-112-54-00-5416POND MAINTENANCE2,512 5,095 5,000 5,000 5,000 5,000 5,000 5,000 5,000 12-112-54-00-5462 PROFESSIONAL SERVICES- 2,138 2,835 2,835 2,977 3,126 3,282 3,446 3,618 12-112-54-00-5495 OUTSIDE REPAIR & MAINTENANCE2,545 11,724 11,000 11,000 6,000 7,200 7,200 7,200 8,640 Expenditures 5,05718,95718,83518,83513,97715,32615,48215,64617,258Surplus(Deficit)15,399(5,477) (3,198) (3,196) 4,1635,9785,8225,6584,046Fund Balance(15,774) (21,251) (28,236) (24,447) (20,284) (14,306) (8,484) (2,826) 1,220-311.92%-112.10%-149.91%-129.80%-145.12%-93.34%-54.80%-18.06%7.07%22 FY 2019 FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Intergovernmental 470,816 495,510 530,817 537,422 525,084 534,766 544,641 554,714 564,988 Investment Earnings 3,556 8,475 5,000 15,000 9,820 5,900 2,677 576 - Other Financing Sources 33,750 268 - - - - - - - Total Revenue 508,122 504,253 535,817 552,422 534,904 540,666 547,318 555,290 564,988 Expenditures Contractual Services 105,673 98,120 97,000 97,000 - - - - - Supplies 119,661 126,075 90,000 90,000 - - - - - Capital Outlay 373,787 373,787 504,787 433,788 718,788 718,788 693,788 650,745 591,184 Total Expenditures 599,121 597,982 691,787 620,788 718,788 718,788 693,788 650,745 591,184 Surplus (Deficit)(90,999) (93,729) (155,970) (68,366) (183,884) (178,122) (146,470) (95,455) (26,196) Ending Fund Balance 792,224 698,493 428,536 630,127 446,243 268,121 121,651 26,196 - Motor Fuel Tax Fund (15) The Motor Fuel Tax Fund is used to maintain existing and construct new City owned roadways, alleys and parking lots. The fund also purchases materials used in the maintenance and operation of those facilities. $0 $200 $400 $600 $800 $1,000 ThousandsFund Balance 23 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionMotor Fuel Tax - 1515-000-41-00-4112 MOTOR FUEL TAX 428,888454,449489,817489,817484,084493,766503,641513,714523,98815-000-41-00-4113 MFT HIGH GROWTH41,92841,06141,00047,60541,00041,00041,00041,00041,00015-000-45-00-45003,5568,4755,00015,0009,8205,9002,677576- 15-000-49-00-4901 TRANSFER FROM GENERAL33,750 268- -- -- -- Revenue 508,122504,253535,817552,422534,904540,666547,318555,290564,98815-155-54-00-5438 SALT STORAGE7,750 7,750 - - - - - - - 15-155-54-00-5482 STREET LIGHTING97,923 90,370 97,00097,000- - - - - 15-155-56-00-5618 SALT64,39684,01590,00090,000- - - - - 15-155-56-00-5619 SIGNS15,6409,171- - - - - - - 15-155-56-00-5632 ASPHALT PATCHING24,24421,653- - - - - - - 15-155-56-00-5642 STREET LIGHTING SUPPLIES15,38111,236- - - - - - - 15-155-60-00-6004 BASELINE ROAD BRIDGE REPAIRS- - 25,000- 25,00025,000- - - 15-155-60-00-6025 ROAD TO BETTER ROADS PROGRAM300,000300,000406,000360,000620,000620,000620,000620,000591,18415-155-60-00-6079 ROUTE 47 EXPANSION73,787 73,787 73,787 73,788 73,788 73,788 73,788 30,745- Expenditures 599,121597,982691,787620,788718,788718,788693,788650,745591,184Surplus(Deficit)(90,999) (93,729) (155,970) (68,366) (183,884) (178,122) (146,470) (95,455) (26,196) Fund Balance792,224698,493428,536630,127446,243268,121121,65126,196- INVESTMENT EARNINGS24 FY 2019FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024Actual Actual BudgetProjectedAdoptedProjected Projected Projected ProjectedRevenue Intergovernmental534,354 206,028 - 32,879- - - - - Licenses & Permits196,003 448,616 91,500 340,000 152,180 152,180 152,180 152,180 152,180 Charges for Service718,872 731,535 730,000 746,500 746,500 750,000 755,000 755,000 760,000 Investment Earnings3,703 21,033 1,000 37,500 7,500 5,000 5,000 5,000 5,000 Reimbursements199,851 373,768 1,109,077 1,295,882 3,013,849 7,549 - - 171,600 Miscellaneous- - 2,000 - 2,000 2,000 2,000 2,000 2,000 Other Financing Sources73,502 1,018,308 569,725 569,725 - 95,756- - - Total Revenue1,726,285 2,799,288 2,503,302 3,022,486 3,922,029 1,012,485 914,180 914,180 1,090,780 ExpendituresContractual Services 115,923 339,391 221,675 143,214 334,795 190,964 197,503 204,435 211,783 Supplies 28,653 18,945 32,000 70,000 82,000 82,000 82,000 82,000 82,000 Capital Outlay 2,816,305 2,846,631 2,197,774 2,140,854 3,657,339 228,108 110,334 80,000 251,600 Debt Service 404,138 403,588 407,563 407,563 322,188 321,338 315,338 319,338 313,038 Other Financing Uses 9,645 157,366 82,866 95,030 152,086 151,075 151,738 151,389 151,807 Total Expenditures 3,374,664 3,765,921 2,941,878 2,856,661 4,548,408 973,485 856,913 837,162 1,010,228 Surplus (Deficit)(1,648,379) (966,633) (438,576) 165,825 (626,379) 39,000 57,267 77,018 80,552 Ending Fund Balance1,355,530 388,897 (30,817) 554,722 (71,657) (32,657) 24,610 101,628 182,180 City-Wide Capital Fund (23)The City-Wide Capital Fund is used to maintain existing and construct new public and municipal infrastructure, and to fund other improvements that benefit the public. ($500)$0$500$1,000$1,500ThousandsFund Balance25 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionCity-Wide Capital - 2323-000-41-00-4161 FEDERAL GRANTS - ITEP DOWNTOWN31,109540- - - - - - - 23-000-41-00-4169 FEDERAL GRANTS -MILL STREET LAFO24,606(1,306) - - - - - - - 23-000-41-00-4178 FEDERAL GRANTS - ITEP KENNEDY RD TRAIL2,475223,344- - - - - - - 23-000-41-00-4188476,164(16,550) - 32,879- - - - - 23-000-42-00-4210 BUILDING PERMITS35,365139,758- 25,000- - - - - 23-000-42-00-4214 DEVELOPMENT FEES - CW CAPITAL1,085 6,929 3,500 5,000 5,000 5,000 5,000 5,000 5,000 23-000-42-00-4216 BUILD PROGRAM PERMITS61,908 95,804 - - - - - - - 23-000-42-00-4218 DEVELOPMENT FEES - MUNICIPAL BLDG9,645 92,125 18,000 30,000 47,180 47,180 47,180 47,180 47,180 23-000-42-00-4222 ROAD CONTRIBUTION FEE88,000 114,000 70,000 280,000 100,000 100,000 100,000 100,000 100,000 23-000-44-00-4440 ROAD INFRASTRUCTURE FEE718,872 731,535 730,000746,500746,500750,000755,000755,000760,00023-000-45-00-45003,70310,2711,00037,5007,5005,0005,0005,0005,00023-000-45-00-4550 GAIN ON INVESTMENT- 10,762- - - - - - - 23-000-46-00-4607 REIMB - BLACKBERRY WOODS131,5747,7977,5497,5497,5497,549- - - 23-000-46-00-4608 REIMB - KENNEDY ROAD IMPROVEMENTS- 160,000- - - - - - - 23-000-46-00-4612 REIMB - MILL ROAD IMPROVEMENTS- - - 215,0002,926,300- - - - 23-000-46-00-4618 REIMB - BRISTOL BAY ANNEX- - - - - - - - 171,60023-000-46-00-4621 REIMB - FOUNTAIN VILLAGE- 19,346256,528256,528- - - - - 23-000-46-00-4624 REIMB - WHISPERING MEADOWS- 2,762800,000797,238- - - - - 23-000-46-00-4630 REIMB - STAGECOACH CROSSING63,404- - - - - - - - 23-000-46-00-4660 REIMB - PUSH FOR THE PATH1,413182,03329,00017,967- - - - - 23-000-46-00-4690 REIMB - MISCELLANEOUS 3,4601,83016,0001,60080,000- - - - 23-000-48-00-4845 DONATIONS- - 2,000- 2,0002,0002,0002,0002,00023-000-49-00-4910 SALE OF CAPITAL ASSETS1,900- - - - - - - - 23-000-49-00-4923 TRANSFER FROM GENERAL 71,602- 569,725569,725- 95,756- - - 23-000-49-00-4951 TRANSFER FROM WATER- 1,018,308- -- -- -- Revenue 1,726,2852,799,2882,503,3023,022,4863,922,0291,012,485914,180914,1801,090,780City-Wide - Building & Grounds Expenditures23-216-54-00-5405 BUILD PROGRAM4,8509,956- - - - - - - 23-216-54-00-5446 PROPERTY & BLDG MAINT SERVICES43,755193,257150,00075,000225,00075,00075,00075,00075,00023-216-54-00-5482 STREET LIGHTING- - - - 102,820108,989115,528122,460129,80823-216-56-00-5626 HANGING BASKETS- - 2,000- 2,0002,0002,0002,0002,00023-216-56-00-5619 SIGNS- - - - 15,00015,00015,00015,00015,00023-216-56-00-5656 PROPERTY & BLDG MAINT SUPPLIES27,84717,99725,00050,00025,00025,00025,00025,00025,00023-216-60-00-6013 BEECHER CENTER- - 319,725320,386- - - - - STATE GRANTS - EDP WRIGLEY (RTE 47)INVESTMENT EARNINGS26 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescription23-216-60-00-6020 BUILDINGS & STRUCTURES- - 40,00013,75041,250- - - - 23-216-99-00-9901 TRANSFER TO GENERAL9,645 92,125 18,000 30,000 47,180 47,180 47,180 47,180 47,180 86,097313,335554,725489,136458,250273,169279,708286,640293,988City-Wide Capital Expenditures23-230-54-00-5405 BUILD PROGRAM57,058 85,848 - - - - - - 23-230-54-00-5462 PROFESSIONAL SERVICES8,649 5,318 5,000 5,000 5,000 5,000 5,000 5,000 5,000 23-230-54-00-5465 ENGINEERING SERVICES- 35,06365,00060,000- - - - - 23-230-54-00-5497 PROPERTY TAX PAYMENT- 8,054- 1,239- - - - - 23-230-54-00-5498 PAYING AGENT FEES47547547547547547547547547523-230-54-00-5499 BAD DEBT1,1361,4201,2001,5001,5001,5001,5001,5001,50023-230-56-00-5632 ASPHALT PATCHING- - - - 35,00035,00035,00035,00035,00023-230-56-00-5637 SIDEWALK CONSTRUCTION SUPPLIES806 948 5,00020,0005,0005,0005,0005,0005,00023-230-60-00-6009 WRIGLEY (RTE 47) EXPANSION454,548- - 32,879- - - - - 23-230-60-00-6011 PROPERTY ACQUISITION160,877- - - - - - - - 23-230-60-00-6012 MILL ROAD IMPROVEMENTS- - - 215,0003,105,000- - - - 23-230-60-00-6014 BLACKBERRY WOODS131,5747,7977,5497,5497,5497,549- - - 23-230-60-00-6017 STAGECOACH CROSSING63,304- - - - - - - - 23-230-60-00-6016 US 34 (CENTER / ELDAMAIN RD) PROJECT - 19,500 110,226 110,226 110,226 110,226 - - - 23-230-60-00-6019 BRISTOL BAY ACCESS ROAD- 40,754 - - - - - - - 23-230-60-00-6021PAVILLION ROAD STREAMBANK STABILIZATION- - 110,000 10,000 137,500 - - - - 23-230-60-00-6023 FOUNTAIN VILLAGE SUBDIVISION- 19,346 256,528 256,528 - - - - - 23-230-60-00-6025 ROAD TO BETTER ROADS PROGRAM695,767 761,759 100,000 100,000 80,000 80,000 80,000 80,000 80,000 23-230-60-00-6034 WHISPERING MEADOWS SUBDIVISION- 2,762 1,070,000 945,000 22,500 - - - - 23-230-60-00-6048 DOWNTOWN STREETSCAPE IMPROVEMENT39,088 675 - - - - - - - 23-230-60-00-6058 ROUTE 71 (RTE 47 / RTE 126) PROJECT- - 30,333 30,333 30,333 30,333 30,334 - - 23-230-60-00-6059 US 34 (IL 47 / ORCHARD RD) PROJECT 16,497 78,682 98,413 90,981 90,981 - - - - 23-230-60-00-6073 GAME FARM ROAD PROJECT13,364328,913- - - - - - - 23-230-60-00-6082COUNTRYSIDE PKY IMPROVEMENTS1,211,639561,550- - - - - - - 23-230-60-00-6084 CENTER & COUNTRYSIDE IMPROVEMENTS- 227,760- - - - - - - 23-230-60-00-6086KENNEDY ROAD IMPROVEMENTS25,753391,76310,0002,500- - - - - 23-230-60-00-6094 KENNEDY ROAD BIKE TRAIL 3,894405,37045,0005,72232,000- - - - 23-230-60-00-6098 BRISTOL BAY SUBDIVISION- - - - - - - - 171,6002014A Bond23-230-78-00-8000 PRINCIPAL PAYMENT185,000190,000190,000190,000195,000200,000200,000210,000210,00023-230-78-00-8050 INTEREST PAYMENT144,138138,588132,888132,888127,188121,338115,338109,338103,03827 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionKendall County Loan - River Road Bridge23-230-97-00-8000 PRINCIPAL PAYMENT 75,00075,00084,67584,675- - - - - 23-230-99-00-9951 TRANSFER TO WATER- 65,241 64,866 65,030 104,906 103,895 104,558 104,209 104,627 3,288,5673,452,5862,387,1532,367,5254,090,158700,316577,205550,522716,240Expenditures3,374,6643,765,9212,941,8782,856,6614,548,408973,485856,913837,1621,010,228Surplus(Deficit)(1,648,379) (966,633) (438,576) 165,825(626,379) 39,00057,26777,01880,552Fund Balance1,355,530388,897(30,817) 554,722(71,657) (32,657) 24,610101,628182,18028 FY 2019 FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Licenses & Permits 134,050 229,575 145,000 255,663 109,500 109,500 109,500 109,500 109,500 Fines & Forfeits 6,608 8,730 6,700 8,900 8,650 8,650 8,650 8,650 8,650 Charges for Service 236,948 201,102 216,652 176,250 40,112 43,254 47,521 67,850 75,435 Investment Earnings 86 596 150 850 850 850 850 850 850 Miscellaneous 5,535 1,975 2,000 - 2,000 2,000 2,000 2,000 2,000 Other Financing Sources 254,162 - - 6,068 - - - - - Total Revenue 637,389 441,978 370,502 447,731 161,112 164,254 168,521 188,850 196,435 Police Capital Expenditures Contractual Services 3,460 18,485 8,750 8,750 8,750 8,750 8,750 8,750 8,750 Capital Outlay 141,832 182,317 160,000 160,000 60,000 55,000 55,000 55,000 55,000 Sub-Total Expenditures 145,292 200,802 168,750 168,750 68,750 63,750 63,750 63,750 63,750 General Government Capital Expenditures Supplies - - 34,411 34,411 14,080 16,154 20,421 37,924 43,700 Capital Outlay - - 40,000 44,985 - - - - - Sub-Total Expenditures --74,411 79,396 14,080 16,154 20,421 37,924 43,700 Public Works Capital Expenditures Contractual Services 26,244 34,464 1,750 784 750 750 750 750 750 Supplies - - 2,000 - 2,000 2,000 2,000 2,000 2,000 Capital Outlay 68,522 20,821 48,200 48,200 7,000 7,000 7,000 14,000 - Debt Service 70,815 70,815 70,815 72,778 75,524 75,523 75,523 75,524 75,523 Sub-Total Expenditures 165,581 126,100 122,765 121,762 85,274 85,273 85,273 92,274 78,273 Parks & Rec Capital Expenditures Contractual Services 1,822 850 - - 5,000 2,000 2,000 2,000 2,000 Capital Outlay 53,908 25,167 50,000 50,000 50,000 - - - - Debt Service 2,219 2,219 2,219 2,280 2,366 2,366 2,367 2,366 2,367 Sub-Total Expenditures 57,949 28,236 52,219 52,280 57,366 4,366 4,367 4,366 4,367 Total Expenditures 368,822 355,138 418,145 422,188 225,470 169,543 173,811 198,314 190,090 Surplus (Deficit)268,567 86,840 (47,643) 25,543 (64,358) (5,289) (5,290) (9,464) 6,345 Police Capital Fund Balance ---6,068 ----- Gen Gov Capital Fund Balance --------- Public Works Capital Fund Balance -37,930 6,435 98,335 91,561 84,788 78,015 67,067 71,929 Parks & Rec Capital Fund Balance 270,407 319,316 257,366 278,386 226,870 228,354 229,837 231,321 232,804 Ending Fund Balance 270,407 357,246 263,801 382,789 318,431 313,142 307,852 298,388 304,733 Vehicle and Equipment Fund (25) This fund was created in Fiscal Year 2014, consolidating the Police Capital, Public Works Capital and Park & Recreation Capital funds. The General Government function was added in Fiscal Year 2019 to account for administrative vehicle and City-wide computer purchases. This fund primarily derives its revenue from monies collected from building permits and development fees, in addition to functional chargebacks. The revenue is primarily used to purchase vehicles and equipment for use in the operations of the Police, Public Works and Parks & Recreation Departments. $0 $200 $400 $600 ThousandsFund Balance 29 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionVehicle & Equipment - 2525-000-42-00-4215 DEVELOPMENT FEES - POLICE CAPITAL32,100 51,511 55,000 65,000 30,000 30,000 30,000 30,000 30,000 25-000-42-00-4216 BUILD PROGRAM PERMITS28,700 44,935 - - - - - - - 25-000-42-00-4217 WEATHER WARNING SIREN FEES- 224 - 163 - - - - - 25-000-42-00-4218 ENGINEERING CAPITAL FEE8,600 11,000 12,000 20,000 10,000 10,000 10,000 10,000 10,000 25-000-42-00-4219 DEVELOPMENT FEES - PW CAPITAL60,350116,20572,000 160,000 64,500 64,500 64,500 64,500 64,500 25-000-42-00-4220 DEVELOPMENT FEES - PARK CAPITAL4,300 5,700 6,000 10,500 5,000 5,000 5,000 5,000 5,000 25-000-43-00-43155,8658,1306,0008,2508,0008,0008,0008,0008,00025-000-43-00-431674360070065065065065065065025-000-43-00-4340- - - - - - - - - 25-000-44-00-4418 MOWING INCOME1,955 894 2,000 2,167 2,000 2,000 2,000 2,000 2,000 25-000-44-00-4419 COMMUNITY DEVELOPMENT CHARGEBACK- - 40,000 44,985 - - - - - 25-000-44-00-4420 POLICE CHARGEBACK97,459 130,208 140,241 94,687 24,032 25,100 25,100 25,100 25,100 25-000-44-00-4421 PUBLIC WORKS CHARGEBACK63,626 - - - - - - 2,826 4,635 25-000-44-00-4427 PARKS & RECREATION CHARGEBACK73,908 70,000 - - - - - - - 25-000-44-00-4428 COMPUTER REPLACEMENT CHARGEBACKS- - 34,411 34,411 14,080 16,154 20,421 37,924 43,700 25-000-45-00-45228635015085085085085085085025-000-45-00-4550 GAIN ON INVESTMENT- 246- - - - - - - 25-000-48-00-4852 MISCELLANEOUS INCOME - POLICE CAPITAL435214- - - - - - - 25-000-48-00-4854 MISCELLANEOUS INCOME - PW CAPITAL5,1001,7612,000- 2,0002,0002,0002,0002,00025-000-49-00-4920 SALE OF CAPITAL ASSETS - POLICE CAPITAL5,990- - 6,068- - - - - 25-000-49-00-4922 SALE OF CAPITAL ASSETS - PARK CAPITAL248,172- -- -- -- - Revenue 637,389441,978370,502447,731161,112164,254168,521188,850196,435Police Capital25-205-54-00-5405 BUILD PROGRAM2,7009,915- - - - - - - 25-205-54-00-5495 OUTSIDE REPAIR & MAINTENANCE760 8,570 8,750 8,750 8,750 8,750 8,750 8,750 8,750 25-205-60-00-6060 EQUIPMENT- 28,2785,0005,0005,000- - - - 25-205-60-00-6070141,832 154,039 155,000 155,000 55,000 55,000 55,000 55,000 55,000 145,292200,802168,750168,75068,75063,75063,75063,75063,750General Government Capital25-212-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE- - 34,41134,41114,08016,15420,42137,92443,70025-212-60-00-6070- -40,000 44,985- -- -- - - 74,41179,39614,08016,15420,42137,92443,700VEHICLESELECTRONIC CITATION FEESSEIZED VEHICLE PROCEEDSDUI FINESINVESTMENT EARNINGS - PARK CAPITALVEHICLES30 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionPublic Works Capital25-215-54-00-5405 BUILD PROGRAM 25,95034,170- - - - - - - 25-215-54-00-5448 FILING FEES2942941,75078475075075075075025-215-56-00-5620 OPERATING SUPPLIES- - 2,000 - 2,000 2,000 2,000 2,000 2,000 25-215-60-00-6060 EQUIPMENT24,098- 13,20013,2007,0007,0007,00014,000- 25-215-60-00-607044,42420,82135,00035,000- - - - - 185 Wolf Street Building25-215-92-00-8000 PRINCIPAL PAYMENT41,43043,30343,30343,92244,42947,08949,90952,89856,06525-215-92-00-8050 INTEREST PAYMENT29,385 27,512 27,512 28,856 31,095 28,434 25,614 22,626 19,458 165,581126,100122,765121,76285,27485,27385,27392,27478,273Parks & Recreation Capital25-225-54-00-5405 BUILD PROGRAM50850- - - - - - - 25-225-54-00-5462 PROFESSIONAL SERVICES1,772- - - - - - - - 25-225-54-00-5495 OUTSIDE REPAIR & MAINTENANCE- - - - 5,0002,0002,0002,0002,00025-225-60-00-6060 EQUIPMENT53,9085,26450,00050,00050,000- - - - 25-225-60-00-6070 VEHICLES- 19,903- - - - - - - 185 Wolf Street Building25-225-92-00-8000 PRINCIPAL PAYMENT1,2981,3571,4181,3761,3921,4751,5641,6571,75725-225-92-00-8050 INTEREST PAYMENT921 862 801 904 974891 803709 610 57,94928,23652,21952,28057,3664,3664,3674,3664,367Expenditures368,822355,138418,145422,188225,470169,543173,811198,314190,090Surplus(Deficit)268,56786,840(47,643) 25,543(64,358) (5,289) (5,290) (9,464) 6,345- --6,068- -- -- -- -- -- -- --37,9306,43598,33591,56184,78878,01567,06771,929 270,407 319,316 257,366 278,386 226,870 228,354 229,837 231,321 232,804 Fund Balance 270,407357,246263,801382,789318,431313,142307,852298,388304,733Fund Balance - Police CapitalFund Balance - Parks & Rec CapitalFund Balance - Public Works CapitalFund Balance - General GovernmentVEHICLES31 FY 2019 FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 47,070 - - - - - - - - Licenses & Permits 7,015 11,303 6,000 10,000 4,646 4,646 4,646 4,646 - Other Financing Sources 266,979 309,972 318,725 314,725 319,379 318,579 324,729 325,429 - Total Revenue 321,064 321,275 324,725 324,725 324,025 323,225 329,375 330,075 - Expenditures Contractual Services 914 1,525 475 475 475 475 475 475 - Debt Service 320,150 319,750 324,250 324,250 323,550 322,750 328,900 329,600 - Total Expenditures 321,064 321,275 324,725 324,725 324,025 323,225 329,375 330,075 - Surplus (Deficit)- - - - - - - - - Ending Fund Balance - - - - - - - - - Debt Service Fund (42) The Debt Service Fund accumulates monies for payment of the 2014B bonds, which refinanced the 2005A bonds. The 2005A bonds were originally issued to finance road improvement projects. $0 $0 $0 ThousandsFund Balance 32 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionDebt Service - 4242-000-40-00-4000 PROPERTY TAXES - 2014B BOND47,070- - - - - - - - 42-000-42-00-4208 RECAPTURE FEES - WATER & SEWER6,57710,2536,00010,0004,646 4,646 4,646 4,646 - 42-000-42-00-4216 BUILD PROGRAM PERMITS4381,050- - - - - - - 42-000-49-00-4901 TRANSFER FROM GENERAL266,979 309,972 318,725 314,725 319,379 318,579 324,729 325,429- Revenue 321,064321,275324,725324,725324,025323,225329,375330,075- 42-420-54-00-5405 BUILD PROGRAM4381,050- - - - - - - 42-420-54-00-5498 PAYING AGENT FEES476475475475475475475475- 2014B Refunding Bond42-420-79-00-8000 PRINCIPAL PAYMENT270,000275,000285,000285,000290,000295,000310,000320,000- 42-420-79-00-8050 INTEREST PAYMENT50,150 44,750 39,250 39,250 33,550 27,750 18,9009,600- Expenditures 321,064321,275324,725324,725324,025323,225329,375330,075- Surplus(Deficit)- - - - - - - - - Fund Balance- - - - - - - - - 33 FY 2019 FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Licenses & Permits 171,840 165,755 - - - - - - - Charges for Service 3,955,944 4,489,995 4,326,486 4,595,800 4,401,300 4,570,215 4,750,476 4,934,500 5,132,725 Investment Earnings 9,729 11,727 7,000 18,000 23,851 19,150 19,183 21,780 43,986 Reimbursements 27,256 388 - 15,753 - - - - - Miscellaneous 60,865 61,221 62,491 62,847 95,999 98,393 100,847 103,362 105,940 Other Financing Sources 6,325,992 139,116 142,541 142,705 178,781 179,020 180,233 177,859 178,752 Total Revenue 10,551,626 4,868,202 4,538,518 4,835,105 4,699,931 4,866,778 5,050,739 5,237,501 5,461,403 Expenses Salaries 390,595 412,773 441,121 397,200 519,935 538,356 553,247 568,584 584,382 Benefits 235,050 246,029 257,466 215,155 263,064 280,751 299,099 318,756 339,814 Contractual Services 827,278 872,119 734,523 759,299 804,218 794,963 848,200 843,193 868,728 Supplies 326,045 327,921 361,948 361,948 393,281 405,405 418,135 431,501 445,536 Capital Outlay 3,499,902 889,684 1,555,976 672,199 1,428,146 1,019,538 1,116,538 1,162,905 285,000 Debt Service 1,449,609 1,343,250 1,532,837 1,532,837 2,361,500 2,305,935 1,815,830 1,654,108 714,373 Other Financing Uses 6,193,291 1,018,308 - - - - - - - Total Expenses 12,921,770 5,110,084 4,883,871 3,938,638 5,770,144 5,344,948 5,051,049 4,979,047 3,237,833 Surplus (Deficit)(2,370,144) (241,882) (345,353) 896,467 (1,070,213) (478,170) (310) 258,454 2,223,570 Ending Fund Balance Equivalent 2,826,144 2,584,259 1,952,155 3,480,726 2,410,513 1,932,343 1,932,033 2,190,487 4,414,057 21.87%50.57%39.97%88.37%41.78%36.15%38.25%43.99%136.33% The Water Fund is an enterprise fund which is comprised of both a capital and operational budget. The capital portion is used for the improvement and expansion of water infrastructure, while the operational side is used to service and maintain City water systems. Water Fund (51) $0 $2,000 $4,000 $6,000 ThousandsFund Balance Equivalent 34 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionWater - 5151-000-42-00-4216 BUILD PROGRAM PERMITS171,840165,755- - - - - - - 51-000-44-00-4424 WATER SALES2,952,0743,094,5643,105,0003,165,0003,228,3003,389,7153,559,2013,737,1613,924,01951-000-44-00-4425 BULK WATER SALES5,2504,2505,0002,8005,0005,0005,0005,0005,00051-000-44-00-4426 LATE PENALTIES - WATER104,425116,805120,000110,000110,000115,500121,275127,339133,70651-000-44-00-4430 WATER METER SALES66,280127,34558,206175,00060,000 60,000 60,000 60,000 60,000 51-000-44-00-4440 WATER INFRASTRUCTURE FEE734,552749,613745,000768,000768,000770,000775,000775,000780,00051-000-44-00-4450 WATER CONNECTION FEES93,363397,418293,280375,000230,000 230,000 230,000 230,000 230,000 51-000-45-00-45009,72910,2967,00018,00023,85119,15019,18321,78043,98651-000-45-00-4550 GAIN ON INVESTMENT- 1,431- - - - - - - 51-000-46-00-4690 REIMB - MISCELLANEOUS27,256388- 15,753- - - - - 51-000-48-00-4820RENTAL INCOME 60,495 61,082 62,491 62,597 95,749 98,143 100,597 103,112 105,690 51-000-48-00-4850 MISCELLANEOUS INCOME370139- 25025025025025025051-000-49-00-4902BOND ISSUANCE5,800,000- - - - - - - - 51-000-49-00-4903 PREMIUM ON BOND ISSUANCE449,023- - - - - - - - 51-000-49-00-4910 SALE OF CAPITAL ASSETS1,894- - - - - - - - 51-000-49-00-4923 TRANSFER FROM CITY-WIDE CAPITAL- 65,24164,86665,030104,906103,895104,558104,209104,62751-000-49-00-4952 TRANSFER FROM SEWER75,075 73,875 77,675 77,675 73,875 75,125 75,675 73,650 74,125 Revenue 10,551,6264,868,2024,538,5184,835,1054,699,9314,866,7785,050,7395,237,5015,461,403Water Operations51-510-50-00-5010 SALARIES & WAGES375,148394,263414,121380,000477,935496,356511,247526,584542,38251-510-50-00-5015 PART-TIME SALARIES5,53011,53215,0005,20030,00030,00030,00030,00030,00051-510-50-00-5020 OVERTIME9,9176,97812,00012,00012,00012,00012,00012,00012,00051-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION41,13242,91545,52641,00044,94847,93850,80753,85857,10151-510-52-00-5214 FICA CONTRIBUTION28,32630,19232,37030,00037,70239,14540,31941,52942,77551-510-52-00-5216 GROUP HEALTH INSURANCE127,757134,779139,233106,545137,566148,571160,457173,294187,15851-510-52-00-5222 GROUP LIFE INSURANCE70570551946456056657257858451-510-52-00-5223 DENTAL INSURANCE9,1478,8088,2607,1779,3549,82210,31310,82911,37051-510-52-00-5224 VISION INSURANCE1,1311,2181,2181,0541,3441,3441,3841,4261,46951-510-52-00-5230UNEMPLOYMENT INSURANCE1,1486712,0001,0002,0002,0002,0002,0002,00051-510-52-00-5231 LIABILITY INSURANCE25,70426,74128,34027,91529,59031,36533,24735,24237,35751-510-54-00-5401 ADMINISTRATIVE CHARGEBACK- 108,154111,629111,629118,631122,190125,856129,632133,52151-510-54-00-5402BOND ISSUANCE COSTS55,732- - - - - - - - 51-510-54-00-5405 BUILD PROGRAM171,840165,755- - - - - - - 51-510-54-00-5412 TRAINING & CONFERENCES3,1782,5156,5006,5006,5006,5006,5006,5006,50051-510-54-00-5415 TRAVEL & LODGING2,1237322,0002,0002,0002,0002,0002,0002,00051-510-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK- - 2,6272,6278272,2584813,1903,349INVESTMENT EARNINGS35 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescription51-510-54-00-5426 PUBLISHING & ADVERTISING6059325001,35950050050050050051-510-54-00-5429 WATER SAMPLES7,6075,89410,00010,0008,0008,00010,0008,0008,00051-510-54-00-5430 PRINTING & DUPLICATING2,4052,8143,2503,2503,2503,2503,2503,2503,25051-510-54-00-5440 TELECOMMUNICATIONS30,80733,83230,00035,00035,00035,00035,00035,00035,00051-510-54-00-5445 TREATMENT FACILITY SERVICES143,204136,286145,000145,000145,000145,000145,000145,000145,00051-510-54-00-5448 FILING FEES2,0581,9014,0003,0003,0003,0003,0003,0003,00051-510-54-00-5452 POSTAGE & SHIPPING16,83817,72319,00019,00019,00019,00019,00019,00019,00051-510-54-00-5460 DUES & SUBSCRIPTIONS1,6031,1691,8001,8001,8001,8001,8001,8001,80051-510-54-00-5462 PROFESSIONAL SERVICES39,02536,86345,00075,00065,00055,00055,00055,00055,00051-510-54-00-5465 ENGINEERING SERVICES46,96039,97515,00016,95837,50015,00015,00015,00015,00051-510-54-00-5480 UTILITIES256,914279,411286,518286,518303,709321,932341,248361,723383,42651-510-54-00-5483 JULIE SERVICES7,8495,9543,0001,2503,0003,0003,0003,0003,00051-510-54-00-5485 RENTAL & LEASE PURCHASE4239291,0001,0001,7001,7001,7001,7001,70051-510-54-00-5488 OFFICE CLEANING- 1,1641,1991,0201,0511,0831,1151,1481,18251-510-54-00-5490 VEHICLE MAINTENANCE SERVICES8,862 5,930 12,000 12,000 12,000 12,000 12,000 12,000 12,000 51-510-54-00-5495 OUTSIDE REPAIR & MAINTENCE15,096 15,023 25,000 15,000 25,000 25,000 55,000 25,000 25,000 51-510-54-00-5498 PAYING AGENT FEES1,415 1,888 2,000 1,888 1,750 1,750 1,750 1,750 1,500 51-510-54-00-5499 BAD DEBT12,734 7,275 7,500 7,500 10,000 10,000 10,000 10,000 10,000 51-510-56-00-5600 WEARING APPAREL4,2646,8375,1005,1005,1005,1005,1005,1005,10051-510-56-00-5620 OPERATING SUPPLIES8,5943,36615,00015,00010,50010,50010,50010,50010,50051-510-56-00-5628 VEHICLE MAINTENANCE SUPPLIES6992,4162,5002,5002,5002,5002,5002,5002,50051-510-56-00-5630 SMALL TOOLS & EQUIPMENT4,4471,3654,0004,0004,0004,0004,0004,0004,00051-510-56-00-5638 TREATMENT FACILITY SUPPLIES173,204159,093183,750183,750218,438229,360240,828252,869265,51251-510-56-00-5640 REPAIR & MAINTENANCE19,30715,18327,50027,50027,50027,50027,50027,50027,50051-510-56-00-5664 METERS & PARTS97,378117,151100,000100,000100,000100,000100,000100,000100,00051-510-56-00-5665 JULIE SUPPLIES3,6696931,2001,2001,2001,2001,2001,2001,20051-510-56-00-5695 GASOLINE14,48321,81722,89822,89824,04325,24526,50727,83229,22451-510-60-00-6011 PROPERTY ACQUISITION- - 200,000- - - 200,000200,000- 51-510-60-00-6015 WATER TOWER PAINTING- - - - - 18,000495,000477,000- 51-510-60-00-6022 WELL REHABILITATIONS174,197264,985257,500132,538165,000175,000- - - 51-510-60-00-6025 ROAD TO BETTER ROADS PROGRAM316,911272,423250,00020,000569,000489,000179,000362,000280,00051-510-60-00-6034 WHISPERING MEADOWS SUBDIVISION- 11549,22045,000- - - - - 51-510-60-00-6059 US 34 (IL 47 / ORCHARD RD) PROJECT - 26,676 4,212 21,608 21,608 - - - - 51-510-60-00-6060 EQUIPMENT3,2488,8255,0005,000400,0005,0005,0005,0005,00051-510-60-00-6066 RTE 71 WATERMAIN REPLACEMENT24,19544,904533,500340,00042,16642,16642,166- - 51-510-60-00-6070 VEHICLES65,710- 50,00050,000- 50,000- 100,000- 51-510-60-00-6079 ROUTE 47 EXPANSION197,544197,544197,54458,05345,37245,37245,37218,905- 51-510-60-00-6081 CATION EXCHANGE MEDIA REPLACEMENT- - 9,000- 185,000195,000150,000- - 51-510-60-00-6082COUNTRYSIDE PKY IMPROVEMENTS2,718,09774,212- - - - - - - 36 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescription2015A Bond51-510-77-00-8000 PRINCIPAL PAYMENT 73,543113,991117,664117,664290,483297,837312,545323,576338,28451-510-77-00-8050 INTEREST PAYMENT228,066161,055156,493156,493151,787140,167128,254115,752102,809Debt Service - 2007A Bond51-510-83-00-8000 PRINCIPAL PAYMENT15,000- - - - - - - - 51-510-83-00-8050 INTEREST PAYMENT121,163- - - - - - - - Debt Service - 2016 Refunding Bond51-510-85-00-8000 PRINCIPAL PAYMENT- 430,000470,000470,0001,470,0001,475,0001,040,000915,000- 51-510-85-00-8050 INTEREST PAYMENT- 248,124195,250195,250176,450117,65058,65027,450- Debt Service - 2003 Debt Certificates51-510-86-00-8000 PRINCIPAL PAYMENT100,000100,000300,000300,000- - - - - 51-510-86-00-8050 INTEREST EXPENSE21,45017,30013,05013,050- - - - - Debt Service - 2006A Refunding Debt Certificates51-510-87-00-8000 PRINCIPAL PAYMENT460,000- - - - - - - - 51-510-87-00-8050 INTEREST EXPENSE155,206- - - - - - - - Debt Service - IEPA Loan L17-15630051-510-89-00-8000 PRINCIPAL PAYMENT96,92399,361101,860101,860104,423107,050109,743112,503115,33351-510-89-00-8050 INTEREST EXPENSE28,10825,66923,17023,17020,60717,98115,28812,5279,697Debt Service - 2014C Refunding Bond51-510-94-00-8000 PRINCIPAL PAYMENT120,000120,000130,000130,000125,000130,000135,000135,000140,00051-510-94-00-8050 INTEREST PAYMENT30,15027,75025,35025,35022,75020,25016,35012,3008,25051-510-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL- 1,018,308- - - - - - - 51-510-99-00-9960 PAYMENT TO ESCROW AGENT6,193,291- -- -- -- - Expenses 12,921,7705,110,0844,883,8713,938,6385,770,1445,344,9485,051,0494,979,0473,237,833Surplus(Deficit)(2,370,144) (241,882) (345,353) 896,467(1,070,213) (478,170) (310) 258,4542,223,570Fund Balance Equiv2,826,1442,584,2591,952,1553,480,7262,410,5131,932,3431,932,0332,190,4874,414,05721.87%50.57%39.97%88.37%41.78%36.15%38.25%43.99%136.33%37 FY 2019FY 2017 FY 2018 AdoptedFY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024Actual Actual Budget ProjectedAdoptedProjectedProjectedProjectedProjectedRevenue Licenses & Permits 105,392 93,000 -------Charges for Service1,286,891 1,595,338 1,558,658 1,535,378 1,567,500 1,596,876 1,632,133 1,663,298 1,700,398 Investment Earnings3,899 24,274 1,250 10,500 7,149 5,006 6,369 9,165 16,027 Reimbursements8,149 54 -1,465 -----Other Financing Sources1,134,052 1,137,166 856,583 856,583 575,030 586,749 994,479 1,135,964 1,134,606 Total Revenue2,538,383 2,849,832 2,416,491 2,403,926 2,149,679 2,188,631 2,632,981 2,808,427 2,851,031 ExpensesSalaries 212,574 224,215 234,507 198,500 270,946 282,992 291,317 299,892 308,724 Benefits105,974 111,531 113,682 99,755 164,060 175,735 187,664 200,460 214,190 Contractual Services170,831 221,111 139,140 142,065 232,677 162,587 165,040 166,314 169,361 Supplies38,912 45,902 55,880 72,880 62,650 63,774 64,954 66,193 67,494 Capital Outlay228,131 228,179 513,167 234,905 350,861 352,488 418,488 429,370 200,000 Developer Commitments33,872 34,888 35,938 35,938 30,721 ----Debt Service1,865,857 1,877,110 1,880,265 1,880,265 1,352,307 1,300,798 1,300,780 1,299,024 1,134,606 Other Financing Uses75,075 73,875 77,675 77,675 73,875 75,125 75,675 73,650 74,125 Total Expenses2,731,226 2,816,811 3,050,254 2,741,983 2,538,097 2,413,499 2,503,918 2,534,903 2,168,500 Surplus (Deficit)(192,843) 33,021 (633,763) (338,057) (388,418) (224,868) 129,063 273,524 682,531 Ending Fund Balance Equivalent 1,378,030 1,411,053 705,765 1,072,996 684,578 459,710 588,773 862,297 1,544,828 50.45% 50.09% 23.14% 39.13% 26.97% 19.05% 23.51% 34.02% 71.24%Sewer Fund (52)The Sewer Fund is an enterprise fund which is comprised of both a capital and operational budget. The capital portion is used for improvement and expansion of the sanitary sewer infrastructure while the operational side allows the City to service and maintain sanitary sewer systems.$0$500$1,000$1,500$2,000ThousandsFund Balance Equivalent38 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionSewer - 5252-000-42-00-4216 BUILD PROGRAM PERMITS105,39293,000- - - - - - - 52-000-44-00-4435 SEWER MAINTENANCE FEES868,488910,828929,258960,000979,2001,008,5761,038,8331,069,9981,102,09852-000-44-00-4440 SEWER INFRASTRUCTURE FEE354,171363,038360,000370,000370,000370,000375,000375,000380,00052-000-44-00-4455 SW CONNECTION FEES - OPERATIONS23,100105,00538,40095,00023,300 23,300 23,300 23,300 23,300 52-000-44-00-4456 SW CONNECTION FEES - CAPITAL25,909198,700216,00095,000180,000 180,000 180,000 180,000 180,000 52-000-44-00-4462 LATE PENALTIES - SEWER13,74615,05715,000 15,000 15,000 15,000 15,000 15,000 15,000 52-000-44-00-4465 RIVER CROSSING FEES1,4772,710- 378- - - - - 52-000-45-00-45003,89917,5501,25010,5007,1495,0066,3699,16516,02752-000-45-00-4550 GAIN ON INVESTMENT- 6,724- - - - - - - 52-000-46-00-46908,14954- 1,465- - - - - 52-000-49-00-4901 TRANSFER FROM GENERAL1,134,052 1,137,166 856,583 856,583 575,030 586,749 994,479 1,135,964 1,134,606 Revenue 2,538,3832,849,8322,416,4912,403,9262,149,6792,188,6312,632,9812,808,4272,851,031Sewer Operations52-520-50-00-5010 SALARIES & WAGES212,553223,926233,507198,000265,446277,492285,817294,392303,22452-520-50-00-5015 PART-TIME SALARIES- - - - 5,0005,0005,0005,0005,00052-520-50-00-5020 OVERTIME212891,00050050050050050050052-520-52-00-5212 RETIREMENT PLAN CONTRIBUTION22,89924,17725,05421,50024,39926,16727,75329,43931,23252-520-52-00-5214 FICA CONTRIBUTION15,90416,84717,31116,00019,03119,91420,51121,12621,76052-520-52-00-5216 GROUP HEALTH INSURANCE48,45751,51151,28544,60198,202106,058114,543123,706133,60252-520-52-00-5222 GROUP LIFE INSURANCE37137127320031431732032332652-520-52-00-5223 DENTAL INSURANCE4,3674,2393,9013,2236,4336,7557,0937,4487,82052-520-52-00-5224 VISION INSURANCE55259459447487987990593296052-520-52-00-5230 UNEMPLOYMENT INSURANCE4783531,00050075075075075075052-520-52-00-5231 LIABILITY INSURANCE12,94613,43914,26413,25714,05214,89515,78916,73617,74052-520-54-00-5401 ADMINISTRATIVE CHARGEBACK- 38,92540,17640,17642,69643,97745,29646,65548,05552-520-54-00-5405 BUILD PROGRAM105,39293,000- - - - - - - 52-520-54-00-5412 TRAINING & CONFERENCES1,7031,1802,5002,5002,5002,5002,5002,5002,50052-520-54-00-5415 TRAVEL & LODGING2,6813442,0002,0002,0002,0002,0002,0002,00052-520-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK- - 263263- 2,2581,94031633252-520-54-00-5430 PRINTING & DUPLICATING1,1331,3071,5001,5001,5001,5001,5001,5001,50052-520-54-00-5440 TELECOMMUNICATIONS2,4118,6679,0009,0009,0009,0009,0009,0009,00052-520-54-00-5444 LIFT STATION SERVICES64820,72710,00015,00075,00020,00020,00020,00020,00052-520-54-00-5462 PROFESSIONAL SERVICES14,77214,63818,00018,00043,00023,00023,00023,00023,00052-520-54-00-5480 UTILITIES17,66020,08121,20021,20022,47223,82025,24926,76428,37052-520-54-00-5483 JULIE SERVICES- - 3,0001,2503,0003,0003,0003,0003,00052-520-54-00-5485 RENTAL & LEASE PURCHASE4236621,0001,0001,0001,0001,0001,0001,000INVESTMENT EARNINGSREIMB - MISCELLANEOUS39 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescription52-520-54-00-5488 OFFICE CLEANING- 72975173775978280582985452-520-54-00-5490 VEHICLE MAINTENANCE SERVICES8,549 1,643 10,000 10,000 10,000 10,000 10,000 10,000 10,000 52-520-54-00-5495 OUTSIDE REPAIR & MAINTENCE11,924 15,072 16,000 16,000 16,000 16,000 16,000 16,000 16,000 52-520-54-00-5498 PAYING AGENT FEES1,542 1,277 1,500 689 750 750 750 750 750 52-520-54-00-5499 BAD DEBT1,9932,8592,2502,7503,0003,0003,0003,0003,00052-520-56-00-5600 WEARING APPAREL2,7913,9653,9803,9803,9803,9803,9803,9803,98052-520-56-00-5610 OFFICE SUPPLIES4651,0291,0001,0001,0001,0001,0001,0001,00052-520-56-00-5613 LIFT STATION MAINTENANCE3,6048,0068,00017,0008,0008,0008,0008,0008,00052-520-56-00-5620 OPERATING SUPPLIES7,1384,51611,30011,3009,0009,0009,0009,0009,00052-520-56-00-5628 VEHICLE MAINTENANCE SUPPLIES3,5905,3562,00010,00010,00010,00010,00010,00010,00052-520-56-00-5630 SMALL TOOLS & EQUIPMENT3,6587112,0002,0002,0002,0002,0002,0002,00052-520-56-00-5640 REPAIR & MAINTENANCE3,7082,2435,0005,0005,0005,0005,0005,0005,00052-520-56-00-5665 JULIE SUPPLIES- - 1,2001,2001,2001,2001,2001,2001,20052-520-56-00-5695 GASOLINE13,95820,07621,40021,40022,47023,59424,77426,01327,31452-520-60-00-6001 SCADA SYSTEM- - - - 67,00067,00067,000- - 52-520-60-00-6025 ROAD TO BETTER ROADS PROGRAM162,427160,219200,000125,000137,000200,000216,000420,000200,00052-520-60-00-6034 WHISPERING MEADOWS SUBDIVISION- 17248,15073,000- - - - - 52-520-60-00-6059 US 34 (IL 47 / ORCHARD RD) PROJECT - 4,213 17,002 11,373 11,373 - - - - 52-520-60-00-6060 EQUIPMENT1,014 - - - - - - - - 52-520-60-00-6066 RTE 71 SANITARY SEWER REPLACEMENT5,6754,560189,000- 63,00063,00063,000- - 52-520-60-00-6070 VEHICLES- - - - 50,000- 50,000- - 52-520-60-00-6079 ROUTE 47 EXPANSION59,01559,01559,01525,53222,48822,48822,4889,370- 52-520-75-00-7500 LENNAR - RAINTREE SEWER RECPATURE33,87234,88835,93835,93830,721- - - - Debt Service - 2004B Bond52-520-84-00-8000 PRINCIPAL PAYMENT410,000435,000455,000455,000- - - - - 52-520-84-00-8050 INTEREST EXPENSE52,00035,60018,20018,200- - - - - Debt Service - 2003A IRBB Debt Certificates52-520-90-00-8000 PRINCIPAL PAYMENT115,000120,000130,000130,000135,000140,000150,000155,000- 52-520-90-00-8050 INTEREST EXPENSE47,75542,29336,23336,23329,66822,85015,7108,060- Debt Service - 2011 Refunding Bond52-520-92-00-8000 PRINCIPAL PAYMENT745,000780,000810,000810,000845,000885,000920,000960,0001,000,00052-520-92-00-8050 INTEREST EXPENSE389,052357,166323,782323,782289,114252,948215,070175,964134,60640 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionDebt Service - IEPA Loan L17-11530052-520-96-00-8000 PRINCIPAL PAYMENT 98,353100,952103,619103,61952,832- - - - 52-520-96-00-8050 INTEREST EXPENSE8,6976,0993,4313,431693- - - - 52-520-99-00-9951 TRANSFER TO WATER75,075 73,875 77,675 77,675 73,875 75,125 75,675 73,650 74,125 Expenses 2,731,2262,816,8113,050,2542,741,9832,538,0972,413,4992,503,9182,534,9032,168,500Surplus(Deficit)(192,843) 33,021(633,763) (338,057) (388,418) (224,868) 129,063273,524682,531Fund Balance Equiv1,378,0301,411,053705,7651,072,996684,578459,710588,773862,2971,544,82850.45%50.09%23.14%39.13%26.97%19.05%23.51%34.02%71.24%41 FY 2019 FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Intergovernmental 15,711 - 702,474 702,474 - - - - - Licenses & Permits 1,103 1,505 - - - - - - - Land Cash Contributions 47,753 125,491 11,639 162,779 58,435 19,579 - - 28,305 Reimbursements 63,796 5,701 - - - - - - - Miscellaneous - - - 3,406 - - - - - Other Financing Sources 2,500 2,503 - - - - - - - Total Revenue 130,863 135,200 714,113 868,659 58,435 19,579 - - 28,305 Expenditures Contractual Services 1,103 1,505 - 4,795 4,850 4,850 5,000 5,000 5,000 Capital Outlay 91,762 662,215 435,000 379,500 100,000 100,000 - 75,000 210,000 Total Expenditures 92,865 663,720 435,000 384,295 104,850 104,850 5,000 80,000 215,000 Surplus (Deficit)37,998 (528,520) 279,113 484,364 (46,415) (85,271) (5,000) (80,000) (186,695) Ending Fund Balance 250,318 (278,204) 62,362 206,160 159,745 74,474 69,474 (10,526) (197,221) Land Cash Fund (72) Land-Cash funds are dedicated by developers through the contribution ordinance to serve the immediate and future needs of park and recreation of residents in new subdivisions. Land for park development and cash spent on recreational facilities is often matched through grant funding to meet the community’s recreation needs at a lower cost to the City. ($400) ($200) $0 $200 $400 ThousandsFund Balance 42 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionLand Cash - 7272-000-41-00-4175 OSLAD GRANT - RIVERFRONT PARK5,514- 312,671312,671- - - - - 72-000-41-00-4186 OSLAD GRANT - BRISTOL BAY 10,197- 389,803389,803- - - - - 72-000-42-00-4216 BUILD PROGRAM PERMITS1,1031,505- - - - - - - 72-000-46-00-4655 REIMB - GRANDE RESERVE PARK 63,7965,701- - - - - - - 72-000-47-00-4702 WHISPERING MEADOWS- - - - - - - - - 72-000-47-00-4703 AUTUMN CREEK27,690- - - 6,606- - - - 72-000-47-00-4704 BLACKBERRY WOODS7,95517,614- 9,09115,909- - - - 72-000-47-00-4706CALEDONIA2,01339,26111,63935,00016,341- - - - 72-000-47-00-4707 RIVER'S EDGE- 671- - - - - - - 72-000-47-00-4708 COUNTRY HILLS4,6146,152- 1,0008,0008,000- - - 72-000-47-00-4709 SALEK- 3,213- - - - - - - 72-000-47-00-4720 WOODWORTH1,071- - - - - - - - 72-000-47-00-4722 GC HOUSING (ANTHONY'S PLACE)- - - 97,162- - - - - 72-000-47-00-4723 WINDETT RIDGE- 50,000- 10,000- - - - - 72-000-47-00-4724 KENDALL MARKETPLACE- 162- 9712,0242,024- - - 72-000-47-00-4725 HEARTLAND MEADOWS- - - - - - - - 28,30572-000-47-00-4726 KENDALLWOOD ESTATES- - - - - - - - - 72-000-47-00-4736 BRIARWOOD4,4108,418- 9,5559,5559,555- - - 72-000-48-00-4850 MISCELLANEOUS INCOME- - - 3,406- - - - - 72-000-49-00-4910 SALE OF CAPITAL ASSETS2,500 2,503- -- -- -- Revenue 130,863135,200714,113868,65958,43519,579- - 28,30572-720-54-00-5405 BUILD PROGRAM1,1031,505- - - - - - - 72-720-54-00-5485 RENTAL & LEASE PURCHASE- - - 4,7954,8504,8505,0005,0005,00072-720-60-00-6010 PARK IMPROVEMENTS- - 300,000270,000- - - - - 72-720-60-00-6013 BEECHER CENTER PARK- - - - - - - - 75,00072-720-60-00-6014 BLACKBERRY WOODS- - - - - - - - 75,00072-720-60-00-6029 CALEDONIA PARK- - - - - 75,000- - - 72-720-60-00-6032 MOSER HOLDING COSTS8,612- - - - - - - - 72-720-60-00-6040 PRESTWICK- - - - - - - 75,000- 72-720-60-00-6043 BRISTOL BAY REGIONAL PARK10,197384,92220,0007,000- - - - - 72-720-60-00-6045RIVERFRONT PARK9,864276,61640,00042,500- - - - - 72-720-60-00-6046 GRANDE RESERVE PARK 63,089677- - 25,000- - - - 72-720-60-00-6047 AUTUMN CREEK- - - - 50,000- - - - 72-720-60-00-6049 RAINTREE PARK C- - - - 25,000- - - - 72-720-60-00-6067 BLACKBERRY CREEK NATURE PRESERVE- - 25,000- - 25,000- - - 43 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescription72-720-60-00-6069 WINDETT RIDGE PARK- - 50,00060,000- - - - - 72-720-60-00-6070 BRISTOL BAY - -- -- -- -60,000 Expenditures 92,865663,720435,000384,295104,850104,8505,00080,000215,000Surplus(Deficit)37,998(528,520) 279,113484,364(46,415) (85,271) (5,000) (80,000) (186,695) Fund Balance250,318(278,204) 62,362206,160159,74574,47469,474(10,526) (197,221) 44 FY 2019 FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Intergovernmental - - 81,815 81,815 - - - - - Charges for Service 455,676 453,466 565,000 578,000 632,000 632,000 632,000 632,000 632,000 Investment Earnings 328 800 500 1,500 1,500 1,500 1,500 1,500 1,500 Reimbursements 3,002 174 - 19,158 - - - - - Miscellaneous 209,970 234,784 201,000 204,849 200,500 202,416 204,409 206,481 208,636 Other Financing Sources 1,118,638 1,308,583 1,274,699 1,274,699 1,410,988 1,558,701 1,622,068 1,699,258 1,765,181 Total Revenue 1,787,614 1,997,807 2,123,014 2,160,021 2,244,988 2,394,617 2,459,977 2,539,239 2,607,317 Expenditures Salaries 805,190 868,189 989,828 992,500 1,103,861 1,133,217 1,163,393 1,194,415 1,226,308 Benefits 365,079 390,010 437,531 415,316 448,232 470,329 501,290 534,481 570,072 Contractual Services 311,346 318,383 294,214 282,579 301,682 293,490 293,663 305,143 305,442 Supplies 360,884 393,250 506,935 527,606 489,630 490,901 492,235 493,636 495,107 Total Expenditures 1,842,499 1,969,832 2,228,508 2,218,001 2,343,405 2,387,937 2,450,581 2,527,675 2,596,929 Surplus (Deficit)(54,885) 27,975 (105,494) (57,980) (98,417) 6,680 9,396 11,564 10,388 Ending Fund Balance 445,875 473,852 312,946 415,872 317,455 324,135 333,531 345,095 355,483 24.20%24.06%14.04%18.75%13.55%13.57%13.61%13.65%13.69% Parks and Recreation Fund (79) This fund accounts for the daily operations of the Parks and Recreation Department. Programs, classes, special events and maintenance of City wide park land and public facilities make up the day to day operations. Programs and classes consist of a wide variety of options serving children through senior citizens. Special events range from Music Under the Stars to Home Town Days. City wide maintenance consists of over two hundred acres at more than fifty sites including buildings, boulevards, parks, utility locations and natural areas. $0 $500 ThousandsFund Balance 45 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionParks and Recreation - 7979-000-41-00-4175 OSLAD GRANT - RIVERFRONT PARK- - 81,81581,815- - - - - 79-000-44-00-4402 SPECIAL EVENTS109,10987,66690,00090,00090,00090,00090,00090,00090,00079-000-44-00-4403 CHILD DEVELOPMENT135,445141,046130,000145,000145,000145,000145,000145,000145,00079-000-44-00-4404 ATHLETICS & FITNESS178,613187,611315,000315,000365,000365,000365,000365,000365,00079-000-44-00-4441 CONCESSION REVENUE32,50937,14330,00028,00032,00032,00032,00032,00032,00079-000-45-00-45003288005001,5001,5001,5001,5001,5001,50079-000-46-00-4690 REIMB - MISCELLANEOUS3,002174- 19,158- - - - - 79-000-48-00-4820 RENTAL INCOME53,34554,70155,00053,20854,50056,41658,40960,48162,63679-000-48-00-4825 PARK RENTALS13,22120,20015,00015,50015,00015,00015,00015,00015,00079-000-48-00-4843 HOMETOWN DAYS117,354128,156108,000118,141108,000108,000108,000108,000108,00079-000-48-00-4846 SPONSORSHIPS & DONATIONS20,54719,75320,00015,00020,00020,00020,00020,00020,00079-000-48-00-4850 MISCELLANEOUS INCOME5,50311,9743,0003,0003,0003,0003,0003,0003,00079-000-49-00-4901 TRANSFER FROM GENERAL1,118,638 1,308,583 1,274,699 1,274,699 1,410,988 1,558,701 1,622,068 1,699,258 1,765,181 Revenue 1,787,6141,997,8072,123,0142,160,0212,244,9882,394,6172,459,9772,539,2392,607,317Parks Department79-790-50-00-5010 SALARIES & WAGES425,198459,025492,742485,000552,859569,445586,528604,124622,24879-790-50-00-5015 PART-TIME SALARIES35,25137,28250,00050,00051,00052,00053,00054,00055,00079-790-50-00-5020 OVERTIME2,0912,5333,0005,0005,0005,0005,0005,0005,00079-790-52-00-5212 RETIREMENT PLAN CONTRIBUTION46,25651,25454,65054,65052,72553,69956,95260,41264,09279-790-52-00-5214 FICA CONTRIBUTION34,14336,88340,35440,35444,71546,05647,43848,86150,32779-790-52-00-5216 GROUP HEALTH INSURANCE119,781131,162158,534141,675153,747166,047179,331193,677209,17179-790-52-00-5222 GROUP LIFE INSURANCE88489659458364565165866567279-790-52-00-5223 DENTAL INSURANCE8,3539,72610,7079,79710,86611,40911,97912,57813,20779-790-52-00-5224 VISION INSURANCE1,0021,3131,4971,3931,5371,5371,5831,6301,67979-790-54-00-5412 TRAINING & CONFERENCES4,4104,1867,0001,0007,0007,0007,0007,0007,00079-790-54-00-5415 TRAVEL & LODGING8072483,0001003,0003,0003,0003,0003,00079-790-54-00-5422 VEHICLE & EQUIPMENT CHARGEBACK53,90870,000- - - - - - - 79-790-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK- - 5,2005,200662- 1,4597,0866,63779-790-54-00-5440 TELECOMMUNICATIONS6,2786,3486,5006,5006,5006,5006,5006,5006,50079-790-54-00-5462 PROFESSIONAL SERVICES2,4611,9403,0003,0009,4009,4009,4009,4009,40079-790-54-00-5466 LEGAL SERVICES6632,6346,0002,0003,0003,0003,0003,0003,00079-790-54-00-5485 RENTAL & LEASE PURCHASE2,3345,8182,5002,5002,5002,5002,5002,5002,50079-790-54-00-5488 OFFICE CLEANING- 2,7192,8002,7922,8762,9623,0513,1433,23779-790-54-00-5495 OUTSIDE REPAIR & MAINTENANCE22,41117,64050,00050,00050,00050,00050,00050,00050,00079-790-56-00-5600WEARING APPAREL5,3448,6476,2206,2206,2206,2206,2206,2206,22079-790-56-00-5620 OPERATING SUPPLIES23,57731,21335,20035,20025,00025,00025,00025,00025,000INVESTMENT EARNINGS46 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescription79-790-56-00-5630 SMALL TOOLS & EQUIPMENT1,5765,9656,0006,0006,0006,0006,0006,0006,00079-790-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE2,0002,00020,00020,0002,0002,0002,0002,0002,00079-790-56-00-5640 REPAIR & MAINTENANCE69,16068,347126,000126,000126,000126,000126,000126,000126,00079-790-56-00-5695 GASOLINE12,439 15,686 14,445 24,200 25,410 26,681 28,015 29,416 30,887 880,327973,4651,105,9431,079,1641,148,6621,182,1071,221,6141,267,2121,308,777Recreation Department79-795-50-00-5010 SALARIES & WAGES283,924290,580324,086337,500359,002369,772380,865392,291404,06079-795-50-00-5015 PART-TIME SALARIES9,98916,60240,00040,00041,00042,00043,00044,00045,00079-795-50-00-5045 CONCESSION WAGES7,8918,34415,00010,00015,00015,00015,00015,00015,00079-795-50-00-5046 PRE-SCHOOL WAGES30,09134,46840,00040,00040,00040,00040,00040,00040,00079-795-50-00-5052 INSTRUCTORS WAGES10,75519,35525,00025,00040,00040,00040,00040,00040,00079-795-52-00-5212 RETIREMENT PLAN CONTRIBUTION30,32831,20839,95636,00037,51434,86936,98239,22941,61879-795-52-00-5214 FICA CONTRIBUTION25,58527,56132,36732,36736,76137,86439,00040,17041,37579-795-52-00-5216 GROUP HEALTH INSURANCE91,18792,49790,94590,570101,795109,939118,734128,233138,49279-795-52-00-5222 GROUP LIFE INSURANCE39640744044044044444845245779-795-52-00-5223 DENTAL INSURANCE6,3626,2356,5396,5396,5396,8667,2097,5697,94779-795-52-00-5224 VISION INSURANCE8028689489489489489761,0051,03579-795-54-00-5410 TUITION REIMBURSEMENT- - - 3,2169,6481,608- - - 79-795-54-00-5412 TRAINING & CONFERENCES2,9513,2955,0005,0005,0005,0005,0005,0005,00079-795-54-00-5415 TRAVEL & LODGING1,0285423,0003,0003,0003,0003,0003,0003,00079-795-54-00-5422 VEHICLE & EQUIPMENT CHARGEBACK20,000- - - - - - - - 79-795-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK- - 4,4124,4122,8122,2581,4596,1295,63179-795-54-00-5426 PUBLISHING & ADVERTISING52,01852,82555,00055,00055,00055,00055,00055,00055,00079-795-54-00-5440 TELECOMMUNICATIONS7,0647,7348,0008,0008,0008,0008,0008,0008,00079-795-54-00-5447 SCHOLARSHIPS- - 2,5001,0002,5002,5002,5002,5002,50079-795-54-00-5452 POSTAGE & SHIPPING2,6093,1983,5003,5003,5003,5003,5003,5003,50079-795-54-00-5460 DUES & SUBSCRIPTIONS1,1554,1133,0003,0003,0003,0003,0003,0003,00079-795-54-00-5462 PROFESSIONAL SERVICES101,289116,287100,000100,000100,000100,000100,000100,000100,00079-795-54-00-5480 UTILITIES11,97611,51513,48313,48314,29215,15016,05917,02318,04479-795-54-00-5485 RENTAL & LEASE PURCHASE1,8081,8743,0003,0003,0003,0003,0003,0003,00079-795-54-00-5488 OFFICE CLEANING- 4,1944,3193,8763,9924,1124,2354,3624,49379-795-54-00-5495 OUTSIDE REPAIR & MAINTENANCE6,061 1,273 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-795-54-00-5496 PROGRAM REFUNDS10,115 - - - - - - - - 79-795-56-00-5602 HOMETOWN DAYS SUPPLIES96,287108,177100,000110,986100,000100,000100,000100,000100,00079-795-56-00-5606 PROGRAM SUPPLIES121,860119,317160,000160,000160,000160,000160,000160,000160,00079-795-56-00-5607 CONCESSION SUPPLIES14,92615,79618,00018,00018,00018,00018,00018,00018,00079-795-56-00-5610 OFFICE SUPPLIES2,3252,8093,0003,0003,0003,0003,0003,0003,00079-795-56-00-5620 OPERATING SUPPLIES9,24012,11515,00015,00015,00015,00015,00015,00015,00047 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescription79-795-56-00-5640 REPAIR & MAINTENANCE1,2302,2792,0002,0002,0002,0002,0002,0002,00079-795-56-00-5695 GASOLINE920 899 1,070 1,000 1,0001,000 1,0001,000 1,000 962,172996,3671,122,5651,138,8371,194,7431,205,8301,228,9671,260,4631,288,152Expenditures1,842,4991,969,8322,228,5082,218,0012,343,4052,387,9372,450,5812,527,6752,596,929Surplus(Deficit)(54,885) 27,975(105,494) (57,980) (98,417) 6,6809,39611,56410,388Fund Balance445,875473,852312,946415,872317,455324,135333,531345,095355,48324.20%24.06%14.04%18.75%13.55%13.57%13.61%13.65%13.69%48 FY 2019FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024Actual Actual BudgetProjectedAdoptedProjected Projected Projected ProjectedRevenue Taxes1,372,091 1,402,659 1,464,606 1,457,087 1,492,248 1,536,157 1,563,492 1,585,093 1,619,273 Intergovernmental18,958 18,086 18,350 30,461 25,250 25,250 25,250 25,250 25,250 Fines & Forfeits7,355 9,922 8,500 8,500 8,500 8,500 8,500 8,500 8,500 Charges for Service10,208 12,750 11,500 12,750 11,750 11,750 11,750 11,750 11,750 Investment Earnings1,594 5,423 1,750 10,000 10,000 10,000 7,500 7,500 5,000 Reimbursements2,141 691- - - - - - - Miscellaneous7,099 6,488 6,750 4,350 4,000 4,000 4,000 4,000 4,000 Other Financing Sources24,044 23,775 25,179 23,485 25,003 26,458 28,000 29,635 31,368 Total Revenue1,443,490 1,479,794 1,536,635 1,546,633 1,576,751 1,622,115 1,648,492 1,671,728 1,705,141 ExpendituresSalaries 411,502 403,032 422,698 431,500 474,394 488,626 503,284 518,382 533,933 Benefits 158,182 148,184 166,150 164,659 175,658 186,526 198,219 210,723 224,094 Contractual Services 104,409 131,797 145,840 129,239 149,080 148,598 149,306 150,056 150,851 Supplies 26,927 15,088 21,200 24,770 24,200 23,200 23,200 23,200 23,200 Debt Service 752,771 760,396 792,101 792,101 797,013 827,088 840,225 847,313 866,750 Total Expenditures 1,453,791 1,458,497 1,547,989 1,542,269 1,620,345 1,674,038 1,714,234 1,749,674 1,798,828 Surplus (Deficit)(10,301) 21,297 (11,354) 4,364 (43,594) (51,923) (65,742) (77,946) (93,687) Ending Fund Balance489,057 510,355 474,039 514,719 471,125 419,202 353,460 275,514 181,827 33.64% 34.99% 30.62% 33.37% 29.08% 25.04% 20.62% 15.75% 10.11%Operational Fund Balance %69.76% 73.11% 62.71% 68.61% 57.22% 49.50% 40.44% 30.53% 19.51%Library Operations Fund (82)The Yorkville Public Library provides the people of the community, from pre-school through maturity, with access to a collection of books and other materials which will serve their educational, cultural and recreational needs. The Library board and staff strive to provide the community an environment that promotes the love of reading.$0$200$400$600ThousandsFund Balance49 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionLibrary Operations82-000-40-00-4000 PROPERTY TAXES - LIBRARY OPS626,183644,025672,505669,065699,220713,204727,468742,017756,85782-000-40-00-4083 PROPERTY TAXES - DEBT SERVICE745,908758,634792,101788,022793,028822,953836,024843,076862,41682-000-41-00-4120 PERSONAL PROPERTY TAX5,9144,9485,2505,2505,2505,2505,2505,2505,25082-000-41-00-4170 STATE GRANTS13,04413,13813,10025,21120,00020,00020,00020,00020,00082-000-43-00-4330 LIBRARY FINES7,3559,9228,5008,5008,5008,5008,5008,5008,50082-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS6,5768,0407,5008,0008,0008,0008,0008,0008,00082-000-44-00-4422 COPY FEES2,7173,8533,0003,7503,7503,7503,7503,7503,75082-000-44-00-4439 PROGRAM FEES9158571,0001,000- - - - - 82-000-45-00-45001,5944,5931,75010,00010,00010,0007,5007,5005,00082-000-45-00-4550 GAIN ON INVESTMENT- 830- - - - - - - 82-000-46-00-4690 REIMB - MISCELLANEOUS2,141691- - - - - - - 82-000-48-00-4820 RENTAL INCOME2,2001,8062,0001,6002,0002,0002,0002,0002,00082-000-48-00-4824 DVD RENTAL INCOME2,4442,8422,7501,750- - - - - 82-000-48-00-4850 MISCELLANEOUS INCOME2,4551,8402,0001,0002,0002,0002,0002,0002,00082-000-49-00-4901 TRANSFER FROM GENERAL24,044 23,775 25,179 23,485 25,003 26,458 28,000 29,635 31,368 Revenue 1,443,4901,479,7941,536,6351,546,6331,576,7511,622,1151,648,4921,671,7281,705,14182-820-50-00-5010 SALARIES & WAGES211,185213,880226,998261,500278,394286,746295,348304,208313,33482-820-50-00-5015 PART-TIME SALARIES200,317189,152195,700170,000196,000201,880207,936214,174220,59982-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION22,55822,88524,25227,50025,54127,04028,67830,42132,27382-820-52-00-5214 FICA CONTRIBUTION30,77830,16931,72031,72035,54436,61037,70838,83940,00482-820-52-00-5216 GROUP HEALTH INSURANCE74,46265,65879,31873,93181,18487,67994,693102,268110,44982-820-52-00-5222 GROUP LIFE INSURANCE40338832835138739139539940382-820-52-00-5223 DENTAL INSURANCE5,2864,6724,6526,6996,9877,3367,7038,0888,49282-820-52-00-5224 VISION INSURANCE6516377019731,0121,0121,0421,0731,10582-820-52-00-5230 UNEMPLOYMENT INSURANCE47474775060575075075075075082-820-52-00-5231 LIABILITY INSURANCE23,57023,02824,42922,88024,25325,70827,25028,88530,61882-820-54-00-5412 TRAINING & CONFERENCES3303082,5001,2002,0002,0002,0002,0002,00082-820-54-00-5415 TRAVEL & LODGING3653486001,5001,5001,5001,5001,5001,50082-820-54-00-5426 PUBLISHING & ADVERTISING2771002,0007502,0001,0001,0001,0001,00082-820-54-00-5440 TELECOMMUNICATIONS3,5244,5135,0006,0006,0006,0006,0006,0006,00082-820-54-00-5452 POSTAGE & SHIPPING39858250060075060060060060082-820-54-00-5460 DUES & SUBSCRIPTIONS9,0058,91111,00011,00011,00011,00011,00011,00011,00082-820-54-00-5462 PROFESSIONAL SERVICES38,03724,15140,00035,00040,00040,00040,00040,00040,00082-820-54-00-5466 LEGAL SERVICES- 2,1003,0003,0003,0003,0003,0003,0003,00082-820-54-00-5468 AUTOMATION12,63313,46620,00018,00020,00020,00020,00020,00020,00082-820-54-00-5480 UTILITIES10,9619,8529,54010,50011,13011,79812,50613,25614,051INVESTMENT EARNINGS50 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescription82-820-54-00-5495 OUTSIDE REPAIR & MAINTENANCE27,190 65,777 50,000 40,000 50,000 50,000 50,000 50,000 50,000 82-820-54-00-5498 PAYING AGENT FEES1,689 1,689 1,700 1,689 1,700 1,700 1,700 1,700 1,700 82-820-56-00-5610 OFFICE SUPPLIES8,9065,5188,0008,0008,0008,0008,0008,0008,00082-820-56-00-5620 LIBRARY OPERATING SUPPLIES9,6546,7332,0002,1663,0002,0002,0002,0002,00082-820-56-00-5621 CUSTODIAL SUPPLIES- - 8,0008,0008,0008,0008,0008,0008,00082-820-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE- - - 6732,0002,0002,0002,0002,00082-820-56-00-5671 LIBRARY PROGRAMMING1,2438201,0001,0001,0001,0001,0001,0001,00082-820-56-00-5676 EMPLOYEE RECOGNITION- 15120020020020020020020082-820-56-00-5684 COMPACT DISCS & OTHER MUSIC- - - - - - - - - 82-820-56-00-5685 DVD'S1,14149950050050050050050050082-820-56-00-5686BOOKS5,9831,3671,5004,2311,5001,5001,5001,5001,500Debt Service - 2006 Bond82-820-84-00-8000 PRINCIPAL PAYMENT50,00050,00050,00050,00050,00075,00075,00075,000100,00082-820-84-00-8050 INTEREST PAYMENT29,73827,36324,98824,98822,61320,23816,67513,1139,550Debt Service - 2013 Refunding Bond82-820-99-00-8000 PRINCIPAL PAYMENT500,000520,000565,000565,000585,000610,000645,000675,000700,00082-820-99-00-8050 INTEREST PAYMENT173,033 163,033 152,113 152,113 139,400 121,850 103,550 84,200 57,200 Expenditures 1,453,7911,458,4971,547,9891,542,2691,620,3451,674,0381,714,2341,749,6741,798,828Surplus(Deficit)(10,301) 21,297(11,354) 4,364(43,594) (51,923) (65,742) (77,946) (93,687) Fund Balance489,057510,355474,039514,719471,125419,202353,460275,514181,82733.64%34.99%30.62%33.37%29.08%25.04%20.62%15.75%10.11%Operational Fund Balance %69.76%73.11%62.71%68.61%57.22%49.50%40.44%30.53%19.51%51 . FY 2019 FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Licenses & Permits 53,650 100,484 43,200 110,000 50,000 50,000 50,000 50,000 50,000 Investment Earnings 12 16 10 150 100 100 100 - - Miscellaneous 130 37 - - - - - - - Total Revenue 53,792 100,537 43,210 110,150 50,100 50,100 50,100 50,000 50,000 Expenditures Contractual Services 3,844 3,425 3,500 3,500 3,500 3,500 3,500 3,500 3,500 Supplies 44,851 54,604 48,600 71,500 72,000 72,000 72,000 62,000 48,143 Capital Outlay - 3,970 - - - - - - - Total Expenditures 48,695 61,999 52,100 75,000 75,500 75,500 75,500 65,500 51,643 Surplus (Deficit)5,097 38,538 (8,890) 35,150 (25,400) (25,400) (25,400) (15,500) (1,643) Ending Fund Balance 19,904 58,443 31,274 93,593 68,193 42,793 17,393 1,893 250 Library Capital Fund (84) The Library Capital Fund derives its revenue from monies collected from building permits. The revenue is used for Library building maintenance and associated capital, contractual and supply purchases. $0 $50 $100 ThousandsFund Balance 52 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionLibrary Capital 84-000-42-00-4214 DEVELOPMENT FEES 53,450100,48443,200110,00050,000 50,000 50,000 50,000 50,000 84-000-42-00-4224 RENEW PROGRAM PERMITS200- - - - - - - - 84-000-45-00-4500121610150100100100- - 84-000-48-00-4850 MISCELLANEOUS INCOME13037- -- -- -- Revenue 53,792100,53743,210110,15050,10050,10050,10050,00050,00084-840-54-00-5406 RENEW PROGRAM200- - - - - - - - 84-840-54-00-5460E-BOOKS SUBSCRIPTION3,6443,4253,5003,5003,5003,5003,5003,5003,50084-840-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE15,4447,36715,00015,00015,00015,00015,00015,00015,00084-840-56-00-5683 AUDIO BOOKS2,7583,5311,6003,0003,5003,5003,5003,5003,50084-840-56-00-5684 COMPACT DISCS & OTHER MUSIC- 69950050050050050050050084-840-56-00-5685 DVD'S1,8431,9031,5003,0003,0003,0003,0003,0003,00084-840-56-00-5686BOOKS24,80641,10430,00050,00050,00050,00050,00040,00026,14384-840-60-00-6020 BUILDINGS & STRUCTURES- 3,970- -- -- -- Expenditures 48,69561,99952,10075,00075,50075,50075,50065,50051,643Surplus(Deficit)5,09738,538(8,890) 35,150(25,400) (25,400) (25,400) (15,500) (1,643) Fund Balance19,90458,44331,27493,59368,19342,79317,3931,893250INVESTMENT EARNINGS53 FY 2019 FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 215,360 198,294 246,261 198,918 232,318 260,762 429,192 439,922 450,920 Total Revenue 215,360 198,294 246,261 198,918 232,318 260,762 429,192 439,922 450,920 Expenditures Contractual Services 1,940 12,691 713,749 13,710 713,963 14,301 14,649 15,007 15,376 Debt Service 159,227 149,669 149,358 149,358 209,845 208,311 209,316 208,787 209,422 Total Expenditures 161,167 162,360 863,107 163,068 923,808 222,612 223,965 223,794 224,798 Surplus (Deficit)54,193 35,934 (616,846) 35,850 (691,490) 38,150 205,227 216,128 226,122 Ending Fund Balance (495,754) (459,819) (1,077,343) (423,969) (1,115,459) (1,077,309) (872,082) (655,954) (429,832) Countryside TIF Fund (87) The Countryside TIF was created in February of 2005, with the intent of constructing a future retail development at Countryside Center. This TIF is located at the northwest corner of US Route 34 and IL Route 47. ($1,500) ($1,000) ($500) $0 ThousandsFund Balance 54 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionCountryside TIF87-000-40-00-4000 PROPERTY TAXES215,360 198,294 246,261 198,918 232,318 260,762 429,192 439,922 450,920 Revenue 215,360198,294246,261198,918232,318260,762429,192439,922450,92087-870-54-00-5401 ADMINISTRATIVE CHARGEBACK- 10,70111,04911,04911,26311,60111,94912,30712,67687-870-54-00-5425 TIF INCENTIVE PAYOUT- - 700,000- 700,000- - - - 87-870-54-00-5462 PROFESSIONAL SERVICES1,2811,3292,0002,0002,0002,0002,0002,0002,00087-870-54-00-5498 PAYING AGENT FEES6596617006617007007007007002015A Bond87-870-77-00-8000 PRINCIPAL PAYMENT26,45741,00942,33642,336104,517107,163112,455116,424121,71687-870-77-00-8050 INTEREST PAYMENT82,05557,94556,30756,30754,61350,43346,14641,64836,991Debt Service - 2014 Refunding Bond87-870-93-00-8000 PRINCIPAL PAYMENT- - - - - - - - - 87-870-93-00-8050 INTEREST PAYMENT50,715 50,715 50,715 50,715 50,715 50,715 50,715 50,715 50,715 Expenditures 161,167162,360863,107163,068923,808222,612223,965223,794224,798Surplus(Deficit)54,19335,934(616,846) 35,850(691,490) 38,150205,227216,128226,122Fund Balance(495,754) (459,819) (1,077,343) (423,969) (1,115,459) (1,077,309) (872,082) (655,954) (429,832) 55 FY 2019 FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 67,307 76,186 80,000 78,417 80,000 80,000 80,000 80,000 80,000 Miscellaneous 1,456 - - - - - - - - Other Financing Sources - 800,000 - - - - - - - Total Revenue 68,763 876,186 80,000 78,417 80,000 80,000 80,000 80,000 80,000 Expenditures Contractual Services 32,016 80,349 72,533 57,533 93,246 69,213 70,209 71,235 72,292 Capital Outlay 192,894 1,574,697 216,663 87,482 114,988 17,488 17,488 13,120 10,000 Debt Service - - 225,800 225,800 218,250 212,200 206,084 - - Total Expenditures 224,910 1,655,046 514,996 370,815 426,484 298,901 293,781 84,355 82,292 Surplus (Deficit)(156,147) (778,860) (434,996) (292,398) (346,484) (218,901) (213,781) (4,355) (2,292) Ending Fund Balance 97,556 (681,305) (1,194,280) (973,703) (1,320,187) (1,539,088) (1,752,869) (1,757,224) (1,759,516) Downtown TIF Fund (88) The Downtown TIF was created in 2006, in order to finance a mixed use development in the downtown area. ($2,000) ($1,000) $0 $1,000 ThousandsFund Balance 56 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionDowntown TIF88-000-40-00-4000 PROPERTY TAXES67,30776,18680,00078,41780,00080,00080,00080,00080,00088-000-48-00-4850 MISCELLANEOUS INCOME1,456- - - - - - - - 88-000-49-00-4905 LOAN PROCEEDS- 800,000- -- -- -- Revenue 68,763876,18680,00078,41780,00080,00080,00080,00080,00088-880-54-00-5401 ADMINISTRATIVE CHARGEBACK- 30,28431,53331,53332,24633,21334,20935,23536,29288-880-54-00-5425 TIF INCENTIVE PAYOUT20,55822,72720,00020,00020,00020,00020,00020,00020,00088-880-54-00-5462 PROFESSIONAL SERVICES3044,4856,0001,0001,0001,0001,0001,0001,00088-880-54-00-5466 LEGAL SERVICES11,15422,85315,0005,00015,00015,00015,00015,00015,00088-880-54-00-5470 FACADE REHAB PROGRAM- - - - 25,000- - - - 88-880-60-00-6000 PROJECT COSTS71,97073,334179,24380,00027,50010,00010,00010,00010,00088-880-60-00-6011 PROPERTY ACQUISITION10,0001,164,449- - - - - - - 88-880-60-00-6015 DOWNTOWN HILL- - - - 50,000- - - - 88-880-60-00-6045 RIVERFRONT PARK- 329,494- - - - - - - 88-880-60-00-6048 DOWNTOWN STREETSCAPE IMPROVEMENT103,504 - 30,000- 30,000- - - - 88-880-60-00-6079 ROUTE 47 EXPANSION7,4207,4207,4207,4827,4887,4887,4883,120- FNBO Loan - 102 E Van Emmon Building88-880-81-00-8000 PRINCIPAL PAYMENT- - 200,000200,000200,000200,000200,000- - 88-880-81-00-8050 INTEREST PAYMENT- -25,800 25,800 18,250 12,200 6,084- - Expenditures 224,9101,655,046514,996370,815426,484298,901293,78184,35582,292Surplus(Deficit)(156,147) (778,860) (434,996) (292,398) (346,484) (218,901) (213,781) (4,355) (2,292) Fund Balance97,556(681,305) (1,194,280) (973,703) (1,320,187) (1,539,088) (1,752,869) (1,757,224) (1,759,516) 57 FY 2019 FY 2017 FY 2018 Adopted FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 FY 2024 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes - - - - - - - - - Investment Earnings - - - - - - - - - Total Revenue - - - - - - - - - Expenditures Contractual Services - - 10,000 10,000 35,000 10,000 10,000 10,000 10,000 Capital Outlay - - - - - - - - - Total Expenditures - - 10,000 10,000 35,000 10,000 10,000 10,000 10,000 Surplus (Deficit)- - (10,000) (10,000) (35,000) (10,000) (10,000) (10,000) (10,000) Ending Fund Balance - - (10,000) (10,000) (45,000) (55,000) (65,000) (75,000) (85,000) Downtown TIF Fund II (89) The Downtown TIF II was created in 2018, in order to help promote downtown redevelopment and support the existing Downtown TIF. ($100) ($50) $0 ThousandsFund Balance 58 FY 2017FY 2018FY 2019FY 2019FY 2020FY 2021FY 2022FY 2023FY 2024Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescriptionDowntown TIF II89-000-40-00-4000 PROPERTY TAXES- - - - - - - - - 89-000-45-00-4500 INVESTMENT EARNINGS- -- -- -- -- Revenue - - - - - - - - - 89-890-54-00-5401 ADMINISTRATIVE CHARGEBACK- - - - - - - - - 89-890-54-00-5462 PROFESSIONAL SERVICES- - - - - - - - - 89-890-54-00-5466 LEGAL SERVICES- - 10,00010,00010,00010,00010,00010,00010,00089-890-54-00-5470 FACADE REHAB PROGRAM- - - - 25,000- - - - 89-890-60-00-6000 PROJECT COSTS- -- -- -- -- Expenditures - - 10,00010,00035,00010,00010,00010,00010,000Surplus(Deficit)- - (10,000) (10,000) (35,000) (10,000) (10,000) (10,000) (10,000) Fund Balance- - (10,000) (10,000) (45,000) (55,000) (65,000) (75,000) (85,000) 59