The URL can be used to link to this page

City Council Packet 2011 09-27-11 0 C t ry o United City of Yorkville Esc - _ less 800 Game Farm Road Yorkville, Illinois 60560 (� W Telephone: 630-553-4350 Fax: 630-553-7575 t AGENDA CITY COUNCIL MEETING CITY COUNCIL CHAMBERS 7:00 p.m. Tuesday, September 27, 2011 Call to Order: Pledge of Allegiance: Roll Call by Clerk: WARD I WARD II WARD III WARD IV George Gilson,Jr. Jackie Milschewski Marty Munns Rose Ann Spears Carlo Colosimo Larry Kot Chris Funkhouser Diane Teeling Establishment of Quorum: Amendments to Agenda: Presentations: Public Hearings: Citizen Comments: Consent Agenda: 1. CC 2011-109 Bills for Payment - $796,018.59 2. ADM 2011-46 Treasurer's Report for August 2011 3. PW 2011-58 Ordinance Amending the Traffic Schedule and Index (Van Emmon and Mill Street)— authorize Mayor and City Clerk to execute 4. PW 2011-31 Kendall Marketplace Improvements Bid Results—award contract to Wilkinson Excavating in an amount not to exceed$87,041.50 Minutes for Approval: Mayor's Report: 1. CC 2011-110 KenCom Agreement Public Works Committee Report: Economic Development Committee Report: Public Safety Committee Report: Administration Committee Report: 1. ADM 2011-48 Fiscal Year 2011 Budget Report City Council Meeting Agenda September 27, 2011 Page 2 Park Board: 1. CC 2011-111 Collman Naming Request Plan Commission: Zoning Board of Appeals: Library Board: 1. CC 2011-112 Ordinance Approving the Revision of the 2011-2012 Fiscal Year Budget Regarding the General Fund, the Library Operations Fund, and the Library Development Fee Fund City Council Report: City Clerk's Report: City Treasurer's Report: Community and Liaison Report: Staff Report: Additional Business: Executive Session: 1. For collective negotiating matters between the public body and its employees or their representatives, or deliberations concerning salary schedules for one or more classes of employees. 2. For litigation, when an action against, affecting, or on behalf of the particular public body has been filed and is pending before a court or administrative tribunal, or when the public body finds that an action is probable or imminent, in which case the basis for the finding shall be recorded and entered into the minutes of the closed meeting. Adjournment: COMMITTEES, MEMBERS AND RESPONSIBILITIES ;PUBLIC WORKS: October 18, 2011 —6: 30 p.m.—City Hall Conference Room; ----- - - ---- -- --------- --------- --------- --------- ----------- ------- ---------- ------------------------------------------ Committee Departments Liaisons Chairman: Alderman Gilson Public Works Park Board Committee: Alderman Teeling Engineering YBSD Committee: Aldennan Kot Parks and Recreation Committee: Aldennan Milschewski City Council Meeting Agenda September 27, 2011 Page 3 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ECONOMIC DEVELOPMENT: October 4, 2011 -6:30 p.m.-City Hall Conference Room ------------------------------------------------------- -------- ------------- Committee Departments Liaisons Chairman: Alderman Munns Community Development Plan Commission Committee: Alderman Funkhouser Building Safety and Zoning Yorkville Econ. Dev. Corp. Committee: Alderman Milschewski Kendall Co. Plan Commission Committee: Aldennan Teeling r------------------------------------------------------------------------------------------------------------------------------------------------------------------- PUBLIC SAFETY: October 6, 2011 -6:30 p.m. - City Hall Conference Room- - -- -- Z=---- ------- ----------------------------------------------------------- Committee Departments Liaisons Chairman: Alderman Colosimo Police Human Resource Comm. Committee: Alderman Spears School District Committee: Alderman Kot Committee: Alderman Funkhouser ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ADMINISTRATION: October 20, 2011 -6:30 p.m.-City Hall Conference Room!! --------------------------------------------------- Committee Departments Liaisons Chairman: Alden-nan Spears Finance Library Committee: Alderman Gilson Administration Committee: Alderman Colosimo Committee: Alderman Munns UNITED CITY OF YORKVILLE WORKSHEET CITY COUNCIL Tuesday, September 27, 2011 7:00 PM CITY COUNCIL CHAMBERS ---------------------------------------------------------------------------------------------------------------------------------------- AMENDMENTS TO AGENDA: ---------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------- CITIZEN COMMENTS: ----------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------- CONSENT AGENDA: ----------------------------------------------------------------------------------------------------------------------------------------- 1. CC 2011-109 Bills for Payment- $796,018.59 ❑ Approved: Y N ❑ Subject to ❑ Removed ❑ Notes ----------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2011-46 Treasurer's Report for August 2011 ❑ Approved: Y N ❑ Subject to ❑ Removed ❑ Notes ----------------------------------------------------------------------------------------------------------------------------------------- 3. PW 2011-58 Ordinance Amending the Traffic Schedule and Index (Van Emmon and Mill Street) ❑ Approved: Y N ❑ Subject to ❑ Removed ❑ Notes ----------------------------------------------------------------------------------------------------------------------------------------- 4. PW 2011-31 Kendall Marketplace Improvements—Bid Results ❑ Approved: Y N ❑ Subject to ❑ Removed ❑ Notes ----------------------------------------------------------------------------------------------------------------------------------------- MAYOR'S REPORT: ----------------------------------------------------------------------------------------------------------------------------------------- l. CC 2011-110 KenCom Agreement ❑ Approved: Y N ❑ Subject to El Bring back to Committee/future meeting ❑ Informational Item ❑ Notes ----------------------------------------------------------------------------------------------------------------------------------------- ADMINISTRATION COMMITTEE REPORT: ----------------------------------------------------------------------------------------------------------------------------------------- 1. ADM 2011-48 Fiscal Year 2011 Budget Report ❑ Approved: Y N ❑ Subject to ❑ Removed ❑ Bring back to Committee/future meeting ❑ Informational Item ❑ Notes ----------------------------------------------------------------------------------------------------------------------------------------- PARK BOARD REPORT: ----------------------------------------------------------------------------------------------------------------------------------------- 1. CC 2011-111 Colman Naming Request ❑ Approved: Y N ❑ Subject to ❑ Removed ❑ Bring back to Committee/future meeting ❑ Informational Item ❑ Notes ----------------------------------------------------------------------------------------------------------------------------------------- LIBRARY BOARD REPORT: ----------------------------------------------------------------------------------------------------------------------------------------- 1. CC 2011-112 Ordinance Approving the Revision of the 2011-2012 Fiscal Year Budget Regarding the General Fund, the Library Operations Fund, and the Library Development Fee Fund ❑ Approved: Y N ❑ Subject to ❑ Removed ❑ Bring back to Committee/future meeting ❑ Informational Item ❑ Notes ----------------------------------------------------------------------------------------------------------------------------------------- REPORTS: ----------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------- ADDITIONAL BUSINESS: ----------------------------------------------------------------------------------------------------------------------------------------- C/Ty Reviewed By: Agenda Item Number J� 0-%A Legal ❑ CA#1 EST , l 1836 Finance Engineer ❑ Tracking Number City Administrator ❑ �� O Public Works ❑ CC 2011-109 C < E El Agenda Item Summary Memo Title: Bill Payments - $796,018.59 Meeting and Date: City Council 09/27/11 Synopsis: Approval of bill payments. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Majority Council Action Requested: Approval Submitted by: Amy Simmons Finance Name Department Agenda Item Notes: NE: 10:16:31 CHECK REGISTER 3 ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ---------------------------------------------------------------------------------------------------------------------------------- 11917 90000959 COLDWELL BANKER HONIG BELL 090711 09/07/11 01 ADMIN-OVERPAYMENT ON FINAL 01-000-13-00-1371 41.95 02 WATER BILL FOR ** COMMENT ** 03 ACCT#0104103500-01 ** COMMENT ** INVOICE TOTAL: 41.95 CHECK TOTAL: 41.95 11918 AA000003 DANIEL V. TRANSIER 083111 08/31/11 01 POLICE-AUGUST 17 ADMIN HEARING 01-210-54-00-5467 150.00 INVOICE TOTAL: 150.00 * CHECK TOTAL: 150.00 11919 ACCURINT LEXISNEXIS RISK DATA MGMT. 1249304-20110831 08/31/11 01 POLICE-AUGUST SEARCHES 01-210-54-00-5462 92.70 INVOICE TOTAL: 92.70 * CHECK TOTAL: 92.70 11920 ARAMARK ARAMARK UNIFORM SERVICES 610-7189527 08/30/11 01 STREETS-UNIFORMS 01-410-56-00-5600 31.69 02 WATER OP-UNIFORMS 51-510-56-00-5600 31.69 03 SEWER OP-UNIFORMS 52-520-56-00-5600 31.69 INVOICE TOTAL: 95.07 * CHECK TOTAL: 95.07 11921 ATT AT&T 6305533436-0811 09/19/11 01 POLICE-MONTHLY CHARGES 01-210-54-00-5440 41.13 INVOICE TOTAL: 41.13 * -1- ME: 10:16:31 CHECK REGISTER ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ---------------------------------------------------------------------------------------------------------------------------------- 11921 ATT AT&T 6305533608-0811 08/25/11 01 WATER OP-MONTHLY CHARGES 51-510-54-00-5440 88.03 INVOICE TOTAL: 88.03 CHECK TOTAL: 129.16 11922 ATTLONG AT&T LONG DISTANCE 82893213-0811 09/01/11 01 ADMIN-AUGUST LONG DISTANCE 01-110-54-00-5440 0.03 02 POLICE-AUGUST LONG DISTANCE 01-210-54-00-5440 73.47 03 WATER OP-AUGUST LONG DISTANCE 51-510-54-00-5440 470.55 INVOICE TOTAL: 544.05 CHECK TOTAL: 544.05 11923 AURBLA AURORA BLACKTOP 33745 09/01/11 01 MFT-SURFACE 15-155-56-00-5634 987.83 INVOICE TOTAL: 987.83 CHECK TOTAL: 987.83 11924 B&FTECH B&F TECHNICAL CODE SERVICES 33597 08/29/11 01 COMM/DEV-RIVER CITY ROASTERS 01-220-54-00-5459 608.56 02 BUILDING PLAN, ELECTRICAL PLAN ** COMMENT ** 03 AND PLUMBING PLAN REVIEW FOR ** COMMENT ** 04 REMODEL ** COMMENT ** INVOICE TOTAL: 608.56 CHECK TOTAL: 608.56 11925 BCBS BLUE CROSS BLUE SHIELD 090711 09/07/11 01 ADMIN SERVICES-OCTOBER HEALTH 01-640-52-00-5216 79, 575.14 -2- 'IE: '15: 16:31 CHECK REGISTER 3 ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ----------------------------------------------------------------------------------------- ---------------------------------------- 11925 BCBS BLUE CROSS BLUE SHIELD 090711 09/07/11 02 INSURANCE ** COMMENT ** 03 ADMIN SERVICES-OCTOBER DENTAL 01-640-52-00-5223 7, 108.78 04 INSURANCE ** COMMENT ** INVOICE TOTAL: 86,683.92 CHECK TOTAL: 86,683.92 11926 CAMBRIA CAMBRIA SALES COMPANY INC. 31567 09/01/11 01 SEWER OP-PAPER TOWEL 52-520-56-0,0-5620 55.50 INVOICE TOTAL: 55.50 CHECK TOTAL: 55.50 11927 CARGILL CARGILL, INC 3257328 08/29/11 01 WATER OP-BULK ROCK SALT 51-510-56-00-5638 2, 688.54 INVOICE TOTiAL: 2, 688.54 CHECK TOTAL!: 2,688.54 11928 CENTRALL CENTRAL LIMESTONE COMPANY, INC 14629 08/31/11 01 STREETS-STONE 01-410-56-00-5620 77.92 02 WATER OP-STONE 51-510-56-06-5620 77.92 03 SEWER OP-STONE 52-520-56-06-5620 77.92 INVOICE TOTAL: 233.76 I CHECK TOTAL!: 233.76 11929 CLASLAND CLASSIC LANDSCAPE, LTD I 73467 08/31/11 01 FOX HILL SSA-AUGUST LAWN CARE 11-111-54-00-5495 613.64 INVOICE TOT L: 613.64 -3- AE: 10:16:31 CHECK REGISTER ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ---------------------------------------------------------------------------------------------------------------------------------- 11929 CLASLAND CLASSIC LANDSCAPE, LTD 73468 08/31/11 01 SUNFLOWER SSA-AUGUST LAWN CARE 12-112-54-00-5495 520.00 INVOICE TOTAL: 520.00 CHECK TOTAL: 1, 133.64 11930 COMCAST COMCAST CABLE 082611 08/26/11 01 POLICE-MONTHLY CABLE 01-210-56-00-5620 4.17 INVOICE TOTAL: 4.17 CHECK TOTAL: 4.17 11931 COMED COMMONWEALTH EDISON 0185079109-0811 08/30/11 01 WATER OP-420 FAIRHAVEN 51-510-54-00-5480 119.02 INVOICE TOTAL: 119.02 0435113116-0811 08/31/11 01 STREETS-LIGHTS 01-410-54-00-5480 70.64 INVOICE TOTAL: 70.64 0908014004-0811 08/31/11 01 WATER OP-WELLS 51-510-54-00-5480 121.94 INVOICE TOTAL: 121.94 1407125045-0811 08/31/11 01 SEWER OP-FOXHILL 7 LIFT 52-520-54-00-5480 70.94 INVOICE TOTAL: 70.94 2019099044-0811 09/03/11 01 WATER OP-WELLS 51-510-54-00-5480 45.29 INVOICE TOTAL: 45.29 2961017043-0811 08/29/11 01 SEWER OP-LIFT STATION 52-520-54-00-5480 98.70 INVOICE TOTAL: 98.70 4085080033-0811 08/30/11 01 WATER OP-1991 CANNONBALL TRAIL 51-510-54-00-5480 123.16 INVOICE TOTAL: 123.16 -4- AE: 1U:16:31 CHECK REGISTER ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ---------------------------------------------------------------------------------------------------------------------------------- 11931 COMED COMMONWEALTH EDISON 4449087016-0811 09/03/11 01 SEWER OP-LIFT STATIONS 52-520-54-00-5480 766.01 INVOICE TOTAL: 766.01 * 4475093053-0811 08/30/11 01 WATER OP-610 TOWER LANE 51-510-54-00-5480 147.87 INVOICE TOTAL: 147.87 * 7090039005-0811 09/08/11 01 STREETS-LIGHTS 01-410-54-00-5480 21.47 INVOICE TOTAL: 21.47 * CHECK TOTAL: 1, 585.04 11932 DAVEAUTO DAVID L CHELSEN 18375 08/30/11 01 POLICE-BRAKES REPAIR 01-210-54-00-5495 265.00 INVOICE TOTAL: 265.00 * 18404 09/08/11 01 POLICE-BATTERY 01-210-54-00-5495 50.00 INVOICE TOTAL: 50.00 * 18408 09/08/11 01 POLICE-REAR STRUT AND BRAKE 01-210-54-00-5495 391.00 02 REPAIR ** COMMENT ** INVOICE TOTAL: 391.00 * 18413 09/09/11 01 POLICE-AXLE 01-210-54-00-5495 160.00 INVOICE TOTAL: 160.00 * 18414 09/09/11 01 POLICE-SQUAD REPAIR 01-210-54-00-5495 217.00 INVOICE TOTAL: 217.00 * CHECK TOTAL: 1,083.00 11933 DEPO DEPO COURT REPORTING SVC, INC 15112 09/12/11 01 POLICE-AUGUST 31 ADMIN HEARING 01-210-54-00-5467 175.00 INVOICE TOTAL: 175.00 * -5- HE: 10:16:31 CHECK REGISTER ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ---------------------------------------------------------------------------------------------------------------------------------- 11933 DEPO DEPO COURT REPORTING SVC, INC 15113 09/12/11 01 ADMIN-PUBLIC HEARING FOR BOND 01-110-54-00-5462 290.15 02 REFINANCING ** COMMENT ** INVOICE TOTAL: 290.15 CHECK TOTAL: 465.15 11934 EXELON EXELON ENERGY 200306900160 09/09/11 01 WATER OP-LIGHTS 51-510-54-00-5480 132.11 INVOICE TOTAL: 132.11 CHECK TOTAL: 132.11 11935 EYEMED FIDELITY SECURITY LIFE INS. 4216953 08/17/11 01 ADMIN SERVICES-SEPTEMBER 2011 01-640-52-00-5223 843.24 02 VISION CARE ** COMMENT ** INVOICE TOTAL: 843.24 CHECK TOTAL: 843.24 11936 FASTENAL FASTENAL COMPANY ILOSW7637 09/01/11 01 STREETS-SAFETY PIN 01-410-56-00-5620 36.00 INVOICE TOTAL: 36.00 CHECK TOTAL: 36.00 11937 FIRST FIRST PLACE RENTAL 216396-1 09/01/11 01 WATER OP-PAINT, FLAGS 51-510-56-00-5620 244.38 02 SEWER OP-PAINT, FLAGS 52-520-56-00-5620 244.38 INVOICE TOTAL: 488.76 216596-1 09/07/11 01 WATER OP-MARKING WAND, FLAGS 51-510-56-00-5620 91.91 INVOICE TOTAL: 91.91 CHECK TOTAL: 580.67 -6- 11E: 10:16:31 CHECK REGISTER ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ---------------------------------------------------------------------------------------------------------------------------------- 11938 GARDKOCH GARDINER KOCH & WEISBERG H-1845C-78829 08/18/11 01 ADMIN SERVICES-LAY-COM MATTERS 01-640-54-00-5461 55.50 INVOICE TOTAL: 55.50 * H-1961C-78852 08/22/11 01 ADMIN SERVICES-KENDALL 01-640-54-00-5461 1,202.50 02 MARKETPLACE MATTERS ** COMMENT ** INVOICE TOTAL: 1,202.50 * H-1974C 78824 08/18/11 01 ADMIN SERVICES-IEPA MATTERS 01-640-54-00-5461 211.05 INVOICE TOTAL: 211.05 * H-2364C-78826 08/18/11 01 ADMIN SERVICES-KIMBALL HILL 01-640-54-00-5461 174.16 02 MATTERS ** COMMENT ** INVOICE TOTAL: 174.16 * H-2644C-78851 08/22/11 01 ADMIN SERVICES-KENCOM MATTERS 01-640-54-00-5461 6, 612.15 INVOICE TOTAL: 6, 612.15 * CHECK TOTAL: 8,255.36 11939 HACH HACH COMPANY 7401389 08/31/11 01 WATER OP-WATER TESTING 51-510-56-00-5638 45.90 02 SOLUTION ** COMMENT ** INVOICE TOTAL: 45.90 CHECK TOTAL: 45.90 11940 HDSUPPLY HD SUPPLY WATERWORKS, LTD. 3585657 09/02/11 01 WATER OP-SR & SRII REGISTERS 51-510-56-00-5664 1,333.97 INVOICE TOTAL: 1,333.97 CHECK TOTAL: 1,333.97 11941 INTEGRYS INTEGRYS ENERGY SERVICES, INC -7- ME: 10:'16:31 CHECK REGISTER 3 ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT --------------------------------------------------------------------------------------------------------------------------------- 11941 INTEGRYS INTEGRYS ENERGY SERVICES, INC 17840025-1 08/31/11 01 WATER OP-2921 BRISTOL RIDGE 51-510-54-00-5480 5, 480.60 INVOICE TOTAL: 5, 480.60 * 17847432-1 08/31/11 01 WATER OP-2224 TREMONT STREET 51-510-54-00-5480 2,514.20 INVOICE TOTAL: 2,514.20 * 17873263-1 09/02/11 01 WATER OP-WELLS 3 & 4 51-510-54-00-5480 4,587.79 INVOICE TOTAL: 4,587.79 * 17879267-1 09/07/11 01 SEWER OP-420 FAIRHAVEN 52-520-54-00-5480 116.34 INVOICE TOTAL: 116.34 * CHECK TOTAL: 12,698.93 11942 IPRF ILLINOIS PUBLIC RISK FUND 2732 09/01/11 01 ADMIN SERVICES-OCTOBER ADMIN 01-640-52-00-5231 305.00 02 FEE ** COMMENT ** INVOICE TOTAL: 305.00 * 3275 09/01/11 01 ADMIN SERVICES-OCTOBER WORKERS 01-640-52-00-5231 10, 165.00 02 COMPENSATION ** COMMENT ** INVOICE TOTAL: 10, 165.00 * CHECK TOTAL: 10,470.00 11943 JCM JCM UNIFORMS, INC. 657422 08/31/11 01 POLICE-3 PAIRS OF PANTS 01-210-56-00-5600 245.85 INVOICE TOTAL: 245.85 CHECK TOTAL: 245.85 11944 KAMP KAMP / SYNERGY, LLC. -8- yE: 10:16:31 CHECK REGISTER ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ---------------------------------------------------------------------------------------------------------------------------------- 11944 KAMP KAMP / SYNERGY, LLC. 3570 08/30/11 01 WATER OP-SERVICE TO WATER 51-510-54-00-5462 880.00 02 SYSTEM TRAINING FOR 1 PERSON ** COMMENT ** INVOICE TOTAL: 880.00 CHECK TOTAL: 880.00 11945 KCCONC KENDALL COUNTY CONCRETE 28144 09/07/11 01 STREETS-CONCRETE 01-410-56-00-5640 424.00 INVOICE TOTAL: 424.00 CHECK TOTAL: 424.00 11946 KCRECORD KENDALL COUNTY RECORD 083111-64 08/31/11 01 ADMIN-PUBLICATION OF BOND 01-110-54-00-5426 151.20 02 ORDINANCE ** COMMENT ** INVOICE TOTAL: 151.20 CHECK TOTAL: 151.20 11947 KENPRINT ANNETTE M. POWELL 18513 08/22/11 01 ADMIN-500 BUSINESS CARDS 01-110-56-00-5610 29.00 INVOICE TOTAL: 29.00 * 18541 09/01/11 01 POLICE-NOTARY STAMP 01-210-56-00-5620 27.90 INVOICE TOTAL: 27.90 * 18544 09/02/11 01 COMM/DEV-500 BUSINESS CARDS 01-220-56-00-5620 29.00 INVOICE TOTAL: 29.00 * CHECK TOTAL: 85.90 11948 KONICAMI KONICA MINOLTA BUSINESS -9- ME: 10:'16:31 CHECK REGISTER 3 ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ---------------------------------------------------------------------------------------------------------------------------------- 11948 KONICAMI KONICA MINOLTA BUSINESS 218754212 08/30/11 01 POLICE-COPIER CHARGES 01-210-54-00-5430 21.36 INVOICE TOTAL: 21.36 * 218754213 08/30/11 01 ADMIN-COLOR COPIES CHARGE 01-110-54-00-5430 171.78 02 ADMIN-B/W COPIES CHARGE 01-110-54-00-5430 89.70 INVOICE TOTAL: 261.48 * 218754255 08/30/11 01 WATER OP-COPIER CHARGES 51-510-54-00-5430 5.38 INVOICE TOTAL: 5.38 * 218754256 08/30/11 01 POLICE-COPIER CHARGES 01-210-54-00-5430 52.27 INVOICE TOTAL: 52.27 * 218754257 08/30/11 01 COMM/DEV-COPIER CHARGES 01-220-54-00-5485 75.62 02 ENG-COPIER CHARGES 01-150-54-00-5485 75.61 INVOICE TOTAL: 151.23 * CHECK TOTAL: 491.72 11949 KOPYKAT KOPY KAT COPIER IMAGING SYSTEM 42606 08/23/11 01 FINANCE-PICK UP OF MACHINE TO 01-120-54-00-5495 250.00 02 RETURN TO LEASING COMPANY ** COMMENT ** INVOICE TOTAL: 250.00 CHECK TOTAL: 250.00 11950 LAWSON LAWSON PRODUCTS 9300064922 08/26/11 01 STREETS-LOCK WASHERS, CAP 01-410-56-00-5640 62.61 02 SCREWS, HEX NUTS, WASHERS ** COMMENT ** INVOICE TOTAL: 62.61 CHECK TOTAL: 62.61 -10- ME: 10:16:31 CHECK REGISTER ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ---------------------------------------------------------------------------------------------------------------------------------- 11951 MCKIRGN RANDY MCKIRGAN 71375 08/24/11 01 STREETS-BIO DIESEL 01-410-56-00-5695 979.77 02 WATER OP-BIO DIESEL 51-510-56-00-5695 979.77 03 SEWER OP-BIO DIESEL 52-520-56-00-5695 979.76 04 STREETS-OIL 01-410-56-00-5640 473.00 INVOICE TOTAL: 3,412.30 CHECK TOTAL: 3, 412.30 11952 MENLAND MENARDS - YORKVILLE 13654 08/29/11 01 WATER OP-BATTERIES 51-510-56-00-5620 10.47 INVOICE TOTAL: 10.47 14414 09/01/11 01 STREETS-HEX NUTS, WASHERS, HEX 01-410-56-00-5620 13.63 02 BOLTS ** COMMENT ** INVOICE TOTAL: 13.63 14632 09/02/11 01 STREETS-BOLTS 01-410-56-00-5620 7.76 INVOICE TOTAL: 7.76 14768 09/02/11 01 POLICE-WATER 01-210-56-00-5620 8.94 INVOICE TOTAL: 8.94 15650 09/06/11 01 POLICE-TANK LEVER, FILTER 01-210-56-00-5640 49.51 02 SLEEVE, DISC FILTER, BAGS, ** COMMENT ** 03 STEEL HANDLE, PUSH BROOM ** COMMENT ** INVOICE TOTAL: 49.51 17371 09/13/11 01 ADMIN-APPLIANCE LIGHT BULB 01-110-56-00-5610 0.98 INVOICE TOTAL: 0.98 CHECK TOTAL: 91.29 11953 MJELECT MJ ELECTRICAL SUPPLY, INC. NE: 10:16:3'1 CHECK REGISTER ID: AP2ISOOO.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ---------------------------------------------------------------------------------------------------------------------------------- 11953 MJELECT MJ ELECTRICAL SUPPLY, INC. 1123980-01 09/01/11 01 STREETS-BULBS 01-410-56-00-5656 52.00 INVOICE TOTAL: 52.00 CHECK TOTAL: 52.00 11954 NICOR NICOR GAS 00-41-22-8748 4-0811 09/06/11 01 ADMIN-1107 PRAIRIE LANE 01-110-54-00-5480 34.98 INVOICE TOTAL: 34.98 15-41-50-1000 6-0811 09/06/11 01 ADMIN-804 GAME FARM RD 01-110-54-00-5480 76.94 INVOICE TOTAL: 76.94 15-64-61-3532 5-0811 09/06/11 01 ADMIN-1991 CANNONBALL TRAIL 01-110-54-00-5480 34.21 INVOICE TOTAL: 34.21 20-52-56-2042 1-0811 09/07/11 01 ADMIN-420 FAIRHAVEN 01-110-54-00-5480 76.21 INVOICE TOTAL: 76.21 23-45-91-4862 5-0811 09/01/11 01 ADMIN-101 BRUELL STREET 01-110-54-00-5480 85.42 INVOICE TOTAL: 85.42 31-61-67-2493 1-0811 09/06/11 01 ADMIN-276 WINDHAM CIRCLE 01-110-54-00-5480 32.41 INVOICE TOTAL: 32.41 45-12-25-4081 3-0811 08/31/11 01 ADMIN-201 W. HYDRAULIC STREET 01-110-54-00-5480 23.12 INVOICE TOTAL: 23.12 46-69-47-6727 1-0811 09/06/11 01 ADMIN-1975 BRIDGE STREET 01-110-54-00-5480 86.11 INVOICE TOTAL: 86.11 49-25-61-1000 5-0811 08/31/11 01 ADMIN-1 VAN EMMON RD 01-110-54-00-5480 35.88 INVOICE TOTAL: 35.88 * 61-60-41-1000 9-0811 09/09/11 01 ADMIN-610 TOWER LANE 01-110-54-00-5480 48.27 INVOICE TOTAL: 48.27 * -12- IE: 10:16:31 CHECK REGISTER 3 ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ---------------------------------------------------------------------------------------------------------------------------------- 11954 NICOR NICOR GAS 66-70-44-6942 9-0811 09/07/11 01 ADMIN-100 RAINTREE RD 01-110-54-00-5480 86.82 INVOICE TOTAL: 86.82 * 77-35-71-1000 4-0811 09/06/11 01 ADMIN-131 E. HYDRAULIC 01-110-54-00-5480 29.48 INVOICE TOTAL: 29.48 * 83-80-00-1000 7-0811 09/09/11 01 ADMIN-610 TOWER LANE UNIT B 01-110-54-00-5480 24.35 INVOICE TOTAL: 24.35 * CHECK TOTAL: 674.20 11955 OFFWORK OFFICE WORKS 195302 09/07/11 01 COMM/DEV-POST-IT NOTES, LABELS 01-220-56-00-5610 44.19 02 FOLDERS, PADS. PENS, SCALE ** COMMENT ** INVOICE TOTAL: 44.19 * 195319 09/08/11 01 COMM/DEV-SCALE 01-220-56-00-5610 7.99 INVOICE TOTAL: 7.99 * CHECK TOTAL: 52. 18 11956 ORRK KATHLEEN FIELD ORR & ASSOC. 13530 09/06/11 01 ADMIN SERVICES-BOND MATTERS 01-640-54-00-5456 890.00 INVOICE TOTAL: 890.00 13531 09/06/11 01 ADMIN SERVICES-GENERAL LEGAL 01-640-54-00-5456 8,556.25 02 MATTERS ** COMMENT ** 03 DEVELOPER ESCROW-HERRON 90-031-31-00-0011 185.00 04 PROPERTY VARIANCE MATTERS ** COMMENT ** 05 DEVELOPER ESCROW-GRANDE 90-030-30-00-0011 277.50 06 RESERVE MATTERS ** COMMENT ** 07 ADMIN SERVICES-KENDALL 01-640-54-00-5456 508.75 -13- yE: 10:16:31 CHECK REGISTER ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ---------------------------------------------------------------------------------------------------------------------------------- 11956 ORRK KATHLEEN FIELD ORR & ASSOC. 13531 09/06/11 08 MARKETPLACE MATTERS ** COMMENT ** 09 ADMIN SERVICES-MEETINGS 01-640-54-00-5456 1, 000.00 10 TIFF-LEGAL MATTERS 85-850-54-00-5420 74.00 11 TIFF III-LEGAL MATTERS 88-880-54-00-5462 1,313.50 INVOICE TOTAL: 11, 915.00 * 13532 09/06/11 01 ADMIN SERVICES-KENCOM MATTERS 01-640-54-00-5456 3, 237.50 INVOICE TOTAL: 3,237.50 * CHECK TOTAL: 16,042.50 11957 PARADISE PARADISE CAR WASH 222168 09/01/11 01 POLICE-AUGUST CAR WASHES 01-210-54-00-5495 24.00 INVOICE TOTAL: 24.00 CHECK TOTAL: 24.00 11958 PATTEN PATTEN INDUSTRIES, INC. PM600200135 08/30/11 01 SEWER OP-COUNTRYSIDE LIFT 52-520-56-00-5613 1, 837.22 02 STATION TESTING ** COMMENT ** INVOICE TOTAL: 1,837.22 PM600200495 08/31/11 01 SEWER OP-PERFORMED TRANSFER 52-520-56-00-5613 1,315.34 02 TEST, REPLACED RELAYS & FUSES ** COMMENT ** INVOICE TOTAL: 1,315.34 T0530049814 08/29/11 01 STREETS-REPAIRED ENGINE LEAK 01-410-54-00-5495 683.68 02 WATER OP-REPAIRED ENGINE LEAK 51-510-54-00-5495 683.68 03 SEWER OP-REPAIRED ENGINE LEAK 52-520-54-00-5495 683.70 INVOICE TOTAL: 2,051.06 CHECK TOTAL: 5,203.62 -14- AE: 10:16:31 CHECK REGISTER ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ---------------------------------------------------------------------------------------------------------------------------------- 11959 PUBSAFDI PUBLIC SAFETY DIRECT, INC 22295 09/08/11 01 POLICE-REPAIR HIGH BAND RADIOS 01-210-54-00-5495 170.25 02 REPAIRED PINCHED WIRE FOR ** COMMENT ** 03 SPOTLIGHT AND LOOSE WIRE FOR ** COMMENT ** 04 RADAR ** COMMENT ** INVOICE TOTAL: 170.25 CHECK TOTAL: 170.25 11960 QUILL QUILL CORPORATION 6243688 08/22/11 01 ADMIN-TONER 01-110-56-00-5610 212.38 INVOICE TOTAL: 212.38 * 6486555 09/01/11 01 ADMIN-TONER 01-110-56-00-5610 197.99 INVOICE TOTAL: 197.99 * CHECK TOTAL: 410.37 11961 R0000244 JOYCE SKINNER 090611 09/06/11 01 ADMIN-REFUND OF OVERPAYMENT ON 01-000-13-00-1371 10.35 02 FINAL WATER BILL FOR ** COMMENT ** 03 ACC#0101101000-00 ** COMMENT ** INVOICE TOTAL: 10.35 CHECK TOTAL: 10.35 11962 R0000334 ANGEL ROJAS 090211 09/02/11 01 ADMIN-REFUND WATER PYMT TO 01-000-13-00-1371 420.34 02 PROPERTY OWNER AS TENANT MADE ** COMMENT ** 03 DUPLICATE PAYMENT ** COMMENT ** 04 ON ACCOUNT 0100105762-01 ** COMMENT ** INVOICE TOTAL: 420.34 CHECK TOTAL: 420.34 -15- ME: 10:16:31 CHECK REGISTER ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ---------------------------------------------------------------------------------------------------------------------------------- 11963 R0000594 BRIAN BETZWISER 100111 09/01/11 01 PW CAPITAL-INTEREST PYMT #35 21-211-92-00-8050 4,509.92 02 185 WOLF STREET ** COMMENT ** 03 PW CAPITAL-PRINCIPAL PYMT #35 21-211-92-00-8000 2,348.00 04 185 WOLF STREET ** COMMENT ** INVOICE TOTAL: 6,857.92 CHECK TOTAL: 6, 857.92 11964 R0000958 AMY BAUDOVIN 090211 09/02/11 01 ADMIN-REFUND FOR OVERCHARGE 01-000-13-00-1371 102.60 02 ON FINAL READING FOR WATER ** COMMENT ** 03 BILL TO ACC#0101342000-00 ** COMMENT ** INVOICE TOTAL: 102.60 CHECK TOTAL: 102.60 11965 R0000960 LLOYD LEFTRIDGE 090711 09/07/11 01 ADMIN-REFUND OVERPAYMENT OF 01-000-13-00-1371 25.00 02 FINAL WATER BILL FOR ** COMMENT ** 03 ACCOUNT #0105060420-14 ** COMMENT ** INVOICE TOTAL: 25.00 CHECK TOTAL: 25.00 11966 R0000965 KATHLEEN HERRON 091411 09/15/11 01 DEVELOPER ESCROW-REFUND 90-031-31-00-0011 661.72 02 REMAINING LEGAL DEPOSIT ** COMMENT ** INVOICE TOTAL: 661.72 CHECK TOTAL: 661.72 11967 SFBCT SWFVCTC -16- yE: 10:16:31 CHECK REGISTER ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT --------------------------------------------------------------------------------------------------------------------------------- 11967 SFBCT SWFVCTC 090211 09/02/11 01 ADMIN SERVICES-2ND QUARTER 01-640-54-00-5475 19, 619.90 02 2011 SFVCTC FRANCHISE DUES ** COMMENT ** INVOICE TOTAL: 19, 619.90 CHECK TOTAL: 19,619.90 11968 SHELL SHELL OIL CO. 065159923109-PW 09/05/11 01 STREETS-GASOLINE 01-410-56-00-5695 975.47 02 WATER OP-GASOLINE 51-510-56-00-5695 975.47 03 SEWER OP-GASOLINE 52-520-56-00-5695 975.49 INVOICE TOTAL: 2, 926.43 CHECK TOTAL: 2,926.43 11969 SRHARLEY STARVED ROCK H-D/BUELL 1116399 09/03/11 01 POLICE-CHANGED OIL & LUBRICANT 01-210-54-00-5495 357.50 02 PERFORMED 1K INSPECTION ** COMMENT ** INVOICE TOTAL: 357.50 116398 09/03/11 01 POLICE-CHANGED OIL & FLUIDS, 01-210-54-00-5495 337.60 02 PERFORMED 1K INSPECTION ** COMMENT ** INVOICE TOTAL: 337.60 CHECK TOTAL: 695.10 11970 TAPCO TAPCO I375673 08/29/11 01 MFT-POSTS, ANCHORS 15-155-56-00-5619 669.25 INVOICE TOTAL: 669.25 CHECK TOTAL: 669.25 11971 TRCONTPR TRAFFIC CONTROL & PROTECTION -17- NE: lu:'16:31 CHECK REGISTER ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ---------------------------------------------------------------------------------------------------------------------------------- 11971 TRCONTPR TRAFFIC CONTROL & PROTECTION 70474 08/30/11 01 MFT-SIGNS 15-155-56-00-5619 329.40 INVOICE TOTAL: 329.40 CHECK TOTAL: 329.40 11972 TROTSKY TROTSKY INVESTIGATIVE YORKVILLE PD 11-03 08/25/11 01 POLICE-POLYGRAPH FOR POLICE 01-210-54-00-5411 125.00 02 OFFICER APPLICANT ** COMMENT ** INVOICE TOTAL: 125.00 CHECK TOTAL: 125.00 11973 TUFFY KRIBBS AUTOMOTIVE, INC 24899 09/02/11 01 POLICE-OIL CHANGE 01-210-54-00-5495 23.96 INVOICE TOTAL: 23.96 * 24979 09/08/11 01 POLICE-OIL CHANGE 01-210-54-00-5495 23.96 INVOICE TOTAL: 23.96 * 24999 09/09/11 01 POLICE-OIL CHANGE 01-210-54-00-5495 25.95 INVOICE TOTAL: 25.95 * 25005 09/09/11 01 POLICE-OIL CHANGE 01-210-54-00-5495 23.96 INVOICE TOTAL: 23.96 * CHECK TOTAL: 97.83 11974 UPS UNITED PARCEL SERVICE 00004296X2341 08/20/11 01 WATER OP-2 PKGS TO ILEPA 51-510-54-00-5452 178.15 INVOICE TOTAL: 178.15 CHECK TOTAL: 178.15 _18_ NE: 10:16:31 CHECK REGISTER 3 ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ---------------------------------------------------------------------------------------------------------------------------------- 11975 VEOLIA VEOLIA ES SOLID WASTE MIDWEST T0184964 08/25/11 01 HEALTH & SANITATION-AUGUST 01-540-54-00-5442 99, 975.00 02 SERVICE ** COMMENT ** INVOICE TOTAL: 99, 975.00 CHECK TOTAL: 99, 975.00 11976 WATERSYS WATER SOLUTIONS UNLIMITED, INC 30468 08/31/11 01 WATER OP-PHOSPHATE 51-510-56-00-5638 508.50 INVOICE TOTAL: 508.50 CHECK TOTAL: 508.50 11977 WERDERW WALLY WERDERICH 090611 09/06/11 01 POLICE-AUGUST 3, 10, 24 & 31 01-210-54-00-5467 750.00 02 ADMIN HEARINGS ** COMMENT ** INVOICE TOTAL: 750.00 CHECK TOTAL: 750.00 11978 WHOLTIRE WHOLESALE TIRE 138796 09/06/11 01 POLICE-TIRE REPAIR 01-210-54-00-5495 15.00 INVOICE TOTAL: 15.00 138836 09/08/11 01 POLICE-TIRE REPAIR 01-210-54-00-5495 15.00 INVOICE TOTAL: 15.00 CHECK TOTAL: 30.00 11979 WIREWIZ WIRE WIZARD OF ILLINOIS, INC 12186 09/01/11 01 WATER OP-10/01/11 - 12/31/11 51-510-54-00-5462 310.50 -19- NE: IU:16:31 CHECK REGISTER S ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ---------------------------------------------------------------------------------------------------------------------------------- 11979 WIREWIZ WIRE WIZARD OF ILLINOIS, INC 12186 09/01/11 02 ALARM MONITORING ** COMMENT ** 03 SEWER OP-10/01/11- 12/31/11 52-520-54-00-5462 310.50 04 ALARM MONITORING ** COMMENT ** INVOICE TOTAL: 621.00 CHECK TOTAL: 621.00 11980 WTRPRD WATER PRODUCTS, INC. 0228191 09/01/11 01 WATER OP-ITRON END POINT, 51-510-56-00-5664 3, 480.00 02 BACKPLATES, GEL CONNECTORS ** COMMENT ** INVOICE TOTAL: 3, 480.00 * CHECK TOTAL: 3,480.00 11981 YBSD YORKVILLE BRISTOL 0551-008856053 08/31/11 01 WATER OP-AUGUST FEES 51-510-56-00-5638 5, 927.46 INVOICE TOTAL: 5, 927.46 CHECK TOTAL: 5, 927.46 11982 YBSD YORKVILLE BRISTOL 090111 09/01/11 01 TRUST & AGENCY-AUGUST 2011 95-000-78-00-9008 283,342.92 02 SANITARY FEES ** COMMENT ** INVOICE TOTAL: 283,342.92 CHECK TOTAL: 283,342.92 11983 YORKACE YORKVILLE ACE & RADIO SHACK 137559 04/11/11 01 STREETS-BOLTS & WASHERS 01-410-56-00-5640 13.14 INVOICE TOTAL: 13.14 _20_ 11E: 10:16:311 CHECK REGISTER 3 ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ---------------------------------------------------------------------------------------------------------------------------------- 11983 YORKACE YORKVILLE ACE & RADIO SHACK 138408 06/03/11 01 WATER OP-SCREWS 51-510-56-00-5620 1.60 INVOICE TOTAL: 1.60 * 138484 06/08/11 01 WATER OP-BOLTS 51-510-56-00-5620 3.19 INVOICE TOTAL: 3.19 * 138533 06/10/11 01 STREETS-PROPANE REFILL 01-410-56-00-5620 39.98 INVOICE TOTAL: 39.98 * 138608 06/15/11 01 STREETS-SCREW, NUT 01-410-56-00-5620 1.18 INVOICE TOTAL: 1.18 * 139283 07/22/11 01 STREETS-CHAINSAW CHAIN & 01-410-56-00-5640 59.98 02 MUFFLER ** COMMENT ** INVOICE TOTAL: 59.98 * 139328 07/25/11 01 STREETS-BOLTS 01-410-56-00-5620 13.14 INVOICE TOTAL: 13.14 * CHECK TOTAL: 132.21 11984 YORKCLER YORKVILLE CLERK'S ACCOUNT 148362 09/14/11 01 WATER OP-RELEASE WATER LIENS 51-510-54-00-5462 147.00 02 WATER OP-FILE WATER LIENS 51-510-54-00-5462 147.00 03 PW CAPITAL-FILE MOWING LIENS 21-211-54-00-5462 147.00 04 DEVELOPER ESCROW-ORDINANCE 90-031-31-00-0011 49.00 05 APPROVING SIGN VARIANCES ** COMMENT ** 06 FOR HERRON PROPERTY ** COMMENT ** INVOICE TOTAL: 490.00 CHECK TOTAL: 490.00 11985 YORKNAPA YORKVILLE NAPA AUTO PARTS -21- AE: 10:'16:31 CHECK REGISTER ID: AP215000.WOW CHECK DATE: 09/27/11 ECK # VENDOR # INVOICE INVOICE ITEM NUMBER DATE # DESCRIPTION ACCOUNT # ITEM AMT ---------------------------------------------------------------------------------------------------------------------------------- 11985 YORKNAPA YORKVILLE NAPA AUTO PARTS 973021 08/16/11 01 STREETS-BRAKE CLEANER 01-410-56-00-5640 10.89 INVOICE TOTAL: 10.89 CHECK TOTAL: 10.89 11986 YOUNGM MARLYS J. YOUNG 080311 09/10/11 01 DEVELOPER ESCROW-08/03/11 ZBA 90-031-31-00-0011 55.88 02 MINUTES ** COMMENT ** INVOICE TOTAL: 55.88 CHECK TOTAL: 55.88 TOTAL AMOUNT PAID: 587,745.06 -22- UNITED CITY OF YORKVILLE PAYROLL SUMMARY 9/10/2011 REGULAR OVERTIME TOTAL IMRF FICA TOTALS MAYOR&LIO. COM. $ 908.34 $ - $ 908.34 $ - $ 69.49 $ 977.83 CLERK 641.67 - 641.67 22.98 37.37 702.02 TREASURER 500.00 - 500.00 47.55 38.25 585.80 ALDERMAN 3,900.00 - 3,900.00 370.89 245.70 4,516.59 ADMINISTRATION 9,049.74 - 9,049.74 860.64 638.51 10,548.89 FINANCE 6,406.13 - 6,406.13 609.22 481.24 7,496.59 POLICE 70,971.88 7,909.80 78,881.68 429.84 5,807.24 85,118.76 COMMUNITY DEV. 7,192.80 - 7,192.80 649.03 539.17 8,381.00 STREETS 9,688.27 - 9,688.27 921.35 718.88 11,328.50 WATER 11,168.54 417.53 11,586.07 1,101.84 851.77 13,539.68 SEWER 7,129.17 - 7,129.17 677.97 523.82 8,330.96 PARKS 14,785.52 - 14,785.52 1,317.07 1,098.58 17,201.17 RECREATION 11,529.77 - 11,529.77 911.48 850.28 13,291.53 REC. CENTER 6,874.45 - 6,874.45 316.31 526.11 7,716.87 LIBRARY 16,419.50 - 16,419.50 889.50 1,228.34 18,537.34 TOTALS $ 177,165.78 $ 8,327.33 $ 185,493.11 $ 9,125.67 $ 13,654.75 $ 208,273.53 TOTAL PAYROLL $ 208,273.53 UNITED CITY OF YORKVILLE CITY COUNCIL Tuesday, September 27, 2011 PA YROLL DATE BI-WEEKLY 9/10/2011 $208,273.53 ACCOUNTS PAYABLE BILLS LIST 9/27/2011 $587,745.06 TOTAL DISBURSEMENTS $796,078.59 -24- Reviewed By: Agenda Item Number J 4 T Legal ❑ CA#2 Finance EST. , 1$36 Engineer ❑ _ Tracking Number O� ® � City Administrator ❑ 1sw �O Consultant ❑ RC ADM 2011-46 kE Agenda Item Summary Memo Title: Treasurer's Report for August 2011 Meeting and Date: City Council—09/27/11 Synopsis: Council Action Previously Taken: Date of Action: Admin 9/15/11 Action Taken: Move forward to City Council consent agenda. Item Number: ADM 2011-46 Type of Vote Required: Majority Council Action Requested: Approval Submitted by: Rob Fredrickson Finance Name Department Agenda Item Notes: UNITED CITY OF YORKVILLE TREASURER'S REPORT-for the period ended August 31,2011 Cash Basis %of %of Projected BGN Fund Revenues YTD Expenses YTD Ending Fund Balance August Revenues YTD Revenues Budget Budget August Expenses YTD Expenses Budget Budget Balance General Fund 01-General (271,900) 1,243,761 4,664,212 11,491,374 41% 1,134,052 3,316,868 10,727,492 31% 1,075,444 Special Revenue Funds 15-Motor Fuel Tax 640,399 110,120 210,770 1,01 1,000 21% 5,010 45,493 661,000 7% 805,676 79-Parks and Recreation 231,558 89,910 485,927 1,175,710 41% 100,394 401,085 1,189,210 34% 316.400 72-Land Cash (388,625) 1,026 318,809 420,500 76% 62,331 203,821 301,084 68% (273,637) 85-Fox Industrial TIF 569,790 9,040 148,834 - 0% 907 4,512 - 0% 714,112 87-Countryside TIF 2,178,550 288 717 10,250 7%r - 65,664 307,543 21% 2,113,603 88-Downtown TIF 209,760 934 45,269 88,550 51% 555 1,804 516,840 0% 253,226 11-Fox Hill SSA 17,942 577 2,512 3,786 66% 614 1,994 3,804 52% 18,460 12-Sunflower SSA 11,922 1,392 5,157 7,530 68% 1,309 3,268 9,078 36% 13,812 Debt Service Fund 42-Debt Service 8,653 48,599 237,758 427,919 56% 375 69,334 429,669 16% 177,077 Capital Funds 16-Municipal Building (587,024) 300 2,400 5,250 46% - - - - (584,624) 22-Park and Recreation Capital 51,443 1,409 1,678 2,830 59% 292 1,167 123,500 1% 51,955 20-Police Capital 194,947 646 7,395 21,500 34% - 95 54,000 0% 202,247 21-Public Works Capital 108,743 2,155 17,872 35,900 50% 7,152 35,564 92,595 38% 91,051 23-City-Wide Capital 652 12,769 63,140 416,600 15% - 125,000 360,0(10 35% (61,208) Enterprise Funds* 51-Water 695,723 478,549 1,023,380 2,694,979 38% 189,554 924,182 2,571,858 36% 794,921 52-Sewer 2,377,831 341,878 1,659,732 3,105,490 53% 92,152 621,163 2,919,989 21% 3,416,401 80-Recreation Center (195,087) 51,704 208,879 611,000 34% 45,513 256,869 691,738 37% (243,077) Library Funds 82-Library Operations 317,336 90,329 443,046 736,950 60% 378,509 518,279 [,060,275 49% 242,103 83-Library Debt Service - 88,627 450,495 720,800 62% - 185,400 720,800 26% 265,095 84-Library Development Fees - 334,708 335,621 341,000 98% - 3,130 4,000 78% 332,491 Total Funds 6,172,614 2,908,720 10,333,603 23,328.918 44% 2,018,718 6,784,690 22,743,475 30% 9,721,527 As Treasurer of the United City of Yorkville,I hereby attest,to the best of my knowledge,that the information contained in this Treasurer's Report is accurate as of the date detailed herein. Further information is available in the Finance Department. William Powell,Treasurer Prepared by the Finance Department *Fund Balance Equivalent C/p� Reviewed By: Agenda Item Number J �. -�, 0-h Legal ❑ CA#3 fix, I Finance ❑ EST. 1836 Engineer ■ City Administrator ❑ Tracking Number Consultant ❑ PW 2011-58 K°�i,ccw,ry Agenda Item Summary Memo Title: Traffic Control Signs on VanEmmon Meeting and Date: City Council 09/27/11 Synopsis: Replace existing yield signs on Mill St. at E. Van Emmon with stop signs. Council Action Previously Taken: Date of Action: PW 9/20/11 Action Taken: Committee recommends stop signs on Mill St. at E.Van Emmon. Leave Heustis/Van Item Number: PW 2011-58 Emmon intersection as is. Type of Vote Required: Majority Council Action Requested: Approval Submitted by: Brad Sanderson Engineering Name Department Agenda Item Notes: See attached ordinance and staff memo from the PW Committee meeting. Ordinance No. 2011- ORDINANCE OF THE UNITED CITY OF YORKVILLE, KENDALL COUNTY,ILLINOIS AMENDING THE TRAFFIC SCHEDULE AND INDEX WHEREAS,the United City of Yorkville,Kendall County,Illinois,has designated certain intersections within the City as yield intersections and has identified the corner for placement of yield signs at such intersections; and, WHEREAS, after extensive investigation and study of traffic patterns, it has been determined that an additional intersection should be designated as a yield intersection; and, WHEREAS,the additional yield intersection,as hereinafter set forth,has been determined to be in conformance with the current Manual on Uniform Traffic Control Devices. NOW THEREFORE BE IT ORDAINED by the Mayor and City Council of the United City of Yorkville, Kendall County, Illinois,that the traffic schedule and index regarding yield-sign control is hereby amended by adding the following: Section L The Traffic Schedule and Index regarding Stop Sign Control is hereby amended by removing the following: Mill Street to Yield for E. Van Emmon Street. Section IT The Traffic Schedule and Index regarding Stop Sign Control is hereby amended by adding the following: Mill Street to Stop for E. Van Emmon Street. Section III. This Ordinance shall be in full force and effect from and after its passage and approval as provided by law. Passed by the City Council of the United City of Yorkville,Kendall County,Illinois,this day of A.D. 2011. City Clerk CHRIS FUNKHOUSER GEORGE GILSON, JR. CARLO COLOSIMO DIANE TEELING JACKIE MILSCHEWSKI MARTY MUNNS ROSE SPEARS LARRY KOT APPROVED by me, as Mayor of the United City of Yorkville,Kendall County,Illinois,this day of , A.D. 2011. Mayor .��° C/ry Memorandum EST 1,.1 AE 1836 To: Bart Olson, City Administrator From: Brad Sanderson, EEI ��v CC: Eric Dhuse, Director of Public Works Krysti Barksdale-Noble, Community Dev. Dir. C��`�2 Lisa Pickering, Deputy City Clerk Date: September 14, 2011 Subject: Van Emmon Signage As requested, we have investigated the signage located at the intersections of Heustis and Van Emmon and Mill and Van Emmon. Our general findings were as follows: The governing entity on traffic control Signage is the Manual on Uniform Traffic Control Devices (MUTCD). The manual states as follows in regards to yield sign installation: Guidance: Engineering judgment should be used to establish intersection control. The following factors should be considered: A. Vehicular, bicycle, and pedestrian traffic volumes on all approaches; B. Number and angle of approaches; C. Approach speeds; D. Sight distance available on each approach; and E. Reported crash experience. YIELD or STOP signs should be used at an intersection if one or more of the following conditions exist: A. An intersection of a less important road with a main road where application of the normal right-of-way rule would not be expected to provide reasonable compliance with the law; B. A street entering a designated through highway or street; andlor C. An unsignalized intersection in a signalized area. In addition, the use of YIELD or STOP signs should be considered at the intersection of two minor streets or local roads where the intersection has more than three approaches and where one or more of the following conditions exist: A. The combined vehicular, bicycle, and pedestrian volume entering the intersection from all approaches averages more than 2,000 units per day; B. The ability to see conflicting traffic on an approach is not sufficient to allow a road user to stop or yield in compliance with the normal right-of-way rule if such stopping or yielding is necessary; andlor C. Crash records indicate that five or more crashes that involve the failure to yield the right-of- way at the intersection tinder the normal right-of-way rule have been reported within a 3-year period, or that three or more such crashes have been reported within a 2 year period. Our comments in regard to the conditions noted are as follows: • Van Emmon appears to be the more heavily traveled street. • Sight distance is poor at both intersections. • There have been six reported accidents at the Heustis Street intersection in the last five years. • There have been 11 reported accidents at the Mill Street intersection in the last five years. • There is inconsistency in the signage at the intersections (thru at Heustis, yield on Mill) potentially causing driver confusion. It is also our understanding that the stop signs were installed on Van Emmon at Heustis due to past bus route concerns. Based on the observed conditions, we would recommend the following: • Installation of stop signs on Heustis and Mill Streets at Van Emmon, due to the traffic volume on Van Emmon and sight distance issues at both intersections. • Removal of the stop signs on Van Emmon at Heustis to make Van Emmon a complete through street, only if we are able to remedy the sight distance issue at the northwest corner of the intersection. We will be prepared to discuss this issue in further detail at the committee meeting. If you have any questions or need additional information,please call. "tipt�r' • lip -All Y ( k� l• Ae AL Op t + r 1 , .r :�26111 Eurupa TcL f+ olOf - d� Imajeiy Dale, 413wc 41'38`27.3CafV 88'.5'3875"W clev 6-Y It 31t CIP Reviewed By: Agenda Item Number J� 0'0 Legal ❑ CA#4 EST. , � 1836 Finance ❑ Engineer ■ Tracking Number City Administrator ❑ 0� ° �� Consultant ❑ pW 2011-31 Agenda Item Summary Memo Title: Kendall Marketplace Infrastructure Improvements—Bid Results Meeting and Date: City Council 09/27/11 Synopsis: Review of Bids Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Brad Sanderson Engineering Name Department Agenda Item Notes: See attached memo. 0� ``° Cl J �. -a Memorandum EST �; To: Bart Olson, City Administrator �- lass From: Brad Sanderson, EEI CC: Eric Dhuse, Director of Public Works ail Krysti Barksdale-Noble, Community Dev. Dir. E r .,� Lisa Pickering, Deputy City Clerk Date: September 15, 2011 Subject: Kendall Marketplace Improvements Bids were received, opened and tabulated for work to be done on the above referenced project at 11:00 a.m., September 15, 2011. Representatives of contractors bidding the project and our firm were in attendance. A tabulation of the bids and the engineer's estimate is attached for your information and record. The apparent low bidder, Wilkinson Excavating failed to sign their bid proposal form with their original bid. They have since signed the proposal form. The bid documents state the following in regards to bidding technicalities: The Awarding Authority reserves the right to waive technicalities and to reject any or all proposals as provided in BLRS Special Provision for Bidding Requirements and Conditions for Contract Proposals contained in the "Supplemental Specifications and Recurring Special Provisions". The Supplemental Specifications and Recurring Special Provisions further state that the "Right is reserved to reject any or all proposals, to waive technicalities, or to advertise for new proposals, if in the judgment of the Awarding Authority, the best interests of the Awarding Authority will be promoted thereby". We have spoken to the City Attorney and she has acknowledged that based on the above the City has the ability to waive the technicality and award the contract to the apparent low bidder. Accordingly, we recommend that the City waive the above noted technicality and recommend the acceptance of the bid and approval of award be made to the low bidder, Wilkinson Excavating, 725 E. LaSalle Street, Somonauk, IL 60552 in the amount of$87,041,50, which is approximately 23% under the Engineer's Estimate of$113,700.00. If you have any questions or require additional information, please call. BID TABULATION KENDALL MARKETPLACE IMPROVEMENTS UNITED CITY OF YORKVILLE KENDALL COUNTY,ILLINOIS ACLU-PAVING CO. D CONSTRUCTION ENCAP INC. GENEVA CONSTRUCTION CO. VJILMNSON EXCAVATING ENGINEER'S ESTIMATE KENDALL MARKETPLACE IMPROVMENTS BID TABULATION 2655 SOUTH 25TH AVENUE 14W S.BROADWAY 1709 AFTON ROAD P.O.BOX 998 725 EAST LASALLE STREET 52 Wheekr Road UNITED CITY OF YORKVILLE,KENDALL COUNTY,ILLINOIS BIDS RECD 09/15/11 BROADVIEW.IL 60135 COAL CITY.IL 60416 SYCAMORE,IL 6017a AURORA IL 60507 SOMONAUK,IL W552 Sugar Grove,IL 60554 ITEM UNIT UNIT UNIT UNIT UNIT UNIT NO. DESCRIPTION UNIT QUANTITY PRICE AMOUNT PRICE AMOUNT PRICE AMOUNT PRICE AMOUNT I PRICE AMOUNT PRICE AMOUNT 1 COMBINATION CONCRETE CURB A GUTTER TYPE 86.12 FOOT 250 22 SS 5DO.00 325.00 S6,25000 $25.00 S6,250.00 $28400 $7 000.00 $21.00 SS 250,00 525400 56,250.00 2 HOT-MIX ASPHALT BINDER COURSE IL-19.0.N50 2.5' TON 215 102.9 $22,123.50 $95.00 $20,425.00 $85,00 $18,275.00 587.00 $10,705.0 $78.00 $16,7700 585.00 $18.275.00 3 HOT-MIX ASPHALT SURFACE COURSE M1X'C'.N50 IS' TON SO 107.9 38632.00 $100600 $8000.00 590.00 57200.00 5100.00 58000.00 $85.D0 55800.00 3110.00 56800.00 4 BITUMINOUS MATERIALS PRIME COAT) GAL 150 5.3 $795.00 $5.001 $750.00 $3.00 $450600 54.00 $600600 32.50 5375.00 $2.00 $300 DO 5 MOT-60XASPHALT SURFACE REMOVAL.1.5 SY 935 8.3 $7760.50 $&DO $4675.00 $8.50 $7947.50 $10.00 59350.00 57.50 $7012450 55.00 $4675.00 6 AGGREGATE BASE COURSE TYPE B TON 1000 20 $19,800.00 $25.00 $25,000.00 $1150 $11,500600 579.50 1 S19,500,001 $14.00 S14.000.001 $2000 $20000,00 7 STONE WEDGE FOR CURB FOOT SBO 4.4 S3.872.00 53,130 52640.00 571.00 $968000 $3.20 31816400 $1430 $1144.00 $5600 $4.400.00 B FINE GRADING AGGREGATE BASE SY 800 6.5 55200.00 53.00 $2400.00 $15.00 512000.00 $1.60 $1280.00 52.00 $1600.00 $12600 39.600.00 9 FINE GRADING LOT L SUM 1 28OW $28,000.00 $25,00000 $25,00000 520.000.00 $20,00000 $10.500.00 570.500.00 S12 500.00 $12,500,00 $5.000.00 $5.ODO 00 10 RESTORATION ACRE 5.3 5600 S29,680.00 $10,000.00 $53 000.00 $3 750.D0 S19,875.00 S12,600.00 $66,780400 S3,800+00 $20,140.00 $3,000.00 315.900 DO 11 SANITARY MANHOLES TO BE ADJUSTED EACH 1 600 $800.20 $600.00 5600400 $2.500.00 $2.500.00 5900.00 $900.00 5350.00 5350000 $500.00 5500.00 12 TOPSOIL FURNISH AND PLACE 4' SY 1,000 5 S5,000.00 $3.00 $3,000.00 $2.50 $2,500.00 52.00 $2,000.00 51.10 S1 100.00 $20.00 $20,000.00 TOTAL FOR CONSTRUCTION COSTS 5137,163.00 5751,740.00 5718,177.50 $147,431.00 1 $87,041,50 3113,700.00 20,6358839% 33.4564644% 369379947% 29.6666667% -2364463500% %«/_ESTIMATE GWW\YOeK.MI20tttYOttJtA Kergep Marke ace lavwemeMatE OtaENa Evan 0 C/ry Reviewed By: Agenda Item Number e �. p J /, h Legal ❑ Mayor#1 �+ Finance ❑ EST. _ isss Engineer ❑ ` �. Tracking Number CO City Administrator ❑ 0<p avn��a, O Consultant El�—"C ,m CC 2011-110 El kE Agenda Item Summary Memo Title: KenCom Intergovernmental Agreement Meeting and Date: City Council—9/27/11 Synopsis: Council Action Previously Taken: Date of Action: CC 9/13/11 Action Taken: Amend county cost to $1,829,752 Item Number: CC 2011-107 Type of Vote Required: Council Action Requested: Submitted by: Mayor Golinski Name Department Agenda Item Notes: Resolution No. 2011- A RESOLUTION OF THE UNITED CITY OF YORKVILLE,KENDALL COUNTY,ILLINOIS APPROVING THE INTERGOVERNMENTAL AGREEMENT CREATING KENDALL COUNTY EMERGENCY PHONE SERVICE AND COMMUNICATION BOARD DATED NOVEMBER 18,2010 WITH CHANGE IN AMOUNT OF CONTRIBUTION OF KENDALL COUNTY WHEREAS, the County of Kendall, the Kendall County Sheriffs office, the Village of Newark, Lisbon-Seward Fire Protection District, Newark Fire Protection District, Little Rock- Fox Fire Protection District, Bristol-Kendall Fire Protection District and Oswego Fire Protection District approved and executed the Intergovernmental Agreement Creating Kendall County Emergency Phone Service and Communication Board dated November 18, 2010 (the "Agreement'); and, WHEREAS, the United City of Yorkville, Kendall County, Illinois, is desirous of approving the Agreement on the condition that the amount stated in Exhibit 1, Exhibit A, and Exhibit B as the annual contribution of Kendall County is replaced with $1.775 million. NOW, THEREFORE, BE IT RESOLVED by the Mayor and City Council of the United City of Yorkville, Kendall County, Illinois, that the Intergovernmental Agreement Creating Kendall County Emergency Phone Service and Communication Board dated November 18, 2010, is hereby approved on the condition that the amount stated of $ 1.6395 million in Exhibitl, Exhibit A and Exhibit B as the annual contribution of Kendall County is replaced with $1.775 million. Dated this day of September, 2011. Passed by the City Council of the United City of Yorkville, Kendall County, Illinois, this day of , A.D. 2011. CHRIS FUNKHOUSER GEORGE T. GILSON,JR. CARLO COLOSIMO DIANE TEELING JACQUELYN MILSCHEWSKI MARTY MUNNS ROSE SPEARS LARRY KOT Mayor Attest: City Clerk 2 INTERGOVERNMENTAL AGREEMENT CREATING KE M E SERVICE � t 3 CN ANM COMMUNICATIONS SOARED November 18,2010 WHEREAS,the VOWS of Kendall County have approved the development of an Enhanced 9-1-1 (E-9-1-1)Emergency Telephone Service,and, WHEREAS,the County of Kendall,Kendall County Sheriffs office,as well as each unit of local government therein dealing,with emergency Wrvicest viz. The County of Kendall,the City of Plano,the United City of Yorkville,the Village of Oswego,the Village of Newark, Lisbon-Seward Fire protection District,Newark Fine Protection District,Little Rack-Fox Fire Protection District,Bristol-Kendall Fire Protection District and Oswego Fire Protection District, have an interest in the creation and operation of a communications system to dispatch and communicate regarding the usual and customary functions of said bodies dealing with police, Fire and urgency Medical services(EMS)functions and; WHEREAS,the County of Kendall is willing to provide the physical location for such system and all of the participating units of local govearn went will provide the costa of operations and provide operations necessary dome€ore in excess of that provided by the telephone surcharge imposed upon the users within the County as outlined in Exhibit 1 attach,arid; WHEREAS,To the CxUnt permitted under 50 ILLS 750,the Emergency Telephone Symms Act,the K.enCom Executive Board shall direct the disbursement of all 9-1.1 surcharge funds collected. IT IS HEREBY AGREED AS FOLLOWS: I. That the County of Kendall shall appoint a board, hereinafter called the KcnConr Executive Board to perform the following fiinctions; PW rof9 a. Create and operate an Enhanced 4-1-1 Emergency Telephone System as provided by 501LCS 750,the Emergency Telephone Systems Act. b. operate a conventional dispatch system for police,fire and EMS services. c. Employ such persons necessary to effectuate the above. d. Determine from time to time the surcharge rate to be charged and tecotnmend any changes thereto to the County Board. Z. That the board to be appointed shall consist of twelve members who shall have the following qualifications: a. All members shall have the ability or experience to administer the E-9-1•1 Service,under the Statute. b. One member shall be the Shmiff of Kendall County. The Alternate for the Sheriff shall be the Chief Deputy.The alt+ctttate will serve in the absence of the Sheriff. c. One member and one alternate shall be appointed by the Chairman of the County Board with the advice and consent of the County Board and shall be a County Board Member.The alternate will serve in the absence of the primary member d. one member and one alternate from each of the four mimicipafities of the City of Piano,the United City of yorkville,the Village of Oswego,and the Village of Newark shall be appointed by the City"age MayorMtce *dent; and approved by the Chairtnan of the County Board with the advice and consent of the County Board. The Chairnim of the County Board shall 4Pmve such personas and alternate fmtn the respective Municipalities as designated by the Mayor or Village hV z or 9 President,and shall be Alderman,Trustees,Mayors or Village Presidents.The alternates will serve in the absence of the primary member e. one member and one altera►ate from each of the five Fire Pro eciion Districts of Lisbon-Seward,Newark,Little Rock-Fox,Bristol-Kendall,and Oswego shall be appointed by the President of the Fire Protection District with the advice and consent of the Firs Protection District Board of Trustees and approved by the Chairman of the County Board with the advice and consent of the County Board. The primary Fire protection District member shall be a Trustee of the rtspecttve Fire Protection District.. The alternates will serve in the absence of the primary member.Alternates shall be a trustee or chief officer of the respective Fire ftection District. f One member shall be a Utmber-At-Large who is a fegisaered voter of Kendall County who shall be appointed by The Chairman of the County Board with the advice and 0onscnt of the County Board. g. Only one person from each governQ»+eaW agency and the member-al-large repicsented by this agreement may cast a vote.Attenuates may only vote in the absence of the member appoitnt0d to the KenCom Executive Board.Wham the member is press►the attere tray not vote nor may they constitute a member for pWpose of detambiat ion of a quonarn. 3. All actions taktn by the Kag om Exe+ "Board will follow procedures established in Roberts Mutts of Order'ex's that a veto of any action may omm as follows. a. By the Member rtpromfing the County Board b. By two of the four members repremye"the four cities and villages. pale 3 os 9 c. By three of the five members representing the I=ire Protection Districts. it is further agreed,however-that any%°eto exercised hereunder may be overridden by an affirmation vote of eight(8)members of the KenCorn Executive Board. 4. That in design of the E9-1-1 System,a backup or secondary Public Safety Answering Point(PSAP)is necessary. The parties hereto agree that such PSAP shah be designed within the constraints of the primary' 9-1-1 telephone service provider for Kendall County 5. In design of the E-9-1-1 System,the parties alb,within design constraints of the primary 9-1-1 telephone service provider for ICertdall Conroy,all ricer~coming rrom the respective four cities ad villages to the Central PSAP,including all future xmcxations to said cities and villages shall be grouped to permit exclusion rom the Sysftm if in the future arty of said cities or villages should choose to operate independent of the countyuride system. 6. That each of the MWdeipalitles or fire protection districts hereto may,by giving 1,460 days notice to the Chairman of the County Board,withdraw from KOCam providing that compliance be made with 83 Illinois Adrninist"Wve Code,Part 725. Said notice shall be in writing and signed by the President of the Fire Protection District or the Mayor or Village President of the municipality, 7. Members of the KenCom Executive Board MY only be removed by the Cbairm n of the County Board with the advice Ond cartse W of the Mayor or Village President of a city or village,or President of the Board of Trustees of the Fire Protection District who appointexl the member to the Board- The parties do further'agree that upon rcquW by the Mayor,Village President,or PW 4 of 9 Fire Protection District President,any such respective member mill be removed.Any vacancy on the KenCom Executive Board must be filled within 90 days,or the County Board Chairman a ill appoint a member from that unit of local government ubo meets the same qualifrcations as set forth above. S. That the KenCom Executive Board as appoh'+ted hereunder shall meet and organize in accordance with the rules of organization in Robert's Rules of Order, including but not limited to the election of a President,Secretary and such other offieers as the Board may deem►from time to time neeessseuY. It is expressly agreed,however,that all members of the KCICom Executive Board as hereinabove structured shall be eligible for the Office of President except for the Sheriff of Kendall County, 9. That the parties expmessly aedrnowlex C that protocols may differ for dispatch between units of local government and the County SheriW s OffIce. It is the intent of this Agreement that central dispatch shall accommodate the individual needs of all parties to this Agreement to the cxt=t standardization requirments of the Illinois Commerce commission permit. 10.Upon creation of this KenCom Executive Board there is simultaneously created an Operations Board haeaftet referred to as moons Board. The purpose of that Operations Board is to coor&nae,monitor and overme,the actual operation of all communications under the jurisdiction of the K=Com Executive Board subject only to policy being,established by KenCom Executive Boaard.The members of the Operations Boat do be determined from time to time by the units of local government who are sipmfies to this Agrmwent,or as approved by the Executive Board.The Operations Board shall contain representatives from Nape S of 4 each unit of local government. Such members shall be persons who work on a day to day basis with the users of the E-9-1-1 system. Such membership of the operations Board is allocated as follows: Nine of Unit of Local tsovenatne �`•""' ' of Merhfscrs Kendall County SherifTs Office 1 United City of Yorkville I Village of Newark 1 City of Plano l Village of Oswego 1 Lisbon-Seward Fire protection Distinct l Newark Fire Protection District 1 Little stock-Fox Fift Protection District 1 Oswego Fire Protection District l Bristol-Kendall Fire Protection District 1 Appoiatatent as a member or alternate to the KenCom Operations Board shall be made by the units of local government being served by KenCom,and approved by the KenCorn Executive Board. The statutory responsibility of the Emergency Telephone Systems Board(E'i'SB) shall,upon ratification of this Agm=cnt by all participating units of local government' be assurned by flue KenCom Executive Board.Thcreaiter,the KenCom Execudve Board shell delegate to the OPecations Board the responsibility of the planning,design and operation of the E-9-1'I qstem- it is the intention of this Agra ment that the KenCom Executive Board shall continue to operate as rite fiscal and policy oversight Board for the E9-1-1 system. pale b d 9 As pari of the fiscal responsibility of the KenCom Executive Board,a 9-1-1 approved by the Board. The Kencont Operations surcharge budget shall be Prepared and board shall review and authorize payment of bills as they become due,on a monthly basis,as long as they are a part of the approved budget. At the Quarterly meeting of the KenCom Executive Board,a report will be presented by the Board's appointed'Treasurer, listing all bills paid for their review and approval. The Putties hereto ftuther exPmssiy age that the Du dor of Communications shall be selected by the KenCom Executive Boatxi and that'fiscal and policy jurisdiction shall be executed by the KenCom Executive Board.. It is fu nher aged that the employed Direc:tot of Communications shalt trot be an appointed rnembcs of the KenCom Executive Board. ]1.Any unit of local govemrnent hamuoder may hereafter choose to operate dispatch locally providing all E-9-1-1 disparah shalt corrtirtuc under the ausPim and operation of KenCom. 12.That the parties hereto ague that this Agreement shall be reviewed annually from the date that this agreement is signed by all psrdes. 13.No corrtpensatians shall be paid to any member of fire KenCoar Executive Board for official duties as a member of the KenCom Executive Board. 14.The mall County Eatml mcy Phone Service and Cotnmunicatiotrs Boatel shall comply with and be subjed to the open Meetings Act and the Freedom of Informafion Aet. The Executive Board shall meet quarterly and shall coMPly with the stag of the State of Illinois regarding meetings. This avvemmt shall be successor to all prior Ageecsnents and all prior Agreements are hereby nullified and repealed. PWI*r 9 15.If any pm vision of this Agreement is held to be invalid,that provision shall be stricken from this Agreement and the remaining pmN'isions shall continue in full force and effect to the fullest extent possible. Adopted this day of County of Kendall By: Attest: Adopted this — day of ' Kendall Cotutty Sheriffs tf"ice By: Attest: Adopted this day of City of Plaao By: Attest: Adopted this -- day of ' United City of Yorkville: By: Attest: Adopted this day of Village of Newark By: Attest: I of 9 Adopted this day of Village of Oswego By: Attest: Adopted this day. of } Lisbon•5ewwd Fire Protection District By: Attest: Adopted this„.______—.day of = Newark Fire Prowidon Distnet By: Auest: Adopt this _day of Little Rock-Fox Fire Protection District By: Attest; Adopted this day of Bristol.Kertdsll Fire Protection 13Wct By: AUest: Adopted this _ _day of -----�--' Oswego Fire Protection District By: Attest: PW4es 9 EXHIBIT I 1.'That the County of Kendall shall pay ar the soon of 1.6345 million dollars each ye towards the Cast of Ken Corn dispatching services. 2. That all Costs as provided herein tM described in the attach with 8 itutalaus4e of the of that provided for in paragraph one(1)sha11 be dime in accordance y av a of ttte actual system allocating the shared cost proportionately upon the CAD ticket cauart calls made by the jurisdiction of the participating e of the CAD ticket count shall be made based�n the July 3.That the three year aver and the ensuing allocation of cost would be based 1"to Iune 30s'dates for each respective year averaging preying July }"of upon the average CAD ticket count calls made for the three Y� each respective Year beginning on July 1,2010. an the I N day of May 2011 the County of Ken as one of the 4.Tliat conuncrtcirt8 able in the agencies will make its annual co ntributintt in tampon the I"�day of May+ �1leach o�'the same ter as all tlic agencies). Also cotton n8 agencies including the Kendall County Sheriff S office,shall pray Its�vC particip i�4 a8"� tlon is ear s of*e 1.5395 million "Per�=ge l(as defied in Exhibit 1b)for dre costs of opem' � l�It of The dollars bused upon the three Yom'average CAD ticket cawtt calls as about dpi to fWl ov May it or equally allocated over the obligations of the respective agencies tasty paid contribution obligation. ens months prior to the next yearly arattuat of Oswego,the City of Yorkville and the City of Providilag,however that the 01� her 1,20}} in the t�(2)y� Plano will pay�the first year�mmeencing on December pay, following stuns on December 1 2012 and Dee"° 1, the Dollars;Yorkville thereafter namely Decom Seven IUUS ►d($37,000-00) May I"of the applicable year:Oswego�' Twenty Two'Mousend($22,000-00);T'larto Sixteen($16,000.0 Dollars•skies based Munici ties shall pay in the same der as the other participating� foxegoiug p� upon their calculated share• budget deftciesicies for the two(2)budget Years begim� With regard to any the E TSB will pay the arr►aruxtt necessary to� December 1,2(112 and December 1,2013,the Tksausand�}50,000-00)Dollars per"yew- Executive budget up to the sum of(?�I�undred flY the Kern Coca Executive Board,shell S. On or before November l'"�Y�f�next ftsc$l year big May 1 have adopted tlrc Ken Com dispat ► here of the total of h�a05%to be and shell notify each of th+e participating age MO I°of the divided among the participating far the next fiscal year b� following Year. CAHISIT A Definttton "Cost" of KENCOM OP9f8tion Acwslst Agount sere l" 2008-08 PERSONNEL 64,566 0102.0354101 Dkedw 63,506 01024354105 Ase Oftg" 134,522 0i02436.4i02 SUPWAMM 735. 0 01024*4103 operetwo 103.?6'8 01024354106 ovadme 44,4W 0102-036-6110 HWW 4,283 0102.085114 sewom` 1,171,5 Tola4 P�4 79 SWAotod F#Mlp (MA t WO*4o Kan" Mftiws Comp.Its. to Ken" caunV IMRF P to genOod County H"I t Cam 4�#[14fv K COMM coMRAMIAL 90 141OZAX402 000mmowdobm 1.358 01024 3 DUm McMbeMh )s 788 01024364204 Cwnforshow 2•S 01024364w Tmkft 5,792 010216 liq*merA l�on� 0=4"* ¢tiiM➢ng/ 1,805 0102.070 0102 we thwisatdne pAnw .36 MOM"" 187 010241 +Fedo 4.inac 01024354109 �_o0w '.19,164 Tokd Co*x&*Ad CQMMODMES 1,637 0102 Off"SUPOM 320 0101 P~ In 0102435420 N 201 Tow t onvoodow OYMM 14,661 0102-W&OW �1e�.ivaac�A� 0102.0 - EtrrPl 14.881 7ogd 0 o w' i.s"Aw 06,010owdyaw misrr B percentages Cost All"O lou over SI 6m M11flou The following is the fbmula for how Cost aver 51.6395 Million dollars are to be allocated among the participating agencies• if one ar more of rite Agencies listed is not of this agmntfi dwir share of Cast shell be tonally allocated wnM the them Participating,agencies. Cost over S 1.6345 million dollars shall be allocated: i A to Fire Sect tea' 85%to Pol'we Setvicc e 0i" Within the Fire Service yc ncits.Cast all+ 0,to each I~im 8errit*ms's l be Pm rated to each Fire agency based on that agwWy`s rumo of the total Fire Soviet CAI) ticket cows made for a 3 year average pre July 1`of each"Sp®etnve Yell Eg on July 1,20M The AWI be used for the Police Soviet+8mcw. ,` D C/Ty Reviewed By: Agenda Item Number J� kfi Al Legal ❑ Admin#1 EST. Jn 1836 Finance ■ Engineer ❑ Trackin g Number City Administrator ■ Co:nty Sv+aV a Consultant ❑ ADM 2011-48 KzMeV County d<t E `i ❑ Agenda Item Summary Memo Title: Fiscal Year 2011 Budget Report Meeting and Date: City Council 09/27/11 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Discussion Submitted by: Rob Fredrickson Finance Naive Department Agenda Item Notes: ututeu l_uy 0I x orKvnje Schedule of Revenues,Expenditures and Changes in Fund Balance-Budgeted and Actual For the Year Ended April 30,2011 GENERAL FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget REVENUES Taxes O1-000-40-00-4000 REAL ESTATE TAXES 2,450,000 2,521,570 71,570 103% O1-000-40-00-4001 TOWN ROAD/BRIDGE TAX 160,000 164,296 4,296 103% 01-000-40-00-4030 MUNICIPAL SALES TAX 2,440,000 2,569,233 129,233 105% Municipal Utility Tax O1-000-40-004040 MUNICIPAL UTILITY TAX 565,000 605,833 40,833 107% O1-000-40-00-4041 UTILITY TAX-NICOR 396,000 268,166 (127,834) 68% O1-000-40-00-4042 UTILITY TAX-CABLE TV 190,000 228,452 38,452 120% 01-000-40-004043 UTILITY TAX-TELEPHONE 600,000 514,189 (85,811) 86% 01-000-40-00-4050 HOTELTAX 20,000 38,198 18,198 191% Admissions&Amusement Tax O1-000-40-00-3994 ADMISSIONS TAX 112,964 181,744 68,780 161% O1-000-40-00-3997 AMUSEMENT TAX 162,964 319 (162,645) 0% O1-000-40-00-4045 AUTO RENTAL TAX 3,421 8,298 4,877 243% 01-000-40-00-4044 BUSINESS DISTRICT TAX 150,000 289,015 139,015 193% 01-000-40-00-4080 PARA MUTUEL TAX - 5,131 5,131 0% TOTAL TAXES 7,250,349 7,394,444 144,095 1027 Intergovernmental O1-000-40-00-4020 STATE INCOME TAX 1,300,000 1,315,321 15,321 101% 01-000-40-00-4010 PERSONAL PROPERTY TAX 20,000 16,394 (3,606) 82% 01-000-40-00-4032 STATE USE TAX 237,063 240,047 2,984 101% Grants O1-000-45-00-4505 COPS GRANT-VESTS - 1,875 1,875 0% 01-000-45-00-4507 FEDERAL GRANTS 11,412 11,412 0% 01-00045-004508 STATE GRANTS - 15,630 15,630 0% O1-000-45-00-4511 POLICE-STATE TOBACCO GRANT 1,803 1,870 67 104% O1-000-45-00-4515 ENERGY&RECYCLING GRANT - 5,307 5,307 0% O1-000-45-00-4525 FULL CIRCLE GRANT - 17,442 17,442 0% TOTAL INTERGOVERNMENTAL 1,558,866 1,625,299 66,433 104% Charges for Service 01-000-42-00-4206 GARBAGE SURCHARGE 1,050,000 1,177,995 127,995 112% 01-000-42-00-4208 COLLECTION FEE-YBSD 121,503 116,087 (5,416) 96% O1-000-42-00-4288 MOWING INCOME - 3,960 3,960 0% TOTAL CHARGES FOR SERVICE 1,171,503 1,298,042 126,539 111% Licenses,Permits and Fees 01-000-42-00-4210 DEVELOPMENT FEES 80,000 73,350 (6,650) 92% 01-000-41-00-4100 LIQUOR LICENSE 30,000 38,903 8,903 130% O1-000-41-00-4101 OTHER LICENSES 4,500 2,670 (1,830) 59% O1-000-41-00-4110 BUILDING PERMITS 205,000 126,829 (78,171) 62% O1-000-42-00-4205 FILING FEES 3,000 - (3,000) 0% O1-000-42-00-4207 ZONING VARIANCE FEES 170 - (170) 0% TOTAL LICENSES,PERMITS AND FEES 322,670 241,752 (80,918) 757. Fines and Forfeits 01-000-43-00-4310 TRAFFIC FINES 151,275 95,289 (55,986) 63% 01-000-43-00-4320 ADMINISTRATIVE ADJUDICATION 50,000 25,457 (24,543) 51% O1-000-43-00-4325 POLICE TOWS 181,275 80,490 (100,785) 44% TOTAL FINES AND FORFEITS 382,550 201,236 (181,314) 537 1 GENERAL FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget Investment Income 01-000-46-00-4600 INVESTMENT INCOME 3,000 1,759 (1,241) 59% Other Revenues 01-000-44-00-4415 REIMB FOR LEGAL EXPENSES 150,000 46,951 (103,049) 31% 01-000-44-00-4416 REIMB FOR THE LIBRARY 40,582 (40,582) 0% 01-000-44-00-4412 INSURANCE REIMBURSEMENTS - 35,711 35,711 0% Health Insurance 01-000-40-00-3993 EMPLOY CONTRIB HEALTH REIMB 168,318 193,147 24,829 115% 01-000-40-00-3995 COBRA INS REIMB - 21,675 21,675 0% 01-000-40-00-3996 RETIREE INS REIMB - 39,671 39,671 0%n Other 01-000-42-00-4287 DEVELOPER SIGN REIMBURSEMENT 5,000 - (5,000) 0% 01-000-44-00-4411 REIMBURSEMENTS-POLICE PROTECTN 3,300 4,190 890 127% 01-000-44-00-4417 MISC.REIMBURSEMENTS - 63,680 63,680 0% 01-000-44-00-4414 WORKERS COMP REIMB 22,207 22,207 0% 01-000-44-00-4421 LIFE INSURANCE REIMB - 4,789 4,789 0% 01-000-45-00-4504 TRAFFIC SIGNAL REVENUE 14,925 33,067 18,142 222% 01-000-45-00-4510 CABLE CONSORTIUM FEES - 19,505 19,505 0% Donations - 01-000-44-00-4401 DARE DONATIONS 20 25 5 125% 01-000-44-00-4404 HANGING BASKET DONATIONS 2,000 2,759 759 138% Miscellaneous Income 01-000-42-00-4285 BEECHER LEASE AGREEMENT 12,000 4,000 (8,000) 33% 01-00042-00-4286 BEECHER RENTALS 2,000 1,600 (400) 80% 01-000-44-00-4407 HOLIDAY UNDER THE STARS 9,585 - (9,585) 0% 01-000-44-00-4419 POLICE SPECIAL DETAIL - 4,431 4,431 0% 01-000-44-00-4490 MISCELLANEOUS INCOME 1,000 9,628 8,628 963% 01-000-45-00-4506 MISC INTEGOVERNMENTAL - 2,196 2,196 0% 01-000-44-00-4499 BAD DEBT RECOVERY - 10,849 10,849 0% TOTAL OTHER REVENUES 408,730 520,082 111,352 127% TOTAL REVENUES 11,097,668 11,282,616 184,948 102% General Government Administration 01-110-50-00-5100 SALARIES-MAYOR 11,310 10,700 (610) 95% 01-110-50-00-5101 SALARIES-CITY CLERK 8,980 9,305 325 104% 01-110-50-00-5102 SALARIES-CITY TREASURER 6,500 6,105 (395) 94% 01-110-50-00-5103 SALARIES-ALDERMAN 50,320 52,455 2,135 104% 01-110-50-00-5104 SALARIES-LIQUOR COMMISSIONER 1,000 1,167 167 117% 01-110-50-00-5106 SALARIES-ADMINISTRATIVE 202,242 239,314 37,072 118% 01-110-50-00-5137 SALARIES-OVERTIME 575 223 (352) 39% 01-110-61-00-5300 SPECIAL COUNSEL 65,000 59,394 (5,606) 91% 01-110-61-00-5302 CORPORATE COUNCIL 130,000 117,960 (12,040) 91% 01-110-61-00-5303 LITIGATION COUNCIL 90,000 87,544 01-110-61-00-5311 CODIFICATION 8,000 4,159 (3,841) 52% (3,84]) 52% 01-110-62-00-5401 CONTRACTUAL SERVICES 8,000 6,594 (1,406) 82% 01-110-62-00-5404 CABLE CONSORTIUM FEE 50,000 75,262 25,262 151% 01-110-62-00-5406 OFFICE CLEANING 14,400 13,124 (1,276) 9 01-110-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 100 0% (]00) 0% 01-110-62-00-5436 TELEPHONE 20,000 11,315 (8,685) 57% 01-110-62-00-5438 CELLULAR TELEPHONE 1,200 1,205 5 100% 01-110-62-00-5439 TELEPHONE SYSTEMS MAINTENANCE 3,000 2,945 (55) 98% 01-110-64-00-5600 DUES 12,450 11,533 (917) 93% 01-110-64-00-5601 ILLINOIS MUNICIPAL LEAGUE DUES 1,200 1,179 (21) 98% 01-110-64-00-5603 SUBSCRIPTIONS 100 160 60 160% 01-110-64-00-5605 TRAVEL/MEALS/LODGING 1,000 790 01-110-64-00-5607 PUBLIC RELATIONS 150 55 (210) 37% (95) 37% 01-110-64-00-5611 KENDALL COUNTY PARATRANSIT 30,000 27,553 (2,447) 92% 01-110-64-00-5612 SENIOR SERVICE FUNDING 5,000 (5,000) 0% 2 GENERAL FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget 01-110-65-00-5800 CONTINGENCIES 10,000 75,000 65,000 750%r• 01-110-65-00-5802 OFFICE SUPPLIES 8,000 4,251 (3,749) 53% 01-110-65-00-5804 OPERATING SUPPLIES 7,000 4,461 (2,539) 64% 01-110-65-00-5808 POSTAGE&SHIPPING 14,000 8,055 (5,945) 58% 01-110-65-00-5809 PRINTING&COPYING 6,750 8,081 1,331 120% 01-110-65-00-5810 PUBLISHING&ADVERTISING 2,000 655 (1,345) 33% 01-110-72-00-6500 IMRF PARTICIPANTS 27,153 26,574 (579) 98% 01-110-72-00-6501 SOCIAL SECURITY&MEDICARE 26,463 22,375 (4,088) 85% 01-110-75-00-7002 COMPUTER EQUIP&SOFTWARE 850 1,944 1,094 229% 01-110-75-00-7003 OFFICE EQUIPMENT 608 608 0% 01-110-78-00-9002 NICOR GAS 31,000 21,735 (9,265) 70% TOTAL ADMINISTRATION 853,743 913,780 60,037 107% Finance 01-120-50-00-5106 SALARIES-FINANCE 259,690 201,586 (58,104) 78% 01-120-50-00-5202 BENEFITS-UNEMPLOY.COMP.TAX 38,000 77,786 39,786 205% 01-120-50-00-5203 BENEFITS-HEALTH INSURANCE 1,156,090 1,185,928 29,838 103% 01-120-50-00-5204 BENEFITS-GROUP LIFE INSURANCE 28,240 24,060 (4,180) 85% 01-120-50-00-5205 BENEFITS-DENTAL VISION ASST 100,880 99,350 (1,530) 98% 01-120-61-00-5304 AUDIT FEES&EXPENSES 57,700 43,500 (14,200) 75%v 01-120-61-00-5310 EMPLOYEE ASSISTANCE 4,000 2,425 (1,575) 61% 01-120-62-00-5400 INSURANCE-LIABILITY&PROP. 344,129 325,906 (18,223) 95% 01-120-62-00-5401 CONTRACTUAL SERVICES 28,000 18,803 (9,197) 67% 01-120-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 1,800 838 (962) 47% 01-120-62-00-5411 MAINTENANCE-COMPUTERS 500 - (500) 0% 01-120-62-00-5412 MAINTENANCE-PHOTOCOPIERS 27,000 18,028 (8,972) 67% 01-120-62-00-5437 ACCTG SYSTEM SERVICE FEE 15,000 10,728 (4,272) 72% 01-120-62-00-5438 CELLULAR TELEPHONE 1,010 633 (377) 63% 01-120-64-00-5600 DUES 1,600 750 (850) 47% 01-120-64-00-5603 SUBSCRIPTIONS/BOOKS 250 152 (98) 61% 01-120-65-00-5802 OFFICE SUPPLIES 2,000 488 (1,512) 24% 01-120-65-00-5804 OPERATING SUPPLIES 3,500 1,032 (2,468) 29% 01-120-65-00-5808 POSTAGE&SHIPPING 2,500 474 (2,026) 19% 01-120-65-00-5809 PRINTING&COPYING 1,000 - (1,000) 0% 01-120-65-00-5844 MARKETING-HOTEL TAX 20,000 33,255 13,255 166% 01-120-72-00-6500 IMRF PARTICIPANTS 25,190 18,759 (6,431) 74% 01-120-72-00-6501 SOCIAL SECURITY&MEDICARE 29,070 15,326 (13,744) 53% 01-120-75-00-7002 COMPUTER EQUIP&SOFTWARE 5,000 1,761 (3,239) 35% 01-120-75-00-7003 OFFICE EQUIPMENT 250 - (250) 0% 01-120-78-00-9001 CITY TAX REBATE 1,050 812 (238) 77% 01-120-78-00-9003 SALES TAX REBATE 620,000 863,793 243,793 139% 01-120-78-00-9004 BUSINESS DISTRICT REBATE 150,000 283,777 133,777 189% 01-120-78-00-9013 ADMISSIONS TAX REBATE 63,000 99,959 36,959 159% 01-120-78-00-9099 BAD DEBT - 91,278 91,278 0% TOTAL FINANCE 2,986,449 3,421,187 434,738 115% Community Relations 01-130-50-00-5106 SALARIES-PUBLIC RELATIONS 63,750 63,359 (391) 99% 01-130-62-00-5401 CONTRACTUAL SERVICES 4,800 3,475 (1,325) 72% 01-130-62-00-5438 CELLULAR TELEPHONE 540 279 (261) 5 01-130-64-00-5603 SUBSCRIPTIONS&BOOKS 100 0% (100) 0% 01-130-64-00-5607 PUBLIC RELATIONS 1,750 - (1,750) 0% 01-130-65-00-5802 OFFICE SUPPLIES 750 130 (620) 17% 01-130-65-00-5808 POSTAGE&SHIPPING 3,500 1,630 (1,870) 47% 01-130-65-00-5809 PRINTING&COPYING 1,000 (],000) 0% 01-130-65-00-5810 PUBLISHING&ADVERTISING 7,500 5,977 (1,523) 80% 01-130-72-00-6500 IMRF PARTICIPANTS 6,184 4,004 (2,180) 65% 01-130-72-00-6501 SOCIAL SECURITY&MEDICARE 4,877 3,935 (942) 81% 01-130-78-00-9010 COMMUNITY EVENTS 6,000 526 (5,475) 9% 01-130-78-00-9013 HOLIDAY UNDER THE STARS 9,585 - (9,585) 0% TOTAL COMMUNITY RELATIONS 110,336 83,315 (27,021) 76% 3 GENERAL FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget Engineering 01-150-50-00-5107 SALARIES-ENGINEERING 263,233 235,552 (27,681) 89% 01-150-50-00-5137 SALARIES-OVERTIME 500 87 (413) 17%r. 01-150-62-00-5401 CONTRACTUAL SERVICES 30,000 4,578 (25,422) 15% 01-150=62-00-5403 FEES 2,550 1,000 (1,550) 39% 01-150-62-00-5409 MAINTENANCE-VEHICLES 1,500 1,303 (197) 87% 01-150-62-00-5410 MAINTENANCE-OFFICE EQUIP 500 - (500) 0% 01-150-62-00-5411 MAINTENANCE-COMPUTERS 500 (500) 0% 01-150-62-00-5421 WEARING APPAREL 100 - (100) 0% 01-150-62-00-5438 CELLULAR TELEPHONE 3,000 1,340 (1,660) 45% 01-150-64-00-5600 DUES 1,000 428 (572) 43% 01-150-64-00-5616 BOOKS&PUBLICATIONS 130 126 (4) 97% 01-150-65-00-5801 ENGINEERING SUPPLIES 2,000 928 (1,072) 46% 01-150-65-00-5802 OFFICE SUPPLIES 1,250 1,006 (244) 80% 01-150-65-00-5808 POSTAGE&SHIPPING 500 257 (243) 51% 01-150-65-00-5809 PRINTING&COPYING 1,500 1,116 (384) 74% 01-150-72-00-6500 IMRF PARTICIPANTS 25,582 21,727 (3,855) 85% 01-150-72-00-6501 SOCIAL SECURITY&MEDICARE 20,176 17,409 (2,767) 86% 01-150-75-00-7002 COMPUTER EQUIPMENT&SOFTWARE 3,300 2,627 (673) 80% 01-150-75-00-7003 OFFICE EQUIPMENT 500 - (500) 0% 01-150-78-00-9015 ENERGY&RECYCLING GRANT - 5,307 5,307 0% TOTAL ENGINEERING 357,821 294,791 (63,030) 82% TOTAL GENERAL GOVERNMENT 4,308,349 4,713,073 404,724 109% Public Safety Police Department 01-210-50-00-5107 SALARIES-POLICE 1,316,326 1,167,964 (148,362) 89% 01-210-50-00-5131 SALARIES-CHIEF/LT./SERGT. 673,166 660,249 (12,917) 98% 01-210-50-00-5134 SALARIES-CROSSING GUARD 25,000 17,381 (7,619) 70% 01-210-50-00-5135 SALARIES-POLICE CLERKS 212,386 156,502 (55,884) 74% 01-210-50-00-5136 SALARIES-PART TIME 39,000 30,604 (8,396) 78%n 01-210-50-00-5137 SALARIES-OVERTIME 60,000 61,250 1,250 102% 01-210-50-00-5200 CADET PROGRAM 13,500 12,045 (1,455) 89% 01-210-50-00-5205 OVERTIME-GRANT REIMB - 21,337 21,337 0% 01-210-50-00-5206 POLICE SPECIAL DETAIL - 4,432 4,432 0% 01-210-61-00-5300 LEGAL SERVICES 20,000 - (20,000) 0% 01-210-62-00-5401 CONTRACTUAL SERVICES - 722 722 0% 01-210-62-00-5408 MAINTENANCE-EQUIPMENT 9,750 6,286 (3,464) 64% 01-210-62-00-5409 MAINTENANCE-VEHICLES 47,000 43,648 (3,352) 93% 01-210-62-00-5411 MAINTENANCE-COMPUTERS 2,500 272 (2,228) 11% 01-210-62-00-5412 MAINTENANCE-K9 1,000 11 (989) 1% 01-210-62-00-5414 WEATHER WARNING SIREN MAINT 4,000 3,513 (487) 88% 01-210-62-00-5421 WEARING APPAREL 10,000 10,586 586 106% 01-210-62-00-5422 COPS GRANT IV-VESTS 4,200 5,460 1,260 130% 01-210-62-00-5432 KENDALL CO.JUVENILE PROBATION 3,000 2,683 (317) 89% 01-210-62-00-5436 TELEPHONE 21,500 9,499 (12,001) 44% 01-210-62-00-5438 CELLULAR TELEPHONE 17,920 12,644 (5,276) 71% 01-210-62-00-5441 MTD-ALERTS FEE 5,150 6,660 1,510 129% 01-210-62-00-5442 NEW WORLD LIVE SCAN 15,000 10,281 (4,719) 69% 01-210-62-00-5443 ADMIN ADJUDICATION CONTRACTUAL 15,000 16,863 1,863 112% 01-210-64-00-5600 DUES 1,000 1,115 115 112% 01-210-64-00-5603 SUBSCRIPTIONS 350 - (350) 0% 01-210-64-00-5604 TRAINING&CONFERENCE 8,025 8,554 529 107% 01-210-64-00-5605 TRAVEL EXPENSES 6,575 1,873 (4,702) 28% 01-210-64-00-5606 COMMUNITY RELATIONS 500 391 (109) 78% 01-210-64-00-5607 POLICE COMMISSION 7,000 3,677 (3,323) 53% 01-210-64-00-5608 TUITION REIMBURSEMENT 2,800 1,808 (992) 65% 01-210-64-00-5610 GUN RANGE FEES 500 - (500) 0% 01-210-64-00-5611 SRT FEE 3,500 3,500 - 100% 01-210-64-00-5612 NEIGHBORHOOD WATCH 1,500 - (1,500) 0% 01-210-64-00-5613 CITIZENS POLICE ACADEMY 1,839 (1,839) 0% 01-210-64-00-5615 COMPLIANCE CHECKS 500 - (500) 0% 01-210-64-00-5616 DARE PROGRAM 3,000 2,629 (371) 88% 01-210-65-00-5801 SUPPLIES-GRANT RE1MB - 106 106 0% 01-210-65-00-5802 OFFICE SUPPLIES 3,000 2,933 (67) 98% 4 GENERAL FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget 01-210-65-00-5803 EVIDENCE TECH SUPPLIES 1,000 995 (5) 99% 01-210-65-00-5804 OPERATING SUPPLIES 8,500 6,066 (2,434) 71% 01-210-65-00-5808 POSTAGE&SHIPPING 3,000 986 (2,014) 33% 01-210-65-00-5809 PRINTING&COPYING 4,500 2,923 (1,577) 65%r 01-210-65-00-5810 PUBLISHING&ADVERTISING 100 86 (14) 86% 01-210-65-00-5812 GASOLINE 80,000 70,080 (9,920) 88% 01-210-65-00-5813 AMMUNITION 2,000 1,995 (5) 100% 01-210-65-00-5814 ADMIN ADJUDICATION OPERATING 1,000 - (1,000) 0% 01-210-72-00-6500 IMRF PARTICIPANTS 24,385 14,455 (9,930) 59% 01-210-72-00-6501 SOCIAL SECURITY&MEDICARE 178,962 157,082 (21,880) 88% 01-210-72-00-6502 POLICE PENSION 325,000 336,075 11,075 103% 01-210-75-00-7002 COMPUTER EQUIP&SOFTWARE 7,000 5,032 (1,968) 72% TOTAL POLICE DEPARTMENT 3,190,934 2,883,253 (307,681) 907 TOTAL PUBLIC SAFETY 3,190,934 2,883,253 (307,681) 90% Community Development Building and Zoning 01-220-50-00-5107 SALARIES-PLANNING&DEV. 287,132 269,607 (17,525) 94% 01-220-54-00-5430 PRINTING&DUPLICATING - - 0% 01-220-61-00-5300 LEGAL SERVICES 8,000 1,777 (6,223) 22% 01-220-61-00-5314 INSPECTIONS 25,000 17,387 (7,613) 70% 01-220-62-00-5401 CONTRACTUAL SERVICES 13,000 1,738 (11,262) 13% 01-220-62-00-5432 ECONOMIC DEVELOPMENT 45,000 45,000 - 100% 01-220-62-00-5438 CELLULAR TELEPHONE 1,500 1,318 (182) 88% 01-220-64-00-5600 DUES 1,500 1,016 (484) 68% 01-220-64-00-5604 TRAINING&CONFERENCES 200 115 (85) 58% 01-220-65-00-5802 OFFICE SUPPLIES 500 469 (31) 94% 01-220-65-00-5804 OPERATING SUPPLIES 3,500 712 (2,788) 20% 01-220-65-00-5808 POSTAGE&SHIPPING 1,000 230 (770) 23% 01-220-65-00-5809 PRINTING&COPYING 1,300 1,062 (238) 82% 01-220-65-00-5810 PUBLISHING&ADVERTISING 150 87 (63) 58% 01-220-65-00-5814 BOOKS&MAPS 500 493 (7) 99% 01-220-72-00-6500 IMRF PARTICIPANTS 27,851 24,175 (3,676) 87% 01-220-72-00-6501 SOCIAL SECURITY&MEDICARE 21,966 19,586 (2,380) 89% 01-220-75-00-7002 COMPUTER EQUIP&SOFTWARE 7,955 2,171 (5,784) 27% 01-220-75-00-7003 OFFICE EQUIPMENT 125 (]25) 0% 01-220-78-00-9016 FULL CIRCLE GRANT - 8,348 8,348 0% TOTAL BUILDING AND ZONING 446,179 395,291 (50,888) 897 TOTAL COMMUNITY DEVELOPMENT 446,179 395,291 (50,888) 89% Public Works Street Operations 01-410-50-00-5107 SALARIES-STREETS 243,472 285,143 41,671 117% 01-410-50-00-5137 SALARIES-OVERTIME 28,000 10,784 (17,216) 39% 01-410-61-00-5314 INSPECTIONS&LICENSES 700 470 (230) 67% 01-410-62-00-5401 CONTRACTUAL SERVICES 1,000 695 (305) 70% 01-410-62-00-5408 MAINTENANCE-EQUIPMENT 10,000 9,226 (774) 92% 01-410-62-00-5409 MAINTENANCE-VEHICLES 25,000 22,110 (2,890) 88% 01-410-62-00-5414 MAINTENANCE-TRAFFIC SIGNALS 15,000 36,568 21,568 244% 01-410-62-00-5415 MAINTENANCE-STREET LIGHTS 9,000 25,011 16,011 278% 01-410-62-00-5416 MAINTENANCE PROPERTY 30,000 13,672 (16,328) 46% 01-410-62-00-5420 MAINTENANCE-STORM SEWER 5,000 5,473 473 109% 01-410-62-00-5421 WEARING APPAREL 4,200 2,386 (1,814) 57% 01-410-62-00-5434 RENTAL-EQUIPMENT 1,000 176 (824) 18% 01-410-62-00-5435 ELECTRICITY 75,000 89,784 14,784 120% 01-410-62-00-5438 CELLULAR TELEPHONE 4,020 2,053 (1,967) 51% 01-410-64-00-5604 TRAINING&CONFERENCES 2,000 180 (1,820) 9% 01-410-65-00-5804 OPERATING SUPPLIES 10,000 3,375 (6,625) 34% 01-410-65-00-5812 GASOLINE 32,000 29,350 (2,650) 92% 01-410-65-00-5815 HAND TOOLS 1,000 1,380 380 138% 01-410-65-00-5837 GRAVEL 1,500 427 (1,073) 28% 01-410-72-00-6500 IMRF PARTICIPANTS 26,332 27,424 1,092 104% 01-410-72-00-6501 SOCIAL SECURITY&MEDICARE 20,768 22,091 1,323 106% 5 GENERAL FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget 01-410-75-00-4404 HANGING BASKETS 2,000 2,048 48 102% 01-410-75-00-5418 MOSQUITO CONTROL 15,000 6,500 (8,500) 43%n 01-410-75-00-7004 SAFETY EQUIPMENT 500 516 16 103% 01-410-75-00-7101 IN TOWN ROAD PROGRAM 40,232 - (40,232) 0% 01-410-75-00-7102 TREE&STUMP REMOVAL 10,000 8,300 (1,700) 83% 01-410-75-00-7103 SIDEWALK CONSTRUCTION 4,000 1,225 (2,775) 31% TOTAL STREET OPERATIONS 616,724 606,368 (10,356) 98% Health&Sanitation 01-540-62-00-5442 GARBAGE SERVICES 1,140,000 1,177,611 37,611 103%r. 01-540-62-00-5443 LEAF PICKUP 6,000 4,560 (1,440) 76% TOTAL HEALTH AND SANITATION 1,146,000 1,182,171 36,171 103% TOTAL PUBLIC WORKS 1,762,724 1,788,539 25,815 101% TOTAL EXPENDITURES 9,708,186 9,780,155 71,969 101% EXCESS OF REVENUES OVER EXPENDITURES 1,389,482 1,502,461 112,979 108% Other Financing Sources(Uses) Transfers In 01-000-49-00-4902 REPAY OF PARK&REC LOAN 100,000 - (100,000) 0% 01-000-49-00-4915 TRANSFER FROM WATER OPERATIONS 91,863 91,863 100% 01-000-49-00-4920 TRANSFER FROM SEWER MAINT. 83,045 83,045 100% 01-000-49-00-4935 TRANSFER FROM LAND CASH 60,449 60,449 100% Transfers Out 01-110-99-00-9970 TRANSFER TO CW CAPITAL(LAND) (125,000) (125,000) - 100% 01-110-99-00-9975 TRANSFER TO CW CAPITAL (37,500) (10,484) 27,016 28% 01-120-99-00-9940 TRANSFER TO PARK&RECREATION (951,890) (951,890) - 100% 01-120-99-00-9941 TRANSFER TO PARK&REC-LOAN (100,000) - 100,000 0% 01-120-99-00-9942 TRANSFER TO POLICE CAPITAL (25,000) 25,000 0% 01-120-99-00-9965 TRANSFER TO DEBT SERVICE (429,404) (429,404) - 100% TOTAL OTHER FINANCING SOURCES(USES) (1,333,437) (1,281,421) 52,016 96% SURPLUS/(DEFICIT) 56,045 221,039 164,994 FUND BALANCE-BEGINNING OF YEAR (492,939) (492,939) FUND BALANCE-END OF YEAR (436,894) (271,900) 164,994 6 United City of Yorkville Schedule of Revenues and Expenditures-Budgeted and Actual For the Year Ended April 30,2011 LIBRARY FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget REVENUES Property Taxes 82-000-40-00-3992 LIBRARY BOND PROP.TAX 605,924 604,131 (1,793) 100% 82-000-40-00-4000 REAL ESTATE TAXES 650,000 648,060 (1,940) 100% TOTAL TAXES 1,255,924 1,252,191 (3,733) 100% Other Taxes 82-000-40-00-4010 PERSONAL PROPERTY TAX 5,000 7,217 2,217 144% Licenses,Permits and Fees 82-000-42-00-4270 PROGRAM FEES - 36 36 0% 82-000-42-00-4211 DEVELOPMENT FEES-BUILDING 20,000 8,825 (11,175) 44% 82-000-42-00-4215 DEVELOPMENT FEES-BOOKS 20,000 8,825 (11,175) 44% 82-000-42-00-4260 COPY FEES 3,000 3,339 339 111% 82-000-42-00-4261 LIBRARY SUBSCRIPTION CARDS 15,000 13,742 (1,259) 92% 82-000-42-00-4262 EXAM PROCTORING - 55 55 0% TOTAL LICENSES,PERMITS AND FEES 58,000 34,822 (23,178) 60% Fines 82-000-43-00-4330 LIBRARY FINES 9,000 14,161 5,161 157% Investment Income 82-000-46-00-4600 INVESTMENT INCOME 10,000 694 (9,306) 7% Contributions 82-000-44-00-4450 MEMORIALS 3,000 1,883 (1,117) 63% Grants 82-000-45-00-4560 LIBRARY PER CAPITA GRANT 17,500 17,193 (307) 98% Other Revenue Rental Income 82-000-42-00-4286 DVD RENTAL INCOME - 4,131 4,131 0% 82-000-42-00-4287 LIBRARY BLDG RENTAL 1,000 1,454 454 145% 82-000-44-00-4432 SALE OF BOOKS 500 300 (200) 60% TOTAL OTHER REVENUE 1,500 5,885 4,385 392% TOTAL REVENUE 1,359,924 1,334,046 (25,878) 98% EXPENDITURES 82-000-50-00-5107 SALARIES-LIBRARY 650,000 501,353 (148,647) 77% 82-000-50-00-5203 GROUP HEALTH INSURANCE 70,000 76,487 6,487 109% 82-000-50-00-5204 GROUP LIFE INSURANCE 2,000 1,200 (800) 60% 82-000-50-00-5205 DENTAL&VISION ASSISTANCE 6,000 6,159 159 103% 82-000-61-00-5322 BONDING 5,000 3,222 (1,778) 64% 82-000-61-00-5323 ATTORNEY 10,000 4,175 (5,825) 42% 82-000-62-00-5401 CONTRACT SERVICES 40,000 28,602 (11,398) 72% 82-000-62-00-5407 MAINTENANCE-BLDG/JANITORIAL 30,000 22,188 (7,812) 74% 82-000-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 20,000 2,180 (17,821) 11% 82-000-62-00-5412 MAINTENANCE-PHOTOCOPIER 15,000 1,007 (13,993) 7% 82-000-62-00-5435 ELECTRICITY 8,000 - (8,000) 0% 82-000-62-00-5436 TELEPHONE 8,000 9,055 1,055 113% 82-000-62-00-5437 NICOR GAS 40,000 11,484 (28,516) 29% 82-000-62-00-5438 DATABASE 15,000 3,888 (11,112) 26% 82-000-64-00-5603 SUBSCRIPTIONS 15,000 7,402 (7,598) 49% 7 LIBRARY FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget 82-000-64-00-5604 TRAINING&CONFERENCES 5,000 949 (4,051) 19% 82-000-64-00-5607 PUBLIC RELATIONS 2,000 112 (1,888) 6% 82-000-64-00-5616 EMPLOYEE RECOGNITION 4,000 93 (3,907) 2% 82-000-65-00-5800 CONTINGENCIES 144,561 6,705 (137,856) 5% 82-000-65-00-5802 OFFICE SUPPLIES 15,000 5,049 (9,951) 34% 82-000-65-00-5806 LIBRARY SUPPLIES 15,000 3,736 (11,264) 25% 82-000-65-00-5807 CUSTODIAL SUPPLIES 20,000 6,995 (13,005) 35% 82-000-65-00-5808 POSTAGE&SHIPPING 2,500 2,104 (396) 84% 82-000-65-00-5810 PUBLISHING&ADVERTISING 2,000 130 (1,870) 7% 82-000-65-00-5826 MILEAGE 1,000 593 (407) 59% 82-000-65-00-5832 VIDEOS 25,000 7,715 (17,285) 31% 82-000-65-00-5834 LIBRARY PROGRAMMING 20,000 8,172 (11,828) 41% 82-000-65-00-5835 LIBRARY BOARD EXPENSES 2,000 - (2,000) 0% 82-000-65-00-5836 BOOKS-ADULT 50,000 30,312 (19,688) 61% 82-000-65-00-5837 BOOKS-JUVENILE 50,000 40,713 (9,287) 81% 82-000-65-00-5838 BOOKS-AUDIO 30,000 9,526 (20,474) 32% 82-000-65-00-5839 BOOKS-REFERENCE 35,000 11,394 (23,606) 33% 82-000-65-00-5840 BOOKS-DEVELOPMENT FEE 20,000 9,343 (10,657) 47% 82-000-65-00-5841 MEMORIALS/GIFTS 3,000 1,622 (1,378) 54% 82-000-65-00-5842 BLDG-DEVELOPMENT FEES 20,000 33,423 13,423 167% 82-000-65-00-5843 CD'S/MUSIC 15,000 2,122 (12,878) 14% 82-000-65-00-5844 MEETING ROOM 1,000 800 (200) 80% 82-000-72-00-6500 IMRF PARTICPANTS 22,000 21,607 (393) 98% 82-000-72-00-6501 SOCIAL SECURITY/MEDICARE 55,000 37,766 (17,234) 69% 82-000-75-00-7002 COMPUTER EQUIPMENT&SOFTWARE 20,000 7,637 (12,363) 38% 82-000-75-00-7003 AUTOMATION 40,000 48,567 8,567 121% TOTAL EXPENDITURES 1,553,061 975,587 (577,474) 63% Capital Outlay 82-000-75-00-7703 BUILDING EXPANSION - 6,200 6,200 0% Debt Service 82-000-66-00-6012 2005B LIBRARY BOND 394,125 394,125 - 100% 82-000-66-00-6014 2006 LIBRARY BOND 211,800 211,800 - 100% TOTAL DEBT SERVICE 605,925 605,925 100% TOTAL EXPENDITURES 2,158,986 1,587,712 (571,274) 74% SURPLUS/(DEFICIT) (799,062) (253,666) 545,396 FUND BALANCE-BEGINNING OF YEAR 571,002 571,002 FUND BALANCE-END OF YEAR (228,060) 317,336 545,396 8 United laity of Yorkville Schedule of Revenues and Expenditures-Budgeted and Actual For the Year Ended April 30,2011 FOX HILL SSA FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget REVENUES 11-000-40-00-4002 FOX HILL LEVY 19,463 19,894 431 102% EXPENDITURES 11-000-65-00-5416 MAINTENANCE COMMON GROUNDS 3,458 4,178 720 121% SURPLUS/(DEFICIT) 16,005 15,716 (289) FUND BALANCE-BEGINNING OF YEAR 2,226 2,226 FUND BALANCE-END OF YEAR 18,231 17,942 (289) 9 United City of Yorkville Schedule of Revenues and Expenditures-Budgeted and Actual For the Year Ended April 30,2011 SUNFLOWER SSA FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget REVENUE 12-000-40-00-4002 SUNFLOWER LEVY 13,112 13,871 759 106% EXPENDITURES 12-000-65-00-5416 MAINTENANCE COMMON GROUNDS 8,253 8,137 (116) 99% SURPLUS/(DEFICIT) 4,859 5,734 875 FUND BALANCE-BEGINNING OF YEAR 6,188 6,188 FUND BALANCE-END OF YEAR 11,047 11,922 875 10 United City of Yorkville Schedule of Revenues and Expenditures-Budgeted and Actual For the Year Ended April 30,2011 MOTOR FUEL TAX FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget Intergovernmental 15-000-40-00-4060 MOTOR FUEL TAX ALLOTMENTS 355,000 425,971 70,971 120% 15-00040-00-4065 MFT HIGH GROWTH - 24,674 24,674 0%n 15-000-44-00-4480 ILLINOIS JOBS NOW - 73,122 73,122 0% TOTAL INTERGOVERNMENTAL 355,000 523,767 168,767 1477 Investment Income 15-000-46-00-4600 INVESTMENT INCOME 1,000 839 (161) 84%n Grant Revenue 15-000-44-00-4403 DOWNTOWN PARKING LOT-OLD JAIL - 151,000 151,000 0% Other Revenue 15-000-44-00-4401 GAME FARM ROAD DESIGN 6,978 6,978 0% 15-000-44-00-4402 FOX ROAD 4,602 4,602 0% 15-000-44-00-4490 MISC.INCOME - 84 84 0% TOTAL OTHER REVENUE - 11,664 11,664 0% TOTAL REVENUES 356,000 687,271 331,271 193% EXPENDITURES Contractual Services 15-000-65-00-5401 CONTRACTUAL SERVICES - 2,587 2,587 0% 15-000-65-00-5402 OUTSIDE REPAIR&MAINTENANCE 30,929 30,929 0% TOTAL CONTRACTUAL SERVICES - 33,516 33,516 07 Supplies 15-000-65-00-5818 SALT 204,000 132,777 (71,223) 65% 15-000-75-00-7007 SIGNS 18,000 1,232 (16,768) 7% 15-000-75-00-7009 PATCHING 50,000 52,481 2,481 105% 15-000-75-00-7108 GAME FARM HOUSE DEMO 20,000 - (20,000) 0% 15-000-75-00-7110 COLD PATCH 10,600 9,892 (708) 93% 15-000-75-00-7111 HOT PATCH 13,000 7,658 (5,342) 59% TOTAL SUPPLIES 315,600 204,040 (111,560) 657 Capital Outlay 15-000-75-00-7106 GAME FARM SURVEYING - 6,456 6,456 0% 15-000-75-00-7118 RT 34&SYCAMORE TRAFFIC SGNL 30,000 - (30,000) 0% 15-000-75-00-7119 GAME FARM ROW 130,000 25,000 (105,000) 19% 15-000-75-00-7120 FOX ROAD - 21,930 21,930 0% 15-000-75-00-7123 GUARDRAIL REPAIRS 23,128 23,128 0% 15-000-75-00-7124 DOWNTOWN PARKING LOT - 42,420 42,420 0% TOTAL CAPITAL OUTLAY 160,000 118,934 (41,066) 74% TOTAL EXPENDITURES 475,600 356,490 (119,110) 75% EXCESS(DEFICIENCY)OF REVENUES OVER EXPENDITURES (119,600) 330,781 450,381 Other Financing Sources(Uses) 15-000-75-00-9923 TRANSFER TO CITY WIDE CAPITAL (96,000) (96,000) 0% SURPLUS/(DEFICIT) (119,600) 234,781 354,381 FUND BALANCE-BEGINNING OF YEAR 405,618 405,618 FUND BALANCE-END OF YEAR 286,018 640,399 354,381 11 United City of Yorkville Schedule of Revenues and Expenditures-Budgeted and Actual For the Year Ended April 30,2011 LAND CASH FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget REVENUES Licenses,Permits and Fees 72-000-47-00-4738 AUTUMN CREEK 22,000 18,460 (3,540) 84% 72-000-47-00-4752 BRISTOL BAY LAND CASH - 100,000 100,000 0% 72-000-47-00-4749 BLACKBERRY WOODS - 568 568 0% 72-000-47-00-4737 CALEDONIA 38,000 (38,000) 0% 72-000-47-00-4712 RIVER'S EDGE - 671 671 0% TOTAL LICENSES,PERMITS&FEES 60,000 119,699 59,699 199% Grants 72-000-47-00-4704 OSLAND GRANT-WHISPERING MEAD 320,000 - (320,000) 0% 72-000-47-00-4706 WHEATON WOODS GRANT 30,000 42,285 12,285 141% 72-000-47-00-4734 WHISPERING MEADOWS(K.HILL) 3,000 312,655 309,655 10422% TOTAL GRANTS 353,000 354,940 1,940 101% TOTAL REVENUES 413,000 474,639 61,639 115% EXPENDITURES 72-000-75-00-7326 MOSIER HOLDING COSTS 10,000 10,000 - 100% 72-000-75-00-7333 RAINTREE VILLAGE 495,000 88,175 (406,825) 18% 72-000-75-00-7336 WHEATON WOODS NATURE TRL - 2,133 2,133 0% 72-000-75-00-7337 BRISTOL BAY PARK A 100,000 85,062 (14,938) 85% 72-000-75-00-7339 BRISTOL BAY REGIONAL PARK - 14,020 14,020 0% TOTAL EXPENDITURES 605,000 199,390 (405,610) 33% EXCESS(DEFICIENCY)OF REVENUES OVER EXPENDITURES (192,000) 275,249 467,249 Other Financing Sources(Uses) 72-000-99-00-9901 TRANSFER TO GENERAL FUND (60,449) (60,449) - 100% SURPLUS/(DEFICIT) (252,449) 214,800 467,249 FUND BALANCE-BEGINNING OF YEAR (603,425) (603,425) FUND BALANCE-END OF YEAR (855,874) (388,625) 467,249 12 United City of Yorkville Schedule of Revenues and Expenditures-Budgeted and Actual For the Year Ended April 30,2011 PARKS AND RECREATION FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget REVENUES Charges for Services 79-000-42-00-4270 FEES FOR PROGRAMS 225,000 189,890 (35,110) 84% 79-000-42-00-4280 CONCESSIONS/ALL SALE ITEMS 30,000 31,072 1,072 104% TOTAL CHARGES FOR SERVICES 255,000 220,962 (34,038) 188% Investment Income 79-000-46-00-4600 INVESTMENT INCOME 500 301 (199) 60% Contributions 79-000-44-00-4400 DONATIONS 14,000 6,745 (7,255) 48% 79-000-44-00-4404 TREE DONATIONS 600 700 100 117% TOTAL CONTRIBUTIONS 14,600 7,445 (7,155) 517 Grants 79-000-45-00-4550 YOUTH SERVICES GRANT 500 - (500) 0% Other Revenue Rental Income 79-000-42-00-4286 RENTAL INCOME - 2,975 2,975 0% 79-000-42-00-4287 PARK RENTAL INCOME 15,000 19,496 4,496 130% 79-000-42-00-4288 GOLF OUTING REVENUE 9,000 - (9,000) 0% 79-000-42-00-4295 MISC RETAIL 3,500 - (3,500) 0°l0 79-000-42-00-4291 HOMETOWN DAYS 130,000 137,142 7,142 105% 79-000-44-00-4412 INSURANCE REIMBURSEMENTS - 7,329 7,329 0% 79-000-44-00-4490 MISCELLANEOUS INCOME - 19,722 19,722 0% TOTAL OTHER REVENUE 157,500 186,663 29,163 119% TOTAL REVENUE 428,100 415,371 (12,729) 97% EXPENDITURES Park Operations 79-610-50-00-5107 SALARIES-PARKS 350,026 355,091 5,065 101% 79-610-50-00-5136 SALARIES-PART-TIME 17,000 15,969 (1,031) 94% 79-610-50-00-5137 SALARIES-OVERTIME 4,000 439 (3,561) 11% 79-610-62-00-5405 PARK CONTRACTUAL 2,000 3,323 1,323 166% 79-610-62-00-5408 MAINTENANCE-EQUIPMENT 14,000 17,143 3,143 122% 79-610-62-00-5417 MAINTENANCE-PARKS 34,000 27,088 (6,912) 80% 79-610-62-00-5421 WEARING APPAREL 4,100 4,031 (69) 984'0 79-610-62-00-5434 RENTAL-EQUIPMENT 2,500 188 (2,312) 8% 79-610-62-00-5438 CELLULAR TELEPHONE 4,200 1,802 (2,398) 43% 79-610-62-00-5445 LEGAL EXPENSES 4,000 1,749 (2,251) 44% 79-610-64-00-5604 TRAINING&CONFERENCE 1,500 309 (1,191) 21% 79-610-65-00-5802 OFFICE SUPPLIES 300 152 (148) 51% 79-610-65-00-5804 OPERATING SUPPLIES 20,000 10,400 (9,600) 52% 79-610-65-00-5815 HAND TOOLS 1,750 1,785 35 102% 79-610-65-00-5824 CHRISTMAS DECORATIONS 1,000 359 (641) 36% 79-610-65-00-5825 PUBLIC DECORATION 500 (500) 0% 79-610-72-00-6500 IMRF PARTICIPANTS 33,953 32,914 (1,039) 97% 79-610-72-00-6501 SOCIAL SECURITY/MEDICARE 28,383 27,503 (880) 97% 79-610-75-00-7002 COMPUTER EQUIP&SOFTWARE 500 (500) 0% 79-610-75-00-7003 OFFICE EQUIPMENT 500 (500) 0% 79-610-75-00-7701 FLOWERWIREES 500 473 (27) 95% TOTAL PARK OPERATIONS 524,712 500,718 (23,994) 954'0 13 PARKS AND RECREATION FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget Recreation Operations 79-650-50-00-5107 SALARIES-RECREATION 368,532 248,541 (119,991) 67%n 79-650-50-00-5108 CONCESSION STAFF 10,000 9,021 (979) 90% 79-650-50-00-5109 SALARIES-PRE SCHOOL 20,000 23,085 3,085 115% 79-650-50-00-5136 SALARIES-PART TIME 22,080 12,708 (9,372) 58% 79-650-50-00-5137 SALARIES-OVERTIME 300 (300) 0% 79-650-50-00-5150 SALARIES-INSTRUCTOR 16,000 22,657 6,657 142% 79-650-50-00-5155 SALARIES-RECORDING SECRETARY 3,000 - (3,000) 0% 79-650-62-00-5401 CONTRACTUAL SERVICES 50,000 49,076 (924) 98% 79-650-62-00-5408 MAINTENANCE SUPPLIES 2,000 412 (1,588) 21% 79-650-62-00-5409 MAINTENANCE-VEHICLES 1,000 1,387 387 139% 79-650-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 3,500 2,459 (1,041) 70% 79-650-62-00-5426 YOUTH SERVICES GRANT EXPENSES 500 - (500) 0% 79-650-62-00-5435 ELECTRICITY 22,000 21,229 (771) 96% 79-650-62-00-5437 TELEPHONE/INTERNET 1,300 3,556 2,256 274% 79-650-62-00-5438 CELLULAR TELEPHONE 3,000 1,961 (1,039) 65% 79-650-62-00-5445 PORTABLE TOILETS 4,500 3,750 (750) 83% 79-650-62-00-5603 PUBLISHING/ADVERTISING 27,000 27,872 872 103% 79-650-62-00-5605 BOOKS/PUBLICATIONS 100 - (100) 0% 79-650-64-00-5600 DUES 1,500 482 (1,018) 32% 79-650-64-00-5604 TRAINING AND CONFERENCES 500 680 180 136% 79-650-65-00-5802 OFFICE SUPPLIES 3,000 2,466 (534) 82% 79-650-65-00-5803 PROGRAM EXPENSES 53,600 47,154 (6,446) 88% 79-650-65-00-5804 OPERATING SUPPLIES 1,000 388 (612) 39% 79-650-65-00-5805 RECREATION EQUIPMENT 2,000 283 (1,717) 14% 79-650-65-00-5808 POSTAGE&SHIPPING 8,000 7,006 (994) 88% 79-650-65-00-5812 GASOLINE 3,000 1,626 (1,374) 54% 79-650-65-00-5826 MILEAGE 300 79-650-65-00-5827 GOLF OUTING EXPENSES 6,000 (6(300) 0% ,000) 0% 79-650-65-00-5828 CONCESSIONS 18,000 17,834 (166) 99% 79-650-65-00-5833 HOMETOWN DAYS EXPENSES 100,000 99,903 (97) 100% 79-650-65-00-5840 SCHOLARSHIPS 1,000 221 (779) 22% 79-650-65-00-5841 PROGRAM REFUND 7,000 3,082 (3,918) 44% 79-650-72-00-6500 IMRF PARTICIPANTS 41,537 24,798 (16,739) 60% 79-650-72-00-6501 SOCIAL SECURITY/MEDICARE 30,351 23,899 (6,452) 79% 79-650-75-00-7002 COMPUTER EQUIP&SOFTWARE 2,600 2,600 100% 79-650-78-00-9010 MISC RETAIL 3,000 (3,000) 0% TOTALRECREATION 837,200 660,136 (177,064) 79% TOTAL EXPENDITURES 1,361,912 1,160,854 (201,058) 85% EXCESS(DEFICIENCY)OF REVENUES OVER EXPENDITURES (933,812) (745,483) 188,329 Other Financing Sources(Uses) Transfers In 79-000-49-00-4901 TRANSFER FROM GENERAL FUND/REC 430,974 430,974 - 100% 79-000-49-00-4902 TRANSFER IN FROM GF-LOAN 100,000 (100,000) 0% 79-000-49-00-4903 TRANSFER FROM GENERAL FUND/PKS 520,916 520,916 - 100% Transfers Out 79-650-99-00-9941 REPAYMENT OF GF LOAN (100,000) - 100,000 0% TOTAL OTHER FINANCING SOURCES(USES) 951,890 951,890 - 100% SURPLUS/(DEFICIT) 18,078 206,407 188,329 FUND BALANCE-BEGINNING OF YEAR 25,151 25,151 FUND BALANCE-END OF YEAR 43,229 231,558 188,329 14 United laity of Yorkville Schedule of Revenues and Expenditures-Budgeted and Actual For the Year Ended April 30,2011 FOX INDUSTRIAL TIF FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget REVENUES Property Taxes 85-000-40-00-4090 TIF REVENUES 216,677 228,346 11,669 105% Investment Income 85-000-46-00-4600 INVESTMENT INCOME 50 15 (35) 30% TOTAL REVENUES 216,727 228,361 11,634 105% EXPENDITURES 85-000-78-00-9007 ADMINISTRATION FEES 500 1,989 1,489 398% Debt Service 85-000-66-00-6021 FOX IND BOND-PRINCIPAL PMT 70,000 70,000 - 100% 85-000-66-00-6022 FOX IND BOND-INT PAYMENT 9,933 9,933 - 0% TOTAL EXPENDITURES 80,433 81,922 1,489 102% SURPLUS/(DEFICIT) 136,294 146,439 10,145 FUND BALANCE-BEGINNING OF YEAR 423,351 423,351 FUND BALANCE-END OF YEAR 559,645 569,790 10,145 15 United City of Yorkville Schedule of Revenues and Expenditures-Budgeted and Actual For the Year Ended April 30,2011 COUNTRYSIDE TIF FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget REVENUES Property Taxes 87-000-40-00-4090 TIF REVENUES 6,250 6,372 122 102% Investment Income 87-000-46-00-4600 INVESTMENT INCOME 6,104 3,135 (2,969) 51% TOTAL REVENUES 12,354 9,507 (2,847) 77% EXPENDITURES 87-000-78-00-9007 ADMINISTRATION FEES 1,000 1,622 622 162% Debt Service 87-000-66-00-6022 BOND-INT PAYMENT 307,093 307,093 - 100% TOTAL EXPENDITURES 308,093 308,715 622 100% SURPLUS/(DEFICIT) (295,739) (299,208) (3,469) FUND BALANCE-BEGINNING OF YEAR 2,477,758 2,477,758 FUND BALANCE-END OF YEAR 2,182,019 2,178,550 (3,469) 16 United City of Yorkville Schedule of Revenues and Expenditures-Budgeted and Actual For the Year Ended April 30,2011 DOWNTOWN TIF FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget REVENUES 88-000-40-00-4090 TIFREVENUES 88,550 75,362 (13,188) 85% EXPENDITURES 88-000-78-00-9007 ADMINISTRATIVE FEES 1,500 1,896 396 126% SURPLUS/(DEFICIT) 87,050 73,466 (13,584) FUND BALANCE-BEGINNING OF YEAR 136,294 136,294 FUND BALANCE-END OF YEAR 223,344 209,760 (13,584) 17 United City of Yorkville Schedule of Revenues and Expenditures-Budgeted and Actual For the Year Ended April 30,2011 DEBT SERVICE FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget REVENUES Licenses,Permits and Fees 42-000-44-00-4440 RECAPTURE-WATER/SEWER 1,025 1,025 0% EXPENDITURES Debt Service 42-000-66-00-6071 $650K ROAD 1MPROV PROG PRINC 107,825 107,825 100% 42-000-66-00-6075 $3.825M IN TOWN ROAD PRINC 321,579 321,579 100% TOTAL EXPENDITURES 429,404 429,404 - 100% Other Financing Sources(Uses) Transfers In 42-000-49-00-4901 TRANSFER FROM GENERAL FUND 429,404 429,404 - 100% SURPLUS/(DEFICIT) - 1,025 1,025 FUND BALANCE-BEGINNING OF YEAR 7,628 7,628 FUND BALANCE-END OF YEAR 7,628 8,653 1,025 18 United City of Yorkville Schedule of Revenues and Expenditures-Budgeted and Actual For the Year Ended April 30,2011 MUNICIPAL BUILDING FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget REVENUES Licenses,Permits and Fees 16-000-42-00-4211 DEVELOPMENT FEES-BUILDING 55,000 20,700 (34,300) 38% SURPLUS/(DEFICIT) 55,000 20,700 (34,300) FUND BALANCE-BEGINNING OF YEAR (607,724) (607,724) FUND BALANCE-END OF YEAR (552,724) (587,024) (34,300) 19 United City of Yorkville Schedule of Revenues and Expenditures-Budgeted and Actual For the Year Ended April 30,2011 POLICE CAPITAL FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget REVENUES Licenses,Permits and Fees 20-000-42-00-4212 DEV FEES-POLICE 25,000 16,009 (8,991) 64% 20-000-44-00-4406 WEATHER WARNING SIREN FEES 6,000 407 (5,593) 7% TOTAL LICENSES,PERMITS&FEES 31,000 16,416 (14,584) 537 Fines and Forfeits 20-000-44-00-4403 DUI FINES - 6,462 6,462 0% 20-000-44-00-4407 ELECTRONIC CITATION FEES - 122 122 0% 20-000-44-00-4440 SEIZED VEHICLES 5,000 6,028 1,028 121% TOTAL FINES AND FORFEITS 51000 12,612 7,612 2527 Other Revenue 20-000-44-00-4431 SALE OF POLICE SQUADS 1,000 8,900 7,900 890% TOTAL REVENUES 37,000 37,928 928 103% EXPENDITURES Public Safety Contractual Services 20-000-65-00-5840 SEIZED VEHICLES 1,500 3,060 1,560 204% Capital Outlay Police Equipment 20-000-75-00-7001 EQUIPMENT 40,000 1,462 (38,538) 4% 20-000-75-00-7002 K-9 EQUIPMENT 2,500 - (2,500) 0% 20-000-75-00-7005 VEHICLES 40,000 42,310 2,310 106% 20-000-75-00-7006 CAR BUILD OUT 20,000 6,433 (13,567) 32% TOTAL EXPENDITURES 104,000 53,265 (50,735) 51% EXCESS(DEFICIENCY)OF REVENUES OVER EXPENDITURES (67,000) (15,337) 51,663 Other Financing Sources(Uses) Transfers In 20-000-49-00-4901 TRANSFER FROM GENERAL FUND 25,000 (25,000) 0% SURPLUS/(DEFICIT) (42,000) (15,337) 26,663 FUND BALANCE-BEGINNING OF YEAR 210,284 210,284 FUND BALANCE-END OF YEAR 168,284 194,947 26,663 20 United City of Yorkville Schedule of Revenues and Expenditures-Budgeted and Actual For the Year Ended April 30,2011 PUBLIC WORKS CAPITAL FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget REVENUES Licenses,Permits and Fees 21-000-42-00-4213 DEVELOPMENT FEES-PUBLIC WORKS 35,000 25,100 (9,900) 72% Other Revenue 21-000-42-00-4288 MOWING INCOME - 4,897 4,897 0% 21-000-44-00-4430 SALE OF EQUIPMENT - - 0% 21-000-44-00-4490 MISCELLANEOUS INCOME - 7,283 7,283 0% TOTAL REVENUE 35,000 37,280 2,280 107% EXPENDITURES Public Works Contractual Services 21-000-62-00-5401 CONTRACTUAL SERVICES - 49 49 0% Supplies 21-000-75-00-7107 TRUCK ACCESSORIES 5,000 (5,000) 0% Capital Outlay Public Works Equipment 21-000-75-00-7005 VEHICLES 46,000 - (46,000) 0% 21-000-75-00-7015 SKIDSTEER UPGRADE 4,000 4,000 100% Debt Service Public Works Building 21-000-75-00-7110 PW BUILDING PAYMENT 84,000 82,295 (1,705) 98% TOTAL EXPENDITURES 139,000 86,344 (52,656) 62% SURPLUS/(DEFICIT) (104,000) (49,064) 54,936 FUND BALANCE-BEGINNING OF YEAR 157,807 157,807 FUND BALANCE-END OF YEAR 53,807 108,743 54,936 21 United City of Yorkville Schedule of Revenues and Expenditures-Budgeted and Actual For the Year Ended April 30,2011 PARKS AND RECREATION CAPITAL FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget REVENUES 22-000-42-00-4216 PARKS CAPITAL FEE 2,500 1,650 (850) 66% 22-000-46-00-4600 INVESTMENT INCOME - 99 99 0% Other Revenue 22-000-42-00-4217 PARK CAPITAL DONATIONS - - - 0% 22-000-42-00-4218 BASEBALL FIELD CONSTRUCT 15,000 (15,000) 0% 22-000-44-00-4430 SALE OF VEHICLES/EQUIPMENT - - - 0% 22-000-44-00-4490 MISCELLANEOUS INCOME - 7,500 7,500 0% TOTAL REVENUE 17,500 9,249 (8,251) 53% EXPENDITURES 22-610-75-00-7010 RAINTREE PARK 158,135 9,002 (149,133) 6% 22-610-75-00-7011 BASEBALL FIELD CONSTRUCT 15,000 15,656 656 104% TOTAL EXPENDITURES 173,135 24,658 (148,477) 14% SURPLUS/(DEFICIT) (155,635) (15,409) 140,226 FUND BALANCE-BEGINNING OF YEAR 66,852 66,852 FUND BALANCE-END OF YEAR (88,783) 51,443 140,226 22 United City of Yorkville Schedule of Revenues and Expenditures-Budgeted and Actual For the Year Ended April 30,2011 CITY WIDE CAPITAL FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget REVENUES Licenses,Permits and Fees 23-000-42-00-4211 ENGINEERING CAPITAL FEE 4,000 3,100 (900) 78% 23-000-40-00-3996 ROAD CONTRIBUTION 24,000 22,000 (2,000) 92% TOTAL LICENSES,PERMITS AND FEES 28,000 25,100 (2,900) 90% Investment Income 23-000-46-00-4600 INVESTMENT INCOME - 19 19 0% Grants 23-000-45-00-4501 SAFE RT TO SCHOOL(DESIGN) 46,200 (46,200) 0% 23-000-45-00-4502 SAFE RT TO SCHOOL(CONST) 184,800 - (184,800) 0% 23-000-45-00-4508 STATE GRANTS - 64,000 64,000 0% TOTAL GRANTS 231,000 64,000 (167,000) 28% Other Revenue 23-000-44-00-4417 MISC.REIMBURSEMENTS - 1,200 1,200 0% TOTAL REVENUE 259,000 90,319 (168,681) 35% EXPENDITURES General Government 23-000-62-00-5401 CONTRACTUAL SERVICES - 5,740 5,740 0% Capital Outlay 23-000-75-00-7005 VEHICLES 4,000 - (4,000) 0% 23-000-75-00-7103 SIDEWALK REPLACEMENT 37,500 10,484 (27,016) 28% 23-000-75-00-7111 PARKWAY TREE PLANTING 25,000 - (25,000) 0% 23-000-75-00-7112 SIDEWALK REPLACEMENT RVRFRNT 50,000 (50,000) 0% 23-000-75-00-7113 SAFE ROUTES TO SCHOOL 46,200 (46,200) 0% 23-000-75-00-7114 SAFE RTS TO SCHOOL(CONS) 184,800 (184,800) 0% 23-000-75-00-7116 TOWN SQUARE PARK 25,000 - (25,000) 0% 23-000-75-00-7117 FAXON ROAD ROW 85,000 - (85,000) 0% 23-000-75-00-7119 OLD JAIL - 161,549 161,549 0% TOTAL CAPITAL OUTLAY 457,500 172,033 (285,467) 38% Debt Service 23-000-75-00-7101 RON CLARK PROPERTY 125,000 125,000 100% TOTAL EXPENDITURES 582,500 302,773 (279,727) 52% EXCESS(DEFICIENCY)OF REVENUES OVER EXPENDITURES (323,500) (212,454) 111,046 Other Financing Sources(Uses) Transfers In 23-000-49-00-4901 TRANSFER FROM GENERAL FUND 162,500 135,484 (27,016) 83% 23-000-49-00-4915 TRANSFER FROM MFT - 96,000 96,000 0% TOTAL OTHER FINANCING SOURCES 162,500 231,484 68,984 142% SURPLUS/(DEFICIT) (161,000) 19,030 180,030 FUND BALANCE-BEGINNING OF YEAR (18,378) (18,378) FUND BALANCE-END OF YEAR (179,378) 652 180,030 23 United City of Yorkville Schedule of Revenues,Expenses and Changes in Net Assets-Budget and Actual For the Year Ended April 30,2011 SEWER FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget OPERATING REVENUES Charges for Sen,ices 52-000-42-00-4250 SEWER MAINTENANCE FEES 580,000 731,743 151,743 126% Other Revenue 52-000-44-00-4412 INSURANCE REIMBURSEMENTS - 1,197 1,197 0% 52-000-44-00-4417 REIMBURSEMENTS 3,379 3,379 0% 52-000-42-00-4221 RIVER CROSSING FEES 239 239 0% TOTAL OTHER REVENUE 4,815 4,815 0% TOTAL OPERATING REVENUE 580,000 736,558 156,558 127% OPERATING EXPENSES 52-000-50-00-5108 SALARIES-SEWER OP. 256,296 257,610 1,314 101% 52-000-50-00-5137 SALARIES-OVERTIME 7,500 448 (7,052) 6% 52-000-62-00-5401 CONTRACTUAL SERVICES 4,500 4,022 (478) 89% 52-000-62-00-5408 MAINTENANCE-EQUIPMENT 5,000 2,973 (2,027) 59% 52-000-62-00-5409 MAINTENANCE-VEHICLES 4,000 4,908 908 123% 52-000-62-00-5419 MAINTENANCE-SANITARY SEWER 20,000 7,981 (12,019) 40% 52-000-62-00-5421 WEARING APPAREL 2,500 1,830 (670) 73% 52-000-62-00-5422 LIFT STATION MAINTENANCE 15,000 10,370 (4,630) 69% 52-000-62-00-5434 RENTAL-EQUIPMENT 1,000 (1,000) 0% 52-000-62-00-5435 ELECTRICITY 30,000 21,071 (8,929) 70% 52-000-62-00-5438 CELLULAR TELEPHONE 1,800 1,399 (401) 78% 52-000-64-00-5604 TRAINING&CONFERENCES 500 (500) 0% 52-000-64-00-5605 TRAVEL/MEALS/LODGING 500 (500) 0% 52-000-65-00-5800 CONTINGENCIES - - - 0% 52-000-65-00-5802 OFFICE SUPPLIES 1,800 1,072 (728) 60% 52-000-65-00-5804 OPERATING SUPPLIES - - - 0% 52-000-65-00-5805 SHOP SUPPLIES 2,500 1,891 (609) 76% 52-000-65-00-5812 GASOLINE 26,000 28,692 2,692 110% 52-000-65-00-5815 HAND TOOLS 1,000 133 (867) 13% 52-000-65-00-5817 GRAVEL 2,000 (2,000) 0% 52-000-65-00-5823 SEWER CHEMICALS - - - 0% 52-000-72-00-6500 IMRF PARTICIPANTS 21,949 24,018 2,069 109% 52-000-72-00-6501 SOCIAL SECURITY&MEDICARE 20,230 18,864 (1,366) 93% 52-000-75-00-7002 COMPUTER EQUIP&SOFTWARE 1,000 879 (121) 88% 52-000-75-00-7003 OFFICE EQUIPMENT 500 5 (495) 1% 52-000-75-00-7004 SAFETY EQUIPMENT 1,000 1,216 216 122% 52-000-78-00-9099 BAD DEBT - 15,859 15,859 0% TOTAL OPERATING EXPENSES 426,575 405,241 (21,334) 95% Depreciation 52-000-66-00-8500 DEPRECIATION EXPENSE - 427,322 427,322 0% TOTAL OPERATING EXPENSES 426,575 832,563 405,988 195% OPERATING INCOME(LOSS) 153,425 (96,005) (249,430) 24 SEWER,FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget Nonoperating Revenues(Expenses) Connection Fees 52-000-42-00-4251 SW CONNNECT10N FEES-OPS 25,000 4;000 (21,000) 16% 52-200-42-00-4220 SW CONNECTION FEES-CAPITAL 175,000 38,000 (137,000) 22% 52-200-48-00-4803 CONNECTION FEES-ROB ROY 100,000 698,000 598,000 698% TOTAL CONNECTION FEES 300,000 740,000 440,000 247% Investment Income 52-000-46-00-4600 INVESTMENT INCOME 1,800 1,517 (283) 84% Amortization Expense 52-000-66-00-8800 AMMORTIZATION EXPENSE - (28,103) (28,103) 0% Interest Expense 52-000-66-00-8200 INTEREST EXPENSE (39,360) (39,360) 0% 52-200-66-00-6003 2003A IRBB INTEREST PMT-BRUELL (163,653) (73,653) 90,001 45% 52-200-66-00-6004 2003A IRBB PRINC.PMT-BRUELL - - 0% 52-200-66-00-6008 2004B PRINCIPAL PMT-CNTRYSIDE (258,300) (103,300) 155,000 40% 52-200-66-00-6011 2004A PRINCIPAL PMT-COMED/HYD. (188,572) (28,573) 159,999 15% 52-200-66-00-6016 2005D INTEREST PMT-ROB ROY (537,541) (385,950) 151,591 72% 52-200-66-00-6017 2005C 2M ALT REV (82,850) 82,850 0% 52-200-66-00-6018 2008 DEBT SERVICE (110,090) (110,090) 0% 52-200-66-00-6050 IEPA LOAN L17-013000 PRINC PMT (38,980) (3,623) 35,357 9% 52-200-66-00-6055 IEPA LOAN L17-115300 P&1 PMT (107,051) (22,944) 84,107 21% 52-200-66-00-6059 2007A BOND (133,866) 133,866 0% TOTAL INTEREST EXPENSE (1,510,813) (767,493) 743,320 51% TOTAL NONOPERATING REVENUE(EXPENSES) (1,209,013) (54,079) 1,154,934 4% INCOME(LOSS)BEFORE CONTRIBUTIONS&TRANSFERS (1,055,588) (150,084) 905,504 Other Financing Sources(Uses) Contributions-Capital Assets 52-000-44-00-4035 DEVELOPER DONATIONS 171,170 171,170 0% Transfers Out 52-000-99-00-9901 TRANSFER TO GENERAL FUND (83,045) (83,045) - 100% 52-200-99-00-9951 TRANSFER TO WATER (82,850) (82,850) 0% TOTAL OTHER FINANCING SOURCES(USES) (83,045) 5,275 88,320 -6% SURPLUS/(DEFICIT) (1,138,633) (144,809) 993,824 NET ASSETS-BEGINNING OF YEAR 16,883,090 16,883,090 NET ASSETS-END OF YEAR 15,744,457 16,738,281 993,824 25 United City of Yorkville Schedule of Revenues,Expenses and Changes in Net Assets-Budget and Actual For the Year Ended April 30,2011 WATER FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual. Over(Under) Budget OPERATING REVENUES Charges for Services 51-000-42-00-4240 BULK WATER SALES 2,000 882 (1,118) 44% 51-000-42-00-4241 WATER SALES 1,286,250 1,698,753 412,503 132% 51-000-42-00-4242 WATER METER SALES 32,000 22,040 (9,960) 69% 51-000-42-00-4243 LEASE REVENUE-H2O TOWER 29,000 32,038 3,038 110% TOTAL CHARGES FOR SERVICES 1,349,250 1,753,713 404,463 130% Other Revenues 51-000-44-00-4417 REIMBURSEMENTS - 4,318 4,318 0% 51-000-44-00-4499 BAD DEBT RECOVERY 4,437 4,437 0% TOTAL OTHER REVENUES - 8,755 8,755 - TOTAL OPERATING REVENUE 1,349,250 1,762,468 413,218 131% Operating Expenses 51-000-50-00-5107 SALARIES-WATER OP. 358,702 364,251 5,549 102% 51-000-50-00-5137 SALARIES-OVERTIME 15,000 3,945 (11,055) 26% 51-000-61-00-5300 LEGAL SERVICES - - 0% 51-000-61-00-5303 JULIE SERVICE 6,000 2,422 (3,578) 40% 51-000-62-00-5401 CONTRACTUAL SERVICES 6,000 5,236 (764) 87% 51-000-62-00-5407 TREATMENT FACILITIES O&M 230,000 245,521 15,521 107% 51-000-62-00-5408 MAINTENANCE-EQUIPMENT 8,000 995 (7,005) 12% 51-000-62-00-5409 MAINTENANCE-VEHICLES 9,000 3,855 (5,145) 43% 51-000-62-00-5411 MAINTENANCE-COMPUTERS 500 (500) 0% 51-000-62-00-5421 WEARING APPAREL 3,500 2,206 (1,294) 63% 51-000-62-00-5434 RENTAL-EQUIPMENT 1,000 (1,000) 0% 51-000-62-00-5435 ELECTRICITY 290,000 262,977 (27,023) 91% 51-000-62-00-5436 TELEPHONE 22,000 13,434 (8,566) 61% 51-000-62-00-5438 CELLULAR TELEPHONE 3,300 2,164 (1,136) 66% 51-000-64-00-5600 DUES 1,000 842 (158) 84% 51-000-64-00-5603 SUBSCRIPTIONS 250 57 (193) 23% 51-000-64-00-5604 TRAINING&CONFERENCES 1,600 1,842 242 115% 51-000-64-00-5605 TRAVEL EXPENSES 1,600 390 (1,210) 24% 51-000-65-00-5800 CONTINGENCIES - - 0% 51-000-65-00-5804 OPERATING SUPPLIES 32,500 19,777 (12,723) 61% 51-000-65-00-5808 POSTAGE&SHIPPING 22,000 16,716 (5,284) 76% 51-000-65-00-5809 PRINTING&COPYING 2,500 1,164 (1,33,61)3,.,3.,6) 47% 51-000-65-00-5810 PUBLISHING&ADVERTISING 500 934 434 187% 51-000-65-00-5812 GASOLINE 34,000 30,008 (3,992) 88% 51-000-65-00-5815 HAND TOOLS 1,000 146 (854) 15% 51-000-65-00-5817 GRAVEL 2,000 1,690 (310) 85% 51-000-65-00-5820 CHEMICALS - - - 0% 51-000-65-00-5821 CATHODIC PROTECTION _ _ 0% 51-000-65-00-5822 WATER SAMPLES 14,000 10,265 (3,735) 73% 51-000-72-00-6500 IMRF PARTICIPANTS 31,017 34,330 3,313 111% 51-000-72-00-6501 SOCIAL SECURITY&MEDICARE 28,588 26,890 (1,698) 94% 51-000-75-00-7002 COMPUTER EQUIP&SOFTWARE 1,200 338 (862) 28% 51-000-75-00-7004 SAFETY EQUIPMENT 1,000 266 (734) 27% 51-000-75-00-7506 METER READERS - - - 0% 51-000-75-00-7507 HYDRANT REPLACEMENT 6,000 1,362 (4,638) 23% 51-000-75-00-7508 METERS&PARTS 40,000 30,773 (9,227) 77% 51-000-75-00-7509 ELECTRICITY MONITOR - - - 0% 51-000-78-00-9099 BAD DEBT - 10,424 10,424 0% TOTAL OPERATING EXPENSES 1,173,757 1,095,220 (78,537) 93% 26 WATER FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget Improvements 51-200-61-00-5300 LEGAL SERVICES 2,000 (2,000) 0% 51-200-62-00-5464 GRANDE RESERVE COURT ORDER 269,856 (269,856) 0% TOTAL IMPROVEMENTS 271,856 (271,856) 0% Depreciation Expense 51-000-66-00-8500 DEPRECIATION EXPENSE - 777,189 777,189 0% TOTAL OPERATING EXPENSES 1,445,613 1,872,409 426,796 130% OPERATING INCOME(LOSS) (96,363) (109,941) (13,578) Nonoperating Revenues(Expenses) Connection Fees 51-200-42-00-4220 CONNECTION FEES 190,000 96,140 (93,860) 51% Improvement Expansion Fee 51-200-42-00-4250 IMPROVEMENT EXPANSION FEE 580,104 685,188 105,084 118% Investment Income 51-000-46-00-4600 INVESTMENT INCOME 1,800 1,517 (283) 84% 51-200-46-00-4600 INVESTMENT INCOME 1,200 371 (829) 31% TOTAL INVESTMENT INCOME 3,000 1,888 (1,112) 63% Amortization Expense 51-000-66-00-8800 AMMORTIZATION EXPENSE - (91,873) (91,873) 0% Interest Expense 51-000-66-00-8200 INTEREST EXPENSE (33,668) (33,668) 0% 51-200-66-00-6007 RADIUM COMPLIANCE BOND - (33,150) (33,150) 0% 51-200-66-00-6041 IEPAL17-156300 PRINCIPAL PMT (125,031) (41,531) 83,500 33% 51-200-66-00-6042 IEPA L17-156300 INTEREST PMT - 0% 51-200-66-00-6056 2006A REFUND.INTEREST PMT-WTR - - - 0% 51-200-66-00-6057 2006A REFUND.PRINCIPAL PMT-WTR (161,307) (91,306) 70,001 57% 51-200-66-00-6058 2002 PRINCIPAL PMT-NORTH WTR (215,000) (27,200) 187,800 13% 51-200-66-00-6059 2007A REFUNDING P&I PMT - (124,266) (124,266) 0% 51-200-66-00-6072 2005C INTEREST PMT-$2M _ 0% 51-200-66-00-6073 2005C PRINCIPAL PMT-$2M (83,863) (80,700) 3,163 96% TOTAL INTEREST EXPENSE (585,201) (431,821) 153,380 74% TOTAL NONOPERATING REVENUE(EXPENSES) 187,903 259,521 71,618 138% INCOME(LOSS)BEFORE CONTRIBUTIONS&TRANSFERS 91,540 149,580 58,040 Other Financing Sources(Uses) Contributions-Capital Assets 51-000-44-00-4035 DEVELOPER DONATIONS - 70,174 70,174 0% Transfers In 51-000-49-00-4952 TRANSFER FROM SEWER - 82,850 82,850 0% Transfers Out 51-000-99-00-9901 TRANSFER TO GENERAL FUND (91,863) (91,863) - 100% TOTAL OTHER FINANCING SOURCES(USES) (91,863) 61,161 153,024 -67% SURPLUS/(DEFICIT) (323) 210,741 211,064 NET ASSETS-BEGINNING OF YEAR 19,308,639 19,308,639 NET ASSETS-END OF YEAR 19,308,316 19,519,380 211,064 27 United City of Yorkville Schedule of Revenues,Expenses and Changes in Net Assets-Budget and Actual For the Year Ended April 30,2011 RECREATION CENTER FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget OPERATING REVENUES Charges for Services 80-000-42-00-4200 MEMBERSHIP FEES 410,000 418,685 8,685 102% 80-000-42-00-4210 GUEST FEES 3,500 7,072 3,572 202% 80-000-42-00-4220 SWIM CLASS 35,000 27,013 (7,988) 77% 80-000-42-00-4230 PERSONAL TRAINING FEES 15,000 8,055 (6,945) 54% 80-000-42-00-4240 TANNING SESSIONS 2,500 2,072 (428) 83% 80-000-42-00-4270 FEES FOR PROGRAMS 125,000 130,565 5,565 104% 80-000-42-00-4280 CONCESSIONS 12,000 14,692 2,692 122% TOTAL CHARGES FOR SERVICE 603,000 608,154 5,154 101% Other Revenue 80-000-42-00-4286 RENTAL INCOME 3,000 7,103 4,103 237% 80-000-44-00-4400 DONATIONS/SPONSORSHIP 2,000 3,170 1,170 159% 80-000-45-00-4550 GRANTS/SCHOLARSHIPS 500 - (500) 0% TOTAL OTHER REVENUE 5,500 10,273 4,773 187% TOTAL REVENUES 608,500 618,427 9,927 102% OPERATING EXPENSES 80-000-50-00-5107 SALARIES-REC CENTER 33,543 34,332 789 102% 80-000-50-00-5109 SALARIES-PRESCHOOL 35,000 38,362 3,362 110% 80-000-50-00-5136 SALARIES-PART TIME 98,000 96,666 (1,334) 99% 80-000-50-00-5137 SALARIES-OVERTIME 500 - (500) 0% 80-000-50-00-5150 SALARIES-INSTRUCTORS 65,000 56,418 (8,582) 87% 80-000-62-00-5401 CONTRACTUAL SERVICES 15,000 30,795 15,795 205% 80-000-62-00-5408 MAINTENANCE-SUPPLIES 11,000 9,768 (1,232) 89% 80-000-62-00-5410 MAINTENANCE-OFFICE EQUIP. 4,500 3,204 (1,296) 71% 80-000-62-00-5416 MAINTENANCE-GENERAL 16,000 9,313 (6,687) 58% 80-000-62-00-5426 GRANTS 500 (500) 0% 80-000-62-00-5430 TOWEL RENTAL 1,500 1,527 27 102% 80-000-62-00-5431 POOL REPAIR 5,000 4,314 (686) 86% 80-000-62-00-5432 LEASE PAYMENT 216,000 215,000 (1,000) 100% 80-000-62-00-5433 LICENSES/PERMITS 700 350 (350) 50% 80-000-62-00-5434 POOL SUPPLIES 3,200 3,346 146 105% 80-000-62-00-5435 ELECTRICITY 28,000 41,456 13,456 148% 80-000-62-00-5437 TELEPHONEANTERNET/CABLE 1,750 4,012 2,262 229% 80-000-62-00-5438 CELLULAR PHONE 600 367 (233) 61% 80-000-62-00-5439 PROPERTY TAX 53,000 53,680 680 101% 80-000-62-00-5440 SECURITY 500 180 (320) 36% 80-000-62-00-5603 PUBLISHING/ADVERTISING 1,500 732 (768) 49% 80-000-62-00-5605 BOOKS/PUBLICATION 50 (50) 0% 80-000-64-00-5600 DUES 200 - (200) 0% 80-000-64-00-5604 TRAINING&CONFERENCES _ - 0% 80-000-64-00-5605 TRAVEL EXPENSES - - - 0% 80-000-65-00-5802 OFFICE SUPPLIES 2,600 1,730 (870) 67% 80-000-65-00-5803 PROGRAM EXPENSES 17,000 11,676 (5,324) 69% 80-000-65-00-5804 OPERATING SUPPLIES 3,000 1,198 (1,802) 40% 80-000-65-00-5805 RECREATION EQUIPMENT 6,000 5,320 (680) 89% 80-000-65-00-5808 POSTAGE&SHIPPING 600 80-000-65-00-5812 GASOLINE 300 (600) 0% (300) 0% 80-000-65-00-5826 MILEAGE 200 (200) 0% 80-000-65-00-5828 CONCESSIONS EXPENSES 6,000 10,029 4,029 167% 80-000-65-00-5840 SCHOLARSHIPS 400 389 (11) 97% 80-000-65-00-5841 PROGRAM REFUNDS 4,000 7,049 3,049 176% 80-000-65-00-5842 MEMBERSHIP REFUNDS 1,500 1,424 (76) 95% 80-000-72-00-6500 IMRF 10,000 11,607 1,607 116% 28 RECREATION CENTER FUND Variance from Percentage FY 2011 FY 2011 Budget of Budget Actual Over(Under) Budget 80-000-72-00-6501 SOCIAL SECURITY 17,658 17,132 (526) 97% 80-000-75-00-7002 COMPUTER EQUIP K.SOFTWARE 3,200 3,180 (20) 99% 80-000-75-00-7003 OFFICE EQUIPMENT 300 - (300) 0% 80-000-75-00-7500 PHONE SYSTEM 200 - (200) 0% 80-000-78-00-9002 N1COR 11,000 13,661 2,661 124% TOTAL OPERATING EXPENSES 675,001 688,218 13,217 102% OPERATING INCOME(LOSS) (66,501) (69,791) (3,290) Nonoperating Revenues(Expenses) Other Income 80-000-78-00-9010 MISC RETAIL (300) - 300 0% 80-000-42-00-4295 MISC RETAIL 500 1,593 1,093 319% TOTAL OTHER INCOME 200 1,593 1,393 7977 SURPLUS/(DEFICIT) (66,301) (68,198) (1,897) NET ASSETS-BEGINNING OF YEAR (128,887) (128,887) NET ASSETS-END OF YEAR (195,188) (197,085) (1,897) 29 'e.D C/ry Reviewed By: Agenda Item Number u O Legal ❑ PKBD #1 Finance ❑ EST. `;i � � 1$36 Engineer El-��— Tracking Number �,� �� t City Administrator ❑ a' 0 Consultant ❑ CC 2011-111 Agenda Item Summary Memo Title: Collman Naming Request Meeting and Date: City Council, September 27, 2011 Synopsis: Park Board approved the park feature naming request for the tennis courts at Raintree Park B of"Collman Courts" at the September 22, 2011 meeting. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Majority Council Action Requested: Approve naming of Raintree Park B tennis courts to "Collman Courts." Submitted by: Laura Schaw Interim Director of Parks Name &Recreation Agenda Item Notes: See attached application and letter of support. The plaque and recognition at the park will be held at a grand opening once the park is completed. We expect the grand opening to be next summer. YM KV 11t a PARKC REMATIaN Parks Naming Application Yorkville Parks and Recreation Department 201 West Hydraulic Street Yorkville,IL 60560 Phone 630-553-4357— Fax 630-553-4360 Person completing application C!-N D Y QOZ-9 V ILL. On behalf of(person or organization) CD t-L-t-JA K Address of person completing application Bo c) 9A)!j F__i=ce`i e P. yow-xvILLE , tL_ LDu UO Home phone number Work x.'553 Cell Suggested name COL.-�x t-1 0,0 u Park, location, facility to be considered for naming _ -T&K4 K 15 Q-e t)t2� Ayr i2A1 KITP-EE PA,�t214- & Please explain why this name should be considered (Please use back of application to attach additional sheets if necessary), -J C-FF ;>A;;r;Q AW,4,y I u -- E SEPT. I I - A-n S. F t E WA--,;, �. �l ORtt-YI LL>E �1DE t.t'r. t4AH i NIA `1+E- W u2T5 A;P`i-I-:P. 441" WDuL-D &E E If naming after a person, please verify that the person or his immediate family have been contacted: Person Contacted ' E Ct0 Lt i� !A lkJ Phone Number Date Contacted 1 D`1I _ By Whom E5MM QL.tPQQ W-A 5C,tW-AV-r OFFICE USE Date Received Staff Initials Request Verified by Staff Schedule for Park Board Review Date Action City Council Date Action Dedication Name on Signage Location of Park, Facility, Building, Thoroughfare Yorkville Park Board 202 E. Countryside Ln. Yorkville, IL 60560 August 23, 2011 To Whom It May Concern; I am the father of Jeff Collman,who passed away in the September 111"attacks.This letter is to formally state my support for naming of the Tennis Courts at Raintree Village Park B located at 872 Prairie Crossing Drive to "Coltman Courts". Thank you, 7 4 Dwayne Collman 0 C/ry Reviewed By: Agenda Item Number ZO Legal ❑ Library#1 EST.; 1836 Finance ■ .� _ Engineer ❑ Tracking Number City Administrator ■ 0� I Jha. 0 Consultant ❑ K-11 C-q CC 2011-112 Agenda Item Summary Memo Title: Proposed FY 12 Budget Amendments (Library) Meeting and Date: City Council 09/27/11 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Rob Fredrickson Finance Name Department Agenda Item Notes: 0 Memorandum J -10 ��° '* h To: City Council EST. = _ Baas From: Rob Fredrickson, Finance Director I��r Date: September 22, 2011 �o5 az Subject: FY 2012 Budget Amendments - Proposed tE 7 � The attached budget amendment would transfer$332,500 from the Library Development Fee Fund (84) to the General Fund (0 1) as a prepayment representing the Libraries share of construction costs associated with the upcoming improvements to Game Farm Road. After this initial transfer is made, the General Fund would transfer$332,500 to the Library Operations Fund (82). These transfers are highlighted in yellow, and can be found on pages 3, 6, 8 and 10 on the attached budget sheets. Please note that these transfers would be contingent on the Library Board approving the same budget amendment (excluding the General Fund) at their next board meeting. STATE OF ILLINOIS ) ) ss COUNTY OF KENDALL ) ORDINANCE NO. 2011- ORDINANCE APPROVING THE REVISION OF THE 2011-2012 FISCAL YEAR BUDGET FOR THE UNITED CITY OF YORKVILLE REGARDING THE GENERAL FUND, THE LIBRARY OPERATIONS FUND, AND THE LIBRARY DEVELOPMENT FEE FUND WHEREAS, the Mayor and City Council of the UNITED CITY OF YORKVILLE, through its committee system have duly considered revision of the budget for the 2011- 2012 Fiscal Year Budget regarding the General Fund, the Library Operations Fund, and the Library Development Fee Fund; 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 revised 2011-2012 Fiscal Year Budget regarding the General Fund, the Library Operations Fund, and the Library Development Fee Fund being submitted on September 27, 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 revision of the 2011-2012 Fiscal Budget regarding the General Fund, the Library Operations Fund, and the Library Development Fee Fund, as attached, is hereby adopted for the 2011-2012 Fiscal Year. Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this day of , A.D. 2011. CITY CLERK ROSE ANN SPEARS DIANE TEELING GEORGE GILSON JR. JACKIE MILSCHEWSKI CARLO COLOSIMO MARTY MUNNS CHRIS FUNKHOUSER LARRY KOT Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this day of , A.D. 2011. MAYOR Library Development Fee Fund (84) The Library Development Fee Fund derives its revenue from monies collected from building permits. The revenue is used for Library building maintenance and associated capital purchases. FY 2011 FY2009 FY2010 Adopted FY2011 FY2012 FY2013 FY2014 Actual Actual Budget Projected Adopted* Projected Projected Revenue Licenses&Permits - - - - 8,000 8,000 8,000 Investment Earnings - - - - 500 500 500 Other Financing Sources - - - - 332,500 - - Total Revenue - - - - 341,000 8,500 8,500 Expenditures Capital Outlay - - - - 4,000 4,000 4,000 Other Financing Uses - - - - 332,500 - - Total Expenditures - - - - 336,500 4,000 4,000 Surplus(Deficit) - - - - 4,500 4,500 4,500 Ending Fund Balance 0 0 0 0 4,500 9,000 13,500 N $15 Fund Balance $10 0 $5 $0 *Amended Budget United City of Yorkville Library Development Fee Fund 84 LIBRARY DVLP FEE 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 84-000-42-00-4212 DEVELOPMENT FEES-BUILDING - - - - 8,000 8,000 8,000 Total: Licenses and Permits $0 $0 $0 $0 $8,000 $8,000 $8,000 Investment Earnings 84-000-45-00-4500 INVESTMENT EARNINGS - 500 500 500 Total: Investment Earnings $0 $0 $0 $0 $500 $500 $500 Other Financing Sources 84-000-49-00-4982 TRANSFER FROM LIBRARY OPS - - 332,500 Total: Other Financing Sources $0 $0 $0 $0 $332,500 $0 $0 Total: LIBRARY DVLP FEE REVENUE L0 $0 L0 L0 $341,000 19.M lut Amended Budget United City of Yorkville Library Development Fee Fund 840 LIBRARY DVLP FEE 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 Capital Outlay 84-840-60-00-6020 BUILDINGS AND STRUCTURES 4,000 4,000 4,000 Total- Capital Outlay $0 $0 $0 $0 $4,000 $4,000 $4,000 Other Financing Uses 84-8443349-(Kl-440i 'C1L%NSl-'LR-10 GENERAL - - - 132,500 - Total: Other Financing Uses $0 $0 $0 $0 $332,500 $0 $0 Total: LIBRARY DVLP FEE EXP L0 L0 L0 L0 $336,500 $4,000 $4,000 *Amended Budget 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* Projected Projected 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 527,492 192,759 187,548 Total Revenue 11,160,942 11,007,428 11,433,025 11,268,062 11,823,874 11,665,831 11,850,039 Expenditures Salaries 4,374,826 4,048,018 3,766,082 3,558,657 3,278,395 3,278,395 3,278,395 Benefits 2,052,692 2,325,141 2,461,298 2,326,791 2,507,632 2,735,900 2,987,913 Contractual Services 3,839,677 4,423,646 3,105,690 3,609,202 3,611,103 3,700,661 3,725,172 Supplies 322,098 249,742 320,884 310,039 300,295 305,425 311,652 Capital Outlay 46 11,330 44,232 42,232 4,000 4,000 4,000 Contingencies (7,047) 16,153 10,000 100,000 64,617 10,000 10,000 Other Financing Uses 2.312,731 1,644,594 1,668,794 1,333,448 1,293,950 1,274,675 889,735 Total Expenditures 12,895,022 12,718,624 11,376,980 11,280,369 11,059,992 11,309,056 11,206,867 Surplus(Deficit) (1,734,080) (1,711,196) 56,045 (12,307) 763,882 356,775 643,172 Ending Fund Balance 1,218,257 (492,939) 1,274,302 (505,246) 258,636 615,411 1,258,583 -4.5% 2.3% 5.4% 11.2% $1,500 Fund Balance r $1,000 N 'o $500 € $0 ($500) ($1,000) *Amended Budget United City of Yorkville General Fund Oi GENERAL 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 O1-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 O1-000-40-00-4010 PROPERTY TAXES-POLICE PENSION 297,327 323,291 350,000 336,041 375,000 400,000 425,000 01-000-40-00-4012 PROPERTY TAXES-FOX INDUSTRIAL TIF - - - 29,804 - - ForindusirialTlFLiquidation FY2011 O1-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 O1-000-40-00-4040 ELECTRIC UTILITY TAX 572,959 548,774 565,000 580,000 591,600 603,432 615,501 01-00040-004041 NATURAL GAS UTILITY TAX 349,136 284,895 396,000 285,000 290,700 296,514 302,444 01-000-40-004043 TELEPHONE UTILITY TAX 519,669 518,446 600,000 525,000 535,500 546,210 557,134 O1-000-40-004045 CABLE FRANCHISE FEES 189,131 188,282 190,000 200,000 204,000 208,080 212,242 O1-000-40-00-4050 HOTELTAX 19,652 17,262 20,000 30,000 30,600 31,212 31,836 O1-000-40-00-4060 AMUSEMENT TAX 111,083 112,964 162,964 108 134,000 134,000 134,000 O1-000-40-00-4065 ADMISSIONS TAX - - 112,964 181,744 190,000 200,000 210,000 O1-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 O1-000-40-00-4080 PARA-MUTUEL TAX - - - 3,000 15,000 20,000 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 Intergovernmental O1-000-41-00-4100 STATE INCOME TAX 1,004,980 1,277,889 1,300,000 1,300,000 1,340,000 1,390,000 1,440,000 O1-000-41-00-4105 LOCAL USE TAX 165,054 201,681 237,063 210,000 210,000 210,000 210,000 O1-000-41-00-4110 ROAD&BRIDGE TAX 143,506 151,196 160,000 164,296 164,296 164,296 164,296 O1-000-41-00-4120 PERSONAL PROPERTY TAX 17,690 13,409 20,000 13,000 13,000 13,000 13,000 O1-000-41-00-4160 FEDERAL GRANTS - 1,502 - 12,913 9,200 9,200 9,200 H1DTA Reimb $5,000 COPS-Vest Grant $4.200 O1-000-41-00-4170 STATE GRANTS (1,758) 1,870 1,803 34,390 - - - 01-000-41-004182 MISC INTERGOVERNMENTAL 4,838 - 2,196 2,000 2,000 2,000 Pull Tub&Jar Games$2,000 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 Permits 01-000-42-004200 LIQUOR LICENSE 50,008 43,545 30,000 40,000 40,000 40,000 40,000 O1-000-42-00-4205 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-00042-00-4214 DEVELOPMENT FEES 199,722 21,690 80,170 35,000 - - - Moved to City-Wide Capital Fund 01-00042-00-4220 FILING FEES 1,880 250 3,000 250 250 250 Total: Licenses and Permits $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 O1-000-43-00-4320 ADMINISTRATIVE ADJUDICATION 22,390 44,565 50,000 26,000 30,000 30,000 30,000 O1-000-43-00-4325 POLICE TOWS - 25,500 181,275 87,000 90,000 90,000 90,000 Total: Fines and Forfeits $152,734 $199,140 $382,550 $204,671 $215,000 $215,000 $215,000 United City of Yorkville General Fund 01 GENERAL 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 Charges for Services 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-44-00-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-00-4474 POLICE SPECIAL DETAIL - - . 4,500 5,000 5,000 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 Investment Earnings 01-000-45-00-4500 INVESTMENT EARNINGS 18,629 62,043 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 Reimbursements 01-000-46-00-4601 REIMB-LEGAL EXPENSES 27,848 150,000 37,130 12,000 - - 01-000-46-00-4650 REIMB-TRAFFIC SIGNAL 18,289 14,925 14,925 33,067 15,000 15,000 15,000 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,000 195,000 01-000-46-00-4671 REIMB-LIFE INSURANCE 4,753 4,800 4,800 4,800 01-000-46-00-4680 REIMB-LIABILITY INSURANCE 4,646 29,776 - 11,404 5,000 5,000 5,000 01-00046-00-4681 REIMB-WORKERS COMP 5,000 - - 01-000-46-004685 REIMB-CABLE CONSORTIUM 98,499 36,185 - 40,000 40,000 40,000 40,000 01-000-46-00-4690 REIMB-MISCELLANEOUS 173,728 88,370 8,300 4,000 4,000 4,000 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 Beecher Lease Agreement $6,000 Beecher Rentals $3,000 01-000-48-00-4845 DONATIONS 2,820 2,460 2,020 1,650 2,000 2,000 2,000 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,000 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,045 83,045 83,045 83,045 01-000-49-00-4972 TRANSFER FROM LAND CASH 181,000 60,449 60,449 60,449 20,084 17,851 12,640 01-000-49-00-4979 TRANSFER FROM PARK&REC - 150,000 100,000 - - 01370"94,10-4984 TRANSFER FROM LIBRARY DVLPMENT - 332,500 - 01-000-49-00-4985 TRANSFER FROM FOX INDUSTRIAL TIP 25,680 - 01-000-49-00-4988 TRANSFER FROM DOWNTOWN TIF 25,805 - - - - - - Total: Other Financing Sources $902,485 $344,658 $335,357 $235,357 $527,492 $192,759 $187,548 Total: GENERAL FUND REVENUE $11,160,942 $11,007,426 $11,433,025 $11,268,062 $11,823,874 $11,665,831 $11,850,039 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 64,617 10,000 10,000 Other Financing Uses 2,312,731 1,644,594 1,668,794 1,333,448 1,293,950 1,274,675 889,735 Total Administrative Services&Transfers 5,112,766 5,628,642 4,539,183 4,777,695 4,805,757 5,007,784 4,859,918 $6,000 $5,000 N c $4,000 1` $3,000 $2,000 $1,000 $0 *Amended Budget 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 Actual Actual Budget Projected Adopted'" Projected Projected Salaries 01-640-50-00-5092 POLICE SPECIAL DETAIL WAGES - - 4,500 5,00) 5,000 5,000 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,000 60,000 01-640-52-00-5231 LIABILITY INSURANCE 216,026 276,386 344,129 320,000 339,200 359,552 381,125 Total: Benefits $1,238,197 $1,554,427 $1,671,339 $1,588,325 $1,743,350 $1,942,718 $2,169,731 Contractual Services 01-640-54-00-5456 CORPORATE COUNSEL - 110,259 130,000 130,000 130,000 130,000 130.000 01-640-54-00-5461 LITIGATION COUNSEL 93,529 90,000 90,000 60,000 60,(X)0 60,000 01-640-54-00-5462 PROFESSIONAL SERVICES - - 15,000 50,000 50,000 50,000 OutsourcedlTScpenditures$50,000 01-640-54-00-5463 SPECIAL COUNSEL - - 65,000 65,000 25,000 25,000 25,000 01-640-54-00-5466 LEGAL SERVICES 407,880 38,747 - - - - 01-640-54-00-5475 CABLE CONSORTIUM FEE 73,828 54,240 50,000 80,000 85,000 85,000 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,050 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 01-640-54-00-5494 ADMISSIONS TAX REBATE 61,096 62,130 63,000 99,550 114,000 190,000 199,500 01-640-54-00-5499 BAD DEBT 866 1,016,132 - 89,822 1,250 1,250 1,250 Landfill ARO-Write Off$66,345 FY 2011 Final Write Off-ARO$22,227 FY 2011 Utility Billing $1,250 FY2011&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,1.53 10,000 100,000 64,617 10,000 10,000 Total: Contingencies ($7,047) $16,153 $10,000 $100,000 $64,617 $10,000 $10,000 Other Financing Uses 01-640-99-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,000 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-640-99-00-9952 TRANSFER TO SEWER 150,000 - - - - - 01-640-99-00-9979 TRANSFER TO PARK&RECREATION 1,080,348 1,119,500 1,051,890 774,244 732,710 800,210 765,210 01-640-99-00-9982 TRANSFER TO LIBRARY OPERATIONS - - - 332.500 - - Total: Other Financing Uses $2,312,731 $1,644,594 $1,668,794 $1,333,448 $1,293,950 $1,274,675 $889,735 Total: ADMINISTRATIVE SERVICES $5,112,766 $5,628,642 $4,539,183 $4,777,695 $4,805,757 $5,007,784 $4,859,918 Amended Budget Library Operations Fund (82) The Yorkville Public Library provides the people of the community,from pre-school through maturity,with access to a collection of books and other materials which will serve their educational,cultural and recreational needs. The Library board and staff strive to provide the community an environment that promotes the love of reading. FY 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,252,191 675,000 700,000 725,000 Intergovernmental 4,551 19,693 22,500 22,693 22,200 22,200 22,200 Licenses&Permits 65,400 31,100 40,000 17,650 8,000 8,000 8,000 Fines&Forfeits 9,531 11,503 9,000 13,906 13,000 13,000 13,000 Charges for Service 19,487 18,493 18,000 16,802 13,000 13,000 13,000 Investment Earnings 10,985 1,952 10,000 784 250 250 250 Reimbursements - 6,181 - - - - - Miscellaneous 3,183 6,113 4,500 7,687 5,500 5,500 5,500 Other Financing Sources - - - - 332,500 - - Total Revenue 1,228,546 1,278,809 1,359,924 1,331,713 1,069,450 761,950 786,950 Expenditures Salaries 428,161 486,675 650,000 501,500 434,000 434,000 434,000 Benefits 99,917 134,192 155,000 143,368 158,425 175,455 191,565 Contractual Services 129,909 152,280 258,500 192,000 105,100 105,100 105,100 Supplies 181,878 164,687 345,000 202,652 29,250 29,250 29,250 Contingencies 6,923 4,985 144,561 10,000 1,000 1,000 1,000 Debt Service 467,406 564,050 605,925 605,925 - - - Other Financing Uses - - - - 332,500 - - Total Expenditures 1,314,193 1,506,868 2,158,986 1,655,445 1,060,275 744,805 760,915 Surplus(Deficit) (85,647) (228,059) (799,062) (323,732) 9,175 17,145 26,035 Ending Fund Balance 799,062 571,002 0 247,270 256,445 273,590 299,625 14.9% 24.2% 36.7% 39.4% *Amended Budget N $1,000 Fund Balance $boo o $hoo $400 $200 $o United City of Yorkville Library Operations Fund 82 LIBRARY OPERATIONS 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 663,101 675,000 700,000 725,000 82-000-40-00-4015 PROPERTY TAXES-DEBT SERVICE 463,324 561,150 605,924 589,090 Total: Taxes $1,115,409 $1,183,774 $1,255,924 $1,252,191 $675,000 $700,000 $725,000 Intergovernmental 82-000-41-00-4120 PERSONAL PROPERTY TAX 4,551 5,139 5,000 5,500 5,000 5,000 5,000 82-000-41-00-4170 STATE GRANTS - 14,555 17,500 17,193 17,200 17,200 17,200 Libran,per Capita Grant $17,200 Total: Intergovernmental $4,551 $199693 $22,500 $22,693 $22,200 $22,200 $22,200 Licenses and Permits 82-000-42-00-4211 DEVELOPMENT FEES-BOOKS 32,700 15,550 20,000 8,825 8,000 8,000 8,000 82-000-42-00-4212 DEVELOPMENT FEES-BUILDING 32,700 15,550 20,000 8,825 - - Total: Licenses and Permits $659400 $31,100 $40,000 $17,650 $8,000 $8,000 $8,000 Fines and Forfeits 82-000-43-00-4330 LIBRARY FINES 9,531 11,503 9,000 13,906 13,000 13,000 13,000 Total: Fines and Forfeits $9,531 $11,503 $9,000 $13,906 $13,000 $13,000 $13,000 Charges for Services 82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 16,758 14,720 15,000 13,419 8,000 8,000 8,000 82-000-44-00-4422 COPY FEES 2,729 3,773 3,000 3,383 3,000 3,000 3,000 82-000-44-00-4440 PROGRAM FEES - - - - 2,000 2,000 2,000 Total: Charges for Services $19,487 $18,493 $18,000 $16,802 $13,000 $13,000 $13,000 Investment Earnings 82-000-45-00-4500 INVESTMENT EARNINGS 10,985 1,952 10,000 784 250 250 250 Total: Investment Earnings $10,985 $1,952 $10,000 $784 $250 $250 $250 Reimbursements 82-000-46-00-4682 REIMB-INSURANCE - 6,181 Total: Reimbursements $0 $6,181 $0 $0 $0 $0 $0 Miscellaneous 82-000-48-00-4820 RENTAL INCOME 1,101 1,239 1,000 1,296 1,500 1,500 1,500 Library Building Rental$1,500 82-000-48-00-4824 DVD RENTAL INCOME - - - 3,800 4,000 4,000 4,000 82-000-48-00-4832 MEMORIALS 1,363 4,451 3,000 2,200 - - - 82-000-48-00-4850 MISCELLANEOUS INCOME - - - 40 Exam Proctoring-FY 2011 82-000-48-00-4881 SALE OF BOOKS 719 423 500 350 - - - Total: Miscellaneous $3,183 $6,113 $4,500 $7,687 $5,500 $5,500 $5,500 Other Financing Sources 82-000-49-00-4901 TRANSFER FROM GENERAL - 332,500 - Total: Other Financing Sources $0 $0 $0 $0 $332,500 $0 $0 Total: LIBRARY OPS FUND REVENUE $1,228,546 $1,278,809 $1,359,924 $1,331,713 $1,069,450 $761,950 $786,950 Amended Budget United City of Yorkville Library Operations Fund 20 [BRARY OPERATIONS FUND EXPENDITURES FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 -count Description Actual Actual Budget Projected Adopted* Projected Projected daries :-820-50-00-5010 SALARIES AND WAGES 428,161 486,675 650,000 501,500 241,000 241,000 241,00 :-820-50-00-5015 PART-TIME SALARIES - - - - 193,000 193,000 193,00 Total: Salaries $428,161 $486,675 $650,000 $501,500 $434,000 $434,000 $434,0( :petits :-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 14,704 19,866 22,000 21,605 22,500 25,000 25,00 :-820-52-00-5214 FICA CONTRIBUTION 32,754 36,691 55,000 37,900 40,000 40,000 40,00 :-820-52-00-5216 GROUP HEALTH INSURANCE 47,457 70,805 70,000 76,500 87,975 101,171 116,34 :-820-52-00-5222 GROUP LIFE INSURANCE 992 1,240 2,000 1,200 1,000 1,500 1,50 :-820-52-00-5223 DENTAL&VISION INSURANCE 4,010 5,589 6,000 6,163 6,950 7,784 8,71 Total: Benefits $99,917 $134,192 $155,000 $143,368 $158,425 $175,455 $191,5( ontractual Services :-820-54-00-5412 TRAINING&CONFERENCES 3,421 358 5,000 1,000 - -. :-820-54-00-5415 TRAVEL AND LODGING 989 566 1,000 1,000 500 500 50 Mileage $500 :-820-54-00-5423 PUBLIC RELATIONS - 663 2,000 500 - - - :-820-54-00-5426 PUBLISHING&ADVERTISING 63 29 2,000 500 100 100 10 :-820-54-00-5440 TELECOMMUNICATIONS 4,218 5,198 8,000 10,000 8,500 8,500 8,50 :-820-54-00-5452 POSTAGE&SHIPPING 1,156 1,738 2,500 2,500 2,000 2,000 2,00 :-820-54-00-5460 DUES AND SUBSCRIPTIONS 5,205 18,046 30,000 20,000 14,000 14,000 14,00 Database $7,000 Subscriptions $7,000 :-820-54-00-5462 PROFESSIONAL SERVICES 22,496 20,090 45.000 39,500 29,000 29,000 29,00 Contractual Services $25,000 Bonding Fees $4,000 :-820-54-00-5466 LEGAL SERVICES 595 2,125 10,000 3,500 2,000 2,000 2,00 :-820-54-00-5468 AUTOMATION 38,933 24,973 40,000 45,500 30,000 30,000 30,00 l-820-54-00-5480 UTILITIES 15,454 12,009 48,000 20,000 15,000 15,000 15,00 Electricity $5,000 Gas $10,000 :-820-54-00-5485 RENTAL&LEASE PURCHASE 1,638 2,442 15.000 3,000 - - - :-820-54-00-5489 BUILDING-DEVELOPMENT FEES 6,850 16,171 20.000 20,000 - :-820-54-00-5495 OUTSIDE REPAIR AND MAINTENANCE 28,892 47,872 30.000 25,000 4,000 4,000 4,00 Maintenance-Bldg&Janitorial $4,000 Total: Contractual Services $129,909 $152,280 $258,500 $1929000 $105,100 $105,100 $105,11 ipplies :-820-56-00-5610 LIBRARY SUPPLIES 15,808 13,889 35,000 9,000 8,000 8,000 8,00 :-820-56-00-5620 OPERATING SUPPLIES 8,932 11,104 15,000 12,000 9,000 9,000 9100 Custodial Supplies $9,000 :-820-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 12,188 4,276 20,000 8,500 - - :-820-56-00-5640 REPAIR AND MAINTENANCE 6,404 2,506 20,000 3,000 - - - :-820-56-00-5671 LIBRARY PROGRAMMING 11,126 10,137 20,000 15,000 2,000 2,000 2,00 :-820-56-00-5676 EMPLOYEE RECOGNITION 1,194 1,113 4,000 - - United City of Yorkville Library Operations Fund 20 IBRARY OPERATIONS FUND EXPENDITURES FY 2009 FY 2010 FY 2011 FY 2011 FY 2012 FY 2013 FY 2014 :count Description Actual Actual Budget Projected Adopted* Projected Projected :-820-56-00-5680 ADULT BOOKS 20,412 20,213 50,000 40,000 :-820-56-00-5681 JUVENILE BOOKS 19,724 40,325 50,000 50,000 :-820-56-00-5682 REFERENCE BOOKS 21,716 24,097 35,000 20,000 :-820-56-00-5683 AUDIO BOOKS 11,708 8,176 30,000 17,500 :-820-56-00-5684 COMPACT DISCS AND OTHER MUSIC 6,645 2,963 15,000 4,000 - - :-820-56-00-5685 DVD'S 4,961 4,750 25,000 10,000 2,000 2,000 2,00 :-820-56-00-5686 BOOKS-DEVELOPMENT FEES 38,068 16,638 20,000 8,652 8,000 8,000 8,00 :-820-56-00-5698 MEMORIALS AND GIFTS 2,844 4,416 3,000 3,000 - - - :-820-56-00-5699 MISCELLANEOUS 147 83 3,000 2,000 250 250 25 Meeting Room$250 Total: Supplies $181,878 $164,687 $345,000 $202,652 $29,250 $29,250 $29,2.° sntingencies :-820-70-00-7799 CONTINGENCIES 6,923 4,985 144,561 10,000 1,000 1,000 1,00 Total: Contingencies $6,923 $4,985 $144,561 $10,000 $1,000 $1,000 $1,0( ebt Service-2005B Bond :-820-83-00-8000 PRINCIPLE PAYMENT 25,000 25,000 75,000 75,000 - :-820-83-00-8050 INTEREST PAYMENT 321,106 320,125 319,125 319,125 Total: Debt Service-2005B Bond $346,106 $345,125 $394,125 $394,125 $0 $0 ebt Service-2006 Bond :-820-84-00-8000 PRINCIPLE PAYMENT 50,000 150,060 150,000 150,000 :-820-84-00-8050 INTEREST PAYMENT 71,300 68,925 61,800 61,800 - Total: Debt Service-2006 Bond $121,300 $218,925 $211,800 $211,800 $0 $0 c ther Financing Uses :-820-99-00-9984 TRANSFER TO LIBRARY DEVLP FEE 332,500 Total: Other Financing Uses $0 $0 $0 $0 $332,500 $0 4 Total: LIBRARY OPS EXPENDITURES $1,314,193 $1,506,868 $2,158,986 $1,655,445 $1.060 275 $744,805 $760.9] Amended Budget