Loading...
Ordinance 2018-55 molar 11XIN911 . FILED - DEC 0 4 201 kufrl- KWUCOOTY UNITED CITY OF YORKVILLE KENDALL COUNTY, ILLINOIS ORDINANCE NO.2018-55 AN ORDINANCE AUTHORIZING THE NINTH AMENDMENT TO THE ANNUAL BUDGET OF THE UNITED CITY OF YORKVILLE,FOR THE FISCAL YEAR COMMENCING ON MAY 1,2018 AND ENDING ON APRIL 30,2019 Passed by the City Council of the United City of Yorkville,Kendall County,Illinois This 23`a day of October, 2018 Published in pamphlet form by the authority of the Mayor and City Council of the United City of Yorkville,Kendall County,Illinois on November 6,2018. Ordinance No. 2018- AN ORDINANCE AUTHORIZING THE NINTH AMENDMENT TO THE ANNUAL BUDGET OF THE UNITED CITY OF YORKVILLE,FOR THE FISCAL YEAR COMMENCING ON MAY 1,2018 AND ENDING ON APRIL 30,2019 WHEREAS, the United City of Yorkville (the "City") is a duly organized and validly existing non-home rule municipality created in accordance with the Constitution of the State of Illinois of 1970 and the laws of the State; and, WHEREAS,pursuant to 65 ILCS 5/8-2-9.4, the City adopted Ordinance No. 2018-26 on April 10, 2018 adopting an annual budget for the fiscal year commencing on May 1, 2018 and ending on April 30, 2019; and, WHEREAS,pursuant to 65 ILCS 5/8-2-9.6,by a vote of two-thirds of the members of the corporate authorities then holding office,the annual budget of the United City of Yorkville may be revised by deleting, adding to, changing or creating sub-classes within object classes and object classes themselves. No revision of the budget shall be made increasing the budget in the event funds are not available to effectuate the purpose of the revision; and, WHEREAS, funds are available to effectuate the purpose of this revision. NOW THEREFORE,BE IT ORDAINED by the Mayor and City Council of the United City of Yorkville, Kendall County, Illinois, as follows: Section 1: That the amounts shown in Schedule A, attached hereto and made a part hereof by reference,increasing and/or decreasing certain object classes and decreasing certain fund balances in the General,Water, Sewer and Parks&Recreation funds with respect to the United City of Yorkville's 2018-2019 Budget are hereby approved. Section 2: This ordinance shall be in full force and effect from and after its passage and approval according to law. Ordinance No.2018-65 Page 2 Passed by the City Co ncil of the United City of Yorkville, Kendall Coun , Illinois this day of +d 2018. i` CITY CLERK i CARLO COLOSIMO KEN KOCH JACKIE MILSCHEWSKI ARDEN JOE PLOCHER CHRIS FUNKHOUSER JOEL FRIEDERS 1 SEAVER TARULIS y JASON PETERSON Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this 30 day of 0 0-M61� 9- 12018. MAYOR Ordinance No.2018- -65 Page 3 Schedule A 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 2019 FY 2019 FY 2016 FY 2017 FY 2018 Adopted Amended Actual Actual Actual Budget Budget Revenue Taxes 10,330,920 10,736,464 10,962,693 11,014,213 11,014,213 Intergovernmental 2,311,978 2,235,395 2,296,435 2,512,487 2,512,487 Licenses&Permits 213,451 315,862 364,499 336,000 336,000 Fines&Forfeits 123,639 140,250 123,617 130,400 130,400 Charges for Service 1,401,384 1,465,678 1,508,994 1,535,112 1,535,112 Investment Earnings 6,394 21,197 49,018 20,000 20,000 Reimbursements 113,024 66,449 85,579 55,000 55,000 Miscellaneous 21,919 19,848 19,243 21,750 21,750 Other Financing Sources 7,077 9,645 92,125 18,000 18,000 Total Revenue 14,529,786 15,010,788 15,502,203 15,642,962 15,642,962 Expenditures Salaries 3,958,489 4,212,964 4,522,164 4,901,639 4,901,639 Benefits 2,447,779 2,635,062 2,905,833 3,056,457 3,056,457 Contractual Services 4,593,459 4,793,382 4,765,498 5,046,691 5,046,691 Supplies 216,288 197,932 246,655 338,598 346,098 Other Financing Uses 2,448,123 2,649,065 2,779,764 3,044,911 3,044,911 Total Expenditures 13,664,138 14,488,405 15,219,914 16,388,296 16,395,796 Surplus(Deficit) 865,648 522,383 282,289 (745,334) (752,834) Ending Fund Balance 5,691,706 6,214,089 6,496,373 5,468,778 5,743,539 41.7% 42.9% 42.7% 33.4% 35.0% $7,000 Fund Balance N c $6,500 M o' $6,000 s $5,500 $5,000 $4,500 1 PUBLIC WORKS DEPARTMENT - STREETS & SANITATION The Public Works Department is an integral part of the United City of Yorkville. The Street Department maintains a comprehensive road and storm sewer network to ensure the safety and quality of life for the citizens of Yorkville. Disposal of refuse is contracted out to Advanced Disposal. FY 2019 FY 2019 FY 2016 FY 2017 FY 2018 Adopted Amended Actual Actual Actual Budget Budget Expenditures Salaries 345,777 362,054 395,459 408,909 408,909 Benefits 178,885 196,446 196,203 197,100 197,100 Contractual Services 1,537,504 1,450,218 1,239,831 1,304,948 1,304,948 Supplies 67,617 68,784 97,088 174,798 182,298 Total Public Works Department 2,129,783 2,077,502 1,928,581 2,085,755 2,093,255 $2,150 V $2,100 c 3 $2,050 0 $2,000 $1,950 $1,900 $1,850 $1,800 2 United City of Yorkville General Fund 410 PUBLIC WORKS-STREET OPERATIONS FY 2016 FY 2017 FY 2018 FY 2019 FY 2019 Account Description Actual Actual Actual Adopted Amended Salaries 01-410-50-00-5010 SALARIES&WAGES 329,967 339,927 360,757 382,309 382,309 01-410-50-00-5015 PART-TIME SALARIES 7,709 8,455 8,550 11,600 11,600 01-410-50-00-5020 OVERTIME 8,101 13,672 26,152 15,000 15,000 Total: Salaries $345,777 $362,054 $395,459 $408,909 $408,909 Benefits 01-410-52-00-5212 RETIREMENT PLAN CONTRIBUTION 36,546 37,768 41,337 42,448 42,448 01-410-52-00-5214 FICA CONTRIBUTION 25,567 26,608 29,271 30,161 30,161 01-410-52-00-5216 GROUP HEALTH INSURANCE 106,676 121,383 116,109 115,626 115,626 01-410-52-00-5222 GROUP LIFE INSURANCE 645 610 594 437 437 01-410-52-00-5223 DENTAL INSURANCE 8,406 9,010 7,827 7,363 7,363 01-410-52-00-5224 VISION INSURANCE 1,045 1,067 1,065 1,065 1,065 Total: Benefits $178,885 $196,446 $196,203 $197,100 $197,100 Contractual Services 01-410-54-00-5412 TRAINING&CONFERENCES 6,514 2,895 2,603 3,000 3,000 01-410-54-00-5415 TRAVEL&LODGING - 1,157 706 2,000 2,000 01-410-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK 194,379 63,626 - - - 01-410-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - 1,523 1,523 01-410-54-00-5435 TRAFFIC SIGNAL MAINTENANCE 23,108 18,871 8,795 20,000 20,000 01-410-54-00-5440 TELECOMMUNICATIONS 2,449 2,751 3,433 3,500 3,500 01-410-54-00-5455 MOSQUITO CONTROL 7,002 7,142 7,142 7,499 7,499 01-410-54-00-5458 TREE&STUMP REMOVAL 8,225 8,980 5,725 15,000 15,000 01-410-54-00-5462 PROFESSIONAL SERVICES 3,906 6,428 3,089 4,000 4,000 01-410-54-00-5482 STREET LIGHTING 3,296 426 400 9,000 9,000 01-410-54-00-5483 JULIE SERVICES - - - 3,000 3,000 01-410-54-00-5485 RENTAL&LEASE PURCHASE 793 6,162 1,238 6,000 6,000 01-410-54-00-5488 OFFICE CLEANING - - 1,164 1,199 1,199 01-410-54-00-5490 VEHICLE MAINTENANCE SERVICES 48,132 30,385 64,919 55,000 55,000 Total: Contractual Services $297,804 $148,823 $99,214 $130,721 $130,721 Supplies 01-410-56-00-5600 WEARING APPAREL 5,043 4,620 6,632 5,100 5,100 01-410-56-00-5619 SIGNS - - 15,000 15,000 01-410-56-00-5620 OPERATING SUPPLIES 8,828 5,287 18,832 17,600 25,100 01-410-56-00-5626 HANGING BASKETS - - - - - 01-410-56-00-5628 VEHICLE MAINTENACE SUPPLIES 15,265 27,441 27,125 30,000 30,000 01-410-56-00-5630 SMALL TOOLS&EQUIPMENT 3,415 3,270 3,288 6,000 6,000 01-410-56-00-5632 ASPHALT PATCHING - - - 35,000 35,000 01-410-56-00-5640 REPAIR&MAINTENANCE 20,580 12,775 19,339 25,000 25,000 01-410-56-00-5642 STREET LIGHTING SUPPLIES - - - 17,000 17,000 3 United City of Yorkville General Fund 410 PUBLIC WORKS-STREET OPERATIONS FY 2016 FY 2017 FY 2018 FY 2019 FY 2019 Account Description Actual Actual Actual Adopted Amended 01-410-56-00-5665 JULIE SUPPLIES - - 1,200 1,200 01-410-56-00-5695 GASOLINE 14,486 15,391 21,872 22,898 22,898 Total: Supplies $67,617 $68,784 $97,088 $174,798 $182,298 Total: STREET OPERATIONS89$ 0,083 $776,107 $787,964 $911,528 $919,028 4 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 2019 FY 2019 FY 2016 FY 2017 FY 2018 Adopted Amended Actual Actual Actual Budget Budget Revenue Licenses&Permits 162,468 171,840 165,755 - - Charges for Service 3,461,906 3,955,944 4,489,995 4,326,486 4,326,486 Investment Earnings 5,492 9,729 11,727 7,000 7,000 Reimbursements 4,605 27,256 388 - - Miscellaneous 57,261 60,865 61,221 62,491 62,491 Other Financing Sources 4,369,998 6,325,992 139,116 142,541 142,541 Total Revenue 8,061,730 10,551,626 4,868,202 4,538,518 4,538,518 Expenditures Salaries 376,019 390,595 412,773 441,121 441,121 Benefits 218,947 235,050 246,029 257,466 257,466 Contractual Services 887,201 827,278 872,119 734,523 734,523 Supplies 266,102 326,045 327,921 354,448 361,948 Capital Outlay 1,069,736 3,499,902 889,684 1,555,976 1,555,976 Debt Service 1,147,429 1,449,609 1,343,250 1,532,837 1,532,837 Other Financing Uses - 6,193,291 1,018,308 - - Total Expenses 3,965,434 12,921,770 5,110,084 4,876,371 4,883,871 Surplus(Deficit) 4,096,296 (2,370,144) (241,882) (337,853) (345,353) Ending Fund Balance Equivalent 5,196,289 2,826,144 2,584,262 1,952,155 2,238,909 131.0% 21.9% 50.6% 40.0% 45.8% $6,000 I $5,000 c 4A 3 $4,000 o $3,000 $2,000 $1,000 $0 5 United City of Yorkville Water Fund 510 WATER OPERATIONS FY 2016 FY 2017 FY 2018 FY 2019 FY 2019 Account Description Actual Actual Actual Adopted Amended Salaries 51-510-50-00-5010 SALARIES&WAGES 365,077 375,148 394,263 414,121 414,121 51-510-50-00-5015 PART-TIME SALARIES 3,611 5,530 11,532 15,000 15,000 51-510-50-00-5020 OVERTIME 7,331 9,917 6,978 12,000 12,000 Total: Salaries $376,019 $390,595 $412,773 5441,121 $441,121 Benefits 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION 40,267 41,132 42,915 45,526 45,526 51-510-52-00-5214 FICA CONTRIBUTION 27,354 28,326 30,192 32,370 32,370 51-510-52-00-5216 GROUP HEALTH INSURANCE 113,806 127,757 134,779 139,233 139,233 51-510-52-00-5222 GROUP LIFE INSURANCE 777 705 705 519 519 51-510-52-00-5223 DENTAL INSURANCE 8,712 9,147 8,808 8,260 8,260 51-510-52-00-5224 VISION INSURANCE 1,131 1,131 1,218 1,218 1,218 51-510-52-00-5230 UNEMPLOYMENT INSURANCE 1,785 1,148 671 2,000 2,000 51-510-52-00-5231 LIABILITY INSURANCE 25,115 25,704 26,741 28,340 28,340 Total: Benefits $218,947 $235,050 $246,029 $257,466 $257,466 Contractual Services 51-510-54-00-5401 ADMINISTRATIVE CHARGEBACK - - 108,154 111,629 111,629 51-510-54-00-5402 BOND ISSUANCE COSTS 40,456 55,732 - - - 51-510-54-00-5405 BUILD PROGRAM 162,468 171,840 165,755 - - 51-510-54-00-5412 TRAINING&CONFERENCES 3,072 3,178 2,515 6,500 6,500 51-510-54-00-5415 TRAVEL&LODGING 1,193 2,123 732 2,000 2,000 51-510-54-00-5415 COMPUTER REPLACEMNET CHARGEBACK - - - 2,627 2,627 51-510-54-00-5426 PUBLISHING&ADVERTISING 211 605 932 500 500 51-510-54-00-5429 WATER SAMPLES 6,842 7,607 5,894 10,000 10,000 51-510-54-00-5430 PRINTING&DUPLICATING 2,679 2,405 2,814 3,250 3,250 51-510-54-00-5440 TELECOMMUNICATIONS 24,715 30,807 33,832 30,000 30,000 51-510-54-00-5445 TREATMENT FACILITY SERVICES 113,208 143,204 136,286 145,000 145,000 51-510-54-00-5448 FILING FEES 3,753 2,058 1,901 4,000 4,000 51-510-54-00-5452 POSTAGE&SHIPPING 18,206 16,838 17,723 19,000 19,000 51-510-54-00-5460 DUES&SUBSCRIPTIONS 1,080 1,603 1,169 1,800 1,800 51-510-54-00-5462 PROFESSIONAL SERVICES 47,595 39,025 36,863 45,000 45,000 51-510-54-00-5465 ENGINEERING SERVICES 187,840 46,960 39,975 15,000 15,000 51-510-54-00-5480 UTILITIES 239,114 256,914 279,411 286,518 286,518 51-510-54-00-5483 JULIE SERVICES 4,300 7,849 5,954 3,000 3,000 51-510-54-00-5485 RENTAL&LEASE PURCHASE 464 423 929 1,000 1,000 51-510-54-00-5488 OFFICE CLEANING - - 1,164 1,199 1,199 6 United City of Yorkville Water Fund 510 WATER OPERATIONS FY 2016 FY 2017 FY 2018 FY 2019 FY 2019 Account Description Actual Actual Actual Adopted Amended 51-510-54-00-5490 VEHICLE MAINTENANCE SERVICES 14,551 8,862 5,930 12,000 12,000 51-510-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 6,994 15,096 15,023 25,000 25,000 51-510-54-00-5498 PAYING AGENT FEES 2,241 1,415 1,888 2,000 2,000 51-510-54-00-5499 BAD DEBT 6,219 12,734 7,275 7,500 7,500 Total: Contractual Services $887,201 $827,278 $872,119 $734,523 $734,523 Supplies 51-510-56-00-5600 WEARING APPAREL 5,194 4,264 6,837 5,100 5,100 51-510-56-00-5620 OPERATING SUPPLIES 5,993 7,744 2,807 7,500 15,000 51-510-56-00-5628 VEHICLE MAINTENACE SUPPLIES 1,082 699 2,416 2,500 2,500 51-510-56-00-5630 SMALL TOOLS&EQUIPMENT 1,144 4,447 1,365 4,000 4,000 51-510-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 641 850 559 - - 51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 151,829 173,204 159,093 183,750 183,750 51-510-56-00-5640 REPAIR&MAINTENANCE 12,970 19,307 15,183 27,500 27,500 51-510-56-00-5664 METERS&PARTS 72,039 97,378 117,151 100,000 100,000 51-510-56-00-5665 JULIE SUPPLIES 1,272 3,669 693 1,200 1,200 51-510-56-00-5695 GASOLINE 13,938 14,483 21,817 22,898 22,898 Total: Supplies $266,102 $326,045 $327,921 $354,448 $361,948 Capital Outlay 51-510-60-00-6022 WELL REHABILITATIONS 128,876 174,197 264,985 257,500 257,500 51-510-60-00-6011 PROPERTY ACQUISITION - - - 200,000 200,000 51-510-60-00-6025 ROAD TO BETTER ROADS PROGRAM 259,341 316,911 272,423 250,000 250,000 51-510-60-00-6034 WHISPERING MEADOWS SUBDIVISION - - 115 49,220 49,220 51-510-60-00-6059 US34(IL RT47/ORCHARD RD)PROJECT - 26,676 4,212 4,212 51-510-60-00-6060 EQUIPMENT - 3,248 8,825 5,000 5,000 51-510-60-00-6066 RTE 71 WATERMAIN RELOCATION 15,955 24,195 44,904 533,500 533,500 51-510-60-00-6070 VEHICLES - 65,710 - 50,000 50,000 51-510-60-00-6079 ROUTE 47 EXPANSION 197,544 197,544 197,544 197,544 197,544 51-510-60-00-6081 CATION EXCHANGE MEDIA REPLACEMENT - - - 9,000 9,000 51-510-60-00-6082 COUNTRYSIDE PKY IMPROVEMENTS 468,020 2,718,097 74,212 - - Total: Capital Outlay $1,069,736 $3,499,902 $889,684 $1,555,976 $1,555,976 Debt Service-2015A Bond 51-510-77-00-8000 PRINCIPAL PAYMENT 73,543 113,991 117,664 117,664 51-510-77-00-8050 INTEREST PAYMENT 228,066 161,055 156,493 156,493 Total: Debt Service-2015A Bond $0 $301,609 $275,046 $274,157 $274,157 7 United City of Yorkville Water Fund 510 WATER OPERATIONS FY 2016 FY 2017 FY 2018 FY 2019 FY 2019 Account Description Actual Actual Actual Adopted Amended Debt Service-2007A Bond 51-510-83-00-8000 PRINCIPAL PAYMENT 15,000 15,000 51-510-83-00-8050 INTEREST PAYMENT 121,793 121,163 - - - Total: Debt Service-2007A Bond $136,793 $136,163 $0 $0 $0 Debt Service-2016 Refunding Bond 51-510-85-00-8000 PRINCIPAL PAYMENT - - 430,000 470,000 470,000 51-510-85-00-8050 INTEREST PAYMENT - - 248,124 195,250 195,250 Total: Debt Service-2016 Refunding Bond $0 $0 $678,124 $665,250 $665,250 Debt Service-2003 Debt Certificates 51-510-86-00-8000 PRINCIPAL PAYMENT 100,000 100,000 100,000 300,000 300,000 51-510-86-00-8050 INTEREST PAYMENT 25,450 21,450 17,300 13,050 13,050 Total: Debt Service-2003 Debt Certificates $125,450 $121,450 $117,300 $313,050 $313,050 Debt Service-2006A Refunding Debt Certificates 51-510-87-00-8000 PRINCIPAL PAYMENT 435,000 460,000 - - - 51-510-87-00-8050 INTEREST PAYMENT 172,606 155,206 - - - Total: Debt Service-2006A Refunding $607,606 $615,206 $0 $0 $0 Debt Service-IEPA Loan L17-156300 51-510-89-00-8000 PRINCIPAL PAYMENT 94,544 96,923 99,361 101,860 101,860 51-510-89-00-8050 INTEREST PAYMENT 30,486 28,108 25,669 23,170 23,170 Total: Debt Service-IL EPA Loan 156300 $125,030 $125,031 $125,030 $125,030 $125,030 Debt Service-2014C Refunding Bond 51-510-94-00-8000 PRINCIPAL PAYMENT 120,000 120,000 120,000 130,000 130,000 51-510-94-00-8050 INTEREST PAYMENT 32,550 30,150 27,750 25,350 25,350 Total: Debt Service-2014C Ref Bond $152,550 $150,150 $147,750 $155,350 $155,350 Other Financing Uses 51-510-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL - - 1,018,308 - - 51-510-99-00-9960 PAYMENT TO ESCROW AGENT - 6,193,291 - Total: Other Financing Uses $0 $6,193,291 $1,018,308 $0 $0 Total: WATER OPERATIONS $3,965,434 $12,921,770 $5,110,084 $4,876,371 $4,883,871 8 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 2019 FY 2019 FY 2016 FY 2017 FY 2018 Adopted Amended Actual Actual Actual Budget Budget Revenue Licenses&Permits 77,350 105,392 93,000 - - Charges for Service 1,312,456 1,286,891 1,595,338 1,558,658 1,558,658 Investment Earnings 1,193 3,899 24,274 1,250 1,250 Reimbursements 1,264 8,149 54 - - Other Financing Sources 1,134,654 1,134,052 1,137,166 856,583 856,583 Total Revenue 2,526,917 2,538,383 2,849,832 2,416,491 2,416,491 Expenditures Salaries 205,371 212,574 224,215 234,507 234,507 Benefits 104,560 105,974 111,531 113,682 113,682 Contractual Services 177,716 170,831 221,111 139,140 139,140 Supplies 38,924 38,912 45,902 51,080 55,880 Capital Outlay 284,509 228,131 228,179 513,167 513,167 Developer Commitments 32,890.00 33,872 34,888 35,938 35,938 Debt Service 1,865,399 1,865,857 1,877,110 1,880,265 1,880,265 Other Financing Uses 76,275 75,075 73,875 77,675 77,675 Total Expenses 2,785,644 2,731,226 2,816,811 3,045,454 3,050,254 Surplus(Deficit) (258,727) (192,843) 33,021 (628,963) (633,763) Ending Fund Balance Equivalent 1,570,874 1,378,030 1,411,051 705,765 777,288 56.4% 50.5% 50.1% 23.2% 25.5% $2,000 $1,500 m ° $1,000 L H $500 $0 9 United City of Yorkville Sewer Fund 520 SEWER OPERAT'ION'S FY 2016 FY 2017 FY 2018 FY 2019 FY 2019 Account Description Actual Actual Actual Adopted Amended Salaries 52-520-50-00-5010 SALARIES&WAGES 205,240 212,553 223,926 233,507 233,507 52-520-50-00-5020 OVERTIME 131 21 289 1,000 1,000 Total: Salaries $205,371 $212,574 $224,215 $234,507 $234,507 Benefits 52-520-52-00-5212 RETIREMENT PLAN CONTRIBUTION 22,403 22,899 24,177 25,054 25,054 52-520-52-00-5214 FICA CONTRIBUTION 15,474 15,904 16,847 17,311 17,311 52-520-52-00-5216 GROUP HEALTH INSURANCE 48,364 48,457 51,511 51,285 51,285 52-520-52-00-5222 GROUP LIFE INSURANCE 409 371 371 273 273 52-520-52-00-5223 DENTAL INSURANCE 4,159 4,367 4,239 3,901 3,901 52-520-52-00-5224 VISION INSURANCE 552 552 594 594 594 52-520-52-00-5230 UNEMPLOYMENT INSURANCE 941 478 353 1,000 1,000 52-520-52-00-5231 LIABILITY INSURANCE 12,258 12,946 13,439 14,264 14,264 Total: Benefits $104,560 $105,974 $111,531 $113,682 $113,682 Contractual Services 52-520-54-00-5401 ADMINISTRATIVE CHARGEBACK - - 38,925 40,176 40,176 52-520-54-00-5405 BUILD PROGRAM 76,600 104,700 93,000 - - 52-520-54-00-5406 RENEW PROGRAM 750 692 - - - 52-520-54-00-5412 TRAINING&CONFERENCES 1,515 1,703 1,180 2,500 2,500 52-520-54-00-5415 TRAVEL&LODGING 1,232 2,681 344 2,000 2,000 52-520-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - 263 263 52-520-54-00-5430 PRINTING&DUPLICATING 1,265 1,133 1,307 1,500 1,500 52-520-54-00-5440 TELECOMMUNICATIONS 2,398 2,411 8,667 9,000 9,000 52-520-54-00-5444 LIFT STATION SERVICES 5,898 648 20,727 10,000 10,000 52-520-54-00-5462 PROFESSIONAL SERVICES 8,615 14,772 14,638 18,000 18,000 52-520-54-00-5480 UTILITIES 19,100 17,660 20,081 21,200 21,200 52-520-54-00-5483 JULIE SERVICES - - - 3,000 3,000 52-520-54-00-5485 RENTAL&LEASE PURCHASE 766 423 662 1,000 1,000 52-520-54-00-5488 OFFICE CLEANING - - 729 751 751 52-520-54-00-5490 VEHICLE MAINTENANCE SERVICES 5,437 8,549 1,643 10,000 10,000 52-520-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 51,366 11,924 15,072 16,000 16,000 52-520-54-00-5498 PAYING AGENT FEES 1,277 1,542 1,277 1,500 1,500 52-520-54-00-5499 BAD DEBT 1,497 1,993 2,859 2,250 2,250 Total: Contractual Services $177,716 $170,831 $221,111 $139,140 $139,140 Supplies 10 United City of Yorkville Sewer Fund 520 SEIVER OPERATIONS FY 2016 FY 2017 FY 2018 FY 2019 FY 2019 Account Description Actual Actual Actual Adopted Amended 52-520-56-00-5600 WEARING APPAREL 3,441 2,791 3,965 3,980 3,980 52-520-56-00-5610 OFFICE SUPPLIES 569 465 1,029 1,000 1,000 52-520-56-00-5613 LIFT STATION MAINTENANCE 5,584 3,604 8,006 8,000 8,000 52-520-56-00-5620 OPERATING SUPPLIES 6,621 5,868 4,516 6,500 11,300 52-520-56-00-5628 VEHICLE MAINTENANCE SUPPLIES 2,697 3,590 5,356 2,000 2,000 52-520-56-00-5630 SMALL TOOLS&EQUIPMENT 1,848 3,658 711 2,000 2,000 52-520-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - 1,270 - - - 52-520-56-00-5640 REPAIR&MAINTENANCE 4,290 3,708 2,243 5,000 5,000 52-520-56-00-5665 JULIE SUPPLIES - - - 1,200 1,200 52-520-56-00-5695 GASOLINE 13,874 13,958 20,076 21,400 21,400 Total: Supplies $38,924 $38,912 $45,902 $51,080 $55,880 Capital Outlay 52-520-60-00-6025 ROAD TO BETTER ROADS 225,494 162,427 160,219 200,000 200,000 52-520-60-00-6034 WHISPERING MEADOWS SUBDIVISION - - 172 48,150 48,150 52-520-60-00-6059 US34(IL 47/ORCHARD RD)PROJECT - 4,213 17,002 17,002 52-520-60-00-6060 EQUIPMENT 1,014 - - - 52-520-60-00-6066 RT71 SANITARY SEWER REPLACEMENT - 5,675 4,560 189,000 189,000 52-520-60-00-6079 ROUTE 47 EXPANSION 59,015 59,015 59,015 59,015 59,015 Total: Capital Outlay $284,509 $228,131 $228,179 $513,167 $513,167 Developer Commitments 52-520-75-00-7500 LENNAR-RAINTREE SEWER RECPATURE 32,890 33,872 34,888 35,938 35,938 Total: Developer Commitments $32,890 $33,872 $34,888 $35,938 $35,938 Debt Service-2004B Bond 52-520-84-00-8000 PRINCIPAL PAYMENT 395,000 410,000 435,000 455,000 455,000 52-520-84-00-8050 INTEREST PAYMENT 65,825 52,000 35,600 18,200 18,200 Total: Debt Service-2004B Bond $460,825 $462,000 $470,600 $473,200 $473,200 Debt Service-2003A IRBB Debt Certificates 52-520-90-00-8000 PRINCIPAL PAYMENT 110,000 115,000 120,000 130,000 130,000 52-520-90-00-8050 INTEREST PAYMENT 52,870 47,755 42,293 36,233 36,233 Total: Debt Service-2003 IRBB $162,870 $162,755 $162,293 $166,233 $166,233 11 United City of Yorkville Sewer Fund .520 SEWER OPERATIONS FY 2016 FY 2017 FY 2018 FY 2019 FY 2019 Account Description Actual Actual Actual Adopted Amended Debt Service-2011 Refunding Bond 52-520-92-00-8000 PRINCIPAL PAYMENT 715,000 745,000 780,000 810,000 810,000 52-520-92-00-8050 INTEREST PAYMENT 419,654 389,052 357,166 323,782 323,782 Total: Debt Service-2011 Refunding $1,134,654 $1,134,052 $1,137,166 $1,133,782 $1,133,782 Debt Service-IEPA Loan L17-115300 52-520-96-00-8000 PRINCIPAL PAYMENT 95,821 98,353 100,952 103,619 103,619 52-520-96-00-8050 INTEREST PAYMENT 11,229 8,697 6,099 3,431 3,431 Total: Debt Service-IEPA Loan 115300 $107,050 $107,050 $107,051 $107,050 $107,050 Other Financing Uses 52-520-99-00-9951 TRANSFER TO WATER 76,275 75,075 73,875 77,675 77,675 Total: Other Financing Uses $76,275 $75,075 $73,875 $77,675 $77,675 Total: SEWER OPERATIONS2 7$ , 85,644 $2,731,226 $2,816,811 $3,045,454 $3,050,254 12 PARKS & 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 2019 FY 2019 FY 2016 FY 2017 FY 2018 Adopted Amended Actual Actual Actual Budget Budget Revenue Charges for Service 408,469 455,676 453,466 511,815 511,815 Investment Earnings 369 328 800 500 500 Reimbursements 12,890 3,002 174 - - Miscellaneous 219,704 209,970 234,784 201,000 201,000 Other Financing Sources 1,076,831 1,118,638 1,308,583 1,274,699 1,274,699 Total Revenue 1,718,263 1,787,614 1,997,807 1,988,014 1,988,014 Expenditures Salaries 723,194 805,190 868,189 972,772 972,772 Benefits 325,538 365,079 390,010 432,587 432,587 Contractual Services 252,132 311,346 318,383 294,214 294,214 Supplies 474,172 360,884 393,250 386,735 396,935 Total Expenditures 1,775,036 1,842,499 1,969,832 2,086,308 2,096,508 Surplus(Deficit) (56,773) (54,885) 27,975 (98,294) (108,494) Ending Fund Balance 500,762 445,875 473,850 312,946 365,356 28.2% 24.2% 24.1% 15.0% 17.4% $600 Fund Balance y $500 M $400 0 0 F $300 $200 $100 $0 13 United City of Yorkville Parks and Recreation Fund 790 PARKS DEPARTMENT EXPENDITURES FY 2016 FY 2017 FY 2018 FY 2019 FY 2019 Account Description Actual Actual Actual Adopted Amended Salaries 79-790-50-00-5010 SALARIES&WAGES 387,634 425,198 459,025 485,686 485,686 79-790-50-00-5015 PART-TIME SALARIES 24,382 35,251 37,282 50,000 50,000 79-790-50-00-5020 OVERTIME 1,884 2,091 2,533 3,000 3,000 Total: Salaries $413,900 $462,540 $498,840 $538,686 $538,686 Benefits 79-790-52-00-5212 RETIREMENT PLAN CONTRIBUTION 41,923 46,256 51,254 54,010 54,010 79-790-52-00-5214 FICA CONTRIBUTION 30,890 34,143 36,883 39,814 39,814 79-790-52-00-5216 GROUP HEALTH INSURANCE 102,203 119,781 131,162 155,114 155,114 79-790-52-00-5222 GROUP LIFE INSURANCE 790 884 896 580 580 79-790-52-00-5223 DENTAL INSURANCE 7,978 8,353 9,726 10,417 10,417 79-790-52-00-5224 VISION INSURANCE 947 1,002 1,313 1,457 1,457 Total: Benefits $184,731 $210,419 $231,234 $261,392 $261,392 Contractual Services 79-790-54-00-5412 TRAINING&CONFERENCES 2,136 4,410 4,186 7,000 7,000 79-790-54-00-5415 TRAVEL&LODGING 85 807 248 3,000 3,000 79-790-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK - 53,908 70,000 - - 79-790-54-00-5424 COMPUTER REPLACEMENT CHARGEBACK - - - 5,200 5,200 79-790-54-00-5440 TELECOMMUNICATIONS 5,312 6,278 6,348 6,500 6,500 79-790-54-00-5462 PROFESSIONAL SERVICES 7,206 2,461 1,940 3,000 3,000 79-790-54-00-5466 LEGAL SERVICES 5,415 663 2,634 6,000 6,000 79-790-54-00-5485 RENTAL&LEASE PURCHASE 2,461 2,334 5,818 2,500 2,500 79-790-54-00-5495 OFFICE CLEANING - - 2,719 2,800 2,800 79-790-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 36,800 22,411 17,640 50,000 50,000 Total: Contractual Services $59,415 $93,272 $111,533 $86,000 $86,000 Supplies 79-790-56-00-5600 WEARING APPAREL 5,759 5,344 8,647 6,220 6,220 79-790-56-00-5620 OPERATING SUPPLIES 147,028 23,577 31,213 25,000 35,200 79-790-56-00-5630 SMALL TOOLS&EQUIPMENT 5,518 1,576 5,965 6,000 6,000 79-790-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 2,000 2,000 2,000 20,000 20,000 79-790-56-00-5640 REPAIR&MAINTENANCE 64,517 69,160 68,347 66,000 66,000 79-790-56-00-5695 GASOLINE 11,694 12,439 15,686 14,445 14,445 Total: Supplies $236,516 $114,096 $131,858 $137,665 $147,865 Total: PARK DEPT EXPENDITURES89$ 4.562 $880,327 $973,465 $1,023,743 $1,033,943 14