Loading...
Administration Packet 2005 02-03-05 • • . .c City of Yorkville z a► County Seat of Kendall County ji „ ' 800 Game Farm Road Est ` ` '1836 Yorkville, Illinois, 60560 4 Telephone: 630-553-4350 09 �„ . O Fax 630-553-7575 $ Website: www.yorkville.il.us '4CEx•' AGENDA ADMINISTRATION COMMITTEE MEETING Thursday,February 3,2005 6:30 P.M. CITY CONFERENCE ROOM Presentation: None Old Business: • 1. Minutes for Approval/Correction: January 6, 2005 2. Monthly Budget Report for December 2004 3. Dental/Vision &HSA— Survey Results and Cost Analysis 4. Director of Public Works Salary Survey New Business: 1. Bristol Kendall Fire Department Request for Fee Consideration for Permits/Reviews for Building Their New Station 2. 2004 Audit Proposal 3. 2005/2006 Budget 4. City Planner/Organizational Charts Additional Business: Page 1 of 8 DRAFT UNITED CITY OF YORKVILLE ADMINISTRATION COMMITTEE MEETING THURSDAY, JANUARY 6, 2005 6:30 PM City Hall Conference Room CITY OFFICIALS IN ATTENDANCE: Mayor Art Prochaska(arrived 6:45pm) Police Chief Harold Martin Alderman Paul James City Administrator Tony Graff Alderwoman Wanda Ohare Finance Director Traci Pleckham Alderman Joe Besco (left 8:00pm) City Treasurer Bill Powell(arrived 7pm) Alderman Larry Kot City Attorney John Wyeth Denise Kasper, Payroll & Benefits Specialist, United City of Yorkville OTHERS IN ATTENDANCE: Hugh Robinson, Tri-Land Properties Greg Hafemann, Tri-Land Properties Kathleen Field Orr/TIF Attorney, Kathleen Fields Orr& Associates Jeffrey Warren of Burke, Warren, Mackay & Serritella Representing Tri-Land Properties Joe Roberts, Caywood &Associates Andrea Visione, EBC Harold Oliver Mason Oliver The meeting was called to order at 6:34pm by Chairman Paul James. NEW BUSINESS 1. Countryside Center TIF-Alternate Revenue Bond Ordinance Kathleen Field Orr, TIF Attorney, was present to speak about the issuance of bonds in conjunction with Countryside Center. She stated a total investment of$26 million is required for the rehab of Countryside Center. The developer believed that TIF permitted reimbursement for acquisition and that the City would assume acquisition costs. However,that is not the case. She further stated that the money the City will contribute cannot not be used for acquisition. Further,the problem with this property is that money must be spent to tear down the present structure. Page 2 of 8 Alderman James asked what the City liability would be. Ms. Orr explained what she considered the "worst case" scenarios: 1. purchaser does not close on property 2. purchaser buys property and does not secure a lease within 3 years. The City would then lose $500,000,but the property would be more marketable after demolition. If the developer can't pay the debt service on bonds and the City must pay, this would reduce the $2.2 million note. She proposes that The City should withhold City money until some movement is seen and that will reduce the City's overall liability. Ms. Ohare added that the taxpayers' money must be protected. Ms. On summarized the project: 1. Once the owner acquires the property and demolishes the buildings,the City issues $2.5 million in bonds. 2. The owner secures a lease 3. When the work is completed, an additional $2.2 million note is issued 4. If any City funds are used,the amount of money for the developer is reduced Ms. Orr stated that TIF's are successful at least 75%of the time. If a plan does not proceed as scheduled, it can be amended. Administrator Graff asked Ms. On about a"trigger date" for sales tax to be used to pay down to the developer's note. Ms. Orr stated the tax is used as soon as it is generated or at the opening of the retailer. The Mayor left the meeting at this point of the meeting. Following additional discussion, Alderman James recapped Ms. Orr's presentation: 1. Developer must acquire property and raise all the money to purchase same 2. Reimburse purchaser for demolition: $500,000 3. Time frame for bond sale: March 22nd 4. Timeline for demolition to contract is 2 years 5. Time frame to secure contract and then building permit: not more than 3 years 6. $2.5 million is then released 7. Time frame is driven by business,written timeline will be provided. 8. The longer it takes for this process,the less money developer receives 9. Economic incentives built in Page 3 of 8 This matter now goes before the C.O.W. on January 18th. Administrator Graff asked Ms. Orr to prepare the agreement and a timeline of development events for that meeting. He also asked her to be present on January 25th at the City Council meeting. (moved forward in agenda to Presentations) PRESENTATIONS 1. Health and Employee Benefits Presentation a. Joe Roberts of Caywood and Associates b. Andrea Visione of EBC Mr. Roberts reiterated that the City's current dental and vision plan does not meet the guidelines of a qualified plan and has extreme liability. Mr. Roberts had been asked to research the best price possible for employee benefits. At this point, Mr. Graff introduced new City employee Denise Kasper, Payroll and Benefits Specialist who has been working with Mr. Roberts. MetLife was recommended as the dental insurance carrier--they currently provide the life insurance for the City. VSP was recommended by Mr. Roberts, as the vision plan. Based on 60 employees (33 families),the total premium would be(monthly) $3753 for dental and $634 for vision, for a total annual premium for both of$52,644. Ms. Pleckham said that approximately $40,000 was spent last year for employee claims. She also said that the employees have been asking for this type of coverage. More discussion will be held to determine if the employees must share in the cost. The proposed new program would be scheduled for a May 1St implementation. Alderman Besco voiced his approval that the program is HIPPA compliant. Alderman James then stated there were 2 decisions to be made: 1. Whether to terminate self-insurance and utilize proposed policy 2. Will the City pay for the entire program or are employee contributions necessary? Employees must receive a 90-day notice whenever a plan changes. February 1st would be the date the City must advise employees that this plan is being considered. Literature will be distributed to all employees. Alderman James asked Mr. Graff to advise the City staff that the Administration committee favors this plan and then he would like to bring this matter back to committee. He would like to review what has been spent in the last 3 years and also explore some options or variable costs depending on different scenarios. Alderman Kot said that if the City can afford the premium costs, it would be a goodwill gesture to not require the employees to share in the cost. A capped payout option is another alternative. Mr. Roberts then reminded the committee that he had previously suggested looking at a plan called the"125 Plan"which deals with pre-tax programs. He then also introduced Ms. Andrea Visione of EBC (Employee Benefits Corporation)to explain this program. She explained that the "125 Plan" gives employees/employers a"legal tax dodge"by Page 4 of 8 using flex plans. She said the average employee would save 25 cents tax on each dollar when using this plan. There are 3 items that the IRS code will allow under the"125 program" 1. Employee categories which do not apply to the employees at present 2. Voluntary health care reimbursement account FSA(Flexible Spending Account) which uses no-tax dollars (the downside is that funds are forfeited if not used) 3. Day care expense account with a cap of$5,000. The cost to the City is $720 for the set-up fee for the first year,with a fee of$450 annually thereafter. Alderwoman Ohare asked what the benefit to the City is. Employees in these flexible spending programs tend to pay more attention to costs in these consumer-driven programs. The other benefit is this gives some"insulation"to the City-- when/if the employees must help pay premiums,the City can remind them these FSA's are available to help absorb out-of-pocket expenses. A survey of the number of employees interested in the programs offered, will be taken and reported back to Administration in February. Alderman Kot concluded that these programs are excellent and education of the employees regarding these programs is very important. This discussion concluded at 7:55pm. 2. Director of Public Works Salary Survey Alderman James explained that Eric Dhuse' salary range needs to be aligned with department heads in neighboring towns. His salary was overlooked in a previous survey of other department heads in the City. If a raise were given, it must be recommended by the City Administrator and would be part of the budget process. Alderman Kot suggested that the budget be researched for any available money to give Mr. Dhuse a raise prior to the next budget. This issue will be brought back to the February Administration meeting. It was decided that a range will be determined by City staff. Administrator Graff will then call each committee member with that range in order to expedite this matter and move it on to C.O.W. At this time in the meeting,Alderman Besco left due to illness. Page 5 of 8 Treasurer Powell asked that"Old Business"Budget Report and Treasurer's Report be covered at this time. (next 2 items out of sequence) OLD BUSINESS 2. Monthly Budget Report for November 2004 Ms. Pleckham noted that the budget is on track on the revenue portion with the expenses being down. The budget is at 58.3%of the fiscal year,the incoming revenue is at 60% and 45%has been spent. Revised budget numbers will be on the December report. 3. Monthly Treasurer's Report for April 2004 Ms. Pleckham and Mr. Powell said there will be many treasurer's report at the next meeting. No further discussion. This moves to the consent agenda. (next item out of sequence-from New Business) NEW BUSINESS 3. IRS Code Section 61 Rule on Cell Phone Usage The IRS has a new rule that now considers cell phone usage for personal use, as a benefit that must be applied as wages or must be reimbursed. Mr. Graff said some options will be presented at the next Administration meeting. He added that Nextel has an option to have one line designated for business use and the second line designated for personal use. Personal calls would be billed directly to the employee. Auditors will be asked for direction on this new ruling and this issue will be discussed in February. OLD BUSINESS 1. Minutes for Approval/Correction: December 1, 2004& December 15, 2004 Minutes were approved for both dates. (items 2&3 discussed earlier) 4. Quarterly Department Vehicle Reports These reports have been moved from a monthly review to a quarterly review. Alderman Kot noted that Public Safety Committee reviews the police reports on a monthly basis. Page 6 of 8 5. Draft Donation/Sponsorship Policy Intern Bart Olson completed a revision on this policy for a final review. Mr. Graff noted that the Mayor is asking for money in the budget for the Human Resource Commission. The Commission will be asked to research grants for special events sponsorship requests. The Commission would then make a recommendation to the Council. This issue moves to C.O.W. 6. Draft Wearing Apparel Policy The committee decided to allow an employee to spend up to $60 per fiscal year for shirts and that amount can be reimbursed. Language will also be added stating the $60 reimbursement will be contingent upon available funds. This moves forward to C.O.W. 7. Draft Tuition Reimbursement Policy Other towns were surveyed regarding their policies on tuition reimbursement. One revision made in the policy was re-wording"Council approval"to "department head approval". This change was made because Councils in other towns were not involved in this function. It was noted that City Council approval is required in the Employee Manual. This moves on to C.O.W. 8. Draft Disposal of City Property Policy Ms. Kramer revised this policy. Mr. James noted that 2 storage units have excess items that will be disposed of when this policy becomes effective. The current rent on these 2 units is $75 per unit. This policy draft will move on to C.O.W. Consent will be requested at C.O.W. on the various policies that were discussed. 9. Special Census Full and partial censuses were explored. If a partial census were to be done, 13 new developments (577 units)would not be counted. The previous full census cost was $30,000 and$150,000 in revenue was gained. An application for a full census will be recommended. There is no limit to the number of times a census is taken. The City will attempt to use the previous census takers to minimize the training. When the contract is received, the matter will be taken to C.O.W. A timeline will also be brought to C.O.W. to indicate when the next census should be done. Page 7 of 8 10. Utility Locator Position When J.U.L.I.E. requests are made, the City must also assist in these locations. Many more locates are being requested and as a result, a full time position might be justified. Ms. Pleckham said the current J.U.L.I.E. City locator estimates 5 hours per day are spent on this function. She is working on a job description for such a position, which would report to the Public Works Director. The job description moves to C.O.W. for information and for approval of such a position. In February, a draft of the job description will be reviewed by the Administration Committee. The memo in this agenda packet will be included as part of the annual report. 11. Last Five Years Medical Costs Mr. Graff reported that no premium costs were included in the information from Caywood, however, general costs were included. Blue Cross will provide the percentage and actual amount of increase to the City over the past few years. Administrator Graff noted that there is now a $40 monthly charge for the Police and he anticipates an increase of 35-40%. This item will be discussed again at the February Administration meeting. 12. RFQ Policy It was recommended to adopt a policy to require RFQ's for all professional services. One of the issues stressed was the interview process and who would be involved in the process. One suggestion was to require Council approval of all RFQ's before being advertised. Many more RFQ's are anticipated in the future. A policy will be drafted and moved to C.O.W. When approved by Council members,the matter would be sent to the appropriate committee for action. ADDITIONAL BUSINESS Alderman Kot said off-hour use of equipment(copiers, phones etc.) should be placed on the next agenda. Pass codes were suggested for all equipment users. It was noted that elected officials now have computer logons available. There is no cost for these logons. Fencing around the air conditioning units, for security/safety reasons, was suggested by Alderman Kot. Chief Martin added that the generators would also be fenced. This issue will be addressed at a future meeting. Alderman Kot asked that it be noted in the minutes that Intern Bart Olson has done a very professional job. Page 8 of 8 Alderwoman Ohare noted that the City Hall flag is ripped and needs replacing. Any budget requests should be suggested to Ms. Pleckham prior to the February 3rd Administration meeting. A special meeting will be requested in February or March. Administrator Graff would like to initiate surveys of each department regarding their manpower allocation in relation to expected growth and how that compares to other communities. He would bring that information to the March meeting. He would also like to request staff input for redoing the bill list. Because of the growing bill list, he would like to suggest a list review meeting prior to the regular committee meeting. Chairman James cited the amount of time Ms. Pleckham must spend to prepare for questions regarding the bill list. Mr. Graff would like to research how other communities handle this procedure. This bill list matter will be placed on the Administration February meeting agenda. Alderman Kot reminded the committee that the bill list must still be approved by the Council, which in turn, opens the possibility of added discussion. Mr. Kot added that there had been previous discussion to expand the "detail" area of the bill list. There was no further business and the meeting was adjourned at 8:55pm. Minutes respectfully submitted by Marlys Young, Minute Taker . , 6 o United City of Yorkville Memo 1 _ E ' '" 800 Game Farm Road te 1836 Yorkville, Illinois 60560 ! Telephone: 630-553-4350 Fax: 630-553-7575 14,1_ 22r 1Date: 2i � i0 � To: A-c4-,,,,..,,,.. co r, ..,_ . From: T'a i_/ 'i E CI-k, l'i- Agenda Item: bee___ _.nAZEk, O'i 6,may-f 4,00,2_,./-- was ,00,2_-fwas not available at the time packets were produced. This item will be available l,(;) Ze'.j C Cis-,.r and distributed in a supplemental packet. �`. Eo co).. ar o United City of Yorkville Memo 800 Game Farm Road Esr. F 1836 Yorkville, Illinois 60560 '`� Telephone: 630-553-4350 0ep tQ S,x~ p Fax: 630-553-7575 mac_ `ir 4CE01 Date: February 2, 2005 To: Administration Committee t V From: Traci Pleckham—Finance Directo CC: Mayor Prochaska, Department Heads Subject: Additional information for Administration Committee Packets—February 3, 2005 Attached please find information on Old Business Item#2—Monthly Budget Report for December 2004. Please add this information to your packet. UNITED CITY OF YORKVILLE BUDGET 2004-2005 GENERAL FUND SUMMARY PERIOD ENDING DECEMBER 31, 2004 66.7% OF FISCAL YEAR REVENUE/EXPENSE THRU 2004-2005 PERCENT VS. DECEMBER 31, 2004 BUDGET BUDGET AMOUNT ,j NERAL FU D REVENUE ' 67 11,218,4807,1 9,963.82% r s = �' GENERAL FUND EXPENSES FINANCE &ADMINISTRATION 2,285,224 4,085,970 55.93% ENGINEERING 259,214 400,649 64.70% POLICE 1,333,627 1,955,579 68.20% BUILDING &ZONING 190,619 253,100 75.31% STREETS 1,200,285 4,017,182 29.88% HEALTH & SANITATION 292,964 506,000 57.90% TVTAL G NERAL FUND EXPENSES 5,561,933 11,218,480, 49.58° 2/2/2005 UNITED CITY OF YORKVILLE DETAILED REVENUE & EXPENSE REPORT AS OF DECEMBER 31, 2004 General Fund Revenue 1 Sanitary Sewer Improvement&Expansion 23 Finance 3 Water Improvement&Expansion 25 Engineering 6 Debt Service Fund 28 Police 7 Water Operations 30 Building and Zoning 9 Sewer Maintenance 34 Streets and Alleys 10 Land Cash 37 Health and Sanitation 12 Land Acquisition 41 Motor Fuel Tax Fund 13 Parks&Recreation 42 Municipal Building 15 Library 47 • Police Equipment Capital 17 Fox Industrial 51 Public Works Equipment Capital 19 Parks&Recreation Equipment Capital 21 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 1 TIME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW 66.7% OF FISCAL YEAR FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED 3ENERAL REVENUES TAXES 01-000-40-00-3995 FUND BALANCE 0.00 113,139.00 113,139.00 100.0 01-000-40-00-3996 ROAD CONTRIBUTION FEE 0.00 0.00 0.00 0.0 01-000-40-00-3997 IN TOWN ROAD PROGRAM FUNDING 0.00 632, 635.58 620,000.00 102.0 01-000-40-00-3998 MPI BRISTOL RIDGE RD FUNDING 0.00 1,368,475.09 2, 690,000.00 50.8 01-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 124,000.00 0.0 01-000-40-00-4000 REAL ESTATE TAXES 39,948.19 1,287,848.33 1,287,453.00 100.0 01-000-40-00-4001 TOWN ROAD/BRIDGE TAX 1,030.29 90, 674.03 95,000.00 95.4 01-000-40-00-4010 PERSONAL PROPERTY TAX 705.47 4,220.08 10,000.00 42.2 01-000-40-00-4020 STATE INCOME TAX 39,312.05 262, 961.00 593,257.00 44.3 01-000-40-00-4030 MUNICIPAL SALES TAX 195,893.61 1,144, 578.96 2,133,000.00 53.6 01-000-40-00-4032 STATE USE TAX 7, 643.47 44,364.22 87,890.00 50.4 01-000-40-00-4040 MUNICIPAL UTILITY TAX 0.00 273, 992.69 500,000.00 54.7 01-000-40-00-4041 UTILITY TAX - NICOR 22,742.47 22,742.47 75,000.00 30.3 01-000-40-00-4042 UTILITY TAX - CABLE TV 0.00 39,419.69 60,000.00 65.6 01-000-40-00-4043 UTILITY TAX - TELEPHONE 30, 901.08 177,020.64 250,000.00 70.8 01-000-40-00-4050 HOTEL TAX 1,395.48 12,752.92 19,000.00 67.1 TOTAL TAXES 339,572.11 5,474,824.70 8, 657,739.00 63.2 LICENSES & PERMITS 01-000-41-00-4100 LIQUOR LICENSE 0.00 9, 672.62 22,500.00 42.9 01-000-41-00-4101 OTHER LICENSES 0.00 3,718.26 4,000.00 92.9 01-000-41-00-4110 BUILDING PERMITS 85,790.00 604,847.80 870,000.00, 69.5 TOTAL LICENSES & PERMITS 85,790.00 618,238.68 896,500.00 68.9 CHARGES FOR SERVICES 01-000-42-00-4205 FILING FEES 3,756.00 18,749.75 22,000.00 85.2 01-000-42-00-4206 GARBAGE SURCHARGE 30,843.53 118,201.26 171,590.00 68.8 01-000-42-00-4207 REFUSE STICKERS 4.00 4.00 0.00 100.0 01-000-42-00-4208 COLLECTION FEE - YBSD 0.00 0.00 44,441.00 0.0 01-000-42-00-4210 DEVELOPMENT FEES 98,721.35 494,583.04 575,000.00 86.0 01-000-42-00-4211 ENGINEERING CAPITAL FEE 600.00 800.00 4,000.00 20.0 TOTAL CHARGES FOR SERVICES 133, 924.88 632,338.05 817,031.00 77.3 P1 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 2 TIME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED GENERAL FINES & FORFEITS 01-000-43-00-4310 TRAFFIC FINES 3,580.43 44,606.21 70,000.00 63.7 01-000-43-00-4315 REIMBURSE POLICE TRAINING 0.00 0.00 3,500.00 0.0 01-000-43-00-4320 ORDINANCE FEES 220.00 1,770.00 2,500.00 70.8 TOTAL FINES & FORFEITS 3,800.43 46,376.21 76,000.00 61.0 MISCELLANEOUS 01-000-44-00-4401 DARE DONATIONS 0.00 0.00 1,000.00 0.0 01-000-44-00-4402 ROB ROY CREEK HYDRAULIC STUDY 0.00 0.00 20,000.00 0.0 01-000-44-00-4410 REIMBURSEMENTS - OTHER GOVTS 18.20 18.20 0.00 100.0 01-000-44-00-4411 REIMBURSEMENTS-POLICE PROTECTN 160.00 1,930.00 3,000.00 64.3 01-000-44-00-4420 SIDWALK CONSTRUCTION 0.00 596.48 5,000.00 11.9 01-000-44-00-4490 MISCELLANEOUS INCOME 273.51 5,817.17 10,000.00 58.1 TOTAL MISCELLANEOUS 451.71 8,361.85 39,000.00 21.4 INTERGOVERNMENTAL 01-000-45-00-4504 TRAFFIC SIGNAL REVENUE 0.00 0.00 6,000.00 0.0 01-000-45-00-4505 COPS GRANT - VESTS 0.00 0.00 2,000.00 0.0 01-000-45-00-4510 COPS GRANT 0.00 26,277.13 41,000.00 64.0 01-000-45-00-4511 POLICE-STATE TOBACCO GRANT 0.00 1,210.00 1,210.00 100.0 01-000-45-00-4521 ICJIA BLOCK GRANT 0.00 0.00 0.00 0.0 TOTAL INTERGOVERNMENTAL 0.00 27,487.13 50,210.00 54.7 INTEREST 01-000-46-00-4600 INVESTMENT INCOME 4,919.52 17,339.88 12,000.00 144 .4 TOTAL INTEREST 4,919.52 17,339.88 12,000.00 144.4 TRANSFERS 01-000-49-00-4915 TRANSFER FROM WATER OPERATIONS 0.00 100,000.00 200,000.00 50.0 01-000-49-00-4920 TRANSFER FROM SEWER MAINT. 0.00 35,000.00 70,000.00 50.0 01-000-49-00-4925 TRANSFER FROM SAN. SEWER 0.00 100,000.00 200,000.00 50.0 01-000-49-00-4930 TRANSFER FROM WATER IMPROVE. 0.00 100,000.00 200,000.00 50.0 TOTAL TRANSFERS 0.00 335,000.00 670,000.00 50.0 • P2 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 3 DIME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL REVENUES: GENERAL 568,458.65 7,159, 966.50 11,218,480.00 63.8 FINANCE & ADMINISTRATION EXPENSES PERSONNEL SERVICES 01-110-50-00-5100 SALARIES - MAYOR 0.00 3,785.00 7,535.00 50.2 01-110-50-00-5101 SALARIES - CITY CLERK 0.00 1,835.00 3,635.00 50.4 01-110-50-00-5102 SALARIES - CITY TREASURER 0.00 1,835.00 3, 635.00 50.4 01-110-50-00-5103 SALARIES - ALDERMAN 0.00 14, 680.00 29,080.00 50.4 01-110-50-00-5104 SALARIES - LIQUOR COMMISSIONER 0.00 500.00 1,000.00 50.0 01-110-50-00-5105 SALARIES - CITY ATTORNEY 1,327.20 7, 963.20 13,500.00 58.9 01-110-50-00-5106 SALARIES - ADMINISTRATIVE 48,158.10 265,759.53 413,600.00 64.2 01-110-50-00-5136 SALARIES - PART TIME 5,082.60 27,020.58 48,000.00 56.2 01-110-50-00-5137 SALARIES - OVERTIME 0.00 172.80 1,500.00 11.5 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 4,420.50 9,000.00 49.1 01-110-50-00-5203 BENEFITS - HEALTH INSURANCE 50,419.19 298,014.00 621,000.00 47.9 01-110-50-00-5204 BENEFITS - GROUP LIFE INSURANC 1,983.51 11,212.68 18,000.00 62.2 01-110-50-00-5205 BENEFITS - DENTAL/VISION ASST 8,192.55 27, 948.41 50,000.00 55.8 TOTAL PERSONNEL SERVICES 115,163.15 665,146.70 1,219,485.00 54.5 PROFESSIONAL SERVICES 01-110-61-00-5300 LEGAL SERVICES 10,598.25 19,536.23 40,000.00 48.8 01-110-61-00-5304 AUDIT FEES & EXPENSES 0.00 14, 660.00 14, 660.00 100.0 01-110-61-00-5305 ACCOUNTING ASSISTANCE 0.00 4,700.00 7,500.00 62.6 01-110-61-00-5307 ACCOUNTING SYSTEM REVIEW 0.00 0.00 0.00 0.0 01-110-61-00-5308 GASB 34 0.00 280.00 15,000.00 1.8 01-110-61-00-5310 EMPLOYEE ASSISTANCE 0.00 1,700.00 4,500.00 37.7 01-110-61-00-5311 CODIFICATION 2,244.00 2,244.00 5,000.00 44.8 01-110-61-00-5314 BUILDING INSPECTIONS 68, 924.30 436,472.05 607,500.00 71.8 01-110-61-00-5322 BONDING 60.00 837.00 2,000.00 41.8 TOTAL PROFESSIONAL SERVICES 81,826.55 480,429.28 696, 160.00 69.0 CONTRACTUAL SERVICES P3 )ATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 4 DIME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ED: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ?INANCE & ADMINISTRATION EXPENSES CONTRACTUAL SERVICES 01-110-62-00-5400 INSURANCE-LIABILITY & PROPERTY 0.00 120,311.62 130,312.00 92.3 01-110-62-00-5401 CONTRACTUAL SERVICES 2,832.75 20,537.81 37,300.00 55.0 01-110-62-00-5403 SPECIAL CENSUS 0.00 0.00 0.00 0.0 Q1-110-62-00-5404 CABLE CONSORTIUM FEE 0.00 15,767.87 30,000.00 52.5 01-110-62-00-5406 OFFICE CLEANING 3,761.20 22,801.18 34,500.00 66.0 01-110-62-00-5410 MAINTENANCE - OFFICE EQUIPMENT 0.00 126.90 500.00 25.3 01-110-62-00-5411 MAINTENANCE - COMPUTERS 0.00 7,743.07 8,000.00 96.7 01-110-62-00-5412 MAINTENANCE - PHOTOCOPIERS 1, 616.00 11,312.00 19,392.00 58.3 01-110-62-00-5421 WEARING APPAREL 0.00 0.00 0.00 0.0 01-110-62-00-5427 FACADE PROGRAM 0.00 2,000.00 20,000.00 10.0 01-110-62-00-5436 TELEPHONE 1,825.05 12,712.15 20,000.00 63.5 01-110-62-00-5437 ACCTG SYSTEM SERVICE FEE 6,785.00 6,785.00 7,385.00 91.8 01-110-62-00-5438 CELLULAR TELEPHONE 120.22 1,045.24 2,300.00 45.4 01-110-62-00-5439 TELEPHONE SYSTEMS MAINTENANCE 0.00 1,237.20 11,000.00 11.2 TOTAL CONTRACTUAL SERVICES 16,940.22 222,380.04 320, 689.00 69.3 PROFESSIONAL DEVELOPMENT 01-110-64-00-5600 DUES 2, 645.00 3,086.75 4,000.00 77.1 01-110-64-00-5601 ILLINOIS MUNICIPAL LEAGUE DUES 690.00 690.00 551.00 125.2 01-110-64-00-5603 SUBSCRIPTIONS 0.00 195.00 400.00 48.7 01-110-64-00-5604 TRAINING & CONFERENCES 0.00 5,498.48 8,000.00 68.7 01-110-64-00-5605 TRAVEL/MEALS/LODGING 114.53 9,070.25 19,000.00 47.7 01-110-64-00-5607 PUBLIC RELATIONS 1,830.94 4, 996.91 11,000.00 45.4 TOTAL PROFESSIONAL DEVELOPMENT 5,280.47 23,537.39 42,951.00 54 .8 OPERATIONS 01-110-65-00-5800 CONTINGENCIES 7.67 11,338.17 163,500.00 6.9 01-110-65-00-5801 FUND BALANCE RESERVE 0.00 0.00 0.00 0.0 01-110-65-00-5802 OFFICE SUPPLIES 379.56 4,865.59 12,000.00 40.5 01-110-65-00-5804 OPERATING SUPPLIES 563.67 3,762.35 14,500.00 25.9 01-110-65-00-5808 POSTAGE & SHIPPING 121.87 8,022.88 8,000.00 100.2 01-110-65-00-5809 PRINTING & COPYING 1,872.86 6, 951.38 8,000.00 86.8 01-110-65-00-5810 PUBLISHING & ADVERTISING 0.00 1,779.60 3,000.00 59.3 P4 )ATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 5 'IME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 :D: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ?INANCE & ADMINISTRATION ',XPENSES OPERATIONS 01-110-65-00-5844 MARKETING - HOTEL TAX 1, 641.79 12,831.39 19,000.00 67.5 TOTAL OPERATIONS 4,587.42 49, 551.36 228,000.00 21.7 RETIREMENT 01-110-72-00-6500 IMRF PARTICIPANTS 5,306.56 29,473.53 44,000.00 66.9 01-110-72-00-6501 SOCIAL SECURITY & MEDICARE 3, 526.38 25, 167.86 42,500.00 59.2 TOTAL RETIREMENT 8,832.94 54, 641.39 86,500.00 63.1 CAPITAL OUTLAY 01-110-75-00-7002 COMPUTER EQUIP & SOFTWARE 3, 484.00 6,481.89 13,500.00 48.0 01-110-75-00-7003 OFFICE EQUIPMENT 0.00 1,924 .93 10,000.00 19.2 TOTAL CAPITAL OUTLAY 3,484.00 8,406.82 23,500.00 35.7 OTHER OPERATING EXPENSES 01-110-78-00-9001 CITY TAX REBATE 0.00 510.67 1,200.00 42.5 01-110-78-00-9002 NICOR GAS 2,759.06 6,442.05 30,000.00 21.4 01-110-78-00-9003 SALES TAX REBATE 2, 628.73 154,391.18 333,500.00 46.2 01-110-78-00-9004 MISCELLANEOUS 0.00 56.00 100.00 56.0 01-110-78-00-9005 MERIT/PAY EQUITY 0.00 0.00 0.00 0.0 TOTAL OTHER OPERATING EXPENSES 5,387.79 161,399.90 364,800.00 44.2 TRANSFERS 01-110-99-00-9923 TRANSFER TO LIBRARY 0.00 0.00 26,249.00 0.0 01-110-99-00-9925 TRANSFER TO SAN SEWER 0.00 75,000.00 150,000.00 50.0 01-110-99-00-9940 TRANSFER TO PARK & RECREATION 0.00 504,330.66 794,036.00 63.5 01-110-99-00-9941 TRANSFER TO PARK/REC CAPITAL 0.00 24,400.00 36, 600.00 66.6 01-110-99-00-9945 TRANSFER TO MUNICIPAL BLDG 0.00 16,000.00 97,000.00 16.4 01-110-99-00-9965 TRANSFER TO DEBT SERVICE 0.00 0.00 0.00 0.0 TOTAL TRANSFERS 0.00 619,730.66 1, 103,885.00 56.1 P5 )ATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 6 'IME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ED: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL $ ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL EXPENSES: FINANCE & ADMINISTRATION 241,502.54 2,285,223.54 4,085,970.00 55.9 iINGINEERING :XPENSES PERSONNEL SERVICES 01-150-50-00-5107 SALARIES-EMPLOYEES 27,866.13 164, 921.82 244, 945.00 67.3 01-150-50-00-5137 SALARIES-OVERTIME 31.80 444.12 1,000.00 44.4 TOTAL PERSONNEL SERVICES 27,897.93 165,365.94 245, 945.00 67.2 CONTRACTUAL SERVICES 01-150-62-00-5401 CONTRACTUAL SERVICES 4,285.20 32,476.61 58,000.00 55.9 01-150-62-00-5409 MAINTENANCE-VEHICLES 741.82 2,067.89 4,500.00 45.9 01-150-62-00-5410 MAINTENANCE-OFFICE EQUIP 0.00 0.00 2,000.00 0.0 01-150-62-00-5411 MAINTENANCE-COMPUTERS 0.00 2, 640.40 3,500.00 75.4 01-150-62-00-5421 WEARING APPAREL 106.00 292.00 1,100.00 26.5 01-150-62-00-5438 CELLULAR TELEPHONE 180.33 1,387.26 2,800.00 49.5 TOTAL CONTRACTUAL SERVICES 5,313.35 38,864.16 71, 900.00 54.0 PROFESSIONAL DEVELOPMENT 01-150-64-00-5600 DUES 0.00 225.00 300.00 75.0 01-150-64-00-5604 TRAINING & CONFERENCES 499.00 862.00 2,500.00 34.4 01-150-64-00-5605 TRAVEL EXPENSE 0.00 0.00 1,000.00 0.0 01-150-64-00-5616 BOOKS & PUBLICATIONS 0.00 91.32 200.00 45.6 TOTAL PROFESSIONAL DEVELOPMENT 499.00 1, 178.32 4,000.00 29.4 OPERATIONS 01-150-65-00-5801 ENGINEERING SUPPLIES 41.71 1,717.52 3,000.00 57.2 01-150-65-00-5802 OFFICE SUPPLIES 0.00 1,127.31 2,000.00 56.3 01-150-65-00-5809 PRINTING & COPYING 6.00 1,055.49 2,000.00 52.7 01-150-65-00-5814 STORM WATER SOFTWARE/TRAINING 0.00 1,000.00 5,000.00 20.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 19,602.57 24,000.00 81.6 TOTAL OPERATIONS 47.71 24,502.89 36,000.00 68.0 P6 )ATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 7 DIME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 [D: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED 'ENGINEERING RETIREMENT 01-150-72-00-6500 IMRF PARTICIPANTS 2,809.34 16, 652.37 23,804 .00 69.9 01-150-72-00-6501 SOCIAL SECURITY & MEDICARE 2,134.14 12, 650.39 19,000.00 66.5 TOTAL RETIREMENT 4, 943.48 29,302.76 42,804 .00 68.4 TOTAL EXPENSES: ENGINEERING 38,701.47 259,214.07 400, 649.00 64.6 ?UBLIC SAFETY/POLICE DEPT. iaPENSES PERSONNEL SERVICES 01-210-50-00-5107 SALARIES - EMPLOYEES 70, 673.67 368,900.59 541,000.00 68.1 01-210-50-00-5131 SALARIES - LIEUTENANT/SERGEANT 57, 572.38 327, 966.54 461,525.00 71.0 01-210-50-00-5133 SALARIES - COPS 17,715.26 103,446.69 148,496.00 69.6 01-210-50-00-5134 SALARIES - CROSSING GUARD 2, 426.50 8, 949.57 18,800.00 47.6 01-210-50-00-5135 SALARIES - POLICE CLERKS 11, 669.16 66,287.93 100,307.00 66.0 01-210-50-00-5136 SALARIES - PART TIME 3,425.41 12,140.79 20,000.00 60.7 01-210-50-00-5137 SALARIES - OVERTIME 4,591.49 31, 123.99 50,000.00 62.2 TOTAL PERSONNEL SERVICES 168,073.87 918,816.10 1,340,128.00 68.5 PROFESSIONAL SERVICES 01-210-61-00-5300 LEGAL SERVICES 0.00 2,338.40 6,300.00 37.1 TOTAL PROFESSIONAL SERVICES 0.00 2,338.40 6,300.00 37.1 CONTRACTUAL SERVICES 01-210-62-00-5408 MAINTENANCE - EQUIPMENT 356.83 4,734.33 8,000.00 59.1 01-210-62-00-5409 MAINTENANCE - VEHICLES 1,409.73 10, 615.90 21,000.00 50.5 01-210-62-00-5410 MAINT-OFFICE EQUIPMENT 219.45 1,250.99 2,500.00 50.0 01-210-62-00-5411 MAINTENANCE - COMPUTERS 0.00 397.59 2,000.00 19.8 01-210-62-00-5414 WEATHER WARNING SIREN MAINT 350.00 5,438.47 8,000.00 67.9 01-210-62-00-5421 WEARING APPAREL 7,873.49 12, 974.67 20,000.00 64.8 01-210-62-00-5422 COPS GRANT IV - VESTS 570.24 1, 687.52 2,500.00 67.5 01-210-62-00-5423 CLASY GRANT 0.00 0.00 0.00 0.0 P7 )ATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 8 LIME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ED: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ?UBLIC SAFETY/POLICE DEPT. F,XPENSES CONTRACTUAL SERVICES 01-210-62-00-5424 ICJIA-JUVENILE 0.00 0.00 5,000.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 500.00 1,375.00 1,000.00 137.5 01-210-62-00-5430 HEALTH SERVICES 270.00 2, 622.39 3,000.00 87.4 01-210-62-00-5431 LABORATORY FEES 80.00 505.00 1,000.00 50.5 01-210-62-00-5436 TELEPHONE 1,767.26 12,562.34 20,000.00 62.8 01-210-62-00-5438 CELLULAR TELEPHONE 874.52 7,076.01 13,000.00 54.4 01-210-62-00-5440 PAGERS 0.00 0.00 0.00 0.0 01-210-62-00-5441 MTD-ALERTS FEE 0.00 1,056.00 2,300.00 45.9 TOTAL CONTRACTUAL SERVICES 14,271.52 62,296.21 109,300.00 56.9 PROFESSIONAL DEVELOPMENT 01-210-64-00-5600 DUES 110.00 2,040.00 2,250.00 90.6 01-210-64-00-5603 SUBSCRIPTIONS 170.00 229.95 300.00 76.6 01-210-64-00-5604 TRAINING & CONFERENCE 730.00 14,084.02 19,000.00 74.1 01-210-64-00-5605 TRAVEL EXPENSES 1,427.25 7,178.36 9,000.00 79.7 01-210-64-00-5606 COMMUNITY RELATIONS 1,073.75 4, 421.43 5,250.00 84.2 01-210-64-00-5607 POLICE COMMISSION 0.00 4,002.61 11,000.00 36.3 01-210-64-00-5608 TUITION REIMBURSEMENT 2,280.00 4,170.97 14,000.00 29.7 01-210-64-00-5609 POLICE RECRUIT ACADEMY 7, 682.54 7, 682.54 10,500.00 73.1 01-210-64-00-5610 GUN RANGE FEES 0.00 56.64 625.00 9.0 01-210-64-00-5611 SRT FEE 0.00 0.00 2,000.00 0.0 TOTAL PROFESSIONAL DEVELOPMENT 13, 473.54 43,866.52 73,925.00 59.3 OPERATIONS 01-210-65-00-5800 CONTINGENCIES 0.00 0.00 0.00 0.0 01-210-65-00-5802 OFFICE SUPPLIES 1, 620.31 5,323.75 6,500.00 81.9 01-210-65-00-5804 OPERATING SUPPLIES 597.24 6,840.46 15,750.00 43.4 01-210-65-00-5808 POSTAGE & SHIPPING 0.00 400.51 3,000.00 13.3 01-210-65-00-5809 PRINTING & COPYING 266.15 1,823.95 4,500.00 40.5 01-210-65-00-5810 PUBLISHING & ADVERTISING 59.95 327.95 1,000.00 32.7 01-210-65-00-5812 GASOLINE 1,688.17 15,503.61 33,000.00 46.9 01-210-65-00-5813 AMMUNITION 0.00 0.00 5,000.00 0.0 P8 )ATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 9 'IME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ED: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL OPERATIONS 4,231.82 30,220.23 68,750.00 43.9 RETIREMENT 01-210-72-00-6500 IMRF PARTICIPANTS 1, 181.00 6,130.11 10,101.00 60.6 01-210-72-00-6501 SOCIAL SECURITY & MEDICARE 12,747.16 70,305.85 102,575.00 68.5 01-210-72-00-6502 POLICE PENSION 6,263.78 193,139.59 207,000.00 93.3 TOTAL RETIREMENT 20,191.94 269,575.55 319, 676.00 84.3 CAPITAL OUTLAY 01-210-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 6,122.99 8,500.00 72.0 TOTAL CAPITAL OUTLAY 0.00 6, 122.99 8,500.00 72.0 OTHER OPERATING EXPENSES 01-210-78-00-9004 BIKE PATROL 0.00 390.85 2,000.00 19.5 TOTAL OTHER OPERATING EXPENSES 0.00 390.85 2,000.00 19.5 TRANSFERS 01-210-99-00-9910 TRANSFER TO PD CAPITAL FUND 0.00 0.00 27,000.00 0.0 TOTAL TRANSFERS 0.00 0.00 27,000.00 0.0 TOTAL EXPENSES: PUBLIC SAFETY/POLICE DEPT. 220,242.69 1,333, 626.85 1,955,579.00 68.1 3UILDING & ZONING 3XPENSES PROFESSIONAL SERVICES 01-220-61-00-5300 LEGAL SERVICES 15,844.49 34,246.74 45,000.00 76.1 TOTAL PROFESSIONAL SERVICES 15,844.49 34,246.74 45,000.00 76.1 CONTRACTUAL SERVICES 01-220-62-00-5401 CONTRACTUAL SERVICES 29,944.99 97, 973.79 110,000.00 89.0 P9 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 10 DIME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED BUILDING & ZONING EXPENSES CONTRACTUAL SERVICES 01-220-62-00-5430 PLANNING CONSULTANT 5, 948.50 7,788.50 40,000.00 19.4 01-220-62-00-5432 ECONOMIC DEVELOPMENT 45,000.00 45,000.00 45,000.00 100.0 TOTAL CONTRACTUAL SERVICES 80,893.49 150,762.29 195,000.00 77.3 PROFESSIONAL DEVELOPMENT 01-220-64-00-5600 DUES 100.00 100.00 200.00 50.0 TOTAL PROFESSIONAL DEVELOPMENT 100.00 100.00 200.00 50.0 OPERATIONS 01-220-65-00-5804 OPERATING SUPPLIES 68.92 683.08 1,200.00 56.9 01-220-65-00-5809 PRINTING & COPYING 0.00 353.56 700.00 50.5 01-220-65-00-5810 PUBLISHING & ADVERTISING 336.00 3,575.86 8,000.00 44.6 01-220-65-00-5814 BOOKS & MAPS 10.00 897 .50 3,000.00 29.9 TOTAL OPERATIONS 414.92 5,510.00 12, 900.00 42.7 TOTAL EXPENSES: BUILDING & ZONING 97,252.90 190,619.03 253, 100.00 75.3 STREETS EXPENSES PERSONNEL SERVICES 01-410-50-00-5107 SALARIES - EMPLOYEE 18,273.87 107,414.18 156, 643.00 68.5 01-410-50-00-5136 SALARIES - PART TIME 0.00 2,338.50 5,500.00 42.5 01-410-50-00-5137 SALARIES - OVERTIME 2,053.05 7,116.44 18,000.00 39.5 TOTAL PERSONNEL SERVICES 20,326.92 116,869.12 180,143.00 64.8 PROFESSIONAL SERVICES 01-410-61-00-5313 ENGINEERING 0.00 4,269.00 120,000.00 3.5 01-410-61-00-5314 INSPECTIONS & LICENSES 0.00 0.00 100.00 0.0 TOTAL PROFESSIONAL SERVICES 0.00 4,269.00 120,100.00 3.5 P10 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 11 PIME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED STREETS CONTRACTUAL SERVICES 01-410-62-00-5401 CONTRACTUAL SERVICES 100.00 750.00 2,000.00 37.5 01-410-62-00-5408 MAINTENANCE-EQUIPMENT 400.50 2,703.30 10,000.00 27.0 01-410-62-00-5409 MAINTENANCE-VEHICLES 1, 673.06 5,928.12 11,000.00 53.8 01-410-62-00-5414 MAINTENANCE-TRAFFIC SIGNALS 0.00 9,815.04 22,000.00 44.6 01-410-62-00-5415 MAINTENANCE-STREET LIGHTS 1,808.82 10, 103.54 20,500.00 49.2 01-410-62-00-5420 MAINTENANCE-STORM SEWER 270.27 2, 611.45 5,000.00 52.2 01-410-62-00-5421 WEARING APPAREL 868.59 2,378.37 5,800.00 41.0 01-410-62-00-5434 RENTAL-EQUIPMENT 0.00 600.00 1,500.00 40.0 01-410-62-00-5435 ELECTRICITY 3, 628.64 28, 995.27 47,000.00 61.6 01-410-62-00-5438 CELLULAR TELEPHONE 229.27 1,197.22 2, 600.00 46.0 01-410-62-00-5440 STREET LIGHTING 0.00 0.00 4,500.00 0.0 TOTAL CONTRACTUAL SERVICES 8, 979.15 65,082.31 131,900.00 49.3 PROFESSIONAL DEVELOPMENT 01-410-64-00-5604 TRAINING & CONFERENCES 0.95 547.21 5, 600.00 9.7 TOTAL PROFESSIONAL DEVELOPMENT 0.95 547.21 5, 600.00 9.7 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 167.88 3,339.22 9,500.00 35.1 01-410-65-00-5812 GASOLINE 1,169.12 8,801.22 20,000.00 44.0 01-410-65-00-5815 HAND TOOLS 13.99 292.14 1, 500.00 19.4 01-410-65-00-5817 GRAVEL 0.00 1,293.03 5,500.00 23.5 TOTAL OPERATIONS 1,350.99 13,725.61 36,500.00 37.6 RETIREMENT 01-410-72-00-6500 IMRF PARTICIPANTS 2,046.93 11, 533.20 17,587.00 65.5 01-410-72-00-6501 SOCIAL SECURITY & MEDICARE 1,555.04 8, 940.62 13,780.00 64.8 TOTAL RETIREMENT 3, 601.97 20, 473.82 31, 367.00 65.2 CAPITAL OUTLAY P11 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 12 TIME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED STREETS EXPENSES CAPITAL OUTLAY 01-410-75-00-5418 MOSQUITO CONTROL 0.00 27,571.95 27,572.00 99.9 01-410-75-00-5419 MAINT SUPPLIES - STREET 1,260.35 2,758.30 15,000.00 18.3 01-410-75-00-7004 SAFETY EQUIPMENT 0.00 232.56 1,000.00 23.2 01-410-75-00-7099 BRISTOL RIDGE ROAD 0.00 669, 641.17 2, 690,000.00 24.8 01-410-75-00-7100 STREET REHAB PROJECTS 766.35 205, 468.38 213,000.00 96.4 01-410-75-00-7101 IN TOWN ROAD PROGRAM 0.00 45,280.80 500,000.00 9.0 01-410-75-00-7102 TREE & STUMP REMOVAL 3,450.00 7,710.00 30,000.00 25.7 01-410-75-00-7103 SIDEWALK CONSTRUCTION 0.00 19, 914.01 35,000.00 56.8 01-410-75-00-7104 FOX HILL SSA EXPENSES 0.00 740.60 0.00 (100.0) TOTAL CAPITAL OUTLAY 5,476.70 979,317.77 3, 511,572.00 27.8 TOTAL EXPENSES: STREETS 39,736.68 1,200,284.84 4,017,182.00 29.8 HEALTH & SANITATION EXPENSES CONTRACTUAL SERVICES 01-540-62-00-5442 GARBAGE SERVICES 43,812.11 288,444.39 502,000.00 57.4 01-540-62-00-5443 LEAF PICKUP 2,750.00 4,520.00 4,000.00 113.0 TOTAL CONTRACTUAL SERVICES 46,562.11 292, 964.39 506,000.00 57.8 TOTAL EXPENSES: HEALTH & SANITATION 46,562.11 292, 964.39 506,000.00 57.8 TOTAL FUND REVENUES 568, 458.65 7,159,966.50 11,218,480.00 63.8 TOTAL FUND EXPENSES 683, 998.39 5,561,932.72 11,218,480.00 49.5 FUND SURPLUS (DEFICIT) (115,539.74) 1,598,033.78 0.00 100.0 P12 )ATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 13 ['IME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ED: GL470002.WOW FUND: MOTOR FUEL TAX FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES TAXES 15-000-40-00-3999 CARRY OVER BALANCE 0.00 500,803.00 500,803.00 100.0 15-000-40-00-4060 MOTOR FUEL TAX ALLOTMENTS 13, 187.00 142,263.62 267,442.00 53.1 15-000-40-00-4065 IDOT TRUCK ACCESS GRANT 0.00 0.00 0.00 0.0 TOTAL TAXES 13, 187.00 643,066.62 768,245.00 83.7 INTEREST 15-000-46-00-4600 INVESTMENT INCOME 648.63 3, 600.24 5,000.00 72.0 TOTAL INTEREST 648.63 3, 600.24 5,000.00 72.0 TOTAL REVENUES: 13,835.63 646, 666.86 773,245.00 83.6 LXPENSES OPERATIONS 15-000-65-00-5800 CONTINGENCY 0.00 35, 993.83 372,833.00 9.6 15-000-65-00-5818 SALT 4, 597.86 4, 597.86 37,000.00 12.4 TOTAL OPERATIONS 4,597.86 40,591.69 409,833.00 9.9 CAPITAL OUTLAY 15-000-75-00-7007 SIGNS 724.54 8,206.26 9,700.00 84.6 15-000-75-00-7008 CRACK FILLING 0.00 24,122.58 25,000.00 96.4 15-000-75-00-7107 CONSTRUCTION ENGINEERING 4, 400.00 59,542.00 200,000.00 29.7 15-000-75-00-7108 VAN EMMON STREET 62,622.63 62, 622.63 62,625.00 99.9 15-000-75-00-7110 COLD PATCH 0.00 592.11 4,000.00 14.8 15-000-75-00-7111 HOT PATCH 0.00 3,444.39 7,000.00 49.2 15-000-75-00-7112 FAXON ROAD ENGINEERING 0.00 0.00 45,500.00 0.0 TOTAL CAPITAL OUTLAY 67,747.17 158,529.97 353,825.00 44 .8 TRANSFERS 15-000-99-00-9960 TRANSFER TO FOX IND FUND 0.00 0.00 9,587.00 0.0 TOTAL TRANSFERS 0.00 0.00 9,587.00 0.0 P13 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 14 DIME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: MOTOR FUEL TAX FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL EXPENSES: 72,345.03 199,121.66 773,245.00 25.7 TOTAL FUND REVENUES 13,835.63 646, 666.86 773,245.00 83.6 TOTAL FUND EXPENSES 72, 345.03 199,121.66 773,245.00 25.7 FUND SURPLUS (DEFICIT) (58,509.40) 447,545.20 0.00 100.0 P14 )ATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 15 DIME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 [D: GL470002.WOW FUND: MUNICIPAL BUILDLING FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CARRY OVER 16-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 0.00 0.0 TOTAL CARRY OVER 0.00 0.00 0.00 0.0 CHARGES FOR SERVICES 16-000-42-00-4211 DEVELOPMENT FEES-BUILDING 4,500.00 33,550.00 57, 600.00 58.2 TOTAL CHARGES FOR SERVICES 4,500.00 33, 550.00 57, 600.00 58.2 TRANSFERS 16-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 16,000.00 97,000.00 16.4 TOTAL TRANSFERS 0.00 16,000.00 97,000.00 16.4 TOTAL REVENUES: 4,500.00 49,550.00 154, 600.00 32.0 EXPENSES CONTRACTUAL SERVICES 16-000-62-00-5416 MAINT-GENERAL BLDG & GROUNDS 0.00 2, 161.60 5,000.00 43.2 TOTAL CONTRACTUAL SERVICES 0.00 2, 161.60 5,000.00 43.2 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 4,283.65 5,807.18 13,000.00 44.6 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 16.40 1,782.12 9,000.00 19.8 16-000-75-00-7204 BLDG MAINT - CITY HALL 29, 975.80 37,049.39 73,000.00 50.7 16-000-75-00-7205 BLDG IMPROVEMENTS-LIBRARY 542.00 1, 995.60 4,000.00 49.8 16-000-75-00-7206 LANDSCAPING-PUBLIC BUILDINGS 0.00 98.19 2,000.00 4.9 16-000-75-00-7209 BEECHER PARKING LOT 0.00 2,457.12 45,000.00 5.4 TOTAL CAPITAL OUTLAY 34,817.85 49,189.60 149, 600.00 32.8 P15 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 16 TIME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: MUNICIPAL BUILDLING FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL $ ACCOUNT DECEMBER 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 TOTAL EXPENSES: 34,817.85 51,351.20 154, 600.00 33.2 TOTAL FUND REVENUES 4,500.00 49,550.00 154, 600.00 32.0 TOTAL FUND EXPENSES 34,817.85 51,351.20 154, 600.00 33.2 FUND SURPLUS (DEFICIT) (30,317.85) (1,801.20) 0.00 100.0 • P16 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 17 TIME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: POLICE EQUIPMENT CAPITAL FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CARRY OVER 20-000-40-00-3999 CARRY OVER BALANCE 0.00 76,718.00 76,718.00 100.0 TOTAL CARRY OVER 0.00 76,718.00 76,718.00 100.0 CHARGES FOR SERVICES 20-000-42-00-4212 DEV FEES - POLICE 5,850.00 49,200.00 95,000.00 51.7 TOTAL CHARGES FOR SERVICES 5,850.00 49,200.00 95,000.00 51.7 MISCELLANEOUS 20-000-44-00-4402 K-9 DONATIONS 0.00 1,700.00 1,700.00 100.0 20-000-44-00-4403 IN CAR VIDEO DONATIONS 0.00 1,500.00 2,000.00 75.0 20-000-44-00-4404 DONATIONS 0.00 387.00 500.00 77.4 20-000-44-00-4405 WEATHER WARNING SIREN 0.00 5,137.50 30,000.00 17.1 20-000-44-00-4431 SALE OF POLICE SQUADS 0.00 0.00 1,000.00 0.0 TOTAL MISCELLANEOUS 0.00 8,724.50 35,200.00 24 .7 OTHER OPERATING RECEIPTS 20-000-48-00-4800 LOAN PROCEEDS 0.00 0.00 62, 500.00 0.0 TOTAL OTHER OPERATING RECEIPTS 0.00 0.00 62,500.00 0.0 TRANSFERS 20-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 0.00 27,000.00 0.0 TOTAL TRANSFERS 0.00 0.00 27,000.00 0.0 TOTAL REVENUES: 5,850.00 134, 642.50 296,418.00 45.4 EXPENSES WEAPONS 20-000-65-00-5811 LETHAL/NON-LETHAL WEAPONS 0.00 2,000.00 6,500.00 30.7 TOTAL WEAPONS 0.00 2,000.00 6,500.00 30.7 P17 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 18 TIME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: POLICE EQUIPMENT CAPITAL FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED CAPITAL OUTLAY 20-000-75-00-7001 EQUIPMENT 9, 999.00 12, 941.28 39,016.00 33.1 20-000-75-00-7002 K-9 EQUIPMENT 858.62 1,311.27 1,700.00 77.1 20-000-75-00-7003 EXPEDITION AND ACCESSORIES 0.00 0.00 0.00 0.0 20-000-75-00-7005 VEHICLES 0.00 18,224.00 80,500.00 22.6 20-000-75-00-7006 CAR BUILD OUT 7,434.74 13, 572.24 23,360.00 58.1 20-000-75-00-7008 NEW WEATHER WARNING SIRENS 0.00 0.00 72,190.00 0.0 TOTAL CAPITAL OUTLAY 18,292.36 46,048.79 216,766.00 21.2 OTHER 20-000-78-00-9009 RESERVE (9,999.00) 0.00 0.00 0.0 TOTAL OTHER (9, 999.00) 0.00 0.00 0.0 TRANSFERS 20-000-99-00-9965 TRANSFER TO DEBT SERV FUND 0.00 36,576.00 73, 152.00 50.0 TOTAL TRANSFERS 0.00 36, 576.00 73,152.00 50.0 TOTAL EXPENSES: 8,293.36 84,624.79 296,418.00 28.5 TOTAL FUND REVENUES 5,850.00 134, 642.50 296,418.00 45.4 TOTAL FUND EXPENSES 8,293.36 84, 624.79 296,418.00 28.5 FUND SURPLUS (DEFICIT) (2,443.36) 50,017.71 0.00 100.0 P18 )ATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 19 LIME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ED: GL470002.WOW FUND: PUBLIC WORKS EQUIP CAPITAL FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CARRY OVER 21-000-40-00-3999 CARRY OVER BALANCE 0.00 272,054.00 272,054.00 100.0 TOTAL CARRY OVER 0.00 272,054 .00 272,054.00 100.0 CHARGES FOR SERVICES 21-000-42-00-4213 DEVELOPMENT FEES-PUBLIC WORKS 16,350.00 146, 468.00 279,700.00 52.3 TOTAL CHARGES FOR SERVICES 16,350.00 146,468.00 279,700.00 52.3 MISCELLANEOUS 21-000-44-00-4430 SALE OF EQUIPMENT 0.00 4, 510.11 4, 510.00 100.0 TOTAL MISCELLANEOUS 0.00 4,510.11 4,510.00 100.0 TRANSFERS 21-000-49-00-4915 TRANSFER FROM WATER FUND 0.00 25,000.00 50,000.00 50.0 21-000-49-00-4920 TRANSFER FROM SEWER FUND 0.00 15,000.00 30,000.00 50.0 TOTAL TRANSFERS 0.00 40,000.00 80,000.00 50.0 TOTAL REVENUES: 16,350.00 463,032.11 636,264 .00 72.7 EXPENSES CAPITAL OUTLAY 21-000-75-00-7005 VEHICLES 0.00 42,130.00 176, 905.00 23.8 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 9,500.00 3,500.00 271.4 21-000-75-00-7100 BOB CAT EXCHANGE 0.00 0.00 0.00 0.0 21-000-75-00-7107 TRUCK ACCESSORIES 1,361.00 1,550.00 5,000.00 31.0 21-000-75-00-7108 SKIDSTEE GRADER 0.00 0.00 6,300.00 0.0 P19 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 20 TIME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: PUBLIC WORKS EQUIP CAPITAL FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES CAPITAL OUTLAY 21-000-75-00-7109 MOWER 0.00 21,000.00 21,000.00 100.0 21-000-75-00-7110 LEAF CHOPPER/VAC 0.00 0.00 35,557.00 0.0 21-000-75-00-7120 STREET SWEEPER 0.00 0.00 150,000.00 0.0 21-000-75-00-7130 PUBLIC WORKS BLDG ADDITION 0.00 0.00 90,000.00 0.0 TOTAL CAPITAL OUTLAY 1,361.00 74,180.00 488,262.00 15.1 OTHER 21-000-78-00-9009 RESERVE 0.00 35,557.00 148,002.00 24.0 TOTAL OTHER 0.00 35,557.00 148,002.00 24.0 TOTAL EXPENSES: 1,361.00 109,737.00 636,264.00 17.2 TOTAL FUND REVENUES 16,350.00 463,032.11 636,264.00 72.7 TOTAL FUND EXPENSES 1,361.00 109,737.00 636,264.00 17.2 FUND SURPLUS (DEFICIT) 14, 989.00 353,295.11 0.00 100.0 P20 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 21 DIME: 16:49:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: PARKS & REC EQUIP CAPITAL FOR B PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CARRY OVER 22-000-40-00-3999 CARRY OVER BALANCE 0.00 24, 624.00 24, 624.00 100.0 TOTAL CARRY OVER 0.00 24, 624.00 24, 624.00 100.0 CHARGES FOR SERVICES 22-000-42-00-4216 PARKS CAPITAL FEE 0.00 100.00 2,000.00 5.0 22-000-42-00-4218 IL CLEAN ENERGY GRANT 0.00 4,149.00 4,149.00 100.0 TOTAL CHARGES FOR SERVICES 0.00 4,249.00 6, 149.00 69.1 TRANSFERS 22-000-49-00-4930 TRANSFER FRM GENERAL FUND 0.00 24, 400.00 36, 600.00 66.6 22-000-49-00-4935 TRANSFER FROM LAND CASH 22,000.00 22,000.00 22,000.00 100.0 TOTAL TRANSFERS 22,000.00 46,400.00 58, 600.00 79.1 TOTAL REVENUES: 22,000.00 75,273.00 89,373.00 84 .2 EXPENSES OTHER 22-000-65-00-5800 RESERVE 0.00 0.00 1,750.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,750.00 0.0 PARKS EXPENSES 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 26,861.00 26,861.00 100.0 22-610-75-00-7007 SOCCER GOALS 12' REPLACEMENT 0.00 3, 165.66 0.00 (100.0) 22-610-75-00-7008 SOCCER GOALS 9' 0.00 0.00 0.00 0.0 22-610-75-00-7009 COMPUTER WORKSTATIONS 1,368.95 3,004.69 6,825.00 44 .0 P21 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 22 DIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: PARKS & REC EQUIP CAPITAL FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED PARKS EXPENSES CAPITAL OUTLAY 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 1,720.00 9,000.00 19.1 22-610-75-00-7012 PLAYGROUNDS 0.00 0.00 4,000.00 0.0 22-610-75-00-7013 PLAYGROUND REPAIRS 0.00 0.00 2,000.00 0.0 22-610-75-00-7014 SIGN REPLACEMENTS 0.00 0.00 3,000.00 0.0 22-610-75-00-7015 MOWER 0.00 19,857.27 19,857.00 100.0 22-610-75-00-7016 BEECHER PATHWAY 0.00 9,480.00 9,480.00 100.0 22-610-75-00-7017 RECREATION EQUIPMENT 0.00 923.88 6,600.00 13.9 TOTAL CAPITAL OUTLAY 1,368.95 65,012.50 87, 623.00 74.1 TOTAL EXPENSES: PARKS 1,368.95 65,012.50 87, 623.00 74.1 TOTAL FUND REVENUES 22,000.00 75,273.00 89,373.00 84.2 TOTAL FUND EXPENSES 1,368.95 65,012.50 89,373.00 72.7 FUND SURPLUS (DEFICIT) 20, 631.05 10,260.50 0.00 100.0 P22 )ATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 23 ['IME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 CD: GL470002.WOW FUND: SANITARY SEWER IMPROVEMENT FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED 1EVENUES CARRY OVER 37-000-40-00-3999 CARRY OVER 0.00 9, 459,809.00 - 9, 459,809.00 100.0 TOTAL CARRY OVER 0.00 9,459,809.00 9,459,809.00 100.0 CHARGES FOR SERVICES 37-000-42-00-4220 CONNECTION FEES 51,400.00 419,400.00 1,071,200.00 39.1 37-000-42-00-4221 RIVER CROSSING FEES 799.50 18, 601.10 20,000.00 93.0 TOTAL CHARGES FOR SERVICES 52,199.50 438,001.10 1,091,200.00 40.1 INTEREST 37-000-46-00-4600 INVESTMENT INCOME 5,999.63 49,563.12 20,000.00 247.8 TOTAL INTEREST 5,999.63 49,563.12 20,000.00 247.8 OTHER OPERATING RECEIPTS 37-000-48-00-4800 COMED/HYDRAULIC DEBT CERT. 0.00 0.00 0.00 0.0 37-000-48-00-4801 BRUELL ST. DEBT CERT. PROCEEDS (325.00) (325.00) 0.00 100.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 100,000.00 550,000.00 750,000.00 73.3 37-000-48-00-4804 SOUTHWEST SVC AREA INTERCEPTOR 0.00 0.00 460,000.00 0.0 TOTAL OTHER OPERATING RECEIPTS 99,675.00 549, 675.00 1,210,000.00 45.4 TRANSFERS 37-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 75,000.00 150,000.00 50.0 TOTAL TRANSFERS 0.00 75,000.00 150,000.00 50.0 TOTAL REVENUES: 157,874.13 10, 572,048.22 11, 931,009.00 88.6 EXPENSES CONTRACTUAL SERVICES 37-000-62-00-5401 CONTRACTURAL/PROFESSIONAL SERV 0.00 3,239.07 40,000.00 8.0 P23 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 24 DIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: SANITARY SEWER IMPROVEMENT FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES CONTRACTUAL SERVICES 37-000-62-00-5402 ENG/LGL/CONTINGNCY-COUNTRYSIDE 444,350.54 479,103.04 800,000.00 59.8 37-000-62-00-5405 ENG/LGL/CONTINGENCY-BRUELL ST. 220,267.34 224, 687.40 500,000.00 44.9 37-000-62-00-5406 ENG/LGL/CONTINGENCY-HYDRAULIC 43,322.02 108, 678.92 666, 625.00 16.3 37-000-62-00-5407 ENG/LGL/CONTING ROB ROY CREEK 0.00 0.00 0.00 0.0 TOTAL CONTRACTUAL SERVICES 707,939.90 815,708.43 2,006, 625.00 40.6 OTHER 37-000-65-00-5421 GIS SYSTEM 0.00 0.00 15,000.00 0.0 37-000-65-00-5800 CONTINGENCY 988.41 9,004.57 44,156.00 20.3 TOTAL OTHER 988.41 9,004.57 59,156.00 15.2 CAPITAL OUTLAY 37-000-75-00-7109 CONTRACTUAL/PROFESSIONAL SVC 0.00 (390.00) 0.00 (100.0) 37-000-75-00-7502 HYDRAULIC INTERCEPTOR 636,396.30 1,564, 630.63 1,847,778.00 84.6 37-000-75-00-7503 COUNTRYSIDE INTERCEPTOR ' 1,575.00 16, 907.25 2, 903,411.00 0.5 37-000-75-00-7504 BRUELL STREET LIFT STATION 52,767.96 395,866.06 1,435,735.00 27.5 37-000-75-00-7505 ROB ROY CREEK SANITARY 335,819.10 825,792.10 1,750,000.00 47.1 37-000-75-00-7506 SOUTHWEST SVC AREA INTERCEPTOR 0.00 0.00 460,000.00 0.0 37-000-75-00-7507 SANITARY JETTER TRUCK 0.00 224,928.00 225,000.00 99.9 37-000-75-00-7515 HEARTLAND ONSITE INTERCEPTOR 0.00 0.00 600,000.00 0.0 TOTAL CAPITAL OUTLAY 1,026,558.36 3,027,734.04 9,221, 924.00 32.8 TRANSFERS 37-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 100,000.00 200,000.00 50.0 37-000-99-00-9965 TRANSFER TO DEBT SERVICE 0.00 219,283.00 443,304.00 49.4 TOTAL TRANSFERS 0.00 319,283.00 643,304.00 49.6 TOTAL EXPENSES: 1,735,486.67 4,171,730.04 11, 931,009.00 34.9 TOTAL FUND REVENUES 157,874.13 10,572,048.22 11,931,009.00 88.6 TOTAL FUND EXPENSES 1,735,486.67 4,171,730.04 11,931,009.00 34.9 FUND SURPLUS (DEFICIT) (1,577,612.54) 6,400,318.18 0.00 100.0 P24 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 25 TIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED. REVENUES CARRY OVER 41-000-40-00-3999 CARRY OVER 0.00 2,387,243.00 2,387,243.00 100.0 TOTAL CARRY OVER 0.00 2,387,243.00 2,387,243.00 100.0 CHARGES FOR SERVICES 41-000-42-00-4220 CONNECTION FEES 62,365.00 317,795.00 1,000,000.00 31.7 41-000-42-00-4221 SOUTHWEST WATER MAIN REVENUE 0.00 0.00 180,000.00 0.0 TOTAL CHARGES FOR SERVICES 62,365.00 317,795.00 1,180,000.00 26.9 INTERGOVERNMENTAL 41-000-45-00-4530 RADIUM GRANT 0.00 873,440.16 950,000.00 91.9 TOTAL INTERGOVERNMENTAL 0.00 873,440.16 950,000.00 91.9 INTEREST 41-000-46-00-4600 INVESTMENT INCOME 7,609.03 49, 912.62 20,000.00 249.5 TOTAL INTEREST 7,809.03 49, 912.62 20,000.00 249.5 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 4,400,000.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 4,400,000.00 0.0 TRANSFERS 41-000-49-00-4915 TRANSFER FROM WATER FUND 0.00 35,000.00 70,000.00 50.0 TOTAL TRANSFERS 0.00 35,000.00 70,000.00 50.0 TOTAL REVENUES: 70,174.03 3, 663,390.78 9,007,243.00 40.6 EXPENSES P25 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 26 TIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED PROFESSIONAL SERVICE 41-000-61-00-5300 LEGAL SERVICES 375.00 450.00 5,000.00 9.0 41-000-61-00-5301 ENGINEERING - GENERAL SERVICES 3,793.50 6, 646.50 7,500.00 88.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 6, 688.88 20,353.75 476,155.00 4.2 41-000-61-00-5405 PROF. SVCS- RADIUM CONTRACT B 0.00 6,878.25 261,115.00 2.6 41-000-61-00-5408 CENTRAL ZONE - CONTRACT C 402,703.84 1,584,478.79 2,494,752.00 63.5 41-000-61-00-5410 ENGINEERING-CENTRAL ZONE 17, 996.30 77, 692.56 71,873.00 108.0 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 0.00 2,104.24 2,500.00 84.1 41-000-61-00-5415 USGS GROUNDWATER STUDY 24,490.00 31,569.00 24,490.00 128.9 41-000-61-00-5416 USGS GROUNDWATER COUNTYWIDE 0.00 0.00 8,260.00 0.0 41-000-61-00-5417 USGS GROUNDWATER SHALLOW WATER 0.00 0.00 29,750.00 0.0 TOTAL PROFESSIONAL SERVICE 456,047.52 1,730,173.09 7,044,125.00 24.5 OTHER 41-000-65-00-5421 GIS SYSTEM 0.00 0.00 20,000.00 0.0 41-000-65-00-5800 CONTINGENCY 44,382.86 133, 616.61 33,489.00 398.9 TOTAL OTHER 44,382.86 133, 616.61 53,489.00 249.8 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 CAPITAL OUTLAY 41-000-75-00-7503 SOUTHWEST WATER MAIN PROJECT 0.00 1,242.00 180,000.00 0.6 41-000-75-00-7504 NORTH WATER TOWER-CONTRACT A 699,949.90 767,769.36 1,085,243.00 70.7 41-000-75-00-7505 JOHNSON STREET WATER MAIN 0.00 0.00 0.00 0.0 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 44,000.00 0.0 41-000-75-00-7515 JOHNSON STREET WATER MAIN 0.00 36,123.35 36,023.00 100.2 TOTAL CAPITAL OUTLAY 699, 949.90 805,134.71 1,345,266.00 59.8 P26 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 27 TIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TRANSFERS 41-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 100,000.00 200,000.00 50.0 41-000-99-00-9965 TRANSFER TO DEBT FUND 0.00 182,181.50 364,363.00 50.0 TOTAL TRANSFERS 0.00 282,181.50 564,363.00 50.0 TOTAL EXPENSES: 1,200,380.28 2, 951, 105.91 9,007,243.00 32.7 TOTAL FUND REVENUES 70, 174.03 3, 663,390.78 9,007,243.00 40.6 TOTAL FUND EXPENSES 1,200,380.28 2, 951, 105.91 9,007,243.00 32.7 FUND SURPLUS (DEFICIT) (1, 130,206.25) 712,284.87 0.00 100.0 P27 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 28 TIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: DEBT SERVICE FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CARRY OVER 42-000-40-00-3999 CARRY OVER 0.00 15,540.00 15,540.00 100.0 TOTAL CARRY OVER 0.00 15,540.00 15,540.00 100.0 MISCELLANEOUS 42-000-44-00-4440 RECAPTURE-WATER/SEWER 15,478.10 105,709.10 95,000.00 111.2 TOTAL MISCELLANEOUS 15,478.10 105,709.10 95,000.00 111.2 TRANSFERS 42-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 0.00 9,722.00 0.0 42-000-49-00-4910 TRANSFER FROM POLICE EQUIP CAP 0.00 36,576.00 73,152.00 50.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 0.00 219,283.00 443,304.00 49.4 42-000-49-00-4930 TRANSFER FROM WATER IMPRV FUND 0.00 182, 181.50 364,363.00 50.0 TOTAL TRANSFERS 0.00 438,040.50 890,541.00 49.1 TOTAL REVENUES: 15,478.10 559,289.60 1,001,081.00 55.8 EXPENSES DEBT SERVICE 42-000-66-00-6001 CITY HALL BONDS-PRINCIPAL PMT 50,000.00 50,000.00 50,000.00 100.0 42-000-66-00-6002 CITY HALL BONDS - INTEREST PMT 27,498.75 54, 997.50 54,998.00 99.9 42-000-66-00-6003 IRBB-BRUELL ST. INTEREST PMTS 0.00 43,357.50 86,715.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,017.00 1,017.00 100.0 42-000-66-00-6006 NORTH H2O TOWER PRINCIPAL PYMT 0.00 23, 983.00 23, 983.00 100.0 42-000-66-00-6007 4.8 MILLION DEBT CERT INT PYMT 116,575.00 339,362.82 339,363.00 99.9 42-000-66-00-6009 COUNTRYSIDE ALT REV INT PYMT 60,318.75 100,196.23 100, 196.00 100.0 42-000-66-00-6010 COMED/HYDRAULIC INTEREST PYMT 35,894.57 35,894.57 35,895.00 99.9 42-000-66-00-6050 LOAN PAYMENT-SANITARY SIPHON 0.00 19,489.99 38,989.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 P28 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 29 TIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: DEBT SERVICE FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES DEBT SERVICE 42-000-66-00-6053 LOAN PAYMENT-RIVER CROSSING 0.00 0.00 0.00 0.0 42-000-66-00-6054 LOAN PAYMENT-POLICE SQUAD CAR 0.00 24,109.66 24,110.00 99.9 42-000-66-00-6055 LOAN PAYMENT-SSES IEPA L171153 0.00 53,525.35 107,051.00 49.9 42-000-66-00-6056 YNB-POLICE/ADMIN CARS 0.00 58,781.10 58,764 .00 100.0 42-000-66-00-6057 IRBB-BRUELL ST. INTEREST PMT 0.00 0.00 0.00 0.0 TOTAL DEBT SERVICE 290,287.07 804,714.72 1,001,081.00 80.3 TOTAL FUND REVENUES 15,478.10 559,289.60 1,001,081.00 55.8 TOTAL FUND EXPENSES 290,287.07 804,714.72 1,001,081.00 80.3 FUND SURPLUS (DEFICIT) (274,808.97) (245,425.12) 0.00 100.0 P29 (DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 30 TIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CARRY OVER 51-000-40-00-3999 CARRY OVER BALANCE 0.00 1,540,418.00 1,540,418.00 100.0 TOTAL CARRY OVER 0.00 1,540,418.00 1,540,418.00 100.0 CHARGES FOR SERVICES 51-000-42-00-4240 BULK WATER SALES 800.00 8,115.83 9,000.00 90.1 51-000-42-00-4241 WATER SALES 165,857.08 690, 991.75 950,000.00 72.7 51-000-42-00-4242 WATER METER SALES 12,250.00 101,374.20 130,000.00 77.9 51-000-42-00-4243 LEASE REVENUE - H2O TOWER 1,800.00 14,400.00 21, 600.00 66.6 TOTAL CHARGES FOR SERVICES 180,707.08 814,881.78 1, 110, 600.00 73.3 MISCELLANEOUS 51-000-44-00-4490 MISCELLANEOUS INCOME 0.00 325.00 500.00 65.0 TOTAL MISCELLANEOUS 0.00 325.00 500.00 65.0 INTEREST 51-000-46-00-4600 INVESTMENT INCOME 3,557.06 10, 676.00 8,000.00 133.4 TOTAL INTEREST 3,557.06 10, 676.00 8,000.00 133.4 TOTAL REVENUES: 184,264.14 2,366,300.78 2, 659,518.00 88.9 EXPENSES PERSONNEL 51-000-50-00-5107 SALARIES - EMPLOYEE 27, 128.41 139,142.95 223,465.00 62.2 51-000-50-00-5136 SALARIES-PART TIME 390.00 5,858.40 4,000.00 146.4 51-000-50-00-5137 SALARIES - OVERTIME 4,715.21 22,382.64 27,000.00 82.8 TOTAL PERSONNEL 32,233.62 167,383.99 254,465.00 65.7 PROFESSIONAL SERVICES 51-000-61-00-5300 LEGAL SERVICES 0.00 0.00 2,000.00 0.0 P30 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 31 TIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES PROFESSIONAL SERVICES 51-000-61-00-5303 JULIE SERVICE 659.75 4,285.80 6,000.00 71.4 TOTAL PROFESSIONAL SERVICES 659.75 4,285.80 8,000.00 53.5 CONTRACTURAL SERVICES 51-000-62-00-5401 CONTRACUAL SERVICES 33.97 2, 676.60 4,000.00 66.9 51-000-62-00-5407 TREATMENT FACILITIES O&M 262.24 262.24 44,000.00 0.5 51-000-62-00-5408 MAINTENANCE-EQUIPMENT 227.20 3,398.16 10,000.00 33.9 51-000-62-00-5409 MAINTENANCE - VEHICLES 0.00 1,836.03 10,000.00 18.3 51-000-62-00-5411 MAINTENANCE-COMPUTERS 0.00 218.83 4,000.00 5.4 51-000-62-00-5413 MAINTENANCE-CONTROL SYSTEM 0.00 2,386.93 8,000.00 29.8 51-000-62-00-5414 TRUCK LETTERING 0.00 464.00 1,000.00 46.4 51-000-62-00-5421 WEARING APPAREL 0.00 1, 439.14 5,500.00 26.1 51-000-62-00-5434 RENTAL - EQUIPMENT 0.00 0.00 1,000.00 0.0 51-000-62-00-5435 ELECTRICITY 7, 905.84 57, 671.90 170,000.00 33.9 51-000-62-00-5436 TELEPHONE 1, 969.24 13,766.19 20,000.00 68.8 51-000-62-00-5438 CELLULAR TELEPHONE 300.55 2, 194.28 5,500.00 39.8 TOTAL CONTRACTURAL SERVICES 10, 699.04 86, 314.30 283,000.00 30.4 PROFESSIONAL DEVELOPMENT 51-000-64-00-5600 DUES 0.00 649.00 1,000.00 64.9 51-000-64-00-5603 SUBSCRIPTIONS 0.00 42.25 250.00 16.9 51-000-64-00-5604 TRAINING & CONFERENCES 0.00 750.00 6,900.00 10.8 51-000-64-00-5605 TRAVEL EXPENSES 0.00 1, 123.44 2,000.00 56.1 TOTAL PROFESSIONAL DEVELOPMENT 0.00 2,564.69 10,150.00 25.2 OPERATIONS 51-000-65-00-5800 CONTINGENCIES 0.00 57.63 29,276.00 0.1 51-000-65-00-5804 OPERATING SUPPLIES 3,790.25 22, 606.49 44,000.00 51.3 51-000-65-00-5808 POSTAGE & SHIPPING 1,115.64 7,284.62 11,700.00 62.2 51-000-65-00-5809 PRINTING & COPYING 2, 108.00 5,015.75 5,000.00 100.3 51-000-65-00-5810 PUBLISHING & ADVERTISING 0.00 0.00 1,000.00 0.0 51-000-65-00-5812 GASOLINE 1, 580.92 6, 645.52 8,700.00 76.3 P31 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 32 TIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES OPERATIONS 51-000-65-00-5815 HAND TOOLS 0.00 86.00 1,000.00 8.6 51-000-65-00-5817 GRAVEL 0.00 462.12 5,000.00 9.2 51-000-65-00-5819 CHLORINE 0.00 0.00 0.00 0.0 51-000-65-00-5820 CHEMICALS 0.00 3,457.23 27,232.00 12.6 51-000-65-00-5821 CATHODIC PROTECTION 0.00 0.00 2,500.00 0.0 51-000-65-00-5822 WATER SAMPLES 1,450.00 5, 643.00 12,000.00 47.0 TOTAL OPERATIONS 10,044.81 51,258.36 147,408.00 34.7 RETIREMENT 51-000-72-00-6500 IMRF PARTICIPANTS 3,206.65 16,479.54 24,606.00 66.9 51-000-72-00-6501 SOCIAL SECURITY & MEDICARE 2,556.61 13,237.33 19,788.00 66.8 TOTAL RETIREMENT 5,763.26 29,716.87 44,394.00 66.9 CAPITAL OUTLAY 51-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 780.95 2,028.16 4,000.00 50.7 51-000-75-00-7004 SAFETY EQUIPMENT 0.00 274.00 2,000.00 13.7 51-000-75-00-7506 METER READERS 1, 185.75 9,355.70 10,320.00 90.6 51-000-75-00-7507 HYDRANT REPLACEMENT 4,807.00 7, 661.00 10,000.00 76.6 51-000-75-00-7508 METERS & PARTS 7,501.45 106, 628.34 130,000.00 82.0 TOTAL CAPITAL OUTLAY 14,275.15 125,947.20 156,320.00 80.5 OTHER 51-000-78-00-9005 REFUND 0.00 1,263.00 1,500.00 84.2 51-000-78-00-9008 RESERVE-H2O TOWER MAINTENANCE 0.00 0.00 21, 600.00 0.0 51-000-78-00-9009 RESERVE 0.00 0.00 1, 412, 681.00 0.0 TOTAL OTHER 0.00 1,263.00 1,435,781.00 0.0 TRANSFERS 51-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 100,000.00 200,000.00 50.0 51-000-99-00-9930 TRANSFER TO WATER IMPRV FUND 0.00 35,000.00 70,000.00 50.0 51-000-99-00-9950 TRANSFER TO PW EQUIP CAPITAL 0.00 25,000.00 50,000.00 50.0 P32 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 33 TIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL TRANSFERS 0.00 160,000.00 320,000.00 50.0 TOTAL EXPENSES: 73, 675.63 628,734.21 2, 659,518.00 23.6 TOTAL FUND REVENUES 184,264.14 2,366,300.78 2, 659,518.00 88.9 TOTAL FUND EXPENSES 73, 675.63 628,734.21 2, 659,518.00 23.6 FUND SURPLUS (DEFICIT) 110,588.51 1,737,566.57 0.00 100.0 P33 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 34 TIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: SEWER MAINTENANCE FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES --- UNDEFINED CODE --- 52-000-40-00-3999 CARRY OVER/FUND BALANCE 0.00 478,506.00 478,506.00 100.0 TOTAL --- UNDEFINED CODE --- 0.00 478,506.00 478,506.00 100.0 CHARGES FOR SERVICES 52-000-42-00-4250 SEWER MAINTENANCE FEES 70,049.05 270,888.44 350,000.00 77.3 52-000-42-00-4251 SEWER CONNNECTION FEES 5, 600.00 62, 650.00 96,800.00 64.7 TOTAL CHARGES FOR SERVICES 75, 649.05 333,538.44 446,800.00 74.6 INTEREST 52-000-46-00-4600 INVESTMENT INCOME 3,567.06 10,756.01 10,000.00 107.5 TOTAL INTEREST 3,567.06 10,756.01 10,000.00 107.5 TOTAL REVENUES: 79,216.11 822,800.45 935,306.00 87.9 EXPENSES PERSONNEL SERVICES 52-000-50-00-5108 SALARIES-REGULAR 13,171.80 69, 686.36 121,072.00 57.5 52-000-50-00-5136 PART TIME 512.00 512.00 5,000.00 10.2 52-000-50-00-5137 SALARIES-OVERTIME 1,230.75 5,143.88 12,000.00 42.8 TOTAL PERSONNEL SERVICES 14, 914.55 75, 342.24 138,072.00 54.5 CONTRACTUAL SERVICES 52-000-62-00-5401 CONTRACTUAL SERVICES 330.00 780.00 2,000.00 39.0 52-000-62-00-5408 MAINTENANCE-EQUIPMENT 15.66 1,259.98 8,500.00 14.8 52-000-62-00-5409 MAINTENANCE-VEHICLES 0.00 0.00 5,000.00 0.0 52-000-62-00-5419 MAINTENANCE-SANITARY SEWER 0.00 5,758.37 19,000.00 30.3 52-000-62-00-5421 WEARING APPAREL 288.04 2,099.37 4,500.00 46.6 52-000-62-00-5422 LIFT STATION MAINTENANCE 1,008.48 15,171.27 22,000.00 68.9 52-000-62-00-5434 RENTAL - EQUIPMENT 0.00 0.00 1,000.00 0.0 52-000-62-00-5435 ELECTRICITY 0.00 135.22 8,900.00 1.5 P34 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 35 TIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: SEWER MAINTENANCE FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES CONTRACTUAL SERVICES 52-000-62-00-5438 CELLULAR TELEPHONE 84.15 599.46 2,500.00 23.9 TOTAL CONTRACTUAL SERVICES 1,726.33 25,803.67 73,400.00 35.1 PROFESSIONAL DEVELOPMENT 52-000-64-00-5604 TRAINING & CONFERENCES 155.00 155.00 1, 900.00 8.1 TOTAL PROFESSIONAL DEVELOPMENT 155.00 155.00 1,900.00 8.1 OPERATIONS 52-000-65-00-5800 CONTINGENCIES 0.00 5, 382.00 10,000.00 53.8 52-000-65-00-5802 OFFICE SUPPLIES 0.00 483.28 2,000.00 24.1 52-000-65-00-5804 OPERATING SUPPLIES 0.00 1,106.94 8,000.00 13.8 52-000-65-00-5805 SHOP SUPPLIES 55.09 630.94 2,500.00 25.2 52-000-65-00-5812 GASOLINE • 1,788.37 8,342.42 9,500.00 87.8 52-000-65-00-5815 HAND TOOLS 0.00 59.74 1,000.00 5.9 52-000-65-00-5817 GRAVEL 0.00 0.00 2,000.00 0.0 52-000-65-00-5823 SEWER CHEMICALS 559.44 1, 396.24 8,000.00 17.4 TOTAL OPERATIONS 2,402.90 17,401.56 43,000.00 40.4 RETIREMENT 52-000-72-00-6500 IMRF PARTICIPANTS 1,450.32 7,321.55 13,217.00 55.3 52-000-72-00-6501 SOCIAL SECURITY & MEDICARE 1, 140.97 5, 601.31 10,423.00 53.7 TOTAL RETIREMENT 2, 591.29 12, 922.86 23, 640.00 54.6 CAPITAL OUTLAY 52-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 431.73 4,000.00 10.7 52-000-75-00-7003 OFFICE EQUIPMENT 0.00 2, 971.38 6,000.00 49.5 52-000-75-00-7004 SAFETY EQUIPMENT 0.00 23.16 2,000.00 1.1 TOTAL CAPITAL OUTLAY 0.00 3, 426.27 12,000.00 28.5 OTHER P35 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 36 TIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: SEWER MAINTENANCE FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES OTHER 52-000-78-00-9009 RESERVE 0.00 0.00 543,294.00 0.0 TOTAL OTHER 0.00 0.00 543,294.00 0.0 TRANSFERS 52-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 35,000.00 70,000.00 50.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 0.00 15,000.00 30,000.00 50.0 52-000-99-00-9965 TRANSFER TO DEBT SERVICE FUND 0.00 0.00 0.00 0.0 TOTAL TRANSFERS 0.•00 50,000.00 100,000.00 50.0 TOTAL EXPENSES: 21,790.07 185,051.60 935,306.00 19.7 TOTAL FUND REVENUES 79,216.11 822,800.45 935,306.00 87.9 TOTAL FUND EXPENSES 21,790.07 185,051.60 935,306.00 19.7 FUND SURPLUS (DEFICIT) 57,426.04 637,748.85 0.00 100.0 P36 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 37 TIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: LAND CASH FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CARRY OVER 72-000-40-00-3999 CARRY OVER/STARTING BALANCE 0.00 693, 912.00 693,912.00 100.0 72-000-40-00-4700 LAND CASH - OTHER 0.00 353.60 354.00 99.8 TOTAL CARRY OVER 0.00 694,265.60 694,266.00 99.9 CONTRIBUTIONS 72-000-47-00-4700 OSLAD GRANT 0.00 0.00 74,000.00 0.0 72-000-47-00-4701 GREENBRIAR-LAND CASH 0.00 2,142.00 5,355.00 40.0 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 4,725.00 4,725.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 769.00 8,959.00 15,380.00 58.2 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 7,758.00 3,000.00 258.6 72-000-47-00-4708 FOX HIGHLANDS DUPLEX-LAND CASH 0.00 14, 160.00 15,000.00 94.4 72-000-47-00-4709 SUNFLOWER-LAND CASH 361.00 13,792.00 15,000.00 91.9 72-000-47-00-4710 CIMMERON RIDGE-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4711 BLACKBERRY CREEK-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4712 RIVER'S EDGE-LAND CASH 671.00 17,446.00 20,130.00 86.6 72-000-47-00-4713 CANNONBALL HILLS-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4714 WOODWORTH-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4715 WHITE OAK UNIT 1&2-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4716 WHITE OAK UNIT 3&4-LAND CASH 0.00 1,406.00 1,406.00 100.0 72-000-47-00-4717 KYLN'S CROSSING-LAND CASH 0.00 2,493.00 3,000.00 83.1 72-000-47-00-4718 FOXFIELD(2ND EDITION)-LAND CAS 0.00 0.00 0.00 0.0 72-000-47-00-4719 WILDWOOD-LAND CASH 0.00 918.00 1,000.00 91.8 72-000-47-00-4720 HEARTLAND-LAND CASH 0.00 15,000.00 15,000.00 100.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 4, 155.00 44,874.00 50,000.00 89.7 72-000-47-00-4723 HEARTLAND CIRCLE-LAND CASH 5,000.00 20,000.00 30,000.00 66.6 72-000-47-00-4724 RAINTREE VILLAGE-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4725 WINDETTE RIDGE-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4726 RESERVE @ THE FOX LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4727 GRAND RESERVE-LAND CASH 0.00 45, 644.84 100,000.00 45.6 72-000-47-00-4728 BRISBEN RESERVE-LAND CASH 0.00 0.00 0.00 0.0 P37 )ATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 38 LIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ED: GL470002.WOW FUND: LAND CASH FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER 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 14,868.00 15,000.00 99.1 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) 0.00 0.00 25,000.00 0.0 72-000-47-00-4735 PRAIRIE MEADOWS (MENARD RES) 0.00 0.00 286,230.00 0.0 72-000-47-00-4736 CORNERSTONE 13,780.00 13,780.00 0.00 100.0 TOTAL CONTRIBUTIONS 29,461.00 227, 965.84 674,501.00 33.7 TOTAL REVENUES: 29,461.00 922,231.44 1,368,767.00 67.3 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 9,245.00 49,505.00 55,000.00 90.0 72-000-75-00-7300 GREENBRIAR 0.00 0.00 3,000.00 0.0 72-000-75-00-7301 FOX HILL 0.00 0.00 0.00 0.0 72-000-75-00-7302 COUNTRYHILLS 2, 115.50 122,839.71 125,000.00 98.2 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 90,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 2,232.79 141,329.74 150,000.00 94.2 72-000-75-00-7308 RIVERS EDGE PARK #2 0.00 0.00 10,000.00 0.0 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 543.00 11,539.19 120,000.00 9.6 P38 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 39 TIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: LAND CASH FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES CAPITAL OUTLAY 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 5,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 7,750.00 0.00 (100.0) 72-000-75-00-7326 CORLANDS 0.00 0.00 0.00 0.0 72-000-75-00-7327 GRANDE RESERVE PARK DEV. 2,018.98 36,361.09 100,000.00 36.3 72-000-75-00-7328 PRAIRIE MEADOWS (MENARDS RES) 0.00 0.00 5,000.00 0.0 72-000-75-00-7329 ELSIE LOUISE GILBERT PARK 0.00 993.75 60,000.00 1.6 72-000-75-00-7330 WHISPERING MEADOWS (K. HILL) 0.00 0.00 5,000.00 0.0 72-000-75-00-7331 WINDETT RIDGE 0.00 19,533.75 20,000.00 97.6 72-000-75-00-7700 PARK MAINTENANCE FACILITY 0.00 0.00 30,000.00 0.0 TOTAL CAPITAL OUTLAY 16,155.27 389,852.23 788,000.00 49.4 OTHER 72-000-78-00-9009 RESERVE 0.00 4,799.17 458,767.00 1.0 72-000-78-00-9010 BEECHER CONCESSION STAND 0.00 0.00 0.00 0.0 TOTAL OTHER 0.00 4,799.17 458,767.00 1.0 TRANSFERS 72-000-99-00-9955 TRANSFER TO PARKS/REC CAP FUND 22,000.00 22,000.00 22,000.00 100.0 72-000-99-00-9970 TRANSFER TO LAND ACQUISITION 0.00 50,000.00 100,000.00 50.0 TOTAL TRANSFERS 22,000.00 72,000.00 122,000.00 59.0 P39 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 40 TIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: LAND CASH FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL EXPENSES: 38,155.27 466, 651.40 1,368,767.00 34.0 TOTAL FUND REVENUES 29,461.00 922,231.44 1,368,767.00 67.3 TOTAL FUND EXPENSES 38, 155.27 466, 651.40 1,368,767.00 34.0 FUND SURPLUS (DEFICIT) (8,694 .27) 455,580.04 0.00 100.0 P40 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 41 TIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: LAND ACQUISITION FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CARRY OVER 73-000-40-00-3999 CARRY OVER BALANCE 0.00 14,078.00 14,078.00 100.0 73-000-40-00-4930 COLT FUNDING 0.00 0.00 100,000.00 0.0 TOTAL CARRY OVER 0.00 14,078.00 114,078.00 12.3 TRANSFERS 73-000-49-00-4935 TRANSFER FROM LAND CASH 0.00 50,000.00 100,000.00 50.0 73-000-49-00-4937 TRANSFER FROM PARKS & REC 0.00 0.00 0.00 0.0 TOTAL TRANSFERS 0.00 50,000.00 100,000.00 50.0 TOTAL REVENUES: 0.00 64,078.00 214,078.00 29.9 EXPENSES OTHER 73-000-65-00-5800 CONTINGENCY 0.00 560.00 214,078.00 0.2 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 560.00 214,078.00 0.2 TOTAL FUND REVENUES 0.00 64,078.00 214,078.00 29.9 TOTAL FUND EXPENSES 0.00 560.00 214,078.00 0.2 FUND SURPLUS (DEFICIT) 0.00 63,518.00 0.00 100.0 P41 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 42 DIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CARRY OVER 79-000-40-00-3999 CARRY OVER BALANCE 0.00 25,857.00 25,857.00 100.0 TOTAL CARRY OVER 0.00 25,857.00 25,857.00 100.0 CHARGES FOR SERVICES 79-000-42-00-4270 FEES FOR PROGRAMS 13,526.00 108,189.76 155, 125.00 69.7 79-000-42-00-4280 CONCESSIONS 0.00 9,004.50 10,000.00 90.0 79-000-42-00-4281 BEECHER BLDG DEPOSITS 450.00 3,170.00 3,500.00 90.5 79-000-42-00-4282 FARMERS MARKET 0.00 955.00 1,000.00 95.5 79-000-42-00-4285 VENDING MACHINE INCOME 0.00 536.36 650.00 82.5 79-000-42-00-4286 RENTAL INCOME 205.00 3,520.00 3,000.00 117.3 79-000-42-00-4287 RENTAL INCOME - SHELTERS 0.00 560.00 600.00 93.3 79-000-42-00-4288 GOLF OUTING REVENUE 0.00 36,251.00 36,251.00 100.0 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 14, 181.00 162,186.62 210,126.00 77.1 MISCELLANEOUS 79-000-44-00-4400 DONATIONS 900.00 11,120.00 12,000.00 92.6 79-000-44-00-4404 TREE DONATIONS 0.00 300.00 750.00 40.0 79-000-44-00-4490 MISCELLANEOUS INCOME 100.00 100.00 0.00 100.0 TOTAL MISCELLANEOUS 1,000.00 11,520.00 12,750.00 90.3 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 3,500.00 28.5 TOTAL INTERGOVERNMENTAL 1,000.00 1,000.00 3,500.00 28.5 INTEREST 79-000-46-00-4600 INVESTMENT INCOME 285.98 1,429.08 1,500.00 95.2 TOTAL INTEREST 285.98 1,429.08 1,500.00 95.2 P42 )ATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 43 LIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ED: GL470002.W0W FUND: PARKS & RECREATION FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TRANSFERS 79-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 504,330.66 794,036.00 63.5 TOTAL TRANSFERS 0.00 504,330.66 794,036.00 63.5 TOTAL REVENUES: 16, 466.98 706,323.36 1,047,769.00 67.4 PARKS EXPENSES PERSONNAL SERVICES 79-610-50-00-5107 SALARIES-EMPLOYEES 23,597.33 157,342.49 272,176.00 57.8 79-610-50-00-5136 SALARIES - PART-TIME 0.00 35,885.13 45,000.00 79.7 79-610-50-00-5137 SALARIES - OVERTIME 1,074.19 5,203.40 8,000.00 65.0 TOTAL PERSONNAL SERVICES 24, 671.52 198,431.02 325, 176.00 61.0 PROFESSIONAL SERVICES 79-610-61-00-5320 MASTER PLAN 0.00 7,218.00 10,000.00 72.1 TOTAL PROFESSIONAL SERVICES 0.00 7,218.00 10,000.00 72.1 CONTRACTUAL SERVICES 79-610-62-00-5405 PARK CONTRACTUAL 0.00 9,738.22 10,000.00 97.3 79-610-62-00-5408 MAINTENANCE-EQUIPMENT 94.16 3,894.64 5,000.00 77.8 79-610-62-00-5417 MAINTENANCE-PARKS 38.81 22,067.13 30,000.00 73.5 79-610-62-00-5421 WEARING APPAREL 0.00 1, 153.60 5,000.00 23.0 79-610-62-00-5425 ILLINOIS FIRST GRANT 0.00 0.00 0.00 0.0 79-610-62-00-5434 RENTAL-EQUIPMENT 925.76 1,475.99 1,500.00 98.3 79-610-62-00-5438 CELLULAR TELEPHONE 444.30 1,115.61 4,000.00 27.8 79-610-62-00-5440 LAND DEVELOPER 2,222.43 22,097.76 23,500.00 94.0 79-610-62-00-5445 LEGAL EXPENSES 200.00 1,297.50 4,000.00 32.4 TOTAL CONTRACTUAL SERVICES 3,925.46 62,840.45 83,000.00 75.7 PROFESSIONAL DEVELOPMENT P43 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 44 TIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL $ ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED PARKS EXPENSES PROFESSIONAL DEVELOPMENT 79-610-64-00-5602 PROFESSIONAL GROWTH/SUBSCRPT 0.00 1,555.00 2,500.00 62.2 79-610-64-00-5605 TRAVEL EXPENSE 51.80 1,767.18 2,000.00 88.3 79-610-64-00-5612 CONTINUING EDUCATION 0.00 958.60 3,000.00 31.9 TOTAL PROFESSIONAL DEVELOPMENT 51.80 4,280.78 7,500.00 57.0 OPERATIONS 79-610-65-00-5800 CONTINGENCIES 0.00 0.00 0.00 0.0 79-610-65-00-5802 OFFICE SUPPLIES 333.50 550.57 1,000.00 55.0 79-610-65-00-5804 OPERATING SUPPLIES (252.79) 10,936.88 20,000.00 54.6 79-610-65-00-5812 GASOLINE 0.00 0.00 2,000.00 0.0 79-610-65-00-5815 HAND TOOLS 97.30 1,312.61 2,000.00 65.6 79-610-65-00-5824 CHRISTMAS DECORATIONS 0.00 23.76 4,000.00 0.5 79-610-65-00-5825 PUBLIC DECORATION 0.00 111.38 2,000.00 5.5 TOTAL OPERATIONS 178.01 12,935.20 31,000.00 41.7 RETIREMENT 79-610-72-00-6500 IMRF PARTICIPANTS 2,484.40 16,290.95 26,678.00 61.0 79-610-72-00-6501 SOCIAL SECURITY/MEDICARE 1,887.36 15,187.83 25,000.00 60.7 TOTAL RETIREMENT 4,371.76 31,478.78 51, 678.00 60.9 CAPITAL OUTLAY 79-610-75-00-7003 OFFICE EQUIPMENT 0.00 0.00 27,000.00 0.0 79-610-75-00-7701 FLOWERS/TREES 119.60 4,295.53 5,500.00 78.1 79-610-75-00-7705 TRANSFER TO LAND ACQUISITION 0.00 0.00 0.00 0.0 TOTAL CAPITAL OUTLAY 119.60 4,295.53 32,500.00 13.2 TOTAL EXPENSES: PARKS 33,318.15 321,479.76 540,854.00 59.4 RECREATION EXPENSES P44 )ATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 45 LIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ED: GL470002.WOW FUND: PARKS & RECREATION FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED 2ECREATION PERSONNEL SERVICES 79-650-50-00-5107 EMPLOYEE SALARIES 27, 501.06 145,587.78 212,971.00 68.3 79-650-50-00-5108 CONCESSION STAFF 0.00 4,253.66 5,000.00 85.0 79-650-50-00-5150 SALARIES-INSTRUCTOR CONTRACTUA 13, 669.76 56,869.49 80,800.00 70.3 79-650-50-00-5155 SALARIES-RECORDING SECRETARY 124.00 1,392.75 3,000.00 46.4 79-650-50-00-5156 SALARIES-CUSTODIAL 0.00 0.00 0.00 0.0 TOTAL PERSONNEL SERVICES 41,294.82 208,103.68 301,771.00 68.9 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 321.50 2, 620.17 6,500.00 40.3 79-650-62-00-5409 MAINTENANCE-VEHICLES 0.00 0.00 1,000.00 0.0 79-650-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 0.00 3,064.30 5,000.00 61.2 79-650-62-00-5426 YOUTH SERVICES GRANT EXPENSES 108.00 108.00 3,000.00 3.6 79-650-62-00-5437 TELEPHONE/INTERNET 0.00 495.93 827.00 59.9 79-650-62-00-5438 CELLULAR TELEPHONE 440.09 1,053.00 3,500.00 30.0 79-650-62-00-5445 PORTABLE TOILETS 0.00 2,880.39 4,000.00 72.0 79-650-62-00-5603 PUBLISHING/ADVERTISING 0.00 19,355.67 24,000.00 80.6 79-650-62-00-5605 BOOKS/PUBLICATIONS 0.00 84.50 750.00 11.2 79-650-62-00-5606 BEECHER DEPOSIT REFUND 50.00 5,814.00 6,000.00 96.9 TOTAL CONTRACTUAL SERVICES 919.59 35, 475.96 54,577.00 65.0 PROFESSIONAL DEVELOPMENT 79-650-64-00-5600 DUES 700.00 1,047.50 2, 500.00 41.9 79-650-64-00-5602 PROFESSIONAL GROWTH/SUBSCRIPT 365.00 4,302.98 7,300.00 58.9 79-650-64-00-5605 TRAVEL EXPENSE 0.00 547.93 2,000.00 27.3 79-650-64-00-5614 TOURNAMENT FEES 0.00 0.00 0.00 0.0 TOTAL PROFESSIONAL DEVELOPMENT 1,065.00 5,898.41 11,800.00 49.9 OPERATIONS P45 )ATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 46 LIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 [D: GL470002.WOW FUND: PARKS & RECREATION FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED RECREATION 3XPENSES OPERATIONS 79-650-65-00-5800 CONTINGENCIES 0.00 0.00 0.00 0.0 79-650-65-00-5802 OFFICE SUPPLIES 568.87 3,175.90 6,000.00 52.9 79-650-65-00-5803 PROGRAM EXPENSES 594.62 22, 456.45 37,810.00 59.3 79-650-65-00-5804 OPERATING SUPPLIES 254.08 1,151.85 3,000.00 38.3 79-650-65-00-5805 RECREATION EQUIPMENT 0.00 1,405.77 2,500.00 56.2 79-650-65-00-5808 POSTAGE & SHIPPING 0.00 2, 989.68 4,000.00 74.7 79-650-65-00-5812 GASOLINE 59.24 627.75 800.00 78.4 79-650-65-00-5826 MILEAGE 0.00 238.77 750.00 31.8 79-650-65-00-5827 GOLF OUTING EXPENSES 0.00 19, 166.05 19, 166.00 100.0 79-650-65-00-5828 CONCESSIONS 0.00 8,835.82 10,500.00 84.1 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 170.00 1,500.00 11.3 79-650-65-00-5841 PROGRAM REFUND 374.00 5,147.53 6,500.00 79.1 TOTAL OPERATIONS 1,850.81 65,365.57 92,526.00 70.6 RETIREMENT 79-650-72-00-6500 IMRF PARTICIPANTS 2, 601.87 13,349.98 19,101.00 69.8 79-650-72-00-6501 SOCIAL SECURITY/MEDICARE 2,635.06 14,320.87 21,500.00 66.6 TOTAL RETIREMENT 5, 436.93 27, 670.85 40,601.00 68.1 CAPITAL OUTLAY 79-650-75-00-7002 COMPUTER EQUIP & SOFTWARE 329.95 4,177.49 5,640.00 74.0 TOTAL CAPITAL OUTLAY 329.95 4,177.49 5, 640.00 74.0 TOTAL EXPENSES: RECREATION 50,897.10 346, 691.96 506, 915.00 68.3 TOTAL FUND REVENUES 16,466.98 706,323.36 1,047,769.00 67.4 TOTAL FUND EXPENSES 84,215.25 668,171.72 1,047,769.00 63.7 FUND SURPLUS (DEFICIT) (67,748.27) 38,151.64 0.00 100.0 P46 )ATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 47 CIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 [D: GL470002.WOW FUND: LIBRARY FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED 2EVENUES TAXES 82-000-40-00-3996 CARRY OVER - BOOK DEV FEES 0.00 57, 646.00 57, 646.00 100.0 82-000-40-00-3997 CARRY OVER - BLDG DEV FEES 0.00 30, 445.00 30,445.00 100.0 82-000-40-00-3998 CARRY OVER-MEMORIALS 0.00 5,362.00 5,362.00 100.0 82-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 72,847.00 0.0 82-000-40-00-4000 REAL ESTATE TAXES 0.00 291,713.25 301, 915.00 96.6 82-000-40-00-4010 PERSONAL PROPERTY TAX 9, 139.99 11,259.75 2,500.00 450.3 82-000-40-00-4015 TRANSFER FROM GENERAL FUND 0.00 0.00 26,249.00 0.0 TOTAL TAXES 9,139.99 396,426.00 496,964.00 79.7 CHARGES FOR SERVICES 82-000-42-00-4211 DEVELOPMENT FEES - BUILDING 0.00 25, 925.00 67,000.00 38.6 82-000-42-00-4215 DEVELOPMENT FEES-BOOKS 0.00 25, 925.00 67,000.00 38.6 82-000-42-00-4260 COPY FEES 70.10 751.75 900.00 83.5 82-000-42-00-4261 LIBRARY SUBSCRIPTION CARDS 600.00 6,800.00 8,000.00 85.0 82-000-42-00-4286 RENTAL INCOME 64.00 605.00 1,000.00 60.5 TOTAL CHARGES FOR SERVICES 734.10 60,006.75 143,900.00 41.7 FINES 82-000-43-00-4330 LIBRARY FINES 241.05 2,155.55 3,000.00 71.8 TOTAL FINES 241.05 2,155.55 3,000.00 71.8 MISCELLANEOUS 82-000-44-00-4432 SALE OF BOOKS 65.70 787.57 500.00 157.5 82-000-44-00-4450 MEMORIALS 4, 100.00 5,993.60 1,500.00 399.5 TOTAL MISCELLANEOUS 4,165.70 6,781.17 2,000.00 339.0 INTERGOVERNMENTAL 82-000-45-00-4560 LIBRARY PER CAPITA GRANT 0.00 0.00 7,700.00 0.0 TOTAL INTERGOVERNMENTAL 0.00 0.00 7,700.00 0.0 P47 )ATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 48 'IME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 CD: GL470002.WOW FUND: LIBRARY FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED INTEREST 82-000-46-00-4600 INVESTMENT INCOME 878.36 896.95 1,500.00 59.7 82-000-46-00-4601 INVESTMENT INCOME-BLDG 213.89 1,088.65 1,250.00 87.0 TOTAL INTEREST 1,092.25 1, 985.60 2,750.00 72.2 TOTAL REVENUES: 15,373.09 467,355.07 656,314.00 71.2 "EXPENSES PERSONNEL SERVICES 82-000-50-00-5107 SALARIES-EMPLOYEES 15,834 .58 96,174 .03 200,000.00 48.0 82-000-50-00-5203 GROUP HEALTH INSURANCE 0.00 17,561.76 45,000.00 39.0 82-000-50-00-5204 GROUP LIFE INSURANCE 0.00 489.78 1,500.00 32.6 82-000-50-00-5205 DENTAL & VISION ASSISTANCE 0.00 1,772.42 4,000.00 44.3 TOTAL PERSONNEL SERVICES 15,834.58 115,997.99 250,500.00 46.3 PROFESSIONAL SERVICES 82-000-61-00-5300 LEGAL SERVICES 0.00 0.00 0.00 0.0 82-000-61-00-5322 BONDING 0.00 633.00 2,000.00 31.6 82-000-61-00-5323 ATTORNEY 0.00 0.00 3,000.00 0.0 TOTAL PROFESSIONAL SERVICES 0.00 633.00 5,000.00 12.6 CONTRACTUAL SERVICES 82-000-62-00-5401 CONTRACT SERVICES 55.00 200.00 3,000.00 6.6 82-000-62-00-5407 MAINTENANCE-BLDG/JANITORIAL 347.42 2,307.42 5,000.00 46.1 82-000-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 0.00 1, 145.13 3,000.00 38.1 82-000-62-00-5412 MAINTENANCE-PHOTOCOPIER 48.52 107.57 1,000.00 10.7 82-000-62-00-5435 ELECTRICITY 85.94 274.29 2,500.00 10.9 82-000-62-00-5436 TELEPHONE 190.25 751.21 1,700.00 44.1 TOTAL CONTRACTUAL SERVICES 727.13 4,785.62 16,200.00 29.5 PROFESSIONAL DEVELOPMENT 82-000-64-00-5603 SUBSCRIPTIONS 1,502.94 1,806.93 4,000.00 45.1 P48 )ATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 49 LIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ED: GL470002.WOW FUND: LIBRARY FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES PROFESSIONAL DEVELOPMENT - 82-000-64-00-5604 TRAINING & CONFERENCES 0.00 70.00 1,500.00 4 .6 82-000-64-00-5607 PUBLIC RELATIONS 0.00 261.30 1,000.00 26.1 82-000-64-00-5616 EMPLOYEE RECOGNITION 0.00 822.44 2,000.00 41.1 TOTAL PROFESSIONAL DEVELOPMENT 1, 502.94 2,960.67 8,500.00 34.8 OPERATIONS 82-000-65-00-5800 CONTINGENCIES 0.00 242.25 12,411.00 1.9 82-000-65-00-5806 LIBRARY SUPPLIES 791.67 4,277.48 8,000.00 53.4 82-000-65-00-5807 CUSTODIAL SUPPLIES 637.56 1, 609.48 6,000.00 26.8 82-000-65-00-5808 POSTAGE & SHIPPING 111.00 222.00 1,000.00 22.2 82-000-65-00-5810 PUBLISHING & ADVERTISING 14.50 52.60 1,000.00 5.2 82-000-65-00-5826 MILEAGE 76.00 282.25 1,000.00 28.2 82-000-65-00-5832 VIDEOS 39.26 167.68 5,500.00 3.0 82-000-65-00-5833 ALARM MONITORING 42.90 691.44 1,000.00 69.1 82-000-65-00-5834 LIBRARY PROGRAMMING 366.62 3,595.87 10,000.00 35.9 82-000-65-00-5835 LIBRARY BOARD EXPENSES 0.00 0.00 1,000.00 0.0 82-000-65-00-5836 BOOKS-ADULT 32.99 3, 437.49 11,000.00 31.2 82-000-65-00-5837 BOOKS-JUVENILE 0.00 5,284 .86 11,000.00 48.0 82-000-65-00-5838 BOOKS-AUDIO 177.10 1, 628.40 11,000.00 14.8 82-000-65-00-5839 BOOKS-REFERENCE 378.00 4, 417.98 12,000.00 36.8 82-000-65-00-5840 BOOKS-DEVELOPMENT FEE 5, 681.47 22, 610.28 124, 646.00 18.1 82-000-65-00-5841 MEMORIALS/GIFTS 383.47 1, 635.69 6,862.00 23.8 82-000-65-00-5842 BLDG-DEVELOPMENT FEES 0.00 5,771.30 98, 695.00 5.8 TOTAL OPERATIONS 8,732.54 55, 927.05 322,114.00 17.3 RETIREMENT 82-000-72-00-6500 IMRF PARTICPANTS 991.86 5, 932.95 9,000.00 65.9 82-000-72-00-6501 SOCIAL SECURITY/MEDICARE 1,211.31 7,357.11 15,000.00 49.0 TOTAL RETIREMENT 2,203.17 13,290.06 24,000.00 55.3 CAPITAL OUTLAY 82-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 0.00 0.00 0.0 P49 )ATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 50 ['IME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ED: GL470002.WOW FUND: LIBRARY FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES CAPITAL OUTLAY 82-000-75-00-7003 AUTOMATION 1,971.92 7,849.24 30,000.00 26.1 82-000-75-00-7703 BUILDING EXPANSION 0.00 0.00 0.00 0.0 TOTAL CAPITAL OUTLAY 1,971.92 7,849.24 30,000.00 26.1 TOTAL EXPENSES: 30,972.28 201,443.63 656,314.00 30.6 TOTAL FUND REVENUES 15,373.09 467,355.07 656,314.00 71.2 TOTAL FUND EXPENSES 30, 972.28 201,443.63 656,314.00 30.6 FUND SURPLUS (DEFICIT) (15,599.19) 265,911.44 0.00 100.0 P50 )ATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 51 PINE: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: FOX INDUSTRIAL FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES TAXES 85-000-40-00-3999 CARRY OVER BALANCE 0.00 34,852.00 34,852.00 100.0 85-000-40-00-4090 TIF REVENUES 527.53 32, 485.84 34,068.00 95.3 TOTAL TAXES 527.53 67,337.84 68,920.00 97.7 INTEREST 85-000-46-00-4600 INVESTMENT INCOME 110.27 610.86 1,000.00 61.0 TOTAL INTEREST 110.27 610.86 1,000.00 61.0 TRANSFERS 85-000-49-00-4905 TRANSFER FROM MFT FUND 0.00 0.00 9,587.00 0.0 TOTAL TRANSFERS 0.00 0.00 9,587.00 0.0 TOTAL REVENUES: 637.80 67, 948.70 79,507.00 85.4 EXPENSES DEBT SERVICES 85-000-66-00-6021 FOX IND BOND-PRINCIPAL PMT 0.00 55,000.00 55,000.00 100.0 85-000-66-00-6022 FOX IND BOND-INT PAYMENT 0.00 24,292.50 24,293.00 99.9 TOTAL DEBT SERVICES 0.00 79,292.50 79,293.00 99.9 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 488.25 0.00 (100.0) TOTAL OTHER 0.00 702.25 214.00 328.1 P51 DATE: 02/02/2005 UNITED CITY OF YORKVILLE PAGE: 52 TIME: 16:49:43 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: FOX INDUSTRIAL FOR 8 PERIODS ENDING DECEMBER 31, 2004 FISCAL FISCAL % ACCOUNT DECEMBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL EXPENSES: 0.00 79,994.75 79,507.00 100.6 TOTAL FUND REVENUES 637.80 67, 948.70 79,507.00 85.4 TOTAL FUND EXPENSES 0.00 79,994.75 79,507.00 100.6 FUND SURPLUS (DEFICIT) 637.80 (12,046.05) 0.00 100.0 P52 Go Results of Benefits Meeting / 49 Employees Attended 44 Surveys Received Question#1 Based on the presentation, at what level would you support the proposed Dental/Vision Plan? Strongly Support Somewhat Support Neutral Do Not Support 35/44 5/44 4/44 0/44 80% Strongly Support 35 DENTALNISION PLAN 35� 30.Y 25-" 20Y 15-" 10-" 5 4 5f 0 0 Strongly Support Somewhat Neutral Do not Support Support EMPLOYEES LEVEL OF SUPPORT Comments: "This is a better plan than what we now have" "The new Dental/Vision Plan is much better then the old one" "I'm already out money for the reimbursement" "Added Benefit to the employees" "Similar to what was looked at a few years ago wish we'd have done it then" "The coverage seems good and I like that we are able to go to our own doctor" "I would like to have it rollover to a maximum as it is now not just a cap of$1,000 for a year" "It sounds good because if it is true we will have the same service available at less cost" "The city needs a better plan then what we have" "The vision and dental plans are very good" Question#2 Based on the presentation, at what level would you support the proposed HSA Plans? Strongly Support Somewhat Support Neutral Do Not Support No Response 22/44 4/44 12/44 5/44 1/44 50% Strongly Support HEALTH CARE SPENDING ACCOUNTS 25-z 22 20-/ 15� 12 10-' 4 5 5- 0 Strongly Somewhat Neutral Do not No Response Support Support Support EMPLOYEES LEVEL OF SUPPORT Comments: "I don't think I need this at this time, maybe later" "It seems like a way to save at least a little money on things" "Used a plan like this at my previous employer" "Explained Well" "It's great to save on taxable income, I especially like the card system idea" "Also wish this was already in place" "Not sure if it's right for me personally but for a family with more kids it sounds good" "I would like the option" "In particular, I like the FSA for Chiropractic spending-treatments and massage" "It seems like a good idea I would like to look at the website" Question #3 Given the fact the HSA is a voluntary employee benefit would this be something you would consider participating in? Yes No No Response 29/44 1144 4/44 66% Would Participate HEALTH CARE SPENDING ACCOUNTS 29 30-7 257 0- 257 20-7 15-7' 77 10-V— 4 0 Yes No No Response WOULD EMPLOYEES CONSIDER PARTICIPATING? Department Attendance Park 4/4 100% Attendance Administration 9/9 100%Attendance Police Department 18/26 69%Attendance Streets 2/4 50% Attendance Engineering 5/5 100%Attendance Water 6/6 100%Attendance Sewer 2/2 100%Attendance Library 3/3 100%Attendance Recreation 6/6 100%Attendance DENTAL COVERAGE - MONTHLY EMPLOYEE 13 x $23.06 = $299.78 EMPLOYEE +1 16 x $46.20 = $739.20 FAMILY 35 x $85.74 = $3,000.90 VISION COVERAGE - MONTHLY EMPLOYEE 13 x $5.34 = $69.42 EMPLOYEE +1 16 x $7.74 = $123.84 FAMILY 35 x $13.88 = $485.80 TOTAL MONTHLY COST 64 EMPLOYEES = $4,718.94 TOTAL ANNUAL COST 64 EMPLOYEES = $56,627.28 4'1-i UNITED CITY OF YORKVILLE SALARY COMPARISION SURVEY FOR Public Works Director Prepared by T. Graff 2/1/05 Town Name Public Works Director Low Actual High Cary $71,052 $83,976 $84,156 Chanahon $76,092 Elburn $51,000 $64,720 $71,000 Huntley $59,292 $83,640 $83,640 Lockport $54,996 $71,772 $74,244 Minooka $75,240 $78,500 McHenry $70,404 $72,974 $92,328 Montgomery $64,164 $79,585 $87,324 New Lenox $83,844 North Aurora $73,560 Plainfield $67,252 $82,687 $93,712 Plano $64,992 $75,000 $79,992 Oswego $67,294 $74,096 $93,176 Shorewood $62,496 South Elgin $76,524 $83,556 $89,400 Sugar Grove $56,779 $61,961 $68,135 Sycamore $60,000 $75,000 $75,000 Yorkville* $56,900 $70,096 $76,186 AVERAGES $62,972 $74,764 $82,204 Yorkville Compared to -10% -6% -7% Average *Comparison purpose only not included within the salary average calculations UNITED CITY OF YORKVILLE SALARY SCHEDULES Approved 1/25/05 FY 2004-2005 Min. Max. City Administrator $76,004 $107,023 Finance Director $59,175 $83,325 City Engineer $59,760 $84,150 Engineering Tech $37,260 $53,524 Receptionist/Assistant $20,800 $27,967 Administrative Support Staff $32,085 $43,675 General Support Staff $26,910 $42,820 Chief of Police $65,078 $86,916 Police Office Supervisor $34,096 $48,172 Police Lieutenant $53,652 $72,200 Police Sergeant $46,506 $62,088 Police Officers **(Per Contract) $38,473 $47,516 Director of Public Works $62,972 $82,204 Foreman (Street/Water/Park) $45,550 $59,989 Maintenance Worker I $29,900 $41,749 Maintenance Worker II $34,155 $47,101 Operator $39,330 $52,454 Janitorial Tool Shop $23,805 $34,256 Executive Director- Parks & Rec $61,300 $86,319 Superintendent of Recreation $42,106 $59,291 Recreation Supervisor $32,085 $51,383 The salary range is subject to review and can be modified annually by Mayor & City Council. Annual Longevity Stipends will be made to all employees based upon the following chart: After 6 years but less than 9 years $750 After 9 years but less than 14 years $1,000 After 14 years but less than 20 years $1,250 After 20 years but less than 25 years $1,500 After 25 years $2,000 Educational Stipends will be paid for education in their related field over that required for entry level of that position as follows: Associate Degree or 60 credit hours 2% Bachelor's Degree 2% Master's Degree 2% This will be applicable only to 1 degree level beyond that necessary for entry level of that position except that all are eligible to earn up to the Bachelor Degree Level as outlined above (one time salary adjustment) 2`.c,00 cii.k. United City of Yorkville Memo '" 800 Game Farm Road EST.lZw. imrui.1836 Yorkville, Illinois 60560 ,� Telephone: 630-553-4350 Il �11 L — p Fax: 630-553-7575 SCE � '� Date: February 1, 2005 To: Administration Committee From: Tony Gr rty Admilii'strato CC: Tim Fairfield, BKFD Asst. Chief, Mayor Prochaska& Dept. Heads Subject: Building Permit Fee Waiver Request by Bristol Kendall Fire Protection District I received a request by the Bristol Kendall Fire Protection District on January 21, 2005 asking for consideration of three (3) items. Here is the department heads response to their request for your consideration and review. #1. The Public Works Department is recommending metering the connection for the filling up of the water tanks,however,no charge for the water usage. The City needs to account for all water usage that is why the Water Department is requesting to meter the connection. #2. The request for parking in the front yard set back needs to have a formal request to be filed for a variance. Bill Dettmer will assist the District with this request. #3. The third request is to reduce or eliminate any fees associated with building their new facility on Kennedy Road&McHugh Road. In the past the City has waived the city portion of the fee however, any out of pocket expense the District would have to pay. Also,the District would pay for the actual cost for the water meters. Any further questions regarding this summary please contact me. Attachment: BKDF Request Letter dated 1/21/2005 N6 4'1 - Bristol Kendall Fire Department 103 East Beaver Street Yorkville, IL 60560-1704 •` • • Phone: 630 553-6186 Fax: 630 553-1482 January 21, 2005 Anton Graff, City Administrator 800 Game Farm Road Yorkville, IL 60560 Dear Mr. Graff; The Fire District would like an opinion on the following items from the United City of Yorkville. 1. In our current station on Beaver Street, the city allowed us to have a separate connection prior to the water meter for filling the water tanks on our vehicles. Will this be allowed in the proposed station 2? 2. We currently are showing 3 parking stalls in the front of our station, on the North side of the truck apron. These are intended to be used in case of somebody coming to the station in an emergency. This would allow them a place to park, instead of blocking the truck bay doors. Will this be allowed by the city? 3. Would the city consider eliminating or reducing any of the fees associated with building our station, for permits, reviews etc.? Thank you in advance for your consideration of the above mentioned items. If you have any questions please feel free to contact me. Sincer ly, Timothy Fairfield Assistant Chief CC: Chief Hitzemann N6 -01 2221 Camden Court,Suite 300 Crowe Chizek and Company LLC Oak Brook,Illinois 60523 Member Horwath International Tel 630.574.1040 Fax 630.574.8313 www.crowechizek.com January 17,2005 Ms. Traci Pleckham Director of Finance United City of Yorkville 800 Game Farm Road Yorkville,Illinois 60560 Dear Traci: Per your request I am providing this informal quote to perform the fiscal year 2005 audit of the United City of Yorkville ("City"). As you know effective January 1, 2005 PTW & Co. combined practices with Crowe Chizek and Company LLC. This combination will not result in a change in your engagement team that you have worked with in the past. Our audit fees will be as follows: Annual Audit of the City and Police Pension Fund Financial Statements Including Preparation of the State of Illinois AFR for the City $26,500 Our fee assumes that we will be provided with auditable trial balances for all funds at year end,that all bank accounts and investment accounts will be reconciled through the end of the year being audited to the trial balances, that interfund and transfer accounts will balance,that subsidiary ledgers (i.e. Utility Billing) will reconcile to the general ledger, that beginning fund equity amounts will be reconcilable to prior year audited ending fund equity and that the City will prepare all year end expense/expenditure accruals for reporting on the modified accrual basis of accounting. We as auditors will assist the City in recording revenue accruals on the modified accrual basis of accounting and full-accrual entries to the City's accounts in order to prepare government-wide financial statements in accordance with GASB Statement No. 34. We assume that the City will cooperate with our requests for information such as explanations of account activity. Additionally, we assume the City will provide a copy of the capital assets ledger including current year additions and dispositions and depreciation by functional expense. We assume that requested records such as invoices, contracts, grant agreements and supporting documentation will be located and provided to us. We also assume the City will prepare confirmation letters and the MD&A section of the report. Our fee does not include implementation of any other future accounting or auditing pronouncements and/or government requirements that may change,thus,the scope or amount of auditing necessary to complete our engagements may increase beyond what is currently anticipated. Should such events occur, we would present you with our estimate of any possible increase prior to beginning our audit for the given year. An equitable adjustment in the proposed fee will be negotiated if the cost of time required for performance of the audit service is increased or decreased pursuant to a change in scope of the audit requested by the City or required by State or Federal regulations. Finally, our fees do not include the following: • Single Audit(if required) • TIF Compliance Audits(if required) • Recording of Pension Fund Activity to the General Ledger • Preparation of Police Pension IDOI Report If the year end expense/expenditure accruals are not booked by the City then our fee will increase to $28,700. Traci, I look forward to continuing our relationship and please call with any questions. Sincerely, .17 e John C. Weber Executive 4til iv 2`.cEv CO., City of Yorkville Memo e ,: ,, '" 800 Game Farm Road '' 1836 Yorkville, Illinois 60560 -��� Telephone: 630-553-4350 4 h' la— g Fax: 630-553-7575 4LE ‘01 ' L Date: Q /51 Zoo 5 / To: AA/vi;n `) Avt (OM r #ee- From: 'Kid 015 , (1m%o 91rn-;ve ii4JPci Agenda Item: Oiul C g ,J wa s not available`at the time packets were produced. This item will be available Fed r'Utt vYZ� d and distributed in a supplemental packet.Y .cEo co.)._ ir o United City of Yorkville Memo • "° 800 Game Farm Road EST "-�-es*18361 Yorkville, Illinois 60560 Telephone: 630-553-4350 4 1. L aas. g Fax: 630-553-7575 NLE 0") Date: February 2, 2005 To: Mayor and Administration Committee From: Lisa Pickering CC: Department Heads Subject: Additional information for Administration Committee packets—February 3, 2005 Attached please find information on New Business Item#4—City Planner/Organizational Charts. Please add this information to your packet. =`,4Ev Cirto United City of Yorkville Memo 800 Game Farm Road est% 1836 Yorkville, Illinois 60560 ,� Telephone: 630-553-4350 P $9.' Fax: 630-553-7575 Date: February 2, 2005 To: Administration Committee From: Bart Olson CC: Tony Graff, Art Prochaska Subject: FY 05/06 Org Chart and Proposed Hires Here is a synopsis of the proposed new hires and hierarchy realignments for the Administration, Finance, and Community Development Departments for FY 05/06: A) 6 Total Hires or Changed Positions of which: 1) 1 Current PT position changing to FT a) Accounting Clerk I 2) 4 New Positions a) Assistant to the City Administrator b) Community Development Director- c) City Planner d) Planning Technician 3) 1 Existing or Similar Positions a) Utility Billing Clerk B) Restructuring of Building and Safety Division to realign under the supervision and coordination of the Community Development Department and Community Development Director C) Total Proposed Salary with Benefits Added in FY 05/06, Assuming Full Year Hires and Benefits Calculated at 18.5% of Total Salary, and $12,000 per year per employee for health care): Estimated $351,545 J? a oPD7@pcve 0 ho ' Represents New• or Changed EST. ,` 1e36 Position Lu y aljalbillent1111®MoM '74CE City Treasurer Items in Blue are Appointed • ..• By the Mayor L_ Parks Board Library Board • Unofficial • • • Executive Director of Subordinate Director of Libn Parks and Recreation ' • • • • • Parks and Recreation Library Org. Ch Org. Chart FT Assistant to the Cit Administrator— FY 05/06 $43,000 - $61,00C ••r Administrative Cita Intern Secret • PT • • • • • City Engineer Finance Director ' Engineering Department Org. Chart Finance Department Org. Chart 2-2-05 BAO • ,2' 4t .----- °; = : Represents New or Changed Position EST 1• 1836 '----- --- = � [��� `�o 0 CR jyg DIxti Items in Red are Division �" Names Items in Blue are Appointed By the Mayor Fin Community FT Development Director- $63,000- $85,000 1i, FY 05/06 --- 1 Human I: Resources 1 Division \ I \__— , )ivision Building Safety Division Payroll/Benefits Specialist , - -- -1 Code Official / Planning Technician Building Inspector $42,000- $59,000 ----- FT Building Safety Org. Chart FY 05/06 (ICCI) \ 1 2-2-05 BAO ANNUAL AUDIT INFO FROM NEIGHBORING MUNICIPALITIES GASB MUNICIPALITY #OF FUNDS AUDIT COSTS AUDITORS COMPLIANT AUDIT YEAR 2003 2004 2005 VILLAGE OF PLAINFIELD 25 20,685 25,694 27,000 SIKICH GROUP YES CITY OF PLANO 8 13,000 13,400 13,800 PTW YES CITY OF LOCKPORT 24 18,500 19,000 19,500 MULCAHY, PAURITSCH &SALVADOR YES VILLAGE OF WINFIELD 14 16,000 ? PTW NO VILLAGE OF MONTGOMERY 14 18,000 18,000 SIKICH GARDNER NO VILLAGE OF SUGAR GROVE 10 20,400 25,000 MILLER,COOPER NO VILLAGE OF OSWEGO 10 18,000 23,000 PTW UNITED CITY OF YORKVILLE 18 14,230 14,660 28,700 PTW w 1B36 9 g�'o UNITED CITY OF YORKVILLE or, ; "'S PLANNING TECHNICIAN—JOB DESCRIPTION(DRAFT 2-3-05) Department: Community Development, Planning Division Reports to: Community Development Director Status: Full-time; Non-exempt Position Description Overview Under administrative direction by the Community Development Director,this position is responsible for performing professional planning duties. Primarily involved in comprehensive planning, and special projects; including design work for facilities, parks, open space, etc. Secondarily involved in landscape design and review. Essential Job Functions 1. Serve as assistant designer under the City Planner on assigned municipal projects involving municipal facilities, and City owned land and open space. Includes the preparation, evaluation, and/or supervision of the preparation of design renderings,plans, specifications, estimates, and recommendations regarding the selection of materials and the construction of said projects. 2. Review variance applications, conduct site and landscape plan reviews. 3. Assists with preparation of natural resource inventory assessments (tree, creek, and wetlands surveys, etc.) for comprehensive land planning, and compliance to City and State environmental regulations. 4. Assists in the updating of the City Land Use Plans, Zoning Maps, Parks and Recreation Open Space Master Plan, Landscape Ordinances, Appearance Codes, Comprehensive Plans, and other City related documents. 5. Assists in the coordination, and review of the City's current planning program. Assists with oversight reviews of proposals /site plans for compliance with plans, applicable ordinances, and other regulations. 6. Responds to inquiries and complaints from local citizens, developers, architects, and media regarding local planning and zoning regulations and ordinances. 7. Assists in the review of special planning and zoning related studies, and updates to the zoning ordinance and subdivision regulations. 8. Assists with the creation of technical research studies and statistical reports and recommendations for drafting or revising local legislation and long range comprehensive plans, projecting trends, monitoring socio-economic data, etc. 9. Assists in the monitoring of planning activities of neighboring jurisdictions; coordinates work with other affected agencies, assists in the development of regional plans as assigned. 10. Prepare applications for various development activities and participate in project administration. 11. Provide assistance to the City Planner on other special projects. 12. Perform other duties and functions as directed. Requirements 1. Must maintain a valid driver's license and abide by the United City of Yorkville vehicle policy. 2. Knowledge of the principles and practices of urban planning, park planning, landscape design, etc. 3. Ability to understand and analyze current planning trends and innovations in metropolitan areas, including and not limited to information pertaining economic, demographic, financial, real estate information, and development agreements analysis and forecasting 4. Knowledge of various state statutes, local ordinances, codes and regulations pertaining to economic development, planning, and community development. 5. Ability and familiarity with word processing, spreadsheet, database, and drafting programs. 6. Ability to work outdoors in all types of weather conditions. Must be able to stoop,bend, kneel, balance, crouch, or walk repeatedly and continually over rough,uneven, or rocky surfaces. 7. Must comply with all rules, policies, regulations and procedures related to the United City of Yorkville's employee manual. 8. Must have successfully completed a background investigation. Experience and Education 1. Bachelor's degree from an accredited college or university with major course work in Urban Planning, Land-Use Planning,Urban Studies, Landscape Architecture, Public Administration, or a closely related field. 2. Minimum of two years of municipal planning experience. The duties listed above are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar,related or a logical assignment to the position. The job description does not constitute an employment agreement between the employer and requirements of the job change. 2 UNITED CITY OF YORKVILLE COMMUNITY DEVELOPMENT DIRECTOR— JOB DESCRIPTION (DRAFT 2-3-2005) Department: Community Development Department Reports to: City Administrator Status: Full-Time; exempt Supervises: Planning Division; Building Safety Division; Consultants and Contractors Position Description Overview This position acts as a professional administrative employee that works under the general direction of the City Administrator_ The Community Development Project Director plans, directs, and coordinates the activities and projects of the Community Development Department composed of professional,technical, and clerical staff engaged in a variety of activities related to Planning/Zoning, Economic Development, and Code Enforcement. Essential Job Functions 1. Plans, organizes, supervises, manages, directs, coordinates, and controls the activities of the Department's professional, technical, and clerical staff 2. Coordinates, reviews, and participates in the City's current planning program. Oversees reviews of proposals/ site plans for compliance with plans, applicable ordinances, and other regulations. Oversees the development and/or revision of the City's Comprehensive Plan. 3. Negotiate with developers to maximize the quality of proposed developments. This involves work with City staff, Plan Commission, Council members, developers and their consultants, and others involved in making decisions. 4. Serve as project manager and director for all residential, commercial, industrial, municipal, and infrastructure related projects on behalf of the City. 5. Monitors planning activities of neighboring jurisdictions; coordinates work with other affected agencies, assists in the development of regional plans as assigned. 6. Manages and oversees work of outside related consultants and contractors. 7. Prepares and administers the Department's annual operating budget 8. Interviews and hires,trains and develops, supervises, and conducts performance reviews of staff of immediate subordinates and the remainder of the department through them. 9. Reviews proposed amendments to City codes and ordinances. Assists with preparing draft ordinances for legal review by City Attorney and/or legal consultants. Assures proper implementation and administration of ordinances. 10. Attends meetings, seminars, and conferences of professional associations and county, regional, and state organizations in order to keep abreast of trends and developments in the field, and to represent the City's interests before these groups. 11. Prepare grant requests and research federal, state, and private funding. 12. Perform other duties and functions as directed by the City Administrator. Requirements 1. Thorough knowledge of the principles and practices of Planning, Zoning, and Community Development, including an understanding of the fundamentals of urban design, economics, demography,municipal finance, urban planning, engineering, architecture, and building construction. 2. Thorough knowledge of plan review techniques including reading and evaluating plans, reading and working with engineering and architectural scales, etc. 3. Considerable knowledge of general administration,management, and budgeting techniques especially applied to the public sector. 4. Knowledge of various state statutes, local ordinances, codes and regulations pertaining to Economic Development, Code Administration, Engineering, and Planning and Zoning. 5. Knowledge of mathematics as applied to Community Development activities (IE—basic trigonometry, areas of lots, ratios, etc.). 6. Knowledge of supervisory techniques including motivation, discipline, goal-setting, evaluation, etc. 7. Some knowledge of the organizational ramifications, constraints, and relationships prevalent in a municipal setting. 8. Ability to establish and maintain effective working relationships with elected officials, employees, architects, developers, contractors, engineers, or other agencies and the general public. 9. Ability to respond tactfully to requests and inquiries from the general public, other departments, and divisions within the City. 10. Ability to plan,direct, organize, supervise, and carry out complex research projects and present results effectively. 11. Ability to read, interpret, and apply codes and ordinances as well as coordinate and propose amendments to codes and ordinances. 12. Ability to present information,both written and oral,to various Boards, Commissions, Committees, and other groups. 13. Ability to effectively supervise subordinate personnel by incorporating motivational techniques, discipline, goal setting, etc. Experience and Education 1. Bachelor's Degree in Urban Planning, Public Administration, or a related field required. Master's Degree in Urban Planning, Public Administration, or a related field preferred. 2. Minimum of(3) years of progressively responsible experience in urban planning and project managing in a local government agency required or equivalent combination of education, training and/or experience. Experience in a municipal setting preferred. 3. Must have successfully completed a background investigation. 4. Must have experience in preparing and administering grant applications and programs. 5. Must have outstanding communication skills, must be highly organized and motivated. The duties listed above are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar,related or a logical assignment to the position. The job description does not constitute an employment agreement between the employer and requirements of the job change. • f v . Esf Imo`^.183S t N UNITED CITY OF YORKVILLE NLE `Vr CITY PLANNER—JOB DESCRIPTION (DRAFT 2-3-2005) Department: Community Development,Planning Division Reports to: City Administrator Status: Full-time; exempt Positions Supervised: Consultants and Contractors as assigned Position Description Overview Under the supervision of the Community Development Director,the City Planner participates, reviews, coordinates, and oversees the processing of new development applications and agreements, current and long-range planning projects, and other related matters pertaining to land use, zoning, and transportation. Performs professional planning duties relative to assigned area of responsibility including current planning, comprehensive planning, or development review. Essential Job Functions 1. Performs technical review and analysis of plats of subdivision and development site plans for compliance with all applicable City codes and ordinances,as well as conformance with the City's Comprehensive Plan and accepted planning principles. 2. Serve as design manager for the United City of Yorkville on assigned municipal projects involving municipal facilities, City owned land and open space, City designed parks, and municipal landscaping areas. Includes the preparation, evaluation, and/or supervision of the preparation of design rendering,plans, specifications, estimates, and recommendations regarding the selection of materials, and the construction of said projects. 3. Reviews reports and recommendations for the Plan Commission and/or City Council. Assists in the coordination of meeting agendas. 4. Works with residents, developments, builders, and their representatives regarding zoning requests, subdivision plats, site plans, and related development issues. Assists in filing and processing related development applications to completion. Coordinates with applicant, City Staff, and other applicable parties to resolve issues and keep development application on track. 5. Coordinate and improve the development review process. This includes working with City staff, developers and their consultants, outside agencies and groups such as the Kendall County Development Department, Yorkville School District, and others. 6. Participates in the development of policies,procedures, and standards relating to planning, and development of municipal buildings, City owned land, and open space. 7. Assists in the updating and/or provides recommendations to the Façade Committee and City for the Land Use Plans, Zoning Maps, Parks and Open Space Master Plan, Landscape Ordinances, Appearance Codes, Comprehensive Plans and other City related documents. 1 8. Coordinate plans with local public safety agencies to ensure compliance with City Facilities Security Plan, including promoting crime prevention through environmental design. 9. Directs coordinates, reviews, and participates in special planning and zoning related studies and updates to the zoning ordinance and subdivision regulations. 10. Assists in the development of short and long range plans; gathers, interprets, and prepares data for studies, reports, and recommendations; coordinates department activities with other departments and agencies as needed. 11. Conducts technical research studies and prepares statistical reports and recommendations for drafting or revising local legislation and long range comprehensive plans,projecting trends, monitoring socio-economic data, etc. 12. Monitors planning activities of neighboring jurisdictions; coordinates work with other affected agencies, assists in the development of regional plans as assigned. 13. Manages and oversees work of outside related consultants and contractors as assigned. 14. Perform other duties and functions as directed by the City Administrator and/or designated Department Head. Requirements 1. Substantial skill and knowledge of the principles land planning, project design, and contract management as well as proficiency in AutoCAD, GIS, and Microsoft Office, as well as ability to create and review land-use design renderings. 2. Knowledge of aspects involved in natural resource planning, including natural systems, relevant federal and state law, and best management practices. 3. Knowledge of pertinent federal, state, and local laws, codes and regulations. 4. Ability to plan, organize and conduct public meetings. 5. Ability to establish effective working relationship; ability to enforce standards and regulations with tact and diplomacy. 6. Work record, references shows reliability, initiative,tact and productivity. Ability to establish priorities and make decisions, and to take appropriate action when necessary. 7. Knowledge of mathematics as applied to Community Development activities (IE—basic trigonometry, areas of lots,ratios, etc. 8. Has the ability to schedule and implement duties in an effective and efficient manner. Establish projects according to priorities, establish schedules and deadlines. 9. Ability to communicate clearly and concisely,both orally and in writing. Ability to communicate effectively with residents, co-workers, contractors, and general public. 2 10. Ability to provide leadership, counsel,motivation and constructive performance reviews to contractors. 11. Must maintain a valid driver's license and abide by the United City of Yorkville vehicle policy. 12. Must comply with all rules,policies, regulations and procedures related to the United City of Yorkville's employee manual. Experience and Education 1. Bachelor's degree in Urban Planning, Architecture, Land Use or Park Planning, Civil Engineering, Public Administration, or a closely related field. 2. Registered Landscape Architect preferred 3. AICP certification preferred. 4. Minimum of(3)years of progressively responsible experience in urban planning in a municipal setting and/or equivalent combination of education,training and/or experience preferred. 5. Must have experience in preparing and administering grant applications and programs. 6. Must have outstanding communication skills, must be highly organized and motivated. The duties listed above are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar, related or a logical assignment to the position. The job description does not constitute an employment agreement between the employer and requirements of the job change. 3 UNITED CITY OF YORKVILLE ASSISTANT TO THE CITY ADMINISTRATOR—JOB DESCRIPTION (DRAFT 2-3-2005) Department: Administration Reports to: City Administrator Status: Full-Time; Exempt? Supervises: Administrative Intern, City Secretary, Receptionist Position Description Overview The purpose of the Assistant to the City Administrator is to provide strategic and confidential analysis and assistance to the City Administrator and Depattment Heads regarding, administrative projects; to manage and coordinate projects dealing with development tracking and projections, budgeting, legislation, technology,policy formulation, etc.; and to supervise, in conjunction with the City Administrator, the City Secretary and Administrative Intern. Essential Job Functions 1. Supervise, in conjunction with the City Administrator, the City Secretary, Receptionist, and Administrative Intern; provides instruction and training;plans, coordinates, assigns, and reviews work; maintains standards; acts on problems and evaluates performance. 2. Coordination with elected officials or appointed officials(Alderpersons, Mayor, Clerk, Treasurer, Plan Commission members, etc.) for research and individual presentations of proposed policies,plans, developments, agenda items, etc. as requested. 3. Assists in the development of short and long range plans; gathers, interprets, and prepares data for studies, reports and recommendations; coordinates activities with other departments and agencies as needed. 4. Prepares a variety of studies, reports, and related information for decision-making purposes; conducts research, analysis, and prepares recommendations regarding proposals for programs, grants, services, budget, equipment, etc. 5. Manages and supervises assigned operations to achieve goals within available resources. 6. Prepares the development of newsletters,media releases, news articles, website,brochures, flyers, notices, flyers, and other informational materials about programs and services. 7. Assists with the projection of employment needs and negotiating of collective bargaining agreements. 8. Communicates official plans, policies, and procedures to staff and the general public; makes presentations to supervisors, boards, commissions, civic groups, and the general public as assigned; prepares drafts of speeches, presentations, resolutions, ordinances, contracts, administrative policies, etc. as assigned; assists in the development of informational materials. • 9. Assists in the preparation of annual budget requests; assures that assigned areas of responsibility are performed within budget; performs cost control activities; monitors expenditures in assigned areas to assure sound fiscal control. 10. Evaluates work procedures, schedules, and workflow; studies and recommends policies and procedures to improve efficiency and effectiveness of operations. 11. Provides administrative assistance to supervisors in meeting management; assembles background materials,prepares agendas, and records action items for various meetings. 12. Researches grant programs; prepares grant applications. 13. Investigates and follows-up on citizen requests for service, complaints, and requests for information. 14. Performs other related duties as assigned. Requirements 1. Working knowledge of the principles and practices of modern public administration, including media relations,budgeting, personnel, and other public administration procedures. 2. Working knowledge of modern records management techniques, including the knowledge of research techniques, ability to assemble, organize, and present, in written or oral form, moderately complex statistical, financial, or factual information derived from many sources. 3. Ability to establish and maintain effective working relationships with employees, supervisors, other departments, officials, and the public. 4. Ability to communicate effectively verbally or in writing. 5. Ability and substantial knowledge of how to operate a personal computer, including word processing, spreadsheet and database software, 10-key calculator, typewriter,phone, copy machine, fax machine, etc. 6. Knowledge of the geography and demography of the City; knowledge of City ordinances and resolutions, and of pertinent federal and state laws. Experience and Education 1. Bachelor's degree in public administration, political science,business management, or a closely related field. Major coursework towards completion of Master's degree in public administration, political science, business management, or a related field preferred. 2. At least one year of related experience required, experience in public administration preferred. 3. Any equivalent combination of education and progressively responsible experience,with additional work experience substituting for the required education on a year for year basis. r 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.