Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Administration Packet 2009 05-14-09
.<�,D CAP® United City of Yorkville £ ^' 800 Game Farm Road EST. -� 1836 Yorkville, Illinois 60560 ITelephone: 630-553 -4350 o� :, py Fax: 630-553-7575 AGENDA ADMINISTRATION COMMITTEE MEETING Thursday, May 14, 2009 7 :00 p.m. City Hall Conference Room Presentation : None Minutes for Correction/Approval: April 9, 2009 New Business : 1 . ADM 2009-32 Monthly Budget Report for March 2009 2. ADM 2009-33 Monthly Treasurer' s Report for March 2009 3 . ADM 2009-34 Future Meeting Dates and Times — Discussion Old Business : Additional Business : 2008 City Council Goals - Administration Committee "City Hall. " (Infrastructure Planning Alderman Munns Bart Olson Alderman Plocher "Event planning, with focus on extension ofOktobertest and Summerfest Glory Spies and clarifyin the city 's role and adding ci presence. " Alderman Plocher Bart Olson "Explore green design/certification for public buildings. " Alderman Sutcliff Bart Olson Travis Miller Alderperson Spears Bart Olson "Action plan for constituent communications. " Alderman Plocher Glory Spies UNITED CITY OF YORKVILLE WORKSHEET ADMINISTRATION COMMITTEE Thursday, May 14, 2009 7 :00 PM City Hall Conference Room -----------------------------------------------------------------------------------I--------------------------------------------------- MINUTES FOR CORRECTION/APPROVAL: --------------------------------------------------------------------------------------------------------------------------------------- 1 . April 9, 2009 ❑ Approved ❑ As presented ❑ With corrections --------------------------------------------------------------------------------------------------------------------------------------- NEW BUSINESS: --------------------------------------------------------------------------------------------------------------------------------------- 1 . ADM 2009-32 Monthly Budget Report for March 2009 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 2. ADM 2009-33 Monthly Treasurer' s Report for March 2009 ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- 3 . ADM 2009-34 Future Meeting Dates and Times — Discussion ❑ Moved forward to CC consent agenda? Y N ❑ Approved by Committee ❑ Bring back to Committee ❑ Informational Item ❑ Notes --------------------------------------------------------------------------------------------------------------------------------------- ADDITIONAL BUSINESS : --------------------------------------------------------------------------------------------------------------------------------------- Page 1 of 5 DRAF 1 UNITED CITY OF YORKVILLE ADMINISTRATION COMMITTEE MEETING Thursday, April 9, 2009 7:00pm City Hall Conference Room COMMITTEE MEMBERS IN ATTENDANCE: Chairman Marty Munns (arr. 7:10pm) Alderwoman Rose Spears Alderman Gary Golinski Alderman Wally Werderich OTHER CITY OFFICIALS IN ATTENDANCE: Mayor Valerie Burd City Administrator Brendan McLaughlin Alderwoman Robyn Sutcliff Treasurer Bill Powell Finance Director Susan Mika Community Development Director Travis Miller GUESTS: Tony Scott, The Kendall County Record Susan Dohoney The meeting was called to order at 7:05pm by Vice-Chairman Wally Werderich, Presentation: None Minutes for Correction/Approval: February 12, 2009 and March 12, 2009 The minutes were approved as read. New Business: 1. ADM 2009-23 Monthly Budget Report for February 2009 No comment, no further action. 2. ADM 2009-24 Monthly Treasurer's Report for February 2009 Treasurer Powell gave the following information: Beginning Balance: $19,921,661 Revenues: $ 1,672,996 Expenses: $ 1,509,692 Ending Balance: $20,084,965 He said the General Fund balance has dropped to about 9%, much lower than a year ago. Ms. Mika added that the sales tax is 3 months behind, the utility taxes are in arrears and Page 2of5 both should be reflected at the end of June. She anticipated the Fund Balance to be 14-15% at the end of the year. This item will move to the consent agenda. 3. ADM 2009-25 Compensation Time Caps Administrator McLaughlin said that due to the harsh winter, there were many callouts for snow removal resulting in many hours of overtime. He said some employees wished to bank the hours while others explored putting the hours into a retirement account. He spoke to the attorney about this. Currently the overtime hours are capped at 120 hours. Because of this, some employees will be forced to take overtime checks. Mr. McLaughlin asked if the committee preferred this overtime payment or allow the cap to be 240 hours. Mayor Burd said that some employees preferred to have time off in lieu of the overtime resulting in a savings for the City. The extra hours are spread fairly evenly among seven employees according to Mr. McLaughlin. Alderman Munns pointed out that if the money were paid later, it could be at a higher rate, however, the employees agreed to sign a document to take time off, rather than take money. Chairman Munns said the overtime must be spread evenly so that large sums are not liable to be paid and managers must monitor the time. He cited a document dated August 2007 that stated employees would stop accruing comp time at 120 hours. Ms. Spears referred to the approved minutes of September 11, 2008 that said "employees had until May 1, 2009 to use or lose the time", however, she said the typed resolution dated 2007 was somewhat different. Even though they signed an agreement, Mr. McLaughlin said the City would still be legally liable. Ms. Spears added that all City policies need to be re-addressed Alderwoman Spears also handed out a survey of Park Districts. It stated that if there was comp time, it must be taken in the next pay period. She also said that Elgin did a cost analysis and found that outsourcing was less expensive. Administrator McLaughlin will contact Elgin for information. Mr. Munns suggested that if the plowing was outsourced, no overtime would need to be paid and a contract could be negotiated. Aldennan Munns requested a list of accrued hours prior to the next meeting. Most committee members said that a limit of 120 hours was more than adequate, but they would prefer no more than 80 hours. Mr. McLaughlin said that other city employees receive flex time. It was agreed that the employees must start taking the comp time and that exceptions cannot be made. Employees who have reached their cap, should not be called for overtime. At the conclusion of the discussion, the committee said they would allow the 120 hours comp time for now, but this will be discussed at the next meeting again. Page 3 of 5 4. ADM 2009-26 Review of Vacation Carryover/Cashout Policy Mayor Burd said two employees have asked to cash out more than 40 hours of vacation time. The handbook states that only up to 40 hours vacation pay can be cashed out, subject to department head approval. She said this had been allowed for other employees in the past, but she asked to have that practice stopped. At this point, these employees will lose this vacation. She asked the committee to review this situation. Alderman Munns stated that most companies have a cap on accrued vacation. Other comments included: every employee has received the handbook and you can accrue more than 40, but it must be used, not cashed out; if it has happened in the past, let it be paid out now, but give warnings, supervisor should be aware of policy; when you read the manual and sign off, it is employee's responsibility. The Mayor said she has denied one request already and all should be treated the same. The committee approved the present written policy. 5. ADM 2009-27 Contract Renewals Alderwoman Spears said that in the past, the Council would always meet with the insurance company at the time of renewal and also obtain quotes from other companies. Three or four years ago a committee was formed to hear all the proposals and they were able to decrease the costs. She added that all other contracts should also be re-evaluated and put out for bid. Previously, there was a spreadsheet of all the contracts coming for renewal. Chairman Munns asked for a list to be provided again which Mr. McLaughlin will compile. There was a brief discussion of auctioning used squad cars on e-bay or through a State auction site. Mr. Golinski said his company uses a site called "Bid for Assets" for excess property. 6. ADM 2009-28 Professional Services Contracts—Community Development Services The City is considering offering some of its professional services to other towns that do not have them. Travis Miller compiled a list of possible services and the costs involved. If the ordinance to do this is approved, any resulting contracts must be brought to the Council for approval. Mayor Burd said that the Planning Consortium provided valuable contacts from municipalities who already offer this service. The committee approved this and it will move forward to City Council on the consent agenda. 7. ADM 2009-29 Purchasing Supplies fronn Local Businesses—Discussion Chairman Golinski said EDC had a discussion regarding local buying and he would like local vendors to get preference if the prices are reasonable. The City's website encourages local vendors to register with the City to be contacted when goods are needed. He suggested using a copy of the Chamber manual for potential vendors and sort it by commodity or type of business. The Mayor suggested that the Chamber might be able to help make sure businesses register with the City. Page 4 of 5 8. ADM 2009-30 Amended Governing Ordinance Regarding Use of City Equipment Mayor Burd asked to have the Governing Ordinance amended. A policy is in place for staff, however, it does not address elected officials. Specifically, she said this amendment would concern the request for FOIA's for City emails. She would like to have these types of requests stopped. Alderwoman Spears requested this matter come back next month because she is appealing 72 FOIA's that were denied. She said she would have confirmation on the status of her appeals at that time. The Mayor said she did not understand the reason for all the FOIA's and that some are denied due to being confidential. She said any Alderman could request the information directly The portion of the ordinance Ms. Burd would like changed is under "Ethics" and concerns the City server. Mayor Burd said City equipment/taxpayer money is not to be used for campaigning or to encourage support for candidates. Ms. Spears also said that there should be a dress code because Aldermen are representing the City. Mayor Burd said she had written the Governing Ordinance and included a dress code due to a consensus at the time. It was discussed who would decide what was appropriate and how to enforce it. Alderman Golinski suggested putting the issue of City equipment on a future agenda for discussion. Chairman Munns said the City should follow the State's guidelines regarding City equipment. Alderwoman Spears questioned the legality of the City checking aldennanic emails since Aldermen were not required to sign documents regarding the usage of City email. Mayor Burd said the State election laws cover this issue. This matter will move forward to the City Council consent agenda. 9. ADM 2009-31 Draft Resolution for Signing of Payroll Checks Treasurer Powell said City staff members sometimes have a difficult time finding personnel to sign the payroll checks. In order to streamline the signing procedure, he rewrote the resolution. It was also suggested to make direct deposit mandatory. Susan Mika said some employees had resisted this idea when asked some time ago. In the proposed solution, the Mayor's signature would be electronic and the City Administrator or Finance Director would actually sign the check. This Resolution will move to the consent agenda. Old Business: 1. ADM 2009-21 Vehicle Replacement Schedule Only one vehicle is scheduled for replacement--it is from Public Works. It was suggested that police officers could share cars instead of having one for each resulting in cost- savings. No further discussion or action at this time. Page 5 of 5 2. ADM 2009-13 School Board Representative for Park Board Mayor Burd said Dr. Engler thought he had appointed Dave Dockstadter years ago to be the Park Board representative. Dr. Engler said he had sent a letter to the fanner Mayor with the understanding that Mr. Dockstadter would only attend in the event of a Parks discussion. However, the Park Board wishes to have someone there on a regular basis. A retired teacher was suggested as a rep to the Park Board. No further discussion. Additional Business: Gary Golinski asked about the status of the rundown building at the northwest corner of Hydraulic and Rt. 47. It is scheduled for demolition this summer according to Mr. McLaughlin. Alderwoman Spears asked about a mattress sign on Rt. 47. Brendan McLaughlin will ask Bill Dettmer for information. Signature cards will need to be updated as a result of election of new Aldermen. Treasurer Powell asked all Aldermen to sign the cards again so that checks can be signed. There was a brief discussion regarding picking new committees when the new Aldermen are sworn in. There was no further business and the meeting was adjourned at 8:38pm. Respectfully submitted by Marlys Young, Minute Taker C/p` Reviewed By: Agenda Item Number 0� Legal ❑ N b -& esr. isas Finance F1 Z Engineer ❑ Tracking Number City Administrator ❑ Consultant El t,g o200o1-3a <LE \V� Agenda Item Summary Memo Title: Monthly Budget Report for March Meeting and Date: Administration Committee 5/14/09 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Rachel Wright Finance Name Department Agenda Item Notes: United City of Yorkville Kendall Couty, IL 2008-2009 Budget General Fund Summary Period 10 Ending March 31 , 2009 91 .63% Of Fiscal Year 2008-2009 REVENUE/EXPENSE THRU REVISED PERCENT VS. BUDGET March 31 , 2009 BUDGET AMOUNT TOTAL GENERAL FUND REVENUE 9,3521960 10,913;842 85.706% , ; GENERAL FUND EXPENSES Admin. 1 ,6081711 13720,368 93.51 % Finance 414169328 4,307,487 102.53% Comm. Relations 1219001 1585151 76.51 % Engineering 466,370 525,240 88.79% Police 258695813 351255952 91 .81 % Planning & Development 4377556 487,295 89.79% Streets 5565276 553,237 100.55% Health & Sanitation 939,395 19126,000 83.43% SS % 11 '415 a449 , 2003,73 10%TO ' Note: Fund balance to account for $600,000 deficit in revenues. United City of Yorkville Kendall County, IL General Fund Summary March 2009 (91 .63°/x) 100% x p " at E32008-2009 BUDGET 40% ` ell �+ - � ® THRU s ` ' March 31 , 2009 llD y : s Ell ' 20% u 0% TOTAL GENERAL Admin. Finance Comm. Engineering Police Planning & Streets Health & TOTAL j GENERAL FUND Relations Development Sanitation GENERAL FUND EXPENSES FUND REVENUE EXPENSES Kendall County, IL Monthly Budget Report Period 11 (91 .63°/x) REVISED FISCAL YTD FISCAL YEAR FISCAL YTD DEPARTMENT PAGE # ACCOUNT NUMBER DESCRIPTION ACTUAL BUDGET ACTUAL % EXPLANATION OF % OVERAGE ADMIN 3 01-110-50-00-5106 SALARIES - ADMINISTRATIVE 457,741 .90 414,113.00 110.5 Unexpected payouts for personal time off. ADMIN 3 01-110-50-00-5136 SALARIES - PART TIME 2,052.78 2,053.00 99.9 Com Relations intern ADMIN 3 01-110-50-00-5137 SALARIES - OVERTIME 22.14 0.00 100 Payout instead of corn -time accrual. ADMIN 3 01-110-61-00-5300 LEGAL SERVICES 354,028.05 250,000.00 141.6 Increased use of attorneys for litigation City Code has been amended frequently. Will need to ADMIN 3 01-110-61-00-5311 CODIFICATION 1 10,660.00 3,500.00 304.5 The adjusted at mid-year budget ADMIN 4 01-110-62-00-5401 CONTRACTUAL SERVICES 18,686.71 20,000.00 93.4 Not expected to exceed. Total spent between mileage and salaries should even ADMIN 4 01-110-62-00-5402 SPECIAL CENSUS MILEAGE 11 ,364.49 0.00 100 out. ADMIN 4 01-110-62-00-5403 SPECIAL CENSUS 4,893.90 5,000.00 . 97.8 Not expected to exceed. ADMIN 4 01-110-62-00-5406 OFFICE CLEANING. 7,900.00 7,500.00 105.3 Extra cost to cover janitor's time off Telephone costs were more than expected. ADMIN 4 01-110-62-00-5436 TELEPHONE 17,340.52 11 ,000.00 15716 Addressed in FY 09/10 budget. Mayor's reimbursement was not budgeted in original ADMIN 4 01-1.10-62-00-5438 CELLULAR PHONE 1 2,682.89 2,040.001 131.5 and revised budget. ADMIN 4 01-110-62-00-5439 TELEPHONE SYSTEM MAINT. 2,944.80 3,000.00 98.1 Done for the year Annual dues for City Admin and Asst. City Admin for ADMIN 4 01-110-64-00-5600 DUES 9,086.16 9,000.00 100.9 ICMA, and MetroWest COG came up in May. ADMIN 4 01-110-64-00-5601 ILLINOIS MUNICIPAL LEAGUE DUES 957.00 918.00 104.2 Dues increased based on est. population. ADMIN 4 01-110-64-00-5607 PUBLIC RELATIONS 189.95 100.00 189.9 No additional money expected to be needed. ADMIN 4 01-110-6500-5800 CONTINGENCIES 15,503.58 15,471 .00 100.2 No further expenses expected. Budgeted amount is not enough to operate. ADMIN 4 01-110-65-00-5802 OFFICE SUPPLIES 7,019.68 7,000.00 100.2 Addressed in FY 09/10. Budgeted amount is not enough to operate. ADMIN 1 4 01-110-65-00-5804 OPERATING SUPPLIES 5,824.27 5,000.00 116.4 Addressed in FY 09110. Final color copier bill came in from KopyKat ($2,100). ADMIN 1 4 01-110-65-00-5809 PRINTING & COPYING 1 9,831 .64 9,000.00 109.2 New bills should be lower than before. FINANCE 6 01-120-61-00-5304 AUDIT FEES & EXPENSES 42,980.00 40,700.00 105.6 Unanticipated single audit. FINANCE 6 01-120-62-00-5400 INSURANCE-LIABILITY & PROP. 380,612.88 240,757.00 158 8 month portion for FY09. Bill was paid in FY08 FINANCE 6 01 -120-64-00-5603 SUBSCRIPTIONS/BOOKS 215.00 0.00 100 Coding error, will be adjusted. FINANCE 6 01-120-64-00-5604 TRAINING & CONFERENCES 2,280.00 2,000.00 114 New employee training, credit in Jan will be over $280 FINANCE 7 01-120-65-00-5808 POSTAGE & SHIPPING 1 ,195.09 1 ,000.00 119.5 New expense to finance this year FINANCE 7 01-120-78-00-9003 SALES TAX REBATE 554,554.53 500,000.00 110.9 Requests greater than the past The city's account is awash-thru". What we take in, FINANCE 7 01-120-78-00-9004 BUSINESS DISTRICT REBATE 175,475.72 0.00 100 we cut right back out. FINANCE 8 01-120-99-00-9941 TRANSFER TO PARK & REC LOAN 200,000.00 0.00 100 Lan to be repaid to the City within one year. ENGINEERING 9 01-150-62-00-5409 MAINTENANCE - VEHICLES 1 1 ,038.22 1 ,000.00 103.8 1 Normal maintenance Over-run primarily due to in-house copy machine ENGINEERING 10 01-150-65-00-5809 PRINTING & COPYING 1 ,389.90 1 ,000.00 138.9 charges POLICE 12 01 -210-62-00-5442 NEW WORLD LIVE SCAN 12,320.04 8,000.00 154 Project extended to Aug 2009 / Travel Expenses POLICE 12 01-210-62-00-5443 ADMIN ADJUDICATION CONTRACTUAL 7,650.00 0.00 100 Directly tied into the proceeds of fine amounts from the adjudication process. Will "balance" to positive numbers at the end of the budget year when compared to the income line associated with the expenditure line POLICE 13 01-210-65-00-5814 ADMIN ADJUDICATION OPERATING 106.96 0.001 100 Balances with revenue fund. POLICE 13 01-210-75-00-7002 COMPUTER EQUIP & SOFTWARE 6,965.00 7,000.00 99.5 Standard Purchases/Yearly Maintenance ITP schedule was advanced - was able to reduce line PLANNING & DEVI 14 01-220-62-00-5401 CONTRACTUAL SERVICES 16,112.45 11 ,100.00 145.1 item for 09-10 budget PLANNING & DEVI 14 01-220-6400-5604 ITRAINING & CONFERENCES 2,001 .22 1 ,850.00 108.1 attended park & rec conference PLANNING & DEVI 14 01-220-64-00-5605 TRAVEL EXPENSE 417.68 200.00 208.8 higher than expected expense for state conference PLANNING & DEVI 14 01-220-65-00-5809 PRINTING & COPYING 651.26 500.00 130.2 Split copier cost with engineering dept not anticipated PLANNING & DEVI 14 01-220-65-00-5814 BOOKS & MAPS 762.93 500.00 152.5 Updated zoning handbook for ordinance update STREETS 15 01410-50-00-5137 ISALARIES - OVERTIME 35,409.61 11 ,328.00 312.5 Due to snowplowing STREETS 15 01410-61-00-5314 1 INSPECTIONS & LICENSES 595.00 100.00 595 1 Done for year STREETS 16 01410-62-00-5416 MAINTENANCE PROPERTY 26,503.44 21 ,000.00 126.2 Property maintenance not budgeted, will need to STREETS 16 01410-62-00-5423 RAYMOND STORM SEWER OUTFLOW 1 1 ,034.00 0.00 100 Follow up paperwork with [DOT STREETS 16 01410-62-00-5435 ELECTRICITY 1 99,405.20 73,526.00 135.1 - May need to adjust year end. STREETS 17 01410-75-00-7101 IN TOWN ROAD PROGRAM 45.56 0.00 100 Reimbursement to residents for driveway paving FOX HILL SSA 19 11-000-65-00-5416 MAINTENANCE COMMON GROUNDS 20,012.46 19,892.00 100.6 Reimbursed through SSA levy MOTOR FUEL TAX 21 15-000-65-00-5818 SALT 227,296.02 86,000.00 264.2 Reapproated monies through MFT will not exceed. MOTOR FUEL TAX 21 15-000-65-00-5825 GEO MELT 13,200.00 0.00 100 Reapproated monies through MFT will not exceed. MOTOR FUEL TAX 21 15-000-75-00-7008 CRACK FILLING 26,549.10 20,000.00 132.7 Bids were higher than anticipated due to oil prices MOTOR FUEL TAX 22 15-000-75-00-7113 COUNTRYSIDE PKWY CONST. 8,380.46 0.00 100 final payout for project from previous fiscal year MOTOR FUEL TAX 22 15-000-75-00-7118 RT 34 & SYCAMORE TRAFFIC SIGNAL 15,337.85 0.00 100;:` Ongoing project from previous fiscal year MOTOR FUEL TAX 22 15-000-75-00-7120 FOX ROAD 9,900.00 0.00 100" New project approved by City Council POLICE EQUIP. C 25 20-000-65-00-5840 SEIZED VEHICLES 1 ,540.30 0.00 100'---'-- Balances with revenue fund. CITY WIDE CAPITY 31 23-000-75-00-7102 MCHUGH ROAD 171 ,601 .82 162,684.001 105.4 1 No response given CITY WIDE CAPIT 31 23-000-75-00-7103 1 ISIDEWALK REPLACEMENT 2.229.001 1 ,186.001 187.9 1 No res onse given WATER OPS. & IM 38 51-000-50-00-5136 SALARIES - PART TIME 3,582.00 3,500.00 102.3 Itrans from meter readers WATER OPS. & IM 39 51-000-02-00-5435 ELECTRICITY 295,240.71 275,000.00 107.3 May balance, based on usage WATER OPS. & IM 39 51-000-62-00-5438 CELLULAR PHONE 3,472.04 3,300.00 105.2 unexpected repairs 2 replacement batteries WATER OPS. & IM 41 51-000-99-00-9901 TRANSFER TO GENERAL FUND 187,500.00 0.00 100 Transferred back to water o WATER OPS. & IM 41 51-200-61-00-5302 FINANCIAL EXPENSES 6,400.00 0.00 100 Paid by excess bond money. WATER OPS. & IM 41 51-200-61-00-5400 B.2 CONTRACTS 274.39 0.00 100 State St. Watermain - paperwork to finish up project WATER OPS. & IM 41 51-200-61-00-5401 B.3 CONTRACTS 597.70 0.00 100 Project complete, follow up paperwork WATER OPS. & IM 41 51-200-61-00-5421 WELL 4 CONSTRUCTION 9,670.00 0.00 100 Final payout for project from previous fiscal year WATER OPS. & IM 41 51-200-62-00-5463 KENDALLWOOD ESTATES REIMB. 96,902.00 0.00 100 Reimbursement for oversizing of watermain WATER OPS. & IMI 42 51-200-66-00-6041 1 IIEPA L17-156300 INTEREST PMT 68,947.03 56,528.00 121.9 Bond Payment WATER OPS. & IM 42 51-200-66-00-6056 12006A REFUND INTEREST PMT-WTR 1 46,053.13 5,100.00 903 Will need to adjust at 6 month review WATER OPS. & IM 42 51-200-66-00-0058 12002 PRINCIPAL PMT-NORTH WTR 1 117,200.00 60,000.001 195.3 Bond Payment WATER OPS. & IM 42 51-200.75-00-7504 1 NORTH WATER TOWER.CONTR. A 1 2,200.00 0.00 100 Band Payment WATER OPS. & IM 42 51-200-75-00-7520 IWATERMAIN PROJECTS 11 ,492.76 0.00 100 Temp. sidewalk for Van Emmon Watermain transfer WATER OPS. & IM 42 51-200-75-00-7522 1 IN-TOWN RD WATER PROJ 5.305.13 0.00 100 Adjusting at 6 month budget WATER OPS. & IM 42 51-200-99-00-9901 ITRANSFERTO GENERAL FUND 150,000.00 0.00 100 Transferred back to water o SEWER IMP & OPI 45 52-000-64-00-5604 ITRAINING & CONFERENCES 733.00 500.00 146.6 Mandatory Customer Service SEWER IMP & OPI 47 52-200-75-00-7506 SOUTHWEST SVC AREA INTERCEPTOI 550,735.48 0.00 100 Raintree sanitary reimbursement. SEWER IMP & OPI 47 52-200-99-00-9901 TRANSFER TO GENERAL FUND 112,500.00 0.00 100 Transferred back to sewer o LAND CASH 50 72-000-75-00-7328 PRAIRIE MEADOWS MENARDS RES 148,20626 138,636.00 106.9 No response given PARKS & REC 53 79-610-62-00-5408 MAINTENANCE-EQUIPMENT 7,894.08 7,000.00 112.7 No response given PARKS & REC 53 79-610.62-00-5445 LEGAL EXPENSES 8,755.001 8,200.00 106.7 IThe main costs re: parksirec - Hoover, Club 47 Lease PARKS & REC 55 79-650-50-00-5150 SALARIES - INSTRUCTOR CONTRACU 104,788m421 99,000.00 105.8 18ummer program just ended 2enerally higher in cost. PARKS & REC 55 79-650-50-00-5155 SALARIES - RECORDING SECRETARY 2,509.871 2,500.00 100.3 IMeetings have run Ion PARKS & REC 55 79-650-02-00-5435 ELECTRICITY 11 ,42239 10,000.00 114.2 ISeasonal expense at Bride Park's lighted fields PARKS & REC 55 79-650-62-00-5445 PORTABLE TOILETS 4,918.39 4,500.00 109.2 budgeted amount will change in 09110 PARKS & REC 55 79-650-62-00-5603 PUBLISHING/ADVERTISING 32,618.60 29,000.00 112.4 4 brochures, 2 are done. We're on target at 56% PARKS & REC 55 79-650-62-00-5605 BOOKS/PUBLICATIONS 707.89 300.00 235.9 Purchased copies of Park District Code for research PARKS & REC 55 79-650-64-00-5604 ITRAINING & CONFERENCES 2,455.00 1 ,500.00 163.6 amountspent earlier in the year PARKS & REC 55 79-650-65-00-5803 PROGRAM EXPENSES 51 ,494.73 50,000.00 102.9 Expense highest in summer; most active season PARKS & REC 55 79-050-65-00-5808 POSTAGE & SHIPPING 10,835.66 9,600.00 112.8 Covers 2 of 4 brochure mailings. Summer is costlier PARKS & REC 66 79-050-65-00-5827 GOLF OUTING EXPESES 21 ,457.33 21 ,457.00 . 100 Event held once per year. No more ex p. until FY09 PARKS & REC 56 79-650-65-00-5841 PROGRAM REFUND 12,799.41 9,000.00 142.2 Is controlled by ro ram sign up Runs and Cancelled REC CENTER 57 80-000-50-00-5150 SALARIES - INSTRUCTOR 52,875.63 47,000.00 112.5 Higher than expected. Checking into coding error REC CENTER 57 80-000-62-00-5408 MAINTENANCE SUPPLIES 13,416.84 12,000.00 111.8 Working with account for first time. To revise in Nov._ REC CENTER 57 80-000-62-00-5416 MAINTENANCE - GENERAL 15,054.98 12,000.00 125.4 Working with account for first time. To revise in Nov. REC CENTER 58 80-000-62-00-5605 BOOKS/PUBLICATIONS 105.39 100.00 105.3 Done for year REC CENTER 58 80-000-64-00-5604 TRAINING & CONFERENCES 660.30 600.00 110 2 food certifcatons were required but not expected REC CENTER 58 80-000-65-00-5803 PROGRAM EXPENSES 16,669.03 12,000.00 138.9 more programs are being run out of rec center REC CENTER 59 80-000-65-00-5841 PROGRAM REFUNDS 2,262.00 2,000.00 113.1 more program refunds than expected Start up cost necessary to merge software with REC CENTER 59 80-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 22,277.84 13,873.00 160.5 Recreat. Gas and Electric were one line item. Made Gas its REC CENTER 59 80-000-78-00-9002 NICOR 14,263.73 0.00 100 own COUNTRYSIDE TI 68 88-000.62-00-5401 CONTRACTUAL SERVICES 3,537.01 0.00 100 bond proceeds will cover United City Of Yorkville Kendall County, IL Budget Index General Fund Revenue . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 Public Works Capital . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 Administration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 Parks and Recreation Capital . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 Finance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 City Wide Capital . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Community Relations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 Debt Service Fund . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35 Engineering . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 Water Operations and Improvement . . . . . . . . . . . . . . . . . . . . . . . . . . 37 Police . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 Sewer Operations and Improvement . . . . . . . . . . . . . . . . . . . . . . . . . . 43 Planning and Development . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 Land Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 Streets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 Parks & Recreation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51 Health and Sanitation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Recreation Center . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57 FoxHill SSA . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Library . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60 Sunflower SSA . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 Fox Industrial . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64 Motor Fuel Tax . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 Countryside TIF . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67 Municipal Building . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 Downtown TIF . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68 Police Capital . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PACE : 1 TIME : 13 : 52 : 14 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : GENERAL FUND FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ___ __ __ ______ GENERAL REVENUES TAXES 01 -000- 40- 00-3993 EMPLOY CONTRIB HEALTH REIMB 8 , 077 . 92 90 , 521 . 42 106 , 117 . 00 93 , 425 . 00 * 96 . 8 01-000-40-00-3994 AMUSEMENT TAX 0 . 00 111 , 083 . 45 135 , 000 . 00 111 , 083 . 00 * 100 . 0 01-000-40-00-3995 RESTRICTED FUND BALANCE CD ' S 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01-000-40- 00-3996 ROAD CONTRIBUTION FEE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01-000-40- 00- 4000 REAL ESTATE TAXES 0 . 00 2 , 101 , 983 . 91 1 , 992 , 991 . 00 21018 , 496 . 00 * 104 . 1 01-000-40-00- 4001 TOWN ROAD/BRIDGE TAX 0 . 00 143 , 505 . 93 131 , 000 . 00 131 , 000 . 00 109 . 5 01-000-40-00- 4010 PERSONAL PROPERTY TAX 675 . 34 10 , 207 . 27 20 , 000 . 00 20 , 000 . 00 51 . 0 O1 -000-40-00-4020 STATE INCOME TAX. 103 , 984 . 94 615 , 656 . 65 1 , 008 , 360 . 00 1 , 008 , 360 . 00 61 . 0 01-000- 40-00-4030 MUNICIPAL SALES TAX 216, 348 . 71 1 , 986 , 070 . 51 2 , 900 , 000 . 00 21625 , 000 . 00 * 75 . 6 01 -000-40- 00-4032 STATE USE TAX 17 , 547 . 92 125 , 888 . 17 150 , 652 . 00 160 , 000 . 00 * 78 . 6 01-000-40- 00-4040 MUNICIPAL UTILITY TAX 140 , 580 . 09 569 , 642 . 98 430 , 000 . 00 540 , 000 . 00 * 105 . 4 01-000-40- 00-4041 UTILITY TAX - NICOR 106 , 668 . 02 422 , 803 . 71 350 , 000 . 00 360 , 000 . 00 * 117 . 4 01-000-40- 00-4042 UTILITY TAX - CABLE TV 0 . 00 141 , 145 . 22 167 , 000 . 00 180 , 000 . 00 * 78 . 4 01-000-40- 00-4043 UTILITY TAX - TELEPHONE 39, 277 . 00 390 , 939 . 91 417 , 000 . 00 550 , 000 . 00 * 71 . 0 01-000-40- 00-4044 BUSINESS DISTRICT TAX 26 , 572 . 85 175 , 475 . 72 0 . 00 0 . 00 100 . 0 01-000-40- 00-4050 HOTEL TAX 931 . 92 18 , 415 . 46 20 , 000 . 00 20 , 022 . 00 * 91 . 9 --------__ _ ____ __ __ __-- TOTAL TAXES 660 , 664 . 71 61903 , 340 . 31 7 , 828 , 120 . 00 71817 , 386 . 00 88 . 3 LICENSES & PERMITS 01-000-41-00- 4100 LIQUOR LICENSE 0 . 00 18 , 825 . 80 32 , 900 . 00 25 , 000 . 00 * 75 . 3 O1-000-41-00- 4101 OTHER LICENSES 0 . 00 2 , 758 . 43 4 , 200 . 00 3 , 958 . 00 * 69 . 6 01 -000-41-00- 4110 BUILDING PERMITS 15 , 825 . 00 304 , 425 . 71 1 , 200 , 000 . 00 481 , 947 . 00 * 63 . 1 TOTAL LICENSES & PERMITS 15 , 825 . 00 326 , 009 . 94 1 , 237 , 100 . 00 510 , 905 . 00 63 . 8 CHARGES FOR SERVICES 01-000- 42-00-4205 FILING FEES 200 . 00 11880 . 00 5 , 000 . 00 31624 . 00 * 51 . 8 01-000-42- 00- 4206 GARBAGE SURCHARGE ( 363 . 35 ) 899 , 320 . 28 1 , 200 , 000 . 00 1 , 0501000 . 00 * 85 . 6 01-000-42-00-4208 COLLECTION FEE - YBSD 0 . 00 66 , 075 . 00 60 , 000 . 00 66 , 000 . 00 * 100 . 1 O1 -000-42-00-4210 DEVELOPMENT FEES 16 , 065 . 44 184 , 031 . 69 1 , 475 , 000 . 00 166 , 766 . 00 * 110 . 3 01 -000-42-00-4285 BEECHER LEASE AGREEMENT i , o00 . 00 11 , 000 . 00 0 . 00 0 . 00 100 . 0 01-000-42 -00- 4286 BEECHER RENTALS 325 . 00 11635 . 00 9 , 000 . 00 1 , 596 . 00 * 102 . 4 01-000-42 -00- 4287 DEVELOPER SIGN REIMBURSEMENT 0 . 00 0 . 00 5 , 000 . 00 5 , 000 . 00 0 . 0 -----_ _ ___ _ -_ TOTAL CHARGES FOR SERVICES 17 , 227 . 09 1 , 163 , 941 . 97 21754 , 000 . 00 1 , 292 , 986 . 00 90 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P1 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 2 TIME : 13 : 52 : 14 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . W0W FUND : GENERAL FUND FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED GENERAL FINES & FORFEITS 01-000-43-00-4310 TRAFFIC FINES 10 , 301 . 52 117 , 967 . 80 100 , 000 . 00 132 , 000 . 00 * 89 . 3 01-000-43-00- 4315 REIMBURSE POLICE TRAINING 0 . 00 81039 . 76 15 , 000 . 00 8 , 040 . 00 * 99 . 9 01-000-43-00-4320 ORDINANCE FEES 30175 . 00 19 , 435 . 00 21500 . 00 2 , 280 . 00 * 852 . 4 ___-_ ___________________ ___________ ________ TOTAL FINES & FORFEITS 13 , 476 . 52 145 , 442 . 56 117 , 500 . 00 142 , 320 . 00 102 . 1 MISCELLANEOUS 01 -000-44 -00-3993 EMPLOYEE CONTR . HEALTH INS . 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01 -000-44 -00-4060 TRAFFIC SIGNAL REIMBURSEMENT 0 . 00 18 , 289 . 00 51000 . 00 18 , 289 . 00 * 100 . 0 01 -000-44 -00-4401 DARE DONATIONS 0 . 00 70 . 00 11250 . 00 120 . 00 * 58 . 3 01-000-44-00- 4403 WEARING APPAREL DONATIONS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01 -000- 44-00- 4404 HANGING BASKET DONATIONS 100 . 00 21650 . 00 500 . 00 17550 . 00 * 170 . 9 O1 -000-44-00-4406 COMMUNITY RELATION DONATIONS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01 -000- 44-00-4407 HOLIDAY UNDER THE STARS 0 . 00 14 , 150 . 00 12 , 500 . 00 12 , 500 . 00 113 . 2 01-000-44-00- 4411 REIMBURSEMENTS-POLICE PROTECTN 220 . 00 21528 . 90 31300 . 00 3 , 300 . 00 76 . 6 01-000-44-00- 4412 INSURANCE REIMBURSEMENTS 0 . 00 2 , 646 . 04 2 , 000 . 00 2 , 000 . 00 132 . 3 01-000- 44 -00-4490 MISCELLANEOUS INCOME 379 . 40 20 , 620 . 59 15 , 000 . 00 15 , 001 . 00 * 137 . 4 01 -000- 44 -00- 4499 BAD DEBT RECOVERY 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL MISCELLANEOUS 699 . 40 60r954 . 53 39 , 550 00 521760 . 00 115 . 5 INTERGOVERNMENTAL 01-000-45-00-4505 COPS GRANT - VESTS 0 . 00 0 . 00 31000 . 00 0 . 00 * 0 . 0 01-000-45-00-4511 POLICE-STATE TOBACCO GRANT ( 21056 . 09 ) ( 277 . 06 ) 1 , 500 . 00 0 . 00 * 100 . 0 01-000-45-00-4525 GRANTS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01-000-45-00- 4540 BEAVER ST DEVELOPMENT GRANT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 ___ ___________________ _____________________________ TOTAL INTERGOVERNMENTAL ( 2 , 056 . 09 ) ( 277 . 06 ) 4 , 500 . 00 0 . 00 100 . 0 INTEREST 01 -000-46-00-4600 INVESTMENT INCOME 70 . 83 18 , 562 . 45 65 , 000 . 00 195 , 000 . 00 9 . 5 TOTAL INTEREST 70 . 83 18 , 562 . 45 65 , 000 00 195 , 000 00 9 . 5 TRANSFERS 01-000-49-00- 4915 TRANSFER FROM WATER OPERATIONS 0 . 00 187 , 500 . 00 250 , 000 . 00 250 , 000 . 00 75 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P2 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 3 TIME : 13 : 52 : 14 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : GENERAL FUND FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL o ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ____ GENERAL REVENUES TRANSFERS 01 -000-49-00- 4920 TRANSFER FROM SEWER MAINT . 0 . 00 52 , 500 . 00 70 , 000 . 00 70 , 000 . 00 75 . 0 01-000-49-00- 4925 TRANSFER FROM SAN . SEWER IMPR 0 . 00 112 , 500 . 00 150 , 000 . 00 1501000 . 00 75 . 0 01-000-49-00- 4930 TRANSFER FROM WATER IMPROVE . 0 . 00 150 , 000 . 00 200 , 000 . 00 200 , 000 . 00 75 . 0 01-000-49-00-4935 TRANSFER FROM LAND CASH 169 , 000 . 00 181 , 000 . 00 16 , 000 . 00 181 , 000 . 00 * 100 . 0 01-000-49-00-4940 TRANSFER FROM MUNICIPAL BLDG 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01-000-49-00-4950 TRANSFER FROM FOX IND TIF 25 , 680 . 00 25 , 680 . 00 0 . 00 25 , 680 . 00 * 100 . 0 01-000- 49-00-4955 TRANSFER FROM DOWNTOWN TIF 25 , 805 . 00 25 , 805 . 00 0 . 00 25 , 805 . 00 * 100 . 0 TOTAL TRANSFERS 220 , 485 . 00 734 , 985 . 00 686 , 000 . 00 902 , 485 . 00 81 . 4 TOTAL REVENUES : GENERAL 926 , 392 . 46 9 , 352 , 959 . 70 12 , 731 , 770 . 00 10 , 913 , 842 . 00 85 . 6 ADMINISTRATION EXPENSES PERSONNEL SERVICES 01-110-50-00- 5100 SALARIES- MAYOR 0 . 00 71535 . 00 11 , 310 . 00 111310 . 00 66 . 6 01 -110-50-00- 5101 SALARIES- CITY CLERK 0 . 00 61715 . 00 8 , 600 . 00 81980 . 00 * 74 . 7 01 - 110-50- 00-5102 SALARIES- CITY TREASURER 0 . 00 41871 . 52 61410 . 00 6 , 315 . 00 * 77 . 1 01 -110-50- 00-5103 SALARIES- ALDERMAN 0 . 00 29 , 410 . 00 30 , 970 . 00 39 , 810 . 00 * 73 . 8 01- 110-50- 00-5104 SALARIES- LIQUOR COMMISSIONER 0 . 00 750 . 00 1 , 000 . 00 11000 . 00 75 . 0 01 - 110-50-00-5106 SALARIES- ADMINISTRATIVE 67 , 265 . 07 457 , 741 . 90 460 , 985 . 00 414 , 113 . 00 * 110 . 5 01 - 110-50- 00-5115 SALARIES- SPECIAL CENSUS 0 . 00 59 , 086 . 75 0 . 00 114 , 384 . 00 * 51 . 6 01 -110-50-00- 5136 SALARIES- PART TIME 0 . 00 2 , 052 . 78 5 , 000 . 00 2 , 053 . 00 * 99 . 9 01 -110-50-00-5137 SALARIES- OVERTIME 0 . 00 22 . 14 500 . 00 0 . 00 * ( 100 . 0 ) TOTAL PERSONNEL SERVICES 67 , 265 . 07 568 , 185 . 09 524 , 775 . 00 597 , 965 . 00 95 . 0 PROFESSIONAL SERVICES 01 - 110- 61- 00-5300 LEGAL SERVICES 45 , 987 . 71 354 , 028 . 05 120 , 000 . 00 250 , 000 . 00 * 141 . 6 01 -110- 61-00-5301 LEGISLATIVE ATTORNEY 0 . 00 0 . 00 10 , 000 . 00 10 , 000 . 00 0 . 0 01 -110- 61- 00-5311 CODIFICATION 0 . 00 10 , 660 . 00 31500 . 00 3 , 500 . 00 304 . 5 01 -110- 61- 00- 5314 BUILDING INSPECTIONS 31505 . 00 243 , 568 . 62 950 , 000 . 00 374 , 772 . 00 * 64 . 9 TOTAL PROFESSIONAL SERVICES 49 , 492 . 71 608 , 256 . 67 11083f500 . 00 638 , 272 . 00 95 . 2 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P3 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 4 TIME : 13 : 52 : 14 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : GENERAL FUND FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ------------- _ ___ __ ADMINISTRATION CONTRACTUAL SERVICES 01-110-62-00- 5401 CONTRACTUAL SERVICES 939 . 75 18 , 686 . 71 20 , 000 . 00 20 , 000 . 00 93 . 4 01- 110- 62-00- 5402 SPECIAL CENSUS MILEAGE 0 . 00 11 , 364 . 49 0 . 00 0 . 00 ( 100 . 0 ) 01-110- 62-00-5403 SPECIAL CENSUS ( 80 . 45 ) 4 , 893 . 90 0 . 00 51000 . 00 * 97 . 8 01- 110- 62-00- 5404 CABLE CONSORTIUM FEE 19 , 029 . 10 ( 6 , 405 . 76 ) 35 , 000 . 00 0 . 00 * ( 100 . 0 ) 01- 110- 62-00- 5406 OFFICE CLEANING 625 . 00 7 , 900 . 00 7 , 500 . 00 71500 . 00 105 . 3 01 -110- 62-00- 5410 MAINTENANCE - OFFICE EQUIPMENT 0 . 00 87 . 50 100 . 00 100 . 00 87 . 5 01 -110- 62-00- 5421 WEARING APPAREL 0 . 00 0 . 00 540 . 00 0 . 00 * 0 . 0 01 -110- 62- 00-5436 TELEPHONE 11796 . 09 17 , 340 . 52 16 , 000 . 00 11 , 000 . 00 157 . 6 01-110- 62 -00-5438 CELLULAR TELEPHONE 387 . 23 21682 . 89 2 , 500 . 00 21040 . 00 * 131 . 5 01-110-62 -00-5439 TELEPHONE SYSTEMS MAINTENANCE 11472 . 40 21944 . 80 3 , 500 . 00 3 , 000 . 00 98 . 1 01-110- 62-00-5440 BEAVER ST GRANT EXPENSE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL CONTRACTUAL SERVICES 24 , 169 . 12 59 , 495 . 05 85 , 140 . 00 48 , 640 . 00 122 . 3 PROFESSIONAL DEVELOPMENT 01-110-64-00- 5600 DUES 0 . 00 91086 . 16 9 , 000 . 00 91000 . 00 100 . 9 01- 110- 64 -00- 5601 ILLINOIS MUNICIPAL LEAGUE DUES 0 . 00 957 . 00 918 . 00 918 . 00 104 . 2 01-110- 64 -00- 5603 SUBSCRIPTIONS 0 . 00 91 . 00 100 . 00 100 . 00 91 . 0 01-110-64 -00-5604 TRAINING & CONFERENCES 245 . 00 4 , 999 . 00 5 , 875 . 00 5 , 875 . 00 85 . 0 01-110- 64 -00-5605 TRAVEL/MEALS /LODGING 129 . 68 9 , 338 . 43 171380 . 00 13 , 000 . 00 * 71 . 8 01 -110- 64 -00-5606 PROMOTIONAL/MARKETING EXPENSES 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01-110-64 -00- 5607 PUBLIC RELATIONS 0 . 00 189 . 95 100 . 00 100 . 00 189 . 9 01 -110- 64 -00-5608 SPONSORSHIPS 0 . 00 250 . 00 11500 . 00 1 , 500 . 00 16 . 6 01 - 110- 64 -00-5609 YMCA PARTNERSHIP 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01-110- 64 -00-5610 TUITION REIMBURSEMENT 0 . 00 31855 . 00 61000 . 00 61000 . 00 64 . 2 01-110- 64 -00-5611 KENDALL COUNTY PARATRANSIT 0 . 00 0 . 00 13 , 964 . 00 13 , 964 . 00 0 . 0 -__ __ _ _ _---- TOTAL PROFESSIONAL DEVELOPMENT 374 . 68 28 , 766 . 54 54 , 837 . 00 50 , 457 . 00 57 . 0 OPERATIONS 01- 110- 65-00- 5800 CONTINGENCIES 0 . 00 15 , 503 . 56 20 , 000 . 00 15 , 471 . 00 * 100 . 2 01-110- 65-00-5802 OFFICE SUPPLIES 162 . 61 7 , 019 . 66 71000 . 00 7 , 000 . 00 100 . 2 01- 110- 65-00-5804 OPERATING SUPPLIES 339 . 44 5 , 824 . 27 51000 . 00 5 , 000 . 00 116 . 4 01- 110- 65-00-5808 POSTAGE & SHIPPING 195 . 60 51923 . 29 17 , 000 . 00 14 , 000 . 00 * 42 . 3 01 - 110- 65-00-5809 PRINTING & COPYING 11022 . 23 91831 . 64 90000 . 00 9 , 000 . 00 109 . 2 01- 110- 65-00-5810 PUBLISHING & ADVERTISING 0 . 00 766 . 78 2 , 000 . 00 21000 . 00 38 . 3 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P4 DATE : 04 /23/ 2009 UNITED CITY OF YORKVILLE PAGE : 5 TIME : 13 : 52 : 14 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . W0W FUND : GENERAL FUND FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL % ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED -_ _ _ _ ___ _ _ _-- TOTAL OPERATIONS 11719 . 88 44 , 869 . 24 60 , 000 . 00 52 , 471 . 00 85 . 5 RETIREMENT 01- 110-72- 00- 6500 IMRF PARTICIPANTS 5 , 509 . 52 37 , 374 . 36 41 , 173 . 00 38 , 765 . 00 * 96 . 4 01- 110-72- 00- 6501 SOCIAL SECURITY & MEDICARE 5 , 104 . 35 41 , 742 . 70 41 , 339 . 00 41 , 278 . 00 * 101 . 1 -------_ _ _ __ -__ _ TOTAL RETIREMENT 10 , 613 . 87 79 , 117 . 06 82 , 512 . 00 80 , 043 . 00 98 . 8 CAPITAL OUTLAY 01- 110-75- 00-7002 COMPUTER EQUIP & SOFTWARE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 O1 - 110-75-00- 7003 OFFICE EQUIPMENT 0 . 00 0 . 00 500 . 00 0 . 00 0 . 0 -----__ _ _ __ _ -_-_------- TOTAL CAPITAL OUTLAY 0 . 00 0 . 00 500 . 00 0 . 00 0 . 0 OTHER OPERATING EXPENSES 01-110-78-00- 9002 NICOR GAS 3 , 523 . 43 23 , 043 . 69 30 , 000 . 00 30 , 543 . 00 * 75 . 4 01 -110-78-00- 9004 MISCELLANEOUS ( 24 . 30 ) 0 . 00 0 . 00 0 . 00 0 . 0 01 -110-78- 00- 9005 MERIT/ PAY INCREASE 0 . 00 0 . 00 18 , 439 . 00 0 . 00 * 0 . 0 01-110-78-00- 9007 APPRECIATION DINNER 0 . 00 1 , 977 . 30 2 , 000 . 00 1 , 977 . 00 * 100 . 0 01-110-78-00- 9008 VOLUNTEER APPRECIATION DAY 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01 -110-78-00- 9009 WEBSITE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01 -110-78- 00- 9010 COMMUNITY EVENTS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01-110-78-00- 9011 TENNIS CRT REFURBISHING 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01-110-78-00- 9013 HOLIDAY UNDER THE STARS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01-110-78-00- 9014 CAR ALLOWANCE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 _ __ _ _ __ ___----- TOTAL OTHER OPERATING EXPENSES 31499 . 13 25 , 020 . 99 50 , 439 . 00 32 , 520 . 00 76 . 9 TRANFERS 01-110- 99-00- 9970 TRANSFER TO CW CAPITAL ( LAND) 0 . 00 75 , 000 . 00 100 , 000 . 00 100 , 000 . 00 75 . 0 01 -110- 99-00- 9975 TRANSFER TO CW CAPITAL 0 . 00 120 , 000 . 00 275 , 000 . 00 120 , 000 . 00 100 . 0 __ _ __ _ _ _ __-- --- TOTAL TRANFERS 0 . 00 195 , 000 . 00 375 , 000 . 00 220 , 000 . 00 88 . 6 TOTAL EXPENSES : ADMINISTRATION 157 , 134 . 46 1 , 608 , 710 . 64 2 , 316 , 703 . 00 11720 , 368 . 00 93 . 5 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P5 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 6 TIME : 13 : 52 : 14 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : GENERAL FUND FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED '----' -----`--------------- ---------_-_---- --------------- ---------------' FINANCE EXPENSES PERSONNEL SERVICES 01 -120-50-00-5106 SALARIES- FINANCE 31 , 868 . 82 297 , 924 . 02 329 , 120 . 00 328 , 487 . 00 * 90 . 6 01 - 120-50-00-5136 SALARIES- PART TIME 0 . 00 236 . 50 0 . 00 237 . 00 * 99 . 7 01-120-50-00-5137 SALARIES- OVERTIME 0 . 00 616 . 39 750 . 00 750 . 00 82 . 1 01 - 120-50-00-5202 BENEFITS- UNEMPLOY . COMP . TAX 0 . 00 10 , 771 . 50 28 , 800 . 00 28 , 600 . 00 37 . 4 01 -120-50-00-5203 BENEFITS- HEALTH INSURANCE ( 8 , 878 . 16 ) 828 , 797 . 42 997 , 021 . 00 980 , 000 . 00 * 84 . 5 01 - 120-50-00-5204 BENEFITS- GROUP LIFE INSURANCE 11983 . 27 10 , 064 . 84 28 , 488 . 00 28 , 240 . 00 * 35 . 6 01-120-50-00-5205 BENEFITS- DENTAL/ VISION ASST 7 , 255 . 16 72 , 008 . 10 97 , 982 . 00 83 , 691 . 00 * 85 . 8 ___ _-----_--_-_ __------ TOTAL PERSONNEL SERVICES 32 , 229 . 09 1 , 220 , 418 . 77 1 , 482 , 161 . 00 11450 , 405 . 00 84 . 1 PROFESSIONAL SERVICES 01 - 120- 61-00-5304 AUDIT FEES & EXPENSES 500 . 00 42 , 980 . 00 40 , 325 . 00 40 , 700 . 00 * 105 . 6 01 -120-61-00-5310 EMPLOYEE ASSISTANCE 0 . 00 11875 . 00 4 , 500 . 00 31500 . 00 * 53 . 5 ----------------------- ------------------------------ ----- -------- TOTAL PROFESSIONAL SERVICES 500 . 00 44 , 855 . 00 44 , 825 . 00 44 , 200 . 00 101 . 4 CONTRACTUAL SERVICES 01- 1? 0- 62-00-5400 INSURANCE-LIABILITY & PROP . 0 . 00 380 , 612 . 88 210 , 000 . 00 240 , 757 . 00 * 158 . 0 01-120- 62-00- 5401 CONTRACTUAL SERVICES 450 . 00 5 , 640 . 75 15 , 000 . 00 151000 . 00 37 . 6 01-120- 62-00- 5410 MAINTENANCE- OFFICE EQUIPMENT 0 . 00 1 , 669 . 01 500 . 00 1 , 700 . 00 * 98 . 1 01-120- 62-00-5411 MAINTENANCE- COMPUTERS 0 . 00 0 . 00 1 , 000 . 00 0 . 00 * 0 . 0 01-120- 62-00- 5412 MAITENANCE- PHOTOCOPIERS 836 . 00 18 , 039 . 45 28 , 000 . 00 24 , 500 . 00 * 73 . 6 01 - 120- 62-00-5437 ACCTG SYSTEM SERVICE FEE 652 . 50 13 , 584 . 62 15 , 000 . 00 151000 . 00 90 . 5 01-120-62-00-5438 CELLULAR TELEPHONE 86 . 12 910 . 87 950 . 00 990 . 00 * 92 . 0 TOTAL CONTRACTUAL SERVICES 2 , 024 . 62 420 , 457 . 58 270 , 450 . 00 297 , 947 . 00 141 . 1 PROFESSIONAL DEVELOPMENT 01 -120- 64-00-5600 DUES 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01 - 120- 64 -00-5603 SUBSCRIPTIONS/ BOOKS 0 . 00 215 . 00 250 . 00 0 . 00 * ( 100 . 0 ) 01-120- 64-00-5604 TRAINING & CONFERENCES 0 . 00 2 , 280 . 00 2 , 000 . 00 2 , 000 . 00 114 . 0 01 - 120- 64-00-5605 TRAVEL/ MEALS/ LODGING 0 . 00 694 . 86 3 , 000 . 00 1 , 500 . 00 * 46 . 3 TOTAL PROFESSIONAL DEVELOPMENT 0 . 00 31189 . 86 51250 . 00 3 , 500 . 00 91 . 1 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P6 DATE : 04 /23/ 2009 UNITED CITY OF YORKVILLE PAGE : 7 TIME : 13 : 52 : 14 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : GENERAL FUND FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED __ _ _ __________ ___ FINANCE OPERATIONS O1 -120- 65-00- 5800 CONTINGENCIES 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01 -120- 65-00-5801 FUND BALANCE RESERVE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01-120- 65-00- 5802 OFFICE SUPPLIES 247 . 91 10800 . 91 4 , 000 . 00 21500 . 00 * 72 . 0 01-120- 65-00-5804 OPERATING SUPPLIES 20 . 00 2 , 661 . 64 5 , 500 . 00 41500 . 00 * 59 . 1 01-120- 65- 00-5808 POSTAGE & SHIPPING 111 . 90 1 , 195 . 09 2 , 500 . 00 1 , 000 . 00 * 119 . 5 01 - 120- 65- 00-5844 MARKETING - HOTEL TAX 24 . 44 15 , 645 . 20 20 , 000 . 00 19 , 406 . 00 * 80 . 6 __--_ _ _ _ __ _ ________ TOTAL OPERATIONS 404 . 25 21 , 302 . 84 32 , 000 . 00 27 , 406 . 00 77 . 7 RETIREMENT 01 -120-72 - 00- 6500 IMRF PARTICIPANTS 21645 . 10 23 , 670 . 33 27 , 185 . 00 26 , 277 . 00 * 90 . 0 01 - 120-72- 00- 6501 SOCIAL SECURITY & MEDICARE 21513 . 03 23 , 636 . 54 26 , 048 . 00 26 , 139 . 00 * 90 . 4 ________-___ _ ___ _ TOTAL RETIREMENT 5 , 158 . 13 47 , 306 . 87 53 , 233 . 00 52 , 416 . 00 90 . 2 CAPITAL OUTLAY 01 -120-75-00-7002 COMPUTER EQUIP & SOFTWARE 287 . 38 41108 . 82 20 , 000 . 00 6 , 500 . 00 * 63 . 2 01 -120-75-00-7003 OFFICE EQUIPMENT 0 . 00 0 . 00 11000 . 00 0 . 00 * 0 . 0 _______-_ _ _______ _______ _ _ TOTAL CAPITAL OUTLAY 287 . 38 41108 . 82 21 , 000 . 00 61500 . 00 63 . 2 OTHER OPERATING EXPENSES 01-120-78-00- 9001 CITY TAX REBATE 0 . 00 11005 . 11 750 . 00 1 , 005 . 00 * 100 . 0 O1-120-78 -00- 9003 SALES TAX REBATE 215 , 083 . 55 554 , 554 . 53 620 , 000 . 00 500 , 000 . 00 * 110 . 9 01 -120-78- 00- 9004 BUSINESS DISTRICT REBATE 45 , 142 . 54 175 , 475 . 72 0 . 00 0 . 00 ( 100 . 0 ) 01 - 120-78-00- 9005 MERIT/COLA 0 . 00 0 . 00 13 , 165 . 00 0 . 00 * 0 . 0 01 - 120-76-00- 9013 AMUSEMNT TAX REBATE 0 . 00 61 , 095 . 90 74 , 250 . 00 61 , 096 . 00 * 99 . 9 01 -120-78-00- 9099 BAD DEBT 0 . 00 865 . 85 0 . 00 7 , 540 . 00 11 . 4 TOTAL OTHER OPERATING EXPENSES 260 , 226 . 09 792 , 997 . 11 708 , 165 . 00 569 , 641 . 00 139 . 2 TRANSFERS 01 -120- 99-00- 9925 TRANSFER TO SAN SEWER 0 . 00 112 , 500 . 00 1501000 . 00 150 , 000 . 00 75 . 0 01-120- 99-00- 9930 TRANSFER TO WATER IMPROVEMENT 0 . 00 150 , 000 . 00 200 , 000 . 00 200 , 000 . 00 75 . 0 01 -120-99-00-9935 TRANSFER TO LAND CASH 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01 -120- 99-00- 9940 TRANSFER TO PARK & RECREATION 1371178 . 52 11080 , 348 . 00 1 , 206 , 742 . 00 1 , 080 , 348 . 00 * 100 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P7 DATE : 04 /23 /2009 UNITED CITY OF YORKVILLE PAGE : 8 TIME : 13 : 52 : 14 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : GENERAL FUND FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED -------------------------------__ FINANCE EXPENSES TRANSFERS 01-120- 99-00- 9941 TRANSFER TO PARK & REC - LOAN 200 , 000 . 00 200 , 000 . 00 0 . 00 0 . 00 ( 100 . 0 ) 01-120- 99-00- 9945 TRANSFER TO GF FOR PD 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01-120-99-00- 9965 TRANSFER TO DEBT SERVICE 0 . 00 318 , 843 . 00 425 , 124 . 00 425 , 124 . 00 75 . 0 TOTAL TRANSFERS 337 , 178 . 52 11861 , 691 . 00 1 , 981 , 866 . 00 1 , 855 , 472 . 00 100 . 3 TOTAL EXPENSES : FINANCE 638 , 008 . 08 41416 , 327 . 85 4 , 598 , 950 . 00 4 , 307 , 487 . 00 102 . 5 COMMUNITY RELATIONS EXPENSES PERSONNEL SERVICES 01 - 130-50-00-5106 SALARIES -PUBLIC RELATIONS 7 , 500 . 00 59 , 938 . 41 59 , 662 . 00 65 , 000 . 00 92 . 2 01 - 130-50-00-5136 SALARIES- PART TIME 737 . 00 7 , 508 . 72 91880 . 00 9 , 880 . 00 75 . 9 TOTAL PERSONNEL SERVICES 81237 . 00 67 , 447 . 13 69 , 542 . 00 74 , 880 . 00 90 . 0 CONTRACTUAL SERVICES 01-130- 62-00-5401 CONTRACTUAL SERVICES 0 . 00 2 , 846 . 62 4 , 000 . 00 5 , 000 . 00 * 56 . 9 TOTAL CONTRACTUAL SERVICES 0 . 00 21846 . 62 4 , 000 . 00 5 , 000 00 56 . 9 PROFESSIONAL DEVELOPMENT 01 -130- 64-00- 5603 SUBSCRIPTIONS & BOOKS 0 . 00 0 . 00 400 . 00 400 . 00 0 . 0 01-130- 64-00- 5604 TRAINING & CONFERENCES 0 . 00 50 . 00 1 , 500 . 00 450 . 00 * 11 . 1 O1-130- 64-00- 5605 TRAVEL/MEALS/ LODGING 0 . 00 25 . 00 1 , 000 . 00 1 , 000 . 00 2 . 5 01-130- 64-00- 5607 PUBLIC RELATIONS 0 . 00 1 , 322 . 23 8 , 000 . 00 4 , 000 . 00 * 33 . 0 _ -_ ___ ----- TOTAL PROFESSIONAL DEVELOPMENT 0 . 00 1 , 397 . 23 10 , 900 . 00 51850 . 00 ? 3 . 8 OPERATIONS 01-130- 65-00-5802 OFFICE SUPPLIES 0 . 00 125 . 45 750 . 00 750 . 00 16 . 7 01-130- 65-00- 5808 POSTAGE & SHIPPING 6625 . 00 6 , 687 . 74 7 , 520 . 00 10 , 000 . 00 * 66 . 8 01-130- 65-00-5809 PRINTING & COPYING 0 . 00 1 , 009 . 66 14 , 000 . 00 8 , 000 . 00 * 12 . 6 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P8 DATE : 04 /23 / 2009 UNITED CITY OF YORKVILLE PAGE : 9 TIME : 13 : 52 : 14 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . W0W FUND : GENERAL FUND FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL % ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED __ _______________ _____ _ ___ ______ COMMUNITY RELATIONS EXPENSES OPERATIONS 01- 130- 65-00- 5810 PUBLISHING & ADVERTISING 0 . 00 71430 . 40 151000 . 00 16 , 000 . 00 * 46 . 4 TOTAL OPERATIONS 625 . 00 15 , 253 . 25 37t270 . 00 34 , 750 . 00 43 . 8 RETIREMENT 01-130-72-00- 6500 IMRF PARTICIPANTS 622 . 50 41754 . 21 4 , 747 . 00 4 , 973 . 00 * 95 . 6 01-130-72- 00- 6501 SOCIAL SECURITY & MEDICARE 630 . 14 5 , 333 . 61 5 , 474 . 00 51698 . 00 * 93 . 6 _-___ -__ -____ TOTAL RETIREMENT 1 , 252 . 64 10 , 087 . 82 101221 . 00 10 , 671 . 00 94 . 5 OTHER OPERATING EXPENSES 01 - 130-78 -00- 9005 MERIT/COLA 0 . 00 0 . 00 21366 . 00 0 . 00 * 0 . 0 01 -130-78 -00- 9010 COMMUNITY EVENTS 0 . 00 3 , 310 . 07 5 , 000 . 00 6 , 000 . 00 * 55 . 1 01 - 130-78-00-9013 HOLIDAY UNDER THE STARS 0 . 00 20 , 656 . 77 25 , 000 . 00 21 , 000 . 00 * 98 . 3 TOTAL OTHER OPERATING EXPENSES 0 . 00 23 , 968 . 84 32 , 386 . 00 27 , 000 . 00 88 . 7 TOTAL EXPENSES : COMMUNITY RELATIONS 10 , 114 . 64 121 , 000 . 89 - 1641319 . 00 158 , 151 . 00 76 . 5 ENGINEERING EXPENSES PERSONNEL SERVICES 01- 150-50- 00- 5107 SALARIES- ENGINEERING 48 , 370 . 29 386 , 514 . 15 406 , 935 . 00 426 , 262 . 00 * 90 . 6 01-150-50-00- 5137 SALARIES- OVERTIME 0 . 00 ( 99 . 21 ) 1 , 000 . 00 200 . 00 * ( 49 . 6 ) TOTAL PERSONNEL SERVICES 48 , 370 . 29 386 , 414 . 94 407 , 935 . 00 426 , 462 . 00 90 . 6 CONTRACTUAL SERVICES O1-150- 62 - 00-5401 CONTRACTUAL SERVICES 0 . 00 81015 . 58 301000 . 00 15 , 000 . 00 * 53 . 4 O1-150- 62- 00-5403 FEES 0 . 00 1 , 000 . 00 1 , 000 . 00 11000 . 00 100 . 0 01 - 150- 62- 00-5409 MAINTENANCE-VEHICLES 175 . 90 11038 . 22 21000 . 00 11000 . 00 * 103 . 8 01-150-62- 00-5410 MAINTENANCE-OFFICE EQUIP 0 . 00 0 . 00 1 , 000 . 00 200 . 00 * 0 . 0 01 - 150- 62 - 00-5411 MAINTENANCE-COMPUTERS 0 . 00 0 . 00 21000 . 00 0 . 00 * 0 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P9 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 10 TIME : 13 : 52 : 14 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : GENERAL FUND FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ________-__ -___-___ ____________ ________ ___ ________________________ ENGINEERING EXPENSES CONTRACTUAL SERVICES 01-150- 62-00- 5421 WEARING APPAREL 0 . 00 143 . 00 1 , 400 . 00 300 . 00 * 47 . 6 01 -150- 62-00-5438 CELLULAR TELEPHONE 301 . 42 21959 . 05 41100 . 00 31400 . 00 * 87 . 0 __ ___ _______________ ____ TOTAL CONTRACTUAL SERVICES 477 . 32 13 , 155 . 85 41 , 500 . 00 20 , 900 . 00 62 . 9 PROFESSIONAL DEVELOPMENT 01-150- 64 -00- 5600 DUES 0 . 00 285 . 00 600 . 00 300 . 00 * 95 . 0 01 - 150- 64-00- 5604 TRAINING & CONFERENCES ( 75 . 00 ) 417 . 00 21000 . 00 11000 . 00 * 41 . 7 01- 150- 64-00- 5605 TRAVEL EXPENSE 0 . 00 257 . 67 11000 . 00 500 . 00 * 51 . 5 01 - 150- 64-00- 5608 TUITION REIMBURSEMENT 0 . 00 1 , 491 . 95 21000 . 00 21000 . 00 74 . 5 01-150- 64-00- 5616 BOOKS & PUBLICATIONS 0 . 00 0 . 00 200 . 00 0 . 00 * 0 . 0 TOTAL PROFESSIONAL DEVELOPMENT ( 75 . 00 ) 2 , 451 . 62 5 , 800 . 00 3 , 800 00 64 . S OPERATIONS 01-150- 65-00- 5801 ENGINEERING SUPPLIES 46 . 01 688 . 72 2 , 500 . 00 11500 . 00 * 45 . 9 01-150- 65-00- 5802 OFFICE SUPPLIES 37 . 99 920 . 96 21000 . 00 21000 . 00 46 . 0 01 -150- 65-00- 5809 PRINTING & COPYING 196 . 54 1 , 389 . 90 21250 . 00 1 , 000 . 00 * 138 . 9 01 -150- 65-00-5816 ISWS GOUNDWTR STUDY 0 . 00 0 . 00 1 , 000 . 00 1 , 000 . 00 0 . 0 TOTAL OPERATIONS 280 . 54 2t999 . 58 71750 . 00 5 , 500 . 00 54 . 5 RETIREMENT 01-150-72-00- 6500 IMRF PARTICIPANTS 4 , 014 . 71 30 , 677 . 05 32 , 452 . 00 32 , 624 . 00 * 94 . 0 01-150-72-00- 6501 SOCIAL SECURITY & MEDICARE 3 , 669 . 63 29 , 274 . 74 32 , 283 . 00 321454 . 00 90 . 2 TOTAL RETIREMENT 7 , 684 . 39 59, 951 . 79 64 , 735 . 00 65 , 078 . 00 92 . 1 CAPITAL OUTLAY 01-150-75-00-7002 COMPUTER EQUIPMENT & SOFTWARE 550 . 59 1 , 396 . 36 4 , 100 . 00 3 , 500 . 00 * 39 . 8 01- 150-75-00- 7003 OFFICE EQUIPMENT 0 . 00 0 . 00 1 , 000 . 00 0 . 00 * 0 . 0 TOTAL CAPITAL OUTLAY 550 . 59 11396 . 36 5 , 100 . 00 3 , 500 . 00 39 . 8 OTHER OPERATING EXPENSE * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P10 DATE : 04 /23 /2009 UNITED CITY OF YORKVILLE PAGE : 11 TIME : 13 : 52 : 14 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . W0W FUND : GENERAL FUND FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED _____ _ _ _____________________________ ______ ENGINEERING EXPENSES OTHER OPERATING EXPENSE 01 - 150-78-00- 9005 MERIT/COLA 0 . 00 0 . 00 16 , 277 . 00 0 . 00 * 0 . 0 TOTAL OTHER OPERATING EXPENSE 0 . 00 0 . 00 16 , 277 . 00 0 . 00 0 . 0 TOTAL EXPENSES : ENGINEERING 57 , 288 . 08 466 , 370 . 14 549 , 097 . 00 525 , 240 . 00 88 . 7 PUBLIC SAFETY/POLICE DEPT . EXPENSES PERSONNEL SERVICES O1-210-50-00-5107 SALARIES- POLICE 150 , 328 . 63 11179 , 732 . 43 1 , 181 , 811 . 00 11231 , 043 . 00 * 95 . 8 01-210-50-00-5131 SALARIES- CHIEF/LT . /SERGT . 80 , 516 . 63 630 , 668 . 32 705 , 227 . 00 691 , 041 . 00 * 91 . 2 O1 -210-50-00-5134 SALARIES- CROSSING GUARD 21848 . 50 16 , 550 . 00 26 , 350 . 00 26 , 350 . 00 70 . 3 01 -210-50-00-5135 SALARIES- POLICE CLERKS 25 , 453 . 52 196 , 140 . 73 202 , 535 . 00 213 , 581 . 00 * 91 . 8 01-210-50- 00-5136 SALARIES- PART TIME 51589 . 60 27 , 179 . 85 30 , 000 . 00 39 , 000 . 00 * 69 . 6 01-210-50-00-5137 SALARIES- OVERTIME 7 , 399 . 54 49 , 622 . 61 701000 . 00 60 , 000 . 00 * 83 . 0 01-210-50-00- 5200 CADET PROGRAM 595 . 00 20 , 026 . 61 36 , 000 . 00 30 , 000 . 00 * 66 . 7 _--__ _ __ _ __ _ ________ TOTAL PERSONNEL SERVICES 272 , 731 . 42 21122 , 120 . 55 2 , 251 , 923 . 00 2 , 291 , 015 . 00 92 . 6 PROFESSIONAL SERVICES 01 -210- 61-00-5300 LEGAL SERVICES 0 . 00 1 , 079 . 46 10 , 000 . 00 4 , 000 . 00 * 26 . 9 __ _ __ _ ___ -__ _-__ TOTAL PROFESSIONAL SERVICES 0 . 00 1 , 079 . 46 10 , 000 . 00 41000 . 00 26 . 9 CONTRACTUAL SERVICES 01-210-62-00-5408 MAINTENANCE - EQUIPMENT 1 , 862 . 95 12 , 903 . 75 15 , 000 . 00 14 , 000 . 00 * 92 . 1 01-210- 62- 00- 5409 MAINTENANCE - VEHICLES 61522 . 19 32 , 364 . 94 40 , 000 . 00 37 , 000 . 00 * 87 . 4 01-210- 62- 00-5410 MAINT-OFFICE EQUIPMENT 0 . 00 0 . 00 5 , 000 . 00 0 . 00 * 0 . 0 01 -210- 62-00- 5411 MAINTENANCE - COMPUTERS 0 . 00 41811 . 65 10 , 000 . 00 4 , 812 . 00 * 99 . 9 01-210- 62-00-5412 MAINTENANCE- K9 79 . 40 462 . 82 21000 . 00 11000 . 00 * 46 . 2 01-210- 62-00-5414 WEATHER WARNING SIREN MAINT 0 . 00 41348 . 45 6 , 930 . 00 6 , 930 . 00 62 . 7 01-210- 62 -00-5421 WEARING APPAREL 21146 . 76 13 , 162 . 23 33 , 000 . 00 16 , 000 . 00 * 73 . 1 01-210- 62-00-5422 COPS GRANT IV - VESTS 0 . 00 11212 . 36 8 , 000 . 00 3 , 000 . 00 * 40 . 4 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P11 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 12 TIME : 13 : 52 : 14 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : GENERAL FUND FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL a ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED --------------------------------------------------------------- ----------------------------------------------------- ---------------- PUBLIC SAFETY/ POLICE DEPT . EXPENSES CONTRACTUAL SERVICES 01 -210- 62 -00-5429 PSYCHOLOGICAL TESTING 0 . 00 0 . 00 21000 . 00 0 . 00 0 . 0 01-210- 62 -00-5430 HEALTH SERVICES 0 . 00 154 . 00 61000 . 00 500 . 00 * 30 . 8 01-210- 62 -00-5431 LABORATORY FEES 0 . 00 0 . 00 2 , 000 . 00 500 . 00 * 0 . 0 01-210- 62 -00-5432 KENDALL CO . JUVENILE PROBATION 0 . 00 21684 . 89 3 , 000 . 00 2 , 685 . 00 * 99 . 9 01 -210- 62 -00-5436 TELEPHONE 1 , 941 . 45 18 , 521 . 39 23 , 000 . 00 21 , 500 . 00 * 86 . 1 01 -210- 62 -00-5438 CELLULAR TELEPHONE 1 , 725 . 38 15 , 295 . 91 19 , 420 . 00 17 , 920 . 00 * 85 . 3 01 -210- 62 -00-5441 MTD-ALERTS FEE 0 . 00 5 , 676 . 00 12 , 000 . 00 51838 . 00 * 97 . 2 01-210- 62 -00-5442 NEW WORLD LIVE SCAN 5 , 335 . 78 12 , 320 . 04 8 , 634 . 00 81000 . 00 * 154 . 0 01 -210- 62 -00- 5443 ADMIN ADJUDICATION CONTRACTUAL 1 , 525 . 00 71650 . 00 0 . 00 0 . 00 ( 100 . 0 ) TOTAL CONTRACTUAL SERVICES 21 , 138 . 91 131 , 568 . 63 195 , 984 . 00 141 , 685 . 00 92 . 8 PROFESSIONAL DEVELOPMENT 01 -210- 64 -00- 5600 DUES 535 . 00 11395 . 00 4 , 000 . 00 21000 . 00 * 69 . 7 01 -210- 64 -00- 5603 SUBSCRIPTIONS 100 . 00 329 . 20 600 . 00 350 . 00 * 94 . 0 01 -210- 64 -00- 5604 TRAINING & CONFERENCE 1 , 345 . 00 14 , 126 . 30 33 , 025 . 00 18 , 025 . 00 * 78 . 3 01-210- 64 -00-5605 TRAVEL EXPENSES 892 . 58 5 , 001 . 56 12 , 075 . 00 7 , 575 . 00 * 66 . 0 01-210- 64 -00-5606 COMMUNITY RELATIONS 43 . 73 11991 . 10 10 , 000 . 00 31250 . 00 * 661 . 2 01-210- 64 -00-5607 POLICE COMMISSION 0 . 00 7 , 642 . 36 25 , 000 . 00 10 , 000 . 00 * 76 . 4 01-210- 64 -00-5608 TUITION REIMBURSEMENT 0 . 00 3 , 202 . 57 10 , 000 . 00 4 , 500 . 00 * 71 . 1 01 -210- 64 -00-5609 POLICE RECRUIT ACADEMY 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01-210- 64 -00-5610 GUN RANGE FEES 500 . 00 500 . 00 1 , 000 . 00 500 . 00 * 100 . 0 01 -210- 64-00- 5611 SRT FEE 0 . 00 31500 . 00 41000 . 00 30500 . 00 * 100 . 0 01 -210- 64-00- 5612 NEIGHBORHOOD WATCH 0 . 00 11238 . 81 1 , 500 . 00 1 , 500 . 00 82 . 5 01-210- 64-00- 5613 CITIZENS POLICE ACADEMY 0 . 00 532 . 43 2 , 500 . 00 1 , 775 . 00 * 29 . 9 01-210- 64 -00- 5614 CHAPLAIN PROGRAM 0 . 00 0 . 00 400 . 00 0 . 00 * O . 0 01-210- 64 -00- 5615 COMPLIANCE CHECKS ( 75 . 91 ) 115 . 14 500 . 00 500 . 00 23 . 0 01 -210- 64 -00- 5616 DARE PROGRAM 0 . 00 0 . 00 5 , 250 . 00 3 , 000 . 00 * 0 . 0 TOTAL PROFESSIONAL DEVELOPMENT 3 , 340 . 40 39 , 574 . 47 109 , 850 . 00 56f475 . 00 70 . 0 OPERATIONS 01 -210- 65-00-5802 OFFICE SUPPLIES ( 97 . 98 ) 3 , 593 . 54 9 , 000 . 00 4 , 700 . 00 * 76 . 4 01-210- 65-00-5803 EVIDENCE TECH SUPPLIES 25 . 23 1 , 500 . 00 21500 . 00 11500 . 00 * 100 . 0 01-210- 65-00-5804 OPERATING SUPPLIES 240 . 05 11 , 538 . 56 19 , 500 . 00 14 , 500 . 00 * 79 . 5 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P12 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 13 TIME : 13 : 52 : 14 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : GENERAL FUND FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ----_-_ _-------__ _ -__ _ _ __ -_ __ _ PUBLIC SAFETY/POLICE DEPT . EXPENSES OPERATIONS 01-210- 65-00-5808 POSTAGE & SHIPPING 10 . 52 1 , 347 . 16 51250 . 00 3 , 750 . 00 * 35 . 9 01-210- 65-00-5809 PRINTING & COPYING 70 . 54 4 , 368 . 94 7 , 500 . 00 51000 . 00 * 87 . 3 01-210- 65-00-5810 PUBLISHING & ADVERTISING 0 . 00 455 . 12 2 , 000 . 00 500 . 00 * 91 . 0 01-210- 65-00-5812 GASOLINE 5 , 321 . 10 71 , 616 . 26 80 , 000 . 00 100 , 000 . 00 * 71 . 6 O1 -210- 65-00-5813 AMMUNITION 0 . 00 0 . 00 6 , 300 . 00 800 . 00 * 0 . 0 01 -210- 65- 00-5814 ADMIN ADJUDICATION OPERATING 0 . 00 106 . 96 0 . 00 0 . 00 ( 100 . 0 ) _-__------_ _ __ __ __ -__------ TOTAL OPERATIONS 5 , 569 . 46 94 , 526 . 54 132 , 050 . 00 1301750 . 00 72 . 2 RETIREMENT 01-210-72- 00- 6500 IMRF PARTICIPANTS 2 , 113 . 86 15 , 511 . 22 18 , 272 . 00 18 , 272 . 00 84 . 8 01 -210-72-00- 6501 SOCIAL SECURITY & MEDICARE 20 , 960 . 46 161 , 139 . 44 174 , 135 . 00 174 , 135 . 00 92 . 5 01-210-72-00- 6502 POLICE PENSION 0 . 00 297 , 327 . 74 300 , 000 . 00 300 , 000 . 00 99 . 1 TOTAL RETIREMENT 23 , 074 . 32 473 , 978 . 40 492 , 407 . 00 492 , 407 . 00 96 . 2 CAPITAL OUTLAY 01 -210-75- 00-7002 COMPUTER EQUIP & SOFTWARE 11507 . 77 6 , 965 . 00 10 , 000 . 00 7 , 000 . 00 * 99 . 5 ---------------- _ __ -_ _ ___ TOTAL CAPITAL OUTLAY 11507 . 77 61965 . 00 10 , 000 . 00 7 , 000 . 00 99 . 5 OTHER OPERATING EXPENSES 01 -210-78- 00- 9004 BIKE PATROL 0 . 00 0 . 00 1 , 000 . 00 0 . 00 * 0 . 0 01-210-78- 00- 9005 MERIT/COLA 0 . 00 0 . 00 36 , 310 . 00 21620 . 00 * 0 . 0 01-210-78-00- 9006 K9 STIPEND 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 -__ _ _ _ ----- -------------- __ TOTAL OTHER OPERATING EXPENSES 0 . 00 0 . 00 37 , 310 . 00 21620 . 00 0 . 0 TOTAL EXPENSES : PUBLIC SAFETY/POLICE DEPT . 327 , 362 . 28 2 , 869 , 813 . 05 3 , 239 , 524 . 00 3 , 125 , 952 . 00 91 . 8 PLANNING & DEVELOPMENT EXPENSES PERSONNEL SERVICES * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P13 DATE : 04 /23 /2009 UNITED CITY OF YORKVILLE PAGE : 14 TIME : 13 : 52 : 14 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : GENERAL FUND FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL 3 ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ___ _ ---------------- - ----------------------------------------------------- PLANNING & DEVELOPMENT EXPENSES PERSONNEL SERVICES 01 -220-50-00- 5107 SALARIES- PLANNING & DEV . 35 , 075 . 59 311 , 147 . 88 340 , 955 . 00. 355 , 245 . 00 87 . 5 TOTAL PERSONNEL SERVICES 35 , 075 . 59 311 , 147 . 88 340 , 955 . 00 355 , 245 . 00 87 . 5 PROFESSIONAL SERVICES O1 -220- 61-00-5300 LEGAL SERVICES 160 . 60 2 , 452 . 39 20 , 000 . 00 4 , 000 . 00 * 61 . 3 -----_---__ ___-_-___ _--_ TOTAL PROFESSIONAL SERVICES 160 . 60 2 , 452 . 39 20 , 000 . 00 4 , 000 . 00 61 . 3 CONTRACTUAL SERVICES 01 -220- 62-00-5401 CONTRACTUAL SERVICES 607 . 65 16 , 112 . 45 30 , 000 . 00 11 , 100 . 00 * 145 . 1 01 -220- 62-00-5430 PLANNING CONSULTANT 0 . 00 0 . 00 50 , 000 . 00 0 . 00 * 0 . 0 01 -220- 62-00-5432 ECONOMIC DEVELOPMENT 0 . 00 45 , 000 . 00 45 , 000 . 00 45 , 000 . 00 100 . 0 01-220- 62-00- 5438 CELLULAR TELEPHONE 126 . 11 11195 . 77 1 , 500 . 00 1 , 440 . 00 * 83 . 0 TOTAL CONTRACTUAL SERVICES 733 . 76 62 , 308 . 22 126 , 500 . 00 57 , 540 . 00 108 . 2 PROFESSIONAL DEVELOPMENT 01-220- 64 -00- 5600 DUES 0 . 00 965 . 00 11500 . 00 1 , 000 . 00 * 96 . 5 01 -220- 64 -00-5604 TRAINING & CONFERENCES 187 . 64 2 , 001 . 22 51000 . 00 1 , 850 . 00 * 108 . 1 01 -220- 64-00-5605 TRAVEL EXPENSE 0 . 00 417 . 68 2 , 000 . 00 200 . 00 * 208 . 8 TOTAL PROFESSIONAL DEVELOPMENT 187 . 64 3 , 383 . 90 8 , 500 00 31050 . 00 110 . 9 OPERATIONS 01-220- 65-00- 5604 OPERATING SUPPLIES 218 . 14 21995 . 41 81000 . 00 51000 . 00 * 59 . 9 01 -220- 65-00- 5809 PRINTING & COPYING 213 . 42 651 . 26 1 , 500 . 00 500 . 00 * 130 . 2 01-220- 65-00- 5810 PUBLISHING & ADVERTISING 0 . 00 14 . 00 1 , 500 . 00 1 , 500 . 00 0 . 9 01 -220- 65-00- 5814 BOOKS & MAPS 0 . 00 762 . 93 2 , 000 . 00 500 . 00 * 152 . 5 TOTAL OPERATIONS 431 . 56 4 , 423 . 60 13 , 000 . 00 7 , 500 . 00 56 . 9 RETIREMENT 01-220-72- 00- 6500 IMRF PARTICIPANTS 2 , 912 . 39 24 , 645 . 84 27 , 126 . 00 27 , 176 . 00 * 90 . 6 01 -220-72- 00- 6501 SOCIAL SECURITY & MEDICARE 2 , 667 . 06 23 , 665 . 93 26 , 985 . 00 27 , 034 . 00 * 87 . 5 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P14 DATE : 04 /23 /2009 UNITED CITY OF YORKVILLE PAGE : 15 TIME : 13 : 52 : 14 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . W0W FUND : GENERAL FUND FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL o ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED -----__ _ _- _ __-_ TOTAL RETIREMENT 5 , 579 . 45 48 , 311 . 77 54 , 111 . 00 54 , 210 . 00 89 . 1 CAPITAL OUTLAY O1-220-75-00-7002 COMPUTER EQUIP & SOFTWARE 0 . 00 5 , 528 . 06 6 , 000 . 00 5 , 700 . 00 * 96 . 9 01-220-75-00-7003 OFFICE EQUIPMENT 0 . 00 0 . 00 11000 . 00 50 . 00 * 0 . 0 O1-220-75-00-7004 IL TOMORROW GRANT MATCH 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL CAPITAL OUTLAY 0 . 00 51528 . 06 71000 . 00 51750 . 00 96 . 1 OTHER OPERATING EXPENSE 01-220-78-00- 9005 MERIT/COLA 0 . 00 0 . 00 13 , 638 . 00 0 . 00 0 . 0 O1 -220-78- 00- 9012 SALARY SURVEY 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL OTHER OPERATING EXPENSE 0 . 00 0 . 00 13 , 638 . 00 0 . 00 0 . 0 TOTAL EXPENSES : PLANNING & DEVELOPMENT 42 , 168 . 60 437 , 555 . 82 583 , 704 . 00 487 , 295 . 00 89 . 7 STREETS EXPENSES PERSONNEL SERVICES 01 - 410-50-00-5107 SALARIES- STREETS 28 , 934 . 02 233 , 957 . 83 240 , 825 . 00 253 , 530 . 00 * 92 . 2 01 - 410-50- 00-5136 SALARIES- PART TIME 0 . 00 6 , 752 . 00 10 , 000 . 00 71000 . 00 * 96 . 4 O1 -410-50-00-5137 SALARIES- OVERTIME 3 , 920 . 24 35 , 409 . 61 15 , 000 . 00 11 , 328 . 00 * 312 . 5 TOTAL PERSONNEL SERVICES 32 , 854 . 26 2761119 . 44 265 , 825 . 00 271 , 858 . 00 101 . 5 PROFESSIONAL SERVICES 01-410- 61-00- 5313 ENGINEERING - IN TOWN RD PROG 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01 - 410- 61-00- 5314 INSPECTIONS & LICENSES 0 . 00 595 . 00 400 . 00 100 . 00 * 595 . 0 TOTAL PROFESSIONAL SERVICES 0 . 00 595 . 00 400 . 00 100 . 00 595 . 0 CONTRACTUAL SERVICES 01-410- 62 -00-5401 CONTRACTUAL SERVICES 131 . 67 987 . 51 2 , 000 . 00 1 , 000 . 00 * 98 . 7 01-410- 62-00- 5408 MAINTENANCE-EQUIPMENT 1 . 13 4 , 205 . 04 9 , 000 . 00 5 , 000 . 00 * 84 . 1 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P15 DATE : 04 /23 /2009 UNITED CITY OF YORKVILLE PAGE : 16 TIME : 13 : 52 : 14 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B300D . WOW FUND : GENERAL FUND FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL 's ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ----------------------------' STREETS EXPENSES CONTRACTUAL SERVICES 01 -410- 62-00-5409 MAINTENANCE-VEHICLES ( 10 . 00 ) 9 , 407 . 60 18 , 000 . 00 10 , 000 . 00 * 94 . 0 01 -410- 62- 00-5414 MAINTENANCE-TRAFFIC SIGNALS 73 . 92 31023 . 18 15 , 000 . 00 14 , 436 . 00 * 20 . 9 01 - 410- 62-00- 5415 MAINTENANCE-STREET LIGHTS ( 169 . 30 ) 8 , 679 . 03 20 , 000 . 00 181000 . 00 * 48 . 2 01 -410- 62-00-5416 MAINTENANCE PROPERTY 384 . 40 26 , 503 . 44 0 . 00 21 , 000 . 00 * 126 . 2 01 - 410- 62-00-5420 MAINTENANCE-STORM SEWER 0 . 00 151 . 32 10 , 000 . 00 2 , 000 . 00 * 7 . 5 01 -410- 62-00-5421 WEARING APPAREL 100 . 10 1 , 706 . 68 41150 . 00 2 , 114 . 00 * 80 . 7 01-410- 62-00-5422 RAYMOND DETENTION BASE 0 . 00 3 , 557 . 83 _ 0 . 00 3 , 825 . 00 * 93 . 0 01 -410- 62-00-5423 RAYMOND STORM SEWER OUTFLOW 695 . 00 1 , 034 . 00 0 . 00 0 . 00 ( 100 . 0 ) 01-410-62-00-5424 RAYMOND STORM SW . TER 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01-410- 62-00-5434 RENTAL-EQUIPMENT 0 . 00 0 . 00 1 , 000 . 00 11000 . 00 0 . 0 01- 410- 62-00-5435 ELECTRICITY 11 , 591 . 68 99 , 405 . 20 78 , 120 . 00 73 , 526 . 00 * 135 . 1 01-410-62-00- 5438 CELLULAR TELEPHONE 258 . 36 2 , 352 . 65 3 , 300 . 00 2 , 880 . 00 * 81 . 6 01- 410- 62-00- 5440 STREET LIGHTING 0 . 00 226 . 00 1 , 000 . 00 230 . 00 * 98 . 2 -_____ __ _-_ _ ___ TOTAL CONTRACTUAL SERVICES 13 , 056 . 96 161 , 239 . 48 1611570 . 00 155 , 011 . 00 104 . 0 PROFESSIONAL DEVELOPMENT 01-410- 64 -00-5604 TRAINING & CONFERENCES 0 . 00 734 . 00 4 , 500 . 00 1 , 000 . 00 * 73 . 4 ------- ----------------- ____------------- ------_--------- -------- TOTAL PROFESSIONAL DEVELOPMENT 0 . 00 734 . 00 41500 . 00 1 , 000 . 00 73 . 4 OPERATIONS 01 -410- 65-00-5804 OPERATING SUPPLIES 874 . 01 51161 . 92 15 , 000 . 00 14 , 435 . 00 * 35 . 7 01 -410- 65-00-5812 GASOLINE 2 , 070 . 60 30 , 583 . 94 33 , 275 . 00 31 , 332 . 00 * 97 . 6 01 -410- 65-00-5815 HAND TOOLS 0 . 00 759 . 42 1 , 500 . 00 1 , 500 . 00 50 . 6 01 -410- 65-00-5817 GRAVEL 0 . 00 1 , 913 . 62 21500 . 00 2 , 155 . 00 * 88 . 7 TOTAL OPERATIONS 2 , 944 61 38 , 418 90 52f275 . 00 49 , 422 . 00 77 . 7 RETIREMENT 01 - 410-72 -00- 6500 IMRF PARTICIPANTS 2 , 726 . 87 21 , 459 . 84 20 , 308 . 00 19 , 395 . 00 * 110 . 6 01 -410-72-00- 6501 SOCIAL SECURITY & MEDICARE 2 , 498 . 71 21 , 018 . 30 20 , 962 . 00 19 , 294 . 00 * 106 . 9 TOTAL RETIREMENT 5 , 225 . 58 42 , 478 . 14 41 , 270 . 00 38 , 689 . 00 109 . 7 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P16 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 17 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . W0W FUND : GENERAL FUND FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL °- ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED _ __________________ _ _ STREETS CAPITAL OUTLAY 01-410-75-00- 4404 HANGING BASKETS 0 . 00 1 , 825 . 00 21000 . 00 11825 . 00 * 100 . 0 01-410-75-00-5418 MOSQUITO CONTROL 0 . 00 29 , 832 . 00 30 , 000 . 00 29 , 832 . 00 * 100 . 0 01 - 410-75-00-7004 SAFETY EQUIPMENT 0 . 00 441 . 30 1 , 000 . 00 500 . 00 * 88 . 2 O1 -410-75-00-7101 IN TOWN ROAD PROGRAM 0 . 00 45 . 56 0 . 00 0 . 00 ( 100 . 0 ) 01 -410-75- 00-7102 TREE & STUMP REMOVAL 0 . 00 40990 . 00 51000 . 00 5 , 000 . 00 99 . 8 01 -410-75-00-7103 SIDEWALK CONSTRUCTION 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 01 -410-75-00-7104 SSA EXPENSE-FOX HILL SUNFLOWER 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 _______ __________ _ _ ___________ __ TOTAL CAPITAL OUTLAY 0 . 00 37 , 133 . 86 38 , 000 . 00 37 , 157 . 00 99 . 9 OTHER OPERATING EXPENSES 01 -410-78- 00- 9005 MERIT/COLA 0 . 00 0 . 00 9 , 633 . 00 0 . 00 0 . 0 01-410-78-00- 9010 PARKWAY TREE PROGRAM ( 443 . 00 ) ( 443 . 00 ) 0 . 00 0 . 00 ( 100 . 0 ) TOTAL OTHER OPERATING EXPENSES ( 443 . 00 ) ( 443 . 00 ) 9 , 633 . 00 0 . 00 ( 100 . 0 ) TRANSFERS 01-410- 99-00- 9930 TRANSFER TO WATER IMPROVEMENT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 _______ _ _ _ _ _________ _ TOTAL TRANSFERS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL EXPENSES : STREETS 53 , 638 . 41 556 , 275 . 82 573 , 473 . 00 553 , 237 . 00 100 . 5 HEALTH & SANITATION EXPENSES CONTRACTUAL SERVICES 01-540- 62-00-5442 GARBAGE SERVICES 93 , 373 . 49 933 , 754 . 57 1 , 3001000 . 00 1 , 120 , 000 . 00 83 . 3 01-540- 62-00-5443 LEAF PICKUP 0 . 00 51640 . 00 6 , 000 . 00 61000 . 00 94 . 0 TOTAL CONTRACTUAL SERVICES 93 , 373 . 49 939 , 394 . 57 1 , 306 , 000 . 00 1 , 1261000 . 00 83 . 4 TOTAL EXPENSES : HEALTH & SANITATION 93 , 373 . 49 939 , 394 . 57 1 , 3061000 . 00 11126 , 000 . 00 83 . 4 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P17 DATE : 04 /23 /2009 UNITED CITY OF YORKVILLE PAGE : 18 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : GENERAL FUND FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL % ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ---------------------------- --------------------------------------------------- ---------- ------ ------------------------------------- TOTAL FUND REVENUES 926 , 392 . 46 9 , 352 , 959 . 70 12 , 731 , 770 . 00 101913 , 842 . 00 85 . 6 TOTAL FUND EXPENSES 1 , 379 , 088 . 04 11 , 415 , 448 . 78 13 , 331 , 770 . 00 12 , 003 , 730 . 00 95 . 0 FUND SURPLUS ( DEFICIT ) ( 452 , 695 . 58 ) ( 21062 , 489 . 08 ) ( 6001000 . 00 ) ( 11089 , 888 . 00 ) 189 . 2 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P18 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 19 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : FOX, HILL SSA FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED _____---_ _ _ _________ __ GENERAL REVENUES TAXES 11 -000-40-00- 4002 FOX HILL LEVY 0 . 00 6 , 352 . 59 6 , 376 . 00 61376 . 00 99 . 6 _-__ _ __ __-__ _ TOTAL TAXES 0 . 00 6, 352 . 59 61376 . 00 61376 . 00 99 . 6 EXPENSES OPERATIONS 11-000- 65-00- 5416 MAINTENANCE COMMON GROUNDS 120 . 00 20 , 012 . 46 61376 . 00 19 , 892 . 00 * 100 . 6 TOTAL OPERATIONS 120 . 00 20 , 012 . 46 61376 . 00 19 , 892 . 00 100 . 6 TOTAL FUND REVENUES 0 . 00 61352 . 59 6 , 376 . 00 6 , 376 . 00 99 . 6 TOTAL FUND EXPENSES 120 . 00 20 , 012 . 46 6 , 376 . 00 19 , 892 . 00 100 . 6 FUND SURPLUS ( DEFICIT ) ( 120 . 00 ) ( 13 , 659 . 87 ) 0 . 00 ( 13 , 516 . 00 ) 101 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P19 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 20 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : SUNFLOWER SSA FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ------------------ --_--_--_-____-___--_-_-- -------- ----------------------_-----____-___---___--_---_--------------- GENERPL REVENUES TAXES 19 -000-40-00- 4002 SUNFLOWER LEVY 0 . 00 15 , 938 . 84 15 , 925 . 00 15 , 925 . 00 100 . 0 TOTAL TAXES 0 . 00 15 , 938 . 84 15 , 925 . 00 15 , 925 . 00 100 . 0 EXPENSES OPERATIONS 12 -000-65-00- 5416 MAINTENANCE COMMON GROUNDS 1? 1 . 60 13 , 989 . 80 15 , 925 . 00 15 , 925 . 00 87 . 8 -------------- --------------------------------------- ___------- TOTAL OPERATIONS 121 . 60 13 , 989 . 80 15 , 925 . 00 15 , 925 . 00 87 . 8 TOTAL FUND REVENUES 0 . 00 15 , 938 . 84 15 , 925 . 00 15 , 925 . 00 100 . 0 TOTAL FUND EXPENSES 121 . 60 13 , 989 . 80 15 , 925 . 00 15 , 925 . 00 87 . 8 FUND SURPLUS ( DEFICIT ) ( 121 . 60 ) 1 , 949 . 04 0 . 00 0 . 00 100 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P20 DATE : 04 /23/ 2009 UNITED CITY OF YORKVILLE PAGE : 21 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : MOTOR FUEL TAX FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ______ ______________ ___ __ _____ __ _____ GENERAL REVENUES TAXES 15 -000-40-00-3999 CARRY OVER BALANCE 0 . 00 0 . 00 118 , 520 . 00 336 , 488 . 00 * 0 . 0 15-000-40- 00-4060 MOTOR FUEL TAX ALLOTMENTS 26 , 129 . 70 232 , 289 . 69 325 , 000 . 00 252 , 500 . 00 * 91 . 9 _ ________ __ ___ __ _ _____ TOTAL TAXES 26 , 129 . 70 232 , 289 . 69 443 , 520 . 00 568 , 988 . 00 39 . 4 MISCELLANEOUS 15-000- 44 -00- 4401 GAME FARM ROAD DESIGN 0 . 00 0 . 00 157 , 000 . 00 157 , 000 . 00 0 . 0 15-000-44 -00-4490 MISC . INCOME 175 . 50 175 . 50 0 . 00 0 . 00 100 . 0 ________ __ __ _ _ __ TOTAL MISCELLANEOUS 175 . 50 175 . 50 157 , 000 . 00 157 , 000 . 00 0 . 1 INTEREST 15-000- 46-00-4600 INVESTMENT INCOME 87 . 04 4 , 657 . 85 14 , 000 . 00 6 , 600 . 00 73 . 6 TOTAL INTEREST 87 . 04 4f857 . 85 14 , 000 . 00 61600 . 00 73 . 6 TOTAL REVENUES : GENERAL 26 , 392 . 24 237 , 323 . 04 614 , 520 . 00 752 , 588 . 00 31 . 5 EXPENSES OPERATIONS 15-000-65-00- 5800 CONTINGENCY 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 15-000- 65-00-5818 SALT 0 . 00 2271296 . 02 86 , 000 . 00 86 , 000 . 00 264 . 2 15-000- 65-00-5825 GEO MELT 71197 . 60 13 , 200 . 00 0 . 00 0 . 00 ( 100 . 0 ) TOTAL OPERATIONS 7 , 197 . 60 240 , 496 . 02 86 , 000 . 00 86 , 000 . 00 279 . 6 CAPITAL OUTLAY 15-000-75-00-7007 SIGNS 183 . 11 10 , 221 . 34 14 , 550 . 00 14 , 550 . 00 70 . 2 15-000-75-00-7008 CRACK FILLING 0 . 00 26 , 549 . 10 20 , 000 . 00 20 , 000 . 00 132 . 7 15-000-75- 00-7106 GAME FARM SURVEYING 0 . 00 99 , 753 . 07 68 , 000 . 00 158 , 800 . 00 * 62 . 8 15-000-75- 00-7107 CONSTRUCTION ENGINEERING 0 . 00 0 . 00 314 , 000 . 00 314 , 000 . 00 0 . 0 15-000-75-00-7110 COLD PATCH 3 , 018 . 90 3 , 546 . 90 31720 . 00 3 , 720 . 00 95 . 3 15-000-75-00-7111 HOT PATCH 0 . 00 0 . 00 81250 . 00 8 , 250 . 00 0 . 0 15-000-75-00-7112 VAN EMMON 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P21 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 22 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : MOTOR FUEL TAX FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL a ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED _________________________________ _____________________________________________ GENERAL EXPENSES CAPITAL OUTLAY 15-000-75-00-7113 COUNTRYSIDE PKWY CONSTRUCTION 0 . 00 81380 . 46 0 . 00 0 . 00 ( 100 . 0 ) 15-000-75-00-7114 ROUTE 126/71 TRAFFIC SIGNALS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 15 -000-75- 00-7115 PALMER COURT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 15-000-75-00-7116 WOOD DALE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 15-000-75- 00-7117 FAXON ROAD ROW ACQ 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 15 -000-75-00-7118 RT 34 & SYCAMORE TRAFFIC SGNL 0 . 00 15 , 337 . 85 0 . 00 0 . 00 ( 100 . 0 ) 15-000-75-00-7119 GAME FARM ROW 0 . 00 0 . 00 100 , 000 . 00 100 , 000 . 00 0 . 0 15-000-75-00-7120 FOX ROAD 0 . 00 9 , 900 . 00 0 . 00 0 . 00 ( 100 . 0 ) TOTAL CAPITAL OUTLAY 3 , 202 . 01 173 , 688 . 72 528 , 520 . 00 619 , 320 00 28 . 0 TOTAL EXPENSES : GENERAL 10 , 399 . 61 414 , 184 . 74 614 , 520 . 00 705 , 320 . 00 58 . 7 TOTAL FUND REVENUES 26 , 392 . 24 237 , 323 . 04 614 , 520 . 00 752 , 588 . 00 31 . 5 TOTAL FUND EXPENSES 10 , 399 . 61 414 , 184 . 74 614 , 520 . 00 7051320 . 00 56 . 7 FUND SURPLUS ( DEFICIT ) 15 , 992 . 63 ( 1761861 . 70 ) 0 . 00 47 , 268 . 00 ( 374 . 1 ) * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P22 DATE : 04 /23 / 2009 UNITED CITY OF YORKVILLE PAGE : 23 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : MUNICIPAL BUILDING FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED __ ____ _ GENERAL REVENUES CARRY OVER 16-000- 40-00-3999 CARRY OVER BALANCE 0 . 00 0 . 00 0 . 00 ( 5141524 . 00 ) * 0 . 0 TOTAL CARRY OVER 0 . 00 0 . 00 0 . 00 ( 514 , 524 . 00 ) 0 . 0 CHARGES FOR SERVICES 16-000-42- 00-4211 DEVELOPMENT FEES-BUILDING 750 . 00 12 , 750 . 00 100 , 000 . 00 22 , 000 . 00 * 57 . 9 16-000-42- 00-4215 BEECHER RENTAL FEE 0 . 00 0 . 00 0 . 00 61000 . 00 * 0 . 0 --__ _ _ -_ __---- TOTAL CHARGES FOR SERVICES 750 . 00 12 , 750 . 00 100 , 000 . 00 28 , 000 . 00 45 . 5 MISCELLANEOUS 16-000- 44 - 00- 4400 BEECHER CENTER DONATIONS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL MISCELLANEOUS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TRANSFERS 16-000-49- 00- 4901 TRANSFER FROM GENERAL FUND 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 16-000- 49- 00- 4902 TRANSFER FROM LAND ACQUISITION 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL TRANSFERS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL REVENUES : GENERAL 750 . 00 12 , 750 . 00 100 , 000 . 00 ( 486 , 524 . 00 ) ( 2 . 6 ) EXPENSES CONTRACTUAL SERVICES 16-000- 62 -00-5416 MAINT-GENERAL BLDG & GROUNDS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 __ _ -_ __ -_ _ TOTAL CONTRACTUAL SERVICES 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 CAPITAL OUTLAY 16-000-75- 00-7008 ENTRY WAY SIGNS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 16-000-75-00-7200 BLDG IMPROV- BEEHCER/RIVFRNT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 16-000-75-00-7203 BLDG IMPROVEMENTS-PUBLIC WORKS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 16-000-75-00-7204 BLDG MAINT - CITY HALL 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P23 DATE : 04 /23/ 2009 UNITED CITY OF YORKVILLE PAGE : 24 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : MUNICIPAL BUILDING FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL % ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ______ ___-_ __ _________ GENERAL EXPENSES CAPITAL OUTLAY 16-000-75-00-7206 LANDSCAPING-PUBLIC BUILDINGS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 16-000-75-00-7210 BLDG MAINT- POST OFFICE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 16-000-75-00-7211 NEW BUILDINGS 0 . 00 0 . 00 40 , 600 . 00 0 . 00 * 0 . 0 TOTAL CAPITAL OUTLAY 0 . 00 0 . 00 40 , 600 . 00 0 . 00 0 . 0 OTHER 16-000-78-00- 9009 RESERVE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 -__ _--___ _--__----- TOTAL OTHER 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TRANSFERS 16-000-99-00-9901 TRANSFER TO GENERAL FUND 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 16-000-99-00-9965 TRANSFER TO DEBT SERVICE 0 . 00 44 , 550 . 00 59 , 400 . 00 59 , 400 . 00 75 . 0 TOTAL TRANSFERS 0 . 00 441550 . 00 59 , 400 00 59 , 400 . 00 75 . 0 TOTAL EXPENSES : GENERAL. 0 . 00 44 , 550 . 00 100 , 000 . 00 59 , 400 . 00 75 . 0 TOTAL FUND REVENUES 750 . 00 12 , 750 . 00 100 , 000 . 00 ( 486 , 524 . 00 ) ( 2 . 6 ) TOTAL FUND EXPENSES 0 . 00 441550 . 00 100 , 000 . 00 59 , 400 . 00 75 . 0 FUND SURPLUS ( DEFICIT ) 750 . 00 ( 31 , 800 . 00 ) 0 . 00 ( 545 , 924 . 00 ) 5 . 8 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P24 DATE : 04 /23 /2009 UNITED CITY OF YORKVILLE PAGE : 25 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : POLICE EQUIPMENT CAPITAL FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL c ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED __ _ __ _________ _____________________ GENERAL REVENUES CARRY OVER 20-000-40-00-3999 CARRY OVER -WEATHER WARN SIREN 0 . 00 0 . 00 125 , 598 . 00 114 , 617 . 00 0 . 0 _ ________ __ TOTAL CARRY OVER 0 . 00 0 . 00 125 , 598 . 00 114 , 617 . 00 0 . 0 CHARGES FOR SERVICES 20-000-42-00- 4212 DEV FEES - POLICE 1 , 500 . 00 35 , 400 . 00 200 , 000 . 00 30 , 300 . 00 116 . 8 TOTAL CHARGES FOR SERVICES 11500 . 00 35 , 400 00 200 , 000 00 30 , 300 . 00 116 . 8 MISCELLANEOUS 20-000-44-00-4402 K- 9 DONATIONS 0 . 00 0 . 00 50 . 00 0 . 00 * 0 . 0 20-000- 44-00- 4403 IN CAR VIDEO DONATIONS 169 . 60 2 , 914 . 80 2 , 000 . 00 11751 . 00 * 166 . 4 20-000-44-00- 4404 DONATIONS 0 . 00 0 . 00 2 , 000 . 00 0 . 00 * 0 . 0 20-000-44 -00- 4405 WEATHER WARNING SIREN 0 . 00 0 . 00 7 , 500 . 00 82 , 648 . 00 * 0 . 0 20-000-44-00-4431 SALE OF POLICE SQUADS 0 . 00 480 . 00 0 . 00 480 . 00 * 100 . 0 20-000-44-00- 4440 SEIZED VEHICLES 1 , 355 . 00 51010 . 75 0 . 00 0 . 00 100 . 0 ____ ___________________ ________________ TOTAL MISCELLANEOUS 1 , 524 . 80 8 , 405 . 55 11 , 550 . 00 84 , 879 . 00 9 . 9 TRANSFERS 20-000-49-00- 4901 TRANSFER FROM GENERAL FUND 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL TRANSFERS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL REVENUES : GENERAL 3 , 024 . 80 43 , 805 . 55 337 , 148 . 00 229 , 796 . 00 19 . 0 EXPENSES OPERATIONS 20-000- 65-00-5811 LETHAL/NON-LETHAL WEAPONS 0 . 00 400 . 00 10 , 000 . 00 400 . 00 * 100 . 0 20-000- 65-00-5840 SEIZED VEHICLES 440 . 30 1 , 540 . 30 0 . 00 0 . 00 ( 100 . 0 ) __ __-____ __________ ___ TOTAL OPERATIONS 440 . 30 1 , 940 . 30 100000 . 00 400 . 00 485 . 0 CAPITAL OUTLAY * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P25 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 26 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . W0W FUND : POLICE EQUIPMENT CAPITAL FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ---------------------------------------' GENERAL _----_- EXPENSES CAPITAL OUTLAY 20-000-75-00-7001 EQUIPMENT 0 . 00 11587 . 55 40 , 000 . 00 30 , 000 . 00 5 . 2 20-000-75-00-7002 K-9 EQUIPMENT 0 . 00 0 . 00 2 , 500 . 00 2 , 000 . 00 0 . 0 20-000-75-00-7005 VEHICLES 31539 . 97 24 , 893 . 97 85 , 000 . 00 60 , 000 . 00 * 41 . 4 20-000-75-00-7006 CAR BUILD OUT 3 , 040 . 70 12 , 572 . 17 50 , 000 . 00 18 , 250 . 00 68 . 8 20-000-75-00-7008 NEW WEATHER WARNING SIRENS 0 . 00 0 . 00 37 , 000 . 00 36 , 498 . 00 0 . 0 20-000-75-00-7009 RESERVE-WEATHER WARNING SIREN 0 . 00 0 . 00 82 , 648 . 00 82 , 648 . 00 0 . 0 20-000-75-00-7010 NEW WORLD SOFTWARE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 20-000-75-00-7011 ARCHITECT FEES 0 . 00 0 . 00 30 , 000 . 00 0 . 00 * 0 . 0 TOTAL CAPITAL OUTLAY 61580 . 67 39 , 053 . 69 327 , 148 . 00 229 , 396 . 00 17 . 0 OTHER 20-000-78-00- 9009 RESERVE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL OTHER 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL EXPENSES : GENERAL 7 , 020 . 97 40 , 993 . 99 337 , 148 . 00 229 , 796 . 00 17 . 8 TOTAL FUND REVENUES 3 , 024 . 80 43 , 805 . 55 337 , 148 . 00 229 , 796 . 00 19 . 0 TOTAL FUND EXPENSES 7 , 020 . 97 40 , 993 . 99 337 , 148 . 00 229 , 796 . 00 17 . 8 FUND SURPLUS ( DEFICIT ) ( 3 , 996 . 17 ) 2 , 811 . 56 0 . 00 0 . 00 100 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P26 DATE : 04 /23/ 2009 UNITED CITY OF YORKVILLE PAGE : 27 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3OOO . W0W FUND : PUBLIC WORKS EQUIP CAPITAL FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL E ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED __ ________ GENERAL REVENUES CARRY OVER 21-000-40- 00-3999 BEGINNING FUND BALANCE 0 . 00 0 . 00 901000 . 00 507 , 295 . 00 * 0 . 0 TOTAL CARRY OVER 0 . 00 0 . 00 90 , 000 . 00 507 , 295 . 00 0 . 0 CHARGES FOR SERVICES 21 -000- 42 -00- 4213 DEVELOPMENT FEES-PUBLIC WORKS 3 , 500 . 00 82 , 300 . 00 280 , 000 . 00 105 , 000 . 00 * 78 . 3 TOTAL CHARGES FOR SERVICES 30500 . 00 82 , 300 . 00 280 , 000 . 00 105 , 000 . 00 78 . 3 MISCELLANEOUS 21-000-44-00-4430 SALE OF EQUIPMENT 0 . 00 81000 . 00 16 , 000 . 00 0 . 00 * 100 . 0 TOTAL MISCELLANEOUS 0 . 00 8 , 000 . 00 16 , 000 . 00 0 . 00 100 . 0 TRANSFERS 21-000-49-00- 4915 TRANSFER FROM WATER FUND 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 21-000-49-00- 4920 TRANSFER FROM SEWER FUND 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL TRANSFERS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL REVENUES : GENERAL 3 , 500 . 00 90 , 300 . 00 386 , 000 . 00 612 , 295 . 00 14 . 7 EXPENSES CAPITAL OUTLAY 21-000-75-00-7001 EQUIPMENT 0 . 00 7 , 178 . 84 55 , 000 . 00 55 , 000 . 00 13 . 0 21-000-75- 00-7005 VEHICLES 0 . 00 38 , 195 . 00 161 , 000 . 00 80 , 000 . 00 * 47 . 7 21-000-75- 00-7015 SKIDSTEER UPGRADE 0 . 00 4 , 398 . 70 51000 . 00 5 , 000 . 00 87 . 9 21 -000-75-00-7107 TRUCK ACCESSORIES 0 . 00 11031 . 10 91000 . 00 5 , 000 . 00 * 20 . 6 21 -000-75-00-7120 STREET SWEEPER 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 21-000-75-00-7130 FACILITY EXPANSION 6 , 857 . 92 354 , 790 . 06 128 , 600 . 00 375 , 000 . 00 * 94 . 6 TOTAL CAPITAL OUTLAY o , B57 . 92 405 , 593 . 70 358 , 600 . 00 520 , 000 . 00 77 . 9 OTHER * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P27 DATE : 04 /23 / 2009 UNITED CITY OF YORKVILLE PAGE : 28 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : PUBLIC WORKS EQUIP CAPITAL FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED --------------------- --------------- GENERAL EXPENSES OTHER 21 -000-78 -00- 9009 RESERVE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL OTHER 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TRANSFERS 21 -000- 99- 00- 9941 TRANSFER TO PARKS CAPITAL 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 ------------------------ ---------------- TOTAL TRANSFERS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL EXPENSES : GENERAL 6 , 857 . 92 405 , 593 . 70 358 , 600 . 00 520 , 000 . 00 77 . 9 TOTAL FUND REVENUES 3 , 500 . 00 90 , 300 . 00 386 , 000 . 00 612 , 295 . 00 14 . 7 TOTAL FUND EXPENSES 6 , 857 . 92 405 , 593 . 70 358 , 600 . 00 520 , 000 . 00 77 . 9 FUND SURPLUS ( DEFICIT ) ( 3 , 357 . 92 ) ( 315 , 293 . 70 ) 27 , 400 . 00 92 , 295 . 00 ( 341 . 6 ) * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P28 DATE : 04 / 23/2009 UNITED CITY OF YORKVILLE PAGE : 29 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : PARKS & REC EQUIP CAPITAL FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL o ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED __ _ _ GENERAL REVENUES CARRY OVER 22-000-40-00-3999 BEGINNING FUND BALANCE 0 . 00 0 . 00 26 , 946 . 00 43 , 375 . 00 * 0 . 0 TOTAL CARRY OVER 0 . 00 0 . 00 26 , 948 . 00 43 , 375 . 00 0 . 0 CHARGES FOR SERVICES 22 -000-42 -00- 4216 PARKS CAPITAL FEE 0 . 00 21 , 650 . 00 18 , 000 . 00 8 , 000 . 00 * 270 . 6 22-000- 42-00- 4217 PARK CAPITAL DONATIONS 0 . 00 11 , 821 . 98 0 . 00 8 , 822 . 00 * 134 . 0 TOTAL CHARGES FOR SERVICES 0 . 00 33 , 471 . 96 18 , 000 . 00 16 , 822 . 00 196 . 9 MISCELLANEOUS 22-000-44 - 00-4430 SALE OF VEHICLES/EQUIPMENT 0 . 00 0 . 00 20 , 000 . 00 20 , 000 . 00 0 . 0 TOTAL MISCELLANEOUS 0 . 00 0 . 00 20 , 000 00 20r000 . 00 0 0 TRANSFERS 22 -000-49-00- 4930 TRANSFER FROM GF 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 22 -000-49-00- 4950 TRANSFER FROM PW CAPITAL 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL TRANSFERS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL REVENUES : GENERAL 0 . 00 33 , 471 . 98 64 , 948 . 00 80 , 197 . 00 41 . 7 PARKS EXPENSES CAPITAL OUTLAY 22 - 610-75-00-7006 PICK UP TRUCK 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 22 - 610-75-00-7015 EQUIPMENT 0 . 00 8 , 821 . 98 19 , 948 . 00 28 , 770 . 00 * 30 . 6 22 - 610-75-00-7016 COMPUTER SERVER 0 . 00 0 . 00 0 . 00 8 , 427 . 00 * 0 . 0 22- 610-75- 00-7018 PARK RE-DEVELOPEMENTS 0 . 00 42 , 273 . 02 45 , 000 . 00 43 , 000 . 00 * 98 . 3 __ __ _ ___ _ __ TOTAL CAPITAL OUTLAY 0 . 00 511095 . 00 64 , 948 . 00 80 , 197 . 00 63 . 7 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P29 DATE : 04 /23 /2009 UNITED CITY OF YORKVILLE PAGE : 30 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : PARKS & REC EQUIP CAPITAL FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED TOTAL EXPENSES : PARKS 0 . 00 51 , 095 . 00 64 , 948 . 00 80 , 197 . 00 63 . 7 TOTAL FUND REVENUES 0 . 00 33 , 471 . 98 64 , 948 . 00 80 , 197 . 00 41 . 7 TOTAL FUND EXPENSES 0 . 00 51 , 095 . 00 64 , 948 . 00 80 , 197 . 00 63 . 7 FUND SURPLUS ( DEFICIT ) 0 . 00 ( 17 , 623 . 02 ) 0 . 00 0 . 00 100 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P30 DATE : 04 /23/ 2009 UNITED CITY OF YORKVILLE PAGE : 31 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . W0W FUND : CITY WIDE CAPITAL FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL % ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED __ _ __ GENERAL REVENUES CARRY OVER 23-000-40- 00-3996 ROAD CONTRIBUTION 21000 . 00 62 , 000 . 00 800 , 000 . 00 80 , 000 . 00 77 . 5 TOTAL CARRY OVER 21000 . 00 621000 . 00 800 , 000 00 80 , 000 . 00 77 . 5 CHARGES FOR SERVICES 23-000- 42 -00- 4211 ENGINEERING CAPITAL FEE 500 . 00 11 , 500 . 00 40 , 000 . 00 20 , 000 . 00 * 57 . 5 TOTAL CHARGES FOR SERVICES 500 . 00 111500 . 00 40f000 . 00 20 , 000 00 57 . 5 INTERGOVERNMENTAL 23-000-45-00-4500 DOWNTOWN HEWN GRANT 0 . 00 0 . 00 100 , 000 . 00 100 , 000 . 00 0 . 0 TOTAL INTERGOVERNMENTAL 0 . 00 0 . 00 100 , 000 . 00 100 , 000 . 00 0 . 0 TRANSFERS 23-000-49- 00-4901 TRANSFER FROM GENERAL FUND 0 . 00 120 , 000 . 00 375 , 000 . 00 220 , 000 . 00 * 54 . 5 TOTAL TRANSFERS 0 . 00 120 , 000 . 00 375 , 000 . 00 220 , 000 . 00 54 . 5 TOTAL REVENUES : GENERAL 2 , 500 . 00 193 , 500 . 00 1 , 315 , 000 . 00 420 , 000 . 00 46 . 0 EXPENSES CAPITAL OUTLAY 23-000-75- 00-7005 VEHICLES 0 . 00 0 . 00 40 , 000 . 00 20 , 000 . 00 * O . 0 23-000-75- 00-7099 PERIMETER RD STUDY 0 . 00 0 . 00 40 , 000 . 00 0 . 00 * 0 . 0 23-000-75-00-7101 RON CLARK PROPERTY 0 . 00 100 , 000 . 00 100 , 000 . 00 100 , 000 . 00 100 . 0 23-000-75-00-7102 MCHUGH ROAD 0 . 00 171 , 601 . 82 300 , 000 . 00 162 , 684 . 00 * 105 . 4 23-000-75-00-7103 SIDEWALK REPLACEMENT 0 . 00 21229 . 00 15 , 000 . 00 1 , 186 . 00 * 187 . 9 23-000-75- 00-7104 ROB ROY FALLS SIGNAL 0 . 00 0 . 00 75 , 000 . 00 0 . 00 0 . 0 23-000-75-00-7105 BEECHER RD STUDY 0 . 00 0 . 00 100 , 000 . 00 0 . 00 * 0 . 0 23-000-75-00-7106 DOWNTOWN BROWNFIELD 0 . 00 0 . 00 100 , 000 . 00 100 , 000 . 00 0 . 0 23-000-75- 00-7107 COMED BIKE TRAIL 0 . 00 0 . 00 500000 . 00 0 . 00 * 0 . 0 23-000-75- 00-7108 RAYMOND BASIN 0 . 00 0 . 00 30 , 000 . 00 0 . 00 * 0 . 0 23-000-75- 00-7109 KENNEDY ROAD 0 . 00 0 . 00 90 , 000 . 00 0 . 00 * 0 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P31 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 32 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL423000 . WOW FUND : CITY WIDE CAPITAL FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL "s ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ----------- --- ---------------------------------- ---------------------------- ----------- GENERAL EXPENSES CAPITAL OUTLAY 23-000-75-00-7110 ASPHAULT PAVEMENT TREAT 0 . 00 46 , 606 . 10 50 , 000 . 00 46 , 606 . 00 * 100 . 0 23-000-75-00-7115 PALMER COURT 0 . 00 70 , 840 . 86 65 , 000 . 00 70 , 841 . 00 * 99 . 9 23-000-75-00-7117 FAXON ROAD ROW 0 . 00 0 . 00 100 , 000 . 00 0 . 00 * 0 . 0 23-000-75-00-7130 PW BUILDING 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL CAPITAL OUTLAY 0 . 00 391 , 277 . 78 1 , 155 , 000 00 501r317 - 00 78 . 0 TOTAL FUND REVENUES 2 , 500 . 00 193 , 500 . 00 1 , 315 , 000 . 00 420 , 000 . 00 46 . 0 TOTAL FUND EXPENSES 0 . 00 391 , 277 . 78 1 , 155 , 000 . 00 501 , 317 . 00 78 . 0 FUND SURPLUS ( DEFICIT ) 21500 . 00 ( 197 , 777 . 78 ) 160 , 000 . 00 ( 81 , 317 . 00 ) 243 . 2 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P32 DATE : 04 /23 /2009 UNITED CITY OF YORKVILLE PAGE : 33 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . W0W FUND : SANITARY SEWER IMPROVEMENT FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL o ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ___ __ ___ ______ GENERAL REVENUES CHARGES FOR SERVICES 37-000-42- 00-4220 CONNECTION FEES 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 37 -000-42-00-4221 RIVER CROSSING FEES 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL CHARGES FOR SERVICES 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL FUND REVENUES 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL FUND EXPENSES 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 FUND SURPLUS ( DEFICIT ) 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P33 DATE : 04 /23/2009 UNITED CITY OF YORHVILLE PAGE : 34 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . W0W FUND : WATER IMPROV . EXPANSION FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ____ __ ______________________ ________________ GENERAL REVENUES CHARGES FOR SERVICES 41 -000-42- 00-4220 CONNECTION FEES 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL CHARGES FOR SERVICES 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 EXPENSES PROFESSIONAL SERVICE 41-000- 61-00-5401 ENGINEERING-RADIUM CONT B2 & 3 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 41-000- 61 -00-5418 ENG-TOWER LANE REHAB H . 1 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 41-000- 61-00- 5419 ENG-WELL 4 REHAB H . 1 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 41-000- 61-00- 5421 WELL 4 CONSTRUCTION H . 1 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 _-_ _ __ _ TOTAL PROFESSIONAL SERVICE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 OTHER 41-000- 65-00- 5800 CONTINGENCY 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL OTHER 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 CAPITAL OUTLAY 41-000-75-00-7520 WATERMAIN PROJECTS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL CAPITAL OUTLAY 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL EXPENSES : GENERAL 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL FUND REVENUES 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL FUND EXPENSES 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 FUND SURPLUS ( DEFICIT ) 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P34 DATE : 04 /23/ 2009 UNITED CITY OF YORKVILLE PAGE : 35 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : DEBT SERVICE FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL € ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED _ ------------ ----- _ _____ _ GENERAL REVENUES TAXES 42-000- 40-00-3999 CARRY OVER BALANCE 0 . 00 0 . 00 0 . 00 ( 237 , 259 . 00 ) * 0 . 0 TOTAL TAXES 0 . 00 0 . 00 0 . 00 ( 237 , 259 . 00 ) 0 . 0 MISCELLANEOUS 42- 000-44 -00- 4440 RECAPTURE-WATER/SEWER 125 . 00 24 , 319 . 00 0 . 00 0 . 00 100 . 0 42-000-44 -00- 4441 LIBRARY BOND REFERENDUM 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL MISCELLANEOUS 125 . 00 24 , 319 . 00 0 . 00 0 . 00 100 . 0 TRANSFERS 42-000-49-00-4901 TRANSFER FROM GENERAL FUND 0 . 00 318 , 843 . 00 425 , 124 . 00 425 , 124 . 00 75 . 0 42-000-49- 00-4925 TRANSFER FROM SANITARY SEWER 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42-000-49-00- 4930 TRANSFER FROM WATER IMPRV FUND 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42-000-49- 00-4940 TRANSFER FROM MUNICIPAL BLDG 0 . 00 44 , 550 . 00 59 , 400 . 00 59 , 400 . 00 75 . 0 TOTAL TRANSFERS 0 . 00 363 , 393 . 00 484 , 524 . 00 484 , 524 . 00 75 . 0 TOTAL REVENUES : GENERAL 125 . 00 387 , 712 . 00 484 , 524 . 00 247 , 265 . 00 156 . 8 EXPENSES DEBT SERVICE - 42 -000-66-00- 6001 CITY HALL BONDS PRINCIPAL PMT 0 . 00 0 . 00 59 , 400 . 00 59 , 400 . 00 0 . 0 42-000-66-00- 6002 CITY HALL BONDS INTEREST PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42-000-66-00- 6003 IRBB-BRUELL ST . INTEREST PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42 -000- 66-00- 6004 IRBB-BRUELL ST . PRINCIPAL PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42 -000- 66-00- 6005 NORTH H2O TOWER INTEREST PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42 -000- 66-00- 6006 NORTH H2O TOWER PRINCIPAL PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42-000- 66-00- 6007 $ 4 . 8M DEBT CERT INTEREST PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42-000- 66-00- 6008 COUNTRYSIDE ALT REV PRINC . PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42-000-66-00- 6009 COUNTRYSIDE ALT REV INT . PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42 -000-66-00- 6010 COMED/HYDRAULIC INTEREST PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42 -000- 66-00- 6011 COMED/HYDRAULIC PRINCIPAL PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42 -000- 66- 00- 6013 LIBRARY BOND 2005B INT PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P35 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 36 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : DEBT SERVICE FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED _-_ ___ GENERAL EXPENSES DEBT SERVICE 42 -000- 66-00- 6015 LIBRARY BOND 2006 INT PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42 -000-66-00- 6016 ROB ROY CREEK BOND 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42-000- 66- 00- 6041 IEPA DRINK WTR PROJ L171563 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42-000- 66-00- 6042 IEPA DRINK WTR PRJ L171563 INT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42-000- 66-00- 6045 SSES IEPA PRINCIPAL PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42-000-66- 00- 6049 SANITARY SIPHON INTEREST PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42 -000- 66-00- 6050 SANITARY SIPHON PRINCIPAL PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42 -000- 66-00- 6055 SSES IEPA L171153 PRINC . PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42 -000- 66-00- 6056 REFUNDING 2006 INTEREST PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42 -000- 66-00- 6057 REFUNDING 2006A PRINCIPAL PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42 -000- 66-00- 6058 $2 . 8M NORTH WATER TOWER 2002 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42 -000- 66-00- 6059 2007A GO REFUND 02 , 02A, 03 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42 -000- 66-00- 6070 $ 650K ROAD IMPROV FROG INT 0 . 00 19 , 745 . 00 29 , 745 . 00 19 , 745 . 00 * 100 . 0 42 -000- 66-00- 6071 $ 650K ROAD IMPROV FROG PRINC 0 . 00 65 , 000 . 00 75 , 000 . 00 85 , 000 . 00 * 100 . 0 42 -000- 66-00- 6072 $2M ALT REV B2 & B3 INT PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42 -000- 66-00- 6073 $ 2M ALT REV B2 & B3 PRINC PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 42 -000- 66-00- 6074 $ 3 . 825M IN TOWN ROAD INT PMT 0 . 00 150 , 378 . 76 160 , 379 . 00 150 , 379 . 00 * 99 . 9 42 -000- 66-00- 6075 $ 3 . 825M IN TOWN ROAD PRINC 0 . 00 170 , 000 . 00 160 , 000 . 00 170 , 000 . 00 * 100 . 0 TOTAL DEBT SERVICE 0 . 00 425 , 123 . 76 464 , 524 . 00 484 , 524 . 00 87 . 7 TOTAL FUND REVENUES lI5 . 00 387 , 712 . 00 484 , 524 . 00 247 , 265 . 00 156 . 8 TOTAL FUND EXPENSES 0 . 00 425 , 123 . 76 484 , 524 . 00 484 , 524 . 00 87 . 7 FUND SURPLUS ( DEFICIT ) 125 . 00 ( 37 , 411 . 76 ) 0 . 00 ( 237 , 259 . 00 ) 15 . 7 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P36 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 37 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : WATER IMPROVEMENT & OPERATIONS FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL a ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ----___ ___ _ _ _ _ OPERATIONS REVENUES CARRY OVER 51- 000-40-00-3999 BEGINNING FUND BALANCE 0 . 00 0 . 00 296 , 858 . 00 0 . 00 0 . 0 TOTAL CARRY OVER 0 . 00 0 . 00 296 , 858 . 00 0 . 00 0 . 0 CHARGES FOR SERVICES 51-000-42- 00- 4240 BULK WATER SALES ( 120 . 33 ) 4 , 610 . 98 10 , 000 . 00 5 , 000 . 00 * 92 . 2 51-000-42- 00-4241 WATER SALES 11583 . 45 11423 , 357 . 03 11450 , 000 . 00 1 , 500 , 000 . 00 * 94 . 8 51 -000- 42-00-4242 WATER METER SALES 41950 . 00 67 , 042 . 00 200 , 000 . 00 100 , 000 . 00 * 67 . 0 51 - 000- 42 -00-4243 LEASE REVENUE - H2O TOWER 2 , 397 . 19 25 , 510 . 66 31 , 000 . 00 31 , 000 . 00 82 . 2 ---__ _-__ __ __-__ _ TOTAL CHARGES FOR SERVICES 8 , 810 . 31 1 , 520 , 520 . 67 11691 , 000 . 00 11636 , 000 . 00 92 . 9 MISCELLANEOUS 51 -000-44 -00-4490 MISCELLANEOUS INCOME 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 51-000-44 -00- 4499 BAD DEBT RECOVERY 762 . 98 1 , 666 . 32 0 . 00 0 . 00 100 . 0 TOTAL MISCELLANEOUS 762 . 98 11666 . 32 0 00 0 . 00 100 . 0 INTEREST 51 -000-46-00- 4600 INVESTMENT INCOME 40 . 77 16 , 107 . 18 35 , 000 . 00 27 , 500 . 00 * 56 . 5 TOTAL INTEREST 40 . 77 16 , 107 . 18 35 , 000 . 00 27 , 500 . 00 58 . 5 TOTAL REVENUES : OPERATIONS 9 , 614 . 06 1 , 538 , 294 . 17 2 , 022 , 858 . 00 1 , 663 , 500 . 00 92 . 4 IMPROVEMENTS REVENUES CARRY OVER 51-200-40- 00-3999 BEGINNING FUND BALANCE 0 . 00 0 . 00 527 , 625 . 00 ( 164 , 225 . 00 ) * 0 . 0 __ 0 . 00 0 . 00 527 , 625 . 00 ( 164 , 225 . 00 ) 0 . 0 ____ ___ TOTAL CARRY OVER CHARGES FOR SERVICES * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P37 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 38 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : WATER IMPROVEMENT & OPERATIONS FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL % ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED _____ IMPROVEMENTS REVENUES CHARGES FOR SERVICES 51 -200-42-00-4220 CONNECTION FEES 17 , 980 . 00 295 , 480 . 00 532 , 000 . 00 532 , 000 . 00 55 . 5 51 -200-42- 00- 4221 SW WTR MAIN PROJECT 0 . 00 0 . 00 101800 , 000 . 00 0 . 00 * 0 . 0 51 -200-42-00- 4222 USGS SHALLOW WATER 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 51 -200-42- 00-4230 MPI CONNECTION FEE RECOV 0 . 00 0 . 00 425 , 600 . 00 425 , 600 . 00 0 . 0 51 -200-42-00- 4240 AUTUMN CREEK CONN RECOV 0 . 00 0 . 00 106 , 400 . 00 106 , 400 . 00 0 . 0 ______________________________ ___-_-------- ----- TOTAL CHARGES FOR SERVICES 17 , 980 . 00 295 , 480 . 00 11 , 864 , 000 . 00 1 , 064 , 000 . 00 27 . 7 MISCELLANEOUS 51-200-44 - 00- 4490 MISCELLANEOUS INCOME 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL MISCELLANEOUS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 INVESTMENT INCOME 51-200-46- 00- 4600 INVESTMENT INCOME 425 . 84 10 , 214 . 32 30 , 000 . 00 0 . 00 * 100 . 0 TOTAL INVESTMENT INCOME 425 . 84 10 , 214 . 32 30 , 000 . 00 0 . 00 100 . 0 TRANSFERS 51-200-49-00- 4901 TRANSFER FROM GENEREAL FUND 0 . 00 150 , 000 . 00 200 , 000 . 00 200 , 000 . 00 75 . 0 TOTAL TRANSFERS 0 . 00 150 , 000 . 00 200 , 000 . 00 200 , 000 . 00 75 . 0 TOTAL REVENUES : IMPROVEMENTS 18 , 405 . 84 455 , 694 . 32 12 , 621 , 625 . 00 11099 , 775 . 00 41 . 4 OPERATIONS EXPENSES PERSONNEL 51 -000-50-00-5107 SALARIES- WATER OP . 381154 . 33 295 , 962 . 99 330 , 849 . 00 342 , 698 . 00 * 86 . 3 51 -000-50-00-5136 SALARIES- PART TIME 0 . 00 3 , 582 . 00 5 , 000 . 00 3 , 500 . 00 102 . 3 51 -000-50-00-5137 SALARIES- OVERTIME 155 . 09 10 , 436 . 34 35 , 000 . 00 30 , 000 . 00 34 . 7 ----------------- ---------------------------------------- --- ---- TOTAL PERSONNEL 38 , 309 . 42 309 , 981 . 33 370 , 849 . 00 376 , 198 . 00 89 . 3 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P38 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 39 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : WATER IMPROVEMENT & OPERATIONS FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL % ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ---------- ----- ---------- __ __ _ _____ _ ____ OPERATIONS PROFESSIONAL SERVICES 51 -000- 61-00- 5300 LEGAL SERVICES 0 . 00 0 . 00 21000 . 00 2 , 000 . 00 0 . 0 51-000- 61-00- 5303 JULIE SERVICE 0 . 00 2 , 762 . 70 11 , 000 . 00 5 , 500 . 00 50 . 2 __ _ _ _ ---------------- TOTAL PROFESSIONAL SERVICES 0 . 00 2 , 762 . 70 130000 . 00 7 , 500 . 00 36 . 8 CONTRACTURAL SERVICES 51-000- 62 - 00- 5401 CONTRACTUAL SERVICES 131 . 67 9 , 556 . 69 71500 . 00 10 , 000 . 00 * 95 . 5 51-000- 62-00- 5407 TREATMENT FACILITIES O&M 12 , 679 . 29 181 , 740 . 61 220 , 000 . 00 220 , 000 . 00 82 . 6 51 -000- 62-00-5408 MAINTENANCE-EQUIPMENT 172 . 33 71014 . 45 7 , 500 . 00 7 , 500 . 00 93 . 5 51-000- 62-00-5409 MAINTENANCE-VEHICLES 50 . 65 3 , 876 . 46 8 , 000 . 00 81000 . 00 48 . 4 51-000- 62-00-5411 MAINTENANCE-COMPUTERS 0 . 00 0 . 00 500 . 00 500 . 00 0 . 0 51-000-62- 00-5413 MAINTENANCE-CONTROL SYSTEM 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 51-000- 62- 00- 5421 WEARING APPAREL 100 . 11 11928 . 70 4 , 500 . 00 4 , 500 . 00 42 . 8 51-000- 62 -00-5422 WATER TOWER PAINTING 544 . 50 223 , 018 . 07 335 , 000 . 00 270 , 000 . 00 82 . 5 51 -000- 62 -00- 5434 RENTAL - EQUIPMENT 0 . 00 232 . 88 21000 . 00 21000 . 00 11 . 6 51-000- 62-00- 5435 ELECTRICITY 44 , 396 . 82 295 , 240 . 71 275 , 000 . 00 275 , 000 . 00 107 . 3 51 -000- 62 -00- 5436 TELEPHONE 1 , 759 . 36 17 , 086 . 19 22 , 000 . 00 22 , 000 . 00 77 . 6 51-000- 62-00- 5438 CELLULAR TELEPHONE 414 . 46 3 , 472 . 04 3 , 300 . 00 31300 . 00 105 . 2 51-000- 62 -00-5439 LEAK DETECTION SURVEY 0 . 00 0 . 00 18 , 000 . 00 0 . 00 * 0 . 0 TOTAL CONTRACTURAL SERVICES 60 , 249 . 19 743 , 168 . 80 903 , 300 . 00 822 , 800 . 00 90 . 3 PROFESSIONAL DEVELOPMENT 51 -000- 64 -00-5600 DUES 0 . 00 785 . 00 11000 . 00 11000 . 00 78 . 5 51-000- 64 - 00-5603 SUBSCRIPTIONS 0 . 00 22 . 75 250 . 00 250 . 00 9 . 1 51-000- 64 - 00- 5604 TRAINING & CONFERENCES 0 . 00 1 , 443 . 00 17900 . 00 11900 . 00 75 . 9 51-000- 64 -00- 5605 TRAVEL EXPENSES 0 . 00 786 . 48 4 , 000 . 00 3 , 000 . 00 26 . 2 -_ _ _ ____ -_-------_ TOTAL PROFESSIONAL DEVELOPMENT 0 . 00 3 , 037 . 23 71150 . 00 61150 . 00 49 . 3 OPERATIONS 51-000- 65-00- 5800 CONTINGENCIES 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 51 -000- 65-00- 5804 OPERATING SUPPLIES 775 . 78 22 , 331 . 25 45 , 000 . 00 45 , 000 . 00 49 . 6 51 -000- 65-00-5808 POSTAGE & SHIPPING 156 . 18 15 , 664 . 15 18 , 000 . 00 18 , 000 . 00 87 . 0 51 -000- 65-00-5809 PRINTING & COPYING 108 . 95 2 , 145 . 97 13 , 000 . 00 13 , 000 . 00 16 . 5 51-000- 65- 00- 5810 PUBLISHING & ADVERTISING 0 . 00 36 . 90 11200 . 00 1 , 200 . 00 3 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P39 DATE : 04 /23/ 2009 UNITED CITY OF YORKVILLE PAGE : 40 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW - FUND : WATER IMPROVEMENT & OPERATIONS FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL % ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED _______ _____________________________________ ___________________________________________________________ OPERATIONS EXPENSES OPERATIONS 51 -000- 65-00-5812 GASOLINE 2 , 070 . 60 31 , 171 . 47 38 , 500 . 00 35 , 891 . 00 * 86 . 8 51 -000- 65-00- 5815 HAND TOOLS 53 . 36 53 . 36 11000 . 00 1 , 000 . 00 5 . 3 51-000- 65-00- 5817 GRAVEL 0 . 00 2 , 260 . 87 41000 . 00 41000 . 00 56 . 5 51-000- 65-00-5820 CHEMICALS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 51-000- 65-00- 5821 CATHODIC PROTECTION 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 51-000- 65-00- 5822 WATER SAMPLES 50 . 00 10 , 360 . 17 14 , 000 . 00 18 , 000 . 00 * 57 . 5 ______________________________ ________________ ________________________ ___ TOTAL OPERATIONS 31214 . 87 84 , 024 . 14 1341700 . 00 136 , 091 . 00 61 . 7 DEBT SERVICE 51-000-66-00-8200 INTEREST EXPENSE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL DEBT SERVICE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 RETIREMENT 51 -000-72-00- 6500 IMRF PARTICIPANTS 31179 . 70 24 , 318 . 33 29 , 000 . 00 28 , 362 . 00 * 85 . 7 51 -000-72-00- 6501 SOCIAL SECURITY & MEDICARE 2 , 911 . 08 23 , 921 . 49 29 , 229 . 00 28 , 779 . 00 * 83 . 1 TOTAL RETIREMENT 61090 . 78 48 , 239 . 82 58 , 229 . 00 57 , 141 00 84 . 4 CAPITAL OUTLAY 51-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 0 . 00 1 , 320 . 00 0 . 00 1 , 320 . 00 * 100 . 0 51-000-75-00-7004 SAFETY EQUIPMENT 0 . 00 498 . 85 1 , 000 . 00 1 , 000 . 00 49 . 8 51-000-75-00- 7506 METER READERS 0 . 00 4 , 870 . 50 12 , 000 . 00 91000 . 00 * 54 . 1 51-000-75-00-7507 HYDRANT REPLACEMENT 430 . 60 674 . 64 61500 . 00 2 , 500 . 00 * 26 . 9 51-000-75-00-7508 METERS & PARTS 757 . 07 86 , 627 . 85 280 , 000 . 00 178 , 680 . 00 * 48 . 4 51-000-75-00-7509 ELECTRICITY MONITOR 0 . 00 0 . 00 12 , 000 . 00 0 . 00 * 0 . 0 TOTAL CAPITAL OUTLAY 1 , 187 . 67 93 , 991 . 84 311 , 500 . 00 192 , 500 . 00 48 . 8 OTHER OPERATING EXPENSES 51-000-78- 00- 9005 REFUND 0 . 00 390 . 00 11500 . 00 1 , 500 . 00 26 . 0 51-000-78-00- 9006 MERIT 0 . 00 0 . 00 13 , 234 . 00 0 . 00 * 0 . 0 51-000-78-00- 9007 FOOD PANTRY DONATIONS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 51-000-78-00- 9008 RESERVE-H2O TOWER MAINTENANCE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P40 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 41 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : WATER IMPROVEMENT & OPERATIONS FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL o ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED -_ _ _ _ ________ _____________________ OPERATIONS EXPENSES OTHER OPERATING EXPENSES 51 -000-78-00- 9009 RESERVE 0 . 00 0 . 00 1 , 536 . 00 1 , 536 . 00 0 . 0 51-000-78- 00- 9099 BAD DEBT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 _-_ __ _ __ _-_ _______ TOTAL OTHER OPERATING EXPENSES 0 . 00 390 . 00 16 , 270 . 00 31036 . 00 12 . 8 TRANSFERS 51-000- 99-00- 9901 TRANSFER TO GENERAL FUND 0 . 00 187 , 500 . 00 250 , 000 . 00 0 . 00 * ( 100 . 0 ) 51-000-99-00- 9950 TRANSFER TO PW EQUIP CAPITAL 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 -_ _ _ -_ ________ ___ _______ ______ TOTAL TRANSFERS 0 . 00 187 , 500 . 00 250 , 000 . 00 0 . 00 ( 100 . 0 ) TOTAL EXPENSES : OPERATIONS 109 , 051 . 93 11473 , 095 . 86 21064 , 998 . 00 1 , 6011416 . 00 91 . 9 IMPROVEMENTS EXPENSES PROFESSIONAL SERVICES 51 -200- 61- 00- 5300 LEGAL SERVICES 0 . 00 0 . 00 41000 . 00 4 , 000 . 00 0 . 0 51 -200-61-00- 5301 ENGINEERING- GENERAL SVCS 0 . 00 1 , 550 . 00 20 , 000 . 00 20 , 000 . 00 7 . 7 51 -200- 61-00-5302 FINANCIAL EXPENSES 0 . 00 6 , 400 . 00 0 . 00 0 . 00 ( 100 . 0 ) 51-200- 61-00-5400 B . 2 CONTRACTS 0 . 00 274 . 39 0 . 00 0 . 00 ( 100 . 0 ) 51-200- 61-00-5401 B . 3 CONTRACTS 0 . 00 597 . 70 0 . 00 0 . 00 ( 100 . 0 ) 51 -200- 61-00-5405 RADIUM VIOLATIONS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 51 -200- 61-00- 5408 CENTRAL ZONE-CONTRACT C 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 51 -200- 61-00- 5410 ENGINEERING-CENTRAL ZONE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 51-200- 61- 00- 5421 WELL 4 CONSTRUCTION 0 . 00 9 , 670 . 00 0 . 00 0 . 00 ( 100 . 0 ) _______ __ _ __ ________ TOTAL PROFESSIONAL SERVICES 0 . 00 18 , 492 . 09 24 , 000 . 00 24 , 000 . 00 77 . 0 CONTRACTUAL SERVICES 51 -200-62-00-5460 MPI RECOVERY 0 . 00 0 . 00 425 , 600 . 00 425 , 600 . 00 0 . 0 51-200- 62-00- 5461 AUTUMN CREEK RECOVERY 0 . 00 0 . 00 106 , 400 . 00 106 , 400 . 00 0 . 0 51-200-62-00-5462 FOX HILL WATERMAIN RECAPTURE 0 . 00 0 . 00 410 , 000 . 00 0 . 00 * 0 . 0 51 -200- 62-00-5463 KENDALLWOOD ESTATES REIMS . 0 . 00 96 , 902 . 00 0 . 00 0 . 00 ( 100 . (D ) * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P41 DATE : 04 /23/ 2009 UNITED CITY OF YORKVILLE PAGE : 42 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : WATER IMPROVEMENT & OPERATIONS FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED TOTAL CONTRACTUAL SERVICES 0 . 00 96 , 902 . 00 942 , 000 . 00 532 , 000 00 18 . 2 DEBT SERVICE 51-200- 66-00- 6007 RADIUM COMPLIANCE BOND 0 . 00 331150 . 00 33 , 150 . 00 331150 . 00 100 . 0 51 -200- 66-00- 6041 IEPA L17 - 156300 PRINCIPAL PMT 0 . 00 68 , 947 . 03 56 , 528 . 00 56 , 528 . 00 121 . 9 51 -200- 66-00- 6042 IEPA L17 -156300 INTEREST PMT 0 . 00 39 , 448 . 69 52 , 708 . 00 52 , 708 . 00 74 . 8 51-200- 66-00- 6056 2006A REFUND . INTEREST PMT-WTR 0 . 00 46 , 053 . 13 51100 . 00 5 , 100 . 00 903 . 0 51-200- 66-00- 6057 2006A REFUND . PRINCIPAL PMT-WTR 0 . 00 56 , 053 . 13 97 , 007 . 00 97 , 007 . 00 57 . 7 S1-200- 66-00- 6058 2002 PRINCIPAL PMT-NORTH WTR 0 . 00 117 , 200 . 00 60 , 000 . 00 60 , 000 . 00 195 . 3 51 -200- 66-00- 6059 2007A REFUNDING P&I PMT ( 225 . 50 ) 134 , 840 . 76 135 , 066 . 00 135 , 066 . 00 99 . 8 51-200- 66-00- 6072 2005C INTEREST PMT-$2M 0 . 00 86 , 300 . 00 91 , 300 . 00 91 , 300 . 00 94 . 5 51 -200- 66-00- 6073 2005C PRINCIPAL PMT-$2M 0 . 00 80 , 000 . 00 75 , 000 . 00 75 , 000 . 00 106 . 6 __ _--_______-_ _-_--- TOTAL DEBT SERVICE ( 22S . S0 ) 661 , 992 . 74 605 , 859 . 00 605 , 859 . 00 109 . 2 CAPITAL OUTLAY 51-200-75-00-7503 SOUTHWEST WATER MAIN PROJ 0 . 00 0 . 00 10 , 800 , 000 . 00 0 . 00 * 0 . 0 51 -200-75- 00-7504 NORTH WATER TOWER CONTE . A 0 . 00 2 , 200 . 00 0 . 00 0 . 00 ( 100 . 0 ) 51 -200-75-00-7520 WATERMIAN PROJECTS 0 . 00 11 , 492 . 76 0 . 00 0 . 00 ( 100 . 0 ) 51-200-75-00-7522 IN-TOWN RD WATER PROJ 0 . 00 5 , 305 . 13 0 . 00 0 . 00 ( 100 . 0 ) -______ ------------ -------------------------- _ TOTAL CAPITAL OUTLAY 0 . 00 18 , 997 . 89 10 , 800 , 000 . 00 0 . 00 ( 100 . 0 ) TRANSFERS 51 -200-99-00- 9901 TRANSFER TO GENERAL FUND 0 . 00 150 , 000 . 00 200 , 000 . 00 0 . 00 ( 100 . 0 ) TOTAL TRANSFERS 0 . 00 150 , 000 . 00 200 , 000 . 00 0 . 00 ( 100 . 0 ) TOTAL EXPENSES : IMPROVEMENTS ( 225 . 50 ) 946 , 384 . 72 12 , 571 , 859 . 00 11161 , 859 . 00 81 . 4 TOTAL FUND REVENUES 28 , 019 . 90 1 , 993 , 988 . 49 14 , 644 , 483 . 00 2 , 763 , 275 . 00 72 . 1 TOTAL FUND EXPENSES 108 , 826 . 43 2 , 4191480 . 58 14 , 6361857 . 00 2 , 763 , 275 . 00 87 . 5 FUND SURPLUS ( DEFICIT ) ( 80 , 806 . 53 ) ( 425 , 492 . 09 ) 7 , 626 . 00 0 . 00 100 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P42 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 43 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : SEWER IMPROVEMENT & OPERATIONS FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED __________ _ _ __ _________________ OPERATIONS REVENUES CARRY OVER 52-000-40-00- 3999 BEGINNING FUND BALANCE 0 . 00 0 . 00 309 , 383 . 00 0 . 00 0 . 0 TOTAL CARRY OVER 0 . 00 0 . 00 309 , 383 . 00 0 . 00 0 . 0 CHARGES FOR SERVICES 52 -000- 42 -00-4240 LIFT STATION INCOME 0 . 00 7 , 500 . 00 0 . 00 0 . 00 100 . 0 52 -000- 42-00-4250 SEWER MAINTENANCE FEES ( 383 . 33 ) 592 , 898 . 28 500 , 000 . 00 500 , 000 . 00 118 . 5 52-000-42- 00- 4251 SEWER CONNNECTION FEES 2 , 800 . 00 68 , 750 . 00 200 , 000 . 00 200 , 000 . 00 34 . 3 TOTAL CHARGES FOR SERVICES 2r416 . 67 669 , 148 . 28 700 , 000 . 00 700 , 000 . 00 95 . 5 MISCELLANEOUS 52 -000-44 -00-4499 BAD DEBT RECOVERY 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL MISCELLANEOUS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 INTEREST 52 -000- 46-00- 4600 INVESTMENT INCOME 40 . 77 19 , 662 . 76 35 , 000 . 00 22 , 800 . 00 * 86 . 2 TOTAL INTEREST 40 . 77 19 , 662 . 76 35 , 000 . 00 22 , 800 . 00 86 . 2 TOTAL REVENUES : OPERATIONS 2 , 457 . 44 688 , 811 . 04 1 , 044 , 383 . 00 722 , 800 . 00 95 . 2 IMPROVEMENTS REVENUES CARRY OVER 52-200-40-00-3999 BEGINNING FUND BALANCE 0 . 00 0 . 00 0 . 00 21435 , 879 . 00 * 0 . 0 _______ _ _ _ --______ TOTAL CARRY OVER 0 . 00 0 . 00 0 . 00 2 , 435 , 879 . 00 0 . 0 CHARGES FOR SERVICES 52-200-42 -00- 4220 CONNECTION FEES 13 , 600 . 00 226, 338 . 00 800 , 000 . 00 62 , 350 . 00 * 363 . 0 52-200-42 -00- 4221 RIVER CROSSING FEE 0 . 00 150 . 50 0 . 00 0 . 00 100 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P43 DATE : 04 /23 /2009 UNITED CITY OF YORKVILLE PAGE : 44 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 !D : GL4B3000 . W0W FUND : SEWER IMPROVEMENT & OPERATIONS FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL $ ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ---------------------------------------- IMPROVEMENTS REVENUES CHARGES FOR SERVICES 52 -200-42-00- 4229 NORTH BRANCH #2 ( DEV REV) 0 . 00 0 . 00 11650 , 000 . 00 0 . 00 * 0 . 0 TOTAL CHARGES FOR SERVICES 13 , 600 . 00 226 , 488 . 50 21450 , 000 . 00 62 , 350 . 00 363 . 2 INVESTMENT INCOME 52 -200-46-00-4600 INVESTMENT INCOME 34 . 35 51810 . 88 30 , 000 . 00 9 , 170 . 00 * 63 . 3 ____--___ -_--------_ ----- TOTAL INVESTMENT INCOME 34 . 35 50810 . 88 30 , 000 . 00 9 , 170 . 00 63 . 3 TRANSFERS 52-200-49-00- 4901 TRANSFER FROM GENERAL FUND 0 . 00 112 , 500 . 00 150 , 000 . 00 150 , 000 . 00 75 . 0 TOTAL TRANSFERS 0 . 00 112 , 500 . 00 150 , 000 . 00 150 , 000 . 00 75 . 0 TOTAL REVENUES : IMPROVEMENTS 13 , 634 . 35 344 , 799 . 38 21630 , 000 . 00 21657 , 399 . 00 12 . 9 OPERATIONS EXPENSES PERSONNEL SERVICES 52 -000-50-00-5108 SALARIES- SEWER OP . 17 , 977 . 18 143 , 358 . 85 131 , 000 . 00 145 , 944 . 00 * 98 . 2 52-000-50-00-5136 SALARIES- PART TIME 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 52-000-50-00-5137 SALARIES- OVERTIME 24 . 48 2 , 740 . 26 8 , 000 . 00 8 , 000 . 00 34 . 2 TOTAL PERSONNEL SERVICES 18 , 001 . 66 146 , 099 . 13 139 , 000 . 00 153 , 944 . 00 94 . 9 CONTRACTUAL SERVICES 52-000-62-00- 5401 CONTRACTUAL SERVICES 131 . 66 2 , 360 . 07 6 , 500 . 00 6 , 500 . 00 36 . 3 52-000-62-00- 5408 MAINTENANCE-EQUIPMENT 262 . 19 1 , 195 . 03 51000 . 00 5 , 000 . 00 23 . 9 52 -000- 62-00-5409 MAINTENANCE-VEHICLES 5 . 92 1 , 670 . 37 41000 . 00 4 , 000 . 00 41 . 7 52 -000- 62-00-5419 MAINTENANCE-SANITARY SEWER 15 . 99 1 , 318 . 14 20 , 000 . 00 15 , 000 . 00 * 8 . 7 52 -000- 62-00-5421 WEARING APPAREL 100 . 12 11929 . 46 2 , 500 . 00 2 , 500 . 00 77 . 1 52 -000- 62-00-5422 LIFT STATION MAINTENANCE 0 . 00 16 , 511 . 07 25 , 000 . 00 25 , 000 . 00 66 . 0 52 -000- 62-00-5434 RENTAL - EQUIPMENT 0 . 00 0 . 00 1 , 000 . 00 1 , 000 . 00 0 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P44 DATE : 04 /23/ 2009 UNITED CITY OF YORKVILLE PAGE : 45 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : SEWER IMPROVEMENT & OPERATIONS FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED __ __ _ _ _____________ OPERATIONS EXPENSES CONTRACTUAL SERVICES 52-000- 62-00-5435 ELECTRICITY 246 . 40 20 , 917 . 05 75 , 000 . 00 75 , 000 . 00 27 . 8 52 -000- 62-00-5438 CELLULAR TELEPHONE 129 . 18 1 , 286 . 31 21500 . 00 2 , 500 . 00 51 . 4 -------"'------------------------------- ' TOTAL CONTRACTUAL SERVICES 891 . 46 47 , 187 . 50 141 , 500 . 00 136 , 500 . 00 34 . 5 PROFESSIONAL DEVELOPMENT 52 -000- 64 -00-5604 TRAINING & CONFERENCES 0 . 00 733 . 00 11000 . 00 500 . 00 * 146 . 6 52 -000- 64-00-5605 TRAVEL/MEALS/LODGING 0 . 00 0 . 00 21000 . 00 500 . 00 * 0 . 0 TOTAL PROFESSIONAL DEVELOPMENT 0 . 00 733 . 00 31000 . 00 11000 . 00 73 . 3 OPERATIONS 52-000- 65- 00- 5800 CONTINGENCIES 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 52-000- 65- 00-5802 OFFICE SUPPLIES 254 . 82 917 . 52 21500 . 00 21500 . 00 36 . 7 52-000- 65-00- 5805 SHOP SUPPLIES 90 . 55 1 , 555 . 35 2 , 500 . 00 2 , 500 . 00 62 . 2 52 -000- 65-00- 5812 GASOLINE 21070 . 60 30 , 770 . 03 26 , 500 . 00 341500 . 00 * 89 . 1 52-000- 65-00-5815 HAND TOOLS 0 . 00 0 . 00 11000 . 00 500 . 00 * 0 . 0 52 -000- 65-00-5817 GRAVEL 0 . 00 0 . 00 2 , 000 . 00 1 , 000 . 00 * 0 . 0 52-000- 65-00-5823 SEWER CHEMICALS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 ---_-------_ _ __ _ __ _---- TOTAL OPERATIONS 2 , 415 . 97 33 , 242 . 90 341500 . 00 41 , 000 . 00 81 . 0 DEBT SERVICE 52 -000- 66- 00- 8200 INTEREST EXPENSE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 -------_ _ _ __ -------- ------------- TOTAL DEBT SERVICE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 RETIREMENT 52 -000-72-00- 6500 IMRF PARTICIPANTS 1 , 494 . 13 11 , 485 . 97 11 , 034 . 00 11 , 715 . 00 * 98 . 0 52 -000-72- 00- 6501 SOCIAL SECURITY & MEDICARE 1 , 358 . 75 11 , 041 . 72 10 , 977 . 00 11 , 777 . 00 * 93 . 7 TOTAL RETIREMENT 2 , 852 . 88 22 , 527 . 69 22 , 011 . 00 23 , 492 . 00 95 . 8 CAPITAL OUTLAY 52-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 0 . 00 135 . 15 2 , 000 . 00 1 , 000 . 00 * 13 . 5 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P45 DATE : 04 /23 /2009 UNITED CITY OF YORKVILLE PAGE : 46 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : SEWER IMPROVEMENT & OPERATIONS FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL o ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED __ _____ ____________ OPERATIONS EXPENSES CAPITAL OUTLAY 52 -000-75-00-7003 OFFICE EQUIPMENT 0 . 00 0 . 00 31500 . 00 500 . 00 * 0 . 0 52 -000-75-00-7004 SAFETY EQUIPMENT 0 . 00 885 . 70 1 , 000 . 00 1 , 000 . 00 88 . 5 ____________ _____________________________________________________________________ TOTAL CAPITAL OUTLAY 0 . 00 1 , 020 . 85 61500 . 00 2 , 500 . 00 40 . 8 OTHER OPERATING EXPENSES 52-000-78-00- 9005 MERIT 0 . 00 0 . 00 51240 . 00 0 . 00 * 0 . 0 52-000-78-00- 9009 RESERVE 0 . 00 0 . 00 156 , 657 . 00 0 . 00 * 0 . 0 52-000-78-00- 9099 BAD DEBT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 _-_ ______________________________ ___________________________ TOTAL OTHER OPERATING EXPENSES 0 . 00 0 . 00 161 , 897 . 00 0 . 00 0 . 0 TRANSFERS 52 -000-99-00- 9901 TRANSFER TO GENERAL FUND 0 . 00 52 , 500 . 00 70 , 000 . 00 70 , 000 . 00 75 . 0 52-000-99-00- 9950 TRANSFER TO PW EQUIP CAPITAL 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL TRANSFERS 0 . 00 52 , 500 . 00 70 , 000 . 00 70 , 000 00 75 . 0 TOTAL EXPENSES : OPERATIONS 24 , 161 . 97 303 , 311 . 07 578 , 408 . 00 428 , 436 . 00 70 . 7 IMPROVEMENTS EXPENSES CONTRACTUAL SERVICES 52-200- 62-00- 5401 CONTRACTUAL/ PROF . SVCS 0 . 00 0 . 00 20 , 000 . 00 20 , 000 . 00 0 . 0 52 -200- 62-00- 5402 ENG/LEGAL/CONTINGEN-COUNTRYSID 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 52-200-62-00- 5403 ENGINEERING-ZANGLER 0 . 00 0 . 00 20 , 000 . 00 201000 . 00 0 . 0 52-200- 62-00- 5462 FOX HILL SEWER RECAPTURE 0 . 00 0 . 00 385 , 000 . 00 0 . 00 * 0 . 0 ____________________ _____________________________________________________ ________ TOTAL CONTRACTUAL SERVICES 0 . 00 0 . 00 425 , 000 . 00 40 , 000 . 00 0 . 0 DEBT SERVICE 52 -200-66-00- 6003 2003A IRBB INTEREST PMT-BRUELL 0 . 00 81 , 101 . 64 84 , 475 . 00 84 , 475 . 00 96 . 0 52 -200- 66-00- 6004 2003A IRBB PRINC . PMT-BRUELL 0 . 00 85 , 000 . 00 80 , 000 . 00 80 , 000 . 00 106 . 2 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P46 DATE : 04 /23 /2009 UNITED CITY OF YORKVILLE PAGE : 47 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : SEWER IMPROVEMENT & OPERATIONS FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED _-------__ _ __ __ _ IMPROVEMENTS EXPENSES DEBT SERVICE 52-200- 66-00- 6008 2004B PRINCIPAL PMT-CNTRYSIDE 0 . 00 140 , 000 . 00 135 , 000 . 00 135 , 000 . 00 103 . 7 52-200- 66-00- 6009 20043 INTEREST PMT-CNTRYSIDE 0 . 00 111 , 137 . 50 116 , 138 . 00 116 , 138 . 00 95 . 6 52-200- 66-00- 6010 2004A INTERST PMT-COMED/HYDRLC 0 . 00 351975 . 00 40 , 975 . 00 40 , 975 . 00 87 . 7 52 -200- 66-00- 6011 2004A PRINCIPAL PMT-COMED/HYD . 0 . 00 150 , 000 . 00 1450000 . 00 1451000 . 00 103 . 4 52 -200- 66-00- 6016 2005D INTEREST PMT-ROB ROY ( 1 , 613 . 69 ) 467 , 336 . 11 468 , 950 . 00 468 , 950 . 00 99 . 6 52 -200- 66-00- 6049 IEPA LOAN L17-013000 INT . PMT 0 . 00 81300 . 98 81301 . 00 81301 . 00 99 . 9 52-200- 66-00- 6050 IEPA LOAN L17-013000 PRINC PMT 0 . 00 30 , 679 . 00 301679 . 00 30 , 679 . 00 100 . 0 52 -200- 66-00- 6055 IEPA LOAN L17-115300 P& I PMT 0 . 00 107 , 050 . 70 109 , 234 . 00 109 , 234 . 00 98 . 0 -_ _ __ __-_ __ _ --__--- TOTAL DEBT SERVICE ( 11613 . 89 ) 11216 , 580 . 93 11218 , 752 . 00 1 , 218 , 752 . 00 99 . 8 CAPITAL OUTLAY 52 -200-75-00-7505 ROB ROY INTERCEPTOR 0 . 00 0 . 00 1 , 650 , 000 . 00 0 . 00 0 . 0 52 -200-75-00-7506 SOUTHWEST SVC AREA INTERCEPTOR 0 . 00 550 , 735 . 46 0 . 00 0 . 00 ( 100 . 0 ) 52-200-75-00-7509 NORTH BRANCH #2 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 -_ _ -------------------- _ -__-- TOTAL CAPITAL OUTLAY 0 . 00 550 , 735 . 48 1 , 650 , 000 . 00 0 . 00 ( 100 . 0 ) TRANSFER 52 -200-99-00-9901 TRANSFER TO GENERAL FUND 0 . 00 112 , 500 . 00 1501000 . 00 0 . 00 * ( 100 . 0 ) TOTAL TRANSFER 0 . 00 112 , 500 . 00 150 , 000 . 00 0 . 00 ( 100 . 0 ) TOTAL EXPENSES : IMPROVEMENTS ( 1 , 613 . 89 ) 1 , 879 , 816 . 41 3 , 443 , 752 . 00 11258 , 752 . 00 149 . 3 TOTAL FUND REVENUES 16 , 091 . 79 1 , 033 , 610 . 42 31674 , 383 . 00 31360 , 199 . 00 30 . 5 TOTAL FUND EXPENSES 22 , 548 . 08 21183 , 127 . 46 41022 , 160 . 00 11687 , 186 . 00 129 . 3 FUND SURPLUS ( DEFICIT ) ( 61456 . 29 ) ( 11149 , 517 . 06 ) ( 347 , 777 . 00 ) 1 , 693 , 011 . 00 ( 67 . 8 ) * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P47 DATE : 04 /23/ 2009 UNITED CITY OF YORKVILLE PAGE : 48 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : LAND CASH FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL % ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED __________________ ___ ____________________________ __ GENERAL REVENUES CARRY OVER 72-000- 40-00-3999 BEGINNING FUND BALANCE 0 . 00 0 . 00 ( 521 , 508 . 00 ) ( 272 , 822 . 00 ) * 0 . 0 TOTAL CARRY OVER 0 . 00 0 . 00 ( 521 , 508 00 ) ( 272 , 822 . 00 ) 0 . 0 MISCELLANEOUS 72 -000-44 -00-4413 REIMB FROM OTHER GOVENRMENTS 0 . 00 0 . 00 0 . 00 600 , 000 . 00 * 0 . 0 TOTAL MISCELLANEOUS 0 . 00 0 . 00 0 . 00 600 , 000 . 00 0 . 0 INTERGOVERNMENTAL 72-000-45-00- 4501 CANNONBALL RIDGE GRANT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL INTERGOVERNMENTAL 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 CONTRIBUTIONS 72-000-47-00-4700 OSLAD GRANT 0 . 00 0 . 00 762 , 000 . 00 4001000 . 00 * 0 . 0 72-000-47- 00-4701 GREENBRIAR 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72-000-47-00-4702 BIKE PATH GRANT 0 . 00 0 . 00 200 , 000 . 00 0 . 00 * 0 . 0 72-000-47-00-4703 PRAIRIE GARDEN 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72-000-47-00-4705 COUNTRY HILLS 0 . 00 0 . 00 1 , 700 . 00 0 . 00 * 0 . 0 72-000-47-00-4707 FOX HIGHLANDS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72-000-47 -00- 4709 SUNFLOWER 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72 -000-47 -00-4712 RIVER ' S EDGE 0 . 00 0 . 00 3 , 684 . 00 0 . 00 * 0 . 0 72 -000- 47 -00- 4714 WOODWORTH 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72 -000-47 -00- 4715 WHITE OAK UNIT 1 &2 0 . 00 0 . 00 0 . 00 1 , 406 . 00 * 0 . 0 72 -000- 47 -00-4716 WHITE OAK UNIT 3 & 4 0 . 00 1 , 406 . 00 0 . 00 0 . 00 100 . 0 72 -000-47 -00-4717 KYLN ' S CROSSING 0 . 00 0 . 00 1 , 570 . 00 0 . 00 * 0 . 0 72 -000-47-00-4718 FOXFIELD II PARK 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72-000-47-00-4719 WILDWOOD 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72-000-47-00-4722 KYLN ' S RIDGE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72-000-47-00- 4723 HEARTLAND CIRCLE 0 . 00 0 . 00 30 , 000 . 00 0 . 00 * 0 . 0 72-000-47-00- 4725 WINDETTE RIDGE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72 -000-47-00- 4727 GRAND RESERVE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72-000-47-00- 4731 MONTALBANO HOMES 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72-000-47-00- 4732 RAINTREE VILLAGE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P48 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 49 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . W0W FUND : LAND CASH FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED __ __ ___ _ GENERAL REVENUES CONTRIBUTIONS 72-000-47-00- 4734 WHISPERING MEADOWS ( K . HILL) 0 . 00 13 , 933 . 36 12 , 000 . 00 12 , 000 . 00 112 . 7 72-000- 47-00- 4735 PRAIRIE MEADOWS (MENARDS RES ) 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72-000-47 -00- 4736 BRIARWOOD 0 . 00 0 . 00 113 , 043 . 00 0 . 00 * 0 . 0 72 -000- 47- 00-4737 CALEDONIA 0 . 00 0 . 00 158 , 000 . 00 0 . 00 * 0 . 0 72 -000-47 -00-4738 AUTUMN CREEK 21051 . 14 26 , 896 . 35 25 , 000 . 00 25 , 000 . 00 107 . 5 72 -000-47 -00- 4739 WYNSTONE TOWNHOMES 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72 -000-47-00- 4740 VILLAS AT THE PRESERVE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72 -000-47-00- 4741 BAILEY MEADOWS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72-000-47- 00- 4742 BLACKBERRY WOODS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72-000-47-00-4743 CORNEILS CROSSING 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72 -000-47 -00-4744 HUDSON LAKES 0 . 00 0 . 00 10 , 000 . 00 0 . 00 * 0 . 0 72 -000- 47 -00-4745 PRESTWICK 0 . 00 0 . 00 30 , 000 . 00 0 . 00 * 0 . 0 72 -000- 47 -00-4746 WESTBURY 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72 -000-47-00-4747 WESTHAVEN 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72 -000-47-00- 4748 WILLMAN 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72 -000- 47-00-4749 BLACKBERRY WOODS 568 . 16 1 , 136 . 36 4 , 000 . 00 2 , 000 . 00 * 56 . 8 72-000- 47 -00- 4750 KENDALLWOOD ESTATES 0 . 00 0 . 00 15 , 000 . 00 0 . 00 * 0 . 0 72 -000- 47 -00-4751 CANNONBALL RIDGE PARK GRANT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72 -000-47 -00- 4752 BRISTOL BAY LAND CASH 0 . 00 65 , 000 . 00 0 . 00 85 , 000 . 00 * 100 . 0 __ ___ _ -_ __ __ _-- TOTAL CONTRIBUTIONS 2 , 619 . 32 127 , 972 . 07 1 , 365 , 997 . 00 525 , 406 . 00 24 . 3 TRANSFERS 72 -000-49-00- 4901 TRANSFER FROM GENERAL FUND 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72 -000-49-00- 4902 TRANSFER FROM LAND ACQUISITION 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72-000-49- 00- 4903 TRANSFER FROM PARK & REC 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 -----___ --_ _------_-__ -------------- _------ TOTAL TRANSFERS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL REVENUES : GENERAL 2 , 619 . 32 127 , 972 . 07 844 , 489 . 00 852 , 584 . 00 15 . 0 EXPENSES CAPITAL OUTLAY 72 -000-75-00- 7308 RIVERS EDGE PARK # 2 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P49 DATE : 04 /23/ 2009 UNITED CITY OF YORKVILLE PAGE : 50 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : LAND CASH FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL $ ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ______ ________ _____________________________________________ GENERAL EXPENSES CAPITAL OUTLAY 72-000-75-00-7317 HEARTLAND CIRCLE 0 . 00 124 , 456 . 68 167 , 000 . 00 167 , 000 . 00 74 . 5 72-000-75-00-7326 MOSIER HOLDING COSTS 0 . 00 6 , 000 . 00 10 , 000 . 00 6 , 000 . 00 * 100 . 0 72 -000-75-00-7327 GRANDE RESERVE PARK 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72-000-75-00-7328 PRAIRIE MEADOWS (MENARDS RES ) 0 . 00 148 , 206 . 26 295 , 000 . 00 138 , 636 . 00 * 106 . 9 72 -000-75- 00-7330 WHISPERING MEADOWS ( K . HILL ) 0 . 00 134 , 577 . 41 374 , 000 . 00 200 , 000 . 00 * 67 . 2 72 -000-75- 00-7332 CALEDONIA 0 . 00 0 . 00 88 , 000 . 00 0 . 00 * 0 . 0 72 -000-75- 00-7333 RAINTREE VILLAGE 0 . 00 3 , 404 . 90 70 , 000 . 00 5 , 000 . 00 * 68 . 0 72 -000-75-00-7334 HOOVER HOLDING COSTS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72 -000-75- 00-7335 GRANDE RESERVE BIKE TRAIL 0 . 00 50 , 186 . 56 0 . 00 50 , 187 . 00 * 99 . 9 _-___-_ ______-__ -_ ___ TOTAL CAPITAL OUTLAY 0 . 00 4661831 . 81 1 , 004 , 000 . 00 566 , 823 . 00 82 . 3 OTHER 72 -000-78 -00- 9009 RESERVE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 72 -000-78-00- 9012 REC CENTER AGREEMENT 0 . 00 100 , 000 . 00 0 . 00 100 , 000 . 00 * 100 . 0 TOTAL OTHER 0 . 00 100 , 000 . 00 0 . 00 100 , 000 . 00 100 . 0 TRANSFERS 72-000-99- 00- 9901 TRANSFER TO GENERAL FUND 169 , 000 . 00 181 , 000 . 00 16 , 000 . 00 181 , 000 . 00 * 100 . 0 _-__ _-___ _-___ TOTAL TRANSFERS 169 , 000 . 00 181 , 000 . 00 16 , 000 . 00 181 , 000 . 00 100 . 0 TOTAL EXPENSES : GENERAL 169 , 000 . 00 747 , 831 . 81 1 , 020 , 000 . 00 847 , 823 . 00 88 . 2 TOTAL FUND REVENUES 2 , 619 . 32 127 , 972 . 07 844 , 489 . 00 852 , 584 . 00 15 . 0 TOTAL FUND EXPENSES 169 , 000 . 00 747 , 831 . 81 1 , 020 , 000 . 00 847 , 823 . 00 88 . 2 FUND SURPLUS ( DEFICIT) ( 166 , 380 . 68 ) ( 619 , 859 . 74 ) ( 175 , 511 . 00 ) 4 , 761 . 00 ( 3019 . 5 ) * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P50 DATE : 04 /23 / 2009 UNITED CITY OF YORKVILLE PAGE : 51 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : PARKS & RECREATION FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ___________ _ _ _ GENERAL REVENUES CARRY OVER 79-000-40-00-3999 BEGINNING FUND BALANCE 0 . 00 0 . 00 0 . 00 ( 27 , 539 . 00 ) * 0 . 0 ________________ _ __ _ -___ TOTAL CARRY OVER 0 . 00 0 . 00 0 . 00 ( 27 , 539 . 00 ) 0 . 0 CHARGES FOR SERVICES 79-000- 42-00- 4270 FEES FOR PROGRAMS 8 , 209 . 00 211 , 231 . 44 300 , 000 . 00 240 , 000 . 00 * 88 . 0 79-000-42-00- 4280 CONCESSIONS /ALL SALE ITEMS 414 . 00 28 , 222 . 67 23 , 000 . 00 311000 . 00 * 91 . 0 79-000-42-00-4285 VENDING MACHINE INCOME 0 . 00 0 . 00 700 . 00 0 . 00 * 0 . 0 79-000-42- 00-4286 RENTAL INCOME 35 . 00 35 . 00 0 . 00 0 . 00 100 . 0 79-000-42- 00-4287 PARK RENTAL INCOME 61486 . 00 14 , 791 . 00 4 , 000 . 00 15 , 000 . 00 * 98 . 6 79-000- 42-00-4288 GOLF OUTING REVENUE 1 , 080 . 00 34 , 210 . 00 32 , 100 . 00 33 , 130 . 00 * 103 . 2 79-000-42 -00- 4291 HOMETOWN DAYS 0 . 00 110 , 762 . 71 115 , 000 . 00 110 , 363 . 00 * 100 . 3 __-_ _ _ __ ______ _ TOTAL CHARGES FOR SERVICES 16 , 224 . 00 399 , 252 . 82 474 , 600 . 00 429 , 493 . 00 92 . 9 MISCELLANEOUS 79-000-44-00- 4400 DONATIONS 510 . 00 15 , 411 . 00 20 , 000 . 00 12 , 000 . 00 * 128 . 4 79-000-44-00- 4404 TREE DONATIONS 800 . 00 800 . 00 11300 . 00 2 , 300 . 00 * 34 . 7 TOTAL MISCELLANEOUS 1 , 310 . 00 16 , 211 . 00 21 , 300 . 00 14 , 300 . 00 113 . 3 INTERGOVERNMENTAL 79-000-45- 00-4550 YOUTH SERVICES GRANT 0 . 00 2 , 000 . 00 21000. 00 21000 . 00 100 . 0 __ _ __ _ --_ _ -_ TOTAL INTERGOVERNMENTAL 0 . 00 21000 . 00 2 , 000 . 00 21000 . 00 100 . 0 INTEREST 79-000-46- 00-4600 INVESTMENT INCOME 23 . 58 1 , 303 . 04 12 , 000 . 00 3 , 000 . 00 * 43 . 4 -_ _ _ _ _ _-_________ __ TOTAL INTEREST 23 . 58 1 , 303 . 04 12 , 000 . 00 31000 . 00 43 . 4 TRANSFERS 79-000-49- 00-4901 TRANSFER FROM GENERAL FUND 137 , 178 . 52 1 , 080 , 348 . 00 11206 , 742 . 00 1 , 080 , 348 . 00 * 100 . 0 79-000-49- 00-4902 TRANSFER IN FROM GF - LOAN 200 , 000 . 00 200 , 000 . 00 0 . 00 0 . 00 100 . 0 79-000-49-00-4980 TRANSFER FROM REG CENTER 0 . 00 0 . 00 46 , 956 . 00 0 . 00 * 0 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P51 DATE : 04 /23/ 2009 UNITED CITY OF YORKVILLE PAGE : 52 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : PARKS & RECREATION FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL o ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED TOTAL TRANSFERS 337 , 178 . 52 1 , 280 , 348 00 11253 , 698 . 00 11080 , 348 . 00 118 . 5 TOTAL REVENUES : GENERAL 354 , 736 . 10 1 , 699 , 114 . 86 1 , 7631798 . 00 11501 , 602 . 00 113 . 1 EXPENSES TRANSFERS 79-000- 99-00- 9973 TRANSFER TO LAND ACQUISITION 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL TRANSFERS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 RECREATION CENTER EXPENSES PERSONNEL SERVICES 79- 600-50-00-5107 SALARIES - REC CENTER 0 . 00 0 . 00 33 , 000 . 00 0 . 00 * 0 . 0 _ ----------------------------------------- TOTAL PERSONNEL SERVICES 0 . 00 0 . 00 331000 . 00 0 . 00 0 . 0 CONTRACTUAL SERVICES 79- 600- 62 -00-5603 PUBLISHING/ADVERTISING 0 . 00 0 . 00 2 , 100 . 00 0 . 00 * 0 . 0 TOTAL CONTRACTUAL SERVICES 0 . 00 0 . 00 21100 . 00 0 . 00 0 . 0 OPERATIONS 79- 600-65-00-5804 OPERATING SUPPLIES 0 . 00 0 . 00 21000 . 00 0 . 00 * 0 . 0 ------------------------- ---------------- TOTAL OPERATIONS 0 . 00 0 . 00 2 , 000 . 00 0 . 00 0 . 0 RETIREMENT 79- 600-72-00- 6500 IMRF 0 . 00 0 . 00 3 , 801 . 00 0 . 00 * 0 . 0 79- 600-72-00- 6501 SOCIAL SECURITY 0 . 00 0 . 00 13 , 348 . 00 0 . 00 * 0 . 0 TOTAL RETIREMENT 0 . 00 0 . 00 17 , 149 . 00 0 . 00 0 . 0 CAPITAL OUTLAY 79-600-75-00-7002 COMPUTER EQUIP & SOFTWARE 0 . 00 0 . 00 16 , 500 . 00 0 . 00 0 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P52 DATE : 04 /23 /2009 UNITED CITY OF YORKVILLE PAGE : 53 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : PARKS & RECREATION FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED TOTAL CAPITAL OUTLAY 0 . 00 0 . 00 16 , 500 . 00 0 . 00 0 . 0 TOTAL EXPENSES : RECREATION CENTER 0 . 00 0 . 00 701749 . 00 0 . 00 0 . 0 PARKS EXPENSES PERSONNAL SERVICES 79- 610-50-00-5107 SALARIES- PARKS 45 , 374 . 97 363 , 832 . 01 412 , 500 . 00 393 , 250 . 00 * 92 . 5 79- 610- 50-00-5136 SALARIES- PART-TIME 0 . 00 27 , 583 . 05 55 , 000 . 00 30 , 000 . 00 * 91 . 9 79- 610-50-00-5137 SALARIES- OVERTIME 44 . 18 3 , 264 . 14 101000 . 00 7 , 500 . 00 * 43 . 5 ---_ _ _ _ __ _ -__----- TOTAL PERSONNAL SERVICES 45 , 419 . 15 3941679 . 20 477 , 500 . 00 430 , 750 . 00 91 . 6 PROFESSIONAL SERVICES 79- 610- 61-00-5320 MASTER PLAN / COMMUNITY SURVEY 0 . 00 1 , 155 . 00 2 , 709 . 00 11500 . 00 * 77 . 0 ----------------- __ _ __ _ ___- TOTAL PROFESSIONAL SERVICES 0 . 00 1 , 155 . 00 21709 . 00 11500 . 00 77 . 0 - CONTRACTUAL SERVICES 79- 610- 62-00-5405 PARK CONTRACTUAL 0 . 00 20 , 294 . 40 26 , 000 . 00 22 , 000 . 00 * 92 . 2 79- 610- 62-00-5408 MAINTENANCE-EQUIPMENT 1 , 360 . 43 7 , 894 . 08 10 , 000 . 00 7 , 000 . 00 * 112 . 7 79- 610- 62-00-5417 MAINTENANCE-PARKS 51254 . 17 26 , 066 . 35 55 , 000 . 00 35 , 000 . 00 * 74 . 4 79- 610- 62-00-5421 WEARING APPAREL 175 . 80 2 , 478 . 77 9 , 000 . 00 71000 . 00 * 35 . 4 79- 610- 62 -00- 5434 RENTAL-EQUIPMENT 65 . 56 11631 . 23 4 , 000 . 00 2 , 000 . 00 * 81 . 5 79- 610- 62 -00- 5438 CELLULAR TELEPHONE 344 . 48 31375 . 88 51000 . 00 51000 . 00 67 . 5 79- 610- 62 -00-5445 LEGAL EXPENSES 0 . 00 81755 . 55 71200 . 00 8 , 200 . 00 ^ 106 . 7 ---__------_ _ _ -__ ----------------------- TOTAL CONTRACTUAL SERVICES 7 , 200 . 44 70 , 496 . 26 116 , 200 . 00 86 , 200 . 00 81 . 7 PROFESSIONAL DEVELOPMENT 79- 610- 64 -00-5604 TRAINING & CONFERENCE 0 . 00 834 . 00 4 , 500 . 00 11000 . 00 * 83 . 4 79- 610- 64 -00-5605 TRAVEL EXPENSE 0 . 00 40 . 60 1 , 550 . 00 100 . 00 * 40 . 8 TOTAL PROFESSIONAL DEVELOPMENT 0 . 00 874 . 80 61050 . 00 1 , 100 . 00 79 . 5 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P53 DATE : 04 /23 / 2009 UNITED CITY OF YORKVILLE PAGE : 54 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . W0W FUND : PARKS & RECREATION FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED -- ---------------' PARKS OPERATIONS 79- 610- 65- 00-5802 OFFICE SUPPLIES 0 . 00 142 . 04 1 , 500 . 00 500 . 00 * 28 . 4 79- 610- 65- 00-5804 OPERATING SUPPLIES 843 . 99 22 , 325 . 47 35 , 750 . 00 25 , 750 . 00 * 86 . 7 79-610- 65- 00-5815 HAND TOOLS 38 . 98 922 . 94 3 , 500 . 00 1 , 500 . 00 * 61 . 5 79- 610- 65-00-5824 CHRISTMAS DECORATIONS 6 . 30 21329 . 70 21500 . 00 21500 . 00 93 . 1 79-610- 65- 00- 5825 PUBLIC DECORATION 0 . 00 0 . 00 11500 . 00 500 . 00 * 0 . 0 TOTAL OPERATIONS 889 . 27 25 , 720 . 15 44 , 750 . 00 30 , 750 . 00 83 . 6 RETIREMENT 79- 610-72- 00- 6500 IMRF PARTICIPANTS 31769 . 77 29 , 094 . 35 33 , 584 . 00 30 , 497 . 00 * 95 . 4 79-610-72-00- 6501 SOCIAL SECURITY/MEDICARE 3 , 474 . 56 30 , 193 . 09 37 , 593 . 00 32 , 952 . 00 * 91 . 6 TOTAL RETIREMENT 7 , 244 . 33 59 , 287 . 44 71 , 177 . 00 63 , 449 . 00 93 . 4 CAPITAL OUTLAY 79- 610-75-00-7003 OFFICE EQUIPMENT 0 . 00 0 . 00 4 , 000 . 00 500 . 00 * 0 . 0 79- 610-75-00-7701 FLOWERS/TREES 0 . 00 ( 33 . 38 ) 6 , 000 . 00 4 , 000 . 00 * ( 0 . 8 ) TOTAL CAPITAL OUTLAY 0 . 00 ( 33 . 38 ) 10 , 000 . 00 41500 . 00 ( 0 . 7 ) OTHER OPERATING EXPENSES 79- 610-78-00- 9005 MERIT 0 . 00 0 . 00 16 , 500 . 00 0 . 00 * 0 . 0 ----------------- ------------------------------------------------ -------- -------- TOTAL OTHER OPERATING EXPENSES 0 . 00 0 . 00 16 , 500 . 00 0 . 00 0 . 0 TOTAL EXPENSES : PARKS 60 , 753 . 19 552 , 179 . 47 744 , 886 . 00 618 , 249 . 00 89 . 3 RECREATION EXPENSES PERSONNEL SERVICES 79-650-50- 00-5107 SALARIES- RECREATION 70 , 194 . 95 351 , 655 . 96 359 , 525 . 00 370 , 282 . 00 * 94 . 9 79- 650-50-00-5108 CONCESSION STAFF 0 . 00 8 , 554 . 27 81000 . 00 97500 . 00 * 90 . 0 79- 650-50- 00-5109 SALARIES- PRE SCHOOL 31194 . 88 34 , 203 . 76 90 , 000 . 00 24 , 000 . 00 * 142 . 5 79-650-50-00-5136 SALARIES-PART TIME 4 , 470 . 37 38 , 862 . 39 39 , 110 . 00 36 , 110 . 00 * 107 . 6 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P54 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 55 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : PARKS & RECREATION FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL $ ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED -_ -------------------------- _ ___ _ RECREATION EXPENSES PERSONNEL SERVICES 79- 650-50-00- 5137 SALARIES- OVERTIME 0 . 00 0 . 00 350 . 00 200 . 00 * 0 . 0 79- 650-50- 00-5150 SALARIES- INSTRUCTOR CONTRACTU 7 , 105 . 34 104 , 788 . 42 80 , 000 . 00 99 , 000 . 00 * 105 . 8 79- 650- 50- 00-5155 SALARIES- RECORDING SECRETARY 265 . 50 2 , 509 . 87 21750 . 00 2 , 500 . 00 * 100 . 3 TOTAL PERSONNEL SERVICES 85 , 231 . 04 540 , 574 . 67 579 , 735 . 00 541 , 592 . 00 99 . 8 CONTRACTUAL SERVICES 79- 650- 62- 00- 5408 MAINTENANCE SUPPLIES 0 . 00 3 , 101 . 94 51500 . 00 4 , 200 . 00 * 73 . 8 79- 650- 62- 00- 5409 MAINTENANCE-VEHICLES 0 . 00 1 , 537 . 11 3 , 000 . 00 2 , 000 . 00 * 76 . 8 79-650- 62-00- 5410 MAINTENANCE-OFFICE EQUIPMENT 245 . 95 3 , 910 . 85 7 , 000 . 00 6 , 000 . 00 * 65 . 1 79- 650- 62-00- 5426 YOUTH SERVICES GRANT EXPENSES 0 . 00 488 . 64 2 , 000 . 00 1 , 000 . 00 * 48 . 8 79- 650- 62- 00-5435 ELECTRICITY 562 . 73 11 , 422 . 79 10 , 000 . 00 10 , 000 . 00 114 . 2 79-650- 62- 00- 5437 TELEPHONE/ INTERNET 104 . 82 1 , 011 . 51 1 , 500 . 00 1 , 300 . 00 * 77 . 8 79-650- 62- 00- 5438 CELLULAR TELEPHONE 430 . 59 41092 . 33 5 , 000 . 00 41500 . 00 * 90 . 9 79- 650- 62- 00-5445 PORTABLE TOILETS 0 . 00 4 , 918 . 39 6 , 000 . 00 4 , 500 . 00 * 109 . 2 79- 650- 62-00-5603 PUBLISHING/ADVERTISING 0 . 00 32 , 618 . 60 29 , 000 . 00 29 , 000 . 00 112 . 4 79- 650- 62- 00-5605 BOOKS/ PUBLICATIONS 0 . 00 707 . 89 422 . 00 300 . 00 * 235 . 9 -------- ----' ----------- TOTAL CONTRACTUAL SERVICES 1 , 344 . 09 63 , 810 . 25 69 , 422 . 00 62 , 800 . 00 101 . 6 PROFESSIONAL DEVELOPMENT 79- 650-64 -00-5600 DUES 0 . 00 713 . 00 21750 . 00 2 , 000 . 00 * 35 . 6 79- 650- 64-00-5604 TRAINING AND CONFERENCES 60 . 00 2 , 455 . 00 47500 . 00 11500 . 00 * 163 . 6 79- 650- 64-00-5605 TRAVEL EXPENSE 0 . 00 353 . 52 1 , 550 . 00 700 . 00 * 50 . 5 TOTAL PROFESSIONAL DEVELOPMENT 60 . 00 31521 . 52 81800 . 00 4 , 200 . 00 83 . 8 OPERATIONS 79- 650- 65-00-5802 OFFICE SUPPLIES 584 . 90 4 , 485 . 30 7 , 000 . 00 6 , 000 . 00 * 74 . 7 79- 650- 65-00-5803 PROGRAM EXPENSES 3 , 950 . 80 51 , 494 . 73 50 , 000 . 00 50 , 000 . 00 102 . 9 79- 650- 65-00-5804 OPERATING SUPPLIES 41 . 57 629 . 40 3 , 600 . 00 3 , 000 . 00 * 20 . 9 79- 650- 65-00-5805 RECREATION EQUIPMENT 0 . 00 1 , 787 . 81 10 , 000 . 00 5 , 000 . 00 * 35 . 7 79-650- 65-00- 5808 POSTAGE & SHIPPING 669 . 80 10 , 835 . 66 7 , 800 . 00 9 , 600 . 00 * 112 . 8 79- 650- 65-00-5812 GASOLINE 80 . 16 4 , 253 . 42 5 , 000 . 00 5 , 000 . 00 85 . 0 79- 650- 65-00-5826 MILEAGE 0 . 00 145 . 74 400 . 00 - 400 . 00 36 . 4 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P55 DATE : 04 /23 /2009 UNITED CITY OF YORKVILLE PAGE : 56 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL433000 . WOW FUND : PARKS & RECREATION FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL $ ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ----------------- ___ __ RECREATION EXPENSES OPERATIONS 79-650- 65-00-5827 GOLF OUTING EXPENSES 0 . 00 21 , 457 . 33 20 , 200 . 00 21 , 457 . 00 * 100 . 0 79-650- 65- 00-5826 CONCESSIONS 35 . 00 16 , 844 . 43 11 , 500 . 00 181000 . 00 * 93 . 5 79-650- 65- 00-5833 HOMETOWN DAYS EXPENSES 0 . 00 93 , 881 . 09 95 , 000 . 00 94 , 000 . 00 * 99 . 8 79- 650- 65- 00- 5640 SCHOLARSHIPS 0 . 00 904 . 50 6 , 825 . 00 3 , 000 . 00 * 30 . 1 79-650- 65-00-5841 PROGRAM REFUND 553 . 00 12 , 799 . 41 91000 . 00 9 , 000 . 00 142 . 2 TOTAL OPERATIONS 51915 . 23 219 , 518 . 82 226 , 325 . 00 224 , 457 . 00 97 . 7 RETIREMENT 79- 650-72-00- 6500 IMRF PARTICIPANTS 6 , 149 . 04 32 , 623 . 81 29 , 678 . 00 28 , 194 . 00 * 115 . 7 79- 650-72 -00- 6501 SOCIAL SECURITY/MEDICARE 6 , 130 . 39 37 , 778 . 46 45 , 003 . 00 33 , 667 . 00 * 112 . 2 TOTAL RETIREMENT 12 , 279 . 43 70 , 402 . 27 74 , 681 . 00 61 , 861 . 00 113 . 6 CAPITAL OUTLAY 79- 650-75-00-7002 COMPUTER EQUIP & SOFTWARE 0 . 00 154 . 85 3 , 400 . 00 1 , 000 . 00 * 15 . 4 TOTAL CAPITAL OUTLAY 0 . 00 154 . 85 31400 . 00 1 , 000 . 00 15 . 4 OTHER OPERATING EXPENSES 79- 650-78-00- 9005 MERIT 0 . 00 0 . 00 19 , 381 . 00 0 . 00 * 0 . 0 79- 650-78-00- 9009 RESERVE 0 . 00 440 . 00 131168 . 00 1 , 000 . 00 * 44 . 0 TOTAL OTHER OPERATING EXPENSES 0 . 00 940 . 00 27 , 549 . 00 11000 . 00 44 . 0 TOTAL EXPENSES : RECREATION 104 , 829 . 79 898 , 422 . 38 989 , 912 . 00 8960910 . 00 100 . 1 TOTAL FUND REVENUES 354 , 736 . 10 1 , 699, 114 . 86 1 , 763 , 798 . 00 11501 , 602 . 00 113 . 1 TOTAL FUND EXPENSES 165 , 582 . 98 11950 , 601 . 85 11805 , 547 . 00 11515 , 159 . 00 95 . 7 FUND SURPLUS ( DEFICIT ) 189 , 153 . 12 298 , 513 . 01 ( 91 , 749 . 00 ) ( 13 , 557 . 00 ) ( 1833 . 0 ) * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P56 DATE : 04 /23 /2009 UNITED CITY OF YORKVILLE PAGE : 57 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : RECREATION CENTER FOR 11 PERIODS ENDING . MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED __ _ _ ___ GENERAL REVENUES CHARGES FOR SERVICES 80-000-42-00-4200 MEMBERSHIP FEES 28 , 728 . 00 263 , 158 . 22 423 , 890 . 00 333 , 000 . 00 * 85 . 0 80-000-42-00-4210 GUEST FEES 346 . 00 7 , 097 . 00 71167 . 00 7 , 200 . 00 * 98 . 5 80-000-42-00-4220 SWIM CLASS 2 , 814 . 00 14 , 338 . 00 20 , 000 . 00 20 , 000 . 00 71 . 6 80-000- 42-00- 4230 PERSONAL TRAINING FEES 11665 . 00 10 , 777 . 75 18 , 750 . 00 181750 . 00 57 . 4 80-000-42-00-4240 TANNING SESSIONS 476 . 00 2 , 107 . 00 7 , 500 . 00 5 , 000 . 00 * 42 . 1 80-000-42- 00- 4270 FEES FOR PROGRAMS 11 , 358 . 00 112 , 946 . 88 125 , 000 . 00 159 , 300 . 00 * 70 . 9 80-000-42-00-4280 CONCESSIONS 959 . 58 7 , 280 . 65 11 , 666 . 00 12 , 000 . 00 * 60 . 6 80- 000-42-00- 4285 VENDING MACHINES 0 . 00 0 . 00 500 . 00 0 . 00 * 0 . 0 80-000-42-00-4286 RENTAL INCOME 553 . 50 31899 . 75 41333 . 00 4 , 400 . 00 * 86 . 6 TOTAL CHARGES FOR SERVICES 46 , 900 . 06 441 , 605 . 25 618 , 806 . 00 559 , 650 . 00 78 . 9 MISCELLANEOUS 80-000-44-00-4400 DONATIONS/SPONSORSHIP 0 . 00 21847 . 00 31200 . 00 9 , 000 . 00 31 . 6 TOTAL MISCELLANEOUS 0 . 00 21847 . 00 3 , 200 . 00 91000 . 00 31 . 6 INTERGOVERNMENTAL 80-000-45-00-4550 GRANTS /SCHOLARSHIPS 0 . 00 0 . 00 1 , 000 . 00 11000 . 00 0 . 0 ______ __ __ _ _ _ TOTAL INTERGOVERNMENTAL 0 . 00 0 . 00 11000 . 00 1 , 000 . 00 0 . 0 TOTAL REVENUES : GENERAL 46 , 900 . 08 444 , 452 . 25 623 , 006 . 00 569 , 650 . 00 78 . 0 EXPENSES PERSONNEL SERVICES 80-000-50-00- 5107 SALARIES- REC CENTER 3 , 946 . 15 25 , 123 . 84 32 , 000 . 00 29 , 000 . 00 * 86 . 6 B0-000-50- 00- 5109 SALARIES- PRESCHOOL 4 , 718 . 60 32 , 196 . 24 63 , 000 . 00 61 , 000 . 00 * 52 . 7 80-000-50- 00-5136 SALARIES- PART TIME 12 , 490 . 50 81 , 101 . 55 114 , 515 . 00 1091541 . 00 * 74 . 0 80-000-50-00- 5137 SALARIES- OVERTIME 0 . 00 952 . 90 21000 . 00 21000 . 00 47 . 6 80-000-50-00-5150 SALARIES- INSTRUCTORS 7 , 670 . 50 52 , 875 . 63 8 , 000 . 00 47 , 000 . 00 * 112 . 5 ______________________ ____ ___________ __ __ _--__ TOTAL PERSONNEL SERVICES 28 , 825 . 75 192 , 250 . 16 219 , 515 . 00 246 , 541 . 00 77 . 3 * PLEASE ,SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P57 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 58 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . W0W FUND : RECREATION CENTER FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL $ ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ------------------------- _ _ GENERAL CONTRACTUAL SERVICES 80-000- 62- 00- 5408 MAINTENANCE SUPPLIES 785 . 59 13 , 416 . 84 6 , 750 . 00 12 , 000 . 00 * 111 . 8 80-000- 62-00- 5410 MAINTENANCE- OFFICE EQUIP . 251 . 22 1 , 678 . 18 51650 . 00 4 , 000 . 00 * 41 . 9 80-000- 62-00- 5416 MAINTENANCE- GENERAL 849 . 40 15 , 054 . 98 31800 . 00 12 , 000 . 00 * 125 . 4 80-000- 62 -00- 5426 GRANTS 0 . 00 0 . 00 10000 . 00 10000 . 00 0 . 0 80-000-62-00- 5430 TOWEL RENTAL 0 . 00 535 . 94 900 . 00 900 . 00 59 . 5 80-000- 62 -00- 5431 POOL REPAIR 0 . 00 903 . 37 1 , 240 . 00 3 , 240 . 00 * 27 . 8 80-000-62-00- 5432 LEASE PAYMENT 17 , 500 . 00 175 , 000 . 00 175 , 000 . 00 175 , 000 . 00 100 . 0 80-000- 62-00-5433 LICENSES/PERMITS 0 . 00 342 . 06 5 , 300 . 00 1 , 000 . 00 * 34 . 2 80-000- 62-00-5434 POOL SUPPLIES 0 . 00 4 , 048 . 45 4 , 400 . 00 5 , 000 . 00 * 60 . 9 80-000- 62-00-5435 ELECTRICITY 2 , 638 . 85 24 , 757 . 56 47 , 250 . 00 27 , 250 . 00 * 90 . 8 80-000- 62-00-5437 TELEPHONE/ INTERNET/CABLE 1? 1 . 27 1 , 220 . 19 41900 . 00 2 , 500 . 00 * 48 . 8 80-000-62 -00-5438 CELLULAR PHONE 43 . 06 480 . 68 500 . 00 500 . 00 96 . 1 80-000-62 -00-5439 PROPERTY TAX 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 80-000-62-00-5440 SECURITY 0 . 00 180 . 00 720 . 00 720 . 00 25 . 0 80-000-62 -00-5603 PUBLISHING/ADVERTISING 29 . 50 563 . 59 2 , 100 . 00 1 , 100 . 00 * 51 . 2 80-000-62-00-5605 BOOKS/PUBLICATION 0 . 00 105 . 39 100 . 00 100 . 00 105 . 3 TOTAL CONTRACTUAL SERVICES 22 , 218 . 89 238 , 287 . 23 259 , 610 . 00 246 , 310 00 96 . 7 PROFESSIONAL DEVELOPMENT 80-000- 64 -00- 5600 DUES 0 . 00 174 . 00 900 . 00 200 . 00 * 87 . 0 80-000- 64- 00- 5604 TRAINING & CONFERENCES 0 . 00 660 . 30 1 , 000 . 00 600 . 00 * 110 . 0 80-000- 64-00-5605 TRAVEL EXPENSES 0 . 00 70 . 24 500 . 00 200 . 00 * 35 . 1 TOTAL PROFESSIONAL DEVELOPMENT 0 . 00 904 . 54 21400 . 00 1 , 000 . 00 90 . 4 OPERATIONS 80-000-65-00-5802 OFFICE SUPPLIES 0 . 00 4 , 997 . 85 4 , 375 . 00 5 , 500 . 00 * 90 . 8 80-000- 65-00-5803 PROGRAM EXPENSES 2 , 064 . 02 16 , 669 . 03 18 , 300 . 00 12 , 000 . 00 * 138 . 9 80-000- 65-00- 5804 OPERATING SUPPLIES 0 . 00 21946 . 08 2 , 000 . 00 31$ 00 . 00 * 77 . 5 80-000- 65-00-5805 RECREATION EQUIPMENT 0 . 00 6 , 678 . 03 10 , 000 . 00 13 , 000 . 00 * 51 . 3 80-000- 65- 00- 5808 POSTAGE & SHIPPING 0 . 00 73 . 15 11100 . 00 300 . 00 * 24 . 3 80-000- 65-00- 5812 GASOLINE 0 . 00 0 . 00 1 , 000 . 00 200 . 00 * 0 . 0 80-000- 65-00- 5826 MILEAGE 0 . 00 86 . 60 300 . 00 300 . 00 28 . 8 80-000- 65-00- 5828 CONCESSIONS EXPENSES 135 . 92 4 , 068 . 31 90000 . 00 81136 . 00 * 50 . 0 80-000- 65- 00- 5840 SCHOLARSHIPS 0 . 00 0 . 00 1 , 000 . 00 11000 . 00 0 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P58 DATE : 04 /23 /2009 UNITED CITY OF YORKVILLE PAGE : 59 TIME : 13 : 52 : 15 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . W0W FUND : RECREATION CENTER FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED -__ -_ _ GENERAL EXPENSES OPERATIONS 80-000- 65-00-5841 PROGRAM REFUNDS 242 . 00 2 , 262 . 00 4 , 000 . 00 2 , 000 . 00 * 113 . 1 80-000- 65-00- 5842 MEMBERSHIP REFUNDS 278 . 00 1 , 058 . 00 0 . 00 0 . 00 ( 100 . 0 ) --_ -__ _ _ __ -__ _ _ TOTAL OPERATIONS 2 , 719 . 94 38 , 839 . 05 51 , 075 . 00 46 , 236 . 00 84 . 0 RETIREMENT 80-000-72-00- 6500 IMRF 461 . 35 3 , 767 . 63 3 , 801 . 00 2 , 359 . 00 * 159 . 7 80-000-72-00- 6501 SOCIAL SECURITY 2 , 164 . 13 14 , 052 . 94 12 , 348 . 00 19 , 013 . 00 * 73 . 9 TOTAL RETIREMENT 21625 . 48 171820 . 57 16 , 149 . 00 21 , 372 . 00 83 . 3 CAPITAL OUTLAY 80-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 0 . 00 22 , 277 . 84 16 , 500 . 00 13 , 873 . 00 * 160 . 5 80-000-75-00-7003 OFFICE EQUIPMENT 0 . 00 0 . 00 2 , 500 . 00 200 . 00 * 0 . 0 80-000-75-00-7500 PHONE SYSTEM 0 . 00 6 , 074 . 00 8 , 300 . 00 61100 . 00 * 99 . 5 --_ __ _ _ -_ --------_ TOTAL CAPITAL OUTLAY 0 . 00 28 , 351 . 84 27 , 300 . 00 20 , 173 . 00 140 . 5 OTHER OPERATING EXPENSES 80-000-78-00- 9002 NICOR 21079 . 07 14 , 263 . 73 0 . 00 0 . 00 ( 100 . 0 ) TOTAL OTHER OPERATING EXPENSES 2 , 079 . 07 14 , 263 . 73 0 . 00 0 . 00 ( 100 . 0 ) TRANSFERS 80-000- 99- 00- 9979 TRANSFER TO PARKS & REC 0 . 00 0 . 00 46 , 956 . 00 0 . 00 * 0 . 0 TOTAL TRANSFERS 0 . 00 0 . 00 46 , 956 . 00 0 . 00 0 . 0 TOTAL EXPENSES : GENERAL 58 , 469 . 13 530 , 717 . 12 623 , 005 . 00 583 , 632 . 00 90 . 9 TOTAL FUND REVENUES 46 , 900 . 08 444 , 452 . 25 623 , 006 . 00 569 , 650 . 00 78 . 0 TOTAL FUND EXPENSES 58 , 469 . 13 530 , 717 . 12 623 , 005 . 00 583 , 632 . 00 90 . 9 FUND SURPLUS ( DEFICIT ) ( 11 , 569 . 05 ) ( 86 , 264 . 87 ) 1 . 00 ( 13 , 982 . 00 ) 616 . 9 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P59 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 000 TIME : 13 : 52 : 16 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : LIBRARY FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL % ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ____________ ______________________ _ ___________ ________________________ GENERAL REVENUES TAXES 82-000-40-00-3992 LIBRARY BOND PROP . TAX 0 . 00 463 , 324 . 18 467 , 425 . 00 467 , 425 . 00 99 . 1 82-000-40- 00- 39966 CARRY OVER- BOOK DEV FEES 0 . 00 0 . 00 186 , 700 . 00 0 . 00 * 0 . 0 82-000-40- 00- 3997 CARRY OVER - BLDG DEV FEES 0 . 00 0 . 00 171 , 782 . 00 282 , 310 . 00 * 0 . 0 82 -000-40- 00- 3998 CARRY OVER - MEMORIALS 0 . 00 0 . 00 0 . 00 1 , 644 . 00 * 0 . 0 82 -000-40- 00-3999 CARRY OVER - FUND BALANCE 0 . 00 0 . 00 0 . 00 600 , 755 . 00 * 0 . 0 82 -000-40-00- 4000 REAL ESTATE TAXES 0 . 00 652 , 084 . 86 658 , 252 . 00 658 , 252 . 00 99 . 0 82 -000-40-00- 4010 PERSONAL PROPERTY TAX 223 . 80 4 , 550 . 85 3 , 360 . 00 3 , 360 . 00 135 . 4 ___ _ ___________________________ TOTAL TAXES 223 . 80 11119 , 959 . 89 1 , 487 , 519 . 00 2 , 013 , 746 . 00 55 . 6 CHARGES FOR SERVICES 82 -000-42 -00-4211 DEVELOPMENT FEES - BUILDING 0 . 00 32 , 700 . 00 100 , 000 . 00 100 , 000 . 00 32 . 7 82-000-42-00-4215 DEVELOPMENT FEES - BOOKS 0 . 00 32 , 700 . 00 100 , 000 . 00 100 , 000 . 00 32 . 7 82 -000-42-00-4260 COPY FEES 317 . 00 21460 . 02 2 , 500 . 00 2 , 500 . 00 98 . 4 82 -000-42-00- 4261 LIBRARY SUBSCRIPTION CARDS 1 , 134 . 20 15 , 401 . 04 15 , 000 . 00 15 , 000 . 00 102 . 6 82-000-42-00- 9286 RENTAL INCOME 0 . 00 329 . 40 41000 . 00 4 , 000 . 00 8 . 2 82-000-42-00- 4287 LIBRARY BLDG RENTAL 127 . 95 731 . 20 1 , 500 . 00 1 , 500 . 00 48 . 7 TOTAL CHARGES FOR SERVICES 1 , 579 . 15 84 , 321 . 66 223 , 000 . 00 223 , 000 . 00 37 . 8 FINES 82-000-43- 00- 4330 LIBRARY FINES 672 . 13 8 , 649 . 54 71000 . 00 7 , 000 . 00 123 . 5 TOTAL FINES 6672 . 13 81649 . 54 7 , 000 . 00 7 , 000 . 00 123 . 5 MISCELLANEOUS 82 -000-44 -00- 4432 SALE OF BOOKS 22 . 30 633 . 65 10000 . 00 1 , 000 . 00 63 . 3 82 -000-44-00- 4450 MEMORIALS ( 510 . 00 ) 1 , 203 . 00 4 , 000 . 00 4 , 000 . 00 30 . 0 TOTAL MISCELLANEOUS ( 487 . 70 ) 1 , 836 . 65 51000 . 00 5 , 000 . 00 36 . 7 INTERGOVERNMENTAL 82-000-45-00-4550 GRANTS 0 . 00 0 . 00 170500 . 00 17 , 500 . 00 0 . 0 TOTAL INTERGOVERNMENTAL 0 . 00 0 . 00 17 , 500 . 00 17 , 500 . 00 0 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P60 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 61 TIME : 13 : 52 : 16 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : LIBRARY FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED _________ __ __ GENERAL INTEREST 82-000- 46-00-4600 INVESTMENT INCOME 387 . 54 10 , 796 . 83 2 , 500 . 00 2 , 500 . 00 431 . 8 ____ __________ __ _________________ ______ TOTAL INTEREST 387 . 54 10 , 796 . 83 2 , 500 . 00 21500 . 00 431 . 8 TOTAL REVENUES : GENERAL 2 , 374 . 92 1 , 225 , 564 . 57 11742 , 519 . 00 2 , 268 , 746 . 00 54 . 0 EXPENSES PERSONNEL SERVICES 82-000- 50-00-5107 SALARIES- LIBRARY 52 , 235 . 55 385 , 296 . 42 600 , 000 . 00 600 , 000 . 00 64 . 2 82-000-50-00-5203 GROUP HEALTH INSURANCE 31961 . 89 39 , 533 . 07 52 , 800 . 00 52 , 800 . 00 74 . 8 82-000-50-00-5204 GROUP LIFE INSURANCE 82 . 68 826 . 80 3 , 000 . 00 31000 . 00 27 . 5 82- 000- 50-00-5205 DENTAL & VISION ASSISTANCE 331 . 24 3 , 347 . 30 41200 . 00 4 , 200 . 00 79 . 6 ____ _ __ _ ______ TOTAL PERSONNEL SERVICES 56 , 611 . 36 429 , 003 . 59 660 , 000 . 00 660 , 000 . 00 65 . 0 PROFESSIONAL SERVICES 82-000- 61- 00- 5322 BONDING 0 . 00 1 , 875 . 00 21000 . 00 2 , 000 . 00 93 . 7 82-000- 61- 00- 5323 ATTORNEY 0 . 00 595 . 00 3 , 000 . 00 3 , 000 . 00 19 . 8 TOTAL PROFESSIONAL SERVICES 0 . 00 2 , 470 . 00 5 , 000 . 00 5 , 000 . 00 49 . 4 CONTRACTUAL SERVICES 82-000- 62 -00-5401 CONTRACT SERVICES 3 , 740 . 48 14 , 045 . 15 20 , 000 . 00 20 , 000 . 00 70 . 2 82 -000- 62 -00-5407 MAINTENANCE-BLDG/JANITORIAL 3 , 055 . 65 8 , 905 . 11 10 , 000 . 00 101000 . 00 89 . 0 82 -000- 62 -00-5410 MAINTENANCE-OFFICE EQUIPMENT 1 , 421 . 98 5 , 906 . 70 10 , 000 . 00 10 , 000 . 00 59 . 0 82 -000- 62 -00-5412 MAINTENANCE-PHOTOCOPIER 23 . 27 1 , 637 . 87 10 , 000 . 00 101000 . 00 16 . 3 82 -000- 62-00-5435 ELECTRICITY 0 . 00 1 , 371 . 00 5 , 000 . 00 51000 . 00 27 . 4 82 -000- 62-00- 5436 TELEPHONE 358 . 84 31164 . 26 71000 . 00 7 , 000 . 00 45 . 2 82-000- 62- 00-5437 NICOR GAS 2 , 088 . 41 10 , 379 . 76 40 , 000 . 00 40 , 000 . 00 25 . 9 ________ _ ____ __ __--_ TOTAL CONTRACTUAL SERVICES 10 , 688 . 63 45-, 409 . 85 102 , 000 . 00 102 , 000 . 00 44 . 5 PROFESSIONAL DEVELOPMENT 82 -000- 64 - 00-5603 SUBSCRIPTIONS 332 . 00 5 , 172 . 17 8 , 000 . 00 8 , 000 . 00 64 . 6 82 -000- 64- 00-5604 TRAINING & CONFERENCES 0 . 00 924 . 90 2 , 000 . 00 2 , 000 . 00 46 . 2 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P61 DATE : 04 /23 /2009 UNITED CITY OF YORKVILLE PAGE : 62 TIME : 13 : 52 : 16 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : LIBRARY FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL $ ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ___-__-_-__ _ ___ GENERAL EXPENSES PROFESSIONAL DEVELOPMENT 82-000- 64 - 00- 5607 PUBLIC RELATIONS 0 . 00 0 . 00 2 , 000 . 00 2 , 000 . 00 0 . 0 82-000- 64 -00- 5616 EMPLOYEE RECOGNITION 0 . 00 11194 . 46 31000 . 00 3 , 000 . 00 39 . 8 __ _---- -_ __-- TOTAL PROFESSIONAL DEVELOPMENT 332 . 00 7 , 291 . 53 15 , 000 . 00 15 , 000 . 00 48 . 6 OPERATIONS 82 -000- 65-00-5800 CONTINGENCIES 44 . 25 7 , 429 . 98 64 , 574 . 00 590 , 801 . 00 1 . 2 82-000- 65-00-5802 OFFICE SUPPLIES 1 , 239 . 83 4 , 762 . 87 10 , 000 . 00 10 , 000 . 00 47 . 6 82-000- 65-00-5806 LIBRARY SUPPLIES 485 . 17 5 , 682 . 28 10 , 000 . 00 10 , 000 . 00 56 . 8 82 -000- 65-00-5807 CUSTODIAL SUPPLIES 1 , 117 . 09 6 , 766 . 13 15 , 000 . 00 15 , 000 . 00 45 . 1 82 -000- 65- 00-5808 POSTAGE & SHIPPING 278 . 70 698 . 70 21000 . 00 2 , 000 . 00 34 . 9 82 -000- 65-00-5810 PUBLISHING & ADVERTISING 0 . 00 35 . 50 2 , 000 . 00 2 , 000 . 00 1 . 7 82 -000- 65-00-5826 MILEAGE 92 . 92 705 . 86 1 , 000 . 00 1 , 000 . 00 70 . 5 82 -000- 65-00-5832 VIDEOS 0 . 00 41961 . 20 51000 . 00 51000 . 00 99 . 2 82 -000- 65-00-5833 ALARM MONITORING 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 82 -000- 65-00-5834 LIBRARY PROGRAMMING 11138 . 22 71864 . 67 10 , 000 . 00 10 , 000 . 00 78 . 6 82 -000- 65-00-5835 LIBRARY BOARD EXPENSES 0 . 00 147 . 38 2 , 000 . 00 2 , 000 . 00 7 . 3 82 -000- 65-00- "x836 BOOKS-ADULT 628 . 77 19 , 373 . 79 15 , 000 . 00 15 , 000 . 00 129 . 1 82 -000-65-00-5837 BOOKS-JUVENILE 0 . 00 16 , 604 . 18 20 , 000 . 00 20 , 000 . 00 83 . 0 82 -000- 65-00-5838 BOOKS-AUDIO 347 . 95 61483 . 54 10 , 000 . 00 10 , 000 . 00 64 . 8 82 -000- 65-00-5839 BOOKS-REFERENCE 2 , 616 . 50 15 , 894 . 51 20 , 000 . 00 20 , 000 . 00 79 . 4 82 -000- 65-00-5840 BOOKS-DEVELOPMENT FEE 3 , 120 . 35 32 , 571 . 61 100 , 000 . 00 100 , 000 . 00 32 . 5 82 -000- 65-00-5841 MEMORIALS/GIFTS 0 . 00 2 , 014 . 87 41000 . 00 41000 . 00 50 . 3 82-000-65-00-5842 BLDG-DEVELOPMENT FEES 0 . 00 61850 . 22 100 , 000 . 00 1001000 . 00 6 . 8 82-000- 65-00-5843 CD ' S/MUSIC 247 . 90 21523 . 62 5 , 000 . 00 5 , 000 . 00 50 . 4 82 -000-65-00-5844 MEETING ROOM 0 . 00 0 . 00 1 , 500 . 00 1 , 500 . 00 0 . 0 -----_-_ _ __ _-_-- TOTAL OPERATIONS 11 , 357 . 65 141 , 370 . 91 397 , 074 . 00 9231301 . 00 15 . 3 DEBT SERVICE 82 -000- 66- 00- 6012 20058 LIBRARY BOND ( 19 . 35 ) 346 , 105 . 67 346 , 145 . 00 346 , 145 . 00 99 . 9 82 -000- 66-00- 6014 2006 LIBRARY BOND 0 . 00 121 , 300 . 00 121 , 300 . 00 121 , 300 . 00 100 . 0 TOTAL DEBT SERVICE ( 19 . 35 ) 467 , 405 . 67 467 , 445 . 00 467 , 445 . 00 99 . 9 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P62 DATE : 04 /23/ 2009 UNITED CITY OF YORKVILLE PAGE : 63 TIME : 13 : 52 : 16 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : LIBRARY FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL - ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ___ ___ __ _______ GENERAL RETIREMENT 82-000-72- 00- 6500 IMRF PARTICPANTS 1 , 989 . 07 13 , 134 . 90 13 , 000 . 00 13 , 000 . 00 101 . 0 82-000-72- 00- 6501 SOCIAL SECURITY/MEDICARE 3 , 995 . 98 29 , 475 . 00 40 , 000 . 00 40 , 000 . 00 73 . 6 __ ____ __ _________________________ TOTAL RETIREMENT 5 , 985 . 05 42 , 609 . 90 53 , 000 . 00 53 , 000 . 00 80 . 3 CAPITAL OUTLAY 62 -000-75-00-7002 COMPUTER EQUIPMENT & SOFTWARE 3 , 594 . 97 11 , 131 . 08 18 , 000 . 00 18 , 000 . 00 61 . 8 82-000-75- 00-7003 AUTOMATION 91 . 97 26 , 890 . 13 25 , 000 . 00 25 , 000 . 00 107 . 5 82- 000-75-00-7703 BUILDING EXPANSION 0 . 00 28 , 150 . 61 0 . 00 0 . 00 ( 100 . 0 ) TOTAL CAPITAL OUTLAY 3 , 686 . 94 66 , 171 . 82 43 , 000 00 43 , 000 . 00 153 . 8 OTHER OPERATING EXPENSES 82 -000-78- 00- 9020 LIBRARY BOND PAYBACK 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL OTHER OPERATING EXPENSES 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL EXPENSES : GENERAL 88 , 642 . 28 11201 , 733 . 27 11742 , 519 . 00 21268 , 746 . 00 52 . 9 TOTAL FUND REVENUES 2 , 374 . 92 1 , 225 , 564 . 57 1 , 742 , 519 . 00 2 , 268 , 746 . 00 54 . 0 TOTAL FUND EXPENSES 88 , 642 . 28 1 , 2011733 . 27 11742 , 519 . 00 21268 , 746 . 00 52 . 9 FUND SURPLUS ( DEFICIT ) ( 86 , 267 . 36 ) 23 , 831 . 30 0 . 00 0 . 00 100 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P63 DATE : 04 /23/ 2009 UNITED CITY OF YORKVILLE PAGE : 64 TIME : 13 : 52 : 16 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : FOX INDUSTRIAL FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ------------------------------- ___ GENERAL REVENUES TAKES 85-000-40-00- 3999 BEGINNING FUND BALANCE 0 . 00 0 . 00 93 , 924 . 00 183 , 227 . 00 * 0 . 0 85-000-40-00-4090 TIF REVENUES 0 . 00 207 , 397 . 54 77 , 430 . 00 200 , 863 . 00 * 103 . 2 ___-_ __ ___ ___ TOTAL TAXES 0 . 00 207 , 397 . 54 171 , 354 . 00 384 , 090 . 00 53 . 9 INTEREST 85-000-46-00- 4600 INVESTMENT INCOME 18 . 68 11489 . 31 30500 . 00 1 , 800 . 00 * 82 . 7 TOTAL INTEREST 18 . 68 1 , 489 . 31 3 , 500 . 00 1 , 800 . 00 82 . 7 TRANSFERS 85-000-49-00- 4905 TRANSFER FROM MFT FUND 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL TRANSFERS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL REVENUES : GENERAL 18 . 68 208 , 886 . 85 174 , 854 . 00 385 , 890 . 00 54 . 1 EXPENSES DEBT SERVICES 85-000- 66-00- 6021 FOX IND BOND-PRINCIPAL PMT 0 . 00 65 , 000 . 00 60 , 000 . 00 65 , 000 . 00 * 100 . 0 85-000- 66-00- 6022 FOX IND BOND- INT PAYMENT 0 . 00 15 , 555 . 00 20 , 555 . 00 15 , 555 . 00 * 100 . 0 --____ __ _ _ TOTAL DEBT SERVICES 0 . 00 80 , 555 . 00 80 , 555 . 00 80 , 555 . 00 100 . 0 CAPITAL OUTLAY BS -000-75-00-7901 FOX INDUSTRIAL - NON MFT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 85-000-75-00-7902 FOX INDUSTRIAL EXPENSES 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 TOTAL CAPITAL OUTLAY 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 OTHER 85-000-78-00- 9007 ADMINSITRATION FEES 0 . 00 252 . 00 375 . 00 375 . 00 67 . 2 85-000-78 -00- 9010 RESERVE-FUTURE BOND PYMTS 0 . 00 0 . 00 93 , 924 . 00 279 , 280 . 00 0 . 0 _________ _ TOTAL OTHER 0 . 00 252 . 00 94 , 299 . 00 279 , 655 . 00 0 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P64 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 65 TIME : 13 : 52 : 16 DETAILED REVENUE 5 EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : FOX INDUSTRIAL FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ___________________________ _ __ GENERAL TRANSFERS 85-000-99- 00- 9901 TRANSFERS 25 , 680 . 00 25 , 680 . 00 0 . 00 25 , 680 . 00 100 . 0 __________________ _ -________-_-_______-__ TOTAL TRANSFERS 25 , 680 . 00 25 , 680 . 00 0 . 00 25 , 680 . 00 100 . 0 TOTAL EXPENSES : GENERAL 25 , 680 . 00 106 , 487 . 00 174 , 654 . 00 385 , 890 . 00 27 . 5 TOTAL FUND REVENUES 18 . 68 208 , 686 . 85 174 , 854 . 00 385 , 890 . 00 54 . 1 TOTAL FUND EXPENSES 25 , 680 . 00 106 , 487 . 00 174 , 854 . 00 385 , 890 . 00 27 . 5 FUND SURPLUS ( DEFICIT) ( 25 , 661 . 32 ) 102 , 399 . 85 0 . 00 0 . 00 100 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P65 DATE : 04 /23 /2009 UNITED CITY OF YORKVILLE PAGE : 66 TIME : 13 : 52 : 16 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : POLICE PENSION FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL °s ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED -------------------------- -------------- GENERAL REVENUES INVESTMENT INCOME 86-000-46-00-4600 INTEREST INCOME 23 . 89 977 . 14 0 . 00 0 . 00 100 . 0 86-000- 46-00-4601 UNREALIZED GAIN/LOSS ON INVSTM 0 . 00 ( 487 , 923 . 66 ) 0 . 00 0 . 00 100 . 0 86-000- 46-00-4602 DIVIDEND INCOME 0 . 00 101 , 754 . 50 0 . 00 0 . 00 100 . 0 TOTAL INVESTMENT INCOME 23 . 89 ( 385 , 192 . 02 ) 0 . 00 0 . 00 100 . 0 OTHER OPERATING RECIEPTS 66-000-48- 00-4805 EMPLOYER CONTRIBUTIONS PROP TX 11 , 809 . 39 266 , 458 . 35 0 . 00 0 . 00 100 . 0 86-000-48 -00-4855 EMPLOYEE CONTRIBUTIONS 62 , 281 . 07 209 , 367 . 57 0 . 00 0 . 00 100 . 0 _-__ __ --------------- TOTAL OTHER OPERATING RECIEPTS 74 , 090 . 46 477 , 825 . 92 0 . 00 0 . 00 100 . 0 TOTAL REVENUES : GENERAL 74 , 114 . 35 92 , 633 . 90 0 . 00 0 . 00 100 . 0 EXPENSES PERSONNEL SERVICES 86-000-50-00-5108 SALARIES -POLICE PENSION 9 , 490 . 05 103 , 371 . 07 0 . 00 0 . 00 ( 100 . 0 ) 86-000-50-00- 5200 CONTRIBUTION REFUND 31688 . 57 6 , 176 . 56 0 . 00 0 . 00 ( 100 . 0 ) _-______ ______________________________ ______ ___- TOTAL PERSONNEL SERVICES 13 , 178 . 62 109 , 547 . 63 0 . 00 0 . 00 ( 100 . 0 ) CONTRACTUAL SERVICES 86-000-81-00- 8100 ADMINISTATIVE EXPENSES 319 . 40 4 , 900 . 77 0 . 00 0 . 00 ( 100 . 0 ) 86-000-81 -00- 8200 LEGAL EXPENSES 600 . 00 2 , 400 . 00 0 . 00 0 . 00 ( 100 . 0 ) 86-000-81-00-8300 INVESTMENT FEES/MANAGEMENT FEE 0 . 00 9 , 336 . 00 0 . 00 0 . 00 ( 100 . 0 ) TOTAL CONTRACTUAL SERVICES 919 . 40 16 , 6636 . 77 0 . 00 0 . 00 ( 100 . 0 ) TOTAL EXPENSES : GENERAL 14 , 098 . 02 126, 184 . 40 0 . 00 0 . 00 ( 100 . 0 ) TOTAL FUND REVENUES 74 , 114 . 35 92 , 633 . 90 0 . 00 0 . 00 100 . 0 TOTAL FUND EXPENSES 14 , 098 . 02 126 , 184 . 40 0 . 00 0 . 00 ( 100 . 0 ) FUND SURPLUS ( DEFICIT ) 60 , 016 . 33 ( 33 , 550 . 50 ) 0 . 00 0 . 00 100 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P66 DATE : 04 /23/2009 UNITED CITY OF YORKVILLE PAGE : 67 TIME : 13 : 52 : 16 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : COUNTRYSIDE TIF PROJECT FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ____________________________________ __ ___ ______________ GENERAL REVENUES TAXES 87 -000-40-00-3999 BEGINNING FUND BALANCE 0 . 00 0 . 00 2 , 856 , 390 . 00 21882 , 609 . 00 * 0 . 0 87 -000-40-00- 4090 TIF REVENUES 0 . 00 81455 . 00 0 . 00 8 , 442 . 00 * 100 . 1 -_ _ __ -__________ __ TOTAL TAXES 0 . 00 8 , 455 . 00 2 , 856 , 390 . 00 2 , 891 , 051 . 00 0 . 2 INTEREST 87 -000- 46-00- 4600 INVESTMENT INCOME 11115 . 42 36 , 633 . 00 75 , 000 . 00 40 , 000 . 00 * 91 . 5 TOTAL INTEREST 1 , 115 42 36, 633 . 00 75 , 000 . 00 40 , 000 . 00 91 . 5 TOTAL REVENUES : GENERAL 1 , 115 . 42 45 , 088 . 00 2 , 931 , 390 . 00 21931 , 051 . 00 1 . 5 EXPENSES OTHER FINANCING 87 -000- 66-00- 6002 COUNTRYSIDE TIF- INTEREST PMT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 87 -000- 66-00- 6022 BOND - INT PAYMENT 0 . 00 142 , 867 . 50 142 , 868 . 00 142 , 868 . 00 99 . 9 TOTAL OTHER FINANCING 0 . 00 142 , 867 . 50 142 , 868 . 00 142 , 866 . 00 99 . 9 OTHER 87-000-78- 00- 9007 ADMINISTRATION FEES 0 . 00 13 , 095 . 00 21500 . 00 14 , 315 . 00 * 91 . 4 87 -000-78 -00- 9009 RESERVE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 67 -000-76-00- 9010 RESERVE - FUTURE BOND PAYMENT 0 . 00 0 . 00 2 , 786 , 022 . 00 2 , 773 , 868 . 00 * 0 . 0 _ _______ ______________________ _ _ TOTAL OTHER 0 . 00 13 , 095 . 00 2 , 768 , 522 . 00 2 , 788 , 183 . 00 0 . 4 TOTAL EXPENSES : GENERAL 0 . 00 1551962 . 50 21 9311390 . 00 21931 , 051 . 00 5 . 3 TOTAL FUND REVENUES 1 , 115 . 42 45 , 088 . 00 21931 , 390 . 00 21931 , 051 . 00 1 . 5 TOTAL FUND EXPENSES 0 . 00 155 , 962 . 50 21931 , 390 . 00 21931 , 051 . 00 5 . 3 FUND SURPLUS ( DEFICIT ) 1 , 115 . 42 ( 110 , 874 . 50 ) 0 . 00 0 . 00 100 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P67 DATE : 04 /23/ 2009 UNITED CITY OF YORKVILLE PAGE : 68 TIME : 13 : 52 : 16 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : DOWNTOWN TIF FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED ___________ ___ _____ __________________ _ ______________________________________ GENERAL REVENUES TAXES 88 -000- 40- 00-3999 BEGINNING FUND BALANCE 0 . 00 0 . 00 28 , 693 . 00 28 , 372 . 00 * 0 . 0 88 -000-40-00- 4090 TIF REVENUES 0 . 00 71 , 587 . 91 28 , 000 . 00 65 , 119 . 00 * 109 . 9 __ ____ ____ TOTAL TAXES 0 . 00 71 , 587 . 91 561693 . 00 93 , 491 . 00 76 . 5 TRANSFERS IN 88 -000-49- 00-4901 TRANSFERS IN 0 . 00 3 , 551 . 47 0 . 00 0 . 00 100 . 0 TOTAL TRANSFERS IN 0 . 00 3 , 551 . 47 0 . 00 0 . 00 100 . 0 TOTAL REVENUES : GENERAL 0 . 00 75 , 139 . 38 56 , 693 . 00 93 , 491 . 00 80 . 3 EXPENSES CONTRACTUAL SERVICES 88 -000- 62- 00-5401 CONTRACTUAL SERVICES 0 . 00 31537 . 01 0 . 00 0 . 00 ( 100 . 0 ) __ _______________________________________ TOTAL CONTRACTUAL SERVICES 0 . 00 31537 . 01 0 . 00 0 . 00 ( 100 . 0 ) OTHER OPERATING EXPENSES 88-000-78-00-7101 IN TOWN ROAD PROGRAM 0 . 00 24 , 062 . 67 0 . 00 25 , 859 . 00 * 93 . 0 88-000-78-00- 9007 ADMINISTRATIVE FEES 0 . 00 495 . 00 10 , 000 . 00 45 . 00 * 1100 . 0 88-000-78- 00- 9010 RESERVE 0 . 00 0 . 00 46 , 693 . 00 41 , 782 . 00 * 0 . 0 TOTAL OTHER OPERATING EXPENSES 0 . 00 24 , 557 . 67 56 , 693 . 00 67 , 686 . 00 36 . 2 TRANSFERS 88 -000-99- 00- 9901 TRANSFER TO GENERAL FUND 25 , 805 . 00 25 , 805 . 00 0 . 00 25 , 805 . 00 * 100 . 0 TOTAL TRANSFERS 25r805 . 00 25 , 805 . 00 0 . 00 25 , 805 . 00 100 . 0 TOTAL EXPENSES : GENERAL 25 , 805 . 00 531899 . 68 56 , 693 . 00 93 , 491 . 00 57 . 6 TOTAL FUND REVENUES 0 . 00 75 , 139 . 38 56 , 693 . 00 93 , 491 . 00 80 . 3 TOTAL FUND EXPENSES 25 , 805 . 00 53 , 899 . 68 56 , 693 . 00 93 , 491 . 00 57 . 6 FUND SURPLUS ( DEFICIT ) ( 25 , 805 . 00 ) 21 , 239 . 70 0 . 00 0 . 00 100 . 0 * PLEASE SEE ADJUSTMENT TRANSFER REPORT FOR COMMENTS P68 DATE : 04 /23 /2009 UNITED CITY OF YORKVILLE PAGE : 69 TIME : 13 : 52 : 16 DETAILED REVENUE & EXPENSE REPORT F-YR : 09 ID : GL4B3000 . WOW FUND : TRUST & AGENCY FOR 11 PERIODS ENDING MARCH 31 , 2009 ORIGINAL REVISED FISCAL FISCAL ACCOUNT MARCH YEAR-TO-DATE YEAR YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET BUDGET EXPENDED _______________________ ____ _ __________ ___________ GENERAL REVENUES CHARGES FOR SERVICES 95-000-42-00-4214 DEV FEE-LIBRARY 2 , 250 . 00 531100 . 00 0 . 00 0 . 00 100 . 0 95-000-42- 00- 4215 SANITARY FEES COLLECTED ( 1 , 815 . 47 ) 21396 , 442 . 60 0 . 00 0 . 00 100 . 0 95-000-42- 00- 4216 DEV FEE-BKFD 5 , 050 . 00 75 , 409 . 00 0 . 00 0 . 00 100 . 0 95-000- 42 -00- 4217 DEV FEE-PARK & RED CAPITAL 250 . 00 5 , 750 . 00 0 . 00 0 . 00 100 . 0 95-000- 42 -00-4218 OSWEGO FIRE DISTRICT FEE 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 95-000-42- 00-4219 SSA PROPERTY TAX PAYMENTS 0 . 00 4 , 648 , 215 . 89 0 . 00 0 . 00 100 . 0 _________________ _ __ _ _ ________ TOTAL CHARGES FOR SERVICES 51734 . 53 7 , 178 , 917 . 49 0 . 00 0 . 00 100 . 0 MISCELLANEOUS 95-000-44-00-4499 BAD DEBT RECOVERY 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 _ _ _ _________________ TOTAL MISCELLANEOUS 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 CONTRIBUTIONS 95-000-47- 00-4729 LAND CASH - SCHOOL 6 , 903 . 04 146 , 344 . 44 0 . 00 0 . 00 100 . 0 _________ _ __ _ _- _______ TOTAL CONTRIBUTIONS 61903 . 04 146 , 344 . 44 0 . 00 0 . 00 100 . 0 TOTAL REVENUES : GENERAL 12 , 637 . 57 7 , 325 , 261 . 93 0 . 00 0 . 00 100 . 0 EXPENSES OTHER 95-000-78- 00- 9008 YBSD PAYMENTS 273 , 208 . 33 21191 , 777 . 68 0 . 00 0 . 00 ( 100 . 0 ) 95-000-78- 00- 9009 LIBRARY DEV FEE PAYMENTS 0 . 00 501850 . 00 0 . 00 0 . 00 ( 100 . 0 ) 95-000-78 - 00- 9010 EKED DEV FEE PAYMENTS 0 . 00 53 , 109 . 00 0 . 00 0 . 00 ( 100 . 0 ) 95-000-78 -00- 9011 SCHOOL LAND CASH PMTS 0 . 00 139, 441 . 34 0 . 00 0 . 00 ( 100 . 0 ) 95-000-78 -00- 9012 PARKS/REC CAPITAL PAYMENTS 0 . 00 5 , 500 . 00 0 . 00 0 . 00 ( 100 . 0 ) 95-000-78-00- 9013 SSA PAYMENTS TO TRUSTEES 0 . 00 41648 , 215 . 89 0 . 00 0 . 00 ( 100 . 0 ) 95-000-78- 00- 9099 BAD DEBT 0 . 00 0 . 00 0 . 00 0 . 00 0 . 0 _______________________________ __________ _ _-____ TOTAL OTHER 273 , 208 . 33 7 , 088 , 893 . 91 0 . 00 0 . 00 ( 100 . 0 ) TOTAL FUND REVENUES 12 , 637 . 57 71325 , 261 . 93 0 . 00 0 . 00 100 . 0 TOTAL FUND EXPENSES 273 , 208 . 33 7 , 088 , 893 . 91 0 . 00 0 . 00 ( 100 . 0 ) FUND SURPLUS ( DEFICIT ) ( 260 , 570 . 76 ) 236 , 368 . 02 0 . 00 0 . 00 100 . 0 P69 `,�O CII.J- Reviewed By: Agenda Item Number J2 �o Legal ❑ EST. 1936 Finance ❑ Engineer ❑ Tracking Number L City Administrator ❑ nn 9 WM `�O Consultant El Ab � ,� ad0q -33 <CE Agenda Item Summary Memo Title: Monthly Treasurer's Report for March 2009 Meeting and Date: Administration Committee—5/14/09 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Colleen Sullivan Finance Name Department Agenda Item Notes: United City of Yorkville Kendall County, IL Monthly Treasurer's Report Pre Audit Financial Summary As of March 31, 2009 FY FY Revised Revised Beginning March March Ending FYTD Budgeted FYTD Budgeted Fund Balance Revenues Expenses Balance Revenues Revenue Expenses Expenses 01 General 1,015,069 926,392 1,379,088 562,373 9,352,960 10,913,842 11,415,449 12,003,730 11 Fox Hill SSA (13,540) - 120 (13,660) 6,353 6,376 20,012 19,892 12 Sunflower SSA 2,071 - 122 1,949 15,939 15,925 13,990 15,925 15 Motor Fuel Tax 182,317 26,392 10,400 198,310 237,323 752,588 414,185 705,320 16 Municipal Building (547,074) 750 - (546,324) 12,750 (486,524) 44,550 59,400 20 PD Capital 204,072 3,025 7,021 200,076 43,806 229,796 40,994 229,796 21 PW Capital 195,359 3,500 6,858 192,001 90,300 612,295 405,594 520,000 22 Parks & Rec Equip Capital 25,752 - - 25,752 33,472 80,197 51,095 80,197 23 City Wide Capital (200,278) 2,500 - (197,778) 193,500 420,000 391,278 501,317 42 Debt Service (274,794) 125 - (274,669) 387,712 247,265 425,124 484,524 51 Water Ops. & Imprv. 14,430,298 28,020 108,826 14,349,492 1,993,988 2,763,275 2,419,481 2,763,275 52 Sewer 1,455,527 16,092 22,548 1,449,070 1,033,610 3,380,199 2,183,127 1,687,188 72 Land Cash (995,972) 2,619 169,000 (1,162,353) 127,972 852,584 747,832 847,823 79 Parks & Recreation 31,663 354,736 165,583 220,816 1,699,115 1,501,602 1,450,602 1,515,159 80 Recreation Center (74,577) 46,900 58,469 (86,146) 444,452 569,650 530,717 583,632 82 Library 994,808 2,375 88,642 908,541 1,225,565 2,268,746 1,201,733 2,268,746 85 Fox Industrial 311,289 19 25,680 285,627 208,887 385,890 106,487 385,890 87 Countryside TIF Project 21770,619 11115 - 2,771,734 45,088 2,931,051 155,963 2,931,051 88 Downtown TIF 75,417 - 25,805 49,612 75,139 93,491 53,900 93,491 95 Trust & Agency 496,939 12,638 273,208 236,368 7,325,262 - 7,088,894 - Totals 20,084,965 1,427,198 2,341,370 19,170,793 24,553,193 27538,248 29,161,005 27,696,356 Note: Revenue dent to be offset with food balance. 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. Full detail information is available in the Finance Department. William Powell, Treasurer Fund Balance Reserve Mar-09 Feb-09 Jan-09 Dec-08 Nov-08 Oct-08 Sep-08 Aug-08 General Fund 4.68% 8.96% 10.69% 15.37% 14.98% 20.18% 25.08% 19.08% Water D s. & Im rv. 98.04% 98.59% 98.22% -11.29% 1 -10.19% -8.35% -10.08% -9.94% Sewer O s. & ]m rv. 36.03% 1 36.19%11 35.13%11 122.53%1 1 134.78%1 134.79% 131.14% 131.05% Combined Fund Balance 53.4% 1 56.4%11 56.7%11 16.7%1 1 18.76%1 21.63% 22.14% 19.90% Prepared by: Colleen Sullivan