Loading...
Administration Packet 2005 09-01-05 .„„ cry o,,, J2� United City of Yorkville „PrrN8800 Game Farm Road EST. twiten 1836 Yorkville, Illinois 60560 \ K5/ Telephone: 630-553-4350 Fax: 630-553-7575 AGENDA ADMINISTRATION COMMITTEE MEETING Thursday, September 1,2005 6:30 P.M. CITY CONFERENCE ROOM Presentation: None Old Business: 1. Minutes for Approval/Correction: July 7, 2005 and August 4, 2005 2. Monthly Budget Report for July 2005 3. Treasurer's Report for July 2005 4. Powers of Council as it Relates to 1 and 4 Year Appointments 5. Clerk and Treasurer—Elected or Appointed Positions 6. Salary Survey: Mayor, Aldermen, Clerk, and Treasurer 7. FY 04/05 Audit Update 8. Rob Roy Creek Interceptor 18 Million Alternate Revenue Bond - Update New Business: 1. Raintree Village II — SSA Proposing Ordinance 2. IML Risk Management Association Second Quarter Minimum-Maximum Status Report 3. Assistant City Administrator Job Description 4. Historical Street Naming Procedures Additional Business: x,6-047 . cso co). United City of Yorkville Memo ` -0 800 Game Farm Road EST. " " �4 1836 Yorkville, Illinois 60560 IM11 S Telephone: 630-553-4350 .a p Fax: 630-553-7575 4LE, w‘i Date: August 30, 2005 To: Mayor and Aldermen From: John Justin Wyeth, City Attorney Subject: Appointment of City Officers The Officers appointments are authorized by Illinois Municipal Code Section 3.1-30-5 (65 ILCS 3.1-30-5). A list is provided at Section 3.1-30-5(a) which includes"a marshal", "an attorney", "a commissioner of public works", "a budget director" and "other officers necessary to carry into effect the powers conferred upon municipalities." To the extent that United City of Yorkville Officers are not specifically called out,the last, italicized portion shall include all current COY Officers, and therefore, we can look to this section as the underlying authorization to appoint officers. We then look to our Yorkville City Code to determine what offices have been established. The office and the City Code Section for the offices established in Yorkville are as follows: City Engineer 1-6-1 Building Inspector 1-6-1 Director of Public Works 1-6-1 City Attorney 1-6-1 Chief of Police 1-6-1 Director of Finance 1-7-10 Executive Director of Parks and Recreation 2-5-9 ("Recreation Director" listed in 1-6-1) There is no code section establishing"City Administrator" as an officer at this time. The Deputy City Clerk is appointed by the City Clerk. The Library Director is appointed by the Library Board. Section 3.1-30-5(c)provides the following guidance for the duration of the appointment: "The city council or board of trustees of a municipality, by ordinance not inconsistent with this Code,may prescribe the duties, define the powers, and fix the term of office of all appointed officers of the municipality; but the term of office, except as otherwise expressly provided in this Code, shall not exceed that of the mayor or president of the municipality." There does not appear to be any"otherwise expressly provided"provisions effecting the term for the COY officers. Therefore, it is my opinion that you may set a term for the offices listed above in a duration of 1, 2, 3, or 4 years, or a defined term of"until the next election whereby a the mayor is elected." Note,the persons now holding the Offices of Chief of Police and Executive Director of Parks and Recreation have multi-year contracts. Durations should take into account these present contracts. It is my opinion that all appointments, and the durations should be contained in one Code Section, Section 1-6-1 could be re-written to accomplish this Goal and modernize the text that now exists. NOTE: [There is a"Budget Officer" established by Section 1-7-1. It does appear that this office has been appointed for at least several years. My brief review of this section leads me to believe that the duties of the "Budget Officer"have been assumed by the combination of the City Treasurer and/or Director of Finance. Subject to sufficient further investigation to confirm my initial opinion, the "Budget Officer" could be discontinued.] x 65 ILCS 5/3.1-25-95 MUNICIPALITIES 38 i 39 as provided in Section 3.1-10-50. Whenever an election is reason of death, permanent physical or mental disability, exercise o held for this purpose, the municipal clerk shall certify the conviction of a disqualifying crime, or dismissal from or The train office to be filled and the candidates for that office to the abandonment of office,the mayor or president of the munici- provided election authorities as provided in the general election law. pality may appoint a temporary successor to the officer. employing During the period from the time a vacancy occurs until a Laws 1961, p. 576, § 3.1-30-5, added by P.A. 87-1119, § 2, i may requ clerk, assessor, collector, or supervisor is elected and has eff.May 13, 1993. Amended by P.A.88-537,§ 5,eff.March municipal qualified, the vacancy may be filled by appointment by the 14,1994. auxiliary president and board of trustees of that incorporated town Formerly Ill.Rev.Stat.,ch.24,4 3.1-30-5. and no pe voting jointly. During the period from the time a vacancy ! that pers occurs until a president is elected and has qualified, the For purpose of P.A.87-1119,see note following 65 ILCS 5/3.1-5-5. involving vacancy may be filled by appointment by the board of trustees of that incorporated town. 5/3.1-30-10. Deputy clerk (c) The Laws 1961,p.576, § 3.1-25-95, added by P.A. 87-1119, § 2, § 3.1-30-10. Deputy clerk. Civil AAs eff.May 13,1993. (a) In municipalities with a population of 500,000sation or more, their des Formerly Ill.Rev.Stat.,ch.24,4 3.1-25-95. the municipal clerk may appoint the number of deputy clerks Laws 19E 110 ILCS 5/1-1 et seq. necessary to discharge the functions and duties of the office eff.May For purpose of P.A.87-1119,see note following 65 ILCS 5/3.1-5-5. of municipal clerk. (b) In municipalities of less than 500,000, the municipal Formed: DIVISION 30. APPOINTED OFFICERS clerk, when authorized by the corporate authorities, may 1820 IL IN ALL MUNICIPALITIES appoint one deputy clerk,who need not be a resident of the For pur) municipality. Section Laws 1961, p. 576, § 3.1-30-10, added by P.A. 87-1119, § 2, 5/3.1-30 5/3.1-30-5. Appointed officers in all municipalities. eff.May 13,1993. § 3.1-; 5/3.1-30-10. Deputy clerk. Formerly Ill.Rev.Stat.,ch.24,4 3.1-30-10. point, di: 5/3.1-30-15. Clerk as collector. For purpose of P.A.87-1119,see note following 65 ILCS 5/3.1-5-5. municipa 5/3.1-30-20. Auxiliary policemen. 5/3.1-30-21. Part-time police. ordinanc 5/3.1-30-25. Municipalities incorporated under special Acts. 5/3.1-30-15. Clerk as collector officers § 3.1-30-15. Clerk as collector. If,in any municipality,a Enforces 5/3.1-30-5. Appointed officers in all municipalities collector is appointed, the corporate authorities may provide Part-t: § 3.1-30-5.Appointed officers in all municipalities. by ordinance that the clerk shall hold the office of collector. police df Laws 1961, p. 576, § 3.1-30-15, added by P.A.87-1119, § 2, police of (a) The mayor or president, as the case may be, by and eff.May 13,1993. to super with the advice and consent of the city council or the board of departm trustees, may appoint(1)a treasurer(if the treasurer is not Formerly I11.Rev.Stat.,ch.24,¶3.1-30-15. ermans For purpose of P.A.87-1119,see note following65 ILCS 5/13.1-5-5. p an elected position in the municipality), (2) a collector, (3) a PrP cers. comptroller, (4) a marshal, (5) an attorney or a corporation Part-t counsel, (6) one or more purchasing agents and deputies, (7) 5/3.1-30-20. Auxiliary policemen governn the number of auxiliary policemen determined necessary by § 3.1-30-20. Auxiliary policemen. ing Act the corporate authorities, (8) police matrons, (9) a commis- (a) Auxiliary policemen shall not be members of the regu- police o sioner of public works, (10) a budget director or a budget lar police department of the municipality. Auxiliary police- Training officer, and (11) other officers necessary to carry into effect men shall not supplement members of the regular police after Ja the powers conferred upon municipalities. department of any municipality in the performance of their under S (b) By ordinance or resolution to take effect at the end of assigned and normal duties, except as otherwise provided in directly the current fiscal year, the corporate authorities, by a two- this Code. Auxiliary policemen shall only be assigned to Laws 1! thirds vote,may discontinue any appointed office and devolve perform the following duties in a municipality: (i) to aid or eff.Jan. the duties of that office on any other municipal officer. After direct traffic within the municipality, (ii) to aid in control of 150 II discontinuance, no officer filling the office before its discon- natural or man made disasters,and (iii)to aid in case of civil tinuance shall have any claim against the municipality for disorder as directed by the chief of police. When it is 2 50 II salary alleged to accrue after the date of discontinuance. impractical for members of the regular police department to (c) Vacancies in all appointed municipal offices may be perform those normal and regular police duties,however,the 5/3.1-3 filled in the same manner as appointments are made under chief of police of the regular police department may assign subsection (a). The city council or board of trustees of a auxiliary policemen to perform those normal and regular § 3.1 municipality, by ordinance not inconsistent with this Code, police duties. Identification symbols worn by auxiliary po- Acts. ' may prescribe the duties,define the powers,and fix the term licemen shall be different and distinct from those used by ed and of office of all appointed officers of the municipality; but the members of the regular police department. Auxiliary police- require term of office,except as otherwise expressly provided in this men shall at all times during the performance of their duties referre Code, shall not exceed that of the mayor or president of the be subject to the direction and control of the chief of police of i resolut municipality. the municipality. Auxiliary policemen shall not carry fire- of the (d) An appointed officer of a municipality may resign from arms, except with the permission of the chief of police and of thos his or her office. If an appointed officer resigns, he or she while in uniform and in the performance of their duties. he shall continue in office until a successor has been chosen and Auxiliary policemen,when on duty,shall also be conservators bond rt, has qualified. If there is a failure to appoint a municipal of the peace and shall have the powers specified in Section officer, or the person appointed fails to qualify, the person 3.1-15-25. Laws 7 fillingthe office shall continue in office until a successor has (b) Auxiliaryeff.Ma policemen,before entering upon any of their been chosen and has qualified. If an appointed municipal duties, shall receive a course of training in the use of Forme officer ceases to perform the duties of or to hold the office by weapons and other police procedures appropriate for the For p , 4 D cir o United City of Yorkville Memo '" 800 Game Farm Road �r EST. 4 `-��itmAme 1836 Yorkville, Illinois 60560 Telephone: 630-553-4350 P 51 ..., - 4 .A 0 Fax: 630-553-7575 1-4 Date: August 8, 2005 To: Administration Committee From: Bart Olson, Administrative Intern CC: Tony Graff, City Administrator Subject: Clerk and Treasurer Survey Municipality Population Home Clerk Treasurer Rule? Cherry Valley 2,221 No Appointed Appointed Palos Park* 4,758 No Elected Appointed (see below) Berkeley 5,063 Yes Elected Appointed (Village Administrator) Highwood 5,494 No Elected Elected Plano 5,855 No Elected Elected Minooka 6,365 No Appointed Appointed Sandwich 6,850 No Elected Elected Sugar Grove 7,541 No Appointed Appointed Flossmoor 9,389 No Elected Appointed (Village Manager) Montgomery 10,459 No Elected Appointed (Finance Director) Shorewood 10,987 No Elected Appointed Channahon 11,038 Yes Elected Appointed (Finance Director) Morris 12,479 No Elected Elected (but has a full-time appointed treasurer as well) Warrenville 13,293 Yes Elected Elected North Aurora 13,677 No Elected Elected Mokena 16,529 No Elected Appointed (Finance Director) Macomb 18,782 No Elected Elected Oswego 20,946 No Appointed Appointed (Finance Director) Lisle 22,321 No Elected Appointed (Finance Director) Geneva 22,913 No Elected Elected Roselle 23,367 No Elected Appointed (Finance Director O'Fallon 24,547 No Elected Elected Plainfield 24,647 No Appointed Appointed Collinsville 25,384 No Appointed Appointed Batavia 26,901 No Elected Elected *Palos Park has a commission form of government. Clerk's position was changed by referendum from appointed to elected in the 90s. Treasurer's position is appointed,but is usually filled by the elected Commissioner of Accounts and Finance. Wilmette 27,104 Yes Appointed Appointed (Finance Director) (Village Manager) Oak Forest 28,078 Yes Elected Elected Mundelein 32,651 Yes Elected Appointed (Finance Director) Woodridge 33,943 Yes Elected Appointed (Finance Director) Elk Grove 34,136 Yes Appointed Appointed (Finance Director) Park Ridge 37,185 Yes Elected Appointed (Finance Director) Buffalo Grove 43,152 Yes Elected Appointed Hoffman Estates 49,823 Yes Elected Appointed (Finance Director) Orland Park 54,781 Yes Elected Appointed (Finance Director) Des Plaines 56,229 Yes Elected Appointed (Finance Director) Tinley Park 56,274 Yes Elected Appointed IN THE CITY COUNCIL OF THE UNITED CITY OF YORKVILLE, ILLINOIS ORDINANCE NO.2005- AN ORDINANCE authorizing the issuance of General Obligation Bonds (Alternate Revenue Source) Series 2005 of the United City of Yorkville, Kendall County, Illinois, in an aggregate principal amount not to exceed $12,000,000 for the purpose of financing certain sanitary and sewer infrastructure improvements within the City BE IT ORDAINED BY THE CITY COUNCIL OF THE UNITED CITY OF YORKVILLE, KENDALL COUNTY, ILLINOIS, AS FOLLOWS: WHEREAS, the City Council (the "Corporate Authorities") of the United City of Yorkville, Kendall County, Illinois (the "City"), has determined that it is advisable, necessary and in the best interests of the City that it construct certain sanitary and sewer infrastructure improvements within the City(the "Project"); and WHEREAS, the estimated cost of making such improvements and paying costs in connection therewith is not greater than $12,000,000, and there are insufficient funds on hand and lawfully available to provide the funds for such Project; and WHEREAS, amounts needed to finance the Project and to pay costs incurred in connection with issuing bonds for such purpose are expected to be paid for from proceeds of alternate bonds, being general obligation bonds payable from certain sewer fees generated and to be collected pursuant to that certain Infrastructure Agreement [dated 2005] [to be entered into] among the City, the Yorkville Bristol Sanitary District, Centex Homes, Ocean Atlantic, Caledonia Homes, Kimball Hill Homes and the other developers named therein, as authorized to be issued at this time pursuant to the Local Government Debt Reform Act of the State of Illinois, as amended(the "Act"); and 011.598545.1 WHEREAS, pursuant to and in accordance with the provisions of the Act, the City is authorized to issue its Alternate Bonds in the aggregate principal amount of not to exceed $12,000,000 for the purpose of providing funds to finance the Project and to pay the costs of issuing such Bonds: BE IT ORDAINED BY THE CITY COUNCIL OF THE UNITED CITY OF YORKVILLE,ILLINOIS,as follows: Section 1. Incorporation of Preambles. The Corporate Authorities hereby find that all of the recitals contained in the preambles to this ordinance are full, true and correct and do incorporate them and the terms defined therein into this ordinance by this reference. Section 2. Determination To Issue Bonds. It is necessary and in the best interests of the City to accomplish the financing of the Project and that for the purpose of paying the costs of issuance in connection therewith, there are hereby authorized to be issued and sold the Alternate Bonds of the City in an aggregate principal amount not to exceed $12,000,000. It is hereby expressed to be the desire of the City to issue Alternate Bonds in an amount less than $12,000,000. Section 3. Publication. This ordinance, together with a notice in the statutory form as attached hereto, and appropriately completed, shall be published once within ten (10) days after passage hereof by the Corporate Authorities in the Kendall County Record the same being a newspaper of general circulation in the City, and if no petition, signed by electors numbering seven and one half percent(7-1/2%) of the registered voters in the City (i.e., ) and asking that the issuance of the Alternate Bonds be submitted to referendum is filed with the City Clerk within thirty (30) days after the date of the publication of this ordinance and said notice,then the Alternate Bonds shall be authorized to be issued. 3 011.598545.1 Section 4. Additional Ordinances. If no petition meeting the requirements of applicable law is filed during the petition period hereinabove referred to, then the Corporate Authorities intend to adopt additional ordinances or proceedings supplementing or amending this ordinance providing for the issuance and sale of the Alternate Bonds, prescribing all the details of the Alternate Bonds, so long as the maximum amount of the Alternate Bonds as set forth in this ordinance is not exceeded and there is no material change in the purposes described herein. Such additional ordinances or proceedings shall in all instances become effective in accordance with applicable law. This ordinance, together with such additional ordinances or proceedings, shall constitute complete authority for the issuance of the Alternate Bonds under applicable law. Section 5. Bond Counsel. The Corporate Authorities hereby appoint Foley & Lardner LLP as its bond counsel for the Alternate Bonds. Section 6. Severability. If any section, paragraph, clause or provision of this ordinance shall be held invalid, the invalidity of such section, paragraph, clause or provision shall not affect any of the other provisions of this ordinance. Section 7. Repealer. All ordinances, resolutions or orders, or parts thereof, in conflict with the provisions of this ordinance are to the extent of such conflict hereby repealed. Section 8. Effectiveness. This ordinance is effective upon its passage and approval. PASSED BY THE CITY COUNCIL OF THE UNITED CITY OF YORKVILLE, KENDALL COUNTY, ILLINOIS this September_2005. PAUL JAMES MARTY MUNNS DEAN WOLFER WANDA OHARE VALERIE BURD ROSE SPEARS JASON LESLIE JOSEPH BESCO 4 011.598545.1 APPROVED Mayor ATTEST: City Clerk Published in pamphlet form , 2005. 5 011.598545.1 NOTICE OF INTENT TO ISSUE BONDS AND RIGHT TO FILE PETITION Notice is hereby given that pursuant to Ordinance No. 2005-_, adopted September _, 2005 (the "Ordinance"), the United City of Yorkville, Kendall County, Illinois (the "City"), intends to issue its General Obligation Bonds (Alternate Revenue Source) (the "Bonds"), in an aggregate principal amount not to exceed $12,000,000, and bearing interest per annum at not to exceed the maximum rate authorized by law at the time the Bonds are sold, for the purpose of financing certain sanitary sewer infrastructure improvements within the City and paying costs associated therewith. The Bonds shall be alternate bonds, being general obligation bonds payable from certain sewer fees to be collected pursuant to that certain Infrastructure Agreement to be entered into among the City, Yorkville Bristol Sanitary District, Centex Homes, Ocean Atlantic, Caledonia Homes, Kimball Hill Homes, and the other developers named therein, as authorized by the Local Government Debt Reform Act of the State of Illinois, as amended. A complete copy of the Ordinance follows this notice. Notice is hereby further given that if a petition signed by or more electors of the City (being equal to 7-1/2% of the registered voters of the City) asking that the issuance of the Bonds be submitted to referendum is filed with the City Clerk within 30 days after the date of publication of this notice, the question of the issuance of the Bonds shall be submitted to the electors of the City at the nonpartisan election to be held on , 200_. The Circuit Court may declare that an emergency referendum should be held prior to said election date pursuant to the provisions of Section 2A-1.4 of The Election Code of the State of Illinois, as amended. By order of the City Council of the United City of Yorkville, Kendall County, Illinois. DATED this_day of September, 2005. /s/ City Clerk United City of Yorkville Kendall County, Illinois 011.598545.1 UNITED CITY OF YORKVILLE $10.6MM Sewer ARS 10 Year- 4.0% Debt Service Schedule Date Principal Coupon Interest Total P+1 12/30/2005 - - - - 12/30/2006 820,000.00 4.000% 493,488.89 1,313,488.89 12/30/2007 925,000.00 4.000% 391,200.00 1,316,200.00 12/30/2008 960,000.00 4.000% 354,200.00 1,314,200.00 12/30/2009 1,000,000.00 4.000% 315,800.00 1,315,800.00 12/30/2010 1,040,000.00 4.000% 275,800.00 1,315,800.00 12/30/2011 1,080,000.00 4.000% 234,200.00 1,314,200.00 12/30/2012 1,125,000.00 4.000% 191,000.00 1,316,000.00 12/30/2013 1,170,000.00 4.000% 146,000.00 • 1,316,000.00 12/30/2014 1,215,000.00 4.000% 99,200.00 1,314,200.00 12/30/2015 1,265,000.00 4.000% 50,600.00 1,315,600.00 Total $10,600,000.00 - $2,551,488.89 $13,151,488.89 Yield Statistics Bond Year Dollars $63,787.22 Average Life 6.018 Years Average Coupon 4.0000000% Net Interest Cost(Nig) 4.0000000% True Interest Cost(TIC) 3.9983699% Bond Yield for Arbitrage Purposes 3.9983699% All Inclusive Cost(AIC) 3.9983699% IRS Form 8038 Net Interest Cost 4.0000000% Weighted Average Maturity 6.018 Years Sewer ARS-10 Years I SINGLE PURPOSE I 8/31/2005 I 3:34 PM Speer Financial, Inc. Public Finance Consultants Since 1954 Page 1 Page 1 of 2 Traci Pleckham From: Tony Graff[tgraff@yorkville.ii.us] Sent: Wednesday, August 31, 2005 6:11 PM To: 'Raphael, Peter'; 'Kevin McCanna'; 'Traci Pleckham' Cc: ffeinstein@mwe.com; BobKennyl @aol.com; david.warner@hklaw.com; 'John Wyeth (E-mail)'; 'Bart Olson' Subject: Rob Roy Creek Sanitary Sewer Funding Option Peter+All:: Here is the breakdown on the funding options we discussed on Wednesday. I did receive a debt service schedule from Kevin McCanna. The 10 year schedule for$10.600,000 issuance with a 4% rate shows 2,551,488 in interest with a payment schedule as follows Principal Interest Total P+I 12/31/06 820,000 493,488 1,313,488 12/31/07 925,000 391,200 1,316,200 12/31/08 960,000 354,200 1,314,200 12/31/09 1,000,000 315,800 1,315,800 12/31/10 1,040,000 275,800 1,315,800 12/31/11 1,080,000 234,200 1,314,200 12/31/12 1,125,000 191,000 1,316,000 12/31/13 1,170,000 146,000 1,316,000 12/31/14 1,215,000 99,200 1,314,200 12/31/15 1,265,000 50,600 1,315,600 Total 10,600,000 2,551,488 13,151,488 Here is the breakdown of fees from the development side: IPF YBSD Fee City Sewer Fee Total Recapture Centex 1,950,000 4,200,000 6,150,000 Ocean Atlantic 139,750 1,780,000 1,919,750 ($750,000 per paid for engineering) Caledonia N/A 408,000 408,000 Kimball Hill 877,500 Paid 900,000 1,777,500 Klyln's Crossing 175,500 Paid 262,000 437,500 Corneils Crossing 48,750 62,000 110,750 Herren Property 123,500 123,500 Total 3,315,000 7,612,000 10,927,000 The shortfall for the project is the debt service interest of$2,224,488. The proposal would be for both Ocean Atlantic and Centex to sign the infrastructure agreement and to be eligible for%of recapture of the interest paid as their commitment for the bond issuance to be backed by the agreement with no or minimal liability by the City. Furthermore, we need all easements and signed agreements by September 12, 2005. I have placed the alternate revenue bond issuance on the Administration Committee Agenda for 9/1/05 and I will be looking for approval by the City Council on 9/13/05 for authorization ordinance and the sale of the bonds with the anticipation of the funds by October 31, 2005. WE will move forward on the contracts to advertise for bids once I have a the signed agreements. Let me know your thoughts and how can we accomplish this task. Tony Graff City Administrator on/Inns Nip i F&L DRAFT 08/26/05 ORDINANCE NO. AN ORDINANCE PROPOSING THE ESTABLISHMENT OF SPECIAL SERVICE AREA NUMBER 2004-107 (RAINTREE VILLAGE II PROJECT) IN THE UNITED CITY OF YORKVILLE AND PROVIDING FOR OTHER PROCEDURES IN CONNECTION THEREWITH BE IT ORDAINED BY THE CITY COUNCIL OF THE UNITED CITY OF YORKVILLE, KENDALL COUNTY, ILLINOIS AS FOLLOWS: Section 1. Authority. The United City of Yorkville, Kendall County, Illinois (the "City") is authorized pursuant to Article VII, Section 7(6) of the Constitution of the State of Illinois, and pursuant to the provisions of the Illinois Special Service Area Tax Law, 35 ILCS 200/27-5 et seq. (the "Act"), which provides, inter alia, the manner of levying or imposing taxes and issuing bonds for the provision of special services to areas within the boundaries of municipalities and counties. Section 2. Findings. The City Council of the City finds and determines as follows: a. Owners of record (the "Owners") of that portion of the City described in Exhibit A attached hereto and made a part hereof (hereinafter the "Subject Territory") have expressed an interest in the construction, acquisition and installation of various infrastructure improvements to their properties as further described herein; and b. Pursuant to Section 27-20 of the Act, the Owners have filed an application with the City Council of the City proposing that the City establish a special service area (the "Application"); and c. It is in the public interest that the City Council of the City consider the creation of a special service area for the Subject Territory; and d. The special service area proposed for consideration is compact and contiguous and is outlined on the map of a portion of the City, which map is attached hereto as Exhibit B and made a part hereof; and e. The proposed special service area will benefit specially from the municipal services to be provided to the area. These proposed municipal services are in addition to municipal services provided to the City as a whole. Section 3. Proposal. In response to the expressed interest of the Owners, the City Council of the City hereby accepts the Application and proposes the establishment of City of Yorkville Special Service Area Number 2004-107 for the construction, acquisition and installation of infrastructure improvements to serve the Subject Territory. Section 4. Public Hearing. A public hearing shall be held on the 25th day of October, 2005, at 7:00 p.m., at the Yorkville City Hall, 800 Game Farm Road, Yorkville, Illinois, 011.598119.1 to consider the creation of the City of Yorkville Special Service Area Number 2004-107, in the Subject Territory. At the hearing, the following alternative methods of financing improvements within the proposed special service area will be considered: (i) the imposition or levy by the City of a tax in the proposed special service area sufficient to produce revenues to provide special municipal services to the proposed special service area; the maximum rate of such taxes to be extended in any year for special services under this ordinance within the proposed special service area shall not exceed the amount necessary to produce a maximum annual tax levy of $1,000,000 in accordance with the special tax roll referred to below, and(ii) the borrowing of an amount not to exceed an aggregate principal amount of $10,000,000 to be evidenced by special tax bonds (including bonds issued to refund such bonds) of such area(the "Bonds"), the proceeds of which shall be used to pay the cost of providing special municipal services to the proposed special service area, to fund certain reserves for, and interest on, the Bonds and initial administrative expenses relating to the proposed special service area, and to pay the cost of issuing the Bonds. The special municipal services to be provided to the proposed special service area may include: engineering, soil testing and appurtenant work, mass grading and demolition, storm water management facilities, storm drainage systems and storm sewers, site clearing and tree removal, public water facilities, sanitary sewer facilities, erosion control measures, roads, streets, curbs, gutters, street lighting, traffic controls, sidewalks, equestrian paths and related street improvements, and equipment and materials necessary for the maintenance thereof, landscaping, wetland mitigation and tree installation, costs for land and easement acquisitions relating to any of the foregoing improvements, required tap-on and related fees for water or sanitary sewer services and other eligible costs. The Bonds, if issued, shall be retired over a period not to exceed forty (40) years from the date of their issuance and shall bear interest at a rate not to exceed the greater of nine percent (9%) per annum or 125% of the rate for the most recent date shown in the 20 G.O. Bonds Index of average municipal bond yields as published in the most recent edition of The Bond Buyer, published in New York,New York, at the time the contract is made for the sale of the Bonds. The Bonds, if issued, shall be retired by the levy of an annual tax levied against each parcel of property within the special service area pursuant to a special tax roll to pay the interest on the Bonds as it falls due and to discharge the principal thereof at maturity and to pay the costs of administration and maintenance of the Subject Territory. This tax is to be levied upon all taxable property within the proposed special service area. Section 5. Notice of Public Hearing. Notice of hearing shall be published at least once not less than fifteen (15) days prior to the public hearing specified in Section 4 above, in a newspaper of general circulation in the City. In addition, notice shall be given by depositing the notice in the United States mail addressed to the person or persons in whose name the general taxes for the last preceding year were paid on each lot, block, tract or parcel of land lying within the proposed special service area. This notice shall be mailed not less than ten (10) days prior to the time set for the public hearing. In the event taxes for the last preceding year were not paid, the notice shall be sent to the person last listed on the tax rolls prior to that year as the owner of the property. The notice to owners of record shall be in substantially the form set forth in Exhibit C to this Ordinance. Section 6. Supercede Conflicting Ordinances. All ordinances or parts of ordinances in conflict with the provisions of this ordinance are repealed to the extent of such conflict. 2 011.598119.1 Section 7. Effective Date. This Ordinance shall be in full force and effect from and after its passage and approval in the manner provided by law. PASSED by the City Council of the City this September 27, 2005. PAUL JAMES MARTY MUNNS JASON LESLIE WANDA OHARE VALERIE BURD ROSE SPEARS DEAN WOLFER JOSEPH BESCO Mayor ATTEST: City Clerk [SEAL] Published in pamphlet form , 2005. 3 011.598119.1 EXHIBIT A Legal Description 011.598119.1 EXHIBIT B Map of Special Service Area Number 2004-107 011 598119A EXHIBIT C NOTICE OF HEARING UNITED CITY OF YORKVILLE SPECIAL SERVICE AREA NUMBER 2004-107 (RAINTREE VILLAGE II PROJECT) NOTICE IS HEREBY GIVEN that on October 25, 2005 at 7:00 p.m. at the Yorkville City Hall, 800 Game Farm Road, Yorkville, Illinois, a hearing will be held by the City of Yorkville to consider forming a special service area, to be called "City of Yorkville Special Service Area Number 2004-107," consisting of the territory legally described in Exhibit 1 to this Notice. The approximate street location is the area generally depicted on the map of a portion of the City, which map is attached as Exhibit 2 to this Notice. The general purpose of the formation of the City of Yorkville Special Service Area Number 2004-107 is to provide special municipal services to the area which may include: engineering, soil testing and appurtenant work, mass grading and demolition, storm water management facilities, storm drainage systems and storm sewers, site clearing and tree removal, public water facilities, sanitary sewer facilities, erosion control measures, roads, streets, curbs, gutters, street lighting, traffic controls, sidewalks, equestrian paths and related street improvements, and equipment and materials necessary for the maintenance thereof, landscaping, wetland mitigation and tree installation, costs for land and easement acquisitions relating to any of the foregoing improvements, required tap-on and related fees for water or sanitary sewer services and other eligible costs. There will also be considered at the hearing the following alternative methods of financing improvements within the proposed special service area: (i) the levy of a tax by the City in the proposed special service area, sufficient to produce revenues to provide special municipal services to the proposed special service area; the maximum rate of such taxes to be extended in any year within the proposed special service area which shall not exceed the amount necessary to produce a maximum annual tax levy of$1,000,000 in accordance with the special tax roll referred to below, and (ii) the issuance of special tax bonds (including bonds issued to refund such bonds) in an aggregate principal amount not to exceed $10,000,000 at an interest rate of not to exceed the greater of nine percent (9%) per annum or 125% of the rate for the most recent date shown in the 20 G.O. Bonds Index of average municipal bond yields as published in the most recent edition of The Bond Buyer, published in New York, New York, at the time the contract is made for the sale of the bonds, and to mature within forty (40) years from the date of their issuance. The bonds, if issued, shall be retired by the levy of an annual tax established pursuant to a special tax roll to pay the interest on such bonds as it falls due and to discharge the principal thereof at maturity and to pay the costs of administration and maintenance of the special service area, said tax to be levied upon all taxable property within the proposed special service area. )11.598119.1 At the hearing, all interested persons affected by the formation of such special service area, including all persons owning taxable real estate therein, may file written objections to and be heard orally regarding the formation of and the boundaries of the special service area, the issuance of bonds and the levy of taxes affecting the area. The hearing may be adjourned by the City Council without further notice other than a motion to be entered upon the minutes of its meeting fixing the time and place of its adjournment. If a petition signed by at least 51% of the electors residing within the City of Yorkville Special Service Area Number 2004-107 and by at least 51% of the owners of record of the land included within the boundaries of the City of Yorkville Special Service Area Number 2004-107 is filed with the City Clerk of the City of Yorkville within 60 days following the final adjournment of the public hearing objecting to the creation of the special service area, the issuance of bonds for the provision of special services to the area or the levy of taxes affecting the area, no such area may be created and no such bonds may be issued or taxes levied or imposed. 2 011.598119.1 Exhibit 1 to Notice Legal Description of Property 011.598119.1 Exhibit 2 to Notice Map of Proposed Special Service Area 011.598119.1 ILLINOIS MUNICIPAL LEAGUE Risk Management Association Kenneth A. Alderson Managing Director August 5, 2005 Anton Graff Risk Management Coordinator City of Yorkville 800 Game Farm Road Yorkville, IL 60560 RE: Illinois Municipal League Risk Management Association Minimum/Maximum Program Dear Anton: Enclosed please find the City of Yorkville's second quarter minimum-maximum status report. The numbers reflected represent claims activity for the first six months of the year, from December 31, 2004 through June 30, 2005. We will continue to provide you with the status report on a quarterly basis. This will enable you to monitor your progress. Written notification will be provided to you if paid claim dollars are equal to or greater than 60% of the minimum loss fund. A second notice will be provided if paid claim dollars are equal to or exceed 85% of the minimum loss fund. If you have questions concerning the status report or the Minimum/Maximum Program, please contact me at 1-800-252-5051, extension 1199. Sincerely, Julia Reynolds Minimum/Maximum Project Coordinator Enclosure c: Mayor Arthur F. Prochaska Jr. I.M.L/RISK MANAGEMENT TOWNE CENTRE BUILDING,THIRD FLOOR DANVILLE,IL 61832 217/446-1089 800/252-5051 Minimum - Maximum Status Report United City of Yorkville Based on Claims Data as of: 6/30/2005 Minimum Maximum YTD Total Paid YTD Outstanding YTD Total Minimum Loss Maximum Loss Percent To Date Percent To Date Year Contribution Contribution YTD Total Claims Claims Reserves Incurred Fund Fund Paid Incurred STATUS 2001 $86,460 $116,736 16 $71,414.63 $893.30 $72,307.93 $60,552 $90,829 117.9% 119.4% PARTIAL PAY: OPEN 2002 $96,589 $130,412 8 $7,841.84 $0.00 $7,841.84 $67,646 $101,469 11.6% 11.6% CLOSED 2003 $106,330 $143,564 8 $40,422.61 $0.00 $40,422.61 $74,468 $111,703 54.3% 54.3% CLOSED 2004 $115,388 $154,210 11 $8,830.68 $0.00 $8,830.68 $77,644 $116,466 11.4% 11.4% CLOSED 2005 $121,519 $162,403 8 $7,126.56 $4,512.72 $11,639.28 $81,770 $122,654 8.7% 14.2% OPEN Percentage of Loss Fund Paid/Incurred 1600% ,,,,,,,,,,..,„.„.•:,-,.,,--„,..,-.„,-, -. �.s � , 140% J y "� , A �, \w � ; , ' it a5 LNoosrmsi 120 / f .vq " a : , aii e xX2rt � ,. t, Maximum axmFauul m 100 / ;, , . : sfis; i _.% s� � a,, a s sr� . f � o , f �' "� ii5 � � �t � w� � h kk' Fund 80% a: rxs �.sf0 Ax . b w � ti4Minimum r•x � - � er% ' �14`, ' s 1 r rxLoss Fund o o hn e 1. 4 7 aim � h w 4i i ` ,4 d 60s s 40% P rr , 7brN 4 q • r 't, v r T _: "�.c E aFP 2 0% �� �tr ®Percent To Date K � P aT .. , ., .. „Ra R <, v,� .,....•;W:, ■Percent To Date �e� 0% �_ _ Incurred 2001 2002 2003 2004 2005 7/27/2005 IMLRMA Claims Experience (A) Page 1 Prepared by CCMSI on: 07/14/2005 Time: 16:28:43 Set/Database: SUMMCLMS/IMLPOLYR Report As Of: 06/30/2005 Index: POLYR6 MUNICIPALITY ENTRY DATE CLASS PRFACT= 1.000 YORKVILLE 01/Dec/99 C YEAR= 2000/2001 CLIENT NUMBER 0500659 CLAIMS OUT RESERVES PAID TO DATE TOTAL EXPERIENCE CONTRIB LR IR MANHOURS WORKCOMP 8 $0 $4,670 $4,670 $26,351 18% 12.95 123544.36 AL/CGL-POL 3 $893 $48,618 $49,511 $65,024 76% PROP 0 $0 $0 $0 $6,369 0% IM 1 $0 $2,360 $2,360 $2,502 94% APD 4 $0 $15,767 $15.767 $1,352 1166% TOTAL 16 $893 $71,415 $72,308 $101,598 71% 25.90 **************************************************************************************************************** MUNICIPALITY ENTRY DATE CLASS PRFACT= 1.000 YORKVILLE 01/Dec/99 C YEAR= 2001/2002 CLIENT NUMBER 0500659 CLAIMS OUT RESERVES PAID TO DATE TOTAL EXPERIENCE CONTRIB LR IR MANHOURS WORKCOMP 5 $0 $2,532 $2,532 $47,016 5% 7.36 135898.85 AL/CGL-POL 1 $0 $1.795 $1,795 $55,839 3% PROP 0 $0 $0 $0 $5,092 0% IM 1 $0 $923 $923 $2,909 32% APD 1 $0 $2,592 $2,592 $2,644 98% TOTAL 8 $0 $7,842 $7,842 $113.500 7% 11.77 **************************************************************************************************************** MUNICIPALITY ENTRY DATE CLASS PRFACT= 1.000 YORKVILLE 01/Dec/99 C YEAR= 2002/2003 CLIENT NUMBER 0500659 CLAIMS OUT RESERVES PAID TO DATE TOTAL EXPERIENCE CONTRIB LR IR MANHOURS WORKCOMP 4 $0 $38,070 $38,070 $44,777 85% 6.49 123328.15 AL/CGL-POL 3 $0 $1,595 $1,595 $64,098 2% PROP 0 $0 $0 $0 $8,209 0% IM 0 $0 $0 $0 $3.893 0% APD 1 $0 $758 $758 $3,970 19% TOTAL 8 $0 $40.423 $40,423 $124,947 32% 12.97 **************************************************************************************************************** MUNICIPALITY ENTRY DATE CLASS PRFACT= 1.000 YORKVILLE 01/Dec/99 C YEAR= 2003/2004 CLIENT NUMBER 0500659 CLAIMS OUT RESERVES PAID TO DATE TOTAL EXPERIENCE CONTRIB LR IR MANHOURS WORKCOMP 9 $0 $5,062 $5,062 $50,037 10% 12.87 139825.38 AL/CGL-POL 1 $0 $2,224 $2,224 $70,622 3% PROP 0 $0 $0 $0 $8.431 0% IM 0 $0 $0 $0 $997 0% APD 1 $0 $1,545 $1,545 $4,712 33% TOTAL 11 $0 $8,831 $8,831 $134,799 7% 15.73 **************************************************************************************************************** IMLRMA Claims Experience (A) Page 2 Prepared by CCMSI on: 07/14/2005 Time: 16:28:44 Set/Database: SUMMCLMS/IMLPOLYR Report As Of: 06/30/2005 Index: POLYR6 MUNICIPALITY ENTRY DATE CLASS PRFACT= 0.499 YORKVILLE 01/Dec/99 C YEAR= 2004/2005 CLIENT NUMBER 0500659 EARNED CLAIMS OUT RESERVES PAID TO DATE TOTAL EXPERIENCE CONTRIB LR IR MANHOURS WORKCOMP 5 $3,013 $2,219 $5,232 $26,888 19% 14.42 69356.51 AL/CGL-POL 1 $1,500 $0 $1,500 $36,175 4% PROP 1 $0 $2,609 $2,609 $5,661 46% IM 0 $0 $0 $0 $420 0% APD 1 $0 $2,298 $2,298 $1,528 150% TOTAL 8 $4,513 $7,127 $11,639 $70,672 16% 23.07 **************************************************************************************************************** Page 1 of 5 DRAFT UNITED CITY OF YORKVILLE ADMINISTRATION COMMITTEE MEETING THURSDAY, JULY 7, 2005 6:30 PM City Hall Conference Room CITY OFFICIALS IN ATTENDANCE: Mayor Art Prochaska Treasurer Bill Powell (arr.6:44pm) Alderman Paul James Attorney John Wyeth(left 7:5opm) Alderwoman Valerie Burd Finance Director Traci Pleckham Alderwoman Wanda Ohare Chief Harold Martin Alderwoman Rose Spears (arr.7:36pm) City Administrator Tony Graff(arr.6:45pm) Interim City Clerk Bart Olson The meeting was called to order at 6:32pm by Alderman Paul James. PRESENTATION: None OLD BUSINESS Alderman James suggested that he thought it would be beneficial to have the agenda packets on the Friday prior to the upcoming meeting. There is a shortage of time to review the packets when they are received on Tuesdays. Ms. Pleckham said the Clerk's office prepares C.O.W. packets on Fridays and she did not know if there was adequate time to prepare two sets of packets. Mr. James said that having a weekend to review the material would be helpful. Ms. Pleckham will research. 1. Minutes for Approval/Correction: June 2, 2005 The minutes were approved as read. 2. Monthly Budget Report for May 2005 Ms. Pleckham noted the"Countryside TIF Project" item on the Pre Audit Financial Summary and said this fund holds bonds for the Countryside TIF project. Alderwoman Ohare commented that it was nice to see the investment income broken down into categories and doing so well. The income will be revised as the revenue streams begin to come in, which is expected to be in September/October. Ms. Ohare asked about the increase of 14% for office cleaning. Ms. Pleckham believed it was for bulk cleaning supplies. The Finance Director also commented on an increase in the Page 2 of 5 income due to the efforts of Treasurer Powell. This report, which was given to department heads, was for information only and no further action was required. 3. Treasurer's Report for May 2005 Ms. Pleckham is researching how other communities handle their Treasurer's report and how often they are issued. She said many towns do not revise their reports and that the State Statute just requires that it must be done. Others just compile an"actual vs. budget" report. She will continue her research and report back to the committee. Alderwoman Burd suggested that she check with the Municipal League for guidance. Ms. Pleckham reported that the Fund Balance Reserve is at 21%. Water and sewer are at 23% and 28%. The Mayor commented that the Treasurer's report is a snapshot of the activity and he suggested adding "pre-audit"on the report. Finance Director Pleckham would like to see the entire fiscal year, by month, on this report,to check the progress. This item moves forward to the consent agenda. 4. Risk Management Coordinator Update This matter came back from the December Administration meeting and concerned a performance update for the City's liability insurance. There have been eight injury reports this year, however, nothing is outstanding at this time. The sewer issue from several months ago has been resolved. Ms. Pleckham recently received quotes from the insurance company and would like to review this again in three months along with any other insurance quotes that require bids. Ms. Pleckham was asked to bring a list of any such items to the next Administration meeting. Ms. Spears also suggested surveying other communities in August. This matter will be brought back to committee next month. 5. Quarterly Department Vehicle Reports This report was previously done monthly but, is now done quarterly. One trip was made to Peoria where Mr. Graff gave a speech. Ms. Burd said she would like to hear a report on that as she considered that to be noteworthy. It was mentioned that each report was set up in a different format. The Police Department format was favored and Mr. Graff will forward a standard template to all department heads. It was noted that the Engineering vehicle has 181,625 miles. A new vehicle is budgeted for that department. This item will return to committee for further discussion. Page 3 of 5 NEW BUSINESS: 1. Library Bond Ordinance Ms. Pleckham handed out information regarding the $7.25 million in bonds to be issued for the Library expansion. This amount is based on a certain percentage of the EAV. She said there are two options to make up the difference: 1) issue the difference next year when the EAV increases or 2) rely on upfront developers' fees. Administrator Graff cautioned that any such fees should not be earmarked for debt service. It was also noted that using developer fees is less burden on the taxpayer. Mr. Graff said this project should be 1/3 taxpayer-based and 2/3 developer-based according to population. Mr. James asked Ms. Pleckham to compile a report of the Library funds: bank balance, the amount taxpayers approved and their expansion budget. It was suggested by Ms. Spears to check the capital fees. Ms. Burd said the Library is above their expansion budget at this time. She also suggested researching the possibility of having a person with financial means, sponsor part of the cost. Ms. Pleckham has found some small foundations to assist the building fund and the grant-writer was also suggested as a possible source for help. The bond ordinance will be moved to C.O.W. with a spreadsheet attached showing the sources of funding. The fees will be re-evaluated in September. Ms. Pleckham said that at the end of the ordinance,there will be a re-payment schedule which must be approved with the ordinance. All these items will move to the July 19th C.O.W. 2. Create Ordinance for City Administrator Attorney Wyeth drafted ordinances for the positions of Finance Director and Executive Director of Parks and Recreation. The ordinances addressed the creation of the positions, the duties, compensation, terms and removal. He distributed copies to the committee and asked for their input. Ms. Burd questioned#3b-appointment term/removal. She asked if it allows the Mayor to remove anyone from that office. There is also a procedure in place to reinstate that person. At this time,there is no ordinance for a City Administrator position,though a job description exists. Ms. Spears had a description dated 1998. Mr. James asked Mr. Wyeth to write an ordinance to cover that position and pattern it after the draft already presented. The Mayor said there are no ordinances covering the Director of Public Works, Chief of Police, Building & Zoning Inspector and City Engineer. However, other committee members said some of those positions are appointed. Paul James said a decision should be made if a position is appointed or not and if appointed, establish an ordinance. He felt there were too many appointed positions at this time. Attorney Wyeth stressed the office of a particular appointee is different than the employment. The office can require signatures on behalf of the City. Page 4 of 5 Mr. Graff suggested conducting a survey of trends for appointed officials and said he has collected some information already. There was a brief discussion regarding contract employees and appointed employees. Under the proposed ordinance,there was some discussion about appointed offices being able to be discontinued with a 2/3 vote effective at the end of that fiscal year. The Mayor can also appoint an interim person to then fill that position. Chairman James reiterated the original issue that would create an ordinance for the City Administrator. He was in favor of the ordinance. At this time, it is not an office and Valerie Burd questioned the value of making this position an office. In conclusion, Mr. James asked what positions need to be appointed. When that determination is made, ordinances can then be drafted. Attorney Wyeth will research the State Statutes and this item will be revisited in August. 4. Organizational Chart Ms. Burd said that Mr. Graff's contract clearly states that the Mayor and City Council provide direction for him,but she thought the chart did not depict that. However, Mr. James said he felt this chart simply provided a quick snapshot of the City employees. The committee complimented Mr. Olson on this chart and it will be posted. 5. Revising of Administrative Secretary Job Description Mr. Graff said this job description was old and had not been updated. He said it had not been sent to the labor attorney yet,pending input from the committee. This position will become non-exempt. Wanda Ohare commented that the position now expects mathematical functions, however,the job description does not mention the need for math skills. Comments and suggestions will be given to Mr. Graff to incorporate into the job description. This item will be discussed again next month. 6. Utility Billing Past Due/Collection Information Finance Director Pleckham reported that 129 accounts are currently on collection status. Efforts have been exhausted for most of these accounts as the persons cannot be found, but these accounts will be sent to the credit companies. This information is from a report by Northwest Collectors Incorporated,the City's collection company. There is no cost to the City unless money is collected and this agency is not used until all other efforts have failed. Over a 7-year period, $34,477.39 was outstanding and in the last 2 years, $4,400 has been collected by this company. They receive 35% of the collected amount. The City is attempting to strengthen the ordinance governing these unpaid bills and Attorney Kramer is still working on this update to the water ordinance. Page 5 of 5 This ordinance is also being tied to developers and building permits could be withheld for non-payment of previous bills. Renters are another part of the problem. Mr. Graff said landlords have been spoken with since they are ultimately responsible for the unpaid bills. Now, when the bills are past due for the renters,the landlord is notified. In some instances, the bills are sent directly to the landlords of large apartment buildings. In the last year, only about 25 accounts have been sent to collections. Ms. Ohare commended the diligence of City staff ADDITIONAL BUSINESS: Mr. Powell said he is considering changing the Treasurer's report based on research he is gathering from other towns. Mayor Prochaska said that a spreadsheet will be prepared for the next Administration meeting, that will show the number of hours the City Attorney works to help justify a full or part time position. Ms. Burd also said the $9,500 salary needs to be revised to agree with the Code. The Attorney took a cut in pay from the original salary. There is no ordinance currently in effect for his salary and this matter is being researched. At the next meeting, the number of hours worked and the salary will be discussed. The Mayor said the job description draft will also be brought to the next meeting. Paul James said that Longford Lakes behind Jewel, (Ward 4) is now done and 45 trees have not been planted. He asked that Mr. Graff to fmd out if trees are missing at other sites and how many developers have not met the ordinance. However, the committee agreed that Mr. Wywrot would include that on a punchlist. Mr. Graff will check with Mr. Wrywrot and will report back. Mr. James also said a lake located near Jewel is not being maintained by Tucker Development. The Mayor cautioned that the agreement is between several parties and should be researched before any action is taken. There was no further business and the meeting was adjourned at 8:18pm. Minutes respectfully submitted by Marlys Young, Minute Taker Page 1 of 6 RAFT UNITED CITY OF YORKVILLE ADMINISTRATION COMMITTEE MEETING THURSDAY,AUGUST 4,2005 6:30 PM City Hall Conference Room CITY OFFICIALS IN ATTENDANCE: Alderman Paul James Treasurer Bill Powell Alderman Dean Wolfer(arr. 6:38pm) Mayor Art Prochaska(7:10-7:15pm) Alderwoman Rose Spears(an.7:36pm) Finance Director Traci Pleckham Alderwoman Wanda Ohare City Administrator Tony Graff Interim City Clerk Bart Olson GUEST: Tony Scott, Kendall County Record The meeting was called to order at 6:30pm by Alderman Paul James. PRESENTATION: None OLD BUSINESS: 1. Minutes for Approval/Correction: July 7, 2005 Not all committee members had an opportunity to review the minutes, so it was decided if there were any corrections, they should be brought to the September meeting. 2. Monthly Budget Report for June 2005 It was noted that the monthly Budget Report as of June 30 showed expenses being greater than revenue,however, some tax distribution and state revenues are still expected. Ms. Pleckham stated that transfers are being done quarterly and the numbers will be"trued up"in July. She also stated that the report is given to all Aldermen and in the future months, "FYI" will be added to this report. 3. Monthly Treasurer's Report for June 2005 The following items were specifically discussed: • The "Municipal Building"item is a carryover from the renovations and fees are still being collected. • #85 Fox Industrial-will be adjusted based on a transfer from MFT. An appropriation resolution was done earlier this year. Page 2 of 6 • #95 Trust&Agency-funds collected by the City for other agencies such as the School District(land cash), Library etc. This report will move to the C.O.W. consent agenda.. 4. Create Ordinance for City Administrator a. Revising of City Administrator Job Description Mr. Graff noted that his position was never created by an ordinance,but rather by a job description. The revised job description was reviewed by the committee and it was decided to discuss this after the IML conference. Ms. Pleckham said that she now tracks items from meeting agendas so that no item will be dropped off. It was suggested that these lists should be printed quarterly for a review. This agenda item will be brought back to committee in October for further discussion. S. Powers of Council as it Relates to 1 and 4 Year Appointments This item will move to a future meeting when the Attorney is present and after more research from him. 6. Revising of Administrative Secretary Job Description Bart Olson's memo was discussed and he noted that the education requirements have been a point of conversation for each job description. The high school level of education was the minimum for support staff. He had done a survey of similar positions in other towns to compare functions for this particular position. Ms. Spears asked him to also do a salary survey for this job,however, Mr. Graff said this information could be found on the computer Mr. Graff said this position was mostly clerical,but this particular position has evolved and includes extra duties. This position works with the Mayor,Administrator and Attorney and a confidentiality requirement was added to the job description. Mr. Olson said that if the education requirements are raised, it could be challenged and the City would have to justify the change. The job description will be reviewed by an attorney after the committee finalizes the revisions. Alderman Wolfer shared some recent information he received that it may be illegal to conduct a background check as a requirement except for Police Departments. It was noted by Ms. Pleckham and Mr. Graff that at the present, a release must be signed for such a check. The attorney will be consulted and Mr. Graff said this requirement should be placed in the employee manual. Page3of 6 After much discussion, it was decided that the job description should require a high school degree along with a preferred Associate degree and/or 64 hours of job-related college courses. Alderwoman Spears recommended a rubber stamp to note"legal review"on all documents being reviewed. Mr. Graff responded that a"synopsis page"is being drafted to indicate legal, financial or other types of review and the action to be taken. He said it will be brought to the next meeting. Mr. Olson was asked to email surrounding towns requesting a job description for similar positions. This job description will move to C.O.W. after a final revision and legal review. 7. Videotaping Public Meetings This is an item that had been discussed at a previous meeting and no decision was made. Mr. Graff added that in the past, there was no one qualified to do the videotaping. At this time, City employee Glory Spies is qualified to do so. Ms. Spears said she is also qualified to videotape and Mayor Prochaska said that the person who tapes "Music Under the Stars"might also be available. The City I.T. Tech-Ron is coordinating with the consortium regarding the videotaping. This will be placed on the next C.O.W. agenda for input from the other Council members. 8. Salary Survey: Mayor,Aldermen, Clerk and Treasurer This item was skipped at this time. NEW BUSINESS: 1. Clerk and Treasurer—Elected Positions? The Clerk and Treasurer positions were necessary in the past,however, with full time staff positions, the question arose if those two positions can be handled by present staff. Mr. James said he spoke with Treasurer Bill Powell and City Clerk Jackie Milschewski and both of them feel their positions could be appointed rather than elected and should be full-time. Two separate referendums would be needed to take this action. The current stipend for each is $3600 annually. This item will be brought back next month for discussion. Prior to the next committee meeting, a survey will be done of surrounding communities to determine if the positions are full-time, elected or appointed, the salaries, etc. Bart Olson said that some communities do not have a Treasurer position or the role is minimal. Mr. Powell added that it is difficult to oversee the financial functions as a part-time official. The"check and balance" of the finances is done by auditors. Page 4 of 6 Also prior to the next meeting, Attorney Wyeth will give an opinion on the legality of this issue. If the City moves forward with a referendum, 90 days must be allowed. (Moved back into agenda to discuss#8 under Old Business) 8. Salary Survey: Mayor,Aldermen, Clerk and Treasurer This issue was brought back from a previous meeting. Alderman James said that he wished to keep the salary on the lower end in order to attract citizens who want to serve the City, rather than those who do it for the money. He wishes to bring this item back to the next meeting when Alderwomen Burd and Ohare are present. (Moved forward in agenda to item#2 under New Business) 2. Special Census Update The special census coordinator recently met with Bart Olson and Annette Williams. The City will solicit office space in town by using an RFP and a contract will be obtained and brought directly to a future C.O.W. Three to four locations have already been identified. The office must be set up by September and must be off-site from the City building. This census should bring in more than $600 per home. The cost of the survey is approximately$102,000, up from the previous time due to more homes. 3. Salary Survey and Performance Review Proposal Currently, the City is examining employee salaries and the Police Department will also conduct a compensation salary survey. Mr. Graff asked if the City wished to hire a firm to study salaries. Three companies have been contacted and asked for quotes. The questions to be answered are: 1. Does the Administration Committee wish to do an RFP for a study? 2. Does the City want to do a formalized compensation review? Mr. Graff said that firms that study salaries often review job descriptions and revise performance reviews. He said some initial prices for this were obtained from a website. Montgomery did such a survey at a cost of over$100,000. Chairman James suggested taking this matter to C.O.W. for further input and also obtain a copy of Montgomery's recent survey. It was stated that the City already has that copy and has been using it. Alderwoman Spears said she does not think the expense of such a survey is justified at this time. The committee discussed the current performance review and suggested that these should be updated. Alderman James suggested pulling one off the internet. Mr. Graff said IML could provide input or perhaps a Ph.D. candidate or intern could do a study for a stipend. It was noted that two interns are approved for the next budget. Page 5 of 6 This item will be brought back in October for further discussion after more information is gathered. 4. Waterworks System Contract B.2 and B.3 Alternate Revenue Bond This item is an update on the EPA loan, though the loan is not certain at this time. Administrator Graff reported that two good bids had been received for running pipes under the river. He recommended moving forth with the alternate revenue bond available, since it is not known if the loan will be approved. He added that the low river level this year would be an advantage as well and the contractor already has equipment in the area. The City must be in full EPA compliance by 2007 and Mr. Graff said that the City would not be notified until at least November, if the loan is approved. There is $50 million dollars available in the State with 65 communities seeking a portion of those funds. It was suggested to do the bond sale on August 23rd, award the bid contingent upon the funds and move this forward to C.O.W. on August 16th. S. Liability Insurance Renewal Process This is a renewal update for IML-RMA. It was questioned if other rates were desired or if the current vendor should be retained. A past concern was a lack of response from the company, however, that has been rectified. In addition, they offered a better rate. Ms. Pleckham said that the current policy needs to be revisited after the Library expansion is complete to insure the proper coverage. It was decided not to seek other bids since this is a recurring contract,but a quote will be requested from the current vendor in October. This item will move forward to C.O.W. 6. Contracted Vendor Information Ms. Pleckham compiled a list of the current preferredCity vendors per an IML request. It was suggested by Alderwoman Spears to ask City staff if adequate service is being received from these vendors and if there is a good working relationship. Mr. Graff will ask department heads for input and report back to the committee. A "length of contract" column will be added to Ms. Pleckham's list. Alderman James suggested moving this on to C.O.W. to inform all Council members of the yearly contracts 7. City Administrator's Request for NIU Class This request is for approval for Administrator Graff s 3'd of 12 classes. The cost is $900. This will move to C.O.W. for approval on consent agenda. The tuition reimbursement policy will be brought back to committee next month for more discussion. Bart Olson Page 6 of 6 will bring the existing document and any proposed changes. The focus is to make the policy consistent for all employees and to make it very clear. 8. FY 04/05 Audit Update Ms. Pleckham said the auditors are currently working at the City and also reminded the committee that this year the City must be GASBY34-compliant. Because of this, the auditors are also looking at all the fixed assets that includes such things as water, sewer, streets, any infrastructure, etc. On this date Ms. Pleckham received the fixed asset appraisal for the land portion. The draft of the audit is expected typically in September,but may take additional time due to the asset appraisal that will need to be added. Mr. Graff asked if an audit presentation should be done at a C.O.W. or at a special meeting. A presentation will be done at C.O.W.,however, a decision on a date will be made at a later time. ADDITIONAL: Alderwoman Spears asked if the historical street naming procedures could be brought to the committee for discussion. This will be brought back in September or October. Ms. Spears also said the sponsorship policy does not match the form that is given out. It was decided to give it to Mr. Graff for revision by City staff and then bring it back to Administration. The Attorney will be asked to review it as well. Administrator Graff reported that Dr. Gabris from NIU will hold a special meeting on August 30th for strategic planning. A memo will be given to each Council member. An IML member will also be attending the meeting in compliance with their rules. It was questioned by Mr. Powell if item#1 regarding the Clerk and Treasurer becoming elected positions could move to C.O.W. However, it is desired to have the attorney review this matter first and it was felt the Clerk should be at the meeting too. It was noted that after discussion with her,the City Clerk fully supports the position being elected. There was no further business and the meeting was adjourned at 8:18pm. Respectfully submitted by Marlys Young,Minute taker UNITED CITY OF YORKVILLE BUDGET 2005-2006 GENERAL FUND SUMMARY PERIOD ENDING JULY 31, 2005 25% OF FISCAL YEAR REVENUE/EXPENSE 2005-2006 PERCENT VS. THRU JULY 31, 2005 BUDGET BUDGET AMOUNT TOTAL GENERAL FUND REVENUE` 5,718,949 18,008,036 31.76% GENERAL FUND EXPENSES FINANCE & ADMINISTRATION 928,623 5,134,030 18.09% ENGINEERING 107,707 373,132 28.87% POLICE 449,795 2,145,143 20.97% PLANNING & DEVELOPMENT 9,912 324,607 3.05% STREETS 864,516 9,459,954 9.14% HEALTH & SANITATION 92,957 571,170 16.27% TOTAL GENERAL FUND EXPENSES 2,453,510 18,008,036 13.62% Please note: • State revenues of$574,928.77 received in May and June are realized in prior fiscal year, thus not reflected in current fiscal year budget z 8/29/2005 UNITED CITY OF YORKVILLE DETAILED REVENUE & EXPENSE REPORT AS OF JULY 31, 2005 General Fund Revenue 1 Sanitary Sewer Improvement& Expansion 25 Finance 3 Water Improvement & Expansion 27 Engineering 6 Debt Service Fund 30 Police 7 Water Operations 32 Planning and Development 10 Sewer Maintenance 36 Streets and Alleys 11 Land Cash 39 Health and Sanitation 13 Land Acquisition 43 Motor Fuel Tax Fund 15 Parks & Recreation 44 Municipal Building 17 Working Cash 50 Police Equipment Capital 19 Library 51 Public Works Equipment Capital 21 Fox Industrial 55 Parks& Recreation Equipment Capital 23 Countryside TIF 57 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 1 DIME: 11:15:31 DETAILED REVENUE & EXPENSE REPORT 25% of Fiscal Year F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY 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 40,000.00 92,000.00 550,000.00 16.7 01-000-40-00-3997 IN TOWN ROAD PROGRAM FUNDING 3,783,562.20 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 406, 959.02 672,768.40 1,393,821.00 48.2 01-000-40-00-4001 TOWN ROAD/BRIDGE TAX 29,488.05 46,327.29 98,000.00 47.2 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 3,008.80 3,008.80 10,000.00 30.0 01-000-40-00-4020 STATE INCOME TAX 0.00 55,547.64 638,820.00 8.6 01-000-40-00-4030 MUNICIPAL SALES TAX 199,818.84 199,618.84 2,308, 900.00 8.6 01-000-40-00-4032 STATE USE TAX 10,065.40 10,065.40 97,006.00 10.3 01-000-40-00-4040 MUNICIPAL UTILITY TAX 78, 669.33 78, 669.33 500,000.00 15.7 01-000-40-00-4041 UTILITY TAX - NICOR 0.00 0.00 100,000.00 0.0 01-000-40-00-4042 UTILITY TAX - CABLE TV 0.00 0.00 65,000.00 0.0 01-000-40-00-4043 UTILITY TAX - TELEPHONE 37,269.61 40,963.59 325,000.00 12.6 01-000-40-00-4050 HOTEL TAX 1, 647.48 4,794.22 20,000.00 23.9 01-000-40-00-4060 TRAFFIC SIGNAL REVENUE 0.00 0.00 5,000.00 0.0 TOTAL TAXES 4,590, 488.73 4,987, 565.71 14,519, 607.00 34.3 LICENSES & PERMITS 01-000-41-00-4100 LIQUOR LICENSE 600.00 2, 113.52 25,000.00 8.4 01-000-41-00-4101 OTHER LICENSES 0.00 50.00 4,500.00 1.1 01-000-41-00-4110 BUILDING PERMITS 103,879.00 294,380.00 1,100,000.00 26.7 TOTAL LICENSES & PERMITS 104, 479.00 296,543.52 1,129,500.00 26.2 CHARGES FOR SERVICES 01-000-42-00-4205 FILING FEES 1,032.40 1,409.40 25,000.00 5.6 01-000-42-00-4206 GARBAGE SURCHARGE 112.19 32,896.06 192,780.00 17.0 01-000-42-00-4207 REFUSE STICKERS 0.00 0.00 0.00 0.0 01-000-42-00-4208 COLLECTION FEE - YBSD 0.00 0.00 34,000.00 0.0 01-000-42-00-4209 PLANNING FEE 0.00 0.00 39,899.00 0.0 01-000-42-00-4210 DEVELOPMENT FEES 28, 436.97 156, 969.06 1,175,000.00 13.3 P1 )ATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 2 LIME: 11:15:31 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 CD: GL470002.WOW FUND: GENERAL FUND FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ;ENERAL 2E VENUES CHARGES FOR SERVICES 01-000-42-00-4211 ENGINEERING CAPITAL FEE 900.00 2,900.00 27,500.00 10.5 TOTAL CHARGES FOR SERVICES 30, 481.56 194,174.52 1,494,179.00 12.9 FINES & FORFEITS 01-000-43-00-4310 TRAFFIC FINES 6,551.50 16,549.56 73,500.00 22.5 01-000-43-00-4315 REIMBURSE POLICE TRAINING 0.00 0.00 0.00 0.0 01-000-43-00-4320 ORDINANCE FEES 110.00 255.00 2,500.00 10.2 TOTAL FINES & FORFEITS 6, 661.50 16,804.56 76,000.00 22.1 MISCELLANEOUS 01-000-44-00-4401 DARE DONATIONS 0.00 100.00 1,250.00 8.0 01-000-44-00-4402 ROB ROY CREEK HYDRAULIC STUDY 0.00 0.00 40,000.00 0.0 01-000-44-00-4410 REIMBURSEMENTS - OTHER GOVTS 0.00 0.00 0.00 0.0 01-000-44-00-4411 REIMBURSEMENTS-POLICE PROTECTN 90.00 585.00 3,000.00 19.5 01-000-44-00-4420 SIDWALK CONSTRUCTION 0.00 0.00 0.00 0.0 01-000-44-00-4490 MISCELLANEOUS INCOME 389.71 1,829.86 10,000.00 18.2 TOTAL MISCELLANEOUS 479.71 2,514.86 54,250.00 4.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 TOTAL INTERGOVERNMENTAL 0.00 0.00 2,500.00 0.0 INTEREST 01-000-46-00-4600 INVESTMENT INCOME 23,042.84 53,845.52 20,000.00 269.2 TOTAL INTEREST 23,042.84 53,845.52 20,000.00 269.2 P2 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 3 LIME: 11:15:31 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 LD: GL470002.WOW FUND: GENERAL FUND FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED 3ENERAL 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 50, 000.00 200,000.00 25.0 01-000-49-00-4920 TRANSFER FROM SEWER MAINT. 17,500.00 17,500.00 70,000.00 25.0 01-000-49-00-4925 TRANSFER FROM SAN. SEWER IMPR 50,000.00 50,000.00 200,000.00 25.0 01-000-49-00-4930 TRANSFER FROM WATER IMPROVE. 50,000.00 50,000.00 200,000.00 25.0 01-000-49-00-4935 TRANSFER FROM LAND CASH 0.00 0.00 42,000.00 0.0 TOTAL TRANSFERS 167, 500.00 167, 500.00 712,000.00 23.5 TOTAL REVENUES: GENERAL 4, 923, 133.34 5,718, 948.69 18,008,036.00 31.7 FINANCE & ADMINISTRATION 3XPENSES PERSONNEL SERVICES 01-110-50-00-5100 SALARIES - MAYOR 0.00 0.00 7,500.00 0.0 01-110-50-00-5101 SALARIES - CITY CLERK 0.00 0.00 3,600.00 0.0 01-110-50-00-5102 SALARIES - CITY TREASURER 0.00 0.00 3, 600.00 0.0 01-110-50-00-5103 SALARIES - ALDERMAN 0.00 0.00 29,080.00 0.0 01-110-50-00-5104 SALARIES - LIQUOR COMMISSIONER 0.00 0.00 1,000.00 0.0 01-110-50-00-5105 SALARIES - CITY ATTORNEY 884.80 2, 654.40 13,500.00 19.6 01-110-50-00-5106 SALARIES - ADMINISTRATIVE 39, 160.72 127,712.38 557,237.00 22.9 01-110-50-00-5136 SALARIES - PART TIME 5,709.09 14,242.01 45,072.00 31.5 01-110-50-00-5137 SALARIES - OVERTIME 54.81 54.81 1,500.00 3.6 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 0.00 10,000.00 0.0 01-110-50-00-5203 BENEFITS - HEALTH INSURANCE 62, 494.50 178,225.92 825,000.00 21.6 01-110-50-00-5204 BENEFITS - GROUP LIFE INSURANC (56.67) 1,171:18 20,000.00 5.8 01-110-50-00-5205 BENEFITS - DENTAL/VISION ASST 2,235.54 5,390.10 68,093.00 7.9 TOTAL PERSONNEL SERVICES 110,482.79 329,450.80 1,585,182.00 20.7 PROFESSIONAL SERVICES 01-110-61-00-5300 LEGAL SERVICES 8,253.50 13,863.50 35,000.00 39.6 01-110-61-00-5304 AUDIT FEES & EXPENSES 0.00 0.00 25,500.00 0.0 P3 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 4 TIME: 11:15:31 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY 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 4,455.00 4,455.00 15,000.00 29.7 01-110-61-00-5310 EMPLOYEE ASSISTANCE 422.50 422.50 4,500.00 9.3 01-110-61-00-5311 CODIFICATION 0.00 2,915.00 5,000.00 58.3 01-110-61-00-5314 BUILDING INSPECTIONS 84,473.55 154,558.05 880,000.00 17.5 01-110-61-00-5322 BONDING 0.00 0.00 0.00 0.0 TOTAL PROFESSIONAL SERVICES 97, 604.55 176,214.05 970,000.00 18.1 CONTRACTUAL SERVICES 01-110-62-00-5400 INSURANCE-LIABILITY & PROPERTY 0.00 0.00 130,000.00 0.0 01-110-62-00-5401 CONTRACTUAL SERVICES 1,014.87 2,877.75 37,500.00 7.6 01-110-62-00-5403 SPECIAL CENSUS 0.00 0.00 66,000.00 0.0 01-110-62-00-5404 CABLE CONSORTIUM FEE 0.00 0.00 30,000.00 0.0 01-110-62-00-5406 OFFICE CLEANING 2, 677.42 1,100.00 7,500.00 14.6 01-110-62-00-5410 MAINTENANCE - OFFICE EQUIPMENT 0.00 0.00 500.00 0.0 01-110-62-00-5411 MAINTENANCE - COMPUTERS 0.00 0.00 2,000.00 0.0 01-110-62-00-5412 MAINTENANCE - PHOTOCOPIERS 1, 616.00 3,232.00 19,392.00 16.6 01-110-62-00-5421 WEARING APPAREL 60.00 108.00 1,740.00 6.2 01-110-62-00-5427 FACADE PROGRAM 0.00 0.00 20,000.00 0.0 01-110-62-00-5436 TELEPHONE 1,024.87 2,082.17 21,000.00 9.9 01-110-62-00-5437 ACCTG SYSTEM SERVICE FEE 0.00 300.00 7, 650.00 3.9 01-110-62-00-5438 CELLULAR TELEPHONE 118.38 242.52 2,300.00 10.5 01-110-62-00-5439 TELEPHONE SYSTEMS MAINTENANCE 0.00 0.00 11,000.00 0.0 TOTAL CONTRACTUAL SERVICES 6, 511.54 9,942.44 356,582.00 2.7 PROFESSIONAL DEVELOPMENT 01-110-64-00-5600 DUES 0.00 300.00 4,000.00 7.5 01-110-64-00-5601 ILLINOIS MUNICIPAL LEAGUE DUES 0.00 0.00 690.00 0.0 01-110-64-00-5603 SUBSCRIPTIONS 35.00 35.00 500.00 7.0 01-110-64-00-5604 TRAINING & CONFERENCES 1,870.00 1,735.00 11,000.00 15.7 01-110-64-00-5605 TRAVEL/MEALS/LODGING 934.68 981.40 17,000.00 5.7 01-110-64-00-5607 PUBLIC RELATIONS 78.64 4,419.79 18,000.00 24.5 P4 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 5 TIME: 11:15:32 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED FINANCE & ADMINISTRATION EXPENSES PROFESSIONAL DEVELOPMENT 01-110-64-00-5608 SPONSORSHIPS 0.00 0.00 1,500.00 0.0 TOTAL PROFESSIONAL DEVELOPMENT 2, 918.32 7,471.19 52, 690.00 14.1 OPERATIONS 01-110-65-00-5800 CONTINGENCIES 1, 620.00 1, 620.00 185, 170.00 0.8 01-110-65-00-5801 FUND BALANCE RESERVE 0.00 0.00 0.00 0,0 01-110-65-00-5802 OFFICE SUPPLIES 1,328.04 3, 120.53 12,000.00 26.0 01-110-65-00-5804 OPERATING SUPPLIES 651.21 921.57 13,000.00 7.0 01-110-65-00-5808 POSTAGE & SHIPPING 1, 196.32 2, 173.24 11,000.00 19.7 01-110-65-00-5809 PRINTING & COPYING 33.90 118.17 10,500.00 1.1 01-110-65-00-5810 PUBLISHING & ADVERTISING 0.00 305.01 3,500.00 8.7 01-110-65-00-5844 MARKETING - HOTEL TAX 58.48 58.48 20,000.00 0.2 TOTAL OPERATIONS 4,887.95 8,317.00 255, 170.00 3.2 RETIREMENT 01-110-72-00-6500 IMRF PARTICIPANTS 3,487.43 10, 666.39 47,791.00 22.3 01-110-72-00-6501 SOCIAL SECURITY & MEDICARE 3,579.48 11,253.70 52,821.00 21.3 TOTAL RETIREMENT 7,066.91 21, 920.09 100,612.00 21.7 CAPITAL OUTLAY 01-110-75-00-7002 COMPUTER EQUIP & SOFTWARE 50.00 2,313.57 13,500.00 17.1 01-110-75-00-7003 OFFICE EQUIPMENT 0.00 389.94 3,000.00 12.9 TOTAL CAPITAL OUTLAY 50.00 2,703.51 16,500.00 16.3 OTHER OPERATING EXPENSES 01-110-78-00-9001 CITY TAX REBATE 0.00 0.00 1,200.00 0.0 01-110-78-00-9002 NICOR GAS 2, 931.40 4,727.26 30,000.00 15.7 01-110-78-00-9003 SALES TAX REBATE 80, 604 .17 80, 604.17 555,300.00 14.5 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 83, 535.57 85,331.43 637,704.00 13.3 P5 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 6 DIME: 11:15:32 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED FINANCE & ADMINISTRATION TRANSFERS 01-110-99-00-9923 TRANSFER TO LIBRARY 5,250.00 5,250.00 31,500.00 16.6 01-110-99-00-9925 TRANSFER TO SAN SEWER 37,500.00 37,500.00 150,000.00 25.0 01-110-99-00-9940 TRANSFER TO PARK & RECREATION 232, 141.74 232,141.74 928,567.00 24.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 12,380.75 12,380.75 49,523.00 25.0 01-110-99-00-9965 TRANSFER TO DEBT SERVICE 0.00 0.00 0.00 0.0 TOTAL TRANSFERS 287,272.49 287,272.49 1,159,590.00 24.7 TOTAL EXPENSES: FINANCE & ADMINISTRATION 600,330.12 928, 623.00 5,134,030.00 18.0 ENGINEERING EXPENSES PERSONNEL SERVICES 01-150-50-00-5107 SALARIES-EMPLOYEES 20,014.75 59,589.29 248,919.00 23.9 01-150-50-00-5137 SALARIES-OVERTIME 0.00 0.00 1,000.00 0.0 TOTAL PERSONNEL SERVICES 20,014.75 59, 589.29 249,919.00 23.8 CONTRACTUAL SERVICES 01-150-62-00-5401 CONTRACTUAL SERVICES 33,695.18 33, 695.18 20,000.00 168.4 01-150-62-00-5402 GIS SYSTEM 0.00 0.00 5,000.00 0.0 01-150-62-00-5403 FEES 0.00 0.00 1,000.00 0.0 01-150-62-00-5409 MAINTENANCE-VEHICLES 0.00 54.96 3,500.00 1.5 01-150-62-00-5410 MAINTENANCE-OFFICE EQUIP 0.00 0.00 1,000.00 0.0 01-150-62-00-5411 MAINTENANCE-COMPUTERS 0.00 0.00 2,500.00 0.0 01-150-62-00-5421 WEARING APPAREL 0.00 0.00 1,100.00 0.0 01-150-62-00-5438 CELLULAR TELEPHONE 177.57 423.77 2,800.00 15.1 TOTAL CONTRACTUAL SERVICES 33,872.75 34, 173.91 36,900.00 92.6 PROFESSIONAL DEVELOPMENT 01-150-64-00-5600 DUES 0.00 0.00 300.00 0.0 01-150-64-00-5604 TRAINING & CONFERENCES 0.00 0.00 6,000.00 0.0 P6 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 7 DIME: 11:15:32 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL a ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ENGINEERING EXPENSES PROFESSIONAL DEVELOPMENT 01-150-64-00-5605 TRAVEL EXPENSE 956.40 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 956.40 956.40 7,500.00 12.7 OPERATIONS 01-150-65-00-5801 ENGINEERING SUPPLIES 12.50 259.05 3,000.00 8.6 01-150-65-00-5802 OFFICE SUPPLIES 44.85 630.08 2,500.00 25.2 01-150-65-00-5809 PRINTING & COPYING 6.00 38.20 2,000.00 1.9 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 63.35 927.33 35,000.00 2.6 RETIREMENT 01-150-72-00-6500 IMRF PARTICIPANTS 1, 629.21 4,850.60 20, 343.00 23.8 01-150-72-00-6501 SOCIAL SECURITY & MEDICARE 1, 498.48 4,460.63 19,120.00 23.3 TOTAL RETIREMENT 3, 127.69 9,311.23 39,463.00 23.5 CAPITAL OUTLAY 01-150-75-00-7002 COMPUTER EQUIPMENT & SOFTWARE 1,714.40 2, 678.79 3,850.00 69.5 01-150-75-00-7003 OFFICE EQUIPMENT 0.00 69.98 500.00 13.9 TOTAL CAPITAL OUTLAY 1,714.40 2,748.77 4,350.00 63.1 TOTAL EXPENSES: ENGINEERING 59,749.34 107,706.93 373,132.00 28.8 PUBLIC SAFETY/POLICE DEPT. EXPENSES PERSONNEL SERVICES 01-210-50-00-5107 SALARIES - EMPLOYEES 48, 910.59 140, 510.82 608,512.00 23.0 P7 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 8 LIME: 11:15:32 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ED: GL470002.WOW FUND: GENERAL FUND FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ?UBLIC SAFETY/POLICE DEPT. 3XPENSES PERSONNEL SERVICES 01-210-50-00-5131 SALARIES-CHIEF/LIEUTENANT/SERG 43, 568.93 131,731.11 522,284.00 25.2 01-210-50-00-5133 SALARIES - COPS 8,288.06 25,176.78 150,158.00 16.7 01-210-50-00-5134 SALARIES - CROSSING GUARD 0.00 2,241.00 19,000.00 11.7 01-210-50-00-5135 SALARIES - POLICE CLERKS 8, 148.34 24,444.99 103, 626.00 23.5 01-210-50-00-5136 SALARIES - PART TIME 2,714.99 8,255.25 30,000.00 27.5 01-210-50-00-5137 SALARIES - OVERTIME 2, 416.43 9,961.10 50,000.00 19.9 01-210-50-00-5200 CADET PROGRAM 0.00 0.00 10,000.00 0.0 TOTAL PERSONNEL SERVICES 114,047.34 342,321.05 1,493,580.00 22.9 PROFESSIONAL SERVICES 01-210-61-00-5300 LEGAL SERVICES 95.87 2, 698.37 20,000.00 13.4 TOTAL PROFESSIONAL SERVICES 95.87 2, 698.37 20,000.00 13.4 CONTRACTUAL SERVICES 01-210-62-00-5408 MAINTENANCE - EQUIPMENT 1,254 .63 2,347.19 8,000.00 29.3 01-210-62-00-5409 MAINTENANCE - VEHICLES 2, 450.35 3,798.76 21,000.00 18.0 01-210-62-00-5410 MAINT-OFFICE EQUIPMENT 0.00 106.00 2,500.00 4.2 01-210-62-00-5411 MAINTENANCE - COMPUTERS 0.00 0.00 2,100.00 0.0 01-210-62-00-5414 WEATHER WARNING SIREN MAINT 0.00 390.00 8,000.00 4.8 01-210-62-00-5421 WEARING APPAREL 784.33 1,366.04 27,000.00 5.0 01-210-62-00-5422 COPS GRANT IV - VESTS 0.00 0.00 2,500.00 0.0 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 170.00 170.00 1,500.00 11.3 01-210-62-00-5430 HEALTH SERVICES 585.73 662.18 3,000.00 22.0 01-210-62-00-5431 LABORATORY FEES 0.00 0.00 1,000.00 0.0 01-210-62-00-5436 TELEPHONE 1,209.22 2,302.08 20,000.00 11.5 01-210-62-00-5438 CELLULAR TELEPHONE 897.33 1,996.11 14,000.00 14.2 01-210-62-00-5440 PAGERS 0.00 0.00 0.00 0.0 01-210-62-00-5441 MTD-ALERTS FEE 0.00 0.00 2, 400.00 0.0 TOTAL CONTRACTUAL SERVICES 7,351.59 13,138.36 114,000.00 11.5 P8 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 9 TIME: 11:15:32 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED PUBLIC SAFETY/POLICE DEPT. PROFESSIONAL DEVELOPMENT 01-210-64-00-5600 DUES 0.00 0.00 2,250.00 0.0 01-210-64-00-5603 SUBSCRIPTIONS 64.50 64.50 300.00 21.5 01-210-64-00-5604 TRAINING & CONFERENCE 1,575.00 6,430.00 19,000.00 33.8 01-210-64-00-5605 TRAVEL EXPENSES 2, 578.08 6,572.67 9,000.00 73.0 01-210-64-00-5606 COMMUNITY RELATIONS 37.60 74.20 5,500.00 1.3 01-210-64-00-5607 POLICE COMMISSION 2,240.00 2,240.00 23,000.00 9.7 01-210-64-00-5608 TUITION REIMBURSEMENT 1,520.00 1, 520.00 14,000.00 10.8 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 8,015.18 16, 901.37 79,175.00 21.3 OPERATIONS 01-210-65-00-5800 CONTINGENCIES 0.00 0.00 0.00 0.0 01-210-65-00-5802 OFFICE SUPPLIES 155.16 799.30 6,500.00 12.2 01-210-65-00-5804 OPERATING SUPPLIES 546.34 1,164.36 16,000.00 7.2 01-210-65-00-5808 POSTAGE & SHIPPING 27.60 27.92 3,000.00 0.9 01-210-65-00-5809 PRINTING & COPYING 54 .50 308.90 4,500.00 6.8 01-210-65-00-5810 PUBLISHING & ADVERTISING 0.00 0.00 1,000.00 0.0 01-210-65-00-5812 GASOLINE 3,202.33 7,383.43 36,300.00 20.3 01-210-65-00-5813 AMMUNITION 0.00 0.00 5,000.00 0.0 TOTAL OPERATIONS 3, 985.93 9, 683.91 72,300.00 13.3 RETIREMENT 01-210-72-00-6500 IMRF PARTICIPANTS 663.28 1, 989.84 8,732.00 22.7 01-210-72-00-6501 SOCIAL SECURITY & MEDICARE 8,726.84 26, 197.23 115,170.00 22.7 01-210-72-00-6502 POLICE PENSION 35,293.16 35,293.16 231,686.00 15.2 TOTAL RETIREMENT 44, 683.28 63, 480.23 355,588.00 17.8 CAPITAL OUTLAY 01-210-75-00-7002 COMPUTER EQUIP & SOFTWARE 149.00 149.00 8,500.00 1.7 TOTAL CAPITAL OUTLAY 149.00 149.00 8,500.00 1.7 P9 )ATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 10 DIME: 11:15:32 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 CD: GL470002.WOW FUND: GENERAL FUND FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ?UBLIC SAFETY/POLICE DEPT. OTHER OPERATING EXPENSES 01-210-78-00-9004 BIKE PATROL 1, 160.39 1,422.51 2,000.00 71.1 TOTAL OTHER OPERATING EXPENSES 1,160.39 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. 179,488.58 449,794.80 2,145,143.00 20.9 PLANNING & DEVELOPMENT EXPENSES PERSONNEL SERVICES 01-220-50-00-5107 EMPLOYEE SALARIES 0.00 0.00 131,086.00 0.0 TOTAL PERSONNEL SERVICES 0.00 0.00 131,086.00 0.0 PROFESSIONAL SERVICES 01-220-61-00-5300 LEGAL SERVICES 4,792.81 5,795.31 20,000.00 28.9 TOTAL PROFESSIONAL SERVICES 4,792.81 5,795.31 20,000.00 28.9 CONTRACTUAL SERVICES 01-220-62-00-5401 CONTRACTUAL SERVICES 441.00 441.00 50,000.00 0.8 01-220-62-00-5430 PLANNING CONSULTANT 823.50 823.50 20,000.00 4.1 01-220-62-00-5432 ECONOMIC DEVELOPMENT 0.00 0.00 45,000.00 0.0 01-220-62-00-5438 CELULAR TELEPHONE 0.00 0.00 1,000.00 0.0 TOTAL CONTRACTUAL SERVICES 1,264.50 1,264.50 116,000.00 1.0 PROFESSIONAL DEVELOPMENT 01-220-64-00-5600 DUES 0.00 0.00 200.00 0.0 01-220-64-00-5604 TRAINING & CONFERENCES 0.00 0.00 6,000.00 0.0 P10 )ATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 11 LIME: 11:15:32 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ED: GL470002.WOW FUND: GENERAL FUND FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ?LANNING & DEVELOPMENT ;XPENSES 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 0.00 9, 625.00 0.0 OPERATIONS 01-220-65-00-5804 OPERATING SUPPLIES 0.00 40.84 5,000.00 0.8 01-220-65-00-5809 PRINTING & COPYING 0.00 42.00 2,500.00 1.6 01-220-65-00-5810 PUBLISHING & ADVERTISING 0.00 2,130.77 10,000.00 21.3 01-220-65-00-5814 BOOKS & MAPS 639.00 639.00 3,000.00 21.3 TOTAL OPERATIONS 639.00 2,852.61 20,500.00 13.9 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 0.00 7,500.00 0.0 01-220-75-00-7003 OFFICE EQUIPMENT 0.00 0.00 2,500.00 0.0 TOTAL CAPITAL OUTLAY 0.00 0.00 10,000.00 0.0 TOTAL EXPENSES: PLANNING & DEVELOPMENT 6, 696.31 9, 912.42 324, 607.00 3.0 STREETS EXPENSES PERSONNEL SERVICES 01-410-50-00-5107 SALARIES - EMPLOYEE 13, 940.22 39,729.42 182,345.00 21.7 01-410-50-00-5136 SALARIES - PART TIME 0.00 0.00 11,000.00 0.0 01-410-50-00-5137 SALARIES - OVERTIME 1, 313.08 3, 122.75 20,400.00 15.3 P11 )ATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 12 LIME: 11:15:32 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ED: GL470002.WOW FUND: GENERAL FUND FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL PERSONNEL SERVICES 15,253.30 42,852.17 213,745.00 20.0 PROFESSIONAL SERVICES 01-410-61-00-5313 ENGINEERING - IN TOWN RD FROG 0.00 0.00 215,210.00 0.0 01-410-61-00-5314 INSPECTIONS & LICENSES 60.00 60.00 200.00 30.0 TOTAL PROFESSIONAL SERVICES 60.00 60.00 215,410.00 0.0 CONTRACTUAL SERVICES 01-410-62-00-5401 CONTRACTUAL SERVICES 150.00 250.00 2,000.00 12.5 01-410-62-00-5408 MAINTENANCE-EQUIPMENT 82.80 284.70 9,000.00 3.1 01-410-62-00-5409 MAINTENANCE-VEHICLES 417.35 727.03 11,550.00 6.2 01-410-62-00-5414 MAINTENANCE-TRAFFIC SIGNALS 893.07 1, 688.07 24,000.00 7.0 01-410-62-00-5415 MAINTENANCE-STREET LIGHTS 2,358.19 3,401.32 25,000.00 13.6 01-410-62-00-5420 MAINTENANCE-STORM SEWER 0.00 0.00 10,000.00 0.0 01-410-62-00-5421 WEARING APPAREL 318.98 945.96 6,000.00 15.7 01-410-62-00-5434 RENTAL-EQUIPMENT 0.00 0.00 2,000.00 0.0 01-410-62-00-5435 ELECTRICITY 3,115.17 6,443.46 51,800.00 12.4 01-410-62-00-5438 CELLULAR TELEPHONE 133.11 451.22 3,300.00 13.6 01-410-62-00-5440 STREET LIGHTING 4,346.61 4,346.61 6,000.00 72.4 TOTAL CONTRACTUAL SERVICES 11,815.28 18,538.37 150, 650.00 12.3 PROFESSIONAL DEVELOPMENT 01-410-64-00-5604 TRAINING & CONFERENCES 181.34 412.11 5,000.00 8.2 TOTAL PROFESSIONAL DEVELOPMENT 181.34 412.11 5,000.00 8.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,399.07 4,199.47 25,800.00 16.2 01-410-65-00-5812 GASOLINE 862.01 2, 943.51 24,000.00 12.2 01-410-65-00-5815 HAND TOOLS 0.00 0.00 2,500.00 0.0 01-410-65-00-5817 GRAVEL 0.00 0.00 6,500.00 0.0 TOTAL OPERATIONS 3,261.08 7, 142.98 58,800.00 12.1 P12 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 13 TIME: 11:15:32 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL o ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED STREETS RETIREMENT 01-410-72-00-6500 IMRF PARTICIPANTS 1,157.28 3,403.81 16,783.00 20.2 01-410-72-00-6501 SOCIAL SECURITY & MEDICARE 1,166.88 3,278.24 16, 616.00 19.7 TOTAL RETIREMENT 2,324.16 6, 682.05 33,399.00 20.0 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 99.92 0.00 0.00 0.0 01-410-75-00-7004 SAFETY EQUIPMENT (39.70) (39.70) 1,000.00 (3.9) 01-410-75-00-7099 GRANDE RESERVE PERIMETER ROADS 9, 561.50 105,358.60 4,000,000.00 2.6 01-410-75-00-7100 STREET REHAB PROJECTS 0.00 8,470.92 40,000.00 21.1 01-410-75-00-7101 IN TOWN ROAD PROGRAM 309,839.36 593,928.41 2,345,000.00 25.3 01-410-75-00-7102 TREE & STUMP REMOVAL 0.00 5,275.00 30,000.00 17.5 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 945.00 1,789.00 18,000.00 9.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 0.00 10,000.00 0.0 01-410-75-00-7107 ROAD CONTRIBUTION FUND-RESERVE 0.00 0.00 490,000.00 0.0 TOTAL CAPITAL OUTLAY 320, 406.08 735,077.83 8,567, 950.00 8.5 TRANSFERS 01-410-99-00-9930 TRANSFER TO WATER IMPROVEMENT 53,750.00 53,750.00 215,000.00 25.0 TOTAL TRANSFERS 53,750.00 53,750.00 215,000.00 25.0 TOTAL EXPENSES: STREETS 407,051.24 864,515.51 9,459, 954 .00 9.1 HEALTH & SANITATION EXPENSES CONTRACTUAL SERVICES 01-540-62-00-5442 GARBAGE SERVICES 46,474.72 92,357.20 565, 670.00 16.3 01-540-62-00-5443 LEAF PICKUP 600.00 600.00 5,500.00 10.9 TOTAL CONTRACTUAL SERVICES 47,074.72 92, 957.20 571,170.00 16.2 P13 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 14 DIME: 11:15:32 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: GENERAL FUND FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL EXPENSES: HEALTH & SANITATION 47,074.72 92,957.20 571,170.00 16.2 DOTAL FUND REVENUES 4,923,133.34 5,718,948.69 18,008,036.00 31.7 DOTAL FUND EXPENSES 1,300,390.31 2,453,509.86 18,008,036.00 13.6 FUND SURPLUS (DEFICIT) 3, 622,743.03 3,265,438.83 0.00 100.0 P14 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 15 DIME: 11:15:32 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: MOTOR FUEL TAX FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL o ACCOUNT JULY 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 19,794 .03 61,792.47 268,304.00 23.0 15-000-40-00-4065 IDOT TRUCK ACCESS GRANT 0.00 0.00 0.00 0.0 TOTAL TAXES 19,794 .03 61,792.47 743,304.00 8.3 INTEREST 15-000-46-00-4600 INVESTMENT INCOME 1,040.86 3,059.66 5,000.00 61.1 TOTAL INTEREST 1,040.86 3,059.66 5,000.00 61.1 TOTAL REVENUES: 20,834 .89 64,852.13 748,304.00 8.6 EXPENSES OPERATIONS 15-000-65-00-5800 CONTINGENCY 2,275.00 2,275.00 145,250.00 1.5 15-000-65-00-5818 SALT 0.00 0.00 51,800.00 0.0 TOTAL OPERATIONS 2,275.00 2,275.00 197,050.00 1.1 CAPITAL OUTLAY 15-000-75-00-7007 SIGNS 647.50 647.50 9,990.00 6.4 15-000-75-00-7008 CRACK FILLING 1,269.12 1, 269.12 30,000.00 4.2 15-000-75-00-7107 CONSTRUCTION ENGINEERING 11,280.22 11,280.22 150,000.00 7.5 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 0.00 9,600.00 0.0 15-000-75-00-7111 HOT PATCH 60.00 60.00 8,000.00 0.7 15-000-75-00-7112 FAXON ROAD ENGINEERING 0.00 0.00 1,000.00 0.0 15-000-75-00-7113 COUNTRYSIDE PKWY CONSTRUCTION 0.00 0.00 300,000.00 0.0 TOTAL CAPITAL OUTLAY 13,256.84 13,256.84 508,590.00 2.6 TRANSFERS 15-000-99-00-9960 TRANSFER TO FOX IND FUND 0.00 0.00 42, 664.00 0.0 P15 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 16 PIME: 11:15:32 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: MOTOR FUEL TAX FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL TRANSFERS 0.00 0.00 42, 664.00 0.0 TOTAL EXPENSES: 15,531.84 15,531.84 748,304.00 2.0 DOTAL FUND REVENUES 20,834.89 64,852.13 748,304.00 8.6 DOTAL FUND EXPENSES 15,531.84 15,531.84 748,304.00 2.0 FUND SURPLUS (DEFICIT) 5,303.05 49,320.29 0.00 100.0 Pie DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 17 TIME: 11:15:32 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: MUNICIPAL BUILDLING FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY 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 2,700.00 8,550.00 105,000.00 8.1 TOTAL CHARGES FOR SERVICES 2,700.00 8, 550.00 105,000.00 8.1 TRANSFERS 16-000-49-00-4901 TRANSFER FROM GENERAL FUND 12,380.75 12,380.75 49,523.00 25.0 TOTAL TRANSFERS 12, 380.75 12,380.75 49,523.00 25.0 TOTAL REVENUES: 15,080.75 20, 930.75 199,523.00 10.4 EXPENSES CONTRACTUAL SERVICES 16-000-62-00-5416 MAINT-GENERAL BLDG & GROUNDS 0.00 0.00 8,000.00 0.0 TOTAL CONTRACTUAL SERVICES 0.00 0.00 8,000.00 0.0 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 1,200.00 1,200.00 13,000.00 9.2 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 3, 180.93 3,480.93 10,000.00 34.8 16-000-75-00-7204 BLDG MAINT - CITY HALL 413.01 1,264.01 10,000.00 12.6 16-000-75-00-7205 BLDG IMPROVEMENTS-LIBRARY 521.20 1,031.20 4,000.00 25.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 41, 119.60 41,119.60 45,000.00 91.3 TOTAL CAPITAL OUTLAY 46,434.74 48,095.74 87,600.00 54.9 P17 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 18 TIME: 11:15:32 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: MUNICIPAL BUILDLING FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY 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 25,980.75 103,923.00 25.0 TOTAL TRANSFERS 25, 980.75 25,980.75 103,923.00 25.0 TOTAL EXPENSES: 72,415.49 74,076.49 199,523.00 37.1 TOTAL FUND REVENUES 15,080.75 20,930.75 199, 523.00 10.4 TOTAL FUND EXPENSES 72,415.49 74,076.49 199,523.00 37.1 FUND SURPLUS (DEFICIT) (57,334.74) (53,145.74) 0.00 100.0 P18 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 19 DIME: 11:15:32 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: POLICE EQUIPMENT CAPITAL FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY 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 6, 600.00 20,400.00 146,250.00 13.9 TOTAL CHARGES FOR SERVICES 6, 600.00 20, 400.00 146,250.00 13.9 MISCELLANEOUS 20-000-44-00-4402 K-9 DONATIONS 200.00 200.00 1,000.00 20.0 20-000-44-00-4403 IN CAR VIDEO DONATIONS 700.00 1,270.00 2,200.00 57.7 20-000-44-00-4404 DONATIONS 0.00 0.00 500.00 0.0 20-000-44-00-4405 WEATHER WARNING SIREN 375.00 375.00 30,000.00 1.2 20-000-44-00-4431 SALE OF POLICE SQUADS 0.00 0.00 500.00 0.0 TOTAL MISCELLANEOUS 1,275.00 1,845.00 34,200.00 5.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: 7,875.00 22,245.00 250,450.00 8.8 EXPENSES WEAPONS 20-000-65-00-5611 LETHAL/NON-LETHAL WEAPONS 0.00 0.00 6,825.00 0.0 TOTAL WEAPONS 0.00 0.00 6,825.00 0.0 P19 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 20 PIME: 11:15:32 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 LD: GL470002.WOW FUND: POLICE EQUIPMENT CAPITAL FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL a ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED 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 36, 974.64 37, 635.64 74,000.00 50.8 20-000-75-00-7006 CAR BUILD OUT 0.00 0.00 26,000.00 0.0 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 36,974.64 37,635.64 201,000.00 18.7 OTHER 20-000-78-00-9009 RESERVE 0.00 0.00 18,515.00 0.0 TOTAL OTHER 0.00 0.00 18,515.00 0.0 TRANSFERS 20-000-99-00-9965 TRANSFER TO DEBT SERV FUND 6,027.50 6,027.50 24,110.00 25.0 TOTAL TRANSFERS 6,027.50 6,027.50 24,110.00 25.0 TOTAL EXPENSES: 43,002.14 43, 663.14 250,450.00 17.4 TOTAL FUND REVENUES 7,875.00 22,245.00 250,450.00 8.8 TOTAL FUND EXPENSES 43,002.14 43,663.14 250,450.00 17.4 FUND SURPLUS (DEFICIT) (35,127.14) (21,418.14) 0.00 100.0 P20 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 21 TIME: 11:15:32 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PUBLIC WORKS EQUIP CAPITAL FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL o ACCOUNT JULY 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 18,000.00 55,400.00 383,750.00 14.4 TOTAL CHARGES FOR SERVICES 18,000.00 55,400.00 383,750.00 14 .4 MISCELLANEOUS 21-000-44-00-4430 SALE OF EQUIPMENT 0.00 0.00 32,000.00 0.0 TOTAL MISCELLANEOUS 0.00 0.00 32,000.00 0.0 TRANSFERS 21-000-49-00-4915 TRANSFER FROM WATER FUND 12, 500.00 12,500.00 50,000.00 25.0 21-000-49-00-4920 TRANSFER FROM SEWER FUND 7, 500.00 7,500.00 30,000.00 25.0 TOTAL TRANSFERS 20,000.00 20,000.00 80,000.00 25.0 TOTAL REVENUES: 38,000.00 75,400.00 729, 924.00 10.3 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 0.00 375,000.00 0.0 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 0.00 3,500.00 0.0 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 861.40 14,000.00 6.1 P21 )ATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 22 .'IME: 11:15:32 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 :D: GL470002.WOW FUND: PUBLIC WORKS EQUIP CAPITAL FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ',XPENSES 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 861.40 729,924.00 0.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 861.40 729,924.00 0.1 COTAL FUND REVENUES 38,000.00 75,400.00 729, 924.00 10.3 COTAL FUND EXPENSES 0.00 861.40 729, 924.00 0.1 FUND SURPLUS (DEFICIT) 38,000.00 74,538.60 0.00 100.0 P22 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 23 TIME: 11:15:33 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PARKS & REC EQUIP CAPITAL FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY 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 750.00 750.00 13,750.00 5.4 22-000-42-00-4217 PARKS CAPITAL - DONATIONS 1,000.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 1,750.00 7,750.00 13,750.00 56.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: 1,750.00 7,750.00 23,750.00 32.6 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: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 24 TIME: 11:15:33 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 TD: GL470002.W0W FUND: PARKS & REC EQUIP CAPITAL FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY 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 0.00 0.00 0.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 5,250.00 5,574.76 6, 600.00 64.4 TOTAL CAPITAL OUTLAY 5,250.00 5,574.76 22,100.00 25.2 TOTAL EXPENSES: PARKS 5,250.00 5,574.76 22, 100.00 25.2 TOTAL FUND REVENUES 1,750.00 7,750.00 23,750.00 32.6 TOTAL FUND EXPENSES 5,250.00 5,574.76 23,750.00 23.4 FUND SURPLUS (DEFICIT) (3,500.00) 2,175.24 0.00 100.0 P24 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 25 TIME: 11:15:33 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: SANITARY SEWER IMPROVEMENT FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY 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 58,200.00 175,400.00 1,260,000.00 13.9 37-000-42-00-4221 RIVER CROSSING FEES 1, 612.50 3,043.00 20,000.00 15.2 TOTAL CHARGES FOR SERVICES 59,812.50 178,443.00 1,280,000.00 13.9 INTEREST 37-000-46-00-4600 INVESTMENT INCOME 7,015.47 21, 129.18 35,000.00 60.3 TOTAL INTEREST 7,015.47 21, 129.18 35,000.00 60.3 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 72,700.00 72,700.00 10,000,000.00 0.7 37-000-48-00-4804 SOUTHWEST SVC AREA INTERCEPTOR 0.00 0.00 5,500,000.00 0.0 TOTAL OTHER OPERATING RECEIPTS 72,700.00 72,700.00 15,500,000.00 0.4 TRANSFERS 37-000-49-00-4901 TRANSFER FROM GENERAL FUND 37,500.00 37,500.00 150,000.00 25.0 TOTAL TRANSFERS 37,500.00 37,500.00 150,000.00 25.0 TOTAL REVENUES: 177,027.97 309,772.18 20, 685,000.00 1.4 EXPENSES CONTRACTUAL SERVICES 37-000-62-00-5401 CONTRACTURAL/PROFESSIONAL SERV 0.00 0.00 50,000.00 0.0 P25 )ATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 26 'IME: 11:15:33 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 :D: GL470002.WOW FUND: SANITARY SEWER IMPROVEMENT FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED :XPENSES CONTRACTUAL SERVICES 37-000-62-00-5402 ENG/LGL/CONTINGNCY-COUNTRYSIDE 1, 602.32 1, 602.32 300,000.00 0.5 37-000-62-00-5405 ENG/LGL/CONTINGENCY-BRUELL ST. 22, 991.11 26,991.11 70,000.00 38.5 37-000-62-00-5406 ENG/LGL/CONTINGENCY-HYDRAULIC 1,745.70 1,745.70 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 26,339.13 30,339.13 420,000.00 7.2 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 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 0.00 0.00 2,850,000.00 0.0 37-000-75-00-7504 BRUELL STREET LIFT STATION 654.00 233,890.01 500,000.00 46.7 37-000-75-00-7505 ROB ROY CREEK SANITARY 954,705.25 1,281,876.05 10,000,000.00 12.8 37-000-75-00-7506 SOUTHWEST SVC AREA INTERCEPTOR 0.00 187.50 5,500,000.00 0.0 37-000-75-00-7507 SANITARY JETTER TRUCK 0.00 0.00 0.00 0.0 37-000-75-00-7508 MANHOLE REHAB PROJECT 0.00 0.00 15,000.00 0.0 37-000-75-00-7509 SCADA SYSTEM 0.00 0.00 100,000.00 0.0 37-000-75-00-7515 HEARTLAND ONSITE INTERCEPTOR 0.00 0.00 278,893.00 0.0 TOTAL CAPITAL OUTLAY 955,359.25 1,515,953.56 19,243,893.00 7.8 TRANSFERS 37-000-99-00-9901 TRANSFER TO GENERAL FUND 50,000.00 50,000.00 200,000.00 25.0 37-000-99-00-9965 TRANSFER TO DEBT SERVICE 161,553.25 161,553.25 724,155.00 22.3 TOTAL TRANSFERS 211,553.25 211,553.25 924,155.00 22.8 TOTAL EXPENSES: 1,193,251.63 1,757,845.94 20, 685,000.00 8.4 COTAL FUND REVENUES 177,027.97 309,772.18 20,685,000.00 1.4 COTAL FUND EXPENSES 1, 193,251.63 1,757,845.94 20, 685,000.00 8.4 CUND SURPLUS (DEFICIT) (1,016,223.66) (1,448,073.76) 0.00 100.0 • P26 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 27 TIME: 11:15:33 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY 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 60, 960.00 211, 660.00 1, 125,000.00 18.8 41-000-42-00-4221 SOUTHWEST WATER MAIN REVENUE 0.00 0.00 0.00 0.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 60, 960.00 211, 660.00 3,725,000.00 5.6 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 3, 307.00 9, 940.09 35,000.00 28.4 TOTAL INTEREST 3, 307.00 9, 940.09 35,000.00 28.4 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 0.00 0.00 0.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 0.00 0.00 0.0 TRANSFERS P27 )ATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 28 CIME: 11:15:33 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 [D: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED 2EVENUES TRANSFERS 41-000-49-00-4901 TRANSFER FROM GENERAL FUND 53,750.00 53,750.00 215,000.00 25.0 41-000-49-00-4915 TRANSFER FROM WATER FUND 0.00 0.00 0.00 0.0 TOTAL TRANSFERS 53,750.00 53,750.00 215,000.00 25.0 TOTAL REVENUES: 118,017.00 275, 350.09 8, 675,000.00 3.1 F,XPENSES PROFESSIONAL SERVICE 41-000-61-00-5300 LEGAL SERVICES 754.00 1,200.20 8,000.00 15.0 41-000-61-00-5301 ENGINEERING - GENERAL SERVICES 6,211.50 6,211.50 8,000.00 77.6 41-000-61-00-5400 RADIUM COMPLIANCE -CONTRACT B 0.00 0.00 3,662,730.00 0.0 41-000-61-00-5401 ENGINEERING-RADIUM CONTRACT B 4,264.40 12,414.40 425,000.00 2.9 41-000-61-00-5405 PROF. SVCS- RADIUM CONTRACT B 3,196.50 3,196.50 250,000.00 1.2 41-000-61-00-5408 CENTRAL ZONE - CONTRACT C 15,240.00 15,240.00 150,000.00 10.1 41-000-61-00-5410 ENGINEERING-CENTRAL ZONE 12,285.75 12,285.75 20,000.00 61.4 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 2, 630.30 100,000.00 2.6 41-000-61-00-5415 USGS GROUNDWATER STUDY 825.00 825.00 24,490.00 3.3 41-000-61-00-5416 USGS GROUNDWATER COUNTYWIDE 0.00 0.00 13,000.00 0.0 41-000-61-00-5417 USGS GROUNDWATER SHALLOW WATER 0.00 0.00 55,108.00 0.0 TOTAL PROFESSIONAL SERVICE 45,407.45 54,003.65 4,716,328.00 1.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 0.00 8,353.00 0.0 TOTAL OTHER 0.00 0.00 18,353.00 0.0 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 P28 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 29 TIME: 11:15:33 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED CAPITAL OUTLAY 41-000-75-00-7503 SOUTHWEST WATER MAIN PROJECT 0.00 0.00 2, 600,000.00 0.0 41-000-75-00-7504 NORTH WATER TOWER-CONTRACT A 17, 932.90 69,202.90 130,000.00 53.2 41-000-75-00-7506 APPLETREE COURT 0.00 0.00 0.00 0.0 41-000-75-00-7507 OVERSIZING - KYLYN'S CROSSING 0.00 0.00 38,877.00 0.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 17,932.90 69,202.90 3,443,877.00 2.0 TRANSFERS 41-000-99-00-9901 TRANSFER TO GENERAL FUND 50,000.00 50,000.00 200,000.00 25.0 41-000-99-00-9965 TRANSFER TO DEBT FUND 74, 110.50 74,110.50 296,442.00 25.0 TOTAL TRANSFERS 124, 110.50 124, 110.50 496,442.00 25.0 TOTAL EXPENSES: 187, 450.85 247,317.05 8, 675,000.00 2.8 TOTAL FUND REVENUES 118,017.00 275,350.09 8, 675,000.00 3.1 TOTAL FUND EXPENSES 187, 450.85 247,317.05 8, 675,000.00 2.8 FUND SURPLUS (DEFICIT) (69, 433.85) 28,033.04 0.00 100.0 P29 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 30 LIME: 11:15:33 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: DEBT SERVICE FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY 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 8, 935.00 29,263.92 100,000.00 29.2 TOTAL MISCELLANEOUS 8, 935.00 29,263.92 100,000.00 29.2 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 6,027.50 24,110.00 25.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 161,553.25 646,213.00 25.0 42-000-49-00-4930 TRANSFER FROM WATER IMPRV FUND 74,110.50 74,110.50 296,442.00 25.0 42-000-49-00-4940 TRANSFER FROM MUNICIPAL BLDG 25,980.75 25,980.75 103,923.00 25.0 TOTAL TRANSFERS 267, 672.00 267,672.00 1,070,688.00 25.0 TOTAL REVENUES: 276, 607.00 296,935.92 1, 180, 688.00 25.1 EXPENSES DEBT SERVICE 42-000-66-00-6001 CITY HALL BONDS-PRINCIPAL PMT 0.00 0.00 50,000.00 0.0 42-000-66-00-6002 CITY HALL BONDS - INTEREST PMT 0.00 26,961.25 53,923.00 49.9 42-000-66-00-6003 IRBB-BRUELL ST. INTEREST PMTS 42,717.50 42,717.50 85,435.00 50.0 42-000-66-00-6004 IRBB-BRUELL ST. PRINCIPAL PYMT 0.00 0.00 80,000.00 0.0 42-000-66-00-6005 NORTH H2O TOWER INTEREST PYMT 0.00 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 116,575.00 233, 150.00 50.0 42-000-66-00-6008 COUNTRYSIDE ALT REV PRINC PYMT 0.00 0.00 120,000.00 0.0 42-000-66-00-6009 COUNTRYSIDE ALT REV INT PYMT 0.00 60,318.75 120, 638.00 49.9 42-000-66-00-6010 COMED/HYDRAULIC INTEREST PYMT 0.00 0.00 43,128.00 0.0 42-000-66-00-6011 COM ED/HYDRAUL DEBT CERT PRINC 21, 608.25 21, 608.25 135,000.00 16.0 P30 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 31 DIME: 11:15:33 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: DEBT SERVICE FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES DEBT SERVICE 42-000-66-00-6050 LOAN PAYMENT-SANITARY SIPHON 19, 489.99 19,489.99 38,980.00 49.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 24,037.15 24,037.15 24,110.00 99.6 42-000-66-00-6055 LOAN PAYMENT-SSES IEPA L171153 0.00 0.00 107,051.00 0.0 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 0.00 14,273.00 0.0 42-000-66-00-6071 $650K ROAD IMPROV PROG PRINC 0.00 0.00 50,000.00 0.0 TOTAL DEBT SERVICE 107,852.89 336,707.89 1, 180, 688.00 28.5 TOTAL FUND REVENUES 276, 607.00 296,935.92 1, 180, 688.00 25.1 TOTAL FUND EXPENSES 107,852.89 336,707.89 1,180, 688.00 28.5 FUND SURPLUS (DEFICIT) 168,754.11 (39,771.97) 0.00 100.0 P31 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 32 TIME: 11:15:33 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY 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 (774.99) 3,005.01 10,000.00 30.0 51-000-42-00-4241 WATER SALES (15,293.91) 201,434.19 900,000.00 22.3 51-000-42-00-4242 WATER METER SALES 15, 525.00 55,800.00 130,000.00 42.9 51-000-42-00-4243 LEASE REVENUE - H2O TOWER 1,854.00 5,562.00 21,600.00 25.7 TOTAL CHARGES FOR SERVICES 1,310.10 265,801.20 1,061, 600.00 25.0 MISCELLANEOUS 51-000-44-00-4490 MISCELLANEOUS INCOME 0.00 0.00 2,000.00 0.0 TOTAL MISCELLANEOUS 0.00 0.00 2,000.00 0.0 INTEREST 51-000-46-00-4600 INVESTMENT INCOME 1,805.45 5,773.34 12,000.00 48.1 TOTAL INTEREST 1,805.45 5,773.34 12,000.00 48.1 TOTAL REVENUES: 3, 115.55 271,574.54 2,575,600.00 10.5 EXPENSES PERSONNEL 51-000-50-00-5107 SALARIES - EMPLOYEE 20,141.23 58,312.76 264,873.00 22.0 51-000-50-00-5136 SALARIES-PART TIME 0.00 0.00 8,200.00 0.0 51-000-50-00-5137 SALARIES - OVERTIME 3, 410.71 8, 683.05 27,000.00 32.1 TOTAL PERSONNEL 23,551.94 66, 995.81 300,073.00 22.3 PROFESSIONAL SERVICES 51-000-61-00-5300 LEGAL SERVICES 0.00 0.00 2,000.00 0.0 P32 )ATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 33 CIME: 11:15:34 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 CD: GL470002.WOW FUND: WATER OPERATIONS FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES PROFESSIONAL SERVICES 51-000-61-00-5303 JULIE SERVICE 864.20 864.20 6,800.00 12.7 TOTAL PROFESSIONAL SERVICES 864 .20 864.20 8,800.00 9.8 CONTRACTURAL SERVICES 51-000-62-00-5401 CONTRACUAL SERVICES 0.00 1,276.00 4,500.00 28.3 51-000-62-00-5407 TREATMENT FACILITIES O&M 2,708.67 3,054.74 150,000.00 2.0 51-000-62-00-5408 MAINTENANCE-EQUIPMENT 75.70 86.87 9,000.00 0.9 51-000-62-00-5409 MAINTENANCE - VEHICLES 0.00 16.35 7,000.00 0.2 51-000-62-00-5411 MAINTENANCE-COMPUTERS 0.00 0.00 1,000.00 0.0 51-000-62-00-5413 MAINTENANCE-CONTROL SYSTEM 0.00 0.00 10,000.00 0.0 51-000-62-00-5414 TRUCK LETTERING 0.00 0.00 0.00 0.0 51-000-62-00-5421 WEARING APPAREL 159.49 639.96 5,500.00 11.6 51-000-62-00-5422 WATER TOWER PAINTING 88,074.00 88,074.00 220,000.00 40.0 51-000-62-00-5434 RENTAL - EQUIPMENT 0.00 0.00 1,000.00 0.0 51-000-62-00-5435 ELECTRICITY 9, 673.50 17,546.06 170,000.00 10.3 51-000-62-00-5436 TELEPHONE 1,236.97 2,548.47 22, 600.00 11.2 51-000-62-00-5438 CELLULAR TELEPHONE 251.48 515.76 5,700.00 9.0 TOTAL CONTRACTURAL SERVICES 102, 179.81 113,758.21 606, 300.00 18.7 PROFESSIONAL DEVELOPMENT 51-000-64-00-5600 DUES 0.00 0.00 1,000.00 0.0 51-000-64-00-5603 SUBSCRIPTIONS 0.00 0.00 250.00 0.0 51-000-64-00-5604 TRAINING & CONFERENCES 181.34 181.34 3,000.00 6.0 51-000-64-00-5605 TRAVEL EXPENSES 0.00 0.00 3,000.00 0.0 TOTAL PROFESSIONAL DEVELOPMENT 181.34 181.34 7,250.00 2.5 OPERATIONS 51-000-65-00-5800 CONTINGENCIES 0.00 0.00 30,000.00 0.0 51-000-65-00-5804 OPERATING SUPPLIES 6,068.71 7,435.88 46,200.00 16.0 51-000-65-00-5808 POSTAGE & SHIPPING 1, 658.79 2,862.05 13,500.00 21.2 51-000-65-00-5809 PRINTING & COPYING 140.00 280.00 5, 500.00 5.0 51-000-65-00-5810 PUBLISHING & ADVERTISING 0.00 0.00 1,000.00 0.0 P33 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 34 DIME: 11:15:34 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES OPERATIONS 51-000-65-00-5812 GASOLINE 2,550.89 3, 626.88 9,570.00 37.8 51-000-65-00-5815 HAND TOOLS 0.00 19.94 1,000.00 1.9 51-000-65-00-5817 GRAVEL 0.00 0.00 5,000.00 0.0 51-000-65-00-5819 CHLORINE 0.00 0.00 0.00 0.0 51-000-65-00-5820 CHEMICALS 37.22 1,481.73 30,000.00 4.9 51-000-65-00-5821 CATHODIC PROTECTION 0.00 0.00 6,250.00 0.0 51-000-65-00-5822 WATER SAMPLES 30.00 475.00 12,000.00 3.9 TOTAL OPERATIONS 10,485.61 16,181.48 160,020.00 10.1 RETIREMENT 51-000-72-00-6500 IMRF PARTICIPANTS 1,837.51 5,373.87 24,354.00 22.0 51-000-72-00-6501 SOCIAL SECURITY & MEDICARE 1,796.56 5,202.51 23,515.00 22.1 TOTAL RETIREMENT 3, 634.07 10,576.38 47,869.00 22.0 CAPITAL OUTLAY 51-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 30.07 237.06 4,000.00 5.9 51-000-75-00-7004 SAFETY EQUIPMENT 142.59 142.59 2,000.00 7.1 51-000-75-00-7506 METER READERS 0.00 1,213.50 10,900.00 11.1 51-000-75-00-7507 HYDRANT REPLACEMENT 0.00 0.00 10,000.00 0.0 51-000-75-00-7508 METERS & PARTS 20,373.24 39,239.78 262,500.00 14.9 TOTAL CAPITAL OUTLAY 20,545.90 40,832.93 289,400.00 14.1 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 50,000.00 200,000.00 25.0 P34 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 35 TIME: 11:15:34 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL o ACCOUNT JULY 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 12, 500.00 50,000.00 25.0 TOTAL TRANSFERS 62, 500.00 62,500.00 250,000.00 25.0 TOTAL EXPENSES: 223,942.87 311,890.35 2,575, 600.00 12.1 TOTAL FUND REVENUES 3,115.55 271,574.54 2,575, 600.00 10.5 TOTAL FUND EXPENSES 223, 942.87 311,890.35 2,575, 600.00 12.1 FUND SURPLUS (DEFICIT) (220,827.32) (40, 315.81) 0.00 100.0 P35 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 36 DIME: 11:15:34 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 LD: GL470002.WOW FUND: SEWER MAINTENANCE FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED 2E VENUES 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 225.15 74,444.64 355,000.00 20.9 52-000-42-00-4251 SEWER CONNNECTION FEES 8,800.00 32,000.00 140,000.00 22.8 TOTAL CHARGES FOR SERVICES 9,025.15 106,444.64 503,000.00 21.1 INTEREST 52-000-46-00-4600 INVESTMENT INCOME 1,810.44 5,798.33 15,000.00 38.6 TOTAL INTEREST 1,810.44 5,798.33 15,000.00 38.6 TOTAL REVENUES: 10,835.59 112,242.97 968,000.00 11.5 EXPENSES PERSONNEL SERVICES 52-000-50-00-5108 SALARIES-REGULAR 9,584.65 25,917.83 137,555.00 18.8 52-000-50-00-5136 PART TIME 1,460.00 3,780.00 5,000.00 75.6 52-000-50-00-5137 SALARIES-OVERTIME 610.94 2,030.41 12,000.00 16.9 TOTAL PERSONNEL SERVICES 11, 655.59 31,728.24 154,555.00 20.5 CONTRACTUAL SERVICES 52-000-62-00-5401 CONTRACTUAL SERVICES 2,818.00 2,868.00 2,000.00 143.4 52-000-62-00-5408 MAINTENANCE-EQUIPMENT 94.50 1,205.25 5,000.00 24.1 52-000-62-00-5409 MAINTENANCE-VEHICLES 0.00 0.00 3,000.00 0.0 52-000-62-00-5419 MAINTENANCE-SANITARY SEWER 98.46 2,923.62 25,000.00 11.6 . 52-000-62-00-5421 WEARING APPAREL 159.49 159.49 4,500.00 3.5 52-000-62-00-5422 LIFT STATION MAINTENANCE 252.55 1,316.63 25,000.00 5.2 52-000-62-00-5434 RENTAL - EQUIPMENT 0.00 0.00 1,000.00 0.0 P36 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 37 TIME: 11:15:34 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: SEWER MAINTENANCE FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES CONTRACTUAL SERVICES 52-000-62-00-5435 ELECTRICITY 1, 674 .95 1, 674.95 16, 500.00 10.1 52-000-62-00-5438 CELLULAR TELEPHONE 128.91 384.97 2,500.00 15.3 TOTAL CONTRACTUAL SERVICES 5,226.86 10,532.91 84, 500.00 12.4 PROFESSIONAL DEVELOPMENT 52-000-64-00-5604 TRAINING & CONFERENCES 181.32 181.32 1,500.00 12.0 52-000-64-00-5605 TRAVEL/MEALS/LODGING 0.00 0.00 1, 500.00 0.0 TOTAL PROFESSIONAL DEVELOPMENT 181.32 181.32 3,000.00 6.0 OPERATIONS 52-000-65-00-5800 CONTINGENCIES 0.00 0.00 9, 300.00 0.0 52-000-65-00-5802 OFFICE SUPPLIES 152.75 267.69 2,000.00 13.3 52-000-65-00-5804 OPERATING SUPPLIES 0.00 0.00 0.00 0.0 52-000-65-00-5805 SHOP SUPPLIES 29.99 244.74 2, 500.00 9.7 52-000-65-00-5812 GASOLINE 0.00 1,076.00 10,500.00 10.2 52-000-65-00-5815 HAND TOOLS 0.00 12.03 1,000.00 1.2 52-000-65-00-5817 GRAVEL 0.00 0.00 2,000.00 0.0 52-000-65-00-5823 SEWER CHEMICALS 457.11 909.74 5,000.00 18.1 TOTAL OPERATIONS 639.85 2, 510.20 32,300.00 7.7 RETIREMENT 52-000-72-00-6500 IMRF PARTICIPANTS 747.98 2, 188.76 12, 475.00 17.5 52-000-72-00-6501 SOCIAL SECURITY & MEDICARE 890.17 2, 422.80 12, 106.00 20.0 TOTAL RETIREMENT 1, 638.15 4, 611.56 24,581.00 18.7 CAPITAL OUTLAY 52-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 50.98 2,500.00 2.0 52-000-75-00-7003 OFFICE EQUIPMENT 0.00 (11.22) 6,000.00 (0.1) 52-000-75-00-7004 SAFETY EQUIPMENT 50.00 50.00 2,000.00 2.5 TOTAL CAPITAL OUTLAY 50.00 89.76 10, 500.00 0.6 P37 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 38 PINE: 11:15:34 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: SEWER MAINTENANCE FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY 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 17,500.00 70,000.00 25.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 7, 500.00 30,000.00 25.0 52-000-99-00-9965 TRANSFER TO DEBT SERVICE FUND 0.00 0.00 0.00 0.0 TOTAL TRANSFERS 25,000.00 25,000.00 100,000.00 25.0 TOTAL EXPENSES: 44,391.77 84,453.99 968,000.00 8.7 TOTAL FUND REVENUES 10,835.59 112,242.97 968,000.00 11.5 TOTAL FUND EXPENSES 44,391.77 84, 453.99 968,000.00 8.7 FUND SURPLUS (DEFICIT) (33,556.18) 27,788.98 0.00 100.0 P38 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 39 DIME: 11:15:34 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ED: GL470002.W0W FUND: LAND CASH FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL o ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EVENUES 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 1,071.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 5, 670.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 1, 538.00 2,307.00 30,468.00 7.5 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 1,083.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 1, 342.00 3,355.00 26,840.00 12.5 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 1, 406.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 F0XFIELD(2ND EDITION)-LAND CAS 0.00 0.00 0.00 0.0 72-000-47-00-4719 WILDWOOD-LAND CASH 0.00 0.00 0.00 0.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 3,324.00 41,550.00 8.0 72-000-47-00-4723 HEARTLAND CIRCLE-LAND CASH 2,000.00 15,000.00 75,000.00 20.0 72-000-47-00-4724 RAINTREE VILLAGE-LAND CASH 0.00 0.00 29, 000.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 5, 166.53 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 P39 )ATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 40 LIME: 11:15:34 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ED: GL470002.W0W FUND: LAND CASH FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY 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 0.00 0.00 0.0 72-000-47-00-4734 WHISPERING MEADOWS (K. HILL) 2,819.45 10,713.91 17,735.00 60.4 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 0.00 314,065.00 0.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 16, 425.98 125,224.44 1,382,933.00 9.0 TOTAL REVENUES: 16,425.98 125,224.44 2,032, 933.00 6.1 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 RIVERFGRONT EQUIP IMPROVEMENT 0.00 0.00 0.00 0.0 72-000-75-00-7300 GREENBRIAR 3,000.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 0.00 145,000.00 0.0 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 3,145.00 3, 145.00 0.00 (100.0) P40 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 41 DIME: 11:15:34 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LAND CASH FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED F.XPENSES CAPITAL OUTLAY 72-000-75-00-7308 RIVERS EDGE PARK #2 0.00 3,059.22 50,000.00 6.1 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 13, 674.25 13, 674.25 229,000.00 5.9 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 0.00 465,500.00 0.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 0.00 0.00 0.0 72-000-75-00-7330 WHISPERING MEADOWS (K. HILL) 17,282.44 17,282.44 5,000.00 345.6 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 37, 101.69 40,160.91 1,565,500.00 2.5 OTHER 72-000-78-00-9009 RESERVE 0.00 0.00 419,433.00 0.0 72-000-78-00-9010 BEECHER CONCESSION STAND 0.00 0.00 0.00 0.0 TOTAL OTHER 0.00 0.00 419, 433.00 0.0 TRANSFERS P41 )ATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 42 'IME: 11:15:34 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 :D: GL470002.WOW FUND: LAND CASH FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ]XPENSES 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: 37, 101.69 40,160.91 2,032,933.00 1.9 COTAL FUND REVENUES 16, 425.98 125,224.44 2,032,933.00 6.1 COTAL FUND EXPENSES 37, 101.69 40,160.91 2,032,933.00 1.9 ?UND SURPLUS (DEFICIT) (20, 675.71) 85,063.53 0.00 100.0 P42 )ATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 43 LIME: 11:15:34 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LAND ACQUISITION FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY 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 P43 PATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 44 'IME: 11:15:34 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 D: GL470002.WOW FUND: PARKS & RECREATION FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ;E VENUES 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 9,716.45 81, 928.05 176,825.00 46.3 79-000-42-00-4280 CONCESSIONS 2,123.75 12,000.22 10,500.00 114.2 79-000-42-00-4281 BEECHER BLDG/SHELTER DEPOSITS 50.00 250.00 4,500.00 5.5 79-000-42-00-4282 FARMERS MARKET 0.00 0.00 0.00 0.0 79-000-42-00-4285 VENDING MACHINE INCOME 118.83 201.34 650.00 30.9 79-000-42-00-4286 RENTAL INCOME 45.00 525.00 4,000.00 13.1 79-000-42-00-4287 RENTAL INCOME - SHELTERS 0.00 205.00 1,000.00 20.5 79-000-42-00-4288 GOLF OUTING REVENUE 3,200.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 15,254.03 135,269.61 235,475.00 57.4 MISCELLANEOUS 79-000-44-00-4400 DONATIONS 720.00 3, 909.00 15,000.00 26.0 79-000-44-00-4404 TREE DONATIONS 300.00 600.00 500.00 120.0 79-000-44-00-4490 MISCELLANEOUS INCOME 0.00 0.00 0.00 0.0 TOTAL MISCELLANEOUS 1,020.00 4,509.00 15,500.00 29.0 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 1,000.00 2,000.00 50.0 TOTAL INTERGOVERNMENTAL 1,000.00 , 1,000.00 2,000.00 50.0 INTEREST 79-000-46-00-4600 INVESTMENT INCOME 531.68 1, 535.10 1,500.00 102.3 TOTAL INTEREST 531.68 1,535.10 1,500.00 102.3 P44 )ATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 45 LIME: 11:15:34 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 CD: GL470002.WOW FUND: PARKS & RECREATION FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TRANSFERS 79-000-49-00-4901 TRANSFER FROM GENERAL FUND 232, 141.74 232, 141.74 928,567.00 24.9 TOTAL TRANSFERS 232, 141.74 232, 141.74 928,567.00 24.9 TOTAL REVENUES: 249, 947.45 374, 455.45 1, 183,042.00 31.6 PARKS EXPENSES PERSONNAL SERVICES 79-610-50-00-5107 SALARIES-EMPLOYEES 23, 468.31 78, 572.35 312, 678.00 25.1 79-610-50-00-5136 SALARIES - PART-TIME 7, 540.38 19,216.38 45,000.00 42.7 79-610-50-00-5137 SALARIES - OVERTIME 217.39 876.78 8,000.00 10.9 TOTAL PERSONNAL SERVICES 31,226.08 98, 665.51 365,678.00 26.9 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 5, 824.00 6,146.00 12,000.00 51.2 79-610-62-00-5408 MAINTENANCE-EQUIPMENT 243.09 1, 168.73 6,000.00 19.4 79-610-62-00-5417 MAINTENANCE-PARKS 1,845.45 6,399.19 32,000.00 19.9 79-610-62-00-5421 WEARING APPAREL 0.00 0.00 8,000.00 0.0 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 0.00 1,700.00 0.0 79-610-62-00-5438 CELLULAR TELEPHONE 284.12 582.06 5,750.00 10.1 79-610-62-00-5440 LAND DEVELOPER 0.00 0.00 10,000.00 0.0 79-610-62-00-5445 LEGAL EXPENSES 337.50 750.00 10,000.00 7.5 TOTAL CONTRACTUAL SERVICES 8,534.16 15,045.98 85,450.00 17.6 PROFESSIONAL DEVELOPMENT P45 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 46 PIME: 11:15:34 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL $ ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED PARKS EXPENSES PROFESSIONAL DEVELOPMENT 79-610-64-00-5602 PROFESSIONAL GROWTH/SUBSCRPT 690.00 732.23 4,500.00 16.2 79-610-64-00-5605 TRAVEL EXPENSE 0.00 94.83 3,000.00 3.1 79-610-64-00-5612 CONTINUING EDUCATION 1,080.00 1,080.00 4,200.00 25.7 TOTAL PROFESSIONAL DEVELOPMENT 1,770.00 1, 907.06 11,700.00 16.2 OPERATIONS 79-610-65-00-5800 CONTINGENCIES 0.00 0.00 0.00 0.0 79-610-65-00-5802 OFFICE SUPPLIES 0.00 203.34 1,500.00 13.5 79-610-65-00-5804 OPERATING SUPPLIES 1,402.18 3,209.10 25,000.00 12.8 79-610-65-00-5812 GASOLINE 55.75 73.75 3,500.00 2.1 79-610-65-00-5815 HAND TOOLS 69.22 108.16 3,000.00 3.6 79-610-65-00-5824 CHRISTMAS DECORATIONS 0.00 0.00 7,000.00 0.0 79-610-65-00-5825 PUBLIC DECORATION 0.00 51.96 3,000.00 1.7 TOTAL OPERATIONS 1,527.15 3, 646.31 43,000.00 8.4 RETIREMENT 79-610-72-00-6500 IMRF PARTICIPANTS 1, 915.77 5,808.21 26,702.00 21.7 79-610-72-00-6501 SOCIAL SECURITY/MEDICARE 2,369.96 7,491.42 28,537.00 26.2 TOTAL RETIREMENT 4,285.73 13,299.63 55,239.00 24.0 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 246.56 1,242.66 6,500.00 19.1 79-610-75-00-7705 TRANSFER TO LAND ACQUISITION 0.00 0.00 0.00 0.0 TOTAL CAPITAL OUTLAY 246.56 1,267.65 33,500.00 3.7 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 P46 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 47 LIME: 11:15:34 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL EXPENSES: PARKS 47,589.68 133,832.14 601, 926.00 22.2 RECREATION EXPENSES PERSONNEL SERVICES 79-650-50-00-5107 EMPLOYEE SALARIES 19,877.07 60,009.74 260, 696.00 23.0 79-650-50-00-5108 CONCESSION STAFF 877.25 2,388.00 3, 600.00 66.3 79-650-50-00-5150 SALARIES-INSTRUCTOR CONTRACTUA 5, 654.50 20,326.25 88,000.00 23.0 79-650-50-00-5155 SALARIES-RECORDING SECRETARY 67.50 386.50 5,000.00 7.7 79-650-50-00-5156 SALARIES-CUSTODIAL 0.00 0.00 0.00 0.0 TOTAL PERSONNEL SERVICES 26, 476.32 83, 110.49 357,296.00 23.2 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 595.17 858.79 8,000.00 10.7 79-650-62-00-5409 MAINTENANCE-VEHICLES 14.95 14.95 1,200.00 1.2 79-650-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 1,251.00 1, 612.53 5,500.00 29.3 79-650-62-00-5426 YOUTH SERVICES GRANT EXPENSES 0.00 455.11 2,000.00 22.7 79-650-62-00-5437 TELEPHONE/INTERNET 18.44 59.11 1,400.00 4.2 79-650-62-00-5438 CELLULAR TELEPHONE 292.05 864.00 4,500.00 19.2 79-650-62-00-5445 PORTABLE TOILETS (5.62) 652.22 4,500.00 14.4 79-650-62-00-5603 PUBLISHING/ADVERTISING 0.00 4,400.19 25,200.00 17.4 79-650-62-00-5605 BOOKS/PUBLICATIONS 0.00 84.50 750.00 11.2 79-650-62-00-5606 BEECHER DEPOSIT REFUND 175.00 1,900.00 4,000.00 47.5 TOTAL CONTRACTUAL SERVICES 2, 340.99 10,901.40 57,050.00 19.1 PROFESSIONAL DEVELOPMENT 79-650-64-00-5600 DUES 0.00 0.00 2,700.00 0.0 79-650-64-00-5602 PROFESSIONAL GROWTH/SUBSCRIPT 345.00 400.00 7,500.00 5.3 79-650-64-00-5605 TRAVEL EXPENSE 0.00 0.00 2,500.00 0.0 P47 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 48 DIME: 11:15:34 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 LD: GL470002.WOW FUND: PARKS & RECREATION FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL o ACCOUNT JULY 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 345.00 400.00 12,700.00 3.1 OPERATIONS 79-650-65-00-5600 CONTINGENCIES 0.00 0.00 0.00 0.0 79-650-65-00-5802 OFFICE SUPPLIES 83.15 1,368.74 6, 600.00 20.7 79-650-65-00-5803 PROGRAM EXPENSES 4,018.90 10,225.20 39,185.00 26.0 79-650-65-00-5804 OPERATING SUPPLIES 549.41 1, 132.12 4,000.00 28.3 79-650-65-00-5805 RECREATION EQUIPMENT 0.00 0.00 3,500.00 0.0 79-650-65-00-5808 POSTAGE & SHIPPING 829.89 1,701.35 6,500.00 26.1 79-650-65-00-5812 GASOLINE 0.00 52.41 1, 600.00 3.2 79-650-65-00-5826 MILEAGE 123.12 184.88 750.00 24.6 79-650-65-00-5827 GOLF OUTING EXPENSES 0.00 21,944.65 20,000.00 109.7 79-650-65-00-5828 CONCESSIONS 1,977.89 9, 143.79 5,000.00 182.8 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 0.00 1,500.00 0.0 79-650-65-00-5841 PROGRAM REFUND 1,143.00 3,907.60 6,500.00 60.1 TOTAL OPERATIONS 8,725.36 49,660.74 95,135.00 52.2 RETIREMENT 79-650-72-00-6500 IMRF PARTICIPANTS 1,593.58 5, 171.79 21,754.00 23.7 79-650-72-00-6501 SOCIAL SECURITY/MEDICARE 1,841.51 5,906.49 24,132.00 24.4 TOTAL RETIREMENT 3,435.09 11,078.28 45,886.00 24.1 CAPITAL OUTLAY 79-650-75-00-7002 COMPUTER EQUIP & SOFTWARE 2,844.01 6,718.63 6,500.00 103.3 TOTAL CAPITAL OUTLAY 2,844.01 6,718.63 6,500.00 103.3 OTHER 79-650-78-00-9005 MERIT 0.00 0.00 6,549.00 0.0 P48 )ATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 49 CIME: 11:15:34 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 CD: GL470002.WOW FUND: PARKS & RECREATION FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY 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, 166.77 161,869.54 581,116.00 27.8 DOTAL FUND REVENUES 249, 947.45 374,455.45 1,183,042.00 31.6 COTAL FUND EXPENSES 91,756.45 295,701.68 1, 183,042.00 24.9 FUND SURPLUS (DEFICIT) 158, 191.00 78,753.77 0.00 100.0 P49 )ATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 50 LIME: 11:15:34 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 [D: GL470002.WOW FUND: WORKING CASH FUND FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED .EVENUES 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 DOTAL FUND REVENUES 0.00 0.00 0.00 0.0 DOTAL FUND EXPENSES 0.00 0.00 0.00 0.0 FUND SURPLUS (DEFICIT) 0.00 0.00 0.00 0.0 P50 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 51 DIME: 11:15:34 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LIBRARY FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY 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 53, 944.27 54,485.72 370,500.00 14 .7 82-000-40-00-4010 PERSONAL PROPERTY TAX 0.00 335.33 2, 500.00 13.4 82-000-40-00-4015 TRANSFER FROM GENERAL FUND 5,250.00 5,250.00 31, 500.00 16.6 TOTAL TAXES 59, 194.27 60,071.05 575,209.00 10.4 CHARGES FOR SERVICES 82-000-42-00-4211 DEVELOPMENT FEES - BUILDING 1, 525.00 4,350.00 121,875.00 3.5 82-000-42-00-4215 DEVELOPMENT FEES-BOOKS 1, 525.00 4,350.00 121,875.00 3.5 82-000-42-00-4260 COPY FEES 128.85 280.65 900.00 31.1 82-000-42-00-4261 LIBRARY SUBSCRIPTION CARDS 700.00 2, 950.00 8,000.00 36.8 82-000-42-00-4286 RENTAL INCOME 132.00 273.00 1,000.00 27.3 TOTAL CHARGES FOR SERVICES 4,010.85 12,203.65 253, 650.00 4.8 FINES 82-000-43-00-4330 LIBRARY FINES 363.61 940.98 3,000.00 31.3 TOTAL FINES 363.61 940.98 3,000.00 31.3 MISCELLANEOUS 82-000-44-00-4432 SALE OF BOOKS 13.50 154.65 500.00 30.9 82-000-44-00-4450 MEMORIALS 35.00 502.00 1,000.00 50.2 TOTAL MISCELLANEOUS 48.50 656.65 1,500.00 43.7 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 P51 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 52 TIME: 11:15:35 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LIBRARY FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED INTEREST 82-000-46-00-4600 INVESTMENT INCOME 695.25 2, 147.61 1,500.00 143.1 82-000-46-00-4601 INVESTMENT INCOME-BLDG 167.38 359.60 1,250.00 28.7 TOTAL INTEREST 862.63 2,507.21 2,750.00 91.1 OTHER OPERATING RECEIPTS 82-000-48-00-4801 LIBRARY EXPAN BOND PROCEEDS 145,000.00 145,000.00 0.00 100.0 TOTAL OTHER OPERATING RECEIPTS 145,000.00 145,000.00 0.00 100.0 TOTAL REVENUES: 209, 479.86 221,379.54 844,809.00 26.2 EXPENSES PERSONNEL SERVICES 82-000-50-00-5107 SALARIES-EMPLOYEES 12,277.05 36,309.34 300,000.00 12.1 82-000-50-00-5203 GROUP HEALTH INSURANCE 3,331.13 6, 662.26 45,000.00 14.8 82-000-50-00-5204 GROUP LIFE INSURANCE 56.67 113.34 1,500.00 7.5 82-000-50-00-5205 DENTAL & VISION ASSISTANCE 0.00 0.00 4,000.00 0.0 TOTAL PERSONNEL SERVICES 15, 664.85 43,084.94 350,500.00 12.2 PROFESSIONAL SERVICES 82-000-61-00-5300 LEGAL SERVICES 0.00 0.00 0.00 0.0 82-000-61-00-5322 BONDING 381.00 762.00 2,000.00 38.1 82-000-61-00-5323 ATTORNEY 0.00 112.50 2,000.00 5.6 TOTAL PROFESSIONAL SERVICES 381.00 874.50 4,000.00 21.8 CONTRACTUAL SERVICES 82-000-62-00-5401 CONTRACT SERVICES 59.75 122.25 3,000.00 4.0 82-000-62-00-5407 MAINTENANCE-BLDG/JANITORIAL 300.00 600.00 5,000.00 12.0 82-000-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 902.90 1,588.84 3,000.00 52.9 82-000-62-00-5412 MAINTENANCE-PHOTOCOPIER 0.00 74.56 500.00 14.9 82-000-62-00-5435 ELECTRICITY 103.29 197.53 2,500.00 7.9 82-000-62-00-5436 TELEPHONE 52.26 167.93 1,700.00 9.8 P52 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 53 TIME: 11:15:35 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LIBRARY FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL o ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL CONTRACTUAL SERVICES 1, 418.20 2,751.11 15,700.00 17.5 PROFESSIONAL DEVELOPMENT 82-000-64-00-5603 SUBSCRIPTIONS 243.00 243.00 4,000.00 6.0 82-000-64-00-5604 TRAINING & CONFERENCES 0.00 0.00 1,500.00 0.0 82-000-64-00-5607 PUBLIC RELATIONS 0.00 0.00 1,000.00 0.0 82-000-64-00-5616 EMPLOYEE RECOGNITION 0.00 0.00 2,000.00 0.0 TOTAL PROFESSIONAL DEVELOPMENT 243.00 243.00 8,500.00 2.8 OPERATIONS 82-000-65-00-5800 CONTINGENCIES 0.00 0.00 14, 616.00 0.0 82-000-65-00-5802 OFFICE SUPPLIES 0.00 0.00 3,000.00 0.0 82-000-65-00-5806 LIBRARY SUPPLIES 851.04 1,013.98 8,000.00 12.6 82-000-65-00-5807 CUSTODIAL SUPPLIES 83.38 412.48 6,000.00 6.8 82-000-65-00-5808 POSTAGE & SHIPPING 0.00 74.00 1,000.00 7.4 82-000-65-00-5810 PUBLISHING & ADVERTISING 0.00 58.40 1,000.00 5.8 82-000-65-00-5826 MILEAGE 0.00 60.75 1,000.00 6.0 82-000-65-00-5832 VIDEOS 59.56 81.90 5,000.00 1.6 82-000-65-00-5833 ALARM MONITORING 258.40 447.50 1,000.00 44.7 82-000-65-00-5834 LIBRARY PROGRAMMING 375.27 701.69 9,500.00 7.3 82-000-65-00-5835 LIBRARY BOARD EXPENSES 0.00 32.00 500.00 6.4 82-000-65-00-5836 BOOKS-ADULT 1,528.97 1, 528.97 9,000.00 16.9 82-000-65-00-5837 BOOKS-JUVENILE 0.00 0.00 9,000.00 0.0 82-000-65-00-5838 BOOKS-AUDIO 127.88 255.76 9,000.00 2.8 82-000-65-00-5839 BOOKS-REFERENCE 0.00 178.58 9,000.00 1.9 82-000-65-00-5840 BOOKS-DEVELOPMENT FEE 2, 373.26 6,016.62 179, 611.00 3.3 82-000-65-00-5841 MEMORIALS/GIFTS 384.93 839.90 6,362.00 13.2 82-000-65-00-5842 BLDG-DEVELOPMENT FEES 10,340.83 40,883.26 153,570.00 26.6 TOTAL OPERATIONS 16, 383.52 52, 585.79 426,159.00 12.3 RETIREMENT 82-000-72-00-6500 IMRF PARTICPANTS 594.60 1,741.20 9,000.00 19.3 82-000-72-00-6501 SOCIAL SECURITY/MEDICARE 939.24 2,777.82 22,950.00 12.1 TOTAL RETIREMENT 1, 533.84 4, 519.02 31,950.00 14.1 P53 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 54 TIME: 11:15:35 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: LIBRARY FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY 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 708.55 1,249.27 8,000.00 15.6 82-000-75-00-7703 BUILDING EXPANSION 0.00 0.00 0.00 0.0 TOTAL CAPITAL OUTLAY 708.55 1,249.27 8,000.00 15.6 TOTAL EXPENSES: 36,332.96 105,307.63 844,809.00 12.4 TOTAL FUND REVENUES 209,479.86 221,379.54 844,809.00 26.2 TOTAL FUND EXPENSES 36,332.96 105,307.63 844,809.00 12.4 FUND SURPLUS (DEFICIT) 173, 146.90 116,071.91 0.00 100.0 P54 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 55 TIME: 11:15:35 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: FOX INDUSTRIAL FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY 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 13, 669.71 36,266.61 34,000.00 106.6 TOTAL TAXES 13, 669.71 36,266.61 34,000.00 106.6 INTEREST 85-000-46-00-4600 INVESTMENT INCOME 183.95 521.69 1,000.00 52.1 TOTAL INTEREST 183.95 521.69 1,000.00 52.1 TRANSFERS 85-000-49-00-4905 TRANSFER FROM MFT FUND 0.00 0.00 42,664.00 0.0 TOTAL TRANSFERS 0.00 0.00 42,664.00 0.0 TOTAL REVENUES: 13,853.66 36,788.30 77, 664.00 47.3 EXPENSES DEBT SERVICES 85-000-66-00-6021 FOX IND BOND-PRINCIPAL PMT 0.00 0.00 55,000.00 0.0 85-000-66-00-6022 FOX IND BOND-INT PAYMENT 0.00 0.00 22,450.00 0.0 TOTAL DEBT SERVICES 0.00 0.00 77,450.00 0.0 CAPITAL OUTLAY 85-000-75-00-7901 FOX INDUSTRIAL - NON MFT 0.00 0.00 0.00 0.0 85-000-75-00-7902 FOX INDUSTRIAL EXPENSES 0.00 0.00 0.00 0.0 TOTAL CAPITAL OUTLAY 0.00 0.00 0.00 0.0 OTHER 85-000-78-00-9007 ADMINSITRATION FEES 0.00 214.00 214.00 100.0 85-000-78-00-9010 RESERVE-FUTURE BOND PYMTS 0.00 0.00 0.00 0.0 TOTAL OTHER 0.00 214.00 214.00 100.0 P55 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 56 TIME: 11:15:35 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: FOX INDUSTRIAL FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL % ACCOUNT JULY YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL EXPENSES: 0.00 214.00 77, 664.00 0.2 TOTAL FUND REVENUES 13,853.66 36,788.30 77, 664.00 47.3 TOTAL FUND EXPENSES 0.00 214.00 77, 664.00 0.2 FUND SURPLUS (DEFICIT) 13,853.66 36,574.30 0.00 100.0 P56 DATE: 08/29/2005 UNITED CITY OF YORKVILLE PAGE: 57 TIME: 11:15:35 DETAILED REVENUE & EXPENSE REPORT F-YR: 06 ID: GL470002.WOW FUND: COUNTRYSIDE TIF PROJECT FOR 3 PERIODS ENDING JULY 31, 2005 FISCAL FISCAL ACCOUNT JULY 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 TOTAL FUND REVENUES 0.00 3, 456,521.17 0.00 100.0 TOTAL FUND EXPENSES 0.00 0.00 0.00 0.0 FUND SURPLUS (DEFICIT) 0.00 3,456,521.17 0.00 100.0 P57 United City of Yorkville Monthly Treasurer's Report Pre Audit Financial Summary As of July 31, 2005 Beginning Ending Fund Balance Revenues Expenses Transfers Balance 1 General 2,000,411.04 5,408,340.71 1,383,901.11 (173,522.49) 5,851,328.15 15 Motor Fuel Tax 149,503.10 21,482.39 16,179.34 - 154,806.15 16 Municipal Building (246,230.78) 2,700.00 46,434.74 (13,600.00) (303,565.52) 20 PD Capital 82,008.48 7,875.00 36,974.64 (6,027.50) 46,881.34 21 PW Capital 223,259.50 18,000.00 - 20,000.00 261,259.50 22 Parks&Rec Equip Capital 71,365.38 1,750.00 5,250.00 - 67,865.38 37 Sanitary Sewer Improvement 2,962,882.31 229,251.13 1,071,421.54 (174,053.25) 1,946,658.65 41 Water Improvement Exp (265,706.17) 64,267.00 63,340.35 (70,360.50) (335,140.02) 42 Debt Service (194,607.78) 8,935.00 107,852.89 267,672.00 (25,853.67) 51 Water 611,827.64 132,562.92 168,112.33 (62,500.00) 513,778.23 52 Sewer 376,286.26 48,496.83 19,436.24 (25,000.00) 380,346.85 72 Land Cash 548,175.55 16,425.98 37,101.69 - 527,499.84 73 Land Acquisition 213,617.69 - - - 213,617.69 79 Parks&Recreation 56,532.40 17,787.02 91,737.76 232,141.74 214,723.40 82 Library 298,491.79 233,145.04 59,056.69 5,250.00 477,830.14 85 Fox Industrial (10,475.29) 13,853.66 - - 3,378.37 87 Countryside TIF Project 3,456,521.17 - - - 3,456,521.17 95 Trust&Agency (65,294.70) 236,807.42 9,729.60 - 161,783.12 Totals 10,268,567.59 6,461,680.10 3,116,528.92 - 13,613,718.77 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 28.65% Water Ops 19.95% Sewer Maint. 39.29% 7-03 Combined Fund Balance Reserve 28.00% Prepared by: Lori Thomas-Accounting Clerk[I 1 ,t0 Cir o United City of Yorkville Memo 800 Game Farm Road EST. 1a36 Yorkville, Illinois 60560 Telephone: 630-553-4350 y Fax: 630-553-7575 KandmilCasty ‘741.E ‘‘)/ Date: August 30, 2005 To: Administration Committee From: Tony Graff, City Administrator; Bart Olson, Administrative Intern CC: Subject: Assistant City Administrator job description The Assistant City Administrator job description has been drafted from a variety of different municipalities'job descriptions. This position is not currently in the FY 05/06 budget, but would be something that I would like to investigate for the revised budget in January. Therefore,per the City Council's policy of reviewing job descriptions before the position is created and the person is hired, I am submitting this job description for discussion and review. Of particular note is the salary schedule that is attached. Comparable groups of regional, administrator/manager, and population have been broken out. There are some procedural differences between a strong mayor and council-manager form of government(administrator or manager, respectively), and therefore felt it necessary to study the salary differences between the different job titles. Also, as is customary with all job descriptions, different population groups have been studied. There appears to be a difference in salary level between the groups when an arbitrary cutoff of 25,000 people(above and below)is used. However these differences between groups should be taken lightly as a statistical analysis shows that the two variables (population and actual salary)have little to do with each other . * 29 R-squared value:the independent variable(population)explains only 29%of the variance in the observations of the dependent variable(actual salary)—a.k.a.there is 71%of some unobserved variable(s)influencing the salary level. UNITED CITY OF YORKVILLE ASSISTANT CITY ADMINISTRATOR—JOB DESCRIPTION (DRAFT 8-30-2005) Department: Administration Reports to: City Administrator Status: Full-time; exempt Supervises: Administration Department Salary Classification: Assistant City Administrator Position Description Overview Under the direction of the City Administrator, as a professional liaison and member of the City's management team, performs work relating to a wide range of municipal, administrative, or operational functions. In achieving desired end results, the incumbent is given considerable freedom to exercise judgment and discretion. This position is required to: give policy guidance and interpretations to department directors through frequent conferences and contacts with the City Administrator; keep informed and abreast of current and projected developments in the conduct of the City governments; show exercise of sound judgment and knowledge of the techniques of public administration as applied to municipal government in meeting a variety of work problems involving continual public, inter-departmental, and intergovernmental relations; keep frequent contact with residents, businesses and other municipal governments and intergovernmental agencies responding to inquiries regarding City programs and services and will often be required to make public presentations; monitor a variety of City contracts and grants for compliance with regulations; act and/or represent the City in the absence of, and/or direction of, the City Administrator; interact frequently with elected officials and give broad policy guidance and interpretations on agenda items at City Council and committee meetings. Essential Job Functions 1. Oversees staff assigned to the City Administrator's office and coordinates and manages the day-to-day administrative functions of the City; supervises department heads during City Administrator's absence. 2. Represents the City Administrator at meetings he/she is unable to attend; represents the City or City Administrator in various situations involving community groups, intergovernmental bodies, and/or associations. 3. Provides high level staff support to the City Administrator; researches and prepares recommendations on public policy proposals as directed; provides leadership and direction in the development of short and long range plans; gathers, interprets, and prepares data for studies, reports and recommends on subjects including but not limited to risk management, insurance, personnel matters, interpretation of City policies, budget format, and code enforcement; coordinates department activities with other departments and agencies as needed. 4. Attends staff, committee and City Council meetings as required, and makes recommendations of subjects under discussion; staff liaison to various boards and commissions as assigned. 5. Assists in the development, planning, and implementation of goals and objectives related to the overall administrative activities and operations of the City. 6. Assists the City Administrator in the development of management improvements; analyzes operating problems and suggests policy or program adjustments as needed. 7. Performs or assists subordinates in performing duties; adjusts errors and complaints. 8. Participates as a key member of the developmental coordination team to ensure development processes are operating at peak efficiency. 9. Provides professional advice to the City Council and department heads; makes presentations to councils, boards, commissions, civic groups and the general public. 10. Performs management analyses, conducts surveys, and prepares research reports and other policy documents to serve as a basis for action by the City Administrator and the City Council. 11. Oversees the City Council agenda preparation process, the coordination of initiatives related to the organization's provision of customer service, and manages special projects as assigned. 12. Works with the City Administrator and Finance Director in the preparation of the annual budget and tax levy for the City; develops and incorporates the capital improvement plan into the budget. 13. Responds to complex and simple citizen inquiries and concerns as needed and coordinates department actions/responses; performs a variety of tasks including answering the telephone and greeting the public in person. 14. Oversees all functions within the Office of the City Clerk, including maintenance of official records and documents, custody of the City seal, licensing, attendance at and recording of council proceedings, administration of oaths, attestation and certification of documents, publication of ordinances, compliance with the Freedom of Information and Open Meetings Acts, voter registration, in-person absentee voting, and municipal election duties pertaining to nomination petitions, ballots and election results. 15. Reviews pre-annexation agreements and provides comments; attends negotiating sessions as directed. *This function has been placed within the job description for discussion purposes related to the clerk/treasurer agenda item. Should the City Clerk become an appointed position,it may be desirable to realign its functions to be underneath the administration department. 16. Assists in the promotion of the City's economic development interests, conducting site visits with key businesses, representing City interests at business expos, tradeshows and other events, and serves as liaison to the Yorkville Economic Development Corporation. 17. Prepares the Administration Department's personnel requirements forecast report annually for review by the City Administrator. 18. Assists in the planning, review, and construction monitoring of major public building construction projects including contract negotiations and administration. 19. Researches and communicates legislative activity relative to the interests of the City. 20. Other duties as assigned by the City Administrator. Requirements - To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. 1. Considerable knowledge of public administration and its applications to local government laws, principles, and regulations. 2. Considerable knowledge of general management and organization principles and practices. 3. Ability to direct and supervise professional and office support personnel. 4. Ability to communicate effectively verbally and in writing. 5. Ability to establish and maintain satisfactory working relationships and tactfully and diplomatically handle controversial situations with City personnel, elected officials, professional groups and the general public; ability to tactfully 6. Ability to present ideas effectively, orally, and in writing, including preparing and presenting concise reports, sometimes on technical subjects in a clear manner using advanced research and statistical methodology. 7. Ability to define problems, collect data, establish facts, and draw valid conclusions; ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables. 8. Ability to analyze and interpret public policy issues, safety precautions, laws, ordinances, policies, procedures problems their impact on City operations and develop solutions, recommendations, and comprehensive reports. 9. Ability to work with mathematical concepts such as probability and statistical inference; ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations. 10. Working knowledge of a financial plan, annual operating budget, and capital improvement budget. 11. Considerable knowledge of current human resource principles and practices as related to a municipal setting. 12. Ability to operate a variety of office equipment including telephone, computers, and copiers; intermediate skill level in the City's current applications of Windows and Excel, and basic skill level in the City's current application of Word Experience and Education 1. Graduation from a four-year college or university with major course work in public or business administration, political science, or a related field; attainment of a Master's degree in public or business administration or closely related field preferred; 2. Administrative or professional experience in local government as an intern or in a full-time position; 3. Any equivalent combination of experience and education that provides the required knowledge, skills, and abilities associated with this position and its essential job functions may be considered. 4. Must successfully complete a background investigation. 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. Organization Population Title Hire Date Hrs /Yr Range Min Range Mid Range Max Actual Last Updated Batavia, City of 26,901 Assistant City Administrator 2080 $69,252 - $95,488 - 10/20/2004 Bloomingdale, Village of 21,903 Deputy/Assistant Village/City Manager 10/18/1993 2080 $62,546 $73,486 $84,427 $87,381 7/27/2004 Buffalo Grove, Village of 43,152 Assistant Village Manager 2080 $68,143 $84,849 $101,556 - 5/14/2004 Carol Stream, Village of 40,267 Assistant Village Manager 2080 $77,041 - $109,667 - 6/13/2005 Champaign, City of 70,306 Assistant City Manager 2080 - - - $117,599 6/3/2005 Crystal Lake, City of 40,496 Deputy City Manager 2/1/19.99 2080 $82,555 - $108,971 - 7/8/2005 DeKalb, City of 41,532 Administrative Services Director 1950 $61,343 $76,680 $92,016 - 3/4/2004 Downers Grove, Village of 49,302 Deputy City Manager - $83,889 $98,570 $113,250 $111,095 6/1/2004 Elgin, City of 97,761 Deputy City Manager 2080 $82,776 $95,820 $110,928 $1.10,928 3/28/2003 Geneva, City of 22,913 Assistant City Administrator 2080 $58,822 - $85,115 - 6/7/2005 Glendale Heights, Village of 32,729 Assistant Village Administrator 2080 $85,280 $93,600 $99,840 - 6/23/2005 Grayslake, Village of 20,459 Deputy/Assistant Village/City Manager 5/1/2000 2080 $67,833 - $91,575 $82,000 4/22/2005 Gurnee, Village of 30,709 Deputy/Assistant Village/City Manager 2080 $76,444 - $102,443 - 5/13/2005 Hanover Park, Village of 37,391 Assistant Village Manager 1/28/1980 1950 $69,613 $85,668 $101,722 $98,398 6/23/2005 Highland Park, City of 31,221 Assistant City Manager 2080 $84,841 - $113,121 $88,802 6/20/2005 Hinsdale, Village of 17,632 Assistant Village Manager/Dir of Administration 6/18/1990 2080 $81,176 - $120,454 $119,076 10/5/2004 Hoffman Estates, Village of 49,823 Assistant Village Manager 2080 $78,144 $95,974 $113,804 $105,048 8/10/2005 Joliet, City of 129,519 Deputy City Manager 10/5/1987 2080 $93,600 - $130,000 $106,683 1/12/2005 Lake Forest, City of 20,922 Assistant City Manager 2080 $65,264 - $87,571 - 6/17/2005 Lincolnwood, Village of 12,101 Assistant Village Administrator 7/8/1999 2080 $62,004 $75,196 $88,388 $60,844 6/2/2004 Lisle, Village of 22,321 Assistant Village Manager 2080 $76,247 $91,533 $106,746 $96,558 6/2/2005 Morton Grove, Village of 22,383 Assistant Village Administrator 2080 - - - $95,481 2/25/2005 Mount Prospect, Village of 55,028 Assistant Village Manager 1950 - - - $107,900 2/8/2005 Mundelein, Village of 32,651 Assistant Village Administrator 11/28/1988 2080 $75,853 $88,737 $103,810 $103,810 5/10/2005 Naperville, City of 140,106 Assistant City Manager 2080 $90,106 $109,928 $132,345 $134,873 11/18/2004 Northbrook, Village of 34,209 Assistant Village Manager 1950 - - - $113,022 10/7/2004 Oak Park, Village of 50,993 Deputy/Assistant Village/City Manager 1950 $86,146 - $110,742 $97,771 5/28/2004 Orland Park, Village of 54,781 Assistant Village Manager 11/10/2003 2080 - - - $81,151 4/21/2005 Park Ridge, City of 37,185 Assistant City Manager 1950 $85,991 $103,188 $116,599 $114,061 5/4/2005 Roselle, Village of 23,367 Assistant Village Administrator 5/30/2000 2080 $72,888 - $97,678 - 7/27/2005 Schaumburg, Village of 73,346 Assistant Village Manager 1820 $82,739 - $118,970 $118,970 7/12/2004 Skokie, Village of 63,965 Assistant Village Manager 2080 $73,840 - $96,595 $81,390 6/16/2005 Vernon Hills, Village of 23,446 Assistant Village/City Manager 11/10/1999 - - - - $97,286 7/25/2005 Westmont, Village of 24,820 Assistant Village Manager 10/22/1984 - $76,251 $91,502 $106,752 $95,313 9/8/2003 Wheeling, Village of 36,766 Assistant Village Manager 3/10/2003 1950 - - - $80,250 4/22/2005 Wilmette, Village of 27,104 Assistant Village Manager 2080 $83,000 - $122,000 $89,000 1/17/2005 Winfield, Village of 9,655 Deputy/Assistant Village/City Manager - $62,989 - $81,311 - 4/6/2004 Woodridge, Village of 33,943 Assistant Village Administrator 5/5/2003 2080 $74,311 - $101,112 $95,306 8/12/2005 AVERAGE $75,836 $90,338 $104,677 $99,629 Regional Comparables Batavia, City of 26,901 Assistant City Administrator 2080. $69,252 - $95,488 - 10/20/2004 DeKalb, City of 41,532 Administrative Services Director 1950 $61,343 $76,680 $92,016 - 3/4/2004 Geneva, City of 22,913 Assistant City Administrator 2080 $58,822 - $85,115 - 6/7/2005 Joliet, City of 129,519 Deputy City Manager 10/5/1987 2080 $93,600 - $130,000 $106,683 1/12/2005 Naperville, City of 140,106 Assistant City Manager 2080 $90,106 $109,928 $132,345 $134,873 11/18/2004 AVERAGE $74,625 $93,304 $106,993 $120,778 Organization Population Title Hire Date Hrs /Yr Range Min Range Mid Range Max Actual Last Updated Assistant City Administrators (as opposed to Managers) Batavia, City of 26,901 Assistant City Administrator 2080 $69,252 - $95,488 - 10/20/2004 Geneva, City of 22,913 Assistant City Administrator 2080 $58,822 - $85,115 - 6/7/2005 Glendale Heights, Village of 32,729 Assistant Village Administrator 2080 $85,280 $93,600 $99,840 6/23/2005 Lincolnwood, Village of 12,101 Assistant Village Administrator 7/8/1999 2080 $62,004 $75,196 $88,388 $60,844 6/2/2004 Morton Grove, Village of 22,383 Assistant Village Administrator 2080 - - $95,481 2/25/2005 Mundelein, Village of 32,651 Assistant Village Administrator 11/28/1988 2080 $75,853 $88,737 $103,810 $103,810 5/10/2005 Roselle, Village of 23,367 Assistant Village Administrator 5/30/2000 2080 $72,888 - $97,678 7/27/2005 Woodridge, Village of 33,943 Assistant Village Administrator 5/5/2003 2080 $74,311 - $101,112 $95,306 8/12/2005 AVERAGE $71,201 $85,844 $95,919 $88,860 Assistant City Managers (as opposed to Administrators - to be used for comparison purposes and discussion) Bloomingdale, Village of 21,903 Deputy/Assistant Village/City Manager 10/18/1993 2080 $62,546 $73,486 $84,427 $87,381 7/27/2004 Buffalo Grove, Village of 43,152 Assistant Village Manager 2080 $68,143 $84,849 $101,556 - 5/14/2004 Carol Stream, Village of 40,267 Assistant Village Manager 2080 $77,041 - $109,667 - 6/13/2005 Champaign, City of 70,306 Assistant City Manager 2080 - - - $117,599 6/3/2005 Crystal Lake, City of 40,496 Deputy City Manager 2/1/1999 2080 $82,555 - $108,971 - 7/8/2005 DeKalb, City of 41,532 Administrative Services Director 1950 $61,343 $76,680 $92,016 - 3/4/2004 Downers Grove, Village of 49,302 Deputy City Manager - $83,889 $98,570 $113,250 $111,095 6/1/2004 Elgin, City of 97,761 Deputy City Manager 2080 $82,776 $95,820 $110,928 $110,928 3/28/2003 Grayslake, Village of 20,459 Deputy/Assistant Village/City Manager 5/1/2000 2080 $67,833 - $91,575 $82,000 4/22/2005 Gurnee, Village of 30,709 Deputy/Assistant Village/City Manager 2080 $76,444 - $102,443 - 5/13/2005 Hanover Park, Village of 37,391 Assistant Village Manager 1/28/1980 1950 $69,613 $85,668 $101,722 $98,398 6/23/2005 Highland Park, City of 31,221 Assistant City Manager 2080 $84,841 - $113,121 $88,802 6/20/2005 Hinsdale, Village of 17,632 Assistant Village Manager/Dir of Administration 6/18/1990 2080 $81,176 - $120,454 $119,076 10/5/2004 Hoffman Estates, Village of 49,823 Assistant Village Manager 2080 $78,144 $95,974 $113,804 $105,048 8/10/2005 Joliet, City of 129,519 Deputy City Manager 10/5/1987 2080 $93,600 - $130,000 $106,683 1/12/2005 Lake Forest, City of 20,922 Assistant City Manager 2080 $65,264 - $87,571 - 6/17/2005 Lisle, Village of 22,321 Assistant Village Manager 2080 $76,247 $91,533 $106,746 $96,558 6/2/2005 Mount Prospect, Village of 55,028 Assistant Village Manager 1950 - - - $107,900 2/8/2005 Naperville, City of 140,106 Assistant City Manager 2080 $90,106 $109,928 $132,345 $134,873 11/18/2004 Northbrook, Village of 34,209 Assistant Village Manager 1950 - - - $113,022 10/7/2004 Oak Park, Village of 50,993 Deputy/Assistant Village/City Manager 1950 $86,146 - $110,742 $97,771 5/28/2004 Orland Park, Village of 54,781 Assistant Village Manager 11/10/2003 2080 - - - $81,151 4/21/2005 Park Ridge, City of 37,185 Assistant City Manager 1950 $85,991 $103,188 $116,599 $114,061 5/4/2005 Schaumburg, Village of 73,346 Assistant Village Manager 1820 $82,739 - $118,970 $118,970 7/12/2004 Skokie, Village of 63,965 Assistant Village Manager 2080 $73,840 - $96,595 $81,390 6/16/2005 Vernon Hills, Village of 23,446 Assistant Village/City Manager 11/10/1999 - - - - $97,286 7/25/2005 Westmont, Village of 24,820 Assistant Village Manager 10/22/1984 - $76,251 $91,502 $106,752 $95,313 9/8/2003 Wheeling, Village of 36,766 Assistant Village Manager 3/10/2003 1950 - - - $80,250 4/22/2005 Wilmette, Village of 2.7,104 Assistant Village Manager 2080 $83,000 - $122,000 $89,000 1/17/2005 Winfield, Village of 9,655 Deputy/Assistant Village/City Manager - $62,989 - $81,311 - 4/6/2004 AVERAGE $77,188 $91,564 $107,232 $101,502 Population < 25,000 Bloomingdale, Village of 21,903 Deputy/Assistant Village/City Manager 10/18/1993 2080 $62,546 $73,486 $84,427 $87,381 7/27/2004 Geneva, City of 22,913 Assistant City Administrator 2080 $58,822 - $85,115 - 6/7/2005 Grayslake, Village of 20,459 Deputy/Assistant Village/City Manager 5/1/2000 2080 $67,833 - $91,575 $82,000 4/22/2005 Hinsdale, Village of 17,632 Assistant Village Manager/Dir of Administration 6/18/1990 2080 $81,176 - $120,454 $119,076 10/5/2004 Organization Population Title Hire Date Hrs /Yr Range Min Range Mid Range Max Actual Last Updated Lake Forest, City of 20,922 Assistant City Manager 2080 $65,264 - $87,571 - 6/17/2005 Lincolnwood, Village of 12,101 Assistant Village Administrator 7/8/1999 2080 $62,004 $75,196 $88,388 $60,844 6/2/2004 Lisle, Village of 22,321 Assistant Village Manager 2080 $76,247 $91,533 $106,746 $96,558 6/2/2005 Morton Grove, Village of 22,383 Assistant Village Administrator 2080 - - - $95,481 2/25/2005 Roselle, Village of 23,367 Assistant Village Administrator 5/30/2000 2080 $72,888 - $97,678 - 7/27/2005 Vernon Hills, Village of 23,446 Assistant Village/City Manager 11/10/1999 - - - - $97,286 7/25/2005 Westmont, Village of 24,820 Assistant Village Manager 10/22/1984 - $76,251 $91,502 $106,75.2 $95,313 9/8/2003 Winfield, Village of 9,655 Deputy/Assistant Village/City Manager - $62,989 - $81,311 - 4/6/2004 AVERAGE $68,602 $82,929 $95,002 $91,742 Population >= 25,000 Batavia, City of 26,901 Assistant City Administrator 2080 $69,252 - $95,488 - 10/20/2004 Buffalo Grove, Village of 43,152 Assistant Village Manager 2080 $68,143 $84,849 $101,556 - 5/14/2004 Carol Stream, Village of 40,267 Assistant Village Manager 2080 $77,041 - $109,667 - 6/13/2005 Champaign, City of 70,306 Assistant City Manager 2080 - - - $117,599 6/3/2005 Crystal Lake, City of 40,496 Deputy City Manager 2/1/1999 2080 - $82,555 - $108,971 - 7/8/2005 DeKalb, City of 41,532 Administrative Services Director 1950 $61,343 $76,680 $92,016 - 3/4/2004 Downers Grove, Village of 49,302 Deputy City Manager - $83,889 $98,570 $113,250 $111,095 6/1/2004 Elgin, City of 97,761 Deputy City Manager 2080 $82,776 $95,820 $110,928 $110,9.28 3/28/2003 Glendale Heights, Village of 32,729 Assistant Village Administrator 2080 $85,280 $93,600 $99,840 - 6/23/2005 Gurnee, Village of 30,709 Deputy/Assistant Village/City Manager 2080 $76,444 $102,443 - 5/13/2005 Hanover Park, Village of 37,391 Assistant Village Manager 1/28/1980 1950 $69,613 $85,668 $101,722 $98,398 6/23/2005 Highland Park, City of 31,221 Assistant City Manager 2080 $84,841 - $113,121 $88,802 6/20/2005 Hoffman Estates, Village of 49,823 Assistant Village Manager 2080 $78,144 $95,974 $113,804 $105,048 8/10/2005 Joliet, City of 129,519 Deputy City Manager 10/5/1987 2080 $93,600 - $130,0.00 $106,683 1/12/2005 Mount Prospect,Village of 55,028 Assistant Village Manager 1950 - - - $107,900 2/8/2005 Mundelein, Village of 32,651 Assistant Village Administrator 11/28/1988 2080 $75,853 $88,737 $103,810 $103,810 5/10/2005 Naperville, City of 140,106 Assistant City Manager 2080 $90,106 $109,928 $132,345 $134,873 11/18/2004 Northbrook, Village of 34,209 Assistant Village Manager 1950 - - - $113,022 10/7/2004 Oak Park, Village of 50,993 Deputy/Assistant Village/City Manager 1950 $86,146 - $110,742 $97,771 5/28/2004 Orland Park, Village of 54,781 Assistant Village Manager 11/10/2003 2080 - - - $81,151 4/21/2005 Park Ridge, City of 37,185 Assistant City Manager 1950 $85,991 $103,188 $116,599 $114,061 5/4/2005 Schaumburg, Village of 73,346 Assistant Village Manager 1820 $82,739 - $118,970 $118,970 7/12/2004 Skokie, Village of 63,965 Assistant Village Manager 2080 $73,840 $96,595 $81,390 6/16/2005 Wheeling, Village of 36,766 Assistant Village Manager 3/10/2003 1950 - - - $80,250 4/22/2005 Wilmette, Village of 27,104 Assistant Village Manager 2080 $83,000 - $122,000 $89,000 1/17/2005 Woodridge, Village of 33,943 Assistant Village Administrator 5/5/2003 2080 $74,311 - $101,112 $95,306 8/12/2005 AVERAGE $79,281 $93,301 $109,285 $102,950