Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Administration Packet 2004 12-15-04
J=`�s.D CI 7y0-1 + United City of Yorkville EST.% '_NI`,;1836` County Seat of Kendall County 800 Game Farm Road 0 Yorkville, Illinois, 60560 9 �.:; =4 Telephone: 630-553-4350�� C0.4,rs* Fax: 630-553-7575 Website: www.yorkville.il.us AGENDA SPECIAL ADMINISTRATION COMMITTEE MEETING WEDNESDAY, December 15,2004 6:30 P.M. CITY CONFERENCE ROOM Presentation: None New Business: 1. Revised Budget Additional Business: UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET 2004-2005 GENERAL FUND SUMMARY 2004-2005 PROPOSED 2004-2005 REVISED PERCENT BUDGET BUDGET NET CHANGE CHANGE TOTAL GENERAL FUND REVENUE 10,788,259 11,218,480 430,221 3.99% GENERAL FUND EXPENSES FINANCE & ADMINISTRATION 3,967,465 4,085,970 118,505 2.99% ENGINEERING 385,870 400,649 14,779 3.83% POLICE 1,881,291 1,955,579 74,288 3.95% BUILDING &ZONING 137,400 253,100 115,700 84.21% STREETS 3,923,110 4,017,182 94,072 2.40% HEALTH & SANITATION 493,123 506,000 12,877 2.61% TOTAL GENERAL FUND EXPENSES 10,788,259 11,218,480 430,221 3.99% GENERAL FUND EXPENDITURES 2004-2005 PROPOSED BUDGET 0 FINANCE & ADMINISTRATION HEALTH& 0 ENGINEERING STREETS SANITATION 36% 5% ■POLICE BUILDING& FINANCE& 0 BUILDING&ZONING ZONING ADMINISTRATI 2% N 50% ■STREETS POLICE 17% ENGINEERING 0 HEALTH& 4% SANITATION 12/13/2004 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET DRAF U ETrli t FY 2004-2005 GENERAL FUND /?`/3-G'/ PROPOSED REVISED ACCOUNT 2004-2005 2004-2005 NUMBER 1DESCRIPTION BUDGET BUDGET COMMENTS GENERAL FUND REVENUES To fund 62,846.39 Cannonball Rd&50,292.40 Emergency FUND BALANCE 0 113,139 Generator(not Master Facilities Plan)as approved 01-000-40-00-3999 CARRY OVER BALANCE 104,000 124,000 Addt'l Eng Capital fee$20k-received funds 03/04;spent 04/05 01-000-40-00-3998 ROAD FUNDING-MPI 2,690,000 2,690,000 01-000-40-00-3997 IN-TOWN ROAD PROGRAM FUNDING 620,000 620,000 01-000-40-00-4000 REAL ESTATE TAXES 1,289,736 1,287,453 Certified Extension 01-000-40-00-4001 TOWN ROAD/BRIDGE TAX 95,000 95,000 01-000-40-00-4010 PERSONAL PROPERTY TAX 10,000 10,000'' 01-000-40-00-4020 STATE INCOME TAX 566,891 593,257 Per 10/19/04 revised state revenue numbers 01-000-40-00-4030 MUNICIPAL SALES TAX 1,953,000 2,133,000 01-000-40-00-4032 STATE USE TAX 79,101 87,890 Per 10/19/04 revised state revenue numbers 01-000-40-00-4040 MUNICIPAL UTILITY TAX 560,000 500,000 Receipts less than anticipated 01-000-40-00-4041 UTILITY TAX-NICOR 26,000 75,000 Audit last year 75,000 01-000-40-00-4042 UTILITY TAX-CABLE TV 48,000 60,000 Currently at 82%of budget amount 01-000-40-00-4043 UTILITY TAX-TELEPHONE 220,000 250,000 Currently at 66%of budget amount 01-000-40-00-4050 HOTEL TAX 19,000 19,000', TRAFFIC SIGNAL REVENUE 0 6,000 Per maintenance agreement, IDOT to pay City 01-000-41-00-4100 LIQUOR LICENSE 22,500 22,5001 01-000-41-00-4101 OTHER LICENSES 3,500 4,000 01-000-41-00-4110 BUILDING PERMITS 870,000' 870,000, 01-000-42-00-4205 FILING FEES 20,000 22,000 01-000-42-00-4206 GARBAGE SURCHARGE 171,590 171,590', 01-000-42-00-4208 COLLECTION FEE-YBSD 44,441 44,441 01-000-42-00-4210 DEVELOPMENT FEES 520,000 575,000 Currently at 76%of budget amount 01-000-42-00-4211 ENGINEERING CAPITAL FEE 20,000 4,000 Decrease due to low#of permits that include this new fee 01-000-43-00-4310 TRAFFIC FINES 70,000 70,000. 01-000-43-00-4315 REIMBURSE POLICE TRAINING 3,500 3,500 01-000-43-00-4320 ORDINANCE FEES 2,500 2,500 01-000-44-00-4401 DARE DONATIONS 1,000 1,000 01-000-44-00-4402 ROB ROY CREEK HYDRAULIC STUDY 20,000 20,000 01-000-44-00-4411 REIMBURSEMENTS-POLICE PROTECTION 2,500 3,000 01 000 44 00 4420 SIDEWALK CONSTRUCTION 5,000 5,000. MISCELLANEOUS01-000-44-00-4490 INCOME 10,000 10,000 01-000-45-00-4505 COPS GRANT-VESTS 2,000 01-000-45-00-4510 1 COPS GRANT 41,000 41,0001 01-000-45-00-4511 POLICE-STATE TOBACCO GRANT 0 1,210 01-000-46-00-4600 INVESTMENT INCOME 8,000 12,000 01-000-49-00-4915 TRANSFER FROM WATER OPERATIONS 200,000 200,000 01-000-49-00-4920 TRANSFER FROM SEWER MAINT. 70,000 70,000 01-000-49-00-4925 TRANSFER FROM SAN. SEWER IMP 200,000 200,000 01-000-49-00-4930 TRANSFER FROM WATER IMPROVE. 200,000 200,000 Page 1 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 GENERAL FUND PROPOSED REVISED ACCOUNT 2004-2005 2004-2005 NUMBER DESCRIPTION BUDGET BUDGET COMMENTS TOTAL REVENUES: GENERAL 10,788,259 11,218,480 FINANCE &ADMINISTRATION EXPENSES 01-110-50-00-5100 SALARIES-MAYOR 7,500 7,535 Includes special City Council meeting 01-110-50-00-5101 SALARIES-CITY CLERK 3,600 3,635 Includes special City Council meeting 01-110-50-00-5102 SALARIES-CITY TREASURER 3,600 3,635 Includes special City Council meeting 01-110-50-00-5103 SALARIES-ALDERMAN 28,800 29,080 Includes special City Council meeting 01-110-50-00-5104 SALARIES-LIQUOR COMMISSIONER 1,000 1,000'. 01-110-50-00-5105 SALARIES-CITY ATTORNEY 13,500 13,500 01-110-50-00-5106 SALARIES-ADMINISTRATIVE 459,223 413,600 Decrease due to hiring part time vs.full time 01-110-50-00-5136 SALARIES-PART TIME 13,500 48,000 Increase due to hiring part time vs.full time&includes IT 3 mos 01-110-50-00-5137 SALARIES-OVERTIME 1,500 1,500 01-110-50-00-5202 BENEFITS-UNEMPLOY. COMP.TAX 9,000 9,000 01-110-50-00-5203 BENEFITS-HEALTH INSURANCE 621,000 621,000 01-110-50-00-5204 BENEFITS-GROUP LIFE INSURANCE 18,000 18,000', 01-110-50-00-5205 BENEFITS-DENTALNISION ASST 50,000 50,000 01-110-61-00-5300 LEGAL SERVICES 30,000 40,000 01-110-61-00-5304 'AUDIT FEES&EXPENSES 14,660 14,660 01-110-61-00-5305 ACCOUNTING ASSISTANCE 5,000 7,500 01-110-61-00-5308 GASB 34 15,000 15,000 01-110-61-00-5310 EMPLOYEE ASSISTANCE 4,500 4,500 01-110-61-00-5311 CODIFICATION 5,000 5,000 01-110-61-00-5314 BUILDING INSPECTIONS 607,500 607,500 01-110-61-00-5322 BONDING 2,000 2,000', 01-110-62-00-5400 INSURANCE-LIABILITY&PROPERTY 125,000 120,312 As approved 01-110-62-00-5401 CONTRACTUAL SERVICES 37,300 37,300 01-110-62-00-5404 CABLE CONSORTIUM FEE 30,000 30,000 01-110-62-00-5406 OFFICE CLEANING 25,000 34,500 Increase due to full time 01-110-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 500 500 01-110-62-00-5411 MAINTENANCE-COMPUTERS 6,000 8,000 Increase due to T-1 expense budgeted last FY spent this FY 01-110-62-00-5412 MAINTENANCE-PHOTOCOPIERS 19,392 19,392 01-110-62-00-5427 FACADE PROGRAM 20,000 20,000 01-110-62-00-5436 TELEPHONE 20,000 20,000 01-110-62-00-5437 ACCTG SYSTEM SERVICE FEE 7,385 7,385 01-110-62-00-5438 CELLULAR TELEPHONE 2,300 2,300 01-110-62-00-5439 TELEPHONE SYSTEMS MAINTENANCE 5,000 11,000 Includes voice mail upgrade$6k 01-110-64-00-5600 DUES 4,000 4,000 01-110-64-00-5601 ILLINOIS MUNICIPAL LEAGUE DUES 551 551 01-110-64-00-5603 SUBSCRIPTIONS 400 400 MSI,computer,cust service training for current&new employees, 01-110-64-00-5604 TRAINING&CONFERENCES 6,000 8,000 IML leadership class 01-110-64-00-5605 TRAVEL/MEALS/LODGING 19,000 19,000 01-110-64-00-5607 PUBLIC RELATIONS 11,000 11,000 Page 2 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 GENERAL FUND PROPOSED REVISED ACCOUNT 2004-2005 2004-2005 NUMBER 'DESCRIPTION BUDGET BUDGET COMMENTS 01-110-65-00-5800 CONTINGENCIES 122,523 175,500 01-110-65-00-5802 OFFICE SUPPLIES 12,000 12,000 01-110-65-00-5804 OPERATING SUPPLIES 8,000 14,500 Includes 6,500 sound system upgrades in Council Chamber 01-110-65-00-5808 POSTAGE&SHIPPING 8,000 8,000 01-110-65-00-5809 PRINTING©ING 7,000 8,000 Increase in copy&color copy volume 01-110-65-00-5810 PUBLISHING&ADVERTISING 2,000 3,000 01-110-65-00-5844 MARKETING-HOTEL TAX 19,000 19,000 01-110-72-00-6500 IMRF PARTICIPANTS 47,754 44,000 Decrease due to hiring part time vs.full time 01-110-72-00-6501 SOCIAL SECURITY&MEDICARE 37,770 42,500 Additional part time staff Replacement computers,new hire computers,printer&3,500 01-110-75-00-7002 COMPUTER EQUIP&SOFTWARE 8,000 13,500 server/license/backup upgrades 01-110-75-00-7003 OFFICE EQUIPMENT 4,000 8,000 Increase for 2 new workstations 01-110-78-00-9001 CITY TAX REBATE 1,200 1,200 01-110-78-00-9002 NICOR GAS 20,000 30,000 Expense higher per 03/04 audit 01-110-78-00-9003 SALES TAX REBATE 333,500 333,500 01-110-78-00-9004 MISCELLANEOUS 100 100 01-110-78-00-9005 MERIT/PAY EQUITY 89,000 0 01-110-99-00-9923 TRANSFER TO LIBRARY 19,811 26,249 Includes$6,438 reserve due to decrease in Tax Levy Amount 01-110-99-00-9925 I TRANSFER TO SAN SEWER 150,000 150,000' 01-110-99-00-9940 TRANSFER TO PARK&RECREATION 756,496 794,036 Increase 37,540 due to Park Planner/equipment and merit _ 01-110-99-00-9941 TRANSFER TO PARK/REC CAPITAL 36,600 36,600 01-110-99-00-9945 TRANSFER TO MUNICIPAL BLDG 32,000 97,000 Includes 56,000 for emergency generator&9k carpet TOTAL EXPENSES: FINANCE&ADMINISTRATION 3,967,465 4,085,970 Page 3 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 GENERAL FUND PROPOSED REVISED ACCOUNT 2004-2005 2004-2005 NUMBER DESCRIPTION BUDGET BUDGET COMMENTS ENGINEERING EXPENSES 01-150-50-00-5107 SALARIES-EMPLOYEES 235,883 244,945 Increase due to COLA/Merit transfer 01-150-50-00-5137 SALARIES-OVERTIME 500 1,000 01-150-62-00-5401 CONTRACTUAL SERVICES 40,000 58,000 Includes 14,490 Raymond Stormwater&3k Game Farm Rd 01-150-62-00-5409 MAINTENANCE-VEHICLES 4,500 4,500 01-150-62-00-5410 MAINTENANCE-OFFICE EQUIP 2,000 2,000 01-150-62-00-5411 MAINTENANCE-COMPUTERS 3,500 3,500 01-150-62-00-5421 WEARING APPAREL 1,100 1,100 01-150-62-00-5438 CELLULAR TELEPHONE 2,800 2,800 01-150-64-00-5600 DUES 300 300 01-150-64-00-5604 TRAINING&CONFERENCES 2,500 2,500 000, 01-150-64-00-5605 TRAVEL EXPENSE 1,000' 1 01-150-64-00-5616 BOOKS&PUBLICATIONS 200, 200 01-150-65-00-5801 ENGINEERING SUPPLIES 2,000 3,000 First year for budget-additional supplies needed 01-150-65-00-5802 OFFICE SUPPLIES 1,500 2,000 First year for budget-additional supplies needed 01-150-65-00-5809 PRINTING©ING 1,200 2,000 Increased volume of copies 01-150-72-00-6500 IMRF PARTICIPANTS 23,804 23,804 01-150-72-00-6501 SOCIAL SECURITY&MEDICARE 18,083 19,000 Due to COLA/Merit 01-150-65-00-5820 PICK UP TRUCK/ENGINEERING CAPITAL 40,000 24,000 PW purchasing 2nd replacement truck until capital fees come in 01-150-65-00-5814 STORM WATER SOFTWARE&TRAINING 5,000 5,000 TOTAL EXPENSES: ENGINEERING 385,870 400,649 Page4of28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 GENERAL FUND PROPOSED REVISED ACCOUNT 2004-2005 2004-2005 NUMBER DESCRIPTION BUDGET BUDGET COMMENTS PUBLIC SAFETY/POLICE DEPT. EXPENSES 01-210-50-00-5107 SALARIES-EMPLOYEES 531,563 541,000 Due to employee step increases/vacation payouts per contract 01-210-50-00-5131 SALARIES-LIEUT./SERGEANTS/CHIEF 446,104 461,525 Increase due to vacation payouts&merit 01-210-50-00-5133 SALARIES-COPS 148,496 148,496 Increased 1 Crossing Guard Position&increased hours @ the other 01-210-50-00-5134 SALARIES-CROSSING GUARD 10,000 18,800 2 locations.Contingency funds to pay for the increase. 01-210-50-00-5135 SALARIES-POLICE CLERKS 100,307 100,307 01-210-50-00-5136 SALARIES-PART TIME 20,000 20,000 01-210-50-00-5137 SALARIES-OVERTIME 50,000 50,000 01-210-61-00-5300 LEGAL SERVICES 6,300 6,300' 01-210-62-00-5408 MAINTENANCE-EQUIPMENT 8,000 8,000,, 01-210-62-00-5409 MAINTENANCE-VEHICLES 21,000 21,000 01-210-62-00-5410 'MAINT-OFFICE EQUIPMENT 2,500 2,500, 01-210-62-00-5411 MAINTENANCE-COMPUTERS 2,000 2,000 01-210-62-00-5414 WEATHER WARNING SIREN MAINT 8,000 8,000 01-210-62-00-5421 WEARING APPAREL 20,000 20,000 01-210-62-00-5422 COPS GRANT IV-VESTS 2,500 2,500 01-210-62-00-5423 CLASY GRANT 4,000 0 CLASY program discontinued 01-210-62-00-5424 ICJIA-JUVENILE 5,000 5,000 01-210-62-00-5429 PSYCHOLOGICAL TESTING 1,000 1,000 01-210-62-00-5430 HEALTH SERVICES 3,000', 3,000 01-210-62-00-5431 LABORATORY FEES 1,000 1,000 01-210-62-00-5436 TELEPHONE 20,000 20,000 01-210-62-00-5438 CELLULAR TELEPHONE 13,000 13,000 01-210-62-00-5441 MTD-ALERTS FEE 2,300 2,300 01-210-64-00-5600 DUES 2,250 2,250 01-210-64-00-5603 SUBSCRIPTIONS 300 300 Increased per Admin.Committee's recommendation,if funds are available @ Revised Budget time. This assists us with our 01-210-64-00-5604 TRAINING&CONFERENCE 16,000 19,000 Investigation Division's Training initiative. Increased per Admin.Committee's recommendation,if funds are available @ Revised Budget time. This assists us with our 01-210-64-00-5605 TRAVEL EXPENSES 7,000 9,000 Investigation Division's Training initiative. 01-210-64-00-5606 COMMUNITY RELATIONS 5,250 5,250 01-210-64-00-5607 POLICE COMMISSION 11,000 11,000 01-210-64-00-5608 TUITION REIMBURSEMENT 14,000 14,000 At budget time we had budgeted for only one new employee going to Basic PTI-through the testing process,3 ended up going. We 01-210-64-00-5609 POLICE RECRUIT ACADEMY 3,500 10,500 do recoup this training cost. 01-210-64-00-5610 GUN RANGE FEES 625 625 01-210-64-00-5611 SRT FEE 2,000 2,000 01-210-65-00-5802 OFFICE SUPPLIES 6,500 6,500 Page 5 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 GENERAL FUND PROPOSED REVISED ACCOUNT 2004-2005 2004-2005 NUMBER DESCRIPTION BUDGET BUDGET COMMENTS PUBLIC SAFETY/POLICE DEPT. 01-210-65-00-5804 OPERATING SUPPLIES 15,750 15,750 01-210-65-00-5808 POSTAGE&SHIPPING 3,000 3,000 01-210-65-00-5809 PRINTING©ING 4,500 4,500 01-210-65-00-5810 PUBLISHING&ADVERTISING 1,000 1,000'. 01-210-65-00-5812 GASOLINE 30,000 33,000 Increase in gas prices 01-210-65-00-5813 ',AMMUNITION 5,000 5,000 01-210-72-00-6500 IMRF PARTICIPANTS 10,101 10,101 01-210-72-00-6501 SOCIAL SECURITY&MEDICARE 99,945 102,575 Due to salary updates 01-210-72-00-6502 POLICE PENSION 207,000 207,000 01-210-75-00-7002 COMPUTER EQUIP&SOFTWARE 8,500 8,500 01-210-78-00-9004 BIKE PATROL 2,000 2,000 01-210-99-00-9910 TRANSFER TO POLICE CAPITAL 0 27,000 To help fund detective car(7K)+Dictaphone quote(20K) TOTAL EXPENSES: PUBLIC SAFETY/POLICE DEPT. 1,881,291 1,955,579' Page 6 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 GENERAL FUND PROPOSED . REVISED ACCOUNT 2004-2005 2004-2005 NUMBER DESCRIPTION BUDGET BUDGET COMMENTS BUILDING &ZONING EXPENSES 01-220-61-00-5300 LEGAL SERVICES 12,000 45,000 01-220-62-00-5401 CONTRACTUAL SERVICES 50,000 110,000 South Comp Plan-Includes$60k Master Facilities Plan 01-220-62-00-5430 PLANNING CONSULTANT 20,000 40,000 Miscellaneous Schoppe reviews 01-220-62-00-5432 ECONOMIC DEVELOPMENT 45,000 45,000 01-220-64-00-5600 DUES 200 200 01-220-65-00-5804 OPERATING SUPPLIES 1,000 1,200 01-220-65-00-5809 PRINTING©ING 700 700 01-220-65-00-5810 PUBLISHING&ADVERTISING 8,000 8,000 01-220-65-00-5814 BOOKS&MAPS 500 3,000 South Comp Plan-additional copies TOTAL EXPENSES: BUILDING&ZONING 137,400 253,100 Page 7 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 GENERAL FUND PROPOSED REVISED ACCOUNT 2004-2005 2004-2005 NUMBER DESCRIPTION BUDGET BUDGET COMMENTS STREETS EXPENSES 01-410-50-00-5107 SALARIES -EMPLOYEE 156,643 156,643 01-410-50-00-5136 'SALARIES-PART TIME 5,500 5,500 01-410-50-00-5137 SALARIES-OVERTIME 18,000 18,000 01-410-61-00-5313 ENGINEERING-IN TOWN ROAD PROGRAM 120,000 120,000 01-410-61-00-5314 INSPECTIONS&LICENSES 100 100 01-410-62-00-5401 CONTRACTUAL SERVICES 2,000 2,000 01-410-62-00-5408 MAINTENANCE-EQUIPMENT 10,000 10,000 01-410-62-00-5409 MAINTENANCE-VEHICLES 11,000 11,000' 01-410-62-00-5414 MAINTENANCE-TRAFFIC SIGNALS 12,500 22,000 More traffic signals 01-410-62-00-5415 ',MAINTENANCE-STREETLIGHTS 20,500 20,500 01-410-62-00-5420 MAINTENANCE-STORM SEWER 5,000 5,000, 01-410-62-00-5421 WEARING APPAREL 5,800 5,800 01-410-62-00-5434 RENTAL-EQUIPMENT 1,000 1,500 More efficient to rent specialty equipment than to purchase 01-410-62-00-5435 ELECTRICITY 47,000 47,000 01-410-62-00-5438 CELLULAR TELEPHONE 2,600 2,600 01-410-62-00-5440 STREET LIGHTING 4,500 4,500 01-410-64-00-5604 TRAINING&CONFERENCES 5,600 5,600 01-410-65-00-5804 OPERATING SUPPLIES 9,500 9,500 01-410-65-00-5812 GASOLINE 16,000 20,000 Higher prices,plow season coming 01-410-65-00-5815 HAND TOOLS 1,500 1,500 01-410-65-00-5817 GRAVEL 4,000 5,500 Unexpected costs for Van Emmon,additional work in spring 01-410-72-00-6500 IMRF PARTICIPANTS 17,587 17,587 01-410-72-00-6501 SOCIAL SECURITY&MEDICARE 13,780 13,780 01-410-75-00-5418 MOSQUITO CONTROL 22,000 27,572 True costs 01-410-75-00-5419 MAINT SUPPLIES-STREET 15,000 15,000 01-410-75-00-7004 SAFETY EQUIPMENT 1,000 1,000 01-410-75-00-7100 STREET REHAB PROJECTS 150,000 213,000 Includes approved additional Cannonball Rd costs(62K) 01-410-75-00-7101 IN-TOWN ROAD PROGRAM(Phase 1 Utilities) 500,000 500,000 01-410-75-00-7099 BRISTOL RIDGE ROAD 2,690,000 2,690,000 01-410-75-00-7102 TREE&STUMP REMOVAL 20,000 30,000 Numerous older trees in parkways-cost for removal has risen 01-410-75-00-7103 SIDEWALK CONSTRUCTION 35,000 35,000 TOTAL EXPENSES:STREETS 3,923,110 4,017,182 Page 8 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 GENERAL FUND PROPOSED REVISED ACCOUNT 2004-2005 2004-2005 NUMBER DESCRIPTION BUDGET BUDGET COMMENTS HEALTH & SANITATION EXPENSES 01-540-62-00-5442 GARBAGE SERVICES 489,123 502,000 Additional Services 01-540-62-00-5443 LEAF PICKUP 4,000 4,000 TOTAL EXPENSES: HEALTH&SANITATION 493,123 506,000 TOTAL GENERAL FUND REVENUES 10,788,259 11,218,480 TOTAL GENERAL FUND EXPENSES 10,788,259 11,218,480 FUND SURPLUS(DEFICIT) 0 0 Page 9 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 MFT PROPOSED REVISED ACCOUNT 2004-2005 2004-2005 NUMBER DESCRIPTION BUDGET BUDGET COMMENTS REVENUES 15-000-40-00-3999 CARRY OVER BALANCE 340,000 500,803 Per audit 15-000-40-00-4060 MOTOR FUEL TAX ALLOTMENTS 256,199 267,442 Per 10/19/04 revised state revenue#'s+high growth revenue 15-000-46-00-4600 INVESTMENT INCOME 3,000 5,000 TOTAL REVENUES: 599,199 773,245 15-000-65-00-5800 CONTINGENCY 211,499 372,833 Reserving for Countryside Parkway 15-000-65-00-5818 SALT 37,000 37,000 15-000-75-00-7007 SIGNS 9,700 9,700 15-000-75-00-7008 CRACK FILLING 30,000 25,000 Completed 15-000-75-00-7107 CONSTRUCTION ENGINEERING 200,000 200,000 Game Farm/Somonauk 15-000-75-00-7108 Van Emmon St. (Corp. limits to Rt.47) 100,000 62,625 Actual cost 15-000-75-00-7110 1COLD PATCH 4,000 4,000 15-000-75-00-7111 HOT PATCH 7,0007,000 FAXON ROAD ENGINEERING 0 45,500 As approved 7/13/04 15-000-99-00-9960 TRANSFER TO FOX INDUSTRIAL 0 9,587 TOTAL EXPENSES: 599,199 773,245 TOTAL FUND REVENUES 599,199 773,245 TOTAL FUND EXPENSES 599,199 773,245 FUND SURPLUS(DEFICIT) 0 0 Page 10 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 MUNICIPAL BUILDING PROPOSED REVISED ACCOUNT 2004-2005 2004-2005 NUMBER 'DESCRIPTION BUDGET BUDGET COMMENTS REVENUES CARRY OVER 16-000-40-00-3999 CARRY OVER BALANCE 0 0 16-000-42-00-4211 DEVELOPMENT FEES-BUILDING 57,600 57,600 16-000-49-00-4901 TRANSFER FROM GENERAL FUND 32,000 97,000 Includes 56,000 for emergency generator&9k carpet TOTAL REVENUES: 89,600 154,600 16-000-62-00-5416 MAINT-GENERAL BLDG&GROUNDS 5,000 5,000 16-000-75-00-7008 ENTRY WAY SIGNS 3,6003,600' 16-000-75-00-7200 j BLDG IMPROV-BEEHCER/RIVFRNT 13,000' 13,000', 16-000-75-00-7202 BLDG IMPROVEMENTS-CITY HALL 0 0, 16-000-75-00-7203 BLDG IMPROVEMENTS-PUBLIC WORKS 9,000 9,000 16-000-75-00-7204 BLDG MAINT-CITY HALL 5,000 73,000 Includes 56,000 for emergency generator&9k carpet 16-000-75-00-7205 BLDG IMPROVEMENTS-LIBRARY 4,000 4,000 16-000-75-00-7209 BEECHER PARKING LOT 45,000 45,000 16-000-75-00-7206 LANDSCAPING-PUBLIC BUILDINGS 5,000 2,000 Phase 1 of landscaping;Phase 2 next FY 16-000-78-00-9009 RESERVE 0 0 TOTAL EXPENSES: 89,600 154,600 TOTAL FUND REVENUES 89,600 154,600 TOTAL FUND EXPENSES 89,600 154,600 FUND SURPLUS(DEFICIT) 0 01 Page 11 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 POLICE CAPITAL PROPOSED REVISED 2004-2005 2004-2005 ACCOUNT NUMBER DESCRIPTION BUDGET BUDGET COMMENTS REVENUES 20-000-40-00-3999 CARRY OVER BALANCE 40,000 76,718 Per Audit($42,190 Weather Warning Siren) 20-000-42-00-4212 DEV FEES-POLICE 99,900 95,000 20-000-44-00-4402 K-9 DONATIONS 500 1,700 20-000-44-00-4403 IN CAR VIDEO DONATIONS 2,000 2,000 20-000-44-00-4404 DONATIONS 0 500 20-000-44-00-4405 WEATHER WARNING SIREN 40,000 30,000 20-000-44-00-4431 SALE OF POLICE SQUADS 1,000 1,000 20-000-48-00-4800 LOAN PROCEEDS 62,500 62,500 Evidence Tech Van 20-000-49-00-4901 TRANSFER FROM GENERAL FUND 0 27,000 To help fund detective car(7K)+Dictaphone quote(20K) TOTAL REVENUES: 245,900 296,418 EXPENSES 20-000-65-00-5811 LETHAL/NON-LETHAL WEAPONS 6,500 6,500 20-000-75-00-7001 EQUIPMENT 7,350 19,016 Includes$9,999 Total Station as approved 20-000-75-00-7002 K-9 EQUIPMENT 0 1,700 20-000-75-00-7006 CAR BUILD OUT 23,360 23,360 20-000-75-00-7008 NEW WEATHER WARNING SIRENS 70,000 72,190 20-000-75-00-7005 VEHICLES 62,500 80,500 $62,500 Evidence Tech Van$18k to purchase detective car 20-000-78-00-9009 RESERVE 3,038 0 20-000-99-00-9965 1 1TRANSFER TO DEBT SERV FUND 73,152 73,152 TOTAL EXPENSES: 245,900 276,418 TOTAL FUND REVENUES 245,900 296,418 TOTAL FUND EXPENSES 245,900 276,418 FUND SURPLUS(DEFICIT) 0 20,000 Page 12 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 PUBLIC WORKS CAPITAL PROPOSED REVISED ACCOUNT 2004-2005 2004-2005 NUMBER DESCRIPTION BUDGET BUDGET COMMENTS REVENUES 21-000-40-00-3999 CARRY OVER BALANCE 140,000 272,054 Per audit 21-000-42-00-4213 DEVELOPMENT FEES-PUBLIC WORKS 279,700 279,700 21-000-44-00-4430 SALE OF EQUIPMENT 0 4,510 21-000-49-00-4915 TRANSFER FROM WATER FUND 50,000 50,000 21-000-49-00-4920 TRANSFER FROM SEWER FUND 30,000 30,000 TOTAL REVENUES: 499,700 636,264 EXPENSES 1 ton dump truck budgeted last FY paid this FY(41,905)+Additional truck for Engineering(35,000 Replace 1987 Chevy)w/plow to assist 21-000-75-00-7005 VEHICLES 100,000 176,905 PW. Engineering to pay back portion. 21-000-75-00-7015 SKID STEER UPGRADE 4,500 3,500 True cost 21-000-75-00-7107 TRUCK ACCESSORIES 5,000 5,000 21-000-75-00-7108 AUGER SYSTEM/SKIDSTEER GRADER 9,000 6,300 Rename-SKIDSTEER GRADER 21-000-75-00-7120 STREET SWEEPER 140,000 150,000 Prices are higher than first thought 21-000-75-00-7130 'PUBLIC WORKS BLDG ADDITION 90,000 90,000 21-000-75-00-7109 MOWER 21,000 21,000 21-000-78-00-9009 RESERVE 130,200 148,002 Reserving for salt bin @ new park facility LEAF CHOPPER/VAC 0 35,557 Budgeted last FY-paid for this FY TOTAL EXPENSES: 499,700, 636,264 TOTAL FUND REVENUES 499,700, 636,264 TOTAL FUND EXPENSES 499,700 636,264 FUND SURPLUS(DEFICIT) 0 0 Page 13 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 PARKS & RECREATION CAPITAL PROPOSED REVISED ACCOUNT '2004-2005 '2004-2005 NUMBER DESCRIPTION BUDGET BUDGET COMMENTS REVENUES 22-000-40-00-3999 CARRY OVER 10,000 24,624 Per Audit 22-000-49-00-4930 TRANSFER FROM GENERAL FUND 36,600', 36,600 22-000-49-00-4935 TRANSFER FROM LAND CASH 22,000 22,000 22-000-42-00-4216 PARKS CAPITAL FEE 5,000 2,000 Decrease due to low#of permits that include this new fee 22-000-42-00-4218 IL CLEAN ENERGY GRANT 0 4,149 TOTAL REVENUES: 73,600 89,373 EXPENSES PARKS CAPITAL OUTLAY 22-610-75-00-7006 PICK UP TRUCK 28,000 26,861 actual costs 22-610-75-00-7007 SOCCER GOALS 12'REPLACEMENT 2,000 0 combine line item with -recreation equipment 22-610-75-00-7008 SOCCER GOALS 9'REPLACEMENT 2,000 0 combine line item with -recreation equipment 22-610-75-00-7009 COMPUTER WORKSTATIONS 7,000 6,825 22-610-75-00-7011 PLAYER BENCHES/UTILITY TRAILER 2,000 9,000 rename to UTILITY TRAILER 22-610-75-00-7012 RIVERFRONT PLAYGROUND 5,000 4,000 rename to PLAYGROUNDS(in general)this is for replacement or improvements 22-610-75-00-7013 PLAYGROUND REPAIRS 5,000 2,000 22-610-75-00-7014 SIGN REPLACEMENTS 5,000 3,000 22-610-75-00-7015 MOWERS 15,000 19,857 increased due to actual purchase price cost 22-610-75-00-7016 BEECHER PATHWAY 0 9,480 budgeted last fiscal but spent this fiscal 22-610-75-00-7017 RECREATION EQUIPMENT 2,600 6,600 Includes Recreation large equipment(ie soccer goals,preschool furniture,etc). 22-610-65-00-5800 RESERVE 0 1,750 TOTAL EXPENSES: PARKS 73,600 89,373 TOTAL FUND REVENUES 73,600 89,373 TOTAL FUND EXPENSES 73,600 89,373 FUND SURPLUS(DEFICIT) 0 0 Page 14 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 SEWER IMPROVEMENT PROPOSED REVISED ACCOUNT 2004-2005 2004-2005 NUMBER DESCRIPTION BUDGET BUDGET COMMENTS REVENUES 37-000-40-00-3999 CARRY OVER BALANCE 12,692,117 9,459,809 Per Audit 37-000-42-00-4220 'CONNECTION FEES 1,071,200 1,071,2001 37-000-42-00-4221 RIVER CROSSING FEES 12,506 20,000 37-000-48-00-4803 ROB ROY CREEK REVENUE 0 750,000 Developer funding SOUTHWEST SERVICE AREA INTERCEPTOR 0 460,000 37-000-49-00-4901 TRANSFER FROM GENERAL FUND 150,000 150,000 37-000-46-00-4600 INVESTMENT INCOME 15,000 20,000 TOTAL REVENUES: 13,940,823, 11,931,009 EXPENSES 37-000-62-00-5401 CONTRACTUAL/PROFESSIONAL SERVICES 40,000, 40,0001, 37-000-62-00-5402 ENGINEERING/LEGAL/CONTINGENCIES-COUNTRYSIDE 515,759 800,000 Includes land purchase 37-000-62-00-5405 ENGINEERING/LEGAL/CONTINGENCIES-BRUELL STREET 315,000 500,000 Includes land purchase 37-000-62-00-5406 ENGINEERING/LEGAL/CONTINGENCIES-HYDRAULIC 666,625 666,625' 37-000-65-00-5421 GIS SYSTEM 20,000 15,000 37-000-65-00-5800 CONTINGENCY 2,576,138 44,156 37-000-75-00-7502 HYDRAULIC INTERCEPTOR 4,335,000 1,847,778 37-000-75-00-7503 COUNTRYSIDE INTERCEPTOR 2,933,735 2,903,411 37-000-75-00-7505 ROB ROY CREEK SANITARY 0 1,750,000 SOUTHWEST SERVICE AREA INTERCEPTOR 0 460,000 37-000-75-00-7515 HEARTLAND ONSITE INTERCEPTOR OVER SIZING 200,000 600,000 37-000-75-00-7504 BRUELL STREET LIFT STATION 1,475,000 1,435,735 37-000-75-00-7507 SANITARY JETTER TRUCK ' 225,000''. 225,000 37-000-99-00-9901 TRANSFER TO GENERAL FUND 200,000 200,000 37-000-99-00-9965 TRANSFER TO DEBT SERVICE 438,566 443,304 Due to debt svc recapture/carryover adjustments TOTAL EXPENSES: 13,940,823 11,931,009 TOTAL FUND REVENUES 13,940,823 11,931,009. TOTAL FUND EXPENSES 13,940,823 11,931,009 FUND SURPLUS(DEFICIT) 0 0 Page 15 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 WATER IMPROVEMENT PROPOSED REVISED ACCOUNT 2004-2005 2004-2005 NUMBER 'DESCRIPTION BUDGET BUDGET COMMENTS REVENUES 41-000-40-00-3999 CARRY OVER 4,581,458 2,387,243 Per Audit 41-000-42-00-4220 CONNECTION FEES 1,460,800 1,000,000 SOUTHWEST WATER MAIN PROJECT REVENUE 0 180,000 41-000-45-00-4530 RADIUM GRANT 0 950,000 41-000-46-00-4600 INVESTMENT INCOME 15,000 20,000 41-000-48-00-4801 TEPA LOAN/CONTRACT B PROCEEDS 4,400,000', 4,400,000 41-000-49-00-4915 TRANSFER FROM WATER FUND 70,000 70,000'. TOTAL REVENUES: 10,527,258' 9,007,243 EXPENSES 41-000-61-00-5300 LEGAL SERVICES 10,000 5,000 Legal services outside of contracted projects 41-000-61-00-5301 ENGINEERING -GENERAL SERVICES 0 7,500 41-000-61-00-5400 RADIUM COMPLIANCE PROJECT/CONTRACT B 3,662,730 3,662,730 41-000-61-00-5401 ENGINEERING-RADIUM COMPLIANCE/CONTRACT B 476,155 476,155 41-000-61-00-5405 PROFESSIONAL SERVICE RADIUM/CONTRACT B 261,115 261,115 41-000-61-00-5408 CENTRAL ZONE-CONTRACT C WATER IMPRV 3,404,855 2,494,752 41-000-61-00-5410 ENGINEERING-CENTRAL ZONE-CONTRACT C 91,360 71,873 41-000-61-00-5414 CONTRACT D-SCADA SYSTEM 0 2,500 Preliminary EEI work 41-000-61-00-5415 USGS GROUNDWATER STUDY 0 24,490 USGS GROUNDWATER STUDY COUNTYWIDE 0 8,260 Phase 1 USGS GROUNDWATER STUDY SHALLOW WATER 0 21,000 41-000-65-00-5421 GIS SYSTEM 30,000 20,000 41-000-65-00-5800 CONTINGENCY 901,437 42,239 41-000-75-00-7503 SOUTHWEST WATER MAINTENANCE PROJECT 0 180,000 41-000-75-00-7504 NORTH WATER TOWER-CONTRACT A 1,085,243 1,085,243 OVERSIZING - KYLYN'S CROSSING 0 44,000 Recapture intended 41-000-75-00-7515 JOHNSON STREET WATER MAIN 40,000 36,023 True up 41-000-99-00-9901 TRANSFER TO GENERAL FUND 200,000 200,000 41-000-99-00-9965 TRANSFER TO DEBT FUND 364,363 364,363 TOTAL EXPENSES: 10,527,258 9,007,243 TOTAL FUND REVENUES 10,527,258 9,007,243 TOTAL FUND EXPENSES 10,527,258 9,007,243 FUND SURPLUS (DEFICIT) 0 0 Page 16 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 DEBT SERVICE PROPOSED REVISED 2004-2005 2004-2005 ACCOUNT NUMBER DESCRIPTION BUDGET BUDGETCOMMENTS 42-000-40-00-3999 CARRY OVER 50,000 15,540 Per Audit 42-000-44-00-4440 RECAPTURE-WATER/SEWER 75,000 95,000 42-000-49-00-4901 TRANSFER FROM GENERAL FUND 0 9,722 Due to lower carry over-final Admin car payment(pd May 1,2004) 42-000-49-00-4910 TRANSFER FROM POLICE EQUIP CAP 73,152 73,152 42-000-49-00-4920 TRANSFER FROM SEWER FUND 0 0 42-000-49-00-4925 TRANSFER FROM SANITARY SEWER 438,566 443,304 Adjusted due to recapture/carryover adjustments 42-000-49-00-4930 TRANSFER FROM WATER IMPRV FUND 364,363 364,363 TOTAL REVENUES: 1,001,081 1,001,081 EXPENSES 42-000-66-00-6001 CITY HALL BONDS-PRINCIPAL PMT 50,000 50,000 Due 1/1/2022 42-000-66-00-6002 CITY HALL BONDS-INTEREST PMT 54,998 54,998',Due 1/1/2022 42-000-66-00-6003 IRBB-BRUELL STREET INTEREST PYMT 86,715 86,715 Due 2/1/2023 42-000-66-00-6004 IRBB-BRUELL STREET PRINCIPAL PYMT 80,000 80,000,Due 2/1/2023 42-000-66-00-6005 NORTH WATER TOWER-INTEREST PYMT 1,017 1,017 Due 5/1/2021 42-000-66-00-6006 NORTH WATER TOWER-PRIN PYMT 23,983 23,983 Due 5/1/2021 42-000-66-00-6007 '4.8 MILLION DEBT CERT INT PYMT(WATER) 339,363 339,363'Due 12/15/2022 42-000-66-00-6009 COUNTRYSIDE ALT REV INTEREST PYMT 100,196. 100,196iDue 2018 42-000-66-00-6010 COM ED/HYDRAULIC DEBT CERT. INT PYMT 35,895 35,895 Due 12/30/2014 42-000-66-00-6050 LOAN PAYMENT-SANITARY SIPHON 38,989 38,989 Due 1/25/13 42-000-66-00-6054 LOAN PAYMENT-POLICE SQUAD CAR 24,110 24,110.'Due 7/15/05 42-000-66-00-6055 LOAN PAYMENT-SSES IEPA L17-1153 107,051 107,051 Due 9/6/19 42-000-66-00-6056 YNB-POLICE/ADMIN CARS 58,764 58,764 Final pymt 5/1/04 TOTAL DEBT SERVICE 1,001,081 1,001,081'. TOTAL FUND REVENUES 1,001,081 1,001,081 TOTAL FUND EXPENSES 1,001,081 1,001,081 FUND SURPLUS(DEFICIT) 0 0' Page 17 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 WATER OPERATIONS PROPOSED REVISED 2004-2005 2004-2005 ACCOUNT NUMBER DESCRIPTION BUDGET BUDGET COMMENTS REVENUES 51-000-40-00-3999 CARRY OVER BALANCE 1,500,000 1,540,418 Per Audit 51-000-42-00-4240 BULK WATER SALES 5,000 9,000 51-000-42-00-4241 WATER SALES 950,000 950,000 51-000-42-00-4242 WATER METER SALES 130,000 130,000 51-000-42-00-4243 LEASE REVENUE-H2O TOWER 0 21,600 Per new lease contract 51-000-44-00-4490 MISCELLANEOUS INCOME 500 500 51-000-46-00-4600 INVESTMENT INCOME 6,000 8,000 TOTAL REVENUES: 2,591,500 2,659,518 EXPENSES 51-000-50-00-5107 SALARIES-EMPLOYEE 217,348 223,465 Increase due to COLA/Merit 51-000-50-00-5136 SALARIES-PART TIME 4,000 4,000 51-000-50-00-5137 SALARIES-OVERTIME 27,000 27,000 51-000-61-00-5300 LEGAL SERVICES 2,000 2,000 51-000-61-00-5303 JULIE SERVICE 5,000 6,000 Increased JULIE requests 51-000-62-00-5401 CONTRACTUAL SERVICES 4,000 4,000 51-000-62-00-5408 MAINTENANCE-EQUIPMENT 10,000 10,000 51-000-62-00-5409 MAINTENANCE-VEHICLES 10,000 10,000 51-000-62-00-5411 MAINTENANCE-COMPUTERS 4,000 4,000 51-000-62-00-5413 MAINTENANCE-CONTROL SYSTEM 4,000 8,000 For upgrades in older part of system(wells 3&4) 51-000-62-00-5421 WEARING APPAREL 5,500 5,500 51-000-62-00-5434 RENTAL-EQUIPMENT 1,000 1,000 51-000-62-00-5435 ELECTRICITY 170,000 170,000 51-000-62-00-5436 TELEPHONE 20,000 20,000 51-000-62-00-5438 CELLULAR TELEPHONE 5,500 5,500 51-000-64-00-5600 DUES 750 1,000 True number 51-000-64-00-5603 SUBSCRIPTIONS 250 250 51-000-64-00-5604 TRAINING&CONFERENCES 6,900 6,900 51-000-64-00-5605 TRAVEL EXPENSES 2,000 2,000 51-000-65-00-5800 CONTINGENCIES 29,276 29,276 51-000-65-00-5804 OPERATING SUPPLIES 44,000 44,000 51-000-65-00-5808 POSTAGE&SHIPPING 11,700' 11,700 51-000-65-00-5809 PRINTING©ING 5,000 5,000 51-000-65-00-5810 PUBLISHING&ADVERTISING 1,000 1,000 51-000-65-00-5812 GASOLINE 7,200 8,700 Increase in cost of fuel 51-000-65-00-5815 HAND TOOLS 1,000 1,000 51-000-65-00-5817 GRAVEL 5,000 5,000 51-000-65-00-5820 CHEMICALS 27,232 27,232 51-000-65-00-5821 CATHODIC PROTECTION 2,500 2,500 51-000-65-00-5822 WATER SAMPLES 12,000 12,000 Page 18 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 WATER OPERATIONS PROPOSED REVISED 2004-2005 2004-2005 ACCOUNT NUMBER DESCRIPTION BUDGET BUDGET COMMENTS 51-000-72-00-6500 IMRF PARTICIPANTS 24,606 24,606 51-000-72-00-6501 SOCIAL SECURITY&MEDICARE 19,788 19,788 51-000-75-00-7002 COMPUTER EQUIP&SOFTWARE 4,000 4,000 51-000-75-00-7004 SAFETY EQUIPMENT 2,000 2,000 51-000-75-00-7506 METER READERS 10,320 10,320 51-000-75-00-7507 HYDRANT REPLACEMENT 4,000 10,000 2 unexpected replacements,locks for raw water hydrants 51-000-75-00-7508 METERS&PARTS 130,000 130,000' 51-000-78-00-9005 REFUND 500 1,500 True number 51-000-62-00-5407 TREATMENT FACILITIES 0& M 44,000 44,000 51-000-62-00-5414 TRUCK LETTERING 1,000 1,000 RESERVE-H2O TOWER MAINT. 0 21,600 51-000-78-00-9009 RESERVE 1,386,130 1,412,681 Committed funds for future debt service 51-000-99-00-9901 TRANSFER TO GENERAL FUND 200,000 200,000 51-000-99-00-9930 ,TRANSFER TO WATER IMPRV FUND 70,000 70,000 51-000-99-00-9950 TRANSFER TO PW EQUIP CAPITAL 50,000 50,000 TOTAL EXPENSES: 2,591,500 2,659,518 TOTAL FUND REVENUES 2,591,500 2,659,518 TOTAL FUND EXPENSES 2,591,500 2,659,518 FUND SURPLUS (DEFICIT) 0 0 Page 19 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 SEWER MAINTENANCE PROPOSED REVISED 2004-2005 2004-2005 ACCOUNT NUMBER DESCRIPTION BUDGET BUDGET COMMENTS REVENUES CARRY OVER 0 478,506 Per audit 52-000-42-00-4250 SEWER MAINTENANCE FEES 350,000 350,000 52-000-42-00-4251 SEWER CONNECTION FEES 96,800 96,800 52-000-46-00-4600 INVESTMENT INCOME 10,000 10,000 TOTAL REVENUES: 456,800 935,306 EXPENSES 52-000-50-00-5108 SALARIES-REGULAR 119,254 121,072 Net increase due to COLA/Merit/FT Secretary split costs 52-000-50-00-5136 PART TIME 5,000 5,000 52-000-50-00-5137 SALARIES-OVERTIME 12,000 12,000 52-000-62-00-5401 CONTRACTUAL SERVICES 2,000 2,000 52-000-62-00-5408 MAINTENANCE-EQUIPMENT 8,500 8,500 52-000-62-00-5409 MAINTENANCE-VEHICLES 5,000 5,000 52-000-62-00-5419 MAINTENANCE-SANITARY SEWER 13,000 19,000 Additional$6,000 for manhole repair 52-000-62-00-5421 WEARING APPAREL 4,500 4,500 52-000-62-00-5422 LIFT STATION MAINTENANCE 15,000 22,000 Additional lift stations,unexpected maintenance 52-000-62-00-5434 RENTAL-EQUIPMENT 1,000 1,000 52-000-62-00-5435 ELECTRICITY 8,900 8,900 52-000-62-00-5438 CELLULAR TELEPHONE 2,500 2,500 52-000-64-00-5604 TRAINING&CONFERENCES 1,900 1,900 52-000-65-00-5800 CONTINGENCIES 10,000 10,000'. 52-000-65-00-5802 OFFICE SUPPLIES 2,000 2,000 52-000-65-00-5804 OPERATING SUPPLIES 8,000 8,000 52-000-65-00-5805 SHOP SUPPLIES 2,500 2,500 52-000-65-00-5812 GASOLINE 5,900 9,500 Rising fuel costs 52-000-65-00-5815 HAND TOOLS 1,000 1,000 52-000-65-00-5817 GRAVEL 2,000 2,000 52-000-65-00-5823 SEWER CHEMICALS 15,000 8,000 Transfer$7,000 to lift station maintenance 52-000-72-00-6500 IMRF PARTICIPANTS 13,217 13,217, 52-000-72-00-6501 SOCIAL SECURITY&MEDICARE 10,423 10,423 52-000-75-00-7002 COMPUTER EQUIP&SOFTWARE 2,000 4,000 New CPU 52-000-75-00-7003 OFFICE EQUIPMENT 3,000 6,000 Fire proof file,desk,regular file cabinets,book cases 52-000-75-00-7004 SAFETY EQUIPMENT 2,000 2,000 52-000-78-00-9009 RESERVE 81,206 543,294 Future SSES commitments 52-000-99-00-9901 n TRANSFER TO GENERAL FUND 70,000 70,000 52-000-99-00-9925 TRANSFER TO SAN SEWER IMPROV. 0 0 52-000-99-00-9950 TRANSFER TO PW EQUIP CAPITAL 30,000 30,000 52-000-99-00-9965 TRANSFER TO DEBT SERVICE FUND 0 0 TOTAL EXPENSES: 456,800 935,306 TOTAL FUND REVENUES 456,800 935,306 TOTAL FUND EXPENSES 456,800 935,306': FUND SURPLUS(DEFICIT) 0 0 Page 20 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 LAND CASH PROPOSED REVISED ACCOUNT 2004-2005 2004-2005 NUMBER 'DESCRIPTION BUDGET BUDGET COMMENTS REVENUES 72-000-40-00-3999 CARRY OVER/STARTING BALANCE 626,812 693,912 Per Audit 72-000-40-00-4700 LAND CASH-OTHER 0 354 Refund from Corlands closing 72-000-47-00-4701 'GREENBRIAR-LAND CASH 5,355 5,355 72-000-47-00-4703 PRAIRIE GARDEN-LAND CASH 0 0 72-000-47-00-4704 !FOX HILL-LAND CASH 0 0 72-000-47-00-4705 COUNTRY HILLS-LAND CASH 15,380 15,380 72-000-47-00-4707 FOX HIGHLANDS-LAND CASH 0 3,000 72-000-47-00-4708 FOX HIGHLANDS DUPLEX LAND CASH 0 15,000 72-000-47-00-4709 SUNFLOWER-LAND CASH 7,220 15,000 72-000-47-00-4710 CIMMERON RIDGE-LAND CASH 0 0 72-000-47-00-4712 1RIVER'S EDGE-LAND CASH 20, 72-000-47-00-4713 CANNONBALL HILLS AND CASH 13001 20,130', I 0 72-000-47-00-4714 WOODWORTH-LAND CASH 0 0 72-000-47-00-4715 'WHITE OAK UNIT 1&2-LAND CASH 0 0 72-000-47-00-4716 WHITE OAK UNIT 3&4-LAND CASH 7,030 1,406 72-000-47-00-4717 KYLYN'S CROSSING-LAND CASH 0 3,000 72-000-47-00-4718 FOXFIELD(2ND EDITION)-LAND CASH 0 0 72-000-47-00-4719 WILDWOOD-LAND CASH 0 1,000 72-000-47-00-4720 HEARTLAND-LAND CASH 0 15,000 72-000-47-00-4721 COUNTRYSIDE CNTR#9-LAND CASH 0 0 72-000-47-00-4722 KYLN'S RIDGE-LAND CASH 66,480 50,000 72-000-47-00-4723 HEARTLAND CIRCLE-LAND CASH 60,000 30,000 72-000-47-00-4724 THE HIGHLANDS-RAINTREE VILLAGE 0 0 72-000-47-00-4725 WINDETTE RIDGE-LAND CASH 100,000 0 72-000-47-00-4726 RESERVE @ THE FOX LAND CASH 0 0 72-000-47-00-4727 GRAND RESERVE-LAND CASH 220,500 100,000 72-000-47-00-4730 CANNONBALL EST/KYLYNS CROSSING 0 0 Cannonball Ridge Park 72-000-47-00-4731 MONTALBANO HOMES LAND CASH 0 15,000 72-000-47-00-4734 WHISPERING MEADOWS-(Kimball Hill) 56,160 25,000 72-000-47-00-4735 PRAIRIE MEADOWS-(Menards Res.) 286,230 286,230 72-000-47-00-4700 OSLAD GRANT/Rivers Edge Park 74,000 74,000 TOTAL CONTRIBUTIONS 1,545,297 1,368,767 EXPENSES 72-000-75-00-7008 MISC. BALL FIELD EQUIP 0 0 72-000-75-00-7200 BLDG IMPROVE-BEECHER 0 0 72-000-75-00-7201 RIVERFRONT EQUIP IMPROVEMENT 40,000 55,000 Shelter 72-000-75-00-7300 GREENBRIAR 6,000 3,000 72-000-75-00-7301 FOX HILL 0 0 72-000-75-00-7302 COUNTRY HILLS 130,000 125,000 Page 21 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 LAND CASH 'PROPOSED REVISED ACCOUNT 2004-2005 2004-2005 NUMBER DESCRIPTION BUDGET BUDGET COMMENTS 72-000-75-00-7304 SUNFLOWER 90,000 90,000 72-000-75-00-7307 RIVERS EDGE/Rice Park 160,000 150,000 Separated the 2 parks in Rivers Edge Rivers Edge Park#II 10,000 Separated the 2 parks in Rivers Edge 72-000-75-00-7311 CANNONBALL ESTATES/KYLYNS 97,000 120,000 72-000-75-00-7317 HEARTLAND CIRCLE 5,000, 5,000 72-000-75-00-7324 TOWN SQUARE 10,000 10,000 72-000-75-00-7325 VAN EMMON 0 0 72-000-75-00-7326 CORLANDS 5,000 0 72-000-78-00-9009 RESERVE 594,797 458,767 72-000-75-00-7327 GRANDE RESERVE PARK DEVELOPMENT 220,500 100,000 72-000-75-00-7328 PRAIRIE MEADOWS-(Menards Res.) 5,000 5,000 72-000-75-00-7329 ELSIE LOUISE GILBERT PARK 55,000 60,000 Parks Maintenance Facility 30,000 needs assessment,site planning Windett Ridge 20,000 Trail reimbursement Hill) 5 72-000-75-00-7330 WHISPERING MEADOWS-(Kimball ,000 5,000 72-000-99-00-9955 TRANSFER TO PARKS/REC CAP FUND 22,000 22,000 72-000-99-00-9970 TRANSFER TO LAND ACQUISITION 100,000 100,000 TOTAL EXPENSES: 1,545,297 1,368,767 TOTAL FUND REVENUES 1,545,297 1,368,767 TOTAL FUND EXPENSES 1,545,297, 1,368,767 FUND SURPLUS(DEFICIT) 0 0 Page 22 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 LAND ACQUISITION PROPOSED REVISED 2004-2005 2004-2005 ACCOUNT NUMBER DESCRIPTION BUDGET BUDGET COMMENTS REVENUES 73-000-40-00-3999 CARRY OVER BALANCE 85,982 14,078 Per Audit 73-000-40-00-4930 COLT FUNDING 100,000 100,000 Still pending distribution from Governor 73-000-49-00-4935 TRANSFER FROM LAND CASH 100,000 100,000 TOTAL REVENUES: 285,982 214,078 EXPENSES 73-000-65-00-5800 CONTINGENCY 285,982 214,078 TOTAL EXPENSES: 285,982 214,078 TOTAL FUND REVENUES 285,982 214,078 TOTAL FUND EXPENSES 285,982 214,078 FUND SURPLUS(DEFICIT) 0 Page 23 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 PARKS & RECREATION PROPOSED REVISED 2004-2005 2004-2005 ACCOUNT NUMBER DESCRIPTION BUDGET BUDGET COMMENTS REVENUES 79-000-40-00-3999 CARRY OVER BALANCE 15,000 25,857 Per audit/supports Rec Supervisor salary&benefits 79-000-42-00-4270 FEES FOR PROGRAMS 93,000 155,125 Increase due to addition of Preschool program 79-000-42-00-4280 CONCESSIONS 35,000 10,000 decrease due to actual 79-000-42-00-4281 BEECHER BLDG DEPOSIT 5,000 3,500 decrease due to reduction in building rental availability 79-000-42-00-4282 FARMERS MARKET 500 1,000 increase due to actual 79-000-42-00-4285 VENDING MACHINE INCOME 450 650 increase due to actual 79-000-42-00-4286 RENTAL INCOME 2,000 3,000 79-000-42-00-4287 RENTAL INCOME(SHELTERS) 300 600 79-000-42-00-4288 GOLF OUTING REVENUE 25,000 36,251 increase due to actual 79-000-44-00-4400 DONATIONS 12,000 12,000 79-000-44-00-4404 TREE DONATIONS 1,200 750 79-000-45-00-4550 YOUTH SERVICES GRANT 3,500 3,500 79-000-46-00-4600 INVESTMENT INCOME 1,500 1,500 79-000-49-00-4901 TRANSFER FROM GENERAL FUND 756,496 794,036 Increase 37,540 due to Park Planner/equipment&COLA/Merit Transfer TOTAL REVENUES: 950,946 1,047,769 PARKS EXPENSES 79-610-50-00-5107 SALARIES-EMPLOYEES 256,926 272,176 Includes 3 months FT Park Planner$15,250 79-610-50-00-5136 SALARIES-PART-TIME 45,000 45,000 79-610-50-00-5137 SALARIES-OVERTIME 8,000 8,000 79-610-61-00-5320 MASTER PLAN 10,000 10,000 79-610-62-00-5405 PARK CONTRACTUAL 10,000 10,000 79-610-62-00-5408 MAINTENANCE-EQUIPMENT 5,000 5,000 79-610-62-00-5417 MAINTENANCE-PARKS 30,000 30,000 79-610-62-00-5421 WEARING APPAREL 5,500 5,000 decreased 79-610-62-00-5434 RENTAL-EQUIPMENT 1,500 1,500 79-610-62-00-5438 CELLULAR TELEPHONE 5,000 4,000 decreased 79-610-62-00-5440 LAND DEVELOPER 35,000 23,500 Decrease due to Park Planner position 79-610-62-00-5445 LEGAL EXPENSES 5,000 4,000 PARKS EXPENSES 79-610-64-00-5602 PROFESSIONAL GROWTH/SUBSCRPT 2,500 2,500 79-610-64-00-5605 TRAVEL EXPENSE 2,000 2,000 79-610-64-00-5612 CONTINUING EDUCATION 3,000 3,000 79-610-65-00-5802 OFFICE SUPPLIES 1,000 1,000 79-610-65-00-5804 OPERATING SUPPLIES 20,000 20,000 79-610-65-00-5812 GASOLINE 3,000 2,000 79-610-65-00-5815 HAND TOOLS 2,000 2,000 79-610-65-00-5824 CHRISTMAS DECORATIONS 5,000 4,000 79-610-65-00-5825 PUBLIC DECORATION 2,000 2,000 79-610-72-00-6500 IMRF PARTICIPANTS 26,678 26,678 79-610-72-00-6501 SOCIAL SECURITY/MEDICARE 23,709 25,000 79-610-75-00-7003 OFFICE EQUIPMENT 2,000 27,000 To reflect new park planner office equip computer,CAD licensing Page 24 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 PARKS & RECREATION PROPOSED REVISED 2004-2005 2004-2005 ACCOUNT NUMBER DESCRIPTION BUDGET BUDGET COMMENTS 79-610-75-00-7701 FLOWERS/TREES 5,500 5,500 TOTAL EXPENSES: PARKS 515,313 540,854 RECREATION EXPENSES 79-650-50-00-5107 EMPLOYEE SALARIES 195,471 212,971 Add 17,500 salary from fund balance for Rec Supervisor 79-650-50-00-5150 SALARIES-INSTRUCTOR CONTRACTUAL 35,000 80,800 Increase due to Preschool Program 79-650-50-00-5155 SALARIES-RECORDING SECRETARY 3,000 3,000 79-650-61-00-5321 RECREATION RESEARCH 1,000 0 79-650-50-00-5108 CONCESSION STAFF 16,500 5,000 Actual 79-650-62-00-5408 MAINTENANCE SUPPLIES 6,500 6,500'1 79-650-62-00-5409 MAINTENANCE-VEHICLES 1,000' 1,000 79-650-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 2,500 5,000 79-650-62-00-5426 YOUTH SERVICES GRANT EXPENSES 3,000 3,000 79-650-62-00-5437 TELEPHONE/INTERNET 1,500 827 Actual 79-650-62-00-5438 CELLULAR TELEPHONE 3,500 3,500 79-650-62-00-5445 PORTABLE TOILETS 5,000 4,000 79-650-62-00-5603 PUBLISHING/ADVERTISING 24,000 24,000 RECREATION EXPENSES 79-650-62-00-5605 BOOKS/PUBLICATIONS 750 750 79-650-62-00-5606 BEECHER DEPOSIT REFUND 5,000 6,000 79-650-64-00-5600 DUES 2,500 2,500 79-650-64-00-5602 PROFESSIONAL GROWTH/SUBSCRIPT 7,300 7,300. 79-650-64-00-5605 TRAVEL EXPENSE 2,000 2,000, 79-650-65-00-5802 OFFICE SUPPLIES 6,000 6,000 79-650-65-00-5803 PROGRAM EXPENSES 29,300 37,810 Increase due to additional Programs 79-650-65-00-5804 OPERATING SUPPLIES 4,000 3,000 decreased 79-650-65-00-5805 RECREATION EQUIPMENT 2,500 2,500 79-650-65-00-5808 POSTAGE&SHIPPING 5,000 4,000 decreased 79-650-65-00-5812 GASOLINE 800 800 79-650-65-00-5826 MILEAGE 750 750 79-650-65-00-5827 GOLF OUTING EXPENSES 15,000 19,166 Actual 79-650-65-00-5828 CONCESSIONS 9,800 10,500 Actual 79-650-65-00-5840 SCHOLARSHIPS 1,500 1,500 79-650-65-00-5841 PROGRAM REFUND 4,500 6,500 increased 79-650-72-00-6500 IMRF PARTICIPANTS 18,101 19,101 Due to salary updates 79-650-72-00-6501 SOCIAL SECURITY/MEDICARE 17,861 21,500 Due to salary updates 79-650-75-00-7002 COMPUTER EQUIP&SOFTWARE 5,000 5,640 TOTAL EXPENSES: RECREATION 435,633 506,915 TOTAL FUND REVENUES 950,946 1,047,769 TOTAL FUND EXPENSES 950,946 1,047,769 FUND SURPLUS(DEFICIT) 0 0 Page 25 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 LIBRARY PROPOSED REVISED ACCOUNT 2004-2005 2004-2005 NUMBER DESCRIPTION BUDGET BUDGET COMMENTS REVENUES 82-000-40-00-3999 CARRY OVER 0 72,847 82-000-40-00-3996 CARRY OVER-BOOK DEV FEES 0 57,646 Per audit 82-000-40-00-3997 CARRY OVER-BLDG DEV FEES 100,000 30,445 Per audit 82-000-40-00-3998 CARRY OVER-MEMORIALS 5,000 5,362 Per audit 82-000-40-00-4015 TRANSFER FROM GENERAL FUND 19,811 26,249 Includes$6,438 reserve due to decrease in Tax Levy Amount 82-000-40-00-4000 REAL ESTATE TAXES 308,353 301,915 82-000-40-00-4010 PERSONAL PROPERTY TAX 2,500 2,500 82-000-42-00-4211 DEVELOPMENT FEES-BUILDING 20,000 67,000 82-000-42-00-4215 DEVELOPMENT FEES-BOOKS 20,000 67,000 82-000-42-00-4260 COPY FEES 1 900 900 82-000-42-00-4261 LIBRARY SUBSCRIPTION CARDS 8,000 8,000 82-000-42-00-4286 RENTAL INCOME 1,000 1,000 82-000-43-00-4330 LIBRARY FINES 3,000 3,000 82-000-44-00-4432 SALE OF BOOKS 500 500 82-000-44-00-4450 MEMORIALS 1,500 1,500 82-000-45-00-4560 LIBRARY PER CAPITA GRANT 7,700 7,700 82-000-46-00-4600 INVESTMENT INCOME 1,500 1,500 82-000-46-00-4601 INVESTMENT INCOME-BLDG 1,250 1,250 TOTAL REVENUES: 501,014 656,314 EXPENSES 82-000-50-00-5107 SALARIES-EMPLOYEES 180,000 200,000 82-000-50-00-5203 GROUP HEALTH INSURANCE 30,000 45,000 82-000-50-00-5204 GROUP LIFE INSURANCE 1,500 1,500 82-000-50-00-5205 DENTAL&VISION ASSISTANCE 3,500 4,000 82-000-61-00-5322 BONDING 1,400 2,000 82-000-61-00-5323 ATTORNEY 3,000 3,000 CONTRACT SERVICES 0 3,000 82-000-62-00-5407 MAINTENANCE-BLDG/JANITORIAL 5,000 5,000 82-000-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 3,000 3,000 82-000-62-00-5412 MAINTENANCE-PHOTOCOPIER 1,000 1,000 82-000-62-00-5435 ELECTRICITY 2,500 2,500 82-000-62-00-5436 TELEPHONE 1,700 1,700 82-000-64-00-5603 SUBSCRIPTIONS 2,500 4,000 82-000-64-00-5604 TRAINING&CONFERENCES 1,000 1,500 82-000-64-00-5607 PUBLIC RELATIONS 650 1,000 82-000-64-00-5616 EMPLOYEE RECOGNITION 2,000 2,000 82-000-65-00-5800 CONTINGENCIES 4,314 12,411 To reflect 3%Contingency Per Policy 82-000-65-00-5806 LIBRARY SUPPLIES 7,000 8,000 82-000-65-00-5807 CUSTODIAL SUPPLIES 4,000 6,000 Page 26 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 LIBRARY PROPOSED REVISED ACCOUNT 2004-2005 2004-2005 NUMBER DESCRIPTION BUDGET BUDGET COMMENTS 82-000-65-00-5808 POSTAGE&SHIPPING 900 1,000 82-000-65-00-5810 PUBLISHING&ADVERTISING 300 1,000 82-000-65-00-5826 MILEAGE 600 1,000 82-000-65-00-5832 VIDEOS 5,500 5,500 82-000-65-00-5833 ALARM MONITORING 900 1,000 82-000-65-00-5834 LIBRARY PROGRAMMING 9,000 10,000 82-000-65-00-5835 LIBRARY BOARD EXPENSES 500 1,000 82-000-65-00-5836 BOOKS-ADULT 10,000 11,000 82-000-65-00-5837 BOOKS-JUVENILE 10,000 11,000 82-000-65-00-5838 BOOKS-AUDIO 6,000 11,000 82-000-65-00-5839 BOOKS-REFERENCE 12,000 12,000 82-000-65-00-5840 BOOKS-DEVELOPMENT FEE 70,000 124,646 To include carry over 82-000-65-00-5841 MEMORIALS/GIFTS 6,500 6,862 To include carry over 82-000-65-00-5842 BLDG-DEVELOPMENT FEES 71,250 98,695 To include carry over 82-000-72-00-6500 IMRF PARTICIPANTS 8,000 9,000 82-000-72-00-6501 SOCIAL SECURITY/MEDICARE 13,500 15,000 82-000-75-00-7003 AUTOMATION 22,000 30,000 TOTAL EXPENSES: I 501,014 656,314 TOTAL FUND REVENUES 501,014, 656,314 TOTAL FUND EXPENSES 501,014 656,314 FUND SURPLUS(DEFICIT) 0 0 Page 27 of 28 UNITED CITY OF YORKVILLE PROPOSED REVISED BUDGET FY 2004-2005 FOX INDUSTRIAL PROPOSED REVISED ACCOUNT 2004-2005 2004-2005 NUMBER DESCRIPTION BUDGET BUDGET ,COMMENTS REVENUES 85-000-40-00-3999 CARRY OVER BALANCE 46,000 34,852 Per audit 85-000-40-00-4090 TIF REVENUES 35,000 34,068 Certified extension 85-000-46-00-4600 INVESTMENT INCOME 1,000 1,000 85-000-49-00-4905 TRANSFER FROM MFT FUND 0 9,587 TOTAL REVENUES: 82,000 79,507 EXPENSES 85-000-66-00-6021 FOX IND BOND-PRINCIPAL PMT 55,000 55,000 85-000-66-00-6022 FOX IND BOND-INT PAYMENT 24,293 24,293 85-000-75-00-7901 FOX INDUSTRIAL-NON MFT 0 0 85-000-75-00-7902 FOX INDUSTRIAL EXPENSES 0 0' 85-000-78-00-9007 ADMINISTRATION FEES 214 214 85-000-78-00-9010 RESERVE-FUTURE BOND PYMT 2,493 0 TOTAL EXPENSES: 82,000 79,507 TOTAL FUND REVENUES 82,000 79,507 TOTAL FUND EXPENSES 82,000 79,507 FUND SURPLUS(DEFICIT) 0 0 Page 28 of 28 UNITED CITY OF YORKVILLE BUDGET 2004-2005 GENERAL FUND SUMMARY PERIOD ENDING OCTOBER 31, 2004 50% OF FISCAL YEAR REVENUE/EXPENSE THRU 2004-2005 PERCENT VS. OCTOBER 31, 2004 BUDGET BUDGET AMOUNT TOTAL GENERAL FUND REVENUE 5,926,988 10,788,259 54.94% GENERAL FUND EXPENSES FINANCE & ADMINISTRATION 1,621,962 3,967,465 40.88% ENGINEERING 185,614 385,870 48.10% POLICE 981,518 1,881,291 52.17% BUILDING &ZONING 68,664 137,400 49.97% STREETS 970,069 3,923,110 24.73% HEALTH & SANITATION 202,463 493,123 41.06% TOTAL GENERAL FUND EXPENSES 4,030,289 10,788,259 37.36% 12/13/2004 UNITED CITY OF YORKVILLE DETAILED REVENUE & EXPENSE REPORT AS OF OCTOBER 31, 2004 General Fund Revenue 1 Sanitary Sewer Improvement&Expansion 23 Finance 3 Water Improvement &Expansion 25 Engineering 6 Debt Service Fund 28 Police 7 Water Operations 30 Building and Zoning 9 Sewer Maintenance 34 Streets and Alleys 10 Land Cash 37 Health and Sanitation 12 Land Acquisition 41 Motor Fuel Tax Fund 13 Parks &Recreation 42 Municipal Building 15 Library 47 Police Equipment Capital 17 Fox Industrial 51 Public Works Equipment Capital 19 Parks &Recreation Equipment Capital 21 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 1 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND 50% OF FISCAL YEAR FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED GENERAL REVENUES TAXES 01-000-40-00-3997 IN TOWN ROAD PROGRAM FUNDING 0.00 632, 635.58 620,000.00 102.0 01-000-40-00-3998 MPI BRISTOL RIDGE RD FUNDING 113,302.73 1, 368, 475.09 2, 690,000.00 50.8 01-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 104,000.00 0.0 01-000-40-00-4000 REAL ESTATE TAXES 501, 979.42 1, 162, 520.19 1,289,736.00 90.1 01-000-40-00-4001 TOWN ROAD/BRIDGE TAX 38,742.03 89, 643.74 95,000.00 94.3 01-000-40-00-4010 PERSONAL PROPERTY TAX 2,266.24 4, 309.43 10,000.00 43.0 01-000-40-00-4020 STATE INCOME TAX 40, 144 .61 127, 540.45 566,891.00 22.4 01-000-40-00-4030 MUNICIPAL SALES TAX 200, 177.94 748, 598.68 1, 953,000.00 38.3 01-000-40-00-4032 STATE USE TAX 7,352.45 29, 666.78 79, 101.00 37.5 01-000-40-00-4040 MUNICIPAL UTILITY TAX 84, 442.35 273, 992.69 560,000.00 48.9 01-000-40-00-4041 UTILITY TAX - NICOR 0.00 0.00 26,000.00 0.0 01-000-40-00-4042 UTILITY TAX - CABLE TV 20,059.29 39, 419.69 48,000.00 82.1 01-000-40-00-4043 UTILITY TAX - TELEPHONE 23,263.01 112,557.42 220,000.00 51.1 01-000-40-00-4050 HOTEL TAX 1, 659.82 9, 925.45 19,000.00 52.2 TOTAL TAXES 1,033, 389.89 4, 599,285.19 8,280,728.00 55.5 LICENSES & PERMITS 01-000-41-00-4100 LIQUOR LICENSE 4, 425.00 6,572.62 22, 500.00 29.2 01-000-41-00-4101 OTHER LICENSES 0.00 3,718.26 3, 500.00 106.2 01-000-41-00-4110 BUILDING PERMITS 46,293.00 459,537.80 870,000.00 52.8 TOTAL LICENSES & PERMITS 50,718.00 469,828.68 896,000.00 52.4 CHARGES FOR SERVICES 01-000-42-00-4205 FILING FEES 295.00 14, 066.00 20,000.00 70.3 01-000-42-00-4206 GARBAGE SURCHARGE 29, 996.55 87, 542.27 171, 590.00 51.0 01-000-42-00-4207 REFUSE STICKERS 0.00 0.00 0.00 0.0 01-000-42-00-4208 COLLECTION FEE - YBSD 0.00 0.00 44, 441.00 0.0 01-000-42-00-4210 DEVELOPMENT FEES 169, 988.64 342, 158.03 520,000.00 65.7 01-000-42-00-4211 ENGINEERING CAPITAL FEE 0.00 200.00 20,000.00 1.0 TOTAL CHARGES FOR SERVICES 200,280.19 443, 966.30 776,031.00 57.2 FINES & FORFEITS P1 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 2 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED GENERAL REVENUES FINES & FORFEITS 01-000-43-00-4310 TRAFFIC FINES 3,767.58 35,034 .17 70,000.00 50.0 01-000-43-00-4315 REIMBURSE POLICE TRAINING 0.00 0.00 3, 500.00 0.0 01-000-43-00-4320 ORDINANCE FEES 145.00 1,490.00 2,500.00 59.6 TOTAL FINES & FORFEITS 3, 912.58 36,524.17 76,000.00 48.0 MISCELLANEOUS 01-000-44-00-4401 DARE DONATIONS 0.00 0.00 1,000.00 0.0 01-000-44-00-4402 ROB ROY CREEK HYDRAULIC STUDY 0.00 0.00 20,000.00 0.0 01-000-44-00-4410 REIMBURSEMENTS - OTHER GOVTS 0.00 0.00 0.00 0.0 01-000-44-00-4411 REIMBURSEMENTS-POLICE PROTECTN 220.00 1, 630.00 2,500.00 65.2 1 01-000-44-00-4420 SIDWALK CONSTRUCTION 0.00 596.48 5,000.00 11.9 01-000-44-00-4490 MISCELLANEOUS INCOME 98.36 5,259.78 10,000.00 52.5 TOTAL MISCELLANEOUS 318.36 7,486.26 38, 500.00 19.4 INTERGOVERNMENTAL 01-000-45-00-4505 COPS GRANT - VESTS 0.00 0.00 2,000.00 0.0 01-000-45-00-4510 COPS GRANT 0.00 26,277.13 41, 000.00 64 .0 01-000-45-00-4511 POLICE-STATE TOBACCO GRANT 0.00 1,210.00 0.00 100.0 01-000-45-00-4521 ICJIA BLOCK GRANT 0.00 0.00 0.00 0.0 TOTAL INTERGOVERNMENTAL 0.00 27,487.13 43,000.00 63.9 INTEREST 01-000-46-00-4600 INVESTMENT INCOME 2,887.63 7, 410.10 8,000.00 92.6 TOTAL INTEREST 2,887.63 7, 410.10 8,000.00 92. 6 TRANSFERS 01-000-49-00-4915 TRANSFER FROM WATER OPERATIONS 50,000.00 100,000.00 200,000.00 50.0 01-000-49-00-4920 TRANSFER FROM SEWER MAINT. 17, 500.00 35,000.00 70,000.00 50.0 01-000-49-00-4925 TRANSFER FROM SAN. SEWER 50,000.00 100,000.00 200,000.00 50.0 01-000-49-00-4930 TRANSFER FROM WATER IMPROVE. 50,000.00 100,000.00 200,000.00 50.0 TOTAL TRANSFERS 167,500.00 335,000.00 670,000.00 50.0 P2 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 3 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL REVENUES: GENERAL 1, 459,006.65 5, 926, 987.83 10,788,259.00 54.9 FINANCE & ADMINISTRATION EXPENSES PERSONNEL SERVICES 01-110-50-00-5100 SALARIES - MAYOR 3,785.00 3,785.00 7, 500.00 50.4 01-110-50-00-5101 SALARIES - CITY CLERK 1,835.00 1,835.00 3, 600.00 50.9 01-110-50-00-5102 SALARIES - CITY TREASURER 1,835.00 1, 835.00 3, 600.00 50.9 01-110-50-00-5103 SALARIES - ALDERMAN 14, 680.00 14, 680.00 28, 800.00 50.9 01-110-50-00-5104 SALARIES - LIQUOR COMMISSIONER 500.00 500.00 1, 000.00 50.0 01-110-50-00-5105 SALARIES - CITY ATTORNEY 884 .80 5,751.20 13, 500.00 42.6 01-110-50-00-5106 SALARIES - ADMINISTRATIVE 29,036.62 184, 631.95 459,223.00 40.2 01-110-50-00-5136 SALARIES - PART TIME 2, 648.64 19,264 .85 13, 500.00 142.7 01-110-50-00-5137 SALARIES - OVERTIME 0.00 23.25 1, 500.00 1.5 01-110-50-00-5199 MSI PAYROLL 0.00 0.00 0.00 0.0 01-110-50-00-5202 BENEFITS-UNEMPLOY. COMP. TAX 0.00 2,210.25 9, 000.00 24.5 01-110-50-00-5203 BENEFITS - HEALTH INSURANCE (2, 616.99) 214, 136.62 621, 000.00 34 .4 01-110-50-00-5204 BENEFITS - GROUP LIFE INSURANC 1, 613.49 7, 595.01 18, 000.00 42.1 01-110-50-00-5205 BENEFITS - DENTAL/VISION ASST 1, 409.87 17,701. 61 50, 000.00 35.4 TOTAL PERSONNEL SERVICES 55, 611.43 473, 949.74 1,230,223.00 38.5 PROFESSIONAL SERVICES 01-110-61-00-5300 LEGAL SERVICES 3,799.75 8, 140.48 30, 000.00 27.1 01-110-61-00-5304 AUDIT FEES & EXPENSES 0.00 12,515.70 14, 660.00 85.3 01-110-61-00-5305 ACCOUNTING ASSISTANCE 0.00 3,860.00 5,000.00 77.2 01-110-61-00-5307 ACCOUNTING SYSTEM REVIEW 0.00 0.00 0.00 0.0 01-110-61-00-5308 GASB 34 0.00 0.00 15,000.00 0.0 01-110-61-00-5310 EMPLOYEE ASSISTANCE 850.00 1,700.00 4, 500.00 37.7 01-110-61-00-5311 CODIFICATION 0.00 0.00 5,000.00 0.0 01-110-61-00-5314 BUILDING INSPECTIONS 34,505.90 321,012.10 607, 500.00 52.8 01-110-61-00-5322 BONDING 0.00 757.00 2,000.00 37.8 TOTAL PROFESSIONAL SERVICES 39, 155.65 347, 985.28 683, 660.00 50.9 CONTRACTUAL SERVICES P3 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 4 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED FINANCE & ADMINISTRATION EXPENSES CONTRACTUAL SERVICES 01-110-62-00-5400 INSURANCE-LIABILITY & PROPERTY 0.00 0.00 125,000.00 0.0 01-110-62-00-5401 CONTRACTUAL SERVICES 1,357.38 9,849.26 37, 300.00 26.4 01-110-62-00-5403 SPECIAL CENSUS 0.00 0.00 0.00 0.0 01-110-62-00-5404 CABLE CONSORTIUM FEE 0.00 7,744.16 30,000.00 25.8 01-110-62-00-5406 OFFICE CLEANING 2,075.20 16, 353.27 25,000.00 65.4 01-110-62-00-5410 MAINTENANCE - OFFICE EQUIPMENT 0.00 126.90 500.00 25.3 01-110-62-00-5411 MAINTENANCE - COMPUTERS 0.00 7,743.07 6,000.00 129.0 01-110-62-00-5412 MAINTENANCE - PHOTOCOPIERS 1, 616.00 8, 080.00 19,392.00 41.6 01-110-62-00-5421 WEARING APPAREL 0.00 0.00 0.00 0.0 01-110-62-00-5427 FACADE PROGRAM 0.00 2, 000.00 20,000.00 10.0 01-110-62-00-5436 TELEPHONE 1,893.65 9, 107.87 20,000.00 45.5 01-110-62-00-5437 ACCTG SYSTEM SERVICE FEE 0.00 0.00 7,385.00 0.0 01-110-62-00-5438 CELLULAR TELEPHONE 135.77 805.13 2,300.00 35.0 01-110-62-00-5439 TELEPHONE SYSTEMS MAINTENANCE 0.00 1,237.20 5,000.00 24 .7 TOTAL CONTRACTUAL SERVICES 7,078.00 63,046.86 297,877.00 21.1 PROFESSIONAL DEVELOPMENT 01-110-64-00-5600 DUES 0.00 441.75 4,000.00 11.0 01-110-64-00-5601 ILLINOIS MUNICIPAL LEAGUE DUES 0.00 0.00 551.00 0.0 01-110-64-00-5603 SUBSCRIPTIONS 0.00 195.00 400.00 48.7 01-110-64-00-5604 TRAINING & CONFERENCES 1,044 .48 3, 913.48 6,000.00 65.2 1 01-110-64-00-5605 TRAVEL/MEALS/LODGING 1, 317.58 2, 539.47 19,000.00 13.3 01-110-64-00-5607 PUBLIC RELATIONS 380.30 2,873.03 11,000.00 26.1 TOTAL PROFESSIONAL DEVELOPMENT 2,742.36 9, 962.73 40, 951.00 24 .3 OPERATIONS 01-110-65-00-5800 CONTINGENCIES 0.00 11, 330.50 122, 523.00 9.2 01-110-65-00-5802 OFFICE SUPPLIES 537.71 4,178.07 12,000.00 34 .8 01-110-65-00-5804 OPERATING SUPPLIES 299.29 2,505.29 8,000.00 31.3 01-110-65-00-5808 POSTAGE & SHIPPING 3,345.21 7, 922. 62 8,000.00 99.0 01-110-65-00-5809 PRINTING & COPYING 104.38 2, 668.43 7,000.00 38.1 01-110-65-00-5810 PUBLISHING & ADVERTISING 71.76 1,256.96 2,000.00 62.8 01-110-65-00-5844 MARKETING - HOTEL TAX 5,046.58 9, 695.76 19,000.00 51.0 P4 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 5 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL OPERATIONS 9,404 .93 39, 557.63 178, 523.00 22.1 RETIREMENT 01-110-72-00-6500 IMRF PARTICIPANTS 3,222.08 20, 527.61 47,754 .00 42.9 01-110-72-00-6501 SOCIAL SECURITY & MEDICARE 4, 381.94 18,799.72 37,770.00 49.7 TOTAL RETIREMENT 7, 604.02 39, 327.33 85, 524 .00 45.9 CAPITAL OUTLAY 01-110-75-00-7002 COMPUTER EQUIP & SOFTWARE 2, 536.00 2, 997.89 8, 000.00 37.4 01-110-75-00-7003 OFFICE EQUIPMENT 0.00 1,574.99 4,000.00 39.3 TOTAL CAPITAL OUTLAY 2,536.00 4, 572.88 12,000.00 38.1 OTHER OPERATING EXPENSES 01-110-78-00-9001 CITY TAX REBATE 426.73 510. 67 1,200.00 42.5 01-110-78-00-9002 NICOR GAS 476.75 3, 682.38 20,000.00 18.4 01-110-78-00-9003 SALES TAX REBATE 83,150.04 151,762.45 333, 500.00 45.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 89, 000.00 0.0 TOTAL OTHER OPERATING EXPENSES 84,053.52 156,011.50 443, 800.00 35.1 TRANSFERS 01-110-99-00-9923 TRANSFER TO LIBRARY 0.00 0.00 19, 811.00 0.0 01-110-99-00-9925 TRANSFER TO SAN SEWER 37, 500.00 75,000.00 150,000.00 50.0 01-110-99-00-9940 TRANSFER TO PARK & RECREATION 63,041.33 378,248.00 756, 496.00 50.0 01-110-99-00-9941 TRANSFER TO PARK/REC CAPITAL 3,050.00 18, 300.00 36, 600.00 50.0 01-110-99-00-9945 TRANSFER TO MUNICIPAL BLDG 8,000.00 16, 000.00 32,000.00 50.0 01-110-99-00-9965 TRANSFER TO DEBT SERVICE 0.00 0.00 0.00 0.0 TOTAL TRANSFERS 111,591.33 487, 548.00 994, 907.00 49.0 TOTAL EXPENSES: FINANCE & ADMINISTRATION 319,777.24 1, 621, 961.95 3, 967, 465.00 40.8 ENGINEERING EXPENSES P5 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 6 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL o ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED ENGINEERING PERSONNEL SERVICES 01-150-50-00-5107 SALARIES-EMPLOYEES 16,423.58 118,555.19 235,883.00 50.2 01-150-50-00-5137 SALARIES-OVERTIME 95.41 301.01 500.00 60.2 TOTAL PERSONNEL SERVICES 18,518.99 118,856.20 236,383.00 50.2 CONTRACTUAL SERVICES 01-150-62-00-5401 CONTRACTUAL SERVICES 5,710.75 16,802.66 40, 000.00 42.0 01-150-62-00-5409 MAINTENANCE-VEHICLES 2.98 794 .01 4,500.00 17.6 01-150-62-00-5410 MAINTENANCE-OFFICE EQUIP 0.00 0.00 2,000.00 0.0 01-150-62-00-5411 MAINTENANCE-COMPUTERS 0.00 2, 640.40 3,500.00 75.4 01-150-62-00-5421 WEARING APPAREL 0.00 186.00 1, 100.00 16.9 01-150-62-00-5438 CELLULAR TELEPHONE 308.54 1,019.30 2,800.00 36.4 TOTAL CONTRACTUAL SERVICES 6,022.27 21,442.37 53, 900.00 39.7 PROFESSIONAL DEVELOPMENT 01-150-64-00-5600 DUES 0.00 0.00 300.00 0.0 01-150-64-00-5604 TRAINING & CONFERENCES 0.00 213.00 2, 500.00 8.5 01-150-64-00-5605 TRAVEL EXPENSE 0.00 0.00 1,000.00 0.0 01-150-64-00-5616 BOOKS & PUBLICATIONS 91.32 91.32 200.00 45.6 TOTAL PROFESSIONAL DEVELOPMENT 91.32 304 .32 4,000.00 7.6 OPERATIONS 01-150-65-00-5801 ENGINEERING SUPPLIES 49.97 1,542.94 2,000.00 77.1 01-150-65-00-5802 OFFICE SUPPLIES 162.18 1,040. 69 1,500.00 69.3 01-150-65-00-5809 PRINTING & COPYING 212.00 763.65 1,200.00 63.6 01-150-65-00-5814 STORM WATER SOFTWARE/TRAINING 0.00 1,000.00 5,000.00 20.0 01-150-65-00-5815 ROB ROY CREEK HYDRAULIC STUDY 0.00 0.00 0.00 0.0 01-150-65-00-5820 PICK UP TRUCK 0.00 19, 602.57 40, 000.00 49.0 TOTAL OPERATIONS 424 .15 23, 949.85 49,700.00 48.1 RETIREMENT 01-150-72-00-6500 IMRF PARTICIPANTS 1,864 .87 11, 968.81 23, 804 .00 50.2 01-150-72-00-6501 SOCIAL SECURITY & MEDICARE 1, 416.69 9,092.48 18,083.00 50.2 P6 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 7 TIME: 15:12 :41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL RETIREMENT 3,281.56 21,061.29 41,887.00 50.2 TOTAL EXPENSES: ENGINEERING 28,338.29 185, 614 .03 385, 870.00 48.1 PUBLIC SAFETY/POLICE DEPT. EXPENSES PERSONNEL SERVICES 01-210-50-00-5107 SALARIES - EMPLOYEES 41,269.30 254,792.86 531, 563.00 47.9 01-210-50-00-5131 SALARIES - LIEUTENANT/SERGEANT 34,713.17 234,543.28 446,104 .00 52 .5 01-210-50-00-5133 SALARIES - COPS 11,212.94 73, 957.85 148, 496.00 49.8 01-210-50-00-5134 SALARIES - CROSSING GUARD 1, 603.50 4, 669.07 10,000.00 46.8 01-210-50-00-5135 SALARIES - POLICE CLERKS 7,779.45 46, 839.32 100, 307.00 46.6 01-210-50-00-5136 SALARIES - PART TIME 1, 193.99 6,814.12 20,000.00 34.0 01-210-50-00-5137 SALARIES - OVERTIME 4,328 .53 20,721 .83 50,000.00 41.4 TOTAL PERSONNEL SERVICES 102, 100.88 642, 358.33 1, 306, 470.00 49.1 PROFESSIONAL SERVICES 01-210-61-00-5300 LEGAL SERVICES 375.00 2,124 .65 6,300.00 33.7 TOTAL PROFESSIONAL SERVICES 375.00 2, 124.65 6,300.00 33.7 CONTRACTUAL SERVICES 01-210-62-00-5408 MAINTENANCE - EQUIPMENT 796.98 3,514 .74 8,000.00 43.9 01-210-62-00-5409 MAINTENANCE - VEHICLES 799.48 7, 829.94 21,000.00 37.2 01-210-62-00-5410 MAINT-OFFICE EQUIPMENT 0.00 1,031.54 2,500.00 41.2 01-210-62-00-5411 MAINTENANCE - COMPUTERS 0.00 397.59 2,000.00 19.8 01-210-62-00-5414 WEATHER WARNING SIREN MAINT 0.00 1, 820.00 8, 000.00 22.7 01-210-62-00-5421 WEARING APPAREL 612 .35 4,593.66 20,000.00 22.9 01-210-62-00-5422 COPS GRANT IV - VESTS 0.00 1, 117.28 2, 500.00 44.6 01-210-62-00-5423 CLASY GRANT 0.00 0.00 4,000.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 375.00 1,000.00 37.5 01-210-62-00-5430 HEALTH SERVICES 0.00 2,352.39 3,000.00 78.4 P7 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 8 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED PUBLIC SAFETY/POLICE DEPT. EXPENSES CONTRACTUAL SERVICES 01-210-62-00-5431 LABORATORY FEES 300.00 300.00 1,000.00 30.0 01-210-62-00-5436 TELEPHONE 1,858.01 9,085.21 20,000.00 45.4 01-210-62-00-5438 CELLULAR TELEPHONE 981.78 5,293.40 13,000.00 40.7 01-210-62-00-5440 PAGERS 0.00 0.00 0.00 0.0 01-210-62-00-5441 MTD-ALERTS FEE 0.00 1,056.00 2,300.00 45.9 TOTAL CONTRACTUAL SERVICES 5,348.60 38,766.75 113,300.00 34.2 PROFESSIONAL DEVELOPMENT 01-210-64-00-5600 DUES 0.00 1, 905.00 2,250.00 84 .6 01-210-64-00-5603 SUBSCRIPTIONS 0.00 59.95 300.00 19.9 01-210-64-00-5604 TRAINING & CONFERENCE 860.00 12, 979.02 16,000.00 81.1 01-210-64-00-5605 TRAVEL EXPENSES 397.11 5,521.04 7,000.00 78.8 01-210-64-00-5606 COMMUNITY RELATIONS 0.00 2, 619.68 5,250.00 49.8 01-210-64-00-5607 POLICE COMMISSION 1,363.43 3,504 .21 11,000.00 31.8 01-210-64-00-5608 TUITION REIMBURSEMENT 928.00 2,322.22 14,000.00 16.5 01-210-64-00-5609 POLICE RECRUIT ACADEMY 0.00 0.00 3,500.00 0.0 01-210-64-00-5610 GUN RANGE FEES 0.00 56.64 625.00 9.0 01-210-64-00-5611 SRT FEE 0.00 0.00 2,000.00 0.0 TOTAL PROFESSIONAL DEVELOPMENT 3,548.54 28, 967.76 61, 925.00 46.7 OPERATIONS 01-210-65-00-5800 CONTINGENCIES 0.00 0.00 0.00 0.0 01-210-65-00-5802 OFFICE SUPPLIES 76.85 2, 638.44 6,500.00 40.5 01-210-65-00-5804 OPERATING SUPPLIES 885.61 5,807.48 15,750.00 36.8 01-210-65-00-5808 POSTAGE & SHIPPING 246.00 400.51 3,000.00 13.3 01-210-65-00-5809 PRINTING & COPYING 255.40 963.33 4, 500.00 21.4 01-210-65-00-5810 PUBLISHING & ADVERTISING 0.00 268.00 1,000.00 26.8 01-210-65-00-5812 GASOLINE 5, 924.03 13,835.84 30,000.00 46.1 01-210-65-00-5813 AMMUNITION 0.00 0.00 5,000.00 0.0 TOTAL OPERATIONS 7, 387.89 23, 913.60 65,750.00 36.3 RETIREMENT P8 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 9 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002 .WOW FUND: GENERAL FUND FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED PUBLIC SAFETY/POLICE DEPT. EXPENSES RETIREMENT 01-210-72-00-6500 IMRF PARTICIPANTS 790. 66 4, 162.09 10, 101.00 41.2 01-210-72-00-6501 SOCIAL SECURITY & MEDICARE 7,810.74 49,233.14 99, 945.00 49.2 01-210-72-00-6502 POLICE PENSION 80, 693.49 186,875.81 207,000.00 90.2 TOTAL RETIREMENT 89,294.89 240,271.04 317,046.00 75.7 CAPITAL OUTLAY 01-210-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 4,724.99 8,500.00 55.5 TOTAL CAPITAL OUTLAY 0.00 4, 724 .99 8, 500.00 55.5 OTHER OPERATING EXPENSES 01-210-78-00-9004 BIKE PATROL 0.00 390.85 2,000.00 19.5 TOTAL OTHER OPERATING EXPENSES 0.00 390.85 2,000.00 19.5 TRANSFERS 01-210-99-00-9910 TRANSFER TO PD CAPITAL FUND 0.00 0.00 0.00 0.0 TOTAL TRANSFERS 0.00 0.00 0.00 0.0 TOTAL EXPENSES: PUBLIC SAFETY/POLICE DEPT. 208,055.80 981, 517.97 1,881,291.00 52.1 BUILDING & ZONING EXPENSES PROFESSIONAL SERVICES 01-220-61-00-5300 LEGAL SERVICES 10,211.25 15,895.25 12,000.00 132.4 TOTAL PROFESSIONAL SERVICES 10,211.25 15, 895.25 12,000.00 132.4 CONTRACTUAL SERVICES 01-220-62-00-5401 CONTRACTUAL SERVICES 0.00 46,891.70 50,000.00 93.7 01-220-62-00-5430 PLANNING CONSULTANT 0.00 1,840.00 20,000.00 9.2 P9 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 10 TIME: 15: 12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL o ACCOUNT OCTOBER 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 0.00 45, 000.00 0.0 TOTAL CONTRACTUAL SERVICES 0.00 48,731.70 115,000.00 42.3 PROFESSIONAL DEVELOPMENT 01-220-64-00-5600 DUES 0.00 0.00 200.00 0.0 TOTAL PROFESSIONAL DEVELOPMENT 0.00 0.00 200.00 0.0 OPERATIONS 01-220-65-00-5804 OPERATING SUPPLIES 325.45 614 .16 1,000.00 61.4 01-220-65-00-5809 PRINTING & COPYING 0.00 244 .56 700.00 34 .9 01-220-65-00-5810 PUBLISHING & ADVERTISING 2,062.40 2, 900. 66 8,000.00 36.2 01-220-65-00-5814 BOOKS & MAPS 0.00 277.50 500.00 55.5 TOTAL OPERATIONS 2, 387.85 4,036.88 10,200.00 39.5 TOTAL EXPENSES: BUILDING & ZONING 12,599.10 68, 663.83 137, 400.00 49.9 STREETS EXPENSES PERSONNEL SERVICES 01-410-50-00-5107 SALARIES - EMPLOYEE 12,202.45 76, 957.74 156, 643.00 49.1 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 826.27 4, 473.20 18,000.00 24 .8 TOTAL PERSONNEL SERVICES 13,028.72 83,769.44 180, 143.00 46.5 PROFESSIONAL SERVICES 01-410-61-00-5313 ENGINEERING 0.00 4,269.00 120,000.00 3.5 01-410-61-00-5314 INSPECTIONS & LICENSES 0.00 0.00 100.00 0.0 TOTAL PROFESSIONAL SERVICES 0.00 4,269.00 120, 100.00 3.5 P10 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 11 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND I FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL o ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED STREETS CONTRACTUAL SERVICES 01-410-62-00-5401 CONTRACTUAL SERVICES 100.00 500.00 2,000.00 25.0 01-410-62-00-5408 MAINTENANCE-EQUIPMENT 0.00 2,212.35 10, 000.00 22.1 01-410-62-00-5409 MAINTENANCE-VEHICLES 114 .50 1, 801.30 11,000.00 16.3 01-410-62-00-5414 MAINTENANCE-TRAFFIC SIGNALS 1,264 .51 9, 414 .46 12,500.00 75.3 01-410-62-00-5415 MAINTENANCE-STREET LIGHTS 0.00 6,412.14 20,500.00 31.2 01-410-62-00-5420 MAINTENANCE-STORM SEWER 0.00 2, 341.18 5,000.00 46.8 01-410-62-00-5421 WEARING APPAREL 593.79 1, 135.46 5,800.00 19.5 01-410-62-00-5434 RENTAL-EQUIPMENT 600.00 600.00 1, 000.00 60.0 01-410-62-00-5435 ELECTRICITY 4,290.45 21, 141.30 47,000.00 44.9 01-410-62-00-5438 CELLULAR TELEPHONE 203. 65 780.32 2, 600.00 30.0 01-410-62-00-5440 STREET LIGHTING 0.00 0.00 4, 500.00 0.0 TOTAL CONTRACTUAL SERVICES 7, 166.90 46,338.51 121, 900.00 38.0 PROFESSIONAL DEVELOPMENT 01-410-64-00-5604 TRAINING & CONFERENCES 60.00 307.45 5, 600.00 5.4 TOTAL PROFESSIONAL DEVELOPMENT 60.00 307.45 5, 600.00 5.4 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 283.70 1,739.52 9,500.00 18 .3 01-410-65-00-5812 GASOLINE 2, 180.75 5, 424.33 16, 000.00 33.9 01-410-65-00-5815 HAND TOOLS 0.00 260.16 1, 500.00 17.3 01-410-65-00-5817 GRAVEL 0.00 863.53 4,000.00 21.5 TOTAL OPERATIONS 2,464 .45 8,287.54 31,000.00 26.7 RETIREMENT 01-410-72-00-6500 IMRF PARTICIPANTS 1, 311.99 8,200.05 17, 587.00 46.6 01-410-72-00-6501 SOCIAL SECURITY & MEDICARE 996.72 6,408.45 13,780.00 46.5 TOTAL RETIREMENT 2,308.71 14, 608.50 31, 367.00 46.5 CAPITAL OUTLAY P11 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 12 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: GENERAL FUND FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED STREETS EXPENSES CAPITAL OUTLAY 01-410-75-00-5418 MOSQUITO CONTROL 0.00 27, 571.95 22,000.00 125.3 01-410-75-00-5419 MAINT SUPPLIES - STREET 645.89 1, 362.10 15,000.00 9.0 01-410-75-00-7004 SAFETY EQUIPMENT 50.45 194 .37 1,000.00 19.4 01-410-75-00-7099 BRISTOL RIDGE ROAD 0.00 669, 641 .17 2, 690,000.00 24 .8 01-410-75-00-7100 STREET REHAB PROJECTS 971.57 44,726.53 150,000.00 29.8 01-410-75-00-7101 IN TOWN ROAD PROGRAM 0.00 45,280.80 500,000.00 9.0 01-410-75-00-7102 TREE & STUMP REMOVAL 1,090.00 3,797.50 20,000.00 18.9 01-410-75-00-7103 SIDEWALK CONSTRUCTION 0.00 19, 914.01 35,000.00 56.8 01-410-75-00-7104 FOX HILL SSA EXPENSES 0.00 0.00 0.00 0.0 TOTAL CAPITAL OUTLAY 2,757 .91 812,488.43 3,433,000.00 23.6 TOTAL EXPENSES: STREETS 27,786.69 970,068.87 3, 923,110.00 24 .7 HEALTH & SANITATION EXPENSES CONTRACTUAL SERVICES 01-540-62-00-5442 GARBAGE SERVICES 42,284 .16 201,862.55 489,123.00 41.2 01-540-62-00-5443 LEAF PICKUP 0.00 600.00 4,000.00 15.0 TOTAL CONTRACTUAL SERVICES 42,284 .16 202, 462.55 493, 123.00 41.0 TOTAL EXPENSES: HEALTH & SANITATION 42,284 .16 202, 462.55 493, 123.00 41.0 TOTAL FUND REVENUES 1,459,006.65 5,926,987 .83 10,788,259.00 54 .9 TOTAL FUND EXPENSES 638,841.28 4, 030,289.20 10,788,259.00 37.3 FUND SURPLUS (DEFICIT) 820, 165.37 1,896, 698.63 0.00 100.0 P12 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 13 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: MOTOR FUEL TAX FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES TAXES 15-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 340,000.00 0.0 15-000-40-00-4060 MOTOR FUEL TAX ALLOTMENTS 22,866.84 129,076. 62 256, 199.00 50.3 15-000-40-00-4065 IDOT TRUCK ACCESS GRANT 0.00 0.00 0.00 0.0 TOTAL TAXES 22,866.84 129,076.62 596, 199.00 21.6 INTEREST 15-000-46-00-4600 INVESTMENT INCOME 1,408 .65 2,400.12 3,000.00 80.0 TOTAL INTEREST 1, 408. 65 2, 400.12 3,000.00 80.0 TOTAL REVENUES: 24,275.49 131, 476.74 599,199.00 21.9 EXPENSES OPERATIONS 15-000-65-00-5800 CONTINGENCY 28,810.32 28,810.32 211,499.00 13.6 15-000-65-00-5818 SALT 0.00 0.00 37,000.00 0.0 TOTAL OPERATIONS 28,810.32 28,810.32 248, 499.00 11.5 CAPITAL OUTLAY 15-000-75-00-7007 SIGNS 2, 995.09 7, 140.72 9,700.00 73.6 15-000-75-00-7008 CRACK FILLING 0.00 24, 122.58 30,000.00 80.4 15-000-75-00-7107 CONSTRUCTION ENGINEERING (157,402.50) 55, 142.00 200,000.00 27.5 15-000-75-00-7108 VAN EMMON STREET 0.00 0.00 100,000.00 0.0 15-000-75-00-7110 COLD PATCH 0.00 592.11 4, 000.00 14 .8 15-000-75-00-7111 HOT PATCH 0.00 2, 655.45 7,000.00 37.9 TOTAL CAPITAL OUTLAY (154, 407.41) 89, 652.86 350,700.00 25.5 TRANSFERS 15-000-99-00-9960 TRANSFER TO FOX IND FUND 0.00 0.00 0.00 0.0 TOTAL TRANSFERS 0.00 0.00 0.00 0.0 P13 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 14 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: MOTOR FUEL TAX FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL EXPENSES: (125, 597.09) 118,463.18 599, 199.00 19.7 TOTAL FUND REVENUES 24,275.49 131,476.74 599, 199.00 21.9 TOTAL FUND EXPENSES (125,597 .09) 118,463.18 599, 199.00 19.7 FUND SURPLUS (DEFICIT) 149,872.58 13,013.56 0.00 100.0 P14 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 15 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.W0W FUND: MUNICIPAL BUILDLING FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER 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 1, 950.00 26,350.00 57, 600.00 45.7 TOTAL CHARGES FOR SERVICES 1, 950.00 26,350.00 57, 600.00 45.7 TRANSFERS 16-000-49-00-4901 TRANSFER FROM GENERAL FUND 8,000.00 16,000.00 32,000.00 50.0 TOTAL TRANSFERS 8,000.00 16, 000.00 32,000.00 50.0 TOTAL REVENUES: 9, 950.00 42, 350.00 89, 600.00 47.2 EXPENSES CONTRACTUAL SERVICES 16-000-62-00-5416 MAINT-GENERAL BLDG & GROUNDS 1,771. 60 2, 161. 60 5,000.00 43.2 TOTAL CONTRACTUAL SERVICES 1,771. 60 2,161. 60 5, 000.00 43.2 CAPITAL OUTLAY 16-000-75-00-7008 ENTRY WAY SIGNS 0.00 0.00 3, 600.00 0.0 16-000-75-00-7200 BLDG IMPROV- BEEHCER/RIVFRNT 571.12 1,233.53 13,000.00 9.4 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 450.00 1,027.66 9, 000.00 11.4 16-000-75-00-7204 BLDG MAINT - CITY HALL 193.39 7,087.36 5, 000.00 141.7 16-000-75-00-7205 BLDG IMPROVEMENTS-LIBRARY 90.15 1,453. 60 4,000.00 36.3 16-000-75-00-7206 LANDSCAPING-PUBLIC BUILDINGS 0.00 98.19 5,000.00 1.9 16-000-75-00-7209 BEECHER PARKING LOT 480.00 2, 457.12 45,000.00 5.4 TOTAL CAPITAL OUTLAY 1,784.66 13,357.46 84, 600.00 15.7 P15 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 16 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: MUNICIPAL BUILDLING FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED OTHER 16-000-78-00-9009 RESERVE 0.00 0.00 0.00 0.0 TOTAL OTHER 0.00 0.00 0.00 0.0 TOTAL EXPENSES: 3,556.26 15, 519.06 89, 600.00 17.3 TOTAL FUND REVENUES 9, 950.00 42,350.00 89, 600.00 47.2 TOTAL FUND EXPENSES 3,556.26 15, 519.06 89, 600.00 17 .3 FUND SURPLUS (DEFICIT) 6,393.74 26,830.94 0.00 100.0 P16 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 17 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: POLICE EQUIPMENT CAPITAL FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CARRY OVER 20-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 40,000.00 0.0 TOTAL CARRY OVER 0.00 0.00 40,000.00 0.0 CHARGES FOR SERVICES 20-000-42-00-4212 DEV FEES - POLICE 3, 600.00 39, 600.00 99, 900.00 39. 6 TOTAL CHARGES FOR SERVICES 3, 600.00 39, 600.00 99, 900.00 39.6 MISCELLANEOUS 20-000-44-00-4402 K-9 DONATIONS 1, 500.00 1, 500.00 500.00 300.0 20-000-44-00-4403 IN CAR VIDEO DONATIONS 100.00 1, 500.00 2,000.00 75.0 20-000-44-00-4404 DONATIONS 0.00 387.00 0.00 100.0 20-000-44-00-4405 WEATHER WARNING SIREN 0.00 5, 137.50 40,000.00 12.8 20-000-44-00-4431 SALE OF POLICE SQUADS 0.00 0.00 1,000.00 0.0 TOTAL MISCELLANEOUS 1, 600.00 8, 524 .50 43,500.00 19.5 OTHER OPERATING RECEIPTS 20-000-48-00-4800 LOAN PROCEEDS 0.00 0.00 62, 500.00 0.0 TOTAL OTHER OPERATING RECEIPTS 0.00 0.00 62,500.00 0.0 TRANSFERS 20-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 0.00 0.00 0.0 TOTAL TRANSFERS 0.00 0.00 0.00 0.0 TOTAL REVENUES: 5,200.00 48, 124. 50 245, 900.00 19.5 EXPENSES WEAPONS 20-000-65-00-5811 LETHAL/NON-LETHAL WEAPONS 0.00 0.00 6, 500.00 0.0 TOTAL WEAPONS 0.00 0.00 6,500.00 0.0 P17 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 18 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: POLICE EQUIPMENT CAPITAL FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED CAPITAL OUTLAY 20-000-75-00-7001 EQUIPMENT (5,110.50) 2, 942 .28 7,350.00 40.0 20-000-75-00-7002 K-9 EQUIPMENT 0.00 0.00 0.00 0.0 20-000-75-00-7003 EXPEDITION AND ACCESSORIES 0.00 0.00 0.00 0.0 20-000-75-00-7005 VEHICLES 0.00 18,224 .00 62, 500.00 29.1 20-000-75-00-7006 CAR BUILD OUT 6,137.50 6,137 .50 23,360.00 26.2 20-000-75-00-7008 NEW WEATHER WARNING SIRENS 0.00 0.00 70,000.00 0.0 TOTAL CAPITAL OUTLAY 1,027.00 27, 303.78 163,210.00 16.7 OTHER 20-000-78-00-9009 RESERVE 0.00 9, 999.00 3,038.00 329.1 TOTAL OTHER 0.00 9, 999.00 3, 038.00 329.1 TRANSFERS 20-000-99-00-9965 TRANSFER TO DEBT SERV FUND 18,288.00 36, 576.00 73, 152.00 50.0 TOTAL TRANSFERS 18,288.00 36, 576.00 73, 152.00 50.0 TOTAL EXPENSES: 19, 315.00 73,878.78 245, 900.00 30.0 TOTAL FUND REVENUES 5, 200.00 48, 124 .50 245, 900.00 19.5 TOTAL FUND EXPENSES 19,315.00 73, 878.78 245, 900.00 30.0 FUND SURPLUS (DEFICIT) (14,115.00) (25,754 .28) 0.00 100.0 P18 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 19 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002 .WOW FUND: PUBLIC WORKS EQUIP CAPITAL FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CARRY OVER 21-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 140,000.00 0.0 TOTAL CARRY OVER 0.00 0.00 140,000.00 0.0 CHARGES FOR SERVICES 21-000-42-00-4213 DEVELOPMENT FEES-PUBLIC WORKS 10,800.00 118,800.00 279,700.00 42 .4 TOTAL CHARGES FOR SERVICES 10,800.00 118,800.00 279,700.00 42.4 MISCELLANEOUS 21-000-44-00-4430 SALE OF EQUIPMENT 0.00 4,510.11 0.00 100.0 TOTAL MISCELLANEOUS 0.00 4,510.11 0.00 100.0 TRANSFERS 21-000-49-00-4915 TRANSFER FROM WATER FUND 12,500.00 25,000.00 50,000.00 50.0 21-000-49-00-4920 TRANSFER FROM SEWER FUND 7,500.00 15,000.00 30,000.00 50.0 TOTAL TRANSFERS 20,000.00 40,000.00 80,000.00 50.0 TOTAL REVENUES: 30,800.00 163,310.11 499,700.00 32.6 EXPENSES CAPITAL OUTLAY 21-000-75-00-7005 VEHICLES 0.00 42,130.00 100,000.00 42 .1 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 UPGRAGE 0.00 9,500.00 4,500.00 211 .1 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 0.00 5,000.00 0.0 21-000-75-00-7108 AUGER SYSTEM 0.00 0.00 9,000.00 0.0 P19 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 20 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: PUBLIC WORKS EQUIP CAPITAL FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES CAPITAL OUTLAY 21-000-75-00-7109 MOWER 21, 000.00 21, 000.00 21,000.00 100.0 21-000-75-00-7120 STREET SWEEPER 0.00 0.00 140,000.00 0.0 21-000-75-00-7130 PUBLIC WORKS BLDG ADDITION 0.00 0.00 90,000.00 0.0 TOTAL CAPITAL OUTLAY 21,000.00 72, 630.00 369,500.00 19.6 OTHER 21-000-78-00-9009 RESERVE 0.00 35,557.00 130,200.00 27.3 TOTAL OTHER 0.00 35, 557.00 130,200.00 27.3 TOTAL EXPENSES: 21, 000.00 108, 187.00 499,700.00 21.6 TOTAL FUND REVENUES 30,800.00 163,310.11 499,700.00 32.6 TOTAL FUND EXPENSES 21, 000.00 108, 187.00 499,700.00 21. 6 FUND SURPLUS (DEFICIT) 9,800.00 55,123.11 0.00 100.0 P20 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 21 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: PARKS & REC EQUIP CAPITAL FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL o ACCOUNT OCTOBER 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 10,000.00 246.2 TOTAL CARRY OVER 0.00 24,624 .00 10,000.00 246.2 CHARGES FOR SERVICES 22-000-42-00-4216 PARKS CAPITAL FEE 0.00 100.00 5,000.00 2.0 22-000-42-00-4218 IL CLEAN ENERGY GRANT 0.00 4,149.00 0.00 100.0 TOTAL CHARGES FOR SERVICES 0.00 4,249.00 5,000.00 84 .9 TRANSFERS 22-000-49-00-4930 TRANSFER FRM GENERAL FUND 3,050.00 12,200.00 36, 600.00 33.3 22-000-49-00-4935 TRANSFER FROM LAND CASH 0.00 6,100.00 22,000.00 27.7 TOTAL TRANSFERS 3,050.00 18,300.00 58, 600.00 31.2 TOTAL REVENUES: 3,050.00 47,173.00 73, 600.00 64 .0 EXPENSES OTHER 22-000-65-00-5800 CONTINGENCY 0.00 0.00 0.00 0.0 22-000-65-00-5805 BEECHER LIGHTING 0.00 0.00 0.00 0.0 TOTAL OTHER 0.00 0.00 0.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 28,000.00 95.9 22-610-75-00-7007 SOCCER GOALS 12' REPLACEMENT 0.00 3,022.21 2,000.00 151.1 22-610-75-00-7008 SOCCER GOALS 9' 0.00 0.00 2,000.00 0.0 22-610-75-00-7009 COMPUTER WORKSTATIONS 0.00 1, 635.74 7,000.00 23.3 P21 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 22 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002 .WOW FUND: PARKS & REC EQUIP CAPITAL FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER 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 PLAYER BENCHES 1,720.00 1,720.00 2,000.00 86.0 22-610-75-00-7012 RIVERFRONT PLAYGROUND 0.00 0.00 5,000.00 0.0 22-610-75-00-7013 PLAYGROUND REPAIRS 0.00 0.00 5,000.00 0.0 22-610-75-00-7014 SIGN REPLACEMENTS 0.00 0.00 5,000.00 0.0 22-610-75-00-7015 MOWER 19, 857.27 19,857.27 15,000.00 132.3 22-610-75-00-7016 BEECHER PATHWAY 0.00 9, 480.00 0.00 (100.0) 22-610-75-00-7017 RECREATION EQUIPMENT 0.00 923.88 2, 600.00 35.5 TOTAL CAPITAL OUTLAY 21, 577.27 63, 500.10 73, 600.00 86.2 TOTAL EXPENSES: PARKS 21,577.27 63,500.10 73, 600.00 86.2 TOTAL FUND REVENUES 3,050.00 47,173.00 73, 600.00 64 .0 TOTAL FUND EXPENSES 21,577 .27 63,500.10 73, 600.00 86.2 FUND SURPLUS (DEFICIT) (18, 527 .27) (16,327 .10) 0.00 100.0 P22 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 23 TIME: 15:12 :41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.W0W FUND: SANITARY SEWER IMPROVEMENT FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CARRY OVER 37-000-40-00-3999 CARRY OVER 0.00 0.00 12, 692,117.00 0.0 TOTAL CARRY OVER 0.00 0.00 12, 692,117.00 0.0 CHARGES FOR SERVICES 37-000-42-00-4220 CONNECTION FEES 23,400.00 336, 400.00 1, 071,200.00 31.4 37-000-42-00-4221 RIVER CROSSING FEES 955.50 10, 976.50 12,506.00 87.7 TOTAL CHARGES FOR SERVICES 24,355.50 347,376.50 1, 083,706.00 32.0 INTEREST 37-000-46-00-4600 INVESTMENT INCOME 0.00 0.00 15,000.00 0.0 TOTAL INTEREST 0.00 0.00 15,000.00 0.0 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 450,000.00 0.00 100.0 TOTAL OTHER OPERATING RECEIPTS 100,000.00 450,000.00 0.00 100.0 TRANSFERS 37-000-49-00-4901 TRANSFER FROM GENERAL FUND 37, 500.00 75,000.00 150,000.00 50.0 TOTAL TRANSFERS 37, 500.00 75,000.00 150,000.00 50.0 TOTAL REVENUES: 161,855.50 872,376.50 13, 940,823.00 6.2 EXPENSES CONTRACTUAL SERVICES 37-000-62-00-5401 CONTRACTURAL/PROFESSIONAL SERV 0.00 2,026.75 40,000.00 5.0 37-000-62-00-5402 ENG/LGL/CONTINGNCY-COUNTRYSIDE 17, 186.06 28, 122.56 515,759.00 5.4 P23 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 24 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: SANITARY SEWER IMPROVEMENT FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL o ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES CONTRACTUAL SERVICES 37-000-62-00-5405 ENG/LGL/CONTINGENCY-BRUELL ST. 130.00 29, 694 .16 315,000.00 9.4 37-000-62-00-5406 ENG/LGL/CONTINGENCY-HYDRAULIC 10,779.82 43,039.12 666, 625.00 6.4 TOTAL CONTRACTUAL SERVICES 28, 095.88 102, 882.59 1,537, 384.00 6.6 OTHER 37-000-65-00-5421 GIS SYSTEM 0.00 0.00 20, 000.00 0.0 37-000-65-00-5800 CONTINGENCY 7,444 .38 7, 444 .38 2, 576, 138.00 0.2 TOTAL OTHER 7,444 .38 7, 444 .38 2,596, 138.00 0.2 CAPITAL OUTLAY 37-000-75-00-7502 HYDRAULIC INTERCEPTOR 530, 460.00 549, 063.73 4, 335,000.00 12.6 37-000-75-00-7503 COUNTRYSIDE INTERCEPTOR 0.00 15, 462.25 2,933,735.00 0.5 37-000-75-00-7504 BRUELL STREET LIFT STATION 0.00 343,098.10 1, 475,000.00 23.2 37-000-75-00-7505 ROB ROY CREEK SANITARY 70, 320.00 272, 820.00 0.00 (100.0) 37-000-75-00-7507 SANITARY JETTER TRUCK 0.00 224, 928.00 225,000.00 99.9 37-000-75-00-7515 HEARTLAND ONSITE INTERCEPTOR 0.00 0.00 200,000.00 0.0 TOTAL CAPITAL OUTLAY 600,780.00 1,405,372.08 9, 168,735.00 15.3 TRANSFERS 37-000-99-00-9901 TRANSFER TO GENERAL FUND 50,000.00 100,000.00 200,000.00 50.0 37-000-99-00-9965 TRANSFER TO DEBT SERVICE 109, 641.50 219, 283.00 438, 566.00 50.0 TOTAL TRANSFERS 159, 641.50 319,283.00 638,566.00 50.0 TOTAL EXPENSES: 795,961.76 1,834, 982.05 13,940,823.00 13.1 TOTAL FUND REVENUES 161,855.50 872,376.50 13,940,823.00 6.2 TOTAL FUND EXPENSES 795, 961.76 1,834, 982.05 13, 940,823.00 13.1 FUND SURPLUS (DEFICIT) (634, 106.26) (962, 605.55) 0.00 100.0 P24 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 25 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CARRY OVER 41-000-40-00-3999 CARRY OVER 0.00 0.00 4,581, 458.00 0.0 TOTAL CARRY OVER 0.00 0.00 4,581,458.00 0.0 CHARGES FOR SERVICES 41-000-42-00-4220 CONNECTION FEES 27, 140.00 217, 930.00 1,460, 800.00 14 .9 TOTAL CHARGES FOR SERVICES 27,140.00 217,930.00 1,460,800.00 14 .9 INTERGOVERNMENTAL 41-000-45-00-4530 RADIUM GRANT 0.00 873,440.16 0.00 100.0 TOTAL INTERGOVERNMENTAL 0.00 873, 440.16 0.00 100.0 INTEREST 41-000-46-00-4600 INVESTMENT INCOME 0.00 0.00 15,000.00 0.0 TOTAL INTEREST 0.00 0.00 15,000.00 0.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 0.00 0.00 4,400,000.00 0.0 41-000-48-00-4802 PROCEEDS ON SALE OF ASSETS 0.00 0.00 0.00 0.0 41-000-48-00-4803 LOAN PROCEEDS-CENTRAL ZONE 0.00 0.00 0.00 0.0 TOTAL OTHER OPERATING RECEIPTS 0.00 0.00 4, 400,000.00 0.0 TRANSFERS 41-000-49-00-4915 TRANSFER FROM WATER FUND 17, 500.00 35,000.00 70,000.00 50.0 TOTAL TRANSFERS 17,500.00 35,000.00 70,000.00 50.0 TOTAL REVENUES: 44, 640.00 1, 126,370.16 10,527,258 .00 10.6 EXPENSES P25 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 26 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED PROFESSIONAL SERVICE 41-000-61-00-5300 LEGAL SERVICES 0.00 75.00 10, 000.00 0.7 41-000-61-00-5301 ENGINEERING - GENERAL SERVICES 648.00 648.00 0.00 (100.0) 41-000-61-00-5400 RADIUM COMPLIANCE -CONTRACT B 0.00 0.00 3, 662,730.00 0.0 41-000-61-00-5401 ENGINEERING-RADIUM CONTRACT B 5,820.80 16,938.87 476,155.00 3.5 41-000-61-00-5405 PROF. SVCS- RADIUM CONTRACT B 6, 669.00 6, 669.00 261, 115.00 2.5 41-000-61-00-5408 CENTRAL ZONE - CONTRACT C 365, 641 .84 1,327,382 .95 3,404,855.00 38.9 41-000-61-00-5410 ENGINEERING-CENTRAL ZONE 34, 108.49 124,496.51 91,360.00 136.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 0.00 (100.0) 41-000-61-00-5415 USGS GROUNDWATER STUDY 5,360.00 7,079.00 0.00 (100.0) TOTAL PROFESSIONAL SERVICE 418,248.13 1, 485,393.57 7, 906,215.00 18.7 OTHER 41-000-65-00-5421 GIS SYSTEM 0.00 0.00 30,000.00 0.0 41-000-65-00-5800 CONTINGENCY 0.00 93, 184 .75 901, 437.00 10.3 TOTAL OTHER 0.00 93, 184 .75 931, 437.00 10.0 DEBT SERVICE 41-000-66-00-6012 DEBT CERTIFICATE EXPENSES 0.00 0.00 0.00 0.0 TOTAL DEBT SERVICE 0.00 0.00 0.00 0.0 CAPITAL OUTLAY 41-000-75-00-7503 SOUTHWEST WATER MAIN PROJECT 0.00 0.00 0.00 0.0 41-000-75-00-7504 NORTH WATER TOWER-CONTRACT A 52, 518.00 57, 659.46 1,085,243.00 5.3 41-000-75-00-7506 APPLETREE COURT 0.00 0.00 0.00 0.0 41-000-75-00-7515 JOHNSON STREET WATER MAIN 36,023.35 36,023.35 40,000.00 90.0 TOTAL CAPITAL OUTLAY 88,541 .35 93, 682.81 1,125,243.00 8 .3 TRANSFERS 41-000-99-00-9901 TRANSFER TO GENERAL FUND 50, 000.00 100, 000.00 200,000.00 50.0 41-000-99-00-9965 TRANSFER TO DEBT FUND 91, 090.75 182, 181.50 364, 363.00 50.0 TOTAL TRANSFERS 141, 090.75 282,181.50 564, 363.00 50.0 P26 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 27 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: WATER IMPROV. EXPANSION FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL EXPENSES: 647,880.23 1,954,442.63 10,527,258 .00 18.5 TOTAL FUND REVENUES 44, 640.00 1, 126,370.16 10,527,258.00 10. 6 TOTAL FUND EXPENSES 647,880.23 1, 954,442.63 10,527,258.00 18.5 FUND SURPLUS (DEFICIT) (603,240.23) (828,072.47) 0.00 100.0 P27 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 28 TIME: 15:12:41 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: DEBT SERVICE FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CARRY OVER 42-000-40-00-3999 CARRY OVER 0.00 0.00 50,000.00 0.0 TOTAL CARRY OVER 0.00 0.00 50, 000.00 0.0 MISCELLANEOUS 42-000-44-00-4440 RECAPTURE-WATER/SEWER 2,756.00 13,967.00 75,000.00 18 .6 TOTAL MISCELLANEOUS 2,756.00 13, 967.00 75,000.00 18.6 TRANSFERS 42-000-49-00-4901 TRANSFER FROM GENERAL FUND 0.00 0.00 0.00 0.0 42-000-49-00-4910 TRANSFER FROM POLICE EQUIP CAP 18,288.00 36, 576.00 73, 152.00 50.0 42-000-49-00-4920 TRANSFER FROM SEWER FUND 0.00 0.00 0.00 0.0 42-000-49-00-4925 TRANSFER FROM SANITARY SEWER 109, 641.50 219,283.00 438,566.00 50.0 42-000-49-00-4930 TRANSFER FROM WATER IMPRV FUND 91,090.75 182, 181.50 364,363.00 50.0 TOTAL TRANSFERS 219,020.25 438,040.50 876,081.00 50.0 TOTAL REVENUES: 221,776.25 452, 007.50 1,001,081.00 45.1 EXPENSES DEBT SERVICE 42-000-66-00-6001 CITY HALL BONDS-PRINCIPAL PMT 0.00 0.00 50,000.00 0.0 42-000-66-00-6002 CITY HALL BONDS - INTEREST PMT 0.00 27, 498.75 54, 998.00 49.9 42-000-66-00-6003 IRBB-BRUELL ST. INTEREST PMTS 0.00 43, 357.50 86,715.00 50.0 42-000-66-00-6004 IRBB-BRUELL ST. PRINCIPAL PYMT 0.00 0.00 80,000.00 0.0 42-000-66-00-6005 NORTH H2O TOWER INTEREST PYMT 0.00 1,017.00 1,017.00 100.0 42-000-66-00-6006 NORTH H2O TOWER PRINCIPAL PYMT 0.00 23, 983.00 23, 983.00 100.0 42-000-66-00-6007 4.8 MILLION DEBT CERT INT PYMT 0.00 222,787.82 339,363.00 65.6 42-000-66-00-6009 COUNTRYSIDE ALT REV INT PYMT 0.00 39,877.48 100,196.00 39.7 42-000-66-00-6010 COMED/HYDRAULIC INTEREST PYMT 0.00 0.00 35,895.00 0.0 42-000-66-00-6050 LOAN PAYMENT-SANITARY SIPHON 0.00 19, 489.99 38, 989.00 49.9 42-000-66-00-6051 LOAN PAYMENT-NORTH WTR/SWR-EDC 0.00 0.00 0.00 0.0 42-000-66-00-6052 LOAN PAYMENT-NORTH WTR/SWR-YNB 0.00 0.00 0.00 0.0 P28 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 29 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: DEBT SERVICE FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL a ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES DEBT SERVICE 42-000-66-00-6053 LOAN PAYMENT-RIVER CROSSING 0.00 0.00 0.00 0.0 42-000-66-00-6054 LOAN PAYMENT-POLICE SQUAD CAR 0.00 24,109.66 24,110.00 99.9 42-000-66-00-6055 LOAN PAYMENT-SSES IEPA L171153 0.00 53,525.35 107,051.00 49.9 42-000-66-00-6056 YNB-POLICE/ADMIN CARS 0.00 58,781.10 58,764 .00 100.0 42-000-66-00-6057 IRBB-BRUELL ST. INTEREST PMT 0.00 0.00 0.00 0.0 TOTAL DEBT SERVICE 0.00 514,427.65 1,001,081.00 51.3 TOTAL FUND REVENUES 221,776.25 452,007.50 1,001,081.00 45.1 TOTAL FUND EXPENSES 0.00 514,427.65 1,001,081.00 51.3 FUND SURPLUS (DEFICIT) 221,776.25 (62,420.15) 0.00 100.0 P29 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 30 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CARRY OVER 51-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 1,500, 000.00 0.0 TOTAL CARRY OVER 0.00 0.00 1, 500,000.00 0.0 CHARGES FOR SERVICES 51-000-42-00-4240 BULK WATER SALES 1,265.64 5, 442.28 5,000.00 108.8 51-000-42-00-4241 WATER SALES 181, 545.11 522, 822.32 950,000.00 55.0 51-000-42-00-4242 WATER METER SALES 6,825.00 80,899.20 130,000.00 62.2 51-000-42-00-4243 LEASE REVENUE - H2O TOWER 1,800.00 10,800.00 0.00 100.0 TOTAL CHARGES FOR SERVICES 191, 435.75 619, 963.80 1, 085,000.00 57.1 MISCELLANEOUS 51-000-44-00-4490 MISCELLANEOUS INCOME 0.00 202 .00 500.00 40.4 TOTAL MISCELLANEOUS 0.00 202.00 500.00 40.4 INTEREST 51-000-46-00-4600 INVESTMENT INCOME 1,886.95 4,345.16 6,000.00 72.4 TOTAL INTEREST 1,886.95 4, 345.16 6,000.00 72.4 TOTAL REVENUES: 193,322.70 624, 510.96 2,591, 500.00 24.0 EXPENSES PERSONNEL 51-000-50-00-5107 SALARIES - EMPLOYEE 16,284 .78 93, 982.26 217,348.00 43.2 51-000-50-00-5136 SALARIES-PART TIME 500.00 5,468 .40 4,000.00 136.7 51-000-50-00-5137 SALARIES - OVERTIME 2,078.67 14, 186.85 27, 000.00 52.5 TOTAL PERSONNEL 18,863.45 113, 637.51 248,348.00 45.7 PROFESSIONAL SERVICES 51-000-61-00-5300 LEGAL SERVICES 0.00 0.00 2,000.00 0.0 P3O DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 31 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES PROFESSIONAL SERVICES 51-000-61-00-5303 JULIE SERVICE 713.00 2,812.60 5, 000.00 56.2 TOTAL PROFESSIONAL SERVICES 713.00 2, 812.60 7,000.00 40.1 CONTRACTURAL SERVICES 51-000-62-00-5401 CONTRACUAL SERVICES 50.00 2, 388.84 4,000.00 59.7 51-000-62-00-5407 TREATMENT FACILITIES O&M 0.00 0.00 44,000.00 0.0 51-000-62-00-5408 MAINTENANCE-EQUIPMENT 0.00 2, 369.19 10,000.00 23.6 51-000-62-00-5409 MAINTENANCE - VEHICLES 1,574 .00 1,836.03 10,000.00 18 .3 51-000-62-00-5411 MAINTENANCE-COMPUTERS 0.00 218.83 4,000.00 5.4 51-000-62-00-5413 MAINTENANCE-CONTROL SYSTEM 0.00 2,386.93 4,000.00 59. 6 51-000-62-00-5414 TRUCK LETTERING 0.00 464 .00 1, 000.00 46.4 51-000-62-00-5421 WEARING APPAREL 593.79 1, 139.14 5,500.00 20.7 51-000-62-00-5434 RENTAL - EQUIPMENT 0.00 0.00 1,000.00 0.0 51-000-62-00-5435 ELECTRICITY 8,088.47 40, 807.59 170,000.00 24.0 51-000-62-00-5436 TELEPHONE 2,022.51 9,877.96 20,000.00 49.3 51-000-62-00-5438 CELLULAR TELEPHONE 320.19 1, 563.72 5, 500.00 28 .4 TOTAL CONTRACTURAL SERVICES 12, 648 .96 63,052 .23 279,000.00 22 .5 PROFESSIONAL DEVELOPMENT 51-000-64-00-5600 DUES 0.00 649.00 750.00 86.5 51-000-64-00-5603 SUBSCRIPTIONS 0.00 0.00 250.00 0.0 51-000-64-00-5604 TRAINING & CONFERENCES 645.00 750.00 6,900.00 10.8 51-000-64-00-5605 TRAVEL EXPENSES 158.46 1, 123.44 2,000.00 56.1 TOTAL PROFESSIONAL DEVELOPMENT 803.46 2,522.44 9, 900.00 25.4 OPERATIONS 51-000-65-00-5800 CONTINGENCIES 0.00 57.63 29,276.00 0.1 51-000-65-00-5804 OPERATING SUPPLIES 1, 181.00 15,720.20 44, 000.00 35.7 51-000-65-00-5808 POSTAGE & SHIPPING 2, 406.05 5, 999.34 11,700.00 51 .2 51-000-65-00-5809 PRINTING & COPYING 140.00 1,223.00 5,000.00 24 .4 51-000-65-00-5810 PUBLISHING & ADVERTISING 0.00 0.00 1,000.00 0.0 51-000-65-00-5812 GASOLINE 582.92 5,064.60 7,200.00 70.3 P31 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 32 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL o ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES OPERATIONS 51-000-65-00-5815 HAND TOOLS 0.00 86.00 1,000.00 8. 6 51-000-65-00-5817 GRAVEL 0.00 462.12 5,000.00 9.2 51-000-65-00-5819 CHLORINE 0.00 0.00 0.00 0.0 51-000-65-00-5820 CHEMICALS 923.55 1,961 .31 27,232.00 7 .2 51-000-65-00-5821 CATHODIC PROTECTION 0.00 0.00 2, 500.00 0.0 51-000-65-00-5822 WATER SAMPLES 370.00 3,143.00 12,000.00 26.1 TOTAL OPERATIONS 5, 603.52 33,717.20 145, 908.00 23.1 RETIREMENT 51-000-72-00-6500 IMRF PARTICIPANTS 1,849.22 11, 106.51 24, 606.00 45. 1 51-000-72-00-6501 SOCIAL SECURITY & MEDICARE 1, 491.28 9,034.97 19,788.00 45.6 TOTAL RETIREMENT 3,340.50 20,141 .48 44,394 .00 45.3 CAPITAL OUTLAY 51-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 154 .71 1,247.21 4, 000.00 31.1 51-000-75-00-7004 SAFETY EQUIPMENT 45.59 274.00 2,000.00 13.7 51-000-75-00-7506 METER READERS 6,458.45 8,169.95 10,320.00 79.1 51-000-75-00-7507 HYDRANT REPLACEMENT 0.00 2,854 .00 4,000.00 71.3 51-000-75-00-7508 METERS & PARTS 87.39 58, 637.53 130,000.00 45.1 TOTAL CAPITAL OUTLAY 6,746.14 71, 182.69 150,320.00 47.3 OTHER 51-000-78-00-9005 REFUND 489.00 1,263.00 500.00 252. 6 51-000-78-00-9009 RESERVE 0.00 0.00 1, 386, 130.00 0.0 TOTAL OTHER 489.00 1,263.00 1,386,630.00 0.0 TRANSFERS 51-000-99-00-9901 TRANSFER TO GENERAL FUND 50,000.00 100,000.00 200,000.00 50.0 51-000-99-00-9930 TRANSFER TO WATER IMPRV FUND 17,500.00 35,000.00 70,000.00 50.0 51-000-99-00-9950 TRANSFER TO PW EQUIP CAPITAL 12,500.00 25,000.00 50,000.00 50.0 TOTAL TRANSFERS 80,000.00 160,000.00 320,000.00 50.0 P32 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 33 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: WATER OPERATIONS FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL EXPENSES: 129,208 .03 468,329.15 2,591,500.00 18 .0 TOTAL FUND REVENUES 193, 322.70 624,510.96 2, 591,500.00 24.0 TOTAL FUND EXPENSES 129,208 .03 468,329.15 2,591,500.00 18 .0 FUND SURPLUS (DEFICIT) 64, 114 .67 156, 181.81 0.00 100.0 P33 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 34 TIME: 15:12 :42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: SEWER MAINTENANCE FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CHARGES FOR SERVICES 52-000-42-00-4250 SEWER MAINTENANCE FEES 68, 447.00 200, 678.77 350,000.00 57.3 52-000-42-00-4251 SEWER CONNNECTION FEES 4,800.00 52, 850.00 96,800.00 54 .5 TOTAL CHARGES FOR SERVICES 73,247.00 253,528.77 446,800.00 56.7 INTEREST 52-000-46-00-4600 INVESTMENT INCOME 1,896.95 4,395.18 10,000.00 43.9 TOTAL INTEREST 1,896.95 4,395.18 10,000.00 43.9 TOTAL REVENUES: 75,143.95 257, 923.95 456,800.00 56.4 EXPENSES PERSONNEL SERVICES 52-000-50-00-5108 SALARIES-REGULAR 7, 534.40 46,263.36 119,254 .00 38.7 52-000-50-00-5136 PART TIME 0.00 0.00 5,000.00 0.0 52-000-50-00-5137 SALARIES-OVERTIME 453.98 3, 376. 64 12,000.00 28.1 TOTAL PERSONNEL SERVICES 7, 988.38 49, 640.00 136,254 .00 36.4 CONTRACTUAL SERVICES 52-000-62-00-5401 CONTRACTUAL SERVICES 50.00 100.00 2, 000.00 5.0 52-000-62-00-5408 MAINTENANCE-EQUIPMENT 914.63 1,175.25 8,500.00 13.8 52-000-62-00-5409 MAINTENANCE-VEHICLES 0.00 0.00 5,000.00 0.0 52-000-62-00-5419 MAINTENANCE-SANITARY SEWER 0.00 5,750.39 13,000.00 44 .2 52-000-62-00-5421 WEARING APPAREL 1,075.74 1, 174 .40 4,500.00 26.0 52-000-62-00-5422 LIFT STATION MAINTENANCE 5,611 .20 11,833.89 15,000.00 78 .8 52-000-62-00-5434 RENTAL - EQUIPMENT 0.00 0.00 1,000.00 0.0 52-000-62-00-5435 ELECTRICITY 135.22 135.22 8,900.00 1.5 52-000-62-00-5438 CELLULAR TELEPHONE 107.48 427.75 2,500.00 17.1 TOTAL CONTRACTUAL SERVICES 7, 894.27 20,596.90 60, 400.00 34 .1 PROFESSIONAL DEVELOPMENT P34 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 35 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: SEWER MAINTENANCE FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES PROFESSIONAL DEVELOPMENT 52-000-64-00-5604 TRAINING & CONFERENCES 0.00 0.00 1, 900.00 0.0 TOTAL PROFESSIONAL DEVELOPMENT 0.00 0.00 1, 900.00 0.0 OPERATIONS 52-000-65-00-5800 CONTINGENCIES 0.00 0.00 10, 000.00 0.0 52-000-65-00-5802 OFFICE SUPPLIES 9.98 346.10 2,000.00 17.3 52-000-65-00-5804 OPERATING SUPPLIES 2.40 553. 61 8, 000.00 6. 9 52-000-65-00-5805 SHOP SUPPLIES 61.63 513.97 2, 500.00 20.5 52-000-65-00-5812 GASOLINE 0.00 6, 554.05 5, 900.00 111.0 52-000-65-00-5815 HAND TOOLS 0.00 59.74 1,000.00 5.9 52-000-65-00-5817 GRAVEL 0.00 0.00 2, 000.00 0.0 52-000-65-00-5823 SEWER CHEMICALS 0.00 0.00 15,000.00 0.0 TOTAL OPERATIONS 74.01 8,027 .47 46, 400.00 17.3 RETIREMENT 52-000-72-00-6500 IMRF PARTICIPANTS 804 .44 4,784 .92 13,217.00 36.2 52-000-72-00-6501 SOCIAL SECURITY & MEDICARE 611.12 3, 635.07 10, 423.00 34.8 TOTAL RETIREMENT 1,415.56 8,419.99 23, 640.00 35.6 CAPITAL OUTLAY 52-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 101.83 431.73 2, 000.00 21.5 52-000-75-00-7003 OFFICE EQUIPMENT 0.00 2, 971.38 3,000.00 99.0 52-000-75-00-7004 SAFETY EQUIPMENT 0.00 23.16 2,000.00 1.1 TOTAL CAPITAL OUTLAY 101.83 3,426.27 7,000.00 48.9 OTHER 52-000-78-00-9009 RESERVE 0.00 0.00 81, 206.00 0.0 TOTAL OTHER 0.00 0.00 81, 206.00 0.0 TRANSFERS P35 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 36 TIME: 15: 12: 42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: SEWER MAINTENANCE FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES TRANSFERS 52-000-99-00-9901 TRANSFER TO GENERAL FUND 17, 500.00 35,000.00 70,000.00 50.0 52-000-99-00-9925 TRANSFER TO SAN SEWER IMPROV. 0.00 0.00 0.00 0.0 52-000-99-00-9950 TRANSFER TO PW EQUIP CAPITAL 7, 500.00 15,000.00 30, 000.00 50.0 52-000-99-00-9965 TRANSFER TO DEBT SERVICE FUND 0.00 0.00 0.00 0.0 TOTAL TRANSFERS 25,000.00 50,000.00 100,000.00 50.0 TOTAL EXPENSES: 42,474.05 140,110.63 456, 800.00 30.6 TOTAL FUND REVENUES 75,143.95 257, 923.95 456, 800.00 56.4 TOTAL FUND EXPENSES 42,474 .05 140, 110.63 456,800.00 30.6 FUND SURPLUS (DEFICIT) 32, 669. 90 117, 813.32 0.00 100.0 P36 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 37 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: LAND CASH FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER 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 626,812.00 110.7 72-000-40-00-4700 LAND CASH - OTHER 0.00 6, 103. 60 0.00 100.0 TOTAL CARRY OVER 0.00 700,015.60 626,812.00 111.6 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 1,071.00 5, 355.00 20.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 0.00 0.00 0.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 2,038.00 8, 190.00 15,380.00 53.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 6, 352.00 0.00 100.0 72-000-47-00-4708 FOX HIGHLANDS DUPLEX-LAND CASH 0.00 14, 160.00 0.00 100.0 72-000-47-00-4709 SUNFLOWER-LAND CASH 1, 083.00 13, 070.00 7, 220.00 181.0 72-000-47-00-4710 CIMMERON RIDGE-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4711 BLACKBERRY CREEK-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4712 RIVER'S EDGE-LAND CASH 1,342.00 13, 420.00 20, 130.00 66.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 0.00 7, 030.00 0.0 72-000-47-00-4717 KYLN'S CROSSING-LAND CASH 0.00 2,493.00 0.00 100.0 72-000-47-00-4718 FOXFIELD(2ND EDITION)-LAND CAS 0.00 0.00 0.00 0.0 72-000-47-00-4719 WILDWOOD-LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4720 HEARTLAND-LAND CASH 0.00 15, 000.00 0.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 1, 662.00 36,564.00 66, 480.00 55.0 72-000-47-00-4723 HEARTLAND CIRCLE-LAND CASH 4, 000.00 10, 000.00 60,000.00 16. 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 100,000.00 0.0 72-000-47-00-4726 RESERVE @ THE FOX LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4727 GRAND RESERVE-LAND CASH 33, 447.34 45, 644.84 220, 500.00 20.7 72-000-47-00-4728 BRISBEN RESERVE-LAND CASH 0.00 0.00 0.00 0.0 P37 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 38 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: LAND CASH FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CONTRIBUTIONS 72-000-47-00-4729 SCHOOLS-LAND CASH 0.00 0.00 0.00 0.0 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 10, 620.00 0.00 100.0 72-000-47-00-4732 RAINTREE VILLAGE LAND CASH 0.00 0.00 0.00 0.0 72-000-47-00-4734 WHISPERING MEADOWS (K. HILL) 0.00 0.00 56,160.00 0.0 72-000-47-00-4735 PRAIRIE MEADOWS (MENARD RES) 0.00 0.00 286, 230.00 0.0 72-000-47-00-4736 CORNERSTONE 0.00 0.00 0.00 0.0 TOTAL CONTRIBUTIONS 43, 572.34 176, 584.84 918, 485.00 19.2 TOTAL REVENUES: 43, 572.34 876, 600.44 1,545,297.00 56.7 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 3, 550.00 40,000.00 8.8 72-000-75-00-7300 GREENBRIAR 0.00 0.00 6,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 9, 058.25 102, 526. 66 130, 000.00 78.8 72-000-75-00-7303 FOX HIGHLANDS 0.00 0.00 0.00 0.0 72-000-75-00-7304 SUNFLOWER 0.00 0.00 90, 000.00 0.0 72-000-75-00-7305 CIMMERON RIDGE 0.00 0.00 0.00 0.0 72-000-75-00-7306 BLACKBERRY CREEK 0.00 0.00 0.00 0.0 72-000-75-00-7307 RIVERS EDGE 71,834.48 79, 985.67 160,000.00 49.9 72-000-75-00-7308 WOODWORTH 0.00 0.00 0.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 P38 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 39 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: LAND CASH FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES CAPITAL OUTLAY 72-000-75-00-7311 CANNONBALL ESTATES/KYLIN 0.00 10,700.79 97,000.00 11.0 72-000-75-00-7312 FOXFIELD 2ND EDITION 0.00 0.00 0.00 0.0 72-000-75-00-7313 HEARTLAND 0.00 0.00 0.00 0.0 72-000-75-00-7314 PRAIRIE GARDENS 0.00 0.00 0.00 0.0 72-000-75-00-7315 BRISBEN 0.00 0.00 0.00 0.0 72-000-75-00-7316 KYLN'S RIDGE 0.00 0.00 0.00 0.0 72-000-75-00-7317 HEARTLAND CIRCLE 0.00 0.00 5,000.00 0.0 72-000-75-00-7318 THE RESERVE 0.00 0.00 0.00 0.0 72-000-75-00-7319 THE HIGHLANDS 0.00 0.00 0.00 0.0 72-000-75-00-7320 BLACKHAWK 0.00 0.00 0.00 0.0 72-000-75-00-7321 CANNBALL HILL/KYLYN'S 0.00 0.00 0.00 0.0 72-000-75-00-7322 BEECHER 0.00 0.00 0.00 0.0 72-000-75-00-7323 BLACKHAWK 0.00 0.00 0.00 0.0 72-000-75-00-7324 TOWN SQUARE 0.00 0.00 10,000.00 0.0 72-000-75-00-7325 VAN EMMON 0.00 0.00 0.00 0.0 72-000-75-00-7326 CORLANDS 0.00 0.00 5,000.00 0.0 72-000-75-00-7327 GRANDE RESERVE PARK DEV. 0.00 31, 476.38 220, 500.00 14 .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 0.00 993.75 55,000.00 1.8 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 0.00 0.00 0.0 72-000-75-00-7700 PARK BUILDING 0.00 0.00 0.00 0.0 TOTAL CAPITAL OUTLAY 80, 892.73 229,233.25 828,500.00 27.6 OTHER 72-000-78-00-9009 RESERVE 0.00 4,799.17 594,797.00 0.8 72-000-78-00-9010 BEECHER CONCESSION STAND 0.00 0.00 0.00 0.0 TOTAL OTHER 0.00 4,799.17 594,797.00 0.8 TRANSFERS 72-000-99-00-9955 TRANSFER TO PARKS/REC CAP FUND 0.00 0.00 22,000.00 0.0 72-000-99-00-9970 TRANSFER TO LAND ACQUISITION 25,000.00 50,000.00 100,000.00 50.0 TOTAL TRANSFERS 25,000.00 50,000.00 122,000.00 40.9 P39 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 40 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: LAND CASH FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL EXPENSES: 105,892.73 284,032.42 1,545,297 .00 18.3 TOTAL FUND REVENUES 43, 572.34 876, 600.44 1, 545,297.00 56.7 TOTAL FUND EXPENSES 105, 892.73 284,032. 42 1, 545, 297.00 18.3 FUND SURPLUS (DEFICIT) (62,320.39) 592, 568.02 0.00 100.0 P40 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 41 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: LAND ACQUISITION FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CARRY OVER 73-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 85, 982.00 0.0 73-000-40-00-4930 COLT FUNDING 0.00 0.00 100,000.00 0.0 TOTAL CARRY OVER 0.00 0.00 185, 982.00 0.0 TRANSFERS 73-000-49-00-4935 TRANSFER FROM LAND CASH 25,000.00 50,000.00 100,000.00 50.0 73-000-49-00-4937 TRANSFER FROM PARKS & REC 0.00 0.00 0.00 0.0 TOTAL TRANSFERS 25,000.00 50, 000.00 100,000.00 50.0 TOTAL REVENUES: 25,000.00 50, 000.00 285, 982.00 17.4 EXPENSES OTHER 73-000-65-00-5800 CONTINGENCY 0.00 0.00 285, 982.00 0.0 73-000-65-00-5805 WEST HYDRAULIC ACQUISITION 0.00 0.00 0.00 0.0 73-000-65-00-5808 GILBERT PARK ACQUISITION 0.00 0.00 0.00 0.0 TOTAL OTHER 0.00 0.00 285, 982.00 0.0 TOTAL FUND REVENUES 25,000.00 50,000.00 285, 982.00 17.4 TOTAL FUND EXPENSES 0.00 0.00 285, 982.00 0.0 FUND SURPLUS (DEFICIT) 25,000.00 50,000.00 0.00 100.0 P41 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 42 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES CARRY OVER 79-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 15,000.00 0.0 TOTAL CARRY OVER 0.00 0.00 15,000.00 0.0 CHARGES FOR SERVICES 79-000-42-00-4270 FEES FOR PROGRAMS 9, 939.45 70, 160.86 93,000.00 75.4 79-000-42-00-4280 CONCESSIONS 112.00 8,825.25 35,000.00 25.2 79-000-42-00-4281 BEECHER BLDG DEPOSITS 400.00 2,495.00 5,000.00 49. 9 79-000-42-00-4282 FARMERS MARKET 35.00 955.00 500.00 191.0 79-000-42-00-4285 VENDING MACHINE INCOME 73.32 440.47 450.00 97.8 79-000-42-00-4286 RENTAL INCOME 1, 200.00 2,805.00 2,000.00 140.2 79-000-42-00-4287 RENTAL INCOME - SHELTERS 15.00 560.00 300.00 186.6 79-000-42-00-4288 GOLF OUTING REVENUE 0.00 36,251.00 25,000.00 145.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 11,774.77 122,492.58 161,250.00 75.9 MISCELLANEOUS 79-000-44-00-4400 DONATIONS 750.00 7,770.00 12,000.00 64.7 79-000-44-00-4404 TREE DONATIONS 0.00 300.00 1,200.00 25.0 79-000-44-00-4490 MISCELLANEOUS INCOME 0.00 0.00 0.00 0.0 TOTAL MISCELLANEOUS 750.00 8,070.00 13, 200.00 61.1 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 0.00 3, 500.00 0.0 TOTAL INTERGOVERNMENTAL 0.00 0.00 3, 500.00 0.0 INTEREST 79-000-46-00-4600 INVESTMENT INCOME 0.00 0.00 1, 500.00 0.0 TOTAL INTEREST 0.00 0.00 1, 500.00 0.0 P42 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 43 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TRANSFERS 79-000-49-00-4901 TRANSFER FROM GENERAL FUND 63,041.33 378,248.00 756,496.00 50.0 TOTAL TRANSFERS 63,041.33 378,248.00 756, 496.00 50.0 TOTAL REVENUES: 75,566.10 508,810.58 950, 946.00 53.5 PARKS EXPENSES PERSONNAL SERVICES 79-610-50-00-5107 SALARIES-EMPLOYEES 17,018. 67 117,727.33 256, 926.00 45.8 79-610-50-00-5136 SALARIES - PART-TIME 638.00 35,813.13 45,000.00 79.5 79-610-50-00-5137 SALARIES - OVERTIME 628.64 3, 518.85 8,000.00 43.9 TOTAL PERSONNAL SERVICES 18,285.31 157,059.31 309, 926.00 50.6 PROFESSIONAL SERVICES 79-610-61-00-5320 MASTER PLAN 0.00 0.00 10,000.00 0.0 TOTAL PROFESSIONAL SERVICES 0.00 0.00 10,000.00 0.0 CONTRACTUAL SERVICES 79-610-62-00-5405 PARK CONTRACTUAL 3,060.29 6, 596.22 10,000.00 65.9 79-610-62-00-5408 MAINTENANCE-EQUIPMENT 300.04 3, 682.02 5,000.00 73.6 79-610-62-00-5417 MAINTENANCE-PARKS 4,750.49 21,892. 65 30, 000.00 72.9 79-610-62-00-5421 WEARING APPAREL 5.99 695.75 5,500.00 12.6 79-610-62-00-5425 ILLINOIS FIRST GRANT 0.00 0.00 0.00 0.0 79-610-62-00-5434 RENTAL-EQUIPMENT 110.00 368.73 1, 500.00 24 .5 79-610-62-00-5438 CELLULAR TELEPHONE 0.00 408.63 5,000.00 8.1 79-610-62-00-5440 LAND DEVELOPER 0.00 7,057.97 35,000.00 20.1 79-610-62-00-5445 LEGAL EXPENSES 0.00 1,097.50 5,000.00 21.9 TOTAL CONTRACTUAL SERVICES 8,226.81 41,799.47 97,000.00 43.0 PROFESSIONAL DEVELOPMENT P43 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 44 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL o ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED PARKS EXPENSES PROFESSIONAL DEVELOPMENT 79-610-64-00-5602 PROFESSIONAL GROWTH/SUBSCRPT 0.00 115.00 2,500.00 4.6 79-610-64-00-5605 TRAVEL EXPENSE 228.86 1,034 .82 2,000.00 51.7 79-610-64-00-5612 CONTINUING EDUCATION 0.00 958. 60 3,000.00 31.9 TOTAL PROFESSIONAL DEVELOPMENT 228.86 2, 108.42 7,500.00 28.1 OPERATIONS 79-610-65-00-5800 CONTINGENCIES 0.00 0.00 0.00 0.0 79-610-65-00-5802 OFFICE SUPPLIES 11.00 11.00 1,000.00 1.1 79-610-65-00-5804 OPERATING SUPPLIES 1,180.50 5, 442.59 20,000.00 27.2 79-610-65-00-5812 GASOLINE 0.00 0.00 3,000.00 0.0 79-610-65-00-5815 HAND TOOLS 133.87 551.45 2,000.00 27.5 79-610-65-00-5824 CHRISTMAS DECORATIONS 0.00 0.00 5,000.00 0.0 79-610-65-00-5825 PUBLIC DECORATION 0.00 75.47 2,000.00 3.7 TOTAL OPERATIONS 1, 325.37 6,080.51 33, 000.00 18.4 RETIREMENT 79-610-72-00-6500 IMRF PARTICIPANTS 1,777.08 12, 132.09 26, 678.00 45.4 79-610-72-00-6501 SOCIAL SECURITY/MEDICARE 1,398.82 12,022.94 23,709.00 50.7 TOTAL RETIREMENT 3, 175.90 24,155.03 50, 387.00 47.9 CAPITAL OUTLAY 79-610-75-00-7003 OFFICE EQUIPMENT 0.00 0.00 2,000.00 0.0 79-610-75-00-7701 FLOWERS/TREES 795.27 4, 175.93 5,500.00 75.9 79-610-75-00-7705 TRANSFER TO LAND ACQUISITION 0.00 0.00 0.00 0.0 TOTAL CAPITAL OUTLAY 795.27 4, 175.93 7, 500.00 55.6 TOTAL EXPENSES: PARKS 32,037.52 235, 378.67 515, 313.00 45.6 RECREATION EXPENSES P44 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 45 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED RECREATION PERSONNEL SERVICES 79-650-50-00-5107 EMPLOYEE SALARIES 15,265.18 100,025.35 195, 471.00 51.1 79-650-50-00-5108 CONCESSION STAFF 96.88 4,216.16 16,500.00 25.5 79-650-50-00-5150 SALARIES-INSTRUCTOR CONTRACTUA 6, 767.50 36, 624 .73 35,000.00 104 .6 79-650-50-00-5155 SALARIES-RECORDING SECRETARY 275.00 1,140.00 3,000.00 38 .0 79-650-50-00-5156 SALARIES-CUSTODIAL 0.00 0.00 0.00 0.0 TOTAL PERSONNEL SERVICES 22, 404.56 142,006.24 249, 971.00 56.8 PROFESSIONAL SERVICES 79-650-61-00-5321 RECREATION RESEARCH 0.00 0.00 1,000.00 0.0 TOTAL PROFESSIONAL SERVICES 0.00 0.00 1,000.00 0.0 CONTRACTUAL SERVICES 79-650-62-00-5408 MAINTENANCE SUPPLIES 117.01 2,089.77 6,500.00 32.1 79-650-62-00-5409 MAINTENANCE-VEHICLES 0.00 0.00 1,000.00 0.0 79-650-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 863.65 2,747 .03 2,500.00 109.8 79-650-62-00-5426 YOUTH SERVICES GRANT EXPENSES 0.00 0.00 3,000.00 0.0 79-650-62-00-5437 TELEPHONE/INTERNET 0.00 460.05 1,500.00 30.6 79-650-62-00-5438 CELLULAR TELEPHONE 0.00 425.28 3,500.00 12.1 79-650-62-00-5445 PORTABLE TOILETS 465.21 2, 648.06 5,000.00 52.9 79-650-62-00-5603 PUBLISHING/ADVERTISING 142.40 13, 117.67 24,000.00 54.6 79-650-62-00-5605 BOOKS/PUBLICATIONS 0.00 84 .50 750.00 11 .2 79-650-62-00-5606 BEECHER DEPOSIT REFUND 1,870.00 4,764 .00 5,000.00 95.2 TOTAL CONTRACTUAL SERVICES 3, 458.27 26,336.36 52,750.00 49.9 PROFESSIONAL DEVELOPMENT 79-650-64-00-5600 DUES 60.00 172.502,500.00 6.9 79-650-64-00-5602 PROFESSIONAL GROWTH/SUBSCRIPT 0.00 260.00 7,300.00 3.5 79-650-64-00-5605 TRAVEL EXPENSE 0.00 525.93 2,000.00 26.2 79-650-64-00-5614 TOURNAMENT FEES 0.00 0.00 0.00 0.0 TOTAL PROFESSIONAL DEVELOPMENT 60.00 958.43 11, 800.00 8.1 OPERATIONS P45 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 46 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: PARKS & RECREATION FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER 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 0.00 2,048.02 6,000.00 34.1 79-650-65-00-5803 PROGRAM EXPENSES 528.12 19,002.94 29,300.00 64.8 79-650-65-00-5804 OPERATING SUPPLIES 0.00 76.00 4,000.00 1.9 79-650-65-00-5805 RECREATION EQUIPMENT 322.20 1,405.77 2, 500.00 56.2 79-650-65-00-5808 POSTAGE & SHIPPING 771.26 2,736.10 5,000.00 54 .7 79-650-65-00-5812 GASOLINE 78.91 568.51 800.00 71.0 79-650-65-00-5826 MILEAGE 129.34 238.77 750.00 31.8 79-650-65-00-5827 GOLF OUTING EXPENSES 0.00 19,166.05 15,000.00 127.7 79-650-65-00-5828 CONCESSIONS 25.40 8,835.82 9,800.00 90.1 79-650-65-00-5830 YOUTH/SPECIAL EVENTS 0.00 0.00 0.00 0.0 79-650-65-00-5831 DAY TRIP EXPENSES 0.00 0.00 0.00 0.0 79-650-65-00-5840 SCHOLARSHIPS 0.00 170.00 1,500.00 11.3 79-650-65-00-5841 PROGRAM REFUND 944.00 3, 630.53 4, 500.00 80.6 TOTAL OPERATIONS 2,799.23 57,878.51 79, 150.00 73.1 RETIREMENT 79-650-72-00-6500 IMRF PARTICIPANTS 1, 416.06 9, 177.22 18,101.00 50.7 79-650-72-00-6501 SOCIAL SECURITY/MEDICARE 1, 672.72 9,751.55 17,861.00 54.5 TOTAL RETIREMENT 3,088.78 18, 928.77 35, 962.00 52.6 CAPITAL OUTLAY 79-650-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 2,167.80 5,000.00 43.3 TOTAL CAPITAL OUTLAY 0.00 2, 167.80 5,000.00 43.3 TOTAL EXPENSES: RECREATION 31, 810.84 248,276.11 435, 633.00 56.9 TOTAL FUND REVENUES 75, 566.10 508,810.58 950, 946.00 53.5 TOTAL FUND EXPENSES 63, 848.36 483, 654 .78 950, 946.00 50.8 FUND SURPLUS (DEFICIT) 11,717.74 25, 155.80 0.00 100.0 P46 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 47 I TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: LIBRARY FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES TAXES 82-000-40-00-3997 CARRY OVER DEVELOPMENT FEES 0.00 0.00 100,000.00 0.0 82-000-40-00-3998 CARRY OVER-MEMORIALS 0.00 0.00 5, 000.00 0.0 82-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 0.00 0.0 82-000-40-00-4000 REAL ESTATE TAXES 117,746.77 272,609.75 308,353.00 88.4 82-000-40-00-4010 PERSONAL PROPERTY TAX 0.00 1,324 .94 2, 500.00 52.9 82-000-40-00-4015 TRANSFER FROM GENERAL FUND 0.00 0.00 19,811.00 0.0 TOTAL TAXES 117,746.77 273, 934.69 435, 664.00 62.8 CHARGES FOR SERVICES 82-000-42-00-4211 DEVELOPMENT FEES - BUILDING 5, 900.00 24, 125.00 20,000.00 120. 6 82-000-42-00-4215 DEVELOPMENT FEES-BOOKS 5, 900.00 24,125.00 20,000.00 120.6 82-000-42-00-4260 COPY FEES 89.35 558.70 900.00 62.0 82-000-42-00-4261 LIBRARY SUBSCRIPTION CARDS 400.00 5,400.00 8,000.00 67.5 82-000-42-00-4286 RENTAL INCOME 73.00 452 .00 1,000.00 45.2 TOTAL CHARGES FOR SERVICES 12,362.35 54, 660.70 49, 900.00 109.5 FINES 82-000-43-00-4330 LIBRARY FINES 397.20 1, 595.15 3, 000.00 53.1 TOTAL FINES 397.20 1, 595.15 3, 000.00 53.1 MISCELLANEOUS 82-000-44-00-4432 SALE OF BOOKS 135.99 624.92 500.00 124.9 82-000-44-00-4450 MEMORIALS 25.00 1,343.60 1,500.00 89.5 TOTAL MISCELLANEOUS 160.99 1, 968.52 2,000.00 98.4 INTERGOVERNMENTAL 82-000-45-00-4560 LIBRARY PER CAPITA GRANT 0.00 0.00 7,700.00 0.0 TOTAL INTERGOVERNMENTAL 0.00 0.00 7,700.00 0.0 INTEREST P47 • DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 48 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: LIBRARY FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES INTEREST 82-000-46-00-4600 INVESTMENT INCOME 0.00 741.92 1, 500.00 49.4 82-000-46-00-4601 INVESTMENT INCOME-BLDG 0.00 0.00 1,250.00 0.0 TOTAL INTEREST 0.00 741.92 2,750.00 26.9 TOTAL REVENUES: 130, 667.31 332, 900.98 501,014 .00 66.4 EXPENSES PERSONNEL SERVICES 82-000-50-00-5107 SALARIES-EMPLOYEES 10, 941.84 68, 997.36 180,000.00 38.3 82-000-50-00-5203 GROUP HEALTH INSURANCE 0.00 4, 566.16 30,000.00 15.2 82-000-50-00-5204 GROUP LIFE INSURANCE 0.00 163.26 1,500.00 10.8 82-000-50-00-5205 DENTAL & VISION ASSISTANCE 218.00 1,772.42 3,500.00 50.6 TOTAL PERSONNEL SERVICES 11,159.84 75, 499.20 215,000.00 35.1 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 1,400.00 45.2 82-000-61-00-5323 ATTORNEY 0.00 0.00 3,000.00 0.0 TOTAL PROFESSIONAL SERVICES 0.00 633.00 4,400.00 14 .3 CONTRACTUAL SERVICES 82-000-62-00-5401 CONTRACT SERVICES 50.00 100.00 0.00 (100.0) 82-000-62-00-5407 MAINTENANCE-BLDG/JANITORIAL 290.00 1, 670.00 5,000.00 33.4 82-000-62-00-5410 MAINTENANCE-OFFICE EQUIPMENT 251.46 1, 145.13 3,000.00 38.1 82-000-62-00-5412 MAINTENANCE-PHOTOCOPIER 0.00 59.05 1,000.00 5.9 82-000-62-00-5435 ELECTRICITY 0.00 105.94 2, 500.00 4 .2 82-000-62-00-5436 TELEPHONE 44.18 487.92 1,700.00 28.7 TOTAL CONTRACTUAL SERVICES 635.64 3, 568.04 13,200.00 27.0 PROFESSIONAL DEVELOPMENT P48 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 49 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: LIBRARY FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES PROFESSIONAL DEVELOPMENT 82-000-64-00-5603 SUBSCRIPTIONS 133.94 244 .04 2,500.00 9.7 82-000-64-00-5604 TRAINING & CONFERENCES 0.00 70.00 1, 000.00 7.0 82-000-64-00-5607 PUBLIC RELATIONS 0.00 261 .30 650.00 40.2 82-000-64-00-5616 EMPLOYEE RECOGNITION 0.00 83.99 2,000.00 4.1 TOTAL PROFESSIONAL DEVELOPMENT 133.94 659.33 6, 150.00 10.7 OPERATIONS 82-000-65-00-5800 CONTINGENCIES 0.00 102.25 4,314.00 2.3 82-000-65-00-5806 LIBRARY SUPPLIES 292 .59 3,019.96 7,000.00 43.1 82-000-65-00-5807 CUSTODIAL SUPPLIES 268.11 933.78 4,000.00 23.3 82-000-65-00-5808 POSTAGE & SHIPPING 0.00 111 .00 900.00 12 .3 82-000-65-00-5810 PUBLISHING & ADVERTISING 0.00 38.10 300.00 12.7 82-000-65-00-5826 MILEAGE 75.00 206.25 600.00 34 .3 82-000-65-00-5832 VIDEOS 22.30 113.53 5, 500.00 2.0 82-000-65-00-5833 ALARM MONITORING 0.00 509.79 900.00 56.6 82-000-65-00-5834 LIBRARY PROGRAMMING 489.11 3,050. 90 9,000.00 33.8 82-000-65-00-5835 LIBRARY BOARD EXPENSES 0.00 0.00 500.00 0.0 82-000-65-00-5836 BOOKS-ADULT 0.00 1,272.10 10,000.00 12 .7 82-000-65-00-5837 BOOKS-JUVENILE 1,011.53 5,284.86 10,000.00 52.8 82-000-65-00-5838 BOOKS-AUDIO 0.00 1,414 .07 6,000.00 23.5 82-000-65-00-5839 BOOKS-REFERENCE 0.00 2, 110.46 12,000.00 17.5 82-000-65-00-5840 BOOKS-DEVELOPMENT FEE (1,011.07) 16, 928.81 70,000.00 24 .1 82-000-65-00-5841 MEMORIALS/GIFTS 553.90 1,252.22 6, 500.00 19.2 82-000-65-00-5842 BLDG-DEVELOPMENT FEES 0.00 4,250.00 71,250.00 5.9 TOTAL OPERATIONS 1,701.47 40, 598.08 218,764.00 18.5 RETIREMENT 82-000-72-00-6500 IMRF PARTICPANTS 661 .24 4,279.85 8,000.00 53.4 82-000-72-00-6501 SOCIAL SECURITY/MEDICARE 837.02 5,278.16 13, 500.00 39.0 TOTAL RETIREMENT 1, 498.26 9, 558.01 21,500.00 44.4 CAPITAL OUTLAY P49 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 50 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F—YR: 05 ID: GL470002.WOW FUND: LIBRARY FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL o ACCOUNT OCTOBER YEAR—TO—DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED EXPENSES CAPITAL OUTLAY 82-000-75-00-7002 COMPUTER EQUIP & SOFTWARE 0.00 0.00 0.00 0.0 82-000-75-00-7003 AUTOMATION 133.90 3,806.59 22,000.00 17.3 82-000-75-00-7703 BUILDING EXPANSION 0.00 0.00 0.00 0.0 TOTAL CAPITAL OUTLAY 133.90 3,806.59 22,000.00 17.3 TOTAL EXPENSES: 15,263.05 134, 322.25 501,014 .00 26.8 TOTAL FUND REVENUES 130, 667.31 332, 900.98 501,014.00 66.4 TOTAL FUND EXPENSES 15,263.05 134, 322.25 501,014 .00 26.8 FUND SURPLUS (DEFICIT) 115,404 .26 198,578 .73 0.00 100.0 P50 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 51 TIME: 15: 12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.W0W FUND: FOX INDUSTRIAL FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED REVENUES TAXES 85-000-40-00-3999 CARRY OVER BALANCE 0.00 0.00 46,000.00 0.0 85-000-40-00-4090 TIF REVENUES 10,161 .64 31, 958.31 35,000.00 91.3 TOTAL TAXES 10, 161.64 31, 958.31 81,000.00 39.4 INTEREST 85-000-46-00-4600 INVESTMENT INCOME 0.00 0.00 1,000.00 0.0 TOTAL INTEREST 0.00 0.00 1,000.00 0.0 TRANSFERS 85-000-49-00-4905 TRANSFER FROM MFT FUND 0.00 0.00 0.00 0.0 TOTAL TRANSFERS 0.00 0.00 0.00 0.0 TOTAL REVENUES: 10,161 .64 31, 958.31 82,000.00 38.9 EXPENSES DEBT SERVICES 85-000-66-00-6021 FOX IND BOND-PRINCIPAL PMT 0.00 0.00 55,000.00 0.0 85-000-66-00-6022 FOX IND BOND-INT PAYMENT 0.00 12,146.25 24,293.00 49.9 TOTAL DEBT SERVICES 0.00 12, 146.25 79,293.00 15.3 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 2,493.00 19.5 TOTAL OTHER 0.00 702.25 2,707.00 25.9 P51 DATE: 12/13/2004 UNITED CITY OF YORKVILLE PAGE: 52 TIME: 15:12:42 DETAILED REVENUE & EXPENSE REPORT F-YR: 05 ID: GL470002.WOW FUND: FOX INDUSTRIAL FOR 6 PERIODS ENDING OCTOBER 31, 2004 FISCAL FISCAL % ACCOUNT OCTOBER YEAR-TO-DATE YEAR COLLECTED/ NUMBER DESCRIPTION ACTUAL ACTUAL BUDGET EXPENDED TOTAL EXPENSES: 0.00 12,848.50 82, 000.00 15. 6 TOTAL FUND REVENUES 10, 161. 64 31, 958.31 82,000.00 38.9 TOTAL FUND EXPENSES 0.00 12,848.50 82,000.00 15. 6 FUND SURPLUS (DEFICIT) 10,161.64 19,109.81 0.00 100.0 P52