Loading...
Administration Packet 2006 07-06-06 4 United City of Yorkville 800 Game Farm Road EST - " 1$36 Yorkville, Illinois 60560 Telephone: 630-553-4350 Fax: 630-553-7575 LLE AGENDA ADMINISTRATION COMMITTEE MEETING Thursday,July 6,2006 6:30 P.M. CITY CONFERENCE ROOM Administration items are scheduled for the 2nd Committee of the Whole meeting each month Presentation: None Old Business: 1. Minutes for Approval/Correction: May 4, 2006 and June 1, 2006 2. ADM 2006-35 Park Board Bonding Coverage 3. ADM 2006-42 Hiring Policy (non-department heads) 4. ADM 2006-31 Staff Salary Survey 5. Clerk and Treasurer—Elected or Appointed Positions New Business: 1. Monthly Budget Report for May 2006 2. ADM 2006-43 Monthly Treasurer's Report for May 2006 3. ADM 2006-44 Proposal for Community Relations Intern 4. ADM 2006-45 Staffing Needs Analysis Methodology 5. ADM 2006-46 IT Assistant Job Description Update Additional Business: Page 1 of 2 DRAFT ADMINISTRATION COMMITTEE MEETING Thursday,May 4,2006 6:30 P.M. City Conference Room Present Alderwoman Rose Spears Denise Kasper Alderman Jim Bock Bart Olson Alderwoman Valerie Burd City Treasurer Bill Powell City Administrator John Crois Police chief Harold Martin Lynsey Johnson The meeting was called to order at 6:30 pm by Alderman Jim Bock. Presentations: -None. Old Business: 1. Minutes for Approval/Correction: -April 6, 2005 —The minutes were approved. 2. PW 2006-39 Project Manager—Proposed Position and Draft Job Description —The title of this position has changed from Project Manager to Public Improvement Technician and it is budgeted for a November hire. New "knowledge, skills and abilities"items were added as well as a new"physical demands" section. The salary range is $41,000 -$57,000. Alderwoman Spears said she would like to have the candidates tested on Excel and CAD systems so it can be proved the candidate is proficient in these programs. Alderwoman Burd does not know why this position is needed. The individual would be doing routine things that City Engineer Joe Wywrot does such as letter of credit reductions and punch list items. This person would notify residents of projects in their area. Alderwoman Burd said when the last person was hired in this department she asked Joe Wywrot if he would need any more staff, and he said no. She would like to put this job description on hold until the City Engineer can come up with a plan for his department. This will come back to Administration in July. 3. ADM 2006-27 Quarterly Department Vehicle Reports—This will be postponed until June. 4. ADM 2006-28 Hoover Boy Scout Camp—Update on Process—The piece of land being held by Corlands for the City is not in the Hoover Camp, it is in Grande Reserve. Maybe some of the land in Grande Reserve could be swapped with some of the land in the Hoover Camp. The property in Hoover is being held for the Forest Preserve. With Corlands holding land for the City the land can be used for grants such as the OSLAD grant. The 1 year contract extension for Corlands to continue holding the land will cost$10,000. John Crois still has to find out if there is an intergovernmental agreement with the Forest Preserve for using some of the land for active recreation programs. This will move on to COW on May 16, 2006. Page 2 of 2 New Business: 1. Monthly Budget Report for March 2006—No further action is necessary. 2. ADM 2006-33 Monthly Treasurer's Report for March 2006—The beginning balance is$29,125,778.38. Revenues were$2,478,189.14 and expenses were 3,300,349.32. There were $60,832.78 in transfers. The ending balance is $28,364,450.98. The combined Fund Balance Reserve is 41.49%. The City wants the Fund Balance to be closer to 25%. This will move on to COW. 3. ADM 2006-34 Park Board—Beecher Center Rental—Right now the process is being handled by 2 people in 2 separate locations. The Beecher Building will determine the availability and the deposits will now be paid at the City. Ron Robinson will be consulted to see if the 2 computer systems can be linked. Maybe this could be put into the website. No further action is needed for the committee. 4. ADM 2006-35 Park Board Bonding Coverage—This is informational. No further action is needed. There was a question about why the Park Board members sign checks. Dave Mogle or Scott Sleezer may be able to explain. It is thought is has something to do with Land Cash. 5. ADM 2006-36 Assistant City Administrator Related Job Descriptions a. Administrative Assistant b. Office Assistant c. Administrative Secretary—This is informational. Only the reports to line was changed. They now report to the Assistant City Administrator. The memo will go on to COW. Additional Business: John Crois said the Mayor has reviewed a recommendation for the Finance Director. He will be coming forward with his recommendation. Chief Martin asked what the City Council's policy was for people who have retired from the City and then come back to work in another position for the City. This will be investigated and a policy will be made. Gary Collins is the attorney for the Police Pension. He will be contacted to see if there are any ramifications. Bill Powell said as a FYI there is online access to the Parks in the works. Alderwoman Spears asked about the hiring policy of department heads. This will be coming back to COW. The meeting was adjourned at 7:40 pm. Minutes submitted by Laura Leppert. Page I of 3 DRAFT ADMINISTRATION COMMITTEE MEETING Thursday,June 1,2006 6:30 P.M. City Conference Room Present Alderwoman Rose Spears Denise Kasper Alderman Jim Bock Bart Olson Alderwoman Valerie Burd Dan Kramer,attorney Alderman Paul James Tony Graff, Graff Mgmt. Development City Administrator John Crois Patrick Hughes, Ocean Atlantic The meeting was called to order at 6:30 pm by Chairman Paul James. Presentations: -None. Old Business: 1. Minutes for Approval/Correction: -None New Business: 1. Monthly Budget Report for April 2006—Alderman Paul James asked if this report is for the original budget or the revised budget. John Crois said this does not show the whole year's sales tax and income tax yet and when the auditor's are finished the 90%will go up. Bart Olson thinks this does reflect the revised budget. The estimate for Health and Sanitation was too low in the revised budget. On page 3 of the report Alderwoman Spears asked why the unemployment tax was so high. John Crois said that unemployment can be paid as a percentage of payroll or can be paid as reimbursement on the amount paid out in claims.The line item for legal services was high. The line item for building permits was high because it is good to budget low. More permits is more revenue for the City. On page 13 there was a question about why the expense for leaf pickup was so high. John Crois will check with Eric Dhuse to find out. On page 24 there was a question why the river crossing fee was so low, and what it was for. This is on a permit basis, and it is believed it is$110 per permit. Bart Olson will look into it. On page 25 there was a question of why the debt issuance costs were more than double what was budgeted. John Crois will get an explanation. Alderwoman Spears wants to know the City's Bond Rating. On page 26 there was a question about the Southwest Water Main revenue. The project was supposed to annex last Tuesday. It is not developed yet. The Engineering Radium Contract B is more than 4 times what was budgeted and the Central Zone Contract C was more than 2 times what was budgeted. John Crois will get explanations about these as well. Alderman James wondered how close the original budget was to the end numbers. Page 2 of 3 2. ADM 2006-37 Monthly Treasurer's Report for April 2006—Bill Powell is not here tonight but he wanted everyone to know there is still$1.5 million left to Bond for the Library. The sale will be in July and the money will come in in August. This will go on to COW on Consent Agenda. 3. ADM 2006-38 Westbury East Village SSA Resolution Declaring Official Intent 4. ADM 2006-39 Westbury East Village SSA 2006-111 Proposing Ordinance 5. ADM 200640 Westbury South Village SSA Resolution Declaring Official Intent 6. ADM 2006-41 Westbury South Village SSA 2006-112 Proposing Ordinance Items 3—6 were discussed at the same time. Dan Kramer and Pat Hughes were present to explain the development as a whole. Westbury East and South have Annexation Agreements that allow a SSA. The developer is hoping to extend the traditional Bond financing to Westbury West and North. Although Westbury West and North are not on the Agenda tonight, they explained how the development works as a whole. There is a storm sewer outfall that will release at the North East corner of Corneils and Rt. 47. 3 developers will be front funding it so it can be put in this summer or fall. Without this storm sewer, much of this land would be undevelopable. The Golf Course will be developed on land that otherwise can not be developed. It will be a privately owned fee course that may at sometime in the future become a private course. There will be an additional SSA request to widen Rt. 47 and put in a traffic signal. These are the official intent and proposing ordinances that the annexation agreements allow. Alderman James asked if the SSA could be rolled into the price of the home. Patrick Hughes said his experience was that when given a choice,the homeowner chooses not to roll the SSA into the price of the home. Paul James said young people buying their first home do not understand the large tax bill. There was discussion about the fair market value and the tax value. The new Finance Director will be made aware to watch the assessments in the SSA homes. Language about truth in advertising about the SSA community should be included in the ordinance. Alderman James wanted to know if Rt.47 could be widened before the development of the subdivisions began. This will move on to COW on June 20th for discussion. 7. ADM 2006-42 Hiring Policy(non department heads)—In the first paragraph of Section 2.1.3 the phrase"and the following procedures will apply" should be deleted if the procedures are removed. There was discussion that a, c, and d should remain somewhere in the policy. Alderman James said when there is an interim appointment there should be no increase in pay. Interim appointments are career growth and the increase in pay can come if they take the job other than as interim. This part will be tabled for now. Under approval to recruit personnel,the job description must be approved with the adoption of the annual operating budget before recruitment can begin. Also further in the same paragraph,the information should be forwarded to the City Administrator for review and/or approval (the"/or"is what is being added). Page 3 of 3 Under posting process,the job should be posted in the entire city, not just the department. There was some discussion about transferring employees if they are burnt out or struggling in their position. A department head should be able to transfer them into another position. This will be put into another section of the employee handbook. Letter c under posting process has a sentence that should read: Positions will be posted on City Hall bulletin boards.... and letter d it should say...no applications or resumes... . Letter a under Selection Process should say professional references rather than personal references. Somewhere it should be made clear in letter b that some of the tests are not performed until after the offer is made. Under the hiring recommendation/offer Alderwoman Spears would like the salary offer to be made at the minimum point of the salary range. She said that the City has a history of hiring well over the minimum point of the salary range. People who are overqualified get more money. The City Administrator has to approve any other offer than the minimum point of the salary range. The comments will be incorporated and this will come back to Administration on July 6t'. Additional Business: The new Finance Director starts on June 7t'. Tracy Pleckham will be in working on a few things. She will have a bill on the next bill list. There will be documentation of what she is working on. The meeting was adjourned at 9:02 pm. Minutes submitted by Laura Leppert. 06 � `,��0 C/ry Reviewed By: J? �� Legal ❑ City Council Finance ■ 1836 Engineer ❑ City Administrator ■ Agenda Item Tracking Number All Dept. Heads ■ , �AA 6�00b—qA <CE` `��?� Human Resources ■ City Council Agenda Item Summary Memo Title: Hiring Policy(non-department heads) City Council/COW/Committee Agenda Date: Admin. —July 6, 2006 Synopsis: Hiring policy for all positions not addressed by the recently approved department head hiring policy. Council Action Previously Taken: Date of Action: N/A Action Taken: N/A Item Number: N/A Type of Vote Required: N/A Council Action Requested: Discussion Submitted by: Bart Olson Administration Name Department Agenda Item Notes: Staff comments give justification for the individual section of the proposal, as well as highlights policy options. This policy would replace and add to the employee handbook as is noted on the individual sections. June 8, 2006 UPDATE: Comments from June 1, 2006 Admin meeting have been added to the previous document. Track changes and clean versions are included in the packet. D Clrj, ?` c� United City of Yorkville Memo 800 Game Farm Road 18M Yorkville, Illinois 60560 Telephone: 630-553-4350 ?O Fax: 630-553-7575 <<E"`vv Date: June&_2006 ,- Deleted:May 17 To: Administration Committee From: Bart Olson,Assistant City Administrator Denise Kasper,Payroll/Benefits Specialist Lynsey Johnson,Administrative Assistant CC: John Crois,City Administrator Subject: Update to the employee manual-non-department head hiring policy Currently in the employee manual Section 2.1.1 Recruitment(to be kept) It is the policy of the United City of Yorkville to afford equal employment opportunity in all personnel practices to all qualified individuals without regard to race,color,religion,sex,age, national origin,physical or mental disability,ancestry,marital status or veteran status(except those dishonorably discharged,all in accordance with applicable law. Section 2.1.2 Application(to be kept) Appointment and promotion to the positions in the City will be based upon merit and fitness. Selection methods will be based wholly on the job related references,aptitude,and adaptability. ISection 2.1.3 Selection(first paragraph and sections c and d to be kept, sections a and b to be deleted Deleted: to be kept,all else to be - - deleted Regardless of the number of applicants,selection methods shall be deemed competitive when the qualifications required are based upon education,experience and personnel standards established for the position. In such instances,a reasonable opportunity shall be afforded for qualified persons to apply,and the following procedures will apply to the recruitment of all personnel: a. When any non-exempt job vacancy occurs that has been approved by the Mayor and City Council,the Department Head shall post the job announcement,internally and externally, stating the title,salary range,job description,manner of application,and closing date for application. b. After reviewing applicant qualifications,and/or holding personal interviews,the Department Head shall conduct a background check(Appendix C)before making the conditional offer of employment to the applicant deemed best suited for employment with the City. The Department Head may conduct any other required pre-employment screening after the conditional offer of employment has been made to the applicant,such as: medical and/or psychological test. The Department Head shall hire only applicants Mlew,¶ who have passed all pre-employment testing. The Department Head will notify the <#>Imerim Appointment¶ <#>When a vacancy exists in a regular Finance Director of the hiring and copy the City Administrator. City position or a department is made c. While current full-time City employees are encouraged to apply for appointment to aware of an impending vacancy,the positions for which the are qualified,the City reserves the right to hire external or department director shall notify Hunan I� Y q tY Resources. If a vacancy occurs in a internal applicants for any or all vacant positions. Accordingly,position announcements position which,from the standpoint of may be posted internally and/or advertised before a position is filled. the business can not ss left vacant for Y I� Y P the period of time necessary to conduct a d. An employee of the City may request,or be requested,to transfer to another position recruitment and selection process,the within the Ci department director,with approval of City. Human Resources and the City Administrator,may appoint a current New Policy hentatively as Section 2 L 4 and beyond devendine on final avvroval ofvolicy) employee to fill the vacant position in an acting capacity. The duration of such an appointment shall be only until a 1 Applicability other policies,reagreements lations,and permanent appointment can be made' 1� tY to PNormally,acting appointments shall not a. Whenever the provisions of this policy are in conflict with state or federal be more than three months in duration regulations or a collectively bargained agreement between the City and a certified with the exception of department director r positions. Employees performing the bargaining unit,the provisions of the collective-bargained agreement and/or duties in an interim period shall be governmental regulation will revaiL compensated at 10%above their current g prevail. except for individuals acting as interim Police Chief,Director of Parks Staff note: This allows the police contract to remain intact. and Recreation,or City aced t the rate which shall be compensated at the rate of the salary of the prior individual who held the position.¶ _ _ _ _ __ _ _ _ --- --- --- ------- -- - -------- I r - Staffnote: This section it applicable to 2LApproval to Recruit Personnel �' all positions within the City.¶ a. If the position is approved with the adoption of the annual operating budget and ¶ the position has an approved job description,recruitment may begin at the budget Other cities'policies rangefrom designated point for new positions,or immediately for existing but vacant compensating the interim person 100%of � the prior individual's salary,to a flat 5% positions. If the position is not approved with the adoption of the annual to no policy. The proposal regarding operating budget,the requesting department must provide Human Resources with compensation is highly discretionary— the considerations for the policy as written justification as to the need,reasoning and financing of the new position. written is that 5%is too low to offset the This information will be forwarded to the City Administrator for review and/or additional responsibilities ofan interim appointment,and that the three positions approval. If the City Administrator approves the request,it will then be submitted listed are ofsuch significant nature that full compensation ofthe prior individual for City Council review and approval. should be given. All decisions on the compensation section should be Staff note: Addition of internal justification process will provide an extra and formal step in the considered with the proposal for the ' approval process and the fact that interim review for new jobs before presentation to Council. appointments are likely to be uncommon infrequency.¶ 1 Formatted:Bullets and Numbering Posting process •--- Formatted:Bullets and Numbering armor Internal Hiring: Application must be made through Human Resources. ,_ - Deleted:<#>Departmental Candidate Human Resources will announce the position opening to all City personnel via Hiring: Departmental candidates roust take resume directly to their supervisor or email and by posting notices on City Hall bulletin boards. City departments will department director for consideration of be responsible for posting the position announcement to their respective departmental position vacancies. If a qualified departmental candidate is the departmental personnel to assess interest and qualifications of internal candidates. best match to fill the vacancy,no formal Announcements for internal postings will be open for a minimum of five working requitement is necessary and the department director may proceed to hire days. If no qualified internal candidates are available,the department director the candidate through Human Resources. may consider external candidates. If no qualified departmental candidate is available,the department director may consider any qualified internal candidates.¶ b. For External Hiring: Position opening will be announced by Human Resources, and will be open for a minimum of ten working days. Applications and/or resumes must be made through Human Resources. Posting will be made available on City Hall bulletin boards and other means as Human Resources and the department directors decide to generate the best pool of qualified candidates. Announcements shall summarize the primary duties of the position,standards for consideration,compensation,and application deadline. c. For all hiring processes,no applications will be accepted after the closing date. Staff note: Prior handbook policy outlines a process for non-exempt positions only. This addition would apply to both non-exempt and exempt positions, except for the Department Heads,which are outlined in the hiring policy which is under consideration on May 23'x. 4) Selection Process --- Formatted:Bullets and Numbering a. Human Resources and the appropriate department head and/or supervisor will base the selection on the requirements and qualifications established for the position and the relevant work experience,technical knowledge,educational background,general aptitude,maturity,compatibility and personal and professional references of the candidates. b. Aside from the screening process,selection techniques may include oral interviews,reference checks,written examinations,medical examinations, physical agility tests,psychological evaluations,performance evaluations, assessment centers and other measures considered relevant to the job and reliable as a predictor of performance. Staff note: Section b outlines the techniques which may be used by the HR dept. and the supervisor in selection. While interviews would be the most logical and often used tool for selection,physical tests, written tests,psychological tests, etc. might be necessary for certain positions(i.e.public works maintenance workers,police officers, etc.). At this point, leaving the policy open-ended allows the management to be flexible to unique hiring circumstances. Hiring recommendation/offer ---- Formatted:Bullets and Numbering a. Pending selection of a final candidate,an offer sheet and a background check waiver form shall be sent out by Human Resources. A salary offer will be made within the approved salary range for the position with review and approval by the City Administrator,except for salary offers made at the minimum of a range, which do not require City Administrator approval. b. With acceptance and return receipt of offer sheet and background check approval form,the background check will be administered. After passage of the background check,new hire orientation will be completed and rejection letters will be sent out to the pool of applicants. Staff note: Section A outlines how the salary offer will be made. City Administrator approval will be required for all positions except for minimum of ers, Ill Oddod balsam 6181200610:06:00,AM Interim Appointment When a vacancy exists in a regular City position or a department is made aware of an impending vacancy, the department director shall notify Human Resources. If a vacancy occurs in a position which, from the standpoint of City business, can not be left vacant for the period of time necessary to conduct a recruitment and selection process, the department director, with approval of Human Resources and the City Administrator, may appoint a current employee to fill the vacant position in an acting capacity. The duration of such an appointment shall be only until a permanent appointment can be made. Normally, acting appointments shall not be more than three months in duration with the exception of department director positions. Employees performing the duties in an interim period shall be compensated at 10% above their current salary, except for individuals acting as interim Police Chief, Director of Parks and Recreation, or City Administrator, which shall be compensated at the rate of the salary of the prior individual who held the position. Staff note: This section is applicable to all positions within the City. Other cities'policies range from compensating the interim person 100%of the prior individual's salary, to a flat S%, to no policy. The proposal regarding compensation is highly discretionary—the considerations for the policy as written is that S%is too low to offset the additional responsibilities of an interim appointment, and that the three positions listed are of such significant nature that full compensation of the prior individual should be given. All decisions on the compensation section should be considered with the proposal for the approval process and the fact that interim appointments are likely to be uncommon infrequency. Co.c United City of Yorkville Memo 800 Game Farm Road WT.. -ism Yorkville, Illinois 60560 Telephone: 630-553-4350 Fax: 630-553-7575 <LIE Date: June 8, 2006 To: Administration Committee From: Bart Olson, Assistant City Administrator Denise Kasper, Payroll/Benefits Specialist Lynsey Johnson, Administrative Assistant CC: John Crois, City Administrator Subject: Update to the employee manual -non-department head hiring policy Currently in the employee manual Section 2.1.1 Recruitment(to be kept) It is the policy of the United City of Yorkville to afford equal employment opportunity in all personnel practices to all qualified individuals without regard to race, color, religion, sex, age, national origin, physical or mental disability, ancestry, marital status or veteran status (except those dishonorably discharged, all in accordance with applicable law. Section 2.1.2 Application(to be kept) Appointment and promotion to the positions in the City will be based upon merit and fitness. Selection methods will be based wholly on the job related references, aptitude, and adaptability. Section 2.1.3 Selection(first paragraph and sections c and d to be kept, sections a and b to be deleted)) Regardless of the number of applicants, selection methods shall be deemed competitive when the qualifications required are based upon education, experience and personnel standards established for the position. In such instances, a reasonable opportunity shall be afforded for qualified persons to apply, and the following procedures will apply to the recruitment of all personnel: a. When any non-exempt job vacancy occurs that has been approved by the Mayor and City Council, the Department Head shall post the job announcement, internally and externally, stating the title, salary range,job description,manner of application, and closing date for application. b. After reviewing applicant qualifications, and/or holding personal interviews, the Department Head shall conduct a background check(Appendix C)before making the conditional offer of employment to the applicant deemed best suited for employment with the City. The Department Head may conduct any other required pre-employment screening after the conditional offer of employment has been made to the applicant, such as: medical and/or psychological test. The Department Head shall hire only applicants who have passed all pre-employment testing. The Department Head will notify the Finance Director of the hiring and copy the City Administrator. c. While current full-time City employees are encouraged to apply for appointment to positions for which they are qualified, the City reserves the right to hire external or internal applicants for any or all vacant positions. Accordingly, position announcements may be posted internally and/or advertised before a position is filled. d. An employee of the City may request, or be requested, to transfer to another position within the City. New Policy (tentatively as Section Z L 4 and beyond, depending on final approval ofoolicy) 1) Applicability to other policies, regulations, and agreements a. Whenever the provisions of this policy are in conflict with state or federal regulations, or a collectively bargained agreement between the City and a certified bargaining unit, the provisions of the collective-bargained agreement and/or governmental regulation will prevail. Staff note: This allows the police contract to remain intact. 2) Approval to Recruit Personnel a. If the position is approved with the adoption of the annual operating budget and the position has an approved job description, recruitment may begin at the budget designated point for new positions, or immediately for existing but vacant positions. If the position is not approved with the adoption of the annual operating budget, the requesting department must provide Human Resources with written justification as to the need, reasoning and financing of the new position. This information will be forwarded to the City Administrator for review and/or approval. If the City Administrator approves the request, it will then be submitted for City Council review and approval. Staff note: Addition of internal justification process will provide an extra and formal step in the review for new jobs before presentation to Council. 3) Posting process a. For Internal Hiring: Application must be made through Human Resources. Human Resources will announce the position opening to all City personnel via email and by posting notices on City Hall bulletin boards. City departments will be responsible for posting the position announcement to their respective departmental personnel to assess interest and qualifications of internal candidates. Announcements for internal postings will be open for a minimum of five working days. If no qualified internal candidates are available, the department director may consider external candidates. b. For External Hiring: Position opening will be announced by Human Resources, and will be open for a minimum of ten working days. Applications and/or resumes must be made through Human Resources. Posting will be made available on City Hall bulletin boards and other means as Human Resources and the department directors decide to generate the best pool of qualified candidates. Announcements shall summarize the primary duties of the position, standards for consideration, compensation, and application deadline. c. For all hiring processes, no applications will be accepted after the closing date. Staff note: Prior handbook policy outlines a process for non-exempt positions only. This addition would apply to both non-exempt and exempt positions, except for the Department Heads, which are outlined in the hiring policy which is under consideration on May 23rd 4) Selection Process a. Human Resources and the appropriate department head and/or supervisor will base the selection on the requirements and qualifications established for the position and the relevant work experience, technical knowledge, educational background, general aptitude,maturity, compatibility and personal and professional references of the candidates. b. Aside from the screening process, selection techniques may include oral interviews, reference checks, written examinations, medical examinations, physical agility tests, psychological evaluations, performance evaluations, assessment centers and other measures considered relevant to the job and reliable as a predictor of performance. Staff note: Section b outlines the techniques which may be used by the HR dept. and the supervisor in selection. While interviews would be the most logical and often used tool for selection,physical tests, written tests,psychological tests, etc. might be necessary for certain positions (i.e.public works maintenance workers,police officers, etc). At this point, leaving the policy open-ended allows the management to be flexible to unique hiring circumstances. 5) Hiring recommendation/offer a. Pending selection of a final candidate, an offer sheet and a background check waiver form shall be sent out by Human Resources. A salary offer will be made within the approved salary range for the position with review and approval by the City Administrator, except for salary offers made at the minimum of a range, which do not require City Administrator approval. b. With acceptance and return receipt of offer sheet and background check approval form, the background check will be administered. After passage of the background check, new hire orientation will be completed and rejection letters will be sent out to the pool of applicants. Staff note: Section A outlines how the salary offer will be made. City Administrator approval will be required for all positions, except for minimum offers. CAD ClT�, Reviewed By: JZ 0 Legal ❑ City Council Finance ■ WE im Engineer ❑ +, y City Administrator 0 Agenda Item Tracking Number �O Consultant ❑ A ul LE Human Resources ■ City Council Agenda Item Summary Memo Title: Comprehensive Salary Survey Discussion City Council/COW/Committee Agenda Date: Admin—July 6, 2006 Synopsis: Discussion of results of Comprehensive Salary Survey Council Action Previously Taken: Date of Action: N/A Action Taken: N/A Item Number: Type of Vote Required: N/A Council Action Requested: Direction on policy questions Submitted by: Bart Olson Administration Name Department Agenda Item Notes: June 26, 2006 memo outlining policy questions should be discussed. Co.o United City of Yorkville Memo 800 Game Farm Road MT. ,ens Yorkville, Illinois 60560 Telephone: 630-553-4350 ,p 2p Fax: 630-553-7575 Date: June 26, 2006 To: Administration Committee From: Bart Olson CC: Subject: Comprehensive Salary Survey Combined Discussion Outline In an effort to streamline the Comprehensive Salary Survey discussion, I will first outline the policy decisions that need to be addressed,based off of the(attached) May 4h and May 12th memos, and include the justifications and supplemental information that was included in the May 4th and May 12th memos, after the outline of the policy decisions. I have made my best efforts to include all text from the May 4th and May 12th memo into this"combined"memo, and I have highlighted new sections with bold print. Two extra charts have been added since the last COW presentations. These charts format the salary survey data differently, and align them so that changes in individual position ranges based on different policy decisions are easier to see. One chart has observed values,which are the values that were taken directly from the salary survey data, and the other chart has implementation values, which is what the new salary ranges would become if the corresponding compensation level was selected'. Policy Decisions (for a recommendation to COW) 1) Is the information included in the packet sufficient to make a policy decision? a. If not how should the salary survey be revised? 2) Does the Admin. Committee wish to recommend implementation of the salary survey through salary range increases? 3) What is the compensation strategy that the Committee would like to recommend? 4) What does the Committee wish to recommend regarding possible individual salary increases? 5) When does the Committee wish to recommend implementation of the decisions made as a result of the survey? The difference between the observed and implementation values is that implementation values reflect ranges that will not decrease with a new compensation level. Meaning,if the minimum compensation level was selected,and the current range was higher than the selected range,the current range would stay(meaning no salary ranges will be decreased for any compensation level selected). Information to be used for decision making;—QUESTION 1 The direction received from Committee of the whole was to choose a set of comparable communities ahead of time, and discuss the compensation strategy of the City after the data had been compiled. A number of questions have been raised internally as a result of the decision to choose a set of comparable communities. Some of the job titles have received a strong response rate; some of the job titles have not received a strong response rate. Unfortunately, response rate and comparable positions is a weakness of choosing a group of comparable communities ahead of time, and may cause some of the conclusions and recommendations from the survey to be called into question. In studying potential solutions to the weak group data for individual positions, staff would still like to remind the City Council that the second methodology option of using online databases to strengthen the response rate is still available. However, doing so would likely require a couple weeks time for staff to re- compile the data. Also, in order to ensure equity between positions, expansion of the surveyed communities would need to be the same for all positions. Information to be used for decision making—QUESTION 2 The following items are presented for your consideration on implementing the salary survey: a) Benefits survey from the comparable municipalities outlining COLA increases, merit increases, total health insurance cost increases/decreases, and employee and employer health insurance premiums for health, dental, and vision insurance. b) Recent job postings have had mixed success in generating a large number of applicants. It appears the more technical fields (i.e. finance,planning) are having a harder time attracting applicants,while more general positions are attracting plenty of applicants. i. Park Planner— 10 resumes ii. Senior Accounting Clerk— 12 resumes iii. Urban Designer- 13 resumes iv. Finance Director— 15 resumes V. Operator—23 resumes vi. Parks Maintenance Worker—25 resumes vii. Sewer Maintenance Worker—30 resumes viii. Community Development Director—32 resumes ix. Executive Director of Parks and Recreation—38 resumes X. Recreation Program Coordinator—45 resumes xi. Administrative Assistant—50 resumes xii. Receptionist—50 resumes c) Being that Kendall County is the third fastest growing county in the nation, all municipalities within the region will be looking to attract highly qualified individuals to deal with a variety of issues that may or may not be related to growth. Competition for highly qualified employees between cities in the Kendall County area is likely to be strong. Also, competition between sub-regional areas within the greater Chicagoland region and the Chicagoland region and other national regions is likely to be strong2. d) The survey produced the following data: (i) Of all fields (actual and salary ranges), 62 of 91 (68%) are below the average of the comparables. (Yorkville compared to the average) (ii) Of salary range observations (low and high only), 52 of 62 (83%) are below the average of the comparables. (Yorkville compared to the average) (iii) Of salary range comparisons, 30 of 52 (57%) are less than negative 10%. (iv) Of 32 total positions, 24 show a comparison value to the mean that is negative, 5 show a split comparison(meaning one side of range is below mean, one side is above mean), and 3 show a comparison value to the mean that is positive (v) Two positions posted comparisons to comparables in the negative 30% range—Community Relations Manager and Payroll/Benefits Specialist. These two positions are recommended to be looked at in the immediate future to address major job function and compensation inequities. Information to be used for decision making—QUESTION 3 Option 1 —Include a flat percentage increase for all positions. Option 2—Include a variable percentage increase for all positions based on a desired compensation level in relationship to comparable municirlities a. Sub-option 2a—Choose a percentile(25t'or 75' percentiles) or observation level on the chart(i.e. median,min, or max)to adjust all ranges b. Sub-option 2b—Create a percentile not on the chart(i.e. 40 ', 60�') Supplemental Option(for use in either Option 1 or 2)—Different groups of employees have different compensation strategies. For example, Geneva recently finished a salary survey and implemented a new compensation strategy. The raises were only implemented for management employees. Any decision to address employee groups differently should be made in a context-sensitive manner—meaning the City should justify why they choose to pay one group of employees higher than another. It is recommended that any decision based on different compensation strategies between employee groups be limited to Dept. Head or exempt status only. Also, any decision on an individual position's range should be a result of a conscious strategy for service-delivery improvement(i.e. raise the range in highly desired service areas,like growth management,to attract extremely well qualified candidates). z Anecdotal evidence from several outgoing MPA students suggests that students are very mobile in their search for jobs,both infra-regionally and inter-regionally. Information to be used for decision making—QUESTION 4 Option 1 —Increase individual salaries only when the individual salary falls below the minimum value of the new salary range—the individual would receive an increase to the minimum value of the new range. - For example, an individual with a range of$1 to $3 and an actual salary of$2 with a new range of$3 to $5 would receive a raise to $3 Option 2—Increase individual salaries parallel with the range increase. - For example, an individual with a salary range of$1 to $3 and actual salary of$2 with a new range of$3 to $5 would receive a raise to $4. o An individual with a salary range of$1 to $3 and actual salary of$2 with a new range of$1.50 to $3 would receive a raise to $2.25. Depending on the policy decisions for Questions 3 and 4,the following budgetary impacts are estimated: Financial impact of different policy options (based on using the comparable municipalities data and the options outlined in the May 4 memo)based on an estimated FY 06/07 total FT salary budget of$4,176,395 are as follows: Using the underl3dn strategy trategy that actual increases are only given to the minimum of a range if an individual falls out of a salarrange as a result of increase Compensation Strate Total Increase in Total % Increase Sal ar in Salary Increasing each salary range to the minimum $4,113 0.1% observed values (only if the minimum observed value is greater than Yorkville's range): Increasing each salary range to be within the 25 $11,405 0.27% percentile of all observed comparable ranges: Increasing each salary range to be within the $41,896 1% median of all observed comparable ranges: Increasing each salary range to be within the 75 percentile of all observed comparable ranges: $82,405 1.97% Increasing each salary range to be the maximum observed value: $300,402 7.19% Increasing each salary range 10%: $22,374 0.54% Increasing each salary range 15%: $64,832 1 1.55% Using an underlyin strategy trategy that actual increases parallel the range increases Compensation Strate Total Increase in Total % Increase in Saar Saay Increasing each salary range to the minimum observed values (only if the minimum observed value is greater than Yorkville's range): $41,502 0.99% Increasing each salary range to be within the 25th percentile of all observed comparable ranges: $138,518 3.32% Increasing each salary range to be within the median of all observed comparable ranges: $279,878 6.70% Increasing each salary range to be within the 75 percentile of all observed comparable ranges: $439,186 10.52% Increasing each salary range to be the maximum observed value: $874,554 20.94% Increasing each salary range 2.5%: $75,105 1.80% Increasing each salary range 5%: $150,210 3.60% Increasing each salary range 10%: $300,419 7.19% Information to be used for decision making—QUESTION 5 Self explanatory,but options for consideration include implementation at time of revised budget(November),which may be difficult depending on the size of the city-wide salary increase, or FY 07/08,which would be easier, but might result in some individuals timeframe of initial request to decision on request to approach three years. co*c United City of Yorkville Memo 800 Game Farm Road EST. `, x_:.1836 Yorkville, Illinois 60560 ti y Telephone: 630-553-4350 xl�t'+ $ : p Fax: 630-553-7575 SCE Date: May 12, 2006 To: City Council From: Bart Olson, Assistant City Administrator John Crois, City Administrator Lynsey Johnson, Administrative Assistant Denise Kasper, Payroll/Benefits Specialist Subject: Comprehensive Salary Survey Supplemental Memo A few items have been brought to our attention since the distribution of the 2006 Comprehensive Salary Survey Final Memo on May 4, 2006. First, the salary survey was initiated as a result of a number of employees expressing their perception of inequitable pay to their individual positions. Typically,these requests are handled via a survey(conducted internally) to address the merits of the claim and, if necessary, presentation to the City Council. The quantity and frequency of these claims have increased and became enough to justify a comprehensive survey(promotes efficiency in presentation, also). Comprehensive salary surveys are also a tool regularly used by organizations. Yorkville's last comprehensive salary survey was completed in 2003. Additionally, while some municipalities increase their ranges by the COLA every year(parallel to the individual increase for COLA), Yorkville has not implemented a range increase since FY 2003-2004. Second,the salary survey policy options were presented to City Council during a series of meetings. The first presentation identified the options of performing the survey in-house v. spending $10,000 to have a third-party conduct it. The Council was comfortable with staff conducting the survey and subsequently presenting the results to the Council for interpretation and policy discussion. At a later meeting, staff presented the policy options associated with methodology of the survey. The two sets of options were as follows: 1) Choose a set of comparable communities OR 2) Use all available data from a number of communities from online databases 3) Choose a compensation strategy ahead of time(i.e. define the ranking we wish to achieve in comparison to our surveyed municipalities) OR 4) Discuss the strategy after the data has been compiled The decisions on the options were to choose a set of comparable communities ahead of time, and discuss the compensation strategy of the City after the data had been compiled. At this time, a number of questions have been raised internally as a result of the decision to choose a set of comparable communities. Some of the job titles have received a strong response rate; some of the job titles have not received a strong response rate. Unfortunately, response rate and comparable positions is a weakness of choosing a group of comparable communities ahead of time, and may cause some of the conclusions and recommendations from the survey to be called into question. In studying potential solutions to the weak group data for individual positions, staff would still like to remind the City Council that the second methodology option of using online databases to strengthen the response rate is still available. However, doing so would likely require a couple weeks time for staff to re-compile the data. Also, in order to ensure equity between positions, expansion of the surveyed communities would need to be the same for all positions. In gathering the data for the survey, staff used a number of methods to collect the data: A) A number of online databases were scanned for data. a. When available,job descriptions were read to verify the comparability between the surveyed community and Yorkville. b. If no job description was available from the online databases and the data appeared to be invalid, staff contacted the municipality in question and asked for a copy of the job description. c. When all online databases were scanned, we sent the results to the municipality and asked for verification that the database was accurate. B) If the municipalities did not subscribe to an online database,the survey was sent to a number of staff members within the municipality. a. We attached each Yorkville position's job description executive summary for reference in choosing comparable jobs. b. When the data was returned, questionable data was reviewed by requesting a copy of the job description and asking for verification on the data submitted. Finally, after reviewing the May 4 memo, staff would like to reiterate that the final recommendation for the salary survey should be made with emphasis on the salary range, and only to address actual salary changes as a function of circumstance of salary range . Namely, staff is reminding City Council that the purpose of the survey is to establish competitive ranges, and actual salaries will only be changed in cases where the range modification leaves the actual salary outside the range—or in light of a policy decision by City Council to alter the actual salaries in accordance with the modification in range (i.e.if employee is at midpoint of salary range,increase in salary range yields a parallel increase to the employee to remain at the middle of the range). Staff is NOT making a recommendation to increase employee salaries to be externally competitive to other municipalities' actual salaries; in these cases,factors of seniority and merit increases would yield highly inequitable results. Financial impact of different policy options (based on using the comparable municipalities data and the options outlined in the May 4 memo)base I on an estimated FY 06/07 total FT salary budget of$4,176,395 are as follows: Using the underlying strategy that actual increases are only given to the minimum of a range if an individual falls out of a salary range as a result of increase Compensation Strategy Total Increase in Salary Total % Increase in Salary Increasing each salary range to the $4,113 0.1% minimum observed values (only if the minimum observed value is eater than Yorkville's range): Increasing each salary range to be $11,405 0.27% within the 25h percentile of all observed comparable ranges: Increasing each salary range to be $41,896 1% within the median of all observed comparable ranges: Increasing each salary range to be within the 75h percentile of all observed comparable ranges: $82,405 1.97% Increasing each salary range to be the maximum observed value: $300,402 7.19% Increasing each salary range 10%: $22,374 0.54% Increasing each salary range 15%: 64,832 1.55% Using an underlying strategy that actual increases aarallel the range increases Compensation Strategy Total Increase in Salary Total %Increase in Salar Increasing each salary range to the minimum observed values (only if the minimum observed value is greater than Yorkville's range): $41,502 0.99% Increasing each salary range to be within the 25th percentile of all observed comparable ranges: $138,518 3.32% Increasing each salary range to be within the median of all observed comparable ranges: $279,878 6.70% Increasing each salary range to be within the 75th percentile of all observed comparable ran es: 1 $439,186 10.52% Increasing each salary range to be the maximum observed value: $874,554 20.94% Using an underlying stratep-y that actual increases parallel the ranee increases (continued) Increasing each salary range 2.5%: $75,105 1.80% Increasing each salary range 5%: $150,210 3.60% Increasing each salary range 10%: $300,419 7.19% CO.c United City of Yorkville Memo 800 Game Farm Road ,sus Yorkville, Illinois 60560 Telephone: 630-553-4350 Fax: 630-553-7575 ALE Date: May 4, 2006 To: City Council From: Bart Olson,Assistant City Administrator Denise Kasper,Payroll/Benefits Specialist Lynsey Johnson, Administrative Assistant CC: Department heads Subject: Comprehensive salary survey update and policy discussion outline Enclosed is a copy of the 2006 Comprehensive Salary Survey. Results were gathered from a number of online databases and contacting individuals within each municipality. If information was gathered via online database, we asked the staff for the municipality to verify the information. When available,job descriptions for each position were reviewed by staff to make sure the essential job functions were substantially similar to Yorkville's positions. The document is set up as follows: a) Column of municipalities, or for Parks and Recreation, departments and districts l. b) Columns of titles of position,with information on the salary range(where applicable) and actual salary of the individual or average of the group of individuals under the title c) Highlighted row of average of all salary ranges and actual salaries that are above the highlighted row d) Row of Yorkville's current ranges and FY 05/06 actual salaries (no COLA/merit adjustment) e) "Comparison"row is calculated by taking the values in the"Average"row and dividing it by the values in Yorkville's corresponding row and subtracting by 1. f) "Observations" at the bottom of the chart includes: a. Minimum—lowest value observed in the responses (not including Yorkville) b. 25a'percentile—returns median value between lowest value and normal median value c. Median—returns middle observed value between lowest value and highest value d. 75'percentile—returns median value between normal median value and highest value e. Maximum—highest value observed in the responses (not including Yorkville) 1 Due to several neighboring municipalities not having a parks and recreation department or district and/or being part of the same district(which may or may not be comparable),a few of the comparable organizations have been replaced for the Parks and Recreation department positions. The following information items are provided for your deliberation before the presentation and discussion of this document during the May 16a' Committee of the Whole Meeting. 1) Benefits survey from the comparable municipalities outlining COLA increases,merit increases, total health insurance cost increases/decreases, and employee and employer health insurance premiums for health, dental, and vision insurance. 2) National turnover rates for an 8-month period is between 1.7% and 3% - of the 70 full- time employees employed by the City, 8 full-time(and one part-time, not included within the average) employees have resigned in 8 months. This yields an 11.4% average,more than 3 times the national average. Unfortunately, exit surveys by these eight individuals were not obtained, and thus no conclusions on the role of how compensation and benefits played into the decision to resign can be made. Using informal information, four of the eight individuals included in this list resigned to take more responsible or higher paying jobs with other municipalities or non-profit groups. 3) Recent job postings have had mixed success in generating a large number of applicants. It appears the more technical fields (i.e. finance,planning) are having a harder time attracting applicants,while more general positions are attracting plenty of applicants. a. Park Planner— 10 resumes b. Senior Accounting Clerk— 12 resumes c. Urban Designer- 13 resumes d. Finance Director— 15 resumes e. Operator—23 resumes f. Parks Maintenance Worker—25 resumes g. Sewer Maintenance Worker—30 resumes h. Community Development Director—32 resumes i. Executive Director of Parks and Recreation—38 resumes j. Recreation Program Coordinator—45 resumes k. Administrative Assistant—50 resumes 1. Receptionist—50 resumes 4) Being that Kendall County is the third fastest growing county in the nation, all municipalities within the region will be looking to attract highly qualified individuals to deal with a variety of issues that may or may not be related to growth. Competition for highly qualified employees between cities in the Kendall County area is likely to be strong. Also, competition between sub-regional areas within the greater Chicagoland region and the Chicagoland region and other national regions is likely to be strong2. 5) The survey produced the following data: a. Of all fields (actual and salary ranges), 62 of 91 (68%) are below the average of the comparables. (Yorkville compared to the average) - b. Of salary range observations (low and high only), 52 of 62 (83%) are below the average of the comparables. (Yorkville compared to the average) 2 Anecdotal evidence from several outgoing WA students suggests that students are very mobile in their search for jobs,both intra-regionally and inter-regionally. c. Of salary range comparisons, 30 of 52 (57%) are less than negative 10%. d. Of 32 total positions, 24 show a comparison value to the mean that is negative, 5 show a split comparison(meaning one side of range is below mean, one side is above mean), and 3 show a comparison value to the mean that is positive e. Two positions posted comparisons to comparables in the negative 30%range— Community Relations Manager and Payroll/Benefits Specialist. These two positions are recommended to be looked at in the immediate future to address major job function and compensation inequities. Using these information items,the following policy questions should be discussed: 1) Does the City wish to make an adjustment to current salary ranges? a. Option 1 —Include a flat percentage increase for all positions. b. Option 2—Include a variable percentage increase for all positions based on a desired compensation level in relationship to comparable municipalities i. Sub-option—Choose a percentile(25th or 75h percentiles) or observation level on the chart(i.e. median,min, or max)to adjust all ranges ii. Sub-option—Create a percentile not on the chart(i.e. 40th, 60th) c. Option 3 —No increase. 2) If the answer to question 1 is Option 1 or Option 2,how does the City wish to address individual salary increases? a. Option 1 —Increase ranges only. If an individual falls outside of the new range, give the individual the minimum range value. b. Option 2—Increase actual salaries in relationship to the increase in the range(i.e. if employee was at mid-point of old salary range,they would be increased to be mid-point of new salary range) Given the above information, staff is recommending Option 2 for both policy questions(no sub- option chosen for policy question 1, sample calculations based on variations on compensation levels to be attached and presented). If you have any questions or comments,please do not hesitate to contact Denise, Lynsey, or Bart. Inited City of Yorkville Salary Survey May-June 2006 Job Title Current Range �Iq�IIII III U 25th Percentile* Median* al 11=111111M 75th Percentile* 1111111111 111III 11111 irnpiementetio tilin lmpiementatian Percent lrtpleme tatian irnpiemen ati4n Percent lrrznplementation Percent Min tra Percent inane se €narease %fla C Pt rcent in increase increase allIllIll.IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIMIIIIIIIIIIIIIIIIIIIIIIIIIII Low High Low high ��� Low High ��r Low High Low High Ooh 318 0 43 628 18 4 . 2% 34,755 51,417 29°Iv . 20% 40,366 ' 56,987 50/0 " 33% �.rating C1 `k t , - . 26,910 .. 42.820 29,952 42,8203 11% 0% 3t485 42.820 17 ° ° 6> 32.085 43,675 32,085 43.675 0% 0°° 32,165 44,829 0°l° ';5:898, 48.431 11% 39,787 54.690 24% 25°/`c 43;838 59,658 37% I u/ c34% cl54% 15% 6 6 64% 41% Adrt�ittstrativSecr+�tai -" 26,9103 42,82{3 31,4 : " " 44,034 17:1° 3% 32,798 4.6,237 22 ° til° 36,0332 48,03003 i`" 12�° - 41>554 49,011 44,156 f ,3 Assn st;tntCityAdministrat.or 60.000 80.000 63,669 85,000 6% 6% 64;33587.844 10% 67,126 93,088 MBE 6% 71,592 100.533 19% 26% 78,184 110.378 30% 38% 0% ci� ° 13% 11% 23% 16% "" 37°c Chief of#�o3sc - - � 65 078 � ,J1S " 615,078 � f�6i,916 ! 0% 69>307> 93.97 2 6�� �'° 73626 98,8 3 80,369 100,4; 9 85,060 "�'i 119,462 .. - ;31% i City Administrator 76,004 107,023 76,004 107,023 0% 0% 80,193 108.394 6%_ 85.201 113,788 12% 6% 91,387 117,718 20% 10% 109,809 155,025 44% 45% Ci ineer 59 84 1 S{3 " .59 7 84 150 0%7a 0°. 59,760 84,150 . 0% 0% ,6136 90,502 . 10% 8% '74;284 105,385 .24% 25% " 80,000 115,000 -"34°x° - 37%° , Common€ty Deveioprnent Director 72;000 95,0100 72.000 95,000 0% 0% 72,000 95.000 0% 0% 72,000 95,000 0% 0% 72,849 98,509 1% 4% 78,184 110,378 9°l° 16% 38% 24% 50% 34% 63% c 75% 4> 70 410 87% :: 64% Common[ Rlatitsns manager 265,91[3 42,8213 . 37214 53.162 40,484- 57,474 ':43,764 6"x,786 44,�� 47023 .' 66,098 54!4 5%3,293 , Director ofPublic Work_s 62,972 82,204 62.972 82,204 0% 0% 63,523 82.204 1% 0% 68,777 91,801 9% 72.075 96.005 14% 17% 84,619 119,462 34% 45% . 26% 26% .. ° ° 30% 26% 30% 26% " 30% Eng�neerlrsg dmtnsstratt�ris Assistant 32,085 :: 43,675 40,366: 56,987 .;. 30% 403,366„ 56r,987 301° 40,36565 5 ,987 2.614.: � , 40��665 56,9$? " 40,366 56,987 Engineering Technician 37,260 MEM 40,320 53,524 8% 0% 42.214+:1111=gal 1 13% 0% 44,575 54,915 20% 3% 46,533 58,133 25% 9% 47,218 66,661 27% 25% 6% 2% 410% 17% 26% ° 2604 ~�. 4 6 203 ..:.. 15% 74 313 i [034 912 FinanceF�ir �dr " � -" 59,975 � 83,325 59,175 3„325 - 0�0 OIc, :62,743: 84,78 a �", 68575 9 .8 1 � 16 , 7 95,770x CS Coordinator 41,000 57,000 41.000 57.000 0% 0% 41.000 57:000 0% 0% 41.000 57.000 0°=rc 0% 42,213 59.377 3% 4% 47,218 66,661 15% 17% 1,4ec ianio' 37,140 50,232 37,140 50,232 0% 0% 41,120 52,583 11% 5°1. 42.000 55,219 13% 10% -- 43,255 - ; 57,691 16% 15% 46,155 61,390 " 24% 22°Ic Office Assistant 26,910 42,820 26,910 42.820 0% 0°c 27.300 42.820 aIIIIIIIIIB 0% 30.232 42,820 12% 0°,�c 31.057 43,751 15% 2% 42.738 60.336 59% Operator 39,330 52,454 39,330 52,454 0! 0% 39,330, 52,454 i 0% 0% 40,215 52.748 2% 1% 42,505 56,301 8% 7% 43,485 61,390 11% 's 17% Payroll Benefits Specialist 26.910 42,820 33,729 46,379 25% 8°rc, 38,831 52.963 44% 24°fo 40,836 56,306 31% 46,631 66,935 73% 56%Miltal 72,738 91% 70% tot`ce0% 0% 1 1 °d 5% 62 511 8�494 17% 14% 64 500 87 373 20% 21% 69,111 95,692 29% ` 33% P t ,Lteuteni�rtt . ." 53,652 72x2013 53,652' 72,2030 ' 60,06. 75,793 : 2.4 , , , Police Office Supervisor 34.096 48,172 34,096 48,172 0% 0% 34.096 48.172 0% 0°/c 36,429 48,172 7% 0% 40.931 56,987 20% 18% 42,624 61,704 25% 28% Prance Records Cleric. . 26,910 42,820 26,910: 42,820 034/4 0% 26,910; 42,820 0% 0% 28.816 42,820 7% 0% 30,046 42,820 12% 0% . 40,366 . 56_,987 50% 33% Police Sergeants 46.506 62.088 46.506 62.088 0°/c 0% 53.206 67,298 14°° 8°e 58,189 72.583 IIIIEINiiialilla 61,785 MIMI 33%Mill 67,042 87.600 44% 41% 0% 0% °• °r 4 57. 0% 0% 41.000 57,000" 0% 0% -4 000 57,000 0% 0% Publir3trtprcarrlen. '3'ect�nicia€t 41,000 57,000 41,000" 57,0030 ; 41,071303; 57,03010 OIa 03,e 1,00 2 ,03070 _ . Pkv Foreman 45,550 59,989 45,550 59,989 0% 0% 45.550 59.989 0% 0% 11�' 59,989 0% 0% 46,918 64,083 3% 7% 47.877 67,950 5°I0 13% PWMW1 29,900 41,749 29,990'' 41,749 t}°Ic l°l4 31,0x76 43,749 6% (7°4 33280 44,145 11`0 6% " 33,603 47. 12% 15% 39,250 55,9(13 31% 32% • IIIII,r 47,101 MEM 47,101 0% 0'/c 36,167 i� 6°'c 0°'i 51,081 9'/c 8% 38,002 52,892 11% 12% 43.485 61,390 27% 30%, Receptionist 20,800 27967 21,265 31.897 2% 14% 25,461; 34.874 22% 25°14 26,969 38,322 30% 37% 29,374 40,416 41% 45% 30,213 41,289 45°c 48% Senior Accounting Clerk 32,085 43,675 32,085 43.675 0% 0% 43,675 1% 0% 34,646 47,149 8% 8% 39,266 54,916 22% 26% 44,041 61,156 37% 40% Sent Engineering i . 1% 4 1 1% 43694 61 375 7% 8% 41'234 ' 59,102 1% 4% 41;234 59,102 1% 4% 1? Eng � g Tchn caan 41,8030 57,000 41,234+ 59,102 < 41° "11,234- 59, 032. 4% , , Senior Planner 42.530 56,889 42,530 56,889 0% 0% 43.214 59,301 2% 4°% 44.721 62.920 5%IIIMONI 52,992 74,669 25% 31% 57,304 80,226 35% 41 c/c. 111131 Siliin Cierlc 26 910 42 820 26 910 42.820 0% 0% 29,660" 4 820 10% 0% 30,954 42,820 15% 0% 33,238 46,155 24% 8% 40,366 56,987 50% 33°l tY 9 , , Parks end Rec Director 61.300 86,319 61.300 86.319 0% 0°'o 67.303 86.319 10°ic 0% 69,480 90;520 13% 5°I° 71,500 91,848 17% 6% 85.000 130,000 39%11111111MI Program Superviser0Rec1 32,085 51,383 32,085' , - 51,383 0°4 0% 32,085 51,383 0% 0% 32,085 51,383 0% 0% 35,.147 53,336 10% 4% 42,405 55,974 32% 9%r Recreation Coordinator 32,085 51,383 32.085 51,383 0% 0% 32,085 51.383 0% 0% 32,085 51,383 0% 0% 32,085 51,383 0% 0% 32.085 51,383 0% 0c'/t, Supettitendent of Parks " 38,854 65,000 38,854. 65,000 0% 0% 43,464' 70,000 12% 8% 46,500 70,000 20% 8% 52;380 78,568 35% 21% 59.518 82,135 53% 26% Superintendent of Recreation 42.106 59,291 42,106 59.291 0% 0°c 42.106 61,476 0% 4% 43,458 66,476 3% 12% 49,430 71,476 17% 21% 50,000 75.000 19% 26% • Lynsey Johnson *Observed ranges do not include those which fall below current salary levels. United CitY o rve Eve t1ay June 2905 Job Tide Current Range ObservedMinimum Levet O e€ ed 25th Peree€ tUe O served t Eediart Observed 75th Percentile Observed t iaximum Min Max Mini Max Min Max Min Max Min Max Min Max ca nti g r 1:. . 26.918: 42,820 2693''696592' ,952 36,133' 31,485 40,183' 31.868 43,628 . 34.755 51, 17 0,366 56,987.. Administrative ' ss "t 32,085 43,675 2$.2$8 39.503 32,165 ;4.829! 35,898 48,431 39,787 54,690 43,$38 59,658 Adrr�irrtstrataysSe r taty 6.910 4 ,820 ` 31,488 44,03 32,798 45237 38,032 48.8130 4797742111'':.'2855384948:4927_7 1,554 49,831, 4 ,156 8{3.3 Assistant City Administrator 60,000 80,0t30 63,669 15,000 64,335 87>844� 67,126 93,888 71,592 100.533 7$,1$4 110,378 Chief ot.F olio 15,87$ . 88,916' 59,860 7$,361 68639402'''.')311°963775563 9,367 93972 7663835687',:'66°21323°266621,:. 3,626 96,813 80,369 '111°°°°6956037':':340375°82931995838: 013, 29 85,£3613' 19,402: Chief ominisiratcr 76.004 107,023 72,466 100,112 80,193 174:08358,8,9238379:47: 98394 85,201 113.7$8 91.387 117,718 18857°5°485°9'''',..8°2881°698°,1°°4993' 09,809 155,025 CityEnaneer - 59.7 3 '""- $4.160 52>$75 74,848' 56.197 788 55,631 .502 74, 84 1 }8,3$5 ,0 0 15.000 Community Dcelcpment Director 72.000 95,004 66,793 $9.550 68,299 :71,';42970149,i 1,019 9 93,767 72,849 98,509_ 7$,1$4 110,37$ Gc�rn:ssurzity Peta 1st ara er 26,919, 42,828 37,214 53,`162 40,484 T :7',474' - 46839".',7765_3(87',354 . 5 ,7$6 47,023, 6 ;098 50,293 70,4 1}' Director of P rbhc .'corks 62.972° $2,204 54,445 68,959 63.523 82,204 91,801 72,075 96,005 84;619 119,462 t. rs eneerng drn tgistrative assistant 32,085, 43,675, 4}.366, 56,98 4648342023,-,,'735284625136433 0,3856 58,9$7; 40.3 ' 5696f:79°867', 6987 413.36£5 56,987 4 3,388 54,9871 Engineering Technician 37.260 53,524 40,320 47,009 42.214 53,524 44.575 54.915 +8,533 58,133 47.218 66,881 F nance Drect-r 59,175 83,325 51,6109 73,607' 62,743 84,785 68,573 91,841 095568',,_°,10730,.)b 5,770 7'4:7',3281116358 4,313 104,912" S S Caordinc or 41,000 57,000 31,897 47,846 34,553 49989 40.901 56.799 59,377 47,218 66,661 t.'lec-an• c 37x140' 50„232 37,140 50,232" . 41,120 5;85,24206,359759'8886234957,,' 2583 42,000 55.219. 46443396211,'.226025°53157371:4.. 5854587793::,673373097573711.r 7,691. . 465.155 61,390 Office Assistant 26,910 42,820 26,395 34,444 27,300 42.820 30,232 42.821? 43,751 42,738 60,336 Operator 39.33°' 52,454. 33,992 45,5523 37,070 .52.250 4{3,215 52.74$. 42.505 56.341 48,485 61.390; Payroll Benefits Specialist 26,910 42.822' 33,729 46,379 38,$31 52,963 40,836 56.306 66,935 51.523 72,738 notice Lieutenant l 53,652 F: 7 ,200 49,495 - 52 495 60,061 75.793 62.511+ 82 494 64,513037=373 89,111' 95,692 Police Office Super icor 34,096 48,172 31.866 38,501 32,341 39.915 38.429 , 40.931 56,987 42.624 61,704 notice 3Zai rrds Liar 26,910' 42,820 24,019 31,619, 26.744 34,29$ 28,516 445'2498.,.:8,1_1425700:2,, 31.045' 42,023 40,368.; 66,007 Police Sergeants 46,506 62,08$ 43,569 53.879 53,X16 67,29$ 58,189 72, 861,785 77,257 67,(342 87,800 Punticlrnfsr r arrents ectatvcian 41',0013 :< 67,0013 41,800 57, 41,01 0 57,200 41,C1t31, 57,0 341.000 57,000' 41,000 `- 57.000 Pvt+Foreman 45,550 59,989 31'676, 1,676 _ 38.842 52;819 44.107 46.918 64,0$3 47,877 67,950 Mi t 2 ,900. `- - 41,749 29.1 0 3464,633°08, 31.676 41'701' 1> 49� 33.250 34338369:,..69020061263 3,8103 45759277.,,8821,04052672,;, 7,i46� 39,2-591 65,003' Pb'tzttw 11 34,155 47,101 33,259 42,034 36,187 43574.8147149-- 7,101 37.213 51-981 38.092 52,892 43,4$5 81,390 Receptlonst 20,800 27,967 _ - 21,26153 31,897 255461 34,$74 233673,:92268:°693\ 6.96938_322` 29.3'4 40.4165 3L3,213 41.289. Senior Accounting Clerk 32.085 43,675 30,311 38,147 32.323 43,675 34.646 47,14 39.266 54.916. 44,041 61,156 SeniorEmneeringTechnitsan 41,000 57,000 41,234 59,102 41,234 59,102 43,694? 61,375. 41,234' 59102' 434014,,,,,2204_143,1, '1,234 59,102. Senior Planner 42,530 56,8$9 42.530 56.889 43,214 59,301 44.721 62,929 52,992 74.669 57.304 80,226 Utipity Bitting eri 26,910; 42,820 25,3991 33.852 29,600 42,820 30.954 42,$21 33,238" 48;155, 48,366 56,987 Parks and RecDi ctor 61,300 86,319 51,605 64,130 67,303 85,000 69,480 99.520 71,500 91,84$ 85,000 130,000 Programs 5r er isor(Rec) 32,485 5:"1,383 25,00 7 k 40.000 28,738 45,1190: 30.909 45.000 ;35,147 53,336 42,405 55.974 pipv {ecreatian Cocrttinator 32,085 51,383 25,875 40,000 27,406 40.000 25,875 40000 30.469 -"0,000 32.000 40,900 tzp iers ierit of Pat 38,854 65,000 38.854 6i5,8t 43,464 78,1100 46,500 78,(3138 52,3813 18,568 59,518. 82,135' Super3ntendernofRecreation 42,146 59,291 35,000 55,000 37,937 61,476 43,458 66.476 49,430 71,476 50,000 75,090 Lynsey Johnson UNITED CITY OF YORKVILLE 2006 Comprehensive Salary Survey City Accounting Clerk I Administrative Assistant Administrative Secretary Assistant City Administrator Low High Actual Low High Actual Low High Actual Low High Actual Batavia 31,345 43,222 32,760 45,177 69,252 95,488 Chanahon 33,882 44,156 49,019 Crest Hill 32,323 36,733 Elburn 37,187 52,834 Geneva" 40,366 56,987 42,738 IL,60,336 78,184 110,378 Huntley Lemont* 32,391 46,225 63,669 90,688 Lockport 36,575 41,379 Montgomery* 43,838 59,658 36,032 49,035 Morris New Lenox** 31,488 44,316 1 31,488 44,316 North Aurora 31,720 44,034 40,310 55,973 43,458 31,720 44,034 Oswego Plainfield 29,952 41,933 37,000 28,288 39,603 38,000 Plano" Sandwich Shorewood 32,000 50,000 49,733 47,507 52,500 South Elgin* 39,612 54,263 54,263 Sugar Grove* 36,795 50,636 Sycamore(*K***) 31,250 38,434 38,434 35,000 45,000 40,000 38,000 48,000 65,000 85,000 68,000 AVERAGE 33,268 45,522' 39;125 _35,965 49,459 44,101 36,699 48,560:' 69,026. 95,389 60,250'. Yorkville 26,910 42,820 32,240 32,085 43,675 39,000 26,910 42,820 34,570 60,000 80,000 65,000 Comparison -19% -6% -18% -11% -12% -12% -27% -12% -13% -16% 8% Observations Minimum 29,952 36,733 33,882 28,288 39,603 38,000 31,488 44,034 0 63,669 85,000 52,500 25th 31,485 40,183 36,575 32,165 44,829 40,345 32,798 45,237 64,335 87,844 56,375 Median 31,860 43,628 37,000 35,898 48,431 42,419 36,032 48,000 67,126 93,088 60,250 75th 34,755 51,417 38,434 39,787 54,690 46,495 41,554 49,031 71,592 100,533 64,125 Maximum 40,366 56,987 49,733 1 43,838 1 59,658 54,263 44,156 60,336 0 78,184 110,378 68,000 * Percentage increase in range ** Percentage increase in position Italic:New fiscal year will not start until June or g p July. Updated May 2006 ***Ordinance was passed establishing gold:Proposed figures. management salary and ranges. UNITED CI I'Y OF YORKVII,1[,E 2006 Comprehensive Salary Survey Chief of Police City Administrator City Engineer Community Development Director City Low High Actual Low High Actual Low High Actual Low High Actual Batavia 75,625 104,275 120,000 65,636 90,502 66,270 91,376 Chanahon 87,241 86,080 70,000 Crest Hill 78,361 Elburn 59,890 83,258 72,466 100,112 , Geneva* 84,619 119,462 109,809 155,025 72,378 102,180 78,184 110,378 Huntley 66,699 94,085 96,200 121,385 Lemont* 73,626 96,221 73,623 96,113 Lockport 91,451 95,000 67,925 65,000 Montgomery* 72,994 99,335 96,162 112,350 67,487 91,841 78,654 Morris New Lenox** 93,600 127,683 103,646 North Aurora 70,145 97,404 97,404 73,390 101,910 80,000 Oswego 85,060 106,325 98,175 95,692 116,957 120,000 69,111 95,692 80,000 Plainfield 79,075 110,705 104,751 85,401 120,000 120,000 57,304 80,226 77,000 72,075 100,905 91,000 Plano** 66,950 82,400 72,306 Sandwich Shorewood 93,059 100,435 72,114 South Elgin* 84,249 100,429 90,890 89,952 112,575 108,394 70,166 90,197 90,202 Sugar Grove* 70,092 93,972 82,461 110,555 52,875 74,840 66,793 89,550 Sycamore(*)(***) 75,000 95,000 87,350 85,000 115,000 113,000 80,000 115,000550 112 � .. OYOUG 4;1 �66 .07 2 ,3 ';';'92;3132,:,; 86,771 116,517 108,694 65,639 , 92,550, -'90 2$�1'r.'`.:4;8,484 s 'il041 .�"4#3,S Yorkville '1 65,078 86,916 89,295 76,004 107,023 59,760 84,150 84,210 72,000 95,000 79,000 Comparison -12% -11% -3% -12% -8% -100% -9% -9% -7% 2% -1% 1% Observations Minimum 59,890 78,361 72,306 72,466 100,112 80,000 52,875 74,840 67,925 66,793 89,550 65,000 25th 69,307 93,972 90,005 80,193 108,394 97,718 56,197 78,880 74,731 68,299 91,019 71,057 Median 73,626 96,813 93,330 85,201 113,788 112,675 65,636 90,502 90,323 69,639 93,767 78,654 75th 80,369 100,429 96,501 91,387 117,718 120,000 74,284 105,385 105,872 72,849 98,509 85,101 Maximum 85,060 119,462 104,751 109,809 155,025 127,683 80,000 115,000 112,550 78,184 110,378 91,000 UNITED CITY OF YORKVILLE 2006 Comprehensive Salary Survey City Community Relations Manager Director of Public Works Engingeering Administrative Asst. Engineering Technician Low High Actual Low High Actual Low High Actual Low High Actual Batavia 75,625 104,275 Chanahon 87,312 39,014 55,718 Crest Hill 55,000 66,959 Elburn 54,445 75,962 Geneva* 84,619 119,462 40,366 56,987 47,218 66,661 Huntley 63,523 89,605 89,605 Lemont* 73,626 96,221 Lockport 72,411 1 46,304 47,000 Montgomery* 1 67,487 91,841 88,056 Morris New Lenox** 102,885 40,320 54,540 53,015 North Aurora 55,541 77,125 77,125 Oswego 37,214 53,162 39,520 69,111 95,692 80,442 Plainfield 50,293 70,410 68,500 1 72,075 96,005 100,000 Plano** 65,000 80,000 78,000 Sandwich Shorewood 73,736 South Elgin* 81,972 97,046 90,503 Sugar Grove* 68,443 91,761 42,845 55,290 Sycamore(*)(***) 70,000 90,000 80,500 AVERAGE 43,754 61,786 54,010 68,319 90,854 85,048 40,366 56,987 39,014 44,1,72 55,873 54,367- Yorkville 26,910 42,820 38,501 62,972 82,204 77,043 32,085 43,675 36,253 37,260 53,524 43,340 Comparison -38% -31% -29% -8% -10% -9% -21% -23% -7% -16% 4% -20% Observations Minimum 37,214 53,162 39,520 54,445 66,959 72,411 40,366 56,987 39,014 40,320 47,000 53,015 25th 40,484 57,474 46,765 63,523 80,000 77,781 40,366 56,987 39,014 42,214 52,655 53,691 Median 43,754 61,786 54,010 68,777 91,801 83,906 40,366 56,987 39,014 44,575 54,915 54,367 75th 47,023 66,098 61,255 72,075 96,005 89,830 40,366 56,987 39,014 46,533 58,133 55,042 Maximum 50,293 70,410 68,500 84,619 119,462 102,885 40,366 1 56,987 39,014 1 47,218 1 66,661 55,718 UNII'ED CI'T'Y OF YORKVJ [,J,E 2006 Comprehensive Salary Survey City Finance Director GIS Coordinator Mechanic Office Assistant Low High Actual Low High Actual Low High Actual Low High Actual Batavia 72,369 99,785 44,593 61,487 39,083 53,872 Chanahon 83,066 49,651 27,539 34,444 Crest Hill 46,155 50,232 Elburn Geneva* 74,313 104,912 47,218 66,661 43,485 61,390 42,738 60,336 Huntley 94,915 37,140 52,390 50,619 26,395 37,233 27,726 Lemont* 51,609 73,607 41,085 57,800 Lockport 57,790 Montgomery* 67,487 91,841 88,907 42,152 57,364 53,144 32,032 43,592 Morris New Lenox** 97,306 30,732 41,568 39,474 North Aurora 55,541 77,125 69,000 29,734 41,289 34,128 Oswego 69,111 95,692 90,472 31,897 47,846 44,859 37,214 53,162 26,581 42,530 32,772 Plainfield 68,575 96,005 95,000 37,208 52,092 38,000 43,368 60,715 47,000 Plano** Sandwich Shorewood 78,625 South Elgin* 69,495 91,240 85,831 41,226 55,219 55;219 Sugar Grove* 65,144 87,338 42,914 57,364 30,729 44,226 Sycamore(*)(***) 42,000 51,655 51,655 M7A El GE ` 65r96d'r',';; O,838'',;::',8091 84 b91 ' : .:40,229 57,022 44,110 41,438 .. 55,560, 51:;82'X`' . :30,810:,: "1';43,15*.A ;` 3; .#`''' Yorkville 59,175 83,325 41,000 57,000 26,910 42,820 34,112 Comparison -10% -8% -100% 2% 0% -100% -100% -100% -100% -13% -1% 2% Observations Minimum 51,609 73,607 57,790 31,897 47,846 38,000 37,140 50,232 47,000 26,395 34,444 27,726 25th 62,743 84,785 79,735 34,553 49,969 41,430 41,120 52,583 50,619 27,300 40,275 31,511 Median 68,575 91,841 87,369 40,901 56,790 44,859 42,000 55,219 51,655 30,232 42,049 33,450 75th 69,207 95,770 93,804 42,213 59,377 47,255 43,255 57,691 53,144 31,057 43,751 35,465 Maximum 74,313 104,912 97,306 47,218 66,661 49,651 46,155 61,390 55,219 42,738 60,336 39,474 UNITED CITY OF YORKVILLE 2006 Comprehensive Salary Survey City Operator Payroll Benefits Specialist Police Lieutenant Police Office Supervisor Low High Actual Low High Actual Low High Actual Low High Actual Batavia 40,836 56,306 Chanahon 42,505 52,250 39,764 74,115 31,886 39,915 Crest Hill 70,642 38,501 Elburn 49,495 52,495 Geneva* 43,485 61,390 51,523 72,738 62,021 89,747 40,366 56,987 Huntley Lemont* 37,070 52,748 63,000 80,944 Lockport 1 78,510 45,697 Montgomery* 40,531 55,157 Morris New Lenox** L 42,624 61,704 55,823 North Aurora 59,407 82,494 68,318 32,492 45,119 45,119 Oswego 69,111 95,692 80,500 Plainfield 40,215 56,301 46,800 Plano** Sandwich Shorewood 33,992 45,552 39,349 80,138 46,592 South Elgin* 33,729 46,379 46,379 Sugar Grove* Sycamore(*K***) 1 45,000 65,000 55,000 65,000 1 85,000 78,000 AVERAGE 39,453 53,648 43,075 42,324 59,116 47,048 61,339 79,573 76,597 36,842 48,445 48,308 Yorkville 39,330 52,454 52,187 26,910 42,820 40,000 53,652 72,200 72,330 34,096 48,172 43,164 Comparison 0% -2% 21% -36% -28% -15% -13% -9% -6% -7% -1% -11% Observations Minimum 33,992 45,552 39,349 33,729 46,379 39,764 49,495 52,495 68,318 31,886 38,501 45,119 25th 37,070 52,250 41,212 38,831 52,963 43,072 60,061 75,793 75,086 32,341 39,915 45,553 Mediani 40,215 52,748 43,075 40,836 56,306 46,379 62,511 82,494 78,255 36,429 45,119 46,145 75t 42,505 56,301 1 44,937 46,631 66,935 50,690 64,500 87,373 79,731 40,931 56,987 1 48,900 Maximuml 43,485 1 61,390 1 46,800 51,523 72,738 55,000 69,111 95,692 1 80,500 42,624 61,704 55,823 UNITED CITY OF YORKVILLE 2006 Comprehensive Salary Survey City Police Records Clerk Police Sergeants Public Improvements Technician PW Foreman Low High Actual Low High Actual Low High Actual Low High Actual Batavia 29,994 41,371 67,142 74,734 Chanahon 27,539 34,444 29,365 67,173 Crest Hill 35,922 1 64,542 66,664 49,670 Elburn 25,399 37,037 Geneva* 40,366 56,987 62,050 87,600 47,877 67,591 Huntley 26,395 37,233 49,772 70,208 Lemont* 28,016 37,149 60,282 73,418 41,999 59,953 Lockport 24,019 31,019 Montgomery* 29,616 40,303 39,015 1 53,336 72,583 70,265 1 46,947 67,950 Morris New Lenox** 55,573 78,200 44,484 62,600 North Aurora 1 48,794 67,756 67,756 37,790 52,475 Oswego 53,162 74,427 70,000 37,214 53,162 45,369 Plainfield 29,952 41,933 34,882 1 60,990 85,386 81,034 1 46,833 65,566 1 63,155 Plano** Sandwich 27,092 33,858 43,569 53,879 31,676 42,308 Shorewood 30,139 33,342 32,000 63,162 69,626 69,626 43,730 55,603 58,603 South Elgin* 67,042 79,828 74,817 Sugar Grove* 54,026 67,145 47,799 61,969 Sycamore(*)(***) 35,000 45,000 40,500 58,189 58,189 58,189 AVERAGE 29,461 . 38,892 35,152 57,442 71,976 69,857 .42,635 58,077 55,709 Yorkville 26,910 42,820 31,382 46,506 62,088 61,729 41,000 57,000 45,550 59,989 54,595 Comparison -9% 10% -11% -19% -14% -12% 7% 3% -2% Observations Minimum 24,019 31,019 29,365 43,569 53,879 58,189 0 0 0 31,676 42,308 45,369 25th 26,744 34,298 32,000 53,206 67,298 67,610 38,842 52,819 51,986 Median 28,816 37,149 34,882 58,189 72,583 69,813 44,107 59,953 58,603 75th 30,046 1 40,710 39,015 61,785 77,257 71,403 46,918 64,083 60,879 Maximum 40,366 1 56,987 40,500 67,042 1 87,600 1 81,034 1 0 0 0 47,877 1 67,950 63,155 UNITED CITY OF YORKVILLE 2006 Comprehensive Salary Survey City PW MW I PW MW II Receptionist Senior Accounting Clerk Low High Actual Low High Actual Low High Actual Low High Actual Batavia Chanahon 33,038 36,630 37,912 42,034 27,546 35,712 Crest Hill 1 33,259 45,552 25,646 34,154 32,323 38,147 Elburn 25,399 37,037 Geneva* 38,960 55,003 43,485 61,390 Huntley 29,100 41,049 34,562 Lemont* 33,603 44,145 36,573 50,541 30,311 41,597 Lockport Montgomery* 33,314 45,335 36,032 49,035 34,646 47,149 Morris New Lenox** 58,943 North Aurora 35,048 48,672 1 29,734 41,289 34,128 44,041 61,156 50,674 Oswego 31,897 47,846 34,909 37,214 53,162 43,355 21,265 31,897 26,473 Plainfield 33,280 46,613 41,371 37,211 52,083 46,176 28,292 39,607 31,380 Plano** Sandwich 31,676 42,308 Shorewood 30,916 41,430 41,167 55,168 29,557 South Elgin* 31,602 38,148 37,049 34,767 45,057 34,767 30,213 40,685 31;958 Sugar Grove* 33,459 43,127 38,032 51,621 39,266 54,916 Sycamore(*K***) 39,250 51,655 AVERAGE 33,473 44,766 36;973 37,565 50,564 41,433 26,758 37,445 30,174 36,117 48,593 48,443 Yorkville 29,900 41,749 31,518 34,155 47,101 36,013 20,800 27,967 23,899 32,085 43,675 Comparison -11% -7% -15% -9% -7% -13% -22% -25% -21% -11% -10% -100% Observations Minimum 29,100 36,630 34,562 33,259 42,034 34,767 21,265 31,897 26,473 30,311 38,147 35,712 25th 31,676 41,430 34,822 36,167 46,423 39,061 25,461 34,874 28,049 32,323 41,597 43,193 Median 33,280 44,145 35,979 37,213 51,081 43,355 26,969 38,322 30,469 34,646 47,149 50,674 75th 33,603 47,846 38,130 38,002 52,892 44,766 29,374 40,416 31,814 39,266 54,916 54,809 Maximum 39,250 55,003 1 41,371 43,485 61,390 46,176 30,213 41,289 34,128 44,041 61,156 58,943 UNITED CITY OF YORKVILLE 2006 Comprehensive Salary Survey City Senior Engineering Technician Senior Planner Utility Billing Clerk Low High Actual Low High Actual Low High Actual Batavia 46,155 63,648 44,811 Chanahon 29,660 37,107 30,620 Crest Hill 34,278 38,709 Elbum 25,399 37,037 Geneva* 41,234 59,102 38,551 55,458 78,294 40,366 56,987 Huntley 30,556 43,102 40,237 Lemont* 43,849 58,387 26,417 42,613 Lockport Montgomery* 45,592 62,044 30,800 41,915 40,580 Morris New Lenox** North Aurora 1 33,238 46,155 1 37,626 Oswego 42,530 63,795 31,897 47,846 36,178 Plainfield 57,304 80,226 77,000 33,301 46,613 40,248 Plano** Sandwich 27,092 33,858 Shorewood 31,512 South Elgin* 30,954 44,493 44,493 Sugar Grove* 43,002 56,889 Sycamore(*x***) 31,250 38,434 38,434 Yorkville 41,000 57,000 45,042 26,910 42,820 38,299 Comparison -6% -7% 8% -100% -100% -100% -14% 0% 1% Observations Minimum 41,234 59,102 38,551 42,530 56,889 77,000 25,399 33,858 30,620 25th 41,234 59,102 38,551 43,214 59,301 77,000 29,660 38,434 36,178 Mediani 43,694 61,375 41,681 44,721 62,920 77,000 30,954 42,613 38,434 75thl 41,234 1 59,102 38,551 52,992 74,669 77,000 33,238 46,155 40,248 Maximum 41,234 59,102 38,551 57,304 80,226 77,000 40,366 56,987 44,493 CCi tY OF YORKVII,T,E 2006 Comprehensive Salary Survey City Senior Engineering Technician Senior Planner Utility Billing Clerk Low High Actual Low High Actual Low High Actual Batavia 46,155 63,648 44,811 Chanahon _ 29,660 37,107 30,620 Crest Hill 34,278 38,709 Elburn 25,399 37,037 Geneva* 41,234 59,102 38,551 55,458 78,294 40,366 56,987 Huntley 30,556 43,102 40,237 Lemont* 43,849 58,387 26,417 42,613 Lockport Montgomery* 45,592 62,044 30,800 41,915 40,580 Morris New Lenox** North Aurora 33,238 46,155 37,626 Oswego 42,530 63,795 31,897 47,846 36,178 Plainfield 57,304 80,226 77,000 33,301 46,613 40,248 Plano** Sandwich 27,092 33,858 Shorewood 31,512 South Elgin* 30,954 44,493 44,493 Sugar Grove* 43,002 56,889 Sycamore(*)(***) 31,250 38,434 38,434 `' AVERAGt 43,694 61,375 41,681 47,956 66,606 ' 77,000 31,170 " ".4202 37,770.‘ Yorkville 41,000 57,000 45,042 26,910 42,820 38,299 Comparison -6% -7% 8% -100% -100% -100% -14% 0% 1% Observations Minimum 41,234 59,102 38,551 42,530 56,889 77,000 25,399 33,858 30,620 25th 41,234 59,102 38,551 43,214 59,301 77,000 29,660 38,434 36,178 Median 43,694 61,375 41,681 44,721 62,920 77,000 30,954 42,613 38,434 75th 41,234 59,102 38,551 52,992 74,669 77,000 33,238 46,155 40,248 Maximum 41,234 59,102 38,551 57,304 80,226 77,000 40,366 56,987 44,493 UNITED CITE' OF YORKVILLE 2006 Comprehensive Salary Survey City Parks and Rec Director Program Su ervisor Rec Recreation Coordinator Low High Actual Low; High Actual Low High Actual Batavia District 75,000 101,400 90,000 30,900 41,600 34,809 Chanahon District 98,000 35,558 Geneva District 85,000 130,000 113,000 30,000 45,000 44,900 Huntley District 86,229 32,702 Lemont District 90,200 25,000 1 45,000 43,500 Lockport District 105,180 1 47,557 Lake In Hills(Department) 66,751 1 92,117 38,293 52,845 Lincolnwood(Department). 68,959 91,039 42,405 55,974 New Lenox District 51,605 64,130 73,587 27,476 35,281 25,875 1 28,282 Oswego District 70 000 90,000 86,611 Plainfield District 120,000 32,000 53,500 40,180 42,000 Sandwich District South Elgin(Department) 72,000 1 84,000 80,752 32,000 40,000 40,000 32,000 40,000 32,800 Sugar Grove District 67,000 33,000 32,000 Sycamore District 78,000 30,031 AVERAGE 69053. <91881 ' `>90,056!° 32;453' 48,720 38,572 28,938' 40,000' 33771' Yorkville(Department) 61,300 86,319 78,000 32,085 51,383 43,329 32,085 51,383 Comparison -11% -6% -13% -11% 5% 12% 11% 28% -100% Observation Minimum 51,605 64,130 67,000 25,000 40,000 30,031 25,875 40,000 28,282 25th 67,303 85,500 78,688 28,738 45,000 33,000 27,406 40,000 31,071 Median 69,480 90,520 86,611 30,900 45,000 35,420 25,875 40,000 32,000 75th 71,500 91,848 101,435 35,147 53,336 43,500 30,469 40,000 35,100 Maximum 85,000 130,000 1 120,000 42,405 55,974 47,557 32,000 40,000 42,000 Updated May 2006 UNITED CITY OF Y( RKVILLE 2006 Comprehensive Salary Survey City Super! tendent of Parks Superintendent of Recreation Low High Actual Low High Actual Batavia District 48,000 65,000 58,636 48,000 65,000 57,517 Chanahon District 58,720 57,916 Geneva District 50,000 75,000 67,000 50,000 75,000 63,400 Huntley District 65,044 60,831 Lemont District 35,000 55,000 55,000 Lockport District 66,300 67,200 Lake In Hills(Department) 59,518 82,135 49,240 67,952 Lincolnwood(Department) New Lenox District 38,854 54,075 38,916 51,302 Oswego District 45,000 65,000 59,987 Plainfield District 65,000 66,000 Sandwich District South Elgin(Department) Sugar Grove District Sycamore District 53,000 49,500 AVERAGE ;48;343' '74045 '!`61,48 ?"'43;289 65,984: ='590033 Yorkville(Department) 65,000 42,106 1 59,291 54,616 Comparison -100% -100% 6% -3% -10% -7% Observation Minimum 38,854 65,000 53,000 35,000 55,000 49,500 25th 43,464 70,000 57,031 37,937 61,476 53,151 Medianj 46,500 70,000 59,354 43,458 66,476 57,717 75th 52,380 78,568 65,672 49,430 71,476 64,700 Maximuml 59,518 82,135 67,000 50,000 75,000 67,200 Yorkville Montgomery Oswego Batavia Plano Proposed 3.3%COLA 4.1%COLA/up COLA/Merit for 06/07 2.5%Merit,2% 4.5%Merit to 4%Merit 3% COLA •of Increase for 14% 14%(EE paid 3% 05/06 5% 6.7%PPO&EE pays 6%;9.75% •of Increase for HMO&EE pays 06/07 -4% $0(moved 20% 3% renewal date from Aug.to Mav 2006 Blue Cross/Blue Blue Blue Cross/Blue Health Care Provider Shield of Illinois Cross/Blue Shield of Illinois self insured BC/BS Shield of Illinois HMO or PPO HMO/PPO HMO HMO/PPO na HMO/PPO Premium EE $294.99/$414.11 $268.96 212.68/447.58 $604.90 247.21/373.24 Premium EE+1 $638.15/$895.85 $550.46 459.56/967.12 $1,175.92 518.63/ 783.03 Premium $604.03/$847.96 $532.71 442.72/931.69 494.63/ EE+Children 746.81 Premium Family $947.21/ $814.21 689.59/1451.23 $1,791.88 766.05/ $1329.70 1156.58 EE Contribution EE 0.00 0.00 $0/6% $76.10 0/5% EE Contribution EE+1 0.00 0.00 $0/6% $171.21 0/5% ' EE Contribution c;a, Family 0.00 0.00 $0/6% $351.34 0/5% ;5 CD ue t' Dental Provider Metlife Cross/Blue Humana self insured Assurant Shield of Illinois t: HMO=21.50 included in % Premium EE $28.70 PPO=28 61 25.11 above rate $25.50 r. HMO=41.35 included in Premium EE+1 $56.19 PPO=59.25 5699 above rate $52.54 Premium HMO=45.60 53.88 included in $53.79 EE+Children PPO=68.98 above rate Premium Family $104.17 HMO=68.70 86.73 included in $80.83 PPO=99.62 above rate EE Contribution EE 0.00 0.00 0.00 included in 0.00 above rate EE Contribution EE+1 0.00 0.00 0.00 included in 28.30 above rate EE Contribution 00 included in 55.34 Family 0.00 0.00 0. above rate Vision Provider Vision Service DNA Vision Service self insured VSP Plan(VSP) Plan(VSP) Premium EE 5.34 DNA 8.83 included in 12.55 above rate ro included in CD Premium EE+1 7.74 DNA 12.80 a above rate Premium Family 13.88 DNA Y4.95 included in 26.99 above rate .> �• EE Contribution EE 0.00 DNA 0.00 included in 0 above rate .00 N °o EE Contribution EE+1 0.00 included in DNA 0.00 Ch above rate EE Contribution 000 DNA 0.00 included in Family . above rate 14.44 Crest HIII Elburn Lemont Plainfield Sugar Grove Proposed up to COLA/Merit for 06/07 5%Merit,3.3% Merit only 4.4% 3-5%Merit 3.3%5-1-06 COLA •of Increase for 3% 12% 05/06 •of Increase for 3% 12% 06/07 Blue Cross/Blue Blue Cross/Blue Health Care Provider self insured Shield of Illinois Shield HMO Blue Cross/Blue Shield& BC/BS of Illinois CoreSource CoreSource HMO/PPO PPO HMO/PPO HMO or PPO PPO PPO HMO/PPO HMO/PPO 1&2 Employee Contributions are per payperiod(26) Premium EE $759 fmlyi$348 450.41 $330/$492.37/$408.67 189.15/338.10 Premium EE+1 no premium 973.65 n/a 434.37/776.45 change Premium no premium 913.54 n/a 415.28/742.33 EE+Children change Premium Family $15.00 Biweekly 1436.79 $979.55/$1,340.06/$1112 660.50/1180.65 Fm only .25 EE Contribution EE no premium 0 $211.12/ 0/017.8% 28.37/50.72 change $687.05 EE Contribution EE+1 no premium 261.62 $1465.56/ n/a 65.16/116.47 change- $497.12 EE Contribution no premium $2179.91 / o Family change 493.19 $791.44 0/0/7.8/0 99.08/177.10 -17n-n-Mip-al Dental Dental Provider self insured Midwest Dental UniCare Employee Benefits Contributions are naynprind included in above 100% included in Premium EE rate preventive, above rate $23.81 27.97 50%remainin Premium EE+1 included in above DNA included in n/a 58.52 rate above rate Premium included in above DNA included in n/a 69.82 EE+Children rate above rate Premium Family included in above DNA included in 64.47 110.87 rate above rate EE Contribution EE included in above 0 included in 0 4.2 rate above rate EE Contribution EE+1 included in above DNA included in n/a 10.47 rate above rate EE Contribution included in above DNA included in 0 16.63 Family rate above rate Not applicable, Vision Provider N/A DNA Vision Service Plan coverage provided (VSP) by BC/BS and with Dental Premium EE N/A DNA included in 8.41 above rate Premium EE+1 N/A DNA included in n/a above rate Premium Family N/A DNA included in 18.08 above rate EE Contribution EE N/A DNA included in 0 above rate EE Contribution EE+1 N/A DNA included in n/a above rate EE Contribution N/A DNA included in 0 Familv above rate Geneva Sandwich South Elgin Lockport Shorewood 3.35%COLA,2-5%Merit N/A-Have COLA/Merit for 06/07 and/or implementation of Longevity Pay Merit compensation study Increases instead •of Increase for 10.60% 3.5 05/06 •of Increase for Anticipating 15%but won't 4.5%non-union. 06107 know for months 3 PW and Police union 3.5% Blue Cross/Blue Shield of Blue SUBS of Coresource Health Care Provider Illinois Cross/Blue Illinois (SWARM) Shield of Illinois HMO or PPO HMO Blue/HMO/PPO PPO HMO/PPO1/PPO 2/PPO3 Premium EE $343.76/$377.75/ 344.03 $419.59 364/558/474/459 $377.75 Premium EE+1 $834.61/$917.48/ 768.4 896.11 $917.48 Premium $834.61/$917.48/ 730.57 857.65 EE+Children $917.49 Premium Family $1012.9/$1113.08/ 1154.94 1,334.17 1054/1218/1446/ $1113.08 1218/1178 EE Contribution EE $34.38/$37.78/$37.78 42.14 10.49 0 0124/6/0 (10%EE premium) $132.55/$145.73/ EE Contribution EE+1 $145.73(20%for 43.43 22.40 0 Dependent premium) EE Contribution $168.21/$184.85/ Family $184.85(20%for 64.2 33.37 0 0/63/16/0 Dependent premium) HMO=Blue Cross/Blue Dental Provider Shield of Principal Guardian Unicare Illinois/PPO=Delta Dental Premium EE $21.50/$25.41 22.52 In-$17.21 Out induded above $31.97 Premium EE+1 $57.50/$67.39 24.33 In-$32.96 Out $63.04 Premium $67.501$67.40 34.02 In-$43.71 Out EE+Children -$96.83 Premium Family $57.50/$67.41 66.77 In-$43.71 Out -$96.83 EE Contribution EE 0(0%of EE premium) 4.88 All 0 0 EE Contribution EE+1 $18/$20-99(50%of 8,08 All 0 0 dependent premium) EE Contribution $18/$20.99(50%of 12.76 All 0 0 Family dependent premium) Provided by Vision Provider Vision Service Plan(VSP) Vision Service BC/BS- None Plan(VSP EyeMed Vision,Care- Premium EE $7.80 4.99 n/a Premium EE+1 $16.76 n/a n/a Premium Family $16.76 10.73 n/a EE Contribution EE $7.80 0 n/a EE Contribution EE+1 $16.76 n/a n/a EE Contribution $16.76 0 n/a Famil UNITED CITY OF YORKVILLE BUDGET 2006-2007 GENERAL FUND SUMMARY PERIOD ENDING MAY 31, 2006 8.33% OF FISCAL YEAR REVENUE/EXPENSE 2006-2007 PERCENT VS. THRU MAY 31, 2006 BUDGET BUDGET AMOUNT ,� -n -F ' '`"`y �.. .,tae-"w� TOTAL GENERALFUND RE�/,ENUE� �.836,1460 �16583,5754� T 2504% a _ t GENERAL FUND EXPENSES FINANCE & ADMINISTRATION 211,038 6,420,660 3.29% ENGINEERING 36,294 510,186 7.11% POLICE 201,516 2,561,214 7.87% PLANNING & DEVELOPMENT 461 525,399 0.09% STREETS 50,093 5,8849953 0.85% HEALTH & SANITATION 0 681,163.11F.- 0.00% l." -•-x' ._ ' +. k. *.,x �> s' _ tom. s"` " rTOTALGENERALFUNDEXPENSES4}99�40a 46583.575 Ag 2 .'N= 6/29/2006 UNITED CITY OF YORKVILLE DETAILED REVENUE & EXPENSE REPORT AS OF MAY 31, 2006 General Fund Revenue 1 Sanitary Sewer Improvement&Expansion 23 Finance 3 Water Improvement &Expansion 25 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 41 Municipal Building 16 Library 46 Police Equipment Capital 17 Fox Industrial 50 Public Works Equipment Capital 19 Countryside TIF 52 Parks & Recreation Equipment Capital 21 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 1 TIME: 08:10:16 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: GENERAL FUND FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ GENERAL REVENUES TAXES 01-000-40-00-3996 ROAD CONTRIBUTION FEE 130,482.00 130,482.00 1,500,000.00 8.6 01-000-40-00-3997 IN TOWN ROAD PROGRAM FUNDING 0.00 0.00 2,070,000.00 0.0 01-000-40-00-3998 MPI BRISTOL RIDGE RD FUNDING 0.00 0.00 1,600,000.00 0.0 01-000-40-00-3999 RESERVE FUND BALANCE 0.00 0.00 372,849.00 0.0 01-000-40-00-4000 REAL ESTATE TAXES 0.00 0.00 1,571,133.00 0.0 01-000-40-00-4001 TOWN ROAD/BRIDGE TAX 0.00 0.00 105,000.00 0.0 01-000-40-00-4002 FOX HILL LEVY REVENUE 0.00 0.00 18,000.00 0.0 01-000-40-00-4010 PERSONAL PROPERTY TAX 2,865.91 2,865.91 10,000.00 28.6 01-000-40-00-4020 STATE INCOME TAX 65,695.03 65,695 .03 885,000.00 7.4 01-000-40-00-4030 MUNICIPAL SALES TAX 186,668.39 186,668.39 2,845,000.00 6.5 01-000-40-00-4032 STATE USE TAX 0.00 0.00 137,000.00 0.0 01-000-40-00-4040 MUNICIPAL UTILITY TAX 0.00 0.00 375,000.00 0.0 01-000-40-00-4041 UTILITY TAX - NICOR 21,547.11 21,547.11 250,000.00 8.6 01-000-40-00-4042 UTILITY TAX - CABLE TV 28,074.45' 28,074.45 90,000.00 31.1 01-000-40-00-4043 UTILITY TAX - TELEPHONE 39,605.14 39,605.14 425,000.00 9.3 01-000-40-00-4050 HOTEL TAX 1,470.76 1,470.76 20,000.00 7.3 01-000-40-00-4060 TRAFFIC SIGNAL REVENUE 0.00 0.00 5,000.00 0.0 --------------------------------------------------------------------------------- TOTAL TAXES 476,408.79 476,408.79 12,278, 982.00 3.8 LICENSES & PERMITS 01-000-41-00-4100 LIQUOR LICENSE 2,156.00 2,156:00 26,000.00 8.2 01-000-41-00-4101 OTHER LICENSES 0.00 0.00 4,500.00 0.0 01-000-.41-00-4110 BUILDING PERMITS 198,904.75 198,904.75 1,550,000.00 12.8 01-000-41-00-4111 Centex Fees 0.00 0.00 0.00 0.0 -------------°------------------------------------------------------------------- TOTAL LICENSES & PERMITS 201,060.75 201, 060.75 1,580,500.00 12.7 CHARGES FOR SERVICES 01-000-42-00-4205 FILING FEES 2,195.00 2,195.00 25,000.00 8.7 01-000-42-00-4206 GARBAGE SURCHARGE (0.92) (0.92) 227,648.00 0.0 01-000-42-00-4208 COLLECTION FEE - YBSD 0.00 0.00 35,000.00 0.0 01-000-42-00-4210 DEVELOPMENT FEES 138,221.81 138,221.81 1,475, 000.00 9.3 01-000-42-00-4211 ENGINEERING CAPITAL FEE 4,200.00 4,200.00 52,000.00 8.0 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 144,615.89 144,615.89 1,814,648.00 7.9 P1 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 2 TIME: 08:10:16 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: GENERAL FUND FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL °s ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ GENERAL FINES & FORFEITS 01-000-43-00-4310 TRAFFIC FINES 5,580.03 5,580.03 75,000.00 7.4 01-000-43-00-4315 REIMBURSE POLICE TRAINING 0.00 0.00 11,805.00 0.0 01-000-43-00-4320 ORDINANCE FEES 210.00 210.00 2,500.00 8.4 --------------------------------------------------------------------------------- TOTAL FINES & FORFEITS 5,790.03 5,790.03 89,305.00 6.4 MISCELLANEOUS 01-000-44-00-4401 DARE DONATIONS 0.00 0.00 1,250.00 0.0 01-000-44-00-4402 ROB ROY CREEK HYDRAULIC STUDY 0.00 0.00 10,000.00 0.0 01-000-44-00-4403 WEARING APPAREL DONATIONS 0.00 0.00 1, 140.00 0.0 01-000-44-00-4411 REIMBURSEMENTS-POLICE PROTECTN 414.45 414.45 3,000.00 13.8 01-000-44-00-4490 MISCELLANEOUS INCOME 332.50 332.50 10, 000.00 3.3 ------------------------------------------------------ -------------- ---------- TOTAL MISCELLANEOUS 746.95 746.95 25,390.00 2.9 INTERGOVERNMENTAL 01-000-45-00-4505 COPS GRANT - VESTS 0.00 0.00 2,500.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 0.00 0.00 30,000.00 0.0 --------------------------------------------------------------------------------- TOTAL INTERGOVERNMENTAL 0.00 0.00 33,750.00 0.0 INTEREST 01-000-46-00-4600 INVESTMENT INCOME 7,537.56 7,537.56 75,000.00 10.0 --------------------------------------------------------------------------------- TOTAL INTEREST 7,537.56 7,537.56 75,000.00 10.0 TRANSFERS 01-000-49-00-4915 TRANSFER FROM WATER OPERATIONS 0.00 0.00 250,000.00 0.0 01-000-49-00-4920 TRANSFER FROM SEWER MAINT. 0.00 0.00 - 70,000.00 0.0 01-000-49-00-4925 TRANSFER FROM SAN. SEWER IMPR 0.00. 0.00 150,000.00 0.0 01-000-49-00-4930 TRANSFER FROM WATER IMPROVE. 0.00 0.00 200,000.00 0.0 01-000-49-00-4935 TRANSFER FROM LAND CASH 0. 00 0.00 16,000.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 686, 000.00 0.0 P2 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 3 TIME: 08:10:16 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: GENERAL FUND FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL I ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TOTAL REVENUES: . GENERAL 836,159.97 836,159.97 16,583,575.00 5.0 FINANCE & ADMINISTRATION EXPENSES PERSONNEL SERVICES 01-110-50-00-5100 SALARIES - MAYOR 4,320.00 4,320.00 7,500.00 57.6 01-110-50-00-5101 SALARIES - CITY CLERK 1,800.00 1,800.00. 3,600.00 50.0 01-110-50-00-5102 SALARIES - CITY TREASURER 1,870.00 1,870.00 3,600.00 51.9 01-110-50-00-5103 SALARIES - ALDERMAN 13,955.00 13,955.00 29,080.00 47.9 01-110-50-00-5104 SALARIES - LIQUOR COMMISSIONER 0.00 0.00 1,000.00 0.0 01-110-50-00-5105 SALARIES - CITY ATTORNEY 1,327.20 1,327.20 11,502.00 11.5 01-110-50-00-5106 SALARIES - ADMINISTRATIVE 74,629.90 74,629.90 626,215.00 11.9 01-110-50-00-5136 SALARIES - PART TIME 4,132.20 4,132.20 50,000.00 8 .2 01-110-50-00-5137 SALARIES - OVERTIME 623.08 623.08 1,500.00 41.5 01-110-50-00-5202 BENEFITS - UNEMPLOY. COMP. TAX 0.00 0.00 12,000.00 0.0 01-110-50-00-5203 BENEFITS - HEALTH INSURANCE (1,797.21) (1,797.21) 852,458.00 (0.2) 01-110-50-00-5204 BENEFITS - GROUP LIFE INSURANC (282.70) (282.70) 74,049.00 (0.3) 01-110-50-00-5205 BENEFITS - DENTAL/VISION ASST 522.64 522.64 23,668.00 2 .2 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 101,100.11 101,100.11 1,696,172.00 5.9 PROFESSIONAL SERVICES 01-110-61-00-5300 LEGAL SERVICES 950.00 950.00 55,000.00 1.7 01-110-61-00-5304 AUDIT FEES & EXPENSES 0.00 0.00 2,675.00 0.0 01-110-61-00-5305 ACCOUNTING ASSISTANCE 0.00 0.00 5,000.00 0.0 01-110-61-00-5310 EMPLOYEE ASSISTANCE 0.00 0.00 4,500.00 0.0 01-110-61-00-5311 CODIFICATION 0.00 0.00 5,000.00 0.0 01-110-61-00-5314 BUILDING INSPECTIONS 0.00 0.00 1,115,000.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 950.00 950.00 1,187, 175.00 0.0 CONTRACTUAL SERVICES 01-110-62-00-5400 INSURANCE-LIABILITY & PROPERTY 0.00 0.00 130,000.00 0.0 01-110-62-00-5401 CONTRACTUAL SERVICES 100.00 100.00 40,000.00 0.2 01-110-62-00-5404 CABLE CONSORTIUM FEE 0.00 0.00 30,000.00 0.0 01-110-62-00-5406 OFFICE CLEANING 0.00 0.00 7,500.00 0.0 P3 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 4 TIME: 08:10:16 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: GENERAL FUND FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL °s ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ FINANCE & ADMINISTRATION EXPENSES CONTRACTUAL SERVICES 01-110-62-00-5410 MAINTENANCE - OFFICE EQUIPMENT 0.00 0.00 500.00 0.0 01-110-62-00-5411 MAINTENANCE - COMPUTERS 0.00 0.00 2,000.00 0.0 01-110-62-00-5412 MAINTENANCE - PHOTOCOPIERS 1,616.00 1,616.00 19,392.00 8.3 01-110-62-00-5421 WEARING APPAREL 0.00 0.00 1,140.00 0.0 01-110-62-00-5427 FACADE PROGRAM 0.00 0.00 30,000.00 0.0 01-110-62-00-54'36 TELEPHONE 0.00 0.00 15,000.00 0.0 01-110-62-00-5437 ACCTG SYSTEM SERVICE FEE 0.00 0.00 8,500.00 0.0 01-110-62-00-5438 CELLULAR TELEPHONE 0.00 0.00 2,300.00 0.0 01-110-62-00-5439 TELEPHONE SYSTEMS MAINTENANCE 0.00 0.00 11,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 1,716.00 1,716.00 297,332.00 0.5 PROFESSIONAL DEVELOPMENT 01-110-64-00-5600 DUES 396.75 396.75 5,000.00 7.9 01-110-64-00-5601 ILLINOIS MUNICIPAL LEAGUE DUES 0.00 0.00 781.00 0.0 01-110-64-00-5603 SUBSCRIPTIONS 0.00 0.00 900.00 0.0 01-110-64-00-5604 TRAINING & CONFERENCES 515.00 515.00 13,000.00 3.9 01-110-64-00-5605 TRAVEL/MEALS/LODGING 0.00 0.00 17,000.00 0.0 01-110-64-00-5606 PROMOTIONAL/MARKETING EXPENSES 0.00 0.00 9,577.00 0.0 01-110-64-00-5607 PUBLIC RELATIONS (1,225.00) (1,225.00) 18,000. 00 (6.8) 01-110-64-00-5608 SPONSORSHIP§ 0.00 0.00 1,500.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT (313.25) (313.25) 65,758.00 (0.4) OPERATIONS 01-110-65-00-5800 CONTINGENCIES 0.00 0.00 595,000.00 0.0 01-110-65-00-5802 OFFICE SUPPLIES 429.93 429.93 15,000.00 2.8 01-110-65-00-5804 OPERATING SUPPLIES 279.24 279.24 10,000.00 2.7 01-110-65-00-5808 POSTAGE & SHIPPING 2,977.95 2, 977.95 12,500.00 23.8 01-110-65-00-5809 PRINTING & COPYING (68.79) (68.79) 11,000.00 (0.6) 01-110-65-00-5810 PUBLISHING & ADVERTISING 0.00 0.00 5,000.00 0.0 01-110-65-00-5844 MARKETING - HOTEL TAX 0.00 0.00 20,000.00 0.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS 3,618.33 3,618.33 668,500.00 0.5 P4 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 5 TIME: 08:10:16 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: GENERAL FUND FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ FINANCE & ADMINISTRATION RETIREMENT 01-110-72-00-6500 IMRF PARTICIPANTS 6,049.84 6,049.84 49,471.00 12.2 01-110-72-00-6501 SOCIAL SECURITY & MEDICARE 7,802.20 7,802.20 56, 151.00 13.8 -----------------------------=--------------------------------------------------- TOTAL RETIREMENT 13,852 .04 13,852 .04 105,622 .00 13 .1 CAPITAL OUTLAY 01-110-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 0.00 30,000.00 0.0 01-110-75-00-7003 OFFICE EQUIPMENT 0.00 0.00 5,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 0.00 35,000.00 0.0 OTHER OPERATING EXPENSES 01-110-78-00-9001 CITY TAX REBATE 0.00 0.00 500.00 0.0 01-110-78-00-9002 NICOR GAS 0.00 0.00 30, 000.00 0.0 01-110-78-00-9003 SALES TAX REBATE 0.00 0.00 450,000.00 0.0 01-110-78-00-9004 MISCELLANEOUS 0.00 0.00 100.00 0.0 01-110-78-00-9005 MERIT/PAY INCREASE 0.00 0.00 104,400.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING EXPENSES 0.00 0.00 585,000.00 0.0 TRANSFERS 01-110-99-00-9923 TRANSFER TO LIBRARY 2,937.50 2,937.50 35,250.00 8.3 01-110-99-00-9925 TRANSFER TO SAN SEWER 0.00 0.00 150,000.00 0.0 01-110-99-00-9940 TRANSFER TO PARK & RECREATION 87,177.25 87,177.25 1,046,127.00 8.3 01-110-99-00-9941 TRANSFER TO PARK/REC CAPITAL 0.00 0.00 150,000.00 0.0 01-110-99-00-9942 TRANSFER TO POLICE CAPITAL 0.00 0.00 75,000.00 0.0 01-110-99-00-9945 TRANSFER TO MUNICIPAL BLDG 0.00 0.00 30,865.00 0.0 01-110-99-00-9965 TRANSFER TO DEBT SERVICE 0.00 0.00 292,859.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 90,114.75 90,114.75 1,780,101.00 5.0 TOTAL EXPENSES: FINANCE & ADMINISTRATION 211,037.98 211,037.98 6,420,660.00 3 .2 ENGINEERING EXPENSES P5 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 6 TIME: 08:10:16 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.W0W FUND: GENERAL FUND FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ ENGINEERING PERSONNEL SERVICES 01=150-50-00-5107 SALARIES-EMPLOYEES 31,450.55 31,450.55 313,306.00 10.0 01-150-50-00-5137 SALARIES-OVERTIME 0.00 0.00 1, 000.00 0.0 ---------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 31,450.55 31,450.55 314,306.00 10.0 CONTRACTUAL SERVICES 01-150-62-00-5401 CONTRACTUAL SERVICES 0.00 0.00 50, 000.00 0.0 01-150-62-00-5402 GIS SYSTEM 0.00 0.00 5, 000.00 0.0 01-150-62-00-5403 FEES 0.00 0.00 2, 000.00 0.0 01-150-62-00-5409 MAINTENANCE-VEHICLES 0.00 0.00 2, 000.00 0.0 01-150-62-00-5410 MAINTENANCE-OFFICE EQUIP 0.00 0.00 1,000.00 0.0 01-150-62-00-5411 MAINTENANCE-COMPUTERS 0.00 0.00 3,000.00 0.0 01-150-62-00-5421 WEARING APPAREL 0.00 0.00 1,400.00 0.0 01-150-62.-00-5438 CELLULAR TELEPHONE 0.00 0.00 3,360.00 0.0 ---------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 0.00 0.00 67,760.00 0.0 PROFESSIONAL DEVELOPMENT 01-150-64-00-5600 DUES 0.00 0.00 400.00 0.0 01-150-64-00-5604 TRAINING & CONFERENCES 0.00 0.00 6, 000.00 0.0 01-150-64-00-5605 TRAVEL EXPENSE 0.00 0.00 1, 000.00 0.0 01-150-64-00-5608 TUITION REIMBURSEMENT 0.00 0.00 1,245.00 0.0 01-150-64-00-5616 BOOKS & PUBLICATIONS 0.00 0.00 200.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 0.00 0.00 8, 845.00 0.0 OPERATIONS 01-150-65-00-5801 ENGINEERING SUPPLIES 0.00 0.00 3, 000.00 0.0 01-150-65-00-5802 OFFICE SUPPLIES 0.00 0.00 2,500.00 0.0 01-150-65-00-5809 PRINTING & COPYING 0.00 0.00 2, 000.00 0.0 01-150-65-00-5820 ENGINEERING CAPITAL 0.00 0.00 52,000.00 0.0 TOTAL OPERATIONS 0.00 0.00 59,500.00 0.0 RETIREMENT 01-150-72-00-6500 IMRF PARTICIPANTS 2,484.59 2,484.59 24,830.00 10.0 P6 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 7 TIME: 08:10:16 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: GENERAL FUND FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ ENGINEERING EXPENSES RETIREMENT 01-150-72-00-6501 SOCIAL SECURITY & MEDICARE 2,359.21 2,359.21 24, 045.00 9.8 ------------------------------------------------------------------------ ------ TOTAL RETIREMENT 4,843.80 4,843.80 48,875.00 9.9 CAPITAL OUTLAY 01-150-75-00-7002 COMPUTER EQUIPMENT & SOFTWARE 0.00 0.00 7, 900.00 0.0 01-150-75-00-7003 OFFICE EQUIPMENT 0.00 0.00 3,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 0.00 10,900.00 0.0 TOTAL EXPENSES: ENGINEERING 36,294.35 36,294.35 510,186.00 7.1 PUBLIC SAFETY/POLICE DEPT. EXPENSES PERSONNEL SERVICES 01-210-SO-00-5107 SALARIES - EMPLOYEES 79,362.79 79,362.79 8.22,230.00 9.6 01-210-50-00-5131 SALARIES-CHIEF/LIEUTENANT/SERG 64,876.88 64,876.88 612,203.00 10.5 01-210-50-00-5133 SALARIES - COPS 11,868.93 11, 868.93 106,226.00 11.1 01-210-50-00-5134 SALARIES- CROSSING GUARD 2,984.50 2,984.50 19,500.00 15.3 01-210-50-00-5135 SALARIES - POLICE CLERKS 12,574.71 12,574.71 122,418.00 10.2 01-210-50-00-5136 SALARIES - PART TIME 4,668.94 4,668.94 35, 000.00 13.3 01-210-50-00-5137 SALARIES - OVERTIME 6,255.18 6,255.18 65, 000.00 9.6 01-210-50-00-5200 CADET PROGRAM 993.00 993.00 22,000.00 4.5 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 183,584.93 183,584.93 1,804, 577.00 10.1 PROFESSIONAL SERVICES 01-210-61-00-5300 LEGAL SERVICES 0.00 0.00 20,000.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 0.00 0.00 20,000.00 0.0 CONTRACTUAL SERVICES 01-210-62-00-5408 MAINTENANCE - EQUIPMENT 0.00 0.00 8,400.00 0.0 P7 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 8 TIME: 08:10:16 DETAILED REVENUE, & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: GENERAL FUND FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PUBLIC SAFETY/POLICE DEPT. EXPENSES CONTRACTUAL SERVICES 01-210-62-00-5409 MAINTENANCE - VEHICLES 531.80 531.80 28,000.00 1.8 01-210-62-00-5410 MAINT-OFFICE EQUIPMENT 0.00 0.00 2,625.00 0.0 01-210-62-00-5411 MAINTENANCE - COMPUTERS 604.00 604.00 6,000.00 10.0 01-210-62-00-5414 WEATHER WARNING SIREN MAINT 118.00 118.00 6, 000.00 1.9 01-210-62-00-5421 WEARING APPAREL 0.00 0.00 30, 000.00 0.0 01-210-62-00-5422 COPS GRANT IV - VESTS 0.00 0.00 3,000.00 0.0 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 0.00 1,750.00 0.0 01-210-62-00-5430 HEALTH SERVICES 45.00 45.00 3,500.00 1.2 01-210-62-00-5431 LABORATORY FEES 0.00 0.00 1,500.00 0.0 01-210-62-00-5436 TELEPHONE 0.00 0.00 20,000.00 0.0 01-210-62-00-5438 CELLULAR TELEPHONE 0.00 0.00 14,500.00 0.0 01-210-62-00-5441 MTD-ALERTS FEE 0.00 0.00 8,450.00 . 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 1,298.80 1,298.80 134,725.00 0.9 PROFESSIONAL DEVELOPMENT 01-210-64-00-5600 DUES 800.00 800.00 2, 500.00 32.0 01-210-64-00-5603 SUBSCRIPTIONS 0.00 0.00 350.00 0.0 01-210-64-00-5604 TRAINING & CONFERENCE 300.00 300.00 19,950.00 1.5 01-210-64-00-5605 TRAVEL EXPENSES 29.68 29.68 10,500.00 0.2 01-210-64-00-5606 COMMUNITY RELATIONS 0.00 0.00 7,800.00 0. 0 01-210-64-00-5607 POLICE COMMISSION 0.00 0.00 21,000.00 0.0 01-210-64-00-5608 TUITION REIMBURSEMENT 0.00 0.00 14,000.00 0.0 01-210-64-00-5609 POLICE RECRUIT ACADEMY 0.00 0.00 10,500.00 0.0 01-210-64-00-5610 GUN RANGE FEES 0.00 0.00 700.00 0.0 01-210-64-00-5611 SRT FEE 0.00 0.00 3,500.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 1,129.68 1,129.68 90,800.00 1.2 OPERATIONS 01-210-65-00-5802 OFFICE SUPPLIES 38.90 38.90 6,825.00 0.5 01-210-65-00-5804 OPERATING SUPPLIES 22.68 22.68 16,800.00 0. 1 01-210-65-00-5808 POSTAGE & SHIPPING 0.00 0.00 3,500.00 0. 0 01-210-65-00-5809 PRINTING & COPYING 0.00 0.00 4,725.00 0.0 P8 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 9 TIME: 08:10:16 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: GENERAL FUND FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PUBLIC SAFETY/POLICE DEPT. EXPENSES OPERATIONS 01-210-65-00-5810 PUBLISHING & ADVERTISING 0.00 0.00 1,500.00 0.0 01-210-65-00-5812 GASOLINE 0.00 0.00 63, 000.00 0.0 01-210-65-00-5813 AMMUNITION 0.00 0.00 5,500.00 0.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS 61.58 61.58 101,850.00 0.0 RETIREMENT 01-210-72-00-6500 IMRF PARTICIPANTS 997.54 997.54 9, 671.00 10.3 01-210-72-00-6501 SOCIAL SECURITY & MEDICARE 13,954.96 13,954.96 137,591.00 10.1 01-210-72-00-6502 POLICE PENSION 0.00 0.00 250,000.00 0.0 --------------------------------------------------------------------------------- TOTAL RETIREMENT 14,952.50 14,952.50 397,262.00 3.7 CAPITAL OUTLAY 01-210-75-00-7002 COMPUTER EQUIP & SOFTWARE 489.00 489.00 9,500.00 5.1 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 489.00 489.00 9,500.00 5.1 OTHER OPERATING EXPENSES 01-210-78-00-9004 BIKE PATROL 0.00 0.00 2,500.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING EXPENSES 0.00 0.00 2,500.00 0.0 TOTAL EXPENSES: PUBLIC SAFETY/POLICE DEPT. 201,516.49 , 201,516.49 2,561,214.00 7.8 PLANNING & DEVELOPMENT EXPENSES PERSONNEL SERVICES 01-220-50-00-5107 EMPLOYEE SALARIES 0.00 0.00 218,000.00 0.0 -------------------------------------------=------------------------------------- TOTAL PERSONNEL SERVICES 0.00 0.00 218,000.00 0.0 PROFESSIONAL SERVICES P9 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 10 TIME: 08:10:16 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: GENERAL FUND FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL °s ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PLANNING & DEVELOPMENT EXPENSES PROFESSIONAL SERVICES 01-220-61-00-5300 LEGAL SERVICES 0.00 0.00 20,000.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 0.00 0.00 20,000.00 0.0 CONTRACTUAL SERVICES 01-220-62-00-5401 CONTRACTUAL SERVICES 0.00 0.00 80,000.00 0.0 01-220-62-00-5430 PLANNING CONSULTANT 0.00 0.00 70,000.00 0.0 01-220-62-00-5432- ECONOMIC DEVELOPMENT 0.00 0.00 45,000.00 0.0 01-220-62-00-5438 CELULAR TELEPHONE 0.00 0.00 1,000.00. 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 0.00 0.00 196,000.00 0.0 PROFESSIONAL DEVELOPMENT 01-220-64-00-5600 DUES 0.00 0.00 1,000.00 0.0 01-220-64-00-5604 TRAINING & CONFERENCES 0.00 0.00 6,000.00 0.0 01-220-64-00-5605 TRAVEL EXPENSE 0.00 0.00 3,000.00 0.0 01-220-64-00-5616 BOOKS & PUBLICATIONS 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 0.00 0.00 10,000.00 0.0 OPERATIONS 01-220-65-00-5804 OPERATING SUPPLIES 44.54 44.54 5,000.00 0.8 01-220-65-00-5809 PRINTING & COPYING 22.95 22.95 2,500.00 0.9 01-220-65-00-5810 PUBLISHING & ADVERTISING 0.00 0.00 8,000.00 0.0 01-220-65-00-5814 BOOKS & MAPS 0.00 0.00 4,000.00 0.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS 67.49 67.49 19,500.00 0.3 RETIREMENT 01-220-72-00-6500 IMRF PARTICIPANTS 0.00 0.00 17,222.00 0.0 01-220-72-00-6501 SOCIAL SECURITY & MEDICARE 0.00 0.00 16,677.00 0.0 --------------------------------------------------------------------------------- TOTAL RETIREMENT 0.00 0.00 33,899.00 0.0 CAPITAL OUTLAY P10 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 11 TIME: 08:10:16 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: GENERAL FUND FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL % ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED --------------------------------------------------------------=--------------------------------------------------------------------- PLANNING & DEVELOPMENT EXPENSES CAPITAL OUTLAY 01-220-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 0.00 25,000.00 0.0 01-220-75-00-7003 OFFICE EQUIPMENT 393.23 393.23 3,000.00 13.1 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 393.23 393.23 28,000.00 1.4 TOTAL EXPENSES: PLANNING & DEVELOPMENT 460.72 460.72 525,399.00 0.0 STREETS EXPENSES PERSONNEL SERVICES 01-410-50-00-5107 SALARIES - EMPLOYEE 25,070.62 25,070.62 225,437.00 11.1 01-410-50-00-5136 SALARIES - PART TIME 648.00 648.00 8,500.00 7.6 01-410-50-00-5137 SALARIES - OVERTIME 1,194.52 1,194.52 20,000.00 5.9 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 26,913.14 26,913.14 253,937.00 10.5 PROFESSIONAL SERVICES 01-410-61-00-5313 ENGINEERING - IN TOWN RD PROG 0.00 0.00 261,802.00 0.0 01-410-61-00-5314 INSPECTIONS & LICENSES 0.00 0.00 400.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 0.00 0.00 262,202.00 0.0 CONTRACTUAL SERVICES 01-410-62-00-5401 CONTRACTUAL SERVICES 0.00 0.00 2,000.00 0.0 01-410-62-00-5408 MAINTENANCE-EQUIPMENT 0.00 0.00 8,000.00 0.0 01-410-62-00-5409 MAINTENANCE-VEHICLES 0.00 0.00 9,000.00 0.0 01-410-62-00-5414 MAINTENANCE-TRAFFIC SIGNALS 0.00 0.00 18,000.00 0.0 01-410-62-00-5415 MAINTENANCE-STREET LIGHTS (2,214.69) (2,214.69) 25,000.00 (8.8) 01-410-62-00-5420 MAINTENANCE-STORM SEWER 0.00 0.00 10,000.00 0.0 01-410-62-00-5421 WEARING APPAREL 0.00 0.00 6,000.00 0.0 01-410-62-00-5434 RENTAL-EQUIPMENT 0.00 0.00 2,000.00 0.0 01-410-62-00-5435 ELECTRICITY 0.00 0.00 60,000.00 0.0 01-410-62-00-5438 CELLULAR TELEPHONE 0.00 0.00 3,300.00 0.0 P11 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 12 TIME: 08:10:16 DETAILED REVENUE &EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: . GENERAL FUND FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ STREETS EXPENSES CONTRACTUAL SERVICES 01-410-62-00-5440 STREET LIGHTING 0.00 0.00 6,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES (2,214.69) (2,214.69) 149,300.00 (1.4) PROFESSIONAL DEVELOPMENT 01-410-64-00-5604 TRAINING & CONFERENCES (50.00) (50.00) 5,000.00 (1.0) --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT (50.00) (50.00) 5,000.00 (1.0) OPERATIONS 01-410-65-00-5804 OPERATING SUPPLIES 0.00 0.00 30,000.00 0.0 01-410-65-00-5812 GASOLINE 0.00 0.00 27,500.00 0.0 01-410-65-00-5815 HAND TOOLS 0.00 0.00 2,500.00 0.0 01-410-65-00-5817 GRAVEL 0.00 0.00 6,500.00 0.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS 0.00 0.00 66,500.00 0.0 RETIREMENT 01-410-72-00-6500 IMRF PARTICIPANTS 2,074.94 2,074.94 19,390.00 10.7 01-410-72-00-6501 SOCIAL SECURITY & MEDICARE 2, 058.90 2,058.90 19,426.00 10.5 --------------------------------------------------------------------------------- TOTAL RETIREMENT 4, 133.84 4,133 .84 38,816.00 10.6 CAPITAL OUTLAY 01-410-75-00-5418 MOSQUITO CONTROL 21,.310.50 21,310.50 27,000.00 78 .9 01-410-75-00-7004 SAFETY EQUIPMENT 0.00 0.00 1,000.00 0.0 01-410-75-00-7099 GRANDE RESERVE PERIMETER ROADS 0.00 0.00 1,600,000.00 0.0 01-410-75-00-7100 STREET REHAB PROJECTS 0.00 0.00 75, 000.00 0.0 01-410-75-00-7101 IN TOWN ROAD PROGRAM 0.00 0.00 1, 588,198.00 0.0 01-410-75-00-7102 TREE & STUMP REMOVAL 0.00 0.00 25,000.00 0.0 01-410-75-00-7103 SIDEWALK CONSTRUCTION 0.00 0.00 25,000.00 0.0 01-410-75-00-7104 FOX HILL SSA EXPENSES 0.00 0.00 18,000.00 0.0 01-410-75-00-7106 ROAD CONTRIBUTION FUND PROJ 0.00 0.00 30,000.00 0.0 01-410-75-00-7107 ROAD CONTRIBUTION FUND-RESERVE 0.00 0.00 1,500,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 21,310.50 21,310.50 4,889,198.00 0.4 P12 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 13 TIME: 08: 10:16 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: GENERAL FUND FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ STREETS TRANSFERS 01-410-99-00-9930 TRANSFER TO WATER IMPROVEMENT 0.00 0.00 220,000.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 220,000.00 0.0 TOTAL EXPENSES: STREETS 50,092.79 50,092.79 5,884, 953.00 0.8 HEALTH & SANITATION EXPENSES CONTRACTUAL SERVICES 01-540-62-00-5442 GARBAGE SERVICES 0.00 0.00 676,163.00 0.0 01-540-62-00-5443 LEAF PICKUP 0.00 0.00 5, 000.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 0.00 0.00 681,163.00 0.0 TOTAL EXPENSES: HEALTH & SANITATION 0.00 0.00 681, 163.00 0.0 TOTAL FUND REVENUES 836,159.97 836,159.97 16,583,575.00 5.0 " TOTAL FUND EXPENSES 499,402.33 499,402.33 16,583,575.00 3.0 FUND SURPLUS (DEFICIT) 336,757.64 336,757.64 0.00 -100.0 P13 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 14 TIME: 08:10:16 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: MOTOR FUEL TAX FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL w ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES TAXES 15-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 300,000.00 0.0 15-000-40-00-4060 MOTOR FUEL TAX ALLOTMENTS 20,139.74 20,139.74 318,601.00 6.3 --------------------------------------------------------------------------------- TOTAL TAXES 20,139.74 20,139.74 618,601.00 3.2 INTEREST 15-000-46-00-4600 INVESTMENT INCOME 1,865.34 1,865.34 12,000.00 15.5 --------------------------------------------------------------------------------- TOTAL INTEREST 1,865.34 1,865.34 12,000.00 15.5 TOTAL REVENUES: 22,005.08 22,005.08 630,601.00 3.4 EXPENSES OPERATIONS 15-000-65-00-5800 CONTINGENCY 0.00 0.00 34,011.00 0.0 15-000-65-00-5818 SALT 0.00 0.00 60,000.00 0.0 TOTAL OPERATIONS 0.00 0.00 94,011.00 0.0 CAPITAL OUTLAY 15-000-75-00-7007 SIGNS 0.00 0.00 9,990.00 0.0 15-000-75-00-7008 CRACK FILLING 0.00 0.00 40,000.00 0.0 15-000-75-00-7107 CONSTRUCTION ENGINEERING 0.00 0.00 150,000.00 0.0 15-000-75-00-7110 COLD PATCH 0.00 0.00 8,000.00 0.0 15-000-75-00-7111 HOT PATCH 0.00 0.00 9,600.00 0.0 15-000-75-00-7113 COUNTRYSIDE PKWY CONSTRUCTION 0.00 0.00 300,000.00 0.0 15-000-75-00-7114 ROUTE 126/71 TRAFFIC SIGNALS 0.00 0.00 19,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 0.00 536,590.00 0.0 TOTAL EXPENSES: 0.00 0.00 630,601.00 0.0 TOTAL FUND REVENUES 22,005.08 22,005.08 630,601.00 3.4 TOTAL FUND EXPENSES 0.00 0.00 630,601.00 0.0 FUND SURPLUS (DEFICIT) 22,005.08 22,005.08 0.00 100.0 P14 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 15 TIME: 08:10:16 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: MUNICIPAL BUILDLING FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY 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 32,500.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 32,500.00 0.0 CHARGES FOR SERVICES 16-000-42-00-4211 DEVELOPMENT FEES-BUILDING 40, 950.00 40,950.00 137,423 .00 29.7 16-000-42-00-4215 BEECHER RENTAL FEE 1, 000.00 1,000.00 12,000.00 8.3 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 41, 950.00 41,950.00 149,423.00 28.0 TRANSFERS 16-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 0.00 30,865.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 30,865.00 0.0 TOTAL REVENUES: 41, 950.00 41, 950.00 .212,788.00 19.7 EXPENSES CONTRACTUAL SERVICES 16-000-62-00-5402 RECREATION RENTAL FEE 0.00 0.00 32,500.00 0.0 16-000-62-00-5416 MAINT-GENERAL BLDG & GROUNDS 0.00 0.00 51000.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 0.00 0.00 37,500.00 0.0 CAPITAL OUTLAY 16-000-75-00-7008 ENTRY WAY SIGNS 0.00 0.00 4,000.00 0.0 16-000-75-00-7200 BLDG IMPROV- BEEHCER/RIVFRNT 0.00 0.00 10,000.00 0.0 16-000-75-00-7203 BLDG IMPROVEMENTS-PUBLIC WORKS 150.00 150.00 10,000.00 1.5 16-000-75-00-7204 BLDG MAINT - CITY HALL 115.00 115.00 12,000.00 0.9 16-000-75-00-7205 BLDG IMPROVEMENTS-LIBRARY 0.00 0.00 4,000.00 0.0 16-000-75-00-7206 LANDSCAPING-PUBLIC BUILDINGS 0.00 0.00 2,000.00 0.0 16-000-75-00-7210 BLDG IMPROV-POST OFFICE 0.00 0.00 30,865.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 265.00 265.00 72,865.00 0.3 P15 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 16 TIME: 08:10:16 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: MUNICIPAL BUILDLING FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TRANSFERS 16-000-99-00-9965 TRANSFER TO DEBT SERVICE 0.00 0.00 102,423.00 0.0 TOTAL TRANSFERS 0.00 0.00 102,423.00 0.0 TOTAL EXPENSES: 265.00 265.00 212,788.00 0.1 TOTAL FUND REVENUES 41,950.00 41,950.00 212,788.00 19.7 TOTAL FUND EXPENSES 265.00 265.00 212,788.00 0.1 FUND SURPLUS (DEFICIT) 41,685.00 41,685.00 0.00 100.0 Z P16 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 17 TIME: 08:10:16 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: POLICE EQUIPMENT CAPITAL FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY 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 0.00 169,648 .00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 169,648.00 0.0 CHARGES FOR SERVICES 20-000-42-00-4212 DEV FEES - POLICE 17,250.00 17,250.00 188,000.00 9.1 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 17,250.00 17,250.00 188,000.00 9.1 MISCELLANEOUS 20-000-44-00-4402 K-9 DONATIONS 0.00 0.00 1,000.00 0.0 20-000-44-00-4403 IN CAR VIDEO DONATIONS 100.00 100.00 2,500.00 4.0 20-000-44-00-4404 DONATIONS 0.00 0.00 1,000.00 0.0 20-000-44-00-4405 WEATHER WARNING SIREN 8,357.85 8,357.85 20,000.00 41.7 20-000-44-00-4431 SALE OF POLICE SQUADS 0.00 0.00 500.00 0.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 8,457.85 8,457.85 25,000.00 33.8 TRANSFERS 20-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 0.00 75,000.00 0.0 ---------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 75,000.00 0.0 TOTAL REVENUES: 25,707.85 25,707.85 457,648.00 5.6 EXPENSES WEAPONS 20-000-65-00-5811 LETHAL/NON-LETHAL WEAPONS 0.00 0.00 7,000.00 0.0 --------------------------------------------------------------------------------- TOTAL WEAPONS 0.00 0.00 7,000.00 0.0 CAPITAL OUTLAY 20-000-75-00-7001 EQUIPMENT 0.00 0.00 36,722.00 0.0 20-000-75-00-7002 K-9 EQUIPMENT 0.00 0.00 1,500.00 0.0 P17 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 18 TIME: 08:10:16 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: POLICE EQUIPMENT CAPITAL FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES CAPITAL OUTLAY 20-000-75-00-7005 VEHICLES 0.00 0.00 97,222.00 0.0 20-000-75-00-7006 CAR BUILD OUT 0.00 0.00 49,415.00 0.0 20-000-75-00-7008 NEW WEATHER WARNING SIRENS 0.00 0.00 37,000.00 0.0 20-000-75-00-7009 RESERVE-WEATHER WARNING SIREN 0.00 0.00 82,648.00 0.0 20-000-75-00-7010 NEW WORLD SOFTWARE 0.00 0.00 125,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 0.00 429,507.00 0.0 OTHER 20-000-78-00-9009 RESERVE 0.00 0.00 21,141.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 21,141.00 0.0 TOTAL EXPENSES: 0.00 0.00 457,648.00 0.0 TOTAL FUND REVENUES 25,707.85 25,707.85 457,648.00 5.6 TOTAL FUND EXPENSES 0.00 0.00 457,648.00 0.0 FUND SURPLUS (DEFICIT) 25,707.85 25,707.85 0.00 100.0 P18 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 19 TIME: 08:10:17 DETAILED REVENUE & EXPENSE, REPORT F-YR: 07 ID: GL470002.WOW FUND: PUBLIC WORKS EQUIP CAPITAL FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 21-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 175,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 175,000.00 0.0 CHARGES FOR SERVICES 21-000-42-00-4213 DEVELOPMENT FEES-PUBLIC WORKS 43,350.00 43,350.00 435,000.00 9.9 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 43,350.00 43,350.00 435,000.00 9.9 MISCELLANEOUS 21-000-44-00-4430 SALE OF EQUIPMENT 0.00 0.00 40,000.00 0.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 0.00 0.00 40, 000.00 0.0 TRANSFERS 21-000-49-00-4915 TRANSFER FROM WATER FUND 0.00 0.00 50,000.00 0.0 21-000-49-00-4920 TRANSFER FROM SEWER FUND 0.00 0.00 30,000.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 80,000.00 0.0 TOTAL REVENUES: 43,350.00 43,350.00 730,000.00 5.9 EXPENSES CAPITAL OUTLAY 21-000-75-00-7001 EQUIPMENT 0.00 0.00 150,000.00 0.0 21-000-75-00-7005 VEHICLES 0.00 0.00 309,000.00 0.0 21-000-75-00-7015 SKIDSTEER UPGRADE 0.00 0.00 4,500.00 0.0 21-000-75-00-7107 TRUCK ACCESSORIES 0.00 0.00 14,000.00 0.0 21-000-75-00-7130 BLDG ADDITION - SALT DOME 0.00 0.00 200,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 0.00 677,500.00 0.0 OTHER 21-000-78-00-9009 RESERVE 0.00 0.00 52,500.00 0.0 P19 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 20 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: PUBLIC WORKS EQUIP CAPITAL FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL a ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 52,500.00 0.0 TOTAL EXPENSES: 0.00 0.00 730,000.00 0.0 TOTAL FUND REVENUES 43,350.00 43,350.00 730,000.00 5.9 TOTAL FUND EXPENSES 0.00 0.00 730,000.00 0.0 FUND SURPLUS (DEFICIT) 43,350.00 43,350.00 0.00 100.0 P20 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 21 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: PARKS & REC EQUIP CAPITAL FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL °s ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED --------------------------------------------------------------------------------------------------------------`--------------------- REVENUES CARRY OVER 22-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 13,100.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 13,100.00 0.0 CHARGES FOR SERVICES 22-000-42-00-4216 PARKS CAPITAL FEE 2,200.00 2,200.00 26,000.00 8.4 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 2,200.00 2,200.00 26,000.00 8.4 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 TRANSFERS 22-000-49-00-4930 TRANSFER FROM GENERAL FUND 0.00 0.00 150,000.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 150,000.00 0.0 TOTAL REVENUES: 2,200.00 2,200.00 199,100.00 1.1 PARKS EXPENSES CAPITAL OUTLAY 22-610-75-00-7006 PICK UP TRUCK 0.00 0.00 75,000.00 0.0 22-610-75-00-7009 COMPUTER WORKSTATIONS 0.00 0.00 1,500.00 0.0 22-610-75-00-7013 PLAYGROUND REPAIRS 0.00 0.00 0.00 0.0 22-610-75-00-7014 SIGN REPLACEMENT 0.00 0.00 0.00 0.0 22-610-75-00-7015 MOWER 0.00 0.00 15,000.00 0.0 22-610-75-00-7017 RECREATION EQUIPMENT 0.00 0.00 2,600.00 0.0 22-610-75-00-7018 PARK RE-DEVELOPEMENTS 0.00 0.00 105,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 0.00 199, 100.00 0.0 P21 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 22 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: PARKS & REC EQUIP CAPITAL - FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TOTAL EXPENSES: PARKS 0.00 0.00 199, 100.00 0.0 TOTAL FUND REVENUES 2,200.00 2,200.00 199, 100.00 1.1 TOTAL FUND EXPENSES 0.00 0.00 199,100.00 0.0 FUND SURPLUS (DEFICIT) 2,200.00 2,200.00 0.00 100.0 P22 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 23 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002 .WOW FUND: SANITARY SEWER IMPROVEMENT FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 37-000-40-00-3999 CARRY OVER 0.00 0.00 3,130,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 3,130,000.00 0.0 CHARGES FOR SERVICES 37-000-42-00-4220 CONNECTION FEES 147,000.00 147,000.00 1,576,800.00 9.3 37-000-42-00-4221 RIVER CROSSING FEES 136.50 136.50 20,000.00 0.6 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 147, 136.50 147,136.50 1,596,800.00 9.2 INTEREST 37-000-46-00-4600 INVESTMENT INCOME 26,866.61 26,866.61 150,000.00 17.9 -------------------------------------------'-------------------------------------- TOTAL INTEREST 26,866.61 26,866.61 150,000.00 17.9 OTHER OPERATING RECEIPTS 37-000-48-00-4804 SOUTHWEST, SVC AREA INTERCEPTOR 21,363.00 21,363.00 5,500,00.0.00 0.3 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING RECEIPTS 21,363.00 21,363.00 5, 500, 000.00 0.3 TRANSFERS 37-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 0.00 150,000.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 150,000.00 0.0 TOTAL REVENUES: 195,366.11 195,366.11 10,526,800.00 1.8 EXPENSES CONTRACTUAL SERVICES 37-000-62-00-5401 CONTRACTURAL/PROFESSIONAL SERV 0.00 0.00 40,000.00 0.0 37-000-62-00-5402 ENG/LGL/CONTINGNCY-COUNTRYSIDE 0.00 0.00 0.00 0.0 37-000-62-00-5405 ENG/LGL/CONTINGENCY-BRUELL ST. 0.00 0.00 .0.00 0.0 37-000-62-00-5406 ENG/LGL/CONTINGENCY-HYDRAULIC 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 0.00 0.00 40,000.00 0.0 P23 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 24 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: SANITARY SEWER IMPROVEMENT FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ OTHER 37-000-65-00-5421 GIS SYSTEM 0.00 0.00 5,000.00 0.0 37-000-65-00-5800 CONTINGENCY 0.00 0.00 796,759.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 801,759.00 0.0 DEBT SERVICE 37-000-66-00-6012 DEBT ISSUANCE COSTS 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL DEBT SERVICE 0.00 0.00 0.00 0.0 CAPITAL OUTLAY 37-000-75-00-7503 COUNTRYSIDE INTERCEPTOR 0.00 0.00 0.00 0.0 37-000-75-00-7504 BRUELL STREET LIFT STATION 0.00 0.00 0.00 0.0 37-000-75-00-7505 ROB ROY CREEK SANITARY 0.00 0.00 3,130,000.00 0.0 37-000-75-00-7506 SOUTHWEST SVC AREA INTERCEPTOR 0.00 0.00 5,500,000.00 0.0 37-000-75-00-7508 MANHOLE REHAB PROJECT 0.00 0.00 15,000.00 0.0 37-000-75-00-7509 SCADA SYSTEM 0.00 0.00 100,000.00 0.0 37-000-75-00-7510 FOX HILL SANITARY SEWER RECAP. 0.00 0.00 150,000.00 0.0 37-000-75-00-7515 HEARTLAND ONSITE INTERCEPTOR 0.00 0.00 0.00 0.0 TOTAL CAPITAL OUTLAY 0.00 0.00 8,895,000.00 0.0 TRANSFERS 37-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 0.00 150,000.00 0.0 37-000-99-00-9965 TRANSFER TO DEBT SERVICE 0.00 0.00 640,041.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 790,041.00 0.0 TOTAL EXPENSES: 0.00 0.00 10,526,800.00 0.0 TOTAL FUND REVENUES 195,366.11 195,366.11 10,526,800.00 1.8 TOTAL FUND EXPENSES 0.00 0.00 10,526,800.00 0.0 FUND SURPLUS (DEFICIT) 195,366.11 195,366.11 0.00 100.0 P24 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 25 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 41-000-40-00-3999 CARRY OVER 0.00 0.00 1,945,082.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 1, 945, 082.00 0.0 CHARGES FOR SERVICES 41-000-42-00-4220 CONNECTION FEES 207,902.86 207,902.86 2,083, 000.00 9.9 41-000-42-00-4221 SOUTHWEST WATER MAIN REVENUE 0.00 0.00 2, 648,276.00 0.0 ---------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 207, 902.86 207,902.86 4,731,276.00 4.3 INTEREST 41-000-46-00-4600 INVESTMENT INCOME 5,768.12 5,768.12. 55, 000.00 10.4 --------------------------------------------------------------------------------- TOTAL INTEREST 5,768.12 5,768.12 55,000.00 10.4 OTHER OPERATING RECEIPTS 41-000-48-00-4800 LOAN PROCEEDS-CONTRACT B.1 0.00 0.00 1,412,960.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING RECEIPTS 0.00 0.00 1,412, 960,00 0.0 TRANSFERS 41-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 0.00 220, 000.00 0.0 --------------------------------------------------=------------------------------ TOTAL TRANSFERS 0.00 0.00 220, 000.00 0.0 TOTAL REVENUES: 213,670.98 213,670.98 8,364,318.00 2 .5 EXPENSES PROFESSIONAL SERVICE 41-000-61-00-5300 LEGAL SERVICES 0.00 0.00 8, 000.00 0.0 41-000-61-00-5301 ENGINEERING - GENERAL SERVICES 0.00 0.00 20, 000.00 0.0 41-000-61-00-5400 RADIUM COMPLIANCE-CONT. B2 & 3 0.00 0.00 1,238, 082.00 0.0 41-000-61-00-5401 ENGINEERING-RADIUM CONT B2 & 3 0.00 0.00 75, 000.00 0.0 41-000-61-00-5402 ENGINEERING-SW H2O PROJECT-F 0.00 0.00 164,036.00 0.0 P25 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 26 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL °s ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES PROFESSIONAL SERVICE 41-000-61-00-5405 PROF. SVCS- RADIUM CONT B2 & 3 0.00 0.00 20,000.00 0.0 41-000-61-00-5406 CONTRACT B.1 PROFESSIONAL SVCS 0.00 0.00 75,000.00 0.0 41-000-61-00-5407 CONTRACT B.1 CONSTRUCTION 0.00 0.00 1,337,960.00 0.0 41-000-61-00-5408 CENTRAL ZONE - CONTRACT C 0.00 0.00 102,702.00 0.0 41-000-61-00-5410 ENGINEERING-CENTRAL ZONE C 0.00 0.00 10,000.00 0.0 41-000-61-00-5414 CONTRACT D SCADA SYSTEM 0.00 0.00 0.00 0.0 41-000-61-00-5415 USGS GROUNDWATER STUDY 0.00 0.00 10,500.00 0.0 41-000-61-00-5416 USGS GROUNDWATER COUNTYWIDE 0.00 0.00 15,000.00 0.0 41-000-61-00-5417 USGS GROUNDWATER SHALLOW WATER 0.00 0.00 50,000.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICE 0.00 0.00 3,126,280.00 0.0 OTHER 41-000-65-00-5421 GIS SYSTEM 0.00 0.00 5,000.00 0.0 41-000-65-00-5800 CONTINGENCY 0.00 0.00 1,124,677.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 1,129,677.00 0.0 CAPITAL OUTLAY 41-000-75-00-7503 SOUTHWEST WATER MAIN PROJECT F 0.00 0.00 2,484,240.00 0.0 41-000-75-00-7504 NORTH WATER TOWER-CONTRACT A 0.00 0.00 0.00 0.0 41-000-75-00-7507 OVERSIZING - HEARTLAND CIRCLE 0.00 0.00 0.00 0.0 41-000-75-00-7509 SCADA SYSTEM 0.00 0.00 450,000.00 0.0 41-000-75-00-7520 WATERMAIN PROJECTS 0.00 0.00 311,000.00 0.0 41-000-75-00-7522 IN TOWN ROAD PROG WATER PROJ 0.00 0.00 220,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00" 0.00 3,465,240.00 0.0 TRANSFERS 41-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 0.00 200,000.00 0.0 41-000-99-00-9965 TRANSFER TO DEBT FUND 0.00 0.00 443,121.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 643,121.00 0.0 TOTAL EXPENSES: 0.00 0.00 8,364,318.00 0.0 P26 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 27 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL k ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TOTAL FUND REVENUES 213,670.98 213,670.98 8,364,318.00 2.5 TOTAL FUND EXPENSES 0.00 0.00 8,364,318.00 0.0 FUND SURPLUS (DEFICIT) 213,670.98 213,670.98 0.00 100.0 P27 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 28 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: , GL470002.W0W FUND: DEBT SERVICE FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES MISCELLANEOUS 42-000-44-00-4440 RECAPTURE-WATER/SEWER 22,577.32 22,577.32 125,000.00 18.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 22,577.32 22,577.32 125,000.00 18.0 TRANSFERS 42-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 0.00 292,859.00 0.0 42-000-49-00-4925 TRANSFER FROM SANITARY SEWER 0.00 0.00 640,041.00 0.0 42-000-49-00-4930 TRANSFER FROM WATER IMPRV FUND 0.00 0.00 443,121.00 0.0 42-000-49-00-4940 TRANSFER FROM MUNICIPAL BLDG 0.00 0.00 102,423.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 1,478,444.00 0.0 TOTAL REVENUES: 22,577.32 22,577.32 1,603,444.00 1.4 EXPENSES DEBT SERVICE 42-000-66-00-6001 CITY HALL BONDS-PRINCIPAL PMT 0.00 0.00 50,000.00 0.0 42-000-66-00-6002 CITY HALL BONDS - INTEREST PMT 0.00 0.00 52,423.00 0.0 42-000-66-00-6003 IRBB-BRUELL ST. INTEREST PMTS 0.00 0.00 83,795.00 0.0 42-000-66-00-6004 IRBB-BRUELL ST. PRINCIPAL PYMT 0.00 0.00 80,000.00 0.0 42-000-66-00-6005 NORTH H2O TOWER INTEREST PYMT 0.00 0.00 2,832.00 0.0 42-000-66-00-6006 NORTH H2O TOWER PRINCIPAL PYMT 0.00 0.00 22,169.00 0.0 42-000-66-00-6007 4.8 MILLION DEBT CERT INT PYMT 116,575.00 116,575.00 233,150.00 50.0 42-000-66-00-6008 COUNTRYSIDE ALT REV PRINC PYMT 0.00 0.00 125,000.00 0.0 42-000-66-00-6009 COUNTRYSIDE ALT REV INT PYMT 0.00 0.00 117,638.00 0.0 42-000-66-00-6010 COMED/HYDRAULIC INTEREST PYMT 0.00 0.00 41,328.00 0.0 42-000-66-00-6011 COM ED/HYDRAUL DEBT CERT PRINC 0.00 0.00 140,000.00 0.0 42-000-66-00-6045 LOAN PMT - SSES IEPA PRINCIPAL 0.00 0.00 31,275.00 0.0 42-000-66-00-6049 SANITARY SIPHON INTEREST PMT 0.00 0.00 8,301.00 0.0 42-000-66-00-6050 SANITARY SIPHON-PRINCIPAL PMT 0.00 0.00 30,679.00 0.0 42-000-66-00-6055 LOAN PAYMENT-SSES IEPA L171153 0.00 0.00 75,775.00 0.0 42-000-66-00-6070 $650K ROAD IMPROV PROG INT 0.00 0.00 26,070.00 0.0 42-000-66-00-6071 $650K ROAD IMPROV PROG PRINC 0.00 0.00 65,000.00 0.0 42-000-66-00-6072 $2 MIL ALT REV B.2&3 INT PYMT 0.00 0.00 90,150.00 0.0 P28 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 29 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: DEBT SERVICE FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET. EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES DEBT SERVICE 42-000-66-00-6073 2 MIL ALT REV (B.2 & B3) PRINC 0.00 0.00 35,000.00 0.0 42-000-66-00-6074 $3.825 MIL IN TOWN ROAD - INT. 0.00 0.00 262,859.00 0.0 42-000-66-00-6075 $3.825 MIL IN TOWN ROAD PRINC 0.00 0.00 30,000.00 0.0 --------------------------------------------------------------------------------- TOTAL DEBT SERVICE 116,575.00 116,575.00 1,603,444.00 7.2 TOTAL FUND REVENUES 22,577.32 22,577.32 1,603,444.00 1.4 TOTAL FUND EXPENSES 116,575.00 116,575.00 1,603,444.00 7.2 FUND SURPLUS (DEFICIT) (93, 997.68) (93,997.68) 0.00 100.0 P29 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 30 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 51-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 500, 000.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 500,000.00 0.0 CHARGES FOR SERVICES 51-000-42-00-4240 BULK WATER SALES 1,336.00 1,336.00 10,000.00 13.3 51-000-42-00-4241 WATER SALES 684.02 684.02 1,150,000.00 0.0 51-000-42-00-4242 WATER METER SALES 59,820.00 59,820.00 220, 000.00 27.1 51-000-42-00-4243 LEASE REVENUE - H2O TOWER 1,909.62 1, 909.62 25,000.00 7.6 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 63,749.64 63,749.64 1,405,000.00 4 .5 MISCELLANEOUS 51-000-44-00-4490 MISCELLANEOUS INCOME 0.00 0.00 2,000.00 0.0 --------------------------------------------------------------------------------- r TOTAL MISCELLANEOUS 0.00 0.00 2,000.00 0.0 INTEREST 51-000-46-00-4600 INVESTMENT INCOME 4,953.67 4,953.67 15,000.00 33.0 ------------------------------=-------------------------------------------------- TOTAL INTEREST 4,953.67 4,953.67 .15,000.00 33.0 TOTAL REVENUES: 68,703.31 68,703.31 1,922, 000.00 3.5 EXPENSES PERSONNEL 51-000-50-00-5107 SALARIES - EMPLOYEE 30,783 .24 30,783.24 318,439.00 9.6 51-000-50-00-5136 SALARIES-PART TIME 0.00 0.00 8,500.00 0.0 51-000-50-00-5137 SALARIES - OVERTIME 4,894.74 4,894.74 40,000.00 12.2 --------------------------------------------------------------------------------- TOTAL PERSONNEL 35,677.98 35,677.98 366,939.00 9.7 PROFESSIONAL SERVICES 51-000-61-00-5300 LEGAL SERVICES 0.00 0.00 2,000.00 0.0 P30 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 31 TIME: 08 :10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES PROFESSIONAL SERVICES 51-000-61-00-5303 JULIE SERVICE 0.00 0.00 10,000.00 0.0 TOTAL PROFESSIONAL SERVICES 0.00 0.00 12,000.00 0.0 CONTRACTURAL SERVICES 51-000-62-00-5401 CONTRACUAL SERVICES 1,000.00 1,000.00 5,000.00 20.0 51-000-62-00-5407 TREATMENT FACILITIES O&M 0.00 0.00 100,000.00 0.0 51-000-62-00-5408 MAINTENANCE-EQUIPMENT 0.00 0.00 9, 000.00 0.0 51-000-62-00-5409 MAINTENANCE - VEHICLES 0.00 0.00 7,000.00 0.0 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 0.00 10,000.00 0.0 51-000-62-00-5421 WEARING APPAREL 0.00 0.00 5,500.00 0.0 51-000-62-00-5422 WATER TOWER PAINTING 0.00 0.00 0.00 0.0 51-000-62-00-5434 RENTAL - EQUIPMENT 0.00 0.00 2,000.00 0.0 51-000-62-00-5435 ELECTRICITY 0.00 0.00 130,000.00 0.0 51-000-62-00-5436 TELEPHONE 0.00 0.00 22,000.00 0.0 51-000-62-00-5438 CELLULAR TELEPHONE 0.00 0.00 5,700.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTURAL SERVICES 1,000.00 1,000.00 297,200.00 0.3 PROFESSIONAL DEVELOPMENT 51-000-64-00-5600 DUES 0.00 0.00 1, 000.00 0.0 51-000-64-00-5603 SUBSCRIPTIONS 0.00 0.00 250.00 0.0 51-000-64-00-5604 TRAINING & CONFERENCES 0.00 0.00 5, 000.00 0.0 51-000-64-00-5605 TRAVEL EXPENSES 0.00 0.00 5,000.00 0.0 TOTAL PROFESSIONAL DEVELOPMENT 0.00 0.00 11,250.00 0.0 OPERATIONS 51-000-65-00-5800 CONTINGENCIES 0.00 0.00 30,000.00 0.0 51-000-65-00-5804 OPERATING SUPPLIES 0.00 0.00 48, 500.00 0.0 51-000-65-00-5808 POSTAGE & SHIPPING 82.17 82.17 15,000.00 0.5 51-000-65-00-5809 PRINTING & COPYING 0.00 0.00 9,075.00 0.0 51-000-65-00-5810 PUBLISHING & ADVERTISING 0.00 0.00 1,000.00 0.0 51-000-65-00-5812 GASOLINE 0.00 0.00 15,000.00 0.0 P31 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 32 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL °s ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES OPERATIONS 51-000-65-00-5815 HAND TOOLS 0.00 0.00 2,000.00 0.0 51-000-65-00-5817 GRAVEL 0.00 0.00 6,000.00 0.0 51-000-65-00-5820 CHEMICALS 0.00 0.00 30,000.00 0.0 51-000-65-00-5821 CATHODIC PROTECTION 0.00 0.00 0.00 0.0 51-000-65-00-5822 WATER SAMPLES 0.00 0.00 12,000.00 0.0 --------------------------------------------- TOTAL OPERATIONS 82.17 82.17 168,575.00 0.0 RETIREMENT 51-000-72-00-6500 IMRF PARTICIPANTS 2, 818.56 2,818.56 28,317.00 9.9 51-000-72-00-6501 SOCIAL SECURITY & MEDICARE 2,716.92 2,716.92 28,071.00 9.6 --------------------------------------------------------------------------------- TOTAL RETIREMENT 5,535.48 5,535.48 56,388.00 9.8 CAPITAL OUTLAY 51-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 0.00 5,000.00 0.0 51-000-75-00-7004 SAFETY EQUIPMENT 0.00 .0.00 3,000.00 0.0 51-000-75-00-7506 METER READERS 0.00 0.00 11,500.00 0.0 51-000-75-00-7507 HYDRANT REPLACEMENT 0.00 0.00 10,000.00 0.0 51-000-75-00-7508 METERS & PARTS 0.00 0.00 265,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 0.00 294,500.00 0.0 OTHER 51-000-78-00-9005 REFUND 0.00 0.00 1,500.0.0 0.0 51-000-78-00-9006 MERIT 0.00 0.00 10,543.00 0.0 51-000-78-00-9008 RESERVE-H20 TOWER MAINTENANCE 0.00 0.00 30,000.00 0.0 51-000-78-00-9009 RESERVE 0.00 0.00 373,105,00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 415,148.00 0.0 TRANSFERS 51-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 0.00 250,000.00 0.0 51-000-99-00-9950 TRANSFER TO PW EQUIP CAPITAL 0.00 0.00 50,000.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 300,000.00 0.0 P32 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 33 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TOTAL EXPENSES: 42,295.63 42,295.63 1, 922, 000.00 2.2 TOTAL FUND REVENUES 68,703.31 68,703.31 1,922,000.00 3.5 TOTAL FUND EXPENSES 42,295.63 42,295.63 1,922,000.00 2.2 FUND SURPLUS (DEFICIT) 26,407.68 26,407.68 0.00 100.0 P33 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 34 TIME: 06:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: SEWER MAINTENANCE FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY 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 0.00 350,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 350,000.00 0.0 CHARGES FOR SERVICES 52-000-42-00-4240 LIFT STATION INCOME 7,596.84 7,596.84 8,000.00 94.9 52-000-42-00-4250 SEWER MAINTENANCE FEES 146.43 146.43 475, 000.00 0.0 52-000-42-00-4251 SEWER CONNNECTION FEES 20,000.00 20,000.00 260,000.00 7.6 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 27,741.27 27,743.27 743, 000.00 3.7 INTEREST 52-000-46-00-4600 INVESTMENT INCOME 4,958.67 4,958.67 15,000.00 33.0 --------------------------------------------------------------------------------- TOTAL INTEREST 4,958.67 4,958.67 15,000.00 33.0 TOTAL REVENUES: 32,701.94 32,701.94 1,108,000.00 2.9 EXPENSES PERSONNEL SERVICES 52-000-50-00-5108 SALARIES-REGULAR 12,973.56 12,973.56 141, 858.00 9.1 52-000-50-00-5136 PART TIME 0.00 0.00 4,200.00 0.0 52-000-50-00-5137 SALARIES-OVERTIME 308.05 308.05 12,000.00 2.5 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 13,281.61 13,281.61 158, 058.00 8.4 CONTRACTUAL SERVICES 52-000-62-00-5401 CONTRACTUAL SERVICES 0.00 0.00 5,000.00 0.0 52-000-62-00-5408 MAINTENANCE-EQUIPMENT 22.52 22.52 5,000.00 0.4 52-000-62-00-5409 MAINTENANCE-VEHICLES 4.31 4 .31 4,000.00 0.1 52-000-62-00-5419 MAINTENANCE-SANITARY SEWER 0.00 0.00 27,500.00 0.0 52-000-62-00-5421 WEARING APPAREL 4.99 4.99 3, 500.00 0.1 52-000-62-00-5422 LIFT STATION MAINTENANCE 0.00 0.00 25, 000.00 0.0 52-000-62-00-5434 RENTAL - EQUIPMENT 0.00 0.00 1,000.00 0.0 P34 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 35 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: SEWER MAINTENANCE FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL °s ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES CONTRACTUAL SERVICES 52-000-62-00-5435 ELECTRICITY 0.00 0.00 14,400.00 0.0 52-000-62-00-5438 CELLULAR TELEPHONE 0.00 0.00 2,500.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 31.82 31.82 87,900.00 0.0 PROFESSIONAL DEVELOPMENT 52-000-64-00-5604 TRAINING & CONFERENCES 0.00 0.00 4,000.00 0.0 52-000-64-00-5605 TRAVEL/MEALS/LODGING 0.00 0.00 3, 000.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 0.00 0.00 7,000.00 0.0 OPERATIONS 52-000-65-00-5800 CONTINGENCIES 0.00 0.00 10,000.00 0.0 52-000-65-00-5802 OFFICE SUPPLIES 0.00 0.00 2,500.00 0.0 52-000-65-00-5805 SHOP SUPPLIES 0.00 0.00 2,500.00 0.0 52-000-65-00-5812 GASOLINE 0.00 0.00 14,000.00 0.0 52-000-65-00-5815 HAND TOOLS 0.00 0.00 2,000.00 0.0 52-000-65-00-5817 GRAVEL 0.00 0.00 3,000.00 0.0 52-000-65-00-5823 SEWER CHEMICALS 0.00 0.00 5,000.00 0.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS 0.00 0.00 39,000.00 0.0 RETIREMENT 52-000-72-00-6500 IMRF PARTICIPANTS 1,049.26 1,049.26 12,155.00 8.6 52-000-72-00-6501 SOCIAL SECURITY & MEDICARE 1,015.34 1,015.34 12,091.00 8.3 --------------------------------------------------------------------------------- TOTAL RETIREMENT 2,064.60 2,064.60 24,246.00 8.5 CAPITAL OUTLAY 52-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 0.00 2,500.00 0.0 52-000-75-00-7003 OFFICE EQUIPMENT 0.00 0.00 6,000.00 0.0 52-000-75-00-7004 SAFETY EQUIPMENT 0.00 0.00 2,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 0.00 10,500.00 0.0 P35 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 36 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: SEWER MAINTENANCE FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------- OTHER 52-000-78-00-9005 MERIT 0.00 0.00 5,282.00 0.0 52-000-78-00-9009 RESERVE 0.00 0.00 676,014.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 681,296.00 0.0 TRANSFERS 52-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 0.00 70,000.00 0.0 52-000-99-00-9950 TRANSFER TO PW EQUIP CAPITAL 0.00 0.00 30,000.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 100,000.00 0.0 TOTAL EXPENSES: 15,378.03 15,378.03 1,108,000.00 1.3 TOTAL FUND REVENUES 32,701.94 32,701.94 1,108,000.00 2.9 TOTAL FUND EXPENSES 15,378.03 15,378.03 1,108,000.00 1.3 FUND SURPLUS (DEFICIT) 17,323.91 17,323.91 0.00 100.0 P36 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 37 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: LAND CASH FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CONTRIBUTIONS 72-000-47-00-4700 OSLAD GRANT 0.00 0.00 362,000.00 0.0 72-000-47-00-4701 GREENBRIAR-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4703 PRAIRIE GARDEN-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4705 COUNTRY HILLS-LAND CASH 0.00 0.00 30,825.00 0.0 72-000-47-00-4707 FOX HIGHLANDS-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4709 SUNFLOWER-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4712 RIVER'S EDGE-LAND CASH 0.00 0.00 13,285.00 0.0 72-000-47-00-4715 WHITE OAK UNIT 1&2-LAND CASH 1,226.00 1,226.00 0.00 100.0 72-000-47-00-4716 WHITE OAK UNIT 3&4-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4717 KYLN'S CROSSING-LAND CASH 0.00 0.00 3,367.00 0.0 72-000-47-00-4719 WILDWOOD-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4722 KYLN'S RIDGE-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4723 HEARTLAND CIRCLE-LAND CASH 3,000.00 3,000.00 49,500.00 6.0 72-000-47-00-4725 WINDETTE RIDGE-LAND CASH 0.00 0.00 3,006.00 0.0 72-000-47-00-4727 GRAND RESERVE-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4731 MONTALBANO HOMES LAND CASH 0.00 0.00 5,256.00 0.0 72-000-47-00-4732 RAINTREE VILLAGE LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4734 WHISPERING MEADOWS (K. HILL) 12,405.58 12,405.58 41,868.00 29.6 72-000-47-00-4735 PRAIRIE MEADOWS(MENARDS RES) 0.00 0.00 505,992 .00 0.0 72-000-47-00-4736 BRIARWOOD 0.00 0.00 113,043.00 0.0 72-000-47-00-4737 CALEDONIA 0.00 0.00 - 172,000.00 0.0 72-000-47-00-4738 AUTUMN CREEK 0.00 0.00 85,765.00 0.0 72-000-47-00-4739 WYNSTONE TOWNHOMES 0.00 O.QO 8,567.00 0.0 72-000-47-00-4740 VILLAS AT THE PRESERVE 0.00 0.00 90,008.00 0.0 72-000-47-00-4741 BAILEY MEADOWS 0.00 0.00 60,833.00 0.0 72-000-47-00-4742 BLACKBERRY WOODS 0.00 0.00 19,800.00 0.0 72-000-47-00-4743 CORNEILS CROSSING 0.00 0.00 40,590.00 0.0 72-000-47-00-4744 HUDSON LAKES 0.00 0.00 28,449.00 0.0 72-000-47-00-4745 PRESTWICK 0.00 0.00 76,303.00 0.0 72-000-47-00-4746 WESTBURY 0.00 0.00 62,414 .00 0.0 72-000-47-00-4747 WESTHAVEN 0.00 0.00 70,338.00 0.0 72-000-47-00-4748 WILLMAN 0.00 0.00 39,600.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRIBUTIONS 16,631.58 16,631.58 1,882,809.00 0.8 P37 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 38 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: LAND CASH FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL °s ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TRANSFERS 72-000-49-00-4902 TRANSFER FROM LAND ACQUISITION 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 0.00 0.0 TOTAL REVENUES: 16,631.58 16,631.58 1,882,809.00 0.8 EXPENSES CAPITAL OUTLAY 72-000-75-00-7201 RIVERFRONT BUILDING IMPROV. 0.00 0.00 60,000.00 0.0 72-000-75-00-7300 GREENBRIAR 0.00 0.00 0.00 0.0 72-000-75-00-7304 SUNFLOWER 0.00 0.00 0.00 0.0 72-000-75-00-7308 RIVERS EDGE PARK #2 0.00 0.00 0.00 0.0 72-000-75-00-7311 CANNONBALL ESTATES/KYLIN 0.00 0.00 0.00 0.0 72-000-75-00-7317 HEARTLAND CIRCLE 0.00 0.00 4,000.00 0.0 72-000-75-00-7324 TOWN SQUARE 0.00 0.00 4,000.00 0.0 72-000-75-00-7327 GRANDE RESERVE PARK DEV. 0.00 0.00 0.00 0.0 72-000-75-00-7328 PRAIRIE MEADOWS (MENARDS RES) 0.00 0.00 6,000.00 0.0 72-000-75-00-7329 ELSIE LOUISE GILBERT PARK 0.00 0.00 0.00 0.0 72-000-75-00-7330 WHISPERING MEADOWS (K. HILL) 0.00 0.00 724,000.00 0.0 72-000-75-00-7331 WINDETT RIDGE 0.00 0.00 4,000.00 0.0 72-000-75-00-7332 CALEDONIA 0.00 0.00 172,000.00 0.0 72-000-75-00-7333 RAINTREE VILLAGE 0.00 0.00 80,000.00 0.0 72-000-75-00-7334 HOOVER HOLDING COSTS 0.00 0.00 100,000.00 0.0 72-000-75-00-7700 PARK MAINTENANCE FACILITY 0.00 0.00` 500,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 0.00 1,654,000.00 0.0 OTHER 72-000-78-00-9009 RESERVE 0.00 0.00 212,809.00 0.0 -----------------=--------------------------------------------------------------- TOTAL OTHER 0.00 0.00 212,809.00 0.0 TRANSFERS 72-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 0.00 16,000.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 16,000.00 0.0 P38 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 39 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: LAND CASH FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL x ' ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------- TOTAL EXPENSES: 0.00 0.00 1,882,809.00 0.0 TOTAL FUND REVENUES 16,631.58 16,631.58 1,882,809.00 0.8 TOTAL FUND EXPENSES 0.00 0.00 1,882,809.00 0.0 FUND SURPLUS (DEFICIT) 16,631.58 16,631.58 0.00 100.0 P39 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 40 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: LAND ACQUISITION FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 73-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 63, 618.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 63,618.00 0.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,61.8.00 0.0 TRANSFERS 73-000-99-00-9935 TRANSFER TO LAND CASH 0.00 0.00 0.00 010 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 0.00 0.0 TOTAL EXPENSES: 0.00 0.00 63,618.00 0.0 TOTAL FUND REVENUES 0.00 0.00 63,618.00 0.0 TOTAL FUND EXPENSES 0.00 0.00 63,618.00 0.0 FUND SURPLUS (DEFICIT) 0.00 0.00 0.00 0.0 P40 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 41 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 79-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 50,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 50,000.00 0.0 CHARGES FOR SERVICES 79-000-42-00-4270 FEES FOR PROGRAMS 34,574.50 34,574.50 266,000.00 12.9 79-000-42-00-4280 CONCESSIONS/ALL SALE ITEMS 3, 823.25 3,823.25 15,000.00 25.4 79-000-42-00-4281 DEPOSITS 100.00 100.00 1,500.00 6.6 79-000-42-00-4285 VENDING MACHINE INCOME 0.00 0.00 650.00 0.0 79-000-42-00-4286 RENTAL INCOME - 45.00 45.00 0.00 100.0 79-000-42-00-4287 PARK RENTAL INCOME 195.00 195.00 1,000.00 19.5 79-000-42-00-4288 GOLF OUTING REVENUE 39,188.00 39,188.00 38,000.00 103.1 79-000-42-00-4291 HOMETOWN DAYS 300.00 300.00 30,000.00 1.0 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 78,225.75 78,225.75 352,150.00 22.2 MISCELLANEOUS 79-000-44-00-4400 DONATIONS 0.00 0.00 15,000.00 0.0 79-000-44-00-4404 TREE DONATIONS 0. 00 0.00 600.00 0.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 0.00 0.00 15,600.00 0.0 INTERGOVERNMENTAL 79-000-45-00-4550 YOUTH SERVICES GRANT 0.00 0.00 2,000.00 0.0 --------------------------------------------------------------------------------- TOTAL INTERGOVERNMENTAL 0.00 0.00 2,000.00 0.0 INTEREST 79-000-46-00-4600 INVESTMENT INCOME 1,045.21 1,045.21 6,500.00 16.0 --------------------------------------------------------------------------------- TOTAL INTEREST 1,045.21 1,045.21 6,500.00 16.0 TRANSFERS 79-000-49-00-4901 TRANSFER FROM GENERAL FUND 87,177.25 87,177.25 1,046,127.00 8.3 --------------------------------------------------------------------------------- TOTAL TRANSFERS 87, 177.25 87,177.25 1,046,127.00 8.3 P41 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 42 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL %. ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TOTAL REVENUES: 166,448.21 166,448.21 1,472,377.00 11.3 PARKS EXPENSES PERSONNAL SERVICES 79-610-50-00-5107 SALARIES-EMPLOYEES 36,389.32 36,389.32 383,107.00 9.4 79-610-50-00-5136 SALARIES - PART-TIME 5,756.00 5,756.00 48,000.00 11.9 79-610-50-00-5137 SALARIES - OVERTIME 160.98 160.98 8,000.00 2.0 --------------------------------------------------------------------------------- TOTAL PERSONNAL SERVICES 42,306.30 42,306.30 439,107.00 9.6 CONTRACTUAL SERVICES 79-610-62-00-5405 PARK CONTRACTUAL 0.00 0.00 18,000.00 0.0 79-610-62-00-5408 MAINTENANCE-EQUIPMENT 0.00 0.00 10,000.00 0.0 79-610-62-00-5417 MAINTENANCE-PARKS 934.00 934.00 40,000.00 2.3 79-610-62-00-5421 WEARING APPAREL 0.00 0.00 8,000.00 0.0 79-610-62-00-5434 RENTAL-EQUIPMENT 0.00 0.00 1,700.00 0.0 79-610-62-00-5438 CELLULAR TELEPHONE 0.00 0.00 5,750.00 0.0 79-610-62-00-5440 LAND DEVELOPER 0.00 0.00 10,000.00 0.0 79-610-62-00-5445 LEGAL EXPENSES 0.00 0.00 10,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 934.00 934.00 103,450.00 0.9 PROFESSIONAL DEVELOPMENT 79-610-64-00-5602 PROFESSIONAL GROWTH/SUBSCRPT 0.00 0.00 4,800.00 0.0 79-610-64-00-5605 TRAVEL EXPENSE 0.00 0.00 3,800.00 0.0 79-610-64-00-5612 CONTINUING EDUCATION 0.00 0.00 4,200.00 0.0 --------------------=------------------------------------------------------------ TOTAL PROFESSIONAL DEVELOPMENT 0.00 0.00 12,800.00 0.0 OPERATIONS 79-610-65-00-5802 OFFICE SUPPLIES 0.00 0.00 1,500.00 0.0 79-610-65-00-5804 OPERATING SUPPLIES 0.00 0.00 30,000.00 0.0 79-610-65-00-5812 GASOLINE 0.00 0.00 3,500.00 0.0 79-610-65-00-5815 HAND TOOLS 0.00 0.00 3,000.00 0.0 79-610-65-00-5824 CHRISTMAS DECORATIONS 0.00 0.00 7,000.00 0.0 P42 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 43 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL s ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ---------------------------------------------------------------------------------------------=-------------------------------------- PARKS EXPENSES OPERATIONS 79-610-65-00-5825 PUBLIC DECORATION 0.00 0.00 3,000.00 0.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS 0.00 0.00 48,000.00 0.0 RETIREMENT 79-610-72-00-6500 IMRF PARTICIPANTS 2,882.00 2,882 .00 30,897.00 9.3 79-610-72-00-6501 SOCIAL SECURITY/MEDICARE 3,214.92 3,214.92 33,592.00 9.5 ----------------------------------------------------`----------------------------- TOTAL RETIREMENT 6,096.92 6,096.92 64,489.00 9.4 CAPITAL OUTLAY 79-610-75-00-7003 OFFICE EQUIPMENT 0.00 0.00 6,000.00 0.0 79-610-75-00-7701 FLOWERS/TREES 0.00 0.00 7,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 0.00 13,000.00 0.0 OTHER 79-610-78-00-9005 MERIT 0.00 0.00 11,053.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 11,053.00 0.0 TOTAL EXPENSES: PARKS 49,337.22 49,337.22 691,899.00 7.1 RECREATION EXPENSES PERSONNEL SERVICES 79-650-50-00-5107 EMPLOYEE SALARIES 32,372.48 32,372.48 312,226.00 10.3 79-650-50-00-5108 CONCESSION STAFF 536.33 536.33 4,000.00 13.4 79-650-50-00-5109 PRE SCHOOL SALARIES 0.00 0.00 87,000.00 0.0 79-650-50-00-5150 SALARIES-INSTRUCTOR CONTRACTUA 12,367.02 12,367.02 58,400.00 21.1 79-650-50-00-5155 SALARIES-RECORDING SECRETARY 0.00 0.00 3,000.00 0.0 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 45,275.83 45,275.83 464,626.00 9.7 P43 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 44 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL °s ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------- RECREATION CONTRACTUAL SERVICES 79-650-62-00-5408 MAINTENANCE SUPPLIES 150.90 150.90 5,000.00 3.0 79-650-62-00-5409 MAINTENANCE-VEHICLES 0.00 0 .00 1,200.00 0.0 79-650-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 0.00 0.00 6,500.00 0.0 79-650,62-00-5426 YOUTH SERVICES GRANT EXPENSES 0.00 0.00 2,000.00 0.0 79-650-62-00-5437 TELEPHONE/INTERNET 0.00 0.00 1,600.00 0.0 79-650-62-00-5438 CELLULAR TELEPHONE 0.00 0.00 6,500.00 0.0 79-650-62-00-5445 PORTABLE TOILETS 0.00 0.00 5,000.00 0.0 79-650-62-00-5603 PUBLISHING/ADVERTISING 4,884.31 4,884.31 25,700.00 19.0 79-650-62-00-5605 BOOKS/PUBLICATIONS 0.00 0.00 750.00 0.0 79-650-62-00-5606 PARK DEPOSIT REFUND 100.00 100.00 1,500.00 6.6 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 5, 135.21 5,135.21 55,750.00 9.2 PROFESSIONAL DEVELOPMENT 79-650-64-00-5600 DUES 371.60 371.60 2,700.00 13.7 79-650-64-00-5602 PROFESSIONAL GROWTH/SUBSCRIPT 0.00 0.00 0.00 0.0 79-650-64-00-5604 TRAINING AND CONFERENCES 0.00 0.00 7,500.00 0.0 79-650-64-00-5605 TRAVEL EXPENSE 0.00 0.00 2,500.00 0.0 TOTAL PROFESSIONAL DEVELOPMENT 371.60 371.60 12,700.00 2.9 OPERATIONS 79-650-65-00-5802 OFFICE SUPPLIES 176.35 176.35 7,000.00 2.5 79-650-65-00-5803 PROGRAM EXPENSES 3,833.66 3,833.66 50,400.00 7.6 79-650-65-00-5804 OPERATING SUPPLIES 0.00 0.00 4,200.00 0.0 79-650-65-00-5805 RECREATION EQUIPMENT 0.00 0.00 8,000.00 0.0 79-650-65-00-5808 POSTAGE & SHIPPING 795.74 795.74 7,200.00 11.0 79-650-65-00-5812 GASOLINE 308.25 308.25 3,600.00 8.5 79-650-65-00-5826 MILEAGE 41.57 41.57 750.00 5.5 79-650-65-00-5827 GOLF OUTING EXPENSES 20,523.46 20,523.46 20,000.00 102.6 79-650-65-00-5828 CONCESSIONS 12.73 12 .73 91000.00 0.1 79-650-65-00-5833 HOMETOWN DAYS EXPENSES 3,330.26 3,330.26 25,000.00 13.3 79-650-65-00-5840 SCHOLARSHIPS 0.00 0.00 3,600.00 0.0 79-650-65-00-5841 PROGRAM REFUND 317.00 317.00 7,000.00 4.5 TOTAL OPERATIONS 29,339.02 29,339.02 145,750.00 20.1 P44 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 45 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ RECREATION RETIREMENT 79-650-72-00-6500 IMRF PARTICIPANTS 2, 846.61 2,846.61 24,666.00 11.5 79-650-72-00-6501 SOCIAL SECURITY/MEDICARE 3,458.82 3,458.82 35,544.00 9.7 --------------------------------------------------------------------------------- TOTAL RETIREMENT 6,305.43 6,305.43 60,210.00 10.4 CAPITAL OUTLAY 79-650-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 0.00 4,750.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 0.00 4,750.00 0.0 OTHER 79-650-78-00-9005 MERIT 0.00 0.00 9,004.00 0.0 79-650-78-00-9009 RESERVE 0.00 0.00 27,688.00 0.0 - --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 36,692.00 0.0 TOTAL EXPENSES: RECREATION 86,427.09 86,427.09 780,478.00 11.0 TOTAL FUND REVENUES 166,448.21 166,448.21 1,472,377.00 11.3 TOTAL FUND EXPENSES 135,764.31 135,764.31 1,472,377.00 9.2 FUND SURPLUS (DEFICIT) 30, 683.90 30,683.90 0.00 100.0 P45 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 46 TIME: 08:10: 17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: LIBRARY FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL °s ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES TAXES 82-000-40-00-3997 CARRY OVER - BLDG DEV FEES 0.00 0.00 7,263, 881.00 0.0 82-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 231,590.00 0.0 82-000-40-00-4000 REAL ESTATE TAXES 0.00 0.00 464,741.00 0.0 62-000-40-00-4010 PERSONAL PROPERTY TAX 1,357.16 1,357.16 2,500.00 54.2 82-000-40-00-4015 TRANSFER FROM GENERAL FUND 2,937.50 2, 937.50 35,250.00 8.3 --------------------------------------------------------------------------------- TOTAL TAXES 4,294.66 4,294.66 7,997, 962.00 0.0 CHARGES FOR SERVICES 82-000-42-00-4211 DEVELOPMENT FEES - BUILDING 11, 925.00 11,925.00 95,000.00 12.5 82-000-42-00-4215 DEVELOPMENT FEES - BOOKS 11,925.00 11,925.00 95,000.00 12.5 82-000-42-00-4260 COPY FEES 150.50 150.50 900.00 16.7 82-000-42-00-4261 LIBRARY SUBSCRIPTION CARDS 800.00 800.00 8, 000.00 10.0 82-000-42-00-4286 RENTAL INCOME , 103.00 103.00 1,000.00 10.3 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 24,903.50 24,903.50 199,900.00 12.4 FINES 82-000-43-00-4330 LIBRARY FINES 391.10 391.10 3, 000.00 13.0 --------------------------------------------------------------------------------- TOTAL FINES 391.10 391.10 3,000.00 13.0 MISCELLANEOUS 82-000-44-00-4432 SALE OF BOOKS 262.25 262.25 500.00 52.4 82-000-44-00-4450 MEMORIALS 50.00 50.00 5,000.00 1.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 312.25 312.25 5,500.00 5.6 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 INTEREST P46 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 47 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: LIBRARY FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES INTEREST 82-000-46-00-4600 INVESTMENT INCOME 1,960.96 1,960.96 1,500.00 130.7 82-000-46-00-4601 INVESTMENT INCOME-BLDG 19,326.87 19,326.87 100,000.00 19.3 --------------------------------------------------------------------------------- TOTAL INTEREST 21,287.83 21,287.83 101,500.00 20.9 TOTAL REVENUES: 51,189.34 51,189.34 8,316,562.00 0.6 EXPENSES PERSONNEL SERVICES 82-000-50-00-5107 SALARIES-EMPLOYEES 21,851.02 21,851.02 350,000.00 6.2 82-000-50-00-5203 GROUP HEALTH INSURANCE 0.00 0.00 55,000.00 0.0 82-000-50-00-5204 GROUP LIFE INSURANCE 0.00 0.00 2,000.00 0.0 82-000-50-00-5205 DENTAL & VISION ASSISTANCE 0.00 0.00 6,000.00 0.0 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 21,851.02 21,851.02 413,000.00 5.2 PROFESSIONAL SERVICES 82-000-61-00-5322 BONDING 0.00 0.00 2,000.00 0.0 82-000-61-00-5323 ATTORNEY 0.00 0.00 2,000.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 0.00 0.00 4,000.00 0.0 CONTRACTUAL SERVICES 82-000-62-00-5401 CONTRACT SERVICES 0.00 0.00 3,000.00 0.0 82-000-62-00-5407 MAINTENANCE-BLDG/JANITORIAL 0.00 0.00 5,000.00 0.0 82-000-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 0.00 0.00 3,000.00 0.0 82-000-62-00-5412 MAINTENANCE-PHOTOCOPIER 0.00 0.00 1,000.00 0.0 82-000-62-00-5435 ELECTRICITY 0.00 0.00 2,500.00 0.0 82-000-62-00-5436 TELEPHONE 0.00 0.00 1,700.00 0.0 82-000-62-00-5437 GAS HEAT 0.00 0.00 7,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 0.00 0.00 23,200.00 0.0 PROFESSIONAL DEVELOPMENT P47 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 48 TIME: 08:10: 17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: LIBRARY FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES PROFESSIONAL DEVELOPMENT 82-000-64-00-5603 SUBSCRIPTIONS 0.00 0.00 4, 000.00 0.0 82-000-64-00-5604 TRAINING & CONFERENCES 0.00 0.00 1,500.00 0.0 82-000-64-00-5607 PUBLIC RELATIONS 0,00 0.00 1, 000.00 0.0 82-000-64-00-5616 EMPLOYEE RECOGNITION 0.00 0.00 2, 000.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 0.00 0.00 8,500.00 0.0 OPERATIONS 82-000-65-00-5800 CONTINGENCIES 0.00 0.00 22, 031.00 0.0 82-000-65-00-5802 OFFICE SUPPLIES 0.00 0.00 6,000.00 0.0 82-000-65-00-5806 LIBRARY SUPPLIES 0.00 0.00 8, 000.00 0.0 82-000-65-00-5807 CUSTODIAL SUPPLIES 0.00 0.00 10, 000.00 0.0 82-000-65-00-5808 POSTAGE & SHIPPING 0.00 0.00 1,000.00 0.0 82-000-65-00-5810 PUBLISHING & ADVERTISING 0.00 0.00 1,000.00 0.0 82-000-65-00-5826 MILEAGE 0.00 0.00 1,000.00 0.0 82-000-65-00-5832 VIDEOS 0.00 0.00 5,000.00 0.0 82-000-65-00-5833 ALARM MONITORING 0.00 0.00 1,000.00 0.0 82-000-65-00-5834 LIBRARY PROGRAMMING 0.00 0.00 12,000.00 0.0 82-000-65-00-5835 LIBRARY BOARD EXPENSES 0.00 0.00 1,000.00 0.0 82-000-65-00-5836 BOOKS-ADULT 0.00 0.00 10,000.00 0.0 82-000-65-00-5837 BOOKS-JUVENILE 0.00 0.00 10,000.00 0.0 82-000-6.5-00-5838 BOOKS-AUDIO 0.00 0.00 10,000.00 0.0 82-000-65-00-5839 BOOKS-REFERENCE 0.00 0.00 10,000.00 0.0 82-000-65-00-5840 BOOKS-DEVELOPMENT FEE 0.00 0.00 95,000.00 0.0 82-000-65-00-5841 MEMORIALS/GIFTS 0.00 0.00 5, 000.00 0.0 82-000-65-00-5842 BLDG-DEVELOPMENT FEES 0.00 0.00 95,000.00 0.0 82-000-65-00-5843 GRANT EXPENSE 0.00 0.00 1,000.00 0.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS 0.00 0.00 304,031.00 0.0 RETIREMENT 82-000-72-00-6500 IMRF PARTICPANTS 949.87 949.87 9,000.00 10.5 82-000-72-00-6501 SOCIAL SECURITY/MEDICARE 1,671.60 1,671.60 26,250.00 6.3 --------------------------------------------------------------------------------- TOTAL RETIREMENT 2,621.47 2,621.47 35,250.00 7.4 P48 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 49 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: LIBRARY FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL % ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ CAPITAL OUTLAY 82-000-75-00-7003 AUTOMATION 0.00 0.00 164,700.00 0.0 82-000-75-00-7703 BUILDING EXPANSION 0.00 0.00 7,363,881.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 0 .00 7,528,581.00 0.0 TOTAL EXPENSES: 24,472.49 24,472 .49 8,316,562.00 0.2 TOTAL FUND REVENUES 51, 189.34 51,189.34 8,316,562.00 0.6 TOTAL FUND EXPENSES 24,472.49 24,472 .49 8,316,562.00 0.2 FUND SURPLUS (DEFICIT) 26,716.85 26,716.85 0.00 100.0 P49 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 50 TIME: 08:10:17 DETAILED REVENUE .& EXPENSE REPORT F-YR: 07 ID: GL4700O2.WOW FUND: FOX INDUSTRIAL FOR - 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL °s ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES TAXES 85-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 30,000.00 0.0 85-000-40-00-4090 TIF REVENUES 0.00 0.00 75,000.00 0.0 --------------------------------------------------------------------------------- TOTAL TAXES 0.00 0.00 105,000.00 0.0 INTEREST 85-000-46-00-4600 INVESTMENT INCOME 408.88 408.88 3,000.00 13.6 --------------------------------------------------------------------------------- TOTAL INTEREST 408.88 408.88 3,000.00 13.6 TRANSFERS 85-000-49-00-4905 TRANSFER FROM MFT FUND 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 0.00 0.0 TOTAL REVENUES: 408.88 408.88 108,000.00 0.3 EXPENSES DEBT SERVICES 85-000-66-00-6021 FOX.IND BOND-PRINCIPAL PMT 0.00 0.00 60,000.00 0.0 85-000-66-00-6022 FOX IND BOND-INT PAYMENT 10,207.50 10,207.50 20,415.00 50.0 --------------------------------------------------------------------------------- TOTAL DEBT SERVICES 10,207.50 10,207.50 80,415.00 12.6 CAPITAL OUTLAY 85-000-75-00-7901 FOX INDUSTRIAL - NON MFT 0.00 0.00 0.00 0.0 85-000-75-00-7902 FOX INDUSTRIAL EXPENSES 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 0.00 0.00 0.0 OTHER 85-000-78-00-9007 ADMINSITRATION FEES 0.00 0.00 300.00 0.0 85-000-78-00-9010 RESERVE-FUTURE BOND PYMTS 0.00 0.00 27,285.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 27,585.00 0.0 P50 DATE: 06/29/2006 UNITED CITY OF YORKVILLE PAGE: 51 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: FOX INDUSTRIAL FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TOTAL EXPENSES: 10,207.50 10,207.50 108,000.00 9.4 TOTAL FUND REVENUES 408.88 408.88 108,000.00 0.3 TOTAL FUND EXPENSES 10,207.50 10,207.50 108,000.00 9.4 FUND SURPLUS (DEFICIT) (9,798.62) (9,798.62) 0.00 100.0 P51 DATE: 06/29/2006 UNITED CITY, OF YORKVILLE PAGE: 52 TIME: 08:10:17 DETAILED REVENUE & EXPENSE REPORT F-YR: 07 ID: GL470002.WOW FUND: COUNTRYSIDE TIF PROJECT FOR 1 PERIODS ENDING MAY 31, 2006 FISCAL FISCAL ACCOUNT MAY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 87-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 3,000,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 3,000,000.00 0.0 INTEREST 87-000-46-00-4600 INVESTMENT INCOME 9,342.28 9,342.28 75,000.00 12.4 ------------------------------------------------------------------------------- TOTAL INTEREST 9,342.28 9,342.28 75,000.00 12.4 TOTAL REVENUES: 9,342.28 9,342 .28 3,075,000.00 0.3 EXPENSES OTHER FINANCING 87-000-66-00-6002 COUNTRYSIDE TIF-INTEREST PMT 0.00 0.00 0.00 0.0 87-000-66-00-6022 BOND - INT PAYMENT 71,433.75 71,433.75 142,868.00 49.9 --------------------------------------------------------------------------------- TOTAL OTHER FINANCING 71,433.75 71,433.75 142,868.00 49.9 OTHER 87-000-78-00-9007 ADMINISTRATION FEES 0.00 0.00 2,500.00 0.0 87-000-78-00-9009 RESERVE 0.00 0.00 0.00 0.0 87-000-78-00-9010 RESERVE - FUTURE BOND PAYMENT 0.00 0.00 2,929,632.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 2,932,132.00 0.0 TOTAL EXPENSES: 71,433.75 71,433.75 3,075,000.00 2.3 TOTAL FUND REVENUES 9,342.28 9,342.28 3,075,000.00 0.3 TOTAL FUND EXPENSES 71,433.75 71,433.75 3,075,000.00 2.3 FUND SURPLUS (DEFICIT) (62,091.47) (62,091.47) 0.00 100.0 P52 ♦,�Efl Cary Reviewed By: N 6./ J= 0 Legal E] City Council Finance ❑ EST. iris Engineer ❑ C y City Administrator El Item Tracking Number Consultant ❑ /17®M F� - LE City Council Agenda Item Summary Memo Title: Monthly Treasurer's Report—May 2006 City Council/COW/Committee Agenda Date: Administration 7/06/06 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Jennifer Milewski Finance Name Department Agenda Item Notes: United City of Yorkville Monthly Treasurer's Report Pre Audit Financial Summary As of May 31, 2006 Beginning Ending Fund Balance Revenues Expenses Transfers Balance 1 General $5,329,510.55 1,748,311.93 598,386.29 (361,406.40) 6,118,029.79 15 Motor Fuel Tax 463,304.78 22,005.08 - - 485,309.86 16 Municipal Building (208,136.24) 41,950.00 265.00 - (166,451.24) 20 PD Capital 173,660.99 25,707.85 - 199,368.84 21 PW Capital 589,047.15 43,350.00 - - 632,397.15 22 Parks&Rec Equip Capital 73,954.67 2,200.00 - - 76,154.67 37 Sanitary Sewer Improvement 4,688,003.83 195,366.11 - - 4,883,369.94 41 Water Improvement Exp 233,705.57 213,670.98 - - 447,376.55 42 Debt Service (11,340.96) 22,577.32 116,575.00 - (105,338.64) 51 Water 893,280.06 164,259.57 42,295.63 - 1,015,244.00 52 Sewer 802,877.10 82,630.26 15,378.03 - 870,129.33 72 Land Cash (85,525.35) 16,631.58 - - (68,893.77) 73 Land Acquisition 213,617.69 - 213,617.69 79 Parks&Recreation 61,575.87 79,270.96 135,764.31 87,177.25 92,259.77 82 Library 5,757,047.18 48,251.84 24,472.49 2,937.50 5,783,764.03 85 Fox Industrial 32,799.08 408.88 10,207.50 - 23,000.46 87 Countryside TIF Project 3,463,672.04 9,342.28 71,433.75 - 3,401,580.57 95 Trust&Agency 554,545.39 158,816.99 - - 713,362.38 Totals 23,025,599.40 2,874,751.63 1,014,778.00 (271,291.65) 24,614,281.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 Fund Balance Reserve General Fundl 47.38%1 Water Ops 1 52.82%1 Sewer Maint. 1 78.53% Combined Fund Balance Reserve 50.20% Prepared by: Jennifer Milewski-Sr.Accounting Clerk UNITED CITY OF YORKVILLE FUND BALANCE CALCULATIONS GENERAL FUND EXPENSES PER BUDGET $16,583,575 LESS EXPENSES DEDICATED TO ROAD PROJECTS ENGINEERING- IN TOWN ROAD PROGRAM (261,802) IN-TOWN ROAD PROGRAM (Phase 1 Utilities) (1,588,198) BRISTOL RIDGE ROAD (1,600,000) TRANSFER TO WATER IMPROVEMENT (220,000) NET GENERAL FUND OPERATING EXPENSES $12,913,575 FUND BALANCE CALCULATION PER POLICY @15% $1,937,036 @25% $3,228,394 5/31/06 GENERAL FUND BALANCE PER TREASURERS REPORT $6,118,030 LESS DOLLARS RECEIVED&DEDICATED TO ROAD PROJECTS $0 5/31/06 NET FUND BALANCE $6,118,030 5/31/06 GENERAL FUND BALANCE PERCENT 47.38% WATER OPERATIONS EXPENSES PER BUDGET $1,922,000 FUND BALANCE CALCULATION PER POLICY @15% $288,300 @25% $480,500 5/31/06 WATER OPERATIONS FUND BALANCE PER TREASURERS REPORT $1,015,244 5/31/06 WATER OPERATIONS FUND BALANCE PERCENT 52.82% SEWER MAINTENANCE EXPENSES PER BUDGET $1,108,000 FUND BALANCE CALCULATION PER POLICY @15% $166,200 @25% $277,000 5/31/06 SEWER MAINTENANCE FUND BALANCE PER TREASURERS REPORT $870,129 5/31/06 SEWER MAINTENANCE FUND BALANCE PERCENT 78.53% COMBINED FUND BALANCE RESERVE UNITED CITY OF YORKVILLE FUND BALANCE CALCULATIONS NET GENERAL FUND OPERATING EXPENSES $12,913,575 WATER OPERATIONS EXPENSES PER BUDGET $1,922,000 SEWER MAINTENANCE EXPENSES PER BUDGET $1,108,000 TOTAL FISCAL YEAR EXPENSES $15,943,575 YTD NET GENERAL FUND BALANCE $6,118,030 YTD WATER OPERATIONS FUND BALANCE PER TREASURER'S REPORT $1,015,244 YTD SEWER MAINTENANCE FUND BALANCE PER TREASURER'S REPORT $870,129 TOTAL YTD NET FUND BALANCES $8,003,403 05/31/06 COMBINED FUND BALANCE RESERVE 50.2% `,��0 C/�•y Reviewed By: J2 �� Legal ❑ City Council Finance ❑ xx Engineer ❑ City Administrator ❑ Agenda Item Tracking Number 20' Consultant ❑ AW 3006- `1 LE City Council Agenda Item Summary Memo Title: Proposal for Community Relations Intern City Council/COW/Committee Agenda Date: Admin 7/6/06 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Glory Spies Community Relations Name Department Agenda Item Notes: =`QEDIT o United City of Yorkville Memo 800 Game Farm Road Esr. sm Yorkville, Illinois 60560 Telephone: 630-553-4350 �9 �p Fax: 630-553-7575 LE TO: Mayor Art Prochaska, Elected Officials, Administration Committee FR: Glory Spies, Community Relations Manager RE: Proposal for Intern DATE: 7/06/06 REQUEST: A Community Relations Intern from a local university's Intern Program (which may include Waubonsee Community College, Aurora University, Joliet Junior College,Northern Illinois University,North Central etc.) Due to the number of projects that I would like to institute within the next six months I am requesting additional help through either NIU or Waubonsee Community College. The length of employment will depend on the parameters of the Intern Program. NUMBER OF REQUESTED HOURS: 10-15 hours per week RANGE OF SALARY: $10 PROPOSED PROJECTS: -United City of Yorkville promotional DVD -Four-page demographic profile -United City of Yorkville new resident/promotional folders -Employee newsletter -Four-color calendar of events held throughout the City to include in new resident folders and to distribute to the Yorkville Area Chamber of Commerce, Economic Development Corporation and to city businesses. -Development of new resident meetings/tour of City Hall FUNCTIONS OF POSITION: • Assist with the development of United City of Yorkville promotional DVD. • Assist with the development of feature articles. • Develop and write press releases to include on city's new Web site on a daily basis. • Assist with the implementation and development of new employee newsletter(first one due out in August). Employee newsletter is a collaborative effort between the Community Relations manager and Denise Kasper, Payroll Benefits Specialist. • Work with Community Relations Manager and the cities of Plainfield and Oswego to market Yorkville, Plainfield and Oswego to publications such as West Suburban Living, Midwest Living and Illinois Tourism Bureau.Newly formed PR Municipality group is working towards regional media coverage. • Work with various community organizations to develop a referral list to include on the Web site. (A comprehensive list of senior and community services available throughout Yorkville and surrounding communities to inform residents of available services). List will also serve as a checklist for individuals who call city asking where and how to contact such services. • Continuous update of FVTV community calendar. • Continuous update of new resident information. • Work with Community Relations manager and Human Resource Commission on developing and instituting ideas to recognize individuals/families for Historical Street Naming program. • Continuous update of new resident letters. • Work with Community Relations manager on the publicity of the Hometown Days Festival. Also work to form a committee to formulate ideas for a second community event/festival. • Write and develop articles for city newsletter featuring city employees. • Other responsibilities as assigned. REQUIREMENTS: Attend Public Access Television Production Training through Waubonsee Community College -Editing, writing and proofreading skills. -Ability to communicate clearly and concisely in both oral and written format. -Ability to understand and follow general instructions. -Ability to organize workload and handle multiple projects. -Working knowledge of various computer software programs including QuarkXPress, Photoshop or In-Design. Working knowledge of Microsoft Word essential. TERMS: Student at Northern Illinois University, Waubonsee Community College, Joliet Community College or Aurora University majoring in Journalism, Public Relations, Advertising or Organizational Communications. Length of term—Fall semester, September through December. Internship may be extended for Spring semester, January through May. Work hours can be flexible depending on student's class schedule. Reviewed By: Legal ❑ City Council Finance ❑ Engineer ❑ H City Administrator ❑ Agenda Item Tracking Number `r0 Consultant ❑ A r)it�t r3 CD- q LE ��'v Human Resources ❑ City Council Agenda Item Summary Memo Title: Staffing Needs Analysis Methodology City Council/COW/Committee Agenda Date: Admin.—July 6, 2006 Synopsis: The staffing needs analysis was discussed as a way to see each department's vision for the future in regards to needed employees. Also, John Crois has supplied a memo for discussion of some related organizational planning projects. Council Action Previously Taken: Date of Action: N/A Action Taken: N/A Item Number: N/A Type of Vote Required: N/A Council Action Requested: Discussion Submitted by: Bart Olson Administration Name Department Agenda Item Notes: The staffing needs analysis methodology memo is an outline of the plan of action for drafting a staffing needs report. The memo is intended to facilitate discussion. Document 2—Memo from John Crois for discussion of related organizational planning projects. United City of Yorkville Memo 800 Game Farm Road EIM us Yorkville, Illinois 60560 Telephone: 630-553-4350 ,p �p Fax: 630-553-7575 LE Date: May 16, 2006 To: Administration Committee From: Bart Olson, Assistant City Administrator John Crois, City Administrator Lynsey Johnson, Administrative Assistant CC: Subject: Staffing Needs Analysis To complete the staffing needs analysis, staff is recommending a three step approach to develop a plan: STEP 1: Identify the years to study staffing needs: eeds: a. FY 2007/08 b. FY 2008/09 c. FY 2009/10 d. 5 year forecast—FY 2011/12 e. 10 year forecast—FY 2017/18 f. Max build out forecast For each fiscal year,basic assumptions will be made on population, demographics, and community characteristics. Using this information, staff will identify a group of communities with similar population, demographics, and community characteristics. For each community, staff will attempt to obtain organizational charts. STEP 2: Identify the requested hires for the next three fiscal years: a. FY 2007/08 b. FY 2008/09 c. FY 2009/10 Staff will complete step 2 by: 1) asking department heads to complete a three year projected staffing request 2) discussing the merits of each request based on anticipated need 3) comparing the total requests to conceptual budget numbers 4) preparing a report and organizational chart for each fiscal year 5) providing information on each new position a. basic description of functions b. commonality in other municipalities c. estimated salary range(current$) d. basic description of functions e. possible alternative positions f. who the position supervises g. who the position is supervised by h. sample executive summaries from other municipalities'job descriptions 6) For each year, the organizational charts of comparable municipalities will be compared against the proposed organizational chart and new hires for Yorkville. Points of interest regarding similarities, differences, and organizational best practices will be highlighted. STEP 3: Identify conceptual hires for 5 years, 10 years, and max build out a. FY 2011/12 b. FY 2017/18 c. Max build out Staff will complete step 3 by: 1) asking department heads to complete conceptual staffing plans for each timeframe 2) discussing the merits of each department's request based on anticipated need 3) comparing the total request to conceptual budget numbers 4) preparing a report and organizational chart for each timeframe 5) providing information for new positions a. basic description of functions b. commonality in other municipalities c. estimated salary range(current $) d. basic description of functions e. possible alternative positions f. who the position supervises g. who the position is supervised by h. sample executive summaries from other municipalities'job descriptions 6) For each year, the organizational charts of comparable municipalities will be compared against the organizational chart and new hires for Yorkville. Points of interest regarding similarities, differences, and organizational best practices will be highlighted. -n United City of Yorkville County Seat of Kendall County EST. 800 Game Farm Road f N Yorkville,Illinois 60560 O `� O Phone:630-553-4350 w �2 Fax:630-553-7575 V <LE Date: July 3,2006 To: The Administration Committee From: John H. Crois,Interim City Administrator Subject: Planning The Council has discussed several topics recently which I believe are tied to planning. The Council has requested a plan for future hiring, and has discussed performance measurements at the Administrative Task Force meeting. The United City of Yorkville needs to plan for its future. To develop a plan,the City needs a vision and a comprehensive program. I believe that we can all agree that the United City of Yorkville is striving to provide high quality services to our residents in the most efficient manner. To accomplish this the City needs to maintain a high performance organization. A high performance begins at the top. The City needs to develop a vision statement. You may wish to have Northern Illinois University assist in this project. In developing the vision statement,input should be from both the Council and residents. Once the vision statement is in place,then goals can be established which related directly to the vision statement. Department goals are then developed which relate directly to the community vision and which achieve the established goals of the community. The second element of the high performance organization is the people component. A hiring plan and performance measurement are part of a larger program. A hiring plan is not meaningful without corresponding revenue and expense projections. To develop a high performance organization,the City has to plan and implement an organizational structure which is capable of accomplishing the vision and goals of the City. For this to happen,the City has to have a program to recruit, train and retain high potential employees. The hiring plan and financial projections are part of this program,but other elements are also required. The program requires some elements of succession planning. The City needs to develop talent pools which prepare employees to move up and assume supervisory positions. This requires developing programs to evaluate employee potential and to set training programs to prepare employees to meet the future needs of the City. Performance measurement is an important element of the program. Feedback is needed to determine whether or not the programs and the departments are meeting the goals of the City. The Northwest Municipal Conference has a performance measurement system which I would recommend the City investigate. The computer program costs$100 per module. The modules are a required financial module and three elective modules(police, public works, and community development). The minimum benefit would be a listing of the type of performance data being collected and what measures to investigate. The additional benefit would be communities to compare to depending on who is included in the data base. For the cost involved, I believe this program would benefit the City. It is important to remember that performance measurement would be used for developmental purposes and not tied to compensation. The literature is clear that for performance measurement to succeed,the participant must trust the validity and equity of the measures. Without this trust the program will fail. In developing a high performance organization,there is a need to address job design. To have the employee perform at their highest potential,there must be in place methods to motivate and reward the employee. Teamwork and open communications need to be addressed. Also there is no need to reinvent the wheel. Best practices have been established for many City functions. These case studies need to be reviewed and adapted to Yorkville where appropriate. The United City of Yorkville has the opportunity to chart its future. This will take vision and planning. I am sure that as a parent your goal is to provide a better world for your children and grandchildren. As the parents of the United City of Yorkville, you have the opportunity to establish for future generations, a City that is an innovator and leader in the state and nation. This process should begin as soon as possible. N e) CO. Reviewed By: Legal ❑ City Council Finance N Engineer ❑ City Administrator Agenda Item Tracking Number 20 Consultant ❑ A DM a LE Human Human Resources ❑ City Council Agenda Item Summary Memo Title: IT Assistant Position and Job Description Discussion City Council/COW/Committee Agenda Date: Admin-July 6, 2006 Synopsis: We are bringing this proposal forward to request a full time Information Technology Specialist due to the resignation of our current Information Technology Assistant. This position was part time and we would like to request it to be full time. We do have an additional part time position approved and budgeted for this fiscal year,however we are willing to forfeit that position. Justification can be found in the attached documentation. Council Action Previously Taken: Date of Action: N/A Action Taken: N/A Item Number: N/A Type of Vote Required: N/A Council Action Requested: Discussion Submitted by: Susan Mika Finance Name Department Agenda Item Notes: Document 1 —New Personnel Request Form, contains justifications for the update and request for full-time status Document 2—Proposed updated job description,track changes copy Document 3-Proposed updated job description, clean copy UNITED CITY OF YORKVILLE FISCAL YEAR 2006-07 NEW PERSONNEL REQUEST FORM Request Tracking Number: NPR 2006-100 Department: Finance Proposed Title: Information Technology Specialist Proposed Supervisor: Finance Director Proposed Employees to be Supervised: None Salary Classification: Information Technology Specialist; $45,000-$60,000 Salary and Wages Other Expenses Salary 50,000.00 Training Overtime - Communications Equip. 50.00 Total Salary and Wages 50,000.00 Office Machine & Equip. Tools&Other Equip. Benefits Uniforms Medical Insurance 16,263.48 Furnishings Dental Insurance 1,275.00 Vehicle Vision Insurance 169.92 Recruitment Life Insurance 248.04 Other FICA 3,100.00 Other Medicare 725.00 Total Other Expenses 50.00 IMRF Contribution 3,950.00 Worker's Comp 975.00 Total Cost of New Position 76,92874 Unemployment 172.00 Total Benefits 26,878.44 What are the g)rimary duties of this position new positions only)? FTheduties would be s imilar to what was recently being done, however new projects that are high ing requested by staff and go beyond the day to day operations. As we continue to row,the job requests have become complex. Currently,are the duties being performed,and by whom? FTheywereerformed by our part-time Information Technology Assistant who has recently resigne from the City. Why is the position needed? F e City's Information Technology needs. The City has roughly 85 computers, 2 new ing to be designed and implemented, and multiple projects that are being requested b City Council and staff(i.e. electronic access to information for Council, document t system, etc.) With 15 full-time hires this year and the rate of growth in the City, a full will be needed sooner rather than later. It is more efficient and more cost effective to essary IT infrastructure in place prior to major staff expansion. Also, hiring a full-time person now will allow staff to catch up on the back log of projects. Provide any statistics,analysis or other factors used in determ ning the need for this position. Fhavinga ot have an internal IT person,then we would need to outsource for these tasks to be . The average hourly rate is$125 an hour. I believe it would be cost effective to have al person to handle our needs. Currently this position is part time and I would like to position to full time status. I have an additional part time position in my budget to hire m willing to forfeit. I believe the City's needs would be met in a more efficient manner ll time staff member rather than two part time positions to h elp keep the City connected and uniform. How will this position improve efficiency and how will it impact customer service/service delivery? Ferrors e City has several projects in relation to Information Technology. These projects keep ushed back or added to resulting in multiple open projects at once with little or no de to completion. Our recent IT person kept getting interrupted with daily requests for various problems that needed to be addressed immediately. These tasks were not completed in a timely manner due to time constraints. What other benefits are associated with approving this position? FTheCity now have access to an IT staff member during normal business hours as well a 24/7 back up in case a problem should arise during non business hours. What are the consequences, if any, of not approving this position? Delay in implementation of our domain server, e-mail server as well as individual division servers. Delay in implementing replacement equipment, software licenses, inventory, etc... Requests would take longer to fulfill and in an extreme circumstance(if our server went down)we would have to outsource a company to come in and fix our problem. Can this position or type of work be outsourced? If so,what are the costs? EThison can be outsourced. However, the average hourly rate is generally$125 an hour. ,r�tt9 c'ry+ UNITED CITY OF YORKVILLE 1e INFORMATION TECHNOLOGY SPECIALIST—JOB DESCRIPTION Deleted: AssisTANT Department: Finance Reports to: Finance Director Status: Full-Time,non-exempt Supervises: None Salary Classification: IT Suecialist Position Description Overview Performs technical and skilled tasks in maintaining g_he_Citv's personal computer inventory,local area networks.and wide area networks. Installs,maintains,repairs and updates hardware and software. Performs administrative functions,coordinates,builds,and troubleshoots Windows, Novell servers,print servers,and WAN-LAN communications. Provides and coordinates training for City employees on the capabilities and operation of various software and hardware systems. This position may require flexible hours,including weekends and nights for computer and system gRgrades and/or repairs. Essential Job Functions 1. Responsible for continual updates to the city•e-mail-system,phone system,and user accounts, ,, Deleted: website, which includes the development,concept,focus,schedule,feature set,coordination, documentation,maintenance,and quality of such Deleted: IT Assistant is NOT involved - in the physical aspects of creating the website,but rather the producing of it 2. Troubleshoot.diagnose,and resolve errors and common problems on city hardware and (i.e.coordinating with city departments software systems,personal computer hardware.software,and printer systems,and local and to help maintain department webpages). remote communication connections. 3. Provides help-desk services for city employees, ,,- Deleted:Handles routine hardware and software support to City end-users. •-- - . - ----- - -- -- -- - - -- -- -- - -- 4. Maintains necessary records and inventory of all equipment,software and maintenance Deleted:¶ 3.Troubleshoot,diagnose,and resolve activities. errors on City hardware and software systems,personal computer hardware, software,and printer systems,and local 5. Coordinate and build all servers and personal computers for the City. and remote communication connections.q 6. Establish and recommend policies on system use and services, Deleted:Assist in maintaining database of equipment inventory. 7. Makes recommendations and assists with the purchase of computer software and equipment, ,,- Deleted:Assist in coordinating all computer related purchases. I 8. Performs regular network backups and general system maintenance,coordinating with t Deleted:6. Troubleshoot City data and hone outside vendors as needed. telephone systems.¶ I 7, 9. Conducts and coordinates small group and one-on-one training as necessary to provide users Formatted:Bullets and Numbering with the ability to utilize certain applications effectively. Deleted:¶ I . 9. Conduct research for,and update,the - City long term Tech Plan.¶ 10.Adhere to all departmental and City safety policies. •--- Formatted:Bullets and Numbering Requirements 1. Thorough knowledge of the principles of computer systems,procedures,analysis,design and simple programming. 2. Thorough knowledge of installation,functions,and use of common packaged software including spreadsheets,word processing,database,and desktop publishing,and others. 3. Thorough knowledge of installation and maintenance of PCs,printers,adapter cards, modems,and other PC related equipment. 4. Effective written and oral communication skills,including the ability to read,interpret,and explain complex concepts and requirements clearly and concisely. 5. Strong interpersonal communication skills for interaction with elected and appointed officials,coworkers,agencies and other governmental units,and the public. 6. Ability to maintain strict confidentiality. 7. Ability to perform physical requirements of the job including moderate lifting and carrying up to 551bs.,climbing,crawling, stooping,etc. 8. Ability to adapt to changing priorities and to work under pressure when circumstances dictate. 9. Ability to learn and stay current with new IT technologies. 10.Possession of a valid driver's license. 11.Must have successfully completed a background investigation. Experience and Education 1. Bachelor's degree in Computer Science or related field: five(5)years of IS experience in end-user support with an emphasis in microcomputers and network systems;or,an equivalent combination of education and experience sufficient to perform the essential duties of the job as those listed above. Deleted:Minimum five(5)years is experience in end-user support with an - - _ -.-- --_ _ _- --- emphasis in microcomputer and network 2. Current working knowledge of the operating system MSCE 2000,with certification in such systems.¶ preferred. Deleted:I - - 3 Graduation from an accredited college --- or university with a BS or program of The duties listed above are intended only as illustrations of the various types of work that may be study in Computer science or closely performed. The omission of specific statements of duties does not exclude them from the position if related field.¶ the work is similar,related or a logical assignment to the position. The job description does not a. Any equivalent combination of constitute an employment agreement between the employer and requirements of the job change. experience and education that provides the required knowledge,skills,and abilities.¶ 141,1174 -V) UNITED CTFY OF YORKVII U LE INFORMATION TECHNOLOGY SPECIALIST—JOB DESCRIPTION Department: Finance Reports to: Finance Director Status: Full-Time,non-exempt Supervises: None Salary Classification: IT Specialist Position Description Overview Performs technical and skilled tasks in maintaining the City's personal computer inventory, local area networks, and wide area networks. Installs,maintains,repairs and updates hardware and software. Performs administrative functions, coordinates,builds, and troubleshoots Windows, Novell servers,print servers, and WAN-LAN communications. Provides and coordinates training for City employees on the capabilities and operation of various software and hardware systems. This position may require flexible hours, including weekends and nights for computer and system upgrades and/or repairs. Essential Job Functions 1. Responsible for continual updates to the city e-mail system,phone system, and user accounts, which includes the development, concept, focus, schedule, feature set, coordination, documentation,maintenance, and quality of such. 2. Troubleshoot, diagnose, and resolve errors and common problems on city hardware and software systems,personal computer hardware, software, and printer systems, and local and remote communication connections. 3. Provides help-desk services for city employees. 4. Maintains necessary records and inventory of all equipment, software and maintenance activities. 5. Coordinate and build all servers and personal computers for the City. 6. Establish and recommend policies on system use and services. 7. Makes recommendations and assists with the purchase of computer software and equipment. 8. Performs regular network backups and general system maintenance, coordinating'with outside vendors as needed. 9. Conducts and coordinates small group and one-on-one training as necessary to provide users with the ability to utilize certain applications effectively. 10. Adhere to all departmental and City safety policies. Requirements 1. Thorough knowledge of the principles of computer systems,procedures, analysis, design and simple programming. 2. Thorough knowledge of installation, functions, and use of common packaged software including spreadsheets, word processing, database, and desktop publishing, and others. 3. Thorough knowledge of installation and maintenance of PCs,printers, adapter cards, modems, and other PC related equipment. 4. Effective written and oral communication skills, including the ability to read, interpret, and explain complex concepts and requirements clearly and concisely. 5. Strong interpersonal communication skills for interaction with elected and appointed officials, coworkers, agencies and other governmental units, and the public. 6. Ability to maintain strict confidentiality. 7. Ability to perform physical requirements of the job including moderate lifting and carrying up to 55 lbs., climbing, crawling, stooping, etc. 8. Ability to adapt to changing priorities and to work under pressure when circumstances dictate. 9. Ability to learn and stay current with new IT technologies. 10. Possession of a valid driver's license. 11. Must have successfully completed a background investigation. Experience and Education 1. Bachelor's degree in Computer Science or related field; five(5) years of IS experience in end-user support with an emphasis in microcomputers and network systems; or, an equivalent combination of education and experience sufficient to perform the essential duties of the job as those listed above. 2. Current working knowledge of the operating system MSCE 2000,with certification in such preferred. The duties listed above are intended only as illustrations of the various types of work that may be performed. 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. The job description does not constitute an employment agreement between the employer and requirements of the job change.