Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Ordinance 2017-16
STATE OF IUINOIS COUNTY OF IUWL - FILED - APR 2 7 2017 am, COW EWQ arc �oau couNnr_ UNITED CITY OF YOI KVILLE KENDALL COUNTY, ILLINOIS ORDINANCE NO. 2017-16 ORDINANCE APPROVING THE 2017-2018 FISCAL BUDGET FOR THE UNITED CITY OF YORKVILLE Passed by the City Council of the United City of Yorkville,Kendall County,Illinois This 11 Phday of April,2017 Published in pamphlet form by the authority of the Mayor and City Council of the United City of Yorkville,Kendall County,Illinois on April 26,2017. ORDINANCE NO.2017-_& ORDINANCE APPROVING THE 2017-2018 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 2017-2018 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 2017-2018 Fiscal Year Budget being submitted on April 11, 2017 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 2017-2018 Budget totaling $33,720,458 including the amounts of$15,645,665 General Fund, $756,137 Motor Fuel Tax Fund, $599,925 Vehicle& Equipment Fund, $3,005,500 Sewer Fund, $5,158,503 Water Fund, $3,619,526 City-Wide Capital Fund, $320,225 Debt Service Fund, $362,355 Land Cash Fund, $1,977,311 Parks &Recreation Fund, $832,585 Library Operations Fund, $760,396 Library Debt Service Fund, $35,000 Library Capital Fund, $163,516 Countryside TIF Fund, $431,079 Downtown TIF Fund, $29,735 Sunflower SSA Fund, and $23,000 Fox Hill SSA Fund is hereby adopted for the 2017-2018 Fiscal Year, as presented. Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this 11ffi day of April, A.D. 2017. CITY CLERK- Ordinance No.2017- 1( Page 2 CARLO COLOSIMO y _ KEN KOCH y JACKIE MILSCHEWSKI Y ARDEN JOE PLOCHER _y CHRIS FUNKHOUSER JOEL FRIEDERS y SEAVER TARULIS DIANE TEELING y Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this 110'day of April, A.D. 2017. MAYOR Ordinance No.2017- Page 3 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. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Revenue Taxes 10,052,792 10,330,920 10,384,836 10,716,006 10,899,060 11,159,364 11,425,477 11,697,564 11,975,793 Intergovernmental 2,295,134 2,311,978 2,313,586 2,267,237 2,379,022 2,543,764 2,592,361 2,636,830 2,682,189 Licenses&Permits 173,126 213,451 178,000 308,000 253,000 253,000 253,000 253,000 253,000 Fines&Forfeits 137,252 123,639 130,225 140,260 140,225 140,225 140,225 140,225 140,225 Charges for Service 1,290,493 1,401,384 1,423,175 1,453,453 1,365,564 1,399,977 1,435,422 1,471,930 1,509,533 Investment Earnings 8,909 6,394 5,000 20,000 15,000 11,000 7,750 5,000 5,000 Reimbursements 168,182 113,024 55,000 54,817 55,000 55,000 55,000 55,000 55,000 Miscellaneous 22,813 21,919 24,000 23,750 23,750 23,750 23,750 23,750 23,750 Other Financing Sources 2,209 7,077 3,000 10,000 7,000 7,000 7,000 7,000 7,000 Total Revenue 14,150,910 14,529,786 149516,822 14,993,523 15,137,621 15,593,080 15,939,985 16,290,299 16,6519490 Expenditures Salaries 3,721,840 3,958,489 4,362,017 4,305,338 4,618,075 4,708,781 4,839,765 4,974,681 5,113,643 Benefits 2,334,546 2,447,779 2,798,284 2,700,543 3,086,500 3,273,590 3,473,378 3,684,000 3,906,072 Contractual Services 4,387,516 4,593,459 4,904,133 4,815,355 4,718,527 4,615,244 4,681,864 4,749,859 4,817,400 Supplies 254,650 216,288 299,161 232,201 274,353 267,193 274,628 282,566 291,041 Other Financing Uses 2,486,885 2,448,123 2,631,459 2,739,970 2,948,210 3,287,272 3,235,672 3,117,524 3,185,554 Total Expenditures 13,185,437 13,664,138 14,995,054 14,793,407 15,645,665 16,152,080 16,505,307 16,808,630 17,313,710 Surplus(Deficit) 965,473 865,648 (478,232) 200,116 (508,044) (559,000) (565,322) (518,331) (662,220) Ending Fund Balance 4,826,059 5,691,706 5,360,499 5,891,822 5,383,778 4,824,778 4,2599456 3,741,125 3,078,905 36.60% 41.65% 35.75% 39.83% 34.41% 29.87% 25.81% 22.26% 17.78% Fund Balance $8,000 $6,000 0 $4,000 $2,000 $0 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected GENERAL FUND-01 O1-000-40-00-4000 PROPERTY TAXES-CORPORATE LEVY 2,277,087 2,278,321 2,219,203 2,206,925 2,124,299 2,166,785 2,210,121 2,254,323 2,299,409 O1-000-40-00-4010 PROPERTY TAXES-POLICE PENSION 624,168 703,105 825,413 817,490 966,211 1,016,211 1,066,211 1,116,211 1,166,211 O1-000-40-00-4030 MUNICIPAL SALES TAX 2,704,651 2,778,116 - 2,800,920 2,925,000 3,012,750 3,103,133 3,196,227 3,292,114 3,390,877 O1-000-40-00-4035 NON-HOME RULE SALES TAX 2,078,061 2,126,851 2,157,300 2,265,000 2,332,950 2,402,939 2,475,027 2,549,278 2,625,756 O1-000-40-00-4040 ELECTRIC UTILITY TAX 635,478 689,084 625,000 700,000 675,000 675,000 675,000 675,000 675,000 O1-000-40-00-4041 NATURAL GAS UTILITY TAX 277,969 207,551 265,000 260,000 240,000 240,000 240,000 240,000 240,000 O1-000-40-00-4043 EXCISE TAX 418,509 393,680 390,000 360,000 361,000 361,000 361,000 361,000 361,000 O1-000-40-00-4044 TELEPHONE UTILITY TAX 10,222 8,499 8,000 8,334 8,300 8,300 8,300 8,300 8,300 O1-000-40-00-4045 CABLE FRANCHISE FEES 258,118 286,944 270,000 285,000 285,000 285,000 285,000 285,000 285,000 01-000-40-00-4050 HOTELTAX 72,708 80,422 76,000 85,000 85,000 85,000 85,000 85,000 85,000 O1-000-40-00-4055 VIDEO GAMING TAX 50,855 74,734 65,000 90,000 90,000 90,000 90,000 90,000 90,000 O1-000-40-00-4060 AMUSEMENT TAX 172,461 201,216 180,000 200,000 200,000 200,000 200,000 200,000 200,000 01-000-40-00-4065 ADMISSIONS TAX 104,066 121,799 120,000 122,007 120,000 120,000 120,000 120,000 120,000 O1-000-40-00-4070 BUSINESS DISTRICT TAX-KENDALL MRKT 336,830 350,589 357,000 365,000 372,300 379,746 387,341 395,088 402,990 O1-000-40-00-4071 BUSINESS DISTRICT TAX-DOWNTOWN 11,192 6,879 4,000 4,000 4,000 4,000 4,000 4,000 4,000 O1-000-40-00-4072 BUSINESS DISTRICT TAX-COUNTRYSIDE 9,054 11,431 11,000 11,000 11,000 11,000 11,000 11,000 11,000 01-000-40-00-4075 AUTO RENTAL TAX 11,363 11,699 11,000 11,250 11,250 11,250 11,250 11,250 11,250 01-000-41-00-4100 STATE INCOME TAX 1,735,422 1,715,155 1,725,942 1,644,721 1,739,021 1,873,201 1,908,065 1,943,626 1,979,899 O1-000-41-00-4105 LOCAL USE TAX 341,880 390,605 397,644 409,488 436,101 466,663 475,396 484,304 493,390 O1-000-41-00-4110 ROAD&BRIDGE TAX 171,756 148,223 150,000 145,522 150,000 150,000 155,000 155,000 155,000 O1-000-41-00-4120 PERSONAL PROPERTY TAX 17,450 16,065 17,000 17,000 17,000 17,000 17,000 17,000 17,000 O1-000-41-00-4160 FEDERAL GRANTS 10,341 17,726 10,000 15,000 15,000 15,000 15,000 15,000 15,000 O1-000-41-00-4168 STATE GRANTS-TRAFFIC SIGNAL MAINTENANCE 17,290 21,342 12,000 31,606 21,000 21,000 21,000 21,000 21,000 O1-000-41-00-4170 STATE GRANTS - 2,000 - 3,000 - - - - - O1-000-41-00-4182 MISC INTERGOVERNMENTAL 995 862 1,000 900 900 900 900 900 900 01-00042-004200 LIQUOR LICENSES 46,887 46,442 45,000 45,000 50,000 50,000 50,000 50,000 50,000 01-000-42-00-4205 OTHER LICENSES&PERMITS 2,537 3,902 3,000 3,000 3,000 3,000 3,000 3,000 3,000 O1-000-42-00-4210 BUILDING PERMITS 123,702 163,107 130,000 260,000 200,000 200,000 200,000 200,000 200,000 O1-00043-004310 CIRCUIT COURT FINES 49,859 43,063 45,000 45,000 45,000 45,000 45,000 45,000 45,000 O1-00043-00-4320 ADMINISTRATIVE ADJUDICATION 31,507 24,406 30,000 30,000 30,000 30,000 30,000 30,000 30,000 O1-00043-00-4323 OFFENDER REGISTRATION FEES 230 220 225 260 225 225 225 225 225 O1-000-43-00-4325 POLICE TOWS 55,656 55,950 55,000 65,000 65,000 65,000 65,000 65,000 65,000 O1-000-44-00-4400 GARBAGESURCHARGE 1,117,947 1,218,991 1,251,675 1,276,653 1,000,000 1,030,000 1,060,900 1,092,727 1,125,509 01-000-44-00-4405 COLLECTION FEES-YBSD 151,241 153,292 150,000 153,000 154,000 154,000 154,000 154,000 154,000 01-000-44-00-4407 LATE PENALTIES-GARBAGE 21,305 22,972 21,000 23,000 23,000 23,000 23,000 23,000 23,000 O1-000-44-004415 ADMINISTRATIVE CHARGEBACK - - - - 188,064 192,477 197,022 201,703 206,524 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected 01-000-44-00-4474 POLICE SPECIAL DETAIL - 6,129 500 800 500 500 500 500 500 01-000-45-00-4500 INVESTMENT EARNINGS 5,458 6,394 5,000 20,000 15,000 11,000 7,750 5,000 5,000 O1-000-45-00-4550 GAIN ON INVESTMENT 3,451 - - - - - - - - O1-000-46-00-4601 REIMB-LEGAL EXPENSES 6,099 1,521 - - - - - - - O1-000-46-00-4604 REIMB-ENGINEERING EXPENSES 81,686 15,196 25,000 10,000 25,000 25,000 25,000 25,000 25,000 01-000-46-00-4680 REIMB-LIABILITY INSURANCE 4,280 32,294 5,000 7,820 5,000 5,000 5,000 5,000 5,000 O1-000-46-00-4681 REIMB-WORKERS COMP (224) - - - - - - - - O1-000-46-00-4685 REIMB-CABLE CONSORTIUM 69,693 21,030 20,000 21,997 20,000 20,000 20,000 20,000 20,000 O1-000-46-00-4690 REIMB-MISCELLANEOUS 6,648 42,983 5,000 15,000 5,000 5,000 5,000 5,000 5,000 01-000-48-00-4820 RENTAL INCOME 6,715 6,905 7,000 6,750 6,750 6,750 6,750 6,750 6,750 O1-00048-004845 DONATIONS 900 - 2,000 2,000 2,000 2,000 2,000 2,000 2,000 O1-00048-004850 MISCELLANEOUS INCOME 15,198 15,014 15,000 15,000 15,000 15,000 15,000 15,000 15,000 01-00049-004916 TRANSFER FROM CW MUNICIPAL BUILDING 2,209 7,077 3,000 10,000 7,000 7,000 7,000 7,000 7,000 Revenue 14,150,910 14,529,786 14,516,822 14,993,523 15,137,621 1.5,593,080 15,939,985 16,290,299 16,651,490 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 it the daily administration of City services. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Expenditures Salaries 364,718 388,629 455,839 475,250 525,478 529,007 542,942 557,295 572,079 Benefits 242,710 150,348 165,333 168,619 206,137 219,132 234,034 250,037 267,171 Contractual Services 103,295 115,668 158,921 139,679 135,660 125,878 116,957 118,100 119,312 Supplies 7,198 10,624 10,850 10,000 10,000 10,000 10,000 10,000 10,000 Total Administration 717,921 665,269 790,943 793,548 877,275 884,017 903,933 935,432 968,562 $1,200 -o C $1,000 s $800 $600 $400 $200 $0 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Administration 01-110-50-00-5001 SALARIES-MAYOR 9,570 9,735 11,000 10,250 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,905 6,935 11,000 9,000 9,000 - - - - 01-110-50-00-5004 SALARIES-CITY TREASURER 968 1,000 6,500 1,000 1,000 - - - - 01-110-50-00-5005 SALARIES-ALDERMAN 47,960 48,690 52,000 52,000 52,000 52,000 52,000 52,000 52,000 01-110-50-00-5010 SALARIES-ADMINISTRATION 294,157 317,586 366,039 396,000 450,978 464,507 478,442 492,795 507,579 01-110-50-00-5015 PART-TIME SALARIES 4,158 3,683 7,800 5,750 - - - - - 01-110-50-00-5020 OVERTIME - - 500 250 500 500 500 500 500 01-110-52-00-5212 RETIREMENT PLAN CONTRIBUTION 37,723 36,387 37,405 - 43,200 49,506 52,081 55,797 59,787 64,018 01-110-52-00-5214 FICA CONTRIBUTION 24,296 25,422 28,931 32,000 36,665 37,765 38,898 40,065 41,267 01-110-52-00-5216 GROUP HEALTH INSURANCE 85,215 81,297 91,653 86;000 111,978 120,936 130,611 141,060 152,345 01-110-52-00-5222 GROUP LIFE INSURANCE 443 491 445 547 557 563 569 575 581 01-110-52-00-5223 DENTAL INSURANCE 5,387 5,516 6,178 6,091 6,612 6,943 7,290 7,655 8,038 01-110-52-00-5224 VISION INSURANCE 576 721 721 771 819 844 869 895 922 01-110-52-00-5235 ELECTED OFFICIAL-GROUP HEALTH INSURANCE 82,691 489 - - - - - - - 01-110-52-00-5236 ELECTED OFFICIAL-GROUP LIFE INSURANCE 633 4 - 10 - - - - - 01-110-52-00-5237 ELECTED OFFICIAL-DENTAL INSURANCE 5,205 (40) - - - - - - - 01-110-52-00-5238 ELECTED OFFICIAL-VISION INSURANCE 541 61 - - - - - - 01-110-54-00-5410 TUITION REIMBURSEMENT - 3,216 - 15,000 8,040 12,000 10,000 - - - 01-110-54-00-5412 TRAINING&CONFERENCES 10,636 5,440 12,000 12,000 20,800 12,000 12,000 12,000 12,000 01-110-54-00-5415 TRAVEL&LODGING 3,356 8,241 9,000 9,000 9,000 9,000 9,000 9,000 9,000 01-110-54-00-5426 PUBLISHING&ADVERTISING 740 1,262 1,000 5,400 5,000 5,000 5,000 5,000 5,000 01-110-54-00-5430 PRINTING&DUPLICATING 4,094 2,890 5,500 2,750 4,000 4,000 4,000 4,000 4,000 01-110-54-00-5440 TELECOMMUNICATIONS 13,097 13,620 16,000 16,000 16,000 16,000 16,000 16,000 16,000 01-110-54-00-5448 FILING FEES 70 49 500 250 500 500 500 500 500 01-110-54-00-5451 CODIFICATION 3,003 12,002 5,000 5,000 5,000 5,000 5,000 5,000 5,000 01-110-54-00-5452 POSTAGE&SHIPPING 2,932 2,418 4,000 2,500 3,500 3,500 3,500 3,500 3,500 01-110-54-00-5460 DUES&SUBSCRIPTIONS 15,981 15,869 17,000 16,000 17,000 17,000 17,000 17,000 17,000 01-110-54-00-5462 PROFESSIONAL SERVICES 9,112 18,739 29,600 29,600 11,000 11,000 11,000 11,000 11,000 01-110-54-00-5480 UTILITIES 23,131 14,862 24,421 16,000 16,960 17,978 19,057 20,200 21,412 01-110-54-00-5485 RENTAL&LEASE PURCHASE 2,347 2,224 2,400 2,103 2,400 2,400 2,400 2,400 2,400 01-110-54-00-5488 OFFICE CLEANING 14,796 14,836 17,500 15,036 12,500 12,500 12,500 12,500 12,500 01-110-56-00-5610 OFFICE SUPPLIES 7,120 10,574 10,000 10,000 10,000 10,000 10,000 10,000 10,000 01-110-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 78 50 850 - - 717,921 665,269 790,943 793,548 877,275 884,017 903,933 935,432 968,562 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. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Expenditures Salaries 206,925 218,467 233,718 236,000 252,079 259,641 267,430 275,453 283,717 Benefits 72,251 75,570 83,961 79,941 115,958 123,414 131,817 140,839 150,497 Contractual Services 73,736 79,872 92,700 87,825 95,420 96,380 97,340 98,300 99,260 Supplies 2,691 2,650 3,450 3,050 2,700 2,700 2,700 2,700 2,700 Total Finance 355,603 376,559 413,829 406,816 466,157 482,135 499,287 517,292 536,174 $600 $500 v C $400 3 O $300 $200 $100 $0 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Finance 01-120-50-00-5010 SALARIES&WAGES 206,925 218,467 233,718 236,000 252,079 259,641 267,430 275,453 283,717 O1-120-52-00-5212 RETIREMENT PLAN CONTRIBUTION 23,900 24,017 25,242 26,000 27,519 29,080 31,156 33,385 35,748 O1-120-52-00-5214 FICA CONTRIBUTION 15,790 16,643 17,694 17,900 18,884 19,451 20,035 20,636 21,255 O1-120-52-00-5216 GROUP HEALTH INSURANCE 26,965 28,500 34,003 29,394 62,533 67,536 72,939 78,774 85,076 01-120-52-00-5222 GROUP LIFE INSURANCE 332 368 334 335 334 337 340 343 346 01-120-52-00-5223 DENTAL INSURANCE 4,778 5,385 .6,031 5,655 6,031 6,333 6,650 6,983 7,332 01-120-52-00-5224 VISION INSURANCE 486 657 657 657 657 677 697 718 740 01-120-54-00-5412 TRAINING&CONFERENCES 3,392 3,167 3,000 3,250 3,500 3,500 3,500 3,500 3,500 O1-120-54-00-5414 AUDITING SERVICES 32,000 33,000 37,400 34,000 35,420 36,380 37,340 38,300 39,260 01-120-54-00-5415 TRAVEL&LODGING 146 274 1,500 350 1,500 1,500 1,500 1,500 1,500 O1-120-54-00-5430 PRINTING&DUPLICATING 1,365 2,853 5,000 3,000 4,000 4,000 4,000 4,000 4,000 01-120-54-00-5440 TELECOMMUNICATIONS 1,061 1,153 1,200 1,200 1,200 1,200 1,200 1,200 1,200 O1-120-54-00-5452 POSTAGE&SHIPPING 1,141 1,104 1,300 1,200 1,300 1,300 1,300 1,300 1,300 O1-120-54-00-5460 DUES&SUBSCRIPTIONS 545 528 800 800 1,000 1,000 1,000 1,000 1,000 O1-120-54-00-5462 PROFESSIONAL SERVICES 31,984 35,714 40,000 42,000 45,000 45,000 45,000 45,000 45,000 O1-120-54-00-5485 RENTAL&LEASE PURCHASE 2,102 2,079 2,500 2,025 2,500 2,500 2,500 2,500 2,500 01-120-56-00-5610 OFFICE SUPPLIES 2,633 2,650 2,700 2,700 2,700 2,700 2,700 2,700 2,700 O1-120-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 58 750 350 - 355,603 376,559 413,829 .406,816 466,157 482,135 499,287 517,292 536,174 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. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Expenditures Salaries 2,511,201 2,659,975 2,896,541 2,851,000 2,974,162 3,057,297 3,142,925 3,231,124 3,321,967 Benefits 1,411,567 1,565,443 1,833,415 1,762,220 2,001,658 2,120,884 2,245,450 2,375,537 2,511,552 Contractual Services 237,729 349,348 411,379 332,857 447,697 286,463 278,650 289,650 278,650 Supplies 154,654 98,647 148,450 118,200 134,700 139,194 144,003 149,148 154,653 Total Police 4,315,151 4,673,413 5,289,785 5,064,277 5,558,217 5,603,838 5,811,028 6,045,459 6,266,822 $7,000 $6,000 N N $5,000 3 O $4,000 I $3,000 i $2,000 $1,000 I $0 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Police 01-210-50-00-5008 SALARIES-POLICE OFFICERS 1,478,093 1,585,447 1,720,357 1,580,000 1,660,659 1,710,479 1,761,793 1,814,647 1,869,086 01-210-50-00-5011 SALARIES-POLICE CHIEF&DEPUTIES 322,269 341,359 358,109 352,000 370,238 381,345 392,785 404,569 416,706 01-210-50-00-5012 SALARIES-SERGEANTS 433,191 447,154 475,680 590,000 593,259 611,057 629,389 648,271 667,719 01-210-50-00-5013 SALARIES-POLICE CLERKS 121,384 132,096 141,395 136,000 147,006 151,416 155,958 160,637 165,456 01-210-50-00-5014 SALARIES-CROSSING GUARD 21,429 22,945 20,000 22,000 22,000 22,000 22,000 22,000 22,000 01-210-50-00-5015 PART-TIME SALARIES 57,235 43,667 70,000 60,000 70,000 70,000 70,000 70,000 70,000 01-210-50.00-5020 OVERTIME 77,600 87,307 111,000 111,000 111,000 111,000 111,000 111,000 111,000 01-210-52-00-5212 RETIREMENT PLAN CONTRIBUTION 13,778 14,283 15,271 15,000 16,048 16,959 18,169 19,469 20,847 01-210-52-00-5213 EMPLOYER CONTRIBUTION-POLICE PENSION 624,168 722,940 825,413 825,413 966,211 1,016,211 1,066,211 1,116,211 1,166,211 01-210-52-00-5214 FICA CONTRIBUTION 184,653 195,360 216,838. 212,000 221,572 228,219 235,066 242,118 249,382 01-210-52-00-5216 GROUP HEALTH INSURANCE 541,667 576,302 709,489 650,000 734,805 793,589 857,076 925,642 999,693 01-210-52-00-5222 GROUP LIFE INSURANCE 3,338 3,817 3,541 3,707 3,514 3,549 3,584 3,620 3,656 01-210-52-00-5223 DENTALINSURANCE 39,727 46,802 56,584 50,000 53,189 55,848 58,640 61,572 64,651 01-210-52-00-5224 VISION INSURANCE 4,236 5,939 6,279 6,100. 6,319 6,509 6,704 6,905 7,112 01-210-54-00-5410 TUITION REIMBURSEMENT - 3,216 31,096 6,432 21,547 10,613 2,800 2,800 2,800 01-210-54-00-5411 POLICE COMMISSION 12,633 996 4,000 3,500 15,000 4,000 4,000 15,000 4,000 01-210-54-00-5412 TRAINING&CONFERENCE 11,184 7,879 18,000 16,000 21,000 21,000 21,000 21,000 21,000 01-210-54-00-5415 TRAVEL&LODGING 2,400 2,671 10,000 5,000 10,000 10,000 10,000 10,000 10,000 01-210-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK 63,777 174,263 153,633 117,310 167,600 30,300 30,300 30,300 30,300 01-210-54-00-5426 PUBLISHING&ADVERTISING - - 200 395 200 200 200 200 200 01-210-54-00-5430 PRINTING&DUPLICATING 3,222 4,863 4,500 4,500 4,500 4,500 4,500 4,500 4,500 01-210-54-00-5440 TELECOMMUNICATIONS 25,663 29,512 36,500 36,500 36,500 36,500 36,500 36,500 36,500 01-210-54-00-5452 POSTAGE&SHIPPING 987 980 1,600 1,200 1,600 1,600 1,600 1,600 1,600 01-210-54-00-5460 DUES&SUBSCRIPTIONS 2,175 1,990 1,350 4,630 3,750 3,750 3,750 3,750 3,750 01-210-54-00-5462 PROFESSIONAL SERVICES 15,288 16,861 35,000 29,000 31,000 29,000 29,000 29,000 29,000 01-210-54-00-5466 LEGAL SERVICES - - 5,000 - 5,000 5,000 5,000 5,000 5,000 01-210-54-00-5467 ADJUDICATION SERVICES 17,215 16,684 20,000 20,000 20,000 20,000 20,000 20,000 20,000 01-210-54-00-5469 NEW WORLD&LIVE SCAN 13,269 16,921 17,500 12,490 19,500 19,500 19,500 19,500 19,500 01-210-54-00-5472 KENDALL CO JUVE PROBATION 2,609 2,894 4,000 3,240 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 6,344 5,903 7,000 6,000 7,000 7,000 7,000 7,000 7,000 01-210-54-00-5488 OFFICE CLEANING - - - - 12,500 12,500 12,500 12,500 12,500 01-210-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 54,303 57,055 55,000 60,000 60,000 60,000 60,000 60,000 60,000 01-210-56-00-5600 WEARING APPAREL 9,775 12,562 20,000 20,000 23,000 23,000 23,000 23,000 23,000 01-210-56-00-5610 OFFICE SUPPLIES 2,676 2,299 4,500 3,000 4,500 4,500 4,500 4,500 4,500 01-210-56-00-5620 OPERATING SUPPLIES 43,711 14,123 10,000 10,000 10,000 10,000 10,000 10,000 10,000 01-210-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 12,959 5,473 12,000 9,000 12,000 12,000 12,000 12,000 12,000 FY 2015 FY 2016 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Proposed Projected Projected Projected Projected O1-210-56-00-5640 REPAIR&MAINTENANCE 242 302 3,000 3,000 3,000 3,000 3,000 s.. ,..,.. a'- 01-210-56-00-5650 COMMUNITY SERVICES - 300 2,000 2,000 2,000 2,000 2,000 O1-210-56-00-5690 BALISTIC VESTS 3,035 5,281 `` 6,000 6,000 6,000 6,000 6,000 O1-210-56-00-5695 GASOLINE 65,888 58,009 rt o '; 64,200 68,694 73,503 78,648 84,153 O1-210-56-00-5696 AMMUNITION 16,368 298arr'6 at `" �� 4�V,�.. 10,000 10,000 10,000 10,000 10,000 4,315,151 4,673,413 5,558,217 5,603,838 5,811,028 6,045,459 6,266,822 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. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Expenditures Salaries 310,422 339,512 381,980 377,000 457,067 469,339 481,979 494,998 508,408 Benefits 139,045 150,738 163,247 149,105 177,490 188,657 201,286 214,839 229,338 Contractual Services 89,854 102,815 71,500 70,382 51,900 51,900 51,900 51,900 51,900 Supplies 6,467 8,877 11,175 12,000 14,190 13,140 13,300 13,472 13,656 Total Community Development 545,788 601,942 627,902 608,487 700,647 723,036 748,465 775,209 803,302 $1,000 v N $800 0 0 $600 $400 $200 $0 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Community Development ?. 01-220-50-00-5010 SALARIES&WAGES 292,601 321,278 333,980 332,000 409,067 421,339 433,979 446,998 460,408 01-220-50-00-5015 PART-TIME SALARIES 17,821 18,234 48,000 45,000 48,000 48,000 48,000 48,000 48,000 01-220-52-00-5212 RETIREMENT PLAN CONTRIBUTION 33,222 34,748 36,070 36,070 44,657 47,190 50,559 54,176 58,011 01-220-52-00-5214 FICA CONTRIBUTION 22,825 24,811 28,597 28,597 34,320 35,350 36,411 37,503 38,628 01-220-52-00-5216 GROUP HEALTH INSURANCE 76,809 84,090 90,833 78,779 90,525 97,767 105,588 114,035 123,158 01-220-52-00.5222 GROUP LIFE INSURANCE 443 491 445 401 557 563 569 575 581 01-220-52-00-5223 DENTAL INSURANCE 5,205 5,866 6,570 4,671 6,612 6,943 7,290 7,655 8,038 01-220-52-00-5224 VISION INSURANCE 541 732 732 587 819 844 869 895 922 01-220-54-00-5412 TRAINING&CONFERENCES 2,666 3,789 6,500 6,500 6,800 6,800 6,800 6,800 6,800 01-220-54-00-5415 TRAVEL&LODGING 1,670 5,316 4,000 4,000 6,500 6,500 6,500 6,500 6,500 01-220-54-00-5426 PUBLISHING&ADVERTISING 218 2,450 1,000 3,750 2,500 2,500 2,500 2,500 2,500 01-220-54-00-5430 PRINTING&DUPLICATING 1,609 1,286 2,500 1,000 2,000 2,000 2,000 2,000 2,000 01-220-54-00-5440 TELECOMMUNICATIONS 2,533 3,011 3,000 3,500 3,500 3,500 3,500 3,500 3,500 01-220-54-00-5452 POSTAGE&SHIPPING 265 610 1,000 1,000 2,500 2,500 2,500 2,500 2,500 01-220-54-00-5459 INSPECTIONS 1,840 455 5,000 2,500 5,000 5,000 5,000 5,000 5,000 01-220-54-00-5460 DUES&SUBSCRIPTIONS 1,701 1,570 2,000.. 2,000 2,100 2,100 2,100 2,100 2,100 01-220-54-00-5462 PROFESSIONAL SERVICES 73,607 79,613 41,000 41,000 15,000 15,000 15,000 15,000 15,000 01-220-54-00-5466 LEGAL SERVICES 277 1,415 2,500 2,000 3,000 3,000 3,000 3,000 3,000 01-220-54-00-5485 RENTAL&LEASE PURCHASE 3,468 3,300 3,000 3,132 3,000 3,000 3,000 3,000 3,000 01-220-56-00-5610 OFFICE SUPPLIES 455 2,862 1,500 1,500 1,500 1,500 1,500 1,500 1,500 01-220.56-00-5620 OPERATING SUPPLIES 3,842 3,848 3,000 4,500 4,200 3,000 3,000 3,000 3,000 01-220-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - 857 3,500 3,500 5,100 5,100 5,100 5,100 5,100 01-220-56-00-5645 BOOKS&PUBLICATIONS - 508 500 500 1,250 1,250 1,250 1,250 1,250 01-220-56-00-5695 GASOLINE 2,170 802 2,675 2,000 2,140 2,290 2,450 2,622 2,806 545,788 601,942 627,902 608,487 700,647 723,036 748,465 775,209 803,302 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. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Expenditures Salaries 328,574 345,777 366,975 365,288 382,325 392,997 403,989 415,311 426,972 Benefits 169,806 178,885 202,031 203,697 214,046 228,385 244,384 261,583 280,027 Contractual Services 1,395,672 1,537,504 1,458,377 1,444,926 1,242,124 1,265,081 1,296,356 1,328,577 1,361,773 Supplies 83,640 67,617 92,836 81,131 107,763 97,159 99,625 102,246 105,032 Total Public Works 1,977,692 2,129,783 2,120,219 2,095,042 1,946,258 1,983,622 2,044,354 2,107,717 2,173,804 $2,200 M $2,150 c $2,100 iC $2,050 $2,000 $1,950 $1,900 $1,850 $1,800 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Public Works-Street Operations 01-410-50-00-5010 SALARIES&WAGES 315,540 329,967 343,875 341,500 355,725 366,397 377,389 388,711 400,372 O1-410-50-00-5015 PART-TIME SALARIES 3,456 7,709 8,100 8,788 11,600 11,600 11,600 11,600 11,600 01-410-50-00-5020 OVERTIME 9,578 8,101 15,000 15,000 15,000 15,000 15,000 15,000 15,000 O1-410-52-00-5212 RETIREMENT PLAN CONTRIBUTION 36,867 36,546 38,759 38,759 40,471 42,716 45,713 48,930 52,337 O1-410-52-00-5214 FICA CONTRIBUTION 24,184 25,567 27,245 27,245 28,250 29,098 29,971 30,870 31,796 O1-410-52-00-5216 GROUP HEALTH INSURANCE 100,266 106,676 124,755 127,000 134,171 144,905 156,497 169,017 182,538 O1-410-52-00-5222 GROUP LIFE INSURANCE 564 645 594 615 594 600 606 612 618 01410-52-00-5223 DENTAL INSURANCE 7,186 8,406 9,611 9,011 9,461 9,934 10,431 10,953 11,501 01410-52-00-5224 VISION INSURANCE 739 1,045 1,067 1,067 1,099 1,132 1,166 1,201 1,237 O1-410-54-00-5412 TRAINING&CONFERENCES 1,236 6,514 3,000 3,000 3,000 3,000 3,000 3,000 3,000 O1-410-54-00-5415 TRAVEL&LODGING 240 - 2,000 1,000 2,000 2,000 2,000 2,000 2,000 01-410-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK 125,000 194,379 45,000 48,224 75,965 68,565 68,565 68,565 68,566 O1-410-54-00-5435 TRAFFIC SIGNAL MAINTENANCE 16,824 23,108 .25,000 25,000 25,000 25,000 25,000 25,000 25,000 01-410-54-00-5440 TELECOMMUNICATIONS 2,073 2,449 3,000 2,750 3,000 3,000 3,000 3,000 3,000 O1-410-54-00-5455 MOSQUITO CONTROL 6,865 7,002 7,352 7,142 7,142 7,499 7,874 8,268 8,681 O1-410-54-00-5458 TREE&STUMP MAINTENANCE - 8,225 20,000 8,980 20,000 20,000 20,000 20,000 20,000 01-410-54-00-5462 PROFESSIONAL SERVICES 3,740 3,906 3,500 6,500 3,500 3,500 3,500 3,500 3,500 01-410-54-00-5482 STREET LIGHTING - 3,296 4,750 500 750 750 750 750 750 O1-410-54-00-5485 RENTAL&LEASE PURCHASE 512 793 1,100 3,250 3,600 3,600 3,600 3,600 3,600 O1-410-54-00-5488 OFFICE CLEANING - - - - 4,167 4,167 4,167 4,167 4,167 O1-410-54-00-5490 VEHICLE MAINTENANCE SERVICES 57,838 48,132 50,000 40,000 55,000 55,000 55,000 55,000 55,000 O1-410-56-00-5600 WEARING APPAREL 4,132 5,043 4,631 4,631 4,863 5,106 5,361 5,629 5,910 01410-56-00-5620 OPERATING SUPPLIES 10,846 8,828 11,025 10,000 20,500 12,155 12,763 13,401 14,071 01-410-56-00-5626 HANGING BASKETS - - 2,000 - 2,000 2,000 2,000 2,000 2,000 01-410-56-00-5628 VEHICLE MAINTENANCE SUPPLIES 17,035 15,265 27,500 28,500 34,000 30,000 30,000 30,000 30,000 O1-410-56-00-5630 SMALL TOOLS&EQUIPMENT 2,105 3,415 2,000 2,000 5,000 5,000 5,000 5,000 5,000 01-410-56-00-5640 REPAIR&MAINTENANCE 26,791 20,580 20,000 16,000 20,000 20,000 20,000 20,000 20,000 01-410-56-00-5695 GASOLINE 22,731 14,486 25,680 20,000 21,400 22,898 24,501 26,216 28,051 796,348 890,083 826,544 796,462 907,258 914,622 944,454 975,990 1,009,29.5 Public Works-Health&Sanitation O1-540-54-00-5441 GARBAGE SERVICES-SENIOR SUBSIDY 76,958 33,486 36,000 36,000 33,000 33,000 33,000 33,000 33,000 O1-540-54-00-5442 GARBAGE SERVICES 1,100,546 1,201,414 1,251,675 1,258,500 1,000,000 1,030,000 1,060,900 1,092,727 1,125,509 O1-540-54-00-5443 LEAF PICKUP 3,840 4,800 6,000 4,080 6,000 6,000 6,000 6,000 6,000 1,181,344 1,239,700 1,293,675 1,298,580 1,039,000 1,069,000 1,099,900 1,131,727 1,164,509 Total Public Works 1,977,692 2,129,783 2,120,219 2,095,042 1,946,258 1,983,622 2,044,3.54 2,107,717 2,173,804 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. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Expenditures Salaries - 6,129 26,964 800 26,964 500 500 500 500 Benefits 299,167 326,795 350,297 336,961 371,211 393,118 416,407 441,165 467,487 Contractual Services 2,487,230 2,408,252 2,711,256 2,739,686 2,745,726 2,789,542 2,840,661 2,863,332 2,906,505 Supplies - 27,873 5,000 7,820 5,000 5,000 5,000 5,000 5,000 Other Financing Uses 2,486,885 2,448,123 2,631,459 2,739,970 2,948,210 3,287,272 3,235,672 3,117,524 3,185,554 Total Admin Services&Transfers 5,273,282 5,217,172 5,724,976 5,825,237 6,097,111 6,475,432 6,498,240 6,427,521 6,565,046 $7,000 $6,000 c o c $5,000 L F $4,000 $3,000 $2,000 $1,000 $0 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Administrative Services 01-640-50-00-5016 SALARIES-SPECIAL CENSUS 26,464 - 26,464 - - - 01-640-50-00-5092 POLICE SPECIAL DETAIL WAGES - 6,129 500 800 500 500 500 500 500 01-640-52-00-5230 UNEMPLOYMENT INSURANCE 7,950 18,460 20,000 9,670. 20,000 20,000 20,000 20,000 20,000 01-640-52-00-5231 LIABILITY INSURANCE 249,686 279,135 293,958 291,041 308,503 327,013 346,634 367,432 389,478 01-640-52-00-5240 RETIREES-GROUP HEALTH INSURANCE 40,078 27,988 35,725 35,725 42,101 45,469 49,107 53,036 57,279 01-640-52-00-5241 RETIREES-DENTAL INSURANCE 1,293 1,052 539 450 530 557 585 614 645 01-640-52-00-5242 RETIREES-VISION INSURANCE 160 160 75 75 77 79 81 83 85 01-640-54-00-5418 PURCHASING SERVICES - 15,000 15,000 50,000 50,000 50,000 50,000 50,000 01-640-54-00-5421 PPRT TAX REBATE - 2,045 - - - - - - - 01-640-54-00-5427 GC HOUSING RENTAL ASSISTANCE - - - - 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 35,000 35,000 35,000 35,000 01-640-54-00-5439 AMUSEMENT TAX REBATE 48,513 60,628 55,000 64,350 64,000 64,000 64,000 40,000 35,000 01-640-54-00-5449 KENCOM 72,999 72,679 75,000 74,842 78,584 82,513 86,639 90,971 95,520 01-640-54-00-5450 INFORMATION TECHNOLOGY SERVICES 51,066 50,875 80,000 80,000 84,000 88,200 92,610 97,241 102,103 01-640-54-00-5456 CORPORATE COUNSEL 129,599 88,017 127,339 110,000 120,000 120,000 120,000 120,000 120,000 01-640-54-00-5461 IMGA71ON COUNSEL 56,874 166,659 120,000 165,000 120,000 120,000 120,000 120,000 120,000 01-640-54-00-5463 SPECIAL COUNSEL 26,020 19,767 25,000 15,000 25,000 25,000 25,000 25,000 25,000 01-640-54-00-5465 ENGINEERING SERVICES 503,943 368,071 390,000 350,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 25,000 25,000 25,000 25,000 25,000 25,000 01-640-54-00-5475 CABLE CONSORTIUM FEE 80,204 86,054 85,000 85,000 85,000 85,000 85,000 85,000 85,000 01-640-54-00-5478 SPECIAL CENSUS - - 108,093 108,093 - - - - - 01-640-54-00-5481 HOTEL TAX REBATE 65,438 72,375 68,400 76,500 76,500 76,500 76,500 76,500 76,500 01-640.54-00-5486 ECONOMIC DEVELOPMENT 46,800 47,564 113,100 151,659 114,100 114,100 120,000 120,000 120,000 01-640-54-00-5489 LOSS ON INVESTMENT 69,382 - - - - - - - - 01-640-54-00-5491 CITY PROPERTY TAX REBATE 1,293 1,286 1,500 1,286 1,500 1,500 1,500 1,500 1,500 01-640-54-00-5492 SALES TAX REBATE 848,634 856,785 913,949 913,949 941,367 969,608 998,696 1,028,657 1,059,517 01-640-54-00-5493 BUSINESS DISTRICT REBATE 357,076 368,899 372,000 380,000 387,300 394,746 402,341 410,088 417,990 01-640-54-00-5494 ADMISSIONS TAX REBATE 104,066 121,799 120,000 122,007 120,000 120,000 120,000 120,000 120,000 01-640-54-00-5499 BAD DEBT 1,773 1,199 2,500 2,000 2,000 2,000 2,000 2,000 2,000 01-640-56-00-5625 REIMBURSABLE REPAIRS - 27,873 5,000 7,820 5,000 5,000 5,000 5,000 5,000 01-640-99-00-9915 TRANSFER TO MOTOR FUEL TAX 323 25,407 25,023 33,750 - - - - - 01-640-99-00-9916 TRANSFER TO CW BUILDINGS&GROUNDS 49,795 58,060 49,500 160,000 160,000 65,000 65,000 65,000 65,000 01-640-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL - - - - - 278,378 188,341 - - 01-640-99-00-9942 TRANSFER TO DEBT SERVICE - 127,243 268,178 268,305 315,225 319,725 319,025 318,225 318,225 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected 01-640-99-00-9952 TRANSFER TO SEWER 1,133,972 1,134,654 1,134,052 1,134,052 1,137,166 1,133,782 1,134,114 1,137,948 1,137,948 O1-640-99-00-9979 TRANSFER TO PARKS&RECREATION 1,277,606 1,076,831 1,118,638 1,118,638 1,308,583 1,461,577 1,498,713 1,564,103 1,630,258 O1-640-99-00-9982 TRANSFER TO LIBRARY OPERATIONS 25,189 25,928 36,068 25,225 27,236 28,810 30,479 32,248 34,123 5,273,282 .5,217,172 5,724,976 5,825,237 6,097,111 6,475,432 6,498,240 6,427,521 6,565,046 Expenditures 13,185,437 13,664,138 14,995,054 14,793,407 15,645,665 16,152,080 16,505,307 16,808,630 17,313,710 Surplus(Deficit) 965,473 865,648 (478,232) 200,116 (508,044) (559,000) (565,322) (518,331) (662,220) Fund Balance 4,826,059 5,691,706 5,360,499 5,891,822 .5,383,778 4,824,778 4,259,456 3,741,125 3,078,90.5 36.60% 41.65% 35.75% 39.83% 34,41% 29.87% 25.81% 22.26% 17.78% 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. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Revenue Taxes 8,536 7,072 7,073 7,263 9,365 17,338 17,338 17,338 17,338 Investment Earnings - - - - - - - - - Total Revenue 8,536 7,072 7,073 7,263 9,365 17,338 17,338 17,338 17,338 Expenditures Contractual Services 4,208 26,314 11,333 11,333 23,000 13,000 13,000 14,200 14,200 Total Expenditures 4,208 26,314 11,333 11,333 23,000 13,000 13,000 14,200 14,200 Surplus(Deficit) 4,328 (19,242) (4,260) (4,070) (13,635) 4,338 4,338 3,138 3,138 Ending Fund Balance 15,462 (3,780) (9,900) (7,850) (21,485) (17,147) (12,809) (9,671) (6,533) 367.44% -14.36% -87.36% -69.27% -93.41% -131.90% -98.53% -68.11% -46.01 $20 Fund Balance N ° $10 N c $0 ($10) ($20) ($30) FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Fox Hill SSA-I1 11-000-40-00-4000 PROPERTY TAXES 8,536 7,072 7,073 7,263 9,365 17,338 17,338 17,338 17,338 11-000-45-00-4500 INVESTMENT EARNINGS Revenue 8,536 7,072 7,073 7,263 9,365 17,338 17,338 17,338 17,338 11-111-54-00-5417 TRAIL MAINTENANCE - 21,141 - - - - - - 11-111-54-00-5462 PROFESSIONAL SERVICES - - - 7,000 7,000 7,000 7,000 7,000 11-111-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 4,208 5,173 11,333 11,333 16,000 6,000 6,000 7,200 7,200 Expenditures 4,208 26,314 11,333 11,333 23,000 13,000 13,000 14,200 14,200 Surplus(Deficit) 4,328 (19,242) (4,260) (4,070) (13,635) 4,338 4,338 3,138 3,138 Fund Balance 15,462 (3,780) (9,900) (7,850) (21,485) (17,147) (12,809) (9,671) (6,533) 367.44% -14.36% -87.36% -69.27% -93.41% -131.90% -98.53% -68.11% -46.01% Sunflower SSA Fund(12) 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. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Revenue Taxes 17,417 18,608 20,392 20,456 13,480 27,022 27,022 27,022 27,022 Investment Earnings - 1 - - - - - - - Total Revenue 17,417 18,609 20,392 20,456 13,480 27,022 27,022 27,022 27,022 Expenditures Contractual Services 40,098 29,676 17,534 8,125 29,735 22,200 22,200 23,640 23,640 Total Expenditures 40,098 29,676 17,534 8,125 29,735 22,200 22,200 23,640 23,640 Surplus(Deficit) (22,681) (11,067) 2,858 12,331 (16,255) 4,822 4,822 3,382 3,382 Ending Fund Balance (20,108) (31,175) (36,499) (18,844) (35,099) (30,277) (25,455) (22,073) (18,691) -50.15% -105.05% -208.16% -231.93% -118.04% -136.38% -114.66% -93.37% -79.07% $0 Fund�alan�e N N ($10) ($20) ($30) ($40) FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Sunflower SSA-12 12-000-40-00-4000 PROPERTY TAXES 17,417 18,608 20,392 20,456 13,480 27,022 27,022 27,022 27,022 12-000-45-00-4500 INVESTMENT EARNINGS 1 Revenue 17,417 18,609 20,392 20,456 13,480 27,022 27,022 27,022 27,022 12-112-54-00-5416 POND MAINTENANCE 34,897 26,551 6,000 2,125 8,735 5,000 5,000 5,000 5,000 12-112-54-00-5462 PROFESSIONAL SERVICES - - - - 10,000 10,000 10,000 10,000 10,000 12-112-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 5,201 3,125 11,534 6,000 11,000 7,200 7,200 8,640 8,640 Expenditures 40,098 29,676 17,534 8,125 29,735 22,200 22,200 23,640 23,640 Surplus(Deficit) (22,681) (11,067) 2,858 12,331 (16,255) 4,822 4,822 3,382 3,382 Fund Balance (20,108) (31,175) (36,499) (18,844) (35,099) (30,277) (25,455) (22,073) (18,691) -50.15% -105.05% -208.16% -231.93% -118.04% -136.38% -114.66% -93.37% -79.07% 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. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Revenue Intergovernmental 837,536 565,571 487,254 475,106 492,616 506,900 506,900 506,900 506,900 Investment Earnings 3,307 813 300 3,350 1,500 1,500 1,000 500 - Reimbursements 4,064 3,564 - - - - - - Other Financing Sources 7,148 30,951 25,023 33,750 - - - - - Total Revenue 852,055 600,899 512,577 512,206 494,116 508,400 507,900 507,400 506,900 Expenditures Contractual Services 116,902 102,418 123,793 117,750 124,350 131,346 131,262 139,123 147,455 Supplies 190,820 136,390 193,000 203,000 208,000 208,000 208,000 208,000 208,000 Capital Outlay 654,506 399,147 423,787 373,787 423,787 323,787 323,787 273,787 166,924 Total Expenditures 962,228 637,955 740,580 694,537 756,137 663,133 663,049 620,910 522,379 Surplus(Deficit) (110,173) (37,056) (228,003) (182,331) (262,021) (154,733) (155,149) (113,510) (15,479) Ending Fund Balance 920,282 883,223 484,079 700,892 438,871 284,138 128,989 15,479 - N $1,000 Fund Balance $800 r $600 ~ $400 $200 $0 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Motor Fucl Tax -15 15-000-41-00-4112 MOTOR FUEL TAX 414,685 432,820 438,254 433,178 450,716 465,000 465,000 465,000 465,000 15-000-41-00-4113 MET HIGH GROWTH 41,892 41,912 41,000 41,928 41,900 41,900 41,900 41,900 41,900 15-000-41-00-4168 STATE GRANTS-TRAFFIC SIGNAL MAINTENANCE - - 8,000 - - - - - - 15-000-41-00-4172 ILLINOIS JOBS NOW PROCEEDS 146,244 - - - - - - - - 15-000-41-00-4183 FEDERAL GRANTS-GAME FARM RD ROW 36,200 - - - - - - - - 15-000-41-00-4184 STATE GRANTS-DOWNTOWN PARKING LOT 177,949 87,238 - - - - - - 15-000-41-00-4187 FEDERAL GRANTS-CANNONBALL LAFO 20,566 3,601 - - - - - - - 15-000-45-00-4500 INVESTMENT EARNINGS 1,997 813 300 3,350 1,500 1,500 1,000 500 - 15-00045-00-4550 GAIN ON INVESTMENT 1,310 - - - - - - - - 15-000-46-00-4690 REIMB-MISCELLANEOUS 4,064 3,564 - - - - - - - 15-000-49-00-4901 TRANSFER FROM GENERAL 323 25,407 25,023 33,750 - - - - - 15-00049-00-4923 TRANSFER FROM CITY-WIDE CAPITAL 6,825 5,544 Revenue 852,0.5.5 600,899 512,577 512,206 494,116 508,400 507,900 507,400 506,900 15-155-54-00-5438 SALT STORAGE 7,500 7,750 7,500 7,750 7,750 7,750 250 250 250 15-155-54-00-5482 STREET LIGHTING 83,069 94,668 116,293 110,000 116,600 123,596 131,012 138,873 147,205 15-155-54-00-5489 LOSS ON INVESTMENT 26,333 - - - - - - - - 15-155-56-00-5618 SALT 152,585 103,119 140,000 140,000 140,000 140,000 140,000 140,000 140,000 15-155-56-00-5619 SIGNS 8,153 8,797 15,000 15,000 15,000 15,000 15,000 15,000 15,000 15-155-56-00-5633 COLD PATCH 12,413 11,706 19,000 19,000 19,000 19,000 19,000 19,000 19,000 15-155-56-00-5634 HOT PATCH 17,669 12,768 19,000 19,000 19,000 19,000 19,000 19,000 19,000 15-155-56-00-5642 STREET LIGHTING SUPPLIES - - - 10,000 15,000 15,000 15,000 15,000 15,000 15-155-60-00-6004 BASELINE ROAD BRIDGE REPAIRS 830 1,190 50,000 - 50,000 - - - - 15-155-60-00-6025 ROAD TO BETTER ROADS PROGRAM 269,813 300,000 300,000 300,000 300,000 250,000 250,000 200,000 93,137 15-155-60-00-6072 DOWNTOWN PARKING LOT 148,100 8,558 - - - - - - - 15-155-60-00-6073 GAME FARM ROAD PROJECT 73,450 - - - - - - - - 15-155-60-00-6079 ROUTE 47 EXPANSION 73,787 73,787 73,787 73,787 73,787 73,787 73,787 73,787 73,787 15-155-60-00-6089 CANNONBALL LAFO PROJECT 88,526 15,612 Expenditures 962,228 637,955 740,580 694,537 756,137 663,133 663,049 620,910 522,379 Surplus(Deficit) (110,173) (37,056) (228,003) (182,331) (262,021) (154,733) (155,149) (113,510) (15,479) Fund Balance 920,282 883,223 484,079 700,892 438,871 284,138 128,989 15,479 - City-Wide Capital Fund(23) The City-Wide Capital Fund is used to maintain existing and construct new public and municipal infrastructure,and to fund other improvements that benefit the public. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Revenue Intergovernmental 62,761 135,722 773,222 474,772 200,224 - - - - Licenses&Permits 105,266 141,203 24,000 86,000 73,000 73,000 73,000 73,000 73,000 Charges for Service 693,467 700,156 681,600 710,000 700,000 700,000 700,000 700,000 700,000 Investment Earnings 10,424 1,630 600 2,800 1,000 - - - - Reimbursements 1,261,619 399,561 294,740 224,632 472,617 5,000 5,000 5,000 5,000 Other Financing Sources 4,408,084 210,243 49,500 161,900 1,258,924 343,378 253,341 65,000 65,000 Total Revenue 6,541,621 11588,515 1,823,662 1,660,104 2,705,765 1,121,378 1,031,341 843,000 843,000 Expenditures Contractual Services 295,580 130,762 61,225 129,675 161,675 31,675 31,675 31,675 31,675 Supplies 5,971 8,913 15,000 35,000 35,000 35,000 35,000 35,000 35,000 Capital Outlay 2,147,884 2,711,081 3,313,308 3,026,697 2,940,753 713,600 588,700 287,500 312,500 Debt Service 75,000 405,937 404,138 404,138 403,588 407,563 322,188 321,338 321,338 Other Financing Uses 9,034 12,621 3,000 10,000 78,510 78,281 121,990 120,881 120,881 Total Expenditures 2,533,469 3,269,314 3,796,671 3,605,510 3,619,526 1,266,119 1,099,553 796,394 821,394 Surplus(Deficit) 4,008,152 (1,680,799) (1,973,009) (1,945,406) (913,761) (144,741) (68,212) 46,606 21,606 CW Municipal Building Fund Balance - - - - - - - City-Wide Capital Fund Balance 4,684,706 3,003,908 649,209 1,058,502 144,741 - (68,212) (21,606) - Ending Fund Balance 4,684,706 3,003,908 649,209 1,058,502 144,741 - (68,212) (21,606) - Fund Balance „ $5,000 $4,000 c $3,000 $2,000 $1,000 $0 ($1,000) FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected City-Wide Capital-23 23-000-41-00-4161 FEDERAL GRANTS-ITEP DOWNTOWN 42,461 11,244 4,000 30,210 1,600 23-000-41-00-4162 FEDERAL GRANTS-RIVER RD BRIDGE (9,411) - - - - 23-00041-00-4169 FEDERAL GRANTS-MILL STREET LAFO - 1,075 - 22,125 - - - - - 23-000-41-00-4178 FEDERAL GRANTS-ITEP KENNEDY RD TRAIL 29,711 71,327 114,160 2,475 133,424 - - - 23-000-41-00-4188 STATE GRANTS-EDP WRIGLEY(RTE 47) - 52,076 655,062 419,962 65,200 23-000-42-00-4210 BUILDING PERMITS - - - - - - - - _ 23-000-42-00-4214 DEVELOPMENT FEES-CW CAPITAL 6,900 6,150 6,000 6,000 6,000 6,000 6,000 6,000 6,000 23-000-42-00-4216 BUILD PROGRAM PERMITS 78,157 85,565 - - - - - - _ 23-00042-004218 DEVELOPMENT FEES-MUNICIPAL BLDG 2,209 7,077 3,000 10,000 7,000 7,000 7,000 7,000 7,000 23-00042-00-4222 ROAD CONTRIBUTION FEE 18,000 40,000 15,000 70,000 60,000 60,000 60,000 60,000 60,000 23-000-42-00-4224 RENEW PROGRAM PERMITS - 2,411 - - - - - - 23-000-44-00-4440 ROAD INFRASTRUCTURE FEE 693,467 700,156 681,600 710,000 700,000 700,000 700,000 700,000 700,000 23-000-45-00-4500 INVESTMENT EARNINGS 4,423 1,630 600 2,800 1,000 - - - - 23-000-45-00-4550 GAIN ON INVESTMENT 6,001 - - - - 23-000-46-00-4606 REIMB-COM ED 93,095 316,905 - - - - - - - - 23-000-46-00-4607 REIMB-BLACKBERRY WOODS - 11,999 - 152,017 - - - - - 23-000-46-00-4608 REIMB-KENNEDY ROAD IMPROVEMENTS - - - - 160,000 - - - - 23-000-46-00-4620 REIMB-PULTE(AUTUMN CREEK) 1,148,170 25,703 - - - - - - _ 23-000-46-00-4630 REIMB-STAGECOACH CROSSING - - - 58,596 - 5,000 5,000 5,000 5,000 23-00046-00-4660 REIMB-PUSH FOR THE PATH 7,727 38,618 294,740 619 312,617 - - - - 23-000-46-004690 REIMB-MISCELLANEOUS 12,627 6,336 - 3,400 - - - - - 23-000-49-00-4900 BOND PROCEEDS 4,295,000 - 23-000-49-00-4903 PREMIUM ON BOND ISSUANCE 49,789 - - - - - - - - 23-000-49-00-4905 LOAN PROCEEDS-RIVER ROAD BRIDGE - 152,183 - - - - - - - 23-000-49-00-4910 SALE OF CAPITAL ASSETS - - - 1,900 - - - - - 23-00049-00-4916 TRANSFER FROM GENERAL-CWB&G 49,795 58,060 49,500 160,000 160,000 65,000 65,000 65,000 65,000 23-000-49-00-4923 TRANSFER FROM GENERAL-CW CAPITAL - - - - - 278,378 188,341 - - 23-000-49-00-4951 TRANSFER FROM WATER - - - - 1,098,924 - - - - 23-000-49-00-4988 TRANSFER FROM DOWNTOWN TIF 13,500 Revenue 6,541,621 1,588,51.5 1,823,662 1,660,104 2,705,765 1,121,378 1,031,341 843,000 843,000 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected City-Wide-Building&Grounds Expenditures 23-216-54-00-5405 BUILD PROGRAM 6,000 8,945 - - - - - _ _ 23-216-54-00-5446 PROPERTY&BLDG MAINT SERVICES 37,824 40,202 w4>,'�',?' 34,500 125,000 125,000 30,000 30,000 30,000 30,000 23-216-56-00-5656 PROPERTY&BLDG MAINT SUPPLIES 5,971 8,913 15,000 35,000 35,000 35,000 35,000 35,000 35,000 23-216-99-00-9901 TRANSFER TO GENERAL 2,209 7,077 3,000 10,000 7,000 7,000 7,000 7,000 7,000 52,004 65,137 52,500 170,000 167,000 72,000 72,000 72,000 729000 City-Wide Capital Expenditures '. 23-230-54-00-5402 BOND ISSUANCE COSTS 52,025 - 23-230-54-00-5405 BUILD PROGRAM 72,157 76,620 23-230-54-00-5406 RENEW PROGRAM - 2,411 - - - 23-230-54-00-5465 ENGINEERING SERVICES 5,856 1,370 25,000 3,000 35,000 - - - - 23-230-54-00-5489 LOSS ON INVESTMENT 120,631 - - - - - - - _ 23-230-54-00-5498 PAYING AGENT FEES - 475 525 475 475 475 475 475 475 23-230-54-00-5499 BAD DEBT 1,087 739 1,200 1,200 1,200 1,200 1,200 1,200 1,200 23-230-60-00-6007 KENNEDY RD-AUTUMN CREEK 1,067,717 25,703 - - - - - - _ 23-230-60-00-6008 BEECHER&CORNEILS ROAD 93,095 318,507 - - - - - - - 23-230-60-00-6009 WRIGLEY(RTE 47)EXPANSION - 57,430 655,062 420,249 65,200 - - - - 23-230-60-00-6011 PROPERTY ACQUISITION - - - 160,000 - - - - - 23-230-60-00-6014 BLACKBERRY WOODS - 11,999 - 162,017 23-230.60-00-6017 STAGECOACH CROSSING - - ,. - 58,596 - - - - - 23-230-60-00-6016 US 34(CENTER/ELDAMAIN RD)PROJECT - - - 151,300 151,300 151,400 - - 23-230-60-00-6018 GREENBRIAR POND NATURALIZATION 18,769 12,632 4,000 8,467 4,672 5,000 5,000 5,000 5,000 23-230-60-00-6025 ROAD TO BETTER ROADS PROGRAM 405,718 509,430 950,000 698,975 400,000 400,000 275,000 275,000 300,000 23-230-60-00-6041 SIDEWALK CONSTRUCTION 8,065 3,598 12,500 5,000 7,500 7,500 7,500 7,500 7,500 23-230-60-00-6048 DOWNTOWN STREETSCAPE IMPROVEMENT 53,077 14,055 5,000 37,762 2,000 - - - - 23-230-60-00-6058 ROUTE 71(RTE 47/ORCHARD RD)PROJECT - - ;. - - - 55,200 55,200 - - 23-230-60-00-6059 US 34(B.47/ORCHARD RD)PROJECT - - 92,846 - 94,600 94,600 94,600 - - 23-230-60-00-6073 GAME FARM ROAD PROJECT 354,220 1,377,783 415,000 336,058 - - - - - 23-230-60-00-6075 RIVER ROAD BRIDGE PROJECT - 152,183 - - - - - - - 23-230-60-00-6082 COUNTRYSIDE PKY IMPROVEMENTS - 117,202 770,000 1,136,479 645,940 - - - - 23-230-60-00-6084 CENTER&COUNTRYSIDE IMPROVEMENTS - - - 'f'^ °. 522,000 - - - - 23-230-60-00-6086 KENNEDY ROAD IMPROVEMENTS - - - 601,500 - - - - 23-230-60-00-6094 KENNEDY RD BIKE TRAIL 37,438 109,946 408,900 3,094 446,041 - - - - 23-230-60-00-6095 SUNFLOWER ESTATES-DRAINAGE IMPROVEMENT 109,785 613 - - - - - - - FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected 2014A Bond 23-230-78-00-8000 PRINCIPAL PAYMENT - 135,000 185,000 185,000 190,000 190,000 195,000 200,000 200,000 23-230-78-00-8050 INTEREST PAYMENT - 195,937 144,138 144,138 138,588 132,888 127,188 121,338 121,338 Kendall County Loan-River Road Bridge 23-230-97-00-8000 PRINCIPAL PAYMENT 75,000 75,000 75,000 75,000 75,000 84,675 - - - 23-230.99-00-9915 TRANSFER TO MOTOR FUEL TAX 6,825 5,544 - - - - - - 23-230-99-00-9951 TRANSFER TO WATER 71,510 71,281 114,990 113,881 113,881 2,481,465 3,204,177 3,744,171 3,435,510 3,452,526 1,194,119 1,027,553 724,394 749,394 Expenditures 2,533,469 3,269,314 3,796,671 3,605,510 3,619,526 1,266,119 1,099,553 796,394 821,394 Surplus(Deficit) 4,008,152 (1,680,799) (1,973,009) (1,945,406) (913,761) (144,741) (68,212) 46,606 21,606 Fund Balance-CW Municipal Building Fund Balance-City-Wide Capital 4,684,706 3,1123.9118 649,109 7,058,502 144,741 (68,212) (21,60 Fund Balance 4,684,706 3,003,908 649,209 1,058,502 144,741 - (68,212) (21,606) - 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. This fund primarily derives its revenue from monies collected from building permits and development fees. The revenue is used to purchase vehicles and equipment for use in the operations of the Police,Public Works and Parks &Recreation Departments. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Revenue Licenses&Permits 59,700 89,150 26,000 100,000 73,500 73,500 73,500 73,500 73,500 Fines&Forfeits 9,181 11,374 10,200 7,700 7,700 7,700 7,700 7,700 7,700 Charges for Service 301,715 374,386 275,633 241,561 246,565 101,865 101,865 101,865 101,866 Investment Earnings 449 43 50 80 80 50 50 50 50 Reimbursements 97,771 - - - - - - - - Miscellaneous 2,193 4,627 2,000 5,200 2,000 2,000 2,000 2,000 2,000 Other Financing Sources - 48,446 1,000 254,162 - - - - - Total Revenue 471,009 528,026 314,883 608,703 329,845 185,115 185,115 185,115 185,116 Police Capital Expenditures Contractual Services 15,803 15,717 16,833 8,000 8,000 8,000 8,000 8,000 8,000 Capital Outlay 112,242 197,119 155,000 155,000 192,300 55,000 55,000 55,000 55,000 Sub-Total Expenditures 128,045 212,836 171,833 163,000 200,300 63,000 63,000 63,000 63,000 Public Works Capital Expenditures Contractual Services 31,608 35,611 1,750 1,750 1,750 1,750 1,750 1,750 1,750 Supplies 499 - 2,000 2,000 2,000 2,000 2,000 2,000 2,000 Capital Outlay 163,750 184,891 45,000 45,000 52,400 45,000 45,000 45,000 45,000 Debt Service 70,816 70,815 70,815 70,815 70,815 70,815 70,815 70,815 70,816 Sub-Total Expenditures 266,673 291,317 119,565 119,565 126,965 119,565 119,565 119,565 119,566 Parks&Rec Capital Expenditures Contractual Services 4,303 1,225 - 1,772 - - - - - Capital Outlay 111,937 124,165 54,000 53,908 270,441 - - - - Debt Service 2,219 2,219 2,219 2,219 2,219 2,219 2,219 2,219 2,218 Sub-Total Expenditures 118,459 127,609 56,219 57,899 272,660 2,219 2,219 2,219 2,218 Total Expenditures 513,177 631,762 347,617 340,464 599,925 184,784 184,784 184,784 184,784 Surplus(Deficit) (42,168) (103,736) (32,734) 268,239 (270,080) 331 331 331 332 Police Capital Fund Balance - - - - - Public Works Capital Fund Balance (20,106) - - - - - - Parks&Rec Capital Fund Balance 125,683 1,841 270,080 331 662 993 1,325 Ending Fund Balance 105,577 1,841 270,080 331 662 993 1,325 $300 Fund Balance Out $200 r $100 $0 -- -- - FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Vehicle&Equipment-25 25-000-42-00-4215 DEVELOPMENT FEES-POLICE CAPITAL 5,175 12,900 7,000 32,000 25,000 25,000 25,000 25,000 25,000 25-000-42-00-4216 BUILD PROGRAM PERMITS 42,920 43,410 - - - - - - - 25-000-42-00-4217 WEATHER WARNING SIREN FEES - - - - - - - - - 25-000-42-00-4218 ENGINEERING CAPITAL FEE 1,300 3,250 3,000 8,000 6,000 6,000 6,000 6,000 6,000 25-000-42-00-4219 DEVELOPMENT FEES-PW CAPITAL 9,655 26,240 15,000 56,000 40,000 40,000 40,000 40,000 40,000 25-000-42-00-4220 DEVELOPMENT FEES-PARK CAPITAL 650 1,625 1,000 4,000 2,500 2,500 2,500 2,500 2,500 25-000-42-00-4224 RENEW PROGRAM PERMITS - 1,725 - - - - - - - 25-000-43-00-4315 DUI FINES 5,545 10,803 7,000 7,000 7,000 7,000 7,000 7,000 7,000 25-000-43-00-4316 ELECTRONIC CITATION FEES 720 571 700 700 700 700 700 700 700 25-00043-004340 SEIZED VEHICLE PROCEEDS 2,916 - 2,500 - - - - - - 25-000-44-00-4418 MOWING INCOME 3,288 5,744 3,000 2,141 3,000 3,000 3,000 3,000 3,000 25-000-44-00-4420 POLICE CHARGEBACK 63,777 174,263 153,633 117,310 167,600 30,300 30,300 30,300 30,300 25-000-44-00-4421 PUBLIC WORKS CHARGEBACK 125,000 194,379 45,000 48,224 75,965 68,565 68,565 68,565 68,566 25-000-44-00-4427 PARKS&RECREATION CHARGEBACK 109,650 - 74,000 73,886 - - - - - 25-000-45-00-4522 INVESTMENT EARNINGS-PARK CAPITAL 312 43 50 80 80 50 50 50 50 25-000-45-00-4550 GAIN ON INVESTMENT 137 - - - - - - - 25-000-46-00-4692 REIMB-MISCELLANEOUS-PARK CAPITAL 97,771 - 25-000-48-00-4852 MISCELLANEOUS INCOME-POLICE CAPITAL 191 624 - - - - - - - 25-000-48-004854 MISCELLANEOUS INCOME-PW CAPITAL 2,002 3,929 2,000 5,200 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 1,000 5,990 - - - - 25-000-49-00-4921 SALE OF CAPITAL ASSETS-PW CAPITAL - 44,171 - - - - - - 25-000-49-004922 SALE OF CAPITAL ASSETS-PARK CAPITAL 800 248,172 - Revenue 471,009 528,026 314,883 608,703 329,845 185,115 185,115 185,115 185,116 Police Capital 25-205-54-00.5405 BUILD PROGRAM 10,350 9,750 - - - - - - - 25-205-54-00-5406 RENEW PROGRAM - 450 - - - - - - 25-205-54-00-5462 PROFESSIONAL SERVICES 1,166 - 833 - - - - - - 25-205-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 4,287 5,517 16,000 8,000 8,000 8,000 8,000 8,000 8,000 25-205-60-00-6060 EQUIPMENT 32,865 2,369 - - 27,300 - - - - 25-205-60-00-6070 VEHICLES 79,377 194,750 155,000 155,000 165,000 55,000 55,000 55,000 55,000 128,045 212,836 171,833 163,000 200,300 63,000 63,000 63,000 63,000 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Public Works Capital 25-215-54-00-5405 BUILD PROGRAM 31,020 32,510 25-215-54-00-5406 RENEW PROGRAM - 1,200 - - - - - - _ 25-215-54-00-5448 FILING FEES 588 1,901 1,750 1,750 1,750 1,750 1,750 1,750 1,750 25-215-56-00-5620 OPERATING SUPPLIES 499 - 2,000 2,000 2,000 2,000 2,000 2,000 2,000 25-215-60-00-6060 EQUIPMENT 163,750 15,084 - - 7,400 - - - - 25-215-60-00-6070 VEHICLES - 169,807 45,000 45,000 45,000 45,000 45,000 45,000 45,000 185 Wo1j.Street Building 25-215-92-00-8000 PRINCIPAL PAYMENT 37,924 39,638 41,430 41,430 43,303 45,261 47,307 49,446 51,682 25-215-92-00-8050 INTEREST PAYMENT 32,892 31,177 29,385 29,385 27,512 25,554 23,508 21,369 19,134 266,673 291,317 119,565 119,565 126,965 119,565 119,565 119,565 119,566 Parks&Recreation Capital 25-225-54-00-5405 BUILD PROGRAM 1,550 1,150 - - - - - 25-225-54-00-5406 RENEW PROGRAM - 75 - - - - - - - 25-225-54-00-5462 PROFESSIONAL SERVICES - - - - , 1,772 - - - - - 25-225-54-00-5489 LOSS ON INVESTMENT 2,753 - - - - - 25-225-60-00-6020 BUILDINGS&STRUCTURES - - - 250,441 - - - - 25-225-60-00-6060 EQUIPMENT 33,731 78,936 54,000 53,908 - - - - - 25-225-60-00-6065 BRIDGE PARK 78,206 - - - - - - - 25-225-60-00-6068 TRAIL IMPROVEMENTS - 20,347 - - - - - 25-225-60-00-6070 VEHICLES - 24,882 - - 20,000 - - - - 185 WoljStreet Building 25-225-92-00-8000 PRINCIPAL PAYMENT 1,188 1,242 1,298 1,298 1,357 1,418 1,482 1,549 1,619 25-225-92-00-8050 INTEREST PAYMENT 1,031 977 921 921 862 801 737 670 599 118,459 127,609 56,219 57,899 272,660 2,219 2,219 2,219 2,218 Expenditures 513,177 631,762 347,617 340,464 599,925 184,784 184,784 184,784 184,784 Surplus(Deficit) (42,168) (103,736) (32,734) 268,239 (270,080) 331 331 331 332 Fund Balance-Police Capital - Fund Balance-Public Works Capital (10,106) Fund Balance-Parks&Bec Capital 125,683 1,841 270,080 331 661 993 1,325 Fund Balance 105,577 1,841 - 270,080 - 331 662 993 1,325 Debt Service Fund(42) The Debt Service Fund accumulates monies for payment of the 2014B bonds,which refinanced the 2005A bonds. The 2005A bonds were originally issued to finance road improvement projects. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Revenue Taxes 327,984 164,852 47,497 47,070 - - - - - Licenses&Permits 7,418 14,281 5,000 5,250 5,000 5,000 5,000 5,000 5,000 Investment Earnings 5 11 - - - - - - - Other Financing Sources 2,369,891 127,243 268,178 268,305 315,225 319,725 319,025 318,225 318,225 Total Revenue 2,705,298 306,387 320,675 320,625 320,225 324,725 324,025 323,225 323,225 Expenditures Contractual Services 39,617 3,979 525 475 475 475 475 475 475 Debt Service 304,042 310,250 320,150 320,150 319,750 324,250 323,550 322,750 322,750 Other Financing Uses 2,359,115 - - - - - - - - Total Expenditures 2,702,774 314,229 320,675 320,625 320,225 324,725 324,025 323,225 323,225 Surplus(Deficit) 2,524 (7,842) - - - - - - - Ending Fund Balance 7,842 - - - - - - - - $10 Fund Balance $8 c $6 $4 $2 $0 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Debt Service-42 42-000-40-00-4000 PROPERTY TAXES-2014B BOND 327,984 164,852 47,497 47,070 - - - - - 42-000-42-004208 RECAPTURE FEES-WATER&SEWER 1,696 10,777 5,000 5,250 5,000 5,000 5,000 5,000 5,000 42-000-42-00-4216 BUILD PROGRAM PERMITS 5,722 3,466 - - - - - - - 42-000-42-004224 RENEW PROGRAM - 38 - - - - - - - 42-000-45-00-4500 INVESTMENT EARNINGS 5 11 - - - - - - - 42-000-49-00-4901 TRANSFER FROM GENERAL - 127,243 268,178 268,305 315,225 319,725 319,025 318,225 318,225 42-000-49-00-4902 BOND ISSUANCE 2,300,000 - - - - - - - - 42-000-49-00-4903 PREMIUM ON BOND ISSUANCE 69,891 Revenue 2,705,298 306,387 320,675 320,625 320,225 324,725 324,025 323,225 323,225 42-420-54-00-5402 BOND ISSUANCE COSTS 33,306 - - - - - - 42-420-54-00-5405 BUILD PROGRAM 5,722 3,466 - - - - - 42-420-54-00-5406 RENEW PROGRAM - 38 - - - - - 42-420-54-00-5498 PAYING AGENT FEES 589 475 525 475 475 475 475 475 475 2014B Refunding Bond 42-420-79-00-8000 PRINCIPAL PAYMENT - 255,000 270,000 270,000 275,000 285,000 290,000 295,000 295,000 42-420-79-00-8050 INTEREST PAYMENT 22,253 55,250 '50,150 50,150 44,750 39,250 33,550 27,750 27,750 2005A Bond 42-420-82-00-8000 PRINCIPAL PAYMENT 225,000 - - - - - - - - 42-420-82-00-8050 INTEREST PAYMENT 56,789 - - - - - - - - 42-420-99-00-9960 PAYMENT TO ESCROW AGENT 2,359,115 Expenditures 2,702,774 314,229 320,675 320,625 320,225 324,725 324,025 323,225 323,225 Surplus(Deficit) 2,524 (7,842) - - - - - - - Fund Balance 7,842 - - - - - - - - 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. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Revenue Taxes 5,210 - - - - - - - Licenses&Permits 112,323 162,468 - - - - - - - Charges for Service 2,513,791 3,461,906 3,661,400 3,981,000 4,088,800 4,118,800 4,273,990 4,436,940 4,608,036 Investment Earnings 2,034 5,492 1,000 8,500 5,000 5,000 5,000 2,500 2,500 Reimbursements 3,970 4,605 - 25,606 - - - - - Miscellaneous 57,775 57,261 57,433 57,833 58,582 59,754 60,949 62,168 63,411 Other Financing Sources 1,373,687 4,369,998 75,075 6,324,098 145,385 148,956 188,865 189,006 189,006 Total Revenue 4,068,790 8,061,730 3,794,908 10,397,037 4,2979767 4,332,510 4,528,804 4,690,614 4,862,953 Expenses Salaries 354,098 376,019 416,844 399,044 430,549 442,211 454,223 466,596 479,340 Benefits 211,030 218,947 252,493 246,721 266,965 284,540 304,039 324,975 347,406 Contractual Services 609,139 887,201 607,087 637,753 886,366 905,829 926,362 762,437 770,298 Supplies 245,704 266,102 297,660 313,350 323,013 333,817 345,191 357,166 369,773 Capital Outlay 474,916 1,069,736 3,606,668 3,344,368 807,937 767,944 1,189,144 570,544 602,544 Debt Service 1,168,385 1,147,429 1,450,677 1,312,493 1,344,749 1,532,837 2,361,500 2,305,935 1,811,935 Other Financing Uses 1,256,453 - - 6,193,291 1,098,924 - - - - Total Expenses 4,319,725 3,965,434 6,631,429 12,447,020 5,158,503 4,267,178 5,580,459 4,787,653 4,381,296 Surplus(Deficit) (250,935) 4,096,296 (2,836,521) (2,049,983) (860,736) 65,332 (1,051,655) (97,040) 481,657 Ending Fund Balance Equivalent 11099,988 5,196,289 2,434,477 3,146,306 2,285,570 2,350,902 1,299,247 1,202,208 1,683,865 25.46% 131.04% 3671% 25.28% 44.31% 55.09% 23.28% 25.11% 38.43% $6,000 Fund Balance Equivalent $4,000 0 t ~ $2,000 $0 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Water-51 51-000-40-00-4000 PROPERTY TAXES-2007A BOND 5,210 - - - - - - - - 51-000-42-00-4216 BUILD PROGRAM PERMITS 112,323 162,468 - - - - - - - 51-000-44-004424 WATER SALES 2,019,810 2,463,058 2,783,000 2,986,000 2,956,000 3,103,800 3,258,990 3,421,940 3,593,036 51-000-44-00-4425 BULK WATER SALES 29,590 (6,660) 500 5,000 5,000 5,000 5,000 5,000 5,000 51-000-44-00-4426 LATE PENALTIES-WATER 91,488 101,208 90,000 105,000 105,000 105,000 105,000 105,000 105,000 51-000-44-00-4430 WATER METER SALES 15,782 38,102 35,000 60,000 50,000 50,000 50,000 50,000 50,000 51-000-44-004440 WATER INFRASTRUCTURE FEE 343,961 717,028 702,900 725,000 725,000 725,000 725,000 725,000 725,000 51-000-44-00-4450 WATER CONNECTION FEES 13,160 149,170 50,000 100,000 247,800 130,000 130,000 130,000 130,000 51-000-45-00-4500 INVESTMENT EARNINGS 1,236 5,492 1,000 8,500 5,000 5,000 5,000 2,500 2,500 51-000-45-00-4550 GAIN ON INVESTMENT 798 - - - - - - - - 51-000-46-00-4690 REIMB-MISCELLANEOUS 3,970 4,605 - 25,606 - - - - - 51-000-48-00-4820 RENTAL INCOME 55,560 56,888 57,433 57,433 58,582 59,754 60,949 62,168 63,411 51-000.48-00-4850 MISCELLANEOUS INCOME 2,215 373 - 400 - - - - - 51-000-49-00-4900 BOND PROCEEDS - 4,100,000 - - - - - - - 51-000-49-00-4902 BOND ISSUANCE 1,263,500 - 5,800,000 51-000-49-00-4903 PREMIUM ON BOND ISSUANCE 26,599 193,723 - 449,023 - - - - - 51-000-49-00-4923 TRANSFER FROM CITY-WIDE CAPITAL - - - - 71,510 71,281 114,990 113,881 113,881 51-000-49-00-4952 TRANSFER FROM SEWER 83,588 76,275 75,075 75,075 73,875 77,675 73,875 75,125 75,125 Revenue 4,068,790 8,061,730 3,794,908 10,397,037 4,297,767 4,332,510 4,525,804 4,690,614 4,862,953 Water Operations 51-510-50-00-5010 SALARIES&WAGES 343,733 365,077 375,044 375,044 388,749 400,411 412,423 424,796 437,540 51-510-50-00-5015 PART-1114E SALARIES 2,808 3,611 29,800 12,000 29,800 29,800 29,800 29,800 29,800 51-510-50-00-5020 OVERTIME 7,557 7,331 12,000 12,000 12,000 12,000 12,000 12,000 12,000 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION 39,878 40,267 41,801 41,801 43,749 46,190 49,445 52,940 56,642 51-510-52-00-5214 FICA CONTRIBUTION 25,689 27,354 30,854 30,854 31,730 32,682 33,662 34,672 35,712 51-510-52-00-5216 GROUP HEALTH INSURANCE 113,371 113,806 139,623 134,688 148,964 160,881 173,751 187,651 202,663 51-510-52-00-5222 GROUP LIFE INSURANCE 701 777 705 705 705 712 719 726 733 51-510-52-00-5223 DENTALINSURANCE 7,130 8,712 9,757 9,148 9,605 10,085 10,589 11,118 11,674 51-510-52-00-5224 VISION INSURANCE 793 1,131 1,131 1,131 1,165 1,200 1,236 1,273 1,311 51-510-52-00-5230 UNEMPLOYMENT INSURANCE 716 1,785 2,000 991 2,000 2,000 2,000 2,000 2,000 51-510-52-00-5231 LIABILITY INSURANCE 22,752 25,115 26,622 27,403 29,047 30,790 32,637 34,595 36,671 51-510-54-00-5401 ADMINISTRATIVE CHARGEBACK - - - - 108,154 111,399 114,741 118,183 121,728 51-510-54-00-5402 BOND ISSUANCE COSTS 24,378 40,456 55,732 - - - - - 51-510-54-00-5405 BUILD PROGRAM 112,323 162,468 - - - - - - - 51-510-54-00.5412 TRAINING&CONFERENCES 2,305 3,072 ' ..6,500 4,500 6,500 6,500 6,500 6,500 6,500 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected 51-510-54-00-5415 TRAVEL&LODGING 942 1,193 1,600 1,200 1,600 1,600 1,600 1,600 1,600 51-510-54-00-5426 PUBLISHING&ADVERTISING 148 211 1,000 605 1,000 1,000 1,000 1,000 1,000 51-510-54-00-5429 WATER SAMPLES 9,823 6,842 14,000 8,000 12,000 12,000 12,000 12,000 12,000 51-510-54-00-5430 PRINTING&DUPLICATING 112 2,679 3,300 2,500 3,000 3,000 3,000 3,000 3,000 51-510-54-00-5440 TELECOMMUNICATIONS 20,221 24,715 24,500 29,000 30,000 30,000 30,000 30,000 30,000 51-510-54-00-5445 TREATMENT FACILITY SERVICES 108,905 113,208 112,000 120,000 120,000 120,000 120,000 120,000 120,000 51-510-54-00-5448 FILING FEES 4,253 3,753 6,500 3,500 5,000 5,000 5,000 5,000 5,000 51-510-54-00-5452 POSTAGE&SHIPPING 17,953 18,206 19,000 19,000 19,000 19,000 19,000 19,000 19,000 51-510-54-00-5460 DUES&SUBSCRIPTIONS 978 1,080 1,600 1,000 1,600 1,600 1,600 1,600 1,600 51-510-54-00-5462 PROFESSIONAL SERVICES 20,343 47,595 21,500 42,000 45,000 45,000 45,000 45,000 45,000 51-510-54-00-5465 ENGINEERING SERVICES - 187,840 62,160 46,997 200,000 200,000 200,000 15,000 - 51-510-54-00-5466 LEGAL SERVICES - - 2,000 - 2,000 2,000 2,000 2,000 2,000 51-510-54-00-5480 UTILITIES 245,641 239,114 280,132 255,000 270,300 286,518 303,709 321,932 341,248 51-510-54-00-5483 JULIE SERVICES 4,570 4,300 5,000 5,000 6,500 6,500 6,500 6,500 6,500 51-510-54-00-5485 RENTAL&LEASE PURCHASE 504 464 1,000 424 750 750 750 750 750 51-510-54-00-5488 OFFICE CLEANING - 4,167 4,167 4,167 4,167 4,167 51-510-54-00-5489 LOSS ON INVESTMENT 16,036 - - - - - 51-510-54-00-5490 VEHICLE MAINTENANCE SERVICES 7,077 14,551 15,000 15,000 15,000 15,000 15,000 15,000 15,000 51-510-54-00-5495 OUTSIDE REPAIR&MAINTENCE 3,380 6,994 19,000 19,000 25,000 25,000 25,000 25,000 25,000 51-510-54-00-5498 PAYING AGENT FEES 2,354 2,241 2,295 2,295 2,295 2,295 2,295 1,705 1,705 51-510-54-00-5499 BAD DEBT 6,893 6,219 9,000 7,000 7,500 7,500 7,500 7,500 7,500 51-510-56-00-5600 WEARING APPAREL 3,434 5,194 4,410 4,000 4,200 4,410 - 4,631 4,863 5,106 51-510-56-00-5620 OPERATING SUPPLIES 12,352 5,993 16,750 12,000 15,000 15,000 15,000 15,000 15,000 51-510-56-00-5628 VEHICLE MAINTENANCE SUPPLIES 2,314 1,082 10,000 4,000 5,000 5,000 5,000 5,000 5,000 51-510-56-00-5630 SMALL TOOLS&EQUIPMENT 1,921 1,144 2,000 2,100 2,000 2,000 2,000 2,000 2,000 51-510-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 1,616 641 2,000 1,500 2,000 2,000 2,000 2,000 2,000 51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 146,540 151,829 173,250 173,250 181,913 191,009 200,559 210,587 221,116 51-510-56-00-5640 REPAIR&MAINTENANCE 20,263 12,970 15,000 20,000 20,000 20,000 20,000 20,000 20,000 51-510-56-00-5664 METERS&PARTS 32,520 72,039 46,000 75,000 70,000 70,000 70,000 70,000 70,000 51-510-56-00-5665 JULIE SUPPLIES 1,788 1,272 1,500 1,500 1,500 1,500 1,500 1,500 1,500 51-510.56-00-5695 GASOLINE 22,956 13,938 26,750 20,000 21,400 22,898 24,501 26,216 28,051 51-510-60-00-6022 WELL REHABILITATIONS - 128,876 124,000 183,119 203,000 - 148,000 - - 51-510-60-00-6025 ROAD TO BETTER ROADS PROGRAM 277,372 259,341 250,000 292,338 250,000 250,000 250,000 250,000 250,000 51-510-60-00-6059 US 34(IL 47/ORCHARD RD)PROJECT - - 22,124 - 10,000 10,000 10,000 - - 51-510-60-00-6060 EQUIPMENT - - 5,000 3,248 10,000 5,000 355,000 5,000 5,000 51-510-60-00-6066 RTE 71 WATERMAIN REPLACEMENT - 15,955 5,000 33,681 14,580 302,400 75,600 - - 51-510-60-00-6070 VEHICLES - - 63,000 58,075 - - - - - 51-510-60-00-6079 ROUTE 47 EXPANSION 197,544 197,544 197,544 197,544 197,544 197,544 197,544 197,544 197,544 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected 51-510-60-00-6081 CATION EXCHANGE MEDIA REPLACEMENT - - - - 3,000 153,000 118,000 150,000 51-510-60-00-6082 COUNTRYSIDE PKY IMPROVEMENTS - 468,020 2,940,000 2,576,363 122,813 - - - - 2015A Bond 51-510-77-00-8000 PRINCIPAL PAYMENT - - 73,540: 73,540 113,987 117,664 290,483 297,837 297,837 51-510-77-00-8050 INTEREST PAYMENT - - 229,137. 229,137 161,053 156,493 151,787 140,167 140,167 Debt Service-2007A Bond 51-510-83-00-8000 PRINCIPAL PAYMENT 15,000 15,000 15,000 15,000 - - - - - 51-510-83-00-8050 INTEREST PAYMENT 122,423 121,793 121,163 60,582 - - - - - Debt Service-2016 Refunding Bond 51-510-85-00-8000 PRINCIPAL PAYMENT - - - 430,000 470,000 1,470,000 1,475,000 1,040,000 51-510-85-00-8050 INTEREST PAYMENT - - - - 249,629 195,250 176,450 117,650 58,650 Debt Service-2003 Debt Certificates 51-510-86-00-8000 PRINCIPAL PAYMENT 100,000 100,000 100,000 100,000 100,000 300,000 - - - 51-510-86-00-8050 INTEREST EXPENSE 29,350 25,450 21,450 21,450 17,300 13,050 - - - Debt Service-2006A Refunding Debt Certificates 51-510-87-00-8000 PRINCIPAL PAYMENT 420,000 435,000 460,000 460,000 - - - - - 51-510-87-00-8050 INTEREST EXPENSE 189,406 172,606 155,206 77,603 - - - - - Debt Service-2005C Bond 51-510-88-00-8000 PRINCIPAL PAYMENT 100,000 - - - - - - - - 51-510-88-00-8050 INTEREST EXPENSE 54,065 - - - - - - - - Debt Service-IEPA Loan L17-156300 51-510-89-00-8000 PRINCIPAL PAYMENT 92,224 94,544 96,923 96,923 99,361 101,860 104,423 107,050 107,050 51-510-89-00-8050 INTEREST EXPENSE 32,806 30,486 28,108 28,108 25,669 23,170 20,607 17,981 17,981 Debt Service-2014C Refunding Bond 51-510-94-00-8000 PRINCIPAL PAYMENT - 120,000 120,000 120,000 120,000 130,000 125,000 130,000 130,000 51-510-94-00-8050 INTEREST PAYMENT 13,111 32,550 30,150 30,150 27,750 25,350 22,750 20,250 20,250 51-510-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL - - - - 1,098,924 - - - - 51-510-99-00-9960 PAYMENT TO ESCROW AGENT 1,256,453 6,193,291 Expenses 4,319,725 3,965,434 6,631,429 12,447,020 5,158,503 4,267,178 5,580,459 4,787,653 4,381,296 Surplus(Deficit) (250,935) 4,096,296 (2,836,521) (2,049,983) (860,736) 65,332 (1,051,65.5) (97,040) 481,657 Fund Balance Equiv 1,099,988 5,196,289 2,434,477 3,146,306 2,285,570 2,350,902 1,299,247 1,202,208 1,683,865 25.46% 131.04% 36.71% 25.28% 44.31% 55.09% 23.28% 25.11% 38.43% 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. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Revenue Licenses&Permits 35,000 77,350 - - - - - - - Charges for Service 1,151,713 1,312,456 1,199,942 1,258,600 1,266,026 1,292,597 1,319,870 1,347,961 1,376,895 Investment Earnings 9,176 1,193 1,000 2,250 1,250 1,250 1,250 1,250 1,250 Reimbursements 2,360 1,264 200,000 208,125 200,000 200,000 200,000 200,000 200,000 Other Financing Sources 1,243,972 1,134,654 1,134,052 1,134,052 1,137,166 1,13 3,782 1,134,114 1,13 7,948 1,137,948 Total Revenue 2,442,221 2,526,917 2,534,994 2,603,027 2,604,442 2,627,629 2,655,234 2,687,159 2,716,093 Expenses Salaries 187,301 205,371 216,289 215,289 223,555 230,202 237,048 244,099 251,362 Benefits 92,443 104,560 110,254 109,361 115,847 123,162 131,358 140,148 149,547 Contractual Services 164,251 177,716 119,463 82,230 152,882 135,386 138,005 140,155 143,022 Supplies 38,300 38,924 84,206 45,471 54,908 56,571 58,348 60,245 62,271 Capital Outlay 808,520 284,509 460,282 431,916 472,435 611,575 504,655 459,015 459,015 Developer Commitments 62,922 32,890 33,872 33,872 34,888 35,939 28,204 - - Debt Service 2,054,461 1,865,399 1,865,857 1,865,857 1,877,110 1,880,265 1,352,307 1,300,798 1,300,798 Other Financing Uses 83,588 76,275 75,075 75,075 73,875 77,675 73,875 75,125 75,125 Total Expenses 3,491,786 2,785,644 2,965,298 2,859,071 3,005,500 3,150,775 2,523,800 2,419,585 2,441,140 Surplus(Deficit) (1,049,565) (258,727) (430,304) (256,044) (401,058) (523,146) 131,434 267,574 274,953 Ending Fund Balance Equivalent 1,829,603 1,570,874 977,023 1,314,830 913,772 390,626 522,060 789,634 1,064,587 52.40% 56.39% 32.95% 45.99% 30.40% 12.40% 20.69% 32.64% 43.61 „ $2,000 Fund Balance Equivalent $1,500 0 g $1,000 $500 $0 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Sewer-52 52-000-42-00-4216 BUILD PROGRAM PERMITS 35,000 76,600 - - - - - - - 52-000-42-00-4224 RENEW PROGRAM PERMITS - 750 - - - - - - - 52-000-44-00-4435 SEWER MAINTENANCE FEES 790,556 821,802 837,942 862,000 882,526 909,097 936,370 964,461 993,395 52-000-44-00-4440 SEWER INFRASTRUCTURE FEE 341,199 345,416 340,000 352,000 345,000 345,000 345,000 345,000 345,000 52-000-44-00-4455 SW CONNECTION FEES-OPERATIONS 600 15,200 2,000 18,500 15,000 15,000 15,000 15,000 15,000 52-000-44-00-4456 SW CONNECTION FEES-CAPITAL 5,400 114,750 7,000 11,500 10,000 10,000 10,000 10,000 10,000 52-000-44-00-4462 LATE PENALTIES-SEWER 13,634 13,740 13,000 13,500 13,500 13,500 13,500 13,500 13,500 52-000-44-00-4465 RIVER CROSSING FEES 324 1,548 - 1,100 - - - - - 52-000-45-00-4500 INVESTMENT EARNINGS 5,427 1,193 1,000 2,250 1,250 1,250 1,250 1,250 1,250 52-000-45-00-4550 GAIN ON INVESTMENT 3,749 - - - - - - - - 52-000-46-00-4625 REIMB-I&I REDUCTIONS - - 200,000 200,000 200,000 200,000 200,000 200,000 200,000 52-00046-00-4690 REIMB-MISCELLANEOUS 2,360 1,264 - 8,125 - - - - - 52-000-49-00-4901 TRANSFER FROM GENERAL 1,133,972 1,134,654 1,134,052 1,134,052 1,137,166 1,133,782 1,134,114 1,137,948 1,137,948 52-000-49-004910 SALE OF CAPITAL ASSETS 110,000 Revenue 2,442,221 2„526,917 2,534,994 2,603,027 2,604,442 2,627,629 2,655,234 2,687,159 2,716,093 Sewer Operations 52-520-50-00-5010 SALARIES&WAGES 187,220 205,240 214,289 214,289 221,555 228,202 235,048 242,099 249,362 52-520-50-00-5020 OVERTIME 81 131 2,000 1,000 2,000 2,000 2,000 2,000 2,000 52-520-52-00-5212 RETIREMENT PLAN CONTRIBUTION 21,410 22,403 23,359 23,359 24,405 25,783 27,616 29,585 31,672 52-520-52-00-5214 FICA CONTRIBUTION 14,093 15,474 16,175 16,175 16,613 17,111 17,624 18,153 18,698 52-520-52-00-5216 GROUP HEALTH INSURANCE 40,589 48,364 51,144 51,144 54,530 58,892 63,603 68,691 74,186 52-520-52-00-5222 GROUP LIFE INSURANCE 328 409 371 371 371 375 379 383 387 52-520-52-00-5223 DENTALINSURANCE 3,215 4,159 4,658 4,370 4,585 4,814 5,055 5,308 5,573 52-520-52-00-5224 VISION INSURANCE 407 552 552 552 568 585 603 621 640 52-520-52-00-5230 UNEMPLOYMENT INSURANCE 376 941 1,000 395 1,000 1,000 1,000 1,000 1,000 52-520-52-00-5231 LIABILITY INSURANCE 12,025 12,258 12,995 12,995 13,775 14,602 15,478 16,407 17,391 52-520-54-00-5401 ADMINISTRATIVE CHARGEBACK - - - - 38,925 40,093 41,296 42,535 43,811 52-520-54-00-5405 BUILD PROGRAM 35,000 76,600 - - - - - - - 52-520-54-00-5406 RENEW PROGRAM - 750 - - - - - - - 52-520-54-00-5412 TRAINING&CONFERENCES 1,504 1,515 3,300 2,500 3,300 3,300 3,300 3,300 3,300 52-520-54-00-5415 TRAVEL&LODGING 240 1,232 500 2,000 2,000 2,000 2,000 2,000 2,000 52-520-54-00-5430 PRINTING&DUPLICATING 30 1,265 1,700 1,250 1,500 1,500 1,500 1,500 1,500 52-520-54-00-5440 TELECOMMUNICATIONS 1,895 2,398 2,500 2,500 2,500 2,500 2,500 2,500 2,500 52-520-54-00-5444 LIFT STATION SERVICES 8,589 5,898 37,433 8,000 30,000 10,000 10,000 10,000 10,000 52-520-54-00-5462 PROFESSIONAL SERVICES 6,861 8,615 8,000 15,000 16,000 16,000 16,000 16,000 16,000 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected 52-520-54-00-5480 UTILITIES 20,258 19,100 31,800 21,000 22,260 23,596 25,012 26,513 28,104 52-520-54-00-5485 RENTAL&LEASE PURCHASE 504 766 1,000 750 1,000 1,000 1,000 1,000 1,000 52-520-54-00-5488 OFFICE CLEANING - - - - 4,167 4,167 4,167 4,167 4,167 52-520-54-00-5489 LOSS ON INVESTMENT 75,369 - - _ _ _ _ _ _ 52-520-54-00-5490 VEHICLE MAINTENANCE SERVICES 4,447 5,437 12,000 8,000 10,000 10,000 10,000 10,000 10,000 52-520-54-00-5495 OUTSIDE REPAIR&MAINTENCE 6,512 51,366 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,277 2,980 2,980 2,980 2,980 2,980 2,390 2,390 52-520-54-00-5499 BAD DEBT 1,765 1,497 2,250 2,250 2,250 2,250 2,250 2,250 2,250 52-520-56-00-5600 WEARING APPAREL 2,585 3,441 2,756 3,150 3,308 3,473 3,647 3,829 4,020 52-520-56-00-5610 OFFICE SUPPLIES 517 569 2,000 750 1,000 1,000 1,000 1,000 1,000 52-520-56-00-5613 LIFT STATION MAINTENANCE 5,012 5,584 12,000 6,000 8,000 8,000 8,000 8,000 8,000 52-520-56-00-5620 OPERATING SUPPLIES 4,828 6,621 5,000 5,300 5,500 5,500 5,500 5,500 5,500 52-520-56-00-5628 VEHICLE MAINTENANCE SUPPLIES 1,315 2,697 2,000 2,000 2,000 2,000 2,000 2,000 2,000 52-520-56-00-5630 SMALL TOOLS&EQUIPMENT 1,109 1,848 2,500 2,000 2,500 2,500 2,500 2,500 2,500 52-520-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 259 - 1,200 1,271 1,200 1,200 1,200 1,200 1,200 52-520-56-00-5640 REPAIR&MAINTENANCE 1,301 4,290 30,000 5,000 10,000 10,000 10,000 10,000 10,000 52-520-56-00-5695 GASOLINE 21,374 13,874 26,750 20,000 21,400 22,898 24,501 26,216 28,051 52-520-60-00-6025 ROAD TO BETTER ROADS PROGRAM 251,677 225,494 200,000 165,000 200,000 200,000 200,000 200,000 200,000 52-520-60-00-6028 SANITARY SEWER LINING 98,029 - 200,000 200,000 200,000 200,000 200,000 200,000 200,000 52-520-60-00-6059 US 34(11,47/ORCHARD RD)PROJECT - - 1,267 - 10,000 10,000 10,000 - - 52-520-60-00-6066 RTE 71 SANITARY SEWER REPLACEMENT - - - 7,901 3,420 142,560 35,640 - - 52-520-60-00-6070 VEHICLES 379,986 - - - - - - - - 52-520-60-00-6079 ROUTE 47 EXPANSION 78,828 59,015 59,015 59,015 59,015 59,015 59,015 59,015 59,015 52-520-75-00-7500 LENNAR-RAINTREE SEWER RECPATURE 62,922 32,890 33,872 33,872 34,888 35,939 28,204 - - Debt Service-2004B Bond 52-520-84-00-8000 PRINCIPAL PAYMENT 375,000 395,000 410,000 410,000- 435,000 455,000 - - - 52-520-84-00-8050 INTEREST EXPENSE 78,950 65,825 52,000 52,000 35,600 18,200 - - - Debt Service-2003A IRBB Debt Certificates 52-520-90-00-8000 PRINCIPAL PAYMENT 105,000 110,000 115,000 115,000 120,000 130,000 135,000 140,000 140,000 52-520-90-00-8050 INTEREST EXPENSE 57,648 52,870 47,755 47,755 42,293 36,233 29,668 22,850 22,850 Debt Service-2004A Debt Certificates 52-520-91-00-8000 PRINCIPAL PAYMENT 190,000 - - - - - - - _ 52-520-91-00-8050 INTEREST EXPENSE 6,840 - - - - - _ Debt Service-2011 Refunding Bond 52-520-92-00-8000 PRINCIPAL PAYMENT 685,000 715,000 745,000 745,000 780,000 810,000 845,000 885,000 885,000 52-520-92-00-8050 INTEREST EXPENSE 448,972 419,654 389,052 389,052 357,166 323,782 289,114 252,948 252,948 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Debt Service-IEPA Loan L17-115300 52-520-96-00-8000 PRINCIPAL PAYMENT 93,355 95,821 98,353 98,353 100,952 103,619 52,832 - - 52-520-96-00-8050 INTEREST EXPENSE 13,696 11,229 8,697 8,697 6,099 3,431 693 - - 52-520-99-00-9951 TRANSFER TO WATER 83,588 76,275 75,075 75,075 73,875 77,675 73,875 75,125 75,125 Expenses 3,491,786 2,785,644 2,965,298 2,859,071 3,005,500 3,150,775 2,523,800 2,419,585 2,441,140 Surplus(Deficit) (1,049,565) (2.58,727) (430,304) (2.56,044) (401,058) (523,146) 131,434 267,574 274,953 Fund Balance Equiv 1,829,603 1,570,874 977,023 1,314,830 913,772 390,626 522,060 789,634 1,064,587 52.40% 56.39% 32.95% 45.99% 30.40% 12.40% 20.69% 32.64% 43.61% 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. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Revenue Intergovernmental 40,144 - 400,000 - - 400,000 400,000 - - Licenses&Permits 8,407 3,570 - - - - - - - Land Cash Contributions 40,997 121,962 39,000 144,097 88,000 8,000 56,000 6,000 6,000 Reimbursements 83,311 - 50,000 61,278 - - - - - Miscellaneous 14 - - - - - - - - Other Financing Sources - - - 2,500 2,500 - - - - Total Revenue 172,873 125,532 489,000 207,875 90,500 408,000 456,000 6,000 6,000 Expenditures Contractual Services 8,407 3,570 - - - - - - - Capital Outlay 235,021 27,074 453,855 91,612 362,355 437,354 50,000 - - Total Expenditures 243,428 30,644 453,855 91,612 362,355 437,354 50,000 - - Surplus(Deficit) (70,555) 94,888 35,145 116,263 (271,855) (29,354) 406,000 6,000 6,000 Ending Fund Balance 117,430 212,318 220,320 328,581 56,726 27,372 433,372 439,372 445,372 Fund Balance $500 V $400 -� c $300 r $200 $100 $0 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Land Cash-72 72-000-41-00-4174 RTP GRANT-CLARK PARK 40,144 - - - - - - - - 72-000-41-00-4175 OSLAD GRANT-RNERFRONT PARK - - 400,000 - - - 400,000 - - 72-000-41-00-4186 OSLAD GRANT-BRISTOL BAY - - - - - 400,000 - - - 72-000-42-004216 BUILD PROGRAM PERMITS 8,407 3,570 - - - - - - 72-000-46-00-4655 REIMB-GRANDE RESERVE PARK 83,311 - 50,000 61,278 - - - - - 72-000-47-004701 WHITE OAK 1,406 - - - - - - - - 72-000-47-004703 AUTUMN CREEK 30,320 34,125 30,000 30,000 30,000 - - - - 72-000-47-00-4704 BLACKBERRY WOODS 7,386 9,659 5,000 7,000 6,000 6,000 6,000 6,000 6,000 72-000-47-00-4706 CALEDONIA - - - 2,013 - - 50,000 - - 72-000-47-00-4708 COUNTRY HILLS - 5,383 2,000 4,614 - - - - 72-000-47-00-4711 FOX HIGHLANDS DETENTION - 1,406 - _ 72-000.47-00-4713 PRESTWICK - 67,600 - - - - - - - 72-000-47-00-4722 GC HOUSING(ANTHONY'S PLACE) - - - 97,162 - - - - - 72-00047-00-4723 WINDETT RIDGE - - - - 50,000 - - - - 72-000-47-00-4736 BRIARWOOD 1,885 3,789 2,000 3,308 2,000 2,000 - - - 72-000-48-00-4850 MISCELLANEOUS INCOME 14 - - - - - - - - 72-00049-00-4910 SALE OF CAPITAL ASSETS 2,500 2,500 Revenue 172,873 125,532 489,000 207,875 90,500 408,000 456,000 6,000 6,000 72-720-54-00-5405 BUILD PROGRAM 8,407 3,570 - - - - - - - 72-720-60-00-6029 CALEDONIA PARK - - - - - - 50,000 - - 72-720-60-00-6032 MOSER HOLDING COSTS - 12,000 13,000 8,612 - - - - - 72-720-60-00-6043 BRISTOL BAY REGIONAL PARK 32,434 - - - 183,783 183,783 - - - 72-720-60-00-6044 CLARK PARK 20,661 - - - - - - - - 72-720-60-00-6045 RIVERFRONTPARK 29,495 5,362 365,855 8,000 178,572 178,571 - - - 72-720-60-00-6046 GRANDE RESERVE PARK A 380 9,562 75,000 75,000 - - - - - 72-720-60-00-6047 GRANDE RESERVE PARK B 146,021 150 - - - - - - - 72-720-60-00-6067 BLACKBERRY CREEK NATURE PRESERVE 6,030 - - - 25,000 - - - 72-720-60-00-6069 WINDETT RIDGE PARK 50,000 Expenditures 243,428 30,644 453,855. 91,612 362,355 437,3.54 50,000 - - Surplus(Deficit) (70,555) 94,888 35,145 116,263 (271,855) (29,354) 406,000 6,000 6,000 Fund Balance 117,430 212,318 220,320 328,581 56,726 27,372 433,372 439,372 445,372 Parks and Recreation Fund(79) This fund accounts for the daily operations of the Parks and Recreation Department. Programs,classes,special events and maintenance of City wide park land and public facilities make up the day to day operations. Programs and classes consist of a wide variety of options serving children through senior citizens. Special events range from Music Under the Stars to Home Town Days. City wide maintenance consists of over two hundred acres at more than fifty sites including buildings,boulevards,parks,utility locations and natural areas. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Revenue Charges for Service 352,714 408,469 355,000 435,000 395,000 395,000 395,000 395,000 395,000 Investment Earnings 698 369 350 350 350 350 350 350 350 Reimbursements 7,502 12,890 - 241 - - - - - Miscellaneous 177,755 219,704 181,000 204,100 196,000 196,000 196,000 196,000 196,000 Other Financing Sources 1,277,606 1,076,831 1,118,638 1,118,638 1,308,583 1,461,577 1,498,713 1,564,103 1,630,258 Total Revenue 1,816,275 1,718,263 1,654,988 1,758,329 1,899,933 2,052,927 2,090,063 2,155,453 2,221,608 Expenditures Salaries 775,138 723,194 816,544 826,000 903,518 926,408 949,985 974,269 999,282 Benefits 338,380 325,538 385,075 387,961 453,922 476,776 509,931 545,565 583,774 Contractual Services 374,840 251,733 260,710 319,386 274,220 274,983 275,792 276,650 277,559 Supplies 316,864 474,571 334,666 351,769 345,651 364,897 348,225 349,640 351,148 Total Expenditures 1,805,222 1,775,036 1,796,995 1,885,116 1,977,311 2,043,064 2,083,933 2,146,124 2,211,763 Surplus(Deficit) 11,053 (56,773) (142,007) (126,787) (77,378) 9,863 6,130 9,329 9,845 Ending Fund Balance 557,536 500,762 269,255 373,975 296,597 306,460 312,590 321,919 331,764 30.88% 28.21% 14.98% 19.84% 15.00% 15.00% 15.00% 15.00% 15.00% N $600 Fund Balance $400 0 $200 $0 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Parks and Recreation-79 79-000-44-00-4402 SPECIAL EVENTS 72,025 100,756 80,000 105,000 85,000 85,000 85,000 85,000 85,000 79-000-44-00-4403 CHILD DEVELOPMENT 103,683 110,861 100,000 130,000 120,000 120,000 120,000 120,000 120,000 79-000-44-00-4404 ATHLETICS&FITNESS 147,481 163,420 145,000 170,000 160,000 160,000 160,000 160,000 160,000 79-000-44-00-4441 CONCESSION REVENUE 29,525 33,432 30,000 30,000 30,000 30,000 30,000 30,000 30,000 79-000-45-00-4500 INVESTMENT EARNINGS 698 369 350 350 350 350 350 350 350 79-00046-00-4690 REIMB-MISCELLANEOUS 7,502 12,890 - 241 - - - - - 79-000-48-00-4820 RENTAL INCOME 44,860 50,921 50,000 51,845 50,000 50,000 50,000 50,000 50,000 79-000-48-00-4825 PARK RENTALS 28,928 19,602 5,000 12,254 15,000 15,000 15,000 15,000 15,000 79-000-48-00-4843 HOMETOWN DAYS 88,475 106,579 108,000 117,354 108,000 108,000 108,000 108,000 108,000 79-00048-00-4846 SPONSORSHIPS&DONATIONS 9,317 18,917 15,000 19,647 20,000 20,000 20,000 20,000 20,000 79-000-48-00-4850 MISCELLANEOUS INCOME 6,175 23,685 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-000-49-00-4901 TRANSFER FROM GENERAL 1,277,606 1,076,831 1,118,638 1,118,638 1,308,583 1,461,577 1,498,713 1,564,103 1,630,258 Revenue 1,816,275 1,718,263 1,654,988 1,758,329 1,899,933 2,052,927 2,090,063 2,155,453 2,221,608 Parks Department 79-790-50-00-5010 SALARIES&WAGES 448,491 387,634 405,322 430,000 459,839 473,634 487,843 502,478 517,552 79-790-50-00-5015 PART-TIME SALARIES 32,644 24,382 40,178 38,000 45,000 45,000 45,000 45,000 45,000 79-790-50-00-5020 OVERTIME 932 1,884 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-790-52-00-5212 RETIREMENT PLAN CONTRIBUTION 51,195 41,923 44,098 47,000 52,224 53,383 57,183 61,264 65,590 79-790-52-00-5214 FICA CONTRIBUTION 36,172 30,890 33,797 35,000 37,601 38,729 39,891 41,088 42,321 79-790-52-00-5216 GROUP HEALTH INSURANCE 109,775 102,203 126,121 126,121 163,947 177,063 191,228 206,526 223,048 79-790-52-00-5222 GROUP LIFE INSURANCE 942 790 724 884 808 816 824 832 840 79-790-52-00-5223 DENTAL INSURANCE 8,959 7,978 9,119 8,288 10,883 11,427 11,998 12,598 13,228 79-790-52-00-5224 VISION INSURANCE 940 947 1,023 1,000 1,250 1,288 1,327 1,367 1,408 79-790-54-00-5412 TRAINING&CONFERENCES 3,045 2,136 7,000 4,000 7,000 7,000 7,000 7,000 7,000 79-790-54-00-5415 TRAVEL&LODGING 453 85 3,000 1,000 3,000 3,000 3,000 3,000 3,000 79-790-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK 109,650 - - 53,908 - - - - - 79-790-54-00-5440 TELECOMMUNICATIONS 3,776 5,312 3,510 6,000 6,000 6,000 6,000 6,000 6,000 79-790-54-00-5462 PROFESSIONAL SERVICES 4,229 7,206 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-790-54-00-5466 LEGAL SERVICES 12,084 5,415 6,000 4,000 6,000 6,000 6,000 6,000 6,000 79-790-54-00-5485 RENTAL&LEASE PURCHASE 1,192 2,461 - 2,500 3,000 2,500 2,500 2,500 2,500 2,500 79-790-54-00-5488 OFFICE CLEANING - - - - - 6,250 6,250 6,250 6,250 6,250 79-790-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 41,995 36,800 47,500 23,500 50,000 50,000 50,000 50,000 50,000 79-790-56-00-5600 WEARING APPAREL 4,643 5,759 5,182 5,182 5,441 5,713 5,999 6,299 6,614 79-790-56-00-5610 OFFICE SUPPLIES 85 347 300 300 300 300 300 300 300 79-790-56-00-5620 OPERATING SUPPLIES 18,295 146,681 22,500 22,500 25,000 25,000 25,000 25,000 25,000 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected 79-790-56-00-5630 SMALL TOOLS&EQUIPMENT 9,081 5,518 4,500 2,500 4,500 4,500 4,500 4,500 4,500 79-790-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 2,000 2,000 500 2,000 2,000 20,000 2,000 2,000 2,000 79-790-56-00-5640 REPAIR&MAINTENANCE 60,514 64,517 56,000 56,000 56,000 56,000 56,000 56,000 56,000 79-790-56-00-5695 GASOLINE 17,283 11,694 21,400 12,000 12,840 13,739 14,701 15,730 16,831 978,375 894,562 846,274 888,183 964,383 1,013,342 1,030,544 1,067,732 1,106,982 Recreation Department 79-795-50-00-5010 SALARIES&WAGES 240,199 261,071 280,333 287,000 303,179 312,274 321,642 331,291 341,230 79-795-50-00-5015 PART-TIME SALARIES 11,439 6,537 22,711 11,000 25,000 25,000 25,000 25,000 25,000 79-795-50-00-5045 CONCESSION WAGES 8,625 7,549 15,000 10,000 15,000 15,000 15,000 15,000 15,000 79-795-50-00-5046 PRE-SCHOOL WAGES 24,223 23,902 25,000 35,000 37,500 37,500 37,500 37,500 37,500 79-795-50.00-5052 INSTRUCTORS WAGES 8,585 10,235 25,000 12,000 15,000 15,000 15,000 15,000 15,000 79-795-52-00-5212 RETIREMENT PLAN CONTRIBUTION 28,192 28,362 32,976 32,976 38,272 34,975 37,471 40,152 42,995 79-795-52-00-5214 FICA CONTRIBUTION 21,830 23,119 28,068 28,068 29,305 30,184 31,090 32,023 32,984 79-795-52-00-5216 GROUP HEALTH INSURANCE 74,560 83,005 101,075 101,075 111,170 120,064 129,669 140,043 151,246 79-795-52-00-5222 GROUP LIFE INSURANCE 551 618 559 450 529 534 539 544 549 79-795-52-00-5223 DENTALINSURANCE 4,731 4,987 6,716 6,300 7,070 7,424 7,795 8,185 8,594 79-795-52-00-5224 VISION INSURANCE 533 716 799 799 863 889 916 943 971 79-795-54-00-5412 TRAINING&CONFERENCES 3,543 3,481 5,000 4,000 5,000 5,000 5,000 5,000 5,000 79-795-54-00-5415 TRAVEL&LODGING 217 354 3,000 2,000 3,000 3,000 3,000 3,000 3,000 79-795-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK - - - 19,978 - - - - - 79-795-54-00-5426 PUBLISHING&ADVERTISING 42,314 49,207 45,000 50,000 50,000 50,000 50,000 50,000 50,000 79.795-54-00.5440 TELECOMMUNICATIONS 6,603 7,231 8,000 7,500 8,000 8,000 8,000 8,000 8,000 79-795-54-00-5447 SCHOLARSHIPS 420 121 2,500 1,500 2,500 2,500 2,500 2,500 2,500 79-795-54-00-5452 POSTAGE&SHIPPING 2,964 1,008 3,500 3,000 3,500 3,500 3,500 3,500 3,500 79-795-54-00-5460 DUES&SUBSCRIPTIONS 1,917 1,231 2,500 3,000 2,500 2,500 2,500 2,500 2,500 79-795-54-00-5462 PROFESSIONAL SERVICES 81,047 94,358 80,000 100,000 90,000 90,000 90,000 90,000 90,000 79-795-54-00-5480 UTILITIES 15,413 10,596 21,200 12,000 12,720 13,483 14,292 15,150 16,059 79-795-54-00-5485 RENTAL&LEASE PURCHASE 3,602 3,019 4,500 3,000 4,000 4,000 4,000 4,000 4,000 79-795-54-00-5488 OFFICE CLEANING - - - - 6,250 6,250 6,250 6,250 6,250 79-795-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 8,580 6,770 3,000 2,500 3,000 3,000 3,000 3,000 3,000 79-795-54-00-5496 PROGRAM REFUNDS 9,819 14,942 10,000 12,500 - - - - - 79-795-54-00-5497 PROPERTY TAX PAYMENT 21,977 - - - - - - - - 79-795-56-00-5602 HOMETOWN DAYS SUPPLIES 85,480 94,845 100,000 96,287 100,000 100,000 100,000 100,000 100,000 79-795-56-00-5606 PROGRAM SUPPLIES 89,074 108,100 86,000 122,000 100,000 100,000 100,000 100,000 100,000 79-795-56-00-5607 CONCESSION SUPPLIES 15,812 19,299 18,000 15,000 18,000 18,000 18,000 18,000 18,000 79-795-56-00-5610 OFFICE SUPPLIES 3,406 2,212 3,000 2,000 3,000 3,000 3,000 3,000 3,000 79-795-56-00-5620 OPERATING SUPPLIES 8,086 11,373 13,500 12,500 15,000 15,000 15,000 15,000 15,000 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected 79-795-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - 399 500 500 500 500 500 500 500 79-795-56-00-5640 REPAIR&MAINTENANCE 2,101 1,009 2,000 2,000 2,000 2,000 2,000 2,000 2,000 79-795-56-00-5695 GASOLINE 1,004 818 1,284 1,000 1,070 1,145 1,225 1,311 1,403 826,847 880,474 950,721 996,933 1,012,928 1,029,722 1,053,389 1,078,392 1,104,781 Expenditures 1,805,222 1,775,036 1,796,995 1,885,116 1,977,311 2,043,064 2,083,933 2,146,124 2,211,763 Surplus(Deficit) 11,053 (56,773) (142,007) (126,787) (77,378) 9,863 6,130 9,329 9,845 Fund Balance 557,536 500,762 269,255 373,975 296,597 306,460 312,590 321,919 331,764 30.88% 28.21% 14.98% 19.84% 15.00% 15.00% 15.00% 15.00% 15.00% 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. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Revenue Taxes 626,950 622,529 644,719 626,183 645,867 658,784 671,960 685,399 699,107 Intergovernmental 26,934 26,475 22,450 18,294 22,450 22,450 22,450 22,450 22,450 Fines&Forfeits 8,356 8,081 9,300 7,620 8,000 8,000 8,000 8,000 8,000 Charges for Service 10,841 9,191 11,500 10,008 10,000 10,000 10,000 10,000 10,000 Investment Earnings 1,279 436 350 924 800 800 800 800 800 Reimbursements 13,174 - - 2,141 - - - - - Miscellaneous 6,762 5,240 7,500 6,692 5,500 5,500 5,500 5,500 5,500 Other Financing Sources 25,189 25,928 36,068 25,225 27,236 28,810 30,479 32,248 34,123 Total Revenue 719,485 697,880 7319887 697,087 719,853 734,344 749,189 764,397 779,980 Expenditures Salaries 400,069 391,904 419,134 411,500 473,828 473,828 473,828 473,828 473,828 Benefits 157,525 151,698 181,638 161,483 182,877 191,873 201,547 211,951 223,142 Contractual Services 145,651 94,596 129,171 109,389 141,880 142,389 142,928 143,500 144,106 Supplies 17,144 23,907 24,000 26,849 31,000 31,000 31,000 31,000 31,000 Other Financing Uses 3,487 3,102 3,000 6,652 3,000 3,000 3,000 3,000 3,000 Total Expenditures 723,876 665,207 756,943 715,873 832,585 842,090 852,303 863,279 875,076 Surplus(Deficit) (4,391) 32,673 (25,056) (18,786) (112,732) (107,746) (103,114) (98,882) (95,096) Ending Fund Balance 466,683 499,355 435,726 480,569 367,837 260,091 156,977 58,095 (37,001) 64.47% 75.07% 57.56% 67.13% 44.18% 30.89% 18.42% 6.73% -4.23% Fund Balance $600 $500 $400 t $300 $200 $100 $0 ($100) FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Library Operations 82-000-40-00-4000 PROPERTY TAXES 626,950 622,529 644,719 626,183 645,867 658,784 671,960 685,399 699,107 82-000-41-00-4120 PERSONAL PROPERTY TAX 5,783 5,324 5,250 5,250 5,250 5,250 5,250 5,250 5,250 82-000-41-00-4170 STATE GRANTS 21,151 21,151 17,200 13,044 17,200 17,200 17,200 17,200 17,200 82-00043-00-4330 LIBRARY FINES 8,356 8,081 9,300 7,620 8,000 8,000 8,000 8,000 8,000 82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 6,647 6,038 7,500 6,588 6,500 6,500 6,500 6,500 6,500 82-000-44-00-4422 COPY FEES 3,095 2,283 3,000 2,484 2,500 2,500 2,500 2,500 2,500 82-000-44-00-4439 PROGRAM FEES 1,099 870 1,000 936 1,000 1,000 1,000 1,000 1,000 82-000-45-00-4500 INVESTMENT EARNINGS 816 436 350 924 800 800 800 800 800 82-000-45-00-4550 GAIN ON INVESTMENT 463 - - - - - - - - 82-000-46-00-4690 REIMB-MISCELLANEOUS 13,174 - - 2,141 - - - - - 82-000-48-00-4820 RENTAL INCOME 1,851 1,942 2,000 2,328 2,000 2,000 2,000 2,000 2,000 82-000-48-00-4824 DVD RENTAL INCOME 3,923 2,454 5,000 2,364 2,500 2,500 2,500 2,500 2,500 82-000-48-00-4850 MISCELLANEOUS INCOME 988 844 500 2,000 1,000 1,000 1,000 1,000 1,000 82-000-49-00-4901 TRANSFER FROM GENERAL 25,189 25,928 36,068 25,225 27,236 28,810 30,479 32,248 34,123 Revenue 719,48.5 697,880 731,887 697,087 719,853 734,344 749,189 764,397 779,980 82-820-50-00-5010 SALARIES&WAGES 210,198 201,312 217,309 213,500 223,828 223,828 223,828 223,828 223,828 82-820-50-00-5015 PART-TIME SALARIES 189,871 190,592 201,825 198,000 250,000 250,000 250,000 250,000 250,000 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 23,897 21,767 23,470 23,470 24,435 24,435 24,435 24,435 24,435 82-820-52-00-5214 FICA CONTRIBUTION 29,991 29,361 31,448 31,448 35,587 35,587 35,587 35,587 35,587 82-820-52-00-5216 GROUP HEALTH INSURANCE 72,838 68,514 83,960 75,000 88,996 96,116 103,805 112,109 121,078 82-820-52-00-5222 GROUP LIFE INSURANCE 427 443 403 403 403 407 411 415 419 82-820-52-00-5223 DENTAL INSURANCE 4,728 5,034 5,638 5,286 5,550 5,828 6,119 6,425 6,746 82-820-52-00-5224 VISION INSURANCE 455 651 651 651 670 690 711 732 754 82-820-52-00-5230 UNEMPLOYMENT INSURANCE - 420 2,500 474 1,000 1,000 1,000 1,000 1,000 82-820-52-00-5231 LIABlLITYINSURANCE 25,189 25,508 33,568 24,751 26,236 27,810 29,479 31,248 33,123 82-820-54-00-5412 TRAINING&CONFERENCES 133 249 500 500 500 500 500 500 500 82-820-54-00-5415 TRAVEL&LODGING 514 262 600 600 600 600 600 600 600 82-820-54-00-5421 PPRT TAX REBATE - 678 - - - - - - - 82-820-54-00-5426 PUBLISHING&ADVERTISING 47 23 100 100 100 100 100 100 100 82-820-54-00-5440 TELECOMMUNICATIONS 11,468 6,007 6,000 6,000 6,000 6,000 6,000 6,000 6,000 82-820-54-00-5452 POSTAGE&SHIPPING 455 494 500 500 500 500 500 500 500 82-820-54-00-5460 DUES&SUBSCRIPTIONS 9,934 9,560 12,000 12,000 12,000 12,000 12,000 12,000 12,000 82-820-54-00-5462 PROFESSIONAL SERVICES 28,610 31,278 29,000 29,000 40,000 40,000 40,000 40,000 40,000 82-820-54-00-5466 LEGAL SERVICES 975 - 2,000 1,000 2,000 2,000 2,000 2,000 2,000 82-820-54-00-5468 AUTOMATION 24,923 17,890 35,000 20,000 20,000 20,000 20,000 20,000 20,000 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected 82-820-54-00-5480 UTILITIES 11,518 6,504 16,281 8,000 8,480 8,989 9,528 10,100 10,706 82-820-54-00-5489 LOSS ON INVESTMENT 9,300 - - - - - - - - 82-820-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 46,085 19,962 25,000 30,000 50,000 50,000 50,000 50,000 50,000 82-820-54-00-5498 PAYING AGENT FEES 1,689 1,689 2,190 1,689 1,700 1,700 1,700 1,700 1,700 82-820-56-00-5610 OFFICE SUPPLIES 5,257 9,240 8,000 8,000. 8,000 8,000 8,000 8,000 8,000 82-820-56-00-5620 OPERATING SUPPLIES 9,338 11,210 8,000 10,000 10,000 10,000 10,000 10,000 10,000 82-820-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - - - - - - - 82-820-56-00-5671 LIBRARY PROGRAMMING 1,209 1,030 1,000 1,000 1,000 1,000 1,000 1,000 1,000 82-820-56-00-5676 EMPLOYEE RECOGNITION - - - - - - - - - 82-820-56-00-5684 COMPACT DISCS&OTHER MUSIC - - - - - - - - - 82-820-56-00-5685 DVD'S 1,340 2,427 2,000 2,000 2,000 2,000 2,000 2,000 2,000 82-820-56-00-5686 BOOKS - - 5,000 5,849 10,000 10,000 10,000 10,000 10,000 82-820-99-00-9983 TRANSFER TO LIBRARY DEBT SERVICE 3,487 3,102 3,000 6,652 3,000 3,000 3,000 3,000 3,000 Expenditures 723,876 66.5,207 756,943 71.5,873 832,58.5 842,090 852,303 863,279 875,076 Surplus(DeBcit) (4,391) 32,673 (25,056) (18,786) (112,732) (107,746) (103,114) (98,882) (95,096) Fund Balance 466,683 499,355 435,726 480,569 367,837 260,091 156,977 58,095 (37,001) 64.47% 75.07% 57.56% 67.13% 44.18% 30.89% 18.42% 6.73% -4.23% Library Debt Service Fund(83) The Library Debt Service Fund accumulates monies for payment of the 2006 and 2013 refinancing bonds,which were issued to finance construction of the Library building. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Revenue Taxes 727,762 746,621 749,771 745,908 757,396 789,101 794,013 824,088 824,088 Investment Earnings 72 123 - 211 - - - - - Other Financing Sources 3,487 3,102 3,000 6,652 3,000 3,000 3,000 3,000 3,000 Total Revenue 731,321 749,846 752,771 752,771 760,396 792,101 797,013 827,088 827,088 Expenditures Debt Service 731,321 749,846 752,771 752,771 760,396 792,101 797,013 827,088 827,088 Total Expenditures 731,321 749,846 752,771 752,771 760,396 792,101 797,013 827,088 827,088 Surplus(Deficit) - - - - - - - - - Ending Fund Balance - - - - - - - - - $1 Fund Balance $1 $1 $0 $0 $0 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted .Projected Proposed Projected Projected Projected Projected Library Debt Service 83-00040-00-4000 PROPERTY TAXES 727,762 746,621 749,771 745,908 757,396 789,101 794,013 824,088 824,088 83-000-45-00-4500 INVESTMENT EARNINGS 72 123 - 211 - - - - - 83-000-49-00-4982 TRANSFER FROM LIBRARY OPS 3,487 3,102 3,000 6,652 3,000 3,000 3,000 3,000 3,000 Revenue 731,321 749,846 752,771 752,771 760,396 792,101 797,013 827,088 827,088 Debt Service-2006 Bond 83-830-84-00-8000 PRINCIPAL PAYMENT 50,000 50,000 50,000 50,000 50,000 50,000 50,000 75,000 75,000 83-830-84-00-8050 INTEREST PAYMENT 34,488 32,113 29,738 29,738 27,363 24,988 22,613 20,238 20,238 Debt Service-2013 Refunding Bond 83-830-99-00-8000 PRINCIPAL PAYMENT 455,000 485,000 500,000 500,000 520,000 565,000 585,000 610,000 610,000 83-830-99-00-8050 INTEREST PAYMENT 191,833 182,733 173,033 173,033 163,033 152,113 139,400 121,850 121,850 Expenditures 731,321 749,846 752,771 752,771 760,396 792,101 797,013 827,088 827,088 Surplus(Deficit) - - - - - - - - - Fund Balance - - - - - - - - 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. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Revenue Licenses&Permits 25,325 36,100 20,000 50,000 35,000 35,000 35,000 35,000 35,000 Investment Earnings 11 8 10 10 10 10 10 10 10 Miscellaneous 13 10 - - - - - - - Total Revenue 25,349 36,118 20,010 50,010 35,010 35,010 35,010 35,010 35,010 Expenditures Contractual Services 3,093 4,258 3,500 3,500 3,500 3,500 3,500 3,500 3,500 Supplies 36,412 29,768 8,395 36,608 31,500 31,510 31,510 31,510 31,510 Total Expenditures 39,505 34,026 11,895 40,108 35,000 35,010 35,010 35,010 35,010 Surplus(Deficit) (14,156) 2,092 8,115 9,902 10 - - - - Ending Fund Balance 12,714 14,087 28,944 23,989 23,999 23,999 23,999 23,999 23,999 Fund Balance N $40 v R N $30 ° $20 $10 $0 FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Library Capital 84-00042-00-4214 DEVELOPMENT FEES 25,325 35,350 20,000. 50,000 35,000 35,000 35,000 35,000 35,000 84-00042-00-4224 RENEW PROGRAM PERMITS - 750 - - - - - - - 84-000-45-00-4500 INVESTMENT EARNINGS 11 8 10 10 10 10 10 10 10 84-000-48-00-4850 MISCELLANEOUS INCOME 13 10 Revenue 25,349 36,118 20,010 50,010 35,010 35,010 35,010 35,010 35,010 84-840-54-00-5406 RENEW PROGRAM - 750 - - - - - - 84-840-54-00-5460 E-BOOKS SUBSCRIPTION 3,093 3,508 3,500 3,500 3,500 3,500 3,500 3,500 3,500 84-840-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 16,428 1,311 - 10,108 15,000 15,000 15,000 15,000 15,000 84-840-56-00-5683 AUDIO BOOKS 2,467 1,237 - 2,500 - - - - - 84-840-56-00-5684 COMPACT DISCS&OTHER MUSIC - - - - - - - - - 84-840-56-00-5685 DVD'S 1,250 394 - 2,000 - - - - - 84-840-56-00-5686 BOOKS 16,267 26,826 8,395 22,000 16,500 16,510 16,510 16,510 16,510 Expenditures 39,505 34,026 11,895 40,108 35,000 35,010 35,010 35,010 35,010 Surplus(Deficit) (14,156) 2,092 8,115 9,902 10 - - - - Fund Balance 12,714 14,087 28,944 23,989 23,999 23,999 23,999 23,999 23,999 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. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Revenue Taxes 9,295 143,784 200,000 215,360 225,000 225,000 225,000 225,000 225,000 Investment Earnings - 5 - - - - - - - Other Financing Sources - 1,597,288 - - - - - - - Total Revenue 9,295 1,741,077 200,000 215,360 225,000 225,000 225,000 225,000 225,000 Expenditures Contractual Services 4,953 16,477 3,140 2,140 13,841 13,841 13,841 13,841 13,841 Capital Outlay 7,004 - - - - - - - - Debt Service 68,073 87,743 159,619 159,619 149,675 149,358 209,845 208,311 208,311 Other Financing Uses - 1,581,984 - - - - - - - Total Expenditures 80,030 1,686,204 162,759 161,759 163,516 163,199 223,686 222,152 222,152 Surplus(Deficit) (70,735) 54,873 37,241 53,601 61,484 61,801 1,314 2,848 2,848 Ending Fund Balance (604,820) (549,946) (520,551) (496,345) (434,861) (373,060) (371,746) (368,898) (366,050) N $0 - - 0 ($200) Fund Balance t ($400) ($600) ($800) FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Countmide TIF 87-000-40-00-4000 PROPERTY TAXES 9,295 143,784 200,000 215,360 225,000 225,000 225,000 225,000 225,000 87-000-45-00-4500 INVESTMENT EARNINGS - 5 - - - - - - - 87-000-49-00-4902 BOND ISSUANCE - 1,475,000 - - - - - - 87-000-49-00-4903 PREMIUM ON BOND ISSUANCE 122,288 Revenue 9,295 1,741,077 200,000 215,360 225,000 225,000 225,000 225,000 225,000 87-870-54-00-5401 ADMINISTRATIVE CHARGEBACK - - - - 10,701 10,701 10,701 10,701 10,701 87-870-54-00-5402 BOND ISSUANCE COSTS - 15,304 - - - - - - - 87-870-54-00-5462 PROFESSIONAL SERVICES 3,829 638 2,000 1,000 2,000 2,000 2,000 2,000 2,000 87-870-54-00-5498 PAYING AGENT FEES 1,124 535 1,140 1,140 1,140 1,140 1,140 1,140 1,140 87-870-60-00-6000 PROJECT COSTS 7,004 - - - - - - - - 2015A Bond 87-870-77-00-8000 PRINCIPAL PAYMENT - - 26,460 .26,460 41,013 42,336 104,517 107,163 107,163 87-870-77-00-8050 INTEREST PAYMENT - - 82,444 82,444 57,947 56,307 54,613 50,433 50,433 Debt Service-2005 Bond 87-870-80-00-8000 PRINCIPAL PAYMENT - - - - - - - - - 87-870-80-00-8050 INTEREST PAYMENT 68,073 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 87-870-99-00-9960 PAYMENT TO ESCROW AGENT 1,581,984 Expenditures 80,030 1,686,204 162,759 161,759 163,516 163,199 223,686 222,152 222,152 Surplus(Deficit) (70,735) 54,873 37,241 53,601 61,484 61,801 1,314 2,848 2,848 Fund Balance (604,820) (549,946) (520,551) (496,345) (434,861) (373,060) (371,746) (368,898) (366,050) Downtown TIF Fund(88) The Downtown TIF was created in 2006,in order to finance a mixed use development in the downtown area. FY 2017 FY 2015 FY 2016 Adopted FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Actual Actual Budget Projected Proposed Projected Projected Projected Projected Revenue Taxes 60,027 68,868 70,000 67,307 70,000 75,000 75,000 80,000 80,000 Investment Earnings 1 3 50 - - - - - - Miscellaneous 187 236 - - - - - - - Total Revenue 60,215 69,107 70,050 67,307 70,000 75,000 75,000 80,000 80,000 Expenditures Contractual Services 20,045 17,830 35,360 35,360 65,659 65,659 65,659 65,659 65,659 Capital Outlay 19,106 36,668 443,170 605,924 137,420 17,420 17,420 17,420 17,420 Debt Service - - - - 228,000 221,000 214,000 207,000 - Other Financing Uses 13,500 - - - - - - - - Total Expenditures 52,651 54,498 478,530 641,284 431,079 304,079 297,079 290,079 83,079 Surplus(Deficit) 7,564 14,609 (408,480) (573,977) (361,079) (229,079) (222,079) (210,079) (3,079) Ending Fund Balance 239,096 253,703 (154,775) (320,274) (681,353) (910,432) (1,132,511) (1,342,590) (1,345,669) $500 Fund Balance r 3 $0 0 ($500) ($1,000) ($1,500) FY 2015 FY 2016 FY 2017 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Account Number Description Actual Actual Adopted Projected Proposed Projected Projected Projected Projected Downtown TIF 88-000-40-00-4000 PROPERTY TAXES 60,027 68,868 70,000 67,307 70,000 75,000 75,000 80,000 80,000 88-000-45-00.4500 INVESTMENT EARNINGS 1 3 50 - - - - - - 88-000-48-00-4850 MISCELLANEOUS INCOME 187 236 Revenue 60,215 69,107 70,050 67,307 70,000 75,000 75,000 80,000 80,000 88-880-54-00-5401 ADMINISTRATIVE CHARGEBACK - - - - 30,284 30,284 30,284 30,284 30,284 88-880-54-00-5425 TIF INCENTIVE PAYOUT 16,196 15,223 20,000 20,000 20,000 20,000 20,000 20,000 20,000 88-880-54-00-5462 PROFESSIONAL SERVICES 276 2,051 360 360 375 375 375 375 375 88-880-54-00-5466 LEGAL SERVICES 3,573 556 15,000 15,000 15,000 15,000 15,000 15,000 15,000 88-880-60-00-6000 PROJECT COSTS 11,686 29,248 125,000 125,000 100,000 10,000 10,000 10,000 10,000 88-880-60-00-6011 PROPERTY ACQUISITION - - - 370,000 - - - - - 88-880-60-00-6048 DOWNTOWN STREETSCAPE IMPROVEMENT - - 310,750 103,504 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 7,420 Old Second Building-Installment Contract 88-880-81-00-8000 PRINCIPAL PAYMENT - - - - 200,000 200,000 200,000 200,000 - 88-880-81-00-8050 INTEREST PAYMENT - - - - 28,000 21,000 14,000 7,000 - 88-880-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL 13,500 Expenditures 52,651 54,498 478,530 641,284 431,079 304,079 297,079 290,079 83,079 Surplus(Deficit) 7,564 14,609 (408,480) (573,977) (361,079) (229,079) (222,079) (210,079) (3,079) Fund Balance 239,096 253,703 (154,775) (320,274) (681,353) (910,432) (1,132,511) (1,342,590) (1,345,669)