The URL can be used to link to this page

Administration Packet 2005 06-02-05 ,c00 C/r o United City of Yorkville -6 County Seat of Kendall County 800 Game Farm Road EST.% 1836 Yorkville, Illinois, 60560 Telephone: 630-553-4350 O if 1 ` �t Fax 630-553-7575 � �4� Website: www.yorkville.il.us CCE x\'> AGENDA ADMINISTRATION COMMITTEE MEETING Thursday,June 2, 2005 6:30 P.M. CITY CONFERENCE ROOM Presentation: None Old Business: 1. Minutes for Approval/Correction: May 5, 2005 2. Monthly Budget Report for April 2005 3. Treasurer's Report for January —April 2005 4. Senior Engineering Technician Salary Schedule 5. Senior Engineering Technician Job Description New Business: 1. Deputy Clerk Ordinance 2. Administrative Assistant Job Description a. City Council Administrative Assistant 3. Clerk's Office Assistant Job Description - Revised 4. Full-time Accounting Clerk I Job Description 5. Part-time Utility Billing Clerk Job Description 6. Organizational Chart: City, Administration, Finance, Engineering, Public Works, and Community Development 7. Appointment of City Administrator, City Attorney, City Engineer, Director of Public Works, Chief of Police, and Building Code Official 8. Single Audit Engagement Letter for $950,000 Water Radium Grant Additional Business: Page 1 of 4 1AF 1 UNITED CITY OF YORKVILLE ADMINISTRATION COMMITTEE MEETING THURSDAY, MAY 5,2005 6:30 PM City Hall Conference Room CITY OFFICIALS IN ATTENDANCE: Mayor Art Prochaska(6:45pm) Police Chief Harold Martin Alderman Paul James Finance Director Traci Pleckham Alderman Joe Besco City Treasurer Bill Powell Alderman Larry Kot (6:40pm) City Administrator Tony Graff(6:45pm) GUESTS: None The meeting was called to order at 6:30pm by Alderman Paul James. PRESENTATIONS None OLD BUSINESS 1. Minutes for Approval/Correction: April 7, 2005 The minutes were approved as read. 2. Monthly Budget Report for March 2005 It was noted that the City revenue collected thus far is at 82.42% and the expenses are at 71.68%. Ms. Pleckham added that the state revenues are delayed about 3 months and these will catch up at audit time. She added that the City could be over 100% in revenues and the numbers will be "trued up" after the audit. There was a very brief discussion of the revised budget and whether or not the revenue and expense projections were on target. Ms. Pleckham added that $400,000 was added to the Fund Balance last year. 3. Treasurer's Report for May—November 2004 Ms. Pleckham said these reports will be presented on a more timely basis in the future. May through November reports do not include the Fund Balance, however, December does. Mr. Powell said that the City Council has already approved these billing expenditures for the budget and these reports are a tally of expenses and match the audit. Page 2 of 4 Mr. Powell said that the December report showed the Fund Balance reserve for the first time and that he and Ms. Pleckham have been considering two methods of calculating the Fund Balance percentage of the budget. Those methods are: 1. Take a percentage of the entire budget to hit the 15-20%amount desired, which would put the Fund Balance at 21%. 2. A more conservative method is to review each line item or the everyday expenses, however, this is very time-consuming. Ms. Pleckham added that she had spoken with auditors on this date and the City's S & P bond rating is at 23.8% as of April of last year. Ms. Pleckham said the Fund Balance amount could also be calculated by figuring 15-25% of the total expenses. Ms. Pleckham will monitor the percentage. Yorkville is one of only a few cities which have Fund Balance policies in place according to Finance Director Pleckham. She further stated that even though the City is growing, the fact that it has a Fund Balance at the 23%range, is viewed as positive. If there were to be a dip in the Fund because of a capital expenditure, it would not be viewed as negative since the expenditure would benefit the community. Alderman Kot recommended that the current accounting methods be continued and that the City Council be updated with the Fund status on a regular basis. If there is a problem, then it should be addressed. The Mayor concurred and added that the 15-25%range in the policy was sound. The City is not penalized for exceeding the 25%,rather the excess is rolled over into next year's budget. If the Fund falls below 15%, it will be reviewed by the Council. Administrator Graff asked Ms. Pleckham to plot a trend chart and include the previous month for comparison. Treasurer Powell noted that Yorkville's investment policy was used as a model by the Treasurer's Association. These reports will move to the City Council consent agenda. 4. Senior Engineering Technician Job Description It was noted that this description was approved in 2001 and is budgeted, however, a salary range must be established. Intern Bart Olson is gathering salary information for a position of this type. Alderman Besco stated that he felt the education was very lenient. It was suggested by Mayor Prochaska that the job description should list specific college courses to insure that the applicant possesses the knowledge needed. A management course was suggested by Alderman Besco while Mr. James preferred an Associates Degree or equivalent experience. It was noted that Mr. Wywrot wishes to promote within the department and is seeking someone to supervise the other engineering techs, thus the "Senior"Engineering Tech. Revisions to the "Minimum and Preferred Experience and Education"will be made and a Page 3 of 4 salary range will be presented at a future C.O.W. Mr. Kot said a revision to the organizational chart should be made as well. NEW BUSINESS 1. Collateralized Single Family Mortgage Revenue Bonds Administrator Graff said this is an annual program and is for first time homebuyers. Ms. Pleckham has requested a list of the banks participating in this program. There is no cost to the City and this program allows first time homebuyers an opportunity for a better mortgage for a home in Yorkville. These funds are bond proceeds which the State allocates for this program. This item moves to the C.O.W. consent agenda. Alderman James also asked for a list of the number of people who participate. ADDITIONAL BUSINESS Mr. Powell said that a CD ladder with$200,000 (4--$50,000 CD's set up for 3, 6, 9 and 12 months)was set up at the Earthmover Credit Union. This was done to increase revenues for the City. This information will be included in the progress report. Retiring Alderman Kot said that he had enjoyed serving the community. When asked what improvements he would suggest, he said the City Council should examine the committee structure and the length of meetings. Mr. James concurred with this suggestion. Mayor Prochaska added that it might be beneficial for committees to make recommendations before moving items on to C.O.W. Another suggestion, by Alderman Besco, was to have two committee meetings per month and the Mayor added that perhaps one City Council meeting per month would be sufficient. Timely payments for the bill list were discussed as being an issue to consider if changes were made in meeting schedules. Alderman James said a recommendation should be brought back to this committee regarding the procedure to follow for the bill list. It was suggested that "Treasurer's Authority" could be used for bills to be paid on time. The City Administrator and Finance Director had previously discussed a Finance Committee be set up to discuss future budgets. This will be discussed for next year. Another idea was having two committees report at one C.O.W and the other two committees would report at the second C.O.W. of the month. Page 4 of 4 Mayor Prochaska requested that the City Council re-appoint Attorney Wyeth for an additional year of service. He added that a time requirement for an attorney is not clear yet since the former attorney is finishing up on some items. Currently, Attorney Wyeth is working for the City about 20 hours per week. Discussion regarding the attorney position will continue at future meetings. There was no further business and the meeting was adjourned at 7:30pm. Respectfully submitted by Marlys Young, Minute Taker UNITED CITY (ORKVILLE ` BUDGET 2004-2005 GENERAL FUND SUMMARY PERIOD ENDING APRIL 30, 2005 100% OF FISCAL YEAR ***UNAUDITED*** REVENUE/EXPENSE THRU 2004-2005 PERCENT VS. APRIL 30, 2005 BUDGET BUDGET AMOUNT a % - "k $ awt F n x '' a GENERAL FUND EXPENSES FINANCE & ADMINISTRATION 4,061,965 4,090,074 99.31% ENGINEERING 353,716 400,649 88.29% POLICE 2,065,416 2,035,614 101.46% BUILDING &ZONING 338,232 346,700 97.56% STREETS 2,007,982 4,060,078 49.46% HEALTH & SANITATION 511,181 506,000 101.02% p7ii.::'-`°:-:?.': .;:, 2., - .,'.,irt.,-;!'r ,-44.t....4:7,:crra.:'''''s s a '-4-- yM 0 SLi 6/1/2005 UNITED CITY OF YORKVILLE DETAILED REVENUE & EXPENSE REPORT AS OF APRIL 30, 2005 **UNAUDITED** 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 Working Cash 47 Police Equipment Capital 17 Library 48 Public Works Equipment Capital 19 Fox Industrial 52 Parks &Recreation Equipment Capital 21 Countryside TIF 54 DATE: 06/01/20.: : LEITRD EIUE & _ NSILRE .* l ',f/ Pe- 5 DIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT ^� F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED GENERAL 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 14,000.00 26,000.00 0.00 100.0 01-000-40-00-3997 IN TOWN ROAD PROGRAM FUNDING 0.00 632, 635.58 632, 635.00 100.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 0.00 1,287,848.33 1,287,453.00 100.0 01-000-40-00-4001 TOWN ROAD/BRIDGE TAX 0.00 90, 674.03 95,000.00 95.4 01-000-40-00-4010 PERSONAL PROPERTY TAX 5,159.03 12,433.76 10,000.00 124.3 01-000-40-00-4020 STATE INCOME TAX 193,301.93 612, 424.98 593,257.00 103.2 01-000-40-00-4030 MUNICIPAL SALES TAX 334,094.01 2,064,087.21 2, 133,000.00 96.7 01-000-40-00-4032 STATE USE TAX 13,864.29 82,386.51 87,890.00 93.7 01-000-40-00-4040 MUNICIPAL UTILITY TAX 0.00 445, 961.95 500,000.00 89.1 01-000-40-00-4041 UTILITY TAX - NICOR 0.00 94,778.34 95,000.00 99.7 01-000-40-00-4042 UTILITY TAX - CABLE TV 0.00 60,757.74 60,000.00 101.2 01-000-40-00-4043 UTILITY TAX - TELEPHONE 65, 632.76 349, 446.30 290,000.00 120.4 01-000-40-00-4050 HOTEL TAX 1,358.83 17,743.68 19,000.00 93.3 TOTAL TAXES 627, 410.85 7,258,792.50 8,730,374.00 83.1 LICENSES & PERMITS 01-000-41-00-4100 LIQUOR LICENSE 7,425.00 22,247.62 22,500.00 98.8 01-000-41-00-4101 OTHER LICENSES 1,560.00 5,278.26 4,000.00 131.9 01-000-41-00-4110 BUILDING PERMITS 83, 697.00 897,794.60 870,000.00 103.1 TOTAL LICENSES & PERMITS 92, 682.00 925,320.48 896, 500.00 103.2 CHARGES FOR SERVICES 01-000-42-00-4205 FILING FEES 886.00 22,382.75 22,000.00 101.7 01-000-42-00-4206 GARBAGE SURCHARGE 31, 914.88 181,845.08 171,590.00 105.9 01-000-42-00-4207 REFUSE STICKERS 0.00 0.00 0.00 0.0 01-000-42-00-4208 COLLECTION FEE - YBSD 44,441.36 44,441.36 44,441.00 100.0 01-000-42-00-4210 DEVELOPMENT FEES 34, 301.01 730, 817.95 730,000.00 100.1 01-000-42-00-4211 ENGINEERING CAPITAL FEE 200.00 2,900.00 4,000.00 72.5 TOTAL CHARGES FOR SERVICES 111,743.25 982,387.14 972,031.00 101.0 P1 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 2 DIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED 3ENERAL FINES & FORFEITS 01-000-43-00-4310 TRAFFIC FINES 7,879.13 68,973.28 70,000.00 98.5 01-000-43-00-4315 REIMBURSE POLICE TRAINING 0.00 0.00 3,500.00 0.0 01-000-43-00-4320 ORDINANCE FEES 285.00 2,380.00 2,500.00 95.2 TOTAL FINES & FORFEITS 8, 164.13 71,353.28 76,000.00 93.8 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 0.00 0.0 01-000-44-00-4410 REIMBURSEMENTS - OTHER GOVTS 0.00 18.20 0.00 100.0 01-000-44-00-4411 REIMBURSEMENTS-POLICE PROTECTN 265.00 2, 620.00 3,000.00 87.3 01-000-44-00-4420 SIDWALK CONSTRUCTION 0.00 596.48 5,000.00 11.9 01-000-44-00-4490 MISCELLANEOUS INCOME 504.42 7,833.01 10,000.00 78.3 TOTAL MISCELLANEOUS 769.42 11,067.69 19,000.00 58.2 INTERGOVERNMENTAL 01-000-45-00-4504 TRAFFIC SIGNAL REVENUE 0.00 6,156.79 6,000.00 102.6 01-000-45-00-4505 COPS GRANT - VESTS 0.00 565.00 2,000.00 28.2 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 34,208.92 50,210.00 68.1 INTEREST 01-000-46-00-4600 INVESTMENT INCOME 4,020.54 25,857.06 25,000.00 103.4 TOTAL INTEREST 4,020.54 25,857.06 25,000.00 103.4 TRANSFERS 01-000-49-00-4914 TRANSFER FROM WORKING CASH 0.00 111,569.00 0.00 100.0 01-000-49-00-4915 TRANSFER FROM WATER OPERATIONS 0.00 200,000.00 200,000.00 100.0 01-000-49-00-4920 TRANSFER FROM SEWER MAINT. 0.00 70,000.00 70,000.00 100.0 01-000-49-00-4925 TRANSFER FROM SAN. SEWER 0.00 200,000.00 200,000.00 100.0 01-000-49-00-4930 TRANSFER FROM WATER IMPROVE. 0.00 200,000.00 200,000.00 100.0 P' DATE: 06/O1/2U UNITED CITY OF _ ,VILLE P.. . 3 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL TRANSFERS 0.00 781,569.00 670,000.00 116.6 TOTAL REVENUES: GENERAL 844,790.19 10,090,556.07 11,439, 115.00 88.2 FINANCE & ADMINISTRATION EXPENSES PERSONNEL SERVICES 01-110-50-00-5100 SALARIES - MAYOR 4,390.00 8,175.00 7, 535.00 108.4 01-110-50-00-5101 SALARIES - CITY CLERK 1,870.00 3,705.00 3, 635.00 101.9 01-110-50-00-5102 SALARIES - CITY TREASURER 1,940.00 3,775.00 3, 635.00 103.8 01-110-50-00-5103 SALARIES - ALDERMAN 15,345.00 30,025.00 29,080.00 103.2 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 11,502.80 13,500.00 85.2 01-110-50-00-5106 SALARIES - ADMINISTRATIVE 54,213.76 409,788.17 413, 600.00 99.0 01-110-50-00-5136 SALARIES - PART TIME 6,077.64 44,049.33 48,000.00 91.7 01-110-50-00-5137 SALARIES - OVERTIME 0.00 192.87 1,500.00 12.8 01-110-50-00-5199 MSI PAYROLL 0.00 0.00 0.00 0.0 01-110-50-00-5202 BENEFITS-UNEMPLOY. COMP. TAX 3,316.50 11,053.50 9,000.00 122.8 01-110-50-00-5203 BENEFITS - HEALTH INSURANCE 52,165.01 483, 980.46 495,000.00 97.7 01-110-50-00-5204 BENEFITS - GROUP LIFE INSURANC 940.60 17,381.35 18,000.00 96.5 01-110-50-00-5205 BENEFITS - DENTAL/VISION ASST 17, 141.67 56,526.23 50,000.00 113.0 TOTAL PERSONNEL SERVICES 158,727.38 1,080, 654.71 1,093,485.00 98.8 PROFESSIONAL SERVICES 01-110-61-00-5300 LEGAL SERVICES 20, 625.20 55,200.43 55,000.00 100.3 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 5,820.00 7, 500.00 77.6 01-110-61-00-5307 ACCOUNTING SYSTEM REVIEW 0.00 0.00 0.00 0.0 01-110-61-00-5308 GASB 34 7,504.00 10,472.00 15,000.00 69.8 01-110-61-00-5310 EMPLOYEE ASSISTANCE 1,295.00 2, 995.00 4, 500.00 66.5 01-110-61-00-5311 CODIFICATION 0.00 2,744.00 5, 000.00 54.8 01-110-61-00-5314 BUILDING INSPECTIONS 141,511.35 732,877.20 607, 500.00 120.6 01-110-61-00-5322 BONDING 0.00 837.00 2,000.00 41.8 TOTAL PROFESSIONAL SERVICES 170, 935.55 625, 605.63 711, 160.00 116.0 P3 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 4 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED FINANCE & ADMINISTRATION 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 8,292.10 35, 582.49 37,300.00 95.3 01-110-62-00-5403 SPECIAL CENSUS 106,351.00 106,351.00 106,351.00 100.0 01-110-62-00-5404 CABLE CONSORTIUM FEE 8,535.22 24,303.09 30,000.00 81.0 01-110-62-00-5406 OFFICE CLEANING 4,331.27 34, 195.78 34,500.00 99.1 01-110-62-00-5410 MAINTENANCE - OFFICE EQUIPMENT 90.00 281.90 500.00 56.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 3,232.00 19,392.00 19,392.00 100.0 01-110-62-00-5421 WEARING APPAREL 0.00 0.00 0.00 0.0 01-110-62-00-5427 FACADE PROGRAM 0.00 9,388.50 20,000.00 46.9 01-110-62-00-5436 TELEPHONE 3,129.75 20,214.67 20,000.00 101.0 01-110-62-00-5437 ACCTG SYSTEM SERVICE FEE 0.00 6,785.00 7,385.00 91.8 01-110-62-00-5438 CELLULAR TELEPHONE 232.93 1, 971.34 2,300.00 85.7 01-110-62-00-5439 TELEPHONE SYSTEMS MAINTENANCE 5,730.10 8,204.50 11,000.00 74.5 TOTAL CONTRACTUAL SERVICES 139, 924.37 394,724.96 427,040.00 92.4 PROFESSIONAL DEVELOPMENT 01-110-64-00-5600 DUES 420.00 3,561.75 4,000.00 89.0 01-110-64-00-5601 ILLINOIS MUNICIPAL LEAGUE DUES 0.00 690.00 551.00 125.2 01-110-64-00-5603 SUBSCRIPTIONS 0.00 279.50 400.00 69.8 01-110-64-00-5604 TRAINING & CONFERENCES 827.00 8,271.08 8,000.00 103.3 01-110-64-00-5605 TRAVEL/MEALS/LODGING 667.04 10, 152.33 19,000.00 53.4 01-110-64-00-5607 PUBLIC RELATIONS 5,751.88 14,844.33 14,000.00 106.0 TOTAL PROFESSIONAL DEVELOPMENT 7, 665.92 37,798.99 45,951.00 82.2 OPERATIONS 01-110-65-00-5800 CONTINGENCIES 48.00 11,396.17 81, 675.00 13.9 01-110-65-00-5801 FUND BALANCE RESERVE 0.00 0.00 0.00 0.0 01-110-65-00-5802 OFFICE SUPPLIES 2,557.72 11,485.76 12,000.00 95.7 01-110-65-00-5804 OPERATING SUPPLIES 7, 136.50 14, 410.30 14,500.00 99.3 01-110-65-00-5808 POSTAGE & SHIPPING 1,553.08 10,798.04 10,500.00 102.8 01-110-65-00-5809 PRINTING & COPYING 4,975.79 14,929.93 13,000,00 114.8 01-110-65-00-5810 PUBLISHING & ADVERTISING 162.00 3,247.70 3,000.00 108.2 01-110-65-00-5844 MARKETING - HOTEL TAX 2,313.73 18,680.00 19,000.00 98.3 Pi' DATE: 06/01/20u_ UNITED CITY OF 1._.<VILLE PAS 5 DIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL OPERATIONS 18,746.82 84, 947.90 153, 675.00 55.2 RETIREMENT 01-110-72-00-6500 IMRF PARTICIPANTS 4,784.01 43,395.16 44,000.00 98.6 01-110-72-00-6501 SOCIAL SECURITY & MEDICARE 6,762.17 41,336.75 42,500.00 97.2 TOTAL RETIREMENT 11, 546.18 84,731.91 86,500.00 97.9 CAPITAL OUTLAY 01-110-75-00-7002 COMPUTER EQUIP & SOFTWARE 2, 936.98 16, 124.31 16, 500.00 97.7 01-110-75-00-7003 OFFICE EQUIPMENT 0.00 10, 151.76 10,000.00 101.5 TOTAL CAPITAL OUTLAY 2, 936.98 26,276.07 26,500.00 99.1 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 6,019.52 23,817.91 30,000.00 79.3 01-110-78-00-9003 SALES TAX REBATE 83,569.59 321,877.83 333,500.00 96.5 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 89, 589.11 346,262.41 364,800.00 94.9 TRANSFERS 01-110-99-00-9923 TRANSFER TO LIBRARY 0.00 26,249.00 26,249.00 100.0 01-110-99-00-9925 TRANSFER TO SAN SEWER 0.00 150,000.00 150,000.00 100.0 01-110-99-00-9940 TRANSFER TO PARK & RECREATION 0.00 794,036.00 794,036.00 100.0 01-110-99-00-9941 TRANSFER TO PARK/REC CAPITAL 60,000.00 96, 600.00 96, 600.00 100.0 01-110-99-00-9945 TRANSFER TO MUNICIPAL BLDG 0.00 97,000.00 97,000.00 100.0 01-110-99-00-9965 TRANSFER TO DEBT SERVICE 17,078.00 17,078.00 17,078.00 100.0 TOTAL TRANSFERS 77,078.00 1,180, 963.00 1,180,963.00 100.0 TOTAL EXPENSES: FINANCE & ADMINISTRATION 677, 150.31 4,061, 965.58 4,090,074.00 99.3 ENGINEERING EXPENSES P5 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 6 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ENGINEERING PERSONNEL SERVICES 01-150-50-00-5107 SALARIES-EMPLOYEES 27,866.13 241,213.66 244,945.00 98.4 01-150-50-00-5137 SALARIES-OVERTIME 85.90 655.16 1,000.00 65.5 TOTAL PERSONNEL SERVICES 27, 952.03 241,868.82 245,945.00 98.3 CONTRACTUAL SERVICES 01-150-62-00-5401 CONTRACTUAL SERVICES 3, 900.45 47, 452.37 58,000.00 81.8 01-150-62-00-5409 MAINTENANCE-VEHICLES 1, 425.29 4, 614.99 4,500.00 102.5 01-150-62-00-5410 MAINTENANCE-OFFICE EQUIP 371.96 544.56 2,000.00 27.2 01-150-62-00-5411 MAINTENANCE-COMPUTERS 0.00 2,895.55 3,500.00 82.7 01-150-62-00-5421 WEARING APPAREL 0.00 437.85 1,100.00 39.8 01-150-62-00-5438 CELLULAR TELEPHONE 338.38 2,568.52 2,800.00 91.7 TOTAL CONTRACTUAL SERVICES 6,036.08 58, 513.84 71, 900.00 81.3 PROFESSIONAL DEVELOPMENT 01-150-64-00-5600 DUES 0.00 245.00 300.00 81.6 01-150-64-00-5604 TRAINING & CONFERENCES 129.00 991.00 2,500.00 39.6 01-150-64-00-5605 TRAVEL EXPENSE 36.30 125.64 1,000.00 12.5 01-150-64-00-5616 BOOKS & PUBLICATIONS 0.00 91.32 200.00 45.6 TOTAL PROFESSIONAL DEVELOPMENT 165.30 1,452.96 4,000.00 36.3 OPERATIONS 01-150-65-00-5801 ENGINEERING SUPPLIES 1,046.16 2,797.21 3,000.00 93.2 01-150-65-00-5802 OFFICE SUPPLIES 203.50 1, 997.34 2,000.00 99.8 01-150-65-00-5809 PRINTING & COPYING 283.12 1, 618.76 2,000.00 80.9 01-150-65-00-5814 STORM WATER SOFTWARE/TRAINING 0.00 2,163.00 5,000.00 43.2 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 767.00 24,000.00 3.1 TOTAL OPERATIONS 1,532.78 9,343.31 36,000.00 25.9 RETIREMENT 01-150-72-00-6500 IMRF PARTICIPANTS 2,275.27 23,475.06 23,804 .00 98.6 01-150-72-00-6501 SOCIAL SECURITY & MEDICARE 2,138.27 19,062.31 19,000.00 100.3 PP DATE: 06/01/20. UNITED CITY OF . ..VILLE P,. 7 DIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL RETIREMENT 4,413.54 42, 537.37 42,804 .00 99.3 TOTAL EXPENSES: ENGINEERING 40,099.73 353,716.30 400, 649.00 88.2 PUBLIC SAFETY/POLICE DEPT. EXPENSES PERSONNEL SERVICES 01-210-50-00-5107 SALARIES - EMPLOYEES 68,242.73 559,041.38 541,000.00 103.3 01-210-50-00-5131 SALARIES - LIEUTENANT/SERGEANT 57,491.32 479,906.46 461,525.00 103.9 01-210-50-00-5133 SALARIES - COPS 15,835.51 149,250.21 148, 496.00 100.5 01-210-50-00-5134 SALARIES - CROSSING GUARD 2, 519.25 16, 308.25 18,800.00 86.7 01-210-50-00-5135 SALARIES - POLICE CLERKS 11,755.71 98,038.37 100,307.00 97.7 01-210-50-00-5136 SALARIES - PART TIME 5, 639. 13 28,457.42 25,000.00 113.8 01-210-50-00-5137 SALARIES - OVERTIME 4,437.03 43,297.39 50,000.00 86.5 TOTAL PERSONNEL SERVICES 165, 920.68 1,374,299.48 1,345,128.00 102.1 PROFESSIONAL SERVICES 01-210-61-00-5300 LEGAL SERVICES 2,833.30 5,171.70 6,300.00 82.0 TOTAL PROFESSIONAL SERVICES 2,833.30 5,171.70 6,300.00 82.0 CONTRACTUAL SERVICES 01-210-62-00-5408 MAINTENANCE - EQUIPMENT 2,070.42 7,818.98 8,000.00 97.7 01-210-62-00-5409 MAINTENANCE - VEHICLES 9,029.50 27, 691.32 21,000.00 131.8 01-210-62-00-5410 MAINT-OFFICE EQUIPMENT 1, 125.30 2,376.29 2,500.00 95.0 01-210-62-00-5411 MAINTENANCE - COMPUTERS 1, 534.00 1,931.59 2,000.00 96.5 01-210-62-00-5414 WEATHER WARNING SIREN MAINT 479.00 5, 917.47 8,000.00 73.9 01-210-62-00-5421 WEARING APPAREL 613. 69 19,993.10 20,000.00 99.9 01-210-62-00-5422 COPS GRANT IV - VESTS 0.00 2,829.18 2,500.00 113.1 01-210-62-00-5423 CLASY GRANT 0.00 0.00 0.00 0.0 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 0.00 1,000.00 1,000.00 100.0 01-210-62-00-5430 HEALTH SERVICES 123. 65 2,730.04 3,000.00 91.0 P7 )ATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 8 DIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ED: GL470002.WOW FUND: GENERAL FUND FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED PUBLIC SAFETY/POLICE DEPT. 3XPENSES CONTRACTUAL SERVICES 01-210-62-00-5431 LABORATORY FEES 484.68 989.68 1,000.00 98.9 01-210-62-00-5436 TELEPHONE 3, 690.28 20,174.97 20,000.00 100.8 01-210-62-00-5438 CELLULAR TELEPHONE 1,985.79 11, 679.14 13,000.00 89.8 01-210-62-00-5440 PAGERS 0.00 0.00 0.00 0.0 01-210-62-00-5441 MTD-ALERTS FEE 0.00 2, 618.00 2,300.00 113.8 TOTAL CONTRACTUAL SERVICES 21,136.31 107,749.76 109,300.00 98.5 PROFESSIONAL DEVELOPMENT 01-210-64-00-5600 DUES 0.00 2,245.30 2,250.00 99.7 01-210-64-00-5603 SUBSCRIPTIONS 44.95 309.90 300.00 103.3 01-210-64-00-5604 TRAINING & CONFERENCE 3,748.45 19,909.82 19,000.00 104 .7 01-210-64-00-5605 TRAVEL EXPENSES 251.01 8,969.39 9,000.00 99.6 01-210-64-00-5606 COMMUNITY RELATIONS 548.71 5,102.20 5,250.00 97.1 01-210-64-00-5607 POLICE COMMISSION 6,114.97 10, 922.58 11,000.00 99.2 01-210-64-00-5608 TUITION REIMBURSEMENT 5,809.22 13,795.21 14,000.00 98.5 01-210-64-00-5609 POLICE RECRUIT ACADEMY 2,801.27 10,483.81 10,500.00 99.8 01-210-64-00-5610 GUN RANGE FEES 565.00 621.64 625.00 99.4 01-210-64-00-5611 SRT FEE 1, 685.00 2,000.00 2,000.00 100.0 TOTAL PROFESSIONAL DEVELOPMENT 21,568.58 74,359.85 73,925.00 100.5 OPERATIONS 01-210-65-00-5800 CONTINGENCIES 0.00 0.00 0.00 0.0 01-210-65-00-5802 OFFICE SUPPLIES 319.28 6,275.99 6,500.00 96.5 01-210-65-00-5804 OPERATING SUPPLIES 981.66 15,320.50 15,750.00 97.2 01-210-65-00-5808 POSTAGE & SHIPPING 251.10 1,811.51 3,000.00 60.3 01-210-65-00-5809 PRINTING & COPYING 811.92 4,838.70 4,500.00 107.5 01-210-65-00-5810 PUBLISHING & ADVERTISING 561.42 889.37 1,000.00 88.9 01-210-65-00-5812 GASOLINE 7,346.08 34,384.00 33,000.00 104.1 01-210-65-00-5813 AMMUNITION 756.18 4,904.80 5,000.00 98.0 TOTAL OPERATIONS 11,027.64 68,424.87 68,750.00 99.5 RETIREMENT P0 )ATE: 06/O1/20b_ UNITED CITY OF : .VILLE P?, 9 PIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ED: GL470002.W0W FUND: GENERAL FUND FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED PUBLIC SAFETY/POLICE DEPT. EXPENSES RETIREMENT 01-210-72-00-6500 IMRF PARTICIPANTS 956.91 8,996.40 10, 101.00 89.0 01-210-72-00-6501 SOCIAL SECURITY & MEDICARE 12,743.63 108,713.94 102, 575.00 105.9 01-210-72-00-6502 POLICE PENSION 0.00 206,231.47 207,000.00 99.6 TOTAL RETIREMENT 13,700.54 323, 941.81 319, 676.00 101.3 CAPITAL OUTLAY 01-210-75-00-7002 COMPUTER EQUIP & SOFTWARE 2,308.00 8, 430.99 8,500.00 99.1 TOTAL CAPITAL OUTLAY 2, 308.00 8, 430. 99 8, 500.00 99.1 OTHER OPERATING EXPENSES 01-210-78-00-9004 BIKE PATROL 611.92 1,002.77 2,000.00 50.1 TOTAL OTHER OPERATING EXPENSES 611.92 1,002.77 2,000.00 50.1 TRANSFERS 01-210-99-00-9910 TRANSFER TO PD CAPITAL FUND 75,035.00 102,035.00 102,035.00 100.0 TOTAL TRANSFERS 75,035.00 102,035.00 102,035.00 100.0 TOTAL EXPENSES: PUBLIC SAFETY/POLICE DEPT. 314, 141.97 2,065, 416.23 2,035, 614 .00 101.4 BUILDING & ZONING EXPENSES PROFESSIONAL SERVICES 01-220-61-00-5300 LEGAL SERVICES 11, 650.00 55, 615.34 50,000.00 111.2 TOTAL PROFESSIONAL SERVICES 11, 650.00 55, 615.34 50,000.00 111.2 CONTRACTUAL SERVICES 01-220-62-00-5401 CONTRACTUAL SERVICES 66,885.71 182,491.88 190,000.00 96.0 01-220-62-00-5430 PLANNING CONSULTANT 6,286.50 44, 297.13 48, 000.00 92.2 P9 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 10 DIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED BUILDING & ZONING EXPENSES CONTRACTUAL SERVICES 01-220-62-00-5432 ECONOMIC DEVELOPMENT 0.00 45,000.00 45,000.00 100.0 TOTAL CONTRACTUAL SERVICES 73,172.21 271,789.01 283,000.00 96.0 PROFESSIONAL DEVELOPMENT 01-220-64-00-5600 DUES 0.00 100.00 200.00 50.0 TOTAL PROFESSIONAL DEVELOPMENT 0.00 100.00 200.00 50.0 OPERATIONS 01-220-65-00-5804 OPERATING SUPPLIES 337.80 1, 666.42 1,800.00 92.5 01-220-65-00-5809 PRINTING & COPYING 183.11 697.02 700.00 99.5 01-220-65-00-5810 PUBLISHING & ADVERTISING 404.81 7,215.47 8,000.00 90.1 01-220-65-00-5814 BOOKS & MAPS 0.00 1, 148.50 3,000.00 38.2 TOTAL OPERATIONS 925.72 10,727.41 13,500.00 79.4 TOTAL EXPENSES: BUILDING & ZONING 85,747.93 338,231.76 346,700.00 97.5 STREETS EXPENSES PERSONNEL SERVICES 01-410-50-00-5107 SALARIES - EMPLOYEE 18,273.86 155,791.31 156, 643.00 99.4 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 866.79 14,007.69 18,000.00 77.8 TOTAL PERSONNEL SERVICES 19,140.65 172,137.50 180,143.00 95.5 PROFESSIONAL SERVICES 01-410-61-00-5313 ENGINEERING - IN TOWN RD PROG 45,227.15 49,496.10 120,000.00 41.2 01-410-61-00-5314 INSPECTIONS & LICENSES 0.00 20.00 100.00 20.0 TOTAL PROFESSIONAL SERVICES 45,227.15 49,516.10 120,100.00 41.2 p1 ^ DATE: 06/01/20._ UNITED CITY OF _ .VILLE P. 11 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED STREETS CONTRACTUAL SERVICES 01-410-62-00-5401 CONTRACTUAL SERVICES 100.00 1,275.00 2,000.00 63.7 01-410-62-00-5408 MAINTENANCE-EQUIPMENT 1,585.08 6, 953.67 10,000.00 69.5 01-410-62-00-5409 MAINTENANCE-VEHICLES 406.94 8,091.21 11,000.00 73.5 01-410-62-00-5414 MAINTENANCE-TRAFFIC SIGNALS 343.90 11,733.54 22,000.00 53.3 01-410-62-00-5415 MAINTENANCE-STREET LIGHTS (585.27) 17, 101.77 20,500.00 83.4 01-410-62-00-5420 MAINTENANCE-STORM SEWER 0.00 2,716.25 5,000.00 54.3 01-410-62-00-5421 WEARING APPAREL 767.96 4,779.09 5,800.00 82.3 01-410-62-00-5434 RENTAL-EQUIPMENT 0.00 600.00 1, 500.00 40.0 01-410-62-00-5435 ELECTRICITY 6,283.14 50,224.16 47,000.00 106.6 01-410-62-00-5438 CELLULAR TELEPHONE 232.32 1,884.80 2,600.00 72.4 01-410-62-00-5440 STREET LIGHTING 0.00 0.00 4,500.00 0.0 TOTAL CONTRACTUAL SERVICES 9, 134.07 105, 359.49 131, 900.00 79.8 PROFESSIONAL DEVELOPMENT 01-410-64-00-5604 TRAINING & CONFERENCES 997.95 1,549.96 5,600.00 27.6 TOTAL PROFESSIONAL DEVELOPMENT 997.95 1,549.96 5, 600.00 27.6 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 413.06 5,499.85 9, 500.00 57.8 01-410-65-00-5812 GASOLINE 2, 660.88 19, 400.13 20,000.00 97.0 01-410-65-00-5815 HAND TOOLS 0.00 292.14 1,500.00 19.4 01-410-65-00-5817 GRAVEL 780.97 2,296.98 5,500.00 41.7 TOTAL OPERATIONS 3,854.91 27, 489.10 36,500.00 75.3 RETIREMENT 01-410-72-00-6500 IMRF PARTICIPANTS 1,558.05 16, 516.54 17,587.00 93.9 01-410-72-00-6501 SOCIAL SECURITY & MEDICARE 1,464.29 13, 624.00 13,780.00 98.8 TOTAL RETIREMENT 3,022.34 30,140.54 31,367.00 96.0 CAPITAL OUTLAY P11 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 12 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED STREETS EXPENSES CAPITAL OUTLAY 01-410-75-00-5418 MOSQUITO CONTROL 6,765.20 23,334.15 27,572.00 84.6 01-410-75-00-5419 MAINT SUPPLIES - STREET 3,566.55 9,748.66 15,000.00 64.9 01-410-75-00-7004 SAFETY EQUIPMENT 349.20 953.76 1,000.00 95.3 01-410-75-00-7099 BRISTOL RIDGE ROAD 0.00 1,338,281.88 2, 690,000.00 49.7 01-410-75-00-7100 STREET REHAB PROJECTS 0.00 201,315.12 234,000.00 86.0 01-410-75-00-7101 IN TOWN ROAD PROGRAM 0.00 18,741.85 521,896.00 3.5 01-410-75-00-7102 TREE & STUMP REMOVAL 150.00 7,860.00 30,000.00 26.2 01-410-75-00-7103 SIDEWALK CONSTRUCTION 0.00 20,814.01 35,000.00 59.4 01-410-75-00-7104 FOX HILL SSA EXPENSES 0.00 740.60 0.00 (100.0) TOTAL CAPITAL OUTLAY 10,830.95 1, 621,790.03 3,554,468.00 45.6 TOTAL EXPENSES: STREETS 92,208.02 2,007,982.72 4,060,078.00 49.4 HEALTH & SANITATION EXPENSES CONTRACTUAL SERVICES 01-540-62-00-5442 GARBAGE SERVICES 88, 105.69 506,060.63 502,000.00 100.8 01-540-62-00-5443 LEAF PICKUP 0.00 5, 120.00 4,000.00 128.0 TOTAL CONTRACTUAL SERVICES 88,105.69 511,180.63 506,000.00 101.0 TOTAL EXPENSES: HEALTH & SANITATION 88,105.69 511,180.63 506,000.00 101.0 TOTAL FUND REVENUES 844,790.19 10,090,556.07 11,439,115.00 88.2 TOTAL FUND EXPENSES 1,297,453.65 9,338,493.22 11,439, 115.00 81.6 FUND SURPLUS (DEFICIT) (452, 663.46) 752,062.85 0.00 100.0 P1 n DATE: 06/01/20u_ UNITED CITY OF '1 .VILLE Pt. 13 DIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: MOTOR FUEL TAX FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL 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 0.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 0.00 643,066.62 768,245.00 83.7 INTEREST 15-000-46-00-4600 INVESTMENT INCOME 2, 617.17 6,217.41 5,000.00 124.3 TOTAL INTEREST 2, 617.17 6,217.41 5,000.00 124.3 TOTAL REVENUES: 2, 617.17 649,284 .03 773,245.00 83.9 EXPENSES OPERATIONS 15-000-65-00-5800 CONTINGENCY 0.00 68,004 .95 372,833.00 18.2 15-000-65-00-5818 SALT 2, 191.88 41,340.73 37,000.00 111.7 TOTAL OPERATIONS 2, 191.88 109,345.68 409,833.00 26.6 CAPITAL OUTLAY 15-000-75-00-7007 SIGNS 440.88 9,153.80 9,700.00 94.3 15-000-75-00-7008 CRACK FILLING 0.00 24, 122.58 25,000.00 96.4 15-000-75-00-7107 CONSTRUCTION ENGINEERING 0.00 76, 351.30 200,000.00 38.1 15-000-75-00-7108 VAN EMMON STREET 0.00 62, 622.63 62, 625.00 99.9 15-000-75-00-7110 COLD PATCH 478.91 2, 419.67 4,000.00 60.4 15-000-75-00-7111 HOT PATCH 0.00 3,558.06 7,000.00 50.8 15-000-75-00-7112 FAXON ROAD ENGINEERING 5, 460.00 5, 460.00 45, 500.00 12.0 TOTAL CAPITAL OUTLAY 6,379.79 183, 688.04 353,825.00 51.9 TRANSFERS 15-000-99-00-9960 TRANSFER TO FOX IND FUND 9, 587.00 9, 587.00 9, 587.00 100.0 TOTAL TRANSFERS 9, 587.00 9, 587.00 9,587.00 100.0 P13 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 14 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: MOTOR FUEL TAX FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL EXPENSES: 18,158.67 302, 620.72 773,245.00 39.1 TOTAL FUND REVENUES 2, 617.17 649,284.03 773,245.00 83.9 TOTAL FUND EXPENSES 18,158.67 302, 620.72 773,245.00 39.1 FUND SURPLUS (DEFICIT) (15,541.50) 346, 663.31 0.00 100.0 P1 DATE: 06/01/20, UNITED CITY OF _,VILLE P.. 15 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: MUNICIPAL BUILDLING FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL 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 3,750.00 140,200.00 140,000.00 100.1 TOTAL CHARGES FOR SERVICES 3,750.00 140,200.00 140,000.00 100.1 TRANSFERS 16-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 97,000.00 97,000.00 100.0 TOTAL TRANSFERS 0.00 97,000.00 97,000.00 100.0 TOTAL REVENUES: 3,750.00 237,200.00 237,000.00 100.0 EXPENSES CONTRACTUAL SERVICES 16-000-62-00-5416 MAINT-GENERAL BLDG & GROUNDS 333.75 4,792.03 5,000.00 95.8 TOTAL CONTRACTUAL SERVICES 333.75 4,792.03 5,000.00 95.8 CAPITAL OUTLAY 16-000-75-00-7008 ENTRY WAY SIGNS 0.00 0.00 3, 600.00 0.0 16-000-75-00-7200 BLDG IMPROV- BEEHCER/RIVFRNT 9,219.56 16,159.58 15,000.00 107.7 16-000-75-00-7202 BLDG IMPROVEMENTS-CITY HALL 0.00 0.00 0.00 0.0 16-000-75-00-7203 BLDG IMPROVEMENTS-PUBLIC WORKS 150.00 4,825.62 9,000.00 53.6 16-000-75-00-7204 BLDG MAINT - CITY HALL 2, 561.01 76,083.55 73,000.00 104.2 16-000-75-00-7205 BLDG IMPROVEMENTS-LIBRARY 0.00 3,772.50 4,000.00 94.3 16-000-75-00-7206 LANDSCAPING-PUBLIC BUILDINGS 0.00 1,294.15 2,000.00 64.7 16-000-75-00-7209 BEECHER PARKING LOT 0.00 2, 457.12 45,000.00 5.4 TOTAL CAPITAL OUTLAY 11,930.57 104,592.52 151, 600.00 68.9 P15 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 16 DIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: MUNICIPAL BUILDLING FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED OTHER 16-000-78-00-9009 RESERVE 0.00 0.00 80,400.00 0.0 TOTAL OTHER 0.00 0.00 80,400.00 0.0 TOTAL EXPENSES: 12,264.32 109,384.55 237,000.00 46.1 TOTAL FUND REVENUES 3,750.00 237,200.00 237,000.00 100.0 TOTAL FUND EXPENSES 12,264.32 109,384.55 237,000.00 46.1 FUND SURPLUS (DEFICIT) (8,514.32) 127,815.45 0.00 100.0 P" DATE: 06/01/21, UNITED CITY OF - .(VILLE P. . 17 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: POLICE EQUIPMENT CAPITAL FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL 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,250.00 72,300.00 75,000.00 96.4 TOTAL CHARGES FOR SERVICES 5,250.00 72,300.00 75,000.00 96.4 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 100.00 2,000.00 2,000.00 100.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 27, 457.50 30,000.00 91.5 20-000-44-00-4431 SALE OF POLICE SQUADS 0.00 0.00 1,000.00 0.0 TOTAL MISCELLANEOUS 100.00 31,544.50 35,200.00 89.6 OTHER OPERATING RECEIPTS 20-000-48-00-4800 LOAN PROCEEDS 0.00 0.00 0.00 0.0 TOTAL OTHER OPERATING RECEIPTS 0.00 0.00 0.00 0.0 TRANSFERS 20-000-49-00-4901 TRANSFER FROM GENERAL FUND 61, 535.00 102,035.00 102,035.00 100.0 TOTAL TRANSFERS 61,535.00 102,035.00 102,035.00 100.0 TOTAL REVENUES: 66,885.00 282,597.50 288, 953.00 97.8 EXPENSES WEAPONS 20-000-65-00-5811 LETHAL/NON-LETHAL WEAPONS 2,087.25 6,492.59 6,500.00 99.8 TOTAL WEAPONS 2,087.25 6,492.59 6,500.00 99.8 P17 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 18 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: POLICE EQUIPMENT CAPITAL FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED CAPITAL OUTLAY 20-000-75-00-7001 EQUIPMENT 45, 695.00 63, 628.08 66,551.00 95.6 20-000-75-00-7002 K-9 EQUIPMENT 77.45 1,388.72 1,700.00 81.6 20-000-75-00-7003 EXPEDITION AND ACCESSORIES 0.00 0.00 0.00 0.0 20-000-75-00-7005 VEHICLES 7,057.90 44,495.00 45,500.00 97.7 20-000-75-00-7006 CAR BUILD OUT 0.00 23,241.24 23,360.00 99.4 20-000-75-00-7008 NEW WEATHER WARNING SIRENS 0.00 0.00 0.00 0.0 TOTAL CAPITAL OUTLAY 52,830.35 132,753.04 137,111.00 96.8 OTHER 20-000-78-00-9009 RESERVE 0.00 0.00 0.00 0.0 20-000-78-00-9010 RESERVE-WEATHER WARNING SIREN 0.00 0.00 72,190.00 0.0 TOTAL OTHER 0.00 0.00 72,190.00 0.0 TRANSFERS 20-000-99-00-9965 TRANSFER TO DEBT SERV FUND 0.00 73,152.00 73,152.00 100.0 TOTAL TRANSFERS 0.00 73,152.00 73,152.00 100.0 TOTAL EXPENSES: 54,917.60 212,397.63 288, 953.00 73.5 TOTAL FUND REVENUES 66,885.00 282,597.50 288, 953.00 97.8 TOTAL FUND EXPENSES 54,917.60 212,397.63 288,953.00 73.5 FUND SURPLUS (DEFICIT) 11, 967.40 70,199.87 0.00 100.0 P1 )ATE: 06/01/20u_ UNITED CITY OF ...VILLE PA 19 LIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 [D: GL470002.WOW FUND: PUBLIC WORKS EQUIP CAPITAL FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL 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 15,350.00 212,218.00 220,000.00 96.4 TOTAL CHARGES FOR SERVICES 15,350.00 212,218.00 220,000.00 96.4 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 50,000.00 50,000.00 100.0 21-000-49-00-4920 TRANSFER FROM SEWER FUND 0.00 30,000.00 30,000.00 100.0 TOTAL TRANSFERS 0.00 80,000.00 80,000.00 100.0 TOTAL REVENUES: 15,350.00 568,782.11 576,564.00 98.6 EXPENSES CAPITAL OUTLAY 21-000-75-00-7005 VEHICLES 0.00 169, 949.27 176,905.00 96.0 21-000-75-00-7006 F150 PICK UPS 0.00 0.00 0.00 0.0 21-000-75-00-7007 5 YARD DUMP 0.00 0.00 0.00 0.0 21-000-75-00-7008 WATER DEPT PICK UP 0.00 0.00 0.00 0.0 21-000-75-00-7009 1 TON DUMP 0.00 0.00 0.00 0.0 21-000-75-00-7010 POWER BREAKER 0.00 0.00 0.00 0.0 21-000-75-00-7015 SKIDSTEER UPGRADE 0.00 3,250.00 3,500.00 92.8 21-000-75-00-7100 BOB CAT EXCHANGE 0.00 0.00 0.00 0.0 21-000-75-00-7107 TRUCK ACCESSORIES 0.00 1,550.00 5,000.00 31.0 21-000-75-00-7108 SKIDSTEE GRADER 0.00 6,250.00 6,300.00 99.2 P19 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 20 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: PUBLIC WORKS EQUIP CAPITAL FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL 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 144,505.00 144, 505.00 150,000.00 96.3 21-000-75-00-7130 PUBLIC WORKS BLDG ADDITION 0.00 0.00 90,000.00 0.0 TOTAL CAPITAL OUTLAY 144,505.00 346,504.27 488,262.00 70.9 OTHER 21-000-78-00-9009 RESERVE 0.00 35,557.00 88,302.00 40.2 TOTAL OTHER 0.00 35,557.00 88,302.00 40.2 TOTAL EXPENSES: 144,505.00 382,061.27 576,564.00 66.2 TOTAL FUND REVENUES 15,350.00 568,782.11 576,564.00 98.6 TOTAL FUND EXPENSES 144,505.00 382,061.27 576,564.00 66.2 FUND SURPLUS (DEFICIT) (129, 155.00) 186,720.84 0.00 100.0 P,,' DATE: 06/01/21. UNITED CITY OF .VILLE E. 21 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.W0W FUND: PARKS & REC EQUIP CAPITAL FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL 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 60,000.00 96, 600.00 96, 600.00 100.0 22-000-49-00-4935 TRANSFER FROM LAND CASH 0.00 22,000.00 22,000.00 100.0 TOTAL TRANSFERS 60,000.00 118, 600.00 118,600.00 100.0 TOTAL REVENUES: 60,000.00 147, 473.00 149,373.00 98.7 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 86,861.00 30.9 22-610-75-00-7007 SOCCER GOALS 12' REPLACEMENT 0.00 0.00 0.00 0.0 22-610-75-00-7008 SOCCER GOALS 9' 0.00 0.00 0.00 0.0 22-610-75-00-7009 COMPUTER WORKSTATIONS (1,328.99) 7, 372.00 6,825.00 108.0 P21 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 22 DIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: PARKS & REC EQUIP CAPITAL FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL 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 6,143.00 7,863.00 9,000.00 87.3 22-610-75-00-7012 PLAYGROUNDS 3,114.40 3, 114.40 4,000.00 77.8 22-610-75-00-7013 PLAYGROUND REPAIRS 1,720.00 1,990.00 2,000.00 99.5 22-610-75-00-7014 SIGN REPLACEMENTS 0.00 347.00 3,000.00 11.5 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 2, 108.99 6,198.53 6,600.00 93.9 TOTAL CAPITAL OUTLAY 11,757.40 83,083.20 147, 623.00 56.2 TOTAL EXPENSES: PARKS 11,757.40 83,083.20 147,623.00 56.2 TOTAL FUND REVENUES 60,000.00 147,473.00 149,373.00 98.7 TOTAL FUND EXPENSES 11,757.40 83,083.20 149,373.00 55.6 FUND SURPLUS (DEFICIT) 48,242.60 64,389.80 0.00 100.0 Pr )ATE: 06/01/20. UNITED CITY OF _ VILLE P. 23 'IME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 CD: GL470002.WOW FUND: SANITARY SEWER IMPROVEMENT FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED 2EVENUES 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 62, 900.00 621,000.00 1,071,200.00 57.9 37-000-42-00-4221 RIVER CROSSING FEES 682.80 21, 194 .55 20,000.00 105.9 TOTAL CHARGES FOR SERVICES 63,582.80 642,194.55 1,091,200.00 58.8 INTEREST 37-000-46-00-4600 INVESTMENT INCOME 18,214.66 67,777.78 65,000.00 104.2 TOTAL INTEREST 18,214 .66 67,777.78 65,000.00 104.2 OTHER OPERATING RECEIPTS 37-000-48-00-4800 COMED/HYDRAULIC DEBT CERT. 0.00 0.00 0.00 0.0 37-000-48-00-4801 BRUELL ST. DEBT CERT. PROCEEDS 0.00 0.00 0.00 0.0 37-000-48-00-4802 COUNTRYSIDE INTERCEPT. ALT REV 0.00 0.00 0.00 0.0 37-000-48-00-4803 ROB ROY CREEK REVENUE 100,000.00 859,750.00 920,000.00 93.4 37-000-48-00-4804 SOUTHWEST SVC AREA INTERCEPTOR (54,000.00) (1,570.28) 460,000.00 (0.3) TOTAL OTHER OPERATING RECEIPTS 46,000.00 858, 179.72 1,380,000.00 62.1 TRANSFERS 37-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 150,000.00 150,000.00 100.0 TOTAL TRANSFERS 0.00 150,000.00 150,000.00 100.0 TOTAL REVENUES: 127,797.46 11, 177, 961.05 12, 146,009.00 92.0 EXPENSES CONTRACTUAL SERVICES 37-000-62-00-5401 CONTRACTURAL/PROFESSIONAL SERV 2,050.00 4,899.07 40,000.00 12.2 P23 )ATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 24 FIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: SANITARY SEWER IMPROVEMENT FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL $ ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED SXPENSES CONTRACTUAL SERVICES 37-000-62-00-5402 ENG/LGL/CONTINGNCY-COUNTRYSIDE 10,752.88 500,366.93 800,000.00 62.5 37-000-62-00-5405 ENG/LGL/CONTINGENCY-BRUELL ST. 21,307.52 277,120.03 500,000.00 55.4 37-000-62-00-5406 ENG/LGL/CONTINGENCY-HYDRAULIC (2, 680.05) 124, 420.41 666, 625.00 18.6 37-000-62-00-5407 ENG/LGL/CONTING ROB ROY CREEK 0.00 0.00 0.00 0.0 TOTAL CONTRACTUAL SERVICES 31,430.35 906,806.44 2,006, 625.00 45.1 OTHER 37-000-65-00-5421 GIS SYSTEM 0.00 0.00 15,000.00 0.0 37-000-65-00-5800 CONTINGENCY 0.00 9,004.57 44, 156.00 20.3 TOTAL OTHER 0.00 9,004.57 59,156.00 15.2 CAPITAL OUTLAY 37-000-75-00-7109 CONTRACTUAL/PROFESSIONAL SVC 0.00 0.00 0.00 0.0 37-000-75-00-7502 HYDRAULIC INTERCEPTOR 0.00 1,835,707.22 1,847,778.00 99.3 37-000-75-00-7503 COUNTRYSIDE INTERCEPTOR 317.20 17,224.45 2,903,411.00 0.5 37-000-75-00-7504 BRUELL STREET LIFT STATION 828.29 909,361.49 1,435,735.00 63.3 37-000-75-00-7505 ROB ROY CREEK SANITARY 266, 697.35 2, 136,772.91 1,965,000.00 108.7 37-000-75-00-7506 SOUTHWEST SVC AREA INTERCEPTOR 0.00 38,750.00 460,000.00 8.4 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 600,000.00 600,000.00 100.0 TOTAL CAPITAL OUTLAY 267,842.84 5,762,744.07 9,436, 924.00 61.0 TRANSFERS 37-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 200,000.00 200,000.00 100.0 37-000-99-00-9965 TRANSFER TO DEBT SERVICE 0.00 443,304.00 443,304.00 100.0 TOTAL TRANSFERS 0.00 643,304.00 643,304.00 100.0 TOTAL EXPENSES: 299,273.19 7,321,859.08 12, 146,009.00 60.2 TOTAL FUND REVENUES 127,797.46 11, 177,961.05 12,146,009.00 92.0 TOTAL FUND EXPENSES 299,273.19 7,321,859.08 12,146,009.00 60.2 FUND SURPLUS (DEFICIT) (171,475.73) 3,856,101.97 0.00 100.0 PI" DATE: 06/01/20u UNITED CITY OF '� _.VILLE PA 25 PINE: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL 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 58,420.00 582, 140.00 1,000,000.00 58.2 41-000-42-00-4221 SOUTHWEST WATER MAIN REVENUE 0.00 71,931.28 180,000.00 39.9 TOTAL CHARGES FOR SERVICES 58,420.00 654,071.28 1, 180,000.00 55.4 MISCELLANEOUS 41-000-44-00-4490 MISCELLANEOUS INCOME 0.00 62, 980.25 62,980.00 100.0 TOTAL MISCELLANEOUS 0.00 62,980.25 62,980.00 100.0 INTERGOVERNMENTAL 41-000-45-00-4530 RADIUM GRANT 0.00 950,200.00 950,000.00 100.0 TOTAL INTERGOVERNMENTAL 0.00 950,200.00 950,000.00 100.0 INTEREST 41-000-46-00-4600 INVESTMENT INCOME 27,484.48 77,397.10 65,000.00 119.0 TOTAL INTEREST 27, 484.48 77,397.10 65,000.00 119.0 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 (225.00) (225.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 (225.00) (225.00) 4, 400,000.00 0.0 TRANSFERS 41-000-49-00-4915 TRANSFER FROM WATER FUND 0.00 70,000.00 70,000.00 100.0 P25 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 26 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL TRANSFERS 0.00 70,000.00 70,000.00 100.0 TOTAL REVENUES: 85, 679.48 4,201, 666.63 9,115,223.00 46.0 EXPENSES PROFESSIONAL SERVICE 41-000-61-00-5300 LEGAL SERVICES 664.20 1,414.20 5,000.00 28.2 41-000-61-00-5301 ENGINEERING - GENERAL SERVICES 2, 638.50 22,045.50 25,000.00 88.1 41-000-61-00-5400 RADIUM COMPLIANCE -CONTRACT B 202.40 202.40 3, 662,730.00 0.0 41-000-61-00-5401 ENGINEERING-RADIUM CONTRACT B 2, 618.00 35,359.00 476,155.00 7.4 41-000-61-00-5405 PROF. SVCS- RADIUM CONTRACT B 3,735.00 10, 613.25 261,115.00 4.0 41-000-61-00-5408 CENTRAL ZONE - CONTRACT C 290,025.25 2,355,335.29 2,408,625.00 97.7 41-000-61-00-5410 ENGINEERING-CENTRAL ZONE 5,844.00 125,061.31 130,000.00 96.2 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 0.00 26,209.00 24,490.00 107.0 41-000-61-00-5416 USGS GROUNDWATER COUNTYWIDE 0.00 5,360.00 8,260.00 64.8 41-000-61-00-5417 USGS GROUNDWATER SHALLOW WATER 15,036.00 16,020.00 29,750.00 53.8 TOTAL PROFESSIONAL SERVICE 320,763.35 2,599,724.19 7,033, 625.00 36.9 OTHER 41-000-65-00-5421 GIS SYSTEM 0.00 0.00 20,000.00 0.0 41-000-65-00-5800 CONTINGENCY 931.30 151,981.05 151,969.00 100.0 TOTAL OTHER 931.30 151,981.05 171,969.00 88.3 DEBT SERVICE 41-000-66-00-6012 DEBT CERTIFICATE EXPENSES 0.00 0.00 0.00 0.0 TOTAL DEBT SERVICE 0.00 0.00 0.00 0.0 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 44,379.97 1,089,353.50 1,085,243.00 100.3 41-000-75-00-7505 JOHNSON STREET WATER MAIN 0.00 1,053.60 0.00 (100.0) P" DATE: 06/01/20, UNITED CITY OF .,VILLE Pi, . 27 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.W0W FUND: WATER IMPROV. EXPANSION FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES CAPITAL OUTLAY 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 44,382.86 44,000.00 100.8 41-000-75-00-7515 JOHNSON STREET WATER MAIN 0.00 36, 123.35 36,023.00 100.2 TOTAL CAPITAL OUTLAY 44, 379.97 1, 172, 155.31 1, 345, 266.00 87.1 TRANSFERS 41-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 200,000.00 200,000.00 100.0 41-000-99-00-9965 TRANSFER TO DEBT FUND 0.00 364, 363.00 364,363.00 100.0 TOTAL TRANSFERS 0.00 564, 363.00 564,363.00 100.0 TOTAL EXPENSES: 366,074.62 4,488,223.55 9,115,223.00 49.2 TOTAL FUND REVENUES 85, 679.48 4,201, 666.63 9,115,223.00 46.0 TOTAL FUND EXPENSES 366,074.62 4,488,223.55 9, 115,223.00 49.2 FUND SURPLUS (DEFICIT) (280,395.14) (286,556.92) 0.00 100.0 P27 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 28 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: DEBT SERVICE FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL 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 3,304.00 128, 924.43 115,000.00 112.1 TOTAL MISCELLANEOUS 3,304.00 128,924.43 115,000.00 112.1 TRANSFERS 42-000-49-00-4901 TRANSFER FROM GENERAL FUND 2,495.00 17,078.00 17,078.00 100.0 42-000-49-00-4910 TRANSFER FROM POLICE EQUIP CAP 0.00 73,152.00 73, 152.00 100.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 443,304.00 443,304.00 100.0 42-000-49-00-4930 TRANSFER FROM WATER IMPRV FUND 0.00 364,363.00 364,363.00 100.0 TOTAL TRANSFERS 2,495.00 897,897.00 897,897.00 100.0 TOTAL REVENUES: 5,799.00 1,042,361.43 1,028,437.00 101.3 EXPENSES DEBT SERVICE 42-000-66-00-6001 CITY HALL BONDS-PRINCIPAL PMT 0.00 50,000.00 50,000.00 100.0 42-000-66-00-6002 CITY HALL BONDS - INTEREST PMT 0.00 54,997.50 54, 998.00 99.9 42-000-66-00-6003 IRBB-BRUELL ST. INTEREST PMTS 0.00 86,715.00 86,715.00 100.0 42-000-66-00-6004 IRBB-BRUELL ST. PRINCIPAL PYMT 0.00 80,000.00 80,000.00 100.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 0.00 339,362.82 339,363.00 99.9 42-000-66-00-6009 COUNTRYSIDE ALT REV INT PYMT 0.00 100,196.23 100, 196.00 100.0 42-000-66-00-6010 COMED/HYDRAULIC INTEREST PYMT 0.00 35,894.57 35,895.00 99.9 42-000-66-00-6050 LOAN PAYMENT-SANITARY SIPHON 0.00 38,979.98 38, 989.00 99.9 42-000-66-00-6051 LOAN PAYMENT-NORTH WTR/SWR-EDC 0.00 0.00 0.00 0.0 42-000-66-00-6052 LOAN PAYMENT-NORTH WTR/SWR-YNB 0.00 0.00 0.00 0.0 P'� DATE: 06/O1/2U UNITED CITY OF .VILLE P. 29 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: DEBT SERVICE FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL 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 107,050.70 107,051.00 99.9 42-000-66-00-6056 YNB-POLICE/ADMIN CARS 0.00 58, 781.10 58,764.00 100.0 42-000-66-00-6058 ROAD IMPROV. PROG. INT PYMT 27,355.63 27,355.63 27,356.00 99.9 TOTAL DEBT SERVICE 27, 355.63 1,028, 443.19 1,028,437.00 100.0 TOTAL FUND REVENUES 5,799.00 1,042,361.43 1,028,437.00 101.3 TOTAL FUND EXPENSES 27, 355. 63 1,028, 443. 19 1, 028, 437.00 100.0 FUND SURPLUS (DEFICIT) (21, 556.63) 13,918.24 0.00 100.0 P29 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 30 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL 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 850.00 11,382.64 9,000.00 126.4 51-000-42-00-4241 WATER SALES 154,079.66 1,001,552.39 950,000.00 105.4 51-000-42-00-4242 WATER METER SALES 18,025.00 155,854.20 130,000.00 119.8 51-000-42-00-4243 LEASE REVENUE - H2O TOWER 1,854.00 21,762.00 21, 600.00 100.7 TOTAL CHARGES FOR SERVICES 174,808.66 1,190,551.23 1,110, 600.00 107.1 MISCELLANEOUS 51-000-44-00-4490 MISCELLANEOUS INCOME 340.02 3,136.98 500.00 627.3 TOTAL MISCELLANEOUS 340.02 3,136.98 500.00 627.3 INTEREST 51-000-46-00-4600 INVESTMENT INCOME (898.75) 12,877.54 8,000.00 160.9 TOTAL INTEREST (898.75) 12,877.54 8,000.00 160.9 TOTAL REVENUES: 174,249.93 2,746,983.75 2, 659,518.00 103.2 EXPENSES PERSONNEL 51-000-50-00-5107 SALARIES - EMPLOYEE 27,315.88 213,349.72 223,465.00 95.4 51-000-50-00-5136 SALARIES-PART TIME 0.00 6,052.40 4,000.00 151.3 51-000-50-00-5137 SALARIES - OVERTIME 4,288.54 37,166.17 27,000.00 137.6 TOTAL PERSONNEL 31, 604.42 256,568.29 254,465.00 100.8 PROFESSIONAL SERVICES 51-000-61-00-5300 LEGAL SERVICES 0.00 9,877.94 2,000.00 493.8 P'A DATE: 06/01/2k_ UNITED CITY OF .VILLE P. 31 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES PROFESSIONAL SERVICES 51-000-61-00-5303 JULIE SERVICE 890.30 6, 406.10 6,000.00 106.7 TOTAL PROFESSIONAL SERVICES 890.30 16,284 .04 8,000.00 203.5 CONTRACTURAL SERVICES 51-000-62-00-5401 CONTRACUAL SERVICES 1, 604 .74 4,821.75 4,000.00 120.5 51-000-62-00-5407 TREATMENT FACILITIES O&M 20,392.41 27,477.95 44,000.00 62.4 51-000-62-00-5408 MAINTENANCE-EQUIPMENT 46.24 5,214.99 10,000.00 52.1 51-000-62-00-5409 MAINTENANCE - VEHICLES 53.81 2, 137.40 10,000.00 21.3 51-000-62-00-5411 MAINTENANCE-COMPUTERS 0.00 323.83 4,000.00 8.0 51-000-62-00-5413 MAINTENANCE-CONTROL SYSTEM 0.00 5, 919.48 8,000.00 73.9 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,746.24 5,500.00 31.7 51-000-62-00-5434 RENTAL - EQUIPMENT 0.00 640.00 1,000.00 64.0 51-000-62-00-5435 ELECTRICITY 19,857.86 102,357.58 170,000.00 60.2 51-000-62-00-5436 TELEPHONE 2,804 .17 21,041.35 20,000.00 105.2 51-000-62-00-5438 CELLULAR TELEPHONE 590.31 3, 671.78 5,500.00 66.7 TOTAL CONTRACTURAL SERVICES 45, 349.54 175, 816.35 283, 000.00 62.1 PROFESSIONAL DEVELOPMENT 51-000-64-00-5600 DUES 140.00 789.00 1,000.00 78.9 51-000-64-00-5603 SUBSCRIPTIONS 0.00 110.50 250.00 44.2 51-000-64-00-5604 TRAINING & CONFERENCES 350.00 2, 021.97 6, 900.00 29.3 51-000-64-00-5605 TRAVEL EXPENSES 832.85 1, 956.29 2,000.00 97.8 TOTAL PROFESSIONAL DEVELOPMENT 1, 322.85 4,877.76 10,150.00 48.0 OPERATIONS 51-000-65-00-5800 CONTINGENCIES 7, 110.00 7, 167.63 29,276.00 24 .4 51-000-65-00-5804 OPERATING SUPPLIES 3,083.60 29,780.16 44,000.00 67.6 51-000-65-00-5808 POSTAGE & SHIPPING 2,298.37 11, 384.64 11,700.00 97.3 51-000-65-00-5809 PRINTING & COPYING 1, 987.98 8,866.01 5,000.00 177.3 51-000-65-00-5810 PUBLISHING & ADVERTISING 0.00 0.00 1, 000.00 0.0 51-000-65-00-5812 GASOLINE 2, 400.13 12,194.11 8,700.00 140.1 P31 DATE: 06/01/2005 UNITED CITY OF YORKVILLE TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT PAGE: 32 ID: GL470002.WOW F-YR: 05 FUND: WATER OPERATIONS FOR 12 PERIODS ENDING APRIL 30, 2005 ACCOUNT FISCAL FISCAL $ APRIL YEAR-TO-DATE NUMBER DESCRIPTION UDGE COLLECTED/ ACTUAL ACTUAL BUDGET EXPENDED EXPENSES OPERATIONS 51-000-65-00-5815 HAND TOOLS 0.00 86.00 51-000-65-00-5817 GRAVEL 1,000.00 8.6 0.00 808.45 5,000.00 16.1 51-000-65-00-5819 CHLORINE 0.00 0.00 51-000-65-00-5820 CHEMICALS 0.00 0.0 1, 636.00 5,932.03 27,232.00 21.7 51-000-65-00-5821 CATHODIC PROTECTION 0.00 0.00 51-000-65-00-5822 WATER SAMPLES 2,500.00 5,240.00 12,483.00 12,000.00 104 .0.0 TOTAL OPERATIONS 23,757.03 88,702.03 147,408.00 60.1 RETIREMENT 51-000-72-00-6500 IMRF PARTICIPANTS 2,572.61 24,249.60 24, 606.00 98.5 51-000-72-00-6501 SOCIAL SECURITY & MEDICARE 2,509.50 20,784.33 19,788.00 105.0 TOTAL RETIREMENT 5,082.11 45,033.93 44,394.00 101.4 CAPITAL OUTLAY 51-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 2,078.11 51-000-75-00-7004 SAFETY EQUIPMENT 4,000.00 36.9 0.10 739.00 2,000.00 36.9 51-000-75-00-7506 METER READERS 1,199.13 11,855.96 10,320.00 114.8 51-000-75-00-7507 HYDRANT REPLACEMENT 0.00 7, 661.00 51-000-75-00-7508 METERS & PARTS10,000.00 1 .9 25,449.79 149,415.53 130,000.00 1144.9 TOTAL CAPITAL OUTLAY 26, 648.92 171,749.60 156,320.00 109.8 OTHER 51-000-78-00-9005 REFUND 0.00 2, 970.00 51-000-78-00-9008 RESERVE-H20 TOWER MAINTENANCE 1,500.00 198.0 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 2, 970.00 1,435,781.00 0.2 TRANSFERS 51-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 200,000.00 51-000-99-00-9930 TRANSFER TO WATER IMPRV FUND 270,000.00 100.0 0.00 70,000.00 70,000.00 100.0 51-000-99-00-9950 TRANSFER TO PW EQUIP CAPITAL 0.00 50,000.00 50,000.00 100.0 P3/ DATE: 06/01/26 UNITED CITY OF .VILLE P. 33 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL TRANSFERS 0.00 320,000.00 320,000.00 100.0 TOTAL EXPENSES: 134, 655.17 1,082,002.00 2, 659,518.00 40.6 TOTAL FUND REVENUES 174,249.93 2,746, 983.75 2, 659,518.00 103.2 TOTAL FUND EXPENSES 134, 655.17 1,082,002.00 2, 659,518.00 40.6 FUND SURPLUS (DEFICIT) 39,594.76 1, 664, 981.75 0.00 100.0 P33 DATE: 06/01/2005 UNITED CITY OF YORKVILLE TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT PAGE: 34 ID: GL470002.WOW F-YR: 05 FUND: SEWER MAINTENANCE FOR 12 PERIODS ENDING APRIL 30, 2005 ACCOUNT FISCAL FISCAL g NUMBER DESCRIPTION APRIL YEAR-TO-DATE YEAR COLLECTED/ ACTUAL ACTUAL BUDGET EXPENDED REVENUES CARRY OVER 52-000-40-00-3999 CARRY OVER/FUND BALANCE 0.00 478,506.00 478,506.00 100.0 TOTAL CARRY OVER 0.00 478,506.00 478,506.00 100.0 CHARGES FOR SERVICES 52-000-42-00-4250 SEWER MAINTENANCE FEES 79,735.14 52-000-42-00-4251 SEWER CONNNECTION FEES 422,051.64 350,000.00 120.5 7,800.00 90,650.00 96,800.00 93.6 TOTAL CHARGES FOR SERVICES 87,535.14 512,701.64 446,800.00 114.7 INTEREST 52-000-46-00-4600 INVESTMENT INCOME (873.74) 13,017.55 10,000.00 130.1 TOTAL INTEREST (873.74) 13,017.55 10,000.00 130.1 TOTAL REVENUES: 86, 661.40 1,004,225.19 935,306.00 107.3 EXPENSES PERSONNEL SERVICES 52-000-50-00-5108 SALARIES-REGULAR 11,841.60 101,709.16 52-000-50-00-5136 PART TIME 121,072.00 284.0 4.1 52-000-50-00-5137 SALARIES-OVERTIME 0.00 1,208.00 5,000.00 24.1 187.29 7,806.04 12,000.00 65.0 TOTAL PERSONNEL SERVICES 12,028.89 110,723.20 138,072.00 80.1 CONTRACTUAL SERVICES 52-000-62-00-5401 CONTRACTUAL SERVICES 812.00 1,792.00 2,000.00 1 52-000-62-00-5408 MAINTENANCE-EQUIPMENT4.3 (630. 52-000-62-00-5409 MAINTENANCE-VEHICLES 00) 1,220.59 8,500.00 12.6 660. 0 52-000-62-00-5419 MAINTENANCE-SANITARY SEWER973.40 5,000.00 12.6 52-000-62-00-5421 WEARING APPAREL 660.43 7, 973.43 14,500.00 68.0 590.70 3,062.79 2 52-000-62-00-5422 LIFT STATION MAINTENANCE ,000.00 68.0 850.00 18,850. 52-000-62-00-5434 RENTAL - EQUIPMENT 0 22,000.00 80.0 52-000-62-00-5435 ELECTRICITY 0.00 0.008 1,000.00 0.0 398.38 590.08 8,900.00 6.6 pp A DATE: 06/01/20 UNITED CITY OF .VILLE P. 35 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: SEWER MAINTENANCE FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES CONTRACTUAL SERVICES 52-000-62-00-5438 CELLULAR TELEPHONE 179.85 1,010.99 2,500.00 40.4 TOTAL CONTRACTUAL SERVICES 3, 962.75 35,138.52 73,400.00 47.8 PROFESSIONAL DEVELOPMENT 52-000-64-00-5604 TRAINING & CONFERENCES 0.00 155.00 1, 900.00 8.1 TOTAL PROFESSIONAL DEVELOPMENT 0.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 156.96 1,257.98 2,000.00 62.8 52-000-65-00-5804 OPERATING SUPPLIES 72.83 2, 433.98 8,000.00 30.4 52-000-65-00-5805 SHOP SUPPLIES 65.93 922.73 2,500.00 36.9 52-000-65-00-5812 GASOLINE 1,379.01 9,721.43 9,500.00 102.3 52-000-65-00-5815 HAND TOOLS 255.28 579.22 1,000.00 57.9 52-000-65-00-5817 GRAVEL 1,115.92 1,115.92 2,000.00 55.7 52-000-65-00-5823 SEWER CHEMICALS 565.98 4,134.06 8,000.00 51.6 TOTAL OPERATIONS 3, 611.91 25,547.32 43,000.00 59.4 RETIREMENT 52-000-72-00-6500 IMRF PARTICIPANTS 979.15 10,392.90 13,217.00 78.6 52-000-72-00-6501 SOCIAL SECURITY & MEDICARE 920.23 8, 541.02 10, 423.00 81.9 TOTAL RETIREMENT 1,899.38 18, 933.92 23, 640.00 80.0 CAPITAL OUTLAY 52-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 3, 108.36 4, 386.79 4, 000.00 109. 6 52-000-75-00-7003 OFFICE EQUIPMENT 474.06 5,214.17 6,000.00 86.9 52-000-75-00-7004 SAFETY EQUIPMENT 301.70 358.16 2,000.00 17.9 TOTAL CAPITAL OUTLAY 3,884.12 9, 959.12 12,000.00 82.9 OTHER P35 )ATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 36 DIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: SEWER MAINTENANCE FOR 12 PERIODS ENDING APRIL 30, 2005 ACCOUNT FISCAL FISCAL % APRIL 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 70,000.00 70,000.00 100.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 30,000.00 30,000.00 100.0 52-000-99-00-9965 TRANSFER TO DEBT SERVICE FUND 0.00 0.00 0.00 0.0 TOTAL TRANSFERS 0.00 100,000.00 100,000.00 100.0 TOTAL EXPENSES: 25,387.05 300,457.08 935,306.00 32.1 TOTAL FUND REVENUES 86, 661.40 1,004,225.19 935,306.00 107.3 TOTAL FUND EXPENSES 25,387.05 300,457.08 935,306.00 32.1 FUND SURPLUS (DEFICIT) 61,274.35 703,768.11 0.00 100.0 P1' DATE: 06/01/26 UNITED CITY OF ,VILLE P, 37 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: LAND CASH FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL 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 0.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 1, 538.00 15, 111.00 15,380.00 98.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 9,164.00 3,000.00 305.4 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 0.00 15,236.00 15,000.00 101.5 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 2,013.00 21, 472.00 20,130.00 106.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 1, 688.00 0.00 100.0 72-000-47-00-4719 WILDWOOD-LAND CASH 0.00 1,836.00 1,000.00 183.6 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 58, 170.00 50,000.00 116.3 72-000-47-00-4723 HEARTLAND CIRCLE-LAND CASH 7,000.00 44,000.00 30,000.00 146.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 49,716.43 100,000.00 49.7 72-000-47-00-4728 BRISBEN RESERVE-LAND CASH 0.00 0.00 0.00 0.0 P37 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 38 DIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 LD: GL470002.WOW FUND: LAND CASH FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL 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 6,202.79 25,000.00 24.8 72-000-47-00-4735 PRAIRIE MEADOWS (MENARD RES) 0.00 0.00 286,230.00 0.0 72-000-47-00-4736 CORNERSTONE 0.00 16,536.00 0.00 100.0 TOTAL CONTRIBUTIONS 14,706.00 293,926.22 674,501.00 43.5 TOTAL REVENUES: 14,706.00 988,191.82 1,368,767.00 72.1 EXPENSES CONTRACTUAL SERVICES 72-000-62-00-5408 MAINTENANCE-EQUIPMENT 0.00 0.00 0.00 0.0 TOTAL CONTRACTUAL SERVICES 0.00 0.00 0.00 0.0 CAPITAL OUTLAY 72-000-75-00-7007 SIGNS 0.00 0.00 0.00 0.0 72-000-75-00-7008 MISC. BALLFIELD EQUIP 0.00 0.00 0.00 0.0 72-000-75-00-7200 BLDG IMPROVE - BEECHER 0.00 0.00 0.00 0.0 72-000-75-00-7201 RIVERFGRONT EQUIP IMPROVEMENT 0.00 50,575.00 55,000.00 91.9 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 1,565.22 124, 957.33 125,000.00 99.9 72-000-75-00-7303 FOX HIGHLANDS 0.00 0.00 0.00 0.0 72-000-75-00-7304 SUNFLOWER 4,199.70 4,199.70 90,000.00 4.6 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 782.61 148,522.15 150,000.00 99.0 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 1,769.50 13,308.69 120,000.00 11.0 P30 )ATE: 06/01/20. UNITED CITY OF 1 VILLE Ph 39 CIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 [D: GL470002.WOW FUND: LAND CASH FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED :XPENSES 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 966.10 0.00 (100.0) 72-000-75-00-7322 BEECHER 0.00 0.00 0.00 0.0 72-000-75-00-7323 BLACKHAWK 0.00 0.00 0.00 0.0 72-000-75-00-7324 TOWN SQUARE 0.00 0.00 10,000.00 0.0 72-000-75-00-7325 VAN EMMON 0.00 0.00 0.00 0.0 72-000-75-00-7326 CORLANDS 0.00 0.00 0.00 0.0 72-000-75-00-7327 GRANDE RESERVE PARK DEV. 5,166.53 42,291.42 100,000.00 42.2 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 5,582.61 6,852.56 60,000.00 11.4 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 7,750.00 30,000.00 25.8 TOTAL CAPITAL OUTLAY 19,066.17 418, 956.70 788,000.00 53.1 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 0.00 22,000.00 22,000.00 100.0 72-000-99-00-9970 TRANSFER TO LAND ACQUISITION 0.00 100,000.00 100,000.00 100.0 TOTAL TRANSFERS 0.00 122, 000.00 122,000.00 100.0 P39 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 40 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: LAND CASH FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL EXPENSES: 19,066.17 545,755.87 1,368,767.00 39.8 TOTAL FUND REVENUES 14,706.00 988,191.82 1,368,767.00 72.1 TOTAL FUND EXPENSES 19,066.17 545,755.87 1,368,767.00 39.8 FUND SURPLUS (DEFICIT) (4,360.17) 442,435.95 0.00 100.0 P40 DATE: 06/01/26 UNITED CITY OF _ _,VILLE Pr. . 41 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: LAND ACQUISITION FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL 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 100,000.00 100,000.00 100.0 TOTAL CARRY OVER 0.00 114,078.00 114,078.00 100.0 TRANSFERS 73-000-49-00-4935 TRANSFER FROM LAND CASH 0.00 100,000.00 100,000.00 100.0 73-000-49-00-4937 TRANSFER FROM PARKS & REC 0.00 0.00 0.00 0.0 TOTAL TRANSFERS 0.00 100,000.00 . 100,000.00 100.0 TOTAL REVENUES: 0.00 214,078.00 214,078.00 100.0 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 214,078.00 214,078.00 100.0 TOTAL FUND EXPENSES 0.00 560.00 214,078.00 0.2 FUND SURPLUS (DEFICIT) 0.00 213, 518.00 0.00 100.0 P41 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 42 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL 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 9,398.50 157,247.42 155,125.00 101.3 79-000-42-00-4280 CONCESSIONS 328.35 9,390.60 10,000.00 93.9 79-000-42-00-4281 BEECHER BLDG DEPOSITS 100.00 5,895.00 3,500.00 168.4 79-000-42-00-4282 FARMERS MARKET 0.00 955.00 1,000.00 95.5 79-000-42-00-4285 VENDING MACHINE INCOME 43.08 684.86 650.00 105.3 79-000-42-00-4286 RENTAL INCOME 250.00 6,075.00 3,000.00 202.5 79-000-42-00-4287 RENTAL INCOME - SHELTERS 45.00 605.00 600.00 100.8 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 10,164.93 217,103.88 210, 126.00 103.3 MISCELLANEOUS 79-000-44-00-4400 DONATIONS (1,827.00) 16,753.00 12,000.00 139.6 79-000-44-00-4404 TREE DONATIONS 0.00 300.00 750.00 40.0 79-000-44-00-4490 MISCELLANEOUS INCOME 0.00 100.00 0.00 100.0 TOTAL MISCELLANEOUS (1,827.00) 17,153.00 12,750.00 134.5 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 0.00 1,000.00 3,500.00 28.5 TOTAL INTERGOVERNMENTAL 0.00 1,000.00 3, 500.00 28.5 INTEREST 79-000-46-00-4600 INVESTMENT INCOME 1, 926.05 3,486.03 1,500.00 232.4 TOTAL INTEREST 1,926.05 3,486.03 1,500.00 232.4 Pd" DATE: 06/01/2U UNITED CITY OF _ .MLLE P. . 43 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TRANSFERS 79-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 794,036.00 794,036.00 100.0 TOTAL TRANSFERS 0.00 794,036.00 794,036.00 100.0 TOTAL REVENUES: 10,263.98 1,058, 635.91 1,047,769.00 101.0 PARKS EXPENSES PERSONNAL SERVICES 79-610-50-00-5107 SALARIES-EMPLOYEES 35,718.76 248, 629.77 272,176.00 91.3 79-610-50-00-5136 SALARIES - PART-TIME 80.00 32,874.13 45,000.00 73.0 79-610-50-00-5137 SALARIES - OVERTIME 777.79 7,473.79 8,000.00 93.4 TOTAL PERSONNAL SERVICES 36,576.55 288, 977.69 325, 176.00 88.8 PROFESSIONAL SERVICES 79-610-61-00-5320 MASTER PLAN 271.59 9, 972.50 10,000.00 99.7 TOTAL PROFESSIONAL SERVICES 271.59 9, 972.50 10,000.00 99.7 CONTRACTUAL SERVICES 79-610-62-00-5405 PARK CONTRACTUAL 0.00 7, 641.54 10,000.00 76.4 79-610-62-00-5408 MAINTENANCE-EQUIPMENT 1, 317.15 5,773.29 5,000.00 115.4 79-610-62-00-5417 MAINTENANCE-PARKS 9, 421.76 33,011.08 30,000.00 110.0 79-610-62-00-5421 WEARING APPAREL 3,387.60 5,525.10 5,000.00 110.5 79-610-62-00-5425 ILLINOIS FIRST GRANT 0.00 0.00 0.00 0.0 79-610-62-00-5434 RENTAL-EQUIPMENT 0.00 1,475.99 1,500.00 98.3 79-610-62-00-5438 CELLULAR TELEPHONE 568.62 2,741.25 4,000.00 68.5 79-610-62-00-5440 LAND DEVELOPER 3,049.50 27,812.26 23,500.00 118.3 79-610-62-00-5445 LEGAL EXPENSES 412.50 1,710.00 4,000.00 42.7 TOTAL CONTRACTUAL SERVICES 18, 157.13 85, 690.51 83,000.00 103.2 PROFESSIONAL DEVELOPMENT P43 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 44 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED PARKS EXPENSES PROFESSIONAL DEVELOPMENT 79-610-64-00-5602 PROFESSIONAL GROWTH/SUBSCRPT 154.60 2,164.60 2,500.00 86.5 79-610-64-00-5605 TRAVEL EXPENSE 1.20 2, 687.69 2,000.00 134.3 79-610-64-00-5612 CONTINUING EDUCATION 272.49 1,732.06 3,000.00 57.7 TOTAL PROFESSIONAL DEVELOPMENT 428.29 6,584.35 7,500.00 87.7 OPERATIONS 79-610-65-00-5800 CONTINGENCIES 0.00 0.00 0.00 0.0 79-610-65-00-5802 OFFICE SUPPLIES 68.71 663.24 1,000.00 66.3 79-610-65-00-5804 OPERATING SUPPLIES 7,131.45 20, 167.92 20,000.00 100.8 79-610-65-00-5812 GASOLINE 0.00 0.00 2,000.00 0.0 79-610-65-00-5815 HAND TOOLS 384 .97 1,922.87 2,000.00 96.1 79-610-65-00-5824 CHRISTMAS DECORATIONS 2,203.74 3,998.13 4,000.00 99.9 79-610-65-00-5825 PUBLIC DECORATION 1,878.50 2,648.05 2,000.00 132.4 TOTAL OPERATIONS 11, 667.37 29,400.21 31,000.00 94 .8 RETIREMENT 79-610-72-00-6500 IMRF PARTICIPANTS 2,843.33 24,050.17 26, 678.00 90.1 79-610-72-00-6501 SOCIAL SECURITY/MEDICARE 2,798.09 22, 605.86 25,000.00 90.4 TOTAL RETIREMENT 5,641.42 46, 656.03 51, 678.00 90.2 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 2,989.48 5,395.80 5,500.00 98.1 79-610-75-00-7705 TRANSFER TO LAND ACQUISITION 0.00 0.00 0.00 0.0 TOTAL CAPITAL OUTLAY 2, 989.48 5,395.80 32,500.00 16.6 TOTAL EXPENSES: PARKS 75,731.83 472, 677.09 540,854.00 87.3 RECREATION EXPENSES Mil DATE: 06/01/20. UNITED CITY OF _ .VILLE Pi 45 PIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED RECREATION PERSONNEL SERVICES 79-650-50-00-5107 EMPLOYEE SALARIES 28,356.03 228,499.55 212,971.00 107.2 79-650-50-00-5108 CONCESSION STAFF 352.63 4,748.79 5,000.00 94 .9 79-650-50-00-5150 SALARIES-INSTRUCTOR CONTRACTUA 14,251.55 104, 118.45 80,800.00 128.8 79-650-50-00-5155 SALARIES-RECORDING SECRETARY 332.50 2,191.50 3,000.00 73.0 79-650-50-00-5156 SALARIES-CUSTODIAL 0.00 0.00 0.00 0.0 TOTAL PERSONNEL SERVICES 43,292.71 339,558.29 301,771.00 112.5 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 1,701.67 5,234 .09 6,500.00 80.5 79-650-62-00-5409 MAINTENANCE-VEHICLES 0.00 803.81 1,000.00 80.3 79-650-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 263.77 3, 985.11 5,000.00 79.7 79-650-62-00-5426 YOUTH SERVICES GRANT EXPENSES 122.00 458.00 3,000.00 15.2 79-650-62-00-5437 TELEPHONE/INTERNET 0.00 609.45 827.00 73.6 79-650-62-00-5438 CELLULAR TELEPHONE 557.53 2,305.60 3,500.00 65.8 79-650-62-00-5445 PORTABLE TOILETS 454.51 3,215.11 4,000.00 80.3 79-650-62-00-5603 PUBLISHING/ADVERTISING 18.00 23,966.65 24,000.00 99.8 79-650-62-00-5605 BOOKS/PUBLICATIONS 0.00 359.50 750.00 47.9 79-650-62-00-5606 BEECHER DEPOSIT REFUND 250.00 8,364.00 6,000.00 139.4 TOTAL CONTRACTUAL SERVICES 3,367.48 49,301.32 54,577.00 90.3 PROFESSIONAL DEVELOPMENT 79-650-64-00-5600 DUES 35.00 1,542.50 2,500.00 61.7 79-650-64-00-5602 PROFESSIONAL GROWTH/SUBSCRIPT 20.00 4,739.94 7,300.00 64.9 79-650-64-00-5605 TRAVEL EXPENSE 0.00 3, 111.37 2,000.00 155.5 79-650-64-00-5614 TOURNAMENT FEES 0.00 0.00 0.00 0.0 TOTAL PROFESSIONAL DEVELOPMENT 55.00 9,393.81 11,800.00 79.6 OPERATIONS P45 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 46 TIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED RECREATION EXPENSES OPERATIONS 79-650-65-00-5800 CONTINGENCIES 0.00 0.00 0.00 0.0 79-650-65-00-5802 OFFICE SUPPLIES 948.31 5,292.47 6,000.00 88.2 79-650-65-00-5803 PROGRAM EXPENSES 6,360.65 37, 620.05 37,810.00 99.4 79-650-65-00-5804 OPERATING SUPPLIES 284.53 2,984.21 3,000.00 99.4 79-650-65-00-5805 RECREATION EQUIPMENT 893.19 2,502.95 2,500.00 100.1 79-650-65-00-5808 POSTAGE & SHIPPING 883.10 6,362.28 4,000.00 159.0 79-650-65-00-5812 GASOLINE 278.15 1,182.31 800.00 147.7 79-650-65-00-5826 MILEAGE 109.15 818.05 750.00 109.0 79-650-65-00-5827 GOLF OUTING EXPENSES 91.15 19,257.20 19, 166.00 100.4 79-650-65-00-5828 CONCESSIONS 984.37 9, 910.19 10,500.00 94.3 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 808.50 1,500.00 53.9 79-650-65-00-5841 PROGRAM REFUND 961.00 8,523.53 6,500.00 131.1 TOTAL OPERATIONS 11,793.60 95,261.74 92,526.00 102.9 RETIREMENT 79-650-72-00-6500 IMRF PARTICIPANTS 2, 621.68 20,756.03 19,101.00 108.6 79-650-72-00-6501 SOCIAL SECURITY/MEDICARE 2,831.52 23,162.47 21,500.00 107.7 TOTAL RETIREMENT 5,453.20 43, 918.50 40, 601.00 108.1 CAPITAL OUTLAY 79-650-75-00-7002 COMPUTER EQUIP & SOFTWARE 394.34 5,428.28 5, 640.00 96.2 TOTAL CAPITAL OUTLAY 394.34 5,428.28 5, 640.00 96.2 TOTAL EXPENSES: RECREATION 64,356.33 542,861.94 506, 915.00 107.0 TOTAL FUND REVENUES 10,263.98 1,058, 635.91 1,047,769.00 101.0 TOTAL FUND EXPENSES 140,088.16 1,015,539.03 1,047,769.00 96.9 FUND SURPLUS (DEFICIT) (129,824.18) 43,096.88 0.00 100.0 Pit DATE: 06/01/20, UNITED CITY OF . .VILLE P . 47 DIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL970002.WOW FUND: WORKING CASH FUND FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CARRY OVER 80-000-40-00-3999 CARRY OVER/BEG FUND BALANCE 0.00 111, 569.00 0.00 100.0 TOTAL CARRY OVER 0.00 111, 569.00 0.00 100.0 EXPENSES TRANSFERS 80-000-99-00-9901 TRANSFER TO GENERAL FUND 0.00 111, 569.00 0.00 (100.0) TOTAL TRANSFERS 0.00 111,569.00 0.00 (100.0) TOTAL FUND REVENUES 0.00 111, 569.00 0.00 100.0 TOTAL FUND EXPENSES 0.00 111,569.00 0.00 (100.0) FUND SURPLUS (DEFICIT) 0.00 0.00 0.00 0.0 P47 )ATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 48 DIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 [D: GL470002.WOW FUND: LIBRARY FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL $ ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES TAXES 82-000-40-00-3996 CARRY OVER - BOOK DEV FEES 0.00 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 300,853.24 301,915.00 99.6 82-000-40-00-4010 PERSONAL PROPERTY TAX 609.07 3,468.49 2,500.00 138.7 82-000-40-00-4015 TRANSFER FROM GENERAL FUND 0.00 26,249.00 26,249.00 100.0 TOTAL TAXES 609.07 424,023.73 496,964.00 85.3 CHARGES FOR SERVICES 82-000-42-00-4211 DEVELOPMENT FEES - BUILDING 8,350.00 42,875.00 67,000.00 63.9 82-000-42-00-4215 DEVELOPMENT FEES-BOOKS 8,350.00 42,875.00 67,000.00 63.9 82-000-42-00-4260 COPY FEES 109.80 1,295.65 900.00 143.9 82-000-42-00-4261 LIBRARY SUBSCRIPTION CARDS 600.00 10,050.00 8,000.00 125.6 82-000-42-00-4286 RENTAL INCOME 110.00 1,029.00 1,000.00 102.9 TOTAL CHARGES FOR SERVICES 17,519.80 98, 124.65 143,900.00 68.1 FINES 82-000-43-00-4330 LIBRARY FINES 353.55 3, 635.00 3,000.00 121.1 TOTAL FINES 353.55 3, 635.00 3,000.00 121.1 MISCELLANEOUS 82-000-44-00-4432 SALE OF BOOKS 139.29 1,124.66 500.00 224.9 82-000-44-00-4450 MEMORIALS 55.00 6,573.60 1,500.00 438.2 TOTAL MISCELLANEOUS 194.29 7, 698.26 2,000.00 384.9 INTERGOVERNMENTAL 82-000-45-00-4560 LIBRARY PER CAPITA GRANT 0.00 10, 977.46 7,700.00 142.5 TOTAL INTERGOVERNMENTAL 0.00 10,977.46 7,700.00 142.5 Pa DATE: 06/01/20L UNITED CITY OF . .VILLE P, 49 DIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: LIBRARY FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED INTEREST 82-000-46-00-4600 INVESTMENT INCOME (16.46) 1,499.91 1, 500.00 99.9 82-000-46-00-4601 INVESTMENT INCOME-BLDG 424.42 1, 960.19 1, 250.00 156.8 TOTAL INTEREST 407.96 3,460.10 2,750.00 125.8 TOTAL REVENUES: 19,084.67 547,919.20 656,314.00 83.4 EXPENSES PERSONNEL SERVICES 82-000-50-00-5107 SALARIES-EMPLOYEES 17,011.45 140, 341.24 200,000.00 70.1 82-000-50-00-5203 GROUP HEALTH INSURANCE 6,258.09 38,454.65 45,000.00 85.4 82-000-50-00-5204 GROUP LIFE INSURANCE 154.38 1,052.31 1,500.00 70.1 82-000-50-00-5205 DENTAL & VISION ASSISTANCE 700.00 2, 938.30 4,000.00 73.4 TOTAL PERSONNEL SERVICES 24,123.92 182,786.50 250,500.00 72.9 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 227.50 600.00 3,000.00 20.0 82-000-62-00-5407 MAINTENANCE-BLDG/JANITORIAL 1, 684.84 4,862.26 5,000.00 97.2 82-000-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 1, 342. 94 2, 920. 67 3,000.00 97.3 82-000-62-00-5412 MAINTENANCE-PHOTOCOPIER 0.00 168.35 1,000.00 16.8 82-000-62-00-5435 ELECTRICITY 200.05 1,032.57 2,500.00 41.3 82-000-62-00-5436 TELEPHONE 274 .57 1,294.21 1,700.00 76.1 TOTAL CONTRACTUAL SERVICES 3,729.90 10,878.06 16,200.00 67.1 PROFESSIONAL DEVELOPMENT 82-000-64-00-5603 SUBSCRIPTIONS 131.91 2,350.24 4,000.00 58.7 P49 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 50 DIME: 16:33:01 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: LIBRARY FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES PROFESSIONAL DEVELOPMENT 82-000-64-00-5604 TRAINING & CONFERENCES 679.00 749.00 1,500.00 49.9 82-000-64-00-5607 PUBLIC RELATIONS 0.00 676.90 1,000.00 67.6 82-000-64-00-5616 EMPLOYEE RECOGNITION 59.19 929.63 2,000.00 46.4 TOTAL PROFESSIONAL DEVELOPMENT 870.10 4,705.77 8,500.00 55.3 OPERATIONS 82-000-65-00-5800 CONTINGENCIES 40.00 282.25 12,411.00 2.2 82-000-65-00-5806 LIBRARY SUPPLIES 2,196.17 7,064.93 8,000.00 88.3 82-000-65-00-5807 CUSTODIAL SUPPLIES 335.88 2,479.74 6,000.00 41.3 82-000-65-00-5808 POSTAGE & SHIPPING 259.00 629.00 1,000.00 62.9 82-000-65-00-5810 PUBLISHING & ADVERTISING 10.00 77.10 1,000.00 7.7 82-000-65-00-5826 MILEAGE 141.75 501.00 1,000.00 50.1 82-000-65-00-5832 VIDEOS 503.80 1,281.67 5,500.00 23.3 82-000-65-00-5833 ALARM MONITORING 145.70 975.89 1,000.00 97.5 82-000-65-00-5834 LIBRARY PROGRAMMING 1,557.04 6,085.33 10,000.00 60.8 82-000-65-00-5835 LIBRARY BOARD EXPENSES 0.00 0.00 1,000.00 0.0 82-000-65-00-5836 BOOKS-ADULT 3,247.81 11, 997.26 11,000.00 109.0 82-000-65-00-5837 BOOKS-JUVENILE 1,033.48 11,096.16 11,000.00 100.8 82-000-65-00-5838 BOOKS-AUDIO 373.28 2,374.96 11,000.00 21.5 82-000-65-00-5839 BOOKS-REFERENCE 5,302.22 9,889.20 12,000.00 82.4 82-000-65-00-5840 BOOKS-DEVELOPMENT FEE 0.00 22, 610.28 124, 646.00 18.1 82-000-65-00-5841 MEMORIALS/GIFTS 312.25 7,785.05 6,862.00 113.4 82-000-65-00-5842 BLDG-DEVELOPMENT FEES 17,585.77 80,756.18 98, 695.00 81.8 TOTAL OPERATIONS 33,044.15 165,886.00 322,114.00 51.4 RETIREMENT 82-000-72-00-6500 IMRF PARTICPANTS 811.92 8,353.94 9,000.00 92.8 82-000-72-00-6501 SOCIAL SECURITY/MEDICARE 1,301.39 11, 167.79 15,000.00 74.4 TOTAL RETIREMENT 2,113.31 19,521.73 24,000.00 81.3 CAPITAL OUTLAY 82-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 0.00 0.00 0.0 PF^ )ATE: 06/O1/20UNITED CITY OF , ✓ILLE P2_ 51 'IME: 16:33:02 DETAILED REVENUE & EXPENSE REPORT F—YR: 05 ED: GL470002.WOW FUND: LIBRARY FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR—TO—DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED sXPENSES CAPITAL OUTLAY 82-000-75-00-7003 AUTOMATION 1,226.90 11,530.50 30,000.00 38.4 82-000-75-00-7703 BUILDING EXPANSION 0.00 0.00 0.00 0.0 TOTAL CAPITAL OUTLAY 1,226.90 11, 530.50 30,000.00 38.4 TOTAL EXPENSES: 65, 108.28 395,941.56 656,314.00 60.3 DOTAL FUND REVENUES 19,084.67 547, 919.20 656,314.00 83.4 COTAL FUND EXPENSES 65,108.28 395, 941.56 656, 314.00 60.3 FUND SURPLUS (DEFICIT) (46,023.61) 151, 977.64 0.00 100.0 P51 DATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 52 TIME: 16:33:02 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: FOX INDUSTRIAL FOR 12 PERIODS ENDING APRIL 30, 2005 ACCOUNT FISCAL FISCAL % APRIL YEAR-TO-DATE YEAR NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET COLLECTED/ 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 0.00 32,485.84 34,068.00 95.3 TOTAL TAXES 0.00 67,337.84 68, 920.00 97.7 INTEREST 85-000-46-00-4600 INVESTMENT INCOME 525.80 1,136.66 1,000.00 113.6 TOTAL INTEREST 525.80 1,136.66 1,000.00 113.6 TRANSFERS 85-000-49-00-4905 TRANSFER FROM MFT FUND 9,587.00 9,587.00 9,587.00 100.0 TOTAL TRANSFERS 9, 587.00 9,587.00 9,587.00 100.0 TOTAL REVENUES: 10, 112.80 78,061.50 79,507.00 98.1 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 11,225.00 23,371.50 24,293.00 96.2 TOTAL DEBT SERVICES 11,225.00 78,371.50 79,293.00 98.8 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 P" )ATE: 06/O1/20. UNITED CITY OF _ VILLE Pe. 53 ['IME: 16:33:02 DETAILED REVENUE & EXPENSE REPORT F—YR: 05 CD: GL470002.W0W FUND: FOX INDUSTRIAL FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR—TO—DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL EXPENSES: 11,225.00 79,073.75 79,507.00 99.4 DOTAL FUND REVENUES 10,112.80 78,061.50 79,507.00 98.1 DOTAL FUND EXPENSES 11,225.00 79,073.75 79,507.00 99.4 FUND SURPLUS (DEFICIT) (1, 112.20) (1,012.25) 0.00 100.0 P53 )ATE: 06/01/2005 UNITED CITY OF YORKVILLE PAGE: 54 'IME: 16:33:02 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ED: GL470002.WOW FUND: COUNTRYSIDE TIF PROJECT FOR 12 PERIODS ENDING APRIL 30, 2005 FISCAL FISCAL % ACCOUNT APRIL YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES INTEREST 87-000-46-00-4600 INVESTMENT INCOME 13,917.73 13, 917.73 0.00 100.0 TOTAL INTEREST 13, 917.73 13, 917.73 0.00 100.0 OTHER OPERATING RECEIPTS 87-000-48-00-4801 BONDS PROCEEDS 3,442,603.44 3,442, 603.44 0.00 100.0 TOTAL OTHER OPERATING RECEIPTS 3,442, 603.44 3,442, 603.44 0.00 100.0 TOTAL REVENUES: 3,456,521.17 3,456,521.17 0.00 100.0 TOTAL FUND REVENUES 3,456,521.17 3,456,521.17 0.00 100.0 TOTAL FUND EXPENSES 0.00 0.00 0.00 0.0 FUND SURPLUS (DEFICIT) 3,456,521.17 3,456,521.17 0.00 100.0 P45" United City of Yorkville Monthly Treasurer's Report For the Month of January As of January 31, 2005 Beginning Ending Fund Balance Revenues Expenses Transfers Balance 1 General 2,896,371.58 639,077.55 643,145.69 (20,771.00) 2,871,532.44 15 Motor Fuel Tax 344,036.75 - 45,891.37 - 298,145.38 16 Municipal Building (382,548.04) 69,450.00 30,681.09 56,750.00 (287,029.13) 20 PD Capital 50,017.32 26,670.00 981.10 1,962.00 77,668.22 21 PW Capital 353,295.17 13,100.00 - 20,000.00 386,395.17 22 Parks&Rec Equip Capital 10,260.84 - - 6,100.00 16,360.84 37 Sanitary Sewer Improvement 6,400,318.29 147,148.72 604,477.93 (125,695.00) 5,817,294.08 41 Water Improvement Exp 712,284.88 151,239.12 528,172.01 (123,590.75) 211,761.24 42 Debt Service (245,425.06) 3,850.63 142,847.49 229,865.25 * (154,556.67) 51 Water 567,841.66 110,221.28 56,560.74 (80,000.00) 541,502.20 52 Sewer 261,105.81 45,083.95 12,483.01 (25,000.00) 268,706.75 72 Land Cash 455,580.40 14,019.89 5,679.60 (25,000.00) 438,920.69 73 Land Acquisition 63,617.69 - - 25,000.00 88,617.69 79 Parks&Recreation 141,136.18 16,115.06 63,062.64 157,366.00 251,554.60 80 Working Cash 111,569.00 - - (111,569.00) - 82 Library 501,138.66 21,046.51 25,912.70 21,874.00 518,146.47 85 Fox Industrial 100.17 - - - 100.17 95 Trust&Agency 20,201.23 350,429.62 12,720.14 357,910.71 Totals 12,260,902.53 1,607,452.33 2,172,615.51 7,291.50 11,703,030.85 * IY�,. /6244.)e�GC William Powell,Treasurer *Represents transfer in transit-clears in April 2005 Fund Balance Reserve From General Fund to Debt Service General Fund 19.76% Water Ops 20.36% Sewer Maint. 28.73% Prepared by: Lori Thomas-Accounting Clerk II -! United City of Yorkville Monthly Treasurer's Report For the Month of February As of February 28, 2005 Beginning Ending Fund Balance Revenues Expenses Transfers Balance 1 General 2,871,532.44 534,380.48 529,680.54 - 2,876,232.38 15 Motor Fuel Tax 298,145.38 - 24,175.68 - 273,969.70 16 Municipal Building (287,029.13) 1,500.00 3,651.74 - (289,180.87) 20 PD Capital 77,668.22 3,500.00 12,702.14 - 68,466.08 21 PW Capital 386,395.17 8,700.00 1,150.00 - 393,945.17 22 Parks&Rec Equip Capital 16,360.84 - 2,185.46 - 14,175.38 37 Sanitary Sewer Improvement 5,817,294.08 179,550.00 1,105,161.61 - 4,891,682.47 41 Water Improvement Exp 211,761.24 80,317.00 344,633.26 - (52,555.02) 42 Debt Service (154,556.67) 3,188.26 54,465.45 - (205,833.86) 51 Water 541,502.20 80,048.20 58,482.00 - 563,068.40 52 Sewer 268,706.75 33,865.26 18,822.18 - 283,749.83 72 Land Cash 438,920.69 13,448.37 4,288.40 - 448,080.66 73 Land Acquisition 88,617.69 - - - 88,617.69 79 Parks&Recreation 251,554.60 19,731.19 76,275.53 - 195,010.26 80 Working Cash - - - - - 82 Library 518,146.47 2,443.50 50,971.09 469,618.88 85 Fox Industrial 100.17 - - - 100.17 95 Trust&Agency 357,910.71 163,611.66 3,878.83 - 517,643.54 Totals 11,703,030.85 1,124,283.92 2,290,523.91 - 10,536,790.86 ilLzt..-- 7°,2,,,zi William Powell,Treasurer Fund Balance Reserve General Fund 28.27% Water Ops 21.17% Sewer Maint. 30.34% Prepared by: Lori Thomas-Accounting Clerk II United City of Yorkville Monthly Treasurer's Report For the Month of March As of March 31, 2005 Beginning Ending Fund Balance Revenues Expenses Transfers Balance I General 2,876,232.38 738,569.42 503,050.32 (43,814.34) 3,067,937.14 15 Motor Fuel Tax 273,969.70 - 15,273.34 - 258,696.36 16 Municipal Building (289,180.87) 32,100.00 11,586.20 24,250.00 (244,417.07) 20 PD Capital 68,466.08 10,850.00 23,046.00 1,962.00 *** 58,232.08 21 PW Capital 393,945.17 29,750.00 127,819.27 20,000.00 315,875.90 22 Parks&Rec Equip Capital 14,175.38 - 4,127.84 6,100.00 16,147.54 37 Sanitary Sewer Improvement 4,891,682.47 77,891.65 818,670.31 (123,326.00) 4,027,577.81 41 Water Improvement Exp (52,555.02) 192,040.25 22,056.25 (123,590.75) (6,161.77) 42 Debt Service (205,833.86) 13,812.54 - 227,496.25 ** 35,474.93 51 Water 563,068.40 117,511.78 54,080.12 (80,000.00) 546,500.06 52 Sewer 283,749.83 52,274.97 12,304.95 (25,000.00) 298,719.85 72 Land Cash 448,080.66 24,617.12 901.30 (25,000.00) 446,796.48 73 Land Acquisition 88,617.69 100,000.00 - 25,000.00 213,617.69 79 Parks&Recreation 195,010.26 34,257.86 81,084.86 132,339.34 280,522.60 80 Working Cash - - - - - 82 Library 469,618.88 17,815.45 64,225.86 4,375.00 427,583.47 85 Fox Industrial 100.17 - - - 100.17 95 Trust&Agency 517,643.54 248,320.02 513,513.26 - 252,450.30 Totals 10,536,790.86 1,689,811.06 2,251,739.88 20,791.50 9,995,653.54 * /:.iliZe-ot.4,.- /I'r- el( William Powell,Treasurer *Represents transfer in transit-clears in April 2005 Fund Balance Reserve ** From General Fund to Debt Service General Fund 30.70% Water Ops 20.55% Sewer Maint. 31.94% *** From General Fund to Police Capital Prepared by: Lori Thomas-Accounting Clerk II UNAUDITED United City of Yorkville Monthly Treasurer's Report For the Month of April As of April 30, 2005 Beginning Ending Fund Balance Revenues Expenses Transfers Balance 1 General 3,067,937.14 974,151.52 1,292,022.95 (92,113.00) 2,657,952.71 15 Motor Fuel Tax 258,696.36 1,481.56 8,963.52 - 251,214.40 16 Municipal Building (244,417.07) 7,796.40 12,264.32 - (248,884.99) 20 PD Capital 58,232.08 58,997.25 54,917.60 61,535.00 123,846.73 21 PW Capital 315,875.90 15,955.00 605.00 - 331,225.90 22 Parks&Rec Equip Capital 16,147.54 1,328.99 13,086.39 - 4,390.14 37 Sanitary Sewer Improvement 4,027,577.81 333,085.26 313,468.20 - 4,047,194.87 41 Water Improvement Exp (6,161.77) 243,367.03 360,404.74 - (123,199.48) 42 Debt Service 35,474.93 30,659.63 27,355.63 2,495.00 41,273.93 51 Water 546,500.06 111,010.41 133,736.52 - 523,773.95 52 Sewer 298,719.85 48,879.30 25,635.01 - 321,964.14 72 Land Cash 446,796.48 25,475.20 29,835.37 - 442,436.31 73 Land Acquisition 213,617.69 - - - 213,617.69 79 Parks&Recreation 280,522.60 32,334.23 142,371.27 - 170,485.56 80 Working Cash - - - - - 82 Library 427,583.47 19,084.67 65,108.28 - 381,559.86 85 Fox Industrial 100.17 11,225.00 11,225.00 - 100.17 95 Trust&Agency 252,450.30 166,516.54 536,934.51 - (117,967.67) Totals 9,995,653.54 2,081,347.99 3,027,934.31 (28,083.00) 9,020,984.22 * Ze)4EZS., /cc.4-)e--IC William Powell,Treasurer *Represents transfer in transit-from Jan&Mar Fund Balance Reserve From General Fund to Debt Service General Fund 25.45% Water Ops 19.69% Sewer Maint. 34.42% From General Fund to Police Capital Prepared by: Lori Thomas-Accounting Clerk II C344 L. 2' ��o United City of Yorkville Memo '° 800 Game Farm Road ' - _ 1838 Yorkville, Illinois 60560 , ` Telephone: 630-553-8545 6 7 ms..- 1 Fax: 630-553-3436 LE %•' Date: February 18, 2005 To: Tony Graff, City Administrator From: Joe Wywrot, City Engineer , CC: Liz D Anna, Deputy City Clerk Eric Dhuse, Director of Public Works Traci Pleckham, Director of Finance Subject: Engineering Department Staffing Issues Attached find one copy each of the proposed organizational charts for the Engineering Department for the next two fiscal years. These charts show two new hires. In FY 05/06, we are proposing that the Public Works Department add a full-time JULIE locator. That will allow Mike Robinson, who currently is a 0.5 FIE Senior Engineering Technician and a 0.5 FTE JULIE Locator, to become a full-time Senior Engineering Technician. If FY 06/07,we are proposing to hire a full-time Civil Engineer or Project Manager to help with some of the administrative tasks in the office as well as working in the field as necessary. We have not yet developed a job description for this position, but since this is an FY 06/07 hire we have some time. The salary range for this position would also need to be researched more thoroughly. One additional item that I would like to clean up at this time is the salary range issue that exists regarding the Engineering Technician positions. Currently we have two Senior Engineering Technicians and one Engineering Technician. The approved salary schedule, however, only lists one salary range($37,260- $53,524)for engineering technician. I recommend that we revise the salary schedule add a salary range of$41,000 to $57,100 for Senior Engineering Technician. The bottom of the range is 10% more than engineering technician, and the top of the range is 39.25% above the bottom, which is the average spread for all city positions. Please place this item on the Public Works Committee agenda of February 28, 2005 for consideration. C UNITED CITY OF YORKVILLE Senior Engineering Technician JOB DESCRIPTION (Revised 5-31-2005) Department: Engineering Reports To: City Engineer Status: Full-time Positions Description Overview This individual will be responsible for preparing plans, specifications and cost estimates for routine or moderately complex constructions projects. Performs construction inspections and drafting duties. Directs survey crews. This position involves some customer contact and the ability to respond to questions and complaints. This individual needs to work independently and supervises lower level technicians. Essential Job Functions 1. Draws, traces and inks maps, plats and similar drawings by hand as well as utilizing computer equipment such as the CAD system, printer, plotter, etc. 2. Inspects residential and commercial construction sites to ensure compliance with approved plans. 3. Keeps complete construction records and prepares partial and final payment forms. 4. Directs construction surveys for all phases of public improvements, interprets construction plans and specifications. 5. Directs and trains subordinate technicians in performance of Engineering Department functions. 6. Provides basic file information to the public on sewer depths and locations, water line locations, dimensions of lots, and information concerning subdivisions. 7. Revises and maintains updated information for the city sanitary sewer system, watermain system, storm sewer system, corporate boundary map, zoning map, and similar data. 8. Maintains various additional departmental files and records. 9. Performs other duties and responsibilities as directed by the City Engineer. Requirements - Knowledge, Skills and Abilities 1. Ability to utilize Auto CAD and Microsoft Excel Spreadsheet and Word. 2. Ability to interpret construction plans. 3. Ability to use surveying equipment and other tools. 4. Ability to work at heights greater than ten (10) feet, walking over rough, uneven terrain and working out of doors year round in a variety of weather conditions with exposure to the elements. 5. Ability to remain in a standing or sitting position for extended periods of time. Minimum and Preferred Experience and Education 1. High School degree or GED/equivalent required, supplemented by course work in civil engineering or construction-related fields, and/or work experience that provides the required knowledge, skills and abilities. 2. Valid Illinois driver's license. 3. Must be willing to attend training classes to increase knowledge of job related responsibilities. 4. Any approved equivalent combination of experience and education that provides the required knowledge, skills and abilities. 5. Must successfully complete a background investigation with findings of good character and no felony convictions. 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 employee and is subject to change by the employer as the needs of the employer and requirements of the job change. N 641 COUNTY OF KENDALL ) ) ss STATE OF ILLINOIS ) ORDINANCE NO. 2005 - AN ORDINANCE ESTABLISHING THE POSITION OF DEPUTY CLERK IN THE UNITED CITY OF YORKVILLE, KENDALL COUNTY, ILLINOIS WHEREAS, the corporate Authorities of the UNITED CITY OF YORKVILLE have, in the City Code, established the position of Deputy Clerk; and WHEREAS,the Corporate Authorities of the UNITED CITY OF YORKVILLE recognize that the Deputy Clerk has significant responsibilities and duties in relationship to the activities of the City Clerk's Office, Administration Department, and Mayor's Office; and WHEREAS, the Corporate Authorities of the UNITED CITY OF YORKVILLE recognize it is vital that the Deputy Clerk be highly trained and qualified in the area of State, Federal, and local laws regarding organization and retention of municipal records, Freedom of Information Act, Open Meetings Act, or related areas referenced to municipal administrative operations; and WHEREAS,the Corporate Authorities of the UNITED CITY OF YORKVILLE want to ensure that is City Code enumerates in greater detail the necessary duties and qualifications of the Deputy Clerk. NOW, THEREFORE, BE IT ORDAINED BY THE MAYOR AND CITY COUNCIL OF THE UNITED CITY OF YORKVILLE, KENDALL COUNTY, ILLINOIS AS FOLLOWS: Title 1 of the City Code entitled"Administration"which shall be amended as follows: Section 1-6A-3: Deputy Clerk: Page 1 of 3 Section 1-6A-3-1: Position Created: The position of Deputy Clerk is hereby created wherever in this Code or other ordinances of the City the term"Position of Deputy Clerk" shall appear, it shall mean and it shall be synonymous with the term"Deputy Clerk". Section 1-6A-3-2: Appointment, Term,Removal: A. The person to be appointed Deputy Clerk shall be recommended by the City Clerk and appointed by the Mayor, by and with the advice and consent of the City Council. B. The Deputy Clerk shall be appointed on an annual basis at the same City Council meeting when annual appointments are made by the Mayor. C. The City Clerk and/or Mayor, with the approval of the City Council,may remove the Deputy Clerk at any time pursuant to the requirements for removal of appointed officers established by the Illinois Municipal Code. Section 1-6A-3-3: Compensation: The Deputy Clerk shall receive such compensation as shall be fixed from time to time by ordinance, resolution, or vote of the City Council as recommended through the adopted City salary schedule. Section 1-6A-3-4: General Duties: It shall be the duty of the Deputy Clerk to assist the City Clerk in all official capacities including but not limited to signing documents and accepting documents on behalf of the office of the City Clerk. Repealer: All ordinances,resolutions or orders, or parts thereof, in conflict with the provisions of this ordinance are to the extent of such conflict hereby repealed, and this ordinance shall be in full force and effect forthwith upon its adoption. PAUL JAMES MARTY MUNNS JASON LESLIE WANDA O'HARE VALERIE BURD ROSE SPEARS DEAN WOLFER JOSEPH BESCO Page 2 of 3 APPROVED by me, as Mayor of the United City of Yorkville, Kendall County, Illinois, this day of , A.D. 2005. MAYOR PASSED by the City Council of the United City of Yorkville, Kendall County, Illinois, this day of , A.D. 2005. CITY CLERK Page 3 of 3 UNITED CITY OF YORKVILLE I ADMINISTRATIVE ASSISTANT,,JOB DESCRIPTION(Revised 5-31-2005) -_-{Deleted:DEPUTY CLERK Department: Administration Reports to: City Administrator, -- Deleted:City Clerk¶ Status: Full Time;Non-exempt Immediate Supervisor: City Administrator Position Description Overview TJiis position provides assistance to the Administrative staff relating to following and implementing ---- Deleted:This position is responsible clic andprocedures particularlyrelated to land development and City Council documentation and for coordinating the day-to-day City policy P � Clerk office functions and keeps all proceedings. This position will be supervised by the City Administrator in the performance of all , required City records in a proper •--- ' , , organized order as required by Federal, general administrative office duties and act as an administrative liaison to the City Council. This State,and local laws. Furthermore, position works closely with the eilected officials,City Attorney,department beads,and citizens to Deleted:t properly facilitate information,especially for public meetings. The,City Administrator will �r p,, s Deleted:This position has complete the performance evaluation. authorization as directed by the City '' v Clerk to execute documents. Essential Job Functions ',,`; Deleted:E ,,'[Deleted:o 1. Type and distribute City agendas and calendar for public meetings as well as miscellaneous Deleted:C correspondence including distribution of minutes as needed. , Deleted:D Deleted:H 2. Prepare and distribute all packets for public meetings. Deleted:immediate supervisor along with the City Clerk 3. Prepare, issue and file paperwork for tobacco, amusement,and liquor license renewals and freedom of information requests. 4. Gather and distribute Plan Commission material packets for the Commission,City Council, City Attorney, and City Planner. 5. Update and maintain various lists of Aldermen,City Council, committee members and other board members. 6. Serve as a liaison to City Council for general information and queries.particularly for agenda.----1 Formatted:Bullets and Numbering items and City projects. 7. prepare and distributeminutes. t __Plan Council agendas and/or , - Deleted:Act as backup for --_ Administrator's Assistant for 8. Work closely with the City Administratocto assure smooth and organized daily ... Bullets and Numbering administrative functions. Assist with organizing and maintainingCityrecords. ssist with Deleted:y Clerk g g A the publishing of legal notices,public hearings, and media releases. Formatted:Bullets and Numbering Deleted:Coordinate with City Clerk 9. Coordinate and facilitate all schedule requests for petitions for annexations,zoning, preliminary and final platting, and any other request pertaining to Plan Commission and/or City Council meetings regarding development. I 10.Other duties as directed by the City Administrator. Requirements 1. Independent writing and proofreading skills. 2. Ability to communicate clearly and concisely in both oral and written format. 3. Ability to establish and maintain a good working relationship with City Officials, employees and the residential and business community. 4. Ability to understand and follow general instructions and carry out policy decisions and/or recommendations quickly and accurately. 5. Ability to operate a variety of office equipment including a typewriter, word processor, personal computer, facsimile machine, and transcribing equipment rapidly and accurately. 6. Ability to type a minimum of sixty(60)words per minute. 7. Ability to maintain strict confidentiality. Experience and Education 1. Minimum of threq,(3)years secretarial experience or in a related field.preferably in aDeleted:two government settings - Deleted:2 Deleted:. 2. High School Degree supplemented by courses in typing and business subjects,preferably with some college level courses in business related subjects. 3. Any equivalent combination of experience and education that provides the required knowledge, skills, and abilities. 4. Must successfully complete a background investigation with findings of good character and no felony convictions. 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 note 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 the 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. UNITED CITY OF YORKVILLE ADMINISTRATIVE ASSISTANT—JOB DESCRIPTION (Revised 5-31-2005) Department: Administration Reports to: City Administrator Status: Full Time; Non-exempt Position Description Overview This position provides assistance to the Administrative staff relating to following and implementing policy and procedures particularly related to land development and City Council documentation and proceedings. This position will be supervised by the City Administrator in the performance of all general administrative office duties and act as an administrative liaison to the City Council. This position works closely with the elected officials, City Attorney, department heads, and citizens to properly facilitate information, especially for public meetings. The City Administrator will complete the performance evaluation. Essential Job Functions 1. Type and distribute City agendas and calendar for public meetings as well as miscellaneous correspondence including distribution of minutes as needed. 2. Prepare and distribute all packets for public meetings. 3. Prepare, issue and file paperwork for tobacco, amusement, and liquor license renewals and freedom of information requests. 4. Gather and distribute Plan Commission material packets for the Commission, City Council, City Attorney, and City Planner. 5. Update and maintain various lists of Aldermen, City Council, committee members and other board members. 6. Serve as a liaison to City Council for general information and queries, particularly for agenda items and City projects. 7. Prepare and distribute Plan Council agendas and/or minutes. 8. Work closely with the City Administrator to assure smooth and organized daily administrative functions. Assist with organizing and maintaining City records. Assist with the publishing of legal notices, public hearings, and media releases. 9. Coordinate and facilitate all schedule requests for petitions for annexations, zoning, preliminary and final platting, and any other request pertaining to Plan Commission and/or City Council meetings regarding development. 10. Other duties as directed by the City Administrator. Requirements 1. Independent writing and proofreading skills. 2. Ability to communicate clearly and concisely in both oral and written format. 3. Ability to establish and maintain a good working relationship with City Officials, employees and the residential and business community. 4. Ability to understand and follow general instructions and carry out policy decisions and/or recommendations quickly and accurately. 5. Ability to operate a variety of office equipment including a typewriter, word processor, personal computer, facsimile machine, and transcribing equipment rapidly and accurately. 6. Ability to type a minimum of sixty(60) words per minute. 7. Ability to maintain strict confidentiality. Experience and Education 1. Minimum of three (3) years secretarial experience or in a related field, preferably in a government setting. 2. High School Degree supplemented by courses in typing and business subjects, preferably with some college level courses in business related subjects. 3. Any equivalent combination of experience and education that provides the required knowledge, skills, and abilities. 4. Must successfully complete a background investigation with findings of good character and no felony convictions. 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 note 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 the 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. 01/04 DRAFT UNITED CITY OF YORKVILLE POSITION: City Council Administrative Assistant Department: Administration Reports to: City Council Status: Full-time, non-exempt Positions Supervised: None Position Description Overview: This position acts as an assistant to the City Council, participates in special administrative projects; researches and compiles assigned projects, surveys, reports, studies, programs and procedures; establishes communication with professional organizations, other communities, city attorney and City staff; tracks committee meeting documents; reviews City Council original documents and verifies (check and balance) revised documentation for accuracy; collects and submits committee meeting agenda items and appropriate attachments for City meeting packets. Essential Job Functions: 1. Researches and prepares special administrative projects for City Council. 2. Attends staff meetings on behalf of City Council, provides feedback to City Council. 3. Tracks City Council requests for specific documentation, reports, etc. directed to City staff; developers, contracted personnel, etc. 4. Verifies committee meeting note drafts are prepared and submitted to committee members within the approved 2-week time frame. 5. Performs other duties and responsibilities as directed by the City Council. 6. Maintains the Visitors' Center. 7. Working closing with the Human Resources Commissions with responsibility for the Historical Street Naming project. Will maintain accurate records of recommended, qualified nominees; contact nominating individuals for additional information (if required); prepare appropriate correspondence; verify non-duplication of names with appropriate staff, post office, engineering department, BKFD; verify developers use of approved names. 8. Maintains City Council files and records as required. 1 9. Develops positive working relationships with Yorkville Economic Development Corporation, Yorkville Area Chamber of Commerce, Yorkville merchants, City Staff, City Attorney, and local municipalities. When required, attends meetings on behalf of the City Council. 10. Verifies attachments for City meeting packets are submitted by the established time frame. Informs appropriate committee chairperson if packets are not complete for appropriate action(remove or table item from agenda)to be taken. Basic Requirements—Job Knowledge: 1. Possess strong administrative and researching skills. 2. Conducts studies, surveys and reports in a timely manner. 3. Possess excellent writing and verbal communication. 4. Must have a minimum of 65 w.p.m. Keyboarding skills. 5. Ability to act in a confidential capacity. 6. Must have knowledge of office procedures, office machines, and office software including Microsoft Word, Excel, PowerPoint, and Access. 7. Develop and maintain a good working relationship with staff and public displaying excellent communication in a professional manner. 8. Works efficiently with little or no supervision. 9. Able to work for multiple individuals; prioritize work assignments by coordinating with City Council members. Preferred Experience and Education: High school degree. Minimum of 5 years experience as an Administrative Assistant or Executive Secretary. Prefers a minimum of 3 years municipality experiences. Any approved equivalent combination of experience and education that provides the required knowledge, skills and abilities. Must have successfully completed a background investigation with findings of god character and no felony convictions. 2 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 employee and is subject to change by the employer as the needs of the employer and requirements of the job changes. / 7/0 opoLa, _ at *,2_,L (1)4,4,_ - 01/04 DRAFT UNITED CITY OF YORKVILLE POSITION: City Council Administrative Assistant Department: Administration Reports to: City Council Status: Full-time, non-exempt Positions Supervised: None Position Description Overview: This position acts as an assistant to the City Council, participates in special administrative projects; researches and compiles assigned projects, surveys, reports, studies, programs and procedures; establishes communication with professional organizations, other communities, city attorney and City staff; tracks committee meeting documents; reviews City Council original documents and verifies (check and balance) revised documentation for accuracy; collects and submits committee meeting agenda items and appropriate attachments for City meeting packets. Essential Job Functions: 1. Researches and prepares special administrative projects for City Council. 2. Attends staff meetings on behalf of City Council, provides feedback to City Council. 3. Tracks City Council requests for specific documentation, reports, etc. directed to City staff, developers, contracted personnel, etc. 4. Verifies committee meeting note drafts are prepared and submitted to committee members within the approved 2-week time frame. 5. Performs other duties and responsibilities as directed by the City Council. 6. Maintains the Visitors' Center. 7. Working closing with the Human Resources Commissions with responsibility for the Historical Street Naming project. Will maintain accurate records of recommended, qualified nominees; contact nominating individuals for additional information (if required); prepare appropriate correspondence; verify non-duplication of names with appropriate staff, post office, engineering department, BKFD; verify developers use of approved names. 8. Maintains City Council files and records as required. 1 9. Develops positive working relationships with Yorkville Economic Development Corporation, Yorkville Area Chamber of Commerce, Yorkville merchants, City Staff, City Attorney, and local municipalities. When required, attends meetings on behalf of the City Council. 10. Verifies attachments for City meeting packets are submitted by the established time frame. Informs appropriate committee chairperson if packets are not complete for appropriate action(remove or table item from agenda)to be taken. Basic Requirements—Job Knowledge: 1. Possess strong administrative and researching skills. 2. Conducts studies, surveys and reports in a timely manner. 3. Possess excellent writing and verbal communication. 4. Must have a minimum of 65 w.p.m. Keyboarding skills. 5. Ability to act in a confidential capacity. 6. Must have knowledge of office procedures, office machines, and office software including Microsoft Word, Excel, PowerPoint, and Access. 7. Develop and maintain a good working relationship with staff and public displaying excellent communication in a professional manner. 8. Works efficiently with little or no supervision. 9. Able to work for multiple individuals; prioritize work assignments by coordinating with City Council members. Preferred Experience and Education: High school degree. Minimum of 5 years experience as an Administrative Assistant or Executive Secretary. Prefers a minimum of 3 years municipality experiences. Any approved equivalent combination of experience and education that provides the required knowledge, skills and abilities. Must have successfully completed a background investigation with findings of god character and no felony convictions. 2 • 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 employee and is subject to change by the employer as the needs of the employer and requirements of the job changes. /\//2, 3 UNITED CITY OF YORKVILLE OFFICE ASSISTANT—JOB DESCRIPTION(Revised 5-31-2005) _--Deleted:CLERK'S Department: Administration Reports to: City Administrator, - --Deleted:Deputy Clerk Status: Full-Time,Non-Exempt Position Description Overview This individual assists the administration departments in a variety of general office tasks including, but not limited to,typing,project tracking,and filing. This position requires an individual who has the ability to organize and prioritize multiple tasks. Essential Job Functions 1. „Assist with day-to-day operations such as mailings,assist with preparing and distributing _-- Deleted:Provide assistance to the y y p g ' h pDeputy Clerk packets for public meetings, and organizing and maintaining City records. 2. Assist with the compiling, distribution, and mailing of the City newsletter. 3. Assist with posting website information. 4. Type correspondence,faxing and copying as requested. 5. Act as backup relief to answer phones and provide customer service at the front desk. 6. Assist in other areas as requested. 7. Participate in cross training with other job functions within the department. 8. Develop a thorough knowledge of the Windows Programs including office software. 9. Other duties as directed by the,City Administrator. --{Deleted: supervisor or Requirements 1. Ability to type a minimum of fifty(50)words per minute. 2. Ability to organize,prioritize,and handle multiple tasks. 3. Ability to maintain strict confidentiality. Experience and Education -{Deleted: 1. High School degree and some job related college coursework.or combination of experience •----{Formatted:Bullets and Numbering or job related training in lieu of college coursework. Deleted:Revised 08-04-04 RAO 2. Previous experience in an office setting. 3. Previous computer experience in a Windows setting. •----[Formatted:Bullets and Numbering 4. Must be willing to attend training classes to increase knowledge of job related duties. • -- Formatted:Bullets and Numbering 5. Must successfully complete a background investigation. • -- {Formatted:Bullets and Numbering 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. {Deleted:Revised 08-04-04 BAO UNITED CITY OF YORKVILLE OFFICE ASSISTANT—JOB DESCRIPTION (Revised 5-31-2005) Department: Administration Reports to: City Administrator Status: Full-Time, Non-Exempt Position Description Overview This individual assists the administration departments in a variety of general office tasks including, but not limited to, typing, project tracking, and filing. This position requires an individual who has the ability to organize and prioritize multiple tasks. Essential Job Functions 1. Assist with day-to-day operations such as mailings, assist with preparing and distributing packets for public meetings, and organizing and maintaining City records. 2. Assist with the compiling, distribution, and mailing of the City newsletter. 3. Assist with posting website information. 4. Type correspondence, faxing and copying as requested. 5. Act as backup relief to answer phones and provide customer service at the front desk. 6. Assist in other areas as requested. 7. Participate in cross training with other job functions within the department. 8. Develop a thorough knowledge of the Windows Programs including office software. 9. Other duties as directed by the City Administrator. Requirements 1. Ability to type a minimum of fifty (50) words per minute. 2. Ability to organize, prioritize, and handle multiple tasks. 3. Ability to maintain strict confidentiality. Experience and Education 1. High School degree and some job related college coursework, or combination of experience or job related training in lieu of college coursework. 2. Previous experience in an office setting. 3. Previous computer experience in a Windows setting. 4. Must be willing to attend training classes to increase knowledge of job related duties. 5. Must successfully complete a background investigation. The duties listed above are intended only as an illustration of the various types of tasks that may be required. The omission of specific statements of duties does not exclude them from the position if the work is similar, related, or a logical assignment to the position. This job description does not constitute an employment agreement between the employer and employee, and is subject to modification by the employer as the needs of the employer and/or agency change, or requirements of the position change. 1�6 441 cirr Z 3 9 T UNITED CITY OF YORKVILLE ce" ACCOUNTING CLERK I—JOB DESCRIPTION Department: Administration Reports To: Finance Director IStatus: ,Full time; Non-exempt -- Deleted:Part-time 20 hours per week Salary Range: General Support Staff not to exceed 1000 hours annually Position Description Overview: Person is responsible for assisting the Finance Department with various accounting functions, inquiry, and maintenance of A/P records. Assist with all routine functions relating to Accounts Payable, General Accounting, and other duties assigned by the Finance Department. Essential Job Functions: 1. Responsible for the coordination and preparation of all City bill lists Duties include sorting Deleted:assist with preparation of the and distribution of invoices to appropriate department heads, data entry, vendor setup, s monthly bill lists for the City inquiry, invoice filing, and mailing of payments. 2. Cancel/void checks. Prepares replacement checks as required. 3. Research credit or outstanding invoices and respond to vendor inquiries. 4. Maintain vendor files. 5. Assist with capital asset inventory tracking relating to GASB 34 reporting and budgeting purposes. 6. Assist with the bank account reconciliation process,including tracking and verifying daily deposits, -(Deleted:. J 7. Maintain accounting records for Motor Fuel Tax. 8. Reviews payment requests and secures all backup documentation. 9. Assist in gathering annual audit report information. 10. Assist with the development of the Accounting Procedure Manual and ongoing reviews and updates as directed. 11. Tracks purchase order process 12. Prepares reports and researches inquiries for revenue,expense,and vendor information. 13. Perform other duties/projects as assigned. Position Requirements—Knowledge,Skills,and Abilities: 1. Knowledge of accounting practices, procedures, and office terminology 2. Strong analytical skills 3. Strong communication skills 4. Ability to work under pressure and/or frequent interruptions 5. Ability to operate in a multi-task environment 6. Ability to understand department priorities and adjust work activities to meet them. 7. Ability to perform report preparation and periodic duties in a timely fashion and on schedule. 8. Ability to operate a variety of office equipment including a typewriter, copy machine,FAX machine, telephone, and calculator. 9. Must be computer literate and have knowledge of Microsoft Excel and Word. Minimum and Preferred Experience and Education: 1. High School diploma or G.E.D. 2. Minimum of 60 credit hours,Qcollege level coursework required with major coursework in -- Deleted:12 credit hours accounting, finance,or a related field preferred, Bachelor's degree preferred. Deleted:in l Deleted: accounting or finance courses, 3. Previous experience in an office and Windows-based computer environment. 4. Any equivalent combination of experience and education that provides the required knowledge, skills,and abilities. 5. Must successfully complete a background investigation., _.-- Deleted:with findings of good - _ - character,and having no felony convictions. 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. Jam` r EST L s=o UNITED CITY OF YORKVILLE LE ``>" ACCOUNTING CLERK I—JOB DESCRIPTION Department: Administration Reports To: Finance Director Status: Full time; Non-exempt Salary Range: General Support Staff Position Description Overview: Person is responsible for assisting the Finance Department with various accounting functions, inquiry, and maintenance of A/P records. Assist with all routine functions relating to Accounts Payable, General Accounting, and other duties assigned by the Finance Department. Essential Job Functions: 1. Responsible for the coordination and preparation of all City bill lists.. Duties include sorting and distribution of invoices to appropriate department heads, data entry, vendor setup, inquiry, invoice filing, and mailing of payments. 2. Cancel/void checks. Prepares replacement checks as required. 3. Research credit or outstanding invoices and respond to vendor inquiries. 4. Maintain vendor files. 5. Assist with capital asset inventory tracking relating to GASB 34 reporting and budgeting purposes. 6. Assist with the bank account reconciliation process, including tracking and verifying daily deposits. 7. Maintain accounting records for Motor Fuel Tax. 8. Reviews payment requests and secures all backup documentation. 9. Assist in gathering annual audit report information. 10. Assist with the development of the Accounting Procedure Manual and ongoing reviews and updates as directed. 11. Tracks purchase order process 12. Prepares reports and researches inquiries for revenue, expense, and vendor information. 13. Perform other duties/projects as assigned. Position Requirements—Knowledge, Skills, and Abilities: 1. Knowledge of accounting practices, procedures, and office terminology 2. Strong analytical skills 3. Strong communication skills 4. Ability to work under pressure and/or frequent interruptions 5. Ability to operate in a multi-task environment 6. Ability to understand department priorities and adjust work activities to meet them. 7. Ability to perform report preparation and periodic duties in a timely fashion and on schedule. 8. Ability to operate a variety of office equipment including a typewriter, copy machine, FAX machine, telephone, and calculator. 9. Must be computer literate and have knowledge of Microsoft Excel and Word. Minimum and Preferred Experience and Education: 1. High School diploma or G.E.D. 2. Minimum of 60 credit hours of college level coursework required, with major coursework in accounting, finance, or a related field preferred. Bachelor's degree preferred. 3. Previous experience in an office and Windows-based computer environment. 4. Any equivalent combination of experience and education that provides the required knowledge, skills, and abilities. 5. Must successfully complete a background investigation. The duties listed above are intended only as an illustration of the various types of tasks that may be required. The omission of specific statements of duties does not exclude them from the position if the work is similar, related, or a logical assignment to the position. This job description does not constitute an employment agreement between the employer and employee, and is subject to modification by the employer as the needs of the employer and/or agency change, or requirements of the position change. 41.5 ti.t`�� `ct.ocar,, Draft 5/31/05 s UNITED CITY OF YORKVILLE -4. `syr PART TIME UTILITY BILLING CLERK-JOB DESCRIPTION Department: Administration Reports to: Finance Director Status: Part-Time,20 hours per week not to exceed 1000 hours annually Salary Range: Receptionist/Assistant Position Description Overview This position will be assisting the Utility Billing Department with the billing process for all municipal utility accounts. This position involves heavy customer contact and the ability to respond to questions and complaints. A need for mathematical ability is necessary. Essential Job Functions 1. Assists with the preparation, review and mailing of the City's bi-monthly utility bills. 2. Process utility bill payments as needed. 3. Process and transfer information recorded within the water meter radio units into the computer billing system. 4. Print and review water meter reads after transfer has been completed by the water meter radio unit. Identify any problem reads and request a re-check of the water meter read to Public Works. 5. Periodically review the past due account list, follow up on delinquent and collection accounts, sending letters prior to referral. 6. Assist with the penalty bill process. 7. When necessary, prepare documentation on uncollected past due accounts to begin filing a lien on the property as directed by procedures. 8. Answer phones,take messages as needed, and provide customer service at counter. 9. Investigate and respond to any customer billing questions, notify the supervisor with any issues. 10. Refer any utility compliant calls to the proper department, if an emergency is reported contact the Public Works Director immediately. 11. Other duties as assigned. Page 1 of 2 Draft 5/31/05 Requirements 1. Ability to utilize the City's Utility Billing software. 2. Ability to operate a variety of office equipment including a typewriter, computer, facsimile machine and calculator. 3. Organizational skills in order to function within an office environment. 4. Knowledge of basic mathematical skills/formulas. Experience and Education 1. High School Degree or GED. 2. Minimum of two (2) years office experience. 3. Any approved equivalent combination of experience and education that provides the required knowledge, skills and abilities. 4. Must be willing to attend training classes to increase knowledge of job related duties. 5. Must successfully complete a background investigation. 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. Page 2 of 2 `,ctD cii j. Represents New ` 2 CITIZENS or Changed Position s '6•31'6 h �, o� Items in Blue �?.��E 0,>• are Appointed City Council N Mayor City Clerk City Treasurer By the Mayor . Items in Yellow are - Deputy Clerk Appointed , By the City Community City Attorney Clerk Relations , Parks Board Library Board . Manager , Items in Red are Division or Executive Director of Director of Library Police Chief City Administrator Department Parks and Recreation Names Parks and Recreation Library Org. Chart Police Department Org. Chart Org. Chart City Engineer Code Official / Public Works Director Administration Proposed Finance Director Department Community Building Inspector / Development / Department r " Public Works i Engineering \ Building Safety Department Org. Chart Administration Department Org. Chart Org. Chart i Finance Department Department Org. Chart (ICCI) Org. Chart \ / • 5-31-05 BAO `,�0 CI1.. ❑ ❑ ❑ 0 ,? 1 .,, ----, ANN D Q @N@IL a,{rammotidigil IUI II I�� Represents New or Changed PositionEsr 1- toIIIJJJ V llU��111 lJ U IIIJJJ "6,,s, IT ' oy Items in Red are Division �� Names AGE ‘‘' Items in Blue are Appointed By the Mayor Finance Director Administration Department C \ C \ t \ .. i Human Information Accounting Resources Technology Division Division Division i • I 'S I . r-------' . . i . I . • • e ` / 1 Administrative Payroll / Benefits UtilityBillingAccountingAdministrative Janitor Office City Receptionist IT Tech Accounting Assistant Intern / ` Assistant , Secretary Specialist Clerk Clerk II Clerk I PT \ l r _ Current ' — Utility Billing / PT Clerk Seasonal Changing Intern to FT PT FY 05/06 FY 05/06 5-31-05 BAO F o IRfi} U@ J , ,. � ili@IDglEARR . .� , , Represents New or Changed Position E ` 1836 o .z".4,-,9 ?0 Items in Red are Division <te ��,� Names Items in Blue are Appointed By the Mayor Public Works Director i \ E \ i \ . • Sewer Division Water Division Streets Division Receptionist . . . I . i . � . I Foreman Foreman Foreman . . . . • 1 Operator Operator FT Operator __ FY 05/06 I N F 5 . Maintenance Maintenance Maintenance Worker II Worker II Maintenance Worker II Worker II . (JULIE Locator) l J Becoming Whole FT FT Maintenance FY 05/06 Worker I FY 05/06 5-31-05 BAO ,„.o co.). kigillE@Eag ❑ _J �� B ° a �a ; Re resents New or Chan ed PositionEst - - . 1838 p g , p� Com\'\ ji D I ® ® @ O0 D ° nn ° 0 ° ° Oa ° nItems in NamesDivision O Items in Blue are Appointed By the Mayor City Engineer Community FT Development Director FY 05/06 1 , , , 1 Planning Division Building Safety Division / \ ' .5 r / . Senior Engineering Senior Engineering i Engineering Tech Engineering Assistant , Tech I Tech J Code Official / \ \ J ` J Future Planner Future Planner (Title TBD) Building Inspector (Title TBD) FT FT Building Safety FY 05/06 FY 05/06 Org. Chart (ICCI) 5-31-05 BAO Ni3 /7 Draft 5/31/05 1-6-1: MUNICIPAL OFFICERS A. Appointive Officers: At the * meeting, the Mayor by and with the advice and consent of the City Council may appoint the following officers: City Administrator, Director of Finance, Director of Public Works, Chief of Police, Executive Director of Parks and Recreation,Building Inspector/Zoning Officer, City Engineer, City Attorney. Each appointment shall run until the removal from office of the officer(See Section 1-6-2), or until the appointment of a new officer to the office. If any officer is under contract with the City, the term of office in the contract shall control, and no appointment shall be necessary until the contract is concluded, terminated or otherwise rendered null and void. * --for discussion purposes this blank could be filled with the one of the following: 'first meeting of each fiscal year" [This would be the first meeting in May] Or 'first meeting of the fiscal year after the election of the Mayor" [This would be once every four years] Or 'first meeting of the fiscal year after the election of aldermen" [This would be every other year] SECTIONS AMENDED TO BECOME CONSISTENT WITH THIS NEW SECTION 1-6-1: Finance Director: 1-7-10 (B)(1) add at the end the following phrase: "at the time stated in Section 1-6-1." Delete 1-7-10(B)(2) which is no longer necessary. Renumber"3" as "2". Executive Director of Parks and Recreation: 2-5-9-2(A) add at the end the following phrase: "at the time stated in Section 1-6-1." Delete 2-5-9-2(B)which is no longer necessary. Reletter "C"as "B" Ni9)- - Crowe®� Crow2221 Camden Court,Suite 300 Oak Brook,Illinois 60523 Tel 630.574.1040 Crowe Chizek and Company LLC Fax 630.574.8313 Member Horwath International www.crowechizek.com May 18,2005 To the Honorable Mayor and City Council United City of Yorkville 800 Game Farm Road Yorkville,Illinois 60560 This letter confirms the arrangements for Crowe Chizek and Company LLC ("Crowe Chizek" or "us" or "we" or "our") to audit and report on the financial statements of United City of Yorkville (the "City" or"you" or "your") for the year ending April 30,2005. Our audit will be a Single Audit of the City. This audit will be performed in conjunction with the audit of the City's financial statements which was contracted for in a separate engagement letter dated February 21, 2005. The attached Crowe Chizek Engagement Terms is an integral part of this letter and its terms are incorporated herein. AUDIT SERVICES Our Responsibilities We will audit the financial statements of the City for the period indicated. The objective of the audit is the expression of an opinion on the financial statements. In addition to the auditing standards generally accepted in the United States of America we will plan and perform the audit in accordance with Government Auditing Standards, issued by the Comptroller General of the United States, the Single Audit Act Amendments of 1996, and the provisions of OMB Circular A-133, Audits of States, Local Governments, and Non-Profit Organizations. Those standards require that we obtain reasonable, rather than absolute, assurance about whether the financial statements are free of material misstatement whether caused by error or fraud, to report on the Schedule of Expenditures of Federal Awards, and on your compliance with laws and regulations and on its internal controls as required for a single audit. Therefore, a material misstatement may remain undetected. In addition to our report on the financial statements as detailed in the separate engagement letter,we plan to report on: • The Schedule of Expenditures of Federal Awards which will be subjected to the auditing procedures applied in our audit of the financial statements. • Internal control related to the financial statements and compliance with laws, regulations, and the provisions of contracts or grant agreements, noncompliance with To the Honorable Mayor and City Council United City of Yorkville May 18,2005 Page 2 which could have a material effect on the financial statements in accordance with Government Auditing Standards • Internal control related to major programs and an opinion on compliance with laws, regulations, and the provisions of contracts or grant agreements that could have a direct and material effect on each major program in accordance with the Single Audit Act Amendements of 1996 and OMB Circular A-133. Audits of States, Local Governments, and Non-Profit Organizations. We will perform tests of controls including testing underlying transactions,as required by OMB Circular A-133, to evaluate the effectiveness of the design and operation of controls that we consider relevant to preventing or detecting material noncompliance with compliance requirements applicable to each of your major federal awards programs. We will determine major programs in accordance with OMB Circular A-133. Our tests will be less in scope than would be necessary to render an opinion on these controls and, accordingly,no opinion will be expressed. We will inform you of any nonreportable conditions or other matters involving internal control,if any,as required by OMB Circular A-133. OMB Circular A-133 requires that we plan and perform the audit to obtain reasonable assurance about whether you have complied with certain provisions of laws, regulations, contracts and grants. Our procedures will consist of the applicable procedures described in the OMB Circular A-133 Compliance Supplement for the types of compliance requirements that could have a direct and material effect on each of your major programs. The purpose of our audit will be to express an opinion on your compliance with requirements applicable to major Federal award programs. Our audit and work product are intended for the benefit and use of the City only. The audit will not be planned or conducted in contemplation of reliance by any other party or with respect to any specific transaction and is not intended to benefit or influence any other party. Therefore, items of possible interest to a third party may not be specifically addressed or matters may exist that could be assessed differently by a third party. Our reports on internal control and compliance will each include a statement that the report is intended for the information and use of the City Council, management of the City, and the federal awarding agencies and if applicable, pass-through entities and is not intended to be and should not be used by anyone other than these specified parties. The working papers for this engagement are the property of Crowe Chizek and constitute confidential information. However,we may be requested to make certain workpapers available to your oversight agency or grantors pursuant to authority given to them by law, regulation, or contract. If requested, access to such workpapers will be provided under the supervision of our personnel. Furthermore, upon request, we may provide photocopies of selected workpapers to To the Honorable Mayor and City Council United City of Yorkville May 18,2005 Page 3 your oversight agency or grantors. The workpapers for this engagement will be retained for a minimum of three years after the date our report is issued or for any additional period requested by the oversight agency or pass-through entity. If we are aware that a federal awarding agency, pass-through entity, or auditee is contesting an audit finding,we will contact the party contesting the audit finding for guidance prior to destroying the workpapers. Government Auditing Standards require that we provide you with a copy of our most recent quality control review report,which report accompanies this letter. The City's Responsibilities The City's management is responsible for complying with applicable laws, regulations, contracts and grants and such responsibility extends to identifying the requirements and designing internal control policies and procedures to provide reasonable assurance that compliance is achieved. Additionally, as required by OMB Circular A-133, it is management's responsibility to follow up and take corrective action on reported audit findings and to prepare a summary schedule of prior audit findings, which should be available for our review, and a corrective action plan. Management has the responsibility to adopt sound accounting policies, maintain an adequate and efficient accounting system, and to safeguard assets. Management's judgments are typically based on its knowledge and experience about past and current events and its expected courses of action. Management's responsibility for financial reporting includes establishing a process to prepare the accounting estimates included in the financial statements and adjusting the financial statements to correct material misstatements. Management is responsible for making available to us, on a timely basis, all financial records and related information and your personnel to whom we may direct inquiries. Management agrees to provide us with written representations relating to its compliance with the requirements of its Federal programs. Because of the importance of management's representations to an effective audit, you agree to release Crowe Chizek and its personnel from any liability and costs relating to our services under this letter attributable to any misrepresentations by management. At the conclusion of the engagement, it is management's responsibility to submit the reporting package (including financial statements, schedule of expenditures of federal awards, summary schedule of prior audit findings, auditor's reports, and corrective action plan) along with the Data Collection Form to the designated federal clearinghouse and, if appropriate, to pass-through entities. The Data Collection Form and the reporting package must be submitted within the earlier of thirty days after receipt of the auditor's reports or nine months after the To the Honorable Mayor and City Council United City of Yorkville May 18, 2005 Page 4 end of the audit period, unless a longer period is agreed to in advance by the oversight agency for audit. FEES Our fees for these services will be at our standard hourly rates plus out-of-pocket costs (such as typing, postage, travel, copies, etc.) except that we agree that our gross fee, including expenses will not exceed $4,000. The fee estimate is based on anticipated cooperation from your personnel and the assumption that unexpected circumstances will not be encountered during the audit. These fees do not consider any time that might be necessary to assist management in the implementation or adoption of new or existing accounting, reporting, regulatory, or tax requirements that may apply. If there is a significant change in your organizational structure or size due to acquisitions or other events, we reserve the right to revise our fees. If significant additional time is necessary,we will discuss it with you and arrive at a new fee estimate before we incur the additional costs. Our invoices for these fees will be rendered periodically as work progresses and are payable upon receipt. In accordance with our firm policies, work may be suspended if your account becomes overdue and will not be resumed until your account is paid in full. Bills that are not paid within 30 days of receipt are subject to a monthly interest charge of one percent per month or the highest interest rate allowed by law, whichever is less, which we may elect to waive at our sole discretion, plus costs of collection including reasonable attorneys' fees. If we elect to terminate our services for nonpayment, you will be obligated to compensate us for all time expended and to reimburse us for all out-of-pocket expenditures through the date of termination. This engagement letter and the attached Crowe Chizek Engagement Terms reflect the entire agreement between us relating to the services covered by this letter. The headings included in this letter are to assist in ease of reading only; the letter and attachment is to be construed as a single document, with the provisions of each section applicable throughout. This agreement may not be amended or varied except by a written document signed by both parties. It replaces and supersedes any previous proposals, correspondence, and understandings, whether written or oral. The agreements of the City and Crowe Chizek contained in this engagement letter shall survive the completion or termination of this engagement. If any term hereof is found unenforceable or invalid, this shall not affect the other terms hereof, all of which shall continue in effect as if the stricken term had not been included. This agreement is governed by the internal laws of the State of Illinois. To the Honorable Mayor and City Council United City of Yorkville May 18,2005 Page 5 If the terms of this letter and the attached Crowe Chizek Engagement Terms are acceptable to you, please sign and date below and return a copy of this letter at your earliest convenience. If you have any questions,please contact John Weber at(630) 574-1040. Very truly yours, Crowe Chizek and Company LLC By: , . John C. Weber,Executive I have reviewed the arrangements outlined above and in the attached Crowe Chizek Engagement Terms,and I accept on behalf of the City the terms and conditions as stated. United City of Yorkville Signature: Printed Name: Title: Date: Crowe Chizek Engagement Terms We want you to understand the basis under which we offer our services to you and determine our fees, as well as to clarify the relationship and responsibilities between your City and ours. These terms are part of our engagement letter and apply to all future services, unless a specific engagement letter is entered into for those services. We specifically note that no advice we may provide should be construed to be investment advice. YOUR ASSISTANCE - For us to provide our services effectively and efficiently, you agree to provide us timely with the information we request and to make your employees available for our questions. The availability of your personnel and the timetable for their assistance are key elements in the successful completion of our services and in the determination of our fees. Completion of our work depends on appropriate and timely cooperation from your personnel; complete, accurate and timely responses to our inquiries; and timely communication by you of all significant accounting and financial reporting matters of which you are aware. If for any reason this does not occur, a revised fee to reflect the additional time or resources required by us will be mutually agreed upon, and you agree to hold us harmless against all matters that arise in whole or in part from any resulting delay. If circumstances arise that, in our professional judgment, prevent us from completing this engagement, we retain the right to take any course of action permitted by professional standards, including declining to express an opinion or issue other work product, or withdrawing from the engagement. CONFIDENTIALITY - We will maintain the confidentiality of your confidential information in accordance with professional standards. You agree not to disclose any confidential material you obtain from us without our prior written consent, except to the extent such disclosure is an agreed objective of this engagement. Your use of our work product shall be limited to its stated purpose and to your business use only. We retain the right to use the ideas, concepts, techniques, industry data, and know-how we use or develop in the course of the engagement. You agree to the use of fax, email, and voicemail to communicate both sensitive and non-sensitive matters. CONSUMER PRIVACY - In order to provide the services called for in this engagement, you may be disclosing to us certain nonpublic personal information regarding your accounts, customers, and consumers. To the extent permitted by law, we will not disclose any such nonpublic personal information except to you and our employees and agents. However, in circumstances that fall under an exception in the regulations "Privacy of Consumer Financial Information" implementing the Gramm-Leach-Bliley Act, we may disclose or use such nonpublic personal information in the ordinary course of business to carry out the services in this engagement. CHANGES - We may periodically communicate changes in laws, rules, or regulations to you. However, you have not engaged us to and we do not undertake an obligation to advise you of changes in laws, rules,regulations, industry or market conditions, your own business practices, or other circumstances, except to the extent required by professional standards. PUBLICATION - You agree to obtain our specific permission before using our report or our firm's name in a published document, and you agree to submit to us copies of such documents to obtain our permission before they are filed or published. 1 of 3 NO PUNITIVE OR CONSEQUENTIAL DAMAGES - Any liability of Crowe Chizek to you shall not include any special, consequential, incidental, punitive, or exemplary damages or loss nor any lost profits,savings,or business opportunity. LIMIT OF LIABILITY - The provisions of this section establishing a limit of liability will not apply if, as determined in a judicial proceeding, we performed our services with gross negligence or willful misconduct. Our engagement with you is not intended to shift risks normally borne by you to us. With respect to any services or work product or this engagement in general, the liability of Crowe Chizek and its personnel shall not exceed the fees we receive for the portion of the work giving rise to liability. A claim for a return of fees paid shall be the exclusive remedy for any damages. This limitation of liability is intended to apply to the full extent allowed by law, regardless of the grounds or nature of any claim asserted. This limitation of liability shall also apply after termination of this agreement. INDEMNIFICATION FOR THIRD PARTY CLAIMS - The provisions of this section for indemnification will not apply if, as determined in a judicial proceeding, we performed our services with gross negligence, or with willful misconduct. Our engagement with you is not intended to shift risks normally borne by you to us. In the event of a legal proceeding or other claim brought against us by a third party you agree to indemnify and hold harmless Crowe Chizek and its personnel against all costs, fees, expenses, damages, and liabilities, including defense costs and legal fees, associated with such third-party claim arising from or relating to any services or work product that you use or disclose to others, or this engagement generally. This indemnification is intended to apply to the full extent allowed by law, regardless of the grounds or nature of any claim asserted. This indemnification shall also apply after termination of this agreement. RESPONSE TO LEGAL PROCESS - If we are requested by subpoena, other legal process, or other proceedings to produce documents pertaining to you, and we are not a named party to the proceeding,you will reimburse us for our professional time, plus out-of-pocket expenses, as well as reasonable attorney fees we incur in responding to such request. MEDIATION- In the unlikely event that a dispute arises out of this engagement, and it cannot be settled through negotiation, you and we agree to try in good faith to settle the dispute by non-binding mediation administered by the American Arbitration Association under its mediation rules for professional accounting and related services disputes, before resorting to litigation. Both parties shall share mediation costs equally. JURY TRIAL - In the unlikely event that differences concerning our services or fees arise between us that are not resolved by mutual agreement or mediation,you and we agree to waive a trial by jury to facilitate judicial resolution and save time and expense of both parties. LEGAL AND REGULATORY CHANGE - The scope of services and fees for the services covered by the accompanying letter are based on current laws and regulations. If changes in laws or regulations change your requirements or the scope of our work, you and we agree that our fees will be modified to a mutually agreed upon amount to reflect the changed level of our effort. 2 of 3 NON-SOLICITATION - You and we acknowledge the importance of retaining key personnel. Accordingly, both parties agree that during the period of this agreement and for one year after its expiration or termination, neither party will solicit any personnel of the other party for employment without the written consent of the other party. If an individual becomes an employee of the other party, the other party agrees to pay a fee equal to the individual's compensation for the prior full twelve-month period to the original employer. AFFILIATES - Crowe Chizek and Company LLC (Crowe Chizek) is a member of Horwath International Association, a Swiss association (Horwath). Each member firm of Horwath is a separate and independent legal entity. Crowe Chizek and its affiliates are not responsible or liable for any acts or omissions of any other member of Horwath and hereby specifically disclaim any and all responsibility or liability for acts or omissions of any other member of Horwath. 3 of 3 MOSS ADAMS LLP mr� CERTIFIED PUBLIC ACCOUNTANTS To the Executives of Crowe Chizek and Company LLC and the Center for Public Company Audit Firms Peer Review Committee We have reviewed the system of quality control for the accounting and auditing practice of Crowe Chizek and Company LLC (the firm) applicable to non-SEC issuers in effect for the year ended June 30, 2004. The firm's accounting and auditing practice applicable to SEC issuers was not reviewed by us since the Public Company Accounting Oversight Board (PCAOB) is responsible for inspecting that portion of the firm's accounting and auditing practice in accordance with PCAOB requirements. A system of quality control encompasses the firm's organizational structure and the policies adopted and procedures established to provide it with reasonable assurance of complying with professional standards. The elements of quality control are described in the Statements on Quality Control Standards issued by the American Institute of Certified Public Accountants (the AICPA). The design of the system, and compliance with it, are the responsibilities of the firm. Our responsibility is to express an opinion on the design of the system, and the firm's compliance with that system based on our review. Our review was conducted in accordance with standards established by the Peer Review Committee of the Center for Public Company Audit Firms and included procedures to plan and perform the review that are summarized in the attached description of the peer review process. Our review would not necessarily disclose all weaknesses in the system of quality control or all instances of lack of compliance with it since it was based on selective tests. Because there are inherent limitations in the effectiveness of any system of quality control, departures from the system may occur and not be detected. Also, projection of any evaluation of a system of quality control to future periods is subject to the risk that the system of quality control may become inadequate because of changes in conditions, or that the degree of compliance with the policies or procedures may deteriorate. In our opinion, the system of quality control for the accounting and auditing practice applicable to the non-SEC issuers of Crowe Chizek and Company LLC in effect for the year ended June 30, 2004, has been designed to meet the requirements of the quality control standards for an accounting and auditing practice established by the AICPA, and was complied with during the year then ended to provide the firm with reasonable assurance of complying with applicable professional standards. As is customary in a peer review, we have issued a letter under this date that sets forth comments relating to certain policies and procedures or compliance with them. The matters described in the letter were not considered to be of sufficient significance to affect the opinion expressed in this report. Seattle, Washington SIV 0-14 6ifamtdG G P October 22, 2004 A membe-of h4uures F,wl;nrl Inlrr»rtienal al'LSSOCI:JITO,'.OI in(lepenclenl accnuntine.firms IhrougITout the world MOSS ADAMS LLP mr� Description of the Peer Review Process Overview Firms enrolled in the AICPA Center for Public Company Audit Firms (the Center) Peer Review Program have their system of'quality control periodically reviewed by independent peers. These reviews are system and compliance oriented with the objectives of evaluating whether: The reviewed firm's system of quality control for its accounting and auditing practice applicable to non-SEC issuers has been designed to meet the requirements of the Quality Control Standards established by the AICPA. The reviewed firm's quality control policies and procedures applicable to non-SEC issuers were being complied with to provide the firm with reasonable assurance of complying with professional standards. A peer review is based on selective tests and directed at assessing whether the design of and compliance with the firm's system of quality control for its accounting and auditing practice applicable to non-SEC issuers provides the firm with reasonable, not absolute, assurance of complying with professional standards. Consequently a peer review on the firm's system of quality control is not intended to, and does not, provide assurance with respect to any individual engagement conducted by the firm or that none of the financial statements audited by the firm should be restated. The Center's Peer Review Committee (PRC) establishes and maintains peer review standards. At regular meetings and through report evaluation task forces, the PRC considers each peer review, evaluates the reviewer's competence and performance, and examines every report, letter of comments, and accompanying response from the reviewed firm that states its corrective action plan before the peer review is finalized. The Center's staff plays a key role in overseeing the performance of peer reviews working closely with the peer review teams and the PRC. Once the PRC accepts the peer review reports, letters of comments, and reviewed firms' responses, these documents are maintained in a file available to the public. In some situations, the public file also includes a signed undertaking by the firm agreeing to specific follow-up action requested by the PRC. Firms that perform audits or play a substantial role in the audit of one or more SEC issuers, as defined by the Public Company Accounting Oversight Board (PCAOB), are required to be registered with and have their accounting and auditing practice applicable to SEC issuers inspected by the PCAOB. Therefore, we did not review the firm's accounting and auditing practice applicable to SEC issuers. Planning the Review for the Firm's Accounting and Auditing Practice Applicable to Non- SEC Issuers To plan the review of Crowe Chizek and Company LLC, we obtained an understanding of(1) the nature and extent of the firm's accounting and auditing practice, and (2) the design of the firm's system of quality control sufficient to assess the inherent and control risks implicit in its MOSS ADAMS LLP rnr� practice. Inherent risks were assessed by obtaining an understanding of the firm's practice, such as the industries of its clients and other factors of complexity in serving those clients, and the organization of the firm's personnel into practice units. Control risks were assessed by obtaining an understanding of the design of the firm's system of quality control, including its audit methodology, and monitoring procedures. Assessing control risk is the process of evaluating the effectiveness of the reviewed firm's system of quality control in preventing the performance of engagements that do not comply with professional standards. Performing the Review for the Firm's Accounting and Auditing Practice Applicable to Non-SEC Issuers Based on our assessment of the combined level of inherent and control risks, we identified practice units and selected engagements within those units to test for compliance with the firm's system of quality control. The engagements selected for review included engagements performed under the Government Auditing Standards, audits performed under FDICIA, and audits of Employee Benefit Plans. The engagements selected for review represented a cross-section of the firm's accounting and auditing practice with emphasis on higher-risk engagements. The engagement reviews included examining working paper files and reports and interviewing engagement personnel. The scope of the peer review also included examining selected administrative and personnel files to determine compliance with the firm's policies and procedures for the elements of quality control pertaining to independence, integrity, and objectivity; personnel management; and acceptance and continuance of clients and engagements. Prior to concluding the review, we reassessed the adequacy of scope and conducted a meeting with firm management to discuss our findings and recommendations.