Loading...
Ordinance 2014-10 STATE OF ILLINOIS COUNTY OF KENOAU — FILED — APR 2 5 2014 com arc KWft n UNITED CITY OF YORKVILLE KENDALL COUNTY, ILLINOIS ORDINANCE NO. 2014-10 ORDINANCE APPROVING THE 2014-2015 FISCAL BUDGET FOR THE UNITED CITY OF YORKVILLE Passed by the City Council of the United City of Yorkville,Kendall County,Illinois This 10th day of April,2014 Published in pamphlet form by the authority of the Mayor and City Council of the United City of Yorkville,Kendall County,Illinois on April 25, 2014. ORDINANCE NO. 2014- 10 ORDINANCE APPROVING THE 2014-2015 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 2014-2015 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 2014-2015 Fiscal Year Budget being submitted on April 10, 2014 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 2014-2015 Budget totaling $28,270,306 including the amounts of$13,570,112 General Fund, $863,499 Motor Fuel Tax Fund, $559,202 Vehicle& Equipment Fund, $3,217,226 Sewer Fund, $3,093,781 Water Fund, $2,548,272 City-Wide Capital Fund, $330,354 Debt Service Fund, $406,850 Land Cash Fund, $1,911,447 Parks &Recreation Fund, $783,453 Library Operations Fund, $731,321 Library Debt Service Fund, $55,015 Library Capital Fund, $91,398 Countryside TIF Fund, $52,788 Downtown TIF Fund, $35,985 Sunflower SSA Fund, and $19,603 Fox Hill SSA Fund is hereby adopted for the 2014-2015 Fiscal Year, as presented. Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this 10`"day of April, A.D. 2014. CITY CLERK Ordinance No.2014- O Page 2 CARLO COLOSIMO Y KEN KOCH _ JACKIE MILSCHEWSKI Y LARRY KOT CHRIS FUNKHOUSER -- JOEL FRIEDERS 1 ROSE ANN SPEARS DIANE TEELING Y Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this 10`h day of April, A.D. 2014. n MAYOR Ordinance No.2014- (Q Page 3 GENERAL FUND(01) The General Fund is the City's primary operating fund. It accounts for major tax revenue used to support administrative and public safety functions. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 7,942,975 9,317,383 9,359,104 9,539,599 9,871,724 9,974,701 10,093,408 10,207,852 10,313,041 Intergovernmental 1,917,618 2,080,757 2,018,200 2,171,750 2,177,200 2,177,200 2,187,200 2,192,200 2,202,200 Licenses&Permits 171,921 168,831 193,000 172,500 193,000 193,000 243,000 243,000 243,000 Fines&Forfeits 175,159 169,144 180,200 181,750 175,250 175,250 175,250 175,250 175,250 Charges for Service 1,561,554 1,199,908 1,181,235 1,173,214 1,203,201 1,234,152 1,266,032 1,298,868 1,332,689 Investment Earnings 5,102 7,287 6,500 8,300 8,000 6,000 5,000 3,000 2,000 Reimbursements 391,321 238,535 55,000 80,000 80,000 80,000 80,000 80,000 80,000 Miscellaneous 13,702 132,965 11,000 9,500 13,000 13,000 13,000 13,000 13,000 Other Financing Sources 332,500 - 5,250 5,250 5,250 5,250 5,250 5,250 5,250 Total Revenue 12,511,852 13,314,810 13,009,489 13,341,863 13,726,625 13,858,553 14,068,140 14,218,420 14,366,430 Expenditures Salaries 3,029,713 3,170,404 3,546,298 3,540,798 3,967,218 4,179,479 4,314,437 4,454,120 4,598,691 Benefits 2,407,769 1,909,160 2,270,039 2,136,670 2,470,227 2,676,671 2,842,578 3,019,414 3,207,340 Contractual Services 3,944,907 3,520,085 3,945,473 4,068,976 4,283,415 4,273,381 4,317,591 4,401,612 4,474,911 Supplies 236,916 260,466 292,110 293,110 300,299 307,827 318,012 328,899 340,538 Contingencies 52,075 - 50,000 11,675 - - - - - Other Financing Uses 1,297,950 1,501,502 3,798,673 3,796,914 2,548,953 2,654,963 2,823,942 3,020,169 3,189,327 Total Expenditures 10,969,330 10,361,617 13,902,593 13,848,143 13,5709112 149092,321 14,616,560 15,224,214 15,810,807 Surplus(Deficit) 1,542,522 2,953,193 (893,104) (506,280) 156,513 (233,768) (548,420) (1,005,794) (1,444,377) Ending Fund Balance 1,270,623 4,223,820 2,541,653 397179540 3,874,053 3,640,285 3,091,865 2,086,071 641,694 11.58% 40.76% 18.28% 2685% 28.55% 25.83% 21.15% 13.70% 4.06% Fund Balance $5,000 N $4,000 r $3,000 $2,000 $1,000 $0 1 FY 2012 FY 2013 FY 2014. FY 2014 FY 2015 FY 2016 FY 2017 FV 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected GENERAL FUND-01 01-00040-00-4000 PROPERTY TAXES-CORPORATE LEVY 2,282,246 2,276,807 2,288,154 2,201759". 2,334,190 2,357,532 2,381,107 2,404,918 2,428,967 01-00040-00 4010 PROPERTY TAXES-POLICE PENSION 360,356 438,711 562,000 524,120 614,005 639,005 664,005 689,005 714,005 01-000-40-00-4012 PROPERTY TAXES-FOX INDUSTRIAL TIF 67,334 - - - - - - - - 01-00040-0011030 MUNICIPAL SALES TAX 2,552,483 2,490,503 2,449,250 2,600,000 2,626,000 2,652,260 2,678,783 2,705,571 2,732,627 01-00040-004035 NON-HOME RULE SALES TAX 410,327 1,919,423 1,800,000 2,000,000` 2,020,000 2,040,200 2,060,602 2,081,208 2,102,020 01-000-40-00-4040 ELECTRIC UTILITY TAX 603,015 600,182 605,000 605,000- 605,000 605,000 610,000 610,000 615,000 01-000-40-00-4041 NATURAL GAS UTILITY TAX 225,411 235,790 275,000 245.000 255,000 260,000 270,000 280,000 280,000 01-000-40-00-4043 EXCISE TAX 500,415 484,365 500,000 475,000 490,000 490,000 490,000 490,000 490,000 01-000-40-00-4044 TELEPHONE UTILITY TAX 18,393 15,265 20,200 15,000 15,000 15,000 15,000 15,000 15,000 01-000-40-00-4045 CABLE FRANCHISE FEES 221,465 218,091 230,000 220,000 225,000 225,000 225,000 225,000 225,000 01-00040-004050 HOTEL TAX 51,029 53,859 50,000 60,000 60,000 60,000 60,000 65,000 65,000 01-000-40-00-4060 AMUSEMENT TAX 127,737 140,856 165,000 165,000':`- 195,000 195,000 200,000 200,000 200,000 01-00040-004065 ADMISSIONS TAX 190,627 119,199 104,500 103,720'. 105,000 105,000 105,000 105,000 105,000 01-00040-004070 BUSINESS DISTRICT TAX 305,908 314,385 300,000 315,000' 317,529 320,704 323,911 327,150 330,422 01-000-40-004075 AUTO RENTAL TAX 9,549 9,633 1 0,000 10,000' 10,000 10,000 10,000 10,000 10,000 01-000-40-004080 PARA-MUTUEL TAX 16,680 314 - - - - - - 01-000-41-00-4100 STATE INCOME TAX 1,444,426 1,587,324 1,550,000 1,650,000 1,650,000 1,650,000 1,650,000 1,650,000 1,650,000 01-00041-004105 LOCAL USE TAX 246,963 268,285 250,000 180,000 280,000 280,000 290,000 290,000 300,000 01-000-41-00-4110 ROAD&BRIDGE TAX 166,896 168,477 170,000 170,000 175,000 175,000 175,000 180,000 180,000 01-00041-00-4115 VIDEO GAMING TAX - 2,300 - 20,000; 20,000 20,000 20,000 20,000 20,000 01-00041-004120 PERSONAL PROPERTY TAX 15,030 15,908 15,000 16,000' 16,000 16,000 16,000 16,000 16,000 01-00041-004160 FEDERAL GRANTS 12,521 17,131 12,000 15,000' 15,000 15,000 15,000 15,000 15,000 01-000 41-004168 TRAFFIC SIGNAL MAINTENANCE 28,582 20,019 20,000 19,284' 20,000 20,000 20,000 20,000 20,000 01-00041-004170 STATE GRANTS 2,123 - - 266 - - - - - 01-000-41-00-4182 MISC INTERGOVERNMENTAL 1,077 1,313 1,200 1,200 1,200 1,200 1,200 1,200 1,200 01-000-42-00-4200 LIQUOR LICENSE 43,265 39,895 40,000 40,000 40,000 40,000 40,000 40,000 40,000 01-00042-00-4205 OTHER LICENSES&PERMITS 6,256 2,336 3,000 2,500 3,000 3,000 3,000 3,000 3,000 01-00042-004210 BUILDING PERMITS 122,400 126,600 150,000 130,000 150,000 150,000 200,000 200,000 200,000 01-000-43-00-4310 CIRCUIT COURT FINES 66,028 59,121 70,000 55,000 60,000 60,000 60,000 60,000 60,000 01-000-43-00-4320 ADMINISTRATIVE ADJUDICATION 24,206 36,328 30,000 36,500'- 35,000 35,000 35,000 35,000 35,000 01-000113-00-4323 OFFENDER REGISTRATION FEES 175 320 200 250 250 250 250 250 250 01-000-43-004325 POLICE TOWS 84,750 73,375 80,000 90,000 80,000 80,000 80,000 80,000 80,000 01-00044-004400 GAR13AGESURCHARGE 1,231,681 1,028,304 :: 1,023,500 1,001,651 1,031,701 1,062,652 1,094,532 1,127,368 1,161,189 01-000-44-00-4405 COLLECTION FEE-YBSD 134,531 150,423 137,235 150,000 150,000 150,000 150,000 150,000 150,000 2 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 01-000.44-00-4407 LATEPENALTIES-GARBAGE - 21,081 20,000 21,063 21,000 21,000 21,000 21,000 21,000 01-000-44-00-4451 WATER CHARGEBACK 91,863 - - _ _ _ _ _ _ 01-000-44-00-4452 SEWER CHARGEBACK 83,045 01-000-44-004472 LAND CASH CHARGEBACK 20,084 - - _ _ _ _ - 01-000-44-00-4474 POLICE SPECIAL DETAIL 350 100 500 500 500 500 500 500 500 01-000-45-00-4500 INVESTMENT EARNINGS 5,102 7,287 6,500 8,300 8,000 6,000 5,000 3,000 2,000 01-000-46-00-4601 REIMB-LEGAL EXPENSES 28,738 12,492 _ _ _ _ _ _ 01-000-46-00-4604 REIMB-ENGINEERING EXPENSES 25,697 30,004 - 50,000 50,000 50,000 50,000 50,000 50,000 01-000-46-00-4668 REIMB-COBRA CONTRIBUTIONS 23,220 - _ _ _ _ _ 01-000-46-00-4669 REIMB-RETIREE INS CONTRIBUTIONS 48,447 57,824 01-000146-004670 REIMB-EMPLOYEEINSCONTRIBUTIONS 91,536 67,166 01-00046-004671 REIMB-LIFE INSURANCE 3,363 2,229 01-000-46-004672 REIMB-LIBRARY INSURANCE 93,842 - - _ _ _ _ _ 01-000-46-004680 REIMB-LIABILITY INSURANCE 3,417 27,670 0 `" .000 -. 5,000: 5,000 5,000 5,000 5,000 5,000 01-00046-00-4681 REIMB-WORKERS COMP 25,557 15,098 - _ _ _ _ _ 01-00046-00-4685 REIMB-CABLE CONSORTIUM 37,167 17,243 40,000 20,000 20,000 20,000 20,000 20,000 20,000 01-00046-00 4690 REIMB-MISCELLANEOUS 10,337 8,809 10,000 5,000 5,000 5,000 5,000 5,000 5,000 01-000-48-004820 RENTAL INCOME 8,460 7,615 8,000 8,000. 8,000 8,000 8,000 8,000 8,000 01-000-48-004845 DONATIONS 50 - - - 2,000 2,000 2,000 2,000 2,000 01-000-48-00-4850 MISCELLANEOUS INCOME 5,192 125,350 3,000 1,500 3,000 3,000 3,000 3,000 3,000 01-000-49-00-4916 TRANSFER FROM CW MUNICIPAL BUILDING - - 5,250 5,250 5,250 5,250 5,250 5,250 5,250 01-000-49-004984 TRANSFER FROM LIBRARY CAPITAL 332,500 Revenue 12,511,852 13,314,810 13,009,489 13,341,863 13,726,625 13,858,553 14,068,140 14,218,420 14,366,430 3 ADMINISTRATION DEPARTMENT The Administration Department includes both elected official and management expenditures. The executive and legislative branches consist of the Mayor and an eight member 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 it the daily administration of City services. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 307,078 340,543 368,599 363,099 433,153 443,688 456,347 469,449 483,010 Benefits 49,070 238,180 253,005 239,732 289,190 315,700 339,572 365,318 393,172 Contractual Services 112,309 122,314 172,833 172,983 167,735 169,039 170,421 171,886 173,439 Supplies 8,084 9,162 12,950 12,950 12,950 12,950 12,950 12,950 12,950 Total Administration 476,541 710,199 807,387 788,764 903,028 941,377 979,290 1,019,603 1,062,571 $1,200 m $1,000 r $800 $600 $400 $200 $0 4 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Administration 01-110-50-00-5001 SALARIES-MAYOR 10,105 9,605 11,000 11,000 11,000 11,000 11,000 11,000 11,000 01-110-50-00-5002 SALARIES-LIQUOR COMM 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 01-110-50-00-5003 SALARIES-CITY CLERK 8,535 10,137 11,000 11,000 11,000 11,000 11,000 11,000 11,000 01-110-50-00-5004 SALARIES-CITY TREASURER 5,800 4,267 6,500 1,000 6,500 6,500 6,500 6,500 6,500 01-110-50-00-5005 SALARIES-ALDERMAN 48,270 47,205 52,000 52,000 52,000 52,000 52,000 52,000 52,000 01-110-50-00-5010 SALARIES-ADMINISTRATION 232,228 268,329 264,599 264,599 351,153 361,688 374,347 387,449 401,010 01-110-50-00-5015 PART-TIME SALARIES - - .22,000 22,000 - - - - - 01-110-50-00-5020 OVERTIME 1,140 - 500 500 500 500 500 500 500 01-110-52-00-5212 RETIREMENT PLAN CONTRIBUTION 27,723 32,561 38,125 38,125:` 47,482 56,728 61,858 67,435 73,583 01-110-52-00-5214 FICA CONTRIBUTION 21,347 23,994 27,087 27,087' 31,887 32,844 33,994 35,184 36,415 01-110-52-00-5216 GROUP HEALTH INSURANCE - 69,719 78,075 78,075 114,769 123,951 133,867 144,576 156,142 01-110-52-00-5222 GROUP LIFE INSURANCE 580 476 400 559 565 571 577 583 01-110-52-00-5223 DENTAL INSURANCE 5,202 5,628 4,500'- 6,376 6,695 7,030 7,382 7,751 01-110-52-00-5224 VISION INSURANCE 562 590 570 775 798 822 847 872 01-110-52-00-5235 ELECTED OFFICIAL-GROUP HEALTH INSURANCE 96,881 94,874 85,000 81,548 88,072 95,118 102,727 110,945 01-110-52-00-5236 ELECTED OFFICIAL-GROUP LIFE INSURANCE 682 682 650- 644 650 657 664 671 01-110-52-00-5237 ELECTED OFFICIAL-DENTAL INSURANCE 7,202 6,765 4,750 4,593 4,823 5,064 5,317 5,583 01-110-52-00-5238 ELECTED OFFICIAL-VISION INSURANCE - 797 7033 575'+i'.- 557 574 591 609 627 01-110-54-00-5412 TRAINING&CONFERENCES 1,925 3,510 3,000 3,000Y' 5,100 5,100 5,100 5,100 5,100 01-110-54-00-5415 TRAVEL&LODGING 1,565 6,310 8,000 8,000! 11,000 11,000 11,000 11,000 11,000 01-110-54-00-5426 PUBLISHING&ADVERTISING 1,107 716 1,000 1,000' 1,000 1,000 1,000 1,000 1,000 01-110-54-00-5430 PRINTING&DUPLICATING 5,972 5,356 5,150 5,250.. 5,500 5,500 5,500 5,500 5,500 01-110-54-00-5436 4TH OF JULY CONTRIBUTION - - 11,033 11,033`8 - - - 01-110-54-00-5440 TELECOMMUNICATIONS 14,085 19,659 20,000 20,000 20,000 20,000 20,000 20,000 20,000 01-110-54-00-5448 FILING FEES - 154 500 500. 500 500 500 500 500 01-110-54-00-5451 CODIFICATION 3,902 4,904 8,000. 8,000": 8,000 8,000 8,000 8,000 8,000 01-110-54-00-5452 POSTAGE&SHIPPING 4,449 (335),.. 14,000 14,000 8,000 8,000 8,000 8,000 8,000 01-110-54-00-5460 DUES&SUBSCRIPTIONS 12,368 16,701 16,600 16,600 17,000 17,000 17,000 17,000 17,000 01-110-54-00-5462 PROFESSIONAL SERVICES 13,581 8,722 20,000 20,000 20,000 20,000 20,000 20,000 20,000 01-110-54-00-5473 KENDALL AREA TRANSIT 23,550 23,550 ..30,000 30,000:: 30,000 30,000 30,000 30,000 30,000 01-110-54-00-5480 UTILITIES 13,887 16,636 18,900 18,900 21,735 23,039 24,421 25,886 27,439 01-110-54-00-5485 RENTAL&LEASE PURCHASE 1,716 2,079 2,150 2,300!" 2,400 2,400 2,400 2,400 2,400 01-110-54-00-5488 OFFICE CLEANING 14,202 14,352 14,400 14,400 17,500 17,500 17,500 17,500 17,500 5 r ff .. FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 01-110-56-00-5610 OFFICE SUPPLIES 8,015 9,162 12,000 12,000 12,000 12,000 12,000 12,000 12,000 O1-110-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - 850 850" 850 850 850 850 850 O1-110.56-00-5640 REPAIR&MAINTENANCE 69 100 100 100 100 100 100 100 476,541 710,199 807,387— 788,764 903,028 941,377 979,290 1,019,603 19062,571 6 FINANCE DEPARTMENT The Finance Department is responsible for the accounting,internal controls,external reporting and auditing of all financial transactions. The Finance Department is in charge of preparing for the annual audit,utility billing,receivables,payables,treasury management and payroll and works with administration in the preparation of the annual budget. Personnel are budgeted in the General and Water Funds. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 170,294 176,887 189,024 189,024 207,142 213,356 220,823 228,552 236,551 Benefits 29,628 60,326 64,571 64,137 73,202 78,730 84,590 90,918 97,793 Contractual Services 80,204 58,584 82,550 81,750 95,450 96,550 97,650 100,250 100,250 Supplies 4,042 2,105 5,250 5,250 5,100 5,100 5,100 5,100 5,100 Total Finance 284,168 297,902 341,395 340,161 380,894 393,736 408,163 424,820 439,694 $500 I $400 c m N o $300 t $200 $100 $0 7 FY 2012 FY 2013 FV 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual ` Budget Projected Adopted Projected Projected Projected Projected Finance 01-120-50-00-5010 SALARIES&WAGES 170,294 176,887 189,024 189,024< 207,142 213,356 220,823 228,552 236,551 01-120-52-00-5212 RETIREMENT PLAN CONTRIBUTION 16,586 19,266 20,742 20,742 24,703 27,310 29,966 32,866 36,074 01-120-52-00-5214 FICA CONTRIBUTION 13,042 13,410 14,166 14,166' 15,674 16,144 16,709 17,294 17,899 01-120-52-00-5216 GROUP HEALTH INSURANCE - 23,908 25,822 25,822. 27,773 29,995 32,395 34,987 37,786 01-120-52-00-5222 GROUP LIFE INSURANCE 357 357 3111 3 336 339 342 345 348 01-120-52-00-5223 DENTALINSURANCE - 3,061 3,160 2,7501 4,216 4,427 4,648 4,880 5,124 01-120-52-00-5224 VISION INSURANCE - 324 324 324 500 515 530 546 562 01-120-54-00-5412 TRAINING&CONFERENCES 670 1,850 2,000 2,000 2,500 2,500 2,500 2,500 2,500 01-120-54-00-5414 AUDITING SERVICES 44,800 31,000 3],000 31 000 f 35,200 36,300 37,400 40,000 40,000 01-120-54-00-5415 TRAVEL&LODGING 237 197 2,000 2,000 2,000 2,000 2,000 2,000 2,000 01-120-54-00-5430 PRINTING&DUPLICATING - 848 1,750 1,750' 2,500 2,500 2,500 2,500 2,500 01-120-54-00-5440 TELECOMMUNICATIONS 540 989 1,200 1,200 1,200 1,200 1,200 1,200 1,200 01-120-54-00-5452 POSTAGE&SHIPPING 648 920 750 750 4,000 4,000 4,000 4,000 4,000 01-120-54-00-5460 DUES&SUBSCRIPTIONS 480 535 800 800'. 800 800 800 800 800 01-120-54-00-5462 PROFESSIONAL SERVICES 27,255 20,410 40,000 40,0001 45,000 45,000 45,000 45,000 45,000 01-120-54-00-5485 RENTAL&LEASE PURCHASE 5,374 1,835 2,300 2,250 2,250 2,250 2,250 2,250 2,250 01-120-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 250 - 750 - - - - - - 01-120-56-00-5610 OFFICE SUPPLIES 1,955 2,019 2,500 2,5001''- 2,600 2,600 2,600 2,600 2,600 01-120-56-00-5630 SMALL TOOLS&EQUIPMENT - 86 250 250'' - - - - 01-120-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 2,087 - 2,500 2,500 2,500 2,500 2,500 2,500 2,500 284,168 297,902 341,395 340,161 380,894 393,736 408,163 424,820 439,694 8 POLICE DEPARTMENT The mission of the Yorkville Police Department is to work in partnership with the community to protect life and property,assist neighborhoods with solving their problems and enhance the quality of life in our City. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 2,028,011 2,185,748 2,434,547 2,434,547 2,659,683 2,842,517 2,935,145 3,031,015 3,130,240 Benefits 521,435 1,071,102 1,342,880 1,249,520 1,464,454 1,607,964 1,699,545 1,796,069 1,897,944 Contractual Services 163,951 157,048 209,350 209,350 284,908 312,767 301,267 280,267 291,267 Supplies 133,023 137,058 153,270 153,270 172,637 179,449 186,738 194,537 202,882 Total Police 2,846,420 3,550,956 4,140,047 4,046,687 4,581,682 4,942,697 5,122,695 5,301,888 5,522,333 $6,000 $5,000 v c o $4,000 L F $3,000 $2,000 $1,000 $0 9 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 F V 2017 F V 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Police 01-210-50-00-5008 SALARIES-POLICE OFFICERS 1,149,440 1,227,993 1,393,000 1,393,000 1,563,667 1,719,501 1,779,684 1,841,973 1,906,442 01-210-50-00-5011 SALARIES-POLICE CHIEF&DEPUTIES 303,452 274,717 299,674 299,674' 326,464 336,258 348,027 360,208 372,815 01-210-50-00-5012 SALARIES-SERGEANTS 297,081 392,598 435,746 435,746 448,639 462,098 478,271 495,010 512,335 01-210-50-00-5013 SALARIES-POLICE CLERKS 128,755 115,152 122,627 122,627 124,913 128,660 133,163 137,824 142,648 01-210-50-00-5014 SALARIES-CROSSING GUARD 19,413 19,192 20,000 20,000 20,000 20,000 20,000 20,000 20,000 01-210-50-00-5015 PART-TIME SALARIES 39,921 54,735 52,500 52,500.. 65,000 65,000 65,000 65,000 65,000 01-210-50-00-5020 OVERTIME 89,949 101,361 111;000 111,000` 111,000 111,000 111,000 111,000 111,000 01-210-52-00-5212 RETIREMENT PLAN CONTRIBUTION 11,696 12,297 13,590 13,590 14,897 16,468 18,070 19,819 21;754 01-210-52-00-5213 EMPLOYER CONTRIBUTION-POLICE PENSION 360,356 438,711 562,000 524..120 614,005 639,005 664,005 689,005 714,005 01-210-52-00-5214 FICA CONTRIBUTION 149,383 161,039 182,664 182,664.; 199,604 213,592 221,068 228,805 236,813 01-210-52-00-5216 GROUP HEALTH INSURANCE - 417,204 537,969 490,000 592,440 693,217 748,674 808,568 873,253 01-210-52-00-5222 GROUP LIFE INSURANCE 4,666 3,498 3,150 3,448 3,706 3,743 3,780 3,818 01-210-52-00-5223 DENTAL INSURANCE - 33,562 39,163 32,000r 35,713 37,499 39,374 41,343 43,410 01-210-52-00-5224 VISION INSURANCE - 3,623 3,996 3,996. 4,347 4,477 4,611 4,749 4,891 01-210-54-00-5410 TUITION REIMBURSEMENT 1,510 - 2,800 2,800 2,800 2,800 2,800 2,800 2,800 01-210-54-00-5411 POLICE COMMISSION 16,281 8,788 16,500 16,500' 15,000 4,000 15,000 4,000 15,000 01-210-54-00-5412 TRAINING&CONFERENCE 8,275 9,183 13,000 13L00 15,000 15,000 15,000 15,000 15,000 01-210-54-00-5415 TRAVEL&LODGING 6,690 2,579 10,000 10,000 10,000 10,000 10,000 10,000 10,000 01-210-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK - - 49,058 97,417 64,917 64,917 64,917 01-210-54-00-5426 PUBLISHING&ADVERTISING 11 359 200 200 200 200 200 200 200 01-210-54-00-5430 PRINTING&DUPLICATING 4,151 3,550 4,500 4,500: 4,500 4,500 4,500 4,500 4,500 01-210-54-00-5440 TELECOMMUNICATIONS 25,933 26,938 36,500 36,500 36,500 36,500 36,500 36,500 36,500 01-210-54-00-5452 POSTAGE&SHIPPING 1,346 1,210 3,000 3,000 3,000 3,000 3,000 3,000 3,000 01-210-54-00-5460 DUES&SUBSCRIPTIONS 1,340 898 1,350 1,350' 1,350 1,350 1,350 1,350 1,350 01-210-54-00-5462 PROFESSIONAL SERVICES 17,989 8,092 8,000 8,000':: 15,000 15,000 15,000 15,000 15,000 01-210-54-00-5466 LEGAL SERVICES - - 10,000 10,000. 20,000 10,000 20,000 10,000 10,000 01-210-54-00-5467 ADJUDICATION SERVICES 18,078 16,811 20,000 20,000 20,000 20,000 20,000 20,000 20,000 01-210-54-00-5469 NEW WORLD LIVE SCAN 10,944 11,660 15,000 15,000': 15,000 15,000 15,000 15,000 15,000 01-210-54-00-5472 KENDALL CO.JUVE PROBATION 2,389 3,406 4,000 4,000 I' 4,000 4,000 4,000 4,000 4,000 01-210-54-00-5484 MDT-ALERTS FEE 6,660 6,660 7,000 7,000. 7,000 7,000 7,000 7,000 7,000 01-210-54-00-5485 RENTAL&LEASE PURCHASE 4,224 5,761 6,500 6,500 6,500 7,000 7,000 7,000 7,000 01-210-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 38,130 51,153 51,000 51,000'-' 60,000 60,000 60,000 60,000 60,000 01-210-56-00-5600 WEARING APPAREL 17,449 18,710 16.000 16,000 20,000 20,000 20,000 20,000 20,000 01-210-56-00-5610 OFFICE SUPPLIES 2,266 4,646 4,500 4,500'. 4,500 4,500 4,500 4,500 4,500 01-210-56-00-5620 OPERATING SUPPLIES 6,491 18,356 8.000 8,000-i 10,000 10,000 10,000 10,000 10,000 10 ail Mh_ FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected O1-210-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 8,405 3,227 7,000 7,000 12,000 12,000 12,000 12,000 12,000 O1-210-56-00-5640 REPAIR&MAINTENANCE 12,821 5,767 12,250 12,250 12,250 12,250 12,250 12,250 12,250 O1-210-56-00-5650 COMMUNITY SERVICES 77 - 7,370 7,370 7,370 7,370 7,370 7,370 7,370 O1-210-56-00-5690 SUPPLIES-GRANT REIMBURSABLE 4,314 3,025 4,200 4,200 4,200 4,200 4,200 4,200 4,200 O1-210-56-00-5695 GASOLINE 79,977 81,459 90,950 90,950 97,317 104,129 111,418 119,217 127,562 01-210-56-00-5696 AMMUNITION 1,223 1,868 3,000 3,000 5,000 5,000 5,000 5,000 5,000 2,846,420 3,550,956 4,140,047, 4,046,687 4,581,682 4,942,697 5,122,695 5,301,888 5,522,333 11 COMMUNITY DEVELOPMENT DEPARTMENT The primary focus of the Community Development Department is to ensure that all existing and new construction is consistent with the overall development goals of the City which entails short and long-range planning,administration of zoning regulations,building permits issuance and code enforcement.The department also provides staff support to the City Council,Plan Commission,Zoning Board of Appeals and Park Board and assists in the review of all development plans proposed within the United City of Yorkville. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 188,249 199,396 225,666 225,666 327,457 336,381 347,104 358,203 369,690 Benefits 31,460 84,415 93,377 93,377 122,541 131,868 141,798 152,523 164,167 Contractual Services 83,661 65,944 81,750 81,750 139,622 141,769 89,794 91,900 94,090 Supplies 3,683 15,434 11,535 11,535 13,934 12,227 12,540 12,875 13,234 Total Community Development 307,053 365,189 412,328 412,328 603,554 622,245 591,236 615,501 641,181 $700 c $600 o $500 s $400 $300 $200 $100 $0 12 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Community Development ,u 01-220-50-00-5010 SALARIES&WAGES 188,249 183,615 195,666 195,666- 297,457 306,381 317,104 328,203 339,690 01-220-50-00-5015 PART-TIME SALARIES - 15,781 30,000 30,000 30,000 30,000 30,000 30,000 30,000 01-220-52-00-5212 RETIREMENT PLAN CONTRIBUTION 17,492 19,592 21,685 21,685 35,474 39,217 43,031 47,196 51,803 01-220-52-00-5214 FICA CONTRIBUTION 13,968 14,716 16,953 16,953 24,681 25,421 26,311 27,232 28,185 01-220-52-00-5216 GROUP HEALTH INSURANCE - 45,833 50,430 50,430 58,362 63,031 68,073 73,519 79,401 01-220-52-00-5222 GROUP LIFE INSURANCE - 511 325[. 325 447 451 456 461 466 01-220-52-00-5223 DENTAL INSURANCE 3,393 3,605 3,605 3,187 3,346 3,513 3,689 3,873 01-220-52-00-5224 VISION INSURANCE - 370 379 379 390 402 414 426 439 01-220-54-00-5412 TRAINING&CONFERENCES 1,144 1,863 2,000 2,000 3,000 3,000 3,000 3,000 3,000 01-220-54-00-5415 TRAVEL&LODGING 573 631 17500. 1,5001:! 2,000 2,000 2,000 2,000 2,000 01-220-54-00-5426 PUBLISHING&ADVERTISING 185 291 500 500 1,000 1,000 1,000 1,000 1,000 01-220-54-00-5430 PRINTING&DUPLICATING 994 1,368 4,250 4,250! 4,250 4,250 4,250 4,250 4,250 01-220-54-00-5440 TELECOMMUNICATIONS 1,736 2,410 3,000 3,000 3,000 3,000 3,000 3,000 3,000 01-220-54-00-5452 POSTAGE&SHIPPING 719 862 1,000 1,0001'<' 1,000 1,000 1,000 1,000 1,000 01-220-54-00-5459 INSPECTIONS 26,060 - 10,000 10,000:: 10,000 10,000 10,000 10,000 10,000 01-220-54-00-5460 DUES&SUBSCRIPTIONS 1,075 2,803 2,000 2,000 2,000 2,000 2,000 2,000 2,000 01-220-54-00-5462 PROFESSIONAL SERVICES 1,026 5,692 6,000 6,000..4 60,000 60,000 6,000 6,000 6,000 01-220-54-00-5466 LEGAL SERVICES 3,511 1,869 2,000 2,000 2,000 2,000 2,000 2,000 2,000 01-220-54-00-5485 RENTAL&LEASE PURCHASE 1,638 3,155 2,700 2,700 2,700 2,900 2,900 2,900 2,900 01-220-54-00-5486 ECONOMIC DEVELOPMENT 45,000 45,000 46,800 46,800 48,672 50,619 52,644 54,750 56,940 01-220-56-00-5610 OFFICE SUPPLIES 311 520 500 500('- 750 750 750 750 750 01-220-56-00-5620 OPERATING SUPPLIES 2,928 2,249 3,000 3,000 5,000 3,000 3,000 3,000 3,000 01-220-56-00-5630 SMALL TOOLS&EQUIPMENT - 61 125 125 - - _ 01-220-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - 9,153 3,500 3,500 3,500 3,500 3,500 3,500 3,500 01-220-56-00-5645 BOOKS&PUBLICATIONS 444 382 500 500 500 500 500 500 500 01-220-56-00-5695 GASOLINE - 3,069 3,910 3,910 4,184 4,477 4,790 5,125 5,484 307,053 365,189 412,328 412,328 603,554 622,245 591,236 615,501 641,181 13 PUBLIC WORKS DEPARTMENT - STREET OPERATIONS/HEALTH & SANITATION The Public Works Department is an integral part of the United City of Yorkville. We provide high quality drinking water,efficient disposal of sanitary waste and maintain a comprehensive road and storm sewer network to ensure the safety and quality of life for the citizens of Yorkville. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 260,348 267,730 327,962 327,962 339,283 343,037 354,518 366,401 378,700 Benefits 44,246 139,666 163,688 163,688 177,193 188,418 202,788 218,303 235,123 Contractual Services 1,314,041 1,169,135 1,509,250 1,482,901 1,304,171 1,269,467 1,301,767 1,335,044 1,369,328 Supplies 85,167 71,058 104,105 105,105 90,678 93,101 95,684 98,437 101,372 Total Public Works 1,703,802 1,647,589 2,105,005 2,079,656 1,911,325 1,894,023 1,954,757 2,018,185 2,084,523 $2,500 v c $2,000 0 L ~ $1,500 $1,000 $500 $0 14 FY 2012 FV2013 FV2014 FV2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Public Works-Street Operations 01-410-50-00-5010 SALARIES&WAGES 253,695 263,824 312,962 312,962 318,483 328,037 339,518 351,401 363,700 01-410-50-00-5015 PART-TIME SALARIES 5800 5`�. , - 01-410-50-00-5020 OVERTIME 6,653 3,906 15,000 15,000 15,000 15,000 15,000 15,000 15,000 01-410-52-00-5212 RETIREMENT PLAN CONTRIBUTION 24,887 28,590 36,347 36,347 39,770 41,989 46,073 50,531 55,464 01-410-52-00-5214 FICA CONTRIBUTION 19,359 19,795 24,510 24,510 25,253 25,553 26,447 27,373 28,331 01-410-52-00-5216 GROUP HEALTH INSURANCE - 82,763 94,362 94,362. 104,498 112,858 121,887 131,638 142,169 01-410-52-00-5222 GROUP LIFE INSURANCE 1,251 635 635 570 576 582 588 594 01-410-52-00-5223 DENTAL INSURANCE - 6,564 7,095 7,095 6,341 6,658 6,991 7,341 7,708 01-410-52-00-5224 VISION INSURANCE - 703 739 739 761 784 808 832 857 01410-54-00-5412 TRAINING&CONFERENCES 1,440 834 2,000 2,000 4,000 4,000 4,000 4,000 4,000 01-410-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK - - 144,650 144,650 97,370 41,315 41,315 41,315 41,315 01-410-54-00-5435 TRAFFIC SIGNAL MAINTENANCE - - 20,000 20,000 20,000 20,000 20,000 20,000 20,000 01-410-54-00-5440 TELECOMMUNICATIONS 2,506 2,395 3,000 3,000 3,000 3,000 3,000 3,000 3,000 01-410-54-00-5446 PROPERTY&BLDG MAINT SERVICES 18,329 13,984 22,500 22,50D'. _ _ _ - _ 01410-54-00-5454 SIDEWALK PROGRAM 869 110 - 01-410-54-00-5455 MOSQUITO CONTROL 6,500 6,730 8,000 8,000 8,000 8,400 8,820 9,261 9,724 01-410-54-00-5458 TREE&STUMP REMOVAL 6,025 17,080 20,000 20,000 30,000 20,000 20,000 20,000 20,000 01-410-54-00-5462 PROFESSIONAL SERVICES 370 773 1.,000 1,000'i': 1,000 1,000 1,000 1,000 1,000 01-410-54-00-5480 UTILITIES 57,145 53,803 94,500 90,000:. - _ _ - 01-410-54-00-5485 RENTAL&LEASE PURCHASE 1,051 1,181 1,100 1,100 1,100 1,100 1,100 1,100 1,100 01410-54-00-5490 VEHICLE MAINTENANCE SERVICES 20,886 28,769 20,000 20,000 25,000 25,000 25,000 25,000 25,000 01-410-54-00-5495 OUTSIDE REPAIR&MAINTENCE 600 - - - 2,000 2,000 2,000 2,000 2,000 01410-56-00-5600 WEARING APPAREL 2,581 2,921 4,200 4,200` 4,200 4,200 4,200 4,200 4,200 01-410-56-00-5620 OPERATING SUPPLIES 10,648 7,364 9,975 9,975[ 10,000 10,500 11,025 11,576 12,155 01410-56-00-5626 HANGING BASKETS 2,041 - - - 2,000 2,000 2,000 2,000 2,000 01410-56-00-5628 VEHICLE MAINTENANCE SUPPLIES - - 20,000 20,000: 25,000 25,000 25,000 25,000 25,000 01-410-56-00-5630 SMALL TOOLS&EQUIPMENT 7,962 2,691 1,750 '.2,750.:'. 2,000 2,000 2,000 2,000 2,000 01410-56-00-5640 REPAIR&MAINTENANCE 22,671 30,984 20,000 20,000< 20,000 20,000 20,000 20,000 20,000 01410-56-00-5656 PROPERTY&BLDG MAINT SUPPLIES 8,240 3,894 22,500 22,500 - _ - _ _ 01-410-56-00-5695 GASOLINE 31,024 23,204 25,680 25,680 27,478 29,401 31,459 33,661 36,017 505,482 604,113 932,505 929,005 798,624 750,371 779,225 809,817 842,334 15 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Public Works-Health&Sanitation 01-540-54-00-5441 GARBAGE SERVICES-SENIOR SUBSIDY - 136,335 143,000 14 3,000 75,000 75,000 75,000 75,000 75,000 01-540-54-00-5442 GARBAGE SERVICES 1,193,400 903,061 1,023,500 1,001,651'; 1,031,701 1,062,652 1,094,532 1,127,368 1,161,189 01-540-54-00-5443 LEAF PICKUP 4,920 4,080 6,000 6,000" 6,000 6,000 6,000 6,000 6,000 1,198,320 1,043,476 1,172,500. 1,150,651 1,112,701 1,143,652 1,175,532 1,208,368 1,242,189 Total Public Works 1,703,802 1,647,589 2,1.05,005 2,079,656': 1,911,325 1,894,023 1,954,757 2,018,185 2,084,523 16 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,engineering services,corporate legal expenditures and interfund transfers. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Expenditures Salaries 350 100 500 500 500 500 500 500 500 Benefits 1,709,445 315,471 352,518 326,216 343,647 353,991 374,285 396,283 419,141 Contractual Services 2,186,393 1,947,060 1,889,740 2,040,242 2,291,529 2,283,789 2,356,692 2,422,265 2,446,537 Supplies 2,910 25,649 5,000 5,000 5,000 5,000 5,000 5,000 5,000 Contingencies 52,075 - 50,000 11,675 - - - - - Other Financing Uses 1,297,950 1,501,502 3,798,673 3,796,914 2,548,953 2,654,963 2,823,942 3,020,169 3,189,327 Total Admin Services&Transfers 5,249,123 3,789,782 6,096,431 6,180,547 5,189,629 5,298,243 5,560,419 5,844,217 6,060,505 $7,000 E $6,000 C ,p 3 a $5,000 s � ~ $4,000 1 $3,000 $2,000 $1,000 $0 17 FY 2012 FY 2013 FY 2014 FY 2014 FV 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Administrative Services O1-640-50-00-5092 POLICE SPECIAL DETAIL WAGES 350 100 500 500 500 500 500 500 500 O1-640-52-00-5216 GROUP HEALTH INSURANCE 1,199,018 - - _ O1-640-52-00-5222 GROUP LIFE INSURANCE 14,022 _ O1-640-52-00-5223 DENTAL INSURANCE 86,598 ', O1-640-52-00-5224 VISION INSURANCE 10,117 O1-640-52-00-5230 UNEMPLOYMENT INSURANCE 91,200 7,024 45,000 30,000 30,000 30,000 30,000 30,000 30,000 01-640-52-00-5231 LIABILITY INSURANCE 308,490 213,976 <'261,302 250,000 265,000 280,900 297,754 315,619 334,556 O1-640-52-00-5240 RETIREES-GROUP HEALTH INSURANCE - 88,868 '44,723 44,72; 47,149 42,021 45,383 49,014 52,935 01-640-52-00-5241 RETIREES-DENTAL INSURANCE - 5,025 I,,33 I.,,33 1,333 950 998 1,500 1,500 O1-640-52-00-5242 RETIREES-VISION INSURANCE - 578 160 160 165 120 150 150 150 O1-640-54-00-5439 AMUSEMENT TAX REBATE - - 25,000 25,000 50,000 50,000 50,000 37,500 37,500 01-640-54-00-5449 KENCOM - 22,000 26,000 26,000 150,000 200,000 250,000 300,000 300,000 O1-640-54-00-5450 INFORMATION TECHNOLOGY SERVICES 55,155 86,654 90,000 90,000 174,500 99,225 104,186 109,395 114,865 O1-640-54-00-5456 CORPORATE COUNSEL 81,998 81,042 110,000 1 10,000:. 115,500 121,275 127,339 133,706 140,391 01-640-54-00-5461 LITIGATION COUNSEL 70,469 44,826 60,000 60,000'1 60,000 60,000 60,000 60,000 60,000 O1-640-54-00-5462 PROFESSIONAL SERVICES 450 451 500 153 - _ _ _ 01-640-54-00-5463 SPECIAL COUNSEL 25,261 2,771 25,000 25,000 25,000 25,000 25,000 25,000 25,000 O1-640-54-00-5465 ENGINEERING SERVICES 222,269 406,630 18Q000 290,000. 290,000 290,000 290,000 290,000 290,000 01-640-54-00-5475 CABLE CONSORTIUM FEE 93,150 70,613 85,000 85,000 85,000 85,000 85,000 85,000 85,000 O1-640-54-00-5479 COMMUNITY RELATIONS 440 - - -+' _ _ _ O1-640-54-00-5481 HOTEL TAX REBATE 45,926 48,473 45,000 54,000 54,000 54,000 54,000 58,500 58,500 O1-640-54-00-5491 CITY PROPERTY TAX REBATE 1,532 1,196 : 1,800 1,369 1,500 1,500 1,500 1,500 1,500 01-640-54-00-5492 SALES TAX REBATE 1,024,421 745,572 832,240 850,000' 858,500 867,085 875,756 884,514 893,359 O1G40-54-00-5493 BUSINESS DISTRICT REBATE 305,908 314,385 300,000 315,000+1' 317,529 320,704 323,911 327,150 330,422 O1-640-54-00-5494 ADMISSIONS TAX REBATE 104,845 119,199 104,500 103,720' 105,000 105,000 105,000 105,000 105,000 01-640-54-00-5499 BAD DEBT 154,569 3,248 5,000 5,000' 5,000 5,000 5,000 5,000 5,000 01-640-56-00-5625 REIMBURSABLE REPAIRS 2,910 25,649 5,000 5,000 5,000 5,000 5,000 5,000 5,000 O1-640-70-00-7799 CONTINGENCIES 52,075 - 50,000 11,675' - _ _ 01-640-99-00-9916 TRANSFER TO MUNICIPAL BUILDING - - 573,374. 57.1,615 01-640-99-16-9923 TRANSFER TO CW CAP BLDG&GROUNDS - low - �_ 105,000 55,000 60,000 60,000 60,000 ,. as 01-640-99-23-9923 TRANSFER TO CITYWIDE CAPITAL 125,000 419,332+, 39,241 87,765 g 01-640-99-00-9942 TRANSFER TO DEBT SERVICE 103,740 99,465 r 91,547 191,854 284,854 338,694 4 ' 16 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 01-640-99-00-9952 TRANSFER TO SEWER - - 1,137,220 1,137,220 1,133,972 1,134,654 1,134,052 1,137,166 1,133,782 01-640-99-00-9979 TRANSFER TO PARKS&RECREATION 736,710 955,886 1,765,504 1,765,504 1,277,606 1,339,594 1,401,968 1,460,826 1,531,004 01-640-99-00-9982 TRANSFER TO LIBRARY OPERATIONS-P-TAX - - 21,490 21,490 - - - - - 01-640-99-00-9982 TRANSFER TO LIBRARY OPERATIONS 332,500 26,b19 30,684 30,684 32,375 34,168 36,068 38,082 38,082 5,249,123 3,789,782 6,096,431 6,1.80,547 5,189,629 5,298,243 5,560,419 5,844,217 6,060,505 Expenditures 10,969,330 10,361,617 13,902,593 13,848,143 13,570,112 14,092,321 14,616,560 15,224,214 15,810,807 Surplus(Deficit) 1,542,522 2,953,193 (893,104) (506,280)., 156,513 (233,768) (548,420) (1,005,794 (1,444,377) Fund Balance 1,270,623 4,223,820 2,541,653 3,717,540`. 3,874,053 3,640,285 3,091,865 2,086,071 641,694 11.58% 40.76% 78.28% 26.85% 28.55% 25.83% 21.15% 13.70910 4.06% 19 Fox Hill SSA Fund(11) This fund was created for the purpose of maintaining the common areas of the Fox Hill Estates(SSA 2004-201)subdivision. All money for the fund is derived from property taxes levied on homeowners in the subdivision. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 3,786 3,786 3,786 3,786 8,536 8,536 8,536 8,536 8,536 Investment Earnings 7 10 - 1 - - - - - Total Revenue 3,793 3,796 3,786 3,787 8,536 8,536 8,536 8,536 8,536 Expenditures Contractual Services 4,664 5,743 7,500 7,690 19,603 19,603 4,603 4,603 4,603 Total Expenditures 4,664 5,743 7,500 7,690 19,603 19,603 4,603 4,603 4,603 Surplus(Deficit) (871) (1,947) (3,714) (3,903) (11,067) (11,067) 3,933 3,933 .3,933 Ending Fund Balance 17,071 15,124 11,677 11,221 154 (10,913) (6,980) (3,047) 886 366.02% 263.35% 155.69% 145.92% 0.79% -55.67% -151.64% -66.20% 19.25% $20 Fund Balance N r N $10 z $0 ($10) ($20) 20 FY 2012 FV 2013 FY 2014 FV 2014 FV 2015 FV 2016 FV 2017 FV 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Fox Hill SSA-11 11-00040-004000 PROPERTY TAXES 3,786 3,786 3.786 3,786 8,536 8,536 8,536 8,536 8,536 11-00045-004500 INVESTMENT EARNINGS 7 10 ] Revenue 3,793 3,796 3,786 3,787 8,536 8,536 8,536 8,536 8,536 11-111-54-00-5417 TRAIL MAINTENANCE - - - 15,000 15,000 - _ _ 11-111-54-00-5466 LEGAL SERVICES - - - 190 - - - 11-111-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 4,664 5,743 7,500 7,500 4,603 4,603 4,603 4,603 4,603 Expenditures 4,664 5,743 7,500 7,690 19,603 19,603 4,603 4,603 4,603 Surplus(Deficit) (871) (1,947) (3,714) (3,903) (11,067) (11,067) 3,933 3,933 3,933 Fund Balance 17,071 15,124 11,677 11,221 154 (10,913) (6,980) (3,047) 886 366.02% 263.35% 155.69% 115.92% 0.79% -55.67% -151.64% -66.20% 19.25% 21 Sunflower SSA Fund(12) This fund was created for the purpose of maintaining the common areas of the Sunflower Estates(SSA 2006-119)subdivision. All money for the fund is derived from property taxes levied on homeowners in the subdivision. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 7,530 7,530 7,531 7,467 17,416 17,416 17,416 17,416 17,416 Investment Earnings 7 14 - 2 - - - - - Total Revenue 7,537 7,544 7,531 7,469 17,416 17,416 17,416 17,416 17,416 Expenditures Contractual Services 7,272 11,992 14,985 14,985 35,985 35,985 10,985 10,985 10,985 Total Expenditures 7,272 11,992 14,985 14,985 35,98.5 35,985 10,985 10,985 10,985 Surplus(Deficit) 265 (4,448) (7,454) (7,516) (18,569) (18,569) 6,431 6,431 6,431 Ending Fund Balance 12,188 7,740 560 224 (18,345) (36,914) (30,483) (24,052) (17,621) 167.60% 64.54% 3.74% 1.49% -50.98% -102.58% -277.50% -218.95% -160.41% $20 Fund Balance y V C 0 $0 t° �- ($20) ($40) 22 FV 2012 FV 2013 FV 2014 FY 2014 FY 2015 FY 2016 FV 2017 FV 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Sunflower SSA-12 12-000-40-00.4000 PROPERTY TAXES 7,530 7.530 7,531 7,467 17,416 17,416 17,416 17,416 17,416 12-000 45-004500 INVESTMENT EARNINGS 7 14 2 Revenue 7,537 7,544 7,531 7,469. 17,416 17,416 17,416 17,416 17,416 12-112-54-00-5416 POND MAINTENANCE - 25,000 25,000 - 12-112-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 7,272 11,992 14,985 14,985 10,985 10,985 10,985 10,985 10,985 Expenditures 7,272 11,992 14,985 14,985. 35,985 35,985 10,985 10,985 10,985 Surplus(Deficit) 265 (4,448) (7,454) (7,516), (18,569) (18,569) 6,431 6,431 6,431 Fund Balance 12,188 7,740 560 224 (18,345) (36,914) (30,483) (24,052) (17,621) 16760% 64.54% 3.74% 1.49/" 50.98% -102.58% -277.50% -218.95% -160.41% 23 Motor Fuel Tax Fund (15) The Motor Fuel Tax Fund is used to maintain existing and construct new City owned roadways,alleys and parking lots. The fund also purchases materials used in the maintenance and operation of those facilities. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Intergovernmental 560,028 515,218 942,000 1,113,186 480,000 440,000 440,000 440,000 440,000 Investment Earnings 570 3,368 2,000 3,500 3,000 3,000 3,000 3,000 3,000 Reimbursements - 257 - 110 - - - - - Total Revenue 560,598 518,843 944,000 1,116,796 483,000 443,000 443,000 443,000 443,000 Expenditures Contractual Services - 7,500 23,500 23,500 111,000 117,210 123,793 130,771 130,667 Supplies 200,355 142,773 219,556 143,556 178,712 188,468 198,869 209,963 214,144 Capital Outlay 75,786 130,923 1,186,400 1,111,400 573,787 373,787 373,787 227,787 177,787 Total Expenditures 276,141 281,196 1,429,456 1,278,456 863,499 679,465 696,449 568,521 522,598 Surplus(Deficit) 284,457 237,647 (485,456) (161,660) (380,499) (236,465) (253,449) (125,521) (79,598) Ending Fund Balance 924,857 1,162,506 605,132 1,000,846 620,347 383,882 130,433 4,912 (74,686) $1,500 Fund Balance $1,000 0 0 r $500 $0 ($500) 24 FY 2012 FY 2013 FY 2014 FY 2014 _ FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual :Budget Projected Adopted Projected Projected Projected Projected Motor Fuel Tax-15 _ 15-00041-004112 MOTOR FUEL TAX 417,416 402,932 410,000 400,000: 400,000 400,000 400,000 400,000 400,000 15-00041-004113 MFT HIGH GROWTH 39,197 39,164 40,000 41,814 f 40,000 40,000 40,000 40,000 40,000 15-000-41-00-4172 ILLINOIS JOBS NOW PROCEEDS 73,122 73,122 - 73,122 - _ - _ _ 15-00041-004183 FEDERAL GRANTS-GAME FARM RD ROW 30,293 - - 106,250 15-00041-004184 STATE GRANTS-DOWNTOWN PARKING LOT - - 492,000 492,000 15-00041-00-4185 STATE GRANTS-MATERIALS STORAGE FACILITY - 40,000 - - _ _ 15-00045-004500 INVESTMENT EARNINGS 570 3,368 2,000 1,500` 3,000 3,000 3,000 3,000 3,000 15-00046-00 4690 REIMB-MISCELLANEOUS 257 110 Revenue 560,598 518,843 ::.944,000 .1,116,796: 483,000 443,000 443,000 443,000 443,000 15-155-54-00-5438 SALT STORAGE - 7,500 7,500 7,500: 7,500 7,500 7,500 7,500 - 15-155-54-00-5482 STREET LIGHTING - - 103,500 109,710 116,293 123,271 130,667 15-155-54-00-5495 OUTSIDE REPAIR&MAINTENANCE - - 16,000 :16,000' - - _ _ _ 15-155-56-00-5618 SALT 129,391 58,875 126,000 100,000(' 132,300 138,915 145,861 153,154 153,154 15-155-56-00-5619 SIGNS 6,732 15,943 15,000 15,000:. 15,000 15,000 15,000 15,000 15,000 15-155-56-00-5632 PATCHING 47,093 47,007 50,000 - - _ _ _ 15-155-56-00-5633 COLD PATCH 5,855 10,621 12,826 12,826 14,109 15,520 17,072 18,779 20,657 15-155-56-00-5634 HOT PATCH 11,284 10,327 15,730 1.5,730 17,303 19,033 20,936 23,030 25,333 15-155-60-00-6003 MATERIAL STORAGE BLDG CONSTRUCTION - 75,000 75,000 _ _ 15-155-60-00-6004 BASELINE ROAD BRIDGE REPAIRS - 50,000 - - _ _ 15455-60-00-6025 ROAD TO BETTER ROADS PROGRAM - - 250,000 250,0004; 275,000 300,000 300,000 154,000 104,000 15-155-60-00-6072 DOWNTOWN PARKING LOT 875 24,271 492,000 492,000 - - _ _ _ 15-155-60-00-6073 GAME FARM ROAD PROJECT 68,086 30,000 212,500 212,500 15-155-60-00-0075 RIVER ROAD BRIDGE PROJECT 6,825 - - - - 15-155-60-00-6079 ROUTE 47 EXPANSION - 76,652 131,900 121,900 73,787 73,787 73,787 73,787 73,787 15-155-60-00-6089 CANNONBALL LAFO PROJECT 35,000 35,000 100,000 Expenditures 276,141 281,196 :1,429,456 1,278,456': 863,499 679,465 696,449 568,521 522,598 Surplus(Deficit) 284,457 237,647 (485,456) (161,660). (380,499) (236,465) (253,449) (125,521) (79,598) Fund Balance 924,857 1,162,506 605,132 1,000,846 620,347 383,882 130,433 4,912 (74,686) 25 City-Wide Capital Fund (23) The City-Wide Capital Fund is used to maintain existing and construct new public and municipal infrastructure,and to fund other improvements that benefit the public. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Intergovernmental - 61,635 327,600 425,965 105,960 39,000 114,160 12,720 - Licenses&Permits 92,417 94,675 20,250 15,250 20,250 20,250 20,250 20,250 20,250 Charges for Service - - 669,120 682,667 680,000 680,000 680,000 680,000 680,000 Investment Earnings 114 243 250 200 3,000 2,000 100 - - Reimbursements 9,586 20,007 327,551 213,010 885,630 7,000 294,740 32,780 - Other Financing Sources 125,000 457,182 435,401 732,101 4,855,000 55,000 60,000 99,241 147,765 Total Revenue 227,117 633,742 1,780,172 2,069,193 6,549,840 803,250 1,169,250 844,991 848,015 Expenditures Contractual Services 14,780 175,608 50,000 50,000 130,000 77,500 80,000 80,000 80,000 Supplies - - - - 25,000 27,500 30,000 30,000 30,000 Capital Outlay 6,793 210,605 1,323,973 1,606,266 2,303,022 4,304,700 1,222,088 358,000 312,500 Debt Service 125,000 - 83,333 75,000 85,000 416,554 418,665 419,705 420,265 Other Financing Uses - - 5,250 5,250 5,250 5,250 5,250 5,250 5,250 Total Expenditures 146,573 386,213 1,462,556 1,736,516 2,548,272 4,831,504 1,756,003 892,955 848,015 Surplus(Deficit) 80,544 247,529 317,616 332,677 4,001,568 (4,028,254) (586,753) (47,964) - Municipal Building Fund Balance - - - - - - - - - City-Wide Capital Fund Balance 81,196 328,726 691,053 661,403 4,662,971 634,717 47,964 - - Ending Fund Balance 81,196 328,726 691,053 661,403 4,662,971 634,717 47,964 - - $5,000 Fund Balance $4,000 c $3,000 $2,000 $1,000 $0 26 5 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected City-Wide Capital-23 23-000-41-00-4161 FEDERAL GRANTS-ITEP DOWNTOWN - - - 32,000 32,000 23-00041-004162 FEDERAL GRANTS-RIVER RD BRIDGE 61,635 - 98,365 - _ 23-000-41-004176 FEDERAL GRANTS-SAFE ROUTE TO SCHOOL - - 280,000 280,000 - _ - _ _ 23-00041-004178 FEDERAL GRANTS-ITEP KENNEDY RD TRAIL - - 47,600` 47,600 73,960 7,000 114,160 12,720 - 23-000-42-00-4210 BUILDING PERMITS 30,993 10,660 - - _ - - - _ 23-000-42-004213 ENGINEERING CAPITAL FEE 4,700 - - _ - _ 23-00042-00-4214 DEVELOPMENT FEES-CW CAPITAL 7,944 3,135 5,000 5,000 5,000 5,000 5,000 5,000 5,000 23-00042-00-4216 BUILD PROGRAM PERMITS 14,780 80,880 - - _ - _ _ - 23-00042-004218 DEVELOPMENT FEES-MUNICIPAL BLDG - - 5,^_50 5,250 5,250 5,250 5,250 5,250 5,250 23-00042-004222 ROAD CONTRIBUTION FEE 34,000 - 10,000 5,000 10,000 10,000 10,000 10,000 10,000 23-000-44-004440 ROAD INFRASTRUCTURE FEE - 669,120 682,667 680,000 680,000 680,000 680,000 680,000 23-000-45-00-4500 INVESTMENT EARNINGS 114 243 250 200 3,000 2,000 100 - _ 23-000-46-00-4620 REIMB-PULTE(AUTUMN CREEK) - - 201,110 201,110 861,890 - - _ 23-000-46-004660 REIMB-PUSH FOR THE PATH - 20,007 126,441 11,000 23,740 7,000 294,740 32,780 - 23-000-46-00-4690 REIMB-MISCELLANEOUS 9,586 - - - _ 23-00049-004900 BOND PROCEEDS - 4,750,000 - _ _ 23-00049-164901 TRANSFER FROM GENERAL-CW B&G - - - _ 105,000 55,000 60,000 60,000 60,000 23-00049-234901 TRANSFER FROM GENERAL-CW CAPITAL 125,000 419,332 270,401 270,401 - - - 39,241 87,765 23-00049-004905 LOAN PROCEEDS-RIVER ROAD BRIDGE 37,850 165,000 461,700 Revenue 227,117 633,742 1,780,172 2,069,193 6,549,840 803,250 1,169,250 844,991 848,015 City-Wide Building&Grounds Expenditures ; w 23-216-54-00-5405 BUILD PROGRAM 23-216-54-00-5446 PROPERTY&BLDG MAINT SERVICES 80,000 27,500 30,000 30,000 30,000 23-216-56-00-5656 PROPERTY&BLDG MAINT SUPPLIES - - 25,000 27,500 30,000 30,000 30,000 23-216-99-00-9901 TRANSFER TO GENERAL - Sk 0 5,250 5,250 5,250 5,250 5,250 ,. 5,2$0 3,2 110,250 60,250 65,250 65,250 65,250 City-Wide Capital Expenditures 23-230-54-00-5405 BUILD PROGRAM 14,780 80,880 _ 23-230-54-00-5462 PROFESSIONAL SERVICES - 94,728 23-230-54-00-5465 ENGINEERING SERVICES - 50,000 50,000 50,000 50,000 50,000 50,000 50,000 23-230-60-00.6007 KENNEDY RD-AUTUMN CREEK 201,110 201,110 1,139,622 - _ _ _ 23-230-60-00-6025 ROAD TO BETTER ROADS PROGRAM 585,863 585,863 390,000 300,000 300,000 300,000 300,000 27 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 - Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 23-230-60-00-6041 SIDEWALK CONSTRUCTION - - 12,500 12,500 12,500 12,500 12,500 12,500 12,500 23-230-60-00-6048 DOWNTOWN STREETSCAPE IMPROVEMENT - 40,000 40,000 - - _ 23-230-60-00-6058 ROUTE 71(RTE 47/ORCHARD RD)PROJECT - 110,400 23-230-60-00-6059 US 34(IL 47/ORCHARD RD)PROJECT - - - ' - 230,200 - - 23-230-60-00-6073 GAME FARM ROAD PROJECT 20,000 20,000 258,000 3,827,800 500,688 23-230-60-00-6075 RIVER ROAD BRIDGE PROJECT - 152,707 165,000 447,293 - - - 23-230-60-00-6092 SAFE ROUTE TO SCHOOL PROJECT 6,793 37,891 280,000 280,000 - - - _ 23-230-60-00-6094 KENNEDY RD BIKE TRAIL - 20,007 59,500 59,500 97,700 14,000 408,900 45,500 - 23-230-60-00-6095 SUNFLOWER ESTATES-DRAINAGE IMPROVEMENT - - - - 135,000 - - - _ 2015 Bond 23-230-81-00-8000 PRINCIPAL PAYMENT - - - - 200,000 180,000 185,000 190,000 23-230-81-00-8050 INTEREST PAYMENT 131,554 153,665 149,705 145,265 Kendall County Loan-River Road Bridge = 23-230-97-00-8000 PRINCIPAL PAYMENT - 83,333 '.. - .75,000 85,000 85,000 85,000 85,000 85,000 Clark Property 23-230-97-00-8000 PRINCIPAL PAYMENT 125,000 146,573 386,213 1,457,306 1,731,266 2,438,022 4,771,2.54 1,690,753 827,705 782,765 Expenditures 146,573 386,213 1,462,556 1,736,516 2,548,272 4,831,504 1,756,003 892,955 848,015 Surplus(Deficit) 80,544 247,529 317,616 .332,677. 4,001,568 (4,028,254) (586,753) (47,964) - Fund Balance-Municipal Building - - - - - - - - FundBalance-City WuleCapital 81,196 328,726 691,053 661,4113 4,662,971 634,717 47,964 Fund Balance 81,196 328,726 691,053 661,403 4,662,971 634,717 47,964 - - 25 Vehicle and Equipment Fund(25) This fund was created in Fiscal Year 2014,consolidating the Police Capital,Public Works Capital and Park&Recreation Capital funds. This fund primarily derives its revenue from monies collected from building permits and development fees. The revenue is used to purchase vehicles and equipment for use in the operations of the Police,Public Works and Parks &Recreation Departments. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Licenses&Permits 55,000 84,459 49,275 61,539 49,275 49,275 49,275 49,275 49,275 Fines&Forfeits 6,233 16,739 8,850 12,750 10,750 10,750 10,750 10,750 10,750 Charges for Service 6,040 6,725 150,150 153,342 262,078 161,726 112,232 112,232 112,232 Investment Earnings 405 567 475 450 450 450 450 450 450 Reimbursements 10,702 - 50,000 50,000 50,000 50,000 - - - Miscellaneous - 966 - 448 1,000 1,000 1,000 1,000 1,000 Other Financing Sources 19,600 2,700 1,000 7,825 61,000 1,000 1,000 1,000 1,000 Total Revenue 979980 112,156 259,750 286,354 434,553 274,201 174,707 174,707 174,707 Police Capital Expenditures Contractual Services 2,647 17,710 11,667 11,667 17,667 17,667 17,667 17,667 17,667 Capital Outlay - 145,176 93,000 93,000 110,000 107,500 75,000 75,000 75,000 Sub-Total Expenditures 2,647 162,886 104,667 104,667 127,667 125,167 92,667 92,667 92,667 Public Works Capital Expenditures Contractual Services 10,076 26,198 6,500 6,500 6,500 6,500 6,500 6,500 6,500 Supplies - - 2,000 2,000 2,000 2,000 2,000 2,000 2,000 Capital Outlay - - 85,000 78,689 160,000 - - - - Debt Service 82,295 82,295 79,795 76,054 70,816 70,815 70,815 70,815 70,815 Sub-Total Expenditures 92,371 108,493 173,295 163,243 239,316 79,315 79,315 79,315 79,315 Parks&Rec Capital Expenditures Contractual Services - - - - - - - - - Capital Outlay 17,284 17,000 17,000 140,000 17,500 - - - Debt Service - - 2,500 2,383 2,219 2,219 2,219 2,219 2,219 Other Financing Uses 3,500 2,500 50,000 50,000 50,000 50,000 - - - Sub-Total Expenditures 3,500 19,784 69,500 69,383 192,219 69,719 2,219 2,219 2,219 Total Expenditures 98,518 291,163 347,462 337,293 559,202 274,201 174,201 1749201 174,201 Surplus(Deficit) (538) (179,007) (87,712) (50,939) (124,649) - 506 506 506 Police Capital Fund Balance 229,238 106,687 22,635 50,859 - - - Public Works Capital Fund Balance 62,884 22,399 20,000 43,946 - - - Parks&Rec Capital Fund Balance 62,473 46,502 73,923 29,844 506 1,012 1,518 Ending Fund Balance 354,595 175,588 116,558 124,649 506 1,012 1,518 N $400 Fund Balance V $300 ° $200 $100 $0 29 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Vehicle&Equipment-25 ;s 25-000-42-20-4215 DEVELOPMENT FEES-POLICE CAPITAL 15,450 23,359 16,000 16,000'' 16,000 16,000 16,000 16,000 16,000 25-000-42-004216 BUILD PROGRAM PERMITS 3,500 24,140 - _ _ _ _ _ 25-000-42-20-4217 WEATHER WARNING SIREN FEES - - - 12,264! - - - - _ 25-000-42-21-4218 ENGINEERING CAPITAL FEE - 6,600 6,500 6,500" 6,500 6,500 6,500 6,500 6,500 25-000-42-214219 DEVELOPMENT FEES-PW CAPITAL 33,450 27,060 24,500 24,500.:- 24,500 24,500 24,500 24,500 24,500 25-000-42-224220 DEVELOPMENT FEES-PARK CAPITAL 2,600 3,300 2,275 2,275 2,275 2,275 2,275 2,275 2,275 25-000-43-204315 DUI FINES 3,116 6,949 3,100 7,000 5,000 5,000 5,000 5,000 5,000 25-000-43-204316 ELECTRONIC CITATION FEES 782 790 750 750 750 750 750 750 750 25-000-43-20-4340 SEIZED VEHICLE PROCEEDS 2,335 9,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 25-000-44-21-4418 MOWING INCOME 6,040 6,725 5,500 8,692:; 6,000 6,000 6,000 6,000 6,000 25-000.44-204420 POLICE CHARGEBACK - - - - 49,058 97,417 64,917 64,917 64,917 25-000-44-21-4421 PUBLIC WORKS CHARGEBACK - - 144,650 144,650' 97,370 41,315 41,315 41,315 41,315 25-000-44-224421 PARKS&RECREATION CHARGEBACK - - - 109,650 16,994 - - - 25-000-45-20-4520 INVESTMENT EARNINGS-POLICE CAPITAL 55 37 25 - - 25-000-45-214521 INVESTMENT EARNINGS-PW CAPITAL 22 17 - - - _ _ _ 25-000-45-224522 INVESTMENT EARNINGS-PARK CAPITAL 328 513 450 450` 450 450 450 450 450 25-000-46-22-4622 REIMB-MISCELLANEOUS-PARK CAPITAL 10,702 - 50,000 50,000 50,000 50,000 - - - 25-000-48-204852 MISCELLANEOUS INCOME-POLICE CAPITAL - - - - - - _ _ 25-000-48-21-4854 MISCELLANEOUS INCOME-PW CAPITAL - 966 - 448. 1,000 1,000 1,000 1,000 1,000 25-000-49-20-4910 SALE OF CAPITAL ASSETS-POLICE CAPITAL 15,200 200 1,000 7,825 1,000 1,000 1,000 1,000 1,000 25-00049-21.4910 SALE OF CAPITAL ASSETS-PW CAPITAL - - - - 60,000 - - _ 25-00049-224910 SALE OF CAPITAL ASSETS-PARKS CAPITAL 900 - _ 25-000-49-21-4922 TRANSFER FROM PARK&REC CAPITAL 3,500 2,500 Revenue 97,980 112,156 259,750 286,354: 434,553 274,201 174,707 174,707 174,707 Police Capital 25-205-54-00-5405 BUILD PROGRAM - - - - _ _ _ 25-205-54-00-5462 PROFESSIONAL SERVICES 2,647 3,982 1,667 1,667' 1,667 1,667 1,667 1,667 1,667 25-205-54-00-5495 OUTSIDE REPAIR&MAINTENANCE - 13,728 10,000 10,000 16,000 16,000 16,000 16,000 16,000 25-205-60-00-6060 EQUIPMENT 105,725 3,000 3,000 30,000 30,000 - - - 25-205-60-00-6070 VEHICLES 39,451 90,000 90,000 80,000 77,500 75,000 75,000 75,000 2,647 162,886 104,667 104,667- 127,667 125,167 92,667 92,667 92,667 Public Works Capital 30 v FY 2012 FV 2013 FV 2014 : FY 2014 FY 2015 FY 2016 FY 2017 FV 2018 FY 2019 Account Number Description Actual Actual Budget .Projected Adopted Projected Projected Projected Projected 25-215-54-00-5405 BUILD PROGRAM 3,500 24,140 - _ _ _ _ _ 25-215-54-00-5448 FILING FEES 2,576 2,058 2,000 2,000 2,000 2,000 2,000 2,000 2,000 25-215-54-00-5485 RENTAL&LEASE PURCHASE 4,000 - 4,500 4,500 4,500 4,500 4,500 4,500 4,500 25-215-56-00-5620 OPERATING SUPPLIES - 2,000 2,000 2,000 2,000 2,000 2,000 2,000 25-215-60-00-6060 EQUIPMENT 55,000 48,689 60,000 _ _ _ 25-215-60-00-6070 VEHICLES - - 30,000 30,000 100,000 - _ _ _ 185 Wo#-Street Building 25-215-92-00-8000 PRINCIPAL PAYMENT 28,254 30,074 31,040 33,184 37,924 39,638 41,430 43,303 45,261 25-215-92-00-8050 INTEREST PAYMENT 54,041 52,221 48,755 42,870. 32,892 31,177 29,385 27,512 25,554 92,371 108,493 173,295 163,243 239,316 79,315 79,315 79,315 79,315 Parks&Recreation Capital 25-225-54-00-5405 BUILD PROGRAM 25-225-60-00-6035 RAINTREE PARK - - 5,000 5,000'.. - 25-225-60-00-6060 EQUIPMENT - 17,284 12,000- 12,000 32,000 25-225-60-00-6065 BRIDGE PARK 108,000 25-225-60-00-6070 VEHICLES 17,500 - _ _ 185 WofStreet Building 25-225-92-00-8000 PRINCIPAL PAYMENT - - 972 S 1,040'.. 1,188 1,242 1,298 1,357 1,418 25-225-92-00-8050 INTEREST PAYMENT - - 1,528 ..1,343 1,031 977 921 862 801 25-225-99-00-9921 TRANSFER TO PUBLIC WORKS CAPITAL 3,500 2,500 - _ _ _ _ _ 31 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget .'Projected Adopted Projected Projected Projected Projected 25-225-99-00-9972 TRANSFER TO LAND CASH 50,000 '. 50,000 50,000 50,000 3,500 19,784 69,500 69,383 192,219 69,719 2,219 2,219 2,219 Expenditures 98,518 291,163 347,462 : 337,293 559,202 274,201 174,201 174,201 174,201 Surplus(Deficit) (538) (179,007) (87,712) '.. (50,939) (124,649) - 506 506 506 Fund Balance-Police Capital 229,238 106,687 22,635 50,859 Fund Balance-PuhlicWorksCapital 62,884 22,399 20,000 43,946:. FundBalance-Parks&RecCapital 62,473 46,502 73,923'- 29,844' - 506 1,012 1,518 Fund Balance 354,595 175,588 116,558 124,649 - 506 1,012 1,518 32 Debt Service Fund (42) The Debt Service Fund accumulates monies for payment of the 2005A bonds,which were issued to finance road improvement projects. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 323,350 324,762 328,179 315,790 329,579 231,000 142,500 49,500 - Licenses&Permits 1,375 4,694 1,000 5,000 2,500 2,500 2,500 2,500 2,500 Investment Earnings 283 610 300 100 100 100 100 100 100 Other Financing Sources 182,517 99,465 - - - 91,547 191,854 284,854 338,694 Total Revenue 507,525 429,531 329,479 320,890 332,179 325,147 336,954 336,954 341,294 Expenditures Contractual Services 749 589 375 375 775 775 775 775 775 Debt Service 427,919 504,407 328,179 328,179 329,579 330,579 336,179 336,179 340,519 Total Expenditures 428,668 504,996 328,554 328,554 330,354 331,354 336,954 336,954 341,294 Surplus(Deficit) 78,857 (75,465) 925 (7,664) 1,825 (6,207) - - - Ending Fund Balance 87,510 12,046 11,611 4,382 6,207 N $100 Fund Balance $so c $60 $40 $20 $0 33 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Debt Service-42 42-00040-00-4000 PROPERTY TAXES-2005A BOND 323,350 324,762 329,170 315,790 329,579 231,000 142,500 49,500 - 42-00042-004208 RECAPTURE FEES-WATER&SEWER 1,375 4,694 1 000 5,000 2,500 2,500 2,500 2,500 2,500 42-000-42-00-4216 BUILD PROGRAM PERMITS - - - - - - - - - 42-000-45-00-4500 INVESTMENT EARNINGS 283 610 300 100.. 100 100 100 100 100 42-000-49-00-4901 TRANSFER FROM GENERAL 103,740 99,465 = - 91,547 191,854 284,854 338,694 42-000-49-004985 TRANSFER FROM FOX INDUSTRIAL TIF 78,777 Revenue 507,525 429,531 329,479 320,890 332,179 325,147 336,954 336,954 341,294 42-420-54-00-5405 BUILD PROGRAM - 1�.. - - - - - - r r� 42420-54-00-5498 PAYING AGENT FEES 749 589 775 775 775 775 775 2004C Bond 4242041-004000 PRINCIPAL PAYMENT 95,000 95,000�� '1 - - - _ - - s �� 41 42-420-81-00-8050 INTEREST PAYMENT 8,740 4,465 � r a 2005A Bond 42-420-82-00-8000 PRINCIPAL PAYMENT 195,000 205,000 T �`_ 225,000 235,000 250,000 260,000 275,000 0!4 i i ,,x rP � 42-420-82-00-8050 INTEREST PAYMENT 129,179 121,379 } S / 104,579 95,579 86,179 76,179 65,519 mnm 2002 Fox Industrial TIF Bond 42-420-98-00-8000 PRINCIPAL PAYMENT 75,000 El 42-420-98-00-8050 INTEREST PAYMENT 3,563 Expenditures 428,668 504,996 328,554'.. 330,354 331,354 336,954 336,954 341,294 Surplus(Dericit) 78,857 (75,465) , '..= (7,664): 1,825 (6,207) - - Fund Balance 87,510 12,046 11,611 4,382 6,207 34 Water Fund(51) The Water Fund is an enterprise fund which is comprised of both a capital and operational budget.The capital portion is used for the improvement and expansion of water infrastructure, while the operational side is used to service and maintain City water systems. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 133,524 132,793 43,027 41,403 5,235 - - - Licenses&Permits 11,970 80,880 - - - - - - - Charges for Service 2,584,199 2,742,476 2,458,740 2,317,132 2,693,000 3,012,125 3,256,788 3,256,788 3,256,788 Investment Earnings 282 2,203 2,000 2,200 2,200 1,000 1,000 1,000 1,000 Reimbursements 1,771 10,476 - 6,064 - - - - - Miscellaneous 39,589 53,223 54,336 54,121 55,203 56,307 57,433 58,582 59,754 Other Financing Sources 83,863 82,288 82,988 82,988 83,588 84,088 84,488 82,288 85,088 Total Revenue 2,855,198 3,104,339 2,641,091 2,503,908 2,839,226 3,153,520 3,399,709 3,398,658 3,402,630 Expenses Salaries 332,461 337,375 339,697 339,697 351,860 356,082 368,125 380,589 393,490 Benefits 56,284 175,472 202,339 200,514 215,055 229,428 246,292 264,470 284,136 Contractual Services 518,831 490,186 497,450 438,950 485,700 501,225 517,682 535,126 553,617 Supplies 267,849 243,224 301,873 301,873 301,234 304,295 307,571 311,076 314,826 Capital Outlay 25,054 75,305 345,434 345,434 571,548 700,548 900,548 700,548 300,548 Developer Commitments 275,865 160,921 - - - - - - - Debt Service 903,277 1,396,016 1,172,802 1,172,802 1,168,384 1,163,054 1,166,825 1,154,236 1,355,949 Total Expenses 2,379,621 2,878,499 2,859,595 2,799,270 3,093,781 3,254,632 3,507,043 3,346,045 3,202,566 Surplus(Deficit) 475,577 225,840 (218,504) (295,362) (254,555) (101,112) (107,334) 52,613 200,064 Ending Fund Balance Equivalent 1,300,837 1,526,679 1,160,768 1,231,317 976,762 875,650 768,316 820,929 1,020,993 54.67% 53.04% 40.59% 43.99% 31.57% 26.90% 21.91% 24.53010 31.88% N $2,000 Fund Balance Equivalent V $1,500 N 7 t $1,000 r $500 $0 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Water-51 51-000-40-00-4000 PROPERTY TAXES-2007A BOND 133,524 132,793 43,027 41.403 5,235 51-000-42-00-4216 BUILD PROGRAM PERMITS 11,970 80,880 - - - _ _ _ _ 51-000-44-00-4424 WATER SALES 1,755,339 1,843,103 1,946,267 1,800,000 2,127,500 2,446,625 2,691,288 2,691,288 2,691,288 51-000-44-00-4425 BULK WATER SALES 329 10,796 500 4,750 500 500 500 500 500 51-000-44-00-4426 LATE PENALTIES-WATER - 97,601 90,000 92,143 90,000 90,000 90,000 90,000 90,000 51-000-44-00-4430 WATER METER SALES 25,365 36,725 27,563 30,000! 30,000 30,000 30,000 30,000 30,000 51-000-44-00-4440 WATER INFRASTRUCTURE FEE 696,716 691,321 334,560 340,239! 340,000 340,000 340,000 340,000 340,000 51-000-44-00-4450 WATER CONNECTION FEES 106,450 62,930 59,850 50,000d 105,000. 105,000 105,000 105,000 105,000 51-00045-00-4500 INVESTMENT EARNINGS 282 2,203 2,000 2,200 2,200 1,000 1,000 1,000 1,000 51-000-46-00-4670 REIMB-EMPLOYEE INS CONTRIBUTIONS - 8,294 - - - _ _ _ _ 51-000-46-00-4671 REIMB-LIFE INSURANCE - 164 - - 51-00046-00-4690 REIMB-MISCELLANEOUS 1,771 2,018 - 6,064 - - _ _ _ 51-00048-004820 RENTAL INCOME 39,491 53,073 54,336 54,121.': 55,203 56,307 57,433 58,582 59,754 51-000-48-00-4850 MISCELLANEOUS INCOME 98 150 _ _ _ _ _ 51-000-49-004952 TRANSFER FROM SEWER 83,863 82,288 ANN,- 82,988 82,988 83,588 84,088 84,488 82,288 85,088 Revenue 2,855,198 3,104,339 2,641,091 2,503,908.. 2,839,226 3,153,520 3,399,709 3,398,658 3,402,630 Water Operations 51-510-50-00-5010 SALARIES&WAGES 324,679 331.616 327,697 127,697< 334,060 344,082 356,125 368,589 381,490 51-510-50-00-5015 PART-TIME SALARIES - 5,800 - - _ 51-510-50-00-5020 OVERTIME 7,782 5,759 12,000 12,000 12,000 12,000 12,000 12,000 12,000 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION 31,777 35,140 37,648 37,648 41,270 44,042 48,326 53,003 58,177 51-510-52-00-5214 FICA CONTRIBUTION 24,507 24,639 25,277 25,277 25,687 26,458 27,384 28,342 29,334 51-510-52-00-5216 GROUP HEALTH INSURANCE - 85,844 102,854 102,854' 111,893 120,844 130,512 140,953 152,229 51-510-52-00-5222 GROUP LIFE INSURANCE - 883 722 675''- 681 688 695 702 709 51-510-52-00-5223 DENTAL INSURANCE 6,461 6,599 5,800 5,792 6,082 6,386 6,705 7,040 51-510-52-00-5224 VISION INSURANCE - 713 729 750 751 774 797 821 846 51-510-52-00-5230 UNEMPLOYMENT INSURANCE 1,025 4,000 3,000 3,000 3,000 3,000 3,000 3,000 51-510-52-00-5231 LIABILITY INSURANCE - 20,767 24,510 24,510: 25,981 27,540 29,192 30,944 32,801 51-510-54-00-5401 ADMINISTRATIVE CHARGEBACK 91,863 51-510-54-00-5405 BUILD PROGRAM 11,970 80,880 i�` - 51-510-54-00-5412 TRAINING&CONFERENCES 330 600 iw 3,000 3,000 3,000 3,000 3,000 .# a !b 51-510-54-00-5415 TRAVEL&LODGING 287 293 _ �ii 31j 1,600 1,600 1,600 1,600 1,600 Aw 51-510-54-00-5426 PUBLISHING&ADVERTISING 1,172 1,117 , F 1,000 1,000 1,000 1,000 1,000 36 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 51-510-54-00-5429 WATER SAMPLES 4,294 7,170 14,000 14,000 14,000 14,000 14,000 14,000 14,000 51-510-54-00-5430 PRINTING&DUPLICATING 86 42 2,500 2,500 2,500 2,500 2,500 2,500 2,500 51-510-54-00-5440 TELECOMMUNICATIONS 19,205 22,942 24,500- 24,500 24,500 24,500 24,500 24,500 24,500 51-510-54-00-5445 TREATMENT FACILITY SERVICES 85,003 89,598 1.00,000 100,000 100,000 100,000 100,000 100,000 100,000 51-510-54-00-5448 FILING FEES 5,888 6,399 6,200 6,200 6,500 6,500 6,500 6,500 6,500 51-510-54-00-5452 POSTAGE&SHIPPING 17,167 17,609 22,000 22,000 22,000 22,000 22,000 22,000 22,000 51-510-54-00-5460 DUES&SUBSCRIPTIONS 629 858 1,250 1,250 1,250 1,250 1,250 1,250 1,250 51-510-54-00-5462 PROFESSIONAL SERVICES 9,755 13,585 10,000 10,000 15,000 15,000 15,000 15,000 15,000 51-510-54-00-5466 LEGAL SERVICES 2.000 2,000 2,000 2,000 2,000 2,000 2,000 51-510-54-00-5480 UTILITIES 239,606 208,439 283,500 225,000"' 258,750 274,275 290,732 308,176 326,667 51-510-54-00-5483 JULIE SERVICES 3,426 6,534 4,500 4,500 4,500 4,500 4,500 4,500 4,500 51-510-54-00-5485 RENTAL&LEASE PURCHASE 396 492 1,000 1,000 1,000 1,000 1,000 1,000 1,000 51-510-54-00-5490 VEHICLE MAINTENANCE SERVICES 12,832 9,790 5,000 5,000 6,000 6,000 6,000 6,000 6,000 51-510-54 00-5495 OUTSIDE REPAIR&MAINTENCE - 4,961 - - 4,000 4,000 4,000 4,000 4,000 51-510-54-00-5498 PAYING AGENT FEES 1,552 1,338 1,400 1,400 3,100 3,100 3,100 3,100 3,100 51-510-54-00-5499 BAD DEBT 13,370 17,539 15,000 15,000 15,000 15,000 15,000 15,000 15,000 51-510-56-00-5600 WEARING APPAREL 3,045 3,067 4,000 4,000 4,000 4,000 4,000 4,000 4,000 51-510-56-00-5620 OPERATING SUPPLIES 16,036 14,601 25,000 25,000 25,000 25,000 25,000 25,000 25,000 51-510-56-00-5628 VEHICLE MAINTENANCE SUPPLIES - - 7,500 7,500 8,500 8,500 8,500 8,500 8,500 51-510-56-00-5630 SMALL TOOLS&EQUIPMENT 459 3,548 2,000 2,000 2,000 2,000 2,000 2,000 2,000 51-510-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 560 104 6,000 6,000 6,000 6,000 6,000 6,000 6,000 51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 177,643 155,048 155,000 155,000 155,000 155,000 155,000 155,000 155,000 51-510-56-00-5640 REPAIR&MAINTENANCE 7,368 9,892 9,500 9,500 9,500 9,500 9,500 9,500 9,500 51-510-56-00-5664 METERS&PARTS 29,092 32,809 52,000 52,000' 46,000 46,000 46,000 46,000 46,000 51-510-56-00-5665 JULIE SUPPLIES - - - - 1,500 1,500 1,500 1,500 1,500 51-510-56-00-5695 GASOLINE 33,646 24,155 40,873 40,873 43,734 46,795 50,071 53,576 57,326 51-510-60-00-6025 ROAD TO BETTER ROADS PROGRAM - - 206,340. 206,340 353,000. 300,000 300,000 100,000 100,000 51-510.60-00-6060 EQUIPMENT 10,000 10,000 5,000 5,000 5,000 5,000 5,000 51-510-60-00-6066 RTE 71 WATERMAIN RELOCATION - - 200,000 400,000 400,000 - 51-510-60-00-6070 VEHICLES - mg - ,k 18,000 - - - 51-510-60-00-6079 ROUTE 47 EXPANSION 25,054 75,305 y 3�. 195,548 195,548 195,548 195,548 195,548 51-510-75-00-7502 GRANDE RESERVE COURT ORDER 275,865 160,921 Debt Service-2007A Bond r 51-510-83-00-8000 PRINCIPAL PAYMENT 10,000 10,000 15,000 15,000 15,000 15,000 15,000 15,000 15,000 51-510-83-00-8050 INTEREST PAYMENT 123,866 123,454 123,041 123,041 122,423 121,793 121,163 120,525 119,888 Debt Service-2002 Capital Appreciation Debt Certificates 37 -5 FY 2012 FY 2013 1- FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual - 4Jed Adopted Projected Projected Projected Projected 110 W16 51-510-85-00-8000 PRINCIPAL PAYMENT 285,000 365,000 Debt Service-2003 Debt Certificates 51-510-86-00-8000 PRINCIPAL PAYMENT - - 100,000 100,000 100,000 100,000 100,000 100,000 300,000 51-510-86-00-8050 INTEREST EXPENSE 33,150 33,150 33,150 33,150 29,350 25,450 21,450 17,300 13,050 Debt Service-2006A Refunding Debt Certificates 51-510-87-00-8000 PRINCIPAL PAYMENT 70,000 355,000 405,000 405,000 420,000 435,000 460,000 475,000 495,000 51-510-87-00-8050 INTEREST EXPENSE 88,506 219,806 205,606 205,606 189,406 172,606 155,206 136,806 117,806 Debt Service-2005C Bond 51-510-88-00-8000 PRINCIPAL PAYMENT 90,000 90,000 95,000 95,000 100,000 105,000 110,000 110,000 120,000 51-510-88-00-8050 INTEREST EXPENSE 77,725 74,575 70,975 70,975.. 67,175 63,175 58,975 54,575 50,175 Debt Service-IEPA Loan L17-156300 51-510-89-00-8000 PRINCIPAL PAYMENT 85,600 87,754 99,061 89,961 92,224 94,544 96,923 99,361 101,860 51-510-89-00-8050 INTEREST EXPENSE 39,430 37,277 35,069 35,069 32,806 30,486 28,108 25,669 23,170 Expenses 2,379,621 2,878,499 2,859,595. 2,799,270_ 3,093,781 3,254,632 3,507,043 3,346,045 3,202,566 Surplus(Deficit) 475,577 225,840 (218,504) (295,362)'. (254,555) (101,112) (107,334) 52,613 200,064 Fund Balance Equiv 1,300,837 1,526,679 1,160,768 1,231,317 976,762 875,650 768,316 820,929 1,020,993 54.67% 53.04% 40.59% 49.99%: 31.57% 26.90% 21.91% 24.53% 31.88% 38 Sewer Fund(52) The Sewer Fund is an enterprise fund which is comprised of both a capital and operational budget. The capital portion is used for improvement and expansion of the sanitary sewer infrastructure while the operational side allows the City to service and maintain sanitary sewer systems. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 1,750,206 262,543 114,940 110,601 Licenses&Permits 4,000 24,000 - - - - - - _ Charges for Service 1,362,022 1,348,205 1,097,560 1,111,261 1,140,500 1,163,675 1,203,459 1,245,232 1,289,094 Investment Earnings 2,405 7,339 5,500 8,500 6,000 5,000 4,500 4,500 4,500 Reimbursements 1,741 7,908 - - - - - _ _ Other Financing Sources - - 1,137,220 1,137,220 1,238,972 1,134,654 1,134,052 1,137,166 1,133,782 Total Revenue 3,120,374 1,649,995 2,355,220 2,367,582 2,385,472 2,303,329 2,342,011 2,386,898 2,427,376 Expenses Salaries 198,218 190,452 189,544 189,544 195,304 201,103 208,072 215,285 222,750 Benefits 33,563 95,946 98,540 98,040 105,056 112,430 120,531 129,260 138,704 Contractual Services 140,460 89,177 80,950 80,950 95,578 99,073 103,166 107,497 112,078 Supplies 45,381 44,378 83,206 83,206 90,144 92,485 94,990 97,670 100,538 Capital Outlay 25,054 38,951 66,773 66,773 593,095 259,098 259,098 259,098 259,098 Developer Commitments 30,996 30,996 - - - - - _ _ Debt Service 1,416,416 1,088,012 1,968,119 1,968,119 2,054,461 1,865,399 1,865,857 1,877,110 1,880,265 Other Financing Uses 604,582 82,288 82,988 82,988 83,588 84,088 84,488 82,288 85,088 Total Expenses 2,494,670 1,660,200 2,570,120 2,569,620 3,217,226 2,713,676 2,736,202 2,768,208 2,798,521 Surplus(Deficit) 625,704 (10,205) (214,900) (202,038) (831,754) (410,347) (394,191) (381,310) (371,145) Ending Fund Balance Equivalent 3,003,537 2,993,332 2,681,077 2,791,294 1,959,540 1,549,193 1,155,002 773,692 402,547 120.40% 180.30% 104.32% 108.63% 60.91% 57.09% 42.21% 27.95% 14.38% $4,000 Fund Balance Equivalent `g $3,000 0 $2,000 $1,000 $0 39 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual - .Budget Projected Adopted Projected Projected Projected Projected Sewer-52 52-00040-004009 PROPERTY TAXES-2004B BOND 257,989 262,543 114,1)40 110,601 52-000-40-00-4013 PROPERTY TAXES-2005D BOND 1,382,408 - - - 52-00040-004014 PROPERTY TAXES-2008 BOND 109,809 - 52-000-42-004216 BUILD PROGRAM PERMITS 4,000 24,000 - - _ _ _ 52-00044-00-4435 SEWER MAINTENANCE FEES 742,022 744,820 740,000. 756,315 772,500 795,675 835,459 877,232 921,094 52-000-44-00-4440 SEWER INFRASTRUCTURE FEE - - 334,560 330,668 330,000 330,000 330,000 330,000 330,000 52-000-44-00-4455 SW CONNECTION FEES-OPERATIONS 4,800 200 1,000 1,000 5,000 5,000 5,000 5,000 5,000 52-000-44-00-4456 SW CONNECTION FEES-CAPITAL 43,200 3,400 '10,000 10,000 20,000 20,000 20,000 20,000 20,000 52-000-44-00-4457 SW CONNECTION FEES-ROB ROY 572,000 586,000 - - - _ _ _ 52-000-44-00-4462 LATE PENALTIES-SEWER - 13,271 12,000 13,000 13,000 13,000 13,000 13,000 13,000 52-000-44-00-4465 RIVER CROSSING FEES - 514 - 1_78'd§ - - _ _ _ 52-000-45-00-4500 INVESTMENT EARNINGS 2,405 7,339 5,500 8,500'14 6,000 5,000 4,500 4,500 4,500 52-000-46-00-4670 REHAB-EMPLOYEE INS CONTRIBUTIONS - 4,240 _ _ _ _ 52-000-46-004690 REHAB-MISCELLANEOUS 1,741 3,668 _ _ _ _ _ 52-000-49-00-4901 TRANSFER FROM GENERAL - - 1,137,220 1,1.37,220 1,133,972 1,134,654 1,134,052 1,137,166 1,133,782 52-000-49-00-4910 SALE OF CAPITAL ASSETS 105,000 Revenue 3,120,374 1,649,995 2,355,220 2,367,582. 2,385,472 2,303,329 2,342,011 2,386,898 2,427,376 Sewer Operations 52-520-50-00-5010 SALARIES&WAGES 198,017 189,7,3 187,544 187,544 193,304 199,103 206,072 213,285 220,750 52-520-50-00-5015 PART-TIME SALARIES - - - - - - _ _ _ 52-520-50-00-5020 OVERTIME 201 719 2,000 2,000- 2,000 2,000 2,000 2,000 2,000 52-520-52-00-5212 RETIREMENT PLAN CONTRIBUTION 18,927 20,244 21,007 21,007 23,291 25,485 27,964 30,670 33,664 52-520-52-00-5214 FICA CONTRIBUTION 14,636 14,245 14,223 14,223' 14,661 15,101 15,630 16,177 16,743 52-520-52-00-5216 GROUP HEALTH INSURANCE - 42,818 41,481 41,481 44,546 48,110 51,959 56,116 60,605 52-520-52-00-5222 GROUP LIFE INSURANCE 377 365 365 346 349 352 356 360 52-520-52-00-5223 DENTAL INSURANCE 3,521 2,653 2,653 2,879 3,023 3,174 3,333 3,500 52-520-52-00-5224 VISION INSURANCE 378 307 307 369 380 391 403 415 52-520-52-00.5230 UNEMPLOYMENT INSURANCE 552 2,500 2,000 2,000 2,000 2,000 2,000 2,000 52-520-52-00-5231 LIABILITY INSURANCE - 13,811 16,004 16,004:` 16,964 17,982 19,061 20,205 21,417 52-520-54-00-5401 ADMINISTRATIVE CHARGEBACK 83,045 52-520-54-00-5405 BUILD PROGRAM 4,000 24,000 52-520-54-00-5412 TRAINING&CONFERENCES 500 500 500 500 500 52-520-54-00-5415 TRAVEL&LODGING 43 ? ii y �*t!¢ , b5"4C1 500 500 500 500 500 40 �r FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 52-520-54-00-5430 PRINTING&DUPLICATING - 29 100 100 100 100 100 100 100 52-520-54-00-5440 TELECOMMUNICATIONS 1,699 1,521 2,500 2,500 2,500 2,500 2,500 2,500 2,500 52-520-54-00-5444 LIFT STATION SERVICES 16,541 9,695 15,750 15,750 16,538 17,365 18,233 19,145 20,102 52-520-54-00-5462 PROFESSIONAL SERVICES 5,960 2,893 5,000 5,000 7,500 7,500 7,500 7,500 7,500 52-520-54-00-5480 UTILITIES 19,782 36,672 44,100 44,100 50,715 53,758 56,983 60,402 64,026 52-520-54-00-5485 RENTAL&LEASE PURCHASE 396 492 1,500 1,500 1,500 1,500 1,500 1,500 1,500 52-520-54-00-5490 VEHICLE MAINTENANCE SERVICES 3,997 8,388 5,000 5,000 5,000 5,000 5,000 5,000 5,000 52-520-54-00-5495 OUTSIDE REPAIR&MAINTENCE - - - - 4,000 4,000 4,000 4,000 4,000 52-520-54-00-5498 PAYING AGENT FEES 2,511 2,812 3 000 3,000 3,725 3,350 3,350 3,350 3,350 52-520-54-00-5499 BAD DEBT 2,529 2,632 3,000 3,000 3,000 3,000 3,000 3,000 3,000 52-520-56-00-5600 WEARING APPAREL 2,753 3,194 2,500 2,500 2,500 2,500 2,500 2,500 2,500 52-520-56-00-5610 OFFICE SUPPLIES 519 1,264 2,000 2,006 2,000 2,000 2,000 2,000 2,000 52-520-56-00-5613 LIFT STATION MAINTENANCE 1,312 3,071 10,500 10,500 12,000 12,000 12,000 12,000 12,000 52-520-56-00-5620 OPERATING SUPPLIES 3,690 4,413 4,500 4,500 4,500 4,500 4,500 4,500 4,500 52-520-56-00-5628 VEHICLE MAINTENANCE SUPPLIES - - 2,000 2,000 2,000 2,000 2,000 2,000 2,000 52-520-56-00-5630 SMALL TOOLS&EQUIPMENT 781 2,481 2,500 2,500'- 2,500 2,500 2,500 2,500 2,500 52-520-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 77 - 1,200 1,200 1,200 1,200 1,200 1,200 1,200 52-520-56-00-5640 REPAIR&MAINTENANCE 5,246 7,547 26,750 26,750 30,000 30,000 30,000 30,000 30,000 52-520-56-00-5695 GASOLINE 31,003 22,408 31,256 31,256 33,444 35,785 38,290 40,970 43,838 52-520-60-00-6025 ROAD TO BETTER ROADS PROGRAM - - - 200,000 200,000 200,000 200,000 200,000 52-520-60-00-6070 VEHICLES - - 333,997 - - - - 52-520-60-00-6079 ROUTE 47 EXPANSION 25,054 38,951 66,773 66,773 59,098 59,098 59,098 59,098 59,098 52-520-75-00-7500 LENNAR-RAINTREE SEWER RECPATURE 30,996 30,996 - - - - - - Debt Service-2004B Bond 52-520-84-00-8000 PRINCIPAL PAYMENT 160,000 170,000 280,000 280,000- 375,000 395,000 410,000 435,000 455,000 52-520-84-00-8050 INTEREST EXPENSE 98,650 93,850 88,750 88,750' 78,950 65,825 52,000 35,600 18,200 Debt Service-2003A BdBB Debt Certificates - - 52-520-90-00-8000 PRINCIPAL PAYMENT 95,000 100,000 100,000 100,000 105,000 110,000 115,000 120,000 130,000 52-520-90-00-8050 INTEREST EXPENSE 70,143 66,248 62,048 62,048 57,648 52,870 47,755 42,293 36,233 41 FV 2012 FV 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Debt Service-2004A Bond 52-520-91-00-8000 PRINCIPAL PAYMENT 170,000 175,000 180,000 180,000 190,000 52-520-91-00-8050 INTEREST EXPENSE 24,093 18,738 13,050 13,050 6,840 - - _ _ Debt Service-2011 Refunding Bond 52-520-92-00-8000 PRINCIPAL PAYMENT - - 660,000 660,000 685,000 715,000 745,000 780,000 810,000 52-520-92-00-8050 INTEREST EXPENSE 225,354 318,147 477,220 477,220 448,972 419,654 389,052 357,166 323,782 Debt Service-2005D Bond 52-520-93-00-8050 INTEREST EXPENSE 332,346 - - _ _ _ _ _ Debt Service-2008 Refunding Bond ' . 52-520-94-00-8050 INTEREST PAYMENT 94,800 Debt Service-IEPA Loan L17-013000 52-520-95-00-8000 PRINCIPAL PAYMENT 36,635 37,958 52-520-95-00-8050 INTEREST EXPENSE 2,345 1,021 Debt Service-IEPA Loan L17-115300 52-520-96-00-8000 PRINCIPAL PAYMENT 86,329 88,610 90,952 90,952 93,355 95,821 98,353 100,952 103,619 52-520-96-00-8050 INTEREST EXPENSE 20,721 18,440 16,099 16,099 13,696 11,229 8,697 6,099 3,431 52-520-99-00-9951 TRANSFER TO WATER 83,863 82,288 82,988 82,988 83,588 84,088 84,488 82,288 85,088 52-520-99-00-9999 TRANSFER TO 2011 BOND ESCROW 520,719 Expenses 2,494,670 1,660,200 2,570,120 2,569,620: 3,217,226 2,713,676 2,736,202 2,768,208 2,798,521 Surplus(Deficit) 625,704 (10,205) (214,900) (202,038)' (831,754) (410,347) (394,191) (381,310) (371,145) Fund Balance Equiv 3,003,537 2,993,332 2,681,077 2,791,294 1,959,540 1,549,193 1,155,002 773,692 402,547 120.40% 780.30% 104.32% 10863%'' 60.91% 57.09% 42.21% 17.95% 14.38% 42 Land Cash Fund (72) Land-Cash funds are dedicated by developers through the contribution ordinance to serve the immediate and future needs of park and recreation of residents in new subdivisions.Land for park development and cash spent on recreational facilities is often matched through grant funding to meet the community's recreation needs at a lower cost to the City. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Intergovernmental 400,000 400,000 96,000 96,000 - - 400,000 - - Licenses&Permits - - - - - - - Investment Earnings - - - 5 - - - - - Land Cash Contributions 30,767 68,768 20,500 32,212 23,000 23,000 23,000 23,000 23,000 Other Financing Sources - - 50,000 50,000 50,000 50,000 - - - Total Revenue 430,767 468,768 166,500 178,217 73,000 73,000 423,000 23,000 23,000 Expenditures Contractual Services 20,084 - - - - - - _ _ Capital Outlay 316,836 52,570 111,000 111,000 406,850 313,000 13,000 13,000 13,000 Total Expenditures 336,920 52,570 11 1,000 111,000 406,850 313,000 13,000 13,000 13,000 Surplus(Deficit) 93,847 416,198 55,500 67,217 (333,850) (240,000) 410,000 10,000 10,000 Ending Fund Balance (294,778) 121,420 162,581 188,637 (145,213) (385,213) 24,787 34,787 44,787 Fund Balance N $400 m $200 ' $0 0 s ($200) ($400) ($600) 43 FY 2012 FY 2013 FY 2014 FV 2014 FY 2015 FY 2016 FV 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Land Cash-72 72-000-41-00-4171 OSLAD GRANT-PRAIRIE MEADOWS 400,000 72-000-41-00-4173 OSLAD GRANT-RAINTREE - 400.000 - 72-00041-00-4174 RTP GRANT-CLARK PARK - - 96,000- 96,000.: 72-00041-00-4175 OSLAD GRANT-RIVERFRONT GRANT - - l - - 400,000 72-000-42-00-4216 BUILD PROGRAM PERMITS - _ 72-000-45-00-4500 INVESTMENT EARNINGS 5 _ _ 72-000-47-00-4703 AUTUMN CREEK 30,767 66,662 20,000 20,000 20,000 20,000 20,000 20,000 20,000 72-00047-00-4704 BLACKBERRY WOODS - 568 500 2,841"r; 500 500 500 500 500 72-000-47-00-4706 CALEDONIA - - - - - 2,500 2,500 2,500 2,500 2,500 72-000-47-00-4708 COUNTRY HILLS 1,538 - _ _ _ _ 72-000-47-00-4736 BRIARWOOD - - 9,371 _ _ 72-000-49-004925 TRANSFER FROM VEHICLE&EQUIPMENT - 50,000 50,000 50,000 50,000 Revenue 430,767 468,768 166,500 178,217 73,000 73,000 423,000 23,000 23,000 72-720-54-00-5401 ADMINISTRATIVE CHARGEBACK 20,084 - _ _ _ _ _ 72-720-54-00-5405 BUILD PROGRAM - 72-720.60-00-6028 CANNONBALL PARK - - 22,000 22,000r - _ _ _ _ 72-720.60-00-6032 MOSIER HOLDING COSTS 11,000 12,000 13,000 13,000 13,000 13,000 13,000 13,000 13,000 72-720-60-00-6036 RAINTREE VILLAGE 305,836 40,570 - _ _ _ _ _ 72-720-60-00-6044 CLARK PARK - - 76,000 76,000' - - 72-720-60-00-6045 RIVERFRONT PARK - _ '._ 200,000 200,000 72-720-60-00.6046 GRANDE RESERVE PARK A , �_ 50,000 My 72-720-60-00-6047 GRANDE RESERVE PARK B - - - - 143,850 - 72-720-60-00-6049 RAINTREE PARK C 50,000 50,000 Expenditures 336,920 52,570 111,000 111,000 406,850 313,000 13,000 13,000 13,000 Surplus(Deficit) 93,847 416,198 55,500 67,217 (333,850) (240,000) 410,000 10,000 10,000 Fund Balance (294,778) 121,420 162,581 188,637 (145,213) (385,213) 24,787 34,787 44,787 44 Parks and Recreation Fund (79) This fund accounts for the daily operations of the Parks and Recreation Department. Programs,classes,special events and maintenance of City wide park land and public facilities make up the day to day operations. Programs and classes consist of a wide variety of options serving children through senior citizens. Special events range from Music Under the Stars to Home Town Days. City wide maintenance consists of over two hundred acres at more than fifty sites including buildings,boulevards,parks,utility locations and natural areas. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Charges for Service 265,699 265,614 240,000 286,676 280,000 280,000 280,000 280,000 280,000 Investment Earnings 175 244 200 250 250 250 250 250 250 Reimbursements 3,336 20,947 - - - - - - - Miscellaneous 193,688 195,868 223,000 180,339 208,000 208,000 208,000 217,700 217,700 Other Financing Sources 736,710 955,886 1,765,504 1,765,504 1,277,606 1,339,594 1,401,968 1,460,826 1,531,004 Total Revenue 1,199,608 1,438,559 2,228,704 2,232,769 1,765,856 1,827,844 1,890,218 1,958,776 2,028,954 Expenditures Salaries 651,906 671,149 771,493 771,493 840,647 862,287 888,292 915,206 943,063 Benefits 107,010 283,568 351,668 351,668 397,762 427,622 459,948 494,845 532,667 Contractual Services 147,598 159,624 227,280 227,280 374,430 253,154 237,623 239,174 240,818 Supplies 244,584 283,915 291,650 282,550 298,608 295,686 297,641 299,733 301,972 Other Financing Uses - - 556,957 487,840 - - - - - Total Expenditures 1,151,098 1,398,256 2,199,048 2,120,831 1,911,447 1,838,749 1,883,504 1,948,958 2,018,520 Surplus(Deficit) 48,510 40,303 29,656 111,938 (145,591) (10,905) 6,714 9,818 ]0,434 Ending Fund Balance 280,065 320,370 322,699 432,308 286,717 275,812 282,526 292,344 302,778 24.33% 22.91% 14.67% 20.38% 15.00% 15.00% 15.00% 15.00% 15.00% $600 Fund Balance 2 $400 0 s $200 $0 45 FV 2012 FV 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Parks and Recreation-79 79-000-44-00-4402 SPECIAL EVENTS 6,935 35,120 30,000 45,355 35,000 35,000 35,000 35,000 35,000 79-000-44-00-4403 CHILD DEVELOPMENT 41,756 59,559 50,000 75,000 75,000 75,000 75,000 75,000 75,000 79-000-44-004404 ATHLETICS&FITNESS 124,164 138,466 130,000. 135,000 140,000 140,000 140,000 140,000 140,000 79-000-44-00-4439 PROGRAM FEES 53,905 _ _ _ _ - 79-000-44-004441 CONCESSION REVENUE 38,939 32,469 30,000 "31,321 30,000 30,000 30,000 30,000 30,000 79-000 45-004500 INVESTMENT EARNINGS 175 244 200 250 250 250 250 250 250 79-000-46-00-4670 REIMB-EMPLOYEE INS CONTRIBUTIONS - 12,521 n 79-000-46-00-4690 REIMB-MISCELLANEOUS 3,336 8,426 2 d " ` `Y 79-000-48-00-4820 RENTAL INCOME 54,240 54,758E 50,000 50,000 50,000 50,000 50,000 79-000-48-00-4825 PARK RENTALS 27,143 12,552 25,000 26,742 25,000 25,000 25,000 25,000 25,000 79-000-48-00-4843 HOMETOWN DAYS 100,960 119,235 135,000 90,597 125,000 125,000 125,000 125,000 125,000 79-000-48-004846 SPONSORSHIPS&DONATIONS 4,314 5,569 5,000 5,000 5,000 5,000 5,000 14,700 14,700 79-00048-00-4850 MISCELLANEOUS INCOME 7,031 3,754 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-00049-00-4901 TRANSFER FROM GENERAL 736,710 955,886 1,765,504 1,765,504 1,277,606 1,339,594 1,401,968 1,460,826 1,531,004 Revenue 1,199,608 1,438,559 2,228,704 2,232,769 1,765,856 1,827,844 1,890,218 1,958,776 2,028,954 Parks Department 79-790-50-00-5010 SALARIES&WAGES 369,514 400,384 427,948 427,948 447,564 460,991 477,126 493,825 511,109 79-790-50-00-5015 PART-TIME SALARIES 16,833 17,932 17,000 17,000 34,000 34,000 34,000 34,000 34,000 79-790-50-00-5020 OVERTIME 50 1,431 3,000 3,000 3,000 3,000 3,000 3,000 3,000 79-790-52-00-5212 RETIREMENT PLAN CONTRIBUTION 35,461 43,342 47,761 47,761 53,733 59,007 64,746 71,012 77,944 79-790-52-00-5214 FICA CONTRIBUTION 28,869 31,109 33,4 8 7 33 487 36,183 37,268 38,572 39,922 41,319 79-790-52-00-5216 GROUP HEALTH INSURANCE - 110,141 126,575 126,575 132,108 142,677 154,091 166,418 179,731 79-790-52-00-5222 GROUP LIFE INSURANCE 936 980- 980 924 933 942 951 961 79-790-52-00-5223 DENTAL INSURANCE - 7,954 9,580 9,580 7,728 8,114 8,520 8,946 9,393 79-790-52-00-5224 VISION INSURANCE - 932 1,004 1,004 1,032 1,063 1,095 1,128 1,162 79-790-54-00-5412 TRAINING&CONFERENCES 2,604 1,333 4,000 4,000' 7,000 7,000 7,000 7,000 7,000 79-790-54-00-5415 TRAVEL&LODGING 332 329 2,000 2,000 3,000 3,000 3,000 3,000 3,000 79-790-54-00-5422 VEHICLE&EQUIPMENT CHARGEBACK - - - - 109,650 16,994 - _ _ 79-790-54-00-5440 TELECOMMUNICATIONS 3,330 3,863 4,780 4,780 4,780 4,780 4,780 4,780 4,780 79-790-54-00-5462 PROFESSIONAL SERVICES 4,748 2,280 4,500 4,500 4,500 4,500 4,500 4,500 4,500 79-790-54-00-5466 LEGAL SERVICES 3,701 5,938 4,000 4,000 4,000 4,000 4,000 4,000 4,000 79-790-54-00-5485 RENTAL&LEASE PURCHASE 2,017 620 2,500 2,500 2,500 2,500 2,500 2,500 2,500 79-790-54-00-5495 OUTSIDE REPAIR&MAINTENANCE - 26,194 22,500 22,500 32,500 32,500 32,500 32,500 32,500 46 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 79-790-56-00-5600 WEARING APPAREL 4,123 4,603 4,100 4,100 4,700 4,700 4,700 4,700 4,700 79-790-56-00-5610 OFFICE SUPPLIES 293 167 300 300 300 300 300 300 300 79-790-56-00-5620 OPERATING SUPPLIES 23,528 17,900 22,500 22,500'r 22,500 22,500 22,500 22,500 22,500 79-790-56-00-5630 SMALL TOOLS&EQUIPMENT 2,374 3,093 2,250 2,250 7,000 2,250 2,250 2,250 2,250 79-790-56-00.5635 COMPUTER EQUIPMENT&SOFTWARE - - 500 500 500 500 500 500 500 79-790-56-00-5640 REPAIR&MAINTENANCE 51,312 54,036 50,500 50,500'' 50,500 50,500 50,500 50,500 50,500 79-790-56-00-5695 GASOLINE - 19,973 21.,400 21,400 22,898 24,501 26,216 28,051 30,015 549,089 754,490 813,165 813,165' 992,600 927,578 947,338 986,283 1,027,664 Recreation Department 79-795-50-00-5010 SALARIES&WAGES 197,710 202,126 240,745 240,745... 273,783 281,996 291,866 302,081 312,654 79-795-50-00-5015 PART-TIME SALARIES 17,013 11,457 15,000 15,000 23,000 23,000 23,000 23,000 23,000 79-795-50-00-5020 OVERTIME - - 300 3001 300 300 300 300 300 79-795-50-00-5045 CONCESSION WAGES 11,542 8,341 12,500 12,500 14,000 14,000 14,000 14,000 14,000 79-795-50-00-5046 PRE-SCHOOL WAGES 22,476 18,431 30,000 38000 20,000 20,000 20,000 20,000 20,000 79-795-50-00-5052 INSTRUCTORS WAGES 16,768 11,047 25,000 25,000 25,000 25,000 25,000 25,000 25,000 79-795-52-00-5212 RETIREMENT PLAN CONTRIBUTION 23,137 24,704 26,714 26,714 32,686 36,095 39,606 43,439 47,680 79-795-52-00-5214 FICA CONTRIBUTION 19,543 18,637 24,216 24,216?. 26,576 27,373 28,331 29,323 30,349 79-795-52-00-5216 GROUP HEALTH INSURANCE - 42,511 75.1)11 75,911'= 100,027 108,029 116,671 126,005 136,085 79-795-52-00-5222 GROUP LIFE INSURANCE - 440 591 591' 673 680 687 694 701 79-795-52-00-5223 DENTAL INSURANCE - 2,566 4,344 4,344- 5,397 5,667 5,950 6,248 6,560 79-795-52-00-5224 VISION INSURANCE - 296 505 505 695 716 737 759 782 79-795-54-00-5412 TRAINING&CONFERENCES 581 1,144 ,,000 3,000 5,000 5,000 5,000 5,000 5,000 79-795-54-00-5415 TRAVEL&LODGING 369 453 1,500 1,500? 3,000 3,000 3,000 3,000 3,000 79-795-54-00-5426 PUBLISHING&ADVERTISING 27,026 24,745 27,000 27,000' 40,000 40,000 40,000 40,000 40,000 79-795-54-00-5440 TELECOMMUNICATIONS 2,847 2,922 7,000 7,000 7,000 7,000 7,000 7,000 7,000 79-795-54-00-5447 SCHOLARSHIPS 685 803 2,500 2,500 2,500 2,500 2,500 2,500 2,500 79-795-54-00-5452 POSTAGE&SHIPPING 3,128 2,188 4,000 4,000 4,000 4,000 4,000 4,000 4,000 79-795-54-00-5460 DUES&SUBSCRIPTIONS 1,375 1,454 1,500 1,500P 2,500 2,500 2,500 2,500 2,500 79-795-54-00-5462 PROFESSIONAL SERVICES 73,265 60,998 65,000 65,000 75,000 75,000 75,000 75,000 75,000 79-795-54-00-5480 UTILITIES 9,538 12,869 20,000 20,000 23,000 24,380 25,843 27,394 29,038 79-795-54-00-5485 RENTAL&LEASE PURCHASE 2,558 2,408 4,500 4,500- 4,500 4,500 4,500 4,500 4,500 79-795-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 106 50 40,000 40,000 3,000 3,000 3,000 3,000 3,000 79-795-54-00-5496 PROGRAM REFUNDS 9,388 9,033 7,000 7,000 7,000 7,000 7,000 7,000 7,000 79-795-54-00-5497 PROPERTY TAX PAYMENT - - - - 30,000 - - - - 79-795-56-00-5602 HOMETOWN DAYS SUPPLIES 84,982 91,712 100,000 9 t 000, 100,000 100,000 100,000 100,000 100,000 47 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 79-795-56-00-5606 PROGRAM SUPPLIES 47,065 50,603 55,000 55,000 55,000 55,000 55,000 55,000 55,000 79-795-56-00-5607 CONCESSION SUPPLIES 19,144 17,714 18,000 18,000 18,000 18,000 18,000 18,000 18,000 79-795-56-00-5610 OFFICE SUPPLIES 1,792 2,503 >,000 "000' 3,000 3,000 3,000 3,000 3,000 79-795-56-00-5620 OPERATING SUPPLIES 6,533 19,426 7,500 7,500 7,500 7,500 7,500 7,500 7,500 79-795-56-00-5630 SMALL TOOLS&EQUIPMENT - - 1,000 1,000 1,000 1,000 1,000 1,000 1,000 79-795-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 1,522 616 500 500 500 500 500 500 500 79-795-56-00-5640 REPAIR&MAINTENANCE 920 132 2,000 2,000 2,000 2,000 2,000 2,000 2,000 79-795-56-00-5645 BOOKS&PUBLICATIONS - - 100 _ _ _ 79-795-56-00-5695 GASOLINE 996 1,437 3,000 3,000''i 3,210 3,435 3,675 3,932 4,207 79-795-99-00-9980 TRANSFER TO RECREATION CENTER 556,957 487,840 602,009 643,766 1,385,883 1,307,666 918,847 911,171 936,166 962,675 990,856 Expenditures 1,151,098 1,398,256 2,199,048 2,120,831 1,911,447 1,838,749 1,883,504 1,948,958 2,018,520 Surplus(Deficit) 48,510 40,303 29,656 111,938 (145,591) (10,905) 6,714 9,818 10,434 Fund Balance 280,065 320,370 322,699 432308 286,717 275,812 282,526 292,344 302,778 24.33% 22.91 11.67% 20.38"/.,. 15.00% 15.00% 15.00% 15.00% 15.00% 48 Library Operations Fund(82) The Yorkville Public Library provides the people of the community,from pre-school through maturity,with access to a collection of books and other materials which will serve their educational,cultural and recreational needs. The Library board and staff strive to provide the community an environment that promotes the love of reading. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 692,476 691,905 670,415 642,838 646,010 635,000 625,000 615,000 615,000 Intergovernmental 22,212 24,124 22,200 22,389 22,200 22,200 22,200 22,200 22,200 Licenses&Permits 4,681 - - - - - - - - Fines&Forfeits 12,864 9,404 9,300 9,300 9,300 9,300 9,300 9,300 9,300 Charges for Service 15,368 14,190 14,000 14,000 14,000 14,000 14,000 14,000 14,000 Investment Earnings 393 1,257 1,300 1,300 1,300 1,500 1,500 1,500 1,500 Reimbursements - 9,396 - - - - - - - Miscellaneous 15,045 12,489 9,250 8,003 7,500 7,500 7,500 7,500 7,500 Other Financing Sources 332,500 26,819 52,174 52,174 32,375 34,168 36,068 38,082 38,082 Total Revenue 1,095,539 789,584 778,639 750,004 732,685 723,668 715,568 707,582 707,582 Expenditures Salaries 432,008 420,283 447,540 447,540 447,540 447,540 447,540 447,540 447,540 Benefits 149,612 177,713 193,524 193,524 204,448 216,894 229,850 243,740 256,545 Contractual Services 88,124 104,651 109,049 109,049 112,465 113,334 114,256 115,233 116,268 Supplies 21,781 24,163 21,250 19,250 19,000 19,000 19,000 19,000 19,000 Other Financing Uses 332,519 5,469 - 21,226 - - - - - Total Expenditures 1,024,044 732,279 771,363 790,589 783,453 7969768 810,646 825,513 839,353 Surplus(Deficit) 71,495 57,305 7,276 (40,585) (50,768) (73,100) (95,078) (117,931) (131,771) Ending Fund Balance 388,831 446,136 407,430 405,551 354,783 281,683 186,605 68,674 (63,097) 37.97% 60.92% 52.82% 51.30% 45.28% 35.35% 23.02% 8.32% -7.52% Fund Balance $500 m $400 c $300 '�..+...� F $200 $100 $0 ($100) 49 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Library Operations 82-000-40-004000 PROPERTY TAXES 673,145 691,905 670,415 642,838 646,010 635,000 625,000 615,000 615,000 82-000-40-004012 PROPERTY TAXES-FOX INDUSTRIAL TIF 19,331 - - - _ - _ 82-000-41-00-4120 PERSONAL PROPERTY TAX 4,981 5,272 5,000 5,000 5,000 5,000 5,000 5,000 5,000 82-000-41-00-4170 STATE GRANTS 17,231 18,852 17,200 17,389 17,200 17,200 17,200 17,200 17,200 ho 82-000-42-00-4211 DEVELOPMENT FEES-BOOKS 4,681 82-000-43-00-4330 LIBRARY FINES 12,864 9,404 9,300 9,300'' 9,300 9,300 9,300 9,300 9,300 82-000-44-004401 LIBRARY SUBSCRIPTION CARDS 11,814 10,434 10,000 ,10,000 10,000 10,000 10,000 10,000 10,000 82-000-44-00-4422 COPY FEES 3,444 2,749 ;,000 3,000 3,000 3,000 3,000 3,000 3,000 82-00044-00-4440 PROGRAM FEES 110 1,008 1,000 1,000 1,000 1,000 1,000 1,000 1,000 82-00045-004500 INVESTMENT EARNINGS 393 1,257 1,300 1,300 1,300 1,500 1,500 1,500 1,500 82-000-46-004670 REIMB-EMPLOYEE INS CONTRIBUTIONS - 8,685 - _ _ _ _ 82-000-46-004671 REIMB-LIFE INSURANCE - 711 - - - _ 82-000-48-00-4820 RENTAL INCOME 2,695 1,556 2,000 2,000'-' 2,000 2,000 2,000 2,000 2,000 82-000-48-00-4824 DVD RENTAL INCOME 5,416 4,884 5,000 5,000 5,000 5,000 5,000 5,000 5,000 82-000-48-00-4832 MEMORIALS&GIFTS 6,119 5,201 2,000 _ - - _ - 82-000-48-00-4850 MISCELLANEOUS INCOME 815 848 250 1,003 500 500 500 500 500 82-000-49-00-4901 TRANSFER FROM GENERAL-P-TAX - - 21,490 21,490 _ _ _ - _ 82-000-49-004901 TRANSFER FROM GENERAL 332,500 26,819 30,684 30,684 32,375 34,168 36,068 38,082 38,082 Revenue 1,095,539 789,584 778,639 750,004 732,685 723,668 715,568 707,582 707,582 82-820-50-00-5010 SALARIES&WAGES 244,695 244,847 252,540 252,540" 252,540 252,540 252,540 252,540 252,540 82-820-50-00-5015 PART-TIME SALARIES 187,313 175,436 195,000 195,000 195,000 195,000 195,000 195,000 195,000 82-820-52-00-5212 RETIREMENT PLANCONTRI13UTTON 23,387 26,152 27,988 27,988 30,117 32,325 34,270 36,315 38,512 82-820-52-00-5214 FICA CONTRIBUTION 32,384 31,483 33,572 33,572`s 33,484 33,484 33,484 33,484 33,484 82-820-52-00-5216 GROUP HEALTH INSURANCE 86,334 85,076 94,116 94,116,4. 101,904 110,056 118,860 128,369 138,639 82-820-52-00-5222 GROUP LIFE INSURANCE 760 1,027 595 595 559 565 571 577 583 82-820-52-00-5223 DENTAL INSURANCE 6,061 5,950 5,926 5,926:;: 5,347 5,614 5,895 6,190 6,500 82-820-52-00-5224 VISION INSURANCE 686 643 643 643 662 682 702 723 745 82-820-52-00-5230 UNEMPLOYMENT INSURANCE - 2,435 2,500 2,500 2,500 2,500 2,500 2,500 2,500 82-820-52-00-5231 LIABILITY INSURANCE - 24,947 28,184 28,184.;. 29,875 31,668 33,568 35,582 35,582 82-820-54-00-5412 TRAINING&CONFERENCES - 500 500'` 500 500 500 500 500 50 FY 2012 FY 2013 FY 2014 -FT 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected 82-820-54-00-5415 TRAVEL&LODGING 215 798 600 600 600 600 600 600 600 82-820-54-00-5426 PUBLISHING&ADVERTISING - 22 100 100 100 100 100 100 100 82-820-54-00-5440 TELECOMMUNICATIONS 8,609 10,982 11,000 11,000 11,000 11,000 11,000 11,000 11,000 82-820-54-00-5452 POSTAGE&SHIPPING 538 244 500 500:: 500 500 500 500 500 82-820-54-00-5460 DUES&SUBSCRIPTIONS 7,495 8,379 12,000 12,000 12,000 12,000 12,000 12,000 12,000 82-820-54-00-5462 PROFESSIONAL SERVICES 29,909 38,778 29,000 29,000 29,000 29,000 29,000 29,000 29,000 82-820-54-00-5466 LEGAL SERVICES - 360 2,000 2,000: 2,000 2,000 2,000 2,000 2,000 82-820-54-00-5468 AUTOMATION 28,210 30,199 35,000 35,000- 35,000 35,000 35,000 35,000 35,000 82-820-54-00-5480 UTILITIES 8,872 10,508 12,600 12,600'. 14,490 15,359 16,281 17,258 18,293 82-820-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 4,276 3,632 5,000 5,000 5,000 5,000 5,000 5,000 5,000 82-820-54-00-5498 PAYING AGENT FEES - 749 749 749 2,275 2,275 2,275 2,275 2,275 82-820-56-00-5610 OFFICE SUPPLIES 5,005 5,497 8,000 8,000'.'. 8,000 8,000 8,000 8,000 8,000 82-820-56-00-5620 OPERATING SUPPLIES 4,694 7,738 8,000 8,000' 8,000 8,000 8,000 8,000 8,000 82-820-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - 1,550 82-820-56-00-5640 REPAIR&MAINTENANCE - 881 = ' 82-820-56-00-5671 LIBRARY PROGRAMMING 225 875 ry j 1,000 1,000 1,000 1,000 1,000 82-820-56-00-5676 EMPLOYEE RECOGNITION , 82-820-56-00-5680 ADULT BOOKS R-a 82-820-56-00-5681 JUVENILE BOOKS 82-820-56-00-5682 REFERENCE BOOKS W " 82-820-56-00-5683 AUDIO BOOKS 0 82-820-56-00-5684 COMPACT DISCS&OTHER MUSIC g t 'how g e = - 82-820-56-00-5685 DVD'S 1,260 2,421 6 a � a 2,000 2,000 2,000 2,000 2,000 82-820-56-00-5686 DEVELOPMENT FEES 4,681 82-820-56-00-5698 MEMORIALS&GIFTS 5,627 5,201 2, 82-820-56-00-5699 MISCELLANEOUS 289 - 250 250 82-820-99-00-9983 TRANSFER TO LIBRARY DEBT SERVICE - 5,469 _ 21,226 82-820-99-00-9984 TRANSFER TO LIBRARY CAPITAL 332,519 Expenditures 1,024,044 732,279 771,363 ' 790,589: 783,453 796,768 810,646 825,513 839,353 Surplus(Deficit) 71,495 57,305 -7,276 (40,585): (50,768) (73,100) (95,078) (117,931) (131,771) Fund Balance 388,831 446,136 407,430 405,551 354,783 281,683 186,605 68,674 (63,097) 3797% 60.92% 52.82% 51.30%'. 45.28% 35.35% 23.02% 8.32% -7.52% 51 Library Debt Service Fund(83) The Library Debt Service Fund accumulates monies for payment of the 2006 and 2013 refinancing bonds,which were issued to finance construction of the Library building. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 718,839 791,640 771,763 746,464 731,321 749,846 752,771 760,396 792,101 Investment Earnings 140 200 200 30 30 30 30 30 30 Other Financing Sources - 5,469 - 21,226 - - - - - Total Revenue 718,979 797,309 771,963 767,720 731,351 749,876 752,801 760,426 792,131 Expenditures Debt Service 720,800 795,488 769,638 767,720 731,321 749.846 752,771 760,396 792,101 Total Expenditures 720,800 795,488 769,638 767,720 731,321 749,846 752,771 760,396 792,101 Surplus(Deficit) (1,821) 1,821 2,325 - 30 30 30 30 30 Ending Fund Balance (1,821) - 2,325 - 30 60 90 120 150 N $3 Fund Balance $2 N $1 /$o ($2) ($3) 52 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FV 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Library Debt Service = r 83-000-40-00-4000 PROPERTY TAXES 718,839 791,640 771,763 746,464 731,321 749,846 752,771 760,396 792,101 83-00045-004500 INVESTMENT EARNINGS 140 200 200 30 30 30 30 30 30 83-000-49-00-4982 TRANSFER FROM LIBRARY OPS 5.469 21,226 Revenue 718,979 797,309 771,963 767,720 731,351 749,876 752,801 760,426 792,131 Debt Service-2005B Bond ° 83-830-83-00-8000 PRINCIPAL PAYMENT 175,000 290,000 335,000 335,000 83-830-83-00-8050 INTEREST PAYMENT 316,125 309,125 13,400 13,400 _ _ _ _ - Debt Service-2006 Bond 83-830-84-00-8000 PRINCIPAL PAYMENT 175,000 150,000 100,000 100,000 50,000 50,000 50,000 50,000 50,000 83-830-84-00-8050 INTEREST PAYMENT 54,675 46,363 39,238 39,238' 34,488 32,113 29,738 27,363 24,988 Debt Service-2013 Refunding Bond 83-830-99-00-8000 PRINCIPAL PAYMENT - - 170,000 155,000 455,000 485,000 500,000 520,000 565,000 83-830-99-00-8050 INTEREST PAYMENT - - 112,000 125,082 191,833 182,733 173,033 163,033 152,113 Expenditures 720,800 795,488 769,638 767,720 731,321 749,846 752,771 760,396 792,101 Surplus(Deficit) (1,821) 1,821 2,325 - 30 30 30 30 30 Fund Balance (1,821) - 2,325 30 60 90 120 150 53 Library Capital Fund (84) The Library Capital Fund derives its revenue from monies collected from building permits. The revenue is used for Library building maintenance and associated capital,contractual and supply purchases. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Licenses&Permits 17,669 35,200 20,000 55,000 20,000 20,000 20,000 20,000 20,000 Investment Earnings 71 8 20 15 20 20 20 20 20 Other Financing Sources 332,519 - - - - - - - - Total Revenue 350,259 35,208 20,020 55,015 20,020 20,020 20,020 20,020 20,020 Expenditures Contractual Services - - 3,500 3,500 3,500 3,500 3,500 3,500 3,500 Supplies - 26,312 35,350 32,209 51,515 16,520 16,520 16,520 16,520 Capital Outlay 10,965 - - - - - - - - Other Financing Uses 332,500 - - - - - - - - Total Expenditures 343,465 26,312 38,850 35,709 55,015 20,020 20,020 20,020 20,020 Surplus(Deficit) 6,794 8,896 (18,830) 19,306 (34,995) - - - - Ending Fund Balance 6,794 15,689 - 34,995 Fund Balance $40 $30 s $20 $10 - *�7�z $o 54 FY 2012 FY 2013 FY 2014 FY 2014 FY 201.5 FY 2016 FY 2017 FY 2018 FY 2019 Account Nom ber Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Library Capital 84-00042-00-4214 DEVELOPMENT FEES 17,669 35,200 20,000 55,000 20,000 20,000 20,000 20,000 20,000 84-000-45-00-4500 INVESTMENT EARNINGS 71 8 20 15 20 20 20 20 20 84-000-49-00-4982 TRANSFER FROM LIBRARY OPS 332,519 Revenue 350,259 35,208 20,020 55,015 20,020 20,020 20,020 20,020 20,020 84-840-54-00-5460 E-BOOKS SUBSCRIPTION - - 3,500 3,500 3,500 3,500 3,500 3,500 3,500 84-840-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 3,153 - - - - - _ _ 84-840-56-00-5683 AUDIO BOOKS - 84-840-56-00-5684 COMPACT DISCS&OTHER MUSIC - - 84-840-56-00-5685 DVD'S 1,768 - - _ - _ _ 84-840-56-00-5686 BOOKS - 21,391 35,350 (32,209 51,515 16,520 16,520 16,520 16,520 84-840-60-00-6020 BUILDINGS&STRUCTURES 10,965 - - - _ _ rt - 84-840-99-00-9901 TRANSFER TO GENERAL 332,500 Expenditures 343,465 26,312 38,850 35,709 55,015 20,020 20,020 20,020 20,020 Surplus(Deficit) 6,794 8,896 (18,830) 19,306 (34,995) - - - _ Fund Balance 6,794 15,689 - 34,995 55 Countryside TIF Fund(87) The Countryside TIF was created in February of 2005,with the intent of constructing a future retail development at Countryside Center. This TIF is located at the northwest corner of US Route 34 and IL Route 47. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 4,188 - - - 20,000 120,000 120,000 120,000 120,000 Investment Earnings 2,718 2,132 1,550 106 - - - - - Total Revenue 6,906 2,132 1,550 106 20,000 120,000 120,000 120,000 120,000 Expenditures Contractual Services 1,442 3,002 1,802,375 1,802,375 23,325 23,325 23,325 23,325 23,325 Debt Service 306,143 304,668 302,738 302,738 68,073 93,431 118,788 118,788 118,788 Total Expenditures 307,585 307,670 2,105,113 2,105,113 91,398 116,756 142,113 142,113 142,113 Surplus(Deficit) (300,679) (305,538) (2,103,563) (2,105,007) (71,398) 3,244 (22,113) (22,113) (22,113) Ending Fund Balance 1,877,872 1,572,335 (529,634) (532,672) (604,070) (600,826) (622,939) (645,052) (667,165) r $3,000 Fund Balance $2,000 r $1,000 $o ($1,000) 56 FY 2012 FV 2013 FY 2014 FV 2014 FY 2015 FY 2016 FV 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Countryside TIF 87-000-40-00-4000 PROPERTY TAXES 4,188 - - - - 100,000 100,000 100,000 100,000 87-00040-004070 BUSINESS DISTRICT TAX - - - - 20,000 20,000 20,000 20,000 20,000 87-000-45-004500 INVESTMENT EARNINGS 2,718 2,132 1,550 106 Revenue 6,906 2,132 1,550 106 20,000 120,000 120,000 120,000 120,000 87-870-54-00-5420 ADMINISTRATIVE FEES 1,067 2,627 2,000 2,000 2,000 2,000 2,000 2,000 2,000 87-870-54-00-5425 TIF INCENTIVE PAYOUT - - 1,800,000 1,800,000 - - - - - 87-870-54-00-5493 BUSINESS DISTRICT REBATE - - 20,000 20,000 20,000 20,000 20,000 87-870-54-00-5498 PAYING AGENT FEES 375 375 375 375` 1,325 1,325 1,325 1,325 1,325 Debt Service-2005 Bond 87-870-80-00-8000 PRINCIPAL PAYMENT 175,000 180,000 185,000 185,000 - - - - _ 87-870-80-00-8050 INTEREST PAYMENT 131,143 124,668 117,738 117,738 68,073 68,073 68,073 68,073 68,073 Debt Service-2013 Refunding Bond 87-870-93-00-8000 PRINCIPAL PAYMENT - - - - - - 87-870-93-00-8050 INTEREST PAYMENT - - 25,358 50,715 50,715 50,715 Expenditures 307,585 307,670 2,105,113 2,105,113 91,398 116,756 142,113 142,113 142,113 Surplus(Deficit) (300,679) (305,538) (2,103,563) (2,105,007) (71,398) 3,244 (22,113 (22,113) (22,113) Fund Balance 1,877,872 1,572,335 (529,634) (532,672) (604,070) (600,826) (622,939) (645,052) (667,165) 57 Downtown TIF Fund(88) The Downtown TV was created in 2006,in order to finance a mixed use development in the downtown area. FY 2014 FY 2012 FY 2013 Adopted FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Actual Actual Budget Projected Adopted Projected Projected Projected Projected Revenue Taxes 67,807 39,980 35,000 59,311 85,000 85,000 90,000 90,000 95,000 Investment Earnings 126 428 350 75 75 75 75 75 75 Other Financing Sources - 5,000 - 8,500 - - - - - Total Revenue 67,933 45,408 35,350 67,886 85,075 8 5,0 75 90,075 90,075 95,075 Expenditures Contractual Services 12,152 18,391 15,350 21,850 35,355 35,360 35,365 35,375 35,375 Capital Outlay 7,589 68,034 30,000 30,000 17,433 328,183 17,433 17,433 17,433 Total Expenditures 19,741 86,425 45,350 51,850 52,788 363,543 52,798 52,808 52,808 Surplus(Deficit) 48,192 (41,017) (10,000) 16,036 32,287 (278,468) 37,277 37,267 42,267 Ending Fund Balance 257,953 216,937 251,449 232,973 265,260 (13,208) 24,069 61,336 103,603 N $300 Fund Balance $200 N 3 L $100 r $0 ($100) 58 FY 2012 FY 2013 FY 2014 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 FY 2019 Account Number Description Actual Actual Budget Projected Adopted Projected Projected Projected Projected Downtown TIF 88-00040-00-4000 PROPERTY TAXES 67,807 32980 35,000 52,811 65,000 65,000 70,000 70,000 75,000 88-000-40-00-4070 BUSINESS DISTRICT TAX - - - 6,500 20,000 20,000 20,000 20,000 20,000 88-00045-00-4500 INVESTMENT EARNINGS 126 428 350 75 75 75 75 75 75 88-00049-0011910 SALE OF CAPITAL ASSETS 5,000 8,500 Revenue 67,933 45,408 35,350 67,886 85,075 85,075 90,075 90,075 95,075 88-880-54-00-5420 ADMINISTRATIVE FEES 366 3,951 350 350 355 360 365 375 375 88-880-54-00-5466 LEGAL SERVICES 11,786 14,440 15,000 15,000 15,000 15,000 15,000 15,000 15,000 88-880-54-00-5425 TIF INCENTIVE PAYOUT - - - - - - 88-880-54-00-5493 BUSINESS DISTRICT REBATE - - - 6,500 20,000 20,000 20,000 20,000 20,000 88-880-60-00-6000 PROJECT COSTS 7,589 56,367 10,000 10,000 10,000 10,000 10,000 10,000 10,000 88-880-60-00-6048 DOWNTOWN STREETSCAPE IMPROVEMENT - - - - - 310,750 - - - 88-880.60-00.6079 ROUTE 47 EXPANSION - 11,667 20,000 20,000 7,433 7,433 7,433 7,433 7,433 Expenditures 19,741 86,425 45350 51,850.' 52,788 363,543 52,798 52,808 52,808 Surplus(Deficit) 48,192 (41,017) (10,000) 16,036'. 32,287 (278,468) 37,277 37,267 42,267 Fund Balance 257,953 216,937 251,449 232,973 265,260 (13,208) 24,069 61,336 103,603 59