Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Ordinance 2013-20
STATE OF ILLINOIS COUNTY OF KENDALL i FILED APR 2 6 2013 i �.KV � �� /i, (®UNTY eLERK AAV,� KENDALL COUNTY i UNITED CITY OF YORKVILLE KENDALL COUNTY, ILLINOIS i i ORDINANCE NO . 2013-20 ORDINANCE APPROVING THE 2013 -2014 FISCAL BUDGET FOR THE UNITED CITY OF YORKVILLE i i i I Passed by the City Council of the United City of Yorkville, Kendall County, Illinois This 9"' day of April, 2013 i i i I Published in pamphlet form by the authority of the Mayor and City Council of the United City of Yorkville, Kendall County, Illinois on April 26, 2013 . i I II i ORDINANCE NO , 2013- ORDINANCE APPROVING THE 2013-2014 FISCAL BUDGET FOR THE UNITED CITY OF YORKVILLE I WHEREAS , the Mayor and City Council of the UNITED CITY OF YORKVILLE have duly held all Public Hearings, allowed public input, and have duly considered formation of a budget for the 2013 -2014 Fiscal Year; and i WHEREAS , a tentative budget was duly announced and available for examination at the City offices of the UNITED CITY OF YORKVILLE ; and WHEREAS , the Mayor and City Council of the UNITED CITY OF YORKVILLE deem it in the best interest of the City for the orderly operation thereof to pass and approve the 2013 -2014 Fiscal Year Budget being submitted on April 9 , 2013 at its regular City Council Meeting : i I NOW, THEREFORE, BE IT ORDAINED , by the Mayor and City Council of the United City of Yorkville, Kendall County, Illinois that the 2013 -2014 Budget totaling $28 ,789 , 529 including the amounts of $ 13 , 891 , 560 General Fund, $ 1 , 394,456 Motor Fuel Tax Fund, $ 0 Municipal Building Fund, $292 ,462 Vehicle & Equipment Fund, $ 2 , 570 , 120 Sewer Fund, $2 , 859 , 595 Water Fund, $ 1 ,261 ,446 City-Wide Capital Fund, $ 328 , 554 Debt Service Fund, $ 89 ,000 Land Cash Fund, $2 , 199 ,048 Parks & Recreation Fund, $ 150,489 Recreation Center Fund, $ 771 ,363 Library Operations Fund, $ 769,638 I Library Debt Service Fund, $ 38 , 850 Library Capital Fund, $ 0 Fox Industrial TIF Fund, $ 2 , 105 , 113 Countryside TIF Fund, $45 , 350 Downtown TIF Fund, $ 14 , 985 Sunflower I SSA Fund, and $ 7, 500 Fox Hill SSA Fund is hereby adopted for the 2013 -2014 Fiscal Year, as presented. Ordinance No . 2013 - ao Page 2 i Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this 9th day of April, A. D . 2013 . i i I CITY CLERK i V CARLO COLOSIMO KEN KOCH JACKIE MILSCHEWSKI _ LARRY KOT MARTY MUNNS CHRIS FUNKHOUSER f ROSE ANN SPEARS DIANE TEELING Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this 9"' day of April , A .D . 2013 , MAYOR I i i ; Ordinance No . 2013 - <QO Page 3 GENERAL FUND (01) The General Fund is the City's primary operating fund. It accounts for major tax revenue used to support administrative and public safety functions. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 7,230,149 7,942,975 8,788,433 9,171,463 9,359,104 9,490,731 9,644,790 9,794,888 9,990,714 Intergovernmental 1,791,792 1,889,036 1,759,600 1,997,077 1,998,200 2,003,500 2,003,500 2,013,500 2,013,500 Licenses&Permits 241,752 171,921 169,300 169,300 193,000 193,000 218,000 218,000 243,000 Fines&Forfeits 201,236 175,159 201,500 162,200 180,200 180,200 180,200 180,200 180,200 Charges for Service 1,537,831 1,561,554 1,178,284 1,179,557 1,181,235 1,182,607 1,183,993 1,185,393 1,193,307 Investment Earnings 1,747 5,102 3,100 6,500 6,500 6,500 6,500 6,500 6,500 Reimbursements 484,593 419,903 199,892 218,240 75,000 75,000 75,000 75,000 75,000 Miscellaneous 28,861 13,702 11,000 124,000 11,000 13,000 13,000 13,000 13,000 Other Financing Sources - 332,500 - - 5,250 5,250 5,250 5,250 5,250 Total Revenue 11,517,961 12,511,852 12,311,109 13,028,337 13,009,489 13,149,788 13,330,233 13,491,731 13,720,471 Expenditures Salaries 3,517,151 3,029,713 3,371,895 3,304,920 3,546,298 3,546,298 3,546,298 3,546,298 3,546,298 Benefits 2,446,452 2,407,769 2,327,040 2,075,440 2,270,039 2,410,767 2,562,438 2,656,890 2,776,255 Contractual Services 3,470,156 3,944,907 3,840,120 3,658,073 3,934,440 4,059,205 4,172,923 4,262,413 4,356,956 Supplies 271,393 236,916 274,151 282,120 292,110 305,547 317,598 330,309 341,223 Contingencies 75,000 52,075 50,000 50,000 50,000 50,000 50,000 50,000 50,000 Other Financing Uses 1,516,778 1,297,950 1,516,661 1,504,683 3,798,673 2,276,458 2,387,916 3,630,415 2,911,434 Total Expenditures 11,296,930 10,969,330 11,379,867 10,875,236 13,891,560 12,648,275 13,037,173 14,476,325 13,982,166 Surplus(Deficit) 221,031 1,542,522 931,242 2,153,101 (882,071) 501,513 293,060 (984,594) (261,695) Ending Fund Balance (271,900) 1,270,623 1,596,094 3,423,724 2,541,653 3,043,166 3,336,226 2,351,632 2,089,937 -2.41% 11.58% 14.03% 31.48% 18.30% 24.06% 25.59% 16.24% 14.95% Fund Balance $4,000 N $3,000 3 t $2,000 H $1,000 $0 ($1,000) 1 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected GENERAL FUND-01 O1-000-40-00-4000 PROPERTY TAXES-CORPORATE LEVY 2,185,495 2,282,246 2,288,133 2,276,807 2,288,154 2,311,036 2,334,146 2,357,487 2,381,062 O1-000-40-00-4010 PROPERTY TAXES-POLICE PENSION 336,075 360,356 413,354 438,711 562,000 587,000 612,000 637,000 662,000 O1-000-40-00-4012 PROPERTY TAXES-FOX INDUSTRIAL TIE - 67,334 20,000 - - - - - - O1-000-40-00-4030 MUNICIPAL SALES TAX 2,569,233 2,552,483 2,325,000 2,425,000 2,449,250 2,473,743 2,523,217 2,573,682 2,650,892 O1-000-40-00-4035 NON-HOME RULE SALES TAX - 410,327 1,500,000 1,800,000 1,800,000 1,818,000 1,854,360 1,891,447 1,948,191 O1-000-40-00-4040 ELECTRIC UTILITY TAX 605,833 603,015 603,432 603,432 605,000 611,050 617,161 623,332 629,565 O1-000-40-00-4041 NATURAL GAS UTILITY TAX 268,166 225,411 296,514 250,000 275,000 280,000 282,800 285,628 288,484 O1-000-40-00-4043 EXCISE TAX 491,188 500,415 490,000 500,000 500,000 500,000 506,000 506,000 510,000 O1-000-40-00-4044 TELEPHONE UTILITY TAX 23,002 18,393 23,500 20,000 20,200 20,402 20,606 20,812 21,020 O1-000-40-00-4045 CABLE FRANCHISE FEES 228,452 221,465 230,000 230,000 230,000 230,000 235,000 235,000 235,000 O1-000-40-00-4050 HOTEL TAX 38,198 51,029 50,000 50,000 50,000 50,000 50,000 50,000 50,000 O1-000-40-00-4060 AMUSEMENT TAX 319 127,737 134,000 148,000 165,000 195,000 195,000 200,000 200,000 O1-000-40-00-4065 ADMISSIONS TAX 181,744 190,627 104,500 119,199 104,500 104,500 104,500 104,500 104,500 O1-000-40-00-4070 BUSINESS DISTRICT TAX-KNDLL MKTPLCE 289,015 305,908 300,000 300,000 300,000 300,000 300,000 300,000 300,000 O1-000-40-00-4072 BUSINESS DISTRICT TAX-DOWNTOWN - - - - - - - - - 01-000-40-00-4075 AUTO RENTAL TAX 8,298 9,549 10,000 10,000 10,000 10,000 10,000 10,000 10,000 01-000-40-00-4080 PARA-MUTUEL TAX 5,131 16,680 - 314 - - - - - O1-000-41-00-4100 STATE INCOME TAX 1,315,321 1,444,426 1,320,000 1,550,000 1,550,000 1,550,000 1,550,000 1,550,000 1,550,000 O1-000-41-00-4105 LOCAL USE TAX 240,047 246,963 242,400 250,000 250,000 250,000 250,000 255,000 255,000 O1-000-41-00-4110 ROAD&BRIDGE TAX 164,296 166,896 170,000 168,477 170,000 175,000 175,000 180,000 180,000 O1-000-41-00-4120 PERSONAL PROPERTY TAX 16,394 15,030 16,000 15,000 15,000 15,000 15,000 15,000 15,000 O1-000-41-00-4160 FEDERAL GRANTS 13,288 12,521 9,200 12,500 12,000 12,000 12,000 12,000 12,000 O1-000-41-00-4170 STATE GRANTS 40,250 2,123 - - - - - - - O1-000-41-00-4182 MISC INTERGOVERNMENTAL 2,196 1,077 2,000 1,100 1,200 1,500 1,500 1,500 1,500 O1-000-42-00-4200 LIQUOR LICENSE 38,903 43,265 40,000 40,000 40,000 40,000 40,000 40,000 40,000 O1-000-42-00-4205 OTHER LICENSES&PERMITS 2,670 6,256 2,700 2,700 3,000 3,000 3,000 3,000 3,000 O1-000-42-00-4210 BUILDING PERMITS 126,829 122,400 126,600 126,600 150,000 150,000 175,000 175,000 200,000 O1-000-42-00-4214 DEVELOPMENT FEES 73,350 - - - - - - - - O1-000-43-00-4310 CIRCUIT COURT FINES 95,289 66,028 95,000 60,000 70,000 70,000 70,000 70,000 70,000 O1-000-43-00-4320 ADMINISTRATIVE ADJUDICATION 25,457 24,206 26,000 32,000 30,000 30,000 30,000 30,000 30,000 O1-000-43-00-4323 OFFENDER REGISTRATION FEES - 175 500 200 200 200 200 200 200 2 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected O1-000-43-00-4325 POLICE TOWS 80,490 84,750 80,000 70,000 80,000 80,000 80,000 80,000 80,000 O1-000-44-00-4400 GARBAGE SURCHARGE 1,177,995 1,231,681 1,021,784 1,023,581 1,023,500 1,023,500 1,023,500 1,023,500 1,030,000 O1-000-44-00-4405 COLLECTION FEE-YBSD 116,087 134,531 151,500 135,876 137,235 138,607 139,993 141,393 142,807 O1-000-44-00-4407 LATE PENALTIES-GARBAGE - - - 20,000 20,000 20,000 20,000 20,000 20,000 O1-000-44-00-4414 OTHER SERVICES 3,960 - - - - - - - O1-000-44-00-4451 WATER CHARGEBACK 91,863 91,863 O1-000-44-00-4452 SEWER CHARGEBACK 83,045 83,045 O1-000-44-00-4472 LAND CASH CHARGEBACK 60,449 20,084 - - - - - - - O1-000-44-00-4474 POLICE SPECIAL DETAIL 4,432 350 5,000 100 500 500 500 500 500 O1-000-45-00-4500 INVESTMENT EARNINGS 1,747 5,102 3,100 6,500 6,500 6,500 6,500 6,500 6,500 O1-000-46-00-4601 REIMB-LEGAL EXPENSES 46,951 28,738 - - - - - - - O1-000-46-00-4604 REIMB-ENGINEERING EXPENSES - 25,697 - - - - - - - O1-000-46-00-4650 REIMB-TRAFFIC SIGNAL 33,067 28,582 15,000 20,019 20,000 20,000 20,000 20,000 20,000 O1-000-46-00-4668 REIMB-COBRA CONTRIBUTIONS 21,675 23,220 12,500 817 - - - - - O1-000-46-00-4669 REIMB-RETIREE INS CONTRIBUTIONS 39,671 48,447 60,398 50,994 01-000-46-00-4670 REIMB-EMPLOYEE INS CONTRIBUTIONS 193,147 91,536 61,295 66,571 01-000-46-00-4671 REIMB-LIFE INSURANCE 4,789 3,363 1,699 2,229 01-000-46-00-4672 REIMB-LIBRARY INSURANCE - 93,842 - - - - - - - 01-000-46-00-4680 REIMB-LIABILITY INSURANCE 35,711 3,417 5,000 29,610 5,000 5,000 5,000 5,000 5,000 O1-000-46-00-4681 REIMB-WORKERS COMP 22,207 25,557 - - - - - - - O1-000-46-00-4685 REIMB-CABLE CONSORTIUM 19,505 37,167 40,000 37,000 40,000 40,000 40,000 40,000 40,000 O1-000-46-00-4690 REIMB-MISCELLANEOUS 67,870 10,337 4,000 11,000 10,000 10,000 10,000 10,000 10,000 O1-000-48-00-4820 RENTAL INCOME 5,600 8,460 8,000 8,000 8,000 8,000 8,000 8,000 8,000 O1-000-48-00-4821 BAD DEBT RECOVERY 10,849 - - - - - - - - O1-000-48-00-4845 DONATIONS 2,784 50 - - - 2,000 2,000 2,000 2,000 01-000-48-00-4850 MISCELLANEOUS INCOME 9,628 5,192 3,000 116,000 3,000 3,000 3,000 3,000 3,000 01-000-49-00-4916 TRANSFER FROM MUNICIPAL BUILDING - - - - 5,250 5,250 5,250 5,250 5,250 01-000-49-00-4984 TRANSFER FROM LIBRARY CAPITAL - 332,500 - - - - - - Revenue 11,517,961 12,511,852 12,311,109 13,028,337 13,009,489 13,149,788 13,3309233 13,491,731 13,720,471 3 ADMINISTRATION DEPARTMENT The Administration Department includes both elected official and management expenditures. Elected officials consists of the Mayor,City Council,Treasurer and City 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. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 319,269 307,078 333,395 338,320 368,599 368,599 368,599 368,599 368,599 Benefits 48,949 49,070 275,732 260,902 253,005 271,681 292,224 305,783 320,158 Contractual Services 119,138 111,976 160,250 158,900 161,800 162,745 163,887 164,929 166,023 Supplies 11,264 8,084 12,950 12,950 12,950 12,950 12,950 12,950 12,950 Total Administration 498,620 476,208 782,327 771,072 796,354 815,975 837,660 852,261 867,730 $1,000 a $900 $800 o $700 1-- $600 $500 $400 $300 $200 $100 $0 4 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Administration O1-110-50-00-5001 SALARIES-MAYOR 10,700 10,105 11,000 11,000 11,000 11,000 11,000 11,000 11,000 O1-110-50-00-5002 SALARIES-LIQUOR COMM 1,167 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 O1-110-50-00-5003 SALARIES-CITY CLERK 9,305 8,535 9,000 9,000 11,000 11,000 11,000 11,000 11,000 O1-110-50-00-5004 SALARIES-CITY TREASURER 6,105 5,800 6,500 6,500 6,500 6,500 6,500 6,500 6,500 O1-110-50-00-5005 SALARIES-ALDERMAN 52,455 48,270 50,320 50,320 52,000 52,000 52,000 52,000 52,000 O1-110-50-00-5007 SALARIES-ADMINISTRATION 239,314 232,228 255,000 260,000 264,599 264,599 264,599 264,599 264,599 O1-110-50-00-5015 PART-TIME SALARIES - - - - 22,000 22,000 22,000 22,000 22,000 01-110-50-00-5020 OVERTIME 223 1,140 575 500 500 500 500 500 500 O1-110-52-00-5212 RETIREMENT PLAN CONTRIBUTION 26,574 27,723 28,383 30,000 38,125 38,125 38,125 38,125 38,125 O1-110-52-00-5214 FICA CONTRIBUTION 22,375 21,347 22,500 22,500 27,087 27,087 27,087 27,087 27,087 O1-110-52-00-5216 GROUP HEALTH INSURANCE - - 72,456 72,456 78,075 85,883 94,471 100,139 106,147 O1-110-52-00-5222 GROUP LIFE INSURANCE 614 614 476 481 486 490 495 O1-110-52-00-5223 DENTAL INSURANCE 5,096 5,096 5,628 6,191 6,810 7,218 7,652 O1-110-52-00-5224 VISION INSURANCE 586 586 590 649 714 757 802 O1-110-52-00-5235 ELECTED OFFICIAL-GROUP HEALTH INSURANCE 133,917 120,000 94,874 104,361 114,798 121,685 128,987 O1-110-52-00-5236 ELECTED OFFICIAL-GROUP LIFE INSURANCE 1,043 750 682 689 696 703 710 O1-110-52-00-5237 ELECTED OFFICIAL-DENTAL INSURANCE 10,008 8,000 6,765 7,442 8,186 8,677 9,197 01-110-52-00-5238 ELECTED OFFICIAL-VISION INSURANCE - 1,129 900 703 773 851 902 956 O1-110-54-00-5412 TRAINING&CONFERENCES - 1,925 3,000 3,000 3,000 3,000 3,000 3,000 3,000 O1-110-54-00-5415 TRAVEL&LODGING 790 1,565 6,000 6,000 8,000 8,000 8,000 8,000 8,000 O1-110-54-00-5423 PUBLIC RELATIONS 55 - - - - - - - - O1-110-54-00-5426 PUBLISHING&ADVERTISING 655 774 1,000 1,000 1,000 1,000 1,000 1,000 1,000 O1-110-54-00-5430 PRINTING&DUPLICATING 8,081 5,972 6,750 6,750 5,250 5,250 5,250 5,250 5,250 01-110-54-00-5440 TELECOMMUNICATIONS 12,520 14,085 15,000 18,750 20,000 20,000 20,000 20,000 20,000 01-110-54-00-5448 FILING FEES - - 500 500 500 500 500 500 500 O1-110-54-00-5451 CODIFICATION 4,159 3,902 8,000 8,000 8,000 8,000 8,000 8,000 8,000 O1-110-54-00-5452 POSTAGE&SHIPPING 8,055 4,449 14,000 14,000 14,000 14,000 14,000 14,000 14,000 O1-110-54-00-5460 DUES&SUBSCRIPTIONS 12,872 12,368 16,600 16,600 16,600 16,600 16,600 16,600 16,600 O1-110-54-00-5462 PROFESSIONAL SERVICES 9,539 13,581 20,000 20,000 20,000 20,000 20,000 20,000 20,000 O1-110-54-00-5473 KENDALL COUNTY PARATRANSIT 27,553 23,550 30,000 30,000 30,000 30,000 30,000 30,000 30,000 01-110-54-00-5474 SENIOR SERVICE FUNDING - - - - - - - - - O1-110-54-00-5480 UTILITIES 21,735 13,887 23,100 18,000 18,900 19,845 20,837 21,879 22,973 O1-110-54-00-5485 RENTAL&LEASE PURCHASE - 1,716 1,900 1,900 2,150 2,150 2,300 2,300 2,300 5 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected O1-110-54-00-5488 OFFICE CLEANING 13,124 14,202 14,400 14,400 14,400 14,400 14,400 14,400 14,400 O1-110-56-00-5610 OFFICE SUPPLIES 9,320 8,015 12,000 12,000 12,000 12,000 12,000 12,000 12,000 O1-110-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 1,944 - 850 850 850 850 850 850 850 O1-110-56-00-5640 REPAIR&MAINTENANCE - 69 100 100 100 100 100 100 100 498,620 476,208 782,327 771,072 7963354 815,975 8373660 852,261 867,730 6 FINANCE DEPARTMENT The Finance Department is responsible for the accounting,internal controls,external reporting and auditing of all financial transactions. The Finance Department is in charge of the annual audit,utility billing,payables and payroll and works with administration in the preparation of the annual budget. Personnel are budgeted in the General and Water funds. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 201,586 170,294 185,000 180,000 189,024 189,024 189,024 189,024 189,024 Benefits 34,085 29,628 62,135 62,377 64,571 67,505 70,733 72,864 75,121 Contractual Services 93,906 80,204 88,150 75,100 82,550 86,750 87,850 88,950 91,550 Supplies 3,281 4,042 5,250 5,250 5,250 5,250 5,250 5,250 5,250 Total Finance 332,858 284,168 340,535 322,727 341,395 348,529 352,857 356,088 360,945 $400 $350 $300 a 3 $250 0 F $200 $150 $100 $50 $0 7 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Finance O1-120-50-00-5010 SALARIES&WAGES 201,586 170,294 185,000 180,000 189,024 189,024 189,024 189,024 189,024 O1-120-52-00-5212 RETIREMENT PLAN CONTRIBUTION 18,759 16,586 18,659 18,659 20,742 20,742 20,742 20,742 20,742 O1-120-52-00-5214 FICA CONTRIBUTION 15,326 13,042 13,005 13,500 14,166 14,166 14,166 14,166 14,166 O1-120-52-00-5216 GROUP HEALTH INSURANCE - - 26,472 26,472 25,822 28,404 31,245 33,119 35,106 O1-120-52-00-5222 GROUP LIFE INSURANCE 461 360 357 361 364 368 371 O1-120-52-00-5223 DENTALINSURANCE 3,182 3,062 3,160 3,476 3,824 4,053 4,296 O1-120-52-00-5224 VISION INSURANCE - 356 324 324 356 392 416 440 O1-120-54-00-5412 TRAINING&CONFERENCES - 670 2,000 2,000 2,000 2,000 2,000 2,000 2,000 O1-120-54-00-5414 AUDITING SERVICES 43,500 44,800 36,000 31,000 31,000 35,200 36,300 37,400 40,000 O1-120-54-00-5415 TRAVEL&LODGING - 237 1,000 500 2,000 2,000 2,000 2,000 2,000 O1-120-54-00-5430 PRINTING&DUPLICATING - - 500 1,500 1,750 1,750 1,750 1,750 1,750 O1-120-54-00-5440 TELECOMMUNICATIONS 633 540 600 1,000 1,200 1,200 1,200 1,200 1,200 O1-120-54-00-5452 POSTAGE&SHIPPING 474 648 500 750 750 750 750 750 750 01-120-54-00-5460 DUES&SUBSCRIPTIONS 902 480 850 600 800 800 800 800 800 O1-120-54-00-5462 PROFESSIONAL SERVICES 29,531 27,255 40,000 35,000 40,000 40,000 40,000 40,000 40,000 O1-120-54-00-5485 RENTAL&LEASE PURCHASE 18,028 5,324 4,900 2,250 2,300 2,300 2,300 2,300 2,300 O1-120-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 838 250 1,800 500 750 750 750 750 750 O1-120-56-00-5610 OFFICE SUPPLIES 1,520 1,955 2,500 2,500 2,500 2,500 2,500 2,500 2,500 O1-120-56-00-5630 SMALL TOOLS&EQUIPMENT - - 250 250 250 250 250 250 250 01-120-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 1,761 2,087 2,500 2,500 2,500 2,500 2,500 2,500 2,500 332,858 284,168 340,535 322,727 3419395 348,529 352,857 356,088 3603945 g COMMUNITY RELATIONS The Community Relations department was discontinued at the end of fiscal year 2011. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 63,359 - - - - - - - - Benefits 7,939 - - - - - - - - Contractual Services 11,361 333 - - - - - - - Supplies 656 - - - - - - - - Total Community Relations 83,315 333 - - - - - - - $100 $80 3 s° $60 $40 $20 $0 9 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Community Relations 01-130-50-00-5010 SALARIES&WAGES 63,359 01-130-52-00-5212 RETIREMENT PLAN CONTRIBUTION 4,004 01-130-52-00-5214 FICA CONTRIBUTION 3,935 - 01-130-54-00-5426 PUBLISHING&ADVERTISING 5,977 333 01-130-54-00-5440 TELECOMMUNICATIONS 279 - 01-130-54-00-5452 POSTAGE&SHIPPING 1,630 01-130-54-00-5462 PROFESSIONAL SERVICES 3,475 01-130-56-00-5610 OFFICE SUPPLIES 130 01-130-56-00-5692 COMMUNITY EVENTS 526 - 83,315 333 - - - - 10 ENGINEERING DEPARTMENT The Engineering Department was closed out at the beginning of fiscal year 2012. Expenditures are now budgeted out of the administrative services department. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 235,639 75,383 - - - - - - - Benefits 95,112 22,485 - - - - - - - Contractual Services 10,022 4,348 - - - - - - - Supplies 9,994 7 - - - - - - - Total Engineering 350,767 102,223 - - - - - - - $400 a $350 $300 $250 $200 $150 $100 $50 $0 11 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Engineering O1-150-50-00-5010 SALARIES&WAGES 235,552 75,383 O1-150-50-00-5020 OVERTIME 87 - O1-150-52-00-5212 RETIREMENT PLAN CONTRIBUTION 21,727 7,169 O1-150-52-00-5214 FICA CONTRIBUTION 17,409 5,716 O1-150-52-00-5216 GROUP HEALTH INSURANCE 50,712 8,826 O1-150-52-00-5222 GROUP LIFE INSURANCE 909 76 O1-150-52-00-5223 DENTAL INSURANCE 3,814 627 - O1-150-52-00-5224 VISION INSURANCE 541 71 - O1-150-54-00-5415 TRAVEL&LODGING - 3 - O1-150-54-00-5430 PRINTING&DUPLICATING 1,116 286 - O1-150-54-00-5440 TELECOMMUNICATIONS 1,340 207 - O1-150-54-00-5452 POSTAGE&SHIPPING 257 23 - O1-150-54-00-5460 DUES&SUBSCRIPTIONS 428 - - O1-150-54-00-5462 PROFESSIONAL SERVICES 5,578 2,164 - O1-150-54-00-5485 RENTAL&LEASE PURCHASE - 1,638 - O1-150-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 1,303 27 - O1-150-56-00-5610 OFFICE SUPPLIES 1,006 7 - O1-150-56-00-5622 ENGINEERING SUPPLIES 928 - - O1-150-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 2,627 - O1-150-56-00-5645 BOOKS&PUBLICATIONS 126 - O1-150-56-00-5690 SUPPLIES-GRANT REIMBURSABLE 5,307 350,767 102,223 - - 12 POLICE DEPARTMENT The mission of the Yorkville Police Department is to work in partnership with the community to protect life and property,assist neighborhoods with solving their problems and enhance the quality of life in our city. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 2,127,332 2,028,011 2,305,500 2,279,500 2,434,547 2,434,547 2,434,547 2,434,547 2,434,547 Benefits 507,612 521,435 1,169,457 1,115,046 1,342,880 1,426,028 1,514,987 1,582,213 1,651,971 Contractual Services 131,034 163,951 213,850 209,180 209,350 263,006 287,142 286,142 287,141 Supplies 112,842 133,023 151,770 138,700 153,270 159,637 166,449 173,738 181,537 Total Police 2,878,820 2,846,420 3,840,577 3,742,426 4,140,047 4,283,218 4,403,125 4,476,640 4,555,196 $5,000 $4,500 $4,000 3 $3,500 s° $3,000 r $2,500 $2,000 $1,500 $1,000 $500 $0 13 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Police O1-210-50-00-5006 SALARIES-LIEUT/SERGEANTS/CHIEFS 660,249 600,533 - - - - - - O1-210-50-00-5008 SALARIES-POLICE OFFICERS 1,167,964 1,149,440 1,261,000 1,261,000 1,393,000 1,393,000 1,393,000 1,393,000 1,393,000 O1-210-50-00-5011 SALARIES-POLICE CHIEF&DEPUTIES - - 317,000 295,000 299,674 299,674 299,674 299,674 299,674 O1-210-50-00-5012 SALARIES-SERGEANTS - - 430,000 410,000 435,746 435,746 435,746 435,746 435,746 O1-210-50-00-5013 SALARIES-POLICE CLERKS 156,502 128,755 135,000 130,000 122,627 122,627 122,627 122,627 122,627 O1-210-50-00-5014 SALARIES-CROSSING GUARD 17,381 19,413 20,000 20,000 20,000 20,000 20,000 20,000 20,000 O1-210-50-00-5015 PART-TIME SALARIES 30,604 33,832 52,500 52,500 52,500 52,500 52,500 52,500 52,500 O1-210-50-00-5017 CADET PROGRAM 12,045 6,089 - - - - - - - O1-210-50-00-5020 OVERTIME 82,587 89,949 90,000 111,000 111,000 111,000 111,000 111,000 111,000 O1-210-52-00-5212 RETIREMENT PLAN CONTRIBUTION 14,455 11,696 15,818 14,000 13,590 13,590 13,590 13,590 13,590 O1-210-52-00-5213 EMPLOYER CONTRI-POLICE PENSION 336,075 360,356 413,354 438,711 562,000 587,000 612,000 637,000 662,000 O1-210-52-00-5214 FICA CONTRIBUTION 157,082 149,383 175,000 175,000 182,664 182,664 182,664 182,664 182,664 O1-210-52-00-5216 GROUP HEALTH INSURANCE - - 517,950 440,000 537,969 591,766 650,943 690,000 731,400 O1-210-52-00-5222 GROUP LIFE INSURANCE 5,635 5,635 3,498 3,533 3,568 3,604 3,640 O1-210-52-00-5223 DENTAL INSURANCE 37,428 37,428 39,163 43,079 47,387 50,230 53,244 O1-210-52-00-5224 VISION INSURANCE - - 4,272 4,272 3,996 4,396 4,835 5,125 5,433 O1-210-54-00-5410 TUITION REIMBURSEMENT 1,808 1,510 2,800 - 2,800 2,800 2,800 2,800 2,800 O1-210-54-00-5411 POLICE COMMISSION 3,677 16,281 4,000 9,000 16,500 4,000 15,000 4,000 15,000 O1-210-54-00-5412 TRAINING&CONFERENCE 8,554 8,275 15,000 15,000 13,000 13,000 13,000 13,000 13,000 O1-210-54-00-5415 TRAVEL&LODGING 1,873 6,690 10,000 6,000 10,000 10,000 10,000 10,000 10,000 O1-210-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK - - - - - 56,156 78,792 78,792 78,791 O1-210-54-00-5426 PUBLISHING&ADVERTISING 86 11 200 200 200 200 200 200 200 O1-210-54-00-5430 PRINTING&DUPLICATING 2,923 4,151 4,500 4,500 4,500 4,500 4,500 4,500 4,500 O1-210-54-00-5440 TELECOMMUNICATIONS 22,142 25,933 36,500 36,500 36,500 36,500 36,500 36,500 36,500 O1-210-54-00-5452 POSTAGE&SHIPPING 986 1,346 3,000 2,000 3,000 3,000 3,000 3,000 3,000 O1-210-54-00-5460 DUES&SUBSCRIPTIONS 1,115 1,340 1,350 1,350 1,350 1,350 1,350 1,350 1,350 O1-210-54-00-5462 PROFESSIONAL SERVICES 4,222 17,989 5,000 8,000 8,000 8,000 8,000 8,000 8,000 01-210-54-00-5466 LEGAL SERVICES - - 20,000 20,000 10,000 20,000 10,000 20,000 10,000 O1-210-54-00-5467 ADJUDICATION SERVICES 16,863 18,078 20,000 20,000 20,000 20,000 20,000 20,000 20,000 01-210-54-00-5469 NEW WORLD LIVE SCAN 10,281 10,944 15,000 9,666 15,000 15,000 15,000 15,000 15,000 01-210-54-00-5472 KENDALL CO.JUVE PROBATION 2,683 2,389 4,000 4,000 4,000 4,000 4,000 4,000 4,000 O1-210-54-00-5484 MDT-ALERTS FEE 6,660 6,660 7,000 6,660 7,000 7,000 7,000 7,000 7,000 O1-210-54-00-5485 RENTAL&LEASE PURCHASE - 4,224 4,500 5,304 6,500 6,500 7,000 7,000 7,000 14 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected O1-210-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 47,161 38,130 61,000 61,000 51,000 51,000 51,000 51,000 51,000 O1-210-56-00-5600 WEARING APPAREL 10,586 17,449 16,000 16,000 16,000 16,000 16,000 16,000 16,000 O1-210-56-00-5610 OFFICE SUPPLIES 2,933 2,266 4,000 4,500 4,500 4,500 4,500 4,500 4,500 O1-210-56-00-5620 OPERATING SUPPLIES 7,061 6,491 8,000 8,000 8,000 8,000 8,000 8,000 8,000 O1-210-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 5,032 8,405 7,000 6,000 7,000 7,000 7,000 7,000 7,000 O1-210-56-00-5640 REPAIR&MAINTENANCE 6,569 12,821 12,250 12,000 12,250 12,250 12,250 12,250 12,250 O1-210-56-00-5650 COMMUNITY SERVICES 3,020 77 7,370 1,000 7,370 7,370 7,370 7,370 7,370 O1-210-56-00-5690 SUPPLIES-GRANT REIMBURSABLE 5,566 4,314 4,200 4,200 4,200 4,200 4,200 4,200 4,200 O1-210-56-00-5695 GASOLINE 70,080 79,977 90,950 85,000 90,950 97,317 104,129 111,418 119,217 O1-210-56-00-5696 AMMUNITION 1,995 1,223 2,000 2,000 3,000 3,000 3,000 3,000 3,000 2,878,820 2,846,420 3,840,577 3,742,426 4,140,047 4,283,218 4,403,125 4,476,640 49555,196 15 COMMUNITY DEVELOPMENT DEPARTMENT The primary focus of the Community Development Department is to ensure that all existing and new construction is consistent with the overall development goals of the City which entails short and long-range planning,administration of zoning regulations,building permits issuance and code enforcement.The department also provides staff support to the City Council,Plan Commission,Zoning Board of Appeals and Park Board and assists in the review of all development plans proposed within the United City of Yorkville. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 269,607 188,249 248,000 220,000 225,666 225,666 225,666 225,666 225,666 Benefits 43,761 31,460 109,797 92,911 93,377 98,822 104,811 108,765 112,954 Contractual Services 69,730 83,661 92,350 69,717 81,750 83,622 85,769 87,794 89,899 Supplies 12,193 3,683 11,279 16,682 11,535 11,808 12,101 12,415 12,750 Total Community Development 395,291 307,053 461,426 399,310 412,328 419,918 428,347 434,640 441,269 $500 v N $400 3 O $300 $200 $100 $0 16 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Community Development O1-220-50-00-5010 SALARIES&WAGES 269,607 188,249 195,000 190,000 195,666 195,666 195,666 195,666 195,666 O1-220-50-00-5015 PART-TIME SALARIES - - 53,000 30,000 30,000 30,000 30,000 30,000 30,000 O1-220-52-00-5212 RETIREMENT PLAN CONTRIBUTION 24,175 17,492 26,227 21,500 21,685 21,685 21,685 21,685 21,685 O1-220-52-00-5214 FICA CONTRIBUTION 19,586 13,968 19,000 17,000 16,953 16,953 16,953 16,953 16,953 O1-220-52-00-5216 GROUP HEALTH INSURANCE - - 59,499 50,000 50,430 55,473 61,020 64,682 68,562 O1-220-52-00-5222 GROUP LIFE INSURANCE 461 511 325 328 332 335 338 O1-220-52-00-5223 DENTALINSURANCE 4,139 3,500 3,605 3,966 4,362 4,624 4,901 O1-220-52-00-5224 VISION INSURANCE - - 471 400 379 417 459 486 515 O1-220-54-00-5412 TRAINING&CONFERENCES 115 1,144 1,500 1,763 2,000 2,000 2,000 2,000 2,000 O1-220-54-00-5415 TRAVEL&LODGING - 573 1,000 1,000 1,500 1,500 1,500 1,500 1,500 O1-220-54-00-5426 PUBLISHING&ADVERTISING 87 185 500 500 500 500 500 500 500 O1-220-54-00-5430 PRINTING&DUPLICATING 1,062 994 4,250 4,250 4,250 4,250 4,250 4,250 4,250 O1-220-54-00-5440 TELECOMMUNICATIONS 1,318 1,736 1,500 2,400 3,000 3,000 3,000 3,000 3,000 O1-220-54-00-5452 POSTAGE&SHIPPING 230 719 500 1,000 1,000 1,000 1,000 1,000 1,000 O1-220-54-00-5459 INSPECTIONS 17,387 26,060 25,000 - 10,000 10,000 10,000 10,000 10,000 O1-220-54-00-5460 DUES&SUBSCRIPTIONS 1,016 1,075 1,500 2,804 2,000 2,000 2,000 2,000 2,000 O1-220-54-00-5462 PROFESSIONAL SERVICES 1,738 1,026 6,000 6,000 6,000 6,000 6,000 6,000 6,000 O1-220-54-00-5466 LEGAL SERVICES 1,777 3,511 2,000 2,000 2,000 2,000 2,000 2,000 2,000 O1-220-54-00-5485 RENTAL&LEASE PURCHASE - 1,638 3,600 3,000 2,700 2,700 2,900 2,900 2,900 O1-220-54-00-5486 ECONOMIC DEVELOPMENT 45,000 45,000 45,000 45,000 46,800 48,672 50,619 52,644 54,749 01-220-56-00-5610 OFFICE SUPPLIES 469 311 500 500 500 500 500 500 500 O1-220-56-00-5620 OPERATING SUPPLIES 712 2,928 3,000 3,000 3,000 3,000 3,000 3,000 3,000 O1-220-56-00-5630 SMALL TOOLS&EQUIPMENT - - 125 125 125 125 125 125 125 O1-220-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 2,171 - 3,500 9,153 3,500 3,500 3,500 3,500 3,500 O1-220-56-00-5645 BOOKS&PUBLICATIONS 493 444 500 250 500 500 500 500 500 O1-220-56-00-5690 SUPPLIES-GRANT REIMBURSABLE 8,348 - - - - - - - - O1-220-56-00-5695 GASOLINE - - 3,654 3,654 3,910 4,183 4,476 4,790 5,125 395,291 307,053 461,426 399,310 412,328 419,918 428,347 434,640 441,269 17 PUBLIC WORKS DEPARTMENT The Public Works Department is an integral part of the United City of Yorkville. We provide high quality drinking water,efficient disposal of sanitary waste and maintain a comprehensive road and storm sewer network to ensure the safety and quality of life for the citizens of Yorkville. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 295,927 260,348 295,000 287,000 327,962 327,962 327,962 327,962 327,962 Benefits 49,515 44,246 147,530 150,914 163,688 173,914 185,162 192,588 200,459 Contractual Services 1,321,931 1,314,041 1,390,020 1,227,880 1,509,250 1,356,020 1,363,901 1,372,052 1,384,484 Supplies 121,163 85,167 87,902 95,950 104,105 110,902 115,848 120,956 123,736 Total Public Works 1,788,536 1,703,802 1,920,452 1,761,744 2,105,005 1,968,798 1,992,873 2,013,558 2,036,641 $2,500 c M $2,000 3 O s ~ $1,500 $1,000 $500 $0 18 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Street Operations O1-410-50-00-5010 SALARIES&WAGES 285,143 253,695 280,000 272,000 312,962 312,962 312,962 312,962 312,962 O1-410-50-00-5020 OVERTIME 10,784 6,653 15,000 15,000 15,000 15,000 15,000 15,000 15,000 O1-410-52-00-5212 RETIREMENT PLAN CONTRIBUTION 27,424 24,887 31,753 31,753 36,347 36,347 36,347 36,347 36,347 O1-410-52-00-5214 FICA CONTRIBUTION 22,091 19,359 23,500 22,000 24,510 24,510 24,510 24,510 24,510 O1-410-52-00-5216 GROUP HEALTH INSURANCE - - 83,361 88,000 94,362 103,798 114,178 121,029 128,290 O1-410-52-00-5222 GROUP LIFE INSURANCE 1,317 1,311 635 641 648 654 661 O1-410-52-00-5223 DENTALINSURANCE 6,826 7,100 7,095 7,805 8,585 9,100 9,646 O1-410-52-00-5224 VISION INSURANCE - - 773 750 739 813 894 948 1,005 O1-410-54-00-5412 TRAINING&CONFERENCES 180 1,440 2,000 2,000 2,000 2,000 2,000 2,000 2,000 O1-410-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK - - - - 144,650 51,795 51,795 51,795 51,795 O1-410-54-00-5435 TRAFFIC SIGNAL MAINTENANCE - - - - 20,000 20,000 20,000 20,000 20,000 O1-410-54-00-5440 TELECOMMUNICATIONS 2,053 2,506 4,020 2,600 3,000 3,000 3,000 3,000 3,000 O1-410-54-00-5446 PROPERTY&BLDG MAINT SERVICES 8,267 18,329 20,000 20,000 22,500 25,000 27,500 30,000 30,000 O1-410-54-00-5454 SIDEWALK PROGRAM 1,225 869 4,000 2,000 - - - - - O1-410-54-00-5455 MOSQUITO CONTROL 6,500 6,500 7,000 6,730 8,000 8,400 8,820 9,261 9,724 O1-410-54-00-5458 TREE&STUMP REMOVAL 8,300 6,025 20,000 20,000 20,000 20,000 20,000 20,000 20,000 O1-410-54-00-5462 PROFESSIONAL SERVICES 1,165 970 1,000 1,000 1,000 1,000 1,000 1,000 1,000 O1-410-54-00-5480 UTILITIES 89,784 57,145 90,000 90,000 94,500 99,225 104,186 109,396 114,865 O1-410-54-00-5485 RENTAL&LEASE PURCHASE 176 1,051 1,000 1,050 1,100 1,100 1,100 1,100 1,100 O1-410-54-00-5490 VEHICLE MAINTENANCE SERVICES 22,110 20,886 35,000 35,000 20,000 20,000 20,000 20,000 20,000 O1-410-56-00-5600 WEARING APPAREL 2,386 2,581 4,200 4,200 4,200 4,200 4,200 4,200 4,200 O1-410-56-00-5620 OPERATING SUPPLIES 3,801 10,648 9,500 9,500 9,975 10,474 10,997 11,547 12,125 O1-410-56-00-5626 HANGING BASKETS 2,048 2,041 - - - 2,000 2,000 2,000 2,000 01-410-56-00-5628 VEHICLE MAINTENANCE SUPPLIES - - - - 20,000 20,000 20,000 20,000 20,000 01-410-56-00-5630 SMALL TOOLS&EQUIPMENT 1,896 7,962 1,750 1,750 1,750 1,750 1,750 1,750 1,750 01-410-56-00-5640 REPAIR&MAINTENANCE 76,277 22,671 36,500 36,500 20,000 20,000 20,000 20,000 20,000 O1-410-56-00-5656 PROPERTY&BLDG MAINT SUPPLIES 5,405 8,240 20,000 20,000 22,500 25,000 27,500 30,000 30,000 01-410-56-00-5695 GASOLINE 29,350 31,024 15,952 24,000 25,680 27,478 29,401 31,459 33,661 606,365 505,482 714,452 714,244 932,505 864,298 888,373 909,058 925,641 19 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Health&Sanitation 01-540-54-00-5441 GARBAGE SERVICES-SENIOR SUBSIDY - - 153,216 143,000 143,000 75,000 75,000 75,000 75,000 01-540-54-00-5442 GARBAGE SERVICES 1,177,611 1,193,400 1,046,784 900,000 1,023,500 1,023,500 1,023,500 1,023,500 1,030,000 01-540-54-00-5443 LEAF PICKUP 4,560 4,920 6,000 4,500 6,000 6,000 6,000 6,000 6,000 1,182,171 1,198,320 1,206,000 1,047,500 1,172,500 1,104,500 1,1043500 131049500 1,1113000 Total Public Works 1,788,536 1,703,802 1,9203452 19761,744 2,1053005 13968,798 1,9923873 2,0139558 29036,641 20 ADMINISTRATIVE SERVICES DEPARTMENT The Administrative Services Department accounts for expenditures that are shared by all departments within the General Fund. These expenditures include such items as tax rebates,bad debt,contingencies,corporate legal expenditures and interfund transfers. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 4,432 350 5,000 100 500 500 500 500 500 Benefits 1,659,479 1,709,445 562,389 393,290 352,518 372,817 394,521 394,677 415,592 Contractual Services 1,713,034 2,186,393 1,895,500 1,917,296 1,889,740 2,107,062 2,184,374 2,262,546 2,337,859 Supplies - 2,910 5,000 12,588 5,000 5,000 5,000 5,000 5,000 Contingencies 75,000 52,075 50,000 50,000 50,000 50,000 50,000 50,000 50,000 Other Financing Uses 1,516,778 1,297,950 1,516,661 1,504,683 3,798,673 2,276,458 2,387,916 3,630,415 2,911,434 Total Admin Services&Transfers 4,968,723 5,249,123 4,034,550 3,877,957 6,096,431 4,811,837 5,022,311 6,343,138 5,720,385 $7,000 $6,000 e $5,000 s H $4,000 $3,000 $2,000 $1,000 $0 21 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Administrative Services O1-640-50-00-5092 POLICE SPECIAL DETAIL WAGES 4,432 350 5,000 100 500 500 500 500 500 O1-640-52-00-5211 RETIREMENT PLAN CONTRIBUTION-ERI - - 60,000 - - - - - - O1-640-52-00-5216 GROUP HEALTH INSURANCE 1,135,216 1,199,018 - O1-640-52-00-5222 GROUP LIFE INSURANCE 23,151 14,022 O1-640-52-00-5223 DENTAL INSURANCE 83,004 86,598 O1-640-52-00-5224 VISION INSURANCE 11,991 10,117 - O1-640-52-00-5225 EMPLOYEE ASSISTANCE 2,425 - 150 - - - - - - O1-640-52-00-5230 UNEMPLOYMENT INSURANCE 77,786 91,200 47,143 37,000 45,000 45,000 45,000 45,000 45,000 O1-640-52-00-5231 LIABILITY INSURANCE 325,906 308,490 332,256 250,000 261,302 276,980 293,599 311,215 329,888 O1-640-52-00-5240 RETIREES-GROUP HEALTH INSURANCE - - 104,458 100,000 44,723 49,195 54,115 37,362 39,604 O1-640-52-00-5241 RETIREES-DENTAL INSURANCE 5,246 5,246 1,333 1,466 1,613 1,000 1,000 O1-640-52-00-5242 RETIREES-VISION INSURANCE 636 636 160 176 194 100 100 O1-640-52-00-5250 COBRA-GROUP HEALTH INSURANCE 11,375 408 - - - - - O1-640-52-00-5251 COBRA-DENTAL INSURANCE 1,000 - O1-640-52-00-5252 COBRA-VISION INSURANCE 125 - - - - - 01-640-54-00-5439 AMUSEMENT TAX REBATE - - 25,000 50,000 50,000 50,000 37,500 O1-640-54-00-5449 KENCOM - - 22,000 26,000 150,000 200,000 250,000 300,000 O1-640-54-00-5450 INFORMATION TECHNOLOGY SERVICES 55,155 140,000 140,000 90,000 94,500 99,225 104,186 109,396 O1-640-54-00-5453 SPECIAL ENGINEERING SERVICES - - - - - 50,000 50,000 50,000 50,000 01-640-54-00-5456 CORPORATE COUNSEL 117,960 81,998 130,000 110,000 110,000 115,500 121,275 127,339 133,706 01-640-54-00-5461 LITIGATION COUNSEL 87,544 70,469 60,000 60,000 60,000 60,000 60,000 60,000 60,000 O1-640-54-00-5462 PROFESSIONAL SERVICES - 450 500 901 500 500 500 500 500 01-640-54-00-5463 SPECIAL COUNSEL 59,394 25,261 25,000 25,000 25,000 25,000 25,000 25,000 25,000 O1-640-54-00-5465 ENGINEERING SERVICES - 222,269 180,000 180,000 180,000 180,000 180,000 180,000 180,000 O1-640-54-00-5475 CABLE CONSORTIUM FEE 75,262 93,150 85,000 85,000 85,000 85,000 85,000 85,000 85,000 O1-640-54-00-5479 COMMUNITY RELATIONS - 440 - - - - - - - O1-640-54-00-5481 HOTEL TAX REBATE 33,255 45,926 45,000 45,000 45,000 45,000 45,000 45,000 45,000 01-640-54-00-5491 CITY PROPERTY TAX REBATE 812 1,532 1,500 1,196 1,500 1,500 1,500 1,500 1,500 O1-640-54-00-5492 SALES TAX REBATE 863,793 1,024,421 824,000 824,000 832,240 840,562 857,374 874,521 900,757 01-640-54-00-5493 BUSINESS DISTRICT REBATE 283,777 305,908 300,000 300,000 300,000 300,000 300,000 300,000 300,000 01-640-54-00-5494 ADMISSIONS TAX REBATE 99,959 104,845 104,500 119,199 104,500 104,500 104,500 104,500 104,500 O1-640-54-00-5499 BAD DEBT 91,278 154,569 - 5,000 5,000 5,000 5,000 5,000 5,000 01-640-56-00-5625 REIMBURSABLE REPAIRS - 2,910 5,000 12,588 5,000 5,000 5,000 5,000 5,000 22 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected O1-640-70-00-7799 CONTINGENCIES 75,000 52,075 50,000 50,000 50,000 50,000 50,000 50,000 50,000 O1-640-99-00-9916 TRANSFER TO MUNICIPAL BUILDING - - - - 573,374 - - - - O1-640-99-00-9923 TRANSFER TO CITYWIDE CAPITAL 135,484 125,000 419,332 419,332 270,401 - 1,117,994 300,890 01-640-99-00-9942 TRANSFER TO DEBT SERVICE 429,404 103,740 99,465 99,465 - - 26,386 125,232 205,852 01-640-99-00-9952 TRANSFER TO SEWER - - - - 1,137,220 1,133,972 1,134,654 1,134,052 1,137,166 01-640-99-00-9979 TRANSFER TO PARKS&RECREATION 951,890 736,710 955,886 955,886 1,765,504 1,110,111 1,192,708 1,217,069 1,229,444 O1-640-99-00-9982 TRANSFER TO LIBRARY OPERATIONS - 332,500 41,978 30,000 52,174 32,375 34,168 36,068 38,082 4,968,723 5,249,123 4,034,550 3,877,957 6,096,431 4,811,837 5,022,311 6,3439138 5,7209385 Expenditures 11,296,930 10,969,330 11,3799867 10,875,236 13,891,560 12,648,275 13,037,173 14,476,325 13,982,166 Surplus(Deficit) 221,031 1,542,522 931,242 2,153,101 (882,071) 501,513 293,060 (984,594) (261,695) Fund Balance (2719900) 1,270,623 1,596,094 3,423,724 2,541,653 3,043,166 3,336,226 2,351,632 2,089,937 -2.41% 11.58% 14.03% 31.48% 18.30% 24.06% 25.59% 1624% 14.95% 23 Fox Hill SSA Fund (11) This fund was created for the purpose of maintaining the common areas of the Fox Hill Estates(SSA 2004-201)subdivision. All money for the fund is derived from property taxes levied on homeowners in the subdivision. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 19,894 3,786 3,786 3,786 3,786 8,536 8,536 8,536 8,536 Investment Earnings - 7 - 10 - - - - - Total Revenue 19,894 3,793 3,786 3,796 3,786 8,536 8,536 8,536 8,536 Expenditures Contractual Services 4,178 4,664 4,500 5,476 7,500 19,603 19,603 4,603 4,603 Total Expenditures 4,178 4,664 4,500 5,476 7,500 19,603 19,603 4,603 4,603 Surplus(Deficit) 15,716 (871) (714) (1,680) (3,714) (11,067) (11,067) 3,933 3,933 Ending Fund Balance 17,942 17,071 16,719 15,391 11,677 610 (10,457) (6,524) (2,591) 429.44% 366.02% 371.53% 281.06% 155.69% 3.11% -53.34% -141.73% -56.29% Fund Balance Na $10 s $0 H ($10) ($20) 24 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Fox Hill SSA-11 11-000-40-00-4011 PROPERTY TAXES-FOX HILL SSA 19,894 3,786 3,786 3,786 3,786 8,536 8,536 8,536 8,536 11-000-45-00-4500 INVESTMENT EARNINGS - 7 - 10 - - - - - Revenue 19,894 3,793 3,786 3,796 3,786 8,536 8,536 8,536 8,536 11-111-54-00-5417 TRAIL MAINTENANCE - - - - - 15,000 15,000 - - 11-111-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 4,178 4,664 4,500 5,476 7,500 4,603 4,603 4,603 4,603 Expenditures 4,178 4,664 4,500 5,476 7,500 19,603 19,603 4,603 4,603 Surplus(Deficit) 15,716 (871) (714) (1,680) (3,714) (11,067) (11,067) 3,933 3,933 Fund Balance 17,942 17,071 16,719 15,391 11,677 610 (10,457) (6,524) (2,591) 429.44% 36602% 371.53% 281.06% 155.69% 3.11% -53.34% -141.73% -56.29% 25 Sunflower SSA Fund (12) This fund was created for the purpose of maintaining the common areas of the Sunflower Estates(SSA 2006-119)subdivision. All money for the fund is derived from property taxes levied on homeowners in the subdivision. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 13,871 7,530 7,531 7,530 7,531 17,416 17,416 17,416 17,416 Investment Earnings - 7 - 10 - - - - - Total Revenue 13,871 7,537 7,531 7,540 7,531 17,416 17,416 17,416 17,416 Expenditures Contractual Services 8,136 7,272 9,986 11,714 14,985 35,985 35,985 10,985 10,985 Total Expenditures 8,136 7,272 9,986 11,714 14,985 35,985 35,985 10,985 10,985 Surplus(Deficit) 5,735 265 (2,455) (4,174) (7,454) (18,569) (18,569) 6,431 6,431 Ending Fund Balance 11,922 12,188 10,007 8,014 560 (18,009) (36,578) (30,147) (23,716) 146.53% 167.60% 100.21% 68.41% 3.74% -50.05% -101.65% -274.44% -215.89% $20 Fund Balance M $0 0 ($20) ($40) 26 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Sunflower SSA-12 12-000-40-00-4012 PROPERTY TAXES-SUNFLOWER SSA 13,871 7,530 7,531 7,530 7,531 17,416 17,416 17,416 17,416 12-000-45-00-4500 INVESTMENT EARNINGS - 7 - 10 - - - - - Revenue 13,871 7,537 7,531 7,540 79531 17,416 17,416 17,416 179416 12-112-54-00-5416 POND MAINTENANCE - - - - - 25,000 25,000 - - 12-112-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 8,136 7,272 9,986 11,714 14,985 10,985 10,985 10,985 10,985 Expenditures 89136 7,272 99986 11,714 14,985 35,985 35,985 10,985 109985 Surplus(Deficit) 59735 265 (29455) (4,174) (7,454) (18,569) (189569) 6,431 69431 Fund Balance 119922 12,188 109007 8,014 560 (18,009) (369578) (30,147) (239716) 14653% 167.60% 100.21% 68.41% 3.74% -50.05% -101.65% -274.44% -215.89% 27 Motor Fuel Tax Fund (15) The Motor Fuel Tax fund is used to maintain existing and construct new City owned roadways,alleys and parking lots. The fund also purchases materials used in the maintenance and operation of those facilities. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Intergovernmental 535,347 560,028 454,197 522,286 942,000 455,000 455,000 460,000 460,000 Investment Earnings 837 570 350 3,200 2,000 1,000 500 500 500 Reimbursements 151,000 - - 257 - - - - - Miscellaneous 85 - - - - - - - - Total Revenue 687,269 560,598 454,547 525,743 944,000 456,000 455,500 460,500 460,500 Expenditures Contractual Services 33,516 - - 7,500 23,500 7,500 7,500 7,500 7,500 Supplies 227,168 200,355 341,960 200,860 219,556 228,712 238,467 248,869 259,962 Capital Outlay 95,806 75,786 231,900 186,652 1,151,400 371,900 406,900 426,900 225,922 Other Financing Uses 96,000 - - - - - - - - Total Expenditures 452,490 276,141 573,860 395,012 1,394,456 608,112 652,867 683,269 493,384 Surplus(Deficit) 234,779 284,457 (119,313) 130,731 (450,456) (152,112) (197,367) (222,769) (32,884) Ending Fund Balance 640,399 924,857 465,255 1,055,588 605,132 453,020 255,653 32,884 - $1,200 Fund Balance $1,000 $800 O F $600 $400 $200 $0 28 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Motor Fuel Tax -15 15-000-41-00-4112 MOTOR FUEL TAX 425,971 417,416 415,000 410,000 410,000 415,000 415,000 420,000 420,000 15-000-41-00-4113 MET HIGH GROWTH 24,674 39,197 39,197 39,164 40,000 40,000 40,000 40,000 40,000 15-000-41-00-4170 STATE GRANTS 11,580 30,293 - - 492,000 - - - - 15-000-41-00-4172 ILLINOIS JOBS NOW PROCEEDS 73,122 73,122 - 73,122 - - - - - 15-000-45-00-4500 INVESTMENT EARNINGS 837 570 350 3,200 2,000 1,000 500 500 500 15-000-46-00-4605 REIMB-OLD JAIL/DWTWN PARKING LOT 151,000 - - - - - - - - 15-000-46-00-4690 REIMB-MISCELLANEOUS - 257 - 15-000-48-00-4850 MISCELLANEOUS INCOME 85 - - - - - - - Revenue 687,269 560,598 454,547 525,743 944,000 456,000 455,500 460,500 460,500 15-155-54-00-5438 SALT STORAGE - - - 7,500 7,500 7,500 7,500 7,500 7,500 15-155-54-00-5462 PROFESSIONAL SERVICES 2,587 - - - - - - 15-155-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 30,929 - - - 16,000 - - - - 15-155-56-00-5618 SALT 132,777 129,391 231,000 115,000 126,000 132,300 138,915 145,861 153,153 15-155-56-00-5619 SIGNS 1,232 6,732 35,000 20,000 15,000 15,000 15,000 15,000 15,000 15-155-56-00-5632 PATCHING 52,481 47,093 50,000 47,007 50,000 50,000 50,000 50,000 50,000 15-155-56-00-5633 COLD PATCH 9,892 5,855 11,660 6,441 12,826 14,109 15,519 17,071 18,779 15-155-56-00-5634 HOT PATCH 7,658 11,284 14,300 12,412 15,730 17,303 19,033 20,937 23,030 15-155-56-00-5640 REPAIR&MAINTENANCE 23,128 - - - - - - - - 15-155-60-00-6003 MATERIAL STORAGE BLDG CONSTRUCTION - 75,000 - - - - 15-155-60-00-6025 ROAD TO BETTER ROADS PROGRAM - - 250,000 250,000 250,000 205,000 104,022 15-155-60-00-6072 DOWNTOWN PARKING LOT 42,420 875 - - 492,000 - - - - 15-155-60-00-6073 GAME FARM ROAD PROJECT 31,456 68,086 110,000 110,000 212,500 15-155-60-00-6074 FOX ROAD PROJECT 21,930 - - - - 15-155-60-00-6075 RIVER ROAD BRIDGE PROJECT - 6,825 - - - - - - - 15-155-60-00-6079 ROUTE 47 EXPANSION - 121,900 76,652 121,900 121,900 121,900 121,900 121,900 15-155-60-00-6089 CANNONBALL LAFO PROJECT - - - - 35,000 100,000 - 29 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 15-155-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL 96,000 - - - - - - - Expenditures 452,490 276,141 573,860 395,012 1,394,456 608,112 652,867 683,269 493,384 Surplus(Deficit) 234,779 284,457 (119,313) 130,731 (450,456) (152,112) (197,367) (222,769) (32,884) Fund Balance 640,399 924,857 465,255 1,055,588 605,132 453,020 255,653 32,884 - 30 Municipal Building Fund (16) The Municipal Building Fund was used to maintain existing City owned buildings and to fund land acquisition,design and construction of new buildings. This fund will be closed out in fiscal year 2014. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Licenses&Permits 20,700 8,400 5,250 9,150 - - - - - Other Financing Sources - - - - 573,374 - - - - Total Revenue 20,700 8,400 5,250 9,150 573,374 - - - - Expenditures Contractual Services - 750 - 3,150 - - - - - Total Expenditures - 750 - 3,150 - - - - - Surplus(Deficit) 20,700 7,650 5,250 6,000 573,374 - - - - Ending Fund Balance (587,024) (579,374) (575,774) (573,374) - - - - - $0 Fund Balance tn ($200) ($400) ($600) ($800) 31 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Municipal Building-16 16-000-42-00-4214 DEVELOPMENT FEES 20,700 7,650 5,250 6,000 16-000-42-00-4216 BUILD PROGRAM PERMITS - 750 - 3,150 - 16-000-49-00-4901 TRANSFER FROM GENERAL - - - - 573,374 Revenue 20,700 8,400 5,250 9,150 573,374 - 16-160-54-00-5405 BUILD PROGRAM 750 3,150 Expenditures - 750 - 3,150 - - Surplus(Deficit) 20,700 7,650 53250 6,000 573,374 - Fund Balance (587,024) (579,374) (575,774) (573,374) - - 32 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. The Municipal Building fund was consolidated into this fund in fiscal year 2014. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Intergovernmental 64,000 - 231,000 - 327,600 93,760 218,200 147,160 512,720 Licenses&Permits 25,100 92,417 53,400 62,620 20,250 20,250 20,250 20,250 20,250 Charges for Service - - - - 669,120 669,120 669,120 669,120 669,120 Investment Earnings 19 114 - 250 250 500 250 100 - Reimbursements 1,200 9,586 - - - - - - - Miscellaneous - - - 13,500 126,441 - - - Other Financing Sources 231,484 125,000 1,019,332 754,332 435,401 4,750,000 - 1,117,994 300,890 Total Revenue 321,803 227,117 1,303,732 830,702 1,579,062 5,533,630 907,820 1,954,624 1,502,980 Expenditures Contractual Services 5,740 14,780 100,000 144,220 50,000 50,000 50,000 50,000 50,000 Capital Outlay 172,033 6,793 940,500 394,241 1,122,863 1,202,221 4,618,022 2,185,916 1,029,692 Debt Service 125,000 125,000 - - 83,333 83,333 414,887 416,998 418,038 Other Financing Uses - - - - 5,250 5,250 5,250 5,250 5,250 Total Expenditures 302,773 146,573 1,040,500 538,461 1,261,446 1,340,804 5,088,159 2,658,164 1,502,980 Surplus(Deficit) 19,030 80,544 263,232 292,241 317,616 4,192,826 (4,180,339) (703,540) - Municipal Building Fund Balance - - - - - - - - - City-Wide Capital Fund Balance 652 81,196 332,500 373,437 691,053 4,883,879 703,540 - Ending Fund Balance 652 81,196 332,500 373,437 691,053 4,883,879 703,540 - - „ $6,000 Fund Balance 3 $4,000 0 $2,000 $0 33 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected City-Wide Capital-23 23-000-41-00-4176 STATE GRANTS-SAFE ROUTE TO SCHOOL 231,000 280,000 - - - 23-000-41-00-4178 STATE GRANTS-ITEP KENNEDY RD TRAIL - - - 47,600 73,960 7,000 114,160 12,720 23-000-41-00-4179 STATE GRANTS-DCEO TAP OLD JAIL 64,000 - - - - - 23-000-41-00-4181 STATE GRANTS-KKCOM STP GAME FARM - 19,800 211,200 33,000 - 23-000-41-00-4183 STATE GRANTS-ITEP DOWNTOWN - - - - - - 500,000 23-000-42-00-4210 BUILDING PERMITS - 30,993 13,400 13,400 - 23-000-42-00-4213 ENGINEERING CAPITAL FEE 3,100 4,700 - - - - - - - 23-000-42-00-4214 DEVELOPMENT FEES - 7,944 20,000 5,000 5,000 5,000 5,000 5,000 5,000 23-000-42-00-4216 BUILD PROGRAM PERMITS 14,780 - 44,220 - - - - - 23-000-42-00-4218 DEVELOPMENT FEES-MUNICIPAL BLDG - - - - 5,250 5,250 5,250 5,250 5,250 23-000-42-00-4222 ROAD CONTRIBUTION FEE 22,000 34,000 20,000 10,000 10,000 10,000 10,000 10,000 23-000-44-00-4440 ROAD INFRASTRUCTURE FEE - - - - 669,120 669,120 669,120 669,120 669,120 23-000-45-00-4500 INVESTMENT EARNINGS 19 114 250 250 500 250 100 - 23-000-46-00-4690 REIMB-MISCELLANEOUS 1,200 9,586 - - - - - 23-000-48-00-4860 PUSH FOR THE PATH PROCEEDS - - - 126,441 23-000-48-00-4880 SALE OF FIXED ASSETS 13,500 - - 23-000-49-00-4900 BOND PROCEEDS - - - - - 4,750,000 - - 23-000-49-00-4901 TRANSFER FROM GENERAL 135,484 125,000 419,332 419,332 270,401 - 1,117,994 300,890 23-000-49-00-4905 LOAN PROCEEDS - - 600,000 335,000 165,000 - - 23-000-49-00-4915 TRANSFER FROM MOTOR FUEL TAX 96,000 - - - - - - - Revenue 321,803 227,117 1,303,732 830,702 1,5793062 5,533,630 9073820 13954,624 1,502,980 CW Municipal Building Expenditures 23-216-60-00-6020 BUILDINGS&STRUCTURES - - - - - - - - - 23-216-99-00-9901 TRANSFER TO GENERAL 5,250 5,250 5,250 5,250 5,250 - 5,250 5,250 53250 5,250 5,250 34 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected City-Wide Capital Expenditures 23-230-54-00-5405 BUILD PROGRAM - 14,780 - 44,220 23-230-54-00-5462 PROFESSIONAL SERVICES 5,740 - 100,000 100,000 - - - - 23-230-54-00-5465 ENGINEERING SERVICES - - - 50,000 50,000 50,000 50,000 50,000 23-230-60-00-6023 OLD JAIL PURCHASE 161,549 - - - - - - 23-230-60-00-6025 ROAD TO BETTER ROADS PROGRAM - 100,000 585,863 600,821 605,022 573,075 537,391 23-230-60-00-6041 SIDEWALK CONSTRUCTION 10,484 - 12,500 12,500 12,500 12,500 - 23-230-60-00-6048 DOWNTOWN STREETSCAPE IMPROV - - - - 450,000 450,000 23-230-60-00-6058 ROUTE 71(RTE 47-ORCHARD RD)PROJECT - 110,400 - - 23-230-60-00-6059 US 34(IL 47/ORCHARD RD)PROJECT - 230,200 - - 23-230-60-00-6073 GAME FARM ROAD PROJECT - - 20,000 261,000 3,876,100 770,000 23-230-60-00-6075 RIVER ROAD BRIDGE PROJECT - 600,000 335,000 165,000 - - - 23-230-60-00-6092 SAFE ROUTE TO SCHOOL PROJECT 6,793 231,000 25,255 280,000 - - - - 23-230-60-00-6094 KENNEDY RD BIKE TRAIL - 9,500 33,986 59,500 97,700 14,000 380,341 42,301 2015 Bond 23-230-81-00-8000 PRINCIPAL PAYMENT - - - - 200,000 180,000 185,000 23-230-81-00-8050 INTEREST PAYMENT - - 131,554 153,665 149,705 Kendall County Loan-River Road Bridge 23-230-97-00-8000 PRINCIPAL PAYMENT - - 83,333 83,333 83,333 83,333 83,333 Clark Property 23-230-97-00-8000 PRINCIPAL PAYMENT 125,000 125,000 - - - - - - - 302,773 146,573 1,040,500 538,461 1,256,196 1,335,554 5,082,909 2,652,914 1,497,730 Expenditures 302,773 146,573 1,0409500 538,461 1,261,446 1,340,804 5,088,159 2,658,164 1,5029980 Surplus(Deficit) 19,030 80,544 2639232 292,241 3179616 49192,826 (4,1809339) (703,540) - Fund Balance-Municipal Building - - - - - FundBalance-City WideCapital 652 81,196 332,500 373,437 691,053 4,883,879 703,540 Fund Balance 652 81,196 3329500 373,437 6919053 49883,879 7039540 - 35 Vehicle and Equipment Fund(25) This fund is new for fiscal year 2014,consolidating the Police Capital,Public Works Capital and Park&Recreation Capital funds. This fund primarily derives its revenue from monies collected from building permits and development fees. The revenue is used to purchase vehicles and equipment for use in the operations of the police,public works and parks departments. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Licenses&Permits 43,167 55,000 50,750 64,315 49,275 49,275 49,275 49,275 49,275 Fines&Forfeits 12,612 6,233 11,650 12,850 8,850 8,850 8,850 8,850 8,850 Charges for Service 4,897 6,040 20,000 5,632 150,150 113,452 136,087 136,087 136,087 Investment Earnings 99 405 300 520 475 475 475 475 475 Reimbursements 7,500 10,702 40,000 40,000 50,000 - - - - Miscellaneous 16,183 16,100 1,000 966 1,000 1,000 1,000 1,000 1,000 Other Financing Sources - 3,500 2,500 2,500 - - - - - Total Revenue 84,458 97,980 126,200 126,783 259,750 173,052 195,687 195,687 195,687 Police Capital Expenditures Contractual Services 9,493 2,647 12,500 17,270 11,667 11,667 11,667 11,667 11,667 Supplies - - 2,500 - - - - - - Capital Outlay 43,772 - 45,000 139,641 93,000 93,000 93,000 93,000 93,000 Sub-Total Expenditures 53,265 2,647 60,000 156,911 104,667 104,667 104,667 104,667 104,667 Public Works Capital Expenditures Contractual Services 49 10,076 10,500 21,402 6,500 6,500 6,500 6,500 6,500 Supplies - - 2,000 2,000 2,000 2,000 2,000 2,000 2,000 Capital Outlay 4,000 - 75,000 75,000 30,000 - - - - Debt Service 82,295 82,295 82,295 82,295 79,795 79,795 79,795 79,795 79,795 Sub-Total Expenditures 86,344 92,371 169,795 180,697 118,295 88,295 88,295 88,295 88,295 Parks Capital Expenditures Capital Outlay 24,658 - 50,000 12,000 17,000 16,000 - - - Debt Service - - - - 2,500 2,500 2,500 2,500 2,500 Other Financing Uses - 3,500 2,500 2,500 50,000 - - - - Sub-Total Expenditures 24,658 3,500 52,500 14,500 69,500 18,500 2,500 2,500 2,500 Total Expenditures 164,267 98,518 282,295 352,108 292,462 211,462 195,462 195,462 195,462 Surplus(Deficit) (79,809) (538) (156,095) (225,325) (32,712) (38,410) 225 225 225 Police Capital Fund Balance 194,947 229,238 104,737 101,427 22,635 - - - Public Works Capital Fund Balance 108,743 62,884 (65,159) (62,855) - - - - - Parks Capital Fund Balance 51,443 62,473 22,545 90,698 73,923 58,148 58,373 58,598 58,823 Ending Fund Balance 355,133 354,595 629123 129,270 96,558 58,148 58,373 58,598 58,823 N $400 Fund Balance �o $300 3 c $200 F $100 $0 36 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Vehicle&Eauiument-25 25-000-42-00-4215 DEVELOPMENT FEES-POLICE CAPITAL 16,009 15,450 10,500 16,000 16,000 16,000 16,000 16,000 16,000 25-000-42-00-4216 BUILD PROGRAM PERMITS - 3,500 - 15,040 - - - - - 25-000-42-00-4217 WEATHER WARNING SIREN FEES 408 - 6,000 - - - - - - 25-000-42-00-4218 ENGINEERING CAPITAL FEE - - 6,500 6,500 6,500 6,500 6,500 6,500 6,500 25-000-42-00-4219 DEVELOPMENT FEES-PW CAPITAL 25,100 33,450 24,500 24,500 24,500 24,500 24,500 24,500 24,500 25-000-42-00-4220 DEVELOPMENT FEES-PARK CAPITAL 1,650 2,600 3,250 2,275 2,275 2,275 2,275 2,275 2,275 25-000-43-00-4315 DUI FINES 6,462 3,116 6,000 3,100 3,100 3,100 3,100 3,100 3,100 25-000-43-00-4316 ELECTRONIC CITATION FEES 122 782 650 750 750 750 750 750 750 25-000-43-00-4340 SEIZED VEHICLE PROCEEDS 6,028 2,335 5,000 9,000 5,000 5,000 5,000 5,000 5,000 25-000-44-00-4418 MOWING INCOME 4,897 6,040 20,000 5,632 5,500 5,500 5,500 5,500 5,500 25-000-44-00-4420 POLICE CHARGEBACK - - - - - 56,157 78,792 78,792 78,792 25-000-44-00-4421 PUBLIC WORKS CHARGEBACK - - - 144,650 51,795 51,795 51,795 51,795 25-000-45-00-4520 INVESTMENT EARNINGS-POLICE CAPITAL 55 50 50 25 25 25 25 25 25-000-45-00-4521 INVESTMENT EARNINGS-PW CAPITAL - 22 - 20 - - - - - 25-000-45-00-4522 INVESTMENT EARNINGS-PARK CAPITAL 99 328 250 450 450 450 450 450 450 25-000-46-00-4622 REIMB-MISCELLANEOUS-PARK CAPITAL 7,500 10,702 40,000 40,000 50,000 - - - - 25-000-48-00-4852 MISCELLANEOUS INCOME-POLICE CAPITAL - - - - - 25-000-48-00-4854 MISCELLANEOUS INCOME-PW CAPITAL 7,283 - - 766 - - - - - 25-000-48-00-4882 SALE OF FIXED ASSETS-POLICE CAPITAL 8,900 15,200 1,000 200 1,000 1,000 1,000 1,000 1,000 25-000-48-00-4883 SALE OF FIXED ASSETS-PARKS CAPITAL - 900 - - - - - - - 25-000-49-00-4922 TRANSFER FROM PARK&REC CAPITAL - 3,500 2,500 2,500 - - - - - Revenue 84,458 97,980 126,200 126,783 259,750 173,052 195,687 195,687 195,687 Police Capital 25-205-54-00-5462 PROFESSIONAL SERVICES 3,060 2,647 2,500 3,542 1,667 19667 1,667 1,667 1,667 25-205-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 6,433 - 10,000 13,728 10,000 109000 10,000 109000 10,000 25-205-56-00-5620 OPERATING SUPPLIES - 2,500 - - - - - - 25-205-60-00-6060 EQUIPMENT 1,462 20,000 100,190 3,000 3,000 3,000 3,000 3,000 25-205-60-00-6070 VEHICLES 42,310 - 25,000 39,451 90,000 90,000 90,000 90,000 90,000 53,265 2,647 609000 156,911 104,667 104,667 1043667 104,667 1043667 37 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Public Works Capital 25-215-54-00-5405 BUILD PROGRAM - 3,500 - 15,040 - - - - 25-215-54-00-5448 FILING FEES 49 2,576 6,000 1,862 2,000 2,000 2,000 2,000 2,000 25-215-54-00-5485 RENTAL&LEASE PURCHASE - 4,000 4,500 4,500 4,500 4,500 4,500 4,500 4,500 25-215-56-00-5620 OPERATING SUPPLIES - - 2,000 2,000 2,000 2,000 2,000 2,000 2,000 25-215-60-00-6060 EQUIPMENT 4,000 75,000 75,000 - - - - - 25-215-60-00-6070 VEHICLES - - - - 30,000 - - - - 185 Wolf 5treetBuilding 25-215-92-00-8000 PRINCIPAL PAYMENT 26,544 28,254 30,074 30,074 31,040 33,039 35,168 37,433 39,846 25-215-92-00-8050 INTEREST PAYMENT 55,751 54,041 52,221 52,221 48,755 46,756 44,627 42,362 39,949 86,344 92,371 169,795 180,697 1183295 88,295 883295 88,295 88,295 Parks&Recreation Capital 25-225-60-00-6035 RAINTREE PARK 9,002 - 10,000 5,000 - - - - 25-225-60-00-6042 BASEBALL FIELD CONSTRUCTION 15,656 - - - 25-225-60-00-6060 EQUIPMENT - 40,000 12,000 12,000 16,000 - - - 185 Wolf 5treetBuilding 25-225-92-00-8000 PRINCIPAL PAYMENT - - 972 1,035 1,102 1,173 1,248 25-225-92-00-8050 INTEREST PAYMENT - - - 1,528 1,465 1,398 1,327 1,252 25-225-99-00-9921 TRANSFER TO PUBLIC WORKS CAPITAL - 3,500 2,500 2,500 - - - - - 25-225-99-00-9972 TRANSFER TO LAND CASH - 50,000 - - - - 24,658 3,500 52,500 14,500 69,500 18,500 2,500 2,500 2,500 Expenditures 164,267 98,518 282,295 352,108 292,462 211,462 195,462 195,462 195,462 Surplus(Deficit) (79,809) (538) (156,095) (225,325) (32,712) (38,410) 225 225 225 Fund Balance-Police Capital 194,947 229,238 104,737 101,427 22,635 Fund Balance-Public Works Capital 108,743 62,884 (65,159) (62,855) Fund Balance-Parks&Rec Capital 51,443 62,473 22,545 90,698 73,923 58,148 58,373 58,598 58,823 Fund Balance 355,133 354,595 62,123 129,270 96,558 58,148 58,373 589598 58,823 38 Debt Service Fund (42) The Debt Service Fund accumulates monies for payment of the 2005A bonds,which were issued to finance road improvement projects. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes - 323,350 326,379 324,762 328,179 329,579 290,732 210,022 129,402 Licenses&Permits 1,025 1,375 1,000 3,969 1,000 1,000 1,000 1,000 1,000 Investment Earnings - 283 300 350 300 300 300 300 300 Other Financing Sources 429,404 182,517 99,465 99,465 - - 26,386 125,232 205,852 Total Revenue 430,429 507,525 427,144 428,546 329,479 330,879 318,418 336,554 336,554 Expenditures Contractual Services - 749 963 963 375 375 375 375 375 Debt Service 429,404 427,919 504,407 504,407 328,179 329,579 330,579 336,179 336,179 Total Expenditures 429,404 428,668 505,370 505,370 328,554 329,954 330,954 336,554 336,554 Surplus(Deficit) 1,025 78,857 (78,226) (76,824) 925 925 (12,536) - - Ending Fund Balance 8,653 87,510 8,925 10,686 11,611 12,536 - - - $100 Fund Balance $80 c $60 F- $40 $20 $0 39 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Debt Service-42 42-000-40-00-4006 PROPERTY TAXES-2005A BOND - 323,350 326,379 324,762 328,179 329,579 290,732 210,022 129,402 42-000-42-00-4208 RECAPTURE FEES-WATER&SEWER 1,025 1,375 1,000 3,969 1,000 1,000 1,000 1,000 1,000 42-000-45-00-4500 INVESTMENT EARNINGS - 283 300 350 300 300 300 300 300 42-000-49-00-4901 TRANSFER FROM GENERAL 429,404 103,740 99,465 99,465 - - 26,386 125,232 205,852 42-000-49-00-4985 TRANSFER FROM FOX INDUSTRIAL TIF - 78,777 - - - - - - Revenue 430,429 507,525 427,144 428,546 329,479 330,879 3183418 336,554 3369554 42-420-54-00-5498 PAYING AGENT FEES - 749 963 963 375 375 375 375 375 2004C Bond 42-420-81-00-8000 PRINCIPAL PAYMENT 95,000 95,000 95,000 95,000 - - - - - 42-420-81-00-8050 INTEREST PAYMENT 12,825 8,740 4,465 4,465 - - - - - 2005A Bond 42-420-82-00-8000 PRINCIPAL PAYMENT 185,000 195,000 205,000 205,000 215,000 225,000 235,000 250,000 260,000 42-420-82-00-8050 INTEREST PAYMENT 136,579 129,179 121,379 121,379 113,179 1049579 95,579 86,179 76,179 2002 Fox Industrial TIF Bond 42-420-98-00-8000 PRINCIPAL PAYMENT - - 75,000 75,000 - - - - - 42-420-98-00-8050 INTEREST PAYMENT - - 3,563 3,563 - - - - - Expenditures 429,404 428,668 5053370 505,370 328,554 329,954 330,954 336,554 3369554 Surplus(Deficit) 1,025 78,857 (783226) (76,824) 925 925 (123536) - - Fund Balance 8,653 87,510 83925 10,686 11,611 12,536 - - 40 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 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes - 133,524 133,454 132,793 43,027 41,959 - - - Licenses&Permits - 11,970 - 54,590 - - - - - Charges for Service 2,503,003 2,580,682 2,527,871 2,799,135 2,458,740 2,487,934 2,517,566 2,547,642 2,578,170 Investment Earnings 1,888 282 300 1,700 2,000 2,500 3,000 3,500 4,000 Reimbursements - 1,771 7,466 8,232 - - - - - Miscellaneous 40,793 43,106 50,000 53,073 54,336 55,632 56,963 58,329 59,731 Other Financing Sources 82,850 83,863 82,288 82,288 82,988 83,588 84,088 84,488 82,288 Total Revenue 2,628,534 2,855,198 2,801,379 3,131,811 2,641,091 2,671,613 2,661,617 2,693,959 2,724,189 Expenses Salaries 346,735 332,461 382,000 362,000 339,697 339,697 339,697 339,697 339,697 Benefits 57,450 56,284 219,720 208,468 202,339 214,835 228,521 238,181 248,418 Contractual Services 493,345 518,831 501,200 542,740 497,450 511,625 526,509 542,137 558,546 Supplies 264,325 267,849 294,124 291,926 301,873 298,734 301,795 305,071 308,576 Capital Outlay - 25,054 132,000 91,305 345,434 1,002,784 1,111,894 806,374 246,254 Developer Commitments 275,865 275,865 160,923 160,921 - - - - - Debt Service 834,453 903,277 1,396,016 1,396,016 1,172,802 1,168,384 1,163,054 1,166,825 1,154,236 Total Expenses 2,272,173 2,379,621 3,085,983 3,053,376 2,859,595 3,536,059 3,671,470 3,398,285 2,855,727 Surplus(Deficit) 356,361 475,577 (284,604) 78,435 (218,504) (864,446) (1,009,853) (704,326) (131,538) Ending Fund Balance Equivalent 825,261 1,300,837 642,452 1,379,272 1,160,768 296,322 (713,531) (1,417,857) (1,549,395) 36.32% 54.67% 20.82% 45.17% 40.59% 8.38% -19.43% -41.72% -54.26% $2,000 Fund Balance Equivalent N $1,000 .,- s $0 - ($1,000) ($2,000 41 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Water-51 51-000-40-00-4007 PROPERTY TAXES-2007A BOND 133,524 133,454 132,793 43,027 41,959 51-000-42-00-4216 BUILD PROGRAM PERMITS - 11,970 - 54,590 - - - - 51-000-44-00-4424 WATER SALES 1,698,753 1,751,822 1,699,871 1,922,239 1,946,267 1,975,461 2,005,093 2,035,169 2,065,697 51-000-44-00-4425 BULK WATER SALES 882 329 500 10,796 500 500 500 500 500 51-000-44-00-4426 LATE PENALTIES-WATER - - - 90,000 90,000 90,000 90,000 90,000 90,000 51-000-44-00-4430 WATER METER SALES 22,040 25,365 26,250 26,250 27,563 27,563 27,563 27,563 27,563 51-000-44-00-4440 WATER INFRASTRUCTURE FEE 685,188 696,716 675,000 690,000 334,560 334,560 334,560 334,560 334,560 51-000-44-00-4450 WATER CONNECTION FEES 96,140 106,450 126,250 59,850 59,850 59,850 59,850 59,850 59,850 51-000-44-00-4473 RECAPTURE FEES - - - - - - - - - 51-000-45-00-4500 INVESTMENT EARNINGS 1,888 282 300 1,700 2,000 2,500 3,000 3,500 4,000 51-000-46-00-4670 REIMB-EMPLOYEE INS CONTRIBUTIONS - - 7,225 7,872 - - - - - 51-000-46-00-4671 REIMB-LIFE INSURANCE - 241 160 51-000-46-00-4690 REIMB-MISCELLANEOUS - 1,771 - 200 - - - - - 51-000-48-00-4820 RENTAL INCOME 32,038 39,491 50,000 53,073 54,336 55,632 56,963 58,329 59,731 51-000-48-00-4821 BAD DEBT RECOVERY 4,437 3,517 - - - - - - - 51-000-48-00-4850 MISCELLANEOUS INCOME 4,318 98 - - - - - - - 51-000-49-00-4952 TRANSFER FROM SEWER 82,850 83,863 82,288 82,288 82,988 83,588 84,088 84,488 82,288 Revenue 2,628,534 2,855,198 2,801,379 39131,811 2,6419091 2,671,613 2,661,617 2,6939959 2,7249189 Water Operations 51-510-50-00-5010 SALARIES&WAGES 342,790 324,679 370,000 350,000 327,697 3279697 327,697 327,697 327,697 51-510-50-00-5020 OVERTIME 3,945 7,782 12,000 12,000 12,000 12,000 12,000 12,000 12,000 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION 32,128 31,777 39,852 39,852 37,648 379648 37,648 37,648 37,648 51-510-52-00-5214 FICA CONTRIBUTION 25,322 24,507 28,200 28,200 25,277 25,277 25,277 25,277 25,277 51-510-52-00-5216 GROUP HEALTH INSURANCE - - 103,966 103,966 102,854 113,139 124,453 131,921 139,836 51-510-52-00-5222 GROUP LIFE INSURANCE 1,210 1,000 722 729 737 744 751 51-510-52-00-5223 DENTAL INSURANCE 7,201 6,700 6,599 79259 7,985 8,464 8,972 51-510-52-00-5224 VISION INSURANCE 829 750 729 802 882 935 991 51-510-52-00-5230 UNEMPLOYMENT INSURANCE 6,000 4,000 4,000 4,000 4,000 4,000 4,000 51-510-52-00-5231 LIABILITY INSURANCE - - 32,462 24,000 24,510 25,981 27,539 29,192 30,943 51-510-54-00-5401 ADMINISTRATIVE CHARGEBACK 91,863 91,863 - - - - - - - 51-510-54-00-5405 BUILD PROGRAM - 11,970 54,590 42 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 51-510-54-00-5412 TRAINING&CONFERENCES 1,842 330 2,000 2,000 2,000 2,000 2,000 2,000 2,000 51-510-54-00-5415 TRAVEL&LODGING 390 287 1,600 1,600 1,600 1,600 1,600 1,600 1,600 51-510-54-00-5426 PUBLISHING&ADVERTISING 934 1,172 1,000 1,000 1,000 1,000 1,000 1,000 1,000 51-510-54-00-5429 WATER SAMPLES 10,265 4,294 14,000 14,000 14,000 14,000 14,000 14,000 14,000 51-510-54-00-5430 PRINTING&DUPLICATING 1,164 86 2,500 2,500 2,500 2,500 2,500 2,500 2,500 51-510-54-00-5440 TELECOMMUNICATIONS 15,598 19,205 24,500 24,500 24,500 24,500 24,500 24,500 24,500 51-510-54-00-5445 TREATMENT FACILITY SERVICES 64,626 85,003 100,000 100,000 100,000 100,000 100,000 100,000 100,000 51-510-54-00-5448 FILING FEES 4,123 5,888 6,200 6,200 6,200 6,200 6,200 6,200 6,200 51-510-54-00-5452 POSTAGE&SHIPPING 16,716 17,167 22,000 22,000 22,000 22,000 22,000 22,000 22,000 51-510-54-00-5460 DUES&SUBSCRIPTIONS 899 629 1,250 1,250 1,250 1,250 1,250 1,250 1,250 51-510-54-00-5462 PROFESSIONAL SERVICES 3,695 9,755 8,800 10,000 10,000 10,000 10,000 10,000 10,000 51-510-54-00-5466 LEGAL SERVICES - 2,000 2,000 2,000 2,000 2,000 2,000 2,000 51-510-54-00-5480 UTILITIES 262,977 239,606 299,250 270,000 283,500 297,675 312,559 328,187 344,596 51-510-54-00-5483 JULIE SERVICES 2,422 3,426 3,500 3,500 4,500 4,500 4,500 4,500 4,500 51-510-54-00-5485 RENTAL&LEASE PURCHASE - 396 1,000 1,000 1,000 1,000 1,000 1,000 1,000 51-510-54-00-5490 VEHICLE MAINTENANCE SERVICES 3,855 12,832 10,000 10,000 5,000 5,000 5,000 5,000 5,000 51-510-54-00-5498 PAYING AGENT FEES 1,552 1,552 1,600 1,600 1,400 1,400 1,400 1,400 1,400 51-510-54-00-5499 BAD DEBT 10,424 13,370 - 15,000 15,000 15,000 15,000 15,000 15,000 51-510-56-00-5600 WEARING APPAREL 2,206 3,045 4,000 4,000 4,000 4,000 4,000 4,000 4,000 51-510-56-00-5620 OPERATING SUPPLIES 21,468 16,036 21,425 21,425 25,000 25,000 25,000 25,000 25,000 51-510-56-00-5628 VEHICLE MAINTENANCE SUPPLIES - - - - 7,500 7,500 7,500 7,500 7,500 51-510-56-00-5630 SMALL TOOLS&EQUIPMENT 412 459 4,000 4,000 2,000 2,000 2,000 2,000 2,000 51-510-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 338 560 6,000 6,000 6,000 6,000 6,000 6,000 6,000 51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 176,762 177,643 165,000 165,000 155,000 155,000 155,000 155,000 155,000 51-510-56-00-5640 REPAIR&MAINTENANCE 995 7,368 9,500 9,500 9,500 9,500 9,500 9,500 9,500 51-510-56-00-5664 METERS&PARTS 32,136 29,092 46,000 46,000 52,000 46,000 46,000 46,000 46,000 51-510-56-00-5695 GASOLINE 30,008 33,646 38,199 36,001 40,873 43,734 46,795 50,071 53,576 51-510-60-00-6025 ROAD TO BETTER ROADS PROGRAM - - - - 206,340 845,690 972,800 667,280 107,160 51-510-60-00-6060 EQUIPMENT 16,000 16,000 10,000 10,000 10,000 10,000 10,000 51-510-60-00-6070 VEHICLES - - - - 18,000 - - - 51-510-60-00-6079 ROUTE 47 EXPANSION - 25,054 116,000 75,305 129,094 129,094 129,094 129,094 129,094 51-510-75-00-7502 GRANDE RESERVE COURT ORDER 275,865 275,865 160,923 160,921 - - - - - 43 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Debt Service-2007A Bond 51-510-83-00-8000 PRINCIPAL PAYMENT 10,000 10,000 10,000 10,000 15,000 15,000 15,000 15,000 15,000 51-510-83-00-8050 INTEREST PAYMENT 124,266 123,866 123,454 123,454 123,041 122,423 121,793 121,163 120,525 Debt Service-2002 Capital Appreciation Debt Certificates 51-510-85-00-8000 PRINCIPAL PAYMENT 215,000 285,000 365,000 365,000 - - - - - 51-510-85-00-8050 INTEREST PAYMENT - - - - - - - - - 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 33,150 33,150 33,150 33,150 29,350 25,450 21,450 17,300 Debt Service-2006A Refunding Debt Certificates 51-510-87-00-8000 PRINCIPAL PAYMENT 70,000 70,000 355,000 355,000 405,000 420,000 435,000 460,000 475,000 51-510-87-00-8050 INTEREST PAYMENT 91,306 88,506 219,806 219,806 205,606 189,406 172,606 155,206 136,806 Debt Service-2005C Bond 51-510-88-00-8000 PRINCIPAL PAYMENT 85,000 90,000 , 90,000 90,000 95,000 100,000 105,000 110,000 110,000 51-510-88-00-8050 INTEREST PAYMENT 80,700 77,725 , 74,575 74,575 70,975 67,175 63,175 58,975 54,575 Debt Service-IEPA Loan L17-156300 51-510-89-00-8000 PRINCIPAL PAYMENT 83,500 85,600 87,754 87,754 89,961 92,224 94,544 96,923 99,361 51-510-89-00-8050 INTEREST PAYMENT 41,531 39,430 37,277 37,277 35,069 32,806 30,486 28,108 25,669 Expenses 2,272,173 2,379,621 3,085,983 3,053,376 2,8593595 33536,059 3,6713470 333989285 2,855,727 Surplus(Deficit) 356,361 475,577 (284,604) 78,435 (218,504) (864,446) (1,009,853) (704,326) (131,538) Fund Balance Equiv 825,261 1,300,837 642,452 1,379,272 1,160,768 296,322 (713,531) (1,417,857) (1,549,395) 3632% 54.67% 20.82% 45.17% 40.59% 8.38% -19.43% -41.72% -54.26% 44 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 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes - 1,750,206 263,850 262,543 114,940 Licenses&Permits - 4,000 - 18,000 - - - - - Charges for Service 1,471,981 1,362,022 1,368,380 1,347,769 1,097,560 1,097,560 1,097,560 1,097,560 1,097,560 Investment Earnings 1,517 2,405 3,000 6,200 5,500 5,500 5,000 4,500 4,500 Reimbursements 4,576 1,741 4,587 8,740 - - - - - Other Financing Sources - - - - 1,137,220 1,133,972 1,134,654 1,134,052 1,137,166 Total Revenue 1,478,074 3,120,374 1,639,817 1,643,252 2,355,220 2,237,032 2,237,214 2,236,112 2,239,226 Expenses Salaries 241,621 198,218 212,000 212,000 189,544 189,544 189,544 189,544 189,544 Benefits 40,046 33,563 132,802 126,491 98,540 103,948 109,857 114,168 118,735 Contractual Services 135,927 140,460 73,400 102,400 80,950 83,943 86,784 90,084 93,548 Supplies 51,419 45,381 65,711 69,673 83,206 87,792 92,687 97,915 101,203 Capital Outlay - 25,054 60,000 38,951 66,773 440,413 253,353 409,723 66,773 Developer Commitments 30,996 30,996 180,996 30,996 - - - - - Debt Service 1,252,597 1,416,416 1,088,013 1,088,013 1,968,119 2,054,461 1,865,399 1,865,857 1,877,110 Other Financing Uses 82,850 604,582 82,288 82,288 82,988 83,588 84,088 84,488 82,288 Total Expenses 1,835,456 2,494,670 1,895,210 1,750,812 2,570,120 3,043,689 2,681,712 2,851,779 2,529,201 Surplus(Deficit) (357,382) 625,704 (255,393) (107,560) (214,900) (806,657) (444,498) (615,667) (289,975) Ending Fund Balance Equivalent 2,377,831 3,003,537 2,625,761 2,895,977 2,681,077 1,874,420 1,429,922 814,255 524,280 129.55% 120.40% 138.55% 165.41% 104.32% 61.58% 53.32% 28.55% 20.73% r $4,000 Fund Balance Equivalent H $3,000 ° ° $2,000 $1,000 $0 45 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Sewer-52 52-000-40-00-4009 PROPERTY TAXES-2004B BOND 257,989 263,850 262,543 114,940 52-000-40-00-4013 PROPERTY TAXES-2005D BOND 1,382,408 - - - 52-000-40-00-4014 PROPERTY TAXES-2008 BOND 109,809 - 52-000-42-00-4216 BUILD PROGRAM PERMITS 4,000 - 18,000 - - - - 52-000-44-00-4435 SEWER MAINTENANCE FEES 731,743 742,022 728,280 741,255 740,000 740,000 740,000 740,000 740,000 52-000-44-00-4440 SEWER INFRASTRUCTURE FEE - - - - 334,560 334,560 334,560 334,560 334,560 52-000-44-00-4455 SW CONNECTION FEES-OPERATIONS 4,000 4,800 5,100 1,000 1,000 1,000 1,000 1,000 1,000 52-000-44-00-4456 SW CONNECTION FEES-CAPITAL 38,000 43,200 35,000 7,000 10,000 10,000 10,000 10,000 10,000 52-000-44-00-4457 SW CONNECTION FEES-ROB ROY 698,000 572,000 600,000 586,000 - - - - - 52-000-44-00-4462 LATE PENALTIES-SEWER - - - 12,000 12,000 12,000 12,000 12,000 12,000 52-000-44-00-4465 RIVER CROSSING FEES 238 514 - - - - - 52-000-44-00-4473 RECAPTURE FEES - - - - - - - - - 52-000-45-00-4500 INVESTMENT EARNINGS 1,517 2,405 3,000 6,200 5,500 5,500 5,000 4,500 4,500 52-000-46-00-4670 REIMB-EMPLOYEE INS CONTRIBUTIONS - - 4,587 4,637 - - - - - 52-000-46-00-4690 REIMB-MISCELLANEOUS 4,576 1,741 - 4,103 - - - - - 52-000-49-00-4901 TRANSFER FROM GENERAL - - - - 1,137,220 1,133,972 1,134,654 1,134,052 1,137,166 Revenue 1,478,074 3,120,374 1,639,817 1,643,252 2,355,220 2,237,032 2,237,214 2,236,112 2,239,226 Sewer Operations 52-520-50-00-5010 SALARIES&WAGES 241,173 198,017 210,000 210,000 187,544 187,544 187,544 187,544 187,544 52-520-50-00-5020 OVERTIME 448 201 2,000 2,000 2,000 2,000 2,000 2,000 2,000 52-520-52-00-5212 RETIREMENT PLAN CONTRIBUTION 22,383 18,927 21,290 21,290 21,007 21,007 21,007 21,007 21,007 52-520-52-00-5214 FICA CONTRIBUTION 17,663 14,636 18,000 18,000 14,223 14,223 14,223 14,223 14,223 52-520-52-00-5216 GROUP HEALTH INSURANCE - - 63,595 63,595 41,481 45,629 50,192 53,204 56,396 52-520-52-00-5222 GROUP LIFE INSURANCE 537 537 365 369 372 376 380 52-520-52-00-5223 DENTAL INSURANCE 4,687 4,687 2,653 2,918 3,210 3,403 3,607 52-520-52-00-5224 VISION INSURANCE 532 532 307 338 371 394 417 52-520-52-00-5230 UNEMPLOYMENT INSURANCE 2,571 2,100 2,500 2,500 2,500 2,500 2,500 52-520-52-00-5231 LIABILITY INSURANCE - - 21,590 15,750 16,004 16,964 17,982 19,061 20,205 52-520-54-00-5401 ADMINISTRATIVE CHARGEBACK 83,045 83,045 - - - - - - - 52-520-54-00-5405 BUILD PROGRAM - 4,000 - 18,000 - - - - - 52-520-54-00-5412 TRAINING&CONFERENCES - 500 500 500 500 500 500 500 46 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 52-520-54-00-5415 TRAVEL&LODGING 500 500 500 500 500 500 500 52-520-54-00-5430 PRINTING&DUPLICATING - - 100 100 100 100 100 100 100 52-520-54-00-5440 TELECOMMUNICATIONS 1,399 1,699 1,800 1,800 2,500 2,500 2,500 2,500 2,500 52-520-54-00-5444 LIFT STATION SERVICES 5,623 16,541 15,000 15,000 15,750 16,538 17,364 18,233 19,144 52-520-54-00-5462 PROFESSIONAL SERVICES 4,022 5,960 5,000 5,000 5,000 5,000 5,000 5,000 5,000 52-520-54-00-5480 UTILITIES 21,071 19,782 42,000 42,000 44,100 46,305 48,620 51,051 53,604 52-520-54-00-5485 RENTAL&LEASE PURCHASE - 396 1,500 1,500 1,500 1,500 1,500 1,500 1,500 52-520-54-00-5490 VEHICLE MAINTENANCE SERVICES 4,908 3,997 4,000 12,000 5,000 5,000 5,000 5,000 5,000 52-520-54-00-5498 PAYING AGENT FEES - 2,511 3,000 3,000 3,000 3,000 2,700 2,700 2,700 52-520-54-00-5499 BAD DEBT 15,859 2,529 - 3,000 3,000 3,000 3,000 3,000 3,000 52-520-56-00-5600 WEARING APPAREL 1,830 2,753 2,500 2,500 2,500 2,500 2,500 2,500 2,500 52-520-56-00-5610 OFFICE SUPPLIES 1,072 519 2,000 2,000 2,000 2,000 2,000 2,000 2,000 52-520-56-00-5613 LIFT STATION MAINTENANCE 4,747 1,312 10,000 10,000 10,500 11,025 11,576 12,155 12,763 52-520-56-00-5620 OPERATING SUPPLIES 1,891 3,690 4,500 4,500 4,500 4,500 4,500 4,500 4,500 52-520-56-00-5628 VEHICLE MAINTENANCE SUPPLIES - - - - 2,000 2,000 2,000 2,000 2,000 52-520-56-00-5630 SMALL TOOLS&EQUIPMENT 1,354 781 4,500 4,500 2,500 2,500 2,500 2,500 2,500 52-520-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 879 77 3,000 3,000 1,200 1,200 1,200 1,200 1,200 52-520-56-00-5640 REPAIR&MAINTENANCE 10,954 5,246 10,000 10,000 26,750 28,623 30,626 32,770 32,770 52-520-56-00-5695 GASOLINE 28,692 31,003 29,211 33,173 31,256 33,444 35,785 38,290 40,970 52-520-60-00-6025 ROAD TO BETTER ROADS PROGRAM - - - - - 343,640 186,580 342,950 - 52-520-60-00-6070 VEHICLES - - - - 30,000 - - - 52-520-60-00-6079 ROUTE 47 EXPANSION - 25,054 60,000 38,951 66,773 66,773 66,773 66,773 66,773 52-520-75-00-7500 LENNAR-RAINTREE SEWER RECPATURE 30,996 30,996 30,996 30,996 - - - - - 52-520-75-00-7501 WINDETT RIDGE-SEWER RECAPTURE - - 150,000 - - - - - - Debt Service-2004B Bond 52-520-84-00-8000 PRINCIPAL PAYMENT 155,000 160,000 170,000 170,000 280,000 375,000 395,000 410,000 435,000 52-520-84-00-8050 INTEREST PAYMENT 103,300 98,650 93,850 93,850 88,750 78,950 65,825 52,000 35,600 Debt Service-2003 IRBB Debt Certificates 52-520-90-00-8000 PRINCIPAL PAYMENT 90,000 95,000 100,000 100,000 100,000 105,000 110,000 115,000 120,000 52-520-90-00-8050 INTEREST PAYMENT 73,653 70,143 66,248 66,248 62,048 57,648 52,870 47,755 42,293 Debt Service-2004A Bond 52-520-91-00-8000 PRINCIPAL PAYMENT 160,000 170,000 175,000 175,000 180,000 190,000 - - - 52-520-91-00-8050 INTEREST PAYMENT 28,573 24,093 18,738 18,738 13,050 6,840 47 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Debt Service-2011 Refunding Bond 52-520-92-00-8000 PRINCIPAL PAYMENT - - - 660,000 685,000 715,000 745,000 780,000 52-520-92-00-8050 INTEREST PAYMENT 225,354 318,147 318,147 477,220 448,972 419,654 389,052 357,166 Debt Service-2005D Bond 52-520-93-00-8000 PRINCIPAL PAYMENT - - - - - - - - - 52-520-93-00-8050 INTEREST PAYMENT 385,950 332,346 Debt Service-2008 Refunding Bond 52-520-94-00-8000 PRINCIPAL PAYMENT - - 52-520-94-00-8050 INTEREST PAYMENT 110,090 94,800 - - Debt Service-IEPA Loan L17-013000 52-520-95-00-8000 PRINCIPAL PAYMENT 35,357 36,635 37,958 37,958 52-520-95-00-8050 INTEREST PAYMENT 3,623 2,345 1,022 1,022 - - - - - Debt Service-IEPA Loan L17-115300 52-520-96-00-8000 PRINCIPAL PAYMENT 84,107 86,329 88,610 88,610 90,952 93,355 95,821 98,353 100,952 52-520-96-00-8050 INTEREST PAYMENT 22,944 20,721 18,440 18,440 16,099 13,696 11,229 8,697 6,099 52-520-99-00-9951 TRANSFER TO WATER 82,850 83,863 82,288 82,288 82,988 83,588 84,088 84,488 82,288 52-520-99-00-9999 TRANSFER TO 2011 BOND ESCROW - 520,719 - - - - - - Expenses 1,835,456 2,494,670 1,895,210 1,750,812 2,570,120 3,043,689 2,681,712 2,8519779 2,529,201 Surplus(Deficit) (357,382) 625,704 (255,393) (107,560) (214,900) (806,657) (444,498) (615,667) (289,975) Fund Balance Equiv 2,377,831 3,003,537 2,625,761 2,895,977 2,681,077 1,874,420 1,429,922 814,255 524,280 129.55% 120.40% 138.55% 165.41% 104.32% 61.58% 53.32% 28.55% 20.73% 48 Land Cash Fund (72) Land-Cash funds are dedicated by developers through the contribution ordinance to serve the immediate and future needs of park and recreation of residents in new subdivisions.Land for park development and cash spent on recreational facilities is often matched through grant funding to meet the community's recreation needs at a lower cost to the City. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Intergovernmental 42,285 400,000 400,000 400,000 96,000 - - 400,000 - Land Cash Contributions 432,354 30,767 20,500 52,106 20,500 23,000 23,000 23,000 23,000 Other Financing Sources - - - - 50,000 - - - - Total Revenue 474,639 430,767 420,500 452,106 166,500 23,000 23,000 423,000 23,000 Expenditures Contractual Services 60,449 20,084 - - - - - - - Capital Outlay 199,390 316,836 323,825 72,247 89,000 356,850 263,000 13,000 63,000 Total Expenditures 259,839 336,920 323,825 72,247 89,000 356,850 263,000 13,000 63,000 Surplus(Deficit) 214,800 93,847 96,675 379,859 77,500 (333,850) (240,000) 410,000 (40,000) Ending Fund Balance (388,625) (294,778) (172,534) 85,081 162,581 (171,269) (411,269) (1,269) (41,269) Fund Balance N $200 $o N F ($200) ($400) ($600) 49 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Land Cash-72 72-000-41-00-4170 STATE GRANTS 42,285 - 72-000-41-00-4171 OSLAD GRANT-PRAIRIE MEADOWS - 400,000 - - 72-000-41-00-4173 OSLAD GRANT-RAINTREE - 400,000 400,000 - 72-000-41-00-4174 RTP GRANT-CLARK PARK - - 96,000 - 72-000-41-00-4175 OSLAD GRANT-RIVERFRONT GRANT - 400,000 72-000-47-00-4701 WHITE OAK UNIT 3&4 - - 72-000-47-00-4702 WHISPERING MEADOWS(K HILL) 312,655 - - - - - - - 72-000-47-00-4703 AUTUMN CREEK 18,460 30,767 20,000 50,000 20,000 20,000 20,000 20,000 20,000 72-000-47-00-4704 BLACKBERRY WOODS 568 - 500 568 500 500 500 500 500 72-000-47-00-4705 BRISTOL BAY 100,000 - - - - - - - 72-000-47-00-4706 CALEDONIA - 2,500 2,500 2,500 2,500 72-000-47-00-4707 RIVER'S EDGE 671 - - - - - 72-000-47-00-4708 COUNTRY HILLS - 1,538 72-000-49-00-4925 TRANSFER FROM VEHICLE&EQUIPMENT - - 50,000 - - - - Revenue 474,639 430,767 420,500 452,106 166,500 23,000 23,000 423,000 23,000 72-720-54-00-5401 ADMINISTRATIVE CHARGEBACK 60,449 20,084 - - - - - - - 72-720-60-00-6032 MOSIER HOLDING COSTS 10,000 11,000 12,000 12,000 13,000 13,000 13,000 13,000 13,000 72-720-60-00-6036 RAINTREE VILLAGE 88,175 305,836 191,825 40,247 - - - - - 72-720-60-00-6038 WHEATON WOODS NATURE TRAIL 2,133 - - - 72-720-60-00-6039 BRISTOL BAY-PARK A 85,062 72-720-60-00-6043 BRISTOL BAY REGIONAL PARK 14,020 - - - 72-720-60-00-6044 CLARK PARK - 120,000 20,000 76,000 - - 72-720-60-00-6045 RIVERFRONT PARK - - - 200,000 200,000 72-720-60-00-6046 GRANDE RESERVE PARK A - 50,000 72-720-60-00-6047 GRANDE RESERVE PARK B 143,850 - 50 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 72-720-60-00-6049 RAINTREE PARK C - - - - - - - 50,000 Expenditures 259,839 336,920 323,825 72,247 89,000 356,850 263,000 13,000 633000 Surplus(Deficit) 214,800 93,847 96,675 379,859 77,500 (333,850) (240,000) 410,000 (40,000) Fund Balance (388,625) (294,778) (172,534) 85,081 162,581 (171,269) (4113269) (1,269) (41,269) 51 Parks and Recreation Fund (79) This fund accounts for the daily operations of the Parks and Recreation Department. Programs,classes,special events and maintenance of City wide park land and public facilities make up the day to day operations. Programs and classes consist of a wide variety of options serving children through senior citizens. Special events range from Music Under the Stars to Home Town Days. City wide maintenance consists of over two hundred acres at more than fifty sites including buildings,boulevards,parks,utility locations and natural areas. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Charges for Service 220,962 265,699 220,000 248,500 240,000 240,000 240,000 240,000 240,000 Investment Earnings 301 175 200 250 200 200 200 200 200 Reimbursements 7,329 3,336 11,661 12,265 - - - - - Miscellaneous 186,780 193,688 263,700 202,235 223,000 223,000 223,000 223,000 232,700 Other Financing Sources 951,890 736,710 955,886 955,886 1,765,504 1,110,111 1,192,708 1,217,069 1,229,444 Total Revenue 1,367,262 1,199,608 1,451,447 1,419,136 2,228,704 1,573,311 1,655,908 1,680,269 1,702,344 Expenditures Salaries 687,511 651,906 702,800 665,800 771,493 772,993 774,568 776,222 777,958 Benefits 109,114 107,010 296,477 302,766 351,668 373,476 397,463 413,300 430,087 Contractual Services 126,382 147,598 177,530 161,630 227,280 222,530 196,993 201,679 206,598 Supplies 237,847 244,584 329,960 275,962 291,650 293,358 295,186 297,141 299,233 Other Financing Uses - - - - 556,957 - - - - Total Expenditures 1,160,854 1,151,098 1,506,767 1,406,158 2,199,048 1,662,357 1,664,210 1,688,342 1,713,876 Surplus(Deficit) 206,408 48,510 (55,320) 12,978 29,656 (89,046) (8,302) (8,073) (11,532) Ending Fund Balance 231,558 280,065 185,635 293,043 322,699 233,653 225,351 217,278 205,746 19.95% 24.33% 12.32% 20.84% 14.67% 14.06% 13.54% 12.87% 12.00% M $400 Fund Balance N $300 3 L $200 F $100 $0 52 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Parks and Recreation-79 79-000-44-00-4402 SPECIAL EVENTS 6,935 18,095 33,500 30,000 30,000 30,000 30,000 30,000 79-000-44-00-4403 CHILD DEVELOPMENT 41,756 58,810 50,000 50,000 50,000 50,000 50,000 50,000 79-000-44-00-4404 ATHLETICS&FITNESS - 124,164 113,095 130,000 130,000 130,000 130,000 130,000 130,000 79-000-44-00-4439 PROGRAM FEES 189,890 53,905 - - - - - - - 79-000-44-00-4441 CONCESSION REVENUE 31,072 38,939 30,000 35,000 30,000 30,000 30,000 30,000 30,000 79-000-45-00-4500 INVESTMENT EARNINGS 301 175 200 250 200 200 200 200 200 79-000-46-00-4670 REIMB-EMPLOYEE INS CONTRIBUTIONS - - 11,661 12,265 - - - - - 79-000-46-00-4690 REIMB-MISCELLANEOUS 7,329 3,336 - - - - - - - 79-000-48-00-4820 RENTAL INCOME 22,471 54,240 48,000 50,000 55,000 55,000 55,000 55,000 55,000 79-000-48-00-4825 PARK RENTALS - 27,143 25,000 25,000 25,000 25,000 25,000 25,000 25,000 79-000-48-00-4843 HOMETOWN DAYS 137,142 100,960 175,000 119,235 135,000 135,000 135,000 135,000 135,000 79-000-48-00-4846 SPONSORSHIPS&DONATIONS 7,445 4,314 14,700 5,000 5,000 5,000 5,000 5,000 14,700 79-000-48-00-4850 MISCELLANEOUS INCOME 19,722 7,031 1,000 3,000 3,000 3,000 3,000 3,000 3,000 79-000-49-00-4901 TRANSFER FROM GENERAL 951,890 736,710 955,886 955,886 1,765,504 1,110,111 1,192,708 1,217,069 1,229,444 Revenue 1,367,262 1,199,608 1,451,447 1,419,136 2,228,704 1,573,311 1,6559908 1,6809269 1,702,344 Parks Department 79-790-50-00-5010 SALARIES&WAGES 355,091 369,514 410,000 400,000 427,948 4279948 427,948 427,948 427,948 79-790-50-00-5015 PART-TIME SALARIES 15,969 16,833 17,000 17,000 17,000 17,000 17,000 17,000 17,000 79-790-50-00-5020 OVERTIME 439 50 3,000 3,000 3,000 39000 3,000 3,000 3,000 79-790-52-00-5212 RETIREMENT PLAN CONTRIBUTION 32,914 35,461 43,693 43,693 47,761 47,761 47,761 47,761 47,761 79-790-52-00-5214 FICA CONTRIBUTION 27,503 28,869 34,000 34,000 33,487 33,487 33,487 33,487 33,487 79-790-52-00-5216 GROUP HEALTH INSURANCE - - 126,842 126,842 126,575 139,233 153,156 162,345 172,086 79-790-52-00-5222 GROUP LIFE INSURANCE 1,208 1,208 980 990 1,000 1,010 1,020 79-790-52-00-5223 DENTALINSURANCE 9,179 9,179 9,580 10,538 11,592 12,287 13,025 79-790-52-00-5224 VISION INSURANCE - - 1,104 1,104 1,004 1,104 1,215 1,288 1,365 79-790-54-00-5412 TRAINING&CONFERENCES 309 2,604 2,600 2,600 4,000 4,000 4,000 49000 4,000 79-790-54-00-5415 TRAVEL&LODGING - 332 750 750 2,000 2,000 2,000 29000 2,000 79-790-54-00-5440 TELECOMMUNICATIONS 1,802 3,330 3,780 3,780 4,780 49780 4,780 4,780 4,780 79-790-54-00-5462 PROFESSIONAL SERVICES 3,323 4,748 4,500 4,500 4,500 49500 4,500 4,500 4,500 79-790-54-00-5466 LEGAL SERVICES 1,749 3,701 4,000 4,000 4,000 4,000 4,000 4,000 4,000 53 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 79-790-54-00-5485 RENTAL&LEASE PURCHASE 188 2,017 2,500 2,500 2,500 2,500 2,500 2,500 2,500 79-790-54-00-5495 OUTSIDE REPAIR&MAINTENANCE - - 17,500 17,500 22,500 22,500 22,500 22,500 22,500 79-790-56-00-5600 WEARING APPAREL 4,031 4,123 4,100 4,100 4,100 4,100 4,100 4,100 4,100 79-790-56-00-5610 OFFICE SUPPLIES 152 293 300 300 300 300 300 300 300 79-790-56-00-5620 OPERATING SUPPLIES 11,232 23,528 22,500 22,500 22,500 22,500 22,500 22,500 22,500 79-790-56-00-5630 SMALL TOOLS&EQUIPMENT 1,785 2,374 2,250 2,250 2,250 2,250 2,250 2,250 2,250 79-790-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - 500 500 500 500 500 500 500 79-790-56-00-5640 REPAIR&MAINTENANCE 44,231 51,312 50,500 50,500 50,500 50,500 50,500 50,500 50,500 79-790-56-00-5695 GASOLINE - - 20,000 20,000 21,400 22,898 24,501 26,216 28,051 500,718 549,089 781,806 771,806 8133165 828,389 8453090 856,772 8693173 Recreation Department 79-795-50-00-5010 SALARIES&WAGES 248,541 197,710 185,000 200,000 240,745 240,745 240,745 240,745 240,745 79-795-50-00-5015 PART-TIME SALARIES 12,708 17,013 25,000 10,500 15,000 15,000 15,000 15,000 15,000 79-795-50-00-5020 OVERTIME - - 300 300 300 300 300 300 300 79-795-50-00-5045 CONCESSION WAGES 9,021 11,542 12,500 10,000 12,500 12,500 12,500 12,500 12,500 79-795-50-00-5046 PRE-SCHOOL WAGES 23,085 22,476 25,000 15,000 30,000 31,500 33,075 34,729 36,465 79-795-50-00-5052 INSTRUCTORS WAGES 22,657 16,768 25,000 10,000 25,000 25,000 25,000 25,000 25,000 79-795-52-00-5212 RETIREMENT PLAN CONTRIBUTION 24,798 23,137 19,884 24,300 26,714 26,714 26,714 26,714 26,714 79-795-52-00-5214 FICA CONTRIBUTION 23,899 19,543 16,000 18,034 24,216 24,216 24,216 24,216 24,216 79-795-52-00-5216 GROUP HEALTH INSURANCE - - 41,094 41,094 75,911 83,502 91,852 97,363 103,205 79-795-52-00-5222 GROUP LIFE INSURANCE 473 450 591 597 603 609 615 79-795-52-00-5223 DENTAL INSURANCE 2,675 2,566 4,344 4,778 5,256 5,572 5,906 79-795-52-00-5224 VISION INSURANCE - - 325 296 505 556 611 648 687 79-795-54-00-5412 TRAINING&CONFERENCES 680 581 2,000 2,000 3,000 3,000 3,000 3,000 3,000 79-795-54-00-5415 TRAVEL&LODGING - 369 1,000 1,000 1,500 1,500 1,500 1,500 1,500 79-795-54-00-5426 PUBLISHING&ADVERTISING 27,872 27,026 27,000 27,000 27,000 27,000 27,000 27,000 27,000 79-795-54-00-5440 TELECOMMUNICATIONS 5,517 2,847 4,300 3,000 7,000 7,000 7,000 7,000 7,000 79-795-54-00-5447 SCHOLARSHIPS 221 685 2,500 2,500 2,500 2,500 2,500 2,500 2,500 79-795-54-00-5452 POSTAGE&SHIPPING 7,006 3,128 8,000 2,000 4,000 4,000 4,000 4,000 4,000 79-795-54-00-5460 DUES&SUBSCRIPTIONS 482 1,375 1,500 1,500 1,500 1,500 1,500 1,500 1,500 79-795-54-00-5462 PROFESSIONAL SERVICES 49,076 73,265 60,000 60,000 65,000 68,250 71,663 75,246 79,008 79-795-54-00-5480 UTILITIES 21,229 9,538 23,100 15,000 20,000 21,000 22,050 23,153 24,310 79-795-54-00-5485 RENTAL&LEASE PURCHASE 2,459 2,558 4,500 4,500 4,500 4,500 4,500 4,500 4,500 54 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 79-795-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 1,387 106 1,000 500 40,000 1,000 1,000 1,000 1,000 79-795-54-00-5496 PROGRAM REFUNDS 3,082 9,388 7,000 7,000 7,000 7,000 7,000 7,000 7,000 79-795-54-00-5497 PROPERTY TAX PAYMENT - - - - - 30,000 - - - 79-795-56-00-5602 HOMETOWN DAYS SUPPLIES 99,903 84,982 140,000 91,712 100,000 100,000 100,000 100,000 100,000 79-795-56-00-5606 PROGRAM SUPPLIES 47,154 47,065 55,000 55,000 55,000 55,000 55,000 55,000 55,000 79-795-56-00-5607 CONCESSION SUPPLIES 17,834 19,144 18,000 15,000 18,000 18,000 18,000 18,000 18,000 79-795-56-00-5610 OFFICE SUPPLIES 2,466 1,792 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-795-56-00-5620 OPERATING SUPPLIES 4,138 6,533 5,500 7,500 7,500 7,500 7,500 7,500 7,500 79-795-56-00-5630 SMALL TOOLS&EQUIPMENT 283 - 2,000 500 1,000 1,000 1,000 1,000 1,000 79-795-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 2,600 1,522 500 500 500 500 500 500 500 79-795-56-00-5640 REPAIR&MAINTENANCE 412 920 2,000 1,000 2,000 2,000 2,000 2,000 2,000 79-795-56-00-5645 BOOKS&PUBLICATIONS - - 100 100 100 100 100 100 100 79-795-56-00-5690 SUPPLIES-GRANT REIMBURSABLE - - 500 - - - - - - 79-795-56-00-5695 GASOLINE 1,626 996 3,210 1,500 3,000 3,210 3,435 3,675 3,932 79-795-99-00-9980 TRANSFER TO RECREATION CENTER - - - - 556,957 - - - - 660,136 602,009 724,961 634,352 1,3853883 833,968 8193120 831,570 8443703 Expenditures 1,160,854 1,151,098 1,506,767 1,406,158 2,1993048 13662,357 1,6643210 13688,342 1,7133876 Surplus(Deficit) 206,408 485510 (55,320) 12,978 293656 (89,046) (83302) (8,073) (11,532) Fund Balance 231,558 280,065 185,635 293,043 3223699 233,653 2253351 217,278 205,746 19.95% 24.33% 13.32% 20.84% 14.67% 14.06% 13.54% 12.87% 12.00% 55 Recreation Center Fund (80) The REC Center is a 38,000 square foot,full-service fitness and recreation facility leased by the City and operated by the Parks and Recreation Department. This fund will be closed out in fiscal year 2014. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Charges for Service 608,154 620,489 607,000 498,750 61,000 - - - - Miscellaneous 11,864 14,074 15,500 14,456 - - - - - Other Financing Sources - - - - 556,957 - - - - Total Revenue 620,018 634,563 622,500 513,206 617,957 - - - - Expenses Salaries 224,988 201,757 223,000 174,250 20,000 - - - - Benefits 28,603 25,706 29,212 29,179 - - - - - Contractual Services 384,248 392,972 408,250 476,050 114,250 - - - - Supplies 49,451 39,041 43,171 81,194 16,239 - - - - Total Expenses 687,290 659,476 703,633 760,673 150,489 - - - - Surplus(Deficit) (67,272) (24,913) (81,133) (247,467) 467,468 - - - - Ending Fund Balance Equivalent (195,087) (220,001) (367,521) (467,468) - - - - - -28.38% -33.36% -52.23% -61.45% - - - - - Fund Balance Equivalent $0 ($100) s ($200) ~ ($300) ($400) ($500) 56 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Recreation Center 80-000-44-00-4439 PROGRAM FEES 130,565 97,070 100,000 60,000 - 80-000-44-00-4441 CONCESSION REVENUE 14,692 10,661 12,500 6,500 500 80-000-44-00-4444 MEMBERSHIP FEES 418,685 465,488 450,000 400,000 60,000 80-000-44-00-4445 GUEST FEES 7,072 8,939 7,000 6,500 500 80-000-44-00-4446 SWIM CLASS FEES 27,013 30,932 25,000 20,000 - 80-000-44-00-4447 PERSONAL TRAINING FEES 8,055 4,910 10,000 5,000 80-000-44-00-4448 TANNING SESSION FEES 2,072 2,489 2,500 750 80-000-48-00-4820 RENTAL INCOME 7,103 13,017 13,000 13,000 80-000-48-00-4846 SCHOLARSHIPS&DONATIONS 3,170 760 2,000 1,356 80-000-48-00-4850 MISCELLANEOUS INCOME 1,591 297 500 100 - 80-000-49-00-4979 TRANSFER FROM PARKS&REC - - - - 556,957 Revenue 620,018 634,563 622,500 513,206 6173957 - 80-800-50-00-5010 SALARIES&WAGES 33,542 29,087 28,000 26,250 - 80-800-50-00-5015 PART-TIME SALARIES 96,666 88,234 100,000 78,000 20,000 80-800-50-00-5046 PRE-SCHOOL WAGES 38,362 30,255 35,000 15,000 - 80-800-50-00-5052 INSTRUCTORS WAGES 56,418 54,181 60,000 55,000 80-800-52-00-5212 RETIREMENT PLAN CONTRIBUTION 11,529 10,213 10,181 10,181 80-800-52-00-5214 FICA CONTRIBUTION 17,074 15,493 17,708 17,708 80-800-52-00-5216 GROUP HEALTH INSURANCE - - 1,200 1,200 80-800-52-00-5222 GROUP LIFE INSURANCE 123 90 80-800-52-00-5223 DENTAL INSURANCE - - 80-800-52-00-5224 VISION INSURANCE 80-800-54-00-5412 TRAINING&CONFERENCES - 80-800-54-00-5415 TRAVEL&LODGING - - 200 80-800-54-00-5426 PUBLISHING&ADVERTISING 732 192 1,500 - - 80-800-54-00-5440 TELECOMMUNICATIONS 4,379 3,198 3,600 3,600 720 80-800-54-00-5447 SCHOLARSHIPS 389 - - - - 80-800-54-00-5452 POSTAGE&SHIPPING - - 600 300 60 80-800-54-00-5460 DUES&SUBSCRIPTIONS - 114 200 200 40 80-800-54-00-5462 PROFESSIONAL SERVICES 32,851 15,810 20,000 15,000 3,000 80-800-54-00-5480 UTILITIES 55,117 46,030 55,650 55,650 11,130 57 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 80-800-54-00-5485 RENTAL&LEASE PURCHASE 215,000 223,647 236,000 330,000 38,000 80-800-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 13,627 37,751 15,000 7,000 1,400 80-800-54-00-5496 PROGRAM REFUNDS 8,473 4,727 5,500 5,500 1,100 80-800-54-00-5497 PROPERTY TAX PAYMENT 53,680 61,503 70,000 58,800 58,800 80-800-56-00-5606 PROGRAM SUPPLIES 11,676 12,125 15,000 7,500 1,500 80-800-56-00-5607 CONCESSION SUPPLIES 10,029 6,302 7,000 7,000 1,400 80-800-56-00-5610 OFFICE SUPPLIES 1,730 892 2,600 1,500 300 80-800-56-00-5620 OPERATING SUPPLIES 4,543 7,039 6,200 3,000 600 80-800-56-00-5630 SMALL TOOLS&EQUIPMENT 8,525 - - - - 80-800-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 3,180 1,000 1,000 1,000 200 80-800-56-00-5640 REPAIR&MAINTENANCE 9,768 11,371 11,000 61,000 12,200 80-800-56-00-5645 BOOKS&PUBLICATIONS - 30 50 194 39 80-800-56-00-5695 GASOLINE - 282 321 - - Expenses 687,290 659,476 703,633 760,673 150,489 - - Surplus(Deficit) (67,272) (24,913) (81,133) (247,467) 467,468 - - Fund Balance Equiv (195,087) (220,001) (367,521) (467,468) - - - - - -28.38% -33.36% -52.23% -61.45% 0.00% 0.00% 0.00% 0.00% 0.00 58 Library Operations Fund(82) The Yorkville Public Library provides the people of the community,from pre-school through maturity,with access to a collection of books and other materials which will serve their educational,cultural and recreational needs. The Library board and staff strive to provide the community an environment that promotes the love of reading. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 1,252,191 692,476 707,500 691,905 670,415 700,000 700,000 700,000 725,000 Intergovernmental 24,410 22,212 22,200 23,852 22,200 22,200 22,200 22,200 22,200 Licenses&Permits 17,650 4,681 - - - - - - - Fines&Forfeits 14,161 12,864 13,000 9,300 9,300 9,300 9,300 9,300 9,300 Charges for Service 17,117 15,368 17,000 13,450 14,000 14,000 14,000 14,000 14,000 Investment Earnings 690 393 150 1,260 1,300 1,300 1,500 1,500 1,500 Reimbursements - - 7,306 9,396 - - - - - Miscellaneous 7,823 15,045 8,500 8,940 9,250 9,250 9,250 9,250 9,250 Other Financing Sources - 332,500 41,978 30,000 52,174 32,375 34,168 36,068 38,082 Total Revenue 1,334,042 1,095,539 817,634 788,103 778,639 788,425 790,418 792,318 819,332 Expenditures Salaries 501,353 432,008 440,000 440,000 447,540 447,540 447,540 447,540 447,540 Benefits 143,220 149,612 218,553 200,412 193,524 205,290 218,163 227,380 237,148 Contractual Services 149,678 88,124 111,599 108,149 109,049 109,679 110,341 111,035 111,764 Supplies 180,831 21,623 21,750 22,750 21,250 21,250 21,250 21,250 21,250 Contingencies 6,705 158 1,000 - - - - - - Debt Service 605,925 - - - - Other Financing Uses - 332,519 1,511 5,469 - - - - - Total Expenditures 1,587,712 1,024,044 794,413 776,780 771,363 783,759 797,294 807,205 817,702 Surplus(Deficit) (253,670) 71,495 23,221 11,323 7,276 4,666 (6,876) (14,887) 1,630 Ending Fund Balance 317,336 388,831 370,330 400,154 407,430 412,096 405,220 390,333 391,963 19.99% 37.97% 46.62% 51.51% 52.82% 52.58% 50.82% 48.36% 47.93% Fund Balance N $500 $400 • •�• ,• • N r $300 ~ $200 $100 $0 59 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Library Operations 82-000-40-00-4005 PROPERTY TAXES-LIBRARY 648,060 673,145 700,000 691,905 670,415 700,000 700,000 700,000 725,000 82-000-40-00-4012 PROPERTY TAXES-FOX INDUSTRIAL TIF - 19,331 7,500 - - - - - - 82-000-40-00-4015 PROPERTY TAXES-DEBT SERVICE 604,131 - - - - - - - - 82-000-41-00-4120 PERSONAL PROPERTY TAX 7,217 4,981 5,000 5,000 5,000 5,000 5,000 5,000 5,000 82-000-41-00-4170 STATE GRANTS 17,193 17,231 17,200 18,852 17,200 17,200 17,200 17,200 17,200 82-000-42-00-4211 DEVELOPMENT FEES-BOOKS 8,825 4,681 - - - - - - - 82-000-42-00-4212 DEVELOPMENT FEES-BUILDING 8,825 - - - - - - - - 82-000-43-00-4330 LIBRARY FINES 14,161 12,864 13,000 9,300 9,300 9,300 9,300 9,300 9,300 82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 13,742 11,814 12,000 10,000 10,000 10,000 10,000 10,000 10,000 82-000-44-00-4422 COPY FEES 3,339 3,444 3,000 2,500 3,000 3,000 3,000 3,000 3,000 82-000-44-00-4440 PROGRAM FEES 36 110 2,000 950 1,000 1,000 1,000 1,000 1,000 82-000-45-00-4500 INVESTMENT EARNINGS 690 393 150 1,260 1,300 1,300 1,500 1,500 1,500 82-000-46-00-4670 REIMB-EMPLOYEE INS CONTRIBUTIONS - - 6,670 8,685 - - - - - 82-000-46-00-4671 REIMB-LIFE INSURANCE - - 636 711 - - - - - 82-000-48-00-4820 RENTAL INCOME 1,454 2,695 2,000 1,540 2,000 2,000 2,000 2,000 2,000 82-000-48-00-4824 DVD RENTAL INCOME 4,131 5,416 4,500 5,000 5,000 5,000 5,000 5,000 5,000 82-000-48-00-4832 MEMORIALS 1,883 6,119 2,000 2,000 2,000 2,000 2,000 2,000 2,000 82-000-48-00-4850 MISCELLANEOUS INCOME 55 815 - 400 250 250 250 250 250 82-000-48-00-4881 SALE OF BOOKS 300 - - - - - - - 82-000-49-00-4901 TRANSFER FROM GENERAL - - - - 21,490 - - - - 82-000-49-00-4901 TRANSFER FROM GENERAL - 332,500 41,978 30,000 30,684 32,375 34,168 36,068 38,082 Revenue 1,334,042 1,095,539 817,634 788,103 778,639 788,425 790,418 792,318 819,332 82-820-50-00-5010 SALARIES&WAGES 501,353 244,695 245,000 245,000 252,540 2529540 252,540 252,540 252,540 82-820-50-00-5015 PART-TIME SALARIES - 187,313 195,000 195,000 195,000 195,000 195,000 195,000 195,000 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 21,607 23,387 26,692 26,692 27,988 27,988 27,988 27,988 27,988 82-820-52-00-5214 FICA CONTRIBUTION 37,766 32,384 38,000 33,000 33,572 33,572 33,572 33,572 33,572 82-820-52-00-5216 GROUP HEALTH INSURANCE 76,487 86,334 102,877 102,877 94,116 103,528 113,880 120,713 127,956 82-820-52-00-5222 GROUP LIFE INSURANCE 1,200 760 1,410 1,100 595 601 607 613 619 82-820-52-00-5223 DENTALINSURANCE 5,451 6,061 6,826 6,100 5,926 6,519 7,170 7,601 8,057 82-820-52-00-5224 VISION INSURANCE 709 686 770 643 643 707 778 825 874 82-820-52-00-5230 UNEMPLOYMENT INSURANCE - - 4,286 2,500 2,500 2,500 2,500 2,500 2,500 60 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 82-820-52-00-5231 LIABILITY INSURANCE - 37,692 27,500 28,184 29,875 31,668 33,568 35,582 82-820-54-00-5412 TRAINING&CONFERENCES 949 - - 500 500 500 500 500 500 82-820-54-00-5415 TRAVEL&LODGING 593 215 500 1,000 600 600 600 600 600 82-820-54-00-5423 PUBLIC RELATIONS 112 - - - - - - - - 82-820-54-00-5426 PUBLISHING&ADVERTISING 130 - 100 100 100 100 100 100 100 82-820-54-00-5440 TELECOMMUNICATIONS 9,055 8,609 8,500 10,500 11,000 11,000 11,000 11,000 11,000 82-820-54-00-5452 POSTAGE&SHIPPING 2,104 538 1,000 300 500 500 500 500 500 82-820-54-00-5460 DUES&SUBSCRIPTIONS 11,290 7,495 14,000 12,000 12,000 12,000 12,000 12,000 12,000 82-820-54-00-5462 PROFESSIONAL SERVICES 31,824 29,909 29,000 29,000 29,000 29,000 29,000 29,000 29,000 82-820-54-00-5466 LEGAL SERVICES 4,175 - 2,000 2,000 2,000 2,000 2,000 2,000 2,000 82-820-54-00-5468 AUTOMATION 48,567 28,210 35,000 35,000 35,000 35,000 35,000 35,000 35,000 82-820-54-00-5480 UTILITIES 11,484 8,872 15,750 12,000 12,600 13,230 13,892 14,586 15,315 82-820-54-00-5485 RENTAL&LEASE PURCHASE 1,007 - - - - - - - - 82-820-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 28,388 4,276 5,000 5,000 5,000 5,000 5,000 5,000 5,000 82-820-54-00-5498 PAYING AGENT FEES - - 749 749 749 749 749 749 749 82-820-56-00-5610 OFFICE SUPPLIES 8,784 5,005 8,000 8,000 8,000 8,000 8,000 8,000 8,000 82-820-56-00-5620 OPERATING SUPPLIES 6,995 4,694 7,500 8,000 8,000 8,000 8,000 8,000 8,000 82-820-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 7,637 - - 1,550 - - - - - 82-820-56-00-5640 REPAIR&MAINTENANCE 2,180 - - - - - - - - 82-820-56-00-5671 LIBRARY PROGRAMMING 8,172 225 2,000 950 1,000 1,000 1,000 1,000 1,000 82-820-56-00-5676 EMPLOYEE RECOGNITION 93 - - - - - - - - 82-820-56-00-5680 ADULT BOOKS 30,312 82-820-56-00-5681 JUVENILE BOOKS 40,713 82-820-56-00-5682 REFERENCE BOOKS 11,394 - 82-820-56-00-5683 AUDIO BOOKS 9,526 - 82-820-56-00-5684 COMPACT DISCS&OTHER MUSIC 2,122 - - - - - - - - 82-820-56-00-5685 DVD'S 7,715 1,260 2,000 2,000 2,000 2,000 2,000 2,000 2,000 82-820-56-00-5686 DEVELOPMENT FEES 42,766 4,681 - - - - - - - 82-820-56-00-5698 MEMORIALS&GIFTS 1,622 5,627 2,000 2,000 2,000 2,000 2,000 2,000 2,000 82-820-56-00-5699 MISCELLANEOUS 800 131 250 250 250 250 250 250 250 82-820-70-00-7799 CONTINGENCIES 6,705 158 1,000 - - - - - - Debt Service-2005B Bond 82-820-83-00-8000 PRINCIPAL PAYMENT 75,000 - - - 82-820-83-00-8050 INTEREST PAYMENT 319,125 - 61 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Debt Service-2006 Bond 82-820-84-00-8000 PRINCIPAL PAYMENT 150,000 82-820-84-00-8050 INTEREST PAYMENT 61,800 - - 82-820-99-00-9983 TRANSFER TO LIBRARY DEBT SERVICE - - 1,511 5,469 82-820-99-00-9984 TRANSFER TO LIBRARY CAPITAL - 332,519 - - - - Expenditures 1,587,712 1,024,044 794,413 776,780 771,363 783,759 797,294 807,205 817,702 Surplus(Deficit) (253,670) 71,495 23,221 11,323 7,276 4,666 (6,876) (14,887) 1,630 Fund Balance 317,336 388,831 370,330 400,154 407,430 412,096 405,220 390,333 391,963 19.99% 37.97% 46.62% 51.51% 53.82°%0 52.58% 50.82% 48.36% 47.93% 62 Library Debt Service Fund (83) The Library Debt Service Fund accumulates monies for payment of the 2005B and 2006 bonds,which were issued to finance construction of the Library building. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes - 718,839 795,488 791,640 771,763 730,288 743,513 751,238 753,563 Investment Earnings - 140 300 200 200 200 200 200 200 Other Financing Sources - - 1,511 5,469 - - - - - Total Revenue - 718,979 797,299 797,309 771,963 730,488 743,713 751,438 753,763 Expenditures Debt Service - 720,800 795,488 795,488 769,638 730,288 743,513 751,238 753,563 Total Expenditures - 720,800 795,488 795,488 769,638 730,288 743,513 751,238 753,563 Surplus(Deficit) - (1,821) 1,811 1,821 2,325 200 200 200 200 Ending Fund Balance - (1,821) - - 2,325 2,525 2,725 2,925 3,125 $4 Fund Balance $2 3 s $0 H ($2) ($4) 63 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Library Debt Service 83-000-40-00-4015 PROPERTY TAXES-DEBT SERVICE 718,839 795,488 791,640 771,763 730,288 743,513 751,238 753,563 83-000-45-00-4500 INVESTMENT EARNINGS 140 300 200 200 200 200 200 200 83-000-49-00-4982 TRANSFER FROM LIBRARY OPS - 1,511 5,469 - - - - - Revenue 718,979 797,299 797,309 771,963 730,488 743,713 751,438 7539763 Debt Service-2005B Bond 83-830-83-00-8000 PRINCIPAL PAYMENT 175,000 290,000 290,000 335,000 - - - - 83-830-83-00-8050 INTEREST PAYMENT 316,125 309,125 309,125 13,400 - - - - Debt Service-2006 Bond 83-830-84-00-8000 PRINCIPAL PAYMENT 175,000 150,000 150,000 100,000 50,000 50,000 50,000 50,000 83-830-84-00-8050 INTEREST PAYMENT 54,675 46,363 46,363 39,238 34,488 32,113 29,738 27,363 Debt Service-2013 Refunding Bond 83-830-99-00-8000 PRINCIPAL PAYMENT - - - 170,000 470,000 495,000 515,000 530,000 83-830-99-00-8050 INTEREST PAYMENT - - - 112,000 175,800 166,400 156,500 146,200 Expenditures 720,800 7959488 795,488 7699638 730,288 7439513 751,238 7539563 Surplus(Deficit) (1,821) 1,811 1,821 2,325 200 200 200 200 Fund Balance (1,821) - 29325 2,525 2,725 2,925 39125 64 Library Capital Fund (84) The Library Capital Fund derives its revenue from monies collected from building permits. The revenue is used for Library building maintenance and associated capital,contractual and supply purchases. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Licenses&Permits - 17,669 16,250 30,000 20,000 20,000 20,000 20,000 20,000 Investment Earnings - 71 100 10 20 20 20 20 20 Other Financing Sources - 332,519 - - - - - - - Total Revenue - 350,259 16,350 30,010 20,020 20,020 20,020 20,020 20,020 Expenditures Contractual Services - - - 3,500 3,500 3,500 3,500 3,500 3,500 Supplies - - 13,474 14,474 35,350 16,520 16,520 16,520 16,520 Capital Outlay - 10,965 - - - - - - - Other Financing Uses - 332,500 - - - - - - - Total Expenditures - 343,465 13,474 17,974 38,850 20,020 20,020 20,020 20,020 Surplus(Deficit) - 6,794 2,876 12,036 (18,830) - - - - Ending Fund Balance - 6,794 - 18,830 - - - - - Fund Balance $20 r N $15 3 t $10 H $5 $0 65 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Library Capital 84-000-42-00-4214 DEVELOPMENT FEES 17,669 16,250 30,000 20,000 20,000 20,000 20,000 20,000 84-000-45-00-4500 INVESTMENT EARNINGS 71 100 10 20 20 20 20 20 84-000-49-00-4982 TRANSFER FROM LIBRARY OPS 332,519 - - - - - - Revenue 350,259 16,350 30,010 20,020 20,020 20,020 20,020 20,020 84-840-54-00-5460 DUES&SUBSCRIPTIONS - - 3,500 3,500 3,500 3,500 3,500 3,500 84-840-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - - - - 84-840-56-00-5683 AUDIO BOOKS 84-840-56-00-5684 COMPACT DISCS&OTHER MUSIC - 84-840-56-00-5685 DVD'S - 1,000 - - - - - 84-840-56-00-5686 BOOKS - 13,474 13,474 35,350 16,520 16,520 16,520 16,520 84-840-60-00-6020 BUILDINGS&STRUCTURES 10,965 - - - - - - - 84-840-99-00-9901 TRANSFER TO GENERAL 332,500 - - - - - Expenditures 343,465 13,474 17,974 38,850 20,020 20,020 20,020 20,020 Surplus(Deficit) 6,794 k876, 12,036 (18,830) - - - - Fund Balance 6,794 18,830 - 66 Fox Industrial TIF Fund (85) The Fox Industrial TIF was created in 2001,in order to finance public infrastructure improvements for the Fox Industrial area. This TIF was closed out in fiscal year 2012. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 228,346 259,052 - - - - - - - Investment Earnings 13 275 - - - - - - - Total Revenue 228,359 259,327 - - - - - - - Expenditures Contractual Services 1,989 662,322 - - - - - - - Supplies - 11,236 - - - - - - - Debt Service 79,933 76,782 - - - - - - - Other Financing Uses - 78,777 - - - - - - - Total Expenditures 81,922 829,117 - - - - - - - Surplus(Deficit) 146,437 (569,790) - - - - - - - Ending Fund Balance 569,790 - - - - - - - - $600 Fund Balance $400 0 $200 $0 67 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Fox Industrial TIF 85-000-40-00-4085 PROPERTY TAXES-FOX INDUSTRIAL TIE 228,346 259,052 - 85-000-45-00-4500 INVESTMENT EARNINGS 13 275 Revenue 228,359 259,327 - - 85-850-54-00-5400 TIF LIQUIDATION - 658,757 - 85-850-54-00-5420 ADMINISTRATIVE FEES 1,989 3,565 - 85-850-56-00-5619 SIGNS - 11,236 - Debt Service-2002 Bond 85-850-98-00-8000 PRINCIPAL PAYMENT 70,000 70,000 - 85-850-98-00-8050 INTEREST PAYMENT 9,933 6,782 - 85-850-99-00-9901 TRANSFER TO GENERAL - - - 85-850-99-00-9942 TRANSFER TO DEBT SERVICE - 78,777 Expenditures 81,922 829,117 - - - - Surplus(Deficit) 146,437 (569,790) - - - - Fund Balance 569,790 - - - - 68 Countryside TIF Fund (87) The Countryside TIF was created in February of 2005,with the intent of constructing a future retail development at Countryside Center. This TIF is located at the northwest corner of US Route 34 and IL Route 47. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 6,372 4,188 4,500 - - - 100,000 100,000 100,000 Investment Earnings 3,134 2,718 2,000 3,100 1,550 - - - - Total Revenue 9,506 6,906 6,500 3,100 1,550 - 100,000 100,000 100,000 Expenditures Contractual Services 1,623 1,442 1,375 2,375 1,802,375 2,375 2,375 2,375 2,375 Debt Service 307,093 306,143 304,668 304,668 302,738 305,523 302,723 304,723 306,323 Total Expenditures 308,716 307,585 306,043 307,043 2,105,113 307,898 305,098 307,098 308,698 Surplus(Deficit) (299,210) (300,679) (299,543) (303,943) (2,103,563) (307,898) (205,098) (207,098) (208,698) Ending Fund Balance 2,178,550 1,877,872 1,578,277 1,573,929 (529,634) (837,532) (1,042,630) (1,249,728) (1,458,426) $3,000 l Fund Balance $2,000 1 a $1,000 s $0 ($1,000) ($2,000) 69 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Countryside TIF 87-000-40-00-4087 PROPERTY TAXES-COUNTRYSIDE TIE 6,372 4,188 4,500 - - 100,000 100,000 100,000 87-000-45-00-4500 INVESTMENT EARNINGS 3,134 2,718 2,000 3,100 1,550 - - - Revenue 9,506 6,906 6,500 3,100 1,550 - 100,000 100,000 100,000 87-870-54-00-5420 ADMINISTRATIVE FEES 1,248 1,067 1,000 2,000 2,000 2,000 2,000 2,000 2,000 87-870-54-00-5425 TIF INCENTIVE PAYOUT - - - - 1,800,000 - - - - 87-870-54-00-5498 PAYING AGENT FEES 375 375 375 375 375 375 375 375 375 Debt Service-2005 Bond 87-870-80-00-8000 PRINCIPAL PAYMENT 170,000 175,000 180,000 180,000 185,000 195,000 200,000 210,000 220,000 87-870-80-00-8050 INTEREST PAYMENT 137,093 131,143 124,668 124,668 117,738 110,523 102,723 94,723 86,323 Debt Service-2013 Refunding Bond 87-870-93-00-8000 PRINCIPAL PAYMENT - - - - - - - - - 87-870-93-00-8050 INTEREST PAYMENT - - - - - - - - - Expenditures 308,716 307,585 306,043 307,043 2,1053113 307,898 305,098 307,098 308,698 Surplus(Deficit) (299,210) (300,679) (299,543) (303,943) (2,103,563) (3079898) (205,098) (207,098) (208,698) Fund Balance 2,178,550 1,877,872 1,578,277 13573,929 (5293634) (837,532) (1,0423630) (1,249,728) (1,458,426) 70 Downtown TIF Fund (88) The Downtown TIF was created in 2006,in order to finance a mixed use development in the downtown area. FY 2013 FY 2011 FY 2012 Adopted FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 75,362 67,807 70,000 39,980 35,000 35,000 35,000 35,000 35,000 Investment Earnings - 126 150 350 350 350 350 350 350 Total Revenue 75,362 67,933 70,150 40,330 35,350 35,350 35,350 35,350 35,350 Expenditures Contractual Services 1,896 12,152 11,500 15,167 15,350 15,355 15,360 15,365 15,375 Capital Outlay - 7,589 30,000 21,667 30,000 30,000 30,000 30,000 30,000 Total Expenditures 1,896 19,741 41,500 36,834 45,350 45,355 45,360 45,365 45,375 Surplus(Deficit) 73,466 48,192 28,650 3,496 (10,000) (10,005) (10,010) (10,015) (10,025) Ending Fund Balance 209,760 257,953 264,867 261,449 251,449 241,444 231,434 221,419 211,394 $300 Fund Balance c 3 $200 0 s ~ $100 $0 71 FY 2011 FY 2012 FY 2013 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Downtown TIF 88-000-40-00-4088 PROPERTY TAXES-DOWNTOWN TIF 75,362 67,807 70,000 39,980 35,000 35,000 35,000 35,000 35,000 88-000-45-00-4500 INVESTMENT EARNINGS - 126 150 350 350 350 350 350 350 Revenue 75,362 67,933 70,150 40,330 35,350 35,350 35,350 35,350 35,350 88-880-54-00-5420 ADMINISTRATIVE FEES 1,896 366 1,500 167 350 355 360 365 375 88-880-54-00-5466 LEGAL SERVICES - 11,786 10,000 15,000 15,000 15,000 15,000 15,000 15,000 88-880-54-00-5425 TIF INCENTIVE PAYOUT - - - - - - - - 88-880-60-00-6000 PROJECT COSTS 7,589 10,000 10,000 10,000 10,000 10,000 10,000 10,000 88-880-60-00-6079 ROUTE 47 EXPANSION - - 20,000 11,667 20,000 20,000 20,000 20,000 20,000 Expenditures 1,896 19,741 41,500 36,834 45,350 45,355 45,360 459365 45,375 Surplus(Deficit) 73,466 48,192 28,650 3,496 (10,000) (10,005) (10,010) (10,015) (10,025) Fund Balance 209,760 257,953 264,867 261,449 251,449 241,444 2313434 221,419 211,394 72