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.