The URL can be used to link to this page

Administration Packet 2011 02-17-11 o United City of Yorkville 800 Game Farm Road EST. '� 1836 Yorkville, Illinois 60560 -e. i Telephone: 630-553-4350 Fax: 630-553-7575 Cou* �? SCE AGENDA ADMINISTRATION COMMITTEE MEETING Thursday, February 17, 2011 6:00 p.m. City Hall Conference Room Citizen Comments: Minutes for Correction/Approval: January 20, 2011 New Business: 1. ADM 2011-04 Budget Report for January 2011 2. ADM 2011-05 Treasurer's Report for January 2011 3. ADM 2011-06 Annual Treasurer's Report for Fiscal Year 2009-2010 Old Business: 1. ADM 2011-03 Budget Cutting Ideas 2. ADM 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, February 17, 2011 6:00 PM City Hall Conference Room --------------------------------------------------------------------------------------------------------------------------------------- CITIZEN COMMENTS: --------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------- MINUTES FOR CORRECTION/APPROVAL: --------------------------------------------------------------------------------------------------------------------------------------- 1. January 20, 2011 ❑ Approved ❑ As presented ❑ With corrections --------------------------------------------------------------------------------------------------------------------------------------- NEW BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. ADM 2011-04 Budget Report for January 2011 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2011-05 Treasurer's Report for January 2011 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 3. ADM 2011-06 Annual Treasurer's Report for Fiscal Year 2009-2010 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- OLD BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. CC 2011-03 Budget Cutting Ideas ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 2. 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: --------------------------------------------------------------------------------------------------------------------------------------- c/Ty Reviewed By: Agenda Item Number 2 i o J a T Legal ❑ Minutes Finance ❑ EST. 1 1836 Engineer ❑ Tracking Number y City Administrator ❑ °^Y `O Public Works ❑ Ken Call County El`E Agenda Item Summary Memo Title: Minutes of the Administration Committee—January 20, 2011 Meeting and Date: Administration Committee 2/17/11 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Majority Council Action Requested: Committee Approval Submitted by: Minute Taker Name Department Agenda Item Notes: DRAFT UNITED CITY OF YORKVILLE ADMINISTRATION COMMITTEE Thursday, January 20, 2011 City Hall Conference Room COMMITTEE MEMBERS PRESENT: Alderman Robyn Sutcliff Alderman Diane Teeling Alderman Gary Golinski OTHER CITY OFFICIALS PRESENT: Mayor Valorie Burd City Finance Director Rob Frederickson Treasurer Bill Powell Chair Sutcliff called the meeting to order at 6:06pm Minutes for Correction/Approval: April 15, 2010 and November 18, 2010 There were two corrections to the minutes, one on page 4 and the other on page 1. The minutes were approved as corrected. New Business: 1. ADM 2011 - 01 Treasurer's Report for November& December 2010 Treasurer Powell noted the reports have been updated to reflect ending fund balances at the end of fiscal year 2010. The ending fund balance for the General Fund is negative $492,939, which is a decrease of$1,711,196 from the previous fiscal year. Additionally, the Auditors are now requiring that the City record sales and business tax rebates on the accrual, rather than cash basis, in order to be in compliance with Generally Accepted Accounting Principals (GAAP). Mayor Burd took the opportunity to inform the Committee that resulting from a conversation with the Auditors, she wanted to remind all Aldermen that any information regarding the audit, prior to the release of the official report, is strictly prohibited by state statute and the Illinois Municipal Handbook. The report is not released to the Council until after it has been received and reviewed by Staff and the Mayor. Finance Director Frederickson stated they would be receiving the report next week and plans to hold an audit discussion to review the Management Letter and the auditors report. The Treasurer's Report was recommended for the Consent Agenda. 1 Z ADM 2011 - 02 Budget Report for November and December 2010 The Committee briefly reviewed the report. Finance Director Frederickson noted that all the recommendations for clarifying funds have been accomplished. It his plan to meet the requirements for the CAFR(Comprehensive Annual Financial Report) in next years financial reporting. Alderman Golinski requested additional information regarding the additional revenue under Grants of$17,442.31. Director Frederickson stated he believed that was the Full Circle Grant for Community Development. Alderman Golinski also questioned the increase in Administrative Salaries. Director Frederickson stated he would confirm, but he believed that was due to severance payouts. The Committee approved the report. 3. ADM 2011 — 03 Budget Cutting Ideas Chair Sutcliff had requested this memo and felt there were some interesting ideas. She suggested that the Committee read it, as Administrator Olson was not here to discuss. Mayor Burd reiterated that the misconception that cutting the General Fund would aid in paying for the sewer fund still exists. That action would require eliminating most City services. Another issue regarding the debt of the City has to due with litigation expenses regarding de-annexation, the landfill, tickets appealed, as well as other issues. Although the attorneys are winning, the defendants are appealing and this creates additional costs. Chair Sutcliff requested that a breakdown of litigation costs be provided to the Council. Chair Sutcliff also encouraged the Alderman to think creatively for ideas to create revenue. The Committee agreed to move the item for discussion at the budget meeting. Old Business: 1. CC 2010-108 Ordinance Amending City Code Regarding Citizen Comments Effective January 1, 2011, the Open Meetings Act requires that public comments at all public meetings be allowed. This will be accomplished at the Committee level by adding "Citizen Comments"to the agenda. It appears that public comment will be limited but extended with a 2/3 vote of the committee. The Committee recommended this item for the Consent Agenda. Additional Business: Chair Sutcliff first, made the recommendation that the RFP for the building at Watershed Park be initiated. Secondly, she also presented at idea to work with other communities along the river to encourage use of the river for kayaking, tubing and ferrying. Finally, she requested confirmation that City Hall is utilized as a warming center. There being no further business, the meeting was adjourned at approximately 7:l Opm. Minutes Respectfully Submitted by: Kristia Leyendecker, Minute Taker 2 c/Ty Reviewed By: Agenda Item Number ii J� a 0-0 Legal ❑ NB #1 II Finance ■ EST. , 1836 Engineer ❑ Tracking Number y City Administrator ■ Consultant ❑ ADM 2011-04 Ke°aao c°°ry `� ❑ <LE Agenda Item Summary Memo Title: Budget Report for January 2011 Meeting and Date: Administration Committee 2/17/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: n O Memorandum � 19111g,L -AN To: Administration Committee EST. _ 1636 From: Bart Olson, City Administrator 4 �' CC: Date: February 11, 2011 ca 5e ;��Z Subject: FY 10/11 budget reports for January 2011 LE A note about the budget reports Now that the FY 09/10 audit is completed and bank account reconciliations are caught up, I will be pushing for a comprehensive clean-up of the budget reports. Specifically, accruals related to tax revenues and sales tax rebates (expenditures) will be posted to their correct month. For now,the budget report stays in the format with which we are familiar. General Fund Revenues 01-000-40-00-3997 Amusement Tax Year to date, we have only generated $107 in amusement tax. Our biggest generators are seasonal, so we do not expect this amount to pick up until May or June. The City staff is also working with Raging Waves to amend their annexation agreement to change the distribution of the admissions tax. 01-000-40-00-4020 State Income Tax The state had caught up with their income tax disbursements and were only 3 months late, and now they have regressed to be four months late. Additionally, the economy had taken a serious toll on state income taxes in FY 09/10, but we are seeing a slow increase in FY 10/11. Although the state recently imposed an income tax increase from 3%to 5%,the City will not see any of that increase. 01-000-40-00-4030 Municipal Sales Tax Sales tax continue to outperform expectations. The $217,000 figure posted as revenue in the January column was for consumer purchases in October 2010, and beat my estimates by $3,000. The February figures (consumer purchases in November 2010) beat my estimates by $17,000. Sales tax figures have beat my historical estimates for 6 months in a row, and 9 of the last 10 months. 01-000-40-00-4045 Auto Rental Tax The opening of Enterprise Rent-A-Car in Yorkville continues to lead to higher-than- expected auto rental tax figures. To date,they are roughly doubling the expected revenues. 01-000-40-00-4050 Hotel Tax The opening of the Hampton Inn has led to higher-than-expected hotel tax revenues in the FY. Page ] of 2 01-000-41-00-4110 Building;Permits Building permit figures have remained close to estimates, as far as the number of permits goes. Revenue lags slightly behind a straight monthly estimate because we assumed one moderate-size commercial permit at some point in FY 10/11. General Fund Expenses Various line-items Salaries The spike in December followed by the drop-off in January is caused by the severance of employees and a lower total payroll, respectively. 01-110-64-00-5600 Dues The City's membership in the Chamber of Commerce came due in January. 01-120-78-00-9003 Sales Tax Rebate As noted in the discussion on sales tax revenues above, the sales tax rebate accruals will be fixed in the budget reports in the next month or two. Even though the timing of the payments are not currently accurate, we can see an illustration of the underestimation of the total sales tax rebates, as we are currently over budget with 3 months of sales taxes outstanding. 01-220-62-00-5432 Economic Development The City's membership in the Yorkville Economic Development Corporation came due in January. MFT 15-000-65-00-5818 Salt The first large purchases of salt came up in December and January. We have a few more invoices due in February and March, and are currently on pace for salt usage this year. We have 300 tons of salt remaining in our current stock, and 400 available to order. In total, we have seven more snow events budgeted this year. REC Center 80-000-42-00-4200 Membership Fees The January membership revenues are the best monthly revenue total ever for the REC Center. We ran successful promotions in January, and had a few dozen new memberships. Some of this figure is result of members paying an entire year's membership fee up front. Page 2 of 2 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUNC DATE OF REPORT/02-09-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-30 June-30 July-10 August-10 September-10 October-10 November-10 December-SO January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 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 $ 19,869.35 $ 172,744.94 $ 168,318.00 O1-000-40-00-3994 ADMISSIONS TAX $ $ $ $ $ $ 181,744.45 $ $ $ $ 181,744.45 $ 112,964.00 01-000-40-00-3997 AMUSEMENTTAX $ $ $ $ $ $ $ 44.10 $ $ 63.72 $ 107.82 $ 162,964.00 O1-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 O1-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 $ 1,578.73 $ 12,672.78 $ 20,000.00 03-000-40-00-4020 STATE INCOME TAX $ $ 124,314.46 $ 213,276.29 $ 127,184.73 $ 255,134.45 $ $ $ 124,700.22 $ 165,595.18 $ 1,010,205.33 $ 1,300,000.00 O1-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 $ 217,052.07 $ 1,944,462.46 $ 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 $ 24,403.61 $ 164,895.73 $ 237,063.00 O1-000-40-00-4040 MUNICIPAL UTILITY TAX $ $ 133,343.15 $ $ $ 143,841.18 $ $ $ $ 179,508.90 $ 456,693.23 $ 565,000.00 01-000-40-00-4041 UTILITY TAX-NICOR $ $ 117,229.18 $ $ $ 32,221.63 $ $ $ 28,087.50 $ 33,387.39 $ 210,925.70 $ 396,000.00 O1-000-40-00-4042 UTILITY TAX-CABLE 1 $ 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-TELEPHC $ 42,820.41 $ 48,994.12 $ 42,325.81 $ 43,671.29 $ 45,259.93 $ 45,330.47 $ 34,022.66 $ 45,371.84 $ 45,561.90 $ 393,358.43 $ 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 $ 21,515.17 $ 203,116.43 $ 150,000.00 03-000-40-00-4045 AUTO RENTAL TAX $ 538.25 $ 613.04 $ 578.60 $ 528.60 $ 699.63 $ 715.37 $ 791.14 $ 691.76 $ 623.86 $ 5,780.25 $ 3,421.00 O1-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 $ 2,582.52 $ 26,952.27 $ 20,000.00 03-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 O1-000-41-00-4101 OTHER LICENSES $ 50.00 $ 368.50 $ $ 234.25 $ 134.25 $ 414.25 $ $ 224.25 $ $ 1,425.50 $ 4,500.00 01-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 $ 2,252.50 $ 104,251.20 $ 205,000.00 01-000-42-00-4205 FILING FEES $ $ $ $ $ $ $ $ $ $ $ 3,000.00 O1-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 $ 3,071.43 $ 785,005.63 $ 1,050,000.00 O1-000-42-00-4207 ZONING VARIANCE FEES $ $ $ $ $ $ $ $ $ $ $ 170.00 O1-000-42-00-4208 COLLECTION FEE-YBSC $ $ $ $ $ $ $ $ $ $ $ 121,503.00 O1-000-42-00-4210 DEVELOPMENT FEE' $ 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 $ $ 500.00 $ 2,500.00 $ 12,000.00 O1-000-42-00-4286 BEECHER RENTAL' $ 45.00 $ 320.00 $ 170.00 $ 55.00 $ 210.00 $ 175.00 $ $ 110.00 $ 115.00 $ 1,200.00 $ 2,000.00 01-000-42-00-4287 DEVELOPER SIGN REIMBU $ $ $ $ $ $ $ $ $ $ $ 5,000.00 O1-000-42-00-4288 MOWING INCOME $ $ $ 46.36 $ 298.13 $ 127.09 $ 107.11 $ 486.54 $ $ $ 1,065.23 $ O1-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 $ 7,826.33 $ 68,752.90 $ 151,275.00 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 $ 2,813.00 $ 19,854.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 $ 9,000.00 $ 65,400.00 $ 181,275.00 O1-000-44-00-4401 DARE DONATIONS $ $ $ $ $ $ $ $ 25.00 $ $ 25.00 $ 20.00 03-000-44-00-4404 HANGING BASKET DONATI $ 50.00 $ $ $ $ $ $ $ $ 600.00 $ 650.00 $ 2,000.00 O1-000-44-00-4407 HOLIDAY UNDER THE STP $ 900.00 $ 1,025.00 $ 350.00 $ 1,110.00 $ 485.00 $ 2,735.00 $ 2,136.00 $ $ $ 8,741.00 $ 9,585.00 01-000-44-00-4411 REIMBURSEMENTS-POLICE $ 160.00 $ 295.00 $ 265.60 $ 270.00 $ 230.35 $ 245.35 $ 220.35 $ 21,797.21 $ 1,690.45 $ 25,174.31 $ 3,300.00 01-000-44-00-4412 INSURANCE REIMBURSEME $ $ $ $ $ $ $ $ $ $ $ O1-000-44-00-4413 PLAN REVIEW INCOME $ $ $ $ $ $ $ $ $ $ $ O1-000-44-00-4415 REIMB FOR LEGAL EXPEN $ $ $ $ $ $ $ $ 33,144.76 $ 3,985.61 $ 37,130.37 $ 150,000.00 O1-000-44-00-4416 REIMB FOR THE LIBRARY $ $ $ $ $ $ $ $ $ $ $ 40,582.00 O1-000-44-00-4417 MI5.REIMBURSEMENTS $ $ $ $ $ $ $ 5,800.44 $ 257.92 $ 22.20 $ 6,080.56 O1-000-44-00-4418 REIMB-STREET OP! $ $ $ $ $ $ $ $ 2,895.21 $ $ 2,895.21 O1-000-44-00-4490 MISCELLANEOUS INCOME $ 1,705.62 $ $ 9.00 $ 67.00 $ 114.00 $ 950.00 $ (3.74) $ 29.56 $ 185.18 $ 3,056.62 $ 1,000.00 01-000-44-00-4495 HAUNTED HOUSE n/a n/a n/a n/a n/a $ $ $ $ $ $ O1-000-44-00-4499 BAD DEBT RECOVERI $ 2,718.75 $ $ $ $ $ $ $ $ $ 2,718.75 $ O1-000-45-00-4504 TRAFFIC SIGNAL REVENU $ $ 19,191.11 $ $ $ $ $ $ $ 13,826.00 $ 33,017.11 $ 14,925.00 O1-000-45-00-4505 COPS GRANT-VESTS $ $ $ $ $ 912.50 $ $ $ $ $ 912.50 $ 03-000-45-00-4506 MISC INTEGOVERNMENTAI $ $ $ $ $ 657.50 $ $ $ 2,195.50 $ $ 2,853.00 $ O1-000-45-00-4510 CABLE CONSORTIUM FEES $ $ $ O1-000-45-00-4511 POLICE-STATE TOBACCC $ $ $ $ $ 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 $ O1-000-46-00-4600 INVESTMENT INCOME $ 64.13 $ 155.78 $ 349.36 $ 210.63 $ 184.61 $ 335.08 $ 100.42 $ 92.83 $ 50.85 $ 1,543.69 $ 3,000.00 O1-000-49-00-4902 REPAY OF PARK&REEL $ $ $ $ $ $ $ $ $ $ $ 100,000.00 O1-000-49-00-4915 TRANSFER FROM WATER C $ $ $ 22,965.75 $ $ $ 22,965.75 $ $ $ 22,965.75 $ 68,897.25 $ 91,863.00 03-000-49-00-4920 TRANSFER FROM SEWER N $ $ $ 20,761.25 $ $ $ 20,761.25 $ $ $ 20,761.25 $ 62,283.75 $ 83,045.00 O1-000-49-00-4935 TRANSFER FROM LAND CP $ $ $ 15,112.25 $ $ $ 15,112.25 $ $ $ 15,112.25 $ 45,336.75 $ 60,449.00 GENERAL FUND-TOTAL REVENUES $ 378,325.58 $ 2,231,237.70 $ 719,672.63 $ 932,189.60 $ 1,826,732.53 $ 884,381.21 $ 458,349.99 $ 796,985.59 $ 816,520.20 $ $ $ $ 9,044,395.03 $ 11,433,025.00 GENERAL FUND-ADMIN EXPENSES O1-110-50-00-5100 SALARIES-MAYOF $ 860.00 $ 825.00 $ 825.00 $ 825.00 $ 860.00 $ 825.00 $ 825.00 $ 725.00 $ 825.00 $ 7,395.00 $ 11,310.00 O1-110-50-00-5101 SALARIES-CITY CLERk $ 741.67 $ 741.67 $ 741.67 $ 741.67 $ 776.67 $ 741.67 $ 641.67 $ 400.00 $ 741.67 $ 6,268.36 $ 8,980.00 O1-110-50-00-5102 SALARIES-CITY TREASL $ 535.00 $ 500.00 $ 400.00 $ 400.00 $ 300.00 $ 500.00 $ 500.00 $ 500.00 $ 400.00 $ 4,035.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 $ 3,900.00 $ 35,855.00 $ 50,320.00 O1-110-50-00-5104 SALARIES-LIQUOR COMM $ 83.33 $ 83.33 $ 83.33 $ 83.33 $ 83.33 $ 83.33 $ 83.33 $ 83.33 $ 83.33 $ 749.97 $ 1,000.00 01-110-50-00-5106 SALARIES-ADMINISTRAI $ 15,935.65 $ 15,789.56 $ 16,697.57 $ 29,607.94 $ 9,850.38 $ 29,334.34 $ 20,406.29 $ 40,470.88 $ 14,272.58 $ 192,365.19 $ 202,242.00 O1-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 $ $ 18,564.45 $ 47,166.61 $ 65,000.00 O1-110-61-00-5301 LEGISLATIVE ATTORNEY $ $ $ $ $ $ $ $ $ $ $ 1of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUNC DATE OF REPORT/02-09-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-30 July-30 August-10 September-10 October-10 November-10 December-30 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 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 $ 21,726.88 $ 77,704.54 $ 130,000.00 01-110-61-00-5303 LITIGATION COUNCIL $ $ $ 16,358.59 $ 16,199.68 $ 1,472.85 $ 6,615.25 $ 5,464.60 $ 7,558.92 $ 4,308.19 $ 57,978.08 $ 90,000.00 01-110-61-00-5311 CODIFICATION $ $ $ $ $ $ $ $ $ 500.00 $ 500.00 $ 8,000.00 O1-110-61-00-5314 BUILDING INSPECTIONS $ $ 1,665.00 $ 3,270.00 $ $ (3,675.00) $ $ $ $ $ 1,260.00 $ O1-110-62-00-5401 CONTRACTUAL SERVICES $ 736.00 $ 192.50 $ 464.85 $ 472.96 $ 324.00 $ 309.28 $ 201.15 $ 160.00 $ 375.00 $ 3,235.74 $ 8,000.00 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 $ $ 1,196.00 $ 8,340.00 $ 14,400.00 O1-110-62-00-5410 MAINTENANCE-OFFICE $ $ $ $ $ $ $ $ $ $ $ 100.00 01-110-62-00-5421 WEARING APPAREL $ $ $ $ $ $ $ $ $ $ $ O1-110-62-00-5436 TELEPHONE $ $ 1.48 $ 987.33 $ 991.16 $ 993.12 $ 996.87 $ 1,005.43 $ 994.78 $ 986.51 $ 6,956.68 $ 20,000.00 O1-110-62-00-5438 CELLULAR TELEPHONE $ $ 119.08 $ 122.17 $ 120.59 $ 123.58 $ 90.00 $ 90.00 $ 90.00 $ 90.00 $ 845.42 $ 1,200.00 O1-110-62-00-5439 TELEPHONE SYSTEMS MA', $ $ $ 1,472.40 $ $ $ $ $ $ $ 1,472.40 $ 3,000.00 01-110-64-00-5600 DUES $ 5,885.00 $ 1,035.50 $ $ 462.14 $ $ $ 1,650.00 $ $ 2,500.00 $ 11,532.64 $ 12,450.00 01-110-64-00-5601 ILLINOIS MUNICIPAL LE $ $ $ $ $ $ $ 1,179.00 $ $ $ 1,179.00 $ 1,200.00 O1-110-64-00-5603 SUBSCRIPTIONS $ $ $ $ $ $ $ $ $ 100.00 $ 100.00 $ 100.00 O1-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 O1-110-64-00-5607 PUBLIC RELATIONS $ $ $ $ $ 54.90 $ $ $ $ $ 54.90 $ 150.00 O1-110-64-00-5611 KENDALL COUNTY PARATP $ 4,945.75 $ $ $ $ $ $ 10,832.00 $ $ $ 15,777.75 $ 30,000.00 03-110-64-00-5612 SENIOR SERVICE FUNDIN $ $ $ $ $ $ $ $ $ $ $ 5,000.00 O1-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 $ 173.24 $ 3,982.83 $ 8,000.00 O1-110-65-00-5804 OPERATING SUPPLIES $ 29.00 $ 525.09 $ 887.48 $ 616.02 $ 459.24 $ 171.68 $ 625.21 $ 207.67 $ 562.54 $ 4,083.93 $ 7,000.00 O1-110-65-00-5808 POSTAGE&SHIPPING $ (5.18) $ 168.33 $ 118.92 $ 3,993.45 $ 106.92 $ 60.89 $ 856.24 $ 435.22 $ 143.95 $ 5,878.74 $ 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 $ 298.49 $ 5,524.27 $ 6,750.00 O1-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 $ 1,694.15 $ 20,602.43 $ 27,153.00 O1-110-72-00-6501 SOCIAL SECURITY&MEC $ 1,548.27 $ 1,512.98 $ 1,566.23 $ 2,501.76 $ 1,102.64 $ 2,510.24 $ 1,861.10 $ 3,372.37 $ 1,395.46 $ 17,371.05 $ 26,463.00 O1-110-75-00-7002 COMPUTER EQUIP&SOFT $ $ 709.98 $ $ 1,233.75 $ $ $ $ $ $ 1,943.73 $ 850.00 01-110-75-00-7003 OFFICE EQUIPMENT $ $ $ 608.15 $ $ $ $ $ $ $ 608.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 $ 1,967.69 $ 10,104.32 $ 31,000.00 01-110-78-00-9004 MISCELLANEOUS $ $ $ $ $ $ $ $ $ $ $ O1-110-78-00-9013 HOLIDAY UNDER THE STA $ $ $ $ $ $ 300.00 $ 4,223.25 $ 919.11 $ $ 5,442.36 $ O1-110-99-00-9970 TRANSFER TO CW CAPITA $ $ $ 31,250.00 $ $ $ 31,250.00 $ $ $ 31,250.00 $ 93,750.00 $ 125,000.00 O1-110-99-00-9975 TRANSFER TO CW CAPITA $ $ $ 9,375.00 $ $ $ 9,375.00 $ $ $ 9,375.00 $ 28,125.00 $ 37,500.00 TOTAL ADMIN EXPENSES $ 37,383.79 $ 37,240.06 $ 125,723.19 $ 82,498.03 $ 57,221.10 $ 102,169.98 $ 80,785.31 $ 94,383.51 $ 117,430.13 $ $ $ $ 734,835.10 $ 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 $ 12,812.26 $ 158,518.38 $ 259,690.00 03-120-SO-00-5202 BENEFITS-UNEMPLOY.C $ 9,108.84 $ $ 13,663.25 $ $ $ 13,663.25 $ $ $ $ 36,435.34 $ 38,000.00 O1-120-50-00-5203 BENEFITS-HEALTH INSL $ 284,297.20 $ 75,984.28 $ 155,709.99 $ (895.84) $ 86,963.34 $ (958.53) $ 164,870.46 $ 108,071.80 $ 114,588.32 $ 988,631.02 $ 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 $ 1,540.13 $ 15,377.52 $ 28,240.00 O1-120-50-00-5205 BENEFITS-DENTAL/VI'- $ 15,124.32 $ 8,139.52 $ 14,551.15 $ 459.05 $ 8,427.62 $ 390.66 $ 15,501.18 $ 6,977.50 $ 7,463.13 $ 77,034.13 $ 100,880.00 O1-120-61-00-5304 AUDIT FEES&EXPENSES $ $ $ $ $ $ $ 1,500.00 $ 1,500.00 $ 20,000.00 $ 23,000.00 $ 57,700.00 O1-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 $ 83,173.75 $ 274,528.75 $ 344,129.00 O1-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 $ 374.50 $ 9,607.50 $ 28,000.00 03-120-62-00-5410 MAINTENANCE-OFFICE E $ $ $ 838.00 $ $ $ $ $ $ $ 838.00 $ 1,800.00 O1-120-62-00-5411 MAINTENANCE-COMPUTEF $ $ $ $ $ $ $ $ $ $ $ 500.00 03-120-62-00-5412 MAINTENANCE-PHOTOCOF $ $ 1,572.00 $ 1,572.00 $ 1,572.00 $ 2,308.00 $ 1,572.00 $ 836.00 $ 2,308.00 $ 1,572.00 $ 13,312.00 $ 27,000.00 01-120-62-00-5437 ACCTG SYSTEM SERVICE $ $ $ $ $ $ $ $ $ $ $ 15,000.00 O1-120-62-00-5438 CELLULAR TELEPHONE $ $ 58.16 $ 64.34 $ 61.19 $ 67.16 $ 28.92 $ 28.28 $ 74.86 $ 70.02 $ 452.93 $ 1,010.00 O1-120-64-00-5600 DUES $ 120.00 $ $ $ 35.00 $ $ $ $ 170.00 $ 195.00 $ 520.00 $ 1,600.00 01-120-64-00-5603 SUBSCRIPTIONS/BOOKS $ $ $ $ $ $ $ $ $ 97.87 $ 97.87 $ 250.00 O1-120-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ $ $ $ $ O1-120-64-00-5605 TRAVEL/MEALS/LODGIN $ $ $ $ $ $ $ $ $ $ $ O1-120-65-00-5802 OFFICE SUPPLIES $ $ 224.09 $ 38.01 $ $ 53.80 $ $ $ 96.61 $ $ 412.51 $ 2,000.00 03-120-65-00-5804 OPERATING SUPPLIES $ 100.10 $ $ $ 158.85 $ 100.10 $ 157.22 $ $ $ 136.45 $ 652.72 $ 3,500.00 O1-120-65-00-5808 POSTAGE&SHIPPING $ $ $ 94.25 $ 18.73 $ 29.90 $ 61.49 $ $ $ 33.60 $ 237.97 $ 2,500.00 O1-120-65-00-5809 PRINTING&COPYING $ $ $ $ $ $ $ $ $ $ $ 1,000.00 O1-120-65-00-5844 MARKETING-HOTEL TAM $ $ $ 1,258.49 $ 2,665.74 $ 3,653.47 $ 4,992.99 $ 2,688.53 $ 3,902.98 $ 2,439.70 $ 21,601.90 $ 20,000.00 01-120-72-00-65001MRF PARTICIPANTS $ 1,644.82 $ 1,644.82 $ 2,139.78 $ 1,477.60 $ 492.72 $ 2,034.05 $ 1,571.28 $ 2,320.82 $ 1,242.21 $ 14,568.10 $ 25,190.00 O1-120-72-00-6501 SOCIAL SECURITY&MEC $ 1,335.38 $ 1,354.33 $ 1,772.15 $ 1,238.55 $ 400.38 $ 1,694.60 $ 1,310.56 $ 1,935.46 $ 979.59 $ 12,021.00 $ 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,535.77 $ 3,475.70 $ 5,000.00 O1-120-75-00-7003 OFFICE EQUIPMENT $ $ $ $ $ $ $ $ $ $ $ 250.00 O1-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 $ $ $ $ 203,211.34 $ 623,554.36 $ 620,000.00 O1-120-78-00-9004 BUSINESS DISTRICT REE $ $ 18,606.77 $ 47,247.67 $ 22,943.42 $ $ 46,866.59 $ $ 45,936.81 $ 21,515.17 $ 203,116.43 $ 150,000.00 O1-120-78-00-9013 AMUSEMNT TAX REBATE $ $ $ $ $ $ 99,959.44 $ $ $ $ 99,959.44 $ 63,000.00 01-120-78-00-9099 BAD DEBT $ $ $ $ $ $ $ $ $ $ $ 2of14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUNC DATE OF REPORT/02-09-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-30 July-30 August-10 September-30 October-10 November-10 December-30 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 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 $ 79,324.16 $ 713,917.44 $ 951,890.00 01-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 O1-120-99-00-9965 TRANSFER TO DEBT SEM $ $ $ 107,351.00 $ $ $ 107,351.00 $ $ $ 107,351.00 $ 322,053.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 $ 659,655.97 $ $ $ $ 3,716,352.35 $ 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 $ 3,750.00 $ 46,250.00 $ 63,750.00 O1-130-62-00-5401 CONTRACTUAL SERVICES $ $ 308.00 $ 583.00 $ 111.00 $ 496.00 $ 111.00 $ 250.00 $ 518.00 $ 250.00 $ 2,627.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 $ 25.02 $ 237.50 $ 540.00 O1-130-64-00-5603 SUBSCRIPTIONS&BOOKS $ $ $ $ $ $ $ $ $ $ $ 100.00 O1-130-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ $ $ $ $ O1-130-64-00-5605 TRAVEL/MEALS/LODGING $ $ $ $ $ $ $ $ $ $ $ 01-130-64-00-5607 PUBLIC RELATIONS $ $ 19.27 $ $ $ $ $ $ $ $ 19.27 $ 1,750.00 O1-130-65-00-5802 OFFICE SUPPLIES $ $ $ $ 27.98 $ $ 56.00 $ $ $ $ 83.98 $ 750.00 03-130-65-00-5808 POSTAGE&SHIPPING $ $ $ 440.00 $ $ $ $ 440.00 $ $ $ 880.00 $ 3,500.00 01-130-65-00-5809 PRINTING&COPYING $ $ $ $ $ $ $ $ $ $ $ 1,000.00 01-130-65-00-5810 PUBLISHING&ADVERTIS $ $ $ $ 1,987.56 $ $ $ $ 2,000.66 $ $ 3,988.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 $ 237.75 $ 4,118.00 $ 6,184.00 03-130-72-00-6501 SOCIAL SECURITY&MEC $ 294.30 $ 294.30 $ 294.30 $ 441.45 $ 147.15 $ 447.30 $ 294.30 $ 294.30 $ 229.50 $ 2,736.90 $ 4,877.00 O1-130-78-00-9010 COMMUNITY EVENTS $ (665.00) $ (425.00) $ 217.98 $ $ 111.44 $ $ $ $ 250.00 $ (510.58) $ 6,000.00 01-130-78-00-9013 HOLIDAY UNDER THE STP $ $ 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 $ 4,742.27 $ $ $ $ 64,108.54 $ 110,336.00 GENERAL FUND-ENGINEERING EXPENSES O1-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 $ 12,395.48 $ 196,992.60 $ 263,233.00 O1-150-50-00-5137 SALARIES-OVERTIME $ $ $ $ 86.59 $ $ $ $ $ $ 86.59 $ 500.00 O1-150-62-00-5401 CONTRACTUAL SERVICES $ $ 427.00 $ 593.99 $ $ $ 150.00 $ 45.00 $ 808.50 $ 464.00 $ 2,488.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 $ $ 33.95 $ 1,302.82 $ 1,500.00 O1-150-62-00-5410 MAINTENANCE-OFFICE EC $ $ $ $ $ $ $ $ $ $ $ 500.00 03-150-62-00-5411 MAINTENANCE-COMPUTER-' $ $ $ $ $ $ $ $ $ $ $ 500.00 O1-150-62-00-5421 WEARING APPAREL $ $ $ $ $ $ $ $ $ $ $ 100.00 03-150-62-00-5438 CELLULAR TELEPHONE $ $ 116.32 $ 128.68 $ 122.37 $ 134.31 $ 115.69 $ 113.13 $ 119.43 $ 100.09 $ 950.02 $ 3,000.00 01-150-64-00-5600 DUES $ $ $ $ $ $ 240.00 $ $ $ $ 240.00 $ 1,000.00 O1-150-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ $ $ $ $ 01-150-64-00-5605 TRAVEL EXPENSE $ $ $ $ $ $ $ $ $ $ $ 01-150-64-00-5608 TUITION REIMBURSEMENI $ $ $ $ $ $ $ $ $ $ $ O1-150-64-00-5616 BOOKS&PUBLICATIONS $ $ $ $ $ $ $ $ 126.00 $ $ 126.00 $ 130.00 O1-150-65-00-5801 ENGINEERING SUPPLIES $ $ 17.21 $ $ 267.87 $ 18.99 $ 71.12 $ 238.32 $ 94.39 $ $ 707.90 $ 2,000.00 O1-150-65-00-5802 OFFICE SUPPLIES $ 3.15 $ 36.08 $ 57.62 $ $ 86.47 $ 23.28 $ $ 58.67 $ 27.70 $ 292.97 $ 1,250.00 O1-150-65-00-5808 POSTAGE&SHIPPING $ $ $ $ $ $ $ $ $ $ $ 500.00 O1-150-65-00-5809 PRINTING&COPYING $ $ 108.80 $ 100.23 $ 150.32 $ 96.12 $ 91.95 $ 117.86 $ 149.41 $ 31.43 $ 846.12 $ 1,500.00 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 $ 1,178.82 $ 18,040.37 $ 25,582.00 O1-150-72-00-6501 SOCIAL SECURITY&MEC $ 1,620.58 $ 1,526.06 $ 1,526.06 $ 2,295.69 $ 763.03 $ 2,269.53 $ 1,526.06 $ 2,096.12 $ 918.96 $ 14,542.09 $ 20,176.00 01-150-75-00-7002 COMPUTER EQUIPMENT 8 $ $ 262.80 $ 398.80 $ $ 1,389.79 $ $ $ 262.80 $ $ 2,314.19 $ 3,300.00 O1-150-75-00-7003 OFFICE EQUIPMENI $ $ $ $ $ $ $ $ $ $ $ 500.00 O1-150-78-00-9015 ENERGY&RECYCLING GP $ $ $ $ 5,307.00 $ $ $ $ $ $ 5,307.00 $ TOTAL ENGINEERING EXPENSES1$ 25,665.37 1$ 25,150.87 1$ 26,525.96 1$ 42,257.55 1$ 14,227.91 $ 37,162.45 $ 24,699.32 $ 34,397.30 $ 15,150.43 $ $ $ $ 245,237.16 $ 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 $ 91,844.68 $ 864,755.10 $ 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 $ 55,225.42 $ 494,025.39 $ 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 $ 1,040.00 $ 11,638.50 $ 25,000.00 O1-210-50-00-5135 SALARIES-POLICE CLEF $ 16,198.50 $ 16,198.49 $ 15,178.49 $ 18,177.75 $ 6,059.24 $ 18,177.73 $ 12,093.50 $ 16,013.69 $ 8,937.72 $ 127,035.11 $ 212,386.00 03-210-50-00-5136 SALARIES-PARTTIME $ 2,081.48 $ 2,261.05 $ 2,227.35 $ 2,620.99 $ 1,846.50 $ 3,996.33 $ 2,503.34 $ 2,165.94 $ 1,945.76 $ 21,648.74 $ 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 $ 3,850.49 $ 53,211.57 $ 60,000.00 O1-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 $ 686.25 $ 7,965.00 $ 13,500.00 O1-210-50-00-5205 SALARIES-GRANT REIME $ 1,402.51 $ 18,322.76 $ 1,275.45 $ 21,000.72 O1-210-61-00-5300 LEGAL SERVICES $ $ $ $ $ $ $ $ $ $ $ 20,000.00 O1-210-62-00-5401 CONTRACTUAL SERVICES n/a n/a n/a n/a $ 275.71 $ 55.22 $ 54.97 $ 54.92 $ 55.22 $ 496.04 $ 01-210-62-00-5408 MAINTENANCE-EQUIPME $ $ 35.80 $ 237.50 $ 1,573.16 $ 68.50 $ 1,065.31 $ 372.99 $ 723.70 $ 1,013.90 $ 5,090.86 $ 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 $ 3,167.51 $ 23,917.81 $ 47,000.00 O1-210-62-00-5410 MAINT-OFFICE EQUIPMEN $ $ $ $ 65.00 $ (65.00) $ $ $ $ $ $ O1-210-62-00-5411 MAINTENANCE-COMPUTE $ $ 123.49 $ $ $ $ 148.82 $ $ $ $ 272.31 $ 2,500.00 01-210-62-00-5412 MAINTENANCE-KS 1$ $ $ $ (54.50) $ 65.00 $ $ $ $ $ 10.50 $ 1,000.00 O1-210-62-00-5414 WEATHER WARNING SIREN $ $ 414.00 $ $ 182.88 $ 2,915.66 $ $ $ $ $ 3,512.54 $ 4,000.00 03-210-62-00-5421 WEARING APPAREL $ 84.95 $ 134.95 1 1,343.33 $ 2,495.69 $ 486.48 $ 396.98 $ 853.85 $ 689.74 $ 666.24 $ 7,152.21 $ 10,000.00 O1-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-5432 KENDALL CO.JUVENILE $ $ $ $ $ $ $ $ 2,683.05 $ $ 2,683.05 $ 3,000.00 3 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUNC DATE OF REPORT/02-09-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-30 July-30 August-10 September-30 October-10 November-10 December-30 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET O1-210-62-00-5436 TELEPHONE $ - $ (414.25) $ 876.12 $ 916.92 $ 905.83 $ 908.89 $ 888.53 $ 909.31 $ 888.65 $ 5,880.00 $ 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 $ 945.74 $ 8,817.44 $ 17,920.00 01-210-62-00-5441 MTD-ALERTS FEE $ 3,330.00 $ $ $ $ $ 3,330.00 $ $ $ $ 6,660.00 $ 5,150.00 O1-210-62-00-5442 NEW WORLD LIVE SCAN $ $ $ 8,286.30 $ $ $ $ $ $ $ 8,286.30 $ 15,000.00 O1-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 $ 1,300.00 $ 11,107.00 $ 15,000.00 01-210-64-00-5600 DUES $ 50.00 $ $ 120.00 $ $ $ $ $ $ 125.00 $ 295.00 $ 1,000.00 O1-210-64-00-5603 SUBSCRIPTIONS $ $ $ $ $ $ $ $ $ $ $ 350.00 O1-210-64-00-5604 TRAINING&CONFERENCE $ 2,340.00 $ $ 210.00 $ $ 582.05 $ 325.00 $ 350.00 $ 525.00 $ 680.00 $ 5,012.05 $ 8,025.00 O1-210-64-00-5605 TRAVEL EXPENSES $ $ 217.28 $ $ (217.28) $ 51.47 $ 46.10 $ $ 284.40 $ 83.38 $ 465.35 $ 6,575.00 O1-210-64-00-5606 COMMUNITY RELATIONS $ $ $ 12.04 $ $ $ $ $ $ $ 12.04 $ 500.00 O1-210-64-00-5607 POLICE COMMISSION $ $ 445.00 $ $ 171.25 $ $ 100.00 $ 1,063.50 $ 618.50 $ 266.00 $ 2,664.25 $ 7,000.00 O1-210-64-00-5608 TUITION REIMBURSEMENI $ $ 126.21 $ 844.63 $ $ $ $ $ $ $ 970.84 $ 2,800.00 O1-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 O1-210-64-00-5612 NEIGHBORHOOD WATCH $ $ $ $ $ $ $ $ $ $ $ 1,500.00 O1-210-64-00-5613 CITIZENS POLICE ACADE $ $ $ $ $ $ $ $ $ $ $ 1,839.00 O1-210-64-00-5614 CHAPLAIN PROGRAM $ $ $ $ $ $ $ $ $ $ $ O1-210-64-00-5615 COMPLIANCE CHECKS $ $ $ $ $ $ $ $ $ $ $ 500.00 03-210-64-00-5616 DARE PROGRAM $ $ $ $ $ $ 2,244.98 $ $ $ $ 2,244.98 $ 3,000.00 O1-210-65-00-5801 SUPPLIES-GRANT REIMS $ $ 45.92 $ $ $ $ 6.21 $ 11.73 $ $ $ 63.86 $ 01-210-65-00-5802 OFFICE SUPPLIES $ 437.36 $ 88.18 $ 94.45 $ 64.18 $ 232.84 $ 674.19 $ 126.46 $ 206.38 $ 26.99 $ 1,951.03 $ 3,000.00 O1-210-65-00-5803 EVIDENCE TECH SUPPLIE $ $ $ $ $ $ $ $ $ 946.85 $ 946.85 $ 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 $ 487.62 $ 4,730.58 $ 8,500.00 O1-210-65-00-5808 POSTAGE&SHIPPING $ $ $ $ 95.74 $ 45.71 $ $ $ 47.39 $ $ 188.84 $ 3,000.00 O1-210-65-00-5809 PRINTING&COPYING $ $ 114.61 $ 456.69 $ 228.18 $ 213.65 $ 89.20 $ 75.01 $ 100.28 $ 84.27 $ 1,361.89 $ 4,500.00 O1-210-65-00-5810 PUBLISHING&ADVERTIS $ $ $ 25.60 $ $ $ $ $ $ $ 25.60 $ 100.00 O1-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 $ 5,517.01 $ 42,364.64 $ 80,000.00 O1-210-65-00-5813 AMMUNITION $ $ $ $ $ $ $ $ 1,995.00 $ $ 1,995.00 $ 2,000.00 01-210-65-00-5814 ADMIN ADJUDICATION OF $ $ $ $ $ $ $ $ $ $ $ 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 $ 849.96 $ 11,632.24 $ 24,385.00 O1-210-72-00-6501 SOCIAL SECURITY&MEC $ 13,929.96 $ 12,645.33 $ 12,482.41 $ 17,445.32 $ 6,398.32 $ 17,915.44 $ 11,992.67 $ 12,857.23 $ 12,414.59 $ 118,081.27 $ 178,962.00 O1-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 O1-210-75-00-7002 COMPUTER EQUIP&SOFT $ $ $ $ 2,467.50 $ $ $ $ $ $ 2,467.50 $ 7,000.00 O1-210-78-00-9006 K9 STIPENC $ 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 $ 194,324.70 $ $ $ $ 2,226,329.65 $ 3,190,934.00 GENERAL FUND-COMMUNITY DEVELOPMENT EXPENSES O1-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 $ 17,550.41 $ 211,050.69 $ 287,132.00 O1-220-61-00-5300 LEGAL SERVICES $ $ 147.00 $ $ 1.00 $ 197.00 $ 146.00 $ 147.00 $ 891.00 $ $ 1,529.00 $ 8,000.00 O1-220-61-00-5314 INSPECTIONS $ $ $ $ $ 7,377.00 $ 1,125.00 $ $ 3,015.00 $ $ 11,517.00 $ 25,000.00 03-220-62-00-5401 CONTRACTUAL SERVICES $ $ $ 876.17 $ 725.00 $ 102.75 $ 34.25 $ $ $ $ 1,738.17 $ 13,000.00 O1-220-62-00-5430 PLANNING CONSULTANT $ $ $ $ $ $ $ $ $ $ $ O1-220-62-00-5432 ECONOMIC DEVELOPMENI $ $ $ $ $ $ $ $ $ 45,000.00 $ 45,000.00 $ 45,000.00 O1-220-62-00-5438 CELLULAR TELEPHONE $ $ 98.15 $ 204.32 $ 101.18 $ 107.15 $ 97.83 $ 96.56 $ 99.70 $ 90.04 $ 894.93 $ 1,500.00 01-220-64-00-5600 DUES $ 463.00 $ $ $ $ $ $ $ 100.00 $ $ 563.00 $ 1,500.00 O1-220-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ 15.00 $ $ $ 40.00 $ 10.00 H$ 8,348.43 5.00 $ 200.00 01-220-64-00-5605 TRAVEL EXPENSE $ $ $ $ $ $ $ $ $ $ O1-220-65-00-5802 OFFICE SUPPLIES $ 53.11 $ 16.64 $ 52.73 $ 33.92 $ 37.37 $ 62.14 $ $ 76.58 $ 27.70 0.19 $ 500.00 01-220-65-00-5804 OPERATING SUPPLIES $ 135.94 $ 6.50 $ 316.20 $ $ 5.94 $ 71.13 $ $ 33.40 $ 9.11 $ 3,500.00 01-220-65-00-5508 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 $ 31.43 1.95 $ 1,300.00 O1-220-65-00-5810 PUBLISHING&ADVERTIS $ $ 86.90 $ $ $ $ $ $ $ 6.90 $ 150.00 01-220-65-00-5814 BOOKS&MAPS $ $ $ $ 202.10 $ $ $ $ $ 50.00 2.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 $ 1,669.03 7.67 $ 27,851.00 03-220-72-00-6501 SOCIAL SECURITY&MEC $ 1,513.95 $ 1,638.45 $ 1,619.33 $ 2,352.61 $ 812.15 $ 2,423.10 $ 1,631.56 $ 2,056.37 $ 1,278.48 6.00 $ 21,966.00 O1-220-75-00-7002 COMPUTER EQUIP&SOFT $ $ $ $ 1,993.03 $ 104.98 $ $ 72.98 $ $ 0.99 $ 7,955.00 01-220-75-00-7003 OFFICE EQUIPMENT $ $ $ $ $ $ $ $ $ $ 125.00 O1-220-78-00-9015 RAIN GARDEN GRANI $ $ $ $ $ $ $ $ $ $ O1-220-78-00-9016 FULL CIRCLE GRANT $ (9,145.00) $ 325.00 $ 155.00 $ 7,048.18 $ (7,477.06) $ $ $ 17,442.31 $ 8.43 $TOTAL COMMUNITY DEVELOPMENT EXPENSES $ 15,681.16 $ 26,611.68 $ 27,423.23 $ 48,292.09 $ 13,671.99 $ 40,495.66 $ 26,657.61 $ 54,317.55 $ 65,707.09 $ $ $ 8.09 $ 446,179.00 GENERAL FUND-STREETS EXPENSES O1-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 $ 22,010.03 $ 216,629.19 $ 243,472.00 O1-410-50-00-5136 SALARIES-PART TIME $ $ $ $ $ $ $ $ $ $ $ 03-410-50-00-5137 SALARIES-OVERTIME $ 538.01 $ 605.83 $ 278.57 $ 696.43 $ $ 603.56 $ 371.43 $ 1,765.03 $ 1,173.52 $ 6,032.38 $ 28,000.00 O1-410-61-00-5313 ENGINEERING-IN TOWN $ $ $ $ $ $ $ $ $ $ $ 03-410-61-00-5314 INSPECTIONS&LICENSE $ $ $ $ $ 137.00 $ $ $ $ $ 137.00 $ 700.00 O1-410-62-00-5401 CONTRACTUAL SERVICES $ $ 19.99 $ 19.98 $ 44.98 $ 19.98 $ 19.98 $ 53.30 $ 19.98 $ 119.99 $ 318.18 $ 1,000.00 01-410-62-00-5408 MAINTENANCE-EQUI PM ENI $ $ (2,259.25) $ 2,540.88 $ 79.33 $ 219.90 $ 1,613.75 $ 181.29 $ 51.21 $ 4,687.90 $ 7,115.01 $ 10,000.00 4 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUNC DATE OF REPORT/02-09-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-30 July-10 August-10 September-30 October-10 November-10 December-30 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 01-410-62-00-5409 MAINTENANCE-VEHICLES $ 475.42 $ 68.29 $ 923.67 $ - $ 521.70 $ 1,944.12 $ 9,714.20 $ 3,158.38 $ 2,681.14 $ 19,486.92 $ 25,000.00 01-410-62-00-5414 MAINTENANCE-TRAFFIC S $ (49.55) $ (13,233.67) $ 567.55 $ $ 3,059.81 $ 3,465.06 $ 1,017.00 $ 5.97 $ 14,140.32 $ 8,972.49 $ 15,000.00 O1-410-62-00-5415 MAINTENANCE-STREET L $ 192.00 $ 1,370.75 $ 4,235.05 $ (2,620.96) $ 725.39 $ 485.72 $ 549.40 $ 389.64 $ 29.50 $ 5,356.49 $ 9,000.00 03-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 $ 2,773.60 $ 8,253.60 $ 30,000.00 O1-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 $ 180.23 $ 1,474.95 $ 4,200.00 O1-410-62-00-5434 RENTAL-EQUIPMENI $ $ $ 176.00 $ $ $ $ $ $ $ 176.00 $ 1,000.00 03-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 $ 11,304.26 $ 53,735.17 $ 75,000.00 O1-410-62-00-5438 CELLULAR TELEPHONE $ $ 145.40 $ 160.85 $ 152.96 $ 167.90 $ 200.91 $ 205.70 $ 172.57 $ 146.78 $ 1,353.07 $ 4,020.00 O1-410-62-00-5440 STREET LIGHTING $ $ $ $ $ $ $ $ $ $ $ O1-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 $ 214.82 $ 2,674.08 $ 10,000.00 O1-410-65-00-5810 ELECTRICAL MAINT SUPF $ $ $ $ $ $ $ $ $ $ $ 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 $ 3,153.68 $ 17,221.97 $ 32,000.00 O1-410-65-00-5815 HAND TOOLS $ $ $ $ $ $ 18.93 $ $ $ $ 18.93 $ 1,000.00 O1-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 $ 2,204.81 $ 20,434.25 $ 26,332.00 O1-410-72-00-6501 SOCIAL SECURITY&MEE $ 1,743.67 $ 1,750.95 $ 1,739.00 $ 2,596.91 $ 860.48 $ 2,600.97 $ 1,749.94 $ 1,852.93 $ 1,724.67 $ 16,619.52 $ 20,768.00 O1-410-75-00-4404 HANGING BASKETS $ $ 1,832.00 $ 204.00 $ 11.98 $ $ $ $ $ $ 2,047.98 $ 2,000.00 03-410-75-00-5418 MOSQUITO CONTROL $ $ $ $ $ $ 6,500.00 $ $ $ $ 6,500.00 $ 15,000.00 O1-410-75-00-7004 SAFETY EQUIPMENT $ $ 245.75 $ $ $ $ $ $ 270.26 $ 45.00 $ 561.01 $ 500.00 01-410-75-00-7101 IN TOWN ROAD PROGRAM $ $ $ $ $ $ $ $ $ $ $ 40,232.00 O1-410-75-00-7102 TREE&STUMP REMOVAI $ $ $ $ 150.00 $ 4,800.00 $ $ $ $ $ 4,950.00 $ 10,000.00 O1-410-75-00-7103 SIDEWALK CONSTRUCTION $ 246.00 $ $ $ $ 240.00 $ $ 739.04 $ $ $ 1,225.04 $ 4,000.00 O1-410-78-00-9010 PARKWAY TREE PROGRAN $ $ (145.00) $ (108.00) $ (1,287.00) $ (1,394.00) $ 1,768.95 $ 432.88 $ $ 732.17 $ $ 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 $ 67,322.42 $ $ $ $ 407,192.42 $ 616,724.00 GENERAL FUND-HEALTH&SANITATION EXPENSES O1-540-62-00-5442 GARBAGE SERVICES $ $ 98,777.71 $ 98,735.97 $ 99,049.02 $ 98,777.71 $ 98,631.62 $ 98,235.09 $ 98,026.39 $ 97,817.69 $ 788,051.20 $ 1,140,000.00 01-540-62-00-5443 LEAF PICKUP $ $ 600.00 $ $ $ $ $ $ $ 3,960.00 $ 4,560.00 $ 6,000.00 TOTAL HEALTH&SANITATION EXPENSES $ 1$ 99,377.71 1$ 98,735.97 1$ 99,049.02 1$ 98,777.71 1$ 98,631.62 1$ 98,235.09 1$ 98,026.39 1$ 101,777.69 1$ $ $ $ 792,611.20 $ 1,146,000.00 TOTAL FUND REVENUES $ 378,325.58 $ 2,231,237.70 $ 719,672.63 $ 932,189.60 $ 1,826,732.53 $ 884,381.21 $ 458,349.99 $ 796,985.59 $ 816,520.20 $ $ $ $ 9,044,395.03 $ 11,433,025.00 TOTAL FUND EXPENSES§$ 850,913.24 $ 705,428.95 $ 1,188,665.20 $ 905,252.63 $ 806,979.66 $ 1,161,907.48 $ 781,646.30 $ 878,620.35 $ 1,226,110.70 $ $ $ $ 8,505,524.51 $ 11,376,980.00 FUND SURPLUS(DEFICIT)1$ (472,587.66) $ 1,525,808.75 1$ (468,992.57)1$ 26,936.97 1$ 1,019,752.87 1$ (277,526.27) $ (323,296.31) $ (81,634.76) $ (409,590.50) $ 1$ 1$ 1$ 538,870.52 1$ 56,045.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 $ 388.47 $ 496.96 $ $ $ 19,894.11 $ 19,463.00 FOX HILL SSA EXPENSES 11-000-65-00-5416 MAINTENANCE COMMON GP $ - $ 430.00 $ 909.84 $ 967.50 $ 454.92 $ 568.65 $ 454.92 $ - $ - $ 3,785.83 $ 3,458.00 TOTAL FUND REVENUES $ $ 9,414.19 $ 441.86 $ 1,881.23 $ 7,271.40 $ 388.47 $ 496.96 $ $ $ $ $ $ 19,894.11 $ 21,808.00 TOTAL FUND EXPENSES $ $ 430.00 $ 909.84 $ 967.50 $ 454.92 $ 568.65 $ 454.92 $ $ $ $ $ $ 3,785.83 $ 3,458.00 FUND SURPLUS(DEFICIT) $ 1$ 8,984.19 1$ (467.98)1$ 913.73 1$ 6,816.48 1$ (180.18)l$ 42.04 1$ $ $ $ $ $ 16,108.28 $ 18,350.00 SUNFLOWER SSA REVENUES 12-000-40-00-3999 CARRY OVER BALANCE $ $ $ $ $ $ $ $ $ $ $ 5,958.00 12-000-40-00-4002 SUNFLOWER LEVY $ $ 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 GP $ $ 2,204.80 $ 1,649.00 $ 1,812.57 $ 1,219.00 $ 537.50 $ 107.50 $ $ $ 7,530.37 $ 8,253.00 TOTAL FUND REVENUES $ $ 6,652.73 $ 341.13 $ 963.56 $ 5,676.61 $ 57.34 $ 179.13 $ $ $ $ $ $ 13,870.50 $ 19,070.00 TOTAL FUND EXPENSES $ $ 2,204.80 $ 1,649.00 $ 1,812.57 $ 1,219.00 $ 537.50 $ 107.50 $ $ $ $ $ $ 7,530.37 $ 8,253.00 FUND SURPLUS(DEFICIT) $ $ 4,447.93 1$ (1,307.87) $ (849.01)l$ 4,457.61 1$ (480.16)1$ 71.63 1$ $ $ $ $ $ 6,340.13 $ 10,817.00 MOTOR FUEL TAX REVENUES 15-000-40-00-3999 CARRY OVER BALANCE $ $ $ $ $ $ $ $ $ $ $ 133,782.00 15-000-40-00-4060 MOTOR FUEL TAX ALLOTN $ 36,524.19 $ 35,337.89 $ 33,399.04 $ 36,201.75 $ 35,211.55 $ 40,536.39 $ 29,696.11 $ 37,878.11 $ 36,262.43 $ 321,047.46 $ 355,000.00 15-000-40-00-4065 MFT HIGH GROWTH n/a n/a n/a n/a $ $ 24,674.00 $ $ $ $ 24,674.00 $ 15-000-44-00-4401 GAME FARM ROAD DESIGN $ $ $ $ 6,978.01 $ $ $ $ $ $ 6,978.01 $ 15-000-44-00-4402 FOX ROAC $ $ $ $ $ $ 4,602.26 $ $ $ $ 4,602.26 $ 15-000-44-00-4403 DOWNTOWN PARKING LOI n/a n/a n/a n/a $ $ 55,000.00 $ $ $ $ 55,000.00 $ 15-000-44-00-4480 ILLINOIS JOBS NOW $ $ $ 73,122.00 $ $ $ 73,122.00 15-000-44-00-4490 MISC.INCOME $ $ $ $ $ $ $ 85.50 $ $ $ 85.50 $ 15-000-46-00-4600 INVESTMENT INCOME $ 38.80 $ 52.60 $ 59.29 $ 70.38 $ 75.17 $ 99.34 $ 93.03 $ 90.36 $ 78.11 $ 657.08 $ 1,000.00 MOTOR FUEL TAX EXPENSES 15-000-65-00-5800 CONTINGENCY $ $ $ $ $ $ $ $ $ $ $ 15-000-65-00-5804 OPERATING SUPPLIES $ $ $ $ $ $ $ $ $ $ $ 15-000-65-00-5818 SALT i$ $ $ $ $ $ $ $ 33,082.50 $ 40,255.52 $ 73,338.02 $ 204,000.00 15-000-75-00-7007 SIGNS $ $ $ 67.10 $ $ $ 41.95 $ $ $ 251.70 $ 360.75 $ 18,000.00 15-000-75-00-7009 PATCHING $ $ $ $ $ $ $ $ 49,857.33 $ $ 49,857.33 $ 50,000.00 5 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUNC DATE OF REPORT/02-09-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-10 July-SO August-10 September-10 October-10 November-10 December-SO January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 15-000-75-00-7106 GAME FARM SURVEYING $ - $ - $ - $ 6,456.02 $ - $ - $ - $ - $ - $ 6,456.02 $ - 15-000-75-00-7108 GAME FARM HOUSE DEMC $ $ $ $ $ $ $ $ $ $ $ 20,000.00 15-000-75-00-7110 COLD PATCH $ $ 1,488.11 $ $ $ $ - $ $ $ 1,500.15 $ 2,988.26 $ 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-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 ROAC $ $ $ $ 582.60 $ $ 20,293.22 $ $ $ $ 20,875.82 $ 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 SIGNAL $ $ $ $ $ $ $ $ $ $ $ TOTAL FUND REVENUES $ 36,562.99 $ 35,390.49 $ 33,458.33 $ 43,250.14 $ 35,286.72 $ 124,911.99 $ 102,996.64 $ 37,968.47 $ 36,340.54 $ $ $ $ 486,166.31 $ 489,782.00 TOTAL FUND EXPENSES $ $ 1,488.11 $ 67.10 $ 27,038.62 $ $ 49,631.48 $ $ 84,429.34 $ 42,007.37 $ $ $ $ 204,662.02 $ 475,600.00 FUND SURPLUS(DEFICIT) $ 36,562.99 $ 33,902.38 $ 33,391.23 $ 16,211.52 $ 35,286.72 $ 75,280.51 $ 102,996.64 $ (46,460.87) $ (5,666.83) $ $ $ $ 281,504.29 $ 14,182.00 MUNICIPAL BUILDING REVENUES 16-000-40-00-3999 CARRY OVER BALANCE $ $ $ $ $ $ $ $ $ $ (607,474.00) 16-000-42-00-4211 DEVELOPMENT FEES-BUII $ 1,350.00 $ 15,900.00 $ 150.00 $ 450.00 $ 750.00 $ 1,350.00 $ $ $ 19,950.00 $ 55,000.00 TOTAL FUND REVENUES 1,350.00 $ 15,900.00 $ 150.00 $ 450.00 $ 750.00 $ 1,350.00 $ $ $ $ $ $ $ 19,950.00 $ (552,474.00) TOTAL FUND EXPENSES $ $ $ $ $ $ $ $ $ $ $ $ $ $ FUND SURPLUS(DEFICIT) $ 1,350.00 $ 15,900.00 $ 150.00 $ 450.00 $ 750.00 $ 1,350.00 $ $ $ $ $ $ $ 19,950.00 $ (552,474.00) POLICE CAPITAL REVENUES 20-000-40-00-3999 CARRY OVER-WEATHER\A $ $ $ $ $ $ $ $ $ $ $ 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-4403 IN CAR VIDEO DONATION $ 500.00 $ 265.80 $ 140.40 $ 188.20 $ 707.40 $ 223.20 $ 432.40 $ 652.17 $ 813.11 $ 3,922.68 $ 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 GENERAI $ $ $ $ $ $ $ $ $ $ $ 25,000.00 POLICE CAPITAL EXPENSES 20-000-65-00-5811 LETHAL/NON-LETHAL WEF $ $ $ $ $ $ $ $ $ $ $ 20-000-65-00-5840 SEIZED VEHICLES $ $ 95.00 $ 95.00 $ 380.00 $ 325.00 $ 95.00 $ 60.00 $ 486.01 $ 105.00 $ 1,641.01 $ 1,500.00 20-000-75-00-7001 EQUIPMENT $ $ $ $ $ $ $ $ $ $ $ 40,000.00 20-000-75-00-7002 K-9 EQUIPMENI $ $ $ $ $ $ $ $ $ $ $ 2,500.00 20-000-75-00-7005 VEHICLES $ $ $ $ 42,310.00 $ $ $ $ $ $ 42,310.00 $ 40,000.00 20-000-75-00-7006 CAR BUILD OUT $ $ $ $ $ 740.00 $ 4,689.05 $ $ $ $ 5,429.05 $ 20,000.00 TOTAL FUND REVENUES $ 4,050.00 $ 3,815.80 $ 1,740.40 $ 1,938.20 $ 2,310.90 $ 2,641.95 $ 1,184.90 $ 6,461.17 $ 813.11 $ $ $ $ 24,956.43 $ 98,617.00 TOTAL FUND EXPENSES $ $ 95.00 $ 95.00 $ 42,690.00 $ 1,065.00 $ 4,784.05 $ 60.00 105.00 $ $ $ $ 49,380.06 $ 104,000.00 FUND SURPLUS(DEFICIT) $ 4,050.00 $ 3,720.80 $ 1,645.40 $ (40,751.80) $ 1,245.90 $ (2,142.10) $ 1,124.90 $ 5,975.16 $ 708.11 $ $ $ Il $ (24,423.63) $ (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-PUBI $ 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-000-42-00-4288 MOWING INCOME $ 2,041.25 $ 337.81 $ 2,379.06 $ 21-000-44-00-4430 SALE OF EQUIPMENT $ $ $ $ $ $ $ $ $ $ 21-000-44-00-4490 MISCELLANEOUS INCOME $ $ $ $ $ $ $ $ $ 1,005.00 $ 1,005.00 $ PUBLIC WORKS CAPITAL EXPENSES 21-000-75-00-7001 EQUIPMENI $ $ $ (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 PAYMENI $ 13,715.84 $ 6,857.92 $ 6,857.92 $ 6,857.92 $ 6,857.92 $ 6,857.92 $ 6,857.92 $ 6,857.92 $ 6,857.92 $ 68,579.20 $ 84,000.00 TOTAL FUND REVENUES $ 6,050.00 $ 2,550.00 $ 1,400.00 $ 1,850.00 $ 3,250.00 $ 5,800.00 $ $ 2,741.25 $ 1,342.81 $ $ $ $ 24,984.06 $ 175,395.00 TOTAL FUND EXPENSES $ 13,715.84 $ 6,857.92 $ 6,765.26 $ 6,365.80 $ 6,603.80 $ 6,643.81 $ 6,348.23 $ 6,857.92 $ 6,857.92 $ $ $ $ 67,016.50 $ 139,000.00 FUND SURPLUS(DEFICIT) $ (7,665.84) $ (4,307.92) $ (5,365.26) $ (4,515.80) $ (3,353.80) $ (843.81) $ (6,348.23) $ (4,116.67) $ (5,515.11) $ $ $ $ (42,032.44)1$ 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 $ $ $ $ $ $ $ $ $ $ $ 22-000-42-00-4218 BASEBALL FIELD CONSTF $ $ $ $ $ $ $ $ $ $ $ 15,000.00 22-000-44-00-4430 SALE OF VEHICLES/EQUI $ $ $ $ $ $ $ $ $ $ $ 22-000-46-00-4600 INVESTMENT INCOME $ 6.72 $ 6.52 $ 6.95 $ 6.94 $ 6.51 $ 6.72 $ 6.51 $ 6.72 $ 6.73 $ 60.32 $ 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-75-00-7011 BASEBALL FIELD CONSTF $ $ $ $ $ $ 3,907.12 $ 4,950.00 $ 6,206.55 $ 592.25 $ 15,655.92 $ 15,000.00 6 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUNC DATE OF REPORT/02-09-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-30 July-10 August-10 September-30 October-10 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET TOTAL FUND REVENUES $ 356.72 $ 6.52 $ 6.95 $ 6.94 $ 656.51 $ 6.72 $ 656.51 $ 6.72 $ 6.73 $ $ $ $ 1,710.32 $ 210,960.00 TOTAL FUND EXPENSES $ $ 275.16 $ 1,500.00 $ $ $ 3,907.12 $ 4,950.00 $ 6,206.55 $ 592.25 $ $ $ $ 17,431.08 $ 173,135.00 FUND SURPLUS(DEFICIT) $ 356.72 $ (268.64) $ (1,493.05)1$ 6.94 1$ 656.51 $ (3,900.40) $ (4,293.49) $ (6,199.83) $ (585.52) $ 1$ 1$ 11$ (15,720.76)1$ 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-42-00-4211 ENGINEERING CAPITAL F $ 800.00 $ 300.00 $ 200.00 $ 200.00 $ 400.00 $ 700.00 $ $ $ $ 2,600.00 $ 4,000.00 23-000-44-00-4400 REIMB.OLD JAIL n/a n/a n/a n/a n/a $ $ $ $ $ $ 23-000-45-00-4501 SAFE RT TO SCHOOL(DE $ $ $ $ $ $ $ $ $ $ $ 46,200.00 23-000-45-00-4502 SAFE RT TO SCHOOL(CC $ $ $ $ $ $ $ $ $ $ $ 184,800.00 23-000-45-00-4600 INVESTMENT INCOME n/a n/a n/a n/a $ 2.75 $ 2.37 $ 2.29 $ 2.37 $ 2.36 $ 12.14 $ 23-000-49-00-4901 TRANSFER FROM GENERAL $ $ $ 40,625.00 $ $ $ 40,625.00 $ $ $ 40,625.00 $ 121,575.00 $ 162,500.00 CITY WIDE CAPITAL EXPENSES 23-000-75-00-7005 VEHICLES $ $ $ $ $ $ $ $ $ $ $ 4,000.00 23-000-75-00-7006 ROAD CONTRIBUTION RES $ $ $ $ $ $ $ $ $ $ $ 24,000.00 23-000-75-00-7101 RON CLARK PROPERTY $ 125,000.00 $ $ $ $ $ $ $ $ $ 125,000.00 $ 125,000.00 23-000-75-00-7103 SIDEWALK REPLACEMENI $ $ $ $ $ 5,934.11 $ $ 4,111.30 $ 439.06 $ $ 10,484.47 $ 37,500.00 23-000-75-00-7111 PARKWAY TREE PLANTING $ $ $ $ $ $ $ $ $ $ $ 25,000.00 23-000-75-00-7112 SIDEWALK REPLACEMENI $ $ $ $ $ $ $ $ $ $ $ 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 PARI< $ $ $ $ $ $ $ $ $ $ $ 25,000.00 23-000-75-00-7117 FAXON ROAD RO" $ $ $ $ $ $ $ $ $ $ $ 85,000.00 23-000-75-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 $ - $ - $ - $ $ - $ $ $ $ $ $ - TOTAL FUND REVENUES $ 12,800.00 $ 300.00 $ 42,825.00 $ 200.00 $ 402.75 $ 43,327.37 $ 2.29 $ 2.37 $ 40,627.36 $ $ $ $ 140,487.14 $ 328,322.00 TOTAL FUND EXPENSES1$ 125,000.00 $ $ $ 161,569.00 $ 5,934.11 $ (96,000.00) $ 4,111.30 $ 490.06 $ $ $ $ $ 201,104.47 $ 606,500.00 FUND SURPLUS(DEFICIT) $ (112,200.00) $ 300.00 $ 42,825.00 $ (161,369.00) $ (5,531.36) $ 139,327.37 $ (4,109.01) $ (487.69) $ 40,627.36 $ $ $ $ (60,617.33) $ (278,178.00) DEBT SERVICE REVENUES 42-000-40-00-3999 CARRY OVER BALANCE $ $ $ $ $ $ $ $ $ - $ $ 6,853.00 42-000-44-00-4440 RECAPTURE-WATER/SEWEF $ 225.00 $ 125.00 $ 75.00 $ 75.00 $ 125.00 $ 225.00 $ 25.00 $ 25.00 $ $ 900.00 $ 42-000-49-00-4901 TRANSFER FROM GENERAL $ $ $ 107,351.00 $ $ $ 107,351.00 $ $ $ 107,351.00 $ 322,053.00 $ 429,404.00 DEBT SERVICE EXPENSES 42-000-66-00-6070$650K ROAD IMPROV PRC $ $ $ $ $ $ $ $ $ $ $ 42-000-66-00-6071$650K ROAD IMPROV PRC $ 6,412.50 $ $ $ $ $ $ $ 101,412.50 $ $ 107,825.00 $ 107,825.00 42-000-66-00-6074$3.825M IN TOWN ROAC $ $ $ $ $ $ - $ $ $ $ $ 42-000-66-00-6075$3.825M IN TOWN ROAC $ $ 68,289.38 $ $ $ $ $ $ 253,289.38 $ $ 321,578.76 $ 321,579.00 TOTAL FUND REVENUES $ 225.00 $ 125.00 $ 107,426.00 $ 75.00 $ 125.00 $ 107,576.00 $ 25.00 $ 25.00 $ 107,351.00 $ $ $ $ 322,953.00 $ 436,257.00 TOTAL FUND EXPENSES $ 6,412.50 $ 68,289.38 $ $ $ $ $ $ 354,701.88 $ $ $ $ $ 429,403.76 $ 429,404.00 FUND SURPLUS(DEFICIT) $ (6,187.50) $ (68,164.38) $ 107,426.00 $ 75.00 $ 125.00 $ 107,576.00 $ 25.00 $ (354,676.88) $ 107,351.00 $ $ $ $ (106,450.76) $ 6,853.00 WATER OPERATIONS REVENUES 51-000-42-00-4240 BULK WATER SALES $ 110.00 $ (98.00) $ $ (149.00) $ (152.00) $ 889.27 $ (392.00) $ (392.00) $ 1,232.00 $ 1,048.27 $ 2,000.00 51-000-42-00-4241 WATER SALES $ 425.91 $ 294,897.03 $ 4,106.77 $ 323,533.53 $ 4,015.90 $ 295,361.44 $ 4,955.07 $ 257,831.40 $ 4,686.71 $ 1,189,813.76 $ 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-H201 $ 2,149.29 $ 2,149.29 $ 2,149.29 $ 5,405.29 $ 2,459.79 $ 2,149.29 $ 2,770.29 $ 2,149.29 $ 3,070.29 $ 24,455.11 $ 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-46001NVESTMENT INCOME $ 45.40 $ 133.06 $ 331.95 $ 192.15 $ 170.96 $ 318.84 $ 86.56 $ 78.78 $ 43.45 $ 1,401.18 $ 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 $ 24,337.34 $ 251,042.14 $ 358,702.00 51-000-50-00-5137 SALARIES-OVERTIME $ 173.44 $ 45.31 $ 317.49 $ 40.82 $ 60.41 $ 1,139.24 $ 644.67 $ 504.07 $ 428.58 $ 3,354.03 $ 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 $ (1,555.98) $ 4,458.79 $ 6,000.00 51-000-62-00-5407 TREATMENT FACILITIES $ 2,570.53 $ 12,613.09 $ 23,621.71 $ 16,914.14 $ 27,066.32 $ 14,188.52 $ 25,126.35 $ 23,375.95 $ 20,118.36 $ 165,595.27 $ 230,000.00 51-000-62-00-5408 MAINTENANCE-EQUI PM ENI $ $ $ 21.09 $ 196.02 $ $ $ $ 322.17 $ 251.00 $ 790.28 $ 8,000.00 51-000-62-00-5409 MAINTENANCE-VEHICLES $ $ 20.00 $ $ 17.58 $ 317.30 $ 27.41 $ 984.86 $ 1,946.07 $ 5.26 $ 3,318.48 $ 9,000.00 51-000-62-00-5411 MAINTENANCE-COMPUTER-' $ $ $ $ $ $ $ $ $ $ $ 500.00 51-000-62-00-5421 WEARING APPAREL $ 65.61 $ 85.57 $ 150.39 $ 142.07 $ 159.64 $ 91.44 $ 150.78 $ 125.43 $ 150.23 $ 1,151.16 $ 3,500.00 51-000-62-00-5434 RENTAL-EQUIPMENI $ $ $ $ $ $ $ $ $ $ $ 1,000.00 51-000-62-00-5435 ELECTRICITY $ $ 12,814.11 $ 21,659.93 $ 24,167.83 $ 11,916.48 $ 25,873.23 $ 24,057.99 $ 25,274.33 $ 9,589.63 $ 155,353.53 $ 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 $ 1,254.97 $ 8,405.70 $ 22,000.00 51-000-62-00-5438 CELLULAR TELEPHONE $ $ 145.40 $ 160.84 $ 152.96 $ 202.89 $ 200.92 $ 164.17 $ 290.56 $ 146.79 $ 1,464.53 $ 3,300.00 51-000-64-00-5600 DUES $ $ 367.00 $ $ $ $ $ $ $ $ 367.00 $ 1,000.00 7 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUNC DATE OF REPORT/02-09-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-10 July-SO August-10 September-10 October-10 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 51-000-64-00-5603 SUBSCRIPTIONS $ - $ - $ - $ - $ - $ - $ - $ 57.20 $ - $ 57.20 $ 250.00 51-000-64-00-5604 TRAINING&CONFERENCE $ $ $ 330.00 $ $ $ 776.60 $ $ $ 735.00 $ 1,841.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 $ 731.25 $ 11,391.61 $ 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 $ 109.60 $ 836.91 $ 2,500.00 51-000-65-00-5810 PUBLISHING&ADVERT15 $ $ $ 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 $ 3,811.61 $ 17,880.02 $ 34,000.00 51-000-65-00-5815 HAND TOOLS $ $ $ $ $ $ $ $ $ $ $ 1,000.00 51-000-65-00-5817 GRAVEL $ $ $ $ $ $ 264.11 $ $ 150.79 $ 407.05 $ 821.95 $ 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 $ 181.50 $ 10,264.54 $ 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 $ 2,355.18 $ 23,320.57 $ 31,017.00 51-000-72-00-6501 SOCIAL SECURITY&MEC $ 1,951.95 $ 1,955.43 $ 1,901.59 $ 2,835.53 $ 981.89 $ 3,008.90 $ 1,981.78 $ 2,137.83 $ 1,804.92 $ 18,559.82 $ 28,588.00 51-000-75-00-7002 COMPUTER EQUIP&SOFI $ $ $ $ $ $ $ 178.00 $ $ 160.00 $ 338.00 $ 1,200.00 51-000-75-00-7004 SAFETY EQUIPMENT $ $ 175.77 $ $ $ $ $ $ $ 90.00 $ 265.77 $ 1,000.00 51-000-75-00-7506 METER READERS $ $ $ 421.81 $ $ $ $ $ $ $ 421.81 $ 51-000-75-00-7507 HYDRANT REPLACEMENI $ $ $ 110.39 $ $ $ $ $ $ 950.00 $ 1,060.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 $ 1,703.25 $ 21,368.25 $ 40,000.00 51-000-75-00-7509 ELECTRICITY MONITOR $ $ 421.81 $ $ $ $ $ $ $ $ 421.81 $ 51-000-78-00-9099 BAD DEBT $ $ $ $ $ $ $ $ $ $ $ 51-000-99-00-9901 TRANSFER TO GENERAL F $ $ - $ 22,965.75 $ - $ $ 22,965.75 $ $ - $ 22,965.75 $ 68,897.25 $ 91,863.00 TOTAL WATER OPERATIONS REVENUES $ 7,000.60 $ 302,111.55 $ 9,500.23 $ 330,872.79 $ 9,751.08 $ 305,058.86 $ 8,482.20 $ 264,426.35 $ 9,032.45 $ $ $ $ 1,243,414.02 $ 1,351,050.00 TOTAL WATER OPERATIONS EXPENSES $ 36,184.59 $ 62,801.55 $ 111,816.43 $ 99,349.58 $ 73,994.59 $ 121,377.49 $ 91,953.02 $ 100,680.36 $ 90,761.29 $ $ $ $ 788,918.90 $ 1,265,620.00 FUND SURPLUS(DEFICIT) $ (29,183.99) $ 239,310.00 $ (102,316.20) $ 231,523.21 $ (64,243.51) $ 183,681.37 $ (83,470.82) $ 163,745.99 $ (81,728.84) $ $ $ $ 454,495.12 $ 85,430.00 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-4250 IMPROVEMENT EXPANSION $ $ 112,450.47 $ 85.34 $ 114,171.19 $ 368.84 $ 112,611.98 $ 168.48 $ 115,327.97 $ 218.16 $ 455,402.43 $ 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 1$ (4.84)1 1 1 1$ 370.80 1$ 1,200.00 WATER IMPROVEMENTS EXPENSES 51-200-61-00-5300 LEGAL SERVICES $ $ $ $ $ $ $ $ $ $ $ 2,000.00 51-200-61-00-5301 ENGINEERING-GENERAL SVC'- $ $ $ $ $ $ $ $ $ $ $ 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 $ 22,988.77 $ 206,898.93 $ 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,030.16 $ 125,031.00 51-200-66-00-6042[EPA L17-1563001NTEF $ $ $ $ $ $ $ $ $ $ $ 51-200-66-00-60562006A REFUND.INTERES $ $ $ $ $ $ $ $ $ $ $ 51-200-66-00-60572006A REFUND.PRINCIPP $ $ 45,653.13 $ $ $ $ $ $ 115,653.13 $ $ 161,306.26 $ 161,307.00 51-200-66-00-6058 2002 PRINCIPAL PMT-NC $ 215,000.00 $ $ $ $ $ $ $ $ $ 215,000.00 $ 215,000.00 51-200-66-00-6059 2007A REFUNDING P&I F $ $ 62,133.13 $ $ $ $ $ $ $ $ 62,133.13 $ 51-200-66-00-6072 20050 INTEREST PMT-$i $ $ $ $ $ $ $ $ $ $ $ 51-200-66-00-6073 2005C PRINCIPAL PMT-$ $ $ 20,175.00 $ $ $ $ $ $ 125,350.00 $ $ 145,525.00 $ 83,863.00 TOTAL WATER IMPROVEMENT REVENUES $ 20,094.03 $ 126,527.83 $ 10,466.37 $ 120,584.26 $ 9,438.28 $ 130,700.54 $ 4,200.02 $ 119,048.58 $ 213.32 $ $ $ $ 541,273.23 $ (291,819.00) TOTAL WATER IMPROVEMENT EXPENSES $ 254,563.77 $ 150,950.03 $ 85,503.85 $ 22,988.77 $ 22,988.77 $ 22,988.77 $ 39,563.77 $ 263,991.90 $ 85,503.85 $ $ $ $ 949,043.48 $ 857,057.00 FUND SURPLUS(DEFICIT) $ (234,469.74) $ (24,422.20) $ (75,037.48) $ 97,595.49 $ (13,550.49) $ 107,711.77 $ (35,363.75) $ (144,943.32) $ (85,290.53) $ $ $ $ (407,770.25) $ (1,148,876.00) COMBINED WATER IMPROVEMENT&OPERATIONS FUNDS TOTAL FUND REVENUES1$ 27,094.63 $ 428,639.38 $ 19,966.60 $ 451,457.05 $ 19,189.36 $ 435,759.40 1$ 12,682.221$ 383,474.93 1$ 9,245.77 1$ $ $ 1$ 1,784,687.25 $ 1,059,231.00 TOTAL FUND EXPENSES§$ 290,748.36 $ 213,751.58 $ 197,320.28 $ 122,338.35 $ 96,983.36 $ 144,366.26 1$ 131,516.79 1$ 364,672.26 1$ 176,265.14 1$ $ $ 1$ 1,737,962.38 $ 2,122,677.00 FUND SURPLUS(DEFICIT)l$ (263,653.73)1$ 214,887.80 1$ (177,353.68)1$ 329,118.70 1$ (77,794.00)1$ 291,393.14 1$ (118,834.57)1$ 18,802.67 1$ (167,019.37) $ 1$ 1$ 11$ 46,724.87 $ (1,063,446.00) SEWER OPERATIONS REVENUES 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 $ 140.04 $ 486,991.88 $ 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 $ 178,000.00 $ 595,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 RECOVERI $ $ $ $ $ $ $ $ $ $ $ 52-000-46-00-4600 INVESTMENT INCOME $ 45.40 $ 133.06 $ 331.98 $ 192.14 $ 170.95 $ 318.84 $ 86.56 $ 78.78 $ 43.45 $ 1,401.16 $ 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 $ 15,636.29 $ 176,168.28 $ 256,296.00 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 $ 2,519.57 $ 3,003.28 $ 4,500.00 8 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUNC DATE OF REPORT/02-09-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-SO June-10 July-SO August-10 September-10 October-10 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 52-000-62-00-5408 MAINTENANCE-EQUI PM ENI $ 123.89 $ - $ - $ 149.41 $ - $ 34.99 $ - $ 323.89 $ 191.25 $ 823.43 $ 5,000.00 52-000-62-00-5409 MAINTENANCE-VEHICLES $ $ 20.00 $ 20.00 $ 19.40 $ $ $ 390.50 $ 2,986.75 $ 39.86 $ 3,476.51 $ 4,000.00 52-000-62-00-5419 MAINTENANCE-SANITARY $ $ (695.56) $ 6.99 $ 281.15 $ 450.00 $ - $ 13.78 $ 62.76 $ $ 119.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 $ 180.27 $ 1,229.24 $ 2,500.00 52-000-62-00-5422 LIFT STATION MAINTENP $ $ 310.50 $ $ 777.30 $ 37.88 $ 636.73 $ 1,647.63 $ 5.98 $ 4.09 $ 3,420.11 $ 15,000.00 52-000-62-00-5434 RENTAL-EQUIPMENI $ $ $ $ $ $ $ $ $ $ $ 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 $ 2,804.59 $ 13,268.00 $ 30,000.00 52-000-62-00-5438 CELLULAR TELEPHONE $ $ 87.23 $ 96.51 $ 91.78 $ 100.74 $ 143.07 $ 225.60 $ 112.85 $ 96.74 $ 954.52 $ 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) $ $ 287.77 $ 306.21 $ 1,800.00 52-000-65-00-5804 OPERATING SUPPLIES $ $ $ 19.07 $ $ $ 23.10 $ $ $ $ 42.17 $ 52-000-65-00-5805 SHOP SUPPLIES $ $ 268.20 $ 313.31 $ 273.95 $ 49.68 $ 168.03 $ 148.82 $ 239.34 $ 32.99 $ 1,494.32 $ 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 $ 2,495.73 $ 16,564.11 $ 26,000.00 52-000-65-00-5815 HAND TOOL $ $ $ $ $ $ $ $ $ $ $ 1,000.00 52-000-65-00-5817 GRAVEI $ $ $ $ $ $ $ $ $ $ $ 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 $ 1,486.99 $ 16,184.33 $ 21,949.00 52-000-72-00-6501 SOCIAL SECURITY&MEE $ 1,318.08 $ 1,292.33 $ 1,254.00 $ 1,919.84 $ 679.51 $ 2,009.54 $ 1,286.78 $ 2,009.17 $ 1,132.57 $ 12,901.82 $ 20,230.00 52-000-75-00-7002 COMPUTER EQUIP&SOFI $ $ $ $ $ $ $ $ $ $ $ 1,000.00 52-000-75-00-7003 OFFICE EQUIPMENT $ $ $ $ $ $ 4.99 $ $ $ $ 4.99 $ 500.00 52-000-75-00-7004 SAFETY EQUIPMENI $ $ 175.77 $ $ $ 995.00 $ $ $ $ 45.00 $ 1,215.77 $ 1,000.00 52-000-78-00-9099 BAD DEBI $ $ $ $ $ $ $ $ $ $ $ 52-000-99-00-9901 TRANSFER TO GENERAL F $ $ $ 20,761.25 $ $ $ 20,761.25 $ $ $ 20,761.25 $ 62,283.75 $ 83,045.00 TOTAL SEWER OPERATIONS REVENUES $ 114,960.03 $ 122,664.17 $ 1,002.22 $ 422,696.69 $ 654.54 $ 120,975.38 $ (491.57) $ 126,765.54 $ 178,183.49 $ $ $ $ 1,087,410.49 $ 606,800.00 TOTAL SEWER OPERATIONS E%PENSES $ 21,309.61 $ 20,502.60 $ 46,210.59 $ 37,343.45 $ 17,754.63 $ 54,782.71 $ 26,364.19 $ 41,924.96 $ 47,714.96 $ $ $ $ 313,907.70 $ 509,620.00 FUND SURPLUS(DEFICIT) $ 93,650.42 $ 102,161.57 $ (45,208.37) $ 385,353.24 $ (17,100.09) $ 66,192.67 $ (26,855.76) $ 84,840.55 $ 130,468.53 $ $ $ $ 773,502.79 $ 97,180.00 SEWER IMPROVEMENTS REVENUES 52-200-40-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-46-00-4600 INVESTMENT INCOME $ $ $ $ $ $ $ $ $ $ $ 52-200-48-00-4803 ROB ROY CREEK REVENUE n/a n/a n/a n/a n/a $ $ $ $ 106,000.00 $ 106,000.00 $ 100,000.00 SEWER IMPROVEMENTS EXPENSES 52-200-62-00-5401 CONTRACTUAL/PROF.SVC $ $ 13,877.05 $ $ $ $ $ $ $ $ 13,877.05 $ 52-200-62-00-5462 FOX HILL SEWER RECAP? $ $ $ $ $ $ $ $ $ $ $ 52-200-62-00-5463 LENNAR SEWER RECAPTUF $ $ $ $ $ $ $ 30,996.00 $ $ $ 30,996.00 $ 52-200-66-00-6003 2003A IRBB INTEREST F $ $ $ 36,826.25 $ $ $ $ $ $ 126,826.25 $ 163,652.50 $ 163,653.00 52-200-66-00-60042003A IRBB PRINC.PMI $ $ $ $ $ $ $ $ $ $ $ 52-200-66-00-6008 20048 PRINCIPAL PMT-C $ 51,650.00 $ $ $ $ $ $ $ 206,650.00 $ $ 258,300.00 $ 258,300.00 52-200-66-00-6011 2004A PRINCIPAL PMT-C $ $ 14,286.25 $ $ $ $ $ $ 174,286.25 $ $ 188,572.50 $ 188,572.00 52-200-66-00-60162005D INTEREST PMT-RC $ $ 192,975.00 $ $ $ $ $ $ 192,975.00 $ $ 385,950.00 $ 537,541.00 52-200-66-00-6017 20050 2M ALT RE% $ $ 20,175.00 $ $ $ $ $ $ $ $ 20,175.00 $ 82,850.00 52-200-66-00-6018 DEBT SERVICE $ 55,045.00 $ $ $ 55,045.00 $ $ 110,090.00 52-200-66-00-6050[EPA LOAN L17-01300( $ $ $ 19,489.99 $ $ - $ $ $ $ 19,489.99 $ 38,979.98 $ 38,980.00 52-200-66-00-6055 IEPA LOAN L17-11530( $ $ $ $ 53,525.35 $ $ $ $ $ $ 53,525.35 $ 107,051.00 52-200-66-00-6059 2007A BONG $ $ $ $ - $ $ $ $ 72,133.13 $ $ 72,133.13 $ 133,866.00 TOTAL SEWER IMPROVEMENT REVENUES $ 12,600.00 $ 3,600.00 $ 3,600.00 $ 1,800.00 $ 1,800.00 $ 5,400.00 $ 2,000.00 $ 1,800.00 $ 106,000.00 $ $ $ $ 138,600.00 $ 1,467,223.00 TOTAL SEWER IMPROVEMENT EXPENSES1$ 51,650.00 $ 296,358.30 $ 56,316.24 $ 53,525.35 $ $ $ 30,996.00 $ 701,089.35 $ 146,316.24 $ $ $ $ 1,336,251.51 $ 1,510,813.00 FUND SURPLUS(DEFICIT) $ (39,050.00) $ (292,758.30) $ (52,716.24) $ (51,725.35) $ 1,800.00 $ 5,400.00 $ (28,996.00) $ (699,289.38) $ (40,316.24) $ $ $ $ (1,197,651.51) $ (43,590.00) COMBINED SEWER IMPROVEMENT&OPERATIONS FUNDS TOTAL FUND REVENUES $ 127,560.03 $ 126,264.17 $ 4,602.22 $ 424,496.69 $ 2,454.54 $ 126,375.38 $ 1,508.43 $ 128,565.54 $ 284,183.49 $ $ $ $ 1,226,010.49 $ 2,074,023.00 TOTAL FUND EXPENSES $ 72,959.61 $ 316,860.90 $ 102,526.83 $ 90,868.80 $ 17,754.63 $ 54,782.71 $ 57,360.19 $ 743,014.34 $ 194,031.20 1$ $ $ $ 1,650,159.21 $ 2,020,433.00 FUND SURPLUS(DEFICIT) $ 54,600.42 1$ (190,596.73) $ (97,924.61)1$ 333,627.89 1$ (15,300.09)1$ 71,592.67 1$ (55,851.76) $ (614,448.80)1$ 90,152.29 1$ $ $ $ (424,148.72) $ 53,590.00 LAND CASH REVENUES 72-000-40-00-3999 BEGINNING FUND BALANC $ $ $ $ $ $ $ $ $ $ $ 69,641 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 HILL $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4706 WHEATON WOODS GRANT $ $ $ $ $ $ $ $ $ $ $ 30,000 72-000-47-00-4707 FOX HIGHLANDS $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4709 SUNFLOWEF $ $ $ $ 1$ 1$ $ $ $ $ $ 72-000-47-00-4712 RIVER'S EDGE $ $ $ $ 1$ 1$ $ $ 671.00 $ $ 671.00 $ 9 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUNC DATE OF REPORT/02-09-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-10 July-SO August-10 September-10 October-10 November-10 December-SO January-11 February-11 March-fl$YEAR-TO-DATE ANNUAL TOTALS BUDGET 72-000-47-00-4714 WOODWORTH $ 72-000-47-00-4715 WHITE OAK UNIT I&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 WILDWOOC $ $ $ $ $ $ $ $ $ $ 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(MENAF $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4736 BRIARWOOC $ $ $ $ $ $ $ $ $ $ $ 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 TOWNHOME! $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4740 VILLAS AT THE PRESER% $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4741 BAILEY MEADOW! $ $ $ $ $ $ $ $ $ $ $ 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 WESTBURN $ $ $ $ $ $ $ $ $ $ $ 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 ESTATE' $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4751 CANNONBALL RIDGE PARK $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4752 BRISTOL BAY LAND CASH $ $ $ 100,000.00 $ $ $ $ $ $ is 100,000.00 $ 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 PA5 $ $ $ $ $ $ $ $ $ $ $ 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 $ $ $ $ $ $ $ $ $ 28,000.00 $ 28,000.00 $ 495,000 72-000-75-00-7334 HOOVER HOLDING COSTS $ $ $ $ $ $ $ $ $ $ $ 72-000-75-00-7335 GRANDE RESERVE BIKE 1 $ $ $ $ $ $ $ $ $ $ $ 72-000-75-00-7336 WHEATON WOODS NATURE $ $ $ $ $ $ $ $ 2,118.00 $ 15.42 $ 2,133.42 $ 72-000-75-00-7337 BRISTOL BAY PARK A $ $ $ 662.51 $ 25,556.64 $ 54,892.70 $ 2,401.00 $ $ $ $ 83,512.85 $ 100,000 72-000-75-00-7339 BRISTOL BAY REGIONAL PARk $ $ - $ 1,420.00 $ 12,599.63 $ 14,019.63 72-000-99-00-9901 TRANSFER TO GENERAL F $ $ $ 15,112.25 $ $ $ 15,112.25 $ $ $ 15,112.25 $ 45,336.75 $ 60,449 TOTAL FUND REVENUES1$ 2,051.14 $ 2,051.14 $ 100,568.18 $ 2,051.14 $ 4,102.28 $ 6,153.42 $ $ 671.00 $ $ $ $ $ 117,648.30 $ 482,641.00 TOTAL FUND EXPENSES $ $ $ 15,774.76 $ 25,556.64 $ 54,892.70 $ 17,513.25 $ 10,000.00 $ 3,538.00 $ 55,727.30 $ $ $ $ 183,002.65 $ 665,449.00 FUND SURPLUS(DEFICIT) $ 2,051.14 $ 2,051.14 $ 84,793.42 $ (23,505.50) $ (50,790.42) $ (11,359.83) $ (10,000.00) $ (2,867.00) $ (55,727.30) $ $ $ $ (65,354.35) $ (182,808.00) PARK&RECREATION OPERATING REVENUES 79-000-40-00-3999 BEGINNING FUND BALANC $ $ $ $ $ $ $ $ $ $ $ 388 79-000-42-00-4270 FEES FOR PROGRAMS $ 8,942.50 $ 36,384.50 $ 13,856.00 $ 12,944.00 $ 6,887.00 $ 26,101.50 $ 17,347.80 $ 5,788.75 $ 5,187.42 $ 133,439.47 $ 225,000 79-000-42-00-4280 CONCESSIONS/ALL SALE $ 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 MACHINE INCOM $ $ $ $ $ $ $ $ $ $ $ 79-000-42-00-4286 RENTAL INCOME $ $ $ $ $ $ $ $ $ $ $ 79-000-42-00-4287 PARK RENTAL INCOME $ 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 REVENUE $ $ $ $ $ $ $ $ $ $ $ 9,000 79-000-42-00-4291 HOMETOWN DAYS $ 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 $ 684.00 $ 4,817.00 $ 14,000 79-000-44-00-4404 TREE DONATION! $ $ $ $ $ 350.00 $ 350.00 $ 225.00 $ $ $ 925.00 $ 600 79-000-44-00-4412 INSURANCE REIMBURSEMENTS $ 5,156.53 $ 5,156.53 $ 79-000-44-00-4490 MISCELLANEOUS INCOME $ $ 79-000-45-00-4550 YOUTH SERVICES GRANI $ $ $ $ $ $ $ $ $ $ $ 500 79-000-46-00-4600 INVESTMENT INCOME $ 13.11 $ 22.97 $ 27.95 $ 32.92 $ 26.80 $ 31.17 $ 28.11 $ 23.32 $ 25.48 $ 231.83 $ 500 79-000-49-00-4901 TRANSFER FROM GENERAL $ 35,914.50 $ 35,914.50 $ 35,914.50 $ 35,914.50 $ 35,914.50 $ 35,914.50 $ 35,914.50 $ 35,914.50 $ 35,914.50 $ 323,230.50 $ 430,974 79-000-49-00-4902 TRANSFER IN FROM GF $ 100,000.00 $ $ $ $ $ $ $ $ $ 100,000.00 $ 100,000 79-000-49-00-4903 TRANSFER FROM GENERAL $ 43,409.66 $ 43,409.66 $ 43,409.66 $ 43,409.66 $ 43,409.66 $ 43,409.66 $ 43,409.66 $ 43,409.66 $ 43,409.66 $ 390,686.94 $ 520,916 TOTAL PARKS&RECREATION REVENUES1$ 201,828.52 1$ 132,799.89 1$ 116,600.111$ 102,348.58 1$ 192,153.36 1$ 113,629.33 1$ 96,986.07 1$ 86,256.23 1$ 90,377.59 1$ $ $ $ 1,132,979.68 $ 1,480,378.00 10 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUNC DATE OF REPORT/02-09-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-30 June-30 July-30 August-10 September-10 October-10 November-10 December-SO January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 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 $ 27,574.05 $ 261,128.37 $ 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 $ $ $ $ 241.37 $ $ $ $ 483.19 $ 4,000 79-610-62-00-5405 PARK CONTRACTUAL $ $ $ $ $ $ 2,025.00 $ 120.00 $ $ 160.00 $ 2,305.00 $ 2,000 79-610-62-00-5408 MAINTENANCE-EQUI PM ENI $ 641.43 $ 473.35 $ 91.92 $ 1,332.52 $ 1,438.89 $ 1,508.67 $ 1,283.42 $ 57.98 $ 5,985.75 $ 12,813.93 $ 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 $ 235.92 $ 14,840.45 $ 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 $ 639.18 $ 2,376.05 $ 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 $ 125.12 $ 1,187.53 $ 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 $ $ 29.00 $ 79.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 $ 267.67 $ 7,469.14 $ 20,000 79-610-65-00-5815 HAND TOOL $ $ $ 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 $ 2,622.28 $ 23,956.33 $ 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 $ 2,034.30 $ 20,518.76 $ 28,383 79-610-75-00-7002 COMPUTER EQUIP&SOFI $ $ $ $ $ $ $ $ $ $ $ 500 79-610-75-00-7003 OFFICE EQUIPMENT $ $ $ $ $ $ $ $ $ $ $ 500 79-610-75-00-7701 FLOWERS/TREES $ $ 473.21 $ $ $ $ $ $ $ $ 473.21 $ 500 TOTAL PARK EXPENSES(FUND 79) $ 35,456.71 $ 38,183.36 $ 39,414.07 $ 69,624.29 $ 18,781.59 $ 54,425.58 $ 34,542.43 $ 34,618.74 $ 39,673.27 $ $ $ $ 364,720.04 $ 524,712.00 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 $ 19,587.16 $ 204,075.82 $ 368,532 79-650-50-00-5108 CONCESSION STAFF $ 2,675.50 $ 2,482.00 $ 2,192.79 $ 777.00 $ $ 222.75 $ 90.75 $ $ $ 8,440.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 $ 1,640.00 $ 14,302.46 $ 20,000 79-650-50-00-5136 SALARIES-PARTTIME $ 1,250.00 $ 1,250.00 $ 1,250.00 $ 1,875.00 $ 625.00 $ 1,782.88 $ 249.38 $ 238.88 $ 416.25 $ 8,937.39 $ 22,080 79-650-50-00-5137 SALARIES-OVERTIME $ $ $ $ $ $ $ $ $ $ $ 300 79-650-50-00-5150 SALARIES-INSTRUCTOF $ 1,087.50 $ 1,839.51 $ 2,372.75 $ 2,714.89 $ 2,267.75 $ 3,603.02 $ 2,429.79 $ 540.26 $ 794.69 $ 17,650.16 $ 16,000 79-650-50-00-5155 SALARIES-RECORDING S $ $ 227.51 $ 237.50 $ $ 280.88 $ 91.00 $ 91.00 $ $ $ 927.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 $ 2,230.80 $ 30,415.09 $ 50,000 79-650-62-00-5408 MAINTENANCE SUPPLIES $ $ 77.04 $ 62.70 $ $ 104.11 $ $ 69.03 $ 99.50 $ $ 412.38 $ 2,000 79-650-62-00-5409 MAINTENANCE-VEHICLES $ $ $ 809.41 $ 49.32 $ 351.01 $ 93.00 $ $ $ 84.49 $ 1,387.23 $ 1,000 79-650-62-00-5410 MAINTENANCE-OFFICE EC $ $ 250.24 $ 242.18 $ 239.48 $ 178.00 $ 178.00 $ 283.97 $ 188.26 $ 216.27 $ 1,776.40 $ 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 $ 1,827.41 $ 14,794.24 $ 22,000 79-650-62-00-5437 TELEPHONE/INTERNET $ $ $ 342.08 $ 341.40 $ 340.22 $ 339.15 $ 336.04 $ 337.14 $ 335.11 $ 2,371.14 $ 1,300 79-650-62-00-5438 CELLULAR TELEPHONE $ $ 174.47 $ 193.02 $ 183.56 $ 201.47 $ 144.61 $ 141.42 $ 149.28 $ 125.12 $ 1,312.95 $ 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 $ $ 420.00 $ 680.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 $ 137.80 $ 1,848.51 $ 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 $ 9,205.94 $ 43,156.46 $ 53,600 79-650-65-00-5804 OPERATING SUPPLIES $ $ 7.47 $ $ 163.33 $ $ 1.47 $ $ 13.47 $ 12.70 $ 198.44 $ 1,000 79-650-65-00-5805 RECREATION EQUIPMENI $ $ $ $ $ $ $ $ $ $ $ 2,000 79-650-65-00-5808 POSTAGE&SHIPPING $ 800.00 $ $ 1,173.00 $ 800.00 $ $ 177.00 $ 1,796.00 $ $ 177.00 $ 4,923.00 $ 8,000 79-650-65-00-5812 GASOLINE $ $ 137.64 $ 286.71 $ 273.75 $ 288.32 $ 154.97 $ 112.64 $ 78.23 $ 117.95 $ 1,450.21 $ 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 $ $ $ 355.30 $ 99,902.83 $ 100,000 79-650-65-00-5840 SCHOLARSHIPS $ $ $ 150.00 $ $ $ 71.00 $ $ $ $ 221.00 $ 1,000 79-650-65-00-5841 PROGRAM REFUNC $ 346.00 $ 270.00 $ 619.00 $ 417.00 $ 195.00 $ 432.00 $ 132.00 $ 198.00 $ 153.00 $ 2,762.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 $ 1,862.74 $ 19,565.12 $ 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 $ 1,699.42 $ 19,147.60 $ 30,351 79-650-75-00-7002 COMPUTER EQUIP&SOF1 $ $ 1,682.00 $ $ 918.00 $ $ $ $ $ $ 2,600.00 $ 2,600 79-650-78-00-9010 MISC RETAIL $ $ $ $ $ $ $ $ $ $ $ 31000 79-650-99-00-9941 REPAYMENT OF GF LOAN, $ $ $ $ $ $ $ $ $ $ $ 100,000 TOTAL RECREATION EXPENSES(FUND 79) $ 41,378.04 1$ 47,528.47 1$ 98,031.77 1$ 80,273.74 1$ 62,997.94 1$ 63,694.90 1$ 37,127.27 1$ 64,312.15 1$ 41,399.15 1$ $ $ $ 536,743.43 $ 937,200.00 TOTAL FUND REVENUES1$ 201,828.52 $ 132,799.89 $ 116,600.11 $ 102,348.58 $ 192,153.36 $ 113,629.33 $ 96,986.07 $ 86,256.23 $ 90,377.59 $ $ $ $ 1,132,979.68 $ 1,480,378.00 TOTAL FUND EXPENSES $ 76,834.75 $ 85,711.83 $ 137,445.84 $ 149,898.03 $ 81,779.53 $ 118,120.48 $ 71,669.70 $ 98,930.89 $ 81,072.42 $ $ $ $ 901,463.47 $ 1,461,912.00 FUND SURPLUS(DEFICIT) $ 124,993.77 $ 47,088.06 1$ (20,845.73) $ (47,549.45)1$ 110,373.83 1$ (4,491.15)1$ 25,316.37 1$ (12,674.66)1$ 9,305.17 1$ $ $ $ 231,516.21 $ 18,466.00 11 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUNC DATE OF REPORT/02-09-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-30 June-30 July-30 August-10 September-10 October-10 November-10 December-SO January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET REC CENTER REVENUES 80-000-40-00-3999 CARRY OVER BALANCE $ $ $ $ $ $ $ $ $ $ $ (61,067) 00 80-000-42-00-4200 MEMBERSHIP FEES $ 30,448. $ 34,608.82 $ 30,919.00 $ 31,053.00 $ 30,963.00 $ 30,707.00 $ 34,959.00 $ 36,209.00 $ 39,855.05 $ 299,721.87 $ 410,000 80-000-42-00-4210 GUEST FEES $ 356.00 $ 506.00 $ 411.00 $ 423.00 $ 335.00 $ 214.00 $ 480.00 $ 751.00 $ 620.00 $ 4,096.00 $ 3,500 80-000-42-00-4220 SWIM CLASS $ 1,388.00 $ 7,082.25 $ 4,821.50 $ 1,154.00 $ 1,760.00 $ 1,392.00 $ 2,045.25 $ 768.00 $ 1,415.75 $ 21,826.75 $ 35,000 80-000-42-00-4230 PERSONAL TRAINING FEE $ 1,002.00 $ 915.00 $ 476.00 $ 40.00 $ 1,338.00 $ 257.00 $ 728.00 $ 698.00 $ 1,245.00 $ 6,699.00 $ 15,000 80-000-42-00-4240 TANNING SESSIONS $ 239.00 $ 115.00 $ 142.00 $ 43.00 $ 180.00 $ 40.00 $ 77.00 $ 85.00 $ 110.00 $ 1,031.00 $ 2,500 80-000-42-00-4270 FEES FOR PROGRAMS $ 8,902.00 $ 7,102.50 $ 4,183.50 $ 20,286.00 $ 12,368.00 $ 12,155.70 $ 9,058.00 $ 9,387.50 $ 14,360.44 $ 97,803.64 $ 125,000 80-000-42-00-4280 CONCESSIONS $ 1,126.75 $ 1,903.75 $ 1,443.00 $ 900.75 $ 923.75 $ 988.25 $ 1,034.50 $ 1,177.50 $ 1,373.75 $ 10,872.00 $ 12,000 80-000-42-00-4286 RENTAL INCOME $ 401.00 $ 70.00 $ 14.00 $ 359.50 $ 1,278.25 $ 209.00 $ 593.00 $ 285.50 $ 2,088.00 $ 5,298.25 $ 3,000 80-000-42-00-4295 MISC RETAIL $ $ $ $ 209.50 $ 77.00 $ 78.00 $ 46.00 $ 26.50 $ 111.45 $ 548.45 $ 500 80-000-44-00-4400 DONATIONS/SPONSORSHIP $ - $ 170.00 $ 90.00 $ $ - $ - $ 156.50 $ 90.00 $ 270.00 $ 776.50 $ 2,000 80-000-45-00-4550 GRANTS/SCHOLARSHIPS $ $ $ $ $ $ $ $ $ $ $ 500 TOTAL REC CENTER REVENUES1$ 43,862.75 1$ 52,473.32 1$ 42,500.00 1$ 54,468.75 1$ 49,273.00 1$ 46,040.95 1$ 49,177.25 1$ 49,478.00 1$ 61,449.44 1$ $ $ $ 445,673.46 $ 547,933.00 REC CENTER EXPENSES 80-000-50-00-5107 SALARIES-REC CENTEF $ 2,630.78 $ 2,630.77 $ 2,630.77 $ 3,946.14 $ 1,315.39 $ 3,946.14 $ 1,973.08 $ 2,630.77 $ 2,630.78 $ 24,334.62 $ 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 $ 3,346.28 $ 24,274.25 $ 35,000 80-000-50-00-5136 SALARIES-PARTTIME $ 7,760.13 $ 7,359.50 $ 6,294.88 $ 11,289.45 $ 3,410.63 $ 9,983.09 $ 8,214.09 $ 8,002.82 $ 7,951.76 $ 70,266.35 $ 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 $ 3,513.38 $ 41,404.78 $ 65,000 80-000-62-00-5401 CONTRACTUAL SERVICES $ $ $ $ 8,895.00 $ $ 3,263.00 $ 1,187.20 $ $ 3,755.50 $ 17,100.70 $ 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 $ 1,420.44 $ 7,750.35 $ 11,000 80-000-62-00-5410 MAINTENANCE-OFFICE E $ $ 240.71 $ 259.26 $ 300.65 $ 270.19 $ 223.00 $ 329.41 $ 266.75 $ 313.30 $ 2,203.27 $ 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 $ 1,211.06 $ 7,347.12 $ 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 $ 190.00 $ 4,313.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 $ 18,000.00 $ 179,000.00 $ 216,000 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 $ 2,992.54 $ 30,526.12 $ 28,000 80-000-62-00-5437 TELEPHONE/INTERNET/CF $ $ 116.54 $ 315.45 $ 318.75 $ 398.35 $ 318.15 $ 317.60 $ 324.03 $ 320.38 $ 2,429.25 $ 1,750 80-000-62-00-5438 CELLULAR PHONE $ $ 29.08 $ 32.17 $ 30.59 $ 33.58 $ 28.92 $ 28.28 $ 29.86 $ 25.02 $ 237.50 $ 600 80-000-62-00-5439 PROPERTY TAY $ 26,839.85 $ $ 26,839.85 $ $ $ $ $ $ $ 53,679.70 $ 53,000 80-000-62-00-5440 SECURITY $ $ 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 $ $ $ $ $ $ $ $ $ $ $ 200 80-000-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ $ $ $ $ 80-000-64-00-5605 TRAVEL EXPENSES $ $ $ $ $ $ $ $ $ $ $ 80-000-65-00-5802 OFFICE SUPPLIES $ $ $ 634.11 $ 456.22 $ $ $ $ $ 8.75 $ 1,099.08 $ 2,600 80-000-65-00-5803 PROGRAM EXPENSES $ 746.96 $ 1,094.78 $ 1,420.45 $ 1,727.69 $ 1,627.07 $ 1,584.99 $ 1,941.51 $ 1,839.67 $ 1,494.96 $ 13,478.08 $ 17,000 80-000-65-00-5804 OPERATING SUPPLIES $ $ 84.00 $ 42.79 $ 201.59 $ $ 399.00 $ 91.71 $ $ $ 819.09 $ 3,000 80-000-65-00-5805 RECREATION EQUIPMENT $ $ $ 61.51 $ $ $ 60.00 $ $ $ 5,198.09 $ 5,319.60 $ 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 $ 207.63 $ 909.66 $ 590.54 $ 941.84 $ 409.35 $ 442.84 $ 804.40 $ 6,908.54 $ 6,000 80-000-65-00-5840 SCHOLARSHIPS $ $ $ 17.50 $ $ $ 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 $ 713.00 $ 5,261.50 $ 4,000 80-000-65-00-5842 MEMBERSHIP REFUNDS $ $ 103.00 $ 85.00 $ 149.00 $ 65.00 $ 58.00 $ 38.00 $ $ 122.00 $ 620.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 $ 895.64 $ 7,930.29 $ 10,000 80-000-72-00-6501 SOCIAL SECU RITY $ 1,292.76 $ 1,117.75 $ 1,089.80 $ 1,832.52 $ 610.50 $ 2,063.76 $ 1,429.38 $ 1,397.83 $ 1,322.71 $ 12,157.01 $ 17,658 80-000-75-00-7002 COMPUTER EQUIP&SOFI $ $ 1,182.00 $ $ 1,995.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,806.47 $ 6,865.21 $ 11,000 80-000-78-00-9010 MISC RETAIL $ $ $ $ $ $ $ $ $ $ $ 300 TOTAL REC CENTER EXPENSES $ 86,167.03 $ 47,032.15 $ 70,610.29 $ 70,440.07 $ 41,501.41 $ 61,227.79 $ 51,104.56 $ 46,058.35 $ 60,036.46 $ $ $ $ 534,178.11 $ 675,301.00 TOTAL FUND REVENUES $ 43,862.75 $ 52,473.32 $ 42,500.00 $ 54,468.75 $ 49,223.00 $ 46,040.95 $ 49,177.25 $ 49,478.00 $ 61,449.44 $ $ $ $ 448,673.46 $ 547,933.00 TOTAL FUND EXPENSES $ 86,167.03 $ 47,032.15 $ 70,610.29 $ 70,440.07 $ 41,501.41 $ 61,227.79 $ 51,104.56 $ 46,058.35 $ 60,036.46 $ $ $ $ 534,178.11 $ 675,301.00 FUND SURPLUS(DEFICIT)1$ (42,304.28)1$ 5,441.17 1$ (28,110.29) $ (15,971.32)1$ 7,721.59 1$ (15,186.84) $ (1,927.31)1$ 3,419.65 1$ 1,412.95 1$ $ 1$ 11$ (85,504.65) $ (127,368.00) LIBRARY REVENUES 82-000-40-00-3992 LIBRARY BOND PROP.TP $ $ 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-3997 CARRY OVER-BLDG DE% $ $ $ $ $ $ $ $ $ $ $ 310,958.00 82-000-40-00-3999 CARRY OVER-FUND BAI $ $ $ $ $ $ $ $ $ $ $ 488,103.00 12 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUNC DATE OF REPORT/02-09-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-30 July-30 August-10 September-10 October-30 November-10 December-30 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 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 TA} $ 923.01 $ 646.74 $ 656.91 $ 86.26 $ $ 1,265.56 $ $ 1,020.86 $ 523.16 $ 5,122.50 $ 5,000.00 82-000-42-00-4211 DEVELOPMENT FEES-BL $ 2,125.00 $ $ $ $ 2,525.00 $ $ 3,425.00 $ $ $ 8,075.00 $ 20,000.00 82-000-42-00-4215 DEVELOPMENT FEES-BC $ 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 $ 365.65 $ 2,586.35 $ 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 $ 1,500.00 $ 9,532.50 $ 15,000.00 82-000-42-00-4262 EXAM PROCTORING $ $ $ $ $ $ 5.00 $ $ $ 35.00 $ 40.00 $ 82-000-42-00-4286 DVD RENTAL INCOME $ $ $ $ $ 566.00 $ 530.00 $ 532.00 $ 447.00 $ 565.00 $ 2,640.00 $ 82-000-42-00-4287 LIBRARY BLDG RENTAL $ 270.00 $ 90.00 $ 120.00 $ 120.00 $ 100.00 $ 80.00 $ 50.00 $ $ 150.00 $ 980.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 $ 1,531.46 $ 10,569.31 $ 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 $ 4.50 $ 300.15 $ 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 $ $ $ $ $ $ $ $ $ $ $ M 0 LIBRARY PER CAPITA GS $ $ $ $ $ $ $ $ 17,193.28 $ 17,193.28 $ 17,500.00 600 INVESTMENT INCOME $ 117.54 $ 103.98 $ 138.27 $ 95.19 $ 30.12 $ 33.33 $ 47.25 $ 40.53 $ 26.27 $ 632.48 1$ 10,000.00 TOTAL LIBRARY REVENUES1$ 8,571.011$ 99,984.45 1$ 497,038.44 1$ 3,772.93 1$ 136,405.37 1$ 474,750.011$ 43,241.02 1$ 91,226.97 1$ 4,701.04 1$ $ $ $ 1,319,691.24 $ 2,158,985.00 LIBRARY EXPENSES 82-000-50-00-5107 SALARIES-LIBRARY $ 39,538.14 $ 37,589.76 $ 36,942.16 $ 57,504.02 $ 18,617.36 $ 58,980.12 $ 39,696.85 $ 39,126.52 $ 37,497.76 $ 365,492.69 $ 650,000.00 82-000-50-00-5203 GROUP HEALTH INSURANC $ $ 7,034.94 $ 7,034.94 $ 7,034.94 $ 7,034.94 $ 7,034.94 $ 7,034.94 $ 7,034.94 $ 7,034.94 $ 56,279.52 $ 70,000.00 82-000-50-00-5204 GROUP LIFE INSURANCE $ $ 103.35 $ 103.35 $ 103.35 $ 103.35 $ 103.35 $ 103.35 $ 103.35 $ 103.35 $ 826.80 $ 2,000.00 82-000-50-00-5205 DENTAL&VISION ASSIS $ $ 513.27 $ 513.27 $ 513.27 $ 513.27 $ 513.27 $ 513.27 $ 513.27 $ 513.27 $ 4,106.16 $ 6,000.00 82-000-61-00-5322 BONDING $ $ 1,839.00 $ $ 1,383.00 $ $ $ $ $ $ 3,222.00 $ 5,000.00 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 $ 2,967.02 $ 18,122.82 $ 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 $ 371.72 $ 17,183.31 $ 30,000.00 82-000-62-00-5410 MAINTENANCE-OFFICE EC $ $ $ $ 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 $ $ $ $ $ $ $ $ $ $ $ 8,000.00 82-000-62-00-5436 TELEPHONE $ $ 683.17 $ 693.42 $ 1,316.99 $ 688.81 $ 687.11 $ 866.12 $ 430.73 $ 692.06 $ 6,058.41 $ 8,000.00 82-000-62-00-5437 NICOR GAS $ $ $ 471.80 $ 127.71 $ 129.08 $ 127.34 $ 631.44 $ 538.58 $ 1,291.28 $ 3,317.23 $ 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 $ $ 900.10 $ 5,000.00 82-000-64-00-5607 PUBLIC RELATIONS $ $ $ $ $ $ $ $ $ $ $ 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 $ 525.28 $ 5,965.35 $ 144,561.00 82-000-65-00-5802 OFFICE SUPPLIES $ $ 822.46 $ 524.66 $ $ 803.84 $ 1,205.34 $ $ $ 533.94 $ 3,890.24 $ 15,000.00 82-000-65-00-5806 LIBRARY SUPPLIES $ $ $ 216.10 $ 48.20 $ 170.58 $ 580.67 $ 1,314.29 $ 653.40 $ 215.94 $ 3,199.18 $ 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 $ 510.34 $ 5,747.14 $ 20,000.00 82-000-65-00-5808 POSTAGE&SHIPPING $ $ 47.14 $ 4.89 $ 452.38 $ 45.28 $ 41.48 $ 24.83 $ 493.96 $ 9.37 $ 1,119.33 $ 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 $ $ $ 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 $ 476.75 $ 5,180.89 $ 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 $ 511.89 $ 6,142.67 $ 20,000.00 82-000-65-00-5835 LIBRARY BOARD EXPENSE $ $ $ $ $ $ $ $ $ $ $ 2,000.00 82-000-65-00-5836 BOOKS-ADULT $ $ 1,634.80 $ 2,831.89 $ 2,226.66 $ 2,972.97 $ 5,080.94 $ 4,037.53 $ 2,657.04 $ 115.27 $ 21,557.10 $ 50,000.00 82-000-65-00-5837 BOOKS-JUVENILE $ $ 3,808.55 $ 3,485.89 $ 3,616.94 $ 3,725.53 $ 2,064.68 $ 3,172.29 $ 8,899.32 $ 5,968.78 $ 34,741.98 $ 50,000.00 82-000-65-00-5838 BOOKS-AUDIC $ $ 842.64 $ 220.93 $ 107.97 $ 1,252.65 $ 795.23 $ 326.92 $ 636.66 $ 574.86 $ 4,757.86 $ 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 $ 929.20 $ 8,651.66 $ 20,000.00 82-000-65-00-5841 MEMORIALS/GIFTS $ $ 752.41 $ $ $ 317.33 $ $ 346.24 $ 85.52 $ 30.00 $ 1,531.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 $ $ $ $ $ $ $ 800.00 $ $ $ 800.00 $ 1,000.00 82-000-66-00-6012 2005B LIBRARY BONC $ $ 159,562.51 $ $ $ $ $ $ 234,562.51 $ $ 394,125.02 $ 394,125.00 82-000-66-00-6014 2006 LIBRARY BONE $ $ 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 $ 1,761.50 $ 15,878.94 $ 22,000.00 82-000-72-00-6501 SOCIAL SECURITY/ME51C $ 2,974.12 $ 2,825.03 $ 2,775.50 $ 4,323.28 $ 1,398.95 $ 4,461.49 $ 2,986.34 $ 2,942.59 $ 2,818.02 $ 27,505.32 $ 55,000.00 82-000-75-00-7002 COMPUTER EQUIPMENT& $ $ $ 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 $ 33,131.36 $ 41,482.54 $ 40,000.00 82-000-75-00-7703 BUILDING EXPANSION $ $ 6,199.55 $ $ $ $ $ $ $ $ 6,199.55 $ 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 $ 98,583.90 $ $ $ $ 1,309,314.19 $ 2,158,986.00 TOTAL FUND REVENUES1$ 8,571.01 $ 99,984.45 $ 497,038.44 $ 3,772.93 $ 136,405.37 $ 474,750.01 $ 43,241.02 $ 51,226.97 $ 4,701.04 $ $ $ $ 1,319,691.24 $ 2,158,985.00 TOTAL FUND 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 $ 98,583.90 $ $ $ $ 1,309,314.19 $ 2,158,986.00 FUND SURPLUS(DEFICIT)l$ (36,704.25) $ (170,732.35)1$ 423,346.03 1$ (93,792.57)1$ 86,706.12 1$ 373,644.96 1$ (31,783.64) $ (446,424.39) $ (93,882.86) $ 1$ 1$ 11$ 10,377.05 1$ (1.00) FOX INDUSTRIAL REVENUES 13 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUNC DATE OF REPORT/02-09-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-10 July-SO August-10 September-10 October-10 November-10 December-SO January-11 February-11 March-11 11p61-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 85-000-40-00-3999 BEGINNING FUND BALANC $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 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 $ 1.36 1 13.49 $ 50.00 FOX INDUSTRIAL EXPENSES 85-000-66-00-6021 FOX IND BOND-PRINCIPP $ 4,966.25 $ $ $ $ $ $ 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-78-00-9007 ADMINISTRATION FEES $ $ 116.25 $ 92.50 $ $ $ - $ $ $ 222.00 $ 430.75 $ 500.00 TOTAL FUND REVENUES $ 1.13 $ 107,260.89 $ 24,293.22 $ 3,479.58 $ 83,116.02 $ 5,772.42 $ 4,433.87 $ 1.47 $ 1.36 $ $ $ $ 228,359.96 $ 640,924.00 TOTAL FUND EXPENSES $ 4,966.25 $ 116.25 $ 92.50 $ $ $ $ 74,966.25 $ $ 222.00 $ $ $ $ 80,363.25 $ 80,433.00 FUND SURPLUS(DEFICIT) $ (4,965.12) $ 107,144.64 $ 24,200.72 $ 3,479.58 $ 83,116.02 $ 5,772.42 $ (70,532.38) $ 1.47 $ (220.64) $ $ $ $ 147,996.71 $ 560,491.00 POLICE PENSION REVENUES 86-000-46-00-4600 INTEREST INCOME $ 3.22 $ 1.14 $ 1.39 $ 8.41 $ 11.73 $ 12.60 $ 11.75 $ 6.84 $ 6.14 $ 63.22 $ - 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 $ 13,888.62 $ 131,244.19 $ POLICE PENSION EXPENSES 86-000-50-00-5108 SALARIES-POLICE PENSI $ 37,906.39 $ 22,329.02 $ 22,773.95 $ 22,773.95 $ 22,773.95 $ 22,773.95 $ 22,773.95 $ 22,773.95 $ 22,935.59 $ 219,814.70 $ 86-000-50-00-5200 CONTRIBUTION REFUNC - TOTAL FUND REVENUES $ 13,641.98 $ 13,723.37 $ 13,779.41 $ 13,711.24 $ 13,794.64 $ 20,337.25 $ 14,031.39 $ 14,393.37 $ 13,894.76 $ $ $ $ 131,307.41 $ TOTAL FUND EXPENSES $ 37,906.39 $ 22,329.02 $ 22,773.95 $ 22,773.95 $ 22,773.95 $ 22,773.95 $ 22,773.95 $ 22,773.95 $ 22,935.59 $ $ $ $ 219,814.70 $ FUND SURPLUS(DEFICIT) $ (24,264.41) $ (8,605.65) $ (8,994.54) $ (9,062.71) $ (8,979.31) $ (2,436.70) $ (8,742.56) $ (8,380.58) $ (9,040.83) $ $ $ $ (88,507.29) $ COUNTRYSIDE TIF REVENUES 87-000-40-00-3999 BEGINNING FUND BALANC $ $ $ $ $ - $ $ $ $ $ $ 2,475,639.00 87-000-40-DO-4090TIF REVENUES $ $ 3,058.20 $ 127.42 $ $ 3,153.76 $ 31.86 $ 0.61 $ $ $ 6,371.85 $ 6,250.00 87-000-46-00-4600 INVESTMENT INCOME $ 498.76 1$ 499.01 $ 456.60 $ 394.26 $ 394.32 $ 407.53 $ 220.21 $ 220.27 $ $ 3,090.96 $ 6,104.00 COUNTRYSIDE TIF EXPENSES 87-000-66-00-6002 COUNTRYSIDE TIF-INTEP $ $ $ $ $ $ $ $ $ $ $ 87-000-66-00-6022 BOND-INT PAYMENT $ 68,546.25 $ $ $ $ $ $ 238,546.25 $ $ $ 307,092.50 $ 307,093.00 87-000-78-00-9007 ADMINISTRATION FEES $ - $ 116.25 $ 92.50 $ $ $ $ $ $ $ 208.75 $ 1,000.00 87-000-78-00-9009 RESERVE $ $ $ $ $ $ $ $ $ $ $ 87-000-78-00-9010 RESERVE-FUTURE BONE $ $ $ $ $ $ $ $ $ $ $ 2,179,900.00 TOTAL FUND REVENUES $ 498.76 $ 3,557.21 $ 584.02 $ 394.26 $ 3,548.08 $ 439.39 $ 220.82 $ 220.27 $ $ $ $ $ 9,462.81 $ 2,487,993.00 TOTAL FUND EXPENSES $ 68,546.25 $ 116.25 $ 92.50 $ $ $ $ 238,546.25 $ $ $ $ $ $ 307,301.25 $ 2,487,993.00 FUND SURPLUS(DEFICIT) $ (68,047.49) $ 3,440.96 $ 491.52 $ 394.26 $ 3,548.08 $ 439.39 $ (238,325.43) $ 220.27 $ $ $ $ $ (297,838.44) $ DOWNTOWN TIF REVENUES 88-000-40-00-3999 BEGINNING FUND BALANC $ $ $ $ $ $ $ $ $ - $ $ 136,663.00 58-000-40-00-4090 TIF REVENUES $ $ 40,820.24 1$ 1,720.46 $ 1,758.58 $ 20,840.99 $ 4,567.75 $ 5,653.65 $ $ 75,361.67 $ 88,550.00 DOWNTOWN TIF EXPENSES 88-000-78-00-9007 ADMINISTRATIVE FEES $ $ 116.25 $ $ $ 500.00 $ $ $ 46.25 $ 662.50 $ 1,500.00 88-000-78-00-9010 RESERVE $ - $ - $ 194.25 $ - $ - $ $ $ $ 194.25 $ - TOTAL FUND REVENUES $ $ 40,820.24 $ 1,720.46 $ 1,758.58 $ 20,840.99 $ 4,567.75 $ 5,653.65 $ $ $ $ $ $ 75,361.67 $ 225,213.00 TOTAL FUND EXPENSES $ $ 116.25 $ 194.25 $ $ 500.00 $ $ $ 46.25 $ $ $ $ $ 856.75 $ 1,500.00 FUND SURPLUS(DEFICIT) $ $ 40,703.99 $ 1,526.21 $ 1,758.58 $ 20,340.99 $ 4,567.75 $ 5,653.65 $ (46.25) $ $ $ $ $ 74,504.92 $ 223,713.00 14 of 14 c/Ty Reviewed By: Agenda Item Number ii J� a 0-0 Legal ❑ NB #2 II Finance ■ EST. , � 1836 Engineer ❑ Tracking Number y City Administrator ❑ Consultant ❑ ADM 2011-05 dal County El`E Agenda Item Summary Memo Title: Treasurer's Report for January 2011 Meeting and Date: Administration Committee 2/17/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: UNITED CITY OF YORKVILLE TREASURER'S REPORT-for the period ended January 31,2011 Cash Basis Projected BGN Fund January Revenues %of YTD January Expenses %of YTD Ending Fund Balance Revenues YTD Revenues Budget Budget Expenses YTD Expenses Budget Budget Balance General Fund O1-General (492,939) 816,520 9,044,395 11,433,024 79% 1,226,111 8,505,525 11,376,981 75% 45,932 Library Fund 82-Library 571,002 4,701 1,319,691 2,158,985 61% 98,584 1,309,314 2,158,986 61% 581,379 Special Revenue Funds 15-Motor Fuel Tax 405,618 36,341 486,166 356,000 137% 42,007 204,662 475,600 43% 687,122 79-Parks and Recreation 25,151 90,378 1,132,980 1,479,990 77% 81,072 901,463 1,461,912 62% 256,667 72-Land Cash (603,425) - 117,648 413,000 28% 55,727 183,003 665,449 28% (668,779) 85-Fox Industrial TIF 423,351 1 228,360 216,727 105% 222 80,363 80,433 100% 571,348 87-Countryside TIF 2,477,758 9,463 12,354 77% - 307,301 308,093 100% 2,179,920 88-Downtown TIF 136,294 75,362 88,550 85% 857 1,500 57% 210,799 11-Fox Hill SSA 2,226 19,894 19,463 102% 3,786 3,458 109% 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 107,351 322,953 429,404 75% 429,404 429,404 100% (98,823) Capital Funds 16-Municipal Building (607,724) - 19,950 (552,474) -4% - - - - (587,774) 22-Park and Rec Equipment Capital 66,852 7 1,710 210,960 1% 592 17,431 173,135 10% 51,131 20-Police Equipment Capital 210,284 813 24,956 62,000 40% 105 49,380 104,000 47% 185,860 21-Public Works Equipment Capital 157,807 1,343 24,984 35,000 71% 6,858 67,017 139,000 48% 115,775 23-City-Wide Equipment Capital (18,378) 40,627 140,487 421,500 33% - 201,104 606,500 33% (78,995) Enterprise Funds 51-Water 339,360 9,246 1,784,687 2,122,354 84% 176,265 1,737,962 2,122,677 82% 386,085 52-Sewer 2,735,211 284,183 1,226,010 881,800 139% 194,031 1,650,159 2,020,433 82% 2,311,062 80-Recreation Center (127,815) 61,449 448,673 609,000 74% 60,036 534,178 675,301 79% (213,320) Total Funds 5,714,449 1,452,960 16,442,242 20,416,707 1,941,612 16,190,440 22,811,115 5,966,251 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 c/Ty Reviewed By: Agenda Item Number ii J� a 0-0 Legal ❑ NB #3 II Finance ■ EST. , � 1836 Engineer ❑ Tracking Number y City Administrator ❑ Consultant ❑ ADM 2011-06 dal County El`E Agenda Item Summary Memo Title: Annual Treasurer's Report for Fiscal Year 2009-2010 Meeting and Date: Administration Committee 2/17/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: UNITED CITY OF YORKVILLE TREASURER'S REPORT FOR THE FISCAL YEAR ENDING APRIL 30, 2010 I certify that the following is true and correct to the best of my knowledge and belief. William Powell City Treasurer Summary Statement of Operations Beginning Fund Ending Fund Fund Type Balance(or Equiv)/ Revenues Expenditures Other Financing Balance(or Net Assets Sources/(Uses) Equiv)/Net Assets* General Fund 1,218,257 10,662,770 11,074,030 (1,299,936) (492,939) Library Fund 799,062 1,278,810 1,506,870 - 571,002 Special Revenue Funds 2,774,115 1,493,442 2,303,447 909,051 2,873,161 Debt Service Funds - 7,628 482,294 482,294 7,628 Capital Project Funds (255,754) 226,225 204,430 42,800 (191,159) Enterprise Funds 21,888,430 4,455,257 4,620,593 14,339,748 36,062,842 Fiduciary Funds 2,755,411 1,034,067 146,124 - 3,643,354 *NOTE: Detailed financial information may be found at http://www.yorkville.il.us/depts_fin_fy_audit.php United City of Yorkville FOR THE FISCAL YEAR ENDING APRIL 30,2010 RECEIPTS- GENERAL FUND:EMPLOY CONTRIB HEALTH REIMB 174,643;AMUSEMENT TAX 112,964;REAL ESTATE TAXES 2,407,483;TOWN ROADBRIDGE TAX 151,196;PERSONAL PROPERTY TAX 13,409; STATE INCOME TAX 1,277,889;MUNICIPAL SALES TAX 2,446,099; STATE USE TAX 201,681;ELECTRIC UTILITY TAX 548,774;UTILITY TAX-NATURAL GAS 284,895;UTILITY TAX-CABLE TV 188,282; UTILITY TAX-TELEPHONE 518,446;BUSINESS DISTRICT TAX 263,363;AUTO RENTAL TAX 6,973; HOTEL TAX 17,262;LIQUOR LICENSE 43,545;OTHER LICENSES 3,786;BUILDING PERMITS 190,579; FILING FEES 250;GARBAGE SURCHARGE 1,132,478;ZONING VARIANCE FEES 255;COLLECTION FEE -YBSD 119,121;DEVELOPMENT FEES 21,435;BEECHER LEASE AGREEMENT 11,000;BEECHER RENTALS 2,155;MOWING INCOME 280;GIS SERVICES 1,025;TRAFFIC FINES 129,075; ADMINISTRATIVE ADJUDICATION 44,565;POLICE TOWS 25,500;EMPLOYEE CONTR.HEALTH INS. 52,958;DARE DONATIONS 20;HANGING BASKET DONATIONS 2,440;REIMB FROM OTHER GOVERNMENTS 17,352;REIMBURSEMENTS-POLICE PROTECTN 36,780;INSURANCE REIMBURSEMENTS 29,776;REIMB -ADMINISTRATION 29,075;REIMB -FINANCE 4,030;REIMB - COMM RELATIONS 534;REIMB -PUBLIC WORKS 22,232;REIMB -POL COMMISION 6,215; MISCELLANEOUS INCOME 1,210;PENALTY FEE INCOME 379;TRAFFIC SIGNAL REVENUE 14,925; COPS GRANT-VESTS 1,502;CABLE CONSORTIUM FEES 36,185;POLICE-STATE TOBACCO GRANT 1,870;GRANTS 4,838;INVESTMENT INCOME 62,043;INTERFUND TRANSFERS 344,658;TOTAL 11,007,428. FOX HILL SSA:FOX HILL LEVY 19,897;TOTAL 19,897. SUNFLOWER SSA: SUNFLOWER LEVY 13,871;TOTAL 13,871. MOTOR FUEL TAX: MOTOR FUEL TAX ALLOTMENTS 409,576;MFT HIGH GROWTH 24,687;FOX ROAD 38,057;MISC.INCOME 105;INVESTMENT INCOME 779;TOTAL 473,203. MUNICIPAL BUILDING:DEVELOPMENT FEES-BUILDING 9,750;TOTAL 9,750. POLICE EQUIPMENT CAPITAL:DEV FEES-POLICE 19,950;IN CAR VIDEO DONATIONS 4,381; WEATHER WARNING SIREN 6,613; SALE OF POLICE SQUADS 4,100;SEIZED VEHICLES 5,683; MISCELLANEOUS INCOME 1,070;TOTAL 41,796. PUBLIC WORKS EQUIP CAPITAL:DEVELOPMENT FEES-PUBLIC WORKS 47,450;MISCELLANEOUS INCOME 558;TOTAL 48,008. PARKS &REC EQUIP CAPITAL:PARKS CAPITAL FEE 3,300;PARK CAPITAL DONATIONS 48,573; TOTAL 51,873. CITY WIDE CAPITAL:ROAD CONTRIBUTION 14,000;KENNEDY ROAD 54,600;ENGINEERING CAPITAL FEE 6,200;INTERFUND TRANSFERS 100,000;TOTAL 174,800. DEBT SERVICE: RECAPTURE-WATER/SEWER 7,628;INTERFUND TRANSFERS 482,294;TOTAL 489,922. WATER IMPROVEMENT&OPERATIONS: BULK WATER SALES 879;WATER SALES 1,591,745;WATER METER SALES 44,255;LEASE REVENUE-H2O TOWER 27,249;MISCELLANEOUS INCOME 471; RECAPTURE 6,071;BAD DEBT RECOVERY 3,690;INVESTMENT INCOME 3,204;INTERFUND TRANSFERS 81,750;CONNECTION FEES 201,466;TOTAL 1,960,778. SEWER IMPROVEMENT&OPERATIONS: SEWER MAINTENANCE FEES 723,012;SEWER CONNNECTION FEES 23,400; REIMBURSEMENTS 5,708;RECAPTURE 9,106;INVESTMENT INCOME 2,174;CONNECTION FEES 786,400;COUNTRYSIDE INTERCEPTOR 450,889;REVENUE COLLECTIONS UNDER 0.00 7,498;TOTAL 1,993,191. LAND CASH:BIKE PATH GRANT 103,337;WHISPERING MEADOWS(K.HILL)3,383;AUTUMN CREEK 62,427;BRISTOL BAY LAND CASH 100,000;TOTAL 269,148. PARKS &RECREATION:FEES FOR PROGRAMS 180,230;CONCESSIONS/ALL SALE ITEMS 39,573; PARK RENTAL INCOME 19,329;GOLF OUTING REVENUE 8,659;HOMETOWN DAYS 137,448; DONATIONS 10,576;YOUTH SERVICES GRANT 1,478;INVESTMENT INCOME 286;INTERFUND TRANSFERS 1,119,500;TOTAL 1,517,079. RECREATION CENTER: MEMBERSHIP FEES 387,975;GUEST FEES 4,303; SWIM CLASS 30,949; PERSONAL TRAINING FEES 12,603;TANNING SESSIONS 2,590;FEES FOR PROGRAMS 123,073; CONCESSIONS 12,765;RENTAL INCOME 4,056;MISC RETAIL 149;DONATIONS/SPONSORSHIP 3,176; SCHOLARSHIPS 1,400;TOTAL 583,040. LIBRARY: LIBRARY BOND PROP.TAX 561,150;REAL ESTATE TAXES 622,624;PERSONAL PROPERTY TAX 5,139;DEVELOPMENT FEES-BUILDING 15,550;DEVELOPMENT FEES-BOOKS 15,550;COPY FEES 3,773;LIBRARY SUBSCRIPTION CARDS 14,720;LIBRARY BLDG RENTAL 1,239;LIBRARY FINES 11,503;INSURANCE REIMBURSEMENTS 6,181; SALE OF BOOKS 423;MEMORIALS 4,451;GRANTS 1,000;LIBRARY PER CAPITA GRANT 13,555;INVESTMENT INCOME 1,952;TOTAL 1,278,809. FOX INDUSTRIAL: TIF REVENUES 216,677;INVESTMENT INCOME 45;TOTAL 216,721. POLICE PENSION:INTEREST INCOME 47,806;UNREALIZED GAIN/LOSS ON INVSTM 442,602; DIVIDEND INCOME 18,444;EMPLOYER CONTRIBUTIONS PROP TX 323,291;EMPLOYEE CONTRIBUTIONS 201,924;TOTAL 1,034,067. COUNTRYSIDE TIF PROJECT:TIF REVENUES 6,250;INVESTMENT INCOME 8,223;TOTAL 14,472. DOWNTOWN TIF:TIF REVENUES 88,550;TOTAL 88,550. PAYROLL: 0.01 TO 25,000.00 AMENT,BEVERLY;ANDERSON,FRED;ANDERSON,JENNIFER; ARENTSEN,DALE;ARNFELT,LUKE;AUW,KATHLEEN;BAHR,NANCY;BAKER,STEVEN;BALDINE, TAMMY;BATTLE,BETTYE;BAZAN,JEAN;BEACH,CHARLES;BIEGALSKI,LOUISE;BIERITZ, ROBERT;BIERMANN MILLER,KAREN;BINDER,ADAM;BOETTCHER,STEPHANIE;BOSTON,DAWN; BRADSTREET,PATRICIA;BREYNE,DONNA;BURD,VALERIE;CARLSON,JARED;CATHEY, CHANDLER;CHATMAN,DEB;COLLINS,ROLAND; CYKO,KELLY;CYKO,NATALIE;DEFELICE, JANET;DRAFKE,AMY;DREDGE,THOMAS;DUNCAN,MOLLY;DURANCIK,NICOLINA;EBERHARDT, MARIANNE;ENGELHARDT,GERALD;ESSEX,JANET;FELTON,DAN;FOSSE,TIA;FRISK,MEGAN; FRITTS,CATHLEEN;GARBELMAN,MARY;GILSON, GEORGE;GLINSKI,HOLLY A;GOLDEN,KIM; GOLINSKI,GARY;GOSS,VIRGINIA;GREZLIK,CATHY;HAGEMAN,JON;HAGEMANN,JORDAN; HARBIN,ALYSSA;HIRTZEL,KRISTI;JOHNSON,DOREEN;JOHNSON,KARA;JOHNSTON,DEVIN; JONES,NICOLE;KLAAS,BAILEY;KLIMEK,DANIELLE;KLINE, STEVE;KNUTSON,JOAN;KOVACS, RICHARD;KRUSE,KELSEY;KURTZ,JORDAN;LAVALLEE,MICHAEL;LEJA,NICOLE;LETRICH, CHRISTY;LINDBLOM,THOMAS;LIVINGSTON,KAY;MACIEJEWSKI,TAMI;MANNING,BARBARA; MATLOCK,JOANNE;MCCOY, SARA N;MCGEE,AMANDA;MEYER,MICHELE M;MILLER,KENNETH; MILSCHEWSKI,JACQUELYN;MINOR,ALLAN;MIX, SHARON;MOHLER,DEBI;MORKERT, CHRISTOPHER;MORRIS,JILL;MUNNS,MARTIN;NEGRE,RYAN;NICHOLSON,MICHELLE;NIESEN, CATHERINE;ODOM,MATTHEW J;PAGE,DALE;PAULSEN,KATHRYN;PAVLAK,CRYSTAL L; PFEIFFER,DAVID;PIELECH,JAMES;PIERSON,JESSICA;PLECKHAM,TRACI;PLOCHER,ARDEN; POWELL,WILLIAM;PREDY,BARBARA;REDMON,STEVEN;REESE,ANNETTE;ROBBINS,KATIE; ROLLINS,JORDAN; SAUER,MARJORIE; SCHICK,DANIELLE;SCHMIDT,MARGO; SCHOENY,KAREN L;SEIBEL,CARLY; SMITH,KATHERINE; SPEARS,ROSE; SPURLOCK,RALPH; STAGGS,NISACHERI; STANISLAUS,KEITH; STELLER,NICOLE;STRICKER,BETH; SULLIVAN,CHRISTOPHER;SULLIVAN, COLLEEN; SUTCLIFF,ROBYN;TEELING,DIANE;UNDERWOOD, SANDY;VAN CLEAVE,VIANNE; VANDERHEYDEN,ANNE;WALKER,KIRSTEN;WALKER,RON;WEDGE,DANIEL;WEINERT,ANDREA M;WERDERICH,WALTER;WICKS,CAROL;WILKINSON,PEGGY;WUNDER,CHARLES;YABSLEY, FRANK;YABSLEY,JENNA;YABSLEY,KRISTA. PAYROLL: 25,000.01 TO 50,000.00 ALWOOD,ANGELA;AUGUSTINE, SHELLEY;BROWN,DAVID; COLLINS JR,ALBERT;DEBORD,DIXIE;DIEDERICH,RONALD;DILLON, SALLY;DYON,JUDY; FELTES,RITA;FINCHAM,KATHRYN;GAWRYCH,KRISTOPHER;HAKE,ADAM;HENNE,DURKEN; HOPKINS,AMANDA;HORNER,RYAN;IWANSKI, SHARYL;JACKSON,JAMIE;KANAN,LEANN; LAWRENTZ, KEVIN;MEDINA,TONY;OLSEM,PAMELA;OSTREKO,MEGHAN;REISINGER, BARBARA;ROSBOROUGH, SHAY; SCODRO,PETER;SCOTT,WILLIAM; SIMMONS,AMY;SKINNER, KATIE;SMITH,AIMEE;TATE,THOMAS;WATERS,MICHAEL;WEBER,ROBERT;WILLIAMS, ANNETTE;WOODRICK,JENNIFER;WRIGHT,RACHEL;ZABEL,PAUL. PAYROLL: 50,000.01 TO 75,000.00 BARKLEY,R;BATTERSON,MOLLY;BEHRENS,BRETT;BEHRENS, DAVID;BLEDSOE,JACOB;BOZUE,STEVEN;BUSCH,DARRELL;CALVERT,GLENN;CARLYLE, MITCHELL;DEARBORN,JACKIE;EVANS,TIMOTHY;GOLDSMITH,RYAN;GRAFF,CHARLES; GRIMES,TOM;HART,ROBBIE;HAYES,CHRISTOPER;HELLAND,JONATHON;HOULE,ANTHONY; HUNTER,JOHN;JELENIEWSKI,ANDREW;KETCHMARK,MATTHEW; KOLOWSKI,TIMOTHY; MCMAHON,PATRICK;MIKOLASEK,RAYMOND;MILLER,TRAVIS;MOORE,JOE;MOTT,STACEY; PFISTER,MICHAELEEN;PFIZENMAIER,BEHR;PICKERING,LISA;PLECKHAM,DANIEL;POULOS, JORDAN;ROBINSON,MICHAEL; SCHRAW,LAURA; SENG,MATTHEW; SHAMSUDDIN, SHAMIM; SLEEZER,JOHN;SLEEZER,SCOTT; SORENSEN,BRIAN; SPIES,GLORY; SWITHIN, SUSAN;WEBER, GREG. PAYROLL: 75,000.01 TO 100,000.00 DELANEY,DAVID;DHUSE,ERIC;GROESCH,BARRY;HART, RICHARD;HILT,LARRY;JOHNSON,JEFFREY;KLINGEL,TERRY;MCLAUGHLIN,BRENDAN;MIKA, SUSAN;OLSON,BART;PRESNAK,JAMES;SCHWARTZKOPF,DONALD; STROUP, SAMUEL; PAYROLL: 100,000.01 TO 125,000.00 MARTIN,HAROLD;WYWROT,JOSEPH;TOTAL 6,127,929. VENDOR DISBURSEMENTS OVER$2,500: 3M 12,178;ACTION GRAPHIX LTD 3,871;ALL STAR SPORTS INSTRUCTION 19,650;AMERICAN ENGLISH 2,750;AMERICAN FITNESS WHOLESALERS 4,097;AQUA PURE ENTERPRISES,INC. 8,371;ARAMARK UNIFORM SERVICES 6,825;ASSOCIATED TECHNICAL SERVICES 3,015;AT&T DATACOMM,INC 2,585;AT&T 61,065;AT&T GLOBAL SERVICES,INC.2,945; AT&T INTERNET SERVICES 5,548;ATLAS BOBCAT 4,048;AURORA AREA CONVENTION 14,698; AURORA BLACKTOP 28,185;BAKER&TAYLOR 97,987;BANC OF AMERICA LEASING 15,732; RAINBOW GROUP,LLC 2,969;BRIAN BETZWISER 82,295;BLACKBERRY OAKS GOLF COURSE 2,536; BLUE CROSS BLUE SHIELD 1,099,787;BP AMOCO OIL COMPANY 46,756;BRENNTAG MID-SOUTH, INC. 8,192;BRISTOL KENDALL FIRE DEPART.71,240;CAMBRIA SALES COMPANY INC. 14,972; CARGILL,INC 115,771;CASTLE INSURANCE SERVICES,INC 3,912;CDW GOVERNMENT INC. 6,691; CENTEX HOMES 15,180;CHICAGO INTERNATIONAL TRUCKS 5,617;CITY OF YORKVILLE 157,718; CLARK ENVIRONMENTAL 30,966;RICHARD HOPKINS CLARK 33,333;RONALD WILLIAM CLARK JR. 33,333;CARLO D. COLOSIMO 3,900;COMCAST CABLE 2,964;COMMONWEALTH EDISON 155,313; COMMUNICATIONS DIRECT INC 6,583;CONSERVATION FOUNDATION 3,500;CORPORATION FOR OPEN LANDS 10,000;CROWN TROPHY 2,591;JULIE VISHER 4,200;DEMCO,INC.6,829;DEPO COURT REPORTING SVC,INC 14,672;DOOR TO DOOR DIRECT 4,228;EBSCO 3,382;EHLERS &ASSOCIATES, INC.9,600;EJ EQUIPMENT 3,086;EMPLOYEE BENEFITS CORPORATION 20,681;ENGINEERING ENTERPRISES,INC. 127,901;EUCLID BEVERAGE 12,604;EXELON ENERGY 274,157;FARREN HEATING &COOLING 17,931;FIRST NONPROFIT UNEMPLOYEMENT 38,925;RAQUEL HERRERA 6,283;FORCES INC 5,290;FOX VALLEY TROPHY&AWARDS 4,177;FOX VALLEY FIRE&SAFETY 4,782;FOX VALLEY TRADING COMPANY 13,597;FUERTE SYSTEMS 21,464;GARDINER KOCH&WEISBERG 100,417;SHARON CLARK GASKILL 33,333;GJOVIK CHEVROLET 3,866;GJOVIK FORD-MERCURY,INC. 4,651;GLADSTONE BUILDER&DEVELOPERS 13,793;GLENBROOK EXCAVATING&4,000;GOLD MEDAL PRODUCTS 10,938;GRAINCO FS.,INC. 5,110;GREATAMERICA LEASING CORP. 8,832;GREEN SCENE 3,763;HACH COMPANY 3,038;HARRIS 1,709;HAYDEN'S 3,485;RAYMOND HAYEN 2,555;HD SUPPLY WATERWORKS,LTD.31,438;HI FI EVENTS,INC. 11,800;HOME PAGES 3,290;HOMER INDUSTRIES 5,680;HOVING PIT STOP 8,012;HRM PROPERTIES&DEVELOPMENT 2,500;IL VALLEY URBAN LUMBERJACKS 6,790;ILLINOIS DEPARTMENT OF 105,306;ILLINOIS ENVIRONMENTAL 271,061;ILLINOIS MUNICIPAL LEAGUE 2,679;ILLINOIS PUBLIC SAFETY AGENCY 6,660;ILLINOIS TRUCK MAINTENANCE,IN 15,590;ILLINOIS PUBLIC RISK FUND 46,890;IMAGE PLUS 6,677;IMAJE RECORDS,INC 5,000;INTERNATIONAL CODES 129,420;ITRON 4,948;JAY M.HEAP&ASSOCIATES, LTD 48,350;JETCO,LTD 66,159;JULIE,INC. 3,465;KATHLEEN FIELD ORR&ASSOC. 142,977; KENDALL COUNTY ASSOCIATION 4,270;KENDALL COUNTY COLLECTOR 26,779;KENDALL COUNTY PROBATION 2,784;KENDALL COUNTY RECORDER'S 3,846;KENDALL COUNTY RECORD 6,335;KENDALL COUNTY TREASURER 28,651;ANNETTE M.POWELL 3,982;KIDS FIRST SPORTS SAFETY INC.4,408;KIMBALL HOMES 79,780;KONICA MINOLTA BUSINESS 15,133;KOPY KAT COPIER IMAGING SYSTEM 2,701;L.J.DODD CONSTRUCTION INC 192,377;LANER,MUCHIN, DOMBROW,BECKER 7,501;LAYNE CHRISTENSEN COMPANY 129,797;LENNAR COMMUNITIES OF CHICAGO, 30,996;LIBRARY FURNITURE INTERNATIONA 5,838;M.A.C.AMUSEMENT INC. 30,168; MAD BOMBER 4,000;MARINE BIOCHEMISTS 3,235;RANDY MCKIRGAN 30,816;MCQUAY INTERNATIONAL 4,704;MEADE ELECTRIC COMPANY,INC. 9,293;MENARDS INC 178,530;MENARDS -YORKVILLE 17,165;MESIROW INSURANCE SERVICES INC 93,181;METLIFE SMALL BUSINESS CENTER 28,262;METRO WEST COG 6,590;METROPOLITAN INDUSTRIES,INC. 12,748;MID AMERICAN WATER 9,407;MIDAMERICA BOOKS 7,468;MIDWEST TAPE 13,200;MJ ELECTRICAL SUPPLY,INC. 13,137;PATRICK MOLKENTINE 3,878;BRUCE MORRICK 3,045;MORTON SALT,INC 170,268;NEXTEL COMMUNICATIONS 38,866;NICOR GAS 56,272;NORTH EAST MULTI-REGIONAL 2,565;CYNTHIA O'LEARY 3,730;OCLC NETLIBRARY 4,200;OFFICE WORKS 20,051;P.F.PETTIBONE&CO. 3,713; PATTEN INDUSTRIES,INC. 9,525;PEPSI-COLA GENERAL BOTTLE 10,228;PITNEY BOWES 4,208; PITNEY BOWES 6,000;PITNEY BOWES,INC. 3,600;PRAIRIE AREA LIBRARY SYSTEM 10,751;JEWEL 2,515;QUILL CORPORATION 6,783;R. SMITS&SONS 3,120;R.J. KUHN INC.4,307;RAGING WAVES 62,130;RALPH'S PLACE 2,577;RATOS,JAMES 12,419;RAY O'HERRON COMPANY,INC.6,615;REESE RECREATION PRODUCTS INC 10,385;REINDERS,INC. 13,167;RI WATERMAN PROPERTIES 114,944; RIVERVIEW FORD 5,138;TRACY ROBINSON 3,685;RUSH-COPLEY MEDICAL CENTER 7,210; S&K DEVELOPMENT LLC 3,160;SCHRADER,CHARLES H. &ASSOC. 14,000; SEC GROUP,INC.41,689; SEILER INSTRUMENT&MFG.9,145;SERVICE PRINTING CORPORATION 41,877;SERVICEMASTER COMM.CLEANING 26,056;SERVICEMASTER OF AURORA&4,851;SEYFARTH SHAW LLP 21,757; SHAW TENT&AWNING 3,880;SHELL OIL CO. 68,888;SHRED-IT 2,673; SWFVCTC 54,240; SPORTSFIELDS,INC.4,136; STANDARD&ASSOCIATES,INC.4,815;STERLING CODIFIERS,INC.6,403; SUPERIOR ASPHALT MATERIALS LLC 4,640;TAPCO 11,977;THE BANK OF NEW YORK 3,915,767;THE BANK OF NEW YORK 4,387;THE BANK OF NEW YORK MELLON 3,084,067;THE GALE GROUP INC. 3,224;THYSSENKRUPP ELEVATOR CORP 6,617;TODAY'S BUSINESS SOLUTIONS INC 2,543;TRAFFIC CONTROL CORPORATION 19,893;TRICO MECHANICAL SERVICE GROUP 6,834;TUCKER DEVELOPMENT CORP. 170,898;TUFFY AUTO SERVICE CENTER 5,881;U.S.BANK 163,390;UNIQUE PRODUCTS&SERVICE 10,123;UNITED PARCEL SERVICE 4,418;UNITED SEPTIC,INC.2,776;JOSEPH J. DEMARCO 3,650;US BANK OPERATIONS CENTER 1,218,886;VEOLIA ES SOLID WASTE MIDWEST 1,153,400;VERMONT SYSTEMS 6,067;VERNE HENNE CONSTR. &20,796;VIKING CHEMICAL COMPANY 5,451;VISA 41,074;VISION SERVICE PLAN 13,448;WALDSCHMIDT&ASSOCIATES,INC. 10,169;WALKER CUSTOM HOMES,INC.210,000;WALMART COMMUNITY 4,822;WAREHOUSE DIRECT 2,621;WATER PRODUCTS,INC. 13,761;WATER SOLUTIONS UNLIMITED,INC 12,503;WESLEY PROPERTY CORP. 82,417;WHOLESALE TIRE 9,297;WILDMAN,HARROLD,ALLEN& 176,281;WIRE WIZARD OF ILLINOIS,INC 2,764;WOLF&COMPANY 60,850;YORKVILLE BRISTOL 2,954,992; YORKVILLE AREA CHAMBER OF 2,790;YORKVILLE BIG BAND 3,020;YORKVILLE CLERK'S ACCOUNT 3,895;YORKVILLE ECONOMIC DEV 45,100;YORKVILLE GENERAL FUND 69,071; YORKVILLE PUBLIC LIBRARY 1,220,013;YORKVILLE NAPA AUTO PARTS 2,768;YORKVILLE POLICE PENSION FUND 323,291;YORKVILLE POSTMASTER 15,484;YORKVILLE PARK&RECREATION 1,184,923;YORKVILLE SCHOOL DIST#115 59,286;DOLPH YOUNG 10,000;MARLYS J.YOUNG 2,921; EXPENSE DISBURSEMENTS UNDER 2,500.00 302,173;TOTAL 22,221,426. c/Ty Reviewed By: Agenda Item Number J� a O� Legal ❑ Finance El OB #1 EST. , � 1836 Engineer ❑ y City Administrator Tracking Number Police ❑ K°d111 Human Resources ❑ ADM 2011-03 Public Works ❑ City Council Agenda Item Summary Memo Title: Budget ideas Meeting and Date: Administration—February 15, 2011 Synopsis: See attached memo. Council Action Previously Taken: Date of Action: N / A Action Taken: Item Number: Type of Vote Required: N/ A Council Action Requested: Discussion Submitted by: Bart Olson Administration Name Department Agenda Item Notes: .��0 Co.y o Memorandum " To: Administration Committee EST. �Z 1836 From: Bart Olson, City Administrator .4 _�` CC: 0� �� o,gaa, �p Date: February 11, 2011 Ke tld"u" et ideas C Subject: Bud < J g Newer ideas The following ideas were either discussed at last month's Administration Committee meeting. 1) Western Riverfront Park building use—The Park Board recommended last evening to lease out the southern 500sf of the Riverfront Building that currently houses a preschool. This RFP/lease agreement is being drafted by staff, is similar to the most recently discussed RFP/lease agreement for the building at the east end of the park, and will be submitted to City Council at the February 22nd meeting. It is anticipated this lease agreement could generate more than$5,000 per year. a. The Park Board also directed staff to move the preschool from this building to the old post office at 201 W Hydraulic St. This new preschool location should be available for use by mid-Spring, and will allow us to expand registrations. 2) Riverfront Park kiosk—The Administration Committee discussed installing a business kiosk at the park to show paddlers where area businesses are located. Staff is researching the cost of a professionally installed kiosk vs. building one with in-house staff. I will discuss this with the Chamber of Commerce at their Board meeting next week. 3) Zip line across the river—The Administration Committee discussed installation of a zip- line across the river. While I think this idea has merit and has a good chance of succeeding, the City would need to partner with a company who has operated a zip-line and would need a significant amount of time to do due diligence on this project. Challenges will include seeking approval from private land-owners and/or the state for use of land in order to accommodate the footprint of a zip-line. Ultimately, this may be developed and operated by a private enterprise, who would only seek development assistance from the City. 4) Residential alarm permit—The Administration Committee discussed this last month. I am not familiar with the program, but I will research and the item can be discussed at the meeting. Previously discussed ideas The following is the list of budget ideas submitted in a December 28th memo to City Council. They are listed in this memo for your reference. ------------------------------------------------------------------------------------------------------------------- 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) Traditional economic development 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 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 fixture,be it for a solar farm or a whitewater recreational facility event. c/Ty Reviewed By: Agenda Item Number J� a O� Legal ■ Finance El OB #2 EST. , � 1836 Engineer ❑ y City Administrator Tracking Number Police ❑ C Kendal ounty . CC 2010-108 Human Resources El Public Works ❑ City Council Agenda Item Summary Memo Title: Ordinance Amending City Code Regarding Citizen Comments Meeting and Date: Administration Committee 2/17/11 Synopsis: Council Action Previously Taken: Date of Action: CC 1/25/11 Action Taken: Tabled back to Committee. Item Number: CC 2010-108(CA#7) Type of Vote Required: Majority Council Action Requested: Discussion and approval Submitted by: Bart Olson Administration Name Department Agenda Item Notes: Please see attached information from the 1/25/11 City Council packet. 0 Cdr y p; Memorandum -AN To: City Council EST. 1836 From: Bart Olson, City Administrator QIre y CC: IQ Date: January 7, 2011 Subject: Amendment to City Code regarding citizen comments at public E 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 1. 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