The URL can be used to link to this page

Administration Packet 2006 03-02-06 'A United City of Yorkville 800 Game Farm Road EST. 18 Yorkville, Illinois 60560 o Telephone: 630-553-4350 Kmdi Fax: 630-553-7575 <LE AGENDA ADMINISTRATION COMMITTEE MEETING Thursday,March 2,2006 6:30 P.M. CITY CONFERENCE ROOM Presentation: None Old Business: 1. Minutes for Approval/Correction: January 5, 2006 and February 2, 2006 2. ADM 2006-11 Health Insurance/Benefit Renewal Information 3. ADM 2006-12 Minute Taking Policy 4. ADM 2006-13 Hiring Policy New Business: 1. Monthly Budget Report for January 2006 2. ADM 2006-21 Monthly Treasurer's Report for January 2006 3. ADM 2006-22 Resolution Appointing INW Authorized Agent 4. PS 2006-05 Maintenance Proposal for Fire Alarm System at City Hall /Police Station 5. PW 2006-39 Project Manager—Proposed Position and Draft Job Description 6. ADM 2006-23 Attorney Hours Spreadsheet and Draft Job Description 7. ADM 2006-24 Salary Increases for the Next Fiscal Year (Cola/Merit) 8. ADM 2006-25 Amendments to City Code Regarding Appointments and Offices Additional Business: Ic Page 1 of 3 ADMINISTRATION MEETING DRACOMMITTEE FT Thursday,January 5,2006 6:30 P.M. City Conference Room Present Alderman Paul James, Chairman Finance Director Tracy Pleckham Alderwoman Rose Spears Denise Kasper Alderwoman Wanda Ohare Bart Olson Alderwoman Valerie Burd City Treasurer Bill Powell City Administrator John Crois Presentations: -None. Old Business: 1. Minutes for Approval/Correction: -December 1, 2005—The minutes were approved. 2. ADM 2005-12 Tuition Policy—In the additions to the existing Employee Manual, Section 8.6b(proposed),the first sentence where it says college degree or certificate was changed to say a college degree program or certificate program, and there was discussion about adding a list of eligible certificates. There was discussion about schooling for Maintenance Workers, and they may want to go for Certifications. The eligible degree level list should include certificates for Parks,Recreation, Streets, Sewer,or Water department employees, and any other departments it would apply. The staff that needs to be included in this list would be the Police Department Office Staff and the Community Relations Director. There was concern that the schooling requirements for the new job descriptions were not reflected in this list. These will be checked and the list will be updated if necessary. A footer should be added to tell the draft date and updated dates on the bottom of documents. This will move on to COW. New Business: 1. Monthly Budget Report for November 2005—The year is 58.3% of the way through, and the General Fund revenue is at 49.76%, and the expenditures are at 35.92%. There are a lot of contractual expenses which may mean more personnel . is needed. There was a question about why some of the expenditure percents were so high for certain items. Those items were one or two time collections or payouts, and they are finished for the year. The revised budget requests will be at February's Administration Committee meeting. This does not move forward at this time. Page 2 of 3 2. ADM 2006-01 Monthly Treasurer's Report for November 2005—The Sewer Maintenance Fund Balance is high because they have a smaller fund balance, and when the percent is taken, it is higher. This is for maintenance items they have not yet expended this year. There will be a new expanded Treasurer's Report format hopefully for next month. This will go on to COW on Consent Agenda. 3. ADM 2006-02 Quarterly Department Vehicle Reports—The new format was not coordinated yet. These reports should be done monthly, but reviewed quarterly. This does not need to go on to COW. 4. ADM 2006-06 Fox Industrial Park Abatement Ordinance—Items 4—7 are similar. These were city issued bonds that the city will not need to collect the dollars from the taxpayers for. They are altenate revenue bonds with an alternate revenue source. Taxes can be levied if the alternate revenue is not available The Tax Levy is attached as a third funding mechanism for the protection of the Bond holder. The county is required to levy the tax unless the City tells them to abate it. This is something that must be done annually. The abatement ordinance must be sent to the County by the last Tuesday in February. Glory Spies will be asked to send out a press release for these abatements. This will move on to COW on Consent Agenda. 5. ADM 2006-07 Countryside Interceptor Abatement Ordinance—This will move on to COW on Consent Agenda. 6. ADM 2006-08 Countryside Center TIF Abatement Ordinance—This will move on to COW on Consent Agenda. 7. ADM 2006-09 In-Town Road Program Abatement Ordinance—This will move on to COW on Consent Agenda. Additional Business: FY 2006/2007 Budget Requests—There should be a separate line item for the Rt. 47 improvements. This will go on the agenda next month. A punch list will be created of items to add or delete identified from other committees and Staff. Alderwoman Burd would like to see more money for the Facade Program and for Public Relations to be expanded. She would also like to work on an incentive program for Small Business. Alderwoman Spears said Mrs.Austin called her about the rezoning of the duplex sold to the Van Riper Insurance Agency. Alderwoman Ohare spoke to her also. She had a concern that there was no covenant mentioned. Mrs.Austin pays a monthly association fee and the Business is not exempt. Mrs.Austin was concerned because the restrictions don't come out until after the closing. Alderwoman Spears has had concerns from residents that some of the residents were not notified of the Public Hearing or of a vote.. The city sends out a certified letter to the residents for the Public Hearings, and knows they received the letter,but they do not notify the residents of when the voting will take place,that is up to the residents to track. Rose Spears asked about the turnaround time of meeting notes from minute takers and court reporters. She said the two week turnaround policy should be enforced.. This will be brought back to Administration next month. Page 3 of 3 Tracy Pleckham said there will be a special meeting, possibly on March 13th, for the next fiscal year's budget. Goals and Objectives should be thought about beforehand. Alderman James said there are 5 Tuesdays in January, and that maybe the 5th Tuesday should be set aside for Goal setting. Alderwoman Burd would like to see a resolution put on the agenda for Tuesday night supporting the School District Referendum. John Crois said there was a press release that FE Wheaton was purchased by Lanoga Corporation. They now have more capital and staff and expertise and will be expanding their services. Bill Powell said there is an inverted yield curve right now and the City is making such good interest on the short term investments that there is no rush to turn them into long term investments. The meeting was adjourned at 7:30 pm. Minutes submitted by Laura Leppert. Page 1 of 7 1AF 1 UNITED CITY OF YORKVILLE ADMINISTRATION COMMITTEE MEETING THURSDAY,FEBRUARY 2,2006 6:30 PM City Hall Conference Room CITY OFFICLALS IN ATTENDANCE: Alderman Paul James Finance Director Traci Pleckham Alderwoman Rose Spears City Treasurer Bill Powell (arr.6:35) Alderwoman Valerie Burd Payroll &Benefits Specialist Denise Kasper Interim City Administrator John Crois Travis Miller, Community Development Director(arr.6:45pm) Bart Olson, Deputy Clerk/Intern Police Chief Harold Martin(left 8:33pm) GUESTS: None The meeting was called to order at 6:30pm by Alderman Paul James. PRESENTATION• None OLD BUSINESS: 1. MinutesforApprovaUCorrection:January 5, 2006 These minutes will be brought back next month so that the committee members can review. NEW BUSINESS: 1. Monthly Budget Report for December 2005 Ms. Pleckham reported that through the end of December the budget is at 58%of the revenue and 40% of the expenses of the general fund. Summary points were also added to the summary page. She added that the budget should be at 67%of the revenues,but that it is close. This report is for information only. 2. ADM 2006-10 Monthly Treasurer's Report for December 2005 The overall Combined Fund balance is 37%with 39% in the general fund. The general fund is up due to funds for the road program. This moves to C.O.W. consent agenda. Page 2 of 7 3. ADM 2006-14 Proposed Revised Budget—Fiscal Year 200512006 Ms. Pleckham reported on the budget. Department heads have reviewed their portions of the budget and they made recommendations for some changes. The following highlights were briefly discussed by Ms. Pleckham: 1. The summary page showed a revenue decrease of$2.9 million related to project timing in the Grande Reserve. The street department will take the major share of this decrease because the money is earmarked for roads. 2. Planning& Development shows a decrease of 20% due to the timing of the new hires in that department. 3. On page 1, some of the revenues were adjusted per the audit report 4. Planning fee removed from budget due to timing reasons. 5. Investment income has increased due to sound investments by Mr. Powell. 6. Road program has increased. 7. Interest rates have increased overall to about 4%. 8. Page 2 has request for Assistant Administrator and salary is included here. This item will be taken back to the Administrative Task Force before the next Council meeting. Ms. Pleckham noted that the COLA increases were factored in this line item as well. Mr. Powell said he preferred to have this shown as separate line items when the initial budget is done and as one total in the revised budget and this is how is was actually done. Ms. Spears said she preferred to see the COLA amounts broken out by departments. 9. Insurance costs were down due to delay in hiring. 10. There is an additional request for funds in the Fagade Program for an applicant. 11. The State has asked the City for a commitment before Rt. 47 engineering is begun so capital projects and funding sources will need to be determined. Revised census should be available in 2 weeks that will provide additional money,plus the Fund Balance can be used if necessary. Other discussion of the budget: Ms. Burd asked if the Intern program would be continued if an Administrative Assistant were hired for the Council. Ms. Pleckham said it would be helpful to continue the Intern program because it allowed her more time for project-oriented tasks rather than day-to- day requests. Public Relations An additional $12,000 for Public Relations was then discussed. Some of that amount is earmarked for the employee appreciation dinner and some for new resident packets. Ms. Spears asked if the Chamber provided information for new residents. Ms. Pleckham said that they do,however, City information is not included. She thought that these packets were given to new residents when their certificate of occupancy is issued. Mr. Crois added that it is not unusual for cities to provide these packets and said that the new Page 3 of 7 parking ban information should be included. Ms. Burd added that she would like to see color on the newsletter. Page 3 of the proposed revised budget, showed that contingencies were up, however, Ms. Pleckham said she was not concerned since the City is close to the end of the fiscal year. Also on page 3,the computer equipment is up due to licensing being upgraded. Parks&Rec have decreased due to funds left from last year. Mr. Crois added that Dr. Engler had told him the recreation programs would cease at the schools if the school referendum does not pass. As a result, Mr. Crois asked the Parks Department to do contingency planning in that event. The basketball program would be the one most affected,however, alternative plans are being researched. Ms. Spears inquired about the merit pay. The $51,104 amount was split up amongst the various departments. Ms. Pleckham added that the employee salary increases were various percentages so the total amount was split up accordingly. Engineering costs were increased due to contractual services related to Brownfield. There will be some reimbursement for this. Ms. Burd asked if the City had a GIS system(page 4). This system has been in place for about a year. Public Safety It was noted that Public Safety showed an increase in salaries. The Chief commented on that cadet program, saying it was operating better than even expected and another cadet is planned. Ms. Burd complimented Alderwoman Spears for pursuing this program. The primary change in the Public Safety budget was the increased cost of gas. Planning& Development The numbers were trued-up due to timing of hiring. Legal services in this category also increased due to an increase of attorney services for development. Some of this is reimbursible if it pertains to a specific development. Another increase includes money earmarked for a plotter. This is a transfer from Parks&Rec. MFT Ms. Pleckham reported that the numbers were trued-up. The special census numbers were removed because there will not be a large amount of money realized this fiscal year as a result of the census. Municipal Building The development fees showed a slight decrease at this time,but increased revenues should come in later. Page 4 of 7 Police Capital Mr. Powell asked the Chief if he anticipated any additional need for funds for disaster plans. The Chief does not need more funds at this time, but they will be needed when more growth occurs. Mr. Powell suggested the purchase of two laptops available to the Mayor or Chief, in the event of a disaster or if City Hall was damaged. Public Works Capital Ms. Pleckham reported the carryover balance was trued-up and the development fees increased sharply. Parks&Rec There was a carryover of$60,000 for two trucks that were approved in the last fiscal budget. Also,there were increased costs for office supplies for a computer replacement. Merit pay decreased Sewer& Water Project costs were trued-up. The Bruell St. project exceeded original estimate. Countryside TIF Demolition is scheduled for this spring. Mr. Crois will check on the status of the last tenant who moved out on December 31St Water Improvement This reflects many contracts that EEI is working on. Also shows alternate bond. This concluded the discussion of the proposed revised budget. 4. ADM 2006-04 Library Buildout Repayment Information Ms. Pleckham and Mr. Powell commented briefly on the payment schedule for the Library. Ms. Pleckham will ask Tom Lindblom to come to a future C.O.W. for an update of the Library progress. 5. ADM 2006-05 Fiscal Year 2006/2007 Budget Requests Some of these requests were discussed last month: Facade Program, Rt. 47,part-time secretary/minute taker for the Police Pension Board,electronic documents/scanning of documents, laptops for aldermen. Additional items will also come from the goal-setting meeting February 11th. Any other ideas should be submitted to Ms. Pleckham before March 13. 6. ADM 2006-11 Health Insurance Information Quotes are being obtained by Caywood&Associates for a May 1St renewal date. Ms. Pleckham said two vendors had declined the request for rates. Names of vendors should be available next month. It was noted the IML does not provide group health insurance. Page 5 of 7 Ms. Pleckham said that some communities are starting to charge their employees a small percentage of the monthly cost. Ms. Spears asked if this type of information could be gathered; it will be brought back next month. Ms Kasper said that she had contacted Montgomery and Sugar Grove and neither town requires employee contributions. Mr. Crois noted that contract employees pay a certain percentage already. Ms. Spears also asked if the City contacts other companies in addition to Caywood. Ms. Pleckham replied that Caywood is recommended because employees can easily contact the rep directly and the service is very good. Broker fees are set by the plans so there are no better rates This item will be brought back to next month's meeting for more discussion. 7. ADM 2006-12 Minute Taking Policy Alderwoman Spears said she had found a memo that was issued by City Clerk Milschewski in 2001. The memo stipulated that the completed minutes and the tapes were to be turned in one week prior to the next committee meeting. Ms. Spears said it was originally two weeks prior and she thought that a policy had been implemented. Mr. Olson will review this with Ms. Milschewki and it will be brought back next month. 8. ADM 2006-13 Hiring Policy Mr. Crois sent a list of questions to the committee members for input regarding a hiring policy. It was agreed that a search firm and RFP should be used for the City Administrator or Department Heads (a list will be made of these). Proposals for the firms would be brought directly to C.O.W. meetings. When the search firm finds candidates, those candidates will be brought to the appropriate committee to determine who will be interviewed. Those committees would then present the finalist's name to the Mayor for an interview and hiring decision. It was also noted by Ms. Pleckham that the Administrator/Mayor should have a role in the interviews of those employees reporting to the Administrator. Mr. Crois will draft a policy and bring it back to committee next month. 9. ADM 2006-15 Municipal Building Impact Fee Mr. Olson asked the committee to review the memo regarding the current municipal building fee that is currently $150. He said he had reviewed Sugar Grove's capital impact fee and it is $6,600. Yorkville's capital impact fee is $2,800. A presentation was given by Mr. Olson that examined a timeline for city building construction. He presented seven different scenarios. Based on discussions at staff/committee levels,he felt that police and public works facilities were the most pressing building needs, followed by a City Hall. Page 6 of 7 Approximately 7,600 units are not currently locked into an impact fee and could probably be negotiated for higher impact fees in future annexation agreements. Mr. Powell also asked about the possibility of a referendum or other taxes to finance construction. Various types of taxes were discussed. Mr. Olson suggested that the impact fee should be raised immediately with all the development pending. It was suggested that the fees for Montgomery and Oswego be reviewed as well. Alderman James said that a recommendation for an increase should be made and this matter moved on to C.O.W. A fee of$3,000 was suggested by Alderwoman Burd. A review of fees for surrounding communities was also requested. Scenario seven was selected as the most feasible: this would allow for construction of a police, public works and city hall to be built first. It would also include the cost of community, senior and aquatic centers to be financed through public-private partnerships or referendum. This matter will come before C.O.W. on February 20. 10. ADM 2006-16 Draft Job Description for Community Development Department a. Senior Planner b. City Park Designer c. Urban Designer d GIS Coordinator Travis Miller prepared a schematic of his vision of this department and also prepared Job Descriptions for a City Park Designer and Urban Designer. He would like to see the Senior Planner and GIS Coordinator be put into the 06/07 budget. The other two positions are already in the current proposed budget. He gave an overview of the job duties for all these positions. He added that outside services might still be needed even with a City Park Designer in place. Ms. Pleckham suggested that language be added to the City Park Designer description to include"works closely with Superintendent or Director of Parks/Recreation". Alderwoman Spears asked if any portion of these salaries could be paid for by developers. Land cash can be used. The City Park Designer and Urban Designer Job Descriptions and salary ranges will move forward to C.O.W. 11. ADM 2006-17 Waterworks System—EEI Contracts B.2 and B.3 Abatement Ordinance 12. ADM-200618 Rob Roy Creek Interceptor Abatement Ordinance These 2 items were discussed together. Ms. Pleckham said that these are the last 2 of 6 abatements. The deadline for filing is February 28. She is working with Glory Spies to Page 7 of 7 disseminate the information. These will move to the C.O.W. consent agenda on February 7th 13. ADM 2006-19 Plan Review Fees A memo from City Engineer Joe Wywrot recommended adding a surcharge of 0.35%for plan reviews outsourced to EEI. There is still City staff time involved in these reviews and this increase would help pay for that time. This will move on to C.O.W. consent agenda. 14. ADM 2006-20 Amending the Administrative Assistant Job Description Alderwoman Burd said she asked that this item be placed on the agenda. She envisioned that one facet of this position would be to remind Aldermen of upcoming meetings to insure a quorum. Mr. Crois offered current City staff assistance to accomplish this. Ms. Burd also said she would like a"go to"person to assist the Council. She cited another duty as being able to obtain certain documents that Council members are not able to, in the course of a day. There was a brief discussion about past problems with securing documents and the need to avoid similar problems in the future. Mr. Crois interjected that all Council members should have the same documents/information to make decisions and that Council members should obtain those from the City Administrator. Ms. Burd asked to go on record saying that if a logical request for information is made, all Aldermen should be able to have original documents for decision-making. ADDITIONAL BUSINESS: Ms. Pleckham reported that the SSA bond ordinances for Bristol Bay and Autumn Creek will be moving to the C.O.W. on February 21. Peter Rafael and representatives of both developments will be present to answer questions. The ordinances are the last documents for the SSA and the SSA's are included in the annexation agreements. There was no further business and the meeting was adjourned at 9:05pm. Minutes respectfully submitted by Marlys Young, Minute Taker ♦,�t�D Cdr` Reviewed By: Legal ❑ City Council Finance ❑ EST. Engineer ❑ 4 City Administrator ❑ Agenda Item Tracking Number 9 �� ADM 2006-11 �O Consultant ❑ F1 SCE �`'�. City Council Agenda Item Summary Memo Title: Health Insurance/Benefit Renewal Information City Council/COW/Committee Agenda Date: Admin 3/2/06 Synopsis: Joe Roberts from Caywood and Associates will be at the meeting to review renewal rates and distribute information. Broker commission information is attached. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Traci Pleckham Finance Name Department Agenda Item Notes: 04/28/2005 14:21 FAX 6305523850 CAYWOOD AND ASSOCIATES 0 002 BlueCross BlueShiield of U nois i March 29,2005 Ms. Traci Pleckham United City of Yorkville 800 Game Farm Road Ates Yorkville,Illinois 60560 Dear Traci: I would like to take this opportunity to explain how commissions are handled for brokers who have business with Blue Cross Blue Shield of Illinois. For groups that range from 4-150 lives, brokers are paid using a standard commission schedule. This schedule is 8%graded,meaning that as time goes on and premiums from the group accumulate,the percentage paid to the broker decreases until $150,000 in premiums have been paid. From.that point forward,the broker is paid a flat percentage. The broker is not allowed to deviate from this schedule with one exception. If a group is 51+in size,he/she does have the option of increasing commissions up to an additional 3%. Caywood and Associates have chosen not to exercise this option. For groups that are 150+ in size and experience-rated, the broker's commissions are negotiated. I hope this provides the informal:ion you need. Should you have any additional questions, please do not hesitate to contact me. Sincerely, Susan C. Moreau,HIA, CEBS,CLU,RHU,REBC Senior Account Representative sin cc: Joe Roberts, Caywood&Associates 2787 McFarland Road•Rockford,Illinois 61.107•(815)659-1500•(815)639-1808 l7ar•www.b(,l)sil.com Blue Crnu and Ukee j1deld wits.oils,u 1Nvisiou.vacalell Care Sark s Corporation,a millual L.eSal11eserve coropmu'. an 1lndepcndcut I Iceivcc of the Glaa Cross and Muc Shlcld dssociation METLIFE SMALL BUSINESS CENTER(SBC) COMIVIISSION AGREEMENT This Agreement is made by and between METROPOLITAN LIFE INSURANCE COMPANY ("MetLife")and the Producer whose signature appears below. MetLife and Producer hereby agree as follows: 1. Commissions. Producer will receive monthly commissions from MetLife for each coverage sold. Monthly payments will be determined by applying the attached schedule to the actual premium received per line of sold coverage within the policy year,and subtracting the commissions already paid during the policy year. Commissions are calculated based on premium received by line of coverage and will be paid so long as(a)Producer is licensed by the applicable State Insurance Department and appointed by MetLife to sell the insurance provided by the policy;(b)Producer services the business;(c)MetLife recognizes Producer as the agent/broker of record;(d)any commission advances or overpayments have been properly recovered by MetLife; (e)the policy remains in force; and(f)this Agreement is in effect. S.c e, P ale 3 2. Risk Acceptance. It is understood and agreed that MetLife retains the exclusive right to(a)bind or commit MetLife on any risk in any matters; (b)decline any application for insurance submitted by the Producer,(c)discontinue any form of policy in any or all jurisdictions in which MetLife does business; and(d)resume the use of any policy at any time. 3. Overpayments. It is agreed that any overpayment of commissions which may occur due to clerical error; cancellation of coverage;refund of premium;payment of any advance if applicable; change of agent/broker of record by the policyholder or MetLife;or any other reason,will be returned to MetLife by the Producer. It is further agreed that MetLife is authorized to recover any overpayments from the current or future commission owed the Producer by MetLife or its affiliates. Producer agrees to reimburse MetLife for expenses, including costs and attorneys' fees, associated with the collection of outstanding debts due MetLife from Producer. 4. Independent Contractor. Producer acknowledges and agrees that it is an independent contractor and not an employee of MetLife. 5. Notices. If Producer receives notice of the commencement of any legal,regulatory or administrative proceedings involving MetLife or Producer,or if it receives any communication from any Insurance Department or other administrative agency or any other person identifying a complaint registered against MetLife or Producer,Producer shall, following receipt of such notice, immediately notify MetLife of the proceeding or complaint,and promptly forward any correspondence or necessary files to MetLife. 6. Customer Information. Producer agrees to treat all information about individuals who enroll,apply for or purchase MetLife's products or services that Producer may have or may obtain in connection with its obligations under this Agreement("Customer Information")as confidential. Customer Information may include, but is not limited to, an individual's name, address, social security number, as well as any financial or health information relating to the individual. Producer may use Customer Information only for the purpose of fulfilling its obligations under this Agreement and Producer may not disclose Customer Information to anyone other than the individual to whom the information relates, except as required for Producer to fulfill its obligations under this Agreement or as otherwise directed by MetLife, or except as expressly required by law. Producer must also ensure that Customer Information is kept in a secure manner. 7. Protected Health Information. "Protected Health Information"or"PHI"is defined as individually identifiable information that is transmitted or maintained in any medium and relates to: the past,present or future physical or mental health or condition of an individual;the provision of health care to an individual; or future payment for the provision of health care to the individual. MetLife and Producer understand that this definition of PHI includes demographic information about the individual, including names; geographic subdivisions smaller than a state (including but not limited to street addresses and ZIP codes);all elements of dates(except year)for dates directly related to an individual, including but not limited to birth date;telephone numbers; fax numbers; electronic mail(E- mail)addresses; Social Security numbers; Medical record numbers;health plan beneficiary numbers;account numbers; certificate/license numbers;vehicle identifiers and serial numbers, including license plate numbers;device identifiers and serial numbers; Web Universal Resource Locators(URL's);Internet Protocol(IP)address numbers; biometric identifiers, including finger and voice prints; full face photographic images and any comparable images; and any other unique identifying number, characteristic, or code. In order to further protect the confidentiality of any PHI disclosed to or used by Producer pursuant to this Agreement and to satisfy requirements of the Health Insurance Portability and Accountability Act of 1996 and its privacy regulations as may be amended from time to time Page 1 of 3 ("HIPAA"),MetLife and Producer agree to the following with respect to any PHI received or created by Producer in providing services pursuant to this Agreement,including PHI received or created prior to the effective date of this Agreement("MetLife PHI"): (a)the obligations regarding MetLife PHI contained in this section shall be in addition to any other obligations contained in this Agreement that apply to MetLife PHI;(b)Producer may not use or disclose MetLife PHI except to provide services pursuant to this Agreement; (c)Producer shall use appropriate safeguards to prevent use or disclosure of MetLife PHI; (d)MetLife and Producer represent and warrant that their security procedures are adequate to protect and maintain the confidentiality of MetLife PHI; (e)Producer shall promptly report to MetLife any use or disclosure of MetLife PHI not permitted by this Agreement of which it becomes aware;(f) Producer shall ensure that any Agents, including any sub-contractor or Producer affiliates,that Producer may use in accordance with this Agreement and to whom Producer provides MetLife PHI or who uses MetLife PHI has been approved by MetLife in writing and agrees to the same restrictions and conditions that apply to Producer with respect to MetLife PHI pursuant to this Agreement;(g)within thirty (30)days of MetLife's request,Producer shall provide to MetLife any MetLife PHI or information relating to MetLife PHI as deemed necessary by MetLife to comply with its obligations under HIPAA to provide individuals with access to, amendment of, and an accounting of disclosures of their MetLife PHI,and Producer agrees to incorporate any amendments of the MetLife PHI as requested by MetLife; (h)Producer agrees to make its internal practices,books,and records relating to its use or disclosure of MetLife PHI available to the Secretary of the United States Department of Health and Human Services at his/her request to determine MetLife's compliance; (i)Producer agrees that upon termination of the Agreement it will, if feasible,return or destroy all MetLife PHI it maintains in any form and retain no copies, and if such return or destruction is not feasible,Producer agrees to extend the protections of this Section 7 to the MetLife PHI beyond the termination of this Agreement and further agrees that any further use or disclosure of the MetLife PHI will be solely for the purposes that make return or destruction infeasible; 0)Producer may use or disclose MetLife PHI to the extent that such use or disclosure is required by law and the use or disclosure complies with and is limited to the relevant requirements of such law, and only to the extent that such use or disclosure complies with any applicable HIPAA requirements relating to uses and disclosures required by law. 8. Amendments. MetLife reserves the right to amend this Agreement by providing Producer with thirty(30)days prior written notice of the change. 9. Advertising. In connection with the sale or marketing of MetLife products,Producer shall use only sales material approved in writing by MetLife. 10. Termination. MetLife may terminate this Agreement at any time for any or no reason. Additionally,this Agreement shall terminate immediately if(a)Producer is no longer appointed by MetLife to sell its products;(b)Producer is not licensed by the applicable state insurance department; (c)Producer breaches any provision of this Agreement; (d) Producer commits or its agents commit fraud, embezzlement, gross negligence or other legal misconduct. Notwithstanding the termination of this Agreement,the rights and obligations established under Sections 3, 5, 6,and 7,hereof, shall in their entirety continue in effect for a period of six(6)years following termination of this Agreement. METROPOLITAN LIFE INSURANCE COMPANY Producer's Printed Name Martin J. Fuller Vice President Producer's Signature Date Date Social Security Number (Tax ID if Corporation) Page 2 of 3 MetLife Small Business Center (SBC) Commission Agreement MetLife SBC Commission Schedule for: Basic Life, Core Life, Dependent Life,AD&D, STD and State Mandated Disability Dental Annual Premium New Business Renewal Annual Premium New Business Renewal Commission Commission Commission Commission First $5,000 15.00% 15.00% First $5,000 10.00% 10.00% Next $5,000 10.00% 10.00% Next $5,000 7.50% 7.50% Next $20000 5.00% 5.00% Next $20,000 5.00% 1 5.00% Next $10,000 1 3.50% 3.50% Next $10,000 3.50% 3.50% Next $10,000 3.00% 3.00% Next $10,000 3.00% 3.00% Next $10,000 2.00% 2.00% Next $10,000 2.00% 2.00% Next $190,000 1.75% 1.75% Next $190,000 1.75% 1.75% Next $250,000 1.00% 1.00% Next $250,000 1.00% 1.00% Next $500,000 0.50% 0.50% Next $500,000 0.50% 0.50% Next $4,000,000 0.25% 0.25% Next $4,000,000 0.25% 0.25% $5,000,000 &over 0.10% 0.10% $5,000,000 &over 0.10% 0.10% Long Term Disability Annual Premium Commission First $15,000 15.00% Next $10,000 10.00% Next $25,000 5.00% Next $200,000 2.00% Excess over$250,000 1.00% Buy-Up Life,Enhanced Optional Life and Enhanced/Buy-Up Dependent Life and Voluntary Short Term Disability: Flat 15%of annualized remium This schedule shall not apply to MetLife Financial Services (MLFS) or New England Financial (NEF) producers. Meft fe Page 3 of 3 4,�) Co. Reviewed By: J� 0 06 Legal r-1 City Council Esr. � 1836 Finance ❑ Engineer ❑ 4 ` . (4 City Administrator El Item Tracking Number O ` 9 ?O Consultant ❑ <LE Human Resources ❑ City Council Agenda Item Summary Memo Title: Minute Taking Policy City Council/COW/Committee Agenda Date: Admin—March 2, 2006 Synopsis: Memo on an update from last month's minute taking policy discussion Council Action Previously Taken: Date of Action: N/A Action Taken: Item Number: Type of Vote Required: N/A Council Action Requested: N/A Submitted by: Bart Olson Administration Name Department Agenda Item Notes: See memo Cip J� o� United City of Yorkville Memo 800 Game Farm Road EST _ 1835 Yorkville, Illinois 60560 4 Telephone: 630-553-4350 0 ;;A Fax: 630-553-7575 <LE Date: February 28, 2006 To: Administration Committee From: Bart Olson, Deputy Clerk CC: John Crois, City Administrator Subject: Minute Taking Policy Per February Admin Committee meeting, I was asked to look at the current minute taking policy. Currently, all minutes are to be submitted to the City Clerk prior to packet distribution for the next meeting of the given committee. After the minutes are placed on the agenda and approved, they are available for public dissemination. I believe part of the confusion on the policy from last month's committee meeting discussion involved a citizen complaint that a specific set of minutes were not available at the time they were requested. It has been reiterated to me by the City Clerk that at the time of the request,the minutes were not approved and therefore could not be handed out. There is a possibility that the approval of the minutes were delayed because the minutes for the public hearing, which are done by a separate company- Depo Court,had not been received yet(this happens on rare occasion). The City Clerk and I will continue to monitor Depo Court's turn around time, and provide information should we encounter any problems. As far as the actual formation of a City policy to govern the turn around time on minutes, the City Clerk's log of the performance of City minute takers has yielded near 100% compliance with the City Clerk's own informal policy—the exceptions being in cases of family or personal emergency. Therefore, we do not feel that a formal minute-taking policy is warranted at this time. CIP J� o� United City of Yorkville Memo 800 Game Farm Road EST _ 1836 Yorkville, Illinois 60560 -��- ,� Telephone: 630-553-4350 " p Fax: 630-553-7575 <LE Date: March 1, 2006 To: Administration Committee From: Lisa Pickering, Office Assistant CC: Department Heads Subject: Additional information for Administration Committee packet—March 2, 2006 Attached please find information on Item 013#4—Hiring Policy. Please add this information to your Administration Committee packet. 06 4 ♦,��D C/r` Reviewed By: J= ��► Legal ❑ City Council Finance F1 EST. 1836 Engineer ❑ Agenda Item Tracking Number -4 ' City Administrator O L ADM 2006-13 S11 ,� �O Consultant ❑ Tye 44LE ,�,�. ❑ City Council Agenda Item Summary Memo Title: Hiring Procedures City Council/COW/Committee Agenda Date: Admin 3/2/06 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: John Crois Administration Name Department Agenda Item Notes: United City of Yorkville a c+ County Seat of Kendall County 800 Game Farm Road EST. 18M Yorkville, Illinois, 60560 Telephone: 630-553-4350 Fax: 630-553-7575 Website: www.yorkville.il.us <LE Date: February 28,2006 To: Administration Committee Members From: John H. Crois,Interim City Administrator Subject: Hiring Procedures In hiring the goal of the City should be to attract a pool of qualified applicants, and to hire the best qualified applicant who meets the City's qualifications and needs. When hiring for positions which report to the Mayor and Council and/or another Board,the Council should consider using a recruitment firm. The City Administrator's position is one of the City's highest level position and reports directly to the Mayor and Council. Therefore I feel that the recruitment process should be coordinated by someone not on the City staff. There are several recruitment firms which specialize in this type of recruitment. They would be best qualified to guide the Mayor and Board through the recruitment process. The other positions reporting to the Mayor and Council are the Police Chief, Executive Director of parks and recreation,and the Community Relations Director. Of the three the Community relations Director could probably be recruited by an in-house process. There are recruitment firms which specialize in Police Chiefs and Executive Directors of Park and Recreation. Again it would seem that an outside firm would be best to coordinate the recruitment process. In terms of the budget officer, city engineer,public works director, and community development director, I feel the most important factor is to verify their knowledge and expertise. This can be accomplished by utilizing professionals in the discipline being recruited. The resumes can be received by the HR Department and reviewed by the City Administrator,HR, and a professional in the field being recruited. Then the top ten rdsum6s can be presented to the appropriate committee for review and selection of candidates to be interviewed. The interviews would be conducted by the committee with assistance and input from the City Administrator and area of expertise professionals. The finalist or top candidates would then be submitted to the Mayor for his consideration and appointment. This is an overview of my suggestion of how the hiring process should be handled. I will be at the Administrative Committee meeting to answer any questions you may have. With your assistance and ideas a final policy can be formulated. UNITED CITY OF YORKVILLE BUDGET 2005-2006 GENERAL FUND SUMMARY PERIOD ENDING JANUARY 31, 2006 75.0% OF FISCAL YEAR REVENUE/EXPENSE 2005-2006 PERCENT VS. THRU JANUARY 31, 2005 BUDGET BUDGET AMOUNT TUND 1`2EVENlJE 1:1 y554,631 ` ' G 18;008;436 'L 64.16% GENERAL FUND EXPENSES FINANCE & ADMINISTRATION 3,414,240 5,134,030 66.50% ENGINEERING 287,196 373,132 76.97% POLICE 1,601,057 2,145,143 74.64% PLANNING & DEVELOPMENT 125,659 324,607 38.71% STREETS 2,435,144 9,459,954 25.74% HEALTH & SANITATION 389,636 571,170 68.22% TOTAL GENERAL FUND EXPENSES x.8;252;933 ,>: .: 18;008;036 45.83% UNITED CITY OF YORKVILLk; JANUARY 2006 BUDGET 75.0% FISCAL YTD PAGE FISCAL YEAR-TO FISCAL YEAR %COLLECTED/ FUND # ACCOUNT NUMBER DESCRIPTION DATE ACTUAL BUDGET EXPENDED COMMENTS GENERAL 1 01-000-40-00-3996 ROAD CONTRIBUTION FEE $ 813,098.00 $ 550,000.00 147.84% BRISTOL BAY PERMIT FEES COLLECTED GENERAL 2 01-000-42-00-4211 ENGINEERING CAPITAL FEE $ 35,800.00 $ 27,500.00 130.18% BRISTOL BAY PERMIT FEES COLLECTED $5,300.00 REIMBURSEMENT FROM FO GENERAL 2 01-000-44-00-4490 MISCELLANEOUS INCOME $ 9,130.28 $ 10,000.00 91.30% INDUSTRIAL FUND ADMIN 3 01-110-61-00-5300 LEGAL SERVICES $ 41,081.67 $ 35,000.00 117.38% 7,800.00 LABOR ATTORNEY ADMIN 4 01-110-62-00-5400 INSURANCE-LIABILITY&PROPERTY $ 121,210.58 $ 130,000.00 93.24% ONE TIME LUMP SUM PAYMENT ADMIN 4 01-110-64-00-5605 TRAVEL/MEALS/LODGING $ 13,634.06 $ 17,000.00 80.20% DUE TO IML CONFERENCE HALLOWEEN&CHRISTMAS TROLLEY,CITY ADMIN 4 01-110-64-00-5607 PUBLIC RELATIONS $ 12,267.23 $ 18,000.00 68.15% MAGNETS,WATER SHED PROGRAM ADMIN 5 01-110-75-00-7002 COMPUTER EQUIP&SOFTWARE $ 10,885.71 $ 13,500.00 80.63% PAYMENT FOR HR MODULE&PROJECTOR ENGINEERING 6 01-150-62-00-5401 CONTRACTUAL SERVICES $ 60,507.63 $ 20,000.00 302.54% BROWNFIELD EXPENSE$21,000 ENGINEERING 7 01-150-64-00-5605 TRAVEL EXPENSES $ 956.40 $ 1,000.00 95.64% ONE TIME CONFERENCE TRAVEL EXPENSES UNANTICIPATED ACCIDENT&TRANSMISSION POLICE 8 01-210-62-00-5409 MAINTENANCE-VEHICLES $ 20,380.12 $ 21,000.00 97.05% WORK DUE TO INCREASED OS -WILL BE REVISED ON POLICE 8 01-210-62-00-5441 MTD-ALERTS FEE $ 4,620.00 $ 2,400.00 192.50% BUDGET POLICE 9 01-210-64-00-5605 TRAVEL EXPENSES $ 9,244.38 $ 9,000.00 102.72% POLICE 9 01-210-72-00-6502 POLICE PENSION $ 231,123.76 $ 231,686.00 99.76% PAYOUTS BASED ON PROPERTY TAX REVENUE POLICE 10 01-210-78-00-9004 BIKE PATROL $ 1,422.51 $ 2,000.00 71.13% SEASONAL EXPENSE PLANNING& LEGAL SERVICES RELATING TO BOUNDARY DEVELOPMENT 10 01-220-61-00-5300 LEGAL SERVICES $ 29,406.18 $ 20,000.00 147.03% MATTERS PIsAI�II�tING$s - l3 RECEIVEDs$8,1.12.50 FOR COMPREHENSIU PLAN: D L Lt3 MCA 1�I ,T lO " 01 2 0 6 00-5430 P AI!11 1G GZ�1 51�LIANT = 9>807 92 $ 0,000.00 "1:9 04°l0, ECM NDIVIEN7 �NORfH VES .LAND STREETS 13 01-410-75-00-7100 STREET REHAB PROJECTS $ 35,646.99 $ 40,000.00 89.12% PROJECTS DONE/NEAR COMPLETION ORKVILLE MOOSE DONATION FUR POLIC PD CAPITAL 19 20-000-44-00-4404 DONATIONS $ 1,500.00 $ 500.00 300.00% VESTS PD CAPITAL 19 20-000-44-00-4489 RICP DISASTER PLAN GRANT $ 9,990.27 $ - 100.00% POLICE CAPITAL GRANT PD CAPITAL 19 20-000-44-00-4490 MISCELLANEOUS INCOME $ 24,609.27 $ 100.00% RECEIVED 1998 GRANT DOLLARS YORKVILLE JUNIOR WOMEN'S TEAM DONATED PARKS&REC $1000 FOR PLAYGROUND CAPITAL, YYBS CAPITAL 23 22-000-42-00-4217 PARKS CAPITAL-DONATIONS $ 7,000.00 $ - 100.00% DONATED$6,000 FOR FOX HILL FIELD DONATION SHALLOW WELL$3,754.00, Eli;I-GENERAL WATER ENGINEERING$6,900.00&WATER QUALITY IMPROVEMENT 29 41-000-61-00-5301 ENGINEERING-GENERAL SERVICES $ 12,681.00 $ 8,000.00 158.51% $1,550.00 WATER LOANER/RENTAL GAS DET E CTOR UNIT B OPERATIONS 35 51-000-75-00-7004 SAFETY EQUIPMENT $ 2,325.01 $ 2,000.00 116.25% CREDITED ON RETURN SEWER RESIDENT SEWER&DRIVEWAY REPAIR OPERATIONS 37 52-000-62-00-5401 CONTRACTUAL SERVICES $ 3,445.33 $ 2,000.00 172.27% $2818.00 1,46 . 0 GATOR REPAIRS, 1, ENGINE PARKS&REC 46 79-610-62-00-5408 MAINTENANCE EQUIPMENT $ 6,864.39 $ 6,000.00 114.41% REPAIRS&PARTS LIBRARY 54 82-000-65-00-5842 BLDG-DEVELOPMENT FEES $ 1,259,842.37 $ 153,570.00 820.37% LIBRARY EXPANSION INTEREST RATE INCREASES&ADDITIONAL BOND ALL VARIOUS INVESTMENT INCOME 96.2%-9559.7% PROCEEDS NOT YET EXPENDED ALL VARIOUS jGASOLlNE 88.4%-152.8% GAS PRICE INCREASES "zutadowed area epreserittlusmonths ne�v addittcxl gam$ UNITED CITY OF YORKVILLE DETAILED REVENUE & EXPENSE REPORT AS OF JANUARY 31, 2005 General Fund Revenue 1 Sanitary Sewer Improvement&Expansion 25 Finance 3 Water Improvement& Expansion 28 Engineering 6 Debt Service Fund 31 Police 7 Water Operations 33 Planning and Development 10 Sewer Maintenance 37 Streets and Alleys 11 Land Cash 40 Health and Sanitation 13 Land Acquisition 44 Motor Fuel Tax Fund 15 Parks& Recreation 45 Municipal Building 17 Working Cash 51 Police Equipment Capital 19 Library 52 Public Works Equipment Capital 21 Fox Industrial 56 Parks &Recreation Equipment Capital 23 Countryside TIF 58 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 1 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW 75% of Fiscal Year FUND: GENERAL FUND FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ GENERAL REVENUES TAXES 01-000-40-00-3995 FUND BALANCE 0.00 0.00 0.00 0.0 01-000-40-00-3996 ROAD CONTRIBUTION FEE 162,000.00 813,098.00 550,000.00 147.8 01-000-40-00-3997 IN TOWN ROAD PROGRAM FUNDING 0.00 3,783,562.20 4,350,210.00 86.9 01-000-40-00-3998 MPI BRISTOL RIDGE RD FUNDING 0.00 40.00 4,000,000.00 0.0 01-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 50,000.00 0.0 01-000-40-00-4000 REAL ESTATE TAXES 0.00 1,387,085.39 1,393,821.00 99.5 01-000-40-00-4001 TOWN ROAD/BRIDGE TAX 0.00 101,790.99 98,000.00 103.8 01-000-40-00-4002 FOX HILL LEVY REVENUE 0.00 0.00 7,850.00 0.0 01-000-40-00-4010 PERSONAL PROPERTY TAX 1,810.34 9,947.56 10,000.00 99.4 01-000-40-00-4020 STATE INCOME TAX 38,890.34 344,481.81 638,820.00 53.9 01-000-40-00-4030 MUNICIPAL SALES TAX 232,117.31 1,522,030.03 2,308,900.00 65.9 01-000-40-00-4032 STATE USE TAX 8,054.55 59,540.43 97,006.00 61.3 01-000-40-00-4040 MUNICIPAL UTILITY TAX 113,675.29 286,028.43 500,000.00 57.2 01-000-40-00-4041 UTILITY TAX - NICOR 0.00 49,044.21 100,000.00 49.0 01-000-40-00-4042 UTILITY TAX - CABLE TV 0.00 57,346.37 65,000.00 88.2 01-000-40-00-4043 UTILITY TAX - TELEPHONE 42,608.35 260,620.95 325,000.00 80.1 01-000-40-00-4050 HOTEL TAX 1,565.11 14,597.43 20,000.00 72.9 01-000-40-00-4060 TRAFFIC SIGNAL REVENUE 0.00 0.00 5,000.00 0.0 --------------------------------------------------------------------------------- TOTAL TAXES 600,721.29 8,689,213.80 14,519,607.00 59.8 LICENSES & PERMITS 01-000-41-00-4100 LIQUOR LICENSE 50.00 12,040.80 25,000.00 48.1 01-000-41-00-4101 OTHER LICENSES 10.00 1,419.50 4,500.00 31.5 01-000-41-00-4110 BUILDING PERMITS 153,203.00 1,000,486.00 1,100,000.00 90.9 --------------------------------------------------------------------------------- TOTAL LICENSES & PERMITS 153,263.00 1,013,946.30 1,129,500.00 89.7 CHARGES FOR SERVICES 01-000-42-00-4205 FILING FEES 305.00 5,839.40 25,000.00 23.3 01-000-42-00-4206 GARBAGE SURCHARGE (10.78) 135,814.77 192,780.00 70.4 01-000-42-00-4207 REFUSE STICKERS 0.00 0.00 0.00 0.0 01-000-42-00-4208 COLLECTION FEE - YBSD 0.00 0.00 34,000.00 0.0 01-000-42-00-4209 PLANNING FEE 0.00 0.00 39,899.00 0.0 01-000-42-00-4210 DEVELOPMENT FEES 64,425.00 996,589.48 1,175,000.00 84.8 P1 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 2 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.W0W FUND: GENERAL FUND FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ GENERAL REVENUES CHARGES FOR SERVICES 01-000-42-00-4211 ENGINEERING CAPITAL FEE 7,900.00 35,800.00 27,500.00 130.1 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 72,619.22 1,174,043.65 1,494,179.00 78.5 FINES & FORFEITS 01-000-43-00-4310 TRAFFIC FINES 5,769.46 56,467.76 73,500.00 76.8 01-000-43-00-4315 REIMBURSE POLICE TRAINING 0.00 11,805.06 0.00 100.0 01-000-43-00-4320 ORDINANCE FEES 1,685.00 2,380.00 2,500.00 95.2 --------------------------------------------------------------------------------- TOTAL FINES & FORFEITS 7,454.46 70,652.82 76,000.00 92.9 MISCELLANEOUS 01-000-44-00-4401 DARE DONATIONS 0.00 125.00 1,250.00 10.0 01-000-44-00-4402 ROB ROY CREEK HYDRAULIC STUDY 0.00 22,700.00 40,000.00 56.7 01-000-44-00-4410 REIMBURSEMENTS - OTHER GOVTS 0.00 0.00 0.00 0.0 01-000-44-00-4411 REIMBURSEMENTS-POLICE PROTECTN 121.40 2,025.60 3,000.00 67.5 01-000-44-00-4420 SIDWALK CONSTRUCTION 0.00 0.00 0.00 0.0 01-000-44-00-4490 MISCELLANEOUS INCOME 283.28 9,130.28 10,000.00 91.3 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 404.68 33,980.88 54,250.00 62.6 INTERGOVERNMENTAL 01-000-45-00-4504 TRAFFIC SIGNAL REVENUE 0.00 0.00 0.00 0.0 01-000-45-00-4505 COPS GRANT - VESTS 0.00 0.00 1,250.00 0.0 01-000-45-00-4510 COPS GRANT 0.00 0.00 0.00 0.0 01-000-45-00-4511 POLICE-STATE TOBACCO GRANT 0.00 0.00 1,250.00 0.0 01-000-45-00-4521 ICJIA BLOCK GRANT 0.00 0.00 0.00 0.0 01-000-45-00-4525 GRANTS 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL INTERGOVERNMENTAL 0.00 0.00 2,500.00 0.0 INTEREST 01-000-46-00-4600 INVESTMENT INCOME 12,812.18 95,293.39 20,000.00 476.4 --------------------------------------------------------------------------------- TOTAL INTEREST 12,812.18 95,293.39 20,000.00 476.4 P2 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 3 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ GENERAL TRANSFERS 01-000-49-00-4914 TRANSFER FROM WORKING CASH 0.00 0.00 0.00 0.0 01-000-49-00-4915 TRANSFER FROM WATER OPERATIONS 50,000.00 150,000.00 200,000.00 75.0 01-000-49-00-4920 TRANSFER FROM SEWER MAINT. 17,500.00 52,500.00 70,000.00 75.0 01-000-49-00-4925 TRANSFER FROM SAN. SEWER IMPR 25,000.00 125,000.00 200,000.00 62.5 01-000-49-00-4930 TRANSFER FROM WATER IMPROVE. 50,000.00 150,000.00 200,000.00 75.0 01-000-49-00-4935 TRANSFER FROM LAND CASH 0.00 0.00 42,000.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 142,500.00 477,500.00 712,000.00 67.0 TOTAL REVENUES: GENERAL 989,774.83 11,554,630.84 18,008,036.00 64.1 FINANCE & ADMINISTRATION EXPENSES PERSONNEL SERVICES 01-110-50-00-5100 SALARIES - MAYOR 0.00 3,775.00 7,500.00 50.3 01-110-50-00-5101 SALARIES - CITY CLERK 0.00 1,800.00 3, 600.00 50.0 01-110-50-00-5102 SALARIES - CITY TREASURER 0.00 1,800.00 3,600.00 50.0 01-110-50-00-5103 SALARIES - ALDERMAN 0.00 14,550.00 29,080.00 50.0 01-110-50-00-5104 SALARIES - LIQUOR COMMISSIONER 0.00 500.00 1,000.00 50.0 01-110-50-00-5105 SALARIES - CITY ATTORNEY 884.80 8,405.60 13,500.00 62.2 01-110-50-00-5106 SALARIES - ADMINISTRATIVE 42,052.44 417,246.53 557,237.00 74.8 01-110-50-00-5136 SALARIES - PART TIME 3,907.76 39,229.82 45,072.00 87.0 01-110-50-00-5137 SALARIES - OVERTIME 187.32 313.25 1,500.00 20.8 01-110-50-00-5199 MSI PAYROLL 0.00 0.00 0.00 0.0 01-110-50-00-5202 BENEFITS-UNEMPLOY. COMP. TAX 0.00 6, 633.00 10,000.00 66.3 01-110-50-00-5203 BENEFITS - HEALTH INSURANCE 59,396.38 534,106.79 825,000.00 64.7 01-110-50-00-5204 BENEFITS - GROUP LIFE INSURANC 3,145.38 10,737.62 20,000.00 53.6 01-110-50-00-5205 BENEFITS - DENTAL/VISION ASST 13,584.16 48,554.22 68,093.00 71.3 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 123,158.24 1,087,651.83 1,585,182.00 68.6 PROFESSIONAL SERVICES 01-110-61-00-5300 LEGAL SERVICES 2,700.00 41,081.67 35,000.00 117.3 01-110-61-00-5304 AUDIT FEES & EXPENSES 5,339.77 22,493.00 25,500.00 88.2 P3 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 4 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ FINANCE & ADMINISTRATION EXPENSES PROFESSIONAL SERVICES 01-110-61-00-5305 ACCOUNTING ASSISTANCE 0.00 0.00 5,000.00 0.0 01-110-61-00-5307 ACCOUNTING SYSTEM REVIEW 0.00 0.00 0.00 0.0 01-110-61-00-5308 GASB 34 0.00 9,847.02 15,000.00 65.6 01-110-61-00-5310 EMPLOYEE ASSISTANCE 0.00 1,306.50 4,500.00 29.0 01-110-61-00-5311 CODIFICATION 500.00 4, 938.00 5,000.00 98.7 01-110-61-00-5314 BUILDING INSPECTIONS 194,078.85 684, 676.30 880,000.00 77.8 01-110-61-00-5322 BONDING 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 202,618.62 764,342.49 970,000.00 78.7 CONTRACTUAL SERVICES 01-110-62-00-5400 INSURANCE-LIABILITY & PROPERTY 0.00 121,210.58 130,000.00 93.2 01-110-62-00-5401 CONTRACTUAL SERVICES 2,803.10 25,701.59 37,500.00 68.5 01-110-62-00-5403 SPECIAL CENSUS 20,039.91 59, 671.28 66,000.00 90.4 01-110-62-00-5404 CABLE CONSORTIUM FEE 0.00 19,528.55 30,000.00 65.0 01-110-62-00-5406 OFFICE CLEANING 550.00 4,400.00 7,500.00 58.6 01-110-62-00-5410 MAINTENANCE - OFFICE EQUIPMENT 0.00 189.50 500.00 37.9 01-110-62-00-5411 MAINTENANCE - COMPUTERS 0.00 1,331.64 2,000.00 66.5 01-110-62-00-5412 MAINTENANCE - PHOTOCOPIERS 1,616.00 13,014.30 19,392.00 67.1 01-110-62-00-5421 WEARING APPAREL 392.83 781.35 1,740.00 44.9 01-110-62-00-5427 FACADE PROGRAM 0.00 20,000.00 20,000.00 100.0 01-110-62-00-5436 TELEPHONE 1,464.52 9,193.97 21,000.00 43.7 01-110-62-00-5437 ACCTG SYSTEM SERVICE FEE 0.00 8,090.00 7,650.00 105.7 01-110-62-00-5438 CELLULAR TELEPHONE 148.74 1,217.82 2,300.00 52.9 01-110-62-00-5439 TELEPHONE SYSTEMS MAINTENANCE 0.00 1,411.20 11,000.00 12.8 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 27,015.10 285,741.78 356,582.00 80.1 PROFESSIONAL DEVELOPMENT 01-110-64-00-5600 DUES 154.73 3,464.73 4,000.00 86.6 01-110-64-00-5601 ILLINOIS MUNICIPAL LEAGUE DUES 0.00 781.00 690.00 113.1 01-110-64-00-5603 SUBSCRIPTIONS 0.00 230.00 500.00 46.0 01-110-64-00-5604 TRAINING & CONFERENCES 0.00 5,818.60 11,000.00 52.8 01-110-64-00-5605 TRAVEL/MEALS/LODGING 0.00 13, 634.06 17,000.00 80.2 01-110-64-00-5607 PUBLIC RELATIONS 193.00 12,267.23 18,000.00 68.1 P4 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 5 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ FINANCE & ADMINISTRATION EXPENSES PROFESSIONAL DEVELOPMENT 01-110-64-00-5608 SPONSORSHIPS 0.00 250.00 1,500.00 16.6 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 347.73 36,445.62 52, 690.00 69.1 OPERATIONS 01-110-65-00-5800 CONTINGENCIES 559.30 7,275.70 185,170.00 3.9 01-110-65-00-5801 FUND BALANCE RESERVE 0.00 0.00 0.00 0.0 01-110-65-00-5802 OFFICE SUPPLIES 609.58 9,847.78 12,000.00 82.0 01-110-65-00-5804 OPERATING SUPPLIES 1,066.83 5,203.81 13,000.00 40.0 01-110-65-00-5808 POSTAGE & SHIPPING 164.97 6,225.24 11,000.00 56.5 01-110-65-00-5809 PRINTING & COPYING 744.13 8,419.38 10,500.00 80.1 01-110-65-00-5810 PUBLISHING & ADVERTISING 456.78 2,073.47 3,500.00 59.2 01-110-65-00-5844 MARKETING - HOTEL TAX 1,492.85 11,838.30 20,000.00 59.1 --------------------------------------------------------------------------------- TOTAL OPERATIONS 5,094.44 50,883.68 255,170.00 19.9 RETIREMENT 01-110-72-00-6500 IMRF PARTICIPANTS 3,073.12 33,872.88 47,791.00 70.8 01-110-72-00-6501 SOCIAL SECURITY & MEDICARE 4,845.94 40,368.02 52,821.00 76.4 --------------------------------------------------------------------------------- TOTAL RETIREMENT 7,919.06 74,240.90 100,612.00 73.7 CAPITAL OUTLAY 01-110-75-00-7002 COMPUTER EQUIP & SOFTWARE 192.10 10,885.71 13,500.00 80.6 01-110-75-00-7003 OFFICE EQUIPMENT 499.98 1,341.90 3,000.00 44.7 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 692.08 12,227.61 16,500.00 74.1 OTHER OPERATING EXPENSES 01-110-78-00-9001 CITY TAX REBATE 0.00 70.09 1,200.00 5.8 01-110-78-00-9002 NICOR GAS 8,433.79 22,549.10 30,000.00 75.1 01-110-78-00-9003 SALES TAX REBATE 0.00 184,134.71 555,300.00 33.1 01-110-78-00-9004 MISCELLANEOUS 0.00 0.00 100.00 0.0 01-110-78-00-9005 MERIT/PAY EQUITY 0.00 0.00 51,104 .00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING EXPENSES 8,433.79 206,753.90 637,704.00 32.4 P5 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 6 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ FINANCE & ADMINISTRATION TRANSFERS 01-110-99-00-9923 TRANSFER TO LIBRARY 2,625.00 23,625.00 31,500.00 75.0 01-110-99-00-9925 TRANSFER TO SAN SEWER 37,500.00 112,500.00 150,000.00 75.0 01-110-99-00-9940 TRANSFER TO PARK & RECREATION 77,380.58 696,425.22 928,567.00 74.9 01-110-99-00-9941 TRANSFER TO PARK/REC CAPITAL 0.00 0.00 0.00 0.0 01-110-99-00-9945 TRANSFER TO MUNICIPAL BLDG 38,640.75 63,402.25 49,523.00 128.0 01-110-99-00-9965 TRANSFER TO DEBT SERVICE 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 156,146.33 895,952.47 1,159,590.00 77.2 TOTAL EXPENSES: FINANCE & ADMINISTRATION 531,425.39 3,414,240.28 5,134,030.00 66.5 ENGINEERING EXPENSES PERSONNEL SERVICES 01-150-50-00-5107 SALARIES-EMPLOYEES 19,529.75 186,172.75 248,919.00 74.7 01-150-50-00-5137 SALARIES-OVERTIME 0.00 0.00 1,000.00 0.0 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 19,529.75 186,172.75 249,919.00 74.4 CONTRACTUAL SERVICES 01-150-62-00-5401 CONTRACTUAL SERVICES 18,333.09 60,507.63 20,000.00 302.5 01-150-62-00-5402 GIS SYSTEM 0.00 0.00 5,000.00 0.0 01-150-62-00-5403 FEES 0.00 11000.00 1,000.00 100.0 01-150-62-00-5409 MAINTENANCE-VEHICLES 350.21 719.75 3,500.00 20.5 01-150-62-00-5410 MAINTENANCE-OFFICE EQUIP 0.00 215.98 1,000.00 21.5 01-150-62-00-5411 MAINTENANCE-COMPUTERS 0.00 186.45 2,500.00 7.4 01-150-62-00-5421 WEARING APPAREL 254.00 254.00 1,100.00 23.0 01-150-62-00-5438 CELLULAR TELEPHONE 223.11 1, 600.27 2,800.00 57.1 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 19,160.41 64,484.08 36,900.00 174.7 PROFESSIONAL DEVELOPMENT 01-150-64-00-5600 DUES 0.00 293.00 300.00 97.6 01-150-64-00-5604 TRAINING & CONFERENCES 0.00 0.00 6,000.00 0.0 P6 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 7 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ ENGINEERING EXPENSES PROFESSIONAL DEVELOPMENT 01-150-64-00-5605 TRAVEL EXPENSE 0.00 956.40 1,000.00 95.6 01-150-64-00-5616 BOOKS & PUBLICATIONS 0.00 0.00 200.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 0.00 1,249.40 7,500.00 16.6 OPERATIONS 01-150-65-00-5801 ENGINEERING SUPPLIES 23.80 787.86 3,000.00 26.2 01-150-65-00-5802 OFFICE SUPPLIES 25.25 1,106.62 2,500.00 44.2 01-150-65-00-5809 PRINTING & COPYING 6.00 423.16 2,000.00 21.1 01-150-65-00-5814 STORM WATER SOFTWARE/TRAINING 0.00 0.00 0.00 0.0 01-150-65-00-5815 ROB ROY CREEK HYDRAULIC STUDY 0.00 0.00 0.00 0.0 01-150-65-00-5820 PICK UP TRUCK 0.00 0.00 27,500.00 0.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS 55.05 2,317.64 35,000.00 6.6 RETIREMENT 01-150-72-00-6500 IMRF PARTICIPANTS 1,589.74 15,183.86 20,343.00 74.6 01-150-72-00-6501 SOCIAL SECURITY & MEDICARE 1,461.38 13, 959.60 19,120.00 73.0 --------------------------------------------------------------------------------- TOTAL RETIREMENT 3,051.12 29,143.46 39,463.00 73.8 CAPITAL OUTLAY 01-150-75-00-7002 COMPUTER EQUIPMENT & SOFTWARE 1,080.00 3,758.79 3,850.00 97.6 01-150-75-00-7003 OFFICE EQUIPMENT 0.00 69.98 500.00 13.9 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 1,080.00 3,828.77 4,350.00 88.0 TOTAL EXPENSES: ENGINEERING 42,876.33 287,196.10 373,132.00 76.9 PUBLIC SAFETY/POLICE DEPT. EXPENSES PERSONNEL SERVICES 01-210-50-00-5107 SALARIES - EMPLOYEES 53,161.62 462,977.02 608,512.00 76.0 P7 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 8 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PUBLIC SAFETY/POLICE DEPT. EXPENSES PERSONNEL SERVICES 01-210-50-00-5131 SALARIES-CHIEF/LIEUTENANT/SERG 44,420.42 410,206.27 522,284.00 78.5 01-210-50-00-5133 SALARIES - COPS 7,912.63 76,796.26 150,158.00 51.1 01-210-50-00-5134 SALARIES - CROSSING GUARD 1,266.00 11,183.25 19,000.00 58.8 01-210-50-00-5135 SALARIES - POLICE CLERKS 8,148.33 77,409.11 103,626.00 74.7 01-210-50-00-5136 SALARIES - PART TIME 2,695.98 28,454.19 30,000.00 94.8 01-210-50-00-5137 SALARIES - OVERTIME 4,486.19 35,448.39 50,000.00 70.8 01-210-50-00-5200 CADET PROGRAM 1,104.00 6,726.67 10,000.00 67.2 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 123,195.17 1,109,201.16 1,493,580.00 74.2 PROFESSIONAL SERVICES 01-210-61-00-5300 LEGAL SERVICES 2,178.75 9,590.37 20,000.00 47.9 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 2,178.75 9,590.37 20,000.00 47.9 CONTRACTUAL SERVICES 01-210-62-00-5408 MAINTENANCE - EQUIPMENT 1,132.37 6,470.10 8,000.00 80.8 01-210-62-00-5409 MAINTENANCE - VEHICLES 1,287.76 20,380.12 21,000.00 97.0 01-210-62-00-5410 MAINT-OFFICE EQUIPMENT 403.00 2,247.00 2,500.00 89.8 01-210-62-00-5411 MAINTENANCE - COMPUTERS 595.89 1,568.24 2,100.00 74.6 01-210-62-00-5414 WEATHER WARNING SIREN MAINT 0.00 3,309.60 8,000.00 41.3 01-210-62-00-5421 WEARING APPAREL 610.24 9,349.44 27,000.00 34.6 01-210-62-00-5422 COPS GRANT IV - VESTS 2,209.30 2,634.30 2,500.00 105.3 01-210-62-00-5423 CLASY GRANT 0.00 0.00 1,000.00 0.0 01-210-62-00-5424 ICJIA-JUVENILE 0.00 0.00 0.00 0.0 01-210-62-00-5427 ICJIA BLOCK GRANT 0.00 0.00 0.00 0.0 01-210-62-00-5429 PSYCHOLOGICAL TESTING 0.00 420.00 1,500.00 26.0 01-210-62-00-5430 HEALTH SERVICES 0.00 1,117.08 3,000.00 37.2 01-210-62-00-5431 LABORATORY FEES 0.00 0.00 1,000.00 0.0 01-210-62-00-5436 TELEPHONE 1,694.02 10,830.85 20,000.00 54.1 01-210-62-00-5438 CELLULAR TELEPHONE 1,070.94 7,883.27 14,000.00 56.3 01-210-62-00-5440 PAGERS 0.00 0.00 0.00 0.0 01-210-62-00-5441 MTD-ALERTS FEE 0.00 4,620.00 2,400.00 192.5 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 9,003.52 70,830.00 114,000.00 62.1 P8 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 9 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PUBLIC SAFETY/POLICE DEPT. PROFESSIONAL DEVELOPMENT 01-210-64-00-5600 DUES 815.00 1,346.20 2,250.00 59.8 01-210-64-00-5603 SUBSCRIPTIONS 31.20 183.15 300.00 61.0 01-210-64-00-5604 TRAINING & CONFERENCE 975.00 13,222.25 19,000.00 69.5 01-210-64-00-5605 TRAVEL EXPENSES 234.65 9,244.38 9,000.00 102.7 01-210-64-00-5606 COMMUNITY RELATIONS 232.12 1, 989.84 5,500.00 36.1 01-210-64-00-5607 POLICE COMMISSION 130.79 5,223.07 23,000.00 22.7 01-210-64-00-5608 TUITION REIMBURSEMENT 2,250.25 4,332.37 14,000.00 30.9 01-210-64-00-5609 POLICE RECRUIT ACADEMY 0.00 0.00 3,500.00 0.0 01-210-64-00-5610 GUN RANGE FEES 0.00 0.00 625.00 0.0 01-210-64-00-5611 SRT FEE 0.00 0.00 2,000.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 4,669.01 35,541.26 79,175.00 44.8 OPERATIONS 01-210-65-00-5800 CONTINGENCIES 0.00 0.00 0.00 0.0 01-210-65-00-5802 OFFICE SUPPLIES 316.82 3, 997.42 6,500.00 61.4 01-210-65-00-5804 OPERATING SUPPLIES 1,500.99 6,770.28 16,000.00 54.8 .01-210-65-00-5808 POSTAGE & SHIPPING 30.40 1,038.57 3,000.00 34.6 01-210-65-00-5809 PRINTING & COPYING 256.40 3,423.43 4,500.00 76.0 01-210-65-00-5810 PUBLISHING & ADVERTISING 39.95 255.23 1,000.00 25.5 01-210-65-00-5812 GASOLINE 3,641.75 32,829.16 36,300.00 90.4 01-210-65-00-5813 AMMUNITION 0.00 0.00 5,000.00 0.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS 5,786.31 50,314.09 72,300.00 69.5 RETIREMENT 01-210-72-00-6500 IMRF PARTICIPANTS 677.57 6,334.43 8,732.00 72.5 01-210-72-00-6501 SOCIAL SECURITY & MEDICARE 9,389.65 84, 661.76 115,170.00 73.5 01-210-72-00-6502 POLICE PENSION 0.00 231,123.76 231,686.00 99.7 --------------------------------------------------------------------------------- TOTAL RETIREMENT 10,067.22 322,119.95 355,588.00 90.5 CAPITAL OUTLAY 01-210-75-00-7002 COMPUTER EQUIP & SOFTWARE 159.74 2,038.12 8,500.00 23.9 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 159.74 2,038.12 8,500.00 23.9 P9 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 10 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PUBLIC SAFETY/POLICE DEPT. OTHER OPERATING EXPENSES 01-210-78-00-9004 BIKE PATROL 0.00 1,422.51 2,000.00 71.1 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING EXPENSES 0.00 1,422.51 2,000.00 71.1 TRANSFERS 01-210-99-00-9910 TRANSFER TO PD CAPITAL FUND 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 0.00 0.0 TOTAL EXPENSES: PUBLIC SAFETY/POLICE DEPT. 155,059.72 1,601,057.46 2,145,143.00 74.6 PLANNING & DEVELOPMENT EXPENSES PERSONNEL SERVICES 01-220-50-00-5107 EMPLOYEE SALARIES 0.00 7,665.00 131,086.00 5.8 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 0.00 7,665.00 131,086.00 5.8 PROFESSIONAL SERVICES 01-220-61-00-5300 LEGAL SERVICES 3,675.00 29,406.18 20,000.00 147.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 3,675.00 29,406.18 20,000.00 147.0 CONTRACTUAL SERVICES 01-220-62-00-5401 CONTRACTUAL SERVICES 2,852.26 31,802.65 50,000.00 63.6 01-220-62-00-5430 PLANNING CONSULTANT (6,357.50) 5,807.92 20,000.00 29.0 01-220-62-00-5432 ECONOMIC DEVELOPMENT 0.00 45,000.00 45,000.00 100.0 01-220-62-00-5438 CELULAR TELEPHONE 0.00 0.00 1,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES (3,505.24) 82,610.57 116,000.00 71.2 PROFESSIONAL DEVELOPMENT 01-220-64-00-5600 DUES 0.00 100.00 200.00 50.0 01-220-64-00-5604 TRAINING & CONFERENCES 0.00 0.00 6,000.00 0.0 P10 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 11 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PLANNING & DEVELOPMENT EXPENSES PROFESSIONAL DEVELOPMENT 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 425.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 0.00 100.00 9,625.00 1.0 OPERATIONS 01-220-65-00-5804 OPERATING SUPPLIES 121.21 995.23 5,000.00 19.9 01-220-65-00-5809 PRINTING & COPYING 0.00 332.75 2,500.00 13.3 01-220-65-00-5810 PUBLISHING & ADVERTISING 0.00 3,251.17 10,000.00 32.5 01-220-65-00-5814 BOOKS & MAPS 0.00 1,042.00 3,000.00 34 .7 --------------------------------------------------------------------------------- TOTAL OPERATIONS 121.21 5,621.15 20,500.00 27.4 RETIREMENT 01-220-72-00-6500 IMRF PARTICIPANTS 0.00 0.00 9,672.00 0.0 01-220-72-00-6501 SOCIAL SECURITY & MEDICARE 0.00 0.00 7,724.00 0.0 --------------------------------------------------------------------------------- TOTAL RETIREMENT 0.00 0.00 17,396.00 0.0 CAPITAL OUTLAY 01-220-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 19.95 7,500.00 0.2 01-220-75-00-7003 OFFICE EQUIPMENT 0.00 235.96 2,500.00 9.4 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 255.91 10,000.00 2.5 TOTAL EXPENSES: PLANNING & DEVELOPMENT 290.97 125, 658.81 324,607.00 38.7 STREETS EXPENSES PERSONNEL SERVICES 01-410-50-00-5107 SALARIES - EMPLOYEE 12,904.23 128,586.07 182,345.00 70.5 01-410-50-00-5136 SALARIES - PART TIME 0.00 1,484.00 11,000.00 13.4 01-410-50-00-5137 SALARIES - OVERTIME 3,317.46 13,850.15 20,400.00 67.8 P11 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 12 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.W0W FUND: GENERAL FUND FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 16,221.69 143,920.22 213,745.00 67.3 PROFESSIONAL SERVICES 01-410-61-00-5313 ENGINEERING - IN TOWN RD PROG 0.00 101,814.23 215,210.00 '47.3 01-410-61-00-5314 INSPECTIONS & LICENSES 20.00 318.00 200.00 159.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 20.00 102,132.23 215,410.00 47.4 CONTRACTUAL SERVICES 01-410-62-00-5401 CONTRACTUAL SERVICES 0.00 548.32 2,000.00 27.4 01-410-62-00-5408 MAINTENANCE-EQUIPMENT 3,352.57 7,143.51 9,000.00 79.3 01-410-62-00-5409 MAINTENANCE-VEHICLES 1,127.62 9,204.93 11,550.00 79.6 01-410-62-00-5414 MAINTENANCE-TRAFFIC SIGNALS 264.34 9,750.98 24,000.00 40.6 01-410-62-00-5415 MAINTENANCE-STREET LIGHTS 3,591.13 17,496.51 25,000.00 69.9 01-410-62-00-5420 MAINTENANCE-STORM SEWER 0.00 0.00 10,000.00 0.0 01-410-62-00-5421 WEARING APPAREL 1,002.01 2,825.62 6,000.00 47.0 01-410-62-00-5434 RENTAL-EQUIPMENT 0.00 0.00 2,000.00 0.0 01-410-62-00-5435 ELECTRICITY 3,856.91 41,638.22 51,800.00 80.3 01-410-62-00-5438 CELLULAR TELEPHONE 223.11 1,807.69 3,300.00 54.7 01-410-62-00-5440 STREET LIGHTING 0.00 686.50 6,000.00 11.4 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 13,417.69 91,102.28 150,650.00 60.4 PROFESSIONAL DEVELOPMENT 01-410-64-00-5604 TRAINING & CONFERENCES 0.00 2,112.55 5,000.00 42.2 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 0.00 2,112.55 5,000.00 42.2 OPERATIONS 01-410-65-00-5421 GIS SYSTEM 0.00 0.00 0.00 0.0 01-410-65-00-5800 CONTINGENCIES 0.00 0.00 0.00 0.0 01-410-65-00-5804 OPERATING SUPPLIES 2,006.69 15,085.46 25,800.00 58.4 01-410-65-00-5812 GASOLINE 1,526.92 21,237.33 24,000.00 88.4 01-410-65-00-5815 HAND TOOLS 766.74 766.74 2,500.00 30.6 01-410-65-00-5817 GRAVEL 0.00 719.52 6,500.00 11.0 --------------------------------------------------------------------------------- TOTAL OPERATIONS 4,300.35 37,809.05 58,800.00 64.3 P12 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 13 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ STREETS RETIREMENT 01-410-72-00-6500 IMRF PARTICIPANTS 1,320.41 11,594.16 16,783.00 69.0 01-410-72-00 76501 SOCIAL SECURITY & MEDICARE 1,239.13 11,008.31 16, 616.00 66.2 --------------------------------------------------------------------------------- TOTAL RETIREMENT 2,559.54 22, 602.47 33,399.00 67.6 CAPITAL OUTLAY 01-410-75-00-5418 MOSQUITO CONTROL 0.00 20,295.60 28,950.00 70.1 01-410-75-00-5419 MAINT SUPPLIES - STREET 0.00 0.00 0.00 0.0 01-410-75-00-7004 SAFETY EQUIPMENT 0.00 669.21 1,000.00 66.9 01-410-75-00-7099 GRANDE RESERVE PERIMETER ROADS 557.25 316,155.95 4,000,000.00 7.9 01-410-75-00-7100 STREET REHAB PROJECTS 0.00 35, 646.99 40,000.00 89.1 01-410-75-00-7101 IN TOWN ROAD PROGRAM 79,725.11 1,474,253.14 2,345,000.00 62.8 01-410-75-00-7102 TREE & STUMP REMOVAL 0.00 9,510.00 30,000.00 31.7 01-410-75-00-7103 SIDEWALK CONSTRUCTION 0.00 0.00 30,000.00 0.0 01-410-75-00-7104 FOX HILL SSA EXPENSES 0.00 6,642.00 18,000.00 36.9 01-410-75-00-7105 IN-TOWN ROAD PRORAM-RESERVE 0.00 0.00 1,575,000.00 0.0 01-410-75-00-7106 ROAD CONTRIBUTION FUND PROJ 0.00 11,042.71 10,000.00 110.4 01-410-75-00-7107 ROAD CONTRIBUTION FUND-RESERVE 0.00 0.00 490,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 80,282.36 1,874,215.60 8,567,950.00 21.8 TRANSFERS 01-410-99-00-9930 TRANSFER TO WATER IMPROVEMENT 53,750.00 161,250.00 215,000.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 53,750.00 161,250.00 215,000.00 75.0 TOTAL EXPENSES: STREETS 170,551.63 2,435,144.40 9,459,954.00 25.7 HEALTH & SANITATION EXPENSES CONTRACTUAL SERVICES 01-540-62-00-5442 GARBAGE SERVICES 49, 664.24 382,586.08 565,670.00 67.6 01-540-62-00-5443 LEAF PICKUP 1,800.00 7,050.00 5,500.00 128.1 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 51,464.24 389,636.08 571,170.00 68.2 P13 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 14 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TOTAL EXPENSES: HEALTH & SANITATION 51,464.24 389,636.08 571,170.00 68.2 TOTAL FUND REVENUES 989,774.83 11,554,630.84 18,008,036.00 64.1 TOTAL FUND EXPENSES 951,668.28 8,252,933.13 18,008,036.00 45.8 FUND SURPLUS (DEFICIT) 38,106.55 3,301,697.71 0.00 100.0 P14 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 15 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: MOTOR FUEL TAX FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY 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 475,000.00 0.0 15-000-40-00-4060 MOTOR FUEL TAX ALLOTMENTS 21,155.00 203,633.88 268,304.00 75.8 15-000-40-00-4065 IDOT TRUCK ACCESS GRANT 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TAXES 21,155.00 203,633.88 743,304.00 27.3 MISCELLANEOUS 15-000-44-00-4490 MISCELLANEOUS INCOME 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 0.00 0.00 0.00 0.0 INTEREST 15-000-46-00-4600 INVESTMENT INCOME 1,493.14 10,824.72 5,000.00 216.4 --------------------------------------------------------------------------------- TOTAL INTEREST 1,493.14 10,824.72 5,000.00 216.4 TOTAL REVENUES: 22, 648.14 214,458.60 748,304.00 28.6 EXPENSES OPERATIONS 15-000-65-00-5800 CONTINGENCY 0.00 11,936.00 145,250.00 8.2 15-000-65-00-5818 SALT 18,741.78 38,321.91 51,800.00 73.9 --------------------------------------------------------------------------------- TOTAL OPERATIONS 18,741.78 50,257.91 197,050.00 25.5 CAPITAL OUTLAY 15-000-75-00-7007 SIGNS 0.00 7,049.84 9,990.00 70.5 15-000-75-00-7008 CRACK FILLING 0.00 28,797.41 30,000.00 95.9 15-000-75-00-7107 CONSTRUCTION ENGINEERING 0.00 45,205.34 150,000.00 30.1 15-000-75-00-7108 VAN EMMON STREET 0.00 0.00 0.00 0.0 15-000-75-00-7110 COLD PATCH 0.00 197.73 9, 600.00 2.0 15-000-75-00-7111 HOT PATCH 0.00 1,830.18 8,000.00 22.8 15-000-75-00-7112 FAXON ROAD ENGINEERING 0.00 0.00 1,000.00 0.0 15-000-75-00-7113 COUNTRYSIDE PKWY CONSTRUCTION 0.00 0.00 300,000.00 0.0 P15 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 16 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: MOTOR FUEL TAX FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 83,080.50 508,590.00 16.3 TRANSFERS 15-000-99-00-9960 TRANSFER TO FOX IND FUND 0.00 31,189.68 42,664.00 73.1 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 31,189.68 42, 664.00 73.1 TOTAL EXPENSES: 18,741.78 164,528.09 748,304.00 21.9 TOTAL FUND REVENUES 22,648.14 214,458.60 748,304.00 28.6 TOTAL FUND EXPENSES 18,741.78 164,528.09 748,304.00 21.9 FUND SURPLUS (DEFICIT) 3,906.36 49,930.51 0.00 100.0 P16 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 17 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: MUNICIPAL BUILDLING FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY 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 45,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 45,000.00 0.0 CHARGES FOR SERVICES 16-000-42-00-4211 DEVELOPMENT FEES-BUILDING 13,200.00 61,200.00 105,000.00 58.2 16-000-42-00-4215 BEECHER RENTAL FEE 1,000.00 4,000.00 0.00 100.0 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 14,200.00 65,200.00 105,000.00 62.0 TRANSFERS 16-000-49-00-4901 TRANSFER FROM GENERAL FUND 38, 640.75 63,402.25 49,523.00 128.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 38,640.75 63,402.25 49,523.00 128.0 TOTAL REVENUES: 52,840.75 128, 602.25 199,523.00 64.4 EXPENSES CONTRACTUAL SERVICES 16-000-62-00-5416 MAINT-GENERAL BLDG & GROUNDS 0.00 225.00 8,000.00 2.8 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 0.00 225.00 8,000.00 2.8 CAPITAL OUTLAY 16-000-75-00-7008 ENTRY WAY SIGNS 0.00 0.00 3,600.00 0.0 16-000-75-00-7200 BLDG IMPROV- BEEHCER/RIVFRNT 363.03 6,463.51 13,000.00 49.7 16-000-75-00-7202 BLDG IMPROVEMENTS-CITY HALL 0.00 0.00 0.00 0.0 16-000-75-00-7203 BLDG IMPROVEMENTS-PUBLIC WORKS 0.00 9,072.40 10,000.00 90.7 16-000-75-00-7204 BLDG MAINT - CITY HALL 439.86 9,613.61 10,000.00 96.1 16-000-75-00-7205 BLDG IMPROVEMENTS-LIBRARY 325.00 2,548.20 4,000.00 63.7 16-000-75-00-7206 LANDSCAPING-PUBLIC BUILDINGS 0.00 0.00 2,000.00 0.0 16-000-75-00-7209 BEECHER PARKING LOT 0.00 41,119.60 45,000.00 91.3 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 1,127.89 68,817.32 87,600.00 78.5 P17 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 18 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: MUNICIPAL BUILDLING FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ OTHER 16-000-78-00-9009 RESERVE 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 0.00 0.0 TRANSFERS 16-000-99-00-9965 TRANSFER TO DEBT SERVICE 25,980.75 77,942.25 103,923.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 25,980.75 77, 942.25 103,923.00 75.0 TOTAL EXPENSES: 27,108.64 146,984.57 199,523.00 73.6 TOTAL FUND REVENUES 52,840.75 128, 602.25 199,523.00 64.4 TOTAL FUND EXPENSES 27,108.64 146,984.57 199,523.00 73.6 FUND SURPLUS (DEFICIT) 25,732.11 (18,382.32) 0.00 100.0 P18 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 19 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.W0W FUND: POLICE EQUIPMENT CAPITAL FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY 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 70,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 70,000.00 0.0 CHARGES FOR SERVICES 20-000-42-00-4212 DEV FEES - POLICE 28,050.00 138, 150.00 146,250.00 94.4 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 28,050.00 138,150.00 146,250.00 94.4 MISCELLANEOUS 20-000-44-00-4402 K-9 DONATIONS 0.00 200.00 1,000.00 20.0 20-000-44-00-4403 IN CAR VIDEO DONATIONS 746.00 4,016.00 2,200.00 182.5 20-000-44-00-4404 DONATIONS 0.00 1,500.00 500.00 300.0 20-000-44-00-4405 WEATHER WARNING SIREN 0.00 29,230.50 30,000.00 97.4 20-000-44-00-4431 SALE OF POLICE SQUADS 0.00 0.00 500.00 0.0 20-000-44-00-4489 RICP DISASTER PLAN GRANT 0.00 9,990.27 0.00 100.0 20-000-44-00-4490 MISCELLANEOUS INCOME 0.00 24,609.27 0.00 100.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 746.00 69,546.04 34,200.00 203.3 OTHER OPERATING RECEIPTS 20-000-48-00-4800 LOAN PROCEEDS 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING RECEIPTS 0.00 0.00 0.00 0.0 TRANSFERS 20-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 0.00 0.0 TOTAL REVENUES: 28,796.00 207,696.04 250,450.00 82.9 EXPENSES WEAPONS P19 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 20 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: POLICE EQUIPMENT CAPITAL FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES WEAPONS 20-000-65-00-5811 LETHAL/NON-LETHAL WEAPONS 0.00 1,962.00 6,825.00 28.7 --------------------------------------------------------------------------------- TOTAL WEAPONS 0.00 1,962.00 6,825.00 28.7 CAPITAL OUTLAY 20-000-75-00-7001 EQUIPMENT 0.00 0.00 0.00 0.0 20-000-75-00-7002 K-9 EQUIPMENT 0.00 0.00 1,000.00 0.0 20-000-75-00-7003 EXPEDITION AND ACCESSORIES 0.00 0.00 0.00 0.0 20-000-75-00-7005 VEHICLES 0.00 72,384.64 74,000.00 97.8 20-000-75-00-7006 CAR BUILD OUT 1,533.11 6,383.27 26,000.00 24.5 20-000-75-00-7008 NEW WEATHER WARNING SIRENS 0.00 0.00 60,000.00 0.0 20-000-75-00-7009 RESERVE-WEATHER WARNING SIREN 0.00 0.00 40,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 1,533.11 78,767.91 201,000.00 39.1 OTHER 20-000-78-00-9009 RESERVE 0.00 10,587.51 18,515.00 57.1 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 10,587.51 18,515.00 57.1 TRANSFERS 20-000-99-00-9965 TRANSFER TO DEBT SERV FUND 6,027.50 18,082.50 24,110.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 6,027.50 18,082.50 24,110.00 75.0 TOTAL EXPENSES: 7,560.61 109,399.92 250,450.00 43.6 TOTAL FUND REVENUES 28,796.00 207,696.04 250,450.00 82.9 TOTAL FUND EXPENSES 7,560.61 109,399.92 250,450.00 43.6 FUND SURPLUS (DEFICIT) 21,235.39 98,296.12 0.00 100.0 P20 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 21 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PUBLIC WORKS EQUIP CAPITAL FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY 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 234,174.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 234,174.00 0.0 CHARGES FOR SERVICES 21-000-42-00-4213 DEVELOPMENT FEES-PUBLIC WORKS 68,350.00 341,950.00 383,750.00 89.1 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 68,350.00 341,950.00 383,750.00 89.1 MISCELLANEOUS 21-000-44-00-4430 SALE OF EQUIPMENT 0.00 34,113.84 32,000.00 106.6 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 0.00 34,113.84 32,000.00 106.6 TRANSFERS 21-000-49-00-4915 TRANSFER FROM WATER FUND 12,500.00 37,500.00 50,000.00 75.0 21-000-49-00-4920 TRANSFER FROM SEWER FUND 7,500.00 22,500.00 30,000.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 20,000.00 60,000.00 80,000.00 75.0 TOTAL REVENUES: 88,350.00 436,063.84 729,924.00 59.7 EXPENSES CAPITAL OUTLAY 21-000-75-00-7001 EQUIMPENT 0.00 0.00 85,000.00 0.0 21-000-75-00-7005 VEHICLES 0.00 184,968.00 375,000.00 49.3 21-000-75-00-7006 F150 PICK UPS 0.00 0.00 0.00 0.0 21-000-75-00-7007 5 YARD DUMP 0.00 0.00 0.00 0.0 21-000-75-00-7008 WATER DEPT PICK UP 0.00 0.00 0.00 0.0 21-000-75-00-7009 1 TON DUMP 0.00 0.00 0.00 0.0 21-000-75-00-7010 POWER BREAKER 0.00 0.00 0.00 0.0 21-000-75-00-7015 SKIDSTEER UPGRADE 0.00 3,951.86 3,500.00 112.9 21-000-75-00-7100 BOB CAT EXCHANGE 0.00 0.00 0.00 0.0 21-000-75-00-7107 TRUCK ACCESSORIES 0.00 9, 602.73 14,000.00 68.5 P21 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 22 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PUBLIC WORKS EQUIP CAPITAL FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES CAPITAL OUTLAY 21-000-75-00-7108 SKIDSTEE GRADER 0.00 0.00 0.00 0.0 21-000-75-00-7109 MOWER 0.00 0.00 0.00 0.0 21-000-75-00-7110 LEAF CHOPPER/VAC 0.00 0.00 0.00 0.0 21-000-75-00-7115 SALT DOME 0.00 0.00 175,000.00 0.0 21-000-75-00-7120 STREET SWEEPER 0.00 0.00 0.00 0.0 21-000-75-00-7130 PUBLIC WORKS BLDG ADDITION 0.00 0.00 77,424.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 198,522.59 729,924.00 27.1 OTHER 21-000-78-00-9009 RESERVE 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 0.00 0.0 TOTAL EXPENSES: 0.00 198,522.59 729,924.00 27.1 TOTAL FUND REVENUES 88,350.00 436,063.84 729,924.00 59.7 TOTAL FUND EXPENSES 0.00 198,522.59 729,924.00 27.1 FUND SURPLUS (DEFICIT) 88,350.00 237,541.25 0.00 100.0 P22 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 23 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PARKS & REC EQUIP CAPITAL FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY 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 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 0.00 0.0 CHARGES FOR SERVICES 22-000-42-00-4216 PARKS CAPITAL FEE 9,750.00 13,950.00 13,750.00 101.4 22-000-42-00-4217 PARKS CAPITAL - DONATIONS 0.00 7,000.00 0.00 100.0 22-000-42-00-4218 IL CLEAN ENERGY GRANT 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 9,750.00 20,950.00 13,750.00 152.3 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 FRM GENERAL FUND 0.00 0.00 0.00 0.0 22-000-49-00-4935 TRANSFER FROM LAND CASH 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 0.00 0.0 TOTAL REVENUES: 9,750.00 20,950.00 23,750.00 88.2 EXPENSES OTHER 22-000-65-00-5800 RESERVE 0.00 0.00 1,650.00 0.0 22-000-65-00-5805 BEECHER LIGHTING 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 1,650.00 0.0 PARKS EXPENSES P23 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 24 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PARKS & REC EQUIP CAPITAL FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PARKS CAPITAL OUTLAY 22-610-75-00-7005 VEHICLES 0.00 0.00 0.00 0.0 22-610-75-00-7006 PICK UP TRUCK 0.00 0.00 0.00 0.0 22-610-75-00-7007 SOCCER GOALS 12' REPLACEMENT 0.00 0.00 0.00 0.0 22-610-75-00-7008 SOCCER GOALS 9' 0.00 0.00 0.00 0.0 22-610-75-00-7009 COMPUTER WORKSTATIONS 0.00 0.00 9,000.00 0.0 22-610-75-00-7010 TOWN SQUARE FOUNTAIN 0.00 0.00 0.00 0.0 22-610-75-00-7011 UTILITY TRAILER 0.00 0.00 0.00 0.0 22-610-75-00-7012 PLAYGROUNDS 0.00 630.00 0.00 (100.0) 22-610-75-00-7013 PLAYGROUND REPAIRS 0.00 0.00 2,500.00 0.0 22-610-75-00-7014 SIGN REPLACEMENTS 0.00 0.00 4,000.00 0.0 22-610-75-00-7015 MOWER 0.00 0.00 0.00 0.0 22-610-75-00-7016 BEECHER PATHWAY 0.00 0.00 0.00 0.0 22-610-75-00-7017 RECREATION EQUIPMENT 0.00 6,174.76 6,600.00 93.5 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 6,804.76 22,100.00 30.7 TOTAL EXPENSES: PARKS 0.00 6,804.76 22,100.00 30.7 TOTAL FUND REVENUES 9,750.00 20,950.00 23,750.00 88.2 TOTAL FUND EXPENSES 0.00 6,804.76 23,750.00 28.6 FUND SURPLUS (DEFICIT) 9,750.00 14,145.24 0.00 100.0 P24 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 25 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: SANITARY SEWER IMPROVEMENT FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY 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,720,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 3,720,000.00 0.0 CHARGES FOR SERVICES 37-000-42-00-4220 CONNECTION FEES 179,000.00 916, 600.00 1,260,000.00 72.7 37-000-42-00-4221 RIVER CROSSING FEES 136.50 5,619.00 20,000.00 28.0 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 179,136.50 922,219.00 1,280,000.00 72.0 INTEREST 37-000-46-00-4600 INVESTMENT INCOME 44,366.73 135,038.77 35,000.00 385.8 --------------------------------------------------------------------------------- TOTAL INTEREST 44,366.73 135,038.77 35,000.00 385.8 OTHER OPERATING RECEIPTS 37-000-48-00-4800 COMED/HYDRAULIC DEBT CERT. 0.00 0.00 0.00 0.0 37-000-48-00-4801 BRUELL ST. DEBT CERT. PROCEEDS 0.00 0.00 0.00 0.0 37-000-48-00-4802 COUNTRYSIDE INTERCEPT. ALT REV 0.00 0.00 0.00 0.0 37-000-48-00-4803 ROB ROY CREEK REVENUE 0.00 12,150,312.50 10,000,000.00 121.5 37-000-48-00-4804 SOUTHWEST SVC AREA INTERCEPTOR 73,302.21 73,302.21 5,500,000.00 1.3 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING RECEIPTS 73,302.21 12,223,614.71 15,500,000.00 78.8 TRANSFERS 37-000-49-00-4901 TRANSFER FROM GENERAL FUND 37,500.00 112,500.00 150,000.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 37,500.00 112,500.00 150,000.00 75.0 TOTAL REVENUES: 334,305.44 13,393,372.48 20,685,000.00 64.7 EXPENSES CONTRACTUAL SERVICES 37-000-62-00-5401 CONTRACTURAL/PROFESSIONAL SERV (374.50) 2,637.50 50,000.00 5.2 P25 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 26 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: SANITARY SEWER IMPROVEMENT FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES CONTRACTUAL SERVICES 37-000-62-00-5402 ENG/LGL/CONTINGNCY-COUNTRYSIDE 35,309.97 89,045.71 300,000.00 29.6 37-000-62-00-5405 ENG/LGL/CONTINGENCY-BRUELL ST. 8,835.51 93,220.83 70,000.00 133.1 37-000-62-00-5406 ENG/LGL/CONTINGENCY-HYDRAULIC 0.00 1,940.43 0.00 (100.0) 37-000-62-00-5407 ENG/LGL/CONTING ROB ROY CREEK 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 43,770.98 186,844.47 420,000.00 44.4 OTHER 37-000-65-00-5421 GIS SYSTEM 0.00 0.00 10,000.00 0.0 37-000-65-00-5800 CONTINGENCY 0.00 0.00 86,952.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 96,952.00 0.0 DEBT SERVICE 37-000-66-00-6012 DEBT ISSUANCE COSTS 130,750.00 216,424.50 0.00 (100.0) --------------------------------------------------------------------------------- TOTAL DEBT SERVICE 130,750.00 216,424.50 0.00 (100.0) CAPITAL OUTLAY 37-000-75-00-7109 CONTRACTUAL/PROFESSIONAL SVC 0.00 0.00 0.00 0.0 37-000-75-00-7502 HYDRAULIC INTERCEPTOR 0.00 0.00 0.00 0.0 37-000-75-00-7503 COUNTRYSIDE INTERCEPTOR 153,187.20 1,486,031.33 2,850,000.00 52.1 37-000-75-00-7504 BRUELL STREET LIFT STATION 164,416.57 797, 663.40 500,000.00 159.5 37-000-75-00-7505 ROB ROY CREEK SANITARY 407,836.97 2,545,213.98 10,000,000.00 25.4 37-000-75-00-7506 SOUTHWEST SVC AREA INTERCEPTOR 0.00 96,287.50 5,500,000.00 1.7 37-000-75-00-7507 SANITARY JETTER TRUCK 0.00 0.00 0.00 0.0 37-000-75-00-7508 MANHOLE REHAB PROJECT 6,456.00 6,456.00 15,000.00 43.0 37-000-75-00-7509 SCADA SYSTEM 0.00 0.00 100,000.00 0.0 37-000-75-00-7515 HEARTLAND ONSITE INTERCEPTOR 0.00 278,893.00 278,893.00 100.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 731,896.74 5,210,545.21 19,243,893.00 27.0 TRANSFERS 37-000-99-00-9901 TRANSFER TO GENERAL FUND 25,000.00 125,000.00 200,000.00 62.5 37-000-99-00-9965 TRANSFER TO DEBT SERVICE 161,553.25 484,659.75 724,155.00 66.9 P26 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 27 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: SANITARY SEWER IMPROVEMENT FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------- TOTAL TRANSFERS 186,553.25 609,659.75 924,155.00 65.9 TOTAL EXPENSES: 1,092, 970.97 6,223,473.93 20, 685,000.00 30.0 TOTAL FUND REVENUES 334,305.44 13,393,372.48 20,685,000.00 64.7 TOTAL FUND EXPENSES 1,092,970.97 6,223,473.93 20,685,000.00 30.0 FUND SURPLUS (DEFICIT) (758,665.53) 7,169,898.55 0.00 100.0 P27 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 28 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY 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 4,700,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 4,700,000.00 0.0 CHARGES FOR SERVICES 41-000-42-00-4220 CONNECTION FEES 203,340.00 1,063,060.00 1,125,000.00 94.4 41-000-42-00-4221 SOUTHWEST WATER MAIN REVENUE 35,957.94 35,957.94 0.00 100.0 41-000-42-00-4230 SOUTHWEST WATER MAIN PROJ REV 0.00 0.00 2,600,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 239,297.94 1,099,017.94 3,725,000.00 29.5 MISCELLANEOUS 41-000-44-00-4490 MISCELLANEOUS INCOME 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 0.00 0.00 0.00 0.0 INTERGOVERNMENTAL 41-000-45-00-4530 RADIUM GRANT 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL INTERGOVERNMENTAL 0.00 0.00 0.00 0.0 INTEREST 41-000-46-00-4600 INVESTMENT INCOME 6,840.66 53,617.19 35,000.00 153.1 --------------------------------------------------------------------------------- TOTAL INTEREST 6,840.66 53,617.19 35,000.00 153.1 OTHER OPERATING RECEIPTS 41-000-48-00-4800 LOAN PROCEEDS 0.00 0.00 0.00 0.0 41-000-48-00-4801 IEPA LOAN/CONTRACT B PROCEEDS 0.00 2,046,892.96 0.00 100.0 41-000-48-00-4802 PROCEEDS ON SALE OF ASSETS 0.00 0.00 0.00 0.0 41-000-48-00-4803 LOAN PROCEEDS-CENTRAL ZONE 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING RECEIPTS 0.00 2,046,892.96 0.00 100.0 TRANSFERS P28 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 29 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.W0W FUND: WATER IMPROV. EXPANSION FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES TRANSFERS 41-000-49-00-4901 TRANSFER FROM GENERAL FUND 53,750.00 161,250.00 215,000.00 75.0 41-000-49-00-4915 TRANSFER FROM WATER FUND 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 53,750.00 161,250.00 215,000.00 75.0 TOTAL REVENUES: 299,888.60 3,360,778.09 8,675,000.00 38.7 EXPENSES PROFESSIONAL SERVICE 41-000-61-00-5300 LEGAL SERVICES 0.00 2,928.20 8,000.00 36.6 41-000-61-00-5301 ENGINEERING - GENERAL SERVICES 0.00 12,681.00 8,000.00 158.5 41-000-61-00-5400 RADIUM COMPLIANCE -CONTRACT B 0.00 558,359.10 3,662,730.00 15.2 41-000-61-00-5401 ENGINEERING-RADIUM CONTRACT B 114,226.21 167,912.26 425,000.00 39.5 41-000-61-00-5405 PROF. SVCS- RADIUM CONTRACT B 0.00 29,701.39 250,000.00 11.8 41-000-61-00-5408 CENTRAL ZONE - CONTRACT C 0.00 17,382.91 150,000.00 11.5 41-000-61-00-5410 ENGINEERING-CENTRAL ZONE 305.75 30,965.03 20,000.00 154.8 41-000-61-00-5413 PROFESSIONAL SERV-CENTRALZONE 0.00 0.00 0.00 0.0 41-000-61-00-5414 CONTRACT D SCADA SYSTEM 2,630.30 7,890.90 100,000.00 7.8 41-000-61-00-5415 USGS GROUNDWATER STUDY 14,975.00 40,290.00 24,490.00 164.5 41-000-61-00-5416 USGS GROUNDWATER COUNTYWIDE 0.00 1,953.00 13,000.00 15.0 41-000-61-00-5417 USGS GROUNDWATER SHALLOW WATER 0.00 32,019.50 55,108.00 58.1 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICE 132,137.26 902,083.29 4,716,328.00 19.1 OTHER 41-000-65-00-5421 GIS SYSTEM 0.00 0.00 10,000.00 0.0 41-000-65-00-5800 CONTINGENCY 0.00 1,532.50 8,353.00 18.3 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 1,532.50 18,353.00 8.3 DEBT SERVICE 41-000-66-00-6012 DEBT CERTIFICATE EXPENSES 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL DEBT SERVICE 0.00 0.00 0.00 0.0 P29 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 30 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ CAPITAL OUTLAY 41-000-75-00-7503 SOUTHWEST WATER MAIN PROJECT 937.30 19,963.63 2,600,000.00 0.7 41-000-75-00-7504 NORTH WATER TOWER-CONTRACT A 1,123.50 228,390.87 130,000.00 175.6 41-000-75-00-7506 APPLETREE COURT 0.00 0.00 0.00 0.0 41-000-75-00-7507 OVERSIZING - HEARTLAND CIRCLE 0.00 38,877.00 38,877.00 100.0 41-000-75-00-7509 SCADA SYSTEM 0.00 0.00 420,000.00 0.0 41-000-75-00-7515 JOHNSON STREET WATER MAIN 0.00 0.00 0.00 0.0 41-000-75-00-7520 WATERMAIN PROJECTS 0.00 0.00 40,000.00 0.0 41-000-75-00-7521 RADIO-READ METER RETRO-FITTING 0.00 0.00 0.00 0.0 41-000-75-00-7522 IN TOWN ROAD PROG WATER PROJ 0.00 0.00 215,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 2,060.80 287,231.50 3,443,877.00 8.3 TRANSFERS 41-000-99-00-9901 TRANSFER TO GENERAL FUND 50,000.00 150,000.00 200,000.00 75.0 41-000-99-00-9965 TRANSFER TO DEBT FUND 74,110.50 222,331.50 296,442.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 124,110.50 372,331.50 496,442.00 75.0 TOTAL EXPENSES: 258,308.56 1,563,178.79 8,675,000.00 18.0 TOTAL FUND REVENUES 299,888.60 3,360,778.09 8,675,000.00 38.7 TOTAL FUND EXPENSES 258,308.56 1,563,178.79 8,675,000.00 18.0 FUND SURPLUS (DEFICIT) 41,580.04 1,797,599.30 0.00 100.0 P30 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 31 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: DEBT SERVICE FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 42-000-40-00-3999 CARRY OVER 0.00 0.00 10,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 10,000.00 0.0 MISCELLANEOUS 42-000-44-00-4440 RECAPTURE-WATER/SEWER 5,468.64 83,799.03 100,000.00 83.7 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 5,468.64 83,799.03 100,000.00 83.7 TRANSFERS 42-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 0.00 0.00 0.0 42-000-49-00-4910 TRANSFER FROM POLICE EQUIP CAP 6,027.50 18,082.50 24,110.00 75.0 42-000-49-00-4920 TRANSFER FROM SEWER FUND 0.00 0.00 0.00 0.0 42-000-49-00-4925 TRANSFER FROM SANITARY SEWER 161,553.25 484,659.75 646,213.00 75.0 42-000-49-00-4930 TRANSFER FROM WATER IMPRV FUND 74,110.50 222,331.50 296, 442.00 75.0 42-000-49-00-4940 TRANSFER FROM MUNICIPAL BLDG 25,980.75 77,942.25 103,923.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 267,672.00 803,016.00 1,070, 688.00 75.0 TOTAL REVENUES: 273,140.64 886,815.03 1,180, 688.00 75.1 EXPENSES DEBT SERVICE 42-000-66-00-6001 CITY HALL BONDS-PRINCIPAL PMT 0.00 50,000.00 50,000.00 100.0 42-000-66-00-6002 CITY HALL BONDS - INTEREST PMT 0.00 53,922.50 53,923.00 99.9 42-000-66-00-6003 IRBB-BRUELL ST. INTEREST PMTS 42,717.50 85,435.00 85,435.00 100.0 42-000-66-00-6004 IRBB-BRUELL ST. PRINCIPAL PYMT 80,000.00 80,000.00 80,000.00 100.0 42-000-66-00-6005 NORTH H2O TOWER INTEREST PYMT 0.00 1,912.25 1, 912.00 100.0 42-000-66-00-6006 NORTH H2O TOWER PRINCIPAL PYMT 0.00 23,087.75 23,088.00 99.9 42-000-66-00-6007 4.8 MILLION DEBT CERT INT PYMT 0.00 233,150.00 233,150.00 100.0 42-000-66-00-6008 COUNTRYSIDE ALT REV PRINC PYMT 0.00 120,000.00 120,000.00 100.0 42-000-66-00-6009 COUNTRYSIDE ALT REV INT PYMT 0.00 120, 637.50 120,638.00 99.9 42-000-66-00-6010 COMED/HYDRAULIC INTEREST PYMT 0.00 43,216.50 43,128.00 100.2 42-000-66-00-6011 COM ED/HYDRAUL DEBT CERT PRINC 0.00 135,000.00 135,000.00 100.0 P31 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 32 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: DEBT SERVICE FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES DEBT SERVICE 42-000-66-00-6050 LOAN PAYMENT-SANITARY SIPHON 0.00 38,979.98 38,980.00 99.9 42-000-66-00-6051 LOAN PAYMENT-NORTH WTR/SWR-EDC 0.00 0.00 0.00 0.0 42-000-66-00-6052 LOAN PAYMENT-NORTH WTR/SWR-YNB 0.00 0.00 0.00 0.0 42-000-66-00-6053 LOAN PAYMENT-RIVER CROSSING 0.00 0.00 0.00 0.0 42-000-66-00-6054 LOAN PAYMENT-POLICE SQUAD CAR 0.00 24,037.15 24,110.00 99.6 42-000-66-00-6055 LOAN PAYMENT-SSES IEPA L171153 0.00 53,525.35 107,051.00 49.9 42-000-66-00-6056 YNB-POLICE/ADMIN CARS 0.00 0.00 0.00 0.0 42-000-66-00-6058 ROAD IMPROV. PROG. INT PYMT 0.00 0.00 0.00 0.0 42-000-66-00-6070 $650K ROAD IMPROV PROG INT 0.00 14,272.50 14,273.00 99.9 42-000-66-00-6071 $650K ROAD IMPROV PROG PRINC 0.00 50,000.00 50,000.00 100.0 42-000-66-00-6072 $2 MIL ALT REV B.2&3 INT PYMT 0.00 29,799.58 0.00 (100.0) --------------------------------------------------------------------------------- TOTAL DEBT SERVICE 122,717.50 1,156,976.06 1,180,688.00 97.9 TOTAL FUND REVENUES 273,140.64 886,815.03 1,180,688.00 75.1 TOTAL FUND EXPENSES 122,717.50 1,156,976.06 1,180,688.00 97.9 FUND SURPLUS (DEFICIT) 150,423.14 (270,161.03) 0.00 100.0 P32 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 33 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY 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 1,500,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 1,500,000.00 0.0 CHARGES FOR SERVICES 51-000-42-00-4240 BULK WATER SALES (438.93) 9,422.97 10,000.00 94.2 51-000-42-00-4241 WATER SALES 1,885.08 873,234.15 900,000.00 97.0 51-000-42-00-4242 WATER METER SALES 38, 640.00 215, 615.00 130,000.00 165.8 51-000-42-00-4243 LEASE REVENUE - H2O TOWER 1,854.00 16, 686.00 21,600.00 77.2 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 41,940.15 1,114,958.12 1,061, 600.00 105.0 MISCELLANEOUS 51-000-44-00-4490 MISCELLANEOUS INCOME 0.00 290.00 2,000.00 14.5 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 0.00 290.00 2,000.00 14.5 INTEREST 51-000-46-00-4600 INVESTMENT INCOME 3,225.43 14,367.19 12,000.00 119.7 --------------------------------------------------------------------------------- TOTAL INTEREST 3,225.43 14,367.19 12,000.00 119.7 TOTAL REVENUES: 45,165.58 1,129,615.31 2,575,600.00 43.8 EXPENSES PERSONNEL 51-000-50-00-5107 SALARIES - EMPLOYEE 20,130.26 189,575.68 264,873.00 71.5 51-000-50-00-5136 SALARIES-PART TIME 0.00 5,216.00 8,200.00 63.6 51-000-50-00-5137 SALARIES - OVERTIME 3,068.62 31,038.65 27,000.00 114.9 --------------------------------------------------------------------------------- TOTAL PERSONNEL 23,198.88 225,830.33 300,073.00 75.2 PROFESSIONAL SERVICES 51-000-61-00-5300 LEGAL SERVICES 0.00 337.50 2,000.00 16.8 P33 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 34 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES PROFESSIONAL SERVICES 51-000-61-00-5303 JULIE SERVICE 0.00 5,589.75 6,800.00 82.2 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 0.00 5,927.25 8,800.00 67.3 CONTRACTURAL SERVICES 51-000-62-00-5401 CONTRACUAL SERVICES 520.00 2,950.62 4,500.00 65.5 51-000-62-00-5407 TREATMENT FACILITIES 0&M 14,259.22 56,924.63 150,000.00 37.9 51-000-62-00-5408 MAINTENANCE-EQUIPMENT 1,067.30 1,573.69 9,000.00 17.4 51-000-62-00-5409 MAINTENANCE - VEHICLES 47.81 387.79 7,000.00 5.5 51-000-62-00-5411 MAINTENANCE-COMPUTERS 0.00 0.00 1,000.00 0.0 51-000-62-00-5413 MAINTENANCE-CONTROL SYSTEM 0.00 500.37 10,000.00 5.0 51-000-62-00-5414 TRUCK LETTERING 0.00 0.00 0.00 0.0 51-000-62-00-5421 WEARING APPAREL 0.00 1,952.12 5,500.00 35.4 51-000-62-00-5422 WATER TOWER PAINTING 10,000.00 219,870.00 220,000.00 99.9 51-000-62-00-5434 RENTAL - EQUIPMENT 0.00 0.00 1,000.00 0.0 51-000-62-00-5435 ELECTRICITY 253.42 77,615.48 170,000.00 45.6 51-000-62-00-5436 TELEPHONE 1,298.89 10,771.51 22, 600.00 47.6 51-000-62-00-5438 CELLULAR TELEPHONE 543.82 2,671.52 5,700.00 46.8 --------------------------------------------------------------------------------- TOTAL CONTRACTURAL SERVICES 27,990.46 375,217.73 606,300.00 61.8 PROFESSIONAL DEVELOPMENT 51-000-64-00-5600 DUES 297.00 297.00 1,000.00 29.7 51-000-64-00-5603 SUBSCRIPTIONS 0.00 42.30 250.00 16.9 51-000-64-00-5604 TRAINING & CONFERENCES 0.00 1,977.34 3,000.00 65.9 51-000-64-00-5605 TRAVEL EXPENSES 0.00 803.24 3,000.00 26.7 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 297.00 3,119.88 7,250.00 43.0 OPERATIONS 51-000-65-00-5800 CONTINGENCIES 0.00 0.00 30,000.00 0.0 51-000-65-00-5804 OPERATING SUPPLIES 5,419.33 32,379.27 46,200.00 70.0 51-000-65-00-5808 POSTAGE & SHIPPING 872.72• 9,351.88 13,500.00 69.2 51-000-65-00-5809 PRINTING & COPYING 1,929.65 7,187.67 5,500.00 130.6 51-000-65-00-5810 PUBLISHING & ADVERTISING 0.00 150.00 1,000.00 15.0 P34 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 35 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES OPERATIONS 51-000-65-00-5812 GASOLINE 0.00 14,629.03 9,570.00 152.8 51-000-65-00-5815 HAND TOOLS 0.00 19.94 1,000.00 1.9 51-000-65-00-5817 GRAVEL 1,063.17 2,255.92 5,000.00 45.1 51-000-65-00-5819 CHLORINE 0.00 0.00 0.00 0.0 51-000-65-00-5820 CHEMICALS 1,743.81 10,923.61, 30,000.00 36.4 51-000-65-00-5821 CATHODIC PROTECTION 0.00 0.00 6,250.00 0.0 51-000-65-00-5822 WATER SAMPLES 1,505.00 10,676.00 12,000.00 88.9 --------------------------------------------------------------------------------- TOTAL OPERATIONS 12,533.68 87,573.32 160,020.00 54.7 RETIREMENT 51-000-72-00-6500 IMRF PARTICIPANTS 1,888.40 17,907.14 24,354.00 73.5 51-000-72-00-6501 SOCIAL SECURITY & MEDICARE 1,771.39 17,606.75 23,515.00 74.8 --------------------------------------------------------------------------------- TOTAL RETIREMENT 3, 659.79 35,513.89 47,869.00 74 .1 CAPITAL OUTLAY 51-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 30.98 268.04 4,000.00 6.7 51-000-75-00-7004 SAFETY EQUIPMENT 0.00 2,325.01 2,000.00 116.2 51-000-75-00-7506 METER READERS 0.00 4,941.63 10,900.00 45.3 51-000-75-00-7507 HYDRANT REPLACEMENT 0.00 1,976.00 10,000.00 19.7 51-000-75-00-7508 METERS & PARTS 14,880.21 131,334.55 262,500.00 50.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 14,911.19 140,845.23 289,400.00 48.6 OTHER 51-000-78-00-9003 MERIT 0.00 0.00 7,318.00 0.0 51-000-78-00-9005 REFUND 0.00 0.00 1,500.00 0.0 51-000-78-00-9008 RESERVE-H2O TOWER MAINTENANCE 0.00 0.00 43,200.00 0.0 51-000-78-00-9009 RESERVE 0.00 0.00 853,870.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 905,888.00 0.0 TRANSFERS 51-000-99-00-9901 TRANSFER TO GENERAL FUND 50,000.00 150,000.00 200,000.00 75.0 P35 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 36 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES TRANSFERS 51-000-99-00-9930 TRANSFER TO WATER IMPRV FUND 0.00 0.00 0.00 0.0 51-000-99-00-9950 TRANSFER TO PW EQUIP CAPITAL 12,500.00 37,500.00 50,000.00 75.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 62,500.00 187,500.00 250,000.00 75.0 TOTAL EXPENSES: 145,091.00 1,061,527.63 2,575,600.00 41.2 TOTAL FUND REVENUES 45,165.58 1,129,615.31 2,575,600.00 43.8 TOTAL FUND EXPENSES 145,091.00 1,061,527.63 2,575,600.00 41.2 FUND SURPLUS (DEFICIT) (99,925.42) 68,087.68 0.00 100.0 P36 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 37 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: SEWER MAINTENANCE FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY 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 450,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 450,000.00 0.0 CHARGES FOR SERVICES 52-000-42-00-4240 LIFT STATION INCOME 0.00 0.00 8,000.00 0.0 52-000-42-00-4250 SEWER MAINTENANCE FEES 31.27 309,889.19 355,000.00 87.2 52-000-42-00-4251 SEWER CONNNECTION FEES 22,800.00 132,400.00 140,000.00 94.5 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 22,831.27 442,289.19 503,000.00 87.9 INTEREST 52-000-46-00-4600 INVESTMENT INCOME 3,230.42 14,437.15 15,000.00 96.2 --------------------------------------------------------------------------------- TOTAL INTEREST 3,230.42 14,437.15 15,000.00 96.2 TOTAL REVENUES: 26,061.69 456,726.34 968,000.00 47.1 EXPENSES PERSONNEL SERVICES 52-000-50-00-5108 SALARIES-REGULAR 8,594.94 82,736.40 137,555.00 60.1 52-000-50-00-5136 PART TIME 0.00 2,299.50 5,000.00 45.9 52-000-50-00-5137 SALARIES-OVERTIME 193.10 3,060.24 12,000.00 25.5 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 8,788.04 88,096.14 154,555.00 56.9 CONTRACTUAL SERVICES 52-000-62-00-5401 CONTRACTUAL SERVICES 434.83 3,445.33 2,000.00 172.2 52-000-62-00-5408 MAINTENANCE-EQUIPMENT 0.50 2,101.54 5,000.00 42.0 52-000-62-00-5409 MAINTENANCE-VEHICLES 0.00 40.00 3,000.00 1.3 52-000-62-00-5419 MAINTENANCE-SANITARY SEWER 186.28 8,030.80 25,000.00 32.1 52-000-62-00-5421 WEARING APPAREL 146.02 2,052.71 4,500.00 45.6 52-000-62-00-5422 LIFT STATION MAINTENANCE 594.75 19,649.81 25,000.00 78.5 52-000-62-00-5434 RENTAL - EQUIPMENT 0.00 0.00 1,000.00 0.0 P37 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 38 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: SEWER MAINTENANCE FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES CONTRACTUAL SERVICES 52-000-62-00-5435 ELECTRICITY 0.00 5,836.98 16,500.00 35.3 52-000-62-00-5438 CELLULAR TELEPHONE 322.12 1,382.01 2,500.00 55.2 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 1,684.50 42,539.18 84,500.00 50.3 PROFESSIONAL DEVELOPMENT 52-000-64-00-5604 TRAINING & CONFERENCES 0.00 181.32 1,500.00 12.0 52-000-64-00-5605 TRAVEL/MEALS/LODGING 0.00 849.31 1,500.00 56.6 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 0.00 1,030.63 3,000.00 34.3 OPERATIONS 52-000-65-00-5800 CONTINGENCIES 0.00 0.00 9,300.00 0.0 52-000-65-00-5802 OFFICE SUPPLIES 240.93 1,746.32 2,000.00 87.3 52-000-65-00-5804 OPERATING SUPPLIES 0.00 0.00 0.00 0.0 52-000-65-00-5805 SHOP SUPPLIES 0.00 650.13 2,500.00 26.0 52-000-65-00-5812 GASOLINE 0.00 13,244.70 10,500.00 126.1 52-000-65-00-5815 HAND TOOLS 0.00 109.40 1,000.00 10.9 52-000-65-00-5817 GRAVEL 0.00 1,216.28 2,000.00 60.8 52-000-65-00-5823 SEWER CHEMICALS 0.00 1,368.87 5,000.00 27.3 --------------------------------------------------------------------------------- TOTAL OPERATIONS 240.93 18,335.70 32,300.00 56.7 RETIREMENT 52-000-72-00-6500 IMRF PARTICIPANTS 715.36 6,989.07 12,475.00 56.0 52-000-72-00-6501 SOCIAL SECURITY & MEDICARE 670.83 6,730.35 12,106.00 55.5 --------------------------------------------------------------------------------- TOTAL RETIREMENT 1,386.19 13,719.42 24,581.00 55.8 CAPITAL OUTLAY 52-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 94.94 2,500.00 3.7 52-000-75-00-7003 OFFICE EQUIPMENT 0.00 413.17 6,000.00 6.8 52-000-75-00-7004 SAFETY EQUIPMENT 155.00 610.64 2,000.00 30.5 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 155.00 1,118.75 10,500.00 10.6 P38 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 39 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: SEWER MAINTENANCE FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ OTHER 52-000-78-00-9005 MERIT 0.00 0.00 3,695.00 0.0 52-000-78-00-9009 RESERVE 0.00 9,800.00 554,869.00 1.7 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 9,800.00 558,564.00 1.7 TRANSFERS 52-000-99-00-9901 TRANSFER TO GENERAL FUND 17,500.00 52,500.00 70,000.00 75.0 52-000-99-00-9925 TRANSFER TO SAN SEWER IMPROV. 0.00 0.00 0.00 0.0 52-000-99-00-9950 TRANSFER TO PW EQUIP CAPITAL 7,500.00 22,500.00 30,000.00 75.0 52-000-99-00-9965 TRANSFER TO DEBT SERVICE FUND 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 25,000.00 75,000.00 100,000.00 75.0 TOTAL EXPENSES: 37,254.66 249,639.82 968,000.00 25.7 TOTAL FUND REVENUES 26,061.69 456,726.34 968,000.00 47.1 TOTAL FUND EXPENSES 37,254.66 249,639.82 968,000.00 25.7 FUND SURPLUS (DEFICIT) (11,192.97) 207,086.52 0.00 100.0 P39 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 40 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL47O002.WOW FUND: LAND CASH FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 72-000-40-00-3999 CARRY OVER/STARTING BALANCE 0.00 0.00 650,000.00 0.0 72-000-40-00-4700 LAND CASH - OTHER 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 650,000.00 0.0 CONTRIBUTIONS 72-000-47-00-4700 OSLAD GRANT 0.00 74,000.00 320,000.00 23.1 72-000-47-00-4701 GREENBRIAR-LAND CASH 0.00 1,071.00 15,498.00 6.9 72-000-47-00-4702 GREENBRIAR(DUPLEX)-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4703 PRAIRIE GARDEN-LAND CASH 0.00 9,450.00 0.00 100.0 72-000-47-00-4704 FOX HILL-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4705 COUNTRY HILLS-LAND CASH 0.00 6,921.00 30,468.00 22.7 72-000-47-00-4706 COUNTRY HILLS DUPLEX-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4707 FOX HIGHLANDS-LAND CASH 0.00 1,406.00 0.00 100.0 72-000-47-00-4708 FOX HIGHLANDS DUPLEX-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4709 SUNFLOWER-LAND CASH 0.00 1,805.00 9,025.00 20.0 72-000-47-00-4710 CIMMERON RIDGE-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4711 BLACKBERRY CREEK-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4712 RIVER'S EDGE-LAND CASH 671.00 10,736.00 26,840.00 40.0 72-000-47-00-4713 CANNONBALL HILLS-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4714 WOODWORTH-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4715 WHITE OAK UNIT 1&2-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4716 WHITE OAK UNIT 3&4-LAND CASH 0.00 1,406.00 0.00 100.0 72-000-47-00-4717 KYLN'S CROSSING-LAND CASH 0.00 0.00 7,065.00 0.0 72-000-47-00-4718 FOXFIELD(2ND EDITION)-LAND CAS 0.00 0.00 0.00 0.0 72-000-47-00-4719 WILDWOOD-LAND CASH 0.00 918.00 0.00 100.0 72-000-47-00-4720 HEARTLAND-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4721 COUNTRYSIDE CNTR#9-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4722 KYLN'S RIDGE-LAND CASH 0.00 4,155.00 41,550.00 10.0 72-000-47-00-4723 HEARTLAND CIRCLE-LAND CASH 4,000.00 32,000.00 75,000.00 42.6 72-000-47-00-4724 RAINTREE VILLAGE-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4725 WINDETTE RIDGE-LAND CASH 0.00 0.00 50,000.00 0.0 72-000-47-00-4726 RESERVE @ THE FOX LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4727 GRAND RESERVE-LAND CASH 0.00 5,166.53 290,000.00 1.7 72-000-47-00-4728 BRISBEN RESERVE-LAND CASH 0.00 0.00 0.00 0.0 P40 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 41 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LAND CASH FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CONTRIBUTIONS 72-000-47-00-4730 CANNONBALL EST/KYLYNS CROSSING 0.00 0.00 0.00 0.0 72-000-47-00-4731 MONTALBANO HOMES LAND CASH 0.00 0.00 10, 620.00 0.0 72-000-47-00-4732 RAINTREE VILLAGE LAND CASH 0.00 29,000.00 29,000.00 100.0 72-000-47-00-4734 WHISPERING MEADOWS (K. HILL) 1,691.67 31,013.95 17,735.00 174.8 72-000-47-00-4735 PRAIRIE MEADOWS (MENARD RES) 0.00 0.00 0.00 0.0 72-000-47-00-4736 CORNERSTONE 0.00 0.00 41,340.00 0.0 72-000-47-00-4737 CALEDONIA 0.00 0.00 7, 672.00 0.0 72-000-47-00-4738 AUTUMN CREEK 0.00 3,384.10 314,065.00 1.0 72-000-47-00-4739 WYNSTONE TOWNHOMES 0.00 0.00 24,216.00 0.0 72-000-47-00-4740 VILLAS AT THE PRESERVE 0.00 0.00 72,839.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRIBUTIONS 6,362.67 212,432.58 1,382, 933.00 15.3 TOTAL REVENUES: 6,362.67 212,432.58 2,032,933.00 10.4 EXPENSES CONTRACTUAL SERVICES 72-000-62-00-5408 MAINTENANCE-EQUIPMENT 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 0.00 0.00 0.00 0.0 CAPITAL OUTLAY 72-000-75-00-7007 SIGNS 0.00 0.00 0.00 0.0 72-000-75-00-7008 MISC. BALLFIELD EQUIP 0.00 0.00 0.00 0.0 72-000-75-00-7200 BLDG IMPROVE - BEECHER 0.00 0.00 0.00 0.0 72-000-75-00-7201 RIVERFRONT EQUIP IMPROVEMENT 0.00 0.00 0.00 0.0 72-000-75-00-7300 GREENBRIAR 0.00 3,000.00 20,000.00 15.0 72-000-75-00-7301 FOX HILL 0.00 0.00 0.00 0.0 72-000-75-00-7302 COUNTRYHILLS 0.00 0.00 0.00 0.0 72-000-75-00-7303 FOX HIGHLANDS 0.00 0.00 0.00 0.0 72-000-75-00-7304 SUNFLOWER 0.00 71, 697.27 145,000.00 49.4 72-000-75-00-7305 CIMMERON RIDGE 0.00 0.00 0.00 0.0 72-000-75-00-7306 BLACKBERRY CREEK 0.00 0.00 0.00 0.0 72-000-75-00-7307 RIVERS EDGE 0.00 0.00 0.00 0.0 P41 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 42 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LAND CASH FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES CAPITAL OUTLAY 72-000-75-00-7308 RIVERS EDGE PARK 02 0.00 26,901.22 50,000.00 53.8 72-000-75-00-7309 WHITE OAK 0.00 0.00 0.00 0.0 72-000-75-00-7310 WILDWOOD 0.00 0.00 0.00 0.0 72-000-75-00-7311 CANNONBALL ESTATES/KYLIN 0.00 201,949.61 229,000.00 88.1 72-000-75-00-7312 FOXFIELD 2ND EDITION 0.00 0.00 0.00 0.0 72-000-75-00-7313 HEARTLAND 0.00 0.00 0.00 0.0 72-000-75-00-7314 PRAIRIE GARDENS 0.00 0.00 0.00 0.0 72-000-75-00-7315 BRISBEN 0.00 0.00 0.00 0.0 72-000-75-00-7316 KYLN'S RIDGE 0.00 0.00 0.00 0.0 72-000-75-00-7317 HEARTLAND CIRCLE 0.00 0.00 6,000.00 0.0 72-000-75-00-7318 THE RESERVE 0.00 0.00 0.00 0.0 72-000-75-00-7319 THE HIGHLANDS 0.00 0.00 0.00 0.0 72-000-75-00-7320 BLACKHAWK 0.00 0.00 0.00 0.0 72-000-75-00-7321 CANNBALL HILL/KYLYN'S 0.00 0.00 0.00 0.0 72-000-75-00-7322 BEECHER 0.00 0.00 0.00 0.0 72-000-75-00-7323 BLACKHAWK 0.00 0.00 0.00 0.0 72-000-75-00-7324 TOWN SQUARE 0.00 0.00 10,000.00 0.0 72-000-75-00-7325 VAN EMMON 0.00 0.00 0.00 0.0 72-000-75-00-7326 CORLANDS 0.00 0.00 0.00 0.0 72-000-75-00-7327 GRANDE RESERVE PARK DEV. 0.00 9, 693.74 465,500.00 2.0 72-000-75-00-7328 PRAIRIE MEADOWS (MENARDS RES) 0.00 0.00 70,000.00 0.0 72-000-75-00-7329 ELSIE LOUISE GILBERT PARK 0.00 75,946.12 0.00 (100.0) 72-000-75-00-7330 WHISPERING MEADOWS (K. HILL) 65.00 19,811.37 5,000.00 396.2 72-000-75-00-7331 WINDETT RIDGE 0.00 0.00 65,000.00 0.0 72-000-75-00-7700 PARK MAINTENANCE FACILITY 0.00 0.00 500,000.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 65.00 408,999.33 1,565,500.00 26.1 OTHER 72-000-78-00-9009 RESERVE 0.00 329,736.22 419,433.00 78.6 72-000-78-00-9010 BEECHER CONCESSION STAND 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 329,736.22 419,433.00 78.6 TRANSFERS P42 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 43 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LAND CASH FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ EXPENSES TRANSFERS 72-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 0.00 48,000.00 0.0 72-000-99-00-9955 TRANSFER TO PARKS/REC CAP FUND 0.00 0.00 0.00 0.0 72-000-99-00-9970 TRANSFER TO LAND ACQUISITION 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 48,000.00 0.0 TOTAL EXPENSES: 65.00 738,735.55 2,032,933.00 36.3 TOTAL FUND REVENUES 6,362.67 212,432.58 2,032,933.00 10.4 TOTAL FUND EXPENSES 65.00 738,735.55 2,032,933.00 36.3 FUND SURPLUS .(DEFICIT) 6,297.67 (526,302.97) 0.00 100.0 P43 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 44 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LAND ACQUISITION FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY 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 214,078.00 0.0 73-000-40-00-4930 COLT FUNDING 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 214,078.00 0.0 TRANSFERS 73-000-49-00-4935 TRANSFER FROM LAND CASH 0.00 0.00 0.00 0.0 73-000-49-00-4937 TRANSFER FROM PARKS & REC 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 0.00 0.0 TOTAL REVENUES: 0.00 0.00 214,078.00 0.0 EXPENSES OTHER 73-000-65-00-5800 CONTINGENCY 0.00 0.00 214,078.00 0.0 73-000-65-00-5805 WEST HYDRAULIC ACQUISITION 0.00 0.00 0.00 0.0 73-000-65-00-5808 GILBERT PARK ACQUISITION 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 214,078.00 0.0 TOTAL FUND REVENUES 0.00 0.00 214,078.00 0.0 TOTAL FUND EXPENSES 0.00 0.00 214,078.00 0.0 FUND SURPLUS (DEFICIT) 0.00 0.00 0.00 0.0 P44 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 45 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY 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 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 0.00 0.0 CHARGES FOR SERVICES 79-000-42-00-4270 FEES FOR PROGRAMS 15,979.50 195,202.34 176,825.00 110.3 79-000-42-00-4280 CONCESSIONS 62.75 13,884.98 10,500.00 132.2 79-000-42-00-4281 BEECHER BLDG/SHELTER DEPOSITS 1,250.00 2,000.00 4,500.00 44.4 79-000-42-00-4282 FARMERS MARKET 0.00 0.00 0.00 0.0 79-000-42-00-4285 VENDING MACHINE INCOME 0.00 459.42 650.00 70.6 79-000-42-00-4286 RENTAL INCOME 155.00 1,685.00 4,000.00 42.1 79-000-42-00-4287 RENTAL INCOME - SHELTERS 35.00 310.00 1,000.00 31.0 79-000-42-00-4288 GOLF OUTING REVENUE 0.00 40,160.00 38,000.00 105.6 79-000-42-00-4289 DAY TRIPS 0.00 0.00 0.00 0.0 79-000-42-00-4290 YOUTH/SPECIAL EVENTS 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 17,482.25 253,701.74 235,475.00 107.7 MISCELLANEOUS 79-000-44-00-4400 DONATIONS 147.00 11,325.00 15,000.00 75.5 79-000-44-00-4404 TREE DONATIONS 0.00 900.00 500.00 180.0 79-000-44-00-4490 MISCELLANEOUS INCOME 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 147.00 12,225.00 15,500.00 78.8 INTERGOVERNMENTAL 79-000-45-00-4540 ILLINOIS FIRST GRANT 0.00 0.00 0.00 0.0 ,79-000-45-00-4545 IDNR GRANT 0.00 0.00 0.00 0.0 79-000-45-00-4550 YOUTH SERVICES GRANT 1,000.00 2,000.00 2,000.00 100.0 --------------------------------------------------------------------------------- TOTAL INTERGOVERNMENTAL 1,000.00 2,000.00 2,000.00 100.0 INTEREST 79-000-46-00-4600 INVESTMENT INCOME 1,293.29 7,712.39 1,500.00 514.1 --------------------------------------------------------------------------------- TOTAL INTEREST 1,293.29 7,712.39 1,500.00 514.1 P45 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 46 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TRANSFERS 79-000-49-00-4901 TRANSFER FROM GENERAL FUND 77,380.58 696,425.22 928,567.00 74 .9 --------------------------------------------------------------------------------- TOTAL TRANSFERS 77,380.58 696,425.22 928,567.00 74.9 TOTAL REVENUES: 97,303.12 972,064.35 1,183,042.00 82.1 PARKS EXPENSES PERSONNAL SERVICES 79-610-50-00-5107 SALARIES-EMPLOYEES 21,846.36 218,513.46 312,678.00 69.8 79-610-50-00-5136 SALARIES - PART-TIME 384.00 38,527.52 45,000.00 85.6 79-610-50-00-5137 SALARIES - OVERTIME 90.00 1,930.98 8,000.00 24.1 --------------------------------------------------------------------------------- TOTAL PERSONNAL SERVICES 22,320.36 258,971.96 365,678.00 70.8 PROFESSIONAL SERVICES 79-610-61-00-5320 MASTER PLAN 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 0.00 0.00 0.00 0.0 CONTRACTUAL SERVICES 79-610-62-00-5405 PARK CONTRACTUAL 600.00 11,185.00 12,000.00 93.2 79-610-62-00-5408 MAINTENANCE-EQUIPMENT 173.18 6,864.39 6,000.00 114.4 79-610-62-00-5417 MAINTENANCE-PARKS 395.68 20,165.75 32,000.00 63.0 79-610-62-00-5421 WEARING APPAREL 213.49 1,823.50 8,000.00 22.7 79-610-62-00-5425 ILLINOIS FIRST GRANT 0.00 0.00 0.00 0.0 79-610-62-00-5434 RENTAL-EQUIPMENT 0.00 309.49 1,700.00 18.2 79-610-62-00-5438 CELLULAR TELEPHONE 464.07 2,302.20 5,750.00 40.0 79-610-62-00-5440 LAND DEVELOPER 0.00 553.50 10,000.00 5.5 79-610-62-00-5445 LEGAL EXPENSES 0.00 1,462.50 10,000.00 14.6 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 1,846.42 44,666.33 85,450.00 52.2 PROFESSIONAL DEVELOPMENT P46 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 47 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ PARKS EXPENSES PROFESSIONAL DEVELOPMENT 79-610-64-00-5602 PROFESSIONAL GROWTH/SUBSCRPT 1,187.39 2,869.62 4,500.00 63.7 79-610-64-00-5605 TRAVEL EXPENSE 303.60 2,714.62 3,000.00 90.4 79-610-64-00-5612 CONTINUING EDUCATION 1,152.00 2,232.00 4,200.00 53.1 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 2,642.99 7,816.24 11,700.00 66.8 OPERATIONS 79-610-65-00-5800 CONTINGENCIES 0.00 0.00 0.00 0.0 79-610-65-00-5802 OFFICE SUPPLIES 50.09 604.34 1,500.00 40.2 79-610-65-00-5804 OPERATING SUPPLIES• 1,311.66 10,879.76 25,000.00 43.5 79-610-65-00-5812 GASOLINE 0.00 73.75 3,500.00 2.1 79-610-65-00-5815 HAND TOOLS 403.65 1,003.51 3,000.00 33.4 79-610-65-00-5824 CHRISTMAS DECORATIONS 229.74 6,359.19 7,000.00 90.8 79-610-65-00-5825 PUBLIC DECORATION 0.00 589.91 3,000.00 19.6 --------------------------------------------------------------------------------- TOTAL OPERATIONS 1,995.14 19,510.46 43,000.00 45.3 RETIREMENT 79-610-72-00-6500 IMRF PARTICIPANTS 1,785.64 17,236.79 26,702.00 64.5 79-610-72-00-6501 SOCIAL SECURITY/MEDICARE 1,692.24 19,011.53 28,537.00 66.6 --------------------------------------------------------------------------------- TOTAL RETIREMENT 3,477.88 36,248.32 55,239.00 65.6 CAPITAL OUTLAY 79-610-75-00-7003 OFFICE EQUIPMENT 0.00 24.99 27,000.00 0.0 79-610-75-00-7701 FLOWERS/TREES 0.00 2,361.86 6,500.00 36.3 79-610-75-00-7705 TRANSFER TO LAND ACQUISITION 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 2,386.85 33,500.00 7.1 OTHER 79-610-78-00-9005 MERIT 0.00 0.00 7,359.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 7,359.00 0.0 P47 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 48 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TOTAL EXPENSES: PARKS 32,282.79 369,600.16 601,926.00 61.4 RECREATION EXPENSES PERSONNEL SERVICES 79-650-50-00-5107 EMPLOYEE SALARIES 18,155.70 188,195.51 260,696.00 72.1 79-650-50-00-5108 CONCESSION STAFF 0.00 3,280.50 3,600.00 91.1 79-650-50-00-5150 SALARIES-INSTRUCTOR CONTRACTUA 10,819.91 83,922.51 88,000.00 95.3 79-650-50-00-5155 SALARIES-RECORDING SECRETARY 113.00 1,183.00 5,000.00 23.6 79-650-50-00-5156 SALARIES-CUSTODIAL 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 29,088.61 276,581.52 357,296.00 77.4 PROFESSIONAL SERVICES 79-650-61-00-5321 RECREATION RESEARCH 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 0.00 0.00 0.00 0.0 CONTRACTUAL SERVICES 79-650-62-00-5408 MAINTENANCE SUPPLIES 124.13 2,904.77 8,000.00 36.3 79-650-62-00-5409 MAINTENANCE-VEHICLES 6.95 129.12 1,200.00 10.7 79-650-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 0.00 3,552.11 5,500.00 64.5 79-650-62-00-5426 YOUTH SERVICES GRANT EXPENSES 76.00 539.42 2,000.00 26.9 79-650-62-00-5437 TELEPHONE/INTERNET 34.16 334.62 1,400.00 23.9 79-650-62-00-5438 CELLULAR TELEPHONE 401.60 2,665.57 4,500.00 59.2 79-650-62-00-5445 PORTABLE TOILETS 0.00 3,273.65 4,500.00 72.7 79-650-62-00-5603 PUBLISHING/ADVERTISING 47.84 18,794.07 25,200.00 74.5 79-650-62-00-5605 BOOKS/PUBLICATIONS 199.53 359.03 750.00 47.8 79-650-62-00-5606 BEECHER DEPOSIT REFUND 250.00 3,450.00 4,000.00 86.2 --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 1,140.21 36,002.36 57,050.00 63.1 PROFESSIONAL DEVELOPMENT 79-650-64-00-5600 DUES 622.00 702.00 2,700.00 26.0 79-650-64-00-5602 PROFESSIONAL GROWTH/SUBSCRIPT 560.00 3,793.00 7,500.00 50.5 79-650-64-00-5605 TRAVEL EXPENSE 477.75 1,581.78 2,500.00 63.2 P48 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 49 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ RECREATION EXPENSES PROFESSIONAL DEVELOPMENT 79-650-64-00-5614 TOURNAMENT FEES 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 1, 659.75 6,076.78 12,700.00 47.8 OPERATIONS 79-650-65-00-5800 CONTINGENCIES 0.00 0.00 0.00 0.0 79-650-65-00-5802 OFFICE SUPPLIES 246.82 3, 500.62 6,600.00 53.0 79-650-65-00-5803 PROGRAM EXPENSES 7,350.65 36,505.03 39,185.00 93.1 79-650-65-00-5804 OPERATING SUPPLIES 28.93 3, 171.41 4,000.00 79.2 79-650-65-00-5805 RECREATION EQUIPMENT 364.57 879.13 3,500.00 25.1 79-650-65-00-5808 POSTAGE & SHIPPING 720.49 4,786.44 6,500.00 73.6 79-650-65-00-5812 GASOLINE 113.75 644.16 1, 600.00 40.2 79-650-65-00-5826 MILEAGE 103.31 616.58 750.00 82.2 79-650-65-00-5827 GOLF OUTING EXPENSES 0.00 21,944.65 20,000.00 109.7 79-650-65-00-5828 CONCESSIONS 0.00 9,734.06 5,000.00 194.6 79-650-65-00-5830 YOUTH/SPECIAL EVENTS 0.00 0.00 0.00 0.0 79-650-65-00-5831 DAY TRIP EXPENSES 0.00 0.00 0.00 0.0 79-650-65-00-5840 SCHOLARSHIPS 0.00 1,570.00 1,500.00 104.6 79-650-65-00-5841 PROGRAM REFUND 772.00 9,779.30 6,500.00 150.4 --------------------------------------------------------------------------------- TOTAL OPERATIONS 9,700.52 93,131.38 95,135.00 97.8 RETIREMENT 79-650-72-00-6500 IMRF PARTICIPANTS 1, 603.08 16, 610.67 21,754.00 76.3 79-650-72-00-6501 SOCIAL SECURITY/MEDICARE 1,787.73 18,837.14 24,132.00 78.0 --------------------------------------------------------------------------------- TOTAL RETIREMENT 3,390.81 35,447.81 45,886.00 77.2 CAPITAL OUTLAY 79-650-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 6,754.63 6,500.00 103.9 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 6,754.63 6,500.00 103.9 OTHER 79-650-78-00-9005 MERIT 0.00 0.00 6,549.00 0.0 P49 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 50 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------- TOTAL OTHER 0.00 0.00 6,549.00 0.0 TOTAL EXPENSES: RECREATION 44,979.90 453,994.48 581,116.00 78.1 TOTAL FUND REVENUES 97,303.12 972,064.35 1,183,042.00 82.1 TOTAL FUND EXPENSES 77,262.69 823,594.64 1,183,042.00 69.6 FUND SURPLUS (DEFICIT) 20,040.43 148,469.71 0.00 100.0 P5O DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 51 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WORKING CASH FUND FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 80-000-40-00-3999 CARRY OVER/BEG FUND BALANCE 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 0.00 0.00 0.0 EXPENSES TRANSFERS 80-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 0.00 0.00 0.0 TOTAL FUND REVENUES 0.00 0.00 0.00 0.0 TOTAL FUND EXPENSES 0.00 0.00 0.00 0.0 FUND SURPLUS (DEFICIT) 0.00 0.00 0.00 0.0 P51 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 52 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.W0W FUND: LIBRARY FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES TAXES 82-000-40-00-3996 CARRY OVER - BOOK DEV FEES 0.00 0.00 57,736.00 0.0 82-000-40-00-3997 CARRY OVER - BLDG DEV FEES 0.00 0.00 31,695.00 0.0 82-000-40-00-3998 CARRY OVER-MEMORIALS 0.00 0.00 5,362.00 0.0 82-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 75,916.00 0.0 82-000-40-00-4000 REAL ESTATE TAXES 0.00 356,387.49 370,500.00 96.1 82-000-40-00-4010 PERSONAL PROPERTY TAX 1,024.46 2,692.36 2,500.00 107.6 82-000-40-00-4015 TRANSFER FROM GENERAL FUND 2,625.00 23,625.00 31,500.00 75.0 --------------------------------------------------------------------------------- TOTAL TAXES 3,649.46 382,704.85 575,209.00 66.5 CHARGES FOR SERVICES 82-000-42-00-4211 DEVELOPMENT FEES - BUILDING 28,825.00 60,550.00 121,875.00 49.6 82-000-42-00-4215 DEVELOPMENT FEES-BOOKS 28,825.00 60,550.00 121,875.00 49.6 82-000-42-00-4260 COPY FEES 136.95 1,012.25 900.00 112.4 82-000-42-00-4261 LIBRARY SUBSCRIPTION CARDS 1,650.00 7,850.00 8,000.00 98.1 82-000-42-00-4286 RENTAL INCOME 161.00 948.00 1,000.00 94.8 --------------------------------------------------------------------------------- TOTAL CHARGES FOR SERVICES 59,597.95 130,910.25 253,650.00 51.6 FINES 82-000-43-00-4330 LIBRARY FINES 304.47 3,047.39 3,000.00 101.5 --------------------------------------------------------------------------------- TOTAL FINES 304.47 3,047.39 3,000.00 101.5 MISCELLANEOUS 82-000-44-00-4432 SALE OF BOOKS 56.60 389.29 500.00 77.8 82-000-44-00-4450 MEMORIALS 0.00 1,417.00 1,000.00 141.7 --------------------------------------------------------------------------------- TOTAL MISCELLANEOUS 56.60 1,806.29 1,500.00 120.4 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 P52 DATE: 02/28/2006 UNITED .CITY OF YORKVILLE PAGE: 53 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LIBRARY FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ INTEREST 82-000-46-00-4600 INVESTMENT INCOME 1,690.76 10,157.65 1,500.00 677.1 82-000-46-00-4601 INVESTMENT INCOME-BLDG 18,130.85 119,497.16 1,250.00 9559.7 --------------------------------------------------------------------------------- TOTAL INTEREST 19,821.61 129,654.81 2,750.00 4714.7 OTHER OPERATING RECEIPTS 82-000-48-00-4801 LIBRARY EXPAN BOND PROCEEDS 0.00 7,263,880.86 0.00 100.0 --------------------------------------------------------------------------------- TOTAL OTHER OPERATING RECEIPTS 0.00 7,263,880.86 0.00 100.0 TOTAL REVENUES: 83,430.09 7,912,004.45 844,809.00 936.5 EXPENSES PERSONNEL SERVICES 82-000-50-00-5107 SALARIES-EMPLOYEES 12,823.46 123,180.04 300,000.00 41.0 62-000-50-00-5203 GROUP HEALTH INSURANCE 3,331.13 23,353.40 45,000.00 51.8 82-000-50-00-5204 GROUP LIFE INSURANCE 62.01 398.37 1,500.00 26.5 82-000-50-00-5205 DENTAL & VISION ASSISTANCE 254.11 1,997.44 4,000.00 49.9 --------------------------------------------------------------------------------- TOTAL PERSONNEL SERVICES 16,470.71 148,929.25 350,500.00 42.4 PROFESSIONAL SERVICES 82-000-61-00-5300 LEGAL SERVICES 0.00 0.00 0.00 0.0 82-000-61-00-5322 BONDING 0.00 1,014.00 2,000.00 50.7 82-000-61-00-5323 ATTORNEY 0.00 862.50 2,000.00 43.1 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL SERVICES 0.00 1,876.50 4,000.00 46.9 CONTRACTUAL SERVICES 82-000-62-00-5401 CONTRACT SERVICES 51.50 518.83 3,000.00 17.2 82-000-62-00-5407 MAINTENANCE-BLDG/JANITORIAL 300.00 2,400.00 5,000.00 48.0 82-000-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 0.00 2, 611.77 3,000.00 87.0 82-000-62-00-5412 MAINTENANCE-PHOTOCOPIER 0.00 301.86 500.00 60.3 82-000-62-00-5435 ELECTRICITY 154.18 451.97 2,500.00 18.0 82-000-62-00-5436 TELEPHONE 182.39 720.95 1,700.00 42.4 P53 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 54 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LIBRARY FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------- TOTAL CONTRACTUAL SERVICES 688.07 7,005.38 15,700.00 44.6 PROFESSIONAL DEVELOPMENT 82-000-64-00-5603 SUBSCRIPTIONS 0.00 2,199.34 4,000.00 54.9 82-000-64-00-5604 TRAINING & CONFERENCES 0.00 10.00 1,500.00 0.6 82-000-64-00-5607 PUBLIC RELATIONS 0.00 121.23 1,000.00 12.1 82-000-64-00-5616 EMPLOYEE RECOGNITION 0.00 444.51 2,000.00 22.2 --------------------------------------------------------------------------------- TOTAL PROFESSIONAL DEVELOPMENT 0.00 2,775.08 8,500.00 32.6 OPERATIONS 82-000-65-00-5800 CONTINGENCIES 156.87 742.44 14, 616.00 5.0 82-000-65-00-5802 OFFICE SUPPLIES 111.63 413.53 3,000.00 13.7 82-000-65-00-5806 LIBRARY SUPPLIES 240.42 3,052.46 8,000.00 38.1 82-000-65-00-5807 CUSTODIAL SUPPLIES 77.20 1,627.00 6,000.00 27.1 82-000-65-00-5808 POSTAGE & SHIPPING 0.00 444.00 1,000.00 44.4 82-000-65-00-5810 PUBLISHING & ADVERTISING 0.00 264.44 1,000.00 26.4 82-000-65-00-5826 MILEAGE 45.80 354.15 1,000.00 35.4 82-000-65-00-5832 VIDEOS 148.80 1,368.15 5,000.00 27.3 82-000-65-00-5833 ALARM MONITORING 145.70 785.75 1,000.00 78.5 82-000-65-00-5834 LIBRARY PROGRAMMING 150.71 3,472.31 9,500.00 36.5 82-000-65-00-5835 LIBRARY BOARD EXPENSES 0.00 74.50 500.00 14.9 82-000-65-00-5836 BOOKS-ADULT 72.66 3,999.04 9,000.00 44.4 82-000-65-00-5837 BOOKS-JUVENILE 2,496.59 5,540.16 9,000.00 61.5 82-000-65-00-5838 BOOKS-AUDIO 0.00 1,321.61 9,000.00 14.6 82-000-65-00-5839 BOOKS-REFERENCE 0.00 7,569.59 9,000.00 84.1 82-000-65-00-5840 BOOKS-DEVELOPMENT FEE 0.00 22,539.77 179,611.00 12.5 82-000-65-00-5841 MEMORIALS/GIFTS 270.90 2,092.61 6,362.00 32.8 82-000-65-00-5842 BLDG-DEVELOPMENT FEES 114,781.66 1,259,842.37 153,570.00 820.3 --------------------------------------------------------------------------------- TOTAL OPERATIONS 118,698.94 1,315,503.88 426,159.00 308.6 RETIREMENT 82-000-72-00-6500 IMRF PARTICPANTS 607.64 5,630.20 9,000.00 62.5 82-000-72-00-6501 SOCIAL SECURITY/MEDICARE 981.01 9,423.47 22,950.00 41.0 --------------------------------------------------------------------------------- TOTAL RETIREMENT 1,588.65 15,053.67 31, 950.00 47.1 P54 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 55 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LIBRARY FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ CAPITAL OUTLAY 82-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 0.00 0.00 0.0 82-000-75-00-7003 AUTOMATION 692.55 7,609.74 8,000.00 95.1 82-000-75-00-7703 BUILDING EXPANSION 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 692.55 7,609.74 8,000.00 95.1 TOTAL EXPENSES: 138,138.92 1, 498,753.50 844,809.00 177.4 TOTAL FUND REVENUES 83,430.09 7,912,004.45 844,809.00 936.5 TOTAL FUND EXPENSES 138,138.92 1,498,753.50 844,809.00 177.4 FUND SURPLUS (DEFICIT) (54,708.83) 6,413,250.95 0.00 100.0 P55 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 56 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: FOX INDUSTRIAL FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY 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 0.00 0.0 85-000-40-00-4090 TIF REVENUES 0.00 70,996.87 34,000.00 208.8 --------------------------------------------------------------------------------- TOTAL TAXES 0.00 70,996.87 34,000.00 208.8 INTEREST 85-000-46-00-4600 INVESTMENT INCOME 348.71 2,216.22 1,000.00 221.6 --------------------------------------------------------------------------------- TOTAL INTEREST 348.71 2,216.22 1,000.00 221.6 TRANSFERS 85-000-49-00-4905 TRANSFER FROM MFT FUND 0.00 31,189.68 42,664.00 73.1 --------------------------------------------------------------------------------- TOTAL TRANSFERS 0.00 31,189.68 42,664.00 73.1 TOTAL REVENUES: 348.71 104,402.77 77,664.00 134.4 EXPENSES DEBT SERVICES 85-000-66-00-6021 FOX IND BOND-PRINCIPAL PMT 0.00 55,000.00 55,000.00 100.0 85-000-66-00-6022 FOX IND BOND-INT PAYMENT 0.00 11,225.00 22,450.00 50.0 --------------------------------------------------------------------------------- TOTAL DEBT SERVICES 0.00 66,225.00 77,450.00 85.5 CAPITAL OUTLAY 85-000-75-00-7901 FOX INDUSTRIAL - NON MFT 0.00 232.50 0.00 (100.0) 85-000-75-00-7902 FOX INDUSTRIAL EXPENSES 0.00 5,067.50 0.00 (100.0) --------------------------------------------------------------------------------- TOTAL CAPITAL OUTLAY 0.00 5,300.00 0.00 (100.0) OTHER 85-000-78-00-9007 ADMINSITRATION FEES 0.00 1,106.50 214.00 517.0 85-000-78-00-9010 RESERVE-FUTURE BOND PYMTS 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL OTHER 0.00 1,106.50 214.00 517.0 P56 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 57 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: FOX INDUSTRIAL FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ TOTAL EXPENSES: 0.00 72,631.50 77,664.00 93.5 TOTAL FUND REVENUES 348.71 104,402.77 77,664.00 134.4 TOTAL FUND EXPENSES 0.00 72,631.50 77,664.00 93.5 FUND SURPLUS (DEFICIT) 348.71 31,771.27 0.00 100.0 P57 DATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 58 TIME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: COUNTRYSIDE TIF PROJECT FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ------------------------------------------------------------------------------------------------------------------------------------ REVENUES CARRY OVER 87-000-40-00-3999 CARRY OVER BALANCE 0.00 3,456,521.17 0.00 100.0 --------------------------------------------------------------------------------- TOTAL CARRY OVER 0.00 3,456,521.17 0.00 100.0 INTEREST 87-000-46-00-4600 INVESTMENT INCOME 9,245.39 82,886.78 0.00 100.0 --------------------------------------------------------------------------------- TOTAL INTEREST 9,245.39 82,886.78 0.00 100.0 TOTAL REVENUES: 9,245.39 3,539,407.95 0.00 100.0 EXPENSES OTHER FINANCING 87-000-66-00-6001 COUNTRYSIDE TIF-PRINCIPAL PMT 0.00 0.00 0.00 0.0 87-000-66-00-6002 COUNTRYSIDE TIF-INTEREST PMT 0.00 101,594.73 0.00 (100.0) --------------------------------------------------------------------------------- TOTAL OTHER FINANCING 0.00 101,594.73 0.00 (100.0) --- UNDEFINED CODE --- 87-000-78-00-9007 ADMINISTRATION FEES 0.00 0.00 0.00 0.0 --------------------------------------------------------------------------------- TOTAL --- UNDEFINED CODE --- 0.00 0.00 0.00 0.0 TOTAL EXPENSES: 0.00 101,594.73 0.00 (100.0) TOTAL FUND REVENUES 9,245.39 3,539,407.95 0.00 100.0 TOTAL FUND EXPENSES 0.00 101,594.73 0.00 (100.0) FUND SURPLUS (DEFICIT) 9,245.39 3,437,813.22 0.00 100.0 P58 IATE: 02/28/2006 UNITED CITY OF YORKVILLE PAGE: 1 'IME: 09:18:48 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 D: GL470002.WOW 75% of Fiscal Year FUND: GENERAL FUND FOR 9 PERIODS ENDING JANUARY 31, 2006 FISCAL FISCAL % ACCOUNT JANUARY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED •----------------------------------------------------------------------------------------------------------------------------------- ;ENERAL tEVENUES TAXES 01-000-40-00-3995 FUND BALANCE 0.00 0.00 0.00 0.0 01-000-40-00-3996 ROAD CONTRIBUTION FEE 162,000.00 813,098.00 550,000.00 147.8 01-000-40-00-3997 IN TOWN ROAD PROGRAM FUNDING 0.00 3,783,562.20 4,350,210.00 86.9 01-000-40-00-3998 MPI BRISTOL RIDGE RD FUNDING 0.00 40.00 4,000,000.00 0.0 01-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 50,000.00 0.0 01-000-40-00-4000 REAL ESTATE TAXES 0.00 1,387,085.39 1,393,821.00 99.5 01-000-40-00-4001 TOWN ROAD/BRIDGE TAX 0.00 101,790.99 98,000.00 103.8 01-000-40-00-4002 FOX HILL LEVY REVENUE 0.00 0.00 7,850.00 0.0 01-000-40-00-4010 PERSONAL PROPERTY TAX 1,810.34 9,947.56 10,000.00 99.4 01-000-40-00-4020 STATE INCOME TAX 38,890.34 344,481.81 638,820.00 53.9 01-000-40-00-4030 MUNICIPAL SALES TAX 232,117.31 1,522,030.03 2,308,900.00 65.9 01-000-40-00-4032 STATE USE TAX 8,054.55 59,540.43 97,006.00 61.3 01-000-40-00-4040 MUNICIPAL UTILITY TAX 113,675.29 286,028.43 500,000.00 57.2 01-000-40-00-4041 UTILITY TAX - NICOR 0.00 49,044.21 100,000.00 49.0 01-000-40-00-4042 UTILITY TAX - CABLE TV 0.00 57,346.37 65,000.00 88.2 01-000-40-00-4043 UTILITY TAX - TELEPHONE 42,608.35 260,620.95 325,000.00 80.1 01-000-40-00-4050 HOTEL TAX 1,565.11 14,597.43 20,000.00 72.9 01-000-40-00-4060 TRAFFIC SIGNAL REVENUE 0.00 0.00 5,000.00 0.0 --------------------------------------------------------------------------------- TOTAL TAXES 600,721.29 8,689,213.80 14,519,607.00 59.8 LICENSES & PERMITS 01-000-41-00-4100 LIQUOR LICENSE 50.00 12,040.80 25,000.00 48.1 01-000-41-00-4101 OTHER LICENSES 10.00 1,419.50 4,500.00 31.5 01-000-41-00-4110 BUILDING PERMITS 153,203.00 1,000,486.00 1,100,000.00 90.9 --------------------------------------------------------------------------------- TOTAL LICENSES & PERMITS 153,263.00 1,013,946.30 1,129,500.00 89.7 CHARGES FOR SERVICES 01-000-42-00-4205 FILING FEES 305.00 5,839.40 25,000.00 23.3 01-000-42-00-4206 GARBAGE SURCHARGE (10.78) 135,814.77 192,780.00 70.4 01-000-42-00-4207 REFUSE STICKERS 0.00 0.00 0.00 0.0 01-000-42-00-4208 COLLECTION FEE - YBSD 0.00 0.00 34,000.00 0.0 01-000-42-00-4209 PLANNING FEE 0.00 0.00 39,899.00 0.0 01-000-42-00-4210 DEVELOPMENT FEES 64,425.00 996,589.48 1,175,000.00 84.8 P1 UNITED CITY OF YORKVILLE DETAILED REVENUE & EXPENSE REPORT AS OF JANUARY 31, 2005 General Fund Revenue 1 Sanitary Sewer Improvement&Expansion 25 Finance 3 Water Improvement&Expansion 28 Engineering 6 Debt Service Fund 31 Police 7 Water Operations 33 Planning and Development 10 Sewer Maintenance 37 Streets and Alleys 11 Land Cash 40 Health and Sanitation 13 Land Acquisition 44 Motor Fuel Tax Fund 15 Parks& Recreation 45 Municipal Building 17 Working Cash 51 Police Equipment Capital 19 Library 52 Public Works Equipment Capital 21 Fox Industrial 56 Parks&Recreation Equipment Capital 23 Countryside TIF 58 ♦,��D C/r� Reviewed By: Legal City Council Finance EST: � "• �1836 Engineer v1 City Administrator ❑ Agenda Item Tracking Number ,r ADM 2006- 021 Consultant ❑ City Council Agenda Item Summary Memo Title: Monthly Treasurer's Report—January 2006 City Council/COW/Committee Agenda Date: Administration 2/02/06 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Traci Pleckham Finance Name Department Agenda Item Notes: United City of Yorkville Monthly Treasurer's Report Pre Audit Financial Summary As of January 31, 2006 Beginning Ending Fund Balance Revenues Expenses Transfers Balance 1 General 5,708,880.82 847,274.83 741,771.95 (67,396.33) 5,746,987.37 15 Motor Fuel Tax 164,856.81 22,648.14 18,741.78 - 168,763.17 16 Municipal Building (294,534.21) 14,200.00 1,127.89 12,660.00 (268,802.10) 20 PD Capital 145,360.21 28,796.00 1,533.11 (6,027.50) 166,595.60 21 PW Capital 345,947.15 68,350.00 20,000.00 434,297.15 22 Parks&Rec Equip Capital 10,085.38 9,750.00 - 19,835.38 37 Sanitary Sewer Improvement 11,323,296.29 296,805.44 906,417.72 (149,053.25) 10,564,630.76 41 Water Improvement Exp 1,397,673.20 246,138.60 134,198.06 (70,360.50) 1,439,253.24 42 Debt Service (406,665.87) 5,468.64 122,717.50 267,672.00 (256,242.73) 51 Water 622,829.72 45,165.58 82,591.00 (62,500.00) 522,904.30 52 Sewer 520,462.62 26,061.69 12,254.66 (25,000.00) 509,269.65 72 Land Cash (90,164.33) 6,362.67 65.00 - (83,866.66) 73 Land Acquisition 213,617.69 - 213,617.69 79 Parks&Recreation 211,051.47 19,489.54 76,829.69 77,380.58 231,091.90 82 Library 6,826,664.14 80,805.09 138,138.92 2,625.00 6,771,955.31 85 Fox Industrial (1,773.37) 348.71 - (1,424.66) 87 Countryside TIF Project 3,428,567.83 9,245.39 - 3,437,813.22 95 Trust&Agency 411,038.46 214,007.53 890,570.45 - (265,524.46) Totals 30,537,194.01 1,940,917.85 3,126,957.73 (0.00) 29,351,154.13 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 Fund 41.59%1 Water Ops 20.30%1 Sewer Maint. 52.61% Combined Fund Balance Reserve 38.25% Prepared by:Julie Ciesla-Senior Accounting Clerk 2/28/2006 LI ♦.��[1 Clr� Reviewed By: J� 0 Legal F1 City Council Finance El 1836 Engineer ❑ City Administrator F1 Agenda Item Tracking Number O � ADM 2006-22 �" �O Consultant ❑ LE City Council Agenda Item Summary Memo Title: Resolution Appointing IMRF Authorized Agent City Council/COW/Committee Agenda Date: Admin 3/2/06 Synopsis: In the absence of a Finance Director, IMRF needs a new authorized agent. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Traci Pleckham Finance Name Department Agenda Item Notes: STATE OF ILLINOIS ) )ss COUNTY OF KENDALL ) RESOLUTION 2006 - RESOLUTION APPOINTING DENISE KASPER AS THE ILLINOIS MUNICIPAL RETIREMENT FUND AUTHORIZED AGENT WHEREAS, the Mayor and the City Council of the UNITED CITY OF YORKVILLE deem it in the best interest of the UNITED CITY OF YORKVILLE to appoint an Illinois Municipal Retirement Fund Authorized Agent; and WHEREAS,the Illinois Municipal Retirement Fund Authorized Agent shall possess the powers and duties contained in Sec. 7-135 of the Illinois Pension Code; and WHEREAS, the Mayor and the City Council of the UNITED CITY OF YORKVILLE deem it in the best interest of the UNITED CITY OF YORKVILLE to appoint Denise Kasper as the United City of Yorkville Illinois Municipal Retirement Fund Authorized Agent; and IT IS HEREBY RESOLVED THAT THE UNITED CITY OF YORKVILLE appoints Denise Kasper as the United City of Yorkville Illinois Municipal Retirement Fund Authorized Agent and hereby authorizes the Mayor and City Clerk to execute any and all documentation required by the Illinois Municipal Retirement Fund. JAMES BLOCK JOSEPH BESCO VALERIE BURD PAUL JAMES JASON LESLIE MARTY MUNNS DEAN WOLFER ROSE SPEARS Page I of 2 APPROVED by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this day of ,A.D. 2006. MAYOR PASSED by the City Council of the United City of Yorkville,Kendall County, Illinois this day of ,A.D. 2006. Attest: CITY CLERK Prepared by: John Justin Wyeth City Attorney United City of Yorkville 800 Game Farm Road Yorkville, IL 60560 630/553-4350 Page 2 of 2 Reviewed By: J= 0� Legal ❑ City Council Finance ❑ EST law Engineer ❑ Agenda Item Tracking Number �; m City Administrator ❑ Consultant ❑ -CE ��` ❑ City Council Agenda Item Summary Memo Title: Maintenance Proposal for Fire Alarm System at City Hall/Police Station City Council/COW/Committee Agenda Date: Public Safety 2/9/06 Synopsis: This is a proposal from Thomas Alarm Systems to inspect the fire alarm system here at City Hall/Police Station on a semi-annual basis. Council Action Previously Taken: None Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Chief Harold Martin Police Name Department Agenda Item Notes: Yorkville Police Department Memorandum 804 Game Farm Road EST _ rF 1836 Yorkville, Illinois 60560 --�� Telephone: 630-553-4340 p y Fax: 630-553-1141 SCE ,w Date: January 31, 2006 To: Chief Harold O. Martin III From: S/Sgt. Ron Diederich Reference: Fire Alarm Chief We currently do not have anyone who checks the fire alarm system here at the City Hall/Police Station. I have asked Thomas Alarm for a quote and they have supplied one - $600.00 yearly. For this fee they will check our fire control panel, manual pull stations, horn/strobes, smoke detectors and any other fire detection devices. These inspections will be carried out on a semi-annual basis. Today I met with spoke with Bill Dettmer and discussed the Thomas Alarm quote. He told me it sounded like they are providing a good service at a very reasonable price. I have attached a copy of the quote for your consideration and I will get with you to discuss any questions you may have. Respectfully, r S/Sgt. Ron Diederich 01/30/2006 13:23 6305530812 THOMAS ALARMS PAGE 01/01 711 North Bridge Street Thomas Alarm Systems Yorkville,Illinois 60560 Phone:630.553.4560 Fax:630.553.0805 Entail AlarmSysm @aol.com January 30,2006 Yorkville Police Depart ont 804 Game Farm Road Yorkville,Illinois 60560 630.553.8507 630.553.1141 -Fax Attn:Ron Diederich PROPOSAL Job Sites: United City of Yorkville&Police Department,804 Game Farm Road,Yorkville,Illinois Annual Service and Testina: At the above locations,we respond within a 24 hour period to service any problems with the Fire alarm control panel,Manual Pull Stations,Horn/Strobes,Addressable Modules,Duct Smoke Detectors,Smoke Detectors,and any other Fire detection or annunciation devices. We will repair at the owners expense any problems found after gaining the owners approval of such a repair. We will respond within a four hour period to emergency service requests for after hour or weekend service. Our regular service hours are Monday thtu Friday from 7:30 to 3:30 at a 2 hour minimum of$90.00 per hour. Emergency service is billed at a four hour minimum @ time and one half,Sundays and Holidays are a four hoar minimum of double time. We will also test your buildings semi-annually,as per NFPA/UL requirements this,includes the Fire alarm control panel,Manual Pull Stations,Horn/Strobes,Addressable Modules,Duct Smoke Detectors, Smoke Detectors,and any other Fire detection or annunciation devices.This test report will be dated and certified by our professional technicians for submitting to the authority having jurisdiction and your insurance provider to satisfy their requirements for testing your fire alarm system. This Annual Service Agreement does not include monitoring charges of your fire alarm system,at this time but it can be added to the agreemept. TOTAL ANNUAL SERVICE PER THE ABOVE MENTIONED BUILDINGS SHALL BE SIX HUNDRED NINETY DOLLARS AND NO/100 EACH $600.00 If you have any questions,please feel'free to give me a call. Respectfully submitted by: Jay VeGrand for Thom-as-arm,Systems Accepted By Nd -45 C/p� Reviewed By: J2 � Legal F-1 City Council EST. , 7 1836 Finance ❑ Engineer 2lzto6 City Administrator El Item Tracking Number Consultant ❑ SCE �V City Council Agenda Item Summary Memo Title: Project Manager—Proposed Position&Job Description City Council/COW/Committee Agenda Date: PW Committee 2/6/06 Synopsis: This proposal is to create a new job position within the Engineering Department called Project Manager. The position is proposed to be filled next fiscal year. Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Majority Council Action Requested: Approval Submitted by: Joe Wywrot Engineering Name Department Agenda Item Notes: Co.o United City of Yorkville Memo J 0 800 Game Farm Road EST 1636 Yorkville, Illinois 60560 Telephone: 630-553-8545 09 o Fax: 630-553-3436 Date: February 2, 2006 To: John Crois, Interim City A strattor From: Joe Wywrot, City Engineer U CC: Denise Kasper, Payroll Benefi Sped ist Liz D'Anna, Administrative Assistant Subject: Project Manager—Proposed Position&Job Description Attached find a draft copy of a job description for a new position that I would like to create for the Engineering Department. The job position would be called Project Manager. This person would perform some of the more routine tasks that I currently perform. This will enable me to perform plan reviews in a more timely manner, continue to prepare plans and specifications for city-funded projects, and in general perform my job at a higher level. Project Manager is a responsible position that would process payouts, change orders, letter of credit reductions,prepare punchlists,be involved in testing of new infrastructure, ensuring compliance with Site Development Permits, and perform a limited amount of minor site plan review. This position performs engineering-related tasks,but would not require an engineering degree. The salary range would be the same as for Senior Engineering Technician. The amount of development occurring in Yorkville is staggering. This position will help us keep up with the pace of development without sacrificing the quality of our work. I recommend that one Project Manager job position be approved for the upcoming fiscal year, with the intent of filling the position by May 1, 2006. Please place this item on the Public Works Committee agenda for consideration. city 02 0 � - ux It ° UNITED CITY OF YORKVE= PROJECT MANAGER—JOB DESCRIPTION(Draft 2-2-2006) Department: Engineering Reports to: City Engineer Status: Full Time,Non-exempt Pay Classification: Project Manager(range same as Senior Engineering Technician) Position Description Overview This individual will be responsible for tracking bonds/letters of credit for development activities, processing reductions to bonds and letters of credits, performing site plan reviews, reviewing record drawings, coordinating punchlist inspections, and ensuring compliance with state- mandated requirements such as NPDES permits, highway permits, EPA permits, etc. This individual will also work with Engineering Technicians on city-funded projects with respect to resident notifications, resolution of resident concerns, and processing of change orders and payouts. Work with Engineering Technicians to track testing of infrastructure improvements. This position also provides support for the Geographic Information System, and AutoCAD work as required. All work is performed under the general supervision of the City Engineer. Essential Job Functions 1. Maintain bond/letter of credit summary information. 2. Process bond/letter of credit reductions. Take reduction from developer request, through City Council approval,to developer notification or City Council action. 3. Perform minor site plan reviews as assigned by the City Engineer. 4. Review record drawings for accuracy,thoroughness, and legibility. 5. Assign and coordinate punchlist inspections and re-inspections by field personnel. Prepare punchlist letters and work with developers to complete required work. 6. Create/update general AutoCAD files as required. 7. Work with Community Relations Director regarding resident notification of City-funded projects, as well as projects by private developers that affect neighboring properties. 8. Respond to requests/requirements of other governmental agencies regarding permits. 9. Process payouts and change orders through appropriate channels. 10. Coordinate/track public infrastructure testing with engineering technicians. 11. Perform site inspections to ensure compliance with site development permit requirements. 12. Respond to resident concerns regarding city and developer projects. 13. Coordinate Engineering Department support for the city's Geographic Information System. 14. Various other duties and responsibilities as directed by the Engineer. Position Requirements—Knowledge, Skills, and Abilities 1. Demonstrate a broad-based knowledge of Microsoft Excel and Microsoft Word programs. Demonstrate knowledge of AutoCAD software sufficient to create customized drawings for general civil engineering and mapping applications. 2. Ability to operate a variety of office equipment, including but not limited to computer, typewriter, copier, fax, scanner, large-scale plotter, and calculator, with minimal supervision. 3. Display professionalism and maintain strict confidentiality. 4. Exhibit mathematical and analytical qualities. 5. Possess proficient customer service skills. 6. Excellent communication and writing skills. 7. Highly organized and able to prioritize job assignments. Minimum and Preferred Experience and Education 1. 64 college course credit hours with special emphasis on Engineering/Technical Fields, Data Management; Two or more years of progressively responsible experience within a municipal engineering department; or, an equivalent combination of education and experience sufficient to perform the essential duties of the job as those listed above. 2. Willingness to attend training classes to increase knowledge of job-related skills and responsibilities. 3. Possession of valid Illinois Driver's License. The duties listed above are intended only as an illustration of the various types of tasks that may be required. The omission of specific statements of duties does not exclude them from the position if the work is similar, related, or a logical assignment to the position. This job description does not constitute an employment agreement between the employer and employee, and is subject to modification by the employer as the needs of the employer and/or agency change, or requirements of the position change. Reviewed By: J=♦ �� Legal ■ City Council Finance ■ EST. leas Engineer ❑ C . �;� � � City Administrator ■ Agenda Item Tracking Number Consultant ❑ A[,)A'1 e C c�):1J <LE ❑ City Council Agenda Item Summary Memo Title: Attorney Hours Spreadsheet and Job Description City Council/COW/Committee Agenda Date: Admin.—March 2, 2006 Synopsis: Spreadsheet documenting hours spent by Atty. Wyeth for City, and draft job description Council Action Previously Taken: Date of Action: None Action Taken: Item Number: Type of Vote Required: N/A Council Action Requested: Submitted by: Bart Olson Admin Name Department Agenda Item Notes: Document 1) Spreadsheet outlining hours billed by Attorney Wyeth for 2005 Document 2) Draft job description for Corporation Counsel Summary of Document 1 —511.25 paid hours by the City(312 hours billable to the developers) equals roughly 1/4 FTE. UNITED CITY OF YORKVILLE LEGAL SERVICES PAID TO ATTORNEY JOHN WYETH 1/01/05 THRU 12/31/05 HOURS BILLED @ $150 PER DEPARTMENT AMOUNT PAID HOUR ARO-BILLABLE TO DEVELOPERS $ 46,793.75 312.00 ADMINISTRATION $ 51,337.50 342.25 POLICE DEPARTMENT $ 525.00 3.50 BUILDING & ZONING $ 9,825.00 65.50 STREETS $ 37.50 0.25 SEWER IMPROVEMENT $ 9,900.00 66.00 WATER IMPROVEMENT $ 2,137.50 14.25 WATER OPERATIONS $ 375.00 2.50 SEWER OPERATIONS $ 37.50 0.25 PARK & RECREATION $ 1,650.00 11.00 LIBRARY $ 862.50 5.75 GRAND TOTAL $ 1239481.25 823.25 UNITED CITY OF YORKVILLE CORPORATION COUNSEL—JOB DESCRIPTION Department: Administration Reports to: Mayor Status: Position Description Overview Under administrative directions of the Mayor, serves as legal counsel for the United City of Yorkville; advises and represents the City in legal actions; researches legal questions and drafts ordinances, resolutions, and legal opinions; supervises Assistant City Attorneys and clerical staff. Essential Job Functions 1. Advise City Council, boards and commissions, department heads, and other City staff members on legal procedures and the legal ramifications of management decisions. 2. Draft ordinances, resolutions, and legal opinions upon the request of the Mayor, members of the City Council, or department heads. 3. Prepare written legal opinions based upon questions submitted to the City Administrator for legal evaluation. 4. Instruct City staff members on legal procedures. 5. Monitor case law and legislative developments to assess impact on City. 6. Represent the City in litigation to which it is a parry, including injunction proceedings, challenges to City ordinances, City code violations and other civil actions. 7. Prepares complaints or statements of charges against employees which the City wishes to discipline. 8. Meets with citizens concerning legal problems in which city is involved. 9. Reviews and drafts all legal agreements with governmental agencies, consultants, service providers. Also drafts contracts for purchase or sale of property, etc. 10. Acts as office administrator and assigns work of assistant counsel. 11. Complies with all personnel safety rules and regulations, both written and verbal. 12. Performs other related duties as directed. Requirements 1. Thorough knowledge of local ordinances, State laws, and established precedents. 2. Thorough knowledge of court procedures and rules of evidence. 3. Ability to research questions regarding points of law and to draft appropriate responses. 4. Ability to draft ordinances, resolutions, and other legal documents. 5. Ability and skill in preparing and trying cases. 6. Ability to communicate effectively both orally and in writing. 7. Requires the skills in the use of standard office machinery,personal computers, 10-key calculators, and familiarity with spread sheet(Excel)and word processing (Word) software. 8. Ability to establish and maintain satisfactory working relationships with City officials, attorneys, and other professionals, law enforcement officials, and the general public. 9. Ability to handle confidential information with tact and diplomacy. Experience and Education 1. License to practice law in the State of Illinois 2. Five years experience as a licensed attorney,preferably in municipal law and litigation. 3. Valid Driver's License. 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. ♦A C/ Reviewed By: Legal ❑ City Council EST. 1838 Finance ❑ Engineer ❑ 0 City Administrator ❑ Agenda Item Tracking Number '?O Consultant ❑ ADM 2006-24 <LE ❑ City Council Agenda Item Summary Memo Title: Salary Increases for the Next Fiscal Year(Cola/Merit) City Council/COW/Committee Agenda Date: Admin 3/2/06 Synopsis: Council Action Previously Taken: Date of Action: Action Taken: Item Number: Type of Vote Required: Council Action Requested: Submitted by: Traci Pleckham Finance Name Department Agenda Item Notes: Cable 1. Consumer Price Index for All Urban Consumers (CPI-U): U. S. City Average,by expenditure category and commodity and service group Page 1 of 5 r .M Ruivau of Labor Sloflslics Washington,D C 20212 BLS Home I Programs &Surveys Get Detailed Statistics Glossary ( What's New Find Itl In DOL , CPI Home JPTFTR AVAILABLE ECONOMIC NEWS REIN Table 1. Consumer Price Index for All Urban Consumers (CPI-U): U. S. City Average, Table 1. Consumer Price Index for All Urban Consumers (CPI-U) : U.S. city average, by expenditure category a and service group (1982-84=100, unless otherwise noted) Unadjusted Relative Unadjusted indexes percent change to Seasonally adjusted importance, Dec. 2005 from- percent change from- CPI-U December 2004 Nov. Dec. 2005 2005 Dec. Nov. Sep. to Oct. to Nov, to 2004 2005 Oct. Nov. Dec. Expenditure category All items. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100.000 197.6 196.8 3.4 -0.4 0.2 -0.6 -0.1 All items (1967=100) . . . . . . . . . . . . . . . . . . . . . . . . . - 592.0 589.4 - - - - Food and beverages. . . . . . . . . . . . . . . . . . . . . . . . . . 15.291 192.8 193.2 2.3 0.2 0.3 0.3 0.1 Food. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14.295 192.4 192.9 2.3 0.3 0.3 0.3 0.2 Food at home. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8.183 191.0 191.7 1.7 0.4 0.3 0.3 0.1 Cereals and bakery products. . . . . . . . . . . . . . 1.185 209.1 208.4 1.0 -0.3 0.6 0.2 -0.2 Meats, poultry, fish, and eggs. . . . . . . . . . . 2.272 185.8 185.7 1.4 -0.1 -0.2 0.7 0.0 Dairy and related products. . . . . . . . . . . . . . . .849 183.5 183.2 1.7 -0.2 0.0 0. 9 -0.3 Fruits and vegetables. . . . . . . . . . . . . . . . . . . . 1.276 246.4 252.3 0.6 2.4 1.3 -0.2 0.9 Nonalcoholic beverages and beverage materials. . . . . . . . . . . . . . . . . . . . . . . . . . . . .884 145.5 145.5 3.5 0.0 -0.1 0.8 -0.5 Other food at home. . . . . . . . . . . . . . . . . . . . . . . 1.716 167.3 167.6 2.4 0.2 0.4 -0.3 0.3 Sugar and sweets. . . . . . . . . . . . . . . . . . . . . . . . .296 166.5 167.8 4.0 0.8 0.5 0.7 1.0 Fats and oils. . . . . . . . . . . . . . . . . . . . . . . . . . . .258 166.2 165.2 -1.3 -0.6 -0.9 0.1 -0.4 Other foods (1) . . . . . . . . . . . . . . . . . . . . . . . . . 1.163 183.0 183.3 2.8 0.2 0.5 -0.5 0.2 Other miscellaneous foods (1) (2) . . . . . . .301 112.7 112.4 1.4 -0.3 0.5 0.5 -0.3 Food away from home (1) . . . . . . . . . . . . . . . . . . . 6.113 195.6 196.0 3.2 0.2 0.3 0.2 0.2 httn-//www.bls.Lyov/news.release/ct)i.tOl.htm 2/13/2006 Chicago Area Consumer Price Index Page 1 of northeastern illinois planning commission Consumer Price Index for the Chicago Consolidated Metropolitan Statistical Area* The Consumer Price Index (CPI) measures the average change over time in the prices paid by urban consumers for a fixed market basket of consumer goods and services. The CPI provides a way to compare what this market basket of goods and services currently costs compared to the cost of the same market basket a month, a year, or a decade ago. In the.Chicago metro area, for example, these representative goods and services cost 3.6% more in December 2005 than they did in December 2004. Looking at CPI annual averages for our area, this same market basket cost 3.0% more in 2005 than it did in 2004. . All Urban Consumers-(CPI-U) . Chicago CMSA* • All Items • 1982-84=100 Percent Chanae Year Dec.- Year- Year tea.. Feb. Mar. APL May June Ally An. 39R. Qr.L Nov. Dec. AM Dec. YOM 2005 189.9 190.5 191.3 193.2 193.3. 194.0 194.2 195.8 198.3 197.9 197.3 196.4 194.3 3.6% 3.0% 2004 185.4 186.4 186.3 187.2 188.7 189.1 189.2 190.2 190.0 190.8 190.7 189.6 188.6 2.2% 2.2% 2003 182.7 184.1 184.8 183.4 183.4 184.1 184.1 184.5 186.1 185.8 185.6 185.5 184.5 1.7% 1.8% 2002 177.9 178.7 179.8 180.9 181.4 182.1 181.2 181.6 182.1 182.8 183.2 182.4 181.2 2.5% 1.6% 2001 178.1 178.5 177.1 178.4 179.8 179.2 177.7 178.1 179.7 178.1 177.4 177.9 178.3 1.2% 2.6% 2000# 170.2 171.4 172.2 171.9 173.7 176.0 174.6 173.7 174.8 175.4 176.0 175.8 173.8 3.9% 3.2% 1999 166.1 166.4 167.0 167.6 168.2 168.9 169.4 169.3 169.7 169.7 169.3 169.2 168.4 2.5% 2.1% 1998 162.8 163.1 164.1 164.8 165.6 166.0 166.5 165.4 165.3 165.7 165.4 165.1 165.0 1.4% 2.0% 1997 160.4 161.1 161.0 160.9 161.1 161.7 161.7 162.5 162.1 162.5 162.9 162.8 161.7 1.9% 2.7% 1996 154.6 155.2 156.3 156.4 156.9 157.6 157.7 158.1 158.3 158.8 159.4 159.7 157.4 3.8% 2.7% 1995 151.8 152.3 152.6 153.1 153.0 153.5 153.6 153.8 154.0 154.3 154.0 153.8 153.3 2.2% 3.2% 1994 146.5 146.8 147.6 147.9 147.6 148.1 148.3 149.8 150.2 149.4 150.4 150.5 148.6 3.0% 2.2% 1993 143.2 143.6 144.1 144.7 145.7 145.6 145.5 146.1 146.7 147.2 146.4 146.1 145.4 2.2% 3.0% 1992 138.9 139.2 139.7 139.8 140.5 141.2 141.4 141.9 142.7 142.1 142.4 142.9 141.1 3.3% 3.0% 1991 135.1 135.5 136.2 136.1 136.8 137.3 137.3 137.6 138.3 138.0 138.0 138.3 137.0 2.7% 4.0% 1990 128.1 129.2 129.5 130.4 130.4 131.7 132.0 133.2 133.8 133.3 134.2 134.6 131.7 6.4% 5.4% 1989 121.5 122.2 123.0 123.6 123.9 125.7 126.4 126.4 127.1 126.8 126.7 126.5 125.0 4.3% 5.0% 1988 115.3 116.6 116.9 117.1 117.0 118.9 119.8 120.1 122.0 121.6 121.0 121.3 119.0 4.8% 3.9% 1987 111.9 111.9 112.3 112.8 113.3 115.5 115.9 116.7 117.1 115.1 115.7 115.7 114.5 4.4% 4.1% 1986 109.2 109.3 108.4 108.3 108.5 110.6 110.8 110.9 111.8 110.0 110.9 110.8 110.0 1.6% 2.1% 1985 105.5 106.0 106.2 106.8 107.0 108.5 108.6 109.1 109.2 108.0 108.5 109.1 107.7 3.8% 3.8% 1984 102.2 102.1 102.3 102.7 102.8 103.7 104.0 104.9 105.5 105.1 105.1 105.1 103.8 3.3% 3.8% 1983 98.4 98.3 98.3 98.8 99.2 99.9 100.3 101.0 101.4 101.2 101.7 101.7 100.0 3.7% 4.0% 1982 92.2 92.0 92.5 93.8 96.3 97.7 98.1 98.1 98.4 98.5 98.5 98.1 96.2 7.0% 6.9% 1981 86.7 86.9 86.9 88.3 88.5 90.1 91.3 92.3 92.7 92.4 92.7 91.7 90.0 5.3% 9.5% 1980 77.1 77.9 78.8 80.4 81.4 83.1 82.6 82.1 83.7 84.9 87.0 87.1 82.2 14.0% 14.5% 1979 66.8 67.8 69.2 69.9 70.3 71.5 72.8 73.2 74.1 74.2 75.6 76.4 71.8 14.9% 12.5% 1978 61.1 61.7 62.4 62.7 63.3 63.7 64.1 64.1 64.9 65.4 66.3 66.5 63.8 10.5% 8.5% 1977 56.7 57.3 57.7 58.2 58.4 58.6 59.0 59.3 59.7 59.8 60.0 60.2 58.8 6.4% 6.3% Source: Bureau of Labor Statistics, U.S. Department of Labor. *The Chicago CMSA consists of 13 counties. They are Cook, DuPage, Kane, Lake, McHenry, Will, DeKalb, Grundy, Kankakee, anc Kendall Counties in Illinois; Lake and Porter Counties in Indiana; and Kenosha County in Wisconsin. http://www.nipc.org/foree.asting/cpi-chgo.ht3n 2/13/200( 16 IPAL OFFICERS )fficers: At the first meeting of the fiscal year after the election of the Mayor meeting,the Mayor by and with the advice and consent of the City Council shall appoint the following officers: City Administrator, Director of Finance, Director of Public Works, Chief of Police, Director of Parks and Recreation, Building Inspector/Zoning Officer, City Engineer, City Attorney, Budget Officer. Each appointment shall run until the removal from office of the officer(See Section 1-6-2), or until the appointment of a new officer to the office. If any officer is under contract with the City,the term of office in the contract shall control,however,the duration of any contract of employment for an officer shall not extend beyond the term of the Mayor. SECTIONS AMENDED TO BECOME CONSISTENT WITH THIS NEW SECTION 1-6-1: Finance Director: 1-7-10 (13)(1) add at the end the following phrase: "at the time stated in Section 1-6-1." Delete 1-7-10 (B)(2)which is no longer necessary. Renumber"Y' as 662". Executive Director of Parks and Recreation: 2-5-9-2(A) add at the end the following phrase: "at the time stated in Section 1-6-1." Delete 2-5-9-2(B)which is no longer necessary. Reletter "C" as`B" NEW SECTION 1-6-9: CITY DEPARTMENTS The United City of Yorkville shall provide its services, and conduct its business via a departmental structure. The following shall be the standing departments of the City with the related department head: Department Department Head Administration Department City Administrator Finance Department Director of Finance Public Works Department Director of Public Works Police Department Chief of Police Parks and Recreation Department Director of Parks and Recreation Building Safety and Zoning Department Building Inspector/Zoning Officer Engineering Department City Engineer Community Development Department Director of Community Development This City Code may contain specific provisions regarding each of these departments, and the Department Heads.