Loading...
Administration Packet 2006 04-06-06 r c 'ED CST 0 United City of Yorkville 800 Game Farm Road EST. 1836 Yorkville, Illinois 60560 Telephone: 630-553-4350 .�o Fax: 630-553-7575 E AGENDA ADMINISTRATION COMMITTEE MEETING Thursday,April 6,2006 6:30 P.M. CITY CONFERENCE ROOM Presentation: None Old Business: 1. Minutes for Approval/Correction: March 2, 2006 2. ADM 2006-12 Minute Taking Policy 3. ADM 2006-13 Hiring Policy 4. PW 2006-39 Project Manager—Proposed Position and Draft Job Description New Business: 1. Monthly Budget Report for February 2006 2. ADM 2006-26 Monthly Treasurer's Report for February 2006 3. ADM 2006-27 Quarterly Department Vehicle Reports 4. ADM 2006-28 Hoover Boy Scout Camp—Update on Process 5. ADM 2006-29 Bailey Meadows SSA 2006-110 Proposing Ordinance 6. ADM 2006-30 Administrative Assistant Job Description 7. ADM 2006-31 Comprehensive Salary Survey Additional Business: Executive Session: 1. For the appointment, employment, compensation, discipline, performance, or dismissal of specific employees of the public body or legal counsel for the public body, including hearing testimony on a complaint lodged against an employee of the public body or against legal counsel for the public body to determine its validity. Page 1 of 7 RAFT UNITED CITY OF YORKVILLE ADMINISTRATION COMMITTEE MEETING THURSDAY,MARCH 2,2006 6:30 PM City Hall Conference Room CITY OFFICIALS IN ATTENDANCE: Mayor Art Prochaska (6:55pm-8:05pm) Police Chief Harold Martin Alderman Paul James Finance Director Traci Pleckham Alderwoman Rose Spears City Treasurer Bill Powell Alderwoman Valerie Burd Payroll &Benefits Specialist Alderman Jim Bock Denise Kasper Interim City Administrator John Crois City Intern/Deputy Clerk Bart Olson GUESTS: Alderman Joe Besco Joe Roberts, Caywood&Associates Alderman Marty Munns The meeting was called to order at 6:30pm by Alderman Paul James. PRESENTATION: None OLD BUSINESS: 1. Minutes for ApprovaUCorrection:January S, 2006 and February 2, 2006 The minutes were approved except for a misspelling of Traci Pleckham's name in the January minutes. 2. ADM 2006-11 Health InsurancelBenefct Renewal Information The City had asked for alternative providers and rates for the health insurance last fall. In Illinois there are 47 companies in Illinois that provide health insurance,however, only five carriers were eligible for the City. The City sent out for bids and received declines from all of those companies for the following reasons: 1. 3 of 5 do not have adequate HMO networks in Kendall County 2. United Healthcare declined the City due to retirees on the plan 3. City had a loss rate of 144%2 years ago and a 131% in the last year(claims exceeded premiums) Page 2 of 7 Mr. Roberts negotiated with Blue Cross/Blue Shield and was able to secure a 4.6% reduction of rates. He also credited Ms. Pleckham and Ms. Kasper for the decrease. Ms. Pleckham handed out a schedule of current costs and she recommended moving forward with Blue Cross/Blue Shield because of the rates and lack of other providers. The lowered rates were due, in part,to an increased use of HMO's rather than PPO's. Also, Caywood is the largest benefit administrator in Kendall County and therefore was able to negotiate benefits. For comparison, it was noted that Batavia's rates increased 20% and Oswego anticipates an increase of 10-13% on HMO and 6-9% on PPO. A decision must now be made whether to retain BCBS as the City carrier and if a co-pay will be required. Mr. Munns asked if an employee co-pay would affect the premium and Mr. Roberts said a co-pay would not significantly change the premium. He added that if the City pays 100% of the current premium, 100% of the eligible employees must belong to the plan. If the City pays anything less than 100% of the premium, 75% of the eligible employees must belong to the plan. This is per State law. Ms. Pleckham suggested offering a wellness incentive for employees to not be on the plan. Proof of insurance from another company would be required this would ultimately save the City money. Some employees currently have double coverage and it was noted that some providers penalize individuals for double coverage. Ms. Kasper said, however, spouses or others are not required to divulge whether or not they carry insurance. It was noted that Montgomery, Plainfield and Oswego do not charge a premium for their HMO plans, but Oswego does charge 5%for their PPO plan. Other municipalities do charge. A suggestion was made to not charge a premium for an"employee only", however,those with family coverage would incur a premium. Alderman Munns noted that charging a co-pay was one of the points made at the goal-setting meeting. Alderman James said the committee should move forward with the Mayl st renewal date with the $36,390.96 savings. A decision must be reached on the question of the premium in relationship to negotiating groups. It was decided that an"employee only" should still contribute $1 while a premium should be charged for spouse or family coverage. Mr. Munns suggested that the cost savings should be calculated from that scenario and adjustments could be made. A review will be done of the costs using information from other towns and internal calculations using various co-pays. This will be moved to C.O.W. 3. ADM 2006-12 Minute Taking Policy Bart Olson included a memo in the packets that stated the City Clerk tracks the turnaround time of the minutes. For the most part,minutes have been on time, with the exception that minutes might beheld up awaiting minutes from Depo Court where public hearings are concerned. Ms. Spears asked that minutes be available a week in advance-- Page 3 of 7 separate from the rest of the agenda packet. This would allow time for the Council members to review them if they had other meetings to attend during the week. The Mayor suggested the minutes could be distributed on Friday prior to the meeting,when other packets are also going out. Mr. Olson will speak with the City Clerk about this possibility and this matter will be brought back to the April meeting. 4. ADM 2006-13 Hiring Policy A previous memo on hiring was referenced,however, Mr. Crois said he will draft a policy based on the discussion at this meeting and forward it to Attorney Wyeth for review. The Community Relations Director, Parks&Rec. Director, City Administrator and Chief of Police are directly responsible to the City Council. He felt a consulting firm should be used in the selection of all those positions except for the Community Relations person. He was unable to find information on the method of appointment of the Librarian. To select other personnel, department heads, etc. Mr. Crois suggested using the H.R. department and also involving a person who has expertise in the particular position being hired. The resumes would then be brought to the appropriate committee for review and they would make a recommendation to the Mayor. Ms. Burd made reference to the previous month's meeting minutes that stated a search firm and RFP's should be used for the City Administrator and Department Heads and that a policy would be drafted for this month's meeting. However, Mr. Crois said he felt that the $10-15,000 for a search firm could be better used in the City. He said that those positions that report to the Council and/or Mayor should be selected by a search firm. Alderman James summarized the discussion saying the following issues were at hand: 1. A decision should be made regarding the personnel for whom a search firm would be used. 2. How will the Finance Director position be handled? 3. A policy is needed for H.R. to follow when hiring employees Ms. Burd also asked if a future City Attorney would be hired under the hiring policy or if it would be a mayoral appointment. The Mayor said that this position is not currently in the budget. He added that it is not a policy that City Council members should be used in the interview process for employees. Since the City now has an H.R. department,hiring decisions can be made by that department. Chairman James asked Denise Kasper to draft a policy covering hiring practices for all employees by next month. He said that the hiring for Ms. Pleckham's position should be resolved at this meeting. She suggested that John Weber, department heads and City Administrator should be involved. The Mayor said he traditionally has asked a particular committee to be part of the interview process. Ms. Burd suggested that after Page 4of7 the Mayor suggests an appointment,there should be a policy that the Council should have an opportunity to meet and talk with that person. She did not feel comfortable voting on someone she had not met. It was decided that a search firm would not be used for Ms. Pleckham's position, but one alderman from each ward would be part of the interview group. If there is less than one alderman from each ward on the interview board, then the entire Council would sit it on the interview. It was recommended that Kevin McCanna also be included in the interviews. The resumes are being accepted through March 8th Mr. Crois and Ms. Kasper will draft the hiring policy and this item will be brought back to committee next month. NEW BUSINESS: 1. Monthly Budget Report for January 2006 The budget is at 75% of the fiscal year and 64.16% of the general fund. The total general fund expenses are at 45.83% of the budget. (next item taken out of order) 6. ADM-2006-23 Attorney Hours Spreadsheet and Draft Job Description Mayor Prochaska complimented Intern Olson in the compilation of information for this spreadsheet. It was noted that 2,000 hours (to warrant a full time position)were not completed this year. That is due, in part, because the attorney is in-house part of the time eliminating many phone calls. Attorney Wyeth said he worked more hours than actually reflected and that e-mails and phone calls also contribute to that extra time. He was asked to track those hours also. Mr. Wyeth categorized his billable hours according to department. He said he allowed a year to learn and a year to implement. He said the staff could actually do many routine things once they are taught and as a result, he sees the billable time actually decreasing. Ms. Burd suggested a paralegal might be beneficial, however, Mr. Wyeth felt it was not necessary at this time. Another suggestion was to have a secretary/clerk in place to assist with some of the legal work. He did not feel that was needed and that it was too early to tell if a full-time attorney was warranted, however, his opinion was that a full time one is not needed. Chief Martin complimented the job that Mr. Wyeth has done since matters can be completed in a more timely manner. The Mayor said the workload had actually been decreased with Mr. Wyeth in the office. Another suggestion was to have Attorney Wyeth review the job descriptions rather than sending them to the labor attorney. Other considerations for him might be union concerns or whether a position is exempt or non-exempt. Page 5 of 7 In conclusion,the job description for a full-time attorney will be postponed and brought back in one year for discussion. (following item taken out of order) 8. ADM 2006-25 Amendments to City Code Regarding Appointments and Offices When appointments were being made last May, Attorney Wyeth reviewed the City Code and found that some appointments were inconsistent with State Statute and were located in various parts of the Code. The revisions he made were as follows: 1. He incorporated all the appointments into one area 2. Determined that appointments will be made at the time the Mayor is elected 3. Made minor revisions to some of the language 4. Established"Departments" in a new section of the Code. He said these should be considered and acted upon before May when re-appointments would be made. Mayor Prochaska suggested that an IT and H.R. department should be added to the list of revisions presented by Mr. Wyeth. There was a brief discussion as to whether all department heads should be under a re-appointment structure. Mr. Wyeth said, at minimum, the statutory appointments are necessary and the Council recommended that the City Administrator be included as well. This item will move to C.O.W. with the list as it was shown on the agenda document and with 4-year appointments. 2. ADM 2006-21 Monthly Treasurer's Report for January 2006 Treasurer Powell reported the following: 1. Beginning balance: $30,537.194.01 2. Revenues: $1,940.917.85 3. Expenses: $3,126.957.73 4. Ending Balance: $29,351,154.13 5. Combined Fund Balance Reserve: at 38.25% This item moves to the consent agenda at C.O.W. 3. ADM 2006-22 Resolution Appointing IMRFAuthorized Agent Ms. Pleckham said IMRF does not allow any other signature except the authorized one even if that person has left. She recommended that Denise Kasper be the authorized signator. Alderman Bock also noted a misspelling in his name on the resolution. This moves to the consent agenda of C.O.W. 4. PS 2006-05 Maintenance Proposal for Fire Alarm System at City HaIL Police Station Chief Martin reported that currently there is no maintenance on the alarm system and it should be checked twice yearly. The expense would be taken from Municipal Building or Contractual Services. The amount was corrected to $600,rather than$690. This moves to C.O.W. Page 6 of 7 S. PW 2006-39 Project Manager—Proposed Position and Draft Job Description Ms. Spears said she felt this job description was almost identical to the Engineering Administrative Assistant. She said this was an administrative-type position and a project manager should be a degreed position. This position was requested by Mr. Wywrot. Mr. Crois will review this with Mr. Wywrot, but it was thought this was to be an assistant to the City Engineer to relieve some of his workload. It was decided the job description needed improvement and will come back next month after Mr. Crois speaks with the engineer. 7. ADM 2006-24 Salary Increases for the Next Fiscal Year (ColwMerit) Alderman James explained that last year the Administration Committee had broken this item down to COLA and merit. In 2005,the committee chose a 4% all-merit increase with zero COLA, however, not all employees received that percentage. The average increase was 3.5 to 3.75%. He explained that employees were given 0% for COLA due to the large increase in medical insurance costs and due to the economy. The City absorbed the insurance cost. Ms. Pleckham noted that the cost of living for this area this year is 3.6%. A decision was reached to award 2% COLA and 2.5%merit. Ms. Pleckham will bring back a report of costs and savings using various percentages. Mr. Crois said a sliding scale of insurance premiums should also be considered depending on what a given employees earns. The "employee only" will still be asked to contribute $1.00 towards his/her premium. Ms. Kasper said that the City employees currently are split 50150 between HMO and PPO. This will come back to C.O.W. with a recommendation for COLA and merit and a cost analysis will also be done. ADDITIONAL BUSINESS: Treasurer Powell said the City is looking for ways to increase revenue and he presented a spreadsheet that showed Money Market rates vs. CD rates. He also looked at the Library funds,the payout schedule and the money needed. He was able to receive increased interest of$5500 from CD's. He also converted three money market accounts to standard checking accounts and will receive an additional $10415,000 interest. In addition, Mr. Powell said that property taxes are only 8% of the total revenues at this time. This is partly due to the road funding being high. As the road funding decreases, the percentage of property taxes will increase. A recommendation was made to have the aldermen paid quarterly rather than twice a year. Attorney Wyeth will be consulted since the payment frequency is currently spelled out in a policy. This item will be brought back next month. Page 7of7 Alderman James asked when the next payment is due for the Boy Scout Camp property and Cor-Lands. He requested this be brought back for discussion next month prior to Ms. Pleckham's upcoming departure. Alderwoman Spears inquired about the line item for the "Polka Party' for the Park District so that she could take the information to Human Resources on March 15. Ms. Pleckham said she had some information, but had not been able to meet with Sue Swithin yet. The meeting adjourned at 8:40pm. Respectfully submitted by Marlys Young, Minute Taker 0 e, q�'5 cir o United City of Yorkville '�)Cac- �3 J .n County Seat of Kendall County 800 Game Farm Road ES' 1$36 Yorkville, Illinois, 60560 Telephone: 630-553-4350 0 Fax: 630-553-7575 �2 Website: www.yorkville.il.us <LE �Vy Date: April 4,2006 To: Administration Committee From: John H. Crois,Interim City Administrator Subject: Hiring Process Attached is a copy of the memo of February 28, 2006 relating to this subject. Also attached is a memo with a suggested hiring policy. This memo has not been reviewed by legal counsel. ►,.o United City of Yorkville J .0 County Seat of Kendall County 800 Game Farm Road EST. 1$36 Yorkville, Illinois, 60560 Telephone: 630-553-4350 �. Fax: 630-553-7575 Website: www.yorkville.il.us <LE Date: February 28,2006 To: Administration Committee Members From: John H. Crois,Interim City Administrator Subject: Hiring Procedures In hiring the goal of the City should be to attract a pool of qualified applicants,and to hire the best qualified applicant who meets the City's qualifications and needs. When hiring for positions which report to the Mayor and Council and/or another Board,the Council should consider using a recruitment firm. The City Administrator's position is one of the City's highest level position and reports directly to the Mayor and Council. Therefore I feel that the recruitment process should be coordinated by someone not on the City staff. There are several recruitment firms which specialize in this type of recruitment. They would be best qualified to guide the Mayor and Board through the recruitment process. The other positions reporting to the Mayor and Council are the Police Chief, Executive Director of parks and recreation, and the Community Relations Director. Of the three the Community relations Director could probably be recruited by an in-house process. There are recruitment firms which specialize in Police Chiefs and Executive Directors of Park and Recreation. Again it would seem that an outside firm would be best to coordinate the recruitment process. In terms of the budget officer, city engineer,public works director,and community development director, I feel the most important factor is to verify their knowledge and expertise. This can be accomplished by utilizing professionals in the discipline being recruited. The resumes can be received by the HR Department and reviewed by the City Administrator, HR, and a professional in the field being recruited. Then the top ten resumes can be presented to the appropriate committee for review and selection of candidates to be interviewed. The interviews would be conducted by the committee with assistance and input from the City Administrator and area of expertise professionals. The finalist or top candidates would then be submitted to the Mayor for his consideration and appointment. This is an overview of my suggestion of how the hiring process should be handled. I will be at the Administrative Committee meeting to answer any questions you may have. With your assistance and ideas a final policy can be formulated. Hiring Process It is the goal of the United City of Yorkville to recruit and hire the best qualified candidate who meets the City's qualifications and needs. These individuals will be hired based on qualifications only with no consideration given to race, creed,religion,political affiliation, or national origin. 1. CITY ADMINISTRATOR,POLICE CHIEF,DIRECTOR OF PARKS AND RECREATION. These positions shall be filled using a recruitment firm. The process will be as follows: A. City Council selects a recruitment firm. B. Recruitment firm advertises and collects resumes. C. Recruitment firm meets with Council, Park Board, or appropriate Committee to select candidates for interviews. D. Interviews are held and a recommendation is made to the Mayor. E. Mayor conducts interviews and makes selection. F. Appointment made for Council's consent and job offer is made. 2. FINANCE DIRECTOR, CITY ENGINEER,PUBLIC WORKS DIRECTOR, COMMUNITY DEVELOPMENT DIRECTOR,AND COMMUNITY RELATIONS DIRECTOR. A. HR Department advertises position and collects resumes. B. Resumes are reviewed by the City Administrator and HR Department. C. Resumes are presented to appropriate committee with recommendations. D. Applicants to be interviewed are selected. E. Interviews are held by committee with assistance and advice from outside professional or professionals. F. Committee recommendation made to Mayor. G. Mayor holds interviews and makes selection. H. Mayor presents candidate to Council for consent. I. Job offer is made. `,QED C/ry Reviewed By: J= p, Legal 13 City Council Finance ❑ EST. .:"�';• �:.. : 1631 Engineer pL] �-' 2�Zt°6 Agenda Item Tracking Number City Administrator ❑ �� j � J .p �O Consultant ❑ l� ❑ City Council Agenda Item Summary 1'vTiemo Title: Project Manager—Proposed Position&Job Description City Council/COW/Committee Agenda Date: PW Committee 2/6/06 Abu, WO(o Ar�Aoj Synopsis: This proposal is to create anew job position within the Engineering Department called Project Manager. The position is proposed to be filled next fiscal year. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Majority Council Action Requested: Approval Submitted by: Joe Wywrot Engineering Name Department Agenda Item Notes: C/J.`4% EF`, Comparison between •� Project Manager and En g. Adm. Asst. <tE ��?' Project Manner Engineering Adm. Asst. Position Description Overview: Position Description Overview: This individual will be responsible for tracking This individual will be responsible for invoicing and bonds/letters of credit for development activities, maintaining project developer accounts for Attorney, processing reductions to bonds and letters of credits, Land Planner, contracted engineering firms, and all performing site plan reviews, reviewing record other outside contracted firms' fees with monthly drawings, coordinating punchlist inspections, and summary reports to Finance Director and City ensuring compliance with state-mandated Administrator. This position also consists of project requirements such as NPDES permits, highway and phase tracking, assigning commercial and permits, EPA permits, etc. This individual will also residential addresses miscellaneous Auto Cad work with Engineering Technicians on city-funded mapping,preparation of IDOT Bid Tabulation forms, projects with respect to resident notifications, and residential &commercial punch list and final resolution of resident concerns, and processing of inspections processing. change orders and payouts. Work with Engineering Technicians to track testing of infrastructure improvements. This position also provides support for the Geographic Information System, and AutoCAD work as required. All work is performed under the general supervision of the City Engineer. Essential Job Functions: Essential Job Functions: 1. Maintain bond/letter of credit summary 1. Create Project Development Administration and information. Deposit Account ledgers; update and maintain accurately. 2. Process bond/letter of credit reductions. Take reduction from developer request, through City 2. Generate Project Development invoices for Council approval,to developer notification or Attorney and Land Planner's fees, Public Works, City Council action. as well as contracted Engineering Firms, Building Department and all other outside firms' 3. Perform minor site plan reviews as assigned by fees subject to City reimbursement. the City Engineer. 3. Establish monthly summary worksheets of fees 4. Review record drawings for accuracy, collected past due accounts, developer account thoroughness, and legibility. balances, and project phase tracking. Submit monthly to Finance Director and City 5. Assign and coordinate punchlist inspections and Administrator for Mayoral/Council review. re-inspections by field personnel. Prepare punchlist letters and work with developers to 4. Import updates to the city Subdivision Control complete required work. Ordinance and Standard Specifications for Improvements. Maintain familiarity with 6. Create/update general AutoCAD files as Ordinance to assist builders and outside required. engineering firms with compliance-related design issues and situations. 7. Work with Community Relations Director regarding resident notification of 5. Assign addresses for residential and commercial City-funded projects, as well as projects by Developments in accordance with City Grid private developers that affect neighboring Map; distribute notification with maps to properties. pertinent staff and agencies. Occasional on-site inspection as necessary to complete. 8. Respond to requests/requirements of other governmental agencies regarding permits. 6. Print Auto Cad maps for front desk sales, design address maps, execute Metes and Bounds 9. Process payouts and change orders through descriptions, location areas, and other functions appropriate channels. as requested by Engineer. 10. Coordinate/track public infrastructure testing 7. Prepare IDOT Bid Tabulation forms, City with engineering technicians. project bid packets, bid holder lists, and attend and record vital statistics at City bid openings. 11. Perform site inspections to ensure compliance Substitute for City Engineer opening and with site development permit requirements. reading bids as necessary. 12. Respond to resident concerns regarding city and 15. Complete departmental purchasing; log developer projects. expenditures and track expenses to ensure departmental budgets are not exceeded. 13. Coordinate Engineering Department support for the city's Geographic Information System. 16. Review subdivision and development plan submittals with regards to streets layout and 14. Various other duties and responsibilities as spelling, as they relate to addressing. Track and directed by the Engineer. ensure approved historical street name use by development. 17. Track development IL EPA water and sanitary permits and applications; work with Public Works Water Operators acquiring chlorination lab reports and mapping test points. Process IL EPA Operating Permit & Permit Partials requests. 18. Perform preliminary in-house review of builder's final site grading plan submittals to verify the approved engineering .grading plans have been matched. Request revisions and/or additional spot elevation grades as necessary; compile inspection packet for engineering technician to perform onsite field inspections. 19. Process field inspection paperwork, request builder escrow funds for completion of public/site improvements for final inspection of lot/home completion, coordinate temporary occupancy certificate release and expiration date, track completion of public/site improvements, and close lot file for release of builder escrow funds and final occupancy certificate release. 20. Serve as liaison with county mapping department, neighboring communities, and Sidwell Company for identification of City parcels, tax identification numbers, website design properties, property lines, and parcel ownership. 21. Various other duties and responsibilities as directed by the Engineer. 22. Answer telephones and greet customers. Position Requirements—Knowledge, Skills, and Position Requirements—Knowledge, Skills, and Abilities: Abilities: 1. Demonstrate a broad-based knowledge of 1. Demonstrate a broad-based knowledge of Microsoft Excel and Microsoft Word programs. Microsoft Excel and Microsoft Word programs. Demonstrate knowledge of AutoCAD software Demonstrate basic knowledge of AutoCAD sufficient to create customized drawings for software sufficient to print documents and create general civil engineering and mapping simple line drawings. applications. 2. Ability to operate a variety of office equipment, 2. Ability to operate a variety of office equipment, including but not limited to computer, including but not limited to computer, typewriter, copier, fax, scanner, large-scale typewriter, copier, fax, scanner, large-scale plotter, and calculator, with minimal supervision. plotter, and calculator, with minimal supervision. 3. Display professionalism and maintain strict 3. Display professionalism and maintain strict confidentiality. confidentiality. 4. Exhibit mathematical and analytical qualities. 4. Exhibit mathematical and analytical qualities. 5. Possess proficient customer service skills. 5. Possess proficient customer service skills. 6. Excellent communication and writing skills. 6. Excellent communication and writing skills. 7. Highly organized and able to prioritize job 7. Highly organized and able to prioritize job assignments. assignments. Requirements: Requirements: 1. 64 college course credit hours with special 1. Any approved equivalent combination of emphasis on Engineering/Technical Fields, Data experience and education that provides the Management; Two or more years of required knowledge, skills, and abilities to progressively responsible experience within a perform job duties as stated. municipal engineering department; or, an equivalent combination of education and 2. Willingness to attend training classes to increase experience sufficient to perform the essential knowledge of job-related skills and duties of the job as those listed above. responsibilities. 2. Willingness to attend training classes to increase 3. 64 college course credit hours with special knowledge of job-related skills and emphasis on Engineering/Technical Fields,Data responsibilities. Management. 3. Possession of valid Illinois Driver's License. 4. Possession of valid Illinois Driver's License and Insurance. 5. Must successfully complete a background investigation. C/,;P.o United City of Yorkville Memo J ®j '" 800 Game Farm Road EST , t4''-®:1636 Yorkville, Illinois 60560 y Telephone: 630-553-8545 Q ' Fax: 630-553-3436 <L E Date: February 2, 2006 To: John Crois, Interim City Adm strator From: Joe Wywrot, City Engineer v CC: Denise Kasper, Payroll Benefi Speci ist Liz D'Anna,Administrative Assistant Subject: Project Manager—Proposed Position&Job Description Attached find a draft copy of a job description for a new position that I would like to create for the Engineering Department. The job position would be called Project Manager. This person would perform some of the more routine tasks that I currently perform. This will enable me to perform plan reviews in a more timely manner, continue to prepare plans and specifications for city-funded projects, and in general perform my job at a higher level. Project Manager is a responsible position that would process payouts, change orders, letter of credit reductions,prepare punchlists,be involved in testing of new infrastructure, ensuring compliance with Site Development Permits, and perform a limited amount of minor site plan review. This position performs engineering-related tasks,but would not require an engineering degree. The salary range would be the same as for Senior Engineering Technician. The amount of development occurring in Yorkville is staggering. This position will help us keep up with the pace of development without sacrificing the quality of our work. I recommend that one Project Manager job position be approved for the upcoming fiscal year, with the intent of filling the position by May 1, 2006. Please place this item on the Public Works Committee agenda for consideration. C/;, t o UNTIED CITY OF YORKVILLE PROJECT MANAGER—JOB DESCRIPTION (Draft 2-2-2006) Department: Engineering Reports to: City Engineer Status: Full Time,Non-exempt Pay Classification: Project Manager(range same as Senior Engineering Technician) Position Description Overview This individual will be responsible for tracking bonds/letters of credit for development activities, processing reductions to bonds and letters of credits, performing site plan reviews, reviewing record drawings, coordinating punchlist inspections, and ensuring compliance with state- mandated requirements such as NPDES permits, highway permits, EPA permits, etc. This individual will also work with Engineering Technicians on city-funded projects with respect to resident notifications, resolution of resident concerns, and processing of change orders and payouts. Work with Engineering Technicians to track testing of infrastructure improvements. This position also provides support for the Geographic Information System, and AutoCAD work as required. All work is performed under the general supervision of the City Engineer. Essential Job Functions 1. Maintain bond/letter of credit summary information. 2. Process bond/letter of credit reductions. Take reduction from developer request, through City Council approval,to developer notification or City Council action. 3. Perform minor site plan reviews as assigned by the City Engineer. 4. Review record drawings for accuracy,thoroughness, and legibility. 5. Assign and coordinate punchlist inspections and re-inspections by field personnel. Prepare punchlist letters and work with developers to complete required work. 6. Create/update general AutoCAD files as required. 7. Work with Community Relations Director regarding resident notification of City-funded projects, as well as projects by private developers that affect neighboring properties. 8. Respond to requests/requirements of other governmental agencies regarding permits. 9. Process payouts and change orders through appropriate channels. 10. Coordinate/track public infrastructure testing with engineering technicians. 11. Perform site inspections to ensure compliance with site development permit requirements. 12. Respond to resident concerns regarding city and developer projects. 13. Coordinate Engineering Department support for the city's Geographic Information System. 14. Various other duties and responsibilities as directed by the Engineer. Position Requirements—Knowledge, Skills, and Abilities 1. Demonstrate a broad-based knowledge of Microsoft Excel and Microsoft Word programs. Demonstrate knowledge of AutoCAD software sufficient to create customized drawings for general civil engineering and mapping applications. 2. Ability to operate a variety of office equipment, including but not limited to computer, typewriter, copier, fax, scanner, large-scale plotter, and calculator, with minimal supervision. 3. Display professionalism and maintain strict confidentiality. 4. Exhibit mathematical and analytical qualities. 5. Possess proficient customer service skills. 6. Excellent communication and writing skills. 7. Highly organized and able to prioritize job assignments. Minimum and Preferred Experience and Education 1. 64 college course credit hours with special emphasis on Engineering/Technical Fields, Data Management; Two or more years of progressively responsible experience within a municipal engineering department; or, an equivalent combination of education and experience sufficient to perform the essential duties of the job as those listed above. 2. Willingness to attend training classes to increase knowledge of job-related skills and responsibilities. 3. Possession of valid Illinois Driver's License. The duties listed above are intended only as an illustration of the various types of tasks that may be required. The omission of specific statements of duties does not exclude them from the position if the work is similar,related, or a logical assignment to the position. This job description does not constitute an employment agreement between the employer and employee, and is subject to modification by the employer as the needs of the employer and/or agency change, or requirements of the position change. UNITED CITY OF YORKVILLE BUDGET 2005-2006 GENERAL FUND SUMMARY PERIOD ENDING FEBRUARY 28, 2006 83.3% OF FISCAL YEAR 2005-2006 REVENUE/EXPENSE REVISED PERCENT VS. THRU FEBRUARY 28, 2006 BUDGET BUDGET AMOUNT s, WFUND R GENERAL FUND EXPENSES FINANCE & ADMINISTRATION 3,935,238 5,076,588 77.52% ENGINEERING 316,806 440,342 71.95% POLICE 1,748,697 2,224,534 78.61% PLANNING & DEVELOPMENT 146,582 259,250 56.54% STREETS 2,600,730 6,609,602 39.95% HEALTH & SANITATION 439,680 530,000 82.96% fi`�'4 LOU A00 02 -34" B4 TOTAL PN L UNITED CITY OF YORKVILLE FEBRUARY 2006 BUDGET 83.3% FISCAL YTD FISCAL YEAR- PAGE TO-DATE FISCAL YEAR %COLLECTED/ FUND # ACCOUNT NUMBER DESCRIPTION ACTUAL BUDGET EXPENDED COMMENTS GENERAL 1 01-000-40-00-3996 ROAD CONTRIBUTION FEE $ 899,098.00 $ 950,000.00 94.64% BRISTOL BAY PERMIT FEES COLLECTED GENERAL 1 01-000-42-00-4211 ENGINEERING CAPITAL FEE $ 40,700.00 $ 40,000.00 101.75% BRISTOL BAY PERMIT FEES COLLECTED 30 REIMBURSEMENT FROM GENERAL 2 01-000-44-00-4490 MISCELLANEOUS INCOME $ 10,152.41 $ 10,000.00 101.52% INDUSTRIAL FUND ADMIN 3 01-110-61-00-5300 LEGAL SERVICES $ 47,541.27 $ 55,000.00 86.44% 7,800.00 LABOR ATTORNEY ADMIN 3 01-110-62-00-5400 INSURANCE-LIABILITY&PROPERTY $ 121,210.58 $ 121,211.00 100.00% ONE TIME LUMP SUM PAYMENT ADMIN r 3 =i 01,110 62,00.5403: SPI;CIQL CFINSUS .$ „ °6'/;017.93 $` ' '=66;000.00 101:54%'=' SPECIAL ENSUS NEAR COMPLETIONH ADMIN 4 01-110-64-00-5605 TRAVEL/MEALS/LODGING $ 13,720.32 $ 17,000.00 80.71% DUE TO IML CONFERENCE HALLOWEEN MA CITY ADMIN 4 01-110-64-00-5607 PUBLIC RELATIONS $ 14,051.97 $ 30,000.00 46.84% MAGNETS,WATER SHED PROGRAM ADMIN 5 01-110-75-00-7002 COMPUTER EQUIP&SOFTWARE $ 10,885.71 $ 18,500.00 58.84% PAYMENT FOR HR MODULE&PROJECTOR ENGINEERING 6 01-150-62-00-5401 CONTRACTUAL SERVICES $ 62,265.23 $ 65,000.00 95.79% BROWNFIELD EXPENSE 21,000 ENGINEERING 6 01-150-64-00-5605 TRAVEL EXPENSES $ 956.40 $ 1,000.00 95.64% ONE TIME CONFERENCE TRAVEL EXPENSES r9ANflrrFA=D ACCIDENT&TRAN I POLICE 7 01-210-62-00-5409 MAINTENANCE-VEHICLES $ 22,584.61 $ 24,000.00 94.10% WORK DUE TO INCREASED S -WILL BE REVISED POLICE 8 01-210-62-00-5441 MTD-ALERTS FEE $ 4,620.00 $ 4,620.00 100.00% ON BUDGET POLICE 8 01-210-64-00-5605 TRAVEL EXPENSES $ 7,767.25 $ 10,500.00 73.97% POLICE 9 01-210-72-00-6502 POLICE PENSION $ 231,123.76 $ 231,686.00 99.76% PAYOUTS BASED ON PROPERTY TAX REVENUE POLICE 9 01-210-78-00-9004 BIKE PATROL $ 1,422.51 $ 2,000.00 71.13% SEASONAL EXPENSE PLANNING& LEGAL SERVICES RELATING TO BOUNDARY DEVELOPMENT 9 01-220-61-00-5300 LEGAL SERVICES $ 39,799.70 $ 38,000.00 104.74% MATTERS PLANNING& RECEIVED$8,112.50 FOR COMPREHENSIVE DEVELOPMENT 9 01-220-62-00-5430 PLANNING CONSULTANT $ 6,677.92 $ 20,000.00 33.39% PLAN AMENDMENT(NORTHWEST LAND AREA) STREETS 12 01-410-75-00-7100 STREET REHAB PROJECTS $ 35,646.99 $ 40,000.00 89.12% PROJECTS DONE/NEAR COMPLETION YORKVILLE MOOSE DONATION F RP E PD CAPITAL 18 20-000-44-00-4404 DONATIONS $ 1,500.00 $ 1,500.00 100.00% VESTS PD CAPITAL 18 20-000-44-00-4489 RICP DISASTER PLAN GRANT $ 9,990.27 $ 9,990.00 100.00% POLICE CAPITAL GRANT PD CAPITAL 18 20-000-44-00-4490 MISCELLANEOUS INCOME $ 24,609.27 $ 24,600.00 100.00% RECEIVED 1998 GRANT DOLLARS $1000 FOR PLAYGROUND CAPITAL, YYBS PARKS&REC DONATED$6,000 FOR FOX HILL FIELD CAPITAL 22 22-000-42-00-4217 PARKS CAPITAL-DONATIONS $ 7,000.00 $ 7,000.00 100.00% DONATION SHALLOW WELL$3,754.00,EM-UNNERKL WATER ENGINEERING$6,900.00&WATER QUALITY IMPROVEMENT 26 41-000-61-00-5301 ENGINEERING-GENERAL SERVICES $ 12,681.00 $ 15,000.00 84.54% $1,550.00 A AL GAS D OR U BE OPERATIONS 32 51-000-75-00-7004 SAFETY EQUIPMENT $ 2,325.01 $ 3,000.00 77.50% CREDITED ON RETURN S yWrl;F_ W99IMMNTMWER&DRIVEWAY OPERATIONS 34 52-000-62-00-5401 CONTRACTUAL SERVICES $ 3,445.33 $ 5,000.00 68.91% $2818.00 $1,466.00 R .00 ENGINE [PA KS&REC 41 79-610-62-00-5408 MAINTENANCE EQUIPMENT $ 7,019.18 $ 9,000.00 77.99% REPAIRS&PARTS - �' BLI�G�DEVI';LOPIvIENT:F,EES�"I'O�NEW LINE~ITEM FOR BUILI3ING'EXPANSION PER REVISED y EBUINTEREST RATE INCREASES&ADDITIONAL BOND VARIOUS INVESTMENT INCOME 101.9%-790.2% PROCEEDS NOT YET EXPENDED ALL VARIOUS GASOLINE 73.7%-91.7% GAS PRICE INCREASES 'Shadowed areas represent this months new additions UNITED CITY OF YORKVILLE DETAILED REVENUE & EXPENSE REPORT AS OF FEBRUARY 28, 2006 General Fund Revenue 1 Sanitary Sewer Improvement& Expansion 24 Finance 3 Water Improvement &Expansion 26 Engineering 5 Debt Service Fund 28 Police 7 Water Operations 30 Planning and Development 9 Sewer Maintenance 34 Streets and Alleys 11 Land Cash 37 Health and Sanitation 13 Land Acquisition 39 Motor Fuel Tax Fund 14 Parks & Recreation 40 Municipal Building 16 Library 45 Police Equipment Capital 18 Fox Industrial 49 Public Works Equipment Capital 20 Countryside TIF 51 Parks& Recreation Equipment Capital 22 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 1 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND 83.3% of FISCAL YEAR FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ GENERAL REVENUES TAXES 01-000-40-00-3996 ROAD CONTRIBUTION FEE 86,000.00 899,098.00 950,000.00 94.6 01-000-40-00-3997 IN TOWN ROAD PROGRAM FUNDING 0.00 3,783,562.20 4,357,225.00 86.8 01-000-40-00-3998 MPI BRISTOL RIDGE RD FUNDING 0.00 40.00 500,000.00 0.0 01-000-40-00-4000 REAL ESTATE TAXES 0.00 1,387,085.39 1,387,100.00 99.9 01-000-40-00-4001 TOWN ROAD/BRIDGE TAX 0.00 101,790.99 102,000.00 99.7 01-000-40-00-4010 PERSONAL PROPERTY TAX 0.00 9,947.56 10,000.00 99.4 01-000-40-00-4020 STATE INCOME TAX 58,675.41 403,157.22 666,000.00 60.5 01-000-40-00-4030 MUNICIPAL SALES TAX 215,468.36 1,537,679.55 2,308,900.00 66.5 01-000-40-00-4032 STATE USE TAX 7,766.91 67,307.34 97,006.00 69.3 01-000-40-00-4040 MUNICIPAL UTILITY TAX 0.00 286,028.43 340,000.00 84.1 01-000-40-00-4041 UTILITY TAX - NICOR 0.00 49,044.21 200,000.00 24.5 01-000-40-00-4042 UTILITY TAX - CABLE TV 25,895.41 83,241.78 75,000.00 110.9 01-000-40-00-4043 UTILITY TAX - TELEPHONE 37,810.36 263,016.48 380,000.00 69.2 01-000-40-00-4050 HOTEL TAX 1,370.35 15,967.78 20,000.00 79.8 01-000-40-00-4060 TRAFFIC SIGNAL REVENUE 0.00 0.00 5,000.00 0.0 --------------------------------------------------------------------------------- TOTAL TAXES 432,986.80 8,886,966.93 11,398,231.00 77.9 LICENSES & PERMITS 01-000-41-00-4100 LIQUOR LICENSE 0.00 12,040.80 25,000.00 48.1 01-000-41-00-4101 OTHER LICENSES 0.00 1,419.50 4,500.00 31.5 01-000-41-00-4110 BUILDING PERMITS 87,687.20 1,088,173.20 1,225,000.00 88.8 --------------------------------------------------------------------------------- TOTAL LICENSES & PERMITS 87,687.20 1,101,633.50 1,254,500.00 87.8 CHARGES FOR SERVICES 01-000-42-00-4205 FILING FEES 89.00 5,928.40 25,000.00 23.7 01-000-42-00-4206 GARBAGE SURCHARGE 35,892.76 171,707.53 192,780.00 89.0 01-000-42-00-4207 REFUSE STICKERS 0.00 0.00 0.00 0.0 01-000-42-00-4208 COLLECTION FEE - YBSD 0.00 0.00 34,000.00 0.0 01-000-42-00-4210 DEVELOPMENT FEES 68,475.00 1,065,064.48 1,175,000.00 90.6 01-000-42-00-4211 ENGINEERING CAPITAL FEE 4,900.00 40,700.00 40,000.00 101.7 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 109,356.76 1,283,400.41 1,466,780.00 87.4 P1 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 2 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ GENERAL FINES & FORFEITS 01-000-43-00-4310 TRAFFIC FINES 6,036.43 62,504.19 73,500.00 85.0 01-000-43-00-4315 REIMBURSE POLICE TRAINING 0.00 11,805.06 11,805.00 100.0 01-000-43-00-4320 ORDINANCE FEES 135.00 2,515.00 2,500.00 100.6 --------------------------------------------------------------------------------- TOTAL FINES & FORFEITS 6,171.43 76,824.25 87,805.00 87.4 MISCELLANEOUS 01-000-44-00-4401 DARE DONATIONS 0.00 125.00 1,250.00 10.0 01-000-44-00-4402 ROB ROY CREEK HYDRAULIC STUDY 0.00 22,700.00 40,000.00 56.7 01-000-44-00-4411 REIMBURSEMENTS-POLICE PROTECTN 60.15 2,085.75 3,000.00 69.5 01-000-44-00-4490 MISCELLANEOUS INCOME 1,022.13 10,152.41 10,000.00 101.5 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 1,082.28 35,063.16 54,250.00 64.6 INTERGOVERNMENTAL 01-000-45-00-4504 TRAFFIC SIGNAL REVENUE 0.00 0.00 0.00 0.0 01-000-45-00-4505 COPS GRANT - VESTS 0.00 0.00 2,500.00 0.0 01-000-45-00-4510 COPS GRANT 0.00 0.00 0.00 0.0 01-000-45-00-4511 POLICE-STATE TOBACCO GRANT 0.00 0.00 1,250.00 0.0 01-000-45-00-4525 GRANTS 49,675.53 49,675.53 50,000.00 99.3 --------------------------------------------------------------------------------- TOTAL INTERGOVERNMENTAL 49,675.53 49,675.53 53,750.00 92.4 INTEREST 01-000-46-00-4600 INVESTMENT INCOME 11,703.45 106,996.84 105,000.00 101.9 --------------------------------------------------------------------------------- TOTAL INTEREST 11,703.45 106,996.84 105,000.00 101.9 TRANSFERS 01-000-49-00-4915 TRANSFER FROM WATER OPERATIONS 0.00 150,000.00 200,000.00 75.0 01-000-49-00-4920 TRANSFER FROM SEWER MAINT. 0.00 52,500.00 70,000.00 75.0 01-000-49-00-4925 TRANSFER FROM SAN. SEWER IMPR 0.00 125,000.00 150,000.00 83.3 01-000-49-00-4930 TRANSFER FROM WATER IMPROVE. 0.00 150,000.00 200,000.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 477,500.00 620,000.00 77.0 P2 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 3 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TOTAL REVENUES: GENERAL 698,663.45 12,018,060.62 15,040,316.00 79.9 FINANCE & ADMINISTRATION EXPENSES PERSONNEL SERVICES 01-110-50-00-5100 SALARIES - MAYOR 0.00 3,775.00 7,500.00 50.3 01-110-50-00-5101 SALARIES - CITY CLERK 0.00 1,800.00 3,600.00 50.0 01-110-50-00-5102 SALARIES - CITY TREASURER 0.00 1,800.00 3,600.00 50.0 01-110-50-00-5103 SALARIES - ALDERMAN 900.00 15,450.00 29,080.00 53.1 01-110-50-00-5104 SALARIES - LIQUOR COMMISSIONER 0.00 500.00 1,000.00 50.0 01-110-50-00-5105 SALARIES - CITY ATTORNEY 884.80 9,290.40 11,502.00 80.7 01-110-50-00-5106 SALARIES - ADMINISTRATIVE 49,657.85 466,904.38 583,931.00 79.9 01-110-50-00-5136 SALARIES - PART TIME 3,452.63 42,682.45 50,000.00 85.3 01-110-50-00-5137 SALARIES - OVERTIME 0.00 313.25 1,500.00 20.8 01-110-50-00-5202 BENEFITS-UNEMPLOY. COMP. TAX 0.00 6,633.00 10,000.00 66.3 01-110-50-00-5203 BENEFITS - HEALTH INSURANCE 122,986.61 657,093.40 750,000.00 87.6 01-110-50-00-5204 BENEFITS - GROUP LIFE INSURANC 1,350.94 12,088.56 20,000.00 60.4 01-110-50-00-5205 BENEFITS - DENTAL/VISION ASST 7,029.85 55,584.07 60,000.00 92.6 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 186,262.68 1,273,914.51 1,531,713.00 83.1 PROFESSIONAL SERVICES 01-110-61-00-5300 LEGAL SERVICES 6,459.60 47,541.27 55,000.00 86.4 01-110-61-00-5304 AUDIT FEES & EXPENSES 0.00 22,493.00 25,500.00 88.2 01-110-61-00-5305 ACCOUNTING ASSISTANCE 0.00 0.00 5,000.00 0.0 01-110-61-00-5308 GASB 34 0.00 9,847.02 21,200.00 46.4 01-110-61-00-5310 EMPLOYEE ASSISTANCE 0.00 1,306.50 4,500.00 29.0 01-110-61-00-5311 CODIFICATION 0.00 4,938.00 5,000.00 98.7 01-110-61-00-5314 BUILDING INSPECTIONS 127,519.55 812,195.85 915,000.00 88.7 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 133,979.15 898,321.64 1,031,200.00 87.1 CONTRACTUAL SERVICES 01-110-62-00-5400 INSURANCE-LIABILITY & PROPERTY 0.00 121,210.58 121,211.00 99.9 01-110-62-00-5401 CONTRACTUAL SERVICES 2,013.16 27,714.75 42,500.00 65.2 01-110-62-00-5403 SPECIAL CENSUS 7,346.65 67,017.93 66,000.00 101.5 P3 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 4 DIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ FINANCE & ADMINISTRATION EXPENSES CONTRACTUAL SERVICES 01-110-62-00-5404 CABLE CONSORTIUM FEE 0.00 19,528.55 30,000.00 65.0 01-110-62-00-5406 OFFICE CLEANING 550.00 4,950.00 7,500.00 66.0 01-110-62-00-5410 MAINTENANCE - OFFICE EQUIPMENT 0.00 189.50 500.00 37.9 01-110-62-00-5411 MAINTENANCE - COMPUTERS 476.64 1,808.28 2,000.00 90.4 01-110-62-00-5412 MAINTENANCE - PHOTOCOPIERS 3,232.00 16,246.30 19,392.00 83.7 01-110-62-00-5421 WEARING APPAREL (8.91) 772.44 1,740.00 44.3 01-110-62-00-5427 FACADE PROGRAM 0.00 20,000.00 31,000.00 64.5 01-110-62-00-5436 TELEPHONE 1,257.18 10,451.15 15,000.00 69.6 01-110-62-00-5437 ACCTG SYSTEM SERVICE FEE 0.00 8,090.00 8,100.00 99.8 01-110-62-00-5438 CELLULAR TELEPHONE 131.91 1,349.73 2,300.00 58.6 01-110-62-00-5439 TELEPHONE SYSTEMS MAINTENANCE 1,255.20 2,666.40 11,000.00 24.2 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 16,253.83 301,995.61 358,243.00 84.2 PROFESSIONAL DEVELOPMENT 01-110-64-00-5600 DUES 213.00 3,677.73 4,000.00 91.9 01-110-64-00-5601 ILLINOIS MUNICIPAL LEAGUE DUES 0.00 781.00 781.00 100.0 01-110-64-00-5603 SUBSCRIPTIONS 84.50 314.50 500.00 62.9 01-110-64-00-5604 TRAINING & CONFERENCES 667.93 6,486.53 11,000.00 58.9 01-110-64-00-5605 TRAVEL/MEALS/LODGING 86.26 13,720.32 17,000.00 80.7 01-110-64-00-5607 PUBLIC RELATIONS 1,784.74 14,051.97 30,000.00 46.8 01-110-64-00-5608 SPONSORSHIPS 0.00 250.00 1,500.00 16.6 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 2,836.43 39,282.05 64,781.00 60.6 OPERATIONS 01-110-65-00-5800 CONTINGENCIES 270.00 7,545.70 275,988.00 2.7 01-110-65-00-5802 OFFICE SUPPLIES 1,676.87 11,524.65 12,000.00 96.0 01-110-65-00-5804 OPERATING SUPPLIES 586.30 5,790.11 13,000.00 44.5 01-110-65-00-5808 POSTAGE & SHIPPING 1,215.41 7,440.65 11,000.00 67.6 01-110-65-00-5809 PRINTING & COPYING 3,467.04 11,886.42 10,500.00 113.2 01-110-65-00-5810 PUBLISHING & ADVERTISING 12.80 2,086.27 3,500.00 59.6 01-110-65-00-5844 MARKETING - HOTEL TAX 1,386.81 13,225.11 20,000.00 66.1 --------------------------------------------------------------------------------- TOTAL OPERATIONS 8,615.23 59,498.91 345,988.00 17.1 P4 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 5 DIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ED: GL470002.WOW FUND: GENERAL FUND FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ FINANCE & ADMINISTRATION RETIREMENT 01-110-72-00-6500 IMRF PARTICIPANTS 3,529.96 37,402.84 47,791.00 78.2 01-110-72-00-6501 SOCIAL SECURITY & MEDICARE 4,405.64 44,773.66 52,821.00 84.7 --------------------------------------------------------------------------------- TOTAL RETIREMENT 7,935.60 82,176.50 100,612.00 81.6 CAPITAL OUTLAY 01-110-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 10,885.71 18,500.00 58.8 01-110-75-00-7003 OFFICE EQUIPMENT 249.00 1,590.90 3,000.00 53.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 249.00 12,476.61 21,500.00 58.0 OTHER OPERATING EXPENSES 01-110-78-00-9001 CITY TAX REBATE 0.00 70.09 1,200.00 5.8 01-110-78-00-9002 NICOR GAS 9,001.31 31,550.41 30,000.00 105.1 01-110-78-00-9003 SALES TAX REBATE 92,406.48 276,541.19 555,300.00 49.8 01-110-78-00-9004 MISCELLANEOUS 0.00 0.00 100.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING EXPENSES 101,407.79 308,161.69 586,600.00 52.5 TRANSFERS 01-110-99-00-9923 TRANSFER TO LIBRARY 3,975.00 27,600.00 28,000.00 98.5 01-110-99-00-9925 TRANSFER TO SAN SEWER 0.00 112,500.00 150,000.00 75.0 01-110-99-00-9940 TRANSFER TO PARK & RECREATION 59,482.78 755,908.00 755,908.00 100.0 01-110-99-00-9945 TRANSFER TO MUNICIPAL BLDG 0.00 63,402.25 102,043.00 62.1 --------------------------------------------------------------------------------- TOTAL TRANSFERS 63,457.78 959,410.25 1,035,951.00 92.6 TOTAL EXPENSES: FINANCE & ADMINISTRATION 520,997.49 3,935,237.77 5,076,588.00 77.5 ENGINEERING EXPENSES PERSONNEL SERVICES 01-150-50-00-5107 SALARIES-EMPLOYEES 19,529.77 205,702.52 257,929.00 79.7 01-150-50-00-5137 SALARIES-OVERTIME 0.00 0.00 1,000.00 0.0 P5 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 6 DIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 19,529.77 205,702.52 258,929.00 79.4 CONTRACTUAL SERVICES 01-150-62-00-5401 CONTRACTUAL SERVICES 1,757.60 62,265.23 .65,000.00 95.7 01-150-62-00-5402 GIS SYSTEM 2,471.83 2,471.83 5,000.00 49.4 01-150-62-00-5403 FEES 0.00 1,000.00 1,000.00 100.0 01-150-62-00-5409 MAINTENANCE-VEHICLES 104.80 824.55 4,200.00 19.6 01-150-62-00-5410 MAINTENANCE-OFFICE EQUIP 59.33 275.31 1,000.00 27.5 01-150-62-00-5411 MAINTENANCE-COMPUTERS 1,400.99 1,587.44 2,500.00 63.4 01-150-62-00-5421 WEARING APPAREL 0.00 254.00 1,100.00 23.0 01-150-62-00-5438 CELLULAR TELEPHONE 197.86 1,798.13 2,800.00 64.2 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 5,992.41 70,476.49 82,600.00 85.3 PROFESSIONAL DEVELOPMENT 01-150-64-00-5600 DUES 0.00 293.00 300.00 97.6 01-150-64-00-5604 TRAINING & CONFERENCES 227.00 227.00 6,000.00 3.7 01-150-64-00-5605 TRAVEL EXPENSE 0.00 956.40 1,000.00 95.6 01-150-64-00-5616 BOOKS & PUBLICATIONS 0.00 0.00 200.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 227.00 1,476.40 7,500.00 19.6 OPERATIONS 01-150-65-00-5801 ENGINEERING SUPPLIES 379.40 1,167.26 3,000.00 38.9 01-150-65-00-5802 OFFICE SUPPLIES 253.60 1,360.22 2,500.00 54.4 01-150-65-00-5809 PRINTING & COPYING 223.96 647.12 2,000.00 32.3 01-150-65-00-5820 PICK UP TRUCK 0.00 0.00 40,000.00 0.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS 856.96 3,174.60 47,500.00 6.6 RETIREMENT 01-150-72-00-6500 IMRF PARTICIPANTS 1,542.86 16,726.72 20,343.00 82.2 01-150-72-00-6501 SOCIAL SECURITY & MEDICARE 1,461.38 15,420.98 19,120.00 80.6 --------------------------------------------------------------------------------- TOTAL RETIREMENT 3,004.24 32,147.70 39,463.00 81.4 CAPITAL OUTLAY P6 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 7 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ ENGINEERING EXPENSES CAPITAL OUTLAY 01-150-75-00-7002 COMPUTER EQUIPMENT & SOFTWARE 0.00 3,758.79 3,850.00 97.6 01-150-75-00-7003 OFFICE EQUIPMENT 0.00 69.98 500.00 13.9 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 3,828.77 4,350.00 88.0 TOTAL EXPENSES: ENGINEERING 29,610.38 316,806.48 440,342.00 71.9 PUBLIC SAFETY/POLICE DEPT. EXPENSES PERSONNEL SERVICES 01-210-50-00-5107 SALARIES - EMPLOYEES 47,982.13 510,959.15 670,154.00 76.2 01-210-50-00-5131 SALARIES-CHIEF/LIEUTENANT/SERG 41,481.02 451,687.29 565,295.00 79.9 01-210-50-00-5133 SALARIES - COPS 7,912.62 84,708.88 105,693.00 80.1 01-210-50-00-5134 SALARIES - CROSSING GUARD 1,902.50 13,085.75 19,000.00 68.8 01-210-50-00-5135 SALARIES - POLICE CLERKS 8,148.32 85,557.43 107,179.00 79.8 01-210-50-00-5136 SALARIES - PART TIME 3,121.85 31,576.04 35,000.00 90.2 01-210-50-00-5137 SALARIES - OVERTIME 2,671.29 38,119.68 50,000.00 76.2 01-210-50-00-5200 CADET PROGRAM 1,617.00 8,343.67 10,000.00 83.4 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 114,836.73 1,224,037.89 1,562,321.00 78.3 PROFESSIONAL SERVICES 01-210-61-00-5300 LEGAL SERVICES 590.00 10,180.37 20,000.00 50.9 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 590.00 10,180.37 20,000.00 50.9 CONTRACTUAL SERVICES 01-210-62-00-5408 MAINTENANCE - EQUIPMENT 1,373.33 7,843.43 8,000.00 98.0 01-210-62-00-5409 MAINTENANCE - VEHICLES 2,204.49 22,584.61 24,000.00 94.1 01-210-62-00-5410 MAINT-OFFICE EQUIPMENT 191.63 2,438.63 2,500.00 97.5 01-210-62-00-5411 MAINTENANCE - COMPUTERS 0.00 1,568.24 2,100.00 74.6 01-210-62-00-5414 WEATHER WARNING SIREN MAINT 0.00 3,309.60 5,000.00 66.1 01-210-62-00-5421 WEARING APPAREL 878.03 10,227.47 27,000.00 37.8 P7 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 8 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PUBLIC SAFETY/POLICE DEPT. EXPENSES CONTRACTUAL SERVICES 01-210-62-00-5422 COPS GRANT IV - VESTS 0.00 2,634.30 3,000.00 87.8 01-210-62-00-5423 CLASY GRANT 0.00 0.00 1,000.00 0.0 01-210-62-00-5429 PSYCHOLOGICAL TESTING 0.00 420.00 1,500.00 28.0 01-210-62-00-5430 HEALTH SERVICES 0.00 1,117.08 3,000.00 37.2 01-210-62-00-5431 LABORATORY FEES 0.00 0.00 1,000.00 0.0 01-210-62-00-5436 TELEPHONE 1,508.32 12,339.17 20,000.00 61.6 01-210-62-00-5438 CELLULAR TELEPHONE 994.74 8,878.01 14,000.00 63.4 01-210-62-00-5441 MTD-ALERTS FEE 0.00 4,620.00 4,620.00 100.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 7,150.54 77,980.54 116,720.00 66.8 PROFESSIONAL DEVELOPMENT 01-210-64-00-5600 DUES 207.00 1,553.20 2,250.00 69.0 01-210-64-00-5603 SUBSCRIPTIONS 0.00 183.15 300.00 61.0 01-210-64-00-5604 TRAINING & CONFERENCE 837.24 14,059.49 19,000.00 73.9 01-210-64-00-5605 TRAVEL EXPENSES (1,477.13) 7,767.25 10,500.00 73.9 01-210-64-00-5606 COMMUNITY RELATIONS 260.00 2,249.84 5,500.00 40.9 01-210-64-00-5607 POLICE COMMISSION 750.00 5,973.07 13,000.00 45.9 01-210-64-00-5608 TUITION REIMBURSEMENT 3,229.75 7,562.12 14,000.00 54.0 01-210-64-00-5609 POLICE RECRUIT ACADEMY 0.00 0.00 3,500.00 0.0 01-210-64-00-5610 GUN RANGE FEES 0.00 0.00 625.00 0.0 01-210-64-00-5611 SRT FEE 0.00 0.00 2,000.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 3,806.86 39,348.12 70,675.00 55.6 OPERATIONS 01-210-65-00-5802 OFFICE SUPPLIES 724.37 4,721.79 6,500.00 72.6 01-210-65-00-5804 OPERATING SUPPLIES 1,847.18 10,617.46 16,000.00 66.3 01-210-65-00-5808 POSTAGE & SHIPPING 273.70 1,312.27 3,000.00 43.7 01-210-65-00-5809 PRINTING & COPYING 574.35 3,997.78 4,500.00 88.8 01-210-65-00-5810 PUBLISHING & ADVERTISING 500.00 755.23 1,000.00 75.5 01-210-65-00-5812 GASOLINE 7,334.64 40,163.80 51,300.00 78.2 01-210-65-00-5813 AMMUNITION 0.00 0.00 5,000.00 0.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS 11,254.24 61,568.33 87,300.00 70.5 P8 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE 9 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PUBLIC SAFETY/POLICE DEPT. RETIREMENT 01-210-72-00-6500 IMRF PARTICIPANTS 643.72 6,978.15 8,732.00 79.9 01-210-72-00-6501 SOCIAL SECURITY & MEDICARE 9,356.99 94,018.75 116,600.00 80.6 01-210-72-00-6502 POLICE PENSION 0.00 231,123.76 231,686.00 99.7 --------------------------------------------------------------------------------- TOTAL RETIREMENT 10,000.71 332,120.66 357,018.00 93.0 CAPITAL OUTLAY 01-210-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 2,038.12 8,500.00 23.9 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 2,038.12 8,500.00 23.9 OTHER OPERATING EXPENSES 01-210-78-00-9004 BIKE PATROL 0.00 1,422.51 2,000.00 71.1 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING EXPENSES 0.00 1,422.51 2,000.00 71.1 TOTAL EXPENSES: PUBLIC SAFETY/POLICE DEPT. 147,639.08 1,748,696.54 2,224,534.00 78.6 PLANNING & DEVELOPMENT EXPENSES PERSONNEL SERVICES 01-220-50-00-5107 EMPLOYEE SALARIES 0.00 7,665.00 43,700.00 17.5 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 0.00 7,665.00 43,700.00 17.5 PROFESSIONAL SERVICES 01-220-61-00-5300 LEGAL SERVICES 10,393.52 39,799.70 38,000.00 104.7 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 10,393.52 39,799.70 38,000.00 104.7 CONTRACTUAL SERVICES 01-220-62-00-5401 CONTRACTUAL SERVICES 2,225.57 34,028.22 50,000.00 68.0 01-220-62-00-5430 PLANNING CONSULTANT 870.00 6,677.92 20,000.00 33.3 01-220-62-00-5432 ECONOMIC DEVELOPMENT 0.00 45,000.00 45,000.00 100.0 P9 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 10 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PLANNING & DEVELOPMENT EXPENSES CONTRACTUAL SERVICES 01-220-62-00-5438 CELULAR TELEPHONE 169.56 169.56 500.00 33.9 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 3,265.13 85,875.70 115,500.00 74.3 PROFESSIONAL DEVELOPMENT 01-220-64-00-5600 DUES 300.00 400.00 300.00 133.3 01-220-64-00-5604 TRAINING & CONFERENCES 0.00 0.00 3,000.00 0.0 01-220-64-00-5605 TRAVEL EXPENSE 0.00 0.00 1,000.00 0.0 01-220-64-00-5616 BOOKS & PUBLICATIONS 0.00 0.00 425.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 300.00 400.00 4,725.00 8.4 OPERATIONS 01-220-65-00-5804 OPERATING SUPPLIES 196.91 1,192.14 5,000.00 23.8 01-220-65-00-5809 PRINTING & COPYING 179.18 511.93 1,000.00 51.1 01-220-65-00-5810 PUBLISHING & ADVERTISING 48.00 3,299.17 10,000.00 32.9 01-220-65-00-5814 BOOKS & MAPS 0.00 1,042.00 3,000.00 34.7 --------------------------------------------------------------------------------- TOTAL OPERATIONS 424.09 6,045.24 19,000.00 31.8 RETIREMENT 01-220-72-00-6500 IMRF PARTICIPANTS 0.00 0.00 3,475.00 0.0 01-220-72-00-6501 SOCIAL SECURITY & MEDICARE 0.00 0.00 3,350.00 0.0 --------------------------------------------------------------------------------- TOTAL RETIREMENT 0.00 0.00 6,825.00 0.0 CAPITAL OUTLAY 01-220-75-00-7002 COMPUTER EQUIP & SOFTWARE 3,858.74 3,878.69 7,500.00 51.7 01-220-75-00-7003 OFFICE EQUIPMENT 2,682.10 2,918.06 24,000.00 12.1 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 6,540.84 6,796.75 31,500.00 21.5 TOTAL EXPENSES: PLANNING & DEVELOPMENT 20,923.58 146,582.39 259,250.00 56.5 P10 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 11 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ STREETS EXPENSES PERSONNEL SERVICES 01-410-50-00-5107 SALARIES - EMPLOYEE 12,904.22 141,490.29 186,178.00 75.9 01-410-50-00-5136 SALARIES - PART TIME 0.00 1,484.00 2,500.00 59.3 01-410-50-00-5137 SALARIES - OVERTIME 852.94 14,703.09 20,400.00 72.0 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 13,757.16 157,677.38 209,078.00 75.4 PROFESSIONAL SERVICES 01-410-61-00-5313 ENGINEERING - IN TOWN RD PROG 0.00 101,814.23 215,210.00 47.3 01-410-61-00-5314 INSPECTIONS & LICENSES 0.00 318.00 500.00 63.6 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 0.00 102,132.23 215,710.00 47.3 CONTRACTUAL SERVICES 01-410-62-00-5401 CONTRACTUAL SERVICES 627.50 1,175.82 2,000.00 58.7 01-410-62-00-5408 MAINTENANCE-EQUIPMENT 2,760.80 9,904.31 9,000.00 110.0 O1-410-62-00-5409 MAINTENANCE-VEHICLES 2,943.04 12,147.97 15,500.00 78.3 01-410-62-00-5414 MAINTENANCE-TRAFFIC SIGNALS 1,289.02 11,040.00 24,000.00 46.0 01-410-62-00-5415 MAINTENANCE-STREET LIGHTS 389.93 17,886.44 25,000.00 71.5 01-410-62-00-5420 MAINTENANCE-STORM SEWER 0.00 0.00 10,000.00 0.0 01-410-62-00-5421 WEARING APPAREL 1,350.12 4,175.74 6,000.00 69.5 01-410-62-00-5434 RENTAL-EQUIPMENT 0.00 0.00 2,000.00 0.0 01-410-62-00-5435 ELECTRICITY 5,762.32 47,400.54 55,000.00 86.1 01-410-62-00-5438 CELLULAR TELEPHONE 197.86 2,005.55 3,300.00 60.7 01-410-62-00-5440 STREET LIGHTING 0.00 686.50 6,000.00 11.4 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 15,320.59 106,422.87 157,800.00 67.4 PROFESSIONAL DEVELOPMENT 01-410-64-00-5604 TRAINING & CONFERENCES 0.00 2,112.55 5,000.00 42.2 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 0.00 2,112.55 51000.00 42.2 OPERATIONS 01-410-65-00-5804 OPERATING SUPPLIES 1,008.81 16,094.27 25,800.00 62.3 01-410-65-00-5812 GASOLINE 6,281.23 27,518.56 30,000.00 91.7 P11 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 12 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ STREETS EXPENSES OPERATIONS 01-410-65-00-5815 HAND TOOLS 0.00 766.74 5,000.00 15.3 01-410-65-00-5817 GRAVEL 0.00 719.52 6,500.00 11.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS 7,290.04 45,099.09 67,300.00 67.0 RETIREMENT 01-410-72-00-6500 IMRF PARTICIPANTS 1,086.81 12,680.97 16,783.00 75.5 01-410-72-00-6501 SOCIAL SECURITY & MEDICARE 1,052.43 12,060.74 16,616.00 72.5 --------------------------------------------------------------------------------- TOTAL RETIREMENT 2,139.24 24,741.71 33,399.00 74.0 CAPITAL OUTLAY 01-410-75-00-5418 MOSQUITO CONTROL 0.00 20,295.60 20,300.00 99.9 01-410-75-00-5419 MAINT SUPPLIES - STREET 0.00 0.00 0.00 0.0 01-410-75-00-7004 SAFETY EQUIPMENT 0.00 669.21 1,000.00 66.9 01-410-75-00-7099 GRANDE RESERVE PERIMETER ROADS 83,602.19 399,758.14 500,000.00 79.9 01-410-75-00-7100 STREET REHAB PROJECTS 0.00 35,646.99 40,000.00 89.1 01-410-75-00-7101 IN TOWN ROAD PROGRAM 43,476.77 1,517,729.91 2,345,000.00 64.7 O1-410-75-00-7102 TREE & STUMP REMOVAL 0.00 9,510.00 30,000.00 31.7 01-410-75-00-7103 SIDEWALK CONSTRUCTION 0.00 0.00 30,000.00 0.0 01-410-75-00-7104 FOX HILL SSA EXPENSES 0.00 6,642.00 18,000.00 36.9 01-410-75-00-7105 IN-TOWN ROAD PRORAM-RESERVE 0.00 0.00 1,672,015.00 0.0 01-410-75-00-7106 ROAD CONTRIBUTION FUND PROJ 0.00 11,042.71 12,000.00 92.0 01-410-75-00-7107 ROAD CONTRIBUTION FUND-RESERVE 0.00 0.00 938,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 127,078.96 2,001,294.56 5,606,315.00 35.6 TRANSFERS 01-410-99-00-9930 TRANSFER TO WATER IMPROVEMENT 0.00 161,250.00 215,000.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 161,250.00 215,000.00 75.0 TOTAL EXPENSES: STREETS 165,585.99 2,600,730.39 6,509,602.00 39.9 P12 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 13 LIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 LD: GL470002.WOW FUND: GENERAL FUND FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ HEALTH & SANITATION EXPENSES CONTRACTUAL SERVICES 01-540-62-00-5442 GARBAGE SERVICES 50,043.88 432,629.96 525,000.00 82.4 01-540-62-00-5443 LEAF PICKUP 0.00 7,050.00 5,000.00 141.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 50,043.88 439,679.96 530,000.00 82.9 TOTAL EXPENSES: HEALTH & SANITATION 50,043.88 439,679.96 530,000.00 82.9 TOTAL FUND REVENUES 698,663.45 12,018,060.62 15,040,316.00 79.9 TOTAL FUND EXPENSES 934,800.40 9,187,733.53 15,040,316.00 61.0 FUND SURPLUS (DEFICIT) (236,136.95) 2,830,327.09 0.00 100.0 P13 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 14 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: MOTOR FUEL TAX FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES TAXES 15-000-40-00-3999 CARRY OVER BALANCE 0.00 423,181.00 423,181.00 100.0 15-000-40-00-4060 MOTOR FUEL TAX ALLOTMENTS 21,746.48 225,380.36 250,487.00 89.9 --------------------------------------------------------------------------------- TOTAL TAXES 21,746.48 648,561.36 673,668.00 96.2 MISCELLANEOUS 15-000-44-00-4490 MISCELLANEOUS INCOME 0.00 0.00 0.00 0.0 ---------------------------------------------------------=----------------------- TOTAL MISCELLANEOUS 0.00 0.00 0.00 0.0 INTEREST 15-000-46-00-4600 INVESTMENT INCOME 1,406.61 12,231.33 12,000.00 101.9 --------------------------------------------------------------------------------- TOTAL INTEREST 1,406.61 12,231.33 12,000.00 101.9 TOTAL REVENUES: 23,153.09 660,792.69 685,668.00 96.3 EXPENSES OPERATIONS 15-000-65-00-5800 CONTINGENCY 0.00 11,936.00 94,088.00 12.6 15-000-65-00-5818 SALT 4,535.37 42,857.28 51,800.00 82.7 --------------------------------------------------------------------------------- TOTAL OPERATIONS 4,535.37 54,793.28 145,888.00 37.5 CAPITAL OUTLAY 15-000-75-00-7007 SIGNS 1,355.11 8,404.95 9,990.00 84.1 15-000-75-00-7008 CRACK FILLING 3,402.37 32,199.78 30,000.00 107.3 15-000-75-00-7107 CONSTRUCTION ENGINEERING 10,736.69 55,942.03 150,000.00 37.2 15-000-75-00-7110 COLD PATCH 205.34 403.07 9,600.00 4.1 15-000-75-00-7111 HOT PATCH 0.00 1,830.18 8,000.00 22.8 15-000-75-00-7112 FAXON ROAD ENGINEERING 0.00 0.00 1,000.00 0.0 15-000-75-00-7113 COUNTRYSIDE PKWY CONSTRUCTION 0.00 0.00 300,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 15,699.51 98,780.01 508,590.00 19.4 P14 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 15 LIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 [D: GL470002.W0W FUND: MOTOR FUEL TAX FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TRANSFERS 15-000-99-00-9960 TRANSFER TO FOX IND FUND 0.00 31,189.68 31,190.00 99.9 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 31,189.68 31,190.00 99.9 TOTAL EXPENSES: 20,234.88 184,762.97 685,668.00 26.9 TOTAL FUND REVENUES 23,153.09 660,792.69 685,668.00 96.3 DOTAL FUND EXPENSES 20,234.88 184,762.97 685,668.00 26.9 FUND SURPLUS (DEFICIT) 2,918.21 476,029.72 0.00 100.0 P15 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 16 DIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: MUNICIPAL BUILDLING FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 16-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 0.00 0.0 CHARGES FOR SERVICES 16-000-42-00-4211 DEVELOPMENT FEES-BUILDING 7,500.00 68,700.00 80,000.00 85.8 16-000-42-00-4215 BEECHER RENTAL FEE 1,000.00 5,000.00 6,000.00 83.3 16-000-42-00-4216 RENTAL FEES 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 8,500.00 73,700.00 86,000.00 85.6 TRANSFERS 16-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 63,402.25 102,043.00 62.1 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 63,402.25 102,043.00 62.1 TOTAL REVENUES: 8,500.00 137,102.25 188,043.00 72.9 EXPENSES CONTRACTUAL SERVICES 16-000-62-00-5416 MAINT-GENERAL BLDG & GROUNDS 0.00 225.00 5,000.00 4.5 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 0.00 225.00 5,000.00 4.5 CAPITAL OUTLAY 16-000-75-00-7200 BLDG IMPROV- BEEHCER/RIVFRNT 2,400.00 8,863.51 10,000.00 88.6 16-000-75-00-7203 BLDG IMPROVEMENTS-PUBLIC WORKS 482.00 9,554.40 10,000.00 95.5 16-000-75-00-7204 BLDG MAINT - CITY HALL 1,215.61 10,829.22 12,000.00 90.2 16-000-75-00-7205 BLDG IMPROVEMENTS-LIBRARY 0.00 2,548.20 4,000.00 63.7 16-000-75-00-7206 LANDSCAPING-PUBLIC BUILDINGS 44.21 44.21 2,000.00 2.2 16-000-75-00-7209 BEECHER PARKING LOT 0.00 41,119.60 41,120.00 99.9 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 4,141.82 72,959.14 79,120.00 92.2 P16 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 17 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: MUNICIPAL BUILDLING FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TRANSFERS 16-000-99-00-9965 TRANSFER TO DEBT SERVICE 0.00 77,942.25 103,923.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 77,942.25 103,923.00 75.0 TOTAL EXPENSES: 4,141.82 151,126.39 188,043.00 80.3 TOTAL FUND REVENUES 8,500.00 137,102.25 188,043.00 72.9 TOTAL FUND EXPENSES 4,141.82 151,126.39 188,043.00 80.3 FUND SURPLUS (DEFICIT) 4,358.18 (14,024.14) 0.00 100.0 P17 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 18 DIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: POLICE EQUIPMENT CAPITAL FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 20-000-40-00-3999 CARRY OVER -WEATHER WARN SIREN 0.00 69,250.00 69,250.00 100.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 69,250.00 69,250.00 100.0 CHARGES FOR SERVICES 20-000-42-00-4212 DEV FEES - POLICE 15,750.00 153,900.00 170,000.00 90.5 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 15,750.00 153,900.00 170,000.00 90.5 MISCELLANEOUS 20-000-44-00-4402 K-9 DONATIONS 0.00 200.00 1,000.00 20.0 20-000-44-00-4403 IN CAR VIDEO DONATIONS 1,269.00 5,285.00 2,200.00 240.2 20-000-44-00-4404 DONATIONS 0.00 1,500.00 1,500.00 100.0 20-000-44-00-4405 WEATHER WARNING SIREN 0.00 29,230.50 30,000.00 97.4 20-000-44-00-4431 SALE OF POLICE SQUADS 0.00 0.00 500.00 0.0 20-000-44-00-4489 RICP DISASTER PLAN GRANT 0.00 9,990.27 9,990.00 100.0 20-000-44-00-4490 MISCELLANEOUS INCOME 0.00 24,609.27 24,600.00 100.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 1,269.00 70,815.04 69,790.00 101.4 TOTAL REVENUES: 17,019.00 293,965.04 309,040.00 95.1 EXPENSES WEAPONS 20-000-65-00-5811 LETHAL/NON-LETHAL WEAPONS 0.00 1,962.00 6,825.00 28.7 --------------------------------------------------------------------------------- TOTAL WEAPONS 0.00 1,962.00 6,825.00 28.7 CAPITAL OUTLAY 20-000-75-00-7001 EQUIPMENT 0.00 0.00 20,000.00 0.0 20-000-75-00-7002 K-9 EQUIPMENT 0.00 0.00 1,000.00 0.0 20-000-75-00-7005 VEHICLES 0.00 72,384.64 74,000.00 97.8 20-000-75-00-7006 CAR BUILD OUT 4,605.15 10,988.42 26,000.00 42.2 20-000-75-00-7008 NEW WEATHER WARNING SIRENS 0.00 0.00 60,000.00 0.0 P18 )ATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 19 'IME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 :D: GL470002.WOW FUND: POLICE EQUIPMENT CAPITAL FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ :XPENSES CAPITAL OUTLAY 20-000-75-00-7009 RESERVE-WEATHER WARNING SIREN 0.00 0.00 39,648.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 4,605.15 83,373.06 220,648.00 37.7 OTHER 20-000-78-00-9009 RESERVE 0.00 10,587.51 57,457.00 18.4 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 10,587.51 57,457.00 18.4 TRANSFERS 20-000-99-00-9965 TRANSFER TO DEBT SERV FUND 0.00 18,082.50 24,110.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 18,082.50 24,110.00 75.0 TOTAL EXPENSES: 4,605.15 114,005.07 309,040.00 36.8 COTAL FUND REVENUES 17,019.00 293,965.04 309,040.00 95.1 COTAL FUND EXPENSES 4,605.15 114,005.07 309,040.00 36.8 ?UND SURPLUS (DEFICIT) 12,413.85 179,959.97 0.00 100.0 P19 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 20 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PUBLIC WORKS EQUIP CAPITAL FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 21-000-40-00-3999 CARRY OVER BALANCE 0.00 186,721.00 186,721.00 100.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 186,721.00 186,721.00 100.0 CHARGES FOR SERVICES 21-000-42-00-4213 DEVELOPMENT FEES-PUBLIC WORKS 37,450.00 379,400.00 485,000.00 78.2 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 37,450.00 379,400.00 485,000.00 78.2 MISCELLANEOUS 21-000-44-00-4430 SALE OF EQUIPMENT 0.00 34,113.84 34,113.00 100.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 0.00 34,113.84 34,113.00 100.0 TRANSFERS 21-000-49-00-4915 TRANSFER FROM WATER FUND 0.00 37,500.00 50,000.00 75.0 21-000-49-00-4920 TRANSFER FROM SEWER FUND 0.00 22,500.00 30,000.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 60,000.00 80,000.00 75.0 TOTAL REVENUES: 37,450.00 660,234.84 785,834.00 84.0 EXPENSES CAPITAL OUTLAY 21-000-75-00-7001 EQUIPMENT 0.00 0.00 90,500.00 0.0 21-000-75-00-7005 VEHICLES 0.00 184,968.00 375,000.00 49.3 21-000-75-00-7009 1 TON DUMP' 0.00 0.00 0.00 0.0 21-000-75-00-7015 SKIDSTEER UPGRADE 0.00 3,951.86 3,952.00 99.9 21-000-75-00-7107 TRUCK ACCESSORIES 0.00 9,602.73 14,000.00 68.5 21-000-75-00-7115 SALT DOME 0.00 0.00 175,000.00 0.0 21-000-75-00-7130 PUBLIC WORKS BLDG ADDITION 0.00 0.00 77,424.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 198,522.59 735,876.00 26.9 P20 )ATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 21 LIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 CD: GL470002.WOW FUND: PUBLIC WORKS EQUIP CAPITAL FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ OTHER 21-000-78-00-9009 RESERVE 0.00 0.00 49,958.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 49,958.00 0.0 TOTAL EXPENSES: 0.00 198,522.59 785,834.00 25.2 TOTAL FUND REVENUES 37,450.00 660,234.84 785,834.00 84.0 TOTAL FUND EXPENSES 0.00 198,522.59 785,834.00 25.2 FUND SURPLUS (DEFICIT) 37,450.00 461,712.25 0.00 100.0 P21 )ATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 22 DIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ED: GL470002.WOW FUND: PARKS & REC EQUIP CAPITAL FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 22-000-40-00-3999 CARRY OVER BALANCE 0.00 65,691.00 65,691.00 100.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 65,691.00 65,691.00 100.0 CHARGES FOR SERVICES 22-000-42-00-4216 PARKS CAPITAL FEE 0.00 13,950.00 20,000.00 69.7 22-000-42-00-4217 PARKS CAPITAL - DONATIONS 0.00 7,000.00 7,000.00 100.0 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 0.00 20,950.00 27,000.00 77.5 MISCELLANEOUS 22-000-44-00-4430 SALE OF VEHICLES/EQUIPMENT 0.00 0.00 10,000.00 0.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 0.00 0.00 10,000.00 0.0 TOTAL REVENUES: 0.00 86,641.00 102,691.00 84.3 EXPENSES OTHER 22-000-65-00-5800 RESERVE 0.00 0.00 13,591.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 13,591.00 0.0 PARKS EXPENSES CAPITAL OUTLAY 22-610-75-00-7006 PICK UP TRUCK 0.00 0.00 60,000.00 0.0 22-610-75-00-7009 COMPUTER WORKSTATIONS 0.00 0.00 9,000.00 0.0 22-610-75-00-7012 PLAYGROUNDS 0.00 630.00 0.00 (100.0) 22-610-75-00-7013 PLAYGROUND REPAIRS 0.00 0.00 2,500.00 0.0 22-610-75-00-7014 SIGN REPLACEMENTS 0.00 0.00 4,000.00 0.0 22-610-75-00-7015 MOWER 0.00 0.00 7,000.00 0.0 22-610-75-00-7017 RECREATION EQUIPMENT 0.00 6,174.76 6,600.00 93.5 P22 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 23 DIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PARKS & REC EQUIP CAPITAL FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 6,804.76 89,100.00 7.6 TOTAL EXPENSES: PARKS 0.00 6,804.76 89,100.00 7.6 TOTAL FUND REVENUES 0.00 86,641.00 102,691.00 84.3 TOTAL FUND EXPENSES 0.00 6,804.76 102,691.00 6.6 FUND SURPLUS (DEFICIT) 0.00 79,836.24 0.00 100.0 P23 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 24 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: SANITARY SEWER IMPROVEMENT FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 37-000-40-00-3999 CARRY OVER 0.00 4,016,171.00 4,016,171.00 100.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 4,016,171.00 4,016,171.00 100.0 CHARGES FOR SERVICES 37-000-42-00-4220 CONNECTION FEES 97,000.00 1,013,600.00 1,260,000.00 80.4 37-000-42-00-4221 RIVER CROSSING FEES 280.00 5,899.00 20,000.00 29.4 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 97,280.00 1,019,499.00 1,280,000.00 79.6 INTEREST 37-000-46-00-4600 INVESTMENT INCOME 39,432.26 174,471.03 170,000.00 102.6 --------------------------------------------------------------------------------- TOTAL INTEREST 39,432.26 174,471.03 170,000.00 102.6 OTHER OPERATING RECEIPTS 37-000-48-00-4803 ROB ROY CREEK REVENUE 0.00 12,150,312.50 12,150,313.00 99.9 37-000-48-00-4804 SOUTHWEST SVC AREA INTERCEPTOR 0.00 73,302.21 5,500,000.00 1.3 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING RECEIPTS 0.00 12,223,614.71 17,650,313.00 69.2 TRANSFERS 37-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 112,500.00 150,000.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 112,500.00 150,000.00 75.0 TOTAL REVENUES: 136,712.26 17,546,255.74 23,266,484.00 75.4 EXPENSES CONTRACTUAL SERVICES 37-000-62-00-5401 CONTRACTURAL/PROFESSIONAL SERV 1,574.00 4,211.50 50,000.00 8.4 37-000-62-00-5402 ENG/LGL/CONTINGNCY-COUNTRYSIDE 26,673.80 115,719.51 100,000.00 115.7 37-000-62-00-5405 ENG/LGL/CONTINGENCY-BRUELL ST. 413.81 93,634.64 95,000.00 98.5 37-000-62-00-5406 ENG/LGL/CONTINGENCY-HYDRAULIC 0.00 1,940.43 2,000.00 97.0 P24 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 25 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: SANITARY SEWER IMPROVEMENT FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES CONTRACTUAL SERVICES 37-000-62-00-5407 ENG/LGL/CONTING ROB ROY CREEK 225.00 225.00 0.00 (100.0) --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 28,886.61 215,731.08 247,000.00 87.3 OTHER 37-000-65-00-5421 GIS SYSTEM 0.00 0.00 10,000.00 0.0 37-000-65-00-5800 CONTINGENCY 0.00 0.00 434,610.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 444,610.00 0.0 DEBT SERVICE 37-000-66-00-6012 DEBT ISSUANCE COSTS 0.00 216,424.50 85,700.00 252.5 --------------------------------------------------------------------------------- TOTAL DEBT SERVICE 0.00 216,424.50 85,700.00 252.5 CAPITAL OUTLAY 37-000-75-00-7502 HYDRAULIC INTERCEPTOR 0.00 0.00 0.00 0.0 37-000-75-00-7503 COUNTRYSIDE INTERCEPTOR 618,046.80 2,104,078.13 2,823,455.00 74.5 37-000-75-00-7504 BRUELL STREET LIFT STATION 18,995.40 816,658.80 798,000.00 102.3 37-000-75-00-7505 ROB ROY CREEK SANITARY 917,754.59 3,462,968.57 12,177,613.00 28.4 37-000-75-00-7506 SOUTHWEST SVC AREA INTERCEPTOR 17,250.00 113,537.50 5,500,000.00 2.0 37-000-75-00-7508 MANHOLE REHAB PROJECT 0.00 6,456.00 15,000.00 43.0 37-000-75-00-7509 SCADA SYSTEM 0.00 0.00 100,000.00 0.0 37-000-75-00-7515 HEARTLAND ONSITE INTERCEPTOR 0.00 278,893.00 278,893.00 100.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 1,572,046.79 6,782,592.00 21,692,961.00 31.2 TRANSFERS 37-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 125,000.00 150,000.00 83.3 37-000-99-00-9965 TRANSFER TO DEBT SERVICE 0.00 484,659.75 646,213.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 609,659.75 796,213.00 76.5 TOTAL EXPENSES: 1,600,933.40 7,824,407.33 23,266,484.00 33.6 TOTAL FUND REVENUES 136,712.26 17,546,255.74 23,266,484.00 75.4 TOTAL FUND EXPENSES 1,600,933.40 7,824,407.33 23,266,484.00 33.6 FUND SURPLUS (DEFICIT) (1,464,221.14) 9,721,848.41 0.00 100.0 P25 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 26 DIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CHARGES FOR SERVICES 41-000-42-00-4220 CONNECTION FEES 120,420.00 1,183,480.00 1,450,000.00 81.6 41-000-42-00-4221 SOUTHWEST WATER MAIN REVENUE 0.00 35,957.94 0.00 100.0 41-000-42-00-4230 SOUTHWEST WATER MAIN PROJ REV 0.00 0.00 2,600,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 120,420.00 1,219,437.94 4,050,000.00 30.1 INTEREST 41-000-46-00-4600 INVESTMENT INCOME 6,054.79 59,671.98 80,000.00 74.5 --------------------------------------------------------------------------------- TOTAL INTEREST 6,054.79 59,671.98 80,000.00 74.5 OTHER OPERATING RECEIPTS 41-000-48-00-4800 LOAN PROCEEDS 0.00 0.00 1,947,070.00 0.0 41-000-48-00-4801 IEPA LOAN/CONTRACT B PROCEEDS 0.00 2,046,892.96 2,046,893.00 99.9 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING RECEIPTS 0.00 2,046,892.96 3,993,963.00 51.2 TRANSFERS 41-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 161,250.00 215,000.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 161,250.00 215,000.00 75.0 TOTAL REVENUES: 126,474.79 3,487,252.88 8,338,963.00 41.8 EXPENSES PROFESSIONAL SERVICE 41-000-61-00-5300 LEGAL SERVICES 225.00 3,153.20 8,000.00 39.4 41-000-61-00-5301 ENGINEERING - GENERAL SERVICES 0.00 12,681.00 15,000.00 84.5 41-000-61-00-5400 RADIUM COMPLIANCE -CONTRACT B 140,659.20 699,018.30 3,756,097.00 18.6 41-000-61-00-5401 ENGINEERING-RADIUM CONTRACT B 113,576.45 281,488.71 274,000.00 102.7 41-000-61-00-5405 PROF. SVCS- RADIUM CONTRACT B 0.00 29,701.39 35,000.00 84.8 41-000-61-00-5408 CENTRAL ZONE - CONTRACT C 0.00 17,382.91 30,000.00 57.9 41-000-61-00-5410 ENGINEERING-CENTRAL ZONE 998.50 31,963.53 30,000.00 106.5 41-000-61-00-5413 PROFESSIONAL SERV-CENTRALZONE 0.00 0.00 0.00 0.0 P26 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 27 DIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES PROFESSIONAL SERVICE 41-000-61-00-5414 CONTRACT D SCADA SYSTEM (7,890.90) 0.00 0.00 0.0 41-000-61-00-5415 USGS GROUNDWATER STUDY 0.00 40,290.00 47,000.00 85.7 41-000-61-00-5416 USGS GROUNDWATER COUNTYWIDE 0.00 1,953.00 13,000.00 15.0 41-000-61-00-5417 USGS GROUNDWATER SHALLOW WATER 19,752.09 51,771.59 65,000.00 79.6 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICE 267,320.34 1,169,403.63 4,273,097.00 27.3 OTHER 41-000-65-00-5421 GIS SYSTEM 0.00 0.00 10,000.00 0.0 41-000-65-00-5800 CONTINGENCY 0.00 1,532.50 85,547.00 1.7 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 1,532.50 95,547.00 1.6 CAPITAL OUTLAY 41-000-75-00-7503 SOUTHWEST WATER MAIN PROJECT 1,133.00 21,096.63 2,600,000.00 0.8 41-000-75-00-7504 NORTH WATER TOWER-CONTRACT A 1,059.50 229,450.37 230,000.00 99.7 41-000-75-00-7507 OVERSIZING - HEARTLAND CIRCLE 0.00 38,877.00 38,877.00 100.0 41-000-75-00-7509 SCADA SYSTEM 13,151.50 13,151.50 350,000.00 3.7 41-000-75-00-7520 WATERMAIN PROJECTS 0.00 0.00 40,000.00 0.0 41-000-75-00-7522 IN TOWN ROAD PROG WATER PROJ 0.00 0.00 215,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 15,344.00 302,575.50 3,473,877.00 8.7 TRANSFERS 41-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 150,000.00 200,000.00 75.0 41-000-99-00-9965 TRANSFER TO DEBT FUND 0.00 222,331.50 296,442.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 372,331.50 496,442.00 75.0 TOTAL EXPENSES: 282,664.34 1,845,843.13 8,338,963.00 22.1 TOTAL FUND REVENUES 126,474.79 3,487,252.88 8,338,963.00 41.8 TOTAL FUND EXPENSES 282,664.34 1,845,843.13 8,338,963.00 22.1 FUND SURPLUS (DEFICIT) (156,189.55) 1,641,409.75 0.00 100.0 P27 )ATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 28 EIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: DEBT SERVICE FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL o ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 42-000-40-00-3999 CARRY OVER 0.00 13,918.00 13,918.00 100.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 13,918.00 13,918.00 100.0 MISCELLANEOUS 42-000-44-00-4440 RECAPTURE-WATER/SEWER 1,440.56 85,239.59 125,882.00 67.7 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 1,440.56 85,239.59 125,882.00 67.7 TRANSFERS 42-000-49-00-4910 TRANSFER FROM POLICE EQUIP CAP 0.00 18,082.50 24,110.00 75.0 42-000-49-00-4925 TRANSFER FROM SANITARY SEWER 0.00 484,659.75 646,213.00 75.0 42-000-49-00-4930 TRANSFER FROM WATER IMPRV FUND 0.00 222,331.50 296,442.00 75.0 42-000-49-00-4940 TRANSFER FROM MUNICIPAL BLDG 0.00 77,942.25 103,923.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 803,016.00 1,070,688.00 75.0 TOTAL REVENUES: 1,440.56 902,173.59 1,210,488.00 74.5 EXPENSES DEBT SERVICE 42-000-66-00-6001 CITY HALL BONDS-PRINCIPAL PMT 0.00 50,000.00 50,000.00 100.0 42-000-66-00-6002 CITY HALL BONDS - INTEREST PMT 0.00 53,922.50 53,923.00 99.9 42-000-66-00-6003 IRBB-BRUELL ST. INTEREST PMTS 0.00 85,435.00 85,435.00 100.0 42-000-66-00-6004 IRBB-BRUELL ST. PRINCIPAL PYMT 0.00 80,000.00 80,000.00 100.0 42-000-66-00-6005 NORTH H2O TOWER INTEREST PYMT 0.00 1,912.25 1,912.00 100.0 42-000-66-00-6006 NORTH H2O TOWER PRINCIPAL PYMT 0.00 23,087.75 23,088.00 99.9 42-000-66-00-6007 4.8 MILLION DEBT CERT INT PYMT 0.00 233,150.00 233,150.00 100.0 42-000-66-00-6008 COUNTRYSIDE ALT REV PRINC PYMT 0.00 120,000.00 120,000.00 100.0 42-000-66-00-6009 COUNTRYSIDE ALT REV INT PYMT 0.00 120,637.50 120,638.00 99.9 42-000-66-00-6010 COMED/HYDRAULIC INTEREST PYMT 0.00 43,216.50 43,128.00 100.2 42-000-66-00-6011 COM ED/HYDRAUL DEBT CERT PRINC 0.00 135,000.00 135,000.00 100.0 42-000-66-00-6050 LOAN PAYMENT-SANITARY SIPHON 0.00 38,979.98 38,980.00 99.9 42-000-66-00-6054 LOAN PAYMENT-POLICE SQUAD CAR 0.00 24,037.15 24,110.00 99.6 P28 )ATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 29 LIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 CD: GL470002.WOW FUND: DEBT SERVICE FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES DEBT SERVICE 42-000-66-00-6055 LOAN PAYMENT-SSES IEPA L171153 53,525.35 107,050.70 107,051.00 99.9 42-000-66-00-6070 $650K ROAD IMPROV PROG INT 0.00 14,272.50 14,273.00 99.9 42-000-66-00-6071 $650K ROAD IMPROV PROG PRINC 0.00 50,000.00 50,000.00 100.0 42-000-66-00-6072 $2 MIL ALT REV B.2&3 INT PYMT 0.00 29,799.58 29,800.00 99.9 --------------------------------------------------------------------------------- TOTAL DEBT SERVICE 53,525.35 1,210,501.41 1,210,488.00 100.0 TOTAL FUND REVENUES 1,440.56 902,173.59 1,210,488.00 74.5 TOTAL FUND EXPENSES 53,525.35 1,210,501.41 1,210,488.00 100.0 FUND SURPLUS (DEFICIT) (52,084.79) (308,327.82) 0.00 100.0 P29 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 30 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 51-000-40-00-3999 CARRY OVER BALANCE 0.00 441,462.00 441,642.00 99.9 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 441,462.00 441,642.00 99.9 CHARGES FOR SERVICES 51-000-42-00-4240 BULK WATER SALES 150.00 9,572.97 15,000.00 63.8 51-000-42-00-4241 WATER SALES 176,987.65 1,050,221.80 1,000,000.00 105.0 51-000-42-00-4242 WATER METER SALES 19,025.00 234,640.00 250,000.00 93.8 51-000-42-00-4243 LEASE REVENUE - H2O TOWER 1,909.62 18,595.62 24,000.00 77.4 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 198,072.27 1,313,030.39 1,289,000.00 101.8 MISCELLANEOUS 51-000-44-00-4490 MISCELLANEOUS INCOME 0.00 290.00 2,000.00 14.5 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 0.00 290.00 2,000.00 14.5 INTEREST 51-000-46-00-4600 INVESTMENT INCOME 2,942.23 17,309.42 15,000.00 115.3 --------------------------------------------------------------------------------- TOTAL INTEREST 2,942.23 17,309.42 15,000.00 115.3 TOTAL REVENUES: 201,014.50 1,772,091.81 1,747,642.00 101.3 EXPENSES PERSONNEL 51-000-50-00-5107 SALARIES - EMPLOYEE 20,877.48 210,453.16 264,873.00 79.4 51-000-50-00-5136 SALARIES-PART TIME 0.00 5,216.00 8,200.00 63.6 51-000-50-00-5137 SALARIES - OVERTIME 2,051.51 33,090.16 40,000.00 82.7 --------------------------------------------------------------------------------- TOTAL PERSONNEL 22,928.99 248,759.32 313,073.00 79.4 PROFESSIONAL SERVICES 51-000-61-00-5300 LEGAL SERVICES 0.00 337.50 2,000.00 16.8 P30 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 31 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES PROFESSIONAL SERVICES 51-000-61-00-5303 JULIE SERVICE 1,348.50 6,938.25 6,800.00 102.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 1,348.50 7,275.75 8,800.00 82.6 CONTRACTURAL SERVICES 51-000-62-00-5401 CONTRACUAL SERVICES 0.00 2,950.62 4,500.00 65.5 51-000-62-00-5407 TREATMENT FACILITIES O&M 4,016.56 60,941.19 110,000.00 55.4 51-000-62-00-5408 MAINTENANCE-EQUIPMENT 32.65 1,606.34 9,000.00 17.8 51-000-62-00-5409 MAINTENANCE - VEHICLES 0.00 387.79 7,000.00 5.5 51-000-62-00-5411 MAINTENANCE-COMPUTERS 0.00 0.00 1,000.00 0.0 51-000-62-00-5413 MAINTENANCE-CONTROL SYSTEM 0.00 500.37 10,000.00 5.0 51-000-62-00-5421 WEARING APPAREL 0.00 1,952.12 5,500.00 35.4 51-000-62-00-5422 WATER TOWER PAINTING 0.00 219,870.00 220,000.00 99.9 51-000-62-00-5434 RENTAL - EQUIPMENT 0.00 0.00 1,000.00 0.0 51-000-62-00-5435 ELECTRICITY 17,917.52 95,533.00 130,000.00 73.4 51-000-62-00-5436 TELEPHONE 1,324.72 12,096.23 20,000.00 60.4 51-000-62-00-5438 CELLULAR TELEPHONE 329.77 3,001.29 5,700.00 52.6 --------------------------------------------------------------------------------- TOTAL CONTRACTURAL SERVICES 23,621.22 398,838.95 523,700.00 76.1 PROFESSIONAL DEVELOPMENT 51-000-64-00-5600 DUES 143.00 440.00 1,000.00 44.0 51-000-64-00-5603 SUBSCRIPTIONS 0.00 42.30 250.00 16.9 51-000-64-00-5604 TRAINING & CONFERENCES 0.00 1,977.34 3,000.00 65.9 51-000-64-00-5605 TRAVEL EXPENSES 0.00 803.24 3,000.00 26.7 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 143.00 3,262.88 7,250.00 45.0 OPERATIONS 51-000-65-00-5800 CONTINGENCIES 0.00 0.00 30,000.00 0.0 51-000-65-00-5804 OPERATING SUPPLIES 1,497.72 33,876.99 46,200.00 73.3 51-000-65-00-5808 POSTAGE & SHIPPING 1,273.86 10,625.74 13,500.00 78.7 51-000-65-00-5809 PRINTING & COPYING 229.63 7,417.30 8,250.00 89.9 51-000-65-00-5810 PUBLISHING & ADVERTISING 0.00 150.00 1,000.00 15.0 51-000-65-00-5812 GASOLINE 114.91 14,743.94 20,000.00 73.7 P31 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 32 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES OPERATIONS 51-000-65-00-5815 HAND TOOLS 0.00 19.94 1,000.00 1.9 51-000-65-00-5817 GRAVEL 0.00 2,255.92 5,000.00 45.1 51-000-65-00-5820 CHEMICALS 3,161.46 14,085.07 30,000.00 46.9 51-000-65-00-5821 CATHODIC PROTECTION 0.00 0.00 6,250.00 0.0 51-000-65-00-5822 WATER SAMPLES 970.00 11,646.00 12,000.00 97.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS 7,247.58 94,820.90 173,200.00 54.7 RETIREMENT 51-000-72-00-6500 IMRF PARTICIPANTS 1,811.39 19,718.53 24,354.00 80.9 51-000-72-00-6501 SOCIAL SECURITY & MEDICARE 1,836.01 19,442.76 23,515.00 82.6 --------------------------------------------------------------------------------- TOTAL RETIREMENT 3,647.40 39,161.29 47,869.00 81.8 CAPITAL OUTLAY 51-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 1,912.31 2,180.35 4,000.00 54.5 51-000-75-00-7004 SAFETY EQUIPMENT 0.00 2,325.01 3,000.00 77.5 51-000-75-00-7506 METER READERS 1,138.75 6,080.38 10,900.00 55.7 51-000-75-00-7507 HYDRANT REPLACEMENT 0.00 1,976.00 10,000.00 19.7 51-000-75-00-7508 METERS & PARTS 53,582.50 184,917.05 262,500.00 70.4 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 56,633.56 197,478.79 290,400.00 68.0 OTHER 51-000-78-00-9005 REFUND 0.00 0.00 1,500.00 0.0 51-000-78-00-9008 RESERVE-H2O TOWER MAINTENANCE 0.00 0.00 43,200.00 0.0 51-000-78-00-9009 RESERVE 0.00 0.00 88,650.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 133,350.00 0.0 TRANSFERS 51-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 150,000.00 200,000.00 75.0 51-000-99-00-9950 TRANSFER TO PW EQUIP CAPITAL 0.00 37,500.00 50,000.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 187,500.00 250,000.00 75.0 P32 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 33 LIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 CD: GL470002.WOW FUND: WATER OPERATIONS FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED -----------------------------------------------------------------=------------------------------------------------------------------ TOTAL EXPENSES: 115,570.25 1,177,097.88 1,747,642.00 67.3 DOTAL FUND REVENUES 201,014.50 1,772,091.81 1,747,642.00 101.3 DOTAL FUND EXPENSES 115,570.25 1,177,097.88 1,747,642.00 67.3 FUND SURPLUS (DEFICIT) 85,444.25 594,993.93 0.00 100.0 P33 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 34 PIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: SEWER MAINTENANCE FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 52-000-40-00-3999 CARRY OVER/FUND BALANCE 0.00 327,526.00 327,526.00 100.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 327,526.00 327,526.00 100.0 CHARGES FOR SERVICES 52-000-42-00-4240 LIFT STATION INCOME 0.00 0.00 8,000.00 0.0 52-000-42-00-4250 SEWER MAINTENANCE FEES 82,771.44 392,660.63 450,000.00 87.2 52-000-42-00-4251 SEWER CONNNECTION FEES 12,400.00 144,800.00 165,000.00 87.7 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 95,171.44 537,460.63 623,000.00 86.2 INTEREST 52-000-46-00-4600 INVESTMENT INCOME 2,947.24 17,384.39 15,000.00 115.8 --------------------------------------------------------------------------------- TOTAL INTEREST 2,947.24 17,384.39 15,000.00 115.8 TOTAL REVENUES: 98,118.68 882,371.02 965,526.00 91.3 EXPENSES PERSONNEL SERVICES 52-000-50-00-5108 SALARIES-REGULAR 8,435.95 91,172.35 125,245.00 72.7 52-000-50-00-5136 PART TIME 0.00 2,299.50 2,500.00 91.9 52-000-50-00-5137 SALARIES-OVERTIME 0.00 3,060.24 12,000.00 25.5 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 8,435.95 96,532.09 139,745.00 69.0 CONTRACTUAL SERVICES 52-000-62-00-5401 CONTRACTUAL SERVICES 0.00 3,445.33 5,000.00 68.9 52-000-62-00-5408 MAINTENANCE-EQUIPMENT 1,867.84 3,969.38 5,000.00 79.3 52-000-62-00-5409 MAINTENANCE-VEHICLES 20.00 60.00 3,000.00 2.0 52-000-62-00-5419 MAINTENANCE-SANITARY SEWER 244.71 8,275.51 25,000.00 33.1 52-000-62-00-5421 WEARING APPAREL 860.33 2,913.04 4,500.00 64.7 52-000-62-00-5422 LIFT STATION MAINTENANCE 22.05 19,671.86 30,000.00 65.5 52-000-62-00-5434 RENTAL - EQUIPMENT 0.00 0.00 1,000.00 0.0 P34 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 35 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: SEWER MAINTENANCE FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES CONTRACTUAL SERVICES 52-000-62-00-5435 ELECTRICITY 10,509.93 16,346.91 13,500.00 121.0 52-000-62-00-5438 CELLULAR TELEPHONE 171.50 1,553.51 2,500.00 62.1 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 13,696.36 56,235.54 89,500.00 62.8 PROFESSIONAL DEVELOPMENT 52-000-64-00-5604 TRAINING & CONFERENCES 50.00 231.32 1,500.00 15.4 52-000-64-00-5605 TRAVEL/MEALS/LODGING 0.00 849.31 1,500.00 56.6 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 50.00 1,080.63 3,000.00 36.0 OPERATIONS 52-000-65-00-5800 CONTINGENCIES 0.00 0.00 9,300.00 0.0 52-000-65-00-5802 OFFICE SUPPLIES 23.46 1,769.78 2,200.00 80.4 52-000-65-00-5804 OPERATING SUPPLIES 0.00 0.00 0.00 0.0 52-000-65-00-5805 SHOP SUPPLIES 135.19 785.32 2,500.00 31.4 52-000-65-00-5812 GASOLINE 410.24 13,654.94 18,000.00 75.8 52-000-65-00-5815 HAND TOOLS 0.00 109.40 1,000.00 10.9 52-000-65-00-5817 GRAVEL 0.00 1,216.28 2,000.00 60.8 52-000-65-00-5823 SEWER CHEMICALS 460.45 1,829.32 3,000.00 60.9 --------------------------------------------------------------------------------- TOTAL OPERATIONS 1,029.34 19,365.04 38,000.00 50.9 RETIREMENT 52-000-72-00-6500 IMRF PARTICIPANTS 666.45 7,655.52 12,475.00 61.3 52-000-72-00-6501 SOCIAL SECURITY & MEDICARE 643.90 7,374.25 12,106.00 60.9 --------------------------------------------------------------------------------- TOTAL RETIREMENT 1,310.35 15,029.77 24,581.00 61.1 CAPITAL OUTLAY 52-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 155.58 250.52 2,500.00 10.0 52-000-75-00-7003 OFFICE EQUIPMENT 289.71 702.88 6,000.00 11.7 52-000-75-00-7004 SAFETY EQUIPMENT 281.80 892.44 2,000.00 44.6 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 727.09 1,845.84 10,500.00 17.5 P35 )ATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 36 LIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 CD: GL470002.WOW FUND: SEWER MAINTENANCE FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ OTHER 52-000-78-00-9005 MERIT 0.00 0.00 0.00 0.0 52-000-78-00-9009 RESERVE 0.00 9,800.00 560,200.00 1.7 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 9,800.00 560,200.00 1.7 TRANSFERS 52-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 52,500.00 70,000.00 75.0 52-000-99-00-9950 TRANSFER TO PW EQUIP CAPITAL 0.00 22,500.00 30,000.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 75,000.00 100,000.00 75.0 TOTAL EXPENSES: 25,249.09 274,888.91 965,526.00 28.4 TOTAL FUND REVENUES 98,118.68 882,371.02 965,526.00 91.3 TOTAL FUND EXPENSES 25,249.09 274,888.91 965,526.00 28.4 FUND SURPLUS (DEFICIT) 72,869.59 607,482.11 0.00 100.0 P36 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 37 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LAND CASH FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 72-000-40-00-3999 CARRY OVER/STARTING BALANCE 0.00 442,437.00 442,437.00 100.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 442,437.00 442,437.00 100.0 CONTRIBUTIONS 72-000-47-00-4700 OSLAD GRANT 0.00 74,000.00 202,000.00 36.6 72-000-47-00-4701 GREENBRIAR-LAND CASH 0.00 1,071.00 15,498.00 6.9 72-000-47-00-4703 PRAIRIE GARDEN-LAND CASH 0.00 9,450.00 9,450.00 100.0 72-000-47-00-4705 COUNTRY HILLS-LAND CASH 0.00 6,921.00 15,380.00 45.0 72-000-47-00-4707 FOX HIGHLANDS-LAND CASH 0.00 1,406.00 1,406.00 100.0 72-000-47-00-4709 SUNFLOWER-LAND CASH 0.00 1,805.00 9,025.00 20.0 72-000-47-00-4712 RIVER'S EDGE-LAND CASH 1,342.00 12,078.00 17,446.00 69.2 72-000-47-00-4716 WHITE OAK UNIT 3&4-LAND CASH 0.00 1,406.00 1,406.00 100.0 72-000-47-00-4717 KYLN'S CROSSING-LAND CASH 0.00 0.00 7,065.00 0.0 72-000-47-00-4719 WILDWOOD-LAND CASH 0.00 918.00 0.00 100.0 72-000-47-00-4722 KYLN'S RIDGE-LAND CASH 0.00 4,155.00 12,465.00 33.3 72-000-47-00-4723 HEARTLAND CIRCLE-LAND CASH 2,000.00 34,000.00 62,000.00 54.8 72-000-47-00-4725 WINDETTE RIDGE-LAND CASH 0.00 0.00 50,000.00 0.0 72-000-47-00-4727 GRAND RESERVE-LAND CASH 0.00 5,166.53 10,000.00 51.6 72-000-47-00-4731 MONTALBANO HOMES LAND CASH 0.00 0.00 5,310.00" 0.0 72-000-47-00-4732 RAINTREE VILLAGE LAND CASH 0.00 29,000.00 29,000.00 100.0 72-000-47-00-4734 WHISPERING MEADOWS (K. HILL) 1,127.78 32,141.73 43,984.00 73.0 72-000-47-00-4736 CORNERSTONE 0.00 0.00 41,340.00 0.0 72-000-47-00-4737 CALEDONIA 0.00 0.00 7,672.00 0.0 72-000-47-00-4738 AUTUMN CREEK 3,353.35 6,737.45 16,921.00 39.8 72-000-47-00-4739 WYNSTONE TOWNHOMES 0.00 0.00 45,402.00 0.0 72-000-47-00-4740 VILLAS AT THE PRESERVE 3,468.52 3,468.52 72,839.00 4.7 --------------------------------------------------------------------------------- TOTAL CONTRIBUTIONS 11,291.65 223,724.23 675,609.00 33.1 TRANSFERS 72-000-49-00-4902 TRANSFER FROM LAND ACQUISITION 0.00 0.00 150,000.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 150,000.00 0.0 P37 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 38 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LAND CASH FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TOTAL REVENUES: 11,291.65 666,161.23 1,268,046.00 52.5 EXPENSES CAPITAL OUTLAY 72-000-75-00-7300 GREENBRIAR 0.00 3,000.00 20,000.00 15.0 72-000-75-00-7304 SUNFLOWER 0.00 71,697.27 145,000.00 49.4 72-000-75-00-7307 RIVERS EDGE 0.00 0.00 0.00 0.0 72-000-75-00-7308 RIVERS EDGE PARK #2 0.00 26,901.22 50,000.00 53.8 72-000-75-00-7311 CANNONBALL ESTATES/KYLIN 0.00 201,949.61 229,000.00 88.1 72-000-75-00-7317 HEARTLAND CIRCLE 0.00 0.00 6,000.00 0.0 72-000-75-00-7324 TOWN SQUARE 0.00 0.00 10,000.00 0.0 72-000-75-00-7327 GRANDE RESERVE PARK DEV. 0.00 9,693.74 10,000.00 96.9 72-000-75-00-7328 PRAIRIE MEADOWS (MENARDS RES) 0.00 0.00 70,000.00 0.0 72-000-75-00-7329 ELSIE LOUISE GILBERT PARK 0.00 75,946.12 76,000.00 99.9 72-000-75-00-7330 WHISPERING MEADOWS (K. HILL) 0.00 19,811.37 20,000.00 99.0 72-000-75-00-7331 WINDETT RIDGE 0.00 0.00 50,000.00 0.0 72-000-75-00-7700 PARK MAINTENANCE FACILITY 0.00 0.00 252,046.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 408,999.33 938,046.00 43.6 OTHER 72-000-78-00-9009 RESERVE 0.00 329,736.22 330,000.00 99.9 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 329,736.22 330,000.00 99.9 TOTAL EXPENSES: 0.00 738,735.55 1,268,046.00 58.2 TOTAL FUND REVENUES 11,291.65 666,161.23 1,268,046.00 52.5 TOTAL FUND EXPENSES 0.00 738,735.55 1,268,046.00 58.2 FUND SURPLUS (DEFICIT) 11,291.65 (72,574.32) 0.00 100.0 P38 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 39 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LAND ACQUISITION FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 73-000-40-00-3999 CARRY OVER BALANCE 0.00, 213,618.00 213,618.00 100.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 213,618.00 213,618.00 100.0 EXPENSES OTHER 73-000-65-00-5800 CONTINGENCY 0.00 0.00 63,618.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 63,618.00 0.0 TRANSFERS 73-000-99-00-9935 TRANSFER TO LAND CASH 0.00 0.00 150,000.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 150,000.00 0.0 TOTAL EXPENSES: 0.00 0.00 213,618.00 0.0 TOTAL FUND REVENUES 0.00 213,618.00 213,618.00 100.0 TOTAL FUND EXPENSES 0.00 0.00 213,618.00 0.0 FUND SURPLUS (DEFICIT) 0.00 213,618.00 0.00 100.0 P39 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 40 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 79-000-40-00-3999 CARRY OVER BALANCE 0.00 142,356.00 142,356.00 100.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 142,356.00 142,356.00 100.0 CHARGES FOR SERVICES 79-000-42-00-4270 FEES FOR PROGRAMS 15,981.60 211,183.94 190,700.00 110.7 79-000-42-00-4280 CONCESSIONS 0.00 13,884.98 13,812.00 100.5 79-000-42-00-4281 BEECHER BLDG/SHELTER DEPOSITS 770.00 2,770.00 4,500.00 61.5 79-000-42-00-4282 FARMERS MARKET 0.00 0.00 0.00 0.0 79-000-42-00-4285 VENDING MACHINE INCOME 0.00 459.42 650.00 70.6 79-000-42-00-4286 RENTAL INCOME 45.00 1,730.00 4,000.00 43.2 79-000-42-00-4287 RENTAL INCOME - SHELTERS 0.00 310.00 1,000.00 31.0 79-000-42-00-4288 GOLF OUTING REVENUE 0.00 40,160.00 40,160.00 100.0 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 16,796.60 270,498.34 254,822.00 106.1 MISCELLANEOUS 79-000-44-00-4400 DONATIONS 2,160.00 13,485.00 15,000.00 89.9 79-000-44-00-4404 TREE DONATIONS 0.00 900.00 900.00 100.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 2,160.00 14,385.00 15,900.00 90.4 INTERGOVERNMENTAL 79-000-45-00-4550 YOUTH SERVICES GRANT 0.00 2,000.00 2,000.00 100.0 --------------------------------------------------------------------------------- TOTAL INTERGOVERNMENTAL 0.00 2,000.00 2,000.00 100.0 INTEREST 79-000-46-00-4600 INVESTMENT INCOME 1,141.40 8,853.79 8,500.00 104.1 ------------------------=-------------------------------------------------------- TOTAL INTEREST 1,141.40 8,853.79 8,500.00 104.1 TRANSFERS 79-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 696,425.22 755,908.00 92.1 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 696,425.22 755,908.00 92.1 P4O DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 41 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TOTAL REVENUES: 20,098.00 1,134,518.35 1,179,486.00 96.1 PARKS EXPENSES PERSONNAL SERVICES 79-610-50-00-5107 SALARIES-EMPLOYEES 22,291.52 240,804.98 300,000.00 80.2 79-610-50-00-5136 SALARIES - PART-TIME 0.00 38,527.52 45,000.00 85.6 79-610-50-00-5137 SALARIES - OVERTIME 0.00 1,930.98 8,000.00 24.1 --------------------------------------------------------------------------------- TOTAL PERSONNAL SERVICES 22,291.52 281,263.48 353,000.00 79.6 CONTRACTUAL SERVICES 79-610-62-00-5405 PARK CONTRACTUAL 250.00 11,435.00 15,000.00 76.2 79-610-62-00-5408 MAINTENANCE-EQUIPMENT 154.79 7,019.18 9,000.00 77.9 79-610-62-00-5417 MAINTENANCE-PARKS 66.72 20,232.47 32,000.00 63.2 79-610-62-00-5421 WEARING APPAREL 430.06 2,253.56 8,000.00 28.1 79-610-62-00-5434 RENTAL-EQUIPMENT 0.00 309.49 1,700.00 18.2 79-610-62-00-5438 CELLULAR TELEPHONE 327.00 2,629.20 5,750.00 45.7 79-610-62-00-5440 LAND DEVELOPER 0.00 553.50 10,000.00 5.5 79-610-62-00-5445 LEGAL EXPENSES 375.00 1,837.50 10,000.00 18.3 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 1,603.57 46,269.90 91,450.00 50.5 PROFESSIONAL DEVELOPMENT 79-610-64-00-5602 PROFESSIONAL GROWTH/SUBSCRPT 573.60 3,443.22 4,500.00 76.5 79-610-64-00-5605 TRAVEL EXPENSE 65.14 2,779.76 3,000.00 92.6 79-610-64-00-5612 CONTINUING EDUCATION 120.00 2,352.00 4,200.00 56.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 758.74 8,574.98 11,700.00 73.2 OPERATIONS 79-610-65-00-5802 OFFICE SUPPLIES 0.00 604.34 3,000.00 20.1 79-610-65-00-5804 OPERATING SUPPLIES 212.54 11,092.30 25,000.00 44.3 79-610-65-00-5812 GASOLINE 0.00 73.75 3,500.00 2.1 79-610-65-00-5815 HAND TOOLS 160.53 1,164.04 3,000.00 38.8 79-610-65-00-5824 CHRISTMAS DECORATIONS 0.00 6,359.19 7,000.00 90.8 P41 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 42 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PARKS EXPENSES OPERATIONS 79-610-65-00-5825 PUBLIC DECORATION 0.00 589.91 3,000.00 19.6 --------------------------------------------------------------------------------- TOTAL OPERATIONS 373.07 19,883.53 44,500.00 44.6 RETIREMENT 79-610-72-00-6500 IMRF PARTICIPANTS 1,761.03 18,997.82 25,070.00 75.7 79-610-72-00-6501 SOCIAL SECURITY/MEDICARE 1,690.01 20,701.54 27,005.00 76.6 --------------------------------------------------------------------------------- TOTAL RETIREMENT 3,451.04 39,699.36 52,075.00 76.2 CAPITAL OUTLAY 79-610-75-00-7003 OFFICE EQUIPMENT 1,398.99 1,423.98 27,000.00 5.2 79-610-75-00-7701 FLOWERS/TREES 0.00 2,361.86 6,500.00 36.3 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 1,398.99 3,785.84 33,500.00 11.3 OTHER 79-610-78-00-9005 MERIT 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 0.00 0.0 TOTAL EXPENSES: PARKS 29,876.93 399,477.09 586,225.00 68.1 RECREATION EXPENSES PERSONNEL SERVICES 79-650-50-00-5107 EMPLOYEE SALARIES 19,837.21 208,032.72 255,600.00 81.3 79-650-50-00-5108 CONCESSION STAFF 0.00 3,280.50 3,600.00 91.1 79-650-50-00-5150 SALARIES-INSTRUCTOR CONTRACTUA 12,180.76 96,103.27 98,000.00 98.0 79-650-50-00-5155 SALARIES-RECORDING SECRETARY 217.25 1,400.25 5,000.00 28.0 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 32,235.22 308,816.74 362,200.00 85.2 P42 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 43 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ RECREATION CONTRACTUAL SERVICES 79-650-62-00-5408 MAINTENANCE SUPPLIES 294.44 3,199.21 8,000.00 39.9 79-650-62-00-5409 MAINTENANCE-VEHICLES 30.93 160.05 1,200.00 13.3 79-650-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 440.84 3,992.95 5,500.00 72.5 79-650-62-00-5426 YOUTH SERVICES GRANT EXPENSES 0.00 539.42 2,000.00 26.9 79-650-62-00-5437 TELEPHONE/INTERNET 30.97 365.59 1,400.00 26.1 79-650-62-00-5438 CELLULAR TELEPHONE 356.16 3,021.73 4,500.00 67.1 79-650-62-00-5445 PORTABLE TOILETS 0.00 3,273.65 4,500.00 72.7 79-650-62-00-5603 PUBLISHING/ADVERTISING 4,631.84 23,425.91 25,200.00 92.9 79-650-62-00-5605 BOOKS/PUBLICATIONS 0.00 359.03, 750.00 47.8 79-650-62-00-5606 BEECHER DEPOSIT REFUND 950.00 4,400.00 4,000.00 110.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 6,735.18 42,737.54 57,050.00 74.9 PROFESSIONAL DEVELOPMENT 79-650-64-00-5600 DUES 35.00 737.00 2,700.00 27.2 79-650-64-00-5602 PROFESSIONAL GROWTH/SUBSCRIPT 188.42 3,981.42 7,500.00 53.0 79-650-64-00-5605 TRAVEL EXPENSE 356.70 1,938.48 2,500.00 77.5 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 580.12 6,656.90 12,700.00 52.4 OPERATIONS 79-650-65-00-5802 OFFICE SUPPLIES 1,568.48 5,069.10 6,600.00 76.8 79-650-65-00-5803 PROGRAM EXPENSES 1,447.99 37,953.02 39,185.00 96.8 79-650-65-00-5804 OPERATING SUPPLIES 42.35 3,213.76 4,000.00 80.3 79-650-65-00-5805 RECREATION EQUIPMENT 519.98 1,399.11 3,500.00 39.9 79-650-65-00-5808 POSTAGE & SHIPPING 1,018.41 5,804.85 6,500.00 89.3 79-650-65-00-5812 GASOLINE 206.29 850.45 1,600.00 53.1 79-650-65-00-5826 MILEAGE 86.33 702.91 1,200.00 58.5 79-650-65-00-5827 GOLF OUTING EXPENSES 0.00 21,944.65 21,945.00 99.9 79-650-65-00-5828 CONCESSIONS 0.00 9,734.06 9,734.00 100.0 79-650-65-00-5840 SCHOLARSHIPS 0.00 1,570.00 2,000.00 78.5 79-650-65-00-5841 PROGRAM REFUND 787.60 10,566.90 13,000.00 81.2 --------------------------------------------------------------------------------- TOTAL OPERATIONS 5,677.43 98,808.81 109,264.00 90.4 RETIREMENT P43 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 44 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL o ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ RECREATION EXPENSES RETIREMENT 79-650-72-00-6500 IMRF PARTICIPANTS 1,683.58 18,294.25 20,806.00 87.9 79-650-72-00-6501 SOCIAL SECURITY/MEDICARE 2,186.69 21,023.83 23,241.00 90.4 --------------------------------------------------------------------------------- TOTAL RETIREMENT 3,870.27 39,318.08 44,047.00 89.2 CAPITAL OUTLAY 79-650-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 6,754.63 8,000.00 84.4 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 6,754.63 8,000.00 84.4 OTHER 79-650-78-00-9005 MERIT 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 0.00 0.0 TOTAL EXPENSES: RECREATION 49,098.22 503,092.70 593,261.00 84.8 TOTAL FUND REVENUES 20,098.00 1,134,518.35 1,179,486.00 96.1 TOTAL FUND EXPENSES 78,975.15 902,569.79 1,179,486.00 76.5 FUND SURPLUS (DEFICIT) (58,877.15) 231,948.56 0.00 100.0 P44 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 45 TIME: 10:58:38 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LIBRARY FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL o ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES TAXES 82-000-40-00-3996 CARRY OVER - BOOK DEV FEES 0.00 77,910.00 77,910.00 100.0 82-000-40-00-3997 CARRY OVER - BLDG DEV FEES 0.00 96,378.00 96,378.00 100.0 82-000-40-00-3998 CARRY OVER-MEMORIALS 0.00 4,150.00 4,150.00 100.0 82-000-40-00-3999 CARRY OVER BALANCE 0.00 231,590.00 231,590.00 100.0 82-000-40-00-4000 REAL ESTATE TAXES 0.00 356,387.49 370,500.00 96.1 82-000-40-00-4010 PERSONAL PROPERTY TAX 0.00 2,692.36 2,500.00 107.6 82-000-40-00-4015 TRANSFER FROM GENERAL FUND 2,625.00 26,250.00 28,000.00 93.7 --------------------------------------------------------------------------------- TOTAL TAXES 2,625.00 795,357.85 811,028.00 98.0 CHARGES FOR SERVICES 82-000-42-00-4211 DEVELOPMENT FEES - BUILDING 0.00 60,550.00 95,000.00 63.7 82-000-42-00-4215 DEVELOPMENT FEES-BOOKS 0.00 60,550.00 95,000.00 63.7 82-000-42-00-4260 COPY FEES 77.10 1,089.35 900.00 121.0 82-000-42-00-4261 LIBRARY SUBSCRIPTION CARDS 900.00 8,750.00 8,000.00 109.3 82-000-42-00-4286 RENTAL INCOME 113.00 1,061.00 1,000.00 106.1 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 1,090.10 132,000.35 199,900.00 66.0 FINES 82-000-43-00-4330 LIBRARY FINES 195.20 3,242.59 3,000.00 108.0 --------------------------------------------------------------------------------- TOTAL FINES 195.20 3,242.59 3,000.00 108.0 MISCELLANEOUS 82-000-44-00-4432 SALE OF BOOKS 25.70 414.99 500.00 82.9 82-000-44-00-4450 MEMORIALS 30.00 1,447.00 5,000.00 28.9 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 55.70 1,861.99 5,500.00 33.8 INTERGOVERNMENTAL 82-000-45-00-4550 GRANTS 0.00 0.00 1,000.00 0.0 82-000-45-00-4560 LIBRARY PER CAPITA GRANT 0.00 0.00 7,700.00 0.0 --------------------------------------------------------------------------------- TOTAL INTERGOVERNMENTAL 0.00 0.00 8,700.00 0.0 P45 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 46 TIME: 10:58:39 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LIBRARY FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ INTEREST 82-000-46-00-4600 INVESTMENT INCOME 1,696.08 11,853.73 1,500.00 790.2 82-000-46-00-4601 INVESTMENT INCOME-BLDG 14,934.74 134,431.90 141,250.00 95.1 --------------------------------------------------------------------------------- TOTAL INTEREST 16,630.82 146,285.63 142,750.00 102.4 OTHER OPERATING RECEIPTS 82-000-48-00-4801 LIBRARY EXPAN BOND PROCEEDS 0.00 7,263,880.86 7,263,881.00 99.9 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING RECEIPTS 0.00 7,263,880.86 7,263,881.00 99.9 TOTAL REVENUES: 20,596.82 8,342,629.27 8,434,759.00 98.9 EXPENSES PERSONNEL SERVICES 82-000-50-00-5107 SALARIES-EMPLOYEES 13,791.93 136,971.97 300,000.00 45.6 82-000-50-00-5203 GROUP HEALTH INSURANCE 3,331.13 26,684.53 45,000.00 59.2 82-000-50-00-5204 GROUP LIFE INSURANCE 62.01 460.38 1,500.00 30.6 82-000-50-00-5205 DENTAL & VISION ASSISTANCE 254.12 2,251.56 4,000.00 56.2 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 17,439.19 166,368.44 350,500.00 47.4 PROFESSIONAL SERVICES 82-000-61-00-5300 LEGAL SERVICES 0.00 0.00 0.00 0.0 82-000-61-00-5322 BONDING 0.00 1,014.00 2,000.00 50.7 82-000-61-00-5323 ATTORNEY 0.00 862.50 3,000.00 28.7 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 0.00 1,876.50 5,000.00 37.5 CONTRACTUAL SERVICES 82-000-62-00-5401 CONTRACT SERVICES 57.00 575.83 4,000.00 14.3 82-000-62-00-5407 MAINTENANCE-BLDG/JANITORIAL 300.00 2,700.00 5,000.00 54.0 82-000-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 380.00 2,991.77 3,000.00 99.7 82-000-62-00-5412 MAINTENANCE-PHOTOCOPIER 50.67 352.53 500.00 70.5 82-000-62-00-5435 ELECTRICITY 393.60 845.57 2,500.00 33.8 82-000-62-00-5436 TELEPHONE 225.43 946.38 1,700.00 55.6 P46 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 47 TIME: 10:58:39 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LIBRARY FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ - --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 1,406.70 8,412.08 16,700.00 50.3 PROFESSIONAL DEVELOPMENT 82-000-64-00-5603 SUBSCRIPTIONS 495.00 2,694.34 4,000.00 67.3 82-000-64-00-5604 TRAINING & CONFERENCES 0.00 10.00 1,500.00 0.6 82-000-64-00-5607 PUBLIC RELATIONS 0.00 121.23 1,000.00 12.1 82-000-64-00-5616 EMPLOYEE RECOGNITION 0.00 444.51 2,000.00 22.2 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 495.00 3,270.08 8,500.00 38.4 OPERATIONS 82-000-65-00-5800 CONTINGENCIES 402.60 1,145.04 19,090.00 . 5.9 82-000-65-00-5802 OFFICE SUPPLIES 2,556.80 2,970.33 3,000.00 99.0 82-000-65-00-5806 LIBRARY SUPPLIES 0.00 3,052.46 3,000.00 101.7 82-000-65-00-5807 CUSTODIAL SUPPLIES 770.72 2,397.72 8,000.00 29.9 82-000-65-00-5808 POSTAGE & SHIPPING 243.00 687.00 1,000.00 68.7 82-000-65-00-5810 PUBLISHING & ADVERTISING 0.00 264.44 1,000.00 26.4 82-000-65-00-5826 MILEAGE 0.00 354.15 1,000.00 35.4 82-000-65-00-5832 VIDEOS 268.61 1,636.76 5,000.00 32.7 82-000-65-00-5833 ALARM MONITORING 0.00 785.75 1,000.00 78.5 82-000-65-00-5834 LIBRARY PROGRAMMING 562.27 4,034.58 9,500.00 42.4 82-000-65-00-5835 LIBRARY BOARD EXPENSES 0.00 74.50 500.00 14.9 82-000-65-00-5836 BOOKS-ADULT 2,904.53 6,903.57 9,000.00 76.7 82-000-65-00-5837 BOOKS-JUVENILE 0.00 5,540.16 9,000.00 61.5 82-000-65-00-5838 BOOKS-AUDIO 0.00 1,321.61 9,000.00 14.6 82-000-65-00-5839 BOOKS-REFERENCE 0.00 7,569.59 9,000.00 84.1 82-000-65-00-5840 BOOKS-DEVELOPMENT FEE 375.43 22,915.20 172,910.00 13.2 82-000-65-00-5841 MEMORIALS/GIFTS 0.00 2,092.61 9,150.00 22.8 82-000-65-00-5842 BLDG-DEVELOPMENT FEES (1,214,510.52) 45,331.85 191,378.00 23.6 82-000-65-00-5843 GRANT EXPENSE 0.00 0.00 1,000.00 0.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS (1,206,426.56) 109,077.32 462,528.00 23.5 RETIREMENT 82-000-72-00-6500 IMRF PARTICPANTS 589.70 6,219.90 10,000.00 62.1 82-000-72-00-6501 SOCIAL SECURITY/MEDICARE 1,055.06 10,478.53 18,000.00 58.2 --------------------------------------------------------------------------------- TOTAL RETIREMENT 1,644.76 16,698.43 28,000.00 59.6 P47 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 48 TIME: 10:58:39 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LIBRARY FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ CAPITAL OUTLAY 82-000-75-00-7003 AUTOMATION 752.55 8,362.29 158,400.00 5.2 82-000-75-00-7703 BUILDING EXPANSION 1,345,711.39 1,345,711.39 7,405,131.00 18.1 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 1,346,463.94 1,354,073.68 7,563,531.00 17.9 TOTAL EXPENSES: 161,023.03 1,659,776.53 8,434,759.00 19.6 TOTAL FUND REVENUES 20,596.82 8,342,629.27 8,434,759.00 98.9 TOTAL FUND EXPENSES 161,023.03 1,659,776.53 8,434,759.00 19.6 FUND SURPLUS (DEFICIT) (140,426.21) 6,682,852.74 0.00 100.0 r P48 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 49 TIME: 10:58:39 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: FOX INDUSTRIAL FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES TAXES 85-000-40-00-3999 CARRY OVER BALANCE 0.00 11,816.84 11,817.00 99.9 85-000-40-00-4090 TIF REVENUES 0.00 70,996.87 71,000.00 99.9 --------------------------------------------------------------------------------- TOTAL TAXES 0.00 82,813.71 82,817.00 99.9 INTEREST 85-000-46-00-4600 INVESTMENT INCOME 320.32 2,536.54 2,800.00 90.5 --------------------------------------------------------------------------------- TOTAL INTEREST 320.32 2,536.54 2,800.00 90.5 TRANSFERS 85-000-49-00-4905 TRANSFER FROM MFT FUND 0.00 31,189.68 31,190.00 99.9 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 31,189.68 31,190.00 99.9 TOTAL REVENUES: 320.32 116,539.93 116,807.00 99.7 EXPENSES DEBT SERVICES 85-000-66-00-6021 FOX IND BOND-PRINCIPAL PMT 0.00 55,000.00 55,000.00 100.0 85-000-66-00-6022 FOX IND BOND-INT PAYMENT 0.00 11,225.00 22,450.00 50.0 --------------------------------------------------------------------------------- TOTAL DEBT SERVICES 0.00 66,225.00 77,450.00 85.5 CAPITAL OUTLAY 85-000-75-00-7901 FOX INDUSTRIAL - NON MFT 0.00 232:50 233.00 99.7 85-000-75-00-7902 FOX INDUSTRIAL EXPENSES 0.00 5,067.50 5,068.00 99.9 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 5,300.00 5,301.00 99.9 OTHER 85-000-78-00-9007 ADMINSITRATION FEES 637.50 1,744.00 1,107.00 157.5 85-000-78-00-9010 RESERVE-FUTURE BOND PYMTS 0.00 0.00 32,949.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 637.50 1,744.00 34,056.00 5.1 P49 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 50 TIME: 10:58:39 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: FOX INDUSTRIAL FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TOTAL EXPENSES: 637.50 73,269.00 116,807.00 62.7 TOTAL FUND REVENUES 320.32 116,539.93 116,807.00 99.7 TOTAL FUND EXPENSES 637.50 73,269.00 116,807.00 62.7 FUND SURPLUS (DEFICIT) (317.18) 43,270.93 0.00 100.0 P50 DATE: 04/04/2006 UNITED CITY OF YORKVILLE PAGE: 51 TIME: 10:58:39 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: COUNTRYSIDE TIF PROJECT FOR 10 PERIODS ENDING FEBRUARY 28, 2006 FISCAL FISCAL % ACCOUNT FEBRUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 87-000-40-00-3999 CARRY OVER BALANCE 0.00 3,456,521.17 3,456,521.00 100.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 3,456,521.17 3,456,521.00 100.0 INTEREST 87-000-46-00-4600 INVESTMENT INCOME 8,373.20 91,259.98 100,000.00 91.2 --------------------------------------------------------------------------------- TOTAL INTEREST 8,373.20 91,259.98 100,000.00 91.2 TOTAL REVENUES: 8,373.20 3,547,781.15 3,556,521.00 99.7 EXPENSES OTHER FINANCING 87-000-66-00-6002 COUNTRYSIDE TIE-INTEREST PMT 0.00 . 101,594.73 101,595.00 99.9 --------------------------------------------------------------------------------- TOTAL OTHER FINANCING 0.00 101,594.73 101,595.00 99.9 OTHER 87-000-78-00-9007 ADMINISTRATION FEES 824.50 824.50 0.00 (100.0) 87-000-78-00-9009 RESERVE 0.00 0.00 3,454,926.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 824.50 824.50 3,454,926.00 0.0 TOTAL EXPENSES: 824.50 102,419.23 3,556,521.00 2.8 TOTAL FUND REVENUES 8,373.20 3,547,781.15 3,556,521.00 99.7 TOTAL FUND EXPENSES 824.50 102,419.23 3,556,521.00 2.8 FUND SURPLUS (DEFICIT) 7,548.70 3,445,361.92 0.00 100.0 P51 o United City of Yorkville Memo '" 800 Game Farm Road EST. 1 ,ate Yorkville, Illinois 60560 Telephone: 630-553-4350 ell% Fax: 630-553-7575 O <LE ��'�• Date: April 5, 2006 To: Mayor and Administration Committee From: Lisa Pickering, Office Assistant CC: Department Heads Subject: Additional information for Administration Committee packet—April 6, 2006 Attached please find information on NB#2—Monthly Treasurer's Report for February 2006. Please add this information to your packet. Reviewed By: J2 O� Legal ❑ City Council EST. '� "'� 1836 Finance Engineer ❑ t w City Administrator ❑ Agenda Item Tracking Number O E O` Consultant El ADM 2006- (c zAp<LE City Council Agenda Item Summary Memo Title: Monthly Treasurer's Report—February 2006 City Council/ COW/ Committee Agenda Date: Administration 4/06/06 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Julie Ciesla Finance Name Department Agenda Item Notes: The beginning balances for February reflect the audited ending cash balances for F/Y 04/05. The ending balances for February reflect the current cash balance of all funds as of February 28, 2006. United City of Yorkville Monthly Treasurer's Report Pre Audit Financial Summary As of February 28, 2006 Beginning Ending Fund Balance Revenues Expenses Transfers Balance 1 General 5,714,885.53 698,663.45 893,433.23 (63,457.78) * 5,456,657.97 15 Motor Fuel Tax 431,112.34 23,153.09 20,234.88 - 434,030.55 16 Municipal Building (268,649.78) 8,500.00 4,141.82 - (264,291.60) 20 PD Capital 167,545.60 17,019.00 4,605.15 - 179,959.45 21 PW Capital 434,297.15 37,450.00 - - 471,747.15 22 Parks&Rec Equip Capital 79,835.38 - - - 79,835.38 37 Sanitary Sewer Improvement 10,715,058.84 136,712.26 1,600,933.40 - 9,250,837.70 41 Water Improvement Exp 1,462,389.25 126,474.79 282,664.34 - 1,306,199.70 42 Debt Service (256,242.73) 1,440.56 53,525.35 - (308,327.52) 51 Water 615,301.01 270,741.17 115,570.25 - 770,471.93 52 Sewer 556,471.98 131,047.62 25,249.09 - 662,270.51 72 Land Cash (83,866.66) 11,291.65 - - (72,575.01) 73 Land Acquisition 213,617.69 - - - 213,617.69 79 Parks&Recreation 240,109.80 20,098.00 78,975.15 - 181,232.65 82 Library 6,776,253.33 17,971.82 161,023.03 2,625.00 * 6,635,827.12 85 Fox Industrial 32,363.11 320.32 637.50 - 32,045.93 87 Countryside TIF Project 3,437,813.22 8,373.20 824.50 - 3,445,361.92 95 Trust&Agency 58,540.24 621,386.62 29,050.00 - 650,876.86 Totals 30,326,835.30 2,130,643.55 3,270,867.69 (60,832.78) * 29,125,778.38 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 * February's transfer check for Library in the amount of$1,350 was deposited Fund Balance Reserve in March General Fund 32.46%1 Water Ops 44.09%1 Sewer Maint. 68.59% * February's transfer check for Parks& Combined Fund Balance Reserve 36.77%1 Recreation in the amount of$59,482.78 was deposited in March Prepared By:Julie Ciesla-Senior Accounting Clerk 4/4/2006 F&L DRAFT 03/29/06 ORDINANCE NO. AN ORDINANCE PROPOSING THE ESTABLISHMENT OF SPECIAL SERVICE AREA NUMBER 2006-J/t/0 (BAILEY MEADOWS PROJECT) IN THE UNITED CITY OF YORKVILLE AND PROVIDING FOR OTHER PROCEDURES IN CONNECTION THEREWITH BE IT ORDAINED BY THE CITY COUNCIL OF THE UNITED CITY OF YORKVILLE, KENDALL COUNTY, ILLINOIS AS FOLLOWS: Section 1. Authority. The United City of Yorkville, Kendall County, Illinois (the is authorized pursuant to Article VII, Section 7(6) of the Constitution of the State of Illinois, and pursuant to the provisions of the Illinois Special Service Area Tax Law, 35 ILCS 200/27-5 et seq. (the "Act"), which provides, inter alia, the manner of levying or imposing taxes and issuing bonds for the provision of special services to areas within the boundaries of municipalities and counties. Section 2. Findings. The City Council of the City finds and determines as follows: a. Owners of record (the "Owners") of that portion of the City described in Exhibit A attached hereto and made a part hereof(hereinafter the "Subject Territory') have expressed an interest in the construction, acquisition and installation of various infrastructure improvements to their properties as further described herein; and b. Pursuant to Section 27-20 of the Act,the Owners have filed an application with the City Council of the City proposing that the City establish a special service area (the"Application"); and C. It is in the public interest that the City Council of the City consider the creation of a special service area for the Subject Territory; and d. The special service area proposed for consideration is compact and contiguous; and e. The proposed special service area will benefit specially from the municipal services to be provided to the area. These proposed municipal services are in addition to municipal services provided to the City as a whole. Section 3. Proposal. In response to the expressed interest of the Owners, the City Council of the City hereby accepts the Application and proposes the establishment of City of Yorkville Special Service Area Number 2006- for the construction, acquisition and installation of infrastructure improvements to serve the Subject Territory. Section 4. Public Hearing. A public hearing shall be held on the day of 2006, at 7:00 p.m., at the Yorkville City Hall, 800 Game Farm Road, Yorkville, CH12_634694.1 Illinois,to consider the creation of the City of Yorkville Special Service Area Number 2006-IL01 in the Subject Territory. At the hearing, the following method of financing improvements within the proposed special service area will be considered: the borrowing of an amount not to exceed an aggregate principal amount of$7,000,000 to be evidenced by special tax bonds (including bonds issued to refund such bonds) of such area (the `Bonds"), the proceeds of which shall be used to pay the cost of providing special municipal services to the proposed special service area, to fund certain reserves for, and interest on, the Bonds and initial administrative expenses relating to the proposed special service area, and to pay the cost of issuing the Bonds. The special municipal services to be provided to the proposed special service area may include: engineering, surveying, soil testing and appurtenant work, mass grading and demolition, storm water management facilities, storm drainage systems and storm sewers, site clearing and tree removal, public water facilities, sanitary sewer facilities, erosion control measures, roads, streets, curbs, gutters, street lighting, traffic controls, sidewalks, paths and related street improvements, and equipment and materials necessary for the maintenance thereof, landscaping, wetland mitigation and tree installation, costs for land. and easement acquisitions or dedications relating to any of the foregoing improvements, required tap-on and related fees for water or sanitary sewer services and other eligible costs. The Bonds shall be retired over a period not to exceed forty (40) years from the date of their issuance and shall bear interest at a rate not to exceed the greater of nine percent(9%)per annum or 125%of the rate for the most recent date shown in the 20 G.O. Bonds Index of average municipal bond yields as published in the most recent edition of The Bond Buyer, published in New York, New York, at the time the contract is made for the sale of the Bonds. The Bonds shall be retired by the levy of an annual tax levied against each parcel of property within the special service area pursuant to a special tax roll to pay the interest on the Bonds as it falls due and to discharge the principal thereof at maturity and to pay the costs of administration and maintenance of the Subject Territory. This tax is to be levied upon all taxable property within the proposed special service area. Section 5. Notice of Public Hearin. Notice of hearing shall be published at least once not less than fifteen (15) days prior to the public hearing specified in Section 4 above, in a newspaper of general circulation in the City. In addition, notice shall be given by depositing the notice in the United States mail addressed to the person or persons in whose name the general taxes for the last preceding year were paid on each lot, block, tract or parcel of land lying within the proposed special service area_ This notice shall be mailed not less than ten (10) days prior to the time set for the public hearing. In the event taxes for the last preceding year were not paid, the notice shall be sent to the person last listed on the tax rolls prior to that year as the owner of the property. The notice to owners of record shall be in substantially the form set forth in Exhibit B to this Ordinance. Section 6. Supercede Conflicting Ordinances. All ordinances or parts of ordinances in conflict with the provisions of this ordinance are repealed to the extent of such conflict. Section 7. Effective Date. This Ordinance shall be in full force and effect from and after its passage and approval in the manner provided by law. 2 CH12_634694.1 PASSED by the City Council of the City this ,2006. Voting Aye(list names): Voting Nay (list names): Abstaining(list names): Absent(list names): City Clerk SIGNED by the Mayor this President ATTEST: City Clerk Published in pamphlet form , 2006. 3 CH12_634694.1 EXHIBIT A Legal Description PARCEL A LOT 2 OF THE NORTHEAST QUARTER OF SECTION 5,TOWNSHIP 37 NORTH,RANGE 7 EAST OF THE THIRD PRINCIPAL MERIDIAN, ACCORDING TO THE PLAT OF THE GOVERNMENT SURVEY OF SAID SECTION 5 (EXCEPT THAT PART DESCRIBED AS FOLLOWS: BEGINNING AT THE SOUTHEAST CORNER OF SAID LOT 2; THENCE WEST 40 CHAINS TO THE SOUTHWEST CORNER OF SAID LOT; THENCE NORTH 38.5 LINKS TO THE SOUTH BANK OF DITCH; THENCE SOUTH 89 DEGREES 30 MINUTES EAST, 40 CHAINS TO THE POINT OF BEGINNING AND EXCEPTING THEREFROM THAT PART OF THE NORTHEAST QUARTER OF SECTION 5, TOWNSHIP 37 NORTH, RANGE 7 EAST OF THE THIRD PRINCIPAL MERIDIAN AS FOLLOWS: BEGINNING AT A POINT ON THE NORTH LINE OF SAID NORTHEAST QUARTER, 1961.60 FEET EAST OF THE NORTHWEST CORNER OF SAID NORTHEAST QUARTER; THENCE EAST ALONG SAID NORTH LINE 667.00 FEET ; THENCE SOUTH AT RIGHT ANGLES TO SAID NORTH LINE, 396.00 FEET; THENCE WEST AT RIGHT ANGLES TO THE LAST DESCRIBED COURSE, 667.00 FEET; THENCE NORTH AT RIGHT ANGLES TO THE LAST DESCRIBED COURSE, 396.00 FEET TO THE POINT OF BEGINNING, AND ALSO EXCEPTING THEREFROM THAT PART DESCRIBED AS FOLLOWS; COMMENCING AT THE SOUTHEAST CORNER OF SAID LOT 2; THENCE WEST 40 CHAINS (RECORD), 2652.01 FEET (MEASURED) TO THE SOUTHWEST CORNER OF SAID LOT 2, THENCE NORTH 38.5 LINKS (RECORD), 25.41 FEET (MEASURED) TO THE SOUTH BANK OF DITCH; THENCE SOUTH 89 DEGREES 30 MINUTES EAST (RECORD), NORTH 88 DEGREES 05 MINUTES 41 SECONDS EAST (MEASURED), 2593.76 FEET (MEASURED) TO THE POINT OF BEGINNING; THENCE 01 DEGREES 54 MINUTES 03 SECONDS WEST, 232.55 FEET TO A POINT ON A NON-TANGENT CURVE; THENCE NORTHEASTERLY 68.93 FEET A LONG A CURVE TO THE LEFT, HAVING A RADIUS OF 533.00 FEET AND WHOSE CHORD BEARS NORTH 59 DEGREES 57 MINUTES 33 SECONDS EAST, 68.88 FEET TO A POINT ON THE EAST LINE OF SAID LOT 2; THENCE SOUTH 01 DEGREES 16 MINUTES 25 SECONDS EAST ALONG SAID EAST LINE,265.04 FEET TO THE SOUTHEAST CORNER OF SAID LOT 2; THENCE SOUTH 88 DEGREES 05 MINUTES 41 SECONDS WEST, 57.84 FEET TO THE POINT OF BEGINNING IN THE TOWNSHIP OF BRISTOL,KENDALL COUNTY,ILLINOIS. PIN'S: PARCEL B THAT PART OF LOT 2 OF THE NORTHWEST QUARTER OF SECTION 4,TOWNSHIP 37 NORTH,RANGE 7 EAST OF THE THIRD PRINCIPAL MERIDIAN,ACCORDING TO THE PLAT OF THE GOVERNMENTAL SURVEY OF SAID SECTION 4,DESCRIBED AS FOLLOWS: BEGINNING AT THE NORTHWEST CORNER OF SAID SECTION; THENCE SOUTH ON THE SECTION LINE 26.80 CHAINS; THENCE EAST PARALLEL WITH THE NORTH LINE OF SAID SECTION, 14.30 CHAINS; THENCE IN A NORTHEASTERLY DIRECTION TO A POINT ON THE NORTH LINE OF SAID SECTION,20.67 CHAINS EAST OF THE POINT OF BEGINNING; THENCE WEST ALONG THE SECTION LINE TO THE POINT OF BEGINNING; EXCEPTING THEREFROM THAT PART OF LOT 2 LYING EASTERLY OF THE FOLLOWING DESCRIBED LINE; BEGINNING AT THE SOUTHWEST CORNER OF SAID LOT 2; THENCE NORTH 01 DEGREES 16 MINUTES 25 SECONDS WEST, ALONG THE WEST LINE OF SAID LOT 2,A DISTANCE OF 265.04 FEET TO A POINT ON A NON-TANGENT CURVE;THENCE NORTHEASTERLY 531.35 FEET ALONG A CURVE TO THE LEFT, HAVING A RADIUS OF 533.00 FEET AND WHOSE CHORD BEARS NORTH 27 DEGREES 41 MINUTES 44 SECONDS EAST, 509.62 FEET TO A POINT OF TANGENCY, THENCE NORTH 00 DEGREES 51 MINUTES 49 SECONDS WEST 150.53 FEET,THENCE NORTH 89 DEGREES 08 MINUTES 11 SECONDS EAST, PERPENDICULAR TO THE LAST DESCRIBED LINE, 110.00 FEET; THENCE NORTH 00 DEGREES 51 MINUTES 49 SECONDS WEST PERPENDICULAR TO THE LAST DESCRIBED LINE, 912.39 CH12_634694.1 FEET TO A POINT ON THE NORTH LINE OF SAID LOT 2, SAID POINT BEING 364.44 FEET EAST OF THE NORTHWEST CORNER OF SAID SECTION 4 (AS MEASURED ALONG SAID NORTH LINE) AND SAID POINT ALSO BEING THE POINT OF TERMINUS; IN THE TOWNSHIP OF BRISTOL,KENDALL COUNTY, ILLINOIS. PIN'S: 2 CHI2_634694.1 EXHIBIT B NOTICE OF HEARING UNITED CITY OF YORKVILLE SPECIAL SERVICE AREA NUMBER 2006-110 (BAILEY MEADOWS PROJECT) NOTICE IS HEREBY GIVEN that on 2006 at 7:00 p.m. at the Yorkville City Hall, 800 Game Farm Road, Yorkville, Illinois, a hearing will be held by the United City of Yorkville (the "Liff") to consider forming a special service area, to be called "City of Yorkville Special Service Area Number 2006-_____-1" consisting of the territory legally described in Exhibit 1 to this Notice. The approximate street location is at the intersection of Route 47 and Galena Road in the City. The general purpose of the formation of the City of Yorkville Special Service Area Number 2006-110 is to provide special municipal services to the area which may include: engineering, surveying, soil testing and appurtenant work, mass grading and demolition, storm water management facilities, storm drainage systems and storm sewers, site clearing and tree removal,public water facilities, sanitary sewer facilities, erosion control measures, roads, streets, curbs, gutters, street lighting, traffic controls, sidewalks, paths and related street improvements, and equipment and materials necessary for the maintenance thereof, landscaping, wetland mitigation and tree installation, costs for land and easement acquisitions or dedications relating to any of the foregoing improvements, required tap-on and related fees for water or sanitary sewer services and other eligible costs. There will also be considered at the hearing the following method of financing improvements within the proposed special service area: the issuance of special tax bonds (including bonds issued to refund such bonds) in an aggregate principal amount not to exceed $7,000,000 at an interest rate of not to exceed the greater of nine percent (9%) per annum or 125% of the rate for the most recent date shown in the 20 G.O. Bonds Index of average municipal bond yields as published in the most recent edition of The Bond Buyer, published in New York, New York, at the time the contract is made for the sale of the bonds, and to mature within forty (40) years from the date of their issuance. The bonds shall be retired by the levy of an annual tax established pursuant to a special tax roll to pay the interest on such bonds as it falls due and to discharge the principal thereof at maturity and to pay the costs of administration and maintenance of the special service area, said tax to be levied upon all taxable property within the proposed special service area. At the hearing, all interested persons affected by the formation of such special service area, including all persons owning taxable real estate therein, may file written objections to and be heard orally regarding the formation of and the boundaries of the special service area, the issuance of bonds and the levy of taxes affecting the area. The hearing may be adjourned by the City Council without further notice other than a motion to be entered upon the minutes of its meeting fixing the time and place of its adjournment. CHI2_634694.1 If a petition signed by at least 51% of the electors residing within the City of Yorkville Special Service Area Number 2006-Aa and by at least 51% of the owners of record of the land included within the boundaries of the City of Yorkville Special Service Area Number 2006-JLO is filed with the City Clerk of the City of Yorkville within 60 days following the final adjournment of the public hearing objecting to the creation of the special service area, the issuance of bonds for the provision of special services to the area or the levy of taxes affecting the area, no such area may be created and no such bonds may be issued or taxes levied or imposed. 2 CH12_634694.1 Exhibit I to Notice Legal Description of Property PARCEL A LOT 2 OF THE NORTHEAST QUARTER OF SECTION 5, TOWNSHIP 37 NORTH,RANGE 7 EAST OF THE THIRD PRINCIPAL MERIDIAN, ACCORDING TO THE PLAT OF THE GOVERNMENT SURVEY OF SAID SECTION 5 (EXCEPT THAT PART DESCRIBED AS FOLLOWS: BEGINNING AT THE SOUTHEAST CORNER OF SAID LOT 2; THENCE WEST 40 CHAINS TO THE SOUTHWEST CORNER OF SAID LOT; THENCE NORTH 38.5 LINKS TO THE SOUTH BANK OF DITCH; THENCE SOUTH 89 DEGREES 30 MINUTES EAST, 40 CHAINS TO THE POINT OF BEGINNING AND EXCEPTING THEREFROM THAT PART OF THE NORTHEAST QUARTER OF SECTION 5, TOWNSHIP 37 NORTH, RANGE 7 EAST OF THE THIRD PRINCIPAL MERIDIAN AS FOLLOWS: BEGINNING AT A POINT ON THE NORTH LINE OF SAID NORTHEAST QUARTER, 1961.60 FEET EAST OF THE NORTHWEST CORNER OF SAID NORTHEAST QUARTER; THENCE EAST ALONG SAID NORTH LINE 667.00 FEET ; THENCE SOUTH AT RIGHT ANGLES TO SAID NORTH LINE, 396.00 FEET; THENCE WEST AT RIGHT ANGLES TO THE LAST DESCRIBED COURSE, 667.00 FEET; THENCE NORTH AT RIGHT ANGLES TO THE LAST DESCRIBED COURSE, 396.00 FEET TO THE POINT OF BEGINNING, AND ALSO EXCEPTING THEREFROM THAT PART DESCRIBED AS FOLLOWS; COMMENCING AT THE SOUTHEAST CORNER OF SAID LOT 2; THENCE WEST 40 CHAINS (RECORD), 2652.01 FEET(MEASURED) TO THE SOUTHWEST CORNER OF SAID LOT 2, THENCE NORTH 38.5 LINKS (RECORD), 25.41 FEET(MEASURED)TO THE SOUTH BANK OF DITCH; THENCE SOUTH 89 DEGREES 30 MINUTES EAST (RECORD), NORTH 88 DEGREES 05 MINUTES 41 SECONDS EAST (MEASURED), 2593.76 FEET (MEASURED) TO THE POINT OF BEGINNING; THENCE 01 DEGREES 54 MINUTES 03 SECONDS WEST, 232.55 FEET TO A POINT ON A NON-TANGENT CURVE; THENCE NORTHEASTERLY 68.93 FEET A LONG A CURVE TO THE LEFT, HAVING A RADIUS OF 533.00 FEET AND WHOSE CHORD BEARS NORTH 59 DEGREES 57 MINUTES 33 SECONDS EAST, 68.88 FEET TO A POINT ON THE EAST LINE OF SAID LOT 2; THENCE SOUTH 01 DEGREES 16 MINUTES 25 SECONDS EAST ALONG SAID EAST LINE,265.04 FEET TO THE SOUTHEAST CORNER OF SAID LOT 2; THENCE SOUTH 88 DEGREES 05 MINUTES 41 SECONDS WEST, 57.84 FEET TO THE POINT OF BEGINNING IN THE TOWNSHIP OF BRISTOL,KENDALL COUNTY,ILLINOIS. PIN'S: PARCEL B THAT PART OF LOT 2 OF THE NORTHWEST QUARTER OF SECTION 4, TOWNSHIP 37 NORTH, RANGE 7 EAST OF THE THIRD PRINCIPAL MERIDIAN,ACCORDING TO THE PLAT OF THE GOVERNMENTAL SURVEY OF SAID SECTION 4,DESCRIBED AS FOLLOWS: BEGINNING AT THE NORTHWEST CORNER OF SAID SECTION;THENCE SOUTH ON THE SECTION LINE 26.80 CHAINS; THENCE EAST PARALLEL WITH THE NORTH LINE OF SAID SECTION, 14.30 CHAINS; THENCE IN A NORTHEASTERLY DIRECTION TO A POINT ON THE NORTH LINE OF SAID SECTION,20.67 CHAINS EAST OF THE POINT OF BEGINNING; THENCE WEST ALONG THE SECTION LINE TO THE POINT OF BEGINNING; EXCEPTING THEREFROM THAT PART OF LOT 2 LYING EASTERLY OF THE FOLLOWING DESCRIBED LINE; BEGINNING AT THE SOUTHWEST CORNER OF SAID LOT 2; THENCE NORTH 01 DEGREES 16 MINUTES 25 SECONDS WEST, ALONG THE WEST LINE OF SAID LOT 2,A DISTANCE OF 265.04 FEET TO A POINT ON A NON-TANGENT CURVE;THENCE NORTHEASTERLY 531.35 FEET ALONG A CURVE TO THE LEFT, HAVING A RADIUS OF 533.00 FEET AND WHOSE CHORD BEARS NORTH 27 DEGREES 41 MINUTES 44 SECONDS EAST, 509.62 FEET TO A POINT OF TANGENCY, THENCE NORTH 00 DEGREES 51 MINUTES 49 SECONDS WEST 150.53 FEET,THENCE NORTH 89 DEGREES 08 MINUTES 11 SECONDS EAST, PERPENDICULAR TO THE LAST DESCRIBED LINE, 110.00 FEET; THENCE NORTH 00 DEGREES 51 MINUTES 49 SECONDS WEST PERPENDICULAR TO THE LAST DESCRIBED LINE, 912.39 CHI2_634694.1 FEET TO A POINT ON THE NORTH LINE OF SAID LOT 2,SAID POINT BEING 364.44 FEET EAST OF THE NORTHWEST CORNER OF SAID SECTION 4 (AS MEASURED ALONG SAID NORTH LINE) AND SAID POINT ALSO BEING THE POINT OF TERMINUS; IN THE TOWNSHIP OF BRISTOL, KENDALL COUNTY, ILLINOIS. PIN'S: 2 CHI2_634694.1 i o United City of Yorkville Memo �C J 'A 800 Game Farm Road EST. 18M Yorkville, Illinois 60560 - � .� Telephone: 630-553-4350 op r �o Fax: 630-553-7575 dd SCE Date: April 4, 2006 To: Administration Committee From: Bart Olson,Assistant City Administrator CC: Subject: Administrative Assistant job description discussion Per the March 21 COW meeting, staff has analyzed the policy options regarding the Administrative Assistant job description. Upon review of several other municipalities'job descriptions, much of the functions within a traditional Adm. Asst. position are clerical/secretarial in nature. In Yorkville's case, this wasn't necessarily false as job functions such as agenda and packet creation, filing and recording documents, and updating and maintaining databases are included within the current job description. However, Yorkville's Adm. Asst.job description also contains functions such as preparing, filing, and issuing paperwork for tobacco, amusement, and liquor licenses, coordinating development applications, and serving as a liaison to City Council for general information and queries—which were a direct result of the change in the job description from Deputy Clerk to Administrative Assistant and the desire for City Council to have more access to administrative staff and policy research. Per discussion at the March 21 COW meeting, it was understood by staff that the elected officials are interested in a position that can do policy research for the Mayor, City Council, and the City Administrator—a.k.a. higher level research than "general information and queries,particularly for agenda items and City projects"as is in the current Adm. Asst.job description. Given the circumstances of a traditional Adm. Asst.job description,the current status of Yorkville's job description, and the understood intentions of the City Council—the following policy options are available: 1) (As discussed at the March 21 COW meeting)Have two levels of Administrative Assistant. The title of"Administrative Assistant I and II"would imply work of mostly clerical nature— and for sake of comparability between municipalities, any additional responsibilities (i.e. policy research) given to the Administrative Assistant would make it less comparable in purposes of salary surveys, organizational hierarchy comparisons, etc. However,this option is feasible and can be carried out if Council desires a"higher level secretary". 2) (New option, as a result of staff research) Keep the current Administrative Assistant job description as is—and draft a job description similar in nature to the Management Analyst job description from Gurnee. This management analyst position would accomplish the higher level policy research that has been sought after by Council, and would still allow the current Administrative Assistant to focus on development coordination and packet and agenda creation.I 'Essential functions of the Gurnee position that relate to"Public Information Officer"and dissemination of press releases would not be applicable to a new position in Yorkville given the presence of a Community Relations Manager. ((: �U!T!age of POSITION TITLE: MANAGEMENT ANALYST EFFECTIVE DATE: February,2006 Note: This job description describes a general category of jobs. In order to meet the needs of Village government or its departments, employees may be assigned other duties, in addition to or in lieu of any of those described below,and duties are subject to change as requirements of the job change. DEFINITION: The employee in this position performs staff or administrative work handling overall technical and administrative matters. Responsible for relieving the Village Administrator of administrative details requiring the exercise of judgment and knowledge of public administration practices. Provides support to the Village Administrator, Department Heads, and elected officials by carrying out special project assignments, dealing with the public as needed and acting as a liaison to the Village residents and media. Position involves a high degree of public contact. Work is performed under general direction of the Village Administrator and requires initiative and independent judgment. EXAMPLES OF ESSENTIAL DUTIES (The omission of a duty does not exclude it from the position if the duty is similar,related,or a logical expectation for an individual to perform as part of the job responsibilities. Reasonable accommodations may be made to assist individuals with disabilities.): 1. Coordinate special projects with department heads to be delegated throughout the respective department 2. Gather information, conduct surveys, and prepare reports for the Village Administrator 3. Provide assistance for meetings; assemble background information; identify items of business to be considered by the Village Board; prepare agendas, reports and communications for the Village Administrator; attend meetings 4. Analyze,prepare, and draft municipal contracts, ordinances, and resolutions 5. Assist in the administration of franchise agreements and other municipal contracts including but not limited to utility, cable, and solid waste and recycling collection programs 6. Supervise the investigation of various citizen complaints and inquiries; initiate appropriate actions; provide information to the general public, news media, and public/Village officials 7. Serve as Public Information Officer for the Village 8. Responsible for the preparation, maintenance, and distribution of a variety of Village information sources, including but not limited to: press releases; Village resident newsletters; Village website maintenance; Annual Report; Community Feedback Survey; Village list serve electronic mail group 9. Assist with overall budget preparation for the Village, specifically with the preparation of historical trend analysis, drafting / editing of goals and objectives, and preparation of the administration, cable television and municipal building cost centers 10. Represent and serve as liaison for the Village Administrator to intergovernmental agencies, community groups, boards, and commissions 11. Supervise and evaluate assigned personnel 12. Perform related job tasks and duties as requested or required KNOWLEDGE, SKILLS,AND ABILITIES (The following knowledge,skills,and abilities are necessary in order to effectively perform the duties of this position. The omission of specific knowledge, skills, and abilities does not exclude them from the position if the knowledge, skill, or ability is a logical expectation for an individual to possess to effectively perform the duties of this position.): Knowledge of: principles and practices public administration and management; research methods and techniques and methods of reports preparation; principles of customer service and public relations; principles, methods, and practices of municipal budgeting and finance; supervisory practices and procedures; word processing, spreadsheet, and database programs Ability to: effectively communicate verbally and in writing; research, organize, and present statistical, financial, and factual data verbally and in writing; prepare reports accurately; exercise resourcefulness to solve problems; work under time constraints; perform statistical and financial calculations; work independently; establish and maintain effective working relationships with other employees, supervisors, Village officials, governmental agencies, and the general public; effective conflict resolution / negotiation skills. Ability to: use hands and fingers to handle equipment; sit for an extended period of time; occasionally lift and/or move up to twenty (20) pounds with or without assistance; work in an office environment. Other Skills and Abilities: skill and ability to perform duties as required and to operate required tools and equipment; effective public speaking skills; organizational skills; time management skills. GENERAL QUALIFICATIONS: Bachelors degree in public administration/related field; Masters degree in public administration preferred. One (1)to three (3)years previous municipal experience in a related position. �A y United City of Yorkville Memo / 800 Game Farm Road AbAll esr -t 1836 Yorkville, Illinois 60560 Telephone: 630-553-4350 Fax: 630-553-7575 <LE Date: April 4, 2006 To: Administration Committee From: Bart Olson, Assistant City Administrator CC: Subject: Comprehensive Salary Survey Update Staff has compiled much of the necessary information for the Comprehensive Salary Survey, and has contacted all comparable communities for responses. At this time, we are still waiting on information or verification of information from a few municipalities. This information should be available within a week, and should be available for presentation at that time. Given the large amount of policy deliberation and discussion for this issue,the option of a presentation at the April 18`h Committee of the Whole (as opposed to the May 41` Administration Committee) should be posed to you for consideration.