Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Ordinance 2017-38
UR OF IKINM awraftwL F{LLD - AUG 14 2017 aaa�tr UNITED CITY OF YORKVILLE KENDALL COUNTY, ILLINOIS ORDINANCE NO. 2017-38 AN ORDINANCE AUTHORIZING THE EIGHTH AMENDMENT TO THE ANNUAL BUDGET OF THE UNITED CITY OF YORKVILLE,FOR THE FISCAL YEAR COMMENCING ON MAY 1,2016 AND ENDING ON APRIL 30,2017 Passed by the City Council of the United City of Yorkville,Kendall County,Illinois This 25th day of July,2017 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,2017. Ordinance No. 2017- AN ORDINANCE AUTHORIZING THE EIGHTH AMENDMENT TO THE ANNUAL BUDGET OF THE UNITED CITY OF YORKVILLE, FOR THE FISCAL YEAR COMMENCING ON MAY 1,2016 AND ENDING ON APRIL 30,2017 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. 2016-30 on April 12, 2016 adopting an annual budget for the fiscal year commencing on May 1, 2016 and ending on April 30,2017; 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 Debt Service Fund, Water Fund, Parks&Recreation Fund and Vehicle& Equipment Fund with respect to the United City of Yorkville's 2016-2017 Budget are hereby approved. Ordinance No.2017- 3% Page 2 Section 2: This ordinance shall be in full force and effect from and after its passage and approval according to law. Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this _ day ofu /q, 2017. CITY CLERK CARLO COLOSIMO KEN KOCH JACKIE MILSCHEWSKI y ARDEN JOE PLOCHER CHRIS FUNKHOUSER JOEL FRIEDERS SEAVER TARULIS ALEX HERNANDEZ Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this ddayof J(ALY 2017. --2LR Ordinance No.2017-'3S Page 3 Schedule A -1 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 2017 FY 2017 FY 2014 FY 2015 FY 2016 Adopted Amended Actual Actual Actual Budget Budget Revenue Taxes 315,790 327,984 164,852 47,497 47,497 Licenses&Permits 6,358 7,418 14,281 5,000 5,438 Investment Earnings 78 5 11 - - Other Financing Sources - 2,369,891 127,243 268,178 268,178 Total Revenue 322,226 2,705,298 306,387 320,675 321,113 Expenditures Contractual Services 775 39,617 3,979 525 963 Debt Service 328,179 304,042 310,250 320,150 320,150 Other Financing Uses - 2,359,115 - - - Total Expenditures 328,954 2,702,774 314,229 320,675 321,113 Surplus(Deficit) (6,728) 2,524 (7,842) - - Ending Fund Balance 5,319 7,842 0 0 0 1.6% 0.3% 0.0% 0.0% 0.0% $10 $8 Fund Balance 3 $6 0 s ~ $4 $2 $0 1 United City of Yorkville Debt Service Fund 42 DEBT SERVICE FUND REVENUE FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended Taxes 42-000-40-00-4000 PROPERTY TAXES-2014B BOND 315,790 327,984 164,852 47,497 47,497 Total: Taxes $315,790 $327,984 $164,852 $47,497 $47,497 License&Permits 42-000-42-00-4208 RECAPTURE FEES-WATER&SEWER 5,958 1,696 10,777 5,000 5,000 42-000-42-00-4216 BUILD PROGRAM PERMITS 400 5,722 3,466 - 425 42-000-42-00-4224 RENEW PROGRAM PERMITS - - 38 - 13 Total: Licenses&Permits $6,358 $7,418 $14,281 $5,000 $5,438 Investment Earnings 42-000-45-00-4500 INVESTMENT EARNINGS 78 5 11 - - Total: Investment Earnings $78 $5 $11 $0 $0 Other Financing Sources 42-000-49-00-4901 TRANSFER FROM GENERAL - - 127,243 268,178 268,178 2014B Debt Service 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 $0 $2,369,891 $127,243 $268,178 $268,178 Total: DEBT SERVICE FUND REVENUE $322,226 $2,705,298 $306,387 $320,675 $321,113 2 United City of Yorkville Debt Service Fund 420 DEBT SERVICE FUND EXPENDITURES FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 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 400 5,722 3,466 - 425 42-420-54-00-5406 RENEW PROGRAM - - 38 13 42-420-54-00-5498 PAYING AGENT FEES 375 589 475 525 525 Total: Contractual Services $775 $39,617 $3,979 $525 $963 Debt Service-2014B Bond 42-420-79-00-8000 PRINCIPAL PAYMENT - - 255,000 270,000 270,000 42-420-79-00-8050 INTEREST PAYMENT - 22,253 55,250 50,150 50,150 Total: Debt Service-2014B Bond $0 $22,253 $310,250 $320,150 $320,150 Debt Service-2005A Bond 42-420-82-00-8000 PRINCIPAL PAYMENT 215,000 225,000 - - - 42-420-82-00-8050 INTEREST PAYMENT 113,179 56,789 Total: Debt Service-2005A Bond $328,179 $281,789 $0 $0 $0 Other Financing Uses 42-420-99-00-9960 PAYMENT TO ESCROW AGENT - 2,359,115 - - - Total: Other Financing Uses $0 $2,359,115 $0 $0 $0 Total: DEBT SERVICE $328,954 $2,702,774 $314,229 $320,675 $321,113 3 Schedule A - 2 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 FY 2017 FY 2017 FY 2014 FY 2015 FY 2016 Adopted Amended Actual Actual Actual Budget Budget Revenue Taxes 41,403 5,210 - - - Licenses&Permits 84,544 112,323 162,468 - 171,840 Charges for Service 2,309,950 2,513,791 3,461,906 3,661,400 3,661,400 Investment Earnings 2,231 2,034 5,492 1,000 1,000 Reimbursements 14,844 3,970 4,605 - - Miscellaneous 51,917 57,775 57,261 57,433 57,433 Other Financing Sources 82,988 1,373,687 4,369,998 75,075 6,324,098 Total Revenue 2,587,877 4,068,790 8,061,730 3,794,908 10,215,771 Expenditures Salaries 338,959 354,098 376,019 416,844 416,844 Benefits 185,769 211,030 218,947 252,493 252,493 Contractual Services 541,175 609,139 887,201 607,087 772,499 Supplies 243,529 245,704 266,102 297,660 297,660 Capital Outlay 282,399 474,916 1,069,736 3,606,668 3,482,668 Debt Service 1,172,802 1,168,385 1,147,429 1,450,677 1,450,677 Other Financing Uses - 1,256,453 - - 6,193,291 Total Expenses 2,764,633 4,319,725 3,965,434 6,631,429 12,866,132 Surplus(Deficit) (176,756) (250,935) 4,096,296 (2,836,521) (2,650,361) Ending Fund Balance Equivalent 1,350,923 1,099,988 5,196,289 2,434,477 2,545,928 48.9% 25.5% 131.0% 36.7% 19.8% $6,000 N $5,000 N $4,000 0 ° $3,000 t r $2,000 $1,000 $0 4 United City of Yorkville Water Fund 51 WATER FUND REVENUE FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended Taxes 51-000-40-00-4000 PROPERTY TAXES-2007A BOND 41,403 5,210 - - Total: Taxes $41,403 $5,210 $0 $0 $0 Licenses&Permits 51-000-42-004216 BUILD PROGRAM PERMIT 84,544 112,323 162,468 - 171,840 Total: Licenses&Permits $84,544 $112,323 $162,468 $0 $171,840 Charges for Services 51-000-44-00-4424 WATER SALES 1,789,296 2,019,810 2,463,058 2,783,000 2,783,000 51-000-44-00-4425 BULK WATER SALES 4,750 29,590 (6,660) 500 500 51-000-44-00-4426 LATE PENALTIES-WATER 92,386 91,488 101,208 90,000 90,000 51-000-44-00-4430 WATER METER SALES 47,785 15,782 38,102 35,000 35,000 51-000-44-00-4440 WATER INFRASTRUCTURE FEE 341,083 343,961 717,028 702,900 702,900 51-000-44-00-4450 WATER CONNECTION FEES 34,650 13,160 149,170 50,000 50,000 Total: Charges for Services $2,309,950 $2,513,791 $3,461,906 $3,661,400 $3,661,400 Investment Earnings 51-00045-00-4500 INVESTMENT EARNINGS 2,231 1,236 5,492 1,000 1,000 51-00045-00-4550 GAIN ON INVESTMENT - 798 - - - Total: Investment Earnings $2,231 $2,034 $5,492 $1,000 $1,000 Reimbursements 51-000-46-004690 REIMB-MISCELLANEOUS 14,844 3,970 4,605 - - Total: Reimbursements $14,844 $3,970 $4,605 $0 $0 Miscellaneous 51-000-48-00-4820 RENTAL INCOME 51,917 55,560 56,888 57,433 57,433 51-000-48-00-4850 MISCELLANEOUS INCOME - 2,215 373 - - Total: Miscellaneous $51,917 $57,775 $57,261 $57,433 $57,433 Other Financing Sources 51-00049-00-4900 BOND PROCEEDS - - 4,100,000 - - 51-000-49-00-4902 BOND ISSUANCE 1,263,500 - 5,800,000 51-00049-00-4903 PREMIUM ON BOND ISSUANCE 26,599 193,723 449,023 51-00049-00-4952 TRANSFER FROM SEWER 82,988 83,588 76,275 75,075 75,075 Total: Other Financing Sources $82,988 $1,373,687 $4,369,998 $75,075 $6,324,098 Total: WATER FUND REVENUE $2,587,877 $4,068,790 $8,061,730 $3,794,908 $10,215,771 5 United City of Yorkville Water Fund 510 WATER OPERATIONS FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended Salaries 51-510-50-00-5010 SALARIES&WAGES 325,817 343,733 365,077 375,044 375,044 51-510-50-00-5015 PART-TIME SALARIES - 2,808 3,611 29,800 29,800 51-510-50-00-5020 OVERTIME 13,142 7,557 7,331 12,000 12,000 Total: Salaries $338,959 $354,098 $376,019 $416,844 $416,844 Benefits 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION 37,447 39,878 40,267 41,801 41,801 51-510-52-00-5214 FICA CONTRIBUTION 24,787 25,689 27,354 30,854 30,854 51-510-52-00-5216 GROUP HEALTH INSURANCE 92,981 113,371 113,806 139,623 139,623 51-510-52-00-5222 GROUP LIFE INSURANCE 675 701 777 705 705 51-510-52-00-5223 DENTAL INSURANCE 5,516 7,130 8,712 9,757 9,757 51-510-52-00-5224 VISION INSURANCE 729 793 1,131 1,131 1,131 51-510-52-00-5230 UNEMPLOYMENT INSURANCE 574 716 1,785 2,000 2,000 51-510-52-00-5231 LIABILITY INSURANCE 23,060 22,752 25,115 26,622 26,622 Total: Benefits $185,769 $211,030 $218,947 $252,493 $252,493 Contractual Services 51-510-54-00-5402 BOND ISSUANCE COSTS - 24,378 40,456 - 55,732 51-510-54-00-5405 BUILD PROGRAM 85,544 112,323 162,468 - 171,840 51-510-54-00-5412 TRAINING&CONFERENCES 3,044 2,305 3,072 6,500 6,500 51-510-54-00-5415 TRAVEL&LODGING 528 942 1,193 1,600 1,600 51-510-54-00-5426 PUBLISHING&ADVERTISING 787 148 211 1,000 1,000 51-510-54-00-5429 WATER SAMPLES 11,340 9,823 6,842 14,000 14,000 51-510-54-00-5430 PRINTING&DUPLICATING 61 112 2,679 3,300 3,300 51-510-54-00-5440 TELECOMMUNICATIONS 20,065 20,221 24,715 24,500 24,500 51-510-54-00-5445 TREATMENT FACILITY SERVICES 119,912 108,905 113,208 112,000 112,000 51-510-54-00-5448 FILING FEES 5,831 4,253 3,753 6,500 6,500 51-510-54-00-5452 POSTAGE&SHIPPING 16,276 17,953 18,206 19,000 19,000 51-510-54-00-5460 DUES&SUBSCRIPTIONS 1,568 978 1,080 1,600 1,600 51-510-54-00-5462 PROFESSIONAL SERVICES 21,047 20,343 47,595 21,500 21,500 51-510-54-00-5465 ENGINEERING SERVICES - - 187,840 62,160 62,160 51-510-54-00-5466 LEGAL SERVICES - - - 2,000 2,000 51-510-54-00-5480 UTILITIES 218,196 245,641 239,114 280,132 280,132 51-510-54-00-5483 JULIE SERVICES 4,520 4,570 4,300 5,000 5,000 51-510-54-00-5485 RENTAL&LEASE PURCHASE 504 504 464 1,000 1,000 51-510-54-00-5489 DOSS ON INVESTMENT - 16,036 - - - 51-510-54-00-5490 VEHICLE MAINTENANCE SERVICES 3,181 7,077 14,551 15,000 15,000 6 United City of Yorkville Water Fund 510 WATER OPERATIONS FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended 51-510-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 19,460 3,380 6,994 19,000 19,000 51-510-54-00-5498 PAYING AGENT FEES 1,338 2,354 2,241 2,295 2,295 51-510-54-00-5499 BAD DEBT 7,973 6,893 6,219 9,000 9,000 Total: Contractual Services $541,175 $609,139 $887,201 $607,087 $834,659 Supplies 51-510-56-00-5600 WEARING APPAREL 3,340 3,434 5,194 4,410 4,410 51-510-56-00-5620 OPERATING SUPPLIES 8,167 12,352 5,993 16,750 16,750 51-510-56-00-5628 VEHICLE MAINTENACE SUPPLIES 1,092 2,314 1,082 10,000 10,000 51-510-56-00-5630 SMALL TOOLS&EQUIPMENT 1,429 1,921 1,144 2,000 2,000 51-510-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 876 1,616 641 2,000 2,000 51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 125,445 146,540 151,829 173,250 173,250 51-510-56-00-5640 REPAIR&MAINTENANCE 20,785 20,263 12,970 15,000 15,000 51-510-56-00-5664 METERS&PARTS 51,805 32,520 72,039 46,000 46,000 51-510-56-00-5665 JULIE SUPPLIES 968 1,788 1,272 1,500 1,500 51-510-56-00-5695 GASOLINE 29,622 22,956 13,938 26,750 26,750 Total: Supplies $243,529 $245,704 $266,102 $297,660 $297,660 Capital Outlay 51-510-60-00-6022 WELL REHABILITATIONS - - 128,876 124,000 124,000 51-510-60-00-6025 ROAD TO BETTER ROADS PROGRAM 153,305 277,372 259,341 250,000 250,000 51-510-60-00-6059 US34(IL RT47/ORCHARD RD)PROJECT - - - 22,124 22,124 51-510-60-00-6060 EQUIPMENT - 5,000 5,000 51-510-60-00-6066 RTE 71 WATERMAIN REPLACEMENT 15,955 5,000 5,000 51-510-60-00-6070 VEHICLES - - - 63,000 63,000 51-510-60-00-6079 ROUTE 47 EXPANSION 129,094 197,544 197,544 197,544 197,544 51-510-60-00-6082 COUNTRYSIDE PKY IMPROVEMENTS - - 468,020 2,940,000 2,940,000 Total: Capital Outlay $282,399 $474,916 $1,069,736 $3,606,668 $3,606,668 7 United City of Yorkville Water Fund 510 WATER OPERATIONS FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended Debt Service-2015A Bond 51-510-77-00-8000 PRINCIPAL PAYMENT 73,540 73,540 51-510-77-00-8050 INTEREST PAYMENT - - - 229,137 229,137 Total: Debt Service-2015A Bond $0 $0 $0 $302,677 $302,677 Debt Service-2007A Bond 51-510-83-00-8000 PRINCIPAL PAYMENT 15,000 15,000 15,000 15,000 15,000 51-510-83-00-8050 INTEREST PAYMENT 123,041 122,423 121,793 121,163 121,163 Total: Debt Service-2007A Bond $138,041 $137,423 $136,793 $136,163 $136,163 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 33,150 29,350 25,450 21,450 21,450 Total: Debt Service-2003 Debt Certificates $133,150 $129,350 $125,450 $121,450 $121,450 Debt Service-2006A Refunding Debt Certificates 51-510-87-00-8000 PRINCIPAL PAYMENT 405,000 420,000 435,000 460,000 460,000 51-510-87-00-8050 INTEREST PAYMENT 205,606 189,406 172,606 155,206 155,206 Total: Debt Service-2006A Refunding $610,606 $609,406 $607,606 $615,206 $615,206 Debt Service-2005C Bond 51-510-88-00-8000 PRINCIPAL PAYMENT 95,000 100,000 - - - 51-510-88-00-8050 INTEREST PAYMENT 70,975 54,065 - - - Total: Debt Service-2005C Bond $165,975 $154,065 $0 $0 $0 Debt Service-IEPA Loan L17-156300 51-510-89-00-8000 PRINCIPAL PAYMENT 89,961 92,224 94,544 96,923 96,923 51-510-89-00-8050 INTEREST PAYMENT 35,069 32,806 30,486 28,108 28,108 Total: Debt Service-IL EPA Loan 156300 $125,030 $125,030 $125,030 $125,031 $125,031 Debt Service-2014C Refunding Bond 51-510-94-00-8000 PRINCIPAL PAYMENT - - 120,000 120,000 120,000 51-510-94-00-8050 INTEREST PAYMENT 13,111 32,550 30,150 30,150 Total: Debt Service-2014C Ref Bond $0 $13,111 $152,550 $150,150 $150,150 Other Financing Uses 51-510-99-00-9960 PAYMENT TO ESCROW AGENT 1,256,453 - - 6,193,291 Total: Other Financing Uses $0 $1,256,453 $0 $0 $6,193,291 Total: WATER OPERATIONS $2,764,633 $4,319,725 $3,965,434 $6,631,429 $13,052,292 8 PARKS & RECREATION FUND (79) 1 Schedule A - 3 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 2017 FY 2014 FY 2015 FY 2016 Adopted Amended Actual Actual Actual Budget Budget Revenue Charges for Service 299,478 352,714 408,469 355,000 355,000 Investment Earnings 382 698 369 350 350 Reimbursements 35,728 7,502 12,890 - - Miscellaneous 188,824 177,755 219,704 181,000 181,000 Other Financing Sources 1,765,504 1,277,606 1,076,831 1,118,638 1,118,638 Total Revenue 2,289,916 1,816,275 1,718,263 1,654,988 1,654,988 Expenditures Salaries 708,142 775,138 723,194 816,544 816,544 Benefits 312,171 338,380 325,538 385,075 385,075 Contractual Services 217,004 374,840 251,733 260,710 334,618 Supplies 337,444 316,864 474,571 334,666 334,666 Total Expenditures 2,063,804 1,805,222 1,775,036 1,796,995 1,870,903 Surplus(Deficit) 226,112 11,053 (56,773) (142,007) (215,915) Ending Fund Balance 546,485 557,536 500,762 269,255 2842847 26.5% 30.9% 28.2% 15.0% 15.2% $600 Fund Balance N $500 -o N $400 0 0 F $300 $200 $100 $0 9 United City of Yorkville Parks and Recreation Fund 79 PARKS AND RECREATION FUND REVENUE FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended Charges for Services 79-000-44-00-4402 SPECIAL EVENTS 47,745 72,025 100,756 80,000 80,000 79-000-44-00-4403 CHILD DEVELOPMENT 81,114 103,683 110,861 100,000 100,000 79-000-44-00-4404 ATHLETICS AND FITNESS 139,158 147,481 163,420 145,000 145,000 79-000-44-00-4441 CONCESSION REVENUE 31,461 29,525 33,432 30,000 30,000 Total: Charges for Services $299,478 $352,714 $408,469 $355,000 $355,000 Investment Earnings 79-000-45-00-4500 INVESTMENT EARNINGS 382 698 369 350 350 Total: Investment Earnings $382 $698 $369 $350 $350 Reimbursements 79-000-46-00-4690 REIMB-MISCELLANEOUS 35,728 7,502 12,890 - - Total: Reimbursements $35,728 $7,502 $12,890 $0 $0 Miscellaneous 79-000-48-00-4820 RENTAL INCOME 52,859 44,860 50,921 50,000 50,000 79-000-48-00-4825 PARK RENTALS 34,559 28,928 19,602 5,000 5,000 79-000-48-00-4843 HOMETOWN DAYS 90,597 88,475 106,579 108,000 108,000 79-000-48-00-4846 SPONSORSHIPS/DONATIONS 4,582 9,317 18,917 15,000 15,000 79-000-48-00-4850 MISCELLANEOUS INCOME 6,227 6,175 23,685 3,000 3,000 Total: Miscellaneous $188,824 $177,755 $219,704 $181,000 $181,000 Other Financing Sources 79-000-49-00-4901 TRANSFER FROM GENERAL 1,765,504 1,277,606 1,076,831 1,118,638 1,118,638 Total: Other Financing Sources $1,765,504 $1,277,606 $1,076,831 $1,118,638 $1,118,638 Total: PARKS&REC REVENUE $2,289,916 $1,816,275 $1,718,263 $1,654,988 $1,654,988 10 United City of Yorkville Parks and Recreation Fund 790 PARKS DEPARTMENT EXPENDITURES FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended Salaries 79-790-50-00-5010 SALARIES&WAGES 410,777 448,491 387,634 405,322 405,322 79-790-50-00-5015 PART-TIME SALARIES 17,207 32,644 24,382 40,178 40,178 79-790-50-00-5020 OVERTIME 514 932 1,884 3,000 3,000 Total: Salaries $428,498 $482,067 $413,900 $448,500 $448,500 Benefits 79-790-52-00-5212 RETIREMENT PLAN CONTRIBUTION 46,293 51,195 41,923 44,098 44,098 79-790-52-00-5214 FICA CONTRIBUTION 31,909 36,172 30,890 33,797 33,797 79-790-52-00-5216 GROUP HEALTH INSURANCE 109,505 109,775 102,203 126,121 126,121 79-790-52-00-5222 GROUP LIFE INSURANCE 878 942 790 724 724 79-790-52-00-5223 DENTAL INSURANCE 6,873 8,959 7,978 9,119 9,119 79-790-52-00-5224 VISION INSURANCE 957 940 947 1,023 1,023 Total: Benefits $196,415 $207,983 $184,731 $214,882 $214,882 Contractual Services 79-790-54-00-5412 TRAINING&CONFERENCES 1,663 3,045 2,136 7,000 7,000 79-790-54-00-5415 TRAVEL&LODGING 114 453 85 3,000 3,000 79-790-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK - 109,650 - - 53,908 79-790-54-00-5440 TELECOMMUNICATIONS 3,913 3,776 5,312 3,510 3,510 79-790-54-00-5462 PROFESSIONAL SERVICES 1,786 4,229 7,206 3,000 3,000 79-790-54-00-5466 LEGAL SERVICES 5,216 12,084 5,415 6,000 6,000 79-790-54-00-5485 RENTAL&LEASE PURCHASE 2,600 1,192 2,461 2,500 2,500 79-790-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 37,059 41,995 36,800 47,500 47,500 Total: Contractual Services $52,351 $176,424 $59,415 $72,510 $126,418 Supplies 79-790-56-00-5600 WEARING APPAREL 4,806 4,643 5,759 5,182 5,182 79-790-56-00-5610 OFFICE SUPPLIES 71 85 347 300 300 79-790-56-00-5620 OPERATING SUPPLIES 32,327 18,295 146,681 22,500 22,500 79-790-56-00-5630 SMALL TOOLS&EQUIPMENT 4,288 9,081 5,518 4,500 4,500 79-790-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - 2,000 2,000 500 500 79-790-56-00-5640 REPAIR&MAINTENANCE 79,678 60,514 64,517 56,000 56,000 79-790-56-00-5695 GASOLINE 20,202 17,283 11,694 21,400 21,400 Total: Supplies $141,372 $111,901 $236,516 $110,382 $110,382 Total: PARK DEPT EXPENDITURES $818,636 $978,375 $894,562 $846,274 $900,182 11 United City of Yorkville Parks and Recreation Fund 795 RECREATION DEPARTMENT EXPENDITURES FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended Salaries 79-795-50-00-5010 SALARIES&WAGES 225,784 240,199 261,071 280,333 280,333 79-795-50-00-5015 PART-TIME SALARIES 13,524 11,439 6,537 22,711 22,711 79-795-50-00-5045 CONCESSION WAGES 10,707 8,625 7,549 15,000 15,000 79-795-50-00-5046 PRE-SCHOOL WAGES 13,691 24,223 23,902 25,000 25,000 79-795-50-00-5052 INSTRUCTORS WAGES 15,938 8,585 10,235 25,000 25,000 Total: Salaries $279,644 $293,071 $309,294 $368,044 $368,044 Benefits 79-795-52-00-5212 RETIREMENT PLAN CONTRIBUTION 28,294 28,192 28,362 32,976 32,976 79-795-52-00-5214 FICA CONTRIBUTION 20,639 21,830 23,119 28,068 28,068 79-795-52-00-5216 GROUP HEALTH INSURANCE 62,448 74,560 83,005 101,075 101,075 79-795-52-00-5222 GROUP LIFE INSURANCE 524 551 618 559 559 79-795-52-00-5223 DENTAL INSURANCE 3,360 4,731 4,987 6,716 6,716 79-795-52-00-5224 VISION INSURANCE 491 533 716 799 799 Total: Benefits $115,756 $130,397 $140,807 $170,193 $170,193 Contractual Services 79-795-54-00-5412 TRAINING&CONFERENCES 1,191 3,543 3,481 5,000 5,000 79-795-54-00-5415 TRAVEL&LODGING 114 217 354 3,000 3,000 79-795-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK - - - - 20,000 79-795-54-00-5426 PUBLISHING&ADVERTISING 28,259 42,314 49,207 45,000 45,000 79-795-54-00-5440 TELECOMMUNICATIONS 6,573 6,603 7,231 8,000 8,000 79-795-54-00-5447 SCHOLARSHIPS 585 420 121 2,500 2,500 79-795-54-00-5452 POSTAGE&SHIPPING 1,694 2,964 1,008 3,500 3,500 79-795-54-00-5460 DUES&SUBSCRIPTIONS 1,688 1,917 1,231 2,500 2,500 79-795-54-00-5462 PROFESSIONAL SERVICES 75,999 81,047 94,358 80,000 80,000 79-795-54-00-5480 UTILITIES 12,224 15,413 10,596 21,200 21,200 79-795-54-00-5485 RENTAL&LEASE PURCHASE 4,035 3,602 3,019 4,500 4,500 79-795-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 23,816 8,580 6,770 3,000 3,000 79-795-54-00-5496 PROGRAM REFUNDS 8,475 9,819 14,942 10,000 10,000 79-795-54-00-5497 PROPERTY TAX PAYMENTS - 21,977 - - - Total: Contractual Services $164,653 $198,416 $192,318 $188,200 $208,200 Supplies 79-795-56-00-5602 HOMETOWN DAYS SUPPLIES 91,422 85,480 94,845 100,000 100,000 79-795-56-00-5606 PROGRAM SUPPLIES 62,594 89,074 108,100 86,000 86,000 12 United City of Yorkville Parks and Recreation Fund 795 RECREATION DEPARTMENT EXPENDITURES FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended 79-795-56-00-5607 CONCESSION SUPPLIES 16,472 15,812 19,299 18,000 18,000 79-795-56-00-5610 OFFICE SUPPLIES 1,993 3,406 2,212 3,000 3,000 79-795-56-00-5620 OPERATING SUPPLIES 21,325 8,086 11,373 12,500 12,500 79-795-56-00-5630 SMALL TOOLS&EQUIPMENT - - 399 1,000 1,000 79-795-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - 500 500 79-795-56-00-5640 REPAIR&MAINTENANCE 1,527 2,101 1,009 2,000 2,000 79-795-56-00-5695 GASOLINE 739 1,004 818 1,284 1,284 Total: Supplies $196,072 $204,963 $238,055 $224,284 $224,284 Other Financing Uses 79-795-99-00-9980 TRANSFER TO RECREATION CENTER 489,043 - - - - Total: Other Financing Uses $489,043 $0 $0 $0 $0 Total: RECREATION EXPENDITURES $1,245,168 $826,847 $880,474 $950,721 $970,721 13 Schedule A - 4 VEHICLE & EQUIPMENT FUND (25) This fund primarily derives its revenue from monies collected from building permits,fines and development fees. Revenues are used to purchase vehicles and equipment for use in the operations of the Police,Public Works Street Operations and Park&Recreation departments. FY 2017 FY 2017 FY 2014 FY 2015 FY 2016 Adopted Amended Actual Actual Actual Budget Budget Revenue Licenses&Permits 76,414 59,700 89,150 26,000 54,700 Fines&Forfeits 8,253 9,181 11,374 10,200 10,200 Charges for Service 157,495 301,715 374,386 275,633 275,633 Investment Earnings 446 449 43 50 50 Reimbursements 50,000 97,771 - - - Miscellaneous 12,819 2,193 53,073 3,000 3,000 Total Revenue 305,427 471,009 528,026 314,883 343,583 Expenditures Contractual Services 50,250 51,714 52,553 18,583 47,283 Supplies - 499 - 2,000 2,000 Capital Outlay 154,582 387,929 506,175 254,000 254,000 Debt Service 78,437 73,035 73,034 73,034 73,034 Other Financing Uses 50,000 - - - - Total Expenditures 333,269 513,177 631,762 347,617 376,317 Surplus(Deficit) (27,842) (42,168) (103,736) (32,734) (32,734) Ending Fund Balance 147,746 105,577 1,841 0 (30,893) 44.3% 20.6% 0.3% 0.0% -8.2% $200 -o $150 c 3 $100 0 ~ $50 $0 ($50) 14 United City of Yorkville Vehicle & Equipment Fund 25 VEHICLE&EQUIPMENT FUND REVENUE FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended Licenses&Permits 25-000-42-00-4215 DEVELOPMENT FEES-POLICE CAPITAL 11,750 5,175 12,900 7,000 7,000 25-000-42-00-4216 BUILD PROGRAM PERMITS 30,960 42,920 43,410 - 28,700 25-000-42-00-4217 WEATHER WARNING SIREN FEES 12,264 - - - - 25-000-42-00-4218 ENGINEERING CAPITAL FEES 3,400 1,300 3,250 3,000 3,000 25-000-42-00-4219 DEVELOPMENT FEES-PW CAPITAL 16,390 9,655 26,240 15,000 15,000 25-00042-00-4220 DEVELOPMENT FEES-PARK CAPITAL 1,650 650 1,625 1,000 1,000 25-000-42-00-4224 RENEW PROGRAM PERMITS - - 1,725 - - Total: Licenses&Permits $76,414 $59,700 $89,150 $26,000 $54,700 Fines&Forfeits 25-000-43-00-4315 DUI FINES 7,569 5,545 10,803 7,000 7,000 25-00043-00-4316 ELECTRONIC CITATION FEES 684 720 571 700 700 25-000-43-00-4340 SEIZED VEHICLE PROCEEDS - 2,916 - 2,500 2,500 Total: Fines&Forfeits $8,253 $9,181 $11,374 $10,200 $10,200 Charges for Service 25-00044-00-4418 MOWING INCOME 12,845 3,288 5,744 3,000 3,000 25-000-44-00-4420 POLICE CHARGEBACK - 63,777 174,263 153,633 153,633 25-000-44-00-4421 PUBLIC WORKS CHARGEBACK 144,650 125,000 194,379 45,000 45,000 25-00044-00-4421 PARKS&RECREATION CHARGEBACK - 109,650 - 74,000 74,000 Total: Charges for Service $157,495 $301,715 $374,386 $275,633 $275,633 Investment Earnings 25-00045-00-4522 INVESTMENT EARNINGS-PARK CAPITAL 446 312 43 50 50 25-00045-00-4550 GAIN ON INVESTMENT-PARK CAPITAL - 137 - - - Total: Investment Earnings $446 $449 $43 $50 $50 Reimbursements 25-000-46-00-4692 REIMB-MISCELLANEOUS PARK CAPITAL 50,000 97,771 - - - Total: Reimbursements $50,000 $97,771 $0 $0 $0 Miscellaneous 25-000-48-00-4852 MISCELLANEOUS INCOME-POLICE CAPITAL 4,064 191 624 - - 25-000-48-00-4854 MISCELLANEOUS INCOME-PW CAPITAL 930 2,002 3,929 2,000 2,000 25-000-48-004855 MISCELLANEOUS INCOME-PARK CAPITAL - 74 25-000-49-00-4920 SALE OF CAPITAL ASSETS-POLICE CAPITAL 7,825 3,475 1,000 1,000 25-000-49-004921 SALE OF CAPITAL ASSETS-PW CAPITAL - 44,171 - - 25-000-49-00-4922 SALE OF CAPITAL ASSETS-PARK CAPITAL - - 800 - - Total: Miscellaneous $12,819 $2,193 $53,073 $3,000 $3,000 Total: VEHICLE&EQUIP REVENUE $305,427 $471,009 $528,026 $314,883 $343,583 15 United City of Yorkville Vehicle & Equipment Fund 205 POLICE CAPITAL EXPENDITURES FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended Contractual Services 25-205-54-00-5405 BUILD PROGRAM 4,800 10,350 9,750 2,700 25-205-54-00-5406 RENEW PROGRAM - - 450 - - 25-205-54-00-5462 PROFESSIONAL SERVICES 95 1,166 - 833 833 25-205-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 17,626 4,287 5,517 16,000 16,000 Total: Contractual Services $22,521 $15,803 $15,717 $16,833 $19,533 Capital Outlay 25-205-60-00-6060 EQUIPMENT - 32,865 2,369 - - 25-205-60-00-6070 VEHICLES 93,750 79,377 194,750 155,000 155,000 Total: Capital Outlay $93,750 $112,242 $197,119 $155,000 $155,000 Total: POLICE CAPITAL EXPENDITURES $116,271 $128,045 $212.836 17$ 1,833 $174,533 16 United City of Yorkville Vehicle & Equipment Fund 215 PUBLIC WORKS CAPITAL EXPENDITURES FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended Contractual Services 25-215-54-00-5405 BUILD PROGRAM 25,360 31,020 32,510 25,950 25-215-54-00-5406 RENEW PROGRAM - - 1,200 - - 25-215-54-00-5448 FILING FEES 1,569 588 1,901 1,750 1,750 Total: Contractual Services $26,929 $31,608 $35,611 $1,750 $27,700 Supplies 25-215-56-00-5620 OPERATING SUPPLIES - 499 - 2,000 2,000 Total: Supplies $0 $499 $0 $2,000 $2,000 Capital Outlay 25-215-60-00-6060 EQUIPMENT 48,689 163,750 15,084 - - 25-215-60-00-6070 VEHICLES - - 169,807 45,000 45,000 Total: Capital Outlay $48,689 $163,750 $184,891 $45,000 $45,000 Debt Service-Public Works Building 25-215-92-00-8000 PRINCIPAL PAYMENT 33,184 37,924 39,638 41,430 41,430 25-215-92-00-8050 INTEREST PAYMENT 42,870 32,892 31,177 29,385 29,385 Total: Debt Service-PW Building $76,054 $70,816 $70,815 $70,815 $70,815 Total: PW CAPITAL EXPENDITURES $151,672 $266,673 $291,317 $119,565 $145,515 17 United City of Yorkville Vehicle & Equipment Fund 225 PARKS&RECREATION CAPITAL EXPENDITURES FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended Contractual Services 25-225-54-00-5405 BUILD PROGRAM 800 1,550 1,150 50 25-225-54-00-5406 RENEW PROGRAM - - 75 25-225-54-00-5489 LOSS ON INVESTMENT - 2,753 - - - Total: Contractual Services $800 $4,303 $1,225 $0 $50 Capital Outlay 25-225-60-00-6060 EQUIPMENT 12,143 33,731 78,936 54,000 54,000 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 - - Total: Capital Outlay $12,143 $111,937 $124,165 $54,000 $54,000 Debt Service-Public Works Building 25-225-92-00-8000 PRINCIPAL PAYMENT 1,040 1,188 1,242 1,298 1,298 25-225-92-00-8050 INTEREST PAYMENT 1,343 1,031 977 921 921 Total: Debt Service-PW Building $2,383 $2,219 $2,219 $2,219 $2,219 Other Financing Uses 25-225-99-00-9972 TRANSFER TO LAND CASH 50,000 - - - - Total: Other Financing Uses $50,000 $0 $0 $0 $0 Total: PW CAPITAL EXPENDITURES6$ 5,326 $118,459 $127,609 $56,219 $56,269 18