Loading...
Ordinance 2018-42 NOIS IAdNi1f OF�IIffNQU - FILED - AUG 0 7 2018 h9i J a- Damn UNITED CITY OF YORKVILLE KENDALL COUNTY, ILLINOIS ORDINANCE NO.2018-42 AN ORDINANCE AUTHORIZING THE EIGHTH AMENDMENT TO THE ANNUAL BUDGET OF THE UNITED CITY OF YORKVILLE,FOR THE FISCAL YEAR COMMENCING ON MAY 1,2017 AND ENDING ON APRIL 30,2018 Passed by the City Council of the United City of Yorkville,Kendall County,Illinois This 24'x'day of July,2018 Published in pamphlet form by the authority of the Mayor and City Council of the United City of Yorkville,Kendall County,Illinois on August 7,2018. Ordinance No. 2018--qJq- AN ORDINANCE AUTHORIZING THE EIGHTH AMENDMENT TO THE ANNUAL BUDGET OF THE UNITED CITY OF YORKVILLE,FOR THE FISCAL YEAR COMMENCING ON MAY 1,2017 AND ENDING ON APRIL 30,2018 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. 2017-16 on April 11, 2017 adopting an annual budget for the fiscal year commencing on May 1,2017 and ending on April 30, 2018; 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 City-Wide Capital, Debt Service and Water funds with respect to the United City of Yorkville's 2017-2018 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- /d Page 2 Passed by the City Council of the United City of Yorkville, Kendall County, Ill' is this day of , 2018. CITY CL CARLO COLOSIMO KEN KOCH _ JACKIE MILSCHEWSKI ARDEN JOE PLOCHER t CHRIS FUNKHOUSER Y JOEL FRIEDERS SEAVER TARULIS ALEX HERNANDEZ Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this day of -A(tc-u,57- , 2018. O Ordinance No.2018- la Page 3 Ef�! A CITY-WIDE CAPITAL FUND (23) The City-Wide Capital Fund is used to maintain existing and construct new public infrastructure,and to fund other improvements that benefit the public. FY 2018 FY 2018 FY 2015 FY 2016 FY 2017 Adopted Amended Actual Actual Actual Budget Budget Revenue Intergovernmental 62,761 135,722 534,354 200,224 200,224 Licenses&Permits 105,266 141,203 196,003 73,000 168,804 Charges for Service 693,467 700,156 718,872 700,000 700,000 Investment Earnings 10,424 1,630 3,703 1,000 1,000 Reimbursements 1,261,619 399,561 199,851 472,617 472,617 Other Financing Sources 4,408,084 210,243 73,502 1,258,924 1,258,924 Total Revenue 6,541,621 1,588,515 1,726,285 2,705,765 2,801,569 Expenditures Contractual Services 295,580 130,762 107,274 161,675 257,479 Supplies 5,971.00 8,913 27,847 35,000 35,000 Capital Outlay 2,147,884 2,711,081 2,825,760 2,940,753 3,319,666 Debt Service 75,000 405,937 404,138 403,588 403,588 Other Financing Uses 9,034 12,621 9,645 78,510 78,510 Total Expenditures 2,533,469 3,269,314 3,374,664 3,619,526 4,094,243 Surplus(Deficit) 4,008,152 (1,680,799) (1,648,379) (913,761) (1,292,674) Ending Fund Balance 4,684,706 3,003,908 1,355,530 144,741 62,856 184.9% 91.9% 40.2% 4.0% 1.5% $5,000 $4,000 a C 3 $3,000 0 $2,000 $1,000 $0 1 United City of Yorkville City-Wide Capital Fund 23 CITY-WIDE CAPITAL FUND REVENUE FY 2015 FY 2016 FY 2017 FY 2018 FY 2018 Account Description Actual Actual Actual Adopted Amended Intergovernmental 23-000-41-00-4161 FEDERAL GRANTS-ITEP DOWNTOWN 42,461 11,244 31,109 1,600 1,600 23-000-41-00-4162 FEDERAL GRANTS-RIVER ROAD BRIDGE (9,411) - - - - 23-000-41-00-4169 FEDERAL GRANTS-MILL STREET LAFO - 1,075 24,606 - - 23-000-41-00-4178 FEDERAL GRANTS-ITEP KENNEDY RD TRAIL 29,711 71,327 2,475 133,424 133,424 23-000-41-00-4188 STATE GRANTS-EDP WRIGLEY(RTE 47) - 52,076 476,164 65,200 65,200 Total: Intergovernmental $62,761 $135,722 $534,354 $200,224 $200,224 Licenses&Permits 23-000-42-00-4210 BUILDING PERMITS - - 35,365 - - 23-000-42-00-4214 DEVELOPMENT FEES-CW CAPITAL 6,900 6,150 1,085 6,000 6,000 23-000-42-00-4216 BUILD PROGRAM PERMITS 78,157 85,565 61,008 - 95,804 23-000-42-00-4218 DEVELOPMENT FEES-MUNI BLDG 2,209 7,077 9,645 7,000 7,000 23-000-42-00-4222 ROAD CONTRIBUTION FEE 18,000 40,000 88,000 60,000 60,000 23-000-42-00-4224 RENEW PROGRAM PERMITS - 2,411 900 - - Total: Licenses&Permits $105,266 $141,203 $196,003 $73,000 $168,804 Charges for Service 23-000-44-00-4440 ROAD INFRASTRUCTURE FEE 693,467 700,156 718,872 700,000 700,000 Total: Charges for Service $693,467 $700,156 $718,872 $700,000 $700,000 Investment Earnings 23-000-45-00-4500 INVESTMENT EARNINGS 4,423 1,630 3,703 1,000 1,000 23-000-45-00-4550 GAIN ON INVESTMENT 6,001 - - - - Total: Investment Earnings $10,424 $1,630 $3,703 $1,000 $1,000 Reimbursements 23-000-46-00-4606 REIMB-COM ED 93,095 316,905 - - - 23-000-46-00-4607 REIMB-BLACKBERRY WOODS - 11,999 131,574 - - 23-000-46-00-4608 REIMB-KENNEDY RD IMPROVEMENTS - - - 160,000 160,000 23-000-46-00-4620 REIMB-PULTE(AUTUMN CREEK) 1,148,170 25,703 - - - 23-000-46-00-4630 REIMB-STAGECOACH CROSSING - - 63,404 - - 23-000-46-00-4660 REIMB-PUSH FOR THE PATH 7,727 38,618 1,413 312,617 312,617 23-000-46-00-4690 REIMB-MISCELLANEOUS 12,627 6,336 3,460 - - Total: Reimbursements $1,261,619 $399,561 $199,851 $472,617 $472,617 Other Financing Sources 23-000-49-00-4900 BOND PROCEEDS 4,295,000 - - - - 23-000-49-00-4903 PREMIUM ON BOND ISSUANCE 49,789 2 United City of Yorkville City-Wide Capital Fund 23 CITY-WIDE CAPITAL FUND REVENUE FY 2015 FY 2016 FY 2017 FY 2018 FY 2018 Account Description Actual Actual Actual Adopted Amended 23-000-49-00-4905 LOAN PROCEEDS 152,183 - 23-000-49-00-4910 SALE OF CAPITAL ASSETS - - 1,900 - 23-000-49-00-4916 TRANSFER FROM GENERAL-CW B&G 49,795 58,060 71,602 160,000 160,000 23-000-49-00-4951 TRANSFER FROM WATER - - - 1,098,924 1,098,924 23-000-49-00-4988 TRANSFER TO DOWNTOWN TIF 13,500 - - - - Total: Other Financing Sources $4,408,084 $210,243 $73,502 $1,258,924 $1,258,924 Total: CITY-WIDE CAPITAL REVENUE $6,541,621 $1,588,515 $1,726,285 $2,705,765 $2,801,569 3 United City of Yorkville City-Wide Capital Fund 216 CITY-WIDE BUILDING&GROUNDS EXPENDITURES FY 2015 FY 2016 FY 2017 FY 2018 FY 2018 Account Description Actual Actual Actual Adopted Amended Contractual Services 23-216-54-00-5405 BUILD PROGRAM 6,000 8,945 4,850 - 9,956 23-216-54-00-5446 PROPERTY&BLDG MAINT SERVICES 37,824 40,202 43,755 125,000 125,000 Total: Contractual Services $43,824 $49,147 $48,605 $125,000 $134,956 Supplies 23-216-56-00-5656 PROPERTY&BLDG MAINT SUPPLIES 5,971 8,913 27,847 35,000 35,000 Total: Supplies $5,971 $8,913 $27,847 $35,000 $35,000 Other Financing Uses 23-216-99-00-9901 TRANSFER TO GENERAL 2,209 7,077 9,645 7,000 7,000 Total: Other Financing Uses $2,209 $7,077 $9,645 $7,000 $7,000 Total: CW B&G EXPENDITURES5$ 2,004 $65,137 $86,097 $167,000 $176,956 4 United City of Yorkville City-Wide Capital Fund 230 CITY-WIDE CAPITAL EXPENDITURES FY 2015 FY 2016 FY 2017 FY 2018 FY 2018 Account Description Actual Actual Actual Adopted Amended Contractual Services 23-230-54-00-5402 BOND ISSUANCE COSTS 52,025 - - - 23-230-54-00-5405 BUILD PROGRAM 72,157 76,620 56,158 85,848 23-230-54-00-5406 RENEW PROGRAM - 2,411 900 - - 23-230-54-00-5465 ENGINEERING SERVICES 5,856 1,370 - 35,000 35,000 23-230-54-00-5489 LOSS ON INVESTMENT 120,631 - - - - 23-230-54-00-5498 PAYING AGENT FEES - 475 475 475 475 23-230-54-00-5499 BAD DEBT 1,087 739 1,136 1,200 1,200 Total: Contractual Services $251,756 $81,615 $58,669 $36,675 $122,523 Capital Outlay 23-230-60-00-6007 KENNEDY ROAD-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 454,548 65,200 65,200 23-230-60-00-6011 PROPERTY ACQUISITION - 160,877 - - 23-230-60-00-6014 BLACKBERRY WOODS 11,999 131,574 - - 23-230-60-00-6016 US34(CENTER/ELDAMIAN RD)PROJECT - - 151,300 151,300 23-230-60-00-6017 STAGECOACH CROSSING - - 63,304 - - 23-230-60-00-6018 GREENBRIAR POND NATURALIZATION 18,769 12,632 8,649 4,672 4,672 23-230-60-00-6019 BRISTOL BAY ACCESS ROAD - - - - 50,000 23-230-60-00-6025 ROAD TO BETTER ROADS PROGRAM 405,718 509,430 695,767 400,000 400,000 23-230-60-00-6041 SIDEWALK CONSTRUCTION 8,065 3,598 806 7,500 7,500 23-230-60-00-6048 DOWNTOWN STREETSCAPE IMPROVEMENT 53,077 14,055 39,088 2,000 2,000 23-230-60-00-6059 US34(IL 47/ORCHARD RD)PROJECT - - 16,497 94,600 94,600 23-230-60-00-6073 GAME FARM ROAD PROJECT 354,220 1,377,783 13,364 - 328,913 23-230-60-00-6075 RIVER ROAD BRIDGE PROJECT - 152,183 - - - 23-230-60-00-6082 COUNTRYSIDE PKY IMPROVEMENTS 117,202 1,211,639 645,940 645,940 23-230-60-00-6084 CENTER&COUNTRYSIDE IMPROVEMENTS - - 522,000 522,000 23-230-60-00-6086 KENNEDY ROAD IMPROVEMENTS - - 25,753 601,500 601,500 23-230-60-00-6094 KENNEDY ROAD BIKE TRAIL 37,438 109,946 3,894 446,041 446,041 23-230-60-00-6095 SUNFLOWER ESTATES-DRAINAGE IMPROV 109,785 613 - - - Total: Capital Outlay $2,147,884 $2,711,081 $2,825,760 $2,940,753 $3,319,666 Debt Service-2014A Bond 23-230-78-00-8000 PRINCIPAL PAYMENT 135,000 185,000 190,000 190,000 23-230-78-00-8050 INTEREST PAYMENT 195,937 144,138 138,588 138,588 Total: Debt Service-2014A Bond $0 $330,937 $329,138 $328,588 $328,588 5 United City of Yorkville City-Wide Capital Fund 230 CITY-WIDE CAPITAL EXPENDITURES FY 2015 FY 2016 FY 2017 FY 2018 FY 2018 Account Description Actual Actual Actual Adopted Amended Kendall County Loan-River Road Bridge 23-230-97-00-8000 PRINCIPAL PAYMENT 75,000 75,000 75,000 75,000 75,000 Total: Kendall Co Loan-River Rd Bridge $75,000 $75,000 $75,000 $75,000 $75,000 Other Financing Uses 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,510 27%of Annual Debt Service Amount for 2015A Bonds Total: Other Financing Uses $6,825 $5,544 $0 $71,510 $71,510 Total: CITY-WIDE CAP EXPENDITURES $2,481,465 $3,204,177 $3,288,567 $3,452,526 $3,917,287 6 DEBT SERVICE FUND (42) This fund accumulates monies for payment of the 2014B bonds,which refunded the 2005A Bonds which were originally issued to finance road improvements. FY 2018 FY 2018 FY 2015 FY 2016 FY 2017 Adopted Amended Actual Actual Actual Budget Budget Revenue Taxes 327,984 164,852 47,070 - - Licenses&Permits 7,418 14,281 7,015 5,000 6,051 Investment Earnings 5 11 - - - Other Financing Sources 2,369,891 127,243 266,979 315,225 315,225 Total Revenue 2,705,298 306,387 321,064 320,225 321,276 Expenditures Contractual Services 39,617 3,979 914 475 1,526 Debt Service 304,042 310,250 320,150 319,750 319,750 Other Financing Uses 2,359,115 - - - - Total Expenditures 2,702,774 314,229 321,064 320,225 321,276 Surplus(Deficit) 2,524 (7,842) 0 - - Ending Fund Balance 7,842 0 0 0 0 0.3% 0.0% 0.0% 0.0% 0.0% $10 $8 Fund Balance $6 0 L ~ $4 $2 $0 7 United City of Yorkville Debt Service Fund 42 DEBT SERVICE FUND REVENUE FY 2015 FY 2016 FY 2017 FY 2018 FY 2018 Account Description Actual Actual Actual Adopted Amended Taxes 42-000-40-00-4000 PROPERTY TAXES-2014B BOND 327,984 164,852 47,070 - Total: Taxes $327,984 $164,852 $47,070 $0 $0 License&Permits 42-000-42-00-4208 RECAPTURE FEES-WATER&SEWER 1,696 10,777 6,577 5,000 5,000 42-000-42-00-4216 BUILD PROGRAM PERMITS 5,722 3,466 425 - 1,051 42-000-42-00-4224 RENEW PROGRAM - 38 13 - - Total: Licenses&Permits $7,418 $14,281 $7,015 $5,000 $6,051 Investment Earnings 42-000-45-00-4500 INVESTMENT EARNINGS 5 11 - - - Total: Investment Earnings $5 $11 $0 $0 $0 Other Financing Sources 42-000-49-00-4901 TRANSFER FROM GENERAL - 127,243 266,979 315,225 315,225 42-000-49-00-4902 BOND ISSUANCE 2,300,000 - - - - 42-000-49-00-4903 PREMIUM ON BOND ISSUANCE 69,891 - - - - Total: Other Financing Sources $2,369,891 $127,243 $266,979 $315,225 $315,225 Total: DEBT SERVICE FUND REVENUE $2,705,298 $306,387 $321,064 $320,225 $321,276 8 United City of Yorkville Debt Service Fund 420 DEBT SERVICE FUND EXPENDITURES FY 2015 FY 2016 FY 2017 FY 2018 FY 2018 Account Description Actual Actual Actual Adopted Amended Contractual Services 42-420-54-00-5402 BOND ISSUANCE COSTS 33,306 - - - 42-420-54-00-5405 BUILD PROGRAM 5,722 3,466 425 1,051 42-420-54-00-5406 RENEW PROGRAM - 38 13 - - 42-420-54-00-5498 PAYING AGENT FEES 589 475 476 475 475 Total: Contractual Services $39,617 $3,979 $914 $475 $1,526 Debt Service-2014B Bond 42-420-79-00-8000 PRINCIPAL PAYMENT - 255,000 270,000 275,000 275,000 42-420-79-00-8050 INTEREST PAYMENT 22,253 55,250 50,150 44,750 44,750 Total: Debt Service-2014B Bond $22,253 $310,250 $320,150 $319,750 $319,750 Debt Service-2005A Bond 42-420-82-00-8000 PRINCIPAL PAYMENT 225,000 - - - - 42-420-82-00-8050 INTEREST PAYMENT 56,789 Total: Debt Service-2005A Bond $281,789 $0 $0 $0 $0 Other Financing Uses 42-420-99-00-9960 PAYMENT TO ESCROW AGENT 2,359,115 - - - - Total: Other Financing Uses $2,359,115 $0 $0 $0 $0 Total: DEBT SERVICE $2,702,774 $314,229 $321,064 $320,225 321276 9 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 2018 FY 2018 FY 2015 FY 2016 FY 2017 Adopted Amended Actual Actual Actual Budget Budget Revenue Taxes 5,210 - - - - Licenses&Permits 112,323 162,468 171,840 - 165,755 Charges for Service 2,513,791 3,461,906 3,955,944 4,088,800 4,088,800 Investment Earnings 2,034 5,492 9,729 5,000 5,000 Reimbursements 3,970 4,605 27,256 - - Miscellaneous 57,775 57,261 60,865 58,582 58,582 Other Financing Sources 1,373,687 4,369,998 6,325,992 145,385 145,385 Total Revenue 4,068,790 8,061,730 10,551,626 4,297,767 4,463,522 Expenditures Salaries 354,098 376,019 390,595 430,549 430,549 Benefits 211,030 218,947 235,050 266,965 266,965 Contractual Services 609,139 887,201 827,278 886,366 1,052,121 Supplies 245,704 266,102 326,045 323,013 323,013 Capital Outlay 474,916 1,069,736 3,499,902 807,937 807,937 Debt Service 1,168,385 1,147,429 1,449,609 1,344,749 1,344,749 Other Financing Uses 1,256,453 - 6,193,291 1,098,924 1,098,924 Total Expenses 4,319,725 3,965,434 12,921,770 5,158,503 5,324,258 Surplus(Deficit) (250,935) 4,096,296 (2,370,144) (860,736) (860,736) Ending Fund Balance Equivalent 1,099,988 5,196,289 2,826,144 2,285,570 1,965,408 25.5% 131.0% 21.9% 44.3% 36.9% $6,000 in $5,000 M N $4,000 s $3,000 $2,000 $1,000 $0 10 United City of Yorkville Water Fund s1 WA'I'E:R FUND REVENUE FY 2015 FY 2016 FY 2017 FY 2018 FY 2018 Account Description Actual Actual Actual Adopted Amended Taxes 51-000-40-00-4000 PROPERTY TAXES-2007A BOND 5,210 - Total: Taxes $5,210 $0 $0 $0 $0 Licenses&Permits 51-000-42-00-4216 BUILD PROGRAM PERMIT 112,323 162,468 171,840 - 165,755 Total: Licenses&Permits $112,323 $162,468 $171,840 $0 $165,755 Charges for Services 51-000-44-00-4424 WATER SALES 2,019,810 2,463,058 2,952,074 2,956,000 2,956,000 51-000-44-00-4425 BULK WATER SALES 29,590 (6,660) 5,250 5,000 5,000 51-000-44-00-4426 LATE PENALTIES-WATER 91,488 101,208 104,425 105,000 105,000 51-000-44-00-4430 WATER METER SALES 15,782 38,102 66,280 50,000 50,000 51-000-44-00-4440 WATER INFRASTRUCTURE FEE 343,961 717,028 734,552 725,000 725,000 51-000-44-00-4450 WATER CONNECTION FEES 13,160 149,170 93,363 247,800 247,800 Total: Charges for Services $2,513,791 $3,461,906 $3,955,944 $49088,800 $4,088,800 Investment Earnings 51-000-45-00-4500 INVESTMENT EARNINGS 1,236 5,492 9,729 5,000 5,000 51-000-45-00-4550 GAIN ON INVESTMENT 798 - - - - Total: Investment Earnings $2,034 $5,492 $9,729 $5,000 $5,000 Reimbursements 51-000-46-00-4690 REIMB-MISCELLANEOUS 3,970 4,605 27,256 - - Total: Reimbursements $3,970 $4,605 $279256 $0 $0 Miscellaneous 51-000-48-00-4820 RENTAL INCOME 55,560 56,888 60,495 58,582 58,582 51-000-48-00-4850 MISCELLANEOUS INCOME 2,215 373 370 - - Total: Miscellaneous $57,775 $57,261 $60,865 $58,582 $58,582 Other Financing Sources 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-4910 SALE OF CAPITAL ASSETS - - 1,894 - - 51-000-49-00-4923 TRANSFER FROM CITY-WIDE CAPITAL - - - 71,510 71,510 51-000-49-00-4952 TRANSFER FROM SEWER 83,588 76,275 75,075 73,875 73,875 Total: Other Financing Sources $1,373,687 $4,369,998 $6,325,992 $145,385 $145,385 Total: WATER FUND REVENUE4 0$ , 68,790 $8,061,730 $10,551,626 $4,297,767 $4,463,522 11 United City of Yorkville Water Fund 510 WATER OPERATIONS FY 2015 FY 2016 FY 2017 FY 2018 FY 2018 Account Description Actual Actual Actual Adopted Amended Salaries 51-510-50-00-5010 SALARIES&WAGES 343,733 365,077 375,148 388,749 388,749 51-510-50-00-5015 PART-TIME SALARIES 2,808 3,611 5,530 29,800 29,800 51-510-50-00-5020 OVERTIME 7,557 7,331 9,917 12,000 12,000 Total: Salaries $354,098 $376,019 $390,595 $430,549 $430,549 Benefits 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION 39,878 40,267 41,132 43,749 43,749 51-510-52-00-5214 FICA CONTRIBUTION 25,689 27,354 28,326 31,730 31,730 51-510-52-00-5216 GROUP HEALTH INSURANCE 113,371 113,806 127,757 148,964 148,964 51-510-52-00-5222 GROUP LIFE INSURANCE 701 777 705 705 705 51-510-52-00-5223 DENTAL INSURANCE 7,130 8,712 9,147 9,605 9,605 51-510-52-00-5224 VISION INSURANCE 793 1,131 1,131 1,165 1,165 51-510-52-00-5230 UNEMPLOYMENT INSURANCE 716 1,785 1,148 2,000 2,000 51-510-52-00-5231 LIABILITY INSURANCE 22,752 25,115 25,704 29,047 29,047 Total: Benefits $211,030 $218,947 $235,050 $266,965 $266,965 Contractual Services 51-510-54-00-5401 ADMINISTRATIVE CHARGEBACK - - - 108,154 108,154 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 171,840 - 165,755 51-510-54-00-5412 TRAINING&CONFERENCES 2,305 3,072 3,178 6,500 6,500 51-510-54-00-5415 TRAVEL&LODGING 942 1,193 2,123 1,600 1,600 51-510-54-00-5426 PUBLISHING&ADVERTISING 148 211 605 1,000 1,000 51-510-54-00-5429 WATER SAMPLES 9,823 6,842 7,607 12,000 12,000 51-510-54-00-5430 PRINTING&DUPLICATING 112 2,679 2,405 3,000 3,000 51-510-54-00-5440 TELECOMMUNICATIONS 20,221 24,715 30,807 30,000 30,000 51-510-54-00-5445 TREATMENT FACILITY SERVICES 108,905 113,208 143,204 120,000 120,000 51-510-54-00-5448 FILING FEES 4,253 3,753 2,058 5,000 5,000 51-510-54-00-5452 POSTAGE&SHIPPING 17,953 18,206 16,838 19,000 19,000 51-510-54-00-5460 DUES&SUBSCRIPTIONS 978 1,080 1,603 1,600 1,600 51-510-54-00-5462 PROFESSIONAL SERVICES 20,343 47,595 39,025 45,000 45,000 51-510-54-00-5465 ENGINEERING SERVICES - 187,840 46,960 200,000 200,000 51-510-54-00-5466 LEGAL SERVICES - - - 2,000 2,000 51-510-54-00-5480 UTILITIES 245,641 239,114 256,914 270,300 270,300 51-510-54-00-5483 JULIE SERVICES 4,570 4,300 7,849 6,500 6,500 12 United City of Yorkville Water Fund 510 WATER OPERATIONS FY 2015 FY 2016 FY 2017 FY 2018 FY 2018 Account Description Actual Actual Actual Adopted Amended 51-510-54-00-5485 RENTAL&LEASE PURCHASE 504 464 423 750 750 51-510-54-00-5488 OFFICE CLEANING - - - 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 8,862 15,000 15,000 51-510-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 3,380 6,994 15,096 25,000 25,000 51-510-54-00-5498 PAYING AGENT FEES 2,354 2,241 1,415 2,295 2,295 51-510-54-00-5499 BAD DEBT 6,893 6,219 12,734 7,500 7,500 Total: Contractual Services $609,139 $887,201 $827,278 $886,366 $1,052,121 Supplies 51-510-56-00-5600 WEARING APPAREL 3,434 5,194 4,264 4,200 4,200 51-510-56-00-5620 OPERATING SUPPLIES 12,352 5,993 7,744 15,000 15,000 51-510-56-00-5628 VEHICLE MAINTENACE SUPPLIES 2,314 1,082 699 5,000 5,000 51-510-56-00-5630 SMALL TOOLS&EQUIPMENT 1,921 1,144 4,447 2,000 2,000 51-510-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 1,616 641 850 2,000 2,000 51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 146,540 151,829 173,204 181,913 181,913 51-510-56-00-5640 REPAIR&MAINTENANCE 20,263 12,970 19,307 20,000 20,000 51-510-56-00-5664 METERS&PARTS 32,520 72,039 97,378 70,000 70,000 51-510-56-00-5665 JULIE SUPPLIES 1,788 1,272 3,669 1,500 1,500 51-510-56-00-5695 GASOLINE 22,956 13,938 14,483 21,400 21,400 Total: Supplies $245,704 $266,102 $326,045 $323,013 $323,013 Capital Outlay 51-510-60-00-6022 WELL REHABILITATIONS - 128,876 174,197 203,000 203,000 51-510-60-00-6025 ROAD TO BETTER ROADS PROGRAM 277,372 259,341 316,911 250,000 250,000 51-510-60-00-6059 US34(IL RT47/ORCHARD RD)PROJECT - - - 10,000 10,000 51-510-60-00-6060 EQUIPMENT - 3,248 10,000 10,000 51-510-60-00-6066 RTE 71 WATERMAIN RELOCATION 15,955 24,195 14,580 14,580 51-510-60-00-6070 VEHICLES - - 65,710 - - 51-510-60-00-6079 ROUTE 47 EXPANSION 197,544 197,544 197,544 197,544 197,544 51-510-60-00-6082 COUNTRYSIDE PKY IMPROVEMENTS - 468,020 2,718,097 122,813 122,813 Total: Capital Outlay $474,916 $1,069,736 $3,499,902 $807,937 $807,937 Debt Service-2015A Bond 51-510-77-00-8000 PRINCIPAL PAYMENT - 73,543 113,987 113,987 51-510-77-00-8050 INTEREST PAYMENT 228,066 161,053 161,053 Total: Debt Service-2015A Bond $0 $0 $301,609 $275,040 $275,040 13 United City of Yorkville Water Fund 510 WATER OPERATIONS FY 2015 FY 2016 FY 2017 FY 2018 FY 2018 Account Description Actual Actual Actual Adopted Amended Debt Service-2007A Bond 51-510-83-00-8000 PRINCIPAL PAYMENT 15,000 15,000 15,000 51-510-83-00-8050 INTEREST PAYMENT 122,423 121,793 121,163 - - Total: Debt Service-2007A Bond $137,423 $136,793 $136,163 $0 $0 Debt Service-2016 Refunding Bond 51-510-85-00-8000 PRINCIPAL PAYMENT - - - 430,000 430,000 51-510-85-00-8050 INTEREST PAYMENT - - - 249,629 249,629 Total: Debt Service-2016 Refunding Bond $0 $0 $0 $679,629 $679,629 Debt Service-2003 Debt Certificates 51-510-86-00-8000 PRINCIPAL PAYMENT 100,000 100,000 100,000 100,000 100,000 51-510-86-00-8050 INTEREST PAYMENT 29,350 25,450 21,450 17,300 17,300 Total: Debt Service-2003 Debt Certificates $129,350 $125,450 $121,450 $117,300 $117,300 Debt Service-2006A Refunding Debt Certificates 51-510-87-00-8000 PRINCIPAL PAYMENT 420,000 435,000 460,000 - - 51-510-87-00-8050 INTEREST PAYMENT 189,406 172,606 155,206 Total: Debt Service-2006A Refunding $609,406 $607,606 $615,206 $0 $0 Debt Service-2005C Bond 51-510-88-00-8000 PRINCIPAL PAYMENT 100,000 - - 51-510-88-00-8050 INTEREST PAYMENT 54,065 - - - - Total: Debt Service-2005C Bond $154,065 $0 $0 $0 $0 Debt Service-IEPA Loan L17-156300 51-510-89-00-8000 PRINCIPAL PAYMENT 92,224 94,544 96,923 99,361 99,361 51-510-89-00-8050 INTEREST PAYMENT 32,806 30,486 28,108 25,669 25,669 Total: Debt Service-IL EPA Loan 156300 $125,030 $125,030 $125,031 $125,030 $125,030 Debt Service-2014C Refunding Bond 51-510-94-00-8000 PRINCIPAL PAYMENT - 120,000 120,000 120,000 120,000 51-510-94-00-8050 INTEREST PAYMENT 13,111 32,550 30,150 27,750 27,750 Total: Debt Service-2014C Ref Bond $13,111 $152,550 $150,150 $147,750 $147,750 Other Financing Uses 51-510-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL - - - 1,098,924 1,098,924 51-510-99-00-9960 PAYMENT TO ESCROW AGENT 1,256,453 6,193,291 - - Total: Other Financing Uses $1,256,453 $0 $6,193,291 $1,098,924 $1,098,924 Total: WATER OPERATIONS $4,319,725 $3,965,434 $12,921,770 $5,158,503 $5,324,258 14