Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Administration Packet 2011 04-21-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, April 21, 2011 6:00 p.m. City Hall Conference Room Citizen Comments: Minutes for Correction/Approval: March 17, 2011 New Business: 1. ADM 2011-11 Budget Report for March 2011 2. ADM 2011-12 Treasurer's Report for March 2011 3. ADM 2011-13 Cash Statements for January and February 2011 4. ADM 2011-14 Amended Governing Ordinance 5. ADM 2011-15 Resolution Approving an Identity Protection Policy 6. ADM 2011-16 Bike Trail Donation Collection Old Business: 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 Bart Olson Litigation aversion. Gilson/Werderich Bart Olson Staff—elected officials communications. Spears/Gilson 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, April 21, 2011 6:00 PM City Hall Conference Room --------------------------------------------------------------------------------------------------------------------------------------- CITIZEN COMMENTS: --------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------- MINUTES FOR CORRECTION/APPROVAL: --------------------------------------------------------------------------------------------------------------------------------------- 1. March 17, 2011 ❑ Approved ❑ As presented ❑ With corrections --------------------------------------------------------------------------------------------------------------------------------------- NEW BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. ADM 2011-11 Budget Report for March 2011 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2011-12 Treasurer's Report for March 2011 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 3. ADM 2011-13 Cash Statements for January and February 2011 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 4. ADM 2011-14 Amended Governing Ordinance ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 5. ADM 2011-15 Resolution Approving an Identity Protection Policy ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 6. ADM 2011-16 Bike Trail Donation Collection ❑ 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— March 17, 2011 Meeting and Date: Administration Committee 4/21/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, March 17, 2011 City Hall Conference Room COMMITTEE MEMBERS PRESENT: Alderman Sutcliff Alderman Gilson Alderman Teeling Alderman Golinski OTHER CITY OFFICIALS PRESENT: City Manager Bart Olson HR Manager, Meghan Ostreko Treasurer Bill Powell Joe Liberty, Better Business Planning Alderman Teeling called the meeting to order at 6:00pm Citizen Comments: There were no citizens present for comment. Minutes for Correction/Approval: February 17, 2011 The minutes were approved as corrected. New Business: At this time, the Committee moved New Business item#4 to the top of the agenda. 4. ADM 2011 -10 Employee Benefits Renewal Administrator Olson began reviewing the Employee Benefit Renewal memo, specifically the employee benefit contribution. The proposal would bring into line the amount contributed by families versus employee, employee plus spouse and employee plus spouse and child. HR Manager Ostreko noted that the greatest change in benefits offered is reflected in co-pays for medical visits and contributions for prescriptions. Alderman Gilson wanted to know the percentage of employees utilizing HMO versus PPO. HR Manager Ostreko stated that, including employees, retirees, elected officials, and COBRA there are 41 are on PPO and 45 are on HMO. Alderman Gilson also noted that YBSD rates did not change because they are grandfathered into the plan. HR Ostreko noted that the letter from BCBC stated that because the City made changes to their plan last year that prevents any grandfathering. Alderman Gilson wonders if it is worth it to increase the deductible to $7,000. City Administrator Olson stated that it was definitely 1 worth it for the PPO. Administrator Olson clarified the cost differences from last year and the division of payment between premium and HRA contribution. The Committee requested the item be moved to the Board agenda for discussion. At this time, the Committee returned to the regular order of the agenda. 1. ADM 2011 — 07 Budget Report for February 2011 Administrator Olson noted that nothing has changed in the projected column versus budgeted amounts except in the health insurance area. However, there will be changes seen as the City shifts to accrual accounting. Alderman Gilson then questioned projections for building permits, developmental fees, traffic fines, administrative adjudication, and police tows in the general fund, as well as select line items in the other funds. 2. ADM 2011 — 08 Treasurer's Report for February 2011 Treasurer Powell informed the Committee of an issue regarding two funds that have been moved due to a change to the Bank Reform bill. Currently, Treasurer Powell and Finance Director Frederickson are reviewing alternatives for these two funds that will enable the funds to be FDIC insured and yet earn beneficial interest. 3. ADM 2011 — 09 Purchase Order Policy Revision Administrator Olson noted the two changes that are proposed. The first clarifies language for non-state bid items so that they are sent only to businesses registered with the City. The second change, initiated by the Auditors, would eliminate additional, unnecessary paperwork for the purchase of smaller items. This item was forwarded to the Board for consent. Old Business: Additional Business: Chair Sutcliff requested that there be research on any cost savings for changing over the billing for water to e-billing. There being no further business, the Committee adjourned at 7:37pm. 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-11 Kend'11 mly El<`E Agenda Item Summary Memo Title: Budget Report for March 2011 Meeting and Date: Administration Committee 4/21/11 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Discussion Submitted by: Rob Fredrickson Finance Name Department Agenda Item Notes: UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/4-14-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-30 June-10 July-10 August-10 September-10 October-30 November-10 December-10 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 $ (16,167.85) $ 23,545.25 $ 29,795.09 $ 190,048.08 $ 168,318.00 O1-000-40-00-3994 ADMISSIONS TAX $ $ $ $ $ $ 181,744.45 $ $ $ $ $ $ 181,744.45 $ 112,964.00 O1-000-40-00-3995 COBRA INS REIMB $ $ $ $ $ $ $ $ $ 15,569.31 $ 8,720.20 $ (4,098.89) $ 20,190.62 $ O1-000-40-00-3996 RETIREE INS REIMB $ $ $ $ $ $ $ $ $ 26,223.41 $ $ $ 26,223.41 $ O1-000-40-00-3997 AMUSEMENTTAX $ $ $ $ $ $ $ 44.10 $ $ 63.72 $ 5.67 $ $ 113.49 $ 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 $ $ 873.33 $ 13,546.11 $ 20,000.00 O1-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 $ 213,559.71 $ 101,421.64 $ 1,325,186.68 $ 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 $ 222,025.63 $ 237,910.96 $ 2,404,399.05 $ 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 $ 18,970.60 $ 29,864.75 $ 213,731.08 $ 237,063.00 O1-000-40-00-4040 MUNICIPAL UTILITY TAX $ $ 133,343.15 $ $ $ 143,841.18 $ $ $ $ 179,508.90 $ $ 146,050.17 $ 602,743.40 $ 565,000.00 O1-000-40-00-4041 UTILITY TAX-NICOR $ $ 117,229.18 $ $ $ 32,221.63 $ $ $ 28,087.50 $ 33,387.39 $ $ 71,795.99 $ 282,721.69 $ 396,000.00 O1-000-40-00-4042 UTILITY TAX-CABLE T $ 49,772.83 $ $ 1,835.78 $ 54,487.07 $ $ $ 55,794.36 $ $ $ 57,024.95 $ $ 218,914.99 $ 190,000.00 O1-000-40-00-4043 UTILITY TAX-TELEPHO $ 42,820.41 $ 48,994.12 $ 42,325.81 $ 43,671.29 $ 45,259.93 $ 45,330.47 $ 34,022.66 $ 45,371.84 $ 45,561.90 $ 42,544.43 $ 31,530.10 $ 467,432.96 $ 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 $ 27,194.75 $ 40,558.61 $ 270,869.79 $ 150,000.00 O1-000-40-00-4045 AUTO RENTAL TAX $ 538.25 $ 613.04 $ 578.60 $ 528.60 $ 699.63 $ 715.37 $ 791.14 $ 691.76 $ 623.86 $ 601.23 $ 770.48 $ 7,151.96 $ 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 $ 2,741.02 $ 2,458.28 $ 32,151.57 $ 20,000.00 O1-000-40-00-4080 PARA MUTUEL TAX $ 191.23 $ 587.12 $ 778.35 $ O1-000-41-00-4100 LIQUOR LICENSE $ 1,244.90 $ 503.12 $ 650.00 $ 374.74 $ $ $ 1,300.00 $ 19.82 $ $ 700.00 $ 1,550.00 $ 6,342.58 $ 30,000.00 O1-000-41-00-4101 OTHER LICENSES $ 50.00 $ 368.50 $ $ 234.25 $ 134.25 $ 414.25 $ $ 224.25 $ $ $ 50.00 $ 1,475.50 $ 4,500.00 O1-000-41-00-4110 BUILDING PERMITS $ 16,601.10 $ 15,346.75 $ 11,678.40 $ 10,935.90 $ 12,518.50 $ 20,281.65 $ 10,383.10 $ 4,253.30 $ 2,252.50 $ 1,972.00 $ 14,910.00 $ 121,133.20 $ 205,000.00 O1-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,024.43 $ 195,011.62 $ (389.00) $ 979,581.25 $ 1,050,000.00 O1-000-42-00-4207 ZONING VARIANCE FEES $ $ $ $ $ $ $ $ $ $ $ $ $ 170.00 O1-000-42-00-4208 COLLECTION FEE-YBSD $ $ $ $ $ $ $ $ $ $ 121,857.00 $ (5,770.00) $ 116,087.00 $ 121,503.00 O1-000-42-00-4210 DEVELOPMENT FEES $ 13,677.65 $ 100.00 $ 200.00 $ $ 1,081.97 $ 18,435.64 $ $ $ $ 22,139.92 $ 2,021.55 $ 57,656.73 $ 80,000.00 O1-000-42-00-4285 BEECHER LEASE AGREEME $ $ $ $ $ 1,000.00 $ 500.00 $ 500.00 $ $ 500.00 $ 500.00 $ 500.00 $ 3,500.00 $ 12,000.00 O1-000-42-00-4286 BEECHER RENTALS $ 45.00 $ 320.00 $ 170.00 $ 55.00 $ 210.00 $ 175.00 $ $ 110.00 $ 115.00 $ 160.00 $ 240.00 $ 1,600.00 $ 2,000.00 O1-000-42-00-4287 DEVELOPER SIGN REIMB $ $ $ $ $ $ $ $ $ $ $ $ $ 5,000.00 O1-000-42-00-4288 MOWING INCOME $ $ $ 46.36 $ 298.13 $ 127.09 $ 107.11 $ 486.54 $ $ 2,895.21 $ $ $ 3,960.44 $ 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 $ 5,660.23 $ 6,419.70 $ 80,832.83 $ 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 $ 2,030.00 $ 1,772.00 $ 23,656.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 $ 7,000.00 $ 2,750.00 $ 75,150.00 $ 181,275.00 O1-000-44-00-4401 DARE DONATIONS $ $ $ $ $ $ $ $ 25.00 $ $ $ $ 25.00 $ 20.00 O1-000-44-00-4404 HANGING BASKET DONATI $ 50.00 $ $ $ $ $ $ $ $ 600.00 $ 950.00 $ 1,009.10 $ 2,609.10 $ 2,000.00 O1-000-44-00-4407 HOLIDAY UNDER THE STA $ $ $ $ $ $ $ $ $ $ $ $ $ 9,585.00 O1-000-44-00-4411 REIMBURSEMENTS-POLICE $ 160.00 $ 295.00 $ 265.60 $ 270.00 $ 230.35 $ 245.35 $ 220.35 $ 21,797.21 $ (21,112.21) $ 254.20 $ 1,007.40 $ 3,633.25 $ 3,300.00 O1-000-44-00-4412 INSURANCE REIMBURSEME $ $ $ $ $ $ $ $ $ 11,404.00 $ $ $ 11,404.00 $ O1-000-44-00-4413 PLAN REVIEW INCOME $ $ $ $ $ $ $ $ $ $ $ $ $ O1-000-44-00-4414 WORKERS COMP REIMB $ 3,354.45 $ $ $ 3,354.45 $ O1-000-44-00-4415 REIMB FOR LEGAL EXPEN $ $ $ $ $ $ $ $ 33,144.76 $ 3,985.61 $ 6,061.05 $ 1,358.70 $ 44,550.12 $ 150,000.00 O1-000-44-00-4416 REIMB FOR THE LIBRARY $ $ $ $ $ $ $ $ $ $ $ $ $ 40,582.00 O1-000-44-00-4417 MIS.REIMBURSEMENTS $ $ $ $ $ $ $ 5,800.44 $ 257.92 $ (5,442.11) $ 2,276.59 $ 42.98 $ 2,935.82 O1-000-44-00-4418 REIMB-STREET OPS $ $ $ $ $ $ $ $ $ $ $ $ O1-000-44-00-4419 POLICE SPECIAL DETAIL $ 4,431.73 $ $ $ 4,431.73 O1-000-44-00-4421 LIFE INSURANCE REIMB $ 3,615.12 $ 275.93 $ 500.87 $ 4,391.92 O1-000-44-00-4490 MISCELLANEOUS INCOME $ 1,705.62 $ $ 9.00 $ 67.00 $ 114.00 $ 950.00 $ (3.74) $ 29.56 $ 5,041.71 $ 2.00 $ 500.14 $ 8,415.29 $ 1,000.00 O1-000-44-00-4495 HAUNTED HOUSE n/a n/a n/a n/a n/a $ $ $ $ $ $ $ $ O1-000-44-00-4499 BAD DEBT RECOVERY $ 2,718.75 $ $ $ $ $ $ $ $ $ $ $ 2,718.75 $ O1-000-45-00-4504 TRAFFIC SIGNAL REVENU $ $ 19,191.11 $ $ $ $ $ $ $ 13,875.55 $ $ $ 33,066.66 $ 14,925.00 O1-000-45-00-4505 COPS GRANT-VESTS $ $ $ $ $ 912.50 $ $ $ $ $ $ $ 912.50 $ O1-000-45-00-4506 MISC INTEGOVERNMENTAL $ $ $ $ $ 657.50 $ $ $ 2,195.50 $ (657.50) $ $ $ 2,195.50 $ O1-000-45-00-4507 FEDERAL GRANTS $ 9,285.49 $ 240.65 $ 866.34 $ 10,392.48 $ O1-000-45-00-4508 STATE GRANTS $ 9,771.30 $ $ $ 9,771.30 $ O1-000-45-00-4510 CABLE CONSORTIUM FEES $ $ $ $ $ O1-000-45-00-4511 POLICE-STATE TOBACCO $ $ $ $ $ 1,870.00 $ $ $ $ $ $ $ 1,870.00 $ 1,803.00 O1-000-45-00-4515 ENERGY&RECYCLING GR $ $ 5,307.00 $ $ $ $ $ $ $ $ $ $ 5,307.00 $ O1-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 $ 58.24 $ 47.10 $ 91.99 $ 1,690.17 $ 3,000.00 O1-000-49-00-4902 REPAY OF PARK&REC L $ $ $ $ $ $ $ $ $ $ $ $ $ 100,000.00 O1-000-49-00-4915 TRANSFER FROM WATER O $ $ $ 22,965.75 $ $ $ 22,965.75 $ $ $ 22,965.75 $ $ $ 68,897.25 $ 91,863.00 O1-000-49-00-4920 TRANSFER FROM SEWER M $ $ $ 20,761.25 $ $ $ 20,761.25 $ $ $ 20,761.25 $ $ $ 62,283.75 $ 83,045.00 O1-000-49-00-4935 TRANSFER FROM LAND CA $ $ $ 15,112.25 $ $ $ 15,112.25 $ $ $ 15,112.25 $ $ $ 45,336.75 $ 60,449.00 GENERAL FUND-TOTAL REVENUES $ 377,425.58 $2,230,212.70 $ 719,322.63 $ 931,079.60 $1,826,247.53 $ 881,646.21 $ 456,213.99 $ 794,090.38 $ 842,975.02 $ 984,262.96 $718,949.40 $ $ 10,762,426.00 $11,433,025.00 GENERAL FUND-ADMIN EXPENSES O1-110-50-00-5100 SALARIES-MAYOR $ 860.00 $ 825.00 $ 825.00 $ 825.00 $ 860.00 $ 825.00 $ 825.00 $ 725.00 $ 825.00 $ 760.00 $ 860.00 $ 9,015.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 $ 776.67 $ 741.67 $ 7,786.70 $ 8,980.00 1 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/4-14-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-30 June-10 July-10 August-10 September-10 October-10 November-30 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 01-110-50-00-5102 SALARIES-CITY TREASU $ 535.00 $ 500.00 $ 400.00 $ 400.00 $ 300.00 $ 500.00 $ 500.00 $ 500.00 $ 400.00 $ 535.00 $ 535.00 $ 5,105.00 $ 6,500.00 O1-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 $ 4,280.00 $ 4,145.00 $ 44,280.00 $ 50,320.00 O1-110-50-00-5104 SALARIES-LIQUOR COMM $ 83.33 $ 83.33 $ 83.33 $ 83.33 $ 53.33 $ 53.33 $ 83.33 $ 83.33 $ 83.33 $ 166.64 $ 83.33 $ 999.94 $ 1,000.00 O1-110-50-00-5106 SALARIES-ADMINISTRAT $ 15,935.65 $ 15,789.56 $ 16,697.57 $ 29,607.94 $ 9,850.38 $ 29,334.34 $ 20,406.29 $ 40,470.88 $ 14,272.58 $ 13,179.44 $ 13,971.09 $ 219,515.72 $ 202,242.00 O1-110-50-00-5137 SALARIES-OVERTIME $ $ $ $ $ $ $ $ $ $ 222.90 $ $ 222.90 $ 575.00 O1-110-61-00-5300 SPECIAL COUNSEL $ $ $ 5,176.24 $ 6,042.65 $ 7,156.17 $ $ 10,227.10 $ $ 18,564.45 $ 6,339.17 $ 45.00 $ 53,550.78 $ 65,000.00 O1-110-61-00-5301 LEGISLATIVE ATTORNEY $ $ $ $ $ $ $ $ $ $ $ $ $ O1-110-61-00-5302 CORPORATE COUNCIL $ $ 5,020.91 $ 7,736.75 $ 6,587.00 $ 10,184.75 $ 9,510.00 $ 9,77735 $ 7,160.50 $ 21,726.88 $ 16,641.75 $ 7,668.75 $ 102,015.04 $ 130,000.00 O1-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 $ 5,273.88 $ 13,272.41 $ 76,524.37 $ 90,000.00 O1-110-61-00-5311 CODIFICATION $ $ $ $ $ $ $ $ $ 500.00 $ 2,210.00 $ $ 2,710.00 $ 8,000.00 O1-110-61-00-5314 BUILDING INSPECTIONS $ $ $ $ $ $ $ $ $ $ $ $ $ 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 $ 236.50 $ 415.75 $ 3,887.99 $ 8,000.00 O1-110-62-00-5404 CABLE CONSORTIUM FEE $ $ $ 17,994.07 $ $ 18,659.87 $ $ $ 19,103.28 $ $ $ 19,505.08 $ 75,262.30 $ 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 $ 2,392.00 $ 1,196.00 $ 11,928.00 $ 14,400.00 O1-110-62-00-5410 MAINTENANCE-OFFICE $ $ $ $ $ $ $ $ $ $ $ $ $ 100.00 O1-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 $ 974.83 $ 977.76 $ 8,909.27 $ 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 $ 90.00 $ 90.00 $ 1,025.42 $ 1,200.00 O1-110-62-00-5439 TELEPHONE SYSTEMS MAI $ $ $ 1,472.40 $ $ $ $ $ $ $ 1,472.40 $ $ 2,944.80 $ 3,000.00 O1-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 $ 60.00 $ $ 160.00 $ 100.00 O1-110-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ $ $ 40.69 $ $ $ 40.69 $ O1-110-64-00-5605 TRAVEL/MEALS/LODGING $ (15.65) $ 56.31 $ 96.00 $ 78.76 $ 25.04 $ 202.88 $ 100.00 $ $ $ $ 150.89 $ 694.23 $ 1,000.00 O1-110-64-00-5607 PUBLIC RELATIONS $ $ $ $ $ 54.90 $ $ $ $ $ $ $ 54.90 $ 150.00 O1-110-64-00-5611 KENDALL COUNTY PARATR $ 4,945.75 $ $ $ $ $ $ 10,832.00 $ $ $ $ $ 15,777.75 $ 30,000.00 O1-110-64-00-5612 SENIOR SERVICE FUNDIN $ $ $ $ $ $ $ $ $ $ $ $ $ 5,000.00 O1-110-65-00-5800 CONTINGENCIES $ $ $ $ $ $ $ $ $ $ $ $ $ 10,000.00 O1-110-65-00-5802 OFFICE SUPPLIES $ 48.10 $ 396.99 $ 44.84 $ 1,225.54 $ 216.54 $ $ 409.92 $ 1,467.36 $ 173.24 $ 14.95 $ 172.64 $ 4,170.42 $ 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 $ 218.15 $ 399.61 $ 4,701.69 $ 7,000.00 01-110-65-00-5808 POSTAGE&SHIPPING $ (5.15) $ 168.33 $ 118.92 $ 3,993.45 $ 106.92 $ 60.89 $ 556.24 $ 435.22 $ 91.26 $ 1,574.43 $ 252.94 $ 7,653.42 $ 14,000.00 O1-110-65-00-5809 PRINTING©ING $ (0.70) $ 780.54 $ 1,343.94 $ 536.20 $ 445.14 $ 403.16 $ 1,130.58 $ 586.92 $ 298.49 $ 884.08 $ 441.19 $ 6,849.54 $ 6,750.00 O1-110-65-00-5810 PUBLISHING&ADVERTIS $ $ $ $ 10.40 $ $ $ 335.05 $ $ $ $ 11.20 $ 356.65 $ 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 $ 1,653.72 $ 1,691.65 $ 23,947.80 $ 27,153.00 O1-110-72-00-6501 SOCIAL SECURITY&VIED $ 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 $ 1,372.38 $ 1,404.16 $ 20,147.59 $ 26,463.00 O1-110-75-00-7002 COMPUTER EQUIP&SOFT $ $ 709.98 $ $ 1,233.75 $ $ $ $ $ $ $ $ 1,943.73 $ 850.00 O1-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.58 $ 1,967.69 $ 2,368.47 $ 3,795.99 $ 16,268.78 $ 31,000.00 O1-110-75-00-9004 MISCELLANEOUS $ $ $ $ $ $ $ $ $ $ $ $ $ O1-110-78-00-9013 HOLIDAY UNDER THE STA $ $ $ $ $ $ $ $ $ $ $ $ $ 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 EXPENSESI$ 37,383.79 $ 35,575.06 $ 122,453.19 $ 82,498.03 $ 60,896.10 $ 101,869.98 $ 76,562.06 $ 93,464.40 $ 117,418.13 $ 63,697.36 $ 71,827.11 $ $ 863,645.21 ",016,243 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 $ 12,652.88 $ 12,652.88 $ 183,824.14 $ 259,690.00 O1-120-50-00-5202 BENEFITS-UNEMPLOY.C $ 9,108.84 $ $ 13,663.25 $ $ $ 13,663.25 $ $ $ $ 18,761.50 $ $ 55,196.84 $ 38,000.00 O1-120-50-00-5203 BENEFITS-HEALTH INSU $ 284,297.20 $ 75,984.28 $ 155,709.99 $ (895.84) $ 86,963.34 $ (958.53) $ 164,870.46 $ 108,071.80 $ 114,588.32 $ 83,975.28 $ 98,038.15 $ 1,170,644.45 $ 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.52 $ 1,70182 $ 1,772.96 $ 5,155.25 $ 1,901.41 $ 1,901.41 $ 22,795.46 $ 28,240.00 O1-120-50-00-5205 BENEFITS-DENTAL/VIS $ 15,124.32 $ 8,139.52 $ 14,551.15 $ 459.05 $ 8,427.62 $ 390.66 $ 15,501.18 $ 6,977.50 $ 13,218.65 $ 7,741.67 $ 7,889.29 $ 98,420.61 $ 100,880.00 O1-120-61-00-5304 AUDIT FEES&EXPENSES $ $ $ $ $ $ $ 1,500.00 $ 1,500.00 $ 20,000.00 $ 15,000.00 $ 5,250.00 $ 43,250.00 $ 57,700.00 O1-120-61-00-5310 EMPLOYEE ASSISTANCE $ 404.16 $ $ $ 606.24 $ $ $ 606.24 $ $ $ $ 606.25 $ 2,222.89 $ 4,000.00 O1-120-62-00-5400 INSURANCE-LIABILITY $ 40,388.34 $ 54,721.50 $ 11,722.00 $ 11,972.00 $ 54,721.50 $ 11,723.00 $ 11,722.00 $ 23,051.00 $ 53,173.75 $ $ 22,710.58 $ 325,905.67 $ 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 $ 1,482.01 $ 1,395.00 $ 12,484.51 $ 28,000.00 O1-120-62-00-5410 MAINTENANCE-OFFICE E $ $ $ 538.00 $ $ $ $ $ $ $ $ $ 538.00 $ 1,800.00 O1-120-62-00-5411 MAINTENANCE-COMPUTER $ $ $ $ $ $ $ $ $ $ $ $ $ 500.00 O1-120-62-00-5412 MAINTENANCE-PHOTOCOP $ $ 1,572.00 $ 1,572.00 $ 1,572.00 $ 2,308.00 $ 1,572.00 $ 836.00 $ 2,308.00 $ 1,572.00 $ 836.00 $ 1,572.00 $ 15,720.00 $ 27,000.00 O1-120-62-00-5437 ACCTG SYSTEM SERVICE $ $ $ $ $ $ $ $ $ $ 10,727.70 $ $ 10,727.70 $ 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 $ 45.00 $ 45.00 $ 542.93 $ 1,010.00 O1-120-64-00-5600 DUES $ 120.00 $ $ $ 35.00 $ $ $ $ 170.00 $ 195.00 $ $ $ 520.00 $ 1,600.00 O1-120-64-00-5603 SUBSCRIPTIONS/BOOKS $ $ $ $ $ $ $ $ $ 97.87 $ 54.40 $ $ 152.27 $ 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 $ $ $ 75.22 $ 487.73 $ 2,000.00 O1-120-65-00-5804 OPERATING SUPPLIES $ 100.10 $ $ $ 158.55 $ 100.10 $ 157.22 $ $ $ 136.45 $ $ 379.70 $ 1,032.42 $ 3,500.00 O1-120-65-00-5808 POSTAGE&SHIPPING $ $ $ 94.25 $ 18.73 $ 29.90 $ 61.49 $ $ $ $ 170.41 $ $ 374.78 $ 2,500.00 O1-120-65-00-5809 PRINTING©ING $ $ $ $ $ $ $ $ $ $ $ $ $ 1,000.00 O1-120-65-00-5844 MARKETING-HOTELTAX $ $ $ 1,258.49 $ 2,665.74 $ 3,653.47 $ 4,992.99 $ 2,688.53 $ 3,902.98 $ 2,439.70 $ 1;529.16 $ 2,453.99 $ 25,585.05 $ 20,000.00 01-120-72-00-65001MRF PARTICIPANTS $ 1,644.82 $ 1,644.82 $ 2,139.75 $ 1,477.60 $ 492.72 $ 2,034.05 $ 1,571.28 $ 2,320.52 $ 1,242.21 $ 1,227.06 $ 1,227.06 $ 17,022.22 $ 25,190.00 O1-120-72-00-6501 SOCIAL SECURITY&VIED $ 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 $ 967.40 $ 967.40 $ 13,955.80 $ 29,070A0 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 $ 15.77 $ 1,365.74 $ 4,857.21 $ 5,00020 2 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/4-14-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-30 June-10 July-SO August-10 September-10 October-30 November-30 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 01-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 $ (145,532.00) $ 33,521.91 $ 157,137.94 $ 25,985.06 $ 203,698.11 $ $ $ $ 203,211.34 $ $ 205,235.54 $ 683,257.90 $ 620,000.00 O1-120-78-00-9004 BUSINESS DISTRICT REB $ (49,125.00) $ 18,606.77 $ 47,247.67 $ 22,943.42 $ $ 46,866.59 $ $ 45,936.81 $ 21,515.17 $ 27,194.75 $ $ 181,186.18 $ 150,000.00 O1-120-78-00-9013 AMUSEMNT TAX REBATE $ $ $ $ $ $ 99,959.44 $ $ $ $ $ $ 99,959.44 $ 63,000.00 O1-120-78-00-9099 BAD DEBT $ $ $ $ $ $ $ $ $ $ 88,572.77 $ $ 88,572.77 $ 01-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 $ 79,324.16 $ 79,324.16 $ 872,565.76 $ 951,890.00 O1-120-99-00-9941 TRANSFER TO PARK&RE $ 100,000.00 $ $ $ $ $ $ $ $ $ $ $ 100,000.00 $ 100,000.00 O1-120-99-00-9942 TRANSFER TO POLICE CA $ $ $ $ $ $ $ $ $ $ $ $ $ 25,000.00 O1-120-99-00-9965 TRANSFER TO DEBT SERV $ $ $ 107,351.00 $ $ $ 107,351.00 $ $ $ 107,351.00 $ $ $ 322,053.00 $ 429,404.00 TOTAL FINANCE EXPENSES1$ 356,949.96 $ 296,884.96 $ 620,158.17 $ 167,320.78 $ 449,275.38 $ 394,376.31 $ 300,665.62 $ 305,074.54 $ 668,993.01 $ 352,179.33 $443,089.37 $ $ 4,354,967.43 $ 4,492,743.00 GENERAL FUND-COMMUNITY RELATIONS EXPENSES O1-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 $ 3,046.88 $ 6,109.38 $ 55,406.26 $ 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 $ 250.00 $ 174.00 $ 3,051.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 $ 32.50 $ 9.24 $ 279.24 $ 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 $ $ $ $ $ $ $ $ $ $ $ $ $ O1-130-64-00-5607 PUBLIC RELATIONS $ $ 19.27 $ $ $ $ $ $ $ $ $ $ 19.27 $ 1,750.00 O1-130-65-00-5802 OFFICE SUPPLIES $ $ $ $ 27.98 $ $ 56.00 $ $ $ $ $ 27.10 $ 111.08 $ 750.00 O1-130-65-00-5808 POSTAGE&SHIPPING $ $ $ 440.00 $ $ $ $ 440.00 $ $ $ 724.19 $ $ 1,604.19 $ 3,500.00 O1-130-65-00-5809 PRINTING©ING $ $ $ $ $ $ $ $ $ $ $ $ $ 1,000.00 O1-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 O1-130-72-00-6501 SOCIAL SECURITY&VIED $ 294.30 $ 294.30 $ 294.30 $ 441.45 $ 147.15 $ 447.30 $ 294.30 $ 294.30 $ 229.50 $ 194.84 $ 429.11 $ 3,360.85 $ 4,877.00 O1-130-78-00-9010 COMMUNITY EVENTS $ (665.00) $ (425.00) $ 217.98 $ $ 111.44 $ $ $ $ 1,188.38 $ $ 97.70 $ 525.50 $ 6,000.00 O1-130-78-00-9013 HOLIDAY UNDER THE STA $ $ 425.00 $ $ 100.00 $ $ 8.25 $ $ 3,145.00 $ (3,716.82) $ 38.57 $ $ (0.00) $ 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 $ 1,963.83 $ 4,286.98 $ 6,846.53 $ $ 72,463.61 $ 110,336.00 GENERAL FUND-ENGINEERING EXPENSES 01-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 $ 12,395.48 $ 12,395.48 $ 221,783.56 $ 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 $ 49.00 $ 53.00 $ 2,590.49 $ 30,000.00 O1-150-62-00-5403 FEES $ $ $ 1,000.00 $ $ $ $ $ $ $ $ $ 1,000.00 $ 2,550.00 O1-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 EQ $ $ $ $ $ $ $ $ $ $ $ $ $ 500.00 O1-150-62-00-5411 MAINTENANCE-COMPUTERS $ $ $ $ $ $ $ $ $ $ $ $ $ 500.00 O1-150-62-00-5421 WEARING APPAREL $ $ $ $ $ $ $ $ $ $ $ $ $ 100.00 O1-150-62-00-5438 CELLULAR TELEPHONE $ $ 116.32 $ 128.68 $ 122.37 $ 134.31 $ 115.69 $ 11113 $ 119.43 $ 100.09 $ 97.50 $ 82.66 $ 1,130.18 $ 3,000.00 O1-150-64-00-5600 DUES $ $ $ $ $ $ 240.00 $ $ $ $ 157.54 $ $ 397.54 $ 1,000.00 O1-150-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ $ $ $ $ $ $ 01-150-64-00-5605 TRAVEL EXPENSE $ $ $ $ $ $ $ $ $ $ $ $ $ O1-150-64-00-5608 TUITION REIMBURSEMENT $ $ $ $ $ $ $ $ $ $ $ $ $ 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 01-150-65-00-5802 OFFICE SUPPLIES $ 3.15 $ 36.08 $ 57.62 $ $ 86.47 $ 23.28 $ $ 58.67 1$ 27.70 $ 11.98 $ 57.55 $ 362.50 $ 1,250.00 O1-150-65-00-5808 POSTAGE&SHIPPING $ $ $ $ $ $ $ $ $ 33.60 $ 184.63 $ $ 218.23 $ 500.00 O1-150-65-00-5809 PRINTING©ING $ $ 108.80 $ 100.23 $ 150.32 $ 96.12 $ 91.95 $ 117.86 $ 149.41 $ 31.43 $ 81.78 $ 37.11 $ 965.01 $ 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 $ 1,178.82 $ 1,178.82 $ 20,398.01 $ 25,582.00 O1-150-72-00-6501 SOCIAL SECURITY&VIED $ 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 $ 918.96 $ 918.96 $ 16,380.01 $ 20,176.00 O1-150-75-00-7002 COMPUTER EQUIPMENT& $ $ 262.80 $ 398.80 $ $ 1,389.79 $ $ $ 262.80 $ $ $ 312.79 $ 2,626.98 $ 3,300.00 01-150-75-00-7003 OFFICE EQUIPMENT $ $ $ $ $ $ $ $ $ $ $ 1,178.05 $ 1,178.05 $ 500.00 O1-150-78-00-9015 ENERGY&RECYCLING GR $ $ $ $ 5,307.00 $ $ $ $ $ $ $ $ 5,307.00 $ TOTAL ENGINEERING EXPENSES 1$ 25,665.37 $ 25,SSO.87 $ 26,525.96 $ 42,257.55 $ 14,227.91 $ 37,162.45 $ 24,699.32 $ 34,397.30 $ 15,184.03 $ 15,075.69 $ 16,214.42 $ $ 276,560.87 $ 357,821.00 GENERAL FUND-POLICE EXPENSES O1-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,876.77 $ 90,140.92 $ 91,103.65 $ 1,046,031.76 $ 1,316,326.00 01-210-50-00-5131 SALARIES-CHIEF/LT./5 $ 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,761.87 $ 51,689.24 $ 46,121.23 $ 592,372.31 $ 673,166.00 O1-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 $ 1,673.00 $ 1,780.75 $ 15,092.25 $ 25,000.00 O1-210-50-00-5135 SALARIES-POLICE CLER $ 16,198.50 $ 16,198.49 $ 15,178.49 $ 18,177.75 $ 6,059.24 $ 18,177.73 $ 12,093.50 $ 16,013.69 $ 8,937.72 $ 8,937.74 $ 8,937.73 $ 144,910.58 $ 212,386.00 O1-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 $ 2,280.31 $ 2,320.10 $ 26,249.15 $ 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 $ 25632 $ 8,182.41 $ 4,684.46 $ 2,158.85 $ 2,088.46 $ 58,292.85 $ 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 $ 474.75 $ 738.00 $ 9,177.75 $ 13,500.00 O1-210-50-00-5205 SALARIES-GRANT REIMB $ 1,402.51 $ 18,322.76 $ (1,325.98) $ 240.65 $ 866.34 $ 19,506.28 O1-210-50-00-5206 POLICE SPECIAL DETAIL 1 1$ 4,431.73 $ $ 4,431.73 O1-210-61-00-5300 LEGAL SERVICES $ $ $ $ $ $ 1$ $ $ $ $ $ 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 $ 54.92 $ 61.00 $ 611.96 $ O1-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 $ 686.30 $ 409.00 $ 6,186.16 $ 9,750.00 O1-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 $ 6,022.94 $ 1,831.38 $ 31,772.13 $ 47,000.00 O1-210-62-00-5410 MAINT-OFFICE EQUIPMEN $ $ $ $ 65.00 1$ (65.00) $ $ $ $ $ 1 1$ $ 3 o 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/4-14-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION EIREN 0 June-10 July-SO August-10 September-10 October-30 November-30 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 01-210-62-00-5411 MAINTENANCE-COM $ 123.49 $ - $ $ $ 148.82 $ $ $ $ - $ - $ 272.31 $ 2,500.00 01-210-62-00-5412 MAINTENANCE-K9 $ $ $ (54.50) $ 65.00 $ $ $ $ $ $ $ 10.50 $ 1,000.00 01-210-62-00-5414 WEATHER WARNING S $ 414.00 $ $ 182.88 $ 2,915.66 $ $ $ $ $ $ $ 3,512.54 $ 4,000.00 01-210-62-00-5421 WEARING APPAREL 4.95 $ 134.95 $ 1,343.33 $ 2,495.69 $ 486.48 $ 396.98 $ 853.85 $ 689.74 $ 666.24 $ 307.06 $ 1,263.84 $ 8,723.11 $ 10,000.00 01-210-62-00-5422 COPS GRANT IV-VEST $ $ $ 1,825.00 $ 610.00 $ 1,210.00 $ $ $ $ $ $ 3,645.00 $ 4,20 0.00 01-210-62-00-5432 KENDALL CO.JUVENILE $ $ $ $ $ $ $ 2,683.05 $ $ $ $ 2,683.05 $ 3,000.00 01-210-62-00-5436 TELEPHONE $ (414.25) $ 876.12 $ 916.92 $ 905.83 $ 908.89 $ 888.53 $ 909.31 $ 888.65 $ 879.64 $ 907.43 $ 7,667.07 $ 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 $ 1,192.42 $ 925.48 $ 10,935.34 $ 17,920.00 01-210-62-00-5441 MTD-ALERTS FEE 0.00 $ $ $ $ $ 3,330.00 $ $ $ $ $ $ 6,660.00 $ 5,150.00 01-210-62-00-5442 NEW WORLD LIVE SCA $ $ 8,286.30 $ $ $ $ $ $ $ $ 1,995.00 $ 10,281.30 $ 15,000.00 01-210-62-00-5443 ADMIN ADJUDICATION 5.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 $ 1,824.00 $ 1,000.00 $ 13,931.00 $ 15,000.00 01-210-64-00-5600 DUES 50.00 $ $ 120.00 $ $ $ $ $ $ 125.00 $ 820.00 $ $ 1,115.00 $ 1,000.00 01-210-64-00-5603 SUBSCRIPTIONS $ $ $ $ $ $ $ $ $ $ $ $ 350.00 01-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 01-210-64-00-5605 TRAVEL EXPENSES $ $ 217.28 $ $ (217.28) $ 51.47 $ 46.10 $ $ 284.40 $ 83.38 $ 68.42 $ 100.00 $ 633.77 $ 6,575.00 01-210-64-00-5606 COMMUNITY RELATIONS $ $ $ 12.04 $ $ $ $ $ $ $ $ $ 12.04 $ 500.00 01-210-64-00-5607 POLICE COMMISSION $ $ 445.00 $ $ 171.25 $ $ 100.00 $ 1,063.50 $ 618.50 $ 266.00 $ $ $ 2,664.25 $ 7,000.00 01-210-64-00-5608 TUITION REIMBURSEMENT $ $ 126.21 $ 844.63 $ $ $ $ $ $ $ $ 837.63 $ 1,808.47 $ 2,800.00 01-210-64-00-5609 POLICE RECRUIT ACADEM $ $ $ $ $ $ $ $ $ $ $ $ $ 01-210-64-00-5610 GUN RANGE FEES $ $ $ $ $ $ $ $ $ $ $ $ $ 500.00 01-210-64-00-5611 SRT FEE $ 3,500.00 $ $ $ $ $ $ $ $ $ $ $ 3,500.00 $ 3,500.00 01-210-64-00-5612 NEIGHBORHOOD WATCH $ $ $ $ $ $ $ $ $ $ $ $ $ 1,500.00 01-210-64-00-5613 CITIZENS POLICE ACADE $ $ $ $ $ $ $ $ $ $ $ $ $ 1,839.00 01-210-64-00-5614 CHAPLAIN PROGRAM $ $ $ $ $ $ $ $ $ $ $ $ $ 01-210-64-00-5615 COMPLIANCE CHECKS $ $ $ $ $ $ $ $ $ $ $ $ $ 500.00 01-210-64-00-5616 DARE PROGRAM $ $ $ $ $ $ 2,244.98 $ $ $ $ $ $ 2,244.98 $ 3,000.00 01-210-65-00-5801 SUPPLIES-GRANT REIMS $ $ 45.92 $ $ $ $ 6.21 $ 11.73 $ $ $ $ 6.00 $ 69.86 $ 01-210-65-00-5802 OFFICE SUPPLIES 1$ 437.36 $ 88.18 $ 94.45 $ 64.18 $ 232.84 $ 674.19 $ 126.46 $ 206.38 $ 26.99 $ 183.14 $ 245.28 $ 2,379.45 $ 3,000.00 01-210-65-00-5803 EVIDENCE TECH SUPPLIE $ $ $ $ $ $ $ $ $ 946.85 $ $ 48.00 $ 994.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 $ 294.79 $ 249.43 $ 5,274.80 $ 8,500.00 01-210-65-00-5808 POSTAGE&SHIPPING $ $ $ $ 95.74 $ 45.71 $ $ $ 47.39 $ (23.51) $ 570.93 $ 16.46 $ 752.72 $ 3,000.00 01-210-65-00-5809 PRINTING©ING $ $ 114.61 $ 456.69 $ 228.18 $ 213.65 $ 89.20 $ 75.01 $ 100.28 $ 84.27 $ 90.71 $ 78.94 $ 1,531.54 $ 4,500.00 01-210-65-00-5810 PUBLISHING&ADVERTIS $ $ $ 25.60 $ $ $ $ $ $ $ $ 31.60 $ 57.20 $ 100.00 01-210-65-00-5812 GASOLINE $ $ 5,571.25 $ 5,403.37 $ 5,556.52 $ 5,257.04 $ 4,989.80 $ 5,289.94 $ 4,779.71 $ 5,517.01 $ 6,377.03 $ 6,248.41 $ 54,990.08 $ 80,000.00 01-210-65-00-5813 AMMUNITION $ $ $ $ $ $ $ $ 1,995.00 $ $ $ $ 1,995.00 $ 2,000.00 01-210-65-00-5814 ADMIN ADJUDICATION 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 $ 849.98 $ 849.97 $ 13,332.19 $ 24,385.00 01-210-72-00-6501 SOCIAL SECURITY&VIED $ 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 $ 11,618.40 $ 11,347.19 $ 141,046.86 $ 178,962.00 01-210-72-00-6502 POLICE PENSION $ $ $ 25,704.86 $ 132,566.85 $ 34,362.70 $ 126,187.34 $ 8,884.76 $ 8,368.38 $ $ $ $ 336,074.89 $ 325,000.00 01-210-75-00-7002 COMPUTER EQUIP&SOFT $ $ $ $ 2,467.50 $ $ $ $ $ $ $ $ 2,467.50 $ 7,000.00 01-210-78-00-9006 K9 STIPEND $ 230.76 $ 135.98 1$ 103.02 $ $ $ $ $ $ $ $ $ 469.76 $ TOTAL POLICE EXPENSES1$ 215,682.77 1$ 197,195.36 1$ 234,703.18 $ 407,021.71 $ 138,539.30 $ 409,882.09 $ 192,205.74 $ 236,774.80 $ 197,534.00 $ 189,436.14 $ 182,408.30 $ $ 2,601,383.39 $ 3,190,934.00 GENERAL FUND-COMMUNITY DEVELOPMENT EXPENSES 01-220-50-00-5107 SALARIES-PLANNING& $ 20,997.81 $ 22,390.20 $ 22,310.20 $ 32,699.32 $ 11,265.10 $ 33,395.31 $ 22,570.20 $ 27,872.14 $ 17,550.41 $ 17,690.40 $ 17,610.40 $ 246,351.49 $ 287,132.00 01-220-54-00-5430 PRINTING&DUPLICATING $ $ $ $ $ $ $ $ $ $ $ $ 01-220-61-00-5300 LEGAL SERVICES $ $ 147.00 $ $ 1.00 $ 197.00 $ 146.00 $ 147.00 $ 891.00 $ 248.00 $ $ $ 1,777.00 $ 8,000.00 01-220-61-00-5314 INSPECTIONS $ $ $ $ $ 8,637.00 $ 1,125.00 $ $ 3,015.00 $ $ 1,650.00 $ 1,755.00 $ 16,182.00 $ 25,000.00 01-220-62-00-5401 CONTRACTUAL SERVICES $ $ $ 876.17 $ 725.00 $ 102.75 $ 34.25 $ $ $ $ $ $ 1,738.17 $ 13,000.00 01-220-62-00-5430 PLANNING CONSULTANT $ $ $ $ $ $ $ $ $ $ $ $ $ 01-220-62-00-5432 ECONOMIC DEVELOPMENT $ $ $ $ $ $ $ $ $ 45,000.00 $ $ $ 45,000.00 $ 45,000.00 01-220-62-00-5438 CELLULAR TELEPHONE $ $ 98.15 $ 204.32 $ 101.18 $ 107.15 $ 97.83 $ 96.56 $ 99.70 $ 90.04 $ 104.99 $ 97.96 $ 1,097.88 $ 1,500.00 01-220-64-00-5600 DUES $ 463.00 $ $ $ $ $ $ $ 100.00 $ $ 453.00 $ $ 1,016.00 $ 1,500.00 01-220-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ 15.00 $ $ $ 40.00 $ 10.00 $ $ 50.00 $ 115.00 $ 200.00 01-220-64-00-5605 TRAVEL EXPENSE $ $ $ $ $ $ $ $ $ $ $ $ $ 01-220-65-00-5802 OFFICE SUPPLIES $ 53.11 $ 16.64 $ 52.73 $ 33.92 $ 37.37 $ 62.14 $ $ 76.58 $ 27.70 $ $ 28.34 $ 388.53 $ 500.00 01-220-65-00-5804 OPERATING SUPPLIES $ 135.94 $ 6.50 $ 316.20 $ $ 5.94 $ 71.13 $ $ 33.40 $ $ 16.90 $ 57.55 $ 643.56 $ 3,500.00 01-220-65-00-5808 POSTAGE&SHIPPING $ $ $ $ $ $ $ $ 6.96 $ $ 182.13 $ $ 189.09 $ 1,000.00 01-220-65-00-5809 PRINTING©ING $ $ 108.80 $ 95.24 $ 150.33 $ 96.12 $ 91.95 $ 78.67 $ 139.41 $ 31.43 $ 81.78 $ 37.10 $ 910.83 $ 1,300.00 01-220-65-00-5810 PUBLISHING&ADVERTIS $ $ 86.90 $ $ $ $ $ $ $ $ $ $ 86.90 $ 150.00 01-220-65-00-5814 BOOKS&MAPS 1$ $ $ $ 202.10 $ $ $ $ $ 50.00 $ $ 120.45 $ 372.55 $ 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 $ 1,682.35 $ 1,674.73 $ 21,944.75 $ 27,851.00 01-220-72-00-6501 SOCIAL SECURITY&VIED $ 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 $ 1,289.19 $ 1,283.07 $ 17,898.26 $ 21,966.00 01-220-75-00-7002 COMPUTER EQUIP&SOFT $ $ $ $ 1,993.03 $ 104.98 $ $ 72.98 $ $ $ $ $ 2,170.99 $ 7,955.00 01-220-75-00-7003 OFFICE EQUIPMENT $ $ $ $ $ $ $ $ $ $ $ $ $ 125.00 01-220-78-00-9015 RAIN GARDEN GRANT $ $ $ $ $ $ $ $ $ $ $ $ $ 01-220-78-00-9016 FULL CIRCLE GRANT $ (9,145.00) $ 325.00 $ 155.00 $ 7,048.18 $ (7,477.06) $ $ $ 17,442.31 $ $ $ $ 8,348.43 $ TOTAL COMMUNITY DEVELOPMENT EXPENSES $ 15,681.16 $ 26,611.68 $ 27,423.23 $ 48,292.09 $ 14,931.99 $ 40,495.66 $ 26,657.61 $ 54,317.58 $ 65,955.09 $ 23,150.74 $ 22,714.60 $ $ 366,231.43 $ 446,179.00 GENERAL FUND-STREETS EXPENSES 01-410-50-00-5107 SALARIES-STREETS $ 22,823.93 $ 21,647.26 1$ 22,964.73 1$ 33,445.49 $ 11,296.22 $ 33,854.65 $ 22,590.98 $ 25,995.90 $ 22,010.03 $ 22,445.85 $ 19,376.52 $ 258,451.56 $ 243,472.00 4 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/4-14-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-30 June-10 July-SO August-10 September-10 October-30 November-30 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 01-410-50-00-5136 SALARIES-PARTTIME $ $ - $ - $ $ $ $ $ $ $ - $ - $ - $ - 01-410-50-00-5137 SALARIES-OVERTIME $ 538.01 $ 605.83 $ 278.57 $ 696.43 $ $ 603.56 $ 371.43 $ 1,765.03 $ 1,173.52 $ 3,516.38 $ 1,225.62 $ 10,774.38 $ 28,000.00 01-410-61-00-5313 ENGINEERING-IN TOWN $ $ $ $ $ $ $ $ $ $ $ $ $ 01-410-61-00-5314 INSPECTIONS&LICENSE $ $ $ $ $ 137.00 $ $ $ $ $ 333.00 $ $ 470.00 $ 700.00 01-410-62-00-5401 CONTRACTUAL SERVICES $ $ 19.99 $ 19.95 $ 44.98 $ 19.98 $ 19.98 $ 5130 $ 19.98 $ 119.99 $ 199.98 $ 65.99 $ 584.15 $ 1,000.00 01-410-62-00-5408 MAINTENANCE-EQUIPMENT $ $ (2,259.25) $ 2,540.88 $ 79.33 $ 219.90 $ 1,613.75 $ 181.29 $ 51.21 $ 4,687.90 $ 1,007.78 $ 572.38 $ 8,695.17 $ 10,000.00 01-410-62-00-5409 MAINTENANCE-VEHICLES $ 475.42 $ 68.29 $ 923.67 $ $ 521.70 $ 1,944.12 $ 9,71410 $ 3,158.38 $ 2,681.14 $ 1,034.25 $ 333.54 $ 20,854.71 $ 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,189.87 $ $ 2,635.00 $ 11,657.04 $ 15,000.00 01-410-62-00-5415 MAINTENANCE-STREET LI $ 192.00 $ 1,370.75 $ 4,235.05 $ (2,620.96) $ 725.39 $ 485.72 $ 549.40 $ 389.64 $ 11,433.50 $ 1,570.75 $ 1,588.90 $ 19,920.14 $ 9,000.00 01-410-62-00-5416 MAINTENANCE PROPERTY $ 150.00 $ 74.97 $ 1,372.60 $ 1,975.75 $ 120.53 $ 223.94 $ 1,081.60 $ 480.61 $ 2,773.60 $ 439.96 $ 794.79 $ 9,488.35 $ 30,000.00 01-410-62-00-5420 MAINTENANCE-STORM SEW $ $ $ 119.78 $ $ $ 4,474.02 $ 878.74 $ $ $ $ $ 5,472.54 $ 5,000.00 01-410-62-00-5421 WEARING APPAREL $ 65.61 $ 85.54 $ 150.37 $ 142.02 $ 159.59 $ 251.42 $ 314.75 $ 125.42 $ 180.23 $ 115.48 $ 350.88 $ 1,941.31 $ 4,200.00 01-410-62-00-5434 RENTAL-EQUIPMENT $ $ $ 176.00 $ $ $ $ $ $ $ $ $ 176.00 $ 1,000.00 01-410-62-00-5435 ELECTRICITY $ $ 1,967.83 $ 6,323.23 $ 6,638.22 $ 6,503.63 $ 5,003.51 $ 7,835.31 $ 5,159.18 $ 11,304.26 $ 8,087.01 $ 11,203.90 $ 73,026.08 $ 75,000.00 01-410-62-00-5438 CELLULAR TELEPHONE $ $ 145.40 $ 160.85 $ 152.96 $ 167.90 $ 200.91 $ 205.70 $ 172.57 $ 146.78 $ 186.65 $ 114.18 $ 1,653.90 $ 4,020.00 01-410-62-00-5440 STREET LIGHTING $ $ $ $ $ $ $ $ $ $ $ $ $ 01-410-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ $ $ $ $ 180.00 $ 180.00 $ 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 $ 364.82 $ 188.73 $ 101.50 $ 3,114.31 $ 10,000.00 01-410-65-00-5810 ELECTRICAL MAINT SUPP $ $ $ $ $ $ $ $ $ $ $ $ $ 01-410-65-00-5812 GASOLINE $ $ 399.90 $ 3,077.06 $ 2,722.01 $ 2,885.28 $ 1,120.80 $ 1,893.88 $ 1,969.36 $ 3,153.68 $ 2,993.39 $ 2,877.70 $ 23,093.06 $ 32,000.00 01-410-65-00-5815 HAND TOOLS $ $ $ $ $ $ 18.93 $ $ $ $ 819.35 $ 179.74 $ 1,018.02 $ 1,000.00 01-410-65-00-5817 GRAVEL $ $ $ 426.65 $ $ $ $ $ $ $ $ $ 426.65 $ 1,500.00 01-410-72-00-65001MRF PARTICIPANTS $ 2,138.64 $ 2,144.84 $ 2,130.59 $ 3,182.00 $ 1,054.55 $ 3,165.57 $ 2,143.01 $ 2,270.24 $ 2,204.81 $ 2,469.02 $ 1,959.28 $ 24,862.55 $ 26,332.00 01-410-72-00-6501 SOCIAL SECURITY&VIED $ 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 $ 1,935.91 $ 1,532.57 $ 20,088.00 $ 20,768.00 01-410-75-00-4404 HANGING BASKETS $ $ 1,832.00 $ 204.00 $ 11.98 $ $ $ $ $ $ $ $ 2,047.95 $ 2,000.00 01-410-75-00-5418 MOSQUITO CONTROL $ $ $ $ $ $ 6,500.00 $ $ $ $ $ $ 6,500.00 $ 15,000.00 01-410-75-00-7004 SAFETY EQUIPMENT $ $ 245.75 $ $ $ $ $ $ 270.26 $ 45.00 $ $ $ 561.01 $ 500.00 01-410-75-00-7101 IN TOWN ROAD PROGRAM $ $ $ $ $ $ $ $ $ $ $ $ $ 40,232.00 01-410-75-00-7102 TREE&STUMP REMOVAL $ $ $ $ 150.00 $ 4,800.00 $ $ $ $ $ $ $ 4,950.00 $ 10,000.00 O1-410-75-00-7103 SIDEWALK CONSTRUCTION $ 246.00 $ $ $ $ 240.00 $ $ 739.04 $ $ $ $ $ 1,225.04 $ 4,000.00 01-410-78-00-9010 PARKWAYTREE PROGRAM $ $ (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 $ 78,925.97 $ 47,343.49 $ 45,092.49 $ $ 511,231.95 $ 616,724.00 GENERAL FUND-HEALTH&SANITATION EXPENSES 01-540-62-00-5442 GARBAGE SERVICES $ $ 98,777.71 $ 98,735.97 $ 99,049.02 $ 98,777.71 $ 98,631.62 $ 98,235.09 $ 98,026.39 $ 97,817.69 $ 97,588.12 $ $ 885,639.32 $ 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 $ $ 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$ 97,558.12 1$ $ l$ 890,199.32 $ 1,146,000.00 TOTAL FUND REVENUES $ 377,425.58 $2,230,212.70 $ 719,322.63 $ 931,079.60 $1,826,247.53 $ 881,646.21 $ 456,213.99 $ 794,090.38 $ 842,975.02 $ 984,262.96 $718,949.40 $ $ 10,762,426.00 $11,433,025.00 TOTAL FUND EXPENSES $ 684,922.58 1$ 703,763.95 $1,185,395.20 1$ 905,252.63 1$ 811,914.66 $1,161,607.48 1$ 777,423.05 1$ 877,701.24 $ 1,247,751.75 1$ 792,757.85 1$788,192.82 $ $ 9,936,683.21 $11,376,980.00 FUND SURPLUS(DEFICIT) $ (307,497.00) $1,526,448.75 1$ (466,072.57)1$ 25,826.97 1$1,014,332.87 1$ (279,961.27) $ (321,209.06) $ (83,610.86) $ (404,776.73)1$ 191,505.11 1$ (69,243.42)1 l$ 825,742.79 1$ 56,045.00 FOX HILL SSA REVENUES 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 GR $ $ 430.00 $ 909.54 $ 967.50 $ 454.92 $ 565.65 $ 454.92 $ $ $ $ 85.50 $ 3,871.33 $ 3,458.00 TOTAL FUND REVENUES $ $ 9,414.19 $ 441.86 $ 1,881.23 $ 7,271.40 $ 388.47 $ 496.96 $ $ $ $ $ $ 19,894.11 $ 19,463.00 TOTAL FUND EXPENSES $ $ 430.00 $ 909.84 $ 967.50 $ 454.92 $ 568.65 $ 454.92 $ $ $ $ 85.50 $ $ 3,871.33 $ 3,458.00 FUND SURPLUS(DEFICIT) $ 1$ 8,984.19 1$ (467.98)1$ 913.73 1$ 6,816.45 1$ (180.18)1$ 42.04 1$ 1 1$ 1$ (85.50)l 1$ 16,022.78 1$ 16,005.00 SUNFLOWER SSA REVENUES 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 GR $ $ 2,204.50 $ 1,649.00 $ 1,812.57 $ 1,219.00 $ 537.50 $ 107.50 $ $ $ $ 85.50 $ 7,615.87 $ 5,253.00 TOTAL FUND REVENUES $ $ 6,652.73 $ 341.13 $ 963.56 $ 5,676.61 $ 57.34 $ 179.13 $ $ $ $ $ $ 13,870.50 $ 13,112.00 TOTAL FUND EXPENSESE$ 1$ 2,204.80 1$ 1,649.00 1$ 1,812.57 1$ 1,219.00 1$ 537.50 1$ 107.50 1$ $ $ $ 85.50 $ $ 7,615.57 $ 8,253.00 FUND SURPLUS(DEFICIT)l$ 1$ 4,447.93 1$ (1,307.87) $ (849.01)l$ 4,457.61 1$ (480.16)1$ 71.63 1$ $ 1$ 1$ (85.50)1 1$ 6,254.63 1$ 4,859.00 MOTOR FUEL TAX REVENUES 15-000-40-00-4060 MOTOR FUEL TAX ALLOTM $ 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,26143 $ 39,229.64 $ 31,590.46 $ 391,867.56 $ 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 ROAD $ $ $ $ $ $ 4,602.26 $ $ $ $ $ $ 4,602.26 $ 15-000-44-00-4403 DOWNTOWN PARKING LOT n/a n/a n/a n/a $ $ 151,000.00 $ $ $ $ $ $ 151,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 $ $ $ $ (0.10) $ 85.40 $ 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 $ 58.39 $ 60.96 $ 776.43 $ 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 $ $ $ $ $ $ $ $ 33,082.50 $ 40,255.52 $ 42,842.04 $ 16,596.76 $ 132,776.82 $ 204,000.00 5 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/4-14-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 15-000-75-00-7007 SIGNS $ - $ - $ 67.10 $ $ - $ 41.95 $ $ $ 251.70 $ 135.20 $ 374.90 $ 870.85 $ 18,000.00 15-000-75-00-7009 PATCHING $ $ $ $ $ $ $ $ 49,857.33 $ $ $ 2,624.07 $ 52,481.40 $ 50,000.00 15-000-75-00-7106 GAME FARM SURVEYING $ $ $ $ 6,456.02 $ $ $ $ $ $ $ $ 6,456.02 $ 15-000-75-00-7108 GAME FARM HOUSE DEMO $ $ $ $ $ $ $ $ $ $ $ $ $ 20,000.00 15-000-75-00-7110 COLD PATCH $ $ 1,488.11 $ $ $ $ $ $ $ 1,500.15 $ $ 3,948.00 $ 6,936.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 ROAD $ $ $ $ 582.60 $ $ 20,293.22 $ $ $ $ 1,054.25 $ $ 21,930.07 $ 15-000-75-00-7122 FOX RD OVERLAY $ $ $ $ $ $ $ $ $ $ $ $ $ 15-000-75-00-7123 GUARDRAIL REPAIRS $ $ $ $ $ $ 23,127.67 $ $ $ $ $ $ 23,127.67 $ 15-000-75-00-7124 IL 47 @ US 30 SIGNALS $ $ $ $ $ $ $ $ $ $ 18,146.3 $$ 18,146.30 $ 15-000-75-00-9923 TRANSFER TO CITY WIDE CAPIT $ $ $ $ $ $ $ $ $ $ 96,000.00 $ $ 96,000.00 $ TOTAL FUND REVENUES $ 36,562.99 $ 35,390.49 $ 33,458.33 $ 43,250.14 $ 35,286.72 $ 220,911.99 $ 102,996.64 $ 37,968.47 $ 36,340.54 $ 39,288.03 $ 31,651.32 $ $ 653,105.66 1 356,000.00 TOTAL FUND EXPENSES $ $ 1,488.11 $ 67.10 $ 27,038.62 $ $ 49,631.48 $ $ 84,429.34 $ 42,007.37 $ 140,031.49 $ 41,690.03 $ $ 386,383.54 $ 475,600.00 FUND SURPLUS(DEFICIT) $ 36,562.99 $ 33,902.38 $ 33,391.23 $ 16,211.52 $ 35,286.72 $ 171,280.51 $ 102,996.64 1$ (46,460.87) $ (5,666.83) $ (100,743.46) $ (10,038.71)1$ 11$ 266,722.12 1$ (119,600.00) MUNICIPAL BUILDING REVENUES 16-000-42-00-4211 DEVELOPMENT FEES-BUIL $ 1,350.00 $ 15,900.00 $ 150.00 $ 450.00 $ 750.00 $ 1,350.00 $ $ $ - $ - $ 750.00 $ 20-,700.00 $ 55,000.00 TOTAL FUND REVENUES $ 1,350.00 $ 15,900.00 $ 150.00 $ 450.00 $ 750.00 $ 1,350.00 $ $ $ $ $ 750.00 $ $ 20,700.00 $ 55,000.00 TOTAL FUND EXPENSES $ $ $ $ $ $ $ 1$ 1$ 1$ 1$ $ 11$ $ FUND SURPLUS(DEFICIT) $ 1,350.00 1$ 15,900.00 1$ 150.00 1$ 450.00 1$ 750.00 1$ 1,350.00 1$ $ $ $ $ 750.00 $ $ 20,700.00 $ 55,000.00 POLICE CAPITAL REVENUES 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 $ $ $ 1,500.00 $ 16,009.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 $ 694.20 $ 717.72 $ 5,334.60 $ 20-000-44-00-4404 DONATIONS $ $ $ $ $ $ $ $ $ $ $ $ $ 20-000-44-00-4405 WEATHER WARNING SIREN $ $ $ $ $ 103.50 $ 18.75 $ $ $ $ 285.75 $ 150.00 $ 558.00 $ 6,000.00 20-000-44-00-4406 WEATHER WARNING SIREN FEE $ $ $ $ $ $ $ $ $ $ $ $ 20-000-44-00-4431 SALE OF POLICE SQUADS $ 1,000.00 $ 2,500.00 $ $ $ $ $ $ $ $ 400.00 $ 3,800.00 $ 7,700.00 $ 1,000.00 20-000-44-00-4440 SEIZED VEHICLES $ $ $ 1,000.00 $ 1,000.00 $ 150.00 $ $ 752.50 $ $ $ $ 3,125.00 $ 6,027.50 $ 5,000.00 20-000-49-00-4901 TRANSFER FROM GENERAL $ $ $ $ $ $ $ $ $ $ $ $ $ 25,000.00 POLICE CAPITAL EXPENSES 20-000-65-00-5811 LETHAL/NON-LETHAL WEA $ $ $ $ $ $ $ $ $ $ $ $ $ 20-000-65-00-5840 SEIZED VEHICLES $ $ 95.00 $ 95.00 $ 380.00 $ 325.00 $ 95.00 $ 60.00 $ 486.01 $ 105.00 $ $ 1,134.00 $ 2,775.01 $ 1,500.00 20-000-75-00-7001 EQUIPMENT $ $ $ $ $ $ $ $ $ $ 95.00 $ $ 95.00 $ 40,000.00 20-000-75-00-7002 K-9 EQUIPMENT $ $ $ $ $ $ $ $ $ $ $ $ $ 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 $ 1,379.95 $ 9,292.72 $ $ 35,629.10 $ 62,000.00 TOTAL FUND EXPENSES $ $ 95.00 $ 95.00 $ 42,690.00 $ 1,065.00 $ 4,784.05 $ 60.00 $ 486.01 $ 105.00 $ 95.00 $ 1,134.00 $ $ 50,609.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 $ 1,284.95 $ 8,158.72 $ $ (14,979.96) $ (42,000.00) PUBLIC WORKS CAPITAL REVENUES 21-000-42-00-4213 DEVELOPMENT FEES-PURL $ 6,050.00 $ 2,550.00 $ 1,400.00 $ 1,850.00 $ 3,250.00 $ 5,800.00 $ $ 700.00 $ $ 3,500.00 $ 25,100.00 $ 35,000.00 21-000-42-00-4288 MOWING INCOME $ 2,041.25 $ 337.81 $ 1,562.70 $ $ 3,941.76 $ 21-000-44-00-4430 SALE OF EQUIPMENT $ $ $ $ $ $ $ $ $ 1,620.00 $ $ 1,620.00 $ 21-000-44-00-4490 MISCELLANEOUS INCOME $ $ $ $ $ $ $ $ $ 1,005.00 $ 658.00 $ $ 1,663.00 $ PUBLIC WORKS CAPITAL EXPENSES 21-000-62-00-5401 CONTRACTUAL SERVICES $ $ $ $ $ $ $ $ $ $ $ 49.00 $ 49.00 $ 21-000-75-00-7001 EQUIPMENT $ $ $ (92.66) $ (492.12) $ (254.12) $ (214.11) $ (509.69) $ $ $ 1,562.70 $ $ $ 21-000-75-00-7005 VEHICLES $ $ $ $ $ $ $ $ $ $ $ $ $ 46,000.00 21-000-75-00-7015 SKIDSTEER UPGRADE $ $ $ $ $ $ $ $ $ $ $ $ $ 4,000.00 21-000-75-00-7107 TRUCK ACCESSORIES $ $ $ $ $ $ $ $ $ $ $ $ $ 5,000.00 21-000-75-00-7110 PW BUILDING PAYMENT $ 13,715.84 $ 6,857.92 $ 6,857.92 $ 6,857.92 $ 6,857.92 $ 6,857.92 $ 6,857.92 $ 6,857.92 $ 6,857.92 $ 6,857.92 $ 6,857.92 $ 82,295.04 $ 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 $ 3,840.70 $ 3,500.00 $ $ 32,324.76 $ 35,000.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 $ 8,420.62 $ 6,906.92 $ $ 82,344.04 $ 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) $ (4,579.92) $ (3,406.92) $ $ (50,019.28) $ (104,000.00) PARK&RECREATION CAPITAL REVENUES 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 CONSTR $ $ $ $ $ $ $ $ $ $ $ $ $ 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 $ 26.03 $ 6.07 $ 6.73 $ 92.42 $ PARK&RECREATION CAPITAL EXPENSES 22-610-75-00-7006 PICK 111 RUCK $ $ $ $ $ $ $ $ $ $ $ $ $ 22-610-75-00-7010 RAINTREE PARK $ $ 27516 $ 1,500.00 $ $ $ $ $ $ $ $ 7,227.25 $ 9,002.41 $ 158,135.00 22-610-75-00-7011 BASEBALL FIELD CONSTR $ $ $ $ $ $ 3,907.12 $ 4,950.00 $ 6,206.55 $ 592.25 $ $ $ 15,655.92 $ 15,000.00 TOTAL FUND REVENUES $ 356.72 1$ 6.52 1$ 6.95 1$ 6.94 1$ 656.51 1$ 6.72 1$ 656.511$ 6.72 1$ 26.03 1$ 6.07 1$ 1 6.73 1$ 11$ 1,742.42 1$ 17,500.00 6 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/4-14-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-30 June-10 July-10 August-10 September-10 October-10 November-30 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET TOTAL FUND EXPENSES $ $ 275.16 $ 1,500.00 $ $ $ 3,907.12 $ 4,950.00 $ 6,206.55 $ 592.25 $ $ 7,227.25 $ $ 24,658.33 $ 173,135.00 FUND SURPLUS(DEFICIT) $ 356.72 $ (268.64) $ (1,493.05) $ 6.94 $ 656.51 $ (3,900.40) $ (4,293.49) $ (6,199.83) $ (566.22) $ 6.07 $ (7,220.52) $ $ (22,915.91) $ (155,635.00) CITY WIDE CAPITAL REVENUES 23-000-40-00-3996 ROAD CONTRIBUTION $ 12,000.00 $ $ 2,000.00 $ $ $ 2,000.00 $ $ $ $ $ 6,000.00 $ 22,000.00 $ 24,000.00 23-000-42-00-4211 ENGINEERING CAPITAL F $ 800.00 $ 300.00 $ 200.00 $ 200.00 $ 400.00 $ 700.00 $ $ $ $ $ 500.00 $ 3,100.00 $ 4,000.00 23-000-44-00-4417 MISC.REIMBURSEMENTS $ $ $ $ $ $ $ $ $ $ 1,200.00 $ $ 1,200.00 $ 23-000-45-00-4501 SAFE RT TO SCHOOL(DE $ $ $ $ $ $ $ $ $ $ $ $ $ 46,200.00 23-000-45-00-4502 SAFE RT TO SCHOOL(CO $ $ $ $ $ $ $ $ $ $ $ $ $ 184,800.00 23-000-45-00-4508 STATE GRANTS $ $ $ $ $ $ $ $ $ $ $ 64,000.00 $ 64,000.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 $ 2.14 $ 2.37 $ 16.65 $ 23-000-49-00-4901 TRANSFER FROM GENERAL $ $ $ 40,625.00 $ $ $ 40,625.00 $ $ $ 40,625.00 $ $ $ 121,875.00 $ 162,500.00 23-000-49-00-4915 TRANSFER FROM MFT $ $ $ $ $ $ $ $ $ $ 96,000.00 $ $ 96,000.00 $ CITY WIDE CAPITAL EXPENSES 23-000-62-00-5401 CONTRACTUAL SERVICES $ $ $ $ $ $ $ $ $ $ 71.00 $ 1,200.00 $ 1,271.00 $ 23-000-75-00-7005 VEHICLES $ $ $ $ $ $ $ $ $ $ $ $ $ 4,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 REPLACEMENT $ $ $ $ $ 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 REPLACEMENT $ $ $ $ $ $ $ $ $ $ $ $ $ 50,000.00 23-000-75-00-7113 SAFE ROUTES TO SCHOOL $ $ $ $ $ $ $ $ $ $ $ $ $ 46,200.00 23-000-75-00-7114 SAFE RTS TO SCHOOL(C $ $ $ $ $ $ $ $ $ $ $ $ $ 184,800.00 23-000-75-00-7115 PALMER COURT $ $ $ $ $ $ $ $ $ $ $ $ $ 23-000-75-00-7116 TOWN SQUARE PARK $ $ $ $ $ $ $ $ $ $ $ $ $ 25,000.00 23-000-75-00-7117 FAXON ROAD ROW $ $ $ $ $ $ $ $ $ $ $ $ $ 85,000.00 23-000-75-00-7119 OLD JAIL n/a n/a n/a $ 161,569.00 n/a $ $ $ 51.00 $ $ (71.00) $ $ 161,549.00 $ 23-000-75-00-7130 PW BUILDING $ - $ $ - $ $ $ $ $ $ - $ - $ $ m $ - 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 $ 97,202.14 $ 70,502.37 $ $ 308,191.65 $ 421,500.00 TOTAL FUND EXPENSES1$ 125,000.00 $ $ $ 161,569.00 $ 5,934.11 $ $ 4,111.30 $ 490.06 $ $ $ 1,200.00 $ $ 298,304.47 $ 582,500.00 FUND SURPLUS(DEFICIT) $(112,200.00) $ 300.00 $ 42,825.00 $(161,369.00) $ (5,531.36) $ 43,327.37 $ (4,109.01) $ (487.69) $ 40,627.36 $ 97,202.14 $ 69,302.37 $ $ 9,887.18 $ (161,000.00) DEBT SERVICE REVENUES 42-000-44-00-4440 RECAPTURE-WATER/SEWER $ 225.00 $ 125.00 $ 75.00 $ 75.00 $ 125.00 $ 225.00 $ 25.00 $ 25.00 $ $ $ 125.00 $ 1,025.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 PRO $ $ $ $ $ $ $ $ $ $ $ $ $ 42-000-66-00-6071$650K ROAD IMPROV PRO $ 6,412.50 $ $ $ $ $ $ $ 101,412.50 $ $ $ $ 107,825.00 $ 107,825.00 42-000-66-00-6074$3.825M IN TOWN ROAD $ $ $ $ $ $ $ $ $ $ $ $ $ 42-000-66-00-6075$3.825M IN TOWN ROAD $ $ 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 $ $ 125.00 $ $ 323,078.00 $ 429,404.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 $ $ 125.00 $ $ (106,325.76) $ WATER OPERATIONS REVENUES 51-000-42-00-4240 BULK WATER SALES $ 110.00 $ (98.00) $ $ (149.00) $ (152.00) $ 397.77 $ (392.00) $ (392.00) $ 1,232.00 $ (463.34) $ 784.00 $ 877.43 $ 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,486.71 $ 267,714.18 $ (270.96) $ 1,457,056.98 $ 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 $ $ $ 2,625.00 $ 22,135.00 $ 32,000.00 51-000-42-00-4243 LEASE REVENUE-H20T $ 2,149.29 $ 2,149.29 $ 2,149.29 $ 5,408.29 $ 2,459.79 $ 2,149.29 $ 2,770.29 $ 2,149.29 $ 3,070.29 $ 2,534.77 $ 2,524.27 $ 29,514.15 $ 29,000.00 51-000-44-00-4417 REIMBURSEMENTS $ 4,318.88 $ $ $ $ 4,318.88 51-000-44-00-4490 MISCELLANEOUS INCOME $ $ $ $ $ $ $ $ $ $ (1.00) $ $ (1.00) $ 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 $ $ $ $ 895.01 $ 3,761.83 $ 51-000-46-00-4600 INVESTMENT INCOME $ 45.40 $ 133.06 $ 331.98 $ 192.15 $ 170.96 $ 318.84 $ 86.56 $ 78.78 $ 43.45 $ 37.71 $ 37.25 $ 1,476.14 1$ 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 $ 25,102.06 $ 26,935.69 $ 303,079.89 $ 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 $ 90.16 $ 187.84 $ 3,632.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 $ $ 67.50 $ $ 2,421.97 $ 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,462.48) $ 637.47 $ 2,587.77 $ 7,777.53 $ 6,000.00 51-000-62-00-5407 TREATMENT FACILITIES $ 2,570.83 $ 12,613.09 $ 23,621.71 $ 16,914.14 $ 27,066.32 $ 14,188.52 $ 25,126.35 $ 23,375.95 $ 20,118.36 $ 20,361.85 $ 11,532.10 $ 197,489.22 $ 230,000.00 51-000-62-00-5408 MAINTENANCE-EQUIPMENT $ $ $ 21.09 $ 196.02 $ $ $ $ 322.17 $ 251.00 $ 20.05 $ 95.38 $ 905.71 $ 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 $ 74.03 $ 107.94 $ 3,500.45 $ 9,000.00 51-000-62-00-5411 MAINTENANCE-COMPUTERS $ $ $ $ $ $ $ $ $ $ $ $ N1,770.06 $ 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 $ 180.23 $ 198.04 $ 420.86 $ $ 3,500.00 51-000-62-00-5434 RENTAL-EQUIPMENT $ $ $ $ $ $ $ $ $ $ $ $ $ 1,000.00 51-000-62-00-5435 ELECTRICITY $ $ 12,814.11 $ 21,659.93 $ 24,167.83 $ 11,916.48 $ 25,873.23 $ 24,057.99 $ 25,274.33 $ 9,589.63 $ 23,114.71 $ 31,189.74 $ $ 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 $ 1,240.07 $ 1,263.90 $ $ 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 $ 186.65 $ 113.45 $ $ 3,300.00 51-000-64-00-5600 DUES $ $ 367.00 $ $ $ $ $ $ $ $ 475.00 $ $ $ 1,000.00 51-000-64-00-5603 SUBSCRIPTIONS $ $ $ $ $ $ $ $ 57.20 $ $ $ $ $ 250.00 51-000-64-00-5604 TRAINING&CONFERENCE $ $ $ 330.00 $ $ $ 776.60 $ $ $ 735.00 $ $ $ $ 1,600.00 7 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/4-14-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-30 June-10 July-SO August-10 September-10 October-30 November-30 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 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 $ 681.82 $ 1,518.51 $ 13,591.94 $ 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 $ $ 1,004.04 $ 416.96 $ 14,003.52 $ 22,000.00 51-000-65-00-5809 PRINTING©ING $ $ 106.01 $ 103.67 $ 103.42 $ 103.58 $ 103.19 $ 105.07 $ 102.37 $ 109.60 $ 107.69 $ 105.88 $ 1,050.48 $ 2,500.00 51-000-65-00-5810 PUBLISHING&ADVERTIS $ $ $ 933.50 $ $ $ $ $ $ $ $ $ 933.50 $ 500.00 51-000-65-00-5812 GASOLINE $ $ 399.91 $ 3,077.08 $ 2,722.03 $ 2,885.30 $ 1,120.82 $ 1,893.89 $ 1,969.38 $ 3,811.61 $ 2,993.36 $ 2,877.68 $ 23,751.06 $ 34,000.00 51-000-65-00-5815 HAND TOOLS $ $ $ $ $ $ $ $ $ $ $ 146.32 $ 146.32 $ 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 $ 2,395.79 $ 2,579.48 $ 28,295.84 $ 31,017.00 51-000-72-00-6501 SOCIAL SECURITY&VIED $ 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 $ 1,837.15 $ 1,981.58 $ 22,378.55 $ 28,588.00 51-000-75-00-7002 COMPUTER EQUIP&SOFT $ $ $ $ $ $ $ 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 REPLACEMENT $ $ $ 110.39 $ $ $ $ $ $ 950.00 $ $ 302.00 $ 1,362.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 $ 4,223.33 $ 776.22 $ 26,367.80 $ 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 $ 8,832.45 $ 269,822.32 $ 6,594.57 $ $ 1,519,139.41 $ 1,351,050.00 TOTAL WATER OPERATIONS EXPENSES $ 36,184.59 $ 62,501.55 $ 111,816.43 $ 99,349.58 $ 73,994.59 $ 121,377.49 $ 91,953.02 $ 100,650.36 $ 90,554.79 $ 84,810.77 $ 85,139.30 $ $ 958,962.47 $ 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 $ (82,022.34) $ 185,011.55 1$ (78,544.73)1$ l$ 560,176.94 1$ 85,430.00 WATER IMPROVEMENTS REVENUES 51-200-42-00-4220 CONNECTION FEES $ 20,040.00 $ 14,020.00 $ 10,320.00 $ 6,360.00 $ 9,020.00 $ 15,040.00 $ 4,000.00 $ 3,700.00 $ $ $ 14,340.00 $ 99,840.00 $ 190,000.00 51-200-42-00-42501MPROVEMENT EXPANSION $ $ 112,450.47 $ 85.34 $ 114,171.19 $ 368.54 $ 112,611.98 $ 168.48 $ 115,327.97 $ 218.16 $ 114,495.07 $ 158.41 $ 570,055.91 $ 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 $ 3134 $ 20.61 1$ (4.84) $ 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 SVCS $ $ $ $ $ $ $ $ $ $ $ $ $ 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 $ 22,988.77 $ 22,988.77 $ 252,876.47 $ 269,856.00 51-200-66-00-6007 RADIUM COMPLIANCE BON $ 16,575.00 $ $ $ $ $ $ 16,575.00 $ $ $ $ $ 33,150.00 $ 51-200-66-00-6041 IEPA L17-156300 PRINC $ $ $ 62,515.08 $ $ $ $ $ $ 62,515.08 $ $ $ 125,030.16 $ 125,031.00 51-200-66-00-60421EPA L17-156300 INTER $ $ $ $ $ $ $ $ $ $ $ $ $ 51-200-66-00-60562006A REFUND.INTERES $ $ $ $ $ $ $ $ $ $ $ $ $ 51-200-66-00-60572006A REFUND.PRINCIPA $ $ 45,653.13 $ $ $ $ $ $ 115,653.13 $ $ $ $ 161,306.26 $ 161,307.00 51-200-66-00-6058 2002 PRINCIPAL PMT-NO $ 215,000.00 $ $ $ $ $ $ $ $ $ $ $ 215,000.00 $ 215,000.00 51-200-66-00-6059 2007A REFUNDING P&I P $ $ 62,133.13 $ $ $ $ $ $ $ $ $ $ 62,133.13 $ 51-200-66-00-6072 2005C INTEREST PMT-$2 $ $ $ $ $ $ $ $ $ $ $ $ $ 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 $ 114,495.07 $ 14,498.41 $ $ 670,266.71 $ 771,304.00 TOTAL WATER IMPROVEMENT EXPENSES $ 254,563.77 $ 150,950.03 $ 85,503.55 $ 22,988.77 $ 22,988.77 $ 22,958.77 $ 39,563.77 $ 263,991.90 $ 85,503.85 $ 22,958.77 $ 22,988.77 $ $ 995,021.02 $ 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) $ 91,506.30 $ (8,490.36) $ $ (324,754.31) $ (85,753.00) COMBINED WATER IMPROVEMENT&OPERATIONS FUNDS TOTAL FUND REVENUES $ 27,094.63 $ 428,639.38 $ 19,966.60 $ 451,457.05 $ 19,159.36 $ 435,759.40 $ 12,682.22 $ 383,474.93 $ 9,045.77 $ 384,317.39 $ 21,092.98 $ $ 2,189,406.12 $ 2,122,354.00 TOTAL FUND EXPENSES $ 290,748.36 $ 213,751.58 $ 197,320.28 $ 122,338.35 $ 96,983.36 $ 144,366.26 $ 131,516.79 $ 364,672.26 $ 176,358.64 $ 107,799.54 $ 108,128.07 $ $ 1,953,983.49 $ 2,122,677.00 FUND SURPLUS(DEFICIT) $(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,312.87)1$ 276,517.85 1$ (87,035.09)1$ 11$ 235,422.63 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 $ 121,463.91 $ (243.13) $ 608,212.66 $ 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 $ (592,000.00) $ 600.00 $ 4,000.00 $ 25,000.00 52-000-44-00-4412 INSURANCE REIMBURSEMENT $ $ $ $ $ $ $ $ $ $ $ 1,042.03 $ 1,042.03 52-000-44-00-4417 REIMBURSEMENTS $ 3,379.48 $ $ $ (0.40) $ 3,379.08 52-000-44-00-4498 RECAPTURE $ $ $ $ $ $ $ $ $ $ $ $ $ 52-000-44-00-4499 BAD DEBT RECOVERY $ $ $ $ $ $ $ $ $ $ $ $ $ 52-000-46-00-4600 INVESTMENT INCOME $ 45.40 $ 133A6 $ 331.98 $ 192.14 $ 170.95 $ 318.84 $ 86.56 $ 78.78 $ 43.45 $ 37.71 $ 37.25 $ 1,476.12 $ 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 $ 17,631.84 $ 19,035.42 $ 212,835.54 $ 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 $ 109.95 $ 65.98 $ 3,179.21 $ 4,500.00 52-000-62-00-5408 MAINTENANCE-EQUIPMENT $ 123.89 $ $ $ 149.41 $ $ 34.99 $ $ 323.89 $ 191.25 $ $ $ 523.43 $ 5,000.00 52-000-62-00-5409 MAINTENANCE-VEHICLES $ $ 20.00 $ 20.00 $ 19.40 $ $ $ 390.50 $ 2,986.75 $ 39.86 $ 75.29 $ 159.11 $ 3,710.91 $ 4,000.00 52-000-62-00-5419 MAINTENANCE-SANITARY $ $ (695.56) $ 6.99 $ 281.15 $ 450.00 $ $ 13.78 $ 62.76 $ $ 229.20 $ $ 348.32 $ 20,000.00 S of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/4-14-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-30 June-10 July-10 August-10 September-30 October-30 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 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 $ 115.47 $ 180.34 $ 1,525.05 $ 2,500.00 52-000-62-00-5422 LIFT STATION MAINTENA $ $ 310.50 $ $ 777.30 $ 37.88 $ 636.73 $ 1,647.63 $ 5.98 $ 4.09 $ 6,096.04 $ $ 9,516.15 $ 15,000.00 52-000-62-00-5434 RENTAL-EQUIPMENT $ $ $ $ $ $ $ $ $ $ $ $ $ 1,000.00 52-000-62-00-5435 ELECTRICITY $ $ 1,082.69 $ 1,412.09 $ 2,083.33 $ 1,881.20 $ 1,298.66 $ 1,331.52 $ 1,373.92 $ 2,804.59 $ 471.38 $ 2,466.36 $ 16,205.74 $ 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 $ 121.66 $ 63.01 $ 1,139.19 $ 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 $ $ 582.96 $ 889.17 $ 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 $ $ 95.70 $ 1,590.02 $ 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 $ 2,993.38 $ 2,877.69 $ 22,435.18 $ 26,000.00 52-000-65-00-5815 HAND TOOLS $ $ $ $ $ $ $ $ $ $ $ 133.33 $ 133.33 $ 1,000.00 52-000-65-00-5817 GRAVEL $ $ $ $ $ $ $ $ $ $ $ $ $ 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 $ 1,676.77 $ 1,810.24 $ 19,671.34 $ 21,949.00 52-000-72-00-6501 SOCIAL SECURITY&VIED $ 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 $ 1,285.79 $ 1,390.72 $ 15,578.33 $ 20,230.00 52-000-75-00-7002 COMPUTER EQUIP&SOFT $ $ $ $ $ $ $ $ $ $ $ $ $ 1,000.00 52-000-75-00-7003 OFFICE EQUIPMENT $ $ $ $ $ $ 4.99 $ $ $ $ $ $ 4.99 $ 500.00 52-000-75-00-7004 SAFETY EQUIPMENT $ $ 175.77 $ $ $ 995.00 $ $ $ $ 45.00 $ $ $ 1,215.77 $ 1,000.00 52-000-78-00-9099 BAD DEBT $ $ 13,877.05 $ $ $ $ $ $ $ $ $ $ 13,877.05 $ 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 $ (470,498.38) $ 1,435.75 $ $ 618,347.86 $ 606,800.00 F TOTAL SEWER OPERATIONS EXPENSES $ 21,309.61 $ 34,379.65 $ 46,210.59 $ 37,343.45 $ 17,754.63 $ 54,782.71 $ 26,364.19 $ 41,924.96 $ 47,714.96 $ 30,806.77 $ 28,860.86 $ $ 387,452.38 $ 509,620.00 FUND SURPLUS(DEFICIT) $ 93,650.42 1$ 88,284.52 $ (45,208.37) $ 385,353.24 $ (17,100.09)1$ 66,192.67 $ (26,855.76) $ 84,840.58 $ 130,468.53 $ (501,305.15) $ (27,425.11)1$ 11$ 230,895.48 $ 97,180.00 SEWER IMPROVEMENTS REVENUES 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 $ $ $ 5,400.00 $ 38,000.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 $ $ $ $ 698,000.00 $ $ $ 698,000.00 $ 100,000.00 SEWER IMPROVEMENTS EXPENSES 52-200-62-00-5401 CONTRACTUAL/PROF.SVC $ $ $ $ $ $ $ $ $ $ $ $ $ 52-200-62-00-5462 FOX HILL SEWER RECAPT $ $ $ $ $ $ $ $ $ $ $ $ $ 52-200-62-00-5463 LENNAR SEWER RECAPTUR $ $ $ $ $ $ $ 30,996.00 $ $ $ $ $ 30,996.00 $ 52-200-66-00-6003 2003A IRBB INTEREST P $ $ $ 36,826.25 $ $ $ $ $ $ 126,826.25 $ $ $ 163,652.50 $ 163,653.00 52-200-66-00-6004 2003A IRBB PRINC.PMT $ $ $ $ $ $ $ $ $ $ $ $ $ 52-200-66-00-600820048 PRINCIPAL PMT-C $ 51,650.00 $ $ $ $ $ $ $ 206,650.00 $ $ $ $ 258,300.00 $ 258,300.00 52-200-66-00-60112004A PRINCIPAL PMT-C $ $ 14,286.25 $ $ $ $ $ $ 174,286.25 $ $ $ $ 188,572.50 $ 188,572.00 52-200-66-00-6016 2005D INTEREST PMT-RO $ $ 192,975.00 $ $ $ $ $ $ 192,975.00 $ $ $ $ 385,950.00 $ 537,541.00 52-200-66-00-6017 2005C 2M ALT REV $ $ 20,175.00 $ $ $ $ $ $ $ $ $ $ 20,175.00 $ 82,850.00 52-200-66-00-6018 DEBT SERVICE $ 55,045.00 $ $ $ 55,045.00 $ $ $ $ 110,090.00 52-200-66-00-60501EPA LOAN L17-013000 $ $ $ 19,489.99 $ $ $ $ $ $ 19,48939 $ $ $ 38,979.98 $ 38,980.00 52-200-66-00-6055 IEPA LOAN L17-115300 $ $ $ $ 53,525.35 $ $ $ $ $ $ 53,525.35 $ $ 107,050.70 $ 107,051.00 52-200-66-00-60592007A BOND $ $ $ $ $ - $ $ $ 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 $ 698,000.00 $ $ 5,400.00 $ $ 736,000.00 $ 275,000.00 TOTAL SEWER IMPROVEMENT EXPENSES $ 51,650.00 $ 282,481.25 $ 56,316.24 $ 53,525.35 $ $ $ 30,996.00 $ 701,089.38 $ 146,316.24 $ 53,525.35 $ $ $ 1,375,899.81 $ 1,510,813.00 FUND SURPLUS(DEFICIT) $ (39,050.00) $ (278,881.25) $ (52,716.24) $ (51,725.35) $ 1,800.00 $ 5,400.00 1$ (28,996.00) $ (699,289.38)1$ 551,683.76 $ (53,525.35) $ 5,400.00 $ $ (639,899.81) $ (1,235,813.00) COMBINED SEWER IMPROVEMENT&OPERATIONS FUNDS TOTAL FUND REVENUES1$ 127,560.03 1$ 126,264.17 1$ 4,602.22 1$ 424,496.69 1$ 2,454.54 1$ 126,375.38 1$ 1,508.43 1$ 128,565.54 1$ 876,183.49 1$ (470,498.38)1$ 6,835.75 1$ 11$ 1,354,347.86 $ 881,800.00 TOTAL FUND EXPENSES $ 72,959.61 1$ 316,860.90 1$ 102,526.83 1$ 90,868.80 1$ 17,754.63 1$ 54,782.71 1$ 57,360.19 1$ 743,014.34 1$ 194,031.20 1$ 84,332.12 1$ 28,860.86 1$ 11$ 1,763,352.19 $ 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$ 682,152.29 1$ (554,830.50) $ (22,025.11) $ 11$ (409,004.33) $ (1,138,633.00) LAND CASH REVENUES 72-000-47-00-4700 OSLAD GRANT-PRAIRIE $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4701 GREENBRIAR $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4702 BIKE PATH GRANT $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4703 PRAIRIE GARDEN $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4704 OSLAND GRANT-WHISPE $ $ $ $ $ $ $ $ $ $ $ $ $ 320,000 72-000-47-00-4705 COUNTRY HILLS $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4706 WHEATON WOODS GRANT $ $ $ $ $ $ $ $ $ $ $ $ $ 30,000 72-000-47-00-4707 FOX HIGHLANDS $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4709 SUNFLOWER $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4712 RIVER'S EDGE $ $ $ $ $ $ $ $ 671.00 $ $ $ $ 671.00 $ 72-000-47-00-4714 WOODWORTH $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4715 WHITE OAK UNIT 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 WILDWOOD $ $ $ $ $ $ $ $ $ $ $ $ $ 9 o 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/4-14-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-30 June-10 July-SO August-10 September-10 October-30 November-30 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 72-000-47-00-4722 KYLN'S RIDGE $ - $ - $ - $ $ $ $ $ $ $ - $ - $ - $ - 72-000-47-00-4723 HEARTLAND CIRCLE $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4725 WINDETTE RIDGE $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4727 GRAND RESERVE $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4731 MONTALBANO HOMES $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4732 RAINTREE VILLAGE $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4734 WHISPERING MEADOWS(K $ $ $ $ $ $ $ $ $ $ $ $ $ 3,000 72-000-47-00-4735 PRAIRIE MEADOWS(MENAR $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4736 BRIARWOOD $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4737 CALEDONIA $ $ $ $ $ $ $ $ $ $ $ $ $ 38,000 72-000-47-00-4738 AUTUMN CREEK $ 2,051.14 $ 2,051.14 $ $ 2,051.14 $ 4,102.28 $ 6,153.42 $ $ $ $ $ 2,051.14 $ 18,460.26 $ 22,000 72-000-47-00-4739 WYNSTONE TOWNHOMES $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4740 VILLAS AT THE PRESERV $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4741 BAILEY MEADOWS $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4742 BLACKBERRY WOODS $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4743 CORNEILS CROSSING $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4744 HUDSON LAKES $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4745 PRESTWICK $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4746 WESTBURY $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4747 WESTHAVEN $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4748 WILLMAN $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4749 BLACKBERRY WOODS $ $ $ 568.18 $ $ $ $ $ $ $ $ $ 5681.18 $ 72-000-47-00-4750 KENDALLWOOD ESTATES 1$ 1$ I$ $ 72-000-47-00-4751 CANNONBALL RIDGE PARK $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4752 BRISTOL BAY LAND CASH $ $ $ 100,000.00 $ $ $ $ $ $ $ $ $ 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 PARK $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-75-00-7328 PRAIRIE MEADOWS(MENA $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-75-00-7330 WHISPERING MEADOWS(K $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-75-00-7332 CALEDONIA $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-75-00-7333 RAINTREE VILLAGE $ $ $ $ $ $ $ $ $ 28,000.00 $ $ $ 28,000.00 $ 495,000 72-000-75-00-7334 HOOVER HOLDING COSTS $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-75-00-7335 GRANDE RESERVE BIKE T $ $ $ $ $ $ $ $ $ $ $ $ $ 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 REVENUES $ 2,051.14 $ 2,051.14 $ 100,568.18 $ 2,051.14 $ 4,102.28 $ 6,153.42 $ $ 671.00 $ $ $ 2,051.14 $ $ 119,699.44 $ 413,000.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 $ $ $ $ 153,002.65 $ 665,449.00 FUND SURPLUS(DEFICIT) $ 2,051.14 $ 2,051.14 $ 54,793.42 $ (23,505.50) $ (50,790.42) $ (11,359.83) $ (10,000.00) $ (2,867.00) $ (55,727.30) $ $ 2,051.14 $ $ (63,303.21) $ (252,449.00) PARK&RECREATION OPERATING REVENUES 79-000-42-00-4270 FEES FOR PROGRAMS $ 8,942.50 $ 36,384.50 $ 13,556.00 $ 12,944.00 $ 6,887.00 $ 26,101.50 $ 17,347.80 $ 5,758.75 $ 5,187.42 $ 14,328.00 $ 6,308.04 $ 154,075.51 $ 225,000 79-000-42-00-4280 CONCESSIONS/ALL SALE $ 6,935.75 $ 10,307.76 $ 10,687.00 $ 709.50 $ 856.50 $ 174.50 $ 61.00 $ $ $ $ 15.00 $ 29,780.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 $ 140.00 $ 540.00 $ 5,497.00 $ 14,000 79-000-44-00-4404 TREE DONATIONS $ $ $ $ $ 350.00 $ 350.00 $ 225.00 $ $ $ $ $ 925.00 $ 600 79-000-44-00-4412 INSURANCE REIMBURSEMENTS $ 5,156.53 $ 2,172.90 $ $ 7,329.43 $ 79-000-44-00-4490 MISCELLANEOUS INCOME $ $ $ $ $ 79-000-45-00-4550 YOUTH SERVICES GRANT $ $ $ $ $ $ $ $ $ $ $ $ $ 500 79-000-46-00-4600 INVESTMENT INCOME $ 13.11 $ 22.97 $ 27.95 $ 32.92 $ 26.80 $ 31.17 $ 25.11 $ 23.32 $ 25.45 $ 20.43 $ 25.13 $ 277.39 $ 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 $ 35,914.50 $ 35,914.50 $ 395,059.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 $ 43,409.66 $ 43,409.66 $ 477,506.26 $ 520,916 TOTAL PARKS&RECREATION REVENUES $ 201,828.52 1$ 132,799.89 1$ 116,600.11 $ 102,348.58 1$ 192,153.36 1$ 113,629.33 1$ 96,986.07 1$ 86,256.23 1$ 90,377.59 $ 95,985.49 $ 86,212.33 $ $ 1,315,177.50 $ 1,479,990.00 PARK EXPENSES(FUND 79) 79-610-50-00-5107 SALARIES-PARKS $ 28,695.89 $ 27,427.07 $ 26,504.82 $ 41,346.65 $ 13,782.22 $ 40,877.93 $ 27,162.56 $ 27,457.18 $ 27,574.05 $ 26,755.92 $ 27,796.97 $ 315,681.26 $ 350,026 79-610-50-00-5136 SALARIES-PART-TIME $ 1,021.25 $ 3,513.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-EQUIPMENT $ 641.43 $ 473.35 $ 91.92 $ 1,332.52 $ 1,438.89 $ 1,508.67 $ 1,283.42 $ 57.98 $ 5,985.75 $ 1,152.73 $ 2,759.01 $ 16,785.67 $ 14,000 79-610-62-00-5417 MAINTENANCE-PARKS $ $ 631.89 $ 365.03 $ 11,331.12 $ 151.95 $ 468.16 $ 446.38 $ 1,180.00 $ 235.92 $ $ 188.45 $ 15,028.90 $ 34,000 10 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/4-14-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-30 June-30 July-10 August-10 September-30 October-30 November-30 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 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 $ 231.75 $ 269.08 $ 2,876.88 $ 4,100 79-610-62-00-5434 RENTAL-EQUIPMENT $ $ $ 148.50 $ $ $ $ $ $ $ 39.60 $ $ 188.10 $ 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 $ 162.49 $ 102.21 $ 1,452.23 $ 4,200 79-610-62-00-5445 LEGAL EXPENSES $ $ $ 500.00 $ 92.50 $ $ $ $ $ $ 46.25 $ $ 638.75 $ 4,000 79-610-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ $ $ $ 35.00 $ 274.00 $ 309.00 $ 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 $ 1,276.11 $ 406.06 $ 9,151.31 $ 20,000 79-610-65-00-5815 HAND TOOLS $ $ $ 39.95 $ 143.96 $ $ 22.97 $ 173.86 $ $ $ 302.92 $ 399.00 $ 1,082.66 $ 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 $ 2,544.47 $ 2,643.45 $ 29,144.25 $ 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 $ 1,972.84 $ 2,051.54 $ 24,543.14 $ 28,383 79-610-75-00-7002 COMPUTER EQUIP&SOFT $ $ $ $ $ $ $ $ $ $ $ $ $ 500 79-610-75-00-7003 OFFICE EQUIPMENT $ $ $ $ $ $ $ $ $ $ $ $ $ 500 79-610-75-00-7701 FLOWERS/TREES $ $ 473.21 $ $ $ $ $ 1$ $ $ $ 473.21 11$ 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 $ 34,550.08 $ 36,919.77 $ $ 436,189.89 $ 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 $ 13,788.56 $ 12,759.73 $ 230,624.11 $ 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 $ 1,945.75 $ 3,046.63 $ 19,294.84 $ 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 $ 993.00 $ 860.63 $ 10,791.02 $ 22,080 79-650-50-00-5137 SALARIES-OVERTIME $ $ $ $ $ $ $ $ $ $ $ $ $ 300 79-650-50-00-5150 SALARIES-INSTRUCTOR $ 1,087.50 $ 1,839.51 $ 2,372.7S $ 2,714.89 $ 2,267.75 $ 3,603.02 $ 2,429.79 $ 540.26 $ 794.69 $ 1,680.63 $ 1,743.50 $ 21,074.29 $ 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 $ 2,829.50 $ 2,971.63 $ 36,216.22 $ 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 EQ $ $ 250.24 $ 242.18 $ 239.48 $ 178.00 $ 178.00 $ 28197 $ 188.26 $ 216.27 $ 216.27 $ 212.57 $ 2,205.24 $ 3,500 79-650-62-00-5426 YOUTH SERVICES GRANT $ $ $ $ $ $ $ $ $ $ $ $ $ S00 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 $ 1,583.63 $ 1,372.15 $ 17,750.02 $ 22,000 79-650-62-00-5437 TELEPHONE/INTERNET $ $ $ 342.08 $ 341.40 $ 340.22 $ 339.15 $ 336.04 $ 337.14 $ 335.11 $ 332.18 $ 331.24 $ 3,034.56 $ 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 $ 162.49 $ 136.24 $ 1,611.68 $ 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 $ $ $ $ $ $ $ $ $ 259.00 $ $ 482.32 $ 1,500 79-650-64-00-5604 TRAINING AND CONFEREN $ $ $ $ 200.00 $ 5.00 $ $ 55.00 $ $ 420.00 $ $ $ 680.00 $ S00 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 $ 70.17 $ 87.61 $ 2,006.29 $ 3,000 79-650-6S-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 $ 1,577.47 $ 1,509.61 $ 46,243.54 $ 53,600 79-650-65-00-5804 OPERATING SUPPLIES $ $ 7.47 $ $ 163.33 $ $ 1.47 $ $ 13.47 $ 12.70 $ $ 190.00 $ 388.44 $ 1,000 79-650-65-00-5805 RECREATION EQUIPMENT $ $ $ $ $ $ $ $ $ $ $ $ $ 2,000 79-650-65-00-5808 POSTAGE&SHIPPING $ 800.00 $ $ 1,173.00 $ 800.00 $ $ 177.00 $ 1,796.00 $ $ 177.00 $ 110.48 $ 1,796.00 $ 6,829.48 $ 8,000 79-650-65-00-5812 GASOLINE $ $ 137.64 $ 286.71 $ 273.75 $ 288.32 $ 154.97 $ 112.64 $ 78.23 $ 117.95 $ 37.91 $ $ 1,488.12 $ 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 $ $ $ 350.00 $ 264.24 $ 12,062.68 $ 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 REFUND $ 346.00 $ 270.00 $ 619.00 $ 417.00 $ 195.00 $ 432.00 $ 132.00 $ 198.00 $ 153.00 $ 115.00 $ 70.00 $ 2,947.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 $ 1,322.70 $ 1,531.34 $ 22,419.16 $ 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 $ 1,391.16 $ 1,391.28 $ 21,930.04 $ 30,351 79-650-75-00-7002 COMPUTER EQUIP&SOFT $ $ 1,682.00 $ $ 918.00 $ $ $ $ $ $ $ $ 2,600.00 $ 2,600 79-650-78-00-9010 MISC RETAIL $ $ $ $ $ $ $ $ $ $ $ $ $ 3,000 79-650-99-00-9941 REPAYMENT OF GF LOAN $ $ $ $ $ $ $ $ $ $ $ $ $ 100,000 TOTAL RECREATION EXPENSES(FUND 79) $ 41,378.04 $ 47,528.47 $ 98,031.77 $ 80,273.74 $ 62,997.94 $ 63,694.90 $ 37,127.27 $ 64,312.15 $ 41,399.15 $ 28,765.90 $ 30,274.40 $ $ 595,783.73 $ 937,200.00 TOTAL FUND REVENUES1$ 201,828.52 1$ 132,799.89 1$ 116,600.11 1$ 102,348.58 1$ 192,153.36 1$ 113,629.33 1$ 96,986.07 1$ 86,256.23 1$ 90,377.59 1$ 95,985.49 1$ 86,212.33 1$ $ 1,315,177.50 $ 1,479,990.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 $ 63,315.98 $ 67,194.17 $ $ 1,031,973.62 $ 1,461,912.00 FUND SURPLUS(DEFICIT) $ 124,993.77 1$ 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$ 32,669.51 1$ 19,018.16 1$ $ 283,203.88 $ 18,078.00 REC CENTER REVENUES 80-000-42-00-4200 MEMBERSHIP FEES $ 30,448.00 $ 34,608.82 $ 30,919.00 $ 31,053.00 $ 30,963.00 $ 30,707.00 $ 34,959.00 $ 36,209.00 $ 39,855.05 $ 38,577.00 $ 40,391.00 $ 378,689.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 $ 913.85 $ 1,159.00 $ 6,168.85 $ 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 $ 1,498.75 $ 3,113.00 $ 26,438.50 $ 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 $ 845.00 $ 211.00 $ 7,755.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 $ 211.00 $ 446.00 $ 1,688.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 $ 11,894.10 $ 12,335.30 $ 122,033.04 $ 125,000 80-000-42-00-4280 CONCESSIONS $ 1,126.75 $ 1,90175 $ 1,443.00 $ 900.75 $ 923.75 $ 988.25 $ 1,034.50 $ 1,177.50 $ 1,373.75 $ 1,107.00 $ 1,374.05 $ 13,353.05 $ 12,000 11 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/4-14-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-30 June-30 July-SO August-10 September-30 October-30 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 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 $ 169.00 $ 347.00 $ 5,814.25 $ 3,000 80-000-42-00-4295 MISC RETAIL $ $ $ $ 209.50 $ 77.00 $ 78.00 $ 46.00 $ 26.50 $ 111.45 $ 781.50 $ 137.50 $ 1,467.45 $ 500 80-000-44-00-4400 DONATIONS/SPONSORSHIP $ $ 170.00 $ 90.00 $ $ $ $ 156.50 $ 90.00 $ 270.00 $ 2,270.00 $ $ 3,046.50 $ 2,000 80-000-45-00-4550 GRANTS/SCHOLARSHIPS $ $ $ $ $ $ $ $ $ $ $ $ $ 500 TOTAL REC CENTER REVENUES $ 43,862.75 $ 52,473.32 $ 42,500.00 $ 54,468.75 $ 49,273.00 $ 46,040.95 $ 49,177.25 $ 49,478.00 $ 61,449.44 $ 58,267.20 $ 59,513.85 $ $ 566,454.51 $ 609,000.00 REC CENTER EXPENSES 80-000-50-00-5107 SALARIES-REC CENTER $ 2,630.78 $ 2,630.77 $ 2,630.77 $ 3,946.14 $ 1,315.39 $ 3,946.14 $ 1,973.08 $ 2,630.77 $ 2,630.78 $ 2,630.77 $ 2,630.77 $ 29,596.16 $ 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 $ 3,805.18 $ 3,838.28 $ 31,917.71 $ 35,000 80-000-50-00-5136 SALARIES-PART TIME $ 7,760.13 $ 7,359.50 $ 6,294.88 $ 11,289.45 $ 3,410.63 $ 9,983.09 $ 8,214.09 $ 8,002.82 $ 7,951.76 $ 7,206.89 $ 7,164.75 $ 84,637.99 $ 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 $ 4,966.19 $ 3,646.00 $ 50,016.97 $ 65,000 80-000-62-00-5401 CONTRACTUAL SERVICES $ $ $ $ 8,895.00 $ $ 3,263.00 $ 1,187.20 $ $ 3,755.50 $ 1,302.50 $ 330.40 $ 18,733.60 $ 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 $ 259.55 $ 753.75 $ 8,763.65 $ 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 $ 324.89 $ 273.73 $ 2,801.89 $ 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 $ 539.32 $ 882.16 $ 8,768.60 $ 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 $ 18,000.00 $ 18,000.00 $ 215,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 $ 3,223.34 $ 2,709.43 $ 36,458.89 $ 28,000 80-000-62-00-5437 TELEPHONE/INTERNET/CA $ $ 116.54 $ 315.45 $ 318.75 $ 398.35 $ 318.15 $ 317.60 $ 324.03 $ 320.38 $ 323.26 $ 329.38 $ 3,081.89 $ 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 $ 32.50 $ 26.83 $ 296.83 $ 600 80-000-62-00-5439 PROPERTY TAX $ 26,839.85 $ $ 26,839.85 $ $ $ $ $ $ $ $ $ 53,679.70 $ 53,000 80-000-62-00-5440 SECURITY $ $ 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 $ 185.68 $ $ 1,284.76 $ 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 $ 1,428.98 $ 1,666.89 $ 16,573.95 $ 17,000 80-000-65-00-5804 OPERATING SUPPLIES $ $ 84.00 $ 42.79 $ 201.59 $ $ 399.00 $ 91.71 $ $ $ 112.48 $ 266.11 $ 1,197.68 $ 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 $ 1,027.30 $ 822.17 $ 8,758.01 $ 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 $ 781.00 $ 417.00 $ 6,459.50 $ 4,000 80-000-65-00-5842 MEMBERSHIP REFUNDS $ $ 103.00 $ 85.00 $ 149.00 $ 65.00 $ 58.00 $ 38.00 $ $ 122.00 $ 295.00 $ 57.00 $ 972.00 $ 1,500 80-000-72-00-6500 1 MRF $ 869.51 $ 713.97 $ 538.43 $ 1,262.46 $ 485.07 $ 1,417.17 $ 884.46 $ 863.58 $ 895.64 $ 924.77 $ 943.96 $ 9,799.02 $ 10,000 80-000-72-00-6501 SOCIAL SECURITY $ 1,292.76 $ 1,117.75 $ 1,089.80 $ 1,832.52 $ 610.50 $ 2,063.76 $ 1,429.38 $ 1,397.83 $ 1,32171 $ 1,411.92 $ 1,310.36 $ 14,879.29 $ 17,658 80-000-75-00-7002 COMPUTER EQUIP&SOFT $ $ 1,182.00 $ $ 1,998.00 $ $ $ $ $ $ $ $ 3,180.00 $ 3,200 80-000-75-00-7003 OFFICE EQUIPMENT $ $ $ $ $ $ $ $ $ $ $ $ $ 300 80-000-75-00-7500 PHONE SYSTEM $ $ $ $ $ $ $ $ $ $ $ $ $ 200 80-000-78-00-9002 NICOR $ $ 534.56 $ 615.79 $ 584.28 $ 581.20 $ 40.33 $ 667.20 $ 35.38 $ 3,806.47 $ 2,202.04 $ 2,322.90 $ 11,390.15 $ 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 $ 50,983.56 $ 48,391.87 $ $ 633,553.54 $ 675,301.00 TOTAL FUND REVENUES1$ 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 $ 58,267.20 $ 59,513.85 $ $ 566,454.51 $ 609,000.00 TOTAL FUND EXPENSES $ 86,167.03 $ 47,032.15 $ 70,610.29 1$ 70,440.07 $ 41,501.41 $ 61,227.79 $ 51,104.56 $ 46,058.35 $ 60,036.46 $ 50,983.56 1$ 48,391.87 $ $ 633,553.54 $ 675,301.00 FUND SURPLUS(DEFICIT) $ (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.98 1$ 7,283.64 1$ 11,121.98 1$ 11$ (67,099.03) $ (66,301.00) LIBRARY REVENUES 82-000-40-00-3992 LIBRARY BOND PROP.TA $ $ 46,202.10 $ 238,305.04 $ $ 61,763.69 $ 226,847.25 $ 15,972.38 $ $ $ $ $ 589,090.46 $ 605,924.00 82-000-40-00-4000 REAL ESTATE TAXES $ $ 49,561.68 $ 255,633.39 $ $ 66,254.82 $ 243,342.45 $ 17,133.81 $ 31,174.58 $ $ $ $ 663,100.73 $ 650,000.00 82-000-40-00-4010 PERSONAL PROPERTY TAX $ 923.01 $ 646.74 $ 656.91 $ 86.26 $ $ 1,265.56 $ $ 1,020.86 $ 523.16 $ $ 289.41 $ 5,411.91 $ 5,000.00 82-000-42-00-4211 DEVELOPMENT FEES-BU $ 2,125.00 $ $ $ $ 2,525.00 $ $ 3,425.00 $ $ $ 750.00 $ $ 8,825.00 $ 20,000.00 82-000-42-00-4215 DEVELOPMENT FEES-BO $ 2,125.00 $ $ $ $ 2,525.00 $ $ 3,425.00 $ $ $ 750.00 $ $ 8,825.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 $ 233.00 $ 197.20 $ 3,016.55 $ 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 $ 1,650.00 $ 1,050.00 $ 12,232.50 $ 15,000.00 82-000-42-00-4262 EXAM PROCTORING $ $ $ $ $ $ 5.00 $ $ $ 35.00 $ $ 15.00 $ 55.00 $ 82-000-42-00-4270 PROGRAM FEES $ $ $ $ $ $ $ $ $ $ $ $ 82-000-42-00-4286 DVD RENTAL INCOME $ $ $ $ $ 566.00 $ 530.00 $ 532.00 $ 447.00 $ 565.00 $ 527.00 $ 518.00 $ 3,685.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 $ 100.00 $ 150.00 $ 1,230.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 $ 1,018.70 $ 1,396.38 $ 12,984.39 $ 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 12 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/4-14-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-30 June-10 July-SO August-10 September-10 October-30 November-30 December-30 January-11 February-11 March-11 jApril-111 YEAR-TO-DATE ANNUAL TOTALS BUDGET 82-000-44-00-4450 MEMORIALS $ 90.00 $ 556.00 $ 20.00 $ 500.00 $ 25.00 $ 115.00 $ 405.00 $ 42.48 $ $ 80.00 $ 50.00 $ 1,883.48 $ 3,000.00 82-000-45-00-4550 GRANTS $ $ $ $ $ $ $ $ $ $ $ $ $82-000-45-00-4560 LIBRARY PER CAPITA GR $ $ $ $ $ $ $ $ 17,193.28 $ $ $ $ 17,193.28 $ 17,500.00 82-000-46-00-4600 INVESTMENT INCOME $ 117.54 $ 103.98 $ 138.27 $ 95.19 $ 30.12 $ 33.33 $ 47.25 $ 40.53 $ 26.27 $ 21.12 $ 20.02 $ 673.62 $ 10,000.00 TOTAL LIBRARY REVENUES $ 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 $ 5,129.82 $ 3,686.01 $ $ 1,328,507.07 $ 1,359,924.00 LIBRARY EXPENSES 82-000-50-00-5107 SALARIES-LIBRARY $ 39,538.14 $ 37,589.76 $ 36,942.16 $ 57,504.02 $ 15,617.36 $ 58,980.12 $ 39,696.85 $ 39,126.52 $ 37,497.76 $ 35,297.52 $ 39,962.01 $ 443,752.22 $ 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 $ $ 14,069.88 $ 70,349.40 $ 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 $ $ 206.70 $ 1,033.50 $ 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 $ $ 1,026.54 $ 5,132.70 $ 6,000.00 82-000-61-00-5322 BONDING $ $ 1,539.00 $ $ 1,383.00 $ $ $ $ $ $ $ $ 3,222.00 $ 5,000.00 82-000-61-00-5323 ATTORNEY $ $ $ $ 2,465.00 $ $ $ 540.00 $ $ $ 360.00 $ $ 3,365.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 $ 4,446.29 $ 3,010.04 $ 25,579.15 $ 40,000.00 82-000-62-00-5407 MAINTENANCE-BLDG/JANI $ $ 1,566.92 $ 949.92 $ 3,522.01 $ 651.21 $ 3,444.50 $ 575.00 $ 5,801.73 $ 371,72 $ 1,067.50 $ 528.00 $ 18,778.81 $ 30,000.00 82-000-62-00-5410 MAINTENANCE-OFFICE EQ $ $ $ $ 176.70 $ 183.97 $ $ 177.77 $ 950.73 $ $ 409.98 $ 280.35 $ 2,179.50 $ 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 $ 657.11 $ 866.12 $ 430.73 $ 692.06 $ 702.21 $ 854.95 $ 7,645.57 $ 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 $ 1,939.70 $ 2,411.23 $ 7,665.16 $ 40,000.00 82-000-62-00-5438 DATABASE $ $ $ $ $ $ 2,898.42 $ $ $ $ 990.00 $ $ 3,588.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 $ $ 1,114.99 $ 354.90 $ 7,215.80 $ 15,000.00 82-000-64-00-5604 TRAINING&CONFERENCE $ $ 330.39 $ 13.00 $ $ $ 226.71 $ 30.00 $ 300.00 $ $ $ 49.00 $ 949.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 $ 562.07 $ 212.45 $ 525.28 $ 739.99 $ $ 6,705.34 $ 144,561.00 82-000-65-00-5802 OFFICE SUPPLIES $ $ 522.46 $ 524.66 $ $ 803.54 $ 1,205.34 $ $ $ 53194 $ 346.53 $ 403.11 $ 4,639.85 $ 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 $ 298.51 $ 237.92 $ 3,735.61 $ 15,000.00 82-000-65-00-5807 CUSTODIAL SUPPLIES $ $ 550.52 $ 108.69 $ 1,135.57 $ 1,239.32 $ 318.21 $ 783.99 $ 800.20 $ 510.34 $ 879.45 $ 236.24 $ 6,862.83 $ 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 $ 21.86 $ 934.26 $ 2,075.45 $ 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 $ $ 77.26 $ 141.11 $ 571.23 $ 1,000.00 82-000-65-00-5832 VIDEOS $ $ 813.87 $ 507.24 $ 317.57 $ 763.61 $ 767.51 $ 584.15 $ 949.59 $ 476.75 $ 822.54 $ 1,065.56 $ 7,069.29 $ 25,000.00 82-000-65-00-5834 LIBRARY PROGRAMMING $ 325.00 $ 1,175.25 $ 579.16 $ 165.37 $ 652.91 $ 218.76 $ 571.70 $ 1,612.63 $ 511.89 $ 504.92 $ 1,172.44 $ 7,820.03 $ 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,531,89 $ 2,226.66 $ 2,972.97 $ 5,080.94 $ 4,037.53 $ 2,657.04 $ 115.27 $ 1,006.50 $ 2,641.53 $ 25,205.73 $ 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 $ 5,899.32 $ 5,968.78 $ 3,398.53 $ 1,048.01 $ 39,188.52 $ 50,000.00 82-000-65-00-5838 BOOKS-AUDIO $ $ 842.64 $ 220.93 $ 107.97 $ 1,252.65 $ 795.23 $ 32632 $ 636.66 $ 574.86 $ 1,494.93 $ 2,667.53 $ 8,920.32 $ 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 $ $ 1,438.67 $ 2,288.97 $ 10,937.29 $ 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 $ $ 13,141.20 $ $ 19,707.06 $ 20,000.00 82-000-65-00-5843 CD-S/MUSIC $ $ 71.95 $ 335.76 $ 126.91 $ 453.68 $ 137.94 $ 365.74 $ $ $ 129.91 $ 164.59 $ 1,786.75 $ 15,000.00 82-000-65-00-5844 MEETING ROOM $ $ $ $ $ $ $ 500.00 $ $ $ $ $ 500.00 $ 1,000.00 82-000-66-00-6012 20058 LIBRARY BOND $ $ 159,562.51 $ $ $ $ $ $ 234,562.51 $ $ $ $ 394,125.02 $ 394,125.00 82-000-66-00-6014 2006 LIBRARY BOND $ $ 30,900.00 $ $ $ $ $ $ 180,900.00 $ $ $ $ 211,500.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 $ 1,761.50 $ 1,761.50 $ 19,401.94 $ 22,000.00 82-000-72-00-6501 SOCIAL SECURITY/MEDIC $ 2,974.12 $ 2,825.03 $ 2,775.50 $ 4,323.28 $ 1,398.95 $ 4,461.49 $ 2,986.34 $ 2,942.59 $ 2,815.02 $ 2,879.20 $ 3,006.57 $ 33,391.09 $ 55,000.00 82-000-75-00-7002 COMPUTER EQUIPMENT& $ $ $ 2,820.23 $ $ $ $ 719.50 $ $ $ $ 4,097.00 $ 7,636.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 $ 3,838.07 $ 7.20 $ 45,327.81 $ 40,000.00 82-000-75-00-7703 BUILDING EXPANSION $ $ 6,199.55 $ $ $ $ $ $ $ $ $ $ 6,199.55 $ TOTAL LIBRARY EXPENSES1$ 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 $ 82,108.36 $ 84,657.74 $ $ 1,476,080.29 $ 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 $ 5,129.82 $ 3,686.01 $ $ 1,328,507.07 $ 1,359,924.00 TOTAL FUND EXPENSESE$ 45,275.26 1$ 270,716.50 1$ 73,692.41 1$ 97,565.50 1$ 49,699.25 1$ 101,105.05 1$ 75,024.66 1$ 497,651.36 1$ 98,583.90 1$ 82,108.36 1$ 84,657.74 1$ 11$ 1,476,080.29 1$ 2,155,986.00 FUND SURPLUS(DEFICIT) $ (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) $ (76,978.54) $ (80,971.73) $ 11$ (147,573.22) $ (799,062.00) FOX INDUSTRIAL REVENUES 85-000-40-00-4090TIFREVENUES $ $ 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.55 $ 1.47 $ 1.36 $ $ $ 13.49 $ 50.00 FOX INDUSTRIAL EXPENSES 85-000-66-00-6021 FOX IND BOND-PRINCIPA $ 4,966.25 $ $ $ $ $ $ 70,000.00 $ $ $ $ $ 74,966.25 $ 79,933.00 85-000-66-00-6022 FOX IND BONDANT PAYM $ $ $ $ $ $ $ 4,966.25 $ $ $ $ $ 4,966.25 $ 85-000-78-00-9007 ADMINISTRATION FEES $ $ 116.25 $ 92.50 $ $ $ $ $ $ 222.00 $ 138.75 $ 1,020.25 $ 1,589.75 $ 500.00 TOTAL FUND REVENUES $ 1.13 $ 107,260.89 $ 24,293.22 $ 3,479.55 $ 83,116.02 $ 5,772.42 $ 4,433.87 $ 1.47 $ 1.36 $ $ $ $ 228,359.96 $ 216,727.00 TOTAL FUND EXPENSES $ 4,966.25 $ 116.25 $ 92.50 $ $ $ $ 74,966.25 $ $ 222.00 $ 138.75 $ 1,020.25 $ $ 81,522.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) $ (135.75) $ (1,020.25) $ $ 146,537.71 $ 136,294.00 COUNTRYSIDE TIF REVENUES 87-000-40-00-4090TIF REVENUES $ $ 3,058.20 1$ 127.42 1$ $ 3,153.76 $ 31.56 $ 0.61 $ $ $ $ $ 6,371.85 $ 6,250.00 87-000-46-00-4600 INVESTMENT INCOME $ 498.76 $ 499.01 $ 456.60 $ 394.26 $ 394.32 $ 407.53 $ 220.21 $ 220.27 $ - $ - $ $ 3,090.96 $ 6,104.00 13 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/4-14-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-30 June-30 July-10 August-10 September-10 October-10 November-10 December-30 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET COUNTRYSIDE TIF EXPENSES 87-000-66-00-6002 COUNTRYSIDE TIF-INTER $ $ $ $ $ $ $ $ $ $ $ $ $ 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.SO $ $ $ $ $ $ $ 138.75 $ 900.00 $ 1,247.SO $ 1,000.00 87-000-78-00-9010 RESERVE-FUTURE BOND PMT $ $ $ $ $ $ $ $ $ $ $ TOTAL FUND REVENUES $ 498.76 $ 3,557.21 $ 584.02 $ 394.26 $ 3,548.08 $ 439.39 $ 220.82 $ 220.27 $ $ $ $ $ 9,462.81 $ 12,354.00 TOTAL FUND EXPENSES $ 68,546.25 $ 116.25 $ 92.50 $ $ $ $ 238,546.25 $ $ $ 138.75 $ 900.00 $ $ 308,340.00 $ 308,093.00 FUND SURPLUS(DEFICIT) $ (68,047.49) $ 3,440.96 $ 491.52 $ 394.26 $ 3,548.08 $ 439.39 1$ (238,325.43)1$ 220.27 $ 1$ (138.75) $ (900.00) $ $ (298,877.19) $ (295,739.00) DOWNTOWN TIF REVENUES 88-000-40-00-4090TIF REVENUES $ $ 40,820.24 $ 1,720.46 $ 1,758.58 $ 20,840.99 $ 4,567.75 $ 5,653.65 $ $ $ $ 75,361.67 $ 88,550.00 DOWNTOWN TIF EXPENSES 88-000-78-00-9007 ADMINISTRATIVE FEES $ $ 116.25 $ $ $ 500.00 $ $ $ 46.25 $ 333.00 $ 900.00 $ 1,895.50 $ 1,500.00 TOTAL FUND REVENUES $ $ 40,820.24 $ 1,720.46 $ 1,758.58 $ 20,840.99 $ 4,567.75 $ 5,653.65 $ $ $ $ 88,550.00 TOTAL FUND EXPENSES $ 1$ 116.25 1$ $ $ 500.00 $ $ $ 46.25 $ $ 333.00 $ 900.00 1$ 1,895.50 1 S 1,500.00 FUND SURPLUS(DEFICIT) $ 1$ 40,703.99 1$ 1,720.46 1$ 1,758.58 1$ 20,340.99 1$ 4,567.75 1$ 5,653.65 1$ (46.25) $ 1$ (333.00) $ (900.00) $ 11$ 73,466.17 1$ 87,050.00 14 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR PARKS&RECREATION DATE OF REPORT 4/14/11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-30 June-10 July-30 August-30 September-30 October-10 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET LAND CASH REVENUES 72-000-47-00-4700 OSLAD GRANT-PRAIRIE $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4701 GREENBRIAR $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4702 BIKE PATH GRANT $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4703 PRAIRIE GARDEN $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4704 OSLAND GRANT-WHISPE $ $ $ $ $ $ $ $ $ $ $ $ $ 320,000 72-000-47-00-4705 COUNTRY HILLS $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4706 WHEATON WOODS GRANT $ $ $ $ $ $ $ $ $ $ $ $ $ 30,000 72-000-47-00-4707 FOX HIGHLANDS $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4709 SUNFLOWER $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4712 RIVER'S EDGE $ $ $ $ $ $ $ $ 671.00 $ $ $ $ 671.00 $ 72-000-47-00-4714 WOODWORTH $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4715 WHITE OAK UNIT 1&2 $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4716 WHITE OAK UNIT 3&4 $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4717 KYLN'S CROSSING $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4718 FOXFIELD II PARK $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4719 WILDWOOD $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4722 KYLN'S RIDGE $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4723 HEARTLAND CIRCLE $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4725 WINDETTE RIDGE $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4727 GRAND RESERVE $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4731 MONTALBANO HOMES $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4732 RAINTREE VILLAGE $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4734 WHISPERING MEADOWS(K $ $ $ $ $ $ $ $ $ $ $ $ $ 3,000 72-000-47-00-4735 PRAIRIE MEADOWS(MENAR $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4736 BRIARWOOD $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4737 CALEDONIA $ $ $ $ $ $ $ $ $ $ $ $ $ 38,000 72-000-47-00-4738 AUTUMN CREEK $ 2,051.14 $ 2,051.14 $ $ 2,051.14 $ 4,102.28 $ 6,153.42 $ $ $ $ $ 2,051.14 $ 18,460.26 $ 22,000 72-000-47-00-4739 WYNSTONE TOWNHOMES $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4740 VILLAS AT THE PRESERV $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4741 BAILEY MEADOWS $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4742 BLACKBERRY WOODS $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4743 CORNEILS CROSSING $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4744 HUDSON LAKES $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4745 PRESTWICK $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4746 WESTBURY $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4747 WESTHAVEN $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4748 WILLMAN $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4749 BLACKBERRY WOODS $ $ $ 568.18 $ $ $ $ $ $ $ $ $ 568.18 $ 72-000-47-00-4750 KENDALLWOOD ESTATES $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4751 CANNONBALL RIDGE PARK $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4752 BRISTOL BAY LAND CASH $ $ $ 100,000.00 $ $ $ $ $ $ 1$ 1$ I$ 100,000.00 1$ LAND CASH EXPENSES 72-000-75-00-7308 RIVERS EDGE PARK#2 $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-75-00-7317 HEARTLAND CIRCLE $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-75-00-7326 MOSIER HOLDING COSTS $ $ $ $ $ $ $ 10,000.00 $ $ $ $ $ 10,000.00 $ 10,000 72-000-75-00-7327 GRANDE RESERVE PARK $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-75-00-7328 PRAIRIE MEADOWS(MENA $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-75-00-7330 WHISPERING MEADOWS(K $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-75-00-7332 CALEDONIA $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-75-00-7333 RAINTREE VILLAGE $ $ $ $ $ $ $ $ $ 28,000.00 $ $ $ 28,000.00 $ 495,000 72-000-75-00-7334 HOOVER HOLDING COSTS $ $ $ $ $ $ $ $ $ $ $ $ $ 72-000-75-00-7335 GRANDE RESERVE BIKE T $ $ $ $ $ $ $ $ $ $ $ $ $ 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 PA $ $ $ 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 REVENUES $ 2,051.14 $ 2,051.14 $ 100,568.18 $ 2,051.14 $ 4,102.28 $ 6,153.42 $ $ 671.00 $ $ $ 2,051.14 $ $ 119,699.44 $ 413,000.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) $ $ 2,051.14 $ $ (63,303.21) $ (252,449.00) PARK&RECREATION OPERATING REVENUES 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 $ 14,328.00 $ 6,308.04 $ 154,075.51 $ 225,000 79-000-42-00-4280 CONCESSIONS/ALL SALE $ 6,93835 $ 10,307.76 $ 10,687.00 $ 709.50 $ 886.50 $ 174.50 $ 61.00 $ $ $ $ 15.00 $ 29,780.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 1$ $ $ $ 9,935.50 1$ 15,000 l of4 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR PARKS&RECREATION DATE OF REPORT 4/14/11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-10 July-10 August-10 September-10 October-10 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 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 $ 140.00 $ 540.00 $ 5,497.00 $ 14,000 79-000-44-00-4404 TREE DONATIONS $ $ $ $ $ 350.00 $ 350.00 $ 225.00 $ $ $ $ - $ 925.00 $ 600 79-000-44-00-4412 INSURANCE REIMBURSEME S $ 5,156.53 $ 2,172.90 $ - $ 7,329.43 $ 79-000-44-00-4490 MISCELLANEOUS INCOME $ $ $ - $ $ 79-000-45-00-4550 YOUTH SERVICES GRANT $ $ $ $ $ $ $ $ $ $ $ - $ $ 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 $ 20.43 $ 25.13 $ 277.39 $ 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 $ 35,914.50 $ 35,914.50 $ 395,059.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 $ 43,409.66 $ 43,409.66 $ 477,506.26 $ 520,916 TOTAL PARKS&RECREATION REVENUES $ 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 $ 95,985.49 $ 86,212.33 $ $ 1,315,177.50 $ 1,479,990.00 PARK EXPENSES(FUND 79) 79-610-50-00-5107 SALARIES-PARKS $ 28,695.89 $ 27,427.07 $ 26,804.82 $ 41,346.65 $ 13,782.22 $ 40,877.93 $ 27,162.56 $ 27,457.18 $ 27,574.05 $ 26,755.92 $ 27,796.97 $ 315,681.26 $ 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 $ m $ $ $ $ $ 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-EQUIPMEN $ 641.43 $ 473.35 $ 91.92 $ 1,332.52 $ 1,438.89 $ 1,508.67 $ 1,283.42 $ 57.98 $ 5,985.75 $ 1,182.73 $ 2,789.01 $ 16,785.67 $ 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 $ m $ 188.45 $ 15,028.90 $ 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 $ 231.75 $ 269.08 $ 2,876.88 $ 4,100 79-610-62-00-5434 RENTAL-EQUIPMENT $ $ $ 148.50 $ $ $ $ m I$ $ $ 39.60 $ $ 188.10 $ 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 $ 162.49 $ 102.21 $ 1,452.23 $ 4,200 79-610-62-00-5445 LEGAL EXPENSES $ $ $ 500.00 $ 92.50 $ $ $ $ $ $ 46.25 $ $ 638.75 $ 4,000 79-610-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ $ $ $ 35.00 $ 274.00 $ 309.00 $ 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 $ 1,276.11 $ 406.06 $ 9,151.31 $ 20,000 79-610-65-00-5815 HAND TOOLS $ $ $ 39.95 $ 143.96 $ $ 22.97 $ 173.86 $ $ $ 302.92 $ 399.00 $ 1,082.66 $ 1,750 79-610-65-00-5824 CHRISTMAS DECORATIONS $ $ $ $ $ $ $ 6.86 $ 352.17 $ $ $ $ 359.03 $ 1,000 79-610-65-00-5825 PUBLIC DECORATION $ $ $ $ m $ $ $ $ $ $ $ $ $ 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 $ 2,544.47 $ 2,643.45 $ 29,144.25 $ 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 $ 1,972.84 $ 2,051.54 $ 24,543.14 $ 28,383 79-610-75-00-7002 COMPUTER EQUIP&SOFT $ $ $ $ $ $ $ $ $ $ $ $ $ 500 79-610-75-00-7003 OFFICE EQUIPMENT $ $ $ $ $ $ $ $ $ $ $ $ $ 500 79-610-75-00-7701 FLOWERS/TREES $ - $ 473.21 $ - $ - $ - $ - $ - $ $ - $ - $ 473.21 $ 500 TOTAL PARK EXPENSES(FUN5 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 $ 34,550.08 $ 36,919.77 $ $ 436,189.89 $ 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 $ 13,788.56 $ 12,759.73 $ 230,624.11 $ 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 $ 1,945.75 $ 3,046.63 $ 19,294.84 $ 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 $ 993.00 $ 860.63 $ 10,791.02 $ 22,080 79-650-50-00-5137 SALARIES-OVERTIME $ $ $ $ m $ $ $ m $ $ $ $ $ $ 300 79-650-50-00-5150 SALARIES-INSTRUCTOR $ 1,087.50 $ 1,839.51 $ 2,372.75 $ 2,714.89 $ 2,267.75 $ 3,603.02 $ 2,429.79 $ 540.26 $ 794.69 $ 1,680.63 $ 1,743.50 $ 21,074.29 $ 16,000 79-650-50-00-5155 SALARIES-RECORDING S $ $ 227.51 $ 237.50 $ m $ 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 $ 2,829.50 $ 2,971.63 $ 36,216.22 $ 50,000 79-650-62-00-5408 MAINTENANCE SUPPLIES $ $ 77.04 $ 62.70 $ m $ 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 EQ $ - $ 250.24 $ 242.18 $ 239.48 $ 178.00 $ 178.00 $ 283.97 $ 188.26 $ 216.27 $ 216.27 $ 212.57 $ 2,205.24 $ 3,500 79-650-62-00-5426 YOUTH SERVICES GRANT $ - $ $ $ $ $ $ $ $ $ m $ $ $ 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 $ 1,583.63 $ 1,372.15 $ 17,750.02 $ 22,000 79-650-62-00-5437 TELEPHONE/INTERNET $ - $ $ 342.08 $ 341.40 $ 340.22 $ 339.15 $ 336.04 $ 337.14 $ 335.11 $ 332.18 $ 331.24 $ 3,034.56 $ 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 $ 162.49 $ 136.24 $ 1,611.68 $ 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 $ $ $ $ $ $ $ $ $ 259.00 $ $ 482.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 $ $ $ $ $ $ $ m $ $ $ $ $ $ 79-650-65-00-5802 OFFICE SUPPLIES $ - $ 12.49 $ 35.87 $ 563.61 $ $ 797.73 $ 273.56 $ 27.45 $ 137.80 $ 70.17 $ 87.61 $ 2,006.29 $ 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 $ 1,577.47 $ 1,509.61 $ 46,243.54 $ 53,600 79-650-65-00-5804 OPERATING SUPPLIES $ - $ 7.47 $ $ 163.33 $ $ 1.47 $ $ 13.47 $ 12.70 $ $ 190.00 $ 388.44 $ 1,000 79-650-65-00-5805 RECREATION EQUIPMENT $ $ $ $ $ $ $ $ $ $ $ $ $ 2,000 79-650-65-00-5808 POSTAGE&SHIPPING $ 800.00 $ $ 1,173.00 $ 800.00 $ $ 177.00 $ 1,796.00 $ $ 177.00 $ 110.48 $ 1,796.00 $ 6,829.48 $ 8,000 79-650-65-00-5812 GASOLINE $ $ 137.64 $ 286.71 $ 273.75 $ 288.32 $ 154.97 $ 112.64 $ 78.23 $ 117.95 $ 37.91 $ $ 1,488.12 $ 3,000 79-650-65-00-5826 MILEAGE $ $ $ $ $ $ $ $ $ $ $ $ $ 300 2 of4 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR PARKS&RECREATION DATE OF REPORT 4/14/11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-10 July-10 August-10 September-10 October-10 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 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 $ $ $ 350.00 $ 264.24 $ 12,062.68 $ 18,000 79-650-65-00-5833 HOMETOWN DAYS EXPENSE $ $ 34.37 $ 48,295.00 $ 6,933.00 $ 37,296.09 $ 6,959.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 REFUND $ 346.00 $ 270.00 $ 619.00 $ 417.00 $ 195.00 $ 432.00 $ 132.00 $ 195.00 $ 153.00 $ 115.00 $ 70.00 $ 2,947.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 $ 1,322.70 $ 1,531.34 $ 22,419.16 $ 41,537 79-650-72-00-6501 SOCIAL SECURITY/MEDIC $ 2,122.74 $ 2,125.08 $ 1,913.36 $ 2,654.53 $ 1,031.00 $ 2,811.59 $ 1,906.76 $ 2,580.12 $ 1,699.42 $ 1,391.16 $ 1,391.28 $ 21,930.04 $ 30,351 79-650-75-00-7002 COMPUTER EQUIP&SOFT $ $ 1,652.00 $ $ 915.00 $ $ $ 79-650-78-00-9010 MISC RETAIL $ - $ - $ - $ - $ - $ 79-650-99-00-9941 REPAYMENT OF GF LOAN $ - $ - $ - $ - $ TOTAL RECREATION EXPENSES(FUND 79) $ 41,378.04 $ 47,528.47 $ 98,031.77 $ 80,273.74 $ 62,997.94 $ 63,694.90 $ 37,127.27 $ 64,312.15 $ 41,399.15 $ 28,765.90 $ 30,274.40 $ $ 595,783.73 $ 937,200.00 TOTAL FUND REVENUES $ 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 $ 95,985.49 $ 86,212.33 $ $ 1,315,177.50 $ 1, 2.0 479,990.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 $ 63,315.98 $ 67,194.17 $ $ 1,031,973.62 $ 1,461,910 FUND SURPLUS(DEFICIT) $ 124,993.77 $ 47,088.06 $ (20,845.73) $ (47,549.45) $ 110,373.83 $ (4,491.15) $ 25,316.37 $ (12,674.66) $ 9,305.17 $ 32,669.51 $ 19,018.16 $ $ 283,203.88 $ 18,078.00 REC CENTER REVENUES 80-000-42-00-4200 MEMBERSHIP FEES $ 30,448.00 $ 34,608.82 $ 30,919.00 $ 31,053.00 $ 30,963.00 $ 30,707.00 $ 34,959.00 $ 36,209.00 $ 39,855.05 $ 38,577.00 $ 40,391.00 $ 378,659.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 $ 913.85 $ 1,159.00 $ 6,165.85 $ 3,500 80-000-42-00-4220 SWIM CLASS $ 1,388.00 $ 7,O82.25 $ 4,821.50 $ 1,154.00 $ 1,760.00 $ 1,392.00 $ 2,045.25 $ 765.00 $ 1,415.75 $ 1,498.75 $ 3,113.00 $ 26,438.50 $ 35,000 80-000-42-00-4230 PERSONAL TRAINING FEE $ 1,002.00 $ 915.00 $ 476.00 $ 40.00 $ 1,338.00 $ 257.00 $ 725.00 $ 698.00 $ 1,245.00 $ 845.00 $ 211.00 $ 7,755.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 $ 211.00 $ 446.00 $ 1,688.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,357.50 $ 14,360.44 $ 11,594.10 $ 12,335.30 $ 122,033.04 $ 125,000 80-000-42-00-4280 CONCESSIONS $ 1,126.75 $ 1,903.75 $ 1,443.00 $ 900.75 $ 923.75 $ 985.25 $ 1,034.50 $ 1,177.50 $ 1,373.75 $ 1,107.00 $ 1,374.05 $ 13,353.05 $ 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 $ 169.00 $ 347.00 $ 5,514.25 $ 3,000 80-000-42-00-4295 MISC RETAIL $ $ $ $ 209.50 $ 77.00 $ 78.00 $ 46.00 $ 26.50 $ 111.45 $ 781.50 $ 137.50 L$ � 500 80-000-44-00-4400 DONATIONS/SPONSORSHIP $ - $ 170.00 $ 90.00 $ - $ - $ - $ 156.50 $ 90.00 $ 270.00 $ 2,270.00 $ - $ 2,000 80-000-45-00-4550 GRANTS/SCHOLARSHIPS $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - 50 0 TOTAL REC CENTER REVENUES $ 43,862.75 $ 52,473.32 $ 42,500.00 $ 54,468.75 $ 49,273.00 $ 46,040.95 $ 49,177.25 $ 49,478.00 $ 61,449.44 $ 58,267.20 $ 59,513.85 $ REC CENTER EXPENSES 80-000-50-00-5107 SALARIES-REC CENTER $ 2,630.78 $ 2,630.77 $ 2,630.77 $ 3,946.14 $ 1,315.39 $ 3,946.14 $ 1,973.08 $ 2,630.77 $ 2,630.78 $ 2,630.77 $ 2,630.77 $ 29,596.16 $ 33,543 80-000-50-00-5109 SALARIES-PRESCHOOL $ 2,564.18 $ 400.00 $ $ 2,172.71 $ 1,825.41 $ 6,195.28 $ 4,025.88 $ 3,741.51 $ 3,346.28 $ 3,505.18 $ 3,838.28 $ 31,917.71 $ 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,953.09 $ 8,214.09 $ 8,002.82 $ 7,951.76 $ 7,206.89 $ 7,164.75 $ 84,637.99 $ 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 $ 4,966.19 $ 3,646.00 $ 50,016.97 $ 65,000 80-000-62-00-5401 CONTRACTUAL SERVICES $ $ $ $ 8,895.00 $ $ 3,263.00 $ 1,157.20 $ $ 3,755.50 $ 1,302.50 $ 330.40 $ 18,733.60 $ 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 $ 259.55 $ 753.75 $ 8,763.65 $ 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 $ 324.89 $ 273.73 $ 2,501.89 $ 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 $ 539.32 $ 882.16 $ 8,765.60 $ 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 $ 350.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 $ 18,000.00 $ 18,000.00 $ 215,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,O83.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,551.87 $ 2,992.54 $ 3,223.34 $ 2,709.43 $ 36,458.89 $ 28,000 80-000-62-00-5437 TELEPHONE/INTERNET/CA $ $ 116.54 $ 315.45 $ 315.75 $ 398.35 $ 315.15 $ 317.60 $ 324.03 $ 320.38 $ 323.26 $ 329.38 $ 3,O81.89 $ 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 $ 32.50 $ 26.53 $ 296.83 $ 600 80-000-62-00-5439 PROPERTY TAX $ 26,839.85 $ $ 26,839.85 $ $ $ $ $ $ $ $ $ 53,679.70 $ 53,000 80-000-62-00-5440 SECURITY $ $ 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 $ 185.68 $ $ 1,254.76 $ 2,600 80-000-65-00-5803 PROGRAM EXPENSES $ 746.96 $ 1,094.78 $ 1,420.45 $ 1,727.69 $ 1,627.07 $ 1,554.99 $ 1,941.51 $ 1,839.67 $ 1,494.96 $ 1,425.98 $ 1,666.89 $ 16,573.95 $ 17,000 80-000-65-00-5804 OPERATING SUPPLIES $ $ 84.00 $ 42.79 $ 201.59 $ $ 399.00 $ 91.71 $ $ $ 112.48 $ 266.11 $ 1,197.68 $ 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 $ 1,027.30 $ 822.17 $ 8,755.01 $ 6,000 80-000-65-00-5840 SCHOLARSHIPS $ $ $ 17.50 $ $ $ 371.00 $ $ $ $ $ $ 385.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 $ 781.00 $ 417.00 $ 6,459.50 $ 45000 80-000-65-00-5842 MEMBERSHIP REFUNDS $ $ 103.00 $ 85.00 $ 149.00 $ 65.00 $ 58.00 $ 38.00 $ $ 122.00 $ 295.00 $ 57.00 $ 972.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 $ 924.77 $ 943.96 $ 9,799.02 $ 10,000 3 of UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR PARKS&RECREATION DATE OF REPORT 4/14/11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-10 July-10 August-10 September-10 October-10 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 80-000-72-00-6501 SOCIAL SECURITY $ 1,292.76 $ 1,117.75 $ 1,089.80 $ 1,832.52 $ 610.50 $ 2,063.76 $ 1,429.38 $ 1,397.83 $ 1,322.71 $ 1,411.92 $ 1,310.36 $ 14,879.29 $ 17,658 80-000-75-00-7002 COMPUTER EQUIP&SOFT $ $ 1,182.00 $ $ 1,998.00 $ $ - $ $ $ $ $ $ 3,180.00 $ 3,200 80-000-75-00-7003 OFFICE EQUIPMENT $ - $ $ $ $ $ - $ $ $ $ $ $ $ 300 80-000-75-00-7500 PHONE SYSTEM $ - $ $ - $ $ $ - $ $ $ $ $ $ $ 200 80-000-78-00-9002 NICOR $ - $ 534.56 $ 615.79 $ 584.28 $ 581.20 $ 40.33 $ 667.20 $ 35.38 $ 3,806.47 $ 2,202.04 $ 2,322.90 $ 11,390.15 $ 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 $ 50,983.56 $ 48,391.87 $ $ 633,553.54 $ 675,301.00 TOTAL FUND REVENUESI$ 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 $ 58,267.20 $ 59,513.85 $ $ 566,454.51 $ 609,000.00 TOTAL FUND EXPENSESE$ 86,167.03 1$ 47,032.15 1$ 70,610.29 1$ 70,440.07 1$ 41,501.41 li$ 61,227.79 1$ 51,104.56 1$ 46,058.35 1$ 60,036.46 1$ 50,983.56 1$ 48,391.87 1$ $ 633,553.54 $ 675,301.00 FUND SURPLUS(DEFICIT)I$ (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.98 1$ 7,283.64 1$ 11,121.98 1$ 11$ (67,099.03) $ (66,301.00) 4 af4 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-12 Kend'11 mly El<`E Agenda Item Summary Memo Title: Treasurer's Report for March 2011 Meeting and Date: Administration Committee 4/21/11 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Rob Fredrickson Finance Name Department Agenda Item Notes: UNITED CITY OF YORKVILLE TREASURER'S REPORT-for the period ended March 31,2011 Cash Basis Projected BGn Fund March Revenues %of YTD Expenses %of YTD Ending Fund Balance Revenues YTD Revenues Budget Budget March Expenses YTD Expenses Budget Budget Balance General Fund O1-General (492,939) 718,949 10,762,426 11,433,024 94% 788,193 9,936,683 11,376,981 87% 332,804 Library Fund 82-Library 571,002 3,686 1,328,507 1,359,924 98% 84,658 1,476,080 2,158,986 68% 423,429 Special Revenue Funds 15-Motor Fuel Tax 405,618 31,651 653,106 356,000 183% 41,690 386,384 475,600 81% 672,340 79-Parks and Recreation 25,151 86,212 1,315,178 1,479,990 89% 67,194 1,031,974 1,461,912 71% 308,355 72-Land Cash (603,425) 2,051 119,699 413,000 29% - 183,003 665,449 28% (666,728) 85-Fox Industrial TIF 423,351 - 228,360 216,727 105% 1,020 81,522 80,433 101% 570,189 87-Countryside TIF 2,477,758 9,463 12,354 77% 900 308,340 308,093 100% 2,178,881 88-Downtown TIF 136,294 75,362 88,550 85% 900 1,896 1,500 126% 209,760 11-Fox Hill SSA 2,226 19,894 19,463 102% 86 3,871 3,458 112% 18,249 12-Sunflower SSA 6,188 - 13,871 13,112 106% 86 7,616 8,253 92% 12,443 Debt Service Funds 42-Debt Service 7,628 125 323,078 429,404 75% 429,404 429,404 100% (98,698) Capital Funds 16-Municipal Building (607,724) 750 20,700 55,000 38% - - - - (587,024) 22-Park and Recreation Capital 66,852 7 1,742 17,500 10% 7,227 24,658 173,135 14% 43,936 20-Police Capital 210,284 9,293 35,629 62,000 57% 1,134 50,609 104,000 49% 195,304 21-Public Works Capital 157,807 3,500 32,325 35,000 92% 6,907 82,344 139,000 59% 107,788 23-City-Wide Capital (18,378) 70,502 308,192 421,500 73% 1,200 298,304 582,500 51% (8,491) Enterprise Funds 51-Water 339,360 21,093 2,189,406 2,122,354 103% 108,128 1,953,983 2,122,677 92% 574,783 52-Sewer 2,735,211 6,836 1,354,348 881,800 154% 28,861 1,763,352 2,020,433 87% 2,326,207 80-Recreation Center (127,815) 59,514 566,455 609,000 93% 48,392 633,554 675,301 94% (194,914) Total Funds 5,714,449 1,014,170 19,357,739 20,025,702 1,186,575 18,653,577 22,787,115 6,418,611 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-13 dal County El`E Agenda Item Summary Memo Title: Cash Statements for January and February 2011 Meeting and Date: Administration Committee 4/21/11 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Rob Fredrickson Finance Name Department Agenda Item Notes: UNITED CITY OF YORKVILLE CASH AND INVESTMENT SUMMARY-as of January 31,2011 CASH Cash-Operations Cash-Special Purpose Operation Aurora Special Purpose Grand Old Second Castle IL Funds Totals Old Second Castle Earthmovers Totals Totals General Fund 01-General (1,434,075) 749 (1,433,327) 1,852 58,667 123 60,642 (1,372,685) Special Revenue Funds 15-Motor Fuel Tax - - 650,599 - 650,599 650,599 72-Land Cash (668,496) - (668,496) - - (668,496) 85-Fox Industrial TIF 571,348 571,348 - - 571,348 87-Countryside TIF 18,428 18,428 2,161,492 2,161,492 2,179,920 88-Downtown TIF 210,799 210,799 - - 210,799 11-Fox Hill SSA 18,335 - 18,335 - 18,335 12-Sunflower SSA 12,528 12,528 12,528 Debt Service Funds 42-Debt Service (98,823) (98,823) (98,823) Capital Funds 16-Municipal Building (587,774) - (587,774) - (587,774) 20-Police Capital 185,860 185,860 185,860 21-Public Works Capital 115,775 115,775 - - 115,775 23-City-Wide Capital (79,007) - (79,007) 55,764 55,764 (23,243) Enterprise Funds 51-Water 218,598 218,598 - - 218,598 52-Sewer 2,256,481 2,256,481 2,256,481 Agency Funds 90-Developer Escrow 158,549 158,549 158,549 95-Trust&Agency 240,229 240,229 - - - - 240,229 Total City Funds 1,138,752 - 749 1,139,501 2,163,343 765,030 123 2,9289496 4,067,997 Distribution% 27.99% 0.00% 0.02% 53.18% 18.81% 0.00% 100.00% Library Fund 82-Library 260,874 - 260,874 331,728 - - 331,728 592,602 Distribution% 44.02% 0.00% 0.00% 55.98% 0.00% 0.00% 100.00% Park and Recreation Funds 79-Parks and Recreation - 314,935 - 314,935 - - 25 25 314,960 22-Park&Rec Capital 51,071 51,071 158,365 - 158,365 209,436 80-Recreation Center (206,775) - (206,775) - - - (206,775) Totals - 159,232 - 159,232 - 158,365 25 158,390 317,622 Distribution% 0.00% 50.13% 0.00% 0.00% 49.86% 0.01% 100.00% UNITED CITY OF YORKVILLE CASH AND INVESTMENT SUMMARY-as of February 28,2011 CASH Cash-Operations Cash-Special Purpose Operation Aurora Special Purpose Grand Old Second Castle IL Funds Totals Old Second Castle Earthmovers Totals Totals General Fund 01-General (1,350,824) - (1,350,824) 2,048 35,361 123 37,531 (1,313,293) Special Revenue Funds 15-Motor Fuel Tax - 645,855 - 645,855 645,855 72-Land Cash (668,566) - (668,566) - - (668,566) 85-Fox Industrial TIF 571,209 571,209 - - 571,209 87-Countryside TIF 18,428 18,428 2,161,353 2,161,353 2,179,781 88-Downtown TIF 210,660 210,660 - - 210,660 11-Fox Hill SSA 18,335 - 18,335 - 18,335 12-Sunflower SSA 12,528 12,528 12,528 Debt Service Funds 42-Debt Service (98,823) (98,823) (98,823) Capital Funds 16-Municipal Building (587,774) (587,774) - (587,774) 20-Police Capital 187,145 - 187,145 - - 187,145 21-Public Works Capital 111,195 111,195 - - 111,195 23-City-Wide Capital (77,807) - (77,807) 55,766 55,766 (22,041) Enterprise Funds 51-Water 299,094 299,094 - - 299,094 52-Sewer 2,230,890 2,230,890 2,230,890 Agency Funds 90-Developer Escrow 158,549 158,549 158,549 95-Trust&Agency 177,482 177,482 - - - - 177,482 Total City Funds 1,211,719 - 1,211,719 2,163,401 736,982 123 2,900,506 4,112,224 Distribution% 29.4701c 0.00% 0.00% 52.61% 17.92% 0.00% 100.00% Library Fund 82-Library 183,133 - 183,133 332,491 - - 332,491 515,624 Distribution% 35.52% 0.00% 0.00% 64.48% 0.00% 0.00% 100.00% Park and Recreation Funds 79-Parks and Recreation - 350,405 - 350,405 - - 25 25 350,430 22-Park&Rec Capital 51,071 51,071 158,371 - 158,371 2099442 80-Recreation Center (199,447) - (199,447) - - - (199,447) Totals - 202,029 - 202,029 - 158,371 25 158,396 360,425 Distribution% 0.00% 56.05% 0.00% 0.00% 43.94% 0.01% 100.00% D C/T y Reviewed By: Agenda Item Number J� A 0 Legal ❑ NB #4 1 ,II 11 Finance ❑ EST. �Z 1836 Engineer El-�� Tracking Number W City Administrator ■ °°°�°ov$edt `O Consultant ❑ County ❑ ADM 2011-14 Kentlall <4L.E Agenda Item Summary Memo Title: Amended Governing Ordinance Meeting and Date: Administration Committee 4/21/11 Synopsis: Amendment to Governing Ordinance to allow the Administration Committee to select the City Council liaison to the Cultural Commission. Council Action Previously Taken: Date of Action: CC 7/13/10 Action Taken: Amended Governing Ordinance approved by Ordinance 2010-36. Item Number: ADM 2010-37 Type of Vote Required: Majority Council Action Requested: Submitted by: Bart Olson Administration Name Department Agenda Item Notes: Red-line copy attached. STATE OF ILLINOIS ) ) ss. COUNTY OF KENDALL ) Ordinance No. 24M201 AN ORDINANCE AMENDING AND RESTATING THE GOVERNING ORDINANCE OF THE MAYOR AND CITY COUNCIL OF THE UNITED CITY OF YORKVILLE,KENDALL COUNTY,ILLINOIS WHEREAS, the City Council of the United City of Yorkville first passed a Governing Ordinance, on June 27, 2006 as Ordinance 2006-58, subsequently passed amendments to the Governing Ordinance, on November 14, 2006 as Ordinance 2006- 133, on June 26, 2007 as Ordinance 2007-49, July 10, 2007 as Ordinance 2007-50, July 24, 2007 as Ordinance 2007-53, on January 22, 2008 as Ordinance 2008-02, on April 22, 2008 as Ordinance 2008-27, on June 24, 2008, as Ordinance 2008-58A, on September 23, 2008, as Ordinance 2008-84, on March 24, 2009 as Ordinance 2009-16, on May 12, 2009 as Ordinance 2009-27, won January 12, 2010 as Ordinance 2010-06, and on July 13, 2010 as Ordinance 2010-36, and intends to amend said Ordinance and restate it in its entirety, by this Ordinance rendering this as the full text of the Governing Ordinance of the United City of Yorkville; and, WHEREAS,the City Council of the United City of Yorkville, in accordance with Illinois Compiled State Statutes, has the right to determine procedures for organizing and conducting all meetings of the City Council acknowledging that the City is bound by certain state and federal laws as well as legal precedents which cannot be supplanted by City Ordinance; and, 1 WHEREAS, in keeping with this right, the City Council has adopted Roberts Rules of Order to outline the procedure to be followed during meetings and to regulate the actions of Council members and the public in attendance at such meetings; and, WHEREAS, the Council has determined that, to further ensure the orderly #low of information presented at its meetings and to protect the integrity of all in attendance at such meetings, it requires an additional written policy to clarify and amend Roberts Rules; and WHEREAS, the Council has undertaken to compile a list of ethical standards for City elected officials which the Council wishes to be included in its written policy; and, WHEREAS, the Council also has determined that it is in the best interests of all members of the City Council and the residents of the United City of Yorkville that said policy should include guidelines that clarify the duties and rights of aldermen and the mayor as elected officials of the United City of Yorkville; and, WHEREAS, the Council also requires said policy to officially establish standing committees of the Council and to outline procedures for the organization of said committees, including the selection of membership and chairmen of said committees, so that membership and chairmanship shall be unbiased and non-partisan, and offer all aldermen an equal opportunity to understand City business. NOW, THEREFORE, BE IT ORDAINED by the Mayor and City Council of the United City of Yorkville, Kendall County, Illinois, that the following shall constitute the Governing Ordinance for the United City of Yorkville: 2 Governing Ordinance, United City of Yorkville Addressing: Ethical Standards—Elected Officials' Duties and Responsibilities, Meeting Standards and Committee Structure I. Ethical Standards—Elected Officials of the United City of Yorkville: A. Shall obey the Constitution and laws of the United States, of the State of Illinois, and the United City of Yorkville. B. Shall be dedicated to the concepts of effective and democratic local government. C. Shall strive to be trustworthy and to act with integrity and moral courage on behalf of one's constituents, so as to maintain public confidence in City government and in the performance of the public trust. D. Shall make impartial decisions, free of bribes, unlawful gifts, narrow special interests, or financial or other personal interests. E. Shall not invest or hold any investment, directly or indirectly, in any financial business, commercial or other private transaction that creates a conflict with official duties. F. Shall extend equal opportunities and due process to all parties in matters under consideration. G. Shall recognize that the chief function of local government is at all times to serve the best interests of the residents of the United City of Yorkville. H. Shall work to keep the community informed on municipal affairs, encourage communication between residents and municipal officers; emphasize friendly and courteous service to the public; and seek to improve the quality and image of public service. I. Shall work to assure that government is conducted openly, efficiently, equitably, and honorably in a manner that permits residents to make informed judgments and hold City officials accountable. J. Shall show respect for persons, confidences and information designated as "confidential". K. Shall, when representing the City, act and dress in a manner appropriate for the function. L. Shall refrain from using city computers, the city server, etc. for political purposes. Elected officials are subject to the same rules of behavior that apply to Council 3 meetings, including refraining from making personal attacks against their fellow Council members, or defaming them in any way. The server and computers are to be used to disseminate information, not political propaganda. II. Duties and Rights of Elected Officials: Aldermen A. Shall, through their council votes, create the public policy that governs the United City of Yorkville, and provide oversight for the executive branch. B. Shall have the right to expect that the mayor and city's staff will provide them with clear and unbiased information to help them in their decision-making process. C. May, at their discretion, hold ward meetings in their ward, or devise other ways to better understand the wishes of their constituents. This is not meant to preclude aldermen from taking a city-wide view of the impact of an item under discussion, but to underline that aldermen are empowered to act on behalf of their constituents, and should be apprised of all items that are brought to the City that in any way pertain to their Ward. It is recommended that as a courtesy the Alderman holding the meeting should contact the other alderman in the ward, in advance, about the meeting. D. Shall refrain from giving direction to any city employee. Policy is created by the entire City Council. If any alderman wishes to address any problems he or she sees occurring in the city, this problem may be brought to the attention of the mayor, the city administrator, department directors, or taken to the council as a whole for action. Requests for information are not to be considered as "giving direction." Mayor A. Shall perform all the duties which are prescribed by law, including ordinances, and shall take care that the laws and ordinances are faithfully executed. Shall from time to time and annually, give the corporate authorities information concerning the affairs of the municipality and may recommend for their consideration measures that the mayor believes expedient. (65 ILCS 5/3.1-35-10) B. Shall be a non-voting member of all standing committees. C. Shall make appointments to fill vacancies, with the advice and consent of the Council. 4 III. Meeting Standards Applicable to City Council Meetings Generally A. City Council Meetings shall be regularly scheduled to convene on the 2nd and 4"' Tuesday's of each month at 7:00 p.m. in the City Hall Council Chambers. B. City Council Meetings shall be generally conducted according to the agenda template attached hereto. C. The Mayor, or any 3 Aldermen, may call a special meeting by submitting the request in the form of a Notice, and an Agenda for the meeting, in writing to the City Clerk. The Clerk shall as soon as possible 1) deliver a copy of the Notice and Agenda to each Elected Official, 2) post the Notice and Agenda at City Hall, and 3) send a copy of the Notice and Agenda to all registered news media. No special meeting shall be called for a date less than 48 hours after the Notice and agenda have been submitted to the City Clerk. The Clerk shall submit a Certification of Notice as evidence of providing the notices set out above, including all Copies of Publication to the City Council, and said Certification of Notice shall be inserted into the record of the Special Meeting. (5 ILCS 120/2.02) D. Except during the time allotted for public discussion and comment, no person, other than a member of the council, or an officer, employee, independent contractor, or other person recognized by the presiding officer, shall address the Council, except with the consent of two of the members present. E. No ordinance or resolution shall be voted on at a City Council meeting unless the item to be voted on has been presented in its final form to the Corporate Authorities at least four days prior to the vote. F. No application presented during a public hearing shall be voted on during the same City Council meeting in which that public hearing is held. G. All attendees at every city council meeting shall put their cell phones, pagers, PDA's or similar devices on silent mode prior to all such meetings, and shall not communicate on such devices during any such meetings. Elected officials, and department heads may excuse themselves from a meeting in order to communicate on such devices. H. The standards concerning order of speaking and time limits set by this Governing Ordinance shall apply to all items, including motions, resolutions, ordinances or action items wherein a vote may be taken. 5 Aldermen A. Shall have the right to place an item on any committee meeting agenda for discussion. Shall have the right to place an item on any Council meeting agenda with the consent of three (3) aldermen. Shall have the right to vote to suspend the rules of order(regarding the order of discussion) to provide for an open discussion. B. Shall,before speaking at a meeting, first be recognized by the presiding officer, and shall address all remarks to the presiding officer, without a response from the presiding officer. C. May not move to end debate before every alderman who wishes to speak to an agenda item has had the opportunity to do so. A motion to end debate, or "call the question" shall require a two-thirds vote. (Roberts Rules (RONR (10th Edition)page 189, Section 16) D. May appeal a ruling by the Mayor to the Council as a whole. A majority vote can overturn the Mayor's ruling. (Roberts Rules (RONR (10th Edition) page 247, Section 24) E. May, by a two-thirds majority vote, expel a fellow alderman from a meeting for cause,but may not do so for the same cause a second time. (65 ILCS 3.1-40-15) F. May, upon the request of any two aldermen present, defer a report of a committee to the next regular meeting of the Council. G. Shall, during a meeting, have the option to be the first and last speaker on an item if he or she has placed the item on the Council agenda. H. Shall, after being appointed as a liaison to another city organization, be responsible for keeping all Council members informed of that organization's significant activities. I. Shall limit their remarks to the question under debate To this end, aldermen must never attack or make any allusion to the motives of aldermen. (RONR (10th Edition)page 41, line 31) J. May, before voting, participate in a special meeting to review nominees that the mayor appoints when the appointment is either to fill a vacancy in an elective or appointed office that requires the advice and consent of the City Council. 6 K. Shall elect from one of the Aldermen as Mayor Pro Tem pursuant to the Mayor Pro Tern Policy of the United City of Yorkville, attached hereto. Mayor A. Shall preside at every regular Council meeting fulfilling the normal and customary functions of the chairman of the meeting; in his absence the elected mayor-pro-tern shall preside. At ad hoc committee meetings of the Council, the chairman of the committee shall preside. B. Shall preserve order and decorum, may speak to points of order in preference to aldermen, and shall decide all questions of order, subject to appeal. In the case of disorderly conduct, the mayor shall have the power to request that the Council Chambers be cleared. C. Shall appoint the City Attorney to be parliamentarian of the Council. D. May, without relinquishing the chair, voice his opinion on items before the City Council. The mayor shall, immediately after stating the item under discussion, ask the alderman who has requested an item to be placed on the agenda if he or she wishes to introduce the item or the applicable Committee Chairman if no particular alderman has requested that the item be placed upon the agenda. The mayor shall recognize this alderman as the last one to speak to the item if the alderman requests to do so. E. Shall recognize each alderman wishing to speak to an agenda item in turn, rotating different sides of the question,pro and con, as much as possible. He shall give preference first to an alderman who has placed the item under discussion on the Council's agenda. F. Shall insure that any information he makes available to aldermen on an agenda item is given to all aldermen in the same timely fashion, so that all aldermen can make informed decisions. It is the mayor's responsibility to insure that any item brought to the mayor's attention that pertains to a project or problem in a City Ward should be brought immediately to the attention of that Ward's two aldermen. G. Shall not vote on any ordinance, resolution or motion except: i. When the vote of the alderman has resulted in a tie; ii. When one-half of the aldermen elected have voted in favor of an ordinance, resolution or motion even though there is not tie; and iii. When a vote greater than a majority of the corporate authorities is required. (65 ILCS 5/3.1-40-30) IV. 7 The Standing Committees of the City Council: I. Shall include the Public Works, Public Safety, Administration, and Economic Development Committees. II. The Public Works, Public Safety, Administration, and Economic Development Committees shall include four members (one from each ward) of the City Council, including the Mayor. The Mayor is a non-voting member of each committee. III. Shall be presided over by its chairman, who will conduct the business of the meeting. In the absence of the chairman, the vice-chairman shall conduct the business of the meeting. Chairman and vice-chairman shall serve two year appointments. Chairs, vice-chairs, and committee rosters shall be filled through the following process: A. For the Public Works, Public Safety, Administration, and Economic Development committees: after each election, the four committee chairmanships shall be vacated. The four vice-chairmen shall each select a committee to chair, with the most senior alderman having the first selection and progressing to the next most senior alderman, and so on. After the chairmanships have been selected, the four non-chaired aldermen shall each select a committee to vice-chair, with the most senior alderman having the first selection, and progressing to the next most senior alderman, and so on. In the same order in which chairmanships and vice- chairmanships are selected, the committee rosters shall be filled (committee chairs pick second committee first, vice chairman pick second committee after the chairmen pick their committee). i. Should an incumbent alderman be defeated in an election, the incoming alderman shall be placed in the group of four "non- chaired" aldermen that will select a vice-chair role in a committee. Subsequently, the most senior alderman of the "non-chaired" group shall be allowed to retain a committee chair for a consecutive year, but will select last in the group of aldermen who are selecting the committee chairs for the upcoming term. In the event there is more than one incumbent alderman allowed to serve consecutive committee chairs, those aldermen shall select committee chairs in order according to seniority, but after the group of alderman who have not served-consecutive committee chairs have selected. ii. Should there be a vacancy in the office of an alderperson, the alderperson appointed to such vacancy shall take the committee position held by his or her predecessor; provided, however, if the 8 position of said predecessor was that of committee chair, the vice chair of the committee shall assume the office of "acting chair" and the new alderperson shall become the vice-chair. The acting chair shall complete the term of the chair which was vacated and retain eligibility for a committee chairmanship for the next succeeding term. IV. Shall control the movement of items from committee agendas to City Council agendas. Items may not move out of committee but for a vote of approval by a majority of the quorum present. When passing items out of committee, where the committee reasonably believes that if the items are approved by the City Council, the impacts of that approval could significantly impact many residents, the item should first be listed on the City Council agenda under the committee report section and listed as being for first reading. The City Council at its discretion may waive a first reading if they deem it desirable. Items for first reading are intended to give notice to the public that a substantial change is being contemplated and the City Council will be taking input and considering the item at their next scheduled City Council meeting. For items forwarded to the City Council which are not expected to have as significant an impact should be recommended for placement on the consent agenda. Items for first reading do not literally have to be read into the record at the city council meeting, placement on agenda is sufficient. When an item is listed for first reading the chairman should explain the item being proposed and that the City Council is seeking input from the public to aid them in the decision making process. V. Shall have the sole power to assign liaisons to those city organizations that fall under that committee's specific area of business listed in the City Council agenda as follows: Public Works: Park Board, YBSD Economic Development: Kendall County Plan Commission, Plan Commission, Yorkville Econ. Dev. Corp. Public Safety: Human Resources Commission, School District Administration: Library Board, Cultural Commission V. Cancellation of a Meeting: A. Regularly scheduled City Council Meetings or Special Meetings called by the Mayor may be cancelled by the Mayor if advised that a quorum shall not be in 9 attendance or there is not a quorum of the members present at the regularly scheduled meeting. B. Special Meetings called by three (3) aldermen may be cancelled by two (2) of the three (3) aldermen that called the meeting if there is not a quorum of the members present or for any other reason. C. Committee Meetings may be cancelled by the Chairman of the committee if there is not a quorum of the members present. D. Cancellation of any of the meetings referenced in this Section requires notice by the person canceling the meeting to the City Clerk, all scheduled attendees, and all news media that has filed an annual request with the City Clerk. E. Lack of a quorum for any meeting prohibits proceeding with the meeting, but permits discussion solely of agenda items so long as no prior notice of cancellation has been issued. 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 2-04-02011. ROBYN SUTCLIFF DIANE TEELING GARY GOLINSKI ARDEN JOE PLOCHER WALLY WERDERICH MARTY MUNNS ROSE SPEARS GEORGE GILSON, JR. Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this day of 2$ 92011. Mayor Attest: City Clerk 10 J � United City of Yorkville ° 800 Game Farm Road EST. Aw 1836 Yorkville, Illinois 60560 0 Telephone: 630-553-4350 Fax: 630-553-7575 Kenaad cowry AGENDA CITY COUNCIL MEETING CITY COUNCIL CHAMBERS 7:00 p.m. Date Call to Order: Pledge of Allegiance: Roll Call by Clerk: WARD I WARD II WARD III WARD IV Wally Werderich Gary Golinski Marty Munns Rose Ann Spears George Gilson, Jr. Arden Joe Plocher Robyn Sutcliff Diane Teeling Establishment of Quorum: Introduction of Guests: Amendments to Agenda: Committee Meeting Dates: Public Works Committee Meeting: Economic Development Committee: Administration Committee Meeting: Public Safety Committee Meeting: Presentations: City Council Meeting Agenda Date Page 2 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Public Hearings: ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Citizen Comments: Consent Agenda: Plan Commission/Zoning Board of Appeals: Minutes for Approval (Corrections and Additions): Minutes of City Council— Bill payments for approval from the current Bill List(Corrections and Additions): Checks total these amounts: $ (vendors) $ (payroll period ending) $ (total) Reports: Mayor's Report: City Council Report: City Attorney's Report: City Clerk's Report: City Treasurer's Report: City Administrator's Report: Finance Director's Report: Director of Parks & Recreation Report: City Engineer's Report: Director of Public Works Report: Chief of Police Report: Community Development Director Report: Community Relations Officer: Community& Liaison Report: City Council Meeting Agenda Date Page 3 Committee Reports: Public Works Committee Report: Economic Development Committee Report: Public Safety Committee Report: Administration Committee Report: Additional Business: Executive Session: Adjournment: COMMITTEES, MEMBERS AND RESPONSIBILITIES ---------------------------------------- ;PUBLIC WORKS! _ -- Committee Departments Liaisons Chairman: Alderman Plocher Public Works Park Board Vice-Chairman: Alderman Gilson Engineering YBSD Committee: Alderman Munns Parks and Recreation Committee: Alderman Teeling --------------------------------------------------------------------- ECONOMIC DEVELOPMENT; -------- --------------------- --------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- Committee Departments Liaisons Chairman: Alderman Golinski Community Development Plan Commission Vice-Chairman: Alderman Spears Building Safety and Zoning Yorkville Econ. Dev. Corp. Committee: Alderman Werderich Kendall Co. Plan Commission Committee: Alderman Sutcliff ------------------------------- PUBLIC SAFETY! -------------------- ------ --------------------------------------------------------------------------------------------------------------------------------------------------------------- Committee Departments Liaisons Chairman: Alderman Werderich Police Human Resource Comm. Vice-Chairman: Alderman Munns School District Committee: Alderman Spears Committee: Alderman Plocher City Council Meeting Agenda Date Page 4 COMMITTEES,MEMBERS AND RESPONSIBILITIES (con't) - ------------------------------------------ 1;ADMINISTRATION; --------------- ----------------------- --------------- mmittee Departments Li aiso ns Chairman: Alderman Sutcliff Finance Library Vice-Chairman: Alderman Teeling Administration Committee: Alderman Gilson Committee: Alderman Golinski JA,�D C`T 0 United City of Yorkville 1836 Mayor Pro Tem Policy — Approved 2/22/05 E MAYOR PRO TEM. i (A) There is created the office of Mayor Pro Tem for the City. (B) In the event of a temporary absence, or a disability causing the Mayor of the City to be incapacitated from the performance of his duties,but which by law does not create a vacancy in the office of Mayor,the Council of Alderpersons shall elect one of its members to act as Mayor Pro Tem. The Mayor Pro Tem,during the absence or disability of the Mayor, shall perform the duties and possess all the rights and powers of the Mayor. (C) The selection of a Mayor Pro Tem shall be made on an annual basis at the first City Council meeting in May. The Council of Alderpersons shall vote to elect one of its members Mayor Pro Tem. No member may be elected as Mayor Pro Tem for two consecutive years. However,the Mayor Pro Tern shall not act as Mayor Pro Tem unless and until the Mayor is temporarily absent or is disabled to an extent so as to incapacitate him from the performance of his duties. (D) In the event the Mayor fails to attend a meeting of the City Council, the Mayor Pro Tem shall act as a temporary chairman for the meeting of the City Council, and while so serving as temporary chairman, shall have only the power of a presiding officer and a right to vote in his capacity as Alderperson on any ordinance,resolution,or motion. i Statutory reference: Mayor pro tern, see iLCS Ch. 65,Act 5 § 3.1-35-35 4 i i I c/Ty Reviewed By: Agenda Item Number 0-0 Legal ❑ NB #5 Finance ❑ EST. , �'� 1836 Engineer ❑ Tracking Number y City Administrator ■ Consultant ❑ K ADM 2011-15 El LE Kendall ..y Cnty 2 Agenda Item Summary Memo Title: Resolution Approving an Identity Protection Policy Meeting and Date: Administration Committee 4/21/11 Synopsis: Adoption of a policy to protect social security numbers from unauthorized disclosure, as required by Public Act 096-0874 of the State of Illinois. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Majority Council Action Requested: Approval Submitted by: Meghan Ostreko Administration Name Department Agenda Item Notes: The attached policy was adapted from the Village of Winfield's Identity Protection Policy. STATE OF ILLINOIS ) )ss COUNTY OF KENDALL ) RESOLUTION NO. 2011- RESOLUTION APPROVING AN IDENTITY PROTECTION POLICY WHEREAS, the United City of Yorkville, as a municipal utility, is subject to the State of Illinois' Identity Protection Act; and WHEREAS, the City Council of the United City of Yorkville has considered and developed an Identity Protection Policy pursuant to the State of Illinois' Identity Protection Act; and WHEREAS, it has been determined to be in the best interests of the United City of Yorkville to approve an Identity Protection Policy in the form attached hereto in Exhibit "A". NOW THEREFORE BE IT RESOLVED, by the Mayor and City Council of the United City of Yorkville, Kendall County, Illinois, that the Identity Protection Policy in the form set forth on Exhibit "A" attached hereto and incorporated herein is hereby adopted as the Identity Protection Policy of the City. 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 WALLY WERDERICH MARTY MUNNS ROSE 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 Exhibit "A" United City of Yorkville Policy with Regard to the Collection, Use and Communication of Individuals' Social Security Numbers (Identity Protection Policy) This policy is to comply with Public Act 096-0874 of the State of Illinois, cited as the Identity Protection Act. 1. Definitions. "Person" means any individual in the employ of the United City of Yorkville. "Publicly post" or "publicly display" means to intentionally communicate or otherwise intentionally make available to the general public. 2. Prohibited Activities. (a) No officer or employee of the United City of Yorkville shall do any of the following: (1) Publicly post or publicly display in a any manner and individual's social security number. (2) Print an individual's social security number on any card required for the individual to access products or services provided by the person or entity. (3) Require and individual to transmit his or her social security number over the Internet, unless the connection is secure or the social security number is encrypted. (4) Print an individual's social security number on any materials that are mailed to the individual, through the U.S. Postal Service, any private mail service, electronic mail, or any similar method of delivery, unless State or federal law requires the social security number to be on the document to be mailed. Notwithstanding any provision in this Section to the contrary, social security numbers may be included in applications and forms sent by mail, including, but not limited to, any material mailed in connection with the administration of the Unemployment Insurance Act, any material mailed in connection with any tax administered by the Department of Revenue, and documents sent as part of an application or enrollment process or to establish, amend, or terminate and account, contract, or policy or to confirm the accuracy of the social security number. A social security number that may permissibly be mailed under this Section may not be printed, in whole or in part, on a postcard or other mailer that does not require an envelope or be visible on an envelope with the envelope having been opened. (b) Except as otherwise provided in this policy, beginning July 1, 2010, no officer or employee of the United City of Yorkville shall do any of the following: (1) Collect, use, or disclose a social security number from an individual, unless (i) required to do so under State or federal law, rules, or regulations, or the collection, use, or disclosure of the social security number is otherwise necessary for the performance of that agency's duties and responsibilities; (ii) the need and purpose for the social security number is documented before collection of the social security number; and (iii) the social security number collected is relevant to the documented need and purpose. (2) Require an individual to use his or her social security number to access an Internet website. (3) Use the social security number for any purposed other than the purpose for which is was collected. (c) The prohibitions in subsection(b) to not apply in the following circumstances: (1) The disclosure of social security numbers to agents, employees, contractors, or subcontractors of the United City of Yorkville or disclosure to another governmental entity or its agents, employees, contractors, or subcontractors if disclosure is necessary in order for the entity to perform its duties and responsibilities; and, if disclosing to a contractor or subcontractor, prior to such disclosure, the officer or employee of the United City of Yorkville must first receive from the contractor or subcontractor a copy of the contractor's or subcontractor's policy that sets forth how the requirements imposed under this Policy on the United City of Yorkville to protect and individual's social security number will be achieved. (2) The disclosure of social security numbers pursuant to a court order, warrant, or subpoena. (3) The collection, use, or disclosure of social security numbers in order to ensure the safety of United City of Yorkville employees; persons committed to correctional facilities, local jails, and other law-enforcement facilities or retention centers; wards of the State; and all persons working in or visiting a United City of Yorkville facility. (4) The collection, use, or disclosure of social security numbers for internal verification or administrative purposes. (5) The collection or use of social security numbers to investigate or prevent fraud, to conduct background checks, to collect a debt, to obtain a credit report from a consumer reporting agency under the federal Fair Credit Reporting Act, to undertake any permissible purpose that is enumerated under the federal Gramm Leach Bliley Act, or to locate a missing person, a lost relative, or a person who is due a benefit, such as a pension benefit or an unclaimed property benefit. (d) Any standards of the United City of Yorkville for the collection, use, or disclosure of social security numbers that are stricter than the standards under this policy with respect to the protection of those social security numbers, then, in the event of any conflict with the provisions of this policy, the stricter standards adopted by the United City of Yorkville shall control. 3. Public Inspection and copying of documents. Notwithstanding any other provision of this policy to the contrary, all officers and employees of the United City of Yorkville must comply with the provisions of any other State law with respect to allowing the public inspection and copying of information or documents containing all or any portion of an individual's social security number. All officers and employees of the United City of Yorkville must redact social security numbers from the information or documents before allowing the public inspection or copying of the information or documents. 4. Applicability. (a) This policy does not apply to the collection, use, or disclosure of a social security number as required by State or federal law, rule, or regulation. (b) This policy does not apply to documents that are required to be open to the public under any State or federal law, rule, or regulation applicable case law, Supreme Court Rule, or the Constitution of the State of Illinois. 5. Compliance with federal law. If federal law takes effect requiring any federal agency to establish a national unique patient health identifier program, the United City of Yorkville shall follow that law. 6. Embedded social security numbers. Beginning December 31, 2009, no officer or employee of the United City of Yorkville may encode or embed a social security number in or on a card or document, including, but not limited to, using a bar code, chip, magnetic strip, RFID technology, or other technology, in place of removing the social security number as required by this policy. 7. Identity-protection requirements. (a) All officers, employees and agents of the United City of Yorkville identified as having access to social security numbers in the course of performing their duties trained to protect the confidentiality of social security numbers. Training shall include instructions on the proper handling of information that contains social security numbers from the time of collection through the destruction of the information. (b) Only employees who are required to use or handle information or documents that contain social security numbers have access to such information or documents. (c) Social security numbers requested from an individual shall be provided in a manner that makes the social security number easily redacted if required to be released as part of a public records request. (d) When collecting a social security number or upon request by the individual, a statement of the purposed or purposes for which the United City of Yorkville is collecting and using the social security number be provided. (e) A written copy of this privacy policy, and any amendment thereto, shall be filed with the city council within 30 days after approval of this policy or any amendment thereto. (f) The United City of Yorkville shall advise its employees of the existence of the policy and make a copy of the policy available to each employee, and shall also make this privacy policy available to any member of the public, upon request. If the United City of Yorkville amends this privacy policy, then the United City of Yorkville shall also advise its employees to the existence of the amended policy available to each employee. 8. Violation. Any person who intentionally violates the prohibitions in Section 10 of the Identity Protection Act [Paragraph 2 of this policy] is guilty of a Class B misdemeanor. 9. This policy does not supersede any more restrictive law, rule, or regulation regarding the collection, use, or disclosure of social security numbers. Illinois Municipal League - Resources - Social Security Numbers: New State Law on Usage Page 1 of 2 PAL IF �1 t Today is April 14,2011 Search IML Home Legislative Legal Training Sunshine Pension IMLRMA &Events Laws Policy Educate Review Magazine Issues>2010 Review Magazine>My> Internet General Social Security Numbers: New State Law on Usage Legal By Ashley Niebur, Legal Extern, IML Legislative The role of Social Security Numbers(SSNs)has expanded vastly since their origination in 1936.The first State Municipal News numbers were issued only to adults,and the age for issuance subsequently lowered, until finally they became applied for at birth.At their inception, SSNs were used solely for tracking Social Security benefits. Historically, Materials some states have used SSNs for identifiers on state licenses and other forms of identification.Today,the Legal number exists as a unique identifier used for a multitude of purposes including banking,school and university identification,grade tracking,credit reports and even employee identification. Recently,the use of SSNs has Publications become more limited due to increased awareness of fraud and identity theft. Review Magazine The most abused SSN in history evolved only two years after the initial issuance of these identifiers.The Handbooks& Woolworth card,as it became known,contained the most claimed SSN in history. In 1938,the E. H. Ferree Manuals Company began inserting sample social security cards in wallets,simply for display purposes at Woolworth Other Periodicals and other department stores.The card was red rather than blue, half the size of an authentic social security card,and had"specimen"inscribed across the front. Despite this, over 40,000 people claimed the number as IDOT their own. Ironically,the SSN had been legitimately issued to Mrs. Hilda Schrader Whitcher,secretary of the Caution!Magazine wallet manufacturer's vice president and treasurer.The number was voided by the Social Security Conference& Administration,who publicized that it should no longer be used. However, proof of its use continued for 4 Seminar Materials decades. Annual Conference Since this time,there has been growing concern regarding the fraudulent use of SSNs.A person can obtain Municipal Attorney's someone else's unique identifier in numerous ways—most commonly,stealing personal information in which the number is contained,as well as posing as a government agent or creditor and seeking the number.The Newly Elected Officials most recent form of obtaining another's SSN is posing as a census officer. Media outlets have tried to combat this fraud by issuing warnings as soon as occurrences arise, however,often times many identities have Annual Conference already been obtained. Road Show TOP RESOURCE IDENTITY PROTECTION ACT PAGES In response to growing concern, Illinois created the Social Security Number Protection Task Force in 2004. 1.Special Edition: The task force consisted of various members representing interested state entities.The purpose behind its Local Election Results 2011 creation was to address the risk that an individual's identity ma y g be stolen through unauthorized disclosure of 2.Statehouse Briefing their SSN.The state acknowledged that it used SSNs for various purposes among state agencies,thus -April 8,2011 creating a potential for identity theft.The task force sought to explore changes which would replace the use of 3.News Items of social security numbers by state and local government agencies. Municipal Interest- April 5,2011 The Identity Protection Act-1113 547—becomes effective July 1,2010.At that time, state and local government agencies can expect to experience major changes in how they conduct business.The Act, Public Act 096-0874,essentially restricts the use of SSNs by: prohibiting a person,state or local government agency from publicly posting or displaying the SSN; printing the SSN on cards required for access to products or p Y p 9 p � 9 q p services; requiring an individual to transmit his or her SSN over the internet without a secure connection,or encryption of the SSN;or printing a SSN on mailed materials. RESTRICTION ON THE USE OF SSNS The Act allows state or local government agencies to collect, use or disclose a SSN only when required by state or federal law.The hurdles continue—the need and purpose for the SSN must be documented before the request,and the SSN collected must be relevant to this specified need and purpose. http://www.iml.org/page.cfm?key=4611 4/14/2011 Illinois Municipal League - Resources - Social Security Numbers: New State Law on Usage Page 2 of 2 Of course,there are exceptions to this rule. For example,the Act does not apply to the use of SSNs or other identifying information for internal verification or administrative purposes. State and local government agencies must comply with other state laws which allow public inspection and copying of information and documents that contain SSNs—however,the SSN must be redacted by the agency. Further,the Act does not apply to documents that are recorded by the county recorder or required to be open to the public under any law, rule or the Constitution of the state of Illinois. IDENTITY PROTECTION POLICY REQUIRED Even more burdensome,state and local government agencies must draft and approve an Identity Protection Policy by June 1,2011.The Attorney General's office will draft a template to be used by agencies. Included in this policy is the requirement that all employees having access to SSNs be trained to protect their confidentiality. Only employees who are required to use or handle documents or information containing SSNs will be allowed access.The SSN must be easily redacted from documents requested by individuals.The Act also imposes that a statement of the purpose for which an agency is collecting and using the SSN be provided in applicable situations.After the agency's policy is approved, it must be implemented within 12 months. In addition to the Act, state and local agencies must bear in mind the Fair and Accurate Credit Transactions Act of 2003 and Red Flag Rules issued by the Federal Trade Commission.These guidelines require that all financial institutions and creditors develop a written Identity Theft Prevention Program. Under this language,a state or local agency may be a creditor if they regularly defer payment for goods or services,or provide goods or services and bill individuals later.The Red Flag Rules extend to municipalities providing utilities,whereby payment is deferred until after services are rendered.The most obvious example of this would be a municipality providing water services for a period of time,and then billing for payment after the use is calculated.An entity that regularly grants loans,arranges for the extension of credit,or makes credit decisions may also fall within the definition of a"creditor." While the Red Flag guidelines require the same general notion that the Identity Protection Act calls for,the programs are not identical.A Red Flag is identified as any pattern,practice or specific activity that indicates the possible existence of identity theft.The Red Flag guidelines require identification,detection and incorporation of"Red Flag"warning signs,an appropriate response mechanism for detected Red Flags, updating of the Program to address the risks to customers,and safety and soundness of the creditor regarding identity theft. Therefore,agencies are likely to be responsible for the creation of two policies—one under the Illinois Identity Protection Act,and another under the federal Red Flag guidelines. In protecting individuals'SSNs,state and local agencies relying on the use of unique identifiers will now be charged with the task of finding new ways to identify individuals. For example,the Department of Human Services has begun assigning Recipient Identification Numbers for those who are provided services through various sections of that agency—most commonly for recipients of cash, medical and food stamp benefits. Additionally,seven agencies which deliver healthcare and human services have begun working together in what they call the Framework,to focus on establishing a single client identifier to be used throughout the seven agencies. CRIMINAL PENALTIES An intentional violation of the Identity Protection Act will result in an issuance of a Class B misdemeanor.Class B misdemeanors are punishable by up to six months in jail and a fine of up to$1500. Further, penalties and sanctions may be set forth and addressed by the policies of various public bodies. For example,the Illinois State University Procedure calls for penalties and sanctions up to discharge and dismissal of students who "substantially breach"the confidentiality of SSNs. CONCLUSION In effect,the Identity Protection Act will likely become burdensome for appropriate adaptation by state and local agencies.The creation of a new system of unique identifiers for certain agencies and benefits could, down the road, become subject to the same issues faced with SSNs today.With federal Red Flag guidelines calling for the creation of programs by creditors,which in most cases will include municipalities,the workload will double when it comes to the implementation of both state and federal requirements on the issue. ©1996-2011 Illinois Municipal League.All Rights Reserved. http://www.iml.org/page.cfm?key=4611 4/14/2011 c/Ty Reviewed By: Agenda Item Number ii J� a 0-0 Legal ❑ NB #6 II Finance ❑ EST. , � 1836 Engineer ❑ Tracking Number y City Administrator ■ Consultant ❑ ADM 2011-16 dal County El`E Agenda Item Summary Memo Title: Bike Trail Donation Collection Meeting and Date: Administration Committee 4/21/11 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: None Council Action Requested: Discussion Submitted by: Bart Olson Administration Name Department Agenda Item Notes: See attached memo. .��0 Co.y o Memorandum To: Administration Committee EST. �Z 1836 From: Bart Olson, City Administrator .4 _�` CC: 0� �� �o,gaa, �p Date: April 15, 2011 Subject: Bike trail donations At the April 14th Park Board meeting, the Park Board listened to a proposal from Alderwoman Teeling and Lynn Dubajic about raising private money for bike trails. The hope is that through a variety of measures,the City will be able to raise enough money to participate in the Route 47 trail funding opportunity. These measures are likely to be privately driven(or through a committee),but would all involve residents giving money to the City that would be earmarked for trail purposes in the future. The question raised by staff at the Park Board meeting was one of accounting and budgetary logistics—namely, would we be able to effectively and correctly collect the money and then use it in the future for this purpose. The answer to this question is "yes"—we have collected money for specific purposes and/or other organizations in the past. We can collect the money at the front desk of City Hall and/or the REC Center and have the money tracked either through a balance sheet or a budgetary line-item. When the time comes to commit to a bike trail project, that money can be spent like any other funds the City collects. The Park Board and Alderman and Mayor-elect Golinski asked for this concept to be brought to the Administration Committee to make them aware of the upcoming initiative.