The URL can be used to link to this page

Administration Packet 2013 01-17-13 �2 r 0 United City of Yorkville EST. 1 iaac 800 Game Farm Road Yorkville, Illinois 60560 o ( Telephone: 630-553-4350 Fax: 630-553-7575 <ILL E ��-�• AGENDA ADMINISTRATION COMMITTEE MEETING Thursday, January 17, 2013 6:00 p.m. City Hall Conference Room Citizen Comments: Minutes for Correction/Approval: November 15, 2012 New Business: 1. ADM 2013-01 Monthly Budget Report for December 2012 2. ADM 2013-02 Monthly Treasurer's Reports for November & December 2012 3. ADM 2013-03 Cash Statement for October & November 2012 4. ADM 2013-04 Local Debt Recovery Program 5. ADM 2013-05 City Services Survey 2013 6. ADM 2013-06 Chamber of Commerce Membership Utility Bill Offer 7. ADM 2013-07 Ordinance Amending City Code Regarding Deputy Treasurer Pay 8. ADM 2013-08 NIMEC Bid for Electric Accounts Old Business: 1. ADM 2012-58 Procedural Ordinance Amendment regarding Removal of COW Additional Business: 2013/2014 City Council Goals-Administration Committee Goal Priority Staff "Build fund balance" 1 Rob Fredrickson&Bart Olson "Website improvement(tie-in to tourism and mobile)" 7 Jeff Weckbach&Bart Olson "Home Rule Referendum" 8.5 Jeff Weckbach&Bart Olson "Community outreach (Route 47)" 10 Bart Olson "Elected Official Referendum Planning" 10 Bart Olson "Updating technology in Chamber" 10 Jeff Weckbach&Bart Olson UNITED CITY OF YORKVILLE WORKSHEET ADMINISTRATION COMMITTEE Thursday, January 17, 2013 6:00 PM City Hall Conference Room --------------------------------------------------------------------------------------------------------------------------------------- CITIZEN COMMENTS: --------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------- MINUTES FOR CORRECTION/APPROVAL: --------------------------------------------------------------------------------------------------------------------------------------- 1. November 15, 2012 ❑ Approved ❑ As presented ❑ With corrections --------------------------------------------------------------------------------------------------------------------------------------- NEW BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. ADM 2013-01 Monthly Budget Report for December 2012 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2013-02 Monthly Treasurer's Reports for November&December 2012 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 3. ADM 2013-03 Cash Statements for October&November 2012 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 4. ADM 2013-04 Local Debt Recovery Program ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 5. ADM 2013-05 City Services Survey 2013 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 6. ADM 2013-06 Chamber of Commerce Membership Utility Bill Offer ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 7. ADM 2013-07 Ordinance Amending City Code Regarding Deputy Treasurer Pay ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 8. ADM 2013-08 NIMEC Bid for Electric Accounts ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- OLD BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. ADM 2012-58 Procedural Ordinance Amendment regarding Removal of COW ❑ 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� 6 Legal ❑ Minutes EST. 1&36 Finance El Engineer ❑ Tracking Number Gy City Administrator El r� 9 _© Public Works ❑ Agenda Item Summary Memo Title: Minutes of the Administration Committee—November 15, 2012 Meeting and Date: Administration Committee—January 17, 2013 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Majority Council Action Requested: Committee Approval Submitted by: Minute Taker Name Department Agenda Item Notes: DRAFT UNITED CITY OF YORKVILLE ADMINISTRATION COMMITTEE MEETING Thursday,November 15, 2012 6:00pm City Hall Conference Room Committee Members In Attendance: Chairman Rose Spears Alderman Chris Funkhouser Alderman Ken Koch Absent: Alderman Marty Munns Other City Officials In Attendance: Bart Olson, City Administrator Rob Fredrickson, Finance Director Jeff Wechbach, Administrative Intern Guests: none The meeting was called to order at 6:00pm by Chairman Rose Spears. Citizen Comments: None Minutes for Correction/Approval: - September 20, 2012 The following corrections in bold were requested: Page 1: a) 3rd paragraph, 5th sentence: ....but one of the disbursements the city received was more than..... b) 4th paragraph, 1St sentence: ... an entire Saturday was lost due to weather. Page 2: a) 1st paragraph, 1St sentence: ...that will rescind the committee. b) 1St paragraph, 2nd sentence: ...The committee agreed.... c) 4th paragraph, 2nd to last sentence: ...agreed to leave this as is... d) 5th paragraph, 2nd sentence: ...a procedural ordinance to return to 12... The committee then approved the minutes as amended. 1 New Business: 1. ADM 2012-54 Monthly Budget Report for September& October 2012 Mr. Olson reported the expenses were under budget. Sales tax will be monitored and the November report has been received that details the August consumer purchases and are comparable to last year. He said the City budgeted lower this year to compensate for the loss of Pro Build. The City is only slightly behind budget, however, Christmas could affect this figure. 2. ADM 2012-55 Monthly Treasurer's Reports for September& October 2012 Rob Fredrickson presented the reports. There was no discussion and this is informational only. 3. ADM 2012-56 Cash Statements for August&September 2012 Informational item, no discussion. 4. ADM 2012-57 Investment Policy The original policy was created in 2004 and Mr. Fredrickson said it should be reviewed periodically. He said there is more detail on the objectives and suitable investments, while the collateralization policy remains the same. This will move forward to the City Council consent agenda. 5. ADM 2012-58 Procedural Ordinance Amendment Regarding Removal of COW Alderman Colosimo proposed this amendment to return to the original City Council structure. Mr. Funkhouser opposes the removal of COW meetings and said he would like to see them continue in the summer months. Mr. Koch said he had not had adequate time to get staff opinions to make an informed decision. Mr. Olson summarized some of the pros and cons and Mr. Funkhouser added that items were able to be discussed by the full Council and staff. The lengths of the COW meetings were also discussed. It was decided to table this item to December to allow Alderman Koch to gather more information. 6. ADM 2012-59 IT Purchase-Laserfiche Add-ons Mr. Olson said this is an on-line document management system and is a budgeted item. Presently there is no central place to find desired documents, however, this system would allow any City-scanned documents to be searched. Residents would also be able to search documents. All committee members were in favor of this system and anticipated implementation will take 30-60 days. 7. ADM 2012-60 Ordinance Establishing a Fee for Collection of Delinquent Bills This ordinance would be a revision of an existing policy allowing for a delinquent bill fee. The current ordinance does not list the fine amounts. The committee recommended approval and the item will move to the City Council consent agenda. 8. ADM 2012-61 Banking RFP Results Mr. Fredrickson said banking RFP's were sent to local banks in August and 4 proposals were returned. After a review, Mr. Fredrickson recommended Castle Bank since they had a positive net income and financial stability. All committee members supported this recommendation and the item will move to the Council consent agenda. 2 9. ADM 2012-62 Ordinance for the Amended Levy...Fox Hill 10. ADM 2012 63 Ordinance for the Amended Levy...Sunflower Estates Items #9 & 10 were discussed together. Bart Olson said the City controls the HOA's and taxes those residents for maintenance of their common areas. Expenses were incurred this summer and money is collected next year. Fox Hill has trails that will need to be sealcoated in the future and Sunflower has ponds in need of dredging. This maintenance will not be done next year, but will be the following year with the costs being amortized over a 10-20 year period. If the ponds are naturalized, it is less expensive. This will move forward to the Council consent agenda. 11. ADM 2012-64 2012 Bond Abatements (see agenda for details) Administrator Olson said all these abatements would result in approximately$486,000 in property taxes. The City is ahead of schedule in reducing the obligation and hopes to eliminate them by 2016. He also detailed the status of each of the 5 bond abatements. This will move to the December Council consent agenda. 12. ADM 2012-65 Administration Committee Meeting Schedule for 2013 This schedule was approved by the committee. Old Business: -None Additional Business: - None The meeting was adjourned at 6:43pm on a motion and second by Aldermen Koch and Funkhouser, respectively. Minutes transcribed by Marlys Young, Minute Taker 3 Reviewed By: Agenda Item Number 4 ' �► Legal ❑ NB #1 Finance ■ EST. -�` _ ti W36 Engineer ❑ �:--- g Tracking Number �! City Administrator ■ Consultant ❑❑ ADM 2013-01 ALE Agenda Item Summary Memo Title: Budget Reports for November&December 2012 Meeting and Date: Administration Committee—January 17, 2013 Synopsis: November/December budget reports and income statements. 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: 0 co �p Date: January 10, 2013 Keda'cun" �' reports Subject: November and December 2012 budget re g p General Fund Revenues 01-000-40-00-4000 Property Taxes—Corporate Levy The November figure is the final disbursement of property taxes for FY 13. The minor shortfall is due from non-payment of property taxes,but is within the bounds of what we've seen the past few years. 01-000-40-00-4010 Police Pension The police pension revenues are higher than budgeted because the City received a little bit more property taxes in full than we thought we'd receive, and the Police Pension fund was where we had indicated any unanticipated revenues would be placed. O1-000-40-00-4030 Municipal Sales Tax The December figure of$207,616 is for consumer purchases made in September and turned into the state by retailers in October. The November figure of$209,444 is for consumer purchases made in August and turned into the state in September. Our sales tax forecasting model expected these figures to both be around $203,000, so both months beat expectations. For the year, we budgeted $2.325 million and we are currently on pace for$2.425 million. In FY 12, our actual year-end total was $2.552 million. 01-000-40-00-4035 Non-home rule sales tax The December figure of$161,337 is for consumer purchases made in September and turned into the state by retailers in October. The November figure of$160,592 is for consumer purchases made in August and turned into the state in September. Currently, we are on pace for more than $1.8 million in total non-home rule sales tax, which is more than our$1.5 million budgeted amount. 01-000-40-00-4041 Natural Gas Utility Tax We are behind our historical average of$296,000 annually, but likely above our total from last year of$225,000—which was during a record warm winter. 01-000-41-00-4100 State Income Tax State income taxes are much higher than we anticipated, and much higher than the IML estimated. We are on pace for a$1.55 million annual amount. Page 1 of 4 01-000-42-00-4200 Liquor Licenses Liquor license renewal letters are not sent out until March, and are due by the end of April. 01-000-43-00-4310 Traffic fines 01-000-43-00-4325 Police Tows Both of these police revenues are under historical averages. 01-000-45-00-4500 Investment Earnings Investment earnings are up due to the positive cash position of the General Fund and because of our use of the IMET accounts. O1-000-48-00-4850 Miscellaneous income The $115,000 in December represents the payment by Fox Moraine for litigation settlement. General Fund Expenses All expenses, all departments While there are four calendar months left in the fiscal year, we are projecting that all departments will be under budget again in FY 13. All Retirement plan contribution line-items, all departments The City opted for a phase-in rate for IMRF contributions a few years ago, which created a $20,000 OPEB liability that was accruing interest over time. Rob and I decided to pay this amount down this year, eliminating interest in future years but resulting in a slight overage in these line-items this year. All health, dental, and vision insurance line-items, all departments The City budgeted for 10% insurance increases across the board, and actual renewal figures for this year came in at 6%, so any overage in percentages in the line-items are temporary and caused by the timing of payments. All gasoline line-items, all departments We have a more detailed tracking method this year for coding gasoline purchases to individual departments. The budgeted amounts for each department were our best guess at the start of the fiscal year for how the individual departments spend money. Some of our department estimates have been more accurate than others,but the aggregate totals are in-line with our overall estimates. 01-210-54-00-5411 Police Commission Page 2 of 4 The Police Commission is over budget for the year due to unexpected training and testing costs related to filling vacant positions. 01-220-54-00-5459 Inspections The City has not had to outsource any inspections this year, resulting in significant savings. Some of the money planned for inspections was used to offset the purchase of the plotter in the item below. 01-220-56-00-5635 Computer Equipment & Software As stated above, the Community Development Department did an analysis of outsourced printing costs vs. purchasing a large-format plotter and decided to purchase the plotter. The overage in this line-item is offset by the savings in the inspections line-item above. 01-540-54-00-5441 Garbage Srvcs— Sr Subsidy 01-540-54-00-5442 Garbage Services The amounts shown for the fiscal year represent half of the total billings for the year. There were two invoices paid in August, simply because of the timing of when the invoices were processed. 01-640-54-00-5465 Engineering Services The overage for this line-item is offset by developer reimbursements,which are coded to the engineering reimbursement line-item in the general fund revenue section. 01-640-54-00-5492 Sales Tax Rebate The amounts shown in this line-item represent only '/4 of the total planned reimbursements for the year. The second reimbursement amount will be processed and shown in January or February. 01-640-70-00-7799 Contingencies There have been no authorized contingencies during this fiscal year. MFT Fund 15-155-56-00-5618 Salt The City's minimum salt purchase invoice was coded and processed on the Jan 8ffi bill list for $53,301 and just under 1000 tons of salt The City already has 1000 tons of salt in storage, leftover from last year's mild winter. An average year's usage is about 2000 tons of salt. Given the already mild winter, our minimum purchase and last year's leftover amounts may be enough to get us through the winter. In a scenario where there was mild winter the rest of this year, the City would be able to proportionately reduce our order next year. Page 3 of 4 Police Capital Fund The fiscal year-to-date budget deficit in this fund was an explicit decision by the City Council to spend down impact fees and weather warning siren fees. Since this decision was made after the budget was approved,we will likely have to go through and amend the budget to reflect this decision. City-wide Capital 23-230-60-00-6015 Road Resurfacing There are no planned road resurfacing projects in FY 13, but we do expect to utilize these funds in the early part of FY 14. Water Fund 51-510-75-00-7502 Grande Reserve Court Order The City made the final payment on this obligation in November 2012. Sewer Fund 52-000-44-00-4457 SW Connection Fees—Rob Roy The City received the final disbursement of prepaid connection fees from Pulte/Centex in November 2012. 52-520-75-00-7500 Lennar—Raintree Swr Recapture 52-520-75-00-7501 Windett Ridge— Sewer Recapture We have placed an administrative hold on any further disbursements of these amounts, while we study the agreements related to each item. Page 4 of 4 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) ofFiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budgct GENERAL FUND REVENUES 01-000-40-00-4000 PROPERTY TAXES-CORPORATE LEVY 325,574 811,918 30,493 139,583 873,875 53,323 42,041 - 2,276,807 2,288,133 99.51% 01-000-40-00-4010 PROPERTY TAXES-POLICE PENSION 62,734 156,446 5,876 26,896 168,384 10,275 8,101 - 438,711 413,354 106.13% 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 228,266 212,170 209,444 207,616 1,658,656 2,325,000 71.34% 01-000-40-00-4035 NON-HOME RULE SALES TAX 127,336 161,729 154,035 170,425 178,724 162,530 160,592 161,337 1,276,709 1,500,000 85.11% 01-000-40-00-4040 ELECTRIC UTILITY TAX - 147,598 - - 144,395 - - 172,660 464,653 603,432 77.00% 01-000-40-00-4041 NATURAL GAS UTILITY TAX - 65,896 - - 26,177 - - 28,014 120,086 296,514 40.50% 01-000-40-00-4043 TELECOMMUNICATIONS TAX 39,153 49,552 39,941 40,944 40,657 39,521 41,467 39,166 330,401 490,000 67.43% 01-000-40-00-4044 TELEPHONE UTILITY TAX 1,422 1,400 1,360 1,345 1,328 1,309 1,290 1,253 10,707 23,500 45.56% 01-000-40-00-4045 CABLE FRANCHISE FEES 51,537 - - 53,038 - 10,346 42,851 - 157,771 230,000 68.60% 01-000-40-00-4050 HOTEL TAX 3,893 4,663 6,045 6,559 5,368 5,756 4,559 4,142 40,985 50,000 81.97% 01-000-40-00-4060 AMUSEMENT TAX 2,097 7,549 458 929 104,164 27,579 1,713 511 145,000 134,000 108.21% 01-000-40-00-4065 ADMISSIONS TAX - - - - - 119,199 - - 119,199 104,500 114.07% 01-000-40-00-4070 BUSINESS DISTRICT TAX 20,290 28,833 22,647 24,613 28,085 21889 23,544 25,954 196,853 300,000 65.62% 01-000-40-00-4075 AUTO RENTAL TAX 838 748 773 688 972 873 978 675 6,546 10,000 65.46% 01-000-40-00-4080 PARA-MUTUEL TAX - - - 314 - - - - 314 - 0.00% Intergovernmental 1� 01-000-41-00-4100 STATE INCOME TAX 263,968 94,310 146,433 212,616 111,784 143,547 90,077 89,349 1,152,084 1,320,000 87.28% 01-000-41-00-4105 LOCAL USE TAX 17,811 22,020 20,307 21,234 23,741 19,619 21,905 22,442 169,078 242,400 69.75% 01-000-41-00-4110 ROAD&BRIDGE TAX 26,133 59,409 2,217 11,285 63,384 3,457 2,591 - 168,477 170,000 99.10% 01-000-41-00-4120 PERSONAL PROPERTY TAX 2,230 - 2,881 348 - 2,193 - 839 8,491 16,000 53.07% 01-000-41-00-4160 FEDERAL GRANTS 1,107 - 7,941 - 246 1,513 10,807 9,200 117.46% 01-000-41-00-4170 STATE GRANTS - - - - - - - 0.00% 01-000-41-00-4182 MISC INTERGOVERNMENTAL - 2,000 0.00% 1 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 - ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget Licenses&Permits 01-000-42-00-4200 LIQUOR LICENSE 1,773 - 625 200 (1,119) 100 850 2,429 40,000 6.07% 01-000-42-00-4205 OTHER LICENSES&PERMITS 60 232 - - 263 - - 38 592 2,700 21.93% 01-000-42-00-4210 BUILDING PERMITS 15,853 17,748 8,896 12,572 14,623 5,787 11,511 10,610 97,599 126,600 77.09% Fines&Forfeits 01-000-43-00-4310 TRAFFIC FINES 4,338 4,499 5,711 5,687 4,661 3,364 4,814 4,483 37,557 95,000 39.53% 01-000-43-00-4320 ADMINISTRATIVE ADJUDICATION 1,580 3,096 1,944 2,157 3,481 4,601 4,595 3,809 25,263 26,000 97.16% 01-000-43-00-4323 OFFENDER REGISTRATION FEES 5 30 30 25 - - 55 - 145 500 29.00% 01-000-43-00-4325 POLICE TOWS 3,500 3,000 9,500 7,375 4,000 5,000 6,000 4,500 42,875 80,000 53.59% Charges for Service 01-000-44-00-4400 GARBAGE SURCHARGE (15) 201,224 220 180,008 (134) 160,386 416 160,521 702,627 1,021,784 68.76% 01-000-44-00-4405 COLLECTION FEE-YBSD - - - - - - - - - 151,500 0.00% 01-000-44-00-4407 LATE PMT PENALTIES-GARBAGE 14 4,022 20 3,937 7 3,790 (6) 3,240 15,024 - 0.00% 01-000-44-00-4474 POLICE SPECIAL DETAIL - - - - - 100 - - 100 5,000 2.00% Investment Earnings 01-000-45-00-4500 INVESTMENT EARNINGS 584 641 762 322 388 654 674 685 4,710 3,100 151.93% Reimbursements 01-000-46-00-4601 REIMB-LEGAL EXPENSES 1,100 - 1,096 934 2,165 1,760 1,451 60 8,566 - 0.00% 01-000-46-00-4604 REIMB-ENGINEERING EXPENSES 41,145 945 5,283 (31,617) 979 2,501 1,928 2,382 23,545 - 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 3,861 4,822 5,782 4,822 39,498 60,398 65.40% 01-000-46-00-4670 REIMB-EMP INS CONTRIBUTIONS 5,128 5,200 5,315 6,063 5,387 6,357 5,634 5,651 44,735 61,295 72.98% 01-000-46-00-4671 REIMB-LIFE INSURANCE 181 181 207 190 190 190 182 182 1,501 1,699 88.37% 01-000-46-00-4680 REIMB-LIABILITY INSURANCE 6,608 1,302 - 1,514 4,514 15,672 - - 29,610 5,000 592.21% 01-000-46-00-4681 REIMB-WORKERS COMP 25,557 - - - - - - 25,557 - 0.00% 01-000-46-00-4685 REIMB-CABLE CONSORTIUM 18,128 - - - - - 17,243 - 35,371 40,000 88.43% 01-000-46-00-4690 REIMB-MISCELLANEOUS 1,453 432 165 2,171 223 489 1,554 429 6,915 4,000 172.88% 2 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %ofFiscal Year 8% 17% 25% 33% 42% 50% 58% 07% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 Jun e-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget Other Financing Sources 01-000-48-00-4820 RENTAL INCOME 875 725 545 560 720 500 500 500 4,925 8,000 61.56% 01-000-48-00-4850 MISCELLANEOUS INCOME - - - 2 - 144 20 115,018 115,183 3,000 3839.45% TOTAL REVENUES:GENERAL FUND 1,256,362 2,068,410 676,269 1,154,943 2,044,832 1,049,825 713,604 1,073,250 10,037,496 12,311,109 81.53% ADMINISTRATION EXPENDITURES Salaries& Wages 01-110-50-00-5001 SALARIES-MAYOR 825 725 825 725 825 825 860 860 6,470 11,000 58.82% 01-110-50-00-5002 SALARIES-LIQUOR COMM 83 83 83 83 83 83 83 83 667 1,000 66.67% 01-110-50-00-5003 SALARIES-CITY CLERK 742 742 642 642 642 742 642 677 5,468 9,000 60.76% 01-110-50-00-5004 SALARIES-CITY TREASURER 500 500 300 500 300 300 300 300 3,000 6,500 46.15% 01-110-50-00-5005 SALARIES-ALDERMAN 4,000 3,800 3,900 4,000 3,900 4,000 4,080 4,245 31,925 50,320 63.44% 01-110-50-00-5010 SALARIES-ADMINISTRATION 18,304 19,627 19,362 30,671 19,446 22.571 22,065 20,626 172,673 255,000 67.71% 01-110-50-00-5020 OVERTIME - - - - - - - - - 575 0.00% Benefits MEL 01-110-52-00-5212 RETIREMENT PLAN CONTRIBUTION 2,222 2,330 2,199 3,113 2,160 2,460 2,409 4,221 21,114 28,383 74.39% 01-110-52-00-5214 FICA CONTRIBUTION 1,695 1,773 1,745 2,595 1,770 2,024 1,985 1,889 15,475 22,500 68.78% 01-110-52-00-5216 GROUP HEALTH INSURANCE 8,798 5,410 5,134 5,984 9,511 4,787 1,136 10,630 51,390 72,456 70.93% 01-110-52-00-5222 GROUP LIFE INSURANCE 29 50 66 48 48 48 48 48 387 614 62.96% 01-110-52-00-5223 GROUP DENTAL INSURANCE 386 430 408 408 816 408 - 969 3,824 5,096 75.05% 01-110-52-00-5224 VISION INSURANCE 44 44 44 44 44 44 44 54 365 586 62.27% 01-110-52-00-5235 ELECTED OFFICIAL-GROUP HEALTH INS 9,789 10,505 10,291 8,569 10,970 6,198 475 13,690 70,486 133,917 52.63% 01-110-52-00-5236 ELECTED OFFICIAL-GROUP LIFE INSURANCE 44 70 57 57 57 57 57 57 455 1,043 43.60% 01-110-52-00-5237 ELECTED OFFICIAL-DENTAL INSURANCE 758 846 802 547 966 547 - 1,094 51561 10,008 55.56% 01-110-52-00-5238 ELECTED OFFICIAL-VISION INSURANCE 86 86 86 72 59 59 59 59 563 1,129 49.85% Contractual Services Em 01-110-54-00-5412 TRAINING&CONFERENCES - - - - 99 1,323 1,470 105 2,997 3,000 99.89% 01-110-54-00-5415 TRAVEL&LODGING - 31 28 339 322 - 5,135 35 5,890 6,000 98.16% 01-110-54-00-5426 PUBLISHING&ADVERTISING - 71 - - 464 87 621 1,000 62.09% 3 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %ofFiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 Jul e-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget 01-110-54-00-5430 PRINTING&DUPLICATION - 441 660 986 320 403 - 338 31149 6,750 46.65% 01-110-54-00-5440 TELECOMMUNICATIONS - 1,902 843 2,940 140 1,668 1,596 1,608 10,697 15,000 71.32% 01-110-54-00-5448 FILING FEES - 39 - - 61 - - - 100 500 20.00% 01-110-54-00-5451 CODIFICATION - - - 1,322 - - - 1,322 8,000 16.53% 01-110-54-00-5452 POSTAGE&SHIPPING - - 113 185 - 1,061 (2,274) 60 (854) 14,000 -6.10% 01-110-54-00-5460 DUES&SUBSCRIPTIONS 8,702 1,036 155 592 90 - 1,226 - 11,801 16,600 71.09% 01-110-54-00-5462 PROFESSIONAL SERVICES 541 678 679 1,545 639 592 445 413 5,532 20,000 27.66% 01-110-54-00-5473 KENDALL COUNTY PARATRANSIT - - - - - - 11,775 - 11,775 30,000 39.25% 01-110-54-00-5480 UTILITIES - 22 - - 2,639 734 1,098 394 4,887 23,100 21.15% 01-110-54-00-5485 RENTAL&LEASE PURCHASE 143 143 143 143 143 143 174 174 1,207 1,900 63.52% 01-110-54-00-5488 OFFICE CLEANING - 1,196 1,196 1,196 1,196 1,196 1,196 1,196 8372 14,400 58.14% Supplies 01-110-56-00-5610 OFFICE SUPPLIES 1,229 557 246 261 223 172 545 342 3,575 12,000 29.79% 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 57,470 52,444 57,094 64,255 460,893 782,327 58.91% FINANCE EXPENDITURES Salaries&Wages 01-120-50-00-5010 SALARIES&WAGES 12,991 14,152 13,295 20,089 13,392 13,392 13,392 13,392 114,096 185,000 61.67% Benefits 01-120-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,281 1,393 1,311 1,965 15320 1,320 1,320 2,442 12,352 18,659 66.20% 01-120-52-00-5214 FICA CONTRIBUTION 985 1,074 1,009 1,519 1,016 1,016 1,016 1,016 8,652 13,005 66.53%° 01-120-52-00-5216 GROUP HEALTH INSURANCE 2,332 2,286 1,873 2,867 2,966 1,636 300 2,966 17,225 26,472 65.07% 01-120-52-00-5222 GROUP LIFE INSURANCE 22 38 30 30 30 30 30 30 238 461 51.64% 01-120-52-00-5223 DENTAL INSURANCE 241 269 255 255 510 255 - 510 2,296 3,182 72.15% 01-120-52-00-5224 VISION INSURANCE 27 27 27 27 27 27 27 27 216 356 60.63% Contractual Services 01-120-54-00-5412 TRAINING&CONFERENCES 440 155 - - 285 - (30) 285 1,135 2,000 56.75% 4 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %ofFiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget 01-120-54-00-5414 AUDITING SERVICES - - 28,000 3,000 - 31,000 36,000 86.11% 01-120-54-00-5415 TRAVEL&LODGING - 18 71 39 - 70 197 1,000 19.74% 01-120-54-00-5430 PRINTING&DUPLICATING - - - - 271 271 500 54.10% 01-120-54-00-5440 TELECOMMUNICATIONS - 45 45 95 95 92 88 88 547 600 91.18% 01-120-54-00-5452 POSTAGE&SHIPPING - - - 337 - 337 500 67.47% 01-120-54-00-5460 DUES&SUBSCRIPTIONS 80 - 35 - - - - 170 285 850 33.53% 01-120-54-00-5462 PROFESSIONAL SERVICES - 572 2,723 474 360 156 1,395 671 6,352 40,000 15.88% 01-120-54-00-5485 RENTAL&LEASE PURCHASE 143 143 143 143 143 143 140 140 1,137 4,900 23.21% 01-120-54-00-5495 OUTSIDE REPAIR&MAINTENANCE - - - - - - - - - 1,800 0.00% Supplies dommi 01-120-56-00-5610 OFFICE SUPPLIES 273 11 29 482 87 56 937 2,500 37.48% 01-120-56-00-5630 SMALL TOOLS&EQUIPMENT - - 86 86 250 34.32% 01-120-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - - - - - - - 2,500 0.00% TOTAL EXPENDITURES:FINANCE 18,815 20,183 20,846 27,946 48,268 18,154 21,070 22,077 197,359 340,535 57.96% POLICE EXPENDITURES Salaries&Wages 01-210-50-00-5010 SALARIES-POLICE OFFICERS 87,792 92,359 89,850 141,646 93,785 72,530 97,200 99,977 775,138 1,261,000 61.47% 01-210-50-00-5011 SALARIES-POLICE CHIEF&DEPUTIES 21,248 24,183 21,329 33,243 21,329 55,917 14,680 16,680 208,608 317,000 65.81% 01-210-50-00-5012 SALARIES-SERGEANTS 22,788 23,286 22,935 34,182 23,359 54,459 31,345 34,862 247,216 430,000 57.49% 01-210-50-00-5013 SALARIES-POLICE CLERKS 9,434 10,161 9,567 15,321 9,480 7,552 9,221 9,221 79,958 135,000 59.23% 01-210-50-00-5014 SALARIES-CROSSING GUARD 2,110 844 - 726 1,915 2,110 2,005 1,899 11,609 20,000 58.04% 01-210-50-00-5015 PART-TIME SALARIES 2,017 3,614 3,584 6,250 5,075 6,540 4,373 3,967 35,419 52,500 67.47% 01-210-50-00-5020 OVERTIME 5,429 10,280 11,348 7,751 8,627 13,203 8,326 8,711 73,676 90,000 81.86% Benefits 01-210-52-00-5212 RETIREMENT PLAN CONTRIBUTION 884 950 889 1,430 889 889 889 1,661 81480 15,818 53.61% 01-210-52-00-5213 EMPLOYER CONTRI-POL PEN 62,734 156,446 5,876 26,896 168,384 10,275 8,101 - 438,711 413,354 106.13% F-210-52-00-5214 FICA CONTRIBUTION 11,035 12,089 11,613 17,577 11,981 15,693 12,332 12,957 105,277 175,000 60.16% 5 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget 01-210-52-00-5216 GROUP HEALTH INSURANCE 33,174 32,961 30,202 30,180 62,214 32,752 10,649 60,377 292,509 517,950 56.47% 01-210-52-00-5222 GROUP LIFE INSURANCE 203 581 400 394 394 394 402 368 3,136 5,635 55.65% 01-210-52-00-5223 DENTAL INSURANCE 2,474 2,939 2,706 2,706 5,566 2,948 - 5,691 25,031 37,428 66.88% 01-210-52-00-5224 VISION INSURANCE 283 301 319 265 306 311 306 315 2,406 4,272 56.33% Contractual Services r T 01-210-54-00-5410 TUITION REIMBURSEMENT - - - 2,800 0.00% 01-210-54-00-5411 POLICE COMMISSION 500 625 821 - - 816 659 3,987 7,407 4,000 185.18% 01-210-54-00-5412 TRAINING&CONFERENCES 2,250 961 245 225 3,032 - 4,650 - 11,363 15,000 75.75% 01-210-54-00-5415 TRAVEL&LODGING 39 201 376 33 - 45 984 430 2,108 10,000 21.08% 01-210-54-00-5426 PUBLISHING&ADVERTISING - - - - - - - - - 200 0.00% 01-210-54-00-5430 PRINTING&DUPLICATING 82 692 (504) 2,109 214 76 95 2,765 4,500 61.44% 01-210-54-00-5440 TELECOMMUNICATIONS 44 2,926 993 3,261 1,728 2,190 2,063 2,012 15,218 36,500 41.69% 01-210-54-00-5452 POSTAGE&SHIPPING - 18 - - 49 614 - 681 3,000 22.69% 01-210-54-00-5460 DUES&SUBSCRIPTIONS - 50 50 (50) - - - 85 135 1,350 10.00% 01-210-54-00-5462 PROFESSIONAL SERVICES 333 184 100 3,691 113 324 1,010 550 6,305 5,000 126.10% 01-210-54-00-5466 LEGAL SERVICES - - - - - - - - - 20,000 0.00% 01-210-54-00-5467 ADJUDICATION SERVICES 858 2,380 1,077 1,078 1,475 1,907 1,475 10,250 20,000 51.25% 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 - 6,660 7,000 95.14% 01-210-54-00-5485 RENTAL&LEASE PURCHASE 277 352 352 352 352 352 532 532 3,101 4,500 68.91% 01-210-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 938 7,639 2,907 3,727 5,780 9,970 4,117 2,152 37,230 61,000 61.03% Supplies 01-210-56-00-5600 WEARING APPAREL 67 1,107 535 2,575 1,294 3,136 1,350 103 10,167 16,000 63.54% 01-210-56-00-5610 OFFICE SUPPLIES - 153 260 661 363 656 1,679 - 3,772 4,000 94.31% 01-210-56-00-5620 OPERATING SUPPLIES - 680 595 71 1,405 780 589 903 5,023 8,000 62.790 01-210-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - 163 2,499 - - - 300 - 2,962 7,000 42.32% 01-210-56-00-5640 REPAIR&MAINTENANCE 16 358 345 62 4,732 - 161 5,674 12,250 46.31% 6 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %ofFiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget 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 6,084 10,145 7,373 5,265 49,557 90,950 54.49% 01-210-56-00-5696 AMMUNITION - 207 - - - - - - 207 2,000 10.35% TOTAL EXPENDITURES:POLICE 266,070 397,340 233,811 350,570 436,706 310,459 231,060 274,434 2,500,449 3,840,577 65.11% COMMUNITY DEVELOPMENT EXPENDITURES Salaries&Wages _ 01-220-50-00-5010 SALARIES&WAGES 14,236 14,435 15,373 23,318 8,753 14,210 14,210 14,210 118,743 195,000 60.89% 01-220-50-00-5015 PART-TIME SALARIES - - - - 7,168 1,835 1,309 798 11,110 53,000 20.96% Benefits ■ f 01-220-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,306 1,259 1,349 2,054 1,370 1,370 1,370 2,511 12,588 26,227 48.00% 01-220-52-00-5214 FICA CONTRIBUTION 1,050 1,065 1,137 1,731 1,174 1,183 1,143 1,104 9,586 19,000 50.45% 01-220-52-00-5216 GROUP HEALTH INSURANCE 3,454 4,695 3,254 2,789 6,856 3,212 - 7,508 31,768 59,499 53.39% 01-220-52-00-5222 GROUP LIFE INSURANCE 15 56 35 45 45 45 45 45 331 461 71.74% 01-220-52-00-5223 DENTAL INSURANCE 241 269 255 255 621 292 584 2,517 4,139 60.81% 01-220-52-00-5224 VISION INSURANCE 27 27 - 63 32 32 32 32 243 471 51.67% Contractual Services 01-220-54-00-5412 TRAINING&CONFERENCES 685 79 220 984 1,500 65.60% 01-220-54-00-5415 TRAVEL&LODGING - - 342 - 342 1,000 34.21% 01-220-54-00-5426 PUBLISHING&ADVERTISING - 94 - 24 - - - - 118 500 23.68% 01-220-54-00-5430 PRINTING&DUPLICATING - 119 385 223 76 - 108 51 961 4,250 22.61% 01-220-54-00-5440 TELECOMMUNICATIONS 151 153 189 372 190 189 188 1,432 1,500 95.45% 01-220-54-00-5452 POSTAGE&SHIPPING - - - - - 760 - 760 500 152.01% 01-220-54-00-5459 INSPECTIONS - - - - - - 25,000 0.00% 01-220-54-00-5460 DUES&SUBSCRIPTIONS 422 1,786 470 - 2,678 1,500 178.55% 01-220-54-00-5462 PROFESSIONAL SERVICES - 3,600 1,032 - 139 306 5,076 6,000 84.61% 01-220-54-00-5466 LEGAL SERVICES 366 618 78 808 - 1,869 2,000 93.44% 7 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %ofFiscal Year 8% 177 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget 01-220-54-00-5485 RENTAL&LEASE PURCHASE 273 273 273 273 273 273 217 217 2,072 3,600 57.54% 01-220-54-00-5486 ECONOMIC DEVELOPMENT - - - - - - - - - 45,000 0.00% 01-220-56-00-5610 OFFICE SUPPLIES 34 15 116 9 - 57 33 265 500 53.03% 01-220-56-00-5620 OPERATING SUPPLIES 1,282 - 345 (14) 21 1,635 3,000 54.50% 01-220-56-00-5630 SMALL TOOLS&EQUIPMENT - 4 (4) - - 28 33 61 125 48.40% 01-220-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - 8,499 - 8,499 3,500 242.83% 01-220-56-00-5645 BOOKS&PUBLICATIONS - - - - - 70 70 500 14.00% 01-220-56-00-5695 GASOLINE - 172 262 398 - 747 328 92 1,999 3,654 54.71% TOTAL EXPENDITURES:COMMUNITY DEVELP 21,058 27,877 25,915 32,627 27,093 23,874 29,261 28,000 215,706 461,426 46.75% PUBLIC WORKS-STREET OPERATIONS EXPENDITURES Salaries& Wages 01-410-50-00-5010 SALARIES&WAGES 19,701 20,818 19,822 30,914 20,061 20,061 20,061 20,061 171,500 280,000 61.25% 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 1,934 1,934 1,934 3,611 18,300 31,753 57.63% 01-410-52-00-5214 FICA CONTRIBUTION 1,470 1,538 1,514 2,304 1,480 1,480 1,480 1,480 12,746 23,500 54.24% 01-410-52-00-5216 GROUP HEALTH INSURANCE 6,729 12,250 6,595 6,595 13,290 6,682 (19) 13,234 65,358 83,361 78.40% 01-410-52-00-5222 GROUP LIFE INSURANCE 36 179 109 109 109 109 109 109 872 11317 66.23% 01-410-52-00-5223 DENTAL INSURANCE 559 623 591 591 1,182 591 - 1,182 5,319 6,826 77.92% 01-410-52-00-5224 VISION INSURNCE 59 59 59 59 59 59 59 59 468 773 60.60% Contractual Services 01-410-54-00-5412 TRAINING&CONFERENCES - 705 - - - - - - 705 2,000 35.25% 01-410-54-00-5440 TELECOMMUNICATIONS 212 216 213 288 183 183 183 1,477 4,020 36.73% 01-410-54-00-5446 PROPERTY&BUILDING MAINT SERVICES 25 1,269 216 - 543 829 3,980 769 7,633 20,000 38.16% 01-410-54-00-5454 SIDEWALK PROGRAM - - 110 - 110 4,000 2.76% 01-410-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 55650 270 16,255 20,000 81.28% 8 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 0 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget 01-410-54-00-5462 PROFESSIONAL SERVICES - 600 26 7 - 87 617 11337 1,000 133.73% 01-410-54-00-5480 UTILITIES - 2,672 2,562 2,824 2,791 2,792 2,999 3,091 19,730 90,000 21.92% 01-410-54-00-5485 RENTAL&LEASE PURCHASE 33 33 248 33 33 33 417 42 872 1,000 87.230yo 01-410-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 126 1,365 405 3,641 1,017 1,814 4,576 9,543 22,488 35,000 64.250yo Supplies 01-410-56-00-5600 WEARING APPAREL 39 275 66 167 355 382 466 79 1,829 4,200 43.55% 01-410-56-00-5620 OPERATING SUPPLIES 106 116 197 196 560 476 682 625 2,957 9,500 31.13% 01-410-56-00-5630 SMALL TOOLS&EQUIPMENT - 11 73 - 169 99 - - 352 1,750 20.14% 01-410-56-00-5640 REPAIR&MAINTENANCE - 2,614 653 2,336 1,158 1,265 6,251 1,887 16,164 36,500 44.28% 01-410-56-00-5656 PROPERTY&BUILDING MAINT SUPPLIES 173 51 61 37 347 113 5 - 788 20,000 3.94% 01-410-56-00-5695 GASOLINE - 1,891 1,843 2,006 1,390 3,079 2,181 1,534 13,924 15,952 87.29% TOTAL EXP:PUBLIC WORKS-STREET OPS 37,931 48,853 42,216 61,619 52,423 42,253 45,451 58,106 388,852 714,452 54.43% PW-HEALTH&SANITATION EXPENDITURES Contractual Services 01-540-54-00-5441 GARBAGE SRVCS-SR SUBSIDY - 13,100 - 26,363 11,030 11,210 10,978 - 72,680 153,216 47.44% 01-540-54-00-5442 GARBAGE SERVICES - 84,769 - 169,400 66,570 66,407 66,622 - 453,768 1,046,784 43.35% 01-540-54-00-5443 LEAF PICKUP - - - - - - - - - 6,000 0.00% TOTAL EXPENDITURES:HEALTH&SANITATION - 97,868 - 195,763 77,600 77,617 77,600 - 526,448 1,206,000 43.65% ADMINISTRATIVE SERVICES EXPENDITURES Salaries&Wages 01-640-50-00-5092 POLICE SPECIAL DETAIL WAGES - - 100 100 5,000 2.00% Benefits 01-640-52-00-5212 RETIREMENT PLAN CONTRIBUTION-E1u _ _ - - - 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 - - 1,325 - 16,558 47,143 35.12% 01-640-52-00-5231 LIABILITY INSURANCE 69,484 15,879 17,119 15,879 7,406 7,406 - 10,196 143,369 332,256 43.15% 01-640-52-00-5240 RETIREES-GROUP HEALTH INS 7,269 9,504 6,680 9,078 11,700 6,352 406 11,994 62,983 104,458 60.30% 9 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %ofFiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget 01-640-52-00-5241 RETIREES-DENTAL INSURANCE 397 440 419 507 750 419 838 3,769 5,246 71.84% 01-640-52-00-5242 RETIREES-VISION INSURANCE 48 48 48 48 48 48 48 48 386 636 60.62% 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 2,790 9,970 9,273 23,140 75,387 140,000 53.85% 01-640-54-00-5456 CORPORATE COUNSEL - 6,562 - 10,234 7,698 6,438 7,090 8,308 46,328 130,000 35.64% 01-640-54-00-5461 LITIGATION COUNSEL - - 12,607 4,333 9,235 - 7,866 2,420 36,462 60,000 60.77% 01-640-54-00-5462 PROFESSIONAL SERVICES 450 - - 1 - - - - 451 500 90.20% 01-640-54-00-5463 SPECIAL COUNSEL - 225 450 1,887 171 465 - - 3,197 25,000 12.79% 01-640-54-00-5465 ENGINEERING SERVICES 35,010 - 37,148 33,423 39,816 43,496 42,749 231,640 180,000 128.69% 01-640-54-00-5475 CABLE CONSORTIUM FEE - - - 17,243 - - - 17,243 85,000 20.29% 01-640-54-00-5481 HOTEL TAX REBATE - 4,179 5,441 5,903 4,831 5,180 4,104 29,637 45,000 65.86% 01-640-54-00-5491 CITY PROPERTY TAX REBATE - - - - 1,196 - - 1,196 1,500 79.74% 01-640-54-00-5492 SALES TAX REBATE - - - 367 179,637 - - - 180,004 824,000 21.85% 01-640-54-00-5493 BUSINESS DISTRICT REBATE (28,833) 28,833 22,647 24,613 28,085 22,889 23,544 25,954 147,730 300,000 49.24% 01-640-54-00-5494 ADMISSIONS TAX REBATE - - - - - - - - - 104,500 0.000 Supplies 01-640-56-00-5625 REIMBURSEABLE REPAIRS - 6,600 802 5,185 12,588 5,000 251.75% Contingencies fi 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 34,944 34,944 34,944 34,944 279,555 419,332 66.67% 01-640-99-00-9942 TRANSFER TO DEBT SERVICE 8,289 8,289 8,289 8,289 8,289 8,289 8,289 8,289 66,310 99,465 66.67% 01-640-99-00-9979 TRANSFER TO PARK&RECREATION 79,657 79,657 79,657 79,657 79,657 79,657 79,657 79,657 637,257 955,886 66.67% 01-640-99-00-9982 TRANSFER TO LIBRARY OPS 9,733 1,801 1,801 2,151 840 960 - 2,312 19,598 41,978 46.69% TOTAL EXPENDITURES:ADMIN SERVICES 195,274 232,427 211,556 240,047 427,818 230,290 219,794 254,951 2,012,156 4,034,550 49.87% 10 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget TOTAL FUND REVENUES 1,256,362 2,068,410 676,269 1,154,943 2,044,832 1,049,825 713,604 1,073,250 10,037,496 12,311,109 81.53% TOTAL FUND EXPENDITURES 598,067 877,614 584,349 976,210 1,127,379 755,091 681,330 701,823 6,301,862 11,379,867 55.38% FUND SURPLUS(DEFICIT) 658,295 1,190,796 91,920 178,733 917,453 294,734 32,275 371,427 3,735,633 931,242 FOX HILL SSA REVENUES 11-000-40-00-4011 PROPERTY TAXES-FOX HILL SSA 551 1,286 90 263 1,478 75 43 - 3,786 3,786 99.99% 11-000-45-00-4500 INVESTMENT EARNINGS 0 0 0 1 1 2 1 1 7 - 0.00% TOTAL REVENUES:FOX HILL SSA 551 1,286 91 264 1,479 77 44 1 3,793 3,786 100.18% FOX HILL SSA EXPENDITURES 11-111-54-00-5495 1 OUTSIDE REPAIR&MAINTENANCE 529 1,338 423 529 423 529 - 3,772 4,500 83.81% TOTAL FUND REVENUES 551 1,286 91 264 1,479 77 44 1 3,793 3,786 100.18% TOTAL FUND EXPENDITURES - 529 1,338 423 529 423 529 - 3,772 4,500 83.81% FUND SURPLUS(DEFICIT) 551 757 (1,248) (160) 950 (347) (485) 1 21 (714) SUNFLOWER SSA REVENUES 12-000-40-00-4012 PROPERTY TAXES-SUNFLOWER SSA 1,370 2,467 57 478 2,968 94 97 7,530 7,531 99.99% 12-000-45-00-4500 INVESTMENT EARNINGS 0 1 l 1 1 2 2 2 8 - 0.00% TOTAL REVENUES:SUNFLOWER SSA 1,370 2,467 58 479 2,968 96 98 2 7,538 7,531 100.10% 11 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget SUNFLOWER SSA EXPENDITURES 12-112-54-00-5495 1 OUTSIDE REPAIR&MAINTENANCE - 1,312 2,854 2,024 1,312 400 3,512 11,414 9,986 114.30% TOTAL FUND REVENUES 1,370 2,467 58 479 2,968 96 98 2 7,538 7,531 100.10% TOTAL FUND EXPENDITURES - 1,312 2,854 2,024 1,312 400 3,512 - 11,414 9,986 114.30% FUND SURPLUS(DEFICIT) 1,370 1,155 (2,796) (1,545) 1,656 (304) (3,414) 2 (3,876) (2,455) MOTOR FUEL TAX REVENUES 15-000-41-00-4112 MOTOR FUEL TAX 32,850 36,593 30,824 36,021 36,104 31,350 34,291 36,557 274,590 415,000 66.17% 15-000-41-00-4113 MFT HIGH GROWTH - - - - - - 39,164 - 39,164 39,197 99.92% 15-000-41-00-4172 ILLINOIS JOBS NOW - - - - 73,122 - - - 73,122 - 0.00% 15-000-45-00-4500 INVESTMENT EARNINGS 212 208 219 246 287 321 335 359 2,187 350 624.73% 15-000-46-00-4690 REIMB-MISCELLANEOUS - - - - - 110 148 - 257 - 0.00% TOTAL REVENUES:MOTOR FUEL TAX 33,063 36,801 31,043 36,267 109,513 31,781 73,938 36,915 389,320 454,547 85.65% MOTOR FUEL TAX EXPENDITURES Contractual Services 15-155-54-00-5438 SALT STORAGE - 7,500 - - 7,500 - 0.00% 15-155-56-00-5618 SALT - - - - - - - 231,000 0.00% 15-155-56-00-5619 SIGNS 106 175 1,077 110 386 - 1,853 35,000 5.29% 15-155-56-00-5632 PATCHING - - - - - - - 47,007 47,007 50,000 94.01% 15-155-56-00-5633 COLD PATCH - 1,647 2,465 - - - 4,113 11,660 35.27% 15-155-56-00-5634 HOTPATCH 2,901 3,402 1,939 1,392 692 10,327 14,300 72.21% Capital Outlay 15-155-60-00-6073 GAME FARM ROAD PROJECT 1,626 - 1,626 110,000 1.48% 15-155-60-00-6072 DOWNTOWN PARKING LOT 1,546 1,546 - 0.00% 15-155-60-00-6079 ROUTE 47 EXPANSION - 20,317 20,317 40,633 121,900 33.33% 12 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %ofFiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget TOTAL FUND REVENUES 33,063 36,801 31,043 36,267 109,513 31,781 73,938 36,915 389,320 454,547 85.65% TOTAL FUND EXPENDITURES - 106 4,723 5,868 3,016 30,945 1,078 68,870 114,605 573,860 19.97% FUND SURPLUS(DEFICIT) 33,063 36,695 26,320 30,399 106,497 836 72,860 (31,954) 274,715 1 (119,313) MUNICIPAL BUILDING REVENUES 16-000-42-00-4214 DEVELOPMENT FEES 900 450 300 450 300 2,059 900 150 5,509 5,250 104.93% 16-000-42-00-4216 BUILD PROGRAM PERMIT 300 300 600 - 900 600 450 - 31150 - 0.00% TOTAL REVENUES:MUNICIPAL BUILDING 1,200 750 900 450 1,200 2,659 1,350 150 8,659 5,250 164.93% MUNICIPAL BUILDING EXPENDITURES 16-160-54-00-5405 BUILD PROGRAM 300 300 600 - 900 1 600 450 - 3,150 1 - 0.00% TOTAL FUND REVENUES 1,200 750 900 450 1,200 2,659 1,350 150 8,659 5,250 164.93% TOTAL FUND EXPENDITURES 300 300 600 - 900 600 450 - 3,150 - 0.00% FUND SURPLUS(DEFICIT) 900 450 300 450 300 2,059 900 150 5,509 5,250 POLICE CAPITAL REVENUES Licenses&Permits - 20-000-42-00-4214 DEVELOPMENT FEES 2,250 3,409 1,800 900 2,400 2,100 2,250 150 15,259 10,500 145.32% 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 178 531 121 584 2,703 6,000 45.06% 20-000-43-00-4316 ELECTRONIC CITATION FEE 62 70 - 123 76 48 69 74 522 650 80.31% 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 5 8 5 4 35 50 70.58% 13 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 jwACTUALS BY MONTH(Cash Basis) of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION 1 May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET °/of Budget Miscellaneous 20-000-48-00-4880 SALE OF FIXED ASSETS - 200 - - - - - - 200 1,000 20.00% TOTAL REVENUES:POLICE CAPITAL 2,908 3,808 10,803 1,597 2,659 2,687 2,445 812 27,720 29,200 94.93% POLICE CAPITAL EXPENDITURES Contractual Services 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 - 32,719 2,715 100,190 20,000 500.95% 20-200-60-00-6070 VEHICLES 39,451 - - - - 39,451 25,000 157.81% TOTAL FUND REVENUES 2,908 3,808 10,803 1,597 2,659 2,687 2,445 812 27,720 29,200 94.93% TOTAL FUND EXPENDITURES 44,942 12,256 61,229 - - - 32,719 2,715 153,861 60,000 256.43% FUND SURPLUS(DEFICIT) (42,034) (8,448) (50,426) 1,597 2,659 2,687 (30,274) (1,904) (126,141) (30,800) PUBLIC WORKS CAPITAL REVENUES Licenses&Permits 21-000-42-00-4213 ENGINEERING CAPITAL FEE 700 400 600 300 800 600 600 - 4,000 6,500 61.54% 21-000-42-00-4214 DEVELOPMENT FEES 3,950 2,550 1,400 2,100 1,060 2,100 3,450 450 17,060 24,500 69.63% 21-000-42-00-4216 BUILD PROGRAM PERMIT 1,400 1,400 2,800 - 4,540 2,800 2,100 - 15,040 - 0.00% Charges for Service 21-000-44-00-4418 MOWING INCOME 1,690 526 1,274 (1,812) 579 1,509 1,866 - 5,632 20,000 28.16% Investment Earnings 21-000-45-00-4500 INVESTMENT EARNINGS 1 1 1 2 2 4 2 2 16 - 0.00% 21-000-48-00-4850 MISCELLANEOUS INCOME - - 766 - - 766 0.00% 14 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET 'GU of Budget Other Financing Uses 21-000-49-00-4922 TSFR FROM PARK&REC CAPITAL 208 208 208 208 208 208 208 208 1,667 2,500 66.67% TOTAL REVENUES:PW CAPITAL REVENUES 7,949 5,085 6,284 798 7,956 7,221 8,227 660 44,181 53,500 82.58% PUBLIC WORKS CAPITAL EXPENDITURES Contractual Services OR 21-211-54-00-5405 BUILD PROGRAM 1,400 1,400 2,800 - 4,540 2,800 2,100 - 15,040 - 0.00% 21-211-54-00-5448 FILING FEES - 49 - 343 637 - 245 588 1,862 6,000 31.03% 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% PW Building-185 Wolf Street 21-211-92-00-8000 PRINCIPAL PAYMENT 2,435 2,448 2,461 2,473 2,486 2,499 2,512 2,525 19,840 30,074 65.97% 21-211-92-00-8050 INTEREST PAYMENT 4,423 4,410 4,397 4,385 4,372 4,359 4,346 4,333 35,023 52,221 67.07% TOTAL FUND REVENUES 7,949 5,085 6,284 798 7,956 7,221 8,227 660 44,181 53,500 82.58% TOTAL FUND EXPENDITURES 8,258 8,307 9,658 7,201 12,035 9,658 9,203 7,446 71,765 169,795 42.27% FUND SURPLUS(DEFICIT) (308) (3,222) (3,374) (6,403) (4,079) (2,437) (976) (6,786) (27,585) (116,295) PARK&RECREATION CAPITAL REVENUES 22-000-42-00-4215 PARK CAPITAL FEES 850 1,000 400 300 300 - 2,850 3,250 87.69% 22-000-45-00-4500 INVESTMENT EARNINGS 38 36 37 41 44 45 45 49 336 250 134.43% 22-000-46-00-4690 REIMB-MISC - - - - - - 40,000 0.00% TOTAL REVENUES:PARK&RECREATION CAPITAL 888 1 36 37 1,041 444 345 345 49 3,186 43,500 1 7.32% PARK&RECREATION CAPITAL EXPENDITURES 22-222-60-00-6035 RAINTREE PARK - - - - - - 10,000 0.00% 22-222-60-00-6060 EQUIPMENT - 6,439 6,439 40,000 0.00% 15 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %ofFiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget 22-222-99-00-9921 TRANSFER TO PW CAPITAL 208 208 208 208 208 208 208 208 1,667 2,500 66.670 TOTAL FUND REVENUES 888 36 37 1,041 444 345 345 49 3,186 43,500 7.32% ]JL TOTAL FUND EXPENDITURES 208 208 208 208 208 6,647 208 208 8,106 52,500 15.44% FUND SURPLUS(DEFICIT) 680 (172) (171) 833 236 (6,302) 137 (159) (4,920) (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 - 1,750 (500) 500 2,250 20,000 11.25% 23-000-42-00-4216 BUILD PROGRAM PERMIT 5,640 5,640 11,280 1,920 11,280 8,460 - 44,220 - 0.00% 23-000-42-00-4222 ROAD CONTRIBUTION FEE - - - - - - - - 20,000 0.00% Investment Earnings 23-000-45-00-4500 INVESTMENT EARNINGS 14 15 16 22 24 30 26 27 174 - 0.00% MISCELLANEOUS 23-000-48-00-4880 SALE OF FIXED ASSETS - - - - - - - 5,000 5,000 - 0.00% Other Financing Sources 23-000-49-00-4901 TRANSFER FROM GENERAL 34,944 34,944 34,944 34,944 34,944 34,944 34,944 34,944 279,555 419,332 66.67% 23-000-49-00-4905 LOAN PROCEEDS - - - 600,000 0.00% TOTAL REVENUES:CITY-WIDE CAPITAL 40,599 40,599 46,740 34,966 36,888 48,005 42,930 40,472 331,199 1,303,732 25.40% CITY-WIDE CAPITAL EXPENDITURES Contractual Services 23-230-54-00-5405 BUILD PROGRAM 5,640 5,640 11,280 - 1,920 11,280 8,460 - 44,220 - 0.00% 23-230-54-00-5462 PROFESSIONAL SERVICES - - - 19,468 - 12,000 - - 31,468 100,000 31.47% 16 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET 'GU of Budget Capital Outlay 23-230-60-00-6015 ROAD RESURFACING - - - - - - - - 100,000 0.00% 23-230-60-00-6075 RIVER ROAD BRIDGE PROJECT - 4,032 - 4,262 - 4,374 2,101 1,990 16,759 600,000 2.79% 23-230-60-00-6092 SAFE ROUTE TO SCHOOL PROJECT 19,989 - 2,669 1,250 1,347 - - 25,255 231,000 10.93% 23-230-60-00-6094 ITEP KENNEDY RD BIKE TRAIL 2,940 10,621 13,561 9,500 142.75% TOTAL FUND REVENUES 40,599 40,599 46,740 34,966 36,888 48,005 42,930 40,472 331,199 1,303,732 25.40% TOTAL FUND EXPENDITURES 5,640 29,661 11,280 26,398 3,170 29,001 13,501 12,611 131,262 1,040,500 12.62% FUND SURPLUS(DEFICIT) 34,959 10,938 35,460 8,569 33,718 19,003 29,429 27,861 199,937 263,232 DEBT SERVICE REVENUES 42-000-40-00-4006 PROPERTY TAXES-2005A BOND 46,440 115,811 4,349 19,910 124,649 7,606 5,997 - 324,762 326,379 99.50% 42-000-42-00-4208 RECAPTURE FEES-WATER&SEWER 200 1,522 150 75 225 1,547 225 25 3,969 1,000 396.90% 42-000-45-00-4500 INVESTMENT EARNINGS 1 12 14 35 39 79 77 74 331 300 110.34% 42-000-49-00-4901 TRANSFER FROM GENERAL 8,289 8,289 8,289 8,289 8,289 8,289 8,289 8,289 66,310 99,465 66.67% TOTAL REVENUES:DEBT SERVICE 54,929 125,634 12,802 28,309 133,202 17,521 14,587 8,388 395,372 427,144 92.56% DEBT SERVICE EXPENDITURES 42-420-54-00-5498 PAYING AGENT FEES 214 375 - - - - - - 589 963 61.11% 2004C Bond 42-420-81-00-8000 PRINCIPAL PAYMENT - - - - - 95,000 95,000 95,000 100.00% 42-420-81-00-8050 INTEREST PAYMENT - 2,233 - - - - 2,233 4,465 4,465 100.00% 2005A Bond 42-420-82-00-8000 PRINCIPAL PAYMENT - - - - - 205,000 205,000 205,000 100.00% 42-420-82-00-8050 INTEREST PAYMENT - 60,689 - - 60,689 121,379 121,379 100.00% 2002 Fox Industrial Bond 42-420-98-00-8000 PRINCIPAL PAYMENT - - - 75,000 - 75,000 75,000 100.00% 42-420-98-00-8050 INTEREST PAYMENT 1,781 - - 1,781 3,563 3,563 99.99% 17 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %ofFiscat Year 8% 17% 25% 33% 42% 1 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget TOTAL FUND REVENUES 54,929 125,634 12,802 28,309 133,202 17,521 14,587 8,388 395,372 427,144 92.56% TOTAL FUND EXPENDITURES 1,995 63,296 - - - - 76,781 362,922 504,995 505,370 99.93% FUND SURPLUS(DEFICIT) 52,934 62,338 12,802 28,309 133,202 17,521 (62,194) (354,534) (109,622) (78,226) WATER FUND REVENUES Tares 51-000-40-00-4007 PROPERTY TAXES-2007A BOND 18,989 47,354 1,778 8,141 50,968 3,110 2,452 - 132,793 133,454 99.50% Licenses&Permits 51-000-42-00-4216 BUILD PROGRAM PERMIT 2,660 8,660 5,320 - 10,640 8,320 15,990 3,000 54,590 - 0.00% Charges for Service 1 51-000-44-00-4424 WATER SALES 1,111 322,220 8,325 440,159 (1,716) 313,085 2,248 260,136 1,345,568 1,699,871 79.16% 51-000-44-00-4425 BULK WATER SALES - - - 7,246 1,700 - 1,150 700 10,796 500 2159.29% 51-000-44-00-4426 LATE PMT PENALTIES-WATER 65 16,196 126 17,891 46 18,089 (24) 15,760 68,148 - 0.00% 51-000-44-00-4430 WATER METER SALES 3,513 1,940 4,340 1,455 3,395 2,910 2,910 - 20,463 26,250 77.95% 51-000-44-00-4440 WATER INFASTRUCTURE FEE 103 114,051 199 113,874 (174) 114,752 371 114,795 457,971 675,000 67.85% 51-000-44-00-4450 WATER CONNECTION FEE 10,350 4,060 2,660 3,990 5,330 3,360 8,090 4,400 42,240 126,250 33.46`% Investment Earnings 51-000-45-00-4500 INVESTMENT EARNINGS 44 68 78 180 195 227 244 252 1,287 300 429.15% Reimbursements 51-000-46-00-4670 REIMB-EMP INS CONTRIBUTIONS 750 709 669 669 795 204 750 750 5,295 7,225 73.29% 51-000-46-00-4671 REIMB-LIFE INSURANCE 26 12 12 12 12 12 12 12 114 241 47.19% 51-000-46-00-4690 REIMB-MISCELLANEOUS 99 - 25 50 - - - 19 194 - 0.00% IL 51-000-48-00-4820 RENTAL INCOME 6,191 2,111 4,391 4,391 4,391 4,391 4,427 A6,857 34,717 50,000 69.43% Other Financing Sources 51-000-49-00-4952 TRANSFER FROM SEWER 6,857 6,857 6,857 6,857 6,857 6,857 6,857 54,859 82,288 66.67% TOTAL REVENUES:WATER FUND 50,758 524,239 34,782 604,916 F 82,439 475,317 45,478 411,108 2,229,035 2,801,379 79.57% 18 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget WATER OPERATIONS EXPENSES Salaries& Wages 51-510-50-00-5010 SALARIES&WAGES 26,260 26,315 21,710 44,120 23,245 25,040 25,040 25,040 216,769 370,000 58.59% 51-510-50-00-5020 OVERTIME 1,255 259 309 595 316 31 793 1,168 4,725 12,000 39.37% Benefits ME_ mmmm_ 51-510-52-00-5212 RETIREMENT PLAN CONTRIBUTION 2,653 2,562 2,123 3,415 2,271 2,417 2,490 41688 22,618 39,852 56.76% 51-510-52-00-5214 FICA CONTRIBUTION 2,022 1,953 1,609 3,325 1,712 1,815 1,873 1,902 16,210 28,200 57.48% 51-510-52-00-5216 GROUP HEALTH INSURANCE 5,863 5,920 5,601 6,180 9,715 6,406 215 12,402 52,302 103,966 50.31% 51-510-52-00-5222 GROUP LIFE INSURANCE 47 102 84 59 52 62 69 69 546 1,210 45.14% 51-510-52-00-5223 DENTAL INSURANCE 456 507 482 521 804 558 - 1,042 4,370 7,201 60.68% 51-510-52-00-5224 VISION INSURANCE 58 58 58 58 49 67 53 62 463 829 55.88% 51-510-52-00-5230 UNEMPLOYMENT INSURANCE 1,346 - 455 - - 157 - 1,957 6,000 32.62% 51-510-52-00-5231 LIABILITY INSURANCE 6,769 1,552 1,552 1,552 724 724 - 996 13,869 32,462 42.72% Contractual Services 51-510-54-00-5405 BUILD PROGRAM 2,660 8,660 5,320 - 10,640 8,320 15,990 3,000 54,590 - 0.00% 51-510-54-00-5412 TRAINING&CONFERENCES - - 20 20 - - 40 - 80 2,000 4.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 295 295 295 - 1,530 14,000 10.93% 51-510-54-00-5430 PRINTING&DUPLICATING - 10 10 5 - - - 2 27 2,500 1.07% 51-510-54-00-5440 TELECOMMUNICATIONS - 3,008 361 3,117 545 1,932 1,907 1,793 12,664 24,500 51.69% 51-510-54-00-5445 TREATMENT FACILITY SERVICES 130 891 9,631 11,513 311 9,464 3,822 6,977 42,738 100,000 42.74% 51-510-54-00-5448 FILING FEES - 245 392 1,068 490 392 637 637 3,861 6,200 62.27% 51-510-54-00-5452 POSTAGE&SHIPPING - 3,770 81 2,471 - 2,519 621 2,414 11,875 22,000 53.98% 51-510-54-00-5460 DUES&SUBSCRIPTIONS 298 389 - - 21 - 20 - 728 1,250 58.22% 51-510-54-00-5462 PROFESSIONAL SERVICES 456 2,728 1,040 18 1,054 790 2,005 513 8,606 8,800 97.79% 51-510-54-00-5466 LEGAL SERVICES - - - - - - - - - 2,000 0.00% 51-510-54-00-5480 UTILITIES - 21,531 7,585 32,225 18,149 15,810 19,569 17,299 132,167 299,250 44.17% 19 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget 51-510-54-00-5483 JULIE SERVICES 24 - (24) - - 3,097 - 3,097 3,500 88.48% 51-510-54-00-5485 RENTAL&LEASE PURCHASE 33 33 33 33 33 33 42 42 282 1,000 28.20% 51-510-54-00-5495 OUTSIDE REPAIR&MAINTENANCE - 36 1,097 5,803 1,616 4,537 569 289 13,947 10,000 139.47% 51-510-54-00-5498 PAYING AGENT FEES 214 - 375 - - 375 - 963 1,600 60.19% Supplies 51-510-56-00-5600 WEARING APPAREL 39 88 fib 315 101 618 157 91 11476 4,000 36.89% 51-510-56-00-5620 OPERATING SUPPLIES 90 520 123 1,468 515 811 627 106 4,259 21,425 19.88% 51-510-56-00-5630 SMALL TOOLS&EQUIPMENT - 14 9 17 - 39 58 15 150 4,000 3.76% 51-510-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - 1,989 - (1,989) 104 - - - 104 6,000 1.74% 51-510-56-00-5638 TREATMENT FACILITY SUPPLIES 5,465 17,272 16,609 26,178 11,836 11,123 10,959 2,588 102,028 165,000 61.84% 51-510-56-00-5640 REPAIR&MAINTENANCE - 1,479 1,638 830 315 - 2,220 648 7,129 9,500 75.04% 51-510-56-00-5664 METERS&PARTS - 3,574 1,348 4,805 3,005 5,213 1,426 332 19,702 46,000 42.83% 51-510-56-00-5695 GASOLINE - 1,891 1,843 2,006 1,390 3,079 1,642 1,534 13,385 38,199 35.04% Capital Outlay 51-510-60-00-6060 EQUIPMENT - - - - - 16,000 0.00% 51-510-60-00-6079 ROUTE 47 EXPANSION - - - - - 21,516 - 21,516 43,031 116,000 37.10% Developer Commitments 51-510-75-00-7502 GRANDE RESERVE COURT ORDER 22,989 22,989 22,989 22,989 22,989 22,989 22,989 - 160,921 160,923 100.000,% 2007A Bond 51-510-83-00-8000 PRINCIPAL PAYMENT - - - - - - - 10,000 10,000 10,000 100.00% 51-510-83-00-8050 INTEREST PAYMENT - 61,727 - - - 61,727 123,454 123,454 100.00% 2002 Capital Appreciation Debt Certificates-] 51-510-85-00-8000 PRINCIPAL PAYMENT 365,000 - - - - 365,000 365,000 100.00% 2003 Debt Certificates 51-510-86-00-8050 INTEREST PAYMENT - 16,575 - 16,575 33,150 33,150 100.00% 2006A Refunding Debt Certificates 51-510-87-00-8000 PRINCIPAL PAYMENT - - - 355,000 355,000 355,000 100.00% 51-510-87-00-8050 INTEREST PAYMENT - 109,903 - - 109,903 219,806 219,806 100.000/( 20 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget 2005C Bond 51-510-88-00-8000 PRINCIPAL PAYMENT 90,000 90,000 90,000 100.00% 51-510-88-00-8050 INTEREST PAYMENT 37,288 - 37,288 74,575 74,575 100.00% IEPA Loan L17-156300 51-510-89-00-8000 PRINCIPAL PAYMENT - 43,604 - 43,604 87,754 49.69% 51-510-89-00-8050 INTEREST PAYMENT - 18,911 1 - - 18,911 37,277 50.73% TOTAL FUND REVENUES 50,758 524,239 34,782 604,916 82,439 475,317 45,478 411,108 2,229,035 2,801,379 79.57% TOTAL FUND EXPENSES 444,202 355,859 105,317 236,109 112,297 146,753 119,597 787,658 2,307,792 3,085,983 74.78% FUND SURPLUS(DEFICIT) (393,444) 168,379 (70,535) 368,807 (29,859) 328,564 (74,119) (376,550) (78,757) (284,604) SEWER FUND REVENUES Taxes 52-000-40-00-4009 PROPERTY TAXES-2004B BOND 37,543 93,624 3,516 16,096 100,768 6,149 4,848 - 262,543 263,850 99.50% Licenses&Permits 52-000-42-00-4216 BUILD PROGRAM PERMIT - 4,000 - - 2,000 2,000 8,000 2,000 18,000 - 0.00% Charges for Service ---A 52-000-44-00-4435 SEWER MAINTENANCE FEES 269 122,958 329 123,066 (143) 123,752 363 123,848 494,443 728,280 67.89% 52-000-44-00-4455 SW CONNECTION FEES-OPS 200 - - - - - (200) 200 200 5,100 3.92% 52-000-44-00-4456 SW CONNECTION FEES-CAPITAL 1,800 - 1,600 (1,800) 1,800 3,400 35,000 9.71% 52-000-44-00-4457 SW CONNECTION FEES-ROB ROY 288,000 - - - - 298,000 - 586,000 600,000 97.67% 52-000-44-00-4462 LATE PMT PENALTIES-SEWER 4 2,342 13 2,296 10 2,278 (1) 2,147 9,088 - 0.00% 52-000-44-00-4565 RIVER CROSSING FEES - 257 - - - 257 - - 514 - 0.00% Investment Earnings 52-000-45-00-4500 INVESTMENT EARNINGS 30 58 64 688 786 835 832 853 4,146 3,000 138.19% Miscellaneous 52-000-46-00-4670 REIMB-EMP INS CONTRIBUTIONS 386 386 386 386 386 386 386 386 3,091 4,587 67.390/c 52-000-46-00-4690 REIMB-MISCELLANEOUS 1,679 2,176 249 - - - - - 4,103 - 0.000/c TOTAL REVENUES:SEWER FUND 329,911 225,801 4,557 142,532 105,408 135,658 310,427 131,235 1,385,528 1,639,817 84.49% 21 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 2S°fo 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget SEWER OPERATIONS EXPENSES Salaries&Wages 52-520-50-00-5010 SALARIES&WAGES 14,411 15,287 14,496 21,755 15,726 14,726 14,726 19,167 130,296 210,000 62.05% 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 2,097 1,516 1,420 1,420 3,030 13,742 21,290 64.55% 52-520-52-00-5214 FICA CONTRIBUTION 1,073 1,140 1,079 1,635 1,174 1,097 1,097 1,437 9,731 18,000 54.06% 52-520-52-00-5216 GROUP HEALTH INSURANCE 3,686 3,938 3,708 3,779 7,529 3,922 18 8,839 35,420 63,595 55.70% 52-520-52-00-5222 GROUP LIFE INSURANCE 25 44 35 35 35 35 35 35 278 537 51.73% 52-520-52-00-5223 DENTAL INSURANCE 318 354 336 336 672 336 672 3,023 4,687 64.50% 52-520-52-00-5224 VISION INSURANCE 36 36 36 36 36 36 36 36 288 532 54.11% 52-520-52-00-5230 UNEMPLOYMENT INSURANCE 725 - 245 - - 84 - 1,054 2,571 40.98% 52-520-52-00-5231 LIABILITY INSURANCE 4,501 1,032 1,032 1,032 481 481 - 663 9,222 21,590 42.71% Contractual Services 52-520-54-00-5405 BUILD PROGRAM - 4,000 - - 1000 1000 8,000 2,000 18,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 - - - - 12 - 2 13 100 13.46% 52-520-54-00-5440 TELECOMMUNICATIONS - 131 135 132 144 123 122 123 909 1,800 50.52% 52-520-54-00-5444 LIFT STATION SERVICES - - - - 311 - 8,030 716 9,057 15,000 60.38% 52-520-54-00-5462 PROFESSIONAL SERVICES - 160 142 69 184 172 214 325 1,266 5,000 25.31% 52-520-54-00-5480 UTILITIES - 2,825 8,025 2,321 2,347 1,143 2,168 2,928 21,757 42,000 51.80% 52-520-54-00-5485 RENTAL&LEASE PURCHASE 33 33 33 33 33 33 42 42 282 1,500 18.80% 52-520-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 26 187 300 934 1,658 51 - 52 3,208 4,000 80.20% 52-520-54-00-5498 PAYING AGENT FEES - - - - - - - 1,177 1,177 3,000 39.23% Supplies 52-520-56-00-5600 WEARING APPAREL 39 88 66 166 233 88 504 79 1,263 2,500 50.54% 52-520-56-00-5610 OFFICE SUPPLIES - 8 - - 583 121 712 2,000 1 35.61% 22 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget 52-520-56-00-5613 LIFT STATION MAINTENANCE - 534 464 12 757 - 636 - 2,403 10,000 24.03% 52-520-56-00-5620 OPERATING SUPPLIES 145 204 278 427 245 179 426 143 2,047 4,500 45.50% 52-520-56-00-5630 SMALL TOOLS&EQUIPMENT - - 599 220 - - 31 - 850 4,500 18.900 52-520-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - - - - - 3,000 0.00% 52-520-56-00-5640 REPAIR&MAINTENANCE - 220 - 59 606 493 78 1,456 10,000 14.56% 52-520-56-00-5695 GASOLINE 1,891 1,843 2,006 1,390 3,079 1,642 1,534 13,385 29,211 45.82% Capital Outlay 52-520-60-00-6079 ROUTE 47 EXPANSION - - - - - 1 1,129 - 11,129 22,258 60,000 37.10% Developer Commitments 52-520-75-00-7500 LENNAR-RAINTREE SWR RECAP - 30,996 - - 30,996 30,996 100.00% 52-520-75-00-7501 WINDETTE RIDGE-SEWER RECAPTURE - - - - 150,000 0.00% 2004B Bond 52-520-84-00-8000 PRINCIPAL PAYMENT - - - - - 170,000 170,000 170,000 100.00% 52-520-84-00-8050 INTEREST PAYMENT - 46,925 - - 46,925 93,850 93,850 100.00% 2003 IRBB Debt Certificates 52-520-90-00-8000 PRINCIPAL 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 PRINCIPAL PAYMENT - - - - - - 175,000 175,000 175,000 100.00% 52-520-91-00-8050 INTEREST PAYMENT - 9,369 - - - 9,369 18,738 18,738 100.00% 2011 Refunding Bond 52-520-92-00-8050 INTEREST PAYMENT - 79,537 - - - - 238,610 318,147 318,147 100.00% [EPA Loan L17-013000 52-520-95-00-8000 PRINCIPAL PAYMENT - - 18,811 - - - - - 18,811 37,958 49.56% 52-520-95-00-8050 INTEREST PAYMENT - - 679 - - - - 679 1,022 66.48% IEPA Loan L17-115300 52-520-96-00-8000 PRINCIPAL 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-9951 TRANSFER TO WATER 6,857 6,857 6,857 6,857 6,857 6,857 6,857 6,857 54,859 82,288 66.67% 23 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) ' %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget TOTAL FUND REVENUES 329,911 225,801 4,557 142,532 105,408 135,658 310,427 131,235 1,385,528 1,639,817 84.49% TOTAL FUND EXPENSES 33,308 207,050 93,941 97,407 43,387 48,192 46,619 700,966 1,270,869 1,895,210 67.06% FUND SURPLUS(DEFICIT) 296,603 18,752 (89,384) 45,125 62,021 87,466 263,809 (569,732) 114,659 (255,393) LAND CASH REVENUES 72-000-41-00-4173 OSLAD GRANT-RAINTREE - - - - - - - - 400,000 0.00% 72-000-47-00-4703 AUTUMN CREEK 7,179 4,102 6,153 3,077 7,179 6,153 6.153 - 39,997 20,000 199.99% 72-000-47-00-4704 BLACKBERRY WOODS - - - - 568 - - 568 500 113.64% 72-000-47-00-4708 COUNTRY HILLS 769 - 769 - 1,538 - 0.00% TOTAL REVENUES:LAND CASH 7,179 4,871 6,153 3,077 7,747 6,922 6093 - 42,103 420,500 10.01% 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 2,136 (96) 13,416 901 38,747 191,825 20.20% 72-720-60-00-6044 HOPKINS PARK - - - - - - - - - 120,000 0.00% TOTAL FUND REVENUES 7,179 4,871 6,153 3,077 7,747 6,922 6,153 - 42,103 420,500 10.01% ' TOTAL FUND EXPENDITURES 450 15,768 17,626 547 2,136 (96) 13,416 901 50,747 323,825 15.67% FUND SURPLUS(DEFICIT) 6,729 (10,896) (11,472) 2,530 5,612 7,018 (7,263) (901) (8,644) 96,675 PARK&RECREATION REVENUES Charges for Service 79-000-44-00-4402 SPECIAL EVENTS r36,929,310 3,075 10,553 660 2,212 5,660 6,965 30 31,465 18,095 173.89% 79-000-44-00-4403 CHILD DEVELOPMENT ,156 4,874 1,270 2,400 1,810 1,988 3,607 5,708 26,813 58,810 45.59% 79-000-44-00-4404 ATHLETICS AND FITNESS 18,225 19,734 4,461 681 29,718 1,713 289 111,750 113,095 98.81% 79-000-44-00-4441 CONCESSION REVENUE 13,379 11,464 6,995 355 169 108 - - 32,469 30,000 108.23% 79-000-44-00-4443 HOMETOWN DAYS 1,325 600 11,020 14,460 81,026 10,803 - 119,234 175,000 68.13% 24 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %ofFiscal Year 8% 17% 2S% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget Investment Earnings 79-000-45-00-4500 INVESTMENT EARNINGS 21 20 22 22 19 19 20 22 166 200 82.77% Reimbursements 79-000-46-00-4670 REIMB-EMP INS CONTRIBUTIONS 1,132 1,132 1,132 1,132 967 967 967 967 8,397 11,661 72.01% Miscellaneous 79-000-48-00-4820 RENTAL INCOME 33,340 3,195 8,018 495 305 250 250 250 46,103 48,000 96.05% 79-000-48-00-4825 PARK RENTALS 6,017 3,074 245 1,307 100 1,404 - - 12,147 25,000 48.59% 79-000-48-00-4846 SPONSORSHIPS/DONATIONS 2,429 130 210 1,212 189 270 135 41575 14,700 31.12% 79-000-48-00-4850 MISCELLANEOUS INCOME 790 792 576 344 - (36) - - 2,466 1,000 246.60% Other Financing Sources 79-000-49-00-4901 TRANSFER FROM GENERAL 79,657 79,657 79,657 79,657 79,657 79,657 79,657 79,657 637,257 955,886 66.67% TOTAL REVENUES:PARK&RECREATION 182,484 126,238 139,433 106,505 167,135 130,809 93,315 86,923 1,032,842 1,451,447 71.16% PARKS DEPARTMENT EXPENDITURES Salaries&Wages 79-790-50-00-5010 SALARIES&WAGES 32,996 32,031 30,483 46,231 28,553 28,060 28,060 31,189 257,603 410,000 62.83% 79-790-50-00-5015 PART-TIME SALARIES 652 4,468 4,965 5,612 1,448 361 271 67 17,843 17,000 104.96% 79-790-50-00-5020 OVERTIME 443 214 344 - 429 - - 1,431 3,000 47.69% Benefits 79-790-52-00-5212 RETIREMENT PLAN CONTRIBUTION 3,245 3,172 2,996 4,530 2,815 2,754 2,746 5,587 27,845 43,693 63.73% 79-790-52-00-5214 FICA CONTRIBUTION 2,514 2,714 2,644 3,851 2,250 2,104 2,097 2,321 20,494 34,000 60.28% 79-790-52-00-5216 GROUP HEALTH INSURANCE 9,090 10,824 8,596 7,684 20,046 8,335 518 15,575 80,668 126,842 63.60% 79-790-52-00-5222 GROUP LIFE INSURANCE 58 102 82 82 82 72 72 72 620 1,208 51.31% 79-790-52-00-5223 DENTAL INSURANCE 635 836 736 608 1,344 608 - 1,253 6,019 9,179 65.58% 79-790-52-00-5224 VISION INSURANCE 84 84 84 84 84 70 70 70 629 1,104 56.95% Contractual Services 79-790-54-00-5412 TRAINING&CONFERENCES - - 180 180 2,600 6.92% 79-790-54-00-5415 TRAVEL&LODGING - - - 750 0.00% 79-790-54-00-5440 TELECOMMUNICATIONS - 335 339 377 310 384 261 301 2,306 3,780 61.01% 79-790-54-00-5462 PROFESSIONAL SERVICES 861 - - 46 96 10 1 1,013 1 4,500 22.51% 25 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION j May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget 79-790-54-00-5466 LEGAL SERVICES 1,710 855 238 428 - 385 3,615 4,000 90.38% 79-790-54-00-5485 RENTAL&LEASE PURCHASE - - 73 - - 78 78 229 2,500 9.16% 79-790-54-00-5495 OUTSIDE REPAIR AND MAINTENANCE - - - - - 101 12,536 3,684 16,322 17,500 93.27% Supplies 79-790-56-00-5600 WEARING APPAREL - 235 99 377 144 110 462 151 1,577 4,100 38.47% 79-790-56-00-5610 OFFICE SUPPLIES - - 53 99 - - - - 151 300 50.43% 79-790-56-00-5620 OPERATING SUPPLIES - 59 256 646 694 563 5,684 1,467 9,369 22,500 41.64% 79-790-56-00-5630 SMALL TOOLS&EQUIPMENT - 7 107 8 - 33 47 10 212 2,250 9.40% 79-790-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - - - - - - - 500 0.00% 79-790-56-00-5640 REPAIR&MAINTENANCE - 820 2,056 5,087 794 3,505 617 496 13,374 50,500 26.48% 79-790-56-00-5695 GASOLINE - 2,679 3,198 2,060 - 3,717 1,095 645 13,394 20,000 66.97% TOTAL EXPENDITURES:PARKS DEPT 49,717 58,579 59,607 78,263 59,228 51,249 54,710 63,540 474,894 781,806 60.74% RECREATION DEPARTMENT EXPENDITURES Salaries& Wages 79-795-50-00-5010 SALARIES&WAGES 13,453 15,885 15,226 22,936 15,291 15,291 17,217 15,291 130,589 185,000 70.59% 79-795-50-00-5015 PART-TIME SALARIES 1,233 770 443 835 2,374 833 1,236 854 8,577 25,000 34.31% 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 - - - - 1,040 - 1,640 4,790 25,000 19.16% 79-795-50-00-5052 INSTRUCTORS WAGES 1,181 1,264 713 1,008 992 722 1,130 434 7,442 25,000 29.77% Benefits 79-795-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,711 1,730 1,602 2,362 1,653 1.675 1,784 2,976 15,492 19,884 77.91% 79-795-52-00-5214 FICA CONTRIBUTION 1,543 1,537 1,391 1,855 1,382 1,323 1,453 1,349 11,834 16,000 73.96% 79-795-52-00-5216 GROUP HEALTH INSURANCE 3,334 2,206 3,043 6,378 5,896 3,299 371 5,531 30,057 41,094 73.14% 79-795-52-00-5222 GROUP LIFE INSURANCE 29 33 29 37 37 37 42 39 283 473 59.82% 79-795-52-00-5223 DENTAL INSURANCE 263 165 214 214 428 214 - 428 1,924 2.675 71.93% 79-795-52-00-5224 VISION INSURANCE 25 25 25 25 25 25 25 25 197 325 60.68% 26 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %ofFiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget 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 213 285 173 228 1,650 4,300 38.37% 79-795-54-00-5447 SCHOLARSHIPS - 300 - - - 32 - - 332 2,500 13.28% 79-795-54-00-5452 POSTAGE&SHIPPING - - 147 947 - - 1,094 8,000 13.68% 79-795-54-00-5460 DUES&SUBSCRIPTIONS - - - - - - - 424 424 1,500 28.27% 79-795-54-00-5462 PROFESSIONAL SERVICES 805 6,737 14,324 5,331 3,734 2,879 5,276 1,536 40,622 60,000 67.70% 79-795-54-00-5480 UTILITIES - 1,413 1,019 1,013 654 721 1,404 867 7,090 23,100 30.69% 79-795-54-00-5485 RENTAL&LEASE PURCHASE 178 178 186 28 178 271 173 351 1,542 4,500 34.27% 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 239 1,054 382 160 6,022 7,000 86.03% 79-795-56-00-5602 HOMETOWN DAYS SUPPLIES 4,151 - 322 54,762 31,994 484 - - 91,712 140,000 65.51% 79-795-56-00-5606 PROGRAM SUPPLIES 2,482 8,422 1,288 5,960 1,669 8,163 288 2,252 30,522 55,000 55.49% 79-795-56-00-5607 CONCESSION SUPPLIES 894 6,348 3,538 110 26 - - - 10,915 18,000 60.64% 79-795-56-00-5610 OFFICE SUPPLIES 273 19 53 212 - 498 416 7 1,477 3,000 49.24% 79-795-56-00-5620 OPERATING SUPPLIES 1,116 1,103 109 1,244 787 1,079 140 140 5,718 5,500 103.97% 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 9 47 2,000 2.37% 79-795-56-00-5645 BOOKS&PUBLICATIONS - - 100 0.00% 79-795-56-00-5690 SUPPLIES-GRANT REIMBURSABLE - - 500 0.00% 27 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET '%of Budget 79-795-56-00-5695 GASOLINE - 121 1 213 125 83 1 290 1 81 53 966 3,210 30.09% TOTAL EXPENDITURES:RECREATION DEPT 37,664 52,490 48,086 114,282 68,609 40,211 31,590 34,583 427,515 724,961 58.97% Emw TOTAL FUND REVENUES 182,484 126,238 139,433 106,505 167,135 130,809 93,315 86,923 1,032,842 1,451,447 71.16% TOTAL FUND EXPENDITURES 87,381 111,069 107,693 192,545 127,836 91,460 86,300 98,123 902,409 1,506,767 59.89% FUND SURPLUS(DEFICIT) 95,103 15,169 31,740 (86,040) 39,299 39,348 7,014 (11,200) 130,433 (55,320) RECREATION CENTER REVENUES Charges for Service 80-000-44-00-4440 PROGRAM FEES 6,987 3,834 2,317 12,329 7,003 7,534 8,889 3,165 52,058 100,000 52.06% 80-000-44-00-4441 CONCESSION REVENUE 890 719 717 738 464 636 625 673 5,462 12,500 43.69% 80-000-44-00-4444 MEMBERSHIP FEES 37,888 33,725 35,129 30,793 29,972 32,782 31,832 32,198 264,319 450,000 58.74% 80-000-44-00-4445 GUEST FEES 633 797 814 762 353 414 711 901 5,385 7,000 76.93% 80-000-44-00-4446 SWIM CLASS FEES 2,825 5,039 3,557 1,974 815 1,068 1,134 516 16,928 25,000 67.71% 80-000-44-00-4447 PERSONAL TRAINING FEES 1,215 257 108 730 236 844 130 912 4,432 10,000 44.32% 80-000-44-00-4448 TANNING SESSION FEES 222 30 92 82 65 50 50 37 628 2,500 25.12% Miscellaneous - 80-000-48-00-4820 RENTAL INCOME 1,296 779 761 1,006 736 824 1,009 604 7,015 13,000 53.96% 80-000-48-00-4846 SCHOLARSHIPS/DONATIONS 1,283 (123) - 250 (54) - - - 1,356 2,000 67.80% 80-000-48-00-4850 MISCELLANEOUS INCOME 21 20 4 1 1 3 1 - 49 500 9.75% TOTAL REVENUES:RECREATION CTR REVENUES 53,259 45,076 43,499 48,664 39,590 44,155 44,381 39,006 357,630 622,500 1 57.45% RECREATION CENTER EXPENSES Salaries& Wages 80-800-50-00-5010 SALARIES&WAGES 2,028 2,040 2,040 3,060 2,040 2,040 2,040 2,040 17,328 28,000 61.89% 80-800-50-00-5015 PART-TIME SALARIES 6,409 5,796 6,081 8,850 5,622 5,979 5,729 6,096 50,561 100,000 50.56% 80-800-50-00-5046 PRE-SCHOOL WAGES 614 400 - 1,790 2,788 2,280 3,370 1,510 12,752 35,000 36.43% 80-800-50-00-5052 INSTRUCTORS WAGES 3,616 5,172 5,586 6,435 4,039 3,792 4,287 3,423 36,349 60,000 60.58% Benefits 28 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget 80-800-52-00-5212 RETIREMENT PLAN CONTRIBUTION 685 595 550 960 816 733 847 1,531 6,718 10,181 65.99% 80-800-52-00-5214 FICA CONTRIBUTION 977 1,034 1,056 1,548 1,116 1,086 1,188 1,008 9,013 17,708 50.90% 80-800-52-00-5216 GROUP HEALTH INSURANCE 100 100 100 100 100 100 100 100 800 11200 66.67% 80-800-52-00-5222 GROUP LIFE INSURANCE 7 7 7 7 7 7 7 7 58 123 47.15% 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 90 581 90 341 1213 3,600 61.47% 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 872 628 955 927 8,737 20,000 43.69% 80-800-54-00-5480 UTILITIES - 3,039 2,889 4,313 314 5,629 2,064 758 19,006 55,650 34.15% 80-800-54-00-5485 RENTAL&LEASE PURCHASE 37,198 19,198 19,242 19,092 19,198 19,291 19,137 19,335 171,691 236,000 72.75% 80-800-54-00-5495 OUTSIDE REPAIR&MAINTENANCE 115 750 - 361 1,303 - 734 - 3,263 15,000 21.75% 80-800-54-00-5496 PROGRAM REFUNDS 174 601 292 740 504 450 175 468 31404 5,500 61.89% 80-800-54-00-5497 PROPERTY TAX PAYMENT 29,400 - - 29,400 - - - - 58,800 70,000 84.00% 80-800-56-00-5606 PROGRAM SUPPLIES - 988 514 366 660 740 771 650 4,689 15,000 31.26% 80-800-56-00-5607 CONCESSION SUPPLIES 694 73 860 798 189 289 367 280 31550 7,000 50.72% 80-800-56-00-5610 OFFICE SUPPLIES - - - - - - - 201 201 2,600 7.74% 80-800-56-00-5620 OPERATING SUPPLIES 177 502 72 203 53 H]1 619 1,737 6,200 28.02% 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 564 473 832 1,271 7,754 11,000 70.49% 80-800-56-00-5645 BOOKS&PUBLICATIONS - 114 80 - - - 194 50 388.22% 80-800-56-00-5695 GASOLINE - - - - 321 1 0.000 29 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %ofFiscat Year 8% 17% 25% 33% 42% 1 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget TOTAL FUND REVENUES 53,259 45,076 43,499 48,664 39,590 44,155 44,381 39,006 357,630 622,500 57.45% TOTAL FUND EXPENSES 82,327 44,881 42,523 81,061 40,505 44,152 42,803 40,567 418,820 703,633 59.52% FUND SURPLUS(DEFICIT) (29,068) 195 976 (32,397) (915) 3 1,577 (1,561) (61,190) (81,133) LIBRARY OPERATIONS REVENUES Taxes 82-000-40-00-4005 PROPERTY TAXES-LIBRARY 98,981 246,721 9,268 42,415 265,534 16,205 12,780 691,905 700,000 98.84% 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 727 - 278 2,814 5,000 56.27% 82-000-41-00-4170 STATE GRANTS - - - 1,500 17,352 - - 18,852 17,200 109.61% Fines&Forfeits 82-000-43-00-4330 LIBRARY FINES 994 888 765 572 508 837 903 707 6,172 13,000 47.48% Charges for Service 82-000-44-00-4401 LIBRARY SUBSCRIPTION CARDS 1,367 1,603 608 650 1,019 452 230 156 6,086 12,000 50.72% 82-000-44-00-4422 COPY FEES 204 153 175 216 181 306 251 147 1,632 3,000 54.41% 82-000-44-00-4440 PROGRAM FEES 93 44 54 74 119 51 61 133 629 2,000 31.43% Investment Earnings 82-000-45-00-4500 INVESTMENT EARNINGS 82 83 108 116 103 115 114 120 841 150 560.40% Reimbursements 82-000-46-00-4670 REIMB-EMP INS CONTRIBUTIONS 724 724 724 724 724 724 724 724 5,790 6,670 86.81% 82-000-46-00-4671 REIMB-LIFE INSURANCE 59 59 59 59 59 59 59 59 474 636 74.56% Miscellaneous 82-000-48-00-4820 RENTAL INCOME 131 150 100 100 150 150 118 123 1,022 2,000 51.10% 82-000-48-00-4824 DVD RENTAL INCOME 349 457 537 507 374 389 294 298 3,205 4,500 71.22% 82-000-48-00-4832 MEMORIALS 142 200 - 40 - 906 300 222 1,810 2,000 90.50% 82-000-48-00-4850 MISCELLANEOUS INCOME 33 13 87 26 26 51 25 - 261 - 0.00% 30 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %ofFiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget Other Financing Sources 82-000-49-00-4901 TRANSFER FROM GENERAL 9,733 1,801 1,801 2,151 840 960 - 2,312 19,598 41,978 46.69% TOTAL REVENUES:LIBRARY 143,630 252,895 15,241 49,265 269,637 39,285 15,859 5,279 761,091 817,634 93.08% LIBRARY OPERATIONS EXPENDITURES Salaries& Wages 82-820-50-00-5010 SALARIES&WAGES 18,707 19,431 18,707 28,060 18,707 18,707 18,707 18,707 159,731 245,000 65.20% 82-820-50-00-5015 PART-TIME SALARIES 14,207 14,193 14,085 20,716 13,594 13,930 13,019 12,482 116,227 195,000 59.60% Benefits 82-820-52-00-5212 RETIREMENT PLAN CONTRIBUTION 1,803 1,873 1,803 2,705 1,803 1,803 1,803 3,364 16,958 26,692 63.53% 82-820-52-00-5214 FICA CONTRIBUTION 2,463 2,517 2,453 3,676 2,416 2,441 2,372 2,331 20,668 38,000 54.39% 82-820-52-00-5216 GROUP HEALTH INSURANCE 8,308 8,047 5,553 10,578 11,001 5,621 - 10,623 59,732 102,877 58.06% 82-820-52-00-5222 GROUP LIFE INSURANCE 36 135 86 86 86 86 86 86 685 1,410 48.56% 82-820-52-00-5223 DENTAL INSURANCE 469 523 496 496 992 496 992 4,463 6,826 65.38% 82-820-52-00-5224 VISION INSURANCE 54 54 54 54 54 54 54 54 429 770 55.69% 82-820-52-00-5230 UNEMPLOYMENT INSURANCE 1,035 - 350 - - 120 - 1,505 4,286 35.12% 82-820-52-00-5231 LIABILITY INSURANCE 8,698 1,801 1,801 1,801 840 840 1,157 16,938 37,692 44.94% Contractual Services 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 795 481 807 794 5,733 8,500 67.45% 82-820-54-00-5452 POSTAGE&SHIPPING - - - 6 2 2 17 4 31 1,000 3.11% 82-820-54-00-5460 DUES&SUBSCRIPTIONS 78 - - - 210 5,401 2,100 - 7,789 14,000 55.63% 82-820-54-00-5462 PROFESSIONAL SERVICES 963 3,943 2,387 1,837 1,648 641 3,172 1,229 15,820 29,000 54.55% 82-820-54-00-5466 LEGAL SERVICES - - - 360 - - - - 360 2,000 18.00% 82-820-54-00-5468 AUTOMATION 3,385 7 - 869 3,866 - 3,836 - 11,965 35,000 34.18% 82-820-54-00-5480 UTILITIES - - 300 204 151 215 483 649 2,002 15,750 12.71% 82-820-54-00-5495 OUTSIDE REPAIR&MAINTENANCE - 276 91 536 214 384 - 864 2,364 5,000 47.28% 82-820-54-00-5498 PAYING AGENT FEES - - 375 375 - - - 749 749 100.00% 31 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget Supplies 82-820-56-00-5610 OFFICE SUPPLIES 793 295 187 1,054 36 817 525 3,706 8,000 46.33% 82-820-56-00-5620 OPERATING SUPPLIES 228 912 1,198 44 607 153 909 4,051 7,500 54.01% 82-820-56-00-5635 COMPUTER EQUIPMENT&SOFTWARE - - - 1,550 - - - 1,550 - 0.00% 82-820-56-00-5640 REPAIR&MAINTENANCE - 905 - - 905 - 0.00% 82-820-56-00-5671 LIBRARY PROGRAMMING - - 44 84 84 12 159 383 2,000 19.13% 82-820-56-00-5685 DVD'S 280 204 135 95 194 - - 908 2,000 45.38% 82-820-56-00-5698 MEMORIALS&GIFTS - - - - 100 609 277 985 2,000 49.27% 82-820-56-00-5699 MISCELLANEOUS - - - - 250 0.00% Contingencies 7 82-820-70-00-7799 CONTINGENCIES - 50 50 1,000 5.00% Other Financing Uses 82-820-99-00-9983 TRANSFER TO LIBRARY DEBT SERVICE 1,822 - 1,822 1,511 l 20.58% TOTAL FUND REVENUES 113,630 252,895 15,241 49,265 269,637 39,285 15,859 5,279 761,091 817,634 93.08% TOTAL FUND EXPENDITURES 62,028 55,051 51,041 75,376 60,109 52,243 48,096 55,203 459,148 794,413 57.80% FUND SURPLUS(DEFICIT) 51,602 197,843 (35,800) (26,112) 209,528 (12,958) (32,237) (49,924) 301,943 23,221 LIBRARY DEBT SERVICE REVENUES 83-000-40-00-4015 PROPERTY TAXES-DEBT SERVICE 113,248 282,285 10,604 48,529 303,810 18,541 14,622 - 791,640 795,488 99.52% 83-000-45-00-4500 INVESTMENT EARNINGS - 6 - - 36 64 58 36 200 300 66.60% 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 303,846 18,605 14,680 36 793,662 797,299 99.54% LIBRARY DEBT SERVICE EXPENDITURES 2005B Bond 83-830-83-00-8000 PRINCIPAL PAYMENT - - - - - - - 290,000 290,000 290,000 100.00% 83-830-83-00-8050 INTEREST PAYMENT 154,563 - - 154,563 309,125 309,125 100.00% 32 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) ofFiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget 2006 Bond 83-830-84-00-8000 PRINCIPAL PAYMENT - - - - 150,000 150,000 150,000 100.00% 83-830-84-00-8050 INTEREST PAYMENT 23,181 - - - - - 23,181 46,363 46,363 100.00% TOTAL FUND REVENUES 115,070 282,291 10,604 48,529 303,846 18,605 14,680 36 793,662 797,299 99.54% TOTAL FUND EXPENDITURES - 177,744 - - - - - 617,744 795,488 795,488 100.00% FUND SURPLUS(DEFICIT) 115,070 104,547 10,604 48,529 303,846 18,605 14,680 (617,708) (1,826) 1,811 LIBRARY CAPITAL REVENUES 84-000-42-00-4214 DEVELOPMENT FEES 2,500 - - 10,800 4.000 3,500 3,450 150 24,400 16,250 150.15% 84-000-45-00-4500 INVESTMENT EARNINGS 0 0 0 0 1 1 1 1 4 100 4.28% TOTAL REVENUES:LIBRARY CAPITAL 2,500 0 0 10,800 4,001 3,501 3,451 151 24,404 16,350 149.26% 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 - - - - - - 204 432 636 - 84-840-56-00-5686 BOOKS - 423 208 6 762 503 3,486 1,699 7,087 13,474 52.60% TOTAL FUND REVENUES 2,500 0 0 10,800 4,001 3,501 3,451 151 24,404 16,350 149.26% TOTAL FUND EXPENDITURES - 423 208 6 762 503 3,690 2,131 7,723 13,474 57.32% FUND SURPLUS(DEFICIT) 2,500 (422) (208) 10,794 3,239 2,997 (239) (1,980) 16,681 2,876 COUNTRYSIDE TIF REVENUES 87-000-40-00-4087 PROPERTY TAXES-CNTRYSDE - - - - - - - - - 4,500 0.00% 87-000-45-00-4500 INVESTMENT EARNINGS 234 223 228 240 281 290 287 285 2,068 2,000 103.40% TOTAL REVENUES:COUNTRYSIDE TIF 234 223 228 240 281 290 287 285 2,068 6,500 31.82% 33 UNITED CITY OF YORKVILLE BUDGET REPORT FOR THE PERIOD ENDING DECEMBER 31,2012 ACTUALS BY MONTH(Cash Basis) %of Fiscal Year 8% 17% 25% 33% 42% 50% 58% 67% Year-to-Date ANNUAL ACCOUNT NUMBER DESCRIPTION May-12 June-12 July-12 August-12 September-12 October-12 November-12 December-12 Totals BUDGET %of Budget COUNTRYSIDE TIF EXPENDITURES Contractual Services 87-870-54-00-5420 ADMINISTRATIVE FEES - 95 - 1,558 167 48 1,867 1,000 186.71% 87-870-54-00-5498 PAYING AGENT FEES - - - - 375 0.00% 2005 Bond - 87-870-80-00-8000 PRINCIPAL PAYMENT - 180,000 180,000 180,000 100.00% 87-870-80-00-8050 INTEREST PAYMENT 62,334 - - - - - 62,334 - 124,668 124,668 100.00% !RW TOTAL FUND REVENUES 234 223 228 240 281 290 287 285 2,068 6,500 31.82% TOTAL FUND EXPENDITURES 62,334 95 - - - 1,558 242,500 48 306,535 306,043 100.16% FUND SURPLUS(DEFICIT) (62,099) 128 228 240 281 (1,268) (242,214) 237 (304,467) (299,543) DOWNTOWN TIF REVENUES 88-000-40-00-4088 PROPERTY TAXES-DOWNTOWN TIF 3,159 19,243 1,504 1,202 12,136 972 1,764 - 39,980 70,000 57.11% 88-000-45-00-4500 INVESTMENT EARNINGS 3 5 6 11 49 56 53 53 236 150 157.15% TOTAL REVENUES:DOWNTOWN TIF 3,162 19,248 1,510 1,213 12,185 1,028 1,817 53 40,216 70,150 57.33% DOWNTOWN TIF EXPENDITURES 88-880-54-00-5420 ADMINISTRATIVE FEES - - - - - - 167 2,921 3,088 1,500 205.86% 88-880-54-00-5466 LEGAL SERVICES 2,869 447 2,185 608 2,442 190 - 8,740 10,000 87.40% 88-880-60-00-6000 PROJECT COSTS - - 1,038 280 - 2,326 4,665 8,309 10,000 83.09% 88-880-60-00-6079 ROUTE 47 EXPANSION - - - - - 3,333 - 3,333 6,667 20,000 33.33% TOTAL FUND REVENUES 3,162 19,248 1,510 1,213 12,185 1,028 1,817 53 40,216 70,150 57.33% TOTAL FUND EXPENDITURES - 2,869 447 3,223 888 5,775 2,682 10,920 26,804 41,500 64.59% FUND SURPLUS(DEFICIT) 3,162 16,379 1,063 (2,010) 11,296 (4,747) (865) (10,867) 13,412 28,650 34 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES, EXPENDITURES AND TRANSFERS For the Period Ending December 31, 2012 % of December YTD YTD to FY 2013 Actual Actual Budget Budget GENERAL FUND (01) Revenues Local Taxes Property Taxes - 2,715,518 99.8% 2,721,487 Municipal Sales Tax 207,616 1,658,656 71.3% 2,325,000 Non-Home Rule Sales Tax 161,337 1,276,709 0.0% 1,500,000 Electric Utility Tax 172,660 464,653 77.0% 603,432 Natural Gas Tax 28,014 120,086 40.5% 296,514 Telecommunications Tax 39,166 330,401 67.4% 490,000 Telephone Utility Tax 1,253 10,707 45.6% 23,500 Cable Franchise Fees - 157,771 68.6% 230,000 Hotel Tax 4,142 40,985 82.0% 50,000 Amusement Tax 511 145,000 108.2% 134,000 Admissions Tax - 119,199 114.1% 104,500 Business District Tax 25,954 196,853 65.6% 300,000 Auto Rental Tax 675 6,546 65.5% 10,000 Para-Mutuel Tax - 314 0.0% - Total Taxes $ 641,328 $ 7,243,397 82.4% $ 8,788,433 Intergovernmental State Income Tax 89,349 1,152,084 87.3% 1,320,000 Local Use Tax 22,442 169,078 69.8% 242,400 Road&Bridge Tax - 168,477 99.1% 170,000 Personal Property Replacement Tax 839 8,491 53.1% 16,000 Other Intergovernmental 1,513 10,807 96.5% 11,200 Total Intergovernmental $ 114,143 $ 1,508,937 85.8% $ 1,759,600 Licenses and Permits Liquor Licenses 850 2,429 6.1% 40,000 Building Permits 10,610 97,599 77.1% 126,600 Other Licenses &Permits 38 592 21.9% 2,700 Total Licenses & Permits $ 11,498 $ 100,620 59.4% $ 169,300 Fines and Forfeits Traffic Fines 4,483 37,557 39.5% 95,000 Administrative Adjudication 3,809 25,263 97.2% 26,000 Police Tows 4,500 42,875 53.6% 80,000 Other Fines & Forfeits (11,608) 175 0.0% 500 Total Fines and Forfeits $ 1,184 $ 105,870 190.3% $ 201,500 35 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES,EXPENDITURES AND TRANSFERS For the Period Ending December 31, 2012 % of December YTD YTD to FY 2013 Actual Actual Budget Budget Charges for Services Garbage Surcharge 160,521 702,627 68.8% 1,021,784 Late PMT Penalties - Garbage 14,849 14,994 0.0% - Collection Fee -YBSD - - 0.0% 151,500 Other Services - 100 2.0% 5,000 Total Charges for Services $ 175,369 $ 717,720 60.9% $ 1,178,284 Investment Earnings $ 685 $ 4,710 151.9% $ 3,100 Reimb/Miscellaneous/Other Financing Sources Reimb - Legal Expenses 60 8,566 0.0% - Reimb - Engineering Expenses 2,382 23,545 0.0% - Reimb - Traffic Signal - 20,019 133.5% 15,000 Reimb - Health Ins Contributions 10,655 86,551 63.7% 135,892 Other Reimbursements 429 97,454 198.9% 49,000 Rental Income 500 4,925 61.6% 8,000 Miscellaneous Income 115,018 115,183 3839.4% 3,000 Total Miscellaneous $ 129,043 $ 356,242 168.9% $ 210,892 Total Revenues and Transfers $ 1,073,250 $ 10,037,496 81.5% $ 12,311,109 Expenditures Administration $ 64,255 $ 460,893 58.9% $ 782,327 Salaries 26,791 220,203 66.0% 333,395 Benefits 32,711 169,620 61.5% 275,732 Contractual Services 4,410 67,495 42.1% 160,250 Supplies 342 3,575 27.6% 12,950 Finance $ 22,077 $ 197,359 58.0% $ 340,535 Salaries 13,392 114,096 61.7% 185,000 Benefits 6,991 40,979 66.0% 62,135 Contractual Services 1,694 41,261 46.8% 88,150 Supplies - 1,023 19.5% 5,250 Police $ 274,434 $ 2,500,449 65.1% $ 3,840,577 Salaries 166,606 1,357,948 61.3% 2,215,500 Overtime 8,711 73,676 81.9% 90,000 Benefits 81,368 875,550 74.9% 1,169,457 Contractual Services 11,317 112,888 52.8% 213,850 Supplies 6,431 80,388 53.0% 151,770 36 UNITED CITY OF YORKVILLE STATEMENT OF REVENUES,EXPENDITURES AND TRANSFERS For the Period Ending December 31, 2012 * % of December YTD YTD to FY 2013 Actual Actual Budget Budget Community Development $ 28,000 $ 215,706 46.7% $ 461,426 Salaries 15,008 129,852 52.4% 248,000 Benefits 11,784 57,033 51.9% 109,797 Contractual Services 981 16,292 17.6% 92,350 Supplies 228 12,529 111.1% 11,279 PW - Street Ops & Sanitation $ 58,106 $ 388,852 20.2% $ 1,920,452 Salaries 20,061 171,500 61.2% 280,000 Overtime - 938 6.3% 15,000 Benefits 19,675 103,063 69.9% 147,530 Contractual Services 14,245 77,337 5.6% 1,390,020 Supplies 4,124 36,014 41.0% 87,902 Administrative Services $ 254,951 $ 2,538,604 62.9% $ 4,034,550 Salaries - 100 2.0% 5,000 Benefits 23,076 227,473 40.4% 562,389 Contractual Services 106,673 1,295,723 68.4% 1,895,500 Supplies - 12,588 251.8% 5,000 Contingencies - - 0.0% 50,000 Transfers Out 125,202 1,002,720 66.1% 1,516,661 Total Expenditures and Transfers $ 701,823 $ 6,301,863 55.4% $ 11,379,867 Variance $ 371,427 $ 3,735,633 $ 931,242 * December represents 67%of the fiscal year 37 DATE: 01/09/2013 UNITED CITY OF YORKVILLE PAGE: 1 TIME: 16:45:29 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 08 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 O5 AP-120911 09/05/2012 09 ADMIN-PLAN COMMISSION MEETING DEPO COURT REPORTING 513872 15545 276.25 09/05/2012 10 ADMIN-JULY 10 MEETING MINUTES MARLYS J. YOUNG 513921 071012 196.35 09/05/2012 11 ADMIN-AUGUST 8 PLAN COMMISSION MARLYS J. YOUNG 513921 080812 40.00 AP-120925 09/20/2012 14 ADMIN-DRUG SCREEN RUSH-COPLEY HEALTHCA 513979 080212 25.00 09/20/2012 15 ADMIN-AUGUST 14 MEETING MARLYS J. YOUNG 513999 081412 101.15 TOTAL PERIOD 05 ACTIVITY 638.75 0.00 06 AP-121009 10/03/2012 18 ADMIN-FINGERPRINTING ILLINOIS STATE POLIC 514034 082412 31.50 AP-121023 10/16/2012 19 ADMIN-FINAL BILL FOR KENCOM ACI SYSTEM CORP 514083 D9357 80.00 10/16/2012 20 ADMIN-QUARTERLY MONITORING ALARM DETECTION SYST 514084 090912 135.00 10/16/2012 21 ADMIN-SEPT. 18 PUBLIC WORKS LISA R. GODWIN 514112 091812 65.24 10/16/2012 22 ADMIN-SEPT. 20 ADMIN MEETING LISA R. GODWIN 514112 092012 43.96 10/16/2012 23 ADMIN-SEPT. 4 EDC MEETING MARLYS J. YOUNG 514169 090412 70.00 10/16/2012 24 ADMIN-SEPT. 6 PUBLIC SAFETY MARLYS J. YOUNG 514169 090612 53.00 10/16/2012 25 ADMIN-SEPT. 12 PLAN COMMISSION MARLYS J. YOUNG 514169 091212 38.00 DATE: 01/09/2013 UNITED CITY OF YORKVILLE PAGE: 2 TIME: 16:45:29 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 08 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 06 GJ-12103IFE 10/23/2012 09 CLRKS SAFE BOX 10/5/12-10/5/13 75.00 TOTAL PERIOD 06 ACTIVITY 591.70 0.00 07 AP-121113 11/07/2012 22 ADMIN-OCT. 16 PUBLIC WORKS LISA R. GODWIN 514204 101612 40.60 11/07/2012 23 ADMIN-BACKGROUND CHECKS ILLINOIS STATE POLIC 514211 102912-CITY 94.50 11/07/2012 24 ADMIN-COPIER RETURN SHIPPING VISA 514268 102812-CITY 61.00 11/07/2012 25 ADMIN-ORDINANCE YORKVILLE CLERK'S AC 514278 157939 54.00 11/07/2012 26 ADMIN-OCT. 2 EDC MEETING MARLYS J. YOUNG 514281 100212 48.25 11/07/2012 27 ADMIN-OCT. 4 PUBLIC SAFETY MARLYS J. YOUNG 514281 100412 42.50 AP-121127 11/19/2012 09 ADMIN-NOTARY PUBLIC RENEWAL CNA SURETY 514304 060115213866N-110912 30.00 11/19/2012 10 ADMIN-NOV. 5 EDC MEETING LISA R. GODWIN 514312 110512 51.80 11/19/2012 11 ADMIN-NOTARY APPLICATION SECRETARY OF STATE 514341 111312 10.00 11/19/2012 12 ADMIN-OCT. 17 PLAN COMMISSION MARLYS J. YOUNG 514366 101712 12.62 TOTAL PERIOD 07 ACTIVITY 445.27 0.00 08 AP-121211 12/04/2012 23 ADMIN-NOVEMBER 20 PUBLIC WORKS LISA R. GODWIN 514388 112012 59.64 12/04/2012 24 ADMIN-OCT. 27 CC GOAL SETTING MARLYS J. YOUNG 514438 102712 82.50 12/04/2012 25 ADMIN-NOVEMBER 1 PUBLIC SAFETY MARLYS J. YOUNG 514438 110112 45.75 AP-121219 12/11/2012 10 ADMIN-11/23/12 PUBLIC HEARING GLORIA APOSTOLOS 514456 108536 225.15 TOTAL PERIOD 08 ACTIVITY 413.04 0.00 YTD BUDGET 13,333.36 TOTAL ACCOUNT ACTIVITY 5,910.79 379.25 ANNUAL REVISED BUDGET 20,000.00 ENDING BALANCE 5,531.54 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 01 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 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-12073IFE 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-120831FE 08/31/2012 03 JULY CC FEES UB 395 71.50 TOTAL PERIOD 04 ACTIVITY 474.45 0.00 DATE: 01/09/2013 UNITED CITY OF YORKVILLE PAGE: 3 TIME: 16:45:30 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 08 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 05 AP-120911 09/05/2012 57 FINANCE-REOCCURRING WEBSITE VISA 513914 082712-C 54.92 GJ-120930FE 09/26/2012 03 AUG CC FEES UB 395 276.39 09/26/2012 09 AUGUST ACCOUNT ANALYSIS FEE 28.63 TOTAL PERIOD 05 ACTIVITY 359.94 0.00 06 AP-121009 10/03/2012 27 FINANCE-ON SITE DESTRUCTION OF SHRED-IT 514061 9400823950 48.00 10/03/2012 28 FINANCE-MONTHLY WEBSITE FEES VISA 514068 092612-CITY 15.95 GJ-121031FE 10/23/2012 03 SEPT CC FEES UB 395 92.17 TOTAL PERIOD 06 ACTIVITY 156.12 0.00 07 AP-121113 11/07/2012 48 FINANCE -POSTAGE LEASE FOR PITNEY BOWES 514244 1970458-OT12 700.00 11/07/2012 49 FINANCE-REOCCURRING WEBSITE VISA 514268 102812-CITY 135.35 11/07/2012 50 FINANCE-COPIER RETURN SHIPPING VISA 514268 102812-CITY 48.83 AP-121127 11/19/2012 27 FINANCE-PO BOND - POWELL MESIROW INSURANCE SE 514327 788322 100.00 11/19/2012 28 FINANCE-PO BOND - FREDRICKSON MESIROW INSURANCE SE 514327 788323 100.00 GJ-121130FE 11/21/2012 03 OCT CC FEES UB 395 310.35 TOTAL PERIOD 07 ACTIVITY 1,394.53 0.00 08 AP-121211 12/04/2012 37 FINANCE-REOCCURRING WEBSITE VISA 514430 112612-CITY 501.87 AP-121219 12/11/2012 25 FINANCE-250 MAIN ACCOUNT AP ANNETTE M. POWELL 514476 18740 82.04 GJ-121231FE 12/11/2012 03 NOV CC FEES UB 395 87.40 TOTAL PERIOD 08 ACTIVITY 671.31 0.00 YTD BUDGET 26,666.68 TOTAL ACCOUNT ACTIVITY 6,389.09 37.32 ANNUAL REVISED BUDGET 40,000.00 ENDING BALANCE 6,351.77 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 CO. SHERIFF' 513781 080812-MCTF 1,000.00 08/22/2012 75 MOBILE COMMAND CENTER ANNUAL KENDALL CO. SHERIFF' 513781 080812-MCU 500.00 08/22/2012 76 POLICE-ANNUAL SRT INSTALLMENT KENDALL CO. SHERIFF' 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 05 AP-120925 09/20/2012 48 POLICE-AUGUST SEARCHES LEXISNEXIS RISK DATA 513924 1249304-20120831 50.00 DATE: 01/09/2013 UNITED CITY OF YORKVILLE PAGE: 4 TIME: 16:45:30 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 08 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 05 GJ-120930FE 09/26/2012 01 AUG CC FEES PD 382 63.40 TOTAL PERIOD 05 ACTIVITY 113.40 0.00 06 AP-121009 10/03/2012 40 POLICE-ON SITE DESTRUCTION OF SHRED-IT 514061 9400823950 140.00 10/03/2012 41 POLICE-ON SITE SHREDDING SHRED-IT 514061 9400837570 97.32 10/03/2012 42 POLICE-BACKGROUND CHECK VISA 514069 092612-pd 11.00 AP-121023 10/16/2012 52 POLICE-SEPTEMBER SEARCHES LEXISNEXIS RISK DATA 514082 1249304-20120930 50.00 GJ-121031FE 10/23/2012 01 SEPT CC FEES PD 382 25.90 TOTAL PERIOD 06 ACTIVITY 324.22 0.00 07 AP-121113 11/07/2012 70 POLICE-COPIER RETURN SHIPPING VISA 514268 102812-CITY 219.64 AP-121127 11/19/2012 38 POLICE-OCTOBER BACKGROUND LEXISNEXIS RISK DATA 514290 1249304-20121031 50.00 11/19/2012 39 POLICE-ILCC TOBACCO GRANT ILLINOIS LIQUOR CONT 514315 111312 598.84 11/19/2012 40 POLICE-SHREDDING SHRED-IT 514342 9401088796 97.32 GJ-121130FE 11/21/2012 01 OCT CC FEES PD 382 43.77 TOTAL PERIOD 07 ACTIVITY 1,009.57 0.00 08 AP-121219 12/11/2012 36 POLICE-KC SHERIFFS OFFICE KENDALL CO. SHERIFF' 514475 R002-13 500.00 GJ-121231FE 12/11/2012 01 NOV CC FEES PD 382 48.87 12/11/2012 09 POLICE EPAY CORRECTION M.MOORE 1.00 TOTAL PERIOD 08 ACTIVITY 549.87 0.00 YTD BUDGET 3,333.36 TOTAL ACCOUNT ACTIVITY 6,359.12 54.05 ANNUAL REVISED BUDGET 5,000.00 ENDING BALANCE 6,305.07 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 GJ-12103ORC 10/30/2012 02 RECLASS TO DUES & SUBSCRIPTION 575.00 TOTAL PERIOD 03 ACTIVITY 1,606.50 575.00 07 AP-121113 11/07/2012 97 COMM/DEV-BACKGROUND CHECK ILLINOIS STATE POLIC 514211 102912-CITY 31.50 11/07/2012 98 COMM/DEV-DRUG SCREEN RUSH-COPLEY HEALTHCA 514252 7060-CITY 25.00 11/07/2012 99 COMM/DEV-COPIER RETURN VISA 514268 102812-CITY 82.37 AP-121127 11/19/2012 68 COMM/DEV-WIPER BLADE YORKVILLE NAPA AUTO 514363 018026 17.24 GJ-121205RC 12/05/2012 02 RECLASS TO OPERATING SUPPLIES 17.24 TOTAL PERIOD 07 ACTIVITY 156.11 17.24 08 AP-121219 12/11/2012 58 COMM/DEV-SEMI ANNUAL GREASE CARLSENS ELEVATOR SE 514448 57847 306.00 TOTAL PERIOD 08 ACTIVITY 306.00 0.00 YTD BUDGET 4,000.00 TOTAL ACCOUNT ACTIVITY 6,243.61 1,167.24 ANNUAL REVISED BUDGET 6,000.00 ENDING BALANCE 5,076.37 01-410-54-00-5462 (E) PROFESSIONAL SERVICES 01 05/01/2012 BEGINNING BALANCE 0.00 DATE: 01/09/2013 UNITED CITY OF YORKVILLE PAGE: 5 TIME: 16:45:30 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 08 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 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 05 AP-120925 09/20/2012 92 STREETS-COPIER CHARGES KONICA MINOLTA BUSIN 513957 222051716 6.94 TOTAL PERIOD 05 ACTIVITY 6.94 0.00 07 AP-121113 11/07/2012 105 STREETS-REIMBURSEMENT FOR CDL SENG, MATT 514253 101212 60.00 11/07/2012 106 STREETS-COPIER RETURN SHIPPING VISA 514268 102812-CITY 27.45 TOTAL PERIOD 07 ACTIVITY 87.45 0.00 08 AP-121219 12/11/2012 67 STREETS-EXTINGUISHER SERVICE CINTAS CORPORATION N 514450 F9400031985 366.88 12/11/2012 68 STREETS-2013 ANNUAL SALT IGLOO KENDALL COUNTY HIGHW 514473 112912 250.00 TOTAL PERIOD 08 ACTIVITY 616.88 0.00 YTD BUDGET 666.68 TOTAL ACCOUNT ACTIVITY 1,337.27 0.00 ANNUAL REVISED BUDGET 1,000.00 ENDING BALANCE 1,337.27 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 333.36 TOTAL ACCOUNT ACTIVITY 451.00 0.00 ANNUAL REVISED BUDGET 500.00 ENDING BALANCE 451.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 CO. SHERIFF' 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 1,666.68 TOTAL ACCOUNT ACTIVITY 3,542.00 0.00 ANNUAL REVISED BUDGET 2,500.00 ENDING BALANCE 3,542.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 06 AP-121023 10/16/2012 184 CW CAPITAL-PAVEMENT MANAGEMENT ENGINEERING ENTERPRI 514104 51492 12,000.00 TOTAL PERIOD 06 ACTIVITY 12,000.00 0.00 YTD BUDGET 66,666.68 TOTAL ACCOUNT ACTIVITY 32,163.42 695.92 ANNUAL REVISED BUDGET 100,000.00 ENDING BALANCE 31,467.50 DATE: 01/09/2013 UNITED CITY OF YORKVILLE PAGE: 6 TIME: 16:45:30 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 08 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 05 AP-120911 09/05/2012 143 WATER OP-SEPTEMBER HOSTING ITRON 513884 256494 456.23 GJ-120930FE 09/26/2012 05 AUG CC FEES UB 395 542.04 09/26/2012 11 AUGUST ACCOUNT ANALYSIS FEE 56.15 TOTAL PERIOD 05 ACTIVITY 1,054.42 0.00 06 AP-121009 10/03/2012 149 WATER OP-BACKGROUND CHECK ILLINOIS STATE POLIC 514035 091212-CITY 31.50 10/03/2012 150 WATER OP-HOSTING SERVICES ITRON 514036 260453 456.23 10/03/2012 151 WATER OP-HEP. A & B SHOT KENDALL COUNTY HEALT 514039 102408-12 70.00 10/03/2012 152 WATER OP-2 RANDOM DRUG RUSH-COPLEY HEALTHCA 514057 6803-C 52.00 GJ-121031FE 10/23/2012 05 SEPT CC FEES UB 395 180.76 TOTAL PERIOD 06 ACTIVITY 790.49 0.00 07 AP-121113 11/07/2012 214 WATER OP-HOSTING SERVICES AND ITRON 514216 264188 456.26 11/07/2012 215 WATER OP-COPIER RETURN VISA 514268 102812-CITY 27.46 GJ-121126RC 11/26/2012 01 RECLASS TO PROF. SERVICES 456.23 11/26/2012 03 RECLASS TO PROF. SERVICES 456.23 GJ-121130FE 11/21/2012 05 OCT CC FEES UB 395 608.65 TOTAL PERIOD 07 ACTIVITY 2,004.83 0.00 08 AP-121211 12/04/2012 149 WATER OP-HOSTING SERVICES ITRON 514397 267679 474.48 DATE: 01/09/2013 UNITED CITY OF YORKVILLE PAGE: 7 TIME: 16:45:30 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 08 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 08 GJ-121213RC 12/13/2012 02 RC TO TREATMENT FACILITY SERV. 500.00 AP-121219 12/11/2012 143 WATER OP-EXTINGUISHER SERVICE CINTAS CORPORATION N 514450 F9400031985 366.88 GJ-121231FE 12/11/2012 05 NOV CC FEES UB 395 171.41 TOTAL PERIOD 08 ACTIVITY 1,012.77 500.00 YTD BUDGET 5,866.68 TOTAL ACCOUNT ACTIVITY 10,183.77 1,578.12 ANNUAL REVISED BUDGET 8,800.00 ENDING BALANCE 8,605.65 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 05 GJ-120930FE 09/26/2012 07 AUG CC FEES UB 395 166.56 09/26/2012 13 AUGUST ACCOUNT ANALYSIS FEE 17.25 TOTAL PERIOD 05 ACTIVITY 183.81 0.00 06 AP-121009 10/03/2012 179 SEWER OP-HEP. A & B SHOT KENDALL COUNTY HEALT 514039 102408-12 70.00 10/03/2012 180 SEWER OP-RANDOM DRUG SCREEN RUSH-COPLEY HEALTHCA 514057 6803-C 46.00 GJ-121031FE 10/23/2012 07 SEPT CC FEES UB 395 55.55 TOTAL PERIOD 06 ACTIVITY 171.55 0.00 07 AP-121113 11/07/2012 255 SEWER OP-COPIER RETURN VISA 514268 102812-CITY 27.46 GJ-121130FE 11/21/2012 07 OCT CC FEES UB 395 187.03 TOTAL PERIOD 07 ACTIVITY 214.49 0.00 08 AP-121211 12/04/2012 171 SEWER OP-DOT DRUG SCREEN RUSH-COPLEY HEALTHCA 514416 7254-CITY 26.00 GJ-121213RC 12/13/2012 04 RC TO LIFT STATION SERVICE 121.00 AP-121219 12/11/2012 173 SEWER OP-EXTINGUISHER SERVICE CINTAS CORPORATION N 514450 F9400031985 366.88 GJ-121231FE 12/11/2012 07 NOV CC FEES UB 395 52.67 TOTAL PERIOD 08 ACTIVITY 445.55 121.00 YTD BUDGET 3,333.36 TOTAL ACCOUNT ACTIVITY 1,595.66 330.00 ANNUAL REVISED BUDGET 5,000.00 ENDING BALANCE 1,265.66 79-790-54-00-5462 (E) PROFESSIONAL SERVICES 01 05/01/2012 BEGINNING BALANCE 0.00 DATE: 01/09/2013 UNITED CITY OF YORKVILLE PAGE: 8 TIME: 16:45:30 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 08 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 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 06 AP-121011 10/09/2012 07 RANDOM DRUG SCREENS RUSH-COPLEY HEALTHCA 209264 6803-PR 46.00 TOTAL PERIOD 06 ACTIVITY 46.00 0.00 07 AP-121113 11/07/2012 289 PARKS-COPIER RETURN SHIPPING VISA 514268 102812-CITY 96.08 TOTAL PERIOD 07 ACTIVITY 96.08 0.00 08 AP-121219 12/11/2012 195 PARKS-10/20/12-11/28/12 COPY MCGRATH OFFICE EQUIP 514479 100358 9.67 TOTAL PERIOD 08 ACTIVITY 9.67 0.00 YTD BUDGET 3,000.00 TOTAL ACCOUNT ACTIVITY 1,153.52 140.50 ANNUAL REVISED BUDGET 4,500.00 ENDING BALANCE 1,013.02 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 DATE: 01/09/2013 UNITED CITY OF YORKVILLE PAGE: 9 TIME: 16:45:30 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 08 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 02 AP-120614 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 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 DATE: 01/09/2013 UNITED CITY OF YORKVILLE PAGE: 10 TIME: 16:45:30 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 08 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 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 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 05 AP-120909 09/19/2012 28 REFEREE RAYMOND HAYEN 209202 090412 70.00 09/19/2012 29 RERFEREE RAYMOND HAYEN 209202 090612 105.00 09/19/2012 30 BACKGROUND CHECK ILLINOIS STATE POLIC 209205 091212-PR 31.50 09/19/2012 31 REFEREE BRUCE MORRICK 209210 090412 70.00 09/19/2012 32 REFEREE BRUCE MORRICK 209210 091312 35.00 09/19/2012 33 ASSIGNING FEE PER OFFICIAL CYNTHIA O'LEARY 209213 SOFTBALL 4TH-2012 245.00 09/19/2012 34 REFEREE MARTIN J. O'LEARY 209214 090612 140.00 09/19/2012 35 REFEREE MARTIN J. O'LEARY 209214 091112 70.00 09/19/2012 36 REFEREE MARTIN J. O'LEARY 209214 091312 35.00 09/19/2012 37 REFEREE TRACY ROBINSON 209221 090412 70.00 09/19/2012 38 REFEREE TRACY ROBINSON 209221 090612 140.00 09/19/2012 39 REFEREE TRACY ROBINSON 209221 091112 70.00 09/19/2012 40 DRUG SCREENING RUSH-COPLEY HEALTHCA 209222 091212-PR 75.00 09/19/2012 41 REFEREE SCOT SUTHERLAND 209227 091112 70.00 AP-120913 09/05/2012 26 SUMMER JUNIOR GOLF CAMP CHAD JOHANSEN GOLF A 209157 1197 810.00 09/05/2012 27 REFEREE HOMER DANIELS 209159 082112 70.00 09/05/2012 28 JULY SUMMER TENNIS CAMP DANIEL LITZHOFF 209170 JULY 2012 750.00 09/05/2012 29 REFEREE MARTIN J. O'LEARY 209175 082112 70.00 09/05/2012 30 REFEREE TRACY ROBINSON 209179 082112 70.00 DATE: 01/09/2013 UNITED CITY OF YORKVILLE PAGE: 11 TIME: 16:45:30 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 08 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 05 GJ-120917PR 09/18/2012 43 AUG CC FEES CHARGED IN SEPT 737.67 TOTAL PERIOD 05 ACTIVITY 3,734.17 0.00 06 AP-121011 10/09/2012 34 REFEREE GREG ERICKSON 209241 100212 70.00 10/09/2012 35 SEPTEMBER 27 MEETING MINUTES LISA R. GODWIN 209245 092712 73.64 10/09/2012 36 REFEREE RAYMOND HAYEN 209248 091812 70.00 10/09/2012 37 REFEREE RAYMOND HAYEN 209248 092512 70.00 10/09/2012 38 REFEREE RAYMOND HAYEN 209248 092712 140.00 10/09/2012 39 REFEREE DENNIS KEITH 209250 092712 140.00 10/09/2012 40 REFEREE NORMAN C. MEIER 209252 092012 105.00 10/09/2012 41 REFEREE BRUCE MORRICK 209256 090212 140.00 10/09/2012 42 REFEREE BRUCE MORRICK 209256 091812 70.00 10/09/2012 43 REFEREE BRUCE MORRICK 209256 092712 140.00 10/09/2012 44 REFEREE BRUCE MORRICK 209256 100212 70.00 10/09/2012 45 REFEREE MARTIN J. O'LEARY 209260 092512 70.00 10/09/2012 46 REFEREE MARTIN J. O'LEARY 209260 100212 70.00 10/09/2012 47 REFEREE RANDY J. SCHNITZ 209265 091812 70.00 10/09/2012 48 REFEREE SCOT SUTHERLAND 209269 092012 105.00 10/09/2012 49 REFEREE SCOT SUTHERLAND 209269 092512 70.00 GJ-121022PR 10/22/2012 41 SEPT CC FEE CHARGED IN OCT 585.30 AP-121025 10/17/2012 24 REFEREE ROBERT FERGUSON 209280 101112 140.00 10/17/2012 25 REFEREE RAYMOND HAYEN 209283 100412 35.00 10/17/2012 26 REFEREE RAYMOND HAYEN 209283 100912 70.00 10/17/2012 27 REFEREE BRUCE MORRICK 209289 101112 105.00 10/17/2012 28 SEPTEMBER OFFICIAL ASSIGNING CYNTHIA O'LEARY 209291 SOFTBALL 5TH-12 295.00 10/17/2012 29 REFEREE MARTIN J. O'LEARY 209292 100912 70.00 10/17/2012 30 REFEREE SCOT SUTHERLAND 209304 101112 105.00 TOTAL PERIOD 06 ACTIVITY 2,878.94 0.00 07 AP-121101 10/25/2012 21 FALL SPORTS INSTRUCTION ALL STAR SPORTS INST 209307 126229 582.00 10/25/2012 22 OCTOBER 15 MEETING MINUTES LISA R. GODWIN 209311 101512 60.20 10/25/2012 23 REFEREE RAYMOND HAYEN 209314 101612 105.00 10/25/2012 24 REFEREE BRUCE MORRICK 209319 101612 35.00 GJ-121112PR 11/14/2012 45 OCTOBER CC FEES 868.62 AP-121113 11/07/2012 292 RECREATION-COPIER RETURN VISA 514268 102812-CITY 123.55 AP-121115 11/07/2012 38 SUMMER BASEBALL CAMPS ROCLAB ATHLETIC INST 209331 IN002608 2,732.00 11/07/2012 39 REFEREE RAYMOND HAYEN 209334 102512 70.00 11/07/2012 40 REFEREE BRUCE MORRICK 209342 102512 70.00 11/07/2012 41 REFEREE BRUCE MORRICK 209342 110112 105.00 11/07/2012 42 REFEREE MARTIN J. O'LEARY 209343 103012 105.00 11/07/2012 43 REFEREE MARTIN J. O'LEARY 209343 110112 140.00 11/07/2012 44 REFEREE TRACY ROBINSON 209348 103012 105.00 11/07/2012 45 REFEREE TRACY ROBINSON 209348 110112 105.00 11/07/2012 46 REFEREE RONALD V. WOZNY 209352 102512 70.00 TOTAL PERIOD 07 ACTIVITY 5,276.37 0.00 08 GJ-121210PR 12/10/2012 44 NOVEMBER CC FEES 669.54 AP-121213 12/05/2012 64 REFEREE ROBERT FERGUSON 209362 100812 70.00 12/05/2012 65 OCTOBER 25 PARK BOARD MEETING LISA R. GODWIN 209368 102512 13.16 DATE: 01/09/2013 UNITED CITY OF YORKVILLE PAGE: 12 TIME: 16:45:30 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 08 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 08 AP-121213 12/05/2012 66 NOVEMBER 15 MEETING MINUTES LISA R. GODWIN 209368 111512 77.00 12/05/2012 67 REFEREE RAYMOND HAYEN 209371 111512 70.00 12/05/2012 68 RECREATION BACKGROUND CHECKS ILLINOIS STATE POLIC 209375 111612-PR 31.50 12/05/2012 69 REFEREE BRUCE MORRICK 209381 110812 140.00 12/05/2012 70 ASSIGNING FEE PER OFFICIAL FOR CYNTHIA O'LEARY 209385 SOFTBALL 6TH-12 335.00 12/05/2012 71 REFEREE TRACY ROBINSON 209391 111512 70.00 AP-121219 12/11/2012 201 RECREATION-10/20/12-11/28/12 MCGRATH OFFICE EQUIP 514479 100358 59.93 TOTAL PERIOD 08 ACTIVITY 1,536.13 0.00 YTD BUDGET 40,000.00 TOTAL ACCOUNT ACTIVITY 41,398.08 775.63 ANNUAL REVISED BUDGET 60,000.00 ENDING BALANCE 40,622.45 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 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 05 AP-120909 09/19/2012 73 SEPTEMBER PEST CONTROL FIRST ILLINOIS SYSTE 209198 10119 43.00 09/19/2012 74 BACKGROUND CHECK ILLINOIS STATE POLIC 209205 091212-PR 31.50 AP-120913 09/05/2012 47 OCTOBER 2012 - DECEMBER 2012 WIRE WIZARD OF ILLIN 209184 14339 60.00 GJ-120917PR 09/18/2012 45 AUG CC FEES CHARGED IN SEPT 737.66 TOTAL PERIOD 05 ACTIVITY 872.16 0.00 06 GJ-121022PR 10/22/2012 43 SEPT CC FEE CHARGED IN OCT 585.31 AP-121025 10/17/2012 50 OCTOBER PEST CONTROL FIRST ILLINOIS SYSTE 209281 10300 43.00 TOTAL PERIOD 06 ACTIVITY 628.31 0.00 07 GJ-121112PR 11/14/2012 47 OCTOBER CC FEES 868.61 DATE: 01/09/2013 UNITED CITY OF YORKVILLE PAGE: 13 TIME: 16:45:31 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 08 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 07 AP-121113 11/07/2012 295 REC CENTER-COPIER RETURN VISA 514268 102812-CITY 54.91 AP-121115 11/07/2012 56 BACKGROUND CHECKS ILLINOIS STATE POLIC 209335 102912-PR 31.50 TOTAL PERIOD 07 ACTIVITY 955.02 0.00 08 GJ-121210PR 12/10/2012 46 NOVEMBER CC FEES 669.54 AP-121213 12/05/2012 91 NOVEMBER PEST CONTROL FIRST ILLINOIS SYSTE 209363 10472 43.00 12/05/2012 92 REC CENTER BACKGROUND CHECK ILLINOIS STATE POLIC 209375 111612-PR 63.00 12/05/2012 93 DRUG SCREENING RUSH-COPLEY HEALTHCA 209393 7060-PR 25.00 12/05/2012 94 DRUG SCREENINGS RUSH-COPLEY HEALTHCA 209393 7254-PR 75.00 AP-121219 12/11/2012 205 REC CENTER-10/20/12-11/28/12 MCGRATH OFFICE EQUIP 514479 100358 51.52 TOTAL PERIOD 08 ACTIVITY 927.06 0.00 YTD BUDGET 13,333.36 TOTAL ACCOUNT ACTIVITY 9,544.61 807.12 ANNUAL REVISED BUDGET 20,000.00 ENDING BALANCE 8,737.49 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 05 GJ-120907FE 10/02/2012 01 WIRE FEE 9/7/12 15.00 AP-120910 09/05/2012 07 COPIER CHARGES KONICA MINOLTA BUSIN 103233 221971111 27.72 09/05/2012 08 ANNUAL SERVICE CONTRACT SOUND INCORPORATED 103241 R116081 291.00 DATE: 01/09/2013 UNITED CITY OF YORKVILLE PAGE: 14 TIME: 16:45:31 GENERAL LEDGER ACTIVITY REPORT F-YR: 13 ID: GL440000.WOW ACTIVITY THROUGH FISCAL PERIOD 08 PER. JOURNAL # ENTRY DATE ITEM TRANSACTION DESCRIPTION VENDOR CHECK INVOICE DEBIT CREDIT 05 AP-120910 09/05/2012 09 AUGUST ELEVATOR MAINTENANCE THYSSENKRUPP ELEVATO 103242 3000207230 218.03 09/05/2012 10 IT SERVICE AND CONSULTATION YORKVILLE PC 103245 1345 1,020.00 09/05/2012 11 AUGUST 13 MEETING MINUTES MARLYS J. YOUNG 103246 081312 60.75 GJ-120925TR 09/26/2012 03 WIRE FEE 15.00 TOTAL PERIOD 05 ACTIVITY 1,647.50 0.00 06 AP-121008 10/02/2012 08 ELEVATOR PHONE MONITORING ACI SYSTEM CORP 103248 D9536 335.40 10/02/2012 09 SEPTEMBER ELEVATOR MAINTENANCE THYSSENKRUPP ELEVATO 103262 3000231712 218.03 10/02/2012 10 SEPTEMBER 10 MEETING MINUTES MARLYS J. YOUNG 103266 091012 73.00 GJ-121026TR 10/26/2012 03 WIRE FEE 15.00 TOTAL PERIOD 06 ACTIVITY 641.43 0.00 07 AP-121105 10/31/2012 09 COPIER CHARGES KONICA MINOLTA BUSIN 103273 222476280 5.90 10/31/2012 10 COPIER CHARGES KONICA MINOLTA BUSIN 103273 222485408 257.71 10/31/2012 11 MAINTENANCE CONTRACT CHARGE SOUND INCORPORATED 103282 R117287 709.50 10/31/2012 12 OCTOBER ELEVATOR MAINTENANCE THYSSENKRUPP ELEVATO 103283 3000254124 218.03 10/31/2012 13 CLEANED UNIT AND REPLACED TRICO MECHANICAL SER 103284 2941 1,980.68 TOTAL PERIOD 07 ACTIVITY 3,171.82 0.00 08 AP-121210 12/04/2012 05 POLICY RENEWAL CASTLE INSURANCE SER 103293 452553 568.00 12/04/2012 06 COPIER CHARGES KONICA MINOLTA BUSIN 103298 222870220 23.17 12/04/2012 07 ANNUAL SERVICES AGREEMENT FOR SOUND INCORPORATED 103304 R117903 291.00 12/04/2012 08 NOVEMBER ELEVATOR MAINTENANCE THYSSENKRUPP ELEVATO 103305 3000282596 218.03 12/04/2012 09 OCTOBER 8 MEETING MINUTES MARLYS J. YOUNG 103310 100812 74.25 GJ-121220 12/20/2012 03 WIRE FEES - 2 BOND PMTS 1 FUND 55.00 TOTAL PERIOD 08 ACTIVITY 1,229.45 0.00 YTD BUDGET 19,333.36 TOTAL ACCOUNT ACTIVITY 15,819.84 0.00 ANNUAL REVISED BUDGET 29,000.00 ENDING BALANCE 15,819.84 GRAND TOTAL 136,126.63 0.00 TOTAL DIFFERENCE 136,126.63 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 2013-02 Agenda Item Summary Memo Title: Treasurer's Reports for November&December 2012 Meeting and Date: Administration Committee—January 17, 2013 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 November 30,2012 Cash Basis %of %of Projected Beginning November Revenues YTD November Expenses YTD Ending Fund Fund Balance Revenues YTD Revenues Budget Budget Expenses YTD Expenses Budget Budget Balance General Fund 01-General 1,270,623 713,604 8,964,246 12,311,109 73% 681,330 5,600,040 11,379,867 49% 4,634,829 Special Revenue Funds 15-Motor Fuel Tax 924,857 73,938 352,405 454,547 78% 1,078 45,735 573,860 8% 1,231,526 79-Parks and Recreation 280,065 93,315 945,919 1,451,447 65% 86,300 804,286 1,506,767 53% 421,698 72-Land Cash (294,778) 6,153 42,103 420,500 10% 13,416 49,846 323,825 15% (302,520) 87-Countryside TIF 1,877,872 287 1,783 6,500 27% 242,500 306,487 306,043 100% 1,573,168 88-Downtown TIF 257,953 1,817 40,163 70,150 57% 2,682 15,884 41,500 38% 282,232 11-Fox Hill SSA 17,071 44 3,792 3,786 100% 529 3,772 4,500 84% 17,091 12-Sunflower SSA 12,188 98 7,537 7,531 100% 3,512 11,414 9,986 114% 8,311 Debt Service Fund 42-Debt Service 87,510 14,587 386,984 427,144 91% 76,781 142,073 505,370 28% 332,421 Capital Funds 16-Municipal Building (579,374) 1,350 8,509 5,250 162% 450 3,150 - - (574,015) 22-Park and Recreation Capital 62,473 345 3,137 43,500 7% 208 7,897 52,500 15% 57,713 20-Police Capital 229,238 2,445 26,908 29,200 92% 32,719 151,145 60,000 252% 105,001 21-Public Works Capital 62,884 8,227 43,520 53,500 81% 9,203 64,319 169,795 38% 42,085 23-City-Wide Capital 81,196 42,930 290,727 1,303,732 22% 13,501 118,651 1,040,500 11% 253,272 Enterprise Funds 51-Water 1,300,837 45,478 1,817,927 2,801,379 65% 119,597 1,520,134 3,085,983 49% 1,598,630 52-Sewer 3,003,537 310,428 1,254,294 1,639,817 76% 46,619 569,903 1,895,210 30% 3,687,928 80-Recreation Center (220,001) 44,381 318,624 622,500 51% 42,803 378,253 703,633 54% (279,630) Library Funds 82-Library Operations 388,831 15,859 755,812 817,634 92% 48,096 403,945 794,413 51% 740,698 83-Library Debt Service (1,821) 14,680 793,626 797,299 100% - 177,744 795,488 22% 614,061 84-Library Capital 6,794 3,451 24,253 16,350 148% 3,690 5,592 13,474 42% 25,455 Total Funds 8,767,955 1,393,416 16,082,269 23,282,875 69% 1,425,015 10,380,271 23,262,714 45% 14,469,953 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 UNITED CITY OF YORKVILLE TREASURER'S REPORT - for the period ending December 31,2012 Cash Basis %of %of Projected Beginning December Revenues YTD December Expenses YTD Ending Fund Fund Balance Revenues YTD Revenues Budget Budget Expenses YTD Expenses Budget Budget Balance General Fund 01 -General 1,270,623 1,073,250 10,037,496 12,311,109 82% 701,823 6,301,863 11,379,867 55% 5,006,256 Special Revenue Funds 15-Motor Fuel Tax 924,857 36,915 389,320 454,547 86% 68,870 114,605 573,860 20% 1,199,572 79-Parks and Recreation 280,065 86,923 1,032,842 1,451,447 71% 98,123 902,409 1,506,767 60% 410,498 72-Land Cash (294,778) - 42,103 420,500 10% 901 50,747 323,825 16% (303,422) 87-Countryside TIF 1,877,872 285 2,068 6,500 32% 48 306,535 306,043 100% 1,573,405 88-Downtown TIF 257,953 53 40,216 70,150 57% 10,920 26,804 41,500 65% 271,365 11 -Fox Hill SSA 17,071 1 3,793 3,786 100% - 3,772 4,500 84% 17,092 12-Sunflower SSA 12,188 2 7,538 7,531 100% - 11,414 9,986 114% 8,312 Debt Service Fund 42-Debt Service 87,510 8,388 395,372 427,144 93% 362,922 504,995 505,370 100% (22,112) Capital Funds 16-Municipal Building (579,374) 150 8,659 5,250 165% - 3,150 - - (573,865) 22-Park and Recreation Capital 62,473 49 3,186 43,500 7% 208 8,106 52,500 15% 57,553 20-Police Capital 229,238 812 27,720 29,200 95% 2,715 153,861 60,000 256% 103,097 21 -Public Works Capital 62,884 660 44,181 53,500 83% 7,446 71,765 169,795 42% 35,299 23-City-Wide Capital 81,196 40,472 331,199 1,303,732 25% 12,611 131,262 1,040,500 13% 281,133 Enterprise Funds 51 -Water 1,300,837 411,108 2,229,035 2,801,379 80% 787,658 2,307,792 3,085,983 75% 1,222,080 52-Sewer 3,003,537 131,235 1,385,528 1,639,817 84% 700,966 1,270,869 1,895,210 67% 3,118,196 80-Recreation Center (220,001) 39,006 357,630 622,500 57% 40,567 418,820 703,633 60% (281,191) Library Funds 82-Library Operations 388,831 5,279 761,091 817,634 93% 55,203 459,148 794,413 58% 690,774 83-Library Debt Service (1,821) 36 793,662 797,299 100% 617,744 795,488 795,488 100% (3,647) 84-Library Capital 6,794 151 24,404 16,350 149% 2,131 7,723 13,474 57% 23,475 Total Funds 8,767,955 1,834,775 17,917,043 23,282,875 77% 3,470,855 13,851,126 23,262,714 60% 12,833,872 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 2013-03 Agenda Item Summary Memo Title: Cash Statement for October&November 2012 Meeting and Date: Administration Committee—January 17, 2013 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 October 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 442,444 7,195 56,790 2,219,258 2,725,687 2,389 15,760 50 18,199 2,743,886 Special Revenue Funds 15-Motor Fuel Tax - - - - - - 1,125,707 1,125,707 1,125,707 72-Land Cash (295,248) - (295,248) - - - (295,248) 87-Countryside TIF 150,125 - 971,321 1,121,446 693,936 693,936 1,815,382 88-Downtown TIF 114,028 972 168,097 283,097 - - 283,097 11-Fox Hill SSA 15,117 75 2,384 17,576 17,576 12-Sunflower SSA 6,754 94 4,876 11,724 11,724 Debt Service Fund 42-Debt Service 141,505 7,606 245,504 394,615 394,615 Capital Funds 16-Municipal Building (571,915) - - (571,915) (571,915) 20-Police Capital 134,618 134,618 134,618 21-Public Works Capital 55,804 55,804 - - 55,804 23-City-Wide Capital 242,298 - - - 242,298 55,967 55,967 298,265 Enterprise Funds 51-Water 334,680 10,965 3,110 784,908 1,133,663 - - 1,133,663 52-Sewer 217,961 3,368 6,149 2,848,527 3,076,005 3,076,005 Agency Funds 90-Developer Escrow 144,786 - - - 144,786 144,786 95-Escrow Deposit 276,974 13,509 - - 290,483 - - - - 290,483 Total City Funds 1,409,931 35,038 74,796 7,244,874 8,764,638 696,325 1,197,435 50 1,893,810 10,658,448 Distribution% 13.23% 0.33% 0.70% 67.97% 6.53% 0.00% 11.23% 0.00% Library Funds 82-Library Operations 449,904 - 40 - 449,943 - - 333,243 25 333,268 783,211 83-Library Debt Service - 599,380 599,380 - - - - 599,380 84-Library Capital 3,500 - 3,500 19,694 - 19,694 23,194 Totals 453,404 599,420 1,052,824 19,694 333,243 25 352,962 1,405,785 Distribution% 32.25% 42.64% 1.40% 23.71% Park and Recreation Funds 79-Parks and Recreation - 451,335 - 451,335 - - 25 25 451,361 22-Park&Rec Capital 300 55,800 56,100 148,208 148,208 204,309 80-Recreation Center - (276,913) (276,913) - - - (276,913) Totals 300 230,223 230,523 148,208 25 148,234 378,757 Distribution% 60.78% 39.13% 0.01% UNITED CITY OF YORKVILLE CASH AND INVESTMENT SUMMARY-as of November 30,2012 CASH Cash-Operations Cash-Special Purpose IL Funds Operations Aurora Special Purpose Grand Old Second Castle E-Pay IL Funds IMET Totals Old Second IMET Earthmovers Totals Totals General Fund 01-General 486,302 8,694 101,430 2,219,899 2,816,325 1,412 15,765 50 17,227 2,833,552 Special Revenue Funds 15-Motor Fuel Tax - - - - - - 1,198,419 1,198,419 1,198,419 72-Land Cash (302,511) - - (302,511) - - - (302,511) 87-Countryside TIF (92,370) - - 971,602 879,232 693,936 693,936 1,573,168 88-Downtown TIF 111,350 - 2,736 168,146 282,232 - - 282,232 11-Fox Hill SSA 14,589 - - 118 2,384 17,091 17,091 12-Sunflower SSA 3,243 - - 191 4,877 8,311 8,311 Debt Service Fund 42-Debt Service 73,243 - - 13,603 245,575 332,421 332,421 Capital Funds 16-Municipal Building (570,115) - - - - (570,115) (570,115) 20-Police Capital 104,345 - - 104,345 104,345 21-Public Works Capital 60,099 - - 60,099 - - 60,099 23-City-Wide Capital 296,021 - - - - 296,021 55,983 55,983 352,005 Enterprise Funds 51-Water 464,321 - 13,906 5,562 785,134 1,268,924 - - 1,268,924 52-Sewer 529,375 - 4,272 10,997 2,849,350 3,393,993 3,393,993 Agency Funds 90-Developer Escrow 140,507 - - - - 140,507 140,507 95-Escrow Deposit 182,859 - 17,133 - - 199,992 - - - - 199,992 Total City Funds 1,501,258 - 44,005 134,637 7,246,966 8,926,866 695,348 1,270,168 50 1,965,566 10,892,431 Distribution% 13.78% 0.40% 1.24% 66.53% 6.38% 11.66% 0.00% Library Funds 82-Library Operations 417,571 - - 40 - 417,610 - 333,339 25 333,364 750,974 83-Library Debt Service - 614,060 614,060 - - - - 614,060 84-Library Capital 3,450 - - 3,450 19,505 - 19,505 22,955 Totals 421,021 614,100 1,035,120 19,505 333,339 25 352,869 1,387,990 Distribution% 30.33% 44.24% 1.41% 24.02% Park and Recreation Funds 79-Parks and Recreation - 458,450 - 458,450 - - 25 25 458,475 22-Park&Rec Capital 300 55,894 56,194 148,251 148,251 204,446 80-Recreation Center - (275,335) (275,335) - - - (275,335) Totals 300 239,009 239,309 148,251 25 148,276 387,585 Distribution% 0.08% 61.67% 38.25% 0.01% 0 CIP Reviewed By: Agenda Item Number J� $ 06 Legal ❑ NB #4 Finance ESL -� 1836 Engineer ❑ -_� City Administrator ■ Tracking Number .4 City y Human Resources El� wn sw _© Community Development ❑ ADM 2013-04 � Police ❑ Public Works ❑ Parks and Recreation ❑ Agenda Item Summary Memo Title: Local Debt Recovery Program Meeting and Date: Administration Committee—January 17, 2013 Synopsis: See attached memo. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Majority Council Action Requested: Approval Submitted by: Rob Fredrickson Finance Name Department Agenda Item Notes: Memorandum To: Administration Committee EST. 1 _ 1836 From: Rob Fredrickson, Finance Director O6 Date: December 12, 2012 9 Boa, =p Subject: Local Debt Recovery Program (LDRP) KantlaElCOUnry <LE The Local Debt Recovery Program (LDRP),which was signed into law in December of 2011 (PA 097-0632), allows for the Illinois Office of the Comptroller(IOC) to enter into an intergovernmental agreement with local governments to collect unpaid debts such as parking tickets, fines, fees and outstanding utility bills. A summary of how the LDRP works is as follows: • The City would transfer debtor information to the Comptroller's Office via the internet. • The Comptroller's Office would then withhold any amounts due to the City from the debtor's state tax refund, lottery proceeds, retirement/payroll check(state employees) or commercial payments. All withheld funds (plus a $15 administrative fee—paid by the debtor)would be deposited into the Comptroller's Local Debt Recovery Trust Fund. • The debtor would be provided written notice of the action and have 60 days to protest the deduction with the Comptroller's Office. • If no protest is made at the end of the 60 day period, the amount owed would be transferred via ACH directly into the City's bank account. In an effort to enhance collection efforts, it is the recommendation of staff that the City participate in the Comptroller's Local Debt Recovery Program. In order to begin this process, staff is seeking authorization to enter into an intergovernmental and non-disclosure agreement with the Illinois Comptroller's Office. These agreements, along with an informational packet about the program provided by the IOC, are attached for your review and consideration. LOCAL DEBT ECOVERY STATE OF ILLINOIS COMPTROLLER JUDY BAARTOPINKA A PARTNERSHIP WITH LOCAL GOVERNMENTS Updated 3 1812012 LOCAL DEBT RECOVERY PROGRAM THE PROGRAM Under a measure signed into law in December of 2011, the Local Debt Recovery Program will allow the Illinois Office of the Comptroller to enter into an Intergovernmental Agreement (IGA) with counties, municipalities, school districts, community colleges, public universities and other local governments to collect unpaid debt such as parking tickets, fines, fees, and other types of outstanding obligations. HOW IT WORKS • Prior to the Comptroller issuing a state tax refund, commercial payment, lottery winning, retirement or payroll check, the amount owed to the local government plus an administrative fee will be deducted and deposited in the Comptroller's Local Debt Recovery Trust Fund. • The debtor will be provided with a written notice of the action and has 60 days to protest the deduction with the Illinois Office of the Comptroller. • If no protest is made at the end of the 60 day period, the amount owed will be transferred to the local unit of government. • Other payments will be processed as protests are adjudicated. • Payments to local units of government will be made on a weekly basis and will be consolidated to include all debts owed to the unit of government for that week. • The same laws governing involuntary withholdings apply to the Local Debt Recovery Program. Contact the Illinois Office of the Comptroller's Government and Community Affairs Department for more information at (312) 814-2488. Updated 31812012 LOCAL DEBT RECOVERY PROGRAM FREQUENTLY ASKED QUESTIONS Is there a maximum amount that can be deducted from tax refunds, commercial payments and state payroll checks? 100% of debt owed can be deducted from tax refunds, lottery winnings and commercial payment checks. However, if a local debt exists from an individual who receives a state payroll check, no more than 25% of the employee's disposable income (i.e. net income) can be deducted. Local governments may submit claims for the entire amount owed and the Illinois Office of the Comptroller will compute the amount available for debt recovery. Are any types of state checks exempt from the Local Debt Recovery Program? Yes, Senior Circuit Breaker, Secretary of State Refund, Illinois Pre-Paid Tuition Trust Fund payments are exempt from the Local Debt Recovery Program as well as any other payments exempt by statute. Is there a cost to the local government for participating in the Local Debt Recovery program? No. The program is funded by an administrative fee paid by the individual who owes the debt. The program will involve some of the local government's staff time to submit debtor records to the Office of the Comptroller and maintain debtor records after debt as been recovered. Will Local Debt Recovery Program payments be late like other State of Illinois payments? No. Once a debt is deducted from a state payment, the amount is transferred into the Local Debt Recovery Trust Fund where it will be held for 60 days during the appeals process. If no appeal is made, the amount with be transferred out of the fund at the end of the 60-day period. Payments will be made on a weekly basis. If an appeal is made and the debtor's appeal is rejected, the amount owed to the local government will be transferred out of the Local Debt Recovery Trust Fund after the determination on the appeal is made. Updated 31812012 LOCAL DEBT RECOVERY PROGRAM FREQUENTLY ASKED QUESTIONS Is there an order of who gets paid first when multiple debts exist? If an individual or entity owes multiple units of government, state and federal government debts are paid first. Following that, any debts owed to local governments will be paid on a "first in, first out" manner based on the date that a debt record was placed on the IOC system (through the Maintenance Add process). Can debt collection agencies assist municipalities with managing debt records for the Comptroller's Local Debt Recovery Program? While all information (debt records, etc) provided to the Illinois Office of the Comptroller must come from the Local Claiming Entity (LCE); a collection agency can assist the LCE with preparation and maintenance of debt records. Can a municipality provide the collection agency phone number in place of a municipal phone number if debtors have questions about a specific debt? No. The phone number can't be a collection agency line. It needs to be a customer service line within the LCE office. Updated 31812012 LOCAL DEBT RECOVERY PROGRAM STATUTE: PA 097-0632 Public Act 097-0632 (1-11130384 Enrolled) AN ACT concerning State government. Be it enacted by the People of the State of Illinois, represented in the General Assembly: Section 5. The State Comptroller Act is amended by changing Section 10.05 and by adding Section 10.05d as follows: (15 ILCS 405/10.05) (from Ch. 15, par. 210.05) Sec. 10.05. Deductions from warrants; statement of reason for deduction. Whenever any person shall be entitled to a warrant or other payment from the treasury or other funds held by the State Treasurer, on any account, against whom there shall be any then due and payable account or claim in favor of the State, or to the United States upon certification by the Secretary of the Treasury of the United States, or his or her delegate, pursuant to a reciprocal offset agreement under subsection (i-1) of Section 10 of the Illinois State Collection Act of 1986, or a unit of local government, a school district, or a public institution of higher education, as defined in Section 1 of the Board of Higher Education Act, upon certification by that entity then due and payable, the Comptroller, upon notification thereof, shall ascertain the amount due and payable to the State, or to the United States, the unit of local government, the school district, or the public institution of higher education, as aforesaid, and draw a warrant on the treasury or on other funds held by the State Treasurer, stating the amount for which the party was entitled to a warrant or other payment, the amount deducted therefrom, and on what account, and directing the payment of the balance; which warrant or payment as so drawn shall be entered on the books of the Treasurer, and such balance only shall be paid. The Comptroller may deduct any one or more of the following: (i) the entire amount due and payable to the State or may deduct a portion of the amount due and payable to the State in accordance with the request of the notifying agency; Updated 31812012 LOCAL DEBT RECOVERY PROGRAM STATUTE: PA 097-0632 (ii) , and may deduct the entire amount due and payable to the United States, or may deduct a portion of the amount due and payable to the United States, in accordance with a reciprocal offset agreement under sub- section (i-1) of Section 10 of the Illinois State Collection Act of 1986; or (iii) the entire amount due and payable to the unit of local government, school district, or public institution of higher education or a portion of the amount due and payable to that entity in accordance with an intergovernmental agreement authorized under this Section and Section 10.05d. No request from a notifying agency, or from the Secretary of the Treasury of the United States, a unit of local government, a school district, or a public institution of higher education for an amount to be deducted under this Section from a wage or salary payment, or from a contractual payment to an individual for personal services, shall exceed 25% of the net amount of such payment. "Net amount" means that part of the earnings of an individual remaining after deduction of any amounts required by law to be withheld. For purposes of this provision, wage, salary or other payments for personal services shall not include final compensation payments for the value of accrued vacation, overtime or sick leave. Whenever the Comptroller draws a warrant or makes a payment involving a deduction ordered under this Section, the Comptroller shall notify the payee and the State agency that submitted the voucher of the reason for the deduction and he or she shall retain a record of such statement in his or her records. As used in this Section, an "account or claim in favor of the State" includes all amounts owing to "State agencies" as defined in Section 7 of this Act. However, the Comptroller shall not be required to accept accounts or claims owing to funds not held by the State Treasurer, where such accounts or claims do not exceed $50, nor shall the Comptroller deduct from funds held by the State Treasurer under the Senior Citizens and Disabled Persons Property Tax Relief and Pharmaceutical Assistance Act or for payments to institutions from the Illinois Prepaid Tuition Trust Fund (unless the Trust Fund moneys are used for child support). The Comptroller and the Department of Revenue shall enter into an interagency agreement to establish responsibilities responsibility, duties, and procedures relating to deductions from lottery prizes awarded under Section 20.1 of the Illinois Lottery Law. Updated 31812012 LOCAL DEBT RECOVERY PROGRAM STATUTE: PA 097-0632 The Comptroller may enter into an intergovernmental agreement with the Department of Revenue and the Secretary of the Treasury of the United States, or his or her delegate, to establish responsibilities, duties, and procedures relating to reciprocal offset of delinquent State and federal obligations pursuant to subsection (i-1) of Section 10 of the Illinois State Collection Act of 1986. The Comptroller may enter into intergovernmental agreements with any unit of local government, school district, or public institution of higher education to establish responsibilities, duties, and procedures to provide for the offset, by the Comptroller, of obligations owed to those entities. (Source: P.A. 97-269, eff. 1-1-12.) (15 ILCS 405/10.05d new) Sec. 10.05d. Deductions for delinquent obligations owed to units of local government, school districts, and public institutions of higher education. Pursuant to Section 10.05 and this Section, the Comptroller may enter into intergovernmental agreements with a unit of local government, a school district, or a public institution of higher education in order to provide for (i) the use of the Comptroller's offset system to collect delinquent obligations owed to that entity and (ii) the payment to the Comptroller of a processing charge of up to $15 per transaction for such offsets. The Comptroller shall deduct, from a warrant or other payment described in Section 10.05, in accordance with the procedures provided therein, its processing charge and the amount certified as necessary to satisfy, in whole or in part, the delinquent obligation owed to the unit of local government, school district, or public institution of higher education, as applicable. The Comptroller shall provide the unit of local government, school district, or public institution of higher education, as applicable, with the address to which the warrant or other payment was to be mailed and any other information pertaining to each person from whom a deduction is made pursuant to this Section. All deductions ordered under this Section and processing charges imposed under this Section shall be deposited into the Comptroller Debt Recovery Trust Fund, a special fund that the Comptroller shall use for the collection of deductions and processing charges, as provided by law, and the payment of deductions and administrative expenses, as provided by law. Updated 31812012 LOCAL DEBT RECOVERY PROGRAM STATUTE: PA 097-0632 Upon processing a deduction, the Comptroller shall give written notice to the person subject to the offset. The notice shall inform the person that he or she may make a written protest to the Comptroller within 60 days after the Comptroller has given notice. The protest shall include the reason for contesting the deduction and any other information that will enable the Comptroller to determine the amount due and payable. The intergovernmental agreement entered into under Section 10.05 and this Section shall establish procedures through which the Comptroller shall determine the validity of the protest and shall make a final disposition concerning the deduction. If the person subject to the offset has not made a written protest within 60 days after the Comptroller has given notice or if a final disposition is made concerning the deduction, the Comptroller shall pay the deduction to the unit of local government, school district, or public institution of higher education, as applicable, from the Comptroller Debt Recovery Trust Fund. Section 10. The Illinois Income Tax Act is amended by changing Section 911.3 as follows: (35 ILCS 5/911.3) Sec. 911.3. Refunds withheld; order of honoring requests. The Department shall honor refund withholding requests in the following order: (1) a refund withholding request to collect an unpaid State tax; (2) a refund withholding request to collect certified past due child support amounts under Section 2505-650 of the Department of Revenue Law of the Civil Administrative Code of Illinois; (3) a refund withholding request to collect any debt owed to the State; (4) a refund withholding request made by the Secretary of the Treasury of the United States, or his or her delegate, to collect any tax liability arising from Title 26 of the United States Code; (4.5) a refund withholding request made by the Secretary of the Treasury of the United States, or his or her delegate, to collect any nontax debt owed to the United States as authorized under subsection (i-1) of Section 10 of the Illinois State Collection Act of 1986; Updated 31812012 LOCAL DEBT RECOVERY PROGRAM STATUTE: PA 097-0632 (4.6) a refund withholding request to collect any debt owed to a unit of local government, school district, or public institution of higher education collected under an intergovernmental agreement entered into under Sections 10.05 and 10.05d of the State Comptroller Act; (5) a refund withholding request pursuant to Section 911.2 of this Act; and (6) a refund withholding request to collect certified past due fees owed to the Clerk of the Circuit Court as authorized under Section 2505-655 of the Department of Revenue Law of the Civil Administrative Code of Illinois. (Source: P.A. 97-269, eff. 1-1-12.) Section 15. "An Act concerning State government", approved August 8, 2011, Public Act 97-269, is amended by adding Section 99 as follows: (P.A. 97-269, Sec. 99 new) Sec. 99. Effective date. This Act (Public Act 97-269) takes effect on the effective date of this amendatory Act of the 97th General Assembly or January 1, 2012, whichever is earlier. Section 99. Effective date. This Act takes effect upon becoming law. Updated 31812012 INTERGOVERNMENTAL AGREEMENT BY AND BETWEEN THE ILLINOIS OFFICE OF THE COMPTROLLER AND THE UNITED CITY OF YORKVILLE REGARDING ACCESS TO THE COMPTROLLER'S LOCAL DEBT RECOVERY PROGRAM This Intergovernmental Agreement ("the Agreement") is hereby made and entered into as of the date of execution by and between the Illinois Office of the Comptroller(hereinafter "IOC") and the United City of Yorkville (hereinafter"the local unit"), in order to provide the named local unit access to the Local Debt Recovery Program for purposes of collecting both tax and nontax debts owed to the named local unit. Each of the parties hereto is a"public agency" as defined in Section 2 of the Intergovernmental Cooperation Act [5 ILCS 220/2]. WHEREAS, both the State of Illinois and the local unit have a responsibility to collect debts owed to its respective public bodies; WHEREAS, IOC operates a system, known as the Comptroller's Offset System (hereinafter, "the System"), for collection of debt owed the State by persons receiving payments from the State; WHEREAS, the Illinois General Assembly specifically provided for the ability of the local unit to utilize the System when it amended Section 10.05 and added Section 10.05d to the State Comptroller Act [P.A. 97-632; 15 ILCS 405/10.05 and 10.05d]; WHEREAS, IOC and the local unit are empowered under the Illinois Constitution [Ill. Const., Art. VII, Sec. 10], Section 3 of the Intergovernmental Cooperation Act [5 ILCS 220/3], and Section 10.05d of the State Comptroller Act(hereinafter, "the Act") [15 ILCS 405/10.05d] to contract with each other in any manner not prohibited by law; NOW THEREFORE, in consideration of the foregoing recitals and the mutual covenants and promises contained herein, the sufficiency of which is hereby acknowledged, the parties do hereby agree as follows: Article I—Purpose The purpose of the Agreement between the IOC and the local unit is to establish the terms and conditions for the offset of the State's tax and nontax payments in order to collect tax and nontax debts owed to the local unit. Article II—Authority The authority for State payment offset is granted under Section 10.05 of the Act [15 ILCS 405/10.05] and the authority for entering into this Agreement is granted under Section 1 10.05d of the Act [15 ILCS 405/10.05d], Section 3 of the Intergovernmental Cooperation Act [5 ILCS 220/3], and Article VII of the Illinois Constitution [Ill. Const., Art. VII, Sec. 10]. Article III— State Payment Offset Requirements and Operations A. Legal_ Requirements. The offset of State payments shall be conducted pursuant to the authority granted in Section 10.05 and 10.05d of the Act [15 ILCS 405/10.05 and 10.05d] and the requirements set forth in this Agreement. 1. Definition of"Debt" (a) For purposes of this Agreement, debt shall mean any monies owed to the local unit which is less than 7 years past the date of final determination, as confirmed by the local unit in Article III(A)(2)(a)(viii) of this Agreement. (b) No debt which is more than 7 years past the date of final determination may be placed or may remain on the System. 2. Due Process &Notification (a) Before submitting a debt to IOC for State payment offset, the local unit must comply with all of the notification requirements of this Agreement. For purposes of this Agreement, notification of an account or claim eligible to be offset shall occur when the local unit submits to IOC the following information: (i) the name and address and/or another unique identifier of the person against whom the claim exists; (ii) the amount of the claim then due and payable to the local unit; (iii) the reason why there is an amount due to the local unit(i.e., tax liability, overpayment, etc.); (iv) the time period to which the claim is attributable; (v) the local entity to which the debt is owed; (vi) a description of the type of notification has been given to the person against whom the claim exists and the type of opportunity to be heard afforded to such a person; (vii) a statement as to the outcome of any hearings or other 2 proceedings held to establish the debt, or a statement that no hearing was requested; and, (viii) the date of final determination of the debt. (b) IOC will not process a claim under the Agreement until notification has been received from the local unit that the debt has been established through notice and opportunity to be heard. (c) The local unit is required to provide the debtor with information about a procedure to challenge the existence, amount, and current collectability of the debt prior to the submission of a claim to IOC for entry into the System. The decision resulting from the utilization of this procedure must be reviewable. 3. Certification (a) The chief officer of the local unit must, at the time the debt is referred, certify that the debt is past due and legally enforceable in the amount stated, and that there is no legal bar to collection by State payment offset(See Appendix A). (b) Only debts finally determined as currently due and payable may be certified to IOC as a claim for offset. (c) The chief officer of the local unit may delegate to a responsible person or persons the authority to execute the statement of the claim required by the Agreement. (d) This delegation of authority shall be made on forms provided by the Comptroller and shall contain a signature sample of the person(s) to whom the delegation is made. (e) For purposes of this Agreement, "chief officer of the local unit" means the City's Finance Director. 4. Notification of Change in Status (a) The chief officer must notify IOC as soon as possible, but in no case later than 30 days, after receiving notice of a change in the status of an offset claim. (b) A change in status may include, but is not limited to,payments received other than through a successful offset, the filing of a bankruptcy petition, the death of the debtor, or the expiration of the 3 ability for the debt to remain on the System, as provided for in Article III(A)(1)(b) of this Agreement. B. Operational Requirements. Upon receiving a data file from the chief officer pursuant to the terms of this this Agreement, IOC will perform a match with the local unit's debt file using a debtor's social security number, taxpayer identification number, name, address, or other unique identifier. The chief officer will receive a weekly file from IOC indicating the matches, at which time the local unit will update its debtor records. The chief officer will assume the responsibility of providing updates to the debtor records on file with IOC in order to ensure an equitable resolution of the debts owed to the local unit. 1. Technical Requirements. IOC agrees to work with the local unit to facilitate information and data procedures as provided for in this Agreement. The local unit agrees to adhere to the standards and practices of IOC when transmitting and receiving data. 2. Fee. A fee shall be charged to the debtor in order to recover the cost to IOC for administrating the System. The fee shall be per payment transaction and shall be $15,unless the payment is for an amount less than $30, in which case the fee shall be equal to the amount offset. The fee will be deducted from the payment to be offset prior to issuance to the local unit. 3. Offset Notices. IOC will send offset notices to the debtor upon processing a claim under the Act and this Agreement. The notice will state that a request has been made to make an offset against a payment due to the debtor, identify the local unit as the entity submitting the request, provide the debtor with a phone number made available pursuant to Article III (13)(6) of this Agreement, and inform the debtor that they may formally protest the offset within sixty(60) days of the written notice. 4. IOC Protest Process. If a protest is received, IOC will determine the amount due and payable to the local unit. This determination will be made by a Hearing Officer and will be made in light of all information relating to the transaction in the possession of IOC and any other information IOC may request and obtain from the local unit and the debtor subject to the offset. If IOC requests information from the local unit relating to the offset, the local unit will respond within sixty(60) days of IOC's request. IOC may grant the local unit an additional sixty(60) day extension for time to respond. 5. IOC Hearing Officer. The local unit hereby agrees to provide the Hearing Officer with any information requested in an efficient and timely manner in order to facilitate the prompt resolution to protests filed as a result of this Agreement. For purposes of this Agreement, any decision rendered 4 by the Hearing Officer shall be binding on the local unit and shall be the final determination on the matter. The Hearing Officer may continue the review of a protest at his/her discretion in order to assure an equitable resolution. 6. Local Unit Call Center. The local unit hereby agrees to provide a working phone number which IOC will furnish to persons offset under this Agreement. The local unit shall ensure that the phone number is properly staffed in order to provide information about the debt the local unit is offsetting under this Agreement. The phone number for purposes of this Section and the Agreement is: 630-553-8534. 7. Debt Priorities (a) If a debtor has more than one local unit debt, the debt with the oldest date of delinquency shall be offset first. (b) Any debt that is less than or equal to $9.99 which is placed or remains on the System will not be offset and will not be paid to the local unit until such time as the balance owed to the local unit by the debtor exceeds $9.99. 8. Transfer of Pam Transfer of payment by IOC to the local unit shall be made in the form of electronic funds transfer(EFT). Nothing in this section or this Agreement shall limit the ability of either party to modify this Agreement at a later date in order to provide for an alternative method(s) of payment transfer. 9. IOC Refunds. If IOC determines that a payment is erroneous or otherwise not due to the local unit, IOC will process a refund of the offset, and refund the amount offset to the debtor. In the event the refund results in only a partial refund to the debtor, IOC will retain the fee referenced in Article III, Paragraph B, Section 2 above. The fee will only be refunded to the debtor in the event of a full refund of the offset amount. 10. Local Unit Refunds. The local unit is responsible for refunding monies to the debtor if an offset occurred due to inaccurate debt information or over collection, and the local unit has already received payment from IOC. IOC will only refund monies in the event that a payment has not yet been made to the local unit. Article IV—Permissible Use of Information IOC acknowledges that the local unit is providing sensitive information about local debts for the purpose of conducting offsets under the Agreement. As such, IOC will use the 5 information solely in connection with the Local Debt Recovery Program. IOC shall safeguard the local information in the same manner as it protects State debt information. The local unit acknowledges that IOC is providing sensitive information about State payments for the purpose of conducting offsets under the Agreement. As such,the local unit will use the information solely in connection with the Local Debt Recovery Program. The local unit shall safeguard State information in the same manner as it protects local debt information. The parties may use information in any litigation involving the parties, when such information is relevant to the litigation. Article V—Term of the Agreement and Modifications The Agreement becomes effective as of the Effective Date and shall remain in effect until it is terminated by one of the parties. Either party may terminate this Agreement by giving the other party written notice at least thirty(30) days prior to the effective date of the termination. Any modifications to the Agreement shall be in writing and signed by both parties. Article VI—No Liability to Other Parties Except for the fees described in Article III, paragraph B, Section 2 above, each party shall be responsible for its own costs incurred in connection with the Agreement. Each party shall be responsible for resolving and reconciling its own errors,but shall not be liable to any other parties for damages of any kind as a result of errors. Each party shall be liable for the acts and omissions of its own employees and agents. The Agreement does not confer any rights or benefits on any third party. Article VII—Issue Resolution The parties acknowledge that IOC is ultimately responsible for the development, design and operation of the System. Subject to that understanding, the parties agree to work cooperatively to resolve any matters that arise during the development, design and implementation of the program. If an issue cannot be resolved informally by mutual agreement of staff personnel, then the parties agree to elevate the issue to a senior level manager for resolution of the issue. For purposes of the Agreement,the "senior level managers" are: 1. IOC: Ray Marchiori, Director—Department of Government and Community Affairs 2. Local Unit: Bart Olson, City Administrator Article VIII—Contacts 6 The points of contacts for this Agreement are: IOC: Alissa Camp, General Counsel Illinois Office of the Comptroller 325 West Adams Springfield, Illinois 62704 Phone: 217/782-6000 Fax: 217/782-2112 E-mail: CampAJ @mail.ioc.state.il.us Local Unit: Kathleen Field Orr Kathleen Field Orr&Associates 53 West Jackson Blvd. Suite 935 Chicago, Illinois 60604 Phone: 312-382-2113 Fax: 312-382-2127 E-mail: kfo @kfoassoc.com Article IX—Acceptance of Terms and Commitment The signing of this document by authorized officials forms a binding commitment between IOC and the United City of Yorkville. The parties are obligated to perform in accordance with the terms and conditions of this document, any properly executed modification, addition, or amendment thereto, any attachment, appendix, addendum, or supplemental thereto, and any documents and requirements incorporated by reference. By their signing, the signatories represent and certify that they possess the authority to bind their respective organizations to the terms of this document, and hereby do so. [Signature Page Follows] 7 IN WITNESS WHEREOF, the Illinois Office of the Comptroller and local unit by the following officials sign their names to enter into this agreement. ILLINOIS OFFICE OF THE COMPTROLLER By: Date: Name: Judy Baar Topinka Title: Comptroller The United City of Yorkville By: Date: Name: Bart Olson Title: City Administrator 8 Appendix A STATE OF ILLINOIS COMPTROLLER JUDY BAAR TOPINKA Involuntary Withholding Tape/File Certification Form Local Unit Name: Tape#/File Type: Record Count: Dollar Amount: Please mark the appropriate box: Q Add Tape/File • The debtor(s)has (have)been sent a notice that a claim has been established against said person thus giving the debtor the opportunity to appeal the determination of the existence and amount of the claim(s). • No hearing(s)was(were)requested or a hearing(s)was (were)held and the result(s)was(were)that the claim(s)was(were) found to be valid in the amount(s)referenced in the attached record. • The date(s) of the final determination of the debt(s)for each claim was prior to the date of submittal of the claim to IOC for Local Debt Recovery purposes. Q Change Tape/File • All change transactions contained on the enclosed tape/file meet the criteria for inclusion in the Local Debt Recovery Program. Q Delete Tape/File • All claims contained on the enclosed tape/file no longer meet the criteria for inclusion in the Local Debt Recovery Program, and should be removed from the Program. do hereby certify that all of the debts included on the tape/file are in compliance with the requirements of the State Comptroller Act [15 ILCS 405] and the Intergovernmental Agreement entered into between the above named local unit and the Illinois Office of the Comptroller. If I am submitting a facsimile or email signature, I hereby certify by so filing that the original signed document exists in my possession. Authorized Signature: Date: Local Unit: Phone#: 9 NON-DISCLOSURE AGREEMENT It is understood and agreed to that the Illinois Office of the Comptroller (hereinafter referred to as "the Discloser") and the United City of Yorkville (hereinafter referred to as "the Recipient") would like to exchange certain information that is considered confidential. To ensure the protection of such information and in consideration of the agreement to exchange said information, the parties agree as follows: 1. The confidential information to be disclosed by the Discloser under this Agreement ("Confidential Information") can be described as and includes: The executable package (titled"LDRP FDA.msi" and"Setup.exe"), any source code that may derive from the executable package, any help files or associated literature, and/or any other information obtained as a direct result of taking receipt of the executable package from the discloser. In addition to the above, Confidential Information shall also include, and the Recipient shall have a duty to protect, other confidential and/or sensitive information which is (a) disclosed by Discloser in writing and marked as confidential (or with other similar designation) at the time of disclosure; and/or (b) disclosed by Discloser in any other manner and identified as confidential at the time of disclosure and is also summarized and designated as confidential in a written memorandum delivered to Recipient within thirty(30) days of the disclosure. 2. Recipient shall use the Confidential Information only for the purpose of participating in the Local Debt Recovery Program. 3. Recipient shall limit disclosure of Confidential Information to within its own organization, and only to its directors, officers, and/or employees having a need to know and shall not disclose Confidential Information to any third party (whether an individual, corporation, or other entity)without the prior express written consent of the Discloser. 4. This Agreement imposes no obligation upon the Recipient with respect to any Confidential Information (a) that was in Recipient's possession before receipt from the Discloser; (b) is or becomes a matter of public knowledge through no fault of the Recipient; (c) is rightfully received by Recipient from a third party not owing a duty of confidentiality to the Discloser; or (d) is disclosed without a duty of confidentiality to a third party by, or with the authorization of, the Discloser. 5. The Discloser warrants that it has the right to make the disclosures under this Agreement. 6. This Agreement shall not be construed as creating, conveying, transferring, granting or conferring upon the Recipient any rights, license or authority in or to the information exchanged, except the limited right to use Confidential Information specified in paragraph 2. Furthermore and specifically, no license or conveyance of any intellectual property rights is granted or implied by this Agreement. 7. Neither party has an obligation under this Agreement to purchase any service, goods, or intangibles from the other party. Furthermore, both parties acknowledge and agree that the exchange of information under this Agreement shall not commit or bind either party to any present or future contractual relationship (except as specifically stated herein), nor shall the exchange of information be construed as an inducement to act or not to act in any given manner. 8. Neither party shall be liable to the other in any manner whatsoever for any decisions, obligations, costs or expenses incurred, changes in business practices, plans, organization, products, services, or otherwise, based on either party's decision to use or rely on any information exchanged under this Agreement. 9. If there is a breach or threatened breach of any provision of this Agreement, it is agreed and understood that Discloser shall have no adequate remedy in money or other damages and accordingly shall be entitled to injunctive relief, provided however, no specification in this Agreement of any particular remedy shall be construed as a waiver or prohibition of any other remedies in the event of a breach or threatened breach of this Agreement. 10. This Agreement states the entire agreement between the parties concerning the disclosure of Confidential Information and supersedes any prior agreements, understandings, or representations with respect to the disclosure of this specific confidential information. Any addition or modification to this Agreement must be made in writing and signed by authorized representatives of both parties. This Agreement is made under and shall be construed according to the laws of the State of Illinois, U.S.A. In the event that there is a breach of this agreement, any and all disputes must be settled in a court of competent jurisdiction in the circuit court of Sangamon County, State of Illinois, U.S.A. 11. This Agreement is supplemental to, and does not in any way modify, amend, or replace, any Intergovernmental Agreement between the two parties pertaining to participation in the Local Debt Recovery Program. Furthermore, the End User License Agreement ("EULA") accompanying the installation of the above referenced executable package is in addition to, and will not replace, modify, or amend, this Agreement. Any inconsistencies between the EULA and this Agreement shall be reconciled and governed by the terms set forth in this Agreement. 12. If any of the provisions of this Agreement are found to be unenforceable, the remainder shall be enforced as fully as possible and the unenforceable provision(s) shall be deemed modified to the limited extent required to permit enforcement of the Agreement as a whole. WHEREFORE, the parties acknowledge that they have read and understand this Agreement and by affixing their signatures to this document, hereby voluntarily accept the duties and obligations set forth herein. [Signature Page Follows] RECIPIENT OF CONFIDENTIAL INFORMATION—THE UNITED CITY OF YORKVILLE Name: Bart Olson Title: City Administrator Signature: Date: DISCLOSER—ILLINOIS OFFICE OF THE COMPTROLLER Name: Judy Baar Topinka Title: Comptroller Signature: Date: Reviewed By: Agenda Item Number 6 Legal ❑ NB #5 Finance ❑ EST. -� __ti 1838 Engineer ❑ -- City Administrator ■ Tracking Number Human Resources ❑ `=Q Community Development ADM 2013-05 Police ALE � Public Works ❑ Parks and Recreation ❑ Agenda Item Summary Memo Title: City Services Survey 2013 Meeting and Date: Administration Committee—January 17, 2013 Synopsis: Overview of changes to City Survey for 2013. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Majority Council Action Requested: Approval 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: January 9, 2013 C<wrMY Sad �LE ��'` Subject: Citizen Services Survey 2013 Summary: An overview of the proposed changes to the 2012 Yorkville Citizens Services Survey for 2013. Background: Last February, City Council approved for staff to send out a link and access code on each resident's water bill in order to allow them to take a City Services Survey. Over 500 responses were collected and analyzed, which allowed for the City Council and staff to better align their goals and address various needs of the public. This is something which we intend to do every year in order to track the change in responses over a period of time. Currently we are looking for the Administration Committee to approve these changes by the end of the month. We would like to then have the questions approved by City Council at the February 12th meeting which will allow us to place the link on the utility bill which goes out at the end of February. Responses would then be collected until mid-April and an analysis would follow in May. Analysis: Based on the comments from last year, a few changes should be made to the survey in order to allow for better communication from the residents to City Council. The following changes have been made and are accompanied with an explanation for the changes: 1. All dates were changed to reflect 2013 and references to Alderman Gilson were replaced with Alderman Koch. We intend for the survey collection to occur throughout March. 2. On Question 6 "What do you consider to be the major assets and advantages of living in Yorkville?" an option listed as "other"was added along with a textbox where individuals can type in their response. 3. In the section Titled"Public Information Outreach,"the following question was added as Question 13 along with a textbox to allow for comments as a response: "If you do not use any of the communication outlets described in the prior questions, what would be the best avenue to inform you of City issues, news, and events?" a. The results of last year's survey indicated a sizeable number of residents do not receive any form of information from the City. Therefore, it is felt this question will give us information which will allow us to better reach citizens with important information. 4. Removed Question 15 which asked if residents were okay with the City generating revenue from special events. 5. On Question 16 and 17, which both list various City events, "Go Green Environmental Fair" and "Share and Care Recycle Day"were both eliminated from the questions and "Ribs on the River," Halloween Egg Hunt, Outdoor Movie, and Easter Express were added. a. These were deleted because they no longer are City events and the other events were not included on the previous survey. 6. In the section Titled"City Events,"the following question was added as "Question 18" along with a textbox to allow for comments as a response: "Are there any types of special events you would like to see the City engage in?" a. This question was added as a potential method of generating new ideas for future special events which might be popular and could potentially be ways to bring in extra revenue for the City. 7. Question 23 "How many years have you lived in your current residence?"was changed to "How many years have you lived in Yorkville?" a. Based on last year's results a number of people stated they had lived in a certain residence for a short time but in Yorkville their whole lives. This new phrasing will allow for greater analysis of the citizen responses and improve some of our inferences. 8. Added a Question 30 which included a textbox for answers: "Is there any way in which this survey can be improved?" a. Adding this question will hopefully allow us to be able to make future changes to improve our survey based on citizen responses. Recommendation: Staff recommends administering the survey to residents as amended. United City of • 1 Welcome to the United City of Yorkville City Services Survey 2013.The City Council would like to know what you think about City services,and has commissioned this web survey to gather your opinions. This survey should take less than 15 minutes to complete. Please insert the passcode for the survey(on your utility bill,or obtained from City Hall). 1. What is your survey passcode? Page 1 United City of • 1 important?Which services are most 2. Please rate your satisfaction with each City service. Very Satisfied Satisfied Neutral Dissatisfied Very Dissatisfied N/A Quality of police services O O O O O O Response time of police O O O O O O services Maintenance of streets, O O O O O O sidewalks,and infrastructure City communication with O O O O O O public(not from elected officials) Communication with your O O O O O O elected officials Quality of customer service O O O O O O (any department) Flow of traffic/congestion O O O O O O management Quality of stormwater O O O O O O management system Quality of flood prevention O O O O O O Quality of water services O O O O O O Quality of wastewater O O O O O O services Quality of refuse, recycling, O O O O O O and yardwaste collection services Quality of parks O O O O O O Quantity of parks provided O O O O O O Quality of recreation O O O O O O programming offered Quantity of recreation O O O O O O classes offered Quality of special events O O O O O O offered Quality of customer service O O O O O O during building inspections Quality of property O O O O O O maintenance services (weeds, unsafe buildings, etc.) Comments: United City of • 1 3. Which three of the items listed below do you think should receive the most emphasis from City leaders over the next two years? (Choose the three most important) Quality of police services ❑ Maintenance of streets,sidewalks,and infrastructure City communication with public(not from elected officials) Communication with your elected officials Quality of customer service(any department) Flow of traffic/congestion management ❑ Quality of stormwater management system Quality of flood prevention Quality of water services ❑ Quality of wastewater services Quality of refuse, recycling,and yardwaste collection services Quality of parks Quantity of parks provided Quality of recreation programming offered Quantity of recreation classes offered Quality of special events offered Quality of customer service during building inspections ❑ Quality of property maintenance services(weeds, unsafe buildings,etc.) Comments: United City of • 1 4. Rank these City Council goals in order from most important (1) to least important (6): Most important out 2 3 4 5 Least important out of this group-1 of this group-6 Work on completion of O O O O O O unfinished subdivisions Attract commercial O O O O O O development Attract manufacturing and O O O O O O light industrial development Attract attainable housing O O O O O O for people at every stage of life Keep citizens informed on O O O O O O City government activities Expand cultural activities O O O O O O Comments: United City of • 1 Value of services? A L —) 5. Approximately 10 cents of each property tax dollar you pay goes to the City. The City's portion of property tax pays for the following services: Police, Public Works (street maintenance, snow plowing), Building, Zoning, Planning, Finance, Administration, and Parks and Recreation. The remaining 90 cents goes to the Library, County, Township, School District, Community College, Fire Protection, and Forest Preservation. Please rate your satisfaction with each item. Very Satisfied Satisfied Neutral Dissatisfied Very Dissatisfied N/A Value you receive for City O O O O O O tax dollars and fees Image of the City O O O O O O Quality of City services O O O O O O Quality of life in the City O O O O O O Comments 6. What do you consider to be the major assets and advantages of living in Yorkville? (check all that apply) Schools Location F-1 Shopping Transportation ❑ Housing Quality Housing Costs ❑ Residential Neighborhoods ❑ Friendliness of residents ElRecreational amenities Other(please specify) Page 5 United City of • 1 Police services Questions about police services 7. Please rate your satisfaction for each police service. Very Satisfied Satisfied Neutral Dissatisfied Very Dissatisfied N/A Visibility of police in your O O O O O O neighborhood Visibility of police in retail O O O O O O areas Efforts to prevent major O O O O O O crime Enforce traffic laws on O O O O O O major streets Enforce traffic laws in your O O O O O O neighborhood How quickly police respond O O O O O O Quality of non-enforcement O O O O O O services Comments 8. Which three of the public safety items listed below do you think should receive the most emphasis from City leaders over the next two years? (Choose the three most important) ❑ Visibility of police in your neighborhood Visibility of police in retail areas Efforts to prevent major crime ❑ Enforce traffic laws on major streets Enforce traffic laws in your neighborhood How quickly police respond ❑ Quality of non-enforcement services 9. Please read each statement below and rate your level of agreement or disagreement: Strongly Agree Agree Neutral Disagree Strongly disagree Yorkville is a good place to O O O O O raise kids. Yorkville is safer than O O O O O surrounding communities. United City of • 1 Public Works questions 10. Please rate your satisfaction for each public works service. Very Satisfied Satisfied Neutral Dissatisfied Very Dissatisfied N/A Maintenance of major City O O O O O O streets(i.e.Game Farm Road, Fox Road,Van Emmon Road) Maintenance of O O O O O O neighborhood streets (entrances to subdivisions, streets in front of your house) Maintenance of City O O O O O O sidewalks Maintenance of street signs O O O O O O Maintenance of City street O O O O O O lighting Snow removal on major O O O O O O streets Snow removal on O O O O O O neighborhood streets Mowing and trimming O O O O O O along major streets Cleanliness of streets and O O O O O O other public areas Comments 11. Which three of the public works items listed below do you think should receive the most emphasis from City leaders over the next two years? (Choose the three most important) Maintenance of major City streets(i.e. Game Farm Road, Fox Road,Van Emmon Road) Maintenance of neighborhood streets(entrances to subdivisions,streets in front of your house) ❑ Maintenance of City sidewalks Maintenance of street signs ❑ Maintenance of City street lighting Snow removal on major streets Snow removal on neighborhood streets ❑ Mowing and trimming along major streets Cleanliness of streets and other public areas United City of • 1 Page 8 United City of • 1 Information Public Outreach 12. Which of the following are/were your primary sources of information about City issues, services, and events? (check all that apply) City newsletter(discontinued) ❑ Website(includes audio/video files of City meetings) City facebook page City twitter account ❑ Utility bill inserts Govt Access TV(FVTV) ❑ Kendall County Record Beacon News Yorkville Patch WSPY Radio Contact with elected officials ElOther Other(please specify) 13. If you do not use any of the communication outlets described in the prior questions, what would be the best avenue to inform you of City issues, news, and events? °I Page 9 United City of • 1 14. Please rate your satisfaction with each item below: Very Satisfied Satisfied Neutral Dissatisfied Very Dissatisfied N/A Efforts to keep you informed O O O O O O about issues Quality of government O O O O O O access TV station Quality of website O O O O O O Quality of City facebook O O O O O O page Quality of City twitter O O O O O O account Quality of City newsletter O O O O O O (discontinued) Comments Page 10 United City of • 1 City events A -1-1 E 15. Please rate your satisfaction with how each event is run: Very Satisfied Satisfied Neutral Dissatisfied Very Dissatisfied N/A Hometown Days O O O O O O Holiday Under the Stars O O O O O O Music Under the Stars O O O O O O National Night Out O O O O O O Ribs on the River O O O O O O 5k runs(Tax Dodge,Chili O O O O O O Chase,etc.) Outdoor Movies O O O O O O Halloween Egg Hunt O O O O O O Easter Express O O O O O O Comments 16. Please rank the events, from your most favorite to least favorite. Second most Third most Third least Second least Most favorite The middle Least favorite favorite favorite favorite favorite Hometown Days O O O O O O O Holiday Under the Stars O O O O O O O Music Under the Stars O O O O O O O National Night Out O O O O O O O Ribs on the River O O O O O O O 5k runs(Tax Dodge,Chili O O O O O O O Chase) Outdoor Movies O O O O O O O Halloween Egg Hunt O O O O O O O Easter Express O O O O O O O 17. Are there any types of special events you would like to see the City engage in? Page 11 United City of • 1 Businesses 18. Which type of businesses or industry would you most like to see in Yorkville? ORetail/shopping opportunities OOffice developments OLight manufacturing areas OHeavy manufacturing or industrial Other(please specify) 19. What specific companies or brands do you want to see open a retail store in Yorkville? Page 12 United City of • 1 20. What suggestions do you have to improve the quality of life in Yorkville? �I 21. How many years have you lived in Yorkville? Years in Yorkville? 22. In which ward do you currently reside? OWard 1 (Alderman Koch,Alderman Colosimo) OWard 2(Alderwoman Milschewski,Alderman Kot) OWard 3(Alderman Munns,Alderman Funkhouser) OWard 4(Alderwoman Spears,Alderwoman Teeling) O1 don't know 23. Which City and State did you live in prior to moving to Yorkville? If you have lived here your entire life, please write 'lifelong resident' or similar. ni 24. Do you own or rent your current residence? O Own ORent 25. How many persons in your household, counting yourself, are in the following age groups? Underage 10 10-19 20-29 30-39 40-49 50-59 60-69 70 and over Page 13 United City of • 1 26. Which is your age group? OUnderage 10 O 10-19 O 20-29 O 30-39 O 40-49 O 50-59 O 60-69 O70 and over 27. Which of the following best describes your race/ethnicity? OWhite/Caucasian OAfrican American/Black OAsian/Pacific Islander ONative American/Eskimo OMixed Race Other(please specify) 28. What is your gender? OMale OFemale 29. Is there any way in which this survey can be improved? -1 °I Page 14 United City of • 1 Thank you for completing this survey. Results for the survey will be published to the City website in May. To review last years results,copy and paste the following link in a new tab: http://yorkviIle.i1.us/documents/CitySurvey2012finaIpacket.pdf Page 15 CIP Reviewed By: K 0 Legal ❑ Agenda Item Number 06 Finance NB #6 ESL -� 1836 Engineer ❑ City Administrator 0 � �� ; � y Human Resources ❑ Tracking Number G �© Community Development ❑❑ ADM 2013-06 Police Public Works ❑ Agenda Item Summary Memo Title: Chamber of Commerce memberships on the City utility bill Meeting and Date: Administration—January 17, 2013 Synopsis: See attached memo. Council Action Previously Taken: Date of Action: N /A Action Taken: Item Number: Type of Vote Required: N/A Council Action Requested: Informational item Submitted by: Bart Olson Administration Name Department Agenda Item Notes: Memorandum To: City Council EST. 183fi From: Bart Olson, City Administrator CC: Date: January 10, 2013 Subject: Chamber of Commerce membership utility bill offer LLE�% Summary Information on a planned roll out of Chamber of Commerce membership offers on the bottom of the City's utility bill. Background The City has been a premier member in the Yorkville Area Chamber of Commerce since 2008, and I have served on the Chamber Board since 2009. Like the YEDC, the Chamber has seen a modest decline in paying memberships since the recession. In a recent discussion with the Chamber, the Executive Board was brainstorming ideas for reaching out Yorkville businesses who do not participate in the Chamber, when the following idea came up. The City usually has first contact with businesses via the utility billing process. When a new business contacts the City to set up an account, our employees could simply ask the incoming business if they intended to join to Yorkville Area Chamber of Commerce and if so, offer to put the Chamber membership on the utility bill for the City throughout the course of the year. This would be a fairly simple process for the City, and can be accommodated with our current utility billing software at no extra cost. Similar to our collection and remittance of YBSD fees, BKFD impact fees, and school district land-cash fees, the City would simply add the corresponding membership amount to the bill and remit the fees to the Chamber on a bi-monthly basis. The marginal cost to the City to providing this service would be very minimal—less than a minute or so for each account creation, a few minutes per month for the Finance Department to reconcile the amounts in the City's accounting system, and the cost of one check to the Chamber every other month. The benefit to the City of offering memberships at point of account creation is that of having of a stronger Chamber of Commerce. More businesses in the Chamber of Commerce produces more leads and transactions for their members, which boosts the overall local economy. When the local economy is stronger, the City and its residents benefit through higher commercial and industrial property values. While most businesses in the City are aware of the Chamber and its benefits, there are some businesses that may not be aware. Recommendation This is an informational item only. The City's next utility bill goes out at the end of February, and we intend to have a flyer created for this program that will be included within that utility bill. Reviewed By: Agenda Item Number 6 Legal ❑ NB #7 Finance ❑ EST. -� __ti 1838 Engineer ❑ -- City Administrator ■ Tracking Number mm Human Resources E]CwrMY Sad `=Q Community Development 1-1 F] ADM 2013-07 Police 4CE ��' Public Works ❑ Parks and Recreation ❑ Agenda Item Summary Memo Title: Ordinance Amending City Code re: Deputy Treasurer Pay Meeting and Date: Administration Committee—January 17, 2013 Synopsis: Proposal to lower the Deputy Treasurer salary from $4,900 to $2,900. Council Action Previously Taken: Date of Action: CC 11/13/12 Action Taken: Approval of ordinance setting salary at $4,900. Item Number: Ord. 2012-46 Type of Vote Required: Majority Council Action Requested: Approval Submitted by: Bart Olson Administration Name Department Agenda Item Notes: Red-Lined Version Ordinance No. 2013- AN ORDINANCE OF THE UNITED CITY OF YORKVILLE, KENDALL COUNTY, ILLINOIS, AMENDING THE COMPENSATION OF DEPUTY TREASURER WHEREAS, the United City of Yorkville (the "City") is a duly organized and validly existing non home-rule municipality created in accordance with the Constitution of the State of Illinois of 1970 and the laws of the State; and, NOW, THEREFORE, BE IT ORDAINED by the City Council of the United City of Yorkville, Kendall County, Illinois, as follows: Section 1. That Title 1, Chapter 6, Section 1-6-5 of the Yorkville City Code, is hereby amended by deleting said subsection (A)(6) in its' entirety and replacing it with the following: 1-6-5: SALARIES: "A. Officials;Annual Salaries: 6. Deputy Treasurer: Twos Thousand Nine Hundred Dollars ($2,900.004;900:00). If there is a "special" City Council meeting called, there is an additional One Hundred Thirty Five Dollars ($135.00) to the Mayor, City Clerk, Deputy Clerk, Treasurer and each Alderman attending. 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. 2013. CITY CLERK Ordinance No.2013- Page 1 CARLO COLOSIMO KEN KOCH JACKIE MILSCHEWSKI LARRY KOT MARTY MUNNS CHRIS FUNKHOUSER ROSE ANN SPEARS DIANE TEELING Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this day of 2013. MAYOR Ordinance No.2013- Page 2 Clean Version Ordinance No. 2013- AN ORDINANCE OF THE UNITED CITY OF YORKVILLE, KENDALL COUNTY, ILLINOIS, AMENDING THE COMPENSATION OF DEPUTY TREASURER WHEREAS, the United City of Yorkville (the "City") is a duly organized and validly existing non home-rule municipality created in accordance with the Constitution of the State of Illinois of 1970 and the laws of the State; and, NOW, THEREFORE, BE IT ORDAINED by the City Council of the United City of Yorkville, Kendall County, Illinois, as follows: Section 1. That Title 1, Chapter 6, Section 1-6-5 of the Yorkville City Code, is hereby amended by deleting said subsection (A)(6) in its' entirety and replacing it with the following: 1-6-5: SALARIES: "A. Officials;Annual Salaries: 6. Deputy Treasurer: Two Thousand Nine Hundred Dollars ($29900.00). If there is a "special" City Council meeting called, there is an additional One Hundred Thirty Five Dollars ($135.00) to the Mayor, City Clerk, Deputy Clerk, Treasurer and each Alderman attending. 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. 2013. CITY CLERK Ordinance No.2013- Page 1 CARLO COLOSIMO KEN KOCH JACKIE MILSCHEWSKI LARRY KOT MARTY MUNNS CHRIS FUNKHOUSER ROSE ANN SPEARS DIANE TEELING Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this day of 2013. MAYOR Ordinance No.2013- Page 2 0 CIP Reviewed By: Agenda Item Number J� $ 06 Legal El NB, #8 Finance ❑ ESL -� 1836 Engineer ❑ -_� City Administrator El Tracking Number .4 City y Human Resources El� wn sw _© Community Development ❑ ADM 2013-08 � Police ❑ Public Works ❑ Parks and Recreation ❑ Agenda Item Summary Memo Title: NIMEC Bid for Electric Accounts Meeting and Date: Administration Committee—January 17, 2013 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: Memorandum To: Administration Committee EST. 1 _ 1836 From: Rob Fredrickson, Finance Director O 6 Date: January 9, 2013 9 Boa, p Subject: NIMEC Bid KantlaElCOUnry <LE Since 2006 staff has solicited bids from the Northern Illinois Municipal Electric Cooperative (NIMEC) for the purposes of securing an electrical supplier at the lowest possible cost for the City's various water treatment plants, lift stations and wells. Recently NIMEC has contacted staff stating that they will begin soliciting bids from suppliers (Integrys, Constellation and MC Squared)beginning on February 1, 2013. Over the last three years the power market has dropped approximately 15% during the first quarter of the year, due to higher natural gas inventories as a result of warmer winters. We do not know if this decline will occur again, but NIMEC recommends that the City position itself to capture the drop in pricing should it occur. Once an upward trend has been identified,NIMEC will begin soliciting bids. Once the winning bid has been identified and presented to the City, we will have approximately 24 hours to decide whether or not to except. Because of this short time frame, staff is requesting that the City Council authorize the City Administrator and Finance Director to approve the lowest bid, at their discretion, and to sign contracts to secure the provision of electricity from the lowest bidder as presented by NIMEC for a one year period. This authority would be effective only for the current NIMEC bid cycle, which ends in April. Reviewed By: Agenda Item Number 0 Legal ❑ OB #1 Finance ❑ EST. -� __ti 1838 Engineer ❑ -- City Administrator ❑ Tracking Number Human Resources ❑ `=Q Community Development ❑❑ ADM 2012-58 Police ALE � Public Works ❑ Parks and Recreation ❑ Agenda Item Summary Memo Title: Ordinance Regarding City Council Procedures—Removal of COW Meeting and Date: Administration Committee—January 17, 2013 Synopsis: Proposal to remove COW summer schedule. Council Action Previously Taken: Date of Action: Admin 11/15/12 Action Taken: Tabled Item Number: ADM 2012-58 Type of Vote Required: Council Action Requested: Submitted by: Alderman Colosimo Name Department Agenda Item Notes: 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 again on October 9, 2012 as Ordinance 2012-33; 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. D -ing the months of September-.h,.,ugh Nlay-, 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 Tane, my, an Ordinance No.2012- Page 2 Tuesday of eaeh month at 7:00 p.m. iff the City Hall Couneil!`b a ffib e fs b.a. Eb.Citizens in attendance at any meeting of the City Council shall be entitled to address the City Council on any agenda 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. d 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. mod.City Council meeting agenda items may be added by the Mayor, consent of four (4) aldermen, or direction from a committee. Vie. 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. g£The City Council shall appoint the Mayor Pro Tem 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. u. Du"-ring the months of tme T„ly, a A„gust !-'a,-.,mit4ee of the iri'role meetings shall be regtilaf:ly sehedule 7 to eenvene An tb,o 7fld month at 7:00 p.ffl. in the Gity Hall Getineil Chaffiber-s. b. Gaffimittee of the Whole agenda iteffis may be added by the Mayef of afly .,l�rm'an.. e. Citizens in aftendanee at any meeting of the Committee of the Whole shall be led to address the C4y Cotmeil on any agenda item in or-def to peffflit the ,ixork of the City Couneil to pfoeeed. Citizens shall be entitled to address City couneii on any mat �atffflffieflt. d. Eaeb seetion of the Committee of the Whole meetin shall be pr-esided eve by the fespeetive Committee's > of the , by the viee ehaifmafi. e. The ifitent of the Gommittee of the Whole is that eaeh agenda item is discussed by the City Council as a whole, t6 its movement toga sttbse"efit City Gatiiieil meeting (as dir-eeted by the Mayof or- any al Section -32. Procedures for Committee Meetings: Ordinance No.2012- Page 3 i a. Dtifing the months of September-thr-ough May, Committee meetings shall be fegulafly held ffioiithly, at the dates, times and loeatioiis as appfoved by the Committees. b a.The Mayor shall be a non-voting member of all standing committees. gib.The Mayor shall select committee rosters at the first City Council meeting in May following a municipal consolidated election (i.e. every two years). Vic.Committee rosters may be switched by mutual, unanimous consent of the aldermen trading seats and the Mayor. mod.The Mayor shall select committee chairmen and vice-chairmen. Vie. Any alderman may add any agenda item to any committee agenda. g:f.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. 13-g._The four committees shall be: i. Administration ii. Economic Development iii. Public Safety iv. Public Works +.h. Each committee shall be presided over by its chairman, or in the absence of the chairman, the vice-chairman. Vii. 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. l-j. 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