Loading...
Administration Packet 2011 03-17-11 o United City of Yorkville 800 Game Farm Road EST. '� 1836 Yorkville, Illinois 60560 -e. i Telephone: 630-553-4350 Fax: 630-553-7575 Cou* �? SCE AGENDA ADMINISTRATION COMMITTEE MEETING Thursday, March 17, 2011 6:00 p.m. City Hall Conference Room Citizen Comments: Minutes for Correction/Approval: February 17, 2011 New Business: 1. ADM 2011-07 Budget Report for February 2011 2. ADM 2011-08 Treasurer's Report for February 2011 3. ADM 2011-09 Purchase Order Policy Revision 4. ADM 2011-10 Employee Benefits Renewal 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 Glory Spies/Bart Olson Litigation aversion. Gilson/Werderich Bart Olson Staff elected officials communications. Spears/Gilson Glory Spies/Bart Olson Budgeting. Munns/Plocher Rob Fredrickson/Bart Olson Grant planning(with Park Board). Golinski/Spears Krysti Barksdale-Noble/ Bart Olson FOIA compliance. Sutcliff/Spears Bart Olson/Lisa Pickering UNITED CITY OF YORKVILLE WORKSHEET ADMINISTRATION COMMITTEE Thursday, March 17, 2011 6:00 PM City Hall Conference Room --------------------------------------------------------------------------------------------------------------------------------------- CITIZEN COMMENTS: --------------------------------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------- MINUTES FOR CORRECTION/APPROVAL: --------------------------------------------------------------------------------------------------------------------------------------- 1. February 17, 2011 ❑ Approved ❑ As presented ❑ With corrections --------------------------------------------------------------------------------------------------------------------------------------- NEW BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1. ADM 2011-07 Budget Report for February 2011 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2011-08 Treasurer's Report for February 2011 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 3. ADM 2011-09 Purchase Order Policy Revision ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 4. ADM 2011-10 Employee Benefits Renewal ❑ 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—February 17, 2011 Meeting and Date: Administration Committee 3/17/11 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Majority Council Action Requested: Committee Approval Submitted by: Minute Taker Name Department Agenda Item Notes: DRAFT UNITED CITY OF YORKVILLE ADMINISTRATION COMMITTEE Thursday, February 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 City Finance Director Rob Frederickson Treasurer Bill Powell Chair Sutcliff called the meeting to order at 6:01pm Citizen Comments: Resident Mr. Walker expressed his concerns regarding the regulations placed on citizen comments. Minutes for Correction/Approval: January 20, 2011 The minutes were approved as presented. New Business: 1. ADM 2011 — 04 Budget Report for January 2011 City Administrator Bart Olson outlined the report and stated that a proposed budget will be provided to members as of tomorrow. Alderman Gilson requested information from both Administrator Olson and Director Frederickson regarding conservative budget practices. He expressed his need to discuss the budget and his many questions regarding the budget. Further, Alderman Gilson questioned many line items, particularly those reflecting office supplies, office services, equipment, and contractual services that could be decreased and free-up additional revenue. Alderman Gilson had additional questions regarding revenues and expenses for the Water and Sewer funds as well as the Parks and Recreation budget. 1 At this time, the Committee requested to move from Old Business item: ADM 2010-108 Ordinance Amending City Code Regarding Citizen Comments. Administrator Olson stated that this item was tabled at Council then moved to Administration Committee. Unfortunately, it was not supposed to be on the agenda and instead will appear before Council next Tuesday. The Committee then returned to the regular order of the agenda. 2. ADM 2011 — 05 Treasurer's Report for January 2011 Treasurer Powell briefly reviewed the fund balance, revenues and expenses for January 2011. The Committee recommended this item be forwarded to the Consent Agenda. 3. ADM 2011 — 06 Annual Treasurer's Report for Fiscal Year 2009-2010 Treasurer Powell noted that this item, as required by law, has been published in the paper. The Committee recommended this item be forwarded to the Consent Agenda. Old Business: 1. ADM 2011 — 03 Budget Cutting Ideas Administrator Olson noted that these items will be discussed in depth at the upcoming Budget meeting. Alderman Gilson wondered if there was a fee for inactive water accounts, those that still have service but are utilizing it. Administrator Olson stated that we do have a minimum fee. Alderman Gilson wondered what recommendation staff would have regarding additional furloughs. Administrator Olson stated that he was not going to recommend additional furloughs. Chair Sutcliffe would like to encourage a partnership with a private company to pursue the possibility of recreational development (i.e. zip line). The Committee went on to review the other potential recommendations for revenue generators. Some members of the Committee expressed positive interest in Digital billboards, cell towers on municipal property, outsourcing, leasing municipal property(i.e. old post office, river walk building, city hall), business registration, selling sponsorship opportunities, and enterprise opportunities. Additional Business: There being no further business, the Committee adjourned at 9:00pm. 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-07 Kend'11 mly El<`E Agenda Item Summary Memo Title: Budget Report for February 2011 Meeting and Date: Administration Committee 3/17/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/3-9-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 GENERAL FUND-REVENUES 01-000-40-00-3993 EMPLOY CONTRIB HEALTF $ 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 $ 160,252.99 $ 168,318.00 01-000-40-00-3994 ADMISSIONS TAX $ $ $ $ $ $ 151,744.45 $ $ $ $ $ 181,744.45 $ 112,964.00 01-000-40-00-3995 COBRA INS REIME $ 15,569.31 $ 14,475.72 $ 30,045.03 $ 01-000-40-00-3996 RETIREE INS REIME $ 26,223.41 $ $ 26,223.41 $ 01-000-40-00-3997 AMUSEMENT TAX $ $ $ $ $ $ $ 44.10 $ $ 63.72 $ 5.67 $ 113.49 $ 162,964.00 01-000-40-00-4000 REAL ESTATE TAXES $ $ 1,187,512.95 $ 77,294.67 $ 180,528.77 $ 946,783.74 $ 66,662.43 $ 62,787.77 $ $ $ $ 2,521,570.33 $ 2,450,000.00 01-000-40-00-4001 TOWN ROAD/BRIDGE TAX $ $ 78,859.34 $ 4,910.35 $ 13,596.68 $ 59,721.22 $ 3,761.54 $ 3,447.29 $ $ $ $ 164,296.42 $ 160,000.00 01-000-40-00-4010 PERSONAL PROPERTY TAX $ 2,598.41 $ (646.74) $ 1,952.34 $ 260.33 $ $ 3,819.07 $ $ 3,080.64 $ 1,578.73 $ $ 12,672.75 $ 20,000.00 01-000-40-00-4020 STATE INCOME TA) $ $ 124,314.46 $ 213,276.29 $ 127,184.73 $ 255,134.45 $ $ $ 124,700.22 $ 165,595.18 $ 213,559.71 $ 1,223,765.04 $ 1,300,000.00 01-000-40-00-4030 MUNICIPAL SALES TAX $ 176,385.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 $ 2,166,488.09 7 2,440,000.00 01-000-40-00-4032 STATE USE TA) $ 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 $ 183,866.33 $ 237,063.00 01-000-40-00-4040 MUNICIPAL UTILITY TA) $ $ 133,343.15 $ $ $ 143,841.18 $ $ $ $ 179,508.90 $ $ 456,693.23 $ 565,000.00 01-000-40-00-4041 UTILITY TAX-NICOF $ $ 117,229.18 $ $ $ 32,221.63 $ $ $ 28,087.50 $ 33,387.39 $ $ 210,925.70 $ 396,000.00 01-000-40-00-4042 UTILITY TAX-CABLE 1 $ 49,772.83 $ $ 1,835.78 $ 54,457.07 $ $ $ 55,794.36 $ $ $ 57,024.95 $ 218,914.99 $ 190,000.00 01-000-40-00-4043 UTILITY TAX-TELEPHC $ 42,820.41 $ 48,994.12 $ 42,325.81 $ 43,671.29 $ 45,259.93 $ 45,330.47 $ 34,022.66 $ 45,371.84 $ 45,561.90 $ 42,544.43 $ 435,902.86 $ 600,000.00 01-000-40-00-4044 BUSINESS DISTRICTTA) $ 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 $ 230,311.18 $ 150,000.00 01-000-40-00-4045 AUTO RENTAL TA) $ 538.25 $ 613.04 $ 578.60 $ 528.60 $ 699.63 $ 715.37 $ 791.14 $ 691.76 $ 623.86 $ 601.23 $ 6,381.48 $ 3,421.00 01-000-40-00-4050 HOTEL TA) $ 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 $ 29,693.29 $ 20,000.00 01-000-40-00-4080 PARA MUTUELTA) $ 191.23 $ 191.23 $ 01-000-41-00-4100 LIQUOR LICENSE $ 1,244.90 $ 503.12 $ 650.00 $ 374.74 $ $ $ 1,300.00 $ 19.52 $ $ 700.00 $ 4,792.58 $ 30,000.00 01-000-41-00-4101 OTHER LICENSES $ 50.00 $ 368.50 $ $ 234.25 $ 134.25 $ 414.25 $ $ 224.25 $ $ $ 1,425.50 $ 4,500.00 01-000-41-00-4110 BUILDING PERMITS $ 16,601.10 $ 15,346.75 $ 11,678.40 $ 10,935.90 $ 12,518.50 $ 20,281.65 $ 10,383.10 $ 4,253.30 $ 2,252.50 $ 1,972.00 $ 106,223.20 $ 205,000.00 01-000-42-00-4205 FILING FEES $ $ $ $ $ $ $ $ $ $ $ $ 3,000.00 01-000-42-00-4206 GARBAGE SURCHARGE $ (509.93) $ 196,466.61 $ 337.19 $ 196,393.91 $ 77.39 $ 192,453.24 $ (248.41) $ 196,964.20 $ 3,024.43 $ 195,011.62 $ 979,970.25 $ 1,050,000.00 01-000-42-00-4207 ZONING VARIANCE FEE'- $ $ $ $ $ $ $ $ $ $ $ $ 170.00 01-000-42-00-4208 COLLECTION FEE-YBSC $ $ $ $ $ $ $ $ $ $ 121,857.00 $ 121,857.00 $ 121,503.00 01-000-42-00-4210 DEVELOPMENT FEE'- $ 13,677.65 $ 100.00 $ 200.00 $ $ 1,081.97 $ 18,435.64 $ $ $ $ 22,139.92 $ 55,635.18 $ 80,000.00 01-000-42-00-4285 BEECHER LEASE AGREEME $ $ $ $ $ 1,000.00 $ 500.00 $ 500.00 $ $ 500.00 $ 500.00 $ 3,000.00 $ 12,000.00 01-000-42-00-4286 BEECHER RENTAL' $ 45.00 $ 320.00 $ 170.00 $ 55.00 $ 210.00 $ 175.00 $ $ 110.00 $ 115.00 $ 160.00 $ 1,360.00 $ 2,000.00 01-000-42-00-4287 DEVELOPER SIGN REIME $ $ $ $ $ $ $ $ $ $ $ $ 5,000.00 01-000-42-00-4288 MOWING INCOME $ $ $ 46.36 $ 298.13 $ 127.09 $ 107.11 $ 486.54 $ $ 2,895.21 $ $ 3,960.44 $ 01-000-43-00-4310 TRAFFIC FINES $ 9,434.34 $ 7,718.93 $ 8,394.55 $ 7,502.53 $ 6,510.22 $ 5,699.31 $ 9,717.23 $ 5,949.46 $ 7,826.33 $ 5,660.23 $ 74,413.13 $ 151,275.00 01-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 $ 21,884.94 $ 50,000.00 01-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 $ 72,400.00 $ 151,275.00 01-000-44-00-4401 DARE DONATIONS $ $ $ $ $ $ $ $ 25.00 $ $ $ 25.00 $ 20.00 01-000-44-00-4404 HANGING BASKET DONAT $ 50.00 $ $ $ $ $ $ $ $ 600.00 $ 950.00 $ 1,600.00 $ 2,000.00 01-000-44-00-4407 HOLIDAY UNDER THE STF $ $ $ $ $ $ $ $ $ $ $ $ 9,585.00 01-000-44-00-4411 REIMBURSEMENTS-POLICE $ 160.00 $ 295.00 $ 265.60 $ 270.00 $ 230.35 $ 245.35 $ 220.35 $ 21,797.21 $ (21,112.21) $ 254.20 $ 2,625.85 $ 3,300.00 01-000-44-00-4412 INSURANCE REIMBURSEME $ $ $ $ $ $ $ $ $ 11,404.00 $ $ 11,404.00 $ 01-000-44-00-4413 PLAN REVIEW INCOME $ $ $ $ $ $ $ $ $ $ $ $ 01-000-44-00-4414 WORKERS COMP REIME $ 3,354.45 $ $ 3,354.45 $ 01-000-44-00-4415 REIMB FOR LEGAL EXPEN $ $ $ $ $ $ $ $ 33,144.76 $ 3,985.61 $ 6,061.05 $ 43,191.42 $ 150,000.00 01-000-44-00-4416 REIMB FOR THE LIBRARY $ $ $ $ $ $ - $ $ $ $ $ $ 40,582.00 01-000-44-00-4417 MIS.REIMBURSEMENTS $ $ $ $ $ $ $ 5,800.44 $ 257.92 $ (5,442.11) $ 2,276.59 $ 2,892.84 01-000-44-00-4418 REIMB-STREET OP! $ $ $ $ $ $ - $ $ $ $ $ 01-000-44-00-4419 POLICE SPECIAL DETAIL $ 4,431.73 $ $ 4,431.73 01-000-44-00-4421 LIFE INSURANCE REIME $ 3,615.12 $ 275.93 $ 3,891.05 01-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 $ 7,915.15 $ 1,000.00 01-000-44-00-4495 HAUNTED HOUSE n/a n/a n/a n/a n/a $ $ $ $ $ - $ $ 01-000-44-00-4499 BAD DEBT RECOVERY $ 2,718.75 $ $ $ $ $ $ $ $ $ $ 2,718.75 $ 01-000-45-00-4504 TRAFFIC SIGNAL REVENU $ $ 19,191.11 $ $ $ $ $ $ $ 13,875.55 $ - $ 33,066.66 $ 14,925.00 01-000-45-00-4505 COPS GRANT-VESTS $ $ $ $ $ 912.50 $ $ $ $ $ $ 912.50 $ 01-000-45-00-4506 MISC INTEGOVERNMENTAI $ $ $ $ $ 657.50 $ $ $ 2,195.50 $ (657.50) $ $ 2,195.50 $ 01-000-45-00-4507 FEDERAL GRANTS $ 9,255.49 $ 240.65 $ 9,526.14 $ 01-000-45-00-4508 STATE GRANTS $ 9,771.30 $ $ 9,771.30 $ 01-000-45-00-4510 CABLE CONSORTIUM FEES $ $ $ $ 01-000-45-00-4511 POLICE-STATE TOBACCC $ $ $ $ $ 1,870.00 $ $ $ $ $ - $ 1,870.00 $ 1,803.00 01-000-45-00-4515 ENERGY&RECYCLING GF $ $ 5,307.00 $ $ $ $ $ $ $ $ $ 5,307.00 $ 01-000-45-00-4525 GRANTS $ $ $ $ $ $ $ $ 17,442.31 $ $ $ 17,442.31 $ 01-000-46-00-4600 INVESTMENT INCOME $ 64.13 $ 155.78 $ 349.36 $ 210.63 $ 184.61 $ 335.08 $ 100.42 $ 92.53 $ 58.24 $ 45.84 $ 1,596.92 $ 3,000.00 01-000-49-00-4902 REPAY OF PARK&REC 1 $ $ $ $ $ $ $ $ $ $ - $ $ 100,000.00 01-000-49-00-4915 TRANSFER FROM WATER C $ $ $ 22,965.75 $ $ $ 22,965.75 $ $ $ 22,965.75 $ $ 68,597.25 $ 91,863.00 01-000-49-00-4920 TRANSFER FROM SEWER N $ - $ $ 20,761.25 $ $ $ 20,761.25 $ - $ $ 20,761.25 $ - $ 62,283.75 $ 83,045.00 01-000-49-00-4935 TRANSFER FROM LAND CP $ $ $ 15,112.25 $ $ $ 15,112.25 $ $ $ 15,112.25 $ $ 45,336.75 $ 60,449.00 GENERAL FUND-TOTAL REVENUES1$ 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 $ 990,017.22 $ $ $ 10,049,230.86 $ 11,433,025.00 GENERAL FUND-ADMIN EXPENSES 01-110-50-00-5100 SALARIES-MAYOR $ 860.00 $ 825.00 $ 825.00 1$ 825.00 $ 860.00 $ 825.00 $ 825.00 $ 725.00 $ 825.00 $ 760.00 $ 8,155.00 $ 11,310.00 1 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/3-9-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-10 July-10 August-30 September-10 October-10 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 01-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 $ 7,045.03 $ 8,980.00 O1-110-50-00-5102 SALARIES-CITY TREASL $ 535.00 $ 500.00 $ 400.00 $ 400.00 $ 300.00 $ 500.00 $ 500.00 $ 500.00 $ 400.00 $ 535.00 $ 4,570.00 $ 6,500.00 01-110-50-00-5103 SALARIES-ALDERMAN $ 4,245.00 $ 4,000.00 $ 3,900.00 $ 4,000.00 $ 4,010.00 $ 3,900.00 $ 4,000.00 $ 3,900.00 $ 3,900.00 $ 4,280.00 $ 40,135.00 $ 50,320.00 01-110-50-00-5104 SALARIES-LIQUOR COMM $ 83.33 $ 83.33 $ 83.33 $ 83.33 $ 83.33 $ 83.33 $ 83.33 $ 83.33 $ 83.33 $ 166.64 $ 916.61 $ 1,000.00 01-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 $ 205,544.63 $ 202,242.00 01-110-50-00-5137 SALARIES-OVERTIME $ $ $ $ $ $ $ $ $ $ 222.90 $ 222.90 $ 575.00 01-110-61-00-5300 SPECIAL COUNSEL $ $ $ 5,176.24 $ 6,042.65 $ 7,156.17 $ $ 10,227.10 $ $ 18,564.45 $ 6,339.17 $ 53,505.78 $ 65,000.00 01-110-61-00-5301 LEGISLATIVE ATTORNEY $ $ $ $ $ $ $ $ $ $ $ $ 01-110-61-00-5302 CORPORATE COUNCIL $ $ 5,020.91 $ 7,736.75 $ 6,587.00 $ 10,184.75 $ 9,510.00 $ 9,777.75 $ 7,160.50 $ 21,726.88 $ 16,641.75 $ 94,346.29 $ 130,000.00 01-110-61-00-5303 LITIGATION COUNCIL $ $ $ 16,358.59 $ 16,199.68 $ 1,472.85 $ 6,615.25 $ 5,464.60 $ 7,558.92 $ 4,308.19 $ 5,273.88 $ 63,251.96 $ 90,000.00 01-110-61-00-5311 CODIFICATION $ $ $ $ $ $ $ $ $ 500.00 $ 2,210.00 $ 2,710.00 $ 8,000.00 01-110-61-00-5314 BUILDING INSPECTIONS $ $ 1,665.00 $ 3,270.00 $ $ (3,675.00) $ $ $ $ $ $ 1,260.00 $ 01-110-62-00-5401 CONTRACTUAL SERVICES $ 736.00 $ 192.50 $ 464.85 $ 472.96 $ 324.00 $ 309.28 $ 201.15 $ 160.00 $ 375.00 $ 236.50 $ 3,472.24 $ 8,000.00 01-110-62-00-5404 CABLE CONSORTIUM FEE $ $ $ 17,994.07 $ $ 18,659.87 $ $ $ 19,103.28 $ $ $ 55,757.22 $ 50,000.00 01-110-62-00-5406 OFFICE CLEANING $ $ 1,188.00 $ 1,188.00 $ 1,188.00 $ 1,188.00 $ 1,196.00 $ 1,196.00 $ $ 1,196.00 $ 2,392.00 $ 10,732.00 $ 14,400.00 01-110-62-00-5410 MAINTENANCE-OFFICE $ $ $ $ $ $ $ $ $ $ $ $ 100.00 01-110-62-00-5421 WEARING APPAREL $ $ $ $ $ $ $ $ $ $ $ $ 01-110-62-00-5436 TELEPHONE $ - $ 1.48 $ 987.33 $ 991.16 $ 993.12 $ 996.87 $ 1,005.43 $ 994.78 $ 986.51 $ 974.83 $ 7,931.51 $ 20,000.00 01-110-62-00-5438 CELLULAR TELEPHONE $ $ 119.08 $ 122.17 $ 120.59 $ 123.58 $ 90.00 $ 90.00 $ 90.00 $ 90.00 $ 90.00 $ 935.42 $ 1,200.00 01-110-62-00-5439 TELEPHONE SYSTEMS MA $ $ $ 1,472.40 $ $ $ $ $ $ $ 1,472.40 $ 2,944.80 $ 3,000.00 01-110-64-00-5600 DUES $ 5,885.00 $ 1,035.50 $ $ 462.14 $ $ $ 1,650.00 $ $ 2,500.00 $ $ 11,532.64 $ 12,450.00 01-110-64-00-5601 ILLINOIS MUNICIPAL LE $ $ $ $ $ $ $ 1,179.00 $ $ $ $ 1,179.00 $ 1,200.00 01-110-64-00-5603 SUBSCRIPTIONS $ $ $ $ $ $ $ $ $ 100.00 $ 60.00 $ 160.00 $ 100.00 01-110-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ $ $ 40.69 $ - $ 40.69 $ 01-110-64-00-5605 TRAVEL/MEALS/LODGING $ (15.65) $ 56.31 $ 96.00 $ 78.76 $ 25.04 $ 202.88 $ 100.00 $ $ $ $ 543.34 $ 1,000.00 01-110-64-00-5607 PUBLIC RELATIONS $ $ $ $ $ 54.90 $ $ $ $ $ - $ 54.90 $ 150.00 01-110-64-00-5611 KENDALL COUNTY PARATF $ 4,945.75 $ $ $ $ $ $ 10,832.00 $ $ $ $ 15,777.75 $ 30,000.00 01-110-64-00-5612 SENIOR SERVICE FUNDIN $ $ $ $ $ $ $ $ $ $ - $ $ 5,000.00 01-110-65-00-5800 CONTINGENCIES $ $ $ $ $ $ $ $ $ $ $ $ 10,000.00 01-110-65-00-5802 OFFICE SUPPLIES $ 48.10 $ 396.99 $ 44.84 $ 1,225.84 $ 216.54 $ $ 409.92 $ 1,467.36 $ 173.24 $ 14.95 $ 3,997.78 $ 8,000.00 01-110-65-00-5804 OPERATING SUPPLIES $ 29.00 $ 525.09 $ 887.48 $ 616.02 $ 459.24 $ 171.68 $ 625.21 $ 207.67 $ 562.54 $ 218.15 $ 4,302.08 $ 7,000.00 01-110-65-00-5808 POSTAGE&SHIPPING $ (5.18) $ 168.33 $ 118.92 $ 3,993.45 $ 106.92 $ 60.89 $ 856.24 $ 435.22 $ 143.95 $ 3,784.76 $ 9,663.50 $ 14,000.00 01-110-65-00-5809 PRINTING&COPYING $ (0.70) $ 780.54 $ 1,343.94 $ 536.20 $ 445.14 $ 403.16 $ 1,130.58 $ 586.92 $ 298.49 $ 884.08 $ 6,408.35 $ 6,750.00 01-110-65-00-5810 PUBLISHING&ADVERTIS $ $ $ $ 10.40 $ $ $ 335.05 $ $ $ $ 345.45 $ 2,000.00 01-110-72-00-65001MRF PARTICIPANTS $ 1,812.55 $ 1,783.21 $ 1,847.85 $ 3,035.69 $ 1,217.24 $ 3,019.85 $ 2,195.60 $ 3,996.29 $ 1,694.15 $ 1,653.72 $ 22,256.15 $ 27,153.00 01-110-72-00-6501 SOCIAL SECURITY&MEC $ 1,548.27 $ 1,512.98 $ 1,566.23 $ 2,501.76 $ 1,102.64 $ 2,510.24 $ 1,861.10 $ 3,372.37 $ 1,395.46 $ 1,372.38 $ 18,743.43 $ 26,463.00 01-110-75-00-7002 COMPUTER EQUIP&SOFT $ $ 709.98 $ $ 1,233.75 $ $ $ $ $ $ $ 1,943.73 $ 850.00 01-110-75-00-7003 OFFICE EQUIPMENT $ $ $ 608.15 $ $ $ $ $ $ $ $ 608.15 $ 01-110-78-00-9002 NICOR GAS $ $ 144.60 $ 1,166.81 $ 1,544.04 $ 1,285.72 $ 774.54 $ 969.04 $ 2,251.88 $ 1,967.69 $ 2,368.47 $ 12,472.79 $ 31,000.00 01-110-78-00-9004 MISCELLANEOUS $ $ $ $ $ $ $ $ $ $ $ $ 01-110-78-00-9013 HOLIDAY UNDER THE STA $ $ $ $ $ $ $ $ $ $ $ $ 01-110-99-00-9970 TRANSFER TO CW CAPITA $ $ $ 31,250.00 $ $ $ 31,250.00 $ $ $ 31,250.00 $ $ 93,750.00 $ 125,000.00 01-110-99-00-9975 TRANSFER TO CW CAPITA $ $ $ 9,375.00 $ $ $ 9,375.00 $ $ $ 9,375.00 $ $ 28,125.00 $ 37,500.00 TOTAL ADMIN EXPENSES $ 37,383.79 $ 37,240.06 $ 125,723.19 $ 82,498.03 $ 57,221.10 $ 101,869.98 $ 76,562.06 $ 93,464.40 $ 117,470.82 $ 65,907.69 $ $ $ 795,341.12 $ 1,016,243.00 GENERAL FUND-FINANCE EXPENSES 01-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 $ 171,171.26 $ 259,690.00 01-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 01-120-50-00-5203 BENEFITS-HEALTH INSL $ 284,297.20 $ 75,984.28 $ 155,709.99 $ (895.84) $ 86,963.34 $ (958.53) $ 164,870.46 $ 108,071.80 $ 114,588.32 $ 88,027.87 $ 1,076,658.89 $ 1,156,090.00 01-120-50-00-5204 BENEFITS-GROUP LIFE $ 1,744.16 $ 1,744.16 $ 1,723.49 $ 1,723.49 $ 1,723.49 $ 1,702.82 $ 1,702.82 $ 1,772.96 $ 5,155.25 $ 1,901.41 $ 20,894.05 $ 28,240.00 01-120-50-00-5205 BENEFITS-DENTAL/VIS $ 15,124.32 $ 8,139.52 $ 14,551.15 $ 459.05 $ 8,427.62 $ 390.66 $ 15,501.18 $ 6,977.50 $ 13,218.65 $ 13,497.19 $ 96,286.84 $ 100,880.00 01-120-61-00-5304 AUDIT FEES&EXPENSES $ $ $ $ $ $ $ 1,500.00 $ 1,500.00 $ 20,000.00 $ 15,000.00 $ 38,000.00 $ 57,700.00 01-120-61-00-5310 EMPLOYEE ASSISTANCE $ 404.16 $ $ $ 606.24 $ $ $ 606.24 $ $ $ $ 1,616.64 $ 4,000.00 01-120-62-00-5400 INSURANCE-LIABILITY $ 11,722.00 $ 54,721.50 $ 11,722.00 $ 11,972.00 $ 54,721.50 $ 11,723.00 $ 11,722.00 $ 23,051.00 $ 83,173.75 $ $ 274,528.75 $ 344,129.00 01-120-62-00-5401 CONTRACTUAL SERVICES $ $ 1,958.00 $ 489.00 $ 1,776.00 $ 1,057.50 $ 374.50 $ 1,440.00 $ 2,138.00 $ 374.50 $ 1,399.35 $ 11,006.85 $ 28,000.00 01-120-62-00-5410 MAINTENANCE-OFFICE E $ $ $ 838.00 $ $ $ $ $ $ $ $ 838.00 $ 1,800.00 01-120-62-00-5411 MAINTENANCE-COMPUTER $ $ $ $ $ $ $ $ $ $ $ $ 500.00 01-120-62-00-5412 MAINTENANCE-PHOTOCOF $ $ 1,572.00 $ 1,572.00 $ 1,572.00 $ 2,308.00 $ 1,572.00 $ 836.00 $ 2,308.00 $ 1,572.00 $ 836.00 $ 14,148.00 $ 27,000.00 01-120-62-00-5437 ACCTG SYSTEM SERVICE $ $ $ $ $ $ $ $ $ $ 10,727.70 $ 10,727.70 $ 15,000.00 01-120-62-00-5438 CELLULAR TELEPHONE $ $ 58.16 $ 64.34 $ 61.19 $ 67.16 $ 28.92 $ 28.28 $ 74.86 $ 70.02 $ 45.00 $ 497.93 $ 1,010.00 01-120-64-00-5600 DUES $ 120.00 $ $ $ 35.00 $ $ $ $ 170.00 $ 195.00 $ $ 520.00 $ 1,600.00 01-120-64-00-5603 SUBSCRIPTIONS/BOOKS $ $ $ $ $ $ $ $ $ 97.87 $ 54.40 $ 152.27 $ 250.00 01-120-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ $ $ $ $ $ 01-120-64-00-5605 TRAVEL/MEALS/LODGIN $ $ $ $ $ $ $ $ $ $ - $ $ 01-120-65-00-5802 OFFICE SUPPLIES $ $ 224.09 $ 38.01 $ $ 53.80 $ $ $ 96.61 $ $ $ 412.51 $ 2,000.00 01-120-65-00-5804 OPERATING SUPPLIES $ 100.10 $ $ $ 158.85 $ 100.10 $ 157.22 $ $ $ 136.45 $ - $ 652.72 $ 3,500.00 01-120-65-00-5808 POSTAGE&SHIPPING $ $ $ 94.25 $ 18.73 $ 29.90 $ 61.49 $ $ $ $ $ 204.37 $ 2,500.00 01-120-65-00-5809 PRINTING&COPYING $ $ $ $ $ $ $ $ $ $ - $ $ 1,000.00 01-120-65-00-5844 MARKETING-HOTEL TA} $ $ $ 1,258.49 $ 2,665.74 $ 3,653.47 $ 4,992.99 $ 2,688.53 $ 3,902.98 $ 2,439.70 $ 1,529.16 $ 23,131.06 $ 20,000.00 01-120-72-00-65001MRF PARTICIPANTS $ 1,644.82 $ 1,644.82 $ 2,139.78 $ 1,477.60 $ 492.72 $ 2,034.05 $ 1,571.28 $ 2,320.82 $ 1,242.21 $ 1,227.06 $ 15,795.16 $ 25,190.00 2 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/3-9-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-10 July-10 August-30 September-10 October-10 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 01-120-72-00-6501 SOCIAL SECURITY&MEC $ 1,335.38 $ 1,354.33 $ 1,772.15 $ 1,238.55 $ 400.38 $ 1,694.60 $ 1,310.56 $ 1,935.46 $ 979.59 $ 967.40 $ 12,988.40 $ 29,070.00 01-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 $ 3,491.47 $ 5,000.00 01-120-75-00-7003 OFFICE EQUIPMENT $ $ $ $ $ $ $ $ $ $ $ $ 250.00 01-120-78-00-9001 CITY TAX REBATE $ $ $ $ $ 811.70 $ $ $ $ $ $ 811.70 $ 1,050.00 01-120-78-00-9003 SALES TAX REBATE $ $ 33,521.91 $ 157,137.94 $ 25,985.06 $ 203,698.11 $ $ $ $ 203,21134 $ $ 623,554.36 $ 620,000.00 01-120-78-00-9004 BUSINESS DISTRICT REE $ $ 18,606.77 $ 47,247.67 $ 22,943.42 $ $ 46,866.59 $ $ 45,936.81 $ 21,515.17 $ 27,194.75 $ 230,311.18 $ 150,000.00 01-120-78-00-9013 AMUSEMNT TAX REBATE $ $ $ $ $ $ 99,959.44 $ $ $ $ $ 99,959.44 $ 63,000.00 01-120-78-00-9099 BAD DEBI $ $ $ $ $ $ $ $ $ $ 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 $ 793,241.60 $ 951,890.00 01-120-99-00-9941 TRANSFER TO PARK&RE $ 100,000.00 $ $ $ $ $ $ $ $ $ $ 100,000.00 $ 100,000.00 01-120-99-00-9942 TRANSFER TO POLICE CP $ $ $ $ $ $ $ $ $ $ $ $ 25,000.00 01-120-99-00-9965 TRANSFER TO DEBT SER% $ $ $ 107,351.00 $ $ $ 107,351.00 $ $ $ 107,351.00 $ $ 322,053.00 $ 429,404.00 TOTAL FINANCE EXPENSES1$ 522,940.62 $ 296,884.96 $ 620,158.17 $ 167,320.78 $ 449,275.38 $ 394,376.31 $ 300,665.62 $ 305,074.54 $ 668,993.01 $ 361,734.37 $ $ $ 4,087,423.76 $ 4,492,743.00 GENERAL FUND-COMMUNITY RELATIONS EXPENSES 01-130-50-00-5106 SALARIES-PUBLIC RELAI $ 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 $ 49,296.88 $ 63,750.00 01-130-62-00-5401 CONTRACTUAL SERVICES $ $ 308.00 $ 583.00 $ 111.00 $ 496.00 $ 111.00 $ 250.00 $ 518.00 $ 250.00 $ 250.00 $ 2,877.00 $ 4,800.00 01-130-62-00-5438 CELLULAR TELEPHONE $ - $ 29.08 $ 32.17 $ 30.59 $ 33.58 $ 28.92 $ 28.28 $ 29.86 $ 25.02 $ 32.50 $ 270.00 $ 540.00 01-130-64-00-5603 SUBSCRIPTIONS&BOOKS $ $ $ $ $ $ $ $ $ $ $ $ 100.00 01-130-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ $ $ $ $ $ 01-130-64-00-5605 TRAVEL/MEALS/LODGING $ $ $ $ $ $ $ $ $ $ $ $ 01-130-64-00-5607 PUBLIC RELATIONS $ $ 19.27 $ $ $ $ $ $ $ $ - $ 19.27 $ 1,750.00 01-130-65-00-5802 OFFICE SUPPLIES $ $ $ $ 27.98 $ $ 56.00 $ $ $ $ $ 83.98 $ 750.00 01-130-65-00-5808 POSTAGE&SHIPPING $ $ $ 440.00 $ $ $ $ 440.00 $ $ $ - $ 880.00 $ 3,500.00 01-130-65-00-5809 PRINTING&COPYING $ $ $ $ $ $ $ $ $ $ $ $ 1,000.00 01-130-65-00-5810 PUBLISHING&ADVERTIS $ $ $ $ 1,987.56 $ $ $ $ 2,000.66 $ $ - $ 3,988.22 $ 7,500.00 01-130-72-00-65001MRF PARTICIPANTS $ 456.50 $ 456.50 $ 456.50 $ 684.75 $ 228.25 $ 684.75 $ 456.50 $ 456.50 $ 237.75 $ $ 4,118.00 $ 6,184.00 01-130-72-00-6501 SOCIAL SECURITY&MEC $ 294.30 $ 294.30 $ 294.30 $ 441.45 $ 147.15 $ 447.30 $ 294.30 $ 294.30 $ 229.50 $ 194.84 $ 2,931.74 $ 4,877.00 01-130-78-00-9010 COMMUNITY EVENTS $ (665.00) $ (425.00) $ 217.98 $ $ 111.44 $ $ $ $ 1,188.38 $ $ 427.80 $ 6,000.00 01-130-78-00-9013 HOLIDAY UNDER THE STF $ $ 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 $ "i_ 1,444.32 $ 1,963.83 $ 3,562.79 $ $ $ 64,892.89 $ 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 $ 209,388.08 $ 263,233.00 01-150-50-00-5137 SALARIES-OVERTIME $ $ $ $ 86.59 $ $ $ $ $ $ $ 86.59 $ 500.00 01-150-62-00-5401 CONTRACTUAL SERVICES $ $ 427.00 $ 593.99 $ $ $ 150.00 $ 45.00 $ 808.50 $ 464.00 $ 49.00 $ 2,537.49 $ 30,000.00 01-150-62-00-5403 FEES $ $ $ 1,000.00 $ $ $ $ $ $ $ $ 1,000.00 $ 2,550.00 01-150-62-00-5409 MAINTENANCE-VEHICLES $ 36.68 $ $ 63.99 $ 34.95 $ 410.90 $ 720.00 $ 2.35 $ $ 33.95 $ $ 1,302.82 $ 1,500.00 01-150-62-00-5410 MAINTENANCE-OFFICE EC $ $ $ $ $ $ $ $ $ $ $ $ 500.00 01-150-62-00-5411 MAINTENANCE-COMPUTERS $ $ $ $ $ $ $ $ $ $ $ $ 500.00 01-150-62-00-5421 WEARING APPAREL $ $ $ $ $ $ $ $ $ $ $ $ 100.00 01-150-62-00-5438 CELLULAR TELEPHONE $ $ 116.32 $ 128.68 $ 122.37 $ 134.31 $ 115.69 $ 113.13 $ 119.43 $ 100.09 $ 97.50 $ 1,047.52 $ 3,000.00 01-150-64-00-5600 DUES $ $ $ $ $ $ 240.00 $ $ $ $ 157.54 $ 397.54 $ 1,000.00 01-150-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ $ $ $ $ $ 01-150-64-00-5605 TRAVEL EXPENSE $ $ $ $ $ $ $ $ $ $ $ $ 01-150-54-00-5608 TUITION REIMBURSEMENT $ $ $ $ $ $ $ $ $ $ - $ $ 01-150-64-00-5616 BOOKS&PUBLICATIONS $ $ $ $ $ $ $ $ 126.00 $ $ $ 126.00 $ 130.00 01-150-65-00-5801 ENGINEERING SUPPLIES $ $ 17.21 $ $ 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 $ 27.70 $ 11.98 $ 304.95 $ 1,250.00 01-150-65-00-5808 POSTAGE&SHIPPING $ $ $ $ $ $ $ $ $ 33.60 $ $ 33.60 $ 500.00 01-150-65-00-5809 PRINTING&COPYING $ $ 108.80 $ 100.23 $ 150.32 $ 96.12 $ 91.95 $ 117.86 $ 149.41 $ 31.43 $ 81.78 $ 927.90 $ 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 $ 19,219.19 $ 25,582.00 01-150-72-00-6501 SOCIAL SECURITY&MEC $ 1,620.58 $ 1,526.06 $ 1,526.06 $ 2,295.69 $ 763.03 $ 2,269.53 $ 1,526.06 $ 2,096.12 $ 918.96 $ 918.96 $ 15,461.05 $ 20,176.00 01-150-75-00-7002 COMPUTER EQUIPMENT& $ $ 262.80 $ 398.80 $ $ 1,389.79 $ $ $ 262.80 $ $ $ 2,314.19 $ 3,300.00 01-150-75-00-7003 OFFICE EQUIPMENT $ $ $ $ $ $ $ $ $ $ $ $ 500.00 01-150-78-00-9015 ENERGY&RECYCLING GF $ $ $ $ 5,307.00 $ $ $ $ $ $ $ 5,307.00 $ TOTAL ENGINEERING EXPENSES $ 25,665.37 $ 25,150.87 $ 26,525.96 $ 42,257.55 $ 14,227.91 $ 37,162.45 $ 24,699.32 $ 34,397.30 $ 15,184.03 $ 14,891.06 $ $ $ 260,161.82 $ 357,821.00 GENERAL FUND-POLICE EXPENSES 01-210-50-00-5107 SALARIES-POLICE $ 110,899.51 $ 87,416.36 $ 88,012.39 $ 129,454.32 $ 44,413.88 $ 132,625.97 $ 89,748.25 $ 90,339.74 $ 91,876.77 $ 90,140.92 $ 954,928.11 $ 1,316,326.00 01-210-50-00-5131 SALARIES-CHIEF/LT./S $ 49,772.92 $ 52,821.25 $ 50,916.00 $ 77,069.26 $ 26,416.17 $ 75,819.25 $ 47,798.35 $ 58,186.77 $ 55,761.87 $ 51,689.24 $ 546,251.08 $ 673,166.00 01-210-50-00-5134 SALARIES-CROSSING GU $ 2,097.25 $ 638.25 $ - $ 369.25 $ 949.50 $ 2,974.00 $ 1,889.50 $ 1,680.75 $ 1,040.00 $ 1,673.00 $ 13,311.50 $ 25,000.00 01-210-50-00-5135 SALARIES-POLICE CLER $ 16,198.50 $ 16,198.49 $ 15,178.49 $ 18,177.75 $ 6,059.24 $ 18,177.73 $ 12,093.50 $ 16,013.69 $ 8,937.72 $ 8,937.74 $ 135,972.85 $ 212,386.00 01-210-50-00-5136 SALARIES-PART TIME $ 2,081.48 $ 2,261.05 $ 2,227.35 $ 2,620.99 $ 1,846.50 $ 3,996.33 $ 2,503.34 $ 2,165.94 $ 1,945.76 $ 2,280.31 $ 23,929.05 $ 39,000.00 01-210-50-00-5137 SALARIES-OVERTIME $ 7,025.27 $ 11,666.53 $ 12,420.47 $ 4,053.75 $ (2,157.50) $ 7,913.23 $ 256.92 $ 8,182.41 $ 4,684.46 $ 2,158.85 $ 56,204.39 $ 60,000.00 01-210-50-00-5200 CADET PROGRAM $ 697.50 $ 834.75 $ 1,210.50 $ 1,584.00 $ 555.75 $ 1,017.00 $ 697.50 $ 681.75 $ 686.25 $ 474.75 $ 8,439.75 $ 13,500.00 01-210-50-00-5205 SALARIES-GRANT REIMS $ 1,402.51 $ 18,322.76 $ (1,325.98) $ 240.65 $ 18,639.94 01-210-50-00-5206 POLICE SPECIAL DETAIL $ 4,431.73 $ 4,431.73 01-210-61-00-5300 LEGAL SERVICES $ $ $ $ $ $ $ $ $ $ $ $ 20,000.00 01-210-62-00-5401 CONTRACTUAL SERVICES n/a n/a n/a n/a $ 275.71 $ 55.22 $ 54.97 $ 54.92 $ 55.22 $ 54.92 $ 550.96 $ 3 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/3-9-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-SO June-10 July-10 August-30 September-10 October-10 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 01-210-62-00-5408 MAINTENANCE-EQUIPME $ $ 35.80 $ 237.50 $ 1,573.16 $ 68.50 $ 1,065.31 $ 372.99 $ 723.70 $ 1,013.90 $ 686.30 $ 5,777.16 $ 9,750.00 01-210-62-00-5409 MAINTENANCE-VEHICLE $ 1,338.84 $ 1,568.12 $ 3,565.06 $ 3,853.65 $ 4,270.98 $ 2,925.02 $ 1,626.45 $ 1,602.18 $ 3,167.51 $ 6,022.94 $ 29,940.75 $ 47,000.00 01-210-62-00-5410 MAINT-OFFICE EQUIPMEN $ $ $ $ 65.00 $ (65.00) $ $ $ $ $ $ $ 01-210-62-00-5411 MAINTENANCE-COMPUTE $ $ 123.49 $ $ $ $ 148.82 $ $ $ $ $ 272.31 $ 2,500.00 01-210-62-00-5412 MAINTENANCE-KS $ $ $ $ (54.50) $ 65.00 $ $ $ $ $ $ 10.50 $ 1,000.00 01-210-62-00-5414 WEATHER WARNING SIREN $ $ 414.00 $ $ 182.88 $ 2,915.66 $ $ $ $ $ $ 3,512.54 $ 4,000.00 01-210-62-00-5421 WEARING APPAREL $ 84.95 $ 134.95 $ 1,343.33 $ 2,495.69 $ 486.48 $ 396.98 $ 853.85 $ 689.74 $ 666.24 $ 307.06 $ 7,459.27 $ 10,000.00 01-210-62-00-5422 COPS GRANT IV-VESTS $ $ $ $ 1,825.00 $ 610.00 $ 1,210.00 $ $ $ $ $ 3,645.00 $ 4,200.00 01-210-62-00-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 $ 6,759.64 $ 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 $ 10,009.86 $ 17,920.00 01-210-62-00-5441 MTD-ALERTS FEE $ 3,330.00 $ $ $ $ $ 3,330.00 $ $ $ $ $ 6,660.00 $ 5,150.00 01-210-62-00-5442 NEW WORLD LIVE SCAN $ $ $ 8,286.30 $ $ $ $ $ $ $ $ 8,286.30 $ 15,000.00 01-210-62-00-5443 ADMIN ADJUDICATION CO $ 175.00 $ 1,068.00 $ 1,759.00 $ 1,287.00 $ 1,712.00 $ 1,325.00 $ 1,425.00 $ 1,056.00 $ 1,300.00 $ 1,824.00 $ 12,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 EXPENSE' $ - $ 217.28 $ $ (217.28) $ 51.47 $ 46.10 $ $ 284.40 $ 83.38 $ 68.42 $ 533.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 $ $ $ $ $ $ $ $ 970.84 $ 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 REIME $ $ 45.92 $ $ $ $ 6.21 $ 11.73 $ $ $ - $ 63.86 $ 01-210-65-00-5802 OFFICE SUPPLIES $ 437.36 $ 88.18 $ 94.45 $ 64.18 $ 232.84 $ 674.19 $ 126.46 $ 206.38 $ 26.99 $ 183.14 $ 2,134.17 $ 3,000.00 01-210-65-00-5803 EVIDENCE TECH SUPPLIE $ $ $ $ $ $ $ $ $ 946.85 $ $ 946.85 $ 1,000.00 01-210-65-00-5804 OPERATING SUPPLIES $ 14.55 $ 460.30 $ 646.24 $ 380.18 $ 285.52 $ 681.06 $ 642.57 $ 1,132.54 $ 487.62 $ 294.79 $ 5,025.37 $ 8,500.00 01-210-65-00-5808 POSTAGE&SHIPPING $ - $ $ $ 95.74 $ 45.71 $ $ $ 47.39 $ $ $ 188.84 $ 3,000.00 01-210-65-00-5809 PRINTING&COPYING $ $ 114.61 $ 456.69 $ 228.18 $ 213.65 $ 89.20 $ 75.01 $ 100.28 $ 84.27 $ 90.71 $ 1,452.60 $ 4,500.00 01-210-65-00-5810 PUBLISHING&ADVERTIS $ $ $ 25.60 $ $ $ $ $ $ $ $ 25.60 $ 100.00 01-210-65-00-5812 GASOLINE $ $ 5,571.25 $ 5,403.37 $ 5,556.52 $ 5,257.04 $ 4,989.80 $ 5,289.94 $ 4,779.71 $ 5,517.01 $ 6,377.03 $ 48,741.67 $ 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 $ 12,482.22 $ 24,385.00 01-210-72-00-6501 SOCIAL SECURITY&MEC $ 13,929.96 $ 12,645.33 $ 12,482.41 $ 17,445.32 $ 6,398.32 $ 17,915.44 $ 11,992.67 $ 12,857.23 $ 12,414.59 $ 11,618.40 $ 129,699.67 $ 178,962.00 01-210-72-00-6502 POLICE PENSION $ $ $ 25,704.86 $ 132,566.85 $ 34,362.70 $ 126,18Z_.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 STIPENC $ 230.76 $ 135.98 $ 103.02 $ $ $ $ $ $ $ $ 469.76 $ TOTAL POLICE EXPENSES $ 215,682.77 $ 197,195.36 $ 234,703.18 $ 407,021.71 $ 138,539.30 $ 409,882.09 $ 192,205.74 $ 236,774.80 $ 197,557.51 $ 188,865.21 $ $ $ 2,418,427.67 $ 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 $ 228,741.09 $ 287,132.00 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 $ $ $ $ $ 7,377.00 $ 1,125.00 $ $ 3,015.00 $ $ 1,650.00 $ 13,167.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 $ 999.92 $ 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 $ $ 65.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 $ $ 360.19 $ 500.00 01-220-65-00-5804 OPERATING SUPPLIES $ 135.94 $ 6.50 $ 316.20 $ $ 5.94 $ 71.13 $ $ 33.40 $ $ 16.90 $ 586.01 $ 3,500.00 01-220-65-00-5808 POSTAGE&SHIPPING $ $ $ $ $ $ $ $ 6.96 $ $ $ 6.96 $ 1,000.00 01-220-65-00-5809 PRINTING&COPYING $ $ 108.80 $ 95.24 $ 150.33 $ 96.12 $ 91.95 $ 78.67 $ 139.41 $ 31.43 $ 81.78 $ 873.73 $ 1,300.00 01-220-65-00-5810 PUBLISHING&ADVERTIS $ $ 86.90 $ $ $ $ $ $ $ $ $ 86.90 $ 150.00 01-220-65-00-5814 BOOKS&MAPS $ $ $ $ 202.10 $ $ $ $ $ 50.00 $ $ 252.10 $ 500.00 01-220-72-00-65001MRF PARTICIPANTS $ 1,662.35 $ 1,794.04 $ 1,794.04 $ 2,985.42 $ 1,028.49 $ 3,048.95 $ 2,060.64 $ 2,544.71 $ 1,669.03 $ 1,682.35 $ 20,270.02 $ 27,851.00 01-220-72-00-6501 SOCIAL SECURITY&MEC $ 1,513.95 $ 1,638.45 $ 1,619.33 $ 2,352.61 $ 812.15 $ 2,423.10 $ 1,631.56 $ 2,056.37 $ 1,278.48 $ 1,289.19 $ 16,615.19 $ 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 $ 13,671.99 $ 40,495.66 $ 26,657.61 $ 54,317.58 $ 65,955.09 $ 22,968.61 $ $ $ 342,074.70 $ 446,179.00 4oJ14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/3-9-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 GENERAL FUND-STREETS EXPENSES 01-410-50-00-5107 SALARIES-STREET'- $ 22,823.93 $ 21,647.26 $ 22,964.73 $ 33,445.49 $ 11,296.22 $ 33,854.65 $ 22,590.98 $ 25,995.90 $ 22,010.03 $ 22,445.85 $ 239,075.04 $ 243,472.00 01-410-50-00-5136 SALARIES-PART TIME $ $ $ $ $ $ $ $ $ $ $ $ 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 $ 9,548.76 $ 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.98 $ 44.98 $ 19.98 $ 19.98 $ 53.30 $ 19.98 $ 119.99 $ 199.98 $ 518.16 $ 1,000.00 01-410-62-00-5408 MAINTENANCE-EQUIPMENI $ $ (2,259.25) $ 2,540.88 $ 79.33 $ 219.90 $ 1,613.75 $ 181.29 $ 51.21 $ 4,687.90 $ 1,007.78 $ 8,122.79 $ 10,000.00 01-410-62-00-5409 MAINTENANCE-VEHICLES $ 475.42 $ 68.29 $ 923.67 $ $ 521.70 $ 1,944.12 $ 9,714.20 $ 3,158.38 $ 2,681.14 $ 1,034.25 $ 20,521.17 $ 25,000.00 01-410-62-00-5414 MAINTENANCE-TRAFFIC' $ (49.55) $ (13,233.67) $ 567.55 $ $ 3,059.81 $ 3,465.06 $ 1,017.00 $ 5.97 $ 14,189.87 $ $ 9,022.04 $ 15,000.00 01-410-62-00-5415 MAINTENANCE-STREET L $ 192.00 $ 1,370.75 $ 4,235.05 $ (2,620.96) $ 725.39 $ 485.72 $ 549.40 $ 389.64 $ 11,433.50 $ 1,570.75 $ 18,331.24 $ 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 $ 8,693.56 $ 30,000.00 01-410-62-00-5420 MAINTENANCE-STORM SE% $ $ $ 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 $ 1,590.43 $ 4,200.00 01-410-62-00-5434 RENTAL-EQUIPMENI $ $ $ 176.00 $ $ $ $ $ $ $ $ 176.00 $ 1,000.00 01-410-62-00-5435 ELECTRICITY $ $ 1,967.83 $ 6,323.23 $ 6,638.22 $ 6,503.63 $ 8,003.51 $ 7,835.31 $ 5,159.18 $ 11,304.26 $ 8,087.01 $ 61,822.18 $ 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 $ 1,539.72 $ 4,020.00 01-410-62-00-5440 STREET LIGHTING $ $ $ $ $ $ $ $ $ $ $ $ 01-410-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ $ $ $ $ $ 2,000.00 01-410-65-00-5804 OPERATING SUPPLIES $ 150.00 $ 139.78 $ 1,068.99 $ $ 371.89 $ 37.29 $ 176.08 $ 515.23 $ 364.82 $ 188.73 $ 3,012.81 $ 10,000.00 01-410-65-00-5810 ELECTRICAL MAINTSUPF $ $ $ $ $ $ $ $ $ $ $ $ 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 $ 20,215.36 $ 32,000.00 01-410-65-00-5815 HAND TOOL $ $ $ $ $ $ 18.93 $ $ $ $ 819.35 $ 838.28 $ 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 $ 22,903.27 $ 26,332.00 01-410-72-00-6501 SOCIAL SECURITY&MED $ 1,743.67 $ 1,750.95 $ 1,739.00 $ 2,596.91 $ 860.48 $ 2,600.97 $ 1,749.94 $ 1,852.93 $ 1,724.67 $ 1,935.91 $ 18,555.43 $ 20,768.00 01-410-75-00-4404 HANGING BASKETS $ $ 1,832.00 $ 204.00 $ 11.98 $ $ $ $ $ $ $ 2,047.98 $ 2,000.00 01-410-75-00-5418 MOSQUITO CONTROL $ $ $ $ $ $ 6,500.00 $ $ $ $ $ 6,500.00 $ 15,000.00 01-410-75-00-7004 SAFETY EQUIPMENI $ $ 245.75 $ $ $ $ $ $ 270.26 $ 45.00 $ - $ 561.01 $ 500.00 01-410-75-00-7101 IN TOWN ROAD PROGRAN $ $ $ $ $ $ $ $ $ $ $ $ 40,232.00 01-410-75-00-7102 TREE&STUMP REMOVAI $ $ $ $ 150.00 $ 4,800.00 $ $ $ $ $ - $ 4,950.00 $ 10,000.00 01-410-75-00-7103 SIDEWALK CONSTRUCTION $ 246.00 $ $ $ $ 240.00 $ $ 739.04 $ $ $ $ 1,225.04 $ 4,000.00 01-410-78-00-9010 PARKWAY TREE 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 $ $ $ 466,139.46 $ 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 EXPENSES1$ $ 99,377.71 $ 98,735.97 $ 99,049.02 $ 98,777.71 $ 98,631.62 $ 98,235.09 $ 98,026.39 $ 101,777.69 $ 97,588.12 $ $ $ 890,199.32 $ 1,146,000.00 TOTAL FUND REVENUES1$ 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 $ 990,017.22 $ $ $ 10,049,230.86 $ 11,433,025.00 TOTAL FUND EXPENSES $ 850,913.24 $ 705,428.95 11, $ 1,188,665.20 $ 905,252.63 $ 806,979.66 $ 1,161,607.48 $ 777,423.05 $ 877,701.24 $ 1,247,827.95 $ 802,861.34 $ $ $ 9,324,660.74 $ 376,980.00 FUND SURPLUS(DEFICIT) $ (473,487.66) $ 1,524,783.75 1$ (469,342.57)1$ 25,826.97 1$ 1,019,267.87 1$ (279,961.27) $ (321,209.06) $ (83,610.86) $ (404,852.93)1$ 187,155.88 1$ $ $ 724,570.12 $ 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 $ $ I$ - 1$ 19,894.11 $ 19,463.00 FOX HILL SSA EXPENSES 11-000-65-00-5416 MAINTENANCE COMMON GR $ $ 430.00 $ 909.84 $ 967.50 $ 454.92 $ 568.65 $ 454.92 $ $ $ $ 3,785.83 $ 3,458.00 TOTAL FUND REVENUESS$ 1$ 9,414.19 1$ 441.86 1$ 1,881.23 1$ 7,271.40 1$ 388.47 1$ 496.96 1$ $ $ $ $ $ 19,894.11 $ 19,463.00 TOTAL FUND EXPENSES $ 1$ 430.00 1$ 909.84 1$ 967.50 1$ 454.92 1$ 568.65 1$ 454.92 1$ $ $ $ $ $ 3,785.83 $ 3,458.00 FUND SURPLUS(DEFICIT) $ $ 8,984.19 1$ (467.98)1$ 913.73 1$ 6,816.48 1$ (180.18)l$ 42.04 1$ $ $ $ $ $ 16,108.28 $ 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.80 $ 1,649.00 $ 1,812.57 $ 1,219.00 $ 537.50 $ 107.50 $ $ $ $ 7,530.37 $ 8,253.00 TOTAL FUND REVENUES S$ $ 6,652.73 $ 341.13 $ 963.56 $ 5,676.61 $ 57.34 $ 179.13 $ $ $ $ $ $ 13,870.50 $ 13,112.00 TOTAL FUND EXPENSESS$ 1$ 2,204.80 1$ 1,649.00 1$ 1,812.57 1$ 1,219.00 1$ 537.50 1$ 107.50 1$ 1$ 1$ I$ I$ $ 7,530.37 1$ 8,253.00 FUND SURPLUS(DEFICIT)l$ 1$ 4,447.93 1$ (1,307.87) $ (849.01)1$ 4,457.61 1$ (480.16)1$ 71.63 1$ :$ $ $ $ $ 6,340.13 $ 4,859.00 MOTOR FUEL TAX REVENUES 15-000-40-00-4060 MOTOR FUEL TAX ALLOTN $ 36,524.19 $ 35,337.89 $ 33,399.04 $ 36,201.75 $ 35,211.55 $ 40,536.39 $ 29,696.11 $ 37,878.11 $ 36,262.43 $ 39,229.64 $ 360,277.10 $ 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 LOl n/a n/a n/a n/a $ $ 151,000.00 $ $ $ $ $ 151,000.00 $ 15-000-44-00-44801LLINOISJOSS NOW $ $ $ 73,122.00 $ $ $ - $ 73,122.00 15-000-44-00-4490 MISC.INCOME $ $ $ $ $ $ $ 85.50 $ $ $ $ 85.50 $ 15-000-46-00-4600 INVESTMENT INCOME $ 38.80 $ 52.60 $ 59.29 $ 70.38 $ 75.17 $ 99.34 $ 93.03 $ 90.36 $ 78.11 $ 58.39 $ 715.47 $ 1,000.00 5 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/3-9-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-10 July-10 August-30 September-10 October-10 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 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 $ 116,180.06 $ 204,000.00 15-000-75-00-7007 SIGNS $ $ $ 67.10 $ $ $ 41.95 $ $ $ 251.70 $ 135.20 $ 495.95 $ 18,000.00 15-000-75-00-7009 PATCHING $ $ $ $ $ $ $ $ 49,857.33 $ $ $ 49,857.33 $ 50,000.00 15-000-75-00-7106 GAME FARM SURVEYING $ $ $ $ 6,456.02 $ $ $ $ $ $ $ 6,456.02 $ 15-000-75-00-7108 GAME FARM HOUSE DEMC $ $ $ $ $ $ $ $ $ $ $ $ 20,000.00 15-000-75-00-7110 COLD PATCH $ $ 1,488.11 $ $ $ $ $ $ $ 1,500.15 $ $ 2,988.26 $ 10,600.00 15-000-75-00-7111 HOT PATCH $ $ $ $ $ $ 6,168.64 $ $ 1,489.51 $ $ $ 7,658.15 $ 13,000.00 15-000-75-00-7118 RT 34&SYCAMORE TRAI $ $ $ $ $ $ $ $ $ $ $ $ 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 OVERLAI $ $ $ $ $ $ $ $ $ $ $ $ 15-000-75-00-7123 GUARDRAIL REPAIRS $ $ $ $ $ $ 23,127.67 $ $ $ $ $ 23,127.67 $ 15-000-75-00-71241L 47 @US 30 SIGNAL° $ $ $ $ $ $ - $ - $ $ $ - $ 15-000-75-00-9923 TRANSFER TO CITY WIDE CAPITA $ 1$ 1$ $ $ $ $ $ $ $ 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,965.47 $ 36,340.54 $ 39,288.03 $ $ $ 621,454.34 $ 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 $ $ $ 344,693.51 $ 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)1$ $ $ 276,760.83 $ (119,600.00) MUNICIPAL BUILDING REVENUES 16-000-42-00-4211 DEVELOPMENT FEES-BUTT $ 1,350.00 $ 15,900.00 $ 150.00 $ 450.00 $ 750.00 $ 1,350.00 $ $ $ $ $ 19,950.00 $ 55,000.00 TOTAL FUND REVENUES $ 1,350.00 $ 15,900.00 $ 150.00 $ 450.00 $ 750.00 $ 1,350.00 $ $ $ $ $ _ $ $ 19,950.00 $ 55,000.00 TOTAL FUND EXPENSES $ $ $ $ $ $ $ $ $ $ $ $ $ $ FUND SURPLUS(DEFICIT) $ 1,350.00 $ 15,900.00 1$ 150.00 $ 450.00 $ 750.00 $ 1,350.00 $ $ 1$ 1$ IL 1$ 11$ 19,950.00 1$ 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 $ $ $ 14,509.00 $ 25,000.00 20-000-44-00-44031N CAR VIDEO DONATION $ 500.00 $ 265.80 $ 140.40 $ 188.20 $ 707.40 $ 223.20 $ 432.40 $ 652.17 $ 813.11 $ 694.20 $ 4,616.88 $ 20-000-44-00-4404 DONATIONS $ $ $ $ $ $ $ $ $ $ $ $ 20-000-44-00-4405 WEATHER WARNING SIREN $ $ $ $ $ 103.50 $ 18.75 $ $ $ $ 285.75 $ 408.00 $ 6,000.00 20-000-44-00-4431 SALE OF POLICE SQUADS $ 1,000.00 $ 2,500.00 $ $ $ $ $ $ $ $ 400.00 $ 3,900.00 $ 1,000.00 20-000-44-00-4440 SEIZED VEHICLES $ - $ $ 1,000.00 $ 1,000.00 $ 150.00 $ $ 752.50 $ $ $ $ 2,902.50 $ 5,000.00 20-000-49-00-4901 TRANSFER FROM GENERAI $ $ $ $ $ $ $ $ $ $ $ $ 25,000.00 POLICE CAPITAL EXPENSES 20-000-65-00-5811 LETHAL/NON-LETHAL WEF $ $ $ $ $ $ $ $ $ $ $ $ 20-000-65-00-5840 SEIZED VEHICLES $ $ 95.00 $ 95.00 $ 380.00 $ 325.00 $ 95.00 $ 60.00 $ 486.01 $ 105.00 $ $ 1,641.01 $ 1,500.00 20-000-75-00-7001 EQUIPMENT $ $ $ $ $ $ $ $ $ $ 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 OUl $ $ $ $ - $ 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 $ $ $ 26,336.38 $ 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 $ $ $ 49,475.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 $ $ $ (23,138.68) $ (42,000.00) PUBLIC WORKS CAPITAL REVENUES 21-000-42-00-4213 DEVELOPMENT FEES-PUBI $ 6,050.00 $ 2,550.00 $ 1,400.00 $ 1,850.00 $ 3,250.00 $ 5,800.00 $ $ 700.00 $ $ 21,600.00 $ 35,000.00 21-000-42-00-4288 MOWING INCOME $ 2,041.25 $ 337.81 $ 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-75-00-7001 EQUIPMENI $ $ $ (92.66) $ (492.12) $ (254.12) $ (214.11) $ (509.69) $ $ $ 1,562.70 $ $ 21-000-75-00-7005 VEHICLES $ $ $ $ $ $ $ $ $ $ $ $ 46,000.00 21-000-75-00-7015 SKIDSTEER UPGRADE $ $ $ $ $ $ $ $ $ $ $ $ 4,000.00 21-000-75-00-7107 TRUCK ACCESSORIES $ $ $ $ $ $ $ $ $ $ $ $ 5,000.00 21-000-75-00-7110 PW BUILDING 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 $ 75,437.12 $ 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 $ $ $ 28,824.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 $ $ $ 75,437.12 $ 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) $ $ $ (46,612.36) $ (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 CONSTP $ $ $ $ $ $ $ $ $ $ - $ $ 15,000.00 22-000-44-00-4430 SALE OF VEHICLES/EQU $ $ $ $ $ $ $ $ $ $ $ $ 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 $ 85.69 $ PARK&RECREATION CAPITAL EXPENSES 22-610-75-00-7006 PICK UP TRUCK $ $ $ $ $ $ $ $ $ $ $ $ 6 o 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/3-9-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-SO July-10 August-30 September-10 October-10 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 22-610-75-00-7010 RAINTREE PARR $ $ 275.16 $ 1,500.00 $ $ $ $ $ $ $ $ 1,775.16 $ 158,135.00 22-610-75-00-7011 BASEBALL FIELD CONSTF $ $ - $ - $ - $ - $ 3,907.12 $ 4,950.00 $ 6,206.55 $ 592.25 $ - $ 15,655.92 $ 15,000.00 TOTAL FUND REVENUES $ 356.72 $ 6.52 $ 6.95 $ 6.94 $ 656.51 $ 6.72 $ 656.51 $ 6.72 $ 26.03 $ 6.07 $ $ $ 1,735.69 $ 17,500.00 TOTAL FUND EXPENSES $ $ 275.16 $ 1,500.00 $ $ $ 3,907.12 $ 4,950.00 $ 6,206.55 $ 592.25 $ $ $ $ 17,431.08 $ 173,135.00 FUND SURPLUS(DEFICIT) $ 356.72 $ (268.64) $ (1,493.05) $ 6.94 $ 656.51 $ (3,900.40) $ (4,293.49) $ (6,199.83) $ (566.22) $ 6.07 $ $ $ (15,695.39) $ (155,635.00) CITY WIDE CAPITAL REVENUES 23-000-40-00-3996 ROAD CONTRIBUTION $ 12,000.00 $ $ 2,000.00 $ $ $ 2,000.00 $ - $ $ $ $ 16,000.00 $ 24,000.00 23-000-42-00-4211 ENGINEERING CAPITAL F $ 800.00 $ 300.00 $ 200.00 $ 200.00 $ 400.00 $ 700.00 $ $ $ $ $ 2,600.00 $ 4,000.00 23-000-44-00-4400 REIMB.OLD JAIL n/a n/a n/a n/a n/a $ $ $ $ $ 1,200.00 $ 1,200.00 $ 23-000-45-00-4501 SAFE RTTO SCHOOL(DE $ $ $ $ $ $ $ $ $ $ $ $ 46,200.00 23-000-45-00-4502 SAFE RTTO SCHOOL(CC $ $ $ $ $ $ $ $ $ $ $ $ 184,800.00 23-000-45-00-4600 INVESTMENT INCOME n/a n/a n/a n/a $ 2.75 $ 2.37 $ 2.29 $ 2.37 $ 2.36 $ 2.14 $ 14.28 $ 23-000-49-00-4901 TRANSFER FROM GENERAI $ $ $ 40,625.00 $ $ $ 40,625.00 $ $ $ 40,625.00 $ $ 121,875.00 $ 162,500.00 23-000-49-00-4915 TRANSFER FROM MFl $ $ $ $ $ $ $ $ $ $ 96,000.00 $ 96,000.00 $ CITY WIDE CAPITAL EXPENSES 23-000-62-00-5401 CONTRACTUAL SERVICES $ $ $ $ $ $ $ $ $ $ 71.00 $ 71.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 SCHOOI $ $ $ $ $ $ $ $ $ $ $ $ 46,200.00 23-000-75-00-7114 SAFE FITS TO SCHOOL(( $ $ $ $ $ $ $ $ $ $ - $ $ 184,800.00 23-000-75-00-7115 PALMER COURT $ $ $ $ $ $ $ $ $ $ $ $ 23-000-75-00-7116 TOWN SQUARE PARR $ $ $ $ $ $ $ $ $ $ - $ $ 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 $ $ $ $ $ $ $ $ $ $ $ $ - 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 $ $ $ 237,689.28 $ 421,500.00 TOTAL FUND EXPENSES1$ 125,000.00 $ $ $ 161,569.00 $ 5,934.11 $ $ 4,111.30 $ 490.06 $ $ $ $ $ 297,104.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 $ $ $ (59,415.19) $ (161,000.00) DEBT SERVICE REVENUES 42-000-44-00-4440 RECAPTURE-WATER/SEWEF $ 225.00 1$ 125.00 $ 75.00 $ 75.00 $ 125.00 $ 225.00 $ 25.00 $ 25.00 $ $ $ 900.00 $ 42-000-49-00-4901 TRANSFER FROM GENERAI $ $ $ 107,351.00 $ $ $ 107,351.00 $ $ $ 107,351.00 $ - $ 322,053.00 $ 429,404.00 DEBT SERVICE EXPENSES 42-000-66-00-6070$650K ROAD IMPROV PRC $ $ $ $ $ $ $ $ $ $ - $ $ 42-000-66-00-6071$650K ROAD IMPROV PRC $ 6,412.50 $ $ $ $ $ $ $ 101,412.50 $ $ $ 107,825.00 $ 107,825.00 42-000-66-00-6074$3.825M IN TOWN ROAC $ - $ $ $ $ $ $ $ - $ $ - $ - $ - 42-000-66-00-6075$3.825M IN TOWN ROAC $ $ 68,289.38 $ $ $ $ $ $ 253,289.38 $ $ $ 321,578.76 $ 321,579.00 TOTAL FUND REVENUES $ 225.00 $ 125.00 $ 107,426.00 $ 75.00 $ 125.00 $ 107,576.00 $ 25.00 $ 25.00 $ 107,351.00 $ $ $ $ 322,953.00 $ 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 $ $ $ (106,450.76) $ WATER OPERATIONS REVENUES 51-000-42-00-4240 BULK WATER SALE! $ 110.00 $ (98.00) $ $ (149.00) $ (152.00) $ 397.77 $ (392.00) $ (392.00) $ 1,232.00 $ (463.34) $ 93.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,686.71 $ 267,679.18 $ 1,457,492.94 $ 1,286,250.00 51-000-42-00-4242 WATER METER SALE! $ 4,270.00 $ 3,540.00 $ 2,665.00 $ 1,795.00 $ 2,330.00 $ 4,080.00 $ 390.00 $ 440.00 $ $ $ 19,510.00 $ 32,000.00 51-000-42-00-4243 LEASE REVENUE-H201 $ 2,149.29 $ 2,149.29 $ 2,149.29 $ 5,408.29 $ 2,459.79 $ 2,149.29 $ 2,770.29 $ 2,149.29 $ 3,070.29 $ 2,534.77 $ 26,989.88 $ 29,000.00 51-000-44-00-4417 REIMBURSEMENT' $ 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 $ $ $ $ 2,866.82 $ 51-000-46-00-4600 INVESTMENT INCOME $ 45.40 $ 133.06 $ 331.98 $ 192.15 $ 170.96 $ 318.84 $ 86.56 $ 78.78 $ 43:45 $ 37.71 $ 1,438.89 $ 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 $ 276,144.20 $ 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 $ 3,444.19 $ 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 $ 5,189.76 $ 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 $ 185,957.12 $ 230,000.00 51-000-62-00-5408 MAINTENANCE-EQUIPMENT $ $ $ 21.09 $ 196.02 $ $ $ $ 322.17 $ 251.00 $ 20.05 $ 810.33 $ 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 $ 3,392.51 $ 9,000.00 51-000-62-00-5411 MAINTENANCE-COMPUTER' $ $ $ $ $ $ $ $ $ $ $ $ 500.00 51-000-62-00-5421 WEARING APPAREL $ 65.61 $ 85.57 $ 150.39 $ 142.07 $ 159.64 $ 91.44 $ 150.78 $ 125.43 $ 180.23 $ 198.04 $ 1,349.20 $ 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 $ 178,468.24 $ 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 $ 9,645.77 $ 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 $ 1,651.18 $ 3,300.00 7 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/3-9-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-SO June-10 July-10 August-30 September-10 October-10 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 51-000-64-00-5600 DUES $ $ 367.00 $ $ $ $ $ $ $ $ 475.00 $ 842.00 $ 1,000.00 51-000-64-00-5603 SUBSCRIPTIONS $ - $ $ $ $ $ $ $ 57.20 $ $ - $ 57.20 $ 250.00 51-000-64-00-5604 TRAINING&CONFERENCE $ $ $ 330.00 $ $ $ 776.60 $ $ $ 735.00 $ $ 1,841.60 $ 1,600.00 51-000-64-00-5605 TRAVEL EXPENSE' $ $ $ $ $ $ $ $ $ $ - $ $ 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 $ 12,073.43 $ 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 $ $ 626.00 $ 13,208.52 $ 22,000.00 51-000-65-00-5809 PRINTING&COPYING $ $ 106.01 $ 103.67 $ 103.42 $ 103.58 $ 103.19 $ 105.07 $ 102.37 $ 109.60 $ 107.69 $ 944.60 $ 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 $ 20,873.38 $ 34,000.00 51-000-65-00-5815 HAND TOOL' $ $ $ $ $ $ $ $ $ $ $ $ 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 CHEMICAL $ $ $ $ $ $ $ $ $ $ $ $ 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 $ 25,716.36 $ 31,017.00 51-000-72-00-6501 SOCIAL SECURITY&MEE $ 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 $ 20,396.97 $ 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 READER'- $ $ $ 421.81 $ $ $ $ $ $ $ $ 421.81 $ 51-000-75-00-7507 HYDRANT REPLACEMENT $ $ $ 110.39 $ $ $ $ $ $ 950.00 $ $ 1,060.39 $ 6,000.00 51-000-75-00-7508 METERS&PART'- $ 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 $ 25,591.58 $ 40,000.00 51-000-75-00-7509 ELECTRICITY MONITOF $ $ 421.81 $ $ $ $ $ $ $ $ $ 421.81 $ 51-000-78-00-9099 BAD DEBI $ $ $ $ $ $ $ $ $ $ $ $ 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,055.56 $ 8,452.20 $ 264,426.35 $ 9,032.45 $ 269,787.32 $ $ $ 1,512,709.84 $ 1,351,050.00 TOTAL WATER OPERATIONS EXPENSES $ 36,154.59 $ 62,801.55 $ 111,816.43 $ 99,349.58 $ 73,994.59 $ 121,377.49 $ 91,953.02 $ 100,680.36 $ 90,854.79 $ 84,432.73 $ $ $ 873,445.13 $ 1,265,620.00 FUND -,SURPLUS(DEFICIT) $ (29,183.99) $ 239,310.00 $ (102,316.20) $ 231,523.21 $ (64,243.51) $ 183,651.37 $ (83,470.82) $ 163,745.99 $ (81,822.34) $ 185,354.59 $ $ $ 639,264.71 $ 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 $ 18,040.00 $ 4,000.00 $ 3,700.00 $ - $ - $ 85,500.00 $ 190,000.00 51-200-42-00-4250 IMPROVEMENT EXPANSION $ $ 112,450.47 $ 85.34 $ 114,171.19 $ 368.84 $ 112,611.98 $ 168.48 $ 115,327.97 $ 218.16 $ 114,495.07 $ 569,897.50 $ 580,104.00 51-200-46-00-4600 INVESTMENT INCOME $ 54.03 $ 57.36 $ 61.03 $ 53.07 $ 49.44 $ 48.56 $ 31.54 $ 20.61 1$ (4.84) $ $ 370.80 $ 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 $ 229,887.70 $ 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 PRIN( $ $ $ 62,515.08 $ $ $ $ $ $ 62,515.08 $ $ 125,030.16 $ 125,031.00 51-200-66-00-60421EPA L17-1563001NTEF $ $ $ $ $ $ $ $ $ $ $ $ 51-200-66-00-6056 2006A REFUND.INTERES $ $ $ $ $ $ $ $ $ $ - $ $ 51-200-66-00-6057 2006A REFUND.PRINCIPA $ $ 45,653.13 $ $ $ $ $ $ 115,653.13 $ $ $ 161,306.26 $ 161,307.00 51-200-66-00-6058 2002 PRINCIPAL PMT-NC $ 215,000.00 $ $ $ $ $ $ $ $ $ - $ 215,000.00 $ 215,000.00 51-200-66-00-6059 2007A REFUNDING P&I F $ $ 62,133.13 $ $ $ $ $ $ $ $ $ 62,133.13 $ 51-200-66-00-6072 2005C INTEREST PMT-$: $ - $ - $ $ $ $ $ - $ $ - $ - $ - $ 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 $ $ $ 655,768.30 $ 771,304.00 TOTAL WATER IMPROVEMENT EXPENSES $ 254,563.77 $ 150,950.03 $ 85,503.85 $ 22,988.77 $ 22,988.77 $ 22,988.77 $ 39,563.77 $ 263,991.90 $ 85,503.85 $ 22,988.77 $ $ $ 972,032.25 $ 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 $ $ $ (316,263.95) $ (85,753.00) COMBINED WATER IMPROVEMENT&OPERATIONS FUNDS TOTAL FUND REVENUESl$ 27,094.63 1$ 428,639.38 1$ 19,966.60 1$ 451,457.05 1$ 19,189.36 1$ 435,759.40 1$ 12,682.22 1$ 383,474.93 1$ 9,245.77 1$ 384,282.39 1$ $ $ 2,168,478.14 $ 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,421.50 $ $ $ 1,845,477.38 $ 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,112.87)1$ 276,860.89 1$ 1$ 1$ 323,000.76 1 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 $ 608,455.79 $ 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) $ 3,400.00 $ 25,000.00 52-000-44-00-4417 REIMBURSEMENT-' $ 3,379.48 $ $ $ 3,379.48 52-000-44-00-4498 RECAPTURE $ $ $ $ $ $ $ $ $ $ $ $ 52-000-44-00-4499 BAD DEBT RECOVERY $ $ $ $ $ $ $ $ $ $ $ $ 52-000-46-00-4600 INVESTMENT INCOME $ 45.40 $ 133.06 $ 331.98 $ 192.14 $ 170.95 $ 318.84 $ 86.56 $ 78.78 $ 43.45 $ 37.71 $ 1,438.87 $ 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 $ 193,800.12 $ 256,296.00 52-000-50-00-5137 SALARIES-OVERTIME $ $ $ $ $ 241.50 $ 85.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 $ 3,113.23 $ 4,500.00 52-000-62-00-5408 MAINTENANCE-EQUIPMENT l$ 123.89 $ $ $ 149.41 $ $ 34.99 $ $ 323.89 $ 191.25 $ $ 823.43 $ 5000.00 8 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/3-9-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-SO June-10 July-10 August-30 September-10 October-10 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 52-000-62-00-5409 MAINTENANCE-VEHICLES $ $ 20.00 $ 20.00 $ 19.40 $ $ $ 390.50 $ 2,986.75 $ 39.86 $ 75.29 $ 3,551.80 $ 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 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 $ 1,344.71 $ 2,500.00 52-000-62-00-5422 LIFT STATION MAINTENP $ $ 310.50 $ $ 777.30 $ 37.88 $ 636.73 $ 1,647.63 $ 5.98 $ 4.09-.$ 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 $ 13,739.38 $ 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 $ 1,076.18 $ 1,800.00 52-000-64-00-5604 TRAINING&CONFERENCE $ $ $ $ $ $ $ $ $ $ $ $ 500.00 52-000-64-00-5605 TRAVEL/MEALS/LODGING $ $ $ $ $ $ $ $ $ $ $ $ 500.00 52-000-65-00-5800 CONTINGENCIES $ $ $ $ $ $ $ $ $ $ $ $ 52-000-65-00-5802 OFFICE SUPPLIES $ $ $ 129.29 $ $ $ 7.98 $ (118.83) $ $ 287.77 $ $ 306.21 $ 1,800.00 52-000-65-00-5804 OPERATING SUPPLIES $ $ $ 19.07 $ $ $ 23.10 $ $ $ $ $ 42.17 $ 52-000-65-00-5805 SHOP SUPPLIES $ $ 268.20 $ 313.31 $ 273.95 $ 49.68 $ 168.03 $ 148.82 $ 239.34 $ 32.99 $ $ 1,494.32 $ 2,500.00 52-000-65-00-5812 GASOLINE $ $ 399.91 $ 3,077.09 $ 2,722.03 $ 2,885.28 $ 1,120.81 $ 1,893.89 $ 1,969.37 $ 2,495.73 $ 2,993.38 $ 19,557.49 $ 26,000.00 52-000-65-00-5815 HAND TOOL' $ $ $ $ $ $ $ $ $ $ $ $ 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 $ 17,861.10 $ 21,949.00 52-000-72-00-6501 SOCIAL SECURITY&MEC $ 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 $ 14,187.61 $ 20,230.00 52-000-75-00-7002 COMPUTER EQUIP&SOFT $ $ $ $ $ $ $ $ $ $ $ $ 1,000.00 52-000-75-00-7003 OFFICE EQUIPMENI $ $ $ - $ $ $ 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 DEBI $ $ 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)-$ $ $ 616,912.11 $ 606,800.00 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 $ $ $ 358,591.52 $ 509,620.00 FUND SURPLUS(DEFICIT) $ 93,650.42 $ 88,284.52 $ (45,208.37) $ 385,353.24 $ (17,100.09) $ 66,192.67 $ (26,855.76) $ 84,840.58 $ 130,468.53 $ (501,305.15) $ $ $ 258,320.59 $ 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 $ $ $ 32,600.00 $ 175,000.00 52-200-46-00-4600 INVESTMENT INCOME $ $ $ $ $ $ $ $ $ $ $ $ 52-200-48-00-4803 ROB ROY CREEK REVENUE n/a n/a n/a n/a n/a $ $ $ $ 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 RECAPI $ $ $ $ $ $ $ $ $ $ $ $ 52-200-62-00-5463 LENNAR SEWER RECAPTUF $ $ $ $ $ $ $ 30,996.00 $ $ $ $ 30,996.00 $ 52-200-66-00-6003 2003A IRBB INTEREST F $ $ $ 36,826.25 $ $ $ $ $ $ 126,826.25 $ - $ 163,652.50 $ 163,653.00 52-200-66-00-6004 2003A IRBB PRINC.PMl $ $ $ $ $ $ $ $ $ $ $ $ 52-200-66-00-6008 20048 PRINCIPAL PMT-C $ 51,650.00 $ $ $ $ $ $ $ 206,650.00 $ $ - $ 258,300.00 $ 258,300.00 52-200-66-00-60112004A PRINCIPAL PMT-C $ $ 14,286.25 $ $ $ $ $ $ 174,286.25 $ $ $ 188,572.50 $ 188,572.00 52-200-66-00-6016 2005D INTEREST PMT-RC $ $ 192,975.00 $ $ $ $ $ $ 192,975.00 $ $ - $ 385,950.00 $ 537,541.00 52-200-66-00-6017 2005C 2M ALT RE% $ $ 20,175.00 $ $ $ $ $ $ $ $ $ 20,175.00 $ 82,850.00 52-200-66-00-6018 DEBT SERVICE. $ 55,045.00 $ $ $ 55,045.00 $ $ $ 110,090.00 52-200-66-00-60501EPA LOAN L17-01300( $ $ $ 19,489.99 $ $ $ $ $ $ 19,489.99 $ $ 38,979.98 $ 38,980.00 52-200-66-00-60551EPA LOAN L17-11530( $ $ $ - $ 53,525.35 $ - $ $ - $ $ - $ 53,525.35 $ 107,050.70 $ 107,051.00 52-200-66-00-60592007A BONC $ - $ $ $ - $ - $ - $ $ 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 $ $ $ $ 730,600.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 $ (28,996.00) $ (699,289.38) $ 551,683.76 $ (53,525.35) $ $ $ (645,299.81) $ (1,235,813.00) COMBINED SEWER IMPROVEMENT&OPERATIONS FUNDS TOTAL FUND REVENUESl$ 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) $ i$ 11$ 1,347,512.11 $ 881,800.00 TOTAL FUND EXPENSES $ 72,959.61 $ 316,860.90 $ 102,526.83 $ 90,868.80 $ 17,754.63 $ 54,782.71 $ 57,360.19 $ 743,014.34 $ 194,031.20 $ 84,332.12 $ $ $ 1,734,491.33 $ 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) $ 1$ 11$ (386,979.22) $ (1,138,633.00) LAND CASH REVENUES 72-000-47-00-47000SLAD GRANT-PRAIRIE $ $ $ $ $ - $ $ $ $ $ - $ $ 72-000-47-00-4701 GREENBRIAF $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4702 BIKE PATH GRANI $ $ $ $ $ $ $ $ $ $ - $ $ 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 WOODWORTF $ $ $ $ $ $ $ $ $ $ - $ $ 72-000-47-00-4715 WHITE OAK UNIT 1&: $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4716 WHITE OAK UNIT 3&z $ $ $ $ $ $ $ $ $ $ - $ $ 9 o 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/3-9-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-SO June-10 July-10 August-30 September-10 October-10 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 72-000-47-00-4717 KYLN'S CROSSINC $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4718 FOXFIELD II PARK $ - $ $ $ $ $ $ $ $ $ - $ $ - 72-000-47-00-4719 WILDWOOC $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4722 KYLN'S RIDGE $ $ $ $ $ $ $ $ $ $ - $ $ 72-000-47-00-4723 HEARTLAND CIRCLE $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4725 WINDETTE RIDGE $ $ $ $ $ $ $ $ $ $ - $ $ 72-000-47-00-4727 GRAND RESERVE $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4731 MONTALBANO HOME' $ $ $ $ $ $ $ $ $ $ - $ $ 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 BRIARWOOC $ $ $ $ $ $ $ $ $ $ - $ $ 72-000-47-00-4737 CALEDONIA $ $ $ $ $ $ $ $ $ $ $ $ 38,000 72-000-47-00-4738 AUTUMN CREEK $ 2,051.14 $ 2,051.14 $ $ 2,051.14 $ 4,102.28 $ 6,153.42 $ $ $ $ - $ 16,409.12 $ 22,000 72-000-47-00-4739 WYNSTONE TOWNHOME! $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4740 VILLAS AT THE PRESEM $ $ $ $ $ $ $ $ $ $ - $ $ 72-000-47-00-4741 BAILEY MEADOWS $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4742 BLACKBERRY WOOD' $ - $ $ $ $ $ $ $ $ $ - $ $ 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 WESTBURI $ $ $ $ $ $ $ $ $ $ - $ $ 72-000-47-00-4747 WESTHAVEN $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4748 WILLMAN $ $ $ $ $ $ $ $ $ $ - $ $ 72-000-47-00-4749 BLACKBERRY WOODS $ $ $ 568.18 $ $ $ $ $ $ $ $ 568.18 $ 72-000-47-00-4750 KENDALLWOOD ESTATE! $ $ $ $ $ $ $ $ $ $ - $ $ - 72-000-47-00-4751 CANNONBALL RIDGE PARK $ $ $ $ $ $ $ $ $ $ $ $ 72-000-47-00-4752 BRISTOL BAY LAND CASK $ $ $ 100,000.00 $ $ $ $ $ $ $ - $ 100,000.00 $ LAND CASH EXPENSES 72-000-75-00-7308 RIVERS EDGE PARK#e dl $ $ $ $ $ $ $ $ $ $ - $ $ 72-000-75-00-7317 HEARTLAND CIRCLE $ $ $ $ $ $ $ $ $ $ $ $ 72-000-75-00-7326 MOSIER HOLDING CO $ $ $ $ $ $ $ 10,000.00 $ $ $ - $ 10,000.00 $ 10,000 72-000-75-00-7327 GRANDE RESERVE PAR $ $ $ $ $ $ $ $ $ $ $ $ 72-000-75-00-7328 PRAIRIE MEADOWS(M $ - $ $ $ $ $ $ $ $ $ - $ $ 72-000-75-00-7330 WHISPERING MEADO $ $ $ $ $ $ $ $ $ $ $ $ 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 CO $ $ $ $ $ $ $ $ $ $ - $ $ 72-000-75-00-7335 GRANDE RESERVE BIK $ $ $ $ $ $ $ $ $ $ $ $ 72-000-75-00-7336 WHEATON WOODS N $ $ $ $ $ $ $ $ 2,118.00 $ 15.42 $ - $ 2,133.42 $ 72-000-75-00-7337 BRISTOL BAY PARKA $ $ $ 662.51 $ 25,556.64 $ 54,892.70 $ 2,401.00 $ $ $ $ $ 83,512.85 $ 100,000 72-000-75-00-7339 BRISTOL BAY REGION $ - $ $ 1,420.00 $ 12,599.63 $ - $ 14,019.63 72-000-99-00-9901 TRANSFER TO GENERA $ - $ - $ 15,112.25 $ - $ - $ 15,112.25 $ - $ $ 15,112.25 $ $ 45,336.75 $ 60,449 TOTAL FUND $ 2,051.14 $ 2,051.14 $ 100,568.18 $ 21051.14 $ 4,102.28 $ 6,153.42 $ $ 671.00 $ $ $ $ $ 117,648.30 $ 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) $ $ 11$ (65,354.35) $ (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 $ 147,767.47 $ 225,000 79-000-42-00-4280 CONCESSIONS/ALL SALE $ 6,938.75 $ 10,307.76 $ 10,687.00 $ 709.50 $ 886.50 $ 174.50 $ 61.00 $ $ $ $ 29,765.01 $ 30,000 79-000-42-00-4285 VENDING MACHINE INCOM $ $ $ $ $ $ $ $ $ $ $ $ 79-000-42-00-4286 RENTAL INCOME $ $ $ $ $ $ $ $ $ $ - $ $ 79-000-42-00-4287 PARK RENTAL INCOME $ 2,985.00 $ 3,060.50 $ 2,735.00 $ $ 505.00 $ 200.00 $ $ 450.00 $ $ $ 9,935.50 $ 15,000 79-000-42-00-4288 GOLF OUTING REVENUE $ $ $ $ $ $ $ $ $ $ - $ $ 9,000 79-000-42-00-4291 HOMETOWN DAY'- $ 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 $ 4,957.00 $ 14,000 79-000-44-00-4404 TREE DONATION'- $ $ $ $ $ 350.00 $ 350.00 $ 225.00 $ $ $ $ 925.00 $ 600 79-000-44-00-4412 INSURANCE REIMBURSEMENT'- $ 5,156.53 $ 2,172.90 $ 7,329.43 $ 79-000-44-00-4490 MISCELLANEOUS INCOME $ $ $ $ 79-000-45-00-4550 YOUTH SERVICES GRANI $ $ $ $ $ $ $ $ $ $ $ $ 500 79-000-46-00-4600 INVESTMENT INCOME $ 13.11 $ 22.97 $ 27.95 $ 32.92 $ 26.80 $ 31.17 $ 28.11 $ 23.32 $ 25.48 $ 20.43 $ 252.26 $ 500 79-000-49-00-4901 TRANSFER FROM GENERAI $ 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 $ 359,145.00 $ 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 $ 434,096.60 $ 520,916 TOTAL PARKS&RECREATION REVENUESl$ 201,828.52 1$ 132,799.89 1$ 116,600.111$ 102,348.58 1$ 192,153.36 1$ 113,629.33 1$ 96,986.07 1$ 86,256.23 1$ 90,377.59 1$ 95,985.49 1$ $ $ 1,228,965.17 $ 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 1$ 26,755.92 $ 287,884.29 $ 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 10 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/3-9-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-SO July-10 August-30 September-10 October-10 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 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-EQUIPMENI $ 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 $ 13,996.66 $ 14,000 79-610-62-00-5417 MAINTENANCE-PARKS $ $ 631.59 $ 365.03 $ 11,331.12 $ 181.95 $ 468.16 $ 446.38 $ 1,180.00 $ 235.92 $ $ 14,540.45 $ 34,000 79-610-62-00-5421 WEARING APPAREL $ 83.23 $ 174.93 $ 284.99 $ 131.19 $ 186.75 $ 295.48 $ 124.20 $ 456.10 $ 639.18 $ 231.75 $ 2,607.80 $ 4,100 79-610-62-00-5434 RENTAL-EQUIPMENI $ $ $ 145.50 $ $ $ $ $ $ $ 39.60 $ 158.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 $ 1,350.02 $ 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 $ 35.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 $ 8,745.25 $ 20,000 79-610-65-00-5815 HAND TOOL' $ $ $ 39.95 $ 143.96 $ $ 22.97 $ 173.86 $ $ $ 302.92 $ 683.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 $ 26,500.80 $ 33,953 79-610-72-00-6501 SOCIAL SECURITY/ME51C $ 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 $ 22,491.60 $ 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(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 $ $ $ 399,270.12 $ 524,712.00 RECREATION EXPENSES(FUND 79) 79-650-50-00-5107 SALARIES-RECREATION $ 21,089.02 $ 22,463.98 $ 19,587.13 $ 29,350.73 $ 9,793.57 $ 27,635.15 $ 20,337.14 $ 34,201.94 $ 19,557.16 $ 13,788.56 $ 217,864.35 $ 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 $ 16,248.21 $ 20,000 79-650-50-00-5136 SALARIES-PART TIME $ 1,250.00 $ 1,250.00 $ 1,250.00 $ 1,875.00 $ 625.00 $ 1,782.88 $ 249.38 $ 238.88 $ 416.25 $ 993.00 $ 9,930.39 $ 22,080 79-650-50-00-5137 SALARIES-OVERTIME $ $ $ $ $ $ $ $ $ $ $ $ 300 79-650-50-00-5150 SALARIES-INSTRUCTOR $ 1,087.50 $ 1,839.51 $ 2,372.75 $ 2,714.89 $ 2,267.75 $ 3,603.02 $ 2,429.79 $ 540.26 $ 794.69 $ 1,680.63 $ 19,330.79 $ 16,000 79-650-50-00-5155 SALARIES-RECORDING S $ $ 227.51 $ 237.50 $ $ 280.58 $ 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 $ 33,244.59 $ 50,000 79-650-62-00-5405 MAINTENANCE SUPPLIES $ $ 77.04 $ 62.70 $ $ 104.11 $ $ 69.03 $ 99.50 $ $ $ 412.38 $ 2,000 79-650-62-00-5409 MAINTENANCE-VEHICLES $ $ $ 809.41 $ 49.32 $ 351.01 $ 93.00 $ $ $ 84.49 $ $ 1,387.23 $ 1,000 79-650-62-00-5410 MAINTENANCE-OFFICE EC $ - $ 250.24 $ 242.18 $ 239.48 $ 178.00 $ 178.00 $ 283.97 $ 185.26 $ 216.27 $ 216.27 $ 1,992.67 $ 3,500 79-650-62-00-5426 YOUTH SERVICES GRANI $ $ $ $ $ $ $ $ $ $ $ $ 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 $ 16,377.87 $ 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 $ 2,703.32 $ 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 $ 1,475.44 $ 3,000 79-650-62-00-5445 PORTABLE TOILET'- $ $ 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 PUBLISH I NG/ADVERTISI N $ $ $ $ 5,196.71 $ $ 2,500.00 $ $ 5,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 $ $ $ $ $ $ $ $ $ $ $ $ 79-650-65-00-5802 OFFICE SUPPLIES $ $ 12.49 $ 35.87 $ 563.61 $ $ 797.73 $ 273.56 $ 27.45 $ 137.80 $ 70.17 $ 1,918.68 $ 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 $ 44,733.93 $ 53,600 79-650-65-00-5804 OPERATING SUPPLIES $ $ 7.47 $ $ 163.33 $ $ 1.47 $ $ 13.47 $ 12.70 $ $ 198.44 $ 1,000 79-650-65-00-5805 RECREATION EQUIPMENI $ $ $ $ $ $ $ $ $ $ $ $ 2,000 79-650-65-00-5808 POSTAGE&SHIPPING $ 800.00 $ $ 1,173.00 $ 800.00 $ $ 177.00 $ 1,796.00 $ $ 177.00 $ 110.48 $ 5,033.48 $ 8,000 79-650-65-00-5812 GASOLINE $ $ 137.64 $ 286.71 $ 273.75 $ 288.32 $ 154.97 $ 112.64 $ 75.23 $ 117.95 $ 37.91 $ 1,485.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 $ 11,798.44 $ 18,000 79-650-65-00-5833 HOMETOWN DAYS EXPENSE $ $ 34.37 $ 48,295.00 $ 6,933.00 $ 37,296.09 $ 6,989.07 $ $ $ 355.30 $ $ 99,902.83 $ 100,000 79-650-65-00-5840 SCHOLARSHIPS $ $ $ 150.00 $ $ $ 71.00 $ $ $ $ $ 221.00 $ 1,000 79-650-65-00-5841 PROGRAM REFUNC $ 346.00 $ 270.00 $ 619.00 $ 417.00 $ 195.00 $ 432.00 $ 132.00 $ 195.00 $ 153.00 $ 115.00 $ 2,877.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 $ 20,887.82 $ 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,580.12 $ 1,699.42 $ 1,391.16 $ 20,538.76 $ 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 $ $ $ 565,509.33 $ 937,200.00 TOTAL FUND REVENUES1$ 201,828.52 $ 132,799.89 $ 116,600.11 $ 102,348.58 $ 192,153.36 $ 113,629.33 $ 96,986.07 $ 86,256.23 $ 90,377.59 $ 95,985.49 $ $ $ 1,228,965.17 $ 1,479,990.00 TOTAL FUND EXPENSESE$ 76,834.75 1$ 85,711.83 1$ 137,445.84 1$ 149,898.03 1$ 81,779.53 1$ 118,120.48 1$ 71,669.70 1$ 98,930.89 1$ 81,072.42 1$ 63,315.98 1$ $ $ 964,779.45 $ 1,461,912.00 FUND SURPLUS(DEFICIT) $ 124,993.77 $ 47,088.06 1$ (20,845.73) $ (47,549.45)1$ 110,373.83 1$ (4,491.15)1$ 25,316.37 1$ (12,674.66)1$ 9,305.17 1$ 32,669.51 1$ $ $ 264,185.72 $ 18,078.00 REC CENTER REVENUES F00-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,537.00 $ 338,258.87 $ 410,000 00-42-00-4210 GUEST FEES $ 356.00 $ 506.00 $ 411.00 $ 423.00 $ 335.00 $ 214.00 $ 480.00 $ 751.00 $ 620.00 $ 913.55 $ 5,009.55 $ 3,500 11 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/3-9-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-10 July-10 August-30 September-10 October-10 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 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 $ 23,325.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 $ 7,544.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 $ 1,242.00 $ 2,500 80-000-42-00-4270 FEES FOR PROGRAMS $ 8,902.00 $ 7,102.50 $ 4,153.50 $ 20,256.00 $ 12,368.00 $ 12,155.70 $ 9,058.00 $ 9,387.50 $ 14,360.44 $ 11,894.10 $ 109,697.74 $ 125,000 80-000-42-00-4280 CONCESSIONS $ 1,126.75 $ 1,903.75 $ 1,443.00 $ 900.75 $ 923.75 $ 988.25 $ 1,034.50 $ 1,177.50 $ 1,373.75 $ 1,107.00 $ 11,979.00 $ 12,000 80-000-42-00-4286 RENTAL INCOME $ 401.00 $ 70.00 $ 14.00 $ 359.50 $ 1,278.25 $ 209.00 $ 593.00 $ 285.50 $ 2,058.00 $ 169.00 $ 5,467.25 $ 3,000 80-000-42-00-4295 295 MISC RETAIL - $ $ 209.50 $ 77.00 $ 78.00 $ 46.00 $ 26.50 $ 111.45 $ 781.50 $ 1,329.95 $ 500 RS 80-000-44-00-4400 DONATIONS/SPONSOHIF $ $ 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 1$ $ $ $ $ $ $ $ $ $ $ 500 TOTAL REC CENTER REVENUESI$ 43,862.75 1$ 52,473.32 1$ 42,500.00 1$ 54,468.75 1$ 49,273.00 1$ 46,040.95 1$ 49,177.25 1$ 49,478.00 $ 61,449.44 $ 58,227.20 $ $ $ 506,900.66 $ 609,000.00 REC CENTER EXPENSES 80-000-50-00-5107 SALARIES-REC CENTEF $ 2,630.78 $ 2,630.77 $ 2,630.77 $ 3,946.14 $ 1,315.39 $ 3,946.14 $ 1,973.08 $ 2,630.77 $ 2,630.78 $ 2,630.77 $ 26,965.39 $ 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 $ 25,079.43 $ 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 $ 77,473.24 $ 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 $ 46,370.97 $ 65,000 80-000-62-00-5401 CONTRACTUAL SERVICES $ $ $ $ 8,595.00 $ $ 3,263.00 $ 1,187.20 $ $ 3,755.50 $ 1,302.50 $ 15,403.20 $ 15,000 80-000-62-00-5408 MAINTENANCE-SUPPLIES $ 378.15 $ 640.50 $ 838.95 $ 1,688.12 $ 926.01 $ 566.74 $ 837.68 $ 453.76 $ 1,420.44 $ 259.55 $ 8,009.90 $ 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.59 $ 2,525.16 $ 4,500 80-000-62-00-5416 MAINTENANCE-GENERAI $ 2,034.01 $ 133.49 $ 391.11 $ 1,604.69 $ 659.91 $ 89.80 $ 330.72 $ 892.33 $ 1,211.06 $ 539.32 $ 7,886.44 $ 16,000 80-000-62-00-5426 GRANTS $ $ $ $ $ $ $ $ $ $ $ $ 500 80-000-62-00-5430 TOWEL RENTAI $ 523.12 $ $ $ $ 561.96 $ $ $ 225.13 $ $ $ 1,310.21 $ 1,500 80-000-62-00-5431 POOL REPAIR $ 189.50 $ 434.37 $ 95.00 $ 55.50 $ 1,988.31 $ 793.10 $ 380.00 $ 184.97 $ 190.00 $ $ 4,313.75 $ 5,000 80-000-62-00-5432 LEASE PAYMENI $ 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 $ 197,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.15 $ 4,110.90 $ 5,595.86 $ 5,334.79 $ 3,239.22 $ 3,065.76 $ 2,581.87 $ 2,992.54 $ 3,223.34 $ 33,749.46 $ 25,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 $ 2,752.51 $ 1,750 80-000-62-00-5435 CELLULAR PHONE $ $ 29.08 $ 32.17 $ 30.59 $ 33.58 $ 28.92 $ 25.28 $ 29.86 $ 25.02 $ 32.50 $ 270.00 $ 600 80-000-62-00-5439 PROPERTY TAA $ 26,839.85 $ $ 26,839.85 $ $ $ $ $ $ $ $ 53,679.70 $ 53,000 80-000-62-00-5440 SECURITY $ $ 60.00 $ $ $ 60.00 $ $ $ 60.00 $ $ $ 150.00 $ 500 80-000-62-00-5603 PUBLISH ING/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 $ 14,907.06 $ 17,000 80-000-65-00-5804 OPERATING SUPPLIES $ $ 54.00 $ 42.79 $ 201.59 $ $ 399.00 $ 91.71 $ $ $ 112.48 $ 931.57 $ 3,000 80-000-65-00-5805 RECREATION EQUIPMENI $ $ $ 61.51 $ $ $ 60.00 $ $ $ 5,198.09 $ $ 5,319.60 $ 6,000 80-000-65-00-5805 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 $ 7,935.84 $ 6,000 80-000-65-00-5840 SCHOLARSHIPS $ $ $ 17.50 $ $ $ 371.00 $ $ $ $ $ 358.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 $ 6,042.50 $ 4,000 80-000-65-00-5842 MEMBERSHIP REFUNDS $ $ 103.00 $ 85.00 $ 149.00 $ 65.00 $ 55.00 $ 35.00 $ $ 122.00 $ 295.00 $ 915.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 $ 8,855.06 $ 10,000 80-000-72-00-6501 SOCIAL SECURITY $ 1,292.76 $ 1,117.75 $ 1,089.80 $ 1,532.52 $ 610.50 $ 2,063.76 $ 1,429.38 $ 1,397.83 $ 1,322.71 $ 1,411.92 $ 13,568.93 $ 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 SYSTEN $ $ $ $ $ $ $ $ $ $ $ $ 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 $ 9,067.25 $ 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 $ $ $ 585,161.67 $ 675,301.00 TOTAL FUND REVENUES1$ 43,862.75 1$ 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,227.20 $ $ $ 506,900.66 $ 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 1$ 61,227.79 1$ 51,104.56 1$ 46,058.35 1$ 60,036.46 1$ 50,983.56 1$ $ $ 585,161.67 1$ 675,301.00 FUND SURPLUS(DEFICIT) $ (42,304.28)1$ 5,441.17 1$ (28,110.29) $ (25,972.32)l$ 7,721.59 1$ (15,186.84) $ (1,927.31)1$ 3,419.65 1$ 1,412.98 1$ 7,243.64 1$ 1$ 11$ (78,261.01) $ (66,301.00) LIBRARY REVENUES 82-000-40-00-3992 LIBRARY BOND PROP.TP $ $ 46,202.10 $ 238,305.04 $ $ 61,763.69 $ 226,847.25 $ 15,972.38 $ $ $ $ 589,090.46 $ 605,924.00 82-000-40-00-4000 REAL ESTATE TAXES $ $ 49,561.68 $ 255,633.39 $ $ 66,254.82 $ 243,342.45 $ 17,133.81 $ 31,174.58 $ $ $ 663,100.73 $ 650,000.00 82-000-40-00-4010 PERSONAL PROPERTY TA) $ 923.01 $ 646.74 $ 656.91 $ 86.26 $ $ 1,265.56 $ $ 1,020.86 $ 523.16 $ $ 5,122.50 $ 5,000.00 82-000-42-00-4211 DEVELOPMENT FEES-BL $ 2,125.00 $ $ $ $ 2,525.00 $ $ 3,425.00 $ $ $ 750.00 $ 8,825.00 $ 20,000.00 82-000-42-00-4215 DEVELOPMENT FEES-BC $ 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 $ 2,819.35 $ 3,000.00 82-000-42-00-4261 LIBRARY SUBSCRIPTION $ 1,502.00 $ 1,204.00 $ 753.50 $ 1,050.00 $ 1,200.00 $ 1,071.00 $ 902.00 $ 350.00 $ 1,500.00 $ 1,650.00 $ 11,182.50 $ 15,000.00 52-000-42-00-4262 EXAM PROCTORING $ $ $ $ $ $ 5.00 $ $ $ 35.00 $ $ 40.00 $ 12 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/3-9-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-SO June-10 July-10 August-30 September-10 October-10 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET 82-000-42-00-4286 DVD RENTAL INCOME $ $ $ $ $ 566.00 $ 530.00 $ 532.00 $ 447.00 $ 565.00 $ 527.00 $ 3,167.00 $ 82-000-42-00-4287 LIBRARY BLDG RENTAI $ 270.00 $ 90.00 $ 120.00 $ 120.00 $ 100.00 $ 80.00 $ 50.00 $ $ 150.00 $ 100.00 $ 1,080.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 $ 11,588.01 $ 9,000.00 82-000-44-00-4412 INSURANCE REIMBURSEME $ $ $ $ $ $ $ $ $ $ $ $ 82-000-44-00-4432 SALE OF BOOKS $ 114.00 $ 45.00 $ 42.65 $ 26.00 $ 21.10 $ 12.50 $ $ 34.40 $ 4.50 $ $ 300.15 $ 500.00 82-000-44-00-4450 MEMORIALS $ 90.00 $ 556.00 $ 20.00 $ 500.00 $ 25.00 $ 115.00 $ 405.00 $ 42.48 $ $ 80.00 $ 1,833.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.95 $ 138.27 $ 95.19 $ 30.12 $ 33.33 $ 47.25 $ 40.53 $ 26.27 1$ 21.12 1 $ 653.60 1$ 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 $ $ $ 1,324,821.06 $ 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 $ 18,617.36 $ 58,980.12 $ 39,696.85 $ 39,126.52 $ 37,497.76 $ 38,297.52 $ 403,790.21 $ 650,000.00 82-000-50-00-5203 GROUP HEALTH INSURANC $ $ 7,034.94 $ 7,034.94 $ 7,034.94 $ 7,034.94 $ 7,034.94 $ 7,034.94 $ 7,034.94 $ 7,034.94 $ $ 56,279.52 $ 70,000.00 82-000-50-00-5204 GROUP LIFE INSURANCE $ $ 103.35 $ 103.35 $ 103.35 $ 103.35 $ 103.35 $ 103.35 $ 103.35 $ 103.35 $ $ 826.80 $ 2,000.00 82-000-50-00-5205 DENTAL&VISION ASSIS $ $ 513.27 $ 513.27 $ 513.27 $ 513.27 $ 513.27 $ 513.27 $ 513.27 $ 513.27 $ $ 4,106.16 $ 6,000.00 82-000-61-00-5322 BONDING $ $ 1,839.00 $ $ 1,353.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 $ 22,569.11 $ 40,000.00 82-000-62-00-5407 MAINTENANCE-BLDG/JANi $ $ 1,566.92 $ 949.92 $ 3,522.01 $ 651.21 $ 3,444.80 $ 875.00 $ 5,801.73 $ 371.72 $ 1,067.50 $ 18,250.81 $ 30,000.00 82-000-62-00-5410 MAINTENANCE-OFFICE EC $ $ $ $ 176.70 $ 183.97 $ $ 177.77 $ 950.73 $ $ 409.98 $ 1,899.15 $ 20,000.00 82-000-62-00-5412 MAINTENANCE-PHOTOCOP $ $ $ $ 543.77 $ 49.41 $ 124.76 $ 252.39 $ 36.97 $ $ $ 1,007.30 $ 15,000.00 82-000-62-00-5435 ELECTRICITY $ $ $ $ $ $ $ $ $ $ $ $ 8,000.00 82-000-62-00-5436 TELEPHONE $ $ 683.17 $ 693.42 $ 1,316.99 $ 688.81 $ 687.11 $ 866.12 $ 430.73 $ 692.06 $ 702.21 $ 6,760.62 $ 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 $ 5,256.93 $ 40,000.00 82-000-62-00-5438 DATABASE $ $ $ $ $ $ 2,898.42 $ $ $ $ 990.00 $ 3,888.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 $ 6,860.90 $ 15,000.00 82-000-64-00-5604 TRAINING&CONFERENCE $ $ 330.39 $ 13.00 $ $ $ 226.71 $ 30.00 $ 300.00 $ $ $ 900.10 $ 5,000.00 82-000-64-00-5607 PUBLIC RELATIONS $ $ $ $ $ $ $ $ $ $ $ $ 2,000.00 82-000-64-00-5616 EMPLOYEE RECOGNITION $ $ $ $ 43.00 $ 50.00 $ $ $ $ $ $ 93.00 $ 4,000.00 82-000-65-00-5800 CONTINGENCIES $ $ 403.98 $ 531.00 $ $ 377.85 $ 3,052.72 $ 862.07 $ 212.45 $ 525.28 $ 739.99 $ 6,705.34 $ 144,561.00 82-000-65-00-5802 OFFICE SUPPLIES $ $ 822.46 $ 524.66 $ $ 803.84 $ 1,205.34 $ $ $ 533.94 $ 346.53 $ 4,236.77 $ 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 $ 3,497.69 $ 15,000.00 82-000-65-00-5807 CUSTODIAL SUPPLIES $ - $ 850.52 $ 108.69 $ 1,135.87 $ 1,239.32 $ 318.21 $ 783.99 $ 800.20 $ 510.34 $ 879.45 $ 6,626.59 $ 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.56 $ 1,141.19 $ 2,500.00 82-000-65-00-5810 PUBLISHING&ADVERTIE $ $ $ 130.00 $ $ $ $ $ $ $ $ 130.00 $ 2,000.00 82-000-65-00-5826 MILEAGE $ $ $ 59.90 $ $ $ 76.93 $ 205.44 $ 10.59 $ $ 77.26 $ 430.12 $ 1,000.00 82-000-65-00-5832 VIDEOS $ $ 813.87 $ 507.24 $ 317.87 $ 763.61 $ 767.81 $ 584.15 $ 949.59 $ 476.75 $ 822.84 $ 6,003.73 $ 25,000.00 82-000-65-00-5834 LIBRARY PROGRAMMING $ 325.00 $ 1,175.25 $ 879.16 $ 165.37 $ 682.91 $ 218.76 $ 571.70 $ 1,612.63 $ 511.89 $ 504.92 $ 6,647.59 $ 20,000.00 82-000-65-00-5835 LIBRARY BOARD EXPENSE $ $ $ $ $ $ $ $ $ $ $ $ 2,000.00 82-000-65-00-5836 BOOKS-ADULT $ $ 1,634.80 $ 2,831.89 $ 2,226.66 $ 2,972.97 $ 5,080.94 $ 4,037.53 $ 2,657.04 $ 115.27 $ 1,006.80 $ 22,563.90 $ 50,000.00 82-000-65-00-5837 BOOKS-JUVENILE $ $ 3,808.55 $ 3,485.89 $ 3,616.94 $ 3,725.53 $ 2,064.68 $ 3,172.29 $ 8,899.32 $ 5,968.78 $ 3,398.53 $ 38,140.51 $ 50,000.00 82-000-65-00-5838 BOOKS-AUDIO $ $ 842.64 $ 220.93 $ 107.97 $ 1,252.65 $ 795.23 $ 326.92 $ 636.66 $ 574.86 $ 1,494.93 $ 6,252.79 $ 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 $ 8,648.32 $ 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 $ 1,621.89 $ 15,000.00 82-000-65-00-5844 MEETING ROOM $ $ $ $ $ $ $ 800.00 $ $ $ $ 800.00 $ 1,000.00 82-000-66-00-6012 20058 LIBRARY BONE $ $ 159,562.51 $ $ $ $ $ $ 234,562.51 $ $ $ 394,125.02 $ 394,125.00 82-000-66-00-6014 2006 LIBRARY BONE $ $ 30,900.00 $ $ $ $ $ $ 180,900.00 $ $ $ 211,800.00 $ 211,800.00 82-000-72-00-65001MRF PARTICPANTS $ 1,640.00 $ 1,647.30 $ 1,647.30 $ 2,470.95 $ 823.65 $ 2,506.00 $ 1,691.12 $ 1,691.12 $ 1,761.50 $ 1,761.50 $ 17,640.44 $ 22,000.00 82-000-72-00-6501 SOCIAL SECURITY/MEDIC $ 2,974.12 $ 2,825.03 $ 2,775.50 $ 4,323.28 $ 1,398.95 $ 4,461.49 $ 2,986.34 $ 2,942.59 $ 2,818.02 $ 2,879.20 $ 30,384.52 $ 55,000.00 82-000-75-00-7002 COMPUTER EQUIPMENT& $ $ $ 2,820.23 $ $ $ $ 719.50 $ $ $ $ 3,539.73 $ 20,000.00 82-000-75-00-7003 AUTOMATION $ $ 7.20 $ 7.20 $ 3,889.39 $ 869.20 $ 79.40 $ 3,231.59 $ 267.20 $ 33,131.36 $ 3,838.07 $ 45,320.61 $ 40,000.00 82-000-75-00-7703 BUILDING EXPANSION $ $ 6,199.55 $ $ $ $ $ $ $ $ $ 6,199.55 $ TOTAL LIBRARY EXPENSES $ 45,275.26 $ 270,716.80 $ 73,692.41 $ 97,565.50 $ 49,699.25 $ 101,105.05 $ 75,024.66 $ 497,651.36 $ 98,583.90 $ 82,108.36 $ $ $ 1,391,422.55 $ 2,158,986.00 TOTAL FUND REVENUESl$ 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 $ $ $ 1,324,821.06 $ 1,359,924.00 TOTAL FUND EXPENSESS$ 45,275.26 1$ 270,716.80 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$ $ $ 1,391,422.55 $ 2,158,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) $ 1$ 11$ (66,601.49) $ (799,062.00) FOX INDUSTRIAL REVENUES 85-000-40-00-4090 TIF REVENUES $ $ 107,259.49 $ 24,291.75 $ 3,477.93 $ 83,114.33 $ 5,770.68 $ 4,432.29 $ - $ $ - $ 228,346.47 $ 216,677.00 85-000-46-00-4600 INVESTMENT INCOME $ 1.13 $ 1.40 $ 1.47 $ 1.65 $ 1.69 $ 1.74 $ 1.58 $ 1.47 $ 1.36 $ $ 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 BOND-INT PAY N $ - $ $ $ $ $ - $ 4,966.25 $ 4,966.25 $ 85-000-78-00-9007 ADMINISTRATION FEES $ $ 116.25 $ 92.50 $ $ $ $ - $ $ 222.00 1$ 138.75 1 $ 569.50 1$ 500.00 TOTAL FUND REVENUES1$ 1.13 1$ 107,260.89 1$ 24,293.22 1$ 3,479.58 1$ 83,116.02 1$ 5,772.42 1$ 4,433.87 1$ 1.47 1$ 1.36 1$ $ $ $ 228,359.96 1$ 216,727.00 13 of 14 UNITED CITY OF YORKVILLE DETAILED MONTH-BY-MONTH REVENUE AND EXPENSE REPORT FOR YORKVILLE GENERAL FUND DATE OF REPORT/3-9-11 ACTUAL EXPENSES BY MONTH ACCOUNT NUMBER AND DESCRIPTION May-10 June-10 July-10 August-30 September-10 October-10 November-10 December-10 January-11 February-11 March-11 April-11 YEAR-TO-DATE ANNUAL TOTALS BUDGET TOTAL FUND EXPENSES $ 4,966.25 $ 116.25 $ 92.50 $ $ $ $ 74,966.25 $ $ 222.00 $ 138.75 $ $ $ 80,502.00 $ 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) $ (138.75) $ $ $ 147,857.96 $ 136,294.00 COUNTRYSIDE TIF REVENUES 87-000-40-00-4090 TIF REVENUES $ $ 3,058.20 $ 127.42 $ $ 3,153.76 $ 31.86 $ 0.61 $ $ $ - $ 6,371.85 $ 6,250.00 87-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 COUNTRYSIDE TIF EXPENSES 87-000-66-00-6002 COUNTRYSIDE TIF-INTEF $ $ $ $ $ r$ 439.39 $ $ $ $ - $ $ 87-000-66-00-6022 BOND-INT PAYMENT $ 68,546.25 $ $ $ $ $ 238,546.25 $ $ $ $ 307,092.50 $ 307,093.00 87-000-78-00-9007 ADMINISTRATION FEES $ - $ 116.25 $ 92.50 $ $ $ - $ $ $ 138.75 $ 347.50 $ 1,000.00 TOTAL FUND REVENUES $ 498.76 $ 3,557.21 $ 584.02 $ 394.26 $ 3,548.08 $ 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 $ $ $ 307,440.00 $ 308,093.00 FUND SURPLUS(DEFICIT) $ (68,047.49) $ 3,440.96 $ 491.52 $ 394.26 $ 3,548.08 39.39 $ (238,325.43) $ 220.27 $ $ (138.75) $ $ $ (297,977.19) $ (295,739.00) DOWNTOWN TIF REVENUES 88-000-40-00-4090 TIF REVENUES $ - $ 40,820.24 $ 1,720.46 $ 1,758.58 $ 20,840.99 $ 4,567.75 $ 5,653.65 $ - $ - $ 75,361.67 $ 88,550.00 DOWNTOWN TIF EXPENSES 88-000-78-00-9007 ADMINISTRATIVE FEES $ - $ 116.25 $ - $ - $ 500.00 $ - $ - $ 46.25 $ 333.00 $ 995.50 $ 1,500.00 TOTAL FUND REVENUES $ 1$ 40,820.24 1$ 1,720.46 1$ 1,758.58 1$ 20,840.99 1$ 4,567.75 1$ 5,653.65 1$ $ $ $ $ $ 75,361.67 $ 88,550.00 TOTAL FUND EXPENSES $ $ 116.25 $ $ $ 500.00 $ $ $ 46.25 $ $ 333.00 1$ $ $ 995.50 $ 1,500.00 FUND SURPLUS(DEFICIT)§$ $ 40,703.99 $ 1,720.46 $ 1,758.58 $ 20,340.99 $ 4,567.75 1$ 5,653.65 1$ (46.25) $ 1$ (333.00) $ 1$ 11$ 74,366.17 1$ 87,050.00 14 of 14 c/Ty Reviewed By: Agenda Item Number ii J� a 0-0 Legal ❑ NB #2 II Finance ■ EST. , 1836 Engineer ❑ Tracking Number y City Administrator ❑ Consultant ❑ ADM 2011-08 Kend'11 mly El<`E Agenda Item Summary Memo Title: Treasurer's Report for February 2011 Meeting and Date: Administration Committee 3/17/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 February 28,2011 Cash Basis Projected BGn Fund February Revenues %of YTD February Expenses %of YTD Ending Fund Balance Revenues YTD Revenues Budget Budget Expenses YTD Expenses Budget Budget Balance General Fund 01-General (492,939) 990,017 10,049,231 11,433,024 88% 802,861 9,324,661 11,376,981 82% 231,631 Library Fund 82-Library 571,002 5,130 1,324,821 1,359,924 97% 82,108 1,391,423 2,158,986 64% 504,401 Special Revenue Funds 15-Motor Fuel Tax 405,618 39,288 621,454 356,000 175% 140,031 344,694 475,600 72% 682,379 79-Parks and Recreation 25,151 95,985 1,228,965 1,479,990 83% 63,316 964,779 1,461,912 66% 289,337 72-Land Cash (603,425) - 117,648 413,000 28% - 183,003 665,449 28% (668,779) 85-Fox Industrial TIF 423,351 228,360 216,727 105% 139 80,502 80,433 100% 571,209 87-Countryside TIF 2,477,758 9,463 12,354 77% 139 307,440 308,093 100% 2,179,781 88-Downtown TIF 136,294 75,362 88,550 85% 139 996 1,500 66% 210,660 11-Fox Hill SSA 2,226 19,894 19,463 102% - 3,786 3,458 109% 18,335 12-Sunflower SSA 6,188 13,871 13,112 106% 7,530 8,253 91% 12,528 Debt Service Funds 42-Debt Service 7,628 322,953 429,404 75% 429,404 429,404 100% (98,823) Capital Funds 16-Municipal Building (607,724) - 19,950 55,000 36% - - - (587,774) 22-Park and Recreation Capital 66,852 6 1,736 17,500 10% - 17,431 173,135 10% 51,157 20-Police Capital 210,284 1,380 26,336 62,000 42% 95 49,475 104,000 48% 187,145 21-Public Works Capital 157,807 3,841 28,825 35,000 82% 8,421 75,437 139,000 54% 111,195 23-City-Wide Capital (18,378) 97,202 237,689 421,500 56% - 297,104 582,500 51% (77,793) Enterprise Funds 51-Water 339,360 384,282 2,168,478 2,122,354 102% 107,422 1,845,477 2,122,677 87% 662,361 52-Sewer 2,735,211 (470,498) 1,347,512 881,800 153% 84,332 1,734,491 2,020,433 86% 2,348,232 80-Recreation Center (127,815) 58,227 506,901 609,000 83% 50,984 585,162 675,301 87% (206,076) Total Funds 5,714,449 1,204,861 18,349,449 20,025,702 1,339,986 17,642,794 22,787,1 t5 6,421,104 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 J� a O� Legal ❑ Finance ■ NB #3 EST. , 1836 Engineer ❑ 4O y City Administrator Tracking Number Police ❑ `��, Human Resources ❑ ADM 2011-09 <E Public Works ❑ City Council Agenda Item Summary Memo Title: Purchase Order Policy Revision Meeting and Date: Administration Committee 3/17/11 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Majority Council Action Requested: Discussion and approval Submitted by: Rob Fredrickson Finance Name Department Agenda Item Notes: Please see attached information. Red-Lined Version 1-7-3: CONTRACTS AND PURCHASES': A. Definitions: The expression "lowest responsible bidder", as used in this section and in the city's bidding documents, shall be deemed to mean the lowest bidder whose offer best represents in quality, fitness and capacity the requirements of the proposed work or usage. (Ord. 1975-8, 6- 26-1975) B. Bids For All Contracts For Services Of Materials Over Twenty Thousand Dollars: 1. Advertising For Bids: Except as otherwise provided herein, all contracts of whatever nature for labor, services or work, and for the purchase or lease of materials or supplies involving amounts in excess of twenty thousand dollars ($20,000.00)made by or on behalf of the city shall be let to the lowest responsible bidder following notice as required in the following subsections: a. Notice shall be published in a newspaper of general circulation throughout the city at least once which publication shall be at least fifteen (15) days prior to the time designated for opening bids. The notice shall include a general description of the article or service desired, shall state the time, date and place of bid opening, and shall designate where bidding documents may be obtained. b. All purchases or contracts to be let shall be noticed by posting on the public bulletin board in the city hall. 2. Bidding Procedures: a. Bidder's Security: All bids must be sealed and, in the case of contracts for construction of municipal buildings or facilities or for labor, shall be accompanied by security, either cash, cashier's check, certified check or surety bond, in a sum equal to ten percent(10%) of the total aggregate of the bid. The successful bidder shall forfeit his bid security upon such bidder's failure or refusal to execute the contract within the time designated in the bid documents. The city council, in such event,may award the contract to the new lowest responsible bidder. b. Other Bond Requirements: A faithful performance bond, labor and material bond and other bonds may be required by the city council in amounts reasonably necessary to protect the city's interests in obtaining the services or work involved. If bonds are required, the form and amount thereof shall be designated in the notice inviting bids. c. Bid Opening Procedures: All bids shall be submitted to the city clerk, who shall safeguard them in a sealed condition until the time noticed for public bid opening. At the time and place stated in the public notices, the city clerk or designee shall publicly open all bids. The tabulation of all bids or copies of bids received shall be available for public inspection in the clerk's office for a period of not less than thirteen (13) days after the bid opening. d. Award Of Contracts: (1) Lowest Responsible Bidder: The city council may make an award of contract to the lowest responsible bidder. If considered to be in the best interest of the city, selected portions of the lowest responsible bid may be accepted and award made accordingly. In the alternative, the city council may either reject all bids and readvertise or authorize the city itself to perform the work and directly acquire the items desired in accordance with the immediately following provision. (2) Direct Method: After bids are rejected or if no bids are received, the city council,by resolution and act of majority vote of the council, including the mayor, may authorize the work done by city personnel and equipment or may authorize the purchase of the material and equipment for services involved on the open market without complying with the requirements of this section, provided that the city council reserves competent information or data that the city itself is capable of completing the project involved in a more satisfactory or economical manner or that the materials, equipment or services may be purchased more economically on the open market. e. Tie Bids: If two (2) or more bids are received which are in all respects equal, the contract shall be awarded to the bidder maintaining a place of business in the city. However, if all or none of said bidders maintain a place of business in the city, then the contract shall be awarded by drawing lots. 3. Exemptions From Bidding Requirements: a. Notwithstanding any provisions of this section to the contrary, the competitive bidding procedures and requirements may be dispensed within any of the following instances: (1) When a commodity being purchased is standardized in a manner to be compatible with equipment or articles in existing city use and in order to obtain more function or economic use from such existing equipment or articles, together with such commodity. (2) When in public session, the city council has received competent information, data and sworn testimony supporting the facts that the product or service desired is provided only by one person or firm. (3) The city council may authorize the purchase of materials, supplies, equipment and services or may order work performed by the city upon a finding of support by competent information or data that such purchase or work is urgent and immediately necessary for the preservation of life, health and property. The term "urgent and immediately" as used herein shall be deemed to mean threatening to happen at once, such as an impending danger or calamity. (4) When an agreement involves acquisition of services, equipment or any agreement entered into with another governmental entity. (5) The city may award a renewal or extension of an existing contract or agreement with any supplier or vendor of services, equipment,materials or work performed by or on behalf of the city in the event that the city is satisfied with the past performance of the entity providing said service, equipment or work. In the event the city council wishes to make a renewal or extension of an existing agreement with the city,no competitive bidding shall be required by the city council by a vote of the majority of the aldermen then holding office. Nothing contained herein shall be interpreted to restrict the power of the city to amend the terms of any existing agreement upon renewal or extension thereof so long as the city council passes a resolution approving the terms of any amendment or modification of an existing agreement. (6) The city may award any contract or approve any purchase of materials without advertising for bids if authorized by two-thirds (2/3) of the aldermen then holding office. C. Bids For All Contracts For Services Of Materials Five Thousand Dollars To Nineteen Thousand Nine Hundred Ninety Nine Dollars: 1. Soliciting Quotes: Except as otherwise provided herein, all contracts of whatever nature for labor, services or work, and for the purchase or lease of materials or supplies involving amounts from five thousand dollars ($5,000.00) to nineteen thousand nine hundred ninety nine dollars ($19,999.00) made by or on behalf of the city shall be let to the lowest responsible bidder as required in the following subsections: a. No expenditures for labor, services or work for the purchase or lease of materials or supplies may be made unless the cost thereof was included in the budget of the city department requesting such expenditure. b. Solicitation for quotes shall be in writing to all businesses located within the city boundaries providing such labor, services or work or manufacturing, selling or distributing the materials or supplies which have registered with the city as hereinafter provided and any ethef business knewn to the eity of pr-eviettsly utilized by the eity. c. Signature of department head or their designee n,,fe ^n°& a°r r ,written bids and council approval of the expenditure shall be required. d. For the purpose of soliciting and obtaining quotes, e-mail shall constitute a writing in addition to any other handwritten or typewritten communication. D. Registration Of City Businesses: 1. All businesses located within city boundaries shall have the right,but not the obligation,to register with the city clerk on a form provided by the city clerk, itemizing all of the services or materials provided by such business and stating a contact person, e-mail address or such other method for communication or correspondence as deemed sufficient to permit such business to submit a quote to the city for the provision of services or materials. E. Expenditures Under Five Thousand Dollars: 1. Every contract or purchase involving an expenditure of less than five thousand dollars ($5 000.00 but mere tha � e ti etis a a l ($i nnn nm , ) �� �__�__�__� �__���a__�uv= shall require.a receipt or invoice for such expenditure from the provider or seller�e made by pu-e -a and shall be signed by the department head or their designee. 2. All ex-penditufes under-ene thousand dellafs ($1,000.00) shall fequir-e the approval of the depaAgment head and a r-eeeipt fer-sue-h expeaditufe fiefn the provider-or-seller, (Or-d. 2008 33, 5 13 2098) Ordinance No. 2011- AN ORDINANCE AMENDING THE CODE OF ORDINANCES OF THE UNITED CITY OF YORKVILLE, KENDALL COUNTY, ILLINOIS REGARDING PROCUREMENT OF MATERIALS AND SERVICES WHEREAS, the United City of Yorkville (the "City") is a duly organized and validly existing non-home-rule municipality created in accordance with Article VII, Section 7 of the Constitution of the State of Illinois of 1970; and, WHEREAS, the Mayor and City Council have determined that it is in the best interest of the City to amend Title 1, Chapter 7, Section 3 of the Code of Ordinances regarding procurement of materials and services. NOW THEREFORE, BE IT ORDAINED by the Mayor and City Council of the United City of Yorkville, Kendall County, Illinois, as follows: Section 1. Title 1, Chapter 7, Section 3, Subsection (C)(1)(b)of the United City of Yorkville Code of Ordinances is hereby deleted in its entirety and replaced with the following: b. Solicitation for quotes shall be in writing to all businesses located within the city boundaries providing such labor, services or work or manufacturing, selling or distributing the materials or supplies which have registered with the city as hereinafter provided. Section 2. Title 1, Chapter 7, Section 3, Subsection (C)(1)(c)of the United City of Yorkville Code of Ordinances is hereby deleted in its entirety and replaced with the following: c. Signature of department head or their designee, written bids and council approval of the expenditure shall be required. Section 3. Title 1, Chapter 7, Section 3, Subsection (E)(1) of the United City of Yorkville Code of Ordinances is hereby deleted in its entirety and replaced with the following: 1. Every contract or purchase involving an expenditure of less than five thousand dollars ($5,000.00) shall require a receipt or invoice for such expenditure from the provider or seller and shall be signed by the department head or their designee. Section 4. Title 1, Chapter 7, Section 3, Subsection (E)(2) of the United City of Yorkville Code of Ordinances is hereby deleted in its entirety. Section 2. If any Section, subsection, sentence, clause, phrase or portion of this Chapter is for any reason held invalid or unconstitutional by any court of competent jurisdiction, such portion shall be deemed a separate, distinct, and independent provision, and such holding shall not affect the validity of the remaining portions hereof. Section 3. This Ordinance shall be in full force and effect upon its passage, approval, and publication as provided by law. Passed by the City Council of the United City of Yorkville, Kendall County, Illinois, this day of 2011. CITY CLERK ROBYN SUTCLIFF DIANE TEELING GARY GOLINSKI ARDEN JOSEPH PLOCHER WALTER WERDERICH MARTY MUNNS ROSE ANN SPEARS GEORGE GILSON, JR. Approved by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this day of 2011. MAYOR 2 0 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 ■ °°°�aovsea, O Consultant ❑ Human Resources ADM 2011-10 tKentlall County E ■ Agenda Item Summary Memo Title: Employee Benefits Renewal Meeting and Date: Administration Committee 3/17/11 Synopsis: Renewal for employee health, dental, vision, & life insurance and staff recommendations for plan changes. 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: Memorandum EST � �- 1836 To: Administration Committee O� From: Meghan Ostreko, HR Manager p CC: Bart Olson, City Administrator �dAC­y,? Date: March 11, 2011 -LE Subject: 2011 Employee Benefits Renewal On Thursday, March 10th City Administrator Bart Olson, Finance Director Rob Fredrickson, and I met with Joe Liberty of Better Business Planning to discuss our upcoming benefits renewal for employee health, dental, vision, and life insurance. We are faced with an increase for each benefit, some greater than others. Below is a summary of each benefit and our recommendation for changes (if any). Joe will be at Thursday's meeting to discuss our renewal and answer any questions. Life Insurance—Attachment A Current Carrier: Met Life FY 10/11 Premium: $13,200 (0.25 /$1000 of Life/AD&D) FY 11/12 Premium: $10,560 (0.20/ $1000 of Life/AD&D) 20 % decrease Recommendation: Our recommendation is to continue with Met Life. Not only have they lowered rate,they are also able to provide an Employee Assistance Program(EAP) at no additional cost. A couple of other carriers offered slightly lower rates(0.19/ $1000 of Life/AD&D)but did not offer dependent coverage or EAR Vision Insurance—Attachment B Current Carrier: VSP FY 10/11 Premium: $11,961 FY 11/12 Premium: $13,204 10.4% increase Recommendation: We are recommending switching our vision insurance carrier to EyeMed. The proposed premium from EyeMed is $11,042, a 7.7% decrease from our current VSP rate. EyeMed would lock in this rate for 48 months. There would be no change in the benefit to employees and I have confirmed that EyeMed is an in-network provider at Brenart Eye Clinic, Yorkville Eye Professionals, and Pearle Vision. Dental Insurance—Attachment C Current Carrier: Blue Cross Blue Shield(BCBS) FY 10/11 Premium: $84,678 FY 11/12 Premium: $96,458 13.9% increase Recommendation: We are recommending no change to our dental insurance. While a few other carriers quoted lower premium rates, they also offer a reduced benefit or have a reputation for quoting low rates for the first year only to increase them significantly in subsequent years. Health Insurance—Attachment D Current Carrier: Blue Cross Blue Shield(BCBS) PPO -FY 10/11 Premium: $490,150 (plus —$176,000 in HRA liability) PPO -FY 11/12 Premium: $573,741 (plus $152,000 in HRA liability) 17.1% increase HMO - FY 10/11 Premium: $443,943 HMO - FY 11/12 Premium: $587,515 32.3% increase The large increase in health insurance premiums is due to a couple of factors. First, BCBS looks at the past year's claims to determine their risk for the following year. In the past year there were multiple large claims (over $25,000 each) that have a high probability of being recurring claims. Second, on the HMO side, Advocate Hospitals was added to the HMO network. Advocate is apparently one of the most expensive hospital systems so BCBS is accounting for the potential of increased expenses should members utilize Advocate's services. Recommendation: Our recommendation for health insurance changes is two-fold. First we are recommending that we stay with BCBS (there were no real matches in benefits from other carriers, particularly on the HMO side), but make some minor changes to both the PPO and HMO plans. Second we are recommending some changes in the monthly employee contributions. Both changes are outline further below. Proposed PPO Plan Changes It is our recommendation that we switch our PPO plan from a $2500/$5000 deductible plan to at $3500/$7000 plan. In doing so we would see a premium of$505,037, which is only a 3% increase from our current plan rates. So as not to place the extra burden of a higher deductible on employees, we are also recommending that the HRA spending be increased from$2000/$4000 to $3000/$6000 ($228,000 in HRA liability). While this plan is practically a wash in comparison to the renewal rates of our current plan, it lowers the likelihood that people will meet their deductible, thus lowering BCBS's risk of having to pay out claims. Proposed HMO Plan Changes It is our recommendation that our HMO plan be changed to increase office visit co-pays from$10/$20 (primary care physic ian/specialist) to $20/$40. We are also recommending that the drug card be changed from$15/$30/$50 (generic/formulary brand name/non- formulary brand name) to $10/$40/$60. Making both of these changes would bring the premium to $574,996, a 29.5% increase from our current plan rates. While this may appear burdensome to employees enrolled in the HMO plan, there are a couple of positives to note. First, the Affordable Care Act provides that, as of our renewal, preventative care be covered 100%. This means that there would be no co-pay for things such as immunizations, childhood health screenings, and adult health screenings (a more detailed list is attached—Attachment E). Second, employees would see a decrease in the cost of generic prescriptions with the proposed drug card. Proposed Employee Contributions The current monthly employee contribution rates are listed below: FY 10/11 Employee Cost HMO HMO PPO PPO (PD union) (PD union) Employee $33 $32 $49 $47 Only Employee+ $72 $69 $104 $100 Spouse Employee+ $68 $65 $98 $94 Children Family $90 $87 $153 $147 The rates that we are proposing are in accordance with the police and public works union contracts, which read that the employee's monthly contribution shall be 10% of the premium for either HMO or PPO,up to a maximum of$41 for HMO single coverage, $87 for HMO family coverage, $61.50 for PPO single coverage, and $147 for PPO family coverage. Proposed FY 11/12 Employee Cost HMO HMO HMO PPO PPO PPO Premium (PD union) (PD union) Premium (proposed) (proposed) Employee $467.06 $41 $41 $61.50 $61.50 $658.34 Only Employee+ Spouse $981.64 $87 $87 $135 $135 $1358.18 Employee+ $947.48 $87 $87 $132 $132 $1328.31 Children Family $1462.04 $90 $87 $153 $147 $1778.17 Since full-time employees are split almost equally between non-union and union we are proposing that all employees pay the union rates, with the exception of those non-union employees on family coverage who were already paying slightly higher rates than the union employees. Everyone except for those on family coverage would see an increase in their contribution. T �r5 BETTER PL-A- N-14-1 S S LIFE/AD8�D ANALYSIS N G INC #OF EMPLOYEES COVERED: 88 CURRENT RENEWAL BENEFITAMOUNT: $50,000 $50,000 GUARANTEE ISSUE LIMIT: $50,000 $50,000 DEPENDENT COVERAGE?: YES YES REDUCTION SCHEDULE Benefit at Age 65: $32,500 $32,500 Benefit at Age 70: $25,000 $25,000 Benefit at Age 75: No Further Reduction No Further Reduction Benefit at Age 80: Benefit at Age 85t TOTALVOLUME: $4,400,000 $4,400,000 LIFEIAD&D RATE1$1,00(y 0.250 0.200 DEPENDENT LIFE RATE: MONTHLY PREMIUM: $1,100 Q g8c) ANNUALPREMIUM, $13,200 VARIANCE FROM CURRENT: Not Applicable -i-7-6 010 IRATE GUARANTEE: Not Applicable 12 Months 4 t CARRIERS PENDING: Dearborn National REMINDERS: • PLEASE NOTE THAT THE DEPENDENT LIFE RATE&COST IS NOT FACTORED INTO THE MONTHLY&ANNUAL TOTAL • The LifelAD&D Benefit Amount will be less for those employees at an age where the Reduction Schedule begins,however the above volume only calculates the full benefit amount for all employees regardless of their age. • If the LifelAD&D benefit is based on a multiple of the employee's salary,updates should be reported to the insurance carrier as changes occur or at the plan anniversary. • The premium paid on Benefit amounts in excess of$50,000 may be subject to tax. Please consult your tax advisor. PLEASE NOTE: This benellt summary/comparison contains a general description of certain benefits&quoted costs and does not set forth the procedures,limitations and exclusions or final rates applicable to each policy.This benefit summary/comparison is intended to foster discussion regarding policy highlights and is created for Informational purposes only and is not intended as a substitute for the official plan certificate and booklet B E T T E R L'_� BUSINESS_ VISION ANALYSIS P L A N N I N G INC. EMPLOYEE: 17 EMPLOYEE&SPOUSE: 16 EMPLOYEE&CHILD(REN): 6 FAMILY: 48 TOTAL: 87 ■ vs p- EyeMedt%s CURRENT RENEWAL EXAM COPAY: $10 $10 $10 LENS COPAY: $25 $25 $25 $130 Allowance; $130 Allowance; $130 Allowance; FRAMES BENEFIT: $130 off balance 20%off balance 20%off balance EXAM FREQUENCY: 12 Months 12 Months 12 Months LENS FREQUENCY: 12 Months 12 Months 12 Months FRAMES FREQUENCY: 24 Months 24 Months 24 Months LASER VISION DISCOUNT?:. YES YES YES EMPLOYEE RATE' $5.52 $6.09 $4.59 EMPLOYEE'&SPOUSE RATE: $8.00 $8.84 $8.72 EMPLOYE E'&CHILDREN)RATE; $14.35 $15.84 $9.18 FAMILY RATE: $14.35 $15.84 $13.49 MONTHLY PREMIUM: $997 $1,100 $920 ANNUAL PREMIUM:' $11,961 $13,204 $11,042 VARIANCE FROM CURRENT. Not Applicable 10.4% •7.7% RATE GUARANTEE: ., Not Applicable 24 Months 48 Months REMINDERS: • Some carriers can have awaiting period and/or frequency limit imposed for certain services. PLEASE NOTE: This benefit summary/comparison contains a general description of certain benefits&quoted costs and does not set forth the procedures,limitations and exclusions or final rates applicable to each policy. This benefit summary/comparison is Intended to foster discussion regarding policy highlights and is created for Informational purposes only and Is not intended as a substitute for the official plan certificate and booklet. BETTE R x.-°BUS IN E S_S DENTAL ANALYSIS PLANNING "Ic EMPLOYEE: 17 EMPLOYEE 8 SPOUSE: 16 EMPLOYEE&CHILD(REN): 6 FAMILY: 48 TOTAL: 87 tatee r:ras 611se SWd of Itaeole CURRENT RENEWAL TYPE OF PLAN: DPPO DPPO COVERAGE STRUCTURE (IN I OUT) (IN I OUT) I INDMDUAL DEDUCTIBLE., $251$25 $251$25 FAMILY DEDUCTIBLE 15.;1," $75/$75 $751$75 DEDUCTIBLE WAIVED FOR PREVENTIVE2 YES I YES YES I YES PREVENTWSIERVIOE&:=y 100%1100% 100%1100% BASIC SERUIOES`..' 'R 80%180% 80%/80% MAJOR SERVIiIES' 50%/501/6 50%150% END EVEL , BASIC BASIC PERIODONTICStww BASIC BASIC IAWLA�ELS00 D?;. NO NO ANNUALd�w M $2,000 $2,000 QRTHQDO�TTI1AA'R''"'�s,. 50%150% 50%150% ORTHODQiIFIq F0IiA6UL3 ( 1tLD? YES I YES YES I YES UFETIME UM: $2,000 $2,000 kJSl1AL hI y; kE' 9 09 4 90% • i EMPLOYEE RATE: $30.66 $34.96 EMPLOYEE&$PO61 RATF: $63.33 $72.49 EMPLTYEE'&GKD(RE*RAM $73.22 $83.01 FAMILYRATEE $105.89 $120.54 M0N7HLYPREmm $7,057 $8,038 ANNUALPREMIUM,, $84,678 $96,458 VARIANCE FROM CURRENT;-,. NOT APPUCABLE 13.9% RA it GWAhANTEEC PARTICIPATION REtt(1�REMEP[T;,, NOT APPLICABLE NOT APPL MONTHS REMINDERS' a Some carriers an have a waiting period andlor frequency limit Imposed for certain services. e Prior authorization Is suggested for services to be performed In excess of a certain dollar amount 0.e.$250) PLEASE NOTE:TMs bwwk summarykomparlson contains s general deserlption of certain benefits&quoted costs and does not adforlth to procedures,limitations and exclusions or Out rate applicable to each This benefit ePPlia policy. summarykomparlson Is Intended to foster discussion regarding policy highlights and Is created for Informations!purposes only and Is not Intended as a subatlWb for the official plan certificate and booldst United City of Yorkville 2011.xisx HDHP HMO TOTAL •{ . ; EMPLOYEE: 6 13 19 SETT E R (` BUSINESS EMPLOYEE&SPOUSE: 10 6 16 P L ,A N N I N G 1 N C. EMPLOYEE&CHILD(REN): 2 4 6 MEDICAL PLAN SUMMARY FAMILY: 23 22 45 TOTAL: 41 1 45 86 (r�`�a�`►{yy IN-NETWORK OUT-OF-NETWORK MEMBER'S RESPONSIBILITY RATES PREMIUM ever Lrae aAkta Deductible Coinsurance Coinsurance Limit Deductible Coinsurance Coinsurance Umit In4iotwork Outpatient l0atwork Preaalptiona VARIANCE or tl0r" Inpatient Hospital Emergency Physician EMPLOYEE&'EMPLOYEE&' MONTHLY FROM Individual(Family) Individual(Family) Individual(Family) Individual(Family) Admission Room Visit Office Visit EMPLOYEE SPOUSE CHILDREN FAMILY TOTAL LNUALTOTJ CURRENT CURRENT HDHPBPEC1807 $2,500($5,000) 100% $p ENetwork mbined within- 80% $2,500($5,000) 0%aae Deductible 0%after 0%after 0%after Ded ucUMe Deductible Deductible Deduchble $389.16 $826.60 $807.34 $1,244.79 $40,846 $490,150 HMOBPHBO13 $0 100% $1,500(2x) ot Applicable Not Applicable NotApplcaae $0 $150 $10�Prac! $151$301$50 $354.33 $752.59 $735.05 $1,133.33 $36,995 $443,943 TOTAL: $77,841 $934,093 RENEWAL•NON-GRANDFATHERED OPTIONS(*Unless a below plan is a"Closed" Plan, in which case that specific plan could remain "Grandfathered") HDHPNPSC1807 $2,500($5,000) 100% $0 Network Deductible 80% $2,500($5,000) o%anerDeductible 0%aAer 0%after 0%atbl $463.89 $974.93 $941.00 $1,452.05 $47,812 $573,741 17.1% Nehvork Deductible Deductible Deductible Deductible HMOBPHBO13* $0 100% $1,500(2x) Not Applicable Not Applicable Not Applicable $0 $150 10 Gen $15/$30/$50 $477.23 $1,003.01 $968.09 $1,493.87 $48,960 $587,515 32.3% TOTAL: $96,771 $1,161,256 24.3% 'EXPECTED ANNUAL REIMBURSEMENT LIABILITY: $114,000 MAXIMUM POTENTIAL COSTS(Insurance Premium+Reimbursement Liability): $1,275,256 21.7% REIMBURSEMENT SCHEDULE $2,000-SINGLE EMPLOYEES (Firm pays first$2,0001 Employee pays last$500) TOTAL MAXIMUM LIABILITY FOR 2011 BASED ON CURRENT ENROLLMENT: $152,000 $4,000.FAMILIES (Firm pays first$4,0001 Employee pays last$1,000) ACTUAL PAID-TO-DATE CLAIMS: $10,045 TOTAL EXPECTED PPO COST: $687,741 13.8% • Please Note: Rue to the"Grandfather"provisions of the Affordable Care Act plan changes to your existing coverage and/or employer contribution changes could result in the loss of"Grandfather Status" • PLEASE NOTE: Your current HMO plan is considered a"Closed Plan"by BCBS of IL. If any plan changes are made or additional plans offered,this plan will need to be replaced by a currently offered("Open")plan. • Mail Order Rx Benefit: 2 x Retail Copay for a 90 day supply. • BCBS of IL has a pre-authorization prescription drug process. • The above HMO Plans are only available to employees residing in Illinois&Chicago Metro area counties(NW Indiana). • If offering multiple plans,the Prescription Co-payments must match. • Triple Option available for any size group. PLEASE NOTE: This benefit summaryfcompadson contains a general description of certain benefits&quoted costs and does not set forth the procedures,limitations and exclusions or final rates applicable to each policy.Thls benefit summaryacompadson Is intended to FOSW discussion regarding policy highlights an is created for Informational purposes only and Is not intended as a substitute for the official plan certificate and booklet. t V IN-NE7WORK OUT-OF•MfTWORK MEMBER'S RESPONSIBILLTY RATES -PREMIUM ° Deductible Catnsurance Unouranco Limes Daducdbts colnwranq ColnwromURA ImNdwWk Outpatient In Network Ptgplytloea WRUUSCE BW°Crms ague SOIe41 orleaaou InpaUSrrtHoepHat Emvpaery Phyaldsn � ENPLOYEEa EMPLOYFEa NONTNLY. FROM Indvidual(Famlyl InrGvidual(Family) Irldividual(Farnily) Isdividual(Fia*]t Admission RoanVisN OlRgvisil EMPLOYEE SPOUT FAMILY TOTAL ANNUALTOfAL CURRENT Reimbursement Arrangement PLAN DESIGN EXAMPLE $0 Combined with in. 80% $2 ($ ) 096 aM1er Deductible o�abet o attar o%aver $408 34 $658.18 $828.31 $1,278.17 $42,086 =505,037 3.0% NPSE1A07 $3,500($7,x) 100% NetworkDeduclible Deductible Dedu"ble Deductible Annual Reimbursement Liability: L$3,000 $6,000 $6,000 $6,000 $228,000 Annual Reimbursement Administrative Fee: $150 Total Costs(Insurance Premium+Reimbursement Liability+Administrative Fee): $733,187 21.4% Total Costs(Insurance Premium+Reimbursement Liability+Administrative Fee)If 75%of Reimbursement Liability met: $676,187 11.9% Total Costs(Insurance Premium+Reimbursement Liabllity+Administrative Fee)If 50%of Reimbursement Liability met: $619,187 2.5% Total Costs(insurance Premium+Reimbursement Liability+Administrative Fee)If 25%of Reimbursement Liability met: $562,187 -6.9% The above Reimbursement Arrangement totals were calculated based on HDHP Population&Annual Reimbursement Liability combined. fN•N�, TWORK OUT-OF-NETWORK MEMBER'S RESPON 181LITY RATES PREMIUM Deductible coinsursnq ColnsuransaUmtt Deducdbk Cdnsurorca'C9lnaurMaUroN MNdvwrk Outpatlart tnJishaerk PrsscAYtiOna VARUWCE et"ecropawesaGw Iopati nt"OSPI l Erlrer"my Physidas EMPLOYEE4 EMPLOYEE6 MONTHLY FROM °f 116w°ir Indvidual(Farmly) Irtdvidval(Fe*) Indiddual(Family) Irldviouel(Famay) Admtatlon Rolm VWt INba Visit FMPLOYEE SPOUSE CHI FAkBLY TOTAL ANNUAL TOTAL CURRENT Blue A ivantage HMO OPTIONS www.bcbsil.com-"BlueAdvantage HMO" o Not Applicable WAVOicable NO $o $150 t2oPCF $Q $10/$40/$6011 $467.06 $981.64 $947.48T$17462.0411 $47,916 $574,996 29.5% INHHB106 $0 100% $1,500(2x) spedaist r B1ueCross BlueShield of Illinois Experience. Wellness. Everywhere." The Affordable Care Act: Summary of Preventive care coverage at 100% The Affordable Care Act requires non-grandfathered plans Immunizations to provide coverage for "preventive care." This coverage . Diphtheria,Tetanus, Pertussis must be provided without cost sharing(e.g., coinsurance, • Haemophilus influenzae type B deductible or copayment). Interim final regulations that were • Hepatitis A and B issued on July 14, 2010,further define certain categories of . Human Papillomavirus (HPV) items/services that must be covered as preventive care. • Influenza (Flu) • Measles, Mumps, Rubella Categories of Covered • Meningococcal Preventive Services • Pneumococcal (pneumonia) • Inactivated Poliovirus • Evidence-based items/services rated A or B in the cur- • Rotavirus f rent recommendations of the U.S. Preventive Services • Varicella (chickenpox) Task Force. Routine immunizations for children,adolescents and Childhood health screenings adults recommended by the Advisory Committee on Im- • Medical history for all children throughout i munization Practices of the Centers for Disease Control development and Prevention. • Height,weight and Body Mass Index(BMI) • Evidence-informed preventive care and screenings for measurements infants, children and adolescents in the comprehensive • Developmental screening guidelines of the Health Resources and Services Admin- • Autism screening " istration. • Behavioral assessment ® Evidence-based preventive care and screenings for • Vision screening women described in the comprehensive guidelines of the • Oral health risk assessment Health Resources and Services Administration. • Hematocrit or hemoglobin screening • Obesity screening and weight management counseling BCBSIL has compiled a detailed list of procedures and • Iron supplements codes that are included in these categories, and this list will • Fluoride supplements be used for claims administration. • Lead screening • Dyslipidemia screening Detailed List of Covered • Tuberculin testing Preventive Care Items/Services Adolescent health screenings • Depression screening Children and Adolescents • Alcohol and drug use assessment Newborns • Counseling to prevent sexually transmitted ! • Screening for hearing loss, hypothyroidism, sickle cell infections (STIs) disease and phenylketonuria (PKU) • Cervical dysplasia screening • Gonorrhea preventive medication for eyes • HIV screening Adults General health screenings Immunizations • Blood pressure screening • Hepatitis A and B • Cholesterol screening • Herpes Zoster • Type 2 diabetes screening • Human Papillomavirus (HPV) • HIV and sexually transmitted infections (STIs) screenings • Influenza (Flu) • Measles, Mumps, Rubella Cancer screenings • Meningococcal • Breast cancer mammography • Pneumococcal (pneumonia) • Breast cancer chemoprevention counseling • Tetanus, Diphtheria, Pertussis • Cervical cancer pap test for women • Varicella (chickenpox) • Colorectal cancer screenings including fecal occult blood testing, sigmoidoscopy or colonoscopy Men • Prostate cancer(PSA) screening for men • Abdominal aortic aneurysm one-time screening Health Counseling Women Doctors are encouraged to counsel patients about these • Osteoporosis screening health issues and refer them to appropriate resources as • Chlamydia infection screening needed: • Gonorrhea and syphilis screening • BRCA counseling about genetic testing • Healthy diet • Weight loss Pregnant Women • Tobacco use • Folic acid supplements • Alcohol misuse • Anemia screening for iron deficiency • Depression • Tobacco cessation counseling • Prevention of sexually transmitted infections (STIs) • Syphilis screening • Use of aspirin to prevent cardiovascular disease d Hepatitis B screening • Rh incompatibility blood type testing • Bacteriuria urinary tract infection screening • Breastfeeding education B1ueCross B1ueShield of Illinois A Division of Health Care Service Corporation,a Mutual Legal Reserve Company. � � an Independent Licensee of the Blue Cross and Blue Shield Association. Experience.Wellness.Everywhere.'