Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Ordinance 2016-48
STATE of ItLIYOIS COUNT'S OF KENOpLL - FILED - AuG 0 9 2016 MUM aRK Luau.coueirr UNITED CITY OF YORKVILLE KENDALL COUNTY, ILLINOIS ORDINANCE NO. 2016-48 AN ORDINANCE AUTHORIZING THE FIRST 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 26`x'day of July, 2016 Published in pamphlet form by the authority of the Mayor and City Council of the United City of Yorkville,Kendall County, Illinois on August 8, 2016. S UTE OF ILLINOIS COUNTY OF NENIJAM FILED - Ordinance No. 2016-4T AUG 0 y 2016 "" - am AN ORDINANCE AUTHORIZING THE FIRST AMENDMENT TO THE A1' UKI, COUM 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 General, Water, Vehicle &Equipment, and Downtown TIF funds with respect to the United City of Yorkville's 2016-2017 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.201649 Page 2 Passed by the Cit Council of the United City of Yorkville, Kendall County inois this day of , 2016. /L* AA-A4 CITY CLE9� CARLO COLOSIMO 1 KEN KOCH JACKIE MILSCHEWSKI LARRY KOT CHRIS FUNKHOUSER JOEL FRIEDERS DIANE TEELING _ SEAVER TARULIS ----� Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this 3 day of jgt46USi 2016. M OR Ordinance No.2016-1-8 Page 3 GENERAL FUND (01) Schedule A - 1 The General Fund is the City's primary operating fund. It accounts for major tax revenue used to support administrative and public safety functions. Unaudited FY 2017 FY 2017 FY 2014 FY 2015 FY 2016 Adopted Amended Actual Actual Actual Budget Budget Revenue Taxes 9,607,999 10,052,792 10,330,920 10,384,836 10,384,836 Intergovernmental 2,120,327 2,295,134 2,302,096 2,313,586 2,313,586 Licenses&Permits 168,119 173,126 215,661 178,000 178,000 Fines&Forfeits 173,954 137,252 123,639 130,225 130,225 Charges for Service 1,175,166 1,290,493 1,401,384 1,423,175 1,423,175 Investment Earnings 8,792 8,909 6,394 5,000 5,000 Reimbursements 168,974 168,182 103,860 55,000 55,000 Miscellaneous 19,335 22,813 22,112 24,000 24,000 Other Financing Sources 2,479 2,209 7,077 3,000 3,000 Total Revenue 13,445,145 14,150,910 14,513,143 14,516,822 14,516,822 Expenditures Salaries 3,437,661 3,721,840 3,958,489 4,315,553 4,335,553 Benefits 2,052,895 2,334,546 2,447,779 2,798,284 2,798,284 Contractual Services 4,267,482 4,387,516 4,599,662 4,731,040 4,796,040 Supplies 247,990 254,650 209,166 326,761 271,761 Contingencies 11,676 - - - - Other Financing Uses 3,790,688 2,486,885 2,447,332 2,631,459 2,631,459 Total Expenditures 13,808,392 13,185,437 13,662,428 14,803,097 14,833,097 Surplus(Deficit) (363,247) 965,473 850,715 (286,275) (316,275) Ending Fund Balance 3,860,581 4,826,059 5,676,774 4,727,411 5,360,499 28.0% 36.6% 41.6% 31.9% 361 $6,000 Fund Balance 3 $4,000 0 s ~ $2,000 $0 I 1 ' I ADMINISTRATION DEPARTMENT The Administration Department includes both elected official and management expenditures. Elected officials consist of the Mayor,City Council,Treasurer and Clerk. The City Administrator is hired by the Mayor with the consent of the City Council. City staff report to the City Administrator. It is the role of the City Administrator to direct staff in the daily administration of City services. Unaudited FY 2017 FY 2017 FY 2014 FY 2015 FY 2016 Adopted Amended Actual Actual Actual Budget Budget Expenditures Salaries 364,083 364,718 388,629 425,839 455,839 Benefits 219,042 242,710 150,348 165,333 165,333 Contractual Services 136,733 126,845 139,715 183,921 183,921 Supplies 8,287 7,198 10,624 10,850 10,850 Total Administration Department 728,145 741,471 689,316 785,943 815,943 $1,000 4A $800 CA -o c $600 0 r ~ $400 $200 $0 2 United City of Yorkville General Fund 110 ADMINISTRATION Unaudited FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended Salaries 01-110-50-00-5001 SALARIES-MAYOR 9,535 9,570 9,735 11,000 11,000 01-110-50-00-5002 SALARIES-LIQUOR COMMISIONER 1,000 1,000 1,000 1,000 1,000 01-110-50-00-5003 SALARIES-CITY CLERK 7,268 6,905 6,935 11,000 11,000 01-110-50-00-5004 SALARIES-CITY TREASURER 1,031 968 1,000 6,500 6,500 01-110-50-00-5005 SALARIES-ALDERMAN 47,190 47,960 48,690 52,000 52,000 01-110-50-00-5010 SALARIES-ADMINISTRATION 275,169 294,157 317,586 336,039 366,039 01-110-50-00-5015 PART-TIME SALARIES 22,646 4,158 3,683 7,800 7,800 Administrative Intern 01-110-50-00-5020 OVERTIME 244 - - 500 500 Total: Salaries $364,083 $364,718 $388,629 $425,839 $455,839 Benefits 01-110-52-00-5212 RETIREMENT PLAN CONTRIBUTION 36,794 37,723 36,387 37,405 37,405 01-110-52-00-5214 FICA CONTRIBUTION 25,473 24,296 25,422 28,931 28,931 01-110-52-00-5216 GROUP HEALTH INSURANCE 69,776 85,215 81,297 91,653 91,653 01-110-52-00-5222 GROUP LIFE INSURANCE 403 443 491 445 445 01-110-52-00-5223 DENTAL INSURANCE 4,252 5,387 5,516 6,178 6,178 01-110-52-00-5224 VISION INSURANCE 550 576 721 721 721 01-110-52-00-5235 ELECTED OFFICIAL-GROUP HEALTH INSURANCE 76,151 82,691 489 - - 01-110-52-00-5236 ELECTED OFFICIAL-GROUP LIFE INSURANCE 643 633 4 01-110-52-00-5237 ELECTED OFFICIAL-DENTAL INSURANCE 4,432 5,205 (40) 01-110-52-00-5238 ELECTED OFFICIAL-VISION INSURANCE 568 541 61 - - Total: Benefits $219,042 $242,710 $150,348 $165,333 $165,333 Contractual Services 01-110-54-00-5410 TUITION REIMBURSEMENT - - 3,216 15,000 15,000 01-110-54-00-5412 TRAINING&CONFERENCES 4,624 10,636 4,785 12,000 12,000 01-110-54-00-5415 TRAVEL&LODGING 7,843 3,356 8,896 9,000 9,000 01-110-54-00-5426 PUBLISHING&ADVERTISING 765 740 1,262 1,000 1,000 01-110-54-00-5430 PRINTING&DUPLICATING 3,503 4,094 2,890 5,500 5,500 01-110-54-00-5436 4TH OF JULY CONTRIBUTIONS 11,033 - - - - 01-110-54-00-5440 TELECOMMUNICATIONS 13,143 13,097 13,620 16,000 16,000 01-110-54-00-5448 FILING FEES 181 70 49 500 500 01-110-54-00-5451 CODIFICATION 2,468 3,003 12,002 5,000 5,000 01-110-54-00-5452 POSTAGE&SHIPPING 2,225 2,932 2,418 4,000 4,000 01-110-54-00-5460 DUES&SUBSCRIPTIONS 14,004 15,981 15,869 17,000 17,000 3 United City of Yorkville General Fund 110 ADMINISTRATION Unaudited FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended 01-110-54-00-5462 PROFESSIONAL SERVICES 8,355 9,112 19,236 29,600 29,600 Administrative Intern-NIU Contract 01-110-54-00-5473 KENDALL AREA TRANSIT 23,550 23,550 23,550 25,000 25,000 01-110-54-00-5480 UTILITIES 27,883 23,131 14,862 24,421 24,421 01-110-54-00-5485 RENTAL&LEASE PURCHASE 2,508 2,347 2,224 2,400 2,400 01-110-54-00-5488 OFFICE CLEANING 14,648 14,796 14,836 17,500 17,500 Total: Contractual Services $136,733 $126,845 $139,715 $183,921 $183,921 Supplies 01-110-56-00-5610 OFFICE SUPPLIES 8,287 7,120 10,574 10,000 10,000 01-110-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - 78 50 850 850 Total: Supplies $8,287 $7,198 $10,624 $10,850 $10,850 Total: ADMINISTRATION $728,145 $741,471 $689,316 $785,943 $815,943 4 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. Unaudited FY 2017 FY 2017 FY 2014 FY 2015 FY 2016 Adopted Amended Actual Actual Actual Budget Budget Expenditures Salaries 2,321,323 2,511,201 2,659,975 2,906,541 2,896,541 Benefits 1,208,317 1,411,567 1,565,443 1,833,415 1,833,415 Contractual Services 149,909 237,729 349,847 311,379 411,379 Supplies 132,585 154,654 98,647 203,450 148,450 Total Police Department 3,812,134 4,315,151 4,673,912 5,254,785 5,289,785 $6,000 y $5,000 v $4,000 ° $3,000 L H $2,000 $1,000 $0 5 United City of Yorkville General Fund 210 POLICE Unaudited FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended Salaries 01-210-50-00-5008 SALARIES-POLICE OFFICERS 1,307,670 1,478,093 1,585,447 1,730,357 1,720,357 01-210-50-00-5011 SALARIES-POLICE CHIEF&DEPUTIES 295,668 322,269 341,359 358,109 358,109 01-210-50-00-5012 SALARIES-SERGEANTS 426,850 433,191 447,154 475,680 475,680 01-210-50-00-5013 SALARIES-POLICE CLERKS 116,872 121,384 132,096 141,395 141,395 01-210-50-00-5014 SALARIES-CROSSING GUARD 21,950 21,429 22,945 20,000 20,000 01-210-50-00-5015 PART-TIME SALARIES 57,252 57,235 43,667 70,000 70,000 01-210-50-00-5020 OVERTIME 95,061 77,600 87,307 111,000 111,000 Total: Salaries $2,321,323 $2,511,201 $2,659,975 $2,906,541 $2,896,541 Benefits 01-210-52-00-5212 RETIREMENT PLAN CONTRIBUTION 12,938 13,778 14,283 15,271 15,271 01-210-52-00-5213 EMPLOYER CONTRI-POLICE PENSION 524,120 624,168 722,940 825,413 825,413 Police Pension Portion ofP-Tax Levy 01-210-52-00-5214 FICA CONTRIBUTION 171,085 184,653 195,360 216,838 216,838 01-210-52-00-5216 GROUP HEALTH INSURANCE 462,711 541,667 576,302 709,489 709,489 01-210-52-00-5222 GROUP LIFE INSURANCE 3,050 3,338 3,817 3,541 3,541 01-210-52-00-5223 DENTAL INSURANCE 30,626 39,727 46,802 56,584 56,584 01-210-52-00-5224 VISION INSURANCE 3,787 4,236 5,939 6,279 6,279 Total: Benefits $1,208,317 $1,411,567 $1,565,443 $1,833,415 $1,833,415 Contractual Services 01-210-54-00-5410 TUITION REIMBURSEMENT - - 3,216 31,096 31,096 01-210-54-00-5411 POLICE COMMISSION 4,590 12,633 996 4,000 4,000 01-210-54-00-5412 TRAINING&CONFERENCE 12,935 11,184 7,766 18,000 18,000 01-210-54-00-5415 TRAVEL&LODGING 3,963 2,400 2,783 10,000 10,000 01-210-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK - 63,777 174,979 53,633 153,633 Police Chargeback to Veh&Equip Fund 01-210-54-00-5426 PUBLISHING&ADVERTISING 517 - - 200 200 01-210-54-00-5430 PRINTING&DUPLICATING 2,370 3,222 4,863 4,500 4,500 01-210-54-00-5440 TELECOMMUNICATIONS 24,048 25,663 28,796 36,500 36,500 Includes Wireless Card Service for MDT's 01-210-54-00-5452 POSTAGE&SHIPPING 1,218 987 980 1,600 1,600 01-210-54-00-5460 DUES&SUBSCRIPTIONS 4,315 2,175 1,990 1,350 1,350 01-210-54-00-5462 PROFESSIONAL SERVICES 11,249 15,288 16,861 35,000 35,000 Includes SRT,Mobile Command Unit, Major Crimes Task Force&NEMRT Dues plus$15kforLexipol implementation �I 6 United City of Yorkville General Fund 210 POLICE Unaudited FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended 01-210-54-00-5466 LEGAL SERVICES - - - 5,000 5,000 01-210-54-00-5467 ADJUDICATION SERVICES 16,132 17,215 16,684 20,000 20,000 01-210-54-00-5469 NEW WORLD LIVE SCAN 12,434 13,269 16,921 17,500 17,500 01-210-54-00-5472 KENDALL CO.JUVE PROBATION 3,118 2,609 2,894 4,000 4,000 01-210-54-00-5484 MDT-ALERTS FEE 6,660 6,660 6,660 7,000 7,000 01-210-54-00-5485 RENTAL&LEASE PURCHASE 6,384 6,344 5,903 7,000 7,000 01-210-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 39,976 54,303 57,555 55,000 55,000 Total: Contractual Services $149,909 $237,729 $349,847 $311,379 $411,379 Supplies 01-210-56-00-5600 WEARING APPAREL 18,424 9,775 12,562 20,000 20,000 01-210-56-00-5610 OFFICE SUPPLIES 2,495 2,676 2,299 4,500 4,500 01-210-56-00-5620 OPERATING SUPPLIES 5,168 43,711 14,123 65,000 10,000 01-210-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 7,792 12,959 5,473 12,000 12,000 01-210-56-00-5640 REPAIR&MAINTENANCE 1,479 242 302 6,500 6,500 01-210-56-00-5650 COMMUNITY SERVICES 7,311 - 300 3,000 3,000 01-210-56-00-5690 BALLISTIC VESTS 8,009 3,035 5,281 4,200 4,200 Partially Reimbursable-DOJ Vest Grant 01-210-56-00-5695 GASOLINE 78,917 65,888 58,009 80,250 80,250 01-210-56-00-5696 AMMUNITION 2,990 16,368 298 8,000 8,000 Total: Supplies $132,585 $154,654 $98,647 $203,450 $148,450 Total: POLICE DEPARTMENT $3,812,134 $4,315,151 $4,673,912 $5,254,785 $5,289,785 7 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. Unaudited FY 2017 FY 2017 FY 2014 FY 2015 FY 2016 Adopted Amended Actual Actual Actual Budget Budget Expenditures Salaries 600 - 6,129 500 500 Benefits 287,892 299,167 326,795 350,297 350,297 Contractual Services 2,395,270 2,416,880 2,335,891 2,500,063 2,465,063 Supplies 1,711 - 20,046 5,000 5,000 Contingencies 11,676 - - - - Other Financing Uses 3,790,688 2,486,885 2,447,332 2,631,459 2,631,459 Total Administrative Services Department 6,487,837 5,202,932 5,136,193 5,487,319 5,452,319 $7,000 $6,000 c CU 3 $5,000 0 $4,000 $3,000 $2,000 $1,000 $0 I 8 United City of Yorkville General Fund 640 ADMINISTRATIVE SERVICES Unaudited FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended Salaries 01-640-50-00-5092 POLICE SPECIAL DETAIL WAGES 600 - 6,129 500 500 Total: Salaries $600 $0 $6,129 $500 $500 Benefits 01-640-52-00-5230 UNEMPLOYMENT INSURANCE 5,241 7,950 18,460 20,000 20,000 01-640-52-00-5231 LIABILITY INSURANCE 246,339 249,686 279,135 293,958 293,958 01-640-52-00-5240 RETIREES-GROUP HEALTH INSURANCE 35,091 40,078 27,988 35,725 35,725 01-640-52-00-5241 RETIREES-DENTAL INSURANCE 1,061 1,293 1,052 539 539 01-640-52-00-5242 RETIREES-VISION INSURANCE 160 160 160 75 75 Total: Benefits $287,892 $299,167 $326,795 $350,297 $350,297 Contractual Services 01-640-54-00-5418 PURCHASING SERVICES - - - 50,000 15,000 IGA with City of Oswego 01-640-54-00-5428 UTILITY TAX REBATE - 14,375 14,375 WM Wrigley Economic Incentive Agreement 01-640-54-00-5434 EXCISE TAX REBATE 42,787 - - - - 01-640-54-00-5439 AMUSEMENT TAX REBATE 22,130 48,513 60,628 55,000 55,000 NCG Cinemas Economic Incentive Agreement 01-640-54-00-5449 KENCOM 25,295 72,999 72,679 75,000 75,000 01-640-54-00-5450 INFORMATION TECHNOLOGY SERVICES 38,867 51,066 50,875 80,000 80,000 01-640-54-00-5456 CORPORATE COUNSEL 89,253 129,599 88,017 127,339 127,339 01-640-54-00-5461 LITIGATION COUNSEL 147,253 56,874 166,659 120,000 120,000 01-640-54-00-5463 SPECIAL COUNSEL 2,872 26,020 19,767 25,000 25,000 01-640-54-00-5465 ENGINEERING SERVICES 597,697 503,943 368,071 390,000 390,000 01-640-54-00-5475 CABLE CONSORTIUM FEE 76,508 80,204 86,054 85,000 85,000 01-640-54-00-5481 HOTEL TAX REBATE 59,045 65,438 72,375 68,400 68,400 90%of Hotel Tax proceeds are Rebated 01-640-54-00-5489 LOSS ON INVESTMENT - 69,382 - - - 01-640-54-00-5491 CITY PROPERTY TAX REBATE 1,369 1,293 1,286 1,500 1,500 01-640-54-00-5492 SALES TAX REBATE 861,234 848,634 857,583 913,949 913,949 01-640-54-00-5493 BUSINESS DISTRICT REBATE 325,724 357,076 368,899 372,000 372,000 Kendall Marketplace,Countryside&Downtown 01-640-54-00-5494 ADMISSIONS TAX REBATE 103,720 104,066 121,799 120,000 120,000 100%Rebated-Raging Waves 01-640-54-00-5499 BAD DEBT 1,516 1,773 1,199 2,500 2,500 Refuse Portion of Utility Billing Total: Contractual Services $2,395,270 $2,416,880 $2,335,891 $2,500,063 $2,465,063 9 United City of Yorkville General Fund 640 ADMINISTRATIVE SERVICES Unaudited FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended Supplies 01-640-56-00-5625 REIMBURSABLE REPAIRS 1,711 20,046 5,000 5,000 Canceled out by Reimb-Liability Insurance Total: Supplies $1,711 $0 $20,046 $5,000 $5,000 Contingencies 01-640-70-00-7799 CONTINGENCIES 11,676 - - - - Total: Contingencies $11,676 $0 $0 $0 $0 Other Financing Uses 01-640-99-00-9914 TRANSFER TO MUNICIPAL BLDG 571,615 - - - - 01-640-99-00-9915 TRANSFER TO MOTOR FUEL TAX - 323 25,407 25,023 25,023 01-640-99-00-9916 TRANSFER TO CW BUILDINGS&GROUNDS - 49,795 57,269 49,500 49,500 01-640-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL 270,401 - - - - 01-640-99-00-9942 TRANSFER TO DEBT SERVICE - - 127,243 268,178 268,178 01-640-99-00-9952 TRANSFER TO SEWER 1,137,220 1,133,972 1,134,654 1,134,052 1,134,052 01-640-99-00-9979 TRANSFER TO PARK&RECREATION 1,765,504 1,277,606 1,076,831 1,118,638 1,118,638 01-640-99-00-9982 TRANSFER TO LIBRARY OPERATIONS 45,948 25,189 25,928 36,068 36,068 Transfer to Offset Library Insurance charges Total: Other Financing Uses $3,790,688 $2,486,885 $2,447,332 $2,631,459 $2,631,459 Total: ADMINISTRATIVE SERVICES $6,487,837 $5,202,932 $5,136,193 $5,487,319 $5,452,319 10 Schedule A- 2 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. Unaudited 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 26,000 Fines&Forfeits 8,253 9,181 11,374 10,200 10,200 Charges for Service 157,495 301,715 375,102 101,633 201,633 Investment Earnings 446 449 43 50 50 Reimbursements 50,000 97,771 - - - Miscellaneous 4,994 2,193 4,627 2,000 2,000 Other Financing Sources 7,825 - 48,446 1,000 1,000 Total Revenue 305,427 471,009 528,742 140,883 240,883 Expenditures Contractual Services 50,250 51,714 53,081 18,583 18,583 Supplies - 499 - 2,000 2,000 Capital Outlay 154,582 387,929 506,813 100,000 200,000 Debt Service 78,437 73,035 73,034 73,034 73,034 Other Financing Uses 50,000 - - - - Total Expenditures 333,269 513,177 632,928 193,617 293,617 Surplus(Deficit) (27,842) (42,168) (104,186) (52,734) (52,734) Ending Fund Balance 147,746 105,577 1,391 0 (51,343) 44.3% 20.6% 0.2% 0.0% -17.5% E $zoo Fund Balance $150 M $100 N 3 r $50 $0 i ($50) ($100) 11 United City of Yorkville Vehicle & Equipment Fund 25 VEHICLE&EQUIPMENT FUND REVENUE Unaudited 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 - - 25-00042-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-004219 DEVELOPMENT FEES-PW CAPITAL 16,390 9,655 26,240 15,000 15,000 25-000-42-00-4220 DEVELOPMENT FEES-PARK CAPITAL 1,650 650 1,625 1,000 1,000 25-00042-00-4224 RENEW PROGRAM PERMITS - - 1,725 - - Total: Licenses&Permits $76,414 $59,700 $89,150 $26,000 $26,000 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-004340 SEIZED VEHICLE PROCEEDS - 2,916 - 2,500 2,500 Total: Fines&Forfeits $8,253 $9,181 $11,374 $10,200 $109200 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,979 53,633 153,633 25-000-44-004421 PUBLIC WORKS CHARGEBACK 144,650 125,000 194,379 45,000 45,000 25-000-44-00-4421 PARKS&RECREATION CHARGEBACK - 109,650 - - - Total: Charges for Service $157,495 $3019715 $375,102 $101,633 $201,633 Investment Earnings 25-000-45-00-4522 INVESTMENT EARNINGS-PARK CAPITAL 446 312 43 50 50 25-000-45-004550 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-00048-00-4852 MISCELLANEOUS INCOME-POLICE CAPITAL 4,064 191 624 - - 25-00048-00-4854 MISCELLANEOUS INCOME-PW CAPITAL 930 2,002 3,929 2,000 2,000 25-000-48-00-4855 MISCELLANEOUS INCOME-PARK CAPITAL - - 74 - - Total: Miscellaneous $4,994 $29193 $4,627 $2,000 $2,000 12 United City of Yorkville Vehicle & Equipment Fund 25 VEHICLE&EQUIPMENT FUND REVENUE Unaudited FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended Other Financing Sources 25-000-49-00-4920 SALE OF CAPITAL ASSETS-POLICE CAPITAL 7,825 3,475 1,000 1,000 25-000-49-00-4921 SALE OF CAPITAL ASSETS-PW CAPITAL - 44,171 - - 25-000-49-00-4922 SALE OF CAPITAL ASSETS-PARK CAPITAL - - 800 - - Total: Other Financing Sources $7,825 $0 $48,446 $1,000 $1,000 Total: VEHICLE&EQUIP REVENUE $305,427 $471,009 $528,742 $140,883 $240,883 13 United City of Yorkville Vehicle & Equipment Fund 205 POLICE CAPITAL EXPENDITURES Unaudited 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 25-205-54-00-5406 RENEW PROGRAM - - 450 - - 25-205-54-00-5462 PROFESSIONAL SERVICES 95 1,166 - 833 833 Portion of Seized Vehicles to Other Gov Agencies 25-205-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 17,626 4,287 6,045 16,000 16,000 Maint-Emergency Sirens&Lighting Detectors Total: Contractual Services $22,521 $15,803 $16,245 $16,833 $169833 Capital Outlay 25-205-60-00-6060 EQUIPMENT - 32,865 25,382 - - 25-205-60-00-6070 VEHICLES 93,750 79,377 171,925 55,000 155,000 Total: Capital Outlay $93,750 $112,242 $197,307 $55,000 $155,000 Total: POLICE CAPITAL EXPENDITURES $116,271 $128,045 $213,552 $71,833 $171,833 I� 14 DOWNTOWN TIF FUND (88) Schedule A - 3 The Downtown TIF was created in 2006,in order to finance a mixed use development in the downtown area. Unaudited FY 2017 FY 2017 FY 2014 FY 2015 FY 2016 Adopted Amended Actual Actual Actual Budget Budget Revenue Taxes 62,269 60,027 68,868 70,000 70,000 Investment Earnings 53 1 3 50 50 Miscellaneous 184 187 236 - - Other Financing Sources 8,500 - - - - Total Revenue 71,006 60,215 69,107 70,050 70,050 Expenditures Contractual Services 26,843 20,045 17,830 35,360 35,360 Capital Outlay 29,568 19,106 36,668 17,420 443,170 Other Financing Uses - 13,500 - - - Total Expenditures 56,411 52,651 54,498 52,780 478,530 Surplus(Deficit) 14,595 7,564 14,609 17,270 (408,480) Ending Fund Balance 231,259 239,096 253,705 (88,246) (154,775) 410.0% 454.1% 465.5% -167.2% -32.3% $300 $200 v c 0 $loo Fund Balance r ~ $0 ($100) ($200) 15 United City of Yorkville Downtown TIF Fund 88 DOWNTOWN TIF FUND REVENUE Unaudited FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended Taxes 88-000-40-00-4000 PROPERTY TAXES 52,811 60,027 68,868 70,000 70,000 88-00040-00-4070 BUSINESS DISTRICT TAX 9,458 - - - - Moved to General Fund Total: Taxes $62,269 $60,027 $68,868 $70,000 $70,000 Investment Earnings 88-000-45-00-4500 INVESTMENT EARNINGS 53 1 3 50 50 Total: Investment Earnings $53 $1 $3 $50 $50 Miscellaneous 88-000-48-00-4850 MISCELLANEOUS INCOME 184 187 236 - - Total: Miscellaneous $184 $187 $236 $0 $0 Other Financing Sources 88-000-49-00-4910 SALE OF CAPITAL ASSETS 8,500 - - - - Total: Other Financing Sources $8,500 $0 $0 $0 $0 Total: DOWNTOWN TIF REVENUE $71,006 $60,215 $69,107 $70,050 $70,050 16 United City of Yorkville Downtown TIF Fund 880 DOWNTOWN TIT FUND EXPENDITURES Unaudited FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended Contractual Services 88-880-54-00-5425 TIF INCENTIVE PAYOUT 12,315 16,196 15,223 20,000 20,000 88-880-54-00-5462 PROFESSIONAL SERVICES 258 276 2,051 360 360 88-880-54-00-5466 LEGAL SERVICES 4,812 3,573 556 15,000 15,000 88-880-54-00-5493 BUSINESS DISTRICT REBATE 9,458 - - - - Total: Contractual Services $26,843 $209045 $17,830 $35,360 $35,360 Capital Outlay 88-880-60-00-6000 PROJECT COSTS 9,568 11,686 29,248 10,000 125,000 88-880-60-00-6048 DOWNTOWN STREETSCAPE IMPROVEMENT - - - - 310,750 88-880-60-00-6079 ROUTE 47 EXPANSION 20,000 7,420 7,420 7,420 7,420 Total: Capital Outlay $29,568 $19,106 $36,668 $17,420 $443,170 Other Financing Uses 88-880-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL - 13,500 - - - Total: Other Financing Uses $0 $13,500 $0 $0 $0 Total: DOWNTOWN TIE EXPENDITURES 5$ 6,411 $52,651 $54,498 $52,780 $478,530 17 Schedule A - 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. Unaudited 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 - - 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 58,899 57,433 57,433 Other Financing Sources 82,988 1,373,687 4,369,998 75,075 75,075 Total Revenue 2,587,877 4,068,790 8,063,368 3,794,908 3,794,908 Expenditures Salaries 338,959 354,098 332,148 416,844 416,844 Benefits 185,769 211,030 210,900 252,493 252,493 Contractual Services 541,175 609,139 887,820 544,927 607,087 Supplies 243,529 245,704 265,483 297,660 297,660 Capital Outlay 282,399 474,916 1,048,578 3,482,668 3,606,668 Debt Service 1,172,802 1,168,385 1,147,429 1,450,677 1,450,677 Other Financing Uses - 1,256,453 - - - Total Expenses 2,764,633 4,319,725 3,892,358 6,445,269 6,631,429 Surplus(Deficit) (176,756) (250,935) 4,171,010 (2,650,361) (2,836,521) Ending Fund Balance Equivalent 1,350,923 1,099,988 5,270,998 1,760,405 2,434,477 48.9% 25.5% 135.4% 27.3% 36.7% $6,000 Fund Balance Equivalency y $5,000 v N $4,000 ° $3,000 r $2,000 $1,000 $0 I 18 United City of Yorkville Water Fund 51 WATER FUND REVENUE Unaudited 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-00-4216 BUILD PROGRAM PERMIT 84,544 112,323 162,468 - - Total: Licenses&Permits $84,544 $112,323 $162,468 $0 $0 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-000-45-00-4500 INVESTMENT EARNINGS 2,231 1,236 5,492 1,000 1,000 51-000-45-00-4550 GAIN ON INVESTMENT - 798 - - - Total: Investment Earnings $2,231 $2,034 $5,492 $1,000 $1,000 Reimbursements 51-000-46-00-4690 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 58,526 57,433 57,433 Prime Directive Water Tower Lease Sprint Water Tower Lease Verizon Water Tower Lease-Lehman Crossing 51-000-48-00-4850 MISCELLANEOUS INCOME - 2,215 373 - - Total: Miscellaneous $51,917 $57,775 $58,899 $57,433 $57,433 Other Financing Sources 51-000-49-00-4900 BOND PROCEEDS - - 4,100,000 - - 51-000-49-00-4902 BOND ISSUANCE 1,263,500 - 51-000-49-00-4903 PREMIUM ON BOND ISSUANCE 26,599 193,723 - - 51-000-49-00-4952 TRANSFER FROM SEWER 82,988 83,588 76,275 75,075 75,075 One Half the 2014C Debt Service PMT Total: Other Financing Sources $82,988 $1,373,687 $4,369,998 $75,075 $75,075 Total: WATER FUND REVENUE $2,587,877 $4,068,790 $8,063,368 $3,794,908 $3,794,908 19 United City of Yorkville Water Fund 510 WATER OPERATIONS Unaudited 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 321,206 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 $332,148 $416,844 $416,844 Benefits 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION 37,447 39,878 35,426 41,801 41,801 51-510-52-00-5214 FICA CONTRIBUTION 24,787 25,689 24,149 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,784 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 $210,900 $252,493 $252,493 Contractual Services 51-510-54-00-5402 BOND ISSUANCE COSTS - 24,378 40,456 - - 51-510-54-00-5405 BUILD PROGRAM 85,544 112,323 162,468 - - 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 132,788 112,000 112,000 51-510-54-00-5448 FILING FEES 5,831 4,253 3,753 6,500 6,500 Water Liens 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 28,444 21,500 21,500 51-510-54-00-5465 ENGINEERING SERVICES - - 187,840 - 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,490 5,000 5,000 51-510-54-00-5485 RENTAL&LEASE PURCHASE 504 504 464 1,000 1,000 51-510-54-00-5489 LOSS ON INVESTMENT - 16,036 - - - 20 United City of Yorkville Water Fund 510 WATER OPERATIONS Unaudited FY 2014 FY 2015 FY 2016 FY 2017 FY 2017 Account Description Actual Actual Actual Adopted Amended 51-510-54-00-5490 VEHICLE MAINTENANCE SERVICES 3,181 7,077 14,551 15,000 15,000 51-510-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 19,460 3,380 6,994 19,000 19,000 Includes$5k-Water Meter Testing Program 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 Water Sales/Infra Fees on Utility Bill Total: Contractual Services $541,175 $609,139 $887,820 $544,927 $607,087 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,971 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 234 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,082 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 $265,483 $297,660 $297,660 Capital Outlay 51-510-60-00-6022 WELL REHABILITATIONS - - 128,876 - 124,000 51-510-60-00-6025 ROAD TO BETTER ROADS PROGRAM 153,305 277,372 238,183 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 Meter Replacements-Radio 51-510-60-00-6066 RTE 71 WATERMAIN RELOCATION 15,955 5,000 5,000 51-510-60-00-6070 VEHICLES - - - 63,000 63,000 New One-Ton and Ford F-150 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,048,578 $3,482,668 $3,606,668 21 United City of Yorkville Water Fund 510 WATER OPERATIONS Unaudited 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 Refunded by 2014C Bond 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-II.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 22