Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Administration Packet 2012 09-20-12
so C►r y z o United City of Yorkville J y y -" 800 Game Farm Road EST , 1836 Yorkville, Illinois 60560 .4 Telephone: 630-553-4350 O� a 4 Fax: 630-553-7575 ALL E AGENDA ADMINISTRATION COMMITTEE MEETING Thursday, September 20, 2012 6:00 p.m. City Hall Conference Room Citizen Comments: Minutes for Correction/Approval: New Business: 1. ADM 2012-49 Monthly Budget Report for August 2012 2. ADM 2012-50 Monthly Treasurer's Report for August 2012 3. ADM 2012-51 Monthly Cash Statement for July 2012 4. ADM 2012-52 Cultural Commission Discussion 5. ADM 2012-53 RFP for Sale of Caboose Old Business: 1. CC 2012-49 Ordinance Regarding City Council Procedures — Citizen Comments Additional Business: UNITED CITY OF YORKVILLE WORKSHEET ADMINISTRATION COMMITTEE Thursday, September 20, 2012 6:00 PM City Hall Conference Room --------------------------------------------------------------------------------------------------------------------------------------- CITIZEN COMMENTS: --------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------- NEW BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. ADM 2012-49 Monthly Budget Report for August 2012 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2012-50 Monthly Treasurer's Report for August 2012 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 3. ADM 2012-51 Monthly Cash Statement for July 2012 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 4. ADM 2012-52 Cultural Commission Discussion ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 5. ADM 2012-53 RFP for Sale of Caboose ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- OLD BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. CC 2012-49 Ordinance Regarding City Council Procedures—Citizen Comments ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- ADDITIONAL BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 0 CIP Reviewed By: Agenda Item Number J� a► Legal ❑ NB #1 W36 EST. Finance ■ Engineer ❑ Tracking Number Gy City Administrator ■ r� _© Consultant E] ADM 2012-49 Agenda Item Summary Memo Title: Budget Report for August 2012 Meeting and Date: Administration Committee 9/20/12 Synopsis: August budget report and income statement. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Discussion Submitted by: Rob Fredrickson Finance Name Department Agenda Item Notes: o Memorandum To: City Council EST _ 1e3s From: Bart Olson, City Administrator CC: p Date: September 13, 2012 co Keda cun" ` Subject: August 2012 budget reports General Fund Revenues 01-000-40-00-4000 Property Taxes—Corporate Levy The August figure represents the fourth property tax disbursement out of six. The amount collected in August is always a moderate amount. The disbursement in September will be the second largest amount for the entire fiscal year. 01-000-40-00-4030 Municipal Sales Tax The August figure of$217,858 is for consumer purchases made in May and turned into the state by the retailers in June. Our sales tax forecasting model projected this amount to be $205,334, so the actual figures were better than expected. This amount represents the second month coded to FY 13. 01-000-40-00-4035 Non-home rule sales tax The August figure of$170,425 represents consumer purchases made in May and turned into the state by the retailers in June. Our sales tax forecasting model projected this amount to be $132,473, so the actual figures were higher than expected. This amount represents the second month coded to FY 13. 01-000-40-00-4050 Hotel Tax The August figures were much higher than expected at $6,559, due to the success of Raging Waves and the success of the Hampton Inn. 01-000-40-00-4065 Admissions Tax This line-item represents the admissions tax on Raging Waves that is refunded to the developer to pay for on-site improvements. This amount is due to the City in October. 01-000-41-00-4100 State Income Tax State income taxes are still arriving late (3-6 later than expected) but are increasing year-over- year, in a potential sign the Illinois economy is improving. 01-000-42-00-4210 Building Permits Building permit amounts are expected to be high during summer months, but the amounts are higher than expected and higher than they were last year. Page 1 of 2 General Fund Expenses All salary line-items, all departments August figures are high because there were three paydays in August (3, 17, 31). 01-410-54-00-5458 Tree and Stump Removal The large amounts in August are due to the microburst storm cleanup. 01-640-54-00-5465 En ing eering Services The $37,148 entry in August represents the gross payment to EEI for services from the middle of June to the middle of July. Developer reimbursements will offset this expense, and are reflected in the reimbursement line-items in the general fund revenue sections. Water Fund 51-510-75-00-7502 Grande Reserve Court Order The final payment on the Grande Reserve Court Order is due in November 2012, which means there are only 3 payments left. Parks and Recreation Fund 79-000-44-00-4443 Hometown Days (revenue) The remaining Hometown Days revenues will be posted in September. We expect that the net income from the event will between $10,000 and $15,000. This is slightly lower than expected, due to the Saturday weather. 79-795-56-00-5602 Hometown Days supplies (expense) The majority of the remaining Hometown Days expenses will be posted in September. REC Center 80-800-54-00-5497 Property Tax Payment The second half of the annual property tax payment was made in August. Page 2 of 2 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING AUGUST 31,2012 ACTUALS BY MONTH(Cash Basis) %ofFiscat Year 8.33% 16.67% 25% 33% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 duly-12 August-12 Totals BUDGET %of Budget GENERAL FUND REVENUES Taxes 01-000-40-00-4000 PROPERTY TAXES-CORPORATE LEVY 325,574 811,918 30,493 139,583 1,307,567 2,288,133 57.15% 01-000-40-00-4010 PROPERTY TAXES-POLICE PENSION 62,734 156,446 5,876 26,896 251,951 413,354 60.95% 01-000-40-00-4012 PROPERTY TAXES-FOX INDUSTRIAL - - - - - 20,000 0.00% 01-000-40-00-4030 MUNICIPAL SALES TAX 177,588 206,467 199,248 217,858 801,161 2,325,000 34.46% 01-000-40-00-4035 NON-HOME RULE SALES TAX 127,336 161,729 154,035 170,425 613,525 1,500,000 40.90% 01-000-40-00-4040 ELECTRIC UTILITY TAX - 147,598 - - 147,598 603,432 24.46% 01-000-40-00-4041 NATURAL GAS UTILITY TAX - 65,896 - - 65,896 296,514 22.22% 01-000-40-00-4043 TELECOMMUNICATIONS TAX 39,153 49,552 39,941 40,944 169,590 490,000 34.61% 01-000-40-00-4044 TELEPHONE UTILITY TAX 1,422 1,400 1,360 1,345 5,527 23,500 23.52% 01-000-40-00-4045 CABLE FRANCHISE FEES 51,537 - - 53,038 104,575 230,000 45.47% 01-000-40-00-4050 HOTEL TAX 3,893 4,663 6,045 6,559 21,159 50,000 42.32% 01-000-40-00-4060 AMUSEMENT TAX 2,097 7,549 458 929 11,033 134,000 8.23% 01-000-40-00-4065 ADMISSIONS TAX - - - - - 104,500 0.00% 01-000-40-00-4070 BUSINESS DISTRICT TAX 20,290 28,833 22,647 24,613 96,382 300,000 32.13% 01-000-40-00-4075 AUTO RENTAL TAX 838 748 773 688 3,048 10,000 30.48% 01-000-40-00-4080 PARA-MUTUEL TAX - - - 314 314 - 0.00% Intergovernmental 01-000-41-00-4100 STATE INCOME TAX 263,968 94,310 146,433 212,616 717,327 1,320,000 54.34% 01-000-41-00-4105 LOCAL USE TAX 17,811 22,020 20,307 21,234 81,371 242,400 33.57% 01-000-41-00-4110 ROAD&BRIDGE TAX 26,133 59,409 2,217 11,285 99,045 170,000 58.26% 01-000-41-00-4120 PERSONAL PROPERTY TAX 2,230 - 2,881 348 5,459 16,000 34.12% 01-000-41-00-4160 FEDERAL GRANTS 1,107 - 7,941 9,048 9,200 98.34% 01-000-41-00-4170 STATE GRANTS - - - - 0.00% 01-000-41-00-4182 MISC INTERGOVERNMENTAL - - - 2,000 0.00% Licenses&Permits 01-000-42-00-4200 LIQUOR LICENSE 1,773 625 2,398 40,000 5.99% 01-000-42-00-4205 OTHER LICENSES&PERMITS 60 232 - - 292 2,700 10.80% 01-000-42-00-4210 BUILDING PERMITS 15,853 17,748 8,896 12,572 55,069 126,600 43.50% Fines&Forfeits 01-000-43-00-4310 TRAFFIC FINES 4,338 4,515 5,711 5,687 20,251 95,000 21.32% 01-000-43-00-4320 ADMINISTRATIVE ADJUDICATION 1,580 3,096 1,944 2,157 8,777 26,000 33.76% 01-000-43-00-4325 POLICE TOWS 3,500 3,000 9,500 7,375 23,375 80,000 29.22% 01-000-43-00-4350 LATE PMT PENALTIES-GARBAGE 14 4,022 20 3,937 7,993 - 0.00% Charges for Service 01-000-44-00-4400 GARBAGE SURCHARGE (15) 201,224 220 180,008 381,437 1,021,784 37.33% 01-000-44-00-4405 COLLECTION FEE-YBSD - - - - - 151,500 0.00% 01-000-44-00-4474 POLICE SPECIAL DETAIL - - - - - 5,000 0.00% 01-000-44-00-4475 OFFENDER REGISTRATION FEES 5 30 30 25 90 500 18.00% Investment Earnings 01-000-45-00-4500 INVESTMENT EARNINGS 584 641 762 322 2,309 3,100 74.48% Reimbursements 01-000-46-00-4601 REIMB-LEGAL EXPENSES 1,100 - 1,096 934 3,130 - 0.00% 01-000-46-00-4604 REIMB-ENGINEERING EXPENSES 41,145 945 5,283 (31,617) 15,755 - 0.00% 01-000-46-00-4650 REIMB-TRAFFIC SIGNAL - - - 20,019 20,019 15,000 133.46% 01-000-46-00-4668 REIMB-COBRA CONTRIBUTIONS - 817 - - 817 12,500 6.53% 01-000-46-00-4669 REIMB-RETIREE CONTRIBUTIONS 4,785 5,782 3,861 5,782 20,211 60,398 33.46% 01-000-46-00-4670 REIMB-EMP INS CONTRIBUTIONS 5,193 5,265 5,379 6,128 21,965 61,295 35.84% 01-000-46-00-4671 REIMB-LIFE INSURANCE 181 181 207 190 758 1,699 44.64% 1 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING AUGUST 31,2012 ACTUALS BY MONTH(Cash Basis) %ojFiscalYear 8.33% 16.67% 25% 33% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 duly-12 August-12 Totals BUDGET %of Budget 01-000-46-00-4680 REIMB-LIABILITY INSURANCE 6,608 1,302 1,514 9,424 5,000 188.49% 01-00046-00-4681 REIMB-WORKERS COMP 25,557 - - 25,557 - 0.00% 01-000-46-00-4685 REIMB-CABLE CONSORTIUM 18,128 - - - 18,128 40,000 45.32% 01-000-46-00-4690 REIMB-MISCELLANEOUS 1,453 417 165 2,171 4,205 4,000 105.13% Other Financing Sources 01-000-48-00-4820 RENTAL INCOME 875 725 545 560 2,705 8,000 33.81% 01-000-48-00-4850 MISCELLANEOUS INCOME - - - 2 2 3,000 0.060/, TOTAL REVENUES:GENERAL FUND 1,256,427 2,068,475 676,334 1,155,008 5,156,244 12,311,109 41.88% ADMINISTRATION EXPENDITURES Salaries&Wages 01-110-50-00-5001 SALARIES-MAYOR 825 725 825 725 3,100 11,000 28.18% 01-110-50-00-5002 SALARIES-LIQUOR COMM 83 83 83 83 333 1,000 33.34% 01-110-50-00-5003 SALARIES-CITY CLERK 742 742 642 642 2,767 9,000 30.74% 01-110-50-00-5004 SALARIES-CITY TREASURER 500 500 300 500 1,800 6,500 27.69% 01-110-50-00-5005 SALARIES-ALDERMAN 4,000 3,800 3,900 4,000 15,700 50,320 31.20% 01-110-50-00-5010 SALARIES-ADMINISTRATION 18,304 19,627 19,362 30,671 87,964 255,000 34.50% 01-110-50-00-5020 OVERTIME - - - - - 575 0.00% Benefits 01-110-52-00-5212 RETIREMENT PLAN CONTRIBUTION 2,222 2,330 2,199 3,113 9,863 28,383 34.75% 01-110-52-00-5214 FICA CONTRIBUTION 1,695 1,773 1,745 2,595 7,808 22,500 34.70% 01-110-52-00-5216 GROUP HEALTH INSURANCE 8,798 5,410 5,134 5,984 25,326 72,456 34.95% 01-110-52-00-5222 GROUP LIFE INSURANCE 29 50 66 48 193 614 31.48% 01-110-52-00-5223 GROUP DENTAL INSURANCE 386 430 408 408 1,632 5,096 32.02% 01-110-52-00-5224 VISION INSURANCE 44 44 44 44 178 586 30.32% 01-110-52-00-5235 ELECTED OFFICIAL-GROUP HEALTH INS 9,789 10,505 10,291 8,569 39,154 133,917 29.24% 01-110-52-00-5236 ELECTED OFFICIAL-GROUP LIFE INSURANCE 44 70 57 57 227 1,043 21.80% 01-110-52-00-5237 ELECTED OFFICIAL-DENTAL INSURANCE 758 846 802 547 2,953 10,008 29.51% 01-110-52-00-5238 ELECTED OFFICIAL-VISIONINSURANCE 86 86 86 72 329 1,129 29.11% Contractual Services 01-110-54-00-5412 TRAINING&CONFERENCES - - 3,000 0.00% 01-110-54-00-5415 TRAVEL&LODGING 31 28 339 398 6,000 6.63% 01-110-54-00-5426 PUBLISHING&ADVERTISING - 71 71 1,000 7.08% 01-110-54-00-5430 PRINTING&DUPLICATION 441 660 986 2,088 6,750 30.93% 01-110-54-00-5440 TELECOMMUNICATIONS 1,902 843 2,940 5,685 15,000 37.90% 01-110-54-00-5448 FILING FEES 39 - - 39 500 7.80% 01-110-54-00-5451 CODIFICATION - 1,322 1,322 8,000 16.53% 01-110-54-00-5452 POSTAGE&SHIPPING - - 113 185 298 14,000 2.13% 01-110-54-00-5460 DUES&SUBSCRIPTIONS 8,702 1,036 155 592 10,485 16,600 63.16% 01-110-54-00-5462 PROFESSIONAL SERVICES 541 678 679 1,545 3,443 20,000 17.21% 01-110-54-00-5473 KENDALL COUNTY PARATRANSIT - - - - - 30,000 0.00% 01-110-54-00-5480 UTILITIES - 22 - 22 23,100 0.09% 01-110-54-00-5485 RENTAL&LEASE PURCHASE 143 143 143 143 572 1,900 30.11% 01-110-54-00-5488 OFFICE CLEANING 1,196 1,196 1,196 3,588 14,400 24.92% 2 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING AUGUST 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8.33% 16.67% 25% 33% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 Totals BUDGET %of Budget Supplies 01-110-56-00-5610 OFFICE SUPPLIES 1,229 557 246 261 2,292 12,000 19.10% 01-110-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - - - 850 0.00% 01-110-56-00-5640 REPAIR&MAINTENANCE - - - - - 100 0.00% TOTAL EXPENDITURES:ADMINISTRATION 58,920 53,066 50,006 67,639 229,631 r 782,327 t 29.35% FINANCE EXPENDITURES Salaries&Wages 01-120-50-00-5010 SALARIES&WAGES 12,991 14,152 13,295 20,089 60,526 185,000 32.72% Benefits 01-120-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,281 1,393 1,311 1,965 5,950 18,659 31.89% 01-120-52-00-5214 FICA CONTRIBUTION 985 1,074 1,009 1,519 4,588 13,005 35.27% 01-120-52-00-5216 GROUP HEALTH INSURANCE 2,332 2,286 1,873 2,867 9,358 26,472 35.35% 01-120-52-00-5222 GROUP LIFE INSURANCE 22 38 30 30 119 461 25.82% 01-120-52-00-5223 DENTALINSURANCE 241 269 255 255 1,020 3,182 32.07% 01-120-52-00-5224 VISION INSURANCE 27 27 27 27 108 356 30.31% Contractual Services 01-120-54-00-5412 TRAINING&CONFERENCES 440 155 595 2,000 29.75% 01-120-54-00-5414 AUDITING SERVICES - - - 36,000 0.00% 01-120-54-00-5415 TRAVEL&LODGING 18 71 89 1,000 8.90% 01-120-54-00-5430 PRINTING&DUPLICATING - 500 0.00% 01-120-54-00-5440 TELECOMMUNICATIONS 45 45 95 185 600 30.81% 01-120-54-00-5452 POSTAGE&SHIPPING - - 500 0.00% 01-120-54-00-5460 DUES&SUBSCRIPTIONS 80 - 35 - 115 850 13.53% 01-120-54-00-5462 PROFESSIONAL SERVICES - 572 2,723 474 3,770 40,000 9.42% 01-120-54-00-5485 RENTAL&LEASE PURCHASE 143 143 143 143 572 4,900 11.67% 01-120-54-00-5495 OUTSIDE REPAIR&MAINTENANCE - - - - - 1,800 0.00% Supplies 01-120-56-00-5610 OFFICE SUPPLIES 273 11 29 482 794 2,500 31.78% 01-120-56-00-5630 SMALL TOOLS&EQUIPMENT - 250 0.00% 01-120-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - - - 2,500 0.00% TOTAL EXPENDITURES:FINANCE 18,815 20,183 20,846 27,946 87,789 3409535 25.78% POLICE EXPENDITURES Salaries&Wages 01-210-50-00-5010 SALARIES-POLICE OFFICERS 87,792 92,359 89,850 141,646 411,647 1,261,000 32.64% 01-210-50-00-5011 SALARIES-POLICE CHIEF&DEPUTIES 21,248 24,183 21,329 33,243 100,003 317,000 31.55% 01-210-50-00-5012 SALARIES-SERGEANTS 22,788 23,286 22,935 34,182 103,190 430,000 24.00% 01-210-50-00-5013 SALARIES-POLICE CLERKS 9,434 10,161 9,567 15,321 44,484 135,000 32.95% 01-210-50-00-5014 SALARIES-CROSSING GUARD 2,110 844 - 726 3,680 20,000 18.40% 01-210-50-00-5015 PART-TIME SALARIES 2,017 3,614 3,584 6,250 15,465 52,500 29.46% 01-210-50-00-5020 OVERTIME 5,429 10,280 11,348 7,751 34,808 90,000 38.68% Benefits 01-210-52-00-5212 RETIREMENT PLAN CONTRIBUTION 884 950 889 1,430 4,152 15,818 26.25% 01-210-52-00-5213 EMPLOYER CONTRI-POL PEN 62,734 156,446 5,876 26,896 251,951 413,354 60.95% 01-210-52-00-5214 FICA CONTRIBUTION 11,035 12,089 11,613 17,577 52,314 175,000 29.89% 01-210-52-00-5216 GROUP HEALTH INSURANCE 33,174 32,961 30,202 30,180 126,517 517,950 24.43% 01-210-52-00-5222 GROUP LIFE INSURANCE 203 581 400 394 1,578 5,635 28.00% 01-210-52-00-5223 DENTAL INSURANCE 2,474 2,939 2,706 2,706 10,826 37,428 28.92% 01-210-52-00-5224 VISION INSURANCE 283 301 319 265 1,168 4,272 27.34% 3 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING AUGUST 31,2012 ACTUALS BY MONTH(Cash Basis) %ojFiscalYear 8.33% 16.67% 25% 33% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 duly-12 August-12 Totals BUDGET %of Budget Contractual Services 01-210-54-00-5410 TUITION REIMBURSEMENT - - - - 2,800 0.00% 01-210-54-00-5411 POLICE COMMISSION 500 625 821 - 1,946 4,000 48.64% 01-210-54-00-5412 TRAINING&CONFERENCES 2,250 961 245 225 3,681 15,000 24.54% 01-210-54-00-5415 TRAVEL&LODGING 39 201 376 33 649 10,000 6.49% 01-210-54-00-5426 PUBLISHING&ADVERTISING - - - - - 200 0.00% 01-210-54-00-5430 PRINTING&DUPLICATING 82 692 (504) 270 4,500 6.00% 01-210-54-00-5440 TELECOMMUNICATIONS 44 2,926 993 3,261 7,225 36,500 19.79% 01-210-54-00-5452 POSTAGE&SHIPPING - 18 - 18 3,000 0.61% 01-210-54-00-5460 DUES&SUBSCRIPTIONS - 50 50 (50) 50 1,350 3.70% 01-210-54-00-5462 PROFESSIONAL SERVICES 333 184 100 3,691 4,308 5,000 86.16% 01-210-54-00-5466 LEGAL SERVICES - - - - - 20,000 0.00% 01-210-54-00-5467 ADMIN ADJ-HEARING OFFICER 858 2,380 1,077 4,315 20,000 21.58% 01-210-54-00-5469 NEW WORLD LIVE SCAN - - 9,665 9,665 15,000 64.43% 01-210-54-00-5472 KENDALL CO.JUVE PROBATION - - - 4,000 0.00% 01-210-54-00-5484 MDT-ALERTS FEE - 3,330 - - 3,330 7,000 47.57% 01-210-54-00-5485 RENTAL&LEASE PURCHASE 277 352 352 352 1,333 4,500 29.62% 01-210-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 938 7,639 2,907 3,727 15,211 61,000 24.94% Supplies 01-210-56-00-5600 WEARING APPAREL 67 1,107 535 2,575 4,285 16,000 26.78% 01-210-56-00-5610 OFFICE SUPPLIES - 153 260 661 1,073 4,000 26.84% 01-210-56-00-5620 OPERATING SUPPLIES 680 595 71 1,347 8,000 16.83% 01-210-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE 163 2,499 - 2,662 7,000 38.03% 01-210-56-00-5640 REPAIR&MAINTENANCE 16 358 345 719 12,250 5.87% 01-210-56-00-5650 COMMUNITY SERVICES - - - 7,370 0.00% 01-210-56-00-5690 SUPPLIES-GRANT REIMBURSABLE - 3,025 - 3,025 4,200 72.02% 01-210-56-00-5695 GASOLINE 6,472 7,001 7,217 20,690 90,950 22.75% 01-210-56-00-5696 AMMUNITION 207 - 207 2,000 10.35% TOTAL EXPENDITURES:POLICE 266,070 397,340 233,811 350,570 1,247,790 3,840,577 32.49% COMMUNITY DEVELOPMENT EXPENDITURES Salaries&Wages 01-220-50-00-5010 SALARIES&WAGES 14,236 14,435 15,373 23,318 67,361 195,000 34.54% 01-220-50-00-5015 PART-TIME SALARIES - - - - - 53,000 0.00% Benefits 01-220-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,306 1,259 1,349 2,054 5,968 26,227 22.75% 01-220-52-00-5214 FICA CONTRIBUTION 1,050 1,065 1,137 1,731 4,982 19,000 26.22% 01-220-52-00-5216 GROUP HEALTH INSURANCE 3,454 4,695 3,254 2,789 14,191 59,499 23.85% 01-220-52-00-5222 GROUP LIFE INSURANCE 15 56 35 45 150 461 32.64% 01-220-52-00-5223 DENTALINSURANCE 241 269 255 255 1,020 4,139 24.65% 01-220-52-00-5224 VISION INSURANCE 27 27 - 63 117 471 24.86% Contractual Services 01-220-54-00-5412 TRAINING&CONFERENCES 685 685 1,500 45.67% 01-220-54-00-5415 TRAVEL&LODGING - - 1,000 0.00% 01-220-54-00-5426 PUBLISHING&ADVERTISING 94 24 118 500 23.68% 4 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING AUGUST 31,2012 ACTUALS BY MONTH(Cash Basis) %ojFiscalYear 8.33% 16.67% 25% 33% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION IL May-12 June-12 duly-12 August-12 Totals BUDGET %of Budget 01-220-54-00-5430 PRINTING&DUPLICATING 119 385 223 727 4,250 17.10% 01-220-54-00-5440 TELECOMMUNICATIONS 151 153 189 492 1,500 32.81% 01-220-54-00-5452 POSTAGE&SHIPPING - - - - 500 0.00% 01-220-54-00-5459 INSPECTIONS - - - 25,000 0.00% 01-220-54-00-5460 DUES&SUBSCRIPTIONS 422 - - 470 892 1,500 59.47% 01-220-54-00-5462 PROFESSIONAL SERVICES - 3,600 1,607 - 5,207 6,000 86.78% 01-220-54-00-5466 LEGAL SERVICES - 366 618 - 983 2,000 49.16% 01-220-54-00-5485 RENTAL&LEASE PURCHASE 273 273 273 273 1,092 3,600 30.33% 01-220-54-00-5486 ECONOMIC DEVELOPMENT - - - - - 45,000 0.00% Supplies 01-220-56-00-5610 OFFICE SUPPLIES 34 15 116 166 500 33.11% 01-220-56-00-5620 OPERATING SUPPLIES 1,282 - - 1,282 3,000 42.74° 01-220-56-00-5630 SMALL TOOLS&EQUIPMENT - 4 (4) - 125 0.00% 01-220-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - 1,211 - 1,211 3,500 34.61% 01-220-56-00-5645 BOOKS&PUBLICATIONS - - - - 500 01-220-56-00-5695 GASOLINE - 172 262 398 832 3,654 22.77% TOTAL EXPENDITURES:COMMUNITY DEVELP 21,058 27,877 25,915 32,627 107,477 461,426 23.29% PUBLIC WORKS-STREET OPERATIONS EXPENDITURES Salaries&Wages 01-410-50-00-5010 SALARIES&WAGES 19,701 20,818 19,822 30,914 91,255 280,000 32.59% 01-410-50-00-5020 OVERTIME 224 - 701 12 938 15,000 6.25% Benefits 01-410-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,921 2,007 1,978 2,981 8,887 31,753 27.99% 01410-52-00-5214 FICA CONTRIBUTION 1,470 1,538 1,514 2,304 6,826 23,500 29.05% 01-410-52-00-5216 GROUP HEALTH INSURANCE 6,729 12,250 6,595 6,595 32,170 83,361 38.59% 01-410-52-00-5222 GROUP LIFE INSURANCE 36 179 109 109 434 1,317 32.98% 01-410-52-00-5223 DENTAL INSURANCE 559 623 591 591 2,364 6,826 34.63% 01-410-52-00-5224 VISION INSURNCE 59 59 59 59 234 773 30.30% Contractual Services 01-410-54-00-5412 TRAINING&CONFERENCES - 705 - - 705 2,000 35.25% 01-410-54-00-5440 TELECOMMUNICATIONS 212 216 213 640 4,020 15.92% 01410-54-00-5446 PROPERTY&BUILDING MAINT SERVICES 25 1,269 216 - 1,510 20,000 7.55% 01-410-54-00-5454 SIDEWALK PROGRAM - - 110 110 4,000 2.76% 01410-54-00-5455 MOSQUITO CONTROL 6,730 - - - 6,730 7,000 96.14% 01-410-54-00-5458 TREE&STUMP REMOVAL - 164 3,596 6,575 10,335 20,000 51.68% 01-410-54-00-5462 PROFESSIONAL SERVICES - 600 26 626 1,000 62.60% 01-410-54-00-5480 UTILITIES - 2,672 2,562 2,824 8,058 90,000 8.95% 01-410-54-00-5485 RENTAL&LEASE PURCHASE 33 33 248 33 347 1,000 34.73% 01-410-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 126 1,365 405 3,641 5,537 35,000 15.82% Supplies 01-410-56-00-5600 WEARING APPAREL 39 275 66 167 547 4,200 13.03% 01-410-56-00-5620 OPERATING SUPPLIES 106 116 197 196 615 9,500 6.47% 01-410-56-00-5630 SMALL TOOLS&EQUIPMENT - 11 73 - 84 1,750 4.82% 01-410-56-00-5640 REPAIR&MAINTENANCE - 2,614 653 2,336 5,603 36,500 15.35% 01-410-56-00-5656 PROPERTY&BUILDING MAINT SUPPLIES 173 51 61 37 322 20,000 1.61% 01410-56-00-5695 GASOLINE - 1,891 1,843 2,006 5,740 15,952 35.98% TOTAL EXP:PUBLIC WORKS-STREET OPS 37,931 48,853 42,216 61,619 190,618 714,452 26.68% 5 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING AUGUST 31,2012 ACTUALS BY MONTH(Cash Basis) %ojFiscat Year 8.33% 16.67% 25% 33% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 duly-12 August-12 Totals BUDGET %of Budget PW-HEALTH&SANITATION EXPENDITURES Contractual Services 01-540-54-00-5441 GARBAGE SRVCS-SR SUBSIDY 13,100 26,363 39,463 153,216 25.76% 01-540-54-00-5442 GARBAGE SERVICES 84,769 169,400 254,169 1,046,784 24.28% 01-540-54-00-5443 LEAF PICKUP - - - 6,000 0.00% TOTAL EXPENDITURES:HEALTH&SANITATION 97,868 195,763 293,631 19206,000 24.35% ADMINISTRATIVE SERVICES EXPENDITURES Salaries&Wages 01-640-50-00-5092 POLICE SPECIAL DETAIL WAGES - - 5,000 0.00% Benefits 01-640-52-00-5212 RETIREMENT PLAN CONTRIBUTION-ERI 60,000 0,00% 01-640-52-00-5225 EMPLOYEE ASSISTANCE 150 0.00% 01-640-52-00-5230 UNEMPLOYMENT INSURANCE 11,387 - 3,846 - 15,233 47,143 32.31% 01-640-52-00-5231 LIABILITY INSURANCE 69,484 15,879 17,119 15,879 118,361 332,256 35.62% 01-640-52-00-5240 RETIREES-GROUP HEALTH INS 7,269 9,504 6,680 9,078 32,530 104,458 31.14% 01-640-52-00-5241 RETIREES-DENTAL INSURANCE 397 440 419 507 1,763 5,246 33.61% 01-640-52-00-5242 RETIREES-VISION INSURANCE 48 48 48 48 193 636 30.31% 01-640-52-00-5250 COBRA-GROUP HEALTH INS 408 - - - 408 11,375 3.59% 01-640-52-00-5251 COBRA-DENTAL INSURANCE - - 1,000 0.00% 01-640-52-00-5252 COBRA-VISION INSURANCE - 125 0.00% Contractual Services 01-640-54-00-5450 INFORMATION TECH SRVCS 2,040 4,635 18,067 5,472 30,214 140,000 21.58% 01-640-54-00-5456 CORPORATE COUNSEL - 6,562 - 10,234 16,796 130,000 12.92% 01-640-54-00-5461 LITIGATION COUNSEL - - 12,607 4,333 16,940 60,000 28.23% 01-640-54-00-5462 PROFESSIONAL SERVICES 450 - - 1 451 500 90.20% 01-640-54-00-5463 SPECIAL COUNSEL - 225 450 1,887 2,562 25,000 10.25% 01-640-54-00-5465 ENGINEERING SERVICES 35,010 - 37,148 72,157 180,000 40.09% 01-640-54-00-5475 CABLE CONSORTIUM FEE - - - - 85,000 0.00% 01-640-54-00-5481 HOTEL TAX REBATE 4,179 5,441 9,619 45,000 21.38% 01-640-54-00-5491 CITY PROPERTY TAX REBATE - - - 1,500 0.00% 01-640-54-00-5492 SALES TAX REBATE - - 367 367 824,000 0.04% 01-640-54-00-5493 BUSINESS DISTRICT REBATE (28,833) 28,833 22,647 24,613 47,260 300,000 15.75% 01-640-54-00-5494 ADMISSIONS TAX REBATE - - - - 104,500 0.00% Supplies 01-640-56-00-5625 REIMBURSEABLE REPAIRS 6,600 802 7,403 5,000 148.06% Contingencies 01-640-70-00-7799 CONTINGENCIES 50,000 0.00% Other Financing Uses 01-640-99-00-9923 TRANSFER TO CITY WIDE CAPITAL 34,944 34,944 34,944 34,944 139,777 419,332 33.33° 01-640-99-00-9942 TRANSFER TO DEBT SERVICE 8,289 8,289 8,289 8,289 33,155 99,465 33.33% 01-640-99-00-9979 TRANSFER TO PARK&RECREATION 79,657 79,657 79,657 79,657 318,629 955,886 33.33% 01-640-99-00-9982 TRANSFER TO LIBRARY OPS 9,733 1,801 1,801 2,151 15,486 41,978 36.89% TOTAL EXPENDITURES:ADMIN SERVICES 195,274 2329427 211,556 240,047 879,304 4,034,550 21.79% TOTAL FUND REVENUES 1,256,427 2,068,475 676,334 1,155,008 5,156,244 12,311,109 41.88% TOTAL FUND EXPENDITURES 598,067 877,614 584,349 976,210 3,036,240 11,379,867 26.68% FUND SURPLUS(DEFICIT) 6589360 1,190,861 91,985 178,798 29120,004 931,242 6 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING AUGUST 31,2012 ACTUALS BY MONTH(Cash Basis) %ojFiscat Year 8.33% 16.67% 25% 33% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 duly-12 August-12 Totals BUDGET %of Budget FOX HILL SSA REVENUES 11-000-40-00-4011 1 PROPERTY TAXES-FOX HILL SSA 551 1,286 90 263 2,190 3,786 57.85% 11-000-45-00-4500 INVESTMENT EARNINGS 0 0 0 1 2 - 0.00% TOTAL REVENUES:FOX HILL SSA 551 1,286 91 264 2,192 3,786 57.90% FOX HILL SSA EXPENDITURES 11-111-54-00-5495 1 OUTSIDE REPAIR&MAINTENANCE 529 1,338 423 2,290 4,500 50.90% TOTAL FUND REVENUES 551 1,286 91 264 2,192 3,786 57.90% [ TOTAL FUND EXPENDITURES - 529 1,338 423 2,290 4,500 50.90% FUND SURPLUS(DEFICIT) 551 757 (1,248) (160) (98) (714) SUNFLOWER SSA REVENUES 12-000-40-00-4012 PROPERTY TAXES-SUNFLOWER SSA 1,370 2,467 57 478 4,372 7,531 58.05% 12-000-45-00-4500 1 INVESTMENT EARNINGS 0 1 1 1 2 - 0.00% TOTAL REVENUES:SUNFLOWER SSA 1,370 2,467 58 479 4,374 7,531 58.08% SUNFLOWER SSA EXPENDITURES 12-112-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 1,312 2,854 1 2,024 6,190 9,986 61.99% TOTAL FUND REVENUES 1,370 1 2,467 58 1 479 4,374 7,531 1 58.08% ITOTAL FUND EXPENDITURES 1,312 2,854 1 2,024 l 6,190 91986 61.99% IFUND SURPLUS(DEFICIT) 1,370 1,155 (2,796) (1,545) (1,816) (2,455) MOTOR FUEL TAX REVENUES 15-000-41-00-4112 MOTOR FUEL TAX 32,850 36,593 30,824 36,021 136,288 415,000 32.84% 15-000-41-00-4113 MFT HIGH GROWTH - - - - - 39,197 0.00% 15-000-45-00-4500 INVESTMENT EARNINGS 212 208 219 246 885 350 252.92% TOTAL REVENUES:MOTOR FUEL TAX 33,063 36,801 31,043 36,267 137,173 454,547 30.18% MOTOR FUEL TAX EXPENDITURES Supplies 15-155-56-00-5618 SALT 231,000 0.00% 15-155-56-00-5619 SIGNS 106 175 281 35,000 0.80% 15-155-56-00-5632 PATCHING - - - 50,000 0.00% 15-155-56-00-5633 COLD PATCH 1,647 ;2,465 4,113 11,660 35.27% 15-155-56-00-5634 HOT PATCH 2,901 402 6,303 14,300 44.08% Ca italOutla 15-155-60-00-6073 GAME FARM ROAD PROJECT 110,000 0.00% 15-155-60-00-6079 ROUTE 47 EXPANSION - - - 121,900 0.00% TOTAL FUND REVENUES 33,063 36,801 31,043 36,267 137,173 454,547 30.18% ITOTAL FUND EXPENDITURES - 106 4,723 5,868 10,696 573,860 1.86% FUND SURPLUS(DEFICIT) 33,063 36,695 26,320 30,399 126,477 (119,313) MUNICIPAL BUILDING REVENUES 16-000-42-00-4214 DEVELOPMENT FEES 900 450 300 450 2,100 5,250 40.00% 16-000-42-00-4216 1 BUILD PROGRAM PERMIT 300 300 600 - 1,200 - 0.00% TOTAL REVENUES:MUNICIPAL BUILDING 1,200 750 900 450 3,300 5,250 62.86% 7 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING AUGUST 31,2012 ACTUALS BY MONTH(Cash Basis) %ofFiscat Year 8.33% 16.67% 25% 33% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 duly-12 August-12 Totals BUDGET %of Budget MUNICIPAL BUILDING EXPENDITURES 16-160-54-00-5405 BUILD PROGRAM 300 1 300 1 600 1 - 1,200 1 - Ir TOTAL FUND REVENUES 1,200 750 900 450 3,300 5,250 62.86% ITOTAL FUND EXPENDITURES 300 300 600 - 1,200 - 0.00% FUND SURPLUS(DEFICIT) 900 450 300 450 2,100 5,250 POLICE CAPITAL REVENUES Licenses&Permits 20-000-42-00-4214 DEVELOPMENT FEES 2,250 3,409 1,800 900 8,359 10,500 79.61% 20-000-42-00-4217 WEATHER WARNING SIREN FEES - - - - - 6,000 0.00% Fines&Forfeits 20-000-43-00-4315 DUI FINES 594 126 569 1,290 6,000 21.49% 20-000-43-00-4316 ELECTRONIC CITATION FEE 62 70 123 255 650 39.20% 20-000-43-00-4340 SEIZED VEHICLE PROCEEDS 9,000 - 9,000 5,000 180.00% Investment Earnings 20-000-45-00-4500 INVESTMENT EARNINGS 2 3 3 4 13 50 26.20% Miscellaneous 20-000-48-00-4880 SALE OF FIXED ASSETS - 200 - 200 1,000 20.00% TOTAL REVENUES:POLICE CAPITAL 2,908 3,808 1Q 803 1,597 19,116 29,200 65.471% POLICE CAPITAL EXPENDITURES Contractual Services �Wv 20-200-54-00-5462 PROFESSIONAL SERVICES - - 3,542 - 3,542 2,500 141.68° 20-200-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 5,491 5,187 10,677 10,000 106.77% Supplies - 20-200-56-00-5620 OPERATING SUPPLIES - - - - 2,500 0.00% Capital Outlay 20-200-60-00-6060 EQUIPMENT 12,256 52,500 64,756 1 20,000 323.78% 20-200-60-00-6070 VEHICLES 39,451 1 - 39,451 1 25,000 157.81% TOTAL FUND REVENUES 2,908 3,808 10,803 1,597 19,116 29,200 65.47% TOTAL FUND EXPENDITURES 44,942 12,256 61,229 - 118,427 60,000 197.38% FUND SURPLUS(DEFICIT) (42,034) (8,448) (50,426) 1,597 (99,310) (30,800) PUBLIC WORKS CAPITAL REVENUES Licenses&Permits JL 21-000-42-00-4213 ENGINEERING CAPITAL FEE 700 400 600 300 2,000 6,500 30.77% 21-000-42-00-4214 DEVELOPMENT FEES 3,950 2,550 1,400 2,100 10,000 24,500 40.82% 21-000-42-00-4216 BUILD PROGRAM PERMIT 1,400 1,400 2,800 - 5,600 - 0.00% Charges far Service � 21-000-44-00-4418 MOWING INCOME 1,690 526 1,274 (1,812) 1,678 20,000 8.39% Investment Earnings 21-000-45-00-4500 INVESTMENT EARNINGS 1 1 1 2 6 - 0.00% Other Financing Uses 21-000-49-00-4922 TSFR FROM PARK&REC CAPITAL 208 208 208 208 833 2,500 33.33% TOTAL REVENUES:PW CAPITAL REVENUES 7,949 1 5,085 1 6,284 798 20,117 53,500 37.60% PUBLIC WORKS CAPITAL EXPENDITURES Contractual Services 21-211-54-00-5405 1 BUILD PROGRAM 1,400 1,400 2,800 - 5,600 - 0.00% 21-211-54-00-5448 FILING FEES 49 343 392 6,000 6.53% 8 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING AUGUST 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8.33% 16.67% 25% 33% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 duly-12 August-12 Totals BUDGET %of Budget 21-211-54-00-5485 RENTAL&LEASE PURCHASE 4,500 0.00% Supplies 21-211-56-00-5620 OPERATING SUPPLIES 2,000 0.00% Capital Outlay 21-211-60-00-6060 EQUIPMENT - 75,000 0.00% PWBuilding-185 Wolf Street 21-211-92-00-8000 PRINCIPLE PAYMENT 2,435 2,448 2,461 2,473 9,817 30,074 32.64% 21-211-92-00-8050 INTEREST PAYMENT 4,423 4,410 4,397 4,385 17,615 52,221 33.73% TOTAL FUND REVENUES 7,949 5,085 6,284 798 20,117 53,500 37.60% TOTAL FUND EXPENDITURES 8,258 8,307 9,658 7,201 33,424 169,795 19.68% FUND SURPLUS(DEFICIT) (308) (3,222) (3,374) (6,403) (13,307) (116,295) PARK&RECREATION CAPITAL REVENUES 22-000-42-00-4215 PARKS CAPITAL FEES 850 1,000 1,850 3,250 56.92% 22-000-45-00-4500 INVESTMENT EARNINGS 38 36 37 41 153 250 61.02% 22-000-46-00-4690 REIMB-MISC - - - 40,000 0.00% TOTAL REVENUES:PARK&RECREATION CAPITAL 888 36 37 1,041 2,003 43,500 4.60% PARK&RECREATION CAPITAL EXPENDITURES 22-222-60-00-6035 RAINTREE PARK - - - 10,000 0.00% 22-222-60-00-6060 EQUIPMENT - - - - - 40,000 0.00% 22-222-99-00-9921 TRANSFER TO PW CAPITAL 208 208 208 208 833 2,500 33.33% TOTAL FUND REVENUES 888 36 37 1,041 2,003 43,500 4.60% TOTAL FUND EXPENDITURES 208 208 208 208 833 52,500 1.59% FUND SURPLUS(DEFICIT) 680 (172) (171) 833 1,169 (9,000) CITY-WIDE CAPITAL REVENUES Intergovernmental 23-000-41-00-4176 STATE GRANTS-SAFE RTE SCH 231,000 0.00% Licenses&Permits 23-000-42-00-4210 BUILDING PERMITS 13,400 0.00% 23-000-42-00-4214 DEVELOPMENT FEES - - 500 500 20,000 2.50% 23-000-42-00-4216 BUILD PROGRAM PERMIT 5,640 5,640 11,280 22,560 - 0.00% 23-000-42-00-4222 ROAD CONTRIBUTION FEE - - - - 20,000 0.00% Investment Earnin s 23-000-45-00-4500 INVESTMENT EARNINGS 14 15 16 22 67 - 0.00% Other Financing Sources 23-000-49-00-4901 TRANSFER FROM GENERAL 34,944 34,944 34,944 34,944 139,777 419,332 33.33% 23-000-49-00-4905 LOAN PROCEEDS - - - - 600,000 1 0.00% TOTAL REVENUES:CITY-WIDE CAPITAL 40,599 40,599 46,740 34,966 162,905 1 1,303,732 1 12.50% CITY-WIDE CAPITAL EXPENDITURES Contractual Services qw 23-230-54-00-5405 tROAD AM 5,640 5,640 11,280 22,560 0.00% 23-230-54-00-5462 L SERVICES - - - 19,468 19,468 100,000 19.47% Capital Outlay 23-230-60-00-6015 FACING - - 100,000 0.00% 23-230-60-00-6075 BRIDGE PROJECT 4,032 4,262 8,294 600,000 1.38% 23-230-60-00-6092 TO SCHOOL PROJECT 19,989 2,669 22,658 231,000 9.81% 23-230-60-00-6094 Y RD BIKE TRAIL - 9,500 0.00% 9 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING AUGUST 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8.33% 16.67% 25% 33% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 Totals BUDGET %of Budget TOTAL FUND REVENUES 40,599 40,599 46,740 34,966 162,905 1,303,732 12.50% TOTAL FUND EXPENDITURES 5,640 29,661 11,280 26,398 72,979 1,040,500 7.01% IL FUND SURPLUS(DEFICIT) 34,959 10,938 35,460 8,569 89,926 263,232 DEBT SERVICE REVENUES 42-000-40-00-4006 PROPERTY TAXES-2005A BOND 46,440 115,811 4,349 19,910 186,511 326,379 57.15% 42-000-42-00-4208 RECAPTURE FEES-WATER&SEWER 200 1,522 150 75 1,947 1,000 194.70% 42-000-45-00-4500 INVESTMENT EARNINGS 1 12 14 35 62 300 20.59% 42-000-49-00-4901 TRANSFER FROM GENERAL 8,289 8,289 8,289 8,289 33,155 99,465 33.33% TOTAL REVENUES:DEBT SERVICE 54,929 125,634 12,802 28,309 221,674 427,144 51.90% DEBT SERVICE EXPENDITURES 42-420-54-00-5498 PAYING AGENT FEES 214 375 - - 589 963 61.11% 2004C Bond 42-420-81-00-8000 PRINCIPLE PAYMENT - - - 95,000 0.00% 42-420-81-00-8050 INTEREST PAYMENT 2,233 2,233 4,465 50.00% 2005A Bond 42-420-82-00-8000 PRINCIPLE PAYMENT - - 205,000 0.00% 42-420-82-00-8050 INTEREST PAYMENT 60,689 60,689 121,379 50.00% 2002 Fox Industrial Bond 42-420-98-00-8000 PRINCIPLE PAYMENT-2002 - - 75,000 0.00% r42-420-98-00-8050 I INTEREST PAYMENT-2002 1,781 1,781 3,563 49.99% TOTAL FUND REVENUES 54,929 125,634 12,802 28,309 221,674 427,144 51.90% TOTAL FUND EXPENDITURES 1,995 63,296 - 65,292 505,370 12.92% FUND SURPLUS(DEFICIT) 52,934 62,338 12,802 28,309 156,383 (789226) WATER FUND REVENUES Taxes 51-000-40-00-4007 PROPERTY TAXES-2007A BOND 18,989 47,354 1,778 8,141 76,263 133,454 57.15% Licenses&Permits 51-000-42-00-4216 BUILD PROGRAM PERMIT 2,660 8,660 5,320 - 16,640 - 0.00% Fines&Forfeits 51-000-43-00-4350 LATE PMT PENALTIES-WATER 65 16,196 126 17,891 34,278 - 0.00% Charges far Service 51-000-44-00-4424 WATER SALES 1,111 322,220 8,325 440,159 771,815 1,699,871 45.40% 51-000-44-00-4425 BULK WATER SALES - - - 7,246 7,246 500 1449.29% 51-000-44-00-4430 WATER METER SALES 3,513 1,940 4,340 1,455 11,248 26,250 42.85% 51-000-44-00-4440 WATER INFASTRUCTURE FEE 103 114,051 199 113,874 228,227 675,000 33.81% 51-000-44-00-4450 WATER CONNECTION FEE 10,350 4,060 2,660 3,990 21,060 126,250 16.68% Investment Earnings 51-000-45-00-4500 INVESTMENT EARNINGS 44 68 78 180 370 300 123.22% Reimbursements 51-000-46-00-4670 REIMB-EMP INS CONTRIBUTIONS 685 645 604 604 2,538 7,225 35.13% 51-000-46-00-4671 REIMB-LIFE INSURANCE 26 12 12 12 64 241 26.47% 51-000-46-00-4690 REIMB-MISCELLANEOUS 99 - 25 50 175 - 0.00% Miscellaneous 51-000-48-00-4820 RENTAL INCOME 6,191 2,111 4,391 4,391 17,083 50,000 34.17% 10 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING AUGUST 31,2012 ACTUALS BY MONTH(Cash Basis) %ojFiscalYear 8.33% 16.67% 25% 33% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 Totals BUDGET %of Budget Other Financing Sources 51-000-49-00-4952 TRANSFER FROM SEWER 6,857 6,857 6,857 6,857 27,429 82,288 33.33% TOTAL REVENUES:WATER FUND 50,693 524,174 34,717 604,851 1,214,435 2,801,379 43.35% WATER OPERATIONS EXPENSES Salaries&Wages 51-510-50-00-5010 SALARIES&WAGES 26,260 26,315 21,710 44,120 118,404 370,000 32.00% 51-510-50-00-5020 OVERTIME 1,255 259 309 595 2,418 12,000 20.15% Benefits 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION 2,653 2,562 2,123 3,415 10,751 39,852 26.98% 51-510-52-00-5214 FICA CONTRIBUTION 2,022 1,953 1,609 3,325 8,909 28,200 31.59% 51-510-52-00-5216 GROUP HEALTH INSURANCE 5,863 5,920 5,601 4,847 22,230 103,966 21.38% 51-510-52-00-5222 GROUP LIFE INSURANCE 47 102 84 59 293 1,210 24.24% 51-510-52-00-5223 DENTAL INSURANCE 456 507 482 394 1,838 7,201 25.53% 51-510-52-00-5224 VISION INSURANCE 58 58 58 58 232 829 27.99% 51-510-52-00-5230 UNEMPLOYMENT INSURANCE 1,346 - 455 - 1,800 6,000 30.01% 51-510-52-00-5231 LIABILITY INSURANCE 6,769 1,552 1,552 1,552 11,425 32,462 35.19% Contractual Services 51-510-54-00-5405 BUILD PROGRAM 2,660 8,660 5,320 - 16,640 - 0.00% 51-510-54-00-5412 TRAINING&CONFERENCES - - 20 20 40 2,000 2.00% 51-510-54-00-5415 TRAVEL&LODGING - 6 6 1,600 0.38% 51-510-54-00-5426 PUBLISHING&ADVERTISING 1,117 - 1,117 1,000 111.69% 51-510-54-00-5429 WATER SAMPLES 99 - 25 521 645 14,000 4.60% 51-510-54-00-5430 PRINTING&DUPLICATING 10 10 5 25 2,500 1.00% 51-510-54-00-5440 TELECOMMUNICATIONS - 3,008 361 3,117 6,486 24,500 26.47% 51-510-54-00-5445 TREATMENT FACILITY SERVICES 130 891 9,631 11,513 22,165 100,000 22.17% 51-510-54-00-5448 FILING FEES - 245 392 1,068 1,705 6,200 27.50% 51-510-54-00-5452 POSTAGE&SHIPPING - 3,770 81 2,471 6,321 22,000 28.73% 51-510-54-00-5460 DUES&SUBSCRIPTIONS 298 389 - - 687 1,250 54.95% 51-510-54-00-5462 PROFESSIONAL SERVICES 456 2,728 1,040 18 4,243 8,800 48.22% 51-510-54-00-5466 LEGAL SERVICES - - - - - 2,000 0.00% 51-510-54-00-5480 UTILITIES 21,531 7,585 32,225 61,340 299,250 20.50% 51-510-54-00-5483 JULIE SERVICES 24 - (24) - 3,500 0.00% 51-510-54-00-5485 RENTAL&LEASE PURCHASE 33 33 33 33 132 1,000 13.20% 51-510-54-00-5495 OUTSIDE REPAIR&MAINTENANCE - 36 1,097 5,803 6,936 10,000 69.36% 51-510-54-00-5498 PAYING AGENT FEES 214 - 375 589 1,600 36.78% Supplies 51-510-56-00-5600 WEARING APPAREL 39 88 66 315 509 4,000 12.73% 51-510-56-00-5620 OPERATING SUPPLIES 90 520 123 1,468 2,201 21,425 10.27% 51-510-56-00-5630 SMALL TOOLS&EQUIPMENT 14 9 17 39 4,000 0.97% 51-510-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - 1,989 - (1,989) - 6,000 0.00% 51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 5,465 17,272 16,609 26,178 65,524 165,000 39.71% 51-510-56-00-5640 REPAIR&MAINTENANCE - 1,479 1,638 830 3,947 9,500 41.55% 51-510-56-00-5664 METERS&PARTS 3,574 1,348 4,805 9,727 46,000 21.15% 51-510-56-00-5695 GASOLINE 1,891 1,843 2,006 5,740 38,199 15.03% Capital Outlay 51-510-60-00-6060 EQUIPMENT - - - - 16,000 0.00% 51-510-60-00-6079 ROUTE 47 EXPANSION - - 116,000 0.00% Developer Commitments 51-510-75-00-7502 GRANDE RESERVE COURT ORDER 22,989 22,989 22,989 22,989 91,955 1 160,923 57.14% 2007A Bond 11 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING AUGUST 31,2012 ACTUALS BY MONTH(Cash Basis) %olFiscalYear 8.33% 16.67% 25% 33% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 duly-12 August-12 Totals BUDGET %of Budget 51-510-83-00-8000 PRINCIPLE PAYMENT - - 10,000 0.00% 51-510-83-00-8050 1 INTEREST PAYMENT - 61,727 61,727 123,454 50.00% 2002 Ca ital A recut' n Debt Certificates 51-510-85-00-8000 PRINCIPLE PAYMENT 365,000 - - 365,000 365,000 100.00% 2003 Debt Certificate 51-510-86-00-8050 1 INTEREST PAYMENT - 16,575 16,575 33,150 50.00% 2006A Refunding Debt Certificates 51-510-87-00-8000 PRINCIPLE PAYMENT - - 355,000 0.00% 51-510-87-00-8050 INTEREST PAYMENT 109,903 109,903 219,806 50.00% 2005C Bond 51-510-88-00-8000 PRINCIPLE PAYMENT - - 90,000 0.00% 51-510-88-00-8050 1 INTEREST PAYMENT 37,288 - 37,288 74,575 50.00% IEPA Loan L17-156300 51-510-89-00-8000 1 PRINCIPLE PAYMENT - 43,604 43,604 87,754 49.69% 51-510-89-00-8050 INTEREST PAYMENT - 18,911 18,911 37,277 50.73% TOTAL FUND REVENUES 50,693 524,174 34,717 604,851 1,214,435 2,801,379 43.35% TOTAL FUND EXPENSES 444,202 355,859 105,317 234,649 1,140,027 3,085,983 36.94% FUND SURPLUS(DEFICIT) (393,509) 168,314 (70,600) 370,202 74,408 (284,604) SEWER FUND REVENUES Taxes 52-000-40-00-4009 PROPERTY TAXES-2004B BOND 37,543 93,624 3,516 16,096 150,778 263,850 57.15°% Licenses&Permits 52-000-42-00-4216 BUILD PROGRAM PERMIT - 4,000 - - 4,000 - 0.00°% Fines&Forfeits 52-000-43-00-4350 LATE PMT PENALTIES-SEWER 4 2,342 13 2,296 4,655 - 0.00°% Char es or Service 52-000-44-00-4435 SEWER MAINTENANCE FEES 269 122,958 329 123,066 246,622 728,280 33.86°% 52-000-44-00-4455 SW CONNECTION FEES-OPS 200 - - - 200 5,100 3.92% 52-000-44-00-4456 SW CONNECTION FEES-CAPITAL 1,800 1,800 35,000 5.14°% 52-000-44-00-4457 SW CONNECTION FEES-ROB ROY 288,000 - 288,000 600,000 48.00% 52-000-44-00-4565 RIVER CROSSING FEES - 257 - 257 - 0.00% Investment Earnings 52-000-45-00-4500 INVESTMENT EARNINGS 30 58 64 688 840 3,000 1 28.00°% Miscellaneous 52-000-46-00-4670 REIMB-EMP INS CONTRIBUTIONS 386 386 386 386 1,546 4,587 33.70°% 52-000-46-00-4690 REIMB-MISCELLANEOUS 1,679 2,176 249 - 4,103 - 0.00% TOTAL REVENUES:SEWER FUND 329,911 1 225,801 1 4,557 142,532 702,801 1,639,817 42.86°% SEWER OPERATIONS EXPENSES Salaries&Wages 52-520-50-00-5010 SALARIES&WAGES 14,411 15,287 14,496 13,077 65,950 210,000 31.40°% 52-520-50-00-5020 OVERTIME - - - - 2,000 0.00% Benefits ■ 52-520-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,389 1,474 1,397 6,358 21,290 29.86°% 52-520-52-00-5214 FICA CONTRIBUTION 1,073 1,140 1,079 4,927 18,000 27.37% 52-520-52-00-5216 GROUP HEALTH INSURANCE 3,686 3,938 3,708 15,111 63,595 23.76% 52-520-52-00-5222 GROUP LIFE INSURANCE 25 44 35 139 537 25.86°%52-520-52-00-5223 DENTAL INSURANCE 318 354 336 1,344 4,687 28.67°%52-520-52-00-5224 VISION INSURANCE 36 36 36 144 532 27.05% 52-520-52-00-5230 UNEMPLOYMENT INSURANCE 725 - 245 969 2,571 37.70% 52-520-52-00-5231 LIABILITY INSURANCE 4,501 1,032 1,032 7,597 21,590 35.19% 12 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING AUGUST 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8.33% 16.67% 25% 33% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 Totals BUDGET %of Budget Contractual Services 52-520-54-00-5405 BUILD PROGRAM 4,000 4,000 - 0.00% 52-520-54-00-5412 TRAINING&CONFERENCES - - 500 0.00% 52-520-54-00-5415 TRAVEL&LODGING 43 43 500 8.56% 52-520-54-00-5430 PRINTING&DUPLICATING - - - - 100 0.00% 52-520-54-00-5440 TELECOMMUNICATIONS 131 135 132 398 1,800 22.09% 52-520-54-00-5444 LIFT STATION SERVICES - - - - 15,000 0.00% 52-520-54-00-5462 PROFESSIONAL SERVICES 160 142 69 371 5,000 7.43% 52-520-54-00-5480 UTILITIES 2,825 8,025 2,321 13,171 42,000 31.36% 52-520-54-00-5485 RENTAL&LEASE PURCHASE 33 33 33 33 132 1,500 8.80% 52-520-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 26 187 300 934 1,447 4,000 36.18% 52-520-54-00-5498 PAYING AGENT FEES - - - - 3,000 0.00% Supplies 52-520-56-00-5600 WEARING APPAREL 39 88 66 166 360 2,500 1 14.41% 52-520-56-00-5610 OFFICE SUPPLIES 8 - - 8 2,000 0.40% 52-520-56-00-5613 LIFT STATION MAINTENANCE - 534 464 12 1,010 10,000 10.10% 52-520-56-00-5620 OPERATING SUPPLIES 145 204 278 427 1,054 4,500 23.43% 52-520-56-00-5630 SMALL TOOLS&EQUIPMENT - - 599 220 819 4,500 18.20% 52-520-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - - - 3,000 0.00% 52-520-56-00-5640 REPAIR&MAINTENANCE - 220 - 220 10,000 2.20% 52-520-56-00-5695 GASOLINE 1,891 11843 2,006 5,740 29,211 19.65% Capital Outlay 52-520-60-00-6079 ROUTE 47 EXPANSION 60,000 0.00% Developer Commitments 52-520-75-00-7500 LENNAR-RAINTREESWR RECAP 30,996 30,996 30,996 1 100.00% 52-520-75-00-7501 WINDETTE RIDGE-SEWER RECAPTURE - - 150,000 0.00% 2004B Bond 52-520-84-00-8000 PRINCIPLE PAYMENT - - 170,000 0.00% 52-520-84-00-8050 INTEREST PAYMENT 46,925 46,925 93,850 50.00% 2003IRBB Debt Certificates 52-520-90-00-8000 PRINCIPLE PAYMENT - - 100,000 0.00% 52-520-90-00-8050 INTEREST PAYMENT 33,124 33,124 66,248 50.00% 2004A Bond 52-520-91-00-8000 PRINCIPLE PAYMENT 175,000 0.00% 52-520-91-00-8050 INTEREST PAYMENT 9,369 9,369 18,738 50.00% 2011 Refunding Bond 52-520-92-00-8050 1 INTEREST PAYMENT 79,537 79,537 318,147 25.00% IEPA Loan L17-013000 52-520-95-00-8000 PRINCIPLE PAYMENT - 18,811 18,811 37,958 49.56% 52-520-95-00-8050 1 INTEREST PAYMENT 679 - 679 1,022 66.48% IEPA Loan L77-115300 52-520-96-00-8000 PRINCIPLE PAYMENT - 44,016 44,016 88,610 49.67% 52-520-96-00-8050 INTEREST PAYMENT - - - 9,509 9,509 18,440 51.57% Other Financing Uses 52-520-99-00-9952 TRANSFER TO WATER 6,857 6,857 6,857 6,857 27,429 82,288 33.33% TOTAL FUND REVENUES 329,911 225,801 4,557 142,532 702,801 1,639,817 42.86% TOTAL FUND EXPENSES 33,308 207,050 93,941 97,407 431,706 1,8959210 22.78% FUND SURPLUS(DEFICIT) 296,603 18,752 (89,384) 45,125 271,095 (255,393) LAND CASH REVENUES 72-000-41-00-4173 OSLAD GRANT-RAINTREE 400,000 13 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING AUGUST 31,2012 ACTUALS BY MONTH(Cash Basis) %ojFiscalYear 8.33% 16.67% 25% 33% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 duly-12 August-12 Totals BUDGET %of Budget 72-000-47-00-4703 AUTUMN CREEK 7,179 4,102 6,153 3,077 20,511 20,000 102.56% 72-000-47-00-4704 BLACKBERRY WOODS - - - - - 500 0.00% 72-000-47-00-4708 COUNTRY HILLS - 769 - - 769 - 0.00% TOTAL REVENUES:LAND CASH 7,179 4,871 69153 3,077 21,280 420,500 5.06% LAND CASH EXPENDITURES 72-720-60-00-6032 MOSIER HOLDING COSTS - - 12,000 - 12,000 12,000 100.00% 72-720-60-00-6036 RAINTREE VILLAGE 450 15,768 5,626 547 22,390 191,825 11.67% 72-720-60-00-6044 HOPKINS PARK - - - - - 120,000 0.00% TOTAL FUND REVENUES 7,179 4,871 6,153 3,077 21,280 420,500 5.06% TOTAL FUND EXPENDITURES 450 15,768 17,626 547 34,390 323,825 10.62% FUND SURPLUS(DEFICIT) 6,729 (10,896) (11,472) 2,530 (13,110) 96,675 PARK&RECREATION REVENUES Char es or Service 79-000-44-00-4402 SPECIAL EVENTS 2,310 3,075 10,553 660 16,598 18,095 91.73% 79-000-44-00-4403 CHILD DEVELOPMENT 5,156 4,874 1,270 2,400 13,700 58,810 23.30% 79-000-44-00-4404 ATHLETICS AND FITNESS 36,929 18,225 19,734 4,461 79,349 113,095 70.16% 79-000-44-00-4441 CONCESSION REVENUE 13,379 11,464 6,995 355 32,192 30,000 107.31% 79-000-44-00-4443 HOMETOWN DAYS 1,325 600 11,020 14,460 27,405 175,000 15.66% Investment Earnings 79-000-45-00-4500 INVESTMENT EARNINGS 21 20 22 22 85 200 42.72% Reimbursements 79-000-46-00-4670 REIMB-EMP INS CONTRIBUTIONS 1,132 1,132 1,132 11132 4,528 11,661 38.83% Miscellaneous ML 79-000-48-00-4820 RENTAL INCOME 33,340 3,195 8,018 495 45,048 48,000 93.85% 79-000-48-00-4825 PARK RENTALS 6,017 3,074 245 1,307 10,643 25,000 42.57% 79-000-48-00-4846 SPONSORSHIPS/DONATIONS 2,429 130 210 1,212 3,981 14,700 27.08% 79-000-48-00-4850 MISCELLANEOUS INCOME 790 792 576 344 2,502 1,000 250.20% Other Financing Sources 79-000-49-00-4901 TRANSFER FROM GENERAL 79,657 79,657 79,657 79,657 318,629 955,886 %TOTA L REVENUES:PARK&RECREATION 182,484 126,238 139,433 106,505 554,660 1,451,447 % PARKS DEPARTMENT EXPENDITURES Salaries&Wages 79-790-50-00-5010 SALARIES&WAGES 32,996 32,031 30,483 46,231 141,741 410,000 34.57% 79-790-50-00-5015 PART-TIME SALARIES 652 4,468 4,965 5,612 15,697 17,000 92.33% 79-790-50-00-5020 OVERTIME 443 214 344 - 1,002 3,000 33.39% Benefits 79-790-52-00-5212 RETIREMENT PLAN CONTRIBUTION 3,245 3,172 2,996 4,530 13,943 43,693 31.91% 79-790-52-00-5214 FICA CONTRIBUTION 2,514 2,714 2,644 3,851 11,723 34,000 34.48% 79-790-52-00-5216 GROUP HEALTH INSURANCE 9,090 10,824 8,596 9,017 37,527 126,842 29.59% 79-790-52-00-5222 GROUP LIFE INSURANCE 58 102 82 82 323 1,208 26.74% 79-790-52-00-5223 DENTALINSURANCE 635 836 736 736 2,942 9,179 32.06% 79-790-52-00-5224 VISION INSURANCE 84 84 84 84 335 1,104 30.31% Contractual Services 79-790-54-00-5412 TRAINING&CONFERENCES 2,600 0.00% 79-790-54-00-5415 TRAVEL&LODGING 750 0.00% 79-790-54-00-5440 TELECOMMUNICATIONS 335 339 377 1,051 3,780 27.80% 79-790-54-00-5462 PROFESSIONAL SERVICES - 861 861 4,500 19.14% 14 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING AUGUST 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8.33% 16.67% 25% 33% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 duly-12 August-12 Totals BUDGET %of Budget 79-790-54-00-5466 LEGAL SERVICES 1,710 855 2,565 4,000 64.13% 79-790-54-00-5485 RENTAL&LEASE PURCHASE - 73 73 2,500 2.91% 79-790-54-00-5495 OUTSIDE REPAIR AND MAINTENANCE - - - - - 17,500 0.00% Supplies 79-790-56-00-5600 WEARING APPAREL 235 99 377 711 4,100 17.34% 79-790-56-00-5610 OFFICE SUPPLIES - 53 99 151 300 50.43% 79-790-56-00-5620 OPERATING SUPPLIES 59 256 646 960 22,500 4.27% 79-790-56-00-5630 SMALL TOOLS&EQUIPMENT 7 107 8 122 2,250 5.42% 79-790-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - - - 500 0.00% 79-790-56-00-5640 REPAIR&MAINTENANCE 820 2,056 5,087 7,963 50,500 15.77% 79-790-56-00-5695 GASOLINE - 2,679 3,198 2,060 7,937 20,000 39.68% TOTAL EXPENDITURES:PARKS DEPT 49,717 58,579 59,607 79,724 247,626 781,806 31.67% RECREATION DEPARTMENT EXPENDITURES Salaries&Wages 79-795-50-00-5010 SALARIES&WAGES 13,453 15,885 15,226 22,936 67,500 185,000 36.49% 79-795-50-00-5015 PART-TIME SALARIES 1,233 770 443 835 3,280 25,000 13.12% 79-795-50-00-5020 OVERTIME - - - - - 300 0.00% 79-795-50-00-5045 CONCESSION WAGES 2,879 2,869 2,496 262 8,507 12,500 68.05% 79-795-50-00-5046 PRE-SCHOOL WAGES 2,110 - - - 2,110 25,000 8.44% 79-795-50-00-5052 INSTRUCTORS WAGES 1,181 1,264 713 1,008 4,166 25,000 16.66% Benefits 79-795-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,711 1,730 1,602 2,362 7,405 19,884 37.24% 79-795-52-00-5214 FICA CONTRIBUTION 1,543 1,537 1,391 1,855 6,327 16,000 39.54% 79-795-52-00-5216 GROUP HEALTH INSURANCE 3,334 2,206 3,043 6,378 14,960 41,094 36.40% 79-795-52-00-5222 GROUP LIFE INSURANCE 29 33 29 37 128 473 27.15% 79-795-52-00-5223 DENTAL INSURANCE 263 165 214 214 855 2,675 31.97% 79-795-52-00-5224 VISION INSURANCE 25 25 25 25 99 325 30.34% Contractual Services 79-795-54-00-5412 TRAINING&CONFERENCES - - - 2,000 0.00% 79-795-54-00-5415 TRAVEL&LODGING - - 1,000 0.00% 79-795-54-00-5426 PUBLISHING&ADVERTISING - - 7,690 7,690 27,000 28.48% 79-795-54-00-5440 TELECOMMUNICATIONS 226 230 294 751 4,300 17.46% 79-795-54-00-5447 SCHOLARSHIPS 300 - - 300 2,500 12.00% 79-795-54-00-5452 POSTAGE&SHIPPING - 147 147 8,000 1.84% 79-795-54-00-5460 DUES&SUBSCRIPTIONS - - - - - 1,500 0.00% 79-795-54-00-5462 PROFESSIONAL SERVICES 805 6,737 14,324 5,331 27,197 60,000 45.33% 79-795-54-00-5480 UTILITIES - 1,413 1,019 1,013 3,445 23,100 14.91% 79-795-54-00-5485 RENTAL&LEASE PURCHASE 178 178 186 28 569 4,500 12.65% 79-795-54-00-5495 OUTSIDE REPAIR&MAINTENANCE - - - - - 1,000 0.00% 79-795-54-00-5496 PROGRAM REFUNDS 6 1,101 1,477 1,603 4,187 7,000 59.81% Supplies 79-795-56-00-5602 HOMETOWN DAYS SUPPLIES 4,151 - 322 54,762 59,235 140,000 42.31% 79-795-56-00-5606 PROGRAM SUPPLIES 2,482 8,422 1,288 5,960 18,151 55,000 33.00% 79-795-56-00-5607 CONCESSION SUPPLIES 894 6,348 3,538 110 10,890 18,000 60.50% 79-795-56-00-5610 OFFICE SUPPLIES 273 19 53 212 557 3,000 18.55% 79-795-56-00-5620 OPERATING SUPPLIES 1,116 1,103 109 1,244 3,572 5,500 64.94% 79-795-56-00-5630 SMALL TOOLS&EQUIPMENT - - - - - 2,000 0.00% 79-795-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - - - 500 0.00% 79-795-56-00-5640 REPAIR&MAINTENANCE 39 39 2,000 1.93% 15 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING AUGUST 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8.33% 16.67% 25% 33% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 duly-12 August-12 Totals BUDGET %of Budget 79-795-56-00-5645 BOOKS&PUBLICATIONS 100 0.00% 79-795-56-00-5690 SUPPLIES-GRANT REIMBURSABLE - - - - 500 0.00% 79-795-56-00-5695 GASOLINE - 121 213 125 459 3,210 14.30% TOTAL EXPENDITURES:RECREATION DEPT 37,664 52,490 48,086 114,282 252,523 724,961 34.83% TOTAL FUND REVENUES 182,484 126,238 139,433 106,505 554,660 1,451,447 38.21% ir TOTAL FUND EXPENDITURES 87,381 111,069 107,693 194,006 500,149 1,506,767 33.19% FUND SURPLUS(DEFICIT) 95,103 15,169 31,740 (87,501) 54,511 (55,320) RECREATION CENTER REVENUES Charges for Service 80-000-44-00-4440 PROGRAM FEES 6,987 3,834 2,317 12,329 25,467 100,000 25.47% 80-000-44-00-4441 CONCESSION REVENUE 890 719 717 738 3,063 12,500 24.51% 80-000-44-00-4444 MEMBERSHIP FEES 37,888 33,725 35,129 30,793 137,535 450,000 30.56% 80-000-44-00-4445 GUEST FEES 633 797 814 762 3,006 7,000 42.94% 80-000-44-00-4446 SWIM CLASS FEES 2,825 5,039 3,557 1,974 13,395 25,000 53.58% 80-000-44-00-4447 PERSONAL TRAINING FEES 1,215 257 108 730 2,310 10,000 23.10% 80-000-44-00-4448 TANNING SESSION FEES 222 30 92 82 426 2,500 17.04% Miscellaneous 80-000-48-00-4820 RENTAL INCOME 1,296 779 761 1,006 3,842 13,000 29.55% 80-000-48-00-4846 SCHOLARSHIPS/DONANTIONS 1,283 (123) - 250 1,410 2,000 70.50% 80-000-48-00-4850 MISCELLANEOUS INCOME 21 20 4 1 45 500 8.95% TOTAL REVENUES:RECREATION CTR REVENUES 53,259 45,076 43,499 48,664 190,498 6229500 30.60% RECREATION CENTER EXPENSES Salaries&Wages 80-800-50-00-5010 SALARIES&WAGES 2,028 2,040 2,040 3,060 9,168 28,000 32.74% 80-800-50-00-5015 PART-TIME SALARIES 6,409 5,796 6,081 8,850 27,135 100,000 27.13% 80-800-50-00-5046 PRE-SCHOOL WAGES 614 400 - 1,790 2,804 35,000 8.01% 80-800-50-00-5052 INSTRUCTORS WAGES 3,616 5,172 5,586 61435 20,808 60,000 34.68% Benefits 80-800-52-00-5212 RETIREMENT PLAN CONTRIBUTION 685 595 550 960 2,791 10,181 27.41% 80-800-52-00-5214 FICA CONTRIBUTION 977 1,034 1,056 1,548 4,615 17,708 26.06% 80-800-52-00-5216 GROUP HEALTH INSURANCE 100 100 100 100 400 1,200 33.33% 80-800-52-00-5222 GROUP LIFE INSURANCE 7 7 7 7 29 123 23.37% Contractual Services 80-800-54-00-5415 TRAVEL&LODGING - - - - 200 0.00% 80-800-54-00-5426 PUBLISHING&ADVERTISING - - - - 1,500 0.00% 80-800-54-00-5440 TELECOMMUNICATIONS 278 281 552 1,111 3,600 30.86% 80-800-54-00-5452 POSTAGE&SHIPPING - - - - 600 0.00% 80-800-54-00-5460 DUES&SUBSCRIPTIONS - - - - 200 0.00% 80-800-54-00-5462 PROFESSIONAL SERVICES 43 2,909 1,574 829 5,355 20,000 26.77% 80-800-54-00-5480 UTILITIES - 3,039 2,889 4,312 10,240 55,650 18.40% 80-800-54-00-5485 RENTAL&LEASE PURCHASE 37,198 19,198 19,242 19,092 94,731 236,000 40.14% 80-800-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 115 750 - 361 1,226 15,000 8.17% 80-800-54-00-5496 PROGRAM REFUNDS 174 601 292 740 1,807 5,500 32.85% 80-800-54-00-5497 PROPERTY TAX PAYMENT 29,400 - - 29,400 58,800 70,000 84.00% Supplies 80-800-56-00-5606 PROGRAM SUPPLIES 988 514 366 1,868 1 15,000 1 12.45% 80-800-56-00-5607 CONCESSION SUPPLIES 694 1 73 860 1 798 2,426 1 7,000 1 34.65% 16 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING AUGUST 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8.33% 16.67% 25% 33% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION lu May-12 June-12 duly-12 August-12 Totals BUDGET %of Budget 80-800-56-00-5610 OFFICE SUPPLIES - - - 2,600 0.00% 80-800-56-00-5620 OPERATING SUPPLIES 177 502 72 751 6,200 12.11% 80-800-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - 1,000 0.00% 80-800-56-00-5640 REPAIR&MAINTENANCE 267 1,725 948 1,673 4,613 11,000 41.94% 80-800-56-00-5645 BOOKS&PUBLICATIONS - 114 114 50 228.80% 80-800-56-00-5695 GASOLINE 321 0.00% TOTAL FUND REVENUES 53,259 45,076 43,499 48,664 190,498 622,500 30.60% F-,=7 TOTAL FUND EXPENSES 82,327 44,881 42,523 81,060 250,791 703,633 35.64% FUND SURPLUS(DEFICIT) (29,068) 195 976 (32,396) (60,293) (81,133) LIBRARY OPERATIONS REVENUES 82-000-40-00-4005 PROPERTY TAXES-LIBRARY 98,981 246,721 9,268 42,415 397,385 700,000 56.77% 82-000-40-00-4012 PROPERTY TAXES-FOX IND TIF - - - - 7,500 0.00% Intergovernmental 82-000-41-00-4120 PERSONAL PROPERTY TAX 739 955 115 1,809 5,000 36.18% 82-000-41-00-4170 STATE GRANTS - - - 1,500 1,500 17,200 8.72% Fines&Forfeits 82-000-43-00-4330 LIBRARY FINES 994 888 765 572 3,218 13,000 24.75% Charges for Service 82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 1,367 1,603 608 650 4,228 12,000 35.23% 82-000-44-00-4422 COPY FEES 204 153 175 216 748 3,000 24.92% 82-000-44-00-4440 PROGRAM FEES 93 44 54 74 265 2,000 13.23% Investment Earnings 82-000-45-00-4500 INVESTMENT EARNINGS 82 83 108 116 389 150 259.46% Reimbursements 82-000-46-00-4670 REIMB-EMP INS CONTRIBUTIONS 724 724 724 724 2,895 6,670 43.40% 82-000-46-00-467F REIMB-LIFE INSURANCE 59 59 59 59 237 636 37.28% Miscellaneous 82-000-48-00-4820 RENTAL INCOME 131 150 100 100 481 2,000 24.05% 82-000-48-00-4824 DVD RENTAL INCOME 349 457 537 507 1,850 4,500 41.11% 82-000-48-00-4832 MEMORIALS 142 200 - 40 382 2,000 19.10% 82-000-48-00-4850 MISCELLANEOUS INCOME 33 13 87 26 159 - 0.00% Other Financing Sources 82-000-49-00-4901 TRANSFER FROM GENERAL 9,733 1 1,801 1,801 2,151 15,486 41,978 36.89% TOTAL REVENUES:LIBRARY 113,630 252,895 15,241 49,265 431,030 817,634 52.72% LIBRARY OPERATIONS EXPENDITURES Salaries&Wages 82-820-50-00-5010 SALARIES&WAGES 18,707 19,431 18,707 28,060 84,905 245,000 34.65% 82-820-50-00-5015 PART-TIME SALARIES 14,207 14,193 14,085 20,716 63,202 195,000 32.41% Benefits 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,803 1,873 1,803 2,705 8,185 26,692 30.66% 82-820-52-00-5214 FICA CONTRIBUTION 2,463 2,517 2,453 3,676 11,109 38,000 29.23% 82-820-52-00-5216 GROUP HEALTH INSURANCE 8,308 8,047 5,553 10,578 32,487 102,877 31.58% 82-820-52-00-5222 GROUP LIFE INSURANCE 36 135 86 86 342 1,410 24.28% 82-820-52-00-5223 DENTAL INSURANCE 469 523 496 496 1,983 6,826 29.06% 82-820-52-00-5224 VISION INSURANCE 54 54 54 54 214 770 27.84% 82-820-52-00-5230 UNEMPLOYMENT INSURANCE 1,035 - 350 350 1,734 4,286 40.47% 82-820-52-00-5231 LIABILITY INSURANCE 8,698 1,801 1,801 1,801 14,101 37,692 37.41% Contractual Services 17 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING AUGUST 31,2012 ACTUALS BY MONTH(Cash Basis) %ojFiscalYear 8.33% 16.67% 25% 33% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 duly-12 August-12 Totals BUDGET %of Budget 82-820-54-00-5415 TRAVEL&LODGING 200 305 135 640 500 128.09% 82-820-54-00-5426 PUBLISHING&ADVERTISING - - - - 100 0.00% 82-820-54-00-5440 TELECOMMUNICATIONS 751 785 1,321 2,857 8,500 33.61% 82-820-54-00-5452 POSTAGE&SHIPPING - - - 6 6 1,000 0.59% 82-820-54-00-5460 DUES&SUBSCRIPTIONS 78 - - - 78 14,000 0.56% 82-820-54-00-5462 PROFESSIONAL SERVICES 963 3,943 2,387 1,837 9,130 29,000 31.48% 82-820-54-00-5466 LEGAL SERVICES - - - 360 360 2,000 18.00% 82-820-54-00-5468 AUTOMATION 3,385 7 - 869 4,262 35,000 12.18% 82-820-54-00-5480 UTILITIES - - 300 204 503 15,750 3.20% 82-820-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 276 91 536 903 5,000 18.05% 82-820-54-00-5498 PAYING AGENT FEES - 375 375 749 749 100.00% Supplies 82-820-56-00-5610 OFFICE SUPPLIES 793 295 187 1,275 8,000 15.93% 82-820-56-00-5620 OPERATING SUPPLIES 228 912 1,199 2,339 7,500 31.18% 82-820-56-00-5671 LIBRARY PROGRAMMING - - 44 44 2,000 2.18% 82-820-56-00-5685 DVD'S 280 204 135 619 2,000 30.94% 82-820-56-00-5698 MEMORIALS&GIFTS 2,000 0.00% 82-820-56-00-5699 MISCELLANEOUS 250 0.00% Contingencies 82-820-70-00-7799 CONTINGENCIES 1,000 0.00% Other Financing Uses 82-820-99-00-9983 TRANSFER TO LIBRARY DEBT SERVICE 1,822 1,822 1,511 120.58% TOTAL FUND REVENUES 113,630 252,895 15,241 49,265 431,030 817,634 52.72% El TOTAL FUND EXPENDITURES 62,028 55,051 51,041 75,727 243,848 794,413 30.70% FUND SURPLUS(DEFICIT) 51,602 1 197,843 1 (35,800) (26,462) 187,183 1 23,221 LIBRARY DEBT SERVICE REVENUES 83-000-40-00-4015 PROPERTY TAXES-DEBT SERVICE 113,248 282,285 10,604 48,529 454,667 795,488 57.16% 83-000-45-00-4500 INVESTMENT EARNINGS - 6 - - 6 300 2.05% 83-000-49-00-4982 TRANSFER FROM LIBRARY OPS 1,822 - - - 1,822 1,511 120.58% TOTAL REVENUES:LIBRARY DEBT SERVICE 115,070 282,291 10,604 48,529 456,495 797,299 57.26% LIBRARY DEBT SERVICE EXPENDITURES 2005B Bond 83-830-83-00-8000 PRINCIPLE PAYMENT - - - - 290,000 0.00% 83-830-83-00-8050 INTEREST PAYMENT 154,563 154,563 309,125 50.00% 2006 Bond 83-830-84-00-8000 PRINCIPLE PAYMENT - 150,000 0.00% 83-830-84-00-8050 INTEREST PAYMENT 23,181 23,181 46,363 50.00% TOTAL FUND REVENUES 115,070 282,291 10,604 48,529 456,495 797,299 57.26% TOTAL FUND EXPENDITURES - 177,744 - - 177,744 795,488 22.34% FUND SURPLUS(DEFICIT) 115,070 104,547 10,604 48,529 278,751 1,811 18 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING AUGUST 31,2012 ACTUALS BY MONTH(Cash Basis) %ojFiscal Year 8.33% 16.67% 25% 33% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 duly-12 August-12 Totals BUDGET %of Budget LIBRARY CAPITAL REVENUES 84-00042-00-4214 DEVELOPMENT FEES 2,500 10,800 13,300 16,250 81.85% 84-000-45-00-4500 1 INVESTMENT EARNINGS 0 0 0 0 1 100 1.16% TOTAL REVENUES:LIBRARY CAPITAL 2,500 0 0 10,800 13,301 16,350 81.35% LIBRARY CAPITAL EXPENDITURES 84-840-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - - 0.00% 84-840-56-00-5683 AUDIO BOOKS 0.00% 84-840-56-00-5684 COMPACT DISCS&OTHER MUSIC 0.00% 84-840-56-00-5685 DVD'S - - - - - 0.00% 84-840-56-00-5686 BOOKS 423 208 6 637 13,474 4.73% TOTAL FUND REVENUES 2,500 0 0 10,800 13,301 16,350 81.35% j I ITOTAL FUND EXPENDITURES 423 208 6 637 13,474 4.73% FUND SURPLUS(DEFICIT) 2,500 (422) (208) 10,794 12,664 2,876 COUNTRYSIDE TIE REVENUES 87-000-40-00-4087 PROPERTY TAXES-CNTRYSDE - - - - - 4,500 0.00% 87-000-45-00-4500 INVESTMENT EARNINGS 234 223 228 240 925 2,000 46.26% TOTAL REVENUES:COUNTRYSIDE TIE 234 223 228 240 925 6,500 14.24% COUNTRYSIDE TIF EXPENDITURES Contractual Services AL 87-870-54-00-5420 ADMINISTRATIVE FEES - 95 - r95 1,000 9.50% 87-870-54-00-5498 PAYING AGENT FEES 375 0.00% 2005 Bond 87-870-80-00-8000 PRINCIPLE PAYMENT 180,000 0.00% 87-870-80-00-8050 INTEREST PAYMENT 62,334 62,334 1 124,668 50.00% TOTAL FUND REVENUES 234 223 228 240 925 6,500 14.24% TOTAL FUND EXPENDITURES 62,334 95 - 62,429 306,043 20.40 or FUND SURPLUS(DEFICIT) (62,099) 128 1 228 240 j (61,503) (299,543) DOWNTOWN TIF REVENUES 88-000-40-00-4088 PROPERTY TAXES-DOWNTOWN TIF 3,159 19,243 1,504 1,202 25,109 70,000 35.87% 88-000-45-00-4500 1 INVESTMENT EARNINGS 3 5 6 11 25 150 16.39% TOTAL REVENUES:DOWNTOWN TIE 3,162 19,248 1,510 1,213 25,133 70,150 35.83% DOWNTOWN TIF EXPENDITURES 88-880-54-00-5420 ADMINISTRATIVE FEES - - - - - 1,500 0.00% 88-880-54-00-5466 LEGAL SERVICES 2,869 447 2,185 5,501 10,000 55.01% 88-880-60-00-6000 PROJECT COSTS - - 1,038 1,038 10,000 10.38% 88-880-60-00-6079 ROUTE 47 EXPANSION - - - - - 20,000 0.00% TOTAL FUND REVENUES 3,162 19,248 1,510 1,213 25,133 70,150 35.83% TOTAL FUND EXPENDITURES - 2,869 447 3,223 69539 41,500 15.76% FUND SURPLUS(DEFICIT) 3,162 16,379 1,063 (2,010) 18,594 28,650 19 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Period Ending August 31, 2012 * % of August YTD YTD to FY 2013 Actual Actual Budget Budget GENERAL FUND (01) Revenues Local Taxes Property Taxes 166,479 1,559,519 57.3% 2,721,487 Municipal Sales Tax 217,858 801,161 34.5% 2,325,000 Non-Home Rule Sales Tax 170,425 613,525 0.0% 1,500,000 Electric Utility Tax - 147,598 24.5% 603,432 Natural Gas Tax - 65,896 22.2% 296,514 Telecommunications Tax 40,944 169,590 34.6% 490,000 Telephone Utility Tax 1,345 5,527 23.5% 23,500 Cable Franchise Fees 53,038 104,575 45.5% 230,000 Hotel Tax 6,559 21,159 42.3% 50,000 Amusement Tax 929 11,033 8.2% 134,000 Admissions Tax - - 0.0% 104,500 Business District Tax 24,613 96,382 32.1% 300,000 Auto Rental Tax 688 3,048 30.5% 10,000 Para-Mutuel Tax 314 314 0.0% - Total Taxes 683,192 3,599,327 41.0% 8,788,433 Intergovernmental State Income Tax 212,616 717,327 54.3% 1,320,000 Local Use Tax 21,234 81,371 33.6% 242,400 Road&Bridge Tax 11,285 99,045 58.3% 170,000 Personal Property Replacement Tax 348 5,459 34.1% 16,000 Other Intergovernmental 7,941 9,048 80.8% 11,200 Total Intergovernmental 253,424 912,250 51.8% 1,759,600 Licenses and Permits Liquor Licenses 625 2,398 6.0% 40,000 Building Permits 12,572 55,069 43.5% 126,600 Other Licenses &Permits - 292 10.8% 2,700 Total Licenses & Permits 13,197 57,758 34.1% 169,300 Fines and Forfeits Traffic Fines 5,687 20,251 21.3% 95,000 Administrative Adjudication 2,157 8,777 33.8% 26,000 Police Tows 7,375 23,375 29.2% 80,000 Late PMT Penalties - Garbage 3,937 7,993 - Total Fines and Forfeits 19,156 60,396 30.0% 201,000 20 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Period Ending August 31, 2012 * % of August YTD YTD to FY 2013 Actual Actual Budget Budget Charges for Services Garbage Surcharge 180,008 381,437 37.3% 1,021,784 Collection Fee -YBSD - - 0.0% 151,500 Other Services 25 90 1.6% 5,500 Total Charges for Services 180,033 381,527 32.4% 1,178,784 Investment Earnings 322 2,309 74.5% 3,100 Reimb/Miscellaneous/Other Financing Sources Reimb - Legal Expenses 934 3,130 0.0% - Reimb - Engineering Expenses (31,617) 15,755 0.0% - Reimb - Traffic Signal 20,018.89 20,019 133.5% 15,000 Reimb - Health Ins Contributions 12,100 43,751 32.2% 135,892 Other Reimbursements 3,685 57,315 117.0% 49,000 Rental Income 560 2,705 33.8% 8,000 Miscellaneous Income 2 2 0.1% 3,000 Total Miscellaneous 5,683 142,677 67.7% 210,892 Total Revenues and Transfers 1,155,008 5,156,244 41.9% 12,311,109 Expenditures Administration 67,639 229,631 29.4% 782,327 Salaries 36,621 111,664 33.5% 333,395 Benefits 21,438 87,663 31.8% 275,732 Contractual Services 9,320 28,011 17.5% 160,250 Supplies 261 2,292 17.7% 12,950 Finance 27,946 87,789 25.8% 340,535 Salaries 20,089 60,526 32.7% 185,000 Benefits 6,663 21,143 34.0% 62,135 Contractual Services 712 5,326 6.0% 88,150 Supplies 482 794 15.1% 5,250 Police 350,570 1,247,790 32.5% 3,840,577 Salaries 231,368 678,468 30.6% 2,215,500 Overtime 7,751 34,808 38.7% 90,000 Benefits 79,449 448,506 38.4% 1,169,457 Contractual Services 21,478 52,000 24.3% 213,850 Supplies 10,525 34,008 22.4% 151,770 21 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Period Ending August 31, 2012 * % of August YTD YTD to FY 2013 Actual Actual Budget Budget Community Development 32,627 107,477 23.3% 461,426 Salaries 23,318 67,361 27.2% 248,000 Benefits 6,936 26,429 24.1% 109,797 Contractual Services 1,864 10,196 11.0% 92,350 Supplies 509 3,491 31.0% 11,279 PW- Street Ops & Sanitation 257,382 484,249 25.2% 1,920,452 Salaries 30,914 91,255 32.6% 280,000 Overtime 12 938 6.3% 15,000 Benefits 12,640 50,916 34.5% 147,530 Contractual Services 209,074 328,230 23.6% 1,390,020 Supplies 4,742 12,911 14.7% 87,902 Administrative Services 240,047 879,304 21.8% 4,034,550 Salaries - - 0.0% 5,000 Benefits 25,512 168,489 30.0% 562,389 Contractual Services 89,494 196,366 10.4% 1,895,500 Supplies - 7,403 148.1% 5,000 Contingencies - - 0.0% 50,000 Transfers Out 125,041 507,047 33.4% 1,516,661 Total Expenditures and Transfers 976,210 3,036,240 26.7% 11,379,867 Variance 178,798 2,120,003 931,242 * August represents 33%of the fiscal year 22 DATE: 09/11/2012 UNITED CITY OF YORKVILLE PAGE: 1 TIME: 19:09:35 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 04 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 01-110-54-00-5462 (E) PROFESSIONAL SERVICES O1 05/01/2012 BEGINNING BALANCE 0.00 AP-120522 05/16/2012 05 ADMIN-VIDEO SERVICES DIANE GIANNELLI OAKL 513382 155 50.00 GJ-ZAJE0IC 05/04/2012 43 AT&T MAINTENANCE BILLING 490.80 TOTAL PERIOD O1 ACTIVITY 540.80 0.00 02 AP-120626 06/19/2012 45 ADMIN-PLAN COMMISSION MEETING DEPO COURT REPORTING 513457 15441 225.00 06/19/2012 46 ADMIN-MAY 7TH MEETING MINUTES LISA R. GODWIN 513471 050712 56.00 06/19/2012 47 ADMIN-MAY 17 ADMIN MEETING LISA R. GODWIN 513471 051712 78.96 06/19/2012 48 ADMIN-AD HOC COMMITTEE MEETING LISA R. GODWIN 513471 061112 65.80 06/19/2012 49 ADMIN-MAY 15TH PW MEETING KIMBERLY A. RYAN 513536 051512 72.50 06/19/2012 50 ADMIN-ON SITE SHREDDING SHRED-IT 513541 9400307670 90.95 06/19/2012 51 ADMIN-MAY 3 PUBLIC SAFETY MARLYS J. YOUNG 513574 050312 53.75 06/19/2012 52 ADMIN-MAY 9 PLAN COMMISSION MARLYS J. YOUNG 513574 050912 35.00 AP-20626A 06/19/2012 02 ADMIN-APRIL 11 ADMIN HEARING DEPO COURT REPORTING 513407 15435 316.25 06/19/2012 03 ADMIN-SOLICITOR BACKGROUND ILLINOIS STATE POLIC 513411 051512-C 63.00 GJ-20626A 06/20/2012 03 AUDIT AJE 316.25 06/20/2012 04 AUDIT AJE 63.00 TOTAL PERIOD 02 ACTIVITY 1,057.21 379.25 03 AP-120724 07/18/2012 22 ADMIN-PLAN COMMISSION PUBLIC DEPO COURT REPORTING 513613 15491 286.50 07/18/2012 23 ADMIN-JULY 9TH AD HOC MEETING LISA R. GODWIN 513629 070912 87.64 07/18/2012 24 ADMIN LIQUOR BACKGROUND CHECKS ILLINOIS STATE POLIC 513636 062612 63.00 07/18/2012 25 ADMIN-LIQUOR BACKGROUND CHECK ILLINOIS STATE POLIO 513637 062612C 31.50 07/18/2012 26 ADMIN-JUNE 12TH COW MEETING MARLYS J. YOUNG 513715 061212 121.98 07/18/2012 27 ADMIN-JUNE 13 PLAN COMMISSION MARLYS J. YOUNG 513715 061312 43.25 GJ-120731FE 08/02/2012 17 CLERKS YEARLY SAFE DEPOSIT BOX 45.00 TOTAL PERIOD 03 ACTIVITY 678.87 0.00 04 AP-120828 08/22/2012 33 ADMIN-MAINTENANCE BILLING FOR AT&T GLOBAL SERVICES 513728 ILB00266 1,472.40 08/22/2012 34 ADMIN-SOLICITOR BACKGROUND ILLINOIS STATE POLIC 513770 080112C 31.50 08/22/2012 35 ADMIN-JULY 11 PLAN COMMISSION MARLYS J. YOUNG 513857 071112 41.25 TOTAL PERIOD 04 ACTIVITY 1,545.15 0.00 YTD BUDGET 6,666.68 TOTAL ACCOUNT ACTIVITY 3,822.03 379.25 ANNUAL REVISED BUDGET 20,000.00 ENDING BALANCE 3,442.78 01-120-54-00-5462 (E) PROFESSIONAL SERVICES 01 05/01/2012 BEGINNING BALANCE 0.00 GJ-120531FE 06/01/2012 03 APRIL CC FEES UB 395 33.41 06/01/2012 11 APRIL ANALYSIS FEES 3.91 GJ-AJE05 09/04/2012 04 AP REVERSALS FY 12 33.41 09/04/2012 05 AP REVERSALS FY 12 3.91 TOTAL PERIOD O1 ACTIVITY 37.32 37.32 02 AP-120626 06/19/2012 71 FINANCE-MUNICIPAL AGGREGATION COMMONWEALTH EDISON 513453 116132039 168.00 06/19/2012 72 FINANCE-PROGRAM FOR A RANDOM HARRIS COMPUTER SYST 513475 MN00001904 30.00 06/19/2012 73 FINANCE-PROGRAM MODIFICATIONS HARRIS COMPUTER SYST 513475 XT00003251 250.00 06/19/2012 74 FINANCE-REOCCURRING WEBSITE VISA 513559 052712-CITY 59.92 GJ-120630FE 06/20/2012 03 MAY CC FEES UB 395 64.18 TOTAL PERIOD 02 ACTIVITY 572.10 0.00 DATE: 09/11/2012 UNITED CITY OF YORKVILLE PAGE: 2 TIME: 19:09:36 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 04 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 03 AP-120724 07/18/2012 42 FINANCE-04/30/12 - 06/30/12 PITNEY BOWES 513674 1970458-JY12 700.00 07/18/2012 43 FINANCE-MAINTENANCE CONTRACT PITNEY BOWES INC 513675 352992 1,761.00 07/18/2012 44 FINANCE-REOCURRING WEBSITE VISA 513698 062612-CITY 25.94 GJ-120731FE 08/02/2012 03 JUNE CC FEES UB 395 202.88 08/02/2012 11 JUNE ACCOUNT ANALYSIS FEE 33.50 TOTAL PERIOD 03 ACTIVITY 2,723.32 0.00 04 AP-120828 08/22/2012 46 FINANCE-MUNICIPAL AGGREGATION COMMONWEALTH EDISON 513743 1161132038-0812 387.00 08/22/2012 47 FINANCE-WEBSITE UPKEEP FEE VISA 513842 072712-CITY 15.95 GJ-12083IFE 08/31/2012 03 JULY CC FEES UB 395 71.50 TOTAL PERIOD 04 ACTIVITY 474.45 0.00 YTD BUDGET 13,333.36 TOTAL ACCOUNT ACTIVITY 3,807.19 37.32 ANNUAL REVISED BUDGET 40,000.00 ENDING BALANCE 3,769.87 01-210-54-00-5462 (E) PROFESSIONAL SERVICES 01 05/01/2012 BEGINNING BALANCE 0.00 GJ-120531FE 06/01/2012 01 APRIL CC FEES PD 382 54.05 GJ-AJE05 09/04/2012 03 AP REVERSALS FY 12 54.05 GJ-ZAJE01C 05/04/2012 44 KC SHERIFF'S OFFICE RANGE FY13 333.32 TOTAL PERIOD 01 ACTIVITY 387.37 54.05 02 AP-120626 06/19/2012 105 POLICE-MAY SEARCHES LEXISNEXIS RISK DATA 513428 1249304-20120531 128.65 GJ-120630FE 06/20/2012 01 MAY CC FEES PD 382 54.90 TOTAL PERIOD 02 ACTIVITY 183.55 0.00 03 AP-120724 07/18/2012 66 POLICE-JUNE SEARCHES LEXISNEXIS RISK DATA 513588 1249304-20120630 50.00 GJ-120731FE 08/02/2012 01 JUNE CC FEES PD 382 50.17 TOTAL PERIOD 03 ACTIVITY 100.17 0.00 04 AP-120828 08/22/2012 73 POLICE-JULY SEARCHES LEXISNEXIS RISK DATA 513722 1249304-20120731 50.00 08/22/2012 74 POLICE-ANNUAL MAJOR CRIMES KENDALL COUNTY SHERI 513781 080812-MCTF 1,000.00 08/22/2012 75 MOBILE COMMAND CENTER ANNUAL KENDALL COUNTY SHERI 513781 080812-MCU 500.00 08/22/2012 76 POLICE-ANNUAL SRT INSTALLMENT KENDALL COUNTY SHERI 513781 080812-SRT 2,000.00 08/22/2012 77 POLICE-SHREDDING SERVICES SHRED-IT 513828 9400592006 90.95 GJ-120831FE 08/31/2012 01 JULY CC FEES PD 382 50.02 TOTAL PERIOD 04 ACTIVITY 3,690.97 0.00 YTD BUDGET 1,666.68 TOTAL ACCOUNT ACTIVITY 4,362.06 54.05 ANNUAL REVISED BUDGET 5,000.00 ENDING BALANCE 4,308.01 01-220-54-00-5462 (E) PROFESSIONAL SERVICES 01 05/01/2012 BEGINNING BALANCE 0.00 02 AP-120626 06/19/2012 173 COMM/DEV-APPRAISAL DAVID W. PHILLIPS AN 513455 12707-SUM 3,600.00 06/19/2012 174 COMM/DEV-52 WEEKS OF ACCESS RECORD INFORMATION S 31775 575.00 AP-120629VD 06/29/2012 01 COMM/DEV-52 WEEKS :VOID 513535 RECORD INFORMATION S 31775 575.00 TOTAL PERIOD 02 ACTIVITY 4,175.00 575.00 03 AP-120724 07/18/2012 126 COMM/DEV-ANNUAL PERMIT FEES ILLINOIS E.P.A. FISC 513634 062012 1,000.00 07/18/2012 127 COMM/DEV-BACKGROUND CHECK ILLINOIS STATE POLIC 513637 062612C 31.50 07/18/2012 128 COMM/DEV-52 WEEK ACCESS TO VISA 513698 062612-CITY 575.00 TOTAL PERIOD 03 ACTIVITY 1,606.50 0.00 YTD BUDGET 2,000.00 TOTAL ACCOUNT ACTIVITY 5,781.50 575.00 ANNUAL REVISED BUDGET 6,000.00 ENDING BALANCE 5,206.50 DATE: 09/11/2012 UNITED CITY OF YORKVILLE PAGE: 3 TIME: 19:09:37 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 04 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 01-410-54-00-5462 (E) PROFESSIONAL SERVICES 01 05/01/2012 BEGINNING BALANCE 0.00 03 AP-120724 07/18/2012 141 STREETS-6 MONTHS OF BURNING BENNETT, GARY L. 513598 070612 600.00 TOTAL PERIOD 03 ACTIVITY 600.00 0.00 04 AP-120828 08/22/2012 135 STREETS-DOT DRUG SCREEN RUSH-COPLEY HEALTHCA 513825 6151 26.00 TOTAL PERIOD 04 ACTIVITY 26.00 0.00 YTD BUDGET 333.36 TOTAL ACCOUNT ACTIVITY 626.00 0.00 ANNUAL REVISED BUDGET 1,000.00 ENDING BALANCE 626.00 01-640-54-00-5462 (E) PROFESSIONAL SERVICES 01 05/01/2012 BEGINNING BALANCE 0.00 GJ-ZAJE01C 05/04/2012 10 DAC ANNUAL FEES 450.00 TOTAL PERIOD 01 ACTIVITY 450.00 0.00 04 GJ-120831FS 09/07/2012 20 TEST FOR DAC DAILY BANK WDRAWL 1.00 TOTAL PERIOD 04 ACTIVITY 1.00 0.00 YTD BUDGET 166.68 TOTAL ACCOUNT ACTIVITY 451.00 0.00 ANNUAL REVISED BUDGET 500.00 ENDING BALANCE 451.00 15-155-54-00-5462 (E) PROFESSIONAL SERVICES 01 05/01/2012 BEGINNING BALANCE 0.00 YTD BUDGET 0.00 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 0.00 ENDING BALANCE 0.00 20-200-54-00-5462 (E) PROFESSIONAL SERVICES 01 05/01/2012 BEGINNING BALANCE 0.00 03 AP-120724 07/18/2012 226 PD CAPITAL-PORTION OF SEIZED KENDALL COUNTY SHERI 513646 12-0378 442.75 07/18/2012 227 PD CAPITAL-PORTION OF SEIZED KENDALL COUNTY STATE 513647 12-0378 3,099.25 TOTAL PERIOD 03 ACTIVITY 3,542.00 0.00 YTD BUDGET 833.36 TOTAL ACCOUNT ACTIVITY 3,542.00 0.00 ANNUAL REVISED BUDGET 2,500.00 ENDING BALANCE 3,542.00 21-211-54-00-5462 (E) PROFESSIONAL SERVICES 01 05/01/2012 BEGINNING BALANCE 0.00 YTD BUDGET 0.00 TOTAL ACCOUNT ACTIVITY 0.00 0.00 ANNUAL REVISED BUDGET 0.00 ENDING BALANCE 0.00 23-230-54-00-5462 (E) PROFESSIONAL SERVICES 01 05/01/2012 BEGINNING BALANCE 0.00 02 GJ-120529RC 07/16/2012 04 RECLASS AP120626 EEI INV 51032 488.50 GJ-120625RC 07/16/2012 04 RECLASS AP-120626 EEI INV 5103 207.42 GJ-120625XX 07/16/2012 04 REVERSE GJ-120625RC 207.42 AP-120626 06/19/2012 299 CW CAPITAL-PAVEMENT ENGINEERING ENTERPRI 513461 51032 488.50 TOTAL PERIOD 02 ACTIVITY 695.92 695.92 04 AP-120828 08/22/2012 276 ADMIN SERVICES-PAVEMENT ENGINEERING ENTERPRI 513748 51219 19,467.50 TOTAL PERIOD 04 ACTIVITY 19,467.50 0.00 YTD BUDGET 33,333.36 TOTAL ACCOUNT ACTIVITY 20,163.42 695.92 ANNUAL REVISED BUDGET 100,000.00 ENDING BALANCE 19,467.50 DATE: 09/11/2012 UNITED CITY OF YORKVILLE PAGE: 4 TIME: 19:09:37 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 04 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 51-510-54-00-5462 (E) PROFESSIONAL SERVICES 01 05/01/2012 BEGINNING BALANCE 0.00 AP-120508 05/03/2012 17 WATER OP-MAY HOSTING SERVICES ITRON 513288 239942 456.23 GJ-120531FE 06/01/2012 05 APRIL CC FEES US 395 447.74 06/01/2012 13 APRIL ANALYSIS FEES 52.37 GJ-AJE05 09/04/2012 09 AP REVERSALS FY 12 447.74 09/04/2012 10 AP REVERSALS FY 12 52.37 TOTAL PERIOD 01 ACTIVITY 956.34 500.11 02 AP-120626 06/19/2012 327 WATER OP-ANNUAL SUPPORT SENSUS METERING SYST 513538 ZA13002005 1,524.60 06/19/2012 328 WATER OP-JULY - SEPTEMBER WIRE WIZARD OF ILLIN 513565 13857 500.00 06/19/2012 329 WATER OP-WATER LIENS YORKVILLE CLERK'S AC 513569 154195 137.00 06/19/2012 330 WATER OP-RELEASE OF WATER YORKVILLE CLERK'S AC 513569 154195 441.00 GJ-120630FE 06/20/2012 05 MAY CC FEES UB 395 125.87 TOTAL PERIOD 02 ACTIVITY 2,728.47 0.00 03 AP-120724 07/18/2012 257 WATER OP-SERVICE CALL DARYL BOWLES 513612 070212 120.00 GJ-120730 08/09/2012 02 CORRECT MAY CC FEE GJ-120630FE 0.01 GJ-120731FE 08/02/2012 05 JUNE CC FEES UB 395 398.08 08/02/2012 13 JUNE ACCOUNT ANALYSIS FEE 65.70 GJ-120905RC 09/05/2012 03 RC TO PROFESSIONAL SERVICES 456.23 TOTAL PERIOD 03 ACTIVITY 1,040.01 0.01 04 AP-120828 08/22/2012 307 WATER OP-AUGUST HOSTING ITRON 513776 252574 456.23 GJ-120831FE 08/31/2012 05 JULY CC FEES UB 395 140.21 GJ-120831RC 08/31/2012 08 RECLASS TO FILING FEES 137.00 08/31/2012 10 RECLASS TO FILING FEES 441.00 TOTAL PERIOD 04 ACTIVITY 596.44 578.00 YTD BUDGET 2,933.36 TOTAL ACCOUNT ACTIVITY 5,321.26 1,078.12 ANNUAL REVISED BUDGET 8,800.00 ENDING BALANCE 4,243.14 52-520-54-00-5462 (E) PROFESSIONAL SERVICES 01 05/01/2012 BEGINNING BALANCE 0.00 GJ-120531FE 06/01/2012 07 APRIL CC FEES UB 395 187.12 06/01/2012 15 APRIL ANALYSIS FEES 21.88 GJ-AJE05 09/04/2012 12 AP REVERSALS FY 12 187.12 09/04/2012 13 AP REVERSALS FY 12 21.88 TOTAL PERIOD 01 ACTIVITY 209.00 209.00 02 AP-120626 06/19/2012 404 SEWER OP-JULY - SEPTEMBER WIRE WIZARD OF ILLIN 513565 13857 121.00 GJ-120630FE 06/20/2012 07 MAY CC FEES UB 395 38.68 TOTAL PERIOD 02 ACTIVITY 159.68 0.00 03 GJ-120731FE 08/02/2012 07 JUNE CC FEES UB 395 122.30 08/02/2012 15 JUNE ACCOUNT ANALYSIS FEE 20.19 TOTAL PERIOD 03 ACTIVITY 142.49 0.00 04 AP-120828 08/22/2012 380 SEWER OP-DOT DRUG SCREEN RUSH-COPLEY HEALTHCA 513825 6151 26.00 GJ-120831FE 08/31/2012 07 JULY CC FEES UB 395 43.09 TOTAL PERIOD 04 ACTIVITY 69.09 0.00 YTD BUDGET 1,666.68 TOTAL ACCOUNT ACTIVITY 580.26 209.00 ANNUAL REVISED BUDGET 5,000.00 ENDING BALANCE 371.26 DATE: 09/11/2012 UNITED CITY OF YORKVILLE PAGE: 5 TIME: 19:09:38 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 04 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 79-790-54-00-5462 (E) PROFESSIONAL SERVICES 01 05/01/2012 BEGINNING BALANCE 0.00 02 AP-20614A 06/06/2012 01 BACKGROUND CHECKS ILLINOIS STATE POLIC 208873 051512-P 94.50 06/06/2012 02 POST ACCIDENT DRUG SCREEN RUSH-COPLEY HEALTHCA 208876 5749-P 46.00 GJ-20614A 06/07/2012 02 AUDIT AJE 94.50 06/07/2012 03 AUDIT AJE 46.00 TOTAL PERIOD 02 ACTIVITY 140.50 140.50 03 GJ-120704FE 08/03/2012 01 JUNE CREDIT CARD FEES 829.77 AP-120712 07/03/2012 07 BACKGROUND CHECKS ILLINOIS STATE POLIC 208975 062612-PR 31.50 TOTAL PERIOD 03 ACTIVITY 861.27 0.00 YTD BUDGET 1,500.00 TOTAL ACCOUNT ACTIVITY 1,001.77 140.50 ANNUAL REVISED BUDGET 4,500.00 ENDING BALANCE 861.27 79-795-54-00-5462 (E) PROFESSIONAL SERVICES 01 05/01/2012 BEGINNING BALANCE 0.00 GJ-120514PR 05/30/2012 40 APRIL CC FEES CHARGED 5/6/12 775.63 AP-120524 05/16/2012 01 REFEREE EDDIE A. HOLMAN 208855 050812 140.00 05/16/2012 02 REFEREE PAUL MCDOWELL 208857 050312 140.00 05/16/2012 03 REFEREE BRUCE MORRICK 208859 050812 35.00 05/16/2012 04 REFEREE TRACY ROBINSON 208866 050312 140.00 05/16/2012 05 REFEREE TRACY ROBINSON 208866 050812 140.00 05/16/2012 06 REFEREE RONALD V. WOZNY 208868 050312 140.00 05/16/2012 07 REFEREE JASON ZALESKI 208869 050812 70.00 GJ-AJE05 09/04/2012 15 AP REVERSALS FY 12 775.63 TOTAL PERIOD 01 ACTIVITY 1,580.63 775.63 02 GJ-120611PR 06/12/2012 40 MAY CREDIT CARDS FEES 930.88 AP-120614 06/06/2012 29 REFEREE JOHN EARLE 208884 051712 140.00 06/06/2012 30 MAY 10 PARK BOARD MEETING LISA R. GODWIN 208886 051012 126.49 06/06/2012 31 REFEREE EDDIE A. HOLMAN 208891 051512 105.00 06/06/2012 32 REFEREE MARK A. HUTH 208894 052212 140.00 06/06/2012 33 REFEREE DENNIS KEITH 208896 051012 140.00 06/06/2012 34 REFEREE SCOTT MAYER 208897 052912 140.00 06/06/2012 35 REFEREE NORMAN C. MEIER 208898 052212 140.00 06/06/2012 36 REFEREE NORMAN C. MEIER 208898 052912 140.00 06/06/2012 37 REFEREE KRISTEN MERRIMAN 208900 051012 140.00 06/06/2012 38 REFEREE KRISTEN MERRIMAN 208900 051512 105.00 06/06/2012 39 REFEREE BRUCE MORRICK 208902 052212 140.00 06/06/2012 40 REFEREE BRUCE MORRICK 208902 052412 140.00 06/06/2012 41 REFEREE MUNNS, MARTY 208903 052412 140.00 06/06/2012 42 REFEREE TRACY ROBINSON 208912 051512 105.00 06/06/2012 43 REFEREE TRACY ROBINSON 208912 051712 140.00 06/06/2012 44 REFEREE TRACY ROBINSON 208912 052412 140.00 06/06/2012 45 REFEREE TRACY ROBINSON 208912 052912 140.00 06/06/2012 46 REFEREE RONALD V. WOZNY 208922 051012 140.00 06/06/2012 47 REFEREE JASON ZALESKI 208924 051712 140.00 AP-120628 06/19/2012 20 REFEREE ROBERT FERGUSON 208933 060512 140.00 06/19/2012 21 REFEREE RAYMOND HAYEN 208937 060512 140.00 DATE: 09/11/2012 UNITED CITY OF YORKVILLE PAGE: 6 TIME: 19:09:38 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 04 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 02 AP-120628 06/19/2012 22 REFEREE EDDIE A. HOLMAN 208938 060712 140.00 06/19/2012 23 REFEREE MARK A. HUTH 208939 060512 140.00 06/19/2012 24 REFEREE MARK A. HUTH 208939 061212 70.00 06/19/2012 25 REFEREE JIMMY E. JONES 208941 061412 140.00 06/19/2012 26 REFEREE NORMAN C. MEIER 208942 061412 140.00 06/19/2012 27 REFEREE BRUCE MORRICK 208946 060712 105.00 06/19/2012 28 REFEREE BRUCE MORRICK 208946 061212 140.00 06/19/2012 29 REFEREE MUNNS, MARTY 208947 060712 140.00 06/19/2012 30 ANNUAL CONTRACT RENEWAL VERMONT SYSTEMS 208957 36378 1,725.00 06/19/2012 31 REFEREE RONALD V. WOZNY 208958 061212 140.00 06/19/2012 32 REFEREE RONALD V. WOZNY 208958 061412 105.00 TOTAL PERIOD 02 ACTIVITY 6,737.37 0.00 03 AP-120712 07/03/2012 37 JUNE 14TH MEETING MINUTES LISA R. GODWIN 208965 061412 99.00 07/03/2012 38 REFEREE EDDIE A. HOLMAN 208971 062112 105.00 07/03/2012 39 REFEREE EDDIE A. HOLMAN 208971 062612 70.00 07/03/2012 40 REFEREE EDDIE A. HOLMAN 208971 062812 140.00 07/03/2012 41 REFEREE MARK A. HUTH 208974 061912 140.00 07/03/2012 42 REFEREE DENNIS KEITH 208976 062612 140.00 07/03/2012 43 CLASS INSTRUCTION KINDERMUSIK 208977 KM062012 136.20 07/03/2012 44 REFEREE BRUCE MORRICK 208980 061912 140.00 07/03/2012 45 REFEREE BRUCE MORRICK 208980 062112 105.00 07/03/2012 46 REFEREE BRUCE MORRICK 208980 062812 140.00 07/03/2012 47 REFEREE MUNNS, MARTY 208981 061912 140.00 07/03/2012 48 OFFICIALS ASSIGNING FEE FOR CYNTHIA O'LEARY 208985 SOFTBALL 1ST-12 505.00 07/03/2012 49 REFEREE TRACY ROBINSON 208994 062112 105.00 07/03/2012 50 REFEREE TRACY ROBINSON 208994 062812 140.00 07/03/2012 51 REFEREE VINCENT J. SCANIO 208996 062612 70.00 07/03/2012 52 REFEREE RONALD V. WOZNY 209002 062612 140.00 AP-120726 07/18/2012 20 SUMMER SESSION 1 SPORTS ALL STAR SPORTS INST 209005 124147 8,649.50 07/18/2012 21 GOLF CAMP INSTRUCTION CHAD JOHANSEN GOLF A 209008 1188 805.00 07/18/2012 22 PROGRAM CATALOG DISTRIBUTION DOOR TO DOOR DIRECT 209012 14647 638.00 07/18/2012 23 JUNE 26 MEETING MINUTES LISA R. GODWIN 209017 062612 13.16 07/18/2012 24 REFEREE RAYMOND HAYEN 209019 071212 140.00 07/18/2012 25 REFEREE DENNIS KEITH 209021 071212 140.00 07/18/2012 26 REFEREE NORMAN C. MEIER 209024 071012 140.00 07/18/2012 27 REFEREE BRUCE MORRICK 209027 071012 140.00 07/18/2012 28 ASSIGNING FEE PER OFFICIALS CYNTHIA O'LEARY 209029 SOFTBALL 2 ND 455.00 07/18/2012 29 REFEREE TRACY ROBINSON 209038 071012 140.00 07/18/2012 30 REFEREE TRACY ROBINSON 209038 071212 140.00 07/18/2012 31 TOT & KID ROCK CLASS ROCK 'N' KIDS, INC. 209039 YVSU12 608.00 TOTAL PERIOD 03 ACTIVITY 14,323.86 0.00 04 AP-120809 08/01/2012 26 REFEREE ROBERT FERGUSON 209053 071712 105.00 08/01/2012 27 JULY 12 MEETING MINUTES LISA R. GODWIN 209054 071212 113.75 08/01/2012 28 REFEREE RAYMOND HAYEN 209057 071712 105.00 08/01/2012 29 REFEREE RAYMOND HAYEN 209057 071912 140.00 08/01/2012 30 REFEREE RAYMOND HAYEN 209057 072412 140.00 08/01/2012 31 REFEREE RAYMOND HAYEN 209057 072612 105.00 DATE: 09/11/2012 UNITED CITY OF YORKVILLE PAGE: 7 TIME: 19:09:39 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 04 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 04 AP-120809 08/01/2012 32 REFEREE BRUCE MORRICK 209068 072612 105.00 08/01/2012 33 REFEREE MARTIN J. O'LEARY 209075 071712 105.00 08/01/2012 34 REFEREE MARTIN J. O'LEARY 209075 071912 140.00 08/01/2012 35 REFEREE MARTIN J. O'LEARY 209075 072412 140.00 08/01/2012 36 SOCCER TRAINING CAMP ALEKS MINAILOVIC 209090 CA12-011 660.00 08/01/2012 37 REFEREE RONALD V. WOZNY 209098 071912 105.00 GJ-120813PR 08/14/2012 45 JULY CREDIT CARD FEES 754.80 AP-120823 08/22/2012 41 JR ENGINEERING CLASS ALL ABOUT LEARNING 209104 5055 828.40 08/22/2012 42 AUGUST 9 PARK BOARD MEETING LISA R. GODWIN 209114 080912 76.16 08/22/2012 43 REFEREE RAYMOND HAYEN 209116 080812 105.00 08/22/2012 44 REFEREE EDDIE A. HOLMAN 209117 081612 105.00 08/22/2012 45 REFEREE MARK A. HUTH 209119 081412 70.00 08/22/2012 46 BACKGROUND CHECK ILLINOIS STATE POLIC 209120 080112P 31.50 08/22/2012 47 BACKGROUND CHECKS ILLINOIS STATE POLIC 209120 080912-PR 441.00 08/22/2012 48 REFEREE SCOTT MAYER 209125 081612 70.00 08/22/2012 49 REFEREE KRISTEN MERRIMAN 209127 081612 140.00 08/22/2012 50 REFEREE BRUCE MORRICK 209129 080912 140.00 08/22/2012 51 REFEREE BRUCE MORRICK 209129 081612 35.00 08/22/2012 52 SOFTBALL ASSIGNING FEE FOR CYNTHIA O'LEARY 209132 SOFTBALL 3 290.00 08/22/2012 53 REFEREE MARTIN J. O'LEARY 209133 071412 70.00 08/22/2012 54 REFEREE MARTIN J. O'LEARY 209133 080912 140.00 08/22/2012 55 REFEREE TRACY ROBINSON 209145 081812 70.00 TOTAL PERIOD 04 ACTIVITY 5,330.61 0.00 YTD BUDGET 20,000.00 TOTAL ACCOUNT ACTIVITY 27,972.47 775.63 ANNUAL REVISED BUDGET 60,000.00 ENDING BALANCE 27,196.84 80-800-54-00-5462 (E) PROFESSIONAL SERVICES 01 05/01/2012 BEGINNING BALANCE 0.00 GJ-120514PR 05/30/2012 42 APRIL CC FEES CHARGED 5/6/12 775.62 AP-120524 05/16/2012 33 MAY PEST CONTROL FIRST ILLINOIS SYSTE 208852 9442 43.00 GJ-AJE05 09/04/2012 17 AP REVERSALS FY 12 775.62 TOTAL PERIOD 01 ACTIVITY 818.62 775.62 02 GJ-120611PR 06/12/2012 42 MAY CREDIT CARDS FEES 930.88 AP-120614 06/06/2012 70 TANNING LICENSE RENEWAL ILLINOIS DEPARTMENT 208895 026989-2012 150.00 06/06/2012 71 JULY 2012 - SEPT. 2012 ALARM WIRE WIZARD OF ILLIN 208921 13767 60.00 AP-120628 06/19/2012 64 JUNE PEST CONTROL FIRST ILLINOIS SYSTE 208934 9608 43.00 06/19/2012 65 ANNUAL CONTRACT RENEWAL VERMONT SYSTEMS 208957 36378 1,725.00 AP-20614A 06/06/2012 10 BACKGROUND CHECKS ILLINOIS STATE POLIC 208873 051512-P 31.50 GJ-20614A 06/07/2012 11 AUDIT AJE 31.50 TOTAL PERIOD 02 ACTIVITY 2,940.38 31.50 03 GJ-120704FE 08/03/2012 03 JUNE CREDIT CARD FEES 829.77 AP-120712 07/03/2012 74 BACKGROUND CHECKS ILLINOIS STATE POLIC 208975 062612-PR 63.00 AP-120726 07/18/2012 45 PROGRAM CATALOG DISTRIBUTION DOOR TO DOOR DIRECT 209012 14647 638.00 07/18/2012 46 JULY PEST CONTROL FIRST ILLINOIS SYSTE 209014 9772 43.00 TOTAL PERIOD 03 ACTIVITY 1,573.77 0.00 04 GJ-120813PR 08/14/2012 47 JULY CREDIT CARD FEES 754.79 DATE: 09/11/2012 UNITED CITY OF YORKVILLE PAGE: 8 TIME: 19:09:39 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 04 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 04 AP-120823 08/22/2012 75 AUGUST PEST CONTROL FIRST ILLINOIS SYSTE 209112 9943 43.00 08/22/2012 76 BACKGROUND CHECK ILLINOIS STATE POLIC 209120 080112P 31.50 TOTAL PERIOD 04 ACTIVITY 829.29 0.00 YTD BUDGET 6,666.68 TOTAL ACCOUNT ACTIVITY 6,162.06 807.12 ANNUAL REVISED BUDGET 20,000.00 ENDING BALANCE 5,354.94 82-820-54-00-5462 (E) PROFESSIONAL SERVICES 01 05/01/2012 BEGINNING BALANCE 0.00 AP-120514 05/08/2012 02 MAINTENANCE CONTRACT CHARGE SOUND INCORPORATED 103157 R113770 709.50 05/08/2012 03 MAY ELEVATOR MAINTENACE THYSSENKRUPP ELEVATO 103159 3000158407 218.03 GJ-120531FE 06/01/2012 17 WIRE FEE 5/7/12 15.00 06/01/2012 19 WIRE FEE 5/14/12 20.00 TOTAL PERIOD 01 ACTIVITY 962.53 0.00 02 AP-120611 06/04/2012 07 SILVER SERVICE AGREEMENT SOUND INCORPORATED 103175 R114336 291.00 06/04/2012 08 REMOVED AND REPLACED FAULTY TRICO MECHANICAL SER 103176 2850 1,285.28 06/04/2012 09 SPRING START UP SERVICE TRICO MECHANICAL SER 103176 2851 2,282.10 GJ-120630FE 06/20/2012 09 JUNE WIRE FEES 85.00 TOTAL PERIOD 02 ACTIVITY 3,943.38 0.00 03 AP-120709 07/02/2012 08 RENEWAL FOR POLICY #2465461 CASTLE INSURANCE SER 103185 427320 340.00 07/02/2012 09 COMMUNICATION CHARGES ILLINOIS CENTURY NET 103188 T1239908 7.20 07/02/2012 10 JUNE ELEVATOR MAINTENANCE THYSSENKRUPP ELEVATO 103197 3000175908 218.03 07/02/2012 11 ELEVATOR REPAIR THYSSENKRUPP ELEVATO 103197 6000003740 200.00 07/02/2012 12 CONTINUED WORK ON PUBLIC PC YORKVILLE PC 103199 1308 1,440.00 07/02/2012 13 MAY 14 MEETING MINUTES MARLYS J. YOUNG 103200 051412 90.00 07/02/2012 14 JUNE 11 MEETING MINUTES MARLYS J. YOUNG 103200 061112 62.00 GJ-120731FE 08/02/2012 09 JUNE WIRE FEES 30.00 TOTAL PERIOD 03 ACTIVITY 2,387.23 0.00 04 AP-120813 08/07/2012 10 POLICY #3020335 ANNUAL RENEWAL CASTLE INSURANCE SER 103208 438244 456.00 08/07/2012 11 COPIER CHARGES KONICA MINOLTA BUSIN 103214 221605130 3.69 08/07/2012 12 COPIER CHARGES KONICA MINOLTA BUSIN 103214 221611598 383.78 08/07/2012 13 MAINTENANCE CONTRACT CHARGE SOUND INCORPORATED 103222 R115534 709.50 08/07/2012 14 JULY ELEVATOR MAINTENANCE THYSSENKRUPP ELEVATO 103223 3000190764 218.03 08/07/2012 15 JULY 9 MEETING MINUTES MARLYS J. YOUNG 103226 070912 65.50 TOTAL PERIOD 04 ACTIVITY 1,836.50 0.00 YTD BUDGET 9,666.68 TOTAL ACCOUNT ACTIVITY 9,129.64 0.00 ANNUAL REVISED BUDGET 29,000.00 ENDING BALANCE 9,129.64 GRAND TOTAL 87,970.75 0.00 TOTAL DIFFERENCE 87,970.75 0.00 0 CIP Reviewed By: Agenda Item Number J� a► Legal ❑ NB #2 W36 EST. Finance ■ Engineer ❑ Tracking Number Gy City Administrator El r� _© Consultant El ADM 2012-50 Agenda Item Summary Memo Title: Treasurer's Report for August 2012 Meeting and Date: Administration Committee 9/20/12 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: UNITED CITY OF YORKVILLE TREASURER'S REPORT-for the period ending AUGUST 31,2012 Cash Basis %of %of Projected Beginning Revenues YTD Expenses YTD Ending Fund Fund Balance August Revenues YTD Revenues Budget Budget August Expenses YTD Expenses Budget Budget Balance General Fund 01 -General 1,270,623 1,155,008 5,156,244 12,311,109 42% 976,210 3,036,240 11,379,867 27% 3,390,627 Special Revenue Funds 15-Motor Fuel Tax 924,857 36,267 137,173 454,547 30% 5,868 10,696 573,860 2% 1,051,334 79-Parks and Recreation 280,065 106,505 554,660 1,451,447 38% 194,006 500,149 1,506,767 33% 334,576 72-Land Cash (294,778) 3,077 21,280 420,500 5% 547 34,390 323,825 11% (307,888) 87-Countryside TIF 1,877,872 240 925 6,500 14% - 62,429 306,043 20% 1,816,369 88-Downtown TIF 257,953 1,213 25,133 70,150 36% 3,223 6,539 41,500 16% 276,547 11 -Fox Hill SSA 17,071 264 2,192 3,786 58% 423 2,290 4,500 51% 16,973 12-Sunflower SSA 12,188 479 4,374 7,531 58% 2,024 6,190 9,986 62% 10,372 Debt Service Fund 42-Debt Service 87,510 28,309 221,674 427,144 52% - 65,292 505,370 13% 243,893 Capital Funds 16-Municipal Building (579,374) 450 3,300 5,250 63% - 1,200 - - (577,274) 22-Park and Recreation Capital 62,473 1,041 2,003 43,500 5% 208 833 52,500 2% 63,642 20-Police Capital 229,238 1,597 19,116 29,200 65% - 118,427 60,000 197% 129,928 21 -Public Works Capital 62,884 798 20,117 53,500 38% 7,201 33,424 169,795 20% 49,577 23-City-Wide Capital 81,196 34,966 162,905 1,303,732 12% 26,398 72,979 1,040,500 7% 171,122 Enterprise Funds 51 -Water 1,300,837 604,851 1,214,435 2,801,379 43% 234,649 1,140,027 3,085,983 37% 1,375,245 52-Sewer 3,003,537 142,532 702,801 1,639,817 43% 97,407 431,706 1,895,210 23% 3,274,632 80-Recreation Center (220,001) 48,664 190,498 622,500 31% 81,060 250,791 703,633 36% (280,294) Library Funds 82-Library Operations 388,831 49,265 431,030 817,634 53% 75,727 243,848 794,413 31% 576,013 83-Library Debt Service (1,821) 48,529 456,495 797,299 57% - 177,744 795,488 22% 276,930 84-Library Capital 6,794 10,800 13,301 16,350 81% 6 637 13,474 5% 19,458 Total Funds 8,767,955 2,274,855 9,339,656 23,282,875 40% 1,704,957 6,195,830 23,262,714 27% 11,911,781 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 0 CIP Reviewed By: Agenda Item Number J� a► Legal ❑ NB #3 W36 EST. Finance ■ Engineer ❑ Tracking Number Gy City Administrator ■ r� _© Consultant E] ADM 2012-51 Agenda Item Summary Memo Title: Cash Statement for July 2012 Meeting and Date: Administration Committee 9/20/12 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: UNITED CITY OF YORKVILLE CASH AND INVESTMENT SUMMARY-as of July 31,2012 CASH Cash-Operations Cash-Special Purpose IL Funds IL Funds Operations Aurora Special Purpose Grand Old Second Castle E-Pay Acct IMET Totals Old Second Castle IMET Earthmovers Totals Totals General Fund 01-General 137,028 5,881 1 1,129,813 1,272,723 2,197 15,747 50 17,995 1,290,718 Special Revenue Funds 15-Motor Fuel Tax - - - - - 988,085 988,085 988,085 72-Land Cash (310,408) - (310,408) - - - (310,408) 87-Countryside TIF 151,662 970,531 1,122,193 693,936 693,936 1,816,129 88-Downtown TIT 273,893 4,665 278,558 - - 278,558 11-Fox Hill SSA 16,491 642 17,132 17,132 12-Sunflower SSA 10,489 1,428 11,917 11,917 Debt Service Fund 42-Debt Service 164,773 50,810 215,584 215,584 Capital Funds 16-Municipal Building (574,724) - (574,724) (574,724) 20-Police Capital 127,675 127,675 127,675 21-Public Works Capital 67,391 67,391 - - 67,391 23-City-Wide Capital 218,444 - 218,444 55,921 55,921 274,365 Enterprise Funds 51-Water 315,178 9,761 313,014 637,954 - - 637,954 52-Sewer 720,762 2,999 2,206,611 2,930,372 2,930,372 Agency Funds 90-Developer Escrow 137,174 - - 137,174 137,174 95-Escrow Deposit 206,797 12,027 - 218,824 - - - - 218,824 Total City Funds 1,662,625 30,668 1 4,677,514 6,370,807 696,133 - 1,059,754 50 1,755,938 8,126,744 Distribution% 20.46% 0.38% 0.00% 57.56% 8.57% 0.000% 13.04% 0.00% Library Funds 82-Library Operations 279,738 - 20 - 279,758 - - 332,969 25 332,994 612,752 83-Library Debt Service - 228,400 228,400 - - - - 228,400 84-Library Capital - - - 6,164 - 6,164 6,164 Totals 279,738 228,420 508,158 6,164 332,969 25 339,158 847,316 Distribution% 33.01% 26.96% 0.73% 39.30% Park and Recreation Funds 79-Parks and Recreation - 459,034 - 459,034 - - 25 25 459,059 22-Park&Rec Capital 61,455 61,455 148,087 148,087 209,542 80-Recreation Center (243,358) (243,358) - - (243,358) Totals 277,131 277,131 148,087 25 148,112 425,243 Distribution% 65.17% 34.82% 0.01% Reviewed By: Agenda Item Number 606 Legal ❑ NB #4 Finance ❑ EST. -� __ti 1838 Engineer ❑ -- City Administrator ❑ Tracking Number Human Resources ❑ `=Q Community Development ADM 2012-52 Police ALE � Public Works ❑ Parks and Recreation ❑ Agenda Item Summary Memo Title: Cultural Commission Discussion Meeting and Date: Administration Committee— September 20, 2012 Synopsis: Discussion regarding disbanding the Cultural Commission. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Mayor Golinski Name Department Agenda Item Notes: Ordinance No. 2012- AN ORDINANCE AMENDING THE CODE OF ORDINANCES OF THE UNITED CITY OF YORKVILLE, KENDALL COUNTY,ILLINOIS REGARDING CULTURAL COMMISSION WHEREAS, the United City of Yorkville (the "City") is a duly organized and validly existing non-home-rule municipality created in accordance with Article VII, Section 7 of the Constitution of the State of Illinois of 1970; and, WHEREAS,the City has established various boards and commissions to help serve the residents of the City; and, WHEREAS, a Cultural Commission (the "Commission")was established in 2010 for the purpose of organizing and producing exhibition of works of art, programs of music and performing arts, establishment of museums, the exhibition of historical objects, the presentation of dramatic productions and other exhibitions and performances as deemed desirable to enhance the cultural and intellectual opportunities of the citizens of the city; and, WHEREAS, after considerable review of the activities of the Commission and related expenditures that the City incurs in keeping the Commission in existence, it has been determined that the Commission should be disbanded. NOW THEREFORE, BE IT ORDAINED by the Mayor and City Council of the United City of Yorkville, Kendall County, Illinois, as follows: Section 1. Title 2, Chapter 9 of the Code of Ordinances is hereby amended by deleting Chapter 9 in its' entirety. Section 2. This Ordinance shall be in full force and effect upon its passage, approval, and publication as provided by law. Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this Day of , A.D. 2012. CITY CLERK CHRIS FUNKHOUSER DIANE TEELING JACKIE MILSCHEWSKI LARRY KOT CARLO COLOSIMO MARTY MUNNS ROSE ANN SPEARS KEN KOCH Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this Day of , A.D. 2012. MAYOR `� 13 fry Reviewed By: �� �•s► Legal ❑ Agenda Item Number Finance ❑ NB #5 EST. -� _ 1838 Engineer ❑ City Administrator 0 Human Resources ❑ Tracking Number Community Development ❑ j� ���� Police F-1 Public 2012-53 LE Public Works ❑ Parks and Recreation ❑ Agenda Item Summary Memo Title: Sale of caboose Meeting and Date: Administration September 20, 2012 Synopsis: See attached memo. Council Action Previously Taken: Date of Action: N/A Action Taken: Item Number: Type of Vote Required: Majority Council Action Requested: Direction Submitted by: Bart Olson Administration Name Department Agenda Item Notes: Memorandum To: City Council EST. 183fi From: Bart Olson, City Administrator ' CC: Date: September 13, 2012 Subject: Caboose LLE�% Summary Discussion of potential sale of the City's caboose. Background In May 2007, the City purchased a caboose from a local resident for$10,500. The caboose was to be refurbished and moved to the Whispering Meadows park("Bristol Station Park"). When the City received quotes for the caboose relocation and installation at the Park, the cost($30,000)was deemed too high and the project was placed on indefinite hold. For the past few years, the Park Board has been discussing the placement of the caboose in various areas around town, including different locations in the downtown. No site has been selected, due to the lack of funds for movement, installation, and rehabilitation. The City Council can authorize the sale of the caboose by simple motion, according to our disposal of property policy(attached). It is recommended that the City utilize a sealed bid process, should the City Council direct a sale of the caboose. Recommendation Staff seeks direction on the sale of the caboose. r STATE OF ILLINOIS ) )SS COUNTY OF KENDALL ) RESOLUTION NO: 2005- ©5 RESOLUTION APPROVING DISPOSAL OF PROPERTY POLICY WHEREAS,the Mayor and City Council deem it prudent and in the best interest of the United City of Yorkville to develop a policy regarding Disposal of City property;and WHEREAS,the purpose of such a policy is to provide direction for the proper disposal of certain City property as described therein; WHEREAS, after extensive study and review, the City Staff Mayor and City Council developed a policy regarding disposal of City property which is attached hereto as Exhibit"A"; NOW THEREFORE BE IT RESOLVED BY THE UNITED CITY OF YORKVILLE, upon motion duly made, seconded, and approved by a majority of those Aldermen voting, that the City hereby adopts the United City of Yorkville Disposal of Property Policy attached hereto as Exhibit "A". PAUL JAMES MARTY MUNNS '— RICHARD STICKA WANDA OHARE �j VALERIE BURD ROSE SPEARS LARRY KOT � JOSEPH BESCO APPROVED by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this 25th day of January, 2005. i 0 1-47�-<- YAW iel& Mayor Page 1 of 2 PASSED by the City Council of the United City of Yorkville, Kendall County, Illinois this 25th day of January, 2005. bityler Prepared by: City Clerk's Office United City of Yorkville 800 Game Farm Road Yorkville, IL 60560 630/553-4350 Fax: 630-553-7575 i Page 2 of 2 16 Disposal of Property Policy DRAFT — 1/19/2005 1)Whenever the City owns any personal property which is determined by a Department Head to be no longer necessary or useful to, or for the best interest of the City and having an original value of less than$500.00,the Department Head,by their approval, may authorize the disposal of said property. Disposal is defined as the destruction of said property, or placement in a trash or recycling receptacle. 2) Whenever the City owns any personal property having an original value of greater than $500, and said property is determined to be no longer necessary or useful to the City, or it is determined that it is not in the best interest of the City to retain the subject personal property, then City shall be authorized to convey or sell the subject personal property in accordance with the following conditions and procedures: 2A) A written determination shall be prepared stating that the City no longer desires to retain ownership of the subject personal property or that the useful life of the subject personal property has expired and shall set forth reasons therefore. As a condition of disposal or sale of property, the written determination must be given to all Department Heads and Council Members. 2B) The written determination stated in paragraph 2A shall be presented to the United City of Yorkville Administration Committee, and receiving a committee recommendation, shall be forwarded to City Council. Upon approval by the City Council, the City may: 2B1) By ordinance authorize the sale of that personal property in such manner as the City Council may designate so long as the sale complies with the applicable statutes contained within the Municipal Code of the Illinois Compiled Statutes. 2132) May authorize any municipal officer to convert that personal property into some other form that is useful to the City by using the material in the property. 2133) May authorize any municipal officer to convey or turn in any specified article of property as part payment on a new purchase of any similar article. However, no article shall be turned in as part of the purchase price on any purchase except upon receipt of competitive bids, in such manner as may be prescribed by ordinance, after notice to all bidders that the article will be turned over as part of the purchase price. 3) Disposal or sale of the property hereunder shall not be made to any elected or appointed official or employee of the City, except items sold at public auction or sealed c bids. Reviewed By: Agenda Item Number 0 Legal ❑ OB #1 Finance ❑ EST. -� __ti 1838 Engineer ❑ -- City Administrator Tracking Number Human Resources ❑ Community Development ❑ P F-1 CC 2012-49 Police ALE � Public Works ❑ Parks and Recreation ❑ Agenda Item Summary Memo Title: Ordinance Regarding City Council Procedures—Citizen Comments Meeting and Date: Administration Committee— September 20, 2012 Synopsis: Proposal to add second Citizen Comment section to City Council/ COW agendas. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Majority Council Action Requested: Submitted by: Jeff Weckbach Administration Name Department Agenda Item Notes: Memorandum To: Administration Committee EST. -�` Yid 1s36 From: Jeff Weckbach, Administrative Intern Bart Olson, City Administrator Date: September 13, 2012 C<wrMY Sad Subject: Procedural Ordinance ALE Summary: Consideration of an amendment to the procedural ordinance to allow for a second citizen comment section at City Council and COW meetings. Background: This item was last discussed at the July 10th COW meeting. At that time an ordinance amendment was proposed to separate the citizen comments section of the City Council and COW meetings to allow for citizen comments related to any agenda items at the beginning of the meeting and for citizen comments related to any other issues to occur at the end of the meeting, prior to executive session. At the June 26th meeting it was proposed to add a five minute time limit to the citizen comment sections. The Council decided at that time to remove this wording from the proposed ordinance. This issue was tabled and sent back to the Administration Committee. Analysis: The addition of a second section for citizen comments would result in the amendment of agendas for City Council and COW meetings so there will be an agenda item specific citizen comment section where the regular citizen comment section is currently, and an open-topic citizen comment section at the end of the meeting. Implementing this procedural ordinance amendment would allow for the Council to focus on how citizen comments directly relate to agenda items and then have time at the end of the meeting to listen to other citizen concerns. Recommendation: The committee should consider what direction should be taken on the procedural ordinance. Ordinance No. 2012- AN ORDINANCE REGARDING CITY COUNCIL PROCEDURES WHEREAS, the United City of Yorkville (the "City") is a duly organized and validly existing non-home-rule municipality created in accordance with Article VII, Section 7 of the Constitution of the State of Illinois of 1970; and, WHEREAS,the City Council of the United City of Yorkville first passed a Procedural Ordinance on November 8, 2011 as Ordinance 2011-65, and revised said ordinance on April 24, 2012 as Ordinance 2012-09; and, WHEREAS,the City Council of the United City of Yorkville, in accordance with the Illinois Compiled State Statutes, has the right to determine procedures for organizing and conducting all meetings of the City Council acknowledging that the City is bound by certain state and federal laws as well as legal precedents which cannot be supplanted by City ordinance; and, WHEREAS, in keeping with this right, the City Council has adopted Roberts Rules of Order to outline the procedure to be followed during meetings and to regulate the actions of Council members and the public in attendance at such meetings; and, WHEREAS,the City Council has discussed implementing additional procedures to supplement Roberts Rules of Order regarding City Council meetings and the four standing committees of the City Council—Administration, Economic Development, Public Safety and Public Works. NOW THEREFORE, BE IT ORDAINED by the Mayor and City Council of the United City of Yorkville, Kendall County, Illinois, as follows: Section 1. Procedures for City Council Meetings: a. During the months of September through May, City Council Meetings shall be regularly scheduled to convene on the 2nd and 4th Tuesday of each month at 7:00 p.m. in the City Hall Council Chambers. For the months of June,July, and Ordinance No.2012- Page 2 August, City Council Meetings shall be regularly scheduled to convene on the 4d' Tuesday of each month at 7:00 p.m. in the City Hall Council Chambers. b. Citizens in attendance at any meeting of the City Council shall be entitled to address the City Council on any genda item prior to the Council's consideration of the Consent Agenda in order to permit the work of the City Council to proceed. Citizens shall be entitled to address the City Council on any matter immediately prior to adjournment. b c.No application presented during a public hearing shall be voted on during the same City Council meeting in which that public hearing is held. This provision may be waived by a supermajority of the City Council. Ed.City Council meeting agenda items may be added by the Mayor, consent of four (4) aldermen, or direction from a committee. 47e.The Mayor shall preside over City Council meeting as the Chairman,unless the Mayor is unavailable, at which time the Mayor Pro Tem shall preside. �£ The City Council shall appoint the Mayor Pro Tern at the first City Council meeting each May. The appointment shall occur by calling for open nominations at the meeting, and then a roll call votes on the nominations. Section 2. Procedures for Committee of the Whole Meetings: a. During the months of June, July, and August Committee of the Whole meetings shall be regularly scheduled to convene on the 2nd Tuesday of each month at 7:00 p.m. in the City Hall Council Chambers. b. Committee of the Whole agenda items may be added by the Mayor or any alderman. c. Citizens in attendance at any meeting of the Committee of the Whole shall be entitled to address the City Council on any agenda item in order to permit the work of the City Council to proceed. Citizens shall be entitled to address the City Council on any matter prior to adjournment. mod.Each section of the Committee of the Whole meeting shall be presided over by the respective Committee's Chairman, or in the absence of the chairman, by the vice-chairman. 4 e.The intent of the Committee of the Whole is that each agenda item is ^discussed by the City Council as a whole, prior to its movement onto a subsequent City Council meeting (as directed by the Mayor or any four aldermen). Section 3. Procedures for Committee Meetings: Ordinance No.2012- Page 3 a. During the months of September through May, Committee meetings shall be regularly held monthly, at the dates, times and locations as approved by the Committees. b. The Mayor shall be a non-voting member of all standing committees. c. The Mayor shall select committee rosters at the first City Council meeting in May following a municipal consolidated election(i.e. every two years). d. Committee rosters may be switched by mutual,unanimous consent of the aldermen trading seats and the Mayor. e. The Mayor shall select committee chairmen and vice-chairmen. f. Any alderman may add any agenda item to any committee agenda. g. Chairmen shall select liaisons to other organizations and boards by any means they deem necessary,provided that the other organizations by-laws may govern the selection of the liaison. h. The four committees shall be: i. Administration ii. Economic Development iii. Public Safety iv. Public Works i. Each committee shall be presided over by its chairman, or in the absence of the chairman, the vice-chairman. j. Committee meetings may be cancelled by the Chairman of the committee if there is a not a quorum of the members present, or there are no agenda items which require action by a committee. k. When moving items from the committee agenda to a City Council agenda, the committee shall make a recommendation whether that item should be on consent agenda or the committee's report. If on the committee's report, the committee shall make a recommendation whether the item is up for first reading, or is on the City Council agenda for action. Section 3. This Ordinance shall be in full force and effect upon its passage, approval, and publication as provided by law. Passed by the City Council of the United City of Yorkville, Kendall County, Illinois this Day of , A.D. 2012. CITY CLERK Ordinance No.2012- Page 4 CHRIS FUNKHOUSER DIANE TEELING JACKIE MILSCHEWSKI LARRY KOT CARLO COLOSIMO MARTY MUNNS ROSE ANN SPEARS KEN KOCH Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this Day of , A.D. 2012. MAYOR Ordinance No.2012- Page 5