Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Ordinance 2012-08
STATE OF ILLINOIS COUNTY OF KENDALL - FILED - APR 2 6 2012 • COUNTY CLERK 1� KENDA!J.COUNTY UNITED CITY OF YORKVILLE KENDALL COUNTY, ILLINOIS ORDINANCE NO. 2012-08 ORDINANCE APPROVING THE 2012-2013 FISCAL BUDGET FOR THE UNITED CITY OF YORKVILLE Passed by the City Council of the United City of Yorkville,Kendall County, Illinois This 10`x'day of April, 2012 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, 2012. STATE OF ILLINOIS ) ) ss COUNTY OF KENDALL ) ORDINANCE NO. 2012- 09 ORDINANCE APPROVING THE 2012-2013 FISCAL BUDGET FOR THE UNITED CITY OF YORKVILLE 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 2012-2013 Fiscal Year; and 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 2012-2013 Fiscal Year Budget being submitted on April 10, 2012 at its regular City Council Meeting: NOW, THEREFORE, BE IT ORDAINED, by the Mayor and City Council of the United City of Yorkville, Kendall County, Illinois that the 2012-2013 Budget totaling $23,262,714 including the amounts of$11,379,867 General Fund, $573,860 Motor Fuel Tax Fund, $0 Municipal Building Fund, $60,000 Police Capital Fund, $169,795 Public Works Capital Fund, $52,500 Parks & Recreation Capital Fund, $1,895,210 Sewer Fund, $3,085,983 Water Fund, $1,040,500 City-Wide Capital Fund, $505,370 Debt Service Fund, $323,825 Land Cash Fund, $1,506,767 Parks & Recreation Fund, $703,633 Recreation Center Fund, $ 794,413 Library Operations Fund, $795,488 Library Debt Service Fund, $13,474 Library Capital Fund, $0 Fox Industrial TIF Fund, $306,043 Ordinance No. 2012-00 Page 2 Countryside TIF Fund, $41,500 Downtown TIF Fund, $9,986 Sunflower SSA Fund, and $4,500 Fox Hill SSA Fund is hereby adopted for the 2012-2013 Fiscal Year, as presented. Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this I0`" day of April, A.D. 2012. CITY CLERK CHRIS FUNKHOUSER V GEORGE GILSON, JR. yl JACKIE MILSCHEWSKI y CARLO COLOSIMO y LARRY KOT MARTY MUNNS y— ROSE SPEARS n DIANE TEELING V— Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this 10`x' day of April, A.D. 2012. MAYOR Ordinance No. 2012- 08 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. $2,000 , Fund Balance $1„000 0 $o - --- -� ($1,000) i i FY2012 FY2013 FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Taxes 6,794,540 7,230,149 7,514,504 7,827,943 8,788,433 8,977,959 9,124,278 9,261,483 9,400,602 Intergovernmental 1,652,385 1,791,792 1,738,496 1,749,303 1,759,600 1,775,224 1,796,004 1,811,942 1,833,039 Licenses&Permits 259,850 241,752 165,650 166,800 169,300 169,300 169,300 169,300 169,300 Fines&Forfeits 199,140 201,236 215,000 174,750 201,000 201,000 201,000 201,000 201,000 Charges for Service 1,252,904 1,302,474 1,303,932 1,330,200 1,178,784 1,180,299 1,181,829 1,183,375 1,184,936 Investment Earnings 62,043 1,747 2,000 5,000 3,100 3,100 3,100 3,100 3,100 Reimbursements 424,704 484,593 340,800 397,251 199,892 205,224 216,459 228,679 246,974 Miscellaneous 17,204 28,861 16,000 10,550 11,000 11,000 13,000 13,000 13,000 Other Financing Sources 344,658 235,357 527,492 527,492 - - - - Total Revenue 11,007,428 11,517,961 11,823,874 12,189,289 12,311,109 12,523,106 12,704,970 12,871,879 13,051,951 Expenditures Salaries 4,051,113 3,517,151 3,278,395 3,239,473 3,371,895 3,313,895 3,363,895 3,413,895 3,463,895 Benefits 2,322,050 2,446,452 2,507,632 2,465,119 2,327,040 2,534,719 2,699,571 2,927,557 3,119,928 Contractual Services 4,437,998 3,470,156 3,615,103 3,909,127 3,840,120 3,787,295 4,005,510 4,095,300 4,132,251 Supplies 239.294 271,393 300,295 288,793 274,151 282,866 298,145 308,028 320,559 Capital Outlay 7,364 - - - - - - - - Contingencies 16,153 75,000 64,617 52,075 50,000 50,000 50,000 50,000 50,000 Other Financing Uses 1,644,594 1,516,778 1,293,950 1,297,950 1,516,661 2,517,952 2,596,554 3,072,607 2,992,619 Total Expenditures 12,718,566 11,296,930 11,059,992 11,252,537 11,379,867 12,486,727 13,013,675 13,867,387 14,079,252 Surplus(Deficit) (1,711,138) 221,031 763,882 936,752 931,242 36,379 (308,705) (995,508) (1,027,301) Ending Fund Balance (492,939) (271,900) 258,636 664,852 1,596,094 1,632,473 1,323,768 328,260 (699,041) -3.88% -2.41% 2.34% 5.91% 14.03% 13.07% 10.17% 2.37% -4.97% $2,000 , Fund Balance $1„000 0 $o - --- -� ($1,000) i i 2 FY 2010 FY 2011 FY 2012 FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 F)'2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected GENERAL FUND-01 01-000-40-00-4000 PROPERTY TAXES-CORPORATE LEVY 2,084,192 2,185,495 2,290,964 2,282,246 2,288,133 2,311,014 2,334,124 2,357,466 2.381.040 01-000-40-00-4010 PROPERTY TAXES-POLICE PENSION 323,291 336.075 375,000 360,356 413 354 500,000 525.000 550.000 575.000 TBI)annually by acivarial evaluation 01-000-40-00-4012 PROPERTY TAXES-FOX INDUSTRIAL TIE - - - 67,334 20,000 - - - - 01-000-40-00-4030 MUNICIPAL SALES TAX 2,446,099 2,569,233 2,550,000 2,430,000 2,325.000 2371,500 1418,930 2,467,309 2,516,655 As imuled decline clue iu closing q/Po-Budd 01-000-40-00-4035 NON-HOME RULE SALES TAX - - - 375,000 1,500,000 1,530 000 1,560,600 1.591,812 1,623,648 01-000-40-00-4040 ELECTRIC UTILITY TAX 548374 605,833 591,600 600,000 603,432 615,501 621,656 627,873 634,151 01-000-40-00-4041 NATURAL GAS UTILITY TAX 284,895 268,166 290,700 290,700 296,514 302,444 305,468 308,523 311,609 01-000-40-00-4043 TELECOMMUNICATIONS TAX 494,707 491,188 535,500 491,000 490.000 495.000 506,000 506.000 506,000 01-000-40-00-4044 TELEPHONE UTILITY TAX 23,738 23,002 19,000 23,500 24.000 24,000 24,000 24,000 Teleeommuuication h Telephone f7libir Taxes were - hndgeled together in FY 2012 01-000-40-00-4045 CABLE FRANCHISE FEES 188,282 228,452 204,000 225,000 230,000 230,000 230,000 230,000 230,000 01-000-40-00-4050 HOTEL TAX 17,262 38,198 30,600 50,000 50,000 50,000 50,000 50,000 50,000 90%Rehaied to Aurora Chamber of Commerce 01-000-40-00-4060 AMUSEMENT TAX 112,964 319 134,000 120,000 134,000 134,000 134.000 134,000 134,000 01-000-40-00-4065 ADMISSIONS TAX - 181.744 190,000 190,627 104.500 104,500 104,500 104,500 104500 01-000-40-00-4070 BUSINESS DISTRICT TAX 263,363 289,015 300,000 300,000 300,000 300,000 300,000 300,000 300.000 1110%Rebated-Beginning in I�Y2013 01-000-40-00-4075 At RENTAL TAX 6 973 8,298 7,140 10,000 10.000 10,000 10.000 10,000 10,000 01-000-40-00-4080 PARA-MUTUEL TAX - 51131 15,000 16,680 - - - - - 01-000-41-00-4100 STATE INCOME TAX 1,277,889 1,315,321 1,340,000 1,315,000 1,320000 1,333,200 1,346532 1,359,997 1,373.597 01-000-41-00-4105 LOCAL USE TAX 201,681 240,047 210,000 240,000 242.400 244,824 247.272 249,745 252.242 01-000-41-00-4110 ROAD&BRIDGE TAX 151,196 164,296 164,296 166,896 170,000 170,000 175,000 175,000 180,000 01-000-41-004120 PERSONAL PROPERTY TAX 13,409 16,394 13,000 14,500 16.000 16,000 16,000 16,000 16,000 01-000-41-004160 FEDERAL GRANTS 1,502 13,288 9,200 9,200 9,200 9,200 9,200 9,200 9,200 HID7S&IDOJ Pest Orants 01-000-41-00-4170 STATE GRANTS 1,870 40,250 - 2,630 - - - - - I'obucco Grams Misc. Training Reimbnrsenicras 01-000-41-00-4182 MISC INTERGOVERNMENTAL 4,838 2,196 2,600 1,077 2,000 2,000 2,000 2,000 2,000 Pull Tab&.lar Ciame,c 01-000-42-00-4200 LIQUOR LICENSE 43,545 38,903 40,000 40,000 40,000 40,000 40,000 40,000 40,000 01-000-42-00-4205 OTHER LICENSES&PERMITS 3,786 2,670 3,000 4,400 2,700 2700 2,700 2.700 2.700 01-000-42-00-4210 BUILDING PERMITS 190,579 126,829 122,400 122,400 126,600 126,600 126,600 126.600 126,600 01-000-42-00-4214 DEVELOPMENT FEES 21,690 73,350 - - - - - - - 01-000-42-00-4220 FILING FEES 250 - 250 - - - - - - Oiscontinued aJ1erP'Y 2012-consoliduted with Mfccellaneous Income 01-00043-00-4310 TRAFFIC FINES 129,075 95,289 95,000 68,000 95,000 95,000 95,000 95.000 95,000 C'ircmt Court 1'lne.r -- - - 01-000-43-00-4320 ADMINISTRATIVE ADJUDICATION 44,565 25,457 30,000 25,000 26,000 26,000 26,000 26,000 26,000 01-000-43-00-4325 POLICE TOWS 25,500 80,490 90,000 81,750 80,000 80,000 80,000 80,000 80,000 01-000-44-004400 GARBAGESURCHARGE 1,132,478 1,177,995 1,175,600 1,175,000 1,021,784 1,021,784 1,021,784 1021,784 1.021,784 01-000-44-004405 COLLECTION FEE-YBSD 119,121 116,087 123,932 150,000 151.500 153,015 154.545 156,091 157,652 01-000-44-004414 OTHER SERVICES 1,305 3,960 - - - - - - - 2 3 FY 2010 FY 2011 FY 2012" FY 2022 -- FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Cancels our with Special Detail in Aclniin Srvcs 01-000-44-004475 OFFENDER REGISTRATION FEES - - - 200 500 500 500 500 500 01-000-45-00-4500 INVESTMENT EARNINGS 62,043 1,747 2,000 5,000 3,100 3,100 3,100 3,100 3,100 01-000-46-00-4601 REIMB-LEGAL EXPENSES 27,848 46,951 12,000 40,000 - - - - - 01-000-46-00-4604 REIMB-ENGINEERING EXPENSES - - - 11,527 - - - - - 01-000-46-00-4650 REIMB-TRAFFIC SIGNAL 14,925 33,067 15,000 28,582 15,000 10,000 10,000 10,000 15,000 01-000-46-00-4668 REIMB-COBRA CONTRIBUTIONS - 21.675 20,000 25,000 11500 12,500 12,500 12,500 11500 Cancels out with COBRA Ins E'xp in Admin Srvc.e 01-000-46-00-4669 REIMB-RETIREE INS CONTRIBUTIONS - 39,671 50,000 50,000 60398 66,438 73,082 80,390 88.429 1MIU &Police Pensioners 01-000-46-00-4670 REIMB-EMPLOYEE INS CONTRIBUTIONS 227,600 193,147 190,000 90,000 61,295 65,586 70,177 75,089 80345 01-000-46-00-4671 REIMB-LIFE INSURANCE - 4,789 4,800 3,300 1.699 1,700 1.700 1,700 1.700 01-000-46-00-4672 REIMS-LIBRARY INSURANCE - - - 93,842 - - - - - 01-000-46-00-4680 REIMB-LIABILITY INSURANCE 29,776 35,711 5,000 5,000 5,000 5,000 5,000 5.000 5,000 Canceled oat by Reimbursable Repowi in Adnun Srvcs 01-000-46-00-4681 REIMB-WORKERS COMP - 22,207 - - - - - - 0l-000-46-00-4685 REIMB-CABLE CONSORTIUM 36,185 19,505 40,000 40,000 40,000 40,000 40,000 40,000 40,000 01-000-46-00-4690 REIMB-MISCELLANEOUS 88,370 67,870 4,000 10,000 4.000 4.000 4,000 4.000 4.000 Reimb for Fingerprinting.Postage,FOIA, Accident Reports,Subpoena lees,etc. 01-000-48-004820 RENTAL INCOME 13,155 5,600 9,000 7,500 8,000 8,000 8,000 8,000 8,000 Senior Services&Beecher('[r rentals 01-000-48-00-4821 BAD DEBT RECOVERY - 10,849 - - - - - - - 01-000-48-00-4845 DONATIONS 2,460 2,784 2,000 50 - - 2,000 2,000 2,000 Suspension of Hanging Basket proceeds-see PW Sneers below 01-000-48-00-4850 MISCELLANEOUS INCOME 1,589 9,628 5,000 3,000 3,000 3,000 3,000 3,000 3,000 Cash Over Under,ON('resit Card Rebates.etc. 01-000-49-004951 TRANSFER FROM WATER 75,569 91,863 91,863 91,863 Health Ins transfer di.seonnnued-Budgeted in Water 01-000-49-00-4952 TRANSFER FROM SEWER 58,640 83,045 83,045 83,045 Health Lac transfer discontinued-Budgeted in Surer 01-000-49-00-4972 TRANSFER FROM LAND CASH 60,449 60,449 20,084 20,084 Disconrinned beginning in 1,Y2013 01-000-49-00-4979 TRANSFER FROM PARK&REC 150A00 - - 01-000-49-00-4984 TRANSFER FROM LIBRARY CAPITAL - 332,500 332,500 - - Revenue 11,007,428 11,517,961 11,823,874 12,189,289 12,311,109 12,523,106 12,704,970 12,871,879 13,051,951 3 ADMINISTRATION DEPARTMENT The Administration Department includes both the legislative and management expenditures. The legislative branch consists of the Mayor and City Council. 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. FY2012 FY2010 FY2011 Adopted FY2012 FY2013 FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 341,388 319,269 273,395 308,850 333,395 323,395 323,395 323,395 323,395 Benefits 48,000 48,949 45,106 47.500 275,732 296,202 320,785 347,826 377,566 Contractual Services 271,495 119.138 155,100 140,566 160,250 161,405 162,618 163,891 165,228 Supplies 11,762 11,264 15,950 9,950 12,950 12,950 12,950 12,950 12,950 Total Administration 672,645 498,620 489,551 506,866 782,327 793,952 819,748 848,062 879,139 $1,000 $900 N $800 'o $700 $600 $500 $400 $300 $200 $100 1j $0 4 I FY 2010 FY 2011 F'Y 2011 FY 2012 y FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Administration 01-110-50-00-5001 SALARIES-MAYOR 8,945 10,700 11,000 11,000 11,000 11,000 11,000 11,000 11,000 01-110-50-00-5002 SALARIES-LIQUORCOMM 917 1,167 1,000 1,000 1,000 1,000 1,000 1,000 1,000 01-110-50-00-5003 SALARIES-CITY CLERK 7,993 9,305 9,000 9,000 9,000 9,000 9,000 9,000 9,000 01-110-50-00-5004 SALARIES-CITY TREASURER 5,300 6,105 6,500 6,500 6,500 6,500 6500 6,500 6,500 01-110-50-00-5005 SALARIES-ALDERMAN 43,685 52,455 50;320 50,320 50,320 50,320 50,320 50,320 50,320 01-110-50-00-5010 SALARIES-ADMINISTRATION 273,685 239,314 195,000 230,000 255,000 245,000 245,000 245,000 245.000 01-110-50-00-5020 OVERTIME 863 223 575 1,030 575 575 575 575 575 01-110-52-00-5212 RETIREMENT PLAN CONTRIBUTION 26,377 26574 25,000 26,500 28,383 26,500 26,500 26,500 26,500 01-110-52-00-5214 FICA CONTRIBUTION 21_,623 22,375 20_,106 21,000 22,500 22,500 22,500 22,500 22,500 01-110-52-00-5216 GROUP HEALTH INSURANCE - - - - 72,456 79,702 87,672 96,439 106,083 01-110-52-00-5222 GROUP LIFE INSURANCE - 614 620 627 633 639 01-110-52-00-5223 DENTAL INSURANCE - 5,096 5,606 6,166 6,784 7,461 01-110-52-00-5224 VISION INSURANCE - 586 645 710 780 858 01-110-52-00-5235 ELECTED OFFICIAL-GROUP HEALTH INSURANCE - 133,917 147,309 162.039 178,243 196.068 01-110-52-00-5236 ELECTED OFFICIAL-GROUP LIFE INSURANCE - 1,043 1,069 1,095 1,123 1,151 01-110-52-00-5237 ELECTED OFFICIAL-DENTAL INSURANCE - I0,008 11,009 12.110 13,321 14,653 01-110-52-00-5238 ELECTED OFFICIAL-VISION INSURANCE - - - - 1.129 1,242 1,366 1,503 1,653 01-110-54-00-5412 TRAINING&CONFERENCES 1,769 - 3,000 2,000 3,000 3,000 3,000 3,000 3,000 01-110-54-00-5415 TRAVEL AND LODGING 4,043 790 1,750 6,000 6,000 6,000 6,000 6.000 01-110-54-00-5423 PUBLIC RELATIONS 176 55 150 150 - - - - - Line item discontinued beginning in FY 2013 01-110-54-00-5426 PUBLISHING&ADVERTISING 1,354 655 2,000 1,000 1.000 1.000 1,000 1,000 1,000 01-110-54-00-5430 PRINTING AND DUPLICATING 8,845 8,081 6,750 6,750 6,750 6,750 6,750 6,750 6,750 01-110-54-00-5440 TELECOMMUNICATIONS 24,018 12,520 21,200 13,000 15,000 15,000 15,000 15,000 15,000 01-110-54-00-5448 FILING FEES - - - 500 500 500 500 500 01-110-54-00-5451 CODIFICATION 8,788 4,159 8,000 5,000 8,000 8,000 8,000 8,000 8,000 01-110-54-00-5452 POSTAGE&SHIPPING 7,378 8.055 14,000 9,000 14,000 14,000 14,000 14,000 14,000 01-110-54-00-5462 PROFESSIONAL SERVICES 25,280 9,539 11,000 17,200 20,000 20,000 20,000 20,000 20,000 01-110-54-00-5473 KENDALL COUNTY PARATRANSIT 5,887 27,553 30,000 30,000 30,000 30,000 30,000 30.000 30,000 01-110-54-00-5474 SENIOR SERVICE FUNDING 5,000 - - - - - - - 01-110-54-00-5477 BUILDING INSPECTIONS 117,622 - - - - - - 01-110-54-00-5480 UTILITIES 25,248 21,735 28,000 22,000 23,100 24,255 25,468 26,741 28,078 5%,increase per annum 01-110-54-00-5485 RENTAL&LEASE PURCHASE - - - 1,716 1,900 1,900 1,900 1,900 1,900 01-110-54-00-5488 OFFICE CLEANING 23,490 13.124 14,400 14,400 14,400 14.400 14,400 14,400 14.400 01-110-54-00-5490 DUES AND SUBSCRIPTIONS 12,597 12,872 16,600 16,600 16,600 1600 16,600 16,600 16,600 01-110-56-00-5610 OFFICE SUPPLIES 11,407 9,320 15,000 9,000 12,000 12,000 12,000 12,000 12,000 01-110-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 355 1,944 850 850 850 850 850 850 850 01-110-56-00-5640 REPAIR AND MAINTENANCE 100 100 100 100 100 100 100 672,645 498,620 489,551 506,866 782,327 793,952 819,748 848,062 879,139 I 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. FY2012 FY2010 FY2011 Adopted FY2012 FY2013 FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 254,608 201,586 175,000 175,000 185,000 175.000 175,000 175,000 175,000 Benefits 42,230 34,085 30,505 30.505 62,135 63,981 67,288 70,924 74,921 Contractual Services 113,197 93,906 109,250 87,914 88,150 88,150 88.150 90,150 90.150 Supplies 6,159 3,281 5,750 5,250 5,250 5,250 5.250 5,250 5,250 Total Finance Department 416,194 332,858 320,505 298,669 340.535 332,381 335,688 341,324 345,321 $500 $400 �i �� 'o $300 • L F $200 $100 $0 O 7 FY 2010 FY 2011 FY 2012 FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget Projected - Adopted Projected Projected Projected Projected Finance 01-120-50-00-5010 SALARIES AND WAGES 254,608 201,586 175,000 175.000 185,000 175,000 175,000 175,000 175.000 01-120-52-00-5212 RETIREMENT PLAN CONTRIBUTION 21,826 18,759 17,500 17,500 18,659 17,500 17,500 17,500 17,500 01-120-52-00-5214 FICA CONTRIBUTION 20,404 15,326 13,005 13,005 13.005 13,005 13.005 13,005 13.005 01-120-52-00-5216 GROUP HEALTH INSURANCE - - - 26.472 29,119 32,031 35,234 38,757 01-120-52-00-5222 GROUP LIFE INSURANCE 461 465 470 475 479 01-120-52-00-5223 DENTAL INSURANCE 3.182 3.500 3,851 4,236 4.659 01-120-52-00-5224 VISION INSURANCE - - - 356 392 431 474 521 01-120-54-00-5412 TRAINING&CONFERENCES - - 2,000 2,000 2,000 2,000 2.000 2,000 2.000 01-120-54-00-5414 AUDITING SERVICES 54,040 43,500 45,000 44,800 36,000 36,000 36,000 38,000 38.000 01-120-54-00-5415 TRAVEL AND LODGING - - 1,000 500 1,000 1,000 1,000 1,000 1,000 01-120-54-00-5430 PRINTING AND DUPLICATING - - 500 - 500 500 500 500 500 01-120-54-00-5440 TELECOMMUNICATIONS 993 633 600 540 600 600 600 600 600 01-120-54-00-5452 POSTAGE&SHIPPING 1,284 474 : 500 500 500 500 500 500 500 01-120-54-00-5460 DUES AND SUBSCRIPTIONS 678 902 " 850 600 850 850 850 850 850 01-120-54-00-5462 PROFESSIONAL SERVICES 37,238 29,531 42,000 32,000 40.000 40,000 40,000 40,000 40,000 01-120-54-00-5485 RENTAL&LEASE PURCHASE 18,964 18,028 15,000 6,724 4,900 4,900 4,900 4,900 4,900 01-120-54-00-5495 OUTSIDE REPAIR AND MAINTENANCE - 838 1,800 250 1,800 1,800 1,800 1,800 1,800 01-120-56-00-5610 OFFICE SUPPLIES 3,527 1,520 2,500 2,500 2,500 2,500 2,500 2,500 2,500 01-120-56-00-5630 SMALL TOOLS&EQUIPMENT - - 250 250 250 250 250 250 250 01-120-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 2,632 1,761 - 2,500 2,500 2,500 2,500 2,500 2,500 2,500 01-120-56-00-5640 REPAIR AND MAINTENANCE 500 - 416,194 332,858 320,505 298,669 340,535 332,381 335,688 341,324 345,321 7 COMMUNITY RELATIONS DEPARTMENT The Community Relations Department was closed out at the end of fiscal year 2011. Expenditures are now budgeted out of the Administrative Services department. FY2012 FY2010 FY2011 Adopted FY2012 FY2013 FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 67,676 63,359 - - - - - - - Benefits 9.690 7,939 - - - - - - - Contractual Services 15,609 11,361 333 333 - - - - - Supplies 2,285 656 - - - - - - - Total Community Relations 95,260 83,315 333 333 - - - - - $120 c $100 m c $80 ~ $60 i $40 I $20 $0 O FY 2010 FV 2011 FY 2012 FY 2012 FY 2013 FY 2014 FV 2015 FV 2016 FV 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Community Relations 01-130-50-00-5010 SALARIES AND WAGES 65,250 63,359 O1-130-50-00-5015 PART-TIME SALARIES 2,426 01-130-52-00-5212 RETIREMENT PLAN CONTRIBUTION 5,603 4,004 01-130-52-00-5214 FICA CONTRIBUTION 4,087 3,935 - 01-130-54-00-5423 PUBLIC RELATIONS 1,565 - - - - 01-130-54-00-5426 PUBLISHING&ADVERTISING 5,923 5.977 333 333 01-130-54-00-5430 PRINTING AND DUPLICATING 135 - - - 01-130-54-00-5440 TELECOMMUNICATIONS 453 279 O1-130-54-00-5452 POSTAGE&SHIPPING 1,933 1,630 01-130-54-00-5460 DUES AND SUBSCRIPTIONS 275 - 01-130-54-00-5462 PROFESSIONAL SERVICES 5325 3,475 O1-130-56-00-5610 OFFICE SUPPLIES 346 130 - 01-130-56-00-5692 COMMUNITY EVENTS 1,939 526 95,260 83,315 333 333 O 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. FY2012 FY2010 FY2011 Adopted FY2012 FY2013 FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 327,133 235,639 172,500 78,123 - - - - - Benefits 52,525 39,136 29,736 13,348 - - - - - Contractual Services 42,944 10,022 42,100 4,184 - - - - - Supplies 2,861 9,994 8,800 7 - - - - - Total Engineering Department 425,463 294,791 253,136 95,662 - - - - - $500 N m $400 N 7 O $300 $200 $100 $0 10 11 FY 2010 FY 2011 VY 2012 -� FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Engineering 01-150-50-00-5010 SALARIES AND WAGES 327,133 235,552 172,000 78,123 01-150-50-00-5020 OVERTIME 87 500 - 01-150-52-00-5212 RETIREMENT PLAN CONTRIBUTION 28,301 21,727 16,500 7,430 01-150-52-00-5214 FICA CONTRIBUTION 24,224 17,409 13,236 5,918 01-150-54-00-5410 TUITION REIMBURSEMENT 823 - - - 01-150-54-00-5412 TRAINING&CONFERENCES (115) 2,250 - 01-150-54-00-5415 TRAVEL AND LODGING 7 400 3 01-150-54-00-5430 PRINTING AND DUPLICATING 1,217 1,116 1,500 286 01-150-54-00-5440 TELECOMMUNICATIONS 2.288 1,340 2,200 207 01-150-54-00-5452 POSTAGE&SHIPPING 452 257 500 23 01-150-54-00-5460 DUES AND SUBSCRIPTIONS 62 428 1,200 - 01-150-54-00-5462 PROFESSIONAL SERVICES 36,689 5,578 32,550 2,000 01-150-54-00-5485 RENTAL&LEASE PURCHASE - - - 1,638 01-150-54-00-5495 OUTSIDE REPAIR AND MAINTENANCE 1,521 1,303 1,500 27 01-150-56-00-5600 WEARING APPAREL - - 100 - 01-150-56-00-5610 OFFICE SUPPLIES 280 1,006 1,000 7 01-150-56-00-5622 ENGINEERING SUPPLIES 1,146 928 1,500 01-150-56-00-5630 SMALL TOOLS&EQUIPMENT - - 500 01-150-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 1,399 2,627 4,550 01-150-56-00-5640 REPAIR AND MAINTENANCE - - 1,000 01-150-56-00-5645 BOOKS AND PUBLICATIONS 36 126 150 01-150-56-00-5690 SUPPLIES-GRANT REIMBURSABLE 5,307 - - 425,463 294,791 253,136 95,662 11 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. FY2012 FY2010 FY2011 Adopted FY2012 FY2013 FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 2,452,761 2,127,332 2,127,500 2,187,500 2,305,500 2,287,500 2,337,500 2,387,500 2,437,500 Benefits 519,722 507,612 560,900 545,356 1,169,457 1,311,307 1,397,926 1,540,701 1,640,248 Contractual Services 176,795 131,034 190,010 192.234 213,850 202,850 201,850 202,850 201,850 Supplies 110,920 112,842 139,820 145,820 151,770 156,137 164,949 170,238 178,037 Total Police Department 3,260,198 2,878,820 3,018,230 3,070,910 3,840,577 3,957,794 4,102,225 4,301,289 4,457,635 $5,000 $4,500 $4,000 O $3,500 ° $3,000 r $2,500 $2,000 $1,500 $1,000 $500 $0 12 13 FY 2010 FY 2011 FY 2012 FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 F)'2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Police 01-210-50-00-5006 SALARIES-LIEUT/SERGEANTS/CHIEFS 774,290 660,249 610,000 610,000 - - - - - Police Admin &Sgt's are now broken oat 01-210-50-00-5010 SALARIES-POLICE OFFICERS 1.327,063 1.167,964 1;250,000 1,250,000 1,261,000 1,300,000 1,350,000 1,400,000 1 450,000 New Qf wer added each year-PT 2013-17 01-210-50-00-5011 SALARIES-POLICE CHIEF&DEPUTIES - - - - 312000 300,000 300.000 300,000 300,000 01-210-50-00-5012 SALARIES-SERGEANTS - - - - 430,000 400,000 400,000 400,000 400.000 New Sergeant added(or FY2013 01-210-50-00-5013 SALARIES-POLICE CLERKS 200,568 156,502 120,000 130,000 135,000 125,000 125,000 125,000 125.000 01-210-50-00-5014 SALARIES-CROSSING GUARD 23,327 17,381 20,000 20,000 20,000 20,000 20,000 20,000 20,000 01-210-50-00-5015 PART-TIME SALARIES 40,775 30,604 39,000 39,000 52,500 52,500 52,500 52,500 52,500 01-210-50-00-5017 CADET PROGRAM 10,969 12,045 13,500 13,500 - - - - - Combined wilt P7"salaries-C'SO Program 01-210-50-00-5020 OVERTIME 75,769 82,587 75,000 125,000 90,000 90,000 90,000 90,000 90,000 01-210-52-00-5212 RETIREMENT PLAN CONTRIBUTION 17,322 14,455 15,900 15,000 15.818 15,000 15,000 15,000 15.000 01-210-52-00-5213 EMPLOYER CONTRI-POLICE PENSION 323,291 336,075 375,000 360,356 413354 500,000 525000 600,000 625,000 1731)annually by actuarial evaluation 01-210-52-00-5214 FICA CONTRIBUTION 179,109 157,082 170,000 170,000 175.000 175,000 175,000 175,000 175.000 01-210-52-00-5216 GROUP HEALTH INSURANCE - - - - 517,950 569,745 626,720 689,392 758331 01-210-52-00-5222 GROUP LIFE INSURANCE - 5.635 5,692 5.749 5.806 5.864 01-210-52-00-5223 DENTAL INSURANCE - 37,428 41,171 45,288 49,817 54,799 01-210-52-00-5224 VISION INSURANCE - 4,272 4,699 5,169 5,686 6,254 01-210-54-00-5410 TUITION REIMBURSEMENT - 1,808 2,800 2,800 2,800 2.800 2,800 1800 2,800 01-210-54-00-5411 POLICE COMMISSION 11,999 3,677 15,000 15,000 4,000 15,000 4,000 15,000 4,000 Spikes are due to testingdeadlines,fin Officers and Sgl's 01-210-54-00-5412 TRAINING&CONFERENCE 7,239 8,554 12,000 12,000 15,000 13,000 13,000 13,000 13,000 Increase for New Hires(gross luition) 01-210-54-00-5415 TRAVEL AND LODGING 5,832 1,873 10,000 10,000 10,000 10,000 10,000 10,000 10,000 01-210-54-00-5426 PUBLISHING&ADVERTISING 187 86 200 200 200 200 200 200 200 01-210-54-00-5430 PRINTING AND DUPLICATING 5,842 2,923 4,500 4,500 4,500 4,500 4,500 4,500 4,500 01-210-54-00-5440 TELECOMMUNICATIONS 40,490 22,142 36,500 25,000 36,500 36.500 36,500 36.500 36,500 01-210-54-00-5452 POSTAGE&SKIPPING 1,821 986 3,000 1,500 3,000 3,000 3,000 3,000 3,000 01-210-54-00-5460 DUES AND SUBSCRIPTIONS 1,696 1,115 1,350 1,350 1,350 1,350 1.350 1,350 1,350 01-210-54-00-5462 PROFESSIONAL SERVICES 6,446 4.222 4,000 10,000 5.000 5,000 5,000 5,000 5,000 IY 2012 Overage needed fm-Psych and Hackgramds - for all jailed Officers and Cadets 01-210-54-00-5466 LEGAL SERVICES 16,367 - 10,000 10,000 20,000 10,000 20,000 10,000 20,000 Spike.v due n,Union Negotiations,ac.vunong-'year cone acts and that non-legal negnlialions jail 01-210-54-00-5467 ADMIN ADJ-HEARING OFFICER 17,925 16,863 15,000 20,000 20,000 20,000 20,000 20,000 20,000 13ased on acnmis for Hearing Officer and Uepo Cunrl 01-210-54-00-5469 NEW WORLD LIVE SCAN 15,087 10,281 15,000 15,000 15,000 15,000 15,000 15,000 15,000 01-210-54-00-5472 KENDALL CO.JTJVEPROBATION 2,784 2,683 3,000 3,000 4,000 4,000 4,000 4,000 4,000 Increase in 1,1'13 haled on an expected increase Ill costs fn-Jule 01-210-54-00-5484 MDT-ALERTS FEE 6,660 6,660 6,660 6,660 7,000 7,000 7,000 7,000 7,000 01-210-54-00-5485 RENTAL&LEASE PURCHASE - - 4,224 4,500 4.500 4,500 4.500 4.500 Slorage and Copicr charges 13 14 FY 2010 FY 2011 FY 2012 FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 F)'2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 01-210-54-00-5495 OUTSIDE REPAIR AND MAINTENANCE 36,420 47,161 51,000 51,000 61,000 51,000 51,000 51,000 51,000 ilddilional S10A in hY 13 is due In Radio N,,mrhand,,W ,,,gsiren.enls 01-210-56-00-5600 WEARING APPAREL 9,118 10_,586 10,000 16,000 16,000 14,000 16,000 14,000 14,000 Increases to correspond svilh new hire schedule above 01-210-56-00-5610 OFFICE SUPPLIES 4,119 2,933 " 4,000 4,000 4,000 4,000 4,000 4,000 4,000 01-210-56-00-5620 OPERATING SUPPLIES 5,077 7,061 8,000 8,000 8,000 8,000 8,000 8,000 8.000 01-210-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 7,993 5,032 7,000 7,000 7,000 7,000 7,000 7,000 7,000 01-210-56-00-5640 REPAIR AND MAINTENANCE 6,032 6,569 12,250 12,250 12,250 12,250 12,250 12,250 12,50 01-210-56-00-5650 COMMUNITY SERVICES 4,006 3,020 7,370 7,370 7,370 7,370 7,370 7.370 7,370 Combines Grew Program,Comnumiq,Relalions, <.... Neighborhood bValch.(mi ens Police,leadenm r� Canlphance Checks line ilem.s - 01-210-56-00-5690 SUPPLIES-GRANT REIMBURSABLE 4,565 5,566 4,200 4,200 4,200 4,200 4,200 4,200 4,200 01-210-56-00-5695 GASOLINE 70,010 70,080 85,000 85,000 90,950 97,317 104,129 111,418 119.217 '%increase per annum 01-210-56-00-5696 AMMUNITION - 1,995 2,000 2,000 2,000 2,000 2,000 2,000 2,000 3,260,198 2,878,820 3,018,230 3,070,910 3,840,577 3,957,794 4,102,225 4,301,289 4,457,635 14 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. FY2012 FY2010 FY2011 Adopted FY2012 FY2013 FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 295,414 269,607 240,000 205,000 248,000 238,000 238,000 238,000 238,000 Benefits 45,359 43,761 44,535 37,260 109,797 114,985 122,042 129,804 138,341 Contractual Services 66,641 69,730 84,450 93,588 92,350 92,350 97.350 98,850 100,395 Supplies 12,371 12,193 6,625 6,625 112279 11,535 11,809 12,101 12,415 Total Community Development 419,785 395,291 375,610 342,473 461,426 456,870 469,201 478,755 489,151 $600 0 N $500 r VI t $400 $300 $200 $100 $0 15 16 FY 2010 FY 2011 1+')<'2012 FY,i4li FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget, Projected `' Adopted Projected Projected Projected Projected Community Development 01-220-50-00-5010 SALARIES AND WAGES 295,414 269,607 240,000 205,000< 195,000 185,000 185,000 185,000 185.000 01-220-50-00-5015 PART-TIME SALARIES - - - 53,000 53,000 53,000 53,000 53,000 Code Enforcement Imern-S13,000 2 PT lnspeclors-540.000 01-220-52-00-5212 RETIREMENT PLAN CONTRIBUTION 23,567 24,175 27,275 20,000 26,227 25,000 25,000 25,000 25,000 01-220-52-00-5214 FICA CONTRIBUTION 21392 19,586 17,260 17,260 19,000 19,000 1900 19,000 19,000 01-220-52-00-5216 GROUP HEALTH INSURANCE - - - - 59,499 65,449 71,994 79,193 87,112 01-220-52-00-5222 GROUP LIFE INSURANCE 461 465 470 475 479 01-220-52-00-5223 DENTAL INSURANCE - - 4,139 4,553 5,008 5,509 6,060 01-220-52-00-5224 VISION INSURANCE, - - - - 471 518 570 627 690 01-220-54-00-5412 TRAINING&CONFERENCES 450 115 1,200 1,200 1.500 1,500 1,500 1,500 1,500 01-220-54-00-5415 TRAVEL AND LODGING - - 700- 700 1,000 1,000 1,000 1.000 1,000 01-220-54-00-5426 PUBLISHING&ADVERTISING 326 87 - 150 150 500 500 500 500 500 01-220-54-00-5430 PRINTING AND DUPLICATING 1,548 1,062 1,500 1,500 4250 4,250 4,250 4,250 4,250 01-220-54-00-5440 TELECOMMUNICATIONS 1,355 1,318 1,500 1,500 1,500 1,500 1,500 1.500 1,500 01-220-54-00-5452 POSTAGE&SHIPPING 459 230 500 500 500 500 500 500 500 01-220-54-00-5459 INSPECTIONS - 17,387 20,000 27,500 25,000 25.000 25,000 25,000 25,000 01-220-54-00-5460 DUES AND SUBSCRIPTIONS 480 1,016 1,500 1,500 1,500 1,500 1,500 1,500 1,500 01-220-54-00-5462 PROFESSIONAL SERVICES 12.550 1,738 6,000 6,000 6.000 6.000 6,000 6.000 6,000 01-220-54-00-5466 LEGAL SERVICES 4,473 1,777 6,400 6,400 2,000 2,000 2,000 2,000 2,000 01-220-54-00-5485 RENTAL&LEASE PURCHASE - - - 1,638 3,600 3,600 3,600 3,600 3,600 01-220-54-00-5486 ECONOMIC DEVELOPMENT 45,000 45,000 45,000 45,000 45,000 45,000 50,000 51,500 53,045 YLDC unnual conlrihulmn 01-220-56-00-5610 OFFICE SUPPLIES - 469 500 500, 500 500 500 500 500 01-220-56-00-5620 OPERATING SUPPLIES 1,532 712 3,000 3,000 3,000 3,000 3,000 3,000 3,000 01-220-56-00-5630 SMALL TOOLS&EQUIPMENT 138 - 125 125 125 125 125 125 125 01-220-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 560 2,171 2,500 2,500 3.500 3.500 3.500 3,500 3,500 01-220-56-00-5645 BOOKS AND PUBLICATIONS 495 493 500 500 500 500 500 500 500 01-220-56-00-5690 SUPPLIES-GRANT REIMBURSABLE 9,646 8,348 - - - - - - - 01-220-56-00-5695 GASOLINE - 3,654 3,910 4,184 4.476 4,790 Increase 7%per annum 419,785 395,291 375,610 342,473 461,426 456,870 469,201 478,755 489,151 16 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. FY2012 FY2010 FY2011 Adopted FY2012 FY2013 FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 312,133 295,927 285,000 280,000 295,000 285,000 285,000 285,000 285,000 Benefits 50,097 49,515 53,500 53,500 147,530 154,886 164,904 175,924 188,045 Contractual Services 1,337,851 1,321.931 1,340,020 1,338,491 1,390,020 1,402,320 1,409,860 1,417,652 1,425,709 Supplies 92,936 121,163 118,350 116,141 87,902 91,994 98,187 102,489 106,907 Capital Outlay 7,364 - - - - - - - - Total Public Works Department 1,800,381 1,788,536 1,796,870 1,788,132 1,920,452 1,934,200 1,957,951 1,981,065 2,005,661 -- I $2,050 r $2,000 N 'o $1,950 $1,900 $1,850 $1,800 I $1,750 $1,700 $1,650 17 1,800,381 1,788,536 1,796,870 18 1,788,132 1,920,452 1,934,200 1,957,251 1,981,065 2,005,661 FY 2010 FY 2011 FY 261i FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget Projected '' Adopted Projected Projected Projected Projected Street Operations 01-410-50-00-5010 SALARIES AND WAGES 296,220 285,143 270,000 270,000 280.000 270,000 270,000 270,000 270,000 01-410-50-00-5020 OVERTIME 15,913 10,784 15,000 10,000 15,000 15,000 15,000 15,000 15,000 01-410-52-00-5212 RETIREMENT PLAN CONTRIBUTION 26,842 27,424 30,000 30,000 31,753 30,000 30-000 30,000 30.000 01-410-52-00-5214 FICA CONTRIBUTION 23,255 22,091 23,500 23,500 23,500 23,500 23500 23,500 23.500 01410-52-00-5216 GROUP HEALTH INSURANCE - - - - 83,361 91,697 100,867 110,953 122,049 01410-52-00-5222 GROUP LIFE INSURANCE - 1,317 1,330 1.343 1,357 1,370 01-410-52-00-5223 DENTAL INSURANCE - 6,826 7,509 8,259 9,085 9,994 01410-52-00-5224 VISION INSURANCE - - - - 773 850 935 1,029 1.132 01410-54-00-5412 TRAINING&CONFERENCES 110 180 2,000 2,000 2,000 2,000 2,000 2,000 2,000 01-410-54-00-5440 TELECOMMUNICATIONS 2,536 2,053 4,020 4,020 4,020 4,020 4,020 4,020 4,020 01-410-54-00-5446 PROPERTY&BLDG MAINT SERVICES 10,386 8,267 - - 20,000 22,500 25,000 27,500 30,000 01-410-54-00-5454 SIDEWALK PROGRAM 3,966 1,225 4,000 4,000 4,000 4,000 4,000 4,000 4,000 01-410-54-00-5455 MOSQUITO CONTROL 30,966 6,500 7,000 6,500 7,000 7,000 7,000 7.000 7,000 01410-54-00-5458 TREE&STUMP REMOVAL 6,790 8,300 10,000 10,000 20,000 20.000 20,000 20.000 20.000 Increase due to Eincruld Ash Borer 01-410-54-00-5462 PROFESSIONAL SERVICES 1,861 1,165 1,000 1,000 1,000 1,000 1,000 1,000 1,000 01-410-54-00-5480 UTILITIES 94,920 89,784 80,000 80,000 90,000 94.500 99,225 104,186 109,396 5%Increase per annum 01-410-54-00-5485 RENTAL&LEASE PURCHASE 300 176 1,000 1,051 1,000 1,000 1,000 1,000 1.000 01-410-54-00-5495 OUTSIDE.REPAIR AND MAINTENANCE 26,856 22,110 30,000 25,000 35,000 40,000 40,000 40,000 40,000 01-410-56-00-5600 WEARING APPAREL 2,441 2,386 5,000 2,750 4,200 4,200 4,200 4,200 4,200 01-410-56-00-5620 OPERATING SUPPLIES 3,875 3,801 9,500 9,500 9,500 9,975 10.474 10,997 11,547 Assumed older equipment Trill need to he replaced 01-410-56-00-5626 HANGING BASKETS 1,800 2,048 2,000 2,041 - - 2,000 2,000 2,000 Podponemem ofHonging Baskets until Kl 47 Project complcled 01-410-56-00-5630 SMALL TOOLS&EQUIPMENT 483 1,896 1,750 1,750 1,750 1,750 1,750 1,750 1,750 01-410-56-00-5640 REPAIR AND MAINTENANCE 52,532 76,277 36,500 36,500 36,500 36,500 36,500 36,500 36,500 01-410-56-00-5656 PROPERTY&BLDG MAINT SUPPLIES 5,673 5,405 30,000 30,000 20,000 22,500 25,000 27,500 30,000 01-410-56-00-5695 GASOLINE 26,132 29,350 33,600 33,600 15,952 17.069 18,263 19,542 20,910 Increase_%perunnunv Purkc portion no,accounted fin•rn hinxl 79 01-410-60-00-6040 IN-TOWN ROAD PROGRAM 7,364 - - - - - 641,221 606,365 595,870 583,212 714,452 727,900 751,336 774,119 798,368 Health and Sanitation 01-540-54-00-5441 GARBAGE SERVICES-SENIOR SUBSIDY - - - 153,216 153,216 153,216 153,216 153,216 01-540-54-00-5442 GARBAGE SERVICES 1,154,840 1,177.611 1,195,000 1,200,000 1,046.784 1046,784 1,046,784 1,046,784 1,046,784 01-540-54-00-5443 LEAF PICKUP 4,320 4,560 6,000 4,920 6.000 6.300 6,615 6.946 7,293 Assumed lea%price increase 1,159,160 1,182,171 1,201,000 1,204,920 1,206,000 1,206,300 1,206,615 1,206,946 1,207,293 1,800,381 1,788,536 1,796,870 18 1,788,132 1,920,452 1,934,200 1,957,251 1,981,065 2,005,661 ADMINISTRATIVE SERVICES DEPARTMENT The Administrative Services Department accounts for General Fund expenditures that are shared by all departments and cannot be easily classified in one department or the other. These expenditures include such items as tax rebates, bad debt,contingencies,corporate legal expenditures and interfund transfers. FY2012 FY2010 FY2011 Adopted FY2012 FY2013 FY2014 FY2015 FY2015 FY2015 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries - 4,432 5,000 5,000 5,000 5,000 5,000 5,000 5,000 Benefits 1,554,427 1,715,455 1,743,350 1,737,650 562,389 593,358 626,626 662,378 700,807 Contractual Services 2,413,466 1,713,034 1,693,840 2,051,817 1,895,500 1,840,220 2,045,682 2,121,907 2,148,919 Supplies - - 5,000 5,000 5,000 5,000 5,000 5,000 5,000 Contingencies 16,153 75,000 64,617 52,075 50,000 50,000 50,000 50,000 50,000 Other Financing Uses 1,644,594 1,516,778 1,293,950 1,297.950 1,516,661 2,517,952 2.596,554 3,072.607 2,992,619 Total Administrative Services&Transfers 5,628,640 5,024,699 4,805,757 5,149,492 4,034,550 5,011,530 5,328,862 5,916,892 5,902,345 $7,000 $6,000 c $5,000 r ~ $4,000 $3,000 $2,000 $1,000 $0 19 20 FY 2010 FY 2011 FY 2012 - FY 2012 ., FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Administrative Services 01-640-50-00-5092 POLICE SPECIAL DETAIL WAGES 4,432 5,000 5,000' 5,000 5,000 5,000 5.000 5,000 Cancels out with Special Delail revenue 01-640-52-00-5212 RETIREMENT PLAN CONTRIBUTION-ERI - - - 60,000 60,000 60,000 60,000 60,000 IMM'Early Relirement Incentive Program 01-640-52-00-5216 GROUP HEALTH INSURANCE 1,118,821 1,185,928 1,204,000 1,225,000 - - - - - Allocaled to the Dept.'s beginning in IT 2013 01-640-52-00-5222 GROUP LIFE INSURANCE 28,262 24,060 26,600 14,000 Allocaled to the Dept.'s beginning in 1,Y2013 01-640-52-00-5223 DENTAL INSURANCE 76,557 86,818 114,000 88,000 Allocated to the Dept.S beginning in FY2013 01-640-52-00-5224 VISION INSURANCE 13,448 12,532 - 10.500 - - - - Allocated to the Dept.'s beginning in FY 2013 01-640-52-00-5225 EMPLOYEE ASSISTANCE 2,487 2,425 150 150 150 150 150 150 150 01-640-52-00-5230 UNEMPLOYMENT INSURANCE 38,466 77,786 60,000 90.000 47.143 47,143 47,143 47,143 47.143 Allocated at hand Level-Beg in FY 2013 01-640-52-00-5231 LIABILITY INSURANCE 276,386 325,906 339,200 310,000 331256 352,191 373322 395,722 419,466 Allocated at 1,imd Level-Beg in I,Y2013 01-640-52-00-5240 RETIREES-GROUP HEALTH INSURANCE - - - - 104,458 114,904 126394 139,034 152,937 01-640-52-00-5241 RETIREES-DENTAL INSURANCE 5,246 5,770 6,347 6,982 7,680 01-640-52-00-5242 RETIREES-VISION INSURANCE - 636 700 770 847 931 01-640-52-00-5250 COBRA-GROUP HEALTH INSURANCE - 11,375 11,375 11,375 11.375 11,375 Cancels out with COBRA Reimbursement 01-640-52-00-5251 COBRA-DENTAL INSURANCE 1,000 1,000 1,000 1.000 1,000 Cancels out with COBRA Reimbursement 01-640-52-00-5252 COBRA-VISION INSURANCE 125 125 125 125 125 Cancels out with COBRA Reimbursement 01-640-54-00-5449 KENCOM - - - 150.000 200,000 200 000 1)i.cpalch MAY 01-640-54-00-5450 INFORMATION TECHNOLOGY SERVICES - 140,000 60,000 60,000 60,000 60,000 Separated ma lmin Pro Sn,cc beginning in 1,1'2013 01-640-54-00-5453 SPECIAL ENGINEERING SERVICES - - - - - - 30,000 30,000 30,000 01-640-54-00-5456 CORPORATE COUNSEL 110,259 117,960 130,000 115,000 130,000 130,000 130,000 130,000 130,000 01-640-54-00-5461 LITIGATION COUNSEL 93,529 87,544 60,006 110,000 60,000 60,000 60,000 60,000 60,000 01-640-54-00-5462 PROFESSIONAL SERVICES - - 50,000 60,000 500 500 500 500 500 DAC Achnin bies 01-640-54-00-5463 SPECIAL COUNSEL 59,394 25,000 25,000 25,000 25,000 25.0011 25,000 25,000 01-640-54-00-5465 ENGINEERING SERVICES - - - 180,000 180,000 180,000 180,000 180,000 180.000 01-640-54-00-5466 LEGAL SERVICES 38,747 - - - - - - - - 01-640-54-00-5475 CABLE CONSORTIUM FEE 54,240 75,262 85,000 80,000 85,000 85,000 85,000 85,000 85,000 01-640-54-00-5479 COMMUNITY RELATIONS - - - 440 - - - - - Disconlinned alter I%Y 2012 01-640-54-00-5481 HOTEL TAX REBATE 15,739 33,255 27,540 45,000 45,000 45,000 45,000 45,000 45,000 90%of Hotel Lax proceeds are rebated 01-640-54-00-5491 CITY PROPERTY TAX REBATE 808 812 1,050. 1,532 1,500 1,500 1,500 1500 1,500 01-640-54-00-5492 SALES TAX REBATE 773,140 863,793 900,000 ' 1,030,000 824,000 848,720 874,182 900,407 927,419 01-640-54-00-5493 BUSINESS DISTRICT REBATE 248,742 283,777 300,000 300.000 300,000 300,000 300,000 300,000 300,000 01-640-54-00-5494 ADMISSIONS TAX REBATE 62,130 99,959 114;000 104,845 104,500 104,500 104,500 104,500 104,500 20 21 FY 2010 FY 2011 i'Y 2012 ', FY 3012 ' FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 01-640-56-00-5625 REIMBURSABLE REPAIRS - - 5,000 5,000 5,000 5,000 5,000 5,000 5,000 Canceled out by Reimb.-Liability Ins 01-640-70-00-7799 CONTINGENCIES 16,153 75,000 64,617 52,075- 50,000 50000 50,000 50,000 50,000 01-640-99-00-9923 TRANSFER TO CITYWIDE CAPITAL 100,000 135,484 125,000 125,000 419,332 352,500 406,943 846,043 646,943 PY2012-Library Capital Proceeds-S332.500 01-640-99-00-9942 TRANSFER TO DEBT SERVICE 425,094 429,404 X103,740 103,740 99,465 - - 4,676 86,579 01-640-99-00-9952 TRANSFER TO SEWER - - - - 1,137,220 1,133,972 1,134.654 1.134,052 To corer 2011 bond-debt sen-ice pmi's 01-640-99-00-9979 TRANSFER TO PARK&RECREATION 1,119,500 951,890 732,710 736,710 955,886 983,992 1,009,002 1,038,056 1,073.173 Inc ludesadd7S from Raging Wares-Acbni.ssionslax in 1--)'2012 - 01-640-99-00-9982 TRANSFER TO LIBRARY OPERATIONS 332,500 332,500 41,978 44,240 46,637 49,178 51,872 Transfer to ol*t liabili!y ins charges to Library 5,628,640 5,024,699 4,805,757 5,149,492 4,034,550 5,011,530 5,328,862 5,916,892 5,902,345 Expenditures 12,718,566 11,296,930 11,059,992 11,252,537 11,379,867 12,486,727 13,013,675 13,867,387 14,079,252 Surplus(Deficit) (1,711,138) 221,031 763,882 936,752 931,242 36,379 (308,705) (995,508) (1,027,301) Fund Balance (492,939) (271,900) 258,636 664,852 1,596,094 1,632,473 1,323,768 328,260 (699,041) -3.88% -2.41% 2.34% 5,91% 14.03% 13.07% 10.1-% 2.37% -4.97% 21 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. Expenditures Contractual Services FY2010 Actual FY2011 Actual FY2012 Adopted Budget FY2012 Projected FY2013 Adopted Budget FY2014 Projected FY2015 Projected FY2016 Projected FY2017 Projected Revenue - - - - - - - - Other Financing Uses - 96,000 - - - - - - Total Expenditures 368,519 452,490 661,000 583,500 573,860 478,006 442,990 458,863 475,690 Intergovernmental 434,263 523,767 517,000 527,319 454,197 455,000 455,000 455,000 455,000 Investment Earnings 779 837 1,000 350 350 350 350 350 350 Reimbursements 38,057 162,580 493,000 - - - - - - Miscellaneous 105 85 - - - - - - - Total Revenue 473,204 687,269 1,011,000 527,669 454,547 455,350 455,350 455,350 455,350 Expenditures Contractual Services 7,865 33,516 - - - - - - - Supplies 191,203 227,168 311,600 311,600 341,960 356,106 321,090 336,963 353,790 Capital Outlay 208,136 95,806 349,400 271,900 231,900 121,900 121,900 121,900 121,900 Contingencies (38,685) - - - - - - - - Other Financing Uses - 96,000 - - - - - - Total Expenditures 368,519 452,490 661,000 583,500 573,860 478,006 442,990 458,863 475,690 Surplus(Deficit) 104,685 234,779 350,000 (55,831) (119,313) (22,656) 12,360 (3,513) (20,340) Ending Fund Balance 405,618 640,399 776,755 584,568 465,255 442,599 454,959 451,446 431,106 „ $1,000 Fund Balance $800 s $600 ~ $400 $200 $0 1 - 22 23 FY 2010 FY 2011 A 2012' FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 F)'2017 Account Description Actual Actual -Budget Projected. Adopted Projected Projected Projected Projected Motor Fuel Tax -15 15-000-41-00-4112 MOTOR FUEL TAX 409,576 425,971 355,000 415,000 415,000 415,000 415,000 415,000 415,000 15-000-41-004113 MFT HIGH GROWTH 24,687 24,674 20,000 39,197 39,197 40,000 40,000 40000 40,000 Based un DX)T Projeelions 15-000-41-00-4172 ILLINOIS JOBS NOW PROCEEDS - 73,122 142,000 73,122 - - - - - 15-000-45-00-4500 INVESTMENT EARNINGS 779 837 1,000 350 350 350 350 350 350 15-000-46-00-4605 REIMB-OLD JAIL/DWTWN PARKING LOT - 151,000 493,000 - - - - - - 15-000-46-00-4690 REIMB-MISCELLANEOUS 38,057 11,580 - 15-000-48-00-4850 MISCELLANEOUS INCOME 105 85 - Revenue 473,204 687,269 1,011,000 527,669 454,547 455,350 455,350 455,350 455,350 15-155-54-00-5462 PROFESSIONAL SERVICES - 2,587 - - - - - - - 15-155-54-00-5495 OUTSIDE REPAIR AND MAINTENANCE 7,865 30,929 - - - - - - 15-155-56-00-5618 SALT 170,268 132,777 220,000 220,000 231,000 242,550 254,678 267,411 280,792 5%increases per annum 15-155-56-00-5619 SIGNS 5,941 1,232 18,000 18,000 35,000 35,000 35,000 35,000 35,000 15-155-56-00-5632 PATCHING - 51481 50,000 50,000 50.000 50,000 - - - 15-155-56-00-5633 COLD PATCH 3,983 9,892 10,600 10,600 11,660 12,826 14,109 15,519 17,071 15-155-56-00-5634 HOT PATCH 11,011 7,658 13,000 13,000 14,300 15,730 17,303 19.033 20,937 15-155-56-00-5640 REPAIR AND MAINTENANCE - 23,128 - - - - - - - 15-155-60-00-6072 DOWNTOWN PARKING LOT - 42,420 55,000 - 15-155-60-00-6073 CAME FARM ROAD PROJECT 54,226 31,456 150,000 150,000_ 110,000 15-155-60-00-6074 FOX ROAD PROJECT 153,910 21,930 - - - 15-155-60-00-6075 RIVER ROAD BRIDGE PROJECT - - 25,000 - - - - - 15-155-60-00-6079 ROUTE 47 EXPANSION 119,400 121,900 121,900 121,900 121,900 121,900 121,900 15-155-70-00-7799 CONTINGENCIES (38,685) - - - - - - - - 15-155-99-00-9923 TRANSFER TO CITY-WIDE CAPITAL 96,000 Expenditures 368,519 452,490 661,000 583,500 573,860 478,006 442,990 458,863 475,690 Surplus(Dericit) 104,685 234,779 350,000 (55,831) (119,313) (22,656) 12,360 (3,513) (20,340) Fund Balance 405,618 640,399 7769755 584,568 465,255 442,599 454,959 451,446 431,106 110.07% 141.53% - 117.51% 100.18% 81.07%, 92.59% 102.70% 98.38% 90.63% 23 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. Ending Fund Balance 25,151 231,558 (33,500) 240,955 185,635 165,166 152,677 150,101 161,177 1.75% 19.95% -2.82% 20.67% 1232% 11.27% 10.26% 9.92% 10.46% N $300 Fund Balance N $200 3 r $100 f $0 ($100) 24 FY2012 FY2013 FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Intergovernmental 1,478 - - - - - - - - Charges for Service 365,910 358,104 345,000 347,656 395,000 360,000 365,000 370,000 375,000 Investment Earnings 286 301 300 150 200 200 200 200 200 Reimbursements - 7,329 - 3,336 11,661 12,478 13,351 14,286 15,286 Miscellaneous 29,905 49,638 97,700 87,190 88,700 88,700 88,700 88,700 88,700 Other Financing Sources 1,1 19,500 951,890 732,710 736,710 955,886 983,992 1,009,002 1,038,056 1,073,173 Total Revenue 1,517,079 1,367,262 1,175,710 1,175,042 1,451,447 1,445,370 1,476,253 1,511,242 1,552,359 Expenditures Salaries 790,972 687,511 667,800 662,735 702,800 679,800 679,800 679,800 679,800 Benefits 124,085 109,114 109,730 109,730 296,477 310,769 330,721 352,664 376,801 Contractual Services 125,366 126,382 144,430 151,430 177,530 183,685 184,898 186,171 187,508 Supplies 245,396 237,847 267,250 241,750 329,960 291,585 293,323 295,183 297,174 Other Financing Uses 150,000 - - - - - - - - Total Expenditures 1,435,819 1,160,854 1,189,210 1,165,645 1,506,767 1,465,839 1,488,742 1,513,818 1,541,283 Surplus(Deficit) 81,260 206,408 (13,500) 9,397 (55,320) (20,469) (12,489) (2,576) 11,076 Ending Fund Balance 25,151 231,558 (33,500) 240,955 185,635 165,166 152,677 150,101 161,177 1.75% 19.95% -2.82% 20.67% 1232% 11.27% 10.26% 9.92% 10.46% N $300 Fund Balance N $200 3 r $100 f $0 ($100) 24 25 FY 2010 FY 2011 *F 2012 F"Y 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Parks and Recreation-79 79-000-41-00-4182 MISC INTERGOVERNMENTAL 1,478 - - - - - 79-000-44-00-4402 SPECIAL EVENTS - - 20,000 18,095 18,572 19,047 19.524 20,000 Previously included under Program bees 79-000-44-00-4403 CHILD DEVELOPMENT - 65,000- 58,810 60,357 61,905 63,452 65,000 Previously included under Program bees 79-000-44-00-4404 ATHLETICS AND FITNESS - - 125,000 113,095 116,071 119,048 122,024 125,000 Previously included under Program l eer 79-000-44-00-4440 PROGRAM FEES 180,230 189,890 180,000 Broken oul as indiculed abore-Beg.Proj 2012 79-000-44-00-4441 CONCESSION REVENUE 39,573 31,072 30.000 36,696 30,000 30,000 30,000 30.000 30.000 79-000-44-00-4442 GOLF OUTING REVENUE 8,659 - - - - - - - - 79-000-44-00-4443 HOMETOWN DAYS 137,448 137,142 135,000 100,960 175,000 135,000 135,000 135,000 135,000 79-000-45-00-4500 INVESTMENT EARNINGS 286 301 300 150 200 200 200 200 200 79-000-46-00-4670 REIMB-EMPLOYEE INS CONTRIBUTIONS - - 11,661 12,478 13,351 14,286 15.286 79-000-46-00-4671 REIMB-LIFE INSURANCE - - - - - - 79-000-46-00-4690 REIMB-MISCELLANEOUS - 7,329 - 3,336` - - - - - 79-000-48-00-4820 RENTAL INCOME 19,329 22,471 86,000 54,190 48,000 48,000 48,000 48,000 48,000 Geneva Kuvak-301 E.H.wh-unhe Y"eri_on Cell Tower Lease-Wheaton Woods 79-000-48-00-4825 PARK RENTALS - - - 25,000 25,000 25,000 25,000 25,000 25,000 79-000-48-00-4846 SPONSORSHIPS/130NATIONS 10,576 7,445 11,200 4,000 14,700 14,700 14,700 14,700 14,700 79-000-48-004850 MISCELLANEOUS INCOME - 19,722 500 4,000 1,000 1,000 1,000 1,000 1,000 79-000-49-00-4901 TRANSFER FROM GENERAL 1,119,500 951,890 �' 732,710 736,710 955,886 983,992 1,009,002 1,038,056 1,073,173 FY 2012 inchides add'I S44-/i-um adnvs.sions fax- Kagmg Wares Revenue 1,517,079 1,367,262 1,175,710 1,175,042 1,451,447 1,445,370 1,476,253 1,511,242 1,552,359 Parks Department 79-790-50-00-5010 SALARIES AND WAGES 383,500 355,091 370;000 370,000 410,000 396,405 396,405 396,405 396,405 79-790-50-00-5015 PART-TIME SALARIES 7,509 15,969 17,000 16,935 17,000 18,000 18,000 1 5,000 18,000 79-790-50-00-5020 OVERTIME 308 439 3,000 3,000 3.000 4,000 4,000 4.000 4,000 79-790-52-00-5212 RETIREMENT PLAN CONTRIBUTION 32,960 32,914 37,730 37,730 43,693 41,000 41,000 41,000 41,000 79-790-52-00-5214 FICA CONTRIBUTION 29,265 27,503 30,000 30,000 34,000 34,000 34,000 34.000 34,000 79-790-52-00-5216 GROUP HEALTH INSURANCE - - - 126,842 139,526 153 479 168,827 185.709 79-790-52-00-5222 GROUP LIFE INSURANCE - - 1,208 1,220 1,232 1,245 1,257 79-790-52-00-5223 DENTAL INSURANCE - - 9,179 10,097 11.107 12.217 13,439 79-790-52-00-5224 VISION INSURANCE - - - 1,104 1,214 1,336 1,469 1,616 79-790-54-00-5412 TRAINING&CONFERENCES 309 2,6010 - 2,6130 2,600 2,600 2,600 2.600 2,600 79-790-54-00-5415 TRAVEL AND LODGING - - 750 750 750 750 750 750 750 79-790-54-00-5440 TELECOMMUNICATIONS 3,085 1,802 3,780 3,780 3,780 3,780 3,780 3,780 3,780 79-790-54-00-5462 PROFESSIONAL SERVICES 865 3,323 4,500 4,500 4,500 4,500 4,500 4,500 4.500 79-790-54-00-5466 LEGAL SERVICES 4,582 1,749 4,000 4,000 4,000 4,000 4,000 4,000 4.000 79-790-54-00-5485 RENTAL&LEASE PURCHASE - 188 2,500 4500> 2,500 2,500 2,500 2,500 2,500 79-790-54-00-5495 OUTSIDE REPAIR AND MAINTENANCE - - 17,500 22,500 22,500 22,500 22,500 Broad weed control in parks 25 26 FY 2010 FY 2011 FY 2012 FY 2012 FV 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 79-790-56-00-5610 OFFICE SUPPLIES 70 152 300 300 300 300 300 300 300 79-790-56-00-5620 OPERATING SUPPLIES 20,372 11,232 22,500 22,560 22,500 22,500 22,500 22,500 22,500 79-790-56-00-5630 SMALL TOOLS&EQUIPMENT 1,889 1,785 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 AND MAINTENANCE 40,514 44,231 48,000 48,000 50,500 50,500 50,500 50,500 50,500 79-790-56-00-5695 GASOLINE - - - - 20,000 21,400 22,898 24.501 26,216 P'ormerlc budgeted under PW-S/reel Op.s Increase of 7%per unn m 528,943 500,718 �' 553,510 553,445 781,806 787,642 804,237 822,444 842,422 Recreation Department 79-795-50-00-5010 SALARIES AND WAGES 342,637 248.541 190,000 195,000 185.000 173,595 173.595 173,595 173.595 79-795-50-00-5015 PART-TIME SALARIES 13,482 12,708 25,000 20,000 25.000 25,000 25.000 25,000 25.000 79-795-50-00-5020 OVERTIME - 300 300 300 300 300 300 300 79-795-50-00-5045 CONCESSION WAGES 9,968 9,021 12,500 12,500 12.500 12,500 12.500 12,500 12.500 79-795-50-00-5046 PRE-SCHOOL WAGES 19,468 23,085 25,000 25,000 25,000 25,000 25,000 25,000 25,000 79-795-50-00-5052 INSTRUCTORS WAGES 14,100 22,657 " 25,000 20,000 25,000 25,000 25,000 25,000 25 000 79-795-52-00-5212 RETIREMENT PLAN CONTRIBUTION 31,675 24,798 22,000 22,000 19,884 18,730 18,730 18,730 18.730 79-795-52-00-5214 FICA CONTRIBUTION 30,185 23,899 20,000 20,000 16,000 16,000 16,000 16,000 16,000 79-79552-00-5216 GROUP HEALTH INSURANCE - - - 41,094 45.203 49,724 54,696 60.166 79-795-52-00-5222 GROUP LIFE INSURANCE 473 478 483 487 492 79-795-52-00-5223 DENTAL INSURANCE - 2,675 2,943 3,237 3,560 3,916 79-795-52-00-5224 VISION INSURANCE - - 325 358 393 433 476 79-795-54-00-5412 TRAINING&CONFERENCES 680 2,000 2,000 2,000 2,000 2,000 2,000 2,000 79-795-54-00-5415 TRAVEL AND LODGING - - 1,006 1,000 1,000 1000 1,000 1,000 1,000 79-795-54-00-5419 GOLF OUTING 6,001 - - - - - - - 79-795-54-00-5426 PUBLISHING&ADVERTISING 28,013 27,872 27,000 27,000 27,000 27,000 27,000 27,000 27,000 79-795-54-00-5440 TELECOMMUNICATIONS 4358 5,517 4,300 4,300, 4,300 4.300 4,300 4,300 4,300 79-795-54-00-5447 SCHOLARSHIPS 156 221 1,000 1,000 2,500 2,500 2,500 2,500 2,500 Expansion ol program in FY 2013 79-795-54-00-5452 POSTAGE&SHIPPING 7,391 7,006 8,000 51000 8,000 8,000 8,000 8,000 8,000 79-795-54-00-5462 PROFESSIONAL SERVICES 43,483 49,076 47,000 65,000 60,000 60,000 60,000 60,000 60,000 79-795-54-00-5480 UTILITIES 15,690 21,229 22,000 12,000 23,100 24,255 25,468 26.741 28,078 5%increase per annum 79-795-54-00-5485 RENTAL&LEASE PURCHASE 4,145 2,459 4,500 4,500 4,500 4,500 4,500 4,500 4,500 79-795-54-00-5490 DUES AND SUBSCRIPTIONS 1,061 482 1,500 1,500 1,500 1.500 1500 1,500 1.500 79-795-54-00-5495 OUTSIDE REPAIR AND MAINTENANCE 587 1,387 1,000 1,000 1,000 1,000 1,000 1,000 1,000 79-795-54-00-5496 PROGRAM REFUNDS 5,949 3,082 7,000 9,000 7,000 7,000 7,000 7,000 7,000 79-795-56-00-5602 HOMETOWN DAYS SUPPLIES 100,579 99,903 100,000 85,000 140,000 100,000 100.000 100,000 100,000 79-795-56-00-5606 PROGRAM SUPPLIES 41,176 47,154 55,000 45,000 55,000 55,000 55,000 55,000 55,000 79-795-56-00-5607 CONCESSION SUPPLIES 24,239 17,834 18,000 18,000 18,000 18,000 18,000 18,000 18,000 79-795-56-00-5610 OFFICE SUPPLIES 4,268 2,466 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-795-56-00-5620 OPERATING SUPPLIES 4,837 4,138 5,500 5,500 5,500 5,500 5,500 5,500 5,500 79-795-56-00-5630 SMALL TOOLS&EQUIPMENT 510 283 2,000 2,000 2,000 2,000 2,000 2,000 2.000 79-795-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 98 2,600 500 1,500 500 500 500 500 500 79-795-56-00-5640 REPAIR AND MAINTENANCE 825 412 2,060 2,000 2,000 2,000 2,000 2,000 2,000 79-795-56-00-5645 BOOKS AND PUBLICATIONS 104 - 100 100 100 100 100 100 100 79-795-56-00-5690 SUPPLIES-GRANT REIMBURSABLE 45 500 500 500 500 500 500 500 26 FY 2010 FY 2011 FY 2012 AY 2612 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 79-795-99-00-9901 TRANSFER TO GENERAL 150,000 - - - 906,876 660,136 635,700 612,200. 724,961 678,197 684,505 691,374 698,861 Expenditures 1,435,819 1,160,854 1,189,210 1,165,645 1,506,767 1,465,839 1,488,742 1,513,818 1,541,283 Surplus(Deficit) 81,260 206,408 (13,500) 9,397 (55,320) (20,469) (12,489) (2,576) 11,076 Fund Balance 25,151 231,558 (33,500) 240,955 185,635 165,166 152,677 150,101 161,177 1.75% 19.95% -1.82% 20.67% 12.32% 11.27Y, 10.26% 9.92Y, 10.46% 27 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. Ending Fund Balance (603,425) (388,625) (312,230) (269,209) (172,534) (219,034) (552,884) (192,884) (182,884) Fund Balance 0 ($200) 0 ($400) ($600) ($800) 28 FY2012 FY2013 FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Intergovernmental 103,337 42,285 400,000 400,000 400,000 96,000 - 400,000 - Land Cash Contributions 165,810 432,354 20,500 20,500 20,500 70,500 23,000 23,000 23,000 Total Revenue 269,147 474,639 420,500 420,500 420,500 166,500 23,000 423,000 23,000 Expenditures Capital Outlay 246,608 199,390 281,000 281,000 323,825 213,000 356,850 63,000 13,000 Other Financing Uses 60,449 60,449 20,084 20,084 - - - - - Total Expenditures 307,057 259,839 301,084 301,084 323,825 213,000 356,850 63,000 13,000 Surplus(Deficit) (37,910) 214,800 119,416 119,416 96,675 (46,500) (333,850) 360,000 10,000 Ending Fund Balance (603,425) (388,625) (312,230) (269,209) (172,534) (219,034) (552,884) (192,884) (182,884) Fund Balance 0 ($200) 0 ($400) ($600) ($800) 28 29 FY 2010 FY 2011 FV 2012 ` FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget`, Projected + Adopted Projected Projected Projected Projected Land Cash-72 72-000-41-00-4170 STATE GRANTS 103,337 42,285 - 72-000-41-00-4171 OSLAD GRANT-PRAIRIE MEADOWS - - 400,000 400,000 - 72-000-41-00-4173 OSLAD GRANT-RAINTREE - 400,000 - 72-000-41-00-4174 RTP GRANT-HOPKINS PARK - 96,000 - 72-000-41-00-4175 OSLAD GRANT-RI VE_RFRONT GRANT - - - 400,000 72-000-47-00-4702 WHISPERING MEADOWS(K HILL) 3,383 312,655 - - - - - - 72-000-47-00-4703 AUTUMN CREEK 62.427 18,460 20,000 20,000 20,000 20,000 20,000 20,000 20,000 72-000-47-00-4704 BLACKBERRY WOODS - 568 500 500 500 500 500 500 500 72-000-47-00-4705 BRISTOL,BAY 100,000 100,000 - - - - - - - 72-000-47-00-4706 CALEDONIA - - 2,500 2,500 2,500 72-000-47-00-4707 RIVER'S EDGE 671 72-000-49-00-4921 TRANSFER FROM PARK&REC CAPITAL 50,000 Re inlrec Park B reimbursement - - - Revenue 269,147 474,639 420,500 420,500 420,500 166,500 23,000 423,000 23,000 72-720-60-00-6029 CALEDONIA - - - - - - - - - 72-720-60-00-6031 HEARTLAND CIRCLE 22,408 - - - - - - - - 72-720-60-00-6032 MOSIER HOLDING COSTS 10,000 10,000 11,000 11,000 12,000 13,000 13,000 13,000 13,000 72-720-60-00-6034 WHISPERING MEADOWS(K HILL) 196,015 - - - - - - - - 72-720-60-00-6036 RAINTREE VILLAGE - 88,175 270,000 270,000 191,825 72-720-60-00-6037 GRANDE RESERVE BIKE TRAIL 2,650 - - - - 72-720-60-00-6038 WHEATON WOODS NATURE TRAIL 15,535 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 HOPKINS PARK - 120,000 - - 72-720-60-00-6045 RIVERFRONT PARK - 200,000 200,000 - 72-720-60-00-6046 GRANDE RESERVE PARKA - - 50,000 Basketball courts and sidewalk corner 72-720-60-00-6047 GRANDE RESERVE PARK B - - - 143,850 - Original estimate w 1(/%increase Jin inhaiion 72-720-99-00-9901 TRANSFER TO GENERAL 60,449 60,449 20,084 20,084 - General hind iransfer eliminated in F)'2013 Expenditures 307,057 259,839 301,084 301,084 323,825 213,000 356,850 63,000 13,000 Surplus(Deficit) (37,910) 214,800 119,416 119,416 96,675 (46,500) (333,850) 360,000 10,000 Fund Balance (603,425) (388,625) x (312,230) (269,209) (172,534) (219,034) (552,884) (192,884) (182,884) -196.52% -149.56% - -103.70% -89.41% -53.28% -102.83% -154.93% -;116.17% -1406.80% 29 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. Ending Fund Balance 423,351 569,790 - - - - - - $600 , Fund Balance $400 1 L ~ $200 1 $0 30 FY2012 FY2013 FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Taxes 216,677 228,346 259,052 Investment Earnings 45 13 275 Total Revenue 216,722 228,359 - 259,327 - - - - Expenditures Contractual Services 1,220 1,989 - 3,565 Supplies - - - 11,236 Debt Service 77,793 79,933 - 76,783 Other Financing Uses - - - 737,533 Total Expenditures 79,013 81,922 - 829,117 - - - - - Surplus(Deficit) 137,709 146,437 - (569,790) Ending Fund Balance 423,351 569,790 - - - - - - $600 , Fund Balance $400 1 L ~ $200 1 $0 30 31 FY 2010 FY 2011 FY 2012 n FY 2012 FY 2013 FY 2014 FY 2015 FV 2016 FY 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Fox Industrial TIF 85-000-40-00-4085 PROPERTY TAXES-FOX INDUSTRIAL TIE 216,677 228,346 259,052 85-000-45-004500 INVESTMENT EARNINGS 45 13 = 275 Revenue 216,722 228,359 259,327 85-850-54-00-5420 ADMINISTRATIVE FEES 1,220 1,989 3,565 85-850-56-00-5619 SIGNS - - 11,236 Debt Service-2002 Bond 85-850-98-00-8000 PRINCIPLE PAYMENT 65,000 70,000 70,000 85-850-98-00-8050 INTEREST PAYMENT 12,793 9,933 6,783 85-850-99-00-9901 TRANSFER TO GENERAL - - - 85-850-99-00-9942 TRANSFER TO DEBT SERVICE 78,777 2002 Dchi Service payahle in hY 2013 85-850-99-00-9999 TIE LIQUIDATION - 658,756 Expenditures 79,013 81,922 829,117 - Surplus(Deficit) 137,709 146,437 - (569,790) Fund Balance 423,351 569,790 - - 31 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. Surplus(Deficit) (294,394) (299,210) (297,293) (300,730) (299,543) (297,613) (300,398) (297,598) (299,598) Ending Fund Balance 2,477,758 2,178,550 19883,380 1,877,820 1,578,277 1,280,664 980,266 682,668 383,070 „ $3,000 Fund Balance N $2,000 t $1,000 $o i 32 FY 2012 FY2013 FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Taxes 6,250 6,372 6,250 4,188 4,500 4,500 4,500 4,500 4,500 Investment Earnings 8,223 3,134 4,000 2,600 2,000 2,000 2,000 2,000 2,000 Total Revenue 14,473 9,506 10,250 6,788 6,500 6,500 6,500 6,500 6,500 Expenditures Contractual Services 999 1,623 1,400 1,375 1,375 1,375 1,375 1,375 1,375 Debt Service 307,868 307,093 306,143 306,143 304,668 302,738 305,523 302,723 304,723 Total Expenditures 308,867 308,716 307,543 307,518 306,043 304,113 306,898 304,098 306,098 Surplus(Deficit) (294,394) (299,210) (297,293) (300,730) (299,543) (297,613) (300,398) (297,598) (299,598) Ending Fund Balance 2,477,758 2,178,550 19883,380 1,877,820 1,578,277 1,280,664 980,266 682,668 383,070 „ $3,000 Fund Balance N $2,000 t $1,000 $o i 32 Account Description Countryside TIF 87-000-40-00-4087 PROPERTY TAXES-COUNTRYSIDE TIF 87-000-45-004500 INVESTMENT EARNINGS 87-870-54-00-5420 ADMINISTRATIVE FEES *V i012 Legal&1YP'reparruJg Costs 87-870-54-00-5498 PAYING AGENT FEES Debt Service-2005 Bond FY 2016 87-870-80-00-8000 PRINCIPLE PAYMENT 87-870-80-00-8050 INTEREST PAYMENT Revenue Expenditures Surplus(Deficit) Fund Balance FY 2010 FY 2011 *V i012 FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Actual Actual Budget Projected Adopted Projected Projected Projected Projected 6,250 6,372 6,250 4,188 4,500 4,500 4,500 4,500 4500 8,223 3,134 4,000 2,600 2,000 2,000 2,000 2,000 2,000 14,473 9,506 10,250 6,788 6,500 6,500 6,500 6,500 6,500 999 1,248 1,000 1,000 1,000 1,000 1,000 1,000 1,000 - 375 400 375 375 375 375 375 375 165,000 170,000 175,000 175,000 180,000 185,000 195,000 200,000 210.000 142,868 137,093 131,143 131,143 124,668 11T738 110,523 102.723 94,723 308,867 308,716 307,543 307,518 306,043 304,113 306,898 304,098 306,098 (294,394) (299,210) (297,293) (300,730) (299,543) (297,613) (300,398) (297,598) (299,598) 2,477,758 2,178,550 1,883,380 1,877,820 1,578,277 1,280,664 980,266 682,668 383,070 802.21%, "115.68% 612.40% 610.64% 515.711% 421.11% 319.41Y, 224.49% 125.15% 33 Downtown TIF Fund(88) The Downtown TIF was created in 2006,in order to finance a mixed use development in the downtown area Ending Fund Balance 136,294 209,760 (238,134) 236,217 264,867 293,517 322,167 350,817 379,467 „ $600 Fund Balance $aoo o $200 r $0 ($200) ($400) 34 FY2012 FY2013 FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Taxes 88,550 75,362 88,550 67,807 70,000 70,000 70,000 70,000 70,000 Investment Earnings - - - 150 150 150 150 150 150 Total Revenue 88,550 75,362 88,550 67,957 70,150 70,150 70,150 70,150 70,150 Expenditures Contractual Services 1,832 1,896 11,500 11,500 11,500 11,500 11,500 11,500 11,500 Capital Outlay - - 525,340 30,000 30,000 30,000 30,000 30,000 30,000 Total Expenditures 1,832 1,896 536,840 41,500 41,500 41,500 41,500 41,500 41,500 Surplus(Deficit) 86,718 73,466 (448,290) 26,457 28,650 28,650 28,650 28,650 28,650 Ending Fund Balance 136,294 209,760 (238,134) 236,217 264,867 293,517 322,167 350,817 379,467 „ $600 Fund Balance $aoo o $200 r $0 ($200) ($400) 34 35 FY 2010 FY 2011 FY 2012 FY 21!12 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual )budget Projected Adopted Projected Projected Projected Projected Downtown TIF 88-000-40-00-4088 PROPERTY TAXES-DOWNTOWN TIE 88,550 75,362 88,550 67,807 70,000 70,000 70,000 70,000 70,000 88-000-45-004500 INVESTMENT EARNINGS - I50 150 150 150 150 150 Revenue 88,550 75,362 88,550 67,957 70,150 70,150 70,150 70,150 70,150 88-880-54-00-5420 ADMINISTRATIVE FEES 1,832 1,896 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,11ing lees&771,reporting GUS /.P 88-880-54-00-5466 LEGAL SERVICES - - 10,000 10,000 10,000 10,000 10,000 10,000 10,000 88-880-60-00-6000 PROJECT COSTS 10,000 10,000 10,000 10,000 10.000 10.000 10.000 88-880-60-00-6079 ROUTE 47 EXPANSION - 515,340 20,000 20,000 20,000 20,000 20,000 20,000 Expenditures 1,832 1,896 536,840 41,500 41,500 41,500 41,500 41,500 41,500 Surplus(Deficit) 86,718 73,466 (448,290) 26,457 28,650 28,650 28,650 28,650 28,650 Fund Balance 136,294 209,760 (238,134) 2369217 264,867 293,517 322,167 350,817 379,467 -439.63% 11063.29% -44.36% 569.20% 638.231Y, `07.27% 776.31% 845.34% 914.38% 35 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. Ending Fund Balance 2,226 17,942 18,316 17,433 16,719 16,384 16,362 16,798 17,738 $20 Fund Balance 0 $15 r $10 $5 $0 W FY2012 FY2013 FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Taxes 19,897 19,894 3,786 3,786 3,786 4,165 4,581 5,039 5,543 Investment Earnings - - - 5 - - - - - Total Revenue 19,897 19,894 3,786 3,791 3,786 4,165 4,581 5,039 5,543 Expenditures Contractual Services 4,011 4,178 3,804 4,300 4,500 4,500 4,603 4,603 4,603 Total Expenditures 4,011 4,178 3,804 4,300 4,500 4,500 4,603 4,603 4,603 Surplus(Deficit) 15,886 15,716 (18) (509) (714) (335) (22) 436 940 Ending Fund Balance 2,226 17,942 18,316 17,433 16,719 16,384 16,362 16,798 17,738 $20 Fund Balance 0 $15 r $10 $5 $0 W 37 FY 2010 FY 2011 Pi 2012 MY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account 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,897 19,894 3,786 3,786 3,786 4,165 4,581 5,039 5,543 10%increase beginning in 1,)'2014 11-000-45-004500 INVESTMENT EARNINGS - 5 - - Revenue 19,897 19,894 3,786 3,791 3,786 4,165 4,581 5,039 5,543 11-111-54-00-5495 OUTSIDE REPAIR AND MAINTENANCE 4,011 4,178 3,804 4,300 4,500 4.500 4,603 4.603 4,603 Expenditures 4,011 4,178 3,804 4,300 4,500 4,500 4,603 4,603 4,603 Surplus(Deficit) 15,886 15,716 (18) (509) (714) (335) (22) 436 940 Fund Balance 2,226 17,942 18,316 17,433 16,719 16,384 16,362 16,798 17,738 55.50% 429.44Y, 481.49% 405.42% 371.53% 364.09% 355.46% 36494"/„ 385.30/ 37 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. FY2012 FY2013 FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Taxes 13,871 13,871 7,530 7,530 7,531 8,284 9,113 10,024 11,026 Investment Earnings - - 10 - - - - - Total Revenue 13,871 13,871 7,530 7,540 7,531 8,284 9,113 10,024 11,026 Expenditures Contractual Services 8,782 8,136 9,078 7,000 9,986 10,985 10,985 10,985 10,985 Total Expenditures 8,782 8,136 9,078 7,000 9,986 10,985 10,985 10,985 10,985 Surplus(Deficit) 5,089 5,735 (1,548) 540 (2,455) (2,701) (1,872) (961) 41 Ending Fund Balance 6,188 11,922 10,980 12,462 10,007 7,306 5,434 4,473 4,514 $15 $10 0 r $s $0 Fund Balance 38 39 FY 2010 FY 2011 P`Y 2012 FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Sunflower SSA-12 12-000-40-004012 PROPERTY TAXES-SUNFLOWER SSA 13,871 13,871 7,530 7,530- 8,284 9,113 10,024 11,026 10%increase staring hT 2014 fm•pond mainlenance 12-000-45-00-4500 INVESTMENT EARNINGS - 10 Revenue 13,871 13,871 7,530 7,540 7,531 8,284 9,113 10,024 11,026 12-112-54-00-5495 OUTSIDE REPAIR AND MAINTENANCE 8,782 8,136 '' 9,078 7,000 9,986 10.985 10,985 10,985 10,985 Expenditures 8,782 8,136 9,078 7,000 9,986 10,985 10,985 10,985 10,985 Surplus(Deficit) 5,089 5,735 (1,548) 540 (2,455) (2,701) (1,872) (961) 41 Fund Balance 6,188 11,922 10,980 12,462 10,007 7,306 5,434 4,473 4,514 70.4/,% 1-/0'.53% 120.95% 178.03% 100.21% 66.51% 49.4-Y, 4072% 41.09% 39 Debt Service Fund(42) The Debt Service Fund accumulates monies for payment of the 2004C and 2005A bonds. These bonds were issued to finance road improvement projects. Property taxes are levied except for the 2004C bond,which utilizes a General Fund transfer of sales tax to pay its annual debt service requirement. Surplus(Deficit) 7,628 1,025 (750) 78,498 (78,226) 925 925 (4,978) 1,325 Ending Fund Balance 7,628 8,653 7,778 87,151 8,925 9,850 10,775 5,797 7,122 $100 Fund Balance $80 c $60 $40 $20 $0 40 FY2012 FY2013 FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Taxes - - 324,179 323,350 326,379 328,179 329,579 320,000 250,000 Licenses&Permits 7,628 1,025 - 1,000 1,000 1,000 1,000 1,000 1,000 Investment Earnings - - - 300 300 300 300 300 300 Other Financing Sources 482,294 429,404 103,740 182,517 99,465 - - 4,676 86,579 Total Revenue 489,922 430,429 427,919 507,167 427,144 329,479 330,879 325,976 337,879 Expenditures Contractual Services - - 750 750 963 375 375 375 375 Debt Service 482,294 429,404 427,919 427,919 504,407 328,179 329,579 330,579 336,179 Total Expenditures 482,294 429,404 428,669 428,669 505,370 328,554 329,954 330,954 336,554 Surplus(Deficit) 7,628 1,025 (750) 78,498 (78,226) 925 925 (4,978) 1,325 Ending Fund Balance 7,628 8,653 7,778 87,151 8,925 9,850 10,775 5,797 7,122 $100 Fund Balance $80 c $60 $40 $20 $0 40 41 FY 2010 FY 2011 IN 2812 FY 2011 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Debt Service-42 42-000-40-00-4006 PROPERTY TAXES-2005A BOND - 324,179 323,350 326,379 328,179 329,579 320,000 250,000 42-000-42-00-4208 RECAPTURE FEES-WATER&SEWER 7,628 1,025 - 1,000 1,000 1,000 1,000 1.000 1.000 42-000-45-004500 INVESTMENT EARNINGS - - - 300 300 300 300 300 300 42-000-49-00-4901 TRANSFER FROM GENERAL 425,094 429,404 103,740 103,740 99,465 - - 4,676 86.579 42-000-49-00-4916 TRANSFER FROM MUNICIPAL BUILDING 57,200 - - - - 42-000-49-00-4985 TRANSFER FROM FOX INDUSTRIAL TIE 78,777 - - - 1•br Series 2002 D S&paying ageni lee Revenue 489,922 430,429 427,919 "7,167 427,144 329,479 330,879 325,976 337,879 42-420-54-00-5498 PAYING AGENT FEES - - 750 750 963 375 375 375 375 Increase clue to 2002 pgvmg ages!fee PY 2013 2002.A Refunding 42420-80-00-8000 PRINCIPLE PAYMENT 55,000 - - - - - - - 42420-80-00-8050 INTEREST PAYMENT 2,200 - - - - 2004C Bond 42-420-81-00-8000 PRINCIPLE PAYMENT 90.000 95,00 95,000 95,000 95,000 42-420-81-00-8050 INTEREST PAYMENT 16,515 12,825 8,740 8,740 4,465 - - - - 2005A Bond 42-420-82-00-8000 PRINCIPLE PAYMENT 17500 185,000 195,000 195,000 205,000 215,000 225 000 235,000 250,000 42-420-82-00-8050 INTEREST PAYMENT 143,579 136,579 129,179 129,179 121,379 113,179 104,579 95,579 86,179 2002 Fox Industrial TIF Bond 42-420-98-00-8000 PRINCIPLE PAYMENT _ - 75.000 - - - - 42-420-98-00-8050 INTEREST PAYMENT 3,563 2002 Debi semce pavuhle in FY 2013 from bier Indusiral"l'1,' Expenditures 482,294 429,404 428,669 428,669 505,370 328,554 329,954 330,954 336,554 Surplus(Deficit) 7,628 1,025 (750) 78,498 (78,226) 925 925 (4,978) 1,325 Fund Balance 7,628 8,653 7,778 87,151 8,925 9,850 10,775 5,797 7,122 1.58% 2.02% 1.81% 20.33% 1."7'% 3.00% 3.2'% 1.75% 2.12% 41 Municipal Building Fund (16) The Municipal Building Fund is used to maintain existing City owned buildings and to fund land acquisition,design and construction of new buildings Ending Fund Balance (607,724) (587,024) (580,474) (581,024) (575,774) (570,524) (565,274) (560,024) (554,774) Fund Balance FY2012 ($520) FY2013 ($540) 0 ($560) FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Licenses&Permits 9,750 20,700 5,250 6,000 5,250 5,250 5,250 5,250 5,250 Total Revenue 9,750 20,700 5,250 6,000 5,250 5,250 5,250 5,250 5,250 Expenditures Contractual Services - - - - - - - - - Other Financing Uses 57,200 Total Expenditures 57,200 - - - - - - - - Surplus(Deficit) (47,450) 20,700 5,250 6,000 5,250 5,250 5,250 5,250 5,250 Ending Fund Balance (607,724) (587,024) (580,474) (581,024) (575,774) (570,524) (565,274) (560,024) (554,774) 42 Fund Balance ($520) ($540) 0 ($560) ($580) ($600) ($620) 42 43 FY 2010 FY 2011 FY 2012 FY 2012 FY 2013 FY 2014 FY 2015 FA'2016 FY 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Municipal Building-16 16-000-42-00-4214 DEVELOPMENT FEES 9,750 20,700 5.250 6,000` 5,250 5.250 5,250 5.250 5.250 5150 Permit-35 Permils 16-000-42-004216 BUILD PROGRAM PERMIT Revenue 9,750 20,700 5,250 6,000 5,250 5,250 5,250 5,250 5,250 16-160-54-00-5405 BUILD PROGRAM - - - - - - - - I6-160-99-00-9942 TRANSFER TO DEBT SERVICE 57,200 Expenditures 57,200 - - - - - - Surplus(Deficit) (47,450) 20,700 5,250 6,000 5,250 5,2.50 5,250 5,250 5,250 Fund Balance (607,724) (587,024) (580,474) (581,024) (575,774) (570,524) (565,274) (560,024) (554,774) 43 Parks and Recreation Capital Fund(22) The Park and Recreation Capital Fund derives its revenue from monies collected from building permits. The revenue is used to purchase equipment essential in the maintenance of park land and open space. Surplus(Deficit) 41,100 (15,409) (120,670) (19,898) (9,000) 1,000 1,000 1,000 1,000 Ending Fund Balance 66,852 51,443 (76,369) 31,545 22,545 23,545 24,545 25,545 26,545 N $100 , Fund Balance 1 N $50 7 r $0 r ($50) ($100) 44 FY2012 FY2013 FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Licenses&Permits 3,300 1,650 1,750 1,750 3,250 3,250 3,250 3,250 3,250 Investment Earnings - 99 80 250 250 250 250 250 250 Reimbursements - 7,500 - 10,702 40,000 50,000 - - - Miscellaneous 48,573 - 1,000 900 - - - - - Total Revenue 51,873 9,249 2,830 13,602 43,500 53,500 3,500 3,500 3,500 Expenditures Capital Outlay 10,773 24,658 120,000 30,000 50,000 - - - - Other Financing Uses - - 3,500 3,500 2,500 52,500 2,500 2,500 2,500 Total Expenditures 10,773 24,658 123,500 33,500 52,500 52,500 2,500 2,500 2,500 Surplus(Deficit) 41,100 (15,409) (120,670) (19,898) (9,000) 1,000 1,000 1,000 1,000 Ending Fund Balance 66,852 51,443 (76,369) 31,545 22,545 23,545 24,545 25,545 26,545 N $100 , Fund Balance 1 N $50 7 r $0 r ($50) ($100) 44 Account Description Parks and Recreation Capital-22 22-000-42-00-4215 PARKS CAPITAL FEES 22-222-60-00-6042 S50 Unit-65 New Housing Slarls 22-000-45-004500 INVESTMENT EARNINGS 22-000-46-00-4690 REIMB-MISCELLANEOUS 22-222-99-00-9972 Reimhm-.cemenl,r from Ramiree Escrow Accl 22-000-48-004845 DONATIONS 22-000-48-0014880 SALE OF FIXED ASSETS Projected Revenue 22-222-60-00-6035 RAINTREE PARK 22-222-60-00-6042 BASEBALL FIELD CONSTRUCTION 22-222-60-00-6060 EQUIPMENT FY 2015 Mower tor Bristol Buy in 1,)'2013 22-222-99-00-9972 7X4NS1•AJ?TOLANPC'A.SH Actual Rainlree Park B Reimhurcement 22-222-99-00-9921 TRANSFER TO PUBLIC WORKS CAPITAL Projected Park&Rec portion of 185 lVolfS/Building Projected Expenditures 3,300 Surplus(Deficit) 1,756 Fund Balance FY 2010 FY 2011 FY 2012 FY 2012 ' FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Actual Actual Budget Projected Adopted Projected Projected Projected Projected 3,300 1,650 1,756 1,750 3,250 3,250 3,250 3,250 3,250 - 99 80 250 250 250 250 250 250 7,500 10,702 40,000 50,000 - - - 48,573 - - - - 1,000 900 51,873 9,249 2,830 13,602 43,500 53,500 3,500 3,500 3,500 1,700 9,002 120,000 30,000 10,000 - - - - - 15.656 - - - 9,073 - 40,000 - - - _ _. . - 50.000 - - - - - 3,500 3,500 2,500 2.500 2,500 2.500 2,500 10,773 24,658 123,500 33,500 52,500 52,500 2,500 2,500 2,500 41,100 (15,409) (120,670) (19,898) (9,000) 1,0(10 1,000 1,000 1,000 66,852 51,443 (76,369) 31,545 22,545 23,545 24,545 25,545 26,545 620.55% 208.63% -61.84% 94.16% 42.94% 44.85% 981.80% 1021.80% 1061.x0% 45 Police Capital Fund(20) The Police Capital Fund derives its revenue from monies collected from permits and fines. The revenue is used to purchase vehicles and equipment for use in the operations of the police department. Ending Fund Balance 210,284 194,947 134,647 135,537 104,737 90,937 77,137 63,337 49,537 N $250 Fund Balance $Zoo c $150 r $100 $50 $0 46 FY2012 FY2013 FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Licenses&Permits 26,563 16,417 16,500 12,000 16,500 16,500 16,500 16,500 16,500 Fines&Forfeits 10,064 12,612 5,000 9,650 11,650 11,650 11,650 11,650 11,650 Investment Earnings - - - 40 50 50 50 50 50 Miscellaneous 5,170 8,900 - 13,900 1,000 1,000 1,000 1,000 1,000 Total Revenue 41,797 37,929 21,500 35,590 29,200 29,200 29,200 29,200 29,200 Expenditures Contractual Services 3,187 9,493 11,500 12,500 12,500 12,500 12,500 12,500 12,500 Supplies 910 - 2,500 2,500 2,500 2,500 2,500 2,500 2,500 Capital Outlay 3,266 43,772 40,000 80,000 45,000 28,000 28,000 28,000 28,000 Total Expenditures 7,363 53,265 54,000 95,000 60,000 43,000 43,000 43,000 43,000 Surplus(Deficit) 34,434 (15,336) (32,500) (59,410) (30,800) (13,800) (13,800) (13,800) (13,800) Ending Fund Balance 210,284 194,947 134,647 135,537 104,737 90,937 77,137 63,337 49,537 N $250 Fund Balance $Zoo c $150 r $100 $50 $0 46 47 FY 2010 FY 2011 FY 2012 FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Police Capital-20 20-000-42-00-4214 DEVELOPMENT FEES 19,950 16,009 10,500 12,000 10,500 10,500 10,500 10,500 10,500 20-000-42-004217 WEATHER WARNING SIREN FEES 6.613 408 6.000 600 6.000 6,000 6,000 6,000 20-000-43-00-4315 DUI FINES 4,381 6,462 4,000 6,000 6,000 6,000 6,000 6,000 20-000-43-00-4316 ELECTRONIC CITATION FEE - 122 650< 650 650 650 650 650 20-000-43-004340 SEIZED VEHICLE PROCEEDS 5,683 6,028 5,000 5,000 5,000 5,000 5,000 500 5,000 20-000-45-00-4500 INVESTMENT EARNINGS - - - 40 50 50 50 50 50 20-000-48-00-4850 MISCELLANEOUS INCOME 1,070 - - - - - - - - 20-000-48-00-4880 SALE OF FIXED ASSETS 4,100 8,900 .` 13,900' 1,000 1,000 1,000 1,000 1,000 Revenue 41,797 37,929 21,500 35,590 29,200 29,200 29,200 29,200 29,200 20-200-54-00-5462 PROFESSIONAL SERVICES 3,187 3,060 1,500 2,500 2,500 2,500 2,500 2,500 2500 20-200-54-00-5495 OUTSIDE REPAIR AND MAINTENANCE - 6,433 10,000 10,000 10.000 10,000 10,000 10,000 10,000 20-200-56-00-5620 OPERATING SUPPLIES - - 2,500 2,500 2,500 2,500 2,500 2,500 2,500 20-200-56-00-5621 SMALL TOOLS&EQUIPMENT 910 - - - - - - - - 20-200-60-00-6060 EQUIPMENT 3,266 1,462 20,000 60,000 20,000 3,000 3,000 3,000 3,000 SI5k1in•neu radios dice in narrmi bonding in 1,T2013 20-200-60-00-6070 VEHICLES - 42,310 20,000 20,000 25,000 25,000 25,000 25.000 25,000 One new squat(cur per fiscal veer Expenditures 7,363 53,265 54,000 95,000 60,000 43,000 43,000 43,000 43,000 Surplus(Deficit) 34,434 (15,336) (32,500) (59,410) (30,800) (13,800) (13,800) (13,800) (13,800) Fund Balance 210,284 194,947 134,647 135,537 104,737 90,937 77,137 63,337 49,537 2855.96/ 365.99% 249.35% 142.67% 174.56'% 211.48/ 179.39'% 147.30% 115.20% 47 Public Works Capital Fund(21) The Public Works Capital Fund derives its revenue from monies collected from permits and fines. The revenue is used to purchase capital items such as vehicles,equipment and property. Ending Fund Balance 157,807 108,743 45,542 51,136 (65,159) (137,454) (209,749) (251,044) (292,339) $200 Fund Balance N c $100 m $0 F ($100) ($200) ($300) ($400) 48 FY2012 FY2013 FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Licenses&Permits 47,450 25,100 24,500 25,000 31,000 31,000 31,000 31,000 31,000 Charges for Service - 4,897 7,900 6,468 20,000 20,000 20,000 20,000 20,000 Investment Earnings - - - 20 - - - - - Miscellaneous 558 7,283 - - - - - - - Other Financing Sources - - 3,500 3,500 2,500 2,500 2,500 2,500 2,500 Total Revenue 48,008 37,280 35,900 34,988 53,500 53,500 53,500 53,500 53,500 Expenditures Contractual Services 4,000 49 6,300 6,300 10,500 11,500 11,500 10,500 10,500 Supplies - - 2,000 2,000 2,000 2,000 2,000 2,000 2,000 Capital Outlay - 4,000 2,000 2,000 75,000 30,000 30,000 - - Debt Service 82,295 82,295 82,295 82,295 82,295 82,295 82,295 82,295 82,295 Total Expenditures 86,295 86,344 92,595 92,595 169,795 125,795 125,795 94,795 94,795 Surplus(Deficit) (38,287) (49,064) (56,695) (57,607) (116,295) (72,295) (72,295) (41,295) (41,295) Ending Fund Balance 157,807 108,743 45,542 51,136 (65,159) (137,454) (209,749) (251,044) (292,339) $200 Fund Balance N c $100 m $0 F ($100) ($200) ($300) ($400) 48 49 FY 2010 FY 2011 �FY 2012 FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Public Works Capital-21 21-000-42-00-4213 ENGINEERING CAPITAL FEE - - - - 6,500 6,500 6,500 6500 6,500 Moved from CW Capital in FY 2013 21-000-42-00-4214 DEVELOPMENT FEES 47,450 25,100 24,500 25,000 24,500 24,500 24,500 24,500 24,500 5700 Unil-35 New Housing Starts 21-000-42-004216 BUILD PROGRAM PERMIT - - - - - - - - 21-000-44-00-4418 MOWING INCOME 4,897 7,900 6,468 20,000 20,000 20,000 20,000 20,000 Increased mowing and liens 21-000-45-00-4500 INVESTMENT EARNINGS - - - 20 - - - - - 21-000-48-00-4850 MISCELLANEOUS INCOME 558 7,283 - - - - - - - 21-000-49-00-4922 TRANSFER FROM PARK&REC CAPITAL - - 3,500 3,500 2,500 2,500 2,500 2,500 2,500 Park&Rec purlion of 185 Wolf Sireel Revenue 48,008 37,280 35,900 34,988 53,500 53,500 53,500 53,500 53,500 21-211-54-00-5405 BUILD PROGRAM - - - - - - - 21-211-54-00-5448 FILING FEES 49 - 2,300 6,000 6,000 6,000 6,000 6,000 Increased lien coa7.v aeeocialed widr movi ing increavec 21-211-54-00-5462 PROFESSIONAL SERVICES - 1,800 - 1.000 1,000 - - 21-211-54-00-5485 RENTAL&LEASE PURCHASE 4,000 4,500 4,000 4,500 4,500 4,500 4,500 4,500 21-211-56-00-5620 OPERATING SUPPLIES - - 2,000 2,000 2,000 2,000 2,000 2,000 2000, 21-211-60-00-6060 EQUIPMENT 4,000 2,000 2,000 75,000 - - - - Replucemenl iracior cmd mower 21-211-60-00-6070 VEHICLES - - - - - 30,000 30,000 - - Public Works Building-185 Wolf Street 21-211-92-00-8000 PRINCIPLE PAYMENT 24,937 26,544 28,254 28,254 30,074 32,012 32,012 32,012 32,012 21-211-92-00-8050 INTEREST PAYMENT 57,358 55,751 54,041 54,041 52,221 50,283 50,283 50,283 50,283 Expenditures 86,295 86,344 92,595 92,595 169,795 125,795 125,795 94,795 94,795 Surplus(Deficit) (38,287) (49,064) (56,695) (57,607) (116,295) (72,295) (72,295) (41,295) (41,295) Fund Balance 157,807 108,743 45,542 51,136 (65,159) (137,454) (209,749) (251,044) (292,339) 182.8"% 125.94% 49.18% 55.23% -38.38% -109.27% -166.74% -264.83% -30N.39% 49 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 Ending Fund Balance (18,378) 652 51,537 69,268 332,500 332,500 - - N $400 Fund Balance m $300 c $200 r $100 $0 ($100) 50 FY2012 FY2013 FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Intergovernmental - 64,000 231,000 - 231,000 - - - 178,700 Licenses&Permits 20,200 25,100 60,600 63,100 53,400 53,400 53,400 53,400 53,400 Investment Earnings - 19 - 85 - - - - - Reimbursements 54,600 1,200 9,578 - Miscellaneous - - - - - - 4,500,000 - - Other Financing Sources 100,000 231,484 125,000 125,000 1,019,332 352,500 406,943 846,043 646,943 Total Revenue 174,800 321,803 416,600 197,763 1,303,732 405,900 4,960,343 899,443 879,043 Expenditures Contractual Services - 5,740 - - 100,000 - - - - Capital Outlay - 172,033 235,000 4,147 940,500 305,900 4,846,900 453,500 433,100 Debt Service 100,000 125,000 125,000 125,000 - 100,000 445,943 445,943 445,943 Total Expenditures 100,000 302,773 360,000 129,147 1,040,500 405,900 5,292,843 899,443 879,043 Surplus(Deficit) 74,800 19,030 56,600 68,616 263,232 - (332,500) - - Ending Fund Balance (18,378) 652 51,537 69,268 332,500 332,500 - - N $400 Fund Balance m $300 c $200 r $100 $0 ($100) 50 51 FY 2010 FY 2011 P;V 2012 F'i'2012 FV 2013 FV 2014 FV 2015 FY 2016 FV 2017 Account Description Actual Actual Iudget Projected, Adopted Projected Projected Projected Projected City-Wide Capital-23 23-000-41-00-4176 STATE GRANTS-SAFE ROUTE TO SCHOOL 231;000 231,000 23-000-41-00-4178 STATE GRANTS-ITEP - 178.700 H)NR Grant in 201-Jor Construction 23-000-41-00-4179 STATE GRANTS-DCEO TAP OLD JAIL 64,000 - - - - - 23-000-42-00-4210 BUILDING PERMITS - 17,600 17,600 13,400 13,400 13,400 13,400 13,400 23-000-42-00-4213 ENGINEERING CAPITAL FEE 6,200 3,100 3,000 3,500 - - - - - Moved to PW Capital,elite to Julie locates 23-000-42-00-4214 DEVELOPMENT FEES - - 20,000 20,000 20,000 20,000 20,000 20,000 20,000 23-000-42-00-4216 BUILD PROGRAM PERMITS - - - - - - - 23-000-42-00-4222 ROAD CONTRIBUTION FEE 14,000 22,000 20,000 22.000 20.000 20,000 20,000 20,000 20.000 23-000-45-00-4500 INVESTMENT EARNINGS - 19 - 85 - - - - - 23-000-46-00-4690 RE1MB-MISCELLANEOUS 54,600 1,200 9,578 - 23-000-49-00-4900 BOND PROCEEDS - - - 4.500,000 Proposed],Y 2015 Bond Proceeds 23-000-49-00-4905 LOAN PROCEEDS - 600,000 Kendall Counhv Loam-River Road Bridge 23-000-49-00-4901 TRANSFER FROM GENERAL 100,000 135,484 125,000 125,000 419,332 352,500 406,943 846,043 646,943 P)'2012-Library Capital Proceeds 5332,.100 23-000-49-004915 TRANSFER FROM MOTOR FUEL TAX 96,000 - - - - - - Revenue 174,800 321,803 416,600 197,763 1,303,732 405,900 4,960,343 899,443 879,043 23-230-54-00-5405 BUILD PROGRAM - - - - - - - - - 23-230-54-00-5462 PROFESSIONAL SERVICES 5,740 : - 100,000 - - - - Road Study-FY 2013 23-230-60-00-6015 ROAD RESURFACING - 100.000 300,000 300.000 300,000 300,000 Excess Non-HR Sales Tax proceeds 23-230-60-00-6023 OLD.TAIL PURCHASE 161.549 - - - - - 23-230-60-00-6041 SIDEWALK CONSTRUCTION 10,484 - - 23-230-60-00-6070 VEHICLES - 4,000 4,000 - Moved to 1'W,elite to Julie locates 23-230-60-00-6073 GAME FARM ROAD PROJECT - - - 4.500,000 Frmded by bond proceeds in FY 2015 23-230-60-00-6075 RIVER ROAD BRIDGE PROJECT - 600,000 - - 23-230-60-00-6089 CANNONBALL LAPP PROJECT - - 35,000 150,000 23-230-60-00-6092 SAFE ROUTE TO SCHOOL PROJECT 231,000 147 231,000 - - - - 23-230-60-00-6094 KENNEDY RD BIKE TRAIL - - 9500 5,900 11.900 3,500 133.100 //'EP-Grant Proceeds 2015 Bond 23-230-81-00-8000 PRINCIPLE PAYMENT - 143,443 149,898 156.643 23-230-81-00-8050 INTEREST PAYMENT - - 202,500 196,045 189,300 S4..5,bl-20 years at 4.5'% 51 52 FY 2010 FY 2011 FY 2012 FY i612 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Kendall County Loan-River Road Bridge 23-230-97-00-8000 PRINCIPLE PAYMENT - - - - 100,000 100,000 100,000 100,000 S 600 lours-6 years al 0.0%- Ihry FY 2019 Clark Property 23-230-97-00-8000 PRINCIPLE PAYMENT 100,000 125,000 125,000 125,000 - - Expenditures 100,000 302,773 360,000 129,147 1,040,500 405,900 5,292,843 899,443 879,043 Surplus(Deficit) 74,800 19,030 56,600 68,616 263,232 - (332,500) - - Fund Balance (18,378) 652 51,537 69,268 332,500 332,500 - - -18.38% 0.22% 14.32% 53.64% 31.96% 81.92/ 0.00% 0.00% 0.00% 52 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. FY2012 FY2013 FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Taxes 346,853 346,735 133,866 133,524 133,454 138,041 130,423 372,000 372,000 Licenses&Permits - - - - - - - - - Charges for Service 1,844,416 2,503,003 2,425,250 2,485,250 2,527,871 2,555,945 2,555,945 2,555,945 2,555,945 Investment Earnings 3,204 1,888 2,000 225 300 300 300 300 300 Reimbursements - - - 1,771 7,466 7,977 8,522 9,101 9,720 Miscellaneous 31,410 40,793 50,000 38,580 50,000 50,000 50,000 50,000 50,000 Other Financing Sources 81,750 82,850 83,863 83,863 82,288 82,988 83,588 84,088 84,488 Total Revenue 1,960,780 2,628,534 2,694,979 2,743,213 2,801,379 2,835,251 2,828,778 2,699,434 2,700,453 Expenses Salaries 346,853 346,735 377,000 354,000 382,000 372,000 372,000 372,000 372,000 Benefits 55,606 57,450 65,700 65,700 219,720 230,527 244,922 260,675 277,914 Contractual Services 409,076 401,482 401,850 375,372 501,200 516,463 532,173 548,669 565,990 Supplies 260,178 264,324 360,300 329,800 294,124 285,769 288,630 291,691 294,967 Capital Outlay 176,448 - 96,000 116,000 132,000 126,000 126,000 126,000 126,000 Contingencies (66,431) - - - - - - - - Developer Commitments 114,944 275,865 275,868 275,868 160,923 - - - - Debt Service 703,053 834,453 903,277 903,277 1,396,016 1,172,802 1,168,384 1,163,054 1,166,825 Other Financing Uses 75,569 91,863 91,863 91,863 - Total Expenses 2,075,296 2,272,172 2,571,858 29511,880 3,085,983 2,703,561 2,732,109 29762,089 2,803,696 Surplus(Deficit) (114,516) 356,362 123,121 231,333 (284,604) 131,690 96,669 (62,655) (103,243) Ending Fund Balance Equivalent 339,359 695,723 683,405 927,056 642,452 774,142 870,811 808,156 704,913 16.35% 30.62% 26.57% 36.91% 20.82% 28.63% 31.87% 29.26% 25.14% N $1,000 , Fund Balance Equivalent N $800 o' $600 $400 $200 $0 53 54 FY 2010 FY 2011 FY 2012' ' FY 2012 i FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Water-51 51-000-40-00-4007 PROPERTY TAXES-2007A BOND 133,866 133,524 133,454 138,041 130A23 51-000-42-00-4216 BUILD PROGRAM PERMIT - - - - 51-000-44-00-4424 WATER SALES 1,591,745 1,698,753 1,674,750 1,674,750 1,699,871 1,725,369 1,725,369 1,725,369 1,725.369 51-000-44-00-4425 BULK WATER SALES 879 882 500 500 500 500 500 500 500 51-000-44-00-4430 WATER METER SALES 44,255 22,040 25,000 25,000 26,250 27563 27563 27,563 27.563 51-000-44-00-4440 WATER INFRASTRUCTURE FEE - 685,188 600,000 675,000 675,000 675,000 675,000 675,000 675,000 51-000-44-00-4450 WATER CONNECTION FEES 201,466 96,140 125,000 110,000 126,250 127,513 127,513 127.513 127,513 51-000-44-00-4473 RECAPTURE FEES 6,071 - - - - - - - - 51-000-45-00-4500 INVESTMENT EARNINGS 3,204 1,888 2,000 225 300 300 300 300 300 51-00046-00-4670 REIMB-EMPLOYEE INS CONTRIBUTIONS - - - - 7,225 7,730 8,272 8,851 9,470 51-000-46-00-4671 REIMB-LIFE INSURANCE - - 241 247 250 250 250 51-000-46-00-4690 REIMB-MISCELLANEOUS - - 1,771 - - - - - 51-000-48-00-4820 RENTAL INCOME 27,249 32,038 ' 50,000 35,000 50,000 50,000 50,000 50,000 50,000 Prime Direciwe Water lower Lease Sprint Waler I over Lease l"ereon Water Tower Lease-Lehman(Tossing 51-000-48-00-4821 BAD DEBT RECOVERY 3,690 4,437 - 3,517 51-000-48-00-4850 MISCELLANEOUS INCOME 471 4,318 - 63 - - - - - 51-000-49-00-4952 TRANSFER FROM SEWER 81,750 82,850 83,863 83,863 82,288 82.988 83,588 84.088 84,488 1,or hall the debt.service amount-2005('Hond Revenue 1,960,780 2,628,534 2,694,979 2,743,213 2,801,379 2,835,251 2,828,778 2,699,434 2,700,453 51-510-50-00-5010 SALARIES AND WAGES 343,217 342,790 365,000 345,000 370,000 360,000 360,000 360,000 360,000 51-510-50-00-5020 OVERTIME 3,636 3,945 12,000 9,000 12,000 12,000 12,000 12,000 12.000 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION 29,845 32,128 37,500 37,500 39,852 37,500 37.500 37,500 37,500 51-510-52-00-5214 FICA CONTRIBUTION 25,761 25,322 28,200 28,200 28,200 28,200 28,200 28,200 28,200 51-510-52-00-5216 GROUP HEALTH INSURANCE - - - - 103,966 114,362 125,798 138,378 152-216 51-510-52-00-5222 GROUP LIFE INSURANCE 1,210 1,222 1,234 1,246 1,259 51-510-52-00-5223 DENTAL INSURANCE 7,201 7,921 8.713 9,585 10,543 51-510-52-00-5224 VISION INSURANCE - 829 912 1.003 1,103 1,213 51-510-52-00-5230 UNEMPLOYMENT INSURANCE. 6.000 6,000 6.000 6,000 6,000 51-510-52-00-5231 LIABILITY INSURANCE - 32,462 34,410 36,474 38,663 40,983 51-510-54-00-5405 BUILD PROGRAM - - - - - - - - 51-510-54-00-5412 TRAINING&CONFERENCES 824 1,842 2,000 1,000 2,000 2,000 2,000 2,000 2,000 51-510-54-00-5415 TRAVEL AND LODGING 1,594 390 1,600 1,000 1,600 1,600 1,600 1.600 1,600 51-510-54-00-5426 PUBLISHING&ADVERTISING - 934 1,000 1;172 1,000 1,000 1,000 1,000 1,000 51-510-54-00-5429 WATER SAMPLES 2,332 10,265 14,000 14,000 14,000 14,000 14,000 14,000 14,000 51-510-54-00-5430 PRINTING AND DUPLICATING 2,319 1,164 2,500 500 2,500 2,500 2,500 2.500 2,500 51-510-54-00-5440 TELECOMMUNICATIONS 25,827 15,598 24,500 24,500 24,500 24,500 24,500 24,500 24,500 51-510-54-00-5445 TREATMENT FACILITY SERVICES 70,428 64,626 - - 100.000 100,000 100,000 100.000 100,000 Previously included Treannenl b'acilily Supplies 51-510-54-00-5448 FILING FEES - 4,123 6,200 6,200 6,200 6,200 6,200 6,200 Haler lien filing fees-previously included under Professional Sendce.s 54 55 FY 2010 FV 2011 FY 2012 FY 2012 ' FY 2013 FV 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 51-510-54-00-5462 PROFESSIONAL SERVICES 3,387 3,695 6,000 7,200 8,800 8,800 8,800 8,800 8,800 51-510-54-00-5466 LEGAL SERVICES - - 1000 2,000 2,000 2,000 2,000 2,000 2,000 51-510-54-00-5480 UTILITIES 276,289 262,977 304,500 285,000 299,250 314,213 329,923 346,419 363 740 5%increase per annum 51-510-54-00-5483 JULIE SERVICES 2,979 2,422 3,500 4,000 3,500 4,000 4,000 4,000 4,000 51-510-54-00-5485 RENTAL&LEASE PURCHASE - - 1,000 500 1,000 1,000 1,000 1,000 1,000 51-510-54-00-5495 OUTSIDE REPAIR AND MAINTENANCE 6,279 3,855 10,000 10,000 10.000 10,000 10,000 10,000 10.000 51-510-54-00-5498 PAYING AGENT FEES - 1,552 1,600 1,600 1,400 1,400 1,400 1,400 Previously incluclecl under Prolessional Services 51-510-54-00-5499 BAD DEBT - 10,424 6,000 - - - - - - 51-510-56-00-5600 WEARING APPAREL 2,391 2,206 5,000 3,500 4,000 4,000 4,000 4,000 4,000 51-510-56-00-5620 OPERATING SUPPLIES 18,788 21,468 20,500 17,500 21,425 22,396 22,396 22,396 22.396 51-510-56-00-5630 SMALL TOOLS&EQUIPMENT 1,093 412 2,000 2,000 4,000 2.000 2,000 2,000 2,000 Trench shoring 51-510-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - 338 1,600 1,600 6,000 6,000 6,000 6.000 6.000 Conrpuler replocemuns al PW I tcdines and treulmem plam,c 51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 157,095 176,761 240,000 230,000 165,000 155,000 155,000 155,000 155,000 Additional cost voila e monitors 51-510-56-00-5640 REPAIR AND MAINTENANCE 3,284 995 9,500 9,500 9,500 9,500 9,500 9,500 9,500 51-510-56-00-5664 METERS AND PARTS 51,393 32,136 46,000 30,000 46,000 46.000 46,000 46,000 46,000 51-510-56-00-5695 GASOLINE 26,134 30,008 35,740 35,700 38,199 40,873 43,734 46,795 50,071 Increase 7%per annum 51-510-60-00-6010 IMPROVEMENTS NOT TO BUILDINGS 176,448 - - - - - - - 51-510-60-00-6060 EQUIPMENT - - - 16,000 10,000 10,000 10,000 10,000 Meier replacements-radio 51-510-60-00-6079 ROUTE 47 EXPANSION - - 96,000 116,000 116.000 116,000 116,000 116,000 116.000 51-510-70-00-7799 CONTINGENCIES (66,431) - - - - - - - - 51-510-75-00-7502 GRANDE RESERVE COURT ORDER 114,944 275,865 275,868 275,868 160.923 P inal PMT-Nov 2013 Debt Service-2007A Bond 51-510-83-00-8000 PRINCIPLE PAYMENT 10,000 10,000 10,000 10,000 10.000 15,000 15,000 15,000 15,000 51-510-83-00-8050 INTEREST PAYMENT 124,666 124,266 123,866 123,866 123,454 123,041 122,423 121,793 121.163 Debt Service-2002 Capital Appreciation Debt Certificates 51510-85-00-8000 PRINCIPLE PAYMENT 145,000 215,000 285,000 285,000 365,000 - - - 51-510-85-00-8050 INTEREST PAYMENT - - - - - - - - Debt Service-2003 Debt Certificates 51-510-86-00-8000 PRINCIPLE PAYMENT - - - - - 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 33,150 29,350 25,450 21,450 Debt Service-2006A Refunding Debt Certificates 51-510-87-00-8000 PRINCIPLE PAYMENT 10,000 70,000 70,000 76,000 355,000 405,000 420,000 435,000 460.000 51-510-87-00-8050 INTEREST PAYMENT 91,706 91,306 88,506 88,506 219,806 205,606 189,406 172,606 155,206 Debt Service-2005C Bond 51-510-88-00-8000 PRINCIPLE PAYMENT 80,000 85,000 90,006 90,000 90,000 95,000 100,000 105,000 110,000 51-510-88-00-8050 INTEREST PAYMENT 83,500 80,700 77,725 77,725 74.575 70,975 67,175 63,175 58,975 55 56 FY 2010 FY 2011 1+1'2012 4V2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Debt Service-IEPA Loan L17-156300 51-510-89-00-8000 PRINCIPLE PAYMENT 81,451 83,500 85,600 85,600 87,754 89,961 92,224 94,544 96,923 51-510-89-00-8050 INTEREST PAYMENT 43,580 41,531 39,430 39,430 37,277 35,069 32,806 30,486 28,108 51-510-99-00-9901 TRANSFER TO GENERAL 75,569 91,863 91,863 91,863 Expenses 2,075,296 2,272,172 X2,571,858 2,511,880 3,085,983 2,703,561 2,732,109 2,762,089 2,803,696 Surplus(Deficit) (114,516) 356,362 123,121 231,333 (284,604) 131,690 96,669 (62,655) (103,243) Fund Balance Equiv 339,359 695,723 683,405 927,056 642,452 774,142 870,811 808,156 704,913 1635% 3Q62% 2657% 3691% 20.82% 28.63'% 31.S-% 29.26% 25.14% 56 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. FY2012 FY2013 FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Taxes 265,944 241,621 1,754,690 1,750,206 263,850 123,780 207,000 - 207,000 Licenses&Permits 40,633 40,046 - - - - - - - Charges for Service 1,985,308 1,471,981 1,349,000 1,357,000 1,368,380 1,383,048 1,383,048 1,383,048 1,383,048 Investment Earnings 2,173 1,517 1,800 3,000 3,000 3,000 3,000 3,000 3,000 Reimbursements 5,708 4,576 - 155 4,587 4,908 5,251 5,619 6,012 Other Financing Sources - - - - - 1,137,220 1,133,972 1,134,654 1,134,052 Total Revenue 1,993,189 1,478,074 3,105,490 3,110,361 1,639,817 2,651,956 2,525,271 2,526,321 2,526,112 Expenses Salaries 265,944 241,621 258,000 236,000 212,000 207,000 207,000 207,000 207,000 Benefits 40,633 40,046 45,230 41,000 132,802 139,695 148,644 158,430 169,138 Contractual Services 31,505 52,882 54,300 55,000 73,400 75,500 77,705 79,720 82,151 Supplies 41,679 51,419 80,000 80,000 65,711 80,706 84,767 89,111 93,760 Capital Outlay - - 24,600 60,000 60,000 60,000 60,000 60,000 60,000 Contingencies 18,356 - - - - - - - - Developer Commitments 30,996 30,996 30,996 30,996 180,996 30,996 30,996 30,996 30,996 Debt Service 1,245,738 1,252,597 2,259,955 1,416,415 1,088,013 1,968,119 2,054,461 1,865,399 1,865,857 Other Financing Uses 140,390 165,892 166,908 687,627 82,288 82,988 83,588 84,088 84,488 Total Expenses 1,815,241 1,835,453 2,919,989 2,607,038 1,895,210 2,645,004 2,747,161 2,574,744 2,593,390 Surplus(Deficit) 177,948 (357,379) 185,501 503,323 (255,393) 6,952 (221,890) (48,423) (67,278) Ending Fund Balance Equivalent 2,735,213 2,377,831 2,482,790 2,881,154 2,625,761 2,632,713 2,410,823 2,362,400 2,295,122 150.68% 129.55% 85.03% 110.51% 138.55% 99.54% 87.76% 91.75% 88.50% $4,000 , Fund Balance Equivalent m $3,000 $2,000 JII $1,000 $0 - 57 58 FY 2010 FY 2011 PY 2012 FV 2012 FY 2013 FY 2014 FY 2015 FV 2016 FY 2017 Account Description Actual Actual Budget - Projected Adopted Projected Projected Projected Projected Sewer-52 52-000-40-004009 PROPERTY TAXES-2004B BOND 258,650 257,989 263,850 123,780 52-000-40-004013 PROPERTY TAXES-2005D BOND 1,385,950 1,382,408 - - 52-000-40-00-4014 PROPERTY TAXES-2008 BOND 110,090 109,809 52-000-42-00-4216 BUILD PROGRAM PERMIT - - - - - - 52-000-44-00-4435 SEWER MAINTENANCE FEES 723.012 731,743 714,000 714,000 728,280 741846 742,846 742,846 742,846 52-000-44-00-4455 SW CONNECTION FEES-OPERATIONS 23,400 4,000 5,000 5,000 5,100 5,202 5,202 5,202 5.202 5200 Permil-Approx.26 Permits 52-000-44-00-4456 SW CONNECTION FEES-CAPITAL 60,400 38,000 30,000 38,000 35,000 35,000 35,000 35.000 35.000 S1,800 Permit-Approx.20 Permits 52-000-44-00-4457 SW CONNECTION FEES-ROB ROY 1.176.889 698,000 . 600,000 600,000 600,000 - - - - C cnlax-17nu1 Pavmenl in FY 2013 52-000-44-00-4460 SEWER INFRASTRUCTURE FEES - - - - 600,000 600,000 600,000 600,000 52-000-44-004465 RIVER CROSSING FEES 238 - - - - - 52-000-44-00-4466 LIFT STATION INCOME (7,499) - - 52-000-44-00-4473 RECAPTURE FEES 9,106 - - - - - - - - 52-000-45-00-4500 INVESTMENT EARNINGS 2,173 1,517 1,800 3,000 3,000 3,000 3,000 3.000 3,000 52-000-46-00-4670 REIMB-EMPLOYEE INS CONTRIBUTIONS - - - - 4,587 4 908 5,251 5,619 6,012 52-000-46-00-4671 REIMB-LIFE INSURANCE - - - - - - - - 52-000-46-00-4690 REIMB-MISCELLANEOUS 5,708 4,576 - 155 - - - 52-000-49-00-4901 TRANSFER FROM GENERAL - 1,137,220 1,133,972 1,134,654 1.134,052 Non-HR Sales lax proceeds for 2011 Debl Sen•ice Revenue 1,993,189 1,478,074 3,105,490 3,110,361 1,639,817 2,651,956 2,525,271 2,526,321 2,526,112 52-520-50-00-5010 SALARIES AND WAGES 265.495 241,173 256,000 235,000 210,000 205,000 205,000 205,000 205,000 52-520-50-00-5020 OVERTIME 449 448 2,000 1,000 2,000 2,000 2,000 2.000 2,000 52-520-52-00-5212 RETIREMENT PLAN CONTRIBUTION 21,340 22,383 25,000 23,000 21,290 20,000 20,000 20,000 20,000 52-520-52-00-5214 FICA CONTRIBUTION 19,293 17,663 20,230 18,000 18,000 18,000 18,000 18,000 18,000 52-520-52-00-5216 GROUP HEALTH INSURANCE - - - - 63,595 69,955 76,950 84.645 93,110 52-520-52-00-5222 GROUP LIFE INSURANCE - 537 543 548 554 559 52-520-52-00-5223 DENTAL INSURANCE - 4,687 5.156 5,672 6,238 6,862 52-520-52-00-5224 VISION INSURANCE - 532 585 644 708 779 52-520-52-00-5230 UNEMPLOYMENT INSURANCE - 2,571 2,571 2.571 2.571 2,571 52-520-52-00-5231 LIABILITY INSURANCE - - 21.590 22,885 24,259 25,714 27,257 52-520-54-00-5405 BUILD PROGRAM - - - - - - 52-520-54-00-5412 TRAINING&CONFERENCES 500 100 500 500 500 500 500 52-520-54-00-5415 TRAVEL AND LODGING 500 100 500 500 500 500 500 52-520-54-00-5430 PRINTING AND DUPLICATING - - 100 100 100 100 100 52-520-54-00-5440 TELECOMMUNICATIONS 1,282 1,399 1,800 1,800 1,800 1,800 1,800 1.800 1,800 52-520-54-00-5444 LIFT STATION SERVICES 5,483 5,623 - - 15,000 15,000 15,000 15.000 15,000 52-520-54-00-5462 PROFESSIONAL SERVICES 4,408 4,022 5,000 000 5,000 5,000 5,000 5.000 5,000 52-520-54-00-5480 UTILITIES 13,607 21,071 40,000 40,000 42,000 44,100 46,305 48,620 51,051 5%increase per annum 52-520-54-00-5485 RENTAL&LEASE PURCHASE - - 1,000 1,000 1,500 1,500 1,500 1,500 1,500 52-520-54-00-5495 OUTSIDE REPAIR AND MAINTENANCE 6,725 4,908 4,000 4,000 4,000 4,000 4,000 4,000 4,000 58 Account Description 52-520-54-00-5498 PAYING AGENT FEES FY 2012 �� Previously included wider Prolessional Services 52-520-54-00-5499 BAD DEBT 52-520-56-00-5600 WEARING APPAREL 52-520-56-00-5610 OFFICE SUPPLIES 52-520-56-00-5613 LIFT STATION MAINTENANCE 52-520-56-00-5620 OPERATING SUPPLIES 52-520-56-00-5630 SMALL TOOLS&EQUIPMENT Projected Trenching equipment 52-520-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - Replacement compuler in FY 2013 52-520-56-00-5640 REPAIR AND MAINTENANCE 52-520-56-00-5695 GASOLINE 2,700 increase'%per annum 52-520-60-00-6079 ROUTE 47 EXPANSION 52-520-70-00-7799 CONTINGENCIES 52-520-75-00-7500 LENNAR-RAINTREE SEWER RECAPTURE 52-520-75-00-7501 WINDETT RIDGE-SEWER RECAPTURE Debt Service-2004B Bond 1,830 52-520-84-00-8000 PRINCIPLE PAYMENT 52-520-8400-8050 INTEREST PAYMENT Debt Service-20031RBB Debt Certificates 52-520-90-00-8000 PRINCIPLE PAYMENT 52-520-90-00-8050 INTEREST PAYMENT Debt Service-2004A Bond 2,000 52-520-91-00-8000 PRINCIPLE PAYMENT 52-520-91-00-8050 INTEREST PAYMENT Debt Service-2011 Refunding Bond 52-520-92-00-8000 PRINCIPLE PAYMENT 52-520-92-00-8050 INTEREST PAYMENT Debt Service-2005D Bond 10,000 52-520-93-00-8000 PRINCIPLE PAYMENT 52-520-93-00-8050 INTEREST PAYMENT 1,891 Rcf coded by 2011 Bond in Nov 2011 Debt Service-2008 Refunding Bond 52-520-94-00-8000 PRINCIPLE PAYMENT 52-520-94-00-8050 INTEREST PAYMENT 4,500 Red nded by 2011 Bond in Nov 2011 Debt Service-IEPA Loan L17-013000 52-520-95-00-8000 PRINCIPLE PAYMENT 52-520-95-00-8050 INTEREST PAYMENT Debt Service-IEPA Loan L1 7-115300 52-520-96-00-8000 PRINCIPLE PAYMENT 52-520-96-00-8050 INTEREST PAYMENT FY 2010 FY 2011 FY 2012 �� FY 2612 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Actual Actual Budget Projected Adopted Projected Projected Projected Projected - - - 3,000 3,000 3,000 3,000 2,700 2,700 - 15,859 1,500 - - - - - - 1,683 1,830 2,500 2,500 2,500 2,500 2,500 1500 2,500 1,565 1,072 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,231 4,747 15,000 25,000 10,000 10,000 10,000 10,000 10,000 1,879 1,891 4,500 4,500 4,500 4,500 4,500 4,500 4,500 641 1,354 2,500 2,500 4,500 2,500 2,500 2,500 2,500 - 879 1,200 1,200 3,000 1,200 1.200 1,200 1.200 7.611 10,954 25,000 15.000 10,000 26.750 28,623 30,626 32,770 26,069 28,692 27,300 27,300 29,211 31,256 33,444 35,785 38,290 - - 24,600 60,000 60,000 60,000 60,000 60.000 60,000 18,356 - - - - - - - 30,996 30,996 30,996 30,996 30,996 30,996 30,996 30,996 30,996 - - _ - - - 150,000 - - - - 145,000 155,000 160,060 160,000 170,000 280,000 375,000 395,000 410,000 107,288 103,300 98,650 98,650 93,850 88,750 78,950 65.825 52,000 85,000 90,000 95,000 95,000 100.000 100,000 105.000 110,000 115,000 76,713 73,653 70,143 70,143 66,248 62,048 57,648 52,870 47,755 155,000 160,000 .170,000 170,000 175.000 180,000 190,000 - - 32,525 28,573 24,093 24,093 18,738 13,050 6,840 - - - - - - 660,000 685,000 715,000 745,000 - 225,354 318,147 477,220 448,972 419,654 389 052 - - 1,000,000 - - - - - 385,950 385,950 385,950 332,346 112,231 110,090 110,090 94,800 - 34,125 35,357 36,635 36,635 37,958 4,855 3,623 2,344 2,344 1,022 - - - - 81,942 84,107 86,329 86,329 88,610 90,952 93,355 95,821 98,353 25,109 22,944 20,721 20,721 18,440 16,099 13,696 11,229 8,697 59 •1 FY 2010 FY 2011 itl 2012 `. FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Gadget Projected Adopted Projected Projected Projected Projected 52-520-99-00-9901 TRANSFER TO GENERAL 58,640 83,042 83,045 83,045 - - - - - 52-520-99-00-9951 TRANSFER TO WATER 81,750 82,850 83,863 83,863 82,288 82,988 83,588 84,088 84,488 For half the debt service amount-2005C Bond 52-520-99-00-9999 TRANSFER TO 2011 BOND ESCROW 520,719 - - Expenses 1,815,241 1,835,453 2,919,989 2,607,038 1,895,210 2,645,004 2,747,161 2,574,744 2,593,390 Surplus(Deficit) 177,948 (357,379) 185,501 503,323 (255,393) 6,952 (221,890) (48,423) (67,278) Fund Balance Equiv 2,735,213 2,377,831 2,482,790 2,881,154 2,625,761 2,632,713 2,410,823 2,362,400 2,295,122 150.68% 129.55% 85.03% 110.51% 138.55% 99.54% 8-.76% 97.75% 88.50% •1 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. A variety of membership options are available to both residents and non-residents. The REC Center houses an indoor track,lap pool,whirlpool,and a variety of cardio and resistance equipment. The facility is also used for programming and events,such as Family Winter Fun Night,the Go Green Fair,open basketball,preschool,Sk runs and sports leagues. Surplus(Deficit) (50,240) (67,272) (80,738) (91,301) (81,133) (53,500) Ending Fund Balance Equivalent (127,819) (195,087) (308,434) (286,388) (367,521) (421,021) (421,021) (421,021) (421,021) -20.18% -28.38% -44.59% -41.76% -52.23% -786.96% 0.00% 0.00% 0.00% Fund Balance Equivalent $0 ($100) N c ($200) ($300) ($400) ($500) 61 FY2012 FY2013 FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Charges for Service 574,408 608,154 603,500 587,000 607,000 Miscellaneous 8,632 11,864 7,500 7,500 15,500 Total Revenue 583,040 620,018 611,000 594,500 622,500 - - - - Expenses Salaries 211,086 224,988 232,700 224,140 223,000 Benefits 24,838 28,603 27,708 27,708 29,212 Contractual Services 342,276 384,248 380,580 393,803 408,250 53,500 Supplies 55,080 49,451 50,750 40,150 43,171 - Total Expenses 633,280 687,290 691,738 685,801 703,633 53,500 - - - Surplus(Deficit) (50,240) (67,272) (80,738) (91,301) (81,133) (53,500) Ending Fund Balance Equivalent (127,819) (195,087) (308,434) (286,388) (367,521) (421,021) (421,021) (421,021) (421,021) -20.18% -28.38% -44.59% -41.76% -52.23% -786.96% 0.00% 0.00% 0.00% Fund Balance Equivalent $0 ($100) N c ($200) ($300) ($400) ($500) 61 62 FY 2010 FY 2011 #Y 20112 ' 'W201 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Bodget Projected Adopted Projected Projected Projected Projected Recreation Center 80-000-44-00-4440 PROGRAM FEES 123,073 130,565 125,000 100,000 100,000 80-000-44-00-4441 CONCESSION REVENUE 12,915 14,692 12,500 12,500 12,500 80-000-44-00-4444 MEMBERSHIP FEES 387,975 418,685 410,000 430,000 450,000 80-000-44-00-4445 GUEST FEES 4,303 7,072 3,500 7,000° 7,000 80-000-44-00-4446 SWIM CLASS FEES 30,949 27,013 35,000 25,000 25,000 80-000-44-00-4447 PERSONAL TRAINING FEES 12,603 8,055 15,000 10,000 10,000 80-000-44-00-4448 TANNING SESSION FEES 2,590 2,072 2,500 2,500 2,500 80-000-46-004670 REIMB-EMPLOYEE INS CONTRIBUTIONS - - - - - 80-000-46-00-4671 REIMB-LIFE INSURANCE - - - - - 80-000-48-00-4820 RENTAL INCOME 4,056 7,103 5,000 5,000 13,000 C'realive Kernels-131 E.HVclranbc River C'iip Roasicrc-131 ls.Hydraidic 80-000-48-004846 SCHOLARSHIPS/DONATIONS 3,176 3,170 2,000 2,000 2,000 80-000-48-00-4850 MISCELLANEOUS INCOME 1,400 1,591 500 500 500 Revenue 583,040 620,018 611,000 594,500 622,500 80-800-50-00-5010 SALARIES AND WAGES 34,068 33,542 34,200 29,140 28,000 80-800-50-00-5015 PART-TIME SALARIES 101,640 96,666 98,000 100,000 100,000 80-800-50-00-5020 OVERTIME - - 500 - - 80-800-50-00-5046 PRE-SCHOOL WAGES 22,644 38,362 35,000 35,000 35,000 80-800-50-00-5052 INSTRUCTORS WAGES 52,734 .56,418 65,000 60,000 60,000 80-800-52-00-5212 RETIREMENT PLAN CONTRIBUTION 8,804 11,529 10,000 10,000 10.181 80-800-52-00-5214 FICA CONTRIBUTION 16,034 17,074 17,708 17,708 17,708 - 90-800-52-00-5216 GROUP HEALTH INSURANCE - 1,200 80-800-52-00-5222 GROUP LIFE INSURANCE - 123 80-800-52-00-5223 DENTAL INSURANCE - 80-800-52-00-5224 VISION INSURANCE - 80-800-54-00-5412 TRAINING&CONFERENCES - - - 90-800-54-00-5415 TRAVEL AND LODGING - 200 200 200 80-800-54-00-5426 PUBLISHING&ADVERTISING 1,478 732 1,500 1,500 1,500 80-800-54-00-5440 TELECOMMUNICATIONS 2,357 4,379 3,600 3,600 3,600 80-800-54-00-5447 SCHOLARSHIPS 216 389 900 - - 80-800-54-00-5452 POSTAGE&SHIPPING 180 - 600 600 600 80-800-54-00-5462 PROFESSIONAL SERVICES 22,433 32,851 17,700 20,000 20 000 - 80-800-54-00-5480 UTILITIES 46,796 55,117 49,000 53,000 55,650 - 5%increase per annum 80-800-54-00-5485 RENTAL&LEASE PURCHASE 214,558 215,000 226,500 226,500 236,000 18,500 80-800-54-00-5490 DUES AND SUBSCRIPTIONS 89 - 200 200 200 - 80-800-54-00-5495 OUTSIDE REPAIR AND MAINTENANCE 20,012 13,627 21,200 21,200 15,000 Kid_(7ub Sludia 2 HVA('Orai1-l P2013 80-800-54-00-5496 PROGRAM REFUNDS 7,837 8,473 5,500 5,500 5,500 - 80-800-54-00-5497 PROPERTY TAX PAYMENT 26,320 5300 53,680 61,503 70,000 35,000 80-800-56-00-5606 PROGRAM SUPPLIES 19,119 11,676 17,000 12,000 15,000 - 80-800-56-00-5607 CONCESSION SUPPLIES 11.615 10,029 : 6,300 7,000 7.000 62 63 FY 2010 FY 2011 FY 2012 , FY 2012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 80-800-56-00-5630 SMALL TOOLS&EQUIPMENT 4,100 8,525 6,300 - - 80-800-56-00-5635 COMM JTER EQUIPMENT&SOFTWARE 3,178 3,180 1.000 1,000 1,000 80-800-56-00-5640 REPAIR AND MAINTENANCE 9,355 9,768 11,000 11,000 11,000 80-800-56-00-5645 BOOKS AND PUBLICATIONS - - 50 50 50 80-800-56-00-5695 GASOLINE - - 300 300 321 5%inerease per annum Expenses 633,280 687,290 691,738 685,801 703,633 53,500 Surplus(Deficit) (50,240) (67,272) (80,738) (91,301) (81,133) (53,500) Fund Balance Equiv (127,819) (195,087) (308,434) (286,388) (367,521) (421,021) (421,021) (421,021) (421,021) -20.18% -28.38% -44.59% -41.76910 -52.23% -"86.96% 63 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. Ending Fund Balance 571,002 317,336 256,445 347,109 370,330 402,884 447,947 5041 292 570,580 37.89% 19.99% 24.19% 32.53% 46.62% 50.03% 54.58% 60.21% 66.67% _ 1 $600 Fund Balance i $noo 3 o i r ~ $200 i $0 64 FY2012 FY2013 FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Taxes 1,183,774 1,252,191 675,000 692,476 707,500 725,000 750,000 775,000 800,000 Intergovernmental 19,694 24,410 22,200 22,231 22,200 22,200 22,200 22,200 22,200 Licenses&Permits 31,100 17,650 8,000 8,000 - - - - - Fines&Forfeits 11,503 14,161 13,000 13,000 13,000 13,000 13,000 13,000 13,000 Charges for Service 18,493 17,117 13,000 16,200 17,000 17,000 17,000 17,000 17,000 Investment Earnings 1,952 690 250 325 150 150 150 150 150 Reimbursements 6,181 - - - 7,306 7,787 8,287 8,821 9,393 Miscellaneous 6,113 7,823 5,500 12,200 8,500 8,500 8,500 8,500 8,500 Other Financing Sources - - 332,500 332,500 41,978 44,240 46,637 49,178 51,872 Total Revenue 1,278,810 1,334,042 1,069,450 1,096,932 817,634 837,877 865,774 893,849 922,115 Expenditures Salaries 486,675 501,353 434,000 438,000 440,000 440,000 440,000 440,000 440,000 Benefits 134,192 143,220 158,425 156,560 218,553 230,186 244,748 260,672 278,084 Contractual Services 152,280 183,101 105,100 105,849 111,599 112,387 113,213 114,082 114,993 Supplies 164,686 147,408 29,250 33,250 21,750 21,750 21,750 21,750 21,750 Contingencies 4,985 6,705 1,000 1,000 1,000 1,000 1,000 1,000 1,000 Debt Service 564,050 605,925 - - - - - - - Other Financing Uses - - 332,500 332,500 1,511 - - - - Total Expenditures 1,506,868 1,587,712 1,060,275 1,067,159 794,413 805,323 820,711 837,504 855,827 Surplus(Deficit) (228,058) (253,670) 9,175 29,773 23,221 32,554 45,063 56,345 66,288 Ending Fund Balance 571,002 317,336 256,445 347,109 370,330 402,884 447,947 5041 292 570,580 37.89% 19.99% 24.19% 32.53% 46.62% 50.03% 54.58% 60.21% 66.67% _ 1 $600 Fund Balance i $noo 3 o i r ~ $200 i $0 64 Account Description Library Operations 82-000-40-00-4005 PROPERTY TAXES-LIBRARY 82-000-40-00-4012 PROPERTY TAXES-FOX INDUSTRIAL TIE 82-000-40-00-4015 PROPERTY TAXES-DEBT SERVICE 82-000-41-00-4120 PERSONAL PROPERTY TAX 82-000-41-00-4170 STATE GRANTS RETIREMENT PLAN CONTRIBUTION Librmy Per Capita Grant 82-000-42-00-4211 DEVELOPMENT FEES-BOOKS 36,691 Moved to Libran,Capital-Beg.FY 2013 82-000-42-00-4212 DEVELOPMENT FEES-BUILDING 82-820-52-00-5222 Moved to Library Capital 82-000-43-00-4330 LIBRARY FINES 82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 82-000-44-00-4422 COPY FEES 82-000-44-00-4440 PROGRAM FEES 82-000-45-00-4500 INVESTMENT EARNINGS 82-000-46-00-4670 REIMB-EMPLOYEE INS CONTRIBUTIONS 82-000-46-00-4671 REIMB-LIFE INSURANCE 82-000-46-00-4682 REIMB-INSURANCE 82-000-48-00-4820 RENTAL INCOME 82-000-48-00-4824 DVD RENTAL INCOME 82-000-48-00-4832 MEMORIALS 82-000-48-00-4850 MISCELLANEOUS INCOME 82-000-48-00-4881 SALE OF BOOKS 82-000-49-00-4901 TRANSFER FROM GENERAL 82-820-54-00-5423 For Liability/Unemplovntent insurance FY 2010 Actual 622,624 561,150 5,139 14,555 15,550 15,550 11,503 14,720 3,773 1,952 6,181 1,239 4,451 423 FY 2011 Revenue 1,278,810 82-820-50-00-5010 SALARIES AND WAGES 486,675 82-820-50-00-5015 PART-TIME SALARIES - 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 19,866 82-820-52-00-5214 FICA CONTRIBUTION 36,691 82-820-52-00-5216 GROUP HEALTH INSURANCE 70,805 82-820-52-00-5222 GROUP LIFE INSURANCE 1,240 82-820-52-00-5223 DENTAL INSURANCE 4,881 Dental&Vision combined in FY 2012 Budget 19,331 82-820-52-00-5224 VISION INSURANCE 709 82-820-52-00-5230 UNEMPLOYMENT INSURANCE - - Canceled out by General Fund transfer - 82-820-52-00-5231 LIABILITY INSURANCE - - Canceled out by General Fund transfer 5,000 82-820-54-00-5412 TRAINING&CONFERENCES 358 82-820-54-00-5415 TRAVEL AND LODGING 566 82-820-54-00-5423 PUBLIC RELATIONS 663 82-820-54-00-5426 PUBLISHING&ADVERTISING 29 82-820-54-00-5440 TELECOMMUNICATIONS 5,198 FY 2011 FY 2012 FY 2012 FV 2013 FV 2014 FV 2015 FV 2016 FV 2017 Actual Budget Projected_ Adopted Projected Projected Projected Projected 648,060 675,000 673,145 700,000 725,000 750,000 775,000 800,000 19,331 7,500 - - - - 604,131 - - - - - - - 7,217 5,000 5,000 5,000 5,000 5,000 5,000 5,000 17,193 17,200 17,231 17,200 17,200 17,200 17,200 17,200 8,825 8,000 8,000 - - - - - 8,825 _ - - - - - - 14,161 13,000 13,000 13,000 13,000 13,000 13,000 13,000 13,742 8,000 12,000 12,000 12,000 12,000 12,000 12,000 3,339 3,000 3,200 3,000 3,000 3,000 3,000 3,000 36 2,000 1,000 2,000 2,000 2,000 2,000 2,000 690 250 325 150 150 150 150 150 - 6,670 7,137 7,637 8,171 8,743 636 650 650 650 650 1,454 1,500 2,500 2,000 2,000 2,000 2,000 2,000 4,131 4,000 5,000 4,500 4,500 4,500 4,500 4,500 1,883 - 4,000 2,000 2,000 2,000 2,000 2,000 55 700 - - - - - 300 - - - - - 332,500 332,500 41,978 44,240 46,637 49,178 51,872 1,334,042 1,069,450 ' 1,096,932 817,634 837,877 865,774 893,849 922,115 501,353 241,000 243,000 245,000 245,000 245,000 245,000 245,000 - 193,000 195,000 195,000 195,000 195,000 195,000 195,000 21,607 22,500 22,500 26,692 25,000 25,000 25,000 25,000 37,766 40,000 40,000 38,000 38,000 38,000 38,000 38,000 76,487 87,975 86,500 102,877 113,165 124,482 136,930 150,623 1,200 1,000 760 1,410 1,424 1,438 1,453 1,467 5,451 6,950 6,100 6,826 7,509 8,259 9,085 9,994 709 - 700 770 848 932 1,026 1,128 - 4,286 4,286 4,286 4,286 4,286 37,692 39,954 42,351 44,892 47,586 949 593 500 500 500 500 500 500 500 112 - - - 130 100 100 100 100 100 100 100 9,055 8,500 8,500 8,500 8,500 8,500 8,500 8,500 65 Account Description 82-820-54-00-5452 POSTAGE&SHIPPING 82-820-54-00-5460 DUES AND SUBSCRIPTIONS 82-820-54-00-5462 PROFESSIONAL SERVICES 82-820-54-00-5466 LEGAL SERVICES 82-820-54-00-5468 AUTOMATION 82-820-54-00-5480 UTILITIES 11,290 5%increase per annum 82-820-54-00-5485 RENTAL&LEASE PURCHASE 82-820-54-00-5489 BUILDING-DEVELOPMENT FEES 82-820-54-00-5495 OUTSIDE REPAIR AND MAINTENANCE 82-820-54-00-5498 PAYING AGENT FEES 2,000 Previously included under Prolessional Services 82-820-56-00-5610 OFFICE SUPPLIES 82-820-56-00-5620 OPERATING SUPPLIES 11,484 Custodial supplies 82-820-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 82-820-56-00-5640 REPAIR AND MAINTENANCE 82-820-56-00-5671 LIBRARY PROGRAMMING 82-820-56-00-5676 EMPLOYEE RECOGNITION 82-820-56-00-5680 ADULT BOOKS 82-820-56-00-5681 JUVENILE BOOKS 82-820-56-00-5682 REFERENCE BOOKS 82-820-56-00-5683 AUDIO BOOKS 82-820-56-00-5684 COMPACT DISCS AND OTHER MUSIC 82-820-56-00-5685 DVD'S 82-820-56-00-5686 BOOKS-DEVELOPMENT FEES 6,995 A4oved to Libran Capital 82-820-56-00-5698 MEMORIALS AND GIFTS 7,637 Ties to memorial&gifts revenue 82-820-56-00-5699 MISCELLANEOUS 82-820-70-00-7799 CONTINGENCIES Debt Service-2005B Bond 82-820-83-00-8000 PRINCIPLE PAYMENT 82-820-83-00-8050 INTEREST PAYMENT 2,000 Moved to Library Debt Service Fund Debt Service-2006 Bond 82-820-84-00-8000 PRINCIPLE PAYMENT 82-820-84-00-8050 INTEREST PAYMENT Moved to Libranv Debt Service Fund 82-820-99-00-9983 TRANSFER TO LIBRARY DEBT SERVICE 82-820-99-00-9984 TRANSFER TO LIBRARY DEVLP FEE Expenditures FY 2010 Actual 1,738 18,046 20,090 2,125 24,973 12,009 2,442 16,171 47,872 13,889 11,104 4,276 2,506 10,137 1,113 20,213 40,325 24,097 8,176 2,963 4,750 16,638 4,416 83 4,985 25,000 320,125 150,000 68,925 1,506,868 Surplus(Deficit) (228,058) Fund Balance 571,002 37.89% FY 2011 1Y 2012 FY 2013 ' FY 2013 Actual Budget Projected Adopted 2,104 1,000 2,000 1,000 11,290 14,000 1000 14,000 31,824 29,000 29,000 29,000 4,175 2,000 2,000 2,000 48,567 30,000 30,000 35,000 11,484 15,000 15,000 15,750 1,007 - - 33,423 - - 28,388 4,000 4,000 5,000 749 749 8,784 8,000 8,000 8,000 6,995 9,000 9,000 7,500 7,637 - 2,180 - - - 8,172 2,000 2,000 2,000 93 30,312 40,713 1 1,394 9,526 2,122 - - - 7,715 2,000 2,000 2,000 9,343 8,000 8,000 - 1,622 - 4,000 2,000 800 250 250 250 6,705 1,000 1,000 1,000 75,000 - - 319,125 150,000 61,800 1,511 332,500 332.500 - 1,587,712 1,060,375 1,067,159 794,413 (253,670) 9,175 29,773 23,221 FY 2014 Projected 1,000 14,000 29,000 2,000 35,000 16,538 5,000 749 8,000 7,500 2,000 2,000 2,000 250 1,000 805,323 32,554 FY 2015 Projected 1,000 14,000 29,000 2,000 35,000 17,364 5,000 749 8,000 7,500 2,000 2,000 2,000 250 1,000 820,711 45,063 FY 2016 Projected 1,000 14,000 29,000 2,000 35,000 18,233 5,000 749 8,000 7,500 2,000 2,000 FY 2017 Projected 1,000 14,000 29,000 2,000 35,000 19,144 5,000 749 8,000 7,500 2,000 2,000 2,000 2,000 250 250 1,000 1,000 837,504 855,827 56,345 317,336 256,445 347,109; 370,330 402,884 447,947 504,292 19.991y" 24.19' 32.53% 46:62% 517.03% 54.58Y, 60.21Y, 66 66,288 570,580 66.67'/n 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. Ending Fund Balance - (1,811) - 300 600 900 1,200 N $2 1 Fund Balance $1 r $o ($1) ($2) 67 FY2012 FY2013 FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2015 FY2015 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Taxes 720,800 718,839 795,488 771,763 768,613 785,238 790,463 Investment Earnings - 150 300 300 300 300 300 Other Financing Sources - - 1,511 - - - - Total Revenue - - 720,800 718,989 797,299 772,063 768,913 785,538 790,763 Expenditures Debt Service - - 720,800 720,800 795,488 771,763 768,613 785,238 790,463 Total Expenditures - - 720,800 720,800 795,488 771,763 768,613 785,238 790,463 Surplus(Deficit) - - - (1,811) 1,811 300 300 300 300 Ending Fund Balance - (1,811) - 300 600 900 1,200 N $2 1 Fund Balance $1 r $o ($1) ($2) 67 a FY 2010 FY 2011 1,+Y 2011 Fi'1012 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Budget.' Projected Adopted Projected Projected Projected Projected Library Debt Service 83-000-40-004015 PROPERTY TAXES-LIB DEBT SERVICE 720,800 718,834 795,488 771,763 768,613 785,238 790,463 83-000-45-004500 INVESTMENT EARNINGS - I50 300 300 300 300 300 83-000-49-004982 TRANSFER FROM LIBRARY OPS 1,511 - To eliminate negative Fund Balance Revenue 720,800 718,989 797,299 772,063 768,913 785,538 7911,763 Debt Service-2005B Bond 83-830-83-00-8000 PRINCIPLE PAYMENT 175,000 115,000 290,000 335,000 400,000 435,000 460.000 83-830-83-00-8050 INTEREST PAYMENT 316,125 316;125 309,125 297,525 284.125 268,125 250.725 Debt Service-2006 Bond 83-830-84-00-8000 PRINCIPLE PAYMENT 175,000 175,000 150.000 100,000 50000 50,000 50.000 83-830-84-00-8050 INTEREST PAYMENT 54,675 54,675 46,363 39.238 34,488 32113 29,738 Expenditures 720,800 710,800 795,488 771,763 768,613 785,238 790,463 Surplus(Deficit) - (1,811) 1,811 300 300 300 300 Fund Balance 0 (1,811) - 300 600 900 1,200 0.00% -0.25% 0.00% 0.04%, 0.08% 0.11% 0.]5% a 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 purchases. Ending Fund Balance 4,500 (2,876) - - - - - $6 Fund Balance N r $4 $2 0 L $p ($2) ($4) _�1 FY2012 FY2013 FY2010 FY2011 Adopted FY2012 Adopted FY2014 FY2015 FY2016 FY2017 Actual Actual Budget Projected Budget Projected Projected Projected Projected Revenue Licenses&Permits - 8,000 8,000 16,250 16,250 16,250 16,250 16,250 Investment Earnings - 500 70 100 100 100 100 100 Other Financing Sources - 332,500 332,519 - - - - Total Revenue - - 341,000 340,589 16,350 16,350 16,350 16,350 16,350 Expenditures Supplies - - - - 13,474 16,350 16,350 16,350 16,350 Capital Outlay - - 4,000 10,965 - - - - - Other Financing Uses - - 332,500 332,500 - Total Expenditures - - 336,500 343,465 13,474 16,350 16,350 16,350 16,350 Surplus(Deficit) - - 4,500 (2,876) 2,876 - - - - Ending Fund Balance 4,500 (2,876) - - - - - $6 Fund Balance N r $4 $2 0 L $p ($2) ($4) _�1 70 FY 2010 FY 2011 W 2012 t*2012, FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 Account Description Actual Actual Midget '' Projected ! Adopted Projected Projected Projected Projected Library Capital Fund 84-000-42-00-4214 DEVELOPMENT FEES 8,000 8,000 16,250 16,250 16,250 16,250 16,250 84-000-45-00-4500 INVESTMENT EARNINGS - - 500 70 100 100 100 100 100 84-000-49-00-4982 TRANSFER FROM LIBRARY OPS 332,500 332,519 Revenue 341,000 340,589 16,350 16,350 16,350 16,350 16,350 84-840-50-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - - - - - 84-840-56-00-5686 BOOKS - 13,474 16,350 16,350 16,350 16,350 84-840-56-00-5683 AUDIO BOOKS - - - - - 84-840-56-00-5684 COMPACT DISCS AND OTHER MUSIC - 94-840-56-00-5685 DVDS - - 84-840-60-00-6020 BUILDINGS&STRUCTURES 4,000 10,965 84-840-99-00-9901 TRANSFER TO GENERAL FUND 332,500 332,500 - - Expenditures 336,500 343,465 13,474 16,350 16,350 16,3511 16,350 Surplus(Deficit) 4,500 (2,876) 2,876 - - - - Fund Balance 4,500- (2,876) - 1.34% -0.84% 0.00% 11.110% 11.011% 0.00% 0.00y, 70