Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Ordinance 2011-13
C9�9FZTY OF i(tC,DALL 6= I LED STATE OF ILLINOIS ) ss Ap, q 2u c� COUNTY OF KENDALL ) coulITY CLERK ORDINANCE NO. 2011- 13 ORDINANCE APPROVING THE 2011 -2012 FISCAL BUDGET FOR THE UNITED CITY OF YORKVILLE 'I i WHEREAS, the Mayor and City Council of the UNITED CITY OF YORKVILLE have duly held all Public Hearings, allowed public input, and have duly considered formation of a budget for the 2011 -2012 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 2011 -2012 Fiscal Year Budget being submitted on March 22, 2011 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 2011 -2012 Budget totaling $22,531,500 including the amounts of $10,727,492 General Fund, $661,000 Motor Fuel Tax Fund, $0 Municipal Building Fund, $54,000 Police Capital Fund, $92,595 Public Works Capital Fund, $123,500 Parks & Recreation Capital Fund, $2,919,989 Sewer Fund, $2,571,858 Water Fund, $360,000 City -Wide Capital Fund, $428,669 Debt Service Fund, $301,084 Land Cash Fund, $1,175,710 Parks & Recreation Fund, $691,738 Recreation Center Fund, $1,586,600 Library Fund, $0 Fox Industrial TIF, $307,543 Countryside TIF, $516,840 Downtown TIF, $9,078 Sunflower SSA, and $3,804 Fox Hill SSA is hereby adopted for the 2011 -2012 Fiscal Year, as presented. Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this /o1 day of -APR I L , A.D. 2011. CITY CLERK ROBYN SUTCLIFF GEORGE GILSON, JR. n ARDEN JOE PLOCHER — V WALLY WERDERICH GARY GOLINSKI MARTY MUNNS T I ROSE SPEARS n DIANE TEELING Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this 616 day of AP(ZIL , A.D. 2011. MAYOR II i FISCAL YEAR 2012 BUDGET For the Fiscal Year May 1, 2011- April 30, 2012 • • ---------------- • , ♦ -, . ourrty Seat • of United City of • 800 Game Farm Road Yorkville, Illinois 60560 (630)553 -4350 www.yorkville.il.us United City Yorkville, Illinois Fiscal Year 2012 Budget May 1, 2011 to April 30, 2012 Elected Officials Mayor: Gary Golinski 1st Ward Alderman: Carlo Colosimo 1st Ward Alderman: George Gilson, Jr. 2nd Ward Alderman: Jackie Milschewski 2nd Ward Alderman: Vacant 3rd Ward Alderman: Marty Munns 3rd Ward Alderman: Chris Funkhouser 4th Ward Alderman: Rose Spears 4th Ward Alderman: Diane Teeling Treasurer: William Powell City Clerk: Beth Warren Administration City Administrator: Bart Olson Finance Director: Rob Fredrickson Public Works Director: Eric Dhuse Police Chief: Rich Hart City Engineer: Joe Wywrot Community Development Director: Krysti Barksdale -Noble Library Director: Michelle Pfister I 2012 Budget Table of Contents BUDGET SUMMARY SPECIAL REVENUE FUNDS (CONT.) Revenues by Category ..................... ..............................1 Fox Industrial TIF ( 85)..................... .............................51 Revenues by Category pie chart ..... ..............................2 Countryside TIF ( 87)........................ .............................55 Expenditures by Category ............... ..............................3 Downtown TIF ( 88)......................... .............................59 Expenditures by Category pie chart .............................4 Fox Hill SSA ( 11).............................. .............................62 Fund Balance Summary 5 Sunflower SSA 12 ......................... .............................65 Personnel Summary ......................... ..............................6 Revenue Budget Summary .............. ..............................8 DEBT SERVICE FUNDS Expenditure Budget Summary ........ ..............................9 Fund Balance History ...................... .............................10 Debt Service Fund ( 42).................. .............................68 Property Tax Levy Summary .......... .............................11 CAPITAL PROJECT FUNDS GENERAL FUND Municipal Building Fund ( 16) ......... .............................74 General Fund Summary ( 01) .......... .............................12 Park s and Recreation Capital Fund (22)...................77 Revenue by Category pie chart ..... .............................13 Police Capital Fund 20 80 Revenue Detail ................................. .............................14 Public Works Capital Fund 21 83 Expenditures by Category pie chart ...........................16 City -Wide Capital Fund ( 23)........... .............................87 Expenditures by Category & Department .................17 Expenditures by Department ......... .............................19 ENTERPRISE FUNDS Administration ................................. .............................20 Finance............................................. .............................23 Water Fund ( 51)............................... .............................90 Community Relations ...................... .............................25 Sewer Fund ( 52 )............................. ............................104 Engineering Department ................ .............................27 Recreation Center Fund (80)........ ............................117 Police Department .......................... .............................29 Community Development ............. .............................32 LIBRARY Public Works .................................... .............................34 Administrative Services .................. .............................37 Library Fund 82 121 SPECIAL REVENUE FUNDS Motor Fuel Tax Fund ( 15) ............... .............................39 Parks and Recreation Fund (79) .... .............................42 Land Cash Fund( 72) ......................... .............................48 United City of Yorktille Revenues by Category Fiscal Year 2012 Other Inter- Licenses & Fines & Charges Investment Reimb- Miscel- Land Financing Fund FUND Taxes governmental Permits Forfeits for Services Earnings ursements laneous Cash Sources Total General Fund 7,514,504 1,738,496 165,650 215,100 1,303,932 2,000 340,800 16,000 - 194,992 11,491,374 Special Revenue Funds Motor Fuel Tax - 517,000 - - - 1,000 493,000 - - - 1,011,000 Parks and Recreation - - - - 345,000 300 - 97,700 - 732,710 1,175,710 Land Cash - 400,000 - - - - - - 20,500 - 420,500 Fox Industrial TIF - - - - - - - - - - - Countryside TIF 6,250 - - - - 4,000 - - - - 10,250 Downtown TIF 88,550 - - - - - - - - - 88,550 Fox Hill SSA 3,786 - - - - - - - - - 3,786 Sunflower SSA 7,530 - - - - - - - - - 7,530 Debt Service Fund 324,179 - - - - - - - - 103,740 427,919 Capital Project Funds Municipal Building - - 5,250 - - - - - - - 5,250 Parks and Recreation Capital - - 1,750 - - 80 - 1,000 - - 2,830 Police Capital - - 16,500 5,000 - - - - - - 21,500 Public Works Capital - - 24,500 - 7,900 - - - - 3,500 35,900 City -Wide Capital - 231,000 60,600 - - - - - - 125,000 416,600 Enterprise Funds Water 133,866 - - - 2,425,250 2,000 - 50,000 - 83,863 2,694,979 Sewer 1,754,690 - - - 1,349,000 1,800 - - - - 3,105,490 Recreation Center - - - - 603,500 - - 7,500 - - 611,000 Library Fund 1,395,800 18,500 - 20,000 20,500 2,000 - 6,500 - - 1,463,300 GRAND TOTAL REVENUES 11,229,155 2,904,996 274,250 240,000 6,055,082 13,180 833,800 178,700 20,500 1,243,805 22,993A68 1 United City of Yorkville Revenues by Category Fiscal Year 2012 Intergovernmental Licenses & Permits 12.63% 1.19% Taxes 48.84% Fines & Forfeits 1.04% i Charges for Services ' 26.33% Investment Earnings 0.06% Other Financing Use Reimbursements 5.41% 3.63% Land Cash 0.09% Miscellaneous 0.78% 2 United City of Yorkville Expenditures by Category Fiscal Year 2012 Other Contractual Capital Developer Debt Financing Fund FUND Salaries Benefits Services Supplies Outlay Contingencies Commitments Service Uses Total General Fund 3,310,895 2,510,132 3,627,320 303,695 4,000 10,000 - - 961,450 10,727,492 Special Revenue Funds Motor Fuel Tax - - - 311,600 349,400 - - - - 661,000 Parks and Recreation 648,300 109,730 150,430 267,250 - - - - - 1,175,710 Land Cash - - - - 281,000 - - - 20,084 301,084 Fox Industrial TIF - - - - - - - - - - Countryside TIF - - 1,400 - - - - 306,143 - 307,543 Downtown TIF - - 1,50 - 515,340 - - - - 516,840 Fox Hill SSA - - 3,804 - - - - - - 3,804 Sunflower SSA - - 9,078 - - - - - - 9,078 Debt Service Fund - - 750 - - - - 427,919 - 428,669 Capital Project Funds Municipal Building - - - - - - - - - - Parks and Recreation Capital - - - - 120,00 - - - 3,50 123,500 Police Capital - - 11,500 2,50 40,00 - - - - 54,00 Public Works Capital - - 6,300 2,00 2,00 - - 82,295 - 92,595 City -Wide Capital - - - - 235,00 - - 125,00 - 360,00 Enterprise Funds Water 377,00 65,700 401,850 360,30 96,00 - 275,868 903,277 91,863 2,571,858 Sewer 258,00 45,230 52,800 81,50 24,60 - 30,996 2,259,955 166,908 2,919,989 Recreation Center 232,700 27,708 380,580 50,750 - - - - - 691,738 Library Fund 475,00 140,500 116,800 123,50 - 10,00 - 720,80 - 1,586,600 GRAND TOTAL EXPENDITURES 5,301,895 2,899,000 4,764,112 1,503,095 1,667,340 20,000 306,864 4,825,389 1,243,805 22,531,500 3 United City of Yorkville Expenditures by Category Fiscal Year 2012 Benefits 12.87% Salaries 23.53% Contractual Services 21.14% Supplies 6.67% Other Financing Uses 5.52% Capital Outlay 7.40% Developer Commitments 1.36% Debt Service 21.42% Contingencies 0.09% 4 United City of Yorkville Fiscal Year 2012 Budget Fund Balance Summary Beginning Budgeted Budgeted Surplus Ending FUND Fund Balance Revenues Expenditures (Deficit) Fund Balance General Fund (505,246) 11,491,374 10,727,492 763,882 258,636 Special Revenue Funds Motor Fuel Tax 426,755 1,011,000 661,000 350,000 776,755 Parks and Recreation - 1,175,710 1,175,710 - - Land Cash (431,646) 420,500 301,084 119,416 (312,230) Fox Industrial TIF - - - - - Countryside TIF 2,180,673 10,250 307,543 (297,293) 1,883,380 Downtown TIF 210,156 88,550 516,840 (428,290) (218,134) Fox Hill SSA 18,334 3,786 3,804 (18) 18,316 Sunflower SSA 12,528 7,530 9,078 (1,548) 10,980 Debt Service Fund 8,528 427,919 428,669 (750) 7,778 Capital Project Funds Municipal Building (585,724) 5,250 - 5,250 (580,474) Parks and Recreation Capital 44,301 2,830 123,500 (120,670) (76,369) Police Capital 167,147 21,500 54,000 (32,500) 134,647 Public Works Capital 102,237 35,900 92,595 (56,695) 45,542 City -Wide Capital (5,063) 416,600 360,000 56,600 51,537 Enterprise Funds Water 560,284 2,694,979 2,571,858 123,121 683,405 Sewer 2,297,289 3,105,490 2,919,989 185,501 2,482,790 Recreation Center (227,696) 611,000 691,738 (80,738) (308,434) Library Fund (34,923) 1,463,300 1,586,600 (123,300) (158,223) Totals 4,237,935 22,993,468 22,531,500 461,968 4,699,903 5 United City of Yorkville Personnel Summary Fiscal Year 2012 Budget Projected Adopted FY 2011 FY 2011 FY 2011 FY 2012 FY 2012 FY 2012 Full -time Part -time Total Full -time Part -time Total Personnel by Department Administration 3.5 0.0 3.5 3.5 0.0 3.5 Finance 4.0 0.0 4.0 4.0 0.0 4.0 Community Relations 0.0 1.0 1.0 0.0 1.0 1.0 Engineering 3.0 0.0 3.0 3.0 0.0 3.0 Police 28.0 8.0 36.0 28.0 8.0 36.0 Community Development 3.0 1.0 4.0 3.0 1.0 4.0 Public Works 14.0 0.0 14.0 14.0 0.0 14.0 Parks 8.0 4.0 12.0 8.0 4.0 12.0 Recreation 3.5 1.0 4.5 3.5 1.0 4.5 Recreation Center 1.0 18.0 19.0 1.0 18.0 19.0 Library 5.0 35.0 40.0 5.0 31.0 36.0 73.0 68.0 141.0 73.0 64.0 137.0 Personnel by Fund General 44.5 10.0 54.5 44.5 10.0 54.5 Water 6.5 0.0 6.5 6.5 0.0 6.5 Sewer 4.5 0.0 4.5 4.5 0.0 4.5 Park and Recreation 11.5 5.0 16.5 11.5 5.0 16.5 Recreation Center 1.0 18.0 19.0 1.0 18.0 19.0 Library 5.0 35.0 40.0 5.0 31.0 36.0 73.0 68.0 141.0 73.0 64.0 137.0 Personnel by Department Administration City Administrator (General /Rec) 0.5 0.0 0.5 0.5 0.0 0.5 Deputy City Clerk 1.0 0.0 1.0 1.0 0.0 1.0 Haman Resource Manager 1.0 0.0 1.0 1.0 0.0 1.0 Administrative Secretai) 1.0 0.0 1.0 1.0 0.0 1.0 Finance Finance Director 1.0 0.0 1.0 1.0 0.0 1.0 Accounting Clerk 1 1.0 0.0 1.0 1.0 0.0 1.0 Accounting Clerk 1.0 0.0 1.0 1.0 0.0 1.0 Utility Billing Clerk (Water Fend) 1.0 0.0 1.0 1.0 0.0 1.0 Community Relations CommunityRelations Officer 0.0 1.0 1.0 0.0 1.0 1.0 Engineering City Engineer 1.0 0.0 1.0 1.0 0.0 1.0 Civil Engineer 1.0 0.0 1.0 1.0 0.0 1.0 Engineering Tech (Sewer Fund) 1.0 0.0 1.0 1.0 0.0 1.0 6 United City of Yorkville Personnel Summary Fiscal Year 2012 Budget Projected Adopted FY 2011 FY 2011 FY 2011 FY 2012 FY 2012 FY 2012 Full -time Part -time Total Full -time Part -time Total Police Chief of Police 1.0 0.0 1.0 1.0 * 0.0 1.0 Deputy Chief of Police 2.0 * 0.0 2.0 2.0 * 0.0 2.0 Lieutenants 1.0 * 0.0 1.0 1.0 * 0.0 1.0 Sergeants 3.0 * 0.0 3.0 3.0 * 0.0 3.0 Police Officers 18.0 * 4.0 * 22.0 18.0 * 4.0 22.0 Office Supervisor 1.0 0.0 1.0 1.0 0.0 1.0 Secretary 2.0 1.0 3.0 2.0 1.0 3.0 Evidence Technician 0.0 1.0 1.0 0.0 1.0 1.0 Cadets 0.0 1.0 1.0 0.0 1.0 1.0 Crossing Guards 0.0 1.0 1.0 0.0 1.0 1.0 * sworn 25.0 4.0 29.0 25.0 4.0 29.0 Community Development Communiq Development Director 1.0 0.0 1.0 1.0 0.0 1.0 Chief Building Official 1.0 0.0 1.0 1.0 0.0 1.0 City Park Designer 1.0 0.0 1.0 1.0 0.0 1.0 Building Adatinistrative Assistant 0.0 1.0 1.0 0.0 1.0 1.0 Public Works Public Works Director (Water /Sewer) 1.0 0.0 1.0 1.0 0.0 1.0 Foreman - Street Operations 1.0 0.0 1.0 1.0 0.0 1.0 Foreman (Water Fund) 1.0 0.0 1.0 1.0 0.0 1.0 Foreman (Sewer Fund) 1.0 0.0 1.0 1.0 0.0 1.0 Operator - Street Operations 2.0 0.0 2.0 2.0 0.0 2.0 Operator (Water Fund) 2.0 0.0 2.0 2.0 0.0 2.0 Maintenance Worker II - Sweet Ops 2.0 0.0 2.0 2.0 0.0 2.0 Maintenance Worker ll (Water Fund) 2.0 0.0 2.0 2.0 0.0 2.0 Maintenance Worker I (Sewer Fund) 2.0 0.0 2.0 2.0 0.0 2.0 Parks Parks Superintendent 1.0 0.0 1.0 1.0 0.0 1.0 Foreman 1.0 0.0 1.0 1.0 0.0 1.0 Maintenance Workerl 2.0 0.0 2.0 2.0 0.0 2.0 Maintenance Workerll 4.0 0.0 4.0 4.0 0.0 4.0 Seasonal Staff 0.0 4.0 4.0 0.0 4.0 4.0 Recreation Director of Parks and Recreation 0.5 0.0 0.5 0.5 0.0 0.5 Recreation Superintendent 1.0 0.0 1.0 1.0 0.0 1.0 Recreation Coordinator 1.0 0.0 1.0 1.0 0.0 1.0 Office Supervisor 1.0 0.0 1.0 1.0 0.0 1.0 Receptionist 0.0 1.0 1.0 0.0 1.0 1.0 Recreation Center Facility Coordinator 1.0 0.0 1.0 1.0 0.0 1.0 Front Desk Staff 0.0 9.0 9.0 0.0 9.0 9.0 Janitorial Staff 0.0 2.0 2.0 0.0 2.0 2.0 Kidz Chub Staff 0.0 4.0 4.0 0.0 4.0 4.0 Preschool Staff 0.0 3.0 3.0 0.0 3.0 3.0 Library Library Director 1.0 0.0 1.0 1.0 0.0 1.0 Director of Adult Services 1.0 0.0 1.0 1.0 0.0 1.0 Director of Youth Services 1.0 0.0 1.0 1.0 0.0 1.0 Director of Technical Services 1.0 0.0 1.0 1.0 0.0 1.0 Circulation Manager 1.0 0.0 1.0 1.0 0.0 1.0 Library Clerks 0.0 30.0 30.0 0.0 26.0 26.0 Building Manager 0.0 1.0 1.0 0.0 1.0 1.0 Custodian 0.0 4.0 4.0 0.0 4.0 4.0 United City of Yorkville Revenue Budget Summary - All Funds Fiscal Years 2009 - 2014 FY2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 FUND Actual Actual Budget Projected Adopted Projected Projected General Fund 11,160,942 11,007,428 11,433,025 11,268,062 11,491,374 11,665,831 11,850,039 Special Revenue Funds Motor Fuel Tax 426,652 473,203 356,000 616,462 1,011,000 903,650 522,145 Parks and Recreation 1,535,101 1,517,079 1,479,990 1,155,536 1,175,710 1,175,710 1,175,710 Land Cash 734,100 269,148 413,000 471,894 420,500 420,500 116,500 Fox Industrial TIF 208,902 216,721 216,727 228,360 - - - Countryside TIF 45,777 14,472 12,354 11,008 10,250 10,250 10,250 Downtown TIF 75,139 88,550 88,550 75,362 88,550 88,550 88,550 Fox Hill SSA 6,353 19,897 19,463 19,894 3,786 3,804 4,184 Sunflower SSA 15,939 13,871 13,112 13,871 7,530 9,078 9,986 Debt Service Fund 746,252 489,922 429,404 430,304 427,919 425,844 328,179 Capital Project Funds Municipal Building 13,650 9,750 55,000 22,000 5,250 5,250 5,250 Parks and Recreation Capital 33,472 51,873 17,500 2,080 2,830 1,830 1,830 Police Capital 46,207 41,796 62,000 43,423 21,500 21,500 21,500 Public Works Capital 94,500 48,008 35,000 32,225 35,900 34,900 34,900 City -Wide Capital 298,100 174,800 421,500 314,349 416,600 60,600 60,600 Enterprise Funds Water 2,294,111 1,960,778 2,122,354 2,546,868 2,694,979 2,721,123 2,754,999 Sewer 1,203,626 1,993,189 881,800 1,430,217 3,105,490 3,683,570 3,536,738 Recreation Center 597,992 583,040 609,000 590,700 611,000 611,000 611,000 Library Fund 1,228,546 1,278,809 1,359,924 - 1,463,300 - - GRAND TOTAL REVENUES 20,765,360 20,252,335 20,025 19 22,993,468 21,842,990 21 8 i United City of Yorkville Expenditure Budget Summary - All Funds Fiscal Years 2009 - 2014 FY2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 FUND Actual Actual Budget Projected Adopted Projected Projected General Fund 12,895,022 12,718,624 11,376,980 11,280,369 10,727,492 11,364,006 11,261,817 I Special Revenue Funds Motor Fuel Tax 462,204 368,519 475,600 595,325 661,000 1,193,000 1,009,550 Parks and Recreation 1,560,187 1,435,817 1,461,912 1,180,687 1,175,710 1,175,710 1,175,710 Land Cash 757,124 307,056 665,449 300,115 301,084 224,851 425,640 Fox Industrial TIF 106,487 79,013 80,433 651,711 - - - Countryside TIF 156,234 308,867 308,093 308,093 307,543 306,068 304,138 Downtown TIF 53,937 1,832 1,500 1,500 516,840 30,130 30,130 Fox Hill SSA 20,012 4,011 3,458 3,786 3,804 4,184 4,603 Sunflower SSA 14,840 8,782 8,253 7,530 9,078 9,986 10,985 Debt Service Fund 508,995 482,294 429,404 429,404 428,669 426,644 328,579 Capital Project Funds Municipal Building 59,400 57,200 - - - - - Parks and Recreation Capital 51,095 10,773 173,135 24,631 123,500 2,500 2,500 Police Capital 67,620 7,364 104,000 86,560 54,000 54,000 54,000 Public Works Capital 405,701 86,295 139,000 87,795 92,595 90,595 90,595 City -Wide Capital 391,278 100,000 582,500 301,034 360,000 4,000 4,000 Enterprise Funds Water 2,662,654 2,075,295 2,122,677 2,325,944 2,571,858 3,133,787 2,776,397 Sewer 2,288,201 1,815,238 2,020,433 1,868,139 2,919,989 3,527,230 3,626,096 Recreation Center 675,617 633,279 675,301 690,581 691,738 697,738 703,738 Library Fund 1,314,193 1,506,868 2,158,986 605,925 1,586,600 - - GRAND TOTAL EXPENDITURES 24,450,800 22,007,123 22,787,114 20,749,128 22,531,500 22,244,429 21,808,478 9 United City of Yorkville Fund Balance History Fiscal Years 2009 - 2014 FY2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 FUND Actual Actual Budget Projected Adopted Projected Projected General Fund 1,218,257 (492,939) 1,274,302 (505,246) 258,636 560,461 1,148,683 Special Revenue Funds Motor Fuel Tax 300,934 405,618 181,334 426,755 776,755 487,405 - Parks and Recreation (56,112) 25,151 (38,034) - - - Land Cash (565,517) (603,425) (817,966) (431,646) (312,230) (116,581) (425,721) Fox Industrial TIF 285,643 423,351 421,937 - - - - Countryside TIF 2,772,153 2,477,758 2,476,414 2,180,673 1,883,380 1,587,562 1,293,674 Downtown TIF 49,575 136,294 136,625 210,156 (218,134) (159,714) (101,294) Fox Hill SSA (13,660) 2,226 2,345 18,334 18,316 17,936 17,517 Sunflower SSA 1,099 6,188 5,958 12,528 10,980 10,072 9,073 Debt Service Fund - 7,628 - 8,528 7,778 6,978 6,578 Capital Project Funds Municipal Building (560,274) (607,724) (505,274) (585,724) (580,474) (575,224) (569,974) Parks and Recreation Capital 25,752 66,852 (129,883) 44,301 (76,369) (77,039) (77,709) Police Capital 175,851 210,284 133,851 167,147 134,647 102,147 69,647 Public Works Capital 196,095 157,807 92,095 102,237 45,542 (10,153) (65,848) City -Wide Capital (93,178) (18,378) (254,178) (5,063) 51,537 108,137 164,737 Enterprise Funds Water 453,875 339,360 453,552 560,284 683,405 270,741 249,343 Sewer 2,557,262 2,735,211 1,418,629 2,297,289 2,482,790 2,639,130 2,549,772 Recreation Center (77,579) (127,815) (143,880) (227,696) (308,434) (395,172) (487,910) Library Fund 799,062 571,002 - (34,923) (158,223) (158,223) (158,223) Totals 7,469,238 5,714 4,707,827 4,237,935 4,699,903 4,298,464 3,622,346 i 10 f Property Tax Levy for the Fiscal Year 2012 Budget FY 2010 FY 2011 FY 2012 2008 2008 2009 2009 1 2010 2010 Levy Request Levy Extension Levy Request Levy Extension Levy Request Levy Extension Corporate $ 859,661 $ 749,837 187.1%j $ 683,500 $ 655,946 = 91i%' $ 823,874 $ 793,563 Bonds & merest ^ $ $ $ $ $ 2,212,735 $ 2,212,770 IMRF Pension $ 449,515 $ 408,487 90.9%I $ 466,991 $ 448,388 �9 030; $ 449,719 $ 433,303 Police Protection $ 341,143 $ 310,315 910 %? $ 350,903 $ 336,940 "96 0%' $ 347,098 $ 334,384 Police Pension $ 325,000 $ 323,291 99; $ 350,000 $ 336,075 96 0%j $ 375,000 $ 361,284 Audit $ 45,325 $ 41,187 90 Q90 $ 57,000 $ 54,774 =91 qo; $ 54,936 $ 52,990 Liability Insurance $ 240,000 $ 218,349 91�%_I $ 350,000 $ 336,075 966loj $ 344,129 $ 331,527 Social Security $ 335,782 $ 305,238 90�% 1 $ 317,124 $ 304,538 9G'6'�� $ 305,441 $ 294,332 School Crossing Guard $ 26,350 $ 24,2602] $ 25,000 $ 24 043 236 $ 24,767 $ 23,935 Unemployment Insurance $ 28,800 $ 26,518 92l%;! $ 25,788 $ 24,792 $ 25,000 $ 24,096 Subtotal City $ 2,651,576 $ 2,407,483 x}030 $ 2,626,306 $ 2,521,570 ;' i $ 4,962,699 $ 4,862,185 t - Library Operations $ 626,202 $ 622,624 99A% $ 650,000 $ 663,101 ]9�2 bei'0 $ 675,000 $ 675,000 Library Bonds & Interest ^ $ 564,050 $ 561,150 39%; $ 605,925 $ 589,090 , ;97 90; $ 720,800 $ 720,820 Subtotal Library $ 1,190,252 $ 1,183,774 ---9 $ 1,255,925 $ 1,252191 _ '9%1 $ 1,395,800 $ 1,395,820 kj otpl (PT T] Tlon -FT L G7 $ . - 3,841$28 A �i59, 251 `93 53io ' 3;88'2 231 $ 3 773 761 97 2 $e s0 18, 9 less Total Bonds & Interest $ 564,050 $ 561,150 �9. %; $ 605,925 $ 589,090 =�21 $ 2,933,535 $ 2,933,589 * 2010 Levy Extension amounts are based on the final extension sheet received from the Kendall County Clerk & Recorders Office in April 2011 ^ Bonds & Interest Levy Breakout Server Fund Series 2004B $ 258,650 $ 258,654 Series 2005D $ 1,385,950 $ 1,385,972 Series 2008 Refunding $ 110,090 $ 110,092 Water Fund Series 2007A $ 133,866 $ 133,868 Debt Set -vice Fund Series 2005A $ 324,179 $ 324,184 Total City Bonds & Interest $ 2,212,735 $ 2,212,770 Liban , Bonds & Interest Series 2005B $ 491,125 $ 491,138 Series 2006 $ 229,675 $ 229,681 $ 720,800 $ 720,820 11 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 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projected Adopted Project Pr ojec t ed Revenue Taxes 6,594,157 6,794,541 7,090,349 7,157,226 7,514,504 7,643,715 7,778,606 Intergovernmental 1,329,472 1,652,385 1,718,866 1,736,795 1,738,496 1,788,496 1,838,496 Licenses & Permits 578,733 259,850 322,670 218,000 165,650 165,650 165,650 Fines & Forfeits 152,734 199,140 382,550 204,671 215,000 215,000 215,000 Charges for Service 1,147,388 1,252,904 1,212,085 1,304,962 1,303,932 1,306,411 1,308,939 Investment Earnings 18,629 62,043 3,000 2,058 2,000 2,000 2,000 Reimbursements 395,385 424,703 341,543 391,843 340,800 335,800 337,800 Miscellaneous 41,959 17,204 26,605 17,150 16,000 16,000 16,000 Other Financing Sources 902,485 344,658 335,357 235,357 194,992 192,759 187,548 Total Revenue 11,160,942 11,007,428 11,433,025 11,268,062 11,491,374 11,665,831 11,850,039 Expenditures Salaries 4,374,826 4,048,018 3,766,082 3,558,657 3,310,895 3,310,895 3,310,895 Benefits 2,052,692 2,325,141 2,461,298 2,326,791 2,510,132 2,738,400 2,990,413 Contractual Services 3,839,677 4,423,646 3,105,690 3,609,202 3,627,320 3,717,211 3,741,722 Supplies 322,098 249,742 320,884 310,039 303,695 308,825 315,052 Capital Outlay 46 11,330 44,232 42,232 4,000 4,000 4,000 Contingencies (7,047) 16,153 10,000 100,000 10,000 10,000 10,000 Other Financing Uses 2,312,731 1,644,594 1,668,794 1,333,448 961,450 1,274,675 889,735 Total Expenditures 12,895,022 12,718,624 11,376,980 11,280,369 10,727,492 11,364,006 11,261,817 i Surplus (Deficit) (1,734,080) (1,711,196) 56,045 (12,307) 763,882 301,825 588,222 Ending Fund Balance 1,218,257 (492,939) 1,274,302 (505,246) 258,636 560,461 1,148,683 -4.5% 2.4% 4.9% 10.2% $1,500 Fund Balance $1,000 N 'o $500 L ~ $0 ($500) ($1,000) 12 United City of Yorkville Revenue by Category General Fund FY 2012 Budget Fines & Forfeits Reimbursements Invest Earnings 2.97% 1.87% 0.02% Licenses & Permits Charges for Service Intergovernmental 1.44 ° 11.35% Miscellaneous 0.14% 15.13% Other Financing Sources 1.70% Taxes 65.39% 13 United City of Yorkville General Fund O1 GENERAL FUND REVENUE fl' 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actuol Actual Budget Projected Adopted Projected Projected Toles 01- 000 -40 -00 -4000 PROPERTY TAXES - CORPORATE LEVY 1,804,657 2,084,192 2,100,000 2,185,529 2,290,964 2,295,984 2,305,000 01- 000 -40 -00-4010 PROPERTY TAXES - POLICE PENSION 297,327 323,291 350,000 336,041 375,000 400,000 425,000 01- 00040 -00 -4012 PROPERTY TAXES- FOX INDUSTRIAL TIF - - - 29,804 - - - ForG,dustrinlTlFLipuidarian FI'2011 01- 000 -40 -00 -4030 MUNICIPAL SALES TAX 2,500,285 2,446,099 2,440,000 2,500,000 2,550,000 2,601,000 2,653,020 01- 000 -40 -00 -4040 ELECTRIC UTILITY TAX 572,959 548,774 565,000 580,000 591,600 603,432 615,501 01- 000 -40 -00-4041 NATURAL GAS UTILITY TAX 349,136 284,895 396,000 285,000 290,700 296,514 302,444 01- 000 -40 -00-4043 TELEPHONE UTILITY TAX 519,669 518,446 600,000 525,000 535,500 546,210 557,134 01- 00040 -00-4045 CABLE FRANCHISE FEES 189,131 188,282 190,000 200,000 204,000 208,1180 212,242 I O1- 000 -40 -00-4050 HOTELTAX 19,652 17,262 20,000 30,000 30,600 31,212 31,836 01- 00040 -00-4060 AMUSEMENT TAX 111,083 112,964 162,964 108 134,000 134,000 134,000 �.. 01. 00040 -00-4065 ADMISSIONS TAX - - 112,964 181,744 190,000 2011,000 210,000 01- 000.40.00-4070 BUSINESS DISTRICT TAX 226,122 263,363 150,000 294,000 300,000 300,000 300,000 O1- 000 -40 -00-4075 AUTO RENTAL TAX 4,137 6,973 3,421 7,000 7,140 7,283 7,429 01- 000 -40 -00-4080 PARA- MUTUELTAX - - - 3,000 15,000 20,0011 25,000 OTB $15,000 Total: Taxes $6,594,157 $6,794,541 $7,090,349 $7,157,226 $7,514,504 $7,643,715 $7,778,606 Intergovcrnmenlal 01- 000 -41 -004100 STATE INCOME TAX I,IX04,980 1,277,889 1,300,000 1,300,000 1,340,000 1,390,000 1,440,000 01- 000.41.004105 LOCAL USE TAX 165,054 201,681 237,063 210,000 210,000 210,000 210,000 01- 000.41.004110 ROAD & BRIDGE TAX 143,506 151,196 160,000 164,296 164,296 164,296 164,296 01.000 -41 -00 -4120 PERSONAL PROPERTY TAX 17,690 13,409 20,000 - 13,000 13,000 13,000 13,000 01- 000 -41 -00-4160 FEDERAL GRANTS - 1,502 - 12,913 9,200 9,200 9,200 HIDTAReiab $5,000 COPS - Peet Gear $4,200 01- 000 -41 -00-4170 STATE GRANTS (1,758) 1,870 1,803 34,390 - - - 01-000-41-00-4182 MISC INTERGOVERNMENTAL - 4,838 - 2,196 2,000 2,000 2,000 Pull Tab & Jar Gmacs $2,!X10 Total: Intergovernmental $1,329,472 $1,652,385 $1,718,866 $1,736,795 $1,738,496 $1,788,496 $1,838,496 Licenses and Pcrndls 01- 00042 -00-4200 LIQUOR LICENSE 50,008 43,545 30,000 40,000 40,000 40,000 40,000 O1- 00042 -004205 OTHER LICENSES 4,964 3,786 4,500 3,000 3,000 3,000 3,000 O1- 000 -42 -00-4210 BUILDING PERMITS 322,160 190,579 205,000 140,000 122,400 122,400 122,400 O1- 000 -42 -00-4214 DEVELOPMENT FEES 199,722 21,690 80,170 35,000 - - - Alored to CIII'-Wide Capitol Fetid 01- 000 -42 -00-4220 FILING FEES 1,880 250 3,000 - 250 250 250 Total: Licenses and Pemtils $578,733 $259,850 $322,670 $218,000 $165,650 $165,650 $165,650 Fines and Forfeits 01- 000 -43 -00-4310 TRAFFIC FINES 130,344 129,075 151,275 91,671 95,000 95,000 95,000 01- 000 -43 -00-4320 ADMINISTRATIVE ADJUDICATION 22,390 44,565 50,000 26,000 30,000 30,000 30,000 01- 00043 -00-4325 POLICE TOWS - 25,500 181,275 87,000 90.000 90,000 90,000 Total: Nines and Forfeits $152,734 $199,140 $382,550 $204,671 $215,000 $215,000 $215,000 I 14 United City of Yorkville General Fund of GENERAL FUND REVENUE FV 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Accown Durription Actual Actual Budget Projected Adopted Projected Projected Charges for S-ices 01- 000 -44 -00 -4400 GARBAGESURCHARGE 1,081,313 1,132,478 1,050,000 1,175,000 1,175,000 1,175,000 1,175,000 01- 000 -4400 -4405 COLLECTION FEE - YBSD 66,075 119,121 121,503 121,502 123,932 126,411 128,939 01- 000 -44.00 -4412 SERVICE CHARGE - LIBRARY - - 40,582 - - - - 01 -000-44.00 -4414 OTHER SERVICES - 1,305 - 3,960 - - - 01- 000 -44 -01 -4474 POLICE SPECIAL DETAIL - - - 4,500 5,000 5,00 5,000 Total: Charges for Services $1,147,388 $1,252,904 $1,212,085 $1,304,962 $1,303,932 $1,306,411 $1,308,939 bnvestmad Earnings 01- 000 - 45.00.4500 INVESTMENT EARNINGS 18,629 62,013 3,000 2,058 2,000 2,000 2,000 Total: Investment Earnings $18,629 $62,043 $3,000 $2,058 $2,000 $2,000 $2,000 Rebut ursenteuts 01- 000 -46 -00-4601 REIMB - LEGAL EXPENSES - 27,848 150,000 37,130 12.00 - - 01- 00046 -00-4650 REIMB - TRAFFIC SIGNAL 18,289 14,925 14,925 33,067 15,000 15,000 15,0X0 01- 000 -46 -00-4668 REIMB - COBRA CONTRIBUTIONS - - - 35,766 20,000 20,000 20,000 01- 000 -46 -00-4669 REIMB - RETIREE INS CONTRIBUTIONS - - - 35,000 50,000 52,000 54,000 01- 000 -46 -00-4670 REIMB - EMPLOYEE INS CONTRIBUTIONS 100,223 227,600 168,318 185,723 190,000 195,00 195,00 01- 000-46 -00-4671 REIMB - LIFE INSURANCE - - - 4,753 4,800 4,800 4,800 01- 00.46 -00-4680 REIMB - LIABILITY INSURANCE 4,646 29,776 - 11,404 5,000 5,000 5,000 01- 000 - 46.00.4681 REIMB - WORKERS COMP - - - 5,000 - - - 01- 00 - 46.004685 REIMB - CABLE CONSORTIUM 98,499 36,185 - 40,000 40,000 40,000 40,00 01. 000 -46 -00-4690 REIMB - MISCELLANEOUS 173,728 88,370 8,300 4,000 4,000 4,00 4,000 Total: Reimbursements $395,385 $424,703 $341,543 - $391,843 $340,800 $335,800 $337,800 Miscellaneous 01- 000 -48.00-4820 RENTAL INCOME 13,730 13,155 14,000 5,500 9,000 9,000 9,000 Beccherlrase Agreewem $6,000 Reechcr Rentals $3,000 01- 000 -48.00-4845 DONATIONS 2,820 2,460 2,020 1,650 2,000 2,00 2,00 01- 000 -48 -00-4850 MISCELLANEOUS INCOME 25,409 1,589 10,585 10,000 5,000 5,000 5,000 Total: Miscellaneous $41,959 $17,204 $26,605 $17,150 $16,000 $16,000 $16,000 Other Financing Sources 01- 000.49 -00-4951 TRANSFER FROM WATER 450,00 75,569 91,863 91,863 91,863 91,863 91,863 01- 000.49 -00-4952 TRANSFER FROM SEWER 220,000 58,640 83,045 83,015 83,045 83,045 83,015 01- 000 -49 -00-4972 TRANSFER FROM LAND CASH 181,000 60,449 60,449 60,449 20,084 17,851 12,640 01- tX0 -49 -00-4979 TRANSFER FROM PARK @ REC - 150,000 100,000 - - - - 01- 000 -49 -00-4985 TRANSFER FROM FOX INDUSTRIAL TIE 25,680 - - - - - - 01- 000.49.00-4988 TRANSFER FROM DOWNTOWN TIE 25,805 - - - - - - Total: Other Financing Sources $902,485 $344,658 $335,357 $235,357 $194,992 $192,759 $187,548' Total: GENERAL FUND REVENUE $11,160,942 $11,007.428 $11,433,025 $11,268,062 $11. 491,374 $11,665,831 $11,850,039 i 15 United City of Yorkville Expenditures by Category General Fund FY 2012 Budget Contingencies Capital Outlay 0.09% 0.04% Other Financing Uses 8.96% Supplies - -- Salaries 2.83% 30.86% Contractual Services 33.81% Benefits 23.40% 16 United City of Yorkville General Fund Expenditures by Category & Department Fiscal Year 2012 Budget FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Bu Proj ecti o n Adopted Projected Projected Administration 1,278,244 672,645 508,743 536,197 489,551 495,551 495,551 Salaries 570,705 338,295 280,927 318,478 273,395 273,395 273,395 Benefits 93,562 51,092 53,616 48,500 45,106 45,106 45,106 Contractual Services 596,776 271,496 158,250 151,510 155,100 161,100 161,100 Supplies 17,201 11,762 15,950 17,709 15,950 15,950 15,950 Finance 478,675 416,193 461,060 338,511 320,505 320,505 320,505 Salaries 323,536 254,608 259,690 201,585 175,000 175,000 175,000 Benefits 51,348 42,230 54,260 35,500 30,505 30,505 30,505 Contractual Services 91,357 113,196 135,860 95,450 109,250 109,250 109,250 Supplies 12,434 6,160 11,250 5,976 5,750 5,750 5,750 Community Relations 134,378 95,259 110,336 91,045 54,950 54,950 54,950 Salaries 73,860 67,676 63,750 57,500 32,500 32,500 32,500 Benefits 11,077 9,690 11,061 7,605 2,500 2,500 2,500 Contractual Services 25,237 15,608 19,190 19,190 16,550 16,550 16,550 Supplies 24,205 2,286 16,335 6,750 3,400 3,400 3,400 Engineering 516,219 425,462 357,821 305,731 253,136 254,896 255,146 Salaries 427,300 327,133 263,733 235,694 172,500 172,500 172,500 Benefits 66,452 52,525 45,758 40,700 29,736 31,496 31,496 Contractual Services 17,559 42,944 40,050 16,750 42,100 42,100 42,350 Supplies 4,908 2,861 8,280 12,587 8,800 8,800 8,800 Police 3,160,729 3,260,257 3,190,934 3,013,240 3,018,230 3,042,920 3,072,383 Salaries 2,340,472 2,452,761 2,339,378 2,188,900 2,127,500 2,127,500 2,127,500 Benefits 504,182 519,722 528,347 516,041 560,900 588,000 613,000 Contractual Services 166,795 176,795 186,920 174,510 190,010 183,350 183,350 Supplies 149,280 110,979 136,289 133,789 139,820 144,070 148,533 Community Development 461,181 419,785 446,179 408,598 375,610 380,650 385,650 Salaries 338,866 295,414 287,132 270,000 240,000 240,000 240,000 Benefits 41,695 45,359 49,817 45,120 44,535 44,575 44,575 Contractual Services 70,786 66,641 96,650 74,850 84,450 89,450 94,450 Supplies 9,835 12,371 12,580 18,628 6,625 6,625 6,625 17 United City of Yorkville General Fund Expenditures by Category & Department Fiscal Year 2012 Budget FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projection Adopted Projected Projected Public Works - Sit-eel Operations 626,098 641,221 616,724 608,352 595,870 605,750 616,714 Salaries 300,088 312,133 271,472 282,000 285,000 285,000 285,000 Benefits 46,179 50,097 47,100 45,000 53,500 53,500 53,500 Contractual Services 175,550 164,338 133,720 124,520 135,020 144,020 153,220 Supplies 104,235 103,323 120,200 114,600 118,350 119,230 120,994 Capital Outlay 46 11,330 44,232 42,232 4,000 4,000 4,000 Public Works - Health & Sanitation 1,126,732 1,159,160 1,146,000 1,201,000 1,201,000 1,201,000 1,201,000 Contractual Services 1,126,732 1,159,160 1,146,000 1,201,000 1,201,000 1,201,000 1,201,000 Administrative Services 5,112,766 5,628,642 4,539,183 4,777,695 4,418,640 5,007,784 4,859,918 Salaries - - - 4,500 5,000 5,000 5,000 Benefits 1,238,197 1,554,427 1,671,339 1,588,325 1,743,350 1,942,718 2,169,731 Contractual Services 1,568,885 2,413,467 1,189,050 1,751,422 1,693,840 1,770,391 1,780,452 Supplies - - - - 5,000 5,000 5,000 Contingencies (7,047) 16,153 10,000 100,000 10,000 10,000 10,000 Other Financing Uses 2,312,731 1,644,594 1,668,794 1,333,448 961,450 1,274,675 889,735 Total Expenditures and Transfers 12,895,022 12,718,624 11376 980 11,280,369 10,727,492 11364 006 11 261817 i t i 18 United City of Yorkville Expenditures by Department General Fund FY 2012 Budget Finance Administration 2.99% 4.56% Community Relations 0.51% Admin Services 41.19% Engineering 2.36% Police 28.14% Public Works 16.75% Community Development 3.50% 19 ADMINISTRATION DEPARTMENT The Administration Department includes both the legislative and management expenditures. The legislative branch consists of the Mayor and City Council. The city administrator is hired by the Mayor with the consent of the City Council. City staff report to the city administrator. It is the role of the city administrator to direct staff in the daily administration of City services. FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projected Adopted Projected Projected Expenditures Salaries 570,705 338,295 280,927 318,478 273,395 273,395 273,395 Benefits 93,562 51,092 53,616 48,500 45,106 45,106 45,106 Contractual Services 596,776 271,496 158,250 151,510 155,100 161,100 161,100 Supplies 17,201 11,762 15,950 17,709 15,950 15,950 15,950 Total Administration 1,278,244 672,645 508,743 536,197 489,551 495,551 495,551 $1,400 $1,200 o $1,000 ~ $800 $hoo $400 $200 $0 Personnel Full -time Personnel: * City Administrator 1.0 0.5 0.5 0.5 0.5 0.5 0.5 Assistant City Administrator 1.0 0.0 0.0 0.0 0.0 0.0 0.0 Human Resource Manager 0.0 0.0 0.0 1.0 1.0 1.0 1.0 Deputy City Clerk 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Administrative Assistant 1.0 1.0 1.0 0.0 0.0 0.0 0.0 Administrative Secretary 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Receptionist 1_0 1_0 1_0 0_0 0_0 0_0 0_0 Total Personnel 6.0 4.5 4.5 3.5 3.5 3.5 3.5 * The City Administrator is also the Interim Director of Parks and Recreation Salary and benefil amounts are split equally between General and Park and Recreation Finds I I 20 I I United City of Yorkville General Fund 110 ADMINISTRATION FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adapted Projected Projected Salaries 01- 110 -50 -00-5001 SALARIES - MAYOR 9,980 8,945 11,310 11,000 11,000 11,100 11,000 01- 110-50-00 -5002 SALARIES - LIQUOR COMM 1,000 917 1 1,083 1,000 1,000 1,000 01. 110 -50 -00 -5003 SALARIES - CITY CLERK 8,975 7,993 8,980 9,000 9,000 9,000 9,000 01- 110 -50 -00 -5004 SALARIES - CITY TREASURER 6,442 5,300 6,500 6,500 6,500 6,500 6,500 01- 110 -50 -00 -5005 SALARIES - ALDERMAN 39,130 43,685 50,320 50,320 50,320 50,320 50,320 01- 110 -50 -00 -5010 SALARIES - ADMINISTRATION 444,017 270,592 202,242 240,000 195,000 195,000 195,000 01- 110 -50 -00 -5015 PART -TIME SALARIES 2,053 - - - - - - 01. 110 -50-00 -5016 SALARIES - SPECIAL CENSUS 59,087 - - - - - - 01- 110 - 50410.5020 OVERTIME 22 863 575 575 575 575 575 Total: Salaries $570,705 $338,295 $280,927 $318,478 $273,395 $273,395 $273,395 Benefits 01- 110-52.00 -5212 RETIREMENT PLAN CONTRIBUTION 41,357 26,377 27,153 26,000 25,000 25,000 25,000 01- 110 - 52.00.5214 FICA CONTRIBUTION 46,297 21,623 26,463 22,500 20,106 20,106 20,106 01- 110 -52 -00 -5229 CAR ALLOWANCE 5,908 3,092 - - - - - Total: Benefits $93,562 $51,092 $53,616 $48,500 $45,106 $45,106 $45,106 Contractual Services 01- 110 - 5400.5410 TUITION REIMBURSEMENT 3,855 - - - - - - 01- 110 -54- 00.5412 TRAINING & CONFERENCES 4,999 1,769 - - 3,000 3,000 3,000 01- 110 -54 -00 -5415 TRAVEL AND LODGING 9,761 4,043 1,000 1,000 - 6,000 6,000 01- 110 -54 -00-5423 PUBLIC RELATIONS 190 176 150 150 150 150 150 01- 110 -54 -00-5426 PUBLISHING & ADVERTISING 767 1,354 2,000 2,000 2,000 2,000 2,000 01- 110 -54.00-5430 PRINTING AND DUPLICATING 11,067 8,845 6,750 6,750 6,750 6,750 6,750 01- 110 -54 -00-5440 TELECOMMUNICATIONS 24,060 24,018 21,200 21,200 21,200 21,200 21,200 Cellular Telephone 51,200 Trlephone $20,000 01. 110 -54 -00-5451 CODIFICATION 10,660 8,788 8,000 8,000 8,000 8,000 8,000 01. 110 -54.00-5452 POSTAGE & SHIPPING 8,685 7,378 14,000 14,000 14,000 14,000 14,000 01- 110.54 -00-5462 PROFESSIONAL SERVICES 29,224 25,280 11,000 11,000 11,000 11,0()0 11,000 Co,arnnon15 -4- $8,000 Telephone Svstem Alninlennnre $3,000 01- 110 -54 -00-5473 KENDALL COUNTY PARATRANSIT - 5,887 30,000 30,000 30,000 30,000 30,000 01- 110 -54 -00-5474 SENIOR SERVICE FUNDING - 5,000 5,000 - - - - 01- 110 -54 -00-5477 BUILDING INSPECTIONS 271,821 117,622 - 1,260 - - - 01- 110 -54 -00-5478 SPECIAL CENSUS 170,437 - - - - - - 01- 110.54 -00-5480 UTILITIES 30,132 25,248 31,100 28,000 28,000 28,000 28,000 Nicor 528,000 01- 110 -54 -00-5487 SPONSORSHIPS 250 - - - - - - 01- 110 -54 -00-5488 OFFICE CLEANING 10,734 23,490 14,400 14,400 14,400 14,400 14,400 01- 110 -54 -00-5490 DUES AND SUBSCRIPTIONS 10,134 12,597 13,750 13,750 16,600 16,600 16,600 Doesaod Subsrriptions $15,000 12IL D,- $1,500 Sob- iplions/BooFr $100 Total: Contractual Services $596,776 $271,496 $158,250 $151,510 $155,100 $161,100 $161,100 I I 21 United City of Yorkville General Fund 110 ADMINISTRATION FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Deseriplion Actual Actual Budget Projected Adoptcd Projected Projected Supplies 01- 110 -56.00 -5600 WEARING APPAREL - - - - - - - Ot- 110 -56 -00 -5610 OFFICESUPPLIES 15,224 11,190 15,000 15,000 15,000 15,000 15,000 01. 110 -56.00 -5630 SMALL TOOLS & EQUIPMENT - 135 - 609 - - - 01- 110 -56- 00.5635 COMPUTER EQUIPMENT & SOFTWARE - 355 850 2,000 850 850 850 01- 110 -56.00 -5640 REPAIR AND MAINTENANCE - - 100 100 100 100 t00 Akiarenmrre - Ohre Equiprneur $100 01. 110 -56 -00 -5699 MISCELLANEOUS 1,977 81 - - - - - Total: Supplies $17,201 $11,762 $15,950 $17,709 $15,950 $15,950 $15,950 Total: ADMINISTRATION $1,278,244 $672,645 $508,743 $536,197 $489,551 $495,551 $495,551 22 FINANCE DEPARTMENT The Finance Department is responsible for the accounting, internal controls, external reporting and auditing of all financial transactions. The Finance Department is in charge of the annual audit, utility billing, payables and payroll and works with administration in the preparation of the annual budget. Personnel are budgeted in the General and Water funds. FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actu Actual Budget Projected Adopted Projected Projected Expenditures Salaries 323,536 254,608 259,690 201,585 175,000 175,000 175,000 Benefits 51,348 42,230 54,260 35,500 30,505 30,505 30,505 Contractual Services 91,357 113,196 135,860 95,450 109,250 109,250 109,250 Supplies 12,434 6,160 11,250 5,976 5,750 5,750 5,750 Total Finance Department 478,675 416,193 461,060 338,511 320,505 320,505 320,505 $600 v $500 c $400 0 >` $300 $200 $100 $0 Personnel Full -lime Personnel: Finance Director 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Senior Accountant 1.0 0.0 0.0 0.0 0.0 0.0 0.0 IT Specialist 1.0 1.0 1.0 0.0 0.0 0.0 0.0 Accounting Clerk I 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Accounting Clerk 1_0 1_0 1_0 1_0 1_0 1_0 1_0 Total Personnel 5.0 4.0 4.0 3.0 3.0 3.0 3.0 23 United City of Yorkville General Fund 120 FINANCE FY 2009 1T 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Descriplimt Actual Actual Budget Projected Adopted Projected Projected Salaries 01- 120.50 -00 -5010 SALARIES AND WAGES 322,919 254,446 259,690 201,585 175,000 175,000 175,000 01- 120 -50.00-5020 OVERTIME 616 161 - - - - - Total: Salaries $323,536 $254,608 $259,690 $201,585 $175,000 $175,000 $175,000 Benefits 01. 120 -52 -00-5212 RETIREMENT PLAN CONTRIBUTION 25,726 21,826 25,190 20,000 17,500 17,500 17,500 01- 120 -52 -00-5214 FICA CONTRIBUTION 25,622 20,404 29,070 15,500 13,005 13,005 13,005 Total: Benefits $51,348 $42,230 $54,260 $35,500 $30,505 $30,505 $30,505 Contractual Services 01- 120 -54 -00-5412 TRAINING & CONFERENCES 2,280 - - - 2,000 2,000 2,000 01- 120.54 -00-5414 AUDITING SERVICES 42,480 54,040 57,700 40,000 45,000 45,000 45,000 01- 120.54.00-5415 TRAVEL AND LODGING 754 - - - 1,000 1,000 1,000 01- 120 - 5400-5430 PRINTING AND DUPLICATING - - 1,000 500 500 500 500 01- 120 -54 -00-5440 TELECOMMUNICATIONS 1,070 993 1,010 600 600 600 600 Cell Phe- $600 01- 120 -54.00-5452 POSTAGE & SHIPPING 1,370 1,284 2,500 500 500 500 500 01- 120 -54 -00-5460 DUES AND SUBSCRIPTIONS 165 678 1,850 850 850 850 850 01- 120 -54 -00-5462 PROFESSIONAL SERVICES 20,486 37,238 43,000 32,000 42,000 42,000 42,000 Couonaual Services $30,000 A-,,,,Iinq Srsrcm Ece $12,000 01- 120 -54 -00-5485 RENTAL & LEASE PURCHASE 21,083 18,964 27,000 20,000 15,000 15,000 15,000 M.hdeunnre - P/rutornpiers $15,000 01- 120 -54 -00-5495 OUTSIDE REPAIR AND MAINTENANCE 1,669 - 1,800 1,000 1,800 1,800 1,800 AMinreoonrc -Off- Equipment $1,800 Total: Contractual Services $91,357 $113,196 $135,860 $95,450 $109,250 $109,250 $109,250 Supplies 01- 120 -56 -00-5610 OFFICE SUPPLIES 6,287 3,527 5,500 2,500 2,500 2,500 2,500 01- 120 -56 -00-5630 SMALL TOOLS & EQUIPMENT - - 250 - 250 250 250 Off- Equip nrenr $250 01- 120 -56 -00-5635 COMPUTER EQUIPMENT & SOFTWARE 6,147 2,632 5,000 3,476 2,500 2,500 2,500 01. 120 -56.00-5640 REPAIR AND MAINTENANCE - - 500 - 500 500 500 AMiniconn- - C-1 1- $500 Total: Supplies $12,434 $6,160 $11,250 $5,976 $5,750 $5,750 $5,750 Total: FINANCE $478,675 $416,193 $461,060 $338,511 $320,50 5 320 505 $320,505 24 COMMUNITY RELATIONS The Community Relations office strives to increase community awareness and involvement in programs, services, and community events. Its primary responsibility is to provide internal and external communication to inform residents, public officials, the business community, and city employees of city news, forums, and events by utilizing all forms of communication including the City's website, broadcast media, e- mail blasts, advertisements, and all printed forms of communication such as the city's newsletter, marketing brochures, pamphlets, new resident packets and more. FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projected Adopted Projected P Expenditures Salaries 73,860 67,676 63,750 57,500 32,500 32,500 32,500 Benefits 11,077 9,690 11,061 7,605 2,500 2,500 2,500 Contractual Services 25,237 15,608 19,190 19,190 16,550 16,550 16,550 Supplies 24,205 2,286 16,335 6,750 3,400 3,400 3,400 Total Community Relations 134,378 95,259 110,336 91,045 54,950 54,950 54,950 $160 v $140 N $120 t $100 ~ $80 $60 $40 $20 $0 Personnel Full -time Personnel: Community Relations Officer 1.0 1.0 1.0 0.0 0.0 0.0 0.0 Part -time Personnel: Community Relations Officer 0.0 0.0 0.0 1.0 1.0 1.0 1.0 Total Personnel 1.0 1.0 1.0 1.0 1.0 1.0 1.0 25 I United City of Yorkville General Fund 130 CONID1UNITY RELATIONS FY 2009 FY 2010 1T 2011 FY 2011 FY 2012 IT 2013 FY 2014 Aarowd D scriplion Actual Actual Budget Prujeeled Adopted Prajected Projected Salaries '. 01430 -50 -00 -5010 SALARIES AND WAGES 65,938 65,250 63,750 57,500 - 01. 130 -50 -00 -5015 PART -TIME SALARIES 7,921 2,426 - - 32,500 32,500 32,500 Total: Salaries $73,860 $67,676 $63,750 $57,500 $32,500 $32,500 $32,500 Benefits 01- 130 -52- 00-5212 RETIREMENT PLAN CONTRIBUTION 5,253 5,603 6,184 4,005 - - - 01. 130 -52 -00-5214 FICA CONTRIBUTION 5,824 4,087 4,877 3,600 2,500 2,500 2,500 Total: Benefits $11,077 $9,690 $11,061 $7,605 $2,500 $2,500 $2,500 Contractual Services 01- 13054 -00 -5412 TRAINING & CONFERENCES 50 - - - - - - 01- 130 -54- 00.5415 TRAVEL AND LODGING 25 - - - - - - 01- 130 -54 -00 -5423 PUBLIC RELATIONS 2,039 1,565 1,750 1,750 1,750 1,750 1,750 01- 130 -54 -00 -5426 PUBLISHING & ADVERTISING 11,035 5,923 7,500 7,500 7,500 7,500 7,500 01- 130 -54 -00 -5430 PRINTING AND DUPLICATING 1,221 135 1,000 1,000 200 200 200 01- 130 -54 -00 -5440 TEELCOMMUNICATIONS - 453 540 540 - - - 01- 13054 -00 -5452 POSTAGE & SHIPPING 7,315 1,933 3,500 3,500 2,200 2,200 2,200 01- 130 -54 -00 -5460 DUES AND SUBSCRIPTIONS 305 275 100 100 100 I00 loo 01. 130 -54 -00 -5462 PROFESSIONAL SERVICES 3,247 5,325 4,800 4,800 4,800 4,800 4,800 Total: Contractual Services $25,237 $15,608 $19,190 $19,190 $16,550 $16,550 $16,550 Supplies 01- 130 - 56.00.5600 WEARING APPAREL - - - - - - - 01- 130 -56 -00-5610 OFFICE SUPPLIES 148 346 750 750 400 400 400 01- 130 -56 -00-5692 COMMUNITY EVENTS 3,330 1,939 6,000 6,001 3,000 3,000 3,000 01- 130 -56 -00-5693 HOLIDAY UNDER THE STARS 20,728 - 9,585 - - - - Total: Supplies $24,205 $2,286 $16,335 $6,750 $3,400 $3,400 $3,400 Total: COMMUNITY RELATIONS $134,378 $95,259 $110,336 $91,045 $54,950 $54,950 $54,950 26 ENGINEERING DEPARTMENT The Engineering Department provides service related to development plan review, capital project plan preparation, construction inspection, project coordination, utility locate requests, and operational support for other departments. FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projected Adopted Projected Projected Expenditures Salaries 427,300 327,133 263,733 235,694 172,500 172,500 172,500 Benefits 66,452 52,525 45,758 40,700 29,736 31,496 31,496 Contractual Services 17,559 42,944 40,050 16,750 42,100 42,100 42,350 Supplies 4,908 2,861 8,280 12,587 8,800 8,800 8,800 Total Engineering Department 516,219 425,462 357,821 305,731 253,136 254,896 255,146 $600 V $500 o $400 t $300 $200 $100 $0 Personnel Full -time Personnel: City Engineer 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Civil Engineer 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Engineering Tech 2.0 1.0 1.0 0.0 0.0 0.0 0.0 Julie Locator Tech 1.0 0.0 0.0 0.0 0.0 0.0 0.0 Administrative Assistant LO 1.0 1.0 0.0 0.0 0.0 0.0 Total Personnel 6.0 4.0 4.0 2.0 2.0 2.0 2.0 27 United City of Yorkville General Fund 150 ENGINEERING IT 2009 FY 2010 IFY 2011 FY 2011 FT 2012 IT 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Salaries 01- 150 -50 -00-5010 SALARIES AND WAGES 427,399 327,133 263,233 235,194 172,000 172,000 172,000 01- 150 -50 -00-5020 OVERTIME (99) - 500 500 500 500 500 Total: Salaries $427,300 $327,133 $263,733 $235,694 $172,500 $172,500 $172,500 Bencfils 01- 150 -52 -00 -5212 RETIREMENT PLAN CONTRIBUTION 34,071 28,301 25,582 22,500 16,500 18,260 18,260 01- 150 -52 -00 -5214 FICA CONTRIBUTION 32,381 24,224 20,176 18,200 13,236 13,236 13,236 Total: Benefits $66,452 $52,525 $45,758 $40,700 $29,736 $31,496 $31,496 Contractual Services 01- 150 -54 -00 -5410 TUITION REIMBURSEMENT 1,492 823 - - - - - 01- 150.54.00 -5412 TRAINING & CONFERENCES 417 (115) - - 2,250 2,250 2,500 01- 150 -54 -00 -5415 TRAVEL AND LODGING 275 7 - - 400 400 400 01- 150 -54- 00.5430 PRINTING AND DUPLICATING 1,566 1,217 1,500 1,500 1,500 1,500 1,500 01- 150 -54 -00 -5440 TELECOMMUNICATIONS 3,431 2,288 3,000 2,200 2,200 2,200 2,200 Cell Pbmie $2,200 01- 150 -54.00-5452 POSTAGE & SHIPPING - 452 500 500 500 500 500 01- 150 -54 -00-5460 DUES AND SUBSCRIPTIONS 285 62 1,000 1 1,200 1,200 1,200 01- 150 -54 -00 -5462 PROFESSIONAL SERVICES 9,016 36,689 32,550 10,050 32,550 32,550 32,550 Corurncmal Samices $30,000 NPDES & FRSG Fees 52,550 01- 150 -54 -00 -5495 OUTSIDE REPAIR AND MAINTENANCE 1,078 1,521 1,500 1,500 1,500 1,500 1,500 3lniutenmrce - 1 les $1,500 Total: Contractual Services $17,559 $42,944 $40,050 $16,750 $42,100 $42,100 $42,350 Supplies 01- 150 -56 -00-5600 WEARING APPAREL 143 - 100 100 100 1170 100 01. 150 -56 -00-5610 OFFICE SUPPLIES 1,106 280 1,250 750 1,000 1,000 1 1 , 01- 150.56.00-5622 ENGINEERING SUPPLIES 689 1,146 2,000 1,500 1,500 1,500 1,500 01.150.56.00-5630 SMALL TOOLS & EQUIPMENT - - 500 500 500 500 500 Off- Equipment $Soo 01- 150 -56 -00-5635 COMPUTER EQUIPMENT & SOFTWARE 2,926 1,399 3,300 3,300 4,550 4,550 4,550 Sofitrnrc Subscriptions $2,550 Replace Old Equil t $2,000 01- 150 -56 -00-5640 REPAIR AND MAINTENANCE - - 1,000 1 1,000 1,000 1,000 Flniotenmme- Or- Equilnneut $500 Maintenance - Cangnners $500 01- 150 -56 -00-5645 BOOKS AND PUBLICATIONS 45 36 130 130 150 150 150 01- 150 -56 -00-5690 SUPPLIES - GRANT REIMBURSABLE - - - 5,307 - - - Energy & Renrl ing Grad F)'2011 Total: Supplies $4,908 $2,861 $8,280 $12,587 $8,800 $8,800 $8,800 Total: ENGINEERING $516,219 $425,462 $357,821 $305,731 $253.13 6 254 89 $255.14 6 i 28 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 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projected Adopted Projected Projected Expenditures Salaries 2,340,472 2,452,761 2,339,378 2,188,900 2,127,500 2,127,500 2,127,500 Benefits 504,182 519,722 528,347 516,041 560,900 588,000 613,000 Contractual Services 166,795 176,795 186,920 174,510 190,010 183,350 183,350 Supplies 149,280 110,979 136,289 133,789 139,820 144,070 148,533 Total Police Department 3,160,729 3,260,257 3,190,934 3,013,240 3,018,230 3,042,920 3,072,383 $3,300 $3,250 c $3,200 M c $3,150 $3,100 $3,050 $3,000 $2,950 $2,900 $2,850 Personnel Full -time Personnel: * Chiefof Police 1.0 1.0 1.0 1.0 1.0 1.0 1.0 * Deputy Chief of Police 0.0 0.0 2.0 2.0 2.0 2.0 2.0 * Lieutenants 2.0 2.0 1.0 1.0 1.0 1.0 1.0 * Sergeants 6.0 5.0 4.0 3.0 3.0 3.0 3.0 * Police Officers 21.0 19.0 19.0 18.0 18.0 18.0 18.0 Director of Support Services 1.0 1.0 1.0 0.0 0.0 0.0 0.0 Office Supervisor 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Executive Assistant 1.0 1.0 1.0 0.0 0.0 0.0 0.0 Secretary 2_0 2_0 2_0 2_0 2_0 2_0 2_0 Total Full -time Personnel 35.0 32.0 32.0 28.0 28.0 28.0 28.0 * sworn 30.0 27.0 27.0 25.0 25.0 25.0 25.0 Part -time Personnel: * Police Officers 3.0 2.0 2.0 4.0 4.0 4.0 4.0 Evidence Technician 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Cadets 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Secretary - Board of Fire & Police 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Crossing Guards 2.0 1.0 1.0 1.0 1.0 1.0 1.0 4_0 3_0 3_0 3_0 3_0 3_0 3_0 Total Part -Time Personnel 12.0 9.0 9.0 11.0 11.0 11.0 11.0 * sworn 3.0 2.0 2.0 4.0 4.0 4.0 4.0 Total Personnel 47.0 41.0 41.0 39.0 39.0 39.0 39.0 * Total sworn 33.0 29.0 29.0 29.0 29.0 29.0 29.0 29 United City of Yorkville General Fund 210 POLICE FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Dmripliou Actual Actual Budget Projected Adopted Projected Projected Salaries 01- 210 -50 -00-5010 SALARIES - POLICE OFFICERS 1,298,052 1,327,063 1,316,326 1,200,000 1,250,000 1,250,100 1,250,000 01-210-50-00-5012 SALARIES - LIEUT /SERGEANTS /CHIEF 693,988 774,290 673,166 681,000 610,000 610,000 610.000 01- 210 -50.00-5013 SALARIES - POLICE CLERKS 223,040 200,568 212,386 160,000 120,1000 120,000 120,100 01. 210 -50 -00-5014 SALARIES - CROSSING GUARD 18,210 23,327 25,11()0 17,400 20,000 20,100 20,000 01. 210 -50 -00-5015 PART -TIME SALARIES 31,299 40,775 39,000 39,000 39,000 39,000 39,100 01. 210 -50 -00-5017 CADET PROGRAM 21,520 10,969 13,500 13,500 13,500 13,500 13,500 O1- 210 -50 -00-5020 OVERTIME 54,363 75,769 60,000 78,100 75,000 75,100 75,000 Total: Salaries $2,340,472 $2,452,761 $2,339,378 $2,188,900 $2,127,500 $2,127,500 $2,127,500 Benefits 01- 210.52.00-5212 RETIREMENT PLAN CONTRIBUTION 18,946 17,322 24,385 15,100 15,900 18,000 18,000 01- 210 -52 -00-5213 EMPLOYER CONTRI - POLICE PENSION 297,328 323,291 325.000 336,041 375,000 400,000 425,000 01- 210 -52 -00-5214 FICA CONTRIBUTION 187,908 179,109 178,962 165,000 170,000 170,000 170,000 Total: BeneBls $504,182 $519,722 $528,347 $516,041 $560,900 $588,000 $613,000 Contractual Services O1. 210 -54 -00-5410 TUITION REIMBURSEMENT 3,203 - 2,800 2,800 2,800 2,800 2,800 O1- 210 -54- 00.5411 POLICE COMMISSION 7,667 11,999 7,000 7,000 15,100 7,000 7,000 01- 21054 -00-5412 TRAINING & CONFERENCE 18,021 7,239 8,025 8,025 12,000 12,000 12,000 01- 210 -54 -00-5415 TRAVEL AND LODGING 5,978 5,832 6,575 6,575 10,000 10,000 10,000 01- 210 -54 -00-5426 PUBLISHING & ADVERTISING 468 187 100 100 200 200 200 01. 210 -54 -00-5430 PRINTING AND DUPLICATING 4,911 5,842 4,500 4,500 4,500 4,500 4,500 01. 210 -54.00-5440 TELECOMMUNICATIONS 40,279 40,490 39,420 36,500 36,500 36,500 36,500 Telephone 521,500 Cell Ph-, $ 15,000 01- 210 -54. 00.5452 POSTAGE & SHIPPING 2,109 1,821 3,000 3,000 3,000 3,000 3,000 O1- 21054 - 00.5457 PSYCHOLOGICAL TESTING - 560 - 01- 210 -54 -00-5460 DUES AND SUBSCRIPTIONS 2,384 1,696 1,350 1,350 1,350 1,350 1,350 O1- 210 -54 -00-5462 PROFESSIONAL SERVICES 4,815 5,886 5,000 4,000 4,000 5,100 5,000 Gun R-g, Fees $500 Special Response Ten Fees $3,500 01- 210 -54 -00-5466 LEGAL SERVICES 1,079 16,367 20,000 10,000 10,000 10,000 10,000 01- 21054 -00-5467 ADMIN ADJ - HEARING OFFICER 10,628 17,925 15,000 15,000 15,000 15,000 15,000 O1- 210.54 -00-5469 NEW WORLD LIVE SCAN 12,320 15,087 15,000 15,000 15,000 15,000 15,000 O1- 210.54 -00-5472 KENDALL CO. JOVE PROBATION 2,685 2,784 3,000 3,000 3,000 3,000 3,000 01- 210.54 -00-5484 MIT - ALERTS FEE 5,676 6,660 5,150 6,660 6,660 7,000 7,000 01- 210 -54 -00-5495 OUTSIDE REPAIR AND MAINTENANCE 44,572 36,420 51,000 51,000 51,000 51,000 51,000 AMimennoce- Vehicles $47,000 Weather Warning Siren Alnimenmrce $4,!00 Total: Contractual Services $166,795 $176,795 $186,920 $174,510 $190,010 $183,350 $183,350 Supplies 01- 210 -56 -00-5600 WEARING APPAREL 14,865 9,118 10,000 10,000 10,000 10,000 10,000 01. 210 -56 -00-5610 OFFICE SUPPLIES 4,439 4,119 4,000 4,100 4,100 4,000 4,000 OJjm Supplies $3,000 Adurio Adjrrdiratiwr Supplies $1 ,000 01- 210 -56 -00-5620 OPERATING SUPPLIES 14,530 5,077 9,500 8,100 8,000 8,000 8,000 Opermirrg Supplier $7,000 Evidenre Tech Supplies $1,000 O1- 210 -56 -00-5635 COMPUTER EQUIPMENT & SOFTWARE 11,777 7,993 7,000 7,000 7,000 7,000 7,000 01- 210 -56 -00-5640 REPAIR AND MAINTENANCE 13,569 6,032 12,250 12,250 12,250 12,250 12,250 AMinrennn-- Eguipnrcr1 $9,750 Afaiorenmrce - Co pmcrs$2,500 01- 210 -56 -00-5669 GREAT PROGRAM 2,916 3,227 3,000 3,000 3,000 3,000 3,000 01- 210 -56 -00-5670 COMMUNITY RELATIONS 2,166 280 500 500 500 500 500 30 United City of Yorkville General Fund 210 POLICE FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FT 2014 Account Dcacriptioa Actual Actual Budget Projected Adopted Projccicd Projccicd 01- 211656 -00 -5673 NEIGHBORHOOD WATCH 1,239 46 1,500 500 1,531 1,531 1,531 01- 210.56.00-5674 CITIZENS POLICE ACADEMY 532 339 1,839 1,839 1,839 1,839 1,839 01- 210 -56.00 -5678 COMPLIANCE CHECKS 115 174 500 500 500 500 500 01- 210 -56.00 -5690 SUPPLIES - GRANT REIMBURSABLE 1,212 4,565 4,200 4,200 4,200 4,200 4,200 Caps Groh - Pcsls $4,200 01- 210 - 56.00.5695 GASOLINE 81,702 70,010 80,000 80,000 85,000 89,250 93,713 01- 210 - 56.005696 AMMUNITION 218 - 2,000 2,000 2,000 2,000 2,000 Total: Supplies $149,280 $110,979 $136,289 $133,789 $139,820 $144,070 $148,533 Total: POLICE DEPARTMENT $3,160,729 $3,260,257 $3,190,934 $3,013,240 $3,018,230 $3,042,920 $3,072,383 I I I 31 i 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 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actua Budget Projected Adopted Projec Projec Expenditures Salaries 338,866 295,414 287,132 270,000 240,000 240,000 240,000 Benefits 41,695 45,359 49,817 45,120 44,535 44,575 44,575 Contractual Services 70,786 66,641 96,650 74,850 84,450 89,450 94,450 Supplies 9,835 12,371 12,580 18,628 6,625 6,625 6,625 Total Community Development 461,181 419,785 446,179 408,598 375,610 380,650 385,650 $500 N r N $400 0 0 $300 $200 $100 $0 Personnel Full -time Personnel: Community Development Director 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Chief Building Official 1.0 1.0 1.0 1.0 1.0 1.0 1.0 City Park Designer 1.0 1.0 1.0 1.0 1.0 1.0 1.0 GIS Coordinator 1.0 1.0 1.0 0.0 0.0 0.0 0.0 Administrative Assistant 1.0 0.0 0.0 0.0 0.0 0.0 0.0 Total Full -time Personnel 5.0 4.0 4.0 3.0 3.0 3.0 3.0 Part -time Personnel: Building Admin Assistant 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Total Personnel 6.0 5.0 5.0 4.0 4.0 4.0 4.0 32 II I �I United City of Yorkville General Fund 220 COMMUNITY DEVELOPMENT FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Salaries 01- 220 -50 -00 -5010 SALARIES AND WAGES 338,866 295,414 287,132 270,000 240,000 240,000 240,000 Total: Salaries $338,866 $295,414 $287,132 $270,000 $240,000 $240,000 $240,000 nenerts 01- 220 -52 -00 -5212 RETIREMENT PLAN CONTRIBUTION 25,741 23,567 27,851 25,000 27,275 27,275 27,275 01- 220 -52 -00 -5214 FICA CONTRIBUTION 15,954 21,792 21,966 20,120 17,260 17,300 17,300 Total: BeneRts $41,695 $45,359 $49,817 $45,120 $44,535 $44,575 $44,575 Contractual Services 01- 220 -54 -00 -5412 TRAINING & CONFERENCES 2,001 450 200 200 1,200 1,200 1,200 01- 220.54 -00 -5415 TRAVEL AND LODGING 418 - - - 700 700 700 01- 220 -54 -00 -5426 PUBLISHING & ADVERTISING 14 326 150 150 150 150 150 01- 220 -54 -00 -5430 PRINTING AND DUPLICATING 822 1,548 1,300 1,300 1,500 1,500 1,500 01.22054 -00 -5440 TELECOMMUNICATIONS 1,392 1,355 1,500 1,500 1,500 1,500 1,500 Cell Phan- $1,500 01- 220 -54 -00-5452 POSTAGE & SHIPPING - 459 1,000 200 500 500 500 O1- 220 -54 -00-5459 INSPECTIONS - - 25,000 20,000 20,000 25,000 30,000 01- 220 -54 -00-5460 DUES AND SUBSCRIPTIONS 965 480 1,500 1,500 1,500 1,500 1,500 01- 22054 -00-5462 PROFESSIONAL SERVICES 17,484 12,550 13,000 3,000 6,000 6,000 6,000 01- 220.54.00-5466 LEGAL SERVICES 2,690 4,473 8,010 2,000 6,400 6,400 6,400 01- 220 -54 -00-5486 ECONOMIC DEVELOPMENT 45,000 45,000 45,000 45,000 45,000 45,000 45,000 Total: Contractual Services $70,786 $66,641 $96,650 $74,850 $84,450 $89,450 $94,450 Supplies 01- 220 -56.00-5610 OFFICE SUPPLIES - - 500 500 500 500 500 01- 220 -56 -00-5620 OPERATING SUPPLIES 3,145 1,532 3,500 1,200 3,000 3,000 3,000 01- 220 -56 -00-5630 SMALL TOOLS & EQUIPMENT - 138 125 125 125 125 125 Off- Equip utrnt $125 01- 22056 -00-5635 COMPUTER EQUIPMENT & SOFTWARE 5,927 560 7,955 7,955 2,500 2,500 2,500 01- 220.56 -00-5645 BOOKS AND PUBLICATIONS 763 495 500 500 500 500 500 01- 220 -56 -00-5690 SUPPLIES - GRANT REIMBURSABLE - 9,646 - 8,348 - - - Full Circle Grow F1' 2011 Total: Supplies $9,835 $12,371 $12,580 $18,628 $6,625 $6,625 $6,625 Total: COMMUNITY DEVELOPMENT $461,181 $419,785 $446,179 $ 408,598 $375.61 0 380 650 $385.65 0 33 PUBLIC WORKS DEPARTMENT The Public Works Department is a very 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 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projected Adopted Proj ected Projected Expenditures Salaries 300,088 312,133 271,472 282,000 285,000 285,000 285,000 Benefits 46,179 50,097 47,100 45,000 53,500 53,500 53,500 Contractual Services 1,302,282 1,323,498 1,279,720 1,325,520 1,336,020 1,345,020 1,354,220 Supplies 104,235 103,323 120,200 114,600 118,350 119,230 120,994 Capital Outlay 46 11,330 44,232 42,232 4,000 4,000 4,000 Total Public Works Department 1,752,830 1,800,381 1,762,724 1,809,352 1,796,870 1,806,750 1,817,714 $1,840 $1,820 ° $1,800 $1,780 $1,760 $1,740 $1,720 FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projection Proposed Projected Projected Personnel Full -time Personnel: * Public Works Director 0.33 0.33 0.33 0.00 0.00 0.00 0.00 Foreman 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Operator 2.00 2.00 2.00 2.00 2.00 2.00 2.00 Maintenance Worker II 2.00 2.00 2.00 2.00 2.00 2.00 2.00 Total Personnel 5.33 5.33 5.33 5.00 5.00 5.00 5.00 * Salary and benefits ivere split equal/) between General, Water and Seiver Funds for FY 2009 Actual, FY 2010 Actual and FY2011 Budgeted amounts 34 United City of Yorkville General Fund 410 PUBLIC WORKS - STREET OPERATIONS FY 2009 FY 2010 F1' 2011 F Y 2011 FY 2012 FY 2013 F'1' 2014 Account Ducriplion Actual Actual Budget Projected Adopted Projeeled Projected Salorics 01 -410 -50 -00 -5010 SALARIES AND WAGES 257,547 296,220 243,472 270,000 270,000 270,000 270,000 01- 410 -50 -00 -5015 PART -TIME SALARIES 6,752 - - - - - - 01- 410 -50 -00 -5020 OVERTIME 35,789 15,913 28,000 12,000 15,000 15,000 15,000 Total: Salaries $300,088 $312,133 $271,472 $282,000 $285,000 $285,000 $285,000 Bcncfits 01-410-52-OD-5212 RETIREMENT PLAN CONTRIBUTION 23,392 26,842 26,332 25,000 30,000 30,081 30,000 01- 410 -52 -00-5214 FICA CONTRIBUTION 22,787 23,255 20,768 20,000 23,500 23,500 23,501 'Total: Benefits $46,179 $50,097 $47,100 $45,000 $53,500 $53,500 $53,500 Canlroclual Services 01- 410 -54- 00.5412 TRAINING & CONFERENCES 1,711 110 2,000 2,000 2,000 2,081 2,00 01- 410 -54 -00 -5440 TELECOMMUNICATIONS 2,788 2,536 4,020 4,020 4,020 4,020 4,020 Cell Phone $4,020 01- 410 -54- 01.5455 MOSQUITO CONTROL 29,832 30,966 15,000 6,500 7,000 7,000 7,081 01- 410 -54- 00.5458 TREE &- STUMP REMOVAL 4,990 6,790 10,000 10,000 10,080 10,000 10,000 01- 410 -54 -00-5462 PROFESSIONAL SERVICES 1,714 1,861 1,700 1,087 1,000 1,081 1,081 01- 410 -54 -00-5480 UTILITIES 124,547 94,920 75,000 75,000 80,000 84,081 88,200 Eleciricih• $80,000 01- 410 -54 -00-5485 RENTAL & LEASE PURCHASE 55 300 1 1,000 1,000 1,000 1,087 01- 410 -54 -00-5495 OUTSIDE REPAIR AND MAINTENANCE 9,913 26,856 25,087 25,000 30,087 35,081 40,000 Al.hae-, - - Vehicles 530,007 Total: Contractual Services $175,550 $164,338 $133,720 $124,520 $135,020 $144,020 $153,220 Supplies 01- 410 -56 -00-5600 WEARINGAPPAREL 1,933 2,441 4,200 2,500 5,000 4,200 4,200 01- 410 -56 -00-5620 OPERATING SUPPLIES 9,261 3,875 11,500 6,500 9,500 9,500 9,500 Operaling Supplies 58,000 Grovel $1,500 01- 410 -56 -00-5626 HANGING BASKETS 1,825 1,800 2,087 2,000 2,000 2,000 2,000 01- 410.56.00-5630 SMALL TOOLS & EQUIPMENT 1,235 483 1,500 1,600 1,750 1,750 1,750 Safgv Equipment $750 Nand Tools 51,000 01- 410 -56 -00-5640 REPAIR AND MAINTENANCE 24,348 52,532 39,000 40,087 36,500 36,500 36,500 Alainrenmme- Equipment $10,007 Alainrenanre - Streer Lights $9,000 Mainrenanre -Tree signals 515,000 Afainrrnmrcr - Stn, wirer $2,500 01- 410 -56 -00-5656 PROPERTY & BUILDING MAINTENANCE 31,896 16,060 30,087 30,000 30,000 30,081 30,000 Alaimenmrre- Property $30,000 01- 410 -56.00-5695 GASOLINE 33,736 26,132 32,000 32,087 33,600 35,280 37,004 Total: Supplies $104,235 $103,323 $120,200 $114,600 $118,350 $119,230 $120,994 Capital Outlay 01- 410 -60 -00-6040 IN -TOWN ROAD PROGRAM 46 7,364 40,232 40,232 - - - 01- 410 -60 -00-6041 SIDEWALK CONSTRUCTION - 3,966 4,000 2,000 4,081 4,000 4,000 Total: Capital Outlay $46 $11,330 $44,232 $42,232 $4,000 $4,000 $4,000 Total: STREET OPERATIONS $626,098 $641,221 $616,724 $608,352 $595,870 $605,75 0 616 714 35 United City of Yorkville General Fund 540 PUBLIC WORKS - HEALTH AND SANITATION FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 F1'2013 F1'2014 Amount Description Aelual Aclunl Budget Projected AdoplM Projected Projvcled Conlroclual Seniors 01- 540 -54 -00 -5442 GARBAGESERVICES 1,121,092 1,154,840 1,140,000 1,195,000 1,195,000 1,195,000 1,195,000 01- 540 -54 -00 -5443 LEAF PICKUP 5,640 4,320 6,000 6,000 6,000 6,000 6,000 Total: Contractual Services $1,126,732 $1,159,160 $1,146,000 $1,201,000 $1,201,000 $1,201,000 $1,201,000 Total: HEALTH AND SANITATION $1,126 2 1159160 $1,146 1 201 1000 $1,201,000 $1,201,000 $1,201,000 36 ADMINISTRATIVE SERVICES DEPARTMENT The Administrative Services Department accounts for general fund expenditures that are shared by all departments and cannot be easily classified in one department or the other. These expenditures include such items as tax rebates, bad debt, contingencies, corporate legal expenditures and interfund transfers. FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projected Adopted Projected Projected Expenditures Salaries - - - 4,500 5,000 5,000 5,000 Benefits 1,238,197 1,554,427 1,671,339 1,588,325 1,743,350 1,942,718 2,169,731 Contractual Services 1,568,885 2,413,467 1,189,050 1,751,422 1,693,840 1,770,391 1,780,452 Supplies - - - - 5,000 5,000 5,000 Contingencies (7,047) 16,153 10,000 100,000 10,000 10,000 10,000 Other Financing Uses 2,312,731 1,644,594 1,668,794 1,333,448 961,450 1,274,675 889,735 Total Administrative Services & Transfers 5,112,766 5,628,642 4,539,183 4,777,695 4,418,640 5,007,784 4,859,918 $6,000 M $5,000 m C $4,000 $3,000 $2,000 $1,000 $0 37 United City of Yorkville General Fund 640 ADMINISTRATIVE SERVICES FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Aclunl Actual Budget Projected Adopted Projected Projected Salaries 01- 640 -50 -00 -5092 POLICE SPECIAL DETAIL WAGES - - - 4,500 5,000 5,000 5,0()0 Total: Salaries $0 $0 $0 $4,500 $5,000 $5,000 $5,000 Benefits 01- 640.52 -00-5216 GROUP HEALTH INSURANCE 912,886 1,118,821 1,156,090 1,081,167 1,204,000 1,369,600 1,560,040 01- 640 -52 -00 -5222 GROUP LIFE INSURANCE 12,069 28,262 28,240 24,744 26,000 26,000 26,000 01- 640 -52 -00 -5223 DENTAL & VISION INSURANCE 79,348 90,005 100,880 105,337 114,000 127,416 142,416 01- 640 -52 -00 -5224 EMPLOYEE ASSISTANCE 2,083 2,487 4,000 2,425 150 150 150 01- 640 -52 -00 -5230 UNEMPLOYMENT INSURANCE 15,785 38,466 38,000 54,653 60,000 60,1700 60,000 01- 640 -52 -00 -5231 LIABILITY INSURANCE 216,026 276,386 344,129 320,000 339,200 359,552 381,125 Total: Benertls $1,238,197 $1,554,427 $1,671,339 $1,588,325 $1,743,350 $1,942,718 $2,169,731 Conlracluai Services 01-640-54-00-5456 CORPORATE COUNSEL - 110,259 130,1100 130,000 130,000 130,000 130,000 01- 640 -54 -00 -5461 LITIGATION COUNSEL - 93,529 90,000 90,000 60,000 60,000 60,000 01-640 -54.00 -5462 PROFESSIONAL SERVICES - - - 15,000 50,000 50,000 50,000 omaonrced lFErprndunrrs $50,000 01- 640 -54 -00 -5463 SPECIALCOUNSEL - - 65,000 65,000 25,000 25,000 25,000 01- 640 -54 -00 -5466 LEGALSERVICES 407,880 38,747 - - - - - 01. 640 -54 -00 -5475 CABLE CONSORTIUM FEE 73,828 54,240 50,000 80,000 85,000 85,100 85,000 01- 640 -54 -00 -5481 MARKETING -HOTEL TAX 18,643 15,739 20,000 27,000 27,540 28,091 28,652 01- 640 -54 -00 -5491 CITY PROPERTY TAX REBATE 1,005 808 1,050 1,050 1,050 1 1,050 ' 01. 640 -54 -00 -5492 SALES TAX REBATE 759,580 773,140 620,000 860,000 900,000 900,000 900,000 01. 640 -54 -00 -5493 BUSINESS DISTRICT REBATE 245,987 248,742 150,000 294,000 300,000 300,000 300,000 l 01. 640 - 54.005494 ADMISSIONS TAX REBATE 61,096 62,130 63,000 99,550 114,000 190,000 199,500 01- 640 -54- 0(0-5499 BAD DEBT 866 1,016,132 - 89,822 1,250 1,250 1,250 Landfill ARO - Writ, Off $66,345 F)'2011 Fioal Write Off- ARO $22,227 F)'2011 Utility Billing $1,250 F)'2011 &2012 Total: Contractual Services $1,568,885 $2,413,467 $1,189,050 $1,751,422 $1,693,840 $1,770,391 $1,780,452 Supplies 01- 640.56.00 -5625 REIMBURSABLE REPAIRS - - - - 5,000 5,000 5,000 Total: Supplies $0 $0 $0 $0 $5,000 $5,000 $5,000 Contingencies 01- 640 -70 -00 -7799 CONTINGENCIES (7,047) 16,153 10,000 100,000 10,000 10,000 10,000 Total: Contingencies ($7,047) $16,153 $10,000 $100,000 $10,000 $10,000 $10,000 Other Financing Uses 01- 64099 -00 -9915 TRANSFER TO MOTOR FUEL TAX - - - - - 375,000 124,525 01- 640 -99 -00 -9920 TRANSFER TO POLICE CAPITAL - - 25,000 - - - - 01- 640 -99 -00 -9923 TRANSFER TO CITYWIDE CAPITAL 220,000 100 162,500 129,800 125,000 - - 01- 640 -99 -00 -9942 TRANSFER TO DEBT SERVICE 662,383 425,094 429,404 429,404 103,740 99,465 - 01-640-99-00-9951 TRANSFER TO WATER 200,000 - - - - - - 01- 64099 -00-9952 TRANSFER TO SEWER 150,100 - - - - - - 01- 64099. 00-9979 TRANSFER TO PARK & RECREATION 1,080,348 1,119,500 1,051,890 774,244 732,710 800,210 765,210 Total: Other Financing Uses $2,312,731 $1,644,594 $1,668,794 $1,333,448 $961,450 $1,274,675 $889,735 Total: ADIIIINISTRAT'IVE SERVICES $5,112,766 $5,628,642 $4,539,183 $4,777,695 $ 4,418,640 $5,007,784 $4,859,918 38 �I 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. FY2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projected Adopted Projected Proje Revenue Intergovernmental 307,882 434,263 355,000 452,796 517,000 527,650 396,620 Investment Earnings 4,951 779 1,000 1,000 1,000 1,000 1,000 Reimbursements 113,644 38,057 - 162,580 493,000 - - Miscellaneous 176 105 86 - - - Other Financing Sources - - - - - 375,000 124,525 Total Revenue 426,652 473,203 356,000 616,462 1,011,000 903,650 522,145 Expenditures Contractual Services 15,338 7,865 30,000 - - - - Supplies 284,835 191,203 295,600 310,585 311,600 339,600 351,150 Capital Outlay 162,031 208,135 150,000 188,740 349,400 853,400 658,400 Contingencies - (38,685) - - - - - Other Financing Uses - - - 96,000 - - Tota Expenditures 462,204 368,519 475,600 595,3 661,000 1,193,000 1,009,550 Surplus (Deficit) (35,552) 104,684 (119,600) 21,137 350,000 (289,350) (487,405) Ending Fund Balance 300,934 405,618 181,334 426,755 776,755 487,405 0 $1,000 Fund Balance $aoo o $hoo L ~ $400 $200 $0 39 United City of Yorkville Motor Fuel Tax Fund 15 MOTOR FUEL TAX FUND REVENUE FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FT 2013 FY 2014 Account Description Actual Actual Budgct Projected Adopted Projccted Projected Inlcrg- muracnlal 15- 000 -41 -00 -4112 MOTOR FUEL TAX 292,372 409,576 355,1)00 355,000 355,000 365,650 376,620 15- 000 -41 -00 -4113 61FT HIGH GR0WTH 15,510 24,687 - 24,674 20,000 20,000 20,000 15- 000 -41 -00 -4172 ILLINOIS JOBS NOW PROCEEDS - - - 73,122 142,000 142,000 - Total: bdcrgarenmrenlal $307,882 $434,263 $355,000 $452,796 $517,000 $527,650 $396,620 Llreslmcul Eandngs 15- 000 -45 -00 -4500 INVESTMENT EARNINGS 4,951 779 1,000 1,000 1,000 1,000 1,000 Total: Inecslmnd Earning $4,951 $779 $1,000 $1,000 $1,000 $1,000 $1,000 Reimbursements 15000 -46 -00-4602 REIMB - GAME FARM ROAD DESIGN 113,644 - - 6,978 - - - 15- 000 -46 -00-4603 REIMB - FOX ROAD - 38,057 - 4,602 - - - 15- 000 -46 -00-4605 REIMB - 0LD JAIUDN'rWN PARKING LOT - - - 151,000 493,000 - - Total: Reimhumemcnts $113,644 $38,057 $0 $162,580 $493,000 $0 $0 Miscellaneous 15- 000 -48.00-4850 MISCELLANEOUS INCOME 176 105 - 86 - - - Total: Miscellaneous $176 $105 $0 $86 $0 $0 $0 Other Financing U- 15-000-49-00-4901 TRANSFER FROM GENERAL - - - - - 375,000 124,525 Total: Other Financing Uses $0 $0 $0 $0 $0 $375,000 $124,525 Total: MFT FUND REVENUE $426,652 $473,203 $356,000 $616,462 $1,011,000 $903,650 $522,145 40 United City of Yorkville Motor Fuel Tax Fund 155 MOTOR FUEL TAX FUND EXPENDITURES FY 2009 FS' 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projmted Adopted Projected Projected Contractual Scrricu 15- 155.5400.5495 OUTSIDE REPAIR AND MAINTENANCE 15,338 7,865 30,000 - - - - Total: Contractual Serri- $15,338 $7,865 $30,000 $0 $0 $0 $0 Supplies 15- 155.56.00 -5618 SALT 240,496 170,268 201,000 204,000 220,00 231,000 242,550 15- 155.56.00 -5619 SIGNS 12,343 5,941 18,000 10,000 18,000 35,000 35,000 15- 155 -56- 00.5631 CRACK FILLING 26,549 - - - - - - 15- 155 -56 -00 -5632 PATCHING - - 50,000 49,857 50,000 50,000 50,000 15- 155 -56 -00 -5633 COLD PATCH 5,447 3,983 10,600 10,600 10,600 10,600 10,600 15- 155 -56 -00 -5634 HOT PATCH - 11,011 13,000 13,000 13,000 13,000 13,000 15- 155 -56 -00 -5640 REPAIR AND MAINTENANCE - - - 23,128 - - - Total: Supplies $284,835 $191,203 $295,600 $310,585 $311,600 $339,600 $351,150 Capital Outlay 15- 155 -60 -00 -6072 DOWNTOWN PARKING LOT - - - - 55,000 440,000 - 15. 155 -60 -0 -6073 GAME FARM ROAD PROJECT 143,751 54,226 150,000 166,810 150,000 70,00 40,000 15155 -60 -00 -6074 FOX ROAD PROJECT 9,900 153,910 - 21,930 - - - 15- 155 -60 -00 -6075 RIVER ROAD BRIDGE PROJECT - - - - 25,000 25,000 100,000 15- 155 -60 -00 -6077 COUNTRYSIDE PKY CONSTRUCTION 8,380 - - - - - 15- 155 -60 -00 -6079 ROUTE 47 EXPANSION - - - - 119,400 318,400 318,40 15- 155 -60 -0 -6080 US 34 & SYCAMORE TRAFFIC SIGNALS - - - - - - 20,000 I ' Total: Capital Outlay $162,031 $208,135 $150,000 $188,740 $349,400 $853,400 $658,400 Contingencies 15- 155 -70 -0 -7799 CONTINGENCIES - (38,685) - - - - - Total: Contingencies $0 ($38,685) $0 $0 $0 $0 $0 Other Financing Uses 15.155.99.0 -9923 TRANSFER TO CITY -WIDE CAPITAL - - - 96,000 - - - Total: O1her Financing Uses $0 $0 $0 $96,000 $0 $0 $0 Total: MFP EXPENDITURES $462,204 $368,519 $475,60 0 595 325 $661,000 $1,193,00 $L009.550 41 Parks and Recreation Fund (79) I 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 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projected Adopted Projected Projected Revenue Intergovernmental 2,000 1,478 500 - - - - Charges for Service 419,091 365,910 394,000 347,792 345,000 345,000 345,000 Investment Earnings 1,370 286 500 300 300 300 300 Reimbursements - - - 7,000 - - - Miscellaneous 32,292 29,905 33,100 26,200 97,700 30,200 65,200 Other Financing Sources 1,080,348 1,119,500 1,051,890 774,244 732,710 800,210 765,210 Total Revenue 1,535,101 1,517,079 1,479,990 1,155,536 1,175,710 1,175,710 1,175,710 Expenditures Salaries 1,009,480 790,971 807,938 684,300 648,300 648,300 648,300 Benefits 141,014 124,085 134,224 110,884 109,730 109,730 109,730 Contractual Services 157,117 125,365 149,300 138,400 150,430 150,430 150,430 Supplies 252,136 245,396 270,450 247,103 267,250 267,250 267,250 Contingencies 440 - - - - - - Other Financing Uses - 150,000 100,000 - - - - Total Expenditures 1,560,187 1,435,817 1,461,912 1,180,687 1,175,710 1,175,710 1,175,710 Surplus (Deficit) (25,086) 81,262 18,078 (25,151) - - - Ending Fund Balance (56,112) 25,151 (38,034) 0 0 0 0 0.0% 0.0% 0.0% 0.0% $40 Fund Balance N e $20 0 $ 7 (] F ($20) ($40) ($60) ($ 42 FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projected Adopted Project Projected Personnel - Parks Department Full -time Personnel: Parks Superintendent 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Foreman 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Maintenance Worker 3.0 3.0 2.0 2.0 2.0 2.0 2.0 Maintenance Worker 11 4.0 4.0 4.0 4.0 4.0 4.0 4.0 Total Full -Time Personnel 9.0 9.0 8.0 8.0 8.0 8.0 8.0 Part -time Personnel: Seasonal Staff 12.0 2.0 4.0 4.0 4.0 4.0 4.0 Total Personnel - Parks 21.0 11.0 12.0 12.0 12.0 12.0 12.0 Personnel - Recreation Department Full -time Personnel: Director of Parks & Recreation 1.0 0.5 0.5 0.5 0.5 0.5 0.5 Recreation Superintendent 0.0 0.0 0.0 1.0 1.0 1.0 1.0 Recreation Manager 1.0 1.0 1.0 0.0 0.0 0.0 0.0 Recreation Coordinator 2.0 2.0 2.0 1.0 1.0 1.0 1.0 Office Supervisor 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Receptionist 1_0 1_0 1_0 0_0 0_0 0_0 0_0 Total Full -Time Personnel 6.0 5.5 5.5 3.5 3.5 3.5 3.5 Part -time Personnel: Receptionist 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Maintenance Worker 1.0 0.0 0.0 0.0 0.0 0.0 0.0 Total Part -Time Personnel 2.0 1.0 1.0 1.0 1.0 1.0 1.0 Total: Personnel - Recreation 8.0 6.5 6.5 4.5 4.5 4.5 4.5 Total Personnel 29.0 17.5 18.5 16.5 16.5 16.5 16.5 The City Administrator is also the hiterim Director of Parks and Recreation Salaq and benefit amounts are split equally benveen General and Pat* and Recreation Finds 43 United City of Yorkville Parks and Recreation Fund 79 PARKS AND RECREATION FUND REVENUE FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Aclunl Actual Budget Projected Adopted Prajmled Projected lntergorenwenlal 79- 000 -41 -00 -4182 S11SC INTERGOVERNMENTAL 2,000 1,478 500 - - - - Total: Intergovernmental $2,000 $1,478 $500 $0 $0 $0 $0 Charges for Services 79- 000 -44 -00 -4440 PROGRAM FEES 244,521 180,230 225,000 180,000 180,000 180,000 180,000 79000 -44 -00 -4441 CONCESSION REVENUE 29,597 39,573 30,000 33,000 30,000 30,000 30,000 79. 000 -44 -00 -4442 GOLF OUTING REVENUE 34,210 8,659 9,000 - - - - 79000- 44- 00 -4"3 HOMETOWN DAYS 110,763 137,448 130,000 134,792 135,00 135,800 135,000 Total: Charges for Services $419,091 $365,910 $394,000 $347,792 $345,000 $345,000 $345,000 I n-cstmcnl Earnings 79- 000 -45 -00 -4500 INVESTMENT EARNINGS 1,370 286 500 300 300 300 300 Total: Investment Earnings $1,370 $286 $500 $300 $300 $300 $300 Reimbursements 79- 000.46.00 -4680 REIMB - LIABILITY INSURANCE - - - 7,000 - - - Total: Reimbursements $0 $0 $0 $7,000 $0 $0 $0 Miscellaneous 79000 -48- 004820 RENTAL INCOME 15,991 19,329 15,000 15,00 86,100 15,100 50,000 Veri,on Wireless lease $71,000 Odrer Renal Lrmrne $15,000 79- 000 -48 -00 -0846 SPONSORSHIPSIDONATIONS 16,301 10,576 14,600 11,200 11,200 14,700 14,700 79. 000 -48 -00-4850 MISCELLANEOUS INCOME - - 3,500 - 500 500 500 Total: - Miscellaneous $32,292 $29,905 $33,100 $26,200 $97,700 $30,200 $65,200 Other Financing Sources 79- 000 -49 -00-4901 TRANSFER FROM GENERAL 1,080,348 1,119,500 1,051,890 774,244 732,710 800,210 765,210 Total: Other Financing Sources $1,080,348 $1,119,500 $1,051,890 $774,244 $732,710 $800,210 $765,210 Total: PARKS & REC REVENUE $1,535,101 $1,517,079 $1,479,990 $1,155,536 $1,175,710 $1,175,710 $1,175,710 I I I 44 United City of Yorkville Parks and Recreation Fund 790 PARKS DEPARTMENT EXPENDITURES FY 2009 FY 2010 FY 2011 F1' 2011 FY 2012 FY 2013 FY 2014 Aunt Description Actual Actual Budget Projected Adopted Projected Projected Salaries 79. 790.50 - 00.5010 SALARIES AND WAGES 402,683 383,500 350,026 353,000 370,000 370,000 370,000 79- 790 -50.00-5015 PART -TIME SALARIES 27,925 7,509 17,000 16,I)OO 17,000 17,000 17,000 79- 790 -50-00-5020 OVERTIME 3,264 308 4,000 500 3,0017 3,000 3,000 Total: Salaries $433,872 $391,317 $371,026 $369,500 $390,000 $390,000 $390,000 B-ergs 79- 790 -52 -00-5212 RETIREMENT PLAN CONTRIBUTION 32,296 32,960 33,953 33,500 37,730 37,730 37,730 79- 790 -52 -00-5214 FICA CONTRIBUTION 33,192 29,265 28,383 28,611 30,0170 30,000 30,000 Total: Benerils $65,488 $62,224 $62,336 $62,111 $67,730 $67,730 $67,730 Contractual Services 79- 790 -54 -00-5412 TRAINING &CONFERENCES 834 - 1,500 700 2,600 2,600 2,600 79- 790 -54 -00-5415 TRAVEL AND LODGING 41 - - - 750 750 750 79- 790 -54 -00-5440 TELECOMMUNICATIONS 3,927 3,085 4,200 4,200 3,780 3,780 3,780 Cellul-Ph -, $3,780 79- 790 -54 -00-5462 PROFESSIONAL SERVICES 21,449 865 2,000 2,500 4,500 4,500 4,500 Increased fim IT Bemires 79- 790 -54 -00-5466 LEGAL SERVICES 10,742 4,582 4,000 2,000 4,000 4,000 4,000 79- 790.54 -00-5485 RENTAL &LEASE PURCHASE 1,631 - 2,500 500 2,500 2,500 2,500 Total: Contractual Services $38,625 $8,532 $14,200 $9,900 $18,130 $18,130 $18,130 Supplies 79- 790 -56 -00-5600 WEARING APPAREL 2,801 4,024 4,100 4,100 4,100 4,100 4,100 79- 790 -56 -00-5610 OFFICE SUPPLIES 142 70 300 150 300 300 300 79- 790 -56 -00-5620 OPERATING SUPPLIES 22,801 20,372 22,000 17,000 22,500 22,500 22,500 Opermhrg Snppaes $20,000 Floarec d Trees $1,000 Chrisbeas& Public Drmrnlionr 51,500 79- 790 -56 -00-5630 SMALL TOOLS & EQUI PMENT 923 1,889 2,250 2,250 2,250 2,250 2,250 Nand Tools $1,750 Ohre Egoil ar 5500 79- 790 -56 -00-5635 COMPUTER EQUIPMENT & SOFTWARE - - 500 - 500 500 500 79- 790 -56 -00-5640 REPAIR AND MAINTENANCE 35,265 40,514 48,000 38,000 48,000 48,000 48,000 31aimenan e - Equipment 514,000 3lainteumree - ParAs 534,000 Total: Supplies $61,931 $66,868 $77,150 $61,500 $77,650 $77,650 $77,650 Total: PARK DEPT EXPENDITURES $599,917 $528,941 $524,712 $503,011 $553,510 $553.51 0 553 510 45 United City of Yorkville Parks and Recreation Fund 795 RECREATION DEPARTMENT EXPENDITURES FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Salaries 79- 795 -50 -00 -5010 SALARIES AND WAGES 400,557 342,637 368,532 248,500 190,000 190,000 190,000 79- 795 -50 -00 -5015 PART -TIME SALARIES 42,060 13,482 22,080 16,000 22,000 22,000 22,000 79- 795 -50 -00 -5020 OVERTIME - - 300 300 300 300 300 79- 795 -50 -00 -5045 CONCESSION WAGES 8,842 9,968 10,000 10,000 10,000 10,000 10,000 79- 795 -50 -00 -5046 PRE - SCHOOL WAGES 36,905 19,468 20,000 20,000 20,000 20,000 20,000 79- 795 -50 -00 -5052 INSTRUCTORS WAGES 87,243 14,100 16,000 20,000 16,000 16,000 16,000 Total: Salaries $575,607 $399,654 $436,912 $314,800 $258,300 $258,300 $258,300 Benefits 79- 795 -52 -00 -5212 RETIREMENT PLAN CONTRIBUTION 35,095 31,675 41,537 28,584 22,000 22,000 22,000 79- 795 -52 -00-5214 FICA CONTRIBUTION 40,430 30,185 30,351 20,189 20,000 20,000 20,000 Total: Benefits $75,526 $61,860 $71,888 $48,773 $42,000 $42,000 $42,000 Contractual Services 79- 795 -54 -00 -5412 TRAINING & CONFERENCES 2,455 - 500 700 2,000 2,000 2,000 79- 795 -54 -00 -5415 TRAVEL AND LODGING 499 - 300 - 1,000 1,000 1,000 79- 795 -54 -00 -5419 GOLF OUTING 21,457 6,001 6,000 - - - - 79- 795 -54 -00 -5426 PUBLISHING & ADVERTISING 41,405 28,013 27,000 27,000 27,000 27,000 27,000 79- 795 -54 -00 -5440 TELECOMMUNICATIONS 5,896 4,358 4,300 4,300 4,300 4,300 4,300 Celhdar Plmne $3,000 Telephone /Internet $1,300 li 79- 795 -54 -00-5447 SCHOLARSHIPS 1,050 156 1,000 500 1,000 1,000 1,000 79- 795 -54 -00 -5452 POSTAGE & SHIPPING 12,009 7,391 8,000 7,500 8,000 8,000 8,000 79- 795 -54 -00 -5462 PROFESSIONAL SERVICES 2,966 43,483 53,000 54,000 53,000 53,000 53,000 Contractual Serrices $50,000 Recording Secrelaq - Contractual $3,000 79- 795 -54 -00 -5480 UTILITIES 12,031 15,690 22,000 22,000 22,000 22,000 22,000 Electricity $21,000 79- 795 -54 -00 -5485 RENTAL &LEASE PURCHASE 4,267 4,145 3,500 3,500 4,500 4,500 4,500 79- 795 -54 -00 -5490 DUES AND SUBSCRIPTIONS 713 1,061 1,500 1,500 1,500 1,500 1,500 79- 795 -54 -00-5495 OUTSIDE REPAIR AND MAINTENANCE 1,552 587 1,000 1,500 1,000 1,000 1,000 79- 795 -54 -00-5496 PROGRAM REFUNDS 12,193 5,949 7,000 6,000 7,000 7,000 7,000 Total: Contractual Services $118,492 $116,833 $135,100 $128,500 $132,300 $132,300 $132,300 Supplies 79- 795 -56 -00-5600 WEARING APPAREL - - - - - - - 79- 795 -56 -00-5602 HOMETOWN DAYS SUPPLIES 94,783 100,579 100,0()1 99,903 100,000 100,000 100,000 79- 795 -56 -00 -5606 PROGRAM SUPPLIES 54,603 41,176 53,600 54,000 55,000 55,000 55,000 79- 795 -56 -00 -5607 CONCESSION SUPPLIES 18,658 24,239 18,000 16,000 18,000 18,000 18,000 79- 795 -56 -00 -5610 OFFICE SUPPLIES 4,599 4,268 3,000 2,500 3,000 3,000 3,000 79- 795 -56 -00 -5620 OPERATING SUPPLIES 6,199 4,837 8,500 5,500 5,500 5,500 5,500 Operating Supplies $1,000 Portable Tailels $4,500 79- 795 -56 -00 -5630 SMALL TOOLS & EQUIPMENT 1,788 510 2,000 2,000 2,000 2,000 2,000 Recreation Equipnrenl $1,000 79- 795 -56 -00 -5635 COMPUTER EQUIPMENT & SOFTWARE 155 98 2,600 2,600 500 500 500 79- 795 -56 -00 -5640 REPAIR AND MAINTENANCE 3,714 825 2,000 1,000 2,000 2,000 2,000 46 I United City of Yorkville Parks and Recreation Fund 795 RECREATION DEPARTMENT EXPENDITURES FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected 79- 795 -56 -00 -5645 BOOKS AND PUBLICATIONS 708 104 100 100 100 100 100 79- 795 -56 -00 -5690 SUPPLIES - GRANT REIMBURSABLE 489 45 500 - 500 500 500 Youth Services Grant Erpenses $500 79- 795 -56 -00 -5695 GASOLINE 4,511 1,846 3,000 2,000 3,000 3,000 3,000 Total: Supplies $190,205 $178,528 $193,300 $185,603 $189,600 $189,600 $189,600 Contingencies 79- 795 -70 -00 -7799 CONTINGENCIES 440 - - - - - - Total: Contingencies $440 $0 $0 $0 $0 $0 $0 Other Financing Uses 79- 795 -99 -00 -9901 TRANSFER TO GENERAL - 150,000 100,000 - - - - Total: Other Financing Uses $0 $150,000 $100,000 $0 $0 $0 $0 Total: RECREATION EXPENDITURES $960,270 $906,875 $937,200 $677,676 $622,200 $622,200 $622,200 47 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 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projection Adopted Pro P Revenue Intergovernmental 602,026 103,337 350,000 352,655 400,000 400,000 96,000 Land Cash Contributions 132,074 165,811 63,000 119,239 20,500 20,500 20,500 Tot Revenue 734,100 269,148 413,000 4 42 0,500 420,500 116, Expenditures Contractual Services 100,000 - - - - - - Capital Outlay 476,124 246,607 605,000 239,666 281,000 207,000 413,000 Other Financing Uses 181,000 60,449 60,449 60,449 20,084 17,851 12,640 Total Expenditures 757,124 307,056 665,449 300,115 301,084 224,851 425,640 Surplus (Deficit) (23,024) (37,908) (252,449) 171,779 119,416 195,649 (309,140) Ending Fund Balance (565,517) (603,425) (817,966) (431,646) (312,230) (116,581) (425,721) Fund Balance $0 M ($200) o ($400) ~ ($600) ($800) ($1,000) 48 United City of Yorkville Land Cash Fund 72 LAND CASH REVENUE F1' 2009 FS' 2010 FY 2011 F1' 2011 FY 2012 F1' 2013 FP 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Intergovernmental 72- 000.41 - 004170 STATE GRANTS - 103,337 350,000 352,655 400,000 400,000 96,000 Oslad Gri- It'hsprg Aldoics F)' 2011 5312,655 RTP- B'henrnn Woods F)'2011 $40,000 Oslnd G-1- Prairie Alendo- F)'2012 0s1nd Grmu - Rona- F)'2013 RTP- Nopkm, Park F)'2014 72- 000.41 -00-4182 MISC INTERGOVERNMENTAL 602,026 - - - - - - Total: Intergovernmental $602,026 $103,337 $350,000 $352,655 $400,000 $400,000 $96,000 Land Cash Contrthulions 72- 000 -47- 00.4701 WHITE OAK UNIT 3 & 4 1,406 - - - - - - 72- 000.47 - 00.4702 WHISPERING MEADOWS (K HILL) 13,533 3,383 3,000 - - - - 72- 000 -47 -00-4703 AUTUMN CREEK 30,999 62,427 22,000 18,000 20,000 20,000 20,000 72- 000 -47 -00-4704 BLACKBERRY WOODS 1,136 - - 568 500 500 500 72- 100 -47 -00 -4705 BRISTOL BAY 85,000 100,000 - 100,000 - - - 72- 000.47 -00-4706 CALEDONIA - - 38,000 - - - - 72- 000 -47 -00-4707 RIVER'S EDGE - - - 671 - - - Total: Land Cash Contributions $132,074 $165,811 $63,000 $119,239 $20,500 $20,500 $20,500 Total: LAND CASH REVENUE $734,100 $269,148 $413,000 $471,894 $420,500 $420,500 $116,500 49 �I United City of Yorkville Land Cash Fund 720 LAND CASH EXPENDITURES FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Contractual Services 72- 72054 -00-5485 RENTAL AND LEASE PURCHASE 100,000 - - Total: Con(ruclual Services $100,000 $0 $0 $0 $0 $0 $0 Capital Oullap 72- 720 -60 -00-6029 CALEDONIA - - - - - 75,000 - 72- 720 -60 -00 -6031 HEARTLAND CIRCLE 133,749 22,408 - - - - - 72-720-60-00-6032 MOSIER HOLDING COSTS 6,000 10,000 10,000 10,000 11,000 12,000 13,00 72- 720 -60 -00-6033 PRAIRIEMEADOWS(MENARDS) 148,206 - - - - - - 72- 72060.00.6034 WHISPERING MEADOWS (K HILL) 134,577 196,015 - - - - - 72- 7206000.6036 RAINTREE VILLAGE 3,405 - 495,000 130,000 270,000 - - 72. 720 -60 -00-6037 GRANDE RESERVE BIKE TRAIL 50,187 2,650 - - - - - 72- 720.6000-6038 WHEATON WOODS NATURE TRAIL - 15,535 - 2,133 - - - 72 - 720.60. 00.6039 BRISTOL BAY -PARKA - - 100,000 83,513 - - - 72- 720.60.00 -6043 BRISTOL BAY REGIONAL PARK - - - 14,020 - - - 72- 720 -60- 00.6044 HOPKINS PARK - - - - - 120,000 - 72- 720 -60 -00-6045 RIVERFRONT PARK - - - - - - 400,000 Total: Capitol Outlay $476,124 $246,607 $605,000 $239,666 $281,000 $207,000 $413,000 Other Financing U- 72-720-99-00-9901 TRANSFER TO GENERAL 181,000 60,449 60,449 60,449 20,084 17,851 12,640 Total: Other Financing Sources $181,000 $60,449 $60,449 $60,449 $20,084 $17,851 $12,640 Total: LAND CASH EXPENDITURES $757,124 $307.05 6 665 449 $300,115 $301,0114 $224,851 $425,640 50 Fox Industrial TIF Fund (85) The Fox Industrial TIF was created in 2001, in order to finance public infrastructure improvements for the Fox Industrial area. This TIF is scheduled to be closed out in either late FY 2011 or FY 2012. FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projected Adopted P rojected Pr Revenue Taxes 207,398 216,677 216,677 228,346 Investment Earnings 1,504 45 50 13 Total Revenue 208,902 216,721 216,727 228,360 Expenditures Contractual Services 252 1,220 500 1,000 Debt Service 80,555 77,793 79,933 224,933 Other Financing Uses 25,680 - - 425,778 Total Expenditures 106,487 79,013 80,433 651,711 Surplus (Deficit) 102,415 137,709 136,294 (423,351) Ending Fund Balance 285,643 423,351 421,937 0 0 0 0 I $500 Fund Balance $400 $ $300 r ~ $200 $100 $0 I 51 I I United City of Yorkville Fox Industrial TIF Fund 85 FOX INDUSTRIAL FUND REVENUE FY 2009 FY 2010 FY 2011 FV 2011 FV 2012 FY 2013 FY 2014 Account Description Actual Actual Rudgcl Projected Adapted Projected Projected Tovcs 85- 000 - 40.00 -4085 PROPERTY TAXES - FOX INDUSTRIAL TIE 207,398 216,677 216,677 228,346 - - - Total: Taxes $207,398 $216,677 $216,677 $228,346 $0 $0 $0 Investment Earnings 85. 000 -45 -00-4500 INVESTMENT EARN] NOS 1,501 45 50 13 - - - Total: Investment Earnings $1,504 $45 $50 $13 $0 $0 $0 Total: FOX INDUSTRIAL TIF REVENUE $208,902 $216,721 $216,727 $228,360 LO L0 .L. i I I 52 United City of Yorkville Fox Industrial TIF Fund 850 FOX INDUSTRIAL FUND EXPENDITURES FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Contractual Services 85- 850 -54 -01 -5420 ADMINISTRATIVE FEES 252 1,220 500 1,000 - - - Total: Contractual Services $252 $1,220 $500 $1,000 $0 $0 $0 Debt Service - 2002 Bond 85- 850 -98 -00 -8000 PRINCIPLE PAYMENT 65,000 65,000 70,000 215,000 - - - 85- 850 -98 -00 -8050 INTERESTPAYMENT 15,555 12,793 9,933 9,933 - - - Total: Debt Service - 2002 Bond $80,555 $77,793 $79,933 $224,933 $0 $0 $0 Other Financing Uses 85- 850 -99.00 -9901 TRANSFER TO GENERAL 25,680 - - - - - - 85- 850 -99- 00.9999 TRANSFER OUT - - - 425,778 - - - LtquiAntia, JTIF Total: Other Financing Uses $25,680 $0 $0 $425,778 $0 $0 $0 Total: FOX INDUSTRIAL TIF $106,487 $79,013 $80,433 $651,711 $ ko Lo 53 UNITED CITY OF YORKVILLE, ILLINOIS Fox Industrial TIF Fund Long -Term Debt Requirements General Obligation Bonds 2002 April 30, 2011 Date of Maturity December 1, 2012 Authorized Issue $625,000 Interest Rates 3.00% - 4.75% Interest Dates June 1st and December 1st Principal Maturity Dates December 1st Payable at BNY Midwest Trust Company Purpose Fox Industrial TIF CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Interest Due on Fiscal Year Principal Interest Totals June 1st Amount Dec 1st Amount 2011-2012 $ 70,000 $ 6,783 $ 76,783 2011 $ 3,392 2011 $ 3,392 2012-2013 75,000 3,563 78,563 2012 1,782 2012 1,782 $ 145,000 $ 10,346 $ 155,346 $ 5,173 $ 5,173 I I I I 54 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 2011 I FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projection Adopted Projected Projected Revenue Taxes 8,455 6,250 6,250 6,372 6,250 6,250 6,250 Investment Earnings 37,322 8,223 6,104 4,636 4,000 4,000 4,000 Tot Revenue 45,777 14,472 12, 11, 10,250 10,250 10,250 Expenditures Contractual Services 13,366 999 1,000 1,000 1,400 1,400 1,400 Debt Service 142,868 307,868 307,093 307,093 306,143 304,668 302,738 Total Expenditures 156,234 308,867 308,093 308,093 307,543 306,068 304,138 Surplus (Deficit) (110,456) (294,394) (295,739) (297,085) (297,293) (295,818) (293,888) Ending Fund Balance 2,772,153 2,477,758 2,476,414 2,180,673 1,883,380 1,587,562 1,293,674 $3,000 Fund Balance $2,000 0 t I ~ $1,000 $0 i IC I �I i i I I 55 United City of Yorkville Countryside TIF Fund 87 COUNTRYSIDE TIF FUND REVENUE FY 1009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Taxes 87- 000 -40 -00 -4087 PROPERTY TARES - COUNTRYSIDE TIF 8,455 6,250 6,250 6,372 6,250 6,250 6,250 Total: Taxes $8,455 $6,250 $6,250 $6,372 $6,250 $6,250 $6,250 Investment Earnings 87- 000 -45 -00 -4500 INVESTMENT EARNINGS 37,322 8,223 6,104 4,636 4,000 4,000 4,000 Total: Investment Earnings $37,322 $8,223 $6,104 $4,636 $4,000 $4,000 $4,000 Total: COUNTRYSIDE TIF REVENUE $45,777 $14A72 $12,354 $11 $M250 $10,250 $10,250 56 United City of Yorkville Countryside TIF Fund 870 COUNTRYSIDE TIF FUND EXPENDITURES FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Contractual Services 87- 870 -54 -00 -5420 ADMINISTRATIVE FEES 13,366 999 1,0110 1,000 1,000 1,000 1,000 87- 870 -54 -00 -5498 PAYING AGENT FEES - - - - 400 400 400 Total: Contractual Services $13,366 $999 $1,000 $1,000 $1,400 $1,400 $1,400 Debt Service - 2005 Bond 87- 870 -80 -00 -8000 PRINCIPLE PAYMENT - 165,000 170,000 170,000 175,000 180,000 185,000 87- 870 -80 -00 -8050 INTEREST PAYMENT 142,868 142,868 137,093 137,093 131,143 124,668 117,738 Total: Debt Service - 2005 Bond $142,868 $307,868 $307,093 $307,093 $306,143 $304,668 $302,738 Total: COUNTRYSIDE TIF $156,234 $308,867 $308,093 $308,093 $307,543 $306,068 $304,138 I II I I I I 57 UNITED CITY OF Y ORKVILLE, ILLINOIS Countryside TIF Fund Long -Term Debt Requirements General Obligation Bonds 2005 April 30, 2011 Date of Maturity December 1, 2024 Authorized Issue $3,525,000 Interest Rates 3.50% - 4.35% Interest Dates June Ist and December 1st Principal Maturity Dates December 1st Payable at BNY Midwest Trust Company Purpose Countryside TIF CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Interest Due on Fiscal Year Principal Interest Totals June 1st Amount Dec 1st Amount 2011-2012 $ 175,000 $ 131,143 $ 306,143 2011 $ 65,572 2011 $ 65,572 2012-2013 180,000 124,668 304,668 2012 62,334 2012 62,334 2013-2014 185,000 117,738 302,738 2013 58,869 2013 58,869 2014-2015 195,000 110,523 305,523 2014 55,261 2014 55,261 2015-2016 200,000 102,723 302,723 2015 51,361 2015 51,361 2016-2017 210,000 94,723 304,723 2016 47,361 2016 47,361 2017-2018 220,000 86,323 306,323 2017 43,161 2017 43,161 2018-2019 225,000 77,523 302,523 2018 38,761 2018 38,761 2019 -2020 235,000 68,073 303,073 2019 34,036 2019 34,036 2020-2021 245,000 58,203 303,203 2020 29,101 2020 29,101 2021-2022 260,000 47,913 307,913 2021 23,956 2021 23,956 2022-2023 275,000 36,993 311,993 2022 18,496 2022 18,496 2023-2024 285,000 25,305 310,305 2023 12,653 2023 12,653 2024-2025 300,000 13,050 313,050 2024 6,525 2024 6,525 $ 3,190,000 $ 1,094,897 $ 4,284,897 $ 547,448 $ 547,448 58 Downtown TIF Fund (88) The Downtown TIF was created in 2006, in order to finance a mixed use development in the downtown area. FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projection Adopted Pro P Revenue Taxes 71,588 88,550 88,550 75,362 88,550 88,550 88,550 Miscellaneous 3,551 - - - - - - Total Revenue 75,139 88,550 88,550 75,362 88,550 88,550 88,550 Expenditures Contractual Services 4,069 1,832 1,500 1,500 1,500 1,500 1,500 Capital Outlay 24,063 - - - 515,340 28,630 28,630 Other Financing Uses 25,805 - - - - - - Total Expenditures 53,937 1,832 1,500 1,500 516,840 30,130 30,130 Surplus (Deficit) 21,203 86,719 87,050 73,862 (428,290) 58,420 58,420 Ending Fund Balance 49,575 136,294 136,625 210,156 (218,134) (159,714) (101,294) N $300 Fund Balance c $200 N 3 $100 $ ($100) ($200) ($300) 59 United City of Yorkville Downtown TIF Fund 88 DOWNTOWN TIF FUND REVENUE FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Taxes 88- 000 -40 -00 -4088 PROPERTY TAXES - DOWNTOWN TIF 71,588 88,550 88,550 75,362 88,550 88,550 88,550 Total: Taxes $71,588 $88,550 $88,550 $75,362 $88,550 $88,550 $88,550 Miscellaneous 88- 000 -48 -00 -4850 MISCELLANEOUS INCOME 3,551 - - - - - - Total: Miscellaneous $3,551 $0 $0 $0 $0 $0 $0 Total: DOWNTOWN TIF REVENUE $75,139 $88,550 $88,550 $75,362 $88,550 $88,550 $88,550 60 United City of Yorkville Downtown TIF Fund 880 DOWNTOWN TIF FUND EXPENDITURES FP 2009 FY 2010 FP 2011 FY 2011 FY 2012 FP 2013 FY 2014 Account Description Acluol Actual Budget Projected Adopted Projected Projected Contractual Services 88. 880 -54 -00-5420 ADMINISTRATIVE FEES 532 1,832 1,500 1,500 1,500 1,500 1,500 88. 880.54 -00-5462 PROFESSIONAL SERVICES 3,537 - - - - - - Total: Contractual Semiccs $4,069 $1,832 $1,500 $1,500 $1,500 $1,500 $1,500 Capitol Outlay 88. 880 -60 -00-6040 IN -TOWN ROAD PROGRAM 24,063 - - - - - - 88. 880.60 - 00.6079 ROUTE 47 EXPANSION - - - - 515,340 28,630 28,630 Total: Capital Outlay $24,063 $0 $0 $0 $515,340 $28,630 $28,630 Other Financing Uses 88- 880 -99 -00 -9901 TRANSFER TO GENERAL 25,805 - - - - - - Total: Other Financing Sources $25,805 $0 $0 $0 $0 $0 $0 Total: DOWNTOWNTIF EXPENDITURES $53 ILL02 $516 $30 $30 i i I I 61 Fox Hill SSA Fund (11) This fund was created for the purpose of maintaining the common areas of the Fox Hill Estates subdivision, All money for the fund is derived from property taxes levied on homeowners in the subdivision. FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Proj Ad Projected Projected Revenue Taxes 6,353 19,897 19,463 19,894 3,786 3,804 4,184 Total Revenue 6,353 19,897 19,463 19,894 3,786 3,804 4,184 Expenditures Contractual Services 20,012 4,011 3,458 3,786 3,804 4,184 4,603 T ota l Exp e n d i tu r es 20,012 4,0 3,458 3, 3,804 4, 4, 603 Surplus (Deficit) (13,660) 15,886 16,005 16,108 (18) (380) (419) Ending Fund Balance (13,660) 2,226 2,345 18,334 18,316 17,936 17,517 N $ Fund Balance N $10 7 F $0 ($10) ($20) 62 I United City of Yorkville Fox Hill Special Service Area Fund u FOX HILL SSA FUND REVENUE FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Taxes 11- 000 -40 -00 -4011 PROPERTY TAXES - FOX HILL SSA 6,353 19,897 19,463 19,894 3,786 3,804 4,184 Total: Taxes $6,353 $19,897 $19,463 $19,894 $3,786 $3,804 $4,184 Total: FOX HILL SSA REVENUE $19,897 $19A63 $19,894 3 786 3 804 4184 I I I I I � 63 United City of Yorkville Fox Hill Special Service Area Fund 111 FOX HILL SSA EXPENDITURES FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Contractual Services 11- 111 -54 -00 -5495 OUTSIDE REPAIR AND MAINTENANCE 20,012 4,011 3,458 3,786 3,804 4,184 4,603 Total: Contractual Services $20,012 $4,011 $3,458 $3,786 $3,804 $4,184 $4,603 Total: FOX HILL SSA EXPENDITURES $20,012 H 011 imm lim Lam 4184 MM i 64 Sunflower SSA Fund (12) This fund was created for the purpose of maintaining the common areas of the Sunflower Estates subdivision. All money for the fund is derived from property taxes levied on homeowners in the subdivision. FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projected Adopted Projected Projected Revenue Taxes 15,939 13,871 13,112 13,871 7,530 9,078 9,986 Total Revenue 15,939 13,871 13,112 13,871 7,530 9,078 9,986 Expenditures Contractual Services 14,840 8,782 8,253 7,530 9,078 9,986 10,985 Total Expenditures 14,840 8,782 8,253 7,530 9,078 9,986 10,985 Surplus (Deficit) 1,099 5,089 4,859 6,340 (1,548) (908) (999) Ending Fund Balance 1,099 6,188 5,958 12,528 10,980 10,072 9,073 Fund Balance N $15 r $10 O s $5 $0 I II I � 65 United City of Yorkville Sunflower Special Service Area Fund 12 SUNFLOWER SSA FUND REVENUE FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account D— ripliou Actual Actual Budget Projected Adopted Projecicd Projected T.— 12- 000.40. 004012 PROPERTY TARES - SUNFLOWER SSA 15,939 13,871 13,112 13,871 7,530 9,078 9,986 Total: Tazcs $15,939 $13,871 $13,112 $13,871 $7,530 $9,078 $9,986 Total: SUNFLOWER SSA REVENUE $15,939 $13,871 $13,112 $13,871 7 5J0 9 078 9 986 I I I I 66 I United City of Yorkville Sunflower Special Service Area Fund 112 SUNFLOWER SSA EXPENDITURES FY 2009 FY 2010 FY 2011 FP 2011 FY 2012 FP 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Contractual Services 12112 -54 -00-5495 OUTSIDE REPAIR AND MAINTENANCE 14,840 8,782 8,253 7,530 9,078 9,986 10,985 Tolal: Contractual Services $14,840 $8,782 $8,253 $7,530 $9,078 $9,986 $10,985 Total: SUNFLOWER SSA EXPENDITURES $14,840 MM 8 253 RIM 12M 9 98fi $10,985 I I 67 Debt Service Fund (42) The Debt Service Fund accumulates monies for payment of the 2004C and 2005A bonds. These bonds were issued to finance road improvement projects. Property taxes are levied except for the 2004C bond, which utilizes a General Fund transfer of sales tax to pay its annual debt service requirement. FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actua Budget Projection Adopted Projec Projected Revenue Taxes - - - 324,179 326,379 328,179 Licenses and Permits 24,469 7,628 - 900 - - - Other Financing Sources 721,783 482,294 429,404 429,404 103,740 99,465 - Total Revenue 746,252 489,922 429,404 430,304 427,919 425,844 328,179 Expenditures Contractual Services - - - - 750 800 400 Debt Service 484,524 482,294 429,404 429,404 427,919 425,844 328,179 Other Financing Sources 24,471 - - - - - - Total Expenditures 508,995 482,294 429,404 429,404 428,669 426,644 328,579 Surplus (Deficit) 237,257 7,628 - 900 (750) (800) (400) Ending Fund Balance 0 7,628 0 8,528 7,778 6,978 6,578 N $ Fund Balance $8 o $6 ~ $4 $2 $0 68 United City of Yorkville Debt Service Fund 42 DEBT SERVICE FUND REVENUE FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FR 2014 Account Descriplion Actual Actual Budget Projected Adopted Projected Projected Tries 42- 000 -40 -00-4006 PROPERTY TAXES - 2005A BOND - - - - 324,179 326,379 328,179 Total: Taxes $0 $0 $0 $0 $324,179 $326,379 $328,179 L e,— and Pcrndts 42- 000 -42 -00 -4208 RECAPTURE FEES - WATER & SEWER 24,469 7,628 - 900 - - - Total: Licenses and Permits $24,469 $7,628 $0 $900 $0 $0 $0 Other Financing Sources 42- 000 -49 -00 -4901 TRANSFER FROM GENERAL 662,383 425,094 429,404 429,404 103,740 99,465 - 42- 000 -49 -00 -4916 TRANSFER FROM MUNICIPAL BUILDING 59,400 57,200 - - - - - Total: Other Financing Sources $721,783 $482,294 $429,404 $429,404 $103,740 $99,465 $0 Total: DEBT SERVICE FUND REVENUE $746.25 2 489 92 $429,404 $430,304 $427,919 $425,844 $328,179 69 United City of Yorkville Debt Service Fund 420 DEBT SERVICE FUND EXPENDITURES FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Descriplion Actual Actual Budget Projected Adopted Projected Projected Contractual Services 42 -420 -54 -00 -5498 PAYING AGENT FEES - - - - 750 800 400 Total: Contractual Services $0 $0 $0 $0 $750 $800 $400 Debt Service -2002A Refunding Bond 42- 420 -80 -00 -8000 PRINCIPLE PAYMENT 55,()()0 55,000 - - - - - 42- 420 -80 -00 -8050 INTERESTPAYMENT 4,400 2,200 - - - - - Total: Debt Service - 2002A Refunding $59,400 $57,200 $0 $0 $0 $0 $0 Debt Senice -2004C Bond 42- 420 -81 -00 -8000 PRINCIPLE PAYMENT 85,000 90,000 95,000 95,000 95,000 95,000 - 42 -420 -81 -00 -8050 INTERESTPAYMENT 19,745 16,515 12,825 12,825 8,740 4,465 - Total: Debt Service -2004C Bond $104,745 $106,515 $107,825 $107,825 $103,740 $99,465 $0 Debt Service - 2005A Bond 42- 420 -82 -00 -8000 PRINCIPLE PAYMENT 170,000 175,000 185,000 185,000 195,000 205,000 215,000 42- 420 -82 -00 -8050 INTEREST PAYMENT 150,379 143,579 136,579 136,579 129,179 121,379 113,179 Total: Debt Service - 2005A Bond $320,379 $318,579 $321,579 $321,579 $324,179 $326,379 $328,179 Other Financing Uses 42- 420 - 99.009951 TRANSFER TO WATER 12,236 - - - - - - 42- 420 -99 -00 -9952 TRANSFER TO SEWER 12,235 - - - - - - Total: Other Financing Uses $24,471 $0 $0 $0 $0 $0 $0 Total: DEBT SERVICE $508,995 $482,294 429 404 429 404 $428,669 $426,644 $328,579 I 70 UNITED CITY OF YORKVILLE, ILLINOIS Debt Service Fund Long -Term Debt Requirements Total Debt Service Fund Debt Outstanding at April 30, 2011 TOTAL DEBT SERVICE FUND - OUTSTANDING DEBT Fiscal Years 2012 - 2023 CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Fiscal Year Principal Interest Totals 2011-2012 $ 290,000 $ 137,919 $ 427,919 2012-2013 $ 300,000 $ 125,844 425,844 2013-2014 $ 215,000 $ 113,179 328,179 2014-2015 $ 225,000 $ 104,579 329,579 2015-2016 $ 235,000 $ 95,579 330,579 2016-2017 $ 250,000 $ 86,179 336,179 2017-2018 $ 260,000 $ 76,179 336,179 2018-2019 $ 275,000 $ 65,519 340,519 2019-2020 $ 290,000 $ 54,106 344,106 2020-2021 $ 300,000 $ 41,781 341,781 2021-2022 $ 320,000 $ 28,656 348,656 2022-2023 $ 335,000 $ 14,656 349,656 $ 3,295,000 $ 944,176 $ 4,239,176 71 UNITED CITY OF YORKVILLE, ILLINOIS Debt Service Fund Long -Term Debt Requirements General Obligation Bonds 2004C April 30, 2011 Date of Maturity December 30, 2012 Authorized Issue $650,000 Interest Rates 3.80% - 5.00% Interest Dates June 301h and December 30th Principal Maturity Dates December 30th Payable at The Bank of New York Trust Company Purpose Road Improvement Program CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Interest Due on Fiscal Year Principal Interest Totals June 30th Amount Dec 30th Amount 2011-2012 $ 95,000 $ 8,740 $ 103,740 2011 $ 4,370 2011 $ 4,370 2012-2013 95,000 4,465 99,465 2012 2,233 2012 2,233 $ 1 $ 13,205 $ 203,205 $ 6,603 $ 6,603 I I 72 UNITED CITY OF YORKVILLE, ILLINOIS Debt Service Fund Long -Term Debt Requirements General Obligation Bonds 2005A April 30, 2011 Dale of Maturity December 30, 2022 Authorized Issue $3,825,000 Interest Rates 4.00% - 4.375% Interest Dates June 30th and December 30th Principal Maturity Dates December 30th Payable at BNY Midwest Trust Company Purpose In -Town Road Program Phase I CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Interest Due on Fiscal Year Principal Interest Totals June 30th Amount Dec 30th Amount 2011 -2012 $ 195,000 $ 129,179 $ 324,179 2011 $ 64,589 2011 $ 64,589 2012-2013 205,000 121,379 326,379 2012 60,690 2012 60,690 2013-2014 215,000 113,179 328,179 2013 56,590 2013 56,590 2014-2015 225,000 104,579 329,579 2014 52,289 2014 52,289 2015-2016 235,000 95,579 330,579 2015 47,789 2015 47,789 2016 -2017 250,000 86,179 336,179 2016 43,089 2016 43,089 2017 -2018 260,000 76,179 336,179 2017 38,089 2017 38,089 2018 -2019 275,000 65,519 340,519 2018 32,759 2018 32,759 2019-2020 290,000 54,106 344,106 2019 27,053 2019 27,053 2020-2021 300,000 41,781 341,781 2020 20,891 2020 20,891 2021-2022 320,000 28,656 348,656 2021 14,328 2021 14,328 2022 -2023 335,000 14,656 349,656 2022 7,328 2022 7,328 $ 3,105,000 $ 930,971 $ 4,035,971 $ 465,485 $ 465,485 73 Municipal Building Fund (16) The Municipal Building Fund is used to maintain existing City owned buildings and to fund land acquisition, design and construction of new buildings. FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projection Adopted Projected P Revenue Licenses and Permits 13,650 9,750 55,000 22,000 5,250 5,250 5,250 Total Revenue 13,650 9,750 55,000 22,000 5,250 5,250 5,250 Expenditures Capital Outlay - - - - - - - Other Financing Uses 59,400 57,200 Total Expenditures 59,400 57,200 I Surplus (Deficit) (45,750) (47,450) 55,000 22,000 5,250 5,250 5,250 Ending Fund Balance (560,274) (607,724) (505,274) (585,724) (580,474) (575,224) (569,974) $0 Fund Balance M. ($200) F ($400) ($600) ♦ ♦� ♦ • • ($800) 74 United City of Yorkville Municipal Building Fund 16 MUNICIPAL BUILDING FUND REVENUE FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FV 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Licenses and Permits 16- 000 -42 -00 -4214 DEVELOPMENT FEES 13,650 9,750 55,000 22,000 5,250 5,250 5,250 Total: Licenses and Permits $13,650 $9,750 $55,000 $22,000 $5,250 $5,250 $5,250 Total: MUNICIPAL BLDG REVENUE $13,650 ISM $55,000 $22,000 5 250 5 250 5 250 I ! I I I 75 United City of Yorkville Municipal Building Fund 160 Municipal Building Expenditures FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Capitol Oallay 16- 160 -60 -00 -6020 BUILDINGS AND STRUCTURES - - - - - - - Tidal: Capital Outlay $0 $0 $0 $0 $0 $0 $0 Other Financing Uses 16- 160 -99 -00-9942 TRANSFER TO DEBT SERVICE 59,400 57,200 - - - - - Total: Other Financing Uses $59,400 $57,200 $0 $0 $0 $0 $0 Total: MUNICIPAL BDLG EXPENDITURES $59,400 $57,200 R L0 10 LO 76 Parks and Recreation Capital Fund (22) The Park and Recreation Capital Fund derives its revenue from monies collected from building permits. The revenue is used to purchase equipment essential in the maintenance of park land and open space. FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projection Adopted Projected Projected Revenue Licenses and Permits 21,650 3,300 2,500 2,000 1,750 1,750 1,750 Investment Earnings - - - 80 80 80 80 Reimbursements - - 15,000 - - - - Miscellaneous 11,822 48,573 - - 1,000 - - Total Revenue 33,472 51,873 17,500 2,080 2,830 1,830 1,830 Expenditures Capital Outlay 51,095 10,773 173,135 24,631 120,000 - - Other Financing Uses - - - - 3,500 2,500 2,500 Total Expenditures 51,095 10,773 173,135 24,631 123,500 2,500 2,500 Surplus (Deficit) (17,623) 41,100 (155,635) (22,551) (120,670) (670) (670) Ending Fund Balance 25,752 66,852 (129,883) 44,301 (76,369) (77,039) (77,709) $100 Fund Balance $so M So r ~ ($so) ($1oo) ($1so) I 77 United City of Yorkville Parks and Recreation Capital Fund 22 PARKS AND RECREATION CAPITAL FUND REVENUE FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Licenses and Permits 22- 000.42 -00 -4215 PARKS CAPITAL FEES 21,650 3,300 2,500 2,000 1,750 1,750 1,750 Total: Licenses and Permits $21,650 $3,300 $2,500 $2,000 $1,750 $1,750 $1,750 Investment Earnings 22 -000 -45- 00-4500 INVESTMENT EARNINGS - - - 80 80 80 80 Total: Investment Earnings $0 $0 $0 $80 $80 $80 $80 Reimbursements 22- 000- 46.00.4690 REIMO - MISCELLANEOUS - - 15,000 - - - - Total: Reimbursements $0 $0 $15,000 $0 $0 $0 $0 MISMIRnenus 22- 000.48 -00 -4845 DONATIONS 11,822 48,573 - - - - - 22- 000-48 -00 -4880 SALE OF FIXED ASSETS - - - - 1,000 - - Total: Miscellaneous $11,822 $48,573 $0 $0 $1,000 $0 $0 Total: PARK & REC CAP REVENUE $33,472 $51,873 $17,500 9M ILM 1 830 1 830 78 United City of Yorkville Parks and Recreation Capital Fund 222 PARKS AND RECREATION CAPITAL EXPENDITURES F%'2009 F] 2010 F1' 2011 FY 2011 FS 2012 FY 2013 FP 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Capitol Oulhy 22- 222 -60- 006011 PARK RE- DEVELOPMENTS 42,273 - - - - - - 22- 222 -60 -00 -6012 CRAWFORD PARK TRAIL - - - 7,200 - - - 22- 222 -60 -00-6035 RAINTREEPARK - 1,700 158,135 1,775 120,000 - - 22- 222 -60- 00.6042 BASEBALL FIELD CONSTRUCTION - - 15,1100 15,656 - - - 22- 222 -60 -00 -6060 EQUIPMENT 8,822 9,073 - - - - - Total: Capitol Oullay $51,095 $10,773 $173,135 $24,631 $120,000 $0 $0 Other Financing Uses 22. 222 -9900 -9921 TRANSFER TO PUBLIC WORKS CAPITAL - - - - 3,500 2,500 2,500 Total: Other Financing Uses $0 $0 $0 $0 $3,500 $2,500 $2,500 Total: PARK & REC CAP EXPENDITURES $51,095 $10,773 $173,135 $24,631 $123,500 2 500 2 500 i lll 79 Police Capital Fund (20) The Police Capital Fund derives its revenue from monies collected from building permits. The revenue is used to purchase vehicles and equipment for use in the operations of the police department. FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projected A Projected Projected Revenue Licenses and Permits 37,200 26,563 31,000 31,000 16,500 16,500 16,500 Fines and Forfeits 5,011 5,683 5,000 5,000 5,000 5,000 5,000 Miscellaneous 3,996 9,551 1,000 7,423 - - - Other Financing Sources - - 25,000 - - - - Total Revenue 46,207 41,796 62,000 43,423 21,500 21,500 21,500 Expenditures Contractual Services 18,948 3,187 21,500 21,750 11,500 11,500 11,500 Supplies 400 910 2,500 2,500 2,500 2,500 2,500 Capital Outlay 48,272 3,266 80,000 62,310 40,000 40,000 40,000 Total Expenditures 67,620 7,364 104,000 86,560 54,000 54,000 54,000 Surplus (Deficit) (21,414) 34,433 (42,000) (43,137) (32,500) (32,500) (32,500) Ending Fund Balance 175,851 210,284 133,851 167,147 134,647 102,147 69,647 N $250 Fund Balance $200 N 'o $150 L $100 $50 $0 I 80 United City of Yorkville Police Capital Fund 20 POLICE CAPITAL FUND REVENUE FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Licenses and Permits 20- 000 -42 -00 -4214 DEVELOPMENT FEES 37,200 19,950 25,000 25,000 10,500 10,500 10,500 20- 000.42 -00 -4217 WEATHER WARNING SIREN FEES - 6,613 6,000 6,000 6,000 6,000 6,000 Total: Licenses and Fees $37,200 $26,563 $31,000 $31,000 $16,500 $16,500 $16,500 Fines and Forfeits 20- 000 -43 -00-4340 IMPOUND FEES 5,011 5,683 5,000 5,000 5,000 5,000 5,000 Total: Fines and Forfeits $5,011 $5,683 $5,000 $5,000 $5,000 $5,000 $5,000 Miscellaneous 20- 000-48 -00 -4845 DONATIONS 2,915 4,381 - 3,923 - - - 20 -000.48 -00-4850 MISCELLANEOUS INCOME - 1,070 - - - - - 20- 000.48 -00-0880 SALE OF FIXED ASSETS 1,081 4,100 1,000 3,500 - - - Total: Miscellaneous $3,996 $9,551 $1,000 $7,423 $0 $0 $0 Other Financing Sources 20- 000 -49 -00-4901 TRANSFER FROM GENERAL - - 25,000 - - - - Total: Other Financing Sources $0 $0 $25,000 $0 $0 $0 $0 Total: POLICE CAPITAL REVENUE $46,207 $41 $62,000 $43,423 $21,500 $21 $21,500 81 United City of Yorkville Police Capital Fund 200 POLICE CAPITAL EXPENDITURES FP 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Contractual Services 20- 200-54 -00 -5462 PROFESSIONAL SERVICES 2.282 3,187 1,500 1,750 1,500 1,500 1,500 Seized Vehicles $1,500 20- 200.54 -00 -5495 OUTSIDE REPAIR AND MAINTENANCE 16,666 - 20.000 20,000 10,000 10,000 10,000 CO! B,,ild OW $10,000 Total: Contractual Services $18,948 $3,187 $21,500 $21,750 $11,500 $11,500 $11,500 Supplies 20- 200 -56- 00.5620 OPERATING SUPPLIES - - 2,500 2,500 2,500 2,500 2,50 K -9 Supplies $2,500 20- 200-56 -00 -5621 SMALL TOOLS & EQUIPMENT 400 910 - - - - - Total: Supplies $400 $910 $2,500 $2,500 $2,500 $2,500 $2,500 Capital Outlay 20- 200-60 -00 -6060 EQUIPMENT 4,127 3,266 40,OW 20,000 20,WO 20,000 20,WO 20.200.60 -W -6070 VEHICLES 44,145 - 40,OW 42,310 20,WO 20,000 20,000 Total: Capital Outlay $48,272 $3,266 $80 $62,310 $40,000 $40,000 $40,000 Total: PD CAPITAL EXPENDITURES $67,620 $104,000 $86,560 $54,000 $54,000 $54,000 i I 82 Public Works Capital Fund (21) The Public Works Capital Fund derives its revenue from monies collected from building permits. The revenue is used to purchase capital items such as vehicles, equipment and property. FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projection Adopted Projected Projected Revenue Licenses and Permits 86,500 47,450 35,000 25,000 24,500 24,500 24,500 Charges for Service - - - 3,942 7,900 7,900 7,900 Miscellaneous 8,000 558 3,283 - - - Other Financing Sources - - - - 3,500 2,500 2,500 Total Revenue 94,500 48,008 35,000 32,225 35,900 34,900 34,900 Expenditures Contractual Services 4,399 4,000 4,000 4,500 6,300 6,300 6,300 Supplies 1,031 - 5,000 1,000 2,000 2,000 2,000 Capital Outlay 400,271 - 46,000 - 2,000 - - Debt Service - 82,295 84,000 82,295 82,295 82,295 82,295 Total Expenditures 405,701 86,295 139,000 87,795 92,595 90,595 90,595 Surplus (Deficit) (311,201) (38,287) (104,000) (55,570) (56,695) (55,695) (55,695) Ending Fund Balance 196,095 157,807 92,095 102,237 45,542 (10,153) (65,848) $300 Fund Balance a m $200 N 7 O F $100 $0 ($100) 83 United City of Yorkville Public Works Capital Fund 21 PUBLIC WORKS CAPITAL FUND REVENUE FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 IT 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Liccoses and Permits 21- 000 -42 -00-4214 DEVELOPMENT FEES 86,500 47,450 35,000 25,000 24,500 24,500 24,500 Total: Licenses and Pemlils $86,500 $47,450 $35,000 $25,000 $24,500 $24,500 $24,500 Charges Far Seni- 21- 000 -44 -00 -4418 MOWING INCOME - - - 3,942 7,900 7,900 7,900 Total: Charges for Services $0 $0 $0 $3,942 $7,900 $7,900 $7,900 Misccllencous 21-000 -48 -00 -4850 MISCELLANEOUS INCOME - 558 - 1,663 - - - 21- OW -48 -00 -4880 SALE OF FIXED ASSETS 8,000 - - 1,620 - - - Total- Miscellaneous $8,000 $558 $0 $3,283 $0 $0 $0 Other Financing Sources 21.000.49 -00 -4922 TRANSFER FROM PARK & REC CAPITAL - - - - 3,500 2,500 2,500 Total: Other Financing Sources $0 $0 $0 $0 $3,500 $2,500 $2,500 Total: PW CAPITAL FUND REVENUE $94,500 $48,008 $35,000 $32,225 $35,900 $34,900 $34,900 II I II 84 United City of Yorkville Public Works Capital Fund 211 PUBLIC WORKS CAPITAL EXPENDITURES FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Descriplion Actual Actual Budget Projected Adopted Projeeled Projected Conlractual Services 21- 211 -54 -00 -5462 PROFESSIONAL SERVICES - - - - 1,800 1,800 1,800 Alouiog Lien Filings $1,800 21- 211 -54 -00 -5485 RENTAL & LEASE PURCHASE 4,399 4,000 4,000 4,500 4,500 4,500 4,500 Tolal: Contractual Services $4,399 $4,000 $4,000 $4,500 $6,300 $6,300 $6,300 Supplies 21- 211 -56.00 -5620 OPERATING SUPPLIES 1,031 - 5,000 1,000 2,000 2,000 2,000 Truck Accessories 52,000 Total: Supplies $1,031 $0 $5,000 $1,000 $2,000 $2,000 $2,000 Capital Outlay 21- 211 -60 -00 -6020 BUILDINGS AND STRUCTURES 354,897 - - - - - - 21- 211 -60 -00 -6060 EQUIPMENT 7,179 - - - 2,000 - - 21- 21160.00.6070 VEHICLES 38,195 - 46,000 - - - - Total: Capital Outlay $400,271 $0 $46,000 $0 $2,000 $0 $0 Debt Service - Public Works Building 21- 211 -92 -00-8000 PRINCIPLEPAYMENT - 24,937 26,544 26,544 28,254 30,074 32,012 21. 211.92 -00-8050 INTEREST PAYMENT - 57,358 57,456 55,751 54,041 52,221 50,283 Pill Building -185 Il'olf Sirecl Total: Debt Service - PW Building $0 $82,295 $84,000 $82,295 $82,295 $82,295 $82,295 Total: PW CAPITAL EXPENDITURES $405,701 $96,295 $139,000 $87,795 $92,595 $90,595 $90,595 i i I I l i I 85 UNITED CITY OF YORKVILLE, ILLINOIS Public Works Capital Fund Long -Term Debt Requirements Adjustable Rate Note - Betzwiser Development, LLC April 30, 2011 Date of Maturity October 1, 2028 Authorized Issue $937,500 Interest Rates Variable A - Recalculated every 60 months at Syr T -Bill rate plus 3% Interest Dates Monthly Principal Maturity Dates Monthly Payable at Betzwiser Development, LLC Propose Purchase of building & land at 185 Wolf Street CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements (Annualized) Fiscal Year Principal Interest Totals 2011 -2012 $ 28,254 $ 54,041 $ 82,295 I 2012-2013 30,074 52,221 82,295 2013-2014 * 32,012 50,283 82,295 2014-2015 34,074 48,221 82,295 2015-2016 36,270 46,025 82,295 2016-2017 38,606 43,689 82,295 2017-2018 41,094 41,201 82,295 2018-2019 * 43,741 38,554 82,295 2019-2020 46,560 35,735 82,295 2020-2021 49,559 32,736 82,295 2021 -2022 52,752 29,543 82,295 2022-2023 56,151 26,144 82,295 2023-2024 * 59,769 22,526 82,295 2024-2025 63,619 18,676 82,295 2025-2026 67,718 14,577 82,295 2026-2027 72,081 10,214 82,295 2027-2028 76,725 5,570 82,295 2028-2029 40,232 880 41,112 $ 869,293 $ 570,835 $ 1,440,127 * Denotes interest rate recalculation on October 1st 2013, 2018 and 2023 A Interest rate is currenthy at 6.26% 86 City -Wide Capital Fund (23) The City -Wide Capital fund is used to maintain existing and construct new public infrastructure, and to fund other improvements that benefit the public. FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projected Adopted Projected Projected Revenue Intergovernmental - - 231,000 65,549 231,000 - - Licenses and Permits 78,100 20,200 28,000 23,000 60,600 60,600 60,600 Reimbursements - 54,600 - - - - - Other Financing Sources 220,000 100,000 162,500 225,800 125,000 - - Total Revenue 298,100 174,800 421,500 314,349 416,600 60,600 60,600 Expenditures Contractual Services - - 25,000 - - - - Capital Outlay 291,278 - 432,500 176,034 235,000 4,000 4,000 Debt Service 100,000 100,000 125,000 125,000 125,000 - - Total Expenditures 391,278 100,000 582,500 301,034 360,000 4,000 4,000 Surplus (Deficit) (93,178) 74,800 (161,000) 13,315 56,600 56,600 56,600 Ending Fund Balance (93,178) (18,378) (254,178) (5,063) 51,537 108,137 164,737 $200 Fund Balance $100 $0 0 IE ($100) ($200) ($300) 87 United City of Yorkville City -Wide Capital Fund 23 CITY-WIDE CAPITAL FUND REVENUE FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Intergovernmental 23- 000 -41 -00 -4170 STATE GRANTS - - 231,000 65,549 231,000 - - DCEO TAP Granl $65,549 F)' 2011 Safe Ric to Sch Grant - Design/Const $231,000 Total: Intergovernmental $0 $0 $231,000 $65,549 $231,000 $0 $0 Licenses and Permits 23- 000 -42 -00 -4210 BUILDING PERMITS - - - - 17,600 17,600 17,600 In Excess of $122,400 from General Fd 23- 000 -42 -00 -4213 ENGINEERING CAPITAL FEE 12,100 6,200 4,000 3,000 3,000 3,000 3,000 23- 000 -42 -00 -4214 DEVELOPMENT FEES - - - - 20,000 20,000 20,000 Aloved from General Fund starling F)'2012 23- 000 -42 -00 -4222 ROAD CONTRIBUTION FEE 66,000 14,000 24,000 20,000 20,000 20,000 20,000 Total: Licenses and Permits $78,100 $20,200 $28,000 $23,000 $60,600 $60,600 $60,600 Reimbursements 23- 000 -46 -00 -4623 ROME - KENNEDY ROAD - 54,600 - - - - - Total: Reimbursements $0 $54,600 $0 $0 $0 $0 $0 Other Financing Sources 23- 000 -49 -00 -4901 TRANSFER FROM GENERAL 220,000 100,000 162,500 129,800 125,000 - - 23- 000 -49 -00 -4915 TRANSFER FROM MOTOR FUEL TAX - - - 96,000 - - - IDOT OM JaiUParking loi Trmesfer - Total: Other Financing Sources $220,000 $100,000 $162,500 $225,800 $125,000 $0 $0 Total: CITY -WIDE CAPITAL REVENUE $298 $174,800 $421 $314,349 $416,600 $60,600 $60,600 88 United City of Yorkville City -Wide Capital Fund 230 CITY -WIDE CAPITAL EXPENDITURES FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Contractual Services 23- 230 -54 -00 -5495 OUTSIDE REPAIR AND MAINTENANCE - - 25,000 - - - - Parbvoy Tree Planting Total: Contractual Services $0 $0 $25,000 $0 $0 $0 $0 Capital Outlay 23- 230 -60 -00 -6010 IMPROVEMENTS NOT TO BUILDINGS 218,208 - - - - - - 23- 230 -60 -00 -6023 OLD JAIL PURCHASE - - - 161,549 - - - 23- 230 -60 -00 -6041 SIDEWALK CONSTRUCTION 2,229 - 87,500 10,485 - - - 23- 230 -60 -00 -6070 VEHICLES - - 4,000 4,000 4,000 4,000 4,000 23- 230 -60 -00 -6078 PALMERCOURT 70,841 - - - - - - 23- 230 -60 -00 -6083 TOWN SQUARE PARK - - 25,000 - - - - 23- 230 -60 -00 -6085 FAXON ROAD - ROW - - 85,000 - - - - 23- 230 -60 -00 -6092 SAFE ROUTE TO SCHOOL PROJECT - - 231,000 231,000 - - Total: Capital Outlay $291,278 $0 $432,500 $176,034 $235,000 $4,000 $4,000 Debt Service - Clark Properly 23- 230 -97 -00 -8000 PRINCIPLE PAYMENT 100,000 100,000 125,000 125,000 125,000 - - Total: Debt Service- Clark Properly $100,000 $100,000 $125,000 $125,000 $125,000 $0 $0 Total: CITY -WIDE CAP EXPENDITURES $391,278 $100,000 $582,500 $301 $360,000 IMN 11m 89 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 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projection Adopted Projected Projected Revenue Taxes - - - - 133,866 133,454 138,041 Charges for Service 2,025,589 1,844,415 2,090,354 2,426,050 2,425,250 2,452,881 2,480,965 Interest Income 26,712 3,204 3,000 1,750 2,000 2,000 2,000 Miscellaneous 29,573 31,410 29,000 36,218 50,000 50,500 51,005 Other Financing Sources 212,236 81,750 - 82,850 83,863 82,288 82,988 Total Revenue 2,294,111 1,960,778 2,122,354 2,546,868 2,694,979 2,721,123 2,754,999 Expenses Salaries 355,864 346,853 373,702 349,304 377,000 377,000 377,000 Benefits 58,812 55,606 59,605 58,005 65,700 65,700 65,700 Contractual Services 460,328 338,647 382,750 385,750 401,850 417,075 433,561 Supplies 404,122 330,605 359,700 330,700 360,300 369,210 379,471 Capital Outlay 325,491 176,448 - - 96,000 256,000 256,000 Contingencies - (66,431) - - - - - Developer Commitments - 114,944 269,856 275,868 275,868 160,923 - Debt Service 608,037 703,053 585,201 834,454 903,277 1,396,016 1,172,802 Other Financing Uses 450,000 75,569 91,863 91,863 91,863 91,863 91,863 Total Expenses 2,662,654 2,075,295 2,122,677 2,325,944 2,571,858 3,133,787 2,776,397 Surplus (Deficit) (368,543) (114,516) (323) 220,924 123,121 (412,664) (21,398) I Ending Fund Balance Equivalent 453,875 339,360 453,552 560,284 683,405 270,741 249,343 24.1% 26.6% 8.6% 9.0% I I N $ 800 Fund Balance Equivalent $600 7 a F $400 $200 $0 90 I FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projection Adopted Projec P Personnel Full -time Personnel: x Public Works Director (50 %) 0.33 0.33 0.33 0.5 0.5 0.5 0.5 Foreman 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Operator 2.0 2.0 2.0 2.0 2.0 2.0 2.0 Maintenance Worker 11 2.0 2.0 2.0 2.0 2.0 2.0 2.0 Utility Billing Clerk (Finance) 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Secretary /Receptionist 1.0 1.0 1.0 0.0 0.0 0.0 0.0 Total Personnel 7.33 7.33 7.33 6.50 6.50 6.50 6.50 Salmo and benefit announts are split equally between Water and Seger Funds 91 United City of Yorkville Water Fund 51 WATER FUND REVENUE FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Taxes 51- 000 -40 -00 -4007 PROPERTY TAXES - 2007A BOND - - - - 133,866 133,454 138,041 Total: Taxes $0 $0 $0 $0 $133,866 $133,454 $138,041 Charges fur Services 51- 000 -44 -00 -4424 WATER SALES 1,640,023 1,591,745 1,286,250 1,650,000 1,674,750 1,699,871 1,725,369 51- 000 -44 -00 -4425 BULK WATER SALES 4,364 879 2,000 1,050 500 510 520 51- 000 -44 -00 -4430 WATER METER SALES 69,762 44,255 32,000 25,000 25,000 26,250 27,563 51- 000 -44 -00 -4440 WATER INFRASTRUCTURE FEE - - 580,104 650,000 600,000 600,000 600,000 51- 000 -44 -00 -4450 WATER CONNECTION FEES 311,440 201,466 190,000 100,000 125,000 126,250 127,513 51- 000 -44 -00 -4473 RECAPTURE FEES - 6,071 - - - - - Total: Charges for Services $2,025,589 $1,844,415 $2,090,354 $2,426,050 $2,425,250 $2,452,881 $2,480,965 Interest Income 51- 000 -45 -00 -4500 INTEREST INCOME 26,712 3,204 3,000 1,750 2,000 2,000 2,000 Total: Interest Income $26,712 $3,204 $3,000 $1,750 $2,000 $2,000 $2,000 Miscellaneous 51- 000 -48 -00 -4822 RENTAL INCOME- WATER TOWER 27,908 27,249 29,000 29,000 50,000 50,500 51,005 51- 000 -48 -00 -4850 MISCELLANEOUS INCOME (1) 471 - 4,318 - - - 51- 000 -48 -00 -4855 BAD DEBT RECOVERY 1,666 3,690 - 2,900 - - - Total: Miscellaneous $29,573 $31,410 $29,000 $36,218 $50,000 $50,500 $51,005 Other Financing Sources 51- 000 -49 -00 -4901 TRANSFER FROM GENERAL 200,000 - - - - - - 51- 000 -49 -00 -4942 TRANSFER FROM DEBT SERVICE 12,236 - - - - - - 51- 000 -49 -00 -4952 TRANSFER FROM SEWER - 81,750 - 82,850 83,863 82,288 82,988 One Half the 2005C Debt Service PAIT Total: Other Financing Sources $212,236 $81,750 $0 $82,850 $83,863 $82,288 $82,988 Total: WATER FUND REVENUE $2,294,111 $1 $2 $2,546,868 $2,694,979 $2,721,123 $2,754,999 92 United City of Yorkville Water Fund 510 WATER OPERATIONS FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Salaries 51- 510 -50 -00 -5010 SALARIES AND WAGES 341,537 343,217 358,702 341,304 365,000 365,000 365,000 51- 510 -50 -00-5015 PART -TIME SALARIES 3,582 - - - - - - 51- 510 -50 -00-5020 OVERTIME 10,745 3,636 15,000 8,000 12,000 12,000 12,000 Total: Salaries $355,864 $346,853 $373,702 $349,304 $377,000 $377,000 $377,000 Benefits 51- 510 -52.00-5212 RETIREMENT PLAN CONTRIBUTION 29,793 29,845 31,017 32,005 37,500 37,500 37,500 51- 510 -52 -00-5214 FICA CONTRIBUTION 29,020 25,761 28,588 26,000 28,200 28,200 28,200 Total: Benefits $58,812 $55,606 $59,605 $58,005 $65,700 $65,700 $65,700 Contractual Services 51- 510 -54 -00-5412 TRAINING &CONFERENCES 2,402 824 1,600 2,000 2,000 2,000 2,000 51- 510 -54 -00-5415 TRAVEL AND LODGING 786 1,594 1,600 1,000 1,600 1,600 1,600 51- 510 -54 -00-5426 PUBLISHING & ADVERTISING 37 - 500 1,000 1,000 1,000 1,000 51- 510 -54 -00-5429 WATER SAMPLES 13,143 2,332 14,000 14,000 14,000 14,000 14,000 51- 510 -54 -00-5430 PRINTING AND DUPLICATING 2,269 2,319 2,500 2,500 2,500 2,500 2,500 51- 510 -54 -00-5440 TELECOMMUNICATIONS 24,596 25,827 25,300 24,500 24,500 24,500 24,500 Telephone $22,000 Cell Phone $2,500 51- 510 -54 -00-5452 POSTAGE & SHIPPING 16,710 16,030 22,000 22,000 22,000 22,000 22,000 51- 510 -5400-5460 DUES AND SUBSCRIPTIONS 808 788 1,250 1,250 1,250 1,250 1,250 51- 510 -54 -00-5462 PROFESSIONAL SERVICES 27,547 3,387 6,000 6,000 6,000 6,000 6,000 51- 510 -54 -00-5466 LEGAL SERVICES - - 2,000 2,000 2,000 2,000 2,000 51- 510 -54 -00 -5480 UTILITIES 354,272 276,289 290,000 290,000 304,500 319,725 335,711 Electrici y $304,500 51- 510 -54 -00-5483 JULIE SERVICES 3,727 2,979 6,000 3,500 3,500 3,500 4,000 51- 510 -54 -00-5485 RENTAL & LEASE PURCHASE 233 - 1,000 1,000 1,000 1,000 1,000 51- 510 -5400-5495 OUTSIDE REPAIR AND MAINTENANCE 13,798 6,279 9,000 9,000 10,000 10,000 10,000 Maintenance - Vehicles $10,00 51- 510 -54 -00 -5499 BAD DEBT - - - 6,000 6,000 6,000 6,000 Utilil. Lulling $6,000 Total: Contractual Services $460,328 $338,647 $382,750 $385,750 $401,850 $417,075 $433,561 Supplies 51- 510 -56 -00-5600 WEARING APPAREL 2,155 2,391 3,500 2,000 5,000 4,000 4,000 51- 510 -56 -00-5620 OPERATING SUPPLIES 48,367 18,788 34,500 20,000 20,500 21,425 22,396 Operating Supplies $18,500 Grarel $2,000 51- 510 -56 -00-5630 SMALL TOOLS & EQUIPMENT 782 1,093 2,000 2,000 2,000 2,000 2,000 Nand Tools $1,000 SafelP Egaipmen1 $1,000 51- 510 -56 -00-5635 COMPUTER EQUIPMENT & SOFTWARE 1,320 - 1,200 1,200 1,600 1,600 1,600 51- 510 -56 -00-5638 TREATMENT FACILITY SUPPLIES 210,951 227,523 230,000 230,000 240,000 247,200 254,616 Treatment Paeililies -Op & Afaint $240,000 51- 510 -56 -00-5640 REPAIR AND MAINTENANCE 7,156 3,284 8,500 8,500 9,500 9,500 9,500 Maintenance - Equipment $9,000 Maintenance - Computers $500 51- 510 -56 -00-5664 METERS AND PARTS 98,676 51,393 46,000 33,000 46,000 46,000 46,000 ALelers and Pam 540,000 Nvdrant Replacement $6,000 93 United City of Yorkville Water Fund 510 WATER OPERATIONS FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected 51- 510 -56 -00 -5695 GASOLINE 34,324 26,134 34,000 34,000 35,700 37,485 39,359 51- 510 -56 -00 -5699 MISCELLANEOUS 390 - - - - - - Total: Supplies $404,122 $330,605 $359,700 $330,700 $360,300 $369,210 $379,471 Capital Outlay 51- 510 -60 -00 -6010 IMPROVEMENTS NOT TO BUILDINGS 320,186 176,448 - - - - - 51- 510 -60 -00 -6040 IN -TOWN ROAD PROJECT 5,305 - - - - - - 51- 510 -60 -00 -6079 ROUTE 47 EXPANSION - - - - 96,000 256,000 256,000 Total: Capital Outlay $325,491 $176,448 $0 $0 $96,000 $256,000 $256,000 Contingencies 51- 510 -70 -00 -7799 CONTINGENCIES - (66,431) - - - - - Total: Contingencies $0 ($66,431) $0 $0 $0 $0 $0 Developer Commitments 51- 510 -75 -00 -7502 GRANDE RESERVE COURT ORDER - 114,944 269,856 275,868 275,868 160,923 - Total: Developer Commitments $0 $114,944 $269,856 $275,868 $275,868 $160,923 $0 Debt Service - 2007A Bond 51- 510 -83 -00 -8000 PRINCIPLE PAYMENT 10,000 10,000 - 10,000 10,000 10,000 15,000 51- 510 -83 -00 -8050 INTERESTPAYMENT 124,841 124,666 - 124,266 123,866 123,454 123,041 Total: Debt Service - 2007A Bond $134,841 $134,666 $0 $134,266 $133,866 $133,454 $138,041 Debt Service - 2002 Capital Appreciation Debt Certificates 51- 510 -85 -00 -8000 PRINCIPLE PAYMENT 60,1100 145,000 215,ODO 215,000 285,000 365,000 - 51- 510 -85 -00 -8050 INTEREST PAYMENT - - - - - - - Total: Debt Service -2002 Cap Apprec $60,000 $145,000 $215,000 $215,000 $285,000 $365,000 $0 Debt Service - 2003 Debt Certificates 51- 510 -86 -00-8000 PRINCIPLE PAYMENT - - - - - - 100,000 51- 510 -86 -00 -8050 INTEREST PAYMENT 33,150 33,150 - 33,150 33,150 33,150 33,150 Total: Debt Service - 2003 Debt Certificate $33,150 $33,150 $0 $33,150 $33,150 $33,150 $133,150 Debt Service - 2006A Refunding Debt Certificates 51- 510 -87 -00 -8000 PRINCIPLE PAYMENT 10,000 10,000 70,000 70,000 70,000 355,000 405,000 51- 510 -87- 00.8050 INTERESTPAYMENT 92,106 91,706 91,307 91,306 88,506 219,806 205,606 Total: Debt Service- 2006A Refunding $102,106 $101,706 $161,307 $161,306 $158,506 $574,806 $610,606 Debt Service - 2005C Bond 51- 510 -88 -00 -8000 PRINCIPLE PAYMENT 80,000 80,000 80,000 85,000 90,000 90,000 95,000 51- 510 -88 -00 -8050 INTEREST PAYMENT 86,300 83,500 3,863 80,700 77,725 74,575 70,975 Total: Debt Service - 2005C Bond $166,300 $163,500 $83,863 $165,700 $167,725 $164,575 $165,975 Debt Service - IEPA Loan L17- 156300 51- 510 -89 -00 -8000 PRINCIPLE PAYMENT 68,947 81,451 83,500 83,500 85,600 87,754 89,961 51- 510 -89 -00 -8050 INTERESTPAYMENT 42,693 43,580 41,531 41,531 39,430 37,277 35,069 Total: Debt Service - IL EPA Loan 156300 $111,640 $125,030 $125,031 $125,031 $125,030 $125,031 $125,030 94 United City of Yorkville Water Fund 510 RATER OPERATIONS FY 2009 FY 2010 FY 2011 FY 2011 FT 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Other Financing Uses 51- 510 -99 -00 -9901 TRANSFER TO GENERAL 450,000 75,569 91,863 91,863 91,863 91,863 91,863 Total: Other Financing Uses $450,000 $75,569 $91,863 $91,863 $91,863 $91,863 $91,863 Total: RATER OPERATIONS $2,662,654 $2,075,295 $2 $2,325,944 $2,571,858 $3,133,787 $2,776,397 95 UNITED CITY OF YORKVILLE, ILLINOIS Water Fund Long -Term Debt Requirements Total Water Fund Debt Outstanding at April 30, 2011 TOTAL WATER FUND - OUTSTANDING DEBT Fiscal Years 2012 - 2027 CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Fiscal Year Principal Interest Totals 2011 -2012 $ 816,468 $ 362,677 $ 1,179,145 2012-2013 $ 1,068,677 $ 488,261 1,556,938 2013-2014 $ 704,961 $ 467,841 1,172,802 2014-2015 $ 727,224 $ 441,160 1,168,384 2015-2016 $ 749,544 $ 413,510 1,163,054 2016-2017 $ 781,923 $ 384,901 1,166,824 2017-2018 $ 799,361 $ 354,876 1,154,236 2018-2019 $ 1,031,860 $ 324,089 1,355,949 2019-2020 $ 1,754,423 $ 283,239 2,037,661 2020-2021 $ 1,782,050 $ 209,412 1,991,461 2021-2022 $ 1,359,743 $ 134,331 1,494,074 2022-2023 $ 1,257,503 $ 77,246 1,334,749 2023-2024 $ 265,333 $ 26,197 291,530 2024-2025 $ 268,235 $ 15,045 283,280 2025-2026 $ 121,209 $ 3,821 125,030 2026-2027 $ 61,744 $ 772 62,515 $ 13,550,257 $ 3,987,377 $ 17,537,634 96 UNITED CITY OF Y ORKVILLE, ILLINOIS Water Fund Developer Cmmnitment Grande Reserve Court Order Outstanding at April 30, 2011 Monthly Payment $22,989 Months Remaining 19 Payable to RI Waterman Properties Purpose Rebate of Fees CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Interest Due on Fiscal Year Principal Interest Totals June 30th Amount Dec 30th Amount 2011 -2012 $ 275,868 $ $ 275,868 2011 $ 2011 $ 2012-2013 160,923 160,923 2012 2012 $ 436,791 $ $ 436,791 $ $ 97 UNITED CITY OF YORKVILLE, ILLINOIS Water Fund Long -Term Debt Requirements General Obligation Bond Series 2007A Refunding Outstanding at April 30, 2011 Date of Maturity December 30, 2022 Authorized Issue $3,020,000 Interest Rates 4.0%-4.25% Interest Dates June 301h and December 301h Principal Maturity Dates December 30th Payable at The Bank of New York Trust Company Purpose Road Improvement Program CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Interest Due on Fiscal Year Principal Interest Totals June 30th Amount Dec 30th Amount 2011 -2012 $ 10,000 $ 123,866 $ 133,866 2011 $ 61,933 2011 $ 61,933 2012-2013 10,000 123,454 133,454 2012 61,727 2012 61,727 2013-2014 15,000 123,041 138,041 2013 61,521 2013 61,521 2014-2015 15,000 122,423 137,423 2014 61,211 2014 61,211 2015 -2016 15,000 121,793 136,793 2015 60,896 2015 60,896 2016 -2017 15,000 121,163 136,163 2016 60,581 2016 60,581 2017-2018 15,000 120,525 135,525 2017 60,263 2017 60,263 2018 -2019 15,000 119,888 134,888 2018 59,944 2018 59,944 2019-2020 680,000 119,250 799,250 2019 59,625 2019 59,625 2020 -2021 695,000 90,350 785,350 2020 45,175 2020 45,175 2021-2022 725,000 60,813 785,813 2021 30,406 2021 30,406 2022-2023 750,000 30,000 780,000 2022 15,000 2022 15,000 $ 2,960,000 $ 1, 276,564 $ 4,236,564 $ 638,282 $ 638,282 98 UNITED CITY OF YORKVILLE, ILLINOIS Water Fund Long -Term Debt Requirements Series 2002 Capital Appreciation Debt Certificates Outstanding at April 30, 2011 Date of Maturity May 1, 2012 Authorized Issue $2,899,365 Interest Rates 2.50% - 4.50% Interest Dates Interest is Accreted Principal Maturity Dates May 1 st Payable at The Bank of New York Trust Company Project North Water Tower CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS I Debt Service Requirements Interest Accretes* to Principal on May 1st Fiscal Year Principal Accreted Interest* Totals May 1st Accretion Amount 2011-2012 $ 285,000 $ 15,888 $ 285,000 2011 $ 15,888 2012-2013 365,000 - 365,000 $ 650,000 $ 15,888 $ 650,000 $ 15,888 Accreted Value at April 30, 2011 $ 634,112 * Interest is not paid but rather accretes (accrues) to principal each May 1 st. Fiscal Year 2011 - 2012 Principal Payment $ (285,000) Fiscal Year 2011 - 2012 Interest Accretion 15,888 Fiscal Year 2011 - 2012 Ending Balance $ 365,000 Fiscal Year 2012 - 2013 Principal Payment (365,000) Fiscal Year 2012 - 2013 Ending Balance $ 99 UNITED CITY OF YORKVILLE, ILLINOIS Water Fund Long -Tenn Debt Requirements Series 2003 Debt Certificates Outstanding at April 30, 2011 Date of Maturity December 15, 2018 Authorized Issue $4,800,000 Interest Rates 3.80% - 4.35% Interest Dates June 151h and December 15th Principal Maturity Dates December 15th Payable at BNY Midwest Trust Company Purpose Radium Compliance CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Interest Due on Fiscal Year Principal Interest Totals June 15th Amount Dec 15th Amount 2011 -2012 $ $ 33,150 $ 33,150 2011 $ 16,575 2011 $ 16,575 2012 -2013 33,150 33,150 2012 16,575 2012 16,575 2013 -2014 100,000 33,150 133,150 2013 16,575 2013 16,575 2014-2015 100,000 29,350 129,350 2014 14,675 2014 14,675 2015-2016 100,000 25,450 125,450 2015 12,725 2015 12,725 2016-2017 100,000 21,450 121,450 2016 10,725 2016 10,725 2017 -2018 100,000 17,300 117,300 2017 8,650 2017 8,650 2018 -2019 300,000 13,050 313,050 2018 6,525 2018 6,525 $ 800,000 $ 206,050 $ 1,006,050 $ 103,025 $ 103,025 I i 100 i i UNITED CITY OF Y ORKVILLE, ILLINOIS Water Fund Long -Term Debt Requirements Series 2006A Refunding Debt Certificates Outstanding at April 30, 2011 Date of Maturity December 30, 2022 Authorized Issue $5,555,000 Interest Rates 4.00% - 4.20% Interest Dates June 30th and December 30th Principal Maturity Dates December 30th Payable at The Bank of New York Trust Company Purpose Refunded Portions of 2002 Capital Appreciation, 2002A and 2003 Debt Certificates CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Interest Due on Fiscal Year Principal Interest Totals June 30th Amount Dec 30th Amount 2011 -2012 $ 70,000 $ 88,506 $ 158,506 2011 $ 44,253 2011 $ 44,253 2012-2013 355,000 219,806 574,806 2012 109,903 2012 109,903 2013 -2014 405,000 205,606 610,606 2013 102,803 2013 102,803 2014-2015 420,000 189,406 609,406 2014 94,703 2014 94,703 2015 -2016 435,000 172,606 607,606 2015 86,303 2015 86,303 2016-2017 460,000 155,206 615,206 2016 77,603 2016 77,603 2017-2018 475,000 136,806 611,806 2017 68,403 2017 68,403 2018-2019 495,000 117,806 612,806 2018 58,903 2018 58,903 2019-2020 850,000 98,006 948,006 2019 49,003 2019 49,003 2020 -2021 850,000 62,306 912,306 2020 31,153 2020 31,153 2021-2022 390,000 26,606 416,606 2021 13,303 2021 13,303 2022 -2023 255,000 10,519 265,519 2022 5,260 2022 5,260 $ 5,460,000 $ 1 ,483,187 $ 6,943,187 $ 741,594 $ 741,594 I I I I 101 UNITED CITY OF YORKVILLE, ILLINOIS Water Fund Lang -Term Debt Requirements General Obligation Bond Series 2005C Outstanding at April 30, 2011 Date of Maturity December 30, 2024 Authorized Issue $2,000,000 Interest Rates 3.50 % - 5.50% Interest Dates June 30th and December 30th Principal Maturity Dates December 30th Payable at BNY Midwest Trust Company Purpose Improvements to Water Distribution System - Mill St, Van Emmon Rd CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Interest Due on Fiscal Year Principal Interest Totals June 30th Amount Dec 30th Amount 2011-2012 $ 90,000 $ 77,725 $ 167,725 2011 $ 38,863 2011 $ 38,863 2012-2013 90,000 74,575 164,575 2012 37,288 2012 37,288 2013-2014 95,000 70,975 165,975 2013 35,488 2013 35,488 2014 -2015 100,000 67,175 167,175 2014 33,588 2014 33,588 2015 -2016 105,000 63,175 168,175 2015 31,588 2015 31,588 2016-2017 110,000 58,975 168,975 2016 29,488 2016 29,488 2017-2018 110,000 54,575 164,575 2017 27,288 2017 27,288 2018 -2019 120,000 50,175 170,175 2018 25,088 2018 25,088 2019-2020 120,000 45,375 165,375 2019 22,688 2019 22,688 2020-2021 130,000 38,775 168,775 2020 19,388 2020 19,388 2021 -2022 135,000 31,625 166,625 2021 15,813 2021 15,813 2022 -2023 140,000 24,200 164,200 2022 12,100 2022 12,100 2023-2024 150,000 16,500 166,500 2023 8,250 2023 8,250 2024 -2025 150,000 8,250 158,250 2024 4,125 2024 4,125 $ 1,645,000 $ 682,075 $ 2,327,075 $ 341,038 $ 341,038 * The Sewer Fund has reimbursed the Water Fund for one -half the cost of debt service in the form of a interfund transfer in fiscal years 2010 and 2011. 102 UNITED CITY OF Y ORKVILLE, ILLINOIS Water Fund Long -Term Debt Requirements IEPA Loan L17 - 156300 Outstanding at April 30, 2011 Date of Maturity August 9, 2026 Authorized Issue $1,886,000 Interest Rate 2.500% Interest Dates August 9th and February 9th Principal Maturity Dates August 9th and February 9th Payable at Illinois Environmental Protection Agency Purpose Drinking Water Loan CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Interest Due on Fiscal Year Principal Interest Totals Aug 9th Amount Feb 9th Amount 2011-2012 $ 85,600 $ 39,430 $ 125,030 2011 $ 19,981 2012 $ 19,449 2012-2013 87,754 37,277 125,030 2012 18,911 2013 18,366 2013-2014 89,961 35,069 125,030 2013 17,814 2014 17,255 2014 -2015 92,224 32,806 125,030 2014 16,689 2015 16,117 2015 -2016 94,544 30,486 125,030 2015 15,537 2016 14,949 2016-2017 96,923 28,108 125,030 2016 14,355 2017 13,753 2017-2018 99,361 25,669 125,030 2017 13,143 2018 12,526 2018 -2019 101,860 23,170 125,030 2018 11,901 2019 11,269 2019-2020 104,423 20,607 125,030 2019 10,628 2020 9,979 2020 -2021 107,050 17,981 125,030 2020 9,323 2021 8,658 2021-2022 109,743 15,288 125,030 2021 7,985 2022 7,303 2022-2023 112,503 12,527 125,030 2022 6,613 2023 5,914 2023-2024 115,333 9,697 125,030 2023 5,207 2024 4,490 2024 -2025 118,235 6,795 125,030 2024 3,765 2025 3,030 2025 -2026 121,209 3,821 125,030 2025 2,287 2026 1,534 2026-2027 61,744 772 62,515 2026 772 2027 - $ 1,598,466 $ 339,501 $ 1,937,967 $ 174,909 $ 164,592 Il i I 103 �I 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 2011 I FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projected Adopted Projected Projected Revenue Taxes - - - - 1,754,690 2,318,390 2,456,890 Charges for Service 1,028,070 1,985,308 880,000 1,425,038 1,349,000 1,363,380 1,078,048 Interest Income 25,556 2,173 1,800 1,800 1,800 1,800 1,800 Reimbursements - 5,708 - 3,379 - - - Other Financing Sources 150,000 - - - - - - Total Revenue 1,203,626 1,993,189 881,800 1,430,217 3,105,490 3,683,570 3,536,738 Expenses Salaries 185,661 265,944 263,796 244,000 258,000 258,000 258,000 Benefits 26,486 40,633 42,179 40,875 45,230 45,230 45,230 Contractual Services 35,902 26,021 42,300 42,300 52,800 54,800 56,900 Supplies 68,670 47,162 78,300 91,477 81,500 82,865 84,298 Capital Outlay - - - - 24,600 65,600 65,600 Contingencies - 18,356 - - - - - Developer Commitments 550,735 30,996 - 30,996 30,996 30,996 30,996 Debt Service 1,212,983 1,245,736 1,510,813 1,252,596 2,259,955 2,824,406 2,919,039 Other Financing Uses 207,765 140,390 83,045 165,895 166,908 165,333 166,033 Total Expenses 2,288,201 1,815,238 2,020,433 1,868,139 2,919,989 3,527,230 3,626,096 Surplus (Deficit) (1,084,575) 177,951 (1,138,633) (437,922) 185,501 156,340 (89,358) Ending Fund Balance Equivalent 2,557,262 2,735,211 1,418,629 2,297,289 2,482,790 2,639,130 2,549,772 123.0% 85.0% 74.8% 70.3% $3,000 Fund Balance Equivalent $2,500 $2,000 s F $1,500 $1,000 $500 $0 I Personnel Full -time Personnel: * Public Works Director (50 %) 0.33 0.33 0.33 0.5 0.5 0.5 0.5 Foreman 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Engineering Tech (Eng Dept) 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Maintenance Worker 2.0 2.0 2.0 2.0 2.0 2.0 2.0 Total Personnel 4.33 4.33 4.33 4.50 4.50 4.50 4.50 * Salary and benefit amounts are split egualhv between Water and Seger Funds 104 United City of Yorkville Sewer Fund 52 SEWER FUND REVENUE FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Taxes 52- 000 -40 -00 -4009 PROPERTY TAXES - 2004B BOND - - - - 258,650 263,850 368,750 52- 000 -40 -00 -4013 PROPERTY TAXES - 2005D BOND - - - - 1,385,950 1,944,450 1,978,050 52- 000 -40 -00 -4014 PROPERTY TAXES - 2008 BOND - - - - 110,090 110,090 110,090 Total: Taxes $0 $0 $0 $0 $1,754,690 $2,318,390 $2,456,890 Charges for Services 52- 000 -44 -00 -4435 SEWER MAINTENANCE FEES 712,331 723,012 580,000 700,000 714,000 728,280 742,846 52- 000 -44 -00 -4455 SW CONNECTION FEES - OPERATIONS 69,950 23,400 25,000 3,400 5,000 5,100 5,202 52- 000 -44 -00 -4456 SW CONNECTION FEES - CAPITAL 238,138 60,400 175,000 23,400 30,000 30,000 30,000 52- 000 -44 -00 -4457 SW CONNECTION FEES - ROB ROY - 1,176,889 100,000 698,000 600,000 600,000 - 52- 000 -44 -00 -4460 SEWER INFRASTRUCTURE FEES - - - - - - 300,000 52- 000 -44 -00 -4465 RIVER CROSSING FEES 151 - - 238 - - - 52- 000 -44 -00 -4466 LIFT STATION INCOME 7,500 (7,499) - - - - - 52- 000 -44 -00 -4473 RECAPTUREFEES - 9,106 - - - - - Total: Charges for Services $1,028,070 $1,985,308 $880,000 $1,425,038 $1,349,000 $1,363,380 $1,078,048 Interest Income 52- 000 -45 -00 -4500 INTERESTINCOME 25,556 2,173 1,800 1,800 1,800 1,800 1,800 Total: Interest Income $25,556 $2,173 $1,800 $1,800 $1,800 $1,800 $1,800 Reimbursements 52- 000 -46 -00 -4690 REIMB - MISCELLANEOUS - 5,708 - 3,379 - - - Total: Reimbursements $0 $5,708 $0 $3,379 $0 $0 $0 Other Financing Sources 52- 000 -49 -00 -4901 TRANSFER FROM GENERAL 150,000 - - - - - - Total: Other Financing Sources $150,000 $0 $0 $0 $0 $0 $0 Total: SEWER FUND REVENUE $1,203,626 $1 $881 $1 $3 $3,683,570 $3,536,738 I 105 United City of Yorkville Sewer Fund 520 SEWER OPERATIONS FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Salaries 52- 520 -50 -00 -5010 SALARIES AND WAGES 182,921 265,495 256,296 242,000 256,000 256,000 256,000 52- 520 -50 -00 -5020 OVERTIME 2,740 449 7,500 2,000 2,000 2,000 2,000 Total: Salaries $185,661 $265,944 $263,796 $244,000 $258,000 $258,000 $258,000 Benefits 52- 520 -52 -00 -5212 RETIREMENT PLAN CONTRIBUTION 13,552 21,340 21,949 22,300 25,000 25,000 25,000 52- 520 -52 -00 -5214 FICA CONTRIBUTION 12,934 19,293 20,230 18,575 20,230 20,230 20,230 Total: Benefits $26,486 $40,633 $42,179 $40,875 $45,230 $45,230 $45,230 Contractual Services 52- 520 -54 -00 -5412 TRAINING & CONFERENCES 733 - 500 500 500 500 500 52- 520 -54 -00 -5415 TRAVEL AND LODGING - - 500 500 500 500 500 52- 520 -54 -00 -5440 TELECOMMUNICATIONS 1,525 1,282 1,800 1,800 1,800 1,800 1,800 Cell plmne $1,800 52- 520 -54 -00 -5462 PROFESSIONAL SERVICES 2,623 4,408 4,500 4,500 5,000 5,000 5,000 52- 520 -54 -00 -5480 UTILITIES 29,342 13,607 30,000 30,000 40,000 42,000 44,100 Electricity $40,000 52- 520 -54 -00 -5485 RENTAL &LEASE PURCHASE - - 1,000 1,000 1,000 1,000 1,000 52- 520 -54 -00 -5495 OUTSIDE REPAIR AND MAINTENANCE 1,678 6,725 4,000 4,000 4,000 4,000 4,000 Maintenance - Vehicles $4,000 Total: Contractual Services $35,902 $26,021 $42,300 $42,300 $52,800 $54,800 $56,900 Supplies 52- 520 -56 -00 -5600 WEARINGAPPAREL 2,156 1,683 2,500 1,800 2,500 2,500 2,500 52- 520 -56 -00 -5610 OFFICE SUPPLIES 937 1,565 1,800 1,800 2,000 2,000 2,000 52- 520 -56 -00 -5613 LIFT STATION MAINTENANCE 22,972 7,714 15,000 15,000 15,000 15,000 15,000 52- 520 -56 -00 -5620 OPERATING SUPPLIES 1,864 1,879 4,500 3,000 4,500 4,500 4,500 Shop Supplies $2,500 Gravel $2,000 52- 520 -56 -00 -5630 SMALL TOOLS & EQUIPMENT 1,007 641 2,500 2,500 2,500 2,500 2,500 Safely Equipmen( $1,000 Hand Tools $1,000 Office Equipment $500 52- 520 -56 -00 -5635 COMPUTER EQUIPMENT & SOFTWARE 135 - 1,000 1,000 1,200 1,200 1,200 52- 520 -56 -00 -5640 REPAIR AND MAINTENANCE 5,676 7,611 25,000 25,000 25,000 25,000 25,000 Maintenance - Equipment $5,000 Alainlenance - Sanirmy Setrer $20,000 52- 520 -56 -00 -5695 GASOLINE 33,923 26,069 26,000 26,000 27,300 28,665 30,098 52- 520 -56 -00 -5699 BAD DEBT - - - 15,377 1,500 1,500 1,500 Bad Debt ARO - FY 2011 $13,877 Utility Billing $1,500 FY 2011 & 2012 Total: Supplies $68,670 $47,162 $78,300 $91,477 $81,500 $82,865 $84,298 Capital Outlay 52- 520 -60 -00 -6079 ROUTE 47 EXPANSION - - - - 24,600 65,600 65,600 Total: Capital Outlay $0 $0 $0 $0 $24,600 $65,600 $65,600 Contingencies 52- 520 -70 -00 -7799 CONTINGENCIES - 18,356 - - - - - Total: Contingencies $0 $18,356 $0 $0 $0 $0 $0 106 United City of Yorkville Sewer Fund 520 SEWER OPERATIONS FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Developer Commitments 52- 520 -75 -00 -7500 LENNAR- RAINTREE SEWER RECPATURE 550,735 30,996 - 30,996 30,996 30,996 30,996 Total: Developer Commitments $550,735 $30,996 $0 $30,996 $30,996 $30,996 $30,996 Debt Service - 2007A Bond 52- 520 -83 -00 -8000 PRINCIPLE PAYMENT - - 10,000 - - - - 52- 520 -83 -00 -8050 INTEREST PAYMENT - - 123,866 - - - - Total: Debt Service - 2007A Bond $0 $0 $133,866 $0 $0 $0 $0 Debt Service - 2004B Bond 52- 520 -84 -00 -8000 PRINCIPLE PAYMENT 140,000 145,000 155,000 155,000 160,000 170,000 280,000 52- 520 -84 -00 -8050 INTERESTPAYMENT 111,138 107,288 103,300 103,300 98,650 93,850 88,750 Total: Debt Service - 2004B Bond $251,138 $252,288 $258,300 $258,300 $258,650 $263,850 $368,750 Debt Service - 2005C Bond 52- 520 -88 -00 -8000 PRINCIPLE PAYMENT - - - - - - - 52- 520 -88 -00 -8050 INTEREST PAYMENT - - 82,850 - - - - Total: Debt Service - 2005C Band $0 $0 $82,850 $0 $0 $0 $0 Debt Service - 20031RBB Debt Certificates 52- 520 -90 -00 -8000 PRINCIPLE PAYMENT 85,000 85,000 90,000 90,000 95,000 100,000 100,000 52- 520 -90 -00 -8050 INTERESTPAYMENT 77,504 76,713 73,653 73,653 70,143 66,248 62,048 Total: Debt Service - 2003IRBB $162,504 $161,713 $163,653 $163,653 $165,143 $166,248 $162,048 Debt Service - 2004A Bond 52- 520 -91 -00 -8000 PRINCIPLE PAYMENT 150,000 155,000 160,000 160,000 170,000 175,000 180,000 52- 520 -91 -00 -8050 INTERESTPAYMENT 35,975 32,525 28,572 28,573 24,093 18,738 13,050 Total: Debt Service -2004A Bond $185,975 $187,525 $188,572 $188,573 $194,093 $193,738 $193,050 Debt Service - 2005D Bond 52- 520 -93 -00 -8000 PRINCIPLE PAYMENT - - - - 1,000,000 1,600,000 1,700,000 52- 520 -93 -00 -8050 INTEREST PAYMENT 467,336 385,950 427,451 385,950 385,950 344,450 278,050 Total: Debt Service -2005D Bond $467,336 $385,950 $427,451 $385,950 $1,385,950 $1,944,450 $1,978,050 Debt Service - 2008 Refunding Bond 52- 520 -94 -00 -8000 PRINCIPLE PAYMENT - - - - - - - 52- 520 -94 -00 -8050 INTEREST PAYMENT - 112,231 110,090 110,090 110,090 110,090 110,090 Total: Debt Service -2008 Refunding $0 $112,231 $110,090 $110,090 $110,090 $110 $110,090 Debt Service - IEPA Loan L17- 013000 52- 520 -95 -00 -8000 PRINCIPLE PAYMENT 32,935 34,125 35,358 35,357 36,635 37,958 - 52- 520 -95 -00 -8050 INTEREST PAYMENT 6,045 4,855 3,622 3,623 2,344 1,022 - Total: Debt Service - IEPA Loan 013000 $38,980 $38,980 $38,980 $38,980 $38,979 $38,980 $0 Debt Service - IEPA Loan L17- 115300 52- 520 -96 -00 -8000 PRINCIPLE PAYMENT 79,833 81,942 84,107 84,107 86,329 88,610 90,952 52- 520 -96 -00 -8050 INTERESTPAYMENT 27,218 25,109 22,944 22,944 20,721 18,440 16,099 Total: DebtService - IEPA Loan 115300 $107,051 $107,051 $107,051 $107,051 $107,050 $107,050 $107,051 107 United City of Yorkville Sewer Fund 520 SEWER OPERATIONS FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014�, Account Description Actual Actual Budget Projected Adopted Projected Projected Other Financing Uses 52- 520 -99 -00 -9901 TRANSFER TO GENERAL 220,000 58,640 83,045 83,045 83,045 83,045 83,045 52- 520 -99 -00 -9942 TRANSFER TO DEBT SERVICE (12,235) - - - - - -, 52- 520 -99 -00 -9952 TRANSFER TO WATER - 81,750 - 82,850 83,863 82,288 82,988 One Half Nie 2005C Debt Seroice Pd9T Total: Other Financing Uses $207,765 $140,390 $83,045 $165,895 $166,908 $165,333 $166,033 Total: SEWER OPERATIONS $2,288,201 $1,815,238 $2,020,433 $1 $2,919,989 $3,527,230 $3,626,096 I 108 UNITED CITY OF YORKVILLE, ILLINOIS Sewer Fund Long -Term Debt Requirements Total Sewer Fund Debt Outstanding at April 30, 2011 TOTAL SEWER FUND - OUTSTANDING DEBT Fiscal Years 2012 - 2023 CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Fiscal Year Principal Interest Totals 2011-2012 $ 1,547,964 $ 711,992 $ 2,259,956 2012-2013 $ 2,171,568 $ 652,838 2,824,406 2013-2014 $ 2,350,952 $ 568,087 2,919,038 2014-2015 $ 2,763,355 $ 474,723 3,238,078 2015-2016 $ 3,600,821 $ 364,514 3,965,336 2016-2017 $ 1,608,353 $ 218,542 1,826,896 2017-2018 $ 1,690,952 $ 140,399 1,831,351 2018-2019 $ 688,619 $ 57,864 746,483 2019-2020 $ 187,832 $ 30,361 218,193 2020-2021 $ 140,000 $ 22,850 162,850 2021-2022 $ 150,000 $ 15,710 165,710 2022-2023 $ 155,000 $ 8,060 163,060 $ 17,055,417 $ 3,265,941 $ 20,321,357 109 UNITED CITY OF YORKVILLE, ILLINOIS Sewer Fund Long -Term Debt Requirements Alternate Revenue Source Bond Series 2004B Outstanding at April 30, 2011 i Date of Maturity December 30, 2018 Authorized Issue $3,500,000 Interest Rates 2.50% - 4.00 % Interest Dates June 30th and December 30th Principal Maturity Dates December 30th Payable at BNY Midwest Trust Company Propose Provide Sanitary Sewer to Autumn Creek Subdivision CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Interest Due on Fiscal Year Principal Interest Totals June 30th Amount Dec 30th Amount 2011 -2012 $ 160,000 $ 98,650 $ 258,650 2011 $ 49,325 2011 $ 49,325 2012-2013 170,000 93,850 263,850 2012 46,925 2012 46,925 2013-2014 280,000 88,750 368,750 2013 44,375 2013 44,375 2014-2015 375,000 78,950 453,950 2014 39,475 2014 39,475 2015-2016 395,000 65,825 460,825 2015 32,913 2015 32,913 2016-2017 410,000 52,000 462,000 2016 26,000 2016 26,000 2017-2018 435,000 35,600 470,600 2017 17,800 2017 17,800 2018 -2019 455,000 18,200 473,200 2018 9,100 2018 9,100 $ 2,680,000 $ 531,825 $ 3,211,825 $ 265,913 $ 265,913 I i I I 110 UNITED CITY OF Y ORKVILLE, ILLINOIS Sewer Fund Long -Term Debt Requirements Series 2003 Illinois Rural Bond Bank Outstanding at April 30, 2011 Date of Maturity February 1, 2023 Authorized Issue $2,035,000 Interest Rates 1.60% - 5.20 % Interest Dates Augustlst and February 1st Principal Maturity Dates February 1st Payable at US Bank National Association Purpose Construction of Bruell Street Lift Station CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Interest Due on Fiscal Year Principal Interest Totals Aug 1st Amount Feb 1st Amount 2011-2012 $ 95,000 $ 70,143 $ 165,143 2011 $ 35,071 2012 $ 35,071 2012 -2013 100,000 66,248 166,248 2012 33,124 2013 33,124 2013 -2014 100,000 62,048 162,048 2013 31,024 2014 31,024 2014 -2015 105,000 57,648 162,648 2014 28,824 2015 28,824 2015-2016 110,000 52,870 162,870 2015 26,435 2016 26,435 2016-2017 115,000 47,755 162,755 2016 23,878 2017 23,878 2017 -2018 120,000 42,293 162,293 2017 21,146 2018 21,146 2018-2019 130,000 36,233 166,233 2018 18,116 2019 18,116 2019-2020 135,000 29,668 164,668 2019 14,834 2020 14,834 2020 -2021 140,000 22,850 162,850 2020 11,425 2021 11,425 2021 -2022 150,000 15,710 165,710 2021 7,855 2022 7,855 2022-2023 155,000 8,060 163,060 2022 4,030 2023 4,030 $ 1,455,000 $ 511,523 $ 1,966,523 $ 255,761 $ 255,761 � 111 UNITED CITY OF YORKVILLE, ILLINOIS Sewer Fund Long -Term Debt Requirements Series 2004A Debt Certificates Outstanding at April 30, 2011 Date of Maturity December 30, 2014 Authorized Issue $1,600,000 Interest Rates 1.40 % - 3.60% Interest Dates June 30th and December 30th Principal Maturity Dates December 30th Payable at BNY Midwest Trust Company Purpose Provide Sewer Access to Windett Ridge, Raintree Village & other Subdivisions CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Interest Due on Fiscal Year Principal Interest Totals June 301h Amount Dec 30th Amount 2011-2012 $ 170,000 $ 24,093 $ 194,093 2011 $ 12,047 2011 $ 12,047 2012-2013 175,000 18,738 193,738 2012 9,369 2012 9,369 2013 -2014 180,000 13,050 193,050 2013 6,525 2013 6,525 2014-2015 190,000 6,840 196,840 2014 3,420 2014 3,420 $ 715,000 $ 62,721 $ 777,721 $ 31,361 $ 31,361 112 UNITED CITY OF YORKVILLE, ILLINOIS Sewer Fund Lang -Term Debt Requirements General Obligation Bond Series 2005D Outstanding at April 30, 2011 Date of Maturity December 30, 2015 Authorized Issue $11,300,000 Interest Rate 4.150% Interest Dates June 30th and December 30th Principal Maturity Dates December 30th Payable at BNY Midwest Trust Company Purpose Construct Rob Roy Sewer Interceptor CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Interest Due on Fiscal Year Principal Interest Totals June 30th Amount Dec 301h Amount 2011 -2012 $ 1,000,000 $ 385,950 $ 1,385,950 2011 $ 192,975 2011 $ 192,975 2012-2013 1,600,000 344,450 1,944,450 2012 172,225 2012 172,225 2013-2014 1,700,000 278,050 1,978,050 2013 139,025 2013 139,025 2014-2015 2,000,000 207,500 2,207,500 2014 103,750 2014 103,750 2015 -2016 3,000,000 124,500 3,124,500 2015 62,250 2015 62,250 $ 9,300,000 $ 1,340,450 $ 10,640,450 $ 670,225 $ 670,225 113 UNITED CITY OF YORKVILLE, ILLINOIS Sewer Fund Long -Term Debt Requirements General Obligation Bond Series 2008 Refunding Outstanding at April 30, 2011 Date of Maturity December 30, 2017 Authorized Issue $2,020,000 Interest Rate 5.250% Interest Dates June 30th and December 30th Principal Maturity Dates December 30th Payable at The Bank of New York Trust Company Purpose Constructed Siphon across River to assist Sanitary Sewer Construction CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Interest Due on Fiscal Year Principal Interest Totals June 30th Amount Dec 30th Amount 2011 -2012 $ $ 110,090 $ 110,090 2011 $ 55,045 2011 $ 55,045 2012 -2013 110,090 110,090 2012 55,045 2012 55,045 2013 -2014 110,090 110,090 2013 55,045 2013 55,045 2014 -2015 110,090 110,090 2014 55,045 2014 55,045 2015 -2016 110,090 110,090 2015 55,045 2015 55,045 2016 -2017 985,000 110,090 1,095,090 2016 55,045 2016 55,045 2017-2018 1,035,000 56,408 1,091,408 2017 28,204 2017 28,204 $ 2,020,000 $ 716,948 $ 2,736,948 $ 358,474 $ 358,474 I I I l i 114 UNITED CITY OF YORKVILLE, ILLINOIS Sewer Fund Long -Term Debt Requirements IEPA Loan L17 - 013000 Outstanding at April 30, 2011 Date of Maturity January 25, 2013 Authorized Issue $549,081 Interest Rate 3.580 % Interest Dates July 25th and January 25th Principal Maturity Dates July 25th and January 25th Payable at Illinois Environmental Protection Agency Purpose Constructed Siphon across River to assist Sanitary Sewer Construction CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Interest Due on Fiscal Year Principal Interest Totals Jul 25th Amount Jan 25th Amount 2011 -2012 $ 36,635 $ 2,345 $ 38,980 2011 $ 1,335 2012 $ 1,010 2012-2013 37,958 1,022 38,980 2012 679 2013 343 $ 74,592 $ 3,368 $ 77,960 $ 2,015 $ 1,353 I II I I I 115 UNITED CITY OF YORKVILLE, ILLINOIS Sewer Fund Long -Term Debt Requirements IEPA Loan L17 - 115300 Outstanding at April 30, 2011 Date of Maturity September 6, 2019 Authorized Issue $1,656,809 Interest Rate 2.625% Interest Dates September 6th and March 6th Principal Maturity Dates September 6th and March 6th Payable at Illinois Environmental Protection Agency Purpose Constructed Sewer Main and 1999 SSES (Sewer Repair & Rehab) CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Interest Due on Fiscal Year Principal Interest Totals Sept 6th Amount Mar 6th Amount 2011 -2012 $ 86,329 $ 20,721 $ 107,051 2011 $ 10,642 2012 $ 10,079 2012-2013 88,610 18,440 107,051 2012 9,509 2013 8,931 2013-2014 90,952 16,099 107,051 2013 8,346 2014 7,753 2014 -2015 93,355 13,696 107,051 2014 7,152 2015 6,544 2015 -2016 95,821 11,229 107,051 2015 5,927 2016 5,302 2016-2017 98,353 8,697 107,051 2016 4,669 2017 4,028 2017-2018 100,952 6,099 107,051 2017 3,378 2018 2,720 2018 -2019 103,619 3,431 107,051 2018 2,053 2019 1,378 2019-2020 52,832 693 53,525 2019 693 2020 - $ 810,825 $ 99,106 $ 909,931 $ 52,371 $ 46,736 I l i I I I I I 116 i Recreation Center Fund (80) The REC Center is a 38,000 square foot, full- service fitness and recreation facility leased by the City and operated by the Parks and Recreation Department. A variety of membership options are available to both residents and non- residents. The REC Center houses an indoor track, lap pool, whirlpool, and a variety of cardio and resistance equipment. The facility is also used for programming and events, such as Family Winter Fun Night, the Go Green Fair, open basketball, preschool, 5k runs and sports leagues. FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projection Adopted Pro jected Projected Revenue Charges for Service 489,847 574,408 603,500 582,000 603,500 603,500 603,500 Miscellaneous 108,145 8,632 5,500 8,700 7,500 7,500 7,500 Total Revenue 597,992 583,040 609,000 590,700 611,000 611,000 611,000 Expenses Salaries 215,132 211,086 232,043 231,543 232,700 232,700 232,700 Benefits 19,746 24,837 27,658 27,658 27,708 27,708 27,708 Contractual Services 261,416 342,276 362,650 379,280 380,580 386,580 392,580 Supplies 79,486 55,080 52,950 52,100 50,750 50,750 50,750 Capital Outlay 99,837 - - - - - - Total Expenses 675,617 633,279 675,301 690,581 691,738 697,738 703,738 Surplus (Deficit) (77,625) (50,240) (66,301) (99,881) (80,738) (86,738) (92,738) Ending Fund Balance Equivalent (77,579) (127,815) (143,880) (227,696) (308,434) (395,172) (487,910) - 33.0% 44.6% - 56.6% - 69.3% Fund Balance Equivalent $0 0 ($200) t ($400) ($600) Personnel Full -time Personnel: Facility Coordinator 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Part -time Personnel: Front Desk Staff 11.0 11.0 8.0 9.0 9.0 9.0 9.0 Janitorial Staff 2.0 2.0 2.0 2.0 2.0 2.0 2.0 Kidz Club Staff 4.0 4.0 4.0 4.0 4.0 4.0 4.0 Preschool Staff 3_0 3_0 3_0 3_0 3_0 3_0 3_0 Total Part -Time Personnel 20.0 20.0 17.0 18.0 18.0 18.0 18.0 Total Personnel 21.0 21.0 18.0 19.0 19.0 19.0 19.0 117 United City of Yorkville Recreation Center Fund 80 RECREATION CENTER FUND REVENUE FY 2009 FY 2010 FT 2011 ITY 2011 FY 2012 FY 2013 FY 2014 Account Descriplion Actual Actual Budget Projected Adopted Projected Projected Charges for Services 80-100 -44 -00 -0440 PROGRAM FEES 121,406 123,073 125,000 125,000 125,000 125,100 125,000 80. 000 -44 -00 -0441 CONCESSION REVENUE 8,372 12,915 12,510 12,700 12,500 12,500 12,500 80- 00.44 -00-4444 MEMBERSHIP FEES 321,099 387,975 410,000 400,000 410,000 410,000 410,010 80- 000- 44 -00-4"5 GUESTFEES 7,517 4,303 3,500 4,300 3,500 3,500 3,500 80. 000 -44 -00 -4446 SWIM CLASS FEES 17,060 30,949 35,000 30,100 35,000 35,000 35,000 80. 000.44 -00 -4447 PERSONAL TRAINING FEES 11,576 12,603 15,000 8,000 15,000 15,000 15,000 80- 00 -44 -00-4448 TANNING SESSION FEES 2,817 2,590 2,500 2,000 2,500 2,500 2,500 Total: Charges for Services $489,847 $574,408 $603,500 $582,000 $603,500 $603,500 $603,500 Miscellaneous 80. 000.48 -00-4820 RENTAL INCOME 4,698 4,056 3,000 6,000 5,100 5,100 5,000 80- 000.48. 00.4845 DONATIONS 3,447 3,176 2,000 2,700 2,100 2,000 2,000 80-00 -48.00-4850 MISCELLANEOUS INCOME 100,000 1,400 500 - 500 500 500 Total: Miscellaneous $108,145 $8,632 $5,500 $8,700 $7,500 $7,500 $7,500 Total: REC CTR REVENUE $597,992 $583.04 0 609 000 $590.70 0 611 000 $611,000 $611,000 118 United City of Yorkville Recreation Center Fund 800 RECREATION CENTER EXPENSES FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 IT 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Salaries 80- 800 -50 -00 -5010 SALARIES AND WAGES 27,886 34,068 33,543 33,543 34,200 34,200 34,200 80- 800 -50 -00 -5015 PART -TIME SALARIES 90,600 101,640 98,000 98,000 98,0110 98,000 98,000 80- 800 -50 -00 -5020 OVERTIME 953 - 500 - 500 500 500 80- 800 -50 -00 -5016 PRE- SCHOOLWAGES 35,781 22,644 35,000 35,000 35,000 35,000 35,000 80- 800-50 -00-5052 INSTRUCTORS WAGES 59,912 52,734 65,000 65,000 65,000 65,000 65,000 Total: Salaries $215,132 $211,086 $232,043 $231,543 $232,700 $232,700 $232,700 Benefits 80- 800.52 - 00.5212 RETIREMENT PLAN CONTRIBUTION 4,088 8,804 10,000 10,000 10,000 10,000 10,000 80- 800-52- 00.5214 FICA CONTRIBUTION 15,658 16,034 17,658 17,658 17,708 17,708 17,708 Total: Benefits $19,746 $24,837 $27,658 $27,658 $27,708 $27,708 $27,708 Contractual Scrviccs 80. 800-54.00-5412 TRAINING & CONFERENCES 660 - - - - - - 80- 800-54 -00-5415 TRAVEL AND LODGING 157 - 200 100 200 200 200 Mileage $200 80. 800-54.00-5426 PUBLISHING & ADVERTISING 859 1,478 1,500 1,000 1,500 1,500 1,500 80. 800- 54.00.5440 TELECOMMUNICATIONS 2,051 2,357 2,350 3,600 3,600 3,600 3,600 Teleplaa, $3,000 Cellydar Phone 5600 80- 800-54 -00-5447 SCHOLARSHIPS - 216 900 400 900 900 900 80- 800-54 -00-5452 POSTAGE & SHIPPING 73 180 600 500 600 600 600 80- 800-54 -00-5462 PROFESSIONAL SERVICES 7,152 22,433 17,700 22,700 17,700 17,700 17,700 Contractual S-4- 515,000 T- WRenml $1,500 Lirensecmrd Permits $700 Secorily 5500 80- 800-54.00-5480 UTILITIES 42,628 46,796 39,000 49,000 49,000 49,000 49,000 Elertrieiry 538,000 Nicor $11,000 80. 800-54 -00 -5485 RENTAL &LEASE PURCHASE 177,131 214,558 220,500 220,500 226,500 232,500 238,500 Lease Torments $222,000 AlairOenanre -O re Equil t 54,500 80. 800- 54.00.5490 DUES AND SUBSCRIPTIONS 174 89 200 200 200 200 200 80.800-54- 00.5495 OUTSIDE REPAIR AND MAINTENANCE 26,691 20,012 21,200 21,100 21,200 21,200 21,200 Alainleaanee- General $16,000 Pool Repair $5,000 Phone Statem $200 80- 800-54 -00-5496 PROGRAM REFUNDS 3,840 7,837 5,500 6,500 5,500 5,500 5,500 80- 800-54 -00-5497 PROPERTY TAX PAYMENT - 26,320 53,000 53,680 53,680 53,680 53,680 Total: Contractual Services $261,416 $342,276 $362,650 $379,280 $380,580 $386,580 $392,580 119 United City of Yorkville Recreation Center Fund 800 RECREATION CENTER EXPENSES FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Acmmri Deacriplioa Actual Actual Budget Projeeled Adapted Prujeeted Projccled Supplies 80- 800 -56 -00 -5600 WEARING APPAREL - - - - - - - 80.800 -56.00-5606 PROGRAM SUPPLIES 18,631 19,119 17,000 17,000 17,000 17,000 17,000 80. 800- 56.00 -5607 CONCESSION SUPPLIES 5,234 11,615 6,300 8,000 6,300 6,300 6,300 Cwrressinn Supplies 56,0(X) AlisrrRnneous Relui! $300 80- 800- 56.00.5610 OFFICE SUPPLIES 5,045 2,383 2,600 1,800 2,600 2,600 2,600 80. 800- 56.00.5620 OPERATING SUPPLIES 7,332 5,330 6,200 4,700 6,200 6,200 6,200 Operaling Supplies $3,000 Punt Supplies $3,200 80- 800-56 -00-5630 SMALL TOOLS & EQUIPMENT 6,678 4,100 6,300 6,200 6,300 6,300 6,300 R,,-lion Egrripnrrnl $6,000 OJfire Ej,dI em $300 80- 800.56 -00-5635 COMPUTER EQUIPMENT & SOFTWARE 22,278 3,178 3,200 3,200 1,000 1,010 1,000 80- 800-56 -00-5640 REPAIR AND MAINTENANCE 14,184 9,355 11,000 11,0001 11,000 11,0()0 11,000 80- 800-56 -00-5645 BOOKS AND PUBLICATIONS 105 - 50 - 50 50 50 80- 800.56 -00-5695 GASOLINE - - 300 200 300 300 300 Total: Supplies $79,486 $55,080 $52,950 $52,100 $50,750 $50,750 $50,750 Capital Outlay 80- 800-60 -00-6020 BUILDINGS AND STRUCTURES 99,837 - - - - - - Tidal: Capital Outlay $99,637 $0 $0 $0 $0 $0 $0 Total: REC CTR EXPENSES $675,617 $633,279 $675,301 $690,581 $691,738 $697,73R $703.73H 120 Library 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 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projected Adopted Projected Projected Revenue Taxes 1,115,409 1,183,774 1,255,924 1,395,800 Intergovernmental 4,551 19,693 22,500 18,500 Licenses & Permits 65,400 31,100 40,000 - Fines & Forfeits 9,531 11,503 9,000 20,000 Charges for Service 19,487 18,493 18,000 20,500 Investment Earnings 10,985 1,952 10,000 2,000 Reimbursements - 6,181 - - Miscellaneous 3,183 6,113 4,500 6,500 - Total Revenue 1,228,546 1,278,809 1,359,924 1,463,300 Expenditures Salaries 428,161 486,675 650,000 475,000 Benefits 99,917 134,192 155,000 140,500 Contractual Services 129,909 136,108 238,500 116,800 Supplies 181,878 180,858 365,000 123,500 Contingencies 6,923 4,985 144,561 10,000 Debt Service 467,406 564,050 605,925 605,925 720,800 Total Expenditures 1,314,193 1,506,868 2,158,986 605,925 1,586,600 Surplus (Deficit) (85,647) (228,059) (799,062) (605,925) (123,300) 0 0 Ending Fund Balance 799,062 571,002 0 (34,923) (158,223) (158,223) (158,223) -5.8% - 10.0% N $1,000 Fund Balance $500 O t $0 ($500) 121 FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projected Adopted Projected Projected Personnel Full -time Personnel: Library Director 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Director of Adult Services 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Director of Youth Services 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Director ofTeclrnical Services 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Circulation Manager 1_0 1_0 1_0 1_0 1_0 1_0 1_0 Total Full -time Personnel 5.0 5.0 5.0 5.0 5.0 5.0 5.0 Part -time Personnel: Library Clerks 30.0 30.0 30.0 30.0 26.0 26.0 26.0 Building Manager 1.0 1.0 1.0 1.0 1.0 1.0 1.0 Custodian 4.0 4.0 4.0 4.0 4.0 4.0 4.0 Total Part -Time Personnel 35.0 35.0 35.0 35.0 31.0 31.0 31.0 Total Personnel 40.00 40.00 40.00 40.00 36.00 36.00 36.00 122 United City of Yorkville Library Fund 82 LIBRARY FUND REVENUE FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected Taxes 82- 000 -40 -00 -4005 PROPERTY TAXES - LIBRARY 652,085 622,624 650,000 - 675,000 - - 82- 000 -40 -00 -4015 PROPERTY TAXES - DEBT SERVICE 463,324 561,150 605,924 - 720,800 - - Total: Taxes $1,115,409 $1,183,774 $1,255,924 $0 $1,395,800 $0 $0 Intergovernmental 82- 000 -41 -00 -4120 PERSONAL PROPERTY TAX 4,551 5,139 5,000 - 5,000 - - 82- 000 -41 -00 -4170 STATEGRANTS - 14,555 17,500 - 13,500 - - Libraq per Capita Gratu $13,500 Total: Intergovernmental $4,551 $19,693 $22,500 $0 $18,500 $0 $0 Licenses and Permits 82- 000 -42 -00 -4211 DEVELOPMENT FEES - BOOKS 32,700 15,550 20,000 - - - - 82- 000 -42 -00 -4212 DEVELOPMENT FEES - BUILDING 32,700 15,550 20,000 - - - - Total: Licenses and Permits $65,400 $31,100 $40,000 $0 $0 $0 $0 Fines and Forfeits 82- 000 -43 -00 -4330 LIBRARY FINES 9,531 11,503 9,000 - 20,000 - - Total: Fines and Forfeits $9,531 $11,503 $9,000 $0 $20,000 $0 $0 Charges for Services 82- 000 -44 -00 -4401 LIBRARY SUBSCRIPTION CARDS 16,758 14,720 15,000 - 17,000 - - 82- 000 -44 -00 -4422 COPY FEES 2,729 3,773 3,000 - 3,500 - - Total: Charges for Services $19,487 $18,493 $18,000 $0 $20,500 $0 $0 Investment Earnings 82- 000 -45 -00 -4500 INVESTMENT EARNINGS 10,985 1,952 10,000 - 2,000 - - Total: Investment Earnings $10,985 $1,952 $10,000 $0 $2,000 $0 $0 Reimbursements 82- 000 -46 -00 -4682 REIMB - INSURANCE - 6,181 - - - - - 82- 000 -46 -00 -4690 REIMB - MISCELLANEOUS - - - - - - - Total: Reimbursements $0 $6,181 $0 $0 $0 $0 $0 Miscellaneous 82- 000 -48 -00 -4820 RENTAL INCOME 1,101 1,239 Low - 2,500 - - Library Building Rental $1,500 Other Rental Income $1,000 82- 000 -48 -00 -4832 MEMORIALS 1,363 4,451 3,000 - 3,500 - - 82- 000 -48 -00 -4850 MISCELLANEOUS INCOME - - - - - - - 82- 000 -48 -00 -4881 SALEOFBOOKS 719 423 500 - 500 - - Total: Miscellaneous $3,183 $6,113 $4,500 $0 $6,500 $0 $0 Total: LIBRARY FUND REVENUE $1,228,546 $1,278,809 $1 L $1A63,300 LO L 123 United City of Yorkville Library Fund 820 LIBRARY FUND EXPENDITURES FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 Account Dmeriplion Actual Acluul Budget Projected Adopted Projected Projecled Salaries 82. 820 -50 -00 -5010 SALARIES AND WAGES 428,161 486,675 650,000 - 475,000 - - Total: Salaries $428,161 $486,675 $650,000 $0 $475,000 $0 $0 B-trM 82- 820- 52 -00 -52 t2 RETIREMENT PLAN CONTRIBUTION 14,714 19,866 22,000 - 22,500 - - 82- 82052.00 -5214 FICA CONTRIBUTION 32,754 36,691 55,000 - 40,000 - - 82- 820 -52 -00-5216 GROUP HEALTH INSURANCE 47,457 70,805 70,000 - 70,000 - - 82- 820 -52 -00-5222 GROUP LIFE INSURANCE 992 1,240 2,000 - 2,000 - - 82- 820 -52 -00-5223 DENTAL & VISION INSURANCE 4,010 5,589 6,000 - 6,000 - - Total: Benerit5 $99,917 $134,192 $155,000 $0 $140,500 $0 $0 Contracwol Services 82- 820 -54 -00-5412 TRAINING & CONFERENCES 3,421 358 5,000 800 - - 82- 820 -54 -00-5415 TRAVEL AND LODGING 989 566 1,000 - 500 - - Mileage $500 82- 820 - 54.00.5423 PUBLIC RELATIONS - 663 2,000 - 1 - - 82- 820 -54 -00-5426 PUBLISHING & ADVERTISING 63 29 2,000 - 500 - - 82- 820 -54 -00-5440 TELECOMMUNICATIONS 4,218 5,198 8,000 - 5,000 - - Tclephone $5,000 82- 820 -54 -00-5452 POSTAGE & SHIPPING 1,156 1,738 2,500 - 2,000 - - 82- 820 -54 -00-5460 DUES AND SUBSCRIPTIONS 5,205 18,046 30,000 - 20,000 - - Datnbace $15,000 S,,b- iplioar $5,000 82- 820 -54.00-5462 PROFESSIONAL SERVICES 61,429 45,063 85,000 - 44,000 - C- t- r ml Srrvices $13,000 Bonding Fees $4,000 Anlonmlion 525,000 82- 820 -54 -00-5466 LEGAL SERVICES 595 2,125 10,000 - 5,000 - - 82- 820 -54 -00-5480 UTILITIES 15,454 12,009 48,000 - 15,000 - - Elecirickv $5,000 Gns $10,000 82- 820 -54 -00-5485 RENTAL & LEASE PURCHASE 1,638 2,442 15,000 - 3,000 - - Alaiul --ce Pboto-1 iar $3,000 82- 820 -54 -00-5495 OUTSIDE REPAIR AND MAINTENANCE 35,742 47,872 30,000 - 20,000 - - Mnituenmtcr - Bldg & Jiunwi- nl S20,000 Total: Contractual Services $129,909 $136,108 $238,500 $0 $116,800 $0 $0 Supplies 82- 820 -56 -00-5600 WEARING APPAREL - - - - 82- 820 -56 -00-5610 OFFICE SUPPLIES 6,362 9,809 15,000 - 10,000 - - 82- 820 -56 -00-5620 OPERATING SUPPLIES 18,378 15,184 35,000 - 16,000 - - Lib-,) $5,000 Custodial Supplier $11,000 82- 820 -56 -00-5635 COMPUTER EQUIPMENT & SOFTWARE 12,188 4,276 20,000 - 2,000 - - 82- 820 -56 -00-5640 REPAIR AND MAINTENANCE 6,404 2,506 20,000 - 3,000 - - Alainte,muceOfceEquipment $3,000 82. 820.56. 00-5670 COMMUNITY RELATIONS 11,126 10,137 20,000 - 10,000 - - LibrmpProgrmnn,ing $10,000 82- 820 -56 -00-5676 EMPLOYEE RECOGNITION 1,194 1,113 4,000 - - - - 82- 820 -56 -00-5680 ADULT BOOKS 20,412 20,213 50,000 - 15,000 - - 82- 820 -56 -00-5681 JUVENILE BOOKS 19,724 40,325 50,000 - 30,000 - - 82. 820 -56. 00.5682 REFERENCE BOOKS 21,716 24,097 35.000 - 20,000 - - 82. 820 - 56.00.5683 AUDIO BOOKS 11,708 8,176 30,000 - 5,000 - - 82. 820 -56.00-5684 COMPACT DISCS AND OTHER MUSIC 6,645 2,963 15,000 - 3,000 - - 82. 820 - 56.00.5685 VIDEOS 4,961 4,750 25,000 - 5,000 124 United City of Yorkville Library Fund 820 LIBRARY FUND EXPENDITURES FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 F V 2014 Account Description Actual Actual Budget Projected Adopted Projected Projected 82- 820 -56 -00 -5686 BOOKS - DEVELOPMENT FEES 38,068 32,810 40,000 - - - 82- 820 -56 -00 -5698 MEMORIALS AND GIFTS 2,844 4,416 3,000 - 3,500 - - 82- 820 -56 -00 -5699 MISCELLANEOUS 147 83 3,000 - 1,000 - - Libra,yBonrdEipensrs $500 dtertirtg Ronrn Deposit Refinrd $500 Total: Supplies $181,878 $180,858 $365,000 $0 $123,500 $0 $0 Contingencies 82- 820 -70 -00 -7799 CONTINGENCIES 6,923 4,985 144,561 - 10,000 - - Total: Contingencies $6,923 $4,985 $144,561 $0 $10,000 $0 $0 Debt Service - 2005B Bond 82- 820 - 83.00 -8000 PRINCIPLE PAYMENT 25,000 25,000 75,000 75,000 175,000 - - 82- 820 -83 -00-8050 INTEREST PAYMENT 321,106 320,125 319,125 319,125 316,125 - - Total: Debt Service -2005B Bond $346,106 $345,125 $394,125 $394,125 $491,125 $0 $0 Debt Service - 2006 Bond 82- 820 -84 -00-8000 PRINCIPLE PAYMENT 50,000 150,000 150,000 150,000 175,000 - - 82- 82084- 00.8050 INTERESTPAYMENT 71,300 68,925 61,800 61,800 54,675 - - Total: Debt Service .2006 Bond $121,300 $218,925 $211,800 $211,800 $229,675 $0 $0 Total: LIBRARY EXPENDITURES $1,314,193 $1,506,868 $2,158,986 $605,925 $1,586,600 5- 0 L 125 UNITED CITY OF YORKVILLE, ILLINOIS Library Fund Long -Term Debt Requirements Total Library Fund Debt Outstanding at April 30, 2011 TOTAL LIBRARY FUND - OUTSTANDING DEBT Fiscal Years 2012 - 2025 CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Fiscal Year Principal Interest Totals 2011-2012 $ 350,000 $ 370,800 $ 720,800 2012-2013 $ 440,000 $ 355,488 795,488 2013-2014 $ 435,000 $ 336,763 771,763 2014-2015 $ 450,000 $ 318,613 768,613 2015-2016 $ 485,000 $ 300,238 785,238 2016-2017 $ 510,000 $ 280,463 790,463 2017-2018 $ 535,000 $ 259,688 794,688 2018-2019 $ 590,000 $ 237,913 827,913 2019-2020 $ 625,000 $ 210,563 835,563 i 2020-2021 $ 680,000 $ 181,594 861,594 2021-2022 $ 725,000 $ 150,050 875,050 I 2022-2023 $ 765,000 $ 116,425 881,425 2023-2024 $ 825,000 $ 80,088 905,088 2024-2025 $ 860,000 $ 40,900 900,900 $ 8,275,000 $ 3,239,582 $ 11,514,582 126 UNITED CITY OF YORKVILLE, ILLINOIS Library Fund Long -Term Debt Requirements General Obligation Bonds 2005B April 30, 2011 Date of Maturity December 30, 2024 Authorized Issue $7,250,000 Interest Rates 4.00% - 4.75% Interest Dates June 30th and December 30th Principal Maturity Dates December 30th Payable at BNY Midwest Trust Company Purpose Library Expansion CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Interest Due on Fiscal Year Principal Interest Totals June 30th Amount Dec 30th Amount 2011 -2012 $ 175,000 $ 316,125 $ 491,125 2011 $ 158,063 2011 $ 158,063 2012 -2013 290,000 309,125 599,125 2012 154,563 2012 154,563 2013-2014 335,000 297,525 632,525 2013 148,763 2013 148,763 2014 -2015 400,000 284,125 684,125 2014 142,063 2014 142,063 2015-2016 435,000 268,125 703,125 2015 134,063 2015 134,063 2016-2017 460,000 250,725 710,725 2016 125,363 2016 125,363 2017 -2018 485,000 232,325 717,325 2017 116,163 2017 116,163 2018 -2019 540,000 212,925 752,925 2018 106,463 2018 106,463 2019 -2020 575,000 187,950 762,950 2019 93,975 2019 93,975 2020-2021 605,000 161,356 766,356 2020 80,678 2020 80,678 2021 -2022 650,000 133,375 783,375 2021 66,688 2021 66,688 2022-2023 690,000 103,313 793,313 2022 51,656 2022 51,656 2023-2024 725,000 70,538 795,538 2023 35,269 2023 35,269 2024-2025 760,000 36,100 796,100 2024 18,050 2024 18,050 $ 7,125,000 $ 2 ,863,631 $ 9,988,631 $ 1,431,816 $ 1,431,816 i 127 UNITED CITY OF Y ORKVILLE, ILLINOIS Library Fund Long -Term Debt Requirements General Obligation Bonds 2006 April 30, 2011 Date of Maturity December 30, 2024 Authorized Issue $1,500,000 Interest Rates 4.75% - 4.80% Interest Dates June 30th and December 30th Principal Maturity Dates December 30th Payable at BNY Midwest Trust Company Purpose Library Expansion CURRENT AND FUTURE PRINCIPAL AND INTEREST REQUIREMENTS Debt Service Requirements Interest Due on Fiscal Year Principal Interest Totals June 30th Amount Dec 30th Amount 2011-2012 $ 175,000 $ 54,675 $ 229,675 2011 $ 27,338 2011 $ 27,338 2012 -2013 150,000 46,363 196,363 2012 23,182 2012 23,182 2013 -2014 100,000 39,238 139,238 2013 19,619 2013 19,619 2014-2015 50,000 34,488 84,488 2014 17,244 2014 17,244 2015 -2016 50,000 32,113 82,113 2015 16,056 2015 16,056 2016-2017 50,000 29,738 79,738 2016 14,869 2016 14,869 2017-2018 50,000 27,363 77,363 2017 13,681 2017 13,681 2018-2019 50,000 24,988 74,988 2018 12,494 2018 12,494 2019-2020 50,000 22,613 72,613 2019 11,306 2019 11,306 2020 -2021 75,000 20,238 95,238 2020 10,119 2020 10,119 2021 -2022 75,000 16,675 91,675 2021 8,338 2021 8,338 2022 -2023 75,000 13,113 88,113 2022 6,556 2022 6,556 2023 -2024 100,000 9,550 109,550 2023 4,775 2023 4,775 2024-2025 100,000 4,800 104,800 2024 2,400 2024 2,400 $ 1,1 50,000 $ 375,951 $ 1,525,951 $ 187,976 $ 187,976 i I I I i 128