The URL can be used to link to this page

Administration Packet 2011 01-20-11 J� 4 United City of Yorkville 800 Game Farm Road JIM ES ,� T. � 1836 Yorkville, Illinois 60560 Telephone: 630-553-4350 0 1 1 ( P .� az `a Fax: 630-553-7575 Kcma+it Corry �� AGENDA ADMINISTRATION COMMITTEE MEETING Thursday, January 20, 2011 6:00 p.m. City Hall Conference Room Citizen Comments: Minutes for Correction/Approval: April 15, 2010 and November 18, 2010 New Business: 1. ADM 2011-01 Treasurer's Report for November and December 2010 2. ADM 2011-02 Budget Report for November and December 2010 3. ADM 2011-03 Budget Cutting Ideas Old Business: 1. CC 2010-108 Ordinance Amending City Code Regarding Citizen Comments Additional Business: 2010/2011 City Council Goals Administration Committee Goal Elected Officials Staff Build fund balance. All Rob Fredrickson/Bart Olson Long-term budgeting. Golinski/Sutcliff Rob Fredrickson/Bart Olson Improve effectiveness of budget discussions. Plocher/Munns Rob Fredrickson/Bart Olson Fiscal responsibility and accountability. Teeling/Spears Rob Fredrickson/Bart Olson Resident outreach (open government communication.) Sutcliff/Spears Glory Spies/Bart Olson Litigation aversion. Gilson/Werderich Bart Olson Staff—elected officials communications. Spears/Gilson Glory Spies/Bart Olson Budgeting. Munns/Plocher Rob Fredrickson/Bart Olson Grant planning(with Park Board). Golinski/Spears Krysti Barksdale-Noble/ Bart Olson FOIA compliance. Sutcliff/Spears Bart Olson/Lisa Pickering UNITED CITY OF YORKVILLE WORKSHEET ADMINISTRATION COMMITTEE Thursday, January 20, 2011 6:00 PM City Hall Conference Room --------------------------------------------------------------------------------------------------------------------------------------- MINUTES FOR CORRECTION/APPROVAL: --------------------------------------------------------------------------------------------------------------------------------------- 1. April 15, 2010 2. November 18, 2010 ❑ Approved ❑ Approved ❑ As presented ❑ As presented ❑ With corrections ❑ With corrections --------------------------------------------------------------------------------------------------------------------------------------- NEW BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. ADM 2011-01 Treasurer's Report for November and December 2010 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2011-02 Budget Report for November and December 2010 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 3. ADM 2011-03 Budget Cutting Ideas ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- OLD BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. CC 2010-108 Ordinance Amending City Code Regarding Citizen Comments ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- ADDITIONAL BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- O.�EID Cl,,. Reviewed By: Agenda Item Number ? O J R r� Legal El Minutes An JU, EST. ,i 1836 Finance ❑ Engineer ❑ Tracking Number E t1 City Administrator ❑ O� � . 71 e� Public Works ❑ C.1 $¢al Kciufal Coumy ®� E v ❑ Agenda Item Summary Memo Title: Minutes of the Administration Committee—April 15, 2010 Meeting and Date: Administration— 1/20/11 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Majority Council Action Requested: Approval Submitted by: Minute Taker Name Department Agenda Item Notes: DRAFT UNITED CITY OF YORKVILLE ADMINISTRATION COMMITTEE MEETING Thursday, April 15, 2010 6:00pm City Hall Conference Room CITY OFFICIALS IN ATTENDANCE: Chairman Robyn Sutcliff Alderman Gary Golinski Alderman George Gilson Alderman Diane Teeling Other City Officials Mayor Valerie Burd City Administrator Bart Olson Finance Director Susan Mika Treasurer Bill Powell Guests: Tony Scott, Kendall County Record Scott/Raging Waves The meeting was called to order at 6:03pm Minutes for Correction None New Business: 1. ADM 2010-20 Monthly Budget Report for March 2010 Alderman Gilson asked what safeguards are in place to curb spending if a certain department has exceeded their budget. Ms. Mika replied that the department would need to underspend on another item. He also asked to see the Community Relations budget. Gilson asked if any bad debt was written off under policies under the previous and present administrations. Mika said a previous spreadsheet had broken this down by year and will be provided to Gilson. Other queries included: 1. Administration overtime of$862.54 was questioned from page 4--- it was related to FOIA requests. 1 2. Contractual services were questioned and it was noted these are related to videotaping Council meetings. 3. New World Live Scan—pertains to fingerprintingibackground checks and allows Yorkville to communicate with the County and surrounding towns. Includes a maintenance fee also. 4. Water tower painting, $18,000 over budget, 5. General Contractual Services, no money budgeted: money is split between part time City employees and actual contractors. Old Business: (out of sequence) 1. ADM 2010-08 Amusement Taxes Alderman Golinski asked to move this item forward on the agenda at this time. A proposed 3-5%recreational tax had been proposed and it was discussed that there was already a 5% admission tax imposed on Raging Waves. Golinski said there needed to be a discussion about this additional tax without adding a burden to Raging Waves. Mayor Burd said the tax could be postponed until after October so the park is not affected this year. It should re-examined next year after looking at the annexation agreement. No action was taken at this time. It was pointed out that a positive vote for the budget including these figures will not institute any further taxes and that it would also take an ordinance with a separate vote. A representative (Scott) from Raging Waves expressed concern about the amusement tax as a whole. He suggested that the proposed amusement tax should not be put into the budget until potential future businesses are actually established. Alderman Gilson agreed with excluding this tax from the budget. The Raging Waves also expressed concern for the impact this tax would have on Yorkville residents. He asked the City to consider the long- term ramifications. New Business 2. ADM 2010-21 Monthly Treasurer's Report for March 2010 Treasurer Powell reported the following: $23,685,434 beginning balance $ 974,861 revenues $ 1,275,742 expenses $23,384,552 balance Powell said real estate taxes are expected soon. Golinski asked if there would be any changes made to the way the City reports the Fund Balance reserves and the way the water options are calculated. Ms. Mika is currently working on this. 3. ADM 2010-22 Redistricting-Discussion Bart Olson reported that the legislative Bill requiring an increase to 10 aldermen due to population increases, is in the Illinois Senate for a second reading. The City asked for 2 legislative relief and Mr. Olson expects it to be adopted. This would mean that the City would not have to increase the number of aldermen until after the certification of the 2010 Census. At that time, the City would have the authority to restrict the number of aldermen if desired. This matter will be discussed at City Council as well. Mr. Olson asked the City GIS employee to draw new preliminary wards using natural dividers such as Rt. 34, the river, etc. 4. ADM 2010-23 YBSD Billing Alderman Teeling brought this matter forward following public complaints about the high bills and it was noted that a good share of the bill is not City billing. Staff was asked to do an analysis as to how much it costs the City and if it was possible to have separate billing. Billing for YBSD is included on the bills and it was noted that Yorkville is one of only three towns in Illinois who do the billing for their sanitary districts. There was also a discussion of using electronic bills. Bart Olson will research this possibility. 5. ADM 2010-24 Resolution of Authorization to Close Checking Account and Transfer Funds (Youth in Community Police) The Police Department opened this account many years ago and received the statements. When the new Chief assumed his duties, he asked Ms. Mika to take over this account that currently has over$4,000. This item will move to consent agenda. 6. ADM 2010-25 Fourth of July Fundraising Chairman Sutcliff said Yorkville is one of the few communities that funds Fourth of July events. She suggested a collection"boot" at City Hall. Many businesses in town also have collection points. Mayor Burd said the Oswego Mayor approached her last year about sharing fireworks, however, the Fire Department prefers to keep this activity in the community. It was noted that a message could be included on the water bills, asking for donations. An e-mail blast was also suggested. 7. ADM 2010-26 Riverfront Building Concession Lease RFP Bart Olson said the Park Board has voted on and approved this document. In a memo to the committee, Mr. Olson stated three vendors have expressed interest in leasing the building for canoe/kayak rental and instruction business. The Park Board recommended that the lease for done through a RFP. Freeman's position on this lease was also discussed and Alderman Gilson said he wanted additional discussion on Freeman's Sports and also if there is another candidate for the lease who could generate more revenue. This item will be brought back next month for more consideration. 8. ADM 2010-27 Sick Time Buy Back Finance Director Mika said employees have been eligible to cash out unused sick time this fiscal year for 50% of their rate of pay. It is being proposed to abolish this for one year by amending the employee manual. No further discussion. 3 Additional Business: It was noted that the meeting videographer ran out of tape at one of the recent meetings. It will be discussed at the next Consortium meeting. Meeting adjourned at 7:50pm Transcription of minutes by Marlys Young 4 `"o Co.y Reviewed By: Agenda Item Number O Legal ❑ Minutes 1836 EST. Finance ❑ Engineer ❑ Tracking Number City Administrator ❑ O'A Public Works ❑ �C4.E ��® ❑ Agenda Item Snmmary Memo Title: Minutes of the Administration Committee—November 18, 2010 Meeting and Date: Administration— 1/20/11 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Majority Council Action Requested: Approval Submitted by: Minute Taker Name Department Agenda Item Notes: DRAFT UNITED CITY OF YORKVILLE ADMINISTRATION COMMITTEE Thursday, November 18, 2010 City Hall Conference Room COMMITTEE MEMBERS PRESENT: Alderman Robyn Sutcliff Alderman Diane Teeling Alderman George Gilson Alderman Gary Golinski OTHER CITY OFFICIALS PRESENT: City Administrator Bart Olson City Finance Director Rob Frederickson Alderman Rose Spears Treasurer Bill Powell The meeting was called to order at 6:02pm by Chair Sutcliff Minutes for Correction/Approval: September 16, 2010 Alderman Golinski had two corrections to the minutes. First, he was listed as other city official instead of Committee members. On page 3, last paragraph, should be Park Board not Park District. The minutes were approved as corrected. New Business: 1. ADM 2010-51 Treasurer's Report for September 2010 2. ADM 2010-52 Treasurer's Reports for October 2010 Chair Sutcliff suggested that both Treasurer's reports be discussed at the same time. Treasurer Powell noted the difference between the September and October report is that Fund Balance has been removed but will be added back in later after the audit. Secondly, the format has changed a little but once the audit is completed the beginning and ending balances will be included again. Future Treasurer reports will be altered to be more concise and easier to read. Finance Director Frederickson stated that field work for the audit will begin on December 61n Alderman Golinski clarified that for funds 51 and 51, Water Operations and Sewer, the City would no longer be listing the assets so the budget number is more acqurate. The Committee agreed to forward both the September and October 2010 Treasurers Reports to the Consent Agenda. 1 3. ADM 2010-53 Administration Committee Meeting Dates for 2011 Alderman Gilson stated that he had a few conflicts but would review those after the election and the reassignment of committees. The Committee approved the dates as presented. 4. ADM 2010-50 Budget Report for September 2010 S. ADM 2010-54 Budget Report for October 2010 Administrator Olson reviewed the two reports. He noted that for the Admission tax the City budgets the revenue as well as the rebate, which beat budget projections of$63,000. Alderman Gilson referred to the Radium Compliance about bonds issues to pay for the project and proceeds are exhausted. Finance Director Frederickson stated the proceeds were put into a separate bank account and used towards capital improvements as well as to pay down debt service. Administrator Olson clarified that a bond was sold to pay for the Radium Compliance project, the project was built under budget, and the remaining money placed in an account. The loan payments are paid from revenues received. The remaining money in the bond account is excess and is pulled to pay for expenses. This is the first time there is no leftover excess proceeds. Alderman Gilson requested a break down of this account. Administrator Olson reiterated that this particular bond was supposed to hit the Water Account and the excess proceeds only used for debt pay down. Discussion then moved to the Business District Tax regarding the City's practice to budget separately for Sales Tax Revenues, Business District Tax Rebate as well as Sales Tax Rebate. The positive about Business District is that what comes in goes out. If the income, and correspondingly, the rebate, is greater than the budgeted amount, it is an indication of how well the sales tax is doing. There was $140,000 variance in budgeted rebate versus actual rebate that wasn't caught. This means that other businesses that we don't share sales tax have declined and the businesses that do, have increased. On another note, the year to date total of$1.289 millions Sales Tax amount does contain months that need to be journaled back to the prior fiscal year. The City receives Sales Tax three months in the rears. Currently, we have received '/ of our annual sales tax. Discussion then began regarding the Water Operations Revenue specifically the year to date total of$933,295, which out performing budget estimates. This is due to conservative budgeting as well as the increase in water rates. Additionally, the Water Improvement revenues of$112, 611 reflect the 8.25% fee passed to pay for debt obligations. This is beating estimates as well. Alderman Golinki introduced the issues of pensions, specifically the Police Pension, and the amount of$162,500 plus encumbrances of$318,000. Administrator Olson stated these were not employee contributions but reflected income from Real Estate taxes for Police Pension. The police pension is a sub-levy of the Real Estate tax, it is received by the City and deposited in the Pension Fund. Alderman Golinski did ask if there are employee contributions. Treasurer Powell stated that employee contributions are not 2 reflected because they go directly into the pension and never hit the general fund. It is important to note that the Police Pension is still underfunded by$125,000. The committee approved the report and recommended it be forwarded to the Consent Agenda. 6. CC 2010-81 Budget Update The Committee began discussing the Budget update. Alderman Gilson had several questions regarding the budgeted Amusement Tax of$162,964. Administrator Olson explained this was based on the assumption that the Amusement Tax would be in place at 5% on May 1,but it was actually 3%. Raging Waves had a good year but not exceptional. The City has had preliminary talks and a tentative agreement over shared distributions for the following year. Alderman Gilson requested clarification regarding Building Permits, Traffic Fines and the Amusement Tax revenue of$162,000. Administrator Olson stated that revenue would be revised downward, closer to $112,000, depending on other vendor receipts. Alderman Golinski questioned the overage for over-time under the Police Department budget. Administrator Olson stated the two likely explanations are staff shortages and increase reports at end of shifts. Alderman Golinski questioned if Police get over-time for Hometown Days and Holidy Under the Stars. Administrator Olson stated that he would have to verify that with the Police Department Discussion continued regarding Council input for Training. Alderman then expressed concern about the Audit Fees, wondered if we could rebid this in 2011/2012, in order to bring these costs down. Administrator Olson stated that we have one more year in the contract; however, we will go out for RFP when the contract expires. Additionally, the increase in the Accounting System Service Fee was attributed to contract obligations for computerized software and includes training and technical support. Further discussion revolved around increases to Insurance Liability and Property due to two additional riders for the old jail and one for Park District inflatables. The staff is in the process of reviewing the amounts and the broker is out getting bids. Our losses have decreased from prior years,however, there are things they have recommended we do to decrease our costs. The amount for Contractual Engineering Services reflects an estimate based upon past usage, even though this year we hadn't used it completely this year. The Committee went on to discuss the front funding for the Yorkville Bristol Sanitary District based on future growth. Comments were made regarding the cash flow and use of funds by YBSD. In addition, there was discussion regarding the City's roll in printing bills and providing customer service. Administrator Olson pointed out this is a good consolidation of services that benefits the residents. The YBSD sets the connection fee and the Village sets the Sewer Connection fee. The Sewer fee was set for the 03/04 3 budget and reflects $1,800 capital and $200 maintenance. Any change to this fee would require an ordinance. Finally, the Committee reviewed the Sewer Fund Debt Obligations and the practice of using revenue pledged on growth when growth des not come. Alderman Tilman wondered the consequences if the City did not refinance or issue another bonds. Administrator Olson said that if the City did not increase fees or refinance, then the bonds would be abated, meaning they would become part of the property tax, outside of the cap, which could result in litigation. There were no further questions or discussion on the Budget Reports. Old Business: 1. ADM 2010-49 Historical Street Naming Policy After a brief discussion and review of the attachments, the Committee agreed to indefinitely table the issue. Additional Business: Alderman Gilson wondered if any planned staff reductions would be presented to the Council at their meeting Tuesday. Administrator Olson stated he was not prepared to respond. Alderman Gilson commented on the condition of the old sawmill property. Administrator Olson stated that property maintenance issues are on a complaint basis and that it is difficult for the City to be proactive with only one employee responsible for finding all the issues. There being no further business, the meeting was adjourned at approximately 7:50pm. Minutes Respectfully Submitted by: Kristia Leyendecker, Minute Taker 4 `'s-o C/p` Reviewed By: Agenda Item Number J - 0-O Legal ❑ NB #1 I Finance ■ EST. , � 1836 Engineer ❑ Tracking Number 0 I�i4r1 W City Administrator ❑ CW,A�. C) Consultant ❑ ADM 2011-01 LE V ❑ Agenda Item Summary Memo Title: Treasurer's Report for November and December 2010 Meeting and Date: Administration Committee 1/20/11 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Rachel Wright Finance Name Department Agenda Item Notes: Memorandum To: Administration Committee Members EST. _ 1836 From: Rob Fredrickson, Finance Director Or.. CC: Bart Olson' City Administrator 11' fl —v- 0 Date: January 14, 2010 Krexi.tl ,Wty `� Subject: Fiscal Year 2010 Audit Lt,E %ti The attached Treasurer reports for the months of November and December 2010 have been updated to reflect ending fund balances (fund balance equivalents for the enterprise funds) at the end of fiscal year 2010. As stated on the report, ending fund balance for the General Fund is at negative $492,939, which is a decrease of$1,711,196 from the previous fiscal year. One of the major reasons for this decline has to do with bad debts associated with developer receivables from prior fiscal years, which were written off in 2010. Total bad debt expenditures for FY 2010 were $1,016,132. Another item that negatively impacted fund balance in the General Fund has to do with the way the auditors are now requiring the City to record sales and business tax rebates on the accrual, rather than cash basis, in order to be in compliance with Generally Accepted Accounting Principles (GAAP). To use sales tax as an example,just as the City records the first three cash allotments received in the new fiscal year(for the months of May, June and July-FY 2011) as revenue for the prior year (because the tax was actually recognized as revenue for the City at the point-of-sale, which occurred in the months of February, March and April-FY 2010), the City must also record the expenditure related to that sales tax in the period in which it was incurred (February, March and April-FY 2010) regardless of when the sales tax rebate checks were actually paid out. This process in accrual based accounting is commonly referred to as the matching principle, whereby revenues of the period (fiscal year) are "matched" against the expenditures of the period. The effect of this tax accrual was an additional reduction in fund balance in the amount of$194,657. This is the first fiscal year that the auditors have deemed these tax rebate amounts material, due to the fact that the rebate amount($194,657) was such a large percentage of fund balance, which was at negative $298,278, prior to the auditor's adjustment. For the sake of consistency, FY 2010 beginning fund balance in the General Fund was also adjusted down by ($177,283) in order to reverse out tax rebates that were recorded in FY 2010 that should have been recorded in FY 2009. Beginning fund balance in the General Fund, as restated, is now $1,218,257. In addition, the enterprise funds (Water, Sewer and the Rec Center) are shown in the fund balance equivalent format, which is essentially current assets minus current liabilities, or net working capital. The fund balance equivalent format reflects a more accurate picture on the overall health of an enterprise fund by excluding fixed assets, as well as other long term assets and liabilities, which cannot be immediately liquidated to satisfy short term obligations. UNITED CITY OF YORKVILLE TREASURER'S REPORT-for the period ended November 30,2010 Cash Basis Projected BGN Fund November Revenues %of YTD November Expenses %of YTD Ending Fund Balance Revenues YTD Revenues Budget Budget Expenses YTD Expenses Budget Budget Balance General Fund 01-General (492,939) 458,350 7,430,212 11,433,024 65% 781,646 6,400,793 11,376,981 56% 536,480 Library Fund 82-Library 571,002 43,241 1,263,763 2,158,985 59% 75,025 713,079 2,158,986 33% 1,121,686 Special Revenue Funds 15-Motor Fuel Tax 405,618 102,997 411,857 356,000 116% - 78,225 475,600 16% 739,250 79-Parks and Recreation 25,151 96,986 956,346 1,479,990 65% 71,670 721,460 1,461,912 49% 260,037 72-Land Cash (603,425) - 116,977 413,000 28% 10,000 123,737 665,449 19% (610,185) 85-Fox Industrial TIF 423,351 4,434 228,357 216,727 105% 74,966 80,141 80,433 100%n 571,567 87-Countryside TIF 2,477,758 221 9,243 12,354 75%r, 238,546 307,301 308,093 100% 2,179,700 88-Downtown TIF 136,294 5,654 75,362 88,550 85%r. - 811 1,500 54% 210,845 11-Fox Hill SSA 2,226 497 19,894 19,463 102%r. 455 3,786 3,458 109% 18,334 12-Sunflower SSA 6,188 179 13,871 19,070 73%n 108 7,530 8,253 91% 12,529 Debt Service Funds 42-Debt Service 7,628 25 215,577 429,404 50%n - 74,702 429,404 17% 148,503 Capital Funds 16-Municipal Building (607,724) - 19,950 (552,474) 4% - - - - (587,774) 22-Park and Rec Equipment Capital 66,852 657 1,697 210,960 1% 4,950 10,632 173,135 6% 57,917 20-Police Equipment Capital 210,284 1,185 17,682 62,000 29% 60 48,789 104,000 47% 179,177 21-Public Works Equipment Capital 157,807 - 20,900 35,000 60% 6,348 53,301 139,000 38% 125,406 23-City-Wide Equipment Capital (18,378) 2 99,857 421,500 24%r. 4,111 200,614 606,500 33% (119,135) Enterprise Funds 51-Water 229,183 13,025 1,403,264 2,122,354 66%r 131,517 1,197,025 2,122,677 56% 435,422 52-Sewer 2,502,866 1,508 813,261 881,800 92%r 57,360 713,114 2,020,433 35% 2,603,013 80-Recreation Center (127,815) 49,177 337,746 609,000 55% 51,105 428,083 675,301 63%n (218,152) Total Funds 5,371,927 778,138 13,455,816 20,416,707 1,507,867 11,163,123 22,811,115 7,664,620 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 ended December 31,2010 Cash Basis Projected BGN Fund December Revenues %of YTD December Expenses %of YTD Ending Fund Balance Revenues YTD Revenues Budget Budget Expenses YTD Expenses Budget Budget Balance General Fund 01-General (492,939) 796,981 8,227,196 11,433,024 72%n 878,620 7,279,414 11,376,981 64% 454,843 Library Fund 82-Library 571,002 51,227 1,314,990 2,158,985 61% 497,651 1,210,730 2,158,986 56% 675,262 Special Revenue Funds 15-Motor Fuel Tax 405,618 37,968 449,826 356,000 126% 84,429 162,655 475,600 34% 692,789 79-Parks and Recreation 25,151 86,256 1,042,602 1,479,990 70%• 98,931 820,391 1,461,912 56% 247,362 72-Land Cash (603,425) 671 117,648 413,000 28% 3,538 127,275 665,449 19% (613,052) 85-Fox Industrial TIF 423,351 1 228,359 216,727 105%r, - 80,141 80,433 100% 571,568 87-Countryside TIF 2,477,758 220 9,463 12,354 77%r, 307,301 308,093 100% 2,179,920 88-Downtown 11F 136,294 - 75,362 88,550 85% 46 857 1,500 57% 210,799 11-Fox Hill SSA 2,226 19,894 19,463 102%n 3,786 3,458 109%n 18,335 12-Sunflower SSA 6,188 13,871 19,070 73% - 7,530 8,253 91% 12,528 Debt Service Funds 42-Debt Service 7,628 25 215,602 429,404 50% 709,404 784,106 429,404 183% (560,876) Capital Funds 16-Municipal Building (607,724) - 19,950 (552,474) 4% - - - - (587,774) 22-Park and Rec Equipment Capital 66,852 7 1,704 210,960 1% 6,207 16,839 173,135 l0% 51,717 20-Police Equipment Capital 210,284 6,461 24,143 62,000 39% 486 49,275 104,000 47% 185,152 21-Public Works Equipment Capital 157,807 2,741 23,641 35,000 68% 6,858 60,159 139,000 43% 121,290 23-City-Wide Equipment Capital (18,378) 2 99,860 421,500 24%r, 490 201,104 606,500 33% (119,623) Enterprise Funds 51-Water 229,183 383,325 1,782,975 2,122,354 84% 605,675 1,802,700 2,122,677 85% 209,457 52-Sewer 2,502,866 128,566 941,827 881,800 107% 1,444,104 2,157,217 2,020,433 107% 1287,476 80-Recreation Center (127,815) 49,478 387,224 609,000 64% 46,058 474,142 675,301 70% (214,733) Total Funds 5,371,927 1,543,930 14,996,135 20.416,707 4,382,498 15,545,623 22,811,115 4,822,440 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 �,,D C/ry Reviewed By: Agenda Item Number 6 O J l0 1 Legal ❑ NB #2 EST. `� 1 1836 Finance ■ . `� Engineer ❑ Tracking Number �Il i @l vy City Administrator ■ -Q o° [,C a'� �O Consultant ❑ �� ADM 2011-02 e Agenda Item Summary Memo Title: Budget Report for November and December 2010 Meeting and Date: Administration Committee 1/20/11 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Discussion Submitted by: Bart Olson Administration Name Department Agenda Item Notes: UNITED CRY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/1-14-11 -_ AMAL EXPENSES BY MOM - - - - - - - - -- - YEAR-TO-DATE _ANNUAL JACODUNTNUMBERANO ION May-10 Jun-lo July-10 August-14 5e umber-1D ber-SD November-lff Dommher-10 lanua ry 11 Febrary ll Marh-13 April-11 49ALS -_ GENERAL FUND-REVENUES O1-000-40-00-3993 EMPLOY CONTRIB HEALTH $ 15,578.82 $ 21,593.01 $ 20,777.13 $ 18,248.19 $ 23,214.40 $ 15,606.40 $ 18,054.53 $ 19,803.11 $ 152,875.59 $ 168,318.00 O1-000-40-00-3994 ADMISSIONS TAX $ $ $ $ $ $ 181,744.45 $ $ 181,744.45 $ 112,964.00 O1-000-40-00-3995 RESTRICTED FUND BALAN $ $ $ $ $ $ $ $ $ - 01.000-40-00-3996 ROAD CONTRIBUTION FEE $ $ $ $ $ $ $ $ - $ - 01-000-40-00-3997 AMUSEMENT TAX $ $ $ $ $ $ $ 44.10 $ 44.10 $ 162,964.00 01.000.40.00-4000 REAL ESTATE TAXES $ $ 1,187,512.95 $ 77,294.67 $ 180,528.77 $ 946,783.74 $ 66,662.43 $ 62,787.77 $ 2,521,570.33 $ 2,450,000.00 01-000-40-00-4001 TOWN ROAD/BRIDGE TAX $ $ 78,859.34 $ 4,910.35 $ 13,596.68 $ 59,721.22 $ 3,761.54 $ 3,447.29 $ 164,296.42 $ 160,000.00 O1-000 40-00-4010 PERSONAL PROPERTY TAX $ 2,598.41 $ (646.74) $ 1,982.34 $ 260.33 $ $ 3,819.07 $ $ 3,080.64 $ 11,094.05 $ 20,000.00 O1-000-40-00-4020 STATE INCOME TAX $ m $ 124,314.46 $ 213,276.29 $ 127,184.73 $ 255,134.45 $ $ - $ 124,700.22 $ 844,610.15 $ 1,300,000.00 01-000-40-00-4030 MUNICIPAL SALES TAX $ 176,388.67 $ 212,835.49 $ 218,349.13 $ 224,744.02 $ 238,912.13 $ 217,924.53 $ 217,044.98 $ 221,211.44 $ 1,727,410.39 $ 2,440,000.00 O1-000-40-00-4032 STATE USE TAX $ 11,158.80 $ 22,269.14 $ 16,947.63 $ 16,064.99 $ 20,727.57 $ 17,230.77 $ $ 36,093.22 $ 140,492.12 $ 237,063.00 O1-000-40-00-4040 MUNICIPAL UTILITY TAX $ $ 133,343.15 $ $ $ 143,841.18 $ $ $ 277,184.33 $ 565,000.00 O1-000-40-00-4041 UTILITY TAX-NICOR $ $ 117,229.18 $ $ $ 32,221.63 $ $ $ 28,087.50 $ 177,538.31 $ 396,000.00 O1-000-40-00-4042 UTILITY TAX-CABLET $ 49,772.83 $ $ 1,835.78 $ 54,487.07 $ $ $ 55,794.36 $ 161,890.04 $ 190,000.00 O1-000.40-00.4043 UTILITY TAX-TELEPHO $ 42,820.41 $ 48,994.12 $ 42,325.81 $ 43,671.29 $ 45,259.93 $ 45,330.47 $ 34,022.66 $ 45,371.84 $ 347,796.53 $ 600,000.00 O1-000-40.00.4044 BUSINESS DISTRICT TAX $ 18,606.77 $ 25,279.42 $ 21,968.25 $ 22,943.42 $ 25,974.17 $ 20,892.42 $ 21,712.68 $ 24,224.13 $ 181,601.26 $ 150,000.00 O1-000-40-00-4045 AUTO RENTAL TAX $ 538.25 $ 613.04 $ 578.60 $ 528.60 $ 699.63 $ 715.37 $ 791.14 $ 691.76 $ 5,156.39 $ 3,421.00 01-000-40-00-4050 HOTEL TAX $ 1,251.06 $ 1,398.34 $ 2,961.94 $ 4,059.42 $ 4,188.16 $ 4,346.88 $ 3,483.55 $ 2,680.40 $ 24,369.75 $ 20,000.00 O1-000-41-00-4100 LIQUOR LICENSE $ 1,244.90 $ 503.12 $ 650.00 $ 374.74 $ $ - $ 1,300.00 $ 19.82 $ 4,092.58 $ 30,000.00 01.000-41-00-4101 OTHER LICENSES $ 50.00 $ 368.50 $ $ 234.25 $ 134.25 $ 414.25 $ $ 2,419.75 $ 3,621.00 $ 4,500.00 O1-000-41-00-4110 BUILDING PERMITS $ 16,601.10 $ 15,346.75 $ 11,678.40 $ 10,935.90 $ 12,518.50 $ 20,281.65 $ 10,383.10 $ 4,253.30 $ 101,998.70 $ 205,000.00 03-000.42-00-4205 FILING FEES $ $ $ $ $ $ $ $ $ 3,000.00 01-000-42-00-4206 GARBAGE SURCHARGE $ (509.93) $ 196,466.61 $ 337.19 $ 196,393.91 $ 77.39 $ 192,453.24 $ (248.41) $ 196,964.20 $ 781,934.20 $ 1,050,000.00 O1-000-42-00-4207 ZONING VARIANCE FEES $ $ $ $ $ $ $ $ - $ 170.00 O1-000-42-00.4208 COLLECTION FEE-YBSD $ $ $ $ $ $ $ $ - $ 121,502.00 01-000-42-00-4210 DEVELOPMENT FEES $ 13,677.65 $ 100.00 $ 200.00 $ $ 1,081.97 $ 18,435.64 $ - $ 33,495.26 $ 80,000.00 O1-000.42-00-4285 BEECHER LEASE AGREEME $ $ $ $ $ 1,000.00 $ 500.00 $ 500.00 $ 2,000.00 $ 12,000.00 01-000-42-00-4286 BEECHER RENTALS $ 45.00 $ 320.00 $ 170.00 $ 55.00 $ 210.00 $ 175.00 $ $ 110.00 $ 1,085.00 $ 2,000.00 O1-000.42-00-4287 DEVELOPER SIGN REIMBU $ - $ $ $ $ - $ $ - 1 $ - $ 5,000.00 O1-000-42-00-4288 MOWING INCOME $ $ $ 46.36 $ 298.13 $ 127.09 $ 107.11 $ 486.54 $ 1,065.23 $ 01-000-42-00.4289 GIS SERVICES $ $ $ $ $ $ - $ - $ - $ 01-000-43-00-4310 TRAFFIC FINES $ 9,434.34 $ 7,718.93 $ 8,394.55 $ 7,502.53 $ 6,510.22 $ 5,699.31 $ 9,717.23 $ 5,949.46 $ 60,926.57 $ 151,275.00 O1-000 43-00-4315 REIMBURSE POLICE TRAI $ $ $ $ $ $ - $ - $ - $ O1-000-43-00-4320 ADMINISTRATIVE ADJUDI $ 1,970.00 $ 2,445.00 $ 2,675.00 $ 2,920.00 $ 1,940.94 $ 1,676.00 $ 1,275.00 $ 2,140.00 $ 17,041.94 $ 50,000.00 O1-000-43-00-4325 POLICE TOWS $ 11,500.00 $ 8,400.00 $ 12,500.00 $ 5,500.00 $ 2,000.00 $ 3,500.00 $ 9,500.00 $ 3,500.00 $ 56,400.00 $ 181,275.00 01-000-44-00-3993 EMPLOYEE CONTR.HEALT $ $ $ $ $ $ - $ - $ - $ - 01-000-44-00-4401 DARE DONATIONS $ $ $ $ $ $ - $ - $ 25.00 $ 25.00 $ 20.00 O1-000-44-00-4403 WEARING APPAREL DONAT $ $ $ $ $ $ $ - $ $ O1-000-44-00-4404 HANGING BASKET DONATI $ 50.00 $ $ $ $ $ - $ - $ 50.00 $ 2,000.00 O1-000-44-00-4406 COMMUNITY RELATION DO $ $ $ $ $ $ $ $ - $ - O1-000-44.00-4407 HOLIDAY UNDER THE STA $ 900.00 $ 1,025.00 $ 350.00 $ 1,110.00 $ 485.00 $ 2,735.00 $ 2,136.00 $ 8,741.00 $ 9,585.00 O1-000.44-00-4410 REIMB TO OTHER GOVERN $ $ $ $ $ - $ $ - $ - $ - 01-000.44-00-4411 REIMBURSEMENTS-POLICE $ 160.00 $ 295.00 $ 265.60 $ 270.00 $ 230.35 $ 245.35 $ 220.35 $ 21,797.21 $ 23,483.86 $ 3,300.00 01-000-44-00-4412 INSURANCE REIMBURSEME $ $ $ $ $ $ - $ $ $ O1-000-44-00-4413 PLAN REVIEW INCOME $ $ $ $ $ $ $ $ - $ - 01-000 44-00.4415 REIMB FOR LEGAL EXPEN $ $ $ $ $ $ $ $ 33,144.76 $ 33,144.76 $ 150,000.00 O1-000-44-00.4416 REIMB FOR THE LIBRARY $ $ $ $ $ $ $ $ - $ 40,582.00 O1-000-44-00-4417 MIS.REIMBURSEMENTS $ 5,800.44 $ 257.92 $ 6,058.36 O1-000-44-00-4418 REIMB-STREET OPS $ 2,895.21 $ 2,895.21 01.000-44-00-4490 MISCELLANEOUS INCOME $ 1,705.62 $ - $ 9.00 $ 67.00 $ 114.00 $ 950.00 $ - $ 30.00 $ 2,875.62 $ 1,000.00 O1-000-44-00-4495 HAUNTED HOUSE n/a n/a n/a n/a n/a $ $ - $ - $ 01-000-44-00-4498 PENALTY FEE INCOME $ $ $ $ $ $ - $ - $ $ O1-000-44-00-4499 BAD DEBT RECOVERY $ 2,718.75 $ $ $ $ $ $ - $ 2,718.75 $ 01-000-45-00-4504 TRAFFIC SIGNAL REVENU $ $ 19,191.11 $ $ $ $ - $ - $ 19,191.11 $ 14,925.00 01-000-45-00-4505 COPS GRANT-VESTS $ $ $ $ $ 912.50 $ - $ $ 912.50 $ - 01-000-45-00-4511 POLICE-STATE TOBACCO $ $ $ $ $ 1,870.00 $ - $ $ 1,870.00 $ 1,803.00 O1-000-45-00-4515 ENERGY&RECYCLING GR $ $ 5,307.00 $ $ $ $ - $ $ 5,307.00 $ 01-000-45-00-4525 GRANTS $ $ $ $ $ $ $ - $ 17,442.31 $ 17,442.31 $ - 01-000 45-00.4540 BEAVER ST DEVELOPMENT $ - $ - $ - $ - $ - M22,96S.7S $ - $ - $ O1-000-46-00-4600 INVESTMENT INCOME $ 63.09 $ 153.40 $ 346.79 $ 204.02 $ 181.78 $ 96.91 $ 87.49 $ 1,463.56 $ 3,000.00 01-000-49-00-4902 REPAY OF PARK&REC L $ $ $ $ $ $ - $ $ 100,000.00 O1-000-49-00-4915 TRANSFER FROM WATER O $ - $ $ 22,965.75 $ $ - $ - $ 45,931.50 $ 91,863.00 O1-00 0-49-00.4920 TRANSFER FROM SEWER M $ $ $ 20,761.25 $ $ $ - $ 41,522.50 $ 83,045.00 O1-000-49-00-4925 TRANSFER FROM SAN.SE $ $ $ $ $ $ $ - $ 01-000-49-00-4930 TRANSFER FROM WATERI $ $ $ $ $ $ $ $ lof18 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/1-14-11 AZTIIAL E](POSIEsS BY MOFITt! AC1YlUMTNUM @ERANDDESCRIPTION K31.,32..54 June 10 ]u1y 10 August-10 September-k0 Octaber-10 Novcmbar-10 December-10 January-11 February 11 March-11 jAprl� 1 YEAR-TO-DATE ANNUAL 11 VMS BUDGET 01-000-49-00-4935 TRANSFER FROM LAND CA - $ 15,112.25 $ - $ - $ 15,112.25 $ - $ 30,224.50 $ 60,449.00 01-000-49-00-4940 TRANSFER FROM MUNICIP $ $ $ $ $ $ - $ - 01-000-49-00-4950 TRANSFER FROM FOX IND $ $ $ $ $ $ $ - 01-000-49-00-4955 TRANSFER FROM DOWNTO $ $ $ $ $ $ - $ - GENERAL FUND-TOTAL REVENUES 2,231,235.32 $ 719,670.06 $ 932,182.99 $ 1,826,072.20 $ 884,376.21 $ 458,350.22 $ 796,980.69 $ $ - $ - $ $ 8,227,192.23 $ 11,433,024.00 GENERAL FUND-ADMIN EXPENSES 01-110-50-00-5100 SALARIES-MAYOR $ 860.00 $ 825.00 $ 825.00 $ 825.00 $ 860.00 $ 825.00 $ 825.00 $ 725.00 $ 6,570.00 $ 11,310.00 01-110-50-00-5101 SALARIES-CITY CLERK $ 741.67 $ 741.67 $ 741.67 $ 741.67 $ 776.67 $ 741.67 $ 641.67 $ 400.00 $ 5,526.69 $ 8,980.00 01-110-50-00-5102 SALARIES-CITY TREASU $ 535.00 $ 500.00 $ 400.00 $ 400.00 $ 300.00 $ 500.00 $ 500.00 $ 500.00 $ 3,635.00 $ 6,500.00 01-110-50-00-5103 SALARIES-ALDERMAN $ 4,245.00 $ 4,000.00 $ 3,900.00 $ 4,000.00 $ 4,010.00 $ 3,900.00 $ 4,000.00 $ 3,900.00 $ 31,955.00 $ 50,320.00 01-110-50.00-5104 SALARIES-LIQUOR COMM $ 83.33 $ 83.33 $ 83.33 $ 83.33 $ 83.33 $ 83.33 $ 83.33 $ 83.33 $ 666.64 $ 1,000.00 01-110-50-00-5306 SALARIES-ADMINISTRAT $ 15,935.65 $ 15,789.56 $ 16,697.57 $ 29,607.94 $ 9,850.38 $ 29,334.34 $ 20,406.29 $ 40,470.88 $ 178,092.61 $ 202,242.00 01-110-50-00-5115 SALARIES-SPECIAL CEN $ $ $ $ $ $ $ $ - $ - 01-110-50-00-5136 SALARIES-PART TIME $ $ $ $ $ $ $ $ - $ - 01-110-50-00-5137 SALARIES-OVERTIME $ $ $ $ $ $ $ $ - $ 575.00 01-110-61-00-5300 SPECIAL COUNSEL $ $ $ 5,176.24 $ 6,042.65 $ 7,156.17 $ $ 10,227.10 $ 28,602.16 $ 65,000.00 01-110.61-00-5301 LEGISLATIVE ATTORNEY $ $ $ $ $ $ $ $ - $ 01-110-61-00-5302 CORPORATE COUNCIL $ $ 5,020.91 $ 7,736.75 $ 6,587.00 $ 10,184.75 $ 9,510.00 $ 9,777.75 $ 7,160.50 $ 55,977.66 $ 130,000.00 01-110-61-00-5303 LITIGATION COUNCIL $ $ $ 16,3SB.59 $ 16,199.68 $ 1,472.85 $ 6,615.25 $ 5,464.60 $ 7,558.92 $ 53,669.89 $ 90,000.00 01-110-61-00-5311 CODIFICATION $ $ $ $ $ $ $ - $ - $ 8,000.00 01-110-61-00-5314 BUILDING INSPECTIONS $ $ 1,665.00 $ 3,270.00 $ $ (3,675.00) $ $ - $ 1,260.00 $ - 01-110-62-00-5401 CONTRACTUAL SERVICES $ 736.00 $ 192.50 $ 464.85 $ 472.96 $ 324.00 $ 309.28 $ 201.15 $ 160.00 $ 2,860.74 $ 8,000.00 01-110-62-00-5402 SPECIAL CENSUS MILEAG $ $ $ $ $ $ $ $ - $ - 01-110-62-00.5403 SPECIAL CENSUS $ $ $ $ $ $ $ $ - $ 01-110-62-00-5404 CABLE CONSORTIUM FEE $ $ $ 17,994.07 $ $ 18,659.87 $ $ $ 19,103.28 $ 55,757.22 $ 50,000.00 01-110-62-00-5406 OFFICE CLEANING $ $ 1,188.00 $ 1,188.00 $ 1,188.00 $ 1,188.00 $ 1,196.00 $ 1,196.00 $ 7,144.00 $ 14,400.00 01-110-62-00-5410 MAINTENANCE-OFFICE $ $ $ $ $ $ $ $ $ 100.00 01-110-62-00-5421 WEARING APPAREL $ $ $ $ $ $ $ $ - $ - 01-110-62-00-5427 FACADE PROGRAM $ $ $ $ $ $ $ - $ - $ - 01-110.62-00-5436 TELEPHONE $ $ 1.48 $ 987.33 $ 991.16 $ 993.12 $ 996.87 $ 1,005.43 $ 994.78 $ 5,970.17 $ 20,000.00 01-110-62-00-5438 CELLULAR TELEPHONE $ $ 119.08 $ 122.17 $ 120.59 $ 123.58 $ 90.00 $ 90.00 $ 90.00 $ 755.42 $ 1,200.00 01-110-62-00-5439 TELEPHONE SYSTEMS MAI $ $ $ 1,472.40 $ $ $ $ - $ 1,472.40 $ 3,000.00 01-110-62-00-5440 BEAVER ST GRANT EXPEN $ $ $ $ $ $ $ - $ - $ - 01-110-64-00-5600 DUES $ 5,885.00 $ 1,035.50 $ $ 462.14 $ $ $ 1,650.00 $ 9,032.64 $ 12,450.00 01-110-64-00-5601 ILLINOIS MUNICIPAL LE $ $ $ $ $ $ $ 1,179.00 $ 1,179.00 $ 1,200.00 01-110-64-00-5603 SUBSCRIPTIONS $ $ $ $ $ $ $ - $ - $ 100.00 01-110-64-00.5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ - $ $ 01-110.64-00.5605 TRAVEL/MEALS/LODGING $ (15.65) $ 56.31 $ 96.00 $ 78.76 $ 25.04 $ 202.88 $ 100.00 $ 543.34 $ 1,000.00 01-110-64-00-5606 PROMOTIONAL/MARKETING $ $ $ $ $ $ - $ - $ $ 01-110-64-00-5607 PUBLIC RELATIONS $ $ $ $ $ 54.90 $ $ $ 54.90 $ 150.00 01-110-64-00-5608 SPONSORSHIPS $ $ $ $ $ $ $ $ - $ - 01-110-64-00-5609 YMCA PARTNERSHIP $ $ $ $ $ $ - $ $ $ - 01-110-64-00-5610 TUITION REIMBURSEMENT $ $ $ $ $ $ - $ $ - $ - 01-110-64-00-5611 KENDALL COUNTY PARATR $ 4,945.75 $ $ $ $ $ $ 10,832.00 $ 15,777.75 $ 30,000.00 01-110-64-00-5612 SENIOR SERVICE FUNDIN $ $ $ $ $ $ $ - $ - $ 5,000.00 01-110-65-00-5800 CONTINGENCIES $ $ $ $ $ $ $ - $ $ 10,000.00 01-110-65-00-5802 OFFICE SUPPLIES $ 48.10 $ 396.99 $ 44.84 $ 1,225.84 $ 216.54 $ - $ 409.92 $ 1,467.36 $ 3,809.59 $ 8,000.00 01-110-65-00-5804 OPERATING SUPPLIES $ 29.00 $ 525.09 $ 887.48 $ 616.02 $ 459.24 $ 171.68 $ 625.21 $ 207.67 $ 3,521.39 $ 7,000.00 01-110-65-00-5808 POSTAGE&SHIPPING $ (5.18 $ 168.33 $ 118.92 $ 3,993.45 $ 106.92 $ 60.89 $ 856.24 $ 435.22 $ 5,734.79 $ 14,000.00 01-110-65-00-5809 PRINTING&COPYING $ (0.70) $ 780.54 $ 1,343.94 $ 536.20 $ 445.14 $ 403.16 $ 1,130.58 $ 586.92 $ 5,225.78 $ 6,750.00 01-110-65-00-5810 PUBLISHING&ADVERTIS $ $ $ $ 10.40 $ $ $ 335.05 $ 345.45 $ 2,000.00 01-110-72-00-65001MRF PARTICIPANTS $ 1,812.55 $ 1,783.21 $ 1,847.85 $ 3,035.69 $ 1,217.24 $ 3,019.85 $ 2,195.60 $ 3,996.29 r$ 62,500.00 .28 $ 27,153.00 01-110-72-00-6501 SOCIAL SECURITY&MED $ 1,548.27 $ 1,512.98 $ 1,566.23 $ 2,501.76 $ 1,102.64 $ 2,510.24 $ 1,861.10 $ 3,372.37 .59 $ 26,463.00 01-110-75.00-7002 COMPUTER EQUIP&SOFT $ $ 709.98 $ $ 1,233.75 $ $ - $ .73 $ 850.00 01-110-75-00-7003 OFFICE EQUIPMENT $ $ $ 608.15 $ $ $ - $ - 8.15 $ 01-110-78-00-9002 NICOR GAS $ $ 144.60 $ 1,166.81 $ 1,544.04 $ 1,285.72 $ 774.54 $ 969.04 $ 2,251.88 6.63 $ 31,000.00 01-110-78-00-9004 MISCELLANEOUS $ $ $ S $ $ - $ - $ - 01-110-78-00.9005 MERIT/PAY INCREASE $ $ - $ $ $ - $ $ -01-110-78-00-9007 APPRECIATION DINNER $ $ $ $ $ $ $ - - $ 01-110-78-00-9008 VOLUNTEER APPRECIATIO $ $ $ $ $ $ - $ - $ 01-110-78-00-9009 WEBSITE $ $ $ $ $ $ $ - $ 01-110-78-00-9010 COMMUNITY EVENTS $ $ $ $ $ $ - $ -01-110-78.00-9011 TENNIS CRT REFURBISHI $ $ $ $ $ $ $ - - $ 01-110-78-00-9013 HOLIDAY UNDER THE STA $ $ $ $ $ $ 300.00 $ 4,223.25 $ 919.11 .36 OS-110-78-00-9014 CAR ALLOWANCE $ $ $ $ $ $ $ -01-110-99-00-9970 TRANSFER TO CW CAPITA $ $ $ 31,250.00 $ $ $ 31,250.00 $ .00 $ 125,000.00 2 of 18 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/1-14-11 ACTUAL 0fPEN3ES dY MbM ACCOUNT NUMBER ANDDESCRIPnON May-LO ILme-10 July-LO Allp5t-10 54p"bar-lA Octoher40 November-10 Detembat-10 fenuary-11 February-11 Mzr[h-ll April-11 YEAR-TO-OATE ANNUAL TOTALS_-_ BUDGET_ - 01-110-99-00-9975 TRANSFER 785 TOTAL ADMIN XPIENSES $ 37,383.79 $ 37,240.06 $ 125,723.19 80 $ - $ - $ 9,375.00 $ - I $ 18,750.00 $ 37,500.00 $ 82,498.03 $ 57,221.10 $ 102,169.98 $ , .31 $ 94,383.51 $ - $ $ - $ - $ 617,404.97 $ 1,016,243.00 GENERAL FUND-FINANCE EXPENSES O1-120.50-00-5106 SALARIES-FINANCE $ 18,015.48 $ 18,015.49 $ 23,436.74 $ 16,183.77 $ 5,396.69 $ 22,278.50 $ 17,209.95 $ 25,169.50 $ 145,706.12 $ 259,690.00 01-120-50-00-5136 SALARIES-PART TIME $ $ $ $ $ $ $ $ $ 01-120-50-00-5137 SALARIES-OVERTIME $ $ $ $ $ $ $ $ - $ - 01-120-50-00-5202 BENEFITS-UNEMPLOY.C $ 9,108.84 $ $ 13,663.25 $ $ $ 13,663.25 $ $ 36,435.34 $ 38,000.00 01-120-50-00-5203 BENEFITS-HEALTH INSU $ 284,297.20 $ 75,984.28 $ 155,709.99 $ (895.84) $ 86,963.34 $ (958.53) $ 164,870.46 $ 108,071.80 $ 874,042.70 $ 1,156,090.00 O1-120-50-00-5204 BENEFITS-GROUP LIFE $ 1,744.16 $ 1,744.16 $ 1,723.49 $ 1,723.49 $ 1,723.49 $ 1,702.82 $ 1,702.82 $ 1,772.96 $ 13,837.39 $ 28,240.00 01-120-50-00-5205 BENEFITS-DENTAL/VIS $ 15,124.32 $ 8,139.52 $ 14,551.15 $ 459.05 $ 8,427.62 $ 390.66 $ 15,501.18 $ 6,977.50 $ 69,571.00 $ 100,880.00 O1-120-61-00-5304 AUDIT FEES&EXPENSES $ $ $ $ $ $ $ 1,500.00 $ 1,500.00 $ 3,000.00 $ 57,700.00 01-120-61-00-5310 EMPLOYEE ASSISTANCE $ 404.16 $ $ $ 606.24 $ $ $ 606.24 $ 1,616.64 $. 4,000.00 01-120-62-00-5400 INSURANCE-LIABILITY $ 11,722.00 $ 54,721.50 $ 11,722.00 $ 11,972.00 $ 54,721.50 $ 11,723.00 $ 11,722.00 $ 23,051.00 $ 191,355.00 $ 344,129.00 01-120-62-00-5401 CONTRACTUAL SERVICES $ $ 1,958.00 $ 489.00 $ 1,776.00 $ 1,057.50 $ 374.50 $ 1,440.00 $ 2,138.00 $ 9,233.00 $ 28,000.00 O1-120-62-00-5410 MAINTENANCE-OFFICE E $ $ $ 838.00 $ $ $ $ $ 838.00 $ 1,800.00 01-120-62-00-5411 MAINTENANCE-COMPUTER $ $ $ $ $ $ $ - $ - $ 500.00 O1-120-62-00-5412 MAINTENANCE-PHOTOCOP $ $ 1,572.00 $ 1,572.00 $ 1,572.00 $ 2,308.00 $ 1,572.00 $ 836.00 $ 2,308.00 $ 11,740.00 $ 27,000.00 O1-120-62-00-5437 ACCTG SYSTEM SERVICE $ $ $ $ $ $ - $ $ - $ 15,000.00 01-120-62-00-5438 CELLULAR TELEPHONE $ $ 58.16 $ 64.34 $ 61.19 $ 67.16 $ 28.92 $ 28.28 $ 74.86 $ 382.91 $ 1,010.00 01-120.64.00-5600 DUES $ 120.00 $ $ $ 35.00 $ $ - $ $ 170.00 $ 325.00 $ 1,600.00 O1-120-64-00-5603 SUBSCRIPTIONS/BOOKS $ $ $ $ $ - $ $ - $ - $ 250.00 01-120-64.00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ - $ - $ - $ 01-120.64.00-5605 TRAVEL/MEALS/LODGIN $ $ $ $ $ $ - $ - $ $ O1-120-65-00-5800 CONTINGENCIES $ $ $ $ $ $ $ - $ - $ - 01-120.65-00-5801 FUND BALANCE RESERVE $ $ $ $ $ $ - $ - $ - $ - 01-120-65-00-5802 OFFICE SUPPLIES $ $ 224.09 $ 38.01 $ $ 53.80 $ - $ - $ 96.61 $ 412.51 $ 2,000.00 01-120-65-00.5804 OPERATING SUPPLIES $ 100.10 $ $ $ 158.85 $ 100.10 $ 157.22 $ $ 516.27 $ 3,500.00 O1-120-65-00.5808 POSTAGE&SHIPPING $ $ $ 94.25 $ 18.73 $ 29.90 $ 61.49 $ - $ 204.37 $ 2,500.00 O1-120-65-00-5809 PRINTING&COPYING $ $ $ $ $ $ $ $ - $ 1,000.00 O1-120-65-00.5844 MARKETING-HOTEL TAX $ $ $ 1,258.49 $ 2,665.74 $ 3,653.47 $ 4,992.99 $ 2,688.53 $ 3,902.98 $ 19,162.20 $ 20,000.00 01-120-72-00.6500 IMRF PARTICIPANTS $ 1,644.82 $ 1,644.82 $ 2,139.78 $ 1,477.60 $ 492.72 $ 2,034.05 $ 1,571.28 $ 2,320.82 $ 13,325.89 $ 25,190.00 01-120-72-00-6501 SOCIAL SECURITY&MED $ 1,335.38 $ 1,354.33 1$ 1,772.15 $ 1,238.55 $ 400.38 $ 1,694.60 $ 1,310.56 $ 1,935.46 $ 11,041.41 $ 29,070.00 O1-120-75-00-7002 COMPUTER EQUIP&SOFT $ $ 15.77 $ 24.76 $ 15.77 $ 45.74 $ 1,159.65 $ 354.16 $ 324.08 $ 1,939.93 $ 5,000.00 O1-120-75-00-7003 OFFICE EQUIPMENT $ $ - $ $ $ - $ - $ $ - $ 250.00 01-120-78-00-9001 CITY TAX REBATE $ $ $ $ $ 811.70 $ - $ - $ 811.70 $ 1,050.00 O1-120-78-00-9003 SALES TAX REBATE $ $ 33,521.91 $ 157,137.94 $ 25,985.06 $ 203,698.11 $ $ - $ 420,343.02 $ 620,000.00 O1-120-78-00-9004 BUSINESS DISTRICT REB $ $ 18,606.77 $ 47,247.67 $ 22,943.42 $ $ 46,866.59 $ - $ 45,936.81 $ 181,601.26 $ 150,000.00 01-120-78-00-9005 MERIT/COLA $ - $ - $ $ - $ - $ - $ $ - $ - 01-120-78-00-9013 AMUSEMNT TAX REBATE $ $ $ $ $ $ 99,959.44 $ - $ 99,959.44 $ 63,000.00 01-120-78.00-9099 BAD DEBT $ $ $ $ $ $ - $ - $ 01-120-99-00-9925 TRANSFER TO SAN SEWER $ $ $ $ $ $ - $ - $ $ - 01-120-99-00-9930 TRANSFER TO WATER IMP $ $ $ $ $ $ $ $ - $ O1-120-99-00-9935 TRANSFER TO LAND CASH $ $ $ $ $ $ - $ - $ $ O1-120-99-00-9940 TRANSFER TO PARK&RE $ 79,324.16 $ 79,324.16 $ 79,324.16 $ 79,324.16 $ 79,324.16 $ 79,324.16 $ 79,324.16 $ 79,324.16 $ 634,593.28 $ 951,890.00 O1-120-99-00-9941 TRANSFER TO PARK&RE $ 100,000.00 $ $ $ $ $ $ - $ 100,000.00 $ 100,000.00 O1-120-99-00-9942 TRANSFER TO POLICE CA $ $ $ $ $ $ - $ $ $ 25,000.00 01-120-99-00-9945 TRANSFER TO GF FOR PD $ $ - $ - $ $ $ - $ $ - $ - 01-120-99-00-9965 TRANSFER TO DEBT SERV $ $ $ 107,351.00 $ - $ $ 107,351.00 $ - $ 214,702.00 $ 429,404.00 TOTAL FINANCE EXPENSES $ 522,940.62 $ 296,884.96 $ 620,158.17 $ 167,320.78 $ 449,275.38 $ 394,376.31 $ 300,665.62 $ 305,074.54 $ - $ - $ - $ - $ 3,056 696-38 $ 4,492,743.00 GENERAL FUND-COMMUNITY RELATIONS EXPENSES 01-130-50-00-5106 SALARIES-PUBLIC RELAT $ 5,000.00 $ 5,000.00 $ 5,000.00 $ 7,500.00 $ 2,500.00 $ 7,500.00 $ 5,000.00 $ 5,000.00 k$ 42 .00 $ 63,750.00 O1-130-50-00-5136 SALARIES-PART TIME $ - $ - $ - $ - $ - $ - $ $ 01-130-62-00-5401 CONTRACTUAL SERVICES $ $ 308.00 $ 583.00 $ 111.00 $ 496.00 $ 111.00 $ 250.00 $ 518.00 .00 $ 4,800.00 O1-130.62-00-5438 CELLULAR TELEPHONE $ - $ 29.08 $ 32.17 $ 30.59 $ 33.58 $ 28.92 $ 28.28 $ 29.86 .48 $ 540.00 O1-130-64-00-5603 SUBSCRIPTIONS&BOOKS $ $ $ $ $ $ - $ - $ 100.00 01-130.64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ - $ O1-130-64-00-5605 TRAVEL/MEALS/LODGING $ - $ $ $ $ - $ - $ - - $O1-130-64-00-5607 PUBLIC RELATIONS $ $ 19.27 $ $ $ $ $ .27 $ 1,750.00 O1-130-65-00-5802 OFFICE SUPPLIES $ $ $ $ 27.98 $ $ 56.00 $ .98 $ 750.00 O1-130-65-00-5808 POSTAGE&SHIPPING $ $ $ 440.00 $ $ $ - $ 440.00 0.00 $ 3,500.00 O1-130-65-00-5809 PRINTING&COPYING $ $ $ $ $ $ $ - - $ 1,000.00 O1-130-65-00-5810 PUBLISHING&ADVERTIS $ $ $ $ 1,987.56 $ $ $ $ 2,000.66 .22 $ 7,500.00 01-130-72-00-65001MRF PARTICIPANTS $ 456.50 $ 456.50 $ 456.50 $ 684.75 $ 228.25 $ 684.75 $ 456.50 $ 456.50 .25 $ 6,184.00 O1-130-72-00-65015OCIAL SECURITY&MED $ 294.30 $ 294.30 $ 294.30 $ 441.45 $ 147.15 $ 447.30 $ 294.30 $ 294.30 .40 4,877.00 O1-130-78-00-9005 MERIT/COLA $ $ - $ 3 of 18 UNITED CRY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/1-14-11 J► AL E1CpEN58S BY IMfONIH - - - -- ACCOLIMNUMBERANG�145CRMON MAY.10 June-l0 July-lD August-10 Septemher-10 Odober-7o N*"mbeT-10 Dacemher-10 Januaryp-11 February-11 Mardi-11 April-11 YEARTALS E ANNUAL TOTALS BUDGET 01-130.78-00-9010 COMMUNITY EVENTS $ (665.00) $ (425.00)1$ 217.98 $ $ 111.44 $ $ - $ (760.58) $ 6,000.00 01-130-78-00-9013 HOLIDAY UNDER THE STA $ $ 425.00 $ $ 100.00 $ $ 8.25 $ - $ 3,145.00 $ 3,678.25 $ 9,585.00 TOTAL COMMUNITY RELATIONS EXPENSES $ 5,085.80 $ 6,107.15 $ 7,023.95 $ 10,883.33 $ 3,516.42 $ 8,836.22 $ 6,469.08 $ 11,444.32 $ 59,366.27 $ 110,336.00 GENERAL FUND-ENGINEERING EXPENSES 03-150-50-00-5107 SALARIES-ENGINEERING $ 21,996.67 $ 20,761.12 $ 20,761.11 $ 31,141.64 $ 10,380.56 $ 30,679.82 $ 20,761.12 $ 28,115.08 $ 184,597.12 $ 263,233.00 01-150-50-00-5137 SALARIES-OVERTIME $ $ $ $ 86.59 $ $ $ $ 86.59 $ 500.00 01-150.62-00-5401 CONTRACTUAL SERVICES $ $ 427.00 $ 593.99 $ $ $ 150.00 $ 45.00 $ 808.50 $ 2,024.49 $ 30,000.00 01-150-62.00-5403 FEES $ $ $ 1,000.00 $ $ $ $ - $ 1,000.00 $ 2,550.00 01-150-62-00-5409 MAINTENANCE-VEHICLES $ 36.68 $ $ 63.99 $ 34.95 $ 410.90 $ 720.00 $ 2.35 $ 1,268.87 $ 1,500.00 01-150-62.00-5410 MAINTENANCE-OFFICE EQ $ $ $ $ $ $ $ - $ - $ 500.00 01-150-62-00-5411 MAINTENANCE-COMPUTERS $ $ $ $ $ $ $ $ $ 500.00 01-150.62-00-5421 WEARING APPAREL $ $ $ $ $ $ $ $ - $ 100.00 01-150-62-00-5438 CELLULAR TELEPHONE $ $ 116.32 $ 128.68 $ 122.37 $ 134.31 $ 115.69 $ 113.13 $ 119.43 $ 849.93 $ 3,000.00 01-150-64-00-5600 DUES $ $ $ $ $ $ 240.00 $ - $ 240.00 $ 1,000.00 01-150.64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ - $ - $ $ $ 01-150-64-00-5605 TRAVEL EXPENSE $ $ $ $ $ $ - $ $ $ - 01-150-64-00-5608 TUITION REIMBURSEMENT $ $ $ $ $ $ $ $ $ 01-150-64-00-5616 BOOKS&PUBLICATIONS $ $ $ $ $ - $ $ $ 126.00 $ 126.00 $ 130.00 01-150-65-00-5801 ENGINEERING SUPPLIES $ $ 17.21 1$ $ 267.87 $ 18.99 $ 71.12 $ 238.32 $ 94.39 $ 707.90 $ 2,000.00 01-150.65.00-5802 OFFICE SUPPLIES $ 3.15 $ 36.08 $ 57.62 $ $ 86.47 $ 23.28 $ $ 58.67 $ 265.27 $ 1,250.00 01-150-65-00-5808 POSTAGE&SHIPPING $ $ $ $ $ - $ $ $ - $ 500.00 01-150.65-00-5809 PRINTING&COPYING $ $ 108.80 $ 100.23 $ 150.32 $ 96.12 $ 91.95 $ 117.86 $ 149.41 $ 814.69 $ 1,500.00 01-150-65.00-58161SWS GOUNDWTR STUDY $ $ $ $ $ - $ $ $ - $ 01-150-72-00-65001MRF PARTICIPANTS $ 2,008.29 $ 1,895.48 $ 1,895.48 $ 2,851.12 $ 947.74 $ 2,801.06 $ 1,895.48 $ 2,566.90 $ 16,861.55 $ 25,582.00 01-150-72-00-6501 SOCIAL SECURITY&MED $ 1,620.58 $ 1,526.06 $ 1,526.06 $ 2,295.69 $ 763.03 $ 2,269.53 $ 1,526.06 $ 2,096.12 $ 13,623.13 $ 20,176.00 01-150-75-00-7002 COMPUTER EQUIPMENT& $ $ 262.80 $ 398.80 $ $ 1,389.79 $ - $ - $ 262.80 $ 2,314.19 $ 3,300.00 01-150.75-00-7003 OFFICE EQUIPMENT $ $ $ $ $ $ - $ - L $ $ 500.00 01-150-78-00-9005 MERIT/COLA 01-150-78-00-9015 ENERGY&RECYCLING GR $ $ $ $ 5,307.00 $ $ - $ - $ 5,307.00 $ - TOTAL ENGINEERING EXPENSES $ 25,665.37 1$ 25,150.87 1$ 26,525.96 1$ 42,257.55 $ 14,227.91 1$ 37,162.45 $ 24,699.32 $ 34,397.30 $ - $ - $ - $ - $ 230,086.73 $ 357,821.00 GENERAL FUND-POLICE EXPENSES 01-210-50-00-5107 SALARIES-POLICE $ 110,899.51 $ 87,416.36 $ 88,012.39 $ 129,454.32 $ 44,413.88 $ 132,625.97 $ 89,748.25 $ 90,339.74 $ 772,910.42 $ 1,316,326.00 01-210-50-00-5131 SALARIES CHIEF/LT./S $ 49,772.92 $ 52,821.25 $ 50,916.00 $ 77,069.26 $ 26,416.17 $ 75,819.25 $ 47,798.35 $ 58,186.77 $ 438,799.97 $ 673,166.00 01-210-50-00-5134 SALARIES CROSSING GU $ 2,097.25 $ 638.25 $ $ 369.25 $ 949.50 $ 2,974.00 $ 1,889.50 $ 1,680.75 $ 10,598.50 $ 25,000.00 01-210-50-00-5135 SALARIES-POLICE CLER $ 16,198.50 $ 16,198.49 $ 15,178.49 $ 18,177.75 $ 6,059.24 $ 18,177.73 $ 12,093.50 $ 16,013.69 $ 118,097.39 $ 212,386.00 01-210-50-00-5136 SALARIES-PART TIME $ 2,081.48 $ 2,261.05 $ 2,227.35 $ 2,620.99 $ 1,846.50 $ 3,996.33 $ 2,503.34 $ 2,165.94 $ 19,702.98 $ 39,000.00 01-210.50-00-5137 SALARIES-OVERTIME $ 7,025.27 •$ 11,666.53 $ 12,420.47 $ 4,053.75 $ (2,157.50) $ 7,913.23 $ 256.92 $ 8,182.41 $ 49,361.08 $ 60,000.00 01-210-50-00-5200 CADET PROGRAM $ 697.50 $ 834.75 $ 1,210.50 $ 1,584.00 $ 555.75 $ 1,017.00 $ 697.50 $ 681.75 $ 7,278.75 $ 13,500.00 01-210-50-00-5205 SALARIES-GRANT REIMB $ 1,402.51 $ 18,322.76 $ 19,725.27 01-210-61-00-5300 LEGAL SERVICES $ $ $ $ $ $ $ $ - $ 20,000.00 01-210-62-00-5401 CONTRACTUAL SERVICES n/a n/a n/a n/a $ 275.71 $ 55.22 $ 54.97 $ 54.92 $ 440.82 $ - 01-210.62-00-5408 MAINTENANCE-EQUIPME $ $ 35.80 $ 237.50 $ 1,573.16 $ 68.50 $ 1,065.31 $ 372.99 $ 723.70 $ 4,076.96 $ 9,750.00 01-210-62-00-5409 MAINTENANCE-VEHICLE $ 1,338.84 $ 1,568.12 $ 3,565.06 $ 3,853.65 $ 4,270.98 $ 2,925.02 $ 1,626.45 $ 1,602.18 $ 20,750.30 $ 47,000.00 01-210-62-00-5410 MAINT-OFFICE EQUIPMEN $ $ - $ $ 65.00 $ (65.00) $ - $ $ - $ - 01-210-62-00.5411 MAINTENANCE-COMPUTE $ $ 123.49 $ $ $ - $ 148.82 $ $ 272.31 $ 2,500.00 01-210-62-00-5412 MAINTENANCE-K9 $ $ $ $ (54.50) $ 65.00 1$ $ $ 10.50 $ 1,000.00 01-210.62-00-5414 WEATHER WARNING SIREN $ $ 414.00 $ $ 182.88 $ 2,915.66 $ $ $ 3,512.54 $ 4,000.00 01-210-62-00.5421 WEARING APPAREL $ 84.95 $ 134.95 $ 1,343.33 $ 2,495.69 $ 486.48 $ 396.98 $ 853.85 $ 689.74 $ 6,485.97 $ 10,000.00 01-210-62-00-5422 COPS GRANT IV-VESTS $ $ $ $ 1,825.00 $ 610.00 $ 1,210.00 $ - $ 3,645.00 $ 4,200.00 01-210-62-00-5429 PSYCHOLOGICAL TESTING $ $ $ $ $ - $ $ $ - $ 01-210-62-00-5430 HEALTH SERVICES $ $ $ $ $ - $ - $ - $ $ 01-210-62-00-5431 LABORATORY FEES $ - $ - $ - $ - $ - $ $ $ $ 01-210-62-00-5432 KENDALL CO.JUVENILE $ $ $ $ $ $ $ $ 2,683.05 $ 2,683.05 $ 3,000.00 01-210-62-00-5436 TELEPHONE $ $ (414.25) $ 876.12 $ 916.92 $ 905.83 $ 908.89 $ 888.53 $ 909.31 $ 4,991.35 $ 21,500.00 01-210-62-00-5438 CELLULAR TELEPHONE $ $ 1,099.59 $ 1,181.57 $ 1,129.52 $ 1,228.09 $ 1,074.39 $ 1,053.30 $ 1,105.24 $ 7,871.70 $ 17,920.00 01-210-62-00-5441 MTD-ALERTS FEE $ 3,330.00 $ $ $ $ $ 3,330.00 $ $ 6,660.00 $ 5,150.00 01-210-62-00-5442 NEW WORLD LIVE SCAN $ $ $ 8,286.30 $ $ $ $ - $ 8,286.30 $ 15,000.00 01-210-62-00-5443 ADMIN ADJUDICATION CO $ 175.00 $ 1,068.00 $ 1,759.00 $ 1,287.00 $ 1,712.00 $ 1,325.00 $ 1,425.00 $ 1,056.00 $ 9,807.00 $ 15,000.00 01-210-64-00-5600 DUES $ 170.00 $ 1,000.00 01-210-64-00.5603 SUBSCRIPTIONS $ $ $ $ $ $ $ - I $ $ 350.00 01-210-64-00.5604 TRAINING&CONFERENCE $ 2,340.00 1$ $ 210.00 $ $ 582.05 $ 325.00 $ 350.00 $ 525.00 $ 4,332.05 $ 8,025.00 01-210-64-00-5605 TRAVEL EXPENSES $ $ 217.28 $ $ (217.28) $ 51.47 $ 46.10 $ - $ 284.40 $ 381.97 $ 6,575.00 01-210-64-00.5606 COMMUNITY RELATIONS $ $ $ 12.04 $ $ $ $ § 12.04 $ 500.00 01-210-64-00-5607 POLICE COMMISSION $ $ 445.00 $ $ 171.25 $ - $ 100.00 $ 1,063.50 $ 618.50 $ 2,398.25 $ 7,000.00 01-210-64-00-5608 TUITION REIMBURSEMENT $ $ 126.21 $ 844.63 $ $ $ - $ - $ 970.84 $ 2,800.00 4 of 18 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/1-14-11 ACfUAIL EINSfi'a BY MONTH - -- - ---- �_ _ B - A --- ---- - ---.. . -- '- - ----q- --APri'�If ANNUAL ACCOUNT NUMBER AND DESCRIPTION Ms 10 - June-10 July-lo Au ust-10 Se tember-10 Odabcr-10 Novcmher-10 December-10 lanua -11 Februa 11 March-11 i, ! Y SATE BUDGE- 01-210-64-00-5609 POLICE RECRUIT ACADEM $ - $ - $ - $ - $ - $ - $ - $ $ 01-210-64-00.5610 GUN RANGE FEES $ $ - $ $ $ $ $ $ $ 500.00 01-210-64-00-5611 SRT FEE $ 3,500.00 $ $ $ - $ $ $ $ 3,500.00 $ 3,500.00 01-210-64-00.5612 NEIGHBORHOOD WATCH $ $ $ $ - $ $ $ $ $ 1,500.00 01-210-64-00-5613 CITIZENS POLICE ACADE $ $ $ $ $ $ $ $ $ 1,839.00 01-210-64-00-5614 CHAPLAIN PROGRAM $ - $ $ $ $ $ $ $ $ - 01-210.64-00-5615 COMPLIANCE CHECKS $ $ $ $ $ $ $ $ $ 500.00 01-210-64-00-5616 DARE PROGRAM $ $ $ $ $ $ 2,244.98 $ $ 2,244.98 $ 3,000.00 01-210.65.00-5801 SUPPLIES-GRANT REIMB $ $ 45.92 $ $ $ $ 6.21 $ 11.73 $ 63.86 $ 01-210-65-00-5802 OFFICE SUPPLIES $ 43736 $ 88.18 $ 94.45 $ 64.18 $ 232.84 $ 674.19 $ 126.46 $ 206.38 $ 1,924.04 $ 3,000.00 01-210-65-00-5803 EVIDENCE TECH SUPPLIE $ $ $ $ $ $ $ $ - $ 1,000.00 01-210.65-00-5804 OPERATING SUPPLIES $ 14.55 $ 460.30 $ 646.24 $ 380.18 $ 285.52 $ 681.06 $ 642.57 $ 1,132.54 $ 4,242.96 $ 8,500.00 01-210-65-00-5808 POSTAGE&SHIPPING $ $ $ $ 95.74 $ 45.71 $ $ $ 47.39 $ 188.84 $ 3,000.00 01-210-65-00-5809 PRINTING&COPYING $ $ 114.61 $ 456.69 $ 228.18 $ 213.65 $ 89.20 $ 75.01 $ 100.28 $ 1,277.62 $ 4,500.00 01-210-65-00-5810 PUBLISHING&ADVERTIS $ $ $ 25.60 $ $ $ $ $ 25.60 $ 100.00 01-210-65-00-5812 GASOLINE $ $ 5,571.25 $ 5,403.37 $ 5,556.52 $ 5,257.04 $ 4,989.80 $ 5,289.94 $ 4,779.71 $ 36,847.63 $ 80,000.00 01-210.65-00-5813 AMMUNITION $ $ $ $ $ $ $ $ 1,995.00 $ 1,995.00 $ 2,000.00 01-210-65-00-5814 ADMIN ADJUDICATION OP $ $ $ $ $ $ $ - $ $ 1,000.00 01-210-72-00.65001MRF PARTICIPANTS $ 1,478.92 $ 1,478.92 $ 1,385.79 $ 1,659.63 $ 553.21 $ 1,659.63 $ 1,104.14 $ 1,462.04 $ 10,782.28 $ 24,384.00 01-210-72-00.6501 SOCIAL SECURITY&MED $ 13,929.96 $ 12,645.33 $ 12,482.41 $ 17,445.32 $ 6,398.32 $ 17,915.44 $ 11,992.67 $ 12,857.23 $ 105,666.68 $ 178,962.00 01-210-72-00.6502 POLICE PENSION $ $ $ 25,704.86 $ 132,566.85 $ 34,362.70 $ 126,187.34 $ 8,884.76 $ 8,368.38 $ 336,074.89 $ 325,000.00 01-210-75-00-7002 COMPUTER EQUIP&SOFT $ $ $ $ 2,467.50 $ $ $ - $ 2,467.50 $ 7,000.00 01-210-78-00-9004 BIKE PATROL $ $ $ $ $ $ $ $ $ 01-210-78-00-9005 MERIT/COLA $ $ $ $ $ $ - $ - $ $ 01-210-78-00-9006 K9 STIPEND $ 230.76 $ 135.98 $ 103.02 $ $ $ $ $ 469.76 $ TOTAL POLICE EXPENSES $ 215,682.77 $ 197,195.36 $ 234,703.18 $ 407,021.71 $ 138,539.30 $ 409,882.09 $ 192,205.74 $ 236,774.80 $ - $ - $ $ - $ 2,032,004.95 $ 3,190,933.00 GENERAL FUND-COMMUNITY DEVELOPMENT EXPENSES 01-220.50-00-5107 SALARIES-PLANNING& $ 20,997.81 $ 22,390.20 $ 22,310.20 $ 32,699.32 $ 11,265.10 $ 33,395.31 $ 22,570.20 $ 27,872.14 $ 193,500.28 $ 287,132.00 01-220-61-00-5300 LEGAL SERVICES $ $ 147.00 $ $ 1.00 $ 197.00 $ 146.00 $ 147.00 $ 891.00 $ 1,529.00 $ 8,000.00 01-220-61-00-5314 INSPECTIONS $ $ $ $ $ 7,377.00 $ 1,125.00 $ $ 3,015.00 $ 11,517.00 $ 25,000.00 01-220-62-00-5401 CONTRACTUAL SERVICES $ $ $ 876.17 $ 725.00 $ 102.75 $ 34.25 $ $ 1,738.17 $ 13,000.00 01-220.62-00-5430 PLANNING CONSULTANT $ $ $ $ $ $ $ $ $ - 01-220-62-00-5432 ECONOMIC DEVELOPMENT $ $ $ $ $ $ $ - $ - $ 45,000.00 01-220-62-00-5438 CELLULAR TELEPHONE $ $ 98.15 $ 204.32 $ 101.18 $ 107.15 $ 97.83 $ 96.56 $ 99.70 $ 804.89 $ 1,500.00 01-220-64-00-5600 DUES $ 463.00 $ $ $ $ $ $ $ 100.00 $ 563.00 $ 1,500.00 01-220-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ 15.00 $ $ - $ 40.00 $ 55.00 $ 200.00 01-220-64.00-5605 TRAVEL EXPENSE $ $ $ $ $ $ $ $ $ - 01-220.65-00-5802 OFFICE SUPPLIES $ 53.11 $ 16.64 $ 52.73 $ 33.92 $ 37.37 $ 62.14 $ $ 76.58 $ 332.49 $ 500.00 01-220.65-00-5804 OPERATING SUPPLIES $ 135.94 $ 6.50 $ 316.20 $ $ 5.94 $ 71.13 $ - $ 33.40 $ 569.11 $ 3,500.00 01-220-65-00-5808 POSTAGE&SHIPPING $ $ $ $ $ $ $ $ 6.96 $ 6.96 $ 1,000.00 01-220-65-00-5809 PRINTING&COPYING $ $ 108.80 $ 95.24 $ 150.33 $ 96.12 $ 91.95 $ 78.67 $ 139.41 $ 760.52 $ 1,300.00 01-220-65-00-5810 PUBLISHING&ADVERTIS $ $ 86.90 $ $ $ $ $ - $ 86.90 $ 150.00 01-220.65-00-5814 BOOKS&MAPS $ $ $ $ 202.10 $ $ $ - $ 202.10 $ 500.00 01-220-72-00-65001MRF PARTICIPANTS $ 1,662.35 $ 1,794.04 $ 1,794.04 $ 2,985.42 $ 1,028.49 $ 3,048.95 $ 2,060.64 $ 2,544.71 $ 16,918.64 $ 27,852.00 01-220-72-00.6501 SOCIAL SECURITY&MED $ 1,513.95 $ 1,638.45 $ 1,619.33 $ 2,352.61 $ 812.15 $ 2,423.10 $ 1,631.56 $ 2,056.37 $ 14,047.52 $ 21,966.00 01-220-75-00-7002 COMPUTER EQUIP&SOFT $ $ $ $ 1,993.03 $ 104.98 $ - $ 72.98 $ 2,170.99 $ 7,955.00 01-220-75-00.7003 OFFICE EQUIPMENT $ $ $ $ $ $ $ - $ $ 125.00 01-220-75.00-7004 IL TOMORROW GRANT MAT $ $ $ $ $ $ $ - $ $ - 01-220-78-00-9005 MERIT/COLA $ $ $ $ $ $ - $ - $ $ 01-220-78-00-9012 SALARY SURVEY $ $ $ $ $ $ $ - $ $ 01-220-78-00-9013 PLAN REVEIW $ $ $ $ $ $ $ - $ $ 01-220-78-00-9015 RAIN GARDEN GRANT $ $ $ $ $ $ $ - $ $ 01-220-78-00-9016 FULL CIRCLE GRANT $ (9,145.00)1$ 325.00 $ 155.00 $ 7,048.18 $ (7,477.06) $ $ - $ 17,442.31 $ 8,348.43 $ - TOTAL COMMUNITY DEVELOPMENT ExPENsEsl$ 15,681.16 $ 26,611.68 $ 27,423.23 $ 48,292.09 $ 13,671.99 $ 40,495.66 $ 26,657.61 $ 54,317.58 $ - $ $ $ $ 253,151.00 $ 446,180.00 GENERAL FUND-STREETS EXPENSES 01-410-50-00-5107 SALARIES-STREETS $ 22,823.93 $ 21,647.26 $ 22,964.73 $ 33,445.49 $ 11,296.22 $ 33,854.65 $ 22,590.98 $ 25,995.90 $ 194,619.16 $ 243,472.00 01-410-50-00-5136 SALARIES-PART TIME $ $ m $ $ $ $ $ - $ $ 01-410-50-00-5137 SALARIES-OVERTIME $ 538.01 $ 605.83 $ 278.57 $ 696.43 $ $ 603.56 $ 371.43 $ 1,765.03 $ 4,858.86 $ 28,000.00 01-410-61-00.5313 ENGINEERING-IN TOWN $ $ $ $ $ $ $ $ $ 01-410-61-00.5314 INSPECTIONS&LICENSE $ $ $ $ $ 137.00 $ $ - $ 137.00 $ 700.00 01-410-62-00-5401 CONTRACTUAL SERVICES $ $ 19.99 $ 19.98 $ 44.98 $ 19.98 $ 19.98 $ 53.30 $ 19.98 $ 198.19 $ 1,000.00 01-410.62-00-5408 MAINTENANCE-EQUIPMENT $ $ (2,259.25) $ 2,540.88 $ 79.33 $ 219.90 $ 1,613.75 $ 181.29 $ 51.21 $ 2,427.11 $ 10,000.00 O1-410-62-00-5409 MAINTENANCE-VEHICLES $ 475.42 $ 68.29 $ 923.67 $ $ 521.70 $ 1,944.12 $ 9,714.20 $ 3,158.38 $ 16,805.78 $ 25,000.00 01-410-62-00.5414 MAINTENANCE-TRAFFICS $ (49.55) $ (13,233.67) $ 567.55 $ $ 3,059.81 $ 3,465.06 $ 1,017.00 $ 5.97 $ (5,167.83) $ 15,000.00 01-410-62-00-5415 MAINTENANCE-STREET U $ 192.00 $ 1,370.75 $ 4,235.05 1$ (2,620.96)1$ 725.39 1$ 485.72 1$ 549.40 1$ 389.64 1 JL$ 5,326.99 $ 9,000.00 5 of 18 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/1-14-11 - ACTUAL EXPENSES BY MONTH - - - - - - -- YEAIL YO•DATE ACCOUNT NUMBER AND DESCRIPTION May-10 June-1D July-10 August-l0 Septomher-10 October-10 November-10 December-10 January-11 Februaq,11 March-11 April-12 ANNUAL _ TOTALS BUDGET 01-410-62-00-5416 MAINTENANCE PROPERTY $ 150.00 $ 74.97 $ 1,372.60 $ 1,975.75 $ 120.53 $ 223.94 $ 1,081.60 $ 480.61 $ 5,480.00 $ 30,000.00 01-410.62-00.5420 MAINTENANCE-STORM SEW $ $ $ 119.78 $ $ $ 4,474.02 $ 878.74 $ 5,472.54 $ 5,000.00 01-410-62-00-5421 WEARING APPAREL $ 65.61 $ 85.54 $ 150.37 $ 142.02 $ 159.59 $ 251.42 $ 314.75 $ 125.42 $ 1,294.72 $ 4,200.00 01-410-62-00.5422 RAYMOND DETENTION BAS $ $ $ $ $ $ $ $ $ 01-410-62-00-5423 RAYMOND STORM SEWER O $ $ $ $ $ $ $ $ $ 03-410-62-00-5424 RAYMOND STORM SW.TBR $ $ $ $ $ $ $ $ $ 01-410-62-00-5434 RENTAL-EQUIPMENT $ $ $ 176.00 $ $ $ $ $ 176.00 $ 1,000.00 01-410-62-00-5435 ELECTRICITY $ $ 1,967.83 $ 6,323.23 $ 6,638.22 $ 6,503.63 $ 8,003.51 $ 7,835.31 $ 5,159.18 $ 42,430.91 $ 75,000.00 01-410-62-00-5438 CELLULAR TELEPHONE $ $ 145.40 $ 160.85 $ 152.96 $ 167.90 $ 200.91 $ 205.70 $ 172.57 $ 1,206.29 $ 4,020.00 01.410-62-00-5440 STREET LIGHTING $ $ $ $ $ $ $ $ $ 01-410-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ $ $ 2,000.00 01-410.65.00-5804 OPERATING SUPPLIES $ 150.00 $ 139.78 $ 1,068.99 $ $ 371.89 $ 37.29 $ 176.08 $ 515.23 $ 2,459.26 $ 10,000.00 01-410-65-00-5810 ELECTRICAL MAI NT SUPP $ $ $ $ $ $ $ $ $ 01-410-65-00-5812 GASOLINE $ $ 399.90 $ 3,077.06 $ 2,722.01 $ 2,885.28 $ 1,120.80 $ 1,893.88 $ 1,969.36 $ 14,068.29 $ 32,000.00 01-410-65-00-5815 HAND TOOLS $ $ $ $ $ $ 18.93 $ $ 18.93 $ 1,000.00 01-410-65-00-5817 GRAVEL $ $ $ 426.65 $ $ $ $ $ 426.65 $ 1,500.00 01-410-72-00-65001MRF PARTICIPANTS $ 2,138.64 $ 2,144.84 $ 2,130.59 $ 3,182.00 $ 1,054.55 $ 3,165.57 $ 2,143.01 $ 2,270.24 $ 18,229.44 $ 26,333.00 01-410-72-00-6501 SOCIAL SECURITY&MED $ 1,743.67 $ 1,750.95 $ 1,739.00 $ 2,596.91 $ 860.48 $ 2,600.97 $ 1,749.94 $ 1,852.93 $ 14,894.85 $ 20,768.00 01.410-75-00-4404 HANGING BASKETS $ $ 1,832.00 $ 204.00 $ 11.98 $ $ $ $ 2,047.98 $ 2,000.00 01-410-75-00-5418 MOSQUITO CONTROL $ $ $ $ $ $ 6,500.00 $ $ 6,500.00 $ 15,000.00 01-410-75-00-7004 SAFETY EQUIPMENT $ $ 245.75 $ $ $ $ $ $ 270.26 $ 516.01 $ 500.00 01-410.75-00-7101 IN TOWN ROAD PROGRAM $ $ $ $ $ $ $ $ - $ 40,232.00 01-410.75-00-7102 TREE&STUMP REMOVAL $ $ $ $ 150.00 $ 4,800.00 $ $ $ 4,950.00 $ 10,000.00 01-410-75-00-7103 SIDEWALK CONSTRUCTION $ 246.00 $ $ $ $ 240.00 $ - $ 739.04 $ 1,225.04 $ 4,000.00 01-410-75-00-7104 SSA EXPENSE-FOX HILL $ $ $ $ $ $ $ $ $ 01-410-78-00-9005 MERIT/COLA $ $ $ $ $ $ $ $ $ - 01-410-78-00-9010 PARKWAY TREE PROGRAM $ $ (145.00) $ (108.00) $ (1,287.00) $ (1,394.00) $ 1,768.95 $ 432.88 $ (732.17) $ - 01-410-99.00-9930 TRANSFER TO WATER IMP $ $ $ $ $ $ $ $ - $ TOTAL STREETS EXPENSES $ 28,473.73 $ 16,861.16 $ 48,371.55 $ 47,930.12 $ 31,749.85 $ 70,353.15 $ 51,928.53 $ 44,201.91 $ $ $ $ $ 339,870.00 $ 616,725.00 GENERAL FUND-HEALTH&SANITATION EXPENSES 01-540-62-00-5442 GARBAGE SERVICES $ $ 98,777.71 $ 98,735.97 $ 99,049.02 $ 98,777.71 $ 96,631.62 $ 98,235.09 $ 98,026,39 $ 690,233.51 $ 1,140,000.00 01-540-62-00-5443 LEAF PICKUP $ $ 600.00 $ $ $ $ $ $ 600.00 $ 6,000.00 TOTAL HEALTH&SANITATION EXPENSESE$ $ 99,377.71 $ 98,735.97 $ 99,049.02 $ 98,777.71 $ 98,631.62 $ 98,235.09 $ 98,026.39 $ $ $ $ $ 690,833.51 $ 1,146,000.00 TOT1tLFUNDR $ 378.!24.$4 3 7$'3;670.06 '932&.911 %.w kW* $ 664,676.22 # 800,2 $ 796,980.69 $ $ 3 S E,2i7,1$Z23 $ 11,453,024.00 TOTAL FUND EXNNS S W,91324 MA28.95 $ 1,188,665.20 1$ 905.75,2.63 S 806,979.66.1$ 1,161,907,48 S 781.646.30 1$ 878,620.35 I S $ S $ $ 727!9,413.81 $ 11,376,981.00 RWSURPLUS PER $ 2488.70 1575 $ 28,930.36 $.JA19AM4 ,277 S � ,639.66 $ - S S - -- $ 94777®A2 $ 56,049,00 FOX HILL SSA REVENUES 11-000-40.00-3999 CARRY OVER BALANCE $ $ $ $ $ - $ $ $ - $ 2,345.00 11-000-40-00-4002 FOX HILL LEVY $ $ 9,414.19 $ 441.86 $ 1,881.23 $ 7,271.40 1$ 388.47 $ 496.96 $ 19,894.11 1$ 19,463.00 FOX HILL SSA EXPENSES _ 1-OOO G5 00.581€MAINTENANCE COMMON G 5 - $ 430.00 $ 909,&d $ 967.50 $ l5C1 1 S 568.65 $ 454 9a $ 3,785.83 $ 3, 55.04 TOTAL FUND REVENUES $. $ 9,414.19 $ 441.86 $ 1,881.23 S 7,271.40 $ 386,47 $ 496.96 _ S 19,694.11 $ 21.808.00 TOTAL FU No EX PENSES $ $ 430.00 $ 909.84.. S %730 S 454.92 1 S 5611,65 1$ 4S4.92 I 3,785.83 $ 3,458A0. FUND SURPLUS(DtFFCFqj$ $ B.984.19 $ L467.93)1-$ 913.73 1 S &;816.48 $ 1180-n S 4104 $ 16,108.28 $ 18,350:08' SUNFLOWER SSA REVENUES 12-000-40-00-3999 CARRY OVER BALANCE $ $ $ $ $ $ $ $ - $ 5,958.00 12-000.40-00-40025UNFLOWER LEW $ $ 6,652.73 $ 341.13 $ 963.56 $ 5,676.61 $ 57.34 $ 179.13 $ 13,870.50 $ 13,112.00 SUNFLOWER SSA EXPENSES 12-000-65-00-5416 MAINTENANCE COMMON G $ $ 2,204.80 $ 1,649.00 1$ 1,812.57 $ 1,219.00 $ 537.50 $ 107.50 $ 7,530.37 MS8,253.00 T irAa tvN1s nEVENUE S s aSz 94 17.34 L79 2 _ 3 15 870.50 0.00 TOTAL W ND 674PENSES $ - 3 204 110 1.64900 $ 812 87 $ 5215.00 77 .00FUNTJSU WJS FIEPIt $ 4A47,93 $ 1.307A7 $ 849:41. S 4AS7.61 $ 480. $ 7L63 $ §340.35 A11 MOTOR FUEL TAX REVENUES 15-000-40-00-3999 CARRY OVER BALA]LOT $ $ $ $ $ $ $ $ - $ 133,782.00 15-000-40-00-4060 MOTOR FUELTAX $ 36,524.19 $ 35,337.89 $ 33,399.04 $ 36,201.75 $ 35,211.55 $ 40,536.39 $ 29,696.11 $ 37,878.11 $ 284,785.03 $ 355,000.00 15-000-40-00-4065 MFT HIGH GROW n/a n/a n/a n/a $ $ 24,674.00 $ $ 24,674.00 $ - 15-000-44-00-4401 GAME FARM ROA $ $ $ $ 6,978.01 $ $ $ $ 6,978.01 $ - 15-000-44-00-4402 FOX ROAD $ $ $ $ $ $ 4,602.26 $ $ 4,602.26 $ - 15-000-44-00-4403 DOWNTOWN PAR n/a n/a n/a n/a $ $ 55,000.00 $ $ 55,000.00 $15-000.44-00-4490 MISC.INCOME $ $ $ $ $ $ $ 73,122.00 $ 73,122.00 $ - 15.000-46-00-4600 INVESTMENT INCO $ 38.80 $ 52.60 $ S9.29 $ 70.38 $ 75.17 $ 99.34 $ 93.03 $ 90.36 $ 578.97 $ 1,000.00 MOTOR FUEL TAX EXPENSES 6.1`18 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/1-14-11 AlIf7All(Pr:NS2S0YM ACCOUNTNUMBERANODE$G McON May-10 Junr-14 jetty-10 AugusaiR September-i0 October-10 November-10 December-W lanuary-11 fabruaq-11 Marsh-11 Apr[I.11 YEAR-70-DATE ANNUAL- TOTALS BUDGET -_. 15-000-65-00-5800 CONTINGENCY $ $ $ $ $ $ $ $ $ 15-000.65-00-5804 OPERATING SUPPLIES $ $ $ $ $ $ $ $ $ 15-000-65-00-5818 SALT $ $ $ $ $ $ $ $ 33,082.50 $ 33,082.50 $ 204,000.00 15-000-65-00-5825 GEO MELT $ $ $ $ $ $ $ $ $ - 15-000-75-00-7007 SIGNS $ $ $ 67.10 $ $ $ 41.95 $ (85.50) $ 23.55 $ 18,000.00 15-000-75-00.7008 CRACK FILLING $ $ $ $ $ $ $ $ $ 15-000-75-00-7009 PATCHING $ $ $ $ $ $ $ $ 49,857.33 $ 49,857.33 $ 50,000.00 15-000-75-00-7106 GAME FARM SURVEYING $ $ $ $ 6,456.02 $ - $ $ $ 6,456.02 $ 15-000-75-00-7107 CONSTRUCTION ENGINEER $ - $ $ $ $ $ $ $ $ 15-000-75-00-7108 GAME FARM HOUSE DEMO $ $ $ $ $ $ $ $ - $ 20,000.00 15-000.75-00-7110 COLD PATCH $ $ 1,488.11 $ $ $ m $ $ $ 1,488.11 $ 10,600.00 15.000-75-00-7111 HOT PATCH $ $ $ $ $ $ 6,168.64 $ $ 1,489.51 $ 7,658.15 $ 13,000.00 15-000-75-00-7112 VAN EMMON $ $ $ $ $ $ $ $ $ 15-000-75-00-7113 COUNTRYSIDE PKWY CONS $ $ $ $ $ $ $ $ $ 15-000-75-00-7114 ROUTE 126/71 TRAFFIC $ $ $ $ $ $ - $ $ $ 15-000-75.00-7115 PALMER COURT $ $ $ $ $ $ $ - $ $ 15-000-75-00-7116 WOOD DALE $ $ $ - $ $ $ $ $ $ 15-000-75-00-7117 FAXON ROAD ROW ACQ $ $ $ $ $ $ $ $ $ 15-000-75-00-7118 RT 34&SYCAMORE TRAF $ $ $ $ $ $ $ $ $ 30,000.00 15-000.75-00-7119 GAME FARM ROW $ $ $ $ 20,000.00 $ $ $ $ 20,000.00 $ 130,000.00 15-000.75-00-7120 FOX ROAD $ $ $ $ 582.60 $ $ 20,293.22 $ $ 20,875.82 $ - 15-000-75-00-7121 FAXON RD EXTENSION $ $ $ $ - $ $ - $ $ $ 15-000-75-00-7122 FOX RD OVERLAY $ $ $ $ $ $ $ $ $ 15.000-75-00-7123 GUARDRAIL REPAIRS $ $ $ $ $ $ 23,127.67 $ - $ 23,127.67 $ - 15-000-75-00-7124 IL 47 @ US 30 SIGNALS $ $ $ $ _ $ _ $ _ $ $ _ " _ $ TOTAL FUND RBV IUES' $ 36562 99 !$ 85,890x4 $ 33 458 # 48 54 35,286.72 $ 52491199 # 502,953 34 $ _ 87.868 47 $ 9 $ � $ $ _449,748.27 $ _489,782,00 - TOfALFUNDE7fpENSE6� ,$ 148811 $ 6750 27,03862 $ # 496334$ $ 8550 $ 8442934 $ - - $-- -- - $ - _' $ 261,569.15 '_$__ 475,600:00 - - FUND SURPLUS DER- # $6,56#99 $ 3B.9DZ a6 # 43 s3T 2a 56,?2s SZ.$ 3s 286.72 # 7s,28osf 3_SDx s98:6a x6.460 97 3 S $ $ --- $ ze7,17112 $ 14,182,00 MUNICIPAL BUILDING REVENUES 16.000-40-00-3999 CARRY OVER BALANCE $ $ $ m $ $ $ $ $ $ (607,474.00) 16-000-42-00-4211 DEVELOPMENT FEES-BOIL $ 1,350.00 $ 15,900.00 $ 150.00 $ 450.00 $ 750.00 $ 1,350.00 $ $ 19,950.00 $ 55,000.00 16-000-42.00-4215 BEECHER RENTAL FEE $ $ $ $ $ $ $ $ $ 16-000-44-00-4400 BEECHER CENTER DONATI $ $ $ $ $ $ $ $ $ 16.000-49-00-4901 TRANSFER FROM GENERAL $ $ $ $ $ $ $ $ $ 16-000-49-00-4902 TRANSFER FROM LAND AC $ $ $ $ $ $ $ $ $ MUNICIPAL BUILDING EXPENSES 16-000-62-00-5416 MAINT-GENERAL J! l$ $ $ $ $ $ $ 1$ $ $ 16-000-75-00-7008 ENTRY WAY SIGN $ $ $ $ $ $ $ $ 16-000-75-00-7200 BLDG IMPROV-BE / $ $ $ $ $ $ $ $ 16.000-75-00-7203 BLDG IMPROVEMUB $ $ $ $ $ $ $ $ 16-000-75-00-7204 BLDG MAINT-CIT $ $ $ $ $ $ $ $ 16-000-7S-00-7206 LANDSCAPING-PUU $ $ $ $ $ $ $ $ 16-000-75-00.7210 BLDG MAINT-POSI $ $ $ $ $ $ $ $ 16-000-75-00.7211 NEW BUILDINGS $ $ $ $ $ $ $ $ 16.000-78-00-9009 RESERVE $ $ $ $ $ $ $ - $ 16-000-99-00-9901 TRANSFER TO GENERAL $ $ $ $ - $ $ $ - $ 16-000-99-00-9965 TRANSFER TO DEBV $ $ $ _ $ $ _ $ $ _ $ AL FlfNd US9 # 1 DO $S,8tl0. 1QD 00 $ $ 750. # SD•(W $ $ $ $ $ $ 552,474,00 TOTALFUNDN$ES $ $ $ $ $ # S $ S $FUND SURPLUI $ 135000 $ Si 800,00 $- 550,00 $ 450.00 750,00 $ 1,350,00 $ $ $ $ $ $ 552 474.00 POLICE CAPITAL REVENUES 20-00040-00-3999 CARRY OVER-WEATHER W $ $ $ $ $ $ $ $ - $ 36,617.00 20.000.42-00-4212 DEV FEES-POLICE $ 2,550.00 $ 1,050.00 $ 600.00 $ 750.00 $ 1,350.00 $ 2,400.00 $ - $ 5,809.00 $ 14,509.00 $ 25,000.00 20-000-44.00-4402 K-9 DONATIONS $ $ $ $ $ $ $ $ - $ 20-000-44-00-4403 IN CAR VIDEO DONATION $ 500.00 $ 265.80 $ 140.40 $ 188.20 $ 707.40 $ 223.20 $ 432.40 $ 652.17 $ 3,109.57 $ - 20-000-44-00-4404 DONATIONS $ $ $ $ $ $ $ $ $ 20-000-44-00-4405 WEATHER WARNING SIREN $ $ $ $ $ 103.50 $ 18.75 $ - $ 122.25 $ - 20-000-44-00-4406 WEAHER WARNING SIREN $ $ $ $ $ $ - $ - $ $ 6,000.00 20-000-44-00-4431 SALE OF POLICE SQUADS $ 1,000.00 $ 2,500.00 $ $ $ $ $ $ 3,500.00 $ 1,000.00 20-000-44-00-4440 SEIZED VEHICLES $ $ $ 1,000.00 $ 1,000.00 $ 150.00 $ $ 752.50 $ 2,902.50 $ 5,000.00 20-000-49-00-4901 TRANSFER FROM GENERAL $ $ $ $ $ $ $ $ - $ 25,000.00 POLICE CAPITAL EXPENSES 20-000-65-00-5811 LETHAL/NON-LETHAL WEA $ $ $ $ $ $ - $ - $ $ 20-000-65-00-5840SEIZED VEHICLES $ $ 95.00 $ 95.00 $ 380.00 $ 325.00 $ 95.00 $ 60.00 $ 486.01 $ 1,536.01 $ 1,500.00 20-000-75-00-7001 EQUIPMENT $ $ $ $ $ $ $ - $ - $ 40,000.00 7oF18 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/1-14-11 ACtUALEXPENSESSYMONTH - -- - - - - - - - i YEAR-TO-DATE'' ANNfJAt ACCOUNTNUMSERAND01=11PTION May-10 June-16 July-1i} August-30 September-10 October-10 Navembar-l0 De€ember-10 January-11 February-Il March 11 April-11 BUDGET__20-000-75-00.7002 K-9 EQUIPMENT $ $ $ $ $ $ $ $ 2,500.00 20-ODO-75.00-7005 VEHICLES $ $ $ $ 42,310.00 $ $ $ - .00 $ 40,000.00 20-000-75-00-7006 CAR BUILD OUT $ - $ $ $ $ 740.00 $ 4,689.05 $ .05 $ 20,000.00 20-000-75-00-7008 NEW WEATHER WARNING S $ $ $ $ $ $ $ $ 20-000-75-00-7009 RESERVE-WEATHER WARM $ $ $ $ $ $ $ $ - 20-000-75-00-7010 NEW WORLD SOFTWARE $ $ $ $ $ $ $20-000.75-00-7011 ARCHITECT FEES $ $ $ $ $ $ $20-000-78-00-9009 RESERVF $ -TOTALFUNDR£VENUES $ 4,050.00 $ 3;61580 1,74840 S 1,938.20 $ 2,310.90 $ 2,6'41:95 $ 2,1&190 5 6.461.17 $ - 5 S S 32 TOTAL FUND EXPENSES $ $ 95.00 $ 95.00 $ 42,690-OB $ 1106S.DD $ 4.784.05 $ 50.00 $ 486:01. $ $ S $ .06 FUND SURPLUS(O'1FiCTTI $ 4AS0.00 $ 3,720.80 $ 1.645,40 S (40.751.80) 5 1„245.94 , $ I,124.90 $ 5.975.16 S S - S $ - .74] $ 5.383.00 PUBLIC WORKS CAPITAL REVENUES 21-000-40-00-3999 BEGINNING FUND BALANC $ $ $ - $ $ $ $ $ - $ 140,395.00 21.000.42-00-4213 DEVELOPMENT FEES-PURL $ 6,050.00 $ 2,550.00 $ 1,400.00 $ 1,850.00 $ 3,250.00 $ 5,800.00 $ $ 700.00 $ 21,600.00 $ 35,000.00 21-00042-00-4288 MOWING INCOME $ 2,041.25 $ 2,041.25 21-000-44-00-4430 SALE OF EQUIPMENT $ $ $ $ $ $ $ $ $ - 21-000.49.00-4915 TRANSFER FROM WATER F $ $ $ $ $ $ $ $ - $ - 21-000-49-00-4920 TRANSFER FROM SEWER F $ $ $ $ $ $ $ $ - $ - PUBLIC WORKS CAPITAL EXPENSES 21-000-75-00-7001 EQUIPMENT $ $ $ (92.66) $ (492.12) $ (254.12) $ (214.11) $ (509.69) $ (1,562.70) $ - 21-000-75-00-7005 VEHICLES $ $ $ $ $ $ $ $ $ 46,000.00 21-000.75-00-7015 SKIDSTEER UPGRADE $ $ $ $ $ $ - $ $ - $ 4,000.00 21-000-75-00.7107 TRUCK ACCESSORIES $ $ $ $ $ $ $ $ - $ 5,000.00 21-000.75-00-7110 PW BUILDING PAYMENT $ 13,715.84 $ 6,857.92 $ 6,857.92 $ 6,857.92 $ 6,857.92 $ 6,857.92 $ 6,857.92 $ 6,857.92 $ 61,721.28 $ 84,000.00 21-000-75-00.7120 STREET SWEEPER $ $ $ $ $ $ $ $ - $ 21-000.75-00-7130 FACILITY EXPANSION $ $ $ $ $ $ $ - $ - $ - 21-000-78-00-9009 RESERVE $ $ $ $ $ $ - $ 21-000-99-00-9941 TRANSFER TO PARKS CAP $ - $ - $ $ - $ - $ - $ - $ - $ TOTATFUNDR puES 60500$ t 3,53800 1,40000 s&§�68 $ s as 3 ssaruo S $ 274L25 $= - f $ 23MTZS $- _:1S,395.00_ TOTAL FUND EXPENSES $ 13 715.84 $ 6,857.32 $ 6 785 26 $ 8365.80 6603 80 $ 6,643.81 $_ 8,94823 6857.92 $ $ S $ aa,lss 6 $ 139,M-00 RINOSURpLUS_ EF1 $ 92 $ .36518 $ 1680 843.81 $ 6 - $ 4,116.+97 $ - $-- $ S 36.517.38 S 36,395.00 PARK&RECREATION CAPITAL REVENUES 22-000-40-00-3999 BEGINNING FUND BALANC $ $ $ $ $ $ - $ $ $ 193,460.00 22-000-42-00-4216 PARKS CAPITAL FEE $ 350.00 $ $ $ $ 650.00 $ - $ 650.00 $ 1,650.00 $ 2,500.00 22-000-42-00-4217 PARK CAPITAL DONATION $ $ S S $ $ - $ $ - $ - 22-000.42-00-4218 BASEBALL FIELD CONSTR $ $ $ $ - $ $ - $ $ - $ 15,000.00 22-000.44-00-4430 SALE OF VEHICLES/EQUI $ $ $ $ S $ $ - $ - $ 22-000-46-00-4600 INVESTMENT INCOME $ 6.72 $ 6.52 $ 6.95 $ 6.94 $ 6.51 $ 6.72 $ 6.51 $ 6.72 $ 53.59 $ 22-000-49-00-4930 TRANSFER FROM GF $ $ $ $ $ $ $ - $ - $ - 22-000-49-00-4950 TRANSFER FROM PW CAPI $ $ $ $ $ $ - $ - $ $ - PARK&RECREATION CAPITAL EXPENSES 22-610-75-00-7006 PICK UP TRUCK $ $ $ $ $ $ - $ - $ $ - 22-610-75-00-7010 RAINTREE PARK $ $ 275.16 $ 1,500.00 $ $ $ - $ - $ 1,775.16 $ 158,135.00 22-610-7S-00-7011 BASEBALL FIELD CONSTR PEN Es $ $ $ $ $ $ 3,907.12 $ 4,950.00 $ 6,206.55 $ 15,063.67 $ 15,000.00 sm 22-610-75-00-7015 EQUIPMENT $ $ $ $ $ $ - $ - $ $ 22-610-75-00-7016 COMPUTER SERVER $ $ $ $ $ - $ $ - $ - $ 22-610-75-00.7018 PARK RE-DEVELOPMENTS $ $ $ - $ - $ $ - $ - _ - - _ $ TOFA1g1NDE1T5 $ - _I$ 27$16 150600 $ 8.34 # 65651 $ 3807.73 $ 4.95000 $ 6206.55 S $ $- $ $_ 16'83883 S 210960.00 173,135,00 FUNDSOFIPLWS - $ 3S6,72 $ 268.64 $ 1,493,8 $ _ 694 $ ._ 656.81 $ 9,900.40 $ 4.29949 $ 8,199.83 $ $ $ 15195.24 $ 37,825.00 CITY WIDE CAPITAL REVENUES 23-000-40-00-3996 ROAD CONTRIBUTION $ 12,000.00 $ $ 2,000.00 $ $ $ 2,000.00 $ - $ 16,000.00 $ 24,000.00 23-000-40.00-3999 CARRY OVER BALANCE $ $ $ $ $ $ $ - $ - $ (93,178.00) 23-000-41-00-4115 KENNEDY ROAD $ $ $ $ $ $ - $ $ - $ 23-000-42-00-4211 ENGINEERING CAPITAL $ 800.00 $ 300.00 $ 200.00 $ 200.00 $ 400.00 $ 700.00 $ $ 2,600.00 $ 4,000.00 23-000-44.00-4400 REIMS.OLD JAIL n/a n/a n/a n/a n/a $ $ - $ $ 23.000-45-004500 DOWNTOWN BRWN GRANT $ $ $ $ $ $ - $ - $ - $ 23-000-45-00-4501 SAFE RT TO SCHOOL(DE $ $ $ $ - $ - $ - $ - $ - $ 46,200.00 23-000-45-00-4502 SAFE RT TO SCHOOL(CO $ $ $ $ $ - $ - $ - $ - $ 184,800.00 23-000-45-00-4600 INVESTMENT INCOME n/a I n/a n/a n/a 1$ 2.75 1$ 2.37 $ 2.29 $ 2.37 $ 9.78 $ - 23-000-49.00.4901 TRANSFER FROM GENERAL $ $ $ 40,625.00 $ $ $ 40,625.00 $ - $ 81,250.00 $ 162,500.00 CITY WIDE CAPITAL EXPENSES 23-000-75-00-7005 VEHICLES 1$ Is 1$ $ $ $ - $ - $ - $ 4,000.00 23-000-75-00-7006 ROAD CONTRIBUTION RES $ $ 1$ $ 1$ $ - $ - $ $ 24,000.00 8 of 18 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/1-14-11 - - AMAL OMINM BY MONTH - ACCOUNTNWM6ERANpOESCRIPTION may-10 June-10 July 10 August-l0 Septe Der-IO Octaber-10 Now imbor-10 December-10 January-11 February-11 Mar h-ii Apra€-11 ART6DA7E ANNUAL TOTAi.S BUDGET 23-000.75-00.7099 PERIMETER RD STUDY $ $ $ $ $ N$ - $ $ $ 23-000-75.00-7101 RON CLARK PROPERTY $ 125,000.00 $ $ $ $ $ $ 125,000.00 $ 125,000.00 23-000-75-00-7102 MCHUGH ROAD $ $ $ $ $ $ $ - $ - 23-000-75-00-7103 SIDEWALK REPLACEMENT $ $ $ $ $ 5,934.11 $ 4,111.30 $ 439.06 $ 10,484.47 $ 37,500.00 23-000-75-00-7104 ROB ROY FALLS SIGNAL $ $ $ $ $ $ $ - $ 23-000-75.00-7105 BEECHER RD STUDY $ $ $ $ $ $ $ - $ - 23-000-75-00-7106 DOWNTOWN BROWNFIELD $ $ $ $ $ $ $ - $ - 23-000.75-00-7107 COMED BIKE TRAIL $ $ $ $ $ $ $ - $ 23-000-75-00-7108 RAYMOND BASIN $ $ $ $ $ $ $ $ $ 23-000-75-00-7109 KENNEDY ROAD $ $ $ $ $ $ $ $ - $ 23-000-75-00-7110 ASPHAULT PAVEMENT THE $ $ $ $ $ $ $ $ $ - 23-000-75-00-7111 PARKWAY TREE PLANTING $ $ $ $ $ $ $ $ $ 25,000.00 23-000-75-00-7112 SIDEWALK REPLACEMENT $ $ $ - $ $ $ $ $ $ 50,000.00 23-000-75-00-7113 SAFE ROUTES TO SCHOOL $ $ $ - $ $ $ $ $ - $ 46,200.00 23-000-75-00-7114 SAFE RTS TO SCHOOL(C $ $ $ $ $ $ - $ $ $ 184,800.00 23-000-75-00-7115 PALMER COURT $ $ $ $ - $ $ $ $ - $ - 23-000-75.00-7116 TOWN SQUARE PARK $ - $ $ $ $ $ $ $ - $ 25,000.00 23-000-75.00-7117 FAXON ROAD ROW $ $ - $ $ $ $ $ $ - $ 85,000.00 23-000-75-00-7118 CENTEX LOAN $ $ $ $ $ $ $ - $ $ 23-000-7S-00-7119 OLD JAIL n/a n/a n/a $ 161,569.00 n/a $ (96,000.00) $ $ 51.00 $ 65,620.00 $ - 23-000-75-00-7130 PW BUILDING $ $ $ $ $ $ $ __ $ - $ TOM FUND REVENUES 12 00 $ - 300.00 42,825.00 $ 200.00 - - 402 7S $ +13 327,37 $ 2.29 2.97 $ $ $ - $ 99 559.75 $ -326,322.00 TOTAL FUND EXPENSES $ i2SA0D.00 $ - - $ 161589.00 $_ 5,934.11 3 96A00.00 4AUJO $ 49405 - $ $ --- $ __ 201104,47','$- 606500.00 FUND SURPLUS DEF[Clr} {172,200.04 $ 300.06 $ 42,52504 ${181,969,00p'$ {5.591.9 784327.97 4]0941)1 $ (48T.b9� $ $ $ $ 01,24484) $ (275,178.00) DEBT SERVICE REVENUES 42-000.40-00-3999 CARRY OVER BALANCE $ $ $ $ $ $ $ $ $ 6,853.00 42-000-44-00.4440 RECAPTURE-WATER/SEWER $ 225.00 $ 125.00 $ 75.00 $ 75.00 $ 125.00 $ 225.00 $ 25.00 $ 25.00 $ 900.00 $ - 42-000.44-00-4441 LIBRARY BOND REFEREND $ $ $ $ $ $ $ $ - $ - 42-000.49.00.4901 TRANSFER FROM GENERAL $ $ $ 107,351.00 $ $ $ 107,351.00 $ $ 214,702.00 $ 429,404.00 42-000-49-00-4925 TRANSFER FROM SAN ITAR $ $ $ $ $ $ $ - $ $ - 42-000-49-00-4930 TRANSFER FROM WATER $ $ $ $ $ $ - $ - $ - $ - 42-000-49-00-4940 TRANSFER FROM MUNICIP $ $ $ $ $ $ $ - $ - $ DEBT SERVICE EXPENSES 42-000-66-00-6001 CITY HALL BONDS PRINC $ $ $ $ $ $ $ - $ - $ 42-000-66-00-6002 CITY HALL BONDS INTER $ $ $ $ $ $ - $ - $ $ - 42-000-66-00-60031RBB-BRUELL ST.INTER $ $ - $ $ $ - $ $ - $ - $ - 42-000-66-00-60041RBB-BRUELLST.PRINC $ $ $ $ $ $ - $ $ $ 42-000-66-00-6005 NORTH H2O TOWER INTER $ $ $ $ $ $ - $ - $ $ 42.000-66-00-6006 NORTH H2O TOWER PRINC $ $ $ $ $ $ $ $ - $ 42-000-66-00-6007$4.8M DEBT CERT INTER $ $ $ $ $ - $ $ $ - $ - 42-000.66-00-6008 COUNTRYSIDE ALT REV P $ $ $ - $ $ $ - $ - $ $ - 42-000-66-00-6009 COUNTRYSIDE ALT REV 1 $ $ $ $ $ $ - $ - $ 42-000-66-00-6010 COMED/HYDRAULIC INTER $ $ $ $ $ - $ $ $ - $ - 42-000-66-00-6011 COMED/HYDRAULIC PRINC $ $ $ $ $ $ - $ - $ - $ - 42-000-66-00-6013 LIBRARY BOND 2005B IN $ $ $ $ $ $ $ - $ - $ - 42-000-66-00-6015 LIBRARY BOND 20061NT $ $ $ $ $ $ $ - $ - $ - 42-000-66-00.6016 ROB ROY CREEK BOND $ $ $ $ $ $ - $ - $ - $ 42-000-66-00-6D411EPA DRINK WTR PROJL $ $ $ $ $ $ - $ $ $ - 42-000-66-00-6042]EPA DRINK WTR PRJ Ll $ $ $ $ $ $ - $ - $ - $ 42-000-66-00.6045 SSES]EPA PRINCIPAL P $ $ $ $ $ $ - $ - $ - $ - 42-000-66-00-6049 SANITARY SIPHON INTER $ $ $ $ $ $ - $ $ - $ 42-000-66-00-6050 SANITARY SIPHON PRINC $ $ $ $ $ $ - $ - $ - $ - 42-000-66-00-6055 SSES[EPA L171153 PRI $ $ $ $ $ $ - $ - $ - $ - 42-000.66.00-6056 REFUNDING 20061NTERE $ $ $ $ $ $ - $ - $ $ - 42-000-66-00-6057 REFUNDING 2006A PRINC $ $ $ $ $ $ - $ $ - $ - 42-000-66-00-6058$2.8M NORTH WATER TOW $ $ $ $ $ - $ - $ $ - $ 42-000.66.00-6059 2007A GO REFUND 02,0 $ $ $ $ $ $ - $ - $ - $ 42-000-66-00-6070$650K ROAD IMPROV PRO $ - $ $ $ - $ - $ - $ - $ - $ 42-000-66-00-6071$650K ROAD IMPROV PRO $ 6,412.50 $ $ $ $ $ - $ - $ 202,825.00 $ 209,237.50 1$ 107,825.00 42-000-66-00-6072$2M ALT REV B2&B3 IN $ $ $ $ $ $ - $ - $ - $ - 42-000-66-00-6073$2M ALT REV B2&B3 P $ $ $ $ - $ - $ - $ - $ $ 42-000.66-00-6074$3.825M IN TOWN ROAD " $ 0142L f- $ - $ $ - $ - $ - $ - $ 42-000-66-00-6075$3.825M IN TOWN ROAD 68,289.38 $ $ $ - $ - $ - $ 506,578.76 $ 574,868.14 $ 321,579.00 - `O ALIUNIfi 61r ' to4 TS.(14 USAW 107','57$. 3 7,5.00 $ t50a $ $ - $ $ 215,642.40 $ 496,257.00 TOTAL FUNDVMNSE 88.283,35 - $ 5 $ _ $ 709463.76 $ - $ $ $ $ 184,105.64 $ 429+104.00 WNp SURPLUS 0 $ 6,187.50 $ $ 107,426.00 $ 75.00 $ 175 00 $ 107 76A0 $ 2500 $ (709,37&76 $ - $ $ $ $ 56850964 $ 6059:00 9ofl8 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/1-14-11 ACTUAL,6XfEN565 81f MDNM -ay- _. - ly- _ - -- -_._. .-- -_ ..January-11 February•Ll March-11 i' APr11d1 YEAR-TO-DATE ANNUAL ACCOUNTNUMEERANDDESCRTPTION M 10 !urge-T0 Ju 10 August-lp Sepesm6er-PO [ktob4r-10 Nouem6er•Ip Decemher•1p TOTALS BUDGET WATER OPERATIONS REVENUES 51-000-40-00-3999 BEGINNING FUND BALANC $ $ $ $ $ $ $ $ $ - 51-000-42-00-4240 BULK WATER SALES $ 110.00 $ (98.00) $ $ (149.00) $ (152.00) $ 889.27 $ (392.00) $ (392.00) $ (183.73) $ 2,000.00 51.000-42-00-4241 WATER SALES $ 425.91 $ 294,897.03 $ 4,106.77 $ 323,533.53 $ 4,577.97 $ 297,621.46 $ 5,298.07 $ 257,681.40 $ 1,188,142.14 $ 1,286,250.00 51-000-42-00-4242 WATER METER SALES $ 4,270.00 $ 3,540.00 $ 2,665.00 $ 1,795.00 $ 2,330.00 $ 4,080.00 $ 390.00 $ 440.00 $ 19,510.00 $ 32,000.00 51-000.42-00-4243 LEASE REVENUE-H2O T $ 2,149.29 $ 2,149.29 $ 2,149.29 $ 5,408.29 $ 2,459.79 $ 2,149.29 $ 2,770.29 $ 2,149.29 $ 21,384.82 $ 29,000.00 51-000-44-00-4417 REIMBURSEMENTS $ 4,318.88 $ 4,318.88 51-000.44-00-4490 MISCELLANEOUS INCOME $ $ $ $ $ $ $ $ - $ 51-000.44-00-4498 RECAPTURE $ $ $ $ $ $ $ $ - $ 51-000-44-00-4499 BAD DEBT RECOVERY $ $ 1,490.17 $ 247.19 $ 92.82 $ 364.36 $ $ 672.28 $ 2,866.82 $ 51-000-46-00-4600 INVESTMENT INCOME $ 45.40 $ 133.06 $ 331.98 $ 192.15 $ 170.96 $ 318.84 $ 86.56 $ 78.78 $ 1,357.73 $ 1,800.00 WATER OPERATIONS EXPENSES 51-000-50-00-5107 SALARIES-WATER OP. $ 26,646.97 $ 24,750.16 $ 25,220.05 $ 38,960.76 $ 11,768.10 $ 39,852.76 $ 26,558.63 $ 32,947.37 $ 226,704.80 $ 358,702.00 51-000.50-00.5136 SALARIES-PART TIME $ $ $ $ $ $ $ $ - $ 51-000.50.00-5137 SALARIES-OVERTIME $ 173.44 $ 45.31 $ 317.49 $ 40.82 $ 60.41 $ 1,139.24 $ 644.67 $ 504.07 $ 2,925.45 $ 15,000.00 51-000-61-00-5300 LEGAL SERVICES $ $ $ $ $ $ $ $ - $ - 51-000-61-00-5303 JULIE SERVICE $ $ $ 840.25 $ $ 632.00 $ 347.50 $ 311.00 $ 223.72 $ 2,354.47 $ 6,000.00 51-000-62-00-5401 CONTRACTUAL SERVICES $ 80.15 $ 479.01 $ 4,292.11 $ 117.30 $ 508.19 $ 90.50 $ 242.83 $ 204.68 $ 6,014.77 $ 6,000.00 51-000.62-00-5407 TREATMENT FACILITIES $ 2,570.83 $ 12,613.09 $ 23,621.71 $ 16,914.14 $ 27,066.32 $ 14,188.52 $ 25,126.35 $ 23,375.95 $ 145,476.91 $ 230,000.00 51-000-62-00-5408 MAINTENANCE-EQUIPMENT $ $ $ 21.09 $ 196.02 $ $ $ $ 322.17 $ 539.28 $ 8,000.00 51-000-62-00-5409 MAINTENANCE-VEHICLES $ $ 20.00 $ $ 17.58 $ 317.30 $ 27.41 $ 984.86 $ 1,946.07 $ 3,313.22 $ 9,000.00 51-000-62-00-5411 MAINTENANCE-COMPUTERS $ $ $ $ $ $ $ $ - $ 500.00 51-000-62-00-5413 MAINTENANCE-CONTROLS $ $ $ $ $ $ $ $ - $ - 51-000-62-00-5421 WEARING APPAREL $ 65.61 $ 85.57 $ 150.39 $ 142.07 $ 159.64 $ 91.44 $ 150.78 $ 125.43 $ 970.93 $ 3,500.00 51-000-62-00-5422 WATER TOWER PAINTING $ - $ $ $ $ $ $ - $ $ - 51.000-62-00-5434 RENTAL-EQUIPMENT $ $ $ $ $ $ $ $ $ 1,000.00 51-000-62-00-5435 ELECTRICITY $ $ 12,814.11 $ 21,659.93 $ 24,167.83 1$ 11,916.48 $ 25,873.23 $ 24,057.99 $ 25,274.33 $ 145,763.90 $ 290,000.00 51-000.62-00-5436 TELEPHONE $ $ (469.01) $ 1,272.38 $ 1,257.07 $ 1,266.99 $ 1,281.75 $ 1,257.37 $ 1,284.18 $ 7,150.73 $ 22,000.00 51-000-62-00-5438 CELLULAR TELEPHONE $ $ 145.40 $ 160.84 $ 152.96 $ 202.89 $ 200.92 $ 164.17 $ 290.56 $ 1,317.74 $ 3,300.00 51-000.62-00-5439 LEAK DETECTION SURVEY $ $ $ $ $ $ $ $ - $ 51-000-64-00-5600 DUES $ $ 367.00 $ $ $ $ $ $ 367.00 $ 1,000.00 51-000-64-00-5603 SUBSCRIPTIONS $ $ $ $ $ $ $ $ 57.20 $ 57.20 $ 250.00 51-000-64-00-5604 TRAINING&CONFERENCE $ $ $ 330.00 $ $ $ 776.60 $ $ 1,106.60 $ 1,600.00 51-000.64-00-5605 TRAVEL EXPENSES $ $ $ $ - $ $ $ $ - $ 1,600.00 51-000-65-00-5800 CONTINGENCIES $ $ $ $ $ $ $ $ $ - 51-000-65-00.5804 OPERATING SUPPLIES $ 736.50 $ 3,148.82 $ 912.53 $ 722.84 $ 906.72 $ 448.70 $ 1,509.99 $ 2,274.26 $ 10,660.36 $ 32,500.00 51-000-65-00-5808 POSTAGE&SHIPPING $ 1,429.84 $ 1,751.54 $ 109.29 $ 2,466.85 $ 100.41 $ 300.00 $ 2,484.12 $ 3,940.47 $ 12,582.52 $ 22,000.00 51-000.65-00-5809 PRINTING&COPYING $ $ 106.01 $ 103.67 $ 103.42 $ 103.58 $ 103.19 $ 105.07 $ 102.37 $ 727.31 $ 2,500.00 51-000-65-00-5810 PUBLISHING&ADVERTIS $ $ $ 933.50 $ $ $ $ $ 933.50 $ 500.00 51.000.65-00-5812 GASOLINE $ $ 399.91 $ 3,077.08 $ 2,722.03 $ 2,885.30 $ 1,120.82 $ 1,893.89 $ 1,969.38 $ 14,068.41 $ 34,000.00 51-000.65-00-5815 HAND TOOLS $ $ $ $ $ $ $ $ - $ 1,000.00 51-000.65-00-5817 GRAVEL $ $ $ $ $ $ 264.11 $ $ 150.79 $ 414.90 $ 2,000.00 51-000-65.00-5820 CHEMICALS $ $ $ $ $ $ $ $ - $ 51-000.65.00-5821 CATHODIC PROTECTION $ $ $ $ $ $ $ $ - $ - 51-000-65-00-5822 WATER SAMPLES $ $ $ $ 33.00 $ 9,992.04 $ 25.00 $ - $ 33.00 $ 10,083.04 $ 14,000.00 51-000-66-00-8200 INTEREST EXPENSE $ $ $ $ $ $ $ - $ - $ - 51-000-72-00-65001MRF PARTICIPANTS $ 2,448.71 $ 2,451.58 $ 2,387.33 $ 3,560.88 $ 1,230.78 $ 3,742.59 $ 2,483.68 $ 2,659.84 $ 20,965.39 $ 31,017.00 51.000-72-00-6501 SOCIAL SECURITY&MED $ 1,951.95 $ 1,955.43 $ 1,901.59 $ 2,835.53 $ 981.89 $ 3,008.90 $ 1,981.78 $ 2,137.83 $ 16,754.90 $ 28,588.00 51-000-75-00-7002 COMPUTER EQUIP&SOFT $ $ $ $ $ $ $ 178.00 $ 178.00 $ 1,200.00 51-000-75-00-7004 SAFETY EQUIPMENT $ $ 17537 $ $ $ $ $ $ 175.77 $ 1,000.00 51-000-75-00-7506 METER READERS $ $ $ 421.81 $ $ $ $ $ 421.81 $ - 51-000-75-00-7507 HYDRANT REPLACEMENT $ $ $ 110.39 $ $ $ $ $ 110.39 $ 6,000.00 51-000-75-00-7508 METERS&PARTS $ 80.59 $ 1,540.04 $ 1,007.25 $ 4,938.48 $ 3,895.55 $ 5,528.56 $ 1,817.84 $ 856.69 $ 19,665.00 $ 40,000.00 51.000-75-00-7509 ELECTRICITY MONITOR $ $ 421.81 $ $ $ $ $ - $ 421.81 $ - 51-000-78-00.9005 REFUND $ $ $ $ $ $ $ $ - $ - 51-000-78-00-9006 MERIT $ $ $ $ $ $ $ $ - $ - 51-000-78-00-9007 FOOD PANTRY DONATIONS $ $ $ $ $ $ $ - $ $ - 51-000-78-00-9008 RESERVE-1-120 TOWER MAI $ $ $ $ $ $ $ - F$ 451,931.50 $ - 51-000-78-00-9009 RESERVE $ $ $ $ $ $ $ $ - 51-000-78-00.9098 RECAPTURE $ $ $ $ - $ $ $ $ 51-000-78-00-9099 BAD DEBT $ $ $ $ $ $ $ - $ - 51-000-99-00-9901 TRANSFER TO GENERAL $ $ $ 22,965.75 $ $ $ 22,965.75 $ $ 91,863.00 51-000-99-00-9950 TRANSFER TO PW EQUIP $ $ $ $ $ _$ $ $ - $ TOTAL WATER O TION5 3EvENU $ 7 3 x11�a5 $ 23' $ 33D,87Z.79 ,75LDB $ 3Q5 8.875.20 $ 264 276.35 $ _ $ $ _ $ S 1.7�7 396.66 $ 3,a5105C p0 TOTALWATER OPERATIONS EXPENSES $ 36,184.59 62ADL55 $ 331,8'16.43 99,349.58 $ 73,994.89 3 77.49 91,95F9.02 x00.#WJ6' i # S 3 $ X9$157.61 $ 1265,62(1.60 FUND SURPLUS DEFT 89 $ 239,920.00 $ 102,916 ZD $ 231,5],3.21 $ 66 249.51 183,68137 $ 83,127.82 $ 99 $ $_ - $ $ $ 399,239,05 $ 85 490.00 10 of 18 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/1-14-11 WOUAL EN5ES'SYMONLH - � - __ _ - - ry„ Marrao-ll _ YBAN=MYDATE ANNUAL ACCOUN'T"NUM9EkA1�IDDESCAWFION M 10 June-10 July-10 August-i0 5eptorober-11) � Octaber=10 NOvemtmr-14 December-10 fanum-11 Februa it ' April-12 T*TALS BUDGET WATER IMPROVEMENTS REVENUES 51-200-40-00-3999 BEGINNING FUND BALANC $ $ $ $ $ $ $ $ - $ (1,063,123.00) 51-200-42-00-4220 CONNECTION FEES $ 20,040.00 $ 14,020.00 $ 10,320.00 $ 6,360.00 $ 9,020.00 $ 18,040.00 $ 4,000.00 $ 3,700.00 $ 85,500.00 $ 190,000.00 51-200-42-00-4221 SW WTR MAIN PROJECT $ $ $ $ $ $ $ $ $ 51-200-42-00-4222 USGS SHALLOW WATER $ $ $ $ $ $ $ $ - $ 51-200-42-00-4230 MPI CONNECTION FEE RE $ $ $ $ $ $ $ $ $ 51-200-42-00-4240 AUTUMN CREEK CONN REC $ $ $ $ $ $ - $ $ - $ 51-200-42-00.4250 IMPROVEMENT EXPANSION $ $ 112,450.47 $ 85.34 $ 114,171.19 $ 368.84 $ 112,611.98 $ 168.48 $ 115,327.97 $ 455,184.27 $ 580,104.00 51-200-44-00-4490 MISCELLANEOUS INCOME $ $ $ $ $ $ $ $ - $ 51-200-46-00-4600 INVESTMENT INCOME $ 54.03 $ 57.36 $ 61.03 $ 53.07 $ 49.44 $ 48.56 $ 31.54 $ 20.61 $ 375.64 $ 1,200.00 51-200-49-00-4901 TRANSFER FROM GENERAL $ $ $ $ $ $ $ - $ $ WATER IMPROVEMENTS EXPENSES 51-200-61-00-5300 LEGAL SERVICES $ $ $ $ $ $ $ $ - $ 2,000.00 51-200-61-00-5301 ENGINEERING-GENERAL $ $ $ $ $ $ $ 51-200.61.00-5302 FINANCIAL EXPENSES $ $ $ $ $ $ $ - 51-2D0-61-00-5400 B.2 CONTRACTS $ $ $ $ $ $ $ - $ $ 51-200-61.00-5401 B.3 CONTRACTS $ $ $ $ $ $ - $ - $ $ 51-200-61-00-5405 RADIUM VIOLATIONS $ $ $ $ $ $ $ - $ $ 51-200.61-00-5408 CENTRAL ZONE-CONTRACT $ $ $ $ $ $ $ - $ $ 51-200-61-00.5410 ENGINEERING-CENTRAL Z $ $ $ $ $ $ $ $ $ 51-200.61-00-5421 WELL 4 CONSTRUCTION $ $ $ $ $ $ $ - $ - $ 51-200-61-00.5422 WELL CONSTRUCTION $ $ $ $ $ $ - $ - $ - $ 51-200-62-00-5460 MPI RECOVERY $ $ $ $ $ $ $ - $ $ 51-200-62-00.5461 AUTUMN CREEK RECOVERY $ $ $ $ $ $ - $ - $ $ 51-200-62-00-5462 FOX HILL WATERMAIN RE $ $ $ $ $ $ - $ $ $ 51-200-62-00-5463 KENDALLWOOD ESTATES R $ $ $ $ $ $ - $ $ $ 51-200-62-00-5464 GRANDE RESERVE COURT $ 22,988.77 $ 22,988.77 $ 22,988.77 $ 22,988.77 $ 22,988.77 $ 22,988.77 $ 22,988.77 $ 22,988.77 $ 183,910.16 $ 269,856.00 51-200-66-00-6007 RADIUM COMPLIANCE BON $ 16,575.00 $ $ $ $ $ $ 16,575.00 $ 33,150.00 $ - 51-200-66-00-60411EPA L17-156300 PRINC $ $ $ 62,515.08 $ $ $ - $ $ 62,515.08 $ 125,031.00 51-200-66-00-60421EPA L17-156300 INTER $ $ $ $ $ $ $ $ $ 51-200-66-00.6056 2006A REFUND.INTERES $ $ $ $ $ $ $ - $ $ - 51-200-66-00-6057 2006A REFUND.PRINCIPA $ $ 45,653.13 $ $ $ $ $ - $ 231,306.26 $ 276,959.39 $ 161,307.00 51-200-66-00.6058 2002 PRINCIPAL PMT-NO $ 215,000.00 $ $ $ $ $ - $ - $ 215,000.00 $ 215,000.00 51-200-66-00-6059 2007A REFUNDING P&I P $ $ 62,133.13 $ $ $ $ $ - $ 62,133.13 $ 51-200-66-00-6072 20050 INTEREST PMT-$2 $ $ $ $ $ - $ - $ - $ $ 51-200-66.00-6073 2005C PRINCIPAL PMT-$ $ $ 20,175.00 $ $ $ - $ $ - $ 250,700.00 $ 270,875.00 $ 83,863.00 51-200-75-00.7503 SOUTHWEST WATER MAIN $ $ $ $ $ $ - $ - $ $ - 51-200-75-00-7504 NORTH WATER TOWER CON $ $ $ $ $ $ $ - $ $ 51-200-75-00-7520 WATERMIAN PROJECTS $ $ $ $ $ $ $ - $ $ 51-200-75-00-7522 IN-TOWN RD WATER PROJ $ $ $ $ $ $ $ $ $ 51-200-99-00-9901 TRANSFER TO GENERAL F $ - $ - $ - $ _ - $ - $ $ - _ _ $ _ $ - $3 f$ 10 466.37 320 59•ZB $ +x,439.2$ $ _ 13D,700.54 _$ 94.9 .77 - _ $ 291819.00 TOTAL WATER IMPROVEMENT EXPENSES $ 254,963.77 $ 156,950,03 85 503 85 $ 229$877 $ 8&77 $ 22 98877 $ 75 $ $ $ $ $ $ 1,504�2.� $ B57A57.00 TpTAEWATER'IMPRDVEMENTIIEVENUES 2D2194:n3 $ i2R $ 4204.0:2 141NDSURPLU3 EN $ 7 $ 22.20 $ 7A8 97 95A9 $ A8 $ 1007,711,77 $ 1,148876.OBp IMPROVEMENT&OPERATIONS FUNDS _ _ COMBINED WATER IMP AL FUND ES $ 27,094.63' 428,689.36 19966:60 $ 451457.05 $ 19,19 .36 ii$ 495.754A0 $ 13025.22 $ 983,324.93 $ $ $_ $ 1,779ASS.37 $ 1,059,231.00 TOTAL FlIN @EXPENSES $ ?90,4$38 213.75#58 $ 197,326.28 $ 122,338.35 $ 96 83.36 $ 144,066.26 $ 191516.79 b83,675.39 I$ $ # $ $ 1,802,700.3'7 $ 2,122,677.00 - FUND SURPLUS( - $ - 73 S 214,88T.80 $ 177 3 $ 329,113.70 $- .794.00 $ 29 3.14 $ -- i 57 $ -(222,950A8 $ $ $ $ $ 24.249.80 $ (1.069,446,00) SEWER OPERATIONS REVENUES 52-000-40-00-3999 BEGINNING FUND BALANC $ $ $ $ $ $ - $ $ - $ 52-000-42-00.4221 RIVER CROSSING FEES $ 237.97 $ 237.97 52-000-42-00-4240 LIFT STATION INCOME $ $ $ $ $ $ $ - $ - $ 52.000-42-00-4250 SEWER MAINTENANCE FEE $ (485.37) $ 122,131.11 $ 270.24 $ 122,304.55 $ 283.59 $ 120,056.54 $ (578.13) $ 122,869.31 $ 486,851.84 $ 580,000.00 52-000-42-00-4251 SEWER CONNNECTION FEE $ 115,400.00 $ 400.00 $ 400.00 $ 300,200.00 $ 200.00 $ 600.00 $ - $ 200.00 $ 417,400.00 $ 25,000.00 52-000-44-00-4417 REIMBURSEMENTS $ 3,379.48 $ 3,379.48 52-000-44-00-4498 RECAPTURE $ $ $ $ $ $ - $ $ $ 52-000-44-00-4499 BAD DEBT RECOVERY $ - $ - Is - $ - $ - $ - is $ - $ 52-000-46-00-4600 INVESTMENT INCOME $ 45.40 $ 133.06 $ 331.98 $ 192.14 $ 170.95 $ 318.84 $ 86.56 $ 78.78 $ 1,357.711$ 1,800.00 SEWER OPERATIONS EXPENSES 52-000-50-00-5108 SALARIES-SEWER OP. $ 18,145.36 $ 15,831.32 $ 17,293.68 $ 26,448.48 $ 9,091.33 $ 25,874.23 $ 17,722.37 $ 30,125.22 $ 160,531.99 $ 256,296.00 52-000-50.00.5136 SALARIES-PART TIME $ $ $ $ $ $ $ - $ $ - 52-000-50-00.5137 SALARIES-OVERTIME $ $ $ $ $ 241.80 $ 88.26 $ $ 117.68 $ 447.74 $ 7,500.00 52-000-62-00-5401 CONTRACTUAL SERVICES $ $ 19.98 $ 19.98 $ 19.99 $ 330.49 $ 19.99 $ 53.30 $ 19.98 $ 483.71 $ 4,500.00 52-000-62-00.5408 MAINTENANCE-EQUIPMENT $ 123.89 $ $ $ 149.41 $ $ 34.99 $ $ 323.89 $ 632.18 $ 5,000.00 11 of 18 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/1-14-11 ACTUALEXPEN$ESBY MONTH - - ACCOUNr NUMBER AND DESCRIPTION May-l0 J¢ne-10 July-10 August-10 September-10 October-10 W"mbea•10 Dmmber-10 January-11 February-11 Marsh-ll April-11 KYlAl ATE ANNUAL S BUDGET 52-000-62-00-5409 MAINTENANCE-VEHICLES $ - $ 20.00 $ 20.00 $ 19.40 $ - $ - $ 390.50 $ 2,986.75 36.65 $ 4,000.00 52.000-62-00-5419 MAINTENANCE-SANITARY $ $ (695.56) $ 6.99 $ 281.15 $ 450.00 $ - $ 13.78 $ 62.76 19.12 $ 20,000.00 52-000-62-00-5421 WEARING APPAREL $ 65.62 $ 85.57 $ 228.44 $ 142.06 $ 159.61 $ 91.44 $ 150.79 $ 125.44 48.97 $ 2,500.00 52-000-62-00-5422 LIFT STATION MAINTENA $ $ 310.50 $ $ 777.30 $ 37.88 $ 636.73 $ 1,647.63 $ 5.98 16.02 $ 15,000.00 52-000-62-00-5434 RENTAL-EQUIPMENT $ $ - $ $ $ $ $ - - $ 1,000.00 52-000-62-00-5435 ELECTRICITY $ $ 1,082.69 $ 1,412.09 $ 2,083.33 $ 1,881.20 $ 1,298.66 $ 1,331.52 $ 1,373.92 3.41 $ 30,000.00 52-000-62-00-5438 CELLULAR TELEPHONE $ $ 87.23 $ 96.51 $ 91.78 $ 100.74 $ 143.07 $ 225.60 $ 112.85 57.78 $ 1,800.00 52-000-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ $ 500.00 52-000-64-00-5605 TRAVEL/MEALS/LODGING $ $ $ $ $ $ $ - $ 500.00 52-000-65-00-5800 CONTINGENCIES $ $ $ $ $ $ $ $ - 52-000-65-00-5802 OFFICE SUPPLIES $ $ $ 129.29 $ $ $ 7.98 $ (118.83) 18.44 $ 1,800.00 52-000.65-00-5804 OPERATING SUPPLIES $ $ $ 19.07 $ $ $ 23.10 $ 2.17 $ 52-000-65-00-5805 SHOP SUPPLIES $ $ 268.20 $ 313.31 $ 273.95 $ 49.68 $ 168.03 $ 148.82 $ 239.34 1.33 $ 2,500.00 52-000-65-00-5812 GASOLINE $ $ 399.91 $ 3,077.09 $ 2,722.03 $ 2,885.28 $ 1,120.81 $ 1,893.89 $ 1,969.37 , 68.38 $ 26,000.00 52-000-65-00-5815 HAND TOOLS $ $ $ $ $ $ m $ $ - $ 1,000.00 52-000-65-00-5817 GRAVEL $ $ $ $ m $ $ m $ $ - $ 2,000.00 52.000-65-00-5823 SEWER CHEMICALS $ $ $ $ $ $ $ $ $ - 52-000-66-00-8200 INTEREST EXPENSE $ $ $ $ $ $ $ $ $ 52.000-72-00-65001MRF PARTICIPANTS $ 1,656.66 $ 1,624.66 $ 1,578.89 $ 2,414.73 $ 852.11 $ 2,499.64 $ 1,618.04 $ 2,452.61 $ 14,697.34 $ 21,949.00 52.000-72-00-6501 SOCIAL SECURITY&MED $ 1,318.08 $ 1,292.33 $ 1,254.00 $ 1,919.84 $ 679.51 $ 2,009.54 $ 1,286.78 $ 2,009.17 $ 11,769.25 $ 20,230.00 52-000-75-00-7002 COMPUTER EQUIP&SOFT $ $ $ $ $ $ $ $ - $ 1,000.00 52-000-75-00-7003 OFFICE EQUIPMENT $ $ $ $ w $ $ 4.99 $ $ 4.99 $ 500.00 52-000-75-00-7004 SAFETY EQUIPMENT $ $ 175.77 $ $ $ 995.00 $ m $ $ 1,170.77 $ 1,000.00 52-000-78-00-9005 MERIT $ $ $ $ $ $ m $ $ $ 52-000-78-00-9009 RESERVE $ $ $ $ $ $ $ $ $ 52-000-78-00-9098 RECAPTURE $ $ $ $ $ $ $ $ w $ 52-000-78-00-9099 BAD DEBT $ - $ $ $ $ $ $ $ - $ 52-000-99-00-9901 TRANSFER TO GENERAL $ $ $ 20,761.25 $ $ $ 20,761.25 $ $ 41,522.50 $ 83,045.00 52-000-99.00-9950 TRANSFER TO PW EQUIP $ $ $ $ $ $ _ __ $ - _ $ TOTAL SEWER OPERATIONS REVENiJ 2100.03 $ 222,664.57 1,002.22 $ 422.696.69 654.54 '$ 320875 96 $ 491. $ 3 6.765.94 S _ _ $ $ $ $ 909,2l7.06 $ 606.500.00 - TOTAL SEWER OPERATIONS EXPENSES $ 22.309.67 $ 2002.601$ AI 230.59 $ 37,343.45 $ _17.75463 $ 54.782.71 $ 2Q364.19 $ 41,974.96 $ - $-_ _ $ $_ 266.192.74 1 $ 509,620.00' - . FUNDSURPlUS EJ7 $ 99850A2 . 10_ 7 $ 45,40837! :365 ,1.00.09 $ 66.194.67 $ 26,655.76 '$ 84.64058 $ $ $ $ $ 643034.26 $ 97,380.00 SEWER IMPROVEMENTS REVENUES 52-20040-00-3999 BEGINNING FUND BALANC $ $ $ $ $ $ $ $ $ 1,192,223.00 52-200-42.00-4220 CONNECTION FEES $ 12,600.00 $ 3,600.00 $ 3,600.00 $ 1,800.00 $ 1,800.00 $ 5,400.00 $ 2,000.00 $ 1,800.00 $ 32,600.00 $ 175,000.00 52-200-42-00-4221 RIVER CROSSING FEE $ $ $ $ $ - $ $ $ $ 52-200-42-004229 NORTH BRANCH#2(DEV $ $ $ $ $ $ - $ - $ $ 52-200-42-004803 ROB ROY CREEK REVENUE $ $ $ $ $ $ $ $ $ 52-200 42-00-4805 COUNTRYSIDE INTERCEPT $ $ $ $ $ $ $ $ $ - 52-200-46-00-4600 INVESTMENT INCOME $ $ $ $ $ $ $ $ $ 52-200-48-00-4803 ROB ROY CREEK REVENUE n/a n/a n/a n/a n/a $ $ $ - $ 100,000.00 52-200-49-00-4901 TRANSFER FROM GENERAL $ $ $ $ $ $ $ $ $ SEWER IMPROVEMENTS EXPENSES 52-200-62-00-5401 CONTRACTUAL/PROF.SVC $ $ 13,877.05 $ $ $ $ $ - $ 13,877.05 $ - 52-200-62-00-5402 ENG/LEGAL/CONTINGEN-C $ $ m $ $ $ $ $ $ $ 52-200-62-00-5403 ENGINEERING-7ANGLER $ $ $ $ $ $ $ $ $ 52-200-62-00-5462 FOX HILL SEWER RECAPT $ $ $ $ $ $ $ - $ $ 52-200-62-00-5463 LENNAR SEWER RECAPTUR $ $ $ $ $ $ $ 30,996.00 $ 30,996.00 $ - 52-200-66-00-6003 2003A IRBB INTEREST P $ $ $ 36,826.25 $ $ $ $ $ 36,826.25 $ 163,653.00 52-200-66-00-6004 2003A IRBB PRINC.PMT $ $ $ w $ $ $ $ $ $ 52-200.66-00-6008 20048 PRINCIPAL PMT-C $ 51,650.00 $ $ m $ $ $ $ $ 413,300.00 $ 464,950.00 1$ 258,300.00 52-200-66-00-6009 2004B INTEREST PMT-CN $ $ $ $ $ $ $ $ $ - 52-200-66-00-6010 2004A INTERST PMT-COM $ $ $ $ $ $ $ $ - $ 52-200.66-00-6011 2004A PRINCIPAL PMT-C $ $ 14,286.25 $ $ $ $ $ $ 348,572.50 $ 362,858.75 $ 188,572.00 52-200-66.00.6016 2005D INTEREST PMT-RO $ - $ 192,975.00 $ $ $ $ $ - $ 385,950.00 $ 578,925.00 $ 537,541.00 52-200-66-00-6017 2005C 2M ALT REV $ $ 20,175.00 $ $ $ $ $ $ 20,175.00 $ 82,850.00 52-200-66-00-6018 DEBT SERVICE $ 55,045.00 1 $ 110,090.00 $ 165,135.00 52-200-66-00-60491EPA LOAN L17-013000 $ $ m $ $ $ $ $ $ w $ 52-200-66-00-60501EPA LOAN L17-013000 $ $ $ 19,489.99 $ $ $ $ $ 19,489.99 $ 38,980.00 52-200.66-00-60551EPA LOAN L17-115300 $ $ $ $ 53,525.35 $ $ $ $ 53,525.35 $ 107,051.00 52-200.66-00.6059 2007A BOND $ $ $ $ w $ $ $ $ 144,266.26 $ 144,266.26 $ 133,866.00 52-200-75-00-7505 ROB ROY INTERCEPTOR $ $ $ $ $ $ $ - $ $ 52-200-75-00.7506 SOUTHWEST SVC AREA IN $ $ $ $ $ $ $ $ $ 52-200-75-00-7509 NORTH BRANCH#2 $ $ $ $ $ $ $ $ $ 52-200-99-00-9901 TRANSFER TO GENERAL F $ $ $ $ $ _ $ $ _ _ $ $ - Tt}TAL SEWER RMPROVEMENTRIEVENUES $ 14.600.00 9600:00 $ 3.600.00 $ 1)600.00 $ 00 5,400.00 $ 2,000.00 $ 1,800.00 $ $ $ S $ 92.600.00 $ 146_7,223.00 12 of 18 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/1-14-11 - --- AMAL 90__ 6Y M0 - ACCOU14T NUMBER AND DESCRIPTION Mny-10 June-38 Suty-10 August-l0 Sgptemher-10 Octnber-10 November-10 December-.10 January-11 February•11 Marth-11---- April-21 - - Mit TO.OATE ANNUAL 'tOy'AFS BUDGET T�OMSEWER1MPROVEMER �XPENS $ 51,650.00 $ Z9685>Y30 $ $6,316.24 $ 53,52&.35 $ $- $ 30996.00 $ 1 178,96 $ $ $ $ $ 1,091,024.65 $ 1,520 13,06 - - FUN8511RPLUS DEFI $ 39 00 $ 292.758.30 S. 52,716.24 $ 52,725.36 $_ 1,50000 $ 5,400.00 $ 26 .00 (SAfflA7B.76: $ $ $ $ (1 896 424 65) $ (49,S90,00) COMBINED SEWER IMPROVEMENT&OPERATIONS FUNDS TOTAL FUND ItwNUES $ 117;360,6 !$ 12$ 17 � 4602.22_'$ SIAN-69 $ 2A54 94 126 975.38 $ 1508 43 i 12411,56S.54 $ _ $ 3 - $ __ $ 941627.00 $ _2,074,023,00 - - - TOTAL FUND EXPEN9ES $ 72A9.6111$_3.1.6,860.90 $ MIA26.83 90,868.E 41 17,764.69 5#,782.7.1 $ 67,360.29 lA44,T08.72 $ _ _ - $ $_ $_ - _ S 2,557,217.39 $ 2,020A33.00 FUND SURPWS EFI $ 54AMA2 $9 73 97,97861 $ 333.627.63 $ 19,300.09 $ 1 815 538 18 $ $ $ $ __ $ ,215,$90.39 $ 71,592 67 $ 93,8917 53590.06 LAND CASH REVENUES 72.000-40.00-3999 BEGINNING FUND BALANC $ $ $ $ $ $ $ $ $ 69,641 72-000-44-00-4413 REIMS FROM OTHER GOVE $ $ $ $ $ $ $ $ $ - 72-000-45-00-4501 CANNONBALL RIDGE GRAN $ $ $ $ $ $ $ $ - $ - 72-000.47-00-4700 OSLAD GRANT-PRAIRIE $ $ $ $ $ $ $ $ - $ - 72-000.47-00-4701 GREENBRIAR $ $ $ $ $ $ $ $ - $ - 72-000-47-00-4702 BIKE PATH GRANT $ $ $ $ $ $ $ $ - $ - 72-000-47-00-4703 PRAIRIE GARDEN 72-000-47-00-4704 OSLAND GRANT-WHISPE $ $ $ $ - $ $ - $ $ - $ 320,000 72-000-47-00.4705 COUNTRY HILLS $ $ $ $ $ $ $ $ - $ - 72-000-47-00-4706 WHEATON WOODS GRANT $ $ $ $ $ $ - $ - $ $ 30,000 72-000-47-00.4707 FOX HIGHLANDS $ $ $ $ $ $ - $ $ - $ - 72-000.47-00-4709 SUNFLOWER $ $ $ $ $ $ - $ - $ $ 72-000-47-00-4712 RIVER'S EDGE $ $ $ $ $ $ $ - $ 671.00 $ 671.00 $ - 72-000-47-00-4714 WOODWORTH $ $ $ $ $ $ - $ $ - $ 72.000-47-00-4715 WHITE OAK UNIT 1&2 $ $ $ $ $ $ $ - $ $ 72-000-47-00-4716 WHITE OAK UNIT 3&4 $ $ $ $ $ $ $ - $ $ 72-000-47-00-4717 KYLN'S CROSSING $ $ $ $ $ $ - $ $ $ - 72-000-47-00-4718 FOXFIELD II PARK $ $ - $ $ $ $ $ - $ - $ 72-000-47-00-4719 WILDWOOD $ $ $ $ $ $ $ - $ - $ - 72-000-47-00-4722 KYLN'S RIDGE $ $ $ $ $ $ $ - $ - $ - 72-000-47-00-4723 HEARTLAND CIRCLE $ $ $ $ $ $ $ - $ - $ 72-000.47-00-4725 WINDETTE RIDGE $ $ $ $ $ $ $ - $ $ 72-000.47-00.4727 GRAND RESERVE $ $ $ $ $ $ - $ $ - $ 72-000-47-00.4731 MONTALBANO HOMES $ $ $ $ $ $ $ - $ $ 72-000-47-00-4732 RAINTREE VILLAGE $ $ $ $ $ $ $ - $ - $ 72-000-47-00-4734 WHISPERING MEADOWS(K $ $ $ $ $ - $ $ $ $ 3,000 72-000.47-00-4735 PRAIRIE MEADOWS(MENAR $ $ $ $ $ - $ $ $ $ - 72-000.47-00.4736 BRIARWOOD $ $ $ $ $ $ $ $ - $ - 72.000-47-00-4737 CALEDONIA $ $ $ $ $ $ - $ - $ $ 38,000 72.000-47-00-4738 AUTUMN CREEK $ 2,051.14 $ 2,051.14 $ $ 2,051.14 $ 4,102.28 $ 6,153.42 $ - $ 16,409.12 $ 22,000 72-000.47-00.4739 WYNSTONE TOWNHOMES $ $ $ $ $ $ - $ $ $ 72-000-47-00-4740 VILLAS AT THE PRESERV $ $ $ $ $ $ - $ $ - $ - 72.000-47-00-4741 BAILEY MEADOWS $ $ $ $ $ $ - $ - $ - $ 72-000-47-00-4742 BLACKBERRY WOODS $ $ $ $ $ $ $ - $ $ - 72-000-47-00-4743 CORNEILS CROSSING $ $ $ $ $ $ - $ - $ $ - 72-000-47-00-4744 HUDSON LAKES $ $ $ $ $ $ $ - $ $ 72.000-47-00-4745 PRESTWICK $ $ $ $ $ $ - $ - $ $ 72-000-47-00-4746 WESTBURY $ $ $ $ $ $ $ - $ - $ 72.000-47-00-4747 WESTHAVEN $ $ $ $ $ $ $ - $ $ 72-000-47.00-4748 WILLMAN $ $ $ $ $ $ - $ - $ $ 72-000-47-00-4749 BLACKBERRY WOODS $ $ $ 568.18 $ $ $ - $ - $ 568.18 $ 72-000-47-00-4750 KENDALLWOOD ESTATES $ $ $ $ $ $ - $ - $ $ 72-000-47-00-4751 CANNONBALL RIDGE PARK $ $ $ $ $ $ - $ - $ - $ - 72-000-47-00.4752 BRISTOL BAY LAND CASH $ $ $ 100,000.00 $ $ - $ - $ - $ 100,000.00 $ - 72-000-49-00-4901 TRANSFER FROM GENERAL $ $ $ $ $ $ $ - $ - $ 72-000-49-00-4902 TRANSFER FROM LAND AC $ $ $ $ $ $ - $ - $ - $ - 72.000-49-00-4903 TRANSFER FROM PARK& $ $ $ $ $ - $ $ $ - $ LAND CASH EXPENSES 72-000-75-00-7308 RIVERS EDGE PARK#2 $ $ $ $ $ $ $ - $ $ - 72-000-75-00-7317 HEARTLAND CIRCLE $ $ $ $ $ $ - $ - $ - $ - 72-000-75-00-7326 MOSIER HOLDING COSTS $ $ $ $ $ $ - $ 10,000.00 $ 10,000.00 $ 10,000 72-000-75-00-7327 GRANDE RESERVE PARK $ $ $ $ $ $ $ - $ - $ 72-000.75-00-7328 PRAIRIE MEADOWS(MENA $ $ $ $ $ $ - $ - $ $ 72-000-75-00-7330 WHISPERING MEADOWS(K $ $ $ $ $ - $ - $ - $ $ 72-000-75-00.7332 CALEDONIA $ $ $ $ $ $ - $ - $ - $ 72-000-75-00-7333 RAINTREE VILLAGE $ $ $ $ $ $ - $ - $ - $ 495,000 72-000-75-00.7334 HOOVER HOLDING COSTS $ 11 $ $ $ I$ I$ I i $ $ 72-000-75-00-7335 GRANDE RESERVE BIKE T $ $ $ $ $ $ $ $ - $ 13 of 18 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/1-14-11 ACTUAL EXPENSES 8Y MOWN ACCOUNT NUMBS ANDDWAIPTJON � may-lA June-10 July-30 August-10 September-l0 Odaber•10 I�,Nrnember•10 01 -10 January-11 Februaryli March•11 Apr}I-11 ANNUAL YEAR -DATE L - - 70TAL$ BUDGET 72-000-75-00-7336 WHEATON WOODS NATURE $ $ $ $ $ $ $ $ 2,118.00 $ 2,118.00 $ 72-000-75-00-7337 BRISTOL BAY PARK A $ $ $ 662.51 $ 25,556.64 $ 54,892.70 $ 2,401.00 $ $ 1,420.00 $ 84,932.85 $ 100,000 72-000.78-00-9009 RESERVE $ $ $ $ $ $ $ $ $ - 72-000-78-00-9012 REC CENTER AGREEMENT $ $ $ $ $ $ $ $ $ - 72-000-99-00-9901 TRANSFER TO GENERAL F $ $ $ 15,112.25 $ $ $ 15,112.25 $ $ 30,224.50 $ 60,449 Td3ALfUNFi11EVENURS 2,05t.tA # 205�i4''# 10dS6R2$ _5 x SI.14I 4,'202.28 5 6,15$. $-- fi7i.00 $ S- _ $ -- $ $ 117,6d&90 S- -482.64IA0 TOTAL FUND p(PENSFS # # 35774 76 # 25 556.6q 44892 70 S 27.519#5 $ 38 000.00 353800 # - # - # _ # S 427,275.35_$ 665,A49.OU_ FUNDSURPLUS(DEFICm # 2,05124 $ - 2,05114' $ 84,793.A2 $ 123,505.50}',$ (50.790A2) $ (U.B59.83)! $ (40;000.00} $ (Z,B67.00} $___ - # $ $__ - # 9,627.05!'# 187 80&00 PARK&RECREATION OPERATING REVENUES 79-000-40-00-3999 BEGINNING FUNJE LANC $ $ $ $ $ $ $ $ - $ 388 79-000-42-00-4270 FEES FOR PROGS $ 8,942.50 $ 36,384.50 $ 13,856.00 $ 12,944.00 $ 6,887.00 $ 26,101.50 $ 17,347.80 $ 5,788.75 $ 128,252.05 $ 225,000 79-000.42-00-4280 CONCESSIONS/ALE $ 6,938.75 $ 10,307.76 $ 10,687.00 $ 709.50 $ 886.50 $ 174.50 $ 61.00 $ 29,765.01 $ 30,000 79-000-42-00-4285 VENDING MACHINCOM $ $ $ - $ $ $ $ - $ $ - 79-000-42-00-4286 RENTAL INCOM $ $ $ $ $ $ $ $ - $ - 79-000-42-00-4287 PARK RENTAL INE $ 2,985.00 $ 3,060.50 $ 2,735.00 $ $ 505.00 $ 200.00 $ $ 450.00 $ 9,935.50 $ 15,000 79-000.42-00-4288 GOLF OUTING RUE $ $ $ $ $ $ $ $ - $ 9,000 79-000-42-00-4291 HOMETOWN DA $ 2,520.00 $ 3,475.00 $ 9,970.00 $ 7,610.00 $ 103,768.90 $ 7,448.00 $ $ 134,791.90 $ 130,000 79-000-42-00.4295 MISC RETAIL $ $ $ $ $ $ $ $ - $ 3,500 79-000-44-00-4400 DONATIONS $ 1,105.00 $ 225.00 $ $ 1,728.00 $ 405.00 $ $ 670.00 $ 4,133.00 $ 14,000 79-000-44-00-4404 TREE DONATION $ $ $ $ $ 350.00 $ 350.00 $ 225.00 $ 925.00 $ 600 79-000-45-00-4 550 YOUTH SERVICENT $ $ $ $ $ $ $ $ - $ 500 79-000-46-00-4600 INVESTMENT INE $ 13.11 $ 22.97 $ 27.95 $ 32.92 $ 26.80 $ 31.17 $ 28.11 $ 23.32 $ 206.35 $ 500 79-000-49-00-4901 TRANSFER FROM ERAL $ 35,914.50 $ 35,914.50 $ 35,914.50 $ 35,914.50 $ 35,914.50 $ 35,914.50 $ 35,914.50 $ 35,914.50 $ 287,316.00 $ 430,974 79-000-49-00-4902 TRANSFER IN FRF- $ 100,000.00 $ $ $ $ $ $ - $ 100,000 $ 100,000 79-000.49-00-4903 TRANSFER FROM NERAL $ 43,409.66 $ 43,409.66 $ 43,409.66 $ 43,409.66 $ 43,409.66 $ 43,409.66 $ 43,409.66 $ 43,409.66 $ 347,277.28 $ 520,916 79-M-49.00-4980 TRANSFER FROM CEN $ $ $ $ $ $ $ $ $ 79-000-99-00-9973 TRANSFER TO LACQU $ $ $ $ $ $ $ _ _ $ $TOTAL PARIrS&RECRFJLT16VENUrxi $ 201,824.52 #_ 492 79989 116600.11 # 10284858 W2,25111416 tiB,629 9B # 96986.07 $ 96 623 $ # $ $ $ 1,042,502.09 $ 1480 378,00 PARK EXPENSES(FUND 79) 79-610-50-00-5107 SALARIES-PARKS $ 28,695.89 $ 27,427.07 $ 26,804.82 $ 41,346.65 $ 13,782.22 $ 40,877.93 $ 27,162.56 $ 27,457.18 $ 233,554.32 $ 350,026 79-610-50-00-5136 SALARIES-PART-TIME $ 1,021.25 $ 3,813.75 $ 4,170.25 $ 5,629.00 $ 330.00 $ 577.51 $ 66.00 $ 15,607.76 $ 17,000 79-610-50-00.5137 SALARIES-OVERTIME $ 206.19 $ 35.63 $ $ $ $ 24197 $ $ 483.19 $ 4,000 79-610-61-00-5320 MASTER PLAN/COMMUNI $ $ $ $ $ $ - $ $ - $ 79-610-62-00-5405 PARK CONTRACTUAL $ $ $ $ $ $ 2,025.00 $ 120.00 $ 2,145.00 $ 2,000 79-610-62-00-5408 MAINTENANCE-EQUIPMENT $ 641.43 $ 473.35 $ 91.92 $ 1,332.52 $ 1,438.89 $ 1,508.67 $ 1,283.42 $ 57.98 $ 6,828.18 $ 14,000 79-610-62-00-5417 MAINTENANCE-PARKS $ $ 631.89 $ 365.03 $ 11,331.12 $ 181.95 $ 468.16 $ 446.38 $ 1,180.00 $ 14,604.53 $ 34,000 79-610-62-00-5421 WEARING APPAREL $ 83.23 $ 174.93 $ 284.99 $ 131.19 $ 186.75 $ 295.48 $ 124.20 $ 456.10 $ 1,736.87 $ 4,100 79-610-62-00-5434 RENTAL-EQUIPMENT $ $ $ 148.50 $ $ $ - $ - $ 148.50 $ 2,500 79-610-62-00-5438 CELLULAR TELEPHONE $ $ 145.40 $ 160.85 $ 152.96 $ 167.90 $ 144.61 $ 141.41 $ 149.28 $ 1,062.41 $ 4,200 79-610.62-00-5445 LEGAL EXPENSES $ $ $ 500.00 $ 92.50 $ $ - $ $ 592.50 $ 4,000 79-610-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ - $ - $ - $ 1,500 79-610-64-00-5605 TRAVEL EXPENSE $ $ $ $ $ - $ $ - $ $ 79-610.65-00-5802 OFFICE SUPPLIES $ $ $ $ $ $ $ 50.55 $ 50.55 $ 300 79.610-65-00-5804 OPERATING SUPPLIES $ (13.32) $ 186.86 $ 2,106.32 $ 2,208.98 $ 393.70 $ 1,406.93 $ 479.72 $ 432.28 $ 7,201.47 $ 20,000 79-610-65-00-5815 HAND TOOLS $ $ $ 39.95 $ 143.96 $ $ 22.97 $ 173.86 $ 380.74 $ 1,750 79-610-65-00-5824 CHRISTMAS DECORATIONS $ $ $ $ $ $ $ 6.86 $ 352.17 $ 359.03 $ 1,000 79-610-65-00-5825 PUBLIC DECORATION $ $ $ $ $ $ $ - $ $ 500 79-610-72-00-65001MRF PARTICIPANTS $ 2,608.37 $ 2,504.10 $ 2,447.29 $ 3,774.96 $ 1,258.32 $ 3,754.20 $ 2,479.95 $ 2,506.86 $ 21,334.05 $ 33,953 79-610-72-00-6501 SOCIAL SECURITY/MEDIC $ 2,213.67 $ 2,317.17 $ 2,294.15 $ 3,480.45 $ 1,041.86 $ 3,102.75 $ 2,007.52 $ 2,026.89 $ 18,484.46 $ 28,383 79-610-75-00-7002 COMPUTER EQUIP&SOFT $ $ $ $ $ $ $ $ $ 500 79.610-75.00-7003 OFFICE EQUIPMENT 1$ $ $ $ $ $ $ - $ $ 500 79-610.75.00.7701 FLOWERS/TREES $ $ 473.21 $ $ $ - $ - $ - $ 473.21 $ z 79-610-78-00.9005 MERIT $ - $ _ $ - $ - $ - $ $ _ $ - $TOTALPARKEXPENSES FUND 79) $ 35A55.71 $ 38,183.36 $ 39A14.07 S 69,624.29 $ 18,781,53 5 54,425.58 $ 34,542.43 -$ 325,04677 $ 524,7 RECREATION EXPENSES(FUND 79) 79-650-50.00-5107 SALARIES-RECREATION $ 21,089.02 $ 22,463.98 $ 19,587.13 $ 29,380.73 $ 9,793.57 $ 27,635.15 $ 20,337.14 $ 34,201.94 F$ 184,488.66 66 $ 368,532 79-650-50-00-5108 CONCESSION STAFF $ 2,675.50 $ 2,482.00 $ 2,192.79 $ 777.00 $ $ 222.75 $ 90.75 79 $ 10,000 79-650-50-00-5109 SALARIES-PRE SCHOOL $ 2,118.00 $ 417.96 $ $ 1,209.00 $ 986.50 $ 3,450.50 $ 2,279.00 $ 2,201.50 46 $ 20,000 79-650-50-00-5136 SALARIES-PART TIME $ 1,250.00 $ 1,250.00 $ 1,250.00 $ 1,875.00 $ 625.00 $ 1,782.88 $ 249.38 $ 238.88 14 $ 22,080 79-650-50-00-5137 SALARIES-OVERTIME $ $ $ $ $ $ $ - $ 300 79.650-50-00-5150 SALARIES-INSTRUCTOR $ 1,087.50 $ 1,839.51 $ 2,372.75 $ 2,714.89 $ 2,267.75 $ 3,603.02 $ 2,429.79 $ 540.26 7 $ 16,000 79-650-50-00-5155 SALARIES-RECORDINGS $ $ 227.51 $ 237.50 $ $ 280.88 $ 91.00 $ 91.00 89 $ 3,000 79-650-62-00-5401 CONTRACTUAL SERVICES $ 525.00 $ 3,545.00 $ 6,549.60 $ 8,742.69 $ 3,010.00 $ 2,767.00 $ 1,470.00 $ 1,575.00 29 $ 50,000 79-650-62-00-5408 MAINTENANCE SUPPLIES $ $ 77.04 $ 62.70 $ $ 104.11 $ - $ 69.03 $ 99.50 $ 412.38 $ 2,000 14 of 18 UNITED CRY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/1-14-11 - ACTUAL EXPEN$ BY MONTif - 1� ANNUAL ACCOUNT NUMBER AND DESCRIPTION May-1D June-ID Futy-10 Augusf-lfl '', September-1tl (ycMher-10 November-14 Oessember-34 January-11 ,. February-11 March-11 Apr}F1I GALS BUDGET YEAR-TO-DATE 79-650.62-00-5409 MAINTENANCE-VEHICLES $ - $ - $ 809.41 $ 49.32 $ 351.01 $ 93.00 $ - $ 1,302.74 $ 1,000 79-650-62-00-5410 MAINTENANCE-OFFICE EQ $ $ 250.24 $ 242.18 $ 239.48 $ 178.00 $ 178.00 $ 283.97 $ 188.26 $ 1,560.13 $ 3,500 79-650-62-00-5426 YOUTH SERVICES GRANT $ $ $ $ $ $ $ $ $ 500 79-650-62-00-5435 ELECTRICITY $ $ 1,931.62 $ 1,972.94 $ 2,021.18 $ 1,769.01 $ 1,404.39 $ 1,750.86 $ 2,116.83 $ 12,966.83 $ 22,000 79-650-62-00-5437 TELEPHONE/INTERNET $ $ $ 342.08 $ 341.40 $ 340.22 $ 339.15 $ 336.04 $ 337.14 $ 2,036.03 $ 1,300 79-650-62-00-5438 CELLULAR TELEPHONE $ $ 174.47 $ 193.02 $ 183.56 $ 201.47 $ 144.61 $ 141.42 $ 149.28 $ 1,187.83 $ 3,000 79-650-62-00-5445 PORTABLE TOILETS $ $ 1,042.50 $ (1,220.00) $ 862.50 $ 557.14 $ 1,077.50 $ $ 464.29 $ 2,783.93 $ 4,500 79-650-62-00-5603 PUBLISHING/ADVERTISIN $ $ $ $ 8,196.71 $ $ 2,500.00 $ $ 8,331.92 $ 19,028.63 $ 27,000 79-650-62-00-5605 BOOKS/PUBLICATIONS $ $ $ $ $ $ $ $ - $ 100 79-650-64-00-5600 DUES $ 223.32 $ $ $ $ $ $ $ 223.32 $ 1,500 79-650-64-00-5604 TRAINING AND CONFEREN $ $ $ $ 200.00 $ 5.00 $ $ 55.00 $ 260.00 $ 500 79-650-64-00-5605 TRAVEL EXPENSE $ $ $ $ $ $ $ $ - $ 79.650.65.00-5802 OFFICE SUPPLIES $ $ 12.49 $ 35.87 $ 563.61 $ $ 797.73 $ 273.56 $ 27.45 $ 1,710.71 $ 3,000 79-650-65-00-5803 PROGRAM EXPENSES $ 6,338.47 $ 2,312.34 $ 3,557.03 $ 5,729.77 $ 2,649.60 $ 4,393.53 $ 1,422.34 $ 7,547.44 $ 33,950.52 $ 53,600 79-650-65-00-5804 OPERATING SUPPLIES $ $ 7.47 $ $ 163.33 $ $ 1.47 $ - $ 13.47 $ 185.74 $ 1,000 79-650.65-00-5805 RECREATION EQUIPMENT $ $ - $ $ $ $ $ $ - $ 2,000 79-650-65-00-5808 POSTAGE&SHIPPING $ 800.00 $ $ 1,173.00 $ 800.00 $ $ 177.00 $ 1,796.00 $ 4,746.00 $ 8,000 79-650.65-00.5812 GASOLINE $ $ 137.64 $ 286.71 $ 273.75 $ 288.32 $ 154.97 $ 112.64 $ 78.23 $ 1,332.26 $ 3,000 79-650-65-00-5826 MILEAGE $ - $ $ $ $ $ $ $ - $ 300 79-650-65-00-5827 GOLF OUTING EXPENSES $ $ $ $ $ $ $ $ - $ 6,000 79.650-65-00-5828 CONCESSIONS $ 614.77 $ 3,039.02 $ 5,507.28 $ 2,173.68 $ 92.61 $ 15.60 $ 5.48 $ 11,448.44 $ 18,000 79-650.65-00-5833 HOMETOWN DAYS EXPENSE $ $ 34.37 $ 48,295.00 $ 6,933.00 $ 37,296.09 $ 6,989.07 $ $ 99,547.53 $ 100,000 79-650-65-00-5840 SCHOLARSHIPS $ $ $ 150.00 $ $ $ 71.00 $ $ 221.00 $ 1,000 79.650-65-00-5841 PROGRAM REFUND $ 346.00 $ 270.00 $ 619.00 $ 417.00 $ 195.00 $ 432.00 $ 132.00 $ 198.00 $ 2,609.00 $ 7,000 79-650-72-00-65001MRF PARTICIPANTS $ 2,187.72 $ 2,203.23 $ 1,902.42 $ 2,853.61 $ 975.66 $ 2,561.99 $ 1,895.11 $ 3,122.64 $ 17,702.38 $ 41,537 79-650.72-00.6501 SOCIAL SECURITY/MEDIC $ 2,122.74 $ 2,128.08 $ 1,913.36 $ 2,654.53 $ 1,031.00 $ 2,811.59 $ 1,906.76 $ 2,880.12 $ 17,448.18 $ 30,351 79-650-75-00-7002 COMPUTER EQUIP&SOFT $ $ 1,682.00 $ $ 918.00 $ $ $ $ 2,600.00 $ 2,600 79-650-78-00-9005 MERIT $ $ $ $ $ $ $ $ - $ - 79.650-78-00-9009 RESERVE $ $ $ $ $ $ $ $ - $79-650-78-00-9010 MISC RETAIL $ $ $ $ $ $ $ $ -79-650-99-00-9941 REPAYMENT OF GF LOAN $ $ $ $ $ $ $ $ -TOTAL RECREATION EXPENSES 79' $ 41,37&04 $ 47 26.47 98,03177 $ 80 73.74 82,997.94 $ 69,654.90 97127,27 $ 54312.15 $ - $ $ - S 495344.28 T#TTAt fUND EX?EIYSUES S_2 6834 75 $ 86,71183 $ 337 84 14984803 $ $2 1$1.779.59 $ 1181204$ $ 669.70 $ 6431x 18 $ - S --- $ � 1820 39 OS $ 1,463 912 09_ FUND SURPLUS DEFT $ 12403.77 47,086.0¢ $ (4,11145,73)1$ ,S45A& $ 710;$73.83 1$ M491,1511$ 25,31547-1$ 21,9408 1$ -_ $ $ $ $ 222,211.04 I$ 18,466.00 REC CENTER REVENUES 80-000-40-00-3999 CARRY OVER BALANCE F13.0,44 $ $ $ $ $ $ $ - $ (61,067) 80-000-42-00-4200 MEMBERSHIP FEES 8.00 $ 34,608.82 $ 30,919.00 $ 31,053.00 $ 30,963.00 $ 30,707.00 $ 34,959.00 $ 36,209.00 $ 259,866.82 $ 410,000 80-000-42-00-4210 GUEST FEES 6.00 $ 506.00 $ 411.00 $ 423.00 $ 335.00 $ 214.00 $ 480.00 $ 751.00 $ 3,476.00 $ 3,500 80-000-42-00.4220 SWIM CLASS 88.00 $ 7,082.25 $ 4,821.50 $ 1,154.00 $ 1,760.00 $ 1,392.00 $ 2,045.25 $ 768.00 $ 20,411.00 $ 35,000 80-000-42-00-4230 PERSONAL TRAI NI NG FEE 02.00 $ 915.00 $ 476.00 $ 40.00 $ 1,338.00 $ 257.00 $ 728.00 $ 698.00 $ 5,454.00 $ 15,000 80-000-42-00-4240 TANNING SESSIONS 39.00 $ 115.00 $ 142.00 $ 43.00 $ 180.00 $ 40.00 $ 77.00 $ 85.00 $ 921.00 $ 2,500 80-000-42-00-4270 FEES FOR PROGRAMS 02.00 $ 7,102.50 $ 4,183.50 $ 20,286.00 $ 12,368.00 $ 12,155.70 $ 9,058.00 $ 9,387.50 $ 83,443.20 $ 125,000 80.000-42-00-4280 CONCESSIONS 26.75 $ 1,903.75 $ 1,443.00 $ 900.75 $ 923.75 $ 988.25 $ 1,034.50 $ 1,177.50 $ 9,498.25 $ 12,000 80-000.42-00.4285 VENDING MACHINES $ $ $ $ $ $ $ - $ - 80-000-42-00-4286 RENTAL INCOME 1.00 $ 70.00 $ 14.00 $ 359.50 $ 1,278.25 $ 209.00 $ 593.00 $ 285.50 $ 3,210.25 $ 3,000 80-000.42-00-4295 MISC RETAIL $ $ $ 209.50 $ 77.00 $ 78.00 $ 46.00 $ 26.50 $ 437.00 $ 500 80-000-44-00-4400 DONATIONS/SPONSORSHI $ 170.00 $ 90.00 $ $ $ $ 156.50 $ 90.00 $ 506.50 $ 2,000 80-000-45-00-4550 GRANTS/SCHOLARSHIPS $ $ $ $ $ _ $ $ 500 TOTAL RECCENTERREVENU275 I$ 5237$32' $ 42,800100 $ 54,4696,$_ 49,273.00 $ 4500095 ,177.25 S 45 7800 S S S $ $ 387,124.02 $ - 547933.00' REC CENTER EXPENSES 80-000-50-00-5107 SALARIES-REC CENTER $ 2,630.78 $ 2,630.77 $ 2,630.77 $ 3,946.14 $ 1,315.39 $ 3,946.14 $ 1,973.08 $ 2,630.77 $ 21,703.84 $ 33,543 80-000-50-00-5109 SALARIES-PRESCHOOL $ 2,564.18 $ 400.00 $ $ 2,172.71 $ 1,825.41 $ 6,195.28 $ 4,028.88 $ 3,741.51 $ 20,927.97 $ 35,000 80-000-50-00-5136 SALARIES-PART TIME $ 7,760.13 $ 7,359.50 $ 6,294.88 $ 11,289.45 $ 3,410.63 $ 9,983.09 $ 8,214.09 $ 8,002.82 $ 62,314.59 $ 98,000 80-000-50-00-5137 SALARIES-OVERTIME $ $ $ $ $ $ $ - $ - $ 500 80.000-50-00-5150 SALARIES-INSTRUCTORS $ 4,096.00 $ 4,373.75 $ 5,471.94 $ 6,772.19 $ 1,504.50 $ 7,003.76 $ 4,620.01 $ 4,049.25 $ 37,891.40 $ 65,000 80.000.62-00-5401 CONTRACTUAL SERVICES $ $ $ $ 8,895.00 $ $ 3,263.00 $ 1,187.20 $ 13,345.20 $ 15,000 80-000-62-00-5408 MAINTENANCE-SUPPLIES $ 378.15 $ 640.50 $ 838.95 $ 1,688.12 $ 926.01 $ 566.74 $ 837.68 $ 453.76 $ 6,329.91 $ 11,000 80-000-62-00-5410 MAINTENANCE-OFFICE E $ $ 240.71 $ 259.26 $ 300.65 $ 270.19 $ 223.00 $ 329.41 $ 266.75 $ 1,889.97 $ 4,500 80-000-62-00-5416 MAINTENANCE-GENERAL $ 2,034.01 $ 133.49 $ 391.11 $ 1,604.69 $ 659.91 $ 89.80 $ 330.72 $ 892.33 $ 6,136.06 $ 16,000 80.000-62-00.5426 GRANTS $ $ $ $ $ $ $ $ - $ 500 80-000.62-00-5430 TOWEL RENTAL $ 523.12 $ $ $ $ 561.96 $ $ $ 225.13 $ 1,310.21 $ 1,500 80-000.62-00-5431 POOL REPAIR $ 189.50 $ 434.37 $ 95.00 $ 58.50 $ 1,988.31 $ 793.10 $ 380.00 $ 184.97 $ 4,123.75 $ 5,000 80-000-62-00-5432 LEASE PAYMENT $ 35,000.00 $ 18,000.00 $ 18,000.00 $ 18,000.00 $ 18,000.00 $ 18,000.00 $ 18,000.00 $ 18,000.00 $ 161,000.00 $ 216,000 15 of 18 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/1-14-11 ACTUAL Ef(p 0N$dS 8Y MONTN ACCOUNT NUMBER AND DESCRIFTION May-10 June-10 luly-10 Augmt 10 September-10 October-10 Hovtmber-10 December-10 Januarydl February-11 March-11 April-11 YEAR40-DATE- ANNUM - - - TOTALS -BUDOET 80-000-62-00-5433 LICENSES/PERMITS $ 200.00 $ 150.00 $ - $ - $ - $ - $ - $ 350.00 $ 700 80.000-62-00-5434 POOL SUPPLIES $ $ 1,107.00 $ $ $ $ $ 1,976.24 $ 3,083.24 $ 3,200 80-000-62-00-5435 ELECTRICITY $ $ 3,605.18 $ 4,110.90 $ 5,595.86 $ 5,334.79 $ 3,239.22 $ 3,065.76 $ 2,581.87 $ 27,533.58 $ 28,000 80-000-62-00-5437 TELEPHONE/INTERNET/CA $ $ 116.54 $ 315.45 $ 318.75 $ 398.35 $ 318.15 $ 317.60 $ 324.03 $ 2,108.87 $ 1,750 80.000.62-00-5438 CELLULAR PHONE $ $ 29.08 $ 32.17 $ 30.59 $ 33.58 $ 28.92 $ 28.28 $ 29.86 S 212.48 $ 600 80-000-62-00-5439 PROPERTY TAX $ 26,839.85 $ $ 26,839.85 $ $ $ $ $ 53,679.70 $ 53,000 80-000-62-00-5440 SECURITY $ m $ 60.00 $ $ $ 60.00 $ - $ $ 60.00 $ 180.00 $ 500 80-000-62-00-5603 PUBLISHING/ADVERTISIN $ 360.00 $ $ $ $ $ $ $ 360.00 $ 1,500 80.000-62-00-5605 BOOKS/PUBLICATION $ $ $ $ $ $ $ $ $ 50 80-000-64-00-5600 DUES $ $ $ $ S $ S $ - $ 200 80-000-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ $ - $ - 80-000-64.00-5605 TRAVEL EXPENSES $ $ $ $ $ $ $ $ - $ - 80.000-65-00-5802 OFFICE SUPPLIES $ $ M142 $ 456.22 $ $ $ $ 1,090.33 $ 2,600 80.000-65.00-5803 PROGRAM EXPENSES $ 746.96 $ 1,094.78 $ 1,727.69 $ 1,627.07 $ 1,584.99 $ 1,941.51 $ 1,839.67 $ 11,983.12 $ 17,000 80-000-65.00-5804 OPERATING SUPPLIES $ $ 84.00 $ 201.59 $ $ 399.00 $ 91.71 $ 819.09 $ 3,000 80-000-65-00-5805 RECREATION EQUIPMENT $ $ $ $ $ 60.00 $ $ 121.51 $ 6,000 80-000.65-00-5808 POSTAGE&SHIPPING $ $ $ $ $ $ $ $ 600 80-000-65-00-5812 GASOLINE $ $ $ $ $ $ $ $ $ 300 80-000-65-00-5826 MILEAGE $ $ $ $ $ - $ $ $ 200 80-000-65-00-5828 CONCESSIONS EXPENSES $ 214.08 $ 2,388.20 $ 909.66 $ 590.54 $ 941.84 $ 409.35 $ 442.84 $ 6,104.14 $ 6,000 80-000-65-00-5840 SCHOLARSHIPS $ $ . $ $ $ 371.00 $ $ 388.50 $ 400 80-000.65-00.5841 PROGRAM REFUNDS $ 468.00 $ 533.00 $ 617.00 $ 646.00 $ 1,253.00 $ 641.50 $ 354.00 $ 36.00 $ 4,548.50 $ 4,000 80.000-65-00-5842 MEMBERSHIP REFUNDS $ $ 103.00 $ 85.00 $ 149.00 $ 65.00 $ 58.00 $ 38.00 $ 498.00 $ 1,500 80-000-72-00-65001MRF $ 869.51 $ 713.97 $ 538.43 $ 1,262.46 $ 485.07 $ 1,417.17 $ 884.46 $ 863.58 $ 7,034.65 $ 10,000 80-000-72.00-6501 SOCIAL SECURITY $ 1,292.76 $ 1,117.75 $ 1,089.80 $ 1,832.52 $ 610.50 $ 2,063.76 $ 1,429.38 $ 1,397.83 $ 10,834.30 $ 17,658 80-000-7S-00-7002 COMPUTER EQUIP&SOFT $ $ 1,182.00 $ $ 1,998.00 $ $ $ $ 3,180.00 $ 3,200 80.000.75-00.7003 OFFICE EQUIPMENT $ $ $ $ $ $ $ - $ $ 300 80-000-75-00-7500 PHONE SYSTEM $ $ $ $ $ $ $ $ - $ 200 80-000-78-00-9002 NICOR $ $ 534.56 $ 615.79 $ 584.28 $ 581.20 $ 40.33 $ 667.20 $ 35.38 $ 3,058.74 $ 11,000 80-000-78-00.9010 MISC RETAIL $ $ $ $ $ $ $ $ $ 300 80-000-99-00-9979 TRANSFER TO PARKS&R $ $ $ $ $ $ $ S $ - TOTAL REC CWwMm JaIpENm $ ae fs�03 $ 47,osz 1s 7a 61oa9 7nMWr" 5 41,50].41 $ GUM" 9 s1,04s6 $ �8 0584$ $ S $ 9 $ 4114,142.65_ $ s�5 3os.oD TOTAL FUND 11Ef/ENlUE5 $ 43.862.775 $ 52,+iT3.32 $ 42,4b.DQ MAWS 4`9X3.00 $ 46,040.95 1$ _409,177,28 Age E78.Op $- - __ 3 $ 387,224.02 $ -_547,938.00 - TOTAL DIERI STS $ 8616 B $ SA4LV �$ 28110,29 $ x,97" $ 47,7Z1.59, $ SS 1867•* $ S�.56'-S---�'g�9.65 $ - $ - - $ _ $ -_ $ 466 917.63 $ 127 001 LIBRARY REVENUES 82-ODO-40.00-3992 LIBRARY BOND PROP.TA $ $ 46,202.10 $ 238,305.04 $ $ 61,763..69 $ 226,847.25 $ 15,972.38 $ 589,090.46 $ 605,924.00 82-000-40-00-3996 CARRY OVER-BOOK DEV $ $ $ $ $ $ $ $ - $ 82-000-40.00-3997 CARRY OVER-BLDG DEV $ $ $ $ $ $ $ - $ $ 310,958.00 82-000-40-00-3998 CARRY OVER-MEMORIAL $ $ $ $ $ $ $ - $ - $ - 82-000-40-00-3999 CARRY OVER-FUND BAL $ $ $ $ $ $ $ $ - $ 488,103.00 82-000-40-00-4000 REAL ESTATE TAXES $ $ 49,561.68 $ 255,633.39 $ $ 66,254.82 $ 243,342.45 $ 17,133.81 $ 31,174.58 $ 663,100.73 $ 650,000.00 82-000.40-00.4010 PERSONAL PROPERTY TAX $ 923.01 $ 646.74 $ 656.91 $ 86.26 $ $ 1,265.56 $ $ 1,020.86 $ 4,599.34 $ 5,000.00 82-000-42-00-4211 DEVELOPMENT FEES-BU $ 2,125.00 $ $ $ $ 2,525.00 $ $ 3,425.00 $ 8,075.00 $ 20,000.00 82-000-42-00.4215 DEVELOPMENT FEES-BO $ 2,125.00 $ $ $ $ 2,525.00 $ $ 3,425.00 $ 8,075.00 $ 20,000.00 82-000-42-00-4260 COPY FEES $ 251.50 $ 260.05 $ 300.20 $ 470.00 $ 231.35 $ 249.50 $ 214.10 $ 244.00 $ 2,220.70 $ 3,000.00 82-000-42-00-4261 LIBRARY SUBSCRIPTION $ 1,502.00 $ 1,204.00 $ 753.50 $ 1,050.00 $ 1,200.00 $ 1,071.00 $ 902.00 $ 350.00 $ 8,032.50 $ 15,000.00 82-000.42.00-4262 EXAM PROCTORING $ $ $ $ $ $ 5.00 $ - $ 5.00 $ 82-000-42.00-4286 DVD RENTAL INCOME $ $ $ $ $ 566.00 $ 530.00 $ 532.00 $ 447.00 $ 2,075.00 $ 82-000-42-00-4287 LIBRARY BLDG RENTAL $ 270.00 $ 90.00 $ 120.00 $ 120.00 $ 100.00 $ 80.00 $ 50.00 $ 830.00 $ 1,000.00 82-000-43-00-4330 LIBRARY FINES $ 1,052.96 $ 1,314.90 $ 1,068.48 $ 1,425.48 $ 1,163.29 $ 1,198.42 $ 1,134.48 $ 679.84 $ 9,037.85 $ 9,000.00 82-000.44-00.4412 INSURANCE REIMBURSEME $ $ $ $ $ $ $ $ - $ 82-000-44-00-4432 SALE OF BOOKS $ 114.00 $ 45.00 $ 42.65 $ 26.00 $ 21.10 $ 12.50 $ - $ 34.40 $ 295.65 $ 500.00 82-000-44-00-4450 MEMORIALS $ 90.00 $ 556.00 $ 20.00 $ 500.00 $ 25.00 $ 115.00 $ 405.00 $ 42.48 $ 1,753.48 $ 3,000.00 82.000-45-00-4550 GRANTS $ $ $ $ $ $ - $ $ - $ - 82-000-45.00-4560 LIBRARY PER CAPITA GR $ $ $ $ $ $ $ - $ 17,193.28 $ 17,193.28 $ 17,500.00 82-000-46-00-4600 INVESTMENT INCOME $ 117.54 $ 103.98 $ 138.27 $ 95.19 $ 30.12 $ 33.33 $ 47.25 $ 40.53 $ 606.21 $ 10,000.00 TOTAL LIBRARY REVENUES $ 8,571.01 $ 99,984.45 $ 497,038.44 I$ 3,772.93 $ 136,405.37 $ 474,750.01 $ 43,241.02 $ 51,226.97 $ - $ - $ $ $ 1,314,990.20 $ 2,158,985.00 LIBRARY EXPENSES 82-000-50-00-5107 SALARIES-LIBRAR�ASSIS $ 39,538.14 $ 37,589.76 $ 36,942.16 $ 57,504.02 $ 18,617.36 $ 58,980.12 $ 39,696.85 $ 39,126.52 $ 327,994.93 $ 650,000.00 82-000-50-00-5203 GROUP HEALTH INANC $ $ 7,034.94 $ 7,034.94 $ 7,034.94 $ 7,034.94 $ 7,034.94 $ 7,034.94 $ 7,034.94 $ 49,244.58 $ 70,000.00 82.000-50-00-5204 GROUP LIFE INSURE $ $ 103.35 $ 103.35 $ 103.35 $ 103.35 $ 103.35 $ 103.35 $ 103.35 $ 723.45 $ 2,000.00 82-000-50-00-5205 DENTAL&VISION $ - $ 513.27 $ 513.27 $ 513.27 $ 513.27 $ 513.27 $ 513.27 $ 513.27 $ 3,592.89 $ 6,000.00 82-000-61-00-5322 BONDING $ $ 1,839.00 $ $ 1,383.00 $ $ $ - $ 3,222.00 $ 5,000.00 16 of 18 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/1-14-11 --ACTUAL EXPENSES 8Y mOWm _ - - -- YEAR-10-DATE ', ANNUAL ACCOUNTNUMBERANODESCRIPTION M 10 lurte-10 July-10 Se P tember-10 Oeaber-10 NavNmheFl0 mm ber-10 Janua 11 February-12 March-11 Aprl TOTALS B 82-000-61-00-5323 ATTORNEY $ - $ - $ - $ 2,465.00 $ - $ - $ 540.00 $ 3,005.00 $ 10,000.00 82-000.62-00-5401 CONTRACT SERVICES $ $ 5,017.71 $ 1,377.89 $ 2,010.00 $ 1,024.28 $ 2,013.75 $ 1,501.78 $ 2,210.39 $ 15,155.80 $ 40,000.00 82-000-62-00-5407 MAINTENANCE-BLDG/JANI $ - $ 1,566.92 $ 949.92 $ 3,522.01 $ 651.21 $ 3,444.80 $ 875.00 $ 5,801.73 $ 16,811.59 $ 30,000.00 82-000-62-00-5410 MAINTENANCE-OFFICE EQ $ $ m $ $ 176.70 $ 183.97 $ $ 177.77 $ 950.73 $ 1,489.17 $ 20,000.00 82-000-62-00-5412 MAINTENANCE-PHOTOCOPI $ $ $ $ 543.77 $ 49.41 $ 124.76 $ 252.39 $ 36.97 $ 1,007.30 $ 15,000.00 82.000-62-00-5435 ELECTRICITY $ $ $ $ $ m $ $ $ $ - $ 8,000.00 82-000-62-00-5436 TELEPHONE $ $ 683.17 $ 693.42 $ 1,316.99 $ 688.81 $ 687.11 $ 866.12 $ 430.73 $ 5,366.35 $ 8,000.00 82-000.62-00.5437 NICOR GAS $ $ $ 471.80 $ 127.71 $ 129.08 $ 127.34 $ 631.44 $ 538.58 $ 2,025.95 $ 40,000.00 82.000-62-00-5438 DATABASE $ $ $ $ $ $ 2,898.42 $ $ 2,898.42 $ 15,000.00 82-000-64-00-5603 SUBSCRIPTIONS $ 798.00 $ 3,673.13 $ 432.00 $ 6.58 $ 512.98 $ $ 93.00 $ 230.22 $ 5,745.91 $ 15,000.00 82-000-64-00-5604 TRAINING&CONFERENCE $ - $ 330.39 $ 13.00 $ $ $ 226.71 $ 30.00 $ 300.00 1$ 900.10 $ 5,000.00 82-000-64-00-5607 PUBLIC RELATIONS $ $ $ $ $ $ m $ $ - $ 2,000.00 82-000-64-00-5616 EMPLOYEE RECOGNITION $ $ $ $ 43.00 $ 50.00 $ $ $ 93.00 $ 4,000.00 82-000-65-00-5800 CONTINGENCIES $ $ 403.98 $ 531.00 $ $ 377.85 $ 3,052.72 $ 862.07 $ 212.45 $ 5,440.07 1 144,561.00 82-000-65-00-5802 OFFICE SUPPLIES $ $ 822.46 $ 524.66 $ $ 803.84 $ 1,205.34 $ $ 3,356.30 $ 15,000.00 82-000-65-00-5806 LIBRARY SUPPLIES $ $ $ 216.10 $ 48.20 $ 170.58 $ 580.67 $ 1,314.29 $ 653.40 $ 2,983.24 $ 15,000.00 82-000-65-00-5807 CUSTODIAL SUPPLIES $ $ 850.52 $ 108.69 $ 1,135.87 $ 1,239.32 $ 318.21 $ 783.99 $ 800.20 $ 5,236.80 $ 20,000.00 82-000-65-00.5808 POSTAGE&SHIPPING $ $ 47.14 $ 4.89 $ 452.38 $ 45.28 $ 41.48 $ 24.83 $ 493.96 $ 1,109.96 $ 2,500.00 82-000-65-00-5810 PUBLISHING&ADVERTIS $ $ $ 130.00 $ $ $ $ $ 130.00 $ 2,000.00 82-000.65.00-5826 MILEAGE $ $ $ 59.90 $ m $ $ 76.93 $ 205.44 $ 10.59 $ 352.86 $ 1,000.00 82-000-65-00-5832 VIDEOS $ $ 813.87 $ 507.24 $ 317.87 $ 763.61 $ 767.81 $ 584.15 $ 949.59 $ 4,704.14 $ 25,000.00 82-000-65.00-5834 LIBRARY PROGRAMMING $ 325.00 $ 1,175.25 $ 879.16 $ 165.37 $ 682.91 $ 218.76 $ 571.70 $ 1,612.63 $ 5,630.78 $ 20,000.00 82-000-65-00-5835 LIBRARY BOARD EXPENSE $ $ $ $ m $ $ $ $ $ 2,000.00 82-000-65-00-5836 BOOKS-ADULT $ m $ 1,634.80 $ 2,831.89 $ 2,226.66 $ 2,972.97 $ 5,080.94 $ 4,037.53 $ 2,657.04 $ 21,441.83 $ 50,000.00 82-000-65-00-5837 BOOKS-JUVENILE $ m $ 3,808.55 $ 3,485.89 $ 3,616.94 $ 3,725.53 $ 2,064.68 $ 3,172.29 $ 8,899.32 $ 28,773.20 $ 50,000.00 82.000.65-00.5838 BOOKS-AUDIO $ $ 842.64 $ 220.93 $ 107.97 $ 1,252.65 $ 795.23 $ 326.92 $ 636.66 $ 4,183.00 $ 30,000.00 82-000-65-00-5839 BOOKS-REFERENCE $ $ $ 1,026.97 $ 1,695.50 $ 1,343.24 $ 1,008.55 $ 685.01 $ 1,450.38 $ 7,209.65 $ 35,000.00 82-000-65-00-5840 BOOKS-DEVELOPMENT FEE $ $ $ 3,597.35 $ 237.87 $ $ 2,554.33 $ $ 1,332.91 $ 7,722.46 $ 20,000.00 82-000.65-00-5841 MEMORIALS/GIFTS $ $ 752.41 $ $ m $ 317.33 $ m $ 346.24 $ 85.52 $ 1,501.50 $ 3,000.00 82-000-65-00-5842 BLDG-DEVELOPMENT FEES $ $ $ 3,450.00 $ $ 2,900.00 $ $ $ 215.86 $ 6,565.86 $ 20,000.00 82-000-65-00-5843 CD'S/MUSIC $ $ 71.95 $ 335.76 $ 126.91 $ 453.68 $ 137.94 $ 365.74 $ 1,491.98 $ 15,000.00 82-000-65-00-5844 MEETING ROOM $ $ $ - $ $ m $ $ 800.00 $ 800.00 $ 1,000.00 82-000-66-00-6012 20058 LIBRARY BOND $ $ 159,562.51 $ $ $ $ $ - $ 234,562.51 $ 394,125.02 $ 394,125.00 82-000-66-00-6014 2006 LIBRARY BOND $ $ 30,900.00 $ $ $ $ $ $ 180,900.00 $ 211,800.00 $ 211,800.00 82-000-72-00-65001MRF PARTICPANTS $ 1,640.00 $ 1,647.30 $ 1,647.30 $ 2,470.95 $ 823.65 $ 2,506.00 $ 1,691.12 $ 1,691.12 $ 14,117.44 $ 22,000.00 82-000-72-00-6501 SOCIAL SECURITY/MEDIC $ 2,974.12 $ 2,825.03 $ 2,775.50 $ 4,323.28 $ 1,398.95 $ 4,461.49 $ 2,986.34 $ 2,942.59 $ 24,687.30 $ 55,000.00 82-000-75-00-7002 COMPUTER EQUIPMENT& $ m $ $ 2,820.23 $ $ $ $ 719.50 $ 3,539.73 $ 20,000.00 82-000-75-00-7003 AUTOMATION $ $ 7.20 $ 7.20 $ 3,889.39 $ 869.20 $ 79.40 $ 3,231.59 $ 267.20 $ 8,351.18 $ 40,000.00 82-000-75-00-7703 BUILDING EXPANSION $ $ 6,199.55 $ $ $ $ m $ $ 6,199.55 $ - 82-000-78-00-9020 LIBRARY BOND PAYBACK $ $ $ m $ $ $ $ $ - $ TOTAL LIBRARY EXPENSES $ 45,275.26 $ 270,716.80 $ 73,692.41 $ 97,565.50 $ 49,699.25 $ 101,105.05 $ 75,024.66 $ 497,651.36 $ - $ $ - $ - $ 1,210,730.29 $ 2,158,986.00 TOTAL FUND Jt 575.1 $ 96 98f145 I W 44 S S, 88,405.97 $ 474,750,01 $ 4%241.02 $1,226.97 $ $ S 5 _ 5 1,U4.990.20 $ 2 159 9-83:00 FE7lAi F17N4 pFPENSFS $ 49 275 28 s 370,718 d0 $ 7169Z41 MOM 11$ 49 699 29 103 105 05 5 75,024.88 $ 497,d8L46 $ $_ 1$ $ 1,210,'730.29 $ 2,156 986A0 FUND SURPLUS 109RCMa$ 36 $ _170, 423.348.03 -$ 93,792.5 $ 88,706.12 $ 373,64498 1,783.84 $ 9 $ $ S 104,259.91 $ 1100 FOX INDUSTRIAL REVENUES 85.000-40-00-3999 BEGINNING FUND BALANC $ $ $ $ S $ $ 424,197.00 85-000-40-00-4090 TIF REVENUES $ $ 107,259.49 $ 24,291.75 $ 3,477.93 $ 83,114.33 $ 5,770.68 $ 4,432.29 $ 228,346.47 $ 216,677.00 85-000-46-00-4600 INVESTMENT INCOME $ 1.13 $ 1.40 $ 1.47 $ 1.65 $ 1.69 $ 1.74 $ 1.58 $ 1.47 $ 12.13 $ 50.00 85-000-49-00-4905 TRANSFER FROM MFT FUN $ $ m $ $ $ $ S $ - $ - FOXINDUSTRIALEXPENSES 85-000-66-00.6021 FOX IND BOND-PRINCIPA $ 4,966.25 $ $ $ $ m $ $ 70,000.00 $ 74,966.25 $ 79,933.00 85-000-66-00-6022 FOX IND BOND-INT PAYM $ $ $ $ $ $ $ 4,966.25 $ 4,966.25 $ 85-000-75-00-7901 FOX INDUSTRIAL-NON $ $ $ $ $ $ $ $ $ 85-000-75-00-7902 FOX INDUSTRIAL EXPENS $ $ $ $ $ $ $ - $ - $ - 85-000-78-00-9007 ADMINISTRATION FEES $ $ 116.25 $ 92.50 $ $ $ $ $ 208.75 $ 500.00 85-000-78-00-9010 RESERVE-FUTURE BOND P $ $ $ m $ $ $ $ $ - $ - 85-000-99-00-9901 TRANSFERS $ - $ - $ - $ - $ - $ - $ - _ _ $ - $ - TOTAL FUND REVENUES, $ 1.13 $ 107,260:89 $ 24,293.22 $ $A"." $ 83,118,02 $ 5,71242 $ 4,493.87 $ _ 3.47' S $ $_ S $ 220.95&60 $ 840,924.00 TOTALFUNDEXPEMSES $ 496825 $ 21825 $ 92,50 $ $ $ $ 74968.251 5_ S $ $ $ 5- _$0,141.25 _$ $0,433A0 FUN&SURPLUS (0.985• $ 107,144 84 $ Z4 200x77 3.47958 LOA" $ 5.77$42 $ 0.533 36 347 _- S $ $_ $ _148217.95 $ 560,493.00 POLICE PENSION REVENUES 86-000-46-00-4600 INTEREST INCOME is 3.22 1$ 1.141$ 1.39 $ 8.41 1$ 11.73 $ 12.60 1$ 11.75 1$ 6.84 1 $ 57.08 $ 86-000-46-00-4601 UNREALIZED GAIN/LOSS $ $ $ $ $ $ $ - $ $ 86-000-46-00-4602 DIVIDEND INCOME $ $ $ $ $ $ $ $ - $ 17 of 18 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/1-14-11 _ AC[W_AC_ MS_ESB_ItIIA6NfN - ACCOUNT NUMBER AND DESCRIPTION may-1 AuW-10 O � i F2hruary,1i Mach- 1 Aprill YEA�TO-DATE ANNUAL 9 en TOTALS I BUDGET 86-000-48-00-4805 EMPLOYER CONTRIBUTION $ $ $ $ $ $ $ $ $ - 86-000-48-00-4855 EMPLOYEE CONTRIBUTION $ 13,638.76 $ 13,722.23 $ 13,778.02 $ 13,702.83 $ 13,782.91 $ 20,324.65 $ 14,019.64 $ 14,386.53 $ 117,355.57 1$ - POLICE PENSION EXPENSES 86-000-50.00-5108 SALARIES-POLICE PENS[ $ 37,906.39 $ 22,329.02 $ 22,773.95 $ 22,773.95 $ 22,773.95 $ 22,773.95 $ 22,773.95 $ 22,773.95 $ 196,879.11 $ 86-000-50-00-5200 CONTRIBUTION REFUND $ $ $ $ $ $ $ $ $ 86-000.50-00.5220 POLICE PENSION REFUND $ $ $ $ $ $ $ $ $ - 86-000-81-00-8100 ADMINISTATIVE EXPENSE $ $ $ $ $ $ $ $ $ 86.000-81-00-8200 LEGAL EXPENSES $ $ $ $ $ $ $ $ $ - 86-000.81-00-8300 INVESTMENT FEES/MANAG $ $ $ $ $ $ $ $ $ - TOTALFUND REVENUES $ 13,641 98 $ tg,7t3.37 $ 13,779.41 $_ 23,11.24 13 79464 $ 2D 33l-2S $ _1d,03t.3N $ i4 348.37 $ $ -- - $ = $ 117,412:65 $ ---- - --- TgTAL FUNDEXPENSES $ 37,90693 $ 22329.02 $ 22,773.95 $ 22,77395_ 22,773 95 $ 2277195 $ 22,773 95__$ -22,779 95 $ $ $ $ FUNbSURPWS DEFt $ 2426441 4)1$ (91,062.71)1$ 8,874,$1 $ ,93530 $ 8:7'4256 $ 8.38058 $ $ $ $_ $ 79x66.46 COUNTRYSIDE TIF REVENUES 87-000-40-00-3999 BEGINNING FUND BALANC $ $ $ $ $ $ $ $ - $ 2,475,639.00 87-000-40-00-4090 TIF REVENUES $ $ 3,058.20 $ 127.42 $ $ 3,153.76 $ 31.86 $ 0.61 $ 6,371.85 $ 6,250.00 87-ODO-46-00-4600 INVESTMENT INCOME $ 498.76 1$ 499.01 $ 456.60 $ 394.26 $ 394.32 $ 407.53 $ 220.21 $ 220.27 1 $ 3,090.96 1$ 6,104.00 COUNTRYSIDE TIF EXPENSES 87-000-66.00.6002 COUNTRYSIDE T3BOND $ $ $ $ $ $ $ $ - $ - 87-000-66-00-6022 BOND-INT PAY8,546.25 $ $ $ $ $ $ 238,546.25 $ 307,092.50 $ 307,093.00 87-000-78-00-9007 ADMINISTRATIO $ 116.25 $ 92.50 $ $ $ $ $ 208.75 $ 1,000.00 87.000-78-00-9009 RESERVE $ $ $ $ $ $ $ - $ 87-000-78-00-9010 RESERVE-FUTU $ $ $ $ $ $ $ $ 2,179,900.00 TOTAL FUN98.76 3157.21 $ .OZ 984.26 3 8,548.08 -438.89 $ 220,82 $ 228.27! - $ $ $ $ -9,462,82. $ Z,487,993.00 TOTALWN8546,25 $ tt6.25 $ 9250 $ $ -_ $ $ 238546.75 $ $ $ S $ $ 307,301,25 $ 2,487,993.00' FUNDSURPLUS EH S 88047.49 $ 3,640.05 I$ 49152 1,$ 384.26 I S 3.64808 '$ 439.391$ 2.98,825,43 '$ 22027 1 3 $ -' $-- $ $_ (297,93&44)1 DOWNTOWN TIF REVENUES 86.000-40-00-3999 BEGINNING FUND BALANC $ $ $ $ $ $ $ $ - $ 136,663.00 88-000-40-00-4090 TIF REVENUES $ $ 40,820.24 $ 1,720.46 $ 1,758.58 $ 20,840.99 $ 4,567.75 $ 5,653.65 $ 75,361.67 $ 88,550.00 88-000-49-00-4901 TRANSFERS IN $ $ $ $ $ $ $ $ $ - DOWNTOWN TIF EXPENSES 88-000-62-00-5401 CONTRACTUAL SERVICES $ $ $ $ $ $ $ - W74 $ - 88-000-78-00-7101 IN TOWN ROAD PROGRAM $ $ $ $ $ $ $ $ - 88-000-78-00-9007 ADMINISTRATIVE FEES $ $ 116.25 $ $ $ 500.00 $ $ $ 46.25 $ 1,500.00 88-000-78-00-9010 RESERVE $ $ $ 194.25 $ $ $ $ $ - 88-000-99-00-9901 TRANSFER TO GENERALF $ $ $ $ $_ $ $ $ - ALFUND Ur4 $ 46 2d $ 1;710.46 1,758,98 $ 20 8M0 99 4567,75 $ 5653.65 $ $ $ S - 215 213.00ROTAL FUND EXPENSES $ $ 116.25 $ 184.25 $ $ Moo $ $ $ 46.25 $ $ $ S $ 1,600.00 FUND SURPLUS DE61 $ 40.703.99' $ 1526 21 $ 1,75858 $ 456733 9663.65 $ 144?5 S $ $ $ _- S 7523,713,00 18 of 18 0,D Co. Reviewed By: Agenda Item Number ai O Legal ❑ NB #3 1836 EST 1836 ❑ 1 . �_ Engineer ❑ Tracking Number Iii rl City Administrator ❑ Consultant ❑ �a ADM 2011-03 0 1< E ❑ C AgC11U[L 1tC111 �r7Uurna.ry Merno Title: Budget Cutting Ideas - Discussion Meeting and Date: Administration— 1/20/11 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Alderman Sutcliff Name Department Agenda Item Notes: For discussion purposes, a copy of Administrator Olson's memo to City Council dated December 21, 2010 is attached. This memo details several "thinking outside the box" ideas for generating revenue and cutting expenses. J� 0 Memorandum To: City Council EST. , 1836 From: Bart Olson, City Administrator `\ CC: CSC av Y Date: December 21, 2010 °�U-1y ®� Subject: Abatement ordinances and the budget <tE o�• These ordinances were last discussed at the December 14th City Council meeting. At that meeting, the City Council approved three abatement ordinances: one for the Countryside TIF bond, one for the Fox Industrial TIF bond, and the final one for 2005A Alt Revenue Sewer and Water Bond. There are five remaining abatement ordinances up for consideration. Two of these ordinances (now listed as "a" and"b" on this agenda) were considered part of the second group of ordinances last meeting; specifically, they were for bonds that were paid out of the sewer fund that the Council directed staff two meetings ago to revert to property taxes (i.e. voting against the abatement ordinance). Two of these ordinances (now listed as "c" and"d") were in the Rob Roy bonds group; specifically, they were bonds that were paid out of the sewer fund for the Rob Roy sewer project. The final ordinance was (now listed as "e") was for the in-town road program; specifically, the bond is paid out of the general fund and was a policy decision for the Council. I have spoken with Yorkville Bristol Sanitary District Director Kevin Collman, who has circulated the concept of a joint City-YBSD board meeting to his board members. His board members are available on Tuesday, January l It at 6pm. It maybe beneficial to postpone further discussion on the abatement ordinances and debt obligations until after that meeting. As a reminder, abatement ordinances do not have to be filed with the County until mid-February. To recap from the last meeting, and summarize the discussion laid out on the following pages of this report: - A vote in favor("aye") for the abatement ordinances on the agenda certifies to our bond holders and the County Clerk(who collects property taxes) that we have enough funds to make our debt payments in 2011. - A vote against("nay")the abatement ordinances, or if no action is taken means that we do not have enough funds to make our debt payments in 2011, and the property taxes associated with each bond will be levied. - The City does not currently have the funds to make the 2011 bond payments, which means either: • The abatement ordinances must be defeated, OR • A significant sewer bonding fee must be implemented, OR • Default on debt obligations, resulting in litigation, significant degradation of the City's bond rating, and property tax increases through court order, OR • Catastrophic cuts to City services - The staff recommendation is to vote "nay" on the remaining five abatement ordinances on the agenda, resulting in the 2011 bond payments reverting to property taxes in 2011 o Further, the staff recommendation is currently that item "e" on the agenda relating to the in- town road program bond be abated for this year only. (No action is needed until December 2011 to confirm or oppose this sub-recommendation) Water and Sewer debts—Agenda item A, Countryside Sewer, and Agenda Item B 2007A refunding These bonds fit within the recommendation by City Council during the discussion two meetings ago, where the City Council directed the staff to find as many sewer and water bonds as possible to discuss for non- abatement. Originally, there were three bonds within this first group. The bond that is no longer in this group was item "c" on the last City Council agenda, and the abatement ordinance was approved,meaning the City has certified that we have the money to make these bond payments. The remaining two bonds are alternate revenue bonds, paid out of the sewer fund. I recommend that the City Council vote "nay" or take no action on these bonds, which will revert the bonds to property taxes. Rnh Roy Sewer Debts—Agenda Item f 2005D Rnh Rny A"A Agenda Item " 2(1 Q Rnh D"IT These bonds were recommended by the City Council to revert to property taxes (non-abatement) during the discussion two meetings ago. Both are paid out of the sewer fund. Voting against the abatement ordinances or taking no action on the ordinances would result in a minimal sewer bonding fee but higher property taxes. For the reasons discussed during the previous City Council meetings, I recommend the City Council vote "nay" or take no action on these two ordinances and allow the bond payments to revert to property taxes. In-Town Road Program Debt—Agenda Item E 2005A In-town Road Program The City Council has not discussed this bond yet. While it appears that we will be able to make this bond payment out of the general fund next year(it was drawn into the FY 11-12 budget discussed by City Council last year), it provides us with an option to replenish a portion of our fund balance in one year, with little perceived impact from one-year-to-the next. It is my recommendation that the City Council vote "nay" or take no action on this ordinance and allow this bond payment to revert to property taxes. Consequences of actions In the recap of last meeting on the first page, the third bullet-point summarizes the consequences of different actions. The staff recommendation is to vote against each abatement ordinance on the agenda. The consequences of this action are: 1) That total property taxes paid by a property owner will increase in the range of 5-6% next year. 2) That property owners will be able to deduct this additional property tax from their gross income a. Rough estimates show that a property owner will be save about 25% of the figure listed above due to a lower adjusted gross income. (i.e. a$250k house that pays $300 will recoup about$70 to $80) 3) A sewer bonding fee in the amount of about$3.75 per month per user will need to be implemented to satisfy other sewer debt. The second action within that bullet-point is to vote for the abatement ordinances, and then enact a sewer bonding fee to satisfy the sewer debt obligations. The consequences of this action are: 1) The total property taxes paid by a property owner will not be affected. 2) A $31 per month per user sewer bonding fee will need to be implemented to satisfy sewer debts. The third action within that bullet-point is to vote for the abatement, enact no sewer bonding fee, and fail to make debt payments. This is the most catastrophic option, and should not be considered because property taxes will still increase, after litigation from our bond holders (at our cost), and further our credit rating will be ruined. The fourth and final action within that bullet-point is to make other cuts from the City budget to fund sewer debt. I strongly advise against this option, and I have previously explained this option as improper budgetary practice, and have illustrated the catastrophic impact it will have to City services in brief prior memos. If the abatement ordinances are approved (meaning no property taxes are collected for our debt obligations), no sewer bonding is enacted, and the City still attempts to make the debt payments, the following consequences will occur: 1) $2.4 million dollars in salaries or other expenses would have to be cut. This represents about % of our total general fund, wherein salaries are the majority expense. a. Previously, some Council members have alluded to an unwillingness to cut public safety or public works employees. In this scenario, every City employee in Admin, Finance, Community Relations, Engineering, Community Development, Building Safety, Streets, and Parks and Recreation could be cut and satisfy the debt obligations. Services related to building permits, subdivision planning, subdivision permitting,bill paying, human resources, payroll, general customer service,record keeping, park maintenance,park construction, and recreation management would be completely eliminated. With those services, that includes department heads being cut as well. Obviously, this scenario is unacceptable, as the City has both obligations under existing agreements and state law related to a variety of these services. Additionally, I think an easy argument can be made that residents expect these services to be provided. b. With this previous scenario being untenable, the other cutting option involves public safety, water, and sewer department employees. I expect this option to be ruled out by a majority of the City Council members, and I do not recommend it. However, to illustrate the level of impact on these departments, I submit the following figures. i. The total police department budget for salaries is just over$2.3 million. That includes every patrolman, sergeant, command staff, and police clerk. ii. The total water department budget for salaries is just over$350,000. iii. The total sewer department budget for salaries is just over$250,000. A final note—cutting elsewhere from the budget to fund existing sewer debt From time-to-time, I hear from people indirectly and directly, that we should be not funding non- essential services. The issue with that statement is the definition of"non-essential". When hearing this statement, typically the assumption is made that parks and recreation is a non-essential service, and that the City should get out of the Parks and Recreation business. I can say with reasonable certainty, yet without concrete evidence, that the majority of the community expects parks and recreation services to be provided—be it by us, or through a separate park district. The problem with this conversation is that should the City cut all Parks and Recreation services, and a group of residents petition to form a separate park district, that the Park districts net costs are likely to be higher than the current City services. This very brief analysis is predicated only upon the concept of duplication of support staff. A park district must hire or outsource human resource, finance, customer service, and other general support staff, and would have to pay for garbage services, insurance, and other incidental costs currently being paid for by the City. Additionally, the City will still have to retain employees that provide the same services, which results in a higher overall tax burden. Indeed, this same outcome was seen in the discussions on whether to form a library district. Thinkini4 outside (and inside) the box—options for generating revenue and cuttinIZ expenses The following is a list of items that should be discussed in February, March, and April during upcoming FY 11/12 budget discussions. Some of these options may allow us to approve abatement ordinances in December 2011 for debt obligations due in 2012, while others may allow us to fund operations or capital improvements in the next few years. I submit these to the City Council as evidence that the staff is thinking outside the box, and a commitment to dedicate our limited time to analyzing these options over the next few months, subject to Council preferences. Some of these may be controversial and unpalatable, but we must give the Council an opportunity to say"no". 1 1 Traditional ecnnom.c develop: :ent incentives a. Continue to offer developers TIF incentives, sales tax sharing incentives, recapture incentives, and other methods to attract businesses. Of note, waiving recapture costs on a sewer debt would be considered an incentive to a developer. 2) Digital billboards within City limits, and possibly on City property a. Attached is an editorial from a newspaper in Colorado Springs outlining their wish for more digital billboards within their boundaries. Digital billboards would generate revenue through the City through permit fees (if they are on private property) and through ground-lease fees if they are on City property. The City staff has had brief conversations with billboard company representatives, who have indicated a strong interest in a couple sites in the City, should the City Council indicate they are willing to consider them. 3) More cell towers on municipal property a. Cell service is only going to expand in the future, due to the increased demand for data used in smartphones. The Wheaton Woods cell tower lease on this agenda has a revenue stream of $35,000 per year. The visual impact of the cell tower, we feel, is minimized as the cell tower is in the form of a flag pole. 4) 6%telecommunications tax a. The maximum rate allowed by state statutes is 6%. We are currently at 5%. 5) Senior garbage subsidy a. Seniors pay$1 per billing cycle for garbage service that costs the City roughly$40 per billing cycle. Over the course of a year, that translates into a$120,000 subsidy. Previous discussions have revolved around implementing a subsidy for seniors who are experiencing financial hardship only. 6) Referendum for sales tax increase a. Previously discussed at City Council and in the newspapers by Mayor Burd. The City could authorize a 1% increase in the sales tax rate through a referendum. This referendum would have to be approved by the City Council, in the same manner as the bike path referendum was previously authorized. A preliminary estimate of the incremental sales tax, should the referendum be successful, is $2 million per year. Some of this tax would be paid by residents of other communities who shop in Yorkville. Also, this would put our sales tax rate higher than communities to the west of us,but on par with communities to the north and east of us. 7) Interns a. The cost effectiveness of interns is very high. Should we run into a scenario where the City Council does not feel the current service levels are acceptable, interns would provide the best option for getting work done at little cost. 8) Outsourcing with other municipalities and consultants a. I have spoken with staff members in other organizations that are interested in out-sourcing their staff on a limited basis to the City. Specifically, we have needs in the IT and GIS field. This follows a recommendation from the Metropolitan Mayors Caucus report on service consolidation, for which Mayor Burd sat on the committee. Of note, prior to layoffs we had outsourced our GIS staff to other communities, and those communities had paid use an hourly fee. 9) Vehicle stickers a. This was discussed by the Public Works committee briefly during the December meeting. One member of the committee was opposed to it, and the other two members were interested in seeing a brief City analysis of the service during the budget discussions. Vehicle stickers could be used as a way of equitably distributing the cost of a road maintenance program to those residents who use the roads most frequently (vehicle owners),but would have some administrative hurdles. 10)iPads v. paper a. A few years ago, the City discussed purchasing laptops for City Council members instead of printing packets. The laptops would have paid for themselves over the course of one or two years. iPads are starting to be used by boards in place of traditional laptops. Their main benefit is that they are cheaper than traditional laptop, and can be more user friendly. 11)Selling or leasing assets a. Land? While it is not a seller's market, the City does have a moderate amount of land used for non-park purposes. b. Buildings? Again, it is not a seller's market—but the City does have buildings that are currently being underutilized due to staff cuts. City Hall, on the administrative side is at 50% capacity. The old Post Office is currently being used for cold storage and Park Board meetings. The Riverfront Building concession-lease RFP is currently being reviewed by the Park Board, and is expected to generate about$10,000 per year in lease and concession fees. 12)Business registration a. Business licenses are available under state statutes. This could generate an amount multiplied by the number of individual businesses in the City(less than 750), and would result in the staff having an accurate, up-to-date database of contacts at every business in the City. We currently have an incomplete database via utility billing—as some strip malls have one meter for multiple units. 13)Selling other sponsorship opportunities a. Several weeks ago, the City of Naperville briefly brought up the concept of selling adspace on City buildings. The Village of Oswego has also discussed an offer from a local business to have their business name on a water tower. The City of Chicago has participated in a pothole filling program with Kentucky Fried Chicken, wherein KFC pays to have potholes filled in Chicago with a KFC stamp placed on the fill material. 14)More furloughs a. Non-union City staff are taking 5-days of furloughs this fiscal year. These could be increased, but would fail to impact almost half of the entire City staff(the other half are in unions). Increasing furlough days would impact City services due to the recent staff cuts, and would further hurt morale with employees who are not in unions. 15)Pay cuts a. The conversation applies to pay cuts as it does to implementing furloughs. When almost half of the City employees have a bargaining contract, the impacts are not equitable. The efforts to negotiate pay cuts or furloughs with unions would be partially offset through increased attorney's fees and other concessions the City would have to make. 16)Convince YBSD, if it has the money, to make payments on debt obligations a. This option would need to be discussed with YBSD, potentially at the joint City-YBSD meeting. They have informally said that almost all money they have within their budget and accounts are dedicated to project or specific purpose. 17)Structural change in budgeting a. In FY 10/11, there are still one-time revenues being used to fund ongoing operational costs. Mayor Burd had argued against this practice in the past and has mandated it be ended in FY 11/12. Continuing to use one-time revenues (building permits, development fees) in the general fund to pay for operational expenses would be irresponsible budgeting. In fact, the direction to change this practice in FY 11/12 was one driving force for the layoffs that occurred this month (namely, we are planning to set aside one-time revenues in FY 11/12 for capital purposes, instead of using them to pay salaries). 18)Enterprise opportunities a. The article about the potential solar power facility in Yorkville or Oswego is a good example. There are going to be many opportunities for the City to venture into enterprise opportunities in the near future, be it for a solar farm or a whitewater recreational facility event. CO. Reviewed By: Agenda Item Number Zo 0� Legal ■ OB #1 Finance El EST, �. 1836 Engineer ❑ -4 �,; City Administrator ■ Tracking Number Police ❑ K 11 C.m 0� CC 2010-108 �E f< `��. Human Resources ❑ Public Works ❑ City Council Agenda Item Summary Memo Title: Ordinance Amending City Code Regarding Citizen Comments City Council/Committee Agenda Date: Administration Committee—January 20, 2011 Synopsis: Council Action Previously Taken: Date of Action: CC 12/14/10 Action Taken: Tabled to January Administration Committee Item Number: Type of Vote Required: Majority Council Action Requested: Approval Submitted by: Bart Olson Administration Name Department Agenda Item Notes: Please see attached information. 0 Memorandum To: City Council EST. �, _ isas From: Bart Olson, City Administrator 0 CC: ® Date: January 7, 2011 LSE �`�c° Subject: Amendment to City Code regarding citizen comments at public f meetings Effective January 1, 2011, the Open Meetings Act will require that public comments at all public meetings be allowed. We will accomplish this at a base level by adding a"citizen comments" section at the beginning of every agenda posted by the City, and by informing every board, commission, and committee chairman about the new rules. Approving this ordinance and amending the City code will reinforce to the public that we follow the Open Meetings Act. In early conversations with Attorney Orr, both she and I felt that while public comments at committee meetings are important, that we give the committee members the ability to enforce time limits if they choose (it can be overridden by a 2/3 majority of those members present). Therefore, we have drafted the ordinance with that suggestion in mind as well as a time limitation for committee meetings. If the Council wishes to remove that section (since no time limits are in place at City Council), they may do so. Ordinance No. 2011- AN ORDINANCE AMENDING THE CODE OF ORDINANCES OF THE UNITED CITY OF YORKVILLE,KENDALL COUNTY,ILLINOIS PROVIDING FOR CITIZEN COMMENTS AT CITY MEETINGS WHEREAS, the United City of Yorkville (the "City") is a non home-rule municipality pursuant to the Constitution of the State of Illinois of 1970 and with such powers as granted to it by law; WHEREAS, the Open Meetings Act (5 ILCS 120/2.06, et seq.) (the "Act') provides that any person shall be afforded the opportunity to address elected officials under rules established by the public body. NOW THEREFORE, BE IT ORDAINED by the Mayor and City Council of the United City of Yorkville, Kendall County, Illinois, as follows: Section I. Title 1, Chapter 15 of the United City of Yorkville Code of Ordinances is hereby amended by adding the following: 1-15-3: Standards for Citizen Comments at Public Meetings 3. Standards for Citizen Comments at Public Meetings: At City Council meetings, individuals shall be allowed to comment during the citizen comment portion of the meeting for a length of time not to exceed five (5) minutes. At all other public meetings that are subject to the Open Meetings Act, individuals shall be allowed to make one(1) comment in an amount of time not to exceed two (2)minutes in length during the citizen comment portion of such meeting. At all public hearings, individuals shall be allowed to make comments as permitted by law. Comments from any member of the audience shall not be permitted at any time. The limits regarding number or length of comments may be waived or amended by a 2/3 vote of the members present. 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. 2011. CITY CLERK ROBYN SUTCLIFF DIANE TEELING GARY GOLINSKI ARDEN JOE PLOCHER WALTER WERDERICH MARTY MUNNS ROSE ANN SPEARS GEORGE GILSON, JR. Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this day of , A.D. 2011. MAYOR 2