Loading...
Ordinance 2018-26 w APR 2 201 ��!GGt� � c�tlWiY/ayr�c UNITED CITY OF YORKVILLE KENDALL COUNTY, ILLINOIS ORDINANCE NO.2018-26 ORDINANCE APPROVING THE 2018-2019 FISCAL BUDGET FOR THE UNITED CITY OF YORKVILLE Passed by the City Council of the United City of Yorkville,Kendall County,Illinois This 10"'day of April,2018 Published in pamphlet form by the authority of the Mayor and City Council of the United City of Yorkville,Kendall County,Illinois on April 23,2018. ORDINANCE NO.2018- ORDINANCE APPROVING THE 2018-2019 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 2018-2019 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 2018-2019 Fiscal Year Budget being submitted on April 10, 2018 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 2018-2019 Budget totaling $33,261,032 including the amounts of$15,952,180 General Fund, $691,787 Motor Fuel Tax Fund, $276,945 Vehicle&Equipment Fund, $3,045,454 Sewer Fund, $4,876,371 Water Fund, $2,622,153 City-Wide Capital Fund, $324,725 Debt Service Fund, $465,000 Land Cash Fund, $2,086,308 Parks&Recreation Fund, $1,547,989 Library Operations Fund, $52,100 Library Capital Fund, $863,107 Countryside TIF Fund, $419,243 Downtown TIF Fund, $10,000 Downtown TIF II Fund, $18,835 Sunflower SSA Fund, and$8,835 Fox Hill SSA Fund is hereby adopted for the 2018-2019 Fiscal Year, as presented. Passed by the City Council of the United City of Yorkville, Kend7Coun Illinois this I Oh day of April,A.D. 2018. - CITY CLERK_ — Ordinance No.2018- a�0 Page 2 CARLO COLOSIMO KEN KOCH JACKIE MILSCHEWSKI ALEX HERNANDEZ CHRIS FUNKHOUSER JOEL FRIEDERS SEAVER TARULIS JOE PLOCHER Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this 10th day of April,A.D. 2018. 1 MAYOR Ordinance No.2018- a� Page 3 FY 2018FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023Actual Actual Budget Projected Adopted Projected Projected Projected ProjectedRevenue Taxes 10,330,920 10,736,464 10,899,060 10,910,998 11,014,213 11,196,435 11,380,899 11,567,646 11,636,714 Intergovernmental 2,311,978 2,235,395 2,379,022 2,259,827 2,512,487 2,563,939 2,616,320 2,669,649 2,723,944 Licenses & Permits 213,451 315,862 253,000 361,000 336,000 311,000 311,000 311,000 311,000 Fines & Forfeits 123,639 140,250 140,225 125,545 130,400 130,400 130,400 130,400 130,400 Charges for Service 1,401,384 1,465,678 1,365,564 1,500,764 1,535,112 1,564,043 1,593,697 1,624,092 1,655,247 Investment Earnings 6,394 21,197 15,000 35,000 20,000 10,000 5,000 2,500 - Reimbursements 113,024 66,449 55,000 64,338 55,000 55,000 55,000 55,000 55,000 Miscellaneous 21,919 19,848 23,750 21,750 21,750 21,750 21,750 21,750 21,750 Other Financing Sources 7,077 9,645 7,000 30,000 18,000 16,500 16,500 16,500 16,500 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. Total Revenue 14,529,786 15,010,788 15,137,621 15,309,222 15,642,962 15,869,067 16,130,566 16,398,537 16,550,555 ExpendituresSalaries 3,958,489 4,212,964 4,618,075 4,575,428 4,901,639 5,029,096 5,169,645 5,314,413 5,463,523 Benefits 2,447,779 2,635,062 3,086,500 2,903,642 3,056,457 3,234,883 3,427,626 3,626,340 3,834,758 Contractual Services 4,593,459 4,793,382 4,794,807 4,960,921 4,937,900 5,019,490 4,932,650 4,997,450 4,958,228 Supplies 216,288 197,932 274,353 274,642 330,998 455,361 444,941 449,750 419,800 Other Financing Uses 2,448,123 2,649,065 2,948,210 3,030,682 2,725,186 2,434,185 2,471,283 2,946,296 3,163,551 Total Expenditures 13,664,138 14,488,405 15,721,945 15,745,315 15,952,180 16,173,015 16,446,145 17,334,249 17,839,860 Surplus (Deficit) 865,648 522,383 (584,324) (436,093) (309,218) (303,948) (315,579) (935,712) (1,289,305) Ending Fund Balance 5,691,706 6,214,089 5,383,778 5,777,996 5,468,778 5,164,830 4,849,251 3,913,539 2,624,234 41.65% 42.89% 34.24% 36.70% 34.28% 31.93% 29.49% 22.58% 14.71%$0$2,000 $4,000 $6,000 $8,000 ThousandsFund Balance$0 $2,000 $4,000 $6,000 $8,000 ThousandsFund Balance FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected Projected 01-000-40-00-4000 PROPERTY TAXES - CORPORATE LEVY 2,278,321 2,206,925 2,124,299 2,129,984 2,191,279 2,235,105 2,279,807 2,325,403 2,371,911 01-000-40-00-4010 PROPERTY TAXES - POLICE PENSION 703,105 817,490 966,211 963,908 958,544 1,008,544 1,058,544 1,108,544 1,158,544 01-000-40-00-4030 MUNICIPAL SALES TAX 2,778,116 2,940,976 3,012,750 2,965,000 3,009,475 3,054,617 3,100,436 3,146,943 3,194,147 01-000-40-00-4035 NON-HOME RULE SALES TAX 2,126,851 2,259,787 2,332,950 2,305,000 2,339,575 2,374,669 2,410,289 2,446,443 2,483,140 01-000-40-00-4040 ELECTRIC UTILITY TAX 689,084 710,892 675,000 705,000 695,000 695,000 695,000 695,000 695,000 01-000-40-00-4041 NATURAL GAS UTILITY TAX 207,551 241,699 240,000 240,000 240,000 240,000 240,000 240,000 240,000 01-000-40-00-4043 EXCISE TAX 393,680 359,947 361,000 335,000 325,000 325,000 325,000 325,000 325,000 01-000-40-00-4044 TELEPHONE UTILITY TAX 8,499 8,340 8,300 8,340 8,340 8,340 8,340 8,340 8,340 01-000-40-00-4045 CABLE FRANCHISE FEES 286,944 294,275 285,000 294,000 290,000 290,000 290,000 290,000 290,000 01-000-40-00-4050 HOTEL TAX 80,422 72,407 85,000 80,000 80,000 80,000 80,000 80,000 80,000 01-000-40-00-4055 VIDEO GAMING TAX 74,734 100,457 90,000 110,000 110,000 110,000 110,000 110,000 110,000 01-000-40-00-4060 AMUSEMENT TAX 201,216 200,284 200,000 200,000 200,000 200,000 200,000 200,000 200,000 01-000-40-00-4065 ADMISSIONS TAX 121,799 122,007 120,000 130,766 120,000 120,000 120,000 120,000 - 01-000-40-00-4070 BUSINESS DISTRICT TAX - KENDALL MRKT 350,589 359,093 372,300 400,000 408,000 416,160 424,483 432,973 441,632 01-000-40-00-4071 BUSINESS DISTRICT TAX - DOWNTOWN 6,879 15,992 4,000 20,000 15,000 15,000 15,000 15,000 15,000 01-000-40-00-4072 BUSINESS DISTRICT TAX - COUNTRYSIDE 11,431 12,071 11,000 11,000 11,000 11,000 11,000 11,000 11,000 01-000-40-00-4075 AUTO RENTAL TAX 11,699 13,822 11,250 13,000 13,000 13,000 13,000 13,000 13,000 01-000-41-00-4100 STATE INCOME TAX 1,715,155 1,602,410 1,739,021 1,617,435 1,822,308 1,858,754 1,895,929 1,933,848 1,972,525 01-000-41-00-4105 LOCAL USE TAX 390,605 417,212 436,101 454,679 500,279 510,285 520,491 530,901 541,519 01-000-41-00-4110 ROAD & BRIDGE TAX 148,223 145,522 150,000 131,612 135,000 140,000 145,000 150,000 155,000 01-000-41-00-4120 PERSONAL PROPERTY TAX 16,065 17,845 17,000 17,000 17,000 17,000 17,000 17,000 17,000 01-000-41-00-4160 FEDERAL GRANTS 17,726 16,810 15,000 16,000 16,000 16,000 16,000 16,000 16,000 01-000-41-00-4168 21,342 31,606 21,000 22,201 21,000 21,000 21,000 21,000 21,000 01-000-41-00-4170 STATE GRANTS 2,000 3,000 - - - - - - - 01-000-41-00-4182 MISC INTERGOVERNMENTAL 862 990 900 900 900 900 900 900 900 01-000-42-00-4200 LIQUOR LICENSES 46,442 52,852 50,000 56,000 56,000 56,000 56,000 56,000 56,000 01-000-42-00-4205 OTHER LICENSES & PERMITS 3,902 6,795 3,000 5,000 5,000 5,000 5,000 5,000 5,000 01-000-42-00-4210 BUILDING PERMITS 163,107 256,215 200,000 300,000 275,000 250,000 250,000 250,000 250,000 01-000-43-00-4310 CIRCUIT COURT FINES 43,063 41,512 45,000 45,000 45,000 45,000 45,000 45,000 45,000 01-000-43-00-4320 ADMINISTRATIVE ADJUDICATION 24,406 33,512 30,000 30,000 30,000 30,000 30,000 30,000 30,000 01-000-43-00-4323 OFFENDER REGISTRATION FEES 220 420 225 545 400 400 400 400 400 01-000-43-00-4325 POLICE TOWS 55,950 64,806 65,000 50,000 55,000 55,000 55,000 55,000 55,000 01-000-44-00-4400 GARBAGE SURCHARGE 1,218,991 1,284,044 1,000,000 1,129,000 1,157,225 1,186,156 1,215,810 1,246,205 1,277,360 01-000-44-00-4405 UB COLLECTION FEES 153,292 158,062 154,000 160,000 160,000 160,000 160,000 160,000 160,000 01-000-44-00-4407 LATE PENALTIES - GARBAGE 22,972 22,772 23,000 23,000 23,000 23,000 23,000 23,000 23,000 01-000-44-00-4415 ADMINISTRATIVE CHARGEBACK - - 188,064 188,064 194,387 194,387 194,387 194,387 194,387 01-000-44-00-4474 POLICE SPECIAL DETAIL 6,129 800 500 700 500 500 500 500 500 01-000-45-00-4500 6,394 21,197 15,000 35,000 20,000 10,000 5,000 2,500 - GENERAL FUND - 01 Description INVESTMENT EARNINGS STATE GRANTS - TRAFFIC SIGNAL MAINTENANCE FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription 01-000-46-00-4604 REIMB - ENGINEERING EXPENSES 15,196 6,684 25,000 971 25,000 25,000 25,000 25,000 25,000 01-000-46-00-4680 REIMB - LIABILITY INSURANCE 32,294 9,213 5,000 15,000 5,000 5,000 5,000 5,000 5,000 01-000-46-00-4685 REIMB - CABLE CONSORTIUM 21,030 33,163 20,000 23,267 20,000 20,000 20,000 20,000 20,000 01-000-46-00-4690 REIMB - MISCELLANEOUS 44,504 17,389 5,000 25,100 5,000 5,000 5,000 5,000 5,000 01-000-48-00-4820 RENTAL INCOME 6,905 7,285 6,750 6,750 6,750 6,750 6,750 6,750 6,750 01-000-48-00-4845 DONATIONS - - 2,000 - - - - - - 01-000-48-00-4850 MISCELLANEOUS INCOME 15,014 12,563 15,000 15,000 15,000 15,000 15,000 15,000 15,000 01-000-49-00-4916 TRANSFER FROM CW MUNICIPAL BUILDING 7,077 9,645 7,000 30,000 18,000 16,500 16,500 16,500 16,500 Revenue 14,529,786 15,010,788 15,137,621 15,309,222 15,642,962 15,869,067 16,130,566 16,398,537 16,550,555 FY 2018 FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 388,629 460,265 525,478 528,800 579,552 585,749 601,401 617,523 634,129 Benefits 150,348 161,660 206,137 199,235 224,357 238,063 253,551 270,230 288,093 Contractual Services 115,668 140,692 135,660 133,522 141,990 122,603 125,334 127,165 129,860 Supplies 10,624 7,563 10,000 10,000 10,000 10,000 10,000 10,000 10,000 Total Administration 665,269 770,180 877,275 871,557 955,899 956,415 990,286 1,024,918 1,062,082 ADMINISTRATION DEPARTMENT The 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,200 Thousands FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Administration 01-110-50-00-5001 SALARIES - MAYOR 9,735 10,175 11,000 10,300 11,000 11,000 11,000 11,000 11,000 01-110-50-00-5002 SALARIES - LIQUOR COMM 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 01-110-50-00-5003 SALARIES - CITY CLERK 6,935 7,440 9,000 7,500 8,000 - - - - 01-110-50-00-5004 SALARIES - CITY TREASURER 1,000 1,000 1,000 1,000 1,000 - - - - 01-110-50-00-5005 SALARIES - ALDERMAN 48,690 46,465 52,000 49,000 52,000 52,000 52,000 52,000 52,000 01-110-50-00-5010 SALARIES - ADMINISTRATION 317,586 389,175 450,978 460,000 506,552 521,749 537,401 553,523 570,129 01-110-50-00-5015 PART-TIME SALARIES 3,683 4,984 - - - - - - - 01-110-50-00-5020 OVERTIME - 26 500 - - - - - - 01-110-52-00-5212 RETIREMENT PLAN CONTRIBUTION 36,387 41,833 49,506 49,506 54,119 57,288 60,726 64,430 68,358 01-110-52-00-5214 FICA CONTRIBUTION 25,422 30,324 36,665 36,000 40,339 40,841 42,066 43,328 44,628 01-110-52-00-5216 GROUP HEALTH INSURANCE 81,297 82,328 111,978 104,948 120,465 130,102 140,510 151,751 163,891 01-110-52-00-5222 GROUP LIFE INSURANCE 491 492 557 675 451 456 461 466 471 01-110-52-00-5223 DENTAL INSURANCE 5,516 5,924 6,612 7,145 7,853 8,246 8,658 9,091 9,546 01-110-52-00-5224 VISION INSURANCE 721 759 819 961 1,130 1,130 1,130 1,164 1,199 01-110-52-00-5235 489 - - - - - - - - 01-110-52-00-5236 4 - - - - - - - - 01-110-52-00-5237 (40) - - - - - - - - 01-110-52-00-5238 61 - - - - - - - - 01-110-54-00-5410 TUITION REIMBURSEMENT 3,216 8,040 12,000 7,500 13,000 - - - - 01-110-54-00-5412 TRAINING & CONFERENCES 5,440 11,051 20,800 20,800 17,000 12,000 12,000 12,000 12,000 01-110-54-00-5415 TRAVEL & LODGING 8,241 12,097 9,000 9,000 9,000 9,000 9,000 9,000 9,000 01-110-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - - 4,568 1,654 2,778 2,916 3,828 01-110-54-00-5426 PUBLISHING & ADVERTISING 1,262 6,219 5,000 5,000 5,000 5,000 5,000 5,000 5,000 01-110-54-00-5430 PRINTING & DUPLICATING 2,890 2,376 4,000 4,000 3,250 3,250 3,250 3,250 3,250 01-110-54-00-5440 TELECOMMUNICATIONS 13,620 15,623 16,000 18,500 19,000 19,000 19,000 19,000 19,000 01-110-54-00-5448 FILING FEES 49 212 500 250 500 500 500 500 500 01-110-54-00-5451 CODIFICATION 12,002 1,579 5,000 5,000 5,000 5,000 5,000 5,000 5,000 01-110-54-00-5452 POSTAGE & SHIPPING 2,418 1,297 3,500 2,500 3,000 3,000 3,000 3,000 3,000 01-110-54-00-5460 DUES & SUBSCRIPTIONS 15,869 16,251 17,000 17,000 17,000 17,000 17,000 17,000 17,000 01-110-54-00-5462 PROFESSIONAL SERVICES 18,739 28,261 11,000 12,000 12,000 12,000 12,000 12,000 12,000 01-110-54-00-5480 UTILITIES 14,862 16,959 16,960 18,500 19,610 20,787 22,034 23,356 24,757 01-110-54-00-5485 RENTAL & LEASE PURCHASE 2,224 2,102 2,400 2,150 2,400 2,400 2,400 2,400 2,400 01-110-54-00-5488 OFFICE CLEANING 14,836 18,625 12,500 11,322 11,662 12,012 12,372 12,743 13,125 01-110-56-00-5610 OFFICE SUPPLIES 10,624 7,563 10,000 10,000 10,000 10,000 10,000 10,000 10,000 665,269 770,180 877,275 871,557 955,899 956,415 990,286 1,024,918 1,062,082 ELECTED OFFICIAL - VISION INSURANCE ELECTED OFFICIAL - GROUP LIFE INSURANCE ELECTED OFFICIAL - DENTAL INSURANCE ELECTED OFFICIAL - GROUP HEALTH INSURANCE FY 2018 FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 218,467 234,874 252,079 252,079 272,370 280,541 288,957 297,626 306,555 Benefits 75,570 78,103 115,958 105,375 119,623 127,339 134,719 142,625 151,076 Contractual Services 79,872 83,934 95,420 86,400 95,936 94,000 94,900 97,258 101,814 Supplies 2,650 2,528 2,700 2,700 2,700 2,700 2,700 2,700 2,700 Total Finance 376,559 399,439 466,157 446,554 490,629 504,580 521,276 540,209 562,145 FINANCE DEPARTMENT The 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 Thousands FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Finance 01-120-50-00-5010 SALARIES & WAGES 218,467 234,874 252,079 252,079 272,370 280,541 288,957 297,626 306,555 01-120-52-00-5212 RETIREMENT PLAN CONTRIBUTION 24,017 25,473 27,519 27,519 29,100 30,803 31,727 32,679 33,660 01-120-52-00-5214 FICA CONTRIBUTION 16,643 17,647 18,884 19,125 19,988 20,588 21,206 21,842 22,497 01-120-52-00-5216 GROUP HEALTH INSURANCE 28,500 28,337 62,533 52,370 64,390 69,541 75,104 81,112 87,601 01-120-52-00-5222 GROUP LIFE INSURANCE 368 334 334 334 246 248 250 253 256 01-120-52-00-5223 DENTAL INSURANCE 5,385 5,655 6,031 5,319 5,192 5,452 5,725 6,011 6,312 01-120-52-00-5224 VISION INSURANCE 657 657 657 708 707 707 707 728 750 01-120-54-00-5412 TRAINING & CONFERENCES 3,167 2,911 3,500 3,500 3,500 3,500 3,500 3,500 3,500 01-120-54-00-5414 AUDITING SERVICES 33,000 34,000 35,420 29,000 33,200 34,100 35,000 35,900 40,000 01-120-54-00-5415 TRAVEL & LODGING 274 261 1,500 500 1,000 1,000 1,000 1,000 1,000 01-120-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - - 2,836 - - 1,458 1,914 01-120-54-00-5430 PRINTING & DUPLICATING 2,853 2,572 4,000 3,000 3,500 3,500 3,500 3,500 3,500 01-120-54-00-5440 TELECOMMUNICATIONS 1,153 1,150 1,200 1,200 1,250 1,250 1,250 1,250 1,250 01-120-54-00-5452 POSTAGE & SHIPPING 1,104 1,033 1,300 1,000 1,200 1,200 1,200 1,200 1,200 01-120-54-00-5460 DUES & SUBSCRIPTIONS 528 1,010 1,000 1,000 1,250 1,250 1,250 1,250 1,250 01-120-54-00-5462 PROFESSIONAL SERVICES 35,714 39,002 45,000 45,000 46,000 46,000 46,000 46,000 46,000 01-120-54-00-5485 RENTAL & LEASE PURCHASE 2,079 1,995 2,500 2,200 2,200 2,200 2,200 2,200 2,200 01-120-56-00-5610 OFFICE SUPPLIES 2,650 2,528 2,700 2,700 2,700 2,700 2,700 2,700 2,700 376,559 399,439 466,157 446,554 490,629 504,580 521,276 540,209 562,145 FY 2018 FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 2,659,975 2,780,763 2,974,162 2,946,009 3,151,723 3,240,125 3,331,179 3,424,965 3,521,564 Benefits 1,565,443 1,728,589 2,001,658 1,911,606 1,960,422 2,071,062 2,191,334 2,316,987 2,448,201 Contractual Services 349,348 297,858 447,697 406,442 296,620 282,512 287,176 279,775 284,086 Supplies 98,647 96,715 134,700 123,039 127,560 130,663 133,921 137,342 140,934 Total Police 4,673,413 4,903,925 5,558,217 5,387,096 5,536,325 5,724,362 5,943,610 6,159,069 6,394,785 POLICE DEPARTMENT The 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 Thousands FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Police 01-210-50-00-5008 SALARIES - POLICE OFFICERS 1,585,447 1,542,800 1,660,659 1,655,000 1,775,116 1,828,369 1,883,220 1,939,717 1,997,909 01-210-50-00-5011 SALARIES - POLICE CHIEF & DEPUTIES 341,359 351,000 370,238 366,000 385,551 397,118 409,032 421,303 433,942 01-210-50-00-5012 SALARIES - SERGEANTS 447,154 577,455 593,259 593,259 616,592 635,090 654,143 673,767 693,980 01-210-50-00-5013 SALARIES - POLICE CLERKS 132,096 136,050 147,006 153,750 169,464 174,548 179,784 185,178 190,733 01-210-50-00-5014 SALARIES - CROSSING GUARD 22,945 23,437 22,000 22,000 24,000 24,000 24,000 24,000 24,000 01-210-50-00-5015 PART-TIME SALARIES 43,667 50,180 70,000 45,000 70,000 70,000 70,000 70,000 70,000 01-210-50-00-5020 OVERTIME 87,307 99,841 111,000 111,000 111,000 111,000 111,000 111,000 111,000 01-210-52-00-5212 RETIREMENT PLAN CONTRIBUTION 14,283 14,661 16,048 16,500 18,105 19,165 20,316 21,555 22,869 01-210-52-00-5213 722,940 825,413 966,211 966,211 963,361 1,008,544 1,058,544 1,108,544 1,158,544 01-210-52-00-5214 FICA CONTRIBUTION 195,360 204,346 221,572 218,000 234,853 241,899 249,156 256,631 264,330 01-210-52-00-5216 GROUP HEALTH INSURANCE 576,302 626,179 734,805 651,856 686,289 741,192 800,487 864,526 933,688 01-210-52-00-5222 GROUP LIFE INSURANCE 3,817 3,416 3,514 4,125 2,619 2,645 2,671 2,698 2,725 01-210-52-00-5223 DENTAL INSURANCE 46,802 48,646 53,189 48,269 48,434 50,856 53,399 56,069 58,872 01-210-52-00-5224 VISION INSURANCE 5,939 5,928 6,319 6,645 6,761 6,761 6,761 6,964 7,173 01-210-54-00-5410 TUITION REIMBURSEMENT 3,216 9,832 21,547 8,442 15,000 2,800 2,800 2,800 2,800 01-210-54-00-5411 POLICE COMMISSION 996 3,198 15,000 15,000 4,000 4,000 15,000 4,000 4,000 01-210-54-00-5412 TRAINING & CONFERENCE 7,879 12,433 21,000 21,000 21,000 21,000 21,000 21,000 21,000 01-210-54-00-5415 TRAVEL & LODGING 2,671 1,253 10,000 7,000 10,000 10,000 10,000 10,000 10,000 01-210-54-00-5422 VEHICLE & EQUIPMENT CHARGEBACK 174,263 97,459 167,600 150,656 31,450 34,000 29,000 29,000 29,000 01-210-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - - 9,358 4,300 2,604 5,832 9,761 01-210-54-00-5426 PUBLISHING & ADVERTISING - 395 200 - - - - - - 01-210-54-00-5430 PRINTING & DUPLICATING 4,863 7,931 4,500 4,500 4,500 4,500 4,500 4,500 4,500 01-210-54-00-5440 TELECOMMUNICATIONS 29,512 35,130 36,500 36,500 36,500 36,500 36,500 36,500 36,500 01-210-54-00-5452 POSTAGE & SHIPPING 980 1,129 1,600 1,200 1,600 1,600 1,600 1,600 1,600 01-210-54-00-5460 DUES & SUBSCRIPTIONS 1,990 9,100 3,750 5,300 5,300 5,300 5,300 5,300 5,300 01-210-54-00-5462 PROFESSIONAL SERVICES 16,861 21,923 31,000 30,000 30,000 30,000 30,000 30,000 30,000 01-210-54-00-5466 LEGAL SERVICES - - 5,000 - - - - - - 01-210-54-00-5467 ADJUDICATION SERVICES 16,684 18,560 20,000 20,000 20,000 20,000 20,000 20,000 20,000 01-210-54-00-5469 NEW WORLD & LIVE SCAN 16,921 12,489 19,500 19,500 19,500 19,500 19,500 19,500 19,500 01-210-54-00-5472 KENDALL CO JUVE PROBATION 2,894 3,239 4,000 4,000 4,000 4,000 4,000 4,000 4,000 01-210-54-00-5484 MDT - ALERTS FEE 6,660 6,660 7,000 6,660 7,000 7,000 7,000 7,000 7,000 01-210-54-00-5485 RENTAL & LEASE PURCHASE 5,903 6,010 7,000 5,362 5,750 6,000 6,000 6,000 6,000 01-210-54-00-5488 OFFICE CLEANING - - 12,500 11,322 11,662 12,012 12,372 12,743 13,125 01-210-54-00-5495 OUTSIDE REPAIR & MAINTENANCE 57,055 51,117 60,000 60,000 60,000 60,000 60,000 60,000 60,000 01-210-56-00-5600 WEARING APPAREL 12,562 10,641 23,000 15,000 15,000 15,000 15,000 15,000 15,000 01-210-56-00-5610 OFFICE SUPPLIES 2,299 1,883 4,500 4,500 4,500 4,500 4,500 4,500 4,500 01-210-56-00-5620 OPERATING SUPPLIES 14,123 9,123 10,000 16,000 16,000 16,000 16,000 16,000 16,000 01-210-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE 5,473 5,961 12,000 12,500 12,500 12,500 12,500 12,500 12,500 01-210-56-00-5640 REPAIR & MAINTENANCE 302 604 3,000 - - - - - - EMPLOYER CONTRIBUTION - POLICE PENSION FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription 01-210-56-00-5650 COMMUNITY SERVICES 300 1,012 2,000 1,039 1,500 1,500 1,500 1,500 1,500 01-210-56-00-5690 BALISTIC VESTS 5,281 4,636 6,000 6,000 6,000 6,000 6,000 6,000 6,000 01-210-56-00-5695 GASOLINE 58,009 54,933 64,200 58,000 62,060 65,163 68,421 71,842 75,434 01-210-56-00-5696 AMMUNITION 298 7,922 10,000 10,000 10,000 10,000 10,000 10,000 10,000 4,673,413 4,903,925 5,558,217 5,387,096 5,536,325 5,724,362 5,943,610 6,159,069 6,394,785 FY 2018 FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 339,512 374,208 457,067 435,000 488,585 501,803 515,417 529,440 543,883 Benefits 150,738 138,585 177,490 150,301 179,347 190,594 202,691 215,708 229,633 Contractual Services 102,815 49,929 51,900 48,950 153,174 110,873 62,675 51,008 50,452 Supplies 8,877 11,236 14,190 13,640 8,540 8,655 8,775 8,901 9,034 Total Community Development 601,942 573,958 700,647 647,891 829,646 811,925 789,558 805,057 833,002 COMMUNITY DEVELOPMENT DEPARTMENT The 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 Thousands FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Community Development 01-220-50-00-5010 SALARIES & WAGES 321,278 331,861 409,067 411,000 440,585 453,803 467,417 481,440 495,883 01-220-50-00-5015 PART-TIME SALARIES 18,234 42,347 48,000 24,000 48,000 48,000 48,000 48,000 48,000 01-220-52-00-5212 RETIREMENT PLAN CONTRIBUTION 34,748 35,454 44,657 44,657 47,071 49,828 52,818 56,040 59,456 01-220-52-00-5214 FICA CONTRIBUTION 24,811 27,585 34,320 32,500 36,504 37,599 38,727 39,889 41,086 01-220-52-00-5216 GROUP HEALTH INSURANCE 84,090 69,889 90,525 66,291 88,827 95,933 103,608 111,897 120,849 01-220-52-00-5222 GROUP LIFE INSURANCE 491 401 557 491 393 397 401 405 409 01-220-52-00-5223 DENTAL INSURANCE 5,866 4,669 6,612 5,590 5,706 5,991 6,291 6,606 6,936 01-220-52-00-5224 VISION INSURANCE 732 587 819 772 846 846 846 871 897 01-220-54-00-5412 TRAINING & CONFERENCES 3,789 1,537 6,800 5,200 7,300 7,300 7,300 7,300 7,300 01-220-54-00-5415 TRAVEL & LODGING 5,316 219 6,500 6,500 6,500 6,500 6,500 6,500 6,500 01-220-54-00-5422 VEHICLE & EQUIPMENT CHARGEBACK - - - - 40,000 - - - - 01-220-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - - 3,624 1,323 3,125 1,458 4,402 01-220-54-00-5426 PUBLISHING & ADVERTISING 2,450 3,659 2,500 2,500 2,500 2,500 2,500 2,500 2,500 01-220-54-00-5430 PRINTING & DUPLICATING 1,286 883 2,000 1,500 1,500 1,500 1,500 1,500 1,500 01-220-54-00-5440 TELECOMMUNICATIONS 3,011 4,008 3,500 4,000 4,000 4,000 4,000 4,000 4,000 01-220-54-00-5452 POSTAGE & SHIPPING 610 535 2,500 1,000 1,000 1,000 1,000 1,000 1,000 01-220-54-00-5459 INSPECTIONS 455 595 5,000 5,000 5,000 5,000 5,000 5,000 5,000 01-220-54-00-5460 DUES & SUBSCRIPTIONS 1,570 2,222 2,100 2,100 2,100 2,100 2,100 2,100 2,100 01-220-54-00-5462 PROFESSIONAL SERVICES 81,028 33,139 18,000 18,000 76,500 76,500 26,500 16,500 13,000 01-220-54-00-5485 RENTAL & LEASE PURCHASE 3,300 3,132 3,000 3,150 3,150 3,150 3,150 3,150 3,150 01-220-56-00-5610 OFFICE SUPPLIES 2,862 1,742 1,500 1,500 1,500 1,500 1,500 1,500 1,500 01-220-56-00-5620 OPERATING SUPPLIES 3,848 4,575 4,200 4,200 3,000 3,000 3,000 3,000 3,000 01-220-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE 857 2,985 5,100 5,100 1,000 1,000 1,000 1,000 1,000 01-220-56-00-5645 BOOKS & PUBLICATIONS 508 254 1,250 700 750 750 750 750 750 01-220-56-00-5695 GASOLINE 802 1,680 2,140 2,140 2,290 2,405 2,525 2,651 2,784 601,942 573,958 700,647 647,891 829,646 811,925 789,558 805,057 833,002 FY 2018 FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 345,777 362,054 382,325 396,100 408,909 420,378 432,191 444,359 456,892 Benefits 178,885 196,446 214,046 200,756 197,100 210,063 224,019 239,056 255,178 Contractual Services 1,537,504 1,450,218 1,242,124 1,289,737 1,304,948 1,438,995 1,359,856 1,395,563 1,434,533 Supplies 67,617 68,784 107,763 110,263 167,198 288,343 274,545 275,807 242,132 Total Public Works 2,129,783 2,077,502 1,946,258 1,996,856 2,078,155 2,357,779 2,290,611 2,354,785 2,388,735 PUBLIC WORKS DEPARTMENT - STREET OPERATIONS / HEALTH & SANITATION The 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,000 Thousands FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Public Works - Street Operations 01-410-50-00-5010 SALARIES & WAGES 329,967 339,927 355,725 357,500 382,309 393,778 405,591 417,759 430,292 01-410-50-00-5015 PART-TIME SALARIES 7,709 8,455 11,600 11,600 11,600 11,600 11,600 11,600 11,600 01-410-50-00-5020 OVERTIME 8,101 13,672 15,000 27,000 15,000 15,000 15,000 15,000 15,000 01-410-52-00-5212 RETIREMENT PLAN CONTRIBUTION 36,546 37,768 40,471 41,000 42,448 44,884 47,527 50,373 53,391 01-410-52-00-5214 FICA CONTRIBUTION 25,567 26,608 28,250 29,000 30,161 31,066 31,998 32,958 33,947 01-410-52-00-5216 GROUP HEALTH INSURANCE 106,676 121,383 134,171 121,269 115,626 124,876 134,866 145,655 157,307 01-410-52-00-5222 GROUP LIFE INSURANCE 645 610 594 594 437 441 445 449 453 01-410-52-00-5223 DENTAL INSURANCE 8,406 9,010 9,461 7,827 7,363 7,731 8,118 8,524 8,950 01-410-52-00-5224 VISION INSURANCE 1,045 1,067 1,099 1,066 1,065 1,065 1,065 1,097 1,130 01-410-54-00-5412 TRAINING & CONFERENCES 6,514 2,895 3,000 3,000 3,000 3,000 3,000 3,000 3,000 01-410-54-00-5415 TRAVEL & LODGING - 1,157 2,000 2,000 2,000 2,000 2,000 2,000 2,000 01-410-54-00-5422 VEHICLE & EQUIPMENT CHARGEBACK 194,379 63,626 75,965 38,831 - - - - 2,826 01-410-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - - 1,523 - 868 3,402 1,276 01-410-54-00-5435 TRAFFIC SIGNAL MAINTENANCE 23,108 18,871 25,000 20,000 20,000 20,000 20,000 20,000 20,000 01-410-54-00-5440 TELECOMMUNICATIONS 2,449 2,751 3,000 3,500 3,500 3,500 3,500 3,500 3,500 01-410-54-00-5455 MOSQUITO CONTROL 7,002 7,142 7,142 7,142 7,499 7,874 8,268 8,681 9,115 01-410-54-00-5458 TREE & STUMP MAINTENANCE 8,225 8,980 20,000 10,000 15,000 15,000 15,000 15,000 15,000 01-410-54-00-5462 PROFESSIONAL SERVICES 3,906 6,428 3,500 3,500 4,000 4,000 4,000 4,000 4,000 01-410-54-00-5482 STREET LIGHTING 3,296 426 750 450 9,000 112,360 - - - 01-410-54-00-5483 JULIE SERVICES - - - - 3,000 3,000 3,000 3,000 3,000 01-410-54-00-5485 RENTAL & LEASE PURCHASE 793 6,162 3,600 2,500 6,000 6,000 6,000 6,000 6,000 01-410-54-00-5488 OFFICE CLEANING - - 4,167 1,164 1,199 1,235 1,272 1,310 1,349 01-410-54-00-5490 VEHICLE MAINTENANCE SERVICES 48,132 30,385 55,000 55,000 55,000 55,000 55,000 55,000 55,000 01-410-56-00-5600 WEARING APPAREL 5,043 4,620 4,863 4,863 5,100 5,100 5,100 5,100 5,100 01-410-56-00-5618 SALT - - - - - 120,000 120,000 120,000 120,000 01-410-56-00-5619 SIGNS - - - - 15,000 15,000 - - - 01-410-56-00-5620 OPERATING SUPPLIES 8,828 5,287 20,500 25,000 10,000 10,000 10,000 10,000 10,000 01-410-56-00-5626 HANGING BASKETS - - 2,000 - - - - - - 01-410-56-00-5628 VEHICLE MAINTENANCE SUPPLIES 15,265 27,441 34,000 34,000 30,000 30,000 30,000 30,000 30,000 01-410-56-00-5630 SMALL TOOLS & EQUIPMENT 3,415 3,270 5,000 5,000 6,000 6,000 6,000 6,000 6,000 01-410-56-00-5632 ASPHALT PATCHING - - - - 35,000 35,000 35,000 35,000 - 01-410-56-00-5640 REPAIR & MAINTENANCE 20,580 12,775 20,000 20,000 25,000 25,000 25,000 25,000 25,000 01-410-56-00-5642 STREET LIGHTING SUPPLIES - - - - 17,000 17,000 17,000 17,000 17,000 01-410-56-00-5665 JULIE SUPPLIES - - - - 1,200 1,200 1,200 1,200 1,200 01-410-56-00-5695 GASOLINE 14,486 15,391 21,400 21,400 22,898 24,043 25,245 26,507 27,832 890,083 776,107 907,258 854,206 903,928 1,151,753 1,052,663 1,084,115 1,080,268 FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Public Works - Health & Sanitation 01-540-54-00-5441 GARBAGE SERVICES - SENIOR SUBSIDY 33,486 35,103 33,000 31,306 32,089 32,891 33,713 34,556 35,420 01-540-54-00-5442 GARBAGE SERVICES 1,201,414 1,262,212 1,000,000 1,107,504 1,137,138 1,168,135 1,199,235 1,231,114 1,268,047 01-540-54-00-5443 LEAF PICKUP 4,800 4,080 6,000 3,840 5,000 5,000 5,000 5,000 5,000 1,239,700 1,301,395 1,039,000 1,142,650 1,174,227 1,206,026 1,237,948 1,270,670 1,308,467 2,129,783 2,077,502 1,946,258 1,996,856 2,078,155 2,357,779 2,290,611 2,354,785 2,388,735 Total Public Works FY 2018 FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 6,129 800 26,964 17,440 500 500 500 500 500 Benefits 326,795 331,679 371,211 336,369 375,608 397,762 421,312 441,734 462,577 Contractual Services 2,408,252 2,770,751 2,822,006 2,995,870 2,945,232 2,970,507 3,002,709 3,046,681 2,957,483 Supplies 27,873 11,106 5,000 15,000 15,000 15,000 15,000 15,000 15,000 Other Financing Uses 2,448,123 2,649,065 2,948,210 3,030,682 2,725,186 2,434,185 2,471,283 2,946,296 3,163,551 Total Admin Services & Transfers 5,217,172 5,763,401 6,173,391 6,395,361 6,061,526 5,817,954 5,910,804 6,450,211 6,599,111 ADMINISTRATIVE SERVICES DEPARTMENT The 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. $0 $1,000 $2,000 $3,000 $4,000 $5,000 $6,000 $7,000 Thousands FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Administrative Services 01-640-50-00-5016 SALARIES - SPECIAL CENSUS - - 26,464 16,740 - - - - - 01-640-50-00-5092 POLICE SPECIAL DETAIL WAGES 6,129 800 500 700 500 500 500 500 500 01-640-52-00-5214 FICA CONTRIBUTION - SPECIAL CENSUS - - - 1,281 - - - - - 01-640-52-00-5230 UNEMPLOYMENT INSURANCE 18,460 11,298 20,000 10,527 20,000 20,000 20,000 20,000 20,000 01-640-52-00-5231 LIABILITY INSURANCE 279,135 286,792 308,503 295,955 313,712 332,535 352,487 373,636 396,054 01-640-52-00-5240 RETIREES - GROUP HEALTH INSURANCE 27,988 33,255 42,101 27,999 41,367 44,676 48,250 47,793 46,523 01-640-52-00-5241 RETIREES - DENTAL INSURANCE 1,052 260 530 530 449 471 495 261 - 01-640-52-00-5242 RETIREES - VISION INSURANCE 160 74 77 77 80 80 80 44 - 01-640-54-00-5418 PURCHASING SERVICES - 5,187 50,000 51,863 53,419 55,022 56,673 58,373 60,124 01-640-54-00-5421 PPRT TAX REBATE 2,045 - - - - - - - - 01-640-54-00-5423 IDOR ADMINISTRATION FEE - - - 51,934 57,357 58,222 59,100 59,993 60,900 01-640-54-00-5427 GC HOUSING RENTAL ASSISTANCE - - 12,000 3,000 12,000 12,000 12,000 12,000 12,000 01-640-54-00-5428 UTILITY TAX REBATE - - 14,375 14,375 14,375 14,375 14,375 14,375 - 01-640-54-00-5432 FACILITY MANAGEMENT SERVICES - - 35,000 6,000 50,000 51,500 53,045 54,636 56,275 01-640-54-00-5439 AMUSEMENT TAX REBATE 60,628 61,613 64,000 62,000 60,000 43,600 30,000 30,000 30,000 01-640-54-00-5449 KENCOM 72,679 74,842 78,584 119,559 110,958 119,943 132,242 141,867 151,829 01-640-54-00-5450 INFORMATION TECHNOLOGY SERVICES 50,875 117,691 160,280 210,000 136,000 142,800 149,940 157,437 165,309 01-640-54-00-5456 CORPORATE COUNSEL 88,017 102,825 120,000 105,000 110,000 110,000 110,000 110,000 110,000 01-640-54-00-5461 LITIGATION COUNSEL 166,659 211,454 120,000 200,000 120,000 120,000 120,000 120,000 120,000 01-640-54-00-5463 SPECIAL COUNSEL 19,767 4,815 25,000 10,000 20,000 20,000 20,000 20,000 20,000 01-640-54-00-5465 ENGINEERING SERVICES 368,071 350,899 390,000 390,000 390,000 390,000 390,000 390,000 390,000 01-640-54-00-5473 KENDALL AREA TRANSIT 23,550 23,550 25,000 23,550 25,000 25,000 25,000 25,000 25,000 01-640-54-00-5475 CABLE CONSORTIUM FEE 86,054 92,765 85,000 92,000 92,000 92,000 92,000 92,000 92,000 01-640-54-00-5478 SPECIAL CENSUS - 108,093 - 3,349 - - - - - 01-640-54-00-5481 HOTEL TAX REBATE 72,375 65,166 76,500 72,000 72,000 72,000 72,000 72,000 72,000 01-640-54-00-5486 ECONOMIC DEVELOPMENT 47,564 160,359 114,100 145,725 145,000 145,000 145,000 145,000 145,000 01-640-54-00-5491 CITY PROPERTY TAX REBATE 1,286 1,286 1,500 1,233 1,500 1,500 1,500 1,500 1,500 01-640-54-00-5492 SALES TAX REBATE 856,785 879,408 941,367 914,584 928,303 942,228 956,361 970,706 985,267 01-640-54-00-5493 BUSINESS DISTRICT REBATE 368,899 387,157 387,300 387,182 425,320 433,317 441,473 449,794 458,279 01-640-54-00-5494 ADMISSIONS TAX REBATE 121,799 122,007 120,000 130,766 120,000 120,000 120,000 120,000 - 01-640-54-00-5499 BAD DEBT 1,199 1,634 2,000 1,750 2,000 2,000 2,000 2,000 2,000 01-640-56-00-5625 REIMBURSABLE REPAIRS 27,873 11,106 5,000 15,000 15,000 15,000 15,000 15,000 15,000 01-640-99-00-9915 TRANSFER TO MOTOR FUEL TAX 25,407 33,750 - - - - - - - 01-640-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL - - - - 250,000 - - - - 01-640-99-00-9916 TRANSFER TO CW BUILDINGS & GROUNDS 58,060 71,602 160,000 247,415 - - - - - 01-640-99-00-9942 TRANSFER TO DEBT SERVICE 127,243 266,979 315,225 313,725 318,725 318,025 317,225 323,375 324,075 FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription 01-640-99-00-9952 TRANSFER TO SEWER 1,134,654 1,134,052 1,137,166 1,137,166 856,583 609,088 586,749 994,479 1,135,964 01-640-99-00-9979 TRANSFER TO PARKS & RECREATION 1,076,831 1,118,638 1,308,583 1,308,583 1,274,699 1,480,427 1,539,110 1,598,596 1,671,920 01-640-99-00-9982 TRANSFER TO LIBRARY OPERATIONS 25,928 24,044 27,236 23,793 25,179 26,645 28,199 29,846 31,592 5,217,172 5,763,401 6,173,391 6,395,361 6,061,526 5,817,954 5,910,804 6,450,211 6,599,111 Expenditures 13,664,138 14,488,405 15,721,945 15,745,315 15,952,180 16,173,015 16,446,145 17,334,249 17,839,860 Surplus(Deficit)865,648 522,383 (584,324) (436,093) (309,218) (303,948) (315,579) (935,712) (1,289,305) Fund Balance 5,691,706 6,214,089 5,383,778 5,777,996 5,468,778 5,164,830 4,849,251 3,913,539 2,624,234 41.65%42.89%34.24%36.70%34.28%31.93%29.49%22.58%14.71% FY 2018FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023Actual Actual Budget Projected Adopted Projected Projected Projected ProjectedRevenue Taxes 7,072 7,263 9,365 9,366 13,381 13,381 13,381 13,381 13,381 Other Financing Sources - 22,000 - - - - - - - Total Revenue 7,072 29,263 9,365 9,366 13,381 13,381 13,381 13,381 13,381 ExpendituresContractual Services 26,314 10,741 23,000 18,700 8,835 30,977 10,326 10,482 10,646 Total Expenditures 26,314 10,741 23,000 18,700 8,835 30,977 10,326 10,482 10,646 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.Surplus (Deficit) (19,242) 18,522 (13,635) (9,334) 4,546 (17,596) 3,055 2,899 2,735 Ending Fund Balance (3,780) 14,742 (21,485) 5,408 9,954 (7,642) (4,587) (1,688) 1,047 -14.36% 137.25% -93.41% 28.92% 112.67% -24.67% -44.42% -16.10% 9.83%-534.828-2374.704270.222-1131.924-1068.555($3,000)($2,500)($2,000)($1,500)($1,000)($500)$0 $500 ThousandsFund Balance($30)($20)($10)$0 $10 $20 ThousandsFund Balance FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Fox Hill SSA - 11 11-000-40-00-4000 PROPERTY TAXES 7,072 7,263 9,365 9,366 13,381 13,381 13,381 13,381 13,381 11-000-49-00-4910 SALE OF CAPITAL ASSETS - 22,000 - - - - - - - Revenue 7,072 29,263 9,365 9,366 13,381 13,381 13,381 13,381 13,381 11-111-54-00-5417 TRAIL MAINTENANCE 21,141 - - - - - - - - 11-111-54-00-5462 PROFESSIONAL SERVICES - - 7,000 2,700 2,835 2,977 3,126 3,282 3,446 11-111-54-00-5495 OUTSIDE REPAIR & MAINTENANCE 5,173 10,741 16,000 16,000 6,000 28,000 7,200 7,200 7,200 Expenditures 26,314 10,741 23,000 18,700 8,835 30,977 10,326 10,482 10,646 Surplus(Deficit)(19,242) 18,522 (13,635) (9,334) 4,546 (17,596) 3,055 2,899 2,735 Fund Balance (3,780) 14,742 (21,485) 5,408 9,954 (7,642) (4,587) (1,688) 1,047 -14.36%137.25%-93.41%28.92%112.67%-24.67%-44.42%-16.10%9.83% FY 2018FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023Actual Actual Budget Projected Adopted Projected Projected Projected ProjectedRevenue Taxes 18,608 20,456 13,480 13,480 15,637 18,139 21,303 21,303 21,303 Investment Earnings 1 - - - - - - - - Total Revenue 18,609 20,456 13,480 13,480 15,637 18,139 21,303 21,303 21,303 ExpendituresContractual Services 29,676 5,057 29,735 22,744 18,835 15,177 15,326 16,922 17,086 Total Expenditures 29,676 5,057 29,735 22,744 18,835 15,177 15,326 16,922 17,086 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)Surplus (Deficit) (11,067) 15,399 (16,255) (9,264) (3,198) 2,962 5,977 4,381 4,217 Ending Fund Balance (31,175) (15,774) (35,099) (25,038) (28,236) (25,274) (19,297) (14,916) (10,699) -105.05% -311.92% -118.04% -110.09% -149.91% -166.53% -125.91% -88.15% -62.62%($40)($30)($20)($10)$0 ThousandsFund Balance FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Sunflower SSA - 12 12-000-40-00-4000 PROPERTY TAXES 18,608 20,456 13,480 13,480 15,637 18,139 21,303 21,303 21,303 12-000-45-00-4500 INVESTMENT EARNINGS 1 - - - - - - - - Revenue 18,609 20,456 13,480 13,480 15,637 18,139 21,303 21,303 21,303 12-112-54-00-5416 POND MAINTENANCE 26,551 2,512 8,735 8,735 5,000 5,000 5,000 5,000 5,000 12-112-54-00-5462 PROFESSIONAL SERVICES - - 10,000 2,700 2,835 2,977 3,126 3,282 3,446 12-112-54-00-5495 OUTSIDE REPAIR & MAINTENANCE 3,125 2,545 11,000 11,309 11,000 7,200 7,200 8,640 8,640 Expenditures 29,676 5,057 29,735 22,744 18,835 15,177 15,326 16,922 17,086 Surplus(Deficit)(11,067) 15,399 (16,255) (9,264) (3,198) 2,962 5,977 4,381 4,217 Fund Balance (31,175) (15,774) (35,099) (25,038) (28,236) (25,274) (19,297) (14,916) (10,699) -105.05%-311.92%-118.04%-110.09%-149.91%-166.53%-125.91%-88.15%-62.62% FY 2018FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023Actual Actual Budget Projected Adopted Projected Projected Projected ProjectedRevenue Intergovernmental 565,571 470,816 492,616 499,319 530,817 540,613 550,605 560,797 571,193 Investment Earnings 813 3,556 1,500 7,500 5,000 3,000 1,000 - - Reimbursements 3,564 - - - - - - - - Other Financing Sources 30,951 33,750 - - - - - - - Total Revenue 600,899 508,122 494,116 506,819 535,817 543,613 551,605 560,797 571,193 ExpendituresContractual Services 102,418 105,673 124,350 107,750 97,000 - - - - 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.,,,,,Supplies 136,390 119,661 208,000 208,000 90,000 - - - - Capital Outlay 399,147 373,787 423,787 398,787 504,787 773,787 662,287 647,287 572,383 Total Expenditures 637,955 599,121 756,137 714,537 691,787 773,787 662,287 647,287 572,383 Surplus (Deficit) (37,056) (90,999) (262,021) (207,718) (155,970) (230,174) (110,682) (86,490) (1,190) Ending Fund Balance 883,223 792,224 438,871 584,506 428,536 198,362 87,680 1,190 - $0 $200 $400 $600 $800 $1,000 ThousandsFund Balance FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Motor Fuel Tax - 15 15-000-41-00-4112 MOTOR FUEL TAX 432,820 428,888 450,716 458,258 489,817 499,613 509,605 519,797 530,193 15-000-41-00-4113 MFT HIGH GROWTH 41,912 41,928 41,900 41,061 41,000 41,000 41,000 41,000 41,000 15-000-41-00-4184 87,238 - - - - - - - - 15-000-41-00-4187 3,601 - - - - - - - - 15-000-45-00-4500 813 3,556 1,500 7,500 5,000 3,000 1,000 - - 15-000-46-00-4690 REIMB - MISCELLANEOUS 3,564 - - - - - - - - 15-000-49-00-4901 TRANSFER FROM GENERAL 25,407 33,750 - - - - - - - 15-000-49-00-4923 TRANSFER FROM CITY-WIDE CAPITAL 5,544 - - - - - - - - Revenue 600,899 508,122 494,116 506,819 535,817 543,613 551,605 560,797 571,193 15-155-54-00-5438 SALT STORAGE 7,750 7,750 7,750 7,750 - - - - - 15-155-54-00-5482 STREET LIGHTING 94,668 97,923 116,600 100,000 97,000 - - - - 15-155-56-00-5618 SALT 103,119 64,396 140,000 140,000 90,000 - - - - 15-155-56-00-5619 SIGNS 8,797 15,640 15,000 15,000 - - - - - 15-155-56-00-5633 COLD PATCH 11,706 8,892 19,000 19,000 - - - - - 15-155-56-00-5634 HOT PATCH 12,768 15,352 19,000 19,000 - - - - - 15-155-56-00-5642 STREET LIGHTING SUPPLIES - 15,381 15,000 15,000 - - - - - 15-155-60-00-6004 BASELINE ROAD BRIDGE REPAIRS 1,190 - 50,000 25,000 25,000 - - - - 15-155-60-00-6025 ROAD TO BETTER ROADS PROGRAM 300,000 300,000 300,000 300,000 406,000 700,000 588,500 573,500 547,787 15-155-60-00-6072 DOWNTOWN PARKING LOT 8,558 - - - - - - - - 15-155-60-00-6079 ROUTE 47 EXPANSION 73,787 73,787 73,787 73,787 73,787 73,787 73,787 73,787 24,596 15-155-60-00-6089 CANNONBALL LAFO PROJECT 15,612 - - - - - - - - Expenditures 637,955 599,121 756,137 714,537 691,787 773,787 662,287 647,287 572,383 Surplus(Deficit)(37,056) (90,999) (262,021) (207,718) (155,970) (230,174) (110,682) (86,490) (1,190) Fund Balance 883,223 792,224 438,871 584,506 428,536 198,362 87,680 1,190 - STATE GRANTS - DOWNTOWN PARKING LOT INVESTMENT EARNINGS FEDERAL GRANTS - CANNONBALL LAFO FY 2018FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023Actual Actual Budget Projected Adopted Projected Projected Projected ProjectedRevenue Intergovernmental 135,722 534,354 200,224 292,754 - - - - - Licenses & Permits 141,203 196,003 73,000 173,500 91,500 90,000 90,000 90,000 90,000 Charges for Service 700,156 718,872 700,000 730,000 730,000 735,000 735,000 740,000 740,000 Investment Earnings 1,630 3,703 1,000 6,750 1,000 - - - - Reimbursements 399,561 199,851 472,617 367,560 1,109,077 7,549 7,549 - 171,600 Miscellaneous - - - - 2,000 2,000 2,000 2,000 2,000 Other Financing Sources 210,243 73,502 1,258,924 1,263,397 250,000 - - - - Total Revenue 1,588,515 1,726,285 2,705,765 2,833,961 2,183,577 834,549 834,549 832,000 1,003,600 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. City-Wide Capital Fund (23)ExpendituresContractual Services 130,762 107,274 161,675 267,144 216,675 151,675 170,777 177,923 185,498 Supplies 8,913 27,847 35,000 25,000 27,000 27,000 42,000 42,000 77,000 Capital Outlay 2,711,081 2,825,760 2,990,753 2,990,926 1,888,049 256,521 158,108 108,810 310,003 Debt Service 405,937 404,138 403,588 403,588 407,563 322,188 321,338 315,338 319,338 Other Financing Uses 12,621 9,645 78,510 95,074 82,866 121,141 120,132 120,793 120,445 Total Expenditures 3,269,314 3,374,664 3,669,526 3,781,732 2,622,153 878,525 812,355 764,864 1,012,284 Surplus (Deficit) (1,680,799) (1,648,379) (963,761) (947,771) (438,576) (43,976) 22,194 67,136 (8,684) Ending Fund Balance 3,003,908 1,355,530 144,741 407,759 (30,817) (74,793) (52,599) 14,537 5,853 ($500)$0 $500 $1,000 $1,500 $2,000 $2,500 $3,000 $3,500 ThousandsFund Balance($500)$0 $500 $1,000 $1,500 $2,000 $2,500 $3,000 $3,500 ThousandsFund Balance FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription City-Wide Capital - 23 23-000-41-00-4161 FEDERAL GRANTS - ITEP DOWNTOWN 11,244 31,109 1,600 540 - - - - - 23-000-41-00-4169 FEDERAL GRANTS -MILL STREET LAFO 1,075 24,606 - - - - - - - 23-000-41-00-4178 FEDERAL GRANTS - ITEP KENNEDY RD TRAIL 71,327 2,475 133,424 227,014 - - - - - 23-000-41-00-4188 52,076 476,164 65,200 65,200 - - - - - 23-000-42-00-4210 BUILDING PERMITS - 35,365 - 50,000 - - - - - 23-000-42-00-4214 DEVELOPMENT FEES - CW CAPITAL 6,150 1,085 6,000 3,500 3,500 3,500 3,500 3,500 3,500 23-000-42-00-4216 BUILD PROGRAM PERMITS 85,565 61,008 - - - - - - - 23-000-42-00-4218 DEVELOPMENT FEES - MUNICIPAL BLDG 7,077 9,645 7,000 30,000 18,000 16,500 16,500 16,500 16,500 23-000-42-00-4222 ROAD CONTRIBUTION FEE 40,000 88,000 60,000 90,000 70,000 70,000 70,000 70,000 70,000 23-000-42-00-4224 RENEW PROGRAM PERMITS 2,411 900 - - - - - - - 23-000-44-00-4440 ROAD INFRASTRUCTURE FEE 700,156 718,872 700,000 730,000 730,000 735,000 735,000 740,000 740,000 23-000-45-00-4500 1,630 3,703 1,000 6,750 1,000 - - - - 23-000-46-00-4606 REIMB - COM ED 316,905 - - - - - - - - 23-000-46-00-4607 REIMB - BLACKBERRY WOODS 11,999 131,574 - 7,797 7,549 7,549 7,549 - - 23-000-46-00-4608 REIMB - KENNEDY ROAD IMPROVEMENTS - - 160,000 160,000 - - - - - 23-000-46-00-4618 REIMB - BRISTOL BAY ANNEX - - - - - - - - 171,600 23-000-46-00-4620 REIMB - PULTE (AUTUMN CREEK)25,703 - - - - - - - - 23-000-46-00-4621 REIMB - FOUNTAIN VILLAGE - - - 16,820 256,528 - - - - 23-000-46-00-4624 REIMB - WHISPERING MEADOWS - - - - 800,000 - - - - 23-000-46-00-4630 REIMB - STAGECOACH CROSSING - 63,404 - - - - - - - 23-000-46-00-4660 REIMB - PUSH FOR THE PATH 38,618 1,413 312,617 118,943 29,000 - - - - 23-000-46-00-4690 REIMB - MISCELLANEOUS 6,336 3,460 - 64,000 16,000 - - - - 23-000-48-00-4845 DONATIONS - - - - 2,000 2,000 2,000 2,000 2,000 23-000-49-00-4905 LOAN PROCEEDS - RIVER ROAD BRIDGE 152,183 - - - - - - - - 23-000-49-00-4910 SALE OF CAPITAL ASSETS - 1,900 - - - - - - - 23-000-49-00-4916 TRANSFER FROM GENERAL - CW B&G 58,060 71,602 160,000 247,415 - - - - - 23-000-49-00-4923 TRANSFER FROM GENERAL - CW CAPITAL - - - - 250,000 - - - - 23-000-49-00-4951 TRANSFER FROM WATER - - 1,098,924 1,015,982 - - - - - Revenue 1,588,515 1,726,285 2,705,765 2,833,961 2,183,577 834,549 834,549 832,000 1,003,600 STATE GRANTS - EDP WRIGLEY (RTE 47) INVESTMENT EARNINGS FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription City-Wide - Building & Grounds Expenditures 23-216-54-00-5405 BUILD PROGRAM 8,945 4,850 - - - - - - - 23-216-54-00-5446 PROPERTY & BLDG MAINT SERVICES 40,202 43,755 125,000 222,415 150,000 150,000 50,000 50,000 50,000 23-216-54-00-5482 STREET LIGHTING - - - - - - 119,102 126,248 133,823 23-216-56-00-5626 HANGING BASKETS - - - - 2,000 2,000 2,000 2,000 2,000 23-216-56-00-5619 SIGNS - - - - - - 15,000 15,000 15,000 23-216-56-00-5656 PROPERTY & BLDG MAINT SUPPLIES 8,913 27,847 35,000 25,000 25,000 25,000 25,000 25,000 25,000 23-216-60-00-6020 BUILDINGS & STRUCTURES - - - - 40,000 - - - - 23-216-99-00-9901 TRANSFER TO GENERAL 7,077 9,645 7,000 30,000 18,000 16,500 16,500 16,500 16,500 65,137 86,097 167,000 277,415 235,000 193,500 227,602 234,748 242,323 City-Wide Capital Expenditures 23-230-54-00-5405 BUILD PROGRAM 76,620 56,158 - - - - - - 23-230-54-00-5406 RENEW PROGRAM 2,411 900 - - - - - - - 23-230-54-00-5465 ENGINEERING SERVICES 1,370 - 35,000 35,000 65,000 - - - - 23-230-54-00-5497 PROPERTY TAX PAYMENT - - - 8,054 - - - - - 23-230-54-00-5498 PAYING AGENT FEES 475 475 475 475 475 475 475 475 475 23-230-54-00-5499 BAD DEBT 739 1,136 1,200 1,200 1,200 1,200 1,200 1,200 1,200 23-230-56-00-5632 ASPHALT PATCHING - - - - - - - - 35,000 23-230-60-00-6007 KENNEDY RD - AUTUMN CREEK 25,703 - - - - - - - - 23-230-60-00-6008 BEECHER & CORNEILS ROAD 318,507 - - - - - - - - 23-230-60-00-6009 WRIGLEY (RTE 47) EXPANSION 57,430 454,548 65,200 65,200 - - - - - 23-230-60-00-6011 PROPERTY ACQUISITION - 160,877 - - - - - - - 23-230-60-00-6014 BLACKBERRY WOODS 11,999 131,574 - 7,797 7,549 7,549 7,549 - - 23-230-60-00-6017 STAGECOACH CROSSING - 63,304 - - - - - - - 23-230-60-00-6016 US 34 (CENTER / ELDAMAIN RD) PROJECT - - 151,300 19,500 110,226 110,226 110,226 - - 23-230-60-00-6018 GREENBRIAR POND NATURALIZATION 12,632 8,649 4,672 5,109 5,000 5,000 5,000 5,000 5,000 23-230-60-00-6019 BRISTOL BAY ACCESS ROAD - - 50,000 40,699 - - - - - 23-230-60-00-6021 PAVILLION ROAD STREAMBANK STABILIZATION - - - - 110,000 - - - - 23-230-60-00-6023 FOUNTAIN VILLAGE SUBDIVISION - - - 16,820 256,528 - - - - 23-230-60-00-6025 ROAD TO BETTER ROADS PROGRAM 509,430 695,767 400,000 771,007 100,000 - - 98,810 128,403 23-230-60-00-6034 WHISPERING MEADOWS SUBDIVISION - - - - 1,070,000 - - - - 23-230-60-00-6041 SIDEWALK CONSTRUCTION 3,598 806 7,500 3,000 5,000 5,000 5,000 5,000 5,000 23-230-60-00-6048 DOWNTOWN STREETSCAPE IMPROVEMENT 14,055 39,088 2,000 675 - - - - - 23-230-60-00-6058 ROUTE 71 (RTE 47 / ORCHARD RD) PROJECT - - - - 30,333 30,333 30,333 - - 23-230-60-00-6059 US 34 (IL 47 / ORCHARD RD) PROJECT - 16,497 94,600 81,682 98,413 98,413 - - - 23-230-60-00-6073 GAME FARM ROAD PROJECT 1,377,783 13,364 - 328,914 - - - - - 23-230-60-00-6075 RIVER ROAD BRIDGE PROJECT 152,183 - - - - - - - - 23-230-60-00-6082 COUNTRYSIDE PKY IMPROVEMENTS 117,202 1,211,639 645,940 627,417 - - - - - 23-230-60-00-6084 CENTER & COUNTRYSIDE IMPROVEMENTS - - 522,000 228,480 - - - - - FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription 23-230-60-00-6086 KENNEDY ROAD IMPROVEMENTS - 25,753 601,500 384,669 10,000 - - - - 23-230-60-00-6094 KENNEDY RD BIKE TRAIL 109,946 3,894 446,041 409,957 45,000 - - - - 23-230-60-00-6095 613 - - - - - - - - 23-230-60-00-6098 BRISTOL BAY SUBDIVISION - - - - - - - - 171,600 2014A Bond 23-230-78-00-8000 PRINCIPAL PAYMENT 135,000 185,000 190,000 190,000 190,000 195,000 200,000 200,000 210,000 23-230-78-00-8050 INTEREST PAYMENT 195,937 144,138 138,588 138,588 132,888 127,188 121,338 115,338 109,338 Kendall County Loan - River Road Bridge 23-230-97-00-8000 PRINCIPAL PAYMENT 75,000 75,000 75,000 75,000 84,675 - - - - 23-230-99-00-9915 TRANSFER TO MOTOR FUEL TAX 5,544 - - - - - - - - 23-230-99-00-9951 TRANSFER TO WATER - - 71,510 65,074 64,866 104,641 103,632 104,293 103,945 3,204,177 3,288,567 3,502,526 3,504,317 2,387,153 685,025 584,753 530,116 769,961 Expenditures 3,269,314 3,374,664 3,669,526 3,781,732 2,622,153 878,525 812,355 764,864 1,012,284 Surplus(Deficit)(1,680,799) (1,648,379) (963,761) (947,771) (438,576) (43,976) 22,194 67,136 (8,684) Fund Balance 3,003,908 1,355,530 144,741 407,759 (30,817) (74,793) (52,599) 14,537 5,853 SUNFLOWER ESTATES - DRAINAGE IMPROVEMENT FY 2018 FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Licenses & Permits 89,150 134,050 73,500 122,000 120,600 110,550 110,550 110,550 110,550 Fines & Forfeits 11,374 6,608 7,700 6,700 6,700 6,700 6,700 6,700 6,700 Charges for Service 374,386 236,948 246,565 260,116 107,861 47,578 47,146 51,412 71,723 Investment Earnings 43 86 80 150 150 150 150 150 150 Miscellaneous 4,627 5,535 2,000 1,583 2,000 2,000 2,000 2,000 2,000 Other Financing Sources 48,446 254,162 - - - - - - - Total Revenue 528,026 637,389 329,845 390,549 237,311 166,978 166,546 170,812 191,123 Police Capital Expenditures Contractual Services 15,717 3,460 8,000 8,570 8,750 8,750 8,750 8,750 8,750 Capital Outlay 197,119 141,832 192,300 181,786 60,000 60,000 55,000 55,000 55,000 Sub-Total Expenditures 212,836 145,292 200,300 190,356 68,750 68,750 63,750 63,750 63,750 General Government Capital Expenditures Supplies - - - - 34,411 11,578 16,146 20,412 37,897 Capital Outlay - - - - 40,000 - - - - Sub-Total Expenditures - - - - 74,411 11,578 16,146 20,412 37,897 Public Works Capital Expenditures Contractual Services 35,611 26,244 1,750 245 1,750 1,750 1,750 1,750 1,750 Supplies - - 2,000 1,583 2,000 2,000 2,000 2,000 2,000 Capital Outlay 184,891 68,522 52,400 52,400 7,000 7,000 7,000 7,000 14,000 Debt Service 70,815 70,815 70,815 70,815 70,815 70,815 70,815 70,816 70,815 Sub-Total Expenditures 291,317 165,581 126,965 125,043 81,565 81,565 81,565 81,566 88,565 Parks & Rec Capital Expenditures Contractual Services 1,225 1,822 - - - - - - - Capital Outlay 124,165 53,908 270,441 39,903 50,000 - - - - Debt Service 2,219 2,219 2,219 2,219 2,219 2,219 2,219 2,218 2,218 Sub-Total Expenditures 127,609 57,949 272,660 42,122 52,219 2,219 2,219 2,218 2,218 Total Expenditures 631,762 368,822 599,925 357,521 276,945 164,112 163,680 167,946 192,430 Surplus (Deficit)(103,736) 268,567 (270,080) 33,028 (39,634) 2,866 2,866 2,866 (1,307) Police Capital Fund Balance - - - - - - - - - Gen Gov Capital Fund Balance - - - - - - - - - Public Works Capital Fund Balance - - - - 6,435 5,870 5,305 4,739 - Parks & Rec Capital Fund Balance 1,841 270,407 - 303,435 257,366 260,797 264,228 267,660 271,092 Ending Fund Balance 1,841 270,407 - 303,435 263,801 266,667 269,533 272,399 271,092 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 $100 $200 $300 $400 ThousandsFund Balance FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Vehicle & Equipment - 25 25-000-42-00-4215 DEVELOPMENT FEES - POLICE CAPITAL 12,900 32,100 25,000 33,000 30,600 28,050 28,050 28,050 28,050 25-000-42-00-4216 BUILD PROGRAM PERMITS 43,410 28,700 - - - - - - - 25-000-42-00-4218 ENGINEERING CAPITAL FEE 3,250 8,600 6,000 9,000 12,000 11,000 11,000 11,000 11,000 25-000-42-00-4219 DEVELOPMENT FEES - PW CAPITAL 26,240 60,350 40,000 75,000 72,000 66,000 66,000 66,000 66,000 25-000-42-00-4220 DEVELOPMENT FEES - PARK CAPITAL 1,625 4,300 2,500 5,000 6,000 5,500 5,500 5,500 5,500 25-000-42-00-4224 RENEW PROGRAM PERMITS 1,725 - - - - - - - - 25-000-43-00-4315 10,803 5,865 7,000 6,000 6,000 6,000 6,000 6,000 6,000 25-000-43-00-4316 571 743 700 700 700 700 700 700 700 25-000-43-00-4340 - - - - - - - - - 25-000-44-00-4418 MOWING INCOME 5,744 1,955 3,000 629 2,000 2,000 2,000 2,000 2,000 25-000-44-00-4419 COMMUNITY DEVELOPMENT CHARGEBACK - - - - 40,000 - - - - 25-000-44-00-4420 POLICE CHARGEBACK 174,263 97,459 167,600 150,656 31,450 34,000 29,000 29,000 29,000 25-000-44-00-4421 PUBLIC WORKS CHARGEBACK 194,379 63,626 75,965 38,831 - - - - 2,826 25-000-44-00-4427 PARKS & RECREATION CHARGEBACK - 73,908 - 70,000 - - - - - 25-000-44-00-4428 COMPUTER REPLACEMENT CHARGEBACKS - - - - 34,411 11,578 16,146 20,412 37,897 25-000-45-00-4522 43 86 80 150 150 150 150 150 150 25-000-48-00-4852 MISCELLANEOUS INCOME - POLICE CAPITAL 624 435 - - - - - - - 25-000-48-00-4854 MISCELLANEOUS INCOME - PW CAPITAL 3,929 5,100 2,000 1,583 2,000 2,000 2,000 2,000 2,000 25-000-48-00-4855 MISCELLANEOUS INCOME - PARK CAPITAL 74 - - - - - - - - 25-000-49-00-4920 SALE OF CAPITAL ASSETS - POLICE CAPITAL 3,475 5,990 - - - - - - - 25-000-49-00-4921 SALE OF CAPITAL ASSETS - PW CAPITAL 44,171 - - - - - - - - 25-000-49-00-4922 SALE OF CAPITAL ASSETS - PARK CAPITAL 800 248,172 - - - - - - - Revenue 528,026 637,389 329,845 390,549 237,311 166,978 166,546 170,812 191,123 Police Capital 25-205-54-00-5405 BUILD PROGRAM 9,750 2,700 - - - - - - - 25-205-54-00-5406 RENEW PROGRAM 450 - - - - - - - - 25-205-54-00-5495 OUTSIDE REPAIR & MAINTENANCE 5,517 760 8,000 8,570 8,750 8,750 8,750 8,750 8,750 25-205-60-00-6060 EQUIPMENT 2,369 - 27,300 27,300 5,000 5,000 - - - 25-205-60-00-6070 194,750 141,832 165,000 154,486 55,000 55,000 55,000 55,000 55,000 212,836 145,292 200,300 190,356 68,750 68,750 63,750 63,750 63,750 General Government Capital 25-212-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - - - - 34,411 11,578 16,146 20,412 37,897 25-212-60-00-6070 - - - - 40,000 - - - - - - - - 74,411 11,578 16,146 20,412 37,897 INVESTMENT EARNINGS - PARK CAPITAL ELECTRONIC CITATION FEES VEHICLES SEIZED VEHICLE PROCEEDS DUI FINES VEHICLES FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Public Works Capital 25-215-54-00-5405 BUILD PROGRAM 32,510 25,950 - - - - - - - 25-215-54-00-5406 RENEW PROGRAM 1,200 - - - - - - - - 25-215-54-00-5448 FILING FEES 1,901 294 1,750 245 1,750 1,750 1,750 1,750 1,750 25-215-56-00-5620 OPERATING SUPPLIES - - 2,000 1,583 2,000 2,000 2,000 2,000 2,000 25-215-60-00-6060 EQUIPMENT 15,084 24,098 7,400 7,400 7,000 7,000 7,000 7,000 14,000 25-215-60-00-6070 169,807 44,424 45,000 45,000 - - - - - 185 Wolf Street Building 25-215-92-00-8000 PRINCIPAL PAYMENT 39,638 41,430 43,303 43,303 45,261 47,307 49,446 51,682 54,018 25-215-92-00-8050 INTEREST PAYMENT 31,177 29,385 27,512 27,512 25,554 23,508 21,369 19,134 16,797 291,317 165,581 126,965 125,043 81,565 81,565 81,565 81,566 88,565 Parks & Recreation Capital 25-225-54-00-5405 BUILD PROGRAM 1,150 50 - - - - - - - 25-225-54-00-5406 RENEW PROGRAM 75 - - - - - - - - 25-225-54-00-5462 PROFESSIONAL SERVICES - 1,772 - - - - - - - 25-225-60-00-6020 BUILDINGS & STRUCTURES - - 250,441 - - - - - - 25-225-60-00-6060 EQUIPMENT 78,936 53,908 - 20,000 50,000 - - - - 25-225-60-00-6068 TRAIL IMPROVEMENTS 20,347 - - - - - - - - 25-225-60-00-6070 VEHICLES 24,882 - 20,000 19,903 - - - - - 185 Wolf Street Building 25-225-92-00-8000 PRINCIPAL PAYMENT 1,242 1,298 1,357 1,357 1,418 1,482 1,549 1,619 1,692 25-225-92-00-8050 INTEREST PAYMENT 977 921 862 862 801 737 670 599 526 127,609 57,949 272,660 42,122 52,219 2,219 2,219 2,218 2,218 Expenditures 631,762 368,822 599,925 357,521 276,945 164,112 163,680 167,946 192,430 Surplus(Deficit)(103,736) 268,567 (270,080) 33,028 (39,634) 2,866 2,866 2,866 (1,307) - - - - - - - - - - - - - - - - - - - - - - 6,435 5,870 5,305 4,739 - 1,841 270,407 - 303,435 257,366 260,797 264,228 267,660 271,092 Fund Balance 1,841 270,407 - 303,435 263,801 266,667 269,533 272,399 271,092 Fund Balance - Police Capital Fund Balance - Public Works Capital Fund Balance - General Government Fund Balance - Parks & Rec Capital VEHICLES FY 2018FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023Actual Actual Budget Projected Adopted Projected Projected Projected ProjectedRevenue Taxes 164,852 47,070 - - - - - - - Licenses & Permits 14,281 7,015 5,000 6,500 6,000 6,000 6,000 6,000 6,000 Investment Earnings 11 - - - - - - - - Other Financing Sources 127,243 266,979 315,225 313,725 318,725 318,025 317,225 323,375 324,075 Total Revenue 306,387 321,064 320,225 320,225 324,725 324,025 323,225 329,375 330,075 ExpendituresDebt 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. pContractual Services 3,979 914 475 475 475 475 475 475 475 Debt Service 310,250 320,150 319,750 319,750 324,250 323,550 322,750 328,900 329,600 Total Expenditures 314,229 321,064 320,225 320,225 324,725 324,025 323,225 329,375 330,075 Surplus (Deficit) (7,842) - - - - - - - - Ending Fund Balance - - - - - - - - - $0 $0 $0 $0 $0 $0 ThousandsFund Balance FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Debt Service - 42 42-000-40-00-4000 PROPERTY TAXES - 2014B BOND 164,852 47,070 - - - - - - - 42-000-42-00-4208 RECAPTURE FEES - WATER & SEWER 10,777 6,577 5,000 6,500 6,000 6,000 6,000 6,000 6,000 42-000-42-00-4216 BUILD PROGRAM PERMITS 3,466 425 - - - - - - - 42-000-42-00-4224 RENEW PROGRAM 38 13 - - - - - - - 42-000-45-00-4500 INVESTMENT EARNINGS 11 - - - - - - - - 42-000-49-00-4901 TRANSFER FROM GENERAL 127,243 266,979 315,225 313,725 318,725 318,025 317,225 323,375 324,075 Revenue 306,387 321,064 320,225 320,225 324,725 324,025 323,225 329,375 330,075 42-420-54-00-5405 BUILD PROGRAM 3,466 425 - - - - - - - 42-420-54-00-5406 RENEW PROGRAM 38 13 - - - - - - - 42-420-54-00-5498 PAYING AGENT FEES 475 476 475 475 475 475 475 475 475 2014B Refunding Bond 42-420-79-00-8000 PRINCIPAL PAYMENT 255,000 270,000 275,000 275,000 285,000 290,000 295,000 310,000 320,000 42-420-79-00-8050 INTEREST PAYMENT 55,250 50,150 44,750 44,750 39,250 33,550 27,750 18,900 9,600 Expenditures 314,229 321,064 320,225 320,225 324,725 324,025 323,225 329,375 330,075 Surplus(Deficit)(7,842) - - - - - - - - Fund Balance - - - - - - - - - FY 2018FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023Actual Actual Budget Projected Adopted Projected Projected Projected ProjectedRevenue Licenses & Permits 162,468 171,840 - - - - - - - Charges for Service 3,461,906 3,955,944 4,088,800 4,356,416 4,326,486 4,458,446 4,627,759 4,805,536 4,992,202 Investment Earnings 5,492 9,729 5,000 10,500 7,000 3,000 3,000 5,000 10,000 Reimbursements 4,605 27,256 - 200 - - - - - Miscellaneous 57,261 60,865 58,582 61,051 62,491 63,741 65,016 66,316 67,642 Other Financing Sources 4,369,998 6,325,992 145,385 138,949 142,541 178,516 178,757 179,968 177,595 Total Revenue 8,061,730 10,551,626 4,297,767 4,567,116 4,538,518 4,703,703 4,874,532 5,056,820 5,247,439 ExpensesSalaries 376,019 390,595 430,549 421,000 441,121 453,545 466,341 479,521 493,097 Water Fund (51)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. Salaries376,019 390,595 430,549 421,000 441,121 453,545 466,341 479,521 493,097 Benefits 218,947 235,050 266,965 249,501 257,466 274,320 292,441 311,939 332,832 Contractual Services 887,201 827,278 886,366 717,206 734,523 764,700 769,390 786,973 795,191 Supplies 266,102 326,045 323,013 334,570 354,448 364,781 375,630 387,021 398,982 Capital Outlay 1,069,736 3,499,902 807,937 1,020,244 1,555,976 1,156,756 827,544 613,544 420,848 Debt Service 1,147,429 1,449,609 1,344,749 1,344,749 1,532,837 2,361,500 2,305,935 1,815,830 1,654,108 Other Financing Uses - 6,193,291 1,098,924 1,015,982 - - - - - Total Expenses 3,965,434 12,921,770 5,158,503 5,103,252 4,876,371 5,375,602 5,037,281 4,394,828 4,095,058 Surplus (Deficit) 4,096,296 (2,370,144) (860,736) (536,136) (337,853) (671,899) (162,749) 661,992 1,152,381 Ending Fund Balance Equivalent 5,196,289 2,826,144 2,285,570 2,290,008 1,952,155 1,280,256 1,117,507 1,779,499 2,931,880 131.04% 21.87% 44.31% 44.87% 40.03% 23.82% 22.18% 40.49% 71.60%$0 $2,000 $4,000 $6,000 ThousandsFund Balance Equivalent$0 $2,000 $4,000 $6,000 ThousandsFund Balance Equivalent FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Water - 51 51-000-42-00-4216 BUILD PROGRAM PERMITS 162,468 171,840 - - - - - - - 51-000-44-00-4424 WATER SALES 2,463,058 2,952,074 2,956,000 3,105,000 3,105,000 3,260,250 3,423,263 3,594,425 3,774,145 51-000-44-00-4425 BULK WATER SALES (6,660) 5,250 5,000 2,000 5,000 5,000 5,000 5,000 5,000 51-000-44-00-4426 LATE PENALTIES - WATER 101,208 104,425 105,000 120,000 120,000 126,000 132,300 138,915 145,861 51-000-44-00-4430 WATER METER SALES 38,102 66,280 50,000 75,000 58,206 53,356 53,356 53,356 53,356 51-000-44-00-4440 WATER INFRASTRUCTURE FEE 717,028 734,552 725,000 745,000 745,000 745,000 745,000 745,000 745,000 51-000-44-00-4450 WATER CONNECTION FEES 149,170 93,363 247,800 309,416 293,280 268,840 268,840 268,840 268,840 51-000-45-00-4500 5,492 9,729 5,000 10,500 7,000 3,000 3,000 5,000 10,000 51-000-46-00-4690 REIMB - MISCELLANEOUS 4,605 27,256 - 200 - - - - - 51-000-48-00-4820 RENTAL INCOME 56,888 60,495 58,582 61,051 62,491 63,741 65,016 66,316 67,642 51-000-48-00-4850 MISCELLANEOUS INCOME 373 370 - - - - - - - 51-000-49-00-4900 BOND PROCEEDS 4,100,000 - - - - - - - - 51-000-49-00-4902 BOND ISSUANCE - 5,800,000 - - - - - - - 51-000-49-00-4903 PREMIUM ON BOND ISSUANCE 193,723 449,023 - - - - - - - 51-000-49-00-4910 SALE OF CAPITAL ASSETS - 1,894 - - - - - - - 51-000-49-00-4923 TRANSFER FROM CITY-WIDE CAPITAL - - 71,510 65,074 64,866 104,641 103,632 104,293 103,945 51-000-49-00-4952 TRANSFER FROM SEWER 76,275 75,075 73,875 73,875 77,675 73,875 75,125 75,675 73,650 Revenue 8,061,730 10,551,626 4,297,767 4,567,116 4,538,518 4,703,703 4,874,532 5,056,820 5,247,439 Water Operations 51-510-50-00-5010 SALARIES & WAGES 365,077 375,148 388,749 391,000 414,121 426,545 439,341 452,521 466,097 51-510-50-00-5015 PART-TIME SALARIES 3,611 5,530 29,800 18,000 15,000 15,000 15,000 15,000 15,000 51-510-50-00-5020 OVERTIME 7,331 9,917 12,000 12,000 12,000 12,000 12,000 12,000 12,000 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION 40,267 41,132 43,749 43,000 45,526 48,152 51,002 54,070 57,324 51-510-52-00-5214 FICA CONTRIBUTION 27,354 28,326 31,730 31,000 32,370 33,341 34,341 35,371 36,432 51-510-52-00-5216 GROUP HEALTH INSURANCE 113,806 127,757 148,964 136,852 139,233 150,372 162,402 175,394 189,426 51-510-52-00-5222 GROUP LIFE INSURANCE 777 705 705 705 519 524 529 534 539 51-510-52-00-5223 DENTAL INSURANCE 8,712 9,147 9,605 8,808 8,260 8,673 9,107 9,562 10,040 51-510-52-00-5224 VISION INSURANCE 1,131 1,131 1,165 1,218 1,218 1,218 1,218 1,255 1,293 51-510-52-00-5230 UNEMPLOYMENT INSURANCE 1,785 1,148 2,000 1,182 2,000 2,000 2,000 2,000 2,000 51-510-52-00-5231 LIABILITY INSURANCE 25,115 25,704 29,047 26,736 28,340 30,040 31,842 33,753 35,778 51-510-54-00-5401 ADMINISTRATIVE CHARGEBACK - - 108,154 108,154 111,629 111,629 111,629 111,629 111,629 51-510-54-00-5402 BOND ISSUANCE COSTS 40,456 55,732 - - - - - - - 51-510-54-00-5405 BUILD PROGRAM 162,468 171,840 - - - - - - - 51-510-54-00-5412 TRAINING & CONFERENCES 3,072 3,178 6,500 6,500 6,500 6,500 6,500 6,500 6,500 51-510-54-00-5415 TRAVEL & LODGING 1,193 2,123 1,600 1,600 2,000 2,000 2,000 2,000 2,000 51-510-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - - 2,627 827 2,257 486 3,190 51-510-54-00-5426 PUBLISHING & ADVERTISING 211 605 1,000 - 500 500 500 500 500 INVESTMENT EARNINGS FY 2016FY 2017FY 2018FY 2018FY 2019FY 2020FY 2021FY 2022FY 2023Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescription51-510-54-00-5429 WATER SAMPLES6,842 7,607 12,000 10,000 10,000 10,000 10,000 10,000 10,000 51-510-54-00-5430 PRINTING & DUPLICATING2,679 2,405 3,000 3,000 3,250 3,250 3,250 3,250 3,250 51-510-54-00-5440 TELECOMMUNICATIONS24,715 30,807 30,000 30,000 30,000 30,000 30,000 30,000 30,000 51-510-54-00-5445 TREATMENT FACILITY SERVICES113,208 143,204 120,000 120,000 145,000 145,000 145,000 145,000 145,000 51-510-54-00-5448 FILING FEES3,753 2,058 5,000 4,000 4,000 4,000 4,000 4,000 4,000 51-510-54-00-5452 POSTAGE & SHIPPING18,206 16,838 19,000 19,000 19,000 19,000 19,000 19,000 19,000 51-510-54-00-5460 DUES & SUBSCRIPTIONS1,080 1,603 1,600 1,600 1,800 1,800 1,800 1,800 1,800 51-510-54-00-5462 PROFESSIONAL SERVICES47,595 39,025 45,000 45,000 45,000 45,000 45,000 45,000 45,000 51-510-54-00-5465 ENGINEERING SERVICES187,840 46,960 200,000 40,000 15,000 30,000 15,000 15,000 - 51-510-54-00-5466 LEGAL SERVICES- - 2,000 - - - - - - 51-510-54-00-5480 UTILITIES239,114 256,914 270,300 270,300 286,518 303,709 321,932 341,248 361,723 51-510-54-00-5483 JULIE SERVICES 4,300 7,849 6,500 6,500 3,000 3,000 3,000 3,000 3,000 51-510-54-00-5485 RENTAL & LEASE PURCHASE 464 423 750 1,000 1,000 1,000 1,000 1,000 1,000 51-510-54-00-5488 OFFICE CLEANING - - 4,167 1,164 1,199 1,235 1,272 1,310 1,349 51-510-54-00-5490 VEHICLE MAINTENANCE SERVICES 14,551 8,862 15,000 15,000 12,000 12,000 12,000 12,000 12,000 51-510-54-00-5495 OUTSIDE REPAIR & MAINTENCE 6,994 15,096 25,000 25,000 25,000 25,000 25,000 25,000 25,000 51-510-54-00-5498 PAYING AGENT FEES 2,241 1,415 2,295 1,888 2,000 1,750 1,750 1,750 1,750 51-510-54-00-5499 BAD DEBT 6,219 12,734 7,500 7,500 7,500 7,500 7,500 7,500 7,500 51-510-56-00-5600 WEARING APPAREL 5,194 4,264 4,200 4,500 5,100 5,100 5,100 5,100 5,100 51-510-56-00-5620 OPERATING SUPPLIES 5,993 7,744 15,000 7,500 7,500 7,500 7,500 7,500 7,500 51-510-56-00-5628 VEHICLE MAINTENANCE SUPPLIES 1,082 699 5,000 2,500 2,500 2,500 2,500 2,500 2,500 51-510-56-00-5630 SMALL TOOLS & EQUIPMENT 1,144 4,447 2,000 2,000 4,000 4,000 4,000 4,000 4,000 51-510-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE 641 850 2,000 170 - - - - - 51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 151,829 173,204 181,913 175,000 183,750 192,938 202,585 212,714 223,350 51-510-56-00-5640 REPAIR & MAINTENANCE 12,970 19,307 20,000 20,000 27,500 27,500 27,500 27,500 27,500 51-510-56-00-5664 METERS & PARTS 72,039 97,378 70,000 100,000 100,000 100,000 100,000 100,000 100,000 51-510-56-00-5665 JULIE SUPPLIES 1,272 3,669 1,500 1,500 1,200 1,200 1,200 1,200 1,200 51-510-56-00-5695 GASOLINE 13,938 14,483 21,400 21,400 22,898 24,043 25,245 26,507 27,832 51-510-60-00-6011 PROPERTY ACQUISITION - - - - 200,000 200,000 200,000 - - 51-510-60-00-6022 WELL REHABILITATIONS 128,876 174,197 203,000 246,954 257,500 - - - - 51-510-60-00-6025 ROAD TO BETTER ROADS PROGRAM 259,341 316,911 250,000 290,356 250,000 250,000 250,000 250,000 250,000 51-510-60-00-6034 WHISPERING MEADOWS SUBDIVISION- - - - 49,220 - - - - 51-510-60-00-6059 US 34 (IL 47 / ORCHARD RD) PROJECT - - 10,000 26,676 4,212 4,212 - - - 51-510-60-00-6060 EQUIPMENT- 3,248 10,000 10,000 5,000 355,000 5,000 5,000 5,000 51-510-60-00-6066 RTE 71 WATERMAIN REPLACEMENT15,955 24,195 14,580 47,935 533,500 - - - - 51-510-60-00-6070 VEHICLES- 65,710 - - 50,000 - 50,000 - 100,000 51-510-60-00-6079 ROUTE 47 EXPANSION197,544 197,544 197,544 197,544 197,544 197,544 197,544 197,544 65,848 51-510-60-00-6081 CATION EXCHANGE MEDIA REPLACEMENT- - - - 9,000 150,000 125,000 161,000 - 51-510-60-00-6082 COUNTRYSIDE PKY IMPROVEMENTS468,020 2,718,097 122,813 200,779 - - - - - FY 2016FY 2017FY 2018FY 2018FY 2019FY 2020FY 2021FY 2022FY 2023Account NumberActualActualAdoptedProjectedAdoptedProjectedProjectedProjectedProjectedDescription2015A Bond51-510-77-00-8000 PRINCIPAL PAYMENT - 73,543 113,987 113,987 117,664 290,483 297,837 312,545 323,576 51-510-77-00-8050 INTEREST PAYMENT - 228,066 161,053 161,053 156,493 151,787 140,167 128,254 115,752 Debt Service - 2007A Bond51-510-83-00-8000 PRINCIPAL PAYMENT 15,000 15,000 - - - - - - - 51-510-83-00-8050 INTEREST PAYMENT 121,793 121,163 - - - - - - - Debt Service - 2016 Refunding Bond51-510-85-00-8000 PRINCIPAL PAYMENT - - 430,000 430,000 470,000 1,470,000 1,475,000 1,040,000 915,000 51-510-85-00-8050 INTEREST PAYMENT - - 249,629 249,629 195,250 176,450 117,650 58,650 27,450 Debt Service - 2003 Debt Certificates51-510-86-00-8000 PRINCIPAL PAYMENT 100,000 100,000 100,000 100,000 300,000 - - - - 51-510-86-00-8050 INTEREST EXPENSE 25,450 21,450 17,300 17,300 13,050 - - - - Debt Service - 2006A Refunding Debt Certificates51-510-87-00-8000 PRINCIPAL PAYMENT 435,000 460,000 - - - - - - - 51-510-87-00-8050 INTEREST EXPENSE 172,606 155,206 - - - - - - - Debt Service - IEPA Loan L17-15630051-510-89-00-8000 PRINCIPAL PAYMENT94,544 96,923 99,361 99,361 101,860 104,423 107,050 109,743 112,503 51-510-89-00-8050 INTEREST EXPENSE 30,486 28,108 25,669 25,669 23,170 20,607 17,981 15,288 12,527 Debt Service - 2014C Refunding Bond51-510-94-00-8000 PRINCIPAL PAYMENT 120,000 120,000 120,000 120,000 130,000 125,000 130,000 135,000 135,000 51-510-94-00-8050 INTEREST PAYMENT 32,550 30,150 27,750 27,750 25,350 22,750 20,250 16,350 12,300 51-510-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL - - 1,098,924 1,015,982 - - - - - 51-510-99-00-9960 PAYMENT TO ESCROW AGENT- 6,193,291 - - - - - - - Expenses 3,965,434 12,921,770 5,158,503 5,103,252 4,876,371 5,375,602 5,037,281 4,394,828 4,095,058 Surplus(Deficit) 4,096,296 (2,370,144) (860,736) (536,136) (337,853) (671,899) (162,749) 661,992 1,152,381 Fund Balance Equiv 5,196,289 2,826,144 2,285,570 2,290,008 1,952,155 1,280,256 1,117,507 1,779,499 2,931,880 131.04% 21.87% 44.31% 44.87% 40.03% 23.82% 22.18% 40.49% 71.60% FY 2018FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023Actual Actual Budget Projected Adopted Projected Projected Projected ProjectedRevenue Licenses & Permits 77,350 105,392 - - - - - - - Charges for Service 1,312,456 1,286,891 1,266,026 1,546,883 1,558,658 1,565,336 1,594,050 1,623,626 1,654,089 Investment Earnings 1,193 3,899 1,250 14,500 1,250 1,250 1,250 1,250 - Reimbursements 1,264 8,149 - - - - - - - Other Financing Sources 1,134,654 1,134,052 1,137,166 1,137,166 856,583 609,088 586,749 994,479 1,135,964 Total Revenue 2,526,917 2,538,383 2,404,442 2,698,549 2,416,491 2,175,674 2,182,049 2,619,355 2,790,053 ExpensesSalaries 205,371 212,574 223,555 222,305 234,507 241,512 248,727 256,159 263,814 Benefits 104,560 105,974 115,847 115,319 113,682 120,712 127,585 134,936 142,778 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.Contractual Services 177,716 170,831 152,882 153,781 139,140 139,422 143,050 144,190 144,105 Supplies 38,924 38,912 54,908 45,808 51,080 51,650 52,774 53,954 55,193 Capital Outlay 284,509 228,131 272,435 218,765 513,167 326,017 259,015 514,015 219,672 Developer Commitments 32,890 33,872 34,888 34,888 35,938 30,076 - - - Debt Service 1,865,399 1,865,857 1,877,110 1,877,110 1,880,265 1,352,307 1,300,798 1,300,780 1,299,024 Other Financing Uses 76,275 75,075 73,875 73,875 77,675 73,875 75,125 75,675 73,650 Total Expenses 2,785,644 2,731,226 2,805,500 2,741,851 3,045,454 2,335,571 2,207,074 2,479,709 2,198,236 Surplus (Deficit) (258,727) (192,843) (401,058) (43,302) (628,963) (159,897) (25,025) 139,646 591,817 Ending Fund Balance Equivalent 1,570,874 1,378,030 913,772 1,334,728 705,765 545,868 520,843 660,489 1,252,306 56.39% 50.45% 32.57% 48.68% 23.17% 23.37% 23.60% 26.64% 56.97%$0 $500 $1,000 $1,500 $2,000 ThousandsFund Balance Equivalent$0 $500 $1,000 $1,500 $2,000 ThousandsFund Balance Equivalent FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Sewer - 52 52-000-42-00-4216 BUILD PROGRAM PERMITS 76,600 104,700 - - - - - - - 52-000-42-00-4224 RENEW PROGRAM PERMITS 750 692 - - - - - - - 52-000-44-00-4435 SEWER MAINTENANCE FEES 821,802 868,488 882,526 900,000 929,258 957,136 985,850 1,015,426 1,045,889 52-000-44-00-4440 SEWER INFRASTRUCTURE FEE 345,416 354,171 345,000 360,000 360,000 360,000 360,000 360,000 360,000 52-000-44-00-4455 SW CONNECTION FEES - OPERATIONS 15,200 23,100 15,000 98,000 38,400 35,200 35,200 35,200 35,200 52-000-44-00-4456 SW CONNECTION FEES - CAPITAL 114,750 25,909 10,000 172,000 216,000 198,000 198,000 198,000 198,000 52-000-44-00-4462 LATE PENALTIES - SEWER 13,740 13,746 13,500 15,000 15,000 15,000 15,000 15,000 15,000 52-000-44-00-4465 RIVER CROSSING FEES 1,548 1,477 - 1,883 - - - - - 52-000-45-00-4500 1,193 3,899 1,250 14,500 1,250 1,250 1,250 1,250 - 52-000-46-00-4690 1,264 8,149 - - - - - - - 52-000-49-00-4901 TRANSFER FROM GENERAL 1,134,654 1,134,052 1,137,166 1,137,166 856,583 609,088 586,749 994,479 1,135,964 Revenue 2,526,917 2,538,383 2,404,442 2,698,549 2,416,491 2,175,674 2,182,049 2,619,355 2,790,053 Sewer Operations 52-520-50-00-5010 SALARIES & WAGES 205,240 212,553 221,555 221,555 233,507 240,512 247,727 255,159 262,814 52-520-50-00-5020 OVERTIME 131 21 2,000 750 1,000 1,000 1,000 1,000 1,000 52-520-52-00-5212 RETIREMENT PLAN CONTRIBUTION 22,403 22,899 24,405 24,405 25,054 26,408 27,200 28,016 28,857 52-520-52-00-5214 FICA CONTRIBUTION 15,474 15,904 16,613 17,100 17,311 17,830 18,365 18,916 19,483 52-520-52-00-5216 GROUP HEALTH INSURANCE 48,364 48,457 54,530 54,530 51,285 55,388 59,819 64,605 69,773 52-520-52-00-5222 GROUP LIFE INSURANCE 409 371 371 371 273 276 279 282 285 52-520-52-00-5223 DENTAL INSURANCE 4,159 4,367 4,585 4,240 3,901 4,096 4,301 4,516 4,742 52-520-52-00-5224 VISION INSURANCE 552 552 568 594 594 594 594 612 630 52-520-52-00-5230 UNEMPLOYMENT INSURANCE 941 478 1,000 622 1,000 1,000 1,000 1,000 1,000 52-520-52-00-5231 LIABILITY INSURANCE 12,258 12,946 13,775 13,457 14,264 15,120 16,027 16,989 18,008 52-520-54-00-5401 ADMINISTRATIVE CHARGEBACK - - 38,925 38,925 40,176 40,176 40,176 40,176 40,176 52-520-54-00-5405 BUILD PROGRAM 76,600 104,700 - - - - - - - 52-520-54-00-5406 RENEW PROGRAM 750 692 - - - - - - - 52-520-54-00-5412 TRAINING & CONFERENCES 1,515 1,703 3,300 3,300 2,500 2,500 2,500 2,500 2,500 52-520-54-00-5415 TRAVEL & LODGING 1,232 2,681 2,000 2,000 2,000 2,000 2,000 2,000 2,000 52-520-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - - 263 - 2,257 1,944 319 52-520-54-00-5430 PRINTING & DUPLICATING 1,265 1,133 1,500 1,500 1,500 1,500 1,500 1,500 1,500 52-520-54-00-5440 TELECOMMUNICATIONS 2,398 2,411 2,500 8,800 9,000 9,000 9,000 9,000 9,000 52-520-54-00-5444 LIFT STATION SERVICES 5,898 648 30,000 30,000 10,000 10,000 10,000 10,000 10,000 52-520-54-00-5462 PROFESSIONAL SERVICES 8,615 14,772 16,000 18,000 18,000 18,000 18,000 18,000 18,000 52-520-54-00-5480 UTILITIES 19,100 17,660 22,260 20,000 21,200 22,472 23,820 25,249 26,764 52-520-54-00-5483 JULIE SERVICES - - - - 3,000 3,000 3,000 3,000 3,000 52-520-54-00-5485 RENTAL & LEASE PURCHASE 766 423 1,000 1,000 1,000 1,000 1,000 1,000 1,000 52-520-54-00-5488 OFFICE CLEANING - - 4,167 729 751 774 797 821 846 REIMB - MISCELLANEOUS INVESTMENT EARNINGS FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription 52-520-54-00-5490 VEHICLE MAINTENANCE SERVICES 5,437 8,549 10,000 10,000 10,000 10,000 10,000 10,000 10,000 52-520-54-00-5495 OUTSIDE REPAIR & MAINTENCE 51,366 11,924 16,000 16,000 16,000 16,000 16,000 16,000 16,000 52-520-54-00-5498 PAYING AGENT FEES 1,277 1,542 2,980 1,277 1,500 750 750 750 750 52-520-54-00-5499 BAD DEBT 1,497 1,993 2,250 2,250 2,250 2,250 2,250 2,250 2,250 52-520-56-00-5600 WEARING APPAREL 3,441 2,791 3,308 3,308 3,980 3,980 3,980 3,980 3,980 52-520-56-00-5610 OFFICE SUPPLIES 569 465 1,000 1,000 1,000 1,000 1,000 1,000 1,000 52-520-56-00-5613 LIFT STATION MAINTENANCE 5,584 3,604 8,000 8,000 8,000 8,000 8,000 8,000 8,000 52-520-56-00-5620 OPERATING SUPPLIES 6,621 5,868 5,500 5,500 6,500 6,000 6,000 6,000 6,000 52-520-56-00-5628 VEHICLE MAINTENANCE SUPPLIES 2,697 3,590 2,000 2,000 2,000 2,000 2,000 2,000 2,000 52-520-56-00-5630 SMALL TOOLS & EQUIPMENT 1,848 3,658 2,500 1,000 2,000 2,000 2,000 2,000 2,000 52-520-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - 1,270 1,200 - - - - - - 52-520-56-00-5640 REPAIR & MAINTENANCE 4,290 3,708 10,000 5,000 5,000 5,000 5,000 5,000 5,000 52-520-56-00-5665 JULIE SUPPLIES - - - - 1,200 1,200 1,200 1,200 1,200 52-520-56-00-5695 GASOLINE 13,874 13,958 21,400 20,000 21,400 22,470 23,594 24,774 26,013 52-520-60-00-6001 SCADA SYSTEM - - - - - - - 205,000 - 52-520-60-00-6025 ROAD TO BETTER ROADS PROGRAM 225,494 162,427 200,000 154,447 200,000 200,000 200,000 200,000 200,000 52-520-60-00-6034 WHISPERING MEADOWS SUBDIVISION - - - - 48,150 - - - - 52-520-60-00-6059 US 34 (IL 47 / ORCHARD RD) PROJECT - - 10,000 1,096 17,002 17,002 - - - 52-520-60-00-6060 EQUIPMENT - 1,014 - - - - - - - 52-520-60-00-6066 RTE 71 SANITARY SEWER REPLACEMENT - 5,675 3,420 4,207 189,000 - - - - 52-520-60-00-6070 VEHICLES - - - - - 50,000 - 50,000 - 52-520-60-00-6079 ROUTE 47 EXPANSION 59,015 59,015 59,015 59,015 59,015 59,015 59,015 59,015 19,672 52-520-75-00-7500 LENNAR - RAINTREE SEWER RECPATURE 32,890 33,872 34,888 34,888 35,938 30,076 - - - Debt Service - 2004B Bond 52-520-84-00-8000 PRINCIPAL PAYMENT 395,000 410,000 435,000 435,000 455,000 - - - - 52-520-84-00-8050 INTEREST EXPENSE 65,825 52,000 35,600 35,600 18,200 - - - - Debt Service - 2003A IRBB Debt Certificates 52-520-90-00-8000 PRINCIPAL PAYMENT 110,000 115,000 120,000 120,000 130,000 135,000 140,000 150,000 155,000 52-520-90-00-8050 INTEREST EXPENSE 52,870 47,755 42,293 42,293 36,233 29,668 22,850 15,710 8,060 Debt Service - 2011 Refunding Bond 52-520-92-00-8000 PRINCIPAL PAYMENT 715,000 745,000 780,000 780,000 810,000 845,000 885,000 920,000 960,000 52-520-92-00-8050 INTEREST EXPENSE 419,654 389,052 357,166 357,166 323,782 289,114 252,948 215,070 175,964 FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Debt Service - IEPA Loan L17-115300 52-520-96-00-8000 PRINCIPAL PAYMENT 95,821 98,353 100,952 100,952 103,619 52,832 - - - 52-520-96-00-8050 INTEREST EXPENSE 11,229 8,697 6,099 6,099 3,431 693 - - - 52-520-99-00-9951 TRANSFER TO WATER 76,275 75,075 73,875 73,875 77,675 73,875 75,125 75,675 73,650 Expenses 2,785,644 2,731,226 2,805,500 2,741,851 3,045,454 2,335,571 2,207,074 2,479,709 2,198,236 Surplus(Deficit)(258,727) (192,843) (401,058) (43,302) (628,963) (159,897) (25,025) 139,646 591,817 Fund Balance Equiv 1,570,874 1,378,030 913,772 1,334,728 705,765 545,868 520,843 660,489 1,252,306 56.39%50.45%32.57%48.68%23.17%23.37%23.60%26.64%56.97% FY 2018FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023Actual Actual Budget Projected Adopted Projected Projected Projected ProjectedRevenue Intergovernmental - 15,711 - - 702,474 - - - - Licenses & Permits 3,570 1,103 - - - - - - - Land Cash Contributions 121,962 47,753 88,000 205,796 11,639 11,638 - - - Reimbursements - 63,796 - 5,466 - - - - - Other Financing Sources - 2,500 2,500 2,500 - - - - - Total Revenue 125,532 130,863 90,500 213,762 714,113 11,638 - - - 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. ExpendituresContractual Services 3,570 1,103 - - - - - - - Capital Outlay 27,074 91,762 362,355 650,831 465,000 50,000 - - 24,000 Total Expenditures 30,644 92,865 362,355 650,831 465,000 50,000 - - 24,000 Surplus (Deficit) 94,888 37,998 (271,855) (437,069) 249,113 (38,362) - - (24,000) Ending Fund Balance 212,318 250,318 56,726 (186,751) 62,362 24,000 24,000 24,000 - ($300)($200)($100)$0 $100 $200 $300 ThousandsFund Balance($300)($200)($100)$0 $100 $200 $300 ThousandsFund Balance FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Land Cash - 72 72-000-41-00-4175 OSLAD GRANT - RIVERFRONT PARK - 5,514 - - 312,671 - - - - 72-000-41-00-4186 OSLAD GRANT - BRISTOL BAY - 10,197 - - 389,803 - - - - 72-000-42-00-4216 BUILD PROGRAM PERMITS 3,570 - - - - - - - - 72-000-42-00-4244 RENEW PROGRAM PERMITS - 1,103 - - - - - - - 72-000-46-00-4655 REIMB - GRANDE RESERVE PARK - 63,796 - 5,466 - - - - - 72-000-47-00-4703 AUTUMN CREEK 34,125 27,690 30,000 - - - - - - 72-000-47-00-4704 BLACKBERRY WOODS 9,659 7,955 6,000 16,000 - - - - - 72-000-47-00-4706 CALEDONIA - 2,013 - 32,000 11,639 11,638 - - - 72-000-47-00-4707 RIVER'S EDGE - - - 671 - - - - - 72-000-47-00-4708 COUNTRY HILLS 5,383 4,614 - 3,845 - - - - - 72-000-47-00-4709 SALEK - - - 3,213 - - - - - 72-000-47-00-4711 FOX HIGHLANDS DETENTION 1,406 - - - - - - - - 72-000-47-00-4713 PRESTWICK 67,600 - - - - - - - - 72-000-47-00-4720 WOODWORTH - 1,071 - - - - - - - 72-000-47-00-4722 GC HOUSING (ANTHONY'S PLACE)- - - 97,162 - - - - - 72-000-47-00-4723 WINDETT RIDGE - - 50,000 50,000 - - - - - 72-000-47-00-4736 BRIARWOOD 3,789 4,410 2,000 2,905 - - - - - 72-000-49-00-4910 SALE OF CAPITAL ASSETS - 2,500 2,500 2,500 - - - - - Revenue 125,532 130,863 90,500 213,762 714,113 11,638 - - - 72-720-54-00-5405 BUILD PROGRAM 3,570 1,103 - - - - - - - 72-720-60-00-6010 PARK IMPROVEMENTS - - - - 300,000 - - - - 72-720-60-00-6013 BEECHER PARK - - - - - - - - 24,000 72-720-60-00-6029 CALEDONIA PARK - - - - - 50,000 - - - 72-720-60-00-6032 MOSER HOLDING COSTS 12,000 8,612 - - - - - - - 72-720-60-00-6043 BRISTOL BAY REGIONAL PARK - 10,197 183,783 360,000 50,000 - - - - 72-720-60-00-6045 RIVERFRONT PARK 5,362 9,864 178,572 285,000 40,000 - - - - 72-720-60-00-6046 GRANDE RESERVE PARK A 9,562 63,089 - 5,831 - - - - - 72-720-60-00-6047 GRANDE RESERVE PARK B 150 - - - - - - - - 72-720-60-00-6067 BLACKBERRY CREEK NATURE PRESERVE - - - - 25,000 - - - - 72-720-60-00-6069 WINDETT RIDGE PARK - - - - 50,000 - - - - Expenditures 30,644 92,865 362,355 650,831 465,000 50,000 - - 24,000 Surplus(Deficit)94,888 37,998 (271,855) (437,069) 249,113 (38,362) - - (24,000) Fund Balance 212,318 250,318 56,726 (186,751) 62,362 24,000 24,000 24,000 - FY 2018FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023Actual Actual Budget Projected Adopted Projected Projected Projected ProjectedRevenue Intergovernmental - - - - 81,815 - - - - Charges for Service 408,469 455,676 395,000 446,186 430,000 430,000 430,000 430,000 430,000 Investment Earnings 369 328 350 500 500 500 500 500 500 Reimbursements 12,890 3,002 - 174 - - - - - Miscellaneous 219,704 209,970 196,000 232,319 201,000 201,000 201,000 201,000 201,000 Other Financing Sources 1,076,831 1,118,638 1,308,583 1,308,583 1,274,699 1,480,427 1,539,110 1,598,596 1,671,920 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.Parks and Recreation Fund (79)Total Revenue 1,718,263 1,787,614 1,899,933 1,987,762 1,988,014 2,111,927 2,170,610 2,230,096 2,303,420 ExpendituresSalaries 723,194 805,190 903,518 883,460 972,772 997,066 1,022,088 1,047,861 1,074,407 Benefits 325,538 365,079 453,922 401,188 432,587 452,909 481,147 511,487 543,978 Contractual Services 252,132 311,346 274,720 330,131 294,214 289,099 288,960 290,754 302,243 Supplies 474,172 360,884 345,151 407,618 386,735 369,511 370,325 371,180 372,078 Total Expenditures 1,775,036 1,842,499 1,977,311 2,022,397 2,086,308 2,108,585 2,162,520 2,221,282 2,292,706 Surplus (Deficit) (56,773) (54,885) (77,378) (34,635) (98,294) 3,342 8,090 8,814 10,714 Ending Fund Balance 500,762 445,875 296,597 411,240 312,946 316,288 324,378 333,192 343,906 28.21% 24.20% 15.00% 20.33% 15.00% 15.00% 15.00% 15.00% 15.00%$0 $200 $400 $600 ThousandsFund Balance$0 $200 $400 $600 ThousandsFund Balance FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Parks and Recreation - 79 79-000-41-00-4175 OSLAD GRANT - RIVERFRONT PARK - - - - 81,815 - - - - 79-000-44-00-4402 SPECIAL EVENTS 100,756 109,109 85,000 90,000 90,000 90,000 90,000 90,000 90,000 79-000-44-00-4403 CHILD DEVELOPMENT 110,861 135,445 120,000 140,000 130,000 130,000 130,000 130,000 130,000 79-000-44-00-4404 ATHLETICS & FITNESS 163,420 178,613 160,000 185,000 180,000 180,000 180,000 180,000 180,000 79-000-44-00-4441 CONCESSION REVENUE 33,432 32,509 30,000 31,186 30,000 30,000 30,000 30,000 30,000 79-000-45-00-4500 369 328 350 500 500 500 500 500 500 79-000-46-00-4690 REIMB - MISCELLANEOUS 12,890 3,002 - 174 - - - - - 79-000-48-00-4820 RENTAL INCOME 50,921 53,345 50,000 55,000 55,000 55,000 55,000 55,000 55,000 79-000-48-00-4825 PARK RENTALS 19,602 13,221 15,000 20,163 15,000 15,000 15,000 15,000 15,000 79-000-48-00-4843 HOMETOWN DAYS 106,579 117,354 108,000 128,156 108,000 108,000 108,000 108,000 108,000 79-000-48-00-4846 SPONSORSHIPS & DONATIONS 18,917 20,547 20,000 20,000 20,000 20,000 20,000 20,000 20,000 79-000-48-00-4850 MISCELLANEOUS INCOME 23,685 5,503 3,000 9,000 3,000 3,000 3,000 3,000 3,000 79-000-49-00-4901 TRANSFER FROM GENERAL 1,076,831 1,118,638 1,308,583 1,308,583 1,274,699 1,480,427 1,539,110 1,598,596 1,671,920 Revenue 1,718,263 1,787,614 1,899,933 1,987,762 1,988,014 2,111,927 2,170,610 2,230,096 2,303,420 Parks Department 79-790-50-00-5010 SALARIES & WAGES 387,634 425,198 459,839 457,000 485,686 500,257 515,265 530,723 546,645 79-790-50-00-5015 PART-TIME SALARIES 24,382 35,251 45,000 45,000 50,000 50,000 50,000 50,000 50,000 79-790-50-00-5020 OVERTIME 1,884 2,091 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-790-52-00-5212 RETIREMENT PLAN CONTRIBUTION 41,923 46,256 52,224 51,800 54,010 54,928 56,576 58,273 60,022 79-790-52-00-5214 FICA CONTRIBUTION 30,890 34,143 37,601 37,000 39,814 41,008 42,238 43,505 44,810 79-790-52-00-5216 GROUP HEALTH INSURANCE 102,203 119,781 163,947 137,906 155,114 167,523 180,925 195,399 211,031 79-790-52-00-5222 GROUP LIFE INSURANCE 790 884 808 900 580 586 592 598 604 79-790-52-00-5223 DENTAL INSURANCE 7,978 8,353 10,883 9,700 10,417 10,938 11,485 12,059 12,662 79-790-52-00-5224 VISION INSURANCE 947 1,002 1,250 1,325 1,457 1,457 1,457 1,501 1,546 79-790-54-00-5412 TRAINING & CONFERENCES 2,136 4,410 7,000 4,500 7,000 7,000 7,000 7,000 7,000 79-790-54-00-5415 TRAVEL & LODGING 85 807 3,000 500 3,000 3,000 3,000 3,000 3,000 79-790-54-00-5422 VEHICLE & EQUIPMENT CHARGEBACK - 53,908 - 70,000 - - - - - 79-790-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - - 5,200 662 - 1,458 7,082 79-790-54-00-5440 TELECOMMUNICATIONS 5,312 6,278 6,000 6,000 6,500 6,500 6,500 6,500 6,500 79-790-54-00-5462 PROFESSIONAL SERVICES 7,206 2,461 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-790-54-00-5466 LEGAL SERVICES 5,415 663 6,000 6,000 6,000 6,000 6,000 6,000 6,000 79-790-54-00-5485 RENTAL & LEASE PURCHASE 2,461 2,334 2,500 5,000 2,500 2,500 2,500 2,500 2,500 79-790-54-00-5488 OFFICE CLEANING - - 6,250 2,718 2,800 2,884 2,971 3,060 3,152 79-790-54-00-5495 OUTSIDE REPAIR & MAINTENANCE 36,800 22,411 50,000 25,000 50,000 50,000 50,000 50,000 50,000 79-790-56-00-5600 WEARING APPAREL 5,759 5,344 5,441 5,441 6,220 6,220 6,220 6,220 6,220 79-790-56-00-5620 OPERATING SUPPLIES 147,028 23,577 25,300 28,000 25,000 25,000 25,000 25,000 25,000 INVESTMENT EARNINGS FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription 79-790-56-00-5630 SMALL TOOLS & EQUIPMENT 5,518 1,576 4,500 4,500 6,000 6,000 6,000 6,000 6,000 79-790-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE 2,000 2,000 2,000 2,000 20,000 2,000 2,000 2,000 2,000 79-790-56-00-5640 REPAIR & MAINTENANCE 64,517 69,160 56,000 62,000 66,000 66,000 66,000 66,000 66,000 79-790-56-00-5695 GASOLINE 11,694 12,439 12,840 13,500 14,445 15,167 15,925 16,721 17,557 894,562 880,327 964,383 981,790 1,023,743 1,031,630 1,063,654 1,099,517 1,141,331 Recreation Department 79-795-50-00-5010 SALARIES & WAGES 261,071 283,924 303,179 293,460 324,086 333,809 343,823 354,138 364,762 79-795-50-00-5015 PART-TIME SALARIES 6,537 9,989 25,000 18,000 30,000 30,000 30,000 30,000 30,000 79-795-50-00-5045 CONCESSION WAGES 7,549 7,891 15,000 11,000 15,000 15,000 15,000 15,000 15,000 79-795-50-00-5046 PRE-SCHOOL WAGES 23,902 30,091 37,500 36,000 40,000 40,000 40,000 40,000 40,000 79-795-50-00-5052 INSTRUCTORS WAGES 10,235 10,755 15,000 20,000 25,000 25,000 25,000 25,000 25,000 79-795-52-00-5212 RETIREMENT PLAN CONTRIBUTION 28,362 30,328 38,272 32,210 39,956 36,652 38,852 41,222 43,735 79-795-52-00-5214 FICA CONTRIBUTION 23,119 25,585 29,305 28,150 32,367 33,338 34,338 35,368 36,429 79-795-52-00-5216 GROUP HEALTH INSURANCE 83,005 91,187 111,170 94,513 90,945 98,221 106,079 114,565 123,730 79-795-52-00-5222 GROUP LIFE INSURANCE 618 396 529 447 440 444 448 452 457 79-795-52-00-5223 DENTAL INSURANCE 4,987 6,362 7,070 6,369 6,539 6,866 7,209 7,569 7,947 79-795-52-00-5224 VISION INSURANCE 716 802 863 868 948 948 948 976 1,005 79-795-54-00-5412 TRAINING & CONFERENCES 3,481 2,951 5,000 3,500 5,000 5,000 5,000 5,000 5,000 79-795-54-00-5415 TRAVEL & LODGING 354 1,028 3,000 500 3,000 3,000 3,000 3,000 3,000 79-795-54-00-5422 VEHICLE & EQUIPMENT CHARGEBACK - 20,000 - - - - - - - 79-795-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - - 4,412 2,812 2,257 1,458 6,125 79-795-54-00-5426 PUBLISHING & ADVERTISING 49,207 52,018 50,000 51,000 55,000 55,000 55,000 55,000 55,000 79-795-54-00-5440 TELECOMMUNICATIONS 7,231 7,064 8,000 7,250 8,000 8,000 8,000 8,000 8,000 79-795-54-00-5447 SCHOLARSHIPS 121 - 2,500 1,250 2,500 2,500 2,500 2,500 2,500 79-795-54-00-5452 POSTAGE & SHIPPING 1,008 2,609 3,500 3,500 3,500 3,500 3,500 3,500 3,500 79-795-54-00-5460 DUES & SUBSCRIPTIONS 1,231 1,155 2,500 4,000 3,000 3,000 3,000 3,000 3,000 79-795-54-00-5462 PROFESSIONAL SERVICES 94,757 101,289 90,500 115,000 100,000 100,000 100,000 100,000 100,000 79-795-54-00-5480 UTILITIES 10,596 11,976 12,720 12,720 13,483 14,292 15,150 16,059 17,023 79-795-54-00-5485 RENTAL & LEASE PURCHASE 3,019 1,808 4,000 2,500 3,000 3,000 3,000 3,000 3,000 79-795-54-00-5488 OFFICE CLEANING - - 6,250 4,193 4,319 4,449 4,582 4,719 4,861 79-795-54-00-5495 OUTSIDE REPAIR & MAINTENANCE 6,770 6,061 3,000 2,000 3,000 3,000 3,000 3,000 3,000 79-795-54-00-5496 PROGRAM REFUNDS 14,942 10,115 - - - - - - - 79-795-56-00-5602 HOMETOWN DAYS SUPPLIES 94,845 96,287 100,000 108,177 100,000 100,000 100,000 100,000 100,000 79-795-56-00-5606 PROGRAM SUPPLIES 108,100 121,860 100,000 131,000 110,000 110,000 110,000 110,000 110,000 79-795-56-00-5607 CONCESSION SUPPLIES 19,299 14,926 18,000 17,000 18,000 18,000 18,000 18,000 18,000 79-795-56-00-5610 OFFICE SUPPLIES 2,212 2,325 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-795-56-00-5620 OPERATING SUPPLIES 11,373 9,240 15,000 30,000 15,000 15,000 15,000 15,000 15,000 FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription 79-795-56-00-5640 REPAIR & MAINTENANCE 1,009 1,230 2,000 2,000 2,000 2,000 2,000 2,000 2,000 79-795-56-00-5695 GASOLINE 818 920 1,070 1,000 1,070 1,124 1,180 1,239 1,301 880,474 962,172 1,012,928 1,040,607 1,062,565 1,076,955 1,098,866 1,121,765 1,151,375 Expenditures 1,775,036 1,842,499 1,977,311 2,022,397 2,086,308 2,108,585 2,162,520 2,221,282 2,292,706 Surplus(Deficit)(56,773) (54,885) (77,378) (34,635) (98,294) 3,342 8,090 8,814 10,714 Fund Balance 500,762 445,875 296,597 411,240 312,946 316,288 324,378 333,192 343,906 28.21%24.20%15.00%20.33%15.00%15.00%15.00%15.00%15.00% FY 2018FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023Actual Actual Budget Projected Adopted Projected Projected Projected ProjectedRevenue Taxes 1,369,150 1,372,091 1,403,263 1,402,659 1,464,606 1,482,968 1,526,762 1,553,892 1,575,253 Intergovernmental 26,475 18,958 22,450 18,388 18,350 18,350 18,350 18,350 18,350 Fines & Forfeits 8,081 7,355 8,000 9,000 8,500 8,500 8,500 8,500 8,500 Charges for Service 9,191 10,208 10,000 13,300 11,500 11,500 11,500 11,500 11,500 Investment Earnings 559 1,594 800 2,000 1,750 1,550 1,400 1,300 1,200 Reimbursements - 2,141 - 691 - - - - - Miscellaneous 5,240 7,099 5,500 6,750 6,750 6,750 6,750 6,750 6,750 Other Financing Sources 25,928 24,044 26,440 23,793 25,179 26,645 28,199 29,846 31,592 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.Total Revenue 1,444,624 1,443,490 1,476,453 1,476,581 1,536,635 1,556,263 1,601,461 1,630,138 1,653,145 ExpendituresSalaries 391,904 411,502 456,517 405,000 422,698 435,379 448,440 461,894 475,750 Benefits 151,698 158,182 180,757 151,460 166,150 176,569 187,744 199,742 212,575 Contractual Services 94,596 104,409 141,880 142,389 145,840 144,412 145,019 145,662 146,344 Supplies 23,907 26,927 21,000 21,000 21,200 21,200 21,200 21,200 21,200 Debt Service 749,846 752,771 760,396 760,396 792,101 797,013 827,088 840,225 847,313 Total Expenditures 1,411,951 1,453,791 1,560,550 1,480,245 1,547,989 1,574,573 1,629,491 1,668,723 1,703,182 Surplus (Deficit) 32,673 (10,301) (84,097) (3,664) (11,354) (18,310) (28,030) (38,585) (50,037) Ending Fund Balance 499,355 489,057 396,472 485,393 474,039 455,729 427,699 389,114 339,077 35.37% 33.64% 25.41% 32.79% 30.62% 28.94% 26.25% 23.32% 19.91%Operational Fund Balance %75.42% 69.76% 49.55% 67.43% 62.71% 58.61% 53.30% 46.97% 39.62%$0$200 $400 $600 ThousandsFund Balance$0 $200 $400 $600 ThousandsFund Balance FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Library Operations 82-000-40-00-4000 PROPERTY TAXES - LIBRARY OPS 622,529 626,183 645,867 644,025 672,505 685,955 699,674 713,667 727,940 82-000-40-00-4083 PROPERTY TAXES - DEBT SERVICE 746,621 745,908 757,396 758,634 792,101 797,013 827,088 840,225 847,313 82-000-41-00-4120 PERSONAL PROPERTY TAX 5,324 5,914 5,250 5,250 5,250 5,250 5,250 5,250 5,250 82-000-41-00-4170 STATE GRANTS 21,151 13,044 17,200 13,138 13,100 13,100 13,100 13,100 13,100 82-000-43-00-4330 LIBRARY FINES 8,081 7,355 8,000 9,000 8,500 8,500 8,500 8,500 8,500 82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 6,038 6,576 6,500 8,800 7,500 7,500 7,500 7,500 7,500 82-000-44-00-4422 COPY FEES 2,283 2,717 2,500 3,500 3,000 3,000 3,000 3,000 3,000 82-000-44-00-4439 PROGRAM FEES 870 915 1,000 1,000 1,000 1,000 1,000 1,000 1,000 82-000-45-00-4500 559 1,594 800 2,000 1,750 1,550 1,400 1,300 1,200 82-000-46-00-4690 REIMB - MISCELLANEOUS - 2,141 - 691 - - - - - 82-000-48-00-4820 RENTAL INCOME 1,942 2,200 2,000 1,800 2,000 2,000 2,000 2,000 2,000 82-000-48-00-4824 DVD RENTAL INCOME 2,454 2,444 2,500 2,800 2,750 2,750 2,750 2,750 2,750 82-000-48-00-4850 MISCELLANEOUS INCOME 844 2,455 1,000 2,150 2,000 2,000 2,000 2,000 2,000 82-000-49-00-4901 TRANSFER FROM GENERAL 25,928 24,044 26,440 23,793 25,179 26,645 28,199 29,846 31,592 Revenue 1,444,624 1,443,490 1,476,453 1,476,581 1,536,635 1,556,263 1,601,461 1,630,138 1,653,145 82-820-50-00-5010 SALARIES & WAGES 201,312 211,185 223,828 215,000 226,998 233,808 240,822 248,047 255,488 82-820-50-00-5015 PART-TIME SALARIES 190,592 200,317 232,689 190,000 195,700 201,571 207,618 213,847 220,262 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 21,767 22,558 24,435 23,500 24,252 25,672 27,213 28,873 30,633 82-820-52-00-5214 FICA CONTRIBUTION 29,361 30,778 34,263 31,000 31,720 32,672 33,652 34,662 35,702 82-820-52-00-5216 GROUP HEALTH INSURANCE 68,514 74,462 88,996 67,475 79,318 85,663 92,516 99,917 107,910 82-820-52-00-5222 GROUP LIFE INSURANCE 443 403 403 381 328 331 334 337 340 82-820-52-00-5223 DENTAL INSURANCE 5,034 5,286 5,550 4,673 4,652 4,885 5,129 5,385 5,654 82-820-52-00-5224 VISION INSURANCE 651 651 670 638 701 701 701 722 744 82-820-52-00-5230 UNEMPLOYMENT INSURANCE 420 474 1,000 747 750 750 750 750 750 82-820-52-00-5231 LIABILITY INSURANCE 25,508 23,570 25,440 23,046 24,429 25,895 27,449 29,096 30,842 82-820-54-00-5412 TRAINING & CONFERENCES 249 330 500 500 2,500 500 500 500 500 82-820-54-00-5415 TRAVEL & LODGING 262 365 600 600 600 600 600 600 600 82-820-54-00-5421 PPRT TAX REBATE 678 - - - - - - - - 82-820-54-00-5426 PUBLISHING & ADVERTISING 23 277 100 100 2,000 2,000 2,000 2,000 2,000 82-820-54-00-5440 TELECOMMUNICATIONS 6,007 3,524 6,000 5,000 5,000 5,000 5,000 5,000 5,000 82-820-54-00-5452 POSTAGE & SHIPPING 494 398 500 500 500 500 500 500 500 82-820-54-00-5460 DUES & SUBSCRIPTIONS 9,560 9,005 12,000 10,000 11,000 11,000 11,000 11,000 11,000 82-820-54-00-5462 PROFESSIONAL SERVICES 31,278 38,037 40,000 35,000 40,000 40,000 40,000 40,000 40,000 82-820-54-00-5466 LEGAL SERVICES - - 2,000 - 3,000 3,000 3,000 3,000 3,000 82-820-54-00-5468 AUTOMATION 17,890 12,633 20,000 15,000 20,000 20,000 20,000 20,000 20,000 82-820-54-00-5480 UTILITIES 6,504 10,961 8,480 9,000 9,540 10,112 10,719 11,362 12,044 82-820-54-00-5495 OUTSIDE REPAIR & MAINTENANCE 19,962 27,190 50,000 65,000 50,000 50,000 50,000 50,000 50,000 INVESTMENT EARNINGS FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription 82-820-54-00-5498 PAYING AGENT FEES 1,689 1,689 1,700 1,689 1,700 1,700 1,700 1,700 1,700 82-820-56-00-5610 OFFICE SUPPLIES 9,240 8,906 8,000 8,000 8,000 8,000 8,000 8,000 8,000 82-820-56-00-5620 LIBRARY OPERATING SUPPLIES 11,210 9,654 10,000 10,000 2,000 2,000 2,000 2,000 2,000 82-820-56-00-5621 CUSTODIAL SUPPLIES - - - - 8,000 8,000 8,000 8,000 8,000 82-820-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE - - - - - - - - - 82-820-56-00-5671 LIBRARY PROGRAMMING 1,030 1,243 1,000 1,000 1,000 1,000 1,000 1,000 1,000 82-820-56-00-5676 EMPLOYEE RECOGNITION - - - - 200 200 200 200 200 82-820-56-00-5684 COMPACT DISCS & OTHER MUSIC - - - - - - - - - 82-820-56-00-5685 DVD'S 2,427 1,141 500 500 500 500 500 500 500 82-820-56-00-5686 BOOKS - 5,983 1,500 1,500 1,500 1,500 1,500 1,500 1,500 Debt Service - 2006 Bond 82-820-84-00-8000 PRINCIPAL PAYMENT 50,000 50,000 50,000 50,000 50,000 50,000 75,000 75,000 75,000 82-820-84-00-8050 INTEREST PAYMENT 32,113 29,738 27,363 27,363 24,988 22,613 20,238 16,675 13,113 Debt Service - 2013 Refunding Bond 82-820-99-00-8000 PRINCIPAL PAYMENT 485,000 500,000 520,000 520,000 565,000 585,000 610,000 645,000 675,000 82-820-99-00-8050 INTEREST PAYMENT 182,733 173,033 163,033 163,033 152,113 139,400 121,850 103,550 84,200 Expenditures 1,411,951 1,453,791 1,560,550 1,480,245 1,547,989 1,574,573 1,629,491 1,668,723 1,703,182 Surplus(Deficit)32,673 (10,301) (84,097) (3,664) (11,354) (18,310) (28,030) (38,585) (50,037) Fund Balance 499,355 489,057 396,472 485,393 474,039 455,729 427,699 389,114 339,077 35.37%33.64%25.41%32.79%30.62%28.94%26.25%23.32%19.91% Operational Fund Balance %75.42%69.76%49.55%67.43%62.71%58.61%53.30%46.97%39.62% .FY 2018FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023Actual Actual Budget Projected Adopted Projected Projected Projected ProjectedRevenue Licenses & Permits 36,100 53,650 35,000 70,000 43,200 39,600 39,600 39,600 39,600 Investment Earnings 8 12 10 10 10 10 10 10 10 Miscellaneous 10 130 - - - - - - - Total Revenue 36,118 53,792 35,010 70,010 43,210 39,610 39,610 39,610 39,610 ExpendituresContractual Services 4,258 3,844 3,500 3,500 3,500 3,500 3,500 3,500 3,500 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.Supplies 29,768 44,851 31,500 46,250 48,600 48,600 48,600 48,600 48,600 Total Expenditures 34,026 48,695 35,000 49,750 52,100 52,100 52,100 52,100 52,100 Surplus (Deficit) 2,092 5,097 10 20,260 (8,890) (12,490) (12,490) (12,490) (12,490) Ending Fund Balance 14,807 19,904 23,999 40,164 31,274 18,784 6,294 (6,196) (18,686) ($40)($20)$0 $20 $40 $60 ThousandsFund Balance  FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Library Capital 84-000-42-00-4214 DEVELOPMENT FEES 35,350 53,450 35,000 70,000 43,200 39,600 39,600 39,600 39,600 84-000-42-00-4224 RENEW PROGRAM PERMITS 750 200 - - - - - - - 84-000-45-00-4500 8 12 10 10 10 10 10 10 10 84-000-48-00-4850 MISCELLANEOUS INCOME 10 130 - - - - - - - Revenue 36,118 53,792 35,010 70,010 43,210 39,610 39,610 39,610 39,610 84-840-54-00-5406 RENEW PROGRAM 750 200 - - - - - - - 84-840-54-00-5460 E-BOOKS SUBSCRIPTION 3,508 3,644 3,500 3,500 3,500 3,500 3,500 3,500 3,500 84-840-56-00-5635 COMPUTER EQUIPMENT & SOFTWARE 1,311 15,444 15,000 15,000 15,000 15,000 15,000 15,000 15,000 84-840-56-00-5683 AUDIO BOOKS 1,237 2,758 - 1,600 1,600 1,600 1,600 1,600 1,600 84-840-56-00-5684 COMPACT DISCS & OTHER MUSIC - - - 150 500 500 500 500 500 84-840-56-00-5685 DVD'S 394 1,843 - 1,500 1,500 1,500 1,500 1,500 1,500 84-840-56-00-5686 BOOKS 26,826 24,806 16,500 28,000 30,000 30,000 30,000 30,000 30,000 Expenditures 34,026 48,695 35,000 49,750 52,100 52,100 52,100 52,100 52,100 Surplus(Deficit)2,092 5,097 10 20,260 (8,890) (12,490) (12,490) (12,490) (12,490) Fund Balance 14,807 19,904 23,999 40,164 31,274 18,784 6,294 (6,196) (18,686) INVESTMENT EARNINGS FY 2018FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023Actual Actual Budget Projected Adopted Projected Projected Projected ProjectedRevenue Taxes 143,784 215,360 225,000 198,294 246,261 268,732 442,258 455,526 469,192 Investment Earnings 5 - - - - - - - - Other Financing Sources 1,597,288 - - - - - - - - Total Revenue 1,741,077 215,360 225,000 198,294 246,261 268,732 442,258 455,526 469,192 ExpendituresContractual Services 16,477 1,940 13,841 13,362 713,749 13,749 13,749 13,749 13,749 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.Debt Service 87,743 159,227 149,675 149,675 149,358 209,845 208,311 209,316 208,787 Other Financing Uses 1,581,984 - - - - - - - - Total Expenditures 1,686,204 161,167 163,516 163,037 863,107 223,594 222,060 223,065 222,536 Surplus (Deficit) 54,873 54,193 61,484 35,257 (616,846) 45,138 220,198 232,461 246,656 Ending Fund Balance (549,946) (495,754) (434,861) (460,497) (1,077,343) (1,032,205) (812,007) (579,546) (332,890) ($1,500)($1,000)($500)$0 ThousandsFund Balance($1,500)($1,000)($500)$0 ThousandsFund Balance FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Countryside TIF 87-000-40-00-4000 PROPERTY TAXES 143,784 215,360 225,000 198,294 246,261 268,732 442,258 455,526 469,192 87-000-45-00-4500 5 - - - - - - - - 87-000-49-00-4902 1,475,000 - - - - - - - - 87-000-49-00-4903 PREMIUM ON BOND ISSUANCE 122,288 - - - - - - - - Revenue 1,741,077 215,360 225,000 198,294 246,261 268,732 442,258 455,526 469,192 87-870-54-00-5401 ADMINISTRATIVE CHARGEBACK - - 10,701 10,701 11,049 11,049 11,049 11,049 11,049 87-870-54-00-5402 BOND ISSUANCE COSTS 15,304 - - - - - - - - 87-870-54-00-5425 TIF INCENTIVE PAYOUT - - - - 700,000 - - - - 87-870-54-00-5462 PROFESSIONAL SERVICES 638 1,281 2,000 2,000 2,000 2,000 2,000 2,000 2,000 87-870-54-00-5498 PAYING AGENT FEES 535 659 1,140 661 700 700 700 700 700 2015A Bond 87-870-77-00-8000 PRINCIPAL PAYMENT - 26,457 41,013 41,013 42,336 104,517 107,163 112,455 116,424 87-870-77-00-8050 INTEREST PAYMENT - 82,055 57,947 57,947 56,307 54,613 50,433 46,146 41,648 Debt Service - 2005 Bond 87-870-80-00-8050 INTEREST PAYMENT 68,073 - - - - - - - - Debt Service - 2014 Refunding Bond 87-870-93-00-8000 PRINCIPAL PAYMENT - - - - - - - - - 87-870-93-00-8050 INTEREST PAYMENT 19,670 50,715 50,715 50,715 50,715 50,715 50,715 50,715 50,715 87-870-99-00-9960 PAYMENT TO ESCROW AGENT 1,581,984 - - - - - - - - Expenditures 1,686,204 161,167 163,516 163,037 863,107 223,594 222,060 223,065 222,536 Surplus(Deficit)54,873 54,193 61,484 35,257 (616,846) 45,138 220,198 232,461 246,656 Fund Balance (549,946) (495,754) (434,861) (460,497) (1,077,343) (1,032,205) (812,007) (579,546) (332,890) INVESTMENT EARNINGS BOND ISSUANCE FY 2018FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023Actual Actual Budget Projected Adopted Projected Projected Projected ProjectedRevenue Taxes 68,868 67,307 70,000 76,186 80,000 85,000 85,000 90,000 90,000 Intergovernmental - - - - 50,536 40,432 - - - Investment Earnings 3 - - - - - - - - Miscellaneous 236 1,456 - - - - - - - Total Revenue 69,107 68,763 70,000 76,186 130,536 125,432 85,000 90,000 90,000 ExpendituresContractual Services 17,830 32,016 65,659 71,288 72,533 67,533 67,533 67,533 67,533 Capital Outlay 36,668 192,894 1,067,083 1,008,027 120,910 244,744 17,420 17,420 12,473 The Downtown TIF was created in 2006, in order to finance a mixed use development in the downtown area.Downtown TIF Fund (88)Debt Service - - - - 225,800 218,250 212,200 206,084 - Total Expenditures 54,498 224,910 1,132,742 1,079,315 419,243 530,527 297,153 291,037 80,006 Surplus (Deficit) 14,609 (156,147) (1,062,742) (1,003,129) (288,707) (405,095) (212,153) (201,037) 9,994 Ending Fund Balance 253,703 97,556 (681,353) (905,573) (1,194,280) (1,599,375) (1,811,528) (2,012,565) (2,002,571) ($3,000)($2,000)($1,000)$0 $1,000 ThousandsFund Balance FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Downtown TIF 88-000-40-00-4000 PROPERTY TAXES 68,868 67,307 70,000 76,186 80,000 85,000 85,000 90,000 90,000 88-000-41-00-4163 FEDERAL GRANTS - ITEP DOWNTOWN HILL - - - - 50,536 40,432 - - - 88-000-45-00-4500 INVESTMENT EARNINGS 3 - - - - - - - - 88-000-48-00-4850 MISCELLANEOUS INCOME 236 1,456 - - - - - - - Revenue 69,107 68,763 70,000 76,186 130,536 125,432 85,000 90,000 90,000 88-880-54-00-5401 ADMINISTRATIVE CHARGEBACK - - 30,284 30,284 31,533 31,533 31,533 31,533 31,533 88-880-54-00-5425 TIF INCENTIVE PAYOUT 15,223 20,558 20,000 20,000 20,000 20,000 20,000 20,000 20,000 88-880-54-00-5462 PROFESSIONAL SERVICES 2,051 304 375 1,004 6,000 1,000 1,000 1,000 1,000 88-880-54-00-5466 LEGAL SERVICES 556 11,154 15,000 20,000 15,000 15,000 15,000 15,000 15,000 88-880-60-00-6000 PROJECT COSTS 29,248 71,970 306,663 306,663 20,320 25,000 10,000 10,000 10,000 88-880-60-00-6011 PROPERTY ACQUISITION - 10,000 363,000 364,449 - - - - - 88-880-60-00-6015 DOWNTOWN HILL - - - - 63,170 212,324 - - - 88-880-60-00-6045 RIVERFRONT PARK - - 360,000 329,495 - - - - - 88-880-60-00-6048 DOWNTOWN STREETSCAPE IMPROVEMENT - 103,504 30,000 - 30,000 - - - - 88-880-60-00-6079 ROUTE 47 EXPANSION 7,420 7,420 7,420 7,420 7,420 7,420 7,420 7,420 2,473 FNBO Loan - 102 E Van Emmon Building 88-880-81-00-8000 PRINCIPAL PAYMENT - - - - 200,000 200,000 200,000 200,000 - 88-880-81-00-8050 INTEREST PAYMENT - - - - 25,800 18,250 12,200 6,084 - Expenditures 54,498 224,910 1,132,742 1,079,315 419,243 530,527 297,153 291,037 80,006 Surplus(Deficit)14,609 (156,147) (1,062,742) (1,003,129) (288,707) (405,095) (212,153) (201,037) 9,994 Fund Balance 253,703 97,556 (681,353) (905,573) (1,194,280) (1,599,375) (1,811,528) (2,012,565) (2,002,571) FY 2018FY 2016 FY 2017 Adopted FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023Actual Actual Budget Projected Adopted Projected Projected Projected ProjectedRevenue Taxes - - - - - - - - - Investment Earnings - - - - - - - - - Total Revenue - - - - - - - - - ExpendituresContractual Services - - - - 10,000 - - - - Capital Outlay - - - - - - - - - Total Expenditures - - - - 10,000 - - - - Surplus (Deficit) - - - - (10,000) - - - - Downtown TIF Fund II (89)Proposed TIF in the downtown area, pending the decision of City Council.Ending Fund Balance - - - - (10,000) (10,000) (10,000) (10,000) (10,000) ($15)($10)($5)$0 ThousandsFund Balance FY 2016 FY 2017 FY 2018 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Account Number Actual Actual Adopted Projected Adopted Projected Projected Projected ProjectedDescription Downtown TIF II 89-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,000 - - - - 89-890-60-00-6000 PROJECT COSTS - - - - - - - - - Expenditures - - - - 10,000 - - - - Surplus(Deficit)- - - - (10,000) - - - - Fund Balance - - - - (10,000) (10,000) (10,000) (10,000) (10,000)